{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Window entry","For EWEB Use"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":18,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Window entry","index":0,"n_rows":63,"n_cols":20,"rows_kept":63,"cut":false,"hidden":false,"merged":[[21,4,22,4],[21,14,21,15],[21,16,21,19],[22,6,22,9],[21,10,22,12],[22,16,22,17],[22,18,22,19],[30,10,30,12],[31,10,31,12],[32,10,32,12],[23,10,23,12],[24,10,24,12],[25,10,25,12],[26,10,26,12],[27,10,27,12],[62,10,62,12],[53,10,53,12],[54,10,54,12],[55,10,55,12],[56,10,56,12],[57,10,57,12],[58,10,58,12],[59,10,59,12],[38,10,38,12],[15,1,16,3],[15,4,16,5],[60,10,60,12],[61,10,61,12],[39,10,39,12],[40,10,40,12],[41,10,41,12],[42,10,42,12],[33,10,33,12],[34,10,34,12],[35,10,35,12],[36,10,36,12],[37,10,37,12],[28,10,28,12],[29,10,29,12],[43,10,43,12],[44,10,44,12],[45,10,45,12],[46,10,46,12],[47,10,47,12],[48,10,48,12],[49,10,49,12],[50,10,50,12],[51,10,51,12],[52,10,52,12],[17,4,18,4],[3,11,10,11],[12,11,19,12],[9,1,10,3],[9,4,10,5],[12,1,13,3],[12,4,13,5],[19,1,19,3],[8,7,19,9],[19,4,19,5],[6,1,7,3],[6,4,7,5],[6,7,7,9],[1,1,4,9]]}
[]
[null,"Please complete the white cells below to determine the rebate and loan amounts available from EWEB.\n\nFunding is based on actual window sizes and the NFRC ratings found in the manufacturer's order confirmation.\nFor faster payment processing for more complex projects, you can optionally provide a rough drawing of the home that indicates locations & number of windows so we can match them using Column B. ",null,null,null,null,null,null,null,null,null,"Program parameters",null,{"$f":"E7","v":"Regular-income"}]
[null,null,null,null,null,null,null,null,null,null,null,"Pre-existing window types",null,"Replacement Window",null,null,null,null,"Rebate/sf","Loan OK?"]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.CONCAT('For EWEB Use'!$AG$42)","v":"Double-pane metal"},null,{"$f":"CONCATENATE(\"Windows with U\", 'For EWEB Use'!$AG$61, FIXED(Min_U,2))","v":"Windows with U≤0.25"},null,null,null,null,{"$f":"IF(OR(E7=LIOwn,E7=LIRent), 0, Min_Rebate)","v":0},"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Windows with U\", 'For EWEB Use'!$AG$61,FIXED(HP_U,2))","v":"Windows with U≤0.22"},null,null,null,null,{"$f":"IF(OR(E7=LIOwn,E7=LIRent),'For EWEB Use'!AJ31,HP_Rebate)","v":4},"Yes"]
[]
[null,"Choose program:",null,null,"Regular-income",null,null,"Project-level comments",null,null,null,null,null,{"$f":"CONCATENATE(\"Patio doors with U\", 'For EWEB Use'!$AG$61,FIXED(0.3,2))","v":"Patio doors with U≤0.30"},null,null,null,null,{"$f":"IF(OR(E7=LIOwn,E7=LIRent), 0, Min_Rebate)","v":0},"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Patio doors with U\", 'For EWEB Use'!$AG$61,0.25)","v":"Patio doors with U≤0.25"},null,null,null,null,{"$f":"IF(OR(E7=LIOwn,E7=LIRent),'For EWEB Use'!AJ31,HP_Rebate)","v":4},"Yes"]
[]
[null,"Project installation address:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Obscured windows with U\", 'For EWEB Use'!$AG$61,FIXED(MinBPA_U, 2))","v":"Obscured windows with U≤0.30"},null,null,null,null,{"$f":"IF(OR(E7=LIOwn,E7=LIRent), 0, Min_Rebate)","v":0},"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Obscured windows with U\", 'For EWEB Use'!$AG$61,FIXED(HPBPA_U,2))","v":"Obscured windows with U≤0.22"},null,null,null,null,{"$f":"IF(OR(E7=LIOwn,E7=LIRent),'For EWEB Use'!AJ31,HP_Rebate)","v":4},"Yes"]
[]
[null,"Project Cost:",null,null,null,null,null,null,null,null,null,{"$f":"_xlfn.CONCAT('For EWEB Use'!$AG$40, \" or \", 'For EWEB Use'!$AG$41)","v":"Single-pane or Single-pane w/storm"},null,{"$f":"CONCATENATE(\"Windows with U\", 'For EWEB Use'!$AG$61, FIXED(Min_U,2))","v":"Windows with U≤0.25"},null,null,null,null,{"$f":"Min_Rebate","v":0},"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Windows with U\",'For EWEB Use'!$AG$61,FIXED(HP_U,2))","v":"Windows with U≤0.22"},null,null,null,null,{"$f":"HP_Rebate","v":4},"Yes"]
[]
[null,{"$f":"IF(E7='For EWEB Use'!AG31, \"Available rebate:\", \"Available grant:\")","v":"Available rebate:"},null,null,{"$f":"'For EWEB Use'!T7","v":0},null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Patio doors with U\", 'For EWEB Use'!$AG$61,FIXED(MinPD_U,2))","v":"Patio doors with U≤0.30"},null,null,null,null,{"$f":"Min_Rebate","v":0},"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Patio doors with U\", 'For EWEB Use'!$AG$61,FIXED(HPPD_U,2))","v":"Patio doors with U≤0.25"},null,null,null,null,{"$f":"HP_Rebate","v":4},"Yes"]
[null,null,null,null,{"$f":"IF(E7=RegInc, \"OR\", \"AND\")","v":"OR"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Obscured windows with U\", 'For EWEB Use'!$AG$61,FIXED(MinBPA_U,2))","v":"Obscured windows with U≤0.30"},null,null,null,null,{"$f":"Min_Rebate","v":0},"Yes"]
[null,"Available loan amount:",null,null,{"$f":"'For EWEB Use'!T11","v":0},null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Obscured windows with U\", 'For EWEB Use'!$AG$61,FIXED(HPBPA_U,2))","v":"Obscured windows with U≤0.22"},null,null,null,null,{"$f":"HP_Rebate","v":4},"Yes"]
[]
[null,"Window number","Width \n(inches)","Height \n(inches)","U-factor\n","Pre-existing window type?","Sliding glass patio door?","Obscured glass?","Garden window?","Was the window opening enlarged for reasons other than egress?","Comments",null,null,"Square feet","converted to feet",null,"converted to feet-inches"]
[null,null,null,null,null,null,"If \"No\", you can leave blank",null,null,null,null,null,null,null,"Width","Height","Width",null,"Height"]
[null,1,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(O24*P24, O24*P24,\"\")","v":""},{"$f":"C24/12","v":0},{"$f":"D24/12","v":0},{"$f":"CONCATENATE(ROUNDDOWN(O24,0),\"'\")","v":"0'"},{"$f":"CONCATENATE(ROUND((O24-ROUNDDOWN(O24,0))*12,1), \"''\")","v":"0''"},{"$f":"CONCATENATE(ROUNDDOWN(P24,0),\"'\")","v":"0'"},{"$f":"CONCATENATE(ROUND((P24-ROUNDDOWN(P24,0))*12,1), \"''\")","v":"0''"}]
[null,2,null,null,null,null,null,null,null,null,null,null,null,"",0,0,{"$f":"CONCATENATE(ROUNDDOWN(O25,0),\"'\")","v":"0'"},{"$f":"CONCATENATE(ROUND((O25-ROUNDDOWN(O25,0))*12,1), \"''\")","v":"0''"},{"$f":"CONCATENATE(ROUNDDOWN(P25,0),\"'\")","v":"0'"},{"$f":"CONCATENATE(ROUND((P25-ROUNDDOWN(P25,0))*12,1), \"''\")","v":"0''"}]
[null,3,null,null,null,null,null,null,null,null,null,null,null,"",0,0,{"$f":"CONCATENATE(ROUNDDOWN(O26,0),\"'\")","v":"0'"},"0''",{"$f":"CONCATENATE(ROUNDDOWN(P26,0),\"'\")","v":"0'"},"0''"]
[null,4,null,null,null,null,null,null,null,null,null,null,null,"",0,0,"0'","0''","0'","0''"]
[null,5,null,null,null,null,null,null,null,null,null,null,null,"",0,0,"0'","0''","0'","0''"]
[null,6,null,null,null,null,null,null,null,null,null,null,null,"",0,0,"0'","0''","0'","0''"]
[null,7,null,null,null,null,null,null,null,null,null,null,null,"",0,0,"0'","0''","0'","0''"]
[null,8,null,null,null,null,null,null,null,null,null,null,null,"",0,0,"0'","0''","0'","0''"]
[null,9,null,null,null,null,null,null,null,null,null,null,null,"",0,0,"0'","0''","0'","0''"]
[null,10,null,null,null,null,null,null,null,null,null,null,null,"",0,0,"0'","0''","0'","0''"]
[null,11,null,null,null,null,null,null,null,null,null,null,null,"",0,0,"0'","0''","0'","0''"]
[null,12,null,null,null,null,null,null,null,null,null,null,null,"",0,0,"0'","0''","0'","0''"]
[null,13,null,null,null,null,null,null,null,null,null,null,null,"",0,0,{"$f":"CONCATENATE(ROUNDDOWN(O36,0),\"'\")","v":"0'"},{"$f":"CONCATENATE(ROUND((O36-ROUNDDOWN(O36,0))*12,1), \"''\")","v":"0''"},{"$f":"CONCATENATE(ROUNDDOWN(P36,0),\"'\")","v":"0'"},{"$f":"CONCATENATE(ROUND((P36-ROUNDDOWN(P36,0))*12,1), \"''\")","v":"0''"}]
[null,14,null,null,null,null,null,null,null,null,null,null,null,"",0,0,"0'","0''","0'","0''"]
[null,15,null,null,null,null,null,null,null,null,null,null,null,"",0,0,"0'","0''","0'","0''"]
[null,16,null,null,null,null,null,null,null,null,null,null,null,"",0,0,"0'","0''","0'","0''"]
[null,17,null,null,null,null,null,null,null,null,null,null,null,"",0,0,"0'","0''","0'","0''"]
[null,18,null,null,null,null,null,null,null,null,null,null,null,"",0,0,"0'","0''","0'","0''"]
[null,19,null,null,null,null,null,null,null,null,null,null,null,"",0,0,"0'","0''","0'","0''"]
[null,20,null,null,null,null,null,null,null,null,null,null,null,"",0,0,"0'","0''","0'","0''"]
[null,21,null,null,null,null,null,null,null,null,null,null,null,"",0,0,"0'","0''","0'","0''"]
[null,22,null,null,null,null,null,null,null,null,null,null,null,"",0,0,"0'","0''","0'","0''"]
[null,23,null,null,null,null,null,null,null,null,null,null,null,"",0,0,"0'","0''","0'","0''"]
[null,24,null,null,null,null,null,null,null,null,null,null,null,"",0,0,"0'","0''","0'","0''"]
[null,25,null,null,null,null,null,null,null,null,null,null,null,"",0,0,"0'","0''","0'","0''"]
[null,26,null,null,null,null,null,null,null,null,null,null,null,"",0,0,"0'","0''","0'","0''"]
[null,27,null,null,null,null,null,null,null,null,null,null,null,"",0,0,"0'","0''","0'","0''"]
[null,28,null,null,null,null,null,null,null,null,null,null,null,"",0,0,"0'","0''","0'","0''"]
[null,29,null,null,null,null,null,null,null,null,null,null,null,"",0,0,"0'","0''","0'","0''"]
[null,30,null,null,null,null,null,null,null,null,null,null,null,"",0,0,"0'","0''","0'","0''"]
[null,31,null,null,null,null,null,null,null,null,null,null,null,"",0,0,"0'","0''","0'","0''"]
[null,32,null,null,null,null,null,null,null,null,null,null,null,"",0,0,"0'","0''","0'","0''"]
[null,33,null,null,null,null,null,null,null,null,null,null,null,"",0,0,"0'","0''","0'","0''"]
[null,34,null,null,null,null,null,null,null,null,null,null,null,"",0,0,"0'","0''","0'","0''"]
[null,35,null,null,null,null,null,null,null,null,null,null,null,"",0,0,"0'","0''","0'","0''"]
[null,36,null,null,null,null,null,null,null,null,null,null,null,"",0,0,"0'","0''","0'","0''"]
[null,37,null,null,null,null,null,null,null,null,null,null,null,"",0,0,"0'","0''","0'","0''"]
[null,38,null,null,null,null,null,null,null,null,null,null,null,"",0,0,"0'","0''","0'","0''"]
[null,39,null,null,null,null,null,null,null,null,null,null,null,"",0,0,"0'","0''","0'","0''"]
[null,40,null,null,null,null,null,null,null,null,null,null,null,"",0,0,"0'","0''","0'","0''"]

{"sheet":"For EWEB Use","index":1,"n_rows":112,"n_cols":74,"rows_kept":112,"cut":false,"hidden":false,"merged":[[27,26,28,26],[27,2,28,2],[27,3,27,4],[27,5,27,6],[27,7,28,8],[27,9,28,9],[27,11,28,11],[27,12,28,12],[27,13,28,13],[27,16,28,16],[27,17,28,17],[27,18,28,18],[27,19,28,19],[27,14,28,14],[27,20,28,20],[27,21,28,21],[27,22,28,22],[27,15,28,15],[13,19,17,21],[26,1,26,9],[6,29,7,29],[6,28,7,28],[12,13,12,14],[6,3,6,16],[8,15,8,16],[9,15,9,16],[10,3,10,16],[12,15,12,16],[8,13,8,14],[9,13,9,14],[6,20,6,21],[10,20,10,21],[3,20,4,21],[4,13,4,14],[5,13,5,14],[3,19,4,19],[27,1,28,1],[1,2,1,16],[3,13,3,14],[4,15,4,16],[5,15,5,16],[3,15,3,16],[27,25,28,25],[21,15,21,16],[26,13,26,21],[21,13,21,14],[13,13,13,14],[16,13,16,14],[17,13,17,14],[14,3,14,16],[16,15,16,16],[17,15,17,16],[18,3,18,16],[20,15,20,16],[20,13,20,14],[13,15,13,16],[27,23,28,23],[27,24,28,24],[3,29,5,29],[3,28,5,28],[22,29,23,29],[22,28,23,28],[19,28,21,29],[15,28,17,29],[8,28,9,29],[10,28,11,28],[10,29,11,29]]}
[]
[null,null,"This worksheet uses entries in the \"Window entry\" tab to calculate square footages & window counts, by measure type, as required for BPA.  It also calculates the area-weighted average U-factor by measure type, & allows users to pick & choose which windows are averaged together (column X) to potentially maximize customer rebates.  A Quantity column is available for larger projects with repeated windows. There are also optional columns to enter window sizes based on EWEB records to determine if total areas match. Only cells in white can be edited. (MCL 10/30/20)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Program specs based on selection on Window entry tab"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Window entry'!E7","v":"Regular-income"}]
[null,null," For EWEB measure entry, enter data shown below in red",null,null,null,null,null,null,null,null,"Count","sq ft","U-factors",null,"Rebate",null,null,null,"Cost:",{"$f":"IF('Window entry'!E13=\"\", \"\", 'Window entry'!E13)","v":""},null,null,null,null,null,null,null,"EWEB minimum windows rebate","High-performance windows"]
[null,null,null,null,null,null,null,null,null,null,"Double-pane window to U≤0.22, high performance",{"$f":"BJ71","v":0},{"$f":"ROUND(AR71,0)","v":0},{"$f":"BA71","v":0},null,{"$f":"M5*'Window entry'!S5","v":0},null,{"$f":"IF(N5>AD15, \"!!!!\", \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Double-pane glass patio door to U≤0.25, high performance",{"$f":"BK71","v":0},{"$f":"ROUND(AS71,0)","v":0},{"$f":"BB71","v":0},null,{"$f":"M6*'Window entry'!S8","v":0},null,{"$f":"IF(N6>AD23, \"!!!!\", \"\")","v":""}]
[null,null,null,{"$f":"IF(M6+M5>0, CONCATENATE(\"  Measure = Windows - Existing Window Double Pane Base to 0.22 Window Any Electric Heat;  Quantity=\",M6+M5,\" sq ft;  Cost= $\", ROUND(BS71+BT71,0)), \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U4>0, IF(U4<P22, U4, P22), P22)","v":0},{"$f":"IF(AC3=AG31, \"Available rebate\", \"Available grant\")","v":"Available rebate"},null,null,null,null,null,null,null,{"$f":"IF(AC3=LIOwn, AI32, IF(AC3=RegInc,  AI31, IF(AC3=LIRent, AI33,0)))","v":0},{"$f":"IF(AC3=LIOwn, AJ32, IF(AC3=RegInc, AJ31, IF(AC3=LIRent, AJ33,0)))","v":4}]
[]
[null,null,null,null,null,null,null,null,null,null,"Double-pane window upgrade, minimum performance",{"$f":"BF71","v":0},{"$f":"ROUND(AN71,0)","v":0},{"$f":"AW71","v":0},null,{"$f":"M9*'Window entry'!S4","v":0},null,{"$f":"IF(N9>MinBPA_U, \"!!!!\", \"\")","v":""},null,{"$f":"'Window entry'!E18","v":"OR"},null,null,null,null,null,null,null,null,"Windows must be no higher than the following U-factor:"]
[null,null,null,null,null,null,null,null,null,null,"Double-pane glass patio door upgrade, minimum performance",{"$f":"BG71","v":0},{"$f":"ROUND(AO71,0)","v":0},{"$f":"AX71","v":0},null,{"$f":"M10*'Window entry'!S7","v":0},null,{"$f":"IF(N10>MinPDBPA_U, \"!!!!\", \"\")","v":""}]
[null,null,null,{"$f":"IF(M10+M9>0, CONCATENATE(\"  Measure = Windows - Existing Window Double Pane Base to 0.30 Window Any Electric Heat;  Quantity= \",M10+M9,\" sq ft;  Cost= $\", ROUND(BO71+BP71, 0)), \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(U4=\"\", 0, IF(M22>0, IF(U4>0, IF((4000+((M13+M14+M5+M6)/(M22-M21)*2000))>U4, U4, (4000+((M13+M14+M5+M6)/(M22-M21)*2000))),4000+((M13+M14+M5+M6)/(M22-M21)*2000)),0))","v":0},"Available loan amount",null,null,null,null,null,null,null,{"$f":"ROUND(IF(AC3=LIOwn, 0.3, IF(AC3=RegInc, 0.25, IF(AC3=LIRent, 0.3,0))),2)","v":0.25},{"$f":"ROUND(IF(AC3=LIOwn, 0.22, IF(AC3=RegInc, 0.22, IF(AC3=LIRent, 0.22, 0))),2)","v":0.22}]
[]
[null,null,null,null,null,null,null,null,null,null,"Single-pane window to U≤0.22, high performance",{"$f":"BH71","v":0},{"$f":"ROUND(AP71,0)","v":0},{"$f":"AY71","v":0},null,{"$f":"M13*'Window entry'!S14","v":0},null,{"$f":"IF(N13>HPBPA_U, \"!!!!\", \"\")","v":""},null,null,null,null,null,null,null,null,null,null,"Obscured windows must be no higher than the following U-factor (BPA maximum):"]
[null,null,null,null,null,null,null,null,null,null,"Single-pane glass patio door to U≤0.25, high performance",{"$f":"BI71","v":0},{"$f":"ROUND(AQ71,0)","v":0},{"$f":"AZ71","v":0},null,{"$f":"M14*'Window entry'!S17","v":0},null,{"$f":"IF(N14>AD23, \"!!!!\", \"\")","v":""},null,{"$f":"IF(R22>0, \"CHECK YOUR MEASURE SELECTIONS! U-factors do not meet BPA criteria!\",\"\")","v":""}]
[null,null,null,{"$f":"IF(M14+M13>0, CONCATENATE(\"  Measure = Windows - Existing Window Single Pane Base to 0.22 Window Any Electric Heat;  Quantity=\",M14+M13,\" sq ft;  Cost= $\", ROUND(BQ71+BR71,0)), \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(IF(AC3=LIOwn, 0.3, IF(AC3=RegInc, 0.3, IF(AC3=LIRent, 0.3, 0))),2)","v":0.3},{"$f":"ROUND(IF(AC3=LIOwn, 0.22, IF(AC3=RegInc, 0.22, IF(AC3=LIRent, 0.22, 0))),2)","v":0.22}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Glass patio doors must be \nno higher than the following U-factor:"]
[null,null,null,null,null,null,null,null,null,null,"Single-pane window upgrade, minimum performance",{"$f":"BD71","v":0},{"$f":"ROUND(AL71,0)","v":0},{"$f":"AU71","v":0},null,{"$f":"M17*'Window entry'!S13","v":0},null,{"$f":"IF(N17>MinBPA_U, \"!!!!\", \"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,"Single-pane glass patio door upgrade, minimum performance",{"$f":"BE71","v":0},{"$f":"ROUND(AM71,0)","v":0},{"$f":"AV71","v":0},null,{"$f":"M18*'Window entry'!S16","v":0},null,{"$f":"IF(N18>MinPDBPA_U, \"!!!!\", \"\")","v":""}]
[null,null,null,{"$f":"IF(M18+M17>0, CONCATENATE(\"  Measure = Windows - Existing Window Single Pane Base to 0.30 Window Any Electric Heat;  Quantity= \", M18+M17,\" sq ft;  Cost= $\",ROUND(BM71+BN71,0)), \"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUND(IF(AC3=LIOwn, 0.35, IF(AC3=RegInc, 0.3, IF(AC3=LIRent,0.3,0))),2)","v":0.3},{"$f":"ROUND(IF(AC3=LIOwn, 0.3, IF(AC3=RegInc, 0.25, IF(AC3=LIRent,0.25,0))),2)","v":0.25}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"(Actual BPA maximum for glass patio doors:)"]
[null,null,null,null,null,null,null,null,null,null,"Ineligible windows:",{"$f":"BL71","v":0},{"$f":"ROUND(AT71,0)","v":0},null,null,0]
[null,null,null,null,null,null,null,null,null,null,"TOTALS:",{"$f":"L17+L18+L9+L10+L13+L14+L5+L6+L21","v":0},{"$f":"ROUND(SUM(N30:N48, N49:N69),0)","v":0},null,null,{"$f":"P17+P18+P9+P10+P13+P14+P5+P6","v":0},null,{"$f":"COUNTIF(R5:R19,\"!!!!\")","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Total installed sq ft:",{"$f":"SUM(N30:N48, N49:N69)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0.35,{"$f":"ROUND(0.3,2)","v":0.3}]
[null,null,null,null,null,null,null,null,null,null,null,"Sq ft of existing windows per EWEB records:",{"$f":"SUMPRODUCT(J30:J69,A30:A69)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Difference compared to installed sf:",{"$f":"IF(M23=0, \"\", (M24-M23)/M23)","v":""}]
[]
[null,"Optional",null,null,null,null,null,null,null,null,null,null,"Optional","From Window entry tab",null,null,null,null,null,null,null,null,null,"Optional","Optional",null,null,null,null,null,null,null,null,null,null,null,null,"square footages",null,null,null,null,null,null,null,null,"Ufactors",null,null,null,null,null,null,null,null,"Count",null,null,null,null,null,null,null,null,"Cost"]
[null,"Replaced?","Window number from EWEB records","Width based on EWEB records",null,"Height based on EWEB records",null,"Converted to feet",null,"Sq ft per EWEB records",null,"Window number from drawing","Quantity (blank=1)","square feet from Window entry tab","Width (ft)","Height (ft)","Pre-existing window type?","Sliding glass door?","Obscured glass?","Garden Window?","Was the window opening enlarged for reasons other than egress?","U-factor","Default Measure","Measure override","Comments","Comments from Window entry tab","Approx cost per window row, based on area"]
[null,null,null,"Feet","Inches","Feet","Inches",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"rebate","rebate","rebate","Measure selected",{"$f":"$AG$48","v":"Single-pane window to U≤0.25"},{"$f":"$AG$49","v":"Single-pane glass patio door to U≤0.30"},{"$f":"$AG$50","v":"Double-pane window to U≤0.25"},{"$f":"$AG$51","v":"Double-pane glass patio door to U≤0.30"},{"$f":"$AG$52","v":"Single-pane window to U≤0.22"},{"$f":"$AG$53","v":"Single-pane glass patio door to U≤0.25"},{"$f":"$AG$54","v":"Double-pane window to U≤0.22"},{"$f":"$AG$55","v":"Double-pane glass patio door to U≤0.25"},{"$f":"$AG$56","v":"Ineligible window"},{"$f":"$AG$48","v":"Single-pane window to U≤0.25"},{"$f":"$AG$49","v":"Single-pane glass patio door to U≤0.30"},{"$f":"$AG$50","v":"Double-pane window to U≤0.25"},{"$f":"$AG$51","v":"Double-pane glass patio door to U≤0.30"},{"$f":"$AG$52","v":"Single-pane window to U≤0.22"},{"$f":"$AG$53","v":"Single-pane glass patio door to U≤0.25"},{"$f":"$AG$54","v":"Double-pane window to U≤0.22"},{"$f":"$AG$55","v":"Double-pane glass patio door to U≤0.25"},{"$f":"$AG$56","v":"Ineligible window"},{"$f":"$AG$48","v":"Single-pane window to U≤0.25"},{"$f":"$AG$49","v":"Single-pane glass patio door to U≤0.30"},{"$f":"$AG$50","v":"Double-pane window to U≤0.25"},{"$f":"$AG$51","v":"Double-pane glass patio door to U≤0.30"},{"$f":"$AG$52","v":"Single-pane window to U≤0.22"},{"$f":"$AG$53","v":"Single-pane glass patio door to U≤0.25"},{"$f":"$AG$54","v":"Double-pane window to U≤0.22"},{"$f":"$AG$55","v":"Double-pane glass patio door to U≤0.25"},{"$f":"$AG$56","v":"Ineligible window"},{"$f":"$AG$48","v":"Single-pane window to U≤0.25"},{"$f":"$AG$49","v":"Single-pane glass patio door to U≤0.30"},{"$f":"$AG$50","v":"Double-pane window to U≤0.25"},{"$f":"$AG$51","v":"Double-pane glass patio door to U≤0.30"},{"$f":"$AG$52","v":"Single-pane window to U≤0.22"},{"$f":"$AG$53","v":"Single-pane glass patio door to U≤0.25"},{"$f":"$AG$54","v":"Double-pane window to U≤0.22"},{"$f":"$AG$55","v":"Double-pane glass patio door to U≤0.25"},{"$f":"$AG$56","v":"Ineligible window"}]
[{"$f":"IF(B30=\"Yes\", 1, 0)","v":1},"Yes",1,null,null,null,null,{"$f":"D30+E30/12","v":0},{"$f":"F30+G30/12","v":0},{"$f":"H30*I30","v":0},null,1,null,{"$f":"IF(M30=\"\", IF('Window entry'!O24*'Window entry'!P24, 'Window entry'!O24*'Window entry'!P24,\"\"), IF('Window entry'!O24*'Window entry'!P24*M30, 'Window entry'!O24*'Window entry'!P24*M30,\"\"))","v":""},{"$f":"'Window entry'!O24","v":0},{"$f":"'Window entry'!P24","v":0},{"$f":"IF('Window entry'!F24=\"\", \"\", 'Window entry'!F24)","v":""},{"$f":"IF('Window entry'!G24=\"\", \"\", 'Window entry'!G24)","v":""},{"$f":"IF('Window entry'!H24=\"\", \"\", 'Window entry'!H24)","v":""},{"$f":"IF('Window entry'!I24=\"\", \"\", 'Window entry'!I24)","v":""},{"$f":"IF('Window entry'!J24=\"\", \"\", 'Window entry'!J24)","v":""},{"$f":"IF('Window entry'!E24=\"\", \"\", 'Window entry'!E24)","v":""},{"$f":"IF(N30=\"\", \"\", IF(OR('Window entry'!J24=\"Yes\",'Window entry'!I24=\"Yes\"),$AG$56, IF(OR(Q30=\"\", V30=\"\"), \"need more data...\", IF(OR(Q30=$AG$43, Q30=$AG$44, Q30=$AG$45), $AG$56, IF(OR(Q30=$AG$40,Q30=$AG$41), IF(R30=\"Yes\", IF(V30<=MinPD_U, IF(V30<=HPPD_U, $AG$53, $AG$49), $AG$56), IF(S30=\"Yes\", IF(V30<=MinBPA_U, IF(V30<=HPBPA_U, $AG$52, $AG$48),$AG$56),IF(V30<=Min_U, IF(V30<=HP_U, $AG$52, $AG$48),$AG$56))),IF(Q30=$AG$42, IF(R30=\"Yes\",IF(V30<=MinPD_U, IF(V30<=HPPD_U, $AG$55, $AG$51), $AG$56), IF(S30=\"Yes\", IF(V30<=MinBPA_U, IF(V30<=HPBPA_U, $AG$54, $AG$50),$AG$56),IF(V30<=Min_U, IF(V30<=HP_U, $AG$54, $AG$50),$AG$56)))))))))","v":""},null,null,{"$f":"IF('Window entry'!K24=\"\", \"\", 'Window entry'!K24)","v":""},{"$f":"IF(N30=\"\", \"\", N30/SUM($N$30:$N$48, $N$49:$N$69)*$U$4)","v":""},null,null,null,null,null,"Program selections",0.3,0.25,0.22,{"$f":"IF(ISBLANK(X30), W30, X30)","v":""},{"$f":"IF($AK30=AL$29, $N30, 0)","v":0},0,0,0,0,0,0,0,{"$f":"IF(OR($AK30=AT$29, $AK30=\"need more data...\"), $N30, 0)","v":0},{"$f":"IF($AK30=AU$29, $V30, 0)","v":0},0,0,0,0,0,0,0,{"$f":"IF(OR($AK30=BC$29, $AK30=\"need more data...\"), $V30, 0)","v":0},{"$f":"IF($AK30=BD$29, IF($M30=\"\", 1, $M30), 0)","v":0},0,0,0,0,0,0,0,0,{"$f":"IF($AK30=BM$29, $AA30, 0)","v":0},0,0,0,0,0,0,0,0]
[{"$f":"IF(B31=\"Yes\", 1, 0)","v":1},"Yes",2,null,null,null,null,{"$f":"D31+E31/12","v":0},{"$f":"F31+G31/12","v":0},0,null,2,null,{"$f":"IF(M31=\"\", IF('Window entry'!O25*'Window entry'!P25, 'Window entry'!O25*'Window entry'!P25,\"\"), IF('Window entry'!O25*'Window entry'!P25*M31, 'Window entry'!O25*'Window entry'!P25*M31,\"\"))","v":""},{"$f":"'Window entry'!O25","v":0},{"$f":"'Window entry'!P25","v":0},{"$f":"IF('Window entry'!F25=\"\", \"\", 'Window entry'!F25)","v":""},{"$f":"IF('Window entry'!G25=\"\", \"\", 'Window entry'!G25)","v":""},{"$f":"IF('Window entry'!H25=\"\", \"\", 'Window entry'!H25)","v":""},{"$f":"IF('Window entry'!I25=\"\", \"\", 'Window entry'!I25)","v":""},{"$f":"IF('Window entry'!J25=\"\", \"\", 'Window entry'!J25)","v":""},{"$f":"IF('Window entry'!E25=\"\", \"\", 'Window entry'!E25)","v":""},{"$f":"IF(N31=\"\", \"\", IF(OR('Window entry'!J25=\"Yes\",'Window entry'!I25=\"Yes\"),$AG$56, IF(OR(Q31=\"\", V31=\"\"), \"need more data...\", IF(OR(Q31=$AG$43, Q31=$AG$44, Q31=$AG$45), $AG$56, IF(OR(Q31=$AG$40,Q31=$AG$41), IF(R31=\"Yes\", IF(V31<=MinPD_U, IF(V31<=HPPD_U, $AG$53, $AG$49), $AG$56), IF(S31=\"Yes\", IF(V31<=MinBPA_U, IF(V31<=HPBPA_U, $AG$52, $AG$48),$AG$56),IF(V31<=Min_U, IF(V31<=HP_U, $AG$52, $AG$48),$AG$56))),IF(Q31=$AG$42, IF(R31=\"Yes\",IF(V31<=MinPD_U, IF(V31<=HPPD_U, $AG$55, $AG$51), $AG$56), IF(S31=\"Yes\", IF(V31<=MinBPA_U, IF(V31<=HPBPA_U, $AG$54, $AG$50),$AG$56),IF(V31<=Min_U, IF(V31<=HP_U, $AG$54, $AG$50),$AG$56)))))))))","v":""},null,null,{"$f":"IF('Window entry'!K25=\"\", \"\", 'Window entry'!K25)","v":""},"",null,null,null,null,null,"Regular-income",0,0,4,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,"Yes",3,null,null,null,null,0,0,0,null,3,null,{"$f":"IF(M32=\"\", IF('Window entry'!O26*'Window entry'!P26, 'Window entry'!O26*'Window entry'!P26,\"\"), IF('Window entry'!O26*'Window entry'!P26*M32, 'Window entry'!O26*'Window entry'!P26*M32,\"\"))","v":""},{"$f":"'Window entry'!O26","v":0},{"$f":"'Window entry'!P26","v":0},{"$f":"IF('Window entry'!F26=\"\", \"\", 'Window entry'!F26)","v":""},{"$f":"IF('Window entry'!G26=\"\", \"\", 'Window entry'!G26)","v":""},{"$f":"IF('Window entry'!H26=\"\", \"\", 'Window entry'!H26)","v":""},{"$f":"IF('Window entry'!I26=\"\", \"\", 'Window entry'!I26)","v":""},{"$f":"IF('Window entry'!J26=\"\", \"\", 'Window entry'!J26)","v":""},{"$f":"IF('Window entry'!E26=\"\", \"\", 'Window entry'!E26)","v":""},{"$f":"IF(N32=\"\", \"\", IF(OR('Window entry'!J26=\"Yes\",'Window entry'!I26=\"Yes\"),$AG$56, IF(OR(Q32=\"\", V32=\"\"), \"need more data...\", IF(OR(Q32=$AG$43, Q32=$AG$44, Q32=$AG$45), $AG$56, IF(OR(Q32=$AG$40,Q32=$AG$41), IF(R32=\"Yes\", IF(V32<=MinPD_U, IF(V32<=HPPD_U, $AG$53, $AG$49), $AG$56), IF(S32=\"Yes\", IF(V32<=MinBPA_U, IF(V32<=HPBPA_U, $AG$52, $AG$48),$AG$56),IF(V32<=Min_U, IF(V32<=HP_U, $AG$52, $AG$48),$AG$56))),IF(Q32=$AG$42, IF(R32=\"Yes\",IF(V32<=MinPD_U, IF(V32<=HPPD_U, $AG$55, $AG$51), $AG$56), IF(S32=\"Yes\", IF(V32<=MinBPA_U, IF(V32<=HPBPA_U, $AG$54, $AG$50),$AG$56),IF(V32<=Min_U, IF(V32<=HP_U, $AG$54, $AG$50),$AG$56)))))))))","v":""},null,null,{"$f":"IF('Window entry'!K26=\"\", \"\", 'Window entry'!K26)","v":""},"",null,null,null,null,null,"Limited-income owner-occupied",0,20,20,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,"Yes",4,null,null,null,null,0,0,0,null,4,null,{"$f":"IF(M33=\"\", IF('Window entry'!O27*'Window entry'!P27, 'Window entry'!O27*'Window entry'!P27,\"\"), IF('Window entry'!O27*'Window entry'!P27*M33, 'Window entry'!O27*'Window entry'!P27*M33,\"\"))","v":""},{"$f":"'Window entry'!O27","v":0},{"$f":"'Window entry'!P27","v":0},{"$f":"IF('Window entry'!F27=\"\", \"\", 'Window entry'!F27)","v":""},{"$f":"IF('Window entry'!G27=\"\", \"\", 'Window entry'!G27)","v":""},{"$f":"IF('Window entry'!H27=\"\", \"\", 'Window entry'!H27)","v":""},{"$f":"IF('Window entry'!I27=\"\", \"\", 'Window entry'!I27)","v":""},{"$f":"IF('Window entry'!J27=\"\", \"\", 'Window entry'!J27)","v":""},{"$f":"IF('Window entry'!E27=\"\", \"\", 'Window entry'!E27)","v":""},{"$f":"IF(N33=\"\", \"\", IF(OR('Window entry'!J27=\"Yes\",'Window entry'!I27=\"Yes\"),$AG$56, IF(OR(Q33=\"\", V33=\"\"), \"need more data...\", IF(OR(Q33=$AG$43, Q33=$AG$44, Q33=$AG$45), $AG$56, IF(OR(Q33=$AG$40,Q33=$AG$41), IF(R33=\"Yes\", IF(V33<=MinPD_U, IF(V33<=HPPD_U, $AG$53, $AG$49), $AG$56), IF(S33=\"Yes\", IF(V33<=MinBPA_U, IF(V33<=HPBPA_U, $AG$52, $AG$48),$AG$56),IF(V33<=Min_U, IF(V33<=HP_U, $AG$52, $AG$48),$AG$56))),IF(Q33=$AG$42, IF(R33=\"Yes\",IF(V33<=MinPD_U, IF(V33<=HPPD_U, $AG$55, $AG$51), $AG$56), IF(S33=\"Yes\", IF(V33<=MinBPA_U, IF(V33<=HPBPA_U, $AG$54, $AG$50),$AG$56),IF(V33<=Min_U, IF(V33<=HP_U, $AG$54, $AG$50),$AG$56)))))))))","v":""},null,null,{"$f":"IF('Window entry'!K27=\"\", \"\", 'Window entry'!K27)","v":""},"",null,null,null,null,null,"Limited-income rental",0,0,10,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,"Yes",5,null,null,null,null,0,0,0,null,5,null,{"$f":"IF(M34=\"\", IF('Window entry'!O28*'Window entry'!P28, 'Window entry'!O28*'Window entry'!P28,\"\"), IF('Window entry'!O28*'Window entry'!P28*M34, 'Window entry'!O28*'Window entry'!P28*M34,\"\"))","v":""},{"$f":"'Window entry'!O28","v":0},{"$f":"'Window entry'!P28","v":0},{"$f":"IF('Window entry'!F28=\"\", \"\", 'Window entry'!F28)","v":""},{"$f":"IF('Window entry'!G28=\"\", \"\", 'Window entry'!G28)","v":""},{"$f":"IF('Window entry'!H28=\"\", \"\", 'Window entry'!H28)","v":""},{"$f":"IF('Window entry'!I28=\"\", \"\", 'Window entry'!I28)","v":""},{"$f":"IF('Window entry'!J28=\"\", \"\", 'Window entry'!J28)","v":""},{"$f":"IF('Window entry'!E28=\"\", \"\", 'Window entry'!E28)","v":""},{"$f":"IF(N34=\"\", \"\", IF(OR('Window entry'!J28=\"Yes\",'Window entry'!I28=\"Yes\"),$AG$56, IF(OR(Q34=\"\", V34=\"\"), \"need more data...\", IF(OR(Q34=$AG$43, Q34=$AG$44, Q34=$AG$45), $AG$56, IF(OR(Q34=$AG$40,Q34=$AG$41), IF(R34=\"Yes\", IF(V34<=MinPD_U, IF(V34<=HPPD_U, $AG$53, $AG$49), $AG$56), IF(S34=\"Yes\", IF(V34<=MinBPA_U, IF(V34<=HPBPA_U, $AG$52, $AG$48),$AG$56),IF(V34<=Min_U, IF(V34<=HP_U, $AG$52, $AG$48),$AG$56))),IF(Q34=$AG$42, IF(R34=\"Yes\",IF(V34<=MinPD_U, IF(V34<=HPPD_U, $AG$55, $AG$51), $AG$56), IF(S34=\"Yes\", IF(V34<=MinBPA_U, IF(V34<=HPBPA_U, $AG$54, $AG$50),$AG$56),IF(V34<=Min_U, IF(V34<=HP_U, $AG$54, $AG$50),$AG$56)))))))))","v":""},null,null,{"$f":"IF('Window entry'!K28=\"\", \"\", 'Window entry'!K28)","v":""},"",null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,"Yes",6,null,null,null,null,0,0,0,null,6,null,{"$f":"IF(M35=\"\", IF('Window entry'!O29*'Window entry'!P29, 'Window entry'!O29*'Window entry'!P29,\"\"), IF('Window entry'!O29*'Window entry'!P29*M35, 'Window entry'!O29*'Window entry'!P29*M35,\"\"))","v":""},{"$f":"'Window entry'!O29","v":0},{"$f":"'Window entry'!P29","v":0},{"$f":"IF('Window entry'!F29=\"\", \"\", 'Window entry'!F29)","v":""},{"$f":"IF('Window entry'!G29=\"\", \"\", 'Window entry'!G29)","v":""},{"$f":"IF('Window entry'!H29=\"\", \"\", 'Window entry'!H29)","v":""},{"$f":"IF('Window entry'!I29=\"\", \"\", 'Window entry'!I29)","v":""},{"$f":"IF('Window entry'!J29=\"\", \"\", 'Window entry'!J29)","v":""},{"$f":"IF('Window entry'!E29=\"\", \"\", 'Window entry'!E29)","v":""},{"$f":"IF(N35=\"\", \"\", IF(OR('Window entry'!J29=\"Yes\",'Window entry'!I29=\"Yes\"),$AG$56, IF(OR(Q35=\"\", V35=\"\"), \"need more data...\", IF(OR(Q35=$AG$43, Q35=$AG$44, Q35=$AG$45), $AG$56, IF(OR(Q35=$AG$40,Q35=$AG$41), IF(R35=\"Yes\", IF(V35<=MinPD_U, IF(V35<=HPPD_U, $AG$53, $AG$49), $AG$56), IF(S35=\"Yes\", IF(V35<=MinBPA_U, IF(V35<=HPBPA_U, $AG$52, $AG$48),$AG$56),IF(V35<=Min_U, IF(V35<=HP_U, $AG$52, $AG$48),$AG$56))),IF(Q35=$AG$42, IF(R35=\"Yes\",IF(V35<=MinPD_U, IF(V35<=HPPD_U, $AG$55, $AG$51), $AG$56), IF(S35=\"Yes\", IF(V35<=MinBPA_U, IF(V35<=HPBPA_U, $AG$54, $AG$50),$AG$56),IF(V35<=Min_U, IF(V35<=HP_U, $AG$54, $AG$50),$AG$56)))))))))","v":""},null,null,{"$f":"IF('Window entry'!K29=\"\", \"\", 'Window entry'!K29)","v":""},"",null,null,null,null,null,"Booleans",null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,"Yes",7,null,null,null,null,0,0,0,null,7,null,{"$f":"IF(M36=\"\", IF('Window entry'!O30*'Window entry'!P30, 'Window entry'!O30*'Window entry'!P30,\"\"), IF('Window entry'!O30*'Window entry'!P30*M36, 'Window entry'!O30*'Window entry'!P30*M36,\"\"))","v":""},{"$f":"'Window entry'!O30","v":0},{"$f":"'Window entry'!P30","v":0},{"$f":"IF('Window entry'!F30=\"\", \"\", 'Window entry'!F30)","v":""},{"$f":"IF('Window entry'!G30=\"\", \"\", 'Window entry'!G30)","v":""},{"$f":"IF('Window entry'!H30=\"\", \"\", 'Window entry'!H30)","v":""},{"$f":"IF('Window entry'!I30=\"\", \"\", 'Window entry'!I30)","v":""},{"$f":"IF('Window entry'!J30=\"\", \"\", 'Window entry'!J30)","v":""},{"$f":"IF('Window entry'!E30=\"\", \"\", 'Window entry'!E30)","v":""},{"$f":"IF(N36=\"\", \"\", IF(OR('Window entry'!J30=\"Yes\",'Window entry'!I30=\"Yes\"),$AG$56, IF(OR(Q36=\"\", V36=\"\"), \"need more data...\", IF(OR(Q36=$AG$43, Q36=$AG$44, Q36=$AG$45), $AG$56, IF(OR(Q36=$AG$40,Q36=$AG$41), IF(R36=\"Yes\", IF(V36<=MinPD_U, IF(V36<=HPPD_U, $AG$53, $AG$49), $AG$56), IF(S36=\"Yes\", IF(V36<=MinBPA_U, IF(V36<=HPBPA_U, $AG$52, $AG$48),$AG$56),IF(V36<=Min_U, IF(V36<=HP_U, $AG$52, $AG$48),$AG$56))),IF(Q36=$AG$42, IF(R36=\"Yes\",IF(V36<=MinPD_U, IF(V36<=HPPD_U, $AG$55, $AG$51), $AG$56), IF(S36=\"Yes\", IF(V36<=MinBPA_U, IF(V36<=HPBPA_U, $AG$54, $AG$50),$AG$56),IF(V36<=Min_U, IF(V36<=HP_U, $AG$54, $AG$50),$AG$56)))))))))","v":""},null,null,{"$f":"IF('Window entry'!K30=\"\", \"\", 'Window entry'!K30)","v":""},"",null,null,null,null,null,"Yes",null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,"Yes",8,null,null,null,null,0,0,0,null,8,null,{"$f":"IF(M37=\"\", IF('Window entry'!O31*'Window entry'!P31, 'Window entry'!O31*'Window entry'!P31,\"\"), IF('Window entry'!O31*'Window entry'!P31*M37, 'Window entry'!O31*'Window entry'!P31*M37,\"\"))","v":""},{"$f":"'Window entry'!O31","v":0},{"$f":"'Window entry'!P31","v":0},{"$f":"IF('Window entry'!F31=\"\", \"\", 'Window entry'!F31)","v":""},{"$f":"IF('Window entry'!G31=\"\", \"\", 'Window entry'!G31)","v":""},{"$f":"IF('Window entry'!H31=\"\", \"\", 'Window entry'!H31)","v":""},{"$f":"IF('Window entry'!I31=\"\", \"\", 'Window entry'!I31)","v":""},{"$f":"IF('Window entry'!J31=\"\", \"\", 'Window entry'!J31)","v":""},{"$f":"IF('Window entry'!E31=\"\", \"\", 'Window entry'!E31)","v":""},{"$f":"IF(N37=\"\", \"\", IF(OR('Window entry'!J31=\"Yes\",'Window entry'!I31=\"Yes\"),$AG$56, IF(OR(Q37=\"\", V37=\"\"), \"need more data...\", IF(OR(Q37=$AG$43, Q37=$AG$44, Q37=$AG$45), $AG$56, IF(OR(Q37=$AG$40,Q37=$AG$41), IF(R37=\"Yes\", IF(V37<=MinPD_U, IF(V37<=HPPD_U, $AG$53, $AG$49), $AG$56), IF(S37=\"Yes\", IF(V37<=MinBPA_U, IF(V37<=HPBPA_U, $AG$52, $AG$48),$AG$56),IF(V37<=Min_U, IF(V37<=HP_U, $AG$52, $AG$48),$AG$56))),IF(Q37=$AG$42, IF(R37=\"Yes\",IF(V37<=MinPD_U, IF(V37<=HPPD_U, $AG$55, $AG$51), $AG$56), IF(S37=\"Yes\", IF(V37<=MinBPA_U, IF(V37<=HPBPA_U, $AG$54, $AG$50),$AG$56),IF(V37<=Min_U, IF(V37<=HP_U, $AG$54, $AG$50),$AG$56)))))))))","v":""},null,null,{"$f":"IF('Window entry'!K31=\"\", \"\", 'Window entry'!K31)","v":""},"",null,null,null,null,null,"No",null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,"Yes",9,null,null,null,null,0,0,0,null,9,null,{"$f":"IF(M38=\"\", IF('Window entry'!O32*'Window entry'!P32, 'Window entry'!O32*'Window entry'!P32,\"\"), IF('Window entry'!O32*'Window entry'!P32*M38, 'Window entry'!O32*'Window entry'!P32*M38,\"\"))","v":""},{"$f":"'Window entry'!O32","v":0},{"$f":"'Window entry'!P32","v":0},{"$f":"IF('Window entry'!F32=\"\", \"\", 'Window entry'!F32)","v":""},{"$f":"IF('Window entry'!G32=\"\", \"\", 'Window entry'!G32)","v":""},{"$f":"IF('Window entry'!H32=\"\", \"\", 'Window entry'!H32)","v":""},{"$f":"IF('Window entry'!I32=\"\", \"\", 'Window entry'!I32)","v":""},{"$f":"IF('Window entry'!J32=\"\", \"\", 'Window entry'!J32)","v":""},{"$f":"IF('Window entry'!E32=\"\", \"\", 'Window entry'!E32)","v":""},{"$f":"IF(N38=\"\", \"\", IF(OR('Window entry'!J32=\"Yes\",'Window entry'!I32=\"Yes\"),$AG$56, IF(OR(Q38=\"\", V38=\"\"), \"need more data...\", IF(OR(Q38=$AG$43, Q38=$AG$44, Q38=$AG$45), $AG$56, IF(OR(Q38=$AG$40,Q38=$AG$41), IF(R38=\"Yes\", IF(V38<=MinPD_U, IF(V38<=HPPD_U, $AG$53, $AG$49), $AG$56), IF(S38=\"Yes\", IF(V38<=MinBPA_U, IF(V38<=HPBPA_U, $AG$52, $AG$48),$AG$56),IF(V38<=Min_U, IF(V38<=HP_U, $AG$52, $AG$48),$AG$56))),IF(Q38=$AG$42, IF(R38=\"Yes\",IF(V38<=MinPD_U, IF(V38<=HPPD_U, $AG$55, $AG$51), $AG$56), IF(S38=\"Yes\", IF(V38<=MinBPA_U, IF(V38<=HPBPA_U, $AG$54, $AG$50),$AG$56),IF(V38<=Min_U, IF(V38<=HP_U, $AG$54, $AG$50),$AG$56)))))))))","v":""},null,null,{"$f":"IF('Window entry'!K32=\"\", \"\", 'Window entry'!K32)","v":""},"",null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,"Yes",10,null,null,null,null,0,0,0,null,10,null,{"$f":"IF(M39=\"\", IF('Window entry'!O33*'Window entry'!P33, 'Window entry'!O33*'Window entry'!P33,\"\"), IF('Window entry'!O33*'Window entry'!P33*M39, 'Window entry'!O33*'Window entry'!P33*M39,\"\"))","v":""},{"$f":"'Window entry'!O33","v":0},{"$f":"'Window entry'!P33","v":0},{"$f":"IF('Window entry'!F33=\"\", \"\", 'Window entry'!F33)","v":""},{"$f":"IF('Window entry'!G33=\"\", \"\", 'Window entry'!G33)","v":""},{"$f":"IF('Window entry'!H33=\"\", \"\", 'Window entry'!H33)","v":""},{"$f":"IF('Window entry'!I33=\"\", \"\", 'Window entry'!I33)","v":""},{"$f":"IF('Window entry'!J33=\"\", \"\", 'Window entry'!J33)","v":""},{"$f":"IF('Window entry'!E33=\"\", \"\", 'Window entry'!E33)","v":""},{"$f":"IF(N39=\"\", \"\", IF(OR('Window entry'!J33=\"Yes\",'Window entry'!I33=\"Yes\"),$AG$56, IF(OR(Q39=\"\", V39=\"\"), \"need more data...\", IF(OR(Q39=$AG$43, Q39=$AG$44, Q39=$AG$45), $AG$56, IF(OR(Q39=$AG$40,Q39=$AG$41), IF(R39=\"Yes\", IF(V39<=MinPD_U, IF(V39<=HPPD_U, $AG$53, $AG$49), $AG$56), IF(S39=\"Yes\", IF(V39<=MinBPA_U, IF(V39<=HPBPA_U, $AG$52, $AG$48),$AG$56),IF(V39<=Min_U, IF(V39<=HP_U, $AG$52, $AG$48),$AG$56))),IF(Q39=$AG$42, IF(R39=\"Yes\",IF(V39<=MinPD_U, IF(V39<=HPPD_U, $AG$55, $AG$51), $AG$56), IF(S39=\"Yes\", IF(V39<=MinBPA_U, IF(V39<=HPBPA_U, $AG$54, $AG$50),$AG$56),IF(V39<=Min_U, IF(V39<=HP_U, $AG$54, $AG$50),$AG$56)))))))))","v":""},null,null,{"$f":"IF('Window entry'!K33=\"\", \"\", 'Window entry'!K33)","v":""},"",null,null,null,null,null,"Window selections",null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,"Yes",11,null,null,null,null,0,0,0,null,11,null,{"$f":"IF(M40=\"\", IF('Window entry'!O34*'Window entry'!P34, 'Window entry'!O34*'Window entry'!P34,\"\"), IF('Window entry'!O34*'Window entry'!P34*M40, 'Window entry'!O34*'Window entry'!P34*M40,\"\"))","v":""},{"$f":"'Window entry'!O34","v":0},{"$f":"'Window entry'!P34","v":0},{"$f":"IF('Window entry'!F34=\"\", \"\", 'Window entry'!F34)","v":""},{"$f":"IF('Window entry'!G34=\"\", \"\", 'Window entry'!G34)","v":""},{"$f":"IF('Window entry'!H34=\"\", \"\", 'Window entry'!H34)","v":""},{"$f":"IF('Window entry'!I34=\"\", \"\", 'Window entry'!I34)","v":""},{"$f":"IF('Window entry'!J34=\"\", \"\", 'Window entry'!J34)","v":""},{"$f":"IF('Window entry'!E34=\"\", \"\", 'Window entry'!E34)","v":""},{"$f":"IF(N40=\"\", \"\", IF(OR('Window entry'!J34=\"Yes\",'Window entry'!I34=\"Yes\"),$AG$56, IF(OR(Q40=\"\", V40=\"\"), \"need more data...\", IF(OR(Q40=$AG$43, Q40=$AG$44, Q40=$AG$45), $AG$56, IF(OR(Q40=$AG$40,Q40=$AG$41), IF(R40=\"Yes\", IF(V40<=MinPD_U, IF(V40<=HPPD_U, $AG$53, $AG$49), $AG$56), IF(S40=\"Yes\", IF(V40<=MinBPA_U, IF(V40<=HPBPA_U, $AG$52, $AG$48),$AG$56),IF(V40<=Min_U, IF(V40<=HP_U, $AG$52, $AG$48),$AG$56))),IF(Q40=$AG$42, IF(R40=\"Yes\",IF(V40<=MinPD_U, IF(V40<=HPPD_U, $AG$55, $AG$51), $AG$56), IF(S40=\"Yes\", IF(V40<=MinBPA_U, IF(V40<=HPBPA_U, $AG$54, $AG$50),$AG$56),IF(V40<=Min_U, IF(V40<=HP_U, $AG$54, $AG$50),$AG$56)))))))))","v":""},null,null,{"$f":"IF('Window entry'!K34=\"\", \"\", 'Window entry'!K34)","v":""},"",null,null,null,null,null,"Single-pane",null,null,null,"",{"$f":"IF($AK40=AL$29, $N40, 0)","v":0},0,0,0,0,0,0,0,0,{"$f":"IF($AK40=AU$29, $V40, 0)","v":0},0,0,0,0,0,0,0,0,{"$f":"IF($AK40=BD$29, IF($M40=\"\", 1, $M40), 0)","v":0},0,0,0,0,0,0,0,0,{"$f":"IF($AK40=BM$29, $AA40, 0)","v":0},0,0,0,0,0,0,0,0]
[1,"Yes",12,null,null,null,null,0,0,0,null,12,null,{"$f":"IF(M41=\"\", IF('Window entry'!O35*'Window entry'!P35, 'Window entry'!O35*'Window entry'!P35,\"\"), IF('Window entry'!O35*'Window entry'!P35*M41, 'Window entry'!O35*'Window entry'!P35*M41,\"\"))","v":""},{"$f":"'Window entry'!O35","v":0},{"$f":"'Window entry'!P35","v":0},{"$f":"IF('Window entry'!F35=\"\", \"\", 'Window entry'!F35)","v":""},{"$f":"IF('Window entry'!G35=\"\", \"\", 'Window entry'!G35)","v":""},{"$f":"IF('Window entry'!H35=\"\", \"\", 'Window entry'!H35)","v":""},{"$f":"IF('Window entry'!I35=\"\", \"\", 'Window entry'!I35)","v":""},{"$f":"IF('Window entry'!J35=\"\", \"\", 'Window entry'!J35)","v":""},{"$f":"IF('Window entry'!E35=\"\", \"\", 'Window entry'!E35)","v":""},{"$f":"IF(N41=\"\", \"\", IF(OR('Window entry'!J35=\"Yes\",'Window entry'!I35=\"Yes\"),$AG$56, IF(OR(Q41=\"\", V41=\"\"), \"need more data...\", IF(OR(Q41=$AG$43, Q41=$AG$44, Q41=$AG$45), $AG$56, IF(OR(Q41=$AG$40,Q41=$AG$41), IF(R41=\"Yes\", IF(V41<=MinPD_U, IF(V41<=HPPD_U, $AG$53, $AG$49), $AG$56), IF(S41=\"Yes\", IF(V41<=MinBPA_U, IF(V41<=HPBPA_U, $AG$52, $AG$48),$AG$56),IF(V41<=Min_U, IF(V41<=HP_U, $AG$52, $AG$48),$AG$56))),IF(Q41=$AG$42, IF(R41=\"Yes\",IF(V41<=MinPD_U, IF(V41<=HPPD_U, $AG$55, $AG$51), $AG$56), IF(S41=\"Yes\", IF(V41<=MinBPA_U, IF(V41<=HPBPA_U, $AG$54, $AG$50),$AG$56),IF(V41<=Min_U, IF(V41<=HP_U, $AG$54, $AG$50),$AG$56)))))))))","v":""},null,null,{"$f":"IF('Window entry'!K35=\"\", \"\", 'Window entry'!K35)","v":""},"",null,null,null,null,null,"Single-pane w/storm",null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,"Yes",13,null,null,null,null,0,0,0,null,13,null,{"$f":"IF(M42=\"\", IF('Window entry'!O36*'Window entry'!P36, 'Window entry'!O36*'Window entry'!P36,\"\"), IF('Window entry'!O36*'Window entry'!P36*M42, 'Window entry'!O36*'Window entry'!P36*M42,\"\"))","v":""},{"$f":"'Window entry'!O36","v":0},{"$f":"'Window entry'!P36","v":0},{"$f":"IF('Window entry'!F36=\"\", \"\", 'Window entry'!F36)","v":""},{"$f":"IF('Window entry'!G36=\"\", \"\", 'Window entry'!G36)","v":""},{"$f":"IF('Window entry'!H36=\"\", \"\", 'Window entry'!H36)","v":""},{"$f":"IF('Window entry'!I36=\"\", \"\", 'Window entry'!I36)","v":""},{"$f":"IF('Window entry'!J36=\"\", \"\", 'Window entry'!J36)","v":""},{"$f":"IF('Window entry'!E36=\"\", \"\", 'Window entry'!E36)","v":""},{"$f":"IF(N42=\"\", \"\", IF(OR('Window entry'!J36=\"Yes\",'Window entry'!I36=\"Yes\"),$AG$56, IF(OR(Q42=\"\", V42=\"\"), \"need more data...\", IF(OR(Q42=$AG$43, Q42=$AG$44, Q42=$AG$45), $AG$56, IF(OR(Q42=$AG$40,Q42=$AG$41), IF(R42=\"Yes\", IF(V42<=MinPD_U, IF(V42<=HPPD_U, $AG$53, $AG$49), $AG$56), IF(S42=\"Yes\", IF(V42<=MinBPA_U, IF(V42<=HPBPA_U, $AG$52, $AG$48),$AG$56),IF(V42<=Min_U, IF(V42<=HP_U, $AG$52, $AG$48),$AG$56))),IF(Q42=$AG$42, IF(R42=\"Yes\",IF(V42<=MinPD_U, IF(V42<=HPPD_U, $AG$55, $AG$51), $AG$56), IF(S42=\"Yes\", IF(V42<=MinBPA_U, IF(V42<=HPBPA_U, $AG$54, $AG$50),$AG$56),IF(V42<=Min_U, IF(V42<=HP_U, $AG$54, $AG$50),$AG$56)))))))))","v":""},null,null,{"$f":"IF('Window entry'!K36=\"\", \"\", 'Window entry'!K36)","v":""},"",null,null,null,null,null,"Double-pane metal",null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,"Yes",14,null,null,null,null,0,0,0,null,14,null,{"$f":"IF(M43=\"\", IF('Window entry'!O37*'Window entry'!P37, 'Window entry'!O37*'Window entry'!P37,\"\"), IF('Window entry'!O37*'Window entry'!P37*M43, 'Window entry'!O37*'Window entry'!P37*M43,\"\"))","v":""},{"$f":"'Window entry'!O37","v":0},{"$f":"'Window entry'!P37","v":0},{"$f":"IF('Window entry'!F37=\"\", \"\", 'Window entry'!F37)","v":""},{"$f":"IF('Window entry'!G37=\"\", \"\", 'Window entry'!G37)","v":""},{"$f":"IF('Window entry'!H37=\"\", \"\", 'Window entry'!H37)","v":""},{"$f":"IF('Window entry'!I37=\"\", \"\", 'Window entry'!I37)","v":""},{"$f":"IF('Window entry'!J37=\"\", \"\", 'Window entry'!J37)","v":""},{"$f":"IF('Window entry'!E37=\"\", \"\", 'Window entry'!E37)","v":""},{"$f":"IF(N43=\"\", \"\", IF(OR('Window entry'!J37=\"Yes\",'Window entry'!I37=\"Yes\"),$AG$56, IF(OR(Q43=\"\", V43=\"\"), \"need more data...\", IF(OR(Q43=$AG$43, Q43=$AG$44, Q43=$AG$45), $AG$56, IF(OR(Q43=$AG$40,Q43=$AG$41), IF(R43=\"Yes\", IF(V43<=MinPD_U, IF(V43<=HPPD_U, $AG$53, $AG$49), $AG$56), IF(S43=\"Yes\", IF(V43<=MinBPA_U, IF(V43<=HPBPA_U, $AG$52, $AG$48),$AG$56),IF(V43<=Min_U, IF(V43<=HP_U, $AG$52, $AG$48),$AG$56))),IF(Q43=$AG$42, IF(R43=\"Yes\",IF(V43<=MinPD_U, IF(V43<=HPPD_U, $AG$55, $AG$51), $AG$56), IF(S43=\"Yes\", IF(V43<=MinBPA_U, IF(V43<=HPBPA_U, $AG$54, $AG$50),$AG$56),IF(V43<=Min_U, IF(V43<=HP_U, $AG$54, $AG$50),$AG$56)))))))))","v":""},null,null,{"$f":"IF('Window entry'!K37=\"\", \"\", 'Window entry'!K37)","v":""},"",null,null,null,null,null,"Double-pane wood",null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,"Yes",15,null,null,null,null,0,0,0,null,15,null,{"$f":"IF(M44=\"\", IF('Window entry'!O38*'Window entry'!P38, 'Window entry'!O38*'Window entry'!P38,\"\"), IF('Window entry'!O38*'Window entry'!P38*M44, 'Window entry'!O38*'Window entry'!P38*M44,\"\"))","v":""},{"$f":"'Window entry'!O38","v":0},{"$f":"'Window entry'!P38","v":0},{"$f":"IF('Window entry'!F38=\"\", \"\", 'Window entry'!F38)","v":""},{"$f":"IF('Window entry'!G38=\"\", \"\", 'Window entry'!G38)","v":""},{"$f":"IF('Window entry'!H38=\"\", \"\", 'Window entry'!H38)","v":""},{"$f":"IF('Window entry'!I38=\"\", \"\", 'Window entry'!I38)","v":""},{"$f":"IF('Window entry'!J38=\"\", \"\", 'Window entry'!J38)","v":""},{"$f":"IF('Window entry'!E38=\"\", \"\", 'Window entry'!E38)","v":""},{"$f":"IF(N44=\"\", \"\", IF(OR('Window entry'!J38=\"Yes\",'Window entry'!I38=\"Yes\"),$AG$56, IF(OR(Q44=\"\", V44=\"\"), \"need more data...\", IF(OR(Q44=$AG$43, Q44=$AG$44, Q44=$AG$45), $AG$56, IF(OR(Q44=$AG$40,Q44=$AG$41), IF(R44=\"Yes\", IF(V44<=MinPD_U, IF(V44<=HPPD_U, $AG$53, $AG$49), $AG$56), IF(S44=\"Yes\", IF(V44<=MinBPA_U, IF(V44<=HPBPA_U, $AG$52, $AG$48),$AG$56),IF(V44<=Min_U, IF(V44<=HP_U, $AG$52, $AG$48),$AG$56))),IF(Q44=$AG$42, IF(R44=\"Yes\",IF(V44<=MinPD_U, IF(V44<=HPPD_U, $AG$55, $AG$51), $AG$56), IF(S44=\"Yes\", IF(V44<=MinBPA_U, IF(V44<=HPBPA_U, $AG$54, $AG$50),$AG$56),IF(V44<=Min_U, IF(V44<=HP_U, $AG$54, $AG$50),$AG$56)))))))))","v":""},null,null,{"$f":"IF('Window entry'!K38=\"\", \"\", 'Window entry'!K38)","v":""},"",null,null,null,null,null,"Double-pane vinyl",null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,"Yes",16,null,null,null,null,0,0,0,null,16,null,{"$f":"IF(M45=\"\", IF('Window entry'!O39*'Window entry'!P39, 'Window entry'!O39*'Window entry'!P39,\"\"), IF('Window entry'!O39*'Window entry'!P39*M45, 'Window entry'!O39*'Window entry'!P39*M45,\"\"))","v":""},{"$f":"'Window entry'!O39","v":0},{"$f":"'Window entry'!P39","v":0},{"$f":"IF('Window entry'!F39=\"\", \"\", 'Window entry'!F39)","v":""},{"$f":"IF('Window entry'!G39=\"\", \"\", 'Window entry'!G39)","v":""},{"$f":"IF('Window entry'!H39=\"\", \"\", 'Window entry'!H39)","v":""},{"$f":"IF('Window entry'!I39=\"\", \"\", 'Window entry'!I39)","v":""},{"$f":"IF('Window entry'!J39=\"\", \"\", 'Window entry'!J39)","v":""},{"$f":"IF('Window entry'!E39=\"\", \"\", 'Window entry'!E39)","v":""},{"$f":"IF(N45=\"\", \"\", IF(OR('Window entry'!J39=\"Yes\",'Window entry'!I39=\"Yes\"),$AG$56, IF(OR(Q45=\"\", V45=\"\"), \"need more data...\", IF(OR(Q45=$AG$43, Q45=$AG$44, Q45=$AG$45), $AG$56, IF(OR(Q45=$AG$40,Q45=$AG$41), IF(R45=\"Yes\", IF(V45<=MinPD_U, IF(V45<=HPPD_U, $AG$53, $AG$49), $AG$56), IF(S45=\"Yes\", IF(V45<=MinBPA_U, IF(V45<=HPBPA_U, $AG$52, $AG$48),$AG$56),IF(V45<=Min_U, IF(V45<=HP_U, $AG$52, $AG$48),$AG$56))),IF(Q45=$AG$42, IF(R45=\"Yes\",IF(V45<=MinPD_U, IF(V45<=HPPD_U, $AG$55, $AG$51), $AG$56), IF(S45=\"Yes\", IF(V45<=MinBPA_U, IF(V45<=HPBPA_U, $AG$54, $AG$50),$AG$56),IF(V45<=Min_U, IF(V45<=HP_U, $AG$54, $AG$50),$AG$56)))))))))","v":""},null,null,{"$f":"IF('Window entry'!K39=\"\", \"\", 'Window entry'!K39)","v":""},"",null,null,null,null,null,"Window in unheated space",null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,"Yes",17,null,null,null,null,0,0,0,null,17,null,{"$f":"IF(M46=\"\", IF('Window entry'!O40*'Window entry'!P40, 'Window entry'!O40*'Window entry'!P40,\"\"), IF('Window entry'!O40*'Window entry'!P40*M46, 'Window entry'!O40*'Window entry'!P40*M46,\"\"))","v":""},{"$f":"'Window entry'!O40","v":0},{"$f":"'Window entry'!P40","v":0},{"$f":"IF('Window entry'!F40=\"\", \"\", 'Window entry'!F40)","v":""},{"$f":"IF('Window entry'!G40=\"\", \"\", 'Window entry'!G40)","v":""},{"$f":"IF('Window entry'!H40=\"\", \"\", 'Window entry'!H40)","v":""},{"$f":"IF('Window entry'!I40=\"\", \"\", 'Window entry'!I40)","v":""},{"$f":"IF('Window entry'!J40=\"\", \"\", 'Window entry'!J40)","v":""},{"$f":"IF('Window entry'!E40=\"\", \"\", 'Window entry'!E40)","v":""},{"$f":"IF(N46=\"\", \"\", IF(OR('Window entry'!J40=\"Yes\",'Window entry'!I40=\"Yes\"),$AG$56, IF(OR(Q46=\"\", V46=\"\"), \"need more data...\", IF(OR(Q46=$AG$43, Q46=$AG$44, Q46=$AG$45), $AG$56, IF(OR(Q46=$AG$40,Q46=$AG$41), IF(R46=\"Yes\", IF(V46<=MinPD_U, IF(V46<=HPPD_U, $AG$53, $AG$49), $AG$56), IF(S46=\"Yes\", IF(V46<=MinBPA_U, IF(V46<=HPBPA_U, $AG$52, $AG$48),$AG$56),IF(V46<=Min_U, IF(V46<=HP_U, $AG$52, $AG$48),$AG$56))),IF(Q46=$AG$42, IF(R46=\"Yes\",IF(V46<=MinPD_U, IF(V46<=HPPD_U, $AG$55, $AG$51), $AG$56), IF(S46=\"Yes\", IF(V46<=MinBPA_U, IF(V46<=HPBPA_U, $AG$54, $AG$50),$AG$56),IF(V46<=Min_U, IF(V46<=HP_U, $AG$54, $AG$50),$AG$56)))))))))","v":""},null,null,{"$f":"IF('Window entry'!K40=\"\", \"\", 'Window entry'!K40)","v":""},"",null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,"Yes",18,null,null,null,null,0,0,0,null,18,null,{"$f":"IF(M47=\"\", IF('Window entry'!O41*'Window entry'!P41, 'Window entry'!O41*'Window entry'!P41,\"\"), IF('Window entry'!O41*'Window entry'!P41*M47, 'Window entry'!O41*'Window entry'!P41*M47,\"\"))","v":""},{"$f":"'Window entry'!O41","v":0},{"$f":"'Window entry'!P41","v":0},{"$f":"IF('Window entry'!F41=\"\", \"\", 'Window entry'!F41)","v":""},{"$f":"IF('Window entry'!G41=\"\", \"\", 'Window entry'!G41)","v":""},{"$f":"IF('Window entry'!H41=\"\", \"\", 'Window entry'!H41)","v":""},{"$f":"IF('Window entry'!I41=\"\", \"\", 'Window entry'!I41)","v":""},{"$f":"IF('Window entry'!J41=\"\", \"\", 'Window entry'!J41)","v":""},{"$f":"IF('Window entry'!E41=\"\", \"\", 'Window entry'!E41)","v":""},{"$f":"IF(N47=\"\", \"\", IF(OR('Window entry'!J41=\"Yes\",'Window entry'!I41=\"Yes\"),$AG$56, IF(OR(Q47=\"\", V47=\"\"), \"need more data...\", IF(OR(Q47=$AG$43, Q47=$AG$44, Q47=$AG$45), $AG$56, IF(OR(Q47=$AG$40,Q47=$AG$41), IF(R47=\"Yes\", IF(V47<=MinPD_U, IF(V47<=HPPD_U, $AG$53, $AG$49), $AG$56), IF(S47=\"Yes\", IF(V47<=MinBPA_U, IF(V47<=HPBPA_U, $AG$52, $AG$48),$AG$56),IF(V47<=Min_U, IF(V47<=HP_U, $AG$52, $AG$48),$AG$56))),IF(Q47=$AG$42, IF(R47=\"Yes\",IF(V47<=MinPD_U, IF(V47<=HPPD_U, $AG$55, $AG$51), $AG$56), IF(S47=\"Yes\", IF(V47<=MinBPA_U, IF(V47<=HPBPA_U, $AG$54, $AG$50),$AG$56),IF(V47<=Min_U, IF(V47<=HP_U, $AG$54, $AG$50),$AG$56)))))))))","v":""},null,null,{"$f":"IF('Window entry'!K41=\"\", \"\", 'Window entry'!K41)","v":""},"",null,null,null,null,null,"Measure list",null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,"Yes",19,null,null,null,null,0,0,0,null,19,null,{"$f":"IF(M48=\"\", IF('Window entry'!O42*'Window entry'!P42, 'Window entry'!O42*'Window entry'!P42,\"\"), IF('Window entry'!O42*'Window entry'!P42*M48, 'Window entry'!O42*'Window entry'!P42*M48,\"\"))","v":""},{"$f":"'Window entry'!O42","v":0},{"$f":"'Window entry'!P42","v":0},{"$f":"IF('Window entry'!F42=\"\", \"\", 'Window entry'!F42)","v":""},{"$f":"IF('Window entry'!G42=\"\", \"\", 'Window entry'!G42)","v":""},{"$f":"IF('Window entry'!H42=\"\", \"\", 'Window entry'!H42)","v":""},{"$f":"IF('Window entry'!I42=\"\", \"\", 'Window entry'!I42)","v":""},{"$f":"IF('Window entry'!J42=\"\", \"\", 'Window entry'!J42)","v":""},{"$f":"IF('Window entry'!E42=\"\", \"\", 'Window entry'!E42)","v":""},{"$f":"IF(N48=\"\", \"\", IF(OR('Window entry'!J42=\"Yes\",'Window entry'!I42=\"Yes\"),$AG$56, IF(OR(Q48=\"\", V48=\"\"), \"need more data...\", IF(OR(Q48=$AG$43, Q48=$AG$44, Q48=$AG$45), $AG$56, IF(OR(Q48=$AG$40,Q48=$AG$41), IF(R48=\"Yes\", IF(V48<=MinPD_U, IF(V48<=HPPD_U, $AG$53, $AG$49), $AG$56), IF(S48=\"Yes\", IF(V48<=MinBPA_U, IF(V48<=HPBPA_U, $AG$52, $AG$48),$AG$56),IF(V48<=Min_U, IF(V48<=HP_U, $AG$52, $AG$48),$AG$56))),IF(Q48=$AG$42, IF(R48=\"Yes\",IF(V48<=MinPD_U, IF(V48<=HPPD_U, $AG$55, $AG$51), $AG$56), IF(S48=\"Yes\", IF(V48<=MinBPA_U, IF(V48<=HPBPA_U, $AG$54, $AG$50),$AG$56),IF(V48<=Min_U, IF(V48<=HP_U, $AG$54, $AG$50),$AG$56)))))))))","v":""},null,null,{"$f":"IF('Window entry'!K42=\"\", \"\", 'Window entry'!K42)","v":""},"",null,null,null,null,null,{"$f":"CONCATENATE(\"Single-pane window to U≤\", FIXED(Min_U,2))","v":"Single-pane window to U≤0.25"},null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,"Yes",20,null,null,null,null,0,0,0,null,20,null,{"$f":"IF(M49=\"\", IF('Window entry'!O43*'Window entry'!P43, 'Window entry'!O43*'Window entry'!P43,\"\"), IF('Window entry'!O43*'Window entry'!P43*M49, 'Window entry'!O43*'Window entry'!P43*M49,\"\"))","v":""},{"$f":"'Window entry'!O43","v":0},{"$f":"'Window entry'!P43","v":0},{"$f":"IF('Window entry'!F43=\"\", \"\", 'Window entry'!F43)","v":""},{"$f":"IF('Window entry'!G43=\"\", \"\", 'Window entry'!G43)","v":""},{"$f":"IF('Window entry'!H43=\"\", \"\", 'Window entry'!H43)","v":""},{"$f":"IF('Window entry'!I43=\"\", \"\", 'Window entry'!I43)","v":""},{"$f":"IF('Window entry'!J43=\"\", \"\", 'Window entry'!J43)","v":""},{"$f":"IF('Window entry'!E43=\"\", \"\", 'Window entry'!E43)","v":""},{"$f":"IF(N49=\"\", \"\", IF(OR('Window entry'!J43=\"Yes\",'Window entry'!I43=\"Yes\"),$AG$56, IF(OR(Q49=\"\", V49=\"\"), \"need more data...\", IF(OR(Q49=$AG$43, Q49=$AG$44, Q49=$AG$45), $AG$56, IF(OR(Q49=$AG$40,Q49=$AG$41), IF(R49=\"Yes\", IF(V49<=MinPD_U, IF(V49<=HPPD_U, $AG$53, $AG$49), $AG$56), IF(S49=\"Yes\", IF(V49<=MinBPA_U, IF(V49<=HPBPA_U, $AG$52, $AG$48),$AG$56),IF(V49<=Min_U, IF(V49<=HP_U, $AG$52, $AG$48),$AG$56))),IF(Q49=$AG$42, IF(R49=\"Yes\",IF(V49<=MinPD_U, IF(V49<=HPPD_U, $AG$55, $AG$51), $AG$56), IF(S49=\"Yes\", IF(V49<=MinBPA_U, IF(V49<=HPBPA_U, $AG$54, $AG$50),$AG$56),IF(V49<=Min_U, IF(V49<=HP_U, $AG$54, $AG$50),$AG$56)))))))))","v":""},null,null,{"$f":"IF('Window entry'!K43=\"\", \"\", 'Window entry'!K43)","v":""},"",null,null,null,null,null,{"$f":"CONCATENATE(\"Single-pane glass patio door to U≤\", FIXED(MinPD_U,2))","v":"Single-pane glass patio door to U≤0.30"},null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF($AK49=BM$29, $AA49, 0)","v":0},0,0,0,0,{"$f":"IF($AH92=BR$29, $AA49, 0)","v":0},0,{"$f":"IF($AK49=BT$29, $AA49, 0)","v":0},0]
[1,"Yes",21,null,null,null,null,0,0,0,null,21,null,{"$f":"IF(M50=\"\", IF('Window entry'!O44*'Window entry'!P44, 'Window entry'!O44*'Window entry'!P44,\"\"), IF('Window entry'!O44*'Window entry'!P44*M50, 'Window entry'!O44*'Window entry'!P44*M50,\"\"))","v":""},{"$f":"'Window entry'!O44","v":0},{"$f":"'Window entry'!P44","v":0},{"$f":"IF('Window entry'!F44=\"\", \"\", 'Window entry'!F44)","v":""},{"$f":"IF('Window entry'!G44=\"\", \"\", 'Window entry'!G44)","v":""},{"$f":"IF('Window entry'!H44=\"\", \"\", 'Window entry'!H44)","v":""},{"$f":"IF('Window entry'!I44=\"\", \"\", 'Window entry'!I44)","v":""},{"$f":"IF('Window entry'!J44=\"\", \"\", 'Window entry'!J44)","v":""},{"$f":"IF('Window entry'!E44=\"\", \"\", 'Window entry'!E44)","v":""},{"$f":"IF(N50=\"\", \"\", IF(OR('Window entry'!J44=\"Yes\",'Window entry'!I44=\"Yes\"),$AG$56, IF(OR(Q50=\"\", V50=\"\"), \"need more data...\", IF(OR(Q50=$AG$43, Q50=$AG$44, Q50=$AG$45), $AG$56, IF(OR(Q50=$AG$40,Q50=$AG$41), IF(R50=\"Yes\", IF(V50<=MinPD_U, IF(V50<=HPPD_U, $AG$53, $AG$49), $AG$56), IF(S50=\"Yes\", IF(V50<=MinBPA_U, IF(V50<=HPBPA_U, $AG$52, $AG$48),$AG$56),IF(V50<=Min_U, IF(V50<=HP_U, $AG$52, $AG$48),$AG$56))),IF(Q50=$AG$42, IF(R50=\"Yes\",IF(V50<=MinPD_U, IF(V50<=HPPD_U, $AG$55, $AG$51), $AG$56), IF(S50=\"Yes\", IF(V50<=MinBPA_U, IF(V50<=HPBPA_U, $AG$54, $AG$50),$AG$56),IF(V50<=Min_U, IF(V50<=HP_U, $AG$54, $AG$50),$AG$56)))))))))","v":""},null,null,{"$f":"IF('Window entry'!K44=\"\", \"\", 'Window entry'!K44)","v":""},"",null,null,null,null,null,{"$f":"CONCATENATE(\"Double-pane window to U≤\", FIXED(Min_U,2))","v":"Double-pane window to U≤0.25"},null,null,null,"",{"$f":"IF($AK50=AL$29, $N50, 0)","v":0},0,0,0,0,0,0,0,0,{"$f":"IF($AK50=AU$29, $V50, 0)","v":0},0,0,0,0,0,0,0,0,{"$f":"IF($AK50=BD$29, IF($M50=\"\", 1, $M50), 0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,"Yes",22,null,null,null,null,0,0,0,null,22,null,{"$f":"IF(M51=\"\", IF('Window entry'!O45*'Window entry'!P45, 'Window entry'!O45*'Window entry'!P45,\"\"), IF('Window entry'!O45*'Window entry'!P45*M51, 'Window entry'!O45*'Window entry'!P45*M51,\"\"))","v":""},{"$f":"'Window entry'!O45","v":0},{"$f":"'Window entry'!P45","v":0},{"$f":"IF('Window entry'!F45=\"\", \"\", 'Window entry'!F45)","v":""},{"$f":"IF('Window entry'!G45=\"\", \"\", 'Window entry'!G45)","v":""},{"$f":"IF('Window entry'!H45=\"\", \"\", 'Window entry'!H45)","v":""},{"$f":"IF('Window entry'!I45=\"\", \"\", 'Window entry'!I45)","v":""},{"$f":"IF('Window entry'!J45=\"\", \"\", 'Window entry'!J45)","v":""},{"$f":"IF('Window entry'!E45=\"\", \"\", 'Window entry'!E45)","v":""},{"$f":"IF(N51=\"\", \"\", IF(OR('Window entry'!J45=\"Yes\",'Window entry'!I45=\"Yes\"),$AG$56, IF(OR(Q51=\"\", V51=\"\"), \"need more data...\", IF(OR(Q51=$AG$43, Q51=$AG$44, Q51=$AG$45), $AG$56, IF(OR(Q51=$AG$40,Q51=$AG$41), IF(R51=\"Yes\", IF(V51<=MinPD_U, IF(V51<=HPPD_U, $AG$53, $AG$49), $AG$56), IF(S51=\"Yes\", IF(V51<=MinBPA_U, IF(V51<=HPBPA_U, $AG$52, $AG$48),$AG$56),IF(V51<=Min_U, IF(V51<=HP_U, $AG$52, $AG$48),$AG$56))),IF(Q51=$AG$42, IF(R51=\"Yes\",IF(V51<=MinPD_U, IF(V51<=HPPD_U, $AG$55, $AG$51), $AG$56), IF(S51=\"Yes\", IF(V51<=MinBPA_U, IF(V51<=HPBPA_U, $AG$54, $AG$50),$AG$56),IF(V51<=Min_U, IF(V51<=HP_U, $AG$54, $AG$50),$AG$56)))))))))","v":""},null,null,{"$f":"IF('Window entry'!K45=\"\", \"\", 'Window entry'!K45)","v":""},"",null,null,null,null,null,{"$f":"CONCATENATE(\"Double-pane glass patio door to U≤\", FIXED(MinPD_U,2))","v":"Double-pane glass patio door to U≤0.30"},null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,"Yes",23,null,null,null,null,0,0,0,null,23,null,{"$f":"IF(M52=\"\", IF('Window entry'!O46*'Window entry'!P46, 'Window entry'!O46*'Window entry'!P46,\"\"), IF('Window entry'!O46*'Window entry'!P46*M52, 'Window entry'!O46*'Window entry'!P46*M52,\"\"))","v":""},{"$f":"'Window entry'!O46","v":0},{"$f":"'Window entry'!P46","v":0},{"$f":"IF('Window entry'!F46=\"\", \"\", 'Window entry'!F46)","v":""},{"$f":"IF('Window entry'!G46=\"\", \"\", 'Window entry'!G46)","v":""},{"$f":"IF('Window entry'!H46=\"\", \"\", 'Window entry'!H46)","v":""},{"$f":"IF('Window entry'!I46=\"\", \"\", 'Window entry'!I46)","v":""},{"$f":"IF('Window entry'!J46=\"\", \"\", 'Window entry'!J46)","v":""},{"$f":"IF('Window entry'!E46=\"\", \"\", 'Window entry'!E46)","v":""},{"$f":"IF(N52=\"\", \"\", IF(OR('Window entry'!J46=\"Yes\",'Window entry'!I46=\"Yes\"),$AG$56, IF(OR(Q52=\"\", V52=\"\"), \"need more data...\", IF(OR(Q52=$AG$43, Q52=$AG$44, Q52=$AG$45), $AG$56, IF(OR(Q52=$AG$40,Q52=$AG$41), IF(R52=\"Yes\", IF(V52<=MinPD_U, IF(V52<=HPPD_U, $AG$53, $AG$49), $AG$56), IF(S52=\"Yes\", IF(V52<=MinBPA_U, IF(V52<=HPBPA_U, $AG$52, $AG$48),$AG$56),IF(V52<=Min_U, IF(V52<=HP_U, $AG$52, $AG$48),$AG$56))),IF(Q52=$AG$42, IF(R52=\"Yes\",IF(V52<=MinPD_U, IF(V52<=HPPD_U, $AG$55, $AG$51), $AG$56), IF(S52=\"Yes\", IF(V52<=MinBPA_U, IF(V52<=HPBPA_U, $AG$54, $AG$50),$AG$56),IF(V52<=Min_U, IF(V52<=HP_U, $AG$54, $AG$50),$AG$56)))))))))","v":""},null,null,{"$f":"IF('Window entry'!K46=\"\", \"\", 'Window entry'!K46)","v":""},"",null,null,null,null,null,{"$f":"CONCATENATE(\"Single-pane window to U≤\", FIXED(HP_U,2))","v":"Single-pane window to U≤0.22"},null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,"Yes",24,null,null,null,null,0,0,0,null,24,null,{"$f":"IF(M53=\"\", IF('Window entry'!O47*'Window entry'!P47, 'Window entry'!O47*'Window entry'!P47,\"\"), IF('Window entry'!O47*'Window entry'!P47*M53, 'Window entry'!O47*'Window entry'!P47*M53,\"\"))","v":""},{"$f":"'Window entry'!O47","v":0},{"$f":"'Window entry'!P47","v":0},{"$f":"IF('Window entry'!F47=\"\", \"\", 'Window entry'!F47)","v":""},{"$f":"IF('Window entry'!G47=\"\", \"\", 'Window entry'!G47)","v":""},{"$f":"IF('Window entry'!H47=\"\", \"\", 'Window entry'!H47)","v":""},{"$f":"IF('Window entry'!I47=\"\", \"\", 'Window entry'!I47)","v":""},{"$f":"IF('Window entry'!J47=\"\", \"\", 'Window entry'!J47)","v":""},{"$f":"IF('Window entry'!E47=\"\", \"\", 'Window entry'!E47)","v":""},{"$f":"IF(N53=\"\", \"\", IF(OR('Window entry'!J47=\"Yes\",'Window entry'!I47=\"Yes\"),$AG$56, IF(OR(Q53=\"\", V53=\"\"), \"need more data...\", IF(OR(Q53=$AG$43, Q53=$AG$44, Q53=$AG$45), $AG$56, IF(OR(Q53=$AG$40,Q53=$AG$41), IF(R53=\"Yes\", IF(V53<=MinPD_U, IF(V53<=HPPD_U, $AG$53, $AG$49), $AG$56), IF(S53=\"Yes\", IF(V53<=MinBPA_U, IF(V53<=HPBPA_U, $AG$52, $AG$48),$AG$56),IF(V53<=Min_U, IF(V53<=HP_U, $AG$52, $AG$48),$AG$56))),IF(Q53=$AG$42, IF(R53=\"Yes\",IF(V53<=MinPD_U, IF(V53<=HPPD_U, $AG$55, $AG$51), $AG$56), IF(S53=\"Yes\", IF(V53<=MinBPA_U, IF(V53<=HPBPA_U, $AG$54, $AG$50),$AG$56),IF(V53<=Min_U, IF(V53<=HP_U, $AG$54, $AG$50),$AG$56)))))))))","v":""},null,null,{"$f":"IF('Window entry'!K47=\"\", \"\", 'Window entry'!K47)","v":""},"",null,null,null,null,null,{"$f":"CONCATENATE(\"Single-pane glass patio door to U≤\", FIXED(HPPD_U,2))","v":"Single-pane glass patio door to U≤0.25"},null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,"Yes",25,null,null,null,null,0,0,0,null,25,null,{"$f":"IF(M54=\"\", IF('Window entry'!O48*'Window entry'!P48, 'Window entry'!O48*'Window entry'!P48,\"\"), IF('Window entry'!O48*'Window entry'!P48*M54, 'Window entry'!O48*'Window entry'!P48*M54,\"\"))","v":""},{"$f":"'Window entry'!O48","v":0},{"$f":"'Window entry'!P48","v":0},{"$f":"IF('Window entry'!F48=\"\", \"\", 'Window entry'!F48)","v":""},{"$f":"IF('Window entry'!G48=\"\", \"\", 'Window entry'!G48)","v":""},{"$f":"IF('Window entry'!H48=\"\", \"\", 'Window entry'!H48)","v":""},{"$f":"IF('Window entry'!I48=\"\", \"\", 'Window entry'!I48)","v":""},{"$f":"IF('Window entry'!J48=\"\", \"\", 'Window entry'!J48)","v":""},{"$f":"IF('Window entry'!E48=\"\", \"\", 'Window entry'!E48)","v":""},{"$f":"IF(N54=\"\", \"\", IF(OR('Window entry'!J48=\"Yes\",'Window entry'!I48=\"Yes\"),$AG$56, IF(OR(Q54=\"\", V54=\"\"), \"need more data...\", IF(OR(Q54=$AG$43, Q54=$AG$44, Q54=$AG$45), $AG$56, IF(OR(Q54=$AG$40,Q54=$AG$41), IF(R54=\"Yes\", IF(V54<=MinPD_U, IF(V54<=HPPD_U, $AG$53, $AG$49), $AG$56), IF(S54=\"Yes\", IF(V54<=MinBPA_U, IF(V54<=HPBPA_U, $AG$52, $AG$48),$AG$56),IF(V54<=Min_U, IF(V54<=HP_U, $AG$52, $AG$48),$AG$56))),IF(Q54=$AG$42, IF(R54=\"Yes\",IF(V54<=MinPD_U, IF(V54<=HPPD_U, $AG$55, $AG$51), $AG$56), IF(S54=\"Yes\", IF(V54<=MinBPA_U, IF(V54<=HPBPA_U, $AG$54, $AG$50),$AG$56),IF(V54<=Min_U, IF(V54<=HP_U, $AG$54, $AG$50),$AG$56)))))))))","v":""},null,null,{"$f":"IF('Window entry'!K48=\"\", \"\", 'Window entry'!K48)","v":""},"",null,null,null,null,null,{"$f":"CONCATENATE(\"Double-pane window to U≤\", FIXED(HP_U,2))","v":"Double-pane window to U≤0.22"},null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,"Yes",26,null,null,null,null,0,0,0,null,26,null,{"$f":"IF(M55=\"\", IF('Window entry'!O49*'Window entry'!P49, 'Window entry'!O49*'Window entry'!P49,\"\"), IF('Window entry'!O49*'Window entry'!P49*M55, 'Window entry'!O49*'Window entry'!P49*M55,\"\"))","v":""},{"$f":"'Window entry'!O49","v":0},{"$f":"'Window entry'!P49","v":0},{"$f":"IF('Window entry'!F49=\"\", \"\", 'Window entry'!F49)","v":""},{"$f":"IF('Window entry'!G49=\"\", \"\", 'Window entry'!G49)","v":""},{"$f":"IF('Window entry'!H49=\"\", \"\", 'Window entry'!H49)","v":""},{"$f":"IF('Window entry'!I49=\"\", \"\", 'Window entry'!I49)","v":""},{"$f":"IF('Window entry'!J49=\"\", \"\", 'Window entry'!J49)","v":""},{"$f":"IF('Window entry'!E49=\"\", \"\", 'Window entry'!E49)","v":""},{"$f":"IF(N55=\"\", \"\", IF(OR('Window entry'!J49=\"Yes\",'Window entry'!I49=\"Yes\"),$AG$56, IF(OR(Q55=\"\", V55=\"\"), \"need more data...\", IF(OR(Q55=$AG$43, Q55=$AG$44, Q55=$AG$45), $AG$56, IF(OR(Q55=$AG$40,Q55=$AG$41), IF(R55=\"Yes\", IF(V55<=MinPD_U, IF(V55<=HPPD_U, $AG$53, $AG$49), $AG$56), IF(S55=\"Yes\", IF(V55<=MinBPA_U, IF(V55<=HPBPA_U, $AG$52, $AG$48),$AG$56),IF(V55<=Min_U, IF(V55<=HP_U, $AG$52, $AG$48),$AG$56))),IF(Q55=$AG$42, IF(R55=\"Yes\",IF(V55<=MinPD_U, IF(V55<=HPPD_U, $AG$55, $AG$51), $AG$56), IF(S55=\"Yes\", IF(V55<=MinBPA_U, IF(V55<=HPBPA_U, $AG$54, $AG$50),$AG$56),IF(V55<=Min_U, IF(V55<=HP_U, $AG$54, $AG$50),$AG$56)))))))))","v":""},null,null,{"$f":"IF('Window entry'!K49=\"\", \"\", 'Window entry'!K49)","v":""},"",null,null,null,null,null,{"$f":"CONCATENATE(\"Double-pane glass patio door to U≤\", FIXED(HPPD_U,2))","v":"Double-pane glass patio door to U≤0.25"},null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,"Yes",27,null,null,null,null,0,0,0,null,27,null,{"$f":"IF(M56=\"\", IF('Window entry'!O50*'Window entry'!P50, 'Window entry'!O50*'Window entry'!P50,\"\"), IF('Window entry'!O50*'Window entry'!P50*M56, 'Window entry'!O50*'Window entry'!P50*M56,\"\"))","v":""},{"$f":"'Window entry'!O50","v":0},{"$f":"'Window entry'!P50","v":0},{"$f":"IF('Window entry'!F50=\"\", \"\", 'Window entry'!F50)","v":""},{"$f":"IF('Window entry'!G50=\"\", \"\", 'Window entry'!G50)","v":""},{"$f":"IF('Window entry'!H50=\"\", \"\", 'Window entry'!H50)","v":""},{"$f":"IF('Window entry'!I50=\"\", \"\", 'Window entry'!I50)","v":""},{"$f":"IF('Window entry'!J50=\"\", \"\", 'Window entry'!J50)","v":""},{"$f":"IF('Window entry'!E50=\"\", \"\", 'Window entry'!E50)","v":""},{"$f":"IF(N56=\"\", \"\", IF(OR('Window entry'!J50=\"Yes\",'Window entry'!I50=\"Yes\"),$AG$56, IF(OR(Q56=\"\", V56=\"\"), \"need more data...\", IF(OR(Q56=$AG$43, Q56=$AG$44, Q56=$AG$45), $AG$56, IF(OR(Q56=$AG$40,Q56=$AG$41), IF(R56=\"Yes\", IF(V56<=MinPD_U, IF(V56<=HPPD_U, $AG$53, $AG$49), $AG$56), IF(S56=\"Yes\", IF(V56<=MinBPA_U, IF(V56<=HPBPA_U, $AG$52, $AG$48),$AG$56),IF(V56<=Min_U, IF(V56<=HP_U, $AG$52, $AG$48),$AG$56))),IF(Q56=$AG$42, IF(R56=\"Yes\",IF(V56<=MinPD_U, IF(V56<=HPPD_U, $AG$55, $AG$51), $AG$56), IF(S56=\"Yes\", IF(V56<=MinBPA_U, IF(V56<=HPBPA_U, $AG$54, $AG$50),$AG$56),IF(V56<=Min_U, IF(V56<=HP_U, $AG$54, $AG$50),$AG$56)))))))))","v":""},null,null,{"$f":"IF('Window entry'!K50=\"\", \"\", 'Window entry'!K50)","v":""},"",null,null,null,null,null,"Ineligible window",null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,"Yes",28,null,null,null,null,0,0,0,null,28,null,{"$f":"IF(M57=\"\", IF('Window entry'!O51*'Window entry'!P51, 'Window entry'!O51*'Window entry'!P51,\"\"), IF('Window entry'!O51*'Window entry'!P51*M57, 'Window entry'!O51*'Window entry'!P51*M57,\"\"))","v":""},{"$f":"'Window entry'!O51","v":0},{"$f":"'Window entry'!P51","v":0},{"$f":"IF('Window entry'!F51=\"\", \"\", 'Window entry'!F51)","v":""},{"$f":"IF('Window entry'!G51=\"\", \"\", 'Window entry'!G51)","v":""},{"$f":"IF('Window entry'!H51=\"\", \"\", 'Window entry'!H51)","v":""},{"$f":"IF('Window entry'!I51=\"\", \"\", 'Window entry'!I51)","v":""},{"$f":"IF('Window entry'!J51=\"\", \"\", 'Window entry'!J51)","v":""},{"$f":"IF('Window entry'!E51=\"\", \"\", 'Window entry'!E51)","v":""},{"$f":"IF(N57=\"\", \"\", IF(OR('Window entry'!J51=\"Yes\",'Window entry'!I51=\"Yes\"),$AG$56, IF(OR(Q57=\"\", V57=\"\"), \"need more data...\", IF(OR(Q57=$AG$43, Q57=$AG$44, Q57=$AG$45), $AG$56, IF(OR(Q57=$AG$40,Q57=$AG$41), IF(R57=\"Yes\", IF(V57<=MinPD_U, IF(V57<=HPPD_U, $AG$53, $AG$49), $AG$56), IF(S57=\"Yes\", IF(V57<=MinBPA_U, IF(V57<=HPBPA_U, $AG$52, $AG$48),$AG$56),IF(V57<=Min_U, IF(V57<=HP_U, $AG$52, $AG$48),$AG$56))),IF(Q57=$AG$42, IF(R57=\"Yes\",IF(V57<=MinPD_U, IF(V57<=HPPD_U, $AG$55, $AG$51), $AG$56), IF(S57=\"Yes\", IF(V57<=MinBPA_U, IF(V57<=HPBPA_U, $AG$54, $AG$50),$AG$56),IF(V57<=Min_U, IF(V57<=HP_U, $AG$54, $AG$50),$AG$56)))))))))","v":""},null,null,{"$f":"IF('Window entry'!K51=\"\", \"\", 'Window entry'!K51)","v":""},"",null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,"Yes",29,null,null,null,null,0,0,0,null,29,null,{"$f":"IF(M58=\"\", IF('Window entry'!O52*'Window entry'!P52, 'Window entry'!O52*'Window entry'!P52,\"\"), IF('Window entry'!O52*'Window entry'!P52*M58, 'Window entry'!O52*'Window entry'!P52*M58,\"\"))","v":""},{"$f":"'Window entry'!O52","v":0},{"$f":"'Window entry'!P52","v":0},{"$f":"IF('Window entry'!F52=\"\", \"\", 'Window entry'!F52)","v":""},{"$f":"IF('Window entry'!G52=\"\", \"\", 'Window entry'!G52)","v":""},{"$f":"IF('Window entry'!H52=\"\", \"\", 'Window entry'!H52)","v":""},{"$f":"IF('Window entry'!I52=\"\", \"\", 'Window entry'!I52)","v":""},{"$f":"IF('Window entry'!J52=\"\", \"\", 'Window entry'!J52)","v":""},{"$f":"IF('Window entry'!E52=\"\", \"\", 'Window entry'!E52)","v":""},{"$f":"IF(N58=\"\", \"\", IF(OR('Window entry'!J52=\"Yes\",'Window entry'!I52=\"Yes\"),$AG$56, IF(OR(Q58=\"\", V58=\"\"), \"need more data...\", IF(OR(Q58=$AG$43, Q58=$AG$44, Q58=$AG$45), $AG$56, IF(OR(Q58=$AG$40,Q58=$AG$41), IF(R58=\"Yes\", IF(V58<=MinPD_U, IF(V58<=HPPD_U, $AG$53, $AG$49), $AG$56), IF(S58=\"Yes\", IF(V58<=MinBPA_U, IF(V58<=HPBPA_U, $AG$52, $AG$48),$AG$56),IF(V58<=Min_U, IF(V58<=HP_U, $AG$52, $AG$48),$AG$56))),IF(Q58=$AG$42, IF(R58=\"Yes\",IF(V58<=MinPD_U, IF(V58<=HPPD_U, $AG$55, $AG$51), $AG$56), IF(S58=\"Yes\", IF(V58<=MinBPA_U, IF(V58<=HPBPA_U, $AG$54, $AG$50),$AG$56),IF(V58<=Min_U, IF(V58<=HP_U, $AG$54, $AG$50),$AG$56)))))))))","v":""},null,null,{"$f":"IF('Window entry'!K52=\"\", \"\", 'Window entry'!K52)","v":""},"",null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,"Yes",30,null,null,null,null,0,0,0,null,30,null,{"$f":"IF(M59=\"\", IF('Window entry'!O53*'Window entry'!P53, 'Window entry'!O53*'Window entry'!P53,\"\"), IF('Window entry'!O53*'Window entry'!P53*M59, 'Window entry'!O53*'Window entry'!P53*M59,\"\"))","v":""},{"$f":"'Window entry'!O53","v":0},{"$f":"'Window entry'!P53","v":0},{"$f":"IF('Window entry'!F53=\"\", \"\", 'Window entry'!F53)","v":""},{"$f":"IF('Window entry'!G53=\"\", \"\", 'Window entry'!G53)","v":""},{"$f":"IF('Window entry'!H53=\"\", \"\", 'Window entry'!H53)","v":""},{"$f":"IF('Window entry'!I53=\"\", \"\", 'Window entry'!I53)","v":""},{"$f":"IF('Window entry'!J53=\"\", \"\", 'Window entry'!J53)","v":""},{"$f":"IF('Window entry'!E53=\"\", \"\", 'Window entry'!E53)","v":""},{"$f":"IF(N59=\"\", \"\", IF(OR('Window entry'!J53=\"Yes\",'Window entry'!I53=\"Yes\"),$AG$56, IF(OR(Q59=\"\", V59=\"\"), \"need more data...\", IF(OR(Q59=$AG$43, Q59=$AG$44, Q59=$AG$45), $AG$56, IF(OR(Q59=$AG$40,Q59=$AG$41), IF(R59=\"Yes\", IF(V59<=MinPD_U, IF(V59<=HPPD_U, $AG$53, $AG$49), $AG$56), IF(S59=\"Yes\", IF(V59<=MinBPA_U, IF(V59<=HPBPA_U, $AG$52, $AG$48),$AG$56),IF(V59<=Min_U, IF(V59<=HP_U, $AG$52, $AG$48),$AG$56))),IF(Q59=$AG$42, IF(R59=\"Yes\",IF(V59<=MinPD_U, IF(V59<=HPPD_U, $AG$55, $AG$51), $AG$56), IF(S59=\"Yes\", IF(V59<=MinBPA_U, IF(V59<=HPBPA_U, $AG$54, $AG$50),$AG$56),IF(V59<=Min_U, IF(V59<=HP_U, $AG$54, $AG$50),$AG$56)))))))))","v":""},null,null,{"$f":"IF('Window entry'!K53=\"\", \"\", 'Window entry'!K53)","v":""},"",null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"IF($AK59=BM$29, $AA59, 0)","v":0},0,0,0,0,0,0,0,0]
[1,"Yes",31,null,null,null,null,0,0,0,null,31,null,{"$f":"IF(M60=\"\", IF('Window entry'!O54*'Window entry'!P54, 'Window entry'!O54*'Window entry'!P54,\"\"), IF('Window entry'!O54*'Window entry'!P54*M60, 'Window entry'!O54*'Window entry'!P54*M60,\"\"))","v":""},{"$f":"'Window entry'!O54","v":0},{"$f":"'Window entry'!P54","v":0},{"$f":"IF('Window entry'!F54=\"\", \"\", 'Window entry'!F54)","v":""},{"$f":"IF('Window entry'!G54=\"\", \"\", 'Window entry'!G54)","v":""},{"$f":"IF('Window entry'!H54=\"\", \"\", 'Window entry'!H54)","v":""},{"$f":"IF('Window entry'!I54=\"\", \"\", 'Window entry'!I54)","v":""},{"$f":"IF('Window entry'!J54=\"\", \"\", 'Window entry'!J54)","v":""},{"$f":"IF('Window entry'!E54=\"\", \"\", 'Window entry'!E54)","v":""},{"$f":"IF(N60=\"\", \"\", IF(OR('Window entry'!J54=\"Yes\",'Window entry'!I54=\"Yes\"),$AG$56, IF(OR(Q60=\"\", V60=\"\"), \"need more data...\", IF(OR(Q60=$AG$43, Q60=$AG$44, Q60=$AG$45), $AG$56, IF(OR(Q60=$AG$40,Q60=$AG$41), IF(R60=\"Yes\", IF(V60<=MinPD_U, IF(V60<=HPPD_U, $AG$53, $AG$49), $AG$56), IF(S60=\"Yes\", IF(V60<=MinBPA_U, IF(V60<=HPBPA_U, $AG$52, $AG$48),$AG$56),IF(V60<=Min_U, IF(V60<=HP_U, $AG$52, $AG$48),$AG$56))),IF(Q60=$AG$42, IF(R60=\"Yes\",IF(V60<=MinPD_U, IF(V60<=HPPD_U, $AG$55, $AG$51), $AG$56), IF(S60=\"Yes\", IF(V60<=MinBPA_U, IF(V60<=HPBPA_U, $AG$54, $AG$50),$AG$56),IF(V60<=Min_U, IF(V60<=HP_U, $AG$54, $AG$50),$AG$56)))))))))","v":""},null,null,{"$f":"IF('Window entry'!K54=\"\", \"\", 'Window entry'!K54)","v":""},"",null,null,null,null,null,"Symbol to use…",null,null,null,"",{"$f":"IF($AK60=AL$29, $N60, 0)","v":0},0,0,0,0,0,0,0,0,{"$f":"IF($AK60=AU$29, $V60, 0)","v":0},0,0,0,0,0,0,0,0,{"$f":"IF($AK60=BD$29, IF($M60=\"\", 1, $M60), 0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,"Yes",32,null,null,null,null,0,0,0,null,32,null,{"$f":"IF(M61=\"\", IF('Window entry'!O55*'Window entry'!P55, 'Window entry'!O55*'Window entry'!P55,\"\"), IF('Window entry'!O55*'Window entry'!P55*M61, 'Window entry'!O55*'Window entry'!P55*M61,\"\"))","v":""},{"$f":"'Window entry'!O55","v":0},{"$f":"'Window entry'!P55","v":0},{"$f":"IF('Window entry'!F55=\"\", \"\", 'Window entry'!F55)","v":""},{"$f":"IF('Window entry'!G55=\"\", \"\", 'Window entry'!G55)","v":""},{"$f":"IF('Window entry'!H55=\"\", \"\", 'Window entry'!H55)","v":""},{"$f":"IF('Window entry'!I55=\"\", \"\", 'Window entry'!I55)","v":""},{"$f":"IF('Window entry'!J55=\"\", \"\", 'Window entry'!J55)","v":""},{"$f":"IF('Window entry'!E55=\"\", \"\", 'Window entry'!E55)","v":""},{"$f":"IF(N61=\"\", \"\", IF(OR('Window entry'!J55=\"Yes\",'Window entry'!I55=\"Yes\"),$AG$56, IF(OR(Q61=\"\", V61=\"\"), \"need more data...\", IF(OR(Q61=$AG$43, Q61=$AG$44, Q61=$AG$45), $AG$56, IF(OR(Q61=$AG$40,Q61=$AG$41), IF(R61=\"Yes\", IF(V61<=MinPD_U, IF(V61<=HPPD_U, $AG$53, $AG$49), $AG$56), IF(S61=\"Yes\", IF(V61<=MinBPA_U, IF(V61<=HPBPA_U, $AG$52, $AG$48),$AG$56),IF(V61<=Min_U, IF(V61<=HP_U, $AG$52, $AG$48),$AG$56))),IF(Q61=$AG$42, IF(R61=\"Yes\",IF(V61<=MinPD_U, IF(V61<=HPPD_U, $AG$55, $AG$51), $AG$56), IF(S61=\"Yes\", IF(V61<=MinBPA_U, IF(V61<=HPBPA_U, $AG$54, $AG$50),$AG$56),IF(V61<=Min_U, IF(V61<=HP_U, $AG$54, $AG$50),$AG$56)))))))))","v":""},null,null,{"$f":"IF('Window entry'!K55=\"\", \"\", 'Window entry'!K55)","v":""},"",null,null,null,null,null,"≤",null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,"Yes",33,null,null,null,null,0,0,0,null,33,null,{"$f":"IF(M62=\"\", IF('Window entry'!O56*'Window entry'!P56, 'Window entry'!O56*'Window entry'!P56,\"\"), IF('Window entry'!O56*'Window entry'!P56*M62, 'Window entry'!O56*'Window entry'!P56*M62,\"\"))","v":""},{"$f":"'Window entry'!O56","v":0},{"$f":"'Window entry'!P56","v":0},{"$f":"IF('Window entry'!F56=\"\", \"\", 'Window entry'!F56)","v":""},{"$f":"IF('Window entry'!G56=\"\", \"\", 'Window entry'!G56)","v":""},{"$f":"IF('Window entry'!H56=\"\", \"\", 'Window entry'!H56)","v":""},{"$f":"IF('Window entry'!I56=\"\", \"\", 'Window entry'!I56)","v":""},{"$f":"IF('Window entry'!J56=\"\", \"\", 'Window entry'!J56)","v":""},{"$f":"IF('Window entry'!E56=\"\", \"\", 'Window entry'!E56)","v":""},{"$f":"IF(N62=\"\", \"\", IF(OR('Window entry'!J56=\"Yes\",'Window entry'!I56=\"Yes\"),$AG$56, IF(OR(Q62=\"\", V62=\"\"), \"need more data...\", IF(OR(Q62=$AG$43, Q62=$AG$44, Q62=$AG$45), $AG$56, IF(OR(Q62=$AG$40,Q62=$AG$41), IF(R62=\"Yes\", IF(V62<=MinPD_U, IF(V62<=HPPD_U, $AG$53, $AG$49), $AG$56), IF(S62=\"Yes\", IF(V62<=MinBPA_U, IF(V62<=HPBPA_U, $AG$52, $AG$48),$AG$56),IF(V62<=Min_U, IF(V62<=HP_U, $AG$52, $AG$48),$AG$56))),IF(Q62=$AG$42, IF(R62=\"Yes\",IF(V62<=MinPD_U, IF(V62<=HPPD_U, $AG$55, $AG$51), $AG$56), IF(S62=\"Yes\", IF(V62<=MinBPA_U, IF(V62<=HPBPA_U, $AG$54, $AG$50),$AG$56),IF(V62<=Min_U, IF(V62<=HP_U, $AG$54, $AG$50),$AG$56)))))))))","v":""},null,null,{"$f":"IF('Window entry'!K56=\"\", \"\", 'Window entry'!K56)","v":""},"",null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,"Yes",34,null,null,null,null,0,0,0,null,34,null,{"$f":"IF(M63=\"\", IF('Window entry'!O57*'Window entry'!P57, 'Window entry'!O57*'Window entry'!P57,\"\"), IF('Window entry'!O57*'Window entry'!P57*M63, 'Window entry'!O57*'Window entry'!P57*M63,\"\"))","v":""},{"$f":"'Window entry'!O57","v":0},{"$f":"'Window entry'!P57","v":0},{"$f":"IF('Window entry'!F57=\"\", \"\", 'Window entry'!F57)","v":""},{"$f":"IF('Window entry'!G57=\"\", \"\", 'Window entry'!G57)","v":""},{"$f":"IF('Window entry'!H57=\"\", \"\", 'Window entry'!H57)","v":""},{"$f":"IF('Window entry'!I57=\"\", \"\", 'Window entry'!I57)","v":""},{"$f":"IF('Window entry'!J57=\"\", \"\", 'Window entry'!J57)","v":""},{"$f":"IF('Window entry'!E57=\"\", \"\", 'Window entry'!E57)","v":""},{"$f":"IF(N63=\"\", \"\", IF(OR('Window entry'!J57=\"Yes\",'Window entry'!I57=\"Yes\"),$AG$56, IF(OR(Q63=\"\", V63=\"\"), \"need more data...\", IF(OR(Q63=$AG$43, Q63=$AG$44, Q63=$AG$45), $AG$56, IF(OR(Q63=$AG$40,Q63=$AG$41), IF(R63=\"Yes\", IF(V63<=MinPD_U, IF(V63<=HPPD_U, $AG$53, $AG$49), $AG$56), IF(S63=\"Yes\", IF(V63<=MinBPA_U, IF(V63<=HPBPA_U, $AG$52, $AG$48),$AG$56),IF(V63<=Min_U, IF(V63<=HP_U, $AG$52, $AG$48),$AG$56))),IF(Q63=$AG$42, IF(R63=\"Yes\",IF(V63<=MinPD_U, IF(V63<=HPPD_U, $AG$55, $AG$51), $AG$56), IF(S63=\"Yes\", IF(V63<=MinBPA_U, IF(V63<=HPBPA_U, $AG$54, $AG$50),$AG$56),IF(V63<=Min_U, IF(V63<=HP_U, $AG$54, $AG$50),$AG$56)))))))))","v":""},null,null,{"$f":"IF('Window entry'!K57=\"\", \"\", 'Window entry'!K57)","v":""},"",null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,"Yes",35,null,null,null,null,0,0,0,null,35,null,{"$f":"IF(M64=\"\", IF('Window entry'!O58*'Window entry'!P58, 'Window entry'!O58*'Window entry'!P58,\"\"), IF('Window entry'!O58*'Window entry'!P58*M64, 'Window entry'!O58*'Window entry'!P58*M64,\"\"))","v":""},{"$f":"'Window entry'!O58","v":0},{"$f":"'Window entry'!P58","v":0},{"$f":"IF('Window entry'!F58=\"\", \"\", 'Window entry'!F58)","v":""},{"$f":"IF('Window entry'!G58=\"\", \"\", 'Window entry'!G58)","v":""},{"$f":"IF('Window entry'!H58=\"\", \"\", 'Window entry'!H58)","v":""},{"$f":"IF('Window entry'!I58=\"\", \"\", 'Window entry'!I58)","v":""},{"$f":"IF('Window entry'!J58=\"\", \"\", 'Window entry'!J58)","v":""},{"$f":"IF('Window entry'!E58=\"\", \"\", 'Window entry'!E58)","v":""},{"$f":"IF(N64=\"\", \"\", IF(OR('Window entry'!J58=\"Yes\",'Window entry'!I58=\"Yes\"),$AG$56, IF(OR(Q64=\"\", V64=\"\"), \"need more data...\", IF(OR(Q64=$AG$43, Q64=$AG$44, Q64=$AG$45), $AG$56, IF(OR(Q64=$AG$40,Q64=$AG$41), IF(R64=\"Yes\", IF(V64<=MinPD_U, IF(V64<=HPPD_U, $AG$53, $AG$49), $AG$56), IF(S64=\"Yes\", IF(V64<=MinBPA_U, IF(V64<=HPBPA_U, $AG$52, $AG$48),$AG$56),IF(V64<=Min_U, IF(V64<=HP_U, $AG$52, $AG$48),$AG$56))),IF(Q64=$AG$42, IF(R64=\"Yes\",IF(V64<=MinPD_U, IF(V64<=HPPD_U, $AG$55, $AG$51), $AG$56), IF(S64=\"Yes\", IF(V64<=MinBPA_U, IF(V64<=HPBPA_U, $AG$54, $AG$50),$AG$56),IF(V64<=Min_U, IF(V64<=HP_U, $AG$54, $AG$50),$AG$56)))))))))","v":""},null,null,{"$f":"IF('Window entry'!K58=\"\", \"\", 'Window entry'!K58)","v":""},"",null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,"Yes",36,null,null,null,null,0,0,0,null,36,null,{"$f":"IF(M65=\"\", IF('Window entry'!O59*'Window entry'!P59, 'Window entry'!O59*'Window entry'!P59,\"\"), IF('Window entry'!O59*'Window entry'!P59*M65, 'Window entry'!O59*'Window entry'!P59*M65,\"\"))","v":""},{"$f":"'Window entry'!O59","v":0},{"$f":"'Window entry'!P59","v":0},{"$f":"IF('Window entry'!F59=\"\", \"\", 'Window entry'!F59)","v":""},{"$f":"IF('Window entry'!G59=\"\", \"\", 'Window entry'!G59)","v":""},{"$f":"IF('Window entry'!H59=\"\", \"\", 'Window entry'!H59)","v":""},{"$f":"IF('Window entry'!I59=\"\", \"\", 'Window entry'!I59)","v":""},{"$f":"IF('Window entry'!J59=\"\", \"\", 'Window entry'!J59)","v":""},{"$f":"IF('Window entry'!E59=\"\", \"\", 'Window entry'!E59)","v":""},{"$f":"IF(N65=\"\", \"\", IF(OR('Window entry'!J59=\"Yes\",'Window entry'!I59=\"Yes\"),$AG$56, IF(OR(Q65=\"\", V65=\"\"), \"need more data...\", IF(OR(Q65=$AG$43, Q65=$AG$44, Q65=$AG$45), $AG$56, IF(OR(Q65=$AG$40,Q65=$AG$41), IF(R65=\"Yes\", IF(V65<=MinPD_U, IF(V65<=HPPD_U, $AG$53, $AG$49), $AG$56), IF(S65=\"Yes\", IF(V65<=MinBPA_U, IF(V65<=HPBPA_U, $AG$52, $AG$48),$AG$56),IF(V65<=Min_U, IF(V65<=HP_U, $AG$52, $AG$48),$AG$56))),IF(Q65=$AG$42, IF(R65=\"Yes\",IF(V65<=MinPD_U, IF(V65<=HPPD_U, $AG$55, $AG$51), $AG$56), IF(S65=\"Yes\", IF(V65<=MinBPA_U, IF(V65<=HPBPA_U, $AG$54, $AG$50),$AG$56),IF(V65<=Min_U, IF(V65<=HP_U, $AG$54, $AG$50),$AG$56)))))))))","v":""},null,null,{"$f":"IF('Window entry'!K59=\"\", \"\", 'Window entry'!K59)","v":""},"",null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,"Yes",37,null,null,null,null,0,0,0,null,37,null,{"$f":"IF(M66=\"\", IF('Window entry'!O60*'Window entry'!P60, 'Window entry'!O60*'Window entry'!P60,\"\"), IF('Window entry'!O60*'Window entry'!P60*M66, 'Window entry'!O60*'Window entry'!P60*M66,\"\"))","v":""},{"$f":"'Window entry'!O60","v":0},{"$f":"'Window entry'!P60","v":0},{"$f":"IF('Window entry'!F60=\"\", \"\", 'Window entry'!F60)","v":""},{"$f":"IF('Window entry'!G60=\"\", \"\", 'Window entry'!G60)","v":""},{"$f":"IF('Window entry'!H60=\"\", \"\", 'Window entry'!H60)","v":""},{"$f":"IF('Window entry'!I60=\"\", \"\", 'Window entry'!I60)","v":""},{"$f":"IF('Window entry'!J60=\"\", \"\", 'Window entry'!J60)","v":""},{"$f":"IF('Window entry'!E60=\"\", \"\", 'Window entry'!E60)","v":""},{"$f":"IF(N66=\"\", \"\", IF(OR('Window entry'!J60=\"Yes\",'Window entry'!I60=\"Yes\"),$AG$56, IF(OR(Q66=\"\", V66=\"\"), \"need more data...\", IF(OR(Q66=$AG$43, Q66=$AG$44, Q66=$AG$45), $AG$56, IF(OR(Q66=$AG$40,Q66=$AG$41), IF(R66=\"Yes\", IF(V66<=MinPD_U, IF(V66<=HPPD_U, $AG$53, $AG$49), $AG$56), IF(S66=\"Yes\", IF(V66<=MinBPA_U, IF(V66<=HPBPA_U, $AG$52, $AG$48),$AG$56),IF(V66<=Min_U, IF(V66<=HP_U, $AG$52, $AG$48),$AG$56))),IF(Q66=$AG$42, IF(R66=\"Yes\",IF(V66<=MinPD_U, IF(V66<=HPPD_U, $AG$55, $AG$51), $AG$56), IF(S66=\"Yes\", IF(V66<=MinBPA_U, IF(V66<=HPBPA_U, $AG$54, $AG$50),$AG$56),IF(V66<=Min_U, IF(V66<=HP_U, $AG$54, $AG$50),$AG$56)))))))))","v":""},null,null,{"$f":"IF('Window entry'!K60=\"\", \"\", 'Window entry'!K60)","v":""},"",null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,"Yes",38,null,null,null,null,0,0,0,null,38,null,{"$f":"IF(M67=\"\", IF('Window entry'!O61*'Window entry'!P61, 'Window entry'!O61*'Window entry'!P61,\"\"), IF('Window entry'!O61*'Window entry'!P61*M67, 'Window entry'!O61*'Window entry'!P61*M67,\"\"))","v":""},{"$f":"'Window entry'!O61","v":0},{"$f":"'Window entry'!P61","v":0},{"$f":"IF('Window entry'!F61=\"\", \"\", 'Window entry'!F61)","v":""},{"$f":"IF('Window entry'!G61=\"\", \"\", 'Window entry'!G61)","v":""},{"$f":"IF('Window entry'!H61=\"\", \"\", 'Window entry'!H61)","v":""},{"$f":"IF('Window entry'!I61=\"\", \"\", 'Window entry'!I61)","v":""},{"$f":"IF('Window entry'!J61=\"\", \"\", 'Window entry'!J61)","v":""},{"$f":"IF('Window entry'!E61=\"\", \"\", 'Window entry'!E61)","v":""},{"$f":"IF(N67=\"\", \"\", IF(OR('Window entry'!J61=\"Yes\",'Window entry'!I61=\"Yes\"),$AG$56, IF(OR(Q67=\"\", V67=\"\"), \"need more data...\", IF(OR(Q67=$AG$43, Q67=$AG$44, Q67=$AG$45), $AG$56, IF(OR(Q67=$AG$40,Q67=$AG$41), IF(R67=\"Yes\", IF(V67<=MinPD_U, IF(V67<=HPPD_U, $AG$53, $AG$49), $AG$56), IF(S67=\"Yes\", IF(V67<=MinBPA_U, IF(V67<=HPBPA_U, $AG$52, $AG$48),$AG$56),IF(V67<=Min_U, IF(V67<=HP_U, $AG$52, $AG$48),$AG$56))),IF(Q67=$AG$42, IF(R67=\"Yes\",IF(V67<=MinPD_U, IF(V67<=HPPD_U, $AG$55, $AG$51), $AG$56), IF(S67=\"Yes\", IF(V67<=MinBPA_U, IF(V67<=HPBPA_U, $AG$54, $AG$50),$AG$56),IF(V67<=Min_U, IF(V67<=HP_U, $AG$54, $AG$50),$AG$56)))))))))","v":""},null,null,{"$f":"IF('Window entry'!K61=\"\", \"\", 'Window entry'!K61)","v":""},"",null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,"Yes",39,null,null,null,null,0,0,0,null,39,null,{"$f":"IF(M68=\"\", IF('Window entry'!O62*'Window entry'!P62, 'Window entry'!O62*'Window entry'!P62,\"\"), IF('Window entry'!O62*'Window entry'!P62*M68, 'Window entry'!O62*'Window entry'!P62*M68,\"\"))","v":""},{"$f":"'Window entry'!O62","v":0},{"$f":"'Window entry'!P62","v":0},{"$f":"IF('Window entry'!F62=\"\", \"\", 'Window entry'!F62)","v":""},{"$f":"IF('Window entry'!G62=\"\", \"\", 'Window entry'!G62)","v":""},{"$f":"IF('Window entry'!H62=\"\", \"\", 'Window entry'!H62)","v":""},{"$f":"IF('Window entry'!I62=\"\", \"\", 'Window entry'!I62)","v":""},{"$f":"IF('Window entry'!J62=\"\", \"\", 'Window entry'!J62)","v":""},{"$f":"IF('Window entry'!E62=\"\", \"\", 'Window entry'!E62)","v":""},{"$f":"IF(N68=\"\", \"\", IF(OR('Window entry'!J62=\"Yes\",'Window entry'!I62=\"Yes\"),$AG$56, IF(OR(Q68=\"\", V68=\"\"), \"need more data...\", IF(OR(Q68=$AG$43, Q68=$AG$44, Q68=$AG$45), $AG$56, IF(OR(Q68=$AG$40,Q68=$AG$41), IF(R68=\"Yes\", IF(V68<=MinPD_U, IF(V68<=HPPD_U, $AG$53, $AG$49), $AG$56), IF(S68=\"Yes\", IF(V68<=MinBPA_U, IF(V68<=HPBPA_U, $AG$52, $AG$48),$AG$56),IF(V68<=Min_U, IF(V68<=HP_U, $AG$52, $AG$48),$AG$56))),IF(Q68=$AG$42, IF(R68=\"Yes\",IF(V68<=MinPD_U, IF(V68<=HPPD_U, $AG$55, $AG$51), $AG$56), IF(S68=\"Yes\", IF(V68<=MinBPA_U, IF(V68<=HPBPA_U, $AG$54, $AG$50),$AG$56),IF(V68<=Min_U, IF(V68<=HP_U, $AG$54, $AG$50),$AG$56)))))))))","v":""},null,null,{"$f":"IF('Window entry'!K62=\"\", \"\", 'Window entry'!K62)","v":""},"",null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,"Yes",40,null,null,null,null,0,0,0,null,40,null,{"$f":"IF(M69=\"\", IF('Window entry'!O63*'Window entry'!P63, 'Window entry'!O63*'Window entry'!P63,\"\"), IF('Window entry'!O63*'Window entry'!P63*M69, 'Window entry'!O63*'Window entry'!P63*M69,\"\"))","v":""},{"$f":"'Window entry'!O63","v":0},{"$f":"'Window entry'!P63","v":0},{"$f":"IF('Window entry'!F63=\"\", \"\", 'Window entry'!F63)","v":""},{"$f":"IF('Window entry'!G63=\"\", \"\", 'Window entry'!G63)","v":""},{"$f":"IF('Window entry'!H63=\"\", \"\", 'Window entry'!H63)","v":""},{"$f":"IF('Window entry'!I63=\"\", \"\", 'Window entry'!I63)","v":""},{"$f":"IF('Window entry'!J63=\"\", \"\", 'Window entry'!J63)","v":""},{"$f":"IF('Window entry'!E63=\"\", \"\", 'Window entry'!E63)","v":""},{"$f":"IF(N69=\"\", \"\", IF(OR('Window entry'!J63=\"Yes\",'Window entry'!I63=\"Yes\"),$AG$56, IF(OR(Q69=\"\", V69=\"\"), \"need more data...\", IF(OR(Q69=$AG$43, Q69=$AG$44, Q69=$AG$45), $AG$56, IF(OR(Q69=$AG$40,Q69=$AG$41), IF(R69=\"Yes\", IF(V69<=MinPD_U, IF(V69<=HPPD_U, $AG$53, $AG$49), $AG$56), IF(S69=\"Yes\", IF(V69<=MinBPA_U, IF(V69<=HPBPA_U, $AG$52, $AG$48),$AG$56),IF(V69<=Min_U, IF(V69<=HP_U, $AG$52, $AG$48),$AG$56))),IF(Q69=$AG$42, IF(R69=\"Yes\",IF(V69<=MinPD_U, IF(V69<=HPPD_U, $AG$55, $AG$51), $AG$56), IF(S69=\"Yes\", IF(V69<=MinBPA_U, IF(V69<=HPBPA_U, $AG$54, $AG$50),$AG$56),IF(V69<=Min_U, IF(V69<=HP_U, $AG$54, $AG$50),$AG$56)))))))))","v":""},null,null,{"$f":"IF('Window entry'!K63=\"\", \"\", 'Window entry'!K63)","v":""},"",null,null,null,null,null,null,null,null,null,"",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AL30:AL69)","v":0},0,0,0,0,0,0,0,0,{"$f":"IF(SUM(AL30:AL69)=0, 0, SUMPRODUCT(AL30:AL69,AU30:AU69)/SUM(AL30:AL69))","v":0},0,0,0,0,0,0,0,0,{"$f":"SUM(BD30:BD69)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(BM71:BU71)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(X49), W49, X49)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(X68), W68, X68)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISBLANK(X69), W69, X69)","v":""}]