{"text_format":"3","workbook":"xlsx","n_sheets":15,"sheets":["BOQ","Estimate Markup","01 Material Prices","02 Equipment","03 Labour","04 Subcontract","05 Built-in Preliminaries","06 Material Transp.","07 ExtraOver Haulage","08 Concrete","09 Asphalt Binder","10 Blockworks","11 Laterite Fillings","12 Road Scarify","13 Prime Coat"],"not_rendered":{"external_links":13,"defined_names":753},"read":"whole","date_system":"1900"}

{"sheet":"BOQ","index":0,"n_rows":56,"n_cols":16,"rows_kept":56,"merged":[[0,0,1,0],[1,4,1,5],[1,7,1,8]]}
["LEGEND","COST TO CONSTRUCT",{"$nulls":5},"Markup",{"$f":"'Estimate Markup'!C37","v":4.171},{"$nulls":5},"PS","PC"]
[null,"OFFER TO CLIENT",null,null,"COST TO CONSTRUCT",null,null,"OFFER TO CLIENT",{"$nulls":6},{"$f":"SUM(M3:M57)","v":{"v":5000000,"d":"5,000,000.00"}},{"$f":"SUM(N3:N57)","v":{"v":7500000,"d":"7,500,000.00"}}]
[]
["CODE","DESCRIPTION","QTY","UNIT","RATE","AMOUNT",null,"RATE","AMOUNT"]
[]
[{"v":1,"d":"1.00"},"BUILDING WORKS"]
[]
[null,"1.5 EXCAVATION AND FILLING"]
[null,"FILLING"]
["1.5.12.2.1.1","Imported filling, bed not exceeding 500mm deep, 350mm thick, leveled to falls in foundation",365,"m3",{"$f":"'11 Laterite Fillings'!D50","v":{"v":1170,"d":"1,170.00"}},{"$f":"E10*C10","v":{"v":427050,"d":"427,050.00"}},null,{"$f":"ROUND(E10*$I$1,0)","v":{"v":4880,"d":"4,880.00"}},{"$f":"H10*C10","v":{"v":1781200,"d":"1,781,200.00"}}]
[]
[null,"1.11 INSITU CONCRETE WORKS"]
["1.11.1.1.2/1","Mass Concrete; 250mm thick; In trench filling; Poured on or against earth or unblinded hard core",400,"m3",{"$f":"'08 Concrete'!E35","v":{"v":42785.19897959185,"d":"42,785.20"}},{"$f":"E13*C13","v":{"v":17114079.59183674,"d":"17,114,079.59"}},null,{"$f":"ROUND(E13*$I$1,0)","v":{"v":178457,"d":"178,457.00"}},{"$f":"H13*C13","v":{"v":71382800,"d":"71,382,800.00"}}]
[]
[null,"1.14 MASONRY"]
[null,"Brick/Blockwalling, Glass Walling, Natural Stone Rubble Walling"]
["1.14.1.2.4.1","Walls; 225mm thickness Hollow sandcrete block in foundation jointed with mortar ratio 1:6",4065,"m2",{"$f":"'10 Blockworks'!E50","v":{"v":8425.751391666665,"d":"8,425.75"}},{"$f":"E17*C17","v":{"v":34250679.407124996,"d":"34,250,679.41"}},null,{"$f":"ROUND(E17*$I$1,0)","v":{"v":35144,"d":"35,144.00"}},{"$f":"H17*C17","v":{"v":142860360,"d":"142,860,360.00"}}]
[]
["1.14.1.2.4.1","Walls; 150mm thickness Hollow sandcrete block in superstructure jointed with mortar ratio 1:6",2500,"m2",{"$f":"'10 Blockworks'!K42","v":{"v":3766.162131666666,"d":"3,766.16"}},{"$f":"E19*C19","v":{"v":9415405.329166666,"d":"9,415,405.33"}},null,{"$f":"ROUND(E19*$I$1,0)","v":{"v":15709,"d":"15,709.00"}},{"$f":"H19*C19","v":{"v":39272500,"d":"39,272,500.00"}}]
[]
[null,"1.23 WINDOWS, SCREENS AND LIGHTS"]
[null,"WINDOWS"]
["1.23.1.1.0","Aluminium Windows and Window frames, 1.5x1.5m high) finished with 5mm thick tinted glass, fixed to pre-installed 25mm square pipe subframe burined in concrete/blockworks",{"v":86,"d":"86.00"},"nr",{"$f":"'04 Subcontract'!I10","v":{"v":253991.5,"d":"253,991.50"}},{"$f":"E23*C23","v":{"v":21843269,"d":"21,843,269.00"}},null,{"$f":"ROUND(E23*$I$1,0)","v":{"v":1059399,"d":"1,059,399.00"}},{"$f":"H23*C23","v":{"v":91108314,"d":"91,108,314.00"}}]
[]
[null,"1.26 METAL WORK"]
["1.26.2.1.0.2","General Metal work members, 25mm square pipe subframe; 1.5x1.5m high, buried in concrete/blockworks with cement moratr 1:5",{"$f":"C23","v":{"v":86,"d":"86.00"}},"nr",{"$f":"'04 Subcontract'!I13","v":{"v":15032.15,"d":"15,032.15"}},{"$f":"E26*C26","v":{"v":1292764.9,"d":"1,292,764.90"}},null,{"$f":"ROUND(E26*$I$1,0)","v":{"v":62699,"d":"62,699.00"}},{"$f":"H26*C26","v":{"v":5392114,"d":"5,392,114.00"}}]
[]
[]
[{"v":2,"d":"2.00"},"CIVIL/INDUSTRIAL ENGINEERING WORKS AND THE LIKES"]
[]
["2A","GENERAL ITEMS"]
[null,"Provisional Sum"]
["2A1.5.1","Provisional Sums for Site Engineers representatives accommodation  (N5,000,000).",null,"Sum",{"$nulls":4},{"v":5000000,"d":"5,000,000.00"},{"$nulls":3},{"$f":"I33","v":{"v":5000000,"d":"5,000,000.00"}}]
[]
[null,"Prime Cost"]
["2A1.5.1","Nominated Sub-contracts which include work on the Site, Prime Cost for provision and installation of Road Markings and Signages as required. (N7,500,000)",null,"Sum",{"$nulls":4},{"v":7500000,"d":"7,500,000.00"},{"$nulls":4},{"$f":"I36","v":{"v":7500000,"d":"7,500,000.00"}}]
[]
["2A1.5.4","Other charges and profit",null,"Sum",{"$nulls":4},{"$f":"(I36*7.5%)","v":{"v":562500,"d":"562,500.00"}}]
[]
["2D","DEMOLITION AND SITE CLEARANCE"]
["2D1.5.1.15","Other structures; no predominant material, Volume not exceeding 50m3",null,"Sum",null,{"$f":"'12 Road Scarify'!C23","v":{"v":55000,"d":"55,000.00"}},null,null,{"$f":"ROUND(F41*$I$1,0)","v":{"v":229405,"d":"229,405.00"}}]
[]
["2E","EARTHWORKS"]
["2E1.6.3.5","Filling; Imported natural material other than topsoil or rock",6000,"m3",{"$f":"'11 Laterite Fillings'!D50","v":{"v":1170,"d":"1,170.00"}},{"$f":"E44*C44","v":{"v":7020000,"d":"7,020,000.00"}},null,{"$f":"ROUND(E44*$I$1,0)","v":{"v":4880,"d":"4,880.00"}},{"$f":"H44*C44","v":{"v":29280000,"d":"29,280,000.00"}}]
[]
["2T","ROADS AND PAVINGS"]
["2T1.3.2.2","Bituminous bound pavements; Hot Rolled asphalt binder, Depth 30-60mm",3000,"m2",{"$f":"'09 Asphalt Binder'!C40","v":{"v":5428.901428571429,"d":"5,428.90"}},{"$f":"E47*C47","v":{"v":16286704.285714287,"d":"16,286,704.29"}},null,{"$f":"ROUND(E47*$I$1,0)","v":{"v":22644,"d":"22,644.00"}},{"$f":"H47*C47","v":{"v":67932000,"d":"67,932,000.00"}}]
[]
["2T1.0.10.0","Separation and waterproof membrane using MC1 bitumenous emulsion applied at the rate of 1.3L/m2",{"$f":"C47","v":3000},"m2",{"$f":"'13 Prime Coat'!D37","v":{"v":622.2041666666667,"d":"622.20"}},{"$f":"E49*C49","v":{"v":1866612.5,"d":"1,866,612.50"}},null,{"$f":"ROUND(E49*$I$1,0)","v":{"v":2595,"d":"2,595.00"}},{"$f":"H49*C49","v":{"v":7785000,"d":"7,785,000.00"}}]
[]
[null,"Subtotal 1",{"$nulls":3},{"$f":"SUM(F5:F50)","v":{"v":109571565.01384269,"d":"109,571,565.01"}},null,null,{"$f":"SUM(I5:I50)","v":{"v":470086193,"d":"470,086,193.00"}}]
[null,"Contigency",{"v":0.05,"d":"5.0%"},{"$nulls":5},{"$f":"$I$51*C52","v":{"v":23504309.650000002,"d":"23,504,309.65"}}]
[null,"Variation of Prices",{"v":0.05,"d":"5.0%"},{"$nulls":5},{"$f":"$I$51*C53","v":{"v":23504309.650000002,"d":"23,504,309.65"}}]
[null,"Subtotal 2",{"$nulls":6},{"$f":"SUM(I51:I53)","v":{"v":517094812.29999995,"d":"517,094,812.30"}}]
[null,"VAT",{"v":0.075,"d":"7.5%"},{"$nulls":5},{"$f":"$I$54*C55","v":{"v":38782110.92249999,"d":"38,782,110.92"}}]
[null,"TOTAL",{"$nulls":6},{"$f":"SUM(I54:I55)","v":{"v":555876923.2225,"d":"555,876,923.22"}}]

{"sheet":"Estimate Markup","index":1,"n_rows":37,"n_cols":7,"rows_kept":37}
[null,"Project Staff",null,{"$f":"'05 Built-in Preliminaries'!G45","v":{"v":14080000,"d":"14,080,000.00"}}]
[null,"Site Accommodation",null,{"$f":"'05 Built-in Preliminaries'!G46","v":{"v":9200000,"d":"9,200,000.00"}}]
[null,"Transportation",null,{"$f":"'05 Built-in Preliminaries'!G47","v":{"v":12137500,"d":"12,137,500.00"}}]
[null,"Scaffolding/Shuttering",null,{"$f":"'05 Built-in Preliminaries'!G48","v":{"v":37200000,"d":"37,200,000.00"}}]
[null,"Site Equipment",null,{"$f":"'05 Built-in Preliminaries'!G49","v":{"v":72925000,"d":"72,925,000.00"}}]
[null,"Insurance & Bond",null,{"$f":"'05 Built-in Preliminaries'!G50","v":{"v":12905300,"d":"12,905,300.00"}}]
[null,"Total In-built Preliminaries",null,{"$f":"SUM(D1:D6)*E7","v":{"v":158447800,"d":"158,447,800.00"}},{"v":1,"d":"100%"}]
[null,"Actual Measured Works",null,{"$f":"BOQ!F51","v":{"v":109571565.01384269,"d":"109,571,565.01"}}]
[null,"Total Cost",null,{"$f":"D8+D7","v":{"v":268019365.0138427,"d":"268,019,365.01"}}]
[null,"ADD-Ons"]
[null,"Management",{"v":0.01,"d":"1.00%"},null,{"$f":"C11*$D$22","v":{"v":4393760.0822,"d":"4,393,760.08"}}]
[null,"Overhead",{"v":0.035,"d":"3.50%"},null,{"$f":"C12*$D$22","v":{"v":15378160.287700003,"d":"15,378,160.29"}}]
[null,"Profit",{"v":0.125,"d":"12.50%"},null,{"$f":"C13*$D$22","v":{"v":54922001.0275,"d":"54,922,001.03"}}]
[null,"Risks",{"v":0.15,"d":"15.00%"},null,{"v":65906401.233,"d":"65,906,401.23"}]
[null,"PR",{"v":0,"d":"0.00%"},null,0]
[null,"WHT",{"v":0.05,"d":"5.00%"},null,{"v":21968800.411000002,"d":"21,968,800.41"}]
[null,"Stamp duty",{"v":0.01,"d":"1.00%"},null,{"v":4393760.0822,"d":"4,393,760.08"}]
[null,"As Built Design",{"v":0.01,"d":"1.00%"},null,{"$f":"C18*$D$22","v":{"v":4393760.0822,"d":"4,393,760.08"}}]
[null,"TOTAL",{"$f":"SUM(C11:C18)","v":{"v":0.39,"d":"39.00%"}},null,{"$f":"SUM(E11:E18)","v":{"v":171356643.2058,"d":"171,356,643.21"}}]
[null,"Cost escalation without Profit",{"$f":"ROUND(1/(1-(C19-C13)),3)","v":1.361}]
[null,"Cost escalation  with Profit",{"$f":"ROUND(1/(1-C19),3)","v":1.639}]
[null,null,"Offer",{"$f":"ROUND(D9/(1-C19),2)","v":{"v":439376008.22,"d":"439,376,008.22"}},"Assumed Cost for Loan of N50,000,000 @ 26%"]
[null,"ADD KNOWN Cost of Finance",null,{"$f":"E23*C20","v":{"v":17693000,"d":"17,693,000.00"}},{"$f":"50000000*26%","v":{"v":13000000,"d":"13,000,000.00"}}]
[{"$nulls":3},{"$f":"SUM(D22:D23)","v":{"v":457069008.22,"d":"457,069,008.22"}}]
[]
[null,null,"Prime Cost",{"$f":"BOQ!P2","v":{"v":7500000,"d":"7,500,000.00"}}]
[null,{"v":0.075,"d":"7.5%"},"PC Attendance",{"$f":"B27*D26","v":{"v":562500,"d":"562,500.00"}}]
[null,null,"Provisional Sum",{"$f":"BOQ!O2","v":{"v":5000000,"d":"5,000,000.00"}}]
[]
[{"$nulls":3},{"$f":"SUM(D24:D29)","v":{"v":470131508.22,"d":"470,131,508.22"}},"AMOUNT IN BOQ"]
[null,"Contingency",{"v":0.05,"d":"5.00%"},{"$f":"C31*$D$30","v":{"v":23506575.411000002,"d":"23,506,575.41"}},{"$f":"BOQ!I52","v":{"v":23504309.650000002,"d":"23,504,309.65"}},{"$f":"E31-D31","v":{"v":-2265.7609999999404,"d":"-2,265.76"}},{"$f":"F31/E31","v":{"v":-9.63976833924982e-05,"d":"-0.01%"}}]
[null,"Variation Of Prices",{"v":0.05,"d":"5.00%"},{"$f":"C32*$D$30","v":{"v":23506575.411000002,"d":"23,506,575.41"}},{"$f":"BOQ!I53","v":{"v":23504309.650000002,"d":"23,504,309.65"}},{"$f":"E32-D32","v":{"v":-2265.7609999999404,"d":"-2,265.76"}},{"$f":"F32/E32","v":{"v":-9.63976833924982e-05,"d":"-0.01%"}}]
[null,"SUBTOTAL (EXCLUDING VAT)",null,{"$f":"SUM(D30:D32)","v":{"v":517144659.04200006,"d":"517,144,659.04"}}]
[null,"VAT",{"v":0.075,"d":"7.50%"},{"$f":"C34*$D$33","v":{"v":38785849.428150006,"d":"38,785,849.43"}},{"$f":"BOQ!I55","v":{"v":38782110.92249999,"d":"38,782,110.92"}},{"v":-3738.505650013685,"d":"-3,738.51"},{"$f":"F34/E34","v":{"v":-9.6397683392853637E-5,"d":"-0.01%"}}]
[{"$nulls":3},{"$f":"SUM(D33:D34)","v":{"v":555930508.4701501,"d":"555,930,508.47"}},{"$f":"BOQ!I56","v":{"v":555876923.2225,"d":"555,876,923.22"}},{"$f":"E35-D35","v":{"v":-53585.247650146484,"d":"-53,585.25"}},{"$f":"F35/E35","v":{"v":-9.6397683392764272E-5,"d":"-0.01%"}}]
[]
[null,"Project Markup Factor",{"$f":"ROUND(D24/D8,3)","v":4.171}]

{"sheet":"01 Material Prices","index":2,"n_rows":17,"n_cols":10,"rows_kept":17}
["S/NO","MATERIAL PRICES","AMOUNT","UNIT",null,null,"Vendor Price Adjustment"]
[{"v":1,"d":"1.0"},"CEMENT  N / TON",{"$f":"C3*20","v":{"v":75712.5,"d":"75,712.5"}},"COST / TON",null,null,"Material Supplied to Site",null,225,150]
[{"v":2,"d":"2.0"},"CEMENT  N / BAG",{"$f":"I17","v":{"v":3785.625,"d":"3,785.6"}},"COST / BAG",null,1,"Suppply 225mm Sandcrete Block",null,230,190]
[{"v":3,"d":"3.0"},"CHIPPINGS",{"v":12500,"d":"12,500.0"},"COST / M3",null,null,"Transportation",null,5,5]
[{"v":4,"d":"4.0"},"SAND",{"v":3000,"d":"3,000.0"},{"$f":"D4","v":"COST / M3"},null,null,"Loading & Offloading",null,5,5]
[{"v":5,"d":"5.0"},"STONE DUST",{"v":12500,"d":"12,500.0"},{"$f":"D4","v":"COST / M3"},null,null,"Subtotal",null,{"$f":"SUM(I3:I5)","v":{"v":240,"d":"240.0"}},{"$f":"SUM(J3:J5)","v":{"v":200,"d":"200.0"}}]
[{"v":6,"d":"6.0"},"STONE BASE",{"v":10353,"d":"10,353.0"},{"$f":"D4","v":"COST / M3"},null,null,"VAT",{"v":0.075,"d":"7.50%"},{"$f":"I6*H7","v":18},{"$f":"J6*H7","v":15}]
[{"v":7,"d":"7.0"},"HARD CORE   ",{"v":10370,"d":"10,370.0"},{"$f":"D5","v":"COST / M3"},null,null,"WHT",{"v":0.05,"d":"5.00%"},{"$f":"I6*H8","v":12},{"$f":"J6*H8","v":10}]
[{"v":8,"d":"8.0"},"225 BLOCK",{"$f":"I9","v":{"v":270,"d":"270.0"}},"COST / BLOCK",{"$nulls":4},{"$f":"SUM(I6:I8)","v":{"v":270,"d":"270.0"}},{"$f":"SUM(J6:J8)","v":{"v":225,"d":"225.0"}}]
[{"v":9,"d":"9.0"},"150 BLOCK",{"$f":"J9","v":{"v":225,"d":"225.0"}},"COST / BLOCK"]
[{"v":10,"d":"10.0"},"KEROSENE",{"v":270,"d":"270.0"},"LT",null,2,"Suppply of 50kg Bag of Cement",null,3350]
[{"v":11,"d":"11.0"},"FUEL",{"v":145,"d":"145.0"},"LT",null,null,"Transportation",null,10]
[{"v":12,"d":"12.0"},"BITUMEN",{"v":395000,"d":"395,000.0"},"TON",null,null,"Loading & Offloading",null,5]
[{"$nulls":6},"Subtotal",null,{"$f":"SUM(I11:I13)","v":{"v":3365,"d":"3,365.0"}}]
[{"$nulls":6},"VAT",{"v":0.075,"d":"7.50%"},{"$f":"I14*H15","v":252.375}]
[{"$nulls":6},"WHT",{"v":0.05,"d":"5.00%"},{"$f":"I14*H16","v":168.25}]
[{"$nulls":8},{"$f":"SUM(I14:I16)","v":{"v":3785.625,"d":"3,785.6"}}]

{"sheet":"02 Equipment","index":3,"n_rows":23,"n_cols":26,"rows_kept":23}
["EQUIPMENT ","PRICE\n (CFI, Lagos)","CUSTOM\nDUTY (%)","COST OF DUTY","TOTAL COST","COST IN NAIRA ($1/N380)","EQUIPMENT LIFESPAN","DEPRECIATION","FUEL CONSUMPTION","COST OF FUEL","MAINTENANCE\n35% OF DEPRE.","FUEL COST / DAY","LUB\n8% OF FUEL","DAILY COST","OPERATOR","TOTAL\nCOST",null,"S/NO","RENTED EQUIPMENT`","RENTAL COST/\nDAY (8 HRS)","FUEL COST / DAY","OPERATOR\n COST/DY","TOTAL COST/DAY ",null,null,"EQUIPMENT COST/\nDAY (8 HRS)"]
["Asphalt Paver (2.5m)",{"v":250000,"d":"250,000.00"},{"v":0.0812,"d":"0.08"},{"$f":"C2*B2","v":{"v":20300,"d":"20,300.00"}},{"$f":"D2+B2","v":{"v":270300,"d":"270,300.00"}},{"$f":"E2*380","v":{"v":102714000,"d":"102,714,000.00"}},{"v":7,"d":"7.00"},{"$f":"F2/(G2*12*25)","v":{"v":48911.42857142857,"d":"48,911.43"}},{"v":162,"d":"162.00"},{"v":270,"d":"270.00"},{"$f":"H2*35%","v":{"v":17119,"d":"17,119.00"}},{"$f":"J2*I2","v":{"v":43740,"d":"43,740.00"}},{"$f":"L2*8%","v":{"v":3499.2000000000003,"d":"3,499.20"}},{"$f":"M2+L2+K2+H2","v":{"v":113269.62857142856,"d":"113,269.63"}},{"v":10000,"d":"10,000.00"},{"$f":"O2+N2","v":{"v":123269.62857142856,"d":"123,269.63"}},null,1,"Asphalt Paver (2.5m)",{"$f":"ROUND(Z2,-3)","v":{"v":82000,"d":"82,000.00"}},{"$f":"L2","v":{"v":43740,"d":"43,740.00"}},{"v":10000,"d":"10,000.00"},{"$f":"T2+U2+V2","v":{"v":135740,"d":"135,740.00"}},null,null,{"v":81871.39,"d":"81,871.39"}]
["Backhoe Loader",{"v":100000,"d":"100,000.00"},{"v":0.0812,"d":"0.08"},{"$f":"C3*B3","v":{"v":8119.999999999999,"d":"8,120.00"}},{"$f":"D3+B3","v":{"v":108120,"d":"108,120.00"}},{"$f":"E3*380","v":{"v":41085600,"d":"41,085,600.00"}},{"v":7,"d":"7.00"},{"$f":"F3/(G3*12*25)","v":{"v":19564.571428571428,"d":"19,564.57"}},{"v":90,"d":"90.00"},{"v":270,"d":"270.00"},{"$f":"H3*35%","v":{"v":6847.599999999999,"d":"6,847.60"}},{"$f":"J3*I3","v":{"v":24300,"d":"24,300.00"}},{"$f":"L3*8%","v":{"v":1944,"d":"1,944.00"}},{"$f":"M3+L3+K3+H3","v":{"v":52656.171428571426,"d":"52,656.17"}},{"v":10000,"d":"10,000.00"},{"$f":"O3+N3","v":{"v":62656.171428571426,"d":"62,656.17"}},null,2,"Backhoe Loader",{"$f":"ROUND(Z3,-3)","v":{"v":37000,"d":"37,000.00"}},{"$f":"L3","v":{"v":24300,"d":"24,300.00"}},{"v":10000,"d":"10,000.00"},{"$f":"T3+U3+V3","v":{"v":71300,"d":"71,300.00"}},null,null,{"v":36920.85,"d":"36,920.85"}]
["Bitumen Sprayer",{"v":174609.75316455695,"d":"174,609.75"},{"v":0.0812,"d":"0.08"},{"v":14178.311956962023,"d":"14,178.31"},{"v":188788.06512151897,"d":"188,788.07"},{"v":71739464.74617721,"d":"71,739,464.75"},{"v":7,"d":"7.00"},{"v":34161.649879132005,"d":"34,161.65"},{"v":100,"d":"100.00"},{"v":270,"d":"270.00"},{"v":11956.577457696201,"d":"11,956.58"},{"v":27000,"d":"27,000.00"},{"v":2160,"d":"2,160.00"},{"v":75278.2273368282,"d":"75,278.23"},{"v":10000,"d":"10,000.00"},{"v":85278.2273368282,"d":"85,278.23"},null,3,"Bitumen Sprayer",{"v":48000,"d":"48,000.00"},{"v":27000,"d":"27,000.00"},{"v":10000,"d":"10,000.00"},{"v":85000,"d":"85,000.00"},null,null,{"v":47802.82,"d":"47,802.82"}]
["CAT Bulldozer D9",{"v":666667,"d":"666,667.00"},{"v":0.0812,"d":"0.08"},{"v":54133.3604,"d":"54,133.36"},{"v":720800.3604,"d":"720,800.36"},{"v":273904136.952,"d":"273,904,136.95"},{"v":7,"d":"7.00"},{"v":130430.54140571429,"d":"130,430.54"},{"v":468,"d":"468.00"},{"v":270,"d":"270.00"},{"v":45650.689492,"d":"45,650.69"},{"v":126360,"d":"126,360.00"},{"v":10108.800000000001,"d":"10,108.80"},{"v":312550.0308977143,"d":"312,550.03"},{"v":10000,"d":"10,000.00"},{"v":322550.0308977143,"d":"322,550.03"},null,4,"CAT Bulldozer D9",{"v":236000,"d":"236,000.00"},{"v":126360,"d":"126,360.00"},{"v":10000,"d":"10,000.00"},{"v":372360,"d":"372,360.00"},null,null,{"v":236119.45,"d":"236,119.45"}]
["Cement Silos",{"v":10000,"d":"10,000.00"},{"v":0.23120000000000002,"d":"0.23"},{"v":2312,"d":"2,312.00"},{"v":12312,"d":"12,312.00"},{"v":4678560,"d":"4,678,560.00"},{"v":5,"d":"5.00"},{"v":3119.04,"d":"3,119.04"},{"v":0,"d":"0.00"},{"v":270,"d":"270.00"},{"v":1091.664,"d":"1,091.66"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":4210.704,"d":"4,210.70"},{"v":10000,"d":"10,000.00"},{"v":14210.704,"d":"14,210.70"},null,5,"Cement Silos",{"v":2000,"d":"2,000.00"},{"v":0,"d":"0.00"},{"v":10000,"d":"10,000.00"},{"v":12000,"d":"12,000.00"},null,null,{"v":1702.13,"d":"1,702.13"}]
["Compressor 7Bar",{"v":30000,"d":"30,000.00"},{"v":0.13119999999999998,"d":"0.13"},{"v":3935.9999999999995,"d":"3,936.00"},{"v":33936,"d":"33,936.00"},{"v":12895680,"d":"12,895,680.00"},{"v":5,"d":"5.00"},{"v":8597.12,"d":"8,597.12"},{"v":123,"d":"123.00"},{"v":270,"d":"270.00"},{"v":3008.992,"d":"3,008.99"},{"v":33210,"d":"33,210.00"},{"v":2656.8,"d":"2,656.80"},{"v":47472.912000000004,"d":"47,472.91"},{"v":10000,"d":"10,000.00"},{"v":57472.912000000004,"d":"57,472.91"},null,6,"Compressor 7Bar",{"v":41000,"d":"41,000.00"},{"v":33210,"d":"33,210.00"},{"v":10000,"d":"10,000.00"},{"v":84210,"d":"84,210.00"},null,null,{"v":40558.45,"d":"40,558.45"}]
["Double Drum  Roller 10Ton",{"v":110000,"d":"110,000.00"},{"v":0.0812,"d":"0.08"},{"v":8932,"d":"8,932.00"},{"v":118932,"d":"118,932.00"},{"v":45194160,"d":"45,194,160.00"},{"v":7,"d":"7.00"},{"v":21521.02857142857,"d":"21,521.03"},{"v":100,"d":"100.00"},{"v":270,"d":"270.00"},{"v":7532.36,"d":"7,532.36"},{"v":27000,"d":"27,000.00"},{"v":2160,"d":"2,160.00"},{"v":58213.38857142857,"d":"58,213.39"},{"v":10000,"d":"10,000.00"},{"v":68213.38857142857,"d":"68,213.39"},null,7,"Double Drum  Roller 10Ton",{"v":41000,"d":"41,000.00"},{"v":27000,"d":"27,000.00"},{"v":10000,"d":"10,000.00"},{"v":78000,"d":"78,000.00"},null,null,{"v":40904.54,"d":"40,904.54"}]
["Double Drum  Roller 8Ton",{"v":90000,"d":"90,000.00"},{"v":0.0812,"d":"0.08"},{"v":7307.999999999999,"d":"7,308.00"},{"v":97308,"d":"97,308.00"},{"v":36977040,"d":"36,977,040.00"},{"v":7,"d":"7.00"},{"v":17608.114285714284,"d":"17,608.11"},{"v":100,"d":"100.00"},{"v":270,"d":"270.00"},{"v":6162.839999999999,"d":"6,162.84"},{"v":27000,"d":"27,000.00"},{"v":2160,"d":"2,160.00"},{"v":52930.95428571428,"d":"52,930.95"},{"v":10000,"d":"10,000.00"},{"v":62930.95428571428,"d":"62,930.95"},null,8,"Double Drum  Roller 8Ton",{"v":42000,"d":"42,000.00"},{"v":27000,"d":"27,000.00"},{"v":10000,"d":"10,000.00"},{"v":79000,"d":"79,000.00"},null,null,{"v":41627.59,"d":"41,627.59"}]
["Excavator (2 M3 ) ",{"v":381600,"d":"381,600.00"},{"v":0.0812,"d":"0.08"},{"v":30985.92,"d":"30,985.92"},{"v":412585.92,"d":"412,585.92"},{"v":156782649.6,"d":"156,782,649.60"},{"v":7,"d":"7.00"},{"v":74658.40457142857,"d":"74,658.40"},{"v":200,"d":"200.00"},{"v":270,"d":"270.00"},{"v":26130.4416,"d":"26,130.44"},{"v":54000,"d":"54,000.00"},{"v":4320,"d":"4,320.00"},{"v":159108.84617142857,"d":"159,108.85"},{"v":10000,"d":"10,000.00"},{"v":169108.84617142857,"d":"169,108.85"},null,9,"Excavator (2 M3 ) ",{"v":99000,"d":"99,000.00"},{"v":54000,"d":"54,000.00"},{"v":10000,"d":"10,000.00"},{"v":163000,"d":"163,000.00"},null,null,{"v":99062.86,"d":"99,062.86"}]
["Motor Grader 270 HP",{"v":400000,"d":"400,000.00"},{"v":0.0812,"d":"0.08"},{"v":32479.999999999996,"d":"32,480.00"},{"v":432480,"d":"432,480.00"},{"v":164342400,"d":"164,342,400.00"},{"v":7,"d":"7.00"},{"v":78258.28571428571,"d":"78,258.29"},{"v":232,"d":"232.00"},{"v":270,"d":"270.00"},{"v":27390.399999999998,"d":"27,390.40"},{"v":62640,"d":"62,640.00"},{"v":5011.2,"d":"5,011.20"},{"v":173299.88571428572,"d":"173,299.89"},{"v":10000,"d":"10,000.00"},{"v":183299.88571428572,"d":"183,299.89"},null,10,"Motor Grader 270 HP",{"v":110000,"d":"110,000.00"},{"v":62640,"d":"62,640.00"},{"v":10000,"d":"10,000.00"},{"v":182640,"d":"182,640.00"},null,null,{"v":110358.6,"d":"110,358.60"}]
["Pneumatic Roller 23Ton ",{"v":112000,"d":"112,000.00"},{"v":0.0812,"d":"0.08"},{"v":9094.4,"d":"9,094.40"},{"v":121094.4,"d":"121,094.40"},{"v":46015872,"d":"46,015,872.00"},{"v":7,"d":"7.00"},{"v":21912.32,"d":"21,912.32"},{"v":100,"d":"100.00"},{"v":270,"d":"270.00"},{"v":7669.311999999999,"d":"7,669.31"},{"v":27000,"d":"27,000.00"},{"v":2160,"d":"2,160.00"},{"v":58741.632,"d":"58,741.63"},{"v":10000,"d":"10,000.00"},{"v":68741.632,"d":"68,741.63"},null,11,"Pneumatic Roller 23Ton ",{"v":45000,"d":"45,000.00"},{"v":27000,"d":"27,000.00"},{"v":10000,"d":"10,000.00"},{"v":82000,"d":"82,000.00"},null,null,{"v":44675.22,"d":"44,675.22"}]
["Plate Compactor 1.0Ton ",{"v":6000,"d":"6,000.00"},{"v":0.0812,"d":"0.08"},{"v":487.2,"d":"487.20"},{"v":6487.2,"d":"6,487.20"},{"v":2465136,"d":"2,465,136.00"},{"v":5,"d":"5.00"},{"v":1643.424,"d":"1,643.42"},{"v":31.5,"d":"31.50"},{"v":270,"d":"270.00"},{"v":575.1984,"d":"575.20"},{"v":8505,"d":"8,505.00"},{"v":680.4,"d":"680.40"},{"v":11404.022399999998,"d":"11,404.02"},{"v":10000,"d":"10,000.00"},{"v":21404.022399999998,"d":"21,404.02"},null,12,"Plate Compactor 1.0Ton ",{"v":5000,"d":"5,000.00"},{"v":8505,"d":"8,505.00"},{"v":10000,"d":"10,000.00"},{"v":23505,"d":"23,505.00"},null,null,{"v":5270.86,"d":"5,270.86"}]
["Single Drum Sheep Foot Compactor, 11Ton",{"v":101000,"d":"101,000.00"},{"v":0.0812,"d":"0.08"},{"v":8201.199999999999,"d":"8,201.20"},{"v":109201.2,"d":"109,201.20"},{"v":41496456,"d":"41,496,456.00"},{"v":7,"d":"7.00"},{"v":19760.217142857142,"d":"19,760.22"},{"v":110,"d":"110.00"},{"v":270,"d":"270.00"},{"v":6916.075999999999,"d":"6,916.08"},{"v":29700,"d":"29,700.00"},{"v":2376,"d":"2,376.00"},{"v":58752.29314285715,"d":"58,752.29"},{"v":10000,"d":"10,000.00"},{"v":68752.29314285715,"d":"68,752.29"},null,13,"Single Drum Sheep Foot Compactor, 11Ton",{"v":43000,"d":"43,000.00"},{"v":29700,"d":"29,700.00"},{"v":10000,"d":"10,000.00"},{"v":82700,"d":"82,700.00"},null,null,{"v":42859.62,"d":"42,859.62"}]
["Single Drum Soil Compactor, 10Ton",{"v":109282.37974683545,"d":"109,282.38"},{"v":0.0812,"d":"0.08"},{"v":8873.729235443037,"d":"8,873.73"},{"v":118156.10898227849,"d":"118,156.11"},{"v":44899321.413265824,"d":"44,899,321.41"},{"v":7,"d":"7.00"},{"v":21380.629244412296,"d":"21,380.63"},{"v":100,"d":"100.00"},{"v":270,"d":"270.00"},{"v":7483.220235544303,"d":"7,483.22"},{"v":27000,"d":"27,000.00"},{"v":2160,"d":"2,160.00"},{"v":58023.849479956596,"d":"58,023.85"},{"v":10000,"d":"10,000.00"},{"v":68023.8494799566,"d":"68,023.85"},null,14,"Single Drum Soil Compactor, 10Ton",{"v":41000,"d":"41,000.00"},{"v":27000,"d":"27,000.00"},{"v":10000,"d":"10,000.00"},{"v":78000,"d":"78,000.00"},null,null,{"v":40827.92,"d":"40,827.92"}]
["Sweeping Machine",{"v":200000,"d":"200,000.00"},{"v":0.0812,"d":"0.08"},{"v":16239.999999999998,"d":"16,240.00"},{"v":216240,"d":"216,240.00"},{"v":82171200,"d":"82,171,200.00"},{"v":7,"d":"7.00"},{"v":39129.142857142855,"d":"39,129.14"},{"v":80,"d":"80.00"},{"v":270,"d":"270.00"},{"v":13695.199999999999,"d":"13,695.20"},{"v":21600,"d":"21,600.00"},{"v":1728,"d":"1,728.00"},{"v":76152.34285714285,"d":"76,152.34"},{"v":10000,"d":"10,000.00"},{"v":86152.34285714285,"d":"86,152.34"},null,15,"Sweeping Machine",{"v":45000,"d":"45,000.00"},{"v":21600,"d":"21,600.00"},{"v":10000,"d":"10,000.00"},{"v":76600,"d":"76,600.00"},null,null,{"v":44681.7,"d":"44,681.70"}]
["Tipper Truck- 16M3",{"v":101000,"d":"101,000.00"},{"v":0.13119999999999998,"d":"0.13"},{"v":13251.199999999999,"d":"13,251.20"},{"v":114251.2,"d":"114,251.20"},{"v":43415456,"d":"43,415,456.00"},{"v":5,"d":"5.00"},{"v":28943.637333333332,"d":"28,943.64"},{"v":140,"d":"140.00"},{"v":270,"d":"270.00"},{"v":10130.273066666665,"d":"10,130.27"},{"v":37800,"d":"37,800.00"},{"v":3024,"d":"3,024.00"},{"v":79897.9104,"d":"79,897.91"},{"v":10000,"d":"10,000.00"},{"v":89897.9104,"d":"89,897.91"},null,16,"Tipper Truck- 16M3",{"v":61000,"d":"61,000.00"},{"v":37800,"d":"37,800.00"},{"v":10000,"d":"10,000.00"},{"v":108800,"d":"108,800.00"},null,null,{"v":61317.81,"d":"61,317.81"}]
["Tipper Dumper Truck- 14M3",{"v":118000,"d":"118,000.00"},{"v":0.38120000000000004,"d":"0.38"},{"v":44981.600000000006,"d":"44,981.60"},{"v":162981.6,"d":"162,981.60"},{"v":61933008,"d":"61,933,008.00"},{"v":5,"d":"5.00"},{"v":41288.672,"d":"41,288.67"},{"v":140,"d":"140.00"},{"v":270,"d":"270.00"},{"v":14451.035199999998,"d":"14,451.04"},{"v":37800,"d":"37,800.00"},{"v":3024,"d":"3,024.00"},{"v":96563.7072,"d":"96,563.71"},{"v":10000,"d":"10,000.00"},{"v":106563.7072,"d":"106,563.71"},null,17,"Tipper Dumper Truck- 14M3",{"v":70000,"d":"70,000.00"},{"v":37800,"d":"37,800.00"},{"v":10000,"d":"10,000.00"},{"v":117800,"d":"117,800.00"},null,null,{"v":70058.82,"d":"70,058.82"}]
["Tipping Trailler Truck- 35 Ton",{"v":145000,"d":"145,000.00"},{"v":0.13119999999999998,"d":"0.13"},{"v":19023.999999999996,"d":"19,024.00"},{"v":164024,"d":"164,024.00"},{"v":62329120,"d":"62,329,120.00"},{"v":5,"d":"5.00"},{"v":41552.746666666666,"d":"41,552.75"},{"v":164.7058823529412,"d":"164.71"},{"v":270,"d":"270.00"},{"v":14543.461333333333,"d":"14,543.46"},{"v":44470.58823529412,"d":"44,470.59"},{"v":3557.6470588235297,"d":"3,557.65"},{"v":104124.44329411765,"d":"104,124.44"},{"v":10000,"d":"10,000.00"},{"v":114124.44329411765,"d":"114,124.44"},null,18,"Tipping Trailler Truck- 35 Ton",{"v":88000,"d":"88,000.00"},{"v":44470.58823529412,"d":"44,470.59"},{"v":10000,"d":"10,000.00"},{"v":142470.58823529413,"d":"142,470.59"},null,null,{"v":88000,"d":"88,000.00"}]
["Vibrators",{"v":6000,"d":"6,000.00"},{"v":0.0812,"d":"0.08"},{"v":487.2,"d":"487.20"},{"v":6487.2,"d":"6,487.20"},{"v":2465136,"d":"2,465,136.00"},{"v":4,"d":"4.00"},{"v":2054.28,"d":"2,054.28"},{"v":5,"d":"5.00"},{"v":270,"d":"270.00"},{"v":718.998,"d":"719.00"},{"v":1350,"d":"1,350.00"},{"v":108,"d":"108.00"},{"v":4231.278,"d":"4,231.28"},{"v":10000,"d":"10,000.00"},{"v":14231.278,"d":"14,231.28"},null,19,"Vibrators",{"v":3000,"d":"3,000.00"},{"v":1350,"d":"1,350.00"},{"v":10000,"d":"10,000.00"},{"v":14350,"d":"14,350.00"},null,null,{"v":2579.07,"d":"2,579.07"}]
["Water Tanker",{"v":115000,"d":"115,000.00"},{"v":0.13119999999999998,"d":"0.13"},{"v":15087.999999999998,"d":"15,088.00"},{"v":130088,"d":"130,088.00"},{"v":49433440,"d":"49,433,440.00"},{"v":5,"d":"5.00"},{"v":32955.62666666666,"d":"32,955.63"},{"v":100,"d":"100.00"},{"v":270,"d":"270.00"},{"v":11534.46933333333,"d":"11,534.47"},{"v":27000,"d":"27,000.00"},{"v":2160,"d":"2,160.00"},{"v":73650.09599999999,"d":"73,650.10"},{"v":10000,"d":"10,000.00"},{"v":83650.09599999999,"d":"83,650.10"},null,20,"Water Tanker",{"v":52000,"d":"52,000.00"},{"v":27000,"d":"27,000.00"},{"v":10000,"d":"10,000.00"},{"v":89000,"d":"89,000.00"},null,null,{"v":52494.54,"d":"52,494.54"}]
["Wheel Loader 2.5 M3 ",{"v":220000,"d":"220,000.00"},{"v":0.0812,"d":"0.08"},{"v":17864,"d":"17,864.00"},{"v":237864,"d":"237,864.00"},{"v":90388320,"d":"90,388,320.00"},{"v":7,"d":"7.00"},{"v":43042.05714285714,"d":"43,042.06"},{"v":190,"d":"190.00"},{"v":270,"d":"270.00"},{"v":15064.72,"d":"15,064.72"},{"v":51300,"d":"51,300.00"},{"v":4104,"d":"4,104.00"},{"v":113510.77714285714,"d":"113,510.78"},{"v":10000,"d":"10,000.00"},{"v":123510.77714285714,"d":"123,510.78"},null,21,"Wheel Loader 2.5 M3 ",{"v":79000,"d":"79,000.00"},{"v":51300,"d":"51,300.00"},{"v":10000,"d":"10,000.00"},{"v":140300,"d":"140,300.00"},null,null,{"v":78893.07,"d":"78,893.07"}]
["750L Capacity Concrete Mixer",{"v":25000,"d":"25,000.00"},{"v":0.13119999999999998,"d":"0.13"},{"v":3279.9999999999995,"d":"3,280.00"},{"v":28280,"d":"28,280.00"},{"v":10746400,"d":"10,746,400.00"},{"v":5,"d":"5.00"},{"v":7164.266666666666,"d":"7,164.27"},{"v":25,"d":"25.00"},{"v":270,"d":"270.00"},{"v":2507.493333333333,"d":"2,507.49"},{"v":6750,"d":"6,750.00"},{"v":540,"d":"540.00"},{"v":16961.76,"d":"16,961.76"},{"v":10000,"d":"10,000.00"},{"v":26961.76,"d":"26,961.76"},null,22,"750L Capacity Concrete Mixer",{"v":45000,"d":"45,000.00"},{"v":6750,"d":"6,750.00"},{"v":10000,"d":"10,000.00"},{"v":61750,"d":"61,750.00"}]

{"sheet":"03 Labour","index":4,"n_rows":6,"n_cols":7,"rows_kept":6}
["S/NO","CATEGORY","RATE/DY","RATE/HR","QTY","DUR\n(12mths x 25dys)","AMOUNT"]
[1,"Unskilled Labour",{"v":2500,"d":"2,500.00"},{"$f":"C2/8","v":{"v":312.5,"d":"312.50"}},{"v":65,"d":"65.00"},{"$f":"11*25","v":{"v":275,"d":"275.00"}},{"$f":"F2*E2*C2","v":{"v":44687500,"d":"44,687,500.00"}}]
[2,"Semi Skilled",{"v":3500,"d":"3,500.00"},{"$f":"C3/8","v":{"v":437.5,"d":"437.50"}},{"v":40,"d":"40.00"},{"$f":"11*25","v":{"v":275,"d":"275.00"}},{"$f":"F3*E3*C3","v":{"v":38500000,"d":"38,500,000.00"}}]
[3,"Skilled",{"v":5000,"d":"5,000.00"},{"v":625,"d":"625.00"},{"v":18,"d":"18.00"},{"v":275,"d":"275.00"},{"v":24750000,"d":"24,750,000.00"}]
[4,"Operator",{"v":10000,"d":"10,000.00"},{"v":1250,"d":"1,250.00"},{"v":7,"d":"7.00"},{"v":275,"d":"275.00"},{"v":19250000,"d":"19,250,000.00"}]
[{"$nulls":6},{"$f":"SUM(G2:G5)","v":{"v":127187500,"d":"127,187,500.00"}}]

{"sheet":"04 Subcontract","index":5,"n_rows":22,"n_cols":13,"rows_kept":22,"merged":[[0,0,0,12],[1,4,1,6],[1,7,1,9],[1,10,1,12],[2,4,2,6],[2,7,2,9],[2,10,2,12],[3,5,3,6],[3,8,3,9],[3,11,3,12],[4,5,4,6],[4,8,4,9],[4,11,4,12],[5,5,5,6],[5,8,5,9],[5,11,5,12],[19,4,19,6],[19,7,19,9],[19,10,19,12],[20,4,20,6],[20,7,20,9],[20,10,20,12],[21,4,21,6],[21,7,21,9],[21,10,21,12]]}
["SUBCONTRACTOR ADJUDICATION"]
[{"$nulls":4},"Subcontractor 1",null,null,"Subcontractor 2",null,null,"Subcontractor 3"]
[null,"ALUMINIUM WINDOWS AND SUB FRAMES",null,null,{"$f":"G19","v":{"v":25715604.330000006,"d":"25,715,604.33"}},null,null,{"$f":"J19","v":{"v":25690538.1375,"d":"25,690,538.14"}},null,null,{"$f":"M19","v":{"v":25981687.631249998,"d":"25,981,687.63"}}]
[{"$nulls":4},{"$f":"50000/G7","v":{"v":2.1693856299895868E-3,"d":"0.22%"}},"Transportation",null,{"$f":"150000/J7","v":{"v":0.006721333512568894,"d":"0.67%"}},"Transportation",null,{"$f":"250000/M7","v":{"v":0.010494500881538074,"d":"1.05%"}},"Transportation"]
[null,"Accepted Quotation","Sub 2",null,{"v":0.01,"d":"1.00%"},"Stamp Duty",null,{"v":0.01,"d":"1.00%"},"Stamp Duty",null,{"v":0.01,"d":"1.00%"},"Stamp Duty"]
[{"$nulls":4},{"v":0.005,"d":"0.50%"},"Special Charge",null,{"v":0.02,"d":"2.00%"},"Special Charge",null,{"v":0,"d":"0.00%"},"Special Charge"]
[{"$nulls":4},"Factor",{"$f":"ROUND(SUM(E4:E6),4)+1","v":{"v":1.0172,"d":"1.017"}},{"$f":"E10*$C10+E13*$C13","v":{"v":23048000,"d":"23,048,000.00"}},"Factor",{"$f":"ROUND(SUM(H4:H6),4)+1","v":{"v":1.0367,"d":"1.037"}},{"$f":"H10*$C10+H13*$C13","v":{"v":22317000,"d":"22,317,000.00"}},"Factor",{"$f":"ROUND(SUM(K4:K6),4)+1","v":{"v":1.0205,"d":"1.021"}},{"$f":"K10*$C10+K13*$C13","v":{"v":23822000,"d":"23,822,000.00"}}]
["REF","DESCRIPTION","QTY","UNIT","RATE","ADJUSTED","AMOUNT","RATE","ADJUSTED","AMOUNT","RATE","ADJUSTED","AMOUNT"]
[null,"1.23 WINDOWS, SCREENS AND LIGHTS"]
["1.1.0","Aluminium Windows and Window frames, 1.5x1.5m high) finished with 5mm thick tinted glass, fixed to pre-installed 25mm square pipe subframe burined in concrete/blockworks",{"$f":"BOQ!C23","v":{"v":86,"d":"86.00"}},"nr",{"v":250000,"d":"250,000"},{"$f":"E10*F$7","v":{"v":254300.00000000003,"d":"254,300.00"}},{"$f":"F10*$C10","v":{"v":21869800.000000004,"d":"21,869,800.00"}},{"v":245000,"d":"245,000"},{"$f":"H10*I$7","v":{"v":253991.5,"d":"253,991.50"}},{"$f":"I10*$C10","v":{"v":21843269,"d":"21,843,269.00"}},{"v":265000,"d":"265,000"},{"$f":"K10*L$7","v":{"v":270432.5,"d":"270,432.50"}},{"$f":"L10*$C10","v":{"v":23257195,"d":"23,257,195.00"}}]
[]
[null,"1.26 METAL WORK"]
["2.1.0.2","General Metal work members, 25mm square pipe subframe; 1.5x1.5m high, buried in concrete/blockworks with cement moratr 1:5",{"$f":"BOQ!C26","v":{"v":86,"d":"86.00"}},"nr",{"v":18000,"d":"18,000"},{"$f":"E13*F$7","v":{"v":18309.600000000002,"d":"18,309.60"}},{"$f":"F13*$C13","v":{"v":1574625.6,"d":"1,574,625.60"}},{"v":14500,"d":"14,500"},{"$f":"H13*I$7","v":{"v":15032.15,"d":"15,032.15"}},{"$f":"I13*$C13","v":{"v":1292764.9,"d":"1,292,764.90"}},{"v":12000,"d":"12,000"},{"$f":"K13*L$7","v":{"v":12246,"d":"12,246.00"}},{"$f":"L13*$C13","v":{"v":1053156,"d":"1,053,156.00"}}]
[null,"Subtotal 1",{"$nulls":4},{"$f":"SUM(G10:G13)","v":{"v":23444425.600000005,"d":"23,444,425.60"}},null,null,{"$f":"SUM(J10:J13)","v":{"v":23136033.9,"d":"23,136,033.90"}},null,null,{"$f":"SUM(M10:M13)","v":{"v":24310351,"d":"24,310,351.00"}}]
[null,"Discount Offered",null,null,{"v":0.025,"d":"2.5%"},null,{"$f":"G14*E15","v":{"v":586110.6400000001,"d":"586,110.64"}},null,null,{"v":300000,"d":"300,000.00"},{"v":0.05,"d":"5.0%"},null,{"$f":"M14*K15","v":{"v":1215517.55,"d":"1,215,517.55"}}]
[null,"Subtotal 2",{"$nulls":4},{"$f":"G14-G15","v":{"v":22858314.960000005,"d":"22,858,314.96"}},null,null,{"$f":"J14-J15","v":{"v":22836033.9,"d":"22,836,033.90"}},null,null,{"$f":"M14-M15","v":{"v":23094833.45,"d":"23,094,833.45"}}]
[null,"VAT",{"v":0.075,"d":"7.5%"},{"$nulls":3},{"$f":"G$16*$C17","v":{"v":1714373.6220000002,"d":"1,714,373.62"}},null,null,{"$f":"J$16*$C17","v":{"v":1712702.5424999997,"d":"1,712,702.54"}},null,null,{"$f":"M$16*$C17","v":{"v":1732112.5087499998,"d":"1,732,112.51"}}]
[null,"WHT",{"v":0.05,"d":"5.0%"},{"$nulls":3},{"$f":"G$16*$C18","v":{"v":1142915.7480000004,"d":"1,142,915.75"}},null,null,{"$f":"J$16*$C18","v":{"v":1141801.695,"d":"1,141,801.70"}},null,null,{"$f":"M$16*$C18","v":{"v":1154741.6725,"d":"1,154,741.67"}}]
[null,"TOTAL",{"$nulls":4},{"$f":"SUM(G16:G18)","v":{"v":25715604.330000006,"d":"25,715,604.33"}},null,null,{"$f":"SUM(J16:J18)","v":{"v":25690538.1375,"d":"25,690,538.14"}},null,null,{"$f":"SUM(M16:M18)","v":{"v":25981687.631249998,"d":"25,981,687.63"}}]
[null,"Payment Term",null,null,{"v":0.5,"d":"50%"},null,null,{"v":0.8,"d":"80%"},null,null,{"v":0.65,"d":"65%"}]
[null,"Delivery Period",null,null,"2 Weeks",null,null,"1 Weeks",null,null,"3 Weeks"]
[null,"Completion Period",null,null,"3 Weeks",null,null,"1 Weeks",null,null,"2 Weeks"]

{"sheet":"05 Built-in Preliminaries","index":6,"n_rows":53,"n_cols":10,"rows_kept":53,"merged":[[52,7,52,8]]}
["REF","S/NO","PRELIMINARY ITEM","QTY","RATE","DUR","AMOUNT","FIXED","TIME"]
[]
["A",null,"PROJECT STAFF"]
[null,1,"Project Manager",1,{"v":300000,"d":"300,000"},12,{"$f":"F4*E4*D4","v":{"v":3600000,"d":"3,600,000"}}]
[null,2,"Quantity Surveyor",1,{"v":250000,"d":"250,000"},10,{"$f":"F5*E5*D5","v":{"v":2500000,"d":"2,500,000"}}]
[null,3,"Assistant QS",1,{"v":180000,"d":"180,000"},8,{"v":1440000,"d":"1,440,000"}]
[null,4,"Site Engineer",2,{"v":200000,"d":"200,000"},12,{"v":4800000,"d":"4,800,000"}]
[null,5,"Accountant",1,{"v":145000,"d":"145,000"},12,{"v":1740000,"d":"1,740,000"}]
[{"$nulls":6},{"$f":"SUM(G4:G8)","v":{"v":14080000,"d":"14,080,000"}},null,{"$f":"G9","v":{"v":14080000,"d":"14,080,000.00"}}]
[]
["B",null,"SITE ACCOMMODATION"]
[null,1,"Site Office (Portacabin- 80m2)",80,{"v":85000,"d":"85,000"},1,{"$f":"F12*E12*D12","v":{"v":6800000,"d":"6,800,000"}},{"$f":"G12","v":{"v":6800000,"d":"6,800,000.00"}}]
[null,2,"staff Accommodation (2 flats)",2,{"v":1200000,"d":"1,200,000"},1,{"v":2400000,"d":"2,400,000"},{"$f":"G13","v":{"v":2400000,"d":"2,400,000.00"}}]
[{"$nulls":6},{"$f":"SUM(G12:G13)","v":{"v":9200000,"d":"9,200,000"}}]
[]
["C",null,"TRANSPORTATION"]
[null,1,"Worker Bus (Hiace)",1,{"v":26000000,"d":"26,000,000"},1,{"$f":"F17*E17*D17","v":{"v":26000000,"d":"26,000,000"}}]
[null,2,"Site Project Vehicle (Hilux)",1,{"v":22550000,"d":"22,550,000"},1,{"v":22550000,"d":"22,550,000"}]
[{"$nulls":4},"Instalmental Recovery",4,{"$f":"SUM(G17:G18)/F19","v":{"v":12137500,"d":"12,137,500"}},{"$f":"G19","v":{"v":12137500,"d":"12,137,500.00"}},{"$f":"H19*3","v":{"v":36412500,"d":"36,412,500.00"}},{"$f":"I19","v":{"v":36412500,"d":"36,412,500.00"}}]
[]
["D",null,"SCAFFOLDING/SHUTTERING"]
[null,1,"Scaffolding (2000m2)",2000,250,{"$f":"12*25","v":300},{"$f":"F22*E22*D22","v":{"v":150000000,"d":"150,000,000"}}]
[null,2,"Shuttering",1500,80,{"$f":"F22","v":300},{"v":36000000,"d":"36,000,000"}]
[{"$nulls":4},"Instalmental Recovery",5,{"$f":"SUM(G22:G23)/F24","v":{"v":37200000,"d":"37,200,000"}},null,{"$f":"G24*F24","v":{"v":186000000,"d":"186,000,000.00"}},{"$f":"I24-G24","v":{"v":148800000,"d":"148,800,000.00"}}]
[]
["E",null,"SITE EQUIPMENT"]
[null,1,"CAT Bulldozer D9",1,{"$f":"'02 Equipment'!T5","v":{"v":236000,"d":"236,000"}},{"$f":"6*25","v":150},{"$f":"F27*E27*D27","v":{"v":35400000,"d":"35,400,000"}}]
[null,2,"Compressor 7Bar",2,{"$f":"'02 Equipment'!T7","v":{"v":41000,"d":"41,000"}},{"$f":"4*25","v":100},{"v":8200000,"d":"8,200,000"}]
[null,3,"Double Drum  Roller 10Ton",1,{"$f":"'02 Equipment'!T8","v":{"v":41000,"d":"41,000"}},{"$f":"3*25","v":75},{"v":3075000,"d":"3,075,000"}]
[null,4,"Double Drum  Roller 8Ton",1,{"$f":"'02 Equipment'!T9","v":{"v":42000,"d":"42,000"}},{"$f":"F29","v":75},{"v":3150000,"d":"3,150,000"}]
[null,5,"Excavator (2 M3 ) ",1,{"$f":"'02 Equipment'!T10","v":{"v":99000,"d":"99,000"}},{"$f":"6*25","v":150},{"v":14850000,"d":"14,850,000"}]
[null,6,"Motor Grader 270 HP",1,{"$f":"'02 Equipment'!T11","v":{"v":110000,"d":"110,000"}},{"$f":"F30","v":75},{"v":8250000,"d":"8,250,000"}]
[{"$nulls":6},{"$f":"SUM(G27:G32)","v":{"v":72925000,"d":"72,925,000"}},null,{"$f":"G33","v":{"v":72925000,"d":"72,925,000.00"}}]
[]
["F",null,"INSURANCE & BOND"]
[null,1,"Project Insurance",1,{"v":542600000,"d":"542,600,000"},{"v":0.0025,"d":"0.25%"},{"$f":"F36*E36*D36","v":{"v":1356500,"d":"1,356,500"}}]
[null,2,"Equipment Insurance",1,{"$f":"G33","v":{"v":72925000,"d":"72,925,000"}},{"v":0.05,"d":"5.00%"},{"$f":"F37*E37*D37","v":{"v":3646250,"d":"3,646,250"}}]
[null,3,"Advance Payment Guarantee",{"v":0.15,"d":"15.0%"},{"$f":"E36","v":{"v":542600000,"d":"542,600,000"}},{"v":2E-3,"d":"0.20%"},{"v":162780,"d":"162,780"}]
[null,4,"Performance Bond",{"v":0.1,"d":"10.0%"},{"$f":"E38","v":{"v":542600000,"d":"542,600,000"}},{"v":2E-3,"d":"0.20%"},{"v":108520,"d":"108,520"}]
[null,5,"Workers Insurance",1,{"$f":"'03 Labour'!G6","v":{"v":127187500,"d":"127,187,500"}},{"v":0.06,"d":"6.00%"},{"v":7631250,"d":"7,631,250"}]
[{"$nulls":6},{"$f":"SUM(G36:G40)","v":{"v":12905300,"d":"12,905,300"}},{"$f":"G41","v":{"v":12905300,"d":"12,905,300.00"}}]
[]
[]
[null,null,"SUMMARY OF BUILT-IN PREL."]
[null,"A",{"$f":"C3","v":"PROJECT STAFF"},{"$nulls":3},{"$f":"G9","v":{"v":14080000,"d":"14,080,000"}}]
[null,"B",{"$f":"C11","v":"SITE ACCOMMODATION"},{"$nulls":3},{"$f":"G14","v":{"v":9200000,"d":"9,200,000"}}]
[null,"C",{"$f":"C16","v":"TRANSPORTATION"},{"$nulls":3},{"$f":"G19","v":{"v":12137500,"d":"12,137,500"}}]
[null,"D",{"$f":"C21","v":"SCAFFOLDING/SHUTTERING"},{"$nulls":3},{"$f":"G24","v":{"v":37200000,"d":"37,200,000"}}]
[null,"E",{"$f":"C26","v":"SITE EQUIPMENT"},{"$nulls":3},{"$f":"G33","v":{"v":72925000,"d":"72,925,000"}}]
[null,"F",{"$f":"C35","v":"INSURANCE & BOND"},{"$nulls":3},{"$f":"G41","v":{"v":12905300,"d":"12,905,300"}}]
[{"$nulls":6},{"$f":"SUM(G45:G50)","v":{"v":158447800,"d":"158,447,800.0"}},{"$f":"SUM(H2:H50)","v":{"v":34242800,"d":"34,242,800.00"}},{"$f":"SUM(I2:I50)","v":{"v":309417500,"d":"309,417,500.00"}}]
[{"$nulls":7},"FIXED","TIME"]
[{"$nulls":7},{"$f":"H51+I51","v":{"v":343660300,"d":"343,660,300.00"}}]

{"sheet":"06 Material Transp.","index":7,"n_rows":22,"n_cols":5,"rows_kept":22,"merged":[[0,0,0,3]]}
["MATERIAL TRANSPORTATION COST"]
[]
[null,"Distance to Quarry",{"v":150,"d":"150.0"},"Km"]
[null,"Truck Travel Speed",{"v":55,"d":"55.0"},"Km / Hr."]
[null,"Travel time (minutes)",{"$f":"C3/C4*60","v":{"v":163.63636363636363,"d":"163.64"}},"Min."]
[null,"Total Time Return Trip",{"$f":"C5*2+10+5","v":{"v":342.27272727272725,"d":"342.27"}},"Min."]
[{"$nulls":3},"Use:"]
[null,"Trips /Tipper/ day",{"$f":"8*60/C6","v":{"v":1.402390438247012,"d":"1.40"}},{"$f":"ROUND(C8,0)","v":{"v":1,"d":"1.0"}},"Trips/Day"]
[]
[null,"Delivery Cost of Cement Transportation",{"v":350000,"d":"350,000.0"},"Cost / Trip"]
[null,"Quantity of cement per load",{"v":600,"d":"600.0"}]
[null,"CEMENT DELIVERY COST",{"$f":"C10/C11","v":{"v":583.3333333333334,"d":"583.33"}},"N / Bag"]
[]
[]
[null,"AGGREGATE HAULAGE COST"]
[{"$f":"D8","v":{"v":1,"d":"1.0"}},"Tipping Trailler Truck- 35 Ton",{"$f":"VLOOKUP(B16,'02 Equipment'!$S$2:$W$22,4,)","v":{"v":10000,"d":"10,000.00"}},{"$f":"C16*A16","v":{"v":10000,"d":"10,000.00"}}]
[{"v":1,"d":"1.0"},"Semi Skilled",{"$f":"VLOOKUP(B17,'03 Labour'!$B$2:$C$5,2,)","v":{"v":3500,"d":"3,500.00"}},{"$f":"C17*A17","v":{"v":3500,"d":"3,500.00"}}]
[{"v":1,"d":"1.0"},"Other Fees per Trip",{"v":6000,"d":"6,000.00"},{"$f":"C18*A18","v":{"v":6000,"d":"6,000.00"}}]
[{"$nulls":3},{"$f":"SUM(D16:D18)","v":{"v":19500,"d":"19,500.00"}}]
[null,"TRUCK CAPACITY",{"v":35,"d":"35.0"},"tons/ Trip"]
[]
[null,"AGGREGATE DELIVERY COST",null,{"$f":"D19/D8/C20","v":{"v":557.1428571428571,"d":"557.14"}},"N/TON"]

{"sheet":"07 ExtraOver Haulage","index":8,"n_rows":23,"n_cols":5,"rows_kept":23,"merged":[[0,0,0,3],[22,1,22,2]]}
["CALCULATION FOR EXTRA COST OF HAULAGE PER M3/KM"]
[]
[null,"CYCLE TIME CALCULATION"]
[null,"Distance  From Quarry/Burrow Pit To Site",{"v":12,"d":"12.00"},"Km"]
[null,"Tipper Speed  ( Km/Hr.)",{"v":45,"d":"45.00"},"Km / Hr."]
[null,"Time Of Travel ( Min.)",{"$f":"C4/C5*60","v":{"v":16,"d":"16.00"}},"Min."]
[null,"Time Of One Trip (Min.)",{"$f":"C6*2+10+10","v":{"v":52,"d":"52.00"}},"Min."]
[null,"No Of Trips\n/Tipper/Day",{"$f":"ROUND((6*60)/C7,0)","v":{"v":7,"d":"7.00"}}]
[]
[null,"COST OF USING EQUIPMENT"]
["NO.","ITEM","Cost ( N/day )","Total /day"]
[{"v":1,"d":"1.00"},"Tipper Dumper Truck- 14M3",{"$f":"VLOOKUP(B12,'02 Equipment'!$S$2:$W$22,4,)","v":{"v":10000,"d":"10,000.00"}},{"$f":"C12*A12","v":{"v":10000,"d":"10,000.00"}},"COST/ DAY"]
[{"v":0.5,"d":"0.50"},"Wheel Loader 2.5 M3 ",{"$f":"VLOOKUP(B13,'02 Equipment'!$S$2:$W$22,4,)","v":{"v":10000,"d":"10,000.00"}},{"$f":"C13*A13","v":{"v":5000,"d":"5,000.00"}},"COST/ DAY"]
[{"v":2,"d":"2.00"},"Operator",{"$f":"VLOOKUP(B14,'03 Labour'!$B$2:$C$5,2,)","v":{"v":10000,"d":"10,000.00"}},{"$f":"C14*A14","v":{"v":20000,"d":"20,000.00"}},"COST/ DAY"]
[null,null,"Total",{"$f":"SUM(D12:D14)","v":{"v":35000,"d":"35,000.00"}},"COST/ DAY"]
[]
[null,"HAULAGE COST"]
[null,"Total Distance Travelled by Tipper/ Day ",{"$f":"C4*2","v":{"v":24,"d":"24.00"}},"km"]
[null,"Truck capacity/ Trip (20Ton)",{"$f":"20/1.6","v":{"v":12.5,"d":"12.50"}},"m3/TRIP"]
[null,"No. Of Trips / Day",{"$f":"C8","v":{"v":7,"d":"7.00"}},"TRIP/DAY"]
[null,"Total Qty hauled / Day",{"$f":"C20*C19","v":{"v":87.5,"d":"87.50"}},"m3"]
[]
[null,"The Cost of Extra Over for Haulage (KM/M3)",null,{"$f":"D15/C18/C21","v":{"v":16.666666666666664,"d":"16.67"}},"COST/KM/m3"]

{"sheet":"08 Concrete","index":9,"n_rows":35,"n_cols":7,"rows_kept":35}
[]
["Density","CONCRETE"]
[1.6,"sand",{"$f":"'01 Material Prices'!$C$5","v":{"v":3000,"d":"3,000.00"}},"m3","20ton"]
[2.1,"granite",{"$f":"'01 Material Prices'!C4","v":{"v":12500,"d":"12,500.00"}},"m3","30ton"]
[]
[null,"Mix Ratio","Cement","Sand","Granite","m3"]
[null,null,{"v":1,"d":"1.00"},{"v":2,"d":"2.00"},{"v":4,"d":"4.00"},{"$f":"SUM(C7:E7)","v":{"v":7,"d":"7.00"}}]
[]
[null,"Shrinkage",{"v":0.45,"d":"45%"}]
[null,"Entrained Air",{"v":0.02,"d":"2%"}]
[null,"Water Cement Ratio",0.45]
[null,"Net Volume of Wet Mix",{"$nulls":3},{"$f":"(1-C10)*F7","v":{"v":6.859999999999999,"d":"6.86"}},"m3"]
[]
[null,"Standard material capacity"]
[{"$f":"C7/F12+(C7/F12)*C9","v":{"v":0.21137026239067058,"d":"0.211"}},"Cement",{"v":3850,"d":"3,850.00"},"Bag",{"$f":"A15/0.035","v":{"v":6.039150354019159,"d":"6.04"}},{"$f":"E15*C15","v":{"v":23250.728862973763,"d":"23,250.73"}}]
[{"$f":"D7/F12+(D7/F12)*C9","v":{"v":0.42274052478134116,"d":"0.423"}},"Sand ",{"$f":"C3","v":{"v":3000,"d":"3,000.00"}},"m3",null,{"$f":"C16*A16","v":{"v":1268.2215743440236,"d":"1,268.22"}}]
[{"$f":"E7/F12+(E7/F12)*C9","v":{"v":0.8454810495626823,"d":"0.845"}},"Granite",{"$f":"C4","v":{"v":12500,"d":"12,500.00"}},"m3",null,{"$f":"C17*A17","v":{"v":10568.513119533529,"d":"10,568.51"}}]
[{"$f":"A15*C11*1000","v":{"v":95.11661807580177,"d":"95.117"}},"Water for works",{"v":5,"d":"5.00"},"liter",null,{"$f":"C18*A18","v":{"v":475.5830903790088,"d":"475.58"}}]
[{"$nulls":5},{"$f":"SUM(F15:F18)","v":{"v":35563.04664723033,"d":"35,563.05"}}]
[null,"waste",{"v":0.05,"d":"5%"},null,null,{"$f":"F19*C20","v":{"v":1778.1523323615165,"d":"1,778.15"}}]
[{"$nulls":5},{"$f":"SUM(F19:F20)","v":{"v":37341.19897959185,"d":"37,341.20"}}]
[]
[null,"Mixing & Placement"]
[{"v":1,"d":"1.000"},"Concrete mixer",{"$f":"'02 Equipment'!W23","v":{"v":61750,"d":"61,750.00"}},"day",{"$f":"C24*A24","v":{"v":61750,"d":"61,750.00"}}]
[{"v":1,"d":"1.000"},"Vibrator",{"$f":"'02 Equipment'!W20","v":{"v":14350,"d":"14,350.00"}},"day",{"$f":"C25*A25","v":{"v":14350,"d":"14,350.00"}}]
[{"v":1,"d":"1.000"},"Operator",{"$f":"VLOOKUP(B26,'03 Labour'!$B$2:$D$5,2,)","v":{"v":10000,"d":"10,000.00"}},"day",{"$f":"C26*A26","v":{"v":10000,"d":"10,000.00"}}]
[{"v":20,"d":"20.000"},"Unskilled Labour",{"$f":"VLOOKUP(B27,'03 Labour'!$B$2:$D$5,2,)","v":{"v":2500,"d":"2,500.00"}},"day",{"$f":"C27*A27","v":{"v":50000,"d":"50,000.00"}}]
[{"$nulls":4},{"$f":"SUM(E24:E27)","v":{"v":136100,"d":"136,100.00"}}]
[]
[null,"Daily Output of Gang",{"$f":"150/6","v":{"v":25,"d":"25.00"}},"m3"]
[{"$nulls":4},{"$f":"E28/C30","v":{"v":5444,"d":"5,444.00"}}]
[]
[null,"Concrete",null,null,{"$f":"F21","v":{"v":37341.19897959185,"d":"37,341.20"}},"Material",{"$f":"E33/E35","v":{"v":0.8727597363144965,"d":"87%"}}]
[null,"Mixing & Placement",null,null,{"$f":"E31","v":{"v":5444,"d":"5,444.00"}},"Labour",{"$f":"E34/E35","v":{"v":0.12724026368550345,"d":"13%"}}]
[{"$nulls":4},{"$f":"SUM(E33:E34)","v":{"v":42785.19897959185,"d":"42,785.20"}}]

{"sheet":"09 Asphalt Binder","index":10,"n_rows":40,"n_cols":5,"rows_kept":40,"merged":[[0,0,0,3]]}
["BREAKDOWN OF ASPHALT BINDER COURSE"]
[]
[null,"COST  OF MATERIAL",null,"BINDER COURSE"]
[]
[null,"Asphalt concrete Purchased from Plant",null,{"v":32000,"d":"32,000.0"},"N/TON"]
[null,"Transportation Cost (18km radius)",null,{"v":2500,"d":"2,500.0"},"N/Ton"]
[null,"Toll Fees / 35ton Truck",{"v":8000,"d":"8,000.0"}]
[null,"Toll fee per Ton",null,{"$f":"C7/35","v":{"v":228.57142857142858,"d":"228.6"}},"N/Ton"]
[null,"Material Cost to Site (Ton)",null,{"$f":"SUM(D5:D8)","v":{"v":34728.57142857143,"d":"34,728.6"}},"N/TON"]
[]
[null,"Concrete Thickness",{"v":60,"d":"60.0"},"mm"]
[null,"Qty of Asphalt Concrete / m2",{"$f":"1*1*C11/1000","v":{"v":0.06,"d":"0.060"}},"m3/m2"]
[]
[null,"Compacted Density of Asphalt (Ton/m3)",2.35,"Ton / m3"]
[null,"Cost of Material per M2",null,{"$f":"D9*C12*C14","v":{"v":4896.728571428572,"d":"4,896.73"}}]
[null,"Wastes (10%)",{"v":0.1,"d":"10%"},{"$f":"D15*C16","v":{"v":489.6728571428572,"d":"489.67"}}]
["A","TOTAL COST OF EQUIPMENT",{"$f":"SUM(D15:D16)","v":{"v":5386.401428571429,"d":"5,386.40"}},"Cost/M2"]
[]
[null,"Work Output Rate per day",{"v":4000,"d":"4,000.0"},"M2 / DAY"]
[]
[null,"COST OF EQUIPMENT"]
["NO.","SPREADING & COMPACTION","Running Cost","Total ( N /DAY )"]
[{"v":1,"d":"1.00"},"Asphalt Paver (2.5m)",{"$f":"VLOOKUP(B23,'02 Equipment'!$S$2:$W$22,4,)","v":{"v":10000,"d":"10,000.00"}},{"$f":"C23*A23","v":{"v":10000,"d":"10,000.00"}}]
[{"v":1,"d":"1.00"},"Double Drum  Roller 10Ton",{"$f":"VLOOKUP(B24,'02 Equipment'!$S$2:$W$22,4,)","v":{"v":10000,"d":"10,000.00"}},{"v":10000,"d":"10,000.00"}]
[{"v":1,"d":"1.00"},"Sweeping Machine",{"$f":"VLOOKUP(B25,'02 Equipment'!$S$2:$W$22,4,)","v":{"v":10000,"d":"10,000.00"}},{"v":10000,"d":"10,000.00"}]
[{"v":1,"d":"1.00"},"Pneumatic Roller 23Ton ",{"$f":"VLOOKUP(B26,'02 Equipment'!$S$2:$W$22,4,)","v":{"v":10000,"d":"10,000.00"}},{"v":10000,"d":"10,000.00"}]
[{"v":1,"d":"1.00"},"Compressor 7Bar",{"$f":"VLOOKUP(B27,'02 Equipment'!$S$2:$W$22,4,)","v":{"v":10000,"d":"10,000.00"}},{"v":10000,"d":"10,000.00"}]
[{"v":1,"d":"1.00"},"Double Drum  Roller 8Ton",{"$f":"VLOOKUP(B28,'02 Equipment'!$S$2:$W$22,4,)","v":{"v":10000,"d":"10,000.00"}},{"v":10000,"d":"10,000.00"}]
[{"$nulls":3},{"$f":"SUM(D23:D28)","v":{"v":60000,"d":"60,000.0"}}]
["B","TOTAL COST OF EQUIPMENT",{"$f":"D29/C19","v":{"v":15,"d":"15.00"}},"Cost/M2"]
[]
[]
[null,"LABOUR COST"]
[{"v":6,"d":"6.00"},"Operator",{"$f":"VLOOKUP(B34,'03 Labour'!$B$2:$C$5,2,)","v":{"v":10000,"d":"10,000.00"}},{"$f":"C34*A34","v":{"v":60000,"d":"60,000.00"}}]
[{"v":5,"d":"5.00"},"Skilled",{"$f":"VLOOKUP(B35,'03 Labour'!$B$2:$C$5,2,)","v":{"v":5000,"d":"5,000.00"}},{"$f":"C35*A35","v":{"v":25000,"d":"25,000.00"}}]
[{"v":10,"d":"10.00"},"Unskilled Labour",{"$f":"VLOOKUP(B36,'03 Labour'!$B$2:$C$5,2,)","v":{"v":2500,"d":"2,500.00"}},{"$f":"C36*A36","v":{"v":25000,"d":"25,000.00"}}]
[{"$nulls":3},{"$f":"SUM(D34:D36)","v":{"v":110000,"d":"110,000.0"}}]
["C","TOTAL COST OF LABOUR",{"$f":"D37/C19","v":{"v":27.5,"d":"27.50"}},"Cost/M2"]
[]
["A+B+C","COST OF ASPHALT BINDER COURSE",{"$f":"C38+C30+C17","v":{"v":5428.901428571429,"d":"5,428.90"}},"Cost/M2"]

{"sheet":"10 Blockworks","index":11,"n_rows":50,"n_cols":11,"rows_kept":50}
[]
[null,"BLOCK WORK","230mm",{"$nulls":4},"BLOCK WORK","150mm"]
[null,"230 Block supplied to site",{"$f":"'01 Material Prices'!C9","v":{"v":270,"d":"270.00"}},{"$nulls":4},"150 Block supplied to site",{"$f":"'01 Material Prices'!C10","v":{"v":225,"d":"225.00"}}]
[]
[null,"1 m2 of Block wall",{"v":10,"d":"10.00"},"pcs",{"$f":"C5*C3","v":{"v":2700,"d":"2,700.00"}},null,null,"1 m2 of Block wall",{"v":10,"d":"10.00"},"pcs",{"$f":"I5*I3","v":{"v":2250,"d":"2,250.00"}}]
[null,"Waste",{"v":0.1,"d":"10%"},null,{"$f":"E5*C6","v":{"v":270,"d":"270.00"}},null,null,"Waste",{"$f":"C6","v":{"v":0.1,"d":"10%"}},null,{"$f":"K5*I6","v":{"v":225,"d":"225.00"}}]
[{"$nulls":4},{"$f":"SUM(E5:E6)","v":{"v":2970,"d":"2,970.00"}},{"$nulls":5},{"$f":"SUM(K5:K6)","v":{"v":2475,"d":"2,475.00"}}]
[]
[null,"Mortar",{"$nulls":5},"Mortar"]
[null,"Mix Ratio",{"v":1,"d":"1.00"},{"v":6,"d":"6.00"},{"$f":"D10+C10","v":{"v":7,"d":"7.00"}},null,null,"Mix Ratio",{"v":1,"d":"1.00"},{"v":6,"d":"6.00"},{"$f":"J10+I10","v":{"v":7,"d":"7.00"}}]
[]
[null,"Cement",null,null,{"$f":"C10/E10","v":{"v":0.14285714285714285,"d":"0.14"}},null,null,"Cement",null,null,{"$f":"I10/K10","v":{"v":0.14285714285714285,"d":"0.14"}}]
[null,"Add shrinkage",{"v":0.4,"d":"40%"},null,{"$f":"C13*E12","v":{"v":0.05714285714285714,"d":"0.06"}},null,null,"Add shrinkage",{"$f":"C13","v":{"v":0.4,"d":"40%"}},null,{"$f":"I13*K12","v":{"v":0.05714285714285714,"d":"0.06"}}]
[{"$nulls":4},{"$f":"SUM(E12:E13)","v":{"v":0.19999999999999998,"d":"0.20"}},{"$nulls":5},{"$f":"SUM(K12:K13)","v":{"v":0.19999999999999998,"d":"0.20"}}]
[null,"Cement (volume/bag)",{"v":0.035,"d":"0.0350"},"m3/bag",{"$nulls":3},"Volume per bag",{"v":0.035,"d":"0.0350"},"m3"]
[{"$f":"E14/C15","v":{"v":5.7142857142857135,"d":"5.714"}},"Total Bags",{"$f":"'01 Material Prices'!$C$3","v":{"v":3785.625,"d":"3,785.63"}},null,{"$f":"ROUND(C16*A16,2)","v":{"v":21632.14,"d":"21,632.14"}},null,{"$f":"K14/I15","v":{"v":5.7142857142857135,"d":"5.714"}},"Total Bags",{"$f":"'01 Material Prices'!$C$3","v":{"v":3785.625,"d":"3,785.63"}},null,{"$f":"ROUND(I16*G16,2)","v":{"v":21632.14,"d":"21,632.14"}}]
[]
[null,"Sand",null,null,{"$f":"D10/E10","v":{"v":0.8571428571428571,"d":"0.86"}},null,null,"Sand",null,null,{"$f":"J10/K10","v":{"v":0.8571428571428571,"d":"0.86"}}]
[null,"Add shrinkage",{"$f":"C13","v":{"v":0.4,"d":"40%"}},null,{"$f":"C19*E18","v":{"v":0.34285714285714286,"d":"0.34"}},null,null,"Add shrinkage",{"$f":"I13","v":{"v":0.4,"d":"40%"}},null,{"$f":"I19*K18","v":{"v":0.34285714285714286,"d":"0.34"}}]
[{"$nulls":4},{"$f":"SUM(E18:E19)","v":{"v":1.2,"d":"1.20"}},{"$nulls":5},{"$f":"SUM(K18:K19)","v":{"v":1.2,"d":"1.20"}}]
[{"$f":"E20","v":{"v":1.2,"d":"1.200"}},"Cost per m3 of sand",{"$f":"'01 Material Prices'!$C$5","v":{"v":3000,"d":"3,000.00"}},null,{"$f":"C21*A21","v":{"v":3600,"d":"3,600.00"}},null,{"$f":"K20","v":{"v":1.2,"d":"1.200"}},"Cost per m3 of sand",{"$f":"C21","v":{"v":3000,"d":"3,000.00"}},null,{"$f":"I21*G21","v":{"v":3600,"d":"3,600.00"}}]
[]
[null,"Mortar",null,null,{"$f":"E21+E16","v":{"v":25232.14,"d":"25,232.14"}},null,null,"Mortar",null,null,{"$f":"K21+K16","v":{"v":25232.14,"d":"25,232.14"}}]
[null,"Waste",{"v":0.2,"d":"20%"},null,{"$f":"E23*C24","v":{"v":5046.428,"d":"5,046.43"}},null,null,"Waste",{"$f":"C24","v":{"v":0.2,"d":"20%"}},null,{"$f":"K23*I24","v":{"v":5046.428,"d":"5,046.43"}}]
[{"$nulls":4},{"$f":"SUM(E23:E24)","v":{"v":30278.568,"d":"30,278.57"}},{"$nulls":5},{"$f":"SUM(K23:K24)","v":{"v":30278.568,"d":"30,278.57"}}]
[null,"Plaster/ m2 of wall",{"$f":"((0.475*0.25*0.225)-((0.45*0.225*0.225)+(0.15*0.15*0.025*2)))*C5","v":{"v":0.028124999999999956,"d":"0.0281"}},"m3/m2",{"$nulls":3},"Plaster/ m2 of wall",{"$f":"((0.475*0.25*0.15)-((0.45*0.225*0.15)+(0.075*0.15*0.025*2)))*I5","v":{"v":0.020624999999999984,"d":"0.0206"}},"m3/m2"]
[]
[null,"Cost/ m2 of Mortar",null,null,{"$f":"E25*C26","v":{"v":851.5847249999987,"d":"851.58"}},null,null,"Cost/ m2 of Mortar",null,null,{"$f":"K25*I26","v":{"v":624.4954649999995,"d":"624.50"}}]
[]
[null,"Labour Laying",{"$nulls":5},"Labour Laying"]
[{"v":2,"d":"2.000"},"Mason",{"v":4000,"d":"4,000.00"},"per day",{"$f":"C31*A31","v":{"v":8000,"d":"8,000.00"}},null,{"v":2,"d":"2.000"},"Mason",{"v":4000,"d":"4,000.00"},"per day",{"$f":"I31*G31","v":{"v":8000,"d":"8,000.00"}}]
[{"v":1,"d":"1.000"},"Labour",{"v":2000,"d":"2,000.00"},"per day",{"$f":"C32*A32","v":{"v":2000,"d":"2,000.00"}},null,{"v":1,"d":"1.000"},"Labour",{"v":2000,"d":"2,000.00"},"per day",{"$f":"I32*G32","v":{"v":2000,"d":"2,000.00"}}]
[{"$nulls":4},{"$f":"SUM(E31:E32)","v":{"v":10000,"d":"10,000.00"}},{"$nulls":5},{"$f":"SUM(K31:K32)","v":{"v":10000,"d":"10,000.00"}}]
[null,"Output/ day",{"v":150,"d":"150.00"},"blocks/ ay",{"$nulls":3},"Output/ day",{"v":150,"d":"150.00"},"blocks/ ay"]
[null,null,{"$f":"C34/C5","v":{"v":15,"d":"15.00"}},"m2",{"$nulls":4},{"$f":"I34/I5","v":{"v":15,"d":"15.00"}},"m2"]
[null,"Cost/ m2",null,null,{"$f":"E33/C35","v":{"v":666.6666666666666,"d":"666.67"}},null,null,"Cost/ m2",null,null,{"$f":"K33/I35","v":{"v":666.6666666666666,"d":"666.67"}}]
[]
[null,"Total",{"$nulls":5},"Total"]
[null,"Blocks",null,null,{"$f":"E7","v":{"v":2970,"d":"2,970.00"}},null,null,"Blocks",null,null,{"$f":"K7","v":{"v":2475,"d":"2,475.00"}}]
[null,"Mortar",null,null,{"$f":"E28","v":{"v":851.5847249999987,"d":"851.58"}},null,null,"Mortar",null,null,{"$f":"K28","v":{"v":624.4954649999995,"d":"624.50"}}]
[null,"Labour",null,null,{"$f":"E36","v":{"v":666.6666666666666,"d":"666.67"}},null,null,"Labour",null,null,{"$f":"K36","v":{"v":666.6666666666666,"d":"666.67"}}]
[null,"Blockwork","Cost/m2",null,{"$f":"SUM(E39:E41)","v":{"v":4488.251391666666,"d":"4,488.25"}},null,null,"Blockwork","Cost/m2",null,{"$f":"SUM(K39:K41)","v":{"v":3766.162131666666,"d":"3,766.16"}}]
[{"$nulls":10},{"$f":"K42*F2","v":{"v":0,"d":"0.00"}}]
[]
[null,"Filled solid with concrete",{"$nulls":5},"Filled solid with concrete"]
[null,"Blocks",null,null,{"$f":"E7","v":{"v":2970,"d":"2,970.00"}},null,null,"Blocks",null,null,{"$f":"K7","v":{"v":2475,"d":"2,475.00"}}]
[{"$f":"0.15*0.15*0.25*2*C5","v":{"v":0.11249999999999999,"d":"0.1125"}},"Concrete","m3",{"v":35000,"d":"35,000.00"},{"$f":"D47*A47","v":{"v":3937.4999999999995,"d":"3,937.50"}},null,{"$f":"0.075*0.15*0.25*2*I5","v":{"v":0.056249999999999994,"d":"0.0563"}},"Concrete","m3",{"$f":"D47","v":{"v":35000,"d":"35,000.00"}},{"$f":"J47*G47","v":{"v":1968.7499999999998,"d":"1,968.75"}}]
[null,"Mortar",null,null,{"$f":"E28","v":{"v":851.5847249999987,"d":"851.58"}},null,null,"Mortar",null,null,{"$f":"K28","v":{"v":624.4954649999995,"d":"624.50"}}]
[null,"Labour",null,null,{"$f":"E36","v":{"v":666.6666666666666,"d":"666.67"}},null,null,"Labour",null,null,{"$f":"K36","v":{"v":666.6666666666666,"d":"666.67"}}]
[null,"Blockwork","Cost/m2",null,{"$f":"SUM(E46:E49)","v":{"v":8425.751391666665,"d":"8,425.75"}},null,null,"Blockwork","Cost/m2",null,{"$f":"SUM(K46:K49)","v":{"v":5734.912131666667,"d":"5,734.91"}}]

{"sheet":"11 Laterite Fillings","index":12,"n_rows":50,"n_cols":8,"rows_kept":50,"merged":[[0,0,0,3]]}
["Break Down of Laterite Backfilling"]
[]
[null,"Distance  To Brorrow Pit ",{"v":10,"d":"10.00"},"Km"]
[null,"Travel Speed ( Km/Hr.)",{"v":40,"d":"40.00"},"Km / Hr."]
[null,"Time Of One Direction ( Min.)",{"$f":"C3/C4*60","v":{"v":15,"d":"15.00"}},"Min."]
[null,"Time Of One Trip (Min.)",{"$f":"C5*2+10+10","v":{"v":50,"d":"50.00"}},"Min."]
[null,"No Of Trips /Tipper/Day",{"$f":"ROUND((8*60)/C6,0)","v":{"v":10,"d":"10.00"}},"Trips"]
[]
[null,"Daily Work Output from Experience",{"v":500,"d":"500.00"},"M3/ day"]
[null,"Using 11 m3/ Tipper Load",{"$f":"ROUND(C9/(C7*11),0)","v":{"v":5,"d":"5.00"}}]
[]
[null,"COST OF EQUIP AT BURROW PIT","Running  Cost","Total /day"]
[{"v":1,"d":"1.00"},"CAT Bulldozer D9",{"$f":"VLOOKUP(B13,'02 Equipment'!$S$2:$W$22,4,)","v":{"v":10000,"d":"10,000.00"}},{"$f":"C13*A13","v":{"v":10000,"d":"10,000.00"}},"COST/ DAY"]
[{"v":1,"d":"1.00"},"Excavator (2 M3 ) ",{"$f":"VLOOKUP(B14,'02 Equipment'!$S$2:$W$22,4,)","v":{"v":10000,"d":"10,000.00"}},{"$f":"C14*A14","v":{"v":10000,"d":"10,000.00"}},"COST/ DAY"]
[null,null,"Total",{"$f":"SUM(D13:D14)","v":{"v":20000,"d":"20,000.00"}},"COST/ DAY"]
[null,"Cost of Equipment ",{"$f":"D15/C9","v":{"v":40,"d":"40.00"}}]
[null,"Borrow Pit  Fee",{"$f":"((2800)/11)","v":{"v":254.54545454545453,"d":"254.55"}}]
[1,"Total cost of LaterIte Burrowing",{"$f":"SUM(C16:C17)","v":{"v":294.5454545454545,"d":"294.55"}}]
[]
[null,"COST OF MATERIAL HAULAGE","Running  Cost","Total /day"]
[{"$f":"C10","v":{"v":5,"d":"5.00"}},"Tipper Truck- 16M3",{"$f":"VLOOKUP(B21,'02 Equipment'!$S$2:$W$22,4,)","v":{"v":10000,"d":"10,000.00"}},{"$f":"C21*A21","v":{"v":50000,"d":"50,000.00"}},"COST/ DAY"]
[{"v":1,"d":"1.00"},"Wheel Loader 2.5 M3 ",{"$f":"VLOOKUP(B22,'02 Equipment'!$S$2:$W$22,4,)","v":{"v":10000,"d":"10,000.00"}},{"$f":"C22*A22","v":{"v":10000,"d":"10,000.00"}},"COST/ DAY"]
[{"v":8,"d":"8.00"},"Semi Skilled",{"$f":"VLOOKUP(B23,'03 Labour'!$B$2:$C$5,2,)","v":{"v":3500,"d":"3,500.00"}},{"$f":"C23*A23","v":{"v":28000,"d":"28,000.00"}},"COST/ DAY"]
[null,null,"Total",{"$f":"SUM(D21:D23)","v":{"v":88000,"d":"88,000.00"}},"COST/ DAY"]
[2,"Transportation Cost",{"$f":"D24/C9","v":{"v":176,"d":"176.00"}}]
[]
["A=1+2","The Cost of Borrow Pit Equipment",{"$f":"C18+C25","v":{"v":470.5454545454545,"d":"470.55"}},"COST/ m3"]
[]
[]
[null,"COST OF MATERIAL","Vendor Price"]
[null,"1 TRIP OF LATERITE ",{"v":300,"d":"300.00"},"COST/ Ton",null,null,"For Material Supplied to Site"]
[null,"Densite of Material (Laterite)",{"v":1.6,"d":"1.60"},"Ton/M3"]
["B","COST  OF MATERIAL/M3 ",{"$f":"C31*C32","v":{"v":480,"d":"480.00"}},"COST/ M3",null,null,{"v":2600,"d":"2,600.00"},"COST/ m3"]
[{"$nulls":6},{"$f":"G33*0.075","v":{"v":195,"d":"195.00"}},"+VAT"]
["C=A+B","COST OF LATERITE SUPPLIED (+10% SWELL)",{"v":1.1,"d":"1.10"},{"$f":"(C27+C33)*C35","v":{"v":1045.6000000000001,"d":"1,045.60"}},"COST/ M3",null,{"$f":"SUM(G33:G34)","v":{"v":2795,"d":"2,795.00"}},"COST/ M3"]
[]
[]
[null,"COST OF COMPACTION","Running  Cost","Total /day"]
[{"v":1,"d":"1.00"},"Motor Grader 270 Hp",{"$f":"VLOOKUP(B39,'02 Equipment'!$S$2:$W$22,4,)","v":{"v":10000,"d":"10,000.00"}},{"$f":"A39*C39","v":{"v":10000,"d":"10,000.00"}}]
[{"v":1,"d":"1.00"},"Water Tanker",{"$f":"VLOOKUP(B40,'02 Equipment'!$S$2:$W$22,4,)","v":{"v":10000,"d":"10,000.00"}},{"$f":"A40*C40","v":{"v":10000,"d":"10,000.00"}}]
[{"v":1,"d":"1.00"},"Single Drum Soil Compactor, 10Ton",{"$f":"VLOOKUP(B41,'02 Equipment'!$S$2:$W$22,4,)","v":{"v":10000,"d":"10,000.00"}},{"$f":"A41*C41","v":{"v":10000,"d":"10,000.00"}}]
[{"v":1,"d":"1.00"},"Single Drum Sheep Foot Compactor, 11Ton",{"$f":"VLOOKUP(B42,'02 Equipment'!$S$2:$W$22,4,)","v":{"v":10000,"d":"10,000.00"}},{"$f":"A42*C42","v":{"v":10000,"d":"10,000.00"}}]
[{"$f":"SUM(A39:A42)","v":{"v":4,"d":"4.00"}},"Semi Skilled",{"$f":"VLOOKUP(B43,'03 Labour'!$B$2:$C$5,2,)","v":{"v":3500,"d":"3,500.00"}},{"$f":"A43*C43","v":{"v":14000,"d":"14,000.00"}}]
[{"$nulls":3},{"$f":"SUM(D39:D43)","v":{"v":54000,"d":"54,000.00"}},"COST/ DAY"]
[]
[null,"Loss due to Compction (% 15)",{"v":0.15,"d":"15.00%"},{"$f":"C46*D44","v":{"v":8100,"d":"8,100.00"}}]
[null,"Subtotal Equipment cost of compaction",null,{"$f":"SUM(D44:D46)","v":{"v":62100,"d":"62,100.00"}}]
["D","COST OF COMPACTION",null,{"$f":"D47/C9","v":{"v":124.2,"d":"124.20"}},"COST/ M3",null,{"$f":"D48","v":{"v":124.2,"d":"124.20"}}]
[]
["C+D","COST TO PROVIDE AND PLACE LATERITE",null,{"$f":"ROUND(D35+D48,0)","v":{"v":1170,"d":"1,170.00"}},"COST/ M3",null,{"$f":"ROUND(G35+G48,0)","v":{"v":2919,"d":"2,919.00"}},"COST/ M3"]

{"sheet":"12 Road Scarify","index":13,"n_rows":23,"n_cols":5,"rows_kept":23,"merged":[[0,0,0,3]]}
["BREAKDOWN OF PAVEMENT SCARIFICATION"]
[]
[null,"COST  OF EQUIPMENTS","Running  Cost","Total /day"]
[1,"CAT Bulldozer D9",{"$f":"VLOOKUP(B4,'02 Equipment'!$S$2:$W$22,4,)","v":{"v":10000,"d":"10,000.00"}},{"$f":"C4*A4","v":{"v":10000,"d":"10,000.00"}},"COST/ DAY"]
[1,"Wheel Loader 2.5 M3 ",{"$f":"VLOOKUP(B5,'02 Equipment'!$S$2:$W$22,4,)","v":{"v":10000,"d":"10,000.00"}},{"v":10000,"d":"10,000.00"},"COST/ DAY"]
[2,"Tipper Dumper Truck- 14M3",{"$f":"VLOOKUP(B6,'02 Equipment'!$S$2:$W$22,4,)","v":{"v":10000,"d":"10,000.00"}},{"v":20000,"d":"20,000.00"},"COST/ DAY"]
[0.5,"Motor Grader 270 Hp",{"$f":"VLOOKUP(B7,'02 Equipment'!$S$2:$W$22,4,)","v":{"v":10000,"d":"10,000.00"}},{"v":5000,"d":"5,000.00"},"COST/ DAY"]
[1,"Single Drum Soil Compactor, 10Ton",{"$f":"VLOOKUP(B8,'02 Equipment'!$S$2:$W$22,4,)","v":{"v":10000,"d":"10,000.00"}},{"v":10000,"d":"10,000.00"},"COST/ DAY"]
[1,"Water Tanker",{"$f":"VLOOKUP(B9,'02 Equipment'!$S$2:$W$22,4,)","v":{"v":10000,"d":"10,000.00"}},{"v":10000,"d":"10,000.00"},"COST/ DAY"]
[{"$nulls":3},{"$f":"SUM(D4:D9)","v":{"v":65000,"d":"65,000.00"}},"COST/ DAY"]
[null,"Output from Experience",{"v":1500,"d":"1,500.00"},"M2/ DAY"]
[]
["A","Equipment Cost",null,{"$f":"D10/C11","v":{"v":43.333333333333336,"d":"43.33"}},"COST/ M2"]
[null,"LABOUR COST"]
[{"v":10,"d":"10.00"},"Operator",{"$f":"VLOOKUP(B15,'03 Labour'!$B$2:$C$5,2,)","v":{"v":10000,"d":"10,000.00"}},{"$f":"C15*A15","v":{"v":100000,"d":"100,000.00"}},"COST/ DAY"]
["B","Labour Cost",null,{"$f":"D15/C11","v":{"v":66.66666666666667,"d":"66.67"}},"COST/ M2"]
[]
["A+B","TOTAL COST ",{"$f":"ROUND(D13+D16,0)","v":{"v":110,"d":"110.00"}},"COST/ M2"]
[]
[null,"Project Information"]
[null,"Surface Pavement structure:\n(Binder- 6cm + Wearing- 4cm)",{"v":0.1,"d":"0.10"},"m"]
[null,null,"Total Cost Volume",{"$f":"C18/C21","v":{"v":1100,"d":"1,100.00"}}]
[null,"Scarification Cost Max. 50m3",{"$f":"D22*50","v":{"v":55000,"d":"55,000.00"}},"COST/SUM"]

{"sheet":"13 Prime Coat","index":14,"n_rows":37,"n_cols":7,"rows_kept":37,"merged":[[0,0,0,4]]}
["BREAKDOWN OF PRIME COAT"]
[]
[null,"COST  OF MATERIAL"]
[null,"Supply Cost of MC-1 to Site",null,{"v":350000,"d":"350,000.00"},"COST/TON"]
[null,"VAT",{"v":0.075,"d":"7.50%"},{"$f":"D4*C5","v":{"v":26250,"d":"26,250.00"}}]
[{"$nulls":3},{"$f":"SUM(D4:D5)","v":{"v":376250,"d":"376,250.00"}},"COST/TON"]
[{"$nulls":3},{"$f":"D6/1000","v":376.25},"COST/LITER"]
[null,"Wastage",{"v":0.1,"d":"10%"},{"$f":"C8*D7","v":{"v":37.625,"d":"37.63"}},"COST/LITER"]
[{"$nulls":3},{"$f":"SUM(D7:D8)","v":{"v":413.875,"d":"413.88"}},"COST/LITER"]
[null,"Application Rate",null,{"v":1.3,"d":"1.30"},"lit/m2"]
[null,"Cost of MC-1 Application",null,null,{"$f":"D9*D10","v":{"v":538.0375,"d":"538.04"}},"N/M2"]
[]
[null,"Sand Blinding","L","W","Thick"]
[null,"Sharp Sand Blinding",1,1,0.025]
[{"$nulls":4},{"$f":"E14*D14*C14","v":0.025}]
[null,"Sharp Sand/m3",{"$f":"'01 Material Prices'!C5","v":{"v":3000,"d":"3,000.00"}},"/m3",{"$f":"E15*C16","v":{"v":75,"d":"75.00"}},"N/M2"]
[]
["A","TOTAL MATERIAL COST",null,{"$f":"E16+E11","v":{"v":613.0375,"d":"613.04"}},"Cost/M2"]
[]
[]
[null,"COST OF EQUIPMENT",null,"Running Cost"]
[1,"Bitumen Sprayer",{"$f":"VLOOKUP(B22,'02 Equipment'!$S$2:$W$22,4,)","v":{"v":10000,"d":"10,000.00"}},{"$f":"C22*A22","v":{"v":10000,"d":"10,000.00"}},"Cost/day"]
[1,"Compressor 7Bar",{"$f":"VLOOKUP(B23,'02 Equipment'!$S$2:$W$22,4,)","v":{"v":10000,"d":"10,000.00"}},{"$f":"C23*A23","v":{"v":10000,"d":"10,000.00"}},"Cost/day"]
[{"$nulls":3},{"$f":"SUM(D22:D23)","v":{"v":20000,"d":"20,000.00"}},"Cost/day"]
[]
[null,"Daily Output",{"v":6000,"d":"6,000.00"},"m2/day"]
[]
["B","TOTAL COST OF EQUIPMENT",null,{"$f":"D24/C26","v":{"v":3.3333333333333335,"d":"3.33"}},"Cost/M2",{"$f":"D24/C26","v":{"v":3.3333333333333335,"d":"3.33"}},"N/M2"]
[]
[]
[null,"COST OF LABOUR",null,"Total / day"]
[10,"Semi Skilled",{"$f":"VLOOKUP(B32,'03 Labour'!$B$2:$C$5,2,)","v":{"v":3500,"d":"3,500.00"}},{"$f":"C32*A32","v":{"v":35000,"d":"35,000.00"}}]
[]
["C","TOTAL COST OF LABOUR",null,{"$f":"D32/C26","v":{"v":5.833333333333333,"d":"5.83"}},"Cost/M2",{"$f":"D32/C26","v":{"v":5.833333333333333,"d":"5.83"}}]
[]
[]
["A+B+C","COST OF MC-1",null,{"$f":"D34+D28+D18","v":{"v":622.2041666666667,"d":"622.20"}},"Cost/M2"]