EV Designer

Post Reply
User avatar
jetpax
Posts: 44
Joined: Wed Jan 01, 2020 12:33 am
Has thanked: 13 times
Been thanked: 20 times
Contact:

EV Designer

Post by jetpax »

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)

image.png
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)
“Take the best that exists and make it better”
User avatar
muehlpower
Posts: 654
Joined: Fri Oct 11, 2019 10:51 am
Location: Germany Fürstenfeldbruck
Has thanked: 12 times
Been thanked: 128 times

Re: EV Designer

Post by muehlpower »

jetpax wrote: Fri Jan 03, 2025 4:58 pm Just make a copy of the spreadsheet
How can I make a copy?
User avatar
jetpax
Posts: 44
Joined: Wed Jan 01, 2020 12:33 am
Has thanked: 13 times
Been thanked: 20 times
Contact:

Re: EV Designer

Post by jetpax »

image.png
“Take the best that exists and make it better”
User avatar
muehlpower
Posts: 654
Joined: Fri Oct 11, 2019 10:51 am
Location: Germany Fürstenfeldbruck
Has thanked: 12 times
Been thanked: 128 times

Re: EV Designer

Post by muehlpower »

I don't know google sheets, but the corresponding field is gray and can't be clicked!
Google sheets.png
User avatar
johu
Site Admin
Posts: 6421
Joined: Thu Nov 08, 2018 10:52 pm
Location: Kassel/Germany
Has thanked: 290 times
Been thanked: 1383 times
Contact:

Re: EV Designer

Post by johu »

I guess you need to be logged into google?
Support R/D and forum on Patreon: https://patreon.com/openinverter - Subscribe on odysee: https://odysee.com/@openinverter:9
User avatar
muehlpower
Posts: 654
Joined: Fri Oct 11, 2019 10:51 am
Location: Germany Fürstenfeldbruck
Has thanked: 12 times
Been thanked: 128 times

Re: EV Designer

Post by muehlpower »

I have found another google sheets file on the net. This one I can copy and edit.
Google sheets2.png
User avatar
jetpax
Posts: 44
Joined: Wed Jan 01, 2020 12:33 am
Has thanked: 13 times
Been thanked: 20 times
Contact:

Re: EV Designer

Post by jetpax »

Thanks @muehlpower, I updated the link, let me know if that works for you
“Take the best that exists and make it better”
maboyce
Posts: 9
Joined: Thu Jan 02, 2025 10:37 pm
Has thanked: 19 times
Been thanked: 1 time

Re: EV Designer

Post by maboyce »

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:
Request Access.png
I am signed into my Google account on both devices.
User avatar
jetpax
Posts: 44
Joined: Wed Jan 01, 2020 12:33 am
Has thanked: 13 times
Been thanked: 20 times
Contact:

Re: EV Designer

Post by jetpax »

@maboyce, when you click the link do you get this?
image.png
“Take the best that exists and make it better”
Zieg
Posts: 260
Joined: Mon Apr 25, 2022 3:31 am
Has thanked: 122 times
Been thanked: 105 times

Re: EV Designer

Post by Zieg »

when I click the link I get the same 'you need access' message.
User avatar
jetpax
Posts: 44
Joined: Wed Jan 01, 2020 12:33 am
Has thanked: 13 times
Been thanked: 20 times
Contact:

Re: EV Designer

Post by jetpax »

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...
image.png
“Take the best that exists and make it better”
Zieg
Posts: 260
Joined: Mon Apr 25, 2022 3:31 am
Has thanked: 122 times
Been thanked: 105 times

Re: EV Designer

Post by Zieg »

Works!
User avatar
muehlpower
Posts: 654
Joined: Fri Oct 11, 2019 10:51 am
Location: Germany Fürstenfeldbruck
Has thanked: 12 times
Been thanked: 128 times

Re: EV Designer

Post by muehlpower »

Works!
Zieg
Posts: 260
Joined: Mon Apr 25, 2022 3:31 am
Has thanked: 122 times
Been thanked: 105 times

Re: EV Designer

Post by Zieg »

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. :)
maboyce
Posts: 9
Joined: Thu Jan 02, 2025 10:37 pm
Has thanked: 19 times
Been thanked: 1 time

Re: EV Designer

Post by maboyce »

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.
User avatar
jetpax
Posts: 44
Joined: Wed Jan 01, 2020 12:33 am
Has thanked: 13 times
Been thanked: 20 times
Contact:

Re: EV Designer

Post by jetpax »

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!
“Take the best that exists and make it better”
User avatar
jetpax
Posts: 44
Joined: Wed Jan 01, 2020 12:33 am
Has thanked: 13 times
Been thanked: 20 times
Contact:

Re: EV Designer

Post by jetpax »

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…
“Take the best that exists and make it better”
Post Reply