A roof comparison can contain correctly copied numbers and still tell the wrong story. One common trap is putting solar reflectance and Solar Reflectance Index into the same spreadsheet column, then formatting every entry as a percentage. The resulting chart may look tidy while mixing two different quantities.
Give each quantity its own field
The Cool Roof Rating Council distinguishes measured solar reflectance, a fraction from 0 to 1, from SRI, a calculated index combining solar reflectance and thermal emittance. Most SRI values fall between 0 and 100, but values outside that interval are possible. SRI therefore needs its own numeric field, without a percentage sign.
Consider these independent, hypothetical entries. They do not describe one product, and no SRI has been calculated from the reflectance example:
- Solar reflectance 0.35: store 0.35 in a field labeled “SR, fraction.” An optional percentage display can show 35%.
- SRI 105: store 105 in a field labeled “SRI, index.” Do not convert it to 1.05, label it 105% or reduce it to 100.
- An unlabeled value of 35: leave its meaning unresolved until the source identifies the quantity. It might be a percent-format reflectance or an index; guessing changes the record.
Catch the formatting error before making a chart
In a conventional spreadsheet, applying percentage formatting to the stored number 35 displays 3,500%. Entering 0.35 and displaying it as 35% is a formatting choice; multiplying by 100 first and then applying that format multiplies the presentation twice. Keep the source value and the displayed value visible during review.
Use a separate range check for the SR fraction field: a value above 1 should prompt a unit or transcription check. Do not reuse that rule for SRI. The CRRC’s current FAQs confirm that an SRI can exceed 100 or be negative. Such a value calls for checking the original rating, not automatically deleting or capping it.
Make corrections traceable
Keep an untouched source column, the source link or document name, and a short correction note. For example: “Source says SR 35%; normalized to fraction 0.35.” A second reader should be able to reverse the conversion and recover the original expression. If a heading is missing, ask the supplier rather than silently repairing the number.
For product identity and equivalent initial or aged rating columns, continue with Tile Roofing USA’s comparison guide. For natural slate documentation questions, see Slate Roofing USA’s documentation guide. A clean spreadsheet preserves the evidence; it does not establish a particular product’s suitability, code compliance or household energy savings.
