{"text_format":"3","workbook":"xls","n_sheets":8,"sheets":["Preliminary and Generals","P1 pump station","P4 Pump station","Central Pump station","P14 Pump station","P12 Pump station","Block 6,7 & 8 Pump station","Summary"],"not_rendered":{"images":8,"external_links":1,"defined_names":2},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Preliminary and Generals","index":0,"n_rows":46,"n_cols":8,"rows_kept":46,"merged":[[0,0,0,5],[1,0,1,5],[2,0,2,5],[43,0,43,4],[44,0,44,5],[45,0,45,5]],"flags":["formulas_cached_only"]}
[]
["Preventetive Maintenance Contract (Electrical works)"]
["Schedule A : (Preliminary and General)"]
[]
["Item","Description","Unit","Qty","Rate","Total"]
[]
["A1","Schedule A (Preliminary and Generals)"]
[]
["A1,1","Contractor contractual requirements","Sum",1]
[{"$nulls":7}," "]
["A1.2","Accomodation"]
[{"$nulls":5}," ",null," "]
["A1.2.1","Six months services (Two times per year)","Sum",1]
[]
["A1.3","Health and safety "]
[]
["A1.3.1","Health and safety plan","Sum",1]
[]
["A1.4","Electrical Compliances"]
[]
["A1.4.1","Issuing of Certificate of Compliance (COC's) per pump station","No",6]
[]
["A1.5","Repairs and Replacements for all pump stations."]
[]
[null,"Hourly rates for repairs and replacing of parts ",{"$nulls":5}," "]
[]
["A1.5.1","Profesional Electrical Engineer/Technologiest","hrs",100]
[]
["A1.5.2","Profesional Electrical Technician","hrs",200]
[]
["A1.5.3","Electrical Artisan ","hrs",200]
[]
["A1.5.4","Labours","hrs",100]
[]
[]
[]
["A1.6","Emergency callout",null," "]
[]
[null,"Maximum of 10 % mark-up fee will be permitted. (This item not be priced)."]
[]
["A1.6","NB: Department of Transport rates shall apply for travelling disbursements. Maximum vehicle capacity of upto 2500cc will be permitted."]
[]
[]
["Sub-Total Electrical Servicing and Adhoc Repairs (Repairs Carried Forward to Summary Page)"]
[]
["PLEASE TRANSFER TOTAL TO PRICE PAGE, SECTION C"]

{"sheet":"P1 pump station","index":1,"n_rows":65,"n_cols":9,"rows_kept":65,"merged":[[0,0,0,5],[1,0,1,5],[2,0,2,5],[64,0,64,4]],"flags":["formulas_cached_only"]}
[]
["Preventetive Maintenance Contract (Electrical works)"]
["Schedule B : (P1 PUMP STATION (ELECTRICAL))"]
[]
["Item","Description","Unit","Qty","Rate","Total"]
[]
["B1","Schedule B (P1 PUMP STATION (ELECTRICAL))"]
[]
[null,"Please note that all electrical works must meet minimum threshold of local content as stipulated by the Department of Trade and Industry.(DTI).",{"$nulls":6}," "]
[]
[null,"Higherand Lower Command Zone"]
[]
["B1,1","Transformers"]
[]
[null,"Full service of 1000 Kva transformer, HV/LV = 22000v -415v, Amperage= 525 - 2782amps, oil quantity = 1426 liters (servicing includes: oil purification, changing gaskets, silica gels "]
[]
["B1.1.1","Six Month Service (Twice per year) (2 Transformers x 2 = 4)","No",4]
[]
["B1.2","Electrical panels"]
[]
[null,"Full service of three phase panels (star/delta). See attached list and picture for details referrence."]
[]
["B1.2.1","Six Months Service (Two times per year) (12 panels x 2 = 24)","No",24]
[]
["B1.3","Electrical motors"]
[]
[null,"Full service of 132kw electric motor. See attached list and picture for  details referrence."]
[]
["B1.3.1","Six Months Service (Two times per year) (7 motors x 2 = 14)","No",14]
[]
[null,"Full service of 110kw electric motor. See attached list and picture for  details referrence."]
[]
["B1.3.2","Six Months Service (Two times per year) (5 motors x 2 = 10)","No",10]
[]
["B1.4","Power factor panels"]
[]
[null,"Full service of power panels . See attached list and picture for referrence."]
[]
["B1.4.1","Six Months Service (Twice per year) (2 panels x 2 = 4)","No",4]
[]
["B1.5","Main incomer breakers"]
[]
[null,"Full service of incomer breaker. See attached list and picture for referrence."]
[]
["B1.5.1","Six Months Service (Twice per year) (3 breakers x 2 = 6)","No",6]
[]
["B1.6","Eletrical overheads lifts"]
[]
[null,"Full service of electric overhead lifts. See attached list and picture for referrence.",{"$nulls":5}," "]
[]
["B1.6.1","Six Months Service (Twice per year) (2 lifts x 2 = 4)","No",4]
[]
["B1.7","Eletrical bus bars"]
[]
[null,"Full service of electric bus bars (cleaning). See attached list and picture for referrence."]
[]
["B1.7.1","Six Months Service (Twice per year) (2 sections x 2 = 4)","No",4]
[]
["B1.8","Eletrical lights"]
[]
[null,"Full service of electric lightings (bulbs, . See attached list and picture for referrence."]
[]
["B1.8.1","Six Months Service (Twice per year) (24 lights x 2 = 48)","No",48]
[]
["Sub-Total Electrical Servicing and Adhoc Repairs (Repairs Carried Forward to Summary Page)"]

{"sheet":"P4 Pump station","index":2,"n_rows":65,"n_cols":6,"rows_kept":65,"merged":[[0,0,0,5],[1,0,1,5],[2,0,2,5],[64,0,64,4]],"flags":["formulas_cached_only"]}
[]
["Preventetive Maintenance Contract (Electrical works)"]
["Schedule C : (P4 PUMP STATION (ELECTRICAL))"]
[]
["Item","Description","Unit","Qty","Rate","Total"]
[]
["C1","Schedule C (P4 PUMP STATION (ELECTRICAL))"]
[]
[null,"Please note that all electrical works must meet minimum threshold of local content as stipulated by the Department of Trade and Industry.(DTI)."]
[]
[null,"Higherand Lower Command Zone"]
[]
["C1,1","Transformers"]
[]
[null,"Full service of 1250 Kva transformer, HV/LV = 22000v -415v, Amperage= 525 - 2782amps, oil quantity = 1426 liters (servicing includes: oil purification, changing gaskets, silica gels. "]
[]
["C1.1.1","Six Months Service (Twice per year) (2 Transformers x 2 = 4)","No",4]
[]
["C1.2","Electrical panels"]
[]
[null,"Full service of three phase panels (star/delta). See attached list and picture for details referrence."]
[]
["C1.2.1","Six Months Service (Two times per year) (12 panels x 2 = 24)","No",24]
[]
["C1.3","Electrical motors"]
[]
[null,"Full service of 300kw electric motor. See attached list and picture for  details referrence."]
[]
["C1.3.1","Six Months Service (Two times per year) (8 motors x 2 = 16)","No",16]
[]
[null,"Full service of 30kw electric motor. See attached list and picture for  details referrence."]
[]
["C1.3.2","Six Months Service (Two times per year) (4 motors x 2 = 8)","No",8]
[]
["C1.4","Power factor panels"]
[]
[null,"Full service of power panels . See attached list and picture for referrence."]
[]
["C1.4.1","Six Months Service (Twice per year) (2 panels x 2 = 4)","No",4]
[]
["C1.5","Main incomer breakers"]
[]
[null,"Full service of incomer breaker. See attached list and picture for referrence."]
[]
["C1.5.1","Six Months Service (Twice per year) (3 breakers x 2 = 6)","No",6]
[]
["C1.6","Eletrical overheads lifts"]
[]
[null,"Full service of electric overhead lifts. See attached list and picture for referrence."]
[]
["C1.6.1","Six Months Service (Twice per year) (2 lifts x 2 = 4)","No",4]
[]
["C1.7","Eletrical bus bars"]
[]
[null,"Full service of electric bus bars (cleaning). See attached list and picture for referrence."]
[]
["C1.7.1","Six Months Service (Twice per year) (2 sections x 2 = 4)","No",4]
[]
["C1.8","Eletrical lights"]
[]
[null,"Full service of electric lightings (bulbs, . See attached list and picture for referrence."]
[]
["C1.8.1","Six Months Service (Twice per year) (24 lights x 2 = 48)","No",48]
[]
["Sub-Total Electrical Servicing and Adhoc Repairs (Repairs Carried Forward to Summary Page)"]

{"sheet":"Central Pump station","index":3,"n_rows":65,"n_cols":6,"rows_kept":65,"merged":[[0,0,0,5],[1,0,1,5],[2,0,2,5],[64,0,64,4]],"flags":["formulas_cached_only"]}
[]
["Preventetive Maintenance Contract (Electrical works)"]
["Schedule D : (CENTRAL PUMP STATION (ELECTRICAL))"]
[]
["Item","Description","Unit","Qty","Rate","Total"]
[]
["D1","Schedule D (CENTRAL PUMP STATION (ELECTRICAL))"]
[]
[null,"Please note that all electrical works must meet minimum threshold of local content as stipulated by the Department of Trade and Industry.(DTI)."]
[]
[null,"Higherand Lower Command Zone"]
[]
["D1,1","Transformers"]
[]
[null,"Full service of 2000 Kva transformer, HV/LV = 22000v -415v, Amperage= 525 - 2782amps, oil quantity = 1426 liters (servicing includes: oil purification, changing gaskets, silica gels "]
[]
["D1.1.1","Six Months Service (Twice per year) ( 1 Transformers x 2 = 2)","No",2]
[]
["D1.2","Electrical panels"]
[]
[null,"Full service of three phase panels (star/delta). See attached list and picture for details referrence."]
[]
["D1.2.1","Six Months Service (Two times per year) (12 panels x 2 = 24)","No",24]
[]
["D1.3","Electrical motor"]
[]
[null,"Full service of 185kw electric motor. See attached list and picture for  details referrence."]
[]
["D1.3.1","Six Months Service (Two times per year) (6 motors x 2 = 12)","No",12]
[]
[null,"Full service of 110kw electric motor. See attached list and picture for  details referrence."]
[]
["D1.3.2","Six Months Service (Two times per year) (6 motors x 4 = 24)","No",12]
[]
["D1.4","Capacitors panels"]
[]
[null,"Full service of capacitors panels. See attached list and picture for referrence."]
[]
["D1.4.1","Six Months Service (Twice per year) (2 panels x 2 = 4)","No",4]
[]
["D1.5","Main incomer breakers"]
[]
[null,"Full service of incomer breaker. See attached list and picture for referrence."]
[]
["D1.5.1","Six Months Service (Twice per year) (3 breakers x 2 = 6)","No",6]
[]
["D1.6","Eletrical overheads lifts"]
[]
[null,"Full service of electric overhead lifts. See attached list and picture for referrence."]
[]
["D1.6.1","Six Months Service (Twice per year) (2 lifts x 2 = 4)","No",4]
[]
["D1.7","Eletrical bus bars"]
[]
[null,"Full service of electric bus bars (cleaning). See attached list and picture for referrence."]
[]
["D1.7.1","Six Months Service (Twice per year) (2 sections x 2 = 4)","No",4]
[]
["D1.8","Eletrical lights"]
[]
[null,"Full service of electric lightings (bulbs, . See attached list and picture for referrence."]
[]
["D1.8.1","Six Months Service (Twice per year) (24 lights x 2 = 48)","No",48]
[]
["Sub-Total Electrical Servicing and Adhoc Repairs (Repairs Carried Forward to Summary Page)"]

{"sheet":"P14 Pump station","index":4,"n_rows":51,"n_cols":6,"rows_kept":51,"merged":[[0,0,0,5],[1,0,1,5],[2,0,2,5],[50,0,50,4]],"flags":["formulas_cached_only"]}
[]
["Preventetive Maintenance Contract (Electrical works)"]
["Schedule E : (P14 PUMP STATION (ELECTRICAL))"]
[]
["Item","Description","Unit","Qty","Rate","Total"]
[]
["E1","Schedule E (P14 PUMP STATION (ELECTRICAL))"]
[]
[null,"Please note that all electrical works must meet minimum threshold of local content as stipulated by the Department of Trade and Industry.(DTI)."]
[]
["E1.2","Electrical panels"]
[]
[null,"Full service of three phase panels (star/delta). See attached list and picture for details referrence."]
[]
["E1.2.1","Six Months Service (Two times per year) (7 panels x 2 = 14)","No",14]
[]
["E1.3","Electrical motor"]
[]
[null,"Full service of 75kw electric motor. See attached list and picture for  details referrence."]
[]
["E1.3.1","Six Months Service (Two times per year) (5 motors x 2 = 10)","No",10]
[]
[null,"Full service of 37kw electric motor. See attached list and picture for  details referrence."]
[]
["E1.3.2","Six Months Service (Two times per year) (2 motors x 2 = 4)","No",4]
[]
["E1.5","Main incomer breakers"]
[]
[null,"Full service of incomer breaker. See attached list and picture for referrence."]
[]
["E1.5.1","Six Months Service (Twice per year) (1 breakers x 2 = 2)","No",2]
[]
["E1.6","Eletrical overheads lifts"]
[]
[null,"Full service of electric overhead lifts. See attached list and picture for referrence."]
[]
["E1.6.1","Six Months Service (Twice per year) (1 lifts x 2 = 2)","No",2]
[]
["E1.7","Eletrical bus bars"]
[]
[null,"Full service of electric bus bars (cleaning). See attached list and picture for referrence."]
[]
["E1.7.1","Six Months Service (Twice per year) (1 sections x 2 = 2)","No",2]
[]
["E1.8","Eletrical lights"]
[]
[null,"Full service of electric lightings (bulbs, . See attached list and picture for referrence."]
[]
["E1.8.1","Six Months Service (Twice per year) (18 lights x 2 = 36)","No",36]
[]
["Sub-Total Electrical Servicing and Adhoc Repairs (Repairs Carried Forward to Summary Page)"]

{"sheet":"P12 Pump station","index":5,"n_rows":41,"n_cols":6,"rows_kept":41,"merged":[[0,0,0,5],[1,0,1,5],[2,0,2,5],[40,0,40,4]],"flags":["formulas_cached_only"]}
[]
["Preventetive Maintenance Contract (Electrical works)"]
["Schedule F : (P12 PUMP STATION (ELECTRICAL))"]
[]
["Item","Description","Unit","Qty","Rate","Total"]
[]
["F1","Schedule F (P2 PUMP STATION (ELECTRICAL))"]
[]
[null,"Please note that all electrical works must meet minimum threshold of local content as stipulated by the Department of Trade and Industry.(DTI)."]
[]
["F1.2","Electrical panels"]
[]
[null,"Full service of three phase panels (star/delta). See attached list and picture for details referrence."]
[]
["F1.2.1","Six Months Service (Two times per year) (3 panels x 2 = 6)","No",6]
[]
["F1.3","Electrical motor"]
[]
[null,"Full service of 30kw electric motor. See attached list and picture for  details referrence."]
[]
["F1.3.1","Six Months Service (Two times per year) (3 motors x 2 = 6)","No",6]
[]
["F1.5","Main incomer breakers"]
[]
[null,"Full service of incomer breaker. See attached list and picture for referrence."]
[]
["F1.5.1","Six Months Service (Twice per year) (1 breakers x 2 = 2)","No",2]
[]
["F1.7","Eletrical bus bars"]
[]
[null,"Full service of electric bus bars (cleaning). See attached list and picture for referrence."]
[]
["F1.7.1","Six Months Service (Twice per year) (1 sections x 2 = 2)","No",2]
[]
["F1.8","Electrical lights"]
[]
[null,"Full service of electric lightings (bulbs, . See attached list and picture for referrence."]
[]
["F1.8.1","Six Months Service (Twice per year) (6 lights x 2 =12)","No",12]
[]
["Sub-Total Electrical Servicing and Adhoc Repairs (Repairs Carried Forward to Summary Page)"]

{"sheet":"Block 6,7 & 8 Pump station","index":6,"n_rows":69,"n_cols":6,"rows_kept":69,"merged":[[0,0,0,5],[1,0,1,5],[2,0,2,5],[68,0,68,4]],"flags":["formulas_cached_only"]}
[]
["Preventetive Maintenance Contract (Electrical works)"]
["Schedule F : (BLOCK 6,7 & 8 PUMP STATION (ELECTRICAL))"]
[]
["Item","Description","Unit","Qty","Rate","Total"]
[]
["G1","Schedule F (BLOCK 6,7 & 8 PUMP STATION (ELECTRICAL))"]
[]
[null,"Please note that all electrical works must meet minimum threshold of local content as stipulated by the Department of Trade and Industry.(DTI)."]
[]
[null,"Block 6, 7 & 8."]
[]
["G1,1","Transformers"]
[]
[null,"Full service of 500 Kva transformer, HV/LV = 22000v -415v, Amperage= 525 - 2782amps, oil quantity = 1426 liters (servicing includes: oil purification, changing gaskets, silica gels "]
[]
["G1.1.1","Six Months Service (Twice per year) (2 Transformers x 2 = 4)","No",4]
[]
["G1.2","Electrical panels"]
[]
[null,"Full service of three phase panels (star/delta). See attached list and picture for details referrence."]
[]
["G1.2.1","Six Months Service (Two times per year) (10 panels x 2 = 20)","No",20]
[]
["G1.3","Electrical motor"]
[]
[null,"Full service of 75kw electric motor. See attached list and picture for  details referrence."]
[]
["G1.3.1","Two Months Service (Two times per year) (6 motors x 2 = 12)","No",12]
[]
[null,"Full service of 55kw electric motor. See attached list and picture for  details referrence."]
[]
["G1.3.2","Two Months Service (Two times per year) (6 motors x 2 = 12)","No",24]
[]
[null,"Full service of 45kw electric motor. See attached list and picture for  details referrence."]
[]
["G1.3.2","Six Months Service (Two times per year) (6 motors x 2 = 12)","No",12]
[]
[null,"Full service of 37kw electric motor. See attached list and picture for  details referrence."]
[]
["G1.3.2","Six Months Service (Two times per year) (6 motors x 2 = 12)","No",12]
[]
[null,"Full service of 18.5kw electric motor. See attached list and picture for  details referrence."]
[]
["G1.3.2","Six Months Service (Two times per year) (6 motors x 2 = 12)","No",12]
[]
[null,"Full service of 11kw electric motor. See attached list and picture for  details referrence."]
[]
["G1.3.2","Six Months Service (Two times per year) (6 motors x 2 = 12)","No",12]
[]
["G1.5","Main incomer breakers"]
[]
[null,"Full service of incomer breaker. See attached list and picture for referrence."]
[]
["G1.5.1","Six Months Service (Twice per year) (9 breakers x 2 = 18)","No",18]
[]
["G1.7","Eletrical bus bars"]
[]
[null,"Full service of electric bus bars (cleaning). See attached list and picture for referrence."]
[]
["G1.7.1","Six Months Service (Twice per year) (4 sections x 2 = 8)","No",8]
[]
["G1.8","Eletrical lights"]
[]
[null,"Full service of electric lightings (bulbs, . See attached list and picture for referrence."]
[]
["G1.8.1","Six Months Service (Twice per year) (20 lights x 2 = 40)","No",40]
[]
["Sub-Total Electrical Servicing and Adhoc Repairs (Repairs Carried Forward to Summary Page)"]

{"sheet":"Summary","index":7,"n_rows":29,"n_cols":3,"rows_kept":29,"merged":[[0,0,0,2],[1,0,1,2],[2,0,2,2]],"flags":["formulas_cached_only"]}
[]
["Preventetive Maintenance Contract (Electrical works)"]
["Summary Schedule"]
[]
["Item","Description","Amounts"]
[]
[1,"Schedule A (Preliminary and Generals)"]
[]
[2,"Schedule B (P1 Pump Station)"]
[]
[3,"Schedule C (P4 Pump Station)"]
[]
[4,"Schedule D (Central Pump Station)"]
[]
[5,"Schedule E (P14 Pump Station)"]
[]
[6,"Schedule F (P12 Pump Station)"]
[]
[7,"Schedule G (Block 6,7 & 8  Pump Station)"]
[]
[8,"Sub-total 1"]
[]
[9,"5% Contigancies"]
[]
[10,"Sub-total 2"]
[]
[11,"VAT"]
[]
[12,"FINAL TOTAL"]