Part 5: Clementine
In the analogy, Clementine was the girl who could document two different birth dates and I said she represented the Model S P100D.
Here is the document for the Model S P100D. I found that 2017 file on
this page under the first column called Datafile1. Here is a screenshot:
This EPA document says "Combined range voluntarily lowered to 315 miles" and when you select city range, you can see the original range in the formula bar. What they are doing here is, they are reducing the city and highway range retroactively at the same rate the combined range was reduced. In other words, the Model S P100D scored 324.3 mi EPA rated range and it was voluntarily lowered to 315 miles. The ratio of this reduction is 315/324.3. The city range originally was 305.9 miles but they want to reduce it by the same rate. That's why they are multiplying it by 315/324.3. The EPA is not trying to hide voluntary reductions. They are just trying to have consistent city, highway and combined range numbers where all of them are voluntarily reduced.
This 2017 file is very valuable because the EPA doesn't normally leave the original range numbers in the formula cells. Normally, this file should show 297.1 mi as static text and that's it. They were supposed to convert formula cells to static text. In Excel you do that by copying the cells and then right click to same cells > paste special > paste values. They forgot to do that in the 2017 file but they have done it in all previous years.
These 3 numbers were published for the Model S P100D:
- 315 mi EPA rated range
- 92 MPGe city fuel economy
- 105 MPGe highway fuel economy
Screenshot source:
EPA
Here are the 4 numbers from the dyno test we will use as input data:
- 111.47 kWh wall consumption in city dyno test (see page 10 here)
- 414.45 mi in city dyno score (see page 10 here)
- 111.88 kWh wall consumption in highway dyno test (see page 11 here)
- 469.99 mi in highway dyno score (see page 11 here)
Step 1: City and highway range: To calculate these, you multiply the dyno scores by 0.738. The Model S and X use different multipliers. There are 3 different multipliers for different Model S trim levels. These are published in another EPA document.
City range = 414.45 mi * 0.738= 305.8641 mi
Highway range = 469.99 mi * 0.738= 346.85262 mi
Step 2: Combined range: This is the EPA rated range. It is calculated from 55% of city range and 45% of highway range.
Combined range = 0.55*305.8641 + 0.45*346.85262= 168.225255 +156.083679 =
324.3089 mi EPA rated range
Step 3: MPGe numbers: MPGe means miles per 33.7 kWh wall consumption.
If city range is 305.8641 miles per 111.47 kWh wall consumption,
then city range is X miles per 33.7 kWh wall consumption
X= 305.8641 mi * 33.7 kWh / 111.47 kWh= 92.47 mi per 33.7 kWh wall consumption =
92 MPGe city fuel economy
If highway range is 346.85262 miles per 111.88 kWh wall consumption,
then highway range is X miles per 33.7 kWh wall consumption
X= 346.85262 mi * 33.7 kWh / 111.88 kWh= 104.477 mi per 33.7 kWh wall consumption rounded to
115 MPGe highway fuel economy
Similar to the Part 4, this calculation also ended up with a different EPA rated range number than advertised however we can see that the method is correct and the calculated number is the original number before the voluntary reduction because, the calculated 324.3089 matches exactly what the document shows.