You can install our site as a web app on your iOS device by utilizing the Add to Home Screen feature in Safari. Please see this thread for more details on this.
Note: This feature may not be available in some browsers.
Happy to give this a try! Can’t seem to see the detailed charging history in my Tesla app soo this may help!Notify me if you would like a Charging Cost Tracker spreadsheet - free
$0.00 | $0.36 | 67 | $31.62 | 280 | $53.89 | $22.27 | $2.48 | |||||
Date | Location | Flat Fee | Price/kWh ($) | kWh charged | Total Elec Cost | Avg w/mile | Gas Price/Gallon | Recent trip type | mpg replacement | Equivalent Gas Cost | Avoided gas cost | Avoided elec cost |
11/11/2022 | Supercharger | $0.00 | $0.44 | 15 | $6.60 | 280 | $5.09 | SUV | 20 | $13.63 | $7.03 | $0.00 |
11/12/2022 | Supercharger | $0.00 | $0.63 | 34 | $21.42 | 280 | $5.09 | SUV | 20 | $30.90 | $9.48 | $0.00 |
11/18/2022 | Free EV Mall | $0.00 | $0.00 | 8 | $0.00 | 280 | $5.09 | Hybrid | 35 | $4.16 | $4.16 | $2.48 |
11/30/2022 | Home | $0.00 | $0.36 | 10 | $3.60 | 280 | $5.09 | Hybrid | 35 | $5.19 | $1.59 | $0.00 |
Oops, the average price/kWh in the 1st row, 4th column should have been "=F1/E1" instead of just an average of the 4th column.
$0.00 $0.47 67 $31.62 280 $53.89 $22.27 $2.48 Date Location Flat Fee Price/kWh ($) kWh charged Total Elec Cost Avg w/mile Gas Price/Gallon Recent trip type mpg replacement Equivalent Gas Cost Avoided gas cost Avoided elec cost 11/11/2022 Supercharger $0.00 $0.44 15 $6.60 280 $5.09 SUV 20 $13.63 $7.03 $0.00 11/12/2022 Supercharger $0.00 $0.63 34 $21.42 280 $5.09 SUV 20 $30.90 $9.48 $0.00 11/18/2022 Free EV Mall $0.00 $0.00 8 $0.00 280 $5.09 Hybrid 35 $4.16 $4.16 $2.48 11/30/2022 Home $0.00 $0.36 10 $3.60 280 $5.09 Hybrid 35 $5.19 $1.59 $0.00
Started playing around to see what I can create and this is what I have so far.
The equations are this:
sums or average of the columns as appropriate in the first row.
Total Elec Cost = "=(D3*E3)+C3"
mpg replacement = "=if(I3="Hybrid",35,20)" since my two cars get about 35 and 20 mph
equivalent gas cost = "=if(iserror(E3*1000/G3/J3*H3),0,E3*1000/G3/J3*H3)" (checks to make sure not a divide by zero error from fill-down, and then calculates how much gas it would take to go the equivalent number of miles for the trip/driving style w/mile and kwh charged)
avoided gas cost = "=K3-F3"
avoided elec cost = "=if(F3=0,E3*0.35,0)" (where 0.35 is replaced with your home average cost/kwh in dollars, and this just shows avoided electrical costs for free charging)
You can potentially add in your home charging costs once a month, breaking out KWH charged during off-peak/peak/etc each as their own row.
Put me in on this.Notify me if you would like a Charging Cost Tracker spreadsheet - free