alsckd333
09-23-2016, 09:36 AM
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 (This is to use the shape of the unit hydrograph).
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 with perhaps cubic spline(?), but I am just not knowledgeable enough about programming to even know the degree of programming that i am asking for...
For example, if Qp=2000 cfs and total duration=40 minutes, I will have a time series column with increment of 1 min, and the interpolated discharge values will be generated by multiplying the peak value with the unit hydrograph's x values (Q/Qp), where it will reach 2000 cfs at 10 minutes, and will be zero or close to zero at 40 mins.
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
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 (This is to use the shape of the unit hydrograph).
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 with perhaps cubic spline(?), but I am just not knowledgeable enough about programming to even know the degree of programming that i am asking for...
For example, if Qp=2000 cfs and total duration=40 minutes, I will have a time series column with increment of 1 min, and the interpolated discharge values will be generated by multiplying the peak value with the unit hydrograph's x values (Q/Qp), where it will reach 2000 cfs at 10 minutes, and will be zero or close to zero at 40 mins.
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