[ad_1]
For $/minute locations, I used a conversion formula to get from $/min to $/kWh based on the Supercharger speed. In practice, this ratio will also vary by vehicle, %SOC, temperature, pairing, etc., but the conversion numbers that I chose line up well with my personal experience charging my Model 3 LR. And Google Sheets geo charts doesn’t have an easy way to present 2 different units on the same map anyway, so I had to convert into a single unit to present it all on a single map.
Here’s a screenshot of the map:
View attachment 722925
And here’s a link to the map where you can hover over each state to see the precise values for a given state:
docs.google.com
As part of this effort, I’ve also compiled individual Supercharger prices for all the locations in 2/3 of states so far, but I’ve skipped the more densely populated states, so I’ve got about 1/3 of all U.S. Superchargers. Google Sheets geo charts can also display color-coded dots at individual charger locations, but it is painfully slow to populate the map once you get over 100 points or so. On this map I have the dot size vary by Supercharger speed.
Here’s a screenshot of what it looks like:
View attachment 722949
And here’s a link to the map where you can hover over each dot to see the price and kW for each Supercharger (but it can be very slow to load all the dots):
docs.google.com
(*If anyone knows how to embed Google Sheets geo charts directly into a post, please let me know.)
[ad_2]