 Introduction
The Team Tornado Motors Spreadsheet is a tool that allows you to calculate the performance of a chosen motor when run with a certain gear ratio and at a particular voltage. We wrote the spreadsheet when we were first designing Tornado, in order to assist our motor choice.

 Motors Spreadsheet v2.4 in Excel 5.0 format - 32kb Worked Example This webpage - as below - 37kb
Worked example
Just to give an idea of what the spreadsheet can do, we're going to set up the Bosch motor that most people use - the GPA 24V 750W. Remember the maths in the spreadsheet assume the motor is working to it's maximum, i.e. at full load. Open the Spreadsheet. If you've just downloaded it, you'll need to unzip it first, and when you open it, it'll start at the Instructions sheet. Read them if you want, but I'll leave that to you.  Go to the Input Data sheet.  Firstly, lets choose the motor we want to use. The motor data is kept in a table below the input fields; find the data for the GPA 24V 750W, highlight it, and copy it (see Figure 1). Highlight the motor input field (green in Figure 1), and paste the data (the spreadsheet starts with a Tamiya RC motor). Figure 1 - Choosing your motor  Next, lets set up the constants we want to use. The desired top speed determines the gear ratio in the motor input field; if the gear ratio is fixed (i.e. the motor has a gearbox on it, like a wheelchair motor) then this is included in the motor data - there's a wheelchair motor and gearbox fixed at 32:1 in the table of data. As we're using a Bosch, lets set the Top Speed to 10mph, the Battery Voltage to 24V, and the Wheel Diameter to 10 inches (i.e. a go-kart tyre). Leave the efficiency factors at 1 - these are included to allow an approximation for friction, and you would set them to about 0.8-0.9 if you wanted to include the approximation. For the moment also we'll leave the Current Limit at 1000 amps - thats a higher current than the motor will ever pull at 24V, so we can consider there to be no current limit. Note that as you change some of these constants, the gear ratio shown in the motor input field (green in Figure 1) changes - this gear ratio is what you need to use for your chosen motor and wheel size. If it's way low a ratio to sensibly build, then you might have to reduce your wheel size or increase your desired top speed. Figure 2 - Setting Up Constants  Let's take a look at the RPM graph (Figure 3) - go to the RPM sheet. The graph shows a variety of different parameters, and the legend shows which vertical axis they are plotted on - [R]ight or [L]eft. The horizontal axis shows RPM of the motor, running from zero up to the motors maximum of 4200. Figure 3 - RPM Performance with no current limit  What do these curves show? Let's look at each in detail.
Motor Current and Battery Current (amps)
Because there is no current limit, the motor current and battery current are the same. The current varies linearly from the maximum at zero rpm (when the motor is stalled), to the minimum at maximum speed (no load). It never reaches zero, because all motors have losses in the bearings etc, and these require power to overcome.
Power Input (watts)
This is simply the input current multiplied by the applied voltage (which is a constant 24V) - therfore as expected it's shape follows the current curve. Here the power input at stall is a massive 4400W, well above the motor's 750W rating!
Wheel Torque (newton-metres)
As torque is proportional to motor current, again this tracks the current curves; it is maximum at stall (0 rpm) and minimum at off load (4200rpm). The torque here is the torque at the wheel, i.e. multiplied through the gear ratio shown in the motor input field (green in Figure 1). It gives a good idea of how much pushing/acceleration force each motor will contribute. Power Output (watts)
The power output of the motor is torque times speed - two quantities that are changing in opposite directions - as speed goes up, torque goes down. This is why the peak power output is always at half of maximum RPM (provided there is no current limit). It can be seen that the peak power output is considerably more than 750W - actually more like 1200W, that's 1.2kW. Note that the curve is always less than the power input, and the difference between the two is the wasted power - heat!
Percentage Efficiency (percent)
This is simply power output divided by power input. There's always power lost as heat in the windings, it's unavoidable. The more efficient a motor is, the longer your batteries will last and everything won't get as hot! It's always zero at stall and max rpm.
Pushing Efficiency (newton-metres per amp)
This is a fairly arbitrary curve, and only should be used to compare motors (setup using the same target speed and wheel size) when the choice between them is getting difficult. It's a measure of the torque produced by the motor for the current taken from the batteries - similar to the torque constant of the motor (one of the fundamental parameters that define a motor), but this takes into account the gear ratio, and any current limiting if present.  Current limit will change all this however. Go back to the Input Data sheet, and change the Current Limit down to 70amps - realistic for say the popular 4QD NCC70 controller. Look at the graph again on the RPM sheet (Figure 4) - it's changed dramatically! Figure 4 - RPM Performance with 70 amp current limit  So what has changed?
Motor Current
This curve follows the battery current when the rpm is high enough that the current limit is not operating. But because of the current limit, it cannot rise above the current limit that has been set. Thus for a substantial chunk of the rpm range of the motor, it will operate in current limit. (But remember - the motor is only going to be in current limiting if it is fully loaded!)
Battery Current (amps)
You would expect this to be the same as the motor current - but while the current limit is operating, it is not. All PWM speed controllers that have current limiting operate in an efficient way that minimises power losses, called "switch mode" operation. You might find this quite a hard concept to understand - for this worked example, please just accept that it is correct!
Power Input (watts)
As before this is the input (battery) current multiplied by the applied voltage - but because the battery current drops at low rpm, the input power drops too, here to about 650W. This characteristic is what makes it much harder to burn out a stalled motor when you have a current limit. The peak power input is also much lower than before, it's only about 1700W - and look where it appears, at the same rpm as the maximum output power, and the same point that the motor comes out of current limit. It's not a coincidence!
Wheel Torque (newton-metres)
As torque is proportional to motor current, this tracks the motor current curve as before; it has a flat maximum at all speeds that the motor is in current limit. The maximum has dropped from that without the current limit; thus it can be said that the current limit directly affects the wheel torque.
Power Output (watts)
The power output of the motor is still torque times speed - but as the torque is lower (and constant) through most of the rpm range (while in current limit), the trace is linear rather than curved. The peak power output is still a relatively high 1100W, but it's no longer at half rpm. The most interesting comparison is the difference between power input and output - in this case it's never more than about 700W, and that's a huge difference to the unlimited case.
Percentage Efficiency (percent)
The current limit has helped to skew the efficiency - it's better at low rpm than it was before. It's the same observation as the relative difference between the input and output powers - less power is being wasted as heat.
Pushing Efficiency (newton-metres per amp)
This shows one of the real merits of current limiting - the pushing efficiency is greater while in current limit, because the battery current is dramtically lower. But it doesn't mean that this option will make the robot using it able to push more - the reduction in wheel torque is more important in this respect.  There's one final thing that the spreadsheet can show you. Have a look at the Calcs sheet, where all the data used in the graphs is stored. If you really want to know exactly what the maximum power output of your motor is (for instance), look for the maximum value in the power output graph. In the current limited case above, it's at 2688rpm, and is 1114W.

Choosing a motor using the Spreadsheet
If you follow these few steps, the spreadsheet should help you decide which motor is the best for your machine. Run through the worked example above to get a hang of how the spreadsheet works first.  Decide on a target top speed. Don't aim for too high a speed, as your robot will not get to full speed in the limited space of the arena, you will always be operating in the less efficient rpm range of the motor, and you are likely to stall your motors easily and burn them out if your gear ratio is too high.  Decide on a wheel size. Your design will probably dictate this. Smaller is lighter, but larger and wider will give more grip.  Decide on a battery supply voltage. This will depend on what speed controllers are available to you, and what voltage your chosen motor will happily run at.  Try different motors under the same target conditions - it may help to have two copies of the spreadsheet open at once, so you can switch between them. Remember to put in the current limit of the speed controllers you will use with that motor as well, as these make a big difference.

| Home || Build Diary || Official Merchandise || Site Map || E-Mail |