![]() ![]() ![]() To make meaningful comparisons between measured and modeled it is important that you keep in mind the reference plane of your measuring device. That's not a catastrophe, just revise the formula to replace the undefined names 'LastFreq' and 'NumSteps' with the desired numeric values of 100 and 25. (If you neglect to click on the formula bar or press F2 you will paste both the text characters and the text font, not what you want.) Change 'LastFreq' to 100 and 'NumSteps' to 25, then press Enter.If you press Enter before changing 'LastFreq' and 'NumSteps' the formula will evaluate to the Excel error code '#NAME?' meaning you used an undefined name in the formula. = ROUND(10 ^ (LOG(B$11) + (ROW()-11) * (LOG(LastFreq) - LOG(B$11)) / (NumSteps - 1)), 3) Hint: You can swipe the above line on this web page, press Ctrl-C to copy, return to the Excel window, select cell B12, click on the formula bar to activate it (or just press F2), then press Ctrl-V to paste. ![]() Then select cell B12, the second frequency, and enter the following string in the formula bar at the top of the Excel window. On the Calculate sheet enter '1' as the first frequency in cell B11. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |