{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Schedules","Project Details","Calculations","Lookups"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":14,"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":"Schedules","index":0,"n_rows":26,"n_cols":11,"rows_kept":26,"cut":false,"hidden":false,"merged":[[2,2,2,3],[2,4,2,8],[2,9,2,10]]}
["Operating Schedules"]
[]
[null,null,"Annual",null,"Weekday Hours Per day (up to 24)",null,null,null,null,"Weekend Hours Per Day (up to 24)"]
[" Schedule","Annual     Hours","Weeks","Weekends","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday"]
[{"$f":"\"Sched_1\"","v":"Sched_1"},{"$f":"(SUM(E5:I5)*C5)+(SUM(J5:K5)*D5)","v":0},52,52]
[{"$f":"\"Sched_2\"","v":"Sched_2"},{"$f":"(SUM(E6:I6)*C6)+(SUM(J6:K6)*D6)","v":0},52,52]
[{"$f":"\"Sched_3\"","v":"Sched_3"},{"$f":"(SUM(E7:I7)*C7)+(SUM(J7:K7)*D7)","v":0},52,52]
[{"$f":"\"Sched_4\"","v":"Sched_4"},{"$f":"(SUM(E8:I8)*C8)+(SUM(J8:K8)*D8)","v":0},52,52]
["Sched_5",0,52,52]
["Sched_6",0,52,52]
["Sched_7",0,52,52]
[{"$f":"\"Sched_8\"","v":"Sched_8"},0,52,52]
[{"$f":"\"Sched_9\"","v":"Sched_9"},0,52,52]
["Sched_10",0,52,52]
[]
["New Control Schedule"]
["Occupancy Sensor","Deemed savings %","Source of Savings Factor"]
["Approved NLC",0.35]
["Control Type 2",0.25]
["Control Type 3",0.15]
["Control Type 4",0.1]
["Control Type 5",0.5]
["None",0]
[]
["User-Defined Fixtures (Existing LED or Other)"]
["Fixture Description","Early Repl. Wattage"]

{"sheet":"Project Details","index":1,"n_rows":386,"n_cols":24,"rows_kept":386,"cut":false,"hidden":false,"merged":[[12,11,12,12],[12,8,12,9],[11,8,11,10],[14,4,14,10],[6,14,7,20],[77,15,78,17],[63,2,63,20],[65,13,66,13],[65,14,66,16],[65,6,66,6],[65,7,66,12],[77,7,78,8],[77,10,78,12],[77,14,78,14],[11,2,11,3],[12,2,12,3],[12,14,12,16],[14,11,14,17],[11,4,11,6],[12,4,12,6]]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Select 100% for the rebate cap if the project is for a multi-family, school, non-profit, or governmental agency facility.  "]
[null,null,null,null,null,null,null,null,null,null,null,null,"Cap:",0.5]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Cost Per kWh:",{"$f":"AVERAGE(0.1718,0.2181)","v":0.19495000000000001}]
[]
[null,null,"Business Name:",null,null,null,null,"Site Address:",null,null,null,"City:","Healdsburg","State:","CA","Zip:",95448]
[null,null,"Contact Name:",null,null,null,null,"Phone:",null,null,"Business Type:",null,null,"Describe (if Other):"]
[]
[null,null,null,null,"Pre-Existing Condition",null,null,null,null,null,null,"Post-Condition (New Equipment)"]
[null,null,"Fixture Location","Space Type","Fixture Type Before Retrofit","Baseline","Fixture Before Retrofit","Baseline Wattage Per Fixture Before Retrofit","# Fixtures Before Retrofit","Lighting Operation Schedule","Annual Hours of Operation Before Retrofit","Fixture Type After Retrofit","Fixture After Retrofit","De-lamp","Watts Per Fixture After Retrofit","# Fixtures After Retrofit","Controls","Annual Hours of Operation After Retrofit","Estimated Annual kWh Savings","Estimated kW Demand Reduction","Calculated Rebate"]
[null,null,null,null,null,null,null,{"$f":"IF(F17=\"Early Replacement\", IFERROR(VLOOKUP(G17, Lookups!B40:D222, 2, FALSE), 0), IF(F17=\"Replace on Burnout\", IFERROR(VLOOKUP(G17, Lookups!B40:D222, 3, FALSE), 0), IF(E17=\"User Defined\", IFERROR(VLOOKUP(G17, Lookups!B213:C246, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J17=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J17,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P17)=0,\"\", _xlfn.IFNA(K17 * (1 - VLOOKUP(TRIM(Q17), Schedules!$A$18:$B$23, 2, FALSE)), K17))","v":""},{"$f":"IF(COUNTA(P17)=0,\"\",IFERROR(IF(F17=\"Replace on Burnout\", Calculations!Z4 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q17), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F17=\"Early Replacement\", Calculations!Y4 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q17), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P17)=0,\"\",IF(D17=\"Exterior\", 0,IF(F17=\"Early Replacement\",Calculations!AC4 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q17), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F17=\"Replace on Burnout\",Calculations!AD4 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q17), Schedules!A18:B23, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P17)=0,\"\", IF(F17=\"Early Replacement\",(Calculations!Y4*0.15),IF(F17=\"Replace on Burnout\",(Calculations!Z4*0.15))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F18=\"Early Replacement\", IFERROR(VLOOKUP(G18, Lookups!B41:D223, 2, FALSE), 0), IF(F18=\"Replace on Burnout\", IFERROR(VLOOKUP(G18, Lookups!B41:D223, 3, FALSE), 0), IF(E18=\"User Defined\", IFERROR(VLOOKUP(G18, Lookups!B214:C247, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J18=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J18,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P18)=0,\"\", _xlfn.IFNA(K18 * (1 - VLOOKUP(TRIM(Q18), Schedules!$A$18:$B$23, 2, FALSE)), K18))","v":""},{"$f":"IF(COUNTA(P18)=0,\"\",IFERROR(IF(F18=\"Replace on Burnout\", Calculations!Z5 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q18), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F18=\"Early Replacement\", Calculations!Y5 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q18), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P18)=0,\"\",IF(D18=\"Exterior\", 0,IF(F18=\"Early Replacement\",Calculations!AC5 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q18), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F18=\"Replace on Burnout\",Calculations!AD5 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q18), Schedules!A19:B24, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P18)=0,\"\", IF(F18=\"Early Replacement\",(Calculations!Y5*0.15),IF(F18=\"Replace on Burnout\",(Calculations!Z5*0.15))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F19=\"Early Replacement\", IFERROR(VLOOKUP(G19, Lookups!B42:D224, 2, FALSE), 0), IF(F19=\"Replace on Burnout\", IFERROR(VLOOKUP(G19, Lookups!B42:D224, 3, FALSE), 0), IF(E19=\"User Defined\", IFERROR(VLOOKUP(G19, Lookups!B215:C248, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J19=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J19,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P19)=0,\"\", _xlfn.IFNA(K19 * (1 - VLOOKUP(TRIM(Q19), Schedules!$A$18:$B$23, 2, FALSE)), K19))","v":""},{"$f":"IF(COUNTA(P19)=0,\"\",IFERROR(IF(F19=\"Replace on Burnout\", Calculations!Z6 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q19), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F19=\"Early Replacement\", Calculations!Y6 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q19), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P19)=0,\"\",IF(D19=\"Exterior\", 0,IF(F19=\"Early Replacement\",Calculations!AC6 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q19), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F19=\"Replace on Burnout\",Calculations!AD6 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q19), Schedules!A20:B25, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P19)=0,\"\", IF(F19=\"Early Replacement\",(Calculations!Y6*0.15),IF(F19=\"Replace on Burnout\",(Calculations!Z6*0.15))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F20=\"Early Replacement\", IFERROR(VLOOKUP(G20, Lookups!B43:D225, 2, FALSE), 0), IF(F20=\"Replace on Burnout\", IFERROR(VLOOKUP(G20, Lookups!B43:D225, 3, FALSE), 0), IF(E20=\"User Defined\", IFERROR(VLOOKUP(G20, Lookups!B216:C249, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J20=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J20,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P20)=0,\"\", _xlfn.IFNA(K20 * (1 - VLOOKUP(TRIM(Q20), Schedules!$A$18:$B$23, 2, FALSE)), K20))","v":""},{"$f":"IF(COUNTA(P20)=0,\"\",IFERROR(IF(F20=\"Replace on Burnout\", Calculations!Z7 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q20), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F20=\"Early Replacement\", Calculations!Y7 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q20), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P20)=0,\"\",IF(D20=\"Exterior\", 0,IF(F20=\"Early Replacement\",Calculations!AC7 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q20), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F20=\"Replace on Burnout\",Calculations!AD7 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q20), Schedules!A21:B26, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P20)=0,\"\", IF(F20=\"Early Replacement\",(Calculations!Y7*0.15),IF(F20=\"Replace on Burnout\",(Calculations!Z7*0.15))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F21=\"Early Replacement\", IFERROR(VLOOKUP(G21, Lookups!B44:D226, 2, FALSE), 0), IF(F21=\"Replace on Burnout\", IFERROR(VLOOKUP(G21, Lookups!B44:D226, 3, FALSE), 0), IF(E21=\"User Defined\", IFERROR(VLOOKUP(G21, Lookups!B217:C250, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J21=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J21,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P21)=0,\"\", _xlfn.IFNA(K21 * (1 - VLOOKUP(TRIM(Q21), Schedules!$A$18:$B$23, 2, FALSE)), K21))","v":""},{"$f":"IF(COUNTA(P21)=0,\"\",IFERROR(IF(F21=\"Replace on Burnout\", Calculations!Z8 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q21), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F21=\"Early Replacement\", Calculations!Y8 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q21), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P21)=0,\"\",IF(D21=\"Exterior\", 0,IF(F21=\"Early Replacement\",Calculations!AC8 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q21), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F21=\"Replace on Burnout\",Calculations!AD8 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q21), Schedules!A22:B27, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P21)=0,\"\", IF(F21=\"Early Replacement\",(Calculations!Y8*0.15),IF(F21=\"Replace on Burnout\",(Calculations!Z8*0.15))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F22=\"Early Replacement\", IFERROR(VLOOKUP(G22, Lookups!B45:D227, 2, FALSE), 0), IF(F22=\"Replace on Burnout\", IFERROR(VLOOKUP(G22, Lookups!B45:D227, 3, FALSE), 0), IF(E22=\"User Defined\", IFERROR(VLOOKUP(G22, Lookups!B218:C251, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J22=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J22,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P22)=0,\"\", _xlfn.IFNA(K22 * (1 - VLOOKUP(TRIM(Q22), Schedules!$A$18:$B$23, 2, FALSE)), K22))","v":""},{"$f":"IF(COUNTA(P22)=0,\"\",IFERROR(IF(F22=\"Replace on Burnout\", Calculations!Z9 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q22), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F22=\"Early Replacement\", Calculations!Y9 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q22), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P22)=0,\"\",IF(D22=\"Exterior\", 0,IF(F22=\"Early Replacement\",Calculations!AC9 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q22), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F22=\"Replace on Burnout\",Calculations!AD9 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q22), Schedules!A23:B28, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P22)=0,\"\", IF(F22=\"Early Replacement\",(Calculations!Y9*0.15),IF(F22=\"Replace on Burnout\",(Calculations!Z9*0.15))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F23=\"Early Replacement\", IFERROR(VLOOKUP(G23, Lookups!B46:D228, 2, FALSE), 0), IF(F23=\"Replace on Burnout\", IFERROR(VLOOKUP(G23, Lookups!B46:D228, 3, FALSE), 0), IF(E23=\"User Defined\", IFERROR(VLOOKUP(G23, Lookups!B219:C252, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J23=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J23,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P23)=0,\"\", _xlfn.IFNA(K23 * (1 - VLOOKUP(TRIM(Q23), Schedules!$A$18:$B$23, 2, FALSE)), K23))","v":""},{"$f":"IF(COUNTA(P23)=0,\"\",IFERROR(IF(F23=\"Replace on Burnout\", Calculations!Z10 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q23), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F23=\"Early Replacement\", Calculations!Y10 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q23), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P23)=0,\"\",IF(D23=\"Exterior\", 0,IF(F23=\"Early Replacement\",Calculations!AC10 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q23), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F23=\"Replace on Burnout\",Calculations!AD10 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q23), Schedules!A24:B29, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P23)=0,\"\", IF(F23=\"Early Replacement\",(Calculations!Y10*0.15),IF(F23=\"Replace on Burnout\",(Calculations!Z10*0.15))))","v":""},null,null," "]
[null,null,null,null,null,null,null,{"$f":"IF(F24=\"Early Replacement\", IFERROR(VLOOKUP(G24, Lookups!B47:D229, 2, FALSE), 0), IF(F24=\"Replace on Burnout\", IFERROR(VLOOKUP(G24, Lookups!B47:D229, 3, FALSE), 0), IF(E24=\"User Defined\", IFERROR(VLOOKUP(G24, Lookups!B220:C253, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J24=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J24,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P24)=0,\"\", _xlfn.IFNA(K24 * (1 - VLOOKUP(TRIM(Q24), Schedules!$A$18:$B$23, 2, FALSE)), K24))","v":""},{"$f":"IF(COUNTA(P24)=0,\"\",IFERROR(IF(F24=\"Replace on Burnout\", Calculations!Z11 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q24), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F24=\"Early Replacement\", Calculations!Y11 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q24), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P24)=0,\"\",IF(D24=\"Exterior\", 0,IF(F24=\"Early Replacement\",Calculations!AC11 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q24), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F24=\"Replace on Burnout\",Calculations!AD11 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q24), Schedules!A25:B30, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P24)=0,\"\", IF(F24=\"Early Replacement\",(Calculations!Y11*0.15),IF(F24=\"Replace on Burnout\",(Calculations!Z11*0.15))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F25=\"Early Replacement\", IFERROR(VLOOKUP(G25, Lookups!B48:D230, 2, FALSE), 0), IF(F25=\"Replace on Burnout\", IFERROR(VLOOKUP(G25, Lookups!B48:D230, 3, FALSE), 0), IF(E25=\"User Defined\", IFERROR(VLOOKUP(G25, Lookups!B221:C254, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J25=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J25,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P25)=0,\"\", _xlfn.IFNA(K25 * (1 - VLOOKUP(TRIM(Q25), Schedules!$A$18:$B$23, 2, FALSE)), K25))","v":""},{"$f":"IF(COUNTA(P25)=0,\"\",IFERROR(IF(F25=\"Replace on Burnout\", Calculations!Z12 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q25), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F25=\"Early Replacement\", Calculations!Y12 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q25), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P25)=0,\"\",IF(D25=\"Exterior\", 0,IF(F25=\"Early Replacement\",Calculations!AC12 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q25), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F25=\"Replace on Burnout\",Calculations!AD12 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q25), Schedules!A26:B31, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P25)=0,\"\", IF(F25=\"Early Replacement\",(Calculations!Y12*0.15),IF(F25=\"Replace on Burnout\",(Calculations!Z12*0.15))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F26=\"Early Replacement\", IFERROR(VLOOKUP(G26, Lookups!B49:D231, 2, FALSE), 0), IF(F26=\"Replace on Burnout\", IFERROR(VLOOKUP(G26, Lookups!B49:D231, 3, FALSE), 0), IF(E26=\"User Defined\", IFERROR(VLOOKUP(G26, Lookups!B222:C255, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J26=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J26,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P26)=0,\"\", _xlfn.IFNA(K26 * (1 - VLOOKUP(TRIM(Q26), Schedules!$A$18:$B$23, 2, FALSE)), K26))","v":""},{"$f":"IF(COUNTA(P26)=0,\"\",IFERROR(IF(F26=\"Replace on Burnout\", Calculations!Z13 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q26), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F26=\"Early Replacement\", Calculations!Y13 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q26), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P26)=0,\"\",IF(D26=\"Exterior\", 0,IF(F26=\"Early Replacement\",Calculations!AC13 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q26), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F26=\"Replace on Burnout\",Calculations!AD13 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q26), Schedules!A27:B32, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P26)=0,\"\", IF(F26=\"Early Replacement\",(Calculations!Y13*0.15),IF(F26=\"Replace on Burnout\",(Calculations!Z13*0.15))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F27=\"Early Replacement\", IFERROR(VLOOKUP(G27, Lookups!B50:D232, 2, FALSE), 0), IF(F27=\"Replace on Burnout\", IFERROR(VLOOKUP(G27, Lookups!B50:D232, 3, FALSE), 0), IF(E27=\"User Defined\", IFERROR(VLOOKUP(G27, Lookups!B223:C256, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J27=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J27,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P27)=0,\"\", _xlfn.IFNA(K27 * (1 - VLOOKUP(TRIM(Q27), Schedules!$A$18:$B$23, 2, FALSE)), K27))","v":""},{"$f":"IF(COUNTA(P27)=0,\"\",IFERROR(IF(F27=\"Replace on Burnout\", Calculations!Z14 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q27), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F27=\"Early Replacement\", Calculations!Y14 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q27), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P27)=0,\"\",IF(D27=\"Exterior\", 0,IF(F27=\"Early Replacement\",Calculations!AC14 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q27), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F27=\"Replace on Burnout\",Calculations!AD14 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q27), Schedules!A28:B33, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P27)=0,\"\", IF(F27=\"Early Replacement\",(Calculations!Y14*0.15),IF(F27=\"Replace on Burnout\",(Calculations!Z14*0.15))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F28=\"Early Replacement\", IFERROR(VLOOKUP(G28, Lookups!B51:D233, 2, FALSE), 0), IF(F28=\"Replace on Burnout\", IFERROR(VLOOKUP(G28, Lookups!B51:D233, 3, FALSE), 0), IF(E28=\"User Defined\", IFERROR(VLOOKUP(G28, Lookups!B224:C257, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J28=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J28,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P28)=0,\"\", _xlfn.IFNA(K28 * (1 - VLOOKUP(TRIM(Q28), Schedules!$A$18:$B$23, 2, FALSE)), K28))","v":""},{"$f":"IF(COUNTA(P28)=0,\"\",IFERROR(IF(F28=\"Replace on Burnout\", Calculations!Z15 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q28), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F28=\"Early Replacement\", Calculations!Y15 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q28), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P28)=0,\"\",IF(D28=\"Exterior\", 0,IF(F28=\"Early Replacement\",Calculations!AC15 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q28), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F28=\"Replace on Burnout\",Calculations!AD15 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q28), Schedules!A29:B34, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P28)=0,\"\", IF(F28=\"Early Replacement\",(Calculations!Y15*0.15),IF(F28=\"Replace on Burnout\",(Calculations!Z15*0.15))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F29=\"Early Replacement\", IFERROR(VLOOKUP(G29, Lookups!B52:D234, 2, FALSE), 0), IF(F29=\"Replace on Burnout\", IFERROR(VLOOKUP(G29, Lookups!B52:D234, 3, FALSE), 0), IF(E29=\"User Defined\", IFERROR(VLOOKUP(G29, Lookups!B225:C258, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J29=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J29,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P29)=0,\"\", _xlfn.IFNA(K29 * (1 - VLOOKUP(TRIM(Q29), Schedules!$A$18:$B$23, 2, FALSE)), K29))","v":""},{"$f":"IF(COUNTA(P29)=0,\"\",IFERROR(IF(F29=\"Replace on Burnout\", Calculations!Z16 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q29), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F29=\"Early Replacement\", Calculations!Y16 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q29), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P29)=0,\"\",IF(D29=\"Exterior\", 0,IF(F29=\"Early Replacement\",Calculations!AC16 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q29), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F29=\"Replace on Burnout\",Calculations!AD16 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q29), Schedules!A30:B35, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P29)=0,\"\", IF(F29=\"Early Replacement\",(Calculations!Y16*0.15),IF(F29=\"Replace on Burnout\",(Calculations!Z16*0.15))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F30=\"Early Replacement\", IFERROR(VLOOKUP(G30, Lookups!B53:D235, 2, FALSE), 0), IF(F30=\"Replace on Burnout\", IFERROR(VLOOKUP(G30, Lookups!B53:D235, 3, FALSE), 0), IF(E30=\"User Defined\", IFERROR(VLOOKUP(G30, Lookups!B226:C259, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J30=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J30,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P30)=0,\"\", _xlfn.IFNA(K30 * (1 - VLOOKUP(TRIM(Q30), Schedules!$A$18:$B$23, 2, FALSE)), K30))","v":""},{"$f":"IF(COUNTA(P30)=0,\"\",IFERROR(IF(F30=\"Replace on Burnout\", Calculations!Z17 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q30), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F30=\"Early Replacement\", Calculations!Y17 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q30), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P30)=0,\"\",IF(D30=\"Exterior\", 0,IF(F30=\"Early Replacement\",Calculations!AC17 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q30), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F30=\"Replace on Burnout\",Calculations!AD17 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q30), Schedules!A31:B36, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P30)=0,\"\", IF(F30=\"Early Replacement\",(Calculations!Y17*0.15),IF(F30=\"Replace on Burnout\",(Calculations!Z17*0.15))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F31=\"Early Replacement\", IFERROR(VLOOKUP(G31, Lookups!B54:D236, 2, FALSE), 0), IF(F31=\"Replace on Burnout\", IFERROR(VLOOKUP(G31, Lookups!B54:D236, 3, FALSE), 0), IF(E31=\"User Defined\", IFERROR(VLOOKUP(G31, Lookups!B227:C260, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J31=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J31,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P31)=0,\"\", _xlfn.IFNA(K31 * (1 - VLOOKUP(TRIM(Q31), Schedules!$A$18:$B$23, 2, FALSE)), K31))","v":""},{"$f":"IF(COUNTA(P31)=0,\"\",IFERROR(IF(F31=\"Replace on Burnout\", Calculations!Z18 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q31), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F31=\"Early Replacement\", Calculations!Y18 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q31), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P31)=0,\"\",IF(D31=\"Exterior\", 0,IF(F31=\"Early Replacement\",Calculations!AC18 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q31), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F31=\"Replace on Burnout\",Calculations!AD18 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q31), Schedules!A32:B37, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P31)=0,\"\", IF(F31=\"Early Replacement\",(Calculations!Y18*0.15),IF(F31=\"Replace on Burnout\",(Calculations!Z18*0.15))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F32=\"Early Replacement\", IFERROR(VLOOKUP(G32, Lookups!B55:D237, 2, FALSE), 0), IF(F32=\"Replace on Burnout\", IFERROR(VLOOKUP(G32, Lookups!B55:D237, 3, FALSE), 0), IF(E32=\"User Defined\", IFERROR(VLOOKUP(G32, Lookups!B228:C261, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J32=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J32,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P32)=0,\"\", _xlfn.IFNA(K32 * (1 - VLOOKUP(TRIM(Q32), Schedules!$A$18:$B$23, 2, FALSE)), K32))","v":""},{"$f":"IF(COUNTA(P32)=0,\"\",IFERROR(IF(F32=\"Replace on Burnout\", Calculations!Z19 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q32), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F32=\"Early Replacement\", Calculations!Y19 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q32), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P32)=0,\"\",IF(D32=\"Exterior\", 0,IF(F32=\"Early Replacement\",Calculations!AC19 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q32), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F32=\"Replace on Burnout\",Calculations!AD19 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q32), Schedules!A33:B38, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P32)=0,\"\", IF(F32=\"Early Replacement\",(Calculations!Y19*0.15),IF(F32=\"Replace on Burnout\",(Calculations!Z19*0.15))))","v":""},null,null," "]
[null,null,null,null,null,null,null,{"$f":"IF(F33=\"Early Replacement\", IFERROR(VLOOKUP(G33, Lookups!B56:D238, 2, FALSE), 0), IF(F33=\"Replace on Burnout\", IFERROR(VLOOKUP(G33, Lookups!B56:D238, 3, FALSE), 0), IF(E33=\"User Defined\", IFERROR(VLOOKUP(G33, Lookups!B229:C262, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J33=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J33,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P33)=0,\"\", _xlfn.IFNA(K33 * (1 - VLOOKUP(TRIM(Q33), Schedules!$A$18:$B$23, 2, FALSE)), K33))","v":""},{"$f":"IF(COUNTA(P33)=0,\"\",IFERROR(IF(F33=\"Replace on Burnout\", Calculations!Z20 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q33), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F33=\"Early Replacement\", Calculations!Y20 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q33), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P33)=0,\"\",IF(D33=\"Exterior\", 0,IF(F33=\"Early Replacement\",Calculations!AC20 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q33), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F33=\"Replace on Burnout\",Calculations!AD20 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q33), Schedules!A34:B39, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P33)=0,\"\", IF(F33=\"Early Replacement\",(Calculations!Y20*0.15),IF(F33=\"Replace on Burnout\",(Calculations!Z20*0.15))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F34=\"Early Replacement\", IFERROR(VLOOKUP(G34, Lookups!B57:D239, 2, FALSE), 0), IF(F34=\"Replace on Burnout\", IFERROR(VLOOKUP(G34, Lookups!B57:D239, 3, FALSE), 0), IF(E34=\"User Defined\", IFERROR(VLOOKUP(G34, Lookups!B230:C263, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J34=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J34,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P34)=0,\"\", _xlfn.IFNA(K34 * (1 - VLOOKUP(TRIM(Q34), Schedules!$A$18:$B$23, 2, FALSE)), K34))","v":""},{"$f":"IF(COUNTA(P34)=0,\"\",IFERROR(IF(F34=\"Replace on Burnout\", Calculations!Z21 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q34), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F34=\"Early Replacement\", Calculations!Y21 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q34), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P34)=0,\"\",IF(D34=\"Exterior\", 0,IF(F34=\"Early Replacement\",Calculations!AC21 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q34), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F34=\"Replace on Burnout\",Calculations!AD21 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q34), Schedules!A35:B40, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P34)=0,\"\", IF(F34=\"Early Replacement\",(Calculations!Y21*0.15),IF(F34=\"Replace on Burnout\",(Calculations!Z21*0.15))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F35=\"Early Replacement\", IFERROR(VLOOKUP(G35, Lookups!B58:D240, 2, FALSE), 0), IF(F35=\"Replace on Burnout\", IFERROR(VLOOKUP(G35, Lookups!B58:D240, 3, FALSE), 0), IF(E35=\"User Defined\", IFERROR(VLOOKUP(G35, Lookups!B231:C264, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J35=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J35,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P35)=0,\"\", _xlfn.IFNA(K35 * (1 - VLOOKUP(TRIM(Q35), Schedules!$A$18:$B$23, 2, FALSE)), K35))","v":""},{"$f":"IF(COUNTA(P35)=0,\"\",IFERROR(IF(F35=\"Replace on Burnout\", Calculations!Z22 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q35), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F35=\"Early Replacement\", Calculations!Y22 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q35), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P35)=0,\"\",IF(D35=\"Exterior\", 0,IF(F35=\"Early Replacement\",Calculations!AC22 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q35), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F35=\"Replace on Burnout\",Calculations!AD22 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q35), Schedules!A36:B41, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P35)=0,\"\", IF(F35=\"Early Replacement\",(Calculations!Y22*0.15),IF(F35=\"Replace on Burnout\",(Calculations!Z22*0.15))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F36=\"Early Replacement\", IFERROR(VLOOKUP(G36, Lookups!B59:D241, 2, FALSE), 0), IF(F36=\"Replace on Burnout\", IFERROR(VLOOKUP(G36, Lookups!B59:D241, 3, FALSE), 0), IF(E36=\"User Defined\", IFERROR(VLOOKUP(G36, Lookups!B232:C265, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J36=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J36,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P36)=0,\"\", _xlfn.IFNA(K36 * (1 - VLOOKUP(TRIM(Q36), Schedules!$A$18:$B$23, 2, FALSE)), K36))","v":""},{"$f":"IF(COUNTA(P36)=0,\"\",IFERROR(IF(F36=\"Replace on Burnout\", Calculations!Z23 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q36), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F36=\"Early Replacement\", Calculations!Y23 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q36), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P36)=0,\"\",IF(D36=\"Exterior\", 0,IF(F36=\"Early Replacement\",Calculations!AC23 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q36), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F36=\"Replace on Burnout\",Calculations!AD23 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q36), Schedules!A37:B42, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P36)=0,\"\", IF(F36=\"Early Replacement\",(Calculations!Y23*0.15),IF(F36=\"Replace on Burnout\",(Calculations!Z23*0.15))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F37=\"Early Replacement\", IFERROR(VLOOKUP(G37, Lookups!B60:D242, 2, FALSE), 0), IF(F37=\"Replace on Burnout\", IFERROR(VLOOKUP(G37, Lookups!B60:D242, 3, FALSE), 0), IF(E37=\"User Defined\", IFERROR(VLOOKUP(G37, Lookups!B233:C266, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J37=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J37,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P37)=0,\"\", _xlfn.IFNA(K37 * (1 - VLOOKUP(TRIM(Q37), Schedules!$A$18:$B$23, 2, FALSE)), K37))","v":""},{"$f":"IF(COUNTA(P37)=0,\"\",IFERROR(IF(F37=\"Replace on Burnout\", Calculations!Z24 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q37), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F37=\"Early Replacement\", Calculations!Y24 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q37), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P37)=0,\"\",IF(D37=\"Exterior\", 0,IF(F37=\"Early Replacement\",Calculations!AC24 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q37), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F37=\"Replace on Burnout\",Calculations!AD24 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q37), Schedules!A38:B43, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P37)=0,\"\", IF(F37=\"Early Replacement\",(Calculations!Y24*0.15),IF(F37=\"Replace on Burnout\",(Calculations!Z24*0.15))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F38=\"Early Replacement\", IFERROR(VLOOKUP(G38, Lookups!B61:D243, 2, FALSE), 0), IF(F38=\"Replace on Burnout\", IFERROR(VLOOKUP(G38, Lookups!B61:D243, 3, FALSE), 0), IF(E38=\"User Defined\", IFERROR(VLOOKUP(G38, Lookups!B234:C267, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J38=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J38,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P38)=0,\"\", _xlfn.IFNA(K38 * (1 - VLOOKUP(TRIM(Q38), Schedules!$A$18:$B$23, 2, FALSE)), K38))","v":""},{"$f":"IF(COUNTA(P38)=0,\"\",IFERROR(IF(F38=\"Replace on Burnout\", Calculations!Z25 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q38), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F38=\"Early Replacement\", Calculations!Y25 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q38), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P38)=0,\"\",IF(D38=\"Exterior\", 0,IF(F38=\"Early Replacement\",Calculations!AC25 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q38), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F38=\"Replace on Burnout\",Calculations!AD25 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q38), Schedules!A39:B44, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P38)=0,\"\", IF(F38=\"Early Replacement\",(Calculations!Y25*0.15),IF(F38=\"Replace on Burnout\",(Calculations!Z25*0.15))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F39=\"Early Replacement\", IFERROR(VLOOKUP(G39, Lookups!B62:D244, 2, FALSE), 0), IF(F39=\"Replace on Burnout\", IFERROR(VLOOKUP(G39, Lookups!B62:D244, 3, FALSE), 0), IF(E39=\"User Defined\", IFERROR(VLOOKUP(G39, Lookups!B235:C268, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J39=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J39,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P39)=0,\"\", _xlfn.IFNA(K39 * (1 - VLOOKUP(TRIM(Q39), Schedules!$A$18:$B$23, 2, FALSE)), K39))","v":""},{"$f":"IF(COUNTA(P39)=0,\"\",IFERROR(IF(F39=\"Replace on Burnout\", Calculations!Z26 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q39), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F39=\"Early Replacement\", Calculations!Y26 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q39), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P39)=0,\"\",IF(D39=\"Exterior\", 0,IF(F39=\"Early Replacement\",Calculations!AC26 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q39), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F39=\"Replace on Burnout\",Calculations!AD26 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q39), Schedules!A40:B45, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P39)=0,\"\", IF(F39=\"Early Replacement\",(Calculations!Y26*0.15),IF(F39=\"Replace on Burnout\",(Calculations!Z26*0.15))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F40=\"Early Replacement\", IFERROR(VLOOKUP(G40, Lookups!B63:D245, 2, FALSE), 0), IF(F40=\"Replace on Burnout\", IFERROR(VLOOKUP(G40, Lookups!B63:D245, 3, FALSE), 0), IF(E40=\"User Defined\", IFERROR(VLOOKUP(G40, Lookups!B236:C269, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J40=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J40,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P40)=0,\"\", _xlfn.IFNA(K40 * (1 - VLOOKUP(TRIM(Q40), Schedules!$A$18:$B$23, 2, FALSE)), K40))","v":""},{"$f":"IF(COUNTA(P40)=0,\"\",IFERROR(IF(F40=\"Replace on Burnout\", Calculations!Z27 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q40), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F40=\"Early Replacement\", Calculations!Y27 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q40), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P40)=0,\"\",IF(D40=\"Exterior\", 0,IF(F40=\"Early Replacement\",Calculations!AC27 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q40), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F40=\"Replace on Burnout\",Calculations!AD27 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q40), Schedules!A41:B46, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P40)=0,\"\", IF(F40=\"Early Replacement\",(Calculations!Y27*0.15),IF(F40=\"Replace on Burnout\",(Calculations!Z27*0.15))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F41=\"Early Replacement\", IFERROR(VLOOKUP(G41, Lookups!B64:D246, 2, FALSE), 0), IF(F41=\"Replace on Burnout\", IFERROR(VLOOKUP(G41, Lookups!B64:D246, 3, FALSE), 0), IF(E41=\"User Defined\", IFERROR(VLOOKUP(G41, Lookups!B237:C270, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J41=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J41,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P41)=0,\"\", _xlfn.IFNA(K41 * (1 - VLOOKUP(TRIM(Q41), Schedules!$A$18:$B$23, 2, FALSE)), K41))","v":""},{"$f":"IF(COUNTA(P41)=0,\"\",IFERROR(IF(F41=\"Replace on Burnout\", Calculations!Z28 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q41), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F41=\"Early Replacement\", Calculations!Y28 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q41), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P41)=0,\"\",IF(D41=\"Exterior\", 0,IF(F41=\"Early Replacement\",Calculations!AC28 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q41), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F41=\"Replace on Burnout\",Calculations!AD28 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q41), Schedules!A42:B47, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P41)=0,\"\", IF(F41=\"Early Replacement\",(Calculations!Y28*0.15),IF(F41=\"Replace on Burnout\",(Calculations!Z28*0.15))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F42=\"Early Replacement\", IFERROR(VLOOKUP(G42, Lookups!B65:D247, 2, FALSE), 0), IF(F42=\"Replace on Burnout\", IFERROR(VLOOKUP(G42, Lookups!B65:D247, 3, FALSE), 0), IF(E42=\"User Defined\", IFERROR(VLOOKUP(G42, Lookups!B238:C271, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J42=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J42,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P42)=0,\"\", _xlfn.IFNA(K42 * (1 - VLOOKUP(TRIM(Q42), Schedules!$A$18:$B$23, 2, FALSE)), K42))","v":""},{"$f":"IF(COUNTA(P42)=0,\"\",IFERROR(IF(F42=\"Replace on Burnout\", Calculations!Z29 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q42), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F42=\"Early Replacement\", Calculations!Y29 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q42), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P42)=0,\"\",IF(D42=\"Exterior\", 0,IF(F42=\"Early Replacement\",Calculations!AC29 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q42), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F42=\"Replace on Burnout\",Calculations!AD29 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q42), Schedules!A43:B48, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P42)=0,\"\", IF(F42=\"Early Replacement\",(Calculations!Y29*0.15),IF(F42=\"Replace on Burnout\",(Calculations!Z29*0.15))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F43=\"Early Replacement\", IFERROR(VLOOKUP(G43, Lookups!B66:D248, 2, FALSE), 0), IF(F43=\"Replace on Burnout\", IFERROR(VLOOKUP(G43, Lookups!B66:D248, 3, FALSE), 0), IF(E43=\"User Defined\", IFERROR(VLOOKUP(G43, Lookups!B239:C272, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J43=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J43,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P43)=0,\"\", _xlfn.IFNA(K43 * (1 - VLOOKUP(TRIM(Q43), Schedules!$A$18:$B$23, 2, FALSE)), K43))","v":""},{"$f":"IF(COUNTA(P43)=0,\"\",IFERROR(IF(F43=\"Replace on Burnout\", Calculations!Z30 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q43), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F43=\"Early Replacement\", Calculations!Y30 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q43), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P43)=0,\"\",IF(D43=\"Exterior\", 0,IF(F43=\"Early Replacement\",Calculations!AC30 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q43), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F43=\"Replace on Burnout\",Calculations!AD30 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q43), Schedules!A44:B49, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P43)=0,\"\", IF(F43=\"Early Replacement\",(Calculations!Y30*0.15),IF(F43=\"Replace on Burnout\",(Calculations!Z30*0.15))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F44=\"Early Replacement\", IFERROR(VLOOKUP(G44, Lookups!B67:D249, 2, FALSE), 0), IF(F44=\"Replace on Burnout\", IFERROR(VLOOKUP(G44, Lookups!B67:D249, 3, FALSE), 0), IF(E44=\"User Defined\", IFERROR(VLOOKUP(G44, Lookups!B240:C273, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J44=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J44,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P44)=0,\"\", _xlfn.IFNA(K44 * (1 - VLOOKUP(TRIM(Q44), Schedules!$A$18:$B$23, 2, FALSE)), K44))","v":""},{"$f":"IF(COUNTA(P44)=0,\"\",IFERROR(IF(F44=\"Replace on Burnout\", Calculations!Z31 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q44), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F44=\"Early Replacement\", Calculations!Y31 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q44), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P44)=0,\"\",IF(D44=\"Exterior\", 0,IF(F44=\"Early Replacement\",Calculations!AC31 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q44), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F44=\"Replace on Burnout\",Calculations!AD31 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q44), Schedules!A45:B50, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P44)=0,\"\", IF(F44=\"Early Replacement\",(Calculations!Y31*0.15),IF(F44=\"Replace on Burnout\",(Calculations!Z31*0.15))))","v":""},null,null," "]
[null,null,null,null,null,null,null,{"$f":"IF(F45=\"Early Replacement\", IFERROR(VLOOKUP(G45, Lookups!B68:D250, 2, FALSE), 0), IF(F45=\"Replace on Burnout\", IFERROR(VLOOKUP(G45, Lookups!B68:D250, 3, FALSE), 0), IF(E45=\"User Defined\", IFERROR(VLOOKUP(G45, Lookups!B241:C274, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J45=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J45,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P45)=0,\"\", _xlfn.IFNA(K45 * (1 - VLOOKUP(TRIM(Q45), Schedules!$A$18:$B$23, 2, FALSE)), K45))","v":""},{"$f":"IF(COUNTA(P45)=0,\"\",IFERROR(IF(F45=\"Replace on Burnout\", Calculations!Z32 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q45), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F45=\"Early Replacement\", Calculations!Y32 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q45), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P45)=0,\"\",IF(D45=\"Exterior\", 0,IF(F45=\"Early Replacement\",Calculations!AC32 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q45), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F45=\"Replace on Burnout\",Calculations!AD32 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q45), Schedules!A46:B51, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P45)=0,\"\", IF(F45=\"Early Replacement\",(Calculations!Y32*0.15),IF(F45=\"Replace on Burnout\",(Calculations!Z32*0.15))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F46=\"Early Replacement\", IFERROR(VLOOKUP(G46, Lookups!B69:D251, 2, FALSE), 0), IF(F46=\"Replace on Burnout\", IFERROR(VLOOKUP(G46, Lookups!B69:D251, 3, FALSE), 0), IF(E46=\"User Defined\", IFERROR(VLOOKUP(G46, Lookups!B242:C275, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J46=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J46,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P46)=0,\"\", _xlfn.IFNA(K46 * (1 - VLOOKUP(TRIM(Q46), Schedules!$A$18:$B$23, 2, FALSE)), K46))","v":""},{"$f":"IF(COUNTA(P46)=0,\"\",IFERROR(IF(F46=\"Replace on Burnout\", Calculations!Z33 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q46), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F46=\"Early Replacement\", Calculations!Y33 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q46), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P46)=0,\"\",IF(D46=\"Exterior\", 0,IF(F46=\"Early Replacement\",Calculations!AC33 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q46), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F46=\"Replace on Burnout\",Calculations!AD33 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q46), Schedules!A47:B52, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P46)=0,\"\", IF(F46=\"Early Replacement\",(Calculations!Y33*0.15),IF(F46=\"Replace on Burnout\",(Calculations!Z33*0.15))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F47=\"Early Replacement\", IFERROR(VLOOKUP(G47, Lookups!B70:D252, 2, FALSE), 0), IF(F47=\"Replace on Burnout\", IFERROR(VLOOKUP(G47, Lookups!B70:D252, 3, FALSE), 0), IF(E47=\"User Defined\", IFERROR(VLOOKUP(G47, Lookups!B243:C276, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J47=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J47,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P47)=0,\"\", _xlfn.IFNA(K47 * (1 - VLOOKUP(TRIM(Q47), Schedules!$A$18:$B$23, 2, FALSE)), K47))","v":""},{"$f":"IF(COUNTA(P47)=0,\"\",IFERROR(IF(F47=\"Replace on Burnout\", Calculations!Z34 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q47), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F47=\"Early Replacement\", Calculations!Y34 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q47), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P47)=0,\"\",IF(D47=\"Exterior\", 0,IF(F47=\"Early Replacement\",Calculations!AC34 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q47), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F47=\"Replace on Burnout\",Calculations!AD34 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q47), Schedules!A48:B53, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P47)=0,\"\", IF(F47=\"Early Replacement\",(Calculations!Y34*0.15),IF(F47=\"Replace on Burnout\",(Calculations!Z34*0.15))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F48=\"Early Replacement\", IFERROR(VLOOKUP(G48, Lookups!B71:D253, 2, FALSE), 0), IF(F48=\"Replace on Burnout\", IFERROR(VLOOKUP(G48, Lookups!B71:D253, 3, FALSE), 0), IF(E48=\"User Defined\", IFERROR(VLOOKUP(G48, Lookups!B244:C277, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J48=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J48,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P48)=0,\"\", _xlfn.IFNA(K48 * (1 - VLOOKUP(TRIM(Q48), Schedules!$A$18:$B$23, 2, FALSE)), K48))","v":""},{"$f":"IF(COUNTA(P48)=0,\"\",IFERROR(IF(F48=\"Replace on Burnout\", Calculations!Z35 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q48), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F48=\"Early Replacement\", Calculations!Y35 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q48), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P48)=0,\"\",IF(D48=\"Exterior\", 0,IF(F48=\"Early Replacement\",Calculations!AC35 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q48), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F48=\"Replace on Burnout\",Calculations!AD35 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q48), Schedules!A49:B54, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P48)=0,\"\", IF(F48=\"Early Replacement\",(Calculations!Y35*0.15),IF(F48=\"Replace on Burnout\",(Calculations!Z35*0.15))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F49=\"Early Replacement\", IFERROR(VLOOKUP(G49, Lookups!B72:D254, 2, FALSE), 0), IF(F49=\"Replace on Burnout\", IFERROR(VLOOKUP(G49, Lookups!B72:D254, 3, FALSE), 0), IF(E49=\"User Defined\", IFERROR(VLOOKUP(G49, Lookups!B245:C278, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J49=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J49,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P49)=0,\"\", _xlfn.IFNA(K49 * (1 - VLOOKUP(TRIM(Q49), Schedules!$A$18:$B$23, 2, FALSE)), K49))","v":""},{"$f":"IF(COUNTA(P49)=0,\"\",IFERROR(IF(F49=\"Replace on Burnout\", Calculations!Z36 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q49), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F49=\"Early Replacement\", Calculations!Y36 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q49), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P49)=0,\"\",IF(D49=\"Exterior\", 0,IF(F49=\"Early Replacement\",Calculations!AC36 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q49), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F49=\"Replace on Burnout\",Calculations!AD36 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q49), Schedules!A50:B55, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P49)=0,\"\", IF(F49=\"Early Replacement\",(Calculations!Y36*0.15),IF(F49=\"Replace on Burnout\",(Calculations!Z36*0.15))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F50=\"Early Replacement\", IFERROR(VLOOKUP(G50, Lookups!B73:D255, 2, FALSE), 0), IF(F50=\"Replace on Burnout\", IFERROR(VLOOKUP(G50, Lookups!B73:D255, 3, FALSE), 0), IF(E50=\"User Defined\", IFERROR(VLOOKUP(G50, Lookups!B246:C279, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J50=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J50,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P50)=0,\"\", _xlfn.IFNA(K50 * (1 - VLOOKUP(TRIM(Q50), Schedules!$A$18:$B$23, 2, FALSE)), K50))","v":""},{"$f":"IF(COUNTA(P50)=0,\"\",IFERROR(IF(F50=\"Replace on Burnout\", Calculations!Z37 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q50), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F50=\"Early Replacement\", Calculations!Y37 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q50), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P50)=0,\"\",IF(D50=\"Exterior\", 0,IF(F50=\"Early Replacement\",Calculations!AC37 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q50), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F50=\"Replace on Burnout\",Calculations!AD37 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q50), Schedules!A51:B56, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P50)=0,\"\", IF(F50=\"Early Replacement\",(Calculations!Y37*0.15),IF(F50=\"Replace on Burnout\",(Calculations!Z37*0.15))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F51=\"Early Replacement\", IFERROR(VLOOKUP(G51, Lookups!B74:D256, 2, FALSE), 0), IF(F51=\"Replace on Burnout\", IFERROR(VLOOKUP(G51, Lookups!B74:D256, 3, FALSE), 0), IF(E51=\"User Defined\", IFERROR(VLOOKUP(G51, Lookups!B247:C280, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J51=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J51,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P51)=0,\"\", _xlfn.IFNA(K51 * (1 - VLOOKUP(TRIM(Q51), Schedules!$A$18:$B$23, 2, FALSE)), K51))","v":""},{"$f":"IF(COUNTA(P51)=0,\"\",IFERROR(IF(F51=\"Replace on Burnout\", Calculations!Z38 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q51), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F51=\"Early Replacement\", Calculations!Y38 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q51), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P51)=0,\"\",IF(D51=\"Exterior\", 0,IF(F51=\"Early Replacement\",Calculations!AC38 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q51), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F51=\"Replace on Burnout\",Calculations!AD38 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q51), Schedules!A52:B57, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P51)=0,\"\", IF(F51=\"Early Replacement\",(Calculations!Y38*0.15),IF(F51=\"Replace on Burnout\",(Calculations!Z38*0.15))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F52=\"Early Replacement\", IFERROR(VLOOKUP(G52, Lookups!B75:D257, 2, FALSE), 0), IF(F52=\"Replace on Burnout\", IFERROR(VLOOKUP(G52, Lookups!B75:D257, 3, FALSE), 0), IF(E52=\"User Defined\", IFERROR(VLOOKUP(G52, Lookups!B248:C281, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J52=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J52,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P52)=0,\"\", _xlfn.IFNA(K52 * (1 - VLOOKUP(TRIM(Q52), Schedules!$A$18:$B$23, 2, FALSE)), K52))","v":""},{"$f":"IF(COUNTA(P52)=0,\"\",IFERROR(IF(F52=\"Replace on Burnout\", Calculations!Z39 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q52), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F52=\"Early Replacement\", Calculations!Y39 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q52), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P52)=0,\"\",IF(D52=\"Exterior\", 0,IF(F52=\"Early Replacement\",Calculations!AC39 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q52), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F52=\"Replace on Burnout\",Calculations!AD39 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q52), Schedules!A53:B58, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P52)=0,\"\", IF(F52=\"Early Replacement\",(Calculations!Y39*0.15),IF(F52=\"Replace on Burnout\",(Calculations!Z39*0.15))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F53=\"Early Replacement\", IFERROR(VLOOKUP(G53, Lookups!B76:D258, 2, FALSE), 0), IF(F53=\"Replace on Burnout\", IFERROR(VLOOKUP(G53, Lookups!B76:D258, 3, FALSE), 0), IF(E53=\"User Defined\", IFERROR(VLOOKUP(G53, Lookups!B249:C282, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J53=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J53,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P53)=0,\"\", _xlfn.IFNA(K53 * (1 - VLOOKUP(TRIM(Q53), Schedules!$A$18:$B$23, 2, FALSE)), K53))","v":""},{"$f":"IF(COUNTA(P53)=0,\"\",IFERROR(IF(F53=\"Replace on Burnout\", Calculations!Z40 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q53), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F53=\"Early Replacement\", Calculations!Y40 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q53), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P53)=0,\"\",IF(D53=\"Exterior\", 0,IF(F53=\"Early Replacement\",Calculations!AC40 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q53), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F53=\"Replace on Burnout\",Calculations!AD40 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q53), Schedules!A54:B59, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P53)=0,\"\", IF(F53=\"Early Replacement\",(Calculations!Y40*0.15),IF(F53=\"Replace on Burnout\",(Calculations!Z40*0.15))))","v":""},null,null," "]
[null,null,null,null,null,null,null,{"$f":"IF(F54=\"Early Replacement\", IFERROR(VLOOKUP(G54, Lookups!B77:D259, 2, FALSE), 0), IF(F54=\"Replace on Burnout\", IFERROR(VLOOKUP(G54, Lookups!B77:D259, 3, FALSE), 0), IF(E54=\"User Defined\", IFERROR(VLOOKUP(G54, Lookups!B250:C283, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J54=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J54,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P54)=0,\"\", _xlfn.IFNA(K54 * (1 - VLOOKUP(TRIM(Q54), Schedules!$A$18:$B$23, 2, FALSE)), K54))","v":""},{"$f":"IF(COUNTA(P54)=0,\"\",IFERROR(IF(F54=\"Replace on Burnout\", Calculations!Z41 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q54), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F54=\"Early Replacement\", Calculations!Y41 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q54), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P54)=0,\"\",IF(D54=\"Exterior\", 0,IF(F54=\"Early Replacement\",Calculations!AC41 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q54), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F54=\"Replace on Burnout\",Calculations!AD41 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q54), Schedules!A55:B60, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P54)=0,\"\", IF(F54=\"Early Replacement\",(Calculations!Y41*0.15),IF(F54=\"Replace on Burnout\",(Calculations!Z41*0.15))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F55=\"Early Replacement\", IFERROR(VLOOKUP(G55, Lookups!B78:D260, 2, FALSE), 0), IF(F55=\"Replace on Burnout\", IFERROR(VLOOKUP(G55, Lookups!B78:D260, 3, FALSE), 0), IF(E55=\"User Defined\", IFERROR(VLOOKUP(G55, Lookups!B251:C284, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J55=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J55,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P55)=0,\"\", _xlfn.IFNA(K55 * (1 - VLOOKUP(TRIM(Q55), Schedules!$A$18:$B$23, 2, FALSE)), K55))","v":""},{"$f":"IF(COUNTA(P55)=0,\"\",IFERROR(IF(F55=\"Replace on Burnout\", Calculations!Z42 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q55), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F55=\"Early Replacement\", Calculations!Y42 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q55), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P55)=0,\"\",IF(D55=\"Exterior\", 0,IF(F55=\"Early Replacement\",Calculations!AC42 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q55), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F55=\"Replace on Burnout\",Calculations!AD42 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q55), Schedules!A56:B61, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P55)=0,\"\", IF(F55=\"Early Replacement\",(Calculations!Y42*0.15),IF(F55=\"Replace on Burnout\",(Calculations!Z42*0.15))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F56=\"Early Replacement\", IFERROR(VLOOKUP(G56, Lookups!B79:D261, 2, FALSE), 0), IF(F56=\"Replace on Burnout\", IFERROR(VLOOKUP(G56, Lookups!B79:D261, 3, FALSE), 0), IF(E56=\"User Defined\", IFERROR(VLOOKUP(G56, Lookups!B252:C285, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J56=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J56,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P56)=0,\"\", _xlfn.IFNA(K56 * (1 - VLOOKUP(TRIM(Q56), Schedules!$A$18:$B$23, 2, FALSE)), K56))","v":""},{"$f":"IF(COUNTA(P56)=0,\"\",IFERROR(IF(F56=\"Replace on Burnout\", Calculations!Z43 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q56), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F56=\"Early Replacement\", Calculations!Y43 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q56), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P56)=0,\"\",IF(D56=\"Exterior\", 0,IF(F56=\"Early Replacement\",Calculations!AC43 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q56), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F56=\"Replace on Burnout\",Calculations!AD43 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q56), Schedules!A57:B62, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P56)=0,\"\", IF(F56=\"Early Replacement\",(Calculations!Y43*0.15),IF(F56=\"Replace on Burnout\",(Calculations!Z43*0.15))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F57=\"Early Replacement\", IFERROR(VLOOKUP(G57, Lookups!B80:D262, 2, FALSE), 0), IF(F57=\"Replace on Burnout\", IFERROR(VLOOKUP(G57, Lookups!B80:D262, 3, FALSE), 0), IF(E57=\"User Defined\", IFERROR(VLOOKUP(G57, Lookups!B253:C286, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J57=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J57,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P57)=0,\"\", _xlfn.IFNA(K57 * (1 - VLOOKUP(TRIM(Q57), Schedules!$A$18:$B$23, 2, FALSE)), K57))","v":""},{"$f":"IF(COUNTA(P57)=0,\"\",IFERROR(IF(F57=\"Replace on Burnout\", Calculations!Z44 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q57), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F57=\"Early Replacement\", Calculations!Y44 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q57), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P57)=0,\"\",IF(D57=\"Exterior\", 0,IF(F57=\"Early Replacement\",Calculations!AC44 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q57), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F57=\"Replace on Burnout\",Calculations!AD44 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q57), Schedules!A58:B63, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P57)=0,\"\", IF(F57=\"Early Replacement\",(Calculations!Y44*0.15),IF(F57=\"Replace on Burnout\",(Calculations!Z44*0.15))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F58=\"Early Replacement\", IFERROR(VLOOKUP(G58, Lookups!B81:D263, 2, FALSE), 0), IF(F58=\"Replace on Burnout\", IFERROR(VLOOKUP(G58, Lookups!B81:D263, 3, FALSE), 0), IF(E58=\"User Defined\", IFERROR(VLOOKUP(G58, Lookups!B254:C287, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J58=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J58,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P58)=0,\"\", _xlfn.IFNA(K58 * (1 - VLOOKUP(TRIM(Q58), Schedules!$A$18:$B$23, 2, FALSE)), K58))","v":""},{"$f":"IF(COUNTA(P58)=0,\"\",IFERROR(IF(F58=\"Replace on Burnout\", Calculations!Z45 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q58), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F58=\"Early Replacement\", Calculations!Y45 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q58), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P58)=0,\"\",IF(D58=\"Exterior\", 0,IF(F58=\"Early Replacement\",Calculations!AC45 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q58), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F58=\"Replace on Burnout\",Calculations!AD45 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q58), Schedules!A59:B64, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P58)=0,\"\", IF(F58=\"Early Replacement\",(Calculations!Y45*0.15),IF(F58=\"Replace on Burnout\",(Calculations!Z45*0.15))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F59=\"Early Replacement\", IFERROR(VLOOKUP(G59, Lookups!B82:D264, 2, FALSE), 0), IF(F59=\"Replace on Burnout\", IFERROR(VLOOKUP(G59, Lookups!B82:D264, 3, FALSE), 0), IF(E59=\"User Defined\", IFERROR(VLOOKUP(G59, Lookups!B255:C288, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J59=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J59,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P59)=0,\"\", _xlfn.IFNA(K59 * (1 - VLOOKUP(TRIM(Q59), Schedules!$A$18:$B$23, 2, FALSE)), K59))","v":""},{"$f":"IF(COUNTA(P59)=0,\"\",IFERROR(IF(F59=\"Replace on Burnout\", Calculations!Z46 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q59), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F59=\"Early Replacement\", Calculations!Y46 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q59), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P59)=0,\"\",IF(D59=\"Exterior\", 0,IF(F59=\"Early Replacement\",Calculations!AC46 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q59), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F59=\"Replace on Burnout\",Calculations!AD46 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q59), Schedules!A60:B65, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P59)=0,\"\", IF(F59=\"Early Replacement\",(Calculations!Y46*0.15),IF(F59=\"Replace on Burnout\",(Calculations!Z46*0.15))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F60=\"Early Replacement\", IFERROR(VLOOKUP(G60, Lookups!B83:D265, 2, FALSE), 0), IF(F60=\"Replace on Burnout\", IFERROR(VLOOKUP(G60, Lookups!B83:D265, 3, FALSE), 0), IF(E60=\"User Defined\", IFERROR(VLOOKUP(G60, Lookups!B256:C289, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J60=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J60,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P60)=0,\"\", _xlfn.IFNA(K60 * (1 - VLOOKUP(TRIM(Q60), Schedules!$A$18:$B$23, 2, FALSE)), K60))","v":""},{"$f":"IF(COUNTA(P60)=0,\"\",IFERROR(IF(F60=\"Replace on Burnout\", Calculations!Z47 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q60), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F60=\"Early Replacement\", Calculations!Y47 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q60), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P60)=0,\"\",IF(D60=\"Exterior\", 0,IF(F60=\"Early Replacement\",Calculations!AC47 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q60), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F60=\"Replace on Burnout\",Calculations!AD47 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q60), Schedules!A61:B66, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P60)=0,\"\", IF(F60=\"Early Replacement\",(Calculations!Y47*0.15),IF(F60=\"Replace on Burnout\",(Calculations!Z47*0.15))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F61=\"Early Replacement\", IFERROR(VLOOKUP(G61, Lookups!B84:D266, 2, FALSE), 0), IF(F61=\"Replace on Burnout\", IFERROR(VLOOKUP(G61, Lookups!B84:D266, 3, FALSE), 0), IF(E61=\"User Defined\", IFERROR(VLOOKUP(G61, Lookups!B257:C290, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J61=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J61,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P61)=0,\"\", _xlfn.IFNA(K61 * (1 - VLOOKUP(TRIM(Q61), Schedules!$A$18:$B$23, 2, FALSE)), K61))","v":""},{"$f":"IF(COUNTA(P61)=0,\"\",IFERROR(IF(F61=\"Replace on Burnout\", Calculations!Z48 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q61), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F61=\"Early Replacement\", Calculations!Y48 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q61), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P61)=0,\"\",IF(D61=\"Exterior\", 0,IF(F61=\"Early Replacement\",Calculations!AC48 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q61), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F61=\"Replace on Burnout\",Calculations!AD48 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q61), Schedules!A62:B67, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P61)=0,\"\", IF(F61=\"Early Replacement\",(Calculations!Y48*0.15),IF(F61=\"Replace on Burnout\",(Calculations!Z48*0.15))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F62=\"Early Replacement\", IFERROR(VLOOKUP(G62, Lookups!B85:D267, 2, FALSE), 0), IF(F62=\"Replace on Burnout\", IFERROR(VLOOKUP(G62, Lookups!B85:D267, 3, FALSE), 0), IF(E62=\"User Defined\", IFERROR(VLOOKUP(G62, Lookups!B258:C291, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J62=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J62,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P62)=0,\"\", _xlfn.IFNA(K62 * (1 - VLOOKUP(TRIM(Q62), Schedules!$A$18:$B$23, 2, FALSE)), K62))","v":""},{"$f":"IF(COUNTA(P62)=0,\"\",IFERROR(IF(F62=\"Replace on Burnout\", Calculations!Z49 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q62), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F62=\"Early Replacement\", Calculations!Y49 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q62), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P62)=0,\"\",IF(D62=\"Exterior\", 0,IF(F62=\"Early Replacement\",Calculations!AC49 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q62), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F62=\"Replace on Burnout\",Calculations!AD49 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q62), Schedules!A63:B68, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P62)=0,\"\", IF(F62=\"Early Replacement\",(Calculations!Y49*0.15),IF(F62=\"Replace on Burnout\",(Calculations!Z49*0.15))))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(F63=\"Early Replacement\", IFERROR(VLOOKUP(G63, Lookups!B86:D268, 2, FALSE), 0), IF(F63=\"Replace on Burnout\", IFERROR(VLOOKUP(G63, Lookups!B86:D268, 3, FALSE), 0), IF(E63=\"User Defined\", IFERROR(VLOOKUP(G63, Lookups!B259:C292, 2, FALSE), 0), 0)))","v":0},null,null,{"$f":"IF(J63=\"\",\"\",INDEX(Schedules!$B$5:$B$14,MATCH(J63,Schedules!$A$5:$A$14,0),))","v":""},null,null,null,null,null,null,{"$f":"IF(COUNTA(P63)=0,\"\", _xlfn.IFNA(K63 * (1 - VLOOKUP(TRIM(Q63), Schedules!$A$18:$B$23, 2, FALSE)), K63))","v":""},{"$f":"IF(COUNTA(P63)=0,\"\",IFERROR(IF(F63=\"Replace on Burnout\", Calculations!Z50 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q63), Schedules!$A$18:$B$23, 2, FALSE), 0)), IF(F63=\"Early Replacement\", Calculations!Y50 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q63), Schedules!$A$18:$B$23, 2, FALSE), 0)),0)),0))","v":""},{"$f":"IF(COUNTA(P63)=0,\"\",IF(D63=\"Exterior\", 0,IF(F63=\"Early Replacement\",Calculations!AC50 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q63), Schedules!$A$18:$B$23, 2, FALSE), 0)),IF(F63=\"Replace on Burnout\",Calculations!AD50 * (1 - _xlfn.IFNA(VLOOKUP(TRIM(Q63), Schedules!A64:B69, 2, FALSE), 0)),0))))","v":""},{"$f":"IF(COUNTA(P63)=0,\"\", IF(F63=\"Early Replacement\",(Calculations!Y50*0.15),IF(F63=\"Replace on Burnout\",(Calculations!Z50*0.15))))","v":""}]
[null,null,"NOTE:  Rebate is $.15/kWh and $250 per kW reduction.  Rebate will not exceed 50% of the installed job cost. \nRebate will not exceed 100% of installed cost for multi-family, schools, non-profit, and governmental agencies."]
[null,null,"Installed Job Cost:"]
[null,null,null,null,null,null,"Contractor Name:",null,null,null,null,null,null,"Phone:"]
[null,null,"Estimated Annual kWh Savings:",{"$f":"SUM(S17:S63)","v":0}]
[null,null,"Estimated Annual $ Savings:",{"$f":"D67*N10","v":0}]
[null,null,"Interior Lighting Project Cost",{"$f":"D65*(D71/SUM(S17:S63))","v":{"$error":"#DIV/0!"}}]
[null,null,"Interior kW Reduction",{"$f":"SUM(T17:T63)","v":0}]
[null,null,"Interior Lighting kWh Savings",{"$f":"SUMIF(D17:D63, \"Interior\",S17:S63)","v":0}]
[null,null,"Exterior Lighting Project Cost",{"$f":"D65*(D73/SUM(S17:S63))","v":{"$error":"#DIV/0!"}}]
[null,null,"Exterior kWh  Savings",{"$f":"SUMIF(D17:D63, \"Exterior\",S17:S63)","v":0}]
[null,null,"Estimated kWh Rebate:",{"$f":"SUM(U17:U63)","v":0}]
[null,null,"Estimated kW Reduction:",{"$f":"SUM(T17:T63)","v":0}]
[null,null,"Estimated kW Reduction Rebate:",{"$f":"D75*250","v":0}]
[null,null,"Estimated Total Rebate:",{"$f":"MIN(D74+D76,D65*N8)","v":0}]
[null,null,"Estimated Payback (Yrs):",{"$f":"(D65-D77)/D68","v":{"$error":"#DIV/0!"}}]
[null,null,"Weighted Ave. Measure Life:",{"$f":"SUM(Calculations!AH4:AH38)","v":0}]
[null,null,"Total Est. kW Demand Reduction:",{"$f":"SUM(T17:T63)","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Fluorescent"]
[null,null,"Incandescent"]
[null,null,"HID"]
[null,null,"LED"]
[null,null,"Other"]
[null,null,"Metal Halide"]
[null,null,"Mercury Vapor"]
[null,null,"Induction"]

{"sheet":"Calculations","index":2,"n_rows":38,"n_cols":34,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
[]
[]
[{"$f":"'Project Details'!C16","v":"Fixture Location"},{"$f":"'Project Details'!E16","v":"Fixture Type Before Retrofit"},{"$f":"'Project Details'!G16","v":"Fixture Before Retrofit"},{"$f":"'Project Details'!H16","v":"Baseline Wattage Per Fixture Before Retrofit"},{"$f":"'Project Details'!I16","v":"# Fixtures Before Retrofit"},null,null,{"$f":"'Project Details'!K16","v":"Annual Hours of Operation Before Retrofit"},"Annual kWh Before Retrofit",{"$f":"'Project Details'!L16","v":"Fixture Type After Retrofit"},{"$f":"'Project Details'!M16","v":"Fixture After Retrofit"},{"$f":"'Project Details'!O16","v":"Watts Per Fixture After Retrofit"},{"$f":"'Project Details'!P16","v":"# Fixtures After Retrofit"},null,null,{"$f":"'Project Details'!R16","v":"Annual Hours of Operation After Retrofit"},"Annual kWh After Retrofit",null,null,null,null,"Total Rebate","unadjusted kWh Reduction","Interactive Effects","adjusted Early Replacement kWh Reduction","adjusted ROB kWh Reduction","Coincident Demand Factor","Interactive Effects","Early Replacement kW Demand Reduction","ROB kWDemand Reduction","Measure Life","Wattage Reduction","% of Total Watt Reduction","Weighted life"]
[{"$f":"'Project Details'!C17","v":0},{"$f":"'Project Details'!E17","v":0},{"$f":"'Project Details'!G17","v":0},{"$f":"'Project Details'!H17","v":0},{"$f":"'Project Details'!I17","v":0},null,null,{"$f":"'Project Details'!K17","v":""},{"$f":"IF(ISERROR(D4*E4*H4/1000),0,D4*E4*H4/1000)","v":0},{"$f":"'Project Details'!L17","v":0},{"$f":"'Project Details'!M17","v":0},{"$f":"'Project Details'!O17","v":0},{"$f":"'Project Details'!P17","v":0},null,null,{"$f":"'Project Details'!R17","v":""},{"$f":"IF(ISERROR(L4*M4*P4/1000),0,L4*M4*P4/1000)","v":0},null,null,null,null,{"$f":"IF(ISERROR(Y4*0.2),0,Y4*0.15)","v":0},{"$f":"IF(ISERROR(I4-Q4),0,I4-Q4)","v":0},{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE))","v":0},{"$f":"IF(ISERROR(W4*X4),0,W4*X4)","v":0},{"$f":"Y4*0.5","v":0},{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE))","v":0},{"$f":"IF(ISERROR((AF4/1000)*AA4*AB4),0,(AF4/1000)*AA4*AB4)","v":0},{"$f":"AC4*0.5","v":0},{"$f":"IF(IF(ISERROR(VLOOKUP(J4,FIXTURE_TYPE,2,FALSE)),0,VLOOKUP(J4,FIXTURE_TYPE,2,FALSE))>15,15,IF(ISERROR(VLOOKUP(J4,FIXTURE_TYPE,2,FALSE)),0,VLOOKUP(J4,FIXTURE_TYPE,2,FALSE)))","v":0},{"$f":"IF(ISERROR(IF(S4=\"Lamp\",(D4*G4)-(L4*O4),(D4*E4)-(L4*M4))),0,IF(S4=\"Lamp\",(D4*G4)-(L4*O4),(D4*E4)-(L4*M4)))","v":0},{"$f":"IF(ISERROR(AF4/SUM($AF$4:$AF$38)),0,AF4/SUM($AF$4:$AF$38))","v":0},{"$f":"IF(ISERROR(AE4*AG4),0,AE4*AG4)","v":0}]
[{"$f":"'Project Details'!C18","v":0},{"$f":"'Project Details'!E18","v":0},{"$f":"'Project Details'!G18","v":0},{"$f":"'Project Details'!H18","v":0},{"$f":"'Project Details'!I18","v":0},null,null,{"$f":"'Project Details'!K18","v":""},{"$f":"IF(ISERROR(D5*E5*H5/1000),0,D5*E5*H5/1000)","v":0},{"$f":"'Project Details'!L18","v":0},{"$f":"'Project Details'!M18","v":0},{"$f":"'Project Details'!O18","v":0},{"$f":"'Project Details'!P18","v":0},null,null,{"$f":"'Project Details'!R18","v":""},{"$f":"IF(ISERROR(L5*M5*P5/1000),0,L5*M5*P5/1000)","v":0},null,null,null,null,{"$f":"IF(ISERROR(Y5*0.2),0,Y5*0.15)","v":0},{"$f":"IF(ISERROR(I5-Q5),0,I5-Q5)","v":0},{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE))","v":0},0,{"$f":"Y5*0.5","v":0},{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE))","v":0},0,{"$f":"AC5*0.5","v":0},0,0,{"$f":"IF(ISERROR(AF5/SUM($AF$4:$AF$38)),0,AF5/SUM($AF$4:$AF$38))","v":0},0]
[{"$f":"'Project Details'!C19","v":0},{"$f":"'Project Details'!E19","v":0},{"$f":"'Project Details'!G19","v":0},{"$f":"'Project Details'!H19","v":0},{"$f":"'Project Details'!I19","v":0},null,null,{"$f":"'Project Details'!K19","v":""},0,{"$f":"'Project Details'!L19","v":0},{"$f":"'Project Details'!M19","v":0},{"$f":"'Project Details'!O19","v":0},{"$f":"'Project Details'!P19","v":0},null,null,{"$f":"'Project Details'!R19","v":""},0,null,null,null,null,0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE))","v":0},0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE))","v":0},0,0,0,0,0,0]
[{"$f":"'Project Details'!C20","v":0},{"$f":"'Project Details'!E20","v":0},{"$f":"'Project Details'!G20","v":0},{"$f":"'Project Details'!H20","v":0},{"$f":"'Project Details'!I20","v":0},null,null,{"$f":"'Project Details'!K20","v":""},0,{"$f":"'Project Details'!L20","v":0},{"$f":"'Project Details'!M20","v":0},{"$f":"'Project Details'!O20","v":0},{"$f":"'Project Details'!P20","v":0},null,null,{"$f":"'Project Details'!R20","v":""},0,null,null,null,null,0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE))","v":0},0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE))","v":0},0,0,0,0,0,0]
[{"$f":"'Project Details'!C21","v":0},{"$f":"'Project Details'!E21","v":0},{"$f":"'Project Details'!G21","v":0},{"$f":"'Project Details'!H21","v":0},{"$f":"'Project Details'!I21","v":0},null,null,{"$f":"'Project Details'!K21","v":""},0,{"$f":"'Project Details'!L21","v":0},{"$f":"'Project Details'!M21","v":0},{"$f":"'Project Details'!O21","v":0},{"$f":"'Project Details'!P21","v":0},null,null,{"$f":"'Project Details'!R21","v":""},0,null,null,null,null,0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE))","v":0},0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE))","v":0},0,0,0,0,0,0]
[{"$f":"'Project Details'!C22","v":0},{"$f":"'Project Details'!E22","v":0},{"$f":"'Project Details'!G22","v":0},{"$f":"'Project Details'!H22","v":0},{"$f":"'Project Details'!I22","v":0},null,null,{"$f":"'Project Details'!K22","v":""},0,{"$f":"'Project Details'!L22","v":0},{"$f":"'Project Details'!M22","v":0},{"$f":"'Project Details'!O22","v":0},{"$f":"'Project Details'!P22","v":0},null,null,{"$f":"'Project Details'!R22","v":""},0,null,null,null,null,0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE))","v":0},0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE))","v":0},0,0,0,0,0,0]
[{"$f":"'Project Details'!C23","v":0},{"$f":"'Project Details'!E23","v":0},{"$f":"'Project Details'!G23","v":0},{"$f":"'Project Details'!H23","v":0},{"$f":"'Project Details'!I23","v":0},null,null,{"$f":"'Project Details'!K23","v":""},0,{"$f":"'Project Details'!L23","v":0},{"$f":"'Project Details'!M23","v":0},{"$f":"'Project Details'!O23","v":0},{"$f":"'Project Details'!P23","v":0},null,null,{"$f":"'Project Details'!R23","v":""},0,null,null,null,null,0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE))","v":0},0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE))","v":0},0,0,0,0,0,0]
[{"$f":"'Project Details'!C24","v":0},{"$f":"'Project Details'!E24","v":0},{"$f":"'Project Details'!G24","v":0},{"$f":"'Project Details'!H24","v":0},{"$f":"'Project Details'!I24","v":0},null,null,{"$f":"'Project Details'!K24","v":""},0,{"$f":"'Project Details'!L24","v":0},{"$f":"'Project Details'!M24","v":0},{"$f":"'Project Details'!O24","v":0},{"$f":"'Project Details'!P24","v":0},null,null,{"$f":"'Project Details'!R24","v":""},0,null,null,null,null,0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE))","v":0},0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE))","v":0},0,0,0,0,0,0]
[{"$f":"'Project Details'!C25","v":0},{"$f":"'Project Details'!E25","v":0},{"$f":"'Project Details'!G25","v":0},{"$f":"'Project Details'!H25","v":0},{"$f":"'Project Details'!I25","v":0},null,null,{"$f":"'Project Details'!K25","v":""},0,{"$f":"'Project Details'!L25","v":0},{"$f":"'Project Details'!M25","v":0},{"$f":"'Project Details'!O25","v":0},{"$f":"'Project Details'!P25","v":0},null,null,{"$f":"'Project Details'!R25","v":""},0,null,null,null,null,0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE))","v":0},0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE))","v":0},0,0,0,0,0,0]
[{"$f":"'Project Details'!C26","v":0},{"$f":"'Project Details'!E26","v":0},{"$f":"'Project Details'!G26","v":0},{"$f":"'Project Details'!H26","v":0},{"$f":"'Project Details'!I26","v":0},null,null,{"$f":"'Project Details'!K26","v":""},0,{"$f":"'Project Details'!L26","v":0},{"$f":"'Project Details'!M26","v":0},{"$f":"'Project Details'!O26","v":0},{"$f":"'Project Details'!P26","v":0},null,null,{"$f":"'Project Details'!R26","v":""},0,null,null,null,null,0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE))","v":0},0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE))","v":0},0,0,0,0,0,0]
[{"$f":"'Project Details'!C27","v":0},{"$f":"'Project Details'!E27","v":0},{"$f":"'Project Details'!G27","v":0},{"$f":"'Project Details'!H27","v":0},{"$f":"'Project Details'!I27","v":0},null,null,{"$f":"'Project Details'!K27","v":""},0,{"$f":"'Project Details'!L27","v":0},{"$f":"'Project Details'!M27","v":0},{"$f":"'Project Details'!O27","v":0},{"$f":"'Project Details'!P27","v":0},null,null,{"$f":"'Project Details'!R27","v":""},0,null,null,null,null,0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE))","v":0},0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE))","v":0},0,0,0,0,0,0]
[{"$f":"'Project Details'!C28","v":0},{"$f":"'Project Details'!E28","v":0},{"$f":"'Project Details'!G28","v":0},{"$f":"'Project Details'!H28","v":0},{"$f":"'Project Details'!I28","v":0},null,null,{"$f":"'Project Details'!K28","v":""},0,{"$f":"'Project Details'!L28","v":0},{"$f":"'Project Details'!M28","v":0},{"$f":"'Project Details'!O28","v":0},{"$f":"'Project Details'!P28","v":0},null,null,{"$f":"'Project Details'!R28","v":""},0,null,null,null,null,0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE))","v":0},0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE))","v":0},0,0,0,0,0,0]
[{"$f":"'Project Details'!C29","v":0},{"$f":"'Project Details'!E29","v":0},{"$f":"'Project Details'!G29","v":0},{"$f":"'Project Details'!H29","v":0},{"$f":"'Project Details'!I29","v":0},null,null,{"$f":"'Project Details'!K29","v":""},0,{"$f":"'Project Details'!L29","v":0},{"$f":"'Project Details'!M29","v":0},{"$f":"'Project Details'!O29","v":0},{"$f":"'Project Details'!P29","v":0},null,null,{"$f":"'Project Details'!R29","v":""},0,null,null,null,null,0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE))","v":0},0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE))","v":0},0,0,0,0,0,0]
[{"$f":"'Project Details'!C30","v":0},{"$f":"'Project Details'!E30","v":0},{"$f":"'Project Details'!G30","v":0},{"$f":"'Project Details'!H30","v":0},{"$f":"'Project Details'!I30","v":0},null,null,{"$f":"'Project Details'!K30","v":""},0,{"$f":"'Project Details'!L30","v":0},{"$f":"'Project Details'!M30","v":0},{"$f":"'Project Details'!O30","v":0},{"$f":"'Project Details'!P30","v":0},null,null,{"$f":"'Project Details'!R30","v":""},0,null,null,null,null,0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE))","v":0},0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE))","v":0},0,0,0,0,0,0]
[{"$f":"'Project Details'!C31","v":0},{"$f":"'Project Details'!E31","v":0},{"$f":"'Project Details'!G31","v":0},{"$f":"'Project Details'!H31","v":0},{"$f":"'Project Details'!I31","v":0},null,null,{"$f":"'Project Details'!K31","v":""},0,{"$f":"'Project Details'!L31","v":0},{"$f":"'Project Details'!M31","v":0},{"$f":"'Project Details'!O31","v":0},{"$f":"'Project Details'!P31","v":0},null,null,{"$f":"'Project Details'!R31","v":""},0,null,null,null,null,0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE))","v":0},0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE))","v":0},0,0,0,0,0,0]
[{"$f":"'Project Details'!C32","v":0},{"$f":"'Project Details'!E32","v":0},{"$f":"'Project Details'!G32","v":0},{"$f":"'Project Details'!H32","v":0},{"$f":"'Project Details'!I32","v":0},null,null,{"$f":"'Project Details'!K32","v":""},0,{"$f":"'Project Details'!L32","v":0},{"$f":"'Project Details'!M32","v":0},{"$f":"'Project Details'!O32","v":0},{"$f":"'Project Details'!P32","v":0},null,null,{"$f":"'Project Details'!R32","v":""},0,null,null,null,null,0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE))","v":0},0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE))","v":0},0,0,0,0,0,0]
[{"$f":"'Project Details'!C33","v":0},{"$f":"'Project Details'!E33","v":0},{"$f":"'Project Details'!G33","v":0},{"$f":"'Project Details'!H33","v":0},{"$f":"'Project Details'!I33","v":0},null,null,{"$f":"'Project Details'!K33","v":""},0,{"$f":"'Project Details'!L33","v":0},{"$f":"'Project Details'!M33","v":0},{"$f":"'Project Details'!O33","v":0},{"$f":"'Project Details'!P33","v":0},null,null,{"$f":"'Project Details'!R33","v":""},0,null,null,null,null,0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE))","v":0},0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE))","v":0},0,0,0,0,0,0]
[{"$f":"'Project Details'!C34","v":0},{"$f":"'Project Details'!E34","v":0},{"$f":"'Project Details'!G34","v":0},{"$f":"'Project Details'!H34","v":0},{"$f":"'Project Details'!I34","v":0},null,null,{"$f":"'Project Details'!K34","v":""},0,{"$f":"'Project Details'!L34","v":0},{"$f":"'Project Details'!M34","v":0},{"$f":"'Project Details'!O34","v":0},{"$f":"'Project Details'!P34","v":0},null,null,{"$f":"'Project Details'!R34","v":""},0,null,null,null,null,0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE))","v":0},0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE))","v":0},0,0,0,0,0,0]
[{"$f":"'Project Details'!C35","v":0},{"$f":"'Project Details'!E35","v":0},{"$f":"'Project Details'!G35","v":0},{"$f":"'Project Details'!H35","v":0},{"$f":"'Project Details'!I35","v":0},null,null,{"$f":"'Project Details'!K35","v":""},0,{"$f":"'Project Details'!L35","v":0},{"$f":"'Project Details'!M35","v":0},{"$f":"'Project Details'!O35","v":0},{"$f":"'Project Details'!P35","v":0},null,null,{"$f":"'Project Details'!R35","v":""},0,null,null,null,null,0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE))","v":0},0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE))","v":0},0,0,0,0,0,0]
[{"$f":"'Project Details'!C36","v":0},{"$f":"'Project Details'!E36","v":0},{"$f":"'Project Details'!G36","v":0},{"$f":"'Project Details'!H36","v":0},{"$f":"'Project Details'!I36","v":0},null,null,{"$f":"'Project Details'!K36","v":""},0,{"$f":"'Project Details'!L36","v":0},{"$f":"'Project Details'!M36","v":0},{"$f":"'Project Details'!O36","v":0},{"$f":"'Project Details'!P36","v":0},null,null,{"$f":"'Project Details'!R36","v":""},0,null,null,null,null,0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE))","v":0},0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE))","v":0},0,0,0,0,0,0]
[{"$f":"'Project Details'!C37","v":0},{"$f":"'Project Details'!E37","v":0},{"$f":"'Project Details'!G37","v":0},{"$f":"'Project Details'!H37","v":0},{"$f":"'Project Details'!I37","v":0},null,null,{"$f":"'Project Details'!K37","v":""},0,{"$f":"'Project Details'!L37","v":0},{"$f":"'Project Details'!M37","v":0},{"$f":"'Project Details'!O37","v":0},{"$f":"'Project Details'!P37","v":0},null,null,{"$f":"'Project Details'!R37","v":""},0,null,null,null,null,0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE))","v":0},0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE))","v":0},0,0,0,0,0,0]
[{"$f":"'Project Details'!C38","v":0},{"$f":"'Project Details'!E38","v":0},{"$f":"'Project Details'!G38","v":0},{"$f":"'Project Details'!H38","v":0},{"$f":"'Project Details'!I38","v":0},null,null,{"$f":"'Project Details'!K38","v":""},0,{"$f":"'Project Details'!L38","v":0},{"$f":"'Project Details'!M38","v":0},{"$f":"'Project Details'!O38","v":0},{"$f":"'Project Details'!P38","v":0},null,null,{"$f":"'Project Details'!R38","v":""},0,null,null,null,null,0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE))","v":0},0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE))","v":0},0,0,0,0,0,0]
[{"$f":"'Project Details'!C39","v":0},{"$f":"'Project Details'!E39","v":0},{"$f":"'Project Details'!G39","v":0},{"$f":"'Project Details'!H39","v":0},{"$f":"'Project Details'!I39","v":0},null,null,{"$f":"'Project Details'!K39","v":""},0,{"$f":"'Project Details'!L39","v":0},{"$f":"'Project Details'!M39","v":0},{"$f":"'Project Details'!O39","v":0},{"$f":"'Project Details'!P39","v":0},null,null,{"$f":"'Project Details'!R39","v":""},0,null,null,null,null,0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE))","v":0},0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE))","v":0},0,0,0,0,0,0]
[{"$f":"'Project Details'!C40","v":0},{"$f":"'Project Details'!E40","v":0},{"$f":"'Project Details'!G40","v":0},{"$f":"'Project Details'!H40","v":0},{"$f":"'Project Details'!I40","v":0},null,null,{"$f":"'Project Details'!K40","v":""},0,{"$f":"'Project Details'!L40","v":0},{"$f":"'Project Details'!M40","v":0},{"$f":"'Project Details'!O40","v":0},{"$f":"'Project Details'!P40","v":0},null,null,{"$f":"'Project Details'!R40","v":""},0,null,null,null,null,0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE))","v":0},0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE))","v":0},0,0,0,0,0,0]
[{"$f":"'Project Details'!C41","v":0},{"$f":"'Project Details'!E41","v":0},{"$f":"'Project Details'!G41","v":0},{"$f":"'Project Details'!H41","v":0},{"$f":"'Project Details'!I41","v":0},null,null,{"$f":"'Project Details'!K41","v":""},0,{"$f":"'Project Details'!L41","v":0},{"$f":"'Project Details'!M41","v":0},{"$f":"'Project Details'!O41","v":0},{"$f":"'Project Details'!P41","v":0},null,null,{"$f":"'Project Details'!R41","v":""},0,null,null,null,null,0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE))","v":0},0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE))","v":0},0,0,0,0,0,0]
[{"$f":"'Project Details'!C42","v":0},{"$f":"'Project Details'!E42","v":0},{"$f":"'Project Details'!G42","v":0},{"$f":"'Project Details'!H42","v":0},{"$f":"'Project Details'!I42","v":0},null,null,{"$f":"'Project Details'!K42","v":""},0,{"$f":"'Project Details'!L42","v":0},{"$f":"'Project Details'!M42","v":0},{"$f":"'Project Details'!O42","v":0},{"$f":"'Project Details'!P42","v":0},null,null,{"$f":"'Project Details'!R42","v":""},0,null,null,null,null,0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE))","v":0},0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE))","v":0},0,0,0,0,0,0]
[{"$f":"'Project Details'!C43","v":0},{"$f":"'Project Details'!E43","v":0},{"$f":"'Project Details'!G43","v":0},{"$f":"'Project Details'!H43","v":0},{"$f":"'Project Details'!I43","v":0},null,null,{"$f":"'Project Details'!K43","v":""},0,{"$f":"'Project Details'!L43","v":0},{"$f":"'Project Details'!M43","v":0},{"$f":"'Project Details'!O43","v":0},{"$f":"'Project Details'!P43","v":0},null,null,{"$f":"'Project Details'!R43","v":""},0,null,null,null,null,0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE))","v":0},0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE))","v":0},0,0,0,0,0,0]
[{"$f":"'Project Details'!C44","v":0},{"$f":"'Project Details'!E44","v":0},{"$f":"'Project Details'!G44","v":0},{"$f":"'Project Details'!H44","v":0},{"$f":"'Project Details'!I44","v":0},null,null,{"$f":"'Project Details'!K44","v":""},0,{"$f":"'Project Details'!L44","v":0},{"$f":"'Project Details'!M44","v":0},{"$f":"'Project Details'!O44","v":0},{"$f":"'Project Details'!P44","v":0},null,null,{"$f":"'Project Details'!R44","v":""},0,null,null,null,null,0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE))","v":0},0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE))","v":0},0,0,0,0,0,0]
[{"$f":"'Project Details'!C45","v":0},{"$f":"'Project Details'!E45","v":0},{"$f":"'Project Details'!G45","v":0},{"$f":"'Project Details'!H45","v":0},{"$f":"'Project Details'!I45","v":0},null,null,{"$f":"'Project Details'!K45","v":""},0,{"$f":"'Project Details'!L45","v":0},{"$f":"'Project Details'!M45","v":0},{"$f":"'Project Details'!O45","v":0},{"$f":"'Project Details'!P45","v":0},null,null,{"$f":"'Project Details'!R45","v":""},0,null,null,null,null,0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE))","v":0},0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE))","v":0},0,0,0,0,0,0]
[{"$f":"'Project Details'!C46","v":0},{"$f":"'Project Details'!E46","v":0},{"$f":"'Project Details'!G46","v":0},{"$f":"'Project Details'!H46","v":0},{"$f":"'Project Details'!I46","v":0},null,null,{"$f":"'Project Details'!K46","v":""},0,{"$f":"'Project Details'!L46","v":0},{"$f":"'Project Details'!M46","v":0},{"$f":"'Project Details'!O46","v":0},{"$f":"'Project Details'!P46","v":0},null,null,{"$f":"'Project Details'!R46","v":""},0,null,null,null,null,0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE))","v":0},0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE))","v":0},0,0,0,0,0,0]
[{"$f":"'Project Details'!C47","v":0},{"$f":"'Project Details'!E47","v":0},{"$f":"'Project Details'!G47","v":0},{"$f":"'Project Details'!H47","v":0},{"$f":"'Project Details'!I47","v":0},null,null,{"$f":"'Project Details'!K47","v":""},0,{"$f":"'Project Details'!L47","v":0},{"$f":"'Project Details'!M47","v":0},{"$f":"'Project Details'!O47","v":0},{"$f":"'Project Details'!P47","v":0},null,null,{"$f":"'Project Details'!R47","v":""},0,null,null,null,null,0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE))","v":0},0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE))","v":0},0,0,0,0,0,0]
[{"$f":"'Project Details'!C48","v":0},{"$f":"'Project Details'!E48","v":0},{"$f":"'Project Details'!G48","v":0},{"$f":"'Project Details'!H48","v":0},{"$f":"'Project Details'!I48","v":0},null,null,{"$f":"'Project Details'!K48","v":""},0,{"$f":"'Project Details'!L48","v":0},{"$f":"'Project Details'!M48","v":0},{"$f":"'Project Details'!O48","v":0},{"$f":"'Project Details'!P48","v":0},null,null,{"$f":"'Project Details'!R48","v":""},0,null,null,null,null,0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE))","v":0},0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE))","v":0},0,0,0,0,0,0]
[{"$f":"'Project Details'!C49","v":0},{"$f":"'Project Details'!E49","v":0},{"$f":"'Project Details'!G49","v":0},{"$f":"'Project Details'!H49","v":0},{"$f":"'Project Details'!I49","v":0},null,null,{"$f":"'Project Details'!K49","v":""},0,{"$f":"'Project Details'!L49","v":0},{"$f":"'Project Details'!M49","v":0},{"$f":"'Project Details'!O49","v":0},{"$f":"'Project Details'!P49","v":0},null,null,{"$f":"'Project Details'!R49","v":""},0,null,null,null,null,0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE))","v":0},0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE))","v":0},0,0,0,0,0,0]
[{"$f":"'Project Details'!C50","v":0},{"$f":"'Project Details'!E50","v":0},{"$f":"'Project Details'!G50","v":0},{"$f":"'Project Details'!H50","v":0},{"$f":"'Project Details'!I50","v":0},null,null,{"$f":"'Project Details'!K50","v":""},0,{"$f":"'Project Details'!L50","v":0},{"$f":"'Project Details'!M50","v":0},{"$f":"'Project Details'!O50","v":0},{"$f":"'Project Details'!P50","v":0},null,null,{"$f":"'Project Details'!R50","v":""},0,null,null,null,null,0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE))","v":0},0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE))","v":0},0,0,0,0,0,0]
[{"$f":"'Project Details'!C51","v":0},{"$f":"'Project Details'!E51","v":0},{"$f":"'Project Details'!G51","v":0},{"$f":"'Project Details'!H51","v":0},{"$f":"'Project Details'!I51","v":0},null,null,{"$f":"'Project Details'!K51","v":""},0,{"$f":"'Project Details'!L51","v":0},{"$f":"'Project Details'!M51","v":0},{"$f":"'Project Details'!O51","v":0},{"$f":"'Project Details'!P51","v":0},null,null,{"$f":"'Project Details'!R51","v":""},0,null,null,null,null,0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,3,FALSE))","v":0},0,0,{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,2,FALSE))","v":0},{"$f":"IF(ISERROR(VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE)),0,VLOOKUP('Project Details'!$L$13,CDF_IE,4,FALSE))","v":0},0,0,0,0,0,0]

{"sheet":"Lookups","index":3,"n_rows":285,"n_cols":15,"rows_kept":285,"cut":false,"hidden":true,"merged":[]}
["ExistingLighitng","ExistingFixtureType2","ExistingFixtureType3","ExistingFixtureType4","ExistingFixtureType5","ExistingFixtureType6","ExistingFixtureType7","ExistingFixtureType8","ExistingFixtureType9","ExistingFixtureType10","ExistingFixtureType11"]
["Fluorescent","T8 4ft Normal Ballast","T8 4ft Low Ballast","T8 4ft High Ballast","T8/T12 All Other Lengths","T5 Lamp","CFL","Metal Halide","High Pressure Sodium","T12 Lamp","User Defined"]
["U-Tube, ES Lamp, EE Mag Ballast","Bi-level Stairwell, Hallway, and Garage Fixture w/ Occ Sensor, 2-lamp T8","Fluorescent, 48\" (1) 32W  T8, BF <0.85","Fluorescent, 48\" (2) 28W  T8, BF >1.1","Fluorescent, 18\" T8 Lamp","Fluorescent, (1) 46\", T5/HO Lamp, NBF","CFL, 10W, Quad, Mag Ballast","Metal Halide, (1) 20W Lamp, Electronic Ballast","High Pressure Sodium, (1) 35W Lamp","Fluorescent, 18\" T12 Lamp",{"$f":"Schedules!A27","v":0}]
["U-Tube, T8 Lamp","Fluorescent, 48\" (1) 25W T8, NBF","Fluorescent, 48\" (2) 25W  T8,  BF <0.85","Fluorescent, 48\" (2) 32W  T8, BF >1.1","Fluorescent, 24\" T8 Lamp","Fluorescent, (2) 46\", T5/HO Lamp, NBF","CFL, 13W, Mag Ballast","Metal Halide, (1) 22W Lamp, Electronic Ballast","High Pressure Sodium, (1) 50W Lamp","Fluorescent, 18\"  (2) T12 Lamps ",{"$f":"Schedules!A28","v":0}]
["U-Tube, 2 Lamps","Fluorescent, 48\" (1) 32W T8, NBF","Fluorescent, 48\" (2) 28W  T8,  BF <0.85","Fluorescent, 48\" (3) 25W  T8, BF >1.1","Fluorescent, 24\" (2) T8 Lamps","Fluorescent, (2) 46\", 54W T5 Lamp, NBF","CFL, 13W, Electronic Ballast","Metal Halide, (1) 39W Lamp, Electronic Ballast","High Pressure Sodium, (1) 70W Lamp","Fluorescent, 24\" T12 Lamp ",{"$f":"Schedules!A29","v":0}]
["U-Tube, 2 ES Lamps, EE Mag Ballast","Fluorescent, 48\" (2) 25W T8, 0.96-1.1","Fluorescent, 48\" (2) 32W  T8,  BF <0.85","Fluorescent, 48\" (3) 28W  T8, BF >1.1","Fluorescent, 24\" (3) T8 Lamps, BF 0.96-1.1","Fluorescent  (3) 46\"  54W T5/HO Lamp","CFL, 13W, Quad, 2-Lamp, Electronic  Ballast","Metal Halide, (2) 39W Lamp, Electronic Ballast","High Pressure Sodium, (1) 100W Lamp","Fluorescent, 24\" (2) T12 Lamps ",{"$f":"Schedules!A30","v":0}]
["U-Tube, 2 T8 Lamps","Fluorescent, 48\" (2) 25W T8, NBF","Fluorescent, 48\" (3) 25W  T8,  BF <0.85","Fluorescent, 48\" (3) 32W  T8, BF >1.1","Fluorescent, 24\" (4) T8 Lamps","Fluorescent  (4) 46\"  54W T5/HO Lamp","CFL, 13W, Quad, 2-Lamp, Mag Ballast","Metal Halide, (1) 50W Lamp, Electronic Ballast","High Pressure Sodium, (1) 150W Lamp","Fluorescent, 24\" (3) T12 Lamps ",{"$f":"Schedules!A31","v":0}]
["Circular Lamp, 6\" Diameter","Fluorescent, 48\" (2) 28W T8, 0.96-1.1","Fluorescent, 48\" (3) 28W  T8,  BF <0.85","Fluorescent, 48\" (4) 25W  T8, BF >1.1","Fluorescent, 36\" (2) T8 Lamps","Fluorescent  (6) 46\"  54W T5/HO Lamp","CFL, 13W, Quad, 3-Lamp Mag Ballast","Metal Halide, (1) 70W Lamp, Electronic Ballast","High Pressure Sodium, (1) 200W Lamp","Fluorescent, 24\" (4) T12 Lamps ",{"$f":"Schedules!A32","v":0}]
["Circular Lamp, 8\" Diameter","Fluorescent, 48\" (2) 28W T8, NBF","Fluorescent, 48\" (3) 32W  T8,  BF <0.85","Fluorescent, 48\" (4) 28W  T8, BF >1.1","Fluorescent, 60\" T8 Lamp, NBF","Fluorescent  (8) 46\"  54W T5 /HO Lamp","CFL, 15W, Quad, Mag Ballast","Metal Halide, (1) 100W Lamp, Electronic Ballast","High Pressure Sodium, (1) 250W Lamp","Fluorescent, 36\" (2) T12 Lamps ",{"$f":"Schedules!A33","v":0}]
["Circular Lamp, 12\" Diameter","Fluorescent, 48\" (2) 32W T8, 0.96-1.1","Fluorescent, 48\" (4) 25W  T8,  BF <0.85","Fluorescent, 48\" (4) 32W  T8, BF >1.1","Fluorescent, 60\", T8 Lamp, HO BF",null,"CFL, 16W, 2D Lamp","Metal Halide, (1) 150W Lamp, Electronic Ballast","High Pressure Sodium, (1) 310W Lamp","Fluorescent, 48\" T12 Lamp ",{"$f":"Schedules!A34","v":0}]
["Circular Lamp, 16\" Diameter","Fluorescent, 48\" (2) 32W T8, NBF","Fluorescent, 48\" (4) 28W  T8,  BF <0.85","Fluorescent, 48\" (6) 32W  T8, BF >1.1","Fluorescent, 60\", (2) T8 Lamps, VHLO BF",null,"CFL, 17W, Quad, Mag Ballast","Metal Halide, (1) 175W Lamp, Electronic Ballast","High Pressure Sodium, (1) 360W Lamp","Fluorescent, 48\" (2) T12 Lamps ",{"$f":"Schedules!A35","v":0}]
["Circular Lamp, 20W","Fluorescent, 48\" (3) 25W T8, 0.96-1.1","Fluorescent, 48\" (4) 32W  T8,  BF <0.85",null,"Fluorescent, 60\", T12 HO (Refrig. Display Case)",null,"CFL, 17W, Quad, 2-Lamp, Mag Ballast","Metal Halide, (1) 200W Lamp, Electronic Ballast","High Pressure Sodium, (1) 400W Lamp","Fluorescent, 48\" (3) T12 Lamps ",{"$f":"Schedules!A36","v":0}]
["Circular Lamp, 22W","Fluorescent, 48\" (3) 25W T8, NBF","Fluorescent, 48\" (6) 32W  T8,  BF <0.85",null,"Fluorescent, 60\" (2) T12 HO (Refrig. Display Case)",null,"CFL, 18W, Quad, Mag Ballast","Metal Halide, (1) 250W Lamp, Electronic Ballast","High Pressure Sodium, (1) 750W Lamp","Fluorescent, 48\" (4) T12 Lamps",{"$f":"Schedules!A37","v":0}]
["Circular Lamp, 32W","Fluorescent, 48\" (3) 28W T8, 0.96-1.1",null,null,"Fluorescent, 60\" (2) T8 Lamps",null,"CFL, 18W, Pin Base","Metal Halide, (1) 320W Lamp, Electronic Ballast","High Pressure Sodium, (1) 1000W Lamp","Fluorescent, 48\" (6) T12 Lamps",{"$f":"Schedules!A38","v":0}]
[null,"Fluorescent, 48\" (3) 28W T8, NBF",null,null,"Fluorescent, 60\" (4) T8 Lamps",null,"CFL, 18W,  Pin Base, Electronic Ballast","Metal Halide, (1) 350W Lamp, Electronic Ballast",null,"Fluorescent, 60\" T12 Lamp ",{"$f":"Schedules!A39","v":0}]
[null,"Fluorescent, 48\" (3) 32W T8, 0.96-1.1",null,null,"Fluorescent, 72\", T12 HO (Refrig. Display Case)",null,"CFL, 18W, Quad, Electronic Ballast","Metal Halide, (1) 400W Lamp, Electronic Ballast",null,"Fluorescent, 60\" T12 HO Lamp ",{"$f":"Schedules!A40","v":0}]
[null,"Fluorescent, 48\" (3) 32W T8, NBF",null,null,"Fluorescent, 72\" (2) T12 HO (Refrig. Display Case)",null,"CFL, 18W, Quad, 2-Lamp, Mag Ballast","Metal Halide, (1) 32W Lamp, Mag Ballast",null,"Fluorescent, 60\" (2) T12 Lamps ",{"$f":"Schedules!A41","v":0}]
[null,"Fluorescent, 48\" (4) 25W T8, 0.96-1.1",null,null,"Fluorescent, 96\" (2) T8 Lamps, BF<0.85",null,"CFL, 18W, Quad, 2-Lamp, Electronic Ballast","Metal Halide, (1) 50W Lamp, Mag Ballast",null,"Fluorescent, 60\" (2) T12 HO Lamps ",{"$f":"Schedules!A42","v":0}]
[null,"Fluorescent, 48\" (4) 25W T8, NBF",null,null,"Fluorescent, 96\" (1) T8 Lamp",null,"CFL, 20W, Quad, Mag Ballast","Metal Halide, (1) 70W Lamp, Mag Ballast",null,"Fluorescent, 60\" (4) T12 Lamps ",{"$f":"Schedules!A43","v":0}]
[null,"Fluorescent, 48\" (4) 28W T8, 0.96-1.1",null,null,"Fluorescent, 96\" (4) T8 Lamps",null,"CFL, 20W, Quad, 2-Lamp, Mag Ballast","Metal Halide, (1) 100W Lamp, Mag Ballast",null,"Fluorescent, 96\" T12 Lamp ",{"$f":"Schedules!A44","v":0}]
[null,"Fluorescent, 48\" (4) 28W T8, NBF",null,null,null,null,"CFL, 22W, Quad, Mag Ballast","Metal Halide, (1) 150W Lamp, Mag Ballast",null,"Fluorescent, 96\" T12 Lamp, HO ",{"$f":"Schedules!A45","v":0}]
[null,"Fluorescent, 48\" (4) 32W T8, 0.96-1.1",null,null,null,null,"CFL, 22W, Quad, 2-Lamp, Mag Ballast","Metal Halide, (1) 175W Lamp, Mag Ballast",null,"Fluorescent, 96\" (2) T12 Lamps ",{"$f":"Schedules!A46","v":0}]
[null,"Fluorescent, 48\" (4) 32W T8, NBF",null,null,null,null,"CFL, 22W, Quad, 3-Lamp, Mag Ballast","Metal Halide, (1) 250W Lamp, Mag Ballast",null,"Fluorescent, 96\" (2) T12 Lamp, HO ",{"$f":"Schedules!A47","v":0}]
[null,"Fluorescent, 48\" (6) 32W T8, NBF",null,null,null,null,"CFL, 26W, Quad, Mag Ballast","Metal Halide, (1) 400W Lamp, Mag Ballast",null,"Fluorescent, 96\" (4) T12 Lamps ",{"$f":"Schedules!A48","v":0}]
[null,null,null,null,null,null,"CFL, 26W, Quad, Electronic Ballast","Metal Halide, (2) 400W Lamp, Mag Ballast",null,null,{"$f":"Schedules!A49","v":0}]
[null,null,null,null,null,null,"CFL, 26W, Quad, 2-Lamp, Mag Ballast","Metal Halide, (1) 750W Lamp, Mag Ballast",null,null,{"$f":"Schedules!A50","v":0}]
[null,null,null,null,null,null,"CFL, 26W, Quad, 2-Lamp, Electronic Ballast","Metal Halide, (1) 1000W Lamp, Mag Ballast",null,null,{"$f":"Schedules!A51","v":0}]
[null,null,null,null,null,null,"CFL, 26W, Quad, 3-Lamp, Mag Ballast","Metal Halide, (1) 1500W Lamp, Mag Ballast",null,null,{"$f":"Schedules!A52","v":0}]
[null,null,null,null,null,null,"CFL, 26W, Quad, 6-Lamp, Electronic Ballast",null,null,null,{"$f":"Schedules!A53","v":0}]
[null,null,null,null,null,null,"CFL, 32W, Quad, Electronic Ballast",null,null,null,{"$f":"Schedules!A54","v":0}]
[null,null,null,null,null,null,"CFL, 32W, Quad, 2-Lamp, Electronic Ballast",null,null,null,{"$f":"Schedules!A55","v":0}]
[null,null,null,null,null,null,"CFL, 40W, Quad, Electronic Ballast",null,null,null,{"$f":"Schedules!A56","v":0}]
[null,null,null,null,null,null,"CFL, 40W, Quad, 2-Lamp, Electronic Eallast",null,null,null,{"$f":"Schedules!A57","v":0}]
[null,null,null,null,null,null,"CFL, 50W, Twin, Electronic Ballast",null,null,null,{"$f":"Schedules!A58","v":0}]
[null,null,null,null,null,null,"CFL, 55W, Twin, Electronic Ballast, BF<0.94",null,null,null,{"$f":"Schedules!A59","v":0}]
[null,null,null,null,null,null,"CFL, 57W, Triple, Electronic Ballast, BF=0.94",null,null,null,{"$f":"Schedules!A60","v":0}]
[]
[]
["Existing Fixture Type","EXISTING_EQUIPMENT","Existing Watts Per Rebate Unit","Reduced Wattage Baseline"]
["Fluorescent","U-Tube, ES Lamp, EE Mag Ballast",43,22]
["Fluorescent","U-Tube, T8 Lamp",31,16]
["Fluorescent","U-Tube, 2 Lamps",59,30]
["Fluorescent","U-Tube, 2 ES Lamps, EE Mag Ballast",72,36]
["Fluorescent","U-Tube, 2 T8 Lamps",58,29]
["Fluorescent","Circular Lamp, 6\" Diameter",25,13]
["Fluorescent","Circular Lamp, 8\" Diameter",26,13]
["Fluorescent","Circular Lamp, 12\" Diameter",32,16]
["Fluorescent","Circular Lamp, 16\" Diameter",40,20]
["Fluorescent","Circular Lamp, 20W",20,10]
["Fluorescent","Circular Lamp, 22W",22,11]
["Fluorescent","Circular Lamp, 32W",40,20]
["T8 4ft Normal Ballast","Bi-level Stairwell, Hallway, and Garage Fixture w/ Occ Sensor, 2-lamp T8",48.4,25]
["T8 4ft Normal Ballast","Fluorescent, 48\" (1) 25W T8, NBF",25,13]
["T8 4ft Normal Ballast","Fluorescent, 48\" (1) 32W T8, NBF",28,14]
["T8 4ft Normal Ballast","Fluorescent, 48\" (2) 25W T8, 0.96-1.1",50,25]
["T8 4ft Normal Ballast","Fluorescent, 48\" (2) 25W T8, NBF",44,22]
["T8 4ft Normal Ballast","Fluorescent, 48\" (2) 28W T8, 0.96-1.1",53,27]
["T8 4ft Normal Ballast","Fluorescent, 48\" (2) 28W T8, NBF",48,24]
["T8 4ft Normal Ballast","Fluorescent, 48\" (2) 32W T8, 0.96-1.1",63,32]
["T8 4ft Normal Ballast","Fluorescent, 48\" (2) 32W T8, NBF",55,28]
["T8 4ft Normal Ballast","Fluorescent, 48\" (3) 25W T8, 0.96-1.1",70,35]
["T8 4ft Normal Ballast","Fluorescent, 48\" (3) 25W T8, NBF",65,33]
["T8 4ft Normal Ballast","Fluorescent, 48\" (3) 28W T8, 0.96-1.1",76,38]
["T8 4ft Normal Ballast","Fluorescent, 48\" (3) 28W T8, NBF",71,36]
["T8 4ft Normal Ballast","Fluorescent, 48\" (3) 32W T8, 0.96-1.1",90,45]
["T8 4ft Normal Ballast","Fluorescent, 48\" (3) 32W T8, NBF",82,41]
["T8 4ft Normal Ballast","Fluorescent, 48\" (4) 25W T8, 0.96-1.1",99,50]
["T8 4ft Normal Ballast","Fluorescent, 48\" (4) 25W T8, NBF",86,43]
["T8 4ft Normal Ballast","Fluorescent, 48\" (4) 28W T8, 0.96-1.1",107,54]
["T8 4ft Normal Ballast","Fluorescent, 48\" (4) 28W T8, NBF",95,48]
["T8 4ft Normal Ballast","Fluorescent, 48\" (4) 32W T8, 0.96-1.1",114,57]
["T8 4ft Normal Ballast","Fluorescent, 48\" (4) 32W T8, NBF",109,55]
["T8 4ft Normal Ballast","Fluorescent, 48\" (6) 32W T8, NBF",164,82]
["T8 4ft Low Ballast","Fluorescent, 48\" (1) 32W  T8, BF <0.85",25,13]
["T8 4ft Low Ballast","Fluorescent, 48\" (2) 25W  T8,  BF <0.85",38,19]
["T8 4ft Low Ballast","Fluorescent, 48\" (2) 28W  T8,  BF <0.85",42,21]
["T8 4ft Low Ballast","Fluorescent, 48\" (2) 32W  T8,  BF <0.85",48,24]
["T8 4ft Low Ballast","Fluorescent, 48\" (3) 25W  T8,  BF <0.85",58,29]
["T8 4ft Low Ballast","Fluorescent, 48\" (3) 28W  T8,  BF <0.85",64,32]
["T8 4ft Low Ballast","Fluorescent, 48\" (3) 32W  T8,  BF <0.85",73,37]
["T8 4ft Low Ballast","Fluorescent, 48\" (4) 25W  T8,  BF <0.85",77,39]
["T8 4ft Low Ballast","Fluorescent, 48\" (4) 28W  T8,  BF <0.85",85,43]
["T8 4ft Low Ballast","Fluorescent, 48\" (4) 32W  T8,  BF <0.85",96,48]
["T8 4ft Low Ballast","Fluorescent, 48\" (6) 32W  T8,  BF <0.85",146,73]
["T8 4ft High Ballast","Fluorescent, 48\" (2) 28W  T8, BF >1.1",65,33]
["T8 4ft High Ballast","Fluorescent, 48\" (2) 32W  T8, BF >1.1",74,37]
["T8 4ft High Ballast","Fluorescent, 48\" (3) 25W  T8, BF >1.1",91,46]
["T8 4ft High Ballast","Fluorescent, 48\" (3) 28W  T8, BF >1.1",97,49]
["T8 4ft High Ballast","Fluorescent, 48\" (3) 32W  T8, BF >1.1",111,56]
["T8 4ft High Ballast","Fluorescent, 48\" (4) 25W  T8, BF >1.1",119,60]
["T8 4ft High Ballast","Fluorescent, 48\" (4) 28W  T8, BF >1.1",128,64]
["T8 4ft High Ballast","Fluorescent, 48\" (4) 32W  T8, BF >1.1",146,73]
["T8 4ft High Ballast","Fluorescent, 48\" (6) 32W  T8, BF >1.1",227,114]
["T8 and T12 All Other Lengths","Fluorescent, 18\" T8 Lamp",19,10]
["T8 and T12 All Other Lengths","Fluorescent, 24\" T8 Lamp",20,10]
["T8 and T12 All Other Lengths","Fluorescent, 24\" (2) T8 Lamps",31,16]
["T8 and T12 All Other Lengths","Fluorescent, 24\" (3) T8 Lamps, BF 0.96-1.1",48,24]
["T8 and T12 All Other Lengths","Fluorescent, 24\" (4) T8 Lamps",66,33]
["T8 and T12 All Other Lengths","Fluorescent, 36\" (2) T8 Lamps",46,23]
["T8 and T12 All Other Lengths","Fluorescent, 60\" T8 Lamp, NBF",36,18]
["T8 and T12 All Other Lengths","Fluorescent, 60\", T8 Lamp, HO BF",57,29]
["T8 and T12 All Other Lengths","Fluorescent, 60\", (2) T8 Lamps, VHLO BF",102,51]
["T8 and T12 All Other Lengths","Fluorescent, 60\", T12 HO (Refrig. Display Case)",69,35]
["T8 and T12 All Other Lengths","Fluorescent, 60\" (2) T12 HO (Refrig. Display Case)",132,66]
["T8 and T12 All Other Lengths","Fluorescent, 60\" (2) T8 Lamps",72,36]
["T8 and T12 All Other Lengths","Fluorescent, 60\" (4) T8 Lamps",134,67]
["T8 and T12 All Other Lengths","Fluorescent, 72\", T12 HO (Refrig. Display Case)",120,60]
["T8 and T12 All Other Lengths","Fluorescent, 72\" (2) T12 HO (Refrig. Display Case)",194,97]
["T8 and T12 All Other Lengths","Fluorescent, 96\" (2) T8 Lamps, BF<0.85",98,49]
["T8 and T12 All Other Lengths","Fluorescent, 96\" (1) T8 Lamp",57,29]
["T8 and T12 All Other Lengths","Fluorescent, 96\" (4) T8 Lamps",220,110]
["T5 Lamp","Fluorescent, (1) 46\", T5/HO Lamp, NBF",62,31]
["T5 Lamp","Fluorescent, (2) 46\", T5/HO Lamp, NBF",118,59]
["T5 Lamp","Fluorescent, (2) 46\", 54W T5 Lamp, NBF",107,54]
["T5 Lamp","Fluorescent  (3) 46\"  54W T5/HO Lamp",182,91]
["T5 Lamp","Fluorescent  (4) 46\"  54W T5/HO Lamp",237,119]
["T5 Lamp","Fluorescent  (6) 46\"  54W T5/HO Lamp",355,178]
["T5 Lamp","Fluorescent  (8) 46\"  54W T5 /HO Lamp",473,237]
["CFL","CFL, 10W, Quad, Mag Ballast",15,7]
["CFL","CFL, 13W, Mag Ballast",17,8]
["CFL","CFL, 13W, Electronic Ballast",15,7]
["CFL","CFL, 13W, Quad, 2-Lamp, Electronic  Ballast",29,14]
["CFL","CFL, 13W, Quad, 2-Lamp, Mag Ballast",31,15]
["CFL","CFL, 13W, Quad, 3-Lamp Mag Ballast",48,22]
["CFL","CFL, 15W, Quad, Mag Ballast",20,10]
["CFL","CFL, 16W, 2D Lamp",26,12]
["CFL","CFL, 17W, Quad, Mag Ballast",24,11]
["CFL","CFL, 17W, Quad, 2-Lamp, Mag Ballast",48,22]
["CFL","CFL, 18W, Quad, Mag Ballast",23,11]
["CFL","CFL, 18W, Pin Base",26,12]
["CFL","CFL, 18W,  Pin Base, Electronic Ballast",20,10]
["CFL","CFL, 18W, Quad, Electronic Ballast",20,10]
["CFL","CFL, 18W, Quad, 2-Lamp, Mag Ballast",44,21]
["CFL","CFL, 18W, Quad, 2-Lamp, Electronic Ballast",36,17]
["CFL","CFL, 20W, Quad, Mag Ballast",23,11]
["CFL","CFL, 20W, Quad, 2-Lamp, Mag Ballast",46,22]
["CFL","CFL, 22W, Quad, Mag Ballast",24,11]
["CFL","CFL, 22W, Quad, 2-Lamp, Mag Ballast",48,22]
["CFL","CFL, 22W, Quad, 3-Lamp, Mag Ballast",72,33]
["CFL","CFL, 26W, Quad, Mag Ballast",33,16]
["CFL","CFL, 26W, Quad, Electronic Ballast",28,13]
["CFL","CFL, 26W, Quad, 2-Lamp, Mag Ballast",66,31]
["CFL","CFL, 26W, Quad, 2-Lamp, Electronic Ballast",52,24]
["CFL","CFL, 26W, Quad, 3-Lamp, Mag Ballast",99,46]
["CFL","CFL, 26W, Quad, 6-Lamp, Electronic Ballast",150,69]
["CFL","CFL, 32W, Quad, Electronic Ballast",34,16]
["CFL","CFL, 32W, Quad, 2-Lamp, Electronic Ballast",62,29]
["CFL","CFL, 40W, Quad, Electronic Ballast",43,20]
["CFL","CFL, 40W, Quad, 2-Lamp, Electronic Eallast",72,33]
["CFL","CFL, 50W, Twin, Electronic Ballast",61,28]
["CFL","CFL, 55W, Twin, Electronic Ballast, BF<0.94",59,28]
["CFL","CFL, 57W, Triple, Electronic Ballast, BF=0.94",60,28]
["Metal Halide","Metal Halide, (1) 20W Lamp, Electronic Ballast",24,18]
["Metal Halide","Metal Halide, (1) 22W Lamp, Electronic Ballast",26,20]
["Metal Halide","Metal Halide, (1) 39W Lamp, Electronic Ballast",45,34]
["Metal Halide","Metal Halide, (2) 39W Lamp, Electronic Ballast",89,67]
["Metal Halide","Metal Halide, (1) 50W Lamp, Electronic Ballast",56,42]
["Metal Halide","Metal Halide, (1) 70W Lamp, Electronic Ballast",80,60]
["Metal Halide","Metal Halide, (1) 100W Lamp, Electronic Ballast",110,83]
["Metal Halide","Metal Halide, (1) 150W Lamp, Electronic Ballast",168,126]
["Metal Halide","Metal Halide, (1) 175W Lamp, Electronic Ballast",194,146]
["Metal Halide","Metal Halide, (1) 200W Lamp, Electronic Ballast",215,162]
["Metal Halide","Metal Halide, (1) 250W Lamp, Electronic Ballast",267,201]
["Metal Halide","Metal Halide, (1) 320W Lamp, Electronic Ballast",343,258]
["Metal Halide","Metal Halide, (1) 350W Lamp, Electronic Ballast",374,281]
["Metal Halide","Metal Halide, (1) 400W Lamp, Electronic Ballast",428,321]
["Metal Halide","Metal Halide, (1) 32W Lamp, Mag Ballast",43,33]
["Metal Halide","Metal Halide, (1) 50W Lamp, Mag Ballast",61,46]
["Metal Halide","Metal Halide, (1) 70W Lamp, Mag Ballast",88,66]
["Metal Halide","Metal Halide, (1) 100W Lamp, Mag Ballast",128,96]
["Metal Halide","Metal Halide, (1) 150W Lamp, Mag Ballast",190,143]
["Metal Halide","Metal Halide, (1) 175W Lamp, Mag Ballast",210,158]
["Metal Halide","Metal Halide, (1) 250W Lamp, Mag Ballast",294,221]
["Metal Halide","Metal Halide, (1) 400W Lamp, Mag Ballast",458,344]
["Metal Halide","Metal Halide, (2) 400W Lamp, Mag Ballast",916,687]
["Metal Halide","Metal Halide, (1) 750W Lamp, Mag Ballast",850,638]
["Metal Halide","Metal Halide, (1) 1000W Lamp, Mag Ballast",1080,810]
["Metal Halide","Metal Halide, (1) 1500W Lamp, Mag Ballast",1605,1204]
["High Pressure Sodium","High Pressure Sodium, (1) 35W Lamp",47,40]
["High Pressure Sodium","High Pressure Sodium, (1) 50W Lamp",66,55]
["High Pressure Sodium","High Pressure Sodium, (1) 70W Lamp",91,76]
["High Pressure Sodium","High Pressure Sodium, (1) 100W Lamp",128,107]
["High Pressure Sodium","High Pressure Sodium, (1) 150W Lamp",188,157]
["High Pressure Sodium","High Pressure Sodium, (1) 200W Lamp",230,192]
["High Pressure Sodium","High Pressure Sodium, (1) 250W Lamp",295,246]
["High Pressure Sodium","High Pressure Sodium, (1) 310W Lamp",355,296]
["High Pressure Sodium","High Pressure Sodium, (1) 360W Lamp",414,345]
["High Pressure Sodium","High Pressure Sodium, (1) 400W Lamp",464,387]
["High Pressure Sodium","High Pressure Sodium, (1) 750W Lamp",830,692]
["High Pressure Sodium","High Pressure Sodium, (1) 1000W Lamp",1100,917]
["T12 Lamp","Fluorescent, 18\" T12 Lamp",19,8]
["T12 Lamp","Fluorescent, 18\"  (2) T12 Lamps ",38,16]
["T12 Lamp","Fluorescent, 24\" T12 Lamp ",28,12]
["T12 Lamp","Fluorescent, 24\" (2) T12 Lamps ",56,24]
["T12 Lamp","Fluorescent, 24\" (3) T12 Lamps ",68,29]
["T12 Lamp","Fluorescent, 24\" (4) T12 Lamps ",100,42]
["T12 Lamp","Fluorescent, 36\" (2) T12 Lamps ",50,21]
["T12 Lamp","Fluorescent, 48\" T12 Lamp ",44,19]
["T12 Lamp","Fluorescent, 48\" (2) T12 Lamps ",74,31]
["T12 Lamp","Fluorescent, 48\" (3) T12 Lamps ",114,48]
["T12 Lamp","Fluorescent, 48\" (4) T12 Lamps",148,62]
["T12 Lamp","Fluorescent, 48\" (6) T12 Lamps",216,90]
["T12 Lamp","Fluorescent, 60\" T12 Lamp ",63,27]
["T12 Lamp","Fluorescent, 60\" T12 HO Lamp ",92,39]
["T12 Lamp","Fluorescent, 60\" (2) T12 Lamps ",126,53]
["T12 Lamp","Fluorescent, 60\" (2) T12 HO Lamps ",184,77]
["T12 Lamp","Fluorescent, 60\" (4) T12 Lamps ",226,95]
["T12 Lamp","Fluorescent, 96\" T12 Lamp ",90,38]
["T12 Lamp","Fluorescent, 96\" T12 Lamp, HO ",110,46]
["T12 Lamp","Fluorescent, 96\" (2) T12 Lamps ",165,69]
["T12 Lamp","Fluorescent, 96\" (2) T12 Lamp, HO ",205,86]
["T12 Lamp","Fluorescent, 96\" (4) T12 Lamps ",330,138]
["User Defined",{"$f":"Schedules!A27","v":0},{"$f":"Schedules!B27","v":0}]
["User Defined",{"$f":"Schedules!A28","v":0},{"$f":"Schedules!B28","v":0}]
["User Defined",{"$f":"Schedules!A29","v":0},{"$f":"Schedules!B29","v":0}]
["User Defined",{"$f":"Schedules!A30","v":0},{"$f":"Schedules!B30","v":0}]
["User Defined",{"$f":"Schedules!A31","v":0},{"$f":"Schedules!B31","v":0}]
["User Defined",{"$f":"Schedules!A32","v":0},{"$f":"Schedules!B32","v":0}]
["User Defined",{"$f":"Schedules!A33","v":0},{"$f":"Schedules!B33","v":0}]
["User Defined",{"$f":"Schedules!A34","v":0},{"$f":"Schedules!B34","v":0}]
["User Defined",{"$f":"Schedules!A35","v":0},{"$f":"Schedules!B35","v":0}]
["User Defined",{"$f":"Schedules!A36","v":0},{"$f":"Schedules!B36","v":0}]
["User Defined",{"$f":"Schedules!A37","v":0},{"$f":"Schedules!B37","v":0}]
["User Defined",{"$f":"Schedules!A38","v":0},{"$f":"Schedules!B38","v":0}]
["User Defined",{"$f":"Schedules!A39","v":0},{"$f":"Schedules!B39","v":0}]
["User Defined",{"$f":"Schedules!A40","v":0},{"$f":"Schedules!B40","v":0}]
["User Defined",{"$f":"Schedules!A41","v":0},{"$f":"Schedules!B41","v":0}]
["User Defined",{"$f":"Schedules!A42","v":0},{"$f":"Schedules!B42","v":0}]
["User Defined",{"$f":"Schedules!A43","v":0},{"$f":"Schedules!B43","v":0}]
["User Defined",{"$f":"Schedules!A44","v":0},{"$f":"Schedules!B44","v":0}]
["User Defined",{"$f":"Schedules!A45","v":0},{"$f":"Schedules!B45","v":0}]
["User Defined",{"$f":"Schedules!A46","v":0},{"$f":"Schedules!B46","v":0}]
["User Defined",{"$f":"Schedules!A47","v":0},{"$f":"Schedules!B47","v":0}]
["User Defined",{"$f":"Schedules!A48","v":0},{"$f":"Schedules!B48","v":0}]
["User Defined",{"$f":"Schedules!A49","v":0},{"$f":"Schedules!B49","v":0}]
["User Defined",{"$f":"Schedules!A50","v":0},{"$f":"Schedules!B50","v":0}]
["User Defined",{"$f":"Schedules!A51","v":0},{"$f":"Schedules!B51","v":0}]
["User Defined",{"$f":"Schedules!A52","v":0},{"$f":"Schedules!B52","v":0}]
["User Defined",{"$f":"Schedules!A53","v":0},{"$f":"Schedules!B53","v":0}]
["User Defined",{"$f":"Schedules!A54","v":0},{"$f":"Schedules!B54","v":0}]
["User Defined",{"$f":"Schedules!A55","v":0},{"$f":"Schedules!B55","v":0}]
["User Defined",{"$f":"Schedules!A56","v":0},{"$f":"Schedules!B56","v":0}]
["User Defined",{"$f":"Schedules!A57","v":0},{"$f":"Schedules!B57","v":0}]
["User Defined",{"$f":"Schedules!A58","v":0},{"$f":"Schedules!B58","v":0}]
["User Defined",{"$f":"Schedules!A59","v":0},{"$f":"Schedules!B59","v":0}]
["User Defined",{"$f":"Schedules!A60","v":0},{"$f":"Schedules!B60","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Coincident Demand Factors","HVAC Interactive Effects (Energy)","HVAC Interactive Effects (Demand)"]
["Building Type","Non-CFL","Non-CFL","Non-CFL","BUSINESS_TYPE","CDF","HVAC IE-Energy","HVAC IE-Demand","FIXTURE_TYPE","MeasureLife",null,"FIXTURE_LOCATION"]
["Assembly",0.53,1.03,1.18,"Assembly",{"$f":"B258","v":0.53},{"$f":"C258","v":1.03},{"$f":"D258","v":1.18},"Fluorescent",10,null,"Interior",null,null,"Cap Status"]
["College/University: Community College",0.49,1.0900000000000001,1.2,"College/University",{"$f":"AVERAGE(B259,B263)","v":0.46499999999999997},{"$f":"AVERAGE(C259,C263)","v":1.0950000000000002},{"$f":"AVERAGE(D259,D263)","v":1.2},"Incandescent",null,null,"Exterior",null,null,0.5]
["School: Primary School",0.02,1.06,1,"School",{"$f":"AVERAGE(B260:B262)","v":0.02},{"$f":"AVERAGE(C260:C262)","v":1.04},{"$f":"AVERAGE(D260:D262)","v":1},"HID",null,null,null,null,null,1]
["School: Relocatable Classroom",0.02,1.02,1,"Grocery",{"$f":"B264","v":0.69},{"$f":"C264","v":0.91},{"$f":"D264","v":1.19},"LED",12]
["School: Secondary School",0.02,1.04,1,"Health/Medical",{"$f":"AVERAGE(B265:B266)","v":0.755},{"$f":"AVERAGE(C265:C266)","v":1.0649999999999999},{"$f":"AVERAGE(D265:D266)","v":1.19},"Other",8]
["College/Univerity: University",0.44,1.1000000000000001,1.2,"Lodging",{"$f":"AVERAGE(B267:B268)","v":0.20500000000000002},{"$f":"AVERAGE(C267:C268)","v":0.995},{"$f":"AVERAGE(D267:D268)","v":1.22},"Metal Halide"]
["Grocery",0.69,0.91,1.19,"Manufacturing",{"$f":"AVERAGE(B269:B270)","v":0.88500000000000001},{"$f":"AVERAGE(C269:C270)","v":1.0750000000000002},{"$f":"AVERAGE(D269:D270)","v":1.18},"Mercury Vapor"]
["Health/Medical: Hospital",0.83,1.1000000000000001,1.19,"Office",{"$f":"AVERAGE(B271:B272)","v":0.7},{"$f":"AVERAGE(C271:C272)","v":1.08},{"$f":"AVERAGE(D271:D272)","v":1.23},"Induction",10]
["Health/Medical: Nursing Home",0.68,1.03,1.19,"Restaurant",{"$f":"AVERAGE(B273:B274)","v":0.80500000000000005},{"$f":"AVERAGE(C273:C274)","v":1.02},{"$f":"AVERAGE(D273:D274)","v":1.19}]
["Lodging: Hotel",0.24,0.97,1.23,"Retail",{"$f":"AVERAGE(B275:B277)","v":0.83},{"$f":"AVERAGE(C275:C277)","v":1.0633333333333332},{"$f":"AVERAGE(D275:D277)","v":1.1866666666666665}]
["Lodging: Motel",0.17,1.02,1.21,"Storage",{"$f":"AVERAGE(B278:B279)","v":0.7},{"$f":"AVERAGE(C278:C279)","v":0.97499999999999998},{"$f":"AVERAGE(D278:D279)","v":1.105}]
["Manufacturing: Bio/Tech Manuf.",0.85,1.1100000000000001,1.19,"Refrigerated Warehouse",{"$f":"B280","v":0.56000000000000005},{"$f":"C280","v":1.59},{"$f":"D280","v":1.32}]
["Manufacturing: Light Industrial Manuf.",0.92,1.04,1.17,"Other",0.5808695652173913,1,1]
["Office - Large Office",0.71,1.1100000000000001,1.26]
["Office: Small Office",0.69,1.05,1.2]
["Restaurant: Fast-Food Restaurant",0.81,1.03,1.17]
["Restaurant: Sit-Down Restaurant",0.8,1.01,1.21]
["Retail: Department Store",0.76,1.07,1.19]
["Retail: Big Box Retail",0.85,1.06,1.19]
["Retail: Small Retail",0.88,1.06,1.18]
["Storage: Conditioned Storage",0.7,0.95,1.21]
["Storage: Unconditioned Storage",0.7,1,1]
["Refrigerated Warehouse",0.56000000000000005,1.59,1.32]
["Exterior",0,1,1]
["Average",{"$f":"AVERAGE(B258:B280)","v":0.5808695652173913},{"$f":"AVERAGE(C258:C280)","v":1.0630434782608695},{"$f":"AVERAGE(D258:D280)","v":1.1686956521739131}]
[]
["Early Replacement"]
["Replace on Burnout"]