{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Engine to Electric Motor","Electric Tractor","Heat Pump Space Heating","Water Heating","Information","Basic Fuel Switch","Basic Fuel Switch Tractor","Heat Pump Calculations","Water Heating Calculations","Technologies"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":4,"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":"Engine to Electric Motor","index":0,"n_rows":36,"n_cols":5,"rows_kept":36,"cut":false,"hidden":false,"merged":[[52,1,52,2],[52,3,52,5],[53,1,53,2],[53,3,53,5],[54,3,54,5],[49,1,49,2],[49,3,49,5],[50,1,50,2],[50,3,50,5],[51,1,51,2],[51,3,51,5],[48,1,48,2],[48,3,48,5],[45,1,45,2],[46,1,46,2],[46,3,46,5],[47,1,47,2],[47,3,47,5]]}
[null,"Engine to Electric Motor"]
[]
[]
[]
[]
[]
[]
[null,null,"Fuel Type: ","Diesel"]
[null,null,"Fuel Cost: ",4,{"$f":"VLOOKUP(D8,Technologies!B1:C8,2,FALSE)","v":"$/gallon"}]
[null,null,"Total Estimated Amount of Fuel Used: ",500,{"$f":"VLOOKUP(D8,Technologies!B1:D9,3,FALSE)","v":"gallons"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Approximate Horsepower of Proposed Motor: ",100]
[null,null,"Average cost of Electricity in NY ($0.15 per kWh default): ",0.15]
[]
[]
[]
[]
[]
[null,null,"New Estimated Electric Motor Efficiency: ",{"$f":"'Basic Fuel Switch'!H9","v":0.95399999999999996}]
[null,null,"Estimated Cost of Proposed Equipment: ",{"$f":"'Basic Fuel Switch'!B18","v":10900}]
[]
[]
[]
[]
[]
[null,null,"Annual Cost Savings ($) :    ",{"$f":"'Basic Fuel Switch'!B16","v":1050.4127358490568}]
[null,null,"Simple Payback Period (yr) :    ",{"$f":"'Basic Fuel Switch'!B19","v":10.376873421274205}]
[]
[]
[null,null,":"]

{"sheet":"Electric Tractor","index":1,"n_rows":38,"n_cols":5,"rows_kept":38,"cut":false,"hidden":false,"merged":[[52,1,52,2],[52,3,52,5],[53,1,53,2],[53,3,53,5],[54,3,54,5],[49,1,49,2],[49,3,49,5],[50,1,50,2],[50,3,50,5],[51,1,51,2],[51,3,51,5],[48,1,48,2],[48,3,48,5],[45,1,45,2],[46,1,46,2],[46,3,46,5],[47,1,47,2],[47,3,47,5]]}
[null,"Electric Tractor"]
[]
[]
[]
[]
[]
[]
[null,null,"Fuel Type: ","Diesel"]
[null,null,"Fuel Cost: ",4,{"$f":"VLOOKUP(D8,Technologies!B1:C8,2,FALSE)","v":"$/gallon"}]
[null,null,"Total Estimated Amount of Fuel Used: ",2000,{"$f":"VLOOKUP(D8,Technologies!B1:D9,3,FALSE)","v":"gallons"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Approximate Horsepower of Proposed Tractor: ",75]
[null,null,"Average cost of Electricity in NY ($0.15 per kWh default): ",0.15]
[]
[]
[]
[]
[]
[null,null,"New Estimated Electric Tractor Efficiency: ",{"$f":"'Basic Fuel Switch Tractor'!H8","v":0.95399999999999996}]
[null,null,"Estimated Cost of Proposed Equipment: ",50000]
[]
[null,"*Note that electric tractor technology is advancing quickly and there are many electric tractors manufacturers bringing their products to market currently. Pricing and technical specifications will also vary widely "]
[]
[]
[]
[null,null,"Annual Cost Savings ($) :    ",{"$f":"'Basic Fuel Switch Tractor'!B16","v":4391.5683962264156}]
[null,null,"Simple Payback Period (yr) :    ",{"$f":"'Basic Fuel Switch Tractor'!B19","v":11.385454008404826}]
[]
[]
[null,null,":"]
[null,"https://www.monarchtractor.com/mkv-electric-tractor.html "]
[null,"https://solectrac.com/e70n-electric-tractor "]

{"sheet":"Heat Pump Space Heating","index":2,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":false,"merged":[[52,1,52,2],[52,3,52,5],[53,1,53,2],[53,3,53,5],[54,3,54,5],[49,1,49,2],[49,3,49,5],[50,1,50,2],[50,3,50,5],[51,1,51,2],[51,3,51,5],[36,1,36,2],[48,1,48,2],[48,3,48,5],[45,1,45,2],[46,1,46,2],[46,3,46,5],[47,1,47,2],[47,3,47,5]]}
[null,"Heat Pump Space Heating"]
[]
[]
[]
[]
[]
[]
[null,null,"Fuel Type: ","Propane"]
[null,null,"Fuel Cost: ",4,{"$f":"VLOOKUP(D8,Technologies!B1:C8,2,FALSE)","v":"$/gallon"}]
[null,null,"Total Estimated Amount of Fuel Used: ",500,{"$f":"VLOOKUP(D8,Technologies!B1:D9,3,FALSE)","v":"gallons"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Approximate Existing System Size (Btu/h): ",48000]
[null,null,"Existing System Estimated Efficiency: ",0.8]
[null,null,"Average cost of Electricity in NY ($0.15 per kWh default): ",0.15]
[null,null,"New Heat Pump Heating Efficiency (HSPF): ",10]
[]
[]
[]
[]
[null,null,"Estimated Cost of Proposed Equipment: ",{"$f":"VLOOKUP(D18,Technologies!Q1:S11,3,FALSE)","v":6000}]
[]
[]
[]
[]
[]
[null,null,"Annual Cost Savings ($) :    ",{"$f":"'Heat Pump Calculations'!B19","v":657.82878077373994}]
[null,null,"Simple Payback Period (yr) :    ",{"$f":"'Heat Pump Calculations'!B21","v":9.1209144010737635}]
[]
[]
[null,null,":"]
[null,"https://www.nationalgridus.com/media/pdfs/resi-ways-to-save/ee7440uny-ehcustomerflyer.pdf"]

{"sheet":"Water Heating","index":3,"n_rows":39,"n_cols":5,"rows_kept":39,"cut":false,"hidden":false,"merged":[[54,1,54,2],[54,3,54,5],[55,1,55,2],[55,3,55,5],[56,3,56,5],[51,1,51,2],[51,3,51,5],[52,1,52,2],[52,3,52,5],[53,1,53,2],[53,3,53,5],[50,1,50,2],[50,3,50,5],[47,1,47,2],[48,1,48,2],[48,3,48,5],[49,1,49,2],[49,3,49,5]]}
[null,"Water Heating"]
[]
[]
[]
[]
[]
[]
[null,null,"Fuel Type: ","Propane"]
[null,null,"Fuel Cost: ",4,{"$f":"VLOOKUP(D8,Technologies!B1:C8,2,FALSE)","v":"$/gallon"}]
[null,null,"Total Estimated Amount of Fuel Used: ",10000,{"$f":"VLOOKUP(D8,Technologies!B1:D9,3,FALSE)","v":"gallons"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Existing System Estimated Efficiency: ",0.8]
[null,null,"Existing Water Heater Temperature Setpoint (°F): ",140]
[null,null,"Average cost of Electricity in NY ($0.15 per kWh default): ",0.15]
[]
[]
[]
[]
[]
[null,null,"New Estimated Heat Pump Water Heater COP: ",4.2]
[null,null,"Approximate Number of Heat Pump Water Heaters Required: ",{"$f":"'Water Heating Calculations'!B25","v":3}]
[null,null,"Estimated Cost of Proposed Equipment: ",{"$f":"'Water Heating Calculations'!B26","v":30000}]
[]
[null,"*Note that for temperatures above 150°F supplemental heating may be required"]
[]
[]
[]
[null,null,"Annual Cost Savings ($) :    ",{"$f":"'Basic Fuel Switch'!B16","v":1050.4127358490568}]
[null,null,"Simple Payback Period (yr) :    ",{"$f":"'Basic Fuel Switch'!B19","v":10.376873421274205}]
[]
[]
[null,null,":"]
[null,"https://www.hotwater.com/water-heaters/commercial/water-heaters/heat-pump/chp-120-fully-integrated-heat-pump/ "]

{"sheet":"Information","index":4,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":false,"merged":[[6,0,6,1],[0,0,0,1],[7,0,7,1],[5,0,5,1],[1,0,1,1]]}
["Resources:"]
[]
["Electric Tractors:"]
["https://www.monarchtractor.com/mkv-electric-tractor.html "]
["https://solectrac.com/e70n-electric-tractor "]
[]
["Heat Space Heating Pump:"]
["https://www.nationalgridus.com/media/pdfs/resi-ways-to-save/ee7440uny-ehcustomerflyer.pdf"]

{"sheet":"Basic Fuel Switch","index":5,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Units","BTU/Unit","MegaJoules per unit"]
[{"$f":"'Engine to Electric Motor'!D8","v":"Diesel"},{"$f":"VLOOKUP(A3,Technologies!B1:F9,3,FALSE)","v":"gallons"},{"$f":"VLOOKUP(A3,Technologies!B1:F9,4,FALSE)","v":137380.95199999999},{"$f":"VLOOKUP(A3,Technologies!B1:F9,5,FALSE)","v":144.94499999999999}]
[]
["Calculations",null,null,null,null,null,"Efficiencies"]
["Total Fuel Use (UNITS)",{"$f":"'Engine to Electric Motor'!D10","v":500},null,null,null,null,"Old Motor Efficiency",0.3]
["Price of UNIT ($)",{"$f":"'Engine to Electric Motor'!D9","v":4},null,null,null,null,"Old Pump Efficiency",1]
["Total Paid for FUEL ($)",{"$f":"$B$6*$B$7","v":2000},null,null,null,null,"Old Drivetrain Efficiency",1]
["Total Fuel MegaJoules Used",{"$f":"B6*D3","v":72472.5},null,null,null,null,"New Electric Motor Efficiency",{"$f":"_xlfn.XLOOKUP('Engine to Electric Motor'!D18,Technologies!I2:I20,Technologies!O2:O20)","v":0.95399999999999996}]
["Total Estimated Electric Used (kWh)-@ same EFF",{"$f":"B9/Technologies!F9","v":20131.25},null,null,null,null,"New Pump Efficiency",1]
["Total Estimated Electric Used (kWh)-@ NEW EFF",{"$f":"B10*((H6*H7*H8)/(H9*H10*H11))","v":6330.5817610062886},null,null,null,null,"New Drivetrain Efficiency",1]
["Total Estimated Savings (kWh)",{"$f":"B10-B11","v":13800.668238993712},null,null,null,null,"Old Total Dynamic Head (ft)",1]
["Cost of Electricity ($/kWh)",{"$f":"'Engine to Electric Motor'!D19","v":0.15},null,null,null,null,"New Total Dynamic Head (ft)",1]
[]
["Total Cost of Electricity ($)",{"$f":"B11*$B$13","v":949.58726415094327}]
["Cost Savings ($)",{"$f":"$B$8-$B$15","v":1050.4127358490568}]
[]
["Quote for Upgrades ($)",{"$f":"_xlfn.XLOOKUP('Engine to Electric Motor'!D18,Technologies!I2:I20,Technologies!J2:J20)","v":10900}]
["Payback Time (Years)",{"$f":"$B$18/$B$16","v":10.376873421274205}]

{"sheet":"Basic Fuel Switch Tractor","index":6,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Units","BTU/Unit","MegaJoules per unit"]
[{"$f":"'Electric Tractor'!D8","v":"Diesel"},{"$f":"VLOOKUP(A3,Technologies!B1:F9,3,FALSE)","v":"gallons"},{"$f":"VLOOKUP(A3,Technologies!B1:F9,4,FALSE)","v":137380.95199999999},{"$f":"VLOOKUP(A3,Technologies!B1:F9,5,FALSE)","v":144.94499999999999}]
[]
["Calculations",null,null,null,null,null,"Efficiencies"]
["Total Fuel Use (UNITS)",{"$f":"'Electric Tractor'!D10","v":2000},null,null,null,null,"Old Motor Efficiency",0.3]
["Price of UNIT ($)",{"$f":"'Electric Tractor'!D9","v":4},null,null,null,null,"Old Drivetrain Efficiency",0.95]
["Total Paid for FUEL ($)",{"$f":"$B$6*$B$7","v":8000},null,null,null,null,"New Electric Motor Efficiency",{"$f":"_xlfn.XLOOKUP('Electric Tractor'!D18,Technologies!I2:I20,Technologies!O2:O20)","v":0.95399999999999996}]
["Total Fuel MegaJoules Used",{"$f":"B6*D3","v":289890},null,null,null,null,"New Drivetrain Efficiency",1]
["Total Estimated Electric Used (kWh)-@ same EFF",{"$f":"B9/Technologies!F9","v":80525}]
["Total Estimated Electric Used (kWh)-@ NEW EFF",{"$f":"B10*((H6*H7)/(H8*H9))","v":24056.210691823897}]
["Total Estimated Savings (kWh)",{"$f":"B10-B11","v":56468.789308176099}]
["Cost of Electricity ($/kWh)",{"$f":"'Electric Tractor'!D19","v":0.15}]
[]
["Total Cost of Electricity ($)",{"$f":"B11*$B$13","v":3608.4316037735844}]
["Cost Savings ($)",{"$f":"$B$8-$B$15","v":4391.5683962264156}]
[]
["Quote for Upgrades ($)",{"$f":"'Electric Tractor'!D26","v":50000}]
["Payback Time (Years)",{"$f":"$B$18/$B$16","v":11.385454008404826}]

{"sheet":"Heat Pump Calculations","index":7,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Heat Pump Conversion"]
[]
["Existing System",{"$f":"'Heat Pump Space Heating'!D8","v":"Propane"},"Fuel Type"]
[]
["-Heating-"]
["Efficiency",{"$f":"'Heat Pump Space Heating'!D19","v":0.8}]
["Fuel Use",{"$f":"'Heat Pump Space Heating'!D10","v":500}]
["Fuel cost ",{"$f":"'Heat Pump Space Heating'!D9","v":4}]
["Energy Use (Btu/unit)",{"$f":"VLOOKUP(B3,Technologies!B1:F9,4,FALSE)","v":91600}]
["Total Energy Use (Btu)",{"$f":"B7*B9","v":45800000}]
[]
["Proposed System"]
["-Heating-"]
["HSPF",{"$f":"'Heat Pump Space Heating'!D21","v":10}]
["Btu output (Btu/hr)",{"$f":"'Heat Pump Space Heating'!D18","v":48000}]
["Heat Pump Use (kWh)",{"$f":"(B10/B14)/3412","v":1342.3212192262602}]
["Electricity Unit Cost ($/kWh)",{"$f":"'Heat Pump Space Heating'!D20","v":0.15}]
[]
["Total Annual Savings ($/yr)",{"$f":"(B7*B8)-(B16-B17)","v":657.82878077373994}]
["Installed Cost ($)",{"$f":"'Heat Pump Space Heating'!D26","v":6000}]
["Simple Payback (years)",{"$f":"B20/B19","v":9.1209144010737635}]

{"sheet":"Water Heating Calculations","index":8,"n_rows":27,"n_cols":3,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
["Existing Hot Water Heater"]
[]
["Existing System",{"$f":"'Water Heating'!D8","v":"Propane"},"Fuel Type"]
[]
["Description"]
["Current Annual Fuel Use (units)",{"$f":"'Water Heating'!D10","v":10000}]
["Energy Use (Btu/unit)",{"$f":"VLOOKUP(B3,Technologies!B1:F9,4,FALSE)","v":91600}]
["Current Annual Energy Use (Btu)",{"$f":"B6*B7","v":916000000}]
[]
["Ground Water Temp (F)",52]
["Hot Water Temp (F)",{"$f":"'Water Heating'!D19","v":140}]
["Current Water Heater delta T (F)",{"$f":"B11-B10","v":88}]
["New Heater delta T (F)",{"$f":"IF(B11<150.01,B11-B10,(150-B10))","v":88}]
["Old Water Heater Energy Factor",{"$f":"'Water Heating'!D18","v":0.8}]
["Useful Btus Gained ",{"$f":"B14*B8","v":732800000}]
[]
["New HP Water Heater COP",4.2,"*Based on the AO Smith CHP-120 unit"]
["New HP Water Heater Input Power (kW)",2.35]
["New HP Water Heater Output (Btu/hr)",{"$f":"(B18*B17)*3412","v":33676.44}]
["New HP Water Heater Run Time (hr)",{"$f":"B15/B19","v":21760.019764559434}]
["New HP Water Heater Run Time (hr/day)",{"$f":"B20/365","v":59.616492505642285}]
["New HP Water Heater Energy Use (kWh)",{"$f":"B20*B18","v":51136.046446714674}]
[]
["Total Annual Savings ($/yr)",{"$f":"(B6*'Water Heating'!D9)-(B22*'Water Heating'!D20)","v":32329.593032992801}]
["Number of HP Units Required",{"$f":"ROUNDUP((B21/24),0)","v":3}]
["Installed Cost Per Unit ($)",{"$f":"10000*B25","v":30000},"*Need better pricing on this "]
["Simple Payback (years)",{"$f":"B26/B24","v":0.92794239535847489}]

{"sheet":"Technologies","index":9,"n_rows":21,"n_cols":19,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Tech","Fuel Options","Units","Units2","BTU/Unit","MegaJoule/Unit",null,null,"hp","3-phase","1-phase","Cost per HP","RPM","Enclosure","Efficiency",null,"HVAC Sizes","Tons","Cost ($)"]
["Engine to Electric Motor","Diesel","$/gallon","gallons",137380.95199999999,144.94499999999999,null,null,1,500,500,{"$f":"J2/I2","v":500},1800,"tefc",0.85499999999999998,null,12000,{"$f":"Q2/12000","v":1},1500]
["Electric Tractor","Gasoline","$/gallon","gallons",120285.71400000001,126.908,null,null,1.5,520,520,346.66666666666669,1800,"tefc",0.86499999999999999,null,{"$f":"Q2+12000","v":24000},{"$f":"Q3/12000","v":2},{"$f":"S2+1500","v":3000}]
["Heat Pump","Propane","$/gallon","gallons",91600,96.64,null,null,2,560,560,280,1800,"tefc",0.86499999999999999,null,{"$f":"Q3+12000","v":36000},3,{"$f":"S3+1500","v":4500}]
["Water Heating","Natural Gas","$/therm","therms",100000,105.51,null,null,3,600,600,200,1800,"tefc",0.89500000000000002,null,48000,4,6000]
[null,"Coal","$/ton","tons",25000000,{"$f":"E6/947.8","v":26376.872757965815},null,null,5,700,700,140,1800,"tefc",0.89500000000000002,null,60000,5,7500]
[null,"Fuel Oil","$/gallon","gallons",138500,146.13,null,null,7.5,1000,1000,133.33333333333334,1800,"tefc",0.91700000000000004,null,72000,6,9000]
[null,"Wood Pellets","$/ton","tons",17000000,{"$f":"E8/947.8","v":17936.273475416754},null,null,10,1200,1200,120,1800,"tefc",0.91700000000000004,null,84000,{"$f":"Q8/12000","v":7},10500]
[null,"Electricity","$/kWh","kWh",3412,3.6,null,null,15,1500,1500,100,1800,"tefc",0.92400000000000004,null,96000,8,12000]
[null,null,null,null,null,null,null,null,20,2000,2000,100,1800,"tefc",0.93,null,108000,9,13500]
[null,null,null,null,null,null,null,null,25,2500,2500,100,1800,"tefc",0.93600000000000005,null,120000,10,15000]
[null,null,null,null,null,null,null,null,30,3000,3000,100,1800,"tefc",0.93600000000000005]
[null,null,null,null,null,null,null,null,40,3900,3900,97.5,1800,"tefc",0.94099999999999995]
[null,null,null,null,null,null,null,null,50,4700,4700,94,1800,"tefc",0.94499999999999995]
[null,null,null,null,null,null,null,null,60,6900,6900,115,1800,"tefc",0.95]
[null,null,null,null,null,null,null,null,75,8000,8000,106.66666666666667,1800,"tefc",0.95399999999999996]
[null,null,null,null,null,null,null,null,100,10900,10900,109,1800,"tefc",0.95399999999999996]
[null,null,null,null,null,null,null,null,125,13000,13000,104,1800,"tefc",0.95399999999999996]
[null,null,null,null,null,null,null,null,150,16000,16000,106.66666666666667,1800,"tefc",0.95799999999999996]
[null,null,null,null,null,null,null,null,200,19500,19500,97.5,1800,"tefc",0.96199999999999997]
[null,null,null,null," "]