Seven years ago this was asked, are there any new developments with regard to formatting with SI units?

Normally, I will adjust the format to be all milli or micro simply by division, however my most recent proof of concept blended the applicability of milli and micro such that data set runs across the milli and micro boundaries.

Dealing with internal combustion engine ignition timing has been an unusual experience in my engineering: how RPM can vary from roughly 900 to as high as 14000 has meant being continuously aware of the capacity of data types.

In this specific case, there is a recovery time which is a fixed value. It limits the maximum RPM of this system, but it alone cannot dictate maximum RPM as the functionality I'm testing has its own dwell independent of recovery time. Staring at the wall of numbers makes it difficult to grasp the magnitude of the values and make interpretations of the data.

Sample data set arranged vertically. Gray are the equations in those cells and green are my ideal formatting for those cells.

Example where milli and micro seconds would be useful

RPM is continuously varying and the Duty Cycle (aka dwell) is programmable. In this sheet, I'm verifying observed timing and trying to relate it to other constraints.

  • Have you read Having units in Google Spreadsheets?? – Tedinoz Oct 25 '19 at 22:36
  • Isn't that the same as if I manually divide by 1000 to get milli as a whole number? When the value goes to 2.5e-5, it should switch to 25 micro. – Chris K Oct 25 '19 at 22:49
  • I must have misunderstood you - what exactly is your problem? – Tedinoz Oct 25 '19 at 23:21
  • Rather than creating a duplicate question, you should put a bounty on the original to attract new answers. – ale Oct 30 '19 at 19:33
  • 1
    @ChrisK I wonder whether Unit of Measure Conversion Library offers any help? – Tedinoz Dec 6 '19 at 8:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.