{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Sheet with calculations","User's Guide"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"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":"Sheet with calculations","index":0,"n_rows":52,"n_cols":9,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[null,null,"Simple Payback Calculator"]
[]
[null,"Current Fleet Status"]
[]
[null,null,"Average miles/year",null,110000,"miles"]
[null,null,"Current annualized % idle time",null,35,"percent"]
[null,null,"Truck group mpg",null,7,"mpg"]
[null,null,"Average speed while driving (mph)",null,45,"mph"]
[null,null,"Fuel consumption at idle/hour (gal)",null,1,"gallons"]
[null,null,"Average cost/gallon fuel",null,3.5]
[]
[null,"Fuel Cost Savings Calculation"]
[]
[null,"Idle Reduction Solution",null,"Already use","Proposed system",null,"For Additional Info, Click Buttons Below"]
[]
[null,null,"ECM Idle Parameters","x","x"]
[null,null,"Driver Incentives","x","x"]
[null,null,"Diesel Fired Bunk Heater","x","x"]
[null,null,"Diesel APU"]
[null,null,"Battery HVAC APU",null,"x"]
[null,null,"Automatic Start/Stop System",null,"x"]
[]
[null,null,null,null,"From","To"]
[null,"Estimated idle % reduction with Proposed System",null,null,{"$f":"E6","v":35},15,"< Enter anticipated proposed idle percent here"]
[null,null,"(Example - from 35% to 15%)"]
[]
[null,null,"Cost/Payback Calculations"]
[]
[null,"Estimated increase/decrease in maintenance expense/truck/year (Diesel APU/Battery HVAC only) ($)",null,null,null,null,null,null,-500]
[null,null,"Considerations:","Oil change, filters belts for Diesel APU"]
[null,null,null,"Decrease in battery maintenance/callouts for Diesel APU"]
[null,null,"Decrease = Negative number!!","Increase in battery maintenance for Battery HVAC"]
[null,null,null,"Decrease in battery maintenance/callouts for Automatic Start/Stop System"]
[null,null,null,"Increase in maintenance for bunk A/C system"]
[]
[null,"One Time Savings/Truck for driver hiring and training with proposed system",null,null,null,null,null,null,2000]
[]
[null,"Proposed system cost with Installation",null,null,null,null,null,null,9000]
[]
[null,"One time benefit or cost per truck (enter benefits as negative number!!)",null,null,null,null,null,null,-300]
[null,null,"Include items here for meeting fleet sustainability goals, noise reduction, driver satisfaction improvement,"]
[null,null,"preparing for future technolgies, fleet image, etc."]
[]
[null,"Calculated annual Savings/Truck"]
[null,null,"Fuel cost/truck/year",null,{"$f":"(E5/E7)*E10","v":55000}]
[null,null,"Idle Fuel Cost",null,{"$f":"(E5/E8)*(E6/100)*E9*E10","v":2994.4444444444439}]
[null,null,"Projected Annual Fuel Savings Per Year",null,{"$f":"E46-((F24*E46)/E24)","v":1711.1111111111109}]
[]
[]
[]
[null,"Approximate years to break even on investment (simple payback)",null,null,null,null,{"$f":"(I38+I40-I36)/(E47-I29)","v":3.0301507537688446},"years"]
[null,null,"Note - does not include opportunity cost considerations"]

{"sheet":"User's Guide","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}