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.
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.