VBA coding- generate a series of column data

[Legacy 384751]

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