As discussed here, I have updated the Units4Excel spreadsheet, with the list of non-SI units updated from the latest Wikipedia table. The EvalU user defined function (UDF) has also been modified with three output options, as shown in the screen-shot below:
The revised spreadsheet, including full open-source code, can be downloaded from:
Newton Excel Bach, not (just) an Excel Blog 
Used to get v angry with my students for quoting more sig figs than they could defend!
LikeLike
OK, I’ll look at adding an option to limit the precision in the text display. It will probably be a number of decimal places, rather than significant figures.
The examples were copied from some Mathcad output, and they had 15 SF for the value of pi as well!
LikeLike
My argument was that steel is the most accurate material used Bt civil engineers abs is rolled to +- 2%. So g in civil engineering is10, though I guess in fluids more precision is justified. Keep up the good work though Doug.
LikeLike
I agree Bill, especially for soil properties. If I see soil properties quoted with more than 2 or 3 significant figures, I always check where it has come from!
LikeLike
Years ago I was internal examiner on a PhD by a Chinese student who had tested many hundreds of cubes and was quoting results to 5sig figs or so. The examiner, a mature guy from industry, asked repeatedly what the material actually was. Student kept starting with “It’s an aluminium silcate…..” Eventually examiner said “OK, how do you make it?” You mixh coarse and fine aggregate and cement with water”. ” And how do you make cement?” “You take a mixture of limestone and clay and kiln it and grind it”.
“OK, so you are telling me you have a mixture of dirt and burnt dirt and you can give me strengths to 5 significant figures?”
LikeLike