{"text_format":"3","workbook":"xlsx","n_sheets":10,"sheets":["GWP Project Summary","GWP Calculator | Building","GWP Calculator | Furniture ","GWP Calculator | Casework ","Sustainability Metrics Sheet","Notes","EPD Sources","Tally Casework Outputs","Building Type Benchmarks","Future phase"],"not_rendered":{"charts":4,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"GWP Project Summary","index":0,"n_rows":70,"n_cols":19,"rows_kept":70,"merged":[[5,3,6,3],[5,5,6,5],[5,7,6,7],[5,12,5,13],[5,15,6,15],[5,17,6,17],[59,3,60,3],[59,5,60,5],[59,7,60,7],[59,12,59,13],[59,15,60,15]]}
[null,"updated 06/28/2023"]
[null,"Total Building Area",null,null,"sf"]
[]
[null,"GWP Summary | New and major renovation project (Project total is only Construction Materials)",{"$nulls":8},"GWP Summary | Interior project (Project total is Construction Materials, Casework & Furniture)"]
[null,"This summary will be compared to the AIA COTE embodied carbon baseline.",{"$nulls":8},"This summary will be compared to the CLF 2019 interior project embodied carbon baseline."]
[{"$nulls":3},"GWP / sf\n(lbs CO2eq/sf)",null,"New vs \nSalvaged",null,"Impact compared to total project",{"$nulls":4},"GWP / sf (lbs CO2eq/sf)",null,null,"New vs \nSalvaged",null,"Impact compared to total project"]
[{"$nulls":12},"initial","multiplied by # refreshes"]
[null,"03 - Concrete",{"$nulls":8},"03 - Concrete"]
[null,null,"New ",{"$f":"'GWP Calculator | Building'!$F$6","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($D$9/$D$11,3)","v":{"$error":"#DIV/0!"}},null,{"$f":"$D$9/$D$64","v":{"$error":"#DIV/0!"}},{"$nulls":3},"New ",{"$f":"'GWP Calculator | Building'!$F$19","v":{"$error":"#DIV/0!"}},{"$f":"$M$9*#REF!","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($M$9/$M$11,3)","v":{"$error":"#DIV/0!"}},null,{"$f":"$M$9/$M$64","v":{"$error":"#DIV/0!"}}]
[null,null,"Salvaged ",{"$f":"'GWP Calculator | Building'!$K$6","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($D$10/$D$11,3)","v":{"$error":"#DIV/0!"}},null,{"$f":"$D$10/$D$64","v":{"$error":"#DIV/0!"}},{"$nulls":3},"Salvaged ",{"$f":"'GWP Calculator | Building'!$K$19","v":{"$error":"#DIV/0!"}},{"$f":"$M$10*#REF!","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($M$10/$M$11,3)","v":{"$error":"#DIV/0!"}},null,{"$f":"$M$10/$M$64","v":{"$error":"#DIV/0!"}}]
[null,null,"New + Salvaged",{"$f":"'GWP Calculator | Building'!$O$6","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$f":"$D$11/$D$64","v":{"$error":"#DIV/0!"}},{"$nulls":3},"New + Salvaged",{"$f":"'GWP Calculator | Building'!$O$19","v":{"$error":"#DIV/0!"}},{"$f":"$M$11*#REF!","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$f":"$M$11/$M$64","v":{"$error":"#DIV/0!"}}]
[{"$nulls":5},{"$f":"SUM($F$9:$F$10)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM($H$9:$H$10)","v":{"$error":"#DIV/0!"}},"QA check",{"$nulls":6},{"$f":"SUM($P$9:$P$10)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM($R$9:$R$10)","v":{"$error":"#DIV/0!"}},"QA check"]
[null,"04 - Masonry",{"$nulls":8},"04 - Masonry"]
[null,null,"New ",{"$f":"'GWP Calculator | Building'!$F$7","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($D$14/$D$16,3)","v":{"$error":"#DIV/0!"}},null,{"$f":"$D$14/$D$64","v":{"$error":"#DIV/0!"}},{"$nulls":3},"New ",{"$f":"'GWP Calculator | Building'!$F$20","v":{"$error":"#DIV/0!"}},{"$f":"$M$14*#REF!","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($M$14/$M$16,3)","v":{"$error":"#DIV/0!"}},null,{"$f":"$M$14/$M$64","v":{"$error":"#DIV/0!"}}]
[null,null,"Salvaged ",{"$f":"'GWP Calculator | Building'!$K$7","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($D$15/$D$16,3)","v":{"$error":"#DIV/0!"}},null,{"$f":"$D$15/$D$64","v":{"$error":"#DIV/0!"}},{"$nulls":3},"Salvaged ",{"$f":"'GWP Calculator | Building'!$K$20","v":{"$error":"#DIV/0!"}},{"$f":"$M$15*#REF!","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($M$15/$M$16,3)","v":{"$error":"#DIV/0!"}},null,{"$f":"$M$15/$M$64","v":{"$error":"#DIV/0!"}}]
[null,null,"New + Salvaged",{"$f":"'GWP Calculator | Building'!$O$7","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$f":"$D$16/$D$64","v":{"$error":"#DIV/0!"}},{"$nulls":3},"New + Salvaged",{"$f":"'GWP Calculator | Building'!$O$20","v":{"$error":"#DIV/0!"}},{"$f":"$M$16*#REF!","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$f":"$M$16/$M$64","v":{"$error":"#DIV/0!"}}]
[{"$nulls":5},{"$f":"SUM($F$19:$F$20)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM($H$14:$H$15)","v":{"$error":"#DIV/0!"}},"QA check",{"$nulls":6},{"$f":"SUM(P14:P15)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM($R$14:$R$15)","v":{"$error":"#DIV/0!"}},"QA check"]
[null,"05 - Metals",{"$nulls":8},"05 - Metals"]
[null,null,"New ",{"$f":"'GWP Calculator | Building'!$F$8","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($D$19/$D$21,3)","v":{"$error":"#DIV/0!"}},null,{"$f":"$D$19/$D$64","v":{"$error":"#DIV/0!"}},{"$nulls":3},"New ",{"$f":"'GWP Calculator | Building'!$F$21","v":{"$error":"#DIV/0!"}},{"$f":"$M$19*#REF!","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($M$19/$M$21,3)","v":{"$error":"#DIV/0!"}},null,{"$f":"$M$19/$M$64","v":{"$error":"#DIV/0!"}}]
[null,null,"Salvaged ",{"$f":"'GWP Calculator | Building'!$K$8","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($D$20/$D$21,3)","v":{"$error":"#DIV/0!"}},null,{"$f":"$D$20/$D$64","v":{"$error":"#DIV/0!"}},{"$nulls":3},"Salvaged ",{"$f":"'GWP Calculator | Building'!$K$21","v":{"$error":"#DIV/0!"}},{"$f":"$M$20*#REF!","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($M$20/$M$21,3)","v":{"$error":"#DIV/0!"}},null,{"$f":"$M$20/$M$64","v":{"$error":"#DIV/0!"}}]
[null,null,"New + Salvaged",{"$f":"'GWP Calculator | Building'!$O$8","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$f":"$D$21/$D$64","v":{"$error":"#DIV/0!"}},{"$nulls":3},"New + Salvaged",{"$f":"'GWP Calculator | Building'!$O$21","v":{"$error":"#DIV/0!"}},{"$f":"$M$21*#REF!","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$f":"$M$21/$M$64","v":{"$error":"#DIV/0!"}}]
[{"$nulls":5},{"$f":"SUM($F$19:$F$20)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM($H$19:$H$20)","v":{"$error":"#DIV/0!"}},"QA check",{"$nulls":6},{"$f":"SUM($P$19:$P$20)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM($R$19:$R$20)","v":{"$error":"#DIV/0!"}},"QA check"]
[null,"06 - Wood/Plastics/Composites",{"$nulls":8},"06 - Wood/Plastics/Composites"]
[null,null,"New ",{"$f":"'GWP Calculator | Building'!$F$9","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($D$24/$D$26,3)","v":{"$error":"#DIV/0!"}},null,{"$f":"$D$24/$D$64","v":{"$error":"#DIV/0!"}},{"$nulls":3},"New ",{"$f":"'GWP Calculator | Building'!$F$22","v":{"$error":"#DIV/0!"}},{"$f":"$M$24*#REF!","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($M$24/$M$26,3)","v":{"$error":"#DIV/0!"}},null,{"$f":"$M$24/$M$64","v":{"$error":"#DIV/0!"}}]
[null,null,"Salvaged ",{"$f":"'GWP Calculator | Building'!$K$9","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($D$25/$D$26,3)","v":{"$error":"#DIV/0!"}},null,{"$f":"$D$25/$D$64","v":{"$error":"#DIV/0!"}},{"$nulls":3},"Salvaged ",{"$f":"'GWP Calculator | Building'!$K$22","v":{"$error":"#DIV/0!"}},{"$f":"$M$25*#REF!","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($M$25/$M$26,3)","v":{"$error":"#DIV/0!"}},null,{"$f":"$M$25/$M$64","v":{"$error":"#DIV/0!"}}]
[null,null,"New + Salvaged",{"$f":"'GWP Calculator | Building'!$O$9","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$f":"$D$26/$D$64","v":{"$error":"#DIV/0!"}},{"$nulls":3},"New + Salvaged",{"$f":"'GWP Calculator | Building'!$O$22","v":{"$error":"#DIV/0!"}},{"$f":"$M$26*#REF!","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$f":"$M$26/$M$64","v":{"$error":"#DIV/0!"}}]
[{"$nulls":5},{"$f":"SUM($F$24:$F$25)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM($H$24:$H$25)","v":{"$error":"#DIV/0!"}},"QA check",{"$nulls":6},{"$f":"SUM($P$24:$P$25)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM($R$24:$R$25)","v":{"$error":"#DIV/0!"}},"QA check"]
[null,"07 - Thermal and Moisture Protection",{"$nulls":8},"07 - Thermal and Moisture Protection"]
[null,null,"New ",{"$f":"'GWP Calculator | Building'!$F$10","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($D$29/$D$31,3)","v":{"$error":"#DIV/0!"}},null,{"$f":"$D$29/$D$64","v":{"$error":"#DIV/0!"}},{"$nulls":3},"New ",{"$f":"'GWP Calculator | Building'!$F$23","v":{"$error":"#DIV/0!"}},{"$f":"$M$29*#REF!","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($M$29/$M$31,3)","v":{"$error":"#DIV/0!"}},null,{"$f":"$M$29/$M$64","v":{"$error":"#DIV/0!"}}]
[null,null,"Salvaged ",{"$f":"'GWP Calculator | Building'!$K$10","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($D$30/$D$31,3)","v":{"$error":"#DIV/0!"}},null,{"$f":"$D$30/$D$64","v":{"$error":"#DIV/0!"}},{"$nulls":3},"Salvaged ",{"$f":"'GWP Calculator | Building'!$K$23","v":{"$error":"#DIV/0!"}},{"$f":"$M$30*#REF!","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($M$30/$M$31,3)","v":{"$error":"#DIV/0!"}},null,{"$f":"$M$30/$M$64","v":{"$error":"#DIV/0!"}}]
[null,null,"New + Salvaged",{"$f":"'GWP Calculator | Building'!$O$10","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$f":"$D$31/$D$64","v":{"$error":"#DIV/0!"}},{"$nulls":3},"New + Salvaged",{"$f":"'GWP Calculator | Building'!$O$23","v":{"$error":"#DIV/0!"}},{"$f":"$M$31*#REF!","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$f":"$M$31/$M$64","v":{"$error":"#DIV/0!"}}]
[{"$nulls":5},{"$f":"SUM($F$29:$F$30)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM($H$29:$H$30)","v":{"$error":"#DIV/0!"}},"QA check",{"$nulls":6},{"$f":"SUM($P$29:$P$30)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM($R$29:$R$30)","v":{"$error":"#DIV/0!"}},"QA check"]
[null,"08 - Openings and Glazing",{"$nulls":8},"08 - Openings and Glazing"]
[null,null,"New ",{"$f":"'GWP Calculator | Building'!$F$11","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($D$34/$D$36,3)","v":{"$error":"#DIV/0!"}},null,{"$f":"$D$34/$D$64","v":{"$error":"#DIV/0!"}},{"$nulls":3},"New ",{"$f":"'GWP Calculator | Building'!$F$24","v":{"$error":"#DIV/0!"}},{"$f":"$M$34*#REF!","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($M$34/$M$36,3)","v":{"$error":"#DIV/0!"}},null,{"$f":"$M$34/$M$64","v":{"$error":"#DIV/0!"}}]
[null,null,"Salvaged ",{"$f":"'GWP Calculator | Building'!$K$11","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($D$35/$D$36,3)","v":{"$error":"#DIV/0!"}},null,{"$f":"$D$35/$D$64","v":{"$error":"#DIV/0!"}},{"$nulls":3},"Salvaged ",{"$f":"'GWP Calculator | Building'!$K$24","v":{"$error":"#DIV/0!"}},{"$f":"$M$35*#REF!","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($M$35/$M$36,3)","v":{"$error":"#DIV/0!"}},null,{"$f":"$M$35/$M$64","v":{"$error":"#DIV/0!"}}]
[null,null,"New + Salvaged",{"$f":"'GWP Calculator | Building'!$O$11","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$f":"$D$36/$D$64","v":{"$error":"#DIV/0!"}},{"$nulls":3},"New + Salvaged",{"$f":"'GWP Calculator | Building'!$O$24","v":{"$error":"#DIV/0!"}},{"$f":"$M$36*#REF!","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$f":"$M$36/$M$64","v":{"$error":"#DIV/0!"}}]
[{"$nulls":5},{"$f":"SUM($F$34:$F$35)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM($H$34:$H$35)","v":{"$error":"#DIV/0!"}},"QA check",{"$nulls":6},{"$f":"SUM($P$34:$P$35)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM($R$34:$R$35)","v":{"$error":"#DIV/0!"}},"QA check"]
[null,"09 - Finishes",{"$nulls":8},"09 - Finishes"]
[null,null,"New ",{"$f":"'GWP Calculator | Building'!$F$12","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($D$39/$D$41,3)","v":{"$error":"#DIV/0!"}},null,{"$f":"$D$39/$D$64","v":{"$error":"#DIV/0!"}},{"$nulls":3},"New ",{"$f":"'GWP Calculator | Building'!$F$25","v":{"$error":"#DIV/0!"}},{"$f":"$M$39*#REF!","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($M$39/$M$41,3)","v":{"$error":"#DIV/0!"}},null,{"$f":"$M$39/$M$64","v":{"$error":"#DIV/0!"}}]
[null,null,"Salvaged ",{"$f":"'GWP Calculator | Building'!$K$12","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($D$40/$D$41,3)","v":{"$error":"#DIV/0!"}},null,{"$f":"$D$40/$D$64","v":{"$error":"#DIV/0!"}},{"$nulls":3},"Salvaged ",{"$f":"'GWP Calculator | Building'!$K$25","v":{"$error":"#DIV/0!"}},{"$f":"$M$40*#REF!","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($M$40/$M$41,3)","v":{"$error":"#DIV/0!"}},null,{"$f":"$M$40/$M$64","v":{"$error":"#DIV/0!"}}]
[null,null,"New + Salvaged",{"$f":"'GWP Calculator | Building'!$O$12","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$f":"$D$41/$D$64","v":{"$error":"#DIV/0!"}},{"$nulls":3},"New + Salvaged",{"$f":"'GWP Calculator | Building'!$O$25","v":{"$error":"#DIV/0!"}},{"$f":"$M$41*#REF!","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$f":"$M$41/$M$64","v":{"$error":"#DIV/0!"}}]
[{"$nulls":5},{"$f":"SUM($F$39:$F$40)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM($H$39:$H$40)","v":{"$error":"#DIV/0!"}},"QA check",{"$nulls":6},{"$f":"SUM($P$39:$P$40)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM($R$39:$R$40)","v":{"$error":"#DIV/0!"}},"QA check"]
[null,"Construction Materials",{"$nulls":8},"Construction Materials"]
[null,null,"New ",{"$f":"'GWP Calculator | Building'!$F$13","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($D$44/$D$46,3)","v":{"$error":"#DIV/0!"}},null,{"$f":"$D$44/$D$64","v":{"$error":"#DIV/0!"}},{"$nulls":3},"New ",{"$f":"'GWP Calculator | Building'!$F$26","v":{"$error":"#DIV/0!"}},{"$f":"$M$44*#REF!","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($M$44/$M$46,3)","v":{"$error":"#DIV/0!"}},null,{"$f":"$M$44/$M$64","v":{"$error":"#DIV/0!"}}]
[null,null,"Salvaged ",{"$f":"'GWP Calculator | Building'!$K$13","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($D$45/$D$46,3)","v":{"$error":"#DIV/0!"}},null,{"$f":"$D$45/$D$64","v":{"$error":"#DIV/0!"}},{"$nulls":3},"Salvaged ",{"$f":"'GWP Calculator | Building'!$K$26","v":{"$error":"#DIV/0!"}},{"$f":"$M$45*#REF!","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($M$45/$M$46,3)","v":{"$error":"#DIV/0!"}},null,{"$f":"$M$45/$M$64","v":{"$error":"#DIV/0!"}}]
[null,null,"New + Salvaged",{"$f":"'GWP Calculator | Building'!$O$13","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$f":"$D$46/$D$64","v":{"$error":"#DIV/0!"}},{"$nulls":3},"New + Salvaged",{"$f":"'GWP Calculator | Building'!$O$26","v":{"$error":"#DIV/0!"}},{"$f":"$M$46*#REF!","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$f":"$M$46/$M$64","v":{"$error":"#DIV/0!"}}]
[{"$nulls":5},{"$f":"SUM($F$44:$F$45)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(H44:H45)","v":{"$error":"#DIV/0!"}},"QA check",{"$nulls":6},{"$f":"SUM($P$44:$P$45)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM($R$44:$R$45)","v":{"$error":"#DIV/0!"}},"QA check"]
[{"$nulls":10},"Casework"]
[{"$nulls":11},"New ",{"$f":"'GWP Calculator | Casework '!$E$6","v":{"$error":"#DIV/0!"}},{"$f":"$M$49*#REF!","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($M$49/$M$51,3)","v":{"$error":"#DIV/0!"}},null,{"$f":"$M$49/$M$64","v":{"$error":"#DIV/0!"}}]
[{"$nulls":11},"Salvaged ",{"$f":"'GWP Calculator | Casework '!$E$7","v":{"$error":"#DIV/0!"}},{"$f":"$M$50*#REF!","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($M$50/$M$51,3)","v":{"$error":"#DIV/0!"}},null,{"$f":"$M$50/$M$64","v":{"$error":"#DIV/0!"}}]
[{"$nulls":11},"New + Salvaged",{"$f":"'GWP Calculator | Casework '!$E$8","v":{"$error":"#DIV/0!"}},{"$f":"$M$51*#REF!","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$f":"$M$51/$M$64","v":{"$error":"#DIV/0!"}}]
[{"$nulls":15},{"$f":"SUM($P$49:$P$50)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM($R$49:$R$50)","v":{"$error":"#DIV/0!"}},"QA check"]
[{"$nulls":10},"Furniture"]
[{"$nulls":11},"New ",{"$f":"'GWP Calculator | Furniture '!$C$5","v":{"$error":"#DIV/0!"}},{"$f":"$M$54*#REF!","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($M$54/$M$56,3)","v":{"$error":"#DIV/0!"}},null,{"$f":"$M$54/$M$64","v":{"$error":"#DIV/0!"}}]
[{"$nulls":11},"Salvaged ",{"$f":"'GWP Calculator | Furniture '!$C$6","v":{"$error":"#DIV/0!"}},{"$f":"$M$55*#REF!","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($M$55/$M$56,3)","v":{"$error":"#DIV/0!"}},null,{"$f":"$M$55/$M$64","v":{"$error":"#DIV/0!"}}]
[{"$nulls":11},"New + Salvaged",{"$f":"'GWP Calculator | Furniture '!$C$7","v":{"$error":"#DIV/0!"}},{"$f":"$M$56*#REF!","v":{"$error":"#DIV/0!"}},{"$nulls":3},{"$f":"$M$56/$M$64","v":{"$error":"#DIV/0!"}}]
[{"$nulls":15},{"$f":"SUM($P$54:$P$55)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM($R$54:$R$55)","v":{"$error":"#DIV/0!"}},"QA check"]
[]
[null,"Project Total",{"$nulls":8},"Project Total"]
[{"$nulls":3},"GWP / sf\n(lbs CO2eq/sf)",null,"New vs \nSalvaged",{"$nulls":6},"GWP / sf (lbs CO2eq/sf)",null,null,"New vs \nSalvaged"]
[{"$nulls":12},"Interior Lifetime","multiplied by # refreshes"]
[null,null,"New ",{"$f":"$D$44","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($D$62/$D$64,3)","v":{"$error":"#DIV/0!"}},{"$nulls":5},"New ",{"$f":"$M$44+$M$49+$M$54","v":{"$error":"#DIV/0!"}},{"$f":"$N$44+$N$49+$N$54","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($M$62/$M$64,3)","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($R$44+$R$49+$R$54,3)","v":{"$error":"#DIV/0!"}},"QA check (sum of C.M. + casework + furniture)"]
[null,null,"Salvaged ",{"$f":"$D$45","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($D$63/$D$64,3)","v":{"$error":"#DIV/0!"}},{"$nulls":5},"Salvaged ",{"$f":"$M$45+$M$50+$M$55","v":{"$error":"#DIV/0!"}},{"$f":"$N$45+$N$50+$N$55","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($M$63/$M$64,3)","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND($R$45+$R$50+$R$55,3)","v":{"$error":"#DIV/0!"}},"QA check (sum of C.M. + casework + furniture)"]
[null,null,"New + Salvaged",{"$f":"$D$46","v":{"$error":"#DIV/0!"}},{"$nulls":7},"New + Salvaged",{"$f":"$M$46+$M$51+$M$56","v":{"$error":"#DIV/0!"}},{"$f":"$N$46+$N$51+$N$56","v":{"$error":"#DIV/0!"}}]
[{"$nulls":3},{"$f":"$D$62+$D$63","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM($F$62:$F$63)","v":{"$error":"#DIV/0!"}},{"$nulls":6},{"$f":"$M$62+$M$63","v":{"$error":"#DIV/0!"}},{"$f":"$N$62+$N$63","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM($P$62:$P$63)","v":{"$error":"#DIV/0!"}},null,{"$f":"$R$46+$R$51+$R$56","v":{"$error":"#DIV/0!"}},"QA check (sum of New + Salvaged)"]
[null,null,"QA check \n(total of individual divisions)",{"$nulls":8},"QA check (total of individual divisions + caseweork + furniture)"]
[null,null,"new",{"$f":"$D$9+$D$14+$D$19+$D$24+$D$29+$D$34+$D$39","v":{"$error":"#DIV/0!"}},null,{"$f":"$H$9+$H$14+$H$19+$H$24+$H$29+$H$34+$H$39","v":{"$error":"#DIV/0!"}},{"$nulls":5},"new",{"$f":"$M$9+$M$14+$M$19+$M$24+$M$29+$M$34+$M$39+$M$49+$M$54","v":{"$error":"#DIV/0!"}},null,null,{"$f":"$R$9+$R$14+$R$19+$R$24+$R$29+$R$34+$R$39+$R$49+$R$54","v":{"$error":"#DIV/0!"}}]
[null,null,"salvaged",{"$f":"$D$10+$D$15+$D$20+$D$25+$D$30+$D$35+$D$40","v":{"$error":"#DIV/0!"}},null,{"$f":"$H$10+$H$15+$H$20+$H$25+$H$30+$H$35+$H$40","v":{"$error":"#DIV/0!"}},{"$nulls":5},"salvaged",{"$f":"$M$10+$M$15+$M$20+$M$25+$M$30+$M$35+$M$40+$M$50+$M$55","v":{"$error":"#DIV/0!"}},null,null,{"$f":"$R$10+$R$15+$R$20+$R$25+$R$30+$R$35+$R$40+$R$50+$R$55","v":{"$error":"#DIV/0!"}}]
[null,null,"New + Salvaged",{"$f":"$D$11+$D$16+$D$21+$D$26+$D$31+$D$36+$D$41","v":{"$error":"#DIV/0!"}},null,{"$f":"$H$11+$H$16+$H$21+$H$26+$H$31+$H$36+$H$41","v":{"$error":"#DIV/0!"}},{"$nulls":5},"New + Salvaged",{"$f":"$M$11+$M$16+$M$21+$M$26+$M$31+$M$36+$M$41+$M$51+$M$56","v":{"$error":"#DIV/0!"}},null,null,{"$f":"$R$11+$R$16+$R$21+$R$26+$R$31+$R$36+$R$41+$R$51+$R$56","v":{"$error":"#DIV/0!"}}]
[{"$nulls":4},"`"]

{"sheet":"GWP Calculator | Building","index":1,"n_rows":27,"n_cols":16,"rows_kept":27,"merged":[[3,2,3,5],[3,7,3,10],[3,12,3,14],[16,2,16,5],[16,7,16,10],[16,12,16,14]]}
[null,"updated 06/28/2023"]
[null,"!!! Warning | enter GWP Total numbers from Tally Excel export (Not from PDF) !!!"]
[null,"Construction GWP Impact | New and major renovation project (Tally output. Set building lifetime in tally to 60 years unless noted otherwise on the Common App_MSR version tab)"]
[null,null,"New",{"$nulls":4},"Salvaged (if applicable)",{"$nulls":4},"New + Salvaged"]
[null,null,"GWP %","GWP Total (kgCO2e)","Conversion of \nkg to lb","lbs per sf",null,"GWP %","GWP Total (kgCO2e)","Conversion of \nkg to lb","lbs per sf",null,"GWP Total (kgCO2e)","Conversion of \nkg to lb","lbs per sf","QA check"]
[null,"03 - Concrete",{"$f":"$D6/$D$13","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(CONVERT($D$6,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$E$6/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},null,{"$f":"I6/$I$13","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(CONVERT($I$6,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$J$6/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},null,{"$f":"$D$6+$I$6","v":{"v":0,"d":"0.000"}},{"$f":"ROUND(CONVERT($M$6,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$N$6/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},{"$f":"$F$6+$K$6","v":{"$error":"#DIV/0!"}}]
[null,"04 - Masonry",{"$error":"#DIV/0!"},null,{"$f":"ROUND(CONVERT($D$7,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$E$7/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},null,{"$f":"I7/$I$13","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(CONVERT($I$7,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$J$7/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},null,{"$f":"$D$7+$I$7","v":{"v":0,"d":"0.000"}},{"$f":"ROUND(CONVERT($M$7,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$N$7/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},{"$f":"$F$7+$K$7","v":{"$error":"#DIV/0!"}}]
[null,"05 - Metals",{"$error":"#DIV/0!"},null,{"$f":"ROUND(CONVERT($D$8,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$E$8/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},null,{"$f":"I8/$I$13","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(CONVERT($I$8,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$J$8/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},null,{"$f":"$D$8+$I$8","v":{"v":0,"d":"0.000"}},{"$f":"ROUND(CONVERT($M$8,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$N$8/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},{"$f":"$F$8+$K$8","v":{"$error":"#DIV/0!"}}]
[null,"06 - Wood/Plastics/Composites",{"$error":"#DIV/0!"},null,{"$f":"ROUND(CONVERT($D$9,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$E$9/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},null,{"$f":"I9/$I$13","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(CONVERT($I$9,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$J$9/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},null,{"$f":"$D$9+$I$9","v":{"v":0,"d":"0.000"}},{"$f":"ROUND(CONVERT($M$9,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$N$9/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},{"$f":"$F$9+$K$9","v":{"$error":"#DIV/0!"}}]
[null,"07 - Thermal and Moisture Protection",{"$error":"#DIV/0!"},null,{"$f":"ROUND(CONVERT($D$10,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$E$10/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},null,{"$f":"I10/$I$13","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(CONVERT($I$10,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$J$10/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},null,{"$f":"$D$10+$I$10","v":{"v":0,"d":"0.000"}},{"$f":"ROUND(CONVERT($M$10,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$N$10/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},{"$f":"$F$10+$K$10","v":{"$error":"#DIV/0!"}}]
[null,"08 - Openings and Glazing",{"$error":"#DIV/0!"},null,{"$f":"ROUND(CONVERT($D$11,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$E$11/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},null,{"$f":"I11/$I$13","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(CONVERT($I$11,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$J$11/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},null,{"$f":"$D$11+$I$11","v":{"v":0,"d":"0.000"}},{"$f":"ROUND(CONVERT($M$11,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$N$11/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},{"$f":"$F$11+$K$11","v":{"$error":"#DIV/0!"}}]
[null,"09 - Finishes",{"$error":"#DIV/0!"},null,{"$f":"ROUND(CONVERT($D$12,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$E$12/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},null,{"$f":"I12/$I$13","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(CONVERT($I$12,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$J$12/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},null,{"$f":"$D$12+$I$12","v":{"v":0,"d":"0.000"}},{"$f":"ROUND(CONVERT($M$12,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$N$12/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},{"$f":"$F$12+$K$12","v":{"$error":"#DIV/0!"}}]
[null,"Total",{"$f":"ROUND(SUM($C$6:$C$12),3)","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(CONVERT($D$13,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$E$13/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(SUM($H$6:$H$12),3)","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(CONVERT($I$13,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$J$13/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},null,{"$f":"$D$13+$I$13","v":{"v":0,"d":"0.000"}},{"$f":"ROUND(CONVERT($M$13,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$N$13/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},{"$f":"$F$13+$K$13","v":{"$error":"#DIV/0!"}}]
[null,"QA check",null,{"$f":"ROUND(SUM($D$6:$D$12),3)","v":{"v":0,"d":"0.000"}},{"$f":"SUM($E$6:$E$12)","v":{"v":0,"d":"0.000"}},{"$f":"SUM($F$6:$F$12)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"ROUND(SUM(I6:I12),3)","v":{"v":0,"d":"0.000"}},{"$f":"SUM($J$6:$J$12)","v":{"v":0,"d":"0.000"}},{"$f":"SUM($K$6:$K$12)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM($M$6:M$12)","v":{"v":0,"d":"0.000"}},{"$f":"ROUND(SUM($N$6:$N$12),3)","v":{"v":0,"d":"0.000"}},{"$f":"SUM($O$6:$O$12)","v":{"$error":"#DIV/0!"}},{"$f":"SUM($P$6:$P$12)","v":{"$error":"#DIV/0!"}}]
[null,"!!! Warning | enter GWP Total numbers from Tally Excel export (Not from PDF) !!!"]
[null,"Construction GWP Impact | Interior project (Tally output numbers. Set building lifetime in tally to 15 years unless noted otherwise on the Common App_MSR version tab)"]
[null,null,"New",{"$nulls":4},"Salvaged (if applicable)",{"$nulls":4},"New + Salvaged"]
[null,null,"GWP %","GWP Total (kgCO2e)","Conversion of \nkg to lb","lbs per sf",null,"GWP %","GWP Total (kgCO2e)","Conversion of \nkg to lb","lbs per sf",null,"GWP Total (kgCO2e)","Conversion of \nkg to lb","lbs per sf","QA check"]
[null,"03 - Concrete",{"$f":"$D19/$D$26","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(CONVERT($D$19,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$E$19/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},null,{"$f":"I19/$I$26","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(CONVERT($I$19,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$J$19/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},null,{"$f":"$D$19+$I$19","v":{"v":0,"d":"0.000"}},{"$f":"ROUND(CONVERT($M$19,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$N$19/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},{"$f":"$F$6+$K$6","v":{"$error":"#DIV/0!"}}]
[null,"04 - Masonry",{"$f":"$D20/$D$26","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(CONVERT($D$20,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$E$20/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},null,{"$f":"I20/$I$26","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(CONVERT($I$20,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$J$20/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},null,{"$f":"$D$20+$I$20","v":{"v":0,"d":"0.000"}},{"$f":"ROUND(CONVERT($M$20,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$N$20/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},{"$f":"$F$7+$K$7","v":{"$error":"#DIV/0!"}}]
[null,"05 - Metals",{"$f":"$D21/$D$26","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(CONVERT($D$21,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$E$21/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},null,{"$f":"I21/$I$26","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(CONVERT($I$21,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$J$21/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},null,{"$f":"$D$21+$I$21","v":{"v":0,"d":"0.000"}},{"$f":"ROUND(CONVERT($M$21,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$N$21/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},{"$f":"$F$8+$K$8","v":{"$error":"#DIV/0!"}}]
[null,"06 - Wood/Plastics/Composites",{"$f":"$D22/$D$26","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(CONVERT($D$22,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$E$22/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},null,{"$f":"I22/$I$26","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(CONVERT($I$22,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$J$22/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},null,{"$f":"$D$22+$I$22","v":{"v":0,"d":"0.000"}},{"$f":"ROUND(CONVERT($M$22,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$N$22/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},{"$f":"$F$9+$K$9","v":{"$error":"#DIV/0!"}}]
[null,"07 - Thermal and Moisture Protection",{"$f":"$D23/$D$26","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(CONVERT($D$23,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$E$23/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},null,{"$f":"I23/$I$26","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(CONVERT($I$23,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$J$23/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},null,{"$f":"$D$23+$I$23","v":{"v":0,"d":"0.000"}},{"$f":"ROUND(CONVERT($M$23,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$N$23/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},{"$f":"$F$10+$K$10","v":{"$error":"#DIV/0!"}}]
[null,"08 - Openings and Glazing",{"$f":"$D24/$D$26","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(CONVERT($D$24,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$E$24/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},null,{"$f":"I24/$I$26","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(CONVERT($I$24,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$J$24/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},null,{"$f":"$D$24+$I$24","v":{"v":0,"d":"0.000"}},{"$f":"ROUND(CONVERT($M$24,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$N$24/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},{"$f":"$F$11+$K$11","v":{"$error":"#DIV/0!"}}]
[null,"09 - Finishes",{"$error":"#DIV/0!"},null,{"$f":"ROUND(CONVERT($D$25,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$E$25/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},null,{"$f":"ROUND(CONVERT($I$25,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$J$25/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},null,{"$f":"$D$25+$I$25","v":{"v":0,"d":"0.000"}},{"$f":"ROUND(CONVERT($M$25,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$N$25/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},{"$f":"$F$12+$K$12","v":{"$error":"#DIV/0!"}}]
[null,"Total",{"$f":"ROUND(SUM($C$19:$C$25),3)","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(CONVERT($D$26,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$E$26/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(SUM($H$19:$H$25),3)","v":{"$error":"#DIV/0!"}},null,{"$f":"ROUND(CONVERT($I$26,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$J$26/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},null,{"$f":"$D$26+$I$26","v":{"v":0,"d":"0.000"}},{"$f":"ROUND(CONVERT($M$26,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},{"$f":"$N$26/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},{"$f":"$F$13+$K$13","v":{"$error":"#DIV/0!"}}]
[null,"QA check",null,{"$f":"ROUND(SUM($D$19:$D$25),3)","v":{"v":0,"d":"0.000"}},{"$f":"SUM($E$19:$E$25)","v":{"v":0,"d":"0.000"}},{"$f":"SUM($F$19:$F$25)","v":{"$error":"#DIV/0!"}},null,null,{"$f":"ROUND(SUM(I19:I25),3)","v":{"v":0,"d":"0.000"}},{"$f":"SUM($J$19:$J$25)","v":{"v":0,"d":"0.000"}},{"$f":"SUM($K$19:$K$25)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM($M$19:M$25)","v":{"v":0,"d":"0.000"}},{"$f":"ROUND(SUM($N$19:$N$25),3)","v":{"v":0,"d":"0.000"}},{"$f":"SUM($O$19:$O$25)","v":{"$error":"#DIV/0!"}},{"$f":"SUM($P$19:$P$25)","v":{"$error":"#DIV/0!"}}]

{"sheet":"GWP Calculator | Furniture ","index":2,"n_rows":95,"n_cols":26,"rows_kept":95,"merged":[[2,19,2,24],[8,19,8,24],[9,5,9,6],[9,8,9,9],[9,11,9,12],[9,14,9,15],[9,19,9,21],[9,23,9,24],[86,1,87,1],[86,2,87,2],[86,5,86,6],[88,1,88,2],[89,1,89,2],[90,1,90,2],[91,1,91,2],[92,1,92,2],[93,1,93,2],[94,1,94,2],[95,1,95,2],[96,1,96,2],[97,1,97,2],[98,1,98,2],[99,1,99,2],[100,1,100,2],[101,1,101,2],[102,1,102,2],[103,1,103,2],[104,1,104,2],[105,1,105,2],[106,1,106,2],[107,1,107,2],[108,1,108,2],[109,1,109,2],[110,1,110,2],[111,1,111,2],[112,1,112,2],[113,15,114,15]]}
[null,"updated 06/28/2023"]
[]
[null,"GWP Summary | Furniture"]
[null,"GWP per square foot",{"$nulls":17},"Total GWP with QTO, lb CO2e"]
[null,"New furniture",{"$f":"X5/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},"lbs CO2e/sf",{"$nulls":15},"New furniture",{"$nulls":3},{"$f":"$X$83","v":{"v":0,"d":"0.000"}},"lb CO2e"]
[null,"Salvaged furniture",{"$f":"X6/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},"lbs CO2e/sf",{"$nulls":15},"Salvaged furniture",{"$nulls":3},{"$f":"$Y$83","v":{"v":0,"d":"0.000"}},"lb CO2e"]
[null,"New + Salvaged furniture",{"$f":"X7/Area_TotalBuilding","v":{"$error":"#DIV/0!"}},"lbs CO2e/sf",{"$nulls":15},"New + Salvaged furniture",{"$nulls":3},{"$f":"$X$84","v":{"v":0,"d":"0.000"}},"lb CO2e"]
[]
[null,"Furniture ",{"$nulls":6},"Furniture EPD Data Ranges (see notes below)",{"$nulls":10},"GWP Calculator | Furniture"]
[{"$nulls":5},"Quantity of Material ",null,null,"EPD 1",null,null,"EPD 2",null,null,"EPD 3",null,null,"CLF baseline GWP",null,"GWP Averages",{"$nulls":3},"GWP with QTO, lb CO2e"]
[null,"Description","Notes",null,null,"New","Salvaged",null,"Manufacturer","kg CO2e",null,"Manufacturer","kg CO2e",null,"Manufacturer","kg CO2e",null,"kg CO2e",null,"kg CO2e",null,"lb CO2e",null,"New","Salvaged"]
[null,"Chair - Conference","with casters",{"$nulls":5},"Herman Miller",{"v":34.4,"d":"34.40"},null,"Herman Miller",{"v":73,"d":"73.00"},null,"Knoll",{"v":110,"d":"110.00"},{"$nulls":3},{"$f":"AVERAGE(J12,M12,P12)","v":{"v":72.46666666666667,"d":"72.467"}},null,{"$f":"ROUND(CONVERT(T12,\"kg\",\"lbm\"),3)","v":159.762},null,{"$f":"V12*F12","v":{"v":0,"d":"0.000"}},{"$f":"V12*G12","v":{"v":0,"d":"0.000"}}]
[null,"Chair - Task ","with casters and adjustability",{"$nulls":5},"Herman Miller",{"v":75.7,"d":"75.70"},null,"Knoll",{"v":88.3,"d":"88.30"},null,"Steelcase",{"v":106.4,"d":"106.40"},null,{"v":77.8,"d":"77.80"},null,{"$f":"AVERAGE(J13,M13,P13)","v":{"v":90.13333333333333,"d":"90.133"}},null,{"$f":"ROUND(CONVERT(T13,\"kg\",\"lbm\"),3)","v":{"v":198.71,"d":"198.710"}},null,{"$f":"V13*F13","v":{"v":0,"d":"0.000"}},{"$f":"V13*G13","v":{"v":0,"d":"0.000"}}]
[null,"Chair - High Density Stacker","typically 40+ chairs stacking on dolly",{"$nulls":5},"Emeco",{"v":16.3,"d":"16.30"},null,"Howe",{"v":30.6,"d":"30.60"},null,"KI",{"v":48.3,"d":"48.30"},{"$nulls":3},{"v":31.733333333333334,"d":"31.733"},null,{"v":69.96,"d":"69.960"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[null,"Chair - Guest/Study ","poly seat, wood legs",{"$nulls":5},"Emeco",{"v":19,"d":"19.00"},null,"Arper",39.15,null,"Haworth",{"v":53,"d":"53.00"},{"$nulls":3},{"v":37.050000000000004,"d":"37.050"},null,81.681,null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[null,"Chair - Barstool","painted metal base with poly seat",{"$nulls":5},"Emeco",{"v":21,"d":"21.00"},null,"Howe",{"v":38.5,"d":"38.50"},null,"KI",57.17,{"$nulls":3},{"v":38.89,"d":"38.890"},null,85.738,null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[null,"Chair - Stool (18\" seat height)","18\"seat height",{"$nulls":5},"Emeco",8.46,null,"Mark Products",{"v":11,"d":"11.00"},{"$nulls":6},{"v":9.73,"d":"9.730"},null,21.451,null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[null,"Table - Height Adjustable","24\"x36\" typ size",{"$nulls":5},"Teknion",{"v":156,"d":"156.00"},null,"Steelcase",{"v":160,"d":"160.00"},null,"Haworth",{"v":200,"d":"200.00"},{"$nulls":3},{"v":172,"d":"172.000"},null,379.195,null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[null,"Table - Conference/Study Table","36\"x72\" typ size",{"$nulls":5},"Haworth",{"v":130,"d":"130.00"},null,"Steelcase",{"v":190,"d":"190.00"},null,"Gunlocke",{"v":310,"d":"310.00"},null,{"v":134,"d":"134.00"},null,{"v":210,"d":"210.000"},null,462.971,null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[null,"Table - Flip Top","flip top with casters",{"$nulls":5},"Howe",{"v":79.3,"d":"79.30"},null,"KI",{"v":110,"d":"110.00"},null,"KI",{"v":130,"d":"130.00"},{"$nulls":3},{"v":106.43333333333334,"d":"106.433"},null,234.645,null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[null,"Table - Laptop","wood or metal base with lam or quartz top",{"$nulls":5},"Arper",{"v":50,"d":"50.00"},{"$nulls":9},{"v":50,"d":"50.000"},null,110.231,null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[null,"Table - Coffee/Occasional Table ","wood or metal base with lam or quartz top",{"$nulls":5},"Koleksiyon",{"v":66,"d":"66.00"},null,"Haworth",{"v":180,"d":"180.00"},null,"Haworth",{"v":270,"d":"270.00"},{"$nulls":3},{"v":172,"d":"172.000"},null,379.195,null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[null,"Workstation - 6x6 Station","6' x 6' floor plate desk configuration (L shaped)",{"$nulls":5},"Teknion",{"v":105,"d":"105.00"},null,"Haworth",{"v":300,"d":"300.00"},null,"Knoll",{"v":572,"d":"572.00"},null,{"v":435,"d":"435.00"},null,{"v":325.6666666666667,"d":"325.667"},null,717.972,null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[null,"Workstation - Private Office","L shaped with wall mounted elements",{"$nulls":5},"Knoll",{"v":208,"d":"208.00"},null,"Gunlocke",{"v":220,"d":"220.00"},null,"Haworth",{"v":570,"d":"570.00"},null,{"v":489,"d":"489.00"},null,{"v":332.6666666666667,"d":"332.667"},null,733.404,null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[null,"Lounge - 3-seat Sofa","3 seat upholstered sofa",{"$nulls":5},"Haworth",{"v":89,"d":"89.00"},null,"Koleksiyon",{"v":309,"d":"309.00"},null,"ForaForm",{"v":364,"d":"364.00"},null,{"v":98.2,"d":"98.20"},null,{"v":254,"d":"254.000"},null,559.974,null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[null,"Lounge - Ottoman","small ottoman/pouf",{"$nulls":5},"ForaForm",{"v":24,"d":"24.00"},null,"Koleksiyon",{"v":40,"d":"40.00"},null,"Haworth",{"v":75,"d":"75.00"},{"$nulls":3},{"v":46.333333333333336,"d":"46.333"},null,102.148,null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[null,"Lounge - Highback","wood or metal base with upholstered seat and back",{"$nulls":5},"Vitra",{"v":152,"d":"152.00"},null,"Vitra",{"v":270,"d":"270.00"},null,"ForaForm",{"v":262.3,"d":"262.30"},{"$nulls":3},{"v":228.1,"d":"228.100"},null,502.874,null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[null,"Lounge - Low/Mid Back","wood or metal base with upholstered seat and back",{"$nulls":5},"Haworth",{"v":120,"d":"120.00"},null,"Haworth",{"v":150,"d":"150.00"},null,"KI",{"v":170,"d":"170.00"},{"$nulls":3},{"v":146.66666666666666,"d":"146.667"},null,323.345,null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[null,"Shelving - 66\"H Double Face Shelving ","welded frame unit",{"$nulls":6},{"v":0,"d":"0.00"},null,"MSR Design STUDY VIA TALLY - modeled after Estey product",{"$nulls":3},{"v":217.5,"d":"217.50"},{"$nulls":3},{"$f":"P29","v":{"v":217.5,"d":"217.500"}},null,479.505,null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[null,"Shelving - 66\"H Single Face Shelving","welded frame unit",{"$nulls":6},{"v":0,"d":"0.00"},null,"MSR Design STUDY VIA TALLY - modeled after Estey product",{"$nulls":3},124.29,{"$nulls":3},{"$f":"P30","v":{"v":124.29,"d":"124.290"}},null,274.013,null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[null,"Shelving - Metal Typical End Panel","66\"H End panel",{"$nulls":6},{"v":0,"d":"0.00"},null,"MSR Design STUDY VIA TALLY - modeled after Estey product",{"$nulls":3},54.22,{"$nulls":3},{"$f":"P31","v":{"v":54.22,"d":"54.220"}},null,119.535,null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[null,"Shelving - Metal Typical Canopy Top",{"$nulls":7},{"v":0,"d":"0.00"},null,"MSR Design STUDY VIA TALLY - modeled after Estey product",{"$nulls":3},{"v":26.3,"d":"26.30"},{"$nulls":3},{"v":13.15,"d":"13.150"},null,28.991,null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[null,"add additional furniture as needed",{"$nulls":7},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"$f":"AVERAGE(J77,M77,P77)","v":{"v":0,"d":"0.000"}},null,{"$f":"ROUND(CONVERT(T77,\"kg\",\"lbm\"),3)","v":{"v":0,"d":"0.000"}},null,{"$f":"V77*F77","v":{"v":0,"d":"0.000"}},{"$f":"V77*G77","v":{"v":0,"d":"0.000"}}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":9},{"v":0,"d":"0.00"},{"$nulls":9},{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[]
[{"$nulls":21},"GWP total ",null,{"$f":"SUM($X$12:X82)","v":{"v":0,"d":"0.000"}},{"$f":"SUM($Y$12:Y82)","v":{"v":0,"d":"0.000"}}]
[{"$nulls":21},"Total GWP (New + Salvaged)",null,{"$f":"X83+Y83","v":{"v":0,"d":"0.000"}}]
[]
[null,"Furniture not accounted for",{"$nulls":6},"Furniture EPD Data Ranges Notes"]
[null,"Description",{"$nulls":3},"Quantity of Material ",null,null,"if only one EPD is listed for an item DO NOT PLACE \"0\" in columns for EPD 2 and 3"]
[{"$nulls":5},"New","Salvaged",null,"Documents with this color have a different naming system than EPD",{"$nulls":8},"(to change the color above use Format Painter)",{"$nulls":7},"`"]
[null,"Layout Carts",{"$nulls":6},"Documents with this color comes from outside of North America",{"$nulls":8},"(to change the color above use Format Painter)"]
[null,"Book Carts",{"$nulls":6},"Documents with this color are being recertified",{"$nulls":8},"(to change the color above use Format Painter)"]
[null,"Millwork Islands",{"$nulls":6},"Environmental impact uses Green House Gas Equivalency Calculator "]
[null,"Reception Desk"]
[null,"planter"]
[null,"Plant Pots"]
[null,"Modular Shelving Units"]

{"sheet":"GWP Calculator | Casework ","index":3,"n_rows":135,"n_cols":16,"rows_kept":135,"merged":[[4,11,4,12],[10,3,10,4],[10,8,10,9],[10,11,10,12]]}
[null,"updated 10/07/2024"]
[null,"Enter building area"]
[]
[null,"Total GWP Summary | Casework"]
[{"$nulls":3},"kg CO2e","kg CO2e per SF"]
[null,"New casework",null,{"$f":"SUMIF(O:O,\"ngwp\",L:L)","v":{"v":0,"d":"0.00"}},{"$f":"D6/$D$2","v":{"$error":"#DIV/0!"}}]
[null,"Salvaged casework",null,{"$f":"SUMIF(P:P,\"sgwp\",M:M)","v":{"v":0,"d":"0.00"}},{"$f":"D7/$D$2","v":{"$error":"#DIV/0!"}}]
[null,"New + Salvaged casework",null,{"$f":"D6+D7","v":{"v":0,"d":"0.00"}},{"$f":"D8/$D$2","v":{"$error":"#DIV/0!"}}]
[]
[null,"GWP Calculator | Casework Group Breakout",{"$nulls":12},"used for formula do not delete"]
[{"$nulls":3},"Casework and Countertop Materials",{"$nulls":4},"GWP per LF, kg CO2e",null,null,"Subtotal GWP with QTO, kg CO2e"]
[{"$nulls":3},"New","Salvaged",null,"enter QTO in LF",null,"New ","Salvaged",null,"New","Salvaged"]
[]
[null,"Casework Group 1 ","input group description here",{"$nulls":8},{"$f":"SUM(L15:L18)","v":{"v":0,"d":"0.000"}},{"$f":"SUM(M15:M18)","v":{"v":0,"d":"0.000"}},null,"ngwp","sgwp"]
[null,"base cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D15,'Tally Casework Outputs'!$P$3:$Q$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E15,'Tally Casework Outputs'!$P$3:$Q$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"$f":"G15*I15","v":{"v":0,"d":"0.000"}},{"$f":"J15*G15","v":{"v":0,"d":"0.000"}}]
[null,"upper cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D16,'Tally Casework Outputs'!$S$3:$T$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E16,'Tally Casework Outputs'!$S$3:$T$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"$f":"G16*I16","v":{"v":0,"d":"0.000"}},{"$f":"J16*G16","v":{"v":0,"d":"0.000"}}]
[null,"tall cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D17,'Tally Casework Outputs'!$V$3:$W$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E17,'Tally Casework Outputs'!$V$3:$W$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"v":0,"d":"0.000"},{"$f":"J17*G17","v":{"v":0,"d":"0.000"}}]
[null,"countertop",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D18,'Tally Casework Outputs'!$Y$3:$Z$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E18,'Tally Casework Outputs'!$Y$3:$Z$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[]
[null,"Casework Group 2","input group description here",{"$nulls":8},{"$f":"SUM(L21:L24)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(M21:M24)","v":{"v":0,"d":"0.00"}},null,"ngwp","sgwp"]
[null,"base cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D21,'Tally Casework Outputs'!$P$3:$Q$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E21,'Tally Casework Outputs'!$P$3:$Q$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"$f":"G21*I21","v":{"v":0,"d":"0.000"}},{"$f":"J21*G21","v":{"v":0,"d":"0.000"}}]
[null,"upper cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D22,'Tally Casework Outputs'!$S$3:$T$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E22,'Tally Casework Outputs'!$S$3:$T$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"$f":"G22*I22","v":{"v":0,"d":"0.000"}},{"$f":"J22*G22","v":{"v":0,"d":"0.000"}}]
[null,"tall cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D23,'Tally Casework Outputs'!$V$3:$W$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E23,'Tally Casework Outputs'!$V$3:$W$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[null,"countertop",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D24,'Tally Casework Outputs'!$Y$3:$Z$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E24,'Tally Casework Outputs'!$Y$3:$Z$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[]
[null,"Casework Group 3","input group description here",{"$nulls":8},{"$f":"SUM(L27:L30)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(M27:M30)","v":{"v":0,"d":"0.00"}},null,"ngwp","sgwp"]
[null,"base cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D27,'Tally Casework Outputs'!$P$3:$Q$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E27,'Tally Casework Outputs'!$P$3:$Q$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"$f":"G27*I27","v":{"v":0,"d":"0.000"}},{"$f":"J27*G27","v":{"v":0,"d":"0.000"}}]
[null,"upper cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D28,'Tally Casework Outputs'!$S$3:$T$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E28,'Tally Casework Outputs'!$S$3:$T$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"$f":"G28*I28","v":{"v":0,"d":"0.000"}},{"$f":"J28*G28","v":{"v":0,"d":"0.000"}}]
[null,"tall cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D29,'Tally Casework Outputs'!$V$3:$W$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E29,'Tally Casework Outputs'!$V$3:$W$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[null,"countertop",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D30,'Tally Casework Outputs'!$Y$3:$Z$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E30,'Tally Casework Outputs'!$Y$3:$Z$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[]
[null,"Casework Group 4 ","input group description here",{"$nulls":8},{"$f":"SUM(L33:L36)","v":{"v":0,"d":"0.000"}},{"$f":"SUM(M33:M36)","v":{"v":0,"d":"0.000"}},null,"ngwp","sgwp"]
[null,"base cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D33,'Tally Casework Outputs'!$P$3:$Q$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E33,'Tally Casework Outputs'!$P$3:$Q$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"$f":"G33*I33","v":{"v":0,"d":"0.000"}},{"$f":"J33*G33","v":{"v":0,"d":"0.000"}}]
[null,"upper cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D34,'Tally Casework Outputs'!$S$3:$T$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E34,'Tally Casework Outputs'!$S$3:$T$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"$f":"G34*I34","v":{"v":0,"d":"0.000"}},{"$f":"J34*G34","v":{"v":0,"d":"0.000"}}]
[null,"tall cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D35,'Tally Casework Outputs'!$V$3:$W$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E35,'Tally Casework Outputs'!$V$3:$W$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"v":0,"d":"0.000"},{"$f":"J35*G35","v":{"v":0,"d":"0.000"}}]
[null,"countertop",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D36,'Tally Casework Outputs'!$Y$3:$Z$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E36,'Tally Casework Outputs'!$Y$3:$Z$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[]
[null,"Casework Group 5","input group description here",{"$nulls":8},{"$f":"SUM(L39:L42)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(M39:M42)","v":{"v":0,"d":"0.00"}},null,"ngwp","sgwp"]
[null,"base cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D39,'Tally Casework Outputs'!$P$3:$Q$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E39,'Tally Casework Outputs'!$P$3:$Q$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"$f":"G39*I39","v":{"v":0,"d":"0.000"}},{"$f":"J39*G39","v":{"v":0,"d":"0.000"}}]
[null,"upper cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D40,'Tally Casework Outputs'!$S$3:$T$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E40,'Tally Casework Outputs'!$S$3:$T$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"$f":"G40*I40","v":{"v":0,"d":"0.000"}},{"$f":"J40*G40","v":{"v":0,"d":"0.000"}}]
[null,"tall cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D41,'Tally Casework Outputs'!$V$3:$W$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E41,'Tally Casework Outputs'!$V$3:$W$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[null,"countertop",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D42,'Tally Casework Outputs'!$Y$3:$Z$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E42,'Tally Casework Outputs'!$Y$3:$Z$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[]
[null,"Casework Group 6","input group description here",{"$nulls":8},{"$f":"SUM(L45:L48)","v":{"v":0,"d":"0.000"}},{"$f":"SUM(M45:M48)","v":{"v":0,"d":"0.000"}},null,"ngwp","sgwp"]
[null,"base cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D45,'Tally Casework Outputs'!$P$3:$Q$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E45,'Tally Casework Outputs'!$P$3:$Q$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"$f":"G45*I45","v":{"v":0,"d":"0.000"}},{"$f":"J45*G45","v":{"v":0,"d":"0.000"}}]
[null,"upper cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D46,'Tally Casework Outputs'!$S$3:$T$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E46,'Tally Casework Outputs'!$S$3:$T$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"$f":"G46*I46","v":{"v":0,"d":"0.000"}},{"$f":"J46*G46","v":{"v":0,"d":"0.000"}}]
[null,"tall cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D47,'Tally Casework Outputs'!$V$3:$W$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E47,'Tally Casework Outputs'!$V$3:$W$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"v":0,"d":"0.000"},{"$f":"J47*G47","v":{"v":0,"d":"0.000"}}]
[null,"countertop",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D48,'Tally Casework Outputs'!$Y$3:$Z$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E48,'Tally Casework Outputs'!$Y$3:$Z$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[]
[null,"Casework Group 7","input group description here",{"$nulls":8},{"$f":"SUM(L51:L54)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(M51:M54)","v":{"v":0,"d":"0.00"}},null,"ngwp","sgwp"]
[null,"base cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D51,'Tally Casework Outputs'!$P$3:$Q$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E51,'Tally Casework Outputs'!$P$3:$Q$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"$f":"G51*I51","v":{"v":0,"d":"0.000"}},{"$f":"J51*G51","v":{"v":0,"d":"0.000"}}]
[null,"upper cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D52,'Tally Casework Outputs'!$S$3:$T$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E52,'Tally Casework Outputs'!$S$3:$T$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"$f":"G52*I52","v":{"v":0,"d":"0.000"}},{"$f":"J52*G52","v":{"v":0,"d":"0.000"}}]
[null,"tall cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D53,'Tally Casework Outputs'!$V$3:$W$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E53,'Tally Casework Outputs'!$V$3:$W$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[null,"countertop",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D54,'Tally Casework Outputs'!$Y$3:$Z$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E54,'Tally Casework Outputs'!$Y$3:$Z$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[]
[null,"Casework Group 8","input group description here",{"$nulls":8},{"$f":"SUM(L57:L60)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(M57:M60)","v":{"v":0,"d":"0.00"}},null,"ngwp","sgwp"]
[null,"base cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D57,'Tally Casework Outputs'!$P$3:$Q$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E57,'Tally Casework Outputs'!$P$3:$Q$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"$f":"G57*I57","v":{"v":0,"d":"0.000"}},{"$f":"J57*G57","v":{"v":0,"d":"0.000"}}]
[null,"upper cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D58,'Tally Casework Outputs'!$S$3:$T$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E58,'Tally Casework Outputs'!$S$3:$T$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"$f":"G58*I58","v":{"v":0,"d":"0.000"}},{"$f":"J58*G58","v":{"v":0,"d":"0.000"}}]
[null,"tall cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D59,'Tally Casework Outputs'!$V$3:$W$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E59,'Tally Casework Outputs'!$V$3:$W$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[null,"countertop",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D60,'Tally Casework Outputs'!$Y$3:$Z$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E60,'Tally Casework Outputs'!$Y$3:$Z$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[]
[null,"Casework Group 9","input group description here",{"$nulls":8},{"$f":"SUM(L63:L66)","v":{"v":0,"d":"0.000"}},{"$f":"SUM(M63:M66)","v":{"v":0,"d":"0.000"}},null,"ngwp","sgwp"]
[null,"base cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D63,'Tally Casework Outputs'!$P$3:$Q$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E63,'Tally Casework Outputs'!$P$3:$Q$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"$f":"G63*I63","v":{"v":0,"d":"0.000"}},{"$f":"J63*G63","v":{"v":0,"d":"0.000"}}]
[null,"upper cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D64,'Tally Casework Outputs'!$S$3:$T$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E64,'Tally Casework Outputs'!$S$3:$T$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"$f":"G64*I64","v":{"v":0,"d":"0.000"}},{"$f":"J64*G64","v":{"v":0,"d":"0.000"}}]
[null,"tall cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D65,'Tally Casework Outputs'!$V$3:$W$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E65,'Tally Casework Outputs'!$V$3:$W$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"v":0,"d":"0.000"},{"$f":"J65*G65","v":{"v":0,"d":"0.000"}}]
[null,"countertop",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D66,'Tally Casework Outputs'!$Y$3:$Z$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E66,'Tally Casework Outputs'!$Y$3:$Z$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[]
[null,"Casework Group 10","input group description here",{"$nulls":8},{"$f":"SUM(L69:L72)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(M69:M72)","v":{"v":0,"d":"0.00"}},null,"ngwp","sgwp"]
[null,"base cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D69,'Tally Casework Outputs'!$P$3:$Q$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E69,'Tally Casework Outputs'!$P$3:$Q$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"$f":"G69*I69","v":{"v":0,"d":"0.000"}},{"$f":"J69*G69","v":{"v":0,"d":"0.000"}}]
[null,"upper cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D70,'Tally Casework Outputs'!$S$3:$T$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E70,'Tally Casework Outputs'!$S$3:$T$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"$f":"G70*I70","v":{"v":0,"d":"0.000"}},{"$f":"J70*G70","v":{"v":0,"d":"0.000"}}]
[null,"tall cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D71,'Tally Casework Outputs'!$V$3:$W$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E71,'Tally Casework Outputs'!$V$3:$W$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[null,"countertop",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D72,'Tally Casework Outputs'!$Y$3:$Z$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E72,'Tally Casework Outputs'!$Y$3:$Z$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[]
[null,"Casework Group 11 ","input group description here",{"$nulls":8},{"$f":"SUM(L75:L78)","v":{"v":0,"d":"0.000"}},{"$f":"SUM(M75:M78)","v":{"v":0,"d":"0.000"}},null,"ngwp","sgwp"]
[null,"base cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D75,'Tally Casework Outputs'!$P$3:$Q$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E75,'Tally Casework Outputs'!$P$3:$Q$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"$f":"G75*I75","v":{"v":0,"d":"0.000"}},{"$f":"J75*G75","v":{"v":0,"d":"0.000"}}]
[null,"upper cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D76,'Tally Casework Outputs'!$S$3:$T$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E76,'Tally Casework Outputs'!$S$3:$T$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"$f":"G76*I76","v":{"v":0,"d":"0.000"}},{"$f":"J76*G76","v":{"v":0,"d":"0.000"}}]
[null,"tall cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D77,'Tally Casework Outputs'!$V$3:$W$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E77,'Tally Casework Outputs'!$V$3:$W$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"v":0,"d":"0.000"},{"$f":"J77*G77","v":{"v":0,"d":"0.000"}}]
[null,"countertop",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D78,'Tally Casework Outputs'!$Y$3:$Z$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E78,'Tally Casework Outputs'!$Y$3:$Z$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[]
[null,"Casework Group 12","input group description here",{"$nulls":8},{"$f":"SUM(L81:L84)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(M81:M84)","v":{"v":0,"d":"0.00"}},null,"ngwp","sgwp"]
[null,"base cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D81,'Tally Casework Outputs'!$P$3:$Q$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E81,'Tally Casework Outputs'!$P$3:$Q$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"$f":"G81*I81","v":{"v":0,"d":"0.000"}},{"$f":"J81*G81","v":{"v":0,"d":"0.000"}}]
[null,"upper cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D82,'Tally Casework Outputs'!$S$3:$T$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E82,'Tally Casework Outputs'!$S$3:$T$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"$f":"G82*I82","v":{"v":0,"d":"0.000"}},{"$f":"J82*G82","v":{"v":0,"d":"0.000"}}]
[null,"tall cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D83,'Tally Casework Outputs'!$V$3:$W$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E83,'Tally Casework Outputs'!$V$3:$W$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[null,"countertop",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D84,'Tally Casework Outputs'!$Y$3:$Z$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E84,'Tally Casework Outputs'!$Y$3:$Z$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[]
[null,"Casework Group 13","input group description here",{"$nulls":8},{"$f":"SUM(L87:L90)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(M87:M90)","v":{"v":0,"d":"0.00"}},null,"ngwp","sgwp"]
[null,"base cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D87,'Tally Casework Outputs'!$P$3:$Q$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E87,'Tally Casework Outputs'!$P$3:$Q$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"$f":"G87*I87","v":{"v":0,"d":"0.000"}},{"$f":"J87*G87","v":{"v":0,"d":"0.000"}}]
[null,"upper cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D88,'Tally Casework Outputs'!$S$3:$T$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E88,'Tally Casework Outputs'!$S$3:$T$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"$f":"G88*I88","v":{"v":0,"d":"0.000"}},{"$f":"J88*G88","v":{"v":0,"d":"0.000"}}]
[null,"tall cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D89,'Tally Casework Outputs'!$V$3:$W$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E89,'Tally Casework Outputs'!$V$3:$W$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[null,"countertop",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D90,'Tally Casework Outputs'!$Y$3:$Z$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E90,'Tally Casework Outputs'!$Y$3:$Z$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[]
[null,"Casework Group 14 ","input group description here",{"$nulls":8},{"$f":"SUM(L93:L96)","v":{"v":0,"d":"0.000"}},{"$f":"SUM(M93:M96)","v":{"v":0,"d":"0.000"}},null,"ngwp","sgwp"]
[null,"base cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D93,'Tally Casework Outputs'!$P$3:$Q$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E93,'Tally Casework Outputs'!$P$3:$Q$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"$f":"G93*I93","v":{"v":0,"d":"0.000"}},{"$f":"J93*G93","v":{"v":0,"d":"0.000"}}]
[null,"upper cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D94,'Tally Casework Outputs'!$S$3:$T$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E94,'Tally Casework Outputs'!$S$3:$T$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"$f":"G94*I94","v":{"v":0,"d":"0.000"}},{"$f":"J94*G94","v":{"v":0,"d":"0.000"}}]
[null,"tall cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D95,'Tally Casework Outputs'!$V$3:$W$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E95,'Tally Casework Outputs'!$V$3:$W$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"v":0,"d":"0.000"},{"$f":"J95*G95","v":{"v":0,"d":"0.000"}}]
[null,"countertop",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D96,'Tally Casework Outputs'!$Y$3:$Z$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E96,'Tally Casework Outputs'!$Y$3:$Z$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[]
[null,"Casework Group 15","input group description here",{"$nulls":8},{"$f":"SUM(L99:L102)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(M99:M102)","v":{"v":0,"d":"0.00"}},null,"ngwp","sgwp"]
[null,"base cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D99,'Tally Casework Outputs'!$P$3:$Q$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E99,'Tally Casework Outputs'!$P$3:$Q$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"$f":"G99*I99","v":{"v":0,"d":"0.000"}},{"$f":"J99*G99","v":{"v":0,"d":"0.000"}}]
[null,"upper cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D100,'Tally Casework Outputs'!$S$3:$T$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E100,'Tally Casework Outputs'!$S$3:$T$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"$f":"G100*I100","v":{"v":0,"d":"0.000"}},{"$f":"J100*G100","v":{"v":0,"d":"0.000"}}]
[null,"tall cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D101,'Tally Casework Outputs'!$V$3:$W$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E101,'Tally Casework Outputs'!$V$3:$W$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[null,"countertop",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D102,'Tally Casework Outputs'!$Y$3:$Z$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E102,'Tally Casework Outputs'!$Y$3:$Z$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[]
[null,"Casework Group 16","input group description here",{"$nulls":8},{"$f":"SUM(L105:L108)","v":{"v":0,"d":"0.000"}},{"$f":"SUM(M105:M108)","v":{"v":0,"d":"0.000"}},null,"ngwp","sgwp"]
[null,"base cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D105,'Tally Casework Outputs'!$P$3:$Q$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E105,'Tally Casework Outputs'!$P$3:$Q$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"$f":"G105*I105","v":{"v":0,"d":"0.000"}},{"$f":"J105*G105","v":{"v":0,"d":"0.000"}}]
[null,"upper cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D106,'Tally Casework Outputs'!$S$3:$T$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E106,'Tally Casework Outputs'!$S$3:$T$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"$f":"G106*I106","v":{"v":0,"d":"0.000"}},{"$f":"J106*G106","v":{"v":0,"d":"0.000"}}]
[null,"tall cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D107,'Tally Casework Outputs'!$V$3:$W$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E107,'Tally Casework Outputs'!$V$3:$W$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"v":0,"d":"0.000"},{"$f":"J107*G107","v":{"v":0,"d":"0.000"}}]
[null,"countertop",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D108,'Tally Casework Outputs'!$Y$3:$Z$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E108,'Tally Casework Outputs'!$Y$3:$Z$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[]
[null,"Casework Group 17","input group description here",{"$nulls":8},{"$f":"SUM(L111:L114)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(M111:M114)","v":{"v":0,"d":"0.00"}},null,"ngwp","sgwp"]
[null,"base cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D111,'Tally Casework Outputs'!$P$3:$Q$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E111,'Tally Casework Outputs'!$P$3:$Q$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"$f":"G111*I111","v":{"v":0,"d":"0.000"}},{"$f":"J111*G111","v":{"v":0,"d":"0.000"}}]
[null,"upper cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D112,'Tally Casework Outputs'!$S$3:$T$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E112,'Tally Casework Outputs'!$S$3:$T$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"$f":"G112*I112","v":{"v":0,"d":"0.000"}},{"$f":"J112*G112","v":{"v":0,"d":"0.000"}}]
[null,"tall cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D113,'Tally Casework Outputs'!$V$3:$W$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E113,'Tally Casework Outputs'!$V$3:$W$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[null,"countertop",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D114,'Tally Casework Outputs'!$Y$3:$Z$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E114,'Tally Casework Outputs'!$Y$3:$Z$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[]
[null,"Casework Group 18","input group description here",{"$nulls":8},{"$f":"SUM(L117:L120)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(M117:M120)","v":{"v":0,"d":"0.00"}},null,"ngwp","sgwp"]
[null,"base cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D117,'Tally Casework Outputs'!$P$3:$Q$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E117,'Tally Casework Outputs'!$P$3:$Q$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"$f":"G117*I117","v":{"v":0,"d":"0.000"}},{"$f":"J117*G117","v":{"v":0,"d":"0.000"}}]
[null,"upper cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D118,'Tally Casework Outputs'!$S$3:$T$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E118,'Tally Casework Outputs'!$S$3:$T$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"$f":"G118*I118","v":{"v":0,"d":"0.000"}},{"$f":"J118*G118","v":{"v":0,"d":"0.000"}}]
[null,"tall cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D119,'Tally Casework Outputs'!$V$3:$W$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E119,'Tally Casework Outputs'!$V$3:$W$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[null,"countertop",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D120,'Tally Casework Outputs'!$Y$3:$Z$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E120,'Tally Casework Outputs'!$Y$3:$Z$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[]
[null,"Casework Group 19","input group description here",{"$nulls":8},{"$f":"SUM(L123:L126)","v":{"v":0,"d":"0.000"}},{"$f":"SUM(M123:M126)","v":{"v":0,"d":"0.000"}},null,"ngwp","sgwp"]
[null,"base cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D123,'Tally Casework Outputs'!$P$3:$Q$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E123,'Tally Casework Outputs'!$P$3:$Q$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"$f":"G123*I123","v":{"v":0,"d":"0.000"}},{"$f":"J123*G123","v":{"v":0,"d":"0.000"}}]
[null,"upper cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D124,'Tally Casework Outputs'!$S$3:$T$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E124,'Tally Casework Outputs'!$S$3:$T$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"$f":"G124*I124","v":{"v":0,"d":"0.000"}},{"$f":"J124*G124","v":{"v":0,"d":"0.000"}}]
[null,"tall cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D125,'Tally Casework Outputs'!$V$3:$W$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E125,'Tally Casework Outputs'!$V$3:$W$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"v":0,"d":"0.000"},{"$f":"J125*G125","v":{"v":0,"d":"0.000"}}]
[null,"countertop",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D126,'Tally Casework Outputs'!$Y$3:$Z$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E126,'Tally Casework Outputs'!$Y$3:$Z$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[]
[null,"Casework Group 20","input group description here",{"$nulls":8},{"$f":"SUM(L129:L132)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(M129:M132)","v":{"v":0,"d":"0.00"}},null,"ngwp","sgwp"]
[null,"base cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D129,'Tally Casework Outputs'!$P$3:$Q$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E129,'Tally Casework Outputs'!$P$3:$Q$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"$f":"G129*I129","v":{"v":0,"d":"0.000"}},{"$f":"J129*G129","v":{"v":0,"d":"0.000"}}]
[null,"upper cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D130,'Tally Casework Outputs'!$S$3:$T$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E130,'Tally Casework Outputs'!$S$3:$T$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"$f":"G130*I130","v":{"v":0,"d":"0.000"}},{"$f":"J130*G130","v":{"v":0,"d":"0.000"}}]
[null,"tall cabinets",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D131,'Tally Casework Outputs'!$V$3:$W$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E131,'Tally Casework Outputs'!$V$3:$W$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[null,"countertop",null,"N/A","N/A",{"$nulls":3},{"$f":"VLOOKUP(D132,'Tally Casework Outputs'!$Y$3:$Z$17,2,0)","v":{"v":0,"d":"0.000"}},{"$f":"VLOOKUP(E132,'Tally Casework Outputs'!$Y$3:$Z$17,2,0)","v":{"v":0,"d":"0.000"}},null,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[]
[{"$nulls":9},"GWP total",null,{"$f":"SUMIF(O:O,\"ngwp\",L:L)","v":{"v":0,"d":"0.000"}},{"$f":"SUMIF(P:P,\"sgwp\",M:M)","v":{"v":0,"d":"0.000"}}]
[{"$nulls":9},"New + Salvaged",null,{"$f":"L134+M134","v":{"v":0,"d":"0.000"}}]

{"sheet":"Sustainability Metrics Sheet","index":4,"n_rows":51,"n_cols":7,"rows_kept":51}
[null,"updated 06/28/2023"]
[null,"Project Embodied Carbon Graphs (New & Reno)"]
[null,"GWP Summary tab"]
[null,"Project Embodied Carbon  (New & Reno)",null,null,"QA"]
[null,"this is reading from \"Impact compared to total project\" column in GWP Summary tab"]
[null,"black dash","Salvaged",{"$f":"'GWP Project Summary'!$H$45","v":{"$error":"#DIV/0!"}}]
[null,"blue-lightest (231-249-250)","09 - Finishes",{"$f":"'GWP Project Summary'!$H$39","v":{"$error":"#DIV/0!"}}]
[null,"blue-lighter (170-237-240)","08 - Openings and Glazing",{"$f":"'GWP Project Summary'!$H$34","v":{"$error":"#DIV/0!"}}]
[null,"blue (80-210-220)","07 - Thermal and Moisture Protection",{"$f":"'GWP Project Summary'!$H$29","v":{"$error":"#DIV/0!"}}]
[null,"39-184-195","06 - Wood/Plastics/Composites",{"$f":"'GWP Project Summary'!$H$24","v":{"$error":"#DIV/0!"}}]
[null,"blue-darker (32-150-159)","05 - Metals",{"$f":"'GWP Project Summary'!$H$19","v":{"$error":"#DIV/0!"}}]
[null,"27-127-135","04 - Masonry",{"$f":"'GWP Project Summary'!$H$14","v":{"$error":"#DIV/0!"}},{"$f":"$D$6","v":{"$error":"#DIV/0!"}}]
[null,"blue-darkest (23-108-115)","03 - Concrete",{"$f":"'GWP Project Summary'!$H$9","v":{"$error":"#DIV/0!"}},{"$f":"SUM($D$7:$D$13)","v":{"$error":"#DIV/0!"}}]
[null,null,"total",{"$f":"SUM($D$5:$D$13)","v":{"$error":"#DIV/0!"}},{"$f":"SUM($E$5:$E$13)","v":{"$error":"#DIV/0!"}}]
[]
[]
[null,"Project Embodied Carbon  (Interior)"]
[null,"GWP Summary tab"]
[null,null,"GWP new vs salvaged"]
[null,"black dash","Salvaged material",{"$f":"'GWP Project Summary'!$P$63","v":{"$error":"#DIV/0!"}}]
[null,"blue-darkest (23-108-115)","New material",{"$f":"'GWP Project Summary'!$P$62","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"GWP per group"]
[null,"green - lightest (228-235-194)","Furniture",{"$f":"'GWP Project Summary'!$R$56","v":{"$error":"#DIV/0!"}},{"$f":"ROUND('GWP Project Summary'!$R$56,3)","v":{"$error":"#DIV/0!"}}]
[null,"green (175-195-70)","Casework",{"$f":"'GWP Project Summary'!$R$51","v":{"$error":"#DIV/0!"}},{"$f":"ROUND('GWP Project Summary'!$R$51,3)","v":{"$error":"#DIV/0!"}}]
[null,"blue-darkest (23-108-115)","Construction Material",{"$f":"'GWP Project Summary'!$R$46","v":{"$error":"#DIV/0!"}},{"$f":"ROUND('GWP Project Summary'!$R$46,3)","v":{"$error":"#DIV/0!"}}]
[{"$nulls":3},{"$f":"SUM($D$24:$D$26)","v":{"$error":"#DIV/0!"}},{"$f":"SUM($D$24:$D$26)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"GWP new vs salvaged Summary"]
[null,"black dash","salvaged furniture",{"$f":"'GWP Project Summary'!$R$55","v":{"$error":"#DIV/0!"}},{"$f":"ROUND('GWP Project Summary'!$R$55,3)","v":{"$error":"#DIV/0!"}}]
[null,"green - lightest (228-235-194)","new furniture",{"$f":"'GWP Project Summary'!$R$54","v":{"$error":"#DIV/0!"}},{"$f":"ROUND('GWP Project Summary'!$R$54,3)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(SUM($E$30:$E$31),3)","v":{"$error":"#DIV/0!"}}]
[null,"black dash","salvaged casework",{"$f":"'GWP Project Summary'!$R$50","v":{"$error":"#DIV/0!"}},{"$f":"ROUND('GWP Project Summary'!$R$50,3)","v":{"$error":"#DIV/0!"}}]
[null,"green (175-195-70)","new casework",{"$f":"'GWP Project Summary'!$R$49","v":{"$error":"#DIV/0!"}},{"$f":"ROUND('GWP Project Summary'!$R$49,3)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(SUM($E$32:$E$33),3)","v":{"$error":"#DIV/0!"}}]
[null,"black dash","salvaged construction material",{"$f":"'GWP Project Summary'!$R$45","v":{"$error":"#DIV/0!"}},{"$f":"ROUND('GWP Project Summary'!$R$45,3)","v":{"$error":"#DIV/0!"}}]
[null,"blue-darkest (23-108-115)","new construction material",{"$f":"'GWP Project Summary'!$R$44","v":{"$error":"#DIV/0!"}},{"$f":"ROUND('GWP Project Summary'!$R$44,3)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(SUM($E$34:$E$35),3)","v":{"$error":"#DIV/0!"}}]
[null,null,"total",{"$f":"SUM($D$30:$D$35)","v":{"$error":"#DIV/0!"}},{"$f":"SUM($E$30:$E$35)","v":{"$error":"#DIV/0!"}},{"$f":"SUM($F$30:$F$35)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Construction Material Breakdown"]
[null,"black dash","salvaged furniture",{"$f":"'GWP Project Summary'!$R$55","v":{"$error":"#DIV/0!"}},{"$f":"ROUND('GWP Project Summary'!$R$55,3)","v":{"$error":"#DIV/0!"}},{"$f":"D39+D41+D43","v":{"$error":"#DIV/0!"}},"total Salvaged"]
[null,"green - lightest (228-235-194)","new furniture",{"$f":"'GWP Project Summary'!$R$54","v":{"$error":"#DIV/0!"}},{"$f":"ROUND('GWP Project Summary'!$R$54,3)","v":{"$error":"#DIV/0!"}},{"$f":"D40+D42+SUM(D44:D50)","v":{"$error":"#DIV/0!"}},"total new material"]
[null,"black dash","salvaged casework",{"$f":"'GWP Project Summary'!$R$50","v":{"$error":"#DIV/0!"}},{"$f":"ROUND('GWP Project Summary'!$R$50,3)","v":{"$error":"#DIV/0!"}},{"$f":"SUM($F$39:$F$40)","v":{"$error":"#DIV/0!"}},"total"]
[null,"green (175-195-70)","new casework",{"$f":"'GWP Project Summary'!$R$49","v":{"$error":"#DIV/0!"}},{"$f":"ROUND('GWP Project Summary'!$R$49,3)","v":{"$error":"#DIV/0!"}}]
[null,"black dash","Salvaged",{"$f":"'GWP Project Summary'!$R$45","v":{"$error":"#DIV/0!"}},{"$f":"ROUND('GWP Project Summary'!$R$45,3)","v":{"$error":"#DIV/0!"}}]
[null,"blue-lightest (231-249-250)","09 - Finishes",{"$f":"'GWP Project Summary'!$R$39","v":{"$error":"#DIV/0!"}},{"$f":"ROUND('GWP Project Summary'!$R$39,3)","v":{"$error":"#DIV/0!"}}]
[null,"blue-lighter (170-237-240)","08 - Openings and Glazing",{"$f":"'GWP Project Summary'!$R$34","v":{"$error":"#DIV/0!"}},{"$f":"ROUND('GWP Project Summary'!$R$34,3)","v":{"$error":"#DIV/0!"}}]
[null,"blue (80-210-220)","07 - Thermal and Moisture Protection",{"$f":"'GWP Project Summary'!$R$29","v":{"$error":"#DIV/0!"}},{"$f":"ROUND('GWP Project Summary'!$R$29,3)","v":{"$error":"#DIV/0!"}}]
[null,"39-184-195","06 - Wood/Plastics/Composites",{"$f":"'GWP Project Summary'!$R$24","v":{"$error":"#DIV/0!"}},{"$f":"ROUND('GWP Project Summary'!$R$24,3)","v":{"$error":"#DIV/0!"}}]
[null,"blue-darker (32-150-159)","05 - Metals",{"$f":"'GWP Project Summary'!$R$19","v":{"$error":"#DIV/0!"}},{"$f":"ROUND('GWP Project Summary'!$R$19,3)","v":{"$error":"#DIV/0!"}}]
[null,"27-127-135","04 - Masonry",{"$f":"'GWP Project Summary'!$R$14","v":{"$error":"#DIV/0!"}},{"$f":"ROUND('GWP Project Summary'!$R$14,3)","v":{"$error":"#DIV/0!"}}]
[null,"blue-darkest (23-108-115)","03 - Concrete",{"$f":"'GWP Project Summary'!$R$9","v":{"$error":"#DIV/0!"}},{"$f":"ROUND('GWP Project Summary'!$R$9,3)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(SUM($D$44:$D$50),3)","v":{"$error":"#DIV/0!"}},"total new const. mat."]
[null,null,"total",{"$f":"SUM($D$39:$D$50)","v":{"$error":"#DIV/0!"}},{"$f":"SUM($E$39:$E$50)","v":{"$error":"#DIV/0!"}}]

{"sheet":"Notes","index":5,"n_rows":33,"n_cols":5,"rows_kept":33}
[]
[null,"Updated 06/28/2023"]
[]
[]
[null,"AIA Framework for Design Excellence: ",null,null,"https://www.aia.org/resources/6077668-framework-for-design-excellence"]
[null,"COTE Super Spreadsheet:",null,null,"https://www.aia.org/resources/77561-sustainability"]
[null,"Join the AIA 2030 Commitment:",null,null,"https://www.aia.org/resources/202041-the-2030-commitment"]
[null,"Take the AIA Materials Pledge:",null,null," https://www.aia.org/pages/6351155-materials-pledge"]
[]
[]
[null,"Abbreviation list"]
[null,"ASE",null,"Annual Sunlight Exposure"]
[null,"BTU",null,"British Thermal Unit"]
[null,"CBPB ",null,"Cement Bonded Particle Board (example: VIROC) "]
[null,"CLF ",null,"Carbon Leadership Forum"]
[null,"CO2",null,"Carbon Dioxide"]
[null,"CO2e",null,"Carbon Dioxide equivalent"]
[null,"DA",null,"Daylight Autonomy"]
[null,"DDx",null,"Design Data Exchange "]
[null,"EC",null,"Embodied Carbon"]
[null,"EPD",null,"Environmental Product Declarations"]
[null,"EUI",null,"Energy Use Intensity"]
[null,"GSF",null,"Gross square footage"]
[null,"GWP",null,"Global Warming Potential"]
[null,"kWh",null,"Kilowatt-Hour"]
[null,"LBC",null,"Living Building Challenge"]
[null,"LCA",null,"Life Cycle Analysis"]
[null,"LPD",null,"Lighting Power Density"]
[null,"QTO",null,"Quantity Takeoff"]
[null,"sDA",null,"Spatial Daylight Autonomy"]
[null,"SF",null,"Square Footage"]
[null,"W/sf",null,"Watt per Square Foot"]
[null,"WFB ",null,"Wood Fiber Board (Color-thru MDF)   example: INTERLAM (FORESCOLOR)"]

{"sheet":"EPD Sources","index":6,"n_rows":34,"n_cols":4,"rows_kept":34,"merged":[[1,1,1,3],[12,1,12,3]]}
[]
[null,"Databases"]
[null,"Databases","Note","Website"]
[null,"EPD Library International","Excellent source, filter by region","EPD Library | EPD International (environdec.com)"]
[null,"EPD Registry","Outside of US, minimal database","The EPD Registry™ | Digital EPD | EPD Databases | EPD for World Construction Products and Materials"]
[null,"LCA Database","Digital EPD's, no product image","Global Construction Products EPD / LCA Databases for Sustainable Buildings | Digital EPD | LCA Database"]
[null,"Mindful Materials","Has variety of other certifications","mindful MATERIALS (origin.build)"]
[null,"Norwegian EPD database","A lot of sofa & lounge chairs","Furniture - EPD Norge (epd-norge.no)"]
[null,"NSF International","Herman Miller, Knoll, Teknion","Listing Category Search Page | NSF International"]
[null,"SCS Global Services","Allsteel, Gunlocke, KI","Certified Green Products Guide | SCS Global Services"]
[null,"Spot","Minimal furniture EPD's","https://spot.ul.com/"]
[]
[null,"Manufacturers"]
[null,"Manufacturer","Website","EPD "]
[null,"Allsteel","Allsteel (allsteeloffice.com)","SCS Global Services Database"]
[null,"Andreu World","https://www.andreuworld.com/","no EPDs for now, but have other certifications"]
[null,"Arper - Italy","Arper: Designer Chairs, Tables and Accessories - Arper USA","EPD can be found here"]
[null,"Benchmark Furnitures - UK","Welcome to Benchmark (benchmarkfurniture.com)","Environmental Product Declarations (benchmarkfurniture.com)"]
[null,"Emeco","https://www.emeco.net/"]
[null,"Fora Form - Norway","Fora Form | Home","lounge chairs and sofa EPDs"]
[null,"Framery Acoustics - Finland","https://www.frameryacoustics.com/en/","EPD can be downloaded from here"]
[null,"Gunlocke","Gunlocke-Office Furniture-Wood Casegoods-Desking-Seating-Conferencing |","SCS Global Services Database"]
[null,"Haworth","https://www.haworth.com/na/en.html","mostly have EPDs with LCA that can be downloaded under each product"]
[null,"Herman Miller","Herman Miller - Modern Furniture for the Office and Home","17 Environmental Product Declaration (EPD) Products | Herman Miller (ecomedes.com)"]
[null,"Keillhauer","https://keilhauer.com/","no EPDs for now, but have other certifications"]
[null,"KI","KI: The Trusted Expert for Contract Furniture Solutions | KI","SCS Global Services Database"]
[null,"Knoll ","Knoll - Modern Furniture Design for the Office & Home","https://www.knoll.com/design-plan/resources/environment"]
[null,"Koleksiyon - Turkey","Koleksiyon - Office & Contract Furniture, Accessories, Designs","EPD can be downloaded from here"]
[null,"Magis Design - Italy","https://www.magisdesign.com/","EPD can be downloaded from here"]
[null,"Mark Products - UK","http://www.markproduct.com/","EPD can be downloaded from here"]
[null,"Mattiazzi - Sweden (Foster + Partners designed chairs)","Home - Mattiazzi","EPD can be downloaded from here"]
[null,"Nowystyl - Poland","Nowy Styl","More than 20 products by Nowy Styl with the EPD - News"]
[null,"Steelcase","Steelcase - Office Furniture Solutions, Education & Healthcare Furniture","Steelcase EPDs can be downloaded here (temp folder)"]
[null,"Teknion - Canada","Homepage (teknion.com)","Listing Category Search Page | NSF International"]

{"sheet":"Tally Casework Outputs","index":7,"n_rows":44,"n_cols":26,"rows_kept":44}
[null,"updated 10/07/2024"]
[]
[null,"Revit modeled dimensions ft2",{"$nulls":13},"Base cabinet","GWP, kg CO2eq/lf",null,"Upper cabinet","GWP, kg CO2eq/lf",null,"Tall cabinet","GWP, kg CO2eq/lf",null,"Countertop","GWP, kg CO2eq/lf"]
[null,null,"Base","Upper","Tall","Counter",{"$nulls":9},"N/A",{"v":0,"d":"0.00"},null,"N/A",{"v":0,"d":"0.00"},null,"N/A",{"v":0,"d":"0.00"},null,"N/A",{"v":0,"d":"0.00"}]
[null,"Back",5.65,{"v":4.9,"d":"4.90"},13.55,{"$nulls":10},"PLY",{"$f":"L22","v":{"v":4.172240802675586,"d":"4.2"}},null,"PLY",{"$f":"M22","v":{"v":3.007246376811594,"d":"3.0"}},null,"PLY",{"$f":"N22","v":{"v":9.839743589743591,"d":"9.8"}},null,"HPL w/plywood substrate",{"$f":"O23","v":{"v":1.1702434039390561,"d":"1.2"}}]
[null,"Side",{"$f":"5.65*2","v":{"v":11.3,"d":"11.30"}},{"$f":"2.51*2","v":5.02},{"$f":"13.66*2","v":27.32},{"$nulls":10},"HPL w/plywood substrate",{"$f":"L23","v":{"v":8.48355629877369,"d":"8.5"}},null,"HPL w/plywood substrate",{"v":6.114734299516908,"d":"6.1"},null,"HPL w/plywood substrate",{"v":20.007478632478637,"d":"20.0"},null,"LINO w/plywood substrate",{"$f":"O25","v":{"v":1.2277963582311409,"d":"1.2"}}]
[null,"Face",5.17,{"$f":"2.45*2","v":{"v":4.9,"d":"4.90"}},13.17,4.13,{"$nulls":9},"OSB",{"v":6.426787564369766,"d":"6.4"},null,"OSB",{"v":4.632267055414146,"d":"4.6"},null,"OSB",{"v":15.156829322650275,"d":"15.2"},null,"MDF",{"$f":"O26","v":{"v":1.7153289687848388,"d":"1.7"}}]
[null,"Interior",3.52,{"$f":"1.61*2","v":3.22},{"$f":"3.18*5","v":{"v":15.9,"d":"15.90"}},{"$nulls":10},"LINO w/plywood substrate",{"v":8.900780379041251,"d":"8.9"},null,"LINO w/plywood substrate",{"v":6.415458937198068,"d":"6.4"},null,"LINO w/plywood substrate",{"v":20.991452991452995,"d":"21.0"},null,"SOLID WOOD",{"$f":"O27","v":{"v":1.878720271274619,"d":"1.9"}}]
[null,"Bottom",3.63,{"$f":"1.77*2","v":3.54},{"$nulls":11},"MDF",{"v":12.435096688963215,"d":"12.4"},null,"MDF",{"v":8.962905362318843,"d":"9.0"},null,"MDF",{"v":29.32672602564104,"d":"29.3"},null,"WOOD VENEER w/particleboard substrate",{"$f":"O29","v":{"v":3.2998699999999994,"d":"3.3"}}]
[null,"Front lower",0.67,null,0.67,{"$nulls":10},"SOLID WOOD",{"v":13.619584726867338,"d":"13.6"},null,"SOLID WOOD",{"v":9.81665458937198,"d":"9.8"},null,"SOLID WOOD",{"v":32.120202991453,"d":"32.1"},null,"PORCELAIN w/MDF substrate",{"$f":"O30","v":{"v":5.744035769230769,"d":"5.7"}}]
[null,"Total",{"$f":"SUM(C5:C10)","v":{"v":29.940000000000005,"d":"29.94"}},{"$f":"SUM(D5:D10)","v":21.58},{"v":70.61000000000001,"d":"70.61"},4.13,{"$nulls":9},"CEMENT BONDED PARTICLEBOARD",{"v":21.34240245261985,"d":"21.3"},null,"CEMENT BONDED PARTICLEBOARD",{"v":15.383067632850242,"d":"15.4"},null,"CEMENT BONDED PARTICLEBOARD",{"v":50.33356837606839,"d":"50.3"},null,"CONCRETE",{"$f":"O34","v":{"v":5.718730118914902,"d":"5.72"}}]
[{"$nulls":15},"WOOD VENEER w/particleboard subst.",{"v":23.922060000000002,"d":"23.9"},null,"WOOD VENEER w/particleboard subst.",{"v":17.242419999999996,"d":"17.2"},null,"WOOD VENEER w/particleboard subst.",{"v":56.417390000000005,"d":"56.4"},null,"PAPER STONE w/plywood substrate",{"$f":"O31","v":{"v":6.023875882571535,"d":"6.0"}}]
[null,"Edgebanding Tally, kgCO2e *",{"$nulls":13},"PORCELAIN w/MDF substrate",{"v":41.64078230769232,"d":"41.6"},null,"PORCELAIN w/MDF substrate",{"v":30.01363,"d":"30.0"},null,"PORCELAIN w/MDF substrate",{"v":98.20493115384618,"d":"98.2"},null,"RECYCLED GLASS, SINTERED",{"$f":"O35","v":{"v":6.2157190635451505,"d":"6.216"}}]
[null,null,"Base","Upper","Tall","Counter",{"$nulls":9},"PAPER STONE w/plywood substrate",{"v":43.66945373467114,"d":"43.7"},null,"PAPER STONE w/plywood substrate",{"v":31.47584541062802,"d":"31.5"},null,"PAPER STONE w/plywood substrate",{"v":102.98931623931627,"d":"103.0"},null,"BUTCHER BLOCK",{"v":7.5010683760683765,"d":"7.50"}]
[null,null,{"$f":"65.72+17.59","v":83.31},{"$f":"97.53+8.8","v":106.33},{"$f":"154.08+18.31","v":{"v":172.39000000000001,"d":"172.39"}},{"v":35.0385548831616,"d":"35.04"},{"$nulls":9},"CHPL w/particleboard subst.",{"v":73.50097547380157,"d":"73.5"},null,"CHPL w/particleboard subst.",{"v":52.97765700483092,"d":"53.0"},null,"CHPL w/particleboard subst.",{"v":173.34348290598297,"d":"173.3"},null,"NATURAL STONE",{"v":8.970587142326274,"d":"8.97"}]
[{"$nulls":24},"1/2\" SINTERED STONE",{"v":9.005886287625417,"d":"9.01"}]
[{"$nulls":24},"STAINLESS w/plywood substrate",{"v":9.879923820141212,"d":"9.88"}]
[{"$nulls":24},"3/4\" ENGINEERED STONE w/plywood substrate",{"v":9.926728849178225,"d":"9.93"}]
[{"$nulls":24},"CHPL w/PARTICLEBOARD",{"$f":"O32","v":{"v":10.138912114455593,"d":"10.1"}}]
[null,"EPD DATA + TALLY, kgCO2e per",{"$nulls":4},"Total GWP Result 2024",{"$nulls":4},"1LF Calculated Result 2024",{"$nulls":12},"1 1/4\" ENGINEERED STONE  w/plywood substrate",{"$f":"O41","v":{"v":12.06693608324043,"d":"12.07"}}]
[null,null,"Source","m2","ft2",null,"Base","Upper","Tall","Counter",null,"Base","Upper","Tall","Counter",{"$nulls":9},"SOLID SURFACE",{"$f":"O43","v":{"v":14.388238573021182,"d":"14.39"}}]
[null,"PLY","EPD",{"v":3,"d":"3.0"},{"$f":"D22/10.764","v":{"v":0.2787068004459309,"d":"0.3"}},null,{"$f":"$C$11*E22","v":{"v":8.344481605351172,"d":"8.3"}},{"$f":"$D$11*E22","v":{"v":6.014492753623188,"d":"6.0"}},{"$f":"$E$11*E22","v":{"v":19.679487179487182,"d":"19.7"}},"X",null,{"$f":"G22/2","v":{"v":4.172240802675586,"d":"4.2"}},{"v":3.007246376811594,"d":"3.0"},{"v":9.839743589743591,"d":"9.8"},"x",{"$nulls":9},"3/4\" SINTERED STONE",{"$f":"O42","v":{"v":15.009810479375696,"d":"15.01"}}]
[null,"HPL w/plywood substrate","EPD AVERAGE",6.1,{"$f":"D23/10.764","v":{"v":0.5667038275733928,"d":"0.6"}},null,{"$f":"$C$11*E23","v":{"v":16.96711259754738,"d":"17.0"}},{"$f":"$D$11*E23","v":{"v":12.229468599033815,"d":"12.2"}},{"$f":"$E$11*E23","v":{"v":40.014957264957275,"d":"40.0"}},{"$f":"F11*E23","v":{"v":2.3404868078781123,"d":"2.3"}},null,{"v":8.48355629877369,"d":"8.5"},{"v":6.114734299516908,"d":"6.1"},{"v":20.007478632478637,"d":"20.0"},{"$f":"J23/2","v":{"v":1.1702434039390561,"d":"1.2"}},{"$nulls":9},"1-1/8\" SINTERED STONE",{"$f":"O44","v":{"v":22.514715719063542,"d":"22.51"}}]
[null,"OSB","EPD",{"v":4.621104966123991,"d":"4.6"},{"v":0.4293111265444065,"d":"0.4"},null,{"v":12.853575128739532,"d":"12.9"},{"v":9.264534110828292,"d":"9.3"},{"v":30.31365864530055,"d":"30.3"},"X",null,{"v":6.426787564369766,"d":"6.4"},{"v":4.632267055414146,"d":"4.6"},{"v":15.156829322650275,"d":"15.2"},"x"]
[null,"LINO w/plywood substrate","EPD",6.4,{"v":0.5945745076179859,"d":"0.6"},null,{"v":17.801560758082502,"d":"17.8"},{"v":12.830917874396135,"d":"12.8"},{"v":41.98290598290599,"d":"42.0"},{"$f":"$F$11*E25","v":{"v":2.4555927164622817,"d":"2.5"}},null,{"v":8.900780379041251,"d":"8.9"},{"v":6.415458937198068,"d":"6.4"},{"v":20.991452991452995,"d":"21.0"},{"$f":"J25/2","v":{"v":1.2277963582311409,"d":"1.2"}}]
[null,"MDF","EPD",{"v":8.941308000000001,"d":"8.9"},{"v":0.8306677814938687,"d":"0.8"},null,{"v":24.87019337792643,"d":"24.9"},{"v":17.925810724637685,"d":"17.9"},{"v":58.65345205128208,"d":"58.7"},{"$f":"$F$11*E26","v":{"v":3.4306579375696775,"d":"3.4"}},null,{"v":12.435096688963215,"d":"12.4"},{"v":8.962905362318843,"d":"9.0"},{"v":29.32672602564104,"d":"29.3"},{"$f":"J26/2","v":{"v":1.7153289687848388,"d":"1.7"}}]
[null,"SOLID WOOD","EPD",{"v":9.793,"d":"9.8"},{"v":0.9097918989223337,"d":"0.9"},null,{"v":27.239169453734675,"d":"27.2"},{"v":19.63330917874396,"d":"19.6"},{"v":64.240405982906,"d":"64.2"},{"$f":"$F$11*E27","v":{"v":3.757440542549238,"d":"3.8"}},null,{"v":13.619584726867338,"d":"13.6"},{"v":9.81665458937198,"d":"9.8"},{"v":32.120202991453,"d":"32.1"},{"$f":"J27/2","v":{"v":1.878720271274619,"d":"1.9"}}]
[null,"CEMENT BONDED PARTICLEBOARD","EPD",{"v":15.346,"d":"15.3"},{"v":1.425678186547752,"d":"1.4"},null,{"v":42.6848049052397,"d":"42.7"},{"v":30.766135265700484,"d":"30.8"},{"v":100.66713675213678,"d":"100.7"},"x",null,{"v":21.34240245261985,"d":"21.3"},{"v":15.383067632850242,"d":"15.4"},{"v":50.33356837606839,"d":"50.3"},"x"]
[null,"WOOD VENEER w/particleboard subst.","EPD",{"v":17.200871999999997,"d":"17.2"},{"v":1.5979999999999999,"d":"1.6"},null,{"v":47.844120000000004,"d":"47.8"},{"v":34.48483999999999,"d":"34.5"},{"v":112.83478000000001,"d":"112.8"},{"$f":"$F$11*E29","v":{"v":6.599739999999999,"d":"6.6"}},null,{"v":23.922060000000002,"d":"23.9"},{"v":17.242419999999996,"d":"17.2"},{"v":56.417390000000005,"d":"56.4"},{"$f":"J29/2","v":{"v":3.2998699999999994,"d":"3.3"}}]
[null,"PORCELAIN w/MDF substrate","EPD",{"$f":"21+D26","v":{"v":29.941308,"d":"29.9"}},{"v":2.781615384615385,"d":"2.8"},null,{"v":83.28156461538464,"d":"83.3"},{"v":60.02726,"d":"60.0"},{"v":196.40986230769235,"d":"196.4"},{"$f":"$F$11*E30","v":{"v":11.488071538461538,"d":"11.5"}},null,{"v":41.64078230769232,"d":"41.6"},{"v":30.01363,"d":"30.0"},{"v":98.20493115384618,"d":"98.2"},{"$f":"J30/2","v":{"v":5.744035769230769,"d":"5.7"}}]
[null,"PAPER STONE w/plywood substrate","EPD",31.4,{"v":2.9171311780007434,"d":"2.9"},null,{"v":87.33890746934227,"d":"87.3"},{"v":62.95169082125604,"d":"63.0"},{"v":205.97863247863253,"d":"206.0"},{"$f":"$F$11*E31","v":{"v":12.04775176514307,"d":"12.0"}},null,{"v":43.66945373467114,"d":"43.7"},{"v":31.47584541062802,"d":"31.5"},{"v":102.98931623931627,"d":"103.0"},{"$f":"J31/2","v":{"v":6.023875882571535,"d":"6.0"}}]
[null,"CHPL w/particleboard subst.","EPD",{"v":52.85,"d":"52.9"},{"v":4.90988480118915,"d":"4.9"},null,{"v":147.00195094760315,"d":"147.0"},{"v":105.95531400966183,"d":"106.0"},{"v":346.68696581196593,"d":"346.7"},{"$f":"$F$11*E32","v":{"v":20.277824228911186,"d":"20.3"}},null,{"v":73.50097547380157,"d":"73.5"},{"v":52.97765700483092,"d":"53.0"},{"v":173.34348290598297,"d":"173.3"},{"$f":"J32/2","v":{"v":10.138912114455593,"d":"10.1"}}]
[]
[null,"CONCRETE","EPD+TALLY",{"v":29.809400000000004,"d":"29.8"},{"v":2.769360832404311,"d":"2.8"},{"$nulls":4},{"$f":"$F$11*E34","v":{"v":11.437460237829804,"d":"11.4"}},{"$nulls":4},{"$f":"J34/2","v":{"v":5.718730118914902,"d":"5.7"}}]
[null,"RECYCLED GLASS, SINTERED","EPD",32.4,{"$f":"D35/10.764","v":{"v":3.0100334448160537,"d":"3.0"}},{"$nulls":4},{"v":12.431438127090301,"d":"12.4"},{"$nulls":4},{"v":6.2157190635451505,"d":"6.2"}]
[null,"BUTCHER'S BLOCK","TALLY",39.1,{"$f":"D36/10.764","v":{"v":3.632478632478633,"d":"3.6"}},{"$nulls":4},{"v":15.002136752136753,"d":"15.0"},{"$nulls":4},{"v":7.5010683760683765,"d":"7.5"}]
[null,"NATURAL STONE","EPD",{"v":46.760000000000005,"d":"46.8"},{"v":4.34410999628391,"d":"4.3"},{"$nulls":4},{"v":17.941174284652547,"d":"17.9"},{"$nulls":4},{"v":8.970587142326274,"d":"9.0"}]
[null,"1/2\" SINTERED STONE","EPD",{"v":46.943999999999996,"d":"46.9"},{"$f":"D38/10.764","v":{"v":4.361204013377926,"d":"4.4"}},{"$nulls":4},{"v":18.011772575250834,"d":"18.0"},{"$nulls":4},{"v":9.005886287625417,"d":"9.0"}]
[null,"STAINLESS w/plywood substrate","EPD",51.5,{"$f":"D39/10.764","v":{"v":4.7844667409884805,"d":"4.8"}},{"$nulls":4},{"v":19.759847640282423,"d":"19.8"},{"$nulls":4},{"v":9.879923820141212,"d":"9.9"}]
[null,"3/4\" ENGINEERED STONE w/plywood substrate","EPD",{"v":51.74397546370673,"d":"51.7"},{"v":4.807132614614153,"d":"4.8"},{"$nulls":4},{"v":19.85345769835645,"d":"19.9"},{"$nulls":4},{"v":9.926728849178225,"d":"9.9"}]
[null,"1 1/4\" ENGINEERED STONE w/plywood substrate","EPD",62.9,{"v":5.843552582683017,"d":"5.8"},{"$nulls":4},{"v":24.13387216648086,"d":"24.1"},{"$nulls":4},{"v":12.06693608324043,"d":"12.1"}]
[null,"3/4\" SINTERED STONE","EPD",{"v":78.24,"d":"78.2"},{"v":7.268673355629877,"d":"7.3"},{"$nulls":4},{"v":30.019620958751393,"d":"30.0"},{"$nulls":4},{"v":15.009810479375696,"d":"15.0"}]
[null,"SOLID SURFACE","EPD",{"v":75,"d":"75.0"},{"$f":"D43/10.764","v":{"v":6.967670011148273,"d":"7.0"}},{"$nulls":4},{"v":28.776477146042364,"d":"28.8"},{"$nulls":4},{"v":14.388238573021182,"d":"14.4"}]
[null,"1 1/8\" SINTERED STONE","EPD",{"v":117.35999999999999,"d":"117.4"},{"v":10.903010033444815,"d":"10.9"},{"$nulls":4},{"v":45.029431438127084,"d":"45.0"},{"$nulls":4},{"v":22.514715719063542,"d":"22.5"}]

{"sheet":"Building Type Benchmarks","index":8,"n_rows":49,"n_cols":23,"rows_kept":49,"merged":[[1,1,4,3],[1,5,4,7],[1,8,1,13],[1,14,4,15],[1,16,4,17],[1,18,4,22],[2,8,3,13],[5,1,7,1],[5,2,7,2],[5,3,7,3],[5,4,7,4],[5,5,7,5],[5,6,7,6],[5,7,7,7],[5,8,7,8],[5,9,7,9],[5,10,7,10],[5,11,7,11],[5,12,7,12],[5,13,7,13],[5,14,7,14],[5,15,7,15],[5,16,7,16],[5,17,7,17],[5,18,7,18],[5,19,7,19],[5,20,7,20],[5,21,7,21],[5,22,7,22]]}
[]
[null,"Building Type",{"$nulls":3},"Energy Benchmarking",null,null,"Carbon Benchmarking",{"$nulls":5},"Embodied Carbon Benchmarking",null,"Water Benchmarking",null,"Building type aggregates"]
[{"$nulls":8},"Fuel Breakdown Table: lbs. CO2/kBtu for each fuel source\n*Assume natural gas"]
[]
[{"$nulls":9},0.36,0.12,0.16,{"$f":"K5","v":0.12}]
[null,"Primary Use","Secondary Use","Tertiary Use","All Uses","Building Type","EUI","LPD","Building Category (Carbon)","Electricity","Natural gas","Fuel oil","District heat*","Benchmark Carbon\nLbs./sf/yr","Building Category (emboded carbon)","Lbs. CO2/sf","Building Category (Water)","Water Use Intensity (Gal/sf/yr)","Carbon Breakdown","EUI Breakdown","Water Breakdown","Embodied carbon","LPD Breakdown"]
[]
[]
[null,{"$f":"IF(#REF!=$F9,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F9,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F9,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"SUM(B9:D9)","v":{"$error":"#REF!"}},"Bank",{"v":77,"d":"77.00"},{"v":1,"d":"1.0"},"Office",{"v":0.7,"d":"70%"},{"v":0.23,"d":"23%"},{"v":0.01,"d":"1%"},{"v":0.06,"d":"6%"},{"$f":"(G9*J9*$F$51)+(G9*K9*$G$51)+(G9*L9*$H$51)+(G9*M9*$I$51)","v":{"v":0,"d":"0.0"}},"Commercial",67,"Office",14.6,{"$f":"N9*E9","v":{"$error":"#REF!"}},{"$f":"E9*G9","v":{"$error":"#REF!"}},{"$f":"E9*R9","v":{"$error":"#REF!"}},{"$f":"P9*E9","v":{"$error":"#REF!"}},{"$f":"E9*H9","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(#REF!=$F10,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F10,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F10,#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Bar / night club",{"v":52,"d":"52.00"},1.2,"Public assembly",{"v":0.57,"d":"57%"},{"v":0.28,"d":"28%"},{"v":0.01,"d":"1%"},{"v":0.13,"d":"13%"},{"$f":"(G10*J10*$F$51)+(G10*K10*$G$51)+(G10*L10*$H$51)+(G10*M10*$I$51)","v":{"v":0,"d":"0.0"}},"Commercial",67,"Public Assembly",25.7,{"$f":"N10*E10","v":{"$error":"#REF!"}},{"$f":"E10*G10","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF(#REF!=$F11,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F11,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F11,#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Education - College / University",{"v":120,"d":"120.00"},1.2,"Education",{"v":0.54,"d":"54%"},{"v":0.35,"d":"35%"},{"v":0.03,"d":"3%"},{"v":0,"d":"0%"},{"v":0,"d":"0.0"},"Educational",96,"Education",14.6,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF(#REF!=$F12,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F12,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F12,#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Convention Center",{"v":66,"d":"66.00"},1.1,"Public assembly",{"v":0.57,"d":"57%"},{"v":0.28,"d":"28%"},{"v":0.01,"d":"1%"},{"v":0.13,"d":"13%"},{"v":0,"d":"0.0"},"Commercial",67,"Public Assembly",25.7,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF(#REF!=$F13,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F13,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F13,#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Courthouse",{"v":118,"d":"118.00"},1.2,"Office",{"v":0.7,"d":"70%"},{"v":0.23,"d":"23%"},{"v":0.01,"d":"1%"},{"v":0.06,"d":"6%"},{"v":0,"d":"0.0"},"Commercial",67,"Office",14.6,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF(#REF!=$F14,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F14,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F14,#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Education - K-12 School",{"v":75,"d":"75.00"},1.2,"Education",{"v":0.54,"d":"54%"},{"v":0.35,"d":"35%"},{"v":0.03,"d":"3%"},{"v":0,"d":"0%"},{"v":0,"d":"0.0"},"Educational",96,"Education",14.6,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF(#REF!=$F15,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F15,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F15,#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Education - Other",{"v":76,"d":"76.00"},1.2,"Education",{"v":0.54,"d":"54%"},{"v":0.35,"d":"35%"},{"v":0.03,"d":"3%"},{"v":0,"d":"0%"},{"v":0,"d":"0.0"},"Educational",96,"Education",14.6,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF(#REF!=$F16,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F16,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F16,#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Education - Preschool",{"v":75,"d":"75.00"},1.2,"Education",{"v":0.54,"d":"54%"},{"v":0.35,"d":"35%"},{"v":0.03,"d":"3%"},{"v":0,"d":"0%"},{"v":0,"d":"0.0"},"Educational",96,"Education",14.6,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF(#REF!=$F17,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F17,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F17,#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Food - Fast Food",{"v":534,"d":"534.00"},1.5,"Food service",{"v":0.54,"d":"54%"},{"v":0.44,"d":"44%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0.0"},"Commercial",67,"Restaurant**",{"v":215,"d":"215.0"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF(#REF!=$F18,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F18,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F18,#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Food - Grocery Store",{"v":213,"d":"213.00"},1.5,"Food sales",{"v":0.79,"d":"79%"},{"v":0.21,"d":"21%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0.0"},"Commercial",67,"Grocery Store",23.7,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF(#REF!=$F19,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F19,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F19,#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Food - Restaurant",{"v":302,"d":"302.00"},1.5,"Food service",{"v":0.54,"d":"54%"},{"v":0.44,"d":"44%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0.0"},"Commercial",67,"Restaurant**",{"v":215,"d":"215.0"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF(#REF!=$F20,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F20,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F20,#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Food - Sales",{"v":225,"d":"225.00"},1.5,"Food sales",{"v":0.79,"d":"79%"},{"v":0.21,"d":"21%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0.0"},"Commercial",67,"Grocery Store*",23.7,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF(#REF!=$F21,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F21,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F21,#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Food - Service",{"v":351,"d":"351.00"},1.5,"Food service",{"v":0.54,"d":"54%"},{"v":0.44,"d":"44%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0.0"},"Commercial",67,"Restaurant**",{"v":215,"d":"215.0"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF(#REF!=$F22,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F22,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F22,#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Laboratory",{"v":370,"d":"370.00"},1.4,"Inpatient",{"v":0.51,"d":"51%"},{"v":0.37,"d":"37%"},{"v":0.03,"d":"3%"},{"v":0.09,"d":"9%"},{"v":0,"d":"0.0"},"Educational",96,"Inpatient",49.6,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF(#REF!=$F23,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F23,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F23,#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Library",{"v":104,"d":"104.00"},1.3,"public assembly",{"v":0.57,"d":"57%"},{"v":0.28,"d":"28%"},{"v":0.01,"d":"1%"},{"v":0.13,"d":"13%"},{"v":0,"d":"0.0"},"Cultural/Institutional",92,"Public Assembly",25.7,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF(#REF!=$F24,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F24,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F24,#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Lodging - Hotel",{"v":94,"d":"94.00"},{"v":1,"d":"1.0"},"Lodging",{"v":0.54,"d":"54%"},{"v":0.39,"d":"39%"},{"v":0.01,"d":"1%"},{"v":0,"d":"0%"},{"v":0,"d":"0.0"},"Lodging",57,"Lodging",41.7,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF(#REF!=$F25,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F25,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F25,#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Lodging - Residence Hall",{"v":89,"d":"89.00"},{"v":1,"d":"1.0"},"Lodging",{"v":0.54,"d":"54%"},{"v":0.39,"d":"39%"},{"v":0.01,"d":"1%"},{"v":0,"d":"0%"},{"v":0,"d":"0.0"},"Lodging",57,"Lodging",41.7,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF(#REF!=$F26,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F26,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F26,#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Medical - Hospital",{"v":227,"d":"227.00"},1.2,"Inpatient",{"v":0.51,"d":"51%"},{"v":0.37,"d":"37%"},{"v":0.03,"d":"3%"},{"v":0.09,"d":"9%"},{"v":0,"d":"0.0"},"Healthcare",75,"Inpatient",49.6,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF(#REF!=$F27,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F27,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F27,#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Medical - Office",{"v":59,"d":"59.00"},{"v":1,"d":"1.0"},"Health care",{"v":0.51,"d":"51%"},{"v":0.37,"d":"37%"},{"v":0.03,"d":"3%"},{"v":0.09,"d":"9%"},{"v":0,"d":"0.0"},"Healthcare",75,"Outpatient",15.6,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF(#REF!=$F28,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F28,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F28,#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Medical - Outpatient surgery",{"v":73,"d":"73.00"},1.2,"Outpatient",{"v":0.67,"d":"67%"},{"v":0.27,"d":"27%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0.0"},"Healthcare",76,"Outpatient",15.6,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF(#REF!=$F29,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F29,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F29,#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Meeting Hall",{"v":52,"d":"52.00"},1.2,"public assembly",{"v":0.57,"d":"57%"},{"v":0.28,"d":"28%"},{"v":0.01,"d":"1%"},{"v":0.13,"d":"13%"},{"v":0,"d":"0.0"},"Civic Building",50,"Public Assembly",25.7,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF(#REF!=$F30,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F30,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F30,#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Movie Theater",{"v":95,"d":"95.00"},1.6,"public assembly",{"v":0.57,"d":"57%"},{"v":0.28,"d":"28%"},{"v":0.01,"d":"1%"},{"v":0.13,"d":"13%"},{"v":0,"d":"0.0"},"Cultural/Institutional",92,"Public Assembly",25.7,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF(#REF!=$F31,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F31,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F31,#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Museum",{"v":95,"d":"95.00"},1.6,"public assembly",{"v":0.57,"d":"57%"},{"v":0.28,"d":"28%"},{"v":0.01,"d":"1%"},{"v":0.13,"d":"13%"},{"v":0,"d":"0.0"},"Cultural/Institutional",92,"Public Assembly",25.7,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF(#REF!=$F32,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F32,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F32,#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Office",{"v":90,"d":"90.00"},{"v":1,"d":"1.0"},"Office",{"v":0.7,"d":"70%"},{"v":0.23,"d":"23%"},{"v":0.01,"d":"1%"},{"v":0.06,"d":"6%"},{"v":0,"d":"0.0"},"Commercial",67,"Office",14.6,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF(#REF!=$F33,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F33,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F33,#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Performing arts",{"v":95,"d":"95.00"},1.6,"public assembly",{"v":0.57,"d":"57%"},{"v":0.28,"d":"28%"},{"v":0.01,"d":"1%"},{"v":0.13,"d":"13%"},{"v":0,"d":"0.0"},"Cultural/Institutional",92,"Public Assembly",25.7,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF(#REF!=$F34,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F34,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F34,#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Public Assembly",{"v":66,"d":"66.00"},1.1,"public assembly",{"v":0.57,"d":"57%"},{"v":0.28,"d":"28%"},{"v":0.01,"d":"1%"},{"v":0.13,"d":"13%"},{"v":0,"d":"0.0"},"Civic Building",50,"Public Assembly",25.7,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF(#REF!=$F35,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F35,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F35,#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Public Safety - Police, fire, etc.",{"v":90,"d":"90.00"},{"v":1,"d":"1.0"},"Public safety",{"v":0.55,"d":"55%"},{"v":0.31,"d":"31%"},{"v":0.02,"d":"2%"},{"v":0,"d":"0%"},{"v":0,"d":"0.0"},"Civic Building",50,"Public order and safety",42.1,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF(#REF!=$F36,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F36,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F36,#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Recreation (Visitor Center)",{"v":66,"d":"66.00"},1.1,"public assembly",{"v":0.57,"d":"57%"},{"v":0.28,"d":"28%"},{"v":0.01,"d":"1%"},{"v":0.13,"d":"13%"},{"v":0,"d":"0.0"},"Civic Building",50,"Public Assembly",25.7,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF(#REF!=$F37,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F37,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F37,#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Religious Worship",{"v":46,"d":"46.00"},1.3,"Religious worship",{"v":0.47,"d":"47%"},{"v":0.5,"d":"50%"},{"v":0.03,"d":"3%"},{"v":0,"d":"0%"},{"v":0,"d":"0.0"},"Cultural/Institutional",92,"Religious Worship*",7.3,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF(#REF!=$F38,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F38,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F38,#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Residential - Assisted Living",{"v":124,"d":"124.00"},{"v":1,"d":"1.0"},"Multifamily",{"v":0.6,"d":"60%"},{"v":0.35,"d":"35%"},{"v":0.05,"d":"5%"},{"v":0,"d":"0%"},{"v":0,"d":"0.0"},"Lodging",57,"Senior Care*",60.2,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF(#REF!=$F39,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F39,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F39,#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Residential - Multifamily",{"v":79,"d":"79.00"},0.7,"Multifamily",{"v":0.6,"d":"60%"},{"v":0.35,"d":"35%"},{"v":0.05,"d":"5%"},{"v":0,"d":"0%"},{"v":0,"d":"0.0"},"Multifamily mid-rise",56,"Multifamily Housing",{"v":42,"d":"42.0"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF(#REF!=$F40,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F40,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F40,#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Residential - Single family",{"v":37.5,"d":"37.50"},0.7,"Single Family",{"$nulls":5},"Single family detached",55,"Single family detached",null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF(#REF!=$F41,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F41,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F41,#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Retail - Box Store",{"v":47,"d":"47.00"},1.5,"Retail (other than mall)",{"v":0.77,"d":"77%"},{"v":0.2,"d":"20%"},{"v":0.02,"d":"2%"},{"v":0,"d":"0%"},{"$f":"(G41*J41*$F$51)+(G41*K41*$G$51)+(G41*L41*$H$51)+(G41*M41*$I$51)","v":{"v":0,"d":"0.0"}},"Commercial",67,"Retail*",{"v":8,"d":"8.0"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF(#REF!=$F42,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F42,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F42,#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Retail - Convenience Store",{"v":192,"d":"192.00"},1.5,"Retail (other than mall)",{"v":0.77,"d":"77%"},{"v":0.2,"d":"20%"},{"v":0.02,"d":"2%"},{"v":0,"d":"0%"},{"v":0,"d":"0.0"},"Commercial",67,"Retail*",{"v":8,"d":"8.0"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF(#REF!=$F43,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F43,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F43,#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Retail - General",{"v":72,"d":"72.00"},1.5,"Retail (other than mall)",{"v":0.77,"d":"77%"},{"v":0.2,"d":"20%"},{"v":0.02,"d":"2%"},{"v":0,"d":"0%"},{"v":0,"d":"0.0"},"Commercial",67,"Retail*",{"v":8,"d":"8.0"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF(#REF!=$F44,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F44,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F44,#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Retail - Mall",{"v":107,"d":"107.00"},1.5,"Enclosed and strip malls",{"v":0.66,"d":"66%"},{"v":0.34,"d":"34%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0.0"},"Commercial",67,"Enclosed and strip malls",11.8,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF(#REF!=$F45,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F45,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F45,#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Self Storage",{"v":31,"d":"31.00"},0.8,"Warehouse and storage",{"v":0.66,"d":"66%"},{"v":0.32,"d":"32%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0.0"},"Commercial",67,"Warehouse and storage",3.4,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF(#REF!=$F46,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F46,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F46,#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Services - General",{"v":77,"d":"77.00"},1.4,"Service",{"v":0.47,"d":"47%"},{"v":0.45,"d":"45%"},{"v":0.06,"d":"6%"},{"v":0,"d":"0%"},{"v":0,"d":"0.0"},"Commercial",67,"Mercantile",12.6,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF(#REF!=$F47,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F47,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F47,#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Warehouse",{"v":26,"d":"26.00"},0.8,"Warehouse and storage",{"v":0.66,"d":"66%"},{"v":0.32,"d":"32%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0.0"},"Commercial",67,"Warehouse and storage",3.4,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF(#REF!=$F48,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F48,#REF!,0)","v":{"$error":"#REF!"}},{"$f":"IF(#REF!=$F48,#REF!,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},"Warehouse - Refrigerated",{"v":127,"d":"127.00"},0.8,"Warehouse and storage",{"v":0.66,"d":"66%"},{"v":0.32,"d":"32%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0.0"},"Commercial",67,"Warehouse and storage",3.4,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[{"$nulls":3},"SUM",{"$f":"SUM(E9:E48)","v":{"$error":"#REF!"}},{"$nulls":12},"SUM",{"$f":"SUM(S9:S48)","v":{"$error":"#REF!"}},{"$f":"SUM(T9:T48)","v":{"$error":"#REF!"}},{"$f":"SUM(U9:U48)","v":{"$error":"#REF!"}},{"$f":"SUM(V9:V48)","v":{"$error":"#REF!"}},{"$f":"SUM(W9:W48)","v":{"$error":"#REF!"}}]

{"sheet":"Future phase","index":9,"n_rows":34,"n_cols":6,"rows_kept":34,"hidden":true}
[null,"The metrics below are not intended to be asked at this time, but some may be added in the future"]
[null,"ADDITIONAL PERFORMANCE METRICS"]
[null,null,"Percent of indoor potable water reduction ","%",null,"https://www.usgbc.org/RESOURCES/INDOOR-WATER-USE-CALCULATOR"]
[null,null,"Percent of stormwater managed on site","%"]
[null,null,"Percentage of occupied areas daylit",null,null,"Not sure we have a way to ask about daylighting that is simple"]
[null,null,"Number of Bike racks"]
[null,null,"Number of showers "]
[null,null,"Parking Spaces provided"]
[null,null,"Parking Spaces required by code"]
[null,null,"Is potable water used for cooling?","Y/N"]
[null,null,"Is potable water used for irrigation","Y/N"]
[null,null,"Rainwater reclaimation?","Y/N"]
[null,null,"Stormwater Quality","drop-down"]
[null,null,"Predicted Gross EUI","kBTU/SF/Year"]
[null,null,"Actual Gross EUI","kBTU/SF/Year"]
[null,null,"Percent from Renewable Energy"]
[null,null,"Lighting Power Density","Watts/SF"]
[null,null,"Window Wall Ratio"]
[null,null,"Regularly occupied space - percent daylit"]
[null,null,"What percentage have quality views?"]
[null,null,"Do occupants control their lighting levels"]
[null,null,"Number of EPD specd"]
[null,null,"Percentage of construction waste diverted from landfill"]
[null,null,"Total cost of Recycled, regional, with certifications (declare, cradle to Cradle)"]
[]
[null,"METRICS BEYOND SCOPE - SEE TOP TEN"]
[null,null,"Occupants Communting by Alternative Transportation"]
[null,null,"Predevelopment Development Vegetated"]
[null,null,"Post Development Vegetated"]
[null,null,"Percentage that is native"]
[null,null,"Percentage that is turf"]
[null,null,"ACOUSTICS"]
[null,null,"VOC"]
[null,null,"CO2"]