Hey y’all over the summer I created a set of three spreadsheets just to see if I could. The first spreadsheet (Shooter Calculator) uses the motor curve data and such to fairly accurately calculate things like:

- Spin up time
- Highest possible feed speed
- Shot accuracy as balls are being fired and rpm varies
- etc.

The second spreadsheet is a drivetrain calculator that given a motor curve and such can calculate:

- Ideal Gearbox Ratio for a given sprint distance
- Top speed
- Time to get to top speed
- Time per one way sprint

The third and last spreadsheet attempts to solve a problem I noticed mentoring last year with making design calculators. The only easily accessible and public motor curve tables is the one for the Falcon 500. I created a calculator that given some basic and usually public information it can calculate:

- The Brushed DC motor curve data
- The Brushless DC motor curve data

The beauty of this third spreadsheet is the motor curve data can then be plugged into other spreadsheets that use motor curves (like my first two).

I have crosschecked all of these spreadsheets with the team I mentored this past year and they seem to check out but I would like some second opinions to find bugs.

Drivetrain Calculator.xlsx (4.2 MB) Motor Curve Calculator.xlsx (93.0 KB) Shooter Calculator.xlsx (621.8 KB)