Spreadsheet: 165303d1341152353-copy-data-from-multiple-worksheet-to-master-worksheet-equipment-maintenance
Sheet: AFT-14

Equipment/Vehicle Details
 | Equipment / Asset Code: |  | AFT-14 |  | Present Location: |  |  |  | A209
 | Description: |  | Air After Cooler |  | Present Status: |  |  |  | Working
 | Category: |  | Machinery |  | Owned / Hired: |  |  |  | Owned
 | Make: |  | Graco |  | Source details (hired): |  |  |  | N/A
 | Model: |  | 2007 |  | Purchased date (dd/mm/yyyy): |  |  |  | 30/06/2008
 | Serial No.: |  | 658741 |  | Purchase value (AED): |  |  |  | 50000
 | Range / Capacity: |  | 13 bar |  | Fuel Type: |  |  |  | N/A
 | Fuel tank capacity: |  | N/A |  | Fuel consumption per litre:
 | User Manual: |  | Manual |  | TPI next due date: |  |  |  | [NAME]
 | Annual Maintenance Cost: |  |  |  | Actual maint. Cost incurred: |  |  |  |  | Display period
 | Worked Days: |  |  |  | Worked hours / kms:
 | Idle hours: |  |  |  | [NAME] hours:
[NAME]
Sch. Code | ISCCO Item Code | [NAME]. Part Code | Service Item | [NAME]. Unit | Frequency | Qty Unit | Qty | Unit Price (AED) | Total Price (AED) | [NAME]. / year | Price/Year (AED)
A |  |  | General Service | Month | 1 | 1 | 1 | 100 |  | 12
B |  |  | Belts | Hours | 1000 | Nos. | 1 | 75 |  | 3
C |  |  | Battery water / Consumables | Hours | 1000 | Nos. | 1 | 50 |  | 3
D |  |  | Third Party Inspection | Month | 6 | Nos. | 1 | 600 |  | 2
E
F
G
H
I
J
K
L |  |  | Others |  |  |  |  | 0 |  | 0
Total
[NAME]
Sch. Code | Date | Inhouse / Third party | Service details | ISCCO Item code | Mfgr. part code | Qty | Unit Price (AED) | Total Price (AED) | Location done | Done by | [NAME] reading (hrs / Km) | Next Service due at | Expected date
F | 2012-06-12 00:00:00 | Inhouse | Air Filter changed |  |  | 2 | 120 |  | A201 | [NAME] | 1254 | 2254 | 2012-09-12 00:00:00
E | 2012-06-20 00:00:00 | Inhouse | General Service |  |  | 1 | 100 |  | A209 | Qassim | 2100 | 2200 | 2012-07-19 00:00:00
Total
Monthly Time sheet |  |  |  |  |  |  |  |  |  | Fuel Log (N/A)
Sl.No | Month - Year | Project / Location | Worked Days | Initial Mtr Reading | Final Mtr Reading | Worked Hours/kms | Idle Hours | Breakdown Hours | Remarks | Month - Year | Consumed litres | Consumption rate | Notes
1 | 2012-01-01 00:00:00 |  | 25 | 1256 | 1258 |  |  | 45 |  | 2012-01-01 00:00:00
2 | 2012-02-01 00:00:00 |  |  |  |  |  |  | 15 |  | 2012-02-01 00:00:00
3 | 2012-03-01 00:00:00 |  |  |  |  |  |  |  |  | 2012-03-01 00:00:00
4 | 2012-04-01 00:00:00 |  |  |  |  |  |  |  |  | 2012-04-01 00:00:00
5 | 2012-05-01 00:00:00 |  |  |  |  |  |  |  |  | 2012-05-01 00:00:00
6 | 2012-06-01 00:00:00 |  |  |  |  |  |  |  |  | 2012-06-01 00:00:00
7 | 2012-07-01 00:00:00 |  |  |  |  |  |  |  |  | 2012-07-01 00:00:00
8 | 2012-08-01 00:00:00 |  |  |  |  |  |  |  |  | 2012-08-01 00:00:00
9 | 2012-09-01 00:00:00 |  |  |  |  |  |  |  |  | 2012-09-01 00:00:00
10 | 2012-10-01 00:00:00 |  |  |  |  |  |  |  |  | 2012-10-01 00:00:00
11 | 2012-11-01 00:00:00 |  |  |  |  |  |  |  |  | 2012-11-01 00:00:00
12 | 2012-12-01 00:00:00 |  |  |  |  |  |  |  |  | 2012-12-01 00:00:00
Total |  |  |  |  |  |  |  |  |  |  |  | N/A
Movement Log
Sl.No | Date | From Location | To Location | LST / Delivery note no. | Transportation means | Reason for movement
1 | 2012-02-01 00:00:00 | A201 | A209 | 4568 | Trailer-5312 | Blasting and Painting activities |  |  |  | Note: Once location changed, update on above  equipment/vehicle details
2 | 2012-04-06 00:00:00 | A209 | I102 | 6547 | Trailer-5312 | breakdown
Third Party Inspection Log (TPI)
Sl.No | Date done | Location Done | TPI name | Certificate No. | Next TPI due | Remarks
1 | 2012-02-01 00:00:00 | A201 | Technical Inspection Bureau | 65464 |  |  |  |  |  | Note: Once TPI done, update the next due date on above equipment/vehicle details
2 | 2012-07-20 00:00:00 | A212 | Bureau veritas | 65465463