|
Import Asset |
  
|
|
Import Asset |
|
Importing of Asset records will automatically create new Product and Address records that are missing from TOOLMINDER.
The Worksheet name in the Excel spreadsheet must be called Asset.
Mandatory |
Column |
Description |
Example |
|
Product Type |
The type of product
T : Power Tool V : Vehicle H : Hand Tool L : Lifting Equipment P : PPE C : Consumable G : Generic Item |
T |
|
Manufacturer |
Manufacturer of the product |
Makita |
YES |
Model No |
The model number of the product |
8271DWPE |
|
Description |
The description of the product |
12V 10MM COMBI DRILL |
|
Site |
Name of the site where the asset is located |
Head Office |
|
Location |
Location on the site where the asset is located |
Warehouse |
|
Room |
Room the asset is located |
Goods In |
YES |
Asset No |
Number you have assigned to the asset so you can identify it |
IDE-001 |
|
Serial No |
Manufacturer or supplier serial number |
1234/421-1232 |
|
Reg No |
Registration Number of the Vehicle |
|
|
VIN |
Vehicle Identification Number |
|
YES |
Vibration Type |
Type of vibration
HAV : Hand Arm Vibration WBV : Whole Body Vibration
NOTE |
HAV |
|
Source Of Vibration |
Source of the Vibration value |
Manufacturer |
|
Task |
Task being performed during Vibration testing |
Hammer Drilling |
|
Magnitude |
Vibration level in m/sec² |
10.5 |
|
X Axis |
WBV X-Axis |
|
|
Y Axis |
WBV Y-Axis |
|
|
Z Axis |
WBV Z-Axis |
|
|
VDV |
WBV VDV |
|
|
Axis Include Uncertainty |
Include Uncertainty Value K-Factor |
|
|
Consumable |
The consumable fitted during the test |
|
|
Seat Type |
Type of seat |
|
|
Accelerometer Mounting |
The position where the Accelerometer was mounted during the monitoring
HAV T : Trigger Grip H : Single Handle Grip L : Left Grip R : Right Grip S : Support Grip B : Body
WBV Seat Floor |
T |
|
Standard |
The Standard to which the test was performed |
ISO 5349 |
|
Test Date |
Date the Vibration test was performed |
25/12/2011 |
|
Test No |
The unique test number to identify the test |
1234 |
|
Temp No |
A temporary Id number |
9876 |
|
Duration Of Test |
The duration of the test (hh:mm) |
00:15 |
|
Test Engineer |
Name of the engineer who performed the test |
John Smith |
|
Operator |
Name of the operator who used the Tool during the test |
Richard Heart |
|
Noise |
Average Noise in dB(A) monitored during the vibration testing |
82 |
|
Temperature |
The measured temperature while the test was performed in °C |
26 |
|
1 Key |
Name for the key value, free text up to 40 characters |
Colour |
|
1 Value |
Value of the key, free text up to 40 characters |
Blue |
|
2 Key |
|
|
|
2 Value |
|
|
|
3 Key |
|
|
|
3 Value |
|
|
|
4 Key |
|
|
|
4 Value |
|
|
|
5 Key |
|
|
|
5 Value |
|
|
|
6 Key |
|
|
|
6 Value |
|
|
|
7 Key |
|
|
|
7 Value |
|
|
|
8 Key |
|
|
|
8 Value |
|
|
|
9 Key |
|
|
|
9 Value |
|
|
|
10 Key |
|
|
|
10 Value |
|
|