This is a technical appendix outlining the logic used to decipher the data being transferred.
When pasting the contents of a Microsoft Excel cell to a PPM category in a scorecard or table cell, the following rules are observed:
The contents of the Excel cell will be defined as an integer if it contains all of the following:
- A string of one or more digits (required).
- Any one of the special unit characters (optional).
- Either of the two negative number indicators (optional).
- Any number of blank spaces anywhere in the cell (except if inserted within the string of digits).
The contents of the Excel cell will be defined as a float if, in addition to the above, the aforementioned string of digits contains the correct digit grouping symbol (comma or period) as defined in the Regional Options.