JoeS said:
Would you like to start a new thread specific to this spreadsheet or would you like me to bring in everybody's comments into one thread?
That was my intention, Joe. All three threads are related to our mileage, so it seemed a good idea to me to use a spreadsheet where all data is collected together. Perhaps it makes sense to join all three threads together into one.
JoeS said:
1. The "kWh/charge" and "Loss of Capacity" is not realistic: in addition to time, measuring the input kWh varies with the input voltage and input current (and not simple power), as CaniON has shown us, and the starting point. None of us is going to deplete our battery to zero in order to perform this measurement; furthermore, the "Loss of Capacity" calculation is questionable.
I disagree, Joe. Like Malm said, it's not perfect, but it's best we got for now. Different factors: time, voltage, current... have no significant impact on the accuracy of the data. kWh does not mean power (W) but measurable amount of power used to recharge the battery. When I charge on CHAdeMO (400V, 125A, 50kW), the end result in kWh is the same as when I charge home (220V, 13A, 2,9kW) if start and end points are the same (--- to 100%).
I'm sure depleting I-miev's battery to 12% SOC or charging to 100% has no significant impact, if:
-I don't do it daily and at extreme temperatures
-I don't left the battery empty or full for to long
-I don't expose the battery to stress (high current driving and regen) in an empty range of charge
Everyone can choose between which two points of SOC levels will be measured and note it while entering data. The --- to 100% seems best range to me, because all of us haven't (yet) any OBD dongle to follow SOC.
JoeS said:
2. Perhaps add a "Comments" column? For example, my "Best Range/Charge" number is "only" 78miles, but I still had two bars remaining. No way am I going to deplete my battery just to find out how far I can go.
You can add notes or comments in every cell in the table you enter. Rightclick the entered cell, choose insert comment (note) and write it. It shows when mouse coursor is over that cell. Use note just to say something and comment to discuss (another) something.
JoeS said:
3. At this moment there is a glitch in the spreadsheet which inserts a decimal point into our "Miles" entry; specifically, I entered "20851" and the spreadsheet interpreted this as "20.851".
Like Malm said, it's just a divider, not decimal point, 20.851 still means 20851. It's used for better perception of numbers with many digits after every 3 digits (for example: 1.546.452.647,15 where only last two digits are decimal points. Does your calculated yearly/monthly/daily mileage represent correctly? If yes, everything is OK.