Spreadsheet: 586356d1534340210-formula-not-giving-expected-results-sample-workbook
Sheet: Roof and Soffit

Directions: Select options (Trusses/Pin Rafters, Shingles/Third-Party, Insulation, Drywall) for chosen roof pitch.                    Select options for Soffit (Miratec/Kleer/Winsor One, Size, Vented/Beaded Soffit). |  |  |  |  |  |  | Index
Pitch | 12' [NAME] | 13' [NAME] | 14' [NAME] | 16' [NAME] |  | Soffit and Gable Trim |  |  | Span - Supporting Deck
 |  |  |  |  |  | Material | Per LF |  | Length | Cost Per LF
10:12 | 15.83998053199272 | 15.38963260733651 | 14.53416377012389 | 12.99133216042097 |  | Miratec | 9.423540738636365
 |  |  |  |  |  | 1x6 |  |  | 10' 6" | 5.626633000000001
 |  |  |  |  |  | Vented Soffit | 2.66 |  | 13' 6" | 10.35207307692307
 |  |  |  |  |  | Total | 12.08354073863637 |  | 16' | 11.071723125
4/12 Pitch | 12' [NAME] | 13' [NAME] | 14' [NAME] | 16' [NAME] |  |  |  |  | 18' | 11.975455
 |  |  |  |  |  | Shed Dormer
Trusses | 43.57585425743882 | 9.868938057985318 | 9.324549942497127 | 7.855814761846405 |  | Per LF | 60.71709208974358 |  | GEPs
Shingles | 3.541242281766382 | 3.390799822945431 | 3.378481508119658 | 3.37410136875 |  |  |  |  | 12' | 368.3824933333333
Cellulose R60 | 0.7087719298245614 | 0.7087719298245614 | 0.7087719298245615 | 0.7087719298245614 |  | "A" Dormer | Total |  | 13' | 394.560528
1/2 Drywall | 0.4923958333333333 | 0.5446153846153846 | 0.5057142857142857 | 0.4425 |  | 4' 9" Width | 858.5463726495727 |  | 14' | 418.2836166666666
Not Mass. Code |  |  |  |  |  | 5' 9" Width | 868.1763726495727 |  | 16' | 454.92064
Total | 48.3182643023631 | 14.51312519537069 | 13.91751766615563 | 12.38118806042097 |  | 8' [NAME] | 913.2663726495728
 |  |  |  |  |  |  |  |  | Valley Components
5/12 Pitch | 12' [NAME] | 13' [NAME] | 14' [NAME] | 16' [NAME] |  |  |  |  | 0' - 12' | 199.04724
 |  |  |  |  |  |  |  |  | 12' 1" - 24' | 387.40448
Trusses | 10.31550686160548 | 9.92098901952378 | 9.304638781782842 | 8.511152652471408 |  |  |  |  | 24' 1" - 36' | 560.96172
Shingles | 3.573354898433049 | 3.4213073921762 | 3.407465936691087 | 3.40048173125
Cellulose R60 | 0.7087719298245614 | 0.7087719298245614 | 0.7087719298245615 | 0.7087719298245614 |  |  |  |  | Reverse GEPs
1/2 Drywall | 0.4923958333333333 | 0.5446153846153846 | 0.5057142857142857 | 0.4425 |  |  |  |  | 0' - 12' | 267.8168886666667
Not Mass. Code |  |  |  |  |  |  |  |  | 12' 1" - 24' | 585.832648
Total | 15.09002952319642 | 14.59568372613993 | 13.92659093401278 | 13.06290631354597 |  |  |  |  | 24' 1" - 36' | 785.5022273333334
6/12 Pitch | 12' [NAME] | 13' [NAME] | 14' [NAME] | 16' [NAME]
Trusses | 8.216687069938818 | 7.654841327216085 | 7.130906371068549 | 5.544063668096405
Shingles | 3.615679903062679 | 3.453107476791585 | 3.447807686691087 | 3.4371200375
Cellulose R49 | 0.5488011954085444 | 0.5488011954085444 | 0.5488011954085444 | 0.5488011954085444
1/2 Drywall | 0.4923958333333333 | 0.5446153846153846 | 0.5057142857142857 | 0.4425
Not Mass. Code
Total | 12.87356400174337 | 12.2013653840316 | 11.63322953888246 | 9.97248490100495
7/12 Pitch | 12' [NAME] | 13' [NAME] | 14' [NAME] | 16' [NAME]
Trusses | 10.39272873660548 | 9.958136134908397 | 9.490906371068556 | 7.887251011846404
Shingles | 3.640459969729345 | 3.453107476791585 | 3.447807686691087 | 3.4371200375
Cellulose R60 | 0.7087719298245614 | 0.7087719298245614 | 0.7087719298245615 | 0.7087719298245614
1/2 Drywall | 0.4923958333333333 | 0.5446153846153846 | 0.5057142857142857 | 0.4425
Not Mass. Code
Total | 15.23435646949272 | 14.66463092613993 | 14.15320027329849 | 12.47564297917097
8/12 Pitch | 12' [NAME] | 13' [NAME] | 14' [NAME] | 16' [NAME]
Trusses | 10.33856206993882 | 9.569052673369935 | 9.083566906782842 | 7.136469761846405
Shingles | 3.699194594729346 | 3.5437441921762 | 3.530528854945056 | 3.47515998125
Cellulose R49 | 0.5488011954085444 | 0.5488011954085444 | 0.5488011954085444 | 0.5488011954085444
5/8 Drywall | 0.5816666666666667 | 0.6395192307692308 | 0.5938392857142857 | 0.5196093749999999
Not Mass. Code
Total | 15.16822452674337 | 14.30111729172391 | 13.75673624285073 | 11.68004031350495
9/12 Pitch | 12' [NAME] | 13' [NAME] | 14' [NAME] | 16' [NAME]
Trusses | 10.62568696577215 | 10.13297555798532 | 9.421316728211414 | 7.889204136846405
Shingles | 3.735727061396012 | 3.578605476791585 | 3.57378441923077 | 3.55443003125
Cellulose R60 | 0.7087719298245614 | 0.7087719298245614 | 0.7087719298245615 | 0.7087719298245614
5/8 Drywall | 0.5816666666666667 | 0.6395192307692308 | 0.5938392857142857 | 0.5196093749999999
Not Mass. Code
Total | 15.65185262365939 | 15.0598721953707 | 14.29771236298103 | 12.67201547292097
10/12 Pitch | 12' [NAME] | 13' [NAME] | 14' [NAME] | 16' [NAME]
Trusses | 10.75045759077215 | 10.39547555798532 | 9.6014772639257 | 8.148563355596407
Shingles | 3.799084344729345 | 3.645865888757397 | 3.630075290659341 | 3.6143875
Cellulose R60 | 0.7087719298245614 | 0.7087719298245614 | 0.7087719298245615 | 0.7087719298245614
5/8 Drywall | 0.5816666666666667 | 0.6395192307692308 | 0.5938392857142857 | 0.5196093749999999
Not Mass. Code
Total | 15.83998053199272 | 15.38963260733651 | 14.53416377012389 | 12.99133216042097
12/12 Pitch | 12' [NAME] | 13' [NAME] | 14' [NAME] | 16' [NAME]
Trusses | 10.93585321577215 | 10.24168671183147 | 9.580744942497127 | 8.204469293096405
Shingles | 3.910545132692308 | 3.753248357988166 | 3.742657033516484 | 3.732325497222222
Cellulose R60 | 0.7087719298245614 | 0.7087719298245614 | 0.7087719298245615 | 0.7087719298245614
5/8 Drywall | 0.5816666666666667 | 0.6395192307692308 | 0.5938392857142857 | 0.5196093749999999
Not Mass. Code
Total | 16.13683694495568 | 15.34322623041343 | 14.62601319155246 | 13.16517609514319