Releases: ZuinigeRijder/hyundai_kia_connect_monitor
Releases · ZuinigeRijder/hyundai_kia_connect_monitor
Fixed weekday bug in sheetupdate
fixed bug that summary.py sheetupdate showed wrong weekday for last update values.
Fixed bug in summary average computation
Fixed bug in summary.py that average were not correctly computed when only 1 entry on a day
Added GoogleSpreadsheet option: python summary.py sheetupdate
- Fixed a bug that the average SOC% and average 12 Volt% for the last entries were incorrect
- Added the option to update a Google Spreadsheet: python summary.py sheetupdate
summary.py does now have a dependency on the package gspread, so install this package, e.g. python -m pip install gspread
When you want to use the summary.py sheetupdate option, you have to configure authentication and setup a shared hyundai-kia-connect-monitor spreadsheet. See this description: https://github.com/ZuinigeRijder/hyundai_kia_connect_monitor#configuration-of-gspread-for-python-summarypy-sheetupdate
Example screenshot: https://github.com/ZuinigeRijder/hyundai_kia_connect_monitor#python-summarypy-sheetupdate
summary.py: add averages for trip, day, week, month and prediction for year
Do you also want to know how the prediction will be over a year, using the already captured information?
- How many kilometers or miles you will drive
- How many kWh you need for this?
- What does this cost over this year, using the cost per kWh
Also interesting to know:
- what is the average trip distance (TRIPAVG)?
- what is the average distance you drive per day (DAYAVG)?
- what are the averages per week (WEEKAVG) or month (MONTHAVG)
C:\Users\Rick\git\monitor>python summary.py year
Period, date , info , odometer, delta km, +kWh, -kWh, km/kWh, kWh/100km, cost Euro, SOC%CUR,AVG,MIN,MAX, 12V%CUR,AVG,MIN,MAX, #charges, #trips, #moves
YEAR , 2022-09-25, 2022 , 17794.9, 470.7, 70.7, -73.5, 6.4, 15.6, 18.08, 50, 50, 5,100, 97, 97, 85, 98, 7 , 14 , 27
TRIPAVG , 2022-09-25, 14t , 17794.9, 33.6, 5.0, -5.2, 6.4, 15.6, 1.29, 50, 50, 5,100, 97, 97, 85, 98, 0.5, 1 , 1.9
DAYAVG , 2022-09-25, 9d , 17794.9, 52.3, 7.9, -8.2, 6.4, 15.6, 2.01, 50, 50, 5,100, 97, 97, 85, 98, 0.8, 1.6, 3
WEEKAVG , 2022-09-25, 9d , 17794.9, 366.1, 55.0, -57.2, 6.4, 15.6, 14.06, 50, 50, 5,100, 97, 97, 85, 98, 5.4, 10.9, 21
MONTHAVG, 2022-09-25, 9d , 17794.9, 1590.8, 238.9, -248.4, 6.4, 15.6, 61.11, 50, 50, 5,100, 97, 97, 85, 98, 23.7, 47.3, 91.2
YEARLY , 2022-09-25, 9d , 17794.9, 19089.5, 2867.3, -2980.8, 6.4, 15.6, 733.29, 50, 50, 5,100, 97, 97, 85, 98, 283.9, 567.8, 1095
Added odometer, current SOC% and current 12V% to summary
For trip administration tools it is of course important also to be able to see the odometer value for a particular day or trip. And I discovered this was NOT in the summary overview. So this is added to summary.py.
Also the current SOC% is added, so you know what the end SOC was e.g. on a particular day. The same for 12Volt%.
C:\Users\Rick\git\monitor>python summary.py
Period, date , info , odometer, delta km, +kWh, -kWh, km/kWh, kWh/100km, cost Euro, SOC%CUR,AVG,MIN,MAX, 12V%CUR,AVG,MIN,MAX, #charges, #drives, #moves
DAY , 2022-09-17, Sat , 17324.2, , 2.8, , , , , 58, 55, 55, 58, 91, 91, 91, 91, 1, ,
DAY , 2022-09-18, Sun , 17324.2, , 0.7, , , , , 59, 59, 59, 60, 91, 91, 91, 91, , ,
WEEK , 2022-09-18, WK 37, 17324.2, , 3.5, , , , , 59, 59, 55, 60, 91, 91, 91, 91, 1, ,
TRIP , 2022-09-19, 15:00, 17324.3, 0.1, , , , , , 61, 60, 60, 61, 85, 90, 85, 91, , 1, 1
TRIP , 2022-09-19, 16:00, 17330.7, 6.4, , -1.4, , , , 59, 60, 59, 59, 86, 85, 86, 86, , 1, 1
DAY , 2022-09-19, Mon , 17330.7, 6.5, , , , , , 59, 60, 59, 61, 86, 88, 85, 91, , 2, 2
TRIP , 2022-09-20, 08:00, 17358.9, 28.2, , -4.2, 6.7, 14.9, 1.03, 53, 57, 53, 59, 91, 88, 88, 91, , 1, 2
TRIP , 2022-09-20, 15:30, 17371.5, 12.6, , -2.1, 6.0, 16.7, 0.52, 48, 50, 48, 51, 92, 90, 87, 92, , 1, 3
TRIP , 2022-09-20, 15:58, 17378.3, 6.8, , -0.7, , , , 47, 47, 47, 47, 91, 91, 91, 91, , 1, 1
DAY , 2022-09-20, Tue , 17378.3, 47.6, , -7.0, 6.8, 14.7, 1.72, 45, 48, 45, 59, 91, 91, 87, 92, , 3, 6
TRIP , 2022-09-21, 12:30, 17380.8, 2.5, 4.9, , , , , 52, 48, 46, 52, 92, 91, 91, 92, 1, 1, 1
TRIP , 2022-09-21, 13:00, 17383.5, 2.7, , -0.7, , , , 51, 51, 51, 51, 91, 91, 91, 91, , 1, 1
DAY , 2022-09-21, Wed , 17383.5, 5.2, 18.2, -0.7, , , , 70, 63, 46, 70, 91, 91, 91, 92, 2, 2, 2
DAY , 2022-09-22, Thu , 17383.5, , , , , , , 72, 72, 72, 72, 91, 91, 91, 91, 1, ,
TRIP , 2022-09-23, 11:21, 17385.4, 1.9, , -0.7, , , , 71, 71, 71, 71, 88, 89, 88, 88, , 1, 1
TRIP , 2022-09-23, 12:00, 17387.1, 1.7, 0.7, , , , , 72, 71, 72, 72, 87, 87, 87, 87, 1, 1, 1
DAY , 2022-09-23, Fri , 17387.1, 3.6, 20.3, -0.7, , , , 100, 86, 71,100, 87, 87, 87, 88, 2, 2, 2
TRIP , 2022-09-24, 09:57, 17390.8, 3.7, , -0.7, , , , 99,100, 99,100, 95, 94, 95, 95, , 1,
TRIP , 2022-09-24, 13:21, 17589.2, 198.4, , -32.9, 6.0, 16.6, 8.09, 52, 80, 52, 98, 96, 96, 92, 98, , 1, 6
TRIP , 2022-09-24, 14:31, 17592.5, 3.3, , -0.7, , , , 51, 51, 51, 51, 94, 95, 94, 94, , 1, 1
TRIP , 2022-09-24, 15:23, 17597.3, 4.8, , -0.7, , , , 50, 51, 50, 51, 96, 94, 93, 96, , 1, 2
TRIP , 2022-09-24, 19:00, 17794.9, 197.6, , -31.5, 6.3, 15.9, 7.75, 5, 30, 5, 50, 97, 95, 94, 97, 1, 1, 6
DAY , 2022-09-24, Sat , 17794.9, 407.8, 25.9, -66.5, 6.1, 16.3, 16.36, 42, 40, 5,100, 97, 96, 92, 98, 1, 5, 15
DAY , 2022-09-25, Sun , 17794.9, , 5.6, , , , , 50, 50, 43, 50, 97, 97, 97, 97, , ,
WEEK , 2022-09-25, WK 38, 17794.9, 470.7, 67.2, -73.5, 6.4, 15.6, 18.08, 50, 50, 5,100, 97, 97, 85, 98, 6, 14, 27
MONTH , 2022-09-25, Sep , 17794.9, 470.7, 70.7, -73.5, 6.4, 15.6, 18.08, 50, 50, 5,100, 97, 97, 85, 98, 7, 14, 27
YEAR , 2022-09-25, 2022 , 17794.9, 470.7, 70.7, -73.5, 6.4, 15.6, 18.08, 50, 50, 5,100, 97, 97, 85, 98, 7, 14, 27
Added address possibility to kml.py and small improvements
- added address possibility to kml.py
- map None to -1 in kml.py (when no 12 volt percentage is reported)
- added requirements.txt for the needed dependencies
- added dependency hyundai_kia_connect_api==1.34.4
- added kml.py address parameter explanation in README.md
- when day change, use first entry as previous day at 23:59 in summary.py, otherwise trips after the last snapshot of a day are counted wrong
Example:
C:\Users\Rick\git\monitor>python kml.py address
1: 20220917 15:00 (5.124957,51.68260 ) SOC: 54% 12V: 90% ODO: 17324.2 Address: "26, Keniaring, Drunen, Heusden, Noord-Brabant, Nederland, 5152 MX, Nederland"
2: 20220917 23:00 C (5.124957,51.68260 ) SOC: 55% 12V: 91% ODO: 17324.2 Address: "26, Keniaring, Drunen, Heusden, Noord-Brabant, Nederland, 5152 MX, Nederland" charging plugged:2
3: 20220918 01:00 (5.124957,51.68260 ) SOC: 60% 12V: 91% ODO: 17324.2 Address: "26, Keniaring, Drunen, Heusden, Noord-Brabant, Nederland, 5152 MX, Nederland" plugged:2
4: 20220919 15:00 D (5.125942,51.679128) SOC: 61% 12V: 85% ODO: 17324.3 Address: "Statenlaan, Drunen, Heusden, Noord-Brabant, Nederland, 5152 SG, Nederland" (+0.1 since 20220919 14:00) drive
5: 20220919 16:00 (5.124957,51.68260 ) SOC: 59% 12V: 86% ODO: 17330.7 Address: "26, Keniaring, Drunen, Heusden, Noord-Brabant, Nederland, 5152 MX, Nederland" (+6.4 since 20220919 15:00)
6: 20220920 07:00 D (5.091594,51.684361) SOC: 59% 12V: 88% ODO: 17330.7 Address: "Akkerlaan, Bloemenoord, Waalwijk, Noord-Brabant, Nederland, 5143 ND, Nederland" drive
7: 20220920 08:00 (5.124957,51.68260 ) SOC: 53% 12V: 91% ODO: 17358.9 Address: "26, Keniaring, Drunen, Heusden, Noord-Brabant, Nederland, 5152 MX, Nederland" (+28.2 since 20220920 07:00)
8: 20220920 14:30 D (5.135242,51.692605) SOC: 50% 12V: 87% ODO: 17358.9 Address: "18, Leliestraat, Drunen, Heusden, Noord-Brabant, Nederland, 5151 TP, Nederland" drive
9: 20220920 15:00 D (5.078042,51.693758) SOC: 49% 12V: 91% ODO: 17358.9 Address: "Desso Tarkett, 15, Taxandriaweg, Laageinde, Waalwijk, Noord-Brabant, Nederland, 5142 PA, Nederland" drive
10: 20220920 15:30 (5.04708 ,51.688192) SOC: 48% 12V: 92% ODO: 17371.5 Address: "29b, Westeinde, Besoijen, Waalwijk, Noord-Brabant, Nederland, 5141 AA, Nederland" (+12.6 since 20220920 15:00)
11: 20220920 15:58 (5.124957,51.68260 ) SOC: 47% 12V: 91% ODO: 17378.3 Address: "26, Keniaring, Drunen, Heusden, Noord-Brabant, Nederland, 5152 MX, Nederland" (+6.8 since 20220920 15:30)
12: 20220921 10:30 C (5.124957,51.68260 ) SOC: 46% 12V: 91% ODO: 17378.3 Address: "26, Keniaring, Drunen, Heusden, Noord-Brabant, Nederland, 5152 MX, Nederland" charging plugged:2
13: 20220921 12:30 (5.135183,51.692608) SOC: 52% 12V: 92% ODO: 17380.8 Address: "18, Leliestraat, Drunen, Heusden, Noord-Brabant, Nederland, 5151 TP, Nederland" (+2.5 since 20220921 12:00)
14: 20220921 13:00 (5.124957,51.68260 ) SOC: 51% 12V: 91% ODO: 17383.5 Address: "26, Keniaring, Drunen, Heusden, Noord-Brabant, Nederland, 5152 MX, Nederland" (+2.7 since 20220921 12:30)
15: 20220921 14:31 C (5.124957,51.68260 ) SOC: 52% 12V: 91% ODO: 17383.5 Address: "26, Keniaring, Drunen, Heusden, Noord-Brabant, Nederland, 5152 MX, Nederland" charging plugged:2
16: 20220922 06:00 (5.124957,51.68260 ) SOC: 70% 12V: 91% ODO: 17383.5 Address: "26, Keniaring, Drunen, Heusden, Noord-Brabant, Nederland, 5152 MX, Nederland" plugged:2
17: 20220923 11:21 (5.132119,51.685055) SOC: 71% 12V: 88% ODO: 17385.4 Address: "Jumbo Aalbersestraat, 5, Aalbersestraat, Drunen, Heusden, Noord-Brabant, Nederland, 5151 EE, Nederland" (+1.9 since 20220923 11:00)
18: 20220923 12:00 C (5.124957,51.68260 ) SOC: 72% 12V: 87% ODO: 17387.1 Address: "26, Keniaring, Drunen, Heusden, Noord-Brabant, Nederland, 5152 MX, Nederland" (+1.7 since 20220923 11:21) charging plugged:2
19: 20220923 15:00 (5.124957,51.68260 ) SOC: 80% 12V: 87% ODO: 17387.1 Address: "26, Keniaring, Drunen, Heusden, Noord-Brabant, Nederland, 5152 MX, Nederland" plugged:2
20: 20220924 08:00 D (5.124957,51.68260 ) SOC:100% 12V: 95% ODO: 17387.1 Address: "26, Keniaring, Drunen, Heusden, Noord-Brabant, Nederland, 5152 MX, Nederland" drive
21: 20220924 08:30 (5.124957,51.68260 ) SOC:100% 12V: 95% ODO: 17387.1 Address: "26, Keniaring, Drunen, Heusden, Noord-Brabant, Nederland, 5152 MX, Nederland"
22: 20220924 11:00 D (5.129967,51.674819) SOC: 98% 12V: 92% ODO: 17390.8 Address: "140, Torenstraat, Drunen, Heusden, Noord-Brabant, Nederland, 5151 JN, Nederland" drive
23: 20220924 11:30 D (5.204728,51.883719) SOC: 91% 12V: 97% ODO: 17390.8 Address: "Rijksweg A2, Enspijk, West Betuwe, Gelderland, Nederland, 4153 RN, Nederland" drive
24: 20220924 12:00 D (5.250064,52.256122) SOC: 81% 12V: 98% ODO: 17390.8 Address: "Rijksweg A27, Eemnes, Utrecht, Nederland, 3755 AS, Nederland" drive
25: 20220924 12:30 D (5.540714,52.575733) SOC: 69% 12V: 98% ODO: 17390.8 Address: "Rijksweg A6, Lelystad, Flevoland, Nederland, 8221 RD, Nederland" drive
26: 20220924 13:00 D (5.768325,52.898894) SOC: 57% 12V: 98% ODO: 17390.8 Address: "A6, Oldeouwer, De Fryske Marren, Fryslân, Nederland, 8516 DD, Nederland" drive
27: 20220924 13:21 (5.683261,53.036686) SOC: 52% 12V: 96% ODO: 17589.2 Address: "17-101, Dekamalaan, Sneek, Súdwest-Fryslân, Fryslân, Nederland, 8604 ZG, Nederland" (+198.4 since 20220924 13:00)
28: 20220924 14:31 (5.681147,53.016858) SOC: 51% 12V: 94% ODO: 17592.5 Address: "Van der Valk Hotel Sneek, 1, Burgemeester Rasterhofflaan, Houkesloot, Sneek, Súdwest-Fryslân, Fryslân, Nederland, 8606 KZ, Nederland" (+3.3 since 20220924 14:00)
29: 20220924 15:00 D (5.686422,53.030697) SOC: 51% 12V: 93% ODO: 17592.5 Address: "Stadsrondweg-Oost, Houkesloot, Sneek, Súdwest-Fryslân, Fryslân, Nederland, 8604 GC, Nederland" drive
30: 20220924 15:23 (5.68325 ,53.036683) SOC: 50% 12V: 96% ODO: 17597.3 Address: "17-101, Dekamalaan, Sneek, Súdwest-Fryslân, Fryslân, Nederland, 8604 ZG, Nederland" (+4.8 since 20220924 15:00)
31: 20220924 16:30 D (5.6802 ,53.035853) SOC: 50% 12V: 94% ODO: 17597.3 Address: "10, Groenedijk, Sneek, Súdwest-Fryslân, Fryslân, Nederland, 8604 AB, Nederland" drive
32: 20220924 17:00 D (5.771994,52.709039) SOC: 40% 12V: 94% ODO: 17597.3 Address: "A6, De Zuidert, Emmeloord, Noordoostpolder, Flevoland, Nederland, 8305 AC, Nederland" drive
33: 20220924 17:30 D (5.375436,52.411236) SOC: 30% 12V: 95% ODO: 17597.3 Address: "Rijksweg A6, Lelystad, Flevoland, Nederland, 3897 MA, Nederland" drive
34: 20220924 18:00 D (5.158522,52.095317) SOC: 21% 12V: 94% ODO: 17597.3 Address: "A27, Rijnsweerd, Utrecht, Nederland, 3731 GC, Nederland" drive
35: 20220924 18:30 D (5.293333,51.748758) SOC: 10% 12V: 96% ODO: 17597.3 Address: "A2, Hoenzadriel, Maasdriel, Gelderland, Nederland, 5334 NV, Nederland" drive
36: 20220924 19:00 C (5.124957,51.68260 ) SOC: 5% 12V: 97% ODO: 17794.9 Address: "26, Keniaring, Drunen, Heusden, Noord-Brabant, Nederland, 5152 MX, Nederland" (+197.6 since 20220924 18:30) charging plugged:2
summary.py: added moves and addresses possibilities
- Whenever the State Of Charge % or 12 Volt % is returning None, this is mapped to -1 (can occur if car cannot determine the value).
- The number of coordinate changes is now counted (#moves in summary.py)
- The distance between two changed coordinates are computed using geopy (so this is not the actual distance using the road) when move is gives as parameter to summary.py
- The address is computed for move and/or trip when address is given as parameter to summary.py
- Each address lookup will sleep for 1 second, to avoid abuse of the geopy Nominatim service limitations/abuse
Note that you need to install the python package geopy for summary.py
Example output when showing day, trip, move and address:
C:\Users\Rick\git\monitor>python summary.py day trip move address
Period, date , info , delta km, +kWh, -kWh, km/kWh, kWh/100km, cost Euro, SOC%AVG,MIN,MAX, 12V%AVG,MIN,MAX, #charges, #drives, #moves, Address
DAY , 2022-09-17, Sat , , 0.7, , , , , 54, 55, 55, 90, 91, 91, 1, , ,
DAY , 2022-09-18, Sun , , 2.8, , , , , 59, 58, 60, 91, 91, 91, , , ,
MOVE , 2022-09-19, 15:00, 0.4, , , , , , 61, 61, 61, 88, 85, 85, , 1, 1, "Statenlaan, Drunen, Heusden, Noord-Brabant, Nederland, 5152 SG, Nederland"
TRIP , 2022-09-19, 15:00, 0.1, 3.5, , , , , 59, 55, 61, 91, 85, 91, 1, 1, 1, "Statenlaan, Drunen, Heusden, Noord-Brabant, Nederland, 5152 SG, Nederland"
MOVE , 2022-09-19, 16:00, 0.4, , -1.4, , , , 60, 59, 59, 85, 86, 86, , 1, 1, "26, Keniaring, Drunen, Heusden, Noord-Brabant, Nederland, 5152 MX, Nederland"
TRIP , 2022-09-19, 16:00, 6.4, , -1.4, , , , 60, 59, 59, 85, 86, 86, , 1, 1, "26, Keniaring, Drunen, Heusden, Noord-Brabant, Nederland, 5152 MX, Nederland"
DAY , 2022-09-19, Mon , 6.5, , , , , , 60, 59, 61, 89, 85, 91, , 2, 2,
MOVE , 2022-09-20, 07:00, 2.3, , , , , , 59, 59, 59, 87, 88, 88, , , 1, "Akkerlaan, Bloemenoord, Waalwijk, Noord-Brabant, Nederland, 5143 ND, Nederland"
MOVE , 2022-09-20, 08:00, 2.3, , -4.2, 0.5, 182.6, 1.03, 56, 53, 53, 89, 91, 91, , 1, 1, "26, Keniaring, Drunen, Heusden, Noord-Brabant, Nederland, 5152 MX, Nederland"
TRIP , 2022-09-20, 08:00, 28.2, , -4.2, 6.7, 14.9, 1.03, 58, 53, 59, 87, 86, 91, , 1, 2, "26, Keniaring, Drunen, Heusden, Noord-Brabant, Nederland, 5152 MX, Nederland"
MOVE , 2022-09-20, 14:30, 1.3, , -0.7, , , , 50, 50, 50, 89, 87, 87, , , 1, "18, Leliestraat, Drunen, Heusden, Noord-Brabant, Nederland, 5151 TP, Nederland"
MOVE , 2022-09-20, 15:00, 4.0, , -0.7, , , , 49, 49, 49, 89, 91, 91, , , 1, "Desso Tarkett, 15, Taxandriaweg, Laageinde, Waalwijk, Noord-Brabant, Nederland, 5142 PA, Nederland"
MOVE , 2022-09-20, 15:30, 2.2, , -0.7, , , , 48, 48, 48, 91, 92, 92, , 1, 1, "29b, Westeinde, Besoijen, Waalwijk, Noord-Brabant, Nederland, 5141 AA, Nederland"
TRIP , 2022-09-20, 15:30, 12.6, , -2.1, 6.0, 16.7, 0.52, 50, 48, 51, 90, 87, 92, , 1, 3, "29b, Westeinde, Besoijen, Waalwijk, Noord-Brabant, Nederland, 5141 AA, Nederland"
MOVE , 2022-09-20, 15:58, 5.4, , -0.7, , , , 47, 47, 47, 91, 91, 91, , 1, 1, "26, Keniaring, Drunen, Heusden, Noord-Brabant, Nederland, 5152 MX, Nederland"
TRIP , 2022-09-20, 15:58, 6.8, , -0.7, , , , 47, 47, 47, 91, 91, 91, , 1, 1, "26, Keniaring, Drunen, Heusden, Noord-Brabant, Nederland, 5152 MX, Nederland"
DAY , 2022-09-20, Tue , 47.6, , -7.0, 6.8, 14.7, 1.72, 54, 47, 59, 89, 86, 92, , 3, 6,
MOVE , 2022-09-21, 12:30, 1.3, 0.7, , , , , 51, 52, 52, 91, 92, 92, , 1, 1, "18, Leliestraat, Drunen, Heusden, Noord-Brabant, Nederland, 5151 TP, Nederland"
TRIP , 2022-09-21, 12:30, 2.5, 3.5, , , , , 46, 45, 52, 91, 91, 92, 1, 1, 1, "18, Leliestraat, Drunen, Heusden, Noord-Brabant, Nederland, 5151 TP, Nederland"
MOVE , 2022-09-21, 13:00, 1.3, , -0.7, , , , 51, 51, 51, 91, 91, 91, , 1, 1, "26, Keniaring, Drunen, Heusden, Noord-Brabant, Nederland, 5152 MX, Nederland"
TRIP , 2022-09-21, 13:00, 2.7, , -0.7, , , , 51, 51, 51, 91, 91, 91, , 1, 1, "26, Keniaring, Drunen, Heusden, Noord-Brabant, Nederland, 5152 MX, Nederland"
DAY , 2022-09-21, Wed , 5.2, 15.4, -0.7, , , , 50, 45, 68, 91, 91, 92, 2, 2, 2,
DAY , 2022-09-22, Thu , , 1.4, , , , , 69, 70, 72, 91, 91, 91, 1, , ,
MOVE , 2022-09-23, 11:21, 0.6, , -0.7, , , , 71, 71, 71, 89, 88, 88, , 1, 1, "Jumbo Aalbersestraat, 5, Aalbersestraat, Drunen, Heusden, Noord-Brabant, Nederland, 5151 EE, Nederland"
TRIP , 2022-09-23, 11:21, 1.9, 13.3, , , , , 68, 52, 72, 91, 88, 91, 2, 1, 1, "Jumbo Aalbersestraat, 5, Aalbersestraat, Drunen, Heusden, Noord-Brabant, Nederland, 5151 EE, Nederland"
MOVE , 2022-09-23, 12:00, 0.6, 0.7, , , , , 71, 72, 72, 87, 87, 87, 1, 1, 1, "26, Keniaring, Drunen, Heusden, Noord-Brabant, Nederland, 5152 MX, Nederland"
TRIP , 2022-09-23, 12:00, 1.7, 0.7, , , , , 71, 72, 72, 87, 87, 87, 1, 1, 1, "26, Keniaring, Drunen, Heusden, Noord-Brabant, Nederland, 5152 MX, Nederland"
DAY , 2022-09-23, Fri , 3.6, 6.3, -0.7, , , , 73, 71, 80, 90, 87, 91, 1, 2, 2,
TRIP , 2022-09-24, 09:57, 3.7, 19.6, -0.7, , , , 88, 73,100, 88, 87, 95, 1, 1, , "26, Keniaring, Drunen, Heusden, Noord-Brabant, Nederland, 5152 MX, Nederland"
MOVE , 2022-09-24, 11:00, 0.9, , -0.7, , , , 98, 98, 98, 93, 92, 92, , , 1, "140, Torenstraat, Drunen, Heusden, Noord-Brabant, Nederland, 5151 JN, Nederland"
MOVE , 2022-09-24, 11:30, 23.8, , -4.9, 4.9, 20.6, 1.21, 94, 91, 91, 94, 97, 97, , , 1, "Rijksweg A2, Enspijk, West Betuwe, Gelderland, Nederland, 4153 RN, Nederland"
MOVE , 2022-09-24, 12:00, 41.6, , -7.0, 5.9, 16.8, 1.72, 86, 81, 81, 97, 98, 98, , , 1, "Rijksweg A27, Eemnes, Utrecht, Nederland, 3755 AS, Nederland"
MOVE , 2022-09-24, 12:30, 40.7, , -8.4, 4.8, 20.6, 2.07, 75, 69, 69, 98, 98, 98, , , 1, "Rijksweg A6, Lelystad, Flevoland, Nederland, 8221 RD, Nederland"
MOVE , 2022-09-24, 13:00, 39.1, , -8.4, 4.7, 21.5, 2.07, 63, 57, 57, 98, 98, 98, , , 1, "A6, Oldeouwer, De Fryske Marren, Fryslân, Nederland, 8516 DD, Nederland"
MOVE , 2022-09-24, 13:21, 16.4, , -3.5, 4.7, 21.3, 0.86, 54, 52, 52, 97, 96, 96, , 1, 1, "17-101, Dekamalaan, Sneek, Súdwest-Fryslân, Fryslân, Nederland, 8604 ZG, Nederland"
TRIP , 2022-09-24, 13:21, 198.4, , -32.9, 6.0, 16.6, 8.09, 80, 52, 98, 96, 92, 98, , 1, 6, "17-101, Dekamalaan, Sneek, Súdwest-Fryslân, Fryslân, Nederland, 8604 ZG, Nederland"
MOVE , 2022-09-24, 14:31, 2.2, , -0.7, , , , 51, 51, 51, 95, 94, 94, , 1, 1, "Van der Valk Hotel Sneek, 1, Burgemeester Rasterhofflaan, Houkesloot, Sneek, Súdwest-Fryslân, Fryslân, Nederland, 8606 KZ, Nederland"
TRIP , 2022-09-24, 14:31, 3.3, , -0.7, , , , 51, 51, 51, 95, 94, 94, , 1, 1, "Van der Valk Hotel Sneek, 1, Burgemeester Rasterhofflaan, Houkesloot, Sneek, Súdwest-Fryslân, Fryslân, Nederland, 8606 KZ, Nederland"
MOVE , 2022-09-24, 15:00, 1.6, , , , , , 51, 51, 51, 93, 93, 93, , , 1, "Stadsrondweg-Oost, Houkesloot, Sneek, Súdwest-Fryslân, Fryslân, Nederland, 8604 GC, Nederland"
MOVE , 2022-09-24, 15:23, 0.7, , -0.7, , , , 50, 50, 50, 94, 96, 96, , 1, 1, "17-101, Dekamalaan, Sneek, Súdwest-Fryslân, Fryslân, Nederland, 8604 ZG, Nederland"
TRIP , 2022-09-24, 15:23, 4.8, , -0.7, , , , 51, 50, 51, 94, 93, 96, , 1, 2, "17-101, Dekamalaan, Sneek, Súdwest-Fryslân, Fryslân, Nederland, 8604 ZG, Nederland"
MOVE , 2022-09-24, 16:30, 0.2, , , , , ,...
summary.py improvements , added TRIP, SOC%, 12V%
Many improvements to summary.py:
- added TRIP information
- added average, minimum, maximum State Of Charge%
- added average, minimum, maximum 12 Volt %
- added possibility of combination of arguments
- added information after 1 month of use
- added option to not show zero values for better readability
- configuration when consumption data should be shown (minimum discharge in kWh)
- configuration when small delta's are not seen as charging/discharging when not charging and not moved (e.g. 2% SOC)
summary.py: added charged/discharged kWh, using location to determine moved, small delta SOC improvement
Improvements to summary.py:
- added charged/discharged kWh
- using location to determine moved
- small delta SOC improvement
- examples adapted
Example output:
C:\Users\Rick\git\monitor>python summary.py
Period, date , driven km, charged%, charged kWh, discharged%, discharged kWh, #charges, #drives, km/kWh, kWh/100km, cost Euro
DAY , 2022-09-17, 0.0, +4%, 2.8, 0%, 0.0, 1, 0, 0.0, 0.0, 0.00
DAY , 2022-09-18, 0.0, +2%, 1.4, 0%, 0.0, 0, 0, 0.0, 0.0, 0.00
WEEK , 2022 W37 , 0.0, +6%, 4.2, 0%, 0.0, 1, 0, 0.0, 0.0, 0.00
DAY , 2022-09-19, 6.5, +0%, 0.0, -1%, -0.7, 0, 2, 0.0, 0.0, 0.00
DAY , 2022-09-20, 47.6, +0%, 0.0, -14%, -9.8, 0, 2, 4.9, 20.6, 2.41
DAY , 2022-09-21, 5.2, +26%, 18.2, -1%, -0.7, 2, 2, 0.0, 0.0, 0.00
DAY , 2022-09-22, 1.9, +2%, 1.4, -1%, -0.7, 1, 1, 0.0, 0.0, 0.00
DAY , 2022-09-23, 1.7, +29%, 20.3, 0%, 0.0, 2, 1, 0.0, 0.0, 0.00
DAY , 2022-09-24, 407.8, +37%, 25.9, -95%, -66.5, 1, 6, 6.1, 16.3, 16.36
DAY , 2022-09-25, 0.0, +8%, 5.6, 0%, 0.0, 0, 0, 0.0, 0.0, 0.00
WEEK , 2022 W38 , 470.7, +102%, 71.4, -112%, -78.4, 6, 14, 6.0, 16.7, 19.29
MONTH , 2022-09 , 470.7, +108%, 75.6, -112%, -78.4, 7, 14, 6.0, 16.7, 19.29
YEAR , 2022 , 470.7, +108%, 75.6, -112%, -78.4, 7, 14, 6.0, 16.7, 19.29
Screenshot of excel example with some graphs:
summary.py improvements and (Excel) examples
22270f0 (HEAD -> main, origin/main, origin/HEAD)
- small improvement in charging/discharging counting in summary.py
- added possibility to filter on day/week/month/year
- added (Excel) examples to summary.py
output:
C:\Users\Rick\git\monitor>python summary.py
Label, date , driven km, charged%, discharged%, charges, drives, km/kWh, kWh/100km, cost Euro
DAY , 2022-09-17, 0.0, +4%, 0, 1, 0, 0.0, 0.0, 0.00
DAY , 2022-09-18, 0.0, +2%, 0, 0, 0, 0.0, 0.0, 0.00
WEEK , 2022 W37 , 0.0, +6%, 0, 1, 0, 0.0, 0.0, 0.00
DAY , 2022-09-19, 6.5, +0%, 0, 0, 2, 0.0, 0.0, 0.00
DAY , 2022-09-20, 47.6, +0%, -14, 0, 2, 4.9, 20.6, 2.41
DAY , 2022-09-21, 5.2, +25%, 0, 2, 2, 0.0, 0.0, 0.00
DAY , 2022-09-22, 1.9, +2%, 0, 1, 1, 0.0, 0.0, 0.00
DAY , 2022-09-23, 1.7, +28%, 0, 2, 1, 0.0, 0.0, 0.00
DAY , 2022-09-24, 407.8, +37%, -95, 1, 6, 6.1, 16.3, 16.36
DAY , 2022-09-25, 0.0, +8%, 0, 0, 0, 0.0, 0.0, 0.00
WEEK , 2022 W38 , 470.7, +100%, -110, 6, 14, 6.1, 16.4, 18.94
MONTH, 2022-09 , 470.7, +106%, -110, 7, 14, 6.1, 16.4, 18.94
YEAR , 2022 , 470.7, +106%, -110, 7, 14, 6.1, 16.4, 18.94
2022-09-24 I did a trip from 100% SOC to 5% SOC, have driven 407.8 km and started charging when back at home.
Example output when filtering on DAY:
C:\Users\Rick\git\monitor>python summary.py day
Label, date , driven km, charged%, discharged%, charges, drives, km/kWh, kWh/100km, cost Euro
DAY , 2022-09-17, 0.0, +4%, 0, 1, 0, 0.0, 0.0, 0.00
DAY , 2022-09-18, 0.0, +2%, 0, 0, 0, 0.0, 0.0, 0.00
DAY , 2022-09-19, 6.5, +0%, 0, 0, 2, 0.0, 0.0, 0.00
DAY , 2022-09-20, 47.6, +0%, -14, 0, 2, 4.9, 20.6, 2.41
DAY , 2022-09-21, 5.2, +25%, 0, 2, 2, 0.0, 0.0, 0.00
DAY , 2022-09-22, 1.9, +2%, 0, 1, 1, 0.0, 0.0, 0.00
DAY , 2022-09-23, 1.7, +28%, 0, 2, 1, 0.0, 0.0, 0.00
DAY , 2022-09-24, 407.8, +37%, -95, 1, 6, 6.1, 16.3, 16.36
DAY , 2022-09-25, 0.0, +8%, 0, 0, 0, 0.0, 0.0, 0.00
