-
Want to remove ads? Register an account and login to see fewer ads, and become a Supporting Member to remove almost all ads.
Charging Cost tracker spreadsheet
- Thread starter Jack D
- Start date
IvesSM
Member
scriptedpixels
Member
Happy to give this a try! Can’t seem to see the detailed charging history in my Tesla app soo this may help!
scriptedpixels
Member
Could you just share on google drive?
I exclusively charge at home with the mobile connector on a 14-30 circuit (24A) and in the summer it’s been $0.025/km and in the cold weather now $0.036/km similar for both the 3 and Y (although 3 is a bit less). Curious if it’s just a simple spreadsheet that tracks mileage and cost per kWh converted to mileage?
I exclusively charge at home with the mobile connector on a 14-30 circuit (24A) and in the summer it’s been $0.025/km and in the cold weather now $0.036/km similar for both the 3 and Y (although 3 is a bit less). Curious if it’s just a simple spreadsheet that tracks mileage and cost per kWh converted to mileage?
Would like to take a look if someone can post a link to a read-only google drive version.
Seems like the Tesla app keeps track of supercharger charging costs (by reporting an average cost for all KWH) and my home charging (since it knows my electric rate plan) but my other category will get populated with both free destination charging and occasional DCFC with CCS-1 adaptor which usually costs money and it would be nice to keep track and piggy-back off the effort others have placed on this.
I've thought about trying to do this and incorporate current gas prices per gallon to compare to savings from my prior gas and hybrid cars (depending on which trip type usage of the Tesla is replacing, since I'm using it for work commuting purposes instead of the hybrid, and for family day trips instead of a small SUV).
Seems like the Tesla app keeps track of supercharger charging costs (by reporting an average cost for all KWH) and my home charging (since it knows my electric rate plan) but my other category will get populated with both free destination charging and occasional DCFC with CCS-1 adaptor which usually costs money and it would be nice to keep track and piggy-back off the effort others have placed on this.
I've thought about trying to do this and incorporate current gas prices per gallon to compare to savings from my prior gas and hybrid cars (depending on which trip type usage of the Tesla is replacing, since I'm using it for work commuting purposes instead of the hybrid, and for family day trips instead of a small SUV).
| $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 |
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.
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.
JetFalcon
Member
I use spread sheets to track my arcade profits. I been trying to integrate the cost of electricity for arcade trips. Maybe wondering if it’s worth traveling to another arcade for a higher jackpot. Or when I know it’s clearly for fun.
I am hoping I can show my other arcade friends how beneficial lower electricity costs are but they drive 40 mpg cars so it’s sort of hard to know who is truly coming ahead. But I think a Tesla has more performance and can match or exceed a 40mpg car. One says they don’t like stopping during vacation time and rather pay for gas. I still think I’m coming out ahead when I charge at home.
I am hoping I can show my other arcade friends how beneficial lower electricity costs are but they drive 40 mpg cars so it’s sort of hard to know who is truly coming ahead. But I think a Tesla has more performance and can match or exceed a 40mpg car. One says they don’t like stopping during vacation time and rather pay for gas. I still think I’m coming out ahead when I charge at home.
legendsk
Member
Similar threads
