Spreadsheet: 165303d1341152353-copy-data-from-multiple-worksheet-to-master-worksheet-equipment-maintenance
Sheet: DG-01

Equipment/Vehicle Details
 | Equipment / Asset Code: |  | DG-01 |  | Present Location: |  |  |  | I102
 | Description: |  | Diesel Generator |  | Present Status: |  |  |  | Working
 | Category: |  | Machinery |  | Owned / Hired: |  |  |  | Owned
 | Make: |  |  |  | Source details (hired): |  |  |  | N/A
 | Model: |  |  |  | Purchased date (dd/mm/yyyy): |  |  |  | 2010-05-12 00:00:00
 | Serial No.: |  | 6546646 |  | Purchase value (AED): |  |  |  | 60000
 | Range / Capacity: |  |  |  | Fuel Type |  |  |  | Diesel
 | Fuel tank capacity |  | 100 |  | Fuel consumption per litre
 | User Manual |  | Manual |  | TPI next due date |  |  |  | 30/09/2012
 | 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 |  |  | Oil Filter | Hours | 250 | Nos. | 1 | 18 |  | 12
B |  |  | Primary Fuel Filter | Hours | 250 | Nos. | 1 | 45 |  | 12
C |  |  | Secondary Fuel Filter | Hours | 250 | Nos. |  |  |  | 12
D |  |  | [NAME] | Hours | 250 | Litres |  |  |  | 12
E |  |  | General Service | Month | 1 | 1 | 1 | 100 |  | 12
F |  |  | Air Filter | Hours | 1000 | Nos. |  |  |  | 3
G |  |  | Belts | Hours | 1000 | Nos. | 1 | 75 |  | 3
H |  |  | Battery water / Consumables | Hours | 1000 | Nos. | 1 | 50 |  | 3
I |  |  | Hydraulic Oil | Hours | 1000 | Litres |  |  |  | 3
J |  |  | Hydraulic Oil Filter | Hours | 1000 | Nos. |  |  |  | 3
K |  |  | Third Party Inspection | Month | 6 | Nos. | 1 | 600 |  | 2
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 | [NAME] | General Service |  |  | 1 | 100 |  | I102 | TPI | 1650 | 1750 | 2012-07-19 00:00:00
Total
Monthly Time sheet |  |  |  |  |  |  |  |  |  | Fuel Log
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 | A201 | 26 | 1235 | 1310 |  |  | 45 |  | 2012-01-01 00:00:00 | 500
2 | 2012-02-01 00:00:00 | A201 | 26 | 1310 | 1450 |  |  | 15 |  | 2012-02-01 00:00:00 | 600
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
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