ABCDEFGHIJKLMNOPQRSTUVWXYZAAABAC
1
2
Total Cost of Ownership - (Energy Cost + Purchase + Maintenance + Fees) --->
$26,306.72
3
Total Cost of Ownership Per Mile Driven ------------------------------------------->
$0.402
4
Cost of Energy Per Mile Driven ------------------------------------------------------->
$0.042
5
Cost of Ownership EXCLUDING Energy Per Mile Driven--------------------------->
$0.360
6
7
8
9
10
DateTotal MilesEV MilesKW Used (In Car Meter)Cost of Electric (Actual Kw Used * $0.1585)HV MilesFuel UsedCost of FuelCost per EV MileCost per HV MileTotal Energy CostTotal Energy Cost per mile% of Miles EV% of Miles HVMiles per Actual KwHMiles per GallonKwh per in car meterkwh per wall meterKwh at wall to produce Kwh in car
11
11/22/20174247915$2.4533456.15$15.13$0.031$0.044$17.583$0.04118.63%81.37%5.2756.1015
12
11/26/20174267314$2.2903536.23$16.18$0.031$0.046$18.470$0.04317.14%82.86%5.2156.6614
13
11/29/2017423539$1.4723707.05$17.98$0.028$0.049$19.452$0.04612.53%87.47%5.8952.489Mtr 2.5 to 14.80 KWh = 12.3KWh at home
14
12/10/201753315330$4.9073806.89$15.39$0.032$0.041$20.297$0.03828.71%71.29%5.1055.1530Mtr 14.80 to 47.37 = 32.57KWH at home.
15
12/14/201747111122$3.5983596.61$15.47$0.032$0.043$19.068$0.04023.57%76.22%5.0554.312232.57 to 66.36
16
12/22/201758916735$5.7254227.08$15.71$0.034$0.037$21.435$0.03628.35%71.65%4.7759.603566.36 to 98
17
12/30/201761020643$7.0334047.34$17.61$0.034$0.044$24.643$0.04033.77%66.23%4.7955.04432762.79%98 to 125 = 27Kwh
18
1/5/201848110725$4.0893746.88$16.44$0.038$0.044$20.529$0.04322.25%77.75%4.2854.36252288.00%125 to 147 = 22Kwh
19
1/13/201856820244$7.1973666.26$14.51$0.036$0.040$21.707$0.03835.56%64.44%4.5958.47443477.27%147 to 181 = 34Kwh
20
1/23/201868027657$9.3234047.21$17.73$0.034$0.044$27.053$0.04040.59%59.41%4.8456.03575087.72%181 to 231 = 50Kwh
21
2/1/201865826153$8.6693976.60$17.10$0.033$0.043$25.769$0.03939.67%60.33%4.9260.15534279.25%231 to 273 = 42Kwh
22
2/16/201882634669$11.2864787.78$23.34$0.033$0.049$34.626$0.04241.89%57.87%5.0161.44695275.36%273 to 325 = 52Kwh
23
3/1/201872227255$8.9964507.33$21.99$0.033$0.049$30.986$0.04337.67%62.33%4.9561.395555100.00%325 to 380 = 55Kwh
24
3/10/201862717735$5.7254506.98$16.34$0.032$0.036$22.065$0.03528.23%71.77%5.0664.473536102.86%
380 to 416 = 36Kwh - Charged at work during the time periods shaded above - Stopped at this point.
25
3/21/201858813026$4.1874587.96$19.10$0.032$0.042$23.287$0.04022.11%77.89%4.0657.542632123.08%416 to 448 = 32Kwh
26
3/27/20185139219$3.2714216.90$17.94$0.036$0.043$21.211$0.04117.93%82.07%3.6861.011925131.58%448 to 473 = 25Kwh
27
4/7/201856013827$5.2344227.44$18.59$0.038$0.044$23.824$0.04324.64%75.36%3.4556.722740148.15%473 to 513 = 40Kwh Oil Chg
28
4/12/20185268015$2.3554467.52$18.58$0.029$0.042$20.935$0.04015.21%84.79%4.4459.311518120.00%513 to 531 = 18Kwh
29
4/19/201857112623$3.7954457.44$22.33$0.030$0.050$26.125$0.04622.07%77.93%4.3459.812329126.09%531 to 560 = 29Kwh
30
5/4/201874026453$8.3744767.48$19.14$0.032$0.040$27.514$0.03735.68%64.32%4.1363.645364120.75%560 to 624 = 64Kwh
31
5/10/201851011822$3.6643926.65$18.60$0.031$0.047$22.264$0.04423.14%76.86%4.2158.952228127.27%624 to 652 = 28Kwh
32
5/24/201865521143$7.0334447.23$20.97$0.033$0.047$28.003$0.04332.21%67.79%3.9161.414354125.58%652 to 706 = 54Kwh
33
5/31/201863315329$4.7434798.03$26.02$0.031$0.054$30.763$0.04924.17%75.67%4.5059.652934117.24%706 to 740 = 34Kwh
34
6/3/201845110$0.0004518.30$22.82$0.000$0.051$22.820$0.0510.22%100.00%5.0054.3400.2#DIV/0!
740 - 0 Kwh Used - Road Trip to WPB - Numbers added to keep formulas active
35
6/11/201864611724$3.9265288.51$22.13$0.034$0.042$26.056$0.04018.11%81.73%3.6662.042432133.33%740 to 772 = 32Kwh
36
6/19/201857110924$3.9264617.94$20.64$0.036$0.045$24.566$0.04319.09%80.74%3.6358.062430125.00%772 to 802 = 30Kwh - New Tires
37
6/27/20185809521$3.4354848.32$21.36$0.036$0.044$24.795$0.04316.38%83.45%3.5258.172127128.57%802 to 829 = 27 Kwh
38
7/5/20185619020$3.2714698.03$21.10$0.036$0.045$24.371$0.04316.04%83.60%3.2158.412028140.00%829 to 857 = 28Kwh
39
8/2/201869722850$8.1784677.66$19.46$0.036$0.042$27.638$0.04032.71%67.00%3.8060.975060120.00%857 to 917 = 60Kwh
40
8/9/201857511125$4.0894638.07$22.57$0.037$0.049$26.659$0.04619.30%80.52%3.5857.372531124.00%917 to 948 = 31Kwh
41
8/16/201855510825$4.0894467.47$19.95$0.038$0.045$24.039$0.04319.46%80.36%3.4859.712531124.00%948 to 979 = 31Kwh
42
8/30/201869120546$7.5244858.14$25.88$0.037$0.053$33.404$0.04829.67%70.19%3.6659.584656121.74%979 to 1035 = 56 Kwh
43
9/9/201863019041$6.7064397.53$20.33$0.035$0.046$27.036$0.04330.16%69.68%3.6558.304152126.83%1035 to 1087 = 52
44
9/16/201858911624$3.9264728.07$21.95$0.034$0.047$25.876$0.04419.69%80.14%3.8758.492430125.00%1087 to 1117 = 30Kwh
45
9/25/20184968919$3.1084076.97$19.52$0.035$0.048$22.628$0.04617.94%82.06%3.7158.391924126.32%1117 to 1141 = 24Kwh
46
9/27/2018439202$0.4034177.34$20.55$0.020$0.049$20.953$0.0484.56%94.99%4.0056.8125250.00%
1141 to 1146 = 5Kwh Road trip to Jacksonville -- Updated Elect rate to .1585/Kwh, 1.27 multiplier
47
10/4/201858611326$5.2344718.12$22.41$0.046$0.048$27.644$0.04719.28%80.38%3.3258.002634130.77%1146 to 1180 = 34Kwh
48
10/18/201899424251$10.26675212.16$32.80$0.042$0.044$43.066$0.04324.35%75.65%3.7861.845164125.49%1180 to 1244 = 64Kwh
49
10/28/201862620240$8.0524236.95$18.06$0.040$0.043$26.112$0.04232.27%67.57%4.2160.864048120.00%1244 to 1292 = 48Kwh
50
11/5/201859313228$5.6364607.61$18.79$0.043$0.041$24.426$0.04122.26%77.57%3.7760.452835125.00%1292 to 1327 = 35Kwh
51
11/14/201857511924$4.8314567.49$17.07$0.041$0.037$21.901$0.03820.70%79.30%3.9760.882430125.00%1327 to 1357 = 30Kwh
52
11/20/201845711623$4.6303405.87$13.26$0.040$0.039$17.890$0.03925.38%74.40%3.8757.922330130.43%1357 to 1387 = 30Kwh
53
11/29/201859515130$6.0394447.68$16.66$0.040$0.038$22.699$0.03825.38%74.62%4.0857.813037123.33%1387 to 1424 = 37Kwh
54
12/12/201888319338$7.64969012.20$26.26$0.040$0.038$33.909$0.03821.86%78.14%3.9456.563849128.95%1424 to 1473 = 49Kwh
55
12/19/201854510823$4.6304377.28$15.86$0.043$0.036$20.490$0.03819.82%80.18%3.8660.032328121.74%1473 to 1501 = 28 Kwh
56
12/27/201853713329$5.8384037.53$15.28$0.044$0.038$21.118$0.03924.77%75.05%3.6953.522936124.14%1501 to 1537 = 36Kwh
57
1/3/20195188918$3.6234287.25$14.20$0.041$0.033$17.823$0.03417.18%82.63%3.8759.031823127.78%1537 to 1560 = 23Kwh
58
1/10/201957913627$5.4354427.61$14.69$0.040$0.033$20.125$0.03523.49%76.34%3.8958.082735129.63%1560 to 1595 = 35Kwh
59
1/19/201964518438$7.6494618.08$17.45$0.042$0.038$25.099$0.03928.53%71.47%4.0057.053846121.05%1595 to 1641 = 46 Kwh
60
1/27/201962917636$7.2474537.88$16.39$0.041$0.036$23.637$0.03827.98%72.02%3.9157.493645125.00%1641 to 1686 = 45Kwh
61
2/9/201966919839$7.8514718.28$18.05$0.040$0.038$25.901$0.03929.60%70.40%4.1356.883948123.08%1686 to 1734 = 48Kwh
62
2/16/201957613627$5.4354407.58$16.61$0.040$0.038$22.045$0.03823.61%76.39%3.7858.052736133.33%1734 to 1770 = 36Kwh
63
2/25/20194547314$2.8183816.68$15.15$0.039$0.040$17.968$0.04016.08%83.92%4.2957.041417121.43%1770 to 1787 = 17Kwh
64
3/1/20195715911$2.2145117.51$18.40$0.038$0.036$20.614$0.03610.33%89.49%4.2168.041114127.27%1787 to 1801 = 14Kwh
65
3/7/201956512026$5.2344457.95$19.08$0.044$0.043$24.314$0.04321.24%78.76%3.6455.972633126.92%1801 to 1834 = 33Kwh
66
3/13/201951210922$4.4284036.87$17.86$0.041$0.044$22.288$0.04421.29%78.71%3.7658.662229131.82%1834 to 1863 = 29Kwh
67
3/28/201958011122$4.4284688.18$22.49$0.040$0.048$26.918$0.04619.14%80.69%3.8357.212229131.82%1863 to 1892 = 29 Kwh
68
4/4/201953712926$5.2344077.26$19.30$0.041$0.047$24.534$0.04624.02%75.79%3.9156.062633126.92%1892 to 1925 = 33Kwh
69
4/10/201960714829$5.8384598.13$22.74$0.039$0.050$28.578$0.04724.38%75.62%4.1156.462936124.14%1925 to 1961 = 36Kwh
70
4/19/201965716233$6.6434958.21$21.83$0.041$0.044$28.473$0.04324.66%75.34%3.8660.293342127.27%1961 to 2003 = 42Kwh
71
4/29/201990818035$7.04572713.37$36.52$0.039$0.050$43.565$0.04819.82%80.07%4.0954.383544125.71%2003 to 2047 = 44Kwh
72
5/7/201955510420$4.0264497.73$20.79$0.039$0.046$24.816$0.04518.74%80.90%3.8558.092027135.00%2047 to 2074 = 27Kwh
73
5/15/201961114730$6.0394647.94$20.09$0.041$0.043$26.129$0.04324.06%75.94%3.8758.443038126.67%2074 to 2112 = 38 Kwh
74
5/25/201958814628$5.6364427.71$19.43$0.039$0.044$25.066$0.04324.83%75.17%4.1757.332835125.00%2112 to 2147 = 35 Kwh
75
6/12/2019117822947$9.46194717.00$42.63$0.041$0.045$52.091$0.04419.44%80.39%3.6955.714762131.91%2147 to 2209 = 62Kwh
76
6/15/20194286312$2.4163646.47$15.78$0.038$0.043$18.196$0.04314.72%85.05%4.5056.261214116.67%2209 to 2223 = 14Kwh
77
6/29/2019134414029$5.838120120.62$50.69$0.042$0.042$56.528$0.04210.42%89.36%3.2658.242943148.28%2223 to 2266 = 43 Kwh
78
7/10/2019106418638$7.64987815.30$40.43$0.041$0.046$48.079$0.04517.48%82.52%3.9657.393847123.68%2266 to 2313 = 47Kwh
79
7/18/20194586613$2.6173926.99$18.68$0.040$0.048$21.297$0.04614.41%85.59%4.1356.081316123.08%2313 to 2329 = 16 Kwh
80
8/5/2019133719839$7.851113819.98$49.97$0.040$0.044$57.821$0.04314.81%85.12%3.8156.963952133.33%2329 to 2381 = 52 Kwh
81
8/16/201988718037$7.44870611.85$27.57$0.041$0.039$35.018$0.03920.29%79.59%3.8359.583747127.03%2381 to 2428 = 47 Kwh
82
9/9/2019183237778$15.701145525.18$62.28$0.042$0.043$77.981$0.04320.58%79.42%3.8557.787898125.64%2428 to 2526 = 98Kwh
83
10/6/2019173639280$16.104134422.98$55.24$0.041$0.041$71.344$0.04122.58%77.42%3.9258.4980100125.00%2526 to 2626 = 100Kwh
84
12/18/20195203999191$38.447420474.22$172.01$0.038$0.041$210.457$0.04019.20%80.80%4.0856.64191245128.27%2626 to 2871 = 245Kwh
85
2/9/20203547787151$30.396275948.57$115.15$0.039$0.042$145.546$0.04122.19%77.78%4.1256.80151191126.49%2871 to 3062 = 191Kwh
86
5/24/202034611019191$38.447244142.15$89.40$0.038$0.037$127.847$0.03729.44%70.53%4.0157.91191254132.98%
3062 to 3316 = 254Kwh COVID - Did not capture Kwh in car - Estimated
87
10/18/202049722681503$101.251229138.19$83.47$0.038$0.036$184.721$0.03753.92%46.08%5.1759.99503519103.18%
3316 to 3835 = 519Kwh - Lost data due to 12v battery change. All are estimated.
88
Test1011$0.16490.16$0.40$0.164$0.044$0.564$0.05610.00%90.00%1.0056.251
89
65424165083287$621.41448875842.16$2,071.67$0.038$0.043$2,693.084$0.04225.23%74.71%5.0258.04
90
91
DateItemCost
Odometer
92
11/17/2017Purchase$20,702.00 18,995
93
11/17/2017Sunshade$10.69 18,995
94
11/17/2017Floor Mats$21.39 18,995
95
12/10/2017Techron$20.00 20,000
96
12/10/2017Seat Cvr$259.00 20,000
97
3/31/2018Oil Chg/Rot$59.00 28,557
Courtesy Toyota - Also did fuse recall work
98
3/31/2018Air Filter$37.00 28,557
Toyota Part - Not installed until 08/21/2018 as filter looked brand new still
99
06/12/2018Tires$717.42 33,315
Mavis/Kaufman Tire - 4 Tires, Alignment, Road Hazard Cvg
100
08/21/2018Oil Chg/Rot$73.8837,082
Courtesy Toyota