VBA coding- generate a series of column data

alsckd333

New Member
Joined
Sep 23, 2016
Messages
1
Hello everyone,

I am in need of your experts' assistance to teach me how to use the VBA program efficiently. Currently, I am trying to create a simple hydrograph with a specific condition: time of peak will be at the 1/4 of total time. My base data will be the USGS Dimensionless Unit Hydrograph, fyi.

My question on here is, I am trying to program a code so that I can automatically generate a column of data with a specific condition. I would like to create a series of discharge data by entering in one variable (peak flow value). In doing so, the peak value will automatically position itself at the 1/4 of total time, while the rising limb and falling limb will follow the shape of USGS Unit Hydrograph (+ skewed bell curve). I am assuming this is an interpolation programming, but I am just not knowledgeable enough about programming to even know where to begin programming this condition...

Hope this explains what my intention is here! Looking forward to hear back from anyone who can help me out !


I really appreciate the help.


Best regards,
Dan
 

Some videos you may like

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes

Watch MrExcel Video

Forum statistics

Threads
1,095,719
Messages
5,446,127
Members
405,383
Latest member
mccordscvs

This Week's Hot Topics

Top