{"text_format":"3","workbook":"xls","n_sheets":16,"sheets":["Instructions, Read First!","Inputs and Outputs","Diesel","Electric","Series Hybrid","Parallel Hybrid","Engine Size","Engine Cost","Propeller Power","Propulsion Power","Shaft RPM","Engine Efficiency","Solar Panels","Batteries","Motor Efficiency","Motor Controller Efficiency"],"not_rendered":{"charts":1,"images":9,"external_links":1},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Instructions, Read First!","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"Inputs and Outputs","index":1,"n_rows":104,"n_cols":12,"rows_kept":104,"flags":["formulas_cached_only"]}
["General Inputs","Value","Units",null,null,"Straight Diesel",{"$nulls":3},"Series Hybrid"]
["Max Speed Under Power",8,"kts",null,null,"Average Hourly Fuel Consumption",{"v":0.8405914140804251,"d":"0.84"},"gal/hr",null,"Average Hourly Fuel Consumption",{"v":0.9897527792836579,"d":"0.99"},"gal/hr"]
["Max Time at Full Power",1,"hours",null,null,"Average Fuel Consumption",{"v":0.1400985690134042,"d":"0.14"},"gal/NM",null,"Average Fuel Consumption",{"v":0.16495879654727633,"d":"0.16"},"gal/NM"]
[{"$nulls":5},"Lifetime Fuel Consumption",{"v":4202.957070402126,"d":"4203"},"gal",null,"Lifetime Fuel Consumption",{"v":4948.76389641829,"d":"4949"},"gal"]
["Cruise Speed Under Power",6,"kts"]
["Max Time Motoring Before Refueling/Recharging",50,"hours",null,null,"Installation Cost",{"v":16640.25,"d":"16640"},"$",null,"Installation Cost",{"v":43630.36152618098,"d":"43630"},"$"]
[{"$nulls":5},"Operating Cost",{"v":21021.452018677297,"d":"21021"},"$",null,"Operating Cost",{"v":25003.792299166224,"d":"25004"},"$"]
["Average House Electrical Load",4,"A @ 12V",null,null,"Total Cost",{"v":37661.7020186773,"d":"37662"},"$",null,"Total Cost",{"v":68634.15382534721,"d":"68634"},"$"]
["Average Total Time Between Shorepower Including Time At Rest",500,"hours"]
["# Solar Panels",2,"#",null,null,"System Size",{"v":18.80981720273439,"d":"19"},"ft^3",null,"System Size",{"v":30.09159214845517,"d":"30"},"ft^3"]
["Battery Life",5,"Years",null,null,"Solar Array",{"v":21.573305555555557,"d":"22"},"ft^2",null,"Solar Array",{"v":21.573305555555557,"d":"22"},"ft^2"]
[{"$nulls":5},"System Weight",{"v":1227.9924403378216,"d":"1228"},"lbs",null,"System Weight",{"v":2938.335444271712,"d":"2938"},"lbs"]
["Total System Life",5000,"hours system usage"]
["System Life",20,"Years",{"$nulls":6},"Parallel Hybrid"]
[{"$nulls":9},"Average Hourly Fuel Consumption",{"v":0.7374082209930601,"d":"0.74"},"gal/hr"]
["Diesel Specific",{"$nulls":8},"Average Fuel Consumption",{"v":0.12290137016551002,"d":"0.12"},"gal/NM"]
["Max Charge Rate at Full Power",25,"A",{"$nulls":6},"Lifetime Fuel Consumption",{"v":3687.0411049653007,"d":"3687"},"gal"]
["# House Batteries",6,"#",null,null,"Straight Electric"]
[{"$nulls":5},"Installation Cost",{"v":459390.5674875974,"d":"459391"},"$",null,"Installation Cost",{"v":33470.19212307568,"d":"33470"},"$"]
["Series Hybrid Specific",{"$nulls":4},"Operating Cost",{"v":5664.621626009975,"d":"5665"},"$",null,"Operating Cost",{"v":18662.550240793214,"d":"18663"},"$"]
["% Series Hybrid Engine Overrate for Cruise",{"v":0.3,"d":"30.00%"},"%",null,null,"Total Cost",{"v":465055.1891136074,"d":"465055"},"$",null,"Total Cost",{"v":52132.74236386889,"d":"52133"},"$"]
["Engine RPM @ Cruise",2000,"rpm"]
[{"$nulls":5},"System Size",{"v":355.75759585184613,"d":"356"},"ft^3",null,"System Size",{"v":24.931264627082907,"d":"25"},"ft^3"]
["Parallel Hybrid Specific",{"$nulls":4},"Solar Array",{"v":21.573305555555557,"d":"22"},"ft^2",null,"Solar Array",{"v":21.573305555555557,"d":"22"},"ft^2"]
["% Parallel Hybrid Engine Overrate for Cruise",{"v":0.5,"d":"50.00%"},"%",null,null,"System Weight",{"v":46935.93343914171,"d":"46936"},"lbs",null,"System Weight",{"v":2452.608494415506,"d":"2453"},"lbs"]
[]
["Assumptions"]
["Gearbox Efficiency",{"v":0.98,"d":"98.00%"},"%"]
["Alternator Efficiency",25,"A/hp"]
["Battery Discharge %",{"v":0.5,"d":"50.00%"},"%"]
["Electricity Cost",0.1,"$/kWh"]
["Sun Factor",0.16666666666666666,"average daily output relative to panel rating"]
["Unusable Portion of Fuel Tank",{"v":0.1,"d":"10.00%"},"%"]
["Fuel Cost",5,"$/gal"]
{"$rows_empty":69}
[{"$nulls":11},"******************************"]

{"sheet":"Diesel","index":2,"n_rows":46,"n_cols":11,"rows_kept":46,"flags":["formulas_cached_only"]}
[{"$nulls":4},"Outputs","Value","Units",null,"Calculations","Value","Units"]
[{"$nulls":4},"Average Hourly Fuel Consumption",0.8405914140804251,"gal/hr",null,"Engine hp",46.594645364848354,"hp"]
[{"$nulls":4},"Average Fuel Consumption",0.1400985690134042,"gal/NM",null,"Engine RPM at Max Speed",3000,"rpm"]
[{"$nulls":4},"Lifetime Fuel Consumption",4202.957070402126,"gal",null,"Torque @max rpm",110.59728275851305,"Nm"]
[{"$nulls":8},"Engine Scaling Factor",0.7627398810931935]
[{"$nulls":4},"Installation Cost",16640.25,"$",null,"RPM Scaling Factor",0.75]
[{"$nulls":4},"Operating Cost",21021.452018677297,"$",null,"Propulsion Power @ Cruise",13.15230154755241,"hp"]
[{"$nulls":4},"Total Cost",37661.7020186773,"$",null,"RPM @ Cruise",1900,"rpm"]
[]
[{"$nulls":4},"System Size",18.80981720273439,"ft^3",null,"Battery Usable Capacity",4.5,"kWh"]
[{"$nulls":4},"Solar Array",21.573305555555557,"ft^2",null,"Solar Generation",23.333333333333332,"kWh"]
[{"$nulls":4},"System Weight",1227.9924403378216,"lbs",null,"Total House Load",24,"kWh"]
[{"$nulls":8},"Net Energy Load",0.6666666666666679,"kWh"]
[{"$nulls":8},"Battery Used Capacity",0.6666666666666679,"kWh"]
[]
[{"$nulls":8},"Alternator Load",0,"kWh"]
[{"$nulls":8},"Alternator Load",0,"A"]
[{"$nulls":8},"Alternator HP",0,"hp"]
[{"$nulls":8},"Total # Battery Cycles",null,"#"]
[{"$nulls":8},"# Battery Sets",4,"#"]
[]
[{"$nulls":8},"Total Power @ Cruise",13.15230154755241,"hp"]
[{"$nulls":8},"Engine Torque @ Cruise",49.292160926825005,"Nm"]
[{"$nulls":8},"Scaled Torque @ Cruise",64.62512600780391,"Nm"]
[{"$nulls":8},"Check Power","yes"]
[{"$nulls":8},"Engine Efficiency @ Cruise",270,"g/kWh"]
[{"$nulls":8},"Fuel Consumption",0.8405914140804251,"gal/hr"]
[{"$nulls":8},"Fuel Consumption",42.02957070402126,"gal/fillup"]
[{"$nulls":8},"Fuel Consumption",4202.957070402126,"gal"]
[]
[{"$nulls":8},"Engine Size",9.438924153645834,"ft^3"]
[{"$nulls":8},"Gearbox Size",0.37471064814814814,"ft^3"]
[{"$nulls":8},"Fuel Tank Size",6.181288963440408,"ft^3"]
[{"$nulls":8},"Battery Size",2.8148934375000003,"ft^3"]
[{"$nulls":8},"Solar Panel Area",21.573305555555557,"ft^2"]
[]
[{"$nulls":8},"Engine Weight",535,"lbs"]
[{"$nulls":8},"Gearbox Weight",null,"lbs"]
[{"$nulls":8},"Fuel Weight",320.99244033782156,"lbs"]
[{"$nulls":8},"Battery Weight",372,"lbs"]
[]
[{"$nulls":8},"Engine/Gearbox Cost",12206.25,"$"]
[{"$nulls":8},"Fuel Cost",21014.78535201063,"$"]
[{"$nulls":8},"Battery Cost",3576,"$"]
[{"$nulls":8},"Solar Panel Cost",858,"$"]
[{"$nulls":8},"Electricity Cost",6.6666666666666785,"$"]

{"sheet":"Electric","index":3,"n_rows":45,"n_cols":11,"rows_kept":45,"flags":["formulas_cached_only"]}
[{"$nulls":4},"Outputs","Value","Units",null,"Calculations","Value","Units"]
[{"$nulls":8},"Propulsion hp",44.68275245755139,"hp"]
[{"$nulls":8},"Motor RPM at Max Speed",2600,"rpm"]
[{"$nulls":8},"Torque @max rpm",122.37600486099758,"Nm"]
[{"$nulls":8},"Motor Scaling Factor",4.479118352310566]
[{"$nulls":4},"Installation Cost",{"v":459390.5674875974,"d":"$459,390.57"},"$",null,"RPM Scaling Factor",0.8653846153846154]
[{"$nulls":4},"Operating Cost",5664.621626009975,"$",null,"Propulsion Power @ Cruise",12.889255516601361,"hp"]
[{"$nulls":4},"Total Cost",{"v":465055.1891136074,"d":"$465,055.19"},"$",null,"RPM @ Cruise",1646.6666666666665,"rpm"]
[]
[{"$nulls":4},"System Size",355.75759585184613,"ft^3",null,"Total # Battery Cycles",null,"#"]
[{"$nulls":4},"Solar Array",21.573305555555557,"ft^2",null,"# Battery Sets",4,"#"]
[{"$nulls":4},"System Weight",46935.93343914171,"lbs"]
[{"$nulls":8},"Power @ Cruise",12.889255516601361,"hp"]
[{"$nulls":8},"Motor Torque @ Cruise",55.738058894179055,"Nm"]
[{"$nulls":8},"Scaled Torque @ Cruise",12.443979933110366,"Nm"]
[{"$nulls":8},"Scaled Torque @ Max",27.32144927536232,"Nm"]
[]
[{"$nulls":8},"Motor Efficiency @ Cruise",{"v":0.8670638972011969,"d":"86.71%"},"%"]
[{"$nulls":8},"Motor Efficiency @ Max",{"v":0.77,"d":"77.00%"},"%"]
[{"$nulls":8},"Motor Controller Efficiency @ Cruise",{"v":0.98,"d":"98.00%"},"%"]
[{"$nulls":8},"Battery Load @ Cruise",11.315909918686616,"kW"]
[{"$nulls":8},"Propulsion Power Requirements @ Cruise",565.7954959343308,"kWh"]
[{"$nulls":8},"Propulsion Power Requirements @ Max",44.17351356126867,"kWh"]
[{"$nulls":8},"Propulsion Power Requirements",565.7954959343308,"kWh"]
[{"$nulls":8},"Total House Load",24,"kWh"]
[{"$nulls":8},"Solar Generation",23.333333333333332,"kWh"]
[{"$nulls":8},"Net Energy Load/Recharge Max",566.4621626009974,"kWh"]
[{"$nulls":8},"Net Energy Max",56646.21626009975,"kWh"]
[{"$nulls":8},"# Batteries Required",755.2828834679966,"#"]
[{"$nulls":8},"Net Energy Load/Recharge",566.4621626009974,"kWh"]
[{"$nulls":8},"Net Energy",56646.21626009975,"kWh"]
[]
[]
[{"$nulls":8},"Motor Size",1.4174571634892748,"ft^3"]
[{"$nulls":8},"Battery Size",354.34013868835683,"ft^3"]
[{"$nulls":8},"Solar Panel Area",21.573305555555557,"ft^2"]
[]
[{"$nulls":8},"Motor Weight",108.39466412591571,"lbs"]
[{"$nulls":8},"Battery Weight",46827.53877501579,"lbs"]
[]
[{"$nulls":8},"Motor Cost",{"v":8383.968940671395,"d":"$8,383.97"},"$"]
[{"$nulls":8},"Motor Controller Cost",1975,"$"]
[{"$nulls":8},"Battery Cost",450148.598546926,"$"]
[{"$nulls":8},"Solar Panel Cost",858,"$"]
[{"$nulls":8},"Electricity Cost",5664.621626009975,"$"]

{"sheet":"Series Hybrid","index":4,"n_rows":73,"n_cols":11,"rows_kept":73,"flags":["formulas_cached_only"]}
[{"$nulls":4},"Outputs","Value","Units",null,"Calculations","Value","Units"]
[{"$nulls":4},"Average Hourly Fuel Consumption",0.9897527792836579,"gal/hr",null,"Propulsion hp",44.68275245755139,"hp"]
[{"$nulls":4},"Average Fuel Consumption",0.16495879654727633,"gal/NM",null,"Torque @max rpm",122.37600486099758,"Nm"]
[{"$nulls":4},"Lifetime Fuel Consumption",4948.76389641829,"gal",null,"Drive Motor Scaling Factor",4.479118352310566]
[{"$nulls":8},"RPM Scaling Factor",0.8653846153846154]
[{"$nulls":4},"Installation Cost",{"v":43630.36152618098,"d":"$43,630.36"},"$",null,"Propulsion Power @ Cruise",12.889255516601361,"hp"]
[{"$nulls":4},"Operating Cost",25003.792299166224,"$",null,"RPM @ Cruise",1646.6666666666665,"rpm"]
[{"$nulls":4},"Total Cost",{"v":68634.15382534721,"d":"$68,634.15"},"$"]
[{"$nulls":8},"Power @ Cruise",12.889255516601361,"hp"]
[{"$nulls":4},"System Size",30.09159214845517,"ft^3",null,"Motor Torque @ Cruise",55.738058894179055,"Nm"]
[{"$nulls":4},"Solar Array",21.573305555555557,"ft^2",null,"Scaled Torque @ Cruise",12.443979933110366,"Nm"]
[{"$nulls":4},"System Weight",2938.335444271712,"lbs"]
[{"$nulls":8},"Motor Efficiency @ Cruise",{"v":0.8670638972011969,"d":"86.71%"},"%"]
[{"$nulls":8},"Motor Controller Efficiency @ Cruise",{"v":0.98,"d":"98.00%"},"%"]
[{"$nulls":8},"Generator Power @ Cruise",15.168780051858736,"hp"]
[{"$nulls":8},"Generator Power Max",19.719414067416356,"hp"]
[{"$nulls":8},"Max Generator RPM",2600,"rpm"]
[{"$nulls":8},"Generator Torque @ Cruise",41.54387541647412,"Nm"]
[{"$nulls":8},"Generator Torque @max rpm",54.00703804141635,"Nm"]
[{"$nulls":8},"Generator Scaling Factor",1.976726691805413,"Nm"]
[{"$nulls":8},"Generator Scaled Torque @ Cruise",21.0164994425864,"Nm"]
[{"$nulls":8},"Generator Scaled Torque @ Max",27.32144927536232,"Nm"]
[{"$nulls":8},"Generator Efficiency @ Cruise",{"v":0.8214604236343367,"d":"82.15%"},"%"]
[{"$nulls":8},"Generator Efficiency @ Max",{"v":0.8188405797101449,"d":"81.88%"},"%"]
[{"$nulls":8},"Engine Output Power Max",24.08211629472086,"hp"]
[{"$nulls":8},"Engine Output Torque Max",57.16143141374686,"Nm"]
[]
[{"$nulls":8},"Motor Scaled Torque @ Max",27.32144927536232,"Nm"]
[{"$nulls":8},"Motor Efficiency @ Max",0.8188405797101449,"%"]
[{"$nulls":8},"Battery and Generator Requirement @ Max",40.707964601769916,"kW"]
[{"$nulls":8},"Generator Output @ Max",14.710682894292601,"kW"]
[{"$nulls":8},"Battery Output @ Max",25.997281707477313,"kW"]
[{"$nulls":8},"Battery Energy @ Max",25.997281707477313,"kWh"]
[{"$nulls":8},"Battery Bank Capacity",51.99456341495463,"kWh"]
[{"$nulls":8},"# Batteries",34.66304227663642,"#"]
[]
[{"$nulls":8},"Drive Power @ Cruise",11.315909918686616,"kW"]
[{"$nulls":8},"Battery Power @ Cruise",0.5199456341495463,"kW"]
[{"$nulls":8},"Solar Power",0.4666666666666666,"kW"]
[{"$nulls":8},"House Battery Consumption",0.48,"kW"]
[{"$nulls":8},"Generator Power @ Cruise",10.809297617870403,"kW"]
[{"$nulls":8},"Generator Torque @ Cruise",39.683959734854334,"Nm"]
[{"$nulls":8},"Generator Scaled Torque @ Cruise",20.07559259424458,"Nm"]
[{"$nulls":8},"Generator Efficiency @ Cruise",{"v":0.8316921205497545,"d":"83.17%"},"%"]
[{"$nulls":8},"Engine Power @ Cruise",17.421921806114156,"hp"]
[{"$nulls":8},"Engine Scaling Factor",0.394216768370668]
[{"$nulls":8},"Engine Torque @ Cruise",62.02914080899292,"Nm"]
[{"$nulls":8},"Scaled Torque @ Cruise",157.3477989415943,"Nm"]
[{"$nulls":8},"Engine Efficiency @ Cruise",240,"g/kWh"]
[{"$nulls":8},"Fuel Consumption",0.9897527792836579,"gal/hr"]
[{"$nulls":8},"Fuel Consumption",49.48763896418289,"gal/fillup"]
[{"$nulls":8},"Fuel Consumption",4948.76389641829,"gal"]
[]
[{"$nulls":8},"Motor Size",1.4174571634892748,"ft^3"]
[{"$nulls":8},"Generator Size",0.6255528854500254,"ft^3"]
[{"$nulls":8},"Engine Size",4.508306665672004,"ft^3"]
[{"$nulls":8},"Battery Size",16.262128371381486,"ft^3"]
[{"$nulls":8},"Solar Panel Area",21.573305555555557,"ft^2"]
[{"$nulls":8},"Fuel Tank Size",7.27814706246238,"ft^3"]
[]
[{"$nulls":8},"Motor Weight",108.39466412591571,"lbs"]
[{"$nulls":8},"Generator Weight",47.836785941691,"lbs"]
[{"$nulls":8},"Engine Weight",255.04342799149265,"lbs"]
[{"$nulls":8},"Battery Weight",2149.108621151458,"lbs"]
[{"$nulls":8},"Fuel Weight",377.95194506115405]
[{"$nulls":8},"Motor Cost",{"v":8383.968940671395,"d":"$8,383.97"},"$"]
[{"$nulls":8},"Motor Controller Cost",1975,"$"]
[{"$nulls":8},"Generator Cost",{"v":3700.017254454454,"d":"$3,700.02"},"$"]
[{"$nulls":8},"Engine Cost",8054.202134179829,"$"]
[{"$nulls":8},"Battery Cost",20659.173196875305,"$"]
[{"$nulls":8},"Solar Panel Cost",858,"$"]
[{"$nulls":8},"Electricity Cost",259.9728170747731,"$"]
[{"$nulls":8},"Fuel Cost",24743.81948209145,"$"]

{"sheet":"Parallel Hybrid","index":5,"n_rows":56,"n_cols":11,"rows_kept":56,"flags":["formulas_cached_only"]}
[{"$nulls":4},"Outputs","Value","Units",null,"Calculations","Value","Units"]
[{"$nulls":4},"Average Hourly Fuel Consumption",0.7374082209930601,"gal/hr",null,"Propulsion hp",44.68275245755139,"hp"]
[{"$nulls":4},"Average Fuel Consumption",0.12290137016551002,"gal/NM",null,"Propulsion Power @ Cruise",13.15230154755241,"hp"]
[{"$nulls":4},"Lifetime Fuel Consumption",3687.0411049653007,"gal",null,"Engine Power Output Max",19.728452321328614,"hp"]
[{"$nulls":8},"Engine Torque @ Max",46.82755288048376,"Nm"]
[{"$nulls":4},"Installation Cost",{"v":33470.19212307568,"d":"$33,470.19"},"$",null,"Engine Scaling Factor",0.3229486405550604]
[{"$nulls":4},"Operating Cost",18662.550240793214,"$",null,"Motor Power Output Max",24.954300136222773,"hp"]
[{"$nulls":4},"Total Cost",{"v":52132.74236386889,"d":"$52,132.74"},"$",null,"Motor Torque @max rpm",68.34421307582399,"Nm"]
[{"$nulls":8},"Motor Scaling Factor",2.501485641812376]
[{"$nulls":4},"System Size",24.931264627082907,"ft^3",null,"RPM Scaling Factor",0.75]
[{"$nulls":4},"Solar Array",21.573305555555557,"ft^2"]
[{"$nulls":4},"System Weight",2452.608494415506,"lbs",null,"Motor Scaled Torque @ Max",27.321449275362323,"Nm"]
[{"$nulls":8},"Motor Efficiency @ Max",0.8188405797101449,"%"]
[{"$nulls":8},"Battery Requirement @ Max",22.734471596671344,"kW"]
[{"$nulls":8},"Battery Energy @ Max",22.734471596671344,"kWh"]
[{"$nulls":8},"Battery Bank Capacity",45.46894319334269,"kWh"]
[{"$nulls":8},"# Propulsions Batteries",30.312628795561793,"#"]
[]
[{"$nulls":8},"Solar Power",23.333333333333332,"kWh"]
[{"$nulls":8},"Total Electrical Power Available",46.06780493000468,"kWh"]
[{"$nulls":8},"House Battery Consumption",24,"kWh"]
[{"$nulls":8},"Battery Propulsion Power Available",22.067804930004677,"kWh"]
[{"$nulls":8},"Battery Propulsion Power Available",0.4413560986000935,"kW"]
[{"$nulls":8},"Scaled Motor Propulsion Power",0.1764375902155178,"kW"]
[{"$nulls":8},"Scaled Motor Torque",0.8112600398109509,"Nm"]
[{"$nulls":8},"Motor Efficiency",{"v":0.2970406746185348,"d":"29.70%"},"%"]
[{"$nulls":8},"Motor Controller Efficiency @ Cruise",{"v":0.98,"d":"98.00%"},"%"]
[{"$nulls":8},"Motor Output @ Cruise",0.1284786990096728,"kW"]
[]
[{"$nulls":8},"Engine Output @ Cruise",12.980078090434887,"hp"]
[{"$nulls":8},"RPM @ Cruise",1900,"rpm"]
[{"$nulls":8},"Engine Torque @ Cruise",48.646702310101695,"Nm"]
[{"$nulls":8},"Scaled Torque @ Cruise",150.63293725742682,"Nm"]
[{"$nulls":8},"Engine Efficiency @ Cruise",240,"g/kWh"]
[{"$nulls":8},"Fuel Consumption",0.7374082209930601,"gal/hr"]
[{"$nulls":8},"Fuel Consumption",36.87041104965301,"gal/fillup"]
[{"$nulls":8},"Fuel Consumption",3687.0411049653007,"gal"]
[]
[{"$nulls":8},"Motor Size",0.7916175603003286,"ft^3"]
[{"$nulls":8},"Engine Size",4.495979068710039,"ft^3"]
[{"$nulls":8},"Battery Size",14.22113664500007,"ft^3"]
[{"$nulls":8},"Solar Panel Area",21.573305555555557,"ft^2"]
[{"$nulls":8},"Fuel Tank Size",5.422531353072469,"ft^3"]
[]
[{"$nulls":8},"Motor Weight",60.5359525318595,"lbs"]
[{"$nulls":8},"Engine Weight",231.0991662493003,"lbs"]
[{"$nulls":8},"Battery Weight",1879.3829853248312,"lbs"]
[{"$nulls":8},"Fuel Weight",281.59039030951493,"lbs"]
[]
[{"$nulls":8},"Motor Cost",{"v":4682.255809487987,"d":"$4,682.26"},"$"]
[{"$nulls":8},"Motor Controller Cost",1975,"$"]
[{"$nulls":8},"Engine Cost",7888.6095514328645,"$"]
[{"$nulls":8},"Battery Cost",18066.32676215483,"$"]
[{"$nulls":8},"Solar Panel Cost",858,"$"]
[{"$nulls":8},"Electricity Cost",227.34471596671344,"$"]
[{"$nulls":8},"Fuel Cost",18435.205524826502,"$"]

{"sheet":"Engine Size","index":6,"n_rows":16,"n_cols":21,"rows_kept":16,"flags":["formulas_cached_only"]}
["Values Used In Model",{"$nulls":9},"Beta Marine Engine Phyiscal Size"]
["Power","Engine Volume","Gearbox Volume","Weight",{"$nulls":6},"Power","L","W","H","Gearbox L","Gearbox W","Gearbox H","Engine Volume","Gearbox Volume","Weight"]
["hp","ft^3","ft^3","lbs",{"$nulls":6},"hp","in","in","in","in","in","in","ft^3","ft^3","lbs"]
[14,3.7685394287109375,0.13020833333333334,198,{"$nulls":6},14,16.6875,16.875,23.125,6.25,6,6,3.7685394287109375,0.13020833333333334,198]
[16,3.8281805019428066,0.13041338582677164,205,{"$nulls":6},16,17.51968503937008,17.125984251968504,22.04724409448819,6.25984251968504,6,6,3.8281805019428066,0.13041338582677164,205]
[20,4.544615643620323,0.13041338582677164,233,{"$nulls":6},20,19.52755905511811,17.401574803149607,23.11023622047244,6.25984251968504,6,6,4.544615643620323,0.13041338582677164,233]
[25,4.500142415364583,0.13020833333333334,260,{"$nulls":6},25,20.375,17.25,22.125,6.25,6,6,4.500142415364583,0.13020833333333334,260]
[28,5.476469616634917,0.27431466899970836,330,{"$nulls":6},28,22.637795275590552,17.755905511811026,23.543307086614174,6.771653543307087,7,10,5.476469616634917,0.27431466899970836,330]
[30,5.476469616634917,0.27431466899970836,330,{"$nulls":6},30,22.637795275590552,17.755905511811026,23.543307086614174,6.771653543307087,7,10,5.476469616634917,0.27431466899970836,330]
[35,7.241308608774626,0.37798009623797035,375,{"$nulls":6},35,25.78740157480315,19.40944881889764,25,9.330708661417324,7,10,7.241308608774626,0.37798009623797035,375]
[38,7.241308608774626,0.37798009623797035,375,{"$nulls":6},38,25.78740157480315,19.40944881889764,25,9.330708661417324,7,10,7.241308608774626,0.37798009623797035,375]
[43,9.438924153645834,0.37471064814814814,535,{"$nulls":6},43,28.5,21.75,26.3125,9.25,7,10,9.438924153645834,0.37471064814814814,535]
[50,9.438924153645834,0.37471064814814814,535,{"$nulls":6},50,28.5,21.75,26.3125,9.25,7,10,9.438924153645834,0.37471064814814814,535]
[60,8.888222323141935,0.5354148439778361,631,{"$nulls":6},60,28.11023622047244,20.590551181102363,26.535433070866144,9.25196850393701,10,10,8.888222323141935,0.5354148439778361,631]
[75,18.77838134765625,0,911,{"$nulls":6},75,43,25.3125,29.8125,0,0,0,18.77838134765625,0,911,"*gearbox size included in engine due to packaging"]
[105,20.394233380603687,0,937,{"$nulls":6},105,46.5748031496063,23.267716535433074,32.51968503937008,0,0,0,20.394233380603687,0,937,"*gearbox size included in engine due to packaging"]

{"sheet":"Engine Cost","index":7,"n_rows":14,"n_cols":8,"rows_kept":14,"flags":["formulas_cached_only"]}
["Values Used in Model",{"$nulls":5},"Beta Prices","(All prices from Beta Marine West)"]
["Power","Price",{"$nulls":4},"Power","Price"]
["hp","$",{"$nulls":4},"hp","$"]
[14,7086.63,{"$nulls":4},14,7086.63]
[16,7542.5,{"$nulls":4},16,7542.5]
[20,8017.63,{"$nulls":4},20,8017.63]
[25,8463,{"$nulls":4},25,8463]
[30,9620.63,{"$nulls":4},30,9620.63]
[35,10470.25,{"$nulls":4},35,10470.25]
[38,10703.88,{"$nulls":4},38,10703.88]
[43,12206.25,{"$nulls":4},43,12206.25]
[50,14210,{"$nulls":4},50,14210]
[75,19072.38,{"$nulls":4},75,19072.38]
[105,21698.25,{"$nulls":4},105,21698.25]

{"sheet":"Propeller Power","index":8,"n_rows":10,"n_cols":3,"rows_kept":10,"flags":["formulas_cached_only"]}
["Speed","Propeller Power","Propeller Power"]
["kts","kW","hp"]
[2,0.5,0.6702412868632708]
[3,1,1.3404825737265416]
[4,2,2.680965147453083]
[5,3,4.021447721179625]
[6,5,6.702412868632708]
[7,8,10.723860589812332]
[8,17,22.78820375335121]
[9,36,48.257372654155496]

{"sheet":"Propulsion Power","index":9,"n_rows":10,"n_cols":3,"rows_kept":10,"flags":["formulas_cached_only"]}
["SOG","Prop Efficiency","Shaft Power"]
["kts","%","hp"]
[2.5,19,3.527585720333004]
[3,27,4.964750273061265]
[4,39,6.874269608854059]
[5,48,8.378016085790884]
[6,52,12.889255516601361]
[7,53,20.233699226061002]
[8,51,44.68275245755139]
[9,44,109.67584694126249]

{"sheet":"Shaft RPM","index":10,"n_rows":9,"n_cols":2,"rows_kept":9,"flags":["formulas_cached_only"]}
["SOG","RPM"]
["kts","rpm"]
[3,750]
[4,950]
[5,1150]
[6,1425]
[7,1750]
[8,2250]
[9,3000]

{"sheet":"Engine Efficiency","index":11,"n_rows":28,"n_cols":18,"rows_kept":28,"merged":[[0,2,0,17]],"flags":["formulas_cached_only"]}
["Speed","Torque Curve","Efficiency (g/kWh) @ Torque (Nm)"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18]
["rpm","Nm",40,50,60,70,80,90,100,110,120,130,140,150,160,170,180,190]
[1500,185,300,280,260,250,250,240,240,230,230,230,230,230,240,240,250]
[1600,185,300,280,270,260,250,240,240,240,230,230,230,230,240,240,250]
[1700,190,300,280,270,260,250,240,240,240,230,230,230,230,240,240,240]
[1800,190,300,280,270,260,250,240,240,240,230,230,230,230,240,240,240]
[1900,185,300,280,270,260,250,250,240,240,240,240,240,240,240,240,240]
[2000,185,300,280,280,260,250,250,250,240,240,240,240,240,240,240,240]
[2100,180,300,290,280,270,260,250,250,240,240,240,240,240,240,240,250]
[2200,175,300,300,280,270,260,250,250,250,240,240,240,240,240,240]
[2300,170,300,300,290,280,270,260,250,250,250,250,250,250,250,250]
[2400,170,300,300,290,280,270,260,260,250,250,250,250,250,250]
[2500,165,300,300,290,280,280,270,260,260,250,250,250,250,250]
[2600,160,300,300,300,280,280,270,260,260,250,250,250,250,250]
[2700,155,300,300,300,290,290,270,260,260,260,260,260,260]
[2800,155,300,300,300,300,290,280,270,260,260,260,260,260]
[2900,150,300,300,300,300,290,280,270,270,270,270,270,270]
[3000,145,300,300,300,300,290,280,280,270,270,270,270]
[3001,145]
{"$rows_empty":7}
["Alternative Fuel Map for 1.9L VW/Cummins tdi Engine"]

{"sheet":"Solar Panels","index":12,"n_rows":8,"n_cols":10,"rows_kept":8,"flags":["formulas_cached_only"]}
["Values Used in Model",{"$nulls":6},"Kyocera KD140GX-LFBS"]
["Max Output",140,"W",{"$nulls":4},"Max Output",140,"W"]
["L",59.06,"in",{"$nulls":4},"L",59.06,"in"]
["W",26.3,"in",{"$nulls":4},"W",26.3,"in"]
["Area",10.786652777777778,"ft^3",{"$nulls":4},"Area",10.786652777777778,"ft^3"]
["Cost",279,"$",{"$nulls":4},"Cost",279,"$"]
["Inverter Cost",150,"$",{"$nulls":4},"Inverter Cost",150,"$"]
["Total Cost/Panel",429,"$",{"$nulls":4},"Total Cost/Panel",429,"$"]

{"sheet":"Batteries","index":13,"n_rows":9,"n_cols":27,"rows_kept":9,"flags":["formulas_cached_only"]}
["Battery used in Calculations",{"$nulls":6},"Trojan T105 (Lead acid)",{"$nulls":6},"Lifeline 8D (AGM)",{"$nulls":4},"Smart Battery SB300 (Li)",{"$nulls":3},"Torqueed0 26-104"]
["Capacity",1.5,"kWh",{"$nulls":4},"Capacity",1.5,"kWh",{"$nulls":4},"Capacity",3.1365,"kWh",null,null,"Capacity",3.84,"kWh",null,"Capacity",2.685,"kWh"]
["L",10.3,"in",{"$nulls":4},"L",10.3,"in",{"$nulls":4},"L",20.76,"in",null,null,"L",20.47,"in",null,"L",22.7,"in"]
["W",7.11,"in",{"$nulls":4},"W",7.11,"in",{"$nulls":4},"W",10.89,"in",null,null,"W",10.5,"in",null,"W",10,"in"]
["H",11.07,"in",{"$nulls":4},"H",11.07,"in",{"$nulls":4},"H",8.64,"in",null,null,"H",9,"in",null,"H",8.6,"in"]
["Volume",0.46914890625000005,"ft^3",{"$nulls":4},"Volume",0.46914890625000005,"ft^3",{"$nulls":4},"Volume",1.1303820000000002,"ft^3",null,null,"Volume",1.119453125,"ft^3",null,"Volume",1.1297453703703704,"ft^3"]
["Weight",62,"lbs",{"$nulls":4},"Weight",62,"lbs",{"$nulls":4},"Weight",156,"lbs",null,null,"Weight",92,"lbs",null,"Weight",53.57,"lbs"]
["Cost",149,"$",{"$nulls":4},"Cost",149,"$",{"$nulls":4},"Cost",814.9,"$","*Go2Marine",null,"Cost",3499.99,"$","*manufacturer's website","Cost",2577.6,"$","*manufacturer's website"]
["# Cycles",1200,{"$nulls":5},"# Cycles",1200,{"$nulls":5},"# Cycles",{"$nulls":4},"# Cycles",{"$nulls":3},"# Cycles"]

{"sheet":"Motor Efficiency","index":14,"n_rows":46,"n_cols":18,"rows_kept":46,"flags":["formulas_cached_only"]}
["Numbers Used in Model",{"$nulls":4},"LMC LEM-200 (motor used for Beta hybrids)",{"$nulls":5},"Elco EP 4000",{"$nulls":3},"Baldor CEM2535T (3Phase AC, NEMA premium efficiency)"]
["Torque","Current","Efficiency",null,null,"Torque","Current","Efficiency",{"$nulls":3},"L",29,"in",null,"L",19.439999999999998,"in"]
["Nm","A","%",null,null,"Nm","A","%",{"$nulls":3},"W",18.82,"in",null,"W",13.25,"in"]
[0,0,{"v":0.2,"d":"20.00%"},null,null,0,0,{"v":0.2,"d":"20.00%"},{"$nulls":3},"H",18.83,"in",null,"H",13.25,"in"]
[4.598,10,{"v":0.75,"d":"75.00%"},null,null,4.598,10,{"v":0.75,"d":"75.00%"},{"$nulls":3},"Volume",5.947359606481481,"ft^3",null,"Volume",1.975078125,"ft^3"]
[9.196,20,{"v":0.86,"d":"86.00%"},null,null,9.196,20,{"v":0.86,"d":"86.00%"},{"$nulls":3},"Weight",400,"lbs",null,"Weight",375,"lbs"]
[13.794,30,{"v":0.87,"d":"87.00%"},null,null,13.794,30,{"v":0.87,"d":"87.00%"},{"$nulls":3},"Cost",{"$nulls":3},"Cost",4037]
[18.392,40,{"v":0.85,"d":"85.00%"},null,null,18.392,40,{"v":0.85,"d":"85.00%"},{"$nulls":3},"Efficiency","\"85-92%\"",null,null,"Efficiency","88-93%"]
[22.99,50,{"v":0.8,"d":"80.00%"},null,null,22.99,50,{"v":0.8,"d":"80.00%"},{"$nulls":3},"Power Output",16,"kW",null,"Power Output",22.38,"kW"]
[27.588,60,{"v":0.82,"d":"82.00%"},null,null,27.588,60,{"v":0.82,"d":"82.00%"}]
[32.186,70,{"v":0.81,"d":"81.00%"},null,null,32.186,70,{"v":0.81,"d":"81.00%"}]
[36.784,80,{"v":0.8,"d":"80.00%"},null,null,36.784,80,{"v":0.8,"d":"80.00%"}]
[41.382,90,{"v":0.78,"d":"78.00%"},null,null,41.382,90,{"v":0.78,"d":"78.00%"}]
[45.98,100,{"v":0.77,"d":"77.00%"},null,null,45.98,100,{"v":0.77,"d":"77.00%"}]
[]
["Speed","Output Power","Torque",null,null,"Speed","Output Power","Torque"]
["rpm","kW","Nm",null,null,"rpm","kW","Nm"]
[2180,10,45.98,null,null,2180,10,45.98]
[2283.5,9,41.38199999999999,null,null,2283.5,9,41.38199999999999]
[2387,8,36.784,null,null,2387,8,36.784]
[2490.5,7,32.186,null,null,2490.5,7,32.186]
[2594,6,27.588,null,null,2594,6,27.588]
[2697.5,5,22.99,null,null,2697.5,5,22.99]
[2801,4,18.392,null,null,2801,4,18.392]
[2904.5,3,13.794,null,null,2904.5,3,13.794]
[3008,2,9.196,null,null,3008,2,9.196]
[3111.5,1,4.598,null,null,3111.5,1,4.598]
[3215,0,0,null,null,3215,0,0]
[]
[null,0,0,{"$nulls":3},0,0]
[null,1,4.598,{"$nulls":3},1,4.598]
[null,2,9.196,{"$nulls":3},2,9.196]
[null,3,13.794,{"$nulls":3},3,13.794]
[null,4,18.392,{"$nulls":3},4,18.392]
[null,5,22.99,{"$nulls":3},5,22.99]
[null,6,27.588,{"$nulls":3},6,27.588]
[null,7,32.186,{"$nulls":3},7,32.186]
[null,8,36.784,{"$nulls":3},8,36.784]
[null,9,41.38199999999999,{"$nulls":3},9,41.38199999999999]
[null,10,45.98,{"$nulls":3},10,45.98]
[]
[]
[]
["Motor Volume",0.3164589662512658,"ft^3",null,null,"Motor Volume",0.3164589662512658,"ft^3"]
["Weight",24.200000000000003,"lbs",null,null,"Weight",24.200000000000003,"lbs"]
["Cost",{"v":1871.79,"d":"$1,871.79"},"$",null,null,"Cost",{"v":1871.79,"d":"$1,871.79"},"$","*From cloud electric"]

{"sheet":"Motor Controller Efficiency","index":15,"n_rows":3,"n_cols":9,"rows_kept":3,"flags":["formulas_cached_only"]}
["Numbers Used In Model",{"$nulls":4},"Zilla 1k Motor Controller"]
["Efficiency",{"v":0.98,"d":"98.00%"},"%",null,null,"Efficiency",{"v":0.98,"d":"98.00%"},"%"]
["Cost",1975,"$",null,null,"Cost",1975,"$","From Manzanita Micro"]