paper: Hill Drivetrain Simulator

[page2067]

Thanks for posting this.
I think it is the best version of a motor simulation spreadsheet I have seen.

But one question: Why is "F2A2" set at 2x "F2A" - it leads to the second gear calculations (performance calcs 2) to show double the amperage? even for the same gear ratio.

[Michael Hill]

I'm not near a computer at the moment (and won't until tomorrow). I'll check it out when I can get to one.

[Michael Hill]

Originally Posted by page2067

Thanks for posting this.
I think it is the best version of a motor simulation spreadsheet I have seen.

But one question: Why is "F2A2" set at 2x "F2A" - it leads to the second gear calculations (performance calcs 2) to show double the amperage? even for the same gear ratio.

So, I'm not seeing which cell you're referring to. I just downloaded the version I uploaded, and this is what i have in the second tab ("Unit Conversions"), and things seem to be correct.



I made the gear ratios the same (7.0) and these are the plots:

http://i.imgur.com/rp8XQvm.png

[page2067]

So that's odd.

The version I pulled had F2A at 0.0752 and F2A2 at 0.1504 it also has TM at 1.623

Thanks for clearing up.

[Michael Hill]

Originally Posted by page2067

So that's odd.

The version I pulled had F2A at 0.0752 and F2A2 at 0.1504 it also has TM at 1.623

Thanks for clearing up.

Well, F2A and F2A2 are functions of the respective gear ratios. It's possible the gear ratios were such that that one was 2x the other?

[Michael Hill]

Just put up an updated version. This version adds the ability to select individual motors (assumes right and left are same). I've also included a Combined Motor Curve chart. The combined motor calculations are based on Paul Copioli's spreadsheet available at http://www.fightingpi.org/Resources/...culations.xlsm