Spreadsheet: 6079e584-cd42-479d-b8ee-a7bc50abc639
Sheet: Sheet1

Unnamed: 0 | Window treatment | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29 | Unnamed: 30 | Unnamed: 31 | Unnamed: 32 | Unnamed: 33 | Unnamed: 34 | Unnamed: 35 | Unnamed: 36 | Unnamed: 37
 |  |  | Energy Savings |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Serious | 525 |  | Serious | 725 |  | Integrity |  |  | Ultrex
 |  |  |  | Conduction |  |  | Infiltration |  |  |  |  |  |  | 1st Year Savings |  |  |  |  |  |  | Hebb House
 |  |  | Area (SF) | U | U | Crack | CFM/LF | CFM/LF |  | Eff | Fuel | Fuel | Conductive | Infiltrative | Fuel |  |  |  |  |  |  | No | W | H | SF | LF |  |  | $/sf
 | Option w/o Labor |  | SF | Old | New | LF | Old | New | HDD | % | $/Unit | Btu/Unit | Svg | Svg | Svg |  |  |  |  |  | DH | 6 | 32 | 60 | 80 | 108 | 688.55 | 4131.299999999999 | 51.64124999999999 | 871 | 5226 |  | 321.3166666666667 | 1927.9 |  | 494.3333333333333 | 2966
1 | Integrity All-Ultrex |  | 115.6458333333333 | 0.62 | 0.29 | 205 | 0.1 | 0.05 | 6500 | 0.7 | 2.5 | 138690 | 61.32327492969934 | 0.08677111337721333 | 61.41004604307655 |  |  |  |  |  | Fixed | 1 | 46 | 74 | 23.63888888888889 | 0 | 695 | 695 | 29.40070505287897 | 863.42 | 863.42 |  | 486.2 | 486.2 |  | 748 | 748
2 | AEP® Interior panels |  | 115.6458333333333 | 0.62 | 0.2693310165073849 | 205 | 0.1 | 0.002 | 6500 | 0.7 | 2.5 | 138690 | 65.16415298192676 | 0.1700713822193381 | 65.3342243641461 |  |  |  |  |  | Csmnt | 2 | 19 | 29.5 | 7.784722222222222 | 97 | 361.69 | 723.38 | 92.92303300624442 | 446.21 | 892.42 |  | 262.6 | 525.2 |  | 404 | 808
3 | Serious Windows 525 | .17 - .22 | 115.6458333333333 | 0.62 | 0.2 | 205 | 0.1 | 0.05 | 6500 | 0.7 | 2.5 | 138690 | 78.04780445598097 | 0.08677111337721333 | 78.13457556935818 |  |  |  |  |  | Fixed | 1 | 19 | 32 | 4.222222222222222 |  | 292.08 | 292.08 | 69.17684210526315 | 372.16 | 372.16 |  | 215.15 | 215.15 |  | 331 | 331
4 | Serious Windows 725 | .14 - .19 | 115.6458333333333 | 0.62 | 0.16 | 205 | 0.1 | 0.05 | 6500 | 0.7 | 2.5 | 138690 | 85.48092868988391 | 0.08677111337721333 | 85.56769980326112
5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5841.759999999999 |  |  | 7354 |  |  | 3154.45 |  |  | 4853
6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tax | 0.05 | 292.088 |  |  | 367.7 |  |  | 157.7225 |  |  | 242.65
7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -1752.528 |  |  | -2206.2 |  |  | -946.335 |  |  | -1455.9
8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 115.6458333333333 | 205 |  | 4381.32 |  |  | 5515.5 |  |  | 2365.8375 |  |  | 3639.75
9
10
11
12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DOE real 10 yr escalation rate for New England excluding inflation
 |  |  | Cost Savings |  |  |  |  |  |  | Avoided Replacement Cost
 |  |  |  |  |  | Salvage |  | Pay- | Life | [NAME] | PV
 |  |  | Cost | Svg | O&M | Value | Life | back | of | ment | Cost | NPV | SIR
 |  |  | ($) | ($/Yr) | ($) | ($) | ([NAME].) | ([NAME].) | Existing | Cost | $ | ($)
1 | Integrity All-Ultrex |  | 3639.75 | 153.5251151076914 | 0 | 0 | 30 | 23.70784739322208 | 15 | 0 | 0 | 4187.331912174182 | 2.150444924012413
2 | AEP® Interior panels |  | 933 | 163.3355609103652 | 50 | 0 | 10 | 4.373391834059995 | 15 | 0 | 0 | 1444.867473758171 | 2.54862537380297
3 | Serious Windows 525 |  | 4381.32 | 195.3364389233954 | 0 | 0 | 30 | 22.42960926362649 | 15 | 0 | 0 | 5577.404387298824 | 2.272996354363257
4 | Serious Windows 725 |  | 5515.5 | 213.9192495081528 | 0 | 0 | 30 | 25.78309344615476 | 15 | 0 | 0 | 5390.621042909775 | 1.977358542817474
5 | 0
6 | 0
7 | 0
8 | 0
9 | 0
10 | 0
11 | 0
12 | 0
 | Fuel Oil Escaltion | 1.0643 | Fuel escalation is anyones guess.
 | Discount Rate | 1.031 | Discount rate is what you would otherwise be getting or paying for your money. 3% might be low but is commonly used.
 | Use NIST Handbook 135 LCC 2008
 |  |  | NPV is net savings in today's dollars and simply needs to be positive.
 |  |  | Avoided Replacement Cost is not entirely accurate as it should be only the value (cost) up to the end of the life of the Ultrex. Actually there is more value in them at that point.
 | Glazing Type/configuration | U
 | Single Strength Sgl Pane | 1.1
 | Single pane [NAME] | 0.8695652173913044
 | Sgl pane 3/16 | 0.62
 | Sgl pane 1/4" | 0.58
 | Sgl pane 1/2" | 0.49
 | Alum combin. Storm | 0.4807692307692307
 | 3M Film on .62 dbl | 0.39
 | Dual Sgl Strnth w/ 1-Low e | 0.3802281368821293
 | Dual Dbl Strnth w/ 1-Low e | 0.3597122302158274
 | Triple clear | 0.3497
 | Dual Dbl Str Low e w/arg gas | 0.3496503496503497
 | Dbl poly film w/ 1/2" air | 0.031
 | Dual Dbl Str w/ 2 Low e | 0.3003003003003003
 | Low e W/gas | 0.2898550724637681
 | Low e gas triple | 0.2702702702702702
 | 1' Heat mirror | 0.2222222222222222