Basics of the solar profile

In the "normalized shape" column I don't understand how the formulas lead to the values in the column. For example, in row 20, it has a value of .24. I don't understand from the formula how it actually calculates that from the INDEX and MATCH functions included within the formula. I've looked up same in Excel but I don't see how/why it grabbed that value of .24.

Also, I don't know why the normalized shape section, only lists 1,235 kWhs and the rooftop shape lists 4,941 kWhs. I understand the value in the CDG shape column.

Hello,

Can you provide some context for your question? I am not sure where in SAM you are seeing this data, and what you mean by "normalized shape" and "CDG shape column" or by the "INDEX" and "MATCH" functions.

Best regards,
Paul.