{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["SUMMARY","Full BOQ DUVHA","FULL CAMDEN BELT REPAIRS","FULL MEDUPI BELT REPAIRS "],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"SUMMARY","index":0,"n_rows":5,"n_cols":2,"rows_kept":5}
[]
[]
[null,"CAMDEN BELT REPAIRS TOTAL EXCL. VAT FOR 3 YEARS "]
[null,"DUVHA BELT REPAIRS TOTAL EXCL. VAT FOR 3 YEARS "]
[null,"MEDUPI BELT REPAIRS TOTAL EXCL. VAT FOR 3 YEARS"]

{"sheet":"Full BOQ DUVHA","index":1,"n_rows":108,"n_cols":12,"rows_kept":108,"merged":[[2,1,2,11],[4,1,11,1],[12,1,20,1],[21,1,25,1],[26,1,30,1],[31,1,38,1],[39,1,43,1],[44,1,50,1],[51,7,51,10],[55,2,55,11],[56,5,56,7],[56,8,56,9],[57,5,57,7],[57,8,57,9],[58,2,58,10],[60,7,60,10],[63,1,63,7],[65,1,65,7],[68,4,68,6],[75,4,75,6],[78,1,78,7],[80,1,80,7],[82,4,82,6],[85,1,85,8],[87,1,87,8],[89,5,89,7],[92,1,92,7],[94,1,94,7],[96,4,96,6],[97,1,97,6],[100,6,100,7],[101,6,101,7],[102,6,102,7],[103,6,103,7],[104,6,104,7],[105,6,105,7],[106,6,106,7],[107,6,107,7]]}
[{"$nulls":3},"DUVHA POWER STATION  - LAGGING + SKIRTING "]
[]
[null,"LAGGING"]
["Item No. ","Belt","Pulley","Diameter [mm]","Face width [mm]","Surface Area [m2]","Estimated qty per annum","Lagging Type","Thickness","Price per Pulley Excl. VAT","Total Price per Annum Excl. Vat","Total Price for 3 years Excl. Vat"]
[1,"2A&B","Head",920,1600,{"$f":"D5*E5*3.14/1000000","v":{"v":4.62208,"d":"4.62"}},2,"Rubber",10]
[2,null,"H.T. Bend",800,1600,{"$f":"D6*E6*3.14/1000000","v":{"v":4.0192,"d":"4.02"}},2,"Rubber",10]
[3,null,"Primary Drive",1093,1600,{"v":5.491232,"d":"5.49"},2,"Ceramic",8]
[4,null,"Secondary Drive",1093,1600,{"v":5.491232,"d":"5.49"},2,"Ceramic",8]
[5,null,"Snub",750,1600,{"v":3.768,"d":"3.77"},2,"Rubber",10]
[6,null,"Take-up",750,1600,{"v":3.768,"d":"3.77"},2,"Rubber",10]
[7,null,"Tail",750,1600,{"v":3.768,"d":"3.77"},2,"Rubber",10]
[8,null,"Take-up Bends",550,1600,{"v":2.7632,"d":"2.76"},2,"Rubber",10]
[9,"3A&B","Head",920,1600,{"v":4.62208,"d":"4.62"},2,"Rubber",10]
[10,null,"H.T. Bend",800,1600,{"v":4.0192,"d":"4.02"},2,"Rubber",10]
[11,null,"Primary Drive",1278,1600,{"v":6.420672,"d":"6.42"},2,"Ceramic",8]
[12,null,"Secondary Drive",1278,1600,{"v":6.420672,"d":"6.42"},2,"Ceramic",8]
[13,null,"Snub",750,1600,{"v":3.768,"d":"3.77"},2,"Rubber",10]
[14,null,"Take-up",750,1600,{"v":3.768,"d":"3.77"},2,"Rubber",10]
[15,null,"Tail",750,1600,{"v":3.768,"d":"3.77"},2,"Rubber",10]
[16,null,"Take-up Bends",550,1600,{"v":2.7632,"d":"2.76"},2,"Rubber",10]
[17,null,"H.T. Bend",800,1600,{"v":4.0192,"d":"4.02"},2,"Rubber",10]
[18,"4A&B","Drive",1278,1600,{"v":6.420672,"d":"6.42"},2,"Ceramic",8]
[19,null,"Snub",450,1600,{"v":2.2608,"d":"2.26"},1,"Rubber",10]
[20,null,"Tail",550,1600,{"v":2.7632,"d":"2.76"},1,"Rubber",10]
[21,null,"Take-Up",550,1600,{"v":2.7632,"d":"2.76"},1,"Rubber",10]
[22,null,"Take-Up Bends",450,1600,{"v":2.2608,"d":"2.26"},1,"Rubber",10]
[23,"5A&B","Drive",1058,1600,{"v":5.315392,"d":"5.32"},1,"Ceramic",8]
[24,null,"Snub",450,1600,{"v":2.2608,"d":"2.26"},1,"Rubber",10]
[25,null,"Tail",550,1600,{"v":2.7632,"d":"2.76"},1,"Rubber",10]
[26,null,"Take-Up",550,1600,{"v":2.7632,"d":"2.76"},1,"Rubber",10]
[27,null,"Take-Up Bends",450,1600,{"v":2.2608,"d":"2.26"},1,"Rubber",10]
[28,"6A&B","Drive 6A",1274,1600,{"v":6.400576,"d":"6.40"},1,"Ceramic",8]
[29,null,"Drive 6B",1274,1600,{"v":6.400576,"d":"6.40"},1,"Rubber",10]
[30,null,"Snub",450,1600,{"v":2.2608,"d":"2.26"},1,"Rubber",10]
[31,null,"Tail",550,1600,{"v":2.7632,"d":"2.76"},1,"Rubber",10]
[32,null,"Take-Up",550,1600,{"v":2.7632,"d":"2.76"},1,"Rubber",10]
[33,null,"Take-Up Bends",450,1600,{"v":2.2608,"d":"2.26"},1,"Rubber",10]
[34,null,"Tripper head",900,1600,{"v":4.5216,"d":"4.52"},1,"Rubber",10]
[35,null,"Tripper bend",680,1600,{"v":3.41632,"d":"3.42"},1,"Rubber",10]
[36,"7A&B","Drive",1121,1600,{"v":5.631904,"d":"5.63"},1,"Ceramic",8]
[37,null,"Snub",450,1600,{"v":2.2608,"d":"2.26"},1,"Rubber",10]
[38,null,"Tail",550,1600,{"v":2.7632,"d":"2.76"},1,"Rubber",10]
[39,null,"Take-Up",550,1600,{"v":2.7632,"d":"2.76"},1,"Rubber",10]
[40,null,"Take-Up Bends",450,1600,{"v":2.2608,"d":"2.26"},1,"Rubber",10]
[41,"8A&B","Drive",1274,1600,{"v":6.400576,"d":"6.40"},1,"Ceramic",8]
[42,null,"Snub",450,1600,{"v":2.2608,"d":"2.26"},1,"Rubber",10]
[43,null,"Tail",550,1600,{"v":2.7632,"d":"2.76"},1,"Rubber",10]
[44,null,"Take-Up",550,1600,{"v":2.7632,"d":"2.76"},1,"Rubber",10]
[45,null,"Take-Up Bends",450,1600,{"v":2.2608,"d":"2.26"},1,"Rubber",10]
[46,null,"Tripper head",900,1600,{"v":4.5216,"d":"4.52"},1,"Rubber",10]
[47,null,"Tripper bend",900,1600,{"v":4.5216,"d":"4.52"},1,"Rubber",10]
[{"$nulls":7},"TOTAL FOR LAGGING  FOR 3 YEARS EXCL. VAT "]
[]
[]
[]
[null,null,"SKIRTING SUPPLY"]
[null,"Item No. ","Skirting belt Description","Skirting Width","Skirting Thickness","Price per length [m]",null,null,"Estimate Skirting length per annum",null,"Total  Annual Value  Excl. Vat","Total Value (3 years) Excl. Vat"]
[null,1,"CSY conveyors","300mm","12.5mm",{"$nulls":3},120]
[null,2,"Skirting Budget ( 3 Years)"]
[]
[{"$nulls":7},"TOTAL FOR LAGGING + SKIRTING FOR 3 YEARS EXCL. VAT "]
[]
[]
[null,"HOT SPLICING"]
["Item No. ","Conveyor Description","Belt Width [mm]","Belt class","Estimate splices per annum","Unit Price ","Total  Annual Value  Excl. Vat","Total Value (3 years) Excl. Vat"]
[null,"Coal Conveyors"]
[1,"Reclaim conveyor, 2A&B, 3A&B, ",1500,"Class ST 1000, Steel cord  ",45]
[2,"Cross conveyors, 4A&B 5A&B,6A&B,7A&B,8A&B, Link conveyor, Cross conveyor,  Boom and Shuttle conveyors",1500,"Class 800,3ply",36]
[{"$nulls":4},"Total Hot Splicing Excl. VAT 3 years "]
[]
[]
[null,"COLD SPLICING"]
["Item No.","Conveyor Description","Belt Width [mm]","Belt class","Estimate splices per annum","Unit Price ","Total  Annual Value  Excl. Vat","Total Value (3 years) Excl. Vat"]
[null,"Coal Conveyors"]
[1,"Cross conveyors, 4A&B 5A&B,6A&B,7A&B,8A&B, Link conveyor, Cross conveyor,  Boom and Shuttle conveyors",1500,"Class 800,3ply",10]
[{"$nulls":4},"Total Cold Splicing Excl. VAT 3 years "]
[]
[]
[null,"STEEL CORD SPLICING REPAIRS"]
["Item No. ","Conveyor Description","Belt Width [mm]","Belt class","Estimate splices per annum","Unit Price ","Total  Annual Value  Excl. Vat","Total Value (3 years) Excl. Vat"]
[null,"Coal Conveyors"]
[1,"Reclaim conveyor, 2A&B, 3A&B, ",1500,"Class ST 1000, Steel cord  ",12]
[{"$nulls":4},"Total Steel Cord Splicing Repairs Excl. VAT 3 years "]
[]
[]
[null,"PLY - BELT SPLICING REPAIRS"]
["Item No. ","Conveyor Description","Belt Width [mm]","Belt class"," Belt Length [m]","Estimate splices per annum","Unit Price ","Total  Annual Value  Excl. Vat","Total Value (3 years) Excl. Vat"]
[null,"Coal Conveyors"]
[1,"Cross conveyors, 4A&B 5A&B,6A&B,7A&B,8A&B, Link conveyor, Cross conveyor,  Boom and Shuttle conveyors",1500,"Class 800,3ply",160,15]
[{"$nulls":5},"Total Ply-belt Splicing Repairs Excl. VAT 3 years"]
[]
[]
[null,"PLY - BELT CLIP JOINT"]
["Item No. ","Conveyor Description","Belt Width [mm]","Belt class","Estimate splices per annum","Unit Price ","Total  Annual Value  Excl. Vat","Total Value (3 years) Excl. Vat"]
[null,"Coal Conveyors"]
[1,"Cross conveyors, 4A&B 5A&B,6A&B,7A&B,8A&B, Link conveyor, Cross conveyor,  Boom and Shuttle conveyors",1500,"Class 800,3ply",24]
[{"$nulls":4},"Total Ply-belt Clip Joint Excl. VAT 3 years"]
[null,"NB: The contractor price shall be inclusive of all costs, including but not limited to: Labour, material, consumables, hand tools, specialized tools and equipment, monitoring instruments, travelling costs, health & safety and all other related costs for splicing, belt repairs and pulley lagging on the BOQ."]
[]
[]
[]
[{"$nulls":6},"TOTAL FOR LAGGING + SKIRTING FOR 3 YEARS EXCL. VAT "]
[{"$nulls":6},"Total Hot Splicing Excl. VAT 3 years "]
[{"$nulls":6},"Total Cold Splicing Excl. VAT 3 years "]
[{"$nulls":6},"Total Steel Cord Splicing Repairs Excl. VAT 3 years "]
[{"$nulls":6},"Total Ply-belt Splicing Repairs Excl. VAT 3 years"]
[{"$nulls":6},"Total Ply-belt Clip Joint Excl. VAT 3 years"]
[{"$nulls":6},"TOTAL VALUE FOR BELT REPAIRS FOR DUVHA 3 YEARS EXCL. VAT "]

{"sheet":"FULL CAMDEN BELT REPAIRS","index":2,"n_rows":57,"n_cols":11,"rows_kept":57,"merged":[[2,1,2,7],[7,4,7,6],[10,1,10,7],[15,1,15,6],[15,9,15,10],[18,1,18,10],[22,1,22,9],[26,1,26,7],[29,1,29,6],[33,1,33,8],[35,0,36,0],[35,1,36,1],[35,2,36,2],[35,3,36,3],[35,5,36,5],[35,6,36,6],[35,7,36,7],[35,8,36,8],[37,0,39,0],[37,1,39,1],[37,2,39,2],[37,3,39,3],[37,5,39,5],[37,6,39,6],[37,7,39,7],[37,8,39,8],[40,0,44,0],[40,1,44,1],[40,3,44,3],[40,5,44,5],[40,6,44,6],[40,7,44,7],[40,8,44,8],[45,1,45,7],[53,6,53,7],[56,1,56,8]]}
[null,null,"CAMDEN POWER STATION "]
[]
["Item No. ","COLD VULCANISING SPLICE"]
[1,"Conveyor Description","Belt Width [mm]","Belt class","Estimate splices per annum","Price per splice Excl. VAT","Total  Annual Value  Excl. Vat","Total Value (3 years) Excl. Vat"]
[2,"Hopper Feeder, Bottom deck underflow",1200,"CLASS: 315/3 (top cover 5mm and bottom 3mm)",15]
[3,"Main Feeder",1050,"CLASS: 315/3 (top cover 5mm and bottom 3mm)",15]
[4,"Bottom deck overflow, Middle deck overflow",700,"Moulded V chevron belt",6]
[{"$nulls":4},"Total Cold Splice Excl. VAT (3 Years)"]
[]
[]
[null,"MECHANICALLY BELT FASTENING (CLIP JOINT)"]
["Item No. ","Conveyor Description","Belt Width [mm]","Belt class","Estimate splices per annum","Price per splice Excl. VAT","Total  Annual Value  Excl. Vat","Total Value (3 years) Excl. Vat"]
[1,"Hopper Feeder, Main feeder, Bottom deck underflow",1200,"CLASS: 315/3 (top cover 5mm and bottom 3mm)",12,{"$nulls":5},1.1]
[2,"Main Feeder",1050,"CLASS: 315/3 (top cover 5mm and bottom 3mm)",6]
[3,"Bottom deck overflow, Middle deck overflow",700,"Moulded V chevron belt",8]
[null,"Clip Joint Total Value Excl. VAT (3 years) "]
[]
[]
[null,"LAGGING "]
["Item No. ","Pulley Descriptions","Diameter [mm]","Face width [mm]","Surface area [m2]","Lagging type","Lagging Thickness [mm]","Price per pulley Excl. VAT","Estimate laggings per annum","Total  Annual Value  Excl. Vat","Total Value (3 years) Excl. Vat"]
[1,"Hopper Feeder",320,420,0.422,"Rubber",6,null,6]
[2,"Main Feeder, Bottom deck underflow, Bottom deck overflow, Middle deck overflow, Hopper Feeder",260,350,0.286,"Rubber",6,null,10]
[null,"Lagging Value Excl. VAT (3 Years)"]
[]
[]
[]
[null,"SKIRTING SUPPLY "]
["Item No. ","Skirting belt Description","Skirting Width","Skirting Thickness","Price per length [m]","Estimate Skirting length (m) per annum","Total  Annual Value  Excl. Vat","Total Value (3 years) Excl. Vat"]
[1,"Hooper Feeder, Main Feeder, Bottom deck underflow","300 mm","10 mm",null,30]
[null,"Skirting Total Value Excl. VAT (3 Years)"]
[]
[]
[]
[null,"CONVEYOR BELT SUPPLY + INSTALLATION"]
["Item No. ","Conveyor belt Description","Conveyor Belt Specification","Conveyor Belt Width (mm)","Conveyor Belt – Brand and Conveyor Belt mass/m2","Price per Roll excl (300m)","Estimate rolls per annum","Total  Annual Value  Excl. Vat","Total Value (3 years) Excl. Vat"]
[1,"Hopper Feeder, Bottom deck underflow","CLASS: 315/3 (top cover 5mm and bottom 3mm)",1200,"Dunlop or Goodyear",null,3]
[{"$nulls":4},"14 kg/m2"]
[2,"Main Feeder","CLASS: 315/3 (top cover 5mm and bottom 3mm)",1050,"Dunlop or Goodyear",null,3]
[]
[{"$nulls":4},"12,3 kg/m2"]
[3,"Bottom deck overflow, Middle deck overflow","Moulded V chevron belt",700,"Oriental Rubber Industries",null,1]
[null,null,"Chevron 360mm wide",null,"Dunlop"]
[null,null,"Rib 20mm bottom",null,"Goodyear"]
[null,null,"Rib 12 mm top"]
[null,null,"Belt 7 mm thick"]
[null,"Conveyor belt supply Total Value Excl. VAT (3 years) "]
[]
[{"$nulls":6},"Total Cold Splice Excl. VAT (3 Years)"]
[{"$nulls":6},"Clip Joint Total Value Excl. VAT (3 years) "]
[{"$nulls":6},"Lagging Value Excl. VAT (3 Years)"]
[{"$nulls":6},"Skirting Total Value Excl. VAT (3 Years)"]
[{"$nulls":6},"Conveyor belt supply Total Value Excl. VAT (3 years) "]
[]
[{"$nulls":6},"TOTAL BELT REPAIRS AT CAMDEN 3 YEARS Excl. VAT "]
[]
[]
[null,"NB: The contractor price shall be inclusive of all costs, including but not limited to: Labour, material, consumables, hand tools, specialized tools and equipment, monitoring instruments, travelling costs, health & safety and all other related costs for splicing, belt repairs and pulley lagging on the BOQ."]

{"sheet":"FULL MEDUPI BELT REPAIRS ","index":3,"n_rows":222,"n_cols":22,"rows_kept":222,"merged":[[99,1,100,1],[101,1,105,1],[106,1,109,1],[110,1,113,1],[114,1,119,1],[120,1,125,1],[126,1,127,1],[128,1,129,1],[130,1,131,1],[132,1,138,1],[139,1,142,1],[143,1,144,1],[145,1,152,1],[153,1,159,1],[160,1,164,1],[165,1,168,1],[175,0,175,5],[218,1,218,6]]}
[null,"MEDUPI POWER STATION BELT REPAIRS "]
[]
[]
["Item No. ","Description","Unit","Quantity","Hrs/month ","Rate"," Total/ month ","Duration ","Total Excl. VAT (3 years)"]
[]
[null,"Section 1"]
[1,"Preliminaries & Generals"]
["1.1","Site Establishment (once-off) 20 x chairs, 1x fridges,1x 30L microwave","Sum",1,{"$nulls":3},1]
["1.2","Induction/Medical tests (once per year) + Exit Medicals","Per person",{"$f":"SUM($D$18:$D$21,$D$23:$D$25)","v":25},{"$nulls":3},4]
["1.3","PPE excluding dust mask and earplugs (once per year)","Per person",{"$f":"SUM($D$18:$D$21,$D$23:$D$25)","v":25},{"$nulls":3},3]
["1.4","Safety file","Sum",1,{"$nulls":3},1]
["1.5","Site De-establishment (once-off)","Sum",1,{"$nulls":3},1]
[null,"Sub -Total P&Gs"]
[]
[null,"Section  2"]
[2,"Labour"]
[null,"Splicing Day Workers","Unit","Quantity","Hrs/month ","Rate"," Total/ month ","Duration ","Total Excl. VAT (3 years)"]
["2.1","Supervisor","Hr",2,173,null,null,36]
["2.2","Senior splicer","Hr",2,173,null,null,36]
["2.3","Junior splicers","Hr",2,173,null,null,36]
["2.4","Splicing assistant","Hr",6,173,null,null,36]
[null,"Scrapper Maintenance "]
["2.5","Supervisor","Hr",1,173,null,null,36]
["2.6","Scrapper Artisan","Hr",4,173,null,null,36]
["2.7","Scrapper Assistant ","Hr",8,173,null,null,36]
[null,"Sub-Total Labour "]
[]
[null,"Weekly & Saturdays @ 1.5 factor"]
["2.8","Supervisor","Hr",2,40,null,null,36]
["2.9","Senior splicer","Hr",2,40,null,null,36]
["2.10","Junior splicers","Hr",2,40,null,null,36]
["2.11","Splicing assistant","Hr",6,40,null,null,36]
[null,"Scrapper"]
["2.12","Supervisor","Hr",1,40,null,null,36]
["2.13","Scrapper Artisan","Hr",4,40,null,null,36]
["2.14","Scrapper Assistant ","Hr",8,40,null,null,36]
[null,"Sub-Total Weekly & Saturday overtime "]
[]
[null,"Sundays/Public Holidays @ 2 factor"]
["2.15","Supervisor","Hr",2,40,null,null,36]
["2.16","Senior splicer","Hr",2,40,null,null,36]
["2.17","Junior splicers","Hr",2,40,null,null,36]
["2.18","Splicing assistant","Hr",6,40,null,null,36]
[null,"Scrapper"]
["2.19","Supervisor","Hr",1,40,null,null,36]
["2.20","Scrapper Artisan","Hr",4,40,null,null,36]
["2.21","Scrapper Assistant ","Hr",8,40,null,null,36]
[null,"Sub-Total Sunday/Public Holidays overtime "]
[]
[{"$nulls":7},"Total for Labour + P&Gs Excl. VAT (3 years)"]
[]
[]
[]
[]
[null,"MEDUPI POWER STATION ASH LAGGING ",{"$nulls":9},{"v":0.05,"d":"5%"}]
[]
["Item No. ","Pulley Descriptions","Diameter [mm]","Face width [mm]","Surface area [m2]","Lagging type","Lagging Thickness [mm]","Price per pulley Excl. VAT","Number of times (2 per year/36 Months)","Total for 36 months "]
[1,"Coarse Ash Conveyors, Conveyor Tail, Bend, Bend and Take-up Pulleys",500,1350,"2.12","Rubber",10,null,6]
[2,"Coarse Ash Conveyors, Head/Drive Pulley",630,1350,"2.67","Ceramic",12,null,6]
[3,"Coarse Ash Conveyors, Snub pulley",405,1350,"1.72","Rubber",10,null,6]
[4,"Transverse Ash Conveyors, Conveyor Tail Pulley & Take-up pulley",500,1350,"2.12","Rubber",10,null,6]
[5,"Transverse Ash Conveyors, Conveyor Head Pulley, High tension Bend pulley, High tension Bend Pulley & Drive Snub Pulley",630,1350,"2.67","Rubber",10,null,6]
[6,"Transverse Ash Conveyors, Conveyor Drive Pulley",630,1350,"2.67","Ceramic",12,null,6]
[7,"Transverse Ash Conveyors, Conveyor Low Tension Bend Pulley & Low Tension Bend Pulley",500,1350,"2.12","Rubber",10,null,6]
[8,"Ash Overland Link Conveyors, Conveyor Tail Pulley, Take-Up pulley, Take-up bend Pulley",500,1700,"2.67","Rubber",10,null,6]
[9,"Ash Overland Link Conveyors, Conveyor Head Pulley & High Tension Bent Pulley",710,1700,"3.79","Rubber",10,null,6]
[10,"Ash Overland Link Conveyors, Conveyor Drive Pulley",630,1700,"3.36","Ceramic",10,null,6]
[11,"Emergency Ash Stacking Conveyor, Tail, snub, take -up, and take-up bent pulleys",500,1700,"2.67","Rubber",10,null,6]
[12,"Emergency Ash Stacking Conveyor, Tripper Car Head Pulley and conveyor  Head pulley",710,1700,"3.79","Rubber",10,null,6]
[13,"Emergency Ash Stacking Conveyor, Tripper Car Bent and High Tension Bent Pulley",630,1700,"3.36","Rubber",10,null,6]
[14,"Emergency Ash Stacking Conveyor, Conveyor Drive Pulley",630,1700,"3.36","Ceramic",12,null,6]
[15,"Emergency Ash Stacker, Boom Drive Pulley",630,1700,"3.36","Ceramic",12,null,6]
[16,"Emergency Ash Stacker, Boom Head Pulley",500,1700,"2.67","Rubber",10,null,6]
[17,"Emergency Ash reclaim Conveyor, Tail, Take-up  and Take-up bend pulleys",500,1350,"2.12","Rubber",10,null,6]
[18,"Emergency Ash reclaim Conveyor, Head/Drive Pulley",630,1350,"2.67","Ceramic",12,null,6]
[19,"Emergency Ash reclaim Conveyor, Snub Pulley",400,1350,"1.70","Rubber",10,null,6]
[20,"Emergency Ash reclaim Conveyor, Take-up bend pulleys",500,1350,"2.12","Rubber",10,null,6]
[21,"Overland Conveyor, Head, HT Snub and Drive snub pulleys",800,1700,"4.27","Rubber",10,null,6]
[22,"Overland Conveyor, High Tension 1 and 2 Pulley",1200,1700,"6.41","Rubber",10,null,6]
[23,"Overland Conveyor, Drive Pulley",800,1700,"4.27","Ceramic",12,null,6]
[24,"Overland Conveyor Take-up Pulley",630,1700,"3.36","Rubber",10,null,6]
[25,"Overland Conveyor Take-up bend 1 to 4 Pulleys",630,1700,"3.36","Rubber",10,null,6]
[26,"Overland Conveyor Tail Pulley",800,1700,"4.27","Rubber",10,null,6]
[27,"Extendable Conveyor, Head, High tension Bend 1 and Primary and Secondary drive snub Pulleys",1000,1700,"5.34","Rubber",10,null,6]
[28,"Extendable Conveyor, Primary and Secondary drive Pulleys",1000,1700,"5.34","Ceramic",12,null,6]
[29,"Extendable Conveyor, Take-up, Take-up bend 1 to 4 and Tail Pulleys",630,1700,"3.36","Rubber",10,null,6]
[30,"Shiftable Conveyor, Drive Pulley",800,1700,"4.27","Ceramic",12,null,6]
[31,"Shiftable Conveyor, Drive Pulley",800,1700,"4.27","Rubber",10,null,6]
[32,"Ash Stacker Tripper car, Discharge and take-up Pulleys",630,1700,"3.36","Rubber",10,null,6]
[33,"Ash Stacker Tripper car, snub Pulley",500,1700,"2.67","Rubber",10,null,6]
[34,"Ash Stacker Link and Boom Conveyor Drive Pulleys",630,1700,"3.36","Rubber",10,null,6]
[35,"Ash Stacker Link and Boom Conveyor Head Pulleys",500,1700,"2.67","Rubber",10,null,6]
[{"$nulls":8},"Total for Ash Lagging Excl. VAT (3 Years)"]
[]
[]
[]
[null,"MEDUPI POWER STATION  COAL PULLEY LAGGING "]
[]
["Item No. ","Belt","Pulley","Diameter [mm]","Face width [mm]","Surface Area [m2]","Lagging Type","Thickness","Price per pulley Excl. VAT","Number of times (36 Months- 2 xper year)","Price per pulley Excl. VAT"]
[1,"US1A&B","Drive",1000,2600,"8.17","Ceramic",8,null,6]
[2,null,"Tail/take-up",1000,2600,"8.17","Rubber",10,null,6]
[3,"OV1","Primary Drive",1000,2300,"7.23","Ceramic",10,null,6]
[4,null,"H.T Bend",1000,2300,"7.23","Rubber",10,null,6]
[5,null,"Secondary Drive",1000,2300,"7.23","Ceramic",10,null,6]
[6,null,"L.T Take Up/ L.T Bend",800,2300,"5.78","Rubber",10,null,6]
[7,null,"Tail",800,2300,"5.78","Rubber",10,null,6]
[8,"OV2","Drive",800,2300,"5.78","Ceramic",10,null,6]
[9,null,"H.T Bend",800,2300,"5.78","Rubber",10,null,6]
[10,null,"L.T Bend/ L.T Take Up/ Tal",630,2300,"4.55","Rubber",10,null,6]
[11,null,"H.T Pulley/ Head Pulley",800,2300,"5.78","Rubber",10,null,6]
[12,"SY1","Tail",800,2300,"5.78","Rubber",10,null,6]
[13,null,"Drive",800,2300,"5.78","Ceramic",6,null,6]
[14,null,"L.T Bend",500,2300,"3.61","Rubber",10,null,6]
[15,null,"H.T Bend",630,2300,"4.55","Rubber",10,null,6]
[16,"SYS1&2","Tail",800,2300,"5.78","Rubber",10,null,6]
[17,null,"Head  ",1000,2300,"7.23","Rubber",10,null,6]
[18,null,"H.T Bend",800,2300,"5.78","Rubber",10,null,6]
[19,null,"Drive",1000,2300,"7.23","Ceramic",6,null,6]
[20,null,"Take-Up",630,2300,"4.55","Rubber",10,null,6]
[21,null,"L.T Bend",500,2300,"3.61","Rubber",10,null,6]
[22,"SYR1&2","Tail",800,2000,"5.03","Rubber",10,null,6]
[23,null,"Head  ",1000,2000,"6.28","Rubber",10,null,6]
[24,null,"H.T Bend",800,2000,"5.03","Rubber",10,null,6]
[25,null,"Drive",800,2000,"5.03","Ceramic",6,null,6]
[26,null,"Take-Up",630,2000,"3.96","Rubber",10,null,6]
[27,null,"L.T Bend",500,2000,"3.14","Rubber",10,null,6]
[28,"Reclaimer 1&2 Cross Conveyor","Drive",630,2300,"4.55","Ceramic",6,null,6]
[29,null,"Tail/take-up",630,2300,"4.55","Rubber",10,null,6]
[30,"Stacker 1&2 Intermediate Conveyor","Drive",800,2300,"5.78","Ceramic",6,null,6]
[31,null,"Tail/take-up/LT Bend",630,2300,"4.55","Rubber",10,null,6]
[32,"Stacker 1&2 Boom Conveyor","Drive",800,2000,"5.03","Ceramic",6,null,6]
[33,null,"Tail/take-up",800,2000,"5.03","Rubber",10,null,6]
[34,"SY2A&B","Tail",800,2000,"5.03","Rubber",10,null,6]
[35,null,"Head ",1000,2000,"6.28","Rubber",10,null,6]
[36,null,"H.T 180 Bend ",800,2000,"5.03","Rubber",10,null,6]
[37,null,"H.T 90 Bend",800,2000,"5.03","Rubber",10,null,6]
[38,null,"Drive",1000,2000,"6.28","Ceramic",6,null,6]
[39,null,"Take-Up",630,2000,"3.96","Rubber",10,null,6]
[40,null,"L.T Bend",500,2000,"3.14","Rubber",10,null,6]
[41,"T1A&B","Tail",800,2000,"5.03","Rubber",10,null,6]
[42,null,"Drive",800,2000,"5.03","Ceramic",6,null,6]
[43,null,"L.T Bend",500,2000,"3.14","Rubber",10,null,6]
[44,null,"Take-Up",630,2000,"3.96","Rubber",10,null,6]
[45,"T2A-F","Drive",1000,2000,"6.28","Ceramic",12,null,6]
[46,null,"Take-Up",800,2000,"5.03","Rubber",10,null,6]
[47,"T3A-F","Drive",630,1350,"2.67","Ceramic",12,null,6]
[48,null,"Head",710,1350,"3.01","Rubber",10,null,6]
[49,null,"Head snub",500,1350,"2.12","Rubber",10,null,6]
[50,null,"Take-Up bend",500,1350,"2.12","Rubber",10,null,6]
[51,null,"H.T snub",630,1350,"2.67","Rubber",10,null,6]
[52,null,"Tail",500,1350,"2.12","Rubber",10,null,6]
[53,null,"Take-Up",500,1350,"2.12","Rubber",10,null,6]
[54,null,"L.T Bend",500,1350,"2.12","Rubber",10,null,6]
[55,"T4A-F","Drive",630,1350,"2.67","Ceramic",12,null,6]
[56,null,"Head",630,1350,"2.67","Rubber",10,null,6]
[57,null,"HT Snub",630,1350,"2.67","Rubber",10,null,6]
[58,null,"Take -Up",500,1350,"2.12","Rubber",10,null,6]
[59,null,"Take-Up bend",500,1350,"2.12","Rubber",10,null,6]
[60,null,"Tail",500,1350,"2.12","Rubber",10,null,6]
[61,null,"L.T bend",500,1350,"2.12","Rubber",10,null,6,{"$nulls":5},"BOQ value",null,"Fixed 15%",null,"Price for one year","Estimated CPA for one year","for 2 years"]
[62,"T5/6A-F","Drive",630,1350,"2.67","Ceramic",12,null,6,{"$nulls":4},"P&G's",{"$f":"$I$13+SUM(J218:J221)","v":0},{"$f":"P161*15%","v":0},{"$f":"P161-Q161","v":0},{"$f":"R161/P163*100","v":{"$error":"#DIV/0!"}},{"$f":"R161/4","v":0},{"$f":"T161*P165","v":0},{"$f":"U161*2","v":0}]
[63,null,"Drive snub",406,1350,"1.72","Rubber",10,null,6,{"$nulls":4},"Labour ",{"$f":"SUM(I26,I37,I48)","v":0},{"$f":"P162*15%","v":0},{"$f":"P162-Q162","v":0},{"$f":"R162/P163*100","v":{"$error":"#DIV/0!"}},{"$f":"R162/4","v":0},{"$f":"T162*P166","v":0},{"$f":"U162*2","v":0}]
[64,null,"Take-Up bend",500,1350,"2.12","Rubber",10,null,6,{"$nulls":5},{"$f":"SUM(P161:P162)","v":0},null,{"$f":"P163*15%","v":0},15,null,null,{"$f":"SUM(V161:V162)","v":0}]
[65,null,"Tail",500,1350,"2.12","Rubber",10,null,6]
[66,null,"Take-up",500,1350,"2.12","Rubber",10,null,6,{"$nulls":4},"CPI increase",0.0695]
[67,"T7/8A-F","Drive",630,1350,"2.67","Ceramic",12,null,6,{"$nulls":4},"MEIBC increase",0.055]
[68,null,"Tail",630,1350,"2.67","Rubber",10,null,6]
[69,null,"Bend",400,1350,"1.70","Rubber",10,null,6]
[70,null,"Take-Up",400,1350,"1.70","Rubber",10,null,6]
[{"$nulls":9},"Total Coal Conveyor Materials Excl. VAT 3 Years"]
[]
[{"$nulls":12},{"v":0.05,"d":"5%"}]
[null,"MEDUPI POWER STATION "]
[]
[null,"MEDUPI COAL CONVEYORS - BELT SPLICING "]
[]
["Item No. ","Coal Conveyors","Belt Class","Cover Thickness","Type","Belt Width (mm)","Rate per Splice","Number of Conveyors","Number of Splices per conveyor /36 months","Total Amount Exc.l VAT 3 Years "]
[1,"US 1A & B","1600/4","15 X 5","M",2400,null,2,9]
[2,"OV1","ST 1600","6 X 6","N",2100,null,1,9]
[3,"OV2","ST 1000","6 X 6","N",2100,null,1,12]
[4,"SY1","ST 500","8 X 5","N",2100,null,1,12]
[5,"SYS I & 2","ST 1000","5 X 5","N",2100,null,2,12]
[6,"SYR 1 & 2","ST 800","5 X 5","N",1800,null,2,12]
[7,"RECLAIMER 1/2 CROSS CONV","800/4","8 X 4","STCK",2100,null,2,6]
[8,"STACKER 1/2 INTERMEDIATE CONV","800/4","8 X 4","STCK",2100,null,2,6]
[9,"STACKER 1/2 BOOM CONV","800/4","8 X 4","N",1800,null,2,6]
[10,"SY2 A & B","ST 1000","5 X 5","N",1800,null,2,12]
[11,"T1 A & B","ST 500","8 X 5","N",1800,null,2,12]
[12,"T2 A-F","1000/4","10 X 5","M",1800,null,6,9]
[13,"T3 A-F","ST 800","5 X 5","N",1200,null,6,9]
[14,"T4 A-F","500/3","8 X 5","N",1200,null,6,9]
[15,"T5/6A-F","500/3","8 X 5","N",1200,null,12,9]
[16,"T7/8A-F","500/3","8 X 5","N",1200,null,12,9]
[{"$nulls":8},"Coal Conveyors - Belt splicing total excl. VAT 3 years"]
[]
[]
[]
[null,"MEDUPI ASH CONVEYORS - BELT SPLICING "]
[]
["Item No. ","Ash Conveyors","Belt Class","Cover Thickness","Type","Belt Width (mm)","Rate per Splice","Number Of Conveyors","Number of Splices per Conveyor/36 months","Total Amount Exc.l VAT 3 Years "]
[1,"COARSE ASH CONVEYOR","500/3","8 X 5","N",1200,null,6,6]
[2,"TRANSVERSE CONVEYOR","500/3","8 X 5","N",1200,null,2,9]
[3,"OVERLAND LINK","630/4","8 X 5","N",1500,null,2,12]
[4,"EMERGENCY ASH STACKING CON","630/4","8 X 5","N",1500,null,1,6]
[5,"EMERGENCY ASH BOOM CONV","630/4","8 X 5","N",1500,null,1,6]
[6,"EMERGENCY ASH RECLAIM CONV","500/3","8 X 5","N",1200,null,1,6]
[7,"OVERLAND CONVEYOR","ST 800","8 X 5","N/STCK",1500,null,2,12]
[8,"EXTENDABLE CONVEYOR","ST 1600","8 X 5","N/STCK",1500,null,2,12]
[9,"SHIFTABLE CONVEYOR","ST 500","8 X 5","N/STCK",1500,null,2,12]
[10,"STACKER LINK CONVEYOR","ST 400","8 X 6","N/STCK",1500,null,2,12]
[11,"STACKER BOOM CONVEYOR","ST 400","8 X 6","N/STCK",1500,null,2,12]
[{"$nulls":8},"Ash Conveyors - Belt splicing total excl. VAT 3 years"]
[]
[]
[]
[]
[{"$nulls":8},"Labour + P&Gs "]
[{"$nulls":8},"Ash Conveyors - Pulley Lagging "]
[null,"NB: The contractor price shall be inclusive of all costs, including but not limited to: Labour, material, consumables, hand tools, specialized tools and equipment, monitoring instruments, travelling costs, health & safety and all other related costs for splicing, belt repair",{"$nulls":6},"Coal Conveyors - Pulley Lagging "]
[{"$nulls":8},"Coal Conveyors - Belt splicing"]
[{"$nulls":8},"Ash Conveyors - Belt splicing"]
[{"$nulls":8},"Total Excl. VAT 3 years for Medupi"]