How are the formulas connected in excel spreadsheet

Capture5.PNG

Can one of you, fine ladies or gentlemen, please translate this table in plain old math... I can't figure out how are they all connected...

Hi and welcome to the forum

Pictures are of little value. Honestly, no one wants to re-type your data to try and solve your issue. Additionally, we would only be guessing at how your data was structured, ie. formulas, formatting, etc.

Please attach a sample file that represents what you have. The structure of your attachment should be the same structure as your actual data. Any proprietary information should be changed.

Include in the attachment any code you're currently using (whether it works or not) and an "After" of what you wish the output to be.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

I see five sets of coefficients for the given polynomial, with labels that specify what x and y represent. In the first column, x represents lF and y represents lm. The second column appears to be the "inverse" function where x represents lm and y represents lF. And so on across the table. I assume those quantities/variables mean something to you.

Ok, thank you. I'm trying to figure out how is this calculator connected. There are two tabs, "Simulator" and "Calculation". I need to find out how the columns under G9 and K9 change when the input changes in C6, G6 and L6. I do well in programming buy haven't done excel. I see some if statements but can't seem to understand how the statements are connected. Thank you for your time

EDIT: I did some reading and I'm kinda getting the hang of it. I cant seem to find the G10 cell that gets referenced when I click on any of the G cells with a number in them. Any suggestions?

Jim, welcome to the forum

Thanks for the title change

cant seem to find the G10 cell that gets referenced when I click on any of the G cells with a number in them. Any suggestions?

Go into Excel options -> Advanced -> Display options for this worksheet -> be sure to check "display row and colum headers". That will bring back the column letters and row numbers so you can see them. Then you will notice that some of the row numbers are missing, indicating that they are hidden. Select the rows above and below the hidden row, right click, and select unhide https://support.office.com/en-us/art...4-dde8443579f8

That should make row 10 (including G10) visible.

Is that your question, or is there more to it?

It is hard to say what you are doing wrong, since you did not explain in any detail how you arrived at 36.73.

When I follow the calculation using the formula evaluate tool (https://support.office.com/en-us/art...6-A70AA409B8A7 ), it appears to be correct, and shows the intermediate steps to their full precision. That might be one tool to use to check your hand calculation against Excel's calculation.

I could not figure out a sequence of calculations that would get result in something near 36.7 for R148 (I do not that S148 is 36.8 -- perhaps you were checking S148's calculation instead????). I note that, all of my evaluations of the quadratic in R148 were less than 1, so R148 should be smaller than O148. Your hand result is larger than O148, so you must be getting something larger than 1 for the quadratic. That might be something to check in your hand calculations.

According to the spreadsheet in post #4, F124=-9.5E-4, but your latest post claims it is -4.1E-6 (which, perhaps coincidentally, is the value in E124). Using E124 instead of F124 (all else unchanged, does seem to result in 36.7. Double check all values in the formula and make sure your hand calculation is using the exact same value for each step. Again, using the formula evaluator tool, stopping at each step, is a useful tool for checking if each value and reference is what you expect.