I would like recommendations for a method to develop a hydrograph for a subsurface drainage or filter system. The simpler, the better.
Specifically, I would like to be able to model the flow attentuation that occurs when rain falls onto an athletic field. The field would consist of say 12...
I have a workbook I have been building for a long time. One of the sheets is for user input, and I have all cells locked except those that receive the user input. The protection setting boxes to allow the user to select locked cells and to select unlocked cells are checked.
Today, for no...
I've come up with an Excel formula that will round a number to a user specified number of significant digits, as follows:
=ROUND(number,-(INT(LOG(number)+1-num_digits)))
Can someone please help me to code this into a user defined VBA function?
Such as Sigfig(number, num_digits)
I've tried...
I am somewhat new to VBA and feel that this should be simple, but I'm stumped. I want a macro that will copy a chart from sheet A to sheet B, then resize the chart. Essentially mirroring the chart from A to B.
The source data is the same each time I use the sheet (or else this would be a...
