openinverter forum

Any EV conversion is a LOT of work. A LOT.

Especially if you are trying to convert a vehicle that has not been converted by the community before.

So a conversion makes more sense as the value of the donor vehicle (either monetary or sentimental) goes up.

But, will the final results of your labour of love be all unicorns and rainbows, or a disappointing and valueless waste of time?

EV Designer is a fairly accurate physics model I created a while back that allows you to experiment on different drivetrain ideas before you buy, cut and hack.

Click the link to make a copy of the spreadsheet, then fill in your parameters in the grey colored cells (you can select MPH or km/h in the pink cell)

It tracks acceleration, max speed and range within a few tenths of a second/MPH with real world vehicles, eg Tesla Model S, 3 etc,

Don't forget to check the Cruise Performance estimate, especially if you live in a hilly part of the world. A lot of people forget that one (see FIGURE 2.9. An accelerating car on inclined pavement).
(I also added a lot of information in subsidiary sheets, so check those out too)

jetpax wrote: ↑Fri Jan 03, 2025 4:58 pm Just make a copy of the spreadsheet

How can I make a copy?

I don't know google sheets, but the corresponding field is gray and can't be clicked!

I guess you need to be logged into google?

I have found another google sheets file on the net. This one I can copy and edit.

Thanks @muehlpower, I updated the link, let me know if that works for you

Thank you for your work on this! Interestingly, I can view the spreadsheet on mobile, but like muehlpower 'Make a Copy' is greyed out. On desktop, I get this:
I am signed into my Google account on both devices.

@maboyce, when you click the link do you get this?

when I click the link I get the same 'you need access' message.

OK, so I think I've finally got it sorted.

I wanted to allow copies, but not let anyone change my original.
Turns out there is an advanced sharing option that allows people with view only access to make a copy, which is off by default...

Works!

Works!

So, putting in my known values the acceleration profile seems pretty close to what I had previously calculated and proven through testing (though I did use peak cell voltage and under load there is some sag). The range estimate seems low by about 20% though. Is that range estimated while travelling up the max grade, or on flat ground at cruising speed?

Also I like that the acceleration performance table has switchable units, would it be possible to implement that for the graph and range/max speed dials as well? Asking as a Canadian.

I now get the 'copy document' screen, and have successfully made a copy! Thank you for getting it sorted for us.

Apps Script gives me nostalgia. I wrote a bunch of it for work years ago to generate documents and such. We'll be moving away from Google Workspace within months, so it will all go away or have to be redone as Office extensions.

Zieg wrote: ↑Sat Jan 04, 2025 10:18 pm So, putting in my known values the acceleration profile seems pretty close to what I had previously calculated and proven through testing (though I did use peak cell voltage and under load there is some sag). The range estimate seems low by about 20% though. Is that range estimated while travelling up the max grade, or on flat ground at cruising speed?

Also I like that the acceleration performance table has switchable units, would it be possible to implement that for the graph and range/max speed dials as well? Asking as a Canadian.

The range is based on the cruising speed that you select, on level ground.

As I recall, the graph does not allow that, but if you find a way let me know!

maboyce wrote: ↑Sat Jan 04, 2025 11:08 pm I now get the 'copy document' screen, and have successfully made a copy! Thank you for getting it sorted for us.

Apps Script gives me nostalgia. I wrote a bunch of it for work years ago to generate documents and such. We'll be moving away from Google Workspace within months, so it will all go away or have to be redone as Office extensions.

From memory, I only used the apps script for loading profiles, the actual model just uses regular excel like expressions, so if you are a Microsoft fan (who am I to judge ) you could likely create this in Excel

Not sure how the dials would be implemented though…