Unlike almost all the other manufacturers, Tesla isn't using history and guessing range based on it for the instrument panel display. The only history based estimate you get on a Tesla is the average of last xx miles one in the center console energy app.
Instead, the Tesla instrument panel offers two choices that are both based on a fixed watt hour per mile number (though different numbers in different car models.) Ideal is some best case scenario, Rated is supposed to match EPA rated range/test cycle.
There is still estimation error, because as you said, the car has to use an alogorithm to guess the chemical state of the battery most of the time due to the flat voltage curve of lithium creeks and the effects of pushing power in and out of the pack on voltage, but it should be a much smaller factor.
@Saghost and @Shaggy
I'm beginning to think that unless you have access to the actual BMS data, you can't trust what the car is telling you
I have someone helping me with pivot tables, will that work?Not sure how you are processing, but for big data sets I change the CSV into binary and use Python+matplotlib for graphing. Runs faster, especially on loading.