This is really cool, thanks to everyone who has put so much work into it!
Had built up something pretty similar years ago using the equations from Bob Brant's EV book, lots of fun to play with
I don't know if its ever been discussed, but I think something that would make this an even more powerful tool particularly for new comers is to start building up a database of standard components. I always liked how this old EV calculator had a bunch of common vehicle, battery, motor and controller choices built in to use as a starting point.
Its great to be able to manipulate the numbers by hand, but IMHO coming up with reliable/realistic inputs is one of the trickiest parts of this kind of modeling. Since a lot of folks will likely be using various combinations of the same handful of components, it would be awesome if every user didn't have to scrounge up the same numbers from the internet and re-invent the inputs at least for the most common components!
Looking forward to spending some "quality time" with this spreadsheet
Link is broken again (not sure for how long). You can still get it on my site, but would be nice to have it somewhere more permanent.