Units4Excel Update

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:

Units4Excel.zip

This entry was posted in Excel, Maths, Newton, UDFs, VBA and tagged , , , , . Bookmark the permalink.

5 Responses to Units4Excel Update

  1. Bill Harvey says:

    Used to get v angry with my students for quoting more sig figs than they could defend!

    Like

    • dougaj4 says:

      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!

      Like

      • Bill Harvey says:

        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.

        Like

        • dougaj4 says:

          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!

          Like

        • Bill Harvey says:

          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?”

          Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.