LSLGuy, I guess I’m still not being clear. The recipes themselves use only U.S. traditional units such as pints and tablespoons. They do not ever list any metric units, and they never will. The only place where metric units appear is in part of the spreadsheet whose explanatory paragraphs are what I’d like checked for clarity and mathematical accuracy.
I still don’t understand what specific changes you recommend, if any, either to the recipes or the spreadsheet.
Finally, I disagree with you that “about 750 kilometers” is just as good as 804.672. As to the decimal portion, I already agreed that it is unnecessarily precise, but nowhere in the recipes or elsewhere in the book do I even suggest that a cook use such precision, and even the conversion spreadsheet does not offer such precision.
But I also disagree that 800 km is no better than “about 750 km.” 750 is 6.25% less. By using such rounding you have introduced significant and unnecessary error.
If I tell a third person that the distance is “about 750 km” and that person translates it correctly into 466 miles and then reduces it by that same 6.25%, the result is 437 miles, which according to you is just as good as 466. If 750 is as good as 800 and 437 is as good as 466, then 437 must be as good as 500, which it isn’t. You can see that by the time a fourth and fifth person have gotten involved, either City A is going to have to pick up its streets and buildings and move or City B is.
LSLGuy, it is precisely (ha) because one cannot predict in which direction any rounding takes place that one should not round much, if at all. If the original estimate was 500 miles then 800 km IS a better answer than 750. Or 850. And it’s rounder!
For many years I examined the books and other documents from funeral homes across the U.S and Canada to assess their value for sale or estate taxes or divorces or whatever, and almost always I requested a real estate appraisal. And almost always the appraiser applied rounding at the very end, where all the various real items’ values were added up. If the actual total was $1,000,435, it would be rounded down to an even million, a difference of only 0.0435%. I think this was the appraisers’ way of saying what you’ve been saying, LSLGuy, which is that either number is a guess. I always used the unrounded total in my own list of the firm’s assets, and I explained why, which is that such rounding is unfair to one party or another, in this example the seller. Would you be willing to give up $435 because someone decided to round up or down FOR NO REASON? At the end of each such valuation report I showed the total value of the several net assets for sale down to the exact dollar, because I could think of no reason not to, because any gratuitous rounding would work against one party and for the other. I went on to explain that the last few sigfigs would be overwhelmed by many other factors, but I still stuck to the original, unrounded number because NO OTHER NUMBER was more accurate. Can you tell me how this example is different from your examples?
I ask yet again, what do you think I should change in the recipes themselves or the spreadsheet?
Although all of the above has been directed only to LSLGuy, I want to report to everyone reading this thread this far that I finally realized, thanks to Saint Cad, how to simplify the formula for converting cups to millimeters, which was (231 / 16) * (2.54^3). By switching to gallons instead of cups for the gospel number I was able to eliminate the whole division by 16 step to get cups per gallon, so now it’s simply 231 * 2.54^3, where 231 is the number of cubic inches in a gallon and 2.54 is still the number of centimeters in an inch and where 1 cc = 1 mL.
Baffle, yes, you get it, and you said it better back on September 25th than I have so far, and certainly more short-windedly.
I’m still happy to upload the Excel 2010 spreadsheet to anyone who wants to see it and, ideally for me, criticize it.