I trying to solve for Head (hTotal and Ht are in essence the same thing). I start by taking a guess at hTotal and going thru several steps to solve for Ht. The exact solution occurs when hTotal = Ht.
Thanks for the response guys. The solve block doesn't work. At least, I can't figure out how to get it to work. I've tried everything short of re-writing the worksheet. The problem with using a solve block is that all non-iterative elements have to be located above the Given statement...
Take a look at the attached worksheet. The only two values changing are highlighted. To solve this problem takes an iterative process. First guessing the first highlighted value and back-checking against the second highlighted value. The solution occurs at the point where the two values are...