I am doing repetitive calculations in excel on about 150 rows of data; the data is pressure measured over time. the equation i solve is:
h=w+(transducer depth+w)*w''/9.81
w is water level change which is WL1-WL2; WL1 is given
I match the solution with the data I collected, h using solver to change WL2 until the solution matches my measured data. sometimes solver doesn't work and returns a large number for WL2; then I manually change it until it matches. this is very time consuming and inefficient. is there a way to program in VB to accomplish this with or without solver? attached is an example file. i have a ton of files to dothanks
Bookmarks