{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Worksheet","Measure Code","Table","Export","Version"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":13,"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":"Worksheet","index":0,"n_rows":40,"n_cols":31,"rows_kept":40,"cut":false,"hidden":false,"merged":[[0,0,0,3],[2,16,2,18],[3,21,3,23],[3,24,3,26],[4,21,8,23],[4,24,8,26],[10,21,10,22],[13,16,13,17],[3,16,3,18],[13,1,13,3],[7,1,7,2],[5,1,5,3],[3,1,3,3],[3,5,3,10],[7,5,7,10],[8,5,8,6],[8,1,8,2],[4,1,4,3]]}
["FY22 SmartStart Existing Buildings - Gas Water Heating v1.0",null,null,null,"Incentive amounts are estimates until verified by the Program Manager."]
[]
["Customer Information",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Units Committed:",null,null,{"$f":"SUM(O16:O40)","v":0}]
["Company",null,null,null,"Address",null,null,null,null,null,null,null,null,null,null,null,"Total Units Installed:",null,null,{"$f":"SUM(P16:P40)","v":0},null,"Pre-Inspection Notes",null,null,"Post-Inspection Notes"]
["Application",null,null,null,"Date"]
["Contact"]
["Contractor/Vendor Information"]
["Company",null,null,null,"Address"]
["Contact",null,null," ","Phone"]
["Enhanced Incentive Eligibility"]
[false,false,false,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inspection Type"]
[false,false,false]
[]
["Project Type","Existing Building",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totals",null,{"$f":"SUM(S16:S40)","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Measure Code","New or Replaced","Type\nW - Water Heater\nT - Tankless\nB - Booster\nLF - Low Flow Faucet Aerator\nLS - Low Flow Showerhead","Manufacturer","Model Number","Unit Size\n(Gallons) ","Unit Capacity\n(MBH)\n\nNote: MBH = Btu/h ÷ 1000","Unit Efficiency","Efficiency Units","Unit Standby Loss Factor\n(MBH)","Area Type","Area Size\n(sq ft)","Water Heater Type Replaced","Proposed Fixture Flowrate\n(GPM)","Quantity Committed","Quantity Installed","Incentive Per Unit","Enhanced Incentive Per Unit","Total Committed Incentive","Total Installed Incentive","Annual Gas Savings Committed\n(Therms)","Annual Gas Savings Installed\n(Therms)","Lifetime Gas Savings Committed\n(Therms)","Lifetime Gas Savings Installed\n(Therms)","Annual Electricity Committed Savings (kWh)","Annual Electricity Installed Savings (kWh)","Lifetime Committed Electricity Savings","Lifetime Installed Electricity Savings","Committed Demand Savings kW","Installed Demand Savings kW","Positive Gas Savings"]
[null,null,{"$f":"IF(A16=\"\",\"\",VLOOKUP(A16,MeasureCode_Lookup,2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($B$14=\"\",A16=\"\",AND(OR(C16=\"LF\",C16=\"LS\")=TRUE,N16=\"\")=TRUE,AND(C16=\"W\",F16=\"\")=TRUE,AND(C16<>\"LF\",C16<>\"LS\",G16=\"\")=TRUE,AND(C16<>\"B\",C16<>\"LF\",C16<>\"LS\",OR(H16=\"\",I16=\"\")=TRUE)=TRUE,AND(C16=\"W\",I16=\"Et\",J16=\"\")=TRUE,AND(C16<>\"B\",C16<>\"LF\",C16<>\"LS\",OR(K16=\"\",L16=\"\")=TRUE)=TRUE,AND(B16=\"R\",C16=\"T\",M16=\"\")=TRUE)=TRUE,0,IF(OR(AE16=\"No\",G16<VLOOKUP(A16,MeasureCode_Lookup,4,FALSE),G16>VLOOKUP(A16,MeasureCode_Lookup,5,FALSE),AND(C16<>\"B\",C16<>\"LF\",C16<>\"LS\",H16<VLOOKUP(A16,MeasureCode_Lookup,IF(I16=\"EF\",6,IF(I16=\"UEF\",7,8)),FALSE)),AND(A16=\"GWH11\",N16>1.5)=TRUE,AND(A16=\"GWH12\",N16>1)=TRUE,AND(A16=\"GWH13\",N16>2)=TRUE,AND(A16=\"GWH14\",N16>1.5)=TRUE)=TRUE,0,VLOOKUP(A16,MeasureCode_Lookup,10,FALSE)*IF(OR(C16=\"T\",C16=\"LF\",C16=\"LS\")=TRUE,1,G16)))","v":0},{"$f":"IF(OR($A$11=TRUE,$A$12=TRUE,$B$11=TRUE,$B$12=TRUE,$C$11=TRUE,$C$12=TRUE)=TRUE,Q16,0)","v":0},{"$f":"O16*(Q16+R16)","v":0},{"$f":"P16*(Q16+R16)","v":0},{"$f":"IF(Q16=0,0,O16*IF(C16=\"LF\",(Table!$B$20-N16)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C16=\"LS\",(Table!$B$21-N16)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C16=\"B\",-G16/100*1000,IF(C16=\"T\",(1-(IF(I16=\"Et\",0.8,IF(I16=\"UEF\",IF(AND(B16=\"R\",M16=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B16=\"R\",M16=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H16)+IF(OR(AND(B16=\"N\",I16=\"Et\")=TRUE,AND(B16=\"R\",I16=\"Et\",M16=\"Tank Type\")=TRUE)=TRUE,0.775*(G16)^-0.778,0))*VLOOKUP(K16,EUD,2,FALSE)*L16/100,(1-(IF(I16=\"Et\",0.8,IF(I16=\"UEF\",IF(F16<=55,0.6483-(0.0017*F16),0.7897-(0.0004*F16)),IF($B$14=\"Existing Building\",0.62-(0.0019*F16),0.67-(0.0005*F16))))/H16)+IF(I16=\"Et\",IF($B$14=\"Existing Building\",(((G16/0.8+110*SQRT(F16))/1000)-J16)/G16,(((G16/0.799+16.6*SQRT(F16))/1000)-J16)/G16),0))*VLOOKUP(K16,EUD,2,FALSE)*L16/100)))))","v":0},{"$f":"IF(Q16=0,0,P16*IF(C16=\"LF\",(Table!$B$20-N16)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C16=\"LS\",(Table!$B$21-N16)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C16=\"B\",-G16/100*1000,IF(C16=\"T\",(1-(IF(I16=\"Et\",0.8,IF(I16=\"UEF\",IF(AND(B16=\"R\",M16=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B16=\"R\",M16=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H16)+IF(OR(AND(B16=\"N\",I16=\"Et\")=TRUE,AND(B16=\"R\",I16=\"Et\",M16=\"Tank Type\")=TRUE)=TRUE,0.775*(G16)^-0.778,0))*VLOOKUP(K16,EUD,2,FALSE)*L16/100,(1-(IF(I16=\"Et\",0.8,IF(I16=\"UEF\",IF(F16<=55,0.6483-(0.0017*F16),0.7897-(0.0004*F16)),IF($B$14=\"Existing Building\",0.62-(0.0019*F16),0.67-(0.0005*F16))))/H16)+IF(I16=\"Et\",IF($B$14=\"Existing Building\",(((G16/0.8+110*SQRT(F16))/1000)-J16)/G16,(((G16/0.799+16.6*SQRT(F16))/1000)-J16)/G16),0))*VLOOKUP(K16,EUD,2,FALSE)*L16/100)))))","v":0},{"$f":"IF(A16=\"\",0,U16*VLOOKUP(A16,MeasureCode_Lookup,12,FALSE))","v":0},{"$f":"IF(A16=\"\",0,V16*VLOOKUP(A16,MeasureCode_Lookup,12,FALSE))","v":0},{"$f":"IF(Q16=0,0,IF(C16=\"B\",O16*G16/3.412*1000,0))","v":0},{"$f":"IF(Q16=0,0,IF(C16=\"B\",P16*G16/3.412*1000,0))","v":0},{"$f":"IF(A16=\"\",0,Y16*VLOOKUP(A16,MeasureCode_Lookup,12,FALSE))","v":0},{"$f":"IF(A16=\"\",0,Z16*VLOOKUP(A16,MeasureCode_Lookup,12,FALSE))","v":0},{"$f":"IF(Q16=0,0,IF(C16=\"B\",O16*G16/3.412*0.3,0))","v":0},{"$f":"IF(Q16=0,0,IF(C16=\"B\",P16*G16/3.412*0.3,0))","v":0},{"$f":"IFERROR(IF(IF(C16=\"T\",(1-(IF(I16=\"Et\",0.8,IF(I16=\"UEF\",IF(AND(B16=\"R\",M16=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B16=\"R\",M16=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H16)+IF(OR(AND(B16=\"N\",I16=\"Et\")=TRUE,AND(B16=\"R\",I16=\"Et\",M16=\"Tank Type\")=TRUE)=TRUE,0.775*(G16)^-0.778,0))*VLOOKUP(K16,EUD,2,FALSE)*L16/100,(1-(IF(I16=\"Et\",0.8,IF(I16=\"UEF\",IF(F16<=55,0.6483-(0.0017*F16),0.7897-(0.0004*F16)),IF($B$14=\"Existing Building\",0.62-(0.0019*F16),0.67-(0.0005*F16))))/H16)+IF(I16=\"Et\",IF($B$14=\"Existing Building\",(((G16/0.8+110*SQRT(F16))/1000)-J16)/G16,(((G16/0.799+16.6*SQRT(F16))/1000)-J16)/G16),0))*VLOOKUP(K16,EUD,2,FALSE)*L16/100)>0,\"Yes\",\"No\"),\"\")","v":""}]
[null,null,{"$f":"IF(A17=\"\",\"\",VLOOKUP(A17,MeasureCode_Lookup,2,FALSE))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,0,{"$f":"IF(OR($A$11=TRUE,$A$12=TRUE,$B$11=TRUE,$B$12=TRUE,$C$11=TRUE,$C$12=TRUE)=TRUE,Q17,0)","v":0},{"$f":"O17*(Q17+R17)","v":0},{"$f":"P17*(Q17+R17)","v":0},{"$f":"IF(Q17=0,0,O17*IF(C17=\"LF\",(Table!$B$20-N17)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C17=\"LS\",(Table!$B$21-N17)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C17=\"B\",-G17/100*1000,IF(C17=\"T\",(1-(IF(I17=\"Et\",0.8,IF(I17=\"UEF\",IF(AND(B17=\"R\",M17=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B17=\"R\",M17=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H17)+IF(OR(AND(B17=\"N\",I17=\"Et\")=TRUE,AND(B17=\"R\",I17=\"Et\",M17=\"Tank Type\")=TRUE)=TRUE,0.775*(G17)^-0.778,0))*VLOOKUP(K17,EUD,2,FALSE)*L17/100,(1-(IF(I17=\"Et\",0.8,IF(I17=\"UEF\",IF(F17<=55,0.6483-(0.0017*F17),0.7897-(0.0004*F17)),IF($B$14=\"Existing Building\",0.62-(0.0019*F17),0.67-(0.0005*F17))))/H17)+IF(I17=\"Et\",IF($B$14=\"Existing Building\",(((G17/0.8+110*SQRT(F17))/1000)-J17)/G17,(((G17/0.799+16.6*SQRT(F17))/1000)-J17)/G17),0))*VLOOKUP(K17,EUD,2,FALSE)*L17/100)))))","v":0},{"$f":"IF(Q17=0,0,P17*IF(C17=\"LF\",(Table!$B$20-N17)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C17=\"LS\",(Table!$B$21-N17)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C17=\"B\",-G17/100*1000,IF(C17=\"T\",(1-(IF(I17=\"Et\",0.8,IF(I17=\"UEF\",IF(AND(B17=\"R\",M17=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B17=\"R\",M17=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H17)+IF(OR(AND(B17=\"N\",I17=\"Et\")=TRUE,AND(B17=\"R\",I17=\"Et\",M17=\"Tank Type\")=TRUE)=TRUE,0.775*(G17)^-0.778,0))*VLOOKUP(K17,EUD,2,FALSE)*L17/100,(1-(IF(I17=\"Et\",0.8,IF(I17=\"UEF\",IF(F17<=55,0.6483-(0.0017*F17),0.7897-(0.0004*F17)),IF($B$14=\"Existing Building\",0.62-(0.0019*F17),0.67-(0.0005*F17))))/H17)+IF(I17=\"Et\",IF($B$14=\"Existing Building\",(((G17/0.8+110*SQRT(F17))/1000)-J17)/G17,(((G17/0.799+16.6*SQRT(F17))/1000)-J17)/G17),0))*VLOOKUP(K17,EUD,2,FALSE)*L17/100)))))","v":0},0,0,{"$f":"IF(Q17=0,0,IF(C17=\"B\",O17*G17/3.412*1000,0))","v":0},{"$f":"IF(Q17=0,0,IF(C17=\"B\",P17*G17/3.412*1000,0))","v":0},0,0,{"$f":"IF(Q17=0,0,IF(C17=\"B\",O17*G17/3.412*0.3,0))","v":0},{"$f":"IF(Q17=0,0,IF(C17=\"B\",P17*G17/3.412*0.3,0))","v":0},{"$f":"IFERROR(IF(IF(C17=\"T\",(1-(IF(I17=\"Et\",0.8,IF(I17=\"UEF\",IF(AND(B17=\"R\",M17=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B17=\"R\",M17=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H17)+IF(OR(AND(B17=\"N\",I17=\"Et\")=TRUE,AND(B17=\"R\",I17=\"Et\",M17=\"Tank Type\")=TRUE)=TRUE,0.775*(G17)^-0.778,0))*VLOOKUP(K17,EUD,2,FALSE)*L17/100,(1-(IF(I17=\"Et\",0.8,IF(I17=\"UEF\",IF(F17<=55,0.6483-(0.0017*F17),0.7897-(0.0004*F17)),IF($B$14=\"Existing Building\",0.62-(0.0019*F17),0.67-(0.0005*F17))))/H17)+IF(I17=\"Et\",IF($B$14=\"Existing Building\",(((G17/0.8+110*SQRT(F17))/1000)-J17)/G17,(((G17/0.799+16.6*SQRT(F17))/1000)-J17)/G17),0))*VLOOKUP(K17,EUD,2,FALSE)*L17/100)>0,\"Yes\",\"No\"),\"\")","v":""}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(Q18=0,0,O18*IF(C18=\"LF\",(Table!$B$20-N18)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C18=\"LS\",(Table!$B$21-N18)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C18=\"B\",-G18/100*1000,IF(C18=\"T\",(1-(IF(I18=\"Et\",0.8,IF(I18=\"UEF\",IF(AND(B18=\"R\",M18=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B18=\"R\",M18=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H18)+IF(OR(AND(B18=\"N\",I18=\"Et\")=TRUE,AND(B18=\"R\",I18=\"Et\",M18=\"Tank Type\")=TRUE)=TRUE,0.775*(G18)^-0.778,0))*VLOOKUP(K18,EUD,2,FALSE)*L18/100,(1-(IF(I18=\"Et\",0.8,IF(I18=\"UEF\",IF(F18<=55,0.6483-(0.0017*F18),0.7897-(0.0004*F18)),IF($B$14=\"Existing Building\",0.62-(0.0019*F18),0.67-(0.0005*F18))))/H18)+IF(I18=\"Et\",IF($B$14=\"Existing Building\",(((G18/0.8+110*SQRT(F18))/1000)-J18)/G18,(((G18/0.799+16.6*SQRT(F18))/1000)-J18)/G18),0))*VLOOKUP(K18,EUD,2,FALSE)*L18/100)))))","v":0},{"$f":"IF(Q18=0,0,P18*IF(C18=\"LF\",(Table!$B$20-N18)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C18=\"LS\",(Table!$B$21-N18)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C18=\"B\",-G18/100*1000,IF(C18=\"T\",(1-(IF(I18=\"Et\",0.8,IF(I18=\"UEF\",IF(AND(B18=\"R\",M18=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B18=\"R\",M18=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H18)+IF(OR(AND(B18=\"N\",I18=\"Et\")=TRUE,AND(B18=\"R\",I18=\"Et\",M18=\"Tank Type\")=TRUE)=TRUE,0.775*(G18)^-0.778,0))*VLOOKUP(K18,EUD,2,FALSE)*L18/100,(1-(IF(I18=\"Et\",0.8,IF(I18=\"UEF\",IF(F18<=55,0.6483-(0.0017*F18),0.7897-(0.0004*F18)),IF($B$14=\"Existing Building\",0.62-(0.0019*F18),0.67-(0.0005*F18))))/H18)+IF(I18=\"Et\",IF($B$14=\"Existing Building\",(((G18/0.8+110*SQRT(F18))/1000)-J18)/G18,(((G18/0.799+16.6*SQRT(F18))/1000)-J18)/G18),0))*VLOOKUP(K18,EUD,2,FALSE)*L18/100)))))","v":0},0,0,0,0,0,0,0,0,{"$f":"IFERROR(IF(IF(C18=\"T\",(1-(IF(I18=\"Et\",0.8,IF(I18=\"UEF\",IF(AND(B18=\"R\",M18=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B18=\"R\",M18=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H18)+IF(OR(AND(B18=\"N\",I18=\"Et\")=TRUE,AND(B18=\"R\",I18=\"Et\",M18=\"Tank Type\")=TRUE)=TRUE,0.775*(G18)^-0.778,0))*VLOOKUP(K18,EUD,2,FALSE)*L18/100,(1-(IF(I18=\"Et\",0.8,IF(I18=\"UEF\",IF(F18<=55,0.6483-(0.0017*F18),0.7897-(0.0004*F18)),IF($B$14=\"Existing Building\",0.62-(0.0019*F18),0.67-(0.0005*F18))))/H18)+IF(I18=\"Et\",IF($B$14=\"Existing Building\",(((G18/0.8+110*SQRT(F18))/1000)-J18)/G18,(((G18/0.799+16.6*SQRT(F18))/1000)-J18)/G18),0))*VLOOKUP(K18,EUD,2,FALSE)*L18/100)>0,\"Yes\",\"No\"),\"\")","v":""}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(Q19=0,0,O19*IF(C19=\"LF\",(Table!$B$20-N19)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C19=\"LS\",(Table!$B$21-N19)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C19=\"B\",-G19/100*1000,IF(C19=\"T\",(1-(IF(I19=\"Et\",0.8,IF(I19=\"UEF\",IF(AND(B19=\"R\",M19=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B19=\"R\",M19=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H19)+IF(OR(AND(B19=\"N\",I19=\"Et\")=TRUE,AND(B19=\"R\",I19=\"Et\",M19=\"Tank Type\")=TRUE)=TRUE,0.775*(G19)^-0.778,0))*VLOOKUP(K19,EUD,2,FALSE)*L19/100,(1-(IF(I19=\"Et\",0.8,IF(I19=\"UEF\",IF(F19<=55,0.6483-(0.0017*F19),0.7897-(0.0004*F19)),IF($B$14=\"Existing Building\",0.62-(0.0019*F19),0.67-(0.0005*F19))))/H19)+IF(I19=\"Et\",IF($B$14=\"Existing Building\",(((G19/0.8+110*SQRT(F19))/1000)-J19)/G19,(((G19/0.799+16.6*SQRT(F19))/1000)-J19)/G19),0))*VLOOKUP(K19,EUD,2,FALSE)*L19/100)))))","v":0},{"$f":"IF(Q19=0,0,P19*IF(C19=\"LF\",(Table!$B$20-N19)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C19=\"LS\",(Table!$B$21-N19)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C19=\"B\",-G19/100*1000,IF(C19=\"T\",(1-(IF(I19=\"Et\",0.8,IF(I19=\"UEF\",IF(AND(B19=\"R\",M19=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B19=\"R\",M19=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H19)+IF(OR(AND(B19=\"N\",I19=\"Et\")=TRUE,AND(B19=\"R\",I19=\"Et\",M19=\"Tank Type\")=TRUE)=TRUE,0.775*(G19)^-0.778,0))*VLOOKUP(K19,EUD,2,FALSE)*L19/100,(1-(IF(I19=\"Et\",0.8,IF(I19=\"UEF\",IF(F19<=55,0.6483-(0.0017*F19),0.7897-(0.0004*F19)),IF($B$14=\"Existing Building\",0.62-(0.0019*F19),0.67-(0.0005*F19))))/H19)+IF(I19=\"Et\",IF($B$14=\"Existing Building\",(((G19/0.8+110*SQRT(F19))/1000)-J19)/G19,(((G19/0.799+16.6*SQRT(F19))/1000)-J19)/G19),0))*VLOOKUP(K19,EUD,2,FALSE)*L19/100)))))","v":0},0,0,0,0,0,0,0,0,{"$f":"IFERROR(IF(IF(C19=\"T\",(1-(IF(I19=\"Et\",0.8,IF(I19=\"UEF\",IF(AND(B19=\"R\",M19=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B19=\"R\",M19=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H19)+IF(OR(AND(B19=\"N\",I19=\"Et\")=TRUE,AND(B19=\"R\",I19=\"Et\",M19=\"Tank Type\")=TRUE)=TRUE,0.775*(G19)^-0.778,0))*VLOOKUP(K19,EUD,2,FALSE)*L19/100,(1-(IF(I19=\"Et\",0.8,IF(I19=\"UEF\",IF(F19<=55,0.6483-(0.0017*F19),0.7897-(0.0004*F19)),IF($B$14=\"Existing Building\",0.62-(0.0019*F19),0.67-(0.0005*F19))))/H19)+IF(I19=\"Et\",IF($B$14=\"Existing Building\",(((G19/0.8+110*SQRT(F19))/1000)-J19)/G19,(((G19/0.799+16.6*SQRT(F19))/1000)-J19)/G19),0))*VLOOKUP(K19,EUD,2,FALSE)*L19/100)>0,\"Yes\",\"No\"),\"\")","v":""}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(Q20=0,0,O20*IF(C20=\"LF\",(Table!$B$20-N20)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C20=\"LS\",(Table!$B$21-N20)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C20=\"B\",-G20/100*1000,IF(C20=\"T\",(1-(IF(I20=\"Et\",0.8,IF(I20=\"UEF\",IF(AND(B20=\"R\",M20=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B20=\"R\",M20=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H20)+IF(OR(AND(B20=\"N\",I20=\"Et\")=TRUE,AND(B20=\"R\",I20=\"Et\",M20=\"Tank Type\")=TRUE)=TRUE,0.775*(G20)^-0.778,0))*VLOOKUP(K20,EUD,2,FALSE)*L20/100,(1-(IF(I20=\"Et\",0.8,IF(I20=\"UEF\",IF(F20<=55,0.6483-(0.0017*F20),0.7897-(0.0004*F20)),IF($B$14=\"Existing Building\",0.62-(0.0019*F20),0.67-(0.0005*F20))))/H20)+IF(I20=\"Et\",IF($B$14=\"Existing Building\",(((G20/0.8+110*SQRT(F20))/1000)-J20)/G20,(((G20/0.799+16.6*SQRT(F20))/1000)-J20)/G20),0))*VLOOKUP(K20,EUD,2,FALSE)*L20/100)))))","v":0},{"$f":"IF(Q20=0,0,P20*IF(C20=\"LF\",(Table!$B$20-N20)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C20=\"LS\",(Table!$B$21-N20)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C20=\"B\",-G20/100*1000,IF(C20=\"T\",(1-(IF(I20=\"Et\",0.8,IF(I20=\"UEF\",IF(AND(B20=\"R\",M20=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B20=\"R\",M20=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H20)+IF(OR(AND(B20=\"N\",I20=\"Et\")=TRUE,AND(B20=\"R\",I20=\"Et\",M20=\"Tank Type\")=TRUE)=TRUE,0.775*(G20)^-0.778,0))*VLOOKUP(K20,EUD,2,FALSE)*L20/100,(1-(IF(I20=\"Et\",0.8,IF(I20=\"UEF\",IF(F20<=55,0.6483-(0.0017*F20),0.7897-(0.0004*F20)),IF($B$14=\"Existing Building\",0.62-(0.0019*F20),0.67-(0.0005*F20))))/H20)+IF(I20=\"Et\",IF($B$14=\"Existing Building\",(((G20/0.8+110*SQRT(F20))/1000)-J20)/G20,(((G20/0.799+16.6*SQRT(F20))/1000)-J20)/G20),0))*VLOOKUP(K20,EUD,2,FALSE)*L20/100)))))","v":0},0,0,0,0,0,0,0,0,{"$f":"IFERROR(IF(IF(C20=\"T\",(1-(IF(I20=\"Et\",0.8,IF(I20=\"UEF\",IF(AND(B20=\"R\",M20=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B20=\"R\",M20=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H20)+IF(OR(AND(B20=\"N\",I20=\"Et\")=TRUE,AND(B20=\"R\",I20=\"Et\",M20=\"Tank Type\")=TRUE)=TRUE,0.775*(G20)^-0.778,0))*VLOOKUP(K20,EUD,2,FALSE)*L20/100,(1-(IF(I20=\"Et\",0.8,IF(I20=\"UEF\",IF(F20<=55,0.6483-(0.0017*F20),0.7897-(0.0004*F20)),IF($B$14=\"Existing Building\",0.62-(0.0019*F20),0.67-(0.0005*F20))))/H20)+IF(I20=\"Et\",IF($B$14=\"Existing Building\",(((G20/0.8+110*SQRT(F20))/1000)-J20)/G20,(((G20/0.799+16.6*SQRT(F20))/1000)-J20)/G20),0))*VLOOKUP(K20,EUD,2,FALSE)*L20/100)>0,\"Yes\",\"No\"),\"\")","v":""}]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(Q21=0,0,O21*IF(C21=\"LF\",(Table!$B$20-N21)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C21=\"LS\",(Table!$B$21-N21)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C21=\"B\",-G21/100*1000,IF(C21=\"T\",(1-(IF(I21=\"Et\",0.8,IF(I21=\"UEF\",IF(AND(B21=\"R\",M21=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B21=\"R\",M21=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H21)+IF(OR(AND(B21=\"N\",I21=\"Et\")=TRUE,AND(B21=\"R\",I21=\"Et\",M21=\"Tank Type\")=TRUE)=TRUE,0.775*(G21)^-0.778,0))*VLOOKUP(K21,EUD,2,FALSE)*L21/100,(1-(IF(I21=\"Et\",0.8,IF(I21=\"UEF\",IF(F21<=55,0.6483-(0.0017*F21),0.7897-(0.0004*F21)),IF($B$14=\"Existing Building\",0.62-(0.0019*F21),0.67-(0.0005*F21))))/H21)+IF(I21=\"Et\",IF($B$14=\"Existing Building\",(((G21/0.8+110*SQRT(F21))/1000)-J21)/G21,(((G21/0.799+16.6*SQRT(F21))/1000)-J21)/G21),0))*VLOOKUP(K21,EUD,2,FALSE)*L21/100)))))","v":0},{"$f":"IF(Q21=0,0,P21*IF(C21=\"LF\",(Table!$B$20-N21)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C21=\"LS\",(Table!$B$21-N21)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C21=\"B\",-G21/100*1000,IF(C21=\"T\",(1-(IF(I21=\"Et\",0.8,IF(I21=\"UEF\",IF(AND(B21=\"R\",M21=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B21=\"R\",M21=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H21)+IF(OR(AND(B21=\"N\",I21=\"Et\")=TRUE,AND(B21=\"R\",I21=\"Et\",M21=\"Tank Type\")=TRUE)=TRUE,0.775*(G21)^-0.778,0))*VLOOKUP(K21,EUD,2,FALSE)*L21/100,(1-(IF(I21=\"Et\",0.8,IF(I21=\"UEF\",IF(F21<=55,0.6483-(0.0017*F21),0.7897-(0.0004*F21)),IF($B$14=\"Existing Building\",0.62-(0.0019*F21),0.67-(0.0005*F21))))/H21)+IF(I21=\"Et\",IF($B$14=\"Existing Building\",(((G21/0.8+110*SQRT(F21))/1000)-J21)/G21,(((G21/0.799+16.6*SQRT(F21))/1000)-J21)/G21),0))*VLOOKUP(K21,EUD,2,FALSE)*L21/100)))))","v":0},0,0,0,0,0,0,0,0,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(Q22=0,0,O22*IF(C22=\"LF\",(Table!$B$20-N22)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C22=\"LS\",(Table!$B$21-N22)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C22=\"B\",-G22/100*1000,IF(C22=\"T\",(1-(IF(I22=\"Et\",0.8,IF(I22=\"UEF\",IF(AND(B22=\"R\",M22=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B22=\"R\",M22=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H22)+IF(OR(AND(B22=\"N\",I22=\"Et\")=TRUE,AND(B22=\"R\",I22=\"Et\",M22=\"Tank Type\")=TRUE)=TRUE,0.775*(G22)^-0.778,0))*VLOOKUP(K22,EUD,2,FALSE)*L22/100,(1-(IF(I22=\"Et\",0.8,IF(I22=\"UEF\",IF(F22<=55,0.6483-(0.0017*F22),0.7897-(0.0004*F22)),IF($B$14=\"Existing Building\",0.62-(0.0019*F22),0.67-(0.0005*F22))))/H22)+IF(I22=\"Et\",IF($B$14=\"Existing Building\",(((G22/0.8+110*SQRT(F22))/1000)-J22)/G22,(((G22/0.799+16.6*SQRT(F22))/1000)-J22)/G22),0))*VLOOKUP(K22,EUD,2,FALSE)*L22/100)))))","v":0},{"$f":"IF(Q22=0,0,P22*IF(C22=\"LF\",(Table!$B$20-N22)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C22=\"LS\",(Table!$B$21-N22)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C22=\"B\",-G22/100*1000,IF(C22=\"T\",(1-(IF(I22=\"Et\",0.8,IF(I22=\"UEF\",IF(AND(B22=\"R\",M22=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B22=\"R\",M22=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H22)+IF(OR(AND(B22=\"N\",I22=\"Et\")=TRUE,AND(B22=\"R\",I22=\"Et\",M22=\"Tank Type\")=TRUE)=TRUE,0.775*(G22)^-0.778,0))*VLOOKUP(K22,EUD,2,FALSE)*L22/100,(1-(IF(I22=\"Et\",0.8,IF(I22=\"UEF\",IF(F22<=55,0.6483-(0.0017*F22),0.7897-(0.0004*F22)),IF($B$14=\"Existing Building\",0.62-(0.0019*F22),0.67-(0.0005*F22))))/H22)+IF(I22=\"Et\",IF($B$14=\"Existing Building\",(((G22/0.8+110*SQRT(F22))/1000)-J22)/G22,(((G22/0.799+16.6*SQRT(F22))/1000)-J22)/G22),0))*VLOOKUP(K22,EUD,2,FALSE)*L22/100)))))","v":0},0,0,0,0,0,0,0,0,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(Q23=0,0,O23*IF(C23=\"LF\",(Table!$B$20-N23)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C23=\"LS\",(Table!$B$21-N23)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C23=\"B\",-G23/100*1000,IF(C23=\"T\",(1-(IF(I23=\"Et\",0.8,IF(I23=\"UEF\",IF(AND(B23=\"R\",M23=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B23=\"R\",M23=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H23)+IF(OR(AND(B23=\"N\",I23=\"Et\")=TRUE,AND(B23=\"R\",I23=\"Et\",M23=\"Tank Type\")=TRUE)=TRUE,0.775*(G23)^-0.778,0))*VLOOKUP(K23,EUD,2,FALSE)*L23/100,(1-(IF(I23=\"Et\",0.8,IF(I23=\"UEF\",IF(F23<=55,0.6483-(0.0017*F23),0.7897-(0.0004*F23)),IF($B$14=\"Existing Building\",0.62-(0.0019*F23),0.67-(0.0005*F23))))/H23)+IF(I23=\"Et\",IF($B$14=\"Existing Building\",(((G23/0.8+110*SQRT(F23))/1000)-J23)/G23,(((G23/0.799+16.6*SQRT(F23))/1000)-J23)/G23),0))*VLOOKUP(K23,EUD,2,FALSE)*L23/100)))))","v":0},{"$f":"IF(Q23=0,0,P23*IF(C23=\"LF\",(Table!$B$20-N23)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C23=\"LS\",(Table!$B$21-N23)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C23=\"B\",-G23/100*1000,IF(C23=\"T\",(1-(IF(I23=\"Et\",0.8,IF(I23=\"UEF\",IF(AND(B23=\"R\",M23=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B23=\"R\",M23=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H23)+IF(OR(AND(B23=\"N\",I23=\"Et\")=TRUE,AND(B23=\"R\",I23=\"Et\",M23=\"Tank Type\")=TRUE)=TRUE,0.775*(G23)^-0.778,0))*VLOOKUP(K23,EUD,2,FALSE)*L23/100,(1-(IF(I23=\"Et\",0.8,IF(I23=\"UEF\",IF(F23<=55,0.6483-(0.0017*F23),0.7897-(0.0004*F23)),IF($B$14=\"Existing Building\",0.62-(0.0019*F23),0.67-(0.0005*F23))))/H23)+IF(I23=\"Et\",IF($B$14=\"Existing Building\",(((G23/0.8+110*SQRT(F23))/1000)-J23)/G23,(((G23/0.799+16.6*SQRT(F23))/1000)-J23)/G23),0))*VLOOKUP(K23,EUD,2,FALSE)*L23/100)))))","v":0},0,0,0,0,0,0,0,0,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(Q24=0,0,O24*IF(C24=\"LF\",(Table!$B$20-N24)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C24=\"LS\",(Table!$B$21-N24)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C24=\"B\",-G24/100*1000,IF(C24=\"T\",(1-(IF(I24=\"Et\",0.8,IF(I24=\"UEF\",IF(AND(B24=\"R\",M24=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B24=\"R\",M24=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H24)+IF(OR(AND(B24=\"N\",I24=\"Et\")=TRUE,AND(B24=\"R\",I24=\"Et\",M24=\"Tank Type\")=TRUE)=TRUE,0.775*(G24)^-0.778,0))*VLOOKUP(K24,EUD,2,FALSE)*L24/100,(1-(IF(I24=\"Et\",0.8,IF(I24=\"UEF\",IF(F24<=55,0.6483-(0.0017*F24),0.7897-(0.0004*F24)),IF($B$14=\"Existing Building\",0.62-(0.0019*F24),0.67-(0.0005*F24))))/H24)+IF(I24=\"Et\",IF($B$14=\"Existing Building\",(((G24/0.8+110*SQRT(F24))/1000)-J24)/G24,(((G24/0.799+16.6*SQRT(F24))/1000)-J24)/G24),0))*VLOOKUP(K24,EUD,2,FALSE)*L24/100)))))","v":0},{"$f":"IF(Q24=0,0,P24*IF(C24=\"LF\",(Table!$B$20-N24)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C24=\"LS\",(Table!$B$21-N24)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C24=\"B\",-G24/100*1000,IF(C24=\"T\",(1-(IF(I24=\"Et\",0.8,IF(I24=\"UEF\",IF(AND(B24=\"R\",M24=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B24=\"R\",M24=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H24)+IF(OR(AND(B24=\"N\",I24=\"Et\")=TRUE,AND(B24=\"R\",I24=\"Et\",M24=\"Tank Type\")=TRUE)=TRUE,0.775*(G24)^-0.778,0))*VLOOKUP(K24,EUD,2,FALSE)*L24/100,(1-(IF(I24=\"Et\",0.8,IF(I24=\"UEF\",IF(F24<=55,0.6483-(0.0017*F24),0.7897-(0.0004*F24)),IF($B$14=\"Existing Building\",0.62-(0.0019*F24),0.67-(0.0005*F24))))/H24)+IF(I24=\"Et\",IF($B$14=\"Existing Building\",(((G24/0.8+110*SQRT(F24))/1000)-J24)/G24,(((G24/0.799+16.6*SQRT(F24))/1000)-J24)/G24),0))*VLOOKUP(K24,EUD,2,FALSE)*L24/100)))))","v":0},0,0,0,0,0,0,0,0,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(Q25=0,0,O25*IF(C25=\"LF\",(Table!$B$20-N25)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C25=\"LS\",(Table!$B$21-N25)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C25=\"B\",-G25/100*1000,IF(C25=\"T\",(1-(IF(I25=\"Et\",0.8,IF(I25=\"UEF\",IF(AND(B25=\"R\",M25=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B25=\"R\",M25=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H25)+IF(OR(AND(B25=\"N\",I25=\"Et\")=TRUE,AND(B25=\"R\",I25=\"Et\",M25=\"Tank Type\")=TRUE)=TRUE,0.775*(G25)^-0.778,0))*VLOOKUP(K25,EUD,2,FALSE)*L25/100,(1-(IF(I25=\"Et\",0.8,IF(I25=\"UEF\",IF(F25<=55,0.6483-(0.0017*F25),0.7897-(0.0004*F25)),IF($B$14=\"Existing Building\",0.62-(0.0019*F25),0.67-(0.0005*F25))))/H25)+IF(I25=\"Et\",IF($B$14=\"Existing Building\",(((G25/0.8+110*SQRT(F25))/1000)-J25)/G25,(((G25/0.799+16.6*SQRT(F25))/1000)-J25)/G25),0))*VLOOKUP(K25,EUD,2,FALSE)*L25/100)))))","v":0},{"$f":"IF(Q25=0,0,P25*IF(C25=\"LF\",(Table!$B$20-N25)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C25=\"LS\",(Table!$B$21-N25)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C25=\"B\",-G25/100*1000,IF(C25=\"T\",(1-(IF(I25=\"Et\",0.8,IF(I25=\"UEF\",IF(AND(B25=\"R\",M25=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B25=\"R\",M25=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H25)+IF(OR(AND(B25=\"N\",I25=\"Et\")=TRUE,AND(B25=\"R\",I25=\"Et\",M25=\"Tank Type\")=TRUE)=TRUE,0.775*(G25)^-0.778,0))*VLOOKUP(K25,EUD,2,FALSE)*L25/100,(1-(IF(I25=\"Et\",0.8,IF(I25=\"UEF\",IF(F25<=55,0.6483-(0.0017*F25),0.7897-(0.0004*F25)),IF($B$14=\"Existing Building\",0.62-(0.0019*F25),0.67-(0.0005*F25))))/H25)+IF(I25=\"Et\",IF($B$14=\"Existing Building\",(((G25/0.8+110*SQRT(F25))/1000)-J25)/G25,(((G25/0.799+16.6*SQRT(F25))/1000)-J25)/G25),0))*VLOOKUP(K25,EUD,2,FALSE)*L25/100)))))","v":0},0,0,0,0,0,0,0,0,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(Q26=0,0,O26*IF(C26=\"LF\",(Table!$B$20-N26)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C26=\"LS\",(Table!$B$21-N26)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C26=\"B\",-G26/100*1000,IF(C26=\"T\",(1-(IF(I26=\"Et\",0.8,IF(I26=\"UEF\",IF(AND(B26=\"R\",M26=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B26=\"R\",M26=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H26)+IF(OR(AND(B26=\"N\",I26=\"Et\")=TRUE,AND(B26=\"R\",I26=\"Et\",M26=\"Tank Type\")=TRUE)=TRUE,0.775*(G26)^-0.778,0))*VLOOKUP(K26,EUD,2,FALSE)*L26/100,(1-(IF(I26=\"Et\",0.8,IF(I26=\"UEF\",IF(F26<=55,0.6483-(0.0017*F26),0.7897-(0.0004*F26)),IF($B$14=\"Existing Building\",0.62-(0.0019*F26),0.67-(0.0005*F26))))/H26)+IF(I26=\"Et\",IF($B$14=\"Existing Building\",(((G26/0.8+110*SQRT(F26))/1000)-J26)/G26,(((G26/0.799+16.6*SQRT(F26))/1000)-J26)/G26),0))*VLOOKUP(K26,EUD,2,FALSE)*L26/100)))))","v":0},{"$f":"IF(Q26=0,0,P26*IF(C26=\"LF\",(Table!$B$20-N26)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C26=\"LS\",(Table!$B$21-N26)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C26=\"B\",-G26/100*1000,IF(C26=\"T\",(1-(IF(I26=\"Et\",0.8,IF(I26=\"UEF\",IF(AND(B26=\"R\",M26=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B26=\"R\",M26=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H26)+IF(OR(AND(B26=\"N\",I26=\"Et\")=TRUE,AND(B26=\"R\",I26=\"Et\",M26=\"Tank Type\")=TRUE)=TRUE,0.775*(G26)^-0.778,0))*VLOOKUP(K26,EUD,2,FALSE)*L26/100,(1-(IF(I26=\"Et\",0.8,IF(I26=\"UEF\",IF(F26<=55,0.6483-(0.0017*F26),0.7897-(0.0004*F26)),IF($B$14=\"Existing Building\",0.62-(0.0019*F26),0.67-(0.0005*F26))))/H26)+IF(I26=\"Et\",IF($B$14=\"Existing Building\",(((G26/0.8+110*SQRT(F26))/1000)-J26)/G26,(((G26/0.799+16.6*SQRT(F26))/1000)-J26)/G26),0))*VLOOKUP(K26,EUD,2,FALSE)*L26/100)))))","v":0},0,0,0,0,0,0,0,0,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(Q27=0,0,O27*IF(C27=\"LF\",(Table!$B$20-N27)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C27=\"LS\",(Table!$B$21-N27)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C27=\"B\",-G27/100*1000,IF(C27=\"T\",(1-(IF(I27=\"Et\",0.8,IF(I27=\"UEF\",IF(AND(B27=\"R\",M27=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B27=\"R\",M27=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H27)+IF(OR(AND(B27=\"N\",I27=\"Et\")=TRUE,AND(B27=\"R\",I27=\"Et\",M27=\"Tank Type\")=TRUE)=TRUE,0.775*(G27)^-0.778,0))*VLOOKUP(K27,EUD,2,FALSE)*L27/100,(1-(IF(I27=\"Et\",0.8,IF(I27=\"UEF\",IF(F27<=55,0.6483-(0.0017*F27),0.7897-(0.0004*F27)),IF($B$14=\"Existing Building\",0.62-(0.0019*F27),0.67-(0.0005*F27))))/H27)+IF(I27=\"Et\",IF($B$14=\"Existing Building\",(((G27/0.8+110*SQRT(F27))/1000)-J27)/G27,(((G27/0.799+16.6*SQRT(F27))/1000)-J27)/G27),0))*VLOOKUP(K27,EUD,2,FALSE)*L27/100)))))","v":0},{"$f":"IF(Q27=0,0,P27*IF(C27=\"LF\",(Table!$B$20-N27)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C27=\"LS\",(Table!$B$21-N27)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C27=\"B\",-G27/100*1000,IF(C27=\"T\",(1-(IF(I27=\"Et\",0.8,IF(I27=\"UEF\",IF(AND(B27=\"R\",M27=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B27=\"R\",M27=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H27)+IF(OR(AND(B27=\"N\",I27=\"Et\")=TRUE,AND(B27=\"R\",I27=\"Et\",M27=\"Tank Type\")=TRUE)=TRUE,0.775*(G27)^-0.778,0))*VLOOKUP(K27,EUD,2,FALSE)*L27/100,(1-(IF(I27=\"Et\",0.8,IF(I27=\"UEF\",IF(F27<=55,0.6483-(0.0017*F27),0.7897-(0.0004*F27)),IF($B$14=\"Existing Building\",0.62-(0.0019*F27),0.67-(0.0005*F27))))/H27)+IF(I27=\"Et\",IF($B$14=\"Existing Building\",(((G27/0.8+110*SQRT(F27))/1000)-J27)/G27,(((G27/0.799+16.6*SQRT(F27))/1000)-J27)/G27),0))*VLOOKUP(K27,EUD,2,FALSE)*L27/100)))))","v":0},0,0,0,0,0,0,0,0,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(Q28=0,0,O28*IF(C28=\"LF\",(Table!$B$20-N28)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C28=\"LS\",(Table!$B$21-N28)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C28=\"B\",-G28/100*1000,IF(C28=\"T\",(1-(IF(I28=\"Et\",0.8,IF(I28=\"UEF\",IF(AND(B28=\"R\",M28=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B28=\"R\",M28=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H28)+IF(OR(AND(B28=\"N\",I28=\"Et\")=TRUE,AND(B28=\"R\",I28=\"Et\",M28=\"Tank Type\")=TRUE)=TRUE,0.775*(G28)^-0.778,0))*VLOOKUP(K28,EUD,2,FALSE)*L28/100,(1-(IF(I28=\"Et\",0.8,IF(I28=\"UEF\",IF(F28<=55,0.6483-(0.0017*F28),0.7897-(0.0004*F28)),IF($B$14=\"Existing Building\",0.62-(0.0019*F28),0.67-(0.0005*F28))))/H28)+IF(I28=\"Et\",IF($B$14=\"Existing Building\",(((G28/0.8+110*SQRT(F28))/1000)-J28)/G28,(((G28/0.799+16.6*SQRT(F28))/1000)-J28)/G28),0))*VLOOKUP(K28,EUD,2,FALSE)*L28/100)))))","v":0},{"$f":"IF(Q28=0,0,P28*IF(C28=\"LF\",(Table!$B$20-N28)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C28=\"LS\",(Table!$B$21-N28)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C28=\"B\",-G28/100*1000,IF(C28=\"T\",(1-(IF(I28=\"Et\",0.8,IF(I28=\"UEF\",IF(AND(B28=\"R\",M28=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B28=\"R\",M28=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H28)+IF(OR(AND(B28=\"N\",I28=\"Et\")=TRUE,AND(B28=\"R\",I28=\"Et\",M28=\"Tank Type\")=TRUE)=TRUE,0.775*(G28)^-0.778,0))*VLOOKUP(K28,EUD,2,FALSE)*L28/100,(1-(IF(I28=\"Et\",0.8,IF(I28=\"UEF\",IF(F28<=55,0.6483-(0.0017*F28),0.7897-(0.0004*F28)),IF($B$14=\"Existing Building\",0.62-(0.0019*F28),0.67-(0.0005*F28))))/H28)+IF(I28=\"Et\",IF($B$14=\"Existing Building\",(((G28/0.8+110*SQRT(F28))/1000)-J28)/G28,(((G28/0.799+16.6*SQRT(F28))/1000)-J28)/G28),0))*VLOOKUP(K28,EUD,2,FALSE)*L28/100)))))","v":0},0,0,0,0,0,0,0,0,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(Q29=0,0,O29*IF(C29=\"LF\",(Table!$B$20-N29)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C29=\"LS\",(Table!$B$21-N29)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C29=\"B\",-G29/100*1000,IF(C29=\"T\",(1-(IF(I29=\"Et\",0.8,IF(I29=\"UEF\",IF(AND(B29=\"R\",M29=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B29=\"R\",M29=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H29)+IF(OR(AND(B29=\"N\",I29=\"Et\")=TRUE,AND(B29=\"R\",I29=\"Et\",M29=\"Tank Type\")=TRUE)=TRUE,0.775*(G29)^-0.778,0))*VLOOKUP(K29,EUD,2,FALSE)*L29/100,(1-(IF(I29=\"Et\",0.8,IF(I29=\"UEF\",IF(F29<=55,0.6483-(0.0017*F29),0.7897-(0.0004*F29)),IF($B$14=\"Existing Building\",0.62-(0.0019*F29),0.67-(0.0005*F29))))/H29)+IF(I29=\"Et\",IF($B$14=\"Existing Building\",(((G29/0.8+110*SQRT(F29))/1000)-J29)/G29,(((G29/0.799+16.6*SQRT(F29))/1000)-J29)/G29),0))*VLOOKUP(K29,EUD,2,FALSE)*L29/100)))))","v":0},{"$f":"IF(Q29=0,0,P29*IF(C29=\"LF\",(Table!$B$20-N29)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C29=\"LS\",(Table!$B$21-N29)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C29=\"B\",-G29/100*1000,IF(C29=\"T\",(1-(IF(I29=\"Et\",0.8,IF(I29=\"UEF\",IF(AND(B29=\"R\",M29=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B29=\"R\",M29=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H29)+IF(OR(AND(B29=\"N\",I29=\"Et\")=TRUE,AND(B29=\"R\",I29=\"Et\",M29=\"Tank Type\")=TRUE)=TRUE,0.775*(G29)^-0.778,0))*VLOOKUP(K29,EUD,2,FALSE)*L29/100,(1-(IF(I29=\"Et\",0.8,IF(I29=\"UEF\",IF(F29<=55,0.6483-(0.0017*F29),0.7897-(0.0004*F29)),IF($B$14=\"Existing Building\",0.62-(0.0019*F29),0.67-(0.0005*F29))))/H29)+IF(I29=\"Et\",IF($B$14=\"Existing Building\",(((G29/0.8+110*SQRT(F29))/1000)-J29)/G29,(((G29/0.799+16.6*SQRT(F29))/1000)-J29)/G29),0))*VLOOKUP(K29,EUD,2,FALSE)*L29/100)))))","v":0},0,0,0,0,0,0,0,0,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(Q30=0,0,O30*IF(C30=\"LF\",(Table!$B$20-N30)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C30=\"LS\",(Table!$B$21-N30)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C30=\"B\",-G30/100*1000,IF(C30=\"T\",(1-(IF(I30=\"Et\",0.8,IF(I30=\"UEF\",IF(AND(B30=\"R\",M30=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B30=\"R\",M30=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H30)+IF(OR(AND(B30=\"N\",I30=\"Et\")=TRUE,AND(B30=\"R\",I30=\"Et\",M30=\"Tank Type\")=TRUE)=TRUE,0.775*(G30)^-0.778,0))*VLOOKUP(K30,EUD,2,FALSE)*L30/100,(1-(IF(I30=\"Et\",0.8,IF(I30=\"UEF\",IF(F30<=55,0.6483-(0.0017*F30),0.7897-(0.0004*F30)),IF($B$14=\"Existing Building\",0.62-(0.0019*F30),0.67-(0.0005*F30))))/H30)+IF(I30=\"Et\",IF($B$14=\"Existing Building\",(((G30/0.8+110*SQRT(F30))/1000)-J30)/G30,(((G30/0.799+16.6*SQRT(F30))/1000)-J30)/G30),0))*VLOOKUP(K30,EUD,2,FALSE)*L30/100)))))","v":0},{"$f":"IF(Q30=0,0,P30*IF(C30=\"LF\",(Table!$B$20-N30)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C30=\"LS\",(Table!$B$21-N30)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C30=\"B\",-G30/100*1000,IF(C30=\"T\",(1-(IF(I30=\"Et\",0.8,IF(I30=\"UEF\",IF(AND(B30=\"R\",M30=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B30=\"R\",M30=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H30)+IF(OR(AND(B30=\"N\",I30=\"Et\")=TRUE,AND(B30=\"R\",I30=\"Et\",M30=\"Tank Type\")=TRUE)=TRUE,0.775*(G30)^-0.778,0))*VLOOKUP(K30,EUD,2,FALSE)*L30/100,(1-(IF(I30=\"Et\",0.8,IF(I30=\"UEF\",IF(F30<=55,0.6483-(0.0017*F30),0.7897-(0.0004*F30)),IF($B$14=\"Existing Building\",0.62-(0.0019*F30),0.67-(0.0005*F30))))/H30)+IF(I30=\"Et\",IF($B$14=\"Existing Building\",(((G30/0.8+110*SQRT(F30))/1000)-J30)/G30,(((G30/0.799+16.6*SQRT(F30))/1000)-J30)/G30),0))*VLOOKUP(K30,EUD,2,FALSE)*L30/100)))))","v":0},0,0,0,0,0,0,0,0,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(Q31=0,0,O31*IF(C31=\"LF\",(Table!$B$20-N31)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C31=\"LS\",(Table!$B$21-N31)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C31=\"B\",-G31/100*1000,IF(C31=\"T\",(1-(IF(I31=\"Et\",0.8,IF(I31=\"UEF\",IF(AND(B31=\"R\",M31=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B31=\"R\",M31=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H31)+IF(OR(AND(B31=\"N\",I31=\"Et\")=TRUE,AND(B31=\"R\",I31=\"Et\",M31=\"Tank Type\")=TRUE)=TRUE,0.775*(G31)^-0.778,0))*VLOOKUP(K31,EUD,2,FALSE)*L31/100,(1-(IF(I31=\"Et\",0.8,IF(I31=\"UEF\",IF(F31<=55,0.6483-(0.0017*F31),0.7897-(0.0004*F31)),IF($B$14=\"Existing Building\",0.62-(0.0019*F31),0.67-(0.0005*F31))))/H31)+IF(I31=\"Et\",IF($B$14=\"Existing Building\",(((G31/0.8+110*SQRT(F31))/1000)-J31)/G31,(((G31/0.799+16.6*SQRT(F31))/1000)-J31)/G31),0))*VLOOKUP(K31,EUD,2,FALSE)*L31/100)))))","v":0},{"$f":"IF(Q31=0,0,P31*IF(C31=\"LF\",(Table!$B$20-N31)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C31=\"LS\",(Table!$B$21-N31)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C31=\"B\",-G31/100*1000,IF(C31=\"T\",(1-(IF(I31=\"Et\",0.8,IF(I31=\"UEF\",IF(AND(B31=\"R\",M31=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B31=\"R\",M31=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H31)+IF(OR(AND(B31=\"N\",I31=\"Et\")=TRUE,AND(B31=\"R\",I31=\"Et\",M31=\"Tank Type\")=TRUE)=TRUE,0.775*(G31)^-0.778,0))*VLOOKUP(K31,EUD,2,FALSE)*L31/100,(1-(IF(I31=\"Et\",0.8,IF(I31=\"UEF\",IF(F31<=55,0.6483-(0.0017*F31),0.7897-(0.0004*F31)),IF($B$14=\"Existing Building\",0.62-(0.0019*F31),0.67-(0.0005*F31))))/H31)+IF(I31=\"Et\",IF($B$14=\"Existing Building\",(((G31/0.8+110*SQRT(F31))/1000)-J31)/G31,(((G31/0.799+16.6*SQRT(F31))/1000)-J31)/G31),0))*VLOOKUP(K31,EUD,2,FALSE)*L31/100)))))","v":0},0,0,0,0,0,0,0,0,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(Q32=0,0,O32*IF(C32=\"LF\",(Table!$B$20-N32)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C32=\"LS\",(Table!$B$21-N32)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C32=\"B\",-G32/100*1000,IF(C32=\"T\",(1-(IF(I32=\"Et\",0.8,IF(I32=\"UEF\",IF(AND(B32=\"R\",M32=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B32=\"R\",M32=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H32)+IF(OR(AND(B32=\"N\",I32=\"Et\")=TRUE,AND(B32=\"R\",I32=\"Et\",M32=\"Tank Type\")=TRUE)=TRUE,0.775*(G32)^-0.778,0))*VLOOKUP(K32,EUD,2,FALSE)*L32/100,(1-(IF(I32=\"Et\",0.8,IF(I32=\"UEF\",IF(F32<=55,0.6483-(0.0017*F32),0.7897-(0.0004*F32)),IF($B$14=\"Existing Building\",0.62-(0.0019*F32),0.67-(0.0005*F32))))/H32)+IF(I32=\"Et\",IF($B$14=\"Existing Building\",(((G32/0.8+110*SQRT(F32))/1000)-J32)/G32,(((G32/0.799+16.6*SQRT(F32))/1000)-J32)/G32),0))*VLOOKUP(K32,EUD,2,FALSE)*L32/100)))))","v":0},{"$f":"IF(Q32=0,0,P32*IF(C32=\"LF\",(Table!$B$20-N32)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C32=\"LS\",(Table!$B$21-N32)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C32=\"B\",-G32/100*1000,IF(C32=\"T\",(1-(IF(I32=\"Et\",0.8,IF(I32=\"UEF\",IF(AND(B32=\"R\",M32=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B32=\"R\",M32=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H32)+IF(OR(AND(B32=\"N\",I32=\"Et\")=TRUE,AND(B32=\"R\",I32=\"Et\",M32=\"Tank Type\")=TRUE)=TRUE,0.775*(G32)^-0.778,0))*VLOOKUP(K32,EUD,2,FALSE)*L32/100,(1-(IF(I32=\"Et\",0.8,IF(I32=\"UEF\",IF(F32<=55,0.6483-(0.0017*F32),0.7897-(0.0004*F32)),IF($B$14=\"Existing Building\",0.62-(0.0019*F32),0.67-(0.0005*F32))))/H32)+IF(I32=\"Et\",IF($B$14=\"Existing Building\",(((G32/0.8+110*SQRT(F32))/1000)-J32)/G32,(((G32/0.799+16.6*SQRT(F32))/1000)-J32)/G32),0))*VLOOKUP(K32,EUD,2,FALSE)*L32/100)))))","v":0},0,0,0,0,0,0,0,0,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(Q33=0,0,O33*IF(C33=\"LF\",(Table!$B$20-N33)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C33=\"LS\",(Table!$B$21-N33)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C33=\"B\",-G33/100*1000,IF(C33=\"T\",(1-(IF(I33=\"Et\",0.8,IF(I33=\"UEF\",IF(AND(B33=\"R\",M33=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B33=\"R\",M33=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H33)+IF(OR(AND(B33=\"N\",I33=\"Et\")=TRUE,AND(B33=\"R\",I33=\"Et\",M33=\"Tank Type\")=TRUE)=TRUE,0.775*(G33)^-0.778,0))*VLOOKUP(K33,EUD,2,FALSE)*L33/100,(1-(IF(I33=\"Et\",0.8,IF(I33=\"UEF\",IF(F33<=55,0.6483-(0.0017*F33),0.7897-(0.0004*F33)),IF($B$14=\"Existing Building\",0.62-(0.0019*F33),0.67-(0.0005*F33))))/H33)+IF(I33=\"Et\",IF($B$14=\"Existing Building\",(((G33/0.8+110*SQRT(F33))/1000)-J33)/G33,(((G33/0.799+16.6*SQRT(F33))/1000)-J33)/G33),0))*VLOOKUP(K33,EUD,2,FALSE)*L33/100)))))","v":0},{"$f":"IF(Q33=0,0,P33*IF(C33=\"LF\",(Table!$B$20-N33)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C33=\"LS\",(Table!$B$21-N33)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C33=\"B\",-G33/100*1000,IF(C33=\"T\",(1-(IF(I33=\"Et\",0.8,IF(I33=\"UEF\",IF(AND(B33=\"R\",M33=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B33=\"R\",M33=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H33)+IF(OR(AND(B33=\"N\",I33=\"Et\")=TRUE,AND(B33=\"R\",I33=\"Et\",M33=\"Tank Type\")=TRUE)=TRUE,0.775*(G33)^-0.778,0))*VLOOKUP(K33,EUD,2,FALSE)*L33/100,(1-(IF(I33=\"Et\",0.8,IF(I33=\"UEF\",IF(F33<=55,0.6483-(0.0017*F33),0.7897-(0.0004*F33)),IF($B$14=\"Existing Building\",0.62-(0.0019*F33),0.67-(0.0005*F33))))/H33)+IF(I33=\"Et\",IF($B$14=\"Existing Building\",(((G33/0.8+110*SQRT(F33))/1000)-J33)/G33,(((G33/0.799+16.6*SQRT(F33))/1000)-J33)/G33),0))*VLOOKUP(K33,EUD,2,FALSE)*L33/100)))))","v":0},0,0,0,0,0,0,0,0,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(Q34=0,0,O34*IF(C34=\"LF\",(Table!$B$20-N34)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C34=\"LS\",(Table!$B$21-N34)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C34=\"B\",-G34/100*1000,IF(C34=\"T\",(1-(IF(I34=\"Et\",0.8,IF(I34=\"UEF\",IF(AND(B34=\"R\",M34=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B34=\"R\",M34=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H34)+IF(OR(AND(B34=\"N\",I34=\"Et\")=TRUE,AND(B34=\"R\",I34=\"Et\",M34=\"Tank Type\")=TRUE)=TRUE,0.775*(G34)^-0.778,0))*VLOOKUP(K34,EUD,2,FALSE)*L34/100,(1-(IF(I34=\"Et\",0.8,IF(I34=\"UEF\",IF(F34<=55,0.6483-(0.0017*F34),0.7897-(0.0004*F34)),IF($B$14=\"Existing Building\",0.62-(0.0019*F34),0.67-(0.0005*F34))))/H34)+IF(I34=\"Et\",IF($B$14=\"Existing Building\",(((G34/0.8+110*SQRT(F34))/1000)-J34)/G34,(((G34/0.799+16.6*SQRT(F34))/1000)-J34)/G34),0))*VLOOKUP(K34,EUD,2,FALSE)*L34/100)))))","v":0},{"$f":"IF(Q34=0,0,P34*IF(C34=\"LF\",(Table!$B$20-N34)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C34=\"LS\",(Table!$B$21-N34)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C34=\"B\",-G34/100*1000,IF(C34=\"T\",(1-(IF(I34=\"Et\",0.8,IF(I34=\"UEF\",IF(AND(B34=\"R\",M34=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B34=\"R\",M34=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H34)+IF(OR(AND(B34=\"N\",I34=\"Et\")=TRUE,AND(B34=\"R\",I34=\"Et\",M34=\"Tank Type\")=TRUE)=TRUE,0.775*(G34)^-0.778,0))*VLOOKUP(K34,EUD,2,FALSE)*L34/100,(1-(IF(I34=\"Et\",0.8,IF(I34=\"UEF\",IF(F34<=55,0.6483-(0.0017*F34),0.7897-(0.0004*F34)),IF($B$14=\"Existing Building\",0.62-(0.0019*F34),0.67-(0.0005*F34))))/H34)+IF(I34=\"Et\",IF($B$14=\"Existing Building\",(((G34/0.8+110*SQRT(F34))/1000)-J34)/G34,(((G34/0.799+16.6*SQRT(F34))/1000)-J34)/G34),0))*VLOOKUP(K34,EUD,2,FALSE)*L34/100)))))","v":0},0,0,0,0,0,0,0,0,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(Q35=0,0,O35*IF(C35=\"LF\",(Table!$B$20-N35)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C35=\"LS\",(Table!$B$21-N35)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C35=\"B\",-G35/100*1000,IF(C35=\"T\",(1-(IF(I35=\"Et\",0.8,IF(I35=\"UEF\",IF(AND(B35=\"R\",M35=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B35=\"R\",M35=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H35)+IF(OR(AND(B35=\"N\",I35=\"Et\")=TRUE,AND(B35=\"R\",I35=\"Et\",M35=\"Tank Type\")=TRUE)=TRUE,0.775*(G35)^-0.778,0))*VLOOKUP(K35,EUD,2,FALSE)*L35/100,(1-(IF(I35=\"Et\",0.8,IF(I35=\"UEF\",IF(F35<=55,0.6483-(0.0017*F35),0.7897-(0.0004*F35)),IF($B$14=\"Existing Building\",0.62-(0.0019*F35),0.67-(0.0005*F35))))/H35)+IF(I35=\"Et\",IF($B$14=\"Existing Building\",(((G35/0.8+110*SQRT(F35))/1000)-J35)/G35,(((G35/0.799+16.6*SQRT(F35))/1000)-J35)/G35),0))*VLOOKUP(K35,EUD,2,FALSE)*L35/100)))))","v":0},{"$f":"IF(Q35=0,0,P35*IF(C35=\"LF\",(Table!$B$20-N35)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C35=\"LS\",(Table!$B$21-N35)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C35=\"B\",-G35/100*1000,IF(C35=\"T\",(1-(IF(I35=\"Et\",0.8,IF(I35=\"UEF\",IF(AND(B35=\"R\",M35=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B35=\"R\",M35=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H35)+IF(OR(AND(B35=\"N\",I35=\"Et\")=TRUE,AND(B35=\"R\",I35=\"Et\",M35=\"Tank Type\")=TRUE)=TRUE,0.775*(G35)^-0.778,0))*VLOOKUP(K35,EUD,2,FALSE)*L35/100,(1-(IF(I35=\"Et\",0.8,IF(I35=\"UEF\",IF(F35<=55,0.6483-(0.0017*F35),0.7897-(0.0004*F35)),IF($B$14=\"Existing Building\",0.62-(0.0019*F35),0.67-(0.0005*F35))))/H35)+IF(I35=\"Et\",IF($B$14=\"Existing Building\",(((G35/0.8+110*SQRT(F35))/1000)-J35)/G35,(((G35/0.799+16.6*SQRT(F35))/1000)-J35)/G35),0))*VLOOKUP(K35,EUD,2,FALSE)*L35/100)))))","v":0},0,0,0,0,0,0,0,0,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(Q36=0,0,O36*IF(C36=\"LF\",(Table!$B$20-N36)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C36=\"LS\",(Table!$B$21-N36)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C36=\"B\",-G36/100*1000,IF(C36=\"T\",(1-(IF(I36=\"Et\",0.8,IF(I36=\"UEF\",IF(AND(B36=\"R\",M36=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B36=\"R\",M36=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H36)+IF(OR(AND(B36=\"N\",I36=\"Et\")=TRUE,AND(B36=\"R\",I36=\"Et\",M36=\"Tank Type\")=TRUE)=TRUE,0.775*(G36)^-0.778,0))*VLOOKUP(K36,EUD,2,FALSE)*L36/100,(1-(IF(I36=\"Et\",0.8,IF(I36=\"UEF\",IF(F36<=55,0.6483-(0.0017*F36),0.7897-(0.0004*F36)),IF($B$14=\"Existing Building\",0.62-(0.0019*F36),0.67-(0.0005*F36))))/H36)+IF(I36=\"Et\",IF($B$14=\"Existing Building\",(((G36/0.8+110*SQRT(F36))/1000)-J36)/G36,(((G36/0.799+16.6*SQRT(F36))/1000)-J36)/G36),0))*VLOOKUP(K36,EUD,2,FALSE)*L36/100)))))","v":0},{"$f":"IF(Q36=0,0,P36*IF(C36=\"LF\",(Table!$B$20-N36)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C36=\"LS\",(Table!$B$21-N36)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C36=\"B\",-G36/100*1000,IF(C36=\"T\",(1-(IF(I36=\"Et\",0.8,IF(I36=\"UEF\",IF(AND(B36=\"R\",M36=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B36=\"R\",M36=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H36)+IF(OR(AND(B36=\"N\",I36=\"Et\")=TRUE,AND(B36=\"R\",I36=\"Et\",M36=\"Tank Type\")=TRUE)=TRUE,0.775*(G36)^-0.778,0))*VLOOKUP(K36,EUD,2,FALSE)*L36/100,(1-(IF(I36=\"Et\",0.8,IF(I36=\"UEF\",IF(F36<=55,0.6483-(0.0017*F36),0.7897-(0.0004*F36)),IF($B$14=\"Existing Building\",0.62-(0.0019*F36),0.67-(0.0005*F36))))/H36)+IF(I36=\"Et\",IF($B$14=\"Existing Building\",(((G36/0.8+110*SQRT(F36))/1000)-J36)/G36,(((G36/0.799+16.6*SQRT(F36))/1000)-J36)/G36),0))*VLOOKUP(K36,EUD,2,FALSE)*L36/100)))))","v":0},0,0,0,0,0,0,0,0,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(Q37=0,0,O37*IF(C37=\"LF\",(Table!$B$20-N37)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C37=\"LS\",(Table!$B$21-N37)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C37=\"B\",-G37/100*1000,IF(C37=\"T\",(1-(IF(I37=\"Et\",0.8,IF(I37=\"UEF\",IF(AND(B37=\"R\",M37=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B37=\"R\",M37=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H37)+IF(OR(AND(B37=\"N\",I37=\"Et\")=TRUE,AND(B37=\"R\",I37=\"Et\",M37=\"Tank Type\")=TRUE)=TRUE,0.775*(G37)^-0.778,0))*VLOOKUP(K37,EUD,2,FALSE)*L37/100,(1-(IF(I37=\"Et\",0.8,IF(I37=\"UEF\",IF(F37<=55,0.6483-(0.0017*F37),0.7897-(0.0004*F37)),IF($B$14=\"Existing Building\",0.62-(0.0019*F37),0.67-(0.0005*F37))))/H37)+IF(I37=\"Et\",IF($B$14=\"Existing Building\",(((G37/0.8+110*SQRT(F37))/1000)-J37)/G37,(((G37/0.799+16.6*SQRT(F37))/1000)-J37)/G37),0))*VLOOKUP(K37,EUD,2,FALSE)*L37/100)))))","v":0},{"$f":"IF(Q37=0,0,P37*IF(C37=\"LF\",(Table!$B$20-N37)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C37=\"LS\",(Table!$B$21-N37)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C37=\"B\",-G37/100*1000,IF(C37=\"T\",(1-(IF(I37=\"Et\",0.8,IF(I37=\"UEF\",IF(AND(B37=\"R\",M37=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B37=\"R\",M37=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H37)+IF(OR(AND(B37=\"N\",I37=\"Et\")=TRUE,AND(B37=\"R\",I37=\"Et\",M37=\"Tank Type\")=TRUE)=TRUE,0.775*(G37)^-0.778,0))*VLOOKUP(K37,EUD,2,FALSE)*L37/100,(1-(IF(I37=\"Et\",0.8,IF(I37=\"UEF\",IF(F37<=55,0.6483-(0.0017*F37),0.7897-(0.0004*F37)),IF($B$14=\"Existing Building\",0.62-(0.0019*F37),0.67-(0.0005*F37))))/H37)+IF(I37=\"Et\",IF($B$14=\"Existing Building\",(((G37/0.8+110*SQRT(F37))/1000)-J37)/G37,(((G37/0.799+16.6*SQRT(F37))/1000)-J37)/G37),0))*VLOOKUP(K37,EUD,2,FALSE)*L37/100)))))","v":0},0,0,0,0,0,0,0,0,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(Q38=0,0,O38*IF(C38=\"LF\",(Table!$B$20-N38)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C38=\"LS\",(Table!$B$21-N38)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C38=\"B\",-G38/100*1000,IF(C38=\"T\",(1-(IF(I38=\"Et\",0.8,IF(I38=\"UEF\",IF(AND(B38=\"R\",M38=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B38=\"R\",M38=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H38)+IF(OR(AND(B38=\"N\",I38=\"Et\")=TRUE,AND(B38=\"R\",I38=\"Et\",M38=\"Tank Type\")=TRUE)=TRUE,0.775*(G38)^-0.778,0))*VLOOKUP(K38,EUD,2,FALSE)*L38/100,(1-(IF(I38=\"Et\",0.8,IF(I38=\"UEF\",IF(F38<=55,0.6483-(0.0017*F38),0.7897-(0.0004*F38)),IF($B$14=\"Existing Building\",0.62-(0.0019*F38),0.67-(0.0005*F38))))/H38)+IF(I38=\"Et\",IF($B$14=\"Existing Building\",(((G38/0.8+110*SQRT(F38))/1000)-J38)/G38,(((G38/0.799+16.6*SQRT(F38))/1000)-J38)/G38),0))*VLOOKUP(K38,EUD,2,FALSE)*L38/100)))))","v":0},{"$f":"IF(Q38=0,0,P38*IF(C38=\"LF\",(Table!$B$20-N38)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C38=\"LS\",(Table!$B$21-N38)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C38=\"B\",-G38/100*1000,IF(C38=\"T\",(1-(IF(I38=\"Et\",0.8,IF(I38=\"UEF\",IF(AND(B38=\"R\",M38=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B38=\"R\",M38=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H38)+IF(OR(AND(B38=\"N\",I38=\"Et\")=TRUE,AND(B38=\"R\",I38=\"Et\",M38=\"Tank Type\")=TRUE)=TRUE,0.775*(G38)^-0.778,0))*VLOOKUP(K38,EUD,2,FALSE)*L38/100,(1-(IF(I38=\"Et\",0.8,IF(I38=\"UEF\",IF(F38<=55,0.6483-(0.0017*F38),0.7897-(0.0004*F38)),IF($B$14=\"Existing Building\",0.62-(0.0019*F38),0.67-(0.0005*F38))))/H38)+IF(I38=\"Et\",IF($B$14=\"Existing Building\",(((G38/0.8+110*SQRT(F38))/1000)-J38)/G38,(((G38/0.799+16.6*SQRT(F38))/1000)-J38)/G38),0))*VLOOKUP(K38,EUD,2,FALSE)*L38/100)))))","v":0},0,0,0,0,0,0,0,0,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(Q39=0,0,O39*IF(C39=\"LF\",(Table!$B$20-N39)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C39=\"LS\",(Table!$B$21-N39)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C39=\"B\",-G39/100*1000,IF(C39=\"T\",(1-(IF(I39=\"Et\",0.8,IF(I39=\"UEF\",IF(AND(B39=\"R\",M39=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B39=\"R\",M39=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H39)+IF(OR(AND(B39=\"N\",I39=\"Et\")=TRUE,AND(B39=\"R\",I39=\"Et\",M39=\"Tank Type\")=TRUE)=TRUE,0.775*(G39)^-0.778,0))*VLOOKUP(K39,EUD,2,FALSE)*L39/100,(1-(IF(I39=\"Et\",0.8,IF(I39=\"UEF\",IF(F39<=55,0.6483-(0.0017*F39),0.7897-(0.0004*F39)),IF($B$14=\"Existing Building\",0.62-(0.0019*F39),0.67-(0.0005*F39))))/H39)+IF(I39=\"Et\",IF($B$14=\"Existing Building\",(((G39/0.8+110*SQRT(F39))/1000)-J39)/G39,(((G39/0.799+16.6*SQRT(F39))/1000)-J39)/G39),0))*VLOOKUP(K39,EUD,2,FALSE)*L39/100)))))","v":0},{"$f":"IF(Q39=0,0,P39*IF(C39=\"LF\",(Table!$B$20-N39)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C39=\"LS\",(Table!$B$21-N39)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C39=\"B\",-G39/100*1000,IF(C39=\"T\",(1-(IF(I39=\"Et\",0.8,IF(I39=\"UEF\",IF(AND(B39=\"R\",M39=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B39=\"R\",M39=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H39)+IF(OR(AND(B39=\"N\",I39=\"Et\")=TRUE,AND(B39=\"R\",I39=\"Et\",M39=\"Tank Type\")=TRUE)=TRUE,0.775*(G39)^-0.778,0))*VLOOKUP(K39,EUD,2,FALSE)*L39/100,(1-(IF(I39=\"Et\",0.8,IF(I39=\"UEF\",IF(F39<=55,0.6483-(0.0017*F39),0.7897-(0.0004*F39)),IF($B$14=\"Existing Building\",0.62-(0.0019*F39),0.67-(0.0005*F39))))/H39)+IF(I39=\"Et\",IF($B$14=\"Existing Building\",(((G39/0.8+110*SQRT(F39))/1000)-J39)/G39,(((G39/0.799+16.6*SQRT(F39))/1000)-J39)/G39),0))*VLOOKUP(K39,EUD,2,FALSE)*L39/100)))))","v":0},0,0,0,0,0,0,0,0,""]
[null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(Q40=0,0,O40*IF(C40=\"LF\",(Table!$B$20-N40)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C40=\"LS\",(Table!$B$21-N40)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C40=\"B\",-G40/100*1000,IF(C40=\"T\",(1-(IF(I40=\"Et\",0.8,IF(I40=\"UEF\",IF(AND(B40=\"R\",M40=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B40=\"R\",M40=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H40)+IF(OR(AND(B40=\"N\",I40=\"Et\")=TRUE,AND(B40=\"R\",I40=\"Et\",M40=\"Tank Type\")=TRUE)=TRUE,0.775*(G40)^-0.778,0))*VLOOKUP(K40,EUD,2,FALSE)*L40/100,(1-(IF(I40=\"Et\",0.8,IF(I40=\"UEF\",IF(F40<=55,0.6483-(0.0017*F40),0.7897-(0.0004*F40)),IF($B$14=\"Existing Building\",0.62-(0.0019*F40),0.67-(0.0005*F40))))/H40)+IF(I40=\"Et\",IF($B$14=\"Existing Building\",(((G40/0.8+110*SQRT(F40))/1000)-J40)/G40,(((G40/0.799+16.6*SQRT(F40))/1000)-J40)/G40),0))*VLOOKUP(K40,EUD,2,FALSE)*L40/100)))))","v":0},{"$f":"IF(Q40=0,0,P40*IF(C40=\"LF\",(Table!$B$20-N40)*Table!$B$22*Table!$B$24*Table!$B$26*8.33/Table!$B$28/100000,IF(C40=\"LS\",(Table!$B$21-N40)*Table!$B$23*Table!$B$25*Table!$B$27*8.33/Table!$B$28/100000,IF(C40=\"B\",-G40/100*1000,IF(C40=\"T\",(1-(IF(I40=\"Et\",0.8,IF(I40=\"UEF\",IF(AND(B40=\"R\",M40=\"Instantaneous\")=TRUE,0.81,0.657),IF(AND(B40=\"R\",M40=\"Instantaneous\")=TRUE,0.62,IF($B$14=\"Existing Building\",0.54,0.65))))/H40)+IF(OR(AND(B40=\"N\",I40=\"Et\")=TRUE,AND(B40=\"R\",I40=\"Et\",M40=\"Tank Type\")=TRUE)=TRUE,0.775*(G40)^-0.778,0))*VLOOKUP(K40,EUD,2,FALSE)*L40/100,(1-(IF(I40=\"Et\",0.8,IF(I40=\"UEF\",IF(F40<=55,0.6483-(0.0017*F40),0.7897-(0.0004*F40)),IF($B$14=\"Existing Building\",0.62-(0.0019*F40),0.67-(0.0005*F40))))/H40)+IF(I40=\"Et\",IF($B$14=\"Existing Building\",(((G40/0.8+110*SQRT(F40))/1000)-J40)/G40,(((G40/0.799+16.6*SQRT(F40))/1000)-J40)/G40),0))*VLOOKUP(K40,EUD,2,FALSE)*L40/100)))))","v":0},0,0,0,0,0,0,0,0,""]

{"sheet":"Measure Code","index":1,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["Measure Code","Type","Description","Min Capacity\n(MBH)","Max Capacity\n(MBH)","Min. Eff\n(EF)","Min. Eff\n(UEF)","Min. Eff\n(Et)","Tier","Incentive","Incentive Units","Measure Life","Measure Type"]
["GWH1","W","Tank Style Water Heater ≤ 75 MBH",0.01,75,"N/A",0.64,"N/A",1,1.75,"per MBH",15,87]
["GWH2","W","Tank Style Water Heater ≤ 75 MBH",0.01,75,"N/A",0.85,"N/A",2,3.5,"per MBH",15,87]
["GWH3","W","Tank Style Water Heater > 75 MBH and ≤105 MBH",75.010000000000005,105,"N/A",0.64,0.82,1,1.75,"per MBH",15,87]
["GWH4","W","Tank Style Water Heater > 75 MBH and ≤105 MBH",75.010000000000005,105,"N/A",0.85,0.9,2,3.5,"per MBH",15,87]
["GWH5","W","Tank Style Water Heater > 105 MBH",105.01,999999,"N/A","N/A",0.82,1,1.75,"per MBH",15,87]
["GWH6","W","Tank Style Water Heater > 105 MBH",105.01,999999,"N/A","N/A",0.92,2,3.5,"per MBH",15,87]
["GWH7","T","Tankless Water Heater < 200 MBH",0.01,199.99999,"N/A",0.9,0.9,"N/A",300,"per Unit",20,87]
["GWH8","T","Tankless Water Heater ≥ 200 MBH",200,999999,"N/A","N/A",0.9,"N/A",300,"per Unit",20,87]
["GWH9","B","Booster Water Heater ≤ 100 MBH",0.01,100,"N/A","N/A","N/A","N/A",35,"per MBH",15,87]
["GWH10","B","Booster Water Heater > 100 MBH",100.01,999999,"N/A","N/A","N/A","N/A",17,"per MBH",15,87]
["GWH11","LF","Low Flow Faucet Aerator",0,0,"N/A","N/A","N/A",1,2,"per Unit",10,252]
["GWH12","LF","Low Flow Faucet Aerator",0,0,"N/A","N/A","N/A",2,4,"per Unit",10,252]
["GWH13","LS","Low Flow Showerhead",0,0,"N/A","N/A","N/A",1,10,"per Unit",10,252]
["GWH14","LS","Low Flow Showerhead",0,0,"N/A","N/A","N/A",2,15,"per Unit",10,252]

{"sheet":"Table","index":2,"n_rows":28,"n_cols":15,"rows_kept":28,"cut":false,"hidden":true,"merged":[[18,0,18,1]]}
["Building Type","Energy Use Density (kBtu/sf/yr)",null,"GWH1_EffUnits","GWH2_EffUnits","GWH3_EffUnits","GWH4_EffUnits","GWH5_EffUnits","GWH6_EffUnits","GWH7_EffUnits","GWH8_EffUnits","GWH9_EffUnits","GWH10_EffUnits",null,"Water Heater Type"]
["Education",7,null,"UEF","UEF","UEF","UEF","Et","Et","UEF","Et",null,null,null,"Tank Type"]
["Food Sales",4.4000000000000004,null,null,null,"Et","Et",null,null,"Et",null,null,null,null,"Instantaneous"]
["Food Service",39.200000000000003]
["Health Care",23.7]
["Health Care - Inpatient",34.299999999999997]
["Health Care - Outpatient",3.9]
["Lodging",26.5]
["Retail (Other Than Mall)",2.5]
["Enclosed and Strip Malls",14.1]
["Office",4.8]
["Public Assembly",2.1]
["Public Order and Safety",21.4]
["Religious Workship",0.9]
["Service",15]
["Warehouse and Storage",2.9]
["Other",2.2999999999999998]
[]
["Low Flow Fixtures"]
["Baseline Faucet Flow Rate (GPM)",2.2000000000000002,"GPM"]
["Baseline Showerhead Flow Rate (GPM)",2.5,"GPM"]
["Minutes of Use (Faucets)",30,"min/day"]
["Minutes of Use (Showerheads)",20,"min/day"]
["Days of Use (Faucets)",260,"days"]
["Days of Use (Showerheads)",365,"days"]
["Temperature Differential (Faucets)",25,"deg F"]
["Temperature Differential (Showerheads)",50,"deg F"]
["Gas Water Heating System Efficiency",0.8]

{"sheet":"Export","index":3,"n_rows":26,"n_cols":25,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
["Measure Type","Manufacturer","Model","Capacity/Size","Capacity/Size Units","EER Efficiency","SEER Efficiency","Incentive Per Unit","Quantity Committed","Annual Electricity Savings","Peak Demand Reduction","Lifetime Electricity Savings","Annual Gas Savings","Lifetime Gas Savings","Efficiency- other","Efficiency- other-type","Measure ID removed","Quantity Installed","Project in UEZ","Project in OZ","Municipality","K-12 School","County","Affordable Housing","Enhanced Incentive per Unit"]
[{"$f":"IF(Worksheet!C16=\"LF\",252,IF(Worksheet!C16=\"LS\",252,IF(ISBLANK(Worksheet!O16)=FALSE,IF(ISBLANK(Worksheet!F16)=FALSE,IF(Worksheet!F16>50,88,87),87),\"\")))","v":""},{"$f":"IF(ISBLANK(Worksheet!D16) = FALSE,Worksheet!D16,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E16) = FALSE,Worksheet!E16,\"\")","v":""},{"$f":"IF(OR(Worksheet!C16=\"LF\",Worksheet!C16=\"LS\")=TRUE,Worksheet!N16,IF(Worksheet!F16=\"\",IF(Worksheet!G16=\"\",\"\",Worksheet!G16),Worksheet!F16))","v":""},{"$f":"IF(OR(Worksheet!C16=\"LF\",Worksheet!C16=\"LS\")=TRUE,\"GPM\",IF(Worksheet!F16=\"\",IF(Worksheet!G16=\"\",\"\",\"MBh\"),\"Gallons\"))","v":""},null,null,{"$f":"IF(Worksheet!Q16>0,Worksheet!Q16,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!O16)=FALSE,Worksheet!O16,\"\")","v":""},{"$f":"IFERROR(Worksheet!Y16/I2,\"\")","v":""},{"$f":"IFERROR(Worksheet!AA16/I2,\"\")","v":""},{"$f":"IFERROR(Worksheet!AC16/I2,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!U16)=FALSE, Worksheet!U16,\"\")/I2,0)","v":0},{"$f":"IFERROR(IF(ISBLANK(Worksheet!W16)=FALSE, Worksheet!W16,\"\")/I2,0)","v":0},{"$f":"IF(ISBLANK(Worksheet!H16)=FALSE, Worksheet!H16,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!I16)=FALSE, Worksheet!I16,\"\")","v":""},null,{"$f":"IF(ISBLANK(Worksheet!P16)=FALSE,Worksheet!P16,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!R16,\"\")","v":0}]
[{"$f":"IF(Worksheet!C17=\"LF\",252,IF(Worksheet!C17=\"LS\",252,IF(ISBLANK(Worksheet!O17)=FALSE,IF(ISBLANK(Worksheet!F17)=FALSE,IF(Worksheet!F17>50,88,87),87),\"\")))","v":""},{"$f":"IF(ISBLANK(Worksheet!D17) = FALSE,Worksheet!D17,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E17) = FALSE,Worksheet!E17,\"\")","v":""},{"$f":"IF(OR(Worksheet!C17=\"LF\",Worksheet!C17=\"LS\")=TRUE,Worksheet!N17,IF(Worksheet!F17=\"\",IF(Worksheet!G17=\"\",\"\",Worksheet!G17),Worksheet!F17))","v":""},{"$f":"IF(OR(Worksheet!C17=\"LF\",Worksheet!C17=\"LS\")=TRUE,\"GPM\",IF(Worksheet!F17=\"\",IF(Worksheet!G17=\"\",\"\",\"MBh\"),\"Gallons\"))","v":""},null,null,{"$f":"IF(Worksheet!Q17>0,Worksheet!Q17,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!O17)=FALSE,Worksheet!O17,\"\")","v":""},{"$f":"IFERROR(Worksheet!Y17/I3,\"\")","v":""},{"$f":"IFERROR(Worksheet!AA17/I3,\"\")","v":""},{"$f":"IFERROR(Worksheet!AC17/I3,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!U17)=FALSE, Worksheet!U17,\"\")/I3,0)","v":0},{"$f":"IFERROR(IF(ISBLANK(Worksheet!W17)=FALSE, Worksheet!W17,\"\")/I3,0)","v":0},{"$f":"IF(ISBLANK(Worksheet!H17)=FALSE, Worksheet!H17,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!I17)=FALSE, Worksheet!I17,\"\")","v":""},null,{"$f":"IF(ISBLANK(Worksheet!P17)=FALSE,Worksheet!P17,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!R17,\"\")","v":0}]
[{"$f":"IF(Worksheet!C18=\"LF\",252,IF(Worksheet!C18=\"LS\",252,IF(ISBLANK(Worksheet!O18)=FALSE,IF(ISBLANK(Worksheet!F18)=FALSE,IF(Worksheet!F18>50,88,87),87),\"\")))","v":""},{"$f":"IF(ISBLANK(Worksheet!D18) = FALSE,Worksheet!D18,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E18) = FALSE,Worksheet!E18,\"\")","v":""},{"$f":"IF(OR(Worksheet!C18=\"LF\",Worksheet!C18=\"LS\")=TRUE,Worksheet!N18,IF(Worksheet!F18=\"\",IF(Worksheet!G18=\"\",\"\",Worksheet!G18),Worksheet!F18))","v":""},{"$f":"IF(OR(Worksheet!C18=\"LF\",Worksheet!C18=\"LS\")=TRUE,\"GPM\",IF(Worksheet!F18=\"\",IF(Worksheet!G18=\"\",\"\",\"MBh\"),\"Gallons\"))","v":""},null,null,{"$f":"IF(Worksheet!Q18>0,Worksheet!Q18,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!O18)=FALSE,Worksheet!O18,\"\")","v":""},{"$f":"IFERROR(Worksheet!Y18/I4,\"\")","v":""},{"$f":"IFERROR(Worksheet!AA18/I4,\"\")","v":""},{"$f":"IFERROR(Worksheet!AC18/I4,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!U18)=FALSE, Worksheet!U18,\"\")/I4,0)","v":0},{"$f":"IFERROR(IF(ISBLANK(Worksheet!W18)=FALSE, Worksheet!W18,\"\")/I4,0)","v":0},{"$f":"IF(ISBLANK(Worksheet!H18)=FALSE, Worksheet!H18,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!I18)=FALSE, Worksheet!I18,\"\")","v":""},null,{"$f":"IF(ISBLANK(Worksheet!P18)=FALSE,Worksheet!P18,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!R18,\"\")","v":0}]
[{"$f":"IF(Worksheet!C19=\"LF\",252,IF(Worksheet!C19=\"LS\",252,IF(ISBLANK(Worksheet!O19)=FALSE,IF(ISBLANK(Worksheet!F19)=FALSE,IF(Worksheet!F19>50,88,87),87),\"\")))","v":""},{"$f":"IF(ISBLANK(Worksheet!D19) = FALSE,Worksheet!D19,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E19) = FALSE,Worksheet!E19,\"\")","v":""},{"$f":"IF(OR(Worksheet!C19=\"LF\",Worksheet!C19=\"LS\")=TRUE,Worksheet!N19,IF(Worksheet!F19=\"\",IF(Worksheet!G19=\"\",\"\",Worksheet!G19),Worksheet!F19))","v":""},{"$f":"IF(OR(Worksheet!C19=\"LF\",Worksheet!C19=\"LS\")=TRUE,\"GPM\",IF(Worksheet!F19=\"\",IF(Worksheet!G19=\"\",\"\",\"MBh\"),\"Gallons\"))","v":""},null,null,{"$f":"IF(Worksheet!Q19>0,Worksheet!Q19,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!O19)=FALSE,Worksheet!O19,\"\")","v":""},{"$f":"IFERROR(Worksheet!Y19/I5,\"\")","v":""},{"$f":"IFERROR(Worksheet!AA19/I5,\"\")","v":""},{"$f":"IFERROR(Worksheet!AC19/I5,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!U19)=FALSE, Worksheet!U19,\"\")/I5,0)","v":0},{"$f":"IFERROR(IF(ISBLANK(Worksheet!W19)=FALSE, Worksheet!W19,\"\")/I5,0)","v":0},{"$f":"IF(ISBLANK(Worksheet!H19)=FALSE, Worksheet!H19,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!I19)=FALSE, Worksheet!I19,\"\")","v":""},null,{"$f":"IF(ISBLANK(Worksheet!P19)=FALSE,Worksheet!P19,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!R19,\"\")","v":0}]
[{"$f":"IF(Worksheet!C20=\"LF\",252,IF(Worksheet!C20=\"LS\",252,IF(ISBLANK(Worksheet!O20)=FALSE,IF(ISBLANK(Worksheet!F20)=FALSE,IF(Worksheet!F20>50,88,87),87),\"\")))","v":""},{"$f":"IF(ISBLANK(Worksheet!D20) = FALSE,Worksheet!D20,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E20) = FALSE,Worksheet!E20,\"\")","v":""},{"$f":"IF(OR(Worksheet!C20=\"LF\",Worksheet!C20=\"LS\")=TRUE,Worksheet!N20,IF(Worksheet!F20=\"\",IF(Worksheet!G20=\"\",\"\",Worksheet!G20),Worksheet!F20))","v":""},{"$f":"IF(OR(Worksheet!C20=\"LF\",Worksheet!C20=\"LS\")=TRUE,\"GPM\",IF(Worksheet!F20=\"\",IF(Worksheet!G20=\"\",\"\",\"MBh\"),\"Gallons\"))","v":""},null,null,{"$f":"IF(Worksheet!Q20>0,Worksheet!Q20,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!O20)=FALSE,Worksheet!O20,\"\")","v":""},{"$f":"IFERROR(Worksheet!Y20/I6,\"\")","v":""},{"$f":"IFERROR(Worksheet!AA20/I6,\"\")","v":""},{"$f":"IFERROR(Worksheet!AC20/I6,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!U20)=FALSE, Worksheet!U20,\"\")/I6,0)","v":0},{"$f":"IFERROR(IF(ISBLANK(Worksheet!W20)=FALSE, Worksheet!W20,\"\")/I6,0)","v":0},{"$f":"IF(ISBLANK(Worksheet!H20)=FALSE, Worksheet!H20,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!I20)=FALSE, Worksheet!I20,\"\")","v":""},null,{"$f":"IF(ISBLANK(Worksheet!P20)=FALSE,Worksheet!P20,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!R20,\"\")","v":0}]
[{"$f":"IF(Worksheet!C21=\"LF\",252,IF(Worksheet!C21=\"LS\",252,IF(ISBLANK(Worksheet!O21)=FALSE,IF(ISBLANK(Worksheet!F21)=FALSE,IF(Worksheet!F21>50,88,87),87),\"\")))","v":""},{"$f":"IF(ISBLANK(Worksheet!D21) = FALSE,Worksheet!D21,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E21) = FALSE,Worksheet!E21,\"\")","v":""},{"$f":"IF(OR(Worksheet!C21=\"LF\",Worksheet!C21=\"LS\")=TRUE,Worksheet!N21,IF(Worksheet!F21=\"\",IF(Worksheet!G21=\"\",\"\",Worksheet!G21),Worksheet!F21))","v":""},{"$f":"IF(OR(Worksheet!C21=\"LF\",Worksheet!C21=\"LS\")=TRUE,\"GPM\",IF(Worksheet!F21=\"\",IF(Worksheet!G21=\"\",\"\",\"MBh\"),\"Gallons\"))","v":""},null,null,{"$f":"IF(Worksheet!Q21>0,Worksheet!Q21,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!O21)=FALSE,Worksheet!O21,\"\")","v":""},{"$f":"IFERROR(Worksheet!Y21/I7,\"\")","v":""},{"$f":"IFERROR(Worksheet!AA21/I7,\"\")","v":""},{"$f":"IFERROR(Worksheet!AC21/I7,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!U21)=FALSE, Worksheet!U21,\"\")/I7,0)","v":0},{"$f":"IFERROR(IF(ISBLANK(Worksheet!W21)=FALSE, Worksheet!W21,\"\")/I7,0)","v":0},{"$f":"IF(ISBLANK(Worksheet!H21)=FALSE, Worksheet!H21,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!I21)=FALSE, Worksheet!I21,\"\")","v":""},null,{"$f":"IF(ISBLANK(Worksheet!P21)=FALSE,Worksheet!P21,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!R21,\"\")","v":0}]
[{"$f":"IF(Worksheet!C22=\"LF\",252,IF(Worksheet!C22=\"LS\",252,IF(ISBLANK(Worksheet!O22)=FALSE,IF(ISBLANK(Worksheet!F22)=FALSE,IF(Worksheet!F22>50,88,87),87),\"\")))","v":""},{"$f":"IF(ISBLANK(Worksheet!D22) = FALSE,Worksheet!D22,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E22) = FALSE,Worksheet!E22,\"\")","v":""},{"$f":"IF(OR(Worksheet!C22=\"LF\",Worksheet!C22=\"LS\")=TRUE,Worksheet!N22,IF(Worksheet!F22=\"\",IF(Worksheet!G22=\"\",\"\",Worksheet!G22),Worksheet!F22))","v":""},{"$f":"IF(OR(Worksheet!C22=\"LF\",Worksheet!C22=\"LS\")=TRUE,\"GPM\",IF(Worksheet!F22=\"\",IF(Worksheet!G22=\"\",\"\",\"MBh\"),\"Gallons\"))","v":""},null,null,{"$f":"IF(Worksheet!Q22>0,Worksheet!Q22,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!O22)=FALSE,Worksheet!O22,\"\")","v":""},{"$f":"IFERROR(Worksheet!Y22/I8,\"\")","v":""},{"$f":"IFERROR(Worksheet!AA22/I8,\"\")","v":""},{"$f":"IFERROR(Worksheet!AC22/I8,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!U22)=FALSE, Worksheet!U22,\"\")/I8,0)","v":0},{"$f":"IFERROR(IF(ISBLANK(Worksheet!W22)=FALSE, Worksheet!W22,\"\")/I8,0)","v":0},{"$f":"IF(ISBLANK(Worksheet!H22)=FALSE, Worksheet!H22,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!I22)=FALSE, Worksheet!I22,\"\")","v":""},null,{"$f":"IF(ISBLANK(Worksheet!P22)=FALSE,Worksheet!P22,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!R22,\"\")","v":0}]
[{"$f":"IF(Worksheet!C23=\"LF\",252,IF(Worksheet!C23=\"LS\",252,IF(ISBLANK(Worksheet!O23)=FALSE,IF(ISBLANK(Worksheet!F23)=FALSE,IF(Worksheet!F23>50,88,87),87),\"\")))","v":""},{"$f":"IF(ISBLANK(Worksheet!D23) = FALSE,Worksheet!D23,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E23) = FALSE,Worksheet!E23,\"\")","v":""},{"$f":"IF(OR(Worksheet!C23=\"LF\",Worksheet!C23=\"LS\")=TRUE,Worksheet!N23,IF(Worksheet!F23=\"\",IF(Worksheet!G23=\"\",\"\",Worksheet!G23),Worksheet!F23))","v":""},{"$f":"IF(OR(Worksheet!C23=\"LF\",Worksheet!C23=\"LS\")=TRUE,\"GPM\",IF(Worksheet!F23=\"\",IF(Worksheet!G23=\"\",\"\",\"MBh\"),\"Gallons\"))","v":""},null,null,{"$f":"IF(Worksheet!Q23>0,Worksheet!Q23,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!O23)=FALSE,Worksheet!O23,\"\")","v":""},{"$f":"IFERROR(Worksheet!Y23/I9,\"\")","v":""},{"$f":"IFERROR(Worksheet!AA23/I9,\"\")","v":""},{"$f":"IFERROR(Worksheet!AC23/I9,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!U23)=FALSE, Worksheet!U23,\"\")/I9,0)","v":0},{"$f":"IFERROR(IF(ISBLANK(Worksheet!W23)=FALSE, Worksheet!W23,\"\")/I9,0)","v":0},{"$f":"IF(ISBLANK(Worksheet!H23)=FALSE, Worksheet!H23,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!I23)=FALSE, Worksheet!I23,\"\")","v":""},null,{"$f":"IF(ISBLANK(Worksheet!P23)=FALSE,Worksheet!P23,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!R23,\"\")","v":0}]
[{"$f":"IF(Worksheet!C24=\"LF\",252,IF(Worksheet!C24=\"LS\",252,IF(ISBLANK(Worksheet!O24)=FALSE,IF(ISBLANK(Worksheet!F24)=FALSE,IF(Worksheet!F24>50,88,87),87),\"\")))","v":""},{"$f":"IF(ISBLANK(Worksheet!D24) = FALSE,Worksheet!D24,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E24) = FALSE,Worksheet!E24,\"\")","v":""},{"$f":"IF(OR(Worksheet!C24=\"LF\",Worksheet!C24=\"LS\")=TRUE,Worksheet!N24,IF(Worksheet!F24=\"\",IF(Worksheet!G24=\"\",\"\",Worksheet!G24),Worksheet!F24))","v":""},{"$f":"IF(OR(Worksheet!C24=\"LF\",Worksheet!C24=\"LS\")=TRUE,\"GPM\",IF(Worksheet!F24=\"\",IF(Worksheet!G24=\"\",\"\",\"MBh\"),\"Gallons\"))","v":""},null,null,{"$f":"IF(Worksheet!Q24>0,Worksheet!Q24,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!O24)=FALSE,Worksheet!O24,\"\")","v":""},{"$f":"IFERROR(Worksheet!Y24/I10,\"\")","v":""},{"$f":"IFERROR(Worksheet!AA24/I10,\"\")","v":""},{"$f":"IFERROR(Worksheet!AC24/I10,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!U24)=FALSE, Worksheet!U24,\"\")/I10,0)","v":0},{"$f":"IFERROR(IF(ISBLANK(Worksheet!W24)=FALSE, Worksheet!W24,\"\")/I10,0)","v":0},{"$f":"IF(ISBLANK(Worksheet!H24)=FALSE, Worksheet!H24,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!I24)=FALSE, Worksheet!I24,\"\")","v":""},null,{"$f":"IF(ISBLANK(Worksheet!P24)=FALSE,Worksheet!P24,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!R24,\"\")","v":0}]
[{"$f":"IF(Worksheet!C25=\"LF\",252,IF(Worksheet!C25=\"LS\",252,IF(ISBLANK(Worksheet!O25)=FALSE,IF(ISBLANK(Worksheet!F25)=FALSE,IF(Worksheet!F25>50,88,87),87),\"\")))","v":""},{"$f":"IF(ISBLANK(Worksheet!D25) = FALSE,Worksheet!D25,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E25) = FALSE,Worksheet!E25,\"\")","v":""},{"$f":"IF(OR(Worksheet!C25=\"LF\",Worksheet!C25=\"LS\")=TRUE,Worksheet!N25,IF(Worksheet!F25=\"\",IF(Worksheet!G25=\"\",\"\",Worksheet!G25),Worksheet!F25))","v":""},{"$f":"IF(OR(Worksheet!C25=\"LF\",Worksheet!C25=\"LS\")=TRUE,\"GPM\",IF(Worksheet!F25=\"\",IF(Worksheet!G25=\"\",\"\",\"MBh\"),\"Gallons\"))","v":""},null,null,{"$f":"IF(Worksheet!Q25>0,Worksheet!Q25,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!O25)=FALSE,Worksheet!O25,\"\")","v":""},{"$f":"IFERROR(Worksheet!Y25/I11,\"\")","v":""},{"$f":"IFERROR(Worksheet!AA25/I11,\"\")","v":""},{"$f":"IFERROR(Worksheet!AC25/I11,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!U25)=FALSE, Worksheet!U25,\"\")/I11,0)","v":0},{"$f":"IFERROR(IF(ISBLANK(Worksheet!W25)=FALSE, Worksheet!W25,\"\")/I11,0)","v":0},{"$f":"IF(ISBLANK(Worksheet!H25)=FALSE, Worksheet!H25,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!I25)=FALSE, Worksheet!I25,\"\")","v":""},null,{"$f":"IF(ISBLANK(Worksheet!P25)=FALSE,Worksheet!P25,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!R25,\"\")","v":0}]
[{"$f":"IF(Worksheet!C26=\"LF\",252,IF(Worksheet!C26=\"LS\",252,IF(ISBLANK(Worksheet!O26)=FALSE,IF(ISBLANK(Worksheet!F26)=FALSE,IF(Worksheet!F26>50,88,87),87),\"\")))","v":""},{"$f":"IF(ISBLANK(Worksheet!D26) = FALSE,Worksheet!D26,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E26) = FALSE,Worksheet!E26,\"\")","v":""},{"$f":"IF(OR(Worksheet!C26=\"LF\",Worksheet!C26=\"LS\")=TRUE,Worksheet!N26,IF(Worksheet!F26=\"\",IF(Worksheet!G26=\"\",\"\",Worksheet!G26),Worksheet!F26))","v":""},{"$f":"IF(OR(Worksheet!C26=\"LF\",Worksheet!C26=\"LS\")=TRUE,\"GPM\",IF(Worksheet!F26=\"\",IF(Worksheet!G26=\"\",\"\",\"MBh\"),\"Gallons\"))","v":""},null,null,{"$f":"IF(Worksheet!Q26>0,Worksheet!Q26,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!O26)=FALSE,Worksheet!O26,\"\")","v":""},{"$f":"IFERROR(Worksheet!Y26/I12,\"\")","v":""},{"$f":"IFERROR(Worksheet!AA26/I12,\"\")","v":""},{"$f":"IFERROR(Worksheet!AC26/I12,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!U26)=FALSE, Worksheet!U26,\"\")/I12,0)","v":0},{"$f":"IFERROR(IF(ISBLANK(Worksheet!W26)=FALSE, Worksheet!W26,\"\")/I12,0)","v":0},{"$f":"IF(ISBLANK(Worksheet!H26)=FALSE, Worksheet!H26,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!I26)=FALSE, Worksheet!I26,\"\")","v":""},null,{"$f":"IF(ISBLANK(Worksheet!P26)=FALSE,Worksheet!P26,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!R26,\"\")","v":0}]
[{"$f":"IF(Worksheet!C27=\"LF\",252,IF(Worksheet!C27=\"LS\",252,IF(ISBLANK(Worksheet!O27)=FALSE,IF(ISBLANK(Worksheet!F27)=FALSE,IF(Worksheet!F27>50,88,87),87),\"\")))","v":""},{"$f":"IF(ISBLANK(Worksheet!D27) = FALSE,Worksheet!D27,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E27) = FALSE,Worksheet!E27,\"\")","v":""},{"$f":"IF(OR(Worksheet!C27=\"LF\",Worksheet!C27=\"LS\")=TRUE,Worksheet!N27,IF(Worksheet!F27=\"\",IF(Worksheet!G27=\"\",\"\",Worksheet!G27),Worksheet!F27))","v":""},{"$f":"IF(OR(Worksheet!C27=\"LF\",Worksheet!C27=\"LS\")=TRUE,\"GPM\",IF(Worksheet!F27=\"\",IF(Worksheet!G27=\"\",\"\",\"MBh\"),\"Gallons\"))","v":""},null,null,{"$f":"IF(Worksheet!Q27>0,Worksheet!Q27,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!O27)=FALSE,Worksheet!O27,\"\")","v":""},{"$f":"IFERROR(Worksheet!Y27/I13,\"\")","v":""},{"$f":"IFERROR(Worksheet!AA27/I13,\"\")","v":""},{"$f":"IFERROR(Worksheet!AC27/I13,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!U27)=FALSE, Worksheet!U27,\"\")/I13,0)","v":0},{"$f":"IFERROR(IF(ISBLANK(Worksheet!W27)=FALSE, Worksheet!W27,\"\")/I13,0)","v":0},{"$f":"IF(ISBLANK(Worksheet!H27)=FALSE, Worksheet!H27,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!I27)=FALSE, Worksheet!I27,\"\")","v":""},null,{"$f":"IF(ISBLANK(Worksheet!P27)=FALSE,Worksheet!P27,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!R27,\"\")","v":0}]
[{"$f":"IF(Worksheet!C28=\"LF\",252,IF(Worksheet!C28=\"LS\",252,IF(ISBLANK(Worksheet!O28)=FALSE,IF(ISBLANK(Worksheet!F28)=FALSE,IF(Worksheet!F28>50,88,87),87),\"\")))","v":""},{"$f":"IF(ISBLANK(Worksheet!D28) = FALSE,Worksheet!D28,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E28) = FALSE,Worksheet!E28,\"\")","v":""},{"$f":"IF(OR(Worksheet!C28=\"LF\",Worksheet!C28=\"LS\")=TRUE,Worksheet!N28,IF(Worksheet!F28=\"\",IF(Worksheet!G28=\"\",\"\",Worksheet!G28),Worksheet!F28))","v":""},{"$f":"IF(OR(Worksheet!C28=\"LF\",Worksheet!C28=\"LS\")=TRUE,\"GPM\",IF(Worksheet!F28=\"\",IF(Worksheet!G28=\"\",\"\",\"MBh\"),\"Gallons\"))","v":""},null,null,{"$f":"IF(Worksheet!Q28>0,Worksheet!Q28,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!O28)=FALSE,Worksheet!O28,\"\")","v":""},{"$f":"IFERROR(Worksheet!Y28/I14,\"\")","v":""},{"$f":"IFERROR(Worksheet!AA28/I14,\"\")","v":""},{"$f":"IFERROR(Worksheet!AC28/I14,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!U28)=FALSE, Worksheet!U28,\"\")/I14,0)","v":0},{"$f":"IFERROR(IF(ISBLANK(Worksheet!W28)=FALSE, Worksheet!W28,\"\")/I14,0)","v":0},{"$f":"IF(ISBLANK(Worksheet!H28)=FALSE, Worksheet!H28,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!I28)=FALSE, Worksheet!I28,\"\")","v":""},null,{"$f":"IF(ISBLANK(Worksheet!P28)=FALSE,Worksheet!P28,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!R28,\"\")","v":0}]
[{"$f":"IF(Worksheet!C29=\"LF\",252,IF(Worksheet!C29=\"LS\",252,IF(ISBLANK(Worksheet!O29)=FALSE,IF(ISBLANK(Worksheet!F29)=FALSE,IF(Worksheet!F29>50,88,87),87),\"\")))","v":""},{"$f":"IF(ISBLANK(Worksheet!D29) = FALSE,Worksheet!D29,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E29) = FALSE,Worksheet!E29,\"\")","v":""},{"$f":"IF(OR(Worksheet!C29=\"LF\",Worksheet!C29=\"LS\")=TRUE,Worksheet!N29,IF(Worksheet!F29=\"\",IF(Worksheet!G29=\"\",\"\",Worksheet!G29),Worksheet!F29))","v":""},{"$f":"IF(OR(Worksheet!C29=\"LF\",Worksheet!C29=\"LS\")=TRUE,\"GPM\",IF(Worksheet!F29=\"\",IF(Worksheet!G29=\"\",\"\",\"MBh\"),\"Gallons\"))","v":""},null,null,{"$f":"IF(Worksheet!Q29>0,Worksheet!Q29,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!O29)=FALSE,Worksheet!O29,\"\")","v":""},{"$f":"IFERROR(Worksheet!Y29/I15,\"\")","v":""},{"$f":"IFERROR(Worksheet!AA29/I15,\"\")","v":""},{"$f":"IFERROR(Worksheet!AC29/I15,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!U29)=FALSE, Worksheet!U29,\"\")/I15,0)","v":0},{"$f":"IFERROR(IF(ISBLANK(Worksheet!W29)=FALSE, Worksheet!W29,\"\")/I15,0)","v":0},{"$f":"IF(ISBLANK(Worksheet!H29)=FALSE, Worksheet!H29,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!I29)=FALSE, Worksheet!I29,\"\")","v":""},null,{"$f":"IF(ISBLANK(Worksheet!P29)=FALSE,Worksheet!P29,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!R29,\"\")","v":0}]
[{"$f":"IF(Worksheet!C30=\"LF\",252,IF(Worksheet!C30=\"LS\",252,IF(ISBLANK(Worksheet!O30)=FALSE,IF(ISBLANK(Worksheet!F30)=FALSE,IF(Worksheet!F30>50,88,87),87),\"\")))","v":""},{"$f":"IF(ISBLANK(Worksheet!D30) = FALSE,Worksheet!D30,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E30) = FALSE,Worksheet!E30,\"\")","v":""},{"$f":"IF(OR(Worksheet!C30=\"LF\",Worksheet!C30=\"LS\")=TRUE,Worksheet!N30,IF(Worksheet!F30=\"\",IF(Worksheet!G30=\"\",\"\",Worksheet!G30),Worksheet!F30))","v":""},{"$f":"IF(OR(Worksheet!C30=\"LF\",Worksheet!C30=\"LS\")=TRUE,\"GPM\",IF(Worksheet!F30=\"\",IF(Worksheet!G30=\"\",\"\",\"MBh\"),\"Gallons\"))","v":""},null,null,{"$f":"IF(Worksheet!Q30>0,Worksheet!Q30,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!O30)=FALSE,Worksheet!O30,\"\")","v":""},{"$f":"IFERROR(Worksheet!Y30/I16,\"\")","v":""},{"$f":"IFERROR(Worksheet!AA30/I16,\"\")","v":""},{"$f":"IFERROR(Worksheet!AC30/I16,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!U30)=FALSE, Worksheet!U30,\"\")/I16,0)","v":0},{"$f":"IFERROR(IF(ISBLANK(Worksheet!W30)=FALSE, Worksheet!W30,\"\")/I16,0)","v":0},{"$f":"IF(ISBLANK(Worksheet!H30)=FALSE, Worksheet!H30,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!I30)=FALSE, Worksheet!I30,\"\")","v":""},null,{"$f":"IF(ISBLANK(Worksheet!P30)=FALSE,Worksheet!P30,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!R30,\"\")","v":0}]
[{"$f":"IF(Worksheet!C31=\"LF\",252,IF(Worksheet!C31=\"LS\",252,IF(ISBLANK(Worksheet!O31)=FALSE,IF(ISBLANK(Worksheet!F31)=FALSE,IF(Worksheet!F31>50,88,87),87),\"\")))","v":""},{"$f":"IF(ISBLANK(Worksheet!D31) = FALSE,Worksheet!D31,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E31) = FALSE,Worksheet!E31,\"\")","v":""},{"$f":"IF(OR(Worksheet!C31=\"LF\",Worksheet!C31=\"LS\")=TRUE,Worksheet!N31,IF(Worksheet!F31=\"\",IF(Worksheet!G31=\"\",\"\",Worksheet!G31),Worksheet!F31))","v":""},{"$f":"IF(OR(Worksheet!C31=\"LF\",Worksheet!C31=\"LS\")=TRUE,\"GPM\",IF(Worksheet!F31=\"\",IF(Worksheet!G31=\"\",\"\",\"MBh\"),\"Gallons\"))","v":""},null,null,{"$f":"IF(Worksheet!Q31>0,Worksheet!Q31,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!O31)=FALSE,Worksheet!O31,\"\")","v":""},{"$f":"IFERROR(Worksheet!Y31/I17,\"\")","v":""},{"$f":"IFERROR(Worksheet!AA31/I17,\"\")","v":""},{"$f":"IFERROR(Worksheet!AC31/I17,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!U31)=FALSE, Worksheet!U31,\"\")/I17,0)","v":0},{"$f":"IFERROR(IF(ISBLANK(Worksheet!W31)=FALSE, Worksheet!W31,\"\")/I17,0)","v":0},{"$f":"IF(ISBLANK(Worksheet!H31)=FALSE, Worksheet!H31,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!I31)=FALSE, Worksheet!I31,\"\")","v":""},null,{"$f":"IF(ISBLANK(Worksheet!P31)=FALSE,Worksheet!P31,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!R31,\"\")","v":0}]
[{"$f":"IF(Worksheet!C32=\"LF\",252,IF(Worksheet!C32=\"LS\",252,IF(ISBLANK(Worksheet!O32)=FALSE,IF(ISBLANK(Worksheet!F32)=FALSE,IF(Worksheet!F32>50,88,87),87),\"\")))","v":""},{"$f":"IF(ISBLANK(Worksheet!D32) = FALSE,Worksheet!D32,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E32) = FALSE,Worksheet!E32,\"\")","v":""},{"$f":"IF(OR(Worksheet!C32=\"LF\",Worksheet!C32=\"LS\")=TRUE,Worksheet!N32,IF(Worksheet!F32=\"\",IF(Worksheet!G32=\"\",\"\",Worksheet!G32),Worksheet!F32))","v":""},{"$f":"IF(OR(Worksheet!C32=\"LF\",Worksheet!C32=\"LS\")=TRUE,\"GPM\",IF(Worksheet!F32=\"\",IF(Worksheet!G32=\"\",\"\",\"MBh\"),\"Gallons\"))","v":""},null,null,{"$f":"IF(Worksheet!Q32>0,Worksheet!Q32,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!O32)=FALSE,Worksheet!O32,\"\")","v":""},{"$f":"IFERROR(Worksheet!Y32/I18,\"\")","v":""},{"$f":"IFERROR(Worksheet!AA32/I18,\"\")","v":""},{"$f":"IFERROR(Worksheet!AC32/I18,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!U32)=FALSE, Worksheet!U32,\"\")/I18,0)","v":0},{"$f":"IFERROR(IF(ISBLANK(Worksheet!W32)=FALSE, Worksheet!W32,\"\")/I18,0)","v":0},{"$f":"IF(ISBLANK(Worksheet!H32)=FALSE, Worksheet!H32,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!I32)=FALSE, Worksheet!I32,\"\")","v":""},null,{"$f":"IF(ISBLANK(Worksheet!P32)=FALSE,Worksheet!P32,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!R32,\"\")","v":0}]
[{"$f":"IF(Worksheet!C33=\"LF\",252,IF(Worksheet!C33=\"LS\",252,IF(ISBLANK(Worksheet!O33)=FALSE,IF(ISBLANK(Worksheet!F33)=FALSE,IF(Worksheet!F33>50,88,87),87),\"\")))","v":""},{"$f":"IF(ISBLANK(Worksheet!D33) = FALSE,Worksheet!D33,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E33) = FALSE,Worksheet!E33,\"\")","v":""},{"$f":"IF(OR(Worksheet!C33=\"LF\",Worksheet!C33=\"LS\")=TRUE,Worksheet!N33,IF(Worksheet!F33=\"\",IF(Worksheet!G33=\"\",\"\",Worksheet!G33),Worksheet!F33))","v":""},{"$f":"IF(OR(Worksheet!C33=\"LF\",Worksheet!C33=\"LS\")=TRUE,\"GPM\",IF(Worksheet!F33=\"\",IF(Worksheet!G33=\"\",\"\",\"MBh\"),\"Gallons\"))","v":""},null,null,{"$f":"IF(Worksheet!Q33>0,Worksheet!Q33,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!O33)=FALSE,Worksheet!O33,\"\")","v":""},{"$f":"IFERROR(Worksheet!Y33/I19,\"\")","v":""},{"$f":"IFERROR(Worksheet!AA33/I19,\"\")","v":""},{"$f":"IFERROR(Worksheet!AC33/I19,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!U33)=FALSE, Worksheet!U33,\"\")/I19,0)","v":0},{"$f":"IFERROR(IF(ISBLANK(Worksheet!W33)=FALSE, Worksheet!W33,\"\")/I19,0)","v":0},{"$f":"IF(ISBLANK(Worksheet!H33)=FALSE, Worksheet!H33,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!I33)=FALSE, Worksheet!I33,\"\")","v":""},null,{"$f":"IF(ISBLANK(Worksheet!P33)=FALSE,Worksheet!P33,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!R33,\"\")","v":0}]
[{"$f":"IF(Worksheet!C34=\"LF\",252,IF(Worksheet!C34=\"LS\",252,IF(ISBLANK(Worksheet!O34)=FALSE,IF(ISBLANK(Worksheet!F34)=FALSE,IF(Worksheet!F34>50,88,87),87),\"\")))","v":""},{"$f":"IF(ISBLANK(Worksheet!D34) = FALSE,Worksheet!D34,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E34) = FALSE,Worksheet!E34,\"\")","v":""},{"$f":"IF(OR(Worksheet!C34=\"LF\",Worksheet!C34=\"LS\")=TRUE,Worksheet!N34,IF(Worksheet!F34=\"\",IF(Worksheet!G34=\"\",\"\",Worksheet!G34),Worksheet!F34))","v":""},{"$f":"IF(OR(Worksheet!C34=\"LF\",Worksheet!C34=\"LS\")=TRUE,\"GPM\",IF(Worksheet!F34=\"\",IF(Worksheet!G34=\"\",\"\",\"MBh\"),\"Gallons\"))","v":""},null,null,{"$f":"IF(Worksheet!Q34>0,Worksheet!Q34,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!O34)=FALSE,Worksheet!O34,\"\")","v":""},{"$f":"IFERROR(Worksheet!Y34/I20,\"\")","v":""},{"$f":"IFERROR(Worksheet!AA34/I20,\"\")","v":""},{"$f":"IFERROR(Worksheet!AC34/I20,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!U34)=FALSE, Worksheet!U34,\"\")/I20,0)","v":0},{"$f":"IFERROR(IF(ISBLANK(Worksheet!W34)=FALSE, Worksheet!W34,\"\")/I20,0)","v":0},{"$f":"IF(ISBLANK(Worksheet!H34)=FALSE, Worksheet!H34,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!I34)=FALSE, Worksheet!I34,\"\")","v":""},null,{"$f":"IF(ISBLANK(Worksheet!P34)=FALSE,Worksheet!P34,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!R34,\"\")","v":0}]
[{"$f":"IF(Worksheet!C35=\"LF\",252,IF(Worksheet!C35=\"LS\",252,IF(ISBLANK(Worksheet!O35)=FALSE,IF(ISBLANK(Worksheet!F35)=FALSE,IF(Worksheet!F35>50,88,87),87),\"\")))","v":""},{"$f":"IF(ISBLANK(Worksheet!D35) = FALSE,Worksheet!D35,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E35) = FALSE,Worksheet!E35,\"\")","v":""},{"$f":"IF(OR(Worksheet!C35=\"LF\",Worksheet!C35=\"LS\")=TRUE,Worksheet!N35,IF(Worksheet!F35=\"\",IF(Worksheet!G35=\"\",\"\",Worksheet!G35),Worksheet!F35))","v":""},{"$f":"IF(OR(Worksheet!C35=\"LF\",Worksheet!C35=\"LS\")=TRUE,\"GPM\",IF(Worksheet!F35=\"\",IF(Worksheet!G35=\"\",\"\",\"MBh\"),\"Gallons\"))","v":""},null,null,{"$f":"IF(Worksheet!Q35>0,Worksheet!Q35,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!O35)=FALSE,Worksheet!O35,\"\")","v":""},{"$f":"IFERROR(Worksheet!Y35/I21,\"\")","v":""},{"$f":"IFERROR(Worksheet!AA35/I21,\"\")","v":""},{"$f":"IFERROR(Worksheet!AC35/I21,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!U35)=FALSE, Worksheet!U35,\"\")/I21,0)","v":0},{"$f":"IFERROR(IF(ISBLANK(Worksheet!W35)=FALSE, Worksheet!W35,\"\")/I21,0)","v":0},{"$f":"IF(ISBLANK(Worksheet!H35)=FALSE, Worksheet!H35,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!I35)=FALSE, Worksheet!I35,\"\")","v":""},null,{"$f":"IF(ISBLANK(Worksheet!P35)=FALSE,Worksheet!P35,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!R35,\"\")","v":0}]
[{"$f":"IF(Worksheet!C36=\"LF\",252,IF(Worksheet!C36=\"LS\",252,IF(ISBLANK(Worksheet!O36)=FALSE,IF(ISBLANK(Worksheet!F36)=FALSE,IF(Worksheet!F36>50,88,87),87),\"\")))","v":""},{"$f":"IF(ISBLANK(Worksheet!D36) = FALSE,Worksheet!D36,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E36) = FALSE,Worksheet!E36,\"\")","v":""},{"$f":"IF(OR(Worksheet!C36=\"LF\",Worksheet!C36=\"LS\")=TRUE,Worksheet!N36,IF(Worksheet!F36=\"\",IF(Worksheet!G36=\"\",\"\",Worksheet!G36),Worksheet!F36))","v":""},{"$f":"IF(OR(Worksheet!C36=\"LF\",Worksheet!C36=\"LS\")=TRUE,\"GPM\",IF(Worksheet!F36=\"\",IF(Worksheet!G36=\"\",\"\",\"MBh\"),\"Gallons\"))","v":""},null,null,{"$f":"IF(Worksheet!Q36>0,Worksheet!Q36,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!O36)=FALSE,Worksheet!O36,\"\")","v":""},{"$f":"IFERROR(Worksheet!Y36/I22,\"\")","v":""},{"$f":"IFERROR(Worksheet!AA36/I22,\"\")","v":""},{"$f":"IFERROR(Worksheet!AC36/I22,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!U36)=FALSE, Worksheet!U36,\"\")/I22,0)","v":0},{"$f":"IFERROR(IF(ISBLANK(Worksheet!W36)=FALSE, Worksheet!W36,\"\")/I22,0)","v":0},{"$f":"IF(ISBLANK(Worksheet!H36)=FALSE, Worksheet!H36,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!I36)=FALSE, Worksheet!I36,\"\")","v":""},null,{"$f":"IF(ISBLANK(Worksheet!P36)=FALSE,Worksheet!P36,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!R36,\"\")","v":0}]
[{"$f":"IF(Worksheet!C37=\"LF\",252,IF(Worksheet!C37=\"LS\",252,IF(ISBLANK(Worksheet!O37)=FALSE,IF(ISBLANK(Worksheet!F37)=FALSE,IF(Worksheet!F37>50,88,87),87),\"\")))","v":""},{"$f":"IF(ISBLANK(Worksheet!D37) = FALSE,Worksheet!D37,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E37) = FALSE,Worksheet!E37,\"\")","v":""},{"$f":"IF(OR(Worksheet!C37=\"LF\",Worksheet!C37=\"LS\")=TRUE,Worksheet!N37,IF(Worksheet!F37=\"\",IF(Worksheet!G37=\"\",\"\",Worksheet!G37),Worksheet!F37))","v":""},{"$f":"IF(OR(Worksheet!C37=\"LF\",Worksheet!C37=\"LS\")=TRUE,\"GPM\",IF(Worksheet!F37=\"\",IF(Worksheet!G37=\"\",\"\",\"MBh\"),\"Gallons\"))","v":""},null,null,{"$f":"IF(Worksheet!Q37>0,Worksheet!Q37,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!O37)=FALSE,Worksheet!O37,\"\")","v":""},{"$f":"IFERROR(Worksheet!Y37/I23,\"\")","v":""},{"$f":"IFERROR(Worksheet!AA37/I23,\"\")","v":""},{"$f":"IFERROR(Worksheet!AC37/I23,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!U37)=FALSE, Worksheet!U37,\"\")/I23,0)","v":0},{"$f":"IFERROR(IF(ISBLANK(Worksheet!W37)=FALSE, Worksheet!W37,\"\")/I23,0)","v":0},{"$f":"IF(ISBLANK(Worksheet!H37)=FALSE, Worksheet!H37,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!I37)=FALSE, Worksheet!I37,\"\")","v":""},null,{"$f":"IF(ISBLANK(Worksheet!P37)=FALSE,Worksheet!P37,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!R37,\"\")","v":0}]
[{"$f":"IF(Worksheet!C38=\"LF\",252,IF(Worksheet!C38=\"LS\",252,IF(ISBLANK(Worksheet!O38)=FALSE,IF(ISBLANK(Worksheet!F38)=FALSE,IF(Worksheet!F38>50,88,87),87),\"\")))","v":""},{"$f":"IF(ISBLANK(Worksheet!D38) = FALSE,Worksheet!D38,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E38) = FALSE,Worksheet!E38,\"\")","v":""},{"$f":"IF(OR(Worksheet!C38=\"LF\",Worksheet!C38=\"LS\")=TRUE,Worksheet!N38,IF(Worksheet!F38=\"\",IF(Worksheet!G38=\"\",\"\",Worksheet!G38),Worksheet!F38))","v":""},{"$f":"IF(OR(Worksheet!C38=\"LF\",Worksheet!C38=\"LS\")=TRUE,\"GPM\",IF(Worksheet!F38=\"\",IF(Worksheet!G38=\"\",\"\",\"MBh\"),\"Gallons\"))","v":""},null,null,{"$f":"IF(Worksheet!Q38>0,Worksheet!Q38,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!O38)=FALSE,Worksheet!O38,\"\")","v":""},{"$f":"IFERROR(Worksheet!Y38/I24,\"\")","v":""},{"$f":"IFERROR(Worksheet!AA38/I24,\"\")","v":""},{"$f":"IFERROR(Worksheet!AC38/I24,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!U38)=FALSE, Worksheet!U38,\"\")/I24,0)","v":0},{"$f":"IFERROR(IF(ISBLANK(Worksheet!W38)=FALSE, Worksheet!W38,\"\")/I24,0)","v":0},{"$f":"IF(ISBLANK(Worksheet!H38)=FALSE, Worksheet!H38,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!I38)=FALSE, Worksheet!I38,\"\")","v":""},null,{"$f":"IF(ISBLANK(Worksheet!P38)=FALSE,Worksheet!P38,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!R38,\"\")","v":0}]
[{"$f":"IF(Worksheet!C39=\"LF\",252,IF(Worksheet!C39=\"LS\",252,IF(ISBLANK(Worksheet!O39)=FALSE,IF(ISBLANK(Worksheet!F39)=FALSE,IF(Worksheet!F39>50,88,87),87),\"\")))","v":""},{"$f":"IF(ISBLANK(Worksheet!D39) = FALSE,Worksheet!D39,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E39) = FALSE,Worksheet!E39,\"\")","v":""},{"$f":"IF(OR(Worksheet!C39=\"LF\",Worksheet!C39=\"LS\")=TRUE,Worksheet!N39,IF(Worksheet!F39=\"\",IF(Worksheet!G39=\"\",\"\",Worksheet!G39),Worksheet!F39))","v":""},{"$f":"IF(OR(Worksheet!C39=\"LF\",Worksheet!C39=\"LS\")=TRUE,\"GPM\",IF(Worksheet!F39=\"\",IF(Worksheet!G39=\"\",\"\",\"MBh\"),\"Gallons\"))","v":""},null,null,{"$f":"IF(Worksheet!Q39>0,Worksheet!Q39,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!O39)=FALSE,Worksheet!O39,\"\")","v":""},{"$f":"IFERROR(Worksheet!Y39/I25,\"\")","v":""},{"$f":"IFERROR(Worksheet!AA39/I25,\"\")","v":""},{"$f":"IFERROR(Worksheet!AC39/I25,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!U39)=FALSE, Worksheet!U39,\"\")/I25,0)","v":0},{"$f":"IFERROR(IF(ISBLANK(Worksheet!W39)=FALSE, Worksheet!W39,\"\")/I25,0)","v":0},{"$f":"IF(ISBLANK(Worksheet!H39)=FALSE, Worksheet!H39,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!I39)=FALSE, Worksheet!I39,\"\")","v":""},null,{"$f":"IF(ISBLANK(Worksheet!P39)=FALSE,Worksheet!P39,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!R39,\"\")","v":0}]
[{"$f":"IF(Worksheet!C40=\"LF\",252,IF(Worksheet!C40=\"LS\",252,IF(ISBLANK(Worksheet!O40)=FALSE,IF(ISBLANK(Worksheet!F40)=FALSE,IF(Worksheet!F40>50,88,87),87),\"\")))","v":""},{"$f":"IF(ISBLANK(Worksheet!D40) = FALSE,Worksheet!D40,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!E40) = FALSE,Worksheet!E40,\"\")","v":""},{"$f":"IF(OR(Worksheet!C40=\"LF\",Worksheet!C40=\"LS\")=TRUE,Worksheet!N40,IF(Worksheet!F40=\"\",IF(Worksheet!G40=\"\",\"\",Worksheet!G40),Worksheet!F40))","v":""},{"$f":"IF(OR(Worksheet!C40=\"LF\",Worksheet!C40=\"LS\")=TRUE,\"GPM\",IF(Worksheet!F40=\"\",IF(Worksheet!G40=\"\",\"\",\"MBh\"),\"Gallons\"))","v":""},null,null,{"$f":"IF(Worksheet!Q40>0,Worksheet!Q40,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!O40)=FALSE,Worksheet!O40,\"\")","v":""},{"$f":"IFERROR(Worksheet!Y40/I26,\"\")","v":""},{"$f":"IFERROR(Worksheet!AA40/I26,\"\")","v":""},{"$f":"IFERROR(Worksheet!AC40/I26,\"\")","v":""},{"$f":"IFERROR(IF(ISBLANK(Worksheet!U40)=FALSE, Worksheet!U40,\"\")/I26,0)","v":0},{"$f":"IFERROR(IF(ISBLANK(Worksheet!W40)=FALSE, Worksheet!W40,\"\")/I26,0)","v":0},{"$f":"IF(ISBLANK(Worksheet!H40)=FALSE, Worksheet!H40,\"\")","v":""},{"$f":"IF(ISBLANK(Worksheet!I40)=FALSE, Worksheet!I40,\"\")","v":""},null,{"$f":"IF(ISBLANK(Worksheet!P40)=FALSE,Worksheet!P40,\"\")","v":""},{"$f":"IF(Worksheet!$A$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$A$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$B$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$11=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IF(Worksheet!$C$12=TRUE,\"Y\",\"N\")","v":"N"},{"$f":"IFERROR(Worksheet!R40,\"\")","v":0}]

{"sheet":"Version","index":4,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[14,"<-Version"]
["Log"]
["2007-09-25",null,"Corrected incentive and savings calculation to account for difference between EF and AFUE units (fraction vs %)"]
["2007-10-02",null,"Added project information in rows 6-10"]
["2007-12-04",null,"Booster heater calculations added"]
["2008-01-08",null,"Corrected for new protocol and fixed faulty booster heater gas usage calculation"]
["2008-12-01",null,"Updated for compatability with measure tracking"]
["2011-09-30",null,"Updated gas savings calculation by removing quantity installed and commited from the calcualtion formula in \"worksheet\" tab and dividing commited quantity in \"Export\" tab in annual gas saving formula"]
["2012-01-13","V5","no change for 2012"]
["2012-07-11",null,"For tankless water heaters ,Added incentive for EF=82, before it was only >82"]
["2013-07-09","V7","no change for V7, skipped V6"]
["2018-06-21","V12","Updated to align with FY19 Protocols; Restored Booster Water Heater incentives"]
["2019-07-01","V13","Added Enhanced Incentive Eligibility Section and Updated for FY20 Program"]
["2020-10-01","V14","Updated for FY21 Program"]