{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["User Guide","Payback Calculator","Back end calculations","City solar intensity"],"not_rendered":{"charts":0,"images":3,"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":"User Guide","index":0,"n_rows":97,"n_cols":3,"rows_kept":97,"cut":false,"hidden":false,"merged":[[1,1,1,5],[3,2,58,4],[59,2,95,4],[96,2,134,4]]}
[]
[null,"Solar for Trucks Payback Calculator User's Guide"]
[]
[null,null,"The Excel file model that is provided with this paper is designed to help fleets evaluate what the value of investing in solar technology on new tractors.  As we have discussed, there are many factors to consider related to solar technology on trucks and evaluating the value of the benefits vs. the costs can be quite difficult.  Factors like area of the country and normal driving cycle can make a big difference in the effectiveness and benefits of solar panels.  In addition, one of the key benefits of solar technology on tractors is improving the life of batteries and avoiding some service calls due to dead batteries.\n\nThe Excel file has a short questionnaire that asks the user to fill in responses.  Once responses are filled in, hit the ‘Calculate Savings’ button and the spreadsheet will return numbers about expected annual savings per truck and calculate a rough estimate of the payback period for the investment.\n\nWe have identified five areas where a solar panel system installed on the tractor can provide financial benefit to the fleet:\n    •  Reduction of engine idling during mandatory rest periods\n    •  Improvement in battery life due to maintaining the batteries at a higher average state of charge\n    •  Reduction in vehicle jump start incidents due to dead batteries\n    •  Fuel savings due to solar power production reducing alternator load during normal vehicle operation\n    •  Savings in driver retention and hiring expenses due to the technology being installed on the vehicles\n\nExplanation of the Questions:\nWhen you first load the Excel file, a button may appear at the top of the screen asking if you want to enable editing.  Press this button to allow the spreadsheet to accept inputs. Many of the questions are self-explanatory. Those that are not straight-forward are explained in detail below.\n\nPlease select the type of solar system you want to assess from the drop down list\n    •  This model is set up to take responses related to two different scenarios.  One is ‘Sleeper Cab with battery HVAC’.  The second is ‘Sleeper Cab without a battery HVAC or a Day Cab’.  Pick the most appropriate one for your application and a list of additional questions to be answered will appear.  \n\nQuoted hardware + installation cost per truck\n     •  In order to evaluate an investment in solar panels, you need to understand the front end cost of both the hardware and the installation.  Of course, this will vary based upon the size of the panel or panels selected as well as the projected installation cost per unit.\n\nSelect the city most near the truck's area of operation from the drop down list\n     •  The area of the country that the vehicle runs has a significant effect on the energy that a solar panel can produce.  For this item, we selected 50 or so large metropolitan areas around the US and Canada to make this a straightforward choice.  We used the output from a solar panel tool called PVWatts maintained by the National Renewable Energy Lab that calculates the expected energy output of solar panels based on average solar illumination data that has been accumulated over several years in each of these areas. \n     •  Note:  We have assumed the solar panel would be mounted on the truck fairing and that its angle is 20 degrees inclined.  Some fairings vary from this angle, so the solar panel output would vary slightly accordingly.  We have further assumed that the orientation of the panel to the sun is an average of 90 degrees off from ideal.  This accounts for the fact that the orientation of the truck relative to the sun, which cannot be controlled, will vary the full 360 degrees and average out over time.\n\n# of 10-hour rest periods/week in sleeper\n     •  Enter the number of 10-hour rest periods per week that the driver will spend in the sleeper vs. somewhere else.  One primary benefit of installing a solar panel on a sleeper with a battery HVAC is to help minimize engine idling during the required 10-hour rest periods.  Since there are several of these per week vs. one 34-hour reset period where the driver may or may not be in the truck sleeper berth, we used this as a means of estimating one of the benefits of the solar panel. \n\nHow long do your HVAC batteries typically last before you have to start the engine?\n     •  One benefit of solar panels is to assist the truck and battery HVAC batteries during 10-hour rest periods.  To estimate this benefit, we need to understand a few things about the vehicle operation.  First, since the primary function of the battery HVAC unit is to provide air conditioning to the sleeper berth during hotter weather without idling the engine, we need to estimate how often that function is needed.  The batteries are generally able to provide hotel load support for a very long time if A/C is not required.\n     •  To estimate the effect of the solar panel, you need to assume which part of rest periods actually occur during the daylight hours.  The added power produced by the solar panel will have the effect of extending the time before the engine needs to start to recharge the batteries.  Solar panel production at night is minimal and will not help extend the number of hours that the battery HVAC system will provide comfort to the driver.\n     •  If the battery system has enough power to supply the needs of the driver for the full 10-hour rest period, then a solar panel will not help avoid engine idling during that rest period.  The questions are trying to ascertain how often and to what degree the battery HVAC has insufficient power to complete a rest period.  When this is the case, the power generated from the solar panel will help eliminate engine idling.\n     •  As noted in the report, idling the engine to charge batteries and run hotel loads consumes approximately 1 gallon/hour of diesel fuel.\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Total number of Group 31 batteries on truck\n     •  This would normally be either 4 or 8 depending on your application.  The total energy available in the batteries on the vehicle is part of calculating the additional contribution that a solar panel will make in avoiding idle time.\n\nTotal watts produced by panels\n     •  This item is the total number of rated watts of the solar panels proposed for the installation.  This can vary based upon the fairing area and the number of panels proposed.  If there are two or more panels proposed, just added the watt ratings up for each individual panel and enter the total.\n\nExpected idle time avoided due to solar - %\n     •  These items are unique to the Sleeper Cab without Battery HVAC or a Day Cab case.  Calculating savings from the installation of a solar panel is slightly different when a Battery HVAC unit is not present.  It is possible that the power from the solar panel could allow some small amount of reduction in the idle times, particularly where hotel loads over a rest period might require idling but the temperature is not high enough to require the engine to be running to provide air conditioning or heating.  For example, if loads due to refrigerators, CPAP machines, etc. are high enough that the engine needs to be started before battery voltage becomes so low that the engine will not start, the solar panel can offset some of those loads and therefore avoid idling.  Enter the average fleet idle times and the percent reduction expected to get an estimate of these kind of savings.\n\nCost plus labor per battery replacement - 4 batteries\n     •  Since one of the benefits of solar panels is to help extend battery life, we need to determine what the current average life of the batteries in the fleet are.  Since it is possible that the starting batteries for the truck have a different average life than the ones for the battery HVAC system, we decided to allow the entry of different numbers.  If the fleet data is insufficient to separate these, then just enter the same number in both lines.\n     •  Some fleets reported that their average battery life was around 18 to 24 months while others stated that their average life was around 4 years.  Of course, this number depends on a wide variety of factors, including maintenance practices, driver controls, vehicle duty cycle, battery technology selection, etc.  It seems that about 24 months or so was the most common answer to this question.\n     •  Many fleets have a maintenance program where individual batteries are replaced before a certain age, after which they are replaced as a set of 4.  We would recommend using an average life for a set that includes both types of replacement.  Depending on the type of records the fleet maintains, this may be difficult to determine.  Often, fleets have the records that indicate the total battery replacements for a given year by vehicle group.  If this is the case, it is possible to make a pretty good guess of average battery life from these types of records.\n     •  If a fleet has a maintenance strategy of replacing batteries at a fixed mileage regardless of their condition, then the fleet would need to consider whether a change to that maintenance practice makes sense if they invest in solar panels. \n\n% improvement expected in battery replacement rate\n     •  We think it is feasible that battery life could be extended by 50% as a result of installing a solar panel on the tractor.  However, this number could vary significantly depending on a wide variety of factors as stated above.\n     •  Fleets that have implemented solar panels have indicated that they think battery life has been extended compared to before using solar panels, but this data was anecdotal.  Logically, the improvement in battery life should be there, but we have not been able to verify this with data from a large-scale study.\n\n"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Expected % of jump starts to be avoided with solar\n     •  Another benefit of installing solar panels on a tractor is the potential to avoid expensive jump starts because the solar panel can help maintain the batteries at a higher average state of charge.  The above questions are targeted at determining what the cost of these jump starts are and the amount that might be avoided with the implementation of solar panels.\n     •  Many fleets told us that they don’t track jump start incidents closely.  They indicated that if a jump start is needed in one of their internal yards that the incident and cost is often not tracked at all, but rather just included in the overall maintenance expense.  Also, jump starts that require battery replacements are tracked in the battery category vs. emergency repairs.  In the end, this expense is one that can be quite expensive at times and the costs might be avoided with the implementation of solar panels.\n     •  Fleets that have implemented solar panels indicated that jump starts have indeed decreased compared to before implementing solar panels, but this data was also anecdotal.  However, it stands to reason that if battery life is extended as a result of implementing solar panels that the number of jump starts required would also decrease.\n     •  We think that it’s feasible that the number of jump starts required would decrease by 30% to 50%.  However, it would be wise to look at the reasons for the jump starts within the fleet to determine if there are other factors involved besides batteries getting to the end of their life or hotel loads draining the batteries during 34-hour reset periods.  The power from the solar panel would help in these situations, but in others it might not.  An example of conditions where the solar panel might not help would be leakage current due to poor electrical connections or grounds. Another example might be a failed battery due to low fluid or a defect in one or more of the cells.\n\nAverage Fuel Cost per gallon\n     •  To calculate how much fuel might be saved due to the solar panel providing some of the power as the vehicle travels down the road, we need to understand the average miles travelled per year and average fuel economy.  From this, along with other numbers provided above, we can calculate the effect of the contribution of the solar panel current on alternator load.  Generally, this savings is a relatively small number compared to the others, but it is nevertheless a real savings.\n     •  The change in vehicle fuel economy from this effect would be undetectable by normal measurement techniques, so this calculation is based on an engineering estimate of the power available from the solar panel annually.  We have assumed that the alternator efficiency is about 45% in this calculation – that is, it would take a little over twice as much power going into the alternator from the engine to generate the power that the solar panel would provide.\n\nAnnual savings in retention/hiring\n     •  Since most fleets we talked to implemented solar panels primarily based on an assumption of improving driver retention and thus avoiding hiring and training expenditures, we have included this line item to put a value on this assumption.\n     •  We think it is reasonable given the very high cost of hiring and training drivers that a benefit of $100 per truck per year is a valid assumption if solar panels are installed on the vehicle.  However, we recognize that each fleet will value this benefit differently, so the user should enter a number that seems reasonable for their particular operation.\n\nResults: Payback period (in years)\n     •  From the inputs, we calculate the annual potential benefits in each of the five categories mentioned above.  The total cost savings is the sum of these five factors and the payback is a simple calculation of including the initial purchase cost vs. the benefits.  We did not attempt to calculate the payback period using standard time value of money parameters since the numbers are simply directional and not meant to be an exact financial calculation.\n"]

{"sheet":"Payback Calculator","index":1,"n_rows":41,"n_cols":6,"rows_kept":41,"cut":false,"hidden":false,"merged":[[1,1,1,5],[3,1,3,5],[40,2,40,3],[31,2,31,3]]}
[]
[null,"Solar for Trucks Payback Calculator"]
[]
[null,"Instructions: Please fill out the form below in order to estimate the financial savings and associated payback period for a solar system investment for your truck. Once you have completed filling out the form, click the calculate button below to view your results. Each time you make a change to one of the values you will need to click the calculate button again to see the updated results."]
[]
[null,"Question #","Questions","User Responses","Suggested Ranges","Notes"]
[null,1,"Please select the type of solar system you want to assess from the drop down list","START HERE"]
[null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",B7+1)","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B8,'Back end calculations'!$B$2:$S$34,2,FALSE),VLOOKUP(B8,'Back end calculations'!$B$2:$S$34,9,FALSE)))","v":""},null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B8,'Back end calculations'!$B$2:$S$34,4,FALSE),VLOOKUP(B8,'Back end calculations'!$B$2:$S$34,11,FALSE)))","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B8,'Back end calculations'!$B$2:$S$34,5,FALSE),VLOOKUP(B8,'Back end calculations'!$B$2:$S$34,12,FALSE)))","v":""}]
[null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",B8+1)","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B9,'Back end calculations'!$B$2:$S$34,2,FALSE),VLOOKUP(B9,'Back end calculations'!$B$2:$S$34,9,FALSE)))","v":""},null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B9,'Back end calculations'!$B$2:$S$34,4,FALSE),VLOOKUP(B9,'Back end calculations'!$B$2:$S$34,11,FALSE)))","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B9,'Back end calculations'!$B$2:$S$34,5,FALSE),VLOOKUP(B9,'Back end calculations'!$B$2:$S$34,12,FALSE)))","v":""}]
[null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",B9+1)","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B10,'Back end calculations'!$B$2:$S$34,2,FALSE),VLOOKUP(B10,'Back end calculations'!$B$2:$S$34,9,FALSE)))","v":""},null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B10,'Back end calculations'!$B$2:$S$34,4,FALSE),VLOOKUP(B10,'Back end calculations'!$B$2:$S$34,11,FALSE)))","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B10,'Back end calculations'!$B$2:$S$34,5,FALSE),VLOOKUP(B10,'Back end calculations'!$B$2:$S$34,12,FALSE)))","v":""}]
[null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",B10+1)","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B11,'Back end calculations'!$B$2:$S$34,2,FALSE),VLOOKUP(B11,'Back end calculations'!$B$2:$S$34,9,FALSE)))","v":""},null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B11,'Back end calculations'!$B$2:$S$34,4,FALSE),VLOOKUP(B11,'Back end calculations'!$B$2:$S$34,11,FALSE)))","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B11,'Back end calculations'!$B$2:$S$34,5,FALSE),VLOOKUP(B11,'Back end calculations'!$B$2:$S$34,12,FALSE)))","v":""}]
[null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",B11+1)","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B12,'Back end calculations'!$B$2:$S$34,2,FALSE),VLOOKUP(B12,'Back end calculations'!$B$2:$S$34,9,FALSE)))","v":""},null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B12,'Back end calculations'!$B$2:$S$34,4,FALSE),VLOOKUP(B12,'Back end calculations'!$B$2:$S$34,11,FALSE)))","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B12,'Back end calculations'!$B$2:$S$34,5,FALSE),VLOOKUP(B12,'Back end calculations'!$B$2:$S$34,12,FALSE)))","v":""}]
[null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",B12+1)","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B13,'Back end calculations'!$B$2:$S$34,2,FALSE),VLOOKUP(B13,'Back end calculations'!$B$2:$S$34,9,FALSE)))","v":""},null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B13,'Back end calculations'!$B$2:$S$34,4,FALSE),VLOOKUP(B13,'Back end calculations'!$B$2:$S$34,11,FALSE)))","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B13,'Back end calculations'!$B$2:$S$34,5,FALSE),VLOOKUP(B13,'Back end calculations'!$B$2:$S$34,12,FALSE)))","v":""}]
[null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",B13+1)","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B14,'Back end calculations'!$B$2:$S$34,2,FALSE),VLOOKUP(B14,'Back end calculations'!$B$2:$S$34,9,FALSE)))","v":""},null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B14,'Back end calculations'!$B$2:$S$34,4,FALSE),VLOOKUP(B14,'Back end calculations'!$B$2:$S$34,11,FALSE)))","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B14,'Back end calculations'!$B$2:$S$34,5,FALSE),VLOOKUP(B14,'Back end calculations'!$B$2:$S$34,12,FALSE)))","v":""}]
[null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",B14+1)","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B15,'Back end calculations'!$B$2:$S$34,2,FALSE),VLOOKUP(B15,'Back end calculations'!$B$2:$S$34,9,FALSE)))","v":""},null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B15,'Back end calculations'!$B$2:$S$34,4,FALSE),VLOOKUP(B15,'Back end calculations'!$B$2:$S$34,11,FALSE)))","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B15,'Back end calculations'!$B$2:$S$34,5,FALSE),VLOOKUP(B15,'Back end calculations'!$B$2:$S$34,12,FALSE)))","v":""}]
[null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",B15+1)","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B16,'Back end calculations'!$B$2:$S$34,2,FALSE),VLOOKUP(B16,'Back end calculations'!$B$2:$S$34,9,FALSE)))","v":""},null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B16,'Back end calculations'!$B$2:$S$34,4,FALSE),VLOOKUP(B16,'Back end calculations'!$B$2:$S$34,11,FALSE)))","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B16,'Back end calculations'!$B$2:$S$34,5,FALSE),VLOOKUP(B16,'Back end calculations'!$B$2:$S$34,12,FALSE)))","v":""}]
[null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",B16+1)","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B17,'Back end calculations'!$B$2:$S$34,2,FALSE),VLOOKUP(B17,'Back end calculations'!$B$2:$S$34,9,FALSE)))","v":""},null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B17,'Back end calculations'!$B$2:$S$34,4,FALSE),VLOOKUP(B17,'Back end calculations'!$B$2:$S$34,11,FALSE)))","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B17,'Back end calculations'!$B$2:$S$34,5,FALSE),VLOOKUP(B17,'Back end calculations'!$B$2:$S$34,12,FALSE)))","v":""}]
[null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",B17+1)","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B18,'Back end calculations'!$B$2:$S$34,2,FALSE),VLOOKUP(B18,'Back end calculations'!$B$2:$S$34,9,FALSE)))","v":""},null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B18,'Back end calculations'!$B$2:$S$34,4,FALSE),VLOOKUP(B18,'Back end calculations'!$B$2:$S$34,11,FALSE)))","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B18,'Back end calculations'!$B$2:$S$34,5,FALSE),VLOOKUP(B18,'Back end calculations'!$B$2:$S$34,12,FALSE)))","v":""}]
[null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",B18+1)","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B19,'Back end calculations'!$B$2:$S$34,2,FALSE),VLOOKUP(B19,'Back end calculations'!$B$2:$S$34,9,FALSE)))","v":""},null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B19,'Back end calculations'!$B$2:$S$34,4,FALSE),VLOOKUP(B19,'Back end calculations'!$B$2:$S$34,11,FALSE)))","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B19,'Back end calculations'!$B$2:$S$34,5,FALSE),VLOOKUP(B19,'Back end calculations'!$B$2:$S$34,12,FALSE)))","v":""}]
[null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",B19+1)","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B20,'Back end calculations'!$B$2:$S$34,2,FALSE),VLOOKUP(B20,'Back end calculations'!$B$2:$S$34,9,FALSE)))","v":""},null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B20,'Back end calculations'!$B$2:$S$34,4,FALSE),VLOOKUP(B20,'Back end calculations'!$B$2:$S$34,11,FALSE)))","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B20,'Back end calculations'!$B$2:$S$34,5,FALSE),VLOOKUP(B20,'Back end calculations'!$B$2:$S$34,12,FALSE)))","v":""}]
[null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",B20+1)","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B21,'Back end calculations'!$B$2:$S$34,2,FALSE),VLOOKUP(B21,'Back end calculations'!$B$2:$S$34,9,FALSE)))","v":""},null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B21,'Back end calculations'!$B$2:$S$34,4,FALSE),VLOOKUP(B21,'Back end calculations'!$B$2:$S$34,11,FALSE)))","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B21,'Back end calculations'!$B$2:$S$34,5,FALSE),VLOOKUP(B21,'Back end calculations'!$B$2:$S$34,12,FALSE)))","v":""}]
[null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",B21+1)","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B22,'Back end calculations'!$B$2:$S$34,2,FALSE),VLOOKUP(B22,'Back end calculations'!$B$2:$S$34,9,FALSE)))","v":""},null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B22,'Back end calculations'!$B$2:$S$34,4,FALSE),VLOOKUP(B22,'Back end calculations'!$B$2:$S$34,11,FALSE)))","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B22,'Back end calculations'!$B$2:$S$34,5,FALSE),VLOOKUP(B22,'Back end calculations'!$B$2:$S$34,12,FALSE)))","v":""}]
[null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",B22+1)","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B23,'Back end calculations'!$B$2:$S$34,2,FALSE),VLOOKUP(B23,'Back end calculations'!$B$2:$S$34,9,FALSE)))","v":""},null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B23,'Back end calculations'!$B$2:$S$34,4,FALSE),VLOOKUP(B23,'Back end calculations'!$B$2:$S$34,11,FALSE)))","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B23,'Back end calculations'!$B$2:$S$34,5,FALSE),VLOOKUP(B23,'Back end calculations'!$B$2:$S$34,12,FALSE)))","v":""}]
[null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",B23+1)","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B24,'Back end calculations'!$B$2:$S$34,2,FALSE),VLOOKUP(B24,'Back end calculations'!$B$2:$S$34,9,FALSE)))","v":""},null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B24,'Back end calculations'!$B$2:$S$34,4,FALSE),VLOOKUP(B24,'Back end calculations'!$B$2:$S$34,11,FALSE)))","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B24,'Back end calculations'!$B$2:$S$34,5,FALSE),VLOOKUP(B24,'Back end calculations'!$B$2:$S$34,12,FALSE)))","v":""}]
[null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",B24+1)","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B25,'Back end calculations'!$B$2:$S$34,2,FALSE),VLOOKUP(B25,'Back end calculations'!$B$2:$S$34,9,FALSE)))","v":""},null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B25,'Back end calculations'!$B$2:$S$34,4,FALSE),VLOOKUP(B25,'Back end calculations'!$B$2:$S$34,11,FALSE)))","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B25,'Back end calculations'!$B$2:$S$34,5,FALSE),VLOOKUP(B25,'Back end calculations'!$B$2:$S$34,12,FALSE)))","v":""}]
[null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",B25+1)","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B26,'Back end calculations'!$B$2:$S$34,2,FALSE),VLOOKUP(B26,'Back end calculations'!$B$2:$S$34,9,FALSE)))","v":""},null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B26,'Back end calculations'!$B$2:$S$34,4,FALSE),VLOOKUP(B26,'Back end calculations'!$B$2:$S$34,11,FALSE)))","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B26,'Back end calculations'!$B$2:$S$34,5,FALSE),VLOOKUP(B26,'Back end calculations'!$B$2:$S$34,12,FALSE)))","v":""}]
[null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",B26+1)","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B27,'Back end calculations'!$B$2:$S$34,2,FALSE),VLOOKUP(B27,'Back end calculations'!$B$2:$S$34,9,FALSE)))","v":""},null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B27,'Back end calculations'!$B$2:$S$34,4,FALSE),VLOOKUP(B27,'Back end calculations'!$B$2:$S$34,11,FALSE)))","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B27,'Back end calculations'!$B$2:$S$34,5,FALSE),VLOOKUP(B27,'Back end calculations'!$B$2:$S$34,12,FALSE)))","v":""}]
[null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",B27+1)","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B28,'Back end calculations'!$B$2:$S$34,2,FALSE),VLOOKUP(B28,'Back end calculations'!$B$2:$S$34,9,FALSE)))","v":""},null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B28,'Back end calculations'!$B$2:$S$34,4,FALSE),VLOOKUP(B28,'Back end calculations'!$B$2:$S$34,11,FALSE)))","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,VLOOKUP(B28,'Back end calculations'!$B$2:$S$34,5,FALSE),VLOOKUP(B28,'Back end calculations'!$B$2:$S$34,12,FALSE)))","v":""}]
[null,{"$f":"IF($D$7='Back end calculations'!$Q$4,'Payback Calculator'!B28+1,\"\")","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$4,'Back end calculations'!C24,\"\")","v":""},null,{"$f":"IF($D$7='Back end calculations'!$Q$4,'Back end calculations'!E24,\"\")","v":""},{"$f":"IF($D$7='Back end calculations'!$Q$4,'Back end calculations'!F24,\"\")","v":""}]
[]
[]
[null,null,"Results: Cost savings and payback period (per truck)"]
[null,null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,'Back end calculations'!C28,'Back end calculations'!J28))","v":""}]
[null,null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,'Back end calculations'!C29,'Back end calculations'!J29))","v":""}]
[null,null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,'Back end calculations'!C30,'Back end calculations'!J30))","v":""}]
[null,null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,'Back end calculations'!C31,'Back end calculations'!J31))","v":""}]
[null,null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,'Back end calculations'!C32,'Back end calculations'!J32))","v":""}]
[null,null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,'Back end calculations'!C33,'Back end calculations'!J33))","v":""}]
[null,null,{"$f":"IF($D$7='Back end calculations'!$Q$3,\"\",IF('Payback Calculator'!$D$7='Back end calculations'!$Q$4,'Back end calculations'!C35,'Back end calculations'!J35))","v":""}]
[]
[null,null,"©2018 North American Council for Freight Efficiency.  All rights reserved.  \nThe contents of this document are provided for informational purposes only and do not constitute an endorsement of any product, service, service provider, manufacturer, or manufacturing process.  Nothing contained herein is intended to constitute legal, tax, or accounting advice, and NACFE assumes no liability for use of the report contents.  No portion of this tool or accompanying materials may be copied, reproduced or distributed in any manner without express attribution to the North American Council for Freight Efficiency."]

{"sheet":"Back end calculations","index":2,"n_rows":35,"n_cols":18,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,"Case Study 1 Inputs - Sleeper Cab with a battery HVAC","Value","Suggested Ranges","Notes","Intermediate Calcs & Constants",null,null,"Case Study 2 Inputs - Sleeper Cab without a battery HVAC or a Day Cab","Value","Suggested Ranges","Notes","Intermediate Calcs & Constants",null,null,"Drop Downs"]
[null,2,"Quoted hardware + installation cost per truck",{"$f":"'Payback Calculator'!D8","v":0},"$0 to $5,000"," ",null,null,2,"Quoted hardware + installation cost per truck",1200,"$0 to $5,000"," ",null,null,null,"START HERE"]
[null,3,"Select the city most near the truck's area of operation from the drop down list",{"$f":"'Payback Calculator'!D9","v":0},"n/a","If your operations span a large geography (e.g. full lower 48), please select a city that represents the average (e.g. Kansas City, MO)",{"$f":"VLOOKUP(D4,'City solar intensity'!$B$3:$D$60,3,FALSE)","v":{"$error":"#N/A"}},"kWh/day for 100W Panel",3,"Select the city most near the truck's area of operation from the drop down list",{"$f":"'Payback Calculator'!D9","v":0},"n/a","If your operations span a large geography (e.g. full lower 48), please select a city that represents the average (e.g. Kansas City, MO)",{"$f":"VLOOKUP(K4,'City solar intensity'!$B$3:$D$60,3,FALSE)","v":{"$error":"#N/A"}},"kWh/day for 100W Panel",null,"Sleeper Cab with a battery HVAC"]
[null,4,"# of 10 hour rest periods/week in sleeper",{"$f":"'Payback Calculator'!D10","v":0},"0 – 6"," ",null,null,4,"# of 10 hour rest periods/week in sleeper",{"$f":"'Payback Calculator'!D10","v":0},"0 – 6"," ",null,null,null,"Sleeper Cab without a battery HVAC or a Day Cab"]
[null,5,"% of rest periods in the sleeper that take place during the day",{"$f":"'Payback Calculator'!D11","v":0},"0 – 100%"," ",null,null,5,"% of rest periods in the sleeper that take place during the day",{"$f":"'Payback Calculator'!D11","v":0},"0 – 100%"," "]
[null,6,"Weeks per year battery A/C needed",{"$f":"'Payback Calculator'!D12","v":0},"0 – 52 weeks/year"," ",null,null,6,"Total number of Group 31 batteries on truck",{"$f":"'Payback Calculator'!D12","v":0},"0 – 6 batteries"," ",{"$f":"K7*1000","v":0},"Watt hours available from batteries"]
[null,7,"% rest periods where HVAC batteries are insufficient",{"$f":"'Payback Calculator'!D13","v":0},"0 – 100%","Insufficient = batteries don't last full rest period and either truck needs to be idled or HVAC needs to be turned off",null,null,7,"Average hours of sun during rest period during day",{"$f":"'Payback Calculator'!D13","v":0},"0 – 10 hours"," "]
[null,8,"Total number of Group 31 batteries on truck",{"$f":"'Payback Calculator'!D14","v":0},"3 – 10 batteries"," ",{"$f":"D9*1000","v":0},"Watt hours available from batteries",8,"Total watts produced by panels",{"$f":"'Payback Calculator'!D14","v":0},"20 – 600 watts"," ",{"$f":"(K9/100)*K8*((N4*1000)/12)","v":{"$error":"#N/A"}},"Watt hours available from solar during rest period"]
[null,9,"Average hours of sun during rest period during day",{"$f":"'Payback Calculator'!D15","v":0},"0 – 10 hours"," ",{"$f":"(D12/100)*((G4*1000)/12)*D11","v":{"$error":"#N/A"}},"Watt hours available from solar during rest period",9,"Average Hotel Load during 10 hour rest period in amps",{"$f":"'Payback Calculator'!D15","v":0},"0 – 50 amps"," ",{"$f":"N9/(K10*10*13.5)*100","v":{"$error":"#N/A"}},"Rest period solar supply capability - %"]
[null,10,"How long do your HVAC batteries typically last before you have to start the engine?",{"$f":"'Payback Calculator'!D16","v":0},"4 – 10 hours"," ",{"$f":"G10/(G9/D10)","v":{"$error":"#N/A"}},"Additional hours of APU operation from solar",10,"Average fleet idle time %",{"$f":"'Payback Calculator'!D16","v":0},"0 – 50%"," "]
[null,11,"Total watts produced by panels",{"$f":"'Payback Calculator'!D17","v":0},"20 – 600 watts"," ",null,null,11,"Expected idle time avoided due to solar - %",{"$f":"'Payback Calculator'!D17","v":0},"0 – 25%","It is possible that some idle time would be avoided, but 0% is the most likely scenario"]
[null,12,"Average Battery life in months - truck",{"$f":"'Payback Calculator'!D18","v":0},"0 – 60 months"," ",null,null,12,"Average Battery life in months - truck",{"$f":"'Payback Calculator'!D18","v":0},"0 – 60 months"," "]
[null,13,"Average battery life in months - HVAC",{"$f":"'Payback Calculator'!D19","v":0},"0 – 60 months"," ",null,null,13,"Cost plus labor per battery replacement - 4 batteries",{"$f":"'Payback Calculator'!D19","v":0},"n/a"," ",{"$f":"K14*(12/K13)","v":{"$error":"#DIV/0!"}},"Total cost of battery replacements/year/truck"]
[null,14,"Cost plus labor per battery replacement - 4 batteries",{"$f":"'Payback Calculator'!D20","v":0},"n/a"," ",{"$f":"D15*(12/D13)+D15*(12/D14)","v":{"$error":"#DIV/0!"}},"Total cost of battery replacements/year/truck",14,"% improvement expected in battery replacement rate",{"$f":"'Payback Calculator'!D20","v":0},"0 – 100%","It is unlikely that the solar panel will do more than double the battery life"]
[null,15,"% improvement expected in battery replacement rate",{"$f":"'Payback Calculator'!D21","v":0},"0 – 100%","It is unlikely that the solar panel will do more than double the battery life",null,null,15,"Average fleet miles per gallon",{"$f":"'Payback Calculator'!D21","v":0},"Range 4 – 10 mpg"," "]
[null,16,"Average fleet miles per gallon",{"$f":"'Payback Calculator'!D22","v":0},"Range 4 – 10 mpg"," ",null,null,16,"Average truck mileage per year",{"$f":"'Payback Calculator'!D22","v":0},"40,000 – 250,000 miles"," ",0.45,"Alternator Efficiency - %"]
[null,17,"Average truck mileage per year",{"$f":"'Payback Calculator'!D23","v":0},"40,000 – 250,000 miles"," ",0.45,"Alternator Efficiency - %",17,"Jump starts/year for entire fleet",{"$f":"'Payback Calculator'!D23","v":0},"n/a"," "]
[null,18,"Jump starts/year for entire fleet",{"$f":"'Payback Calculator'!D24","v":0},"n/a"," ",null,null,18,"Average Cost per jump start (internal/external)",{"$f":"'Payback Calculator'!D24","v":0},"n/a"," "]
[null,19,"Average Cost per jump start (internal/external)",{"$f":"'Payback Calculator'!D25","v":0},"n/a"," ",null,null,19,"Fleet size (# trucks)",{"$f":"'Payback Calculator'!D25","v":0},"n/a"," ",{"$f":"K18/K20","v":{"$error":"#DIV/0!"}},"Jump starts/year/truck ",null,null,"`"]
[null,20,"Fleet size (# trucks)",{"$f":"'Payback Calculator'!D26","v":0},"n/a"," ",{"$f":"D19/D21","v":{"$error":"#DIV/0!"}},"Jump starts/year/truck ",20,"Expected % of jump starts to be avoided with solar",{"$f":"'Payback Calculator'!D26","v":0},"0 – 75%"," "]
[null,21,"Expected % of jump starts to be avoided with solar",{"$f":"'Payback Calculator'!D27","v":0},"0 – 75%"," ",null,null,21,"Average Fuel Cost per gallon",{"$f":"'Payback Calculator'!D27","v":0},"n/a"," "]
[null,22,"Average Fuel Cost per gallon",{"$f":"'Payback Calculator'!D28","v":0},"n/a"," ",null,null,22,"Savings per truck per year in retention/hiring",{"$f":"'Payback Calculator'!D28","v":0},"$0 – $300","We estimate the typical savings in retention/hiring for the non-HVAC use case to be $0/year"]
[null,23,"Savings per truck per year in retention/hiring",{"$f":"'Payback Calculator'!D29","v":0},"$0 – $300","We estimate the typical savings in retention/hiring for the HVAC use case to be ~$100/year"]
[]
[]
[null,null,"Case Study 1 Outputs",null,null,null,null,null,null,"Case Study 2 Outputs"]
[null,null,"Annual savings from avoided jump starts",{"$f":"G21*D22*D20/100","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"Annual savings from avoided jump starts",{"$f":"N20*K21*K19/100","v":{"$error":"#DIV/0!"}}]
[null,null,"Annual savings from extended battery life/reduced replacements",{"$f":"D15*(12/D13)-(D15*(12/(D13*(1+D16/100))))+D15*(12/D14)-(D15*(12/(D14*(1+D16/100))))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"Annual savings from extended battery life/reduced replacements",{"$f":"K14*(12/K13)-(K14*(12/(K13*(1+K15/100))))","v":{"$error":"#DIV/0!"}}]
[null,null,"Annual fuel savings via reduced idle time",{"$f":"D5*52*D8*G11*D23/100","v":{"$error":"#N/A"}},null,null,null,null,null,"Annual fuel savings via reduced idle time",{"$f":"(K17/45)*(K11/100)*K12*K22","v":0}]
[null,null,"Annual fuel savings due to solar energy production while moving",{"$f":"((((D12/100)*G4*1000)/(D12*24))*D12)/(164000*G18)*((D18/D17)*D23)","v":{"$error":"#N/A"}},null,null,null,null,null,"Annual fuel savings due to solar energy production while moving",{"$f":"((((K9/100)*N4*1000)/(K9*24))*K9)/(164000*N17)*((K17/K16)*K22)","v":{"$error":"#N/A"}}]
[null,null,"Annual savings in retention/hiring",{"$f":"D24","v":0},null,null,null,null,null,"Annual savings in retention/hiring",{"$f":"K23","v":0}]
[null,null,"Total cost savings per truck per year",{"$f":"SUM(D28:D32)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"Total cost savings per truck per year",{"$f":"SUM(K28:K32)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,"Payback period (in years)",{"$f":"D3/D33","v":{"$error":"#DIV/0!"}},null,null,null,null,null,"Payback period (in years)",{"$f":"K3/K33","v":{"$error":"#DIV/0!"}}]

{"sheet":"City solar intensity","index":3,"n_rows":60,"n_cols":4,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Cities","PVWatts Factor for 100W panel","kWh per day"]
[]
[null,"Albuquerque",151,{"$f":"C5/365","v":0.41369863013698632}]
[null,"Anchorage",86,0.23561643835616439]
[null,"Arlington, Texas",132,0.36164383561643837]
[null,"Atlanta",124,0.33972602739726027]
[null,"Austin",130,0.35616438356164382]
[null,"Baltimore",117,0.32054794520547947]
[null,"Boston",110,0.30136986301369861]
[null,"Calgary",103,0.28219178082191781]
[null,"Charlotte",117,0.32054794520547947]
[null,"Chicago",113,0.30958904109589042]
[null,"Colorado Springs",139,0.38082191780821917]
[null,"Columbus",112,0.30684931506849317]
[null,"Dallas",128,0.35068493150684932]
[null,"Denver",135,0.36986301369863012]
[null,"Detroit",115,0.31506849315068491]
[null,"El Paso",157,0.43013698630136987]
[null,"Fort Worth",131,0.35890410958904112]
[null,"Fresno",140,0.38356164383561642]
[null,"Houston",129,0.35342465753424657]
[null,"Indianapolis",115,0.31506849315068491]
[null,"Jacksonville",130,0.35616438356164382]
[null,"Kansas City, Mo.",118,0.32328767123287672]
[null,"Las Vegas",118,0.32328767123287672]
[null,"Long Beach",136,0.37260273972602742]
[null,"Los Angeles",140,0.38356164383561642]
[null,"Louisville",118,0.32328767123287672]
[null,"Memphis",125,0.34246575342465752]
[null,"Mesa",146,0.4]
[null,"Miami",142,0.38904109589041097]
[null,"Milwaukee",113,0.30958904109589042]
[null,"Minneapolis",112,0.30684931506849317]
[null,"Montreal",106,0.29041095890410956]
[null,"Nashville",117,0.32054794520547947]
[null,"New Orleans",117,0.32054794520547947]
[null,"New York ",112,0.30684931506849317]
[null,"Oakland",129,0.35342465753424657]
[null,"Oklahoma City",131,0.35890410958904112]
[null,"Omaha",119,0.32602739726027397]
[null,"Philadelphia",116,0.31780821917808222]
[null,"Phoenix",147,0.40273972602739727]
[null,"Portland, Ore.",96,0.26301369863013696]
[null,"Raleigh",120,0.32876712328767121]
[null,"Sacramento",134,0.36712328767123287]
[null,"San Antonio",131,0.35890410958904112]
[null,"San Diego",136,0.37260273972602742]
[null,"San Francisco",130,0.35616438356164382]
[null,"San Jose",137,0.37534246575342467]
[null,"Seattle",92,0.25205479452054796]
[null,"Toronto",112,0.30684931506849317]
[null,"Tucson",154,0.42191780821917807]
[null,"Tulsa",124,0.33972602739726027]
[null,"Vancouver, BC",89,0.24383561643835616]
[null,"Virginia Beach",123,0.33698630136986302]
[null,"Washington",118,0.32328767123287672]
[null,"Wichita",126,0.34520547945205482]
[null,"Winnepeg",104,0.28493150684931506]