#### CWEngineer

##### Civil/Environmental

Hi,

I am trying to setup the attached excel file to find two values (Qd and K2, which I know the answers to be 665.1 and 122.3, respectively), that will give me a Teff = 2.75 s and Beff = 15%. I have done some research and believe the "Goal Seek" function in excel might be able to do this but have not been able to figure it out.

Appreciate if you guys can give me some guidance on using the "Goal Seek" function for my situation.

Thanks

I am trying to setup the attached excel file to find two values (Qd and K2, which I know the answers to be 665.1 and 122.3, respectively), that will give me a Teff = 2.75 s and Beff = 15%. I have done some research and believe the "Goal Seek" function in excel might be able to do this but have not been able to figure it out.

Appreciate if you guys can give me some guidance on using the "Goal Seek" function for my situation.

Thanks