Goal seek using macro

promise899

New Member
Joined
Feb 18, 2022
Messages
9
Office Version
  1. 2016
Platform
  1. Windows
I have transposed a formula that has the same variable on both sides of the equation, thus producing two separate equations that equal each other.

For the first iteration, I find f value using goal seek tool.

each iteration(2,3,4,5) I want to use goal seek tools in order to find f values. After finding f value I can find Cchezy and Vnew because it depends on f value as can be seen from excel sheet.

Iteration continues until V and Vnew value be equal. I think to use assing macro to button in order to use goal seek tool each times . But I cant find how to do it? Thank you.

soru1.xlsx
ABCDEF
10.015974<<--Value of fd=0.50m
2b=10.00m
3L.H.SR.H.SL.H.S-R.H.SJ=0.002
47.9120357.9116410.000394221ks=0.01mm
5
6θ=0.002
7V=0.10
8DH=1.818182
9Re=181818.2
10
11
12IterationV(m/s)fCchezyVnew(m/s)
1310.10.01670.091880.279196552
1420.279197
153
164
175
Sayfa1
Cell Formulas
RangeFormula
A4A4=1/SQRT(B1)
B4B4=-2*LOG10((F4*0.001/3.71/F8)+(2.51)/F9/SQRT(B1))
C4C4=A4-B4
F8F8=4*(F1*F2)/(2*F1+F2)
F9F9=(1000*F7*F8)/0.001
C13C13=B1
D13D13=SQRT(8*9.81/B1)
E13E13=D13*SQRT(0.25*F8*SIN(RADIANS(F6)))
B14B14=E13
 

Attachments

  • 1.jpg
    1.jpg
    81.5 KB · Views: 13

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

Forum statistics

Threads
1,212,927
Messages
6,110,703
Members
448,293
Latest member
jin kazuya

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top