What Is This Spreadsheet For?
This spreadsheet lets you configure monitoring specifications on assets in TRACTIAN. Use it to define bearing models, gear teeth counts, voltage and current specs, and other technical parameters for motors and rotating equipment. All rows are identified by the Motor Code in the first column.
Can I Import, Export, or Both?
Import (upload data into TRACTIAN): Yes
Export (download data from TRACTIAN): Yes
Column Reference
# | Column Name | What to Fill In | Required? | Accepted Values | Used In |
1 | Motor Code | The unique code that identifies the motor | Yes | Text | Import / Export |
2 | Power | The motor power rating | No | Number | Import / Export |
3 | Power Unit | The unit of measurement for power | No | Dropdown: CV, kW | Import / Export |
4 | Model Bearing 1 | The model or reference of the first bearing | No | Text | Import / Export |
5 | Manufacturer Bearing 1 | The manufacturer of the first bearing | No | Text | Import / Export |
6 | Model Bearing 2 | The model or reference of the second bearing | No | Text | Import / Export |
7 | Manufacturer Bearing 2 | The manufacturer of the second bearing | No | Text | Import / Export |
8 | Model Bearing 3 | The model or reference of the third bearing | No | Text | Import / Export |
9 | Manufacturer Bearing 3 | The manufacturer of the third bearing | No | Text | Import / Export |
10 | Motor Gear Teeth 1 | The number of teeth on the first motor gear | No | Number | Import / Export |
11 | Driven Gear Teeth 1 | The number of teeth on the first driven gear | No | Number | Import / Export |
12 | Motor Gear Teeth 2 | The number of teeth on the second motor gear | No | Number | Import / Export |
13 | Driven Gear Teeth 2 | The number of teeth on the second driven gear | No | Number | Import / Export |
14 | Driven Gear Teeth 3 | The number of teeth on the third driven gear | No | Number | Import / Export |
15 | Motor Gear Teeth 3 | The number of teeth on the third motor gear | No | Number | Import / Export |
16 | Nominal Voltage (V) | The nominal voltage of the motor | No | Dropdown: 208/120, 220/127, 380/220, 400/230, 415/240, 440/260, 480/277 | Import / Export |
17 | Nominal Current (A) | The nominal current of the motor in amperes | No | Number | Import / Export |
18 | Blades Count | The number of blades (for fans or turbines) | No | Number | Import / Export |
19 | Rotor Bar Count | The number of rotor bars | No | Number | Import / Export |
Columns in Detail
Motor Code
The unique code that identifies the motor in your plant. This is the key column — every row must have a Motor Code so the system knows which asset the specifications belong to.
Power
The motor power rating as a numeric value. Use the Power Unit column to indicate whether this value is in CV or kW.
Power Unit
The unit of measurement for the power value. Select from the dropdown: CV (cavalo-vapor) or kW (kilowatt).
Model Bearing 1
The model or reference designation of the first bearing. Use the standard manufacturer designation, such as "6205" or "NU 208".
Manufacturer Bearing 1
The manufacturer of the first bearing. Use the full name, such as "SKF", "FAG", or "Timken".
Model Bearing 2
The model or reference designation of the second bearing, if applicable.
Manufacturer Bearing 2
The manufacturer of the second bearing, if applicable.
Model Bearing 3
The model or reference designation of the third bearing, if applicable.
Manufacturer Bearing 3
The manufacturer of the third bearing, if applicable.
Motor Gear Teeth 1
The number of teeth on the first motor gear. Must be a positive integer.
Driven Gear Teeth 1
The number of teeth on the first driven gear. Must be a positive integer.
Motor Gear Teeth 2
The number of teeth on the second motor gear, if a second transmission stage exists.
Driven Gear Teeth 2
The number of teeth on the second driven gear, if a second transmission stage exists.
Driven Gear Teeth 3
The number of teeth on the third driven gear, if a third transmission stage exists.
Motor Gear Teeth 3
The number of teeth on the third motor gear, if a third transmission stage exists.
Nominal Voltage (V)
The nominal voltage of the motor. Select from the dropdown: 208/120, 220/127, 380/220, 400/230, 415/240, 440/260, or 480/277.
Nominal Current (A)
The nominal current of the motor in amperes. Enter a numeric value.
Blades Count
The number of blades, applicable to fans or turbines. Must be a positive integer.
Rotor Bar Count
The number of rotor bars in the motor. Must be a positive integer. This value is used for broken rotor bar analysis.
Custom Fields
This spreadsheet supports custom fields. You can add additional columns using the following field types: dropdown, number, text, currency, and date.
Tips for a Successful Import
Every row must have a value in the Motor Code column — it is required and identifies which asset receives the specifications.
Numeric columns such as Power, Nominal Current (A), gear teeth counts, Blades Count, and Rotor Bar Count must contain valid numbers. Do not include units in these cells.
For Power Unit, only use values from the dropdown: CV or kW.
For Nominal Voltage (V), only use values from the dropdown: 208/120, 220/127, 380/220, 400/230, 415/240, 440/260, or 480/277.
You do not need to fill in every column. Leave optional columns blank if the specification does not apply to a given motor.
When specifying bearings, provide both the model and the manufacturer for the best results in predictive analysis.
Gear teeth values should be entered in pairs (motor and driven) for each transmission stage.
Example Rows
Motor Code | Power | Power Unit | Model Bearing 1 | Manufacturer Bearing 1 | Nominal Voltage (V) | Nominal Current (A) |
MTR-001 | 10 | CV | 6205 | SKF | 380/220 | 18.5 |
MTR-002 | 75 | kW | NU 322 | FAG | 440/260 | 120 |
MTR-003 | 50 | CV | 6308 | Timken | 220/127 | 85.2 |
Motor Code | Motor Gear Teeth 1 | Driven Gear Teeth 1 | Motor Gear Teeth 2 | Driven Gear Teeth 2 | Blades Count | Rotor Bar Count |
MTR-001 | 20 | 80 | 28 | |||
MTR-002 | 25 | 75 | 18 | 54 | 34 | |
MTR-003 | 6 |
Frequently Asked Questions
What is the Motor Code used for?
The Motor Code is the key identifier for each row. It tells TRACTIAN which asset should receive the monitoring specifications you are defining. Every row must have a Motor Code.
Do I need to fill in all 19 columns?
No. Only the Motor Code is required. Fill in the other columns as needed based on the specifications available for each motor.
What happens if I leave bearing or gear columns blank?
The system will simply not set those specifications for the asset. You can always add them later with another import.
Can I define more than three bearings or three transmission stages?
No. The spreadsheet supports up to three bearings (Model Bearing 1 through 3) and up to three transmission stages (Motor Gear Teeth 1 through 3 and Driven Gear Teeth 1 through 3).
How do the imported specifications affect monitoring?
The specifications feed into TRACTIAN's predictive analysis. Bearing models are used to calculate defect frequencies, gear teeth counts determine mesh frequencies, and voltage/current values establish electrical monitoring baselines.