Preserving the craft. Building its future.

Slate & tile · rating literacy

SRI 105 is not 105%: checking a roof-rating spreadsheet

A worked data-entry check separates solar reflectance fractions from SRI index values, preventing percentage-formatting and range-check errors in roofing comparisons.

By the Slate, Tile & Metal Guild ·

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.

Further reading

Cool Roof Rating Council — Understanding the Solar Reflectance Index, updated April 2024. The examples below illustrate data handling; they are not ratings for named slate or tile products, a calculation of SRI or a project compliance determination.

Published by the Guild as part of Tim Kelly’s Slate Boss resource network. These educational guides support project conversations and do not replace an on-site inspection or a project specification.

← All roofing articles