{"text_format":"3","workbook":"xlsx","n_sheets":14,"sheets":["Summary","M.H 4'dia (Type-I)","M.H 4'dia (Type-II.","M.H 4'dia (Type-III","M.H 4'dia (Type-IV","M.H 5'dia (Type-V","M.H 5'dia (Type-VI","M.H 6.5'dia (Type-VII","M.H 2.5'dia (H,Conc)","M.H 4'dia (Type-II","Steel Fixing ","Shuttering","Conc","Bed Dressing"],"not_rendered":{"images":1,"external_links":16,"defined_names":1397},"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":50,"n_cols":24,"rows_kept":50,"merged":[[3,3,3,4],[3,5,3,6],[3,7,3,8],[3,9,3,10],[3,11,3,12],[3,13,3,14],[3,15,3,16],[3,17,3,18],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,19,5,19],[4,20,5,20],[37,0,37,4]]}
["COMPANY NAME"]
["CIVIL INFRASTRUCTURE WORKS"]
["Quantity as per Sewerage BOQ (Total No's of Manhole =349 Nos, House Conncetion =241 Nos)"]
["Summary of Manhole Quantities",null,null,"Type-01",null,"Type-02",null,"Type-03",null,"Type-04",null,"Type-05",null,"Type-06",null,"Type-07",null,"House Connection"]
["Sr.#","Decription of items","Unit","Qty MH-1 No","Total Qty","Qty MH-1 No","Total Qty","Qty MH-1 No","Total Qty","Qty MH-1 No","Total Qty","Qty MH-1 No","Total Qty","Qty MH-1 No","Total Qty","Qty MH-1 No","Total Qty","Qty MH-1 No","Total Qty","Grand Total Quantity","Remarks"]
[{"$nulls":3},"Total Nos=",195,"Total Nos=",70,"Total Nos=",13,"Total Nos=",15,"Total Nos=",31,"Total Nos=",23,"Total Nos=",2,"Total Nos=",241,{"$nulls":3},"Total Qty","Total Rs."]
[1,"Excavation","Cft",{"$f":"+'M.H 4''dia (Type-I)'!I11","v":{"v":408.375,"d":"408"}},{"$f":"D7*E$6","v":{"v":79633.125,"d":"79,633.13"}},{"$f":"+'M.H 4''dia (Type-II.'!I11","v":{"v":612.5625,"d":"613"}},{"$f":"F7*G$6","v":{"v":42879.375,"d":"42,879"}},{"$f":"+'M.H 4''dia (Type-III'!I11","v":{"v":1053,"d":"1,053"}},{"$f":"H7*I$6","v":{"v":13689,"d":"13,689"}},{"$f":"+'M.H 4''dia (Type-IV'!I11","v":{"v":1377,"d":"1,377"}},{"$f":"J7*K$6","v":{"v":20655,"d":"20,655"}},{"$f":"+'M.H 5''dia (Type-V'!I11","v":{"v":1300,"d":"1,300"}},{"$f":"L7*M$6","v":{"v":40300,"d":"40,300"}},{"$f":"+'M.H 5''dia (Type-VI'!I11","v":{"v":1700,"d":"1,700"}},{"$f":"N7*O$6","v":{"v":39100,"d":"39,100"}},{"$f":"+'M.H 6.5''dia (Type-VII'!I11","v":{"v":2380.5,"d":"2,381"}},{"$f":"P7*Q$6","v":{"v":4761,"d":"4,761"}},{"$f":"+'M.H 2.5''dia (H,Conc)'!I11","v":125},{"$f":"R7*S$6","v":{"v":30125,"d":"30,125"}},{"$f":"+Q7+O7+M7+K7+I7+G7+E7+S7","v":{"v":271142.5,"d":"271,143"}}]
[{"$f":"A7+1","v":2},"Dressing of bed","Sft",{"$f":"+'M.H 4''dia (Type-I)'!I14","v":{"v":364.2890625,"d":"364"}},{"$f":"D8*$E$6","v":{"v":71036.3671875,"d":"71,036"}},{"$f":"+'M.H 4''dia (Type-II.'!I14","v":{"v":364.2890625,"d":"364"}},{"v":25500.234375,"d":"25,500"},{"$f":"+'M.H 4''dia (Type-III'!I14","v":{"v":480.8615625,"d":"481"}},{"v":6251.2003125,"d":"6,251"},{"$f":"+'M.H 4''dia (Type-IV'!I14","v":{"v":480.8615625,"d":"481"}},{"v":7212.9234375,"d":"7,213"},{"$f":"+'M.H 5''dia (Type-V'!I14","v":{"v":671.665625,"d":"672"}},{"v":20821.634374999998,"d":"20,822"},{"$f":"+'M.H 5''dia (Type-VI'!I14","v":{"v":671.665625,"d":"672"}},{"v":15448.309374999999,"d":"15,448"},{"$f":"+'M.H 6.5''dia (Type-VII'!I14","v":{"v":1043.2404687500002,"d":"1,043"}},{"v":2086.4809375000004,"d":"2,086"},{"$f":"+'M.H 2.5''dia (H,Conc)'!I14","v":{"v":70.8953125,"d":"71"}},{"v":17085.7703125,"d":"17,086"},{"$f":"+Q8+O8+M8+K8+I8+G8+E8+S8","v":{"v":165442.9203125,"d":"165,443"}}]
[3,"Crurshed Stone Bedding 1\" Down","Cft",{"$f":"+'M.H 4''dia (Type-I)'!I17","v":{"v":22.078125,"d":"22"}},{"v":4305.234375,"d":"4,305"},{"$f":"+'M.H 4''dia (Type-II.'!I17","v":{"v":22.078125,"d":"22"}},{"v":1545.46875,"d":"1,545"},{"$f":"+'M.H 4''dia (Type-III'!I17","v":{"v":53.4290625,"d":"53"}},{"v":694.5778125,"d":"695"},{"$f":"+'M.H 4''dia (Type-IV'!I17","v":{"v":53.4290625,"d":"53"}},{"v":801.4359375,"d":"801"},{"$f":"+'M.H 5''dia (Type-V'!I17","v":{"v":67.1665625,"d":"67"}},{"v":2082.1634375,"d":"2,082"},{"$f":"+'M.H 5''dia (Type-VI'!I17","v":{"v":67.1665625,"d":"67"}},{"v":1544.8309375,"d":"1,545"},{"$f":"+'M.H 6.5''dia (Type-VII'!I17","v":{"v":90.71656250000001,"d":"91"}},{"v":181.43312500000002,"d":"181"},{"$f":"+'M.H 2.5''dia (H,Conc)'!I17","v":{"v":4.679090625000001,"d":"5"}},{"v":1127.6608406250002,"d":"1,128"},{"$f":"+Q9+O9+M9+K9+I9+G9+E9+S9","v":{"v":12282.805215625,"d":"12,283"}}]
[{"$f":"+A9+1","v":4},"PCC Concrete 1:4:8","Cft",{"$f":"+'M.H 4''dia (Type-I)'!I20","v":{"v":24.8746875,"d":"25"}},{"v":4850.5640625,"d":"4,851"},{"$f":"+'M.H 4''dia (Type-II.'!I20","v":{"v":24.8746875,"d":"25"}},{"v":1741.228125,"d":"1,741"},{"$f":"+'M.H 4''dia (Type-III'!I20","v":{"v":30.946171875000005,"d":"31"}},{"v":402.30023437500006,"d":"402"},{"$f":"+'M.H 4''dia (Type-IV'!I20","v":{"v":30.946171875000005,"d":"31"}},{"v":464.19257812500007,"d":"464"},{"$f":"+'M.H 5''dia (Type-V'!I20","v":{"v":40.071796875000004,"d":"40"}},{"v":1242.225703125,"d":"1,242"},{"$f":"+'M.H 5''dia (Type-VI'!I20","v":{"v":40.071796875000004,"d":"40"}},{"v":921.6513281250001,"d":"922"},{"$f":"+'M.H 6.5''dia (Type-VII'!I20","v":{"v":55.968046875000006,"d":"56"}},{"v":111.93609375000001,"d":"112"},{"$f":"+'M.H 2.5''dia (H,Conc)'!I20","v":{"v":2.736215625,"d":"3"}},{"v":659.427965625,"d":"659"},{"$f":"+Q10+O10+M10+K10+I10+G10+E10+S10","v":{"v":10393.526090625,"d":"10,394"}}]
[5,"Pacca Brick Work with 1:3 C/S Mortar","Cft",{"$f":"+'M.H 4''dia (Type-I)'!I25","v":{"v":38.8566230625,"d":"39"}},{"v":7577.0414971875,"d":"7,577"},{"$f":"+'M.H 4''dia (Type-II.'!I25","v":{"v":75.08781056250001,"d":"75"}},{"v":5256.146739375001,"d":"5,256"},{"$f":"+'M.H 4''dia (Type-III'!I25","v":{"v":82.5255136875,"d":"83"}},{"v":1072.8316779375,"d":"1,073"},{"$f":"+'M.H 4''dia (Type-IV'!I25","v":{"v":154.9878886875,"d":"155"}},{"v":2324.8183303125,"d":"2,325"},{"$f":"+'M.H 5''dia (Type-V'!I25","v":{"v":114.375084,"d":"114"}},{"v":3545.6276040000002,"d":"3,546"},{"$f":"+'M.H 5''dia (Type-VI'!I25","v":{"v":200.97645900000003,"d":"201"}},{"v":4622.458557000001,"d":"4,622"},{"$f":"+'M.H 6.5''dia (Type-VII'!I25","v":{"v":276.53174025,"d":"277"}},{"v":553.0634805,"d":"553"},{"$f":"+'M.H 2.5''dia (H,Conc)'!I25","v":{"v":31.077227437499996,"d":"31"}},{"v":7489.611812437499,"d":"7,490"},{"$f":"+Q11+O11+M11+K11+I11+G11+E11+S11","v":{"v":32441.59969875,"d":"32,442"}}]
[6,"Plaster Work with 1:3 C/S Mortar","Sft",{"$f":"+'M.H 4''dia (Type-I)'!I31","v":{"v":100.67203649999999,"d":"101"}},{"v":19631.0471175,"d":"19,631"},{"$f":"+'M.H 4''dia (Type-II.'!I31","v":{"v":190.2190365,"d":"190"}},{"v":13315.332554999999,"d":"13,315"},{"$f":"+'M.H 4''dia (Type-III'!I32","v":{"v":203.43638316666664,"d":"203"}},{"v":2644.6729811666664,"d":"2,645"},{"$f":"+'M.H 4''dia (Type-IV'!I32","v":{"v":329.64004983333325,"d":"330"}},{"v":4944.600747499999,"d":"4,945"},{"$f":"+'M.H 5''dia (Type-V'!I32","v":{"v":267.1587615,"d":"267"}},{"v":8281.9216065,"d":"8,282"},{"$f":"+'M.H 5''dia (Type-VI'!I32","v":{"v":418.49842816666666,"d":"418"}},{"v":9625.463847833333,"d":"9,625"},{"$f":"+'M.H 6.5''dia (Type-VII'!I32","v":{"v":562.4229748333332,"d":"562"}},{"v":1124.8459496666665,"d":"1,125"},{"$f":"+'M.H 2.5''dia (H,Conc)'!I31","v":{"v":96.8466515,"d":"97"}},{"v":23340.043011499998,"d":"23,340"},{"v":82907.92781666666,"d":"82,908"}]
[7,"Bituman Coating ","Sft",{"$f":"+'M.H 4''dia (Type-I)'!I35","v":{"v":119.5240365,"d":"120"}},{"v":23307.187117499998,"d":"23,307"},{"$f":"+'M.H 4''dia (Type-II.'!I35","v":{"v":223.2100365,"d":"223"}},{"v":15624.702555,"d":"15,625"},{"$f":"+'M.H 4''dia (Type-III'!I37","v":{"v":257.77203649999996,"d":"258"}},{"v":3351.0364744999993,"d":"3,351"},{"$f":"+'M.H 4''dia (Type-IV'!I37","v":{"v":414.8720364999999,"d":"415"}},{"v":6223.080547499999,"d":"6,223"},{"$f":"+'M.H 5''dia (Type-V'!I39","v":{"v":166.78639325,"d":"167"}},{"v":5170.37819075,"d":"5,170"},{"$f":"+'M.H 5''dia (Type-VI'!I39","v":{"v":257.90439325,"d":"258"}},{"v":5931.80104475,"d":"5,932"},{"$f":"+'M.H 6.5''dia (Type-VII'!I39","v":{"v":339.00726825000004,"d":"339"}},{"v":678.0145365000001,"d":"678"},{"$f":"+'M.H 2.5''dia (H,Conc)'!I35","v":{"v":103.32702649999999,"d":"103"}},{"v":24901.813386499998,"d":"24,902"},{"$f":"+Q13+O13+M13+K13+I13+G13+E13+S13","v":{"v":85188.013853,"d":"85,188"}},null,{"$f":"+T13/2","v":42594.0069265},{"$f":"V13*1.4","v":{"v":59631.60969709999,"d":"59,631.61"}}]
[8,"Concrete 1:2:4","Cft",{"$f":"+'M.H 4''dia (Type-I)'!I41","v":{"v":21.04817592592593,"d":"21"}},{"v":4104.3943055555565,"d":"4,104"},{"$f":"+'M.H 4''dia (Type-II.'!I41","v":{"v":21.04817592592593,"d":"21"}},{"v":1473.372314814815,"d":"1,473"},{"$f":"+'M.H 4''dia (Type-III'!I43","v":{"v":23.01496435185185,"d":"23"}},{"v":299.19453657407405,"d":"299"},{"$f":"+'M.H 4''dia (Type-IV'!I43","v":{"v":25.390605808738425,"d":"25"}},{"v":380.85908713107636,"d":"381"},{"$f":"+'M.H 5''dia (Type-V'!I45","v":{"v":35.4506,"d":"35"}},{"v":1098.9686000000002,"d":"1,099"},{"$f":"+'M.H 5''dia (Type-VI'!I45","v":{"v":38.4679800925926,"d":"38"}},{"v":884.7635421296297,"d":"885"},{"$f":"+'M.H 6.5''dia (Type-VII'!I45","v":{"v":66.09576435185184,"d":"66"}},{"v":132.19152870370368,"d":"132"},{"$f":"+'M.H 2.5''dia (H,Conc)'!I41","v":{"v":11.072424999999999,"d":"11"}},{"v":2668.454425,"d":"2,668"},{"v":11042.198339908855,"d":"11,042"}]
[9,"Manhole Cover 22\" dia","No",{"$f":"+'M.H 4''dia (Type-I)'!I44","v":1},195,{"$f":"+'M.H 4''dia (Type-II.'!I44","v":1},70,{"$f":"+'M.H 4''dia (Type-III'!I46","v":1},13,{"$f":"+'M.H 4''dia (Type-IV'!I46","v":1},15,{"$f":"+'M.H 5''dia (Type-V'!I48","v":1},31,{"$f":"+'M.H 5''dia (Type-VI'!I48","v":1},23,{"$f":"+'M.H 6.5''dia (Type-VII'!I48","v":1},2,{"$f":"+'M.H 2.5''dia (H,Conc)'!I44","v":1},241,{"$f":"+Q15+O15+M15+K15+I15+G15+E15+S15","v":590}]
[10,"Malleable Iron Step","No",{"$f":"+'M.H 4''dia (Type-I)'!I47","v":3},585,{"$f":"+'M.H 4''dia (Type-II.'!I47","v":6},420,{"$f":"+'M.H 4''dia (Type-III'!I49","v":7},91,{"$f":"+'M.H 4''dia (Type-IV'!I49","v":11},165,{"$f":"+'M.H 5''dia (Type-V'!I51","v":8},248,{"$f":"+'M.H 5''dia (Type-VI'!I51","v":12},276,{"$f":"+'M.H 6.5''dia (Type-VII'!I51","v":13},26,{"$f":"+'M.H 2.5''dia (H,Conc)'!I47","v":0},0,{"$f":"+Q16+O16+M16+K16+I16+G16+E16+S16","v":{"v":1811,"d":"1,811"}}]
[11,"Backfill","Cft",{"$f":"+'M.H 4''dia (Type-I)'!I51","v":{"v":265.89750000000004,"d":"266"}},{"v":51850.012500000004,"d":"51,850"},{"$f":"+'M.H 4''dia (Type-II.'!I51","v":{"v":398.84625,"d":"399"}},{"v":27919.2375,"d":"27,919"},{"$f":"+'M.H 4''dia (Type-III'!I53","v":{"v":744.2987499999999,"d":"744"}},{"v":9675.883749999999,"d":"9,676"},{"$f":"+'M.H 4''dia (Type-IV'!I53","v":{"v":973.31375,"d":"973"}},{"v":14599.706250000001,"d":"14,600"},{"$f":"+'M.H 5''dia (Type-V'!I55","v":{"v":868.83875,"d":"869"}},{"v":26934.00125,"d":"26,934"},{"$f":"+'M.H 5''dia (Type-VI'!I55","v":{"v":1136.17375,"d":"1,136"}},{"v":26131.996249999997,"d":"26,132"},{"$f":"+'M.H 6.5''dia (Type-VII'!I55","v":{"v":1476.1799999999998,"d":"1,476"}},{"v":2952.3599999999997,"d":"2,952"},{"$f":"+'M.H 2.5''dia (H,Conc)'!I51","v":{"v":62.199999999999996,"d":"62"}},{"v":14990.199999999999,"d":"14,990"},{"v":175053.39750000002,"d":"175,053"}]
[null,"Calculation Sheet"]
["A","Bricks Work","Cft ",null,{"$f":"+T11","v":{"v":32441.59969875,"d":"32,441.60"}}]
[null,"No's of Bricks (13.5 Nos/Cft)","No",null,{"$f":"+(E19-E22)*13.5","v":{"v":375387.8329141798,"d":"375,388"}}]
[null,"Cement (Morter for Brick Work)","Bags",null,{"$f":"((E19*15%*1.27)*1/4)/1.25","v":{"v":1236.0249485223749,"d":"1,236.02"}}]
[null,"Sand (Moter for Brick Work)","Cft ",null,{"$f":"((E19*15%*1.27)*3/4)","v":{"v":4635.0935569589055,"d":"4,635.09"}}]
[]
["B","Plaster Work(1:4) 1/2\" thick","Cft ",null,{"$f":"+T12*0.04","v":{"v":3316.3171126666666,"d":"3,316.32"}}]
[null,"Cement (for Plaster Work)","Bags",null,{"$f":"((E24*1.27)*1/4)/1.25","v":{"v":842.3445466173332,"d":"842.34"}}]
[null,"Sand (for Plaster Work)","Cft ",null,{"$f":"((E24*1.27)*3/4)","v":{"v":3158.7920498149997,"d":"3,158.79"}}]
[]
["C","Concrete PCC (1:4:8)","Cft ",null,{"$f":"+T10","v":{"v":10393.526090625,"d":"10,393.5"}}]
[null,"Cement (for Concete Work)","Bags",null,{"$f":"((E28*1.54)*1/13)/1.25","v":{"v":984.9864725884615,"d":"984.99"}}]
[null,"Sand  (for Concete Work)","Cft ",null,{"$f":"((E28*1.54)*4/13)","v":{"v":4924.932362942308,"d":"4,924.93"}}]
[null,"Crush Aggr (for Concete Work)","Cft ",null,{"$f":"((E28*1.54)*8/13)","v":{"v":9849.864725884616,"d":"9,849.86"}}]
[]
["D","Concrete  (1:2:4)","Cft ",null,{"$f":"+T14","v":{"v":11042.198339908855,"d":"11,042.20"}}]
[null,"Cement (for Concete Work)","Bags",null,{"$f":"((E33*1.54)*1/7)/1.25","v":{"v":1943.4269078239588,"d":"1,943.43"}}]
[null,"Sand  (for Concete Work)","Cft ",null,{"$f":"((E33*1.54)*2/7)","v":{"v":4858.567269559897,"d":"4,858.57"}}]
[null,"Crush Aggr (for Concete Work)","Cft ",null,{"$f":"((E33*1.54)*4/7)","v":{"v":9717.134539119794,"d":"9,717.13"}}]
[]
["Basic Material for Sewerage Manholes"]
[1,"Bricks (1st Class)","No's",{"$f":"+E20*1","v":{"v":375387.8329141798,"d":"375,388"}}]
[2,"Cement","Bag's",{"$f":"+(E21+E25+E34+E29)*105%","v":{"v":5257.122019329735,"d":"5,257"}},"5% Wastage "]
[3,"Sand ","Cft ",{"$f":"+(E22+E26+E35+E30)*110%","v":{"v":19335.123763203723,"d":"19,335"}},"10% Wastage "]
[4,"Crush Aggr ","Cft ",{"$f":"+(E36+E31+T9)*110%","v":{"v":35034.78492869235,"d":"35,035"}},"10% Wastage "]
[]
[]
[]
[{"$nulls":18},"Bituman Coating area",{"$f":"+T13","v":{"v":85188.013853,"d":"85,188"}},{"$f":"T46/2*1","v":{"v":42594.0069265,"d":"42,594.01"}}]
[{"$nulls":18},"Cover Area Kg/sft",{"$f":"+(20*0.453)/100","v":{"v":0.0906,"d":"0.09"}},{"$f":"1.5*(20*0.453)/100","v":{"v":0.1359,"d":"0.14"}}]
[{"$nulls":19},{"$f":"T46*T47","v":{"v":7718.0340550818,"d":"7,718"}},{"$f":"U46*U47","v":{"v":5788.525541311349,"d":"5,789"}}]
[{"$nulls":20},{"$f":"+U48*0.6","v":3473.115324786809}]
[{"$nulls":20},{"$f":"+U48*0.4","v":2315.41021652454}]

{"sheet":"M.H 4'dia (Type-I)","index":1,"n_rows":57,"n_cols":15,"rows_kept":57,"merged":[[0,3,0,8],[6,0,7,0],[6,1,6,2],[6,3,6,8],[6,9,6,10],[7,1,7,2],[9,9,10,9],[9,10,10,10],[10,3,10,6],[12,9,13,9],[12,10,13,10],[13,3,13,6],[15,9,16,9],[15,10,16,10],[16,3,16,6],[18,9,19,9],[18,10,19,10],[19,3,19,6],[21,9,24,9],[21,10,24,10],[24,3,24,6],[26,9,30,9],[26,10,30,10],[30,3,30,6],[32,9,34,9],[32,10,34,10],[34,3,34,6],[36,9,40,9],[36,10,40,10],[40,3,40,6],[42,9,43,9],[42,10,43,10],[43,3,43,6],[45,9,46,9],[45,10,46,10],[46,3,46,6],[48,9,50,9],[48,10,50,10],[50,3,50,6]]}
[{"$nulls":3},"PROJECT NAME ",{"$nulls":5},"Manhole #"]
[{"$nulls":4},"CIVIL INFRASTRUCTURE WORKS",{"$nulls":4},"Road Name :"]
[{"$nulls":5},"RATE ANALYSIS",{"$nulls":3},"Sewer Line (Ø)",{"v":0.6666666666666666,"d":"0.67 ft"}]
["Manhole Data;"]
[null,"Manhole Inner dia(Ø)",{"v":4,"d":"4.00 ft"},"Depth of Manhole,",{"v":6,"d":"6.00 ft"},"Wall Thick-I",{"v":0.75,"d":"0.75 ft"},"Wall Thick-II",{"$f":"13.5/12","v":{"v":1.125,"d":"1.125 ft"}},"MH Type-I","Assumed Quantity,",1]
[]
["Sr.#","Item of Works",null,"ABSTRACT OF QUANTIES",{"$nulls":5},"RATE ANALYSIS"]
[null,"Decription of items",null,"No. ","Length (ft)","width\n (ft)","Height (ft)","Unit ","Qty","Unit\nRate ","Amount ",null,null,"Total Qty","Total Rs."]
[1,"Excavation"]
[null,"Excavation ",null,{"$f":"+L5","v":1},{"$f":"+C5+3.5+0.75","v":8.25},{"$f":"+E10","v":8.25},{"$f":"+E5","v":{"v":6,"d":"6.00"}},null,{"$f":"PRODUCT(D10:G10)","v":{"v":408.375,"d":"408.38"}},{"v":12,"d":"12.00"},{"$f":"I11*J10","v":{"v":4900.5,"d":"4,900.50"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I10:I10)","v":{"v":408.375,"d":"408.38"}},null,null,{"$f":"+K10/$K$55","v":{"v":0.061949870669218386,"d":"6%"}},null,{"$f":"+I11*$J$56","v":{"v":79633.125,"d":"79,633.13"}},{"$f":"+I11*J10*$J$56","v":{"v":955597.5,"d":"955,598"}}]
[{"$f":"A9+1","v":2},"Dressing of bed"]
[null,"Dressing of bed",null,{"$f":"D10","v":1},{"$f":"+E10","v":8.25},{"$f":"((3.14*(($E$10-0.75)*($E$10-0.75))/4))","v":{"v":44.15625,"d":"44.16"}},null,null,{"$f":"PRODUCT(D13:G13)","v":{"v":364.2890625,"d":"364.29"}},{"v":4,"d":"4.00"},{"$f":"I14*J13","v":{"v":1457.15625,"d":"1,457.16"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Sft",{"$f":"SUM(I13:I13)","v":{"v":364.2890625,"d":"364.29"}},null,null,{"$f":"+K13/$K$55","v":{"v":0.01842070018005168,"d":"2%"}},null,{"$f":"+I14*$J$56","v":{"v":71036.3671875,"d":"71,036.37"}},{"$f":"+I14*J13*$J$56","v":{"v":284145.46875,"d":"284,145"}}]
[3,"Crurshed Stone Bedding"]
[null,"Crurshed Bedding 1\" Down",null,{"$f":"D10","v":1},"Area=",{"$f":"+F13","v":{"v":44.15625,"d":"44.16"}},{"v":0.5,"d":"0.50"},null,{"$f":"PRODUCT(D16:G16)","v":{"v":22.078125,"d":"22.08"}},{"v":140,"d":"140.00"},{"$f":"I17*J16","v":{"v":3090.9375,"d":"3,090.94"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I16:I16)","v":{"v":22.078125,"d":"22.08"}},null,null,{"$f":"+K16/$K$55","v":{"v":0.03907421250313993,"d":"4%"}},null,{"$f":"+I17*$J$56","v":{"v":4305.234375,"d":"4,305.23"}},{"$f":"+I17*J16*$J$56","v":{"v":602732.8125,"d":"602,733"}}]
[{"$f":"+A15+1","v":4},"PCC Concrete 1:4:8"]
[null,"Base Concrete 1:4:8",null,{"$f":"D13","v":1},"Area=",{"$f":"((3.14*(($E$10-1.75)*($E$10-1.75))/4))","v":{"v":33.16625,"d":"33.17"}},0.75,null,{"$f":"PRODUCT(D19:G19)","v":{"v":24.8746875,"d":"24.87"}},{"v":280,"d":"280.00"},{"$f":"I20*J19","v":{"v":6964.9125,"d":"6,964.91"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I19:I19)","v":{"v":24.8746875,"d":"24.87"}},null,null,{"$f":"+K19/$K$55","v":{"v":0.0880472255070753,"d":"9%"}},null,{"$f":"+I20*$J$56","v":{"v":4850.5640625,"d":"4,850.56"}},{"$f":"+I20*J19*$J$56","v":{"v":1358157.9375,"d":"1,358,158"}}]
[{"$f":"+A18+1","v":5},"Pacca Brick Work with 1:3 C/S Mortar"]
[null,"Wall (Circular) ",null,0,{"$f":"3.142*($C$5+$I$5)","v":{"v":16.10275,"d":"16.10"}},{"$f":"+I5","v":{"v":1.125,"d":"1.13"}},null,null,{"$f":"PRODUCT(D22:G22)","v":{"v":0,"d":"0.00"}},{"v":420,"d":"420.00"},{"$f":"+I25*J22","v":{"v":16319.78168625,"d":"16,319.78"}},null,null,{"$f":"3.14*4","v":12.56}]
[null,"Wall (Circular) ",null,{"$f":"+D19","v":1},{"$f":"3.142*($C$5+$I$5)","v":{"v":16.10275,"d":"16.10"}},{"$f":"$G$5","v":0.75},{"$f":"+G10-G16-G19-G24-G37","v":1.25},null,{"$f":"PRODUCT(D23:G23)","v":{"v":15.096328125,"d":"15.10"}}]
[null,"Wall (Dome)",null,{"$f":"D23","v":1},{"$f":"((3.142*($C$5+$G$5))+(3.142*(1.833+$G$5)))/2","v":{"v":11.520143000000001,"d":"11.52"}},{"$f":"$G$5","v":0.75},2.75,null,{"$f":"PRODUCT(D24:G24)","v":{"v":23.7602949375,"d":"23.76"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I22:I24)","v":{"v":38.8566230625,"d":"38.86"}},null,null,{"$f":"+K22/$K$55","v":{"v":0.2063071859632826,"d":"21%"}},null,{"$f":"+I25*$J$56","v":{"v":7577.0414971875,"d":"7,577.04"}},{"$f":"+I25*J22*$J$56","v":{"v":3182357.42881875,"d":"3,182,357"}}]
[{"$f":"+A21+1","v":6},"Plaster Work with 1:3 C/S Mortar"]
[null,"Wall (Circular) Outer Side",null,{"$f":"D24","v":1},{"$f":"3.142*(+$C$5+$G$5+$G$5)","v":{"v":17.281,"d":"17.28"}},null,{"$f":"+G23","v":1.25},null,{"$f":"PRODUCT(D27:G27)","v":{"v":21.60125,"d":"21.60"}},{"v":48,"d":"48.00"},{"$f":"+I31*J27","v":{"v":4832.2577519999995,"d":"4,832.26"}}]
[null,"Wall (Dome) Outer Side",null,{"$f":"D27","v":1},{"$f":"((3.142*($C$5+$G$5+$G$5))+(3.142*(1.833+$G$5+$G$5)))/2","v":{"v":13.876643,"d":"13.88"}},null,{"$f":"+G24","v":2.75},null,{"$f":"PRODUCT(D28:G28)","v":{"v":38.16076825,"d":"38.16"}}]
[null,"Wall (Circular) inner Side",null,1,{"$f":"3.142*(4)","v":{"v":12.568,"d":"12.57"}},null,{"$f":"+G27","v":1.25},null,{"$f":"PRODUCT(D29:G29)","v":{"v":15.709999999999999,"d":"15.71"}}]
[null,"Wall (Dome Inner Side",null,1,{"$f":"((3.142*(4))+(3.142*(1.833)))/2","v":{"v":9.163643,"d":"9.16"}},null,{"$f":"+G28","v":2.75},null,{"$f":"PRODUCT(D30:G30)","v":{"v":25.20001825,"d":"25.20"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Sft",{"$f":"SUM(I27:I30)","v":{"v":100.67203649999999,"d":"100.67"}},null,null,{"$f":"+K27/$K$55","v":{"v":0.061087183507137634,"d":"6%"}},null,{"$f":"+I31*$J$56","v":{"v":19631.0471175,"d":"19,631.05"}},{"$f":"+I31*J27*$J$56","v":{"v":942290.2616399999,"d":"942,290"}}]
[{"$f":"+A26+1","v":7},"Bituman Coating (2 Coats)"]
[null,"Wall (Circular) Outer Side",null,2,{"$f":"+E27","v":{"v":17.281,"d":"17.28"}},null,{"$f":"+G27","v":1.25},null,{"$f":"PRODUCT(D33:G33)","v":{"v":43.2025,"d":"43.20"}},{"v":14,"d":"14.00"},{"$f":"I35*J33","v":{"v":1673.336511,"d":"1,673.34"}}]
[null,"Wall (Dome) Outer Side",null,{"$f":"D33","v":2},{"$f":"+E28","v":{"v":13.876643,"d":"13.88"}},null,{"$f":"+G28","v":2.75},null,{"$f":"PRODUCT(D34:G34)","v":{"v":76.3215365,"d":"76.32"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Sft",{"$f":"SUM(I33:I34)","v":{"v":119.5240365,"d":"119.52"}},null,null,{"$f":"+K33/$K$55","v":{"v":0.021153551768703423,"d":"2%"}},null,{"$f":"+I35*$J$56","v":{"v":23307.187117499998,"d":"23,307.19"}},{"$f":"+I35*J33*$J$56","v":{"v":326300.61964499997,"d":"326,301"}}]
[{"$f":"+A32+1","v":8},"Concrete 1:2:4"]
[null,"Top Cover Slab",null,{"$f":"D24","v":1},"Area=",{"$f":"((3.14*(3.83*3.83))/4)","v":{"v":11.5150865,"d":"11.52"}},0.75,null,{"$f":"PRODUCT(D37:G37)","v":{"v":8.636314875,"d":"8.64"}},{"v":450,"d":"450.00"},{"$f":"I41*J37","v":{"v":9471.679166666669,"d":"9,471.68"}}]
[null,"D/d of Manhole Cover",null,-1,"Area=",{"$f":"((3.14*(1.83*1.83))/4)","v":{"v":2.6288865000000006,"d":"2.63"}},0.75,null,{"$f":"PRODUCT(D38:G38)","v":{"v":-1.9716648750000005,"d":"-1.97"}}]
[null,"Beching PCC",null,{"$f":"+D37","v":1},"Area=",{"$f":"((3.14*(C5*C5))/4)","v":12.56},{"$f":"0.33+($K$3+0.16)","v":{"v":1.1566666666666667,"d":"1.16"}},null,{"$f":"PRODUCT(D39:G39)","v":{"v":14.527733333333336,"d":"14.53"}}]
[null,"D/d of Pipe ",null,-1,"Area=",{"$f":"((3.14*(K3*K3))/4)/2","v":{"v":0.17444444444444443,"d":"0.17"}},{"$f":"($K$3+0.16)","v":{"v":0.8266666666666667,"d":"0.83"}},null,{"$f":"PRODUCT(D40:G40)","v":{"v":-0.1442074074074074,"d":"-0.14"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I37:I40)","v":{"v":21.04817592592593,"d":"21.05"}},null,null,{"$f":"+K37/$K$55","v":{"v":0.1197366185889869,"d":"12%"}},null,{"$f":"+I41*$J$56","v":{"v":4104.3943055555565,"d":"4,104.39"}},{"$f":"+I41*J37*$J$56","v":{"v":1846977.4375000005,"d":"1,846,977"}}]
[{"$f":"+A36+1","v":9},"Manhole Cover 22\" dia"]
[null," 22\" dia MH Cover",null,1,{"$nulls":4},{"$f":"PRODUCT(D43:G43)","v":{"v":1,"d":"1.00"}},{"$f":"5050+12185","v":{"v":17235,"d":"17235.00"}},{"$f":"I44*J43","v":{"v":17235,"d":"17,235.00"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"No",{"$f":"SUM(I43:I43)","v":{"v":1,"d":"1.00"}},null,null,{"$f":"+K43/$K$55","v":{"v":0.21787695561350454,"d":"22%"}},null,{"$f":"+I44*$J$56","v":{"v":195,"d":"195.00"}},{"$f":"+I44*J43*$J$56","v":{"v":3360825,"d":"3,360,825"}}]
[{"$f":"+A42+1","v":10},"Malleable Iron Step"]
[null,"Iron Step @1' C/C",null,1,null,"Brick Work Height",{"$f":"+(G23+G24)-1","v":{"v":3,"d":"3.00"}},null,{"$f":"ROUND(G46,0)","v":{"v":3,"d":"3.00"}},{"v":1550,"d":"1550.00"},{"$f":"I47*J46","v":{"v":4650,"d":"4,650.00"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"No",{"$f":"SUM(I46:I46)","v":{"v":3,"d":"3.00"}},null,null,{"$f":"+K46/$K$55","v":{"v":0.058783164699901136,"d":"6%"}},null,{"$f":"+I47*$J$56","v":{"v":585,"d":"585.00"}},{"$f":"+I47*J46*$J$56","v":{"v":906750,"d":"906,750"}}]
[{"$f":"+A45+1","v":11},"Backfill"]
[null,"Backfill (Total Excavation)",null,{"$f":"+D10","v":1},null,null,{"$f":"I11","v":{"v":408.375,"d":"408.38"}},null,{"$f":"PRODUCT(D49:G49)","v":{"v":408.375,"d":"408.38"}},{"v":32,"d":"32.00"},{"$f":"I51*J49","v":{"v":8508.720000000001,"d":"8,508.72"}}]
[null,"D/d of Manhole",null,-1,"Area",{"$f":"3.14*(($C$5+$G$5+$G$5)*($C$5+$G$5+$G$5))/4","v":{"v":23.74625,"d":"23.75"}},{"$f":"+G10","v":{"v":6,"d":"6.00"}},null,{"$f":"PRODUCT(D50:G50)","v":{"v":-142.4775,"d":"-142.48"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I49:I50)","v":{"v":265.89750000000004,"d":"265.90"}},null,null,{"$f":"+K49/$K$55","v":{"v":0.10756333099899847,"d":"11%"}},null,{"$f":"+I51*$J$56","v":{"v":51850.012500000004,"d":"51,850.01"}},{"$f":"+I51*J49*$J$56","v":{"v":1659200.4000000001,"d":"1,659,200"}}]
[{"$nulls":11},{"$f":"SUM(L10:L51)","v":{"v":1,"d":"100%"}}]
[{"$nulls":8}," Cost for 10 Rft "]
[{"$nulls":8},"Overhead 10%"]
[{"$nulls":8}," Total Cost =",null,{"$f":"SUM(K9:K54)","v":{"v":79104.28136591667,"d":"79,104"}}]
[{"$nulls":8},"Total of Manhole=",{"$f":"+Summary!E6","v":195},"No's"]
[{"$nulls":8},"Grand Total Cost=",null,{"$f":"+K55*J56","v":{"v":15425334.86635375,"d":"15,425,335"}},null,null,{"$f":"SUM(N9:N56)","v":{"v":267087.533162743,"d":"267,087.53"}},{"$f":"SUM(O9:O56)","v":{"v":15425334.86635375,"d":"15,425,335"}}]

{"sheet":"M.H 4'dia (Type-II.","index":2,"n_rows":57,"n_cols":15,"rows_kept":57,"merged":[[0,3,0,8],[6,0,7,0],[6,1,6,2],[6,3,6,8],[6,9,6,10],[7,1,7,2],[9,9,10,9],[9,10,10,10],[10,3,10,6],[12,9,13,9],[12,10,13,10],[13,3,13,6],[15,9,16,9],[15,10,16,10],[16,3,16,6],[18,9,19,9],[18,10,19,10],[19,3,19,6],[21,9,24,9],[21,10,24,10],[24,3,24,6],[26,9,30,9],[26,10,30,10],[30,3,30,6],[32,9,34,9],[32,10,34,10],[34,3,34,6],[36,9,40,9],[36,10,40,10],[40,3,40,6],[42,9,43,9],[42,10,43,10],[43,3,43,6],[45,9,46,9],[45,10,46,10],[46,3,46,6],[48,9,50,9],[48,10,50,10],[50,3,50,6]]}
[{"$nulls":3},{"$f":"+'M.H 4''dia (Type-I)'!D1:I1","v":"PROJECT NAME "},{"$nulls":5},"Manhole #"]
[{"$nulls":4},"CIVIL INFRASTRUCTURE WORKS",{"$nulls":4},"Road Name :"]
[{"$nulls":5},"RATE ANALYSIS",{"$nulls":3},"Sewer Line(Ø)",{"v":0.6666666666666666,"d":"0.67 ft"}]
["Manhole Data;"]
[null,"Manhole Inner dia(Ø)",{"v":4,"d":"4.00 ft"},"Depth of Manhole,",{"v":9,"d":"9.00 ft"},"Wall Thick-I",{"v":0.75,"d":"0.75 ft"},"Wall Thick-II",{"$f":"13.5/12","v":{"v":1.125,"d":"1.125 ft"}},"MH Type-II","Assumed Quantity,",1]
[]
["Sr.#","Item of Works",null,"ABSTRACT OF QUANTIES",{"$nulls":5},"RATE ANALYSIS"]
[null,"Decription of items",null,"No. ","Length (ft)","width\n (ft)","Height (ft)","Unit ","Qty","Unit\nRate ","Amount ",null,null,"Total Qty","Total Rs."]
[1,"Excavation"]
[null,"Excavation ",null,{"$f":"+L5","v":1},{"$f":"+C5+3.5+0.75","v":8.25},{"$f":"+E10","v":8.25},{"$f":"+E5","v":{"v":9,"d":"9.00"}},null,{"$f":"PRODUCT(D10:G10)","v":{"v":612.5625,"d":"612.56"}},{"$f":"+'M.H 4''dia (Type-I)'!J10:J11","v":{"v":12,"d":"12.00"}},{"$f":"I11*J10","v":{"v":7350.75,"d":"7,350.75"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I10:I10)","v":{"v":612.5625,"d":"612.56"}},null,null,{"$f":"+K10/$K$55","v":{"v":0.0659698803496046,"d":"7%"}},null,{"$f":"+I11*$J$56","v":{"v":42879.375,"d":"42,879.38"}},{"$f":"+I11*J10*$J$56","v":{"v":514552.5,"d":"514,553"}}]
[{"$f":"A9+1","v":2},"Dressing of bed"]
[null,"Dressing of bed",null,{"$f":"D10","v":1},{"$f":"+E10","v":8.25},{"$f":"((3.14*(($E$10-0.75)*($E$10-0.75))/4))","v":{"v":44.15625,"d":"44.16"}},null,null,{"$f":"PRODUCT(D13:G13)","v":{"v":364.2890625,"d":"364.29"}},{"$f":"+'M.H 4''dia (Type-I)'!J13:J14","v":{"v":4,"d":"4.00"}},{"$f":"I14*J13","v":{"v":1457.15625,"d":"1,457.16"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Sft",{"$f":"SUM(I13:I13)","v":{"v":364.2890625,"d":"364.29"}},null,null,{"$f":"+K13/$K$55","v":{"v":0.013077362645060509,"d":"1%"}},null,{"$f":"+I14*$J$56","v":{"v":25500.234375,"d":"25,500.23"}},{"$f":"+I14*J13*$J$56","v":{"v":102000.9375,"d":"102,001"}}]
[3,"Crurshed Stone Bedding"]
[null,"Crurshed Bedding 1\" Down",null,{"$f":"D10","v":1},"Area=",{"$f":"+F13","v":{"v":44.15625,"d":"44.16"}},{"v":0.5,"d":"0.50"},null,{"$f":"PRODUCT(D16:G16)","v":{"v":22.078125,"d":"22.08"}},{"$f":"+'M.H 4''dia (Type-I)'!J16:J17","v":{"v":140,"d":"140.00"}},{"$f":"I17*J16","v":{"v":3090.9375,"d":"3,090.94"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I16:I16)","v":{"v":22.078125,"d":"22.08"}},null,null,{"$f":"+K16/$K$55","v":{"v":0.02773986015618896,"d":"3%"}},null,{"$f":"+I17*$J$56","v":{"v":1545.46875,"d":"1,545.47"}},{"$f":"+I17*J16*$J$56","v":{"v":216365.625,"d":"216,366"}}]
[{"$f":"+A15+1","v":4},"PCC Concrete 1:4:8"]
[null,"Base Concrete 1:4:8",null,{"$f":"D13","v":1},"Area=",{"$f":"((3.14*(($E$10-1.75)*($E$10-1.75))/4))","v":{"v":33.16625,"d":"33.17"}},0.75,null,{"$f":"PRODUCT(D19:G19)","v":{"v":24.8746875,"d":"24.87"}},{"$f":"+'M.H 4''dia (Type-I)'!J19:J20","v":{"v":280,"d":"280.00"}},{"$f":"I20*J19","v":{"v":6964.9125,"d":"6,964.91"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I19:I19)","v":{"v":24.8746875,"d":"24.87"}},null,null,{"$f":"+K19/$K$55","v":{"v":0.06250715155194579,"d":"6%"}},null,{"$f":"+I20*$J$56","v":{"v":1741.228125,"d":"1,741.23"}},{"$f":"+I20*J19*$J$56","v":{"v":487543.875,"d":"487,544"}}]
[{"$f":"+A18+1","v":5},"Pacca Brick Work with 1:3 C/S Mortar"]
[null,"Wall (Circular) ",null,1,{"v":0,"d":"0.00"},{"$f":"+I5","v":{"v":1.125,"d":"1.13"}},null,null,{"$f":"PRODUCT(D22:G22)","v":{"v":0,"d":"0.00"}},{"$f":"+'M.H 4''dia (Type-I)'!J22:J25","v":{"v":420,"d":"420.00"}},{"$f":"+I25*J22","v":{"v":31536.880436250005,"d":"31,536.88"}}]
[null,"Wall (Circular) ",null,{"$f":"+D19","v":1},{"$f":"3.142*($C$5+$I$5)","v":{"v":16.10275,"d":"16.10"}},{"$f":"$G$5","v":0.75},{"$f":"+G10-G16-G19-G24-G37","v":4.25},null,{"$f":"PRODUCT(D23:G23)","v":{"v":51.327515625000004,"d":"51.33"}}]
[null,"Wall (Dome)",null,{"$f":"D23","v":1},{"$f":"((3.142*($C$5+$G$5))+(3.142*(1.833+$G$5)))/2","v":{"v":11.520143000000001,"d":"11.52"}},{"$f":"$G$5","v":0.75},2.75,null,{"v":23.7602949375,"d":"23.76"}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I22:I24)","v":{"v":75.08781056250001,"d":"75.09"}},null,null,{"$f":"+K22/$K$55","v":{"v":0.2830301981402169,"d":"28%"}},null,{"$f":"+I25*$J$56","v":{"v":5256.146739375001,"d":"5,256.15"}},{"$f":"+I25*J22*$J$56","v":{"v":2207581.6305375,"d":"2,207,582"}}]
[{"$f":"+A21+1","v":6},"Plaster Work with 1:3 C/S Mortar"]
[null,"Wall (Circular) Outer Side",null,{"$f":"D24","v":1},{"$f":"3.142*(+$C$5+$G$5+$G$5)","v":{"v":17.281,"d":"17.28"}},null,{"$f":"+G23","v":4.25},null,{"$f":"PRODUCT(D27:G27)","v":{"v":73.44425,"d":"73.44"}},{"$f":"+'M.H 4''dia (Type-I)'!J27:J31","v":{"v":48,"d":"48.00"}},{"$f":"+I31*J27","v":{"v":9130.513751999999,"d":"9,130.51"}}]
[null,"Wall (Dome) Outer Side",null,{"$f":"D27","v":1},{"$f":"((3.142*($C$5+$G$5+$G$5))+(3.142*(1.833+$G$5+$G$5)))/2","v":{"v":13.876643,"d":"13.88"}},null,{"$f":"+G24","v":2.75},null,{"$f":"PRODUCT(D28:G28)","v":{"v":38.16076825,"d":"38.16"}}]
[null,"Wall (Circular) inner Side",null,1,{"$f":"3.142*(4)","v":{"v":12.568,"d":"12.57"}},null,{"$f":"+G27","v":4.25},null,{"$f":"PRODUCT(D29:G29)","v":{"v":53.414,"d":"53.41"}}]
[null,"Wall (Dome Inner Side",null,1,{"$f":"((3.142*(4))+(3.142*(1.833)))/2","v":{"v":9.163643,"d":"9.16"}},null,{"$f":"+G28","v":2.75},null,{"$f":"PRODUCT(D30:G30)","v":{"v":25.20001825,"d":"25.20"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Sft",{"$f":"SUM(I27:I30)","v":{"v":190.2190365,"d":"190.22"}},null,null,{"$f":"+K27/$K$55","v":{"v":0.08194250923373253,"d":"8%"}},null,{"$f":"+I31*$J$56","v":{"v":13315.332554999999,"d":"13,315.33"}},{"$f":"+I31*J27*$J$56","v":{"v":639135.9626399999,"d":"639,136"}}]
[{"$f":"+A26+1","v":7},"Bituman Coating (2 Coats)"]
[null,"Wall (Circular) Outer Side",null,2,{"$f":"+E27","v":{"v":17.281,"d":"17.28"}},null,{"$f":"+G27","v":4.25},null,{"$f":"PRODUCT(D33:G33)","v":{"v":146.8885,"d":"146.89"}},{"$f":"+'M.H 4''dia (Type-I)'!J33:J35","v":{"v":14,"d":"14.00"}},{"$f":"I35*J33","v":{"v":3124.940511,"d":"3,124.94"}}]
[null,"Wall (Dome) Outer Side",null,{"$f":"D33","v":2},{"$f":"+E28","v":{"v":13.876643,"d":"13.88"}},null,{"$f":"+G28","v":2.75},null,{"$f":"PRODUCT(D34:G34)","v":{"v":76.3215365,"d":"76.32"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Sft",{"$f":"SUM(I33:I34)","v":{"v":223.2100365,"d":"223.21"}},null,null,{"$f":"+K33/$K$55","v":{"v":0.02804502283580618,"d":"3%"}},null,{"$f":"+I35*$J$56","v":{"v":15624.702555,"d":"15,624.70"}},{"$f":"+I35*J33*$J$56","v":{"v":218745.83576999998,"d":"218,746"}}]
[{"$f":"+A32+1","v":8},"Concrete 1:2:4"]
[null,"Top Cover Slab",null,{"$f":"D24","v":1},"Area=",{"$f":"((3.14*(3.83*3.83))/4)","v":{"v":11.5150865,"d":"11.52"}},0.75,null,{"$f":"PRODUCT(D37:G37)","v":{"v":8.636314875,"d":"8.64"}},{"$f":"+'M.H 4''dia (Type-I)'!J37:J41","v":{"v":450,"d":"450.00"}},{"$f":"I41*J37","v":{"v":9471.679166666669,"d":"9,471.68"}}]
[null,"D/d of Manhole Cover",null,-1,"Area=",{"$f":"((3.14*(1.83*1.83))/4)","v":{"v":2.6288865000000006,"d":"2.63"}},0.75,null,{"$f":"PRODUCT(D38:G38)","v":{"v":-1.9716648750000005,"d":"-1.97"}}]
[null,"Beching PCC",null,{"$f":"+D37","v":1},"Area=",{"$f":"((3.14*(C5*C5))/4)","v":12.56},{"$f":"0.33+($K$3+0.16)","v":{"v":1.1566666666666667,"d":"1.16"}},null,{"$f":"PRODUCT(D39:G39)","v":{"v":14.527733333333336,"d":"14.53"}}]
[null,"D/d of Pipe ",null,-1,"Area=",{"$f":"((3.14*(K3*K3))/4)/2","v":{"v":0.17444444444444443,"d":"0.17"}},{"$f":"($K$3+0.16)","v":{"v":0.8266666666666667,"d":"0.83"}},null,{"$f":"PRODUCT(D40:G40)","v":{"v":-0.1442074074074074,"d":"-0.14"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I37:I40)","v":{"v":21.04817592592593,"d":"21.05"}},null,null,{"$f":"+K37/$K$55","v":{"v":0.08500432491036192,"d":"9%"}},null,{"$f":"+I41*$J$56","v":{"v":1473.372314814815,"d":"1,473.37"}},{"$f":"+I41*J37*$J$56","v":{"v":663017.5416666667,"d":"663,018"}}]
[{"$f":"+A36+1","v":9},"Manhole Cover 22\" dia"]
[null," 22\" dia MH Cover",null,1,{"$nulls":4},{"$f":"PRODUCT(D43:G43)","v":{"v":1,"d":"1.00"}},{"$f":"+'M.H 4''dia (Type-I)'!J43:J44","v":{"v":17235,"d":"17235.00"}},{"$f":"I44*J43","v":{"v":17235,"d":"17,235.00"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"No",{"$f":"SUM(I43:I43)","v":{"v":1,"d":"1.00"}},null,null,{"$f":"+K43/$K$55","v":{"v":0.1546768544468844,"d":"15%"}},null,{"$f":"+I44*$J$56","v":{"v":70,"d":"70.00"}},{"$f":"+I44*J43*$J$56","v":{"v":1206450,"d":"1,206,450"}}]
[{"$f":"+A42+1","v":10},"Malleable Iron Step"]
[null,"Iron Step @1' C/C",null,1,null,"Brick Work Height",{"$f":"+(G23+G24)-1","v":{"v":6,"d":"6.00"}},null,{"$f":"ROUND(G46,0)","v":{"v":6,"d":"6.00"}},{"$f":"+'M.H 4''dia (Type-I)'!J46:J47","v":{"v":1550,"d":"1550.00"}},{"$f":"I47*J46","v":{"v":9300,"d":"9,300.00"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"No",{"$f":"SUM(I46:I46)","v":{"v":6,"d":"6.00"}},null,null,{"$f":"+K46/$K$55","v":{"v":0.08346357681206991,"d":"8%"}},null,{"$f":"+I47*$J$56","v":{"v":420,"d":"420.00"}},{"$f":"+I47*J46*$J$56","v":{"v":651000,"d":"651,000"}}]
[{"$f":"+A45+1","v":11},"Backfill"]
[null,"Backfill (Total Excavation)",null,{"$f":"+D10","v":1},null,null,{"$f":"I11","v":{"v":612.5625,"d":"612.56"}},null,{"$f":"PRODUCT(D49:G49)","v":{"v":612.5625,"d":"612.56"}},{"$f":"+'M.H 4''dia (Type-I)'!J49:J51","v":{"v":32,"d":"32.00"}},{"$f":"I51*J49","v":{"v":12763.08,"d":"12,763.08"}}]
[null,"D/d of Manhole",null,-1,"Area",{"$f":"3.14*(($C$5+$G$5+$G$5)*($C$5+$G$5+$G$5))/4","v":{"v":23.74625,"d":"23.75"}},{"$f":"+G10","v":{"v":9,"d":"9.00"}},null,{"$f":"PRODUCT(D50:G50)","v":{"v":-213.71625,"d":"-213.72"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I49:I50)","v":{"v":398.84625,"d":"398.85"}},null,null,{"$f":"+K49/$K$55","v":{"v":0.11454325891812829,"d":"11%"}},null,{"$f":"+I51*$J$56","v":{"v":27919.2375,"d":"27,919.24"}},{"$f":"+I51*J49*$J$56","v":{"v":893415.6,"d":"893,416"}}]
[{"$nulls":11},{"$f":"SUM(L9:L51)","v":{"v":1,"d":"100%"}}]
[{"$nulls":8}," Cost for 10 Rft "]
[{"$nulls":8},"Overhead 10%"]
[{"$nulls":8}," Total Cost =",null,{"$f":"SUM(K9:K54)","v":{"v":111425.85011591668,"d":"111,426"}}]
[{"$nulls":8},"Total of Manhole=",{"$f":"+Summary!G6","v":70},"No's"]
[{"$nulls":8},"Grand Total Cost=",null,{"$f":"+K55*J56","v":{"v":7799809.5081141675,"d":"7,799,810"}},null,null,{"$f":"SUM(N9:N56)","v":{"v":135745.0979141898,"d":"135,745.10"}},{"$f":"SUM(O9:O56)","v":{"v":7799809.508114167,"d":"7,799,810"}}]

{"sheet":"M.H 4'dia (Type-III","index":3,"n_rows":57,"n_cols":15,"rows_kept":57,"merged":[[0,3,0,8],[6,0,7,0],[6,1,6,2],[6,3,6,8],[6,9,6,10],[7,1,7,2],[9,9,10,9],[9,10,10,10],[10,3,10,6],[12,9,13,9],[12,10,13,10],[13,3,13,6],[15,9,16,9],[15,10,16,10],[16,3,16,6],[18,9,19,9],[18,10,19,10],[19,3,19,6],[21,9,24,9],[21,10,24,10],[24,3,24,6],[26,9,31,9],[26,10,31,10],[31,3,31,6],[33,9,36,9],[33,10,36,10],[36,3,36,6],[38,9,42,9],[38,10,42,10],[42,3,42,6],[44,9,45,9],[44,10,45,10],[45,3,45,6],[47,9,48,9],[47,10,48,10],[48,3,48,6],[50,9,52,9],[50,10,52,10],[52,3,52,6]]}
[{"$nulls":3},{"$f":"+'M.H 4''dia (Type-II.'!D1:I1","v":"PROJECT NAME "},{"$nulls":5},"Manhole #"]
[{"$nulls":4},"CIVIL INFRASTRUCTURE WORKS",{"$nulls":4},"Road Name :"]
[{"$nulls":5},"RATE ANALYSIS",{"$nulls":3},"Sewer Line (Ø)",{"v":0.8333333333333334,"d":"0.83 ft"}]
["Manhole Data;"]
[null,"Manhole Inner dia(Ø)",{"v":4,"d":"4.00 ft"},"Depth of Manhole,",{"v":13,"d":"13.00 ft"},"Wall Thick-I",{"v":0.75,"d":"0.75 ft"},"Wall Thick-II",{"$f":"13.5/12","v":{"v":1.125,"d":"1.125 ft"}},"MH Type-III","Assumed Quantity,",1]
[]
["Sr.#","Item of Works",null,"ABSTRACT OF QUANTIES",{"$nulls":5},"RATE ANALYSIS"]
[null,"Decription of items",null,"No. ","Length (ft)","width\n (ft)","Height (ft)","Unit ","Qty","Unit\nRate ","Amount ",null,null,"Total Qty","Total Rs."]
[1,"Excavation"]
[null,"Excavation ",null,{"$f":"+L5","v":1},{"$f":"+C5+4.25+0.75","v":{"v":9,"d":"9.00"}},{"$f":"+E10","v":{"v":9,"d":"9.00"}},{"$f":"+E5","v":{"v":13,"d":"13.00"}},null,{"$f":"PRODUCT(D10:G10)","v":{"v":1053,"d":"1053.00"}},{"$f":"+'M.H 4''dia (Type-II.'!J10:J11","v":{"v":12,"d":"12.00"}},{"$f":"I11*J10","v":{"v":12636,"d":"12,636.00"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I10:I10)","v":{"v":1053,"d":"1053.00"}},null,null,{"$f":"+K10/$K$55","v":{"v":0.08961816042187816,"d":"9%"}},null,{"$f":"+I11*$J$56","v":{"v":13689,"d":"13,689.00"}},{"$f":"+I11*J10*$J$56","v":{"v":164268,"d":"164,268"}}]
[{"$f":"A9+1","v":2},"Dressing of bed"]
[null,"Dressing of bed",null,{"$f":"D10","v":1},{"$f":"+E10","v":{"v":9,"d":"9.00"}},{"$f":"((3.14*(($E$10-0.75)*($E$10-0.75))/4))","v":{"v":53.4290625,"d":"53.43"}},null,null,{"$f":"PRODUCT(D13:G13)","v":{"v":480.8615625,"d":"480.86"}},{"$f":"+'M.H 4''dia (Type-II.'!J13:J14","v":{"v":4,"d":"4.00"}},{"$f":"I14*J13","v":{"v":1923.44625,"d":"1,923.45"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Sft",{"$f":"SUM(I13:I13)","v":{"v":480.8615625,"d":"480.86"}},null,null,{"$f":"+K13/$K$55","v":{"v":0.013641636166141181,"d":"1%"}},null,{"$f":"+I14*$J$56","v":{"v":6251.2003125,"d":"6,251.20"}},{"$f":"+I14*J13*$J$56","v":{"v":25004.80125,"d":"25,005"}}]
[3,"Crurshed Stone Bedding"]
[null,"Crurshed Bedding 1\" Down",null,{"$f":"D10","v":1},"Area=",{"$f":"+F13","v":{"v":53.4290625,"d":"53.43"}},{"v":1,"d":"1.00"},null,{"$f":"PRODUCT(D16:G16)","v":{"v":53.4290625,"d":"53.43"}},{"$f":"+'M.H 4''dia (Type-II.'!J16:J17","v":{"v":140,"d":"140.00"}},{"$f":"I17*J16","v":{"v":7480.06875,"d":"7,480.07"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I16:I16)","v":{"v":53.4290625,"d":"53.43"}},null,null,{"$f":"+K16/$K$55","v":{"v":0.053050807312771266,"d":"5%"}},null,{"$f":"+I17*$J$56","v":{"v":694.5778125,"d":"694.58"}},{"$f":"+I17*J16*$J$56","v":{"v":97240.89375,"d":"97,241"}}]
[{"$f":"+A15+1","v":4},"PCC Concrete 1:4:8"]
[null,"Base Concrete 1:4:8",null,{"$f":"D13","v":1},"Area=",{"$f":"((3.14*(($E$10-1.75)*($E$10-1.75))/4))","v":{"v":41.261562500000004,"d":"41.26"}},0.75,null,{"$f":"PRODUCT(D19:G19)","v":{"v":30.946171875000005,"d":"30.95"}},{"$f":"+'M.H 4''dia (Type-II.'!J19:J20","v":{"v":280,"d":"280.00"}},{"$f":"I20*J19","v":{"v":8664.928125000002,"d":"8,664.93"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I19:I19)","v":{"v":30.946171875000005,"d":"30.95"}},null,null,{"$f":"+K19/$K$55","v":{"v":0.061454172107493994,"d":"6%"}},null,{"$f":"+I20*$J$56","v":{"v":402.30023437500006,"d":"402.30"}},{"$f":"+I20*J19*$J$56","v":{"v":112644.06562500003,"d":"112,644"}}]
[{"$f":"+A18+1","v":5},"Pacca Brick Work with 1:3 C/S Mortar"]
[null,"Wall (Circular) ",null,1,{"$f":"3.142*($C$5+$I$5)","v":{"v":16.10275,"d":"16.10"}},{"$f":"+I5","v":{"v":1.125,"d":"1.13"}},{"$f":"+$G$10-$G$16-$G$19-G23-G23-G39","v":{"v":0,"d":"0.00"}},null,{"$f":"PRODUCT(D22:G22)","v":{"v":0,"d":"0.00"}},{"$f":"+'M.H 4''dia (Type-II.'!J22:J25","v":{"v":420,"d":"420.00"}},{"$f":"+I25*J22","v":{"v":34660.71574875,"d":"34,660.72"}}]
[null,"Wall (Circular) ",null,{"$f":"+D19","v":1},{"$f":"3.142*($C$5+$G$5)","v":{"v":14.9245,"d":"14.92"}},{"$f":"$G$5","v":0.75},{"$f":"8-G24","v":5.25},null,{"$f":"PRODUCT(D23:G23)","v":{"v":58.765218749999995,"d":"58.77"}}]
[null,"Wall (Dome)",null,{"$f":"D23","v":1},{"$f":"((3.142*($C$5+$G$5))+(3.142*(1.833+$G$5)))/2","v":{"v":11.520143000000001,"d":"11.52"}},{"$f":"$G$5","v":0.75},2.75,null,{"v":23.7602949375,"d":"23.76"}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I22:I24)","v":{"v":82.5255136875,"d":"82.53"}},null,null,{"$f":"+K22/$K$55","v":{"v":0.2458238037597813,"d":"25%"}},null,{"$f":"+I25*$J$56","v":{"v":1072.8316779375,"d":"1,072.83"}},{"$f":"+I25*J22*$J$56","v":{"v":450589.30473375,"d":"450,589"}}]
[{"$f":"+A21+1","v":6},"Plaster Work with 1:3 C/S Mortar"]
[null,"Wall (Circular) Outer Side",null,{"$f":"D24","v":1},{"$f":"3.142*(+$C$5+$I$5+$I$5)","v":{"v":19.6375,"d":"19.64"}},null,{"$f":"+G22","v":{"v":0,"d":"0.00"}},null,{"$f":"PRODUCT(D27:G27)","v":{"v":0,"d":"0.00"}},{"$f":"+'M.H 4''dia (Type-II.'!J27:J31","v":{"v":48,"d":"48.00"}},{"$f":"+I32*J27","v":{"v":9764.946391999998,"d":"9,764.95"}}]
[null,"Wall (Circular) Outer Side",null,{"$f":"+D27","v":1},{"$f":"3.142*(+$C$5+$G$5+$G$5)","v":{"v":17.281,"d":"17.28"}},null,{"$f":"+G23","v":5.25},null,{"$f":"PRODUCT(D28:G28)","v":{"v":90.72524999999999,"d":"90.73"}}]
[null,"Wall (Dome) Outer Side",null,{"$f":"D27","v":1},{"$f":"((3.142*($C$5+$G$5+$G$5))+(3.142*(1.833+$G$5+$G$5)))/2","v":{"v":13.876643,"d":"13.88"}},null,{"$f":"+G24","v":2.75},null,{"$f":"PRODUCT(D29:G29)","v":{"v":38.16076825,"d":"38.16"}}]
[null,"Wall (Circular) inner Side",null,1,{"$f":"3.142*($C$5)","v":{"v":12.568,"d":"12.57"}},null,{"$f":"+G27+G28-G41","v":{"v":3.9266666666666667,"d":"3.93"}},null,{"$f":"PRODUCT(D30:G30)","v":{"v":49.35034666666667,"d":"49.35"}}]
[null,"Wall (Dome Inner Side",null,{"$f":"D30","v":1},{"$f":"((3.142*($C$5))+(3.142*(1.833)))/2","v":{"v":9.163643,"d":"9.16"}},null,{"$f":"+G29","v":2.75},null,{"$f":"PRODUCT(D31:G31)","v":{"v":25.20001825,"d":"25.20"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Sft",{"$f":"SUM(I27:I31)","v":{"v":203.43638316666664,"d":"203.44"}},null,null,{"$f":"+K27/$K$55","v":{"v":0.06925581926790884,"d":"7%"}},null,{"$f":"+I32*$J$56","v":{"v":2644.6729811666664,"d":"2,644.67"}},{"$f":"+I32*J27*$J$56","v":{"v":126944.30309599997,"d":"126,944"}}]
[{"$f":"+A26+1","v":7},"Bituman Coating (2 Coats)"]
[null,"Wall (Circular) Outer Side",null,2,{"$f":"+E27","v":{"v":19.6375,"d":"19.64"}},null,{"$f":"+G27","v":{"v":0,"d":"0.00"}},null,{"$f":"PRODUCT(D34:G34)","v":{"v":0,"d":"0.00"}},{"v":14,"d":"14.00"},{"$f":"I37*J34","v":{"v":3608.8085109999993,"d":"3,608.81"}}]
[null,"Wall (Circular) Outer Side",null,{"$f":"+D34","v":2},{"$f":"+E28","v":{"v":17.281,"d":"17.28"}},null,{"$f":"+G28","v":5.25},null,{"$f":"PRODUCT(D35:G35)","v":{"v":181.45049999999998,"d":"181.45"}}]
[null,"Wall (Dome) Outer Side",null,{"$f":"D34","v":2},{"$f":"+E29","v":{"v":13.876643,"d":"13.88"}},null,{"$f":"+G29","v":2.75},null,{"$f":"PRODUCT(D36:G36)","v":{"v":76.3215365,"d":"76.32"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Sft",{"$f":"SUM(I34:I36)","v":{"v":257.77203649999996,"d":"257.77"}},null,null,{"$f":"+K34/$K$55","v":{"v":0.025594711939746533,"d":"3%"}},null,{"$f":"+I37*$J$56","v":{"v":3351.0364744999993,"d":"3,351.04"}},{"$f":"+I37*J34*$J$56","v":{"v":46914.51064299999,"d":"46,915"}}]
[{"$f":"+A33+1","v":8},"Concrete 1:2:4"]
[null,"Top Cover Slab",null,{"$f":"D24","v":1},"Area=",{"$f":"((3.14*(3.83*3.83))/4)","v":{"v":11.5150865,"d":"11.52"}},0.75,null,{"$f":"PRODUCT(D39:G39)","v":{"v":8.636314875,"d":"8.64"}},{"v":450,"d":"450.00"},{"$f":"I43*J39","v":{"v":10356.733958333332,"d":"10,356.73"}}]
[null,"D/d of Manhole Cover",null,-1,"Area=",{"$f":"((3.14*(1.83*1.83))/4)","v":{"v":2.6288865000000006,"d":"2.63"}},0.75,null,{"$f":"PRODUCT(D40:G40)","v":{"v":-1.9716648750000005,"d":"-1.97"}}]
[null,"Beching PCC",null,{"$f":"+D39","v":1},"Area=",{"$f":"((3.14*(C5*C5))/4)","v":12.56},{"$f":"0.33+($K$3+0.16)","v":{"v":1.3233333333333335,"d":"1.32"}},null,{"$f":"PRODUCT(D41:G41)","v":{"v":16.621066666666668,"d":"16.62"}}]
[null,"D/d of Pipe ",null,-1,"Area=",{"$f":"((3.14*(K3*K3))/4)/2","v":{"v":0.2725694444444445,"d":"0.27"}},{"$f":"($K$3+0.16)","v":{"v":0.9933333333333334,"d":"0.99"}},null,{"$f":"PRODUCT(D42:G42)","v":{"v":-0.2707523148148149,"d":"-0.27"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I39:I42)","v":{"v":23.01496435185185,"d":"23.01"}},null,null,{"$f":"+K39/$K$55","v":{"v":0.07345294755655507,"d":"7%"}},null,{"$f":"+I43*$J$56","v":{"v":299.19453657407405,"d":"299.19"}},{"$f":"+I43*J39*$J$56","v":{"v":134637.54145833332,"d":"134,638"}}]
[{"$f":"+A38+1","v":9},"Manhole Cover 22\" dia"]
[null," 22\" dia MH Cover",null,1,{"$nulls":4},{"$f":"PRODUCT(D45:G45)","v":{"v":1,"d":"1.00"}},{"v":17235,"d":"17235.00"},{"$f":"I46*J45","v":{"v":17235,"d":"17,235.00"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"No",{"$f":"SUM(I45:I45)","v":{"v":1,"d":"1.00"}},null,null,{"$f":"+K45/$K$55","v":{"v":0.12223559630192071,"d":"12%"}},null,{"$f":"+I46*$J$56","v":{"v":13,"d":"13.00"}},{"$f":"+I46*J45*$J$56","v":{"v":224055,"d":"224,055"}}]
[{"$f":"+A44+1","v":10},"Malleable Iron Step"]
[null,"Iron Step @1' C/C",null,1,null,"Brick Work Height",{"$f":"+(G23+G22+G24)-1","v":{"v":7,"d":"7.00"}},null,{"$f":"ROUND(G48,0)","v":{"v":7,"d":"7.00"}},{"v":1550,"d":"1550.00"},{"$f":"I49*J48","v":{"v":10850,"d":"10,850.00"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"No",{"$f":"SUM(I48:I48)","v":{"v":7,"d":"7.00"}},null,null,{"$f":"+K48/$K$55","v":{"v":0.07695133274591469,"d":"8%"}},null,{"$f":"+I49*$J$56","v":{"v":91,"d":"91.00"}},{"$f":"+I49*J48*$J$56","v":{"v":141050,"d":"141,050"}}]
[{"$f":"+A47+1","v":11},"Backfill"]
[null,"Backfill (Total Excavation)",null,{"$f":"+D10","v":1},null,null,{"$f":"I11","v":{"v":1053,"d":"1053.00"}},null,{"$f":"PRODUCT(D51:G51)","v":{"v":1053,"d":"1053.00"}},{"v":32,"d":"32.00"},{"$f":"I53*J51","v":{"v":23817.559999999998,"d":"23,817.56"}}]
[null,"D/d of Manhole",null,-1,"Area",{"$f":"3.14*(($C$5+$G$5+$G$5)*($C$5+$G$5+$G$5))/4","v":{"v":23.74625,"d":"23.75"}},{"$f":"+G10","v":{"v":13,"d":"13.00"}},null,{"$f":"PRODUCT(D52:G52)","v":{"v":-308.70125,"d":"-308.70"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I51:I52)","v":{"v":744.2987499999999,"d":"744.30"}},null,null,{"$f":"+K51/$K$55","v":{"v":0.16892101241988827,"d":"17%"}},null,{"$f":"+I53*$J$56","v":{"v":9675.883749999999,"d":"9,675.88"}},{"$f":"+I53*J51*$J$56","v":{"v":309628.27999999997,"d":"309,628"}}]
[{"$nulls":11},{"$f":"SUM(L10:L53)","v":{"v":1,"d":"100%"}}]
[{"$nulls":8}," Total Cost =",null,{"$f":"SUM(K9:K54)","v":{"v":140998.20773508333,"d":"140,998"}}]
[{"$nulls":8},"Total of Manhole=",{"$f":"+Summary!I6","v":13},"No's"]
[{"$nulls":8},"Grand Total Cost=",null,{"$f":"+K55*J56","v":{"v":1832976.7005560833,"d":"1,832,977"}},null,null,{"$f":"SUM(N9:N56)","v":{"v":38184.697779553244,"d":"38,184.70"}},{"$f":"SUM(O9:O56)","v":{"v":1832976.7005560833,"d":"1,832,977"}}]

{"sheet":"M.H 4'dia (Type-IV","index":4,"n_rows":57,"n_cols":15,"rows_kept":57,"merged":[[0,3,0,8],[6,0,7,0],[6,1,6,2],[6,3,6,8],[6,9,6,10],[7,1,7,2],[9,9,10,9],[9,10,10,10],[10,3,10,6],[12,9,13,9],[12,10,13,10],[13,3,13,6],[15,9,16,9],[15,10,16,10],[16,3,16,6],[18,9,19,9],[18,10,19,10],[19,3,19,6],[21,9,24,9],[21,10,24,10],[24,3,24,6],[26,9,31,9],[26,10,31,10],[31,3,31,6],[33,9,36,9],[33,10,36,10],[36,3,36,6],[38,9,42,9],[38,10,42,10],[42,3,42,6],[44,9,45,9],[44,10,45,10],[45,3,45,6],[47,9,48,9],[47,10,48,10],[48,3,48,6],[50,9,52,9],[50,10,52,10],[52,3,52,6]]}
[{"$nulls":3},{"$f":"+'M.H 4''dia (Type-III'!D1","v":"PROJECT NAME "},{"$nulls":5},"Manhole #"]
[{"$nulls":4},"CIVIL INFRASTRUCTURE WORKS",{"$nulls":4},"Road Name :"]
[{"$nulls":5},"RATE ANALYSIS",{"$nulls":3},"Sewer Line (Ø)",{"$f":"12.5/12","v":{"v":1.0416666666666667,"d":"1.04 ft"}}]
["Manhole Data;"]
[null,"Manhole Inner dia(Ø)",{"v":4,"d":"4.00 ft"},"Depth of Manhole,",{"v":17,"d":"17.00 ft"},"Wall Thick-I",{"v":0.75,"d":"0.75 ft"},"Wall Thick-II",{"$f":"13.5/12","v":{"v":1.125,"d":"1.125 ft"}},"MH Type-IV","Assumed Quantity,",1]
[]
["Sr.#","Item of Works",null,"ABSTRACT OF QUANTIES",{"$nulls":5},"RATE ANALYSIS"]
[null,"Decription of items",null,"No. ","Length (ft)","width\n (ft)","Height (ft)","Unit ","Qty","Unit\nRate ","Amount ",null,null,"Total Qty","Total Rs."]
[1,"Excavation"]
[null,"Excavation ",null,{"$f":"+L5","v":1},{"$f":"+C5+4.25+0.75","v":{"v":9,"d":"9.00"}},{"$f":"+E10","v":{"v":9,"d":"9.00"}},{"$f":"+E5","v":{"v":17,"d":"17.00"}},null,{"$f":"PRODUCT(D10:G10)","v":{"v":1377,"d":"1377.00"}},{"$f":"+'M.H 4''dia (Type-II.'!J10:J11","v":{"v":12,"d":"12.00"}},{"$f":"I11*J10","v":{"v":16524,"d":"16,524.00"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I10:I10)","v":{"v":1377,"d":"1377.00"}},null,null,{"$f":"+K10/$K$55","v":{"v":0.08338080823027211,"d":"8%"}},null,{"$f":"+I11*$J$56","v":{"v":20655,"d":"20,655.00"}},{"$f":"+I11*J10*$J$56","v":{"v":247860,"d":"247,860"}}]
[{"$f":"A9+1","v":2},"Dressing of bed"]
[null,"Dressing of bed",null,{"$f":"D10","v":1},{"$f":"+E10","v":{"v":9,"d":"9.00"}},{"$f":"((3.14*(($E$10-0.75)*($E$10-0.75))/4))","v":{"v":53.4290625,"d":"53.43"}},null,null,{"$f":"PRODUCT(D13:G13)","v":{"v":480.8615625,"d":"480.86"}},{"$f":"+'M.H 4''dia (Type-II.'!J13:J14","v":{"v":4,"d":"4.00"}},{"$f":"I14*J13","v":{"v":1923.44625,"d":"1,923.45"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Sft",{"$f":"SUM(I13:I13)","v":{"v":480.8615625,"d":"480.86"}},null,null,{"$f":"+K13/$K$55","v":{"v":9.705791752147544E-3,"d":"1%"}},null,{"$f":"+I14*$J$56","v":{"v":7212.9234375,"d":"7,212.92"}},{"$f":"+I14*J13*$J$56","v":{"v":28851.69375,"d":"28,852"}}]
[3,"Crurshed Stone Bedding"]
[null,"Crurshed Bedding 1\" Down",null,{"$f":"D10","v":1},"Area=",{"$f":"+F13","v":{"v":53.4290625,"d":"53.43"}},{"v":1,"d":"1.00"},null,{"$f":"PRODUCT(D16:G16)","v":{"v":53.4290625,"d":"53.43"}},{"$f":"+'M.H 4''dia (Type-II.'!J16:J17","v":{"v":140,"d":"140.00"}},{"$f":"I17*J16","v":{"v":7480.06875,"d":"7,480.07"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I16:I16)","v":{"v":53.4290625,"d":"53.43"}},null,null,{"$f":"+K16/$K$55","v":{"v":0.03774474570279601,"d":"4%"}},null,{"$f":"+I17*$J$56","v":{"v":801.4359375,"d":"801.44"}},{"$f":"+I17*J16*$J$56","v":{"v":112201.03125,"d":"112,201"}}]
[{"$f":"+A15+1","v":4},"PCC Concrete 1:4:8"]
[null,"Base Concrete 1:4:8",null,{"$f":"D13","v":1},"Area=",{"$f":"((3.14*(($E$10-1.75)*($E$10-1.75))/4))","v":{"v":41.261562500000004,"d":"41.26"}},0.75,null,{"$f":"PRODUCT(D19:G19)","v":{"v":30.946171875000005,"d":"30.95"}},{"$f":"+'M.H 4''dia (Type-II.'!J19:J20","v":{"v":280,"d":"280.00"}},{"$f":"I20*J19","v":{"v":8664.928125000002,"d":"8,664.93"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I19:I19)","v":{"v":30.946171875000005,"d":"30.95"}},null,null,{"$f":"+K19/$K$55","v":{"v":0.043723596606131475,"d":"4%"}},null,{"$f":"+I20*$J$56","v":{"v":464.19257812500007,"d":"464.19"}},{"$f":"+I20*J19*$J$56","v":{"v":129973.92187500003,"d":"129,974"}}]
[{"$f":"+A18+1","v":5},"Pacca Brick Work with 1:3 C/S Mortar"]
[null,"Wall (Circular) ",null,1,{"$f":"3.142*($C$5+$I$5)","v":{"v":16.10275,"d":"16.10"}},{"$f":"+I5","v":{"v":1.125,"d":"1.13"}},{"$f":"+$G$10-$G$16-$G$19-G23-G23-G39","v":{"v":4,"d":"4.00"}},null,{"$f":"PRODUCT(D22:G22)","v":{"v":72.46237500000001,"d":"72.46"}},{"$f":"+'M.H 4''dia (Type-II.'!J22:J25","v":{"v":420,"d":"420.00"}},{"$f":"+I25*J22","v":{"v":65094.91324875,"d":"65,094.91"}}]
[null,"Wall (Circular) ",null,{"$f":"+D19","v":1},{"$f":"3.142*($C$5+$G$5)","v":{"v":14.9245,"d":"14.92"}},{"$f":"$G$5","v":0.75},{"$f":"8-G24","v":5.25},null,{"$f":"PRODUCT(D23:G23)","v":{"v":58.765218749999995,"d":"58.77"}}]
[null,"Wall (Dome)",null,{"$f":"D23","v":1},{"$f":"((3.142*($C$5+$G$5))+(3.142*(1.833+$G$5)))/2","v":{"v":11.520143000000001,"d":"11.52"}},{"$f":"$G$5","v":0.75},2.75,null,{"v":23.7602949375,"d":"23.76"}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I22:I24)","v":{"v":154.9878886875,"d":"154.99"}},null,null,{"$f":"+K22/$K$55","v":{"v":0.32847170650933327,"d":"33%"}},null,{"$f":"+I25*$J$56","v":{"v":2324.8183303125,"d":"2,324.82"}},{"$f":"+I25*J22*$J$56","v":{"v":976423.69873125,"d":"976,424"}}]
[{"$f":"+A21+1","v":6},"Bituman Coating (2 Coats)"]
[null,"Wall (Circular) Outer Side",null,{"$f":"D24","v":1},{"$f":"3.142*(+$C$5+$I$5+$I$5)","v":{"v":19.6375,"d":"19.64"}},null,{"$f":"+G22","v":{"v":4,"d":"4.00"}},null,{"$f":"PRODUCT(D27:G27)","v":78.55},{"$f":"+'M.H 4''dia (Type-II.'!J27:J31","v":{"v":48,"d":"48.00"}},{"$f":"+I32*J27","v":{"v":15822.722391999996,"d":"15,822.72"}}]
[null,"Wall (Circular) Outer Side",null,{"$f":"+D27","v":1},{"$f":"3.142*(+$C$5+$G$5+$G$5)","v":{"v":17.281,"d":"17.28"}},null,{"$f":"+G23","v":5.25},null,{"$f":"PRODUCT(D28:G28)","v":{"v":90.72524999999999,"d":"90.73"}}]
[null,"Wall (Dome) Outer Side",null,{"$f":"D27","v":1},{"$f":"((3.142*($C$5+$G$5+$G$5))+(3.142*(1.833+$G$5+$G$5)))/2","v":{"v":13.876643,"d":"13.88"}},null,{"$f":"+G24","v":2.75},null,{"$f":"PRODUCT(D29:G29)","v":{"v":38.16076825,"d":"38.16"}}]
[null,"Wall (Circular) inner Side",null,1,{"$f":"3.142*($C$5)","v":{"v":12.568,"d":"12.57"}},null,{"$f":"+G27+G28-G41","v":{"v":7.718333333333334,"d":"7.72"}},null,{"$f":"PRODUCT(D30:G30)","v":{"v":97.00401333333333,"d":"97.00"}}]
[null,"Wall (Dome Inner Side",null,{"$f":"D30","v":1},{"$f":"((3.142*($C$5))+(3.142*(1.833)))/2","v":{"v":9.163643,"d":"9.16"}},null,{"$f":"+G29","v":2.75},null,{"$f":"PRODUCT(D31:G31)","v":{"v":25.20001825,"d":"25.20"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Sft",{"$f":"SUM(I27:I31)","v":{"v":329.64004983333325,"d":"329.64"}},null,null,{"$f":"K27/$K$55","v":{"v":0.07984213153281192,"d":"8%"}},null,{"$f":"+I32*$J$56","v":{"v":4944.600747499999,"d":"4,944.60"}},{"$f":"+I32*J27*$J$56","v":{"v":237340.83587999994,"d":"237,341"}}]
[{"$f":"+A26+1","v":7},"Bituman Coating "]
[null,"Wall (Circular) Outer Side",null,2,{"$f":"+E27","v":{"v":19.6375,"d":"19.64"}},null,{"$f":"+G27","v":{"v":4,"d":"4.00"}},null,{"$f":"PRODUCT(D34:G34)","v":{"v":157.1,"d":"157.10"}},{"v":14,"d":"14.00"},{"$f":"I37*J34","v":{"v":5808.208510999999,"d":"5,808.21"}}]
[null,"Wall (Circular) Outer Side",null,{"$f":"+D34","v":2},{"$f":"+E28","v":{"v":17.281,"d":"17.28"}},null,{"$f":"+G28","v":5.25},null,{"$f":"PRODUCT(D35:G35)","v":{"v":181.45049999999998,"d":"181.45"}}]
[null,"Wall (Dome) Outer Side",null,{"$f":"D34","v":2},{"$f":"+E29","v":{"v":13.876643,"d":"13.88"}},null,{"$f":"+G29","v":2.75},null,{"$f":"PRODUCT(D36:G36)","v":{"v":76.3215365,"d":"76.32"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Sft",{"$f":"SUM(I34:I36)","v":{"v":414.8720364999999,"d":"414.87"}},null,null,{"$f":"+K34/$K$55","v":{"v":0.02930846768440603,"d":"3%"}},null,{"$f":"+I37*$J$56","v":{"v":6223.080547499999,"d":"6,223.08"}},{"$f":"+I37*J34*$J$56","v":{"v":87123.12766499998,"d":"87,123"}}]
[{"$f":"+A33+1","v":8},"Concrete 1:2:4"]
[null,"Top Cover Slab",null,{"$f":"D24","v":1},"Area=",{"$f":"((3.14*(3.83*3.83))/4)","v":{"v":11.5150865,"d":"11.52"}},0.75,null,{"$f":"PRODUCT(D39:G39)","v":{"v":8.636314875,"d":"8.64"}},{"v":450,"d":"450.00"},{"$f":"I43*J39","v":{"v":11425.772613932291,"d":"11,425.77"}}]
[null,"D/d of Manhole Cover",null,-1,"Area=",{"$f":"((3.14*(1.83*1.83))/4)","v":{"v":2.6288865000000006,"d":"2.63"}},0.75,null,{"$f":"PRODUCT(D40:G40)","v":{"v":-1.9716648750000005,"d":"-1.97"}}]
[null,"Beching PCC",null,{"$f":"+D39","v":1},"Area=",{"$f":"((3.14*(C5*C5))/4)","v":12.56},{"$f":"0.33+($K$3+0.16)","v":{"v":1.5316666666666667,"d":"1.53"}},null,{"$f":"PRODUCT(D41:G41)","v":{"v":19.237733333333335,"d":"19.24"}}]
[null,"D/d of Pipe ",null,-1,"Area=",{"$f":"((3.14*(K3*K3))/4)/2","v":{"v":0.42588975694444453,"d":"0.43"}},{"$f":"($K$3+0.16)","v":{"v":1.2016666666666667,"d":"1.20"}},null,{"$f":"PRODUCT(D42:G42)","v":{"v":-0.5117775245949076,"d":"-0.51"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I39:I42)","v":{"v":25.390605808738425,"d":"25.39"}},null,null,{"$f":"+K39/$K$55","v":{"v":0.057654935560698575,"d":"6%"}},null,{"$f":"+I43*$J$56","v":{"v":380.85908713107636,"d":"380.86"}},{"$f":"+I43*J39*$J$56","v":{"v":171386.58920898437,"d":"171,387"}}]
[{"$f":"+A38+1","v":9},"Manhole Cover 22\" dia"]
[null," 22\" dia MH Cover",null,1,{"$nulls":4},{"$f":"PRODUCT(D45:G45)","v":{"v":1,"d":"1.00"}},{"v":17235,"d":"17235.00"},{"$f":"I46*J45","v":{"v":17235,"d":"17,235.00"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"No",{"$f":"SUM(I45:I45)","v":{"v":1,"d":"1.00"}},null,null,{"$f":"+K45/$K$55","v":{"v":0.08696854453211933,"d":"9%"}},null,{"$f":"+I46*$J$56","v":{"v":15,"d":"15.00"}},{"$f":"+I46*J45*$J$56","v":{"v":258525,"d":"258,525"}}]
[{"$f":"+A44+1","v":10},"Malleable Iron Step"]
[null,"Iron Step @1' C/C",null,1,null,"Brick Work Height",{"$f":"+(G23+G22+G24)-1","v":{"v":11,"d":"11.00"}},null,{"$f":"ROUND(G48,0)","v":{"v":11,"d":"11.00"}},{"v":1550,"d":"1550.00"},{"$f":"I49*J48","v":{"v":17050,"d":"17,050.00"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"No",{"$f":"SUM(I48:I48)","v":{"v":11,"d":"11.00"}},null,null,{"$f":"+K48/$K$55","v":{"v":0.08603502664767244,"d":"9%"}},null,{"$f":"+I49*$J$56","v":{"v":165,"d":"165.00"}},{"$f":"+I49*J48*$J$56","v":{"v":255750,"d":"255,750"}}]
[{"$f":"+A47+1","v":11},"Backfill"]
[null,"Backfill (Total Excavation)",null,{"$f":"+D10","v":1},null,null,{"$f":"I11","v":{"v":1377,"d":"1377.00"}},null,{"$f":"PRODUCT(D51:G51)","v":{"v":1377,"d":"1377.00"}},{"v":32,"d":"32.00"},{"$f":"I53*J51","v":{"v":31146.04,"d":"31,146.04"}}]
[null,"D/d of Manhole",null,-1,"Area",{"$f":"3.14*(($C$5+$G$5+$G$5)*($C$5+$G$5+$G$5))/4","v":{"v":23.74625,"d":"23.75"}},{"$f":"+G10","v":{"v":17,"d":"17.00"}},null,{"$f":"PRODUCT(D52:G52)","v":{"v":-403.68625,"d":"-403.69"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I51:I52)","v":{"v":973.31375,"d":"973.31"}},null,null,{"$f":"+K51/$K$55","v":{"v":0.15716424524161127,"d":"16%"}},null,{"$f":"+I53*$J$56","v":{"v":14599.706250000001,"d":"14,599.71"}},{"$f":"+I53*J51*$J$56","v":{"v":467190.60000000003,"d":"467,191"}}]
[{"$nulls":11},{"$f":"SUM(L10:L53)","v":{"v":1,"d":"100%"}}]
[{"$nulls":8}," Total Cost =",null,{"$f":"SUM(K9:K54)","v":{"v":198175.0998906823,"d":"198,175"}}]
[{"$nulls":8},"Total of Manhole=",{"$f":"+Summary!K6","v":15},"No's"]
[{"$nulls":8},"Grand Total Cost=",null,{"$f":"+K55*J56","v":{"v":2972626.4983602343,"d":"2,972,626"}},null,null,{"$f":"SUM(N9:N56)","v":{"v":57786.61691556858,"d":"57,786.62"}},{"$f":"SUM(O9:O56)","v":{"v":2972626.4983602343,"d":"2,972,626"}}]

{"sheet":"M.H 5'dia (Type-V","index":5,"n_rows":59,"n_cols":15,"rows_kept":59,"merged":[[0,3,0,8],[6,0,7,0],[6,1,6,2],[6,3,6,8],[6,9,6,10],[7,1,7,2],[9,9,10,9],[9,10,10,10],[10,3,10,6],[12,9,13,9],[12,10,13,10],[13,3,13,6],[14,1,14,10],[15,9,16,9],[15,10,16,10],[16,3,16,6],[17,1,17,10],[18,9,19,9],[18,10,19,10],[19,3,19,6],[20,1,20,10],[21,9,24,9],[21,10,24,10],[24,3,24,6],[25,1,25,10],[26,9,31,9],[26,10,31,10],[31,3,31,6],[32,1,32,10],[33,9,38,9],[33,10,38,10],[38,3,38,6],[39,1,39,10],[40,9,44,9],[40,10,44,10],[44,3,44,6],[45,1,45,10],[46,9,47,9],[46,10,47,10],[47,3,47,6],[48,1,48,10],[49,9,50,9],[49,10,50,10],[50,3,50,6],[51,1,51,10],[52,9,54,9],[52,10,54,10],[54,3,54,6]]}
[{"$nulls":3},{"$f":"+'M.H 4''dia (Type-IV'!D1","v":"PROJECT NAME "},{"$nulls":5},"Manhole #"]
[{"$nulls":4},"CIVIL INFRASTRUCTURE WORKS",{"$nulls":4},"Road Name :"]
[{"$nulls":5},"RATE ANALYSIS",{"$nulls":3},"Sewer Line (Ø)",{"v":1,"d":"1.00 ft"}]
["Manhole Data;"]
[null,"Manhole Inner dia(Ø)",{"v":5,"d":"5.00 ft"},"Depth of Manhole,",{"v":13,"d":"13.00 ft"},"Wall Thick-I",{"v":0.75,"d":"0.75 ft"},"Wall Thick-II",{"$f":"13.5/12","v":{"v":1.125,"d":"1.125 ft"}},"MH Type-V","Assumed Quantity,",1]
[]
["Sr.#","Item of Works",null,"ABSTRACT OF QUANTIES",{"$nulls":5},"RATE ANALYSIS"]
[null,"Decription of items",null,"No. ","Length (ft)","width\n (ft)","Height (ft)","Unit ","Qty","Unit\nRate ","Amount ",null,null,"Total Qty","Total Rs."]
[1,"Excavation"]
[null,"Excavation ",null,{"$f":"+L5","v":1},{"$f":"+C5+4.25+0.75","v":{"v":10,"d":"10.00"}},{"$f":"+E10","v":{"v":10,"d":"10.00"}},{"$f":"+E5","v":{"v":13,"d":"13.00"}},null,{"$f":"PRODUCT(D10:G10)","v":{"v":1300,"d":"1300.00"}},{"v":12,"d":"12.00"},{"$f":"I11*J10","v":{"v":15600,"d":"15,600.00"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I10:I10)","v":{"v":1300,"d":"1300.00"}},null,null,{"$f":"+K10/$K$57","v":{"v":0.08889047943966641,"d":"9%"}},null,{"$f":"+I11*$J$58","v":{"v":40300,"d":"40,300.00"}},{"$f":"+I11*J10*$J$58","v":{"v":483600,"d":"483,600"}}]
[{"$f":"A9+1","v":2},"Dressing of bed"]
[null,"Dressing of bed",null,{"$f":"D10","v":1},{"$f":"+E10","v":{"v":10,"d":"10.00"}},{"$f":"((3.14*(($E$10-0.75)*($E$10-0.75))/4))","v":{"v":67.1665625,"d":"67.17"}},null,null,{"$f":"PRODUCT(D13:G13)","v":{"v":671.665625,"d":"671.67"}},{"v":4,"d":"4.00"},{"$f":"I14*J13","v":{"v":2686.6625,"d":"2,686.66"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Sft",{"$f":"SUM(I13:I13)","v":{"v":671.665625,"d":"671.67"}},null,null,{"$f":"+K13/$K$57","v":{"v":0.015308892161382868,"d":"2%"}},null,{"$f":"+I14*$J$58","v":{"v":20821.634374999998,"d":"20,821.63"}},{"$f":"+I14*J13*$J$58","v":{"v":83286.53749999999,"d":"83,287"}}]
[3,"Crurshed Stone Bedding"]
[null,"Crurshed Bedding 1\" Down",null,{"$f":"D10","v":1},"Area=",{"$f":"+F13","v":{"v":67.1665625,"d":"67.17"}},{"v":1,"d":"1.00"},null,{"$f":"PRODUCT(D16:G16)","v":{"v":67.1665625,"d":"67.17"}},{"v":140,"d":"140.00"},{"$f":"I17*J16","v":{"v":9403.31875,"d":"9,403.32"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I16:I16)","v":{"v":67.1665625,"d":"67.17"}},null,null,{"$f":"+K16/$K$57","v":{"v":0.053581122564840045,"d":"5%"}},null,{"$f":"+I17*$J$58","v":{"v":2082.1634375,"d":"2,082.16"}},{"$f":"+I17*J16*$J$58","v":{"v":291502.88125000003,"d":"291,503"}}]
[{"$f":"+A15+1","v":4},"PCC Concrete 1:4:8"]
[null,"Base Concrete 1:4:8",null,{"$f":"D13","v":1},"Area=",{"$f":"((3.14*(($E$10-1.75)*($E$10-1.75))/4))","v":{"v":53.4290625,"d":"53.43"}},0.75,null,{"$f":"PRODUCT(D19:G19)","v":{"v":40.071796875000004,"d":"40.07"}},{"v":280,"d":"280.00"},{"$f":"I20*J19","v":{"v":11220.103125000001,"d":"11,220.10"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I19:I19)","v":{"v":40.071796875000004,"d":"40.07"}},null,null,{"$f":"+K19/$K$57","v":{"v":0.06393335552203522,"d":"6%"}},null,{"$f":"+I20*$J$58","v":{"v":1242.225703125,"d":"1,242.23"}},{"$f":"+I20*J19*$J$58","v":{"v":347823.196875,"d":"347,823"}}]
[{"$f":"+A18+1","v":5},"Pacca Brick Work with 1:3 C/S Mortar"]
[null,"Wall (Circular) ",null,1,{"$f":"3.142*($C$5+$I$5)","v":{"v":19.24475,"d":"19.24"}},{"$f":"+I5","v":{"v":1.125,"d":"1.13"}},{"$f":"+$G$10-$G$16-$G$19-G23-G23","v":0.75},null,{"$f":"PRODUCT(D22:G22)","v":{"v":16.2377578125,"d":"16.24"}},{"v":420,"d":"420.00"},{"$f":"+I25*J22","v":{"v":48037.535280000004,"d":"48,037.54"}}]
[null,"Wall (Circular) ",null,{"$f":"+D19","v":1},{"$f":"3.142*($C$5+$G$5)","v":{"v":18.066499999999998,"d":"18.07"}},{"$f":"$G$5","v":0.75},{"$f":"8-G24","v":5.25},null,{"$f":"PRODUCT(D23:G23)","v":{"v":71.13684375,"d":"71.14"}}]
[null,"Wall (Dome)",null,{"$f":"D23","v":1},{"$f":"((3.142*($C$5+$G$5))+(3.142*(1.833+$G$5)))/2","v":{"v":13.091142999999999,"d":"13.09"}},{"$f":"$G$5","v":0.75},2.75,null,{"v":27.000482437499997,"d":"27.00"}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I22:I24)","v":{"v":114.375084,"d":"114.38"}},null,null,{"$f":"+K22/$K$57","v":{"v":0.27372304757301863,"d":"27%"}},null,{"$f":"+I25*$J$58","v":{"v":3545.6276040000002,"d":"3,545.63"}},{"$f":"+I25*J22*$J$58","v":{"v":1489163.5936800002,"d":"1,489,164"}}]
[{"$f":"+A21+1","v":6},"Plaster Work with 1:3 C/S Mortar"]
[null,"Wall (Circular) Outer Side",null,{"$f":"D24","v":1},{"$f":"3.142*(+$C$5+$I$5+$I$5)","v":{"v":22.7795,"d":"22.78"}},null,{"$f":"+G22","v":0.75},null,{"$f":"PRODUCT(D27:G27)","v":{"v":17.084625,"d":"17.08"}},{"v":48,"d":"48.00"},{"$f":"+I32*J27","v":{"v":12823.620552,"d":"12,823.62"}}]
[null,"Wall (Circular) Outer Side",null,{"$f":"+D27","v":1},{"$f":"3.142*(+$C$5+$G$5+$G$5)","v":{"v":20.423,"d":"20.42"}},null,{"$f":"+G23","v":5.25},null,{"$f":"PRODUCT(D28:G28)","v":{"v":107.22075,"d":"107.22"}}]
[null,"Wall (Dome) Outer Side",null,{"$f":"D27","v":1},{"$f":"((3.142*($C$5+$G$5+$G$5))+(3.142*(1.833+$G$5+$G$5)))/2","v":{"v":15.447643,"d":"15.45"}},null,{"$f":"+G24","v":2.75},null,{"$f":"PRODUCT(D29:G29)","v":{"v":42.48101825,"d":"42.48"}}]
[null,"Wall (Circular) inner Side",null,1,{"$f":"3.142*($C$5)","v":{"v":15.709999999999999,"d":"15.71"}},null,{"$f":"+G27+G28-G43","v":4.51},null,{"$f":"PRODUCT(D30:G30)","v":{"v":70.8521,"d":"70.85"}}]
[null,"Wall (Dome Inner Side",null,{"$f":"D30","v":1},{"$f":"((3.142*($C$5))+(3.142*(1.833)))/2","v":{"v":10.734642999999998,"d":"10.73"}},null,{"$f":"+G29","v":2.75},null,{"$f":"PRODUCT(D31:G31)","v":{"v":29.520268249999994,"d":"29.52"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Sft",{"$f":"SUM(I27:I31)","v":{"v":267.1587615,"d":"267.16"}},null,null,{"$f":"+K27/$K$57","v":{"v":0.0730703704499769,"d":"7%"}},null,{"$f":"+I32*$J$58","v":{"v":8281.9216065,"d":"8,281.92"}},{"$f":"+I32*J27*$J$58","v":{"v":397532.237112,"d":"397,532"}}]
[{"$f":"+A26+1","v":7},"Bituman Coating "]
[null,"Wall (Circular) Outer Side",null,{"$f":"D50","v":1},{"$f":"+E27","v":{"v":22.7795,"d":"22.78"}},null,{"$f":"+G27","v":0.75},null,{"$f":"PRODUCT(D34:G34)","v":{"v":17.084625,"d":"17.08"}},{"v":14,"d":"14.00"},{"$f":"I39*J34","v":{"v":2335.0095055,"d":"2,335.01"}}]
[null,"Wall (Circular) Outer Side",null,{"$f":"+D34","v":1},{"$f":"+E28","v":{"v":20.423,"d":"20.42"}},null,{"$f":"+G28","v":5.25},null,{"$f":"PRODUCT(D35:G35)","v":{"v":107.22075,"d":"107.22"}}]
[null,"Wall (Dome) Outer Side",null,{"$f":"D34","v":1},{"$f":"+E29","v":{"v":15.447643,"d":"15.45"}},null,{"$f":"+G29","v":2.75},null,{"$f":"PRODUCT(D36:G36)","v":{"v":42.48101825,"d":"42.48"}}]
[null,"Wall (Circular) inner Side",null,0,{"$f":"+E30","v":{"v":15.709999999999999,"d":"15.71"}},null,{"$f":"+G30","v":4.51},null,{"$f":"PRODUCT(D37:G37)","v":{"v":0,"d":"0.00"}}]
[null,"Wall (Dome Inner Side",null,{"$f":"+D37","v":0},{"$f":"+E31","v":{"v":10.734642999999998,"d":"10.73"}},null,{"$f":"+G31","v":2.75},null,{"$f":"PRODUCT(D38:G38)","v":{"v":0,"d":"0.00"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Sft",{"$f":"SUM(I34:I38)","v":{"v":166.78639325,"d":"166.79"}},null,null,{"$f":"+K34/$K$57","v":{"v":0.013305135541030346,"d":"1%"}},null,{"$f":"+I39*$J$58","v":{"v":5170.37819075,"d":"5,170.38"}},{"$f":"+I39*J34*$J$58","v":{"v":72385.2946705,"d":"72,385"}}]
[{"$f":"+A33+1","v":8},"Concrete 1:2:4"]
[null,"Top Cover Slab",null,{"$f":"D24","v":1},"Area=",{"$f":"((3.14*(3.83*3.83))/4)","v":{"v":11.5150865,"d":"11.52"}},0.75,null,{"$f":"PRODUCT(D41:G41)","v":{"v":8.636314875,"d":"8.64"}},{"v":450,"d":"450.00"},{"$f":"I45*J41","v":{"v":15952.77,"d":"15,952.77"}}]
[null,"D/d of Manhole Cover",null,-1,"Area=",{"$f":"((3.14*(1.83*1.83))/4)","v":{"v":2.6288865000000006,"d":"2.63"}},0.75,null,{"$f":"PRODUCT(D42:G42)","v":{"v":-1.9716648750000005,"d":"-1.97"}}]
[null,"Beching PCC",null,{"$f":"+D41","v":1},"Area=",{"$f":"((3.14*(C5*C5))/4)","v":{"v":19.625,"d":"19.63"}},{"$f":"0.33+($K$3+0.16)","v":1.49},null,{"$f":"PRODUCT(D43:G43)","v":{"v":29.24125,"d":"29.24"}}]
[null,"D/d of Pipe ",null,-1,"Area=",{"$f":"((3.14*(K3*K3))/4)/2","v":{"v":0.3925,"d":"0.39"}},{"$f":"($K$3+0.16)","v":1.16},null,{"$f":"PRODUCT(D44:G44)","v":{"v":-0.4553,"d":"-0.46"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I41:I44)","v":{"v":35.4506,"d":"35.45"}},null,null,{"$f":"+K41/$K$57","v":{"v":0.09090060087761072,"d":"9%"}},null,{"$f":"+I45*$J$58","v":{"v":1098.9686000000002,"d":"1,098.97"}},{"$f":"+I45*J41*$J$58","v":{"v":494535.87,"d":"494,536"}}]
[{"$f":"+A40+1","v":9},"Manhole Cover 22\" dia"]
[null," 22\" dia MH Cover",null,1,{"$nulls":4},{"$f":"PRODUCT(D47:G47)","v":{"v":1,"d":"1.00"}},{"v":17235,"d":"17235.00"},{"$f":"I48*J47","v":{"v":17235,"d":"17,235.00"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"No",{"$f":"SUM(I47:I47)","v":{"v":1,"d":"1.00"}},null,null,{"$f":"+K47/$K$57","v":{"v":0.09820688545786221,"d":"10%"}},null,{"$f":"+I48*$J$58","v":{"v":31,"d":"31.00"}},{"$f":"+I48*J47*$J$58","v":{"v":534285,"d":"534,285"}}]
[{"$f":"+A46+1","v":10},"Malleable Iron Step"]
[null,"Iron Step @1' C/C",null,1,null,"Brick Work Height",{"$f":"+(G23+G24+G22)-1","v":7.75},null,{"$f":"ROUND(G50,0)","v":{"v":8,"d":"8.00"}},{"v":1550,"d":"1550.00"},{"$f":"I51*J50","v":{"v":12400,"d":"12,400.00"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"No",{"$f":"SUM(I50:I50)","v":{"v":8,"d":"8.00"}},null,null,{"$f":"+K50/$K$57","v":{"v":0.07065653493922201,"d":"7%"}},null,{"$f":"+I51*$J$58","v":{"v":248,"d":"248.00"}},{"$f":"+I51*J50*$J$58","v":{"v":384400,"d":"384,400"}}]
[{"$f":"+A49+1","v":11},"Backfill"]
[null,"Backfill (Total Excavation)",null,{"$f":"+D10","v":1},null,null,{"$f":"I11","v":{"v":1300,"d":"1300.00"}},null,{"$f":"PRODUCT(D53:G53)","v":{"v":1300,"d":"1300.00"}},{"v":32,"d":"32.00"},{"$f":"I55*J53","v":{"v":27802.84,"d":"27,802.84"}}]
[null,"D/d of Manhole",null,-1,"Area",{"$f":"3.14*(($C$5+$G$5+$G$5)*($C$5+$G$5+$G$5))/4","v":{"v":33.16625,"d":"33.17"}},{"$f":"+G10","v":{"v":13,"d":"13.00"}},null,{"$f":"PRODUCT(D54:G54)","v":{"v":-431.16125,"d":"-431.16"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I53:I54)","v":{"v":868.83875,"d":"868.84"}},null,null,{"$f":"+K53/$K$57","v":{"v":0.1584235754733548,"d":"16%"}},null,{"$f":"+I55*$J$58","v":{"v":26934.00125,"d":"26,934.00"}},{"$f":"+I55*J53*$J$58","v":{"v":861888.04,"d":"861,888"}}]
[{"$nulls":11},{"$f":"SUM(L9:L55)","v":{"v":1.0000000000000002,"d":"100%"}}]
[{"$nulls":8}," Total Cost =",null,{"$f":"SUM(K9:K56)","v":{"v":175496.85971249998,"d":"175,497"}}]
[{"$nulls":8},"Total of Manhole=",{"$f":"+Summary!M6","v":31},"No's"]
[{"$nulls":8},"Grand Total Cost=",null,{"$f":"+K57*J58","v":{"v":5440402.651087499,"d":"5,440,403"}},null,null,{"$f":"SUM(N9:N58)","v":{"v":109755.92076687497,"d":"109,755.92"}},{"$f":"SUM(O9:O58)","v":{"v":5440402.651087501,"d":"5,440,403"}}]

{"sheet":"M.H 5'dia (Type-VI","index":6,"n_rows":59,"n_cols":15,"rows_kept":59,"merged":[[0,3,0,8],[6,0,7,0],[6,1,6,2],[6,3,6,8],[6,9,6,10],[7,1,7,2],[9,9,10,9],[9,10,10,10],[10,3,10,6],[12,9,13,9],[12,10,13,10],[13,3,13,6],[14,1,14,10],[15,9,16,9],[15,10,16,10],[16,3,16,6],[17,1,17,10],[18,9,19,9],[18,10,19,10],[19,3,19,6],[20,1,20,10],[21,9,24,9],[21,10,24,10],[24,3,24,6],[25,1,25,10],[26,9,31,9],[26,10,31,10],[31,3,31,6],[32,1,32,10],[33,9,38,9],[33,10,38,10],[38,3,38,6],[39,1,39,10],[40,9,44,9],[40,10,44,10],[44,3,44,6],[45,1,45,10],[46,9,47,9],[46,10,47,10],[47,3,47,6],[48,1,48,10],[49,9,50,9],[49,10,50,10],[50,3,50,6],[51,1,51,10],[52,9,54,9],[52,10,54,10],[54,3,54,6]]}
[{"$nulls":3},{"$f":"+'M.H 5''dia (Type-V'!D1","v":"PROJECT NAME "},{"$nulls":5},"Manhole #"]
[{"$nulls":4},"CIVIL INFRASTRUCTURE WORKS",{"$nulls":4},"Road Name :"]
[{"$nulls":5},"RATE ANALYSIS",{"$nulls":3},"Sewer Line (Ø)",{"v":1.1666666666666667,"d":"1.17 ft"}]
["Manhole Data;"]
[null,"Manhole Inner dia(Ø)",{"v":5,"d":"5.00 ft"},"Depth of Manhole,",{"v":17,"d":"17.00 ft"},"Wall Thick-I",{"v":0.75,"d":"0.75 ft"},"Wall Thick-II",{"$f":"13.5/12","v":{"v":1.125,"d":"1.125 ft"}},"MH Type-VI","Assumed Quantity,",1]
[]
["Sr.#","Item of Works",null,"ABSTRACT OF QUANTIES",{"$nulls":5},"RATE ANALYSIS"]
[null,"Decription of items",null,"No. ","Length (ft)","width\n (ft)","Height (ft)","Unit ","Qty","Unit\nRate ","Amount ",null,null,"Total Qty","Total Rs."]
[1,"Excavation"]
[null,"Excavation ",null,{"$f":"+L5","v":1},{"$f":"+C5+4.25+0.75","v":{"v":10,"d":"10.00"}},{"$f":"+E10","v":{"v":10,"d":"10.00"}},{"$f":"+E5","v":{"v":17,"d":"17.00"}},null,{"$f":"PRODUCT(D10:G10)","v":{"v":1700,"d":"1700.00"}},{"v":12,"d":"12.00"},{"$f":"I11*J10","v":{"v":20400,"d":"20,400.00"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I10:I10)","v":{"v":1700,"d":"1700.00"}},null,null,{"$f":"+K10/$K$57","v":{"v":0.0845343796163766,"d":"8%"}},null,{"$f":"+I11*$J$58","v":{"v":39100,"d":"39,100.00"}},{"$f":"+I11*J10*$J$58","v":{"v":469200,"d":"469,200"}}]
[{"$f":"A9+1","v":2},"Dressing of bed"]
[null,"Dressing of bed",null,{"$f":"D10","v":1},{"$f":"+E10","v":{"v":10,"d":"10.00"}},{"$f":"((3.14*(($E$10-0.75)*($E$10-0.75))/4))","v":{"v":67.1665625,"d":"67.17"}},null,null,{"$f":"PRODUCT(D13:G13)","v":{"v":671.665625,"d":"671.67"}},{"v":4,"d":"4.00"},{"$f":"I14*J13","v":{"v":2686.6625,"d":"2,686.66"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Sft",{"$f":"SUM(I13:I13)","v":{"v":671.665625,"d":"671.67"}},null,null,{"$f":"+K13/$K$57","v":{"v":0.011133105278239382,"d":"1%"}},null,{"$f":"+I14*$J$58","v":{"v":15448.309374999999,"d":"15,448.31"}},{"$f":"+I14*J13*$J$58","v":{"v":61793.237499999996,"d":"61,793"}}]
[3,"Crurshed Stone Bedding"]
[null,"Crurshed Bedding 1\" Down",null,{"$f":"D10","v":1},"Area=",{"$f":"+F13","v":{"v":67.1665625,"d":"67.17"}},{"v":1,"d":"1.00"},null,{"$f":"PRODUCT(D16:G16)","v":{"v":67.1665625,"d":"67.17"}},{"v":140,"d":"140.00"},{"$f":"I17*J16","v":{"v":9403.31875,"d":"9,403.32"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I16:I16)","v":{"v":67.1665625,"d":"67.17"}},null,null,{"$f":"+K16/$K$57","v":{"v":0.03896586847383784,"d":"4%"}},null,{"$f":"+I17*$J$58","v":{"v":1544.8309375,"d":"1,544.83"}},{"$f":"+I17*J16*$J$58","v":{"v":216276.33125000002,"d":"216,276"}}]
[{"$f":"+A15+1","v":4},"PCC Concrete 1:4:8"]
[null,"Base Concrete 1:4:8",null,{"$f":"D13","v":1},"Area=",{"$f":"((3.14*(($E$10-1.75)*($E$10-1.75))/4))","v":{"v":53.4290625,"d":"53.43"}},0.75,null,{"$f":"PRODUCT(D19:G19)","v":{"v":40.071796875000004,"d":"40.07"}},{"v":280,"d":"280.00"},{"$f":"I20*J19","v":{"v":11220.103125000001,"d":"11,220.10"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I19:I19)","v":{"v":40.071796875000004,"d":"40.07"}},null,null,{"$f":"+K19/$K$57","v":{"v":0.046494336122727624,"d":"5%"}},null,{"$f":"+I20*$J$58","v":{"v":921.6513281250001,"d":"921.65"}},{"$f":"+I20*J19*$J$58","v":{"v":258062.37187500004,"d":"258,062"}}]
[{"$f":"+A18+1","v":5},"Pacca Brick Work with 1:3 C/S Mortar"]
[null,"Wall (Circular) ",null,1,{"$f":"3.142*($C$5+$I$5)","v":{"v":19.24475,"d":"19.24"}},{"$f":"+I5","v":{"v":1.125,"d":"1.13"}},{"$f":"+$G$10-$G$16-$G$19-G23-G23","v":4.75},null,{"$f":"PRODUCT(D22:G22)","v":{"v":102.83913281250001,"d":"102.84"}},{"v":420,"d":"420.00"},{"$f":"+I25*J22","v":{"v":84410.11278000001,"d":"84,410.11"}}]
[null,"Wall (Circular) ",null,{"$f":"+D19","v":1},{"$f":"3.142*($C$5+$G$5)","v":{"v":18.066499999999998,"d":"18.07"}},{"$f":"$G$5","v":0.75},{"$f":"8-G24","v":5.25},null,{"$f":"PRODUCT(D23:G23)","v":{"v":71.13684375,"d":"71.14"}}]
[null,"Wall (Dome)",null,{"$f":"D23","v":1},{"$f":"((3.142*($C$5+$G$5))+(3.142*(1.833+$G$5)))/2","v":{"v":13.091142999999999,"d":"13.09"}},{"$f":"$G$5","v":0.75},2.75,null,{"v":27.000482437499997,"d":"27.00"}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I22:I24)","v":{"v":200.97645900000003,"d":"200.98"}},null,null,{"$f":"+K22/$K$57","v":{"v":0.34978218221596485,"d":"35%"}},null,{"$f":"+I25*$J$58","v":{"v":4622.458557000001,"d":"4,622.46"}},{"$f":"+I25*J22*$J$58","v":{"v":1941432.5939400003,"d":"1,941,433"}}]
[{"$f":"+A21+1","v":6},"Plaster Work with 1:3 C/S Mortar"]
[null,"Wall (Circular) Outer Side",null,{"$f":"D24","v":1},{"$f":"3.142*(+$C$5+$I$5+$I$5)","v":{"v":22.7795,"d":"22.78"}},null,{"$f":"+G22","v":4.75},null,{"$f":"PRODUCT(D27:G27)","v":{"v":108.202625,"d":"108.20"}},{"v":48,"d":"48.00"},{"$f":"+I32*J27","v":{"v":20087.924552,"d":"20,087.92"}}]
[null,"Wall (Circular) Outer Side",null,{"$f":"+D27","v":1},{"$f":"3.142*(+$C$5+$G$5+$G$5)","v":{"v":20.423,"d":"20.42"}},null,{"$f":"+G23","v":5.25},null,{"$f":"PRODUCT(D28:G28)","v":{"v":107.22075,"d":"107.22"}}]
[null,"Wall (Dome) Outer Side",null,{"$f":"D27","v":1},{"$f":"((3.142*($C$5+$G$5+$G$5))+(3.142*(1.833+$G$5+$G$5)))/2","v":{"v":15.447643,"d":"15.45"}},null,{"$f":"+G24","v":2.75},null,{"$f":"PRODUCT(D29:G29)","v":{"v":42.48101825,"d":"42.48"}}]
[null,"Wall (Circular) inner Side",null,1,{"$f":"3.142*($C$5)","v":{"v":15.709999999999999,"d":"15.71"}},null,{"$f":"+G27+G28-G43","v":{"v":8.343333333333334,"d":"8.34"}},null,{"$f":"PRODUCT(D30:G30)","v":{"v":131.07376666666667,"d":"131.07"}}]
[null,"Wall (Dome Inner Side",null,{"$f":"D30","v":1},{"$f":"((3.142*($C$5))+(3.142*(1.833)))/2","v":{"v":10.734642999999998,"d":"10.73"}},null,{"$f":"+G29","v":2.75},null,{"$f":"PRODUCT(D31:G31)","v":{"v":29.520268249999994,"d":"29.52"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Sft",{"$f":"SUM(I27:I31)","v":{"v":418.49842816666666,"d":"418.50"}},null,null,{"$f":"+K27/$K$57","v":{"v":0.08324118822470097,"d":"8%"}},null,{"$f":"+I32*$J$58","v":{"v":9625.463847833333,"d":"9,625.46"}},{"$f":"+I32*J27*$J$58","v":{"v":462022.264696,"d":"462,022"}}]
[{"$f":"+A26+1","v":7},"Bituman Coating "]
[null,"Wall (Circular) Outer Side",null,{"$f":"D50","v":1},{"$f":"+E27","v":{"v":22.7795,"d":"22.78"}},null,{"$f":"+G27","v":4.75},null,{"$f":"PRODUCT(D34:G34)","v":{"v":108.202625,"d":"108.20"}},{"v":14,"d":"14.00"},{"$f":"I39*J34","v":{"v":3610.6615055,"d":"3,610.66"}}]
[null,"Wall (Circular) Outer Side",null,{"$f":"+D34","v":1},{"$f":"+E28","v":{"v":20.423,"d":"20.42"}},null,{"$f":"+G28","v":5.25},null,{"$f":"PRODUCT(D35:G35)","v":{"v":107.22075,"d":"107.22"}}]
[null,"Wall (Dome) Outer Side",null,{"$f":"D34","v":1},{"$f":"+E29","v":{"v":15.447643,"d":"15.45"}},null,{"$f":"+G29","v":2.75},null,{"$f":"PRODUCT(D36:G36)","v":{"v":42.48101825,"d":"42.48"}}]
[null,"Wall (Circular) inner Side",null,0,{"$f":"+E30","v":{"v":15.709999999999999,"d":"15.71"}},null,{"$f":"+G30","v":{"v":8.343333333333334,"d":"8.34"}},null,{"$f":"PRODUCT(D37:G37)","v":{"v":0,"d":"0.00"}}]
[null,"Wall (Dome Inner Side",null,{"$f":"+D37","v":0},{"$f":"+E31","v":{"v":10.734642999999998,"d":"10.73"}},null,{"$f":"+G31","v":2.75},null,{"$f":"PRODUCT(D38:G38)","v":{"v":0,"d":"0.00"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Sft",{"$f":"SUM(I34:I38)","v":{"v":257.90439325,"d":"257.90"}},null,null,{"$f":"+K34/$K$57","v":{"v":0.01496201129275367,"d":"1%"}},null,{"$f":"+I39*$J$58","v":{"v":5931.80104475,"d":"5,931.80"}},{"$f":"+I39*J34*$J$58","v":{"v":83045.2146265,"d":"83,045"}}]
[{"$f":"+A33+1","v":8},"Concrete 1:2:4"]
[null,"Top Cover Slab",null,{"$f":"D24","v":1},"Area=",{"$f":"((3.14*(3.83*3.83))/4)","v":{"v":11.5150865,"d":"11.52"}},0.75,null,{"$f":"PRODUCT(D41:G41)","v":{"v":8.636314875,"d":"8.64"}},{"v":450,"d":"450.00"},{"$f":"I45*J41","v":{"v":17310.59104166667,"d":"17,310.59"}}]
[null,"D/d of Manhole Cover",null,-1,"Area=",{"$f":"((3.14*(1.83*1.83))/4)","v":{"v":2.6288865000000006,"d":"2.63"}},0.75,null,{"$f":"PRODUCT(D42:G42)","v":{"v":-1.9716648750000005,"d":"-1.97"}}]
[null,"Beching PCC",null,{"$f":"+D41","v":1},"Area=",{"$f":"((3.14*(C5*C5))/4)","v":{"v":19.625,"d":"19.63"}},{"$f":"0.33+($K$3+0.16)","v":{"v":1.6566666666666667,"d":"1.66"}},null,{"$f":"PRODUCT(D43:G43)","v":{"v":32.51208333333334,"d":"32.51"}}]
[null,"D/d of Pipe ",null,-1,"Area=",{"$f":"((3.14*(K3*K3))/4)/2","v":{"v":0.5342361111111112,"d":"0.53"}},{"$f":"($K$3+0.16)","v":{"v":1.3266666666666667,"d":"1.33"}},null,{"$f":"PRODUCT(D44:G44)","v":{"v":-0.7087532407407409,"d":"-0.71"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I41:I44)","v":{"v":38.4679800925926,"d":"38.47"}},null,null,{"$f":"+K41/$K$57","v":{"v":0.07173235659314207,"d":"7%"}},null,{"$f":"+I45*$J$58","v":{"v":884.7635421296297,"d":"884.76"}},{"$f":"+I45*J41*$J$58","v":{"v":398143.5939583334,"d":"398,144"}}]
[{"$f":"+A40+1","v":9},"Manhole Cover 22\" dia"]
[null," 22\" dia MH Cover",null,1,{"$nulls":4},{"$f":"PRODUCT(D47:G47)","v":{"v":1,"d":"1.00"}},{"v":17235,"d":"17235.00"},{"$f":"I48*J47","v":{"v":17235,"d":"17,235.00"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"No",{"$f":"SUM(I47:I47)","v":{"v":1,"d":"1.00"}},null,null,{"$f":"+K47/$K$57","v":{"v":0.07141911924942405,"d":"7%"}},null,{"$f":"+I48*$J$58","v":{"v":23,"d":"23.00"}},{"$f":"+I48*J47*$J$58","v":{"v":396405,"d":"396,405"}}]
[{"$f":"+A46+1","v":10},"Malleable Iron Step"]
[null,"Iron Step @1' C/C",null,1,null,"Brick Work Height",{"$f":"+(+G22+G23+G24)-1","v":11.75},null,{"$f":"ROUND(G50,0)","v":{"v":12,"d":"12.00"}},{"v":1550,"d":"1550.00"},{"$f":"I51*J50","v":{"v":18600,"d":"18,600.00"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"No",{"$f":"SUM(I50:I50)","v":{"v":12,"d":"12.00"}},null,null,{"$f":"+K50/$K$57","v":{"v":0.07707546376787278,"d":"8%"}},null,{"$f":"+I51*$J$58","v":{"v":276,"d":"276.00"}},{"$f":"+I51*J50*$J$58","v":{"v":427800,"d":"427,800"}}]
[{"$f":"+A49+1","v":11},"Backfill"]
[null,"Backfill (Total Excavation)",null,{"$f":"+D10","v":1},null,null,{"$f":"I11","v":{"v":1700,"d":"1700.00"}},null,{"$f":"PRODUCT(D53:G53)","v":{"v":1700,"d":"1700.00"}},{"v":32,"d":"32.00"},{"$f":"I55*J53","v":{"v":36357.56,"d":"36,357.56"}}]
[null,"D/d of Manhole",null,-1,"Area",{"$f":"3.14*(($C$5+$G$5+$G$5)*($C$5+$G$5+$G$5))/4","v":{"v":33.16625,"d":"33.17"}},{"$f":"+G10","v":{"v":17,"d":"17.00"}},null,{"$f":"PRODUCT(D54:G54)","v":{"v":-563.82625,"d":"-563.83"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I53:I54)","v":{"v":1136.17375,"d":"1136.17"}},null,null,{"$f":"+K53/$K$57","v":{"v":0.15065998916496023,"d":"15%"}},null,{"$f":"+I55*$J$58","v":{"v":26131.996249999997,"d":"26,132.00"}},{"$f":"+I55*J53*$J$58","v":{"v":836223.8799999999,"d":"836,224"}}]
[{"$nulls":11},{"$f":"SUM(L10:L55)","v":{"v":1,"d":"100%"}}]
[{"$nulls":8}," Total Cost =",null,{"$f":"SUM(K9:K56)","v":{"v":241321.93425416667,"d":"241,322"}}]
[{"$nulls":8},"Total of Manhole=",{"$f":"+Summary!O6","v":23},"No's"]
[{"$nulls":8},"Grand Total Cost=",null,{"$f":"+K57*J58","v":{"v":5550404.487845833,"d":"5,550,404"}},null,null,{"$f":"SUM(N9:N58)","v":{"v":104510.27488233795,"d":"104,510.27"}},{"$f":"SUM(O9:O58)","v":{"v":5550404.487845833,"d":"5,550,404"}}]

{"sheet":"M.H 6.5'dia (Type-VII","index":7,"n_rows":59,"n_cols":15,"rows_kept":59,"merged":[[0,3,0,8],[6,0,7,0],[6,1,6,2],[6,3,6,8],[6,9,6,10],[7,1,7,2],[9,9,10,9],[9,10,10,10],[10,3,10,6],[12,9,13,9],[12,10,13,10],[13,3,13,6],[14,1,14,10],[15,9,16,9],[15,10,16,10],[16,3,16,6],[17,1,17,10],[18,9,19,9],[18,10,19,10],[19,3,19,6],[20,1,20,10],[21,9,24,9],[21,10,24,10],[24,3,24,6],[25,1,25,10],[26,9,31,9],[26,10,31,10],[31,3,31,6],[32,1,32,10],[33,9,38,9],[33,10,38,10],[38,3,38,6],[39,1,39,10],[40,9,44,9],[40,10,44,10],[44,3,44,6],[45,1,45,10],[46,9,47,9],[46,10,47,10],[47,3,47,6],[48,1,48,10],[49,9,50,9],[49,10,50,10],[50,3,50,6],[51,1,51,10],[52,9,54,9],[52,10,54,10],[54,3,54,6]]}
[{"$nulls":3},{"$f":"+'M.H 5''dia (Type-VI'!D1","v":"PROJECT NAME "},{"$nulls":5},"Manhole #"]
[{"$nulls":4},"CIVIL INFRASTRUCTURE WORKS",{"$nulls":4},"Road Name :"]
[{"$nulls":5},"RATE ANALYSIS",{"$nulls":3},"Sewer Line (Ø)",{"v":1.3333333333333333,"d":"1.33 ft"}]
["Manhole Data;"]
[null,"Manhole Inner dia(Ø)",{"v":6.5,"d":"6.50 ft"},"Depth of Manhole,",{"v":18,"d":"18.00 ft"},"Wall Thick-I",{"v":0.75,"d":"0.75 ft"},"Wall Thick-II",{"$f":"13.5/12","v":{"v":1.125,"d":"1.125 ft"}},"MH Type-VII","Assumed Quantity,",1]
[]
["Sr.#","Item of Works",null,"ABSTRACT OF QUANTIES",{"$nulls":5},"RATE ANALYSIS"]
[null,"Decription of items",null,"No. ","Length (ft)","width\n (ft)","Height (ft)","Unit ","Qty","Unit\nRate ","Amount ",null,null,"Total Qty","Total Rs."]
[1,"Excavation"]
[null,"Excavation ",null,{"$f":"+L5","v":1},{"$f":"+C5+4.25+0.75","v":{"v":11.5,"d":"11.50"}},{"$f":"+E10","v":{"v":11.5,"d":"11.50"}},{"$f":"+E5","v":{"v":18,"d":"18.00"}},null,{"$f":"PRODUCT(D10:G10)","v":{"v":2380.5,"d":"2380.50"}},{"v":12,"d":"12.00"},{"$f":"I11*J10","v":{"v":28566,"d":"28,566.00"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I10:I10)","v":{"v":2380.5,"d":"2380.50"}},null,null,{"$f":"+K10/$K$57","v":{"v":0.08831606169117082,"d":"9%"}},null,{"$f":"+I11*$J$58","v":{"v":4761,"d":"4,761.00"}},{"$f":"+I11*J10*$J$58","v":{"v":57132,"d":"57,132"}}]
[{"$f":"A9+1","v":2},"Dressing of bed"]
[null,"Dressing of bed",null,{"$f":"D10","v":1},{"$f":"+E10","v":{"v":11.5,"d":"11.50"}},{"$f":"((3.14*(($E$10-0.75)*($E$10-0.75))/4))","v":{"v":90.71656250000001,"d":"90.72"}},null,null,{"$f":"PRODUCT(D13:G13)","v":{"v":1043.2404687500002,"d":"1043.24"}},{"v":4,"d":"4.00"},{"$f":"I14*J13","v":{"v":4172.961875000001,"d":"4,172.96"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Sft",{"$f":"SUM(I13:I13)","v":{"v":1043.2404687500002,"d":"1043.24"}},null,null,{"$f":"+K13/$K$57","v":{"v":0.012901335797360634,"d":"1%"}},null,{"$f":"+I14*$J$58","v":{"v":2086.4809375000004,"d":"2,086.48"}},{"$f":"+I14*J13*$J$58","v":{"v":8345.923750000002,"d":"8,346"}}]
[3,"Crurshed Stone Bedding"]
[null,"Crurshed Bedding 1\" Down",null,{"$f":"D10","v":1},"Area=",{"$f":"+F13","v":{"v":90.71656250000001,"d":"90.72"}},{"v":1,"d":"1.00"},null,{"$f":"PRODUCT(D16:G16)","v":{"v":90.71656250000001,"d":"90.72"}},{"v":140,"d":"140.00"},{"$f":"I17*J16","v":{"v":12700.318750000002,"d":"12,700.32"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I16:I16)","v":{"v":90.71656250000001,"d":"90.72"}},null,null,{"$f":"+K16/$K$57","v":{"v":0.03926493503544541,"d":"4%"}},null,{"$f":"+I17*$J$58","v":{"v":181.43312500000002,"d":"181.43"}},{"$f":"+I17*J16*$J$58","v":{"v":25400.637500000004,"d":"25,401"}}]
[{"$f":"+A15+1","v":4},"PCC Concrete 1:4:8"]
[null,"Base Concrete 1:4:8",null,{"$f":"D13","v":1},"Area=",{"$f":"((3.14*(($E$10-1.75)*($E$10-1.75))/4))","v":{"v":74.62406250000001,"d":"74.62"}},0.75,null,{"$f":"PRODUCT(D19:G19)","v":{"v":55.968046875000006,"d":"55.97"}},{"v":280,"d":"280.00"},{"$f":"I20*J19","v":{"v":15671.053125000002,"d":"15,671.05"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I19:I19)","v":{"v":55.968046875000006,"d":"55.97"}},null,null,{"$f":"+K19/$K$57","v":{"v":0.04844940469625132,"d":"5%"}},null,{"$f":"+I20*$J$58","v":{"v":111.93609375000001,"d":"111.94"}},{"$f":"+I20*J19*$J$58","v":{"v":31342.106250000004,"d":"31,342"}}]
[{"$f":"+A18+1","v":5},"Pacca Brick Work with 1:3 C/S Mortar"]
[null,"Wall (Circular) ",null,1,{"$f":"3.142*($C$5+$I$5)","v":{"v":23.95775,"d":"23.96"}},{"$f":"+I5","v":{"v":1.125,"d":"1.13"}},{"$f":"+$G$10-$G$16-$G$19-G23-G23","v":5.75},null,{"$f":"PRODUCT(D22:G22)","v":{"v":154.9766953125,"d":"154.98"}},{"v":420,"d":"420.00"},{"$f":"+I25*J22","v":{"v":116143.330905,"d":"116,143.33"}}]
[null,"Wall (Circular) ",null,{"$f":"+D19","v":1},{"$f":"3.142*($C$5+$G$5)","v":{"v":22.7795,"d":"22.78"}},{"$f":"$G$5","v":0.75},{"$f":"8-G24","v":5.25},null,{"$f":"PRODUCT(D23:G23)","v":{"v":89.69428124999999,"d":"89.69"}}]
[null,"Wall (Dome)",null,{"$f":"D23","v":1},{"$f":"((3.142*($C$5+$G$5))+(3.142*(1.833+$G$5)))/2","v":{"v":15.447643,"d":"15.45"}},{"$f":"$G$5","v":0.75},2.75,null,{"v":31.860763687499997,"d":"31.86"}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I22:I24)","v":{"v":276.53174025,"d":"276.53"}},null,null,{"$f":"+K22/$K$57","v":{"v":0.35907447935391884,"d":"36%"}},null,{"$f":"+I25*$J$58","v":{"v":553.0634805,"d":"553.06"}},{"$f":"+I25*J22*$J$58","v":{"v":232286.66181,"d":"232,287"}}]
[{"$f":"+A21+1","v":6},"Plaster Work with 1:3 C/S Mortar"]
[null,"Wall (Circular) Outer Side",null,{"$f":"D24","v":1},{"$f":"3.142*(+$C$5+$I$5+$I$5)","v":{"v":27.4925,"d":"27.49"}},null,{"$f":"+G22","v":5.75},null,{"$f":"PRODUCT(D27:G27)","v":{"v":158.081875,"d":"158.08"}},{"v":48,"d":"48.00"},{"$f":"+I32*J27","v":{"v":26996.302791999995,"d":"26,996.30"}}]
[null,"Wall (Circular) Outer Side",null,{"$f":"+D27","v":1},{"$f":"3.142*(+$C$5+$G$5+$G$5)","v":{"v":25.136,"d":"25.14"}},null,{"$f":"+G23","v":5.25},null,{"$f":"PRODUCT(D28:G28)","v":{"v":131.964,"d":"131.96"}}]
[null,"Wall (Dome) Outer Side",null,{"$f":"D27","v":1},{"$f":"((3.142*($C$5+$G$5+$G$5))+(3.142*(1.833+$G$5+$G$5)))/2","v":{"v":17.804143,"d":"17.80"}},null,{"$f":"+G24","v":2.75},null,{"$f":"PRODUCT(D29:G29)","v":{"v":48.96139325,"d":"48.96"}}]
[null,"Wall (Circular) inner Side",null,1,{"$f":"3.142*($C$5)","v":{"v":20.423,"d":"20.42"}},null,{"$f":"+G27+G28-G43","v":{"v":9.176666666666666,"d":"9.18"}},null,{"$f":"PRODUCT(D30:G30)","v":{"v":187.4150633333333,"d":"187.42"}}]
[null,"Wall (Dome Inner Side",null,{"$f":"D30","v":1},{"$f":"((3.142*($C$5))+(3.142*(1.833)))/2","v":{"v":13.091142999999999,"d":"13.09"}},null,{"$f":"+G29","v":2.75},null,{"$f":"PRODUCT(D31:G31)","v":{"v":36.000643249999996,"d":"36.00"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Sft",{"$f":"SUM(I27:I31)","v":{"v":562.4229748333332,"d":"562.42"}},null,null,{"$f":"+K27/$K$57","v":{"v":0.08346310798893083,"d":"8%"}},null,{"$f":"+I32*$J$58","v":{"v":1124.8459496666665,"d":"1,124.85"}},{"$f":"+I32*J27*$J$58","v":{"v":53992.60558399999,"d":"53,993"}}]
[{"$f":"+A26+1","v":7},"Bituman Coating "]
[null,"Wall (Circular) Outer Side",null,{"$f":"D50","v":1},{"$f":"+E27","v":{"v":27.4925,"d":"27.49"}},null,{"$f":"+G27","v":5.75},null,{"$f":"PRODUCT(D34:G34)","v":{"v":158.081875,"d":"158.08"}},{"v":14,"d":"14.00"},{"$f":"I39*J34","v":{"v":4746.101755500001,"d":"4,746.10"}}]
[null,"Wall (Circular) Outer Side",null,{"$f":"+D34","v":1},{"$f":"+E28","v":{"v":25.136,"d":"25.14"}},null,{"$f":"+G28","v":5.25},null,{"$f":"PRODUCT(D35:G35)","v":{"v":131.964,"d":"131.96"}}]
[null,"Wall (Dome) Outer Side",null,{"$f":"D34","v":1},{"$f":"+E29","v":{"v":17.804143,"d":"17.80"}},null,{"$f":"+G29","v":2.75},null,{"$f":"PRODUCT(D36:G36)","v":{"v":48.96139325,"d":"48.96"}}]
[null,"Wall (Circular) inner Side",null,0,{"$f":"+E30","v":{"v":20.423,"d":"20.42"}},null,{"$f":"+G30","v":{"v":9.176666666666666,"d":"9.18"}},null,{"$f":"PRODUCT(D37:G37)","v":{"v":0,"d":"0.00"}}]
[null,"Wall (Dome Inner Side",null,{"$f":"+D37","v":0},{"$f":"+E31","v":{"v":13.091142999999999,"d":"13.09"}},null,{"$f":"+G31","v":2.75},null,{"$f":"PRODUCT(D38:G38)","v":{"v":0,"d":"0.00"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Sft",{"$f":"SUM(I34:I38)","v":{"v":339.00726825000004,"d":"339.01"}},null,null,{"$f":"+K34/$K$57","v":{"v":0.014673283463954077,"d":"1%"}},null,{"$f":"+I39*$J$58","v":{"v":678.0145365000001,"d":"678.01"}},{"$f":"+I39*J34*$J$58","v":{"v":9492.203511000002,"d":"9,492"}}]
[{"$f":"+A33+1","v":8},"Concrete 1:2:4"]
[null,"Top Cover Slab",null,{"$f":"D24","v":1},"Area=",{"$f":"((3.14*(3.83*3.83))/4)","v":{"v":11.5150865,"d":"11.52"}},0.75,null,{"$f":"PRODUCT(D41:G41)","v":{"v":8.636314875,"d":"8.64"}},{"v":450,"d":"450.00"},{"$f":"I45*J41","v":{"v":29743.093958333327,"d":"29,743.09"}}]
[null,"D/d of Manhole Cover",null,-1,"Area=",{"$f":"((3.14*(1.83*1.83))/4)","v":{"v":2.6288865000000006,"d":"2.63"}},0.75,null,{"$f":"PRODUCT(D42:G42)","v":{"v":-1.9716648750000005,"d":"-1.97"}}]
[null,"Beching PCC",null,{"$f":"+D41","v":1},"Area=",{"$f":"((3.14*(C5*C5))/4)","v":{"v":33.16625,"d":"33.17"}},{"$f":"0.33+($K$3+0.16)","v":{"v":1.8233333333333333,"d":"1.82"}},null,{"$f":"PRODUCT(D43:G43)","v":{"v":60.47312916666666,"d":"60.47"}}]
[null,"D/d of Pipe ",null,-1,"Area=",{"$f":"((3.14*(K3*K3))/4)/2","v":{"v":0.6977777777777777,"d":"0.70"}},{"$f":"($K$3+0.16)","v":{"v":1.4933333333333332,"d":"1.49"}},null,{"$f":"PRODUCT(D44:G44)","v":{"v":-1.0420148148148147,"d":"-1.04"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I41:I44)","v":{"v":66.09576435185184,"d":"66.10"}},null,null,{"$f":"+K41/$K$57","v":{"v":0.09195522372437359,"d":"9%"}},null,{"$f":"+I45*$J$58","v":{"v":132.19152870370368,"d":"132.19"}},{"$f":"+I45*J41*$J$58","v":{"v":59486.187916666655,"d":"59,486"}}]
[{"$f":"+A40+1","v":9},"Manhole Cover 22\" dia"]
[null," 22\" dia MH Cover",null,1,{"$nulls":4},{"$f":"PRODUCT(D47:G47)","v":{"v":1,"d":"1.00"}},{"v":17325,"d":"17325.00"},{"$f":"I48*J47","v":{"v":17325,"d":"17,325.00"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"No",{"$f":"SUM(I47:I47)","v":{"v":1,"d":"1.00"}},null,null,{"$f":"+K47/$K$57","v":{"v":0.05356282884546434,"d":"5%"}},null,{"$f":"+I48*$J$58","v":{"v":2,"d":"2.00"}},{"$f":"+I48*J47*$J$58","v":{"v":34650,"d":"34,650"}}]
[{"$f":"+A46+1","v":10},"Malleable Iron Step"]
[null,"Iron Step @1' C/C",null,1,null,"Brick Work Height",{"$f":"+(+G22+G23+G24)-1","v":12.75},null,{"$f":"ROUND(G50,0)","v":{"v":13,"d":"13.00"}},{"v":1550,"d":"1550.00"},{"$f":"I51*J50","v":{"v":20150,"d":"20,150.00"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"No",{"$f":"SUM(I50:I50)","v":{"v":13,"d":"13.00"}},null,null,{"$f":"+K50/$K$57","v":{"v":0.06229673888808695,"d":"6%"}},null,{"$f":"+I51*$J$58","v":{"v":26,"d":"26.00"}},{"$f":"+I51*J50*$J$58","v":{"v":40300,"d":"40,300"}}]
[{"$f":"+A49+1","v":11},"Backfill"]
[null,"Backfill (Total Excavation)",null,{"$f":"+D10","v":1},null,null,{"$f":"I11","v":{"v":2380.5,"d":"2380.50"}},null,{"$f":"PRODUCT(D53:G53)","v":{"v":2380.5,"d":"2380.50"}},{"v":32,"d":"32.00"},{"$f":"I55*J53","v":{"v":47237.759999999995,"d":"47,237.76"}}]
[null,"D/d of Manhole",null,-1,"Area",{"$f":"3.14*(($C$5+$G$5+$G$5)*($C$5+$G$5+$G$5))/4","v":50.24},{"$f":"+G10","v":{"v":18,"d":"18.00"}},null,{"$f":"PRODUCT(D54:G54)","v":-904.32}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I53:I54)","v":{"v":1476.1799999999998,"d":"1476.18"}},null,null,{"$f":"+K53/$K$57","v":{"v":0.14604260051504306,"d":"15%"}},null,{"$f":"+I55*$J$58","v":{"v":2952.3599999999997,"d":"2,952.36"}},{"$f":"+I55*J53*$J$58","v":{"v":94475.51999999999,"d":"94,476"}}]
[{"$nulls":11},{"$f":"SUM(L9:L55)","v":{"v":0.9999999999999999,"d":"100%"}}]
[{"$nulls":8}," Total Cost =",null,{"$f":"SUM(K9:K56)","v":{"v":323451.92316083336,"d":"323,452"}}]
[{"$nulls":8},"Total of Manhole=",{"$f":"+Summary!Q6","v":2},"No's"]
[{"$nulls":8},"Grand Total Cost=",null,{"$f":"+K57*J58","v":{"v":646903.8463216667,"d":"646,904"}},null,null,{"$f":"SUM(N9:N58)","v":{"v":12609.32565162037,"d":"12,609.33"}},{"$f":"SUM(O9:O58)","v":{"v":646903.8463216667,"d":"646,904"}}]

{"sheet":"M.H 2.5'dia (H,Conc)","index":8,"n_rows":57,"n_cols":15,"rows_kept":57,"merged":[[0,3,0,8],[6,0,7,0],[6,1,6,2],[6,3,6,8],[6,9,6,10],[7,1,7,2],[9,9,10,9],[9,10,10,10],[10,3,10,6],[12,9,13,9],[12,10,13,10],[13,3,13,6],[15,9,16,9],[15,10,16,10],[16,3,16,6],[18,9,19,9],[18,10,19,10],[19,3,19,6],[21,9,24,9],[21,10,24,10],[24,3,24,6],[26,9,30,9],[26,10,30,10],[30,3,30,6],[32,9,34,9],[32,10,34,10],[34,3,34,6],[36,9,40,9],[36,10,40,10],[40,3,40,6],[42,9,43,9],[42,10,43,10],[43,3,43,6],[45,9,46,9],[45,10,46,10],[46,3,46,6],[48,9,50,9],[48,10,50,10],[50,3,50,6]]}
[{"$nulls":3},{"$f":"+'M.H 4''dia (Type-IV'!D1","v":"PROJECT NAME "},{"$nulls":5},"Manhole #"]
[{"$nulls":4},"CIVIL INFRASTRUCTURE WORKS",{"$nulls":4},"Road Name :"]
[{"$nulls":5},"RATE ANALYSIS",{"$nulls":3},"Sewer Line (Ø)",{"v":0.5,"d":"0.50 ft"}]
["Manhole Data;"]
[null,"Manhole Inner dia(Ø)",{"v":2.5,"d":"2.50 ft"},"Depth of Manhole,",{"v":5,"d":"5.00 ft"},"Wall Thick-I",{"v":0.75,"d":"0.75 ft"},"Wall Thick-II",{"$f":"9/12","v":{"v":0.75,"d":"0.750 ft"}},"MH Type-HC","Assumed Quantity,",1]
[]
["Sr.#","Item of Works",null,"ABSTRACT OF QUANTIES",{"$nulls":5},"RATE ANALYSIS"]
[null,"Decription of items",null,"No. ","Length (ft)","width\n (ft)","Height (ft)","Unit ","Qty","Unit\nRate ","Amount ",null,null,"Total Qty","Total Rs."]
[1,"Excavation"]
[null,"Excavation ",null,{"$f":"+L5","v":1},{"$f":"+C5+1.75+0.75","v":{"v":5,"d":"5.00"}},{"$f":"+E10","v":{"v":5,"d":"5.00"}},{"$f":"+E5","v":{"v":5,"d":"5.00"}},null,{"$f":"PRODUCT(D10:G10)","v":{"v":125,"d":"125.00"}},{"v":12,"d":"12.00"},{"$f":"I11*J10","v":{"v":1500,"d":"1,500.00"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I10:I10)","v":{"v":125,"d":"125.00"}},null,null,{"$f":"+K10/$K$55","v":{"v":0.03221619127608599,"d":"3%"}},null,{"$f":"+I11*$J$56","v":{"v":30125,"d":"30,125.00"}},{"$f":"+I11*J10*$J$56","v":{"v":361500,"d":"361,500"}}]
[{"$f":"A9+1","v":2},"Dressing of bed"]
[null,"Dressing of bed",null,{"$f":"D10","v":1},{"$f":"+E10","v":{"v":5,"d":"5.00"}},{"$f":"((3.14*(($E$10-0.75)*($E$10-0.75))/4))","v":{"v":14.1790625,"d":"14.18"}},null,null,{"$f":"PRODUCT(D13:G13)","v":{"v":70.8953125,"d":"70.90"}},{"v":4,"d":"4.00"},{"$f":"I14*J13","v":{"v":283.58125,"d":"283.58"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Sft",{"$f":"SUM(I13:I13)","v":{"v":70.8953125,"d":"70.90"}},null,null,{"$f":"+K13/$K$55","v":{"v":0.006090605194874373,"d":"1%"}},null,{"$f":"+I14*$J$56","v":{"v":17085.7703125,"d":"17,085.77"}},{"$f":"+I14*J13*$J$56","v":{"v":68343.08125,"d":"68,343"}}]
[3,"Crurshed Stone Bedding"]
[null,"Crurshed Bedding 1\" Down",null,{"$f":"D10","v":1},"Area=",{"$f":"+F13","v":{"v":14.1790625,"d":"14.18"}},0.33,null,{"$f":"PRODUCT(D16:G16)","v":{"v":4.679090625000001,"d":"4.68"}},{"v":140,"d":"140.00"},{"$f":"I17*J16","v":{"v":655.0726875,"d":"655.07"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I16:I16)","v":{"v":4.679090625000001,"d":"4.68"}},null,null,{"$f":"+K16/$K$55","v":{"v":0.014069298000159804,"d":"1%"}},null,{"$f":"+I17*$J$56","v":{"v":1127.6608406250002,"d":"1,127.66"}},{"$f":"+I17*J16*$J$56","v":{"v":157872.51768750002,"d":"157,873"}}]
[{"$f":"+A15+1","v":4},"PCC Concrete 1:4:8"]
[null,"Base Concrete 1:4:8",null,{"$f":"D13","v":1},"Area=",{"$f":"((3.14*(($E$10-1.75)*($E$10-1.75))/4))","v":{"v":8.2915625,"d":"8.29"}},0.33,null,{"$f":"PRODUCT(D19:G19)","v":{"v":2.736215625,"d":"2.74"}},{"v":280,"d":"280.00"},{"$f":"I20*J19","v":{"v":766.140375,"d":"766.14"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I19:I19)","v":{"v":2.736215625,"d":"2.74"}},null,null,{"$f":"+K19/$K$55","v":{"v":0.0164547499102215,"d":"2%"}},null,{"$f":"+I20*$J$56","v":{"v":659.427965625,"d":"659.43"}},{"$f":"+I20*J19*$J$56","v":{"v":184639.830375,"d":"184,640"}}]
[{"$f":"+A18+1","v":5},"Pacca Brick Work with 1:3 C/S Mortar"]
[null,"Wall (Circular) ",null,0,{"$f":"3.142*($C$5+$I$5)","v":{"v":10.2115,"d":"10.21"}},{"$f":"+I5","v":0.75},null,null,{"$f":"PRODUCT(D22:G22)","v":{"v":0,"d":"0.00"}},{"v":420,"d":"420.00"},{"$f":"+I25*J22","v":{"v":13052.435523749999,"d":"13,052.44"}}]
[null,"Wall (Circular) ",null,{"$f":"+D19","v":1},{"$f":"3.142*($C$5+$I$5)","v":{"v":10.2115,"d":"10.21"}},{"$f":"$G$5","v":0.75},{"$f":"+G10-G16-G19-G24","v":{"v":1.5899999999999999,"d":"1.59"}},null,{"$f":"PRODUCT(D23:G23)","v":{"v":12.177213749999996,"d":"12.18"}}]
[null,"Wall (Dome)",null,{"$f":"D23","v":1},{"$f":"((3.142*($C$5+$G$5))+(3.142*(1.833+$G$5)))/2","v":{"v":9.163643,"d":"9.16"}},{"$f":"$G$5","v":0.75},2.75,null,{"v":18.9000136875,"d":"18.90"}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I22:I24)","v":{"v":31.077227437499996,"d":"31.08"}},null,null,{"$f":"+K22/$K$55","v":{"v":0.2803331729679397,"d":"28%"}},null,{"$f":"+I25*$J$56","v":{"v":7489.611812437499,"d":"7,489.61"}},{"$f":"+I25*J22*$J$56","v":{"v":3145636.9612237494,"d":"3,145,637"}}]
[{"$f":"+A21+1","v":6},"Plaster Work with 1:3 C/S Mortar"]
[null,"Wall (Circular) Outer Side",null,{"$f":"D24","v":1},{"$f":"3.142*(+$C$5+$G$5+$G$5)","v":{"v":12.568,"d":"12.57"}},null,{"$f":"+G23","v":{"v":1.5899999999999999,"d":"1.59"}},null,{"$f":"PRODUCT(D27:G27)","v":{"v":19.983119999999996,"d":"19.98"}},{"v":48,"d":"48.00"},{"$f":"+I31*J27","v":{"v":4648.639271999999,"d":"4,648.64"}}]
[null,"Wall (Dome) Outer Side",null,{"$f":"D27","v":1},{"$f":"((3.142*($C$5+$G$5+$G$5))+(3.142*(1.833+$G$5+$G$5)))/2","v":{"v":11.520143000000001,"d":"11.52"}},null,{"$f":"+G24","v":2.75},null,{"$f":"PRODUCT(D28:G28)","v":{"v":31.68039325,"d":"31.68"}}]
[null,"Wall (Circular) inner Side",null,1,{"$f":"3.142*(4)","v":{"v":12.568,"d":"12.57"}},null,{"$f":"+G27","v":{"v":1.5899999999999999,"d":"1.59"}},null,{"$f":"PRODUCT(D29:G29)","v":{"v":19.983119999999996,"d":"19.98"}}]
[null,"Wall (Dome Inner Side",null,1,{"$f":"((3.142*(4))+(3.142*(1.833)))/2","v":{"v":9.163643,"d":"9.16"}},null,{"$f":"+G28","v":2.75},null,{"$f":"PRODUCT(D30:G30)","v":{"v":25.20001825,"d":"25.20"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Sft",{"$f":"SUM(I27:I30)","v":{"v":96.8466515,"d":"96.85"}},null,null,{"$f":"+K27/$K$55","v":{"v":0.09984096797351807,"d":"10%"}},null,{"$f":"+I31*$J$56","v":{"v":23340.043011499998,"d":"23,340.04"}},{"$f":"+I31*J27*$J$56","v":{"v":1120322.0645519998,"d":"1,120,322"}}]
[{"$f":"+A26+1","v":7},"Bituman Coating (2 Coats)"]
[null,"Wall (Circular) Outer Side",null,2,{"$f":"+E27","v":{"v":12.568,"d":"12.57"}},null,{"$f":"+G27","v":{"v":1.5899999999999999,"d":"1.59"}},null,{"$f":"PRODUCT(D33:G33)","v":{"v":39.96623999999999,"d":"39.97"}},{"v":14,"d":"14.00"},{"$f":"I35*J33","v":{"v":1446.5783709999998,"d":"1,446.58"}}]
[null,"Wall (Dome) Outer Side",null,2,{"$f":"+E28","v":{"v":11.520143000000001,"d":"11.52"}},null,{"$f":"+G28","v":2.75},null,{"$f":"PRODUCT(D34:G34)","v":{"v":63.3607865,"d":"63.36"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Sft",{"$f":"SUM(I33:I34)","v":{"v":103.32702649999999,"d":"103.33"}},null,null,{"$f":"+K33/$K$55","v":{"v":0.031068830330656584,"d":"3%"}},null,{"$f":"+I35*$J$56","v":{"v":24901.813386499998,"d":"24,901.81"}},{"$f":"+I35*J33*$J$56","v":{"v":348625.387411,"d":"348,625"}}]
[{"$f":"+A32+1","v":8},"Concrete 1:2:4"]
[null,"Top Cover Slab",null,{"$f":"D24","v":1},"Area=",{"$f":"((3.14*(3.83*3.83))/4)","v":{"v":11.5150865,"d":"11.52"}},0.75,null,{"$f":"PRODUCT(D37:G37)","v":{"v":8.636314875,"d":"8.64"}},{"v":450,"d":"450.00"},{"$f":"I41*J37","v":{"v":4982.5912499999995,"d":"4,982.59"}}]
[null,"D/d of Manhole Cover",null,-1,"Area=",{"$f":"((3.14*(1.83*1.83))/4)","v":{"v":2.6288865000000006,"d":"2.63"}},0.75,null,{"$f":"PRODUCT(D38:G38)","v":{"v":-1.9716648750000005,"d":"-1.97"}}]
[null,"Beching PCC",null,{"$f":"+D37","v":1},"Area=",{"$f":"((3.14*(C5*C5))/4)","v":{"v":4.90625,"d":"4.91"}},{"$f":"0.33+($K$3+0.08)","v":{"v":0.9099999999999999,"d":"0.91"}},null,{"$f":"PRODUCT(D39:G39)","v":{"v":4.464687499999999,"d":"4.46"}}]
[null,"D/d of Pipe 6\" dia",null,-1,"Area=",{"$f":"((3.14*(K3*K3))/4)/2","v":{"v":0.098125,"d":"0.10"}},{"$f":"($K$3+0.08)","v":0.58},null,{"$f":"PRODUCT(D40:G40)","v":{"v":-0.0569125,"d":"-0.06"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I37:I40)","v":{"v":11.072424999999999,"d":"11.07"}},null,null,{"$f":"+K37/$K$55","v":{"v":0.10701340850703492,"d":"11%"}},null,{"$f":"+I41*$J$56","v":{"v":2668.454425,"d":"2,668.45"}},{"$f":"+I41*J37*$J$56","v":{"v":1200804.49125,"d":"1,200,804"}}]
[{"$f":"+A36+1","v":9},"Manhole Cover 22\" dia"]
[null," 22\" dia MH Cover",null,1,{"$nulls":4},{"$f":"PRODUCT(D43:G43)","v":{"v":1,"d":"1.00"}},{"$f":"5050+12185","v":{"v":17235,"d":"17235.00"}},{"$f":"I44*J43","v":{"v":17235,"d":"17,235.00"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"No",{"$f":"SUM(I43:I43)","v":{"v":1,"d":"1.00"}},null,null,{"$f":"+K43/$K$55","v":{"v":0.370164037762228,"d":"37%"}},null,{"$f":"+I44*$J$56","v":{"v":241,"d":"241.00"}},{"$f":"+I44*J43*$J$56","v":{"v":4153635,"d":"4,153,635"}}]
[{"$f":"+A42+1","v":10},"Malleable Iron Step"]
[null,"Iron Step @1' C/C",null,0,null,"Brick Work Height",{"$f":"+(G23+G24)-1","v":3.34},null,{"$f":"ROUND(G46*D46,0)","v":{"v":0,"d":"0.00"}},{"v":1550,"d":"1550.00"},{"$f":"I47*J46","v":0}]
[null,"Qty",null,"Total:",{"$nulls":3},"No",{"$f":"SUM(I46:I46)","v":{"v":0,"d":"0.00"}},null,null,{"$f":"+K46/$K$55","v":{"v":0,"d":"0%"}},null,{"$f":"+I47*$J$56","v":0},{"$f":"+I47*J46*$J$56","v":0}]
[{"$f":"+A45+1","v":11},"Backfill"]
[null,"Backfill (Total Excavation)",null,{"$f":"+D10","v":1},null,null,{"$f":"I11","v":{"v":125,"d":"125.00"}},null,{"$f":"PRODUCT(D49:G49)","v":{"v":125,"d":"125.00"}},{"v":32,"d":"32.00"},{"$f":"I51*J49","v":{"v":1990.3999999999999,"d":"1,990.40"}}]
[null,"D/d of Manhole",null,-1,"Area",{"$f":"3.14*(($C$5+$G$5+$G$5)*($C$5+$G$5+$G$5))/4","v":12.56},{"$f":"+G10","v":{"v":5,"d":"5.00"}},null,{"$f":"PRODUCT(D50:G50)","v":{"v":-62.800000000000004,"d":"-62.80"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I49:I50)","v":{"v":62.199999999999996,"d":"62.20"}},null,null,{"$f":"+K49/$K$55","v":{"v":0.04274873807728104,"d":"4%"}},null,{"$f":"+I51*$J$56","v":{"v":14990.199999999999,"d":"14,990.20"}},{"$f":"+I51*J49*$J$56","v":{"v":479686.39999999997,"d":"479,686"}}]
[{"$nulls":11},{"$f":"SUM(L10:L51)","v":{"v":1,"d":"100%"}}]
[{"$nulls":8}," Cost for 10 Rft "]
[{"$nulls":8},"Overhead 10%"]
[{"$nulls":8}," Total Cost =",null,{"$f":"SUM(K9:K54)","v":{"v":46560.438729249996,"d":"46,560"}}]
[{"$nulls":8},"Total of Manhole=",{"$f":"+Summary!S6","v":241},"No's"]
[{"$nulls":8},"Grand Total Cost=",null,{"$f":"+K55*J56","v":{"v":11221065.73374925,"d":"11,221,066"}},null,null,{"$f":"SUM(N9:N56)","v":{"v":122628.9817541875,"d":"122,628.98"}},{"$f":"SUM(O9:O56)","v":{"v":11221065.73374925,"d":"11,221,066"}}]

{"sheet":"M.H 4'dia (Type-II","index":9,"n_rows":58,"n_cols":15,"rows_kept":58,"hidden":true,"merged":[[0,0,0,11],[5,0,6,0],[5,3,5,8],[5,9,5,10],[6,1,6,2],[8,9,9,9],[8,10,9,10],[9,3,9,6],[11,9,12,9],[11,10,12,10],[12,3,12,6],[13,1,13,10],[14,9,15,9],[14,10,15,10],[15,3,15,6],[16,1,16,10],[17,9,18,9],[17,10,18,10],[18,3,18,6],[19,1,19,10],[20,9,23,9],[20,10,23,10],[23,3,23,6],[24,1,24,10],[25,9,29,9],[25,10,29,10],[29,3,29,6],[30,1,30,10],[31,9,35,9],[31,10,35,10],[35,3,35,6],[36,1,36,10],[37,9,41,9],[37,10,41,10],[41,3,41,6],[42,1,42,10],[43,9,44,9],[43,10,44,10],[44,3,44,6],[45,1,45,10],[46,9,47,9],[46,10,47,10],[47,3,47,6],[48,1,48,10],[49,9,51,9],[49,10,51,10],[51,3,51,6]]}
["ETIHAD TOWN PHASE-II, LAHORE"]
["CIVIL INFRASTRUCTURE WORKS"]
["RATE ANALYSIS"]
[null,"Manhole 4' i/d upto Height=",null,6,"Ft",null,"Type-II",null,null,"Assumed Quantity=",{"v":1,"d":"1.00"},"No"]
[]
["Sr.#","Item of Works",null,"ABSTRACT OF QUANTIES",{"$nulls":5},"RATE ANALYSIS"]
[null,"Decription of items",null,"No. ","Length (ft)","width\n (ft)","Height (ft)","Unit ","Qty","Labour\nRate ","Amount ",null,null,"Total Qty","Total Rs."]
[1,"Excavation"]
[null,"Excavation ",null,{"$f":"+K4","v":1},{"v":9,"d":"9.00"},{"v":9,"d":"9.00"},{"$f":"+D4","v":{"v":6,"d":"6.00"}},null,{"$f":"PRODUCT(D9:G9)","v":{"v":486,"d":"486.00"}},{"v":8,"d":"8.00"},{"$f":"I10*J9","v":{"v":3888,"d":"3,888.00"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I9:I9)","v":{"v":486,"d":"486.00"}},{"$nulls":4},{"$f":"+I10*$J$57","v":{"v":126360,"d":"126,360.00"}},{"$f":"+I10*J9*$J$57","v":{"v":1010880,"d":"1,010,880"}}]
[{"$f":"A8+1","v":2},"Dressing of bed"]
[null,"Dressing of bed",null,{"$f":"D9","v":1},{"$f":"+E9","v":{"v":9,"d":"9.00"}},{"$f":"((3.14*(8.25*8.25))/4)","v":{"v":53.4290625,"d":"53.43"}},null,null,{"$f":"PRODUCT(D12:G12)","v":{"v":480.8615625,"d":"480.86"}},{"v":3,"d":"3.00"},{"$f":"I13*J12","v":{"v":1442.5846875,"d":"1,442.58"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Sft",{"$f":"SUM(I12:I12)","v":{"v":480.8615625,"d":"480.86"}},{"$nulls":4},{"$f":"+I13*$J$57","v":{"v":125024.00624999999,"d":"125,024.01"}},{"$f":"+I13*J12*$J$57","v":{"v":375072.01875,"d":"375,072"}}]
[3,"Crurshed Stone Bedding"]
[null,"Crurshed Bedding 1\" Down",null,{"$f":"D9","v":1},"Area=",{"$f":"((3.14*(8.25*8.25))/4)","v":{"v":53.4290625,"d":"53.43"}},{"v":0.5,"d":"0.50"},null,{"$f":"PRODUCT(D15:G15)","v":{"v":26.71453125,"d":"26.71"}},{"v":55,"d":"55.00"},{"$f":"I16*J15","v":{"v":1469.29921875,"d":"1,469.30"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I15:I15)","v":{"v":26.71453125,"d":"26.71"}},{"$nulls":4},{"$f":"+I16*$J$57","v":{"v":6945.778125,"d":"6,945.78"}},{"$f":"+I16*J15*$J$57","v":{"v":382017.796875,"d":"382,018"}}]
[{"$f":"+A14+1","v":4},"PCC Concrete 1:3:6"]
[null,"Base Concrete 1:3:6",null,{"$f":"D12","v":1},"Area=",{"$f":"((3.14*(7.25*7.25))/4)","v":{"v":41.261562500000004,"d":"41.26"}},0.75,null,{"$f":"PRODUCT(D18:G18)","v":{"v":30.946171875000005,"d":"30.95"}},{"v":260,"d":"260.00"},{"$f":"I19*J18","v":{"v":8046.004687500001,"d":"8,046.00"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I18:I18)","v":{"v":30.946171875000005,"d":"30.95"}},{"$nulls":4},{"$f":"+I19*$J$57","v":{"v":8046.004687500001,"d":"8,046.00"}},{"$f":"+I19*J18*$J$57","v":{"v":2091961.2187500002,"d":"2,091,961"}}]
[{"$f":"+A17+1","v":5},"Pacca Brick Work with 1:3 C/S Mortar"]
[null,"Wall (Circular) ",null,0,{"$f":"3.142*(4+1.125)","v":{"v":16.10275,"d":"16.10"}},{"v":1.225,"d":"1.23"},null,null,{"$f":"PRODUCT(D21:G21)","v":{"v":0,"d":"0.00"}},{"v":320,"d":"320.00"},{"$f":"+I24*J21","v":{"v":14767.05438,"d":"14,767.05"}}]
[null,"Wall (Circular) ",null,{"$f":"+D18","v":1},{"$f":"3.142*(4+0.75)","v":{"v":14.9245,"d":"14.92"}},0.75,{"$f":"+G9-G15-G18-G23","v":{"v":2,"d":"2.00"}},null,{"$f":"PRODUCT(D22:G22)","v":{"v":22.38675,"d":"22.39"}}]
[null,"Wall (Dome)",null,{"$f":"D22","v":1},{"$f":"((3.142*(4+0.75))+(3.142*(1.833+0.75)))/2","v":{"v":11.520143000000001,"d":"11.52"}},0.75,2.75,null,{"v":23.7602949375,"d":"23.76"}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I21:I23)","v":{"v":46.1470449375,"d":"46.15"}},{"$nulls":4},{"$f":"+I24*$J$57","v":{"v":11998.23168375,"d":"11,998.23"}},{"$f":"+I24*J21*$J$57","v":{"v":3839434.1388,"d":"3,839,434"}}]
[{"$f":"+A20+1","v":6},"Plaster Work with 1:3 C/S Mortar"]
[null,"Wall (Circular) Outer Side",null,{"$f":"D23","v":1},{"$f":"3.142*(4+0.75+0.75)","v":{"v":17.281,"d":"17.28"}},null,{"$f":"+G22","v":{"v":2,"d":"2.00"}},null,{"$f":"PRODUCT(D26:G26)","v":{"v":34.562,"d":"34.56"}},{"v":45,"d":"45.00"},{"$f":"+I30*J26","v":{"v":5537.6453925,"d":"5,537.65"}}]
[null,"Wall (Dome) Outer Side",null,{"$f":"D26","v":1},{"$f":"((3.142*(4+0.75+0.75))+(3.142*(1.833+0.75+0.75)))/2","v":{"v":13.876643,"d":"13.88"}},null,{"$f":"+G23","v":2.75},null,{"$f":"PRODUCT(D27:G27)","v":{"v":38.16076825,"d":"38.16"}}]
[null,"Wall (Circular) inner Side",null,1,{"$f":"3.142*(4)","v":{"v":12.568,"d":"12.57"}},null,{"$f":"+G26","v":{"v":2,"d":"2.00"}},null,{"$f":"PRODUCT(D28:G28)","v":{"v":25.136,"d":"25.14"}}]
[null,"Wall (Dome Inner Side",null,1,{"$f":"((3.142*(4))+(3.142*(1.833)))/2","v":{"v":9.163643,"d":"9.16"}},null,{"$f":"+G27","v":2.75},null,{"$f":"PRODUCT(D29:G29)","v":{"v":25.20001825,"d":"25.20"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Sft",{"$f":"SUM(I26:I29)","v":{"v":123.0587865,"d":"123.06"}},{"$nulls":4},{"$f":"+I30*$J$57","v":{"v":31995.28449,"d":"31,995.28"}},{"$f":"+I30*J26*$J$57","v":{"v":1439787.8020499998,"d":"1,439,788"}}]
[{"$f":"+A25+1","v":7},"Bituman Coating "]
[null,"Wall (Circular) Outer Side",null,{"$f":"D47","v":1},{"$f":"+E26","v":{"v":17.281,"d":"17.28"}},null,{"$f":"+G26","v":{"v":2,"d":"2.00"}},null,{"$f":"PRODUCT(D32:G32)","v":{"v":34.562,"d":"34.56"}},{"v":15,"d":"15.00"},{"$f":"I36*J32","v":{"v":1090.84152375,"d":"1,090.84"}}]
[null,"Wall (Dome) Outer Side",null,{"$f":"D32","v":1},{"$f":"+E27","v":{"v":13.876643,"d":"13.88"}},null,{"$f":"+G27","v":2.75},null,{"$f":"PRODUCT(D33:G33)","v":{"v":38.16076825,"d":"38.16"}}]
[null,"Wall (Circular) inner Side",null,0,{"$f":"+E28","v":{"v":12.568,"d":"12.57"}},null,{"$f":"+G28","v":{"v":2,"d":"2.00"}},null,{"$f":"PRODUCT(D34:G34)","v":{"v":0,"d":"0.00"}}]
[null,"Wall (Dome Inner Side",null,{"$f":"+D34","v":0},{"$f":"+E29","v":{"v":9.163643,"d":"9.16"}},null,{"$f":"+G29","v":2.75},null,{"$f":"PRODUCT(D35:G35)","v":{"v":0,"d":"0.00"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Sft",{"$f":"SUM(I32:I35)","v":{"v":72.72276825,"d":"72.72"}},{"$nulls":4},{"$f":"+I36*$J$57","v":{"v":18907.919745,"d":"18,907.92"}},{"$f":"+I36*J32*$J$57","v":{"v":283618.796175,"d":"283,619"}}]
[{"$f":"+A31+1","v":8},"Concrete 1:2:4"]
[null,"Top Cover Slab",null,{"$f":"D23","v":1},"Area=",{"$f":"((3.14*(3.83*3.83))/4)","v":{"v":11.5150865,"d":"11.52"}},0.75,null,{"$f":"PRODUCT(D38:G38)","v":{"v":8.636314875,"d":"8.64"}},{"v":340,"d":"340.00"},{"$f":"I42*J38","v":{"v":5415.512208333332,"d":"5,415.51"}}]
[null,"D/d of Manhole Cover",null,-1,"Area=",{"$f":"((3.14*(1.83*1.83))/4)","v":{"v":2.6288865000000006,"d":"2.63"}},0.75,null,{"$f":"PRODUCT(D39:G39)","v":{"v":-1.9716648750000005,"d":"-1.97"}}]
[null,"Beching PCC",null,{"$f":"+D38","v":1},"Area=",{"$f":"((3.14*(4*4))/4)","v":12.56},{"$f":"0.33+0.08+(0.333333333333333)","v":{"v":0.743333333333333,"d":"0.74"}},null,{"$f":"PRODUCT(D40:G40)","v":{"v":9.336266666666662,"d":"9.34"}}]
[null,"D/d of Pipe 6\" dia",null,-1,"Area=",{"$f":"((3.14*(0.5*0.5))/4)/2","v":{"v":0.098125,"d":"0.10"}},{"$f":"+G40","v":{"v":0.743333333333333,"d":"0.74"}},null,{"$f":"PRODUCT(D41:G41)","v":{"v":-0.0729395833333333,"d":"-0.07"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I38:I41)","v":{"v":15.927977083333328,"d":"15.93"}},{"$nulls":4},{"$f":"+I42*$J$57","v":{"v":4141.274041666666,"d":"4,141.27"}},{"$f":"+I42*J38*$J$57","v":{"v":1408033.1741666663,"d":"1,408,033"}}]
[{"$f":"+A37+1","v":9},"Manhole Cover 22\" dia"]
[null," 22\" dia MH Cover",null,1,{"$nulls":4},{"$f":"PRODUCT(D44:G44)","v":{"v":1,"d":"1.00"}},{"v":5000,"d":"5000.00"},{"$f":"I45*J44","v":{"v":5000,"d":"5,000.00"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"No",{"$f":"SUM(I44:I44)","v":{"v":1,"d":"1.00"}},{"$nulls":4},{"$f":"+I45*$J$57","v":{"v":260,"d":"260.00"}},{"$f":"+I45*J44*$J$57","v":{"v":1300000,"d":"1,300,000"}}]
[{"$f":"+A43+1","v":10},"Malleable Iron Step"]
[null,"Iron Step @1' C/C",null,1,null,"Brick Work Height",{"$f":"+(G22+G23)-1","v":3.75},null,{"$f":"ROUND(G47,0)","v":{"v":4,"d":"4.00"}},{"v":400,"d":"400.00"},{"$f":"I48*J47","v":{"v":1600,"d":"1,600.00"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"No",{"$f":"SUM(I47:I47)","v":{"v":4,"d":"4.00"}},{"$nulls":4},{"$f":"+I48*$J$57","v":{"v":1040,"d":"1,040.00"}},{"$f":"+I48*J47*$J$57","v":{"v":416000,"d":"416,000"}}]
[{"$f":"+A46+1","v":11},"Backfill"]
[null,"Backfill (Total Excavation)",null,{"$f":"+D9","v":1},null,null,{"$f":"I10","v":{"v":486,"d":"486.00"}},null,{"$f":"PRODUCT(D50:G50)","v":{"v":486,"d":"486.00"}},{"v":12,"d":"12.00"},{"$f":"I52*J50","v":{"v":4122.27,"d":"4,122.27"}}]
[null,"D/d of Manhole",null,-1,"Area",{"$f":"3.14*(5.5*5.5)/4","v":{"v":23.74625,"d":"23.75"}},{"$f":"+G9","v":{"v":6,"d":"6.00"}},null,{"$f":"PRODUCT(D51:G51)","v":{"v":-142.4775,"d":"-142.48"}}]
[null,"Qty",null,"Total:",{"$nulls":3},"Cft",{"$f":"SUM(I50:I51)","v":{"v":343.52250000000004,"d":"343.52"}},{"$nulls":4},{"$f":"+I52*$J$57","v":{"v":89315.85,"d":"89,315.85"}},{"$f":"+I52*J50*$J$57","v":{"v":1071790.2000000002,"d":"1,071,790"}}]
[]
[{"$nulls":8}," Cost for 10 Rft "]
[{"$nulls":8},"Overhead 10%"]
[{"$nulls":8}," Total Cost =",null,{"$f":"SUM(K8:K55)","v":{"v":52379.21209833333,"d":"52,379"}}]
[{"$nulls":8},"Total of Manhole=",260,"No's"]
[{"$nulls":8},"Grand Total Cost=",null,{"$f":"+K56*J57","v":{"v":13618595.145566666,"d":"13,618,595"}},null,null,{"$f":"SUM(N8:N57)","v":{"v":424034.34902291663,"d":"424,034.35"}},{"$f":"SUM(O8:O57)","v":{"v":13618595.145566665,"d":"13,618,595"}}]

{"sheet":"Steel Fixing ","index":10,"n_rows":140,"n_cols":11,"rows_kept":140,"hidden":true,"merged":[[0,0,0,7],[6,2,6,5],[10,1,10,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[46,2,46,5],[50,1,50,2],[51,1,51,2],[52,1,52,2],[54,1,54,2],[55,1,55,2],[58,1,58,2],[59,1,59,2],[96,2,96,5],[100,1,100,2],[101,1,101,2],[102,1,102,2],[104,1,104,2],[105,1,105,2],[108,1,108,2],[109,1,109,2]]}
["Naval Anchorage Gawadar"]
["CIVIL INFRASTRUCTURE WORKS"]
[]
["RATE ANALYSIS"]
[null,"Steel Fixing for Drain"]
[null,"Item # 001",{"$nulls":3},"Unit",{"v":5,"d":"5.00"},"Ton"]
[null,"Item Desc.","Provid and fixing Steel for Drain including Cutting & beding in all respect to complete."]
[]
["A","Manpower"]
[null,"Description",null,"No.","Hours","Rate (Rs.)","Amount (Rs.)"]
[null,"Supervisor",null,1,{"v":8,"d":"8.00"},134.23,{"$f":"D11*E11*F11","v":{"v":1073.84,"d":"1,073.84"}}]
[null,"Steel Fixer",null,7,{"v":8,"d":"8.00"},65.19,{"$f":"D12*E12*F12","v":{"v":3650.64,"d":"3,650.64"}}]
[null,"Labour",null,10,{"v":8,"d":"8.00"},65.19,{"v":5215.2,"d":"5,215.20"}]
[]
[]
[]
[null,"Total  Manpower (A)",{"$nulls":4},{"$f":"SUM(G11:G15)","v":{"v":9939.68,"d":"9,939.68"}}]
["B","Materials"]
[{"$nulls":3},"Unit","Quantity","Rate (Rs.)","Amount"]
[null,"Cold Steel Wire (Aashto M-32)",null,"Ton",0.13,{"v":104000,"d":"104,000.00"},{"$f":"E20*F20","v":{"v":13520,"d":"13,520.00"}},null,{"v":1,"d":"1.00"},{"$f":"+I20*1.54","v":1.54}]
[{"$nulls":8},1,{"$f":"+(1/7)*J20","v":0.22},{"$f":"+J21*35.32","v":7.7704}]
[{"$nulls":8},2,{"$f":"+J21*2","v":0.44},{"$f":"+J22*35.32","v":15.5408}]
[{"$nulls":8},4,{"$f":"+J21*4","v":0.88},{"$f":"+J23*35.32","v":31.0816}]
[]
[]
[null,"Total Materials (B)",{"$nulls":4},{"$f":"SUM(G20:G24)","v":{"v":13520,"d":"13,520.00"}}]
["C","Equipment /Machinery"]
[{"$nulls":3},"No.","Hours","Rate (Rs.)","Amount (Rs.)"]
[null,"Tractor Trolley",null,1,{"v":8,"d":"8.00"},{"v":920,"d":"920.00"},{"$f":"D29*E29*F29","v":{"v":7360,"d":"7,360.00"}}]
[]
[]
[]
[]
[null,"Total Equipment / Machinery ( C )",{"$nulls":4},{"$f":"SUM(G29:G32)","v":{"v":7360,"d":"7,360.00"}}]
[null,"Summary"]
[]
[null,"Basic Cost For 1 Ton",{"$nulls":4},{"$f":"G17+G26+G34","v":{"v":30819.68,"d":"30,819.68"}}]
[null,"Basic Cost Per Ton",{"$nulls":4},{"$f":"ROUND(G37/G6,2)","v":{"v":6163.94,"d":"6,163.94"}}]
[null,"OverHead & Profit (15)Percentage",{"$nulls":4},{"$f":"G38*15%","v":{"v":924.5909999999999,"d":"924.59"}}]
[null,"Total Cost Per Ton ",{"$nulls":4},{"$f":"G38+G39","v":{"v":7088.530999999999,"d":"7,088.53"}}]
[{"$f":"A1","v":"Naval Anchorage Gawadar"}]
[{"$f":"A2","v":"CIVIL INFRASTRUCTURE WORKS"}]
[]
["RATE ANALYSIS"]
[null,"Concrete Class-A1"]
[null,"Item # 401 a1 (i)",{"$nulls":3},"Unit",{"v":72,"d":"72.00"},"CM"]
[null,"Item Desc.","Concrete Class-A1 (Under Ground) Ratio 1:2:4 3000 PSI Cylinder Strength"]
[]
["A","Manpower"]
[null,"Description",null,"No.","Hours","Rate (Rs.)","Amount (Rs.)"]
[null,"Site Engineer",null,1,{"v":20,"d":"20.00"},267.07,{"$f":"D51*E51*F51","v":{"v":5341.4,"d":"5,341.40"}}]
[null,"Concrete Plant Engineer",null,1,{"v":4,"d":"4.00"},485.58,{"$f":"D52*E52*F52","v":{"v":1942.32,"d":"1,942.32"}}]
[null,"Forman Concrete",null,1,{"v":24,"d":"24.00"},{"v":150,"d":"150.00"},{"$f":"D53*E53*F53","v":{"v":3600,"d":"3,600.00"}}]
[null,"Supervisor",null,1,{"v":24,"d":"24.00"},169.95,{"$f":"D54*E54*F54","v":{"v":4078.7999999999997,"d":"4,078.80"}}]
[null,"Surveyor",null,1,{"v":20,"d":"20.00"},281.51,{"v":5630.2,"d":"5,630.20"}]
[null,"Assistant.Surveyor ",null,1,{"v":20,"d":"20.00"},106.83,{"v":2136.6,"d":"2,136.60"}]
[null,"Mason",null,8,{"v":8,"d":"8.00"},118.75,{"v":7600,"d":"7,600.00"}]
[null,"Carpenter",null,10,{"v":24,"d":"24.00"},{"v":125,"d":"125.00"},{"v":30000,"d":"30,000.00"}]
[null,"Helper",null,15,{"v":24,"d":"24.00"},{"v":62.5,"d":"62.50"},{"$f":"D59*E59*F59","v":{"v":22500,"d":"22,500.00"}}]
[null,"Labour",null,10,{"v":8,"d":"8.00"},{"v":62.5,"d":"62.50"},{"$f":"D60*E60*F60","v":{"v":5000,"d":"5,000.00"}}]
[]
[null,"Total  Manpower (A)",{"$nulls":4},{"$f":"SUM(G51:G60)","v":{"v":87829.31999999999,"d":"87,829.32"}}]
["B","Materials"]
[{"$nulls":3},"Unit","Quantity","Rate (Rs.)","Amount"]
[null,"Cement ",null,"Bag",{"$f":"(350/50)*72","v":{"v":504,"d":"504.00"}},{"v":535,"d":"535.00"},{"$f":"E65*F65","v":{"v":269640,"d":"269,640.00"}}]
[null,"Local Sand",null,"Cft",{"$f":"17*72","v":{"v":1224,"d":"1224.00"}},{"v":25,"d":"25.00"},{"$f":"E66*F66","v":{"v":30600,"d":"30,600.00"}},null,{"$f":"E66/35.32","v":34.65458663646659}]
[null,"Crushed",null,"Cft",{"$f":"32*72","v":{"v":2304,"d":"2304.00"}},{"v":41,"d":"41.00"},{"v":94464,"d":"94,464.00"},null,{"$f":"E67/35.32","v":65.2321630804077}]
[null,"Admixture",null,"Ltr",{"$f":"5.25*72","v":{"v":378,"d":"378.00"}},{"v":72,"d":"72.00"},{"v":27216,"d":"27,216.00"}]
[null,"Water",null,"1000LIT",15.45,{"v":120,"d":"120.00"},{"v":1854,"d":"1,854.00"}]
[null,"Shuttering (A)",null,"CM",{"v":72,"d":"72.00"},112.79,{"v":8120.88,"d":"8,120.88"}]
[]
[null,"Total Materials (B)",{"$nulls":4},{"$f":"SUM(G65:G70)","v":{"v":431894.88,"d":"431,894.88"}}]
["C","Equipment /Machinery"]
[{"$nulls":3},"No.","Hours","Rate (Rs.)","Amount (Rs.)"]
[null,"Front End Loader 1.50 Cu.m",null,1,{"v":2,"d":"2.00"},{"v":1364.75,"d":"1,364.75"},{"$f":"D75*E75*F75","v":{"v":2729.5,"d":"2,729.50"}}]
[null,"Water Tank Tow Type 12000 LTR.(INCLUDE.TRACTOR)",null,1,{"v":3,"d":"3.00"},{"v":1446.17,"d":"1,446.17"},{"v":4338.51,"d":"4,338.51"}]
[null,"Concrete Batching Plant.30 CUM/H",null,1,{"v":3,"d":"3.00"},{"v":600,"d":"600.00"},{"v":1800,"d":"1,800.00"}]
[null,"Concrete Transit mixer.6 Cu.m",null,6,{"v":4,"d":"4.00"},{"v":1605.14,"d":"1,605.14"},{"v":38523.36,"d":"38,523.36"}]
[null,"Pump 4'' Delivery (Diesel)",null,1,{"v":2,"d":"2.00"},{"v":625,"d":"625.00"},{"v":1250,"d":"1,250.00"}]
[null,"Vibrator (Pocker 1.5\")",null,2,{"v":6,"d":"6.00"},152.57,{"v":1830.84,"d":"1,830.84"}]
[null,"Tractor Trolley",null,1,{"v":4,"d":"4.00"},466.03,{"v":1864.12,"d":"1,864.12"}]
[]
[null,"Total Equipment / Machinery ( C )",{"$nulls":4},{"$f":"SUM(G75:G81)","v":{"v":52336.33,"d":"52,336.33"}}]
[null,"Summary"]
[]
[null,"Basic Cost For 72.00 CM ",{"$nulls":4},{"$f":"G62+G72+G83","v":{"v":572060.53,"d":"572,060.53"}}]
[null,"Basic Cost Per CM",{"$nulls":4},{"$f":"ROUND(G86/72,2)","v":{"v":7945.29,"d":"7,945.29"}},null,{"$f":"G87/35.315","v":{"v":224.98343480107604,"d":"224.98"}}]
[null,"Basic Cost Per CFT",{"$nulls":4},{"$f":"ROUND(G87/35.32,2)","v":224.95}]
[null,"OverHead & Profit (10 + 15)Percentage",{"$nulls":4},{"$f":"G88*0.25","v":{"v":56.2375,"d":"56.24"}}]
[null,"Total Cost Per CFT",{"$nulls":4},{"$f":"ROUND(SUM(G88:G89),2)","v":281.19}]
["ROYAL ORCHARD MULTAN"]
[{"$f":"A42","v":"CIVIL INFRASTRUCTURE WORKS"}]
[]
["RATE ANALYSIS"]
[null,"Concrete Class-A3 "]
[null,"Item # 401 a 3 (iii) ",{"$nulls":3},"Unit",{"v":72,"d":"72.00"},"CM"]
[null,"Item Desc.","Concrete Class-A3 (Elevated)Ratio 1:1.5:3 4000 PSI Cylinder Strength"]
[]
["A","Manpower"]
[null,"Description",null,"No.","Hours","Rate (Rs.)","Amount (Rs.)"]
[null,"Site Engineer",null,1,{"v":20,"d":"20.00"},267.07,{"$f":"D101*E101*F101","v":{"v":5341.4,"d":"5,341.40"}}]
[null,"Concrete Plant Engineer",null,1,{"v":4,"d":"4.00"},485.58,{"$f":"D102*E102*F102","v":{"v":1942.32,"d":"1,942.32"}}]
[null,"Forman Concrete",null,1,{"v":24,"d":"24.00"},{"v":150,"d":"150.00"},{"$f":"D103*E103*F103","v":{"v":3600,"d":"3,600.00"}}]
[null,"Supervisor",null,1,{"v":24,"d":"24.00"},169.95,{"$f":"D104*E104*F104","v":{"v":4078.7999999999997,"d":"4,078.80"}}]
[null,"Surveyor",null,1,{"v":20,"d":"20.00"},281.51,{"v":5630.2,"d":"5,630.20"}]
[null,"Assistant.Surveyor ",null,1,{"v":20,"d":"20.00"},106.83,{"v":2136.6,"d":"2,136.60"}]
[null,"Mason",null,8,{"v":8,"d":"8.00"},118.75,{"v":7600,"d":"7,600.00"}]
[null,"Carpenter",null,10,{"v":24,"d":"24.00"},{"v":125,"d":"125.00"},{"v":30000,"d":"30,000.00"}]
[null,"Helper",null,15,{"v":24,"d":"24.00"},{"v":62.5,"d":"62.50"},{"$f":"D109*E109*F109","v":{"v":22500,"d":"22,500.00"}}]
[null,"Labour",null,10,{"v":8,"d":"8.00"},{"v":62.5,"d":"62.50"},{"$f":"D110*E110*F110","v":{"v":5000,"d":"5,000.00"}}]
[]
[null,"Total  Manpower (A)",{"$nulls":4},{"$f":"SUM(G101:G110)","v":{"v":87829.31999999999,"d":"87,829.32"}}]
["B","Materials"]
[{"$nulls":3},"Unit","Quantity","Rate (Rs.)","Amount"]
[null,"Cement ",null,"Bag",{"$f":"(450/50)*72","v":{"v":648,"d":"648.00"}},{"v":535,"d":"535.00"},{"$f":"E115*F115","v":{"v":346680,"d":"346,680.00"}}]
[null,"Haro Sand",null,"Cft",{"$f":"16*72","v":{"v":1152,"d":"1152.00"}},{"v":25,"d":"25.00"},{"$f":"E116*F116","v":{"v":28800,"d":"28,800.00"}},null,{"$f":"E116/35.32","v":32.61608154020385}]
[null,"Crushed",null,"Cft",{"$f":"30*72","v":{"v":2160,"d":"2160.00"}},{"v":41,"d":"41.00"},{"v":88560,"d":"88,560.00"},null,{"$f":"E117/35.32","v":61.15515288788222}]
[null,"Admixture",null,"Ltr",{"$f":"6.75*72","v":{"v":486,"d":"486.00"}},{"v":72,"d":"72.00"},{"v":34992,"d":"34,992.00"}]
[null,"Water",null,"1000LIT",{"v":15,"d":"15.00"},{"v":120,"d":"120.00"},{"v":1800,"d":"1,800.00"}]
[null,"Shuttering (A)",null,"CM",{"v":72,"d":"72.00"},{"v":2474,"d":"2,474.00"},{"v":178128,"d":"178,128.00"}]
[]
[null,"Total Materials (B)",{"$nulls":4},{"$f":"SUM(G115:G120)","v":{"v":678960,"d":"678,960.00"}}]
["C","Equipment /Machinery"]
[{"$nulls":3},"No.","Hours","Rate (Rs.)","Amount (Rs.)"]
[null,"Front End Loader 1.50 Cu.m",null,1,{"v":2,"d":"2.00"},{"v":1364.75,"d":"1,364.75"},{"$f":"D125*E125*F125","v":{"v":2729.5,"d":"2,729.50"}}]
[null,"Water Tank Tow Type 12000 LTR.(INCLUDE.TRACTOR)",null,1,{"v":3,"d":"3.00"},{"v":1446.17,"d":"1,446.17"},{"v":4338.51,"d":"4,338.51"}]
[null,"Concrete Batching Plant.30 CUM/H",null,1,{"v":3,"d":"3.00"},{"v":600,"d":"600.00"},{"v":1800,"d":"1,800.00"}]
[null,"Concrete Transit mixer.6 Cu.m",null,6,{"v":4,"d":"4.00"},{"v":1605.14,"d":"1,605.14"},{"v":38523.36,"d":"38,523.36"}]
[null,"Pump 4'' Delivery (Diesel)",null,1,{"v":2,"d":"2.00"},{"v":625,"d":"625.00"},{"v":1250,"d":"1,250.00"}]
[null,"Vibrator (Pocker 1.5\")",null,2,{"v":6,"d":"6.00"},152.57,{"v":1830.84,"d":"1,830.84"}]
[null,"Tractor Trolley",null,1,{"v":4,"d":"4.00"},466.03,{"v":1864.12,"d":"1,864.12"}]
[]
[null,"Total Equipment / Machinery ( C )",{"$nulls":4},{"$f":"SUM(G125:G131)","v":{"v":52336.33,"d":"52,336.33"}}]
[null,"Summary"]
[]
[null,"Basic Cost For 72.00 CM ",{"$nulls":4},{"$f":"G112+G122+G133","v":{"v":819125.6499999999,"d":"819,125.65"}}]
[null,"Basic Cost Per CM",{"$nulls":4},{"$f":"ROUND(G136/72,2)","v":{"v":11376.75,"d":"11,376.75"}},null,{"$f":"G137/35.315","v":{"v":322.1506442021804,"d":"322.15"}}]
[null,"Basic Cost Per CFT",{"$nulls":4},{"$f":"ROUND(G137/35.32,2)","v":322.11}]
[null,"OverHead & Profit (10 + 15)Percentage",{"$nulls":4},{"$f":"G138*0.25","v":{"v":80.5275,"d":"80.53"}}]
[null,"Total Cost Per CFT",{"$nulls":4},{"$f":"ROUND(SUM(G138:G139),2)","v":402.64}]

{"sheet":"Shuttering","index":11,"n_rows":140,"n_cols":15,"rows_kept":140,"hidden":true,"merged":[[0,0,0,7],[6,2,6,5],[10,1,10,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[46,2,46,5],[50,1,50,2],[51,1,51,2],[52,1,52,2],[54,1,54,2],[55,1,55,2],[58,1,58,2],[59,1,59,2],[96,2,96,5],[100,1,100,2],[101,1,101,2],[102,1,102,2],[104,1,104,2],[105,1,105,2],[108,1,108,2],[109,1,109,2]]}
["Etihad Town Phase-II, Lahore"]
["CIVIL INFRASTRUCTURE WORKS"]
[]
["RATE ANALYSIS"]
[null,"Shuttering for Drain"]
[null,"Item # 002",{"$nulls":3},"Unit",{"v":635,"d":"635.00"},"Sft",null,{"$f":"0.67+2+0.67","v":3.34},{"$f":"2+0.33+0.67","v":3},{"$f":"K6","v":3},{"$f":"0.67+2+0.67","v":3.34},{"$f":"SUM(J6:M6)","v":12.68},{"$f":"N6*100","v":1268}]
[null,"Item Desc.","Provid and fixing Shuttering for Drain including all asseccories   to complete."]
[]
["A","Manpower",{"$nulls":7},{"$f":"G6/2","v":317.5}]
[null,"Description",null,"No.","Hours","Rate (Rs.)","Amount (Rs.)"]
[null,"Supervisor",null,1,{"v":8,"d":"8.00"},134.23,{"$f":"D11*E11*F11","v":{"v":1073.84,"d":"1,073.84"}}]
[null,"Carpenter",null,4,{"v":8,"d":"8.00"},65.19,{"$f":"D12*E12*F12","v":{"v":2086.08,"d":"2,086.08"}}]
[null,"Labour",null,8,{"v":8,"d":"8.00"},65.19,{"v":4172.16,"d":"4,172.16"}]
[]
[]
[]
[null,"Total  Manpower (A)",{"$nulls":4},{"$f":"SUM(G11:G15)","v":{"v":7332.08,"d":"7,332.08"}}]
["B","Materials"]
[{"$nulls":3},"Unit","Quantity","Rate (Rs.)","Amount"]
[null,"Special Tools",null,"Ls",{"v":1,"d":"1.00"},{"v":4500,"d":"4,500.00"},{"$f":"E20*F20","v":{"v":4500,"d":"4,500.00"}},null,{"v":1,"d":"1.00"},{"$f":"+I20*1.54","v":1.54}]
[{"$nulls":8},1,{"$f":"+(1/7)*J20","v":0.22},{"$f":"+J21*35.32","v":7.7704}]
[{"$nulls":8},2,{"$f":"+J21*2","v":0.44},{"$f":"+J22*35.32","v":15.5408}]
[{"$nulls":8},4,{"$f":"+J21*4","v":0.88},{"$f":"+J23*35.32","v":31.0816}]
[]
[]
[null,"Total Materials (B)",{"$nulls":4},{"$f":"SUM(G20:G24)","v":{"v":4500,"d":"4,500.00"}}]
["C","Equipment /Machinery"]
[{"$nulls":3},"No.","Hours","Rate (Rs.)","Amount (Rs.)"]
[null,"Tractor Trolley",null,1,{"v":6,"d":"6.00"},{"v":920,"d":"920.00"},{"$f":"D29*E29*F29","v":{"v":5520,"d":"5,520.00"}}]
[]
[]
[]
[]
[null,"Total Equipment / Machinery ( C )",{"$nulls":4},{"$f":"SUM(G29:G32)","v":{"v":5520,"d":"5,520.00"}}]
[null,"Summary"]
[]
[null,"Basic Cost For 635 Sft.",{"$nulls":4},{"$f":"G17+G26+G34","v":{"v":17352.08,"d":"17,352.08"}}]
[null,"Basic Cost Per Sft.",{"$nulls":4},{"$f":"ROUND(G37/G6,2)","v":27.33}]
[null,"OverHead & Profit (15)Percentage",{"$nulls":4},{"$f":"G38*15%","v":{"v":4.0995,"d":"4.10"}}]
[null,"Total Cost Per Sft.",{"$nulls":4},{"$f":"G38+G39","v":{"v":31.429499999999997,"d":"31.43"}}]
[{"$f":"A1","v":"Etihad Town Phase-II, Lahore"}]
[{"$f":"A2","v":"CIVIL INFRASTRUCTURE WORKS"}]
[]
["RATE ANALYSIS"]
[null,"Concrete Class-A1"]
[null,"Item # 401 a1 (i)",{"$nulls":3},"Unit",{"v":72,"d":"72.00"},"CM"]
[null,"Item Desc.","Concrete Class-A1 (Under Ground) Ratio 1:2:4 3000 PSI Cylinder Strength"]
[]
["A","Manpower"]
[null,"Description",null,"No.","Hours","Rate (Rs.)","Amount (Rs.)"]
[null,"Site Engineer",null,1,{"v":20,"d":"20.00"},267.07,{"$f":"D51*E51*F51","v":{"v":5341.4,"d":"5,341.40"}}]
[null,"Concrete Plant Engineer",null,1,{"v":4,"d":"4.00"},485.58,{"$f":"D52*E52*F52","v":{"v":1942.32,"d":"1,942.32"}}]
[null,"Forman Concrete",null,1,{"v":24,"d":"24.00"},{"v":150,"d":"150.00"},{"$f":"D53*E53*F53","v":{"v":3600,"d":"3,600.00"}}]
[null,"Supervisor",null,1,{"v":24,"d":"24.00"},169.95,{"$f":"D54*E54*F54","v":{"v":4078.7999999999997,"d":"4,078.80"}}]
[null,"Surveyor",null,1,{"v":20,"d":"20.00"},281.51,{"v":5630.2,"d":"5,630.20"}]
[null,"Assistant.Surveyor ",null,1,{"v":20,"d":"20.00"},106.83,{"v":2136.6,"d":"2,136.60"}]
[null,"Mason",null,8,{"v":8,"d":"8.00"},118.75,{"v":7600,"d":"7,600.00"}]
[null,"Carpenter",null,10,{"v":24,"d":"24.00"},{"v":125,"d":"125.00"},{"v":30000,"d":"30,000.00"}]
[null,"Helper",null,15,{"v":24,"d":"24.00"},{"v":62.5,"d":"62.50"},{"$f":"D59*E59*F59","v":{"v":22500,"d":"22,500.00"}}]
[null,"Labour",null,10,{"v":8,"d":"8.00"},{"v":62.5,"d":"62.50"},{"$f":"D60*E60*F60","v":{"v":5000,"d":"5,000.00"}}]
[]
[null,"Total  Manpower (A)",{"$nulls":4},{"$f":"SUM(G51:G60)","v":{"v":87829.31999999999,"d":"87,829.32"}}]
["B","Materials"]
[{"$nulls":3},"Unit","Quantity","Rate (Rs.)","Amount"]
[null,"Cement ",null,"Bag",{"$f":"(350/50)*72","v":{"v":504,"d":"504.00"}},{"v":535,"d":"535.00"},{"$f":"E65*F65","v":{"v":269640,"d":"269,640.00"}}]
[null,"Local Sand",null,"Cft",{"$f":"17*72","v":{"v":1224,"d":"1224.00"}},{"v":25,"d":"25.00"},{"$f":"E66*F66","v":{"v":30600,"d":"30,600.00"}},null,{"$f":"E66/35.32","v":34.65458663646659}]
[null,"Crushed",null,"Cft",{"$f":"32*72","v":{"v":2304,"d":"2304.00"}},{"v":41,"d":"41.00"},{"v":94464,"d":"94,464.00"},null,{"$f":"E67/35.32","v":65.2321630804077}]
[null,"Admixture",null,"Ltr",{"$f":"5.25*72","v":{"v":378,"d":"378.00"}},{"v":72,"d":"72.00"},{"v":27216,"d":"27,216.00"}]
[null,"Water",null,"1000LIT",15.45,{"v":120,"d":"120.00"},{"v":1854,"d":"1,854.00"}]
[null,"Shuttering (A)",null,"CM",{"v":72,"d":"72.00"},112.79,{"v":8120.88,"d":"8,120.88"}]
[]
[null,"Total Materials (B)",{"$nulls":4},{"$f":"SUM(G65:G70)","v":{"v":431894.88,"d":"431,894.88"}}]
["C","Equipment /Machinery"]
[{"$nulls":3},"No.","Hours","Rate (Rs.)","Amount (Rs.)"]
[null,"Front End Loader 1.50 Cu.m",null,1,{"v":2,"d":"2.00"},{"v":1364.75,"d":"1,364.75"},{"$f":"D75*E75*F75","v":{"v":2729.5,"d":"2,729.50"}}]
[null,"Water Tank Tow Type 12000 LTR.(INCLUDE.TRACTOR)",null,1,{"v":3,"d":"3.00"},{"v":1446.17,"d":"1,446.17"},{"v":4338.51,"d":"4,338.51"}]
[null,"Concrete Batching Plant.30 CUM/H",null,1,{"v":3,"d":"3.00"},{"v":600,"d":"600.00"},{"v":1800,"d":"1,800.00"}]
[null,"Concrete Transit mixer.6 Cu.m",null,6,{"v":4,"d":"4.00"},{"v":1605.14,"d":"1,605.14"},{"v":38523.36,"d":"38,523.36"}]
[null,"Pump 4'' Delivery (Diesel)",null,1,{"v":2,"d":"2.00"},{"v":625,"d":"625.00"},{"v":1250,"d":"1,250.00"}]
[null,"Vibrator (Pocker 1.5\")",null,2,{"v":6,"d":"6.00"},152.57,{"v":1830.84,"d":"1,830.84"}]
[null,"Tractor Trolley",null,1,{"v":4,"d":"4.00"},466.03,{"v":1864.12,"d":"1,864.12"}]
[]
[null,"Total Equipment / Machinery ( C )",{"$nulls":4},{"$f":"SUM(G75:G81)","v":{"v":52336.33,"d":"52,336.33"}}]
[null,"Summary"]
[]
[null,"Basic Cost For 72.00 CM ",{"$nulls":4},{"$f":"G62+G72+G83","v":{"v":572060.53,"d":"572,060.53"}}]
[null,"Basic Cost Per CM",{"$nulls":4},{"$f":"ROUND(G86/72,2)","v":{"v":7945.29,"d":"7,945.29"}},null,{"$f":"G87/35.315","v":{"v":224.98343480107604,"d":"224.98"}}]
[null,"Basic Cost Per CFT",{"$nulls":4},{"$f":"ROUND(G87/35.32,2)","v":224.95}]
[null,"OverHead & Profit (10 + 15)Percentage",{"$nulls":4},{"$f":"G88*0.25","v":{"v":56.2375,"d":"56.24"}}]
[null,"Total Cost Per CFT",{"$nulls":4},{"$f":"ROUND(SUM(G88:G89),2)","v":281.19}]
["ROYAL ORCHARD MULTAN"]
[{"$f":"A42","v":"CIVIL INFRASTRUCTURE WORKS"}]
[]
["RATE ANALYSIS"]
[null,"Concrete Class-A3 "]
[null,"Item # 401 a 3 (iii) ",{"$nulls":3},"Unit",{"v":72,"d":"72.00"},"CM"]
[null,"Item Desc.","Concrete Class-A3 (Elevated)Ratio 1:1.5:3 4000 PSI Cylinder Strength"]
[]
["A","Manpower"]
[null,"Description",null,"No.","Hours","Rate (Rs.)","Amount (Rs.)"]
[null,"Site Engineer",null,1,{"v":20,"d":"20.00"},267.07,{"$f":"D101*E101*F101","v":{"v":5341.4,"d":"5,341.40"}}]
[null,"Concrete Plant Engineer",null,1,{"v":4,"d":"4.00"},485.58,{"$f":"D102*E102*F102","v":{"v":1942.32,"d":"1,942.32"}}]
[null,"Forman Concrete",null,1,{"v":24,"d":"24.00"},{"v":150,"d":"150.00"},{"$f":"D103*E103*F103","v":{"v":3600,"d":"3,600.00"}}]
[null,"Supervisor",null,1,{"v":24,"d":"24.00"},169.95,{"$f":"D104*E104*F104","v":{"v":4078.7999999999997,"d":"4,078.80"}}]
[null,"Surveyor",null,1,{"v":20,"d":"20.00"},281.51,{"v":5630.2,"d":"5,630.20"}]
[null,"Assistant.Surveyor ",null,1,{"v":20,"d":"20.00"},106.83,{"v":2136.6,"d":"2,136.60"}]
[null,"Mason",null,8,{"v":8,"d":"8.00"},118.75,{"v":7600,"d":"7,600.00"}]
[null,"Carpenter",null,10,{"v":24,"d":"24.00"},{"v":125,"d":"125.00"},{"v":30000,"d":"30,000.00"}]
[null,"Helper",null,15,{"v":24,"d":"24.00"},{"v":62.5,"d":"62.50"},{"$f":"D109*E109*F109","v":{"v":22500,"d":"22,500.00"}}]
[null,"Labour",null,10,{"v":8,"d":"8.00"},{"v":62.5,"d":"62.50"},{"$f":"D110*E110*F110","v":{"v":5000,"d":"5,000.00"}}]
[]
[null,"Total  Manpower (A)",{"$nulls":4},{"$f":"SUM(G101:G110)","v":{"v":87829.31999999999,"d":"87,829.32"}}]
["B","Materials"]
[{"$nulls":3},"Unit","Quantity","Rate (Rs.)","Amount"]
[null,"Cement ",null,"Bag",{"$f":"(450/50)*72","v":{"v":648,"d":"648.00"}},{"v":535,"d":"535.00"},{"$f":"E115*F115","v":{"v":346680,"d":"346,680.00"}}]
[null,"Haro Sand",null,"Cft",{"$f":"16*72","v":{"v":1152,"d":"1152.00"}},{"v":25,"d":"25.00"},{"$f":"E116*F116","v":{"v":28800,"d":"28,800.00"}},null,{"$f":"E116/35.32","v":32.61608154020385}]
[null,"Crushed",null,"Cft",{"$f":"30*72","v":{"v":2160,"d":"2160.00"}},{"v":41,"d":"41.00"},{"v":88560,"d":"88,560.00"},null,{"$f":"E117/35.32","v":61.15515288788222}]
[null,"Admixture",null,"Ltr",{"$f":"6.75*72","v":{"v":486,"d":"486.00"}},{"v":72,"d":"72.00"},{"v":34992,"d":"34,992.00"}]
[null,"Water",null,"1000LIT",{"v":15,"d":"15.00"},{"v":120,"d":"120.00"},{"v":1800,"d":"1,800.00"}]
[null,"Shuttering (A)",null,"CM",{"v":72,"d":"72.00"},{"v":2474,"d":"2,474.00"},{"v":178128,"d":"178,128.00"}]
[]
[null,"Total Materials (B)",{"$nulls":4},{"$f":"SUM(G115:G120)","v":{"v":678960,"d":"678,960.00"}}]
["C","Equipment /Machinery"]
[{"$nulls":3},"No.","Hours","Rate (Rs.)","Amount (Rs.)"]
[null,"Front End Loader 1.50 Cu.m",null,1,{"v":2,"d":"2.00"},{"v":1364.75,"d":"1,364.75"},{"$f":"D125*E125*F125","v":{"v":2729.5,"d":"2,729.50"}}]
[null,"Water Tank Tow Type 12000 LTR.(INCLUDE.TRACTOR)",null,1,{"v":3,"d":"3.00"},{"v":1446.17,"d":"1,446.17"},{"v":4338.51,"d":"4,338.51"}]
[null,"Concrete Batching Plant.30 CUM/H",null,1,{"v":3,"d":"3.00"},{"v":600,"d":"600.00"},{"v":1800,"d":"1,800.00"}]
[null,"Concrete Transit mixer.6 Cu.m",null,6,{"v":4,"d":"4.00"},{"v":1605.14,"d":"1,605.14"},{"v":38523.36,"d":"38,523.36"}]
[null,"Pump 4'' Delivery (Diesel)",null,1,{"v":2,"d":"2.00"},{"v":625,"d":"625.00"},{"v":1250,"d":"1,250.00"}]
[null,"Vibrator (Pocker 1.5\")",null,2,{"v":6,"d":"6.00"},152.57,{"v":1830.84,"d":"1,830.84"}]
[null,"Tractor Trolley",null,1,{"v":4,"d":"4.00"},466.03,{"v":1864.12,"d":"1,864.12"}]
[]
[null,"Total Equipment / Machinery ( C )",{"$nulls":4},{"$f":"SUM(G125:G131)","v":{"v":52336.33,"d":"52,336.33"}}]
[null,"Summary"]
[]
[null,"Basic Cost For 72.00 CM ",{"$nulls":4},{"$f":"G112+G122+G133","v":{"v":819125.6499999999,"d":"819,125.65"}}]
[null,"Basic Cost Per CM",{"$nulls":4},{"$f":"ROUND(G136/72,2)","v":{"v":11376.75,"d":"11,376.75"}},null,{"$f":"G137/35.315","v":{"v":322.1506442021804,"d":"322.15"}}]
[null,"Basic Cost Per CFT",{"$nulls":4},{"$f":"ROUND(G137/35.32,2)","v":322.11}]
[null,"OverHead & Profit (10 + 15)Percentage",{"$nulls":4},{"$f":"G138*0.25","v":{"v":80.5275,"d":"80.53"}}]
[null,"Total Cost Per CFT",{"$nulls":4},{"$f":"ROUND(SUM(G138:G139),2)","v":402.64}]

{"sheet":"Conc","index":12,"n_rows":140,"n_cols":15,"rows_kept":140,"hidden":true,"merged":[[0,0,0,7],[6,2,6,5],[10,1,10,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[46,2,46,5],[50,1,50,2],[51,1,51,2],[52,1,52,2],[54,1,54,2],[55,1,55,2],[58,1,58,2],[59,1,59,2],[96,2,96,5],[100,1,100,2],[101,1,101,2],[102,1,102,2],[104,1,104,2],[105,1,105,2],[108,1,108,2],[109,1,109,2]]}
[{"$f":"+Shuttering!A1","v":"Etihad Town Phase-II, Lahore"}]
["CIVIL INFRASTRUCTURE WORKS"]
[]
["RATE ANALYSIS"]
[null,"Concrete for Drain"]
[null,"Item # 003",{"$nulls":3},"Unit",{"v":850,"d":"850.00"},"Cft",null,{"$f":"0.67+2+0.67","v":3.34},{"$f":"2+0.33+0.67","v":3},{"$f":"K6","v":3},{"$f":"0.67+2+0.67","v":3.34},{"$f":"SUM(J6:M6)","v":12.68},{"$f":"N6*100","v":1268}]
[null,"Item Desc.","Providing and Pouring Concrete for Drain ",{"$nulls":10},{"$f":"N6*0.67","v":8.4956}]
[{"$nulls":13},{"$f":"N7*100","v":849.56}]
["A","Manpower",{"$nulls":7},{"$f":"G6/2","v":425}]
[null,"Description",null,"No.","Hours","Rate (Rs.)","Amount (Rs.)"]
[null,"Supervisor",null,1,{"v":8,"d":"8.00"},134.23,{"$f":"D11*E11*F11","v":{"v":1073.84,"d":"1,073.84"}}]
[null,"Mason",null,4,{"v":8,"d":"8.00"},65.19,{"$f":"D12*E12*F12","v":{"v":2086.08,"d":"2,086.08"}}]
[null,"Labour",null,15,{"v":8,"d":"8.00"},65.19,{"v":7822.799999999999,"d":"7,822.80"}]
[]
[]
[]
[null,"Total  Manpower (A)",{"$nulls":4},{"$f":"SUM(G11:G15)","v":{"v":10982.72,"d":"10,982.72"}}]
["B","Materials"]
[{"$nulls":3},"Unit","Quantity","Rate (Rs.)","Amount"]
[null,"Special Tools",null,"Ls",{"v":1,"d":"1.00"},{"v":5500,"d":"5,500.00"},{"$f":"E20*F20","v":{"v":5500,"d":"5,500.00"}},null,{"v":1,"d":"1.00"},{"$f":"+I20*1.54","v":1.54}]
[{"$nulls":8},1,{"$f":"+(1/7)*J20","v":0.22},{"$f":"+J21*35.32","v":7.7704}]
[{"$nulls":8},2,{"$f":"+J21*2","v":0.44},{"$f":"+J22*35.32","v":15.5408}]
[{"$nulls":8},4,{"$f":"+J21*4","v":0.88},{"$f":"+J23*35.32","v":31.0816}]
[]
[]
[null,"Total Materials (B)",{"$nulls":4},{"$f":"SUM(G20:G24)","v":{"v":5500,"d":"5,500.00"}}]
["C","Equipment /Machinery"]
[{"$nulls":3},"No.","Hours","Rate (Rs.)","Amount (Rs.)"]
[null,"Tractor Trolley",null,1,{"v":6,"d":"6.00"},{"v":920,"d":"920.00"},{"$f":"D29*E29*F29","v":{"v":5520,"d":"5,520.00"}}]
[null,"Water Tank Bowser Type 12000 Ltr.",null,1,{"v":2,"d":"2.00"},{"v":1919.73,"d":"1,919.73"},{"$f":"D30*E30*F30","v":{"v":3839.46,"d":"3,839.46"}}]
[{"$nulls":9},"Water Tank Bowser Type 12000 Ltr."]
[]
[]
[null,"Total Equipment / Machinery ( C )",{"$nulls":4},{"$f":"SUM(G29:G32)","v":{"v":9359.46,"d":"9,359.46"}}]
[null,"Summary"]
[]
[null,"Basic Cost For 850 Cft.",{"$nulls":4},{"$f":"G17+G26+G34","v":{"v":25842.18,"d":"25,842.18"}}]
[null,"Basic Cost Per Cft.",{"$nulls":4},{"$f":"ROUND(G37/G6,2)","v":{"v":30.4,"d":"30.40"}}]
[null,"OverHead & Profit (15)Percentage",{"$nulls":4},{"$f":"G38*15%","v":4.56}]
[null,"Total Cost Per Cft.",{"$nulls":4},{"$f":"G38+G39","v":34.96}]
[{"$f":"A1","v":"Etihad Town Phase-II, Lahore"}]
[{"$f":"A2","v":"CIVIL INFRASTRUCTURE WORKS"}]
[]
["RATE ANALYSIS"]
[null,"Concrete Class-A1"]
[null,"Item # 401 a1 (i)",{"$nulls":3},"Unit",{"v":72,"d":"72.00"},"CM"]
[null,"Item Desc.","Concrete Class-A1 (Under Ground) Ratio 1:2:4 3000 PSI Cylinder Strength"]
[]
["A","Manpower"]
[null,"Description",null,"No.","Hours","Rate (Rs.)","Amount (Rs.)"]
[null,"Site Engineer",null,1,{"v":20,"d":"20.00"},267.07,{"$f":"D51*E51*F51","v":{"v":5341.4,"d":"5,341.40"}}]
[null,"Concrete Plant Engineer",null,1,{"v":4,"d":"4.00"},485.58,{"$f":"D52*E52*F52","v":{"v":1942.32,"d":"1,942.32"}}]
[null,"Forman Concrete",null,1,{"v":24,"d":"24.00"},{"v":150,"d":"150.00"},{"$f":"D53*E53*F53","v":{"v":3600,"d":"3,600.00"}}]
[null,"Supervisor",null,1,{"v":24,"d":"24.00"},169.95,{"$f":"D54*E54*F54","v":{"v":4078.7999999999997,"d":"4,078.80"}}]
[null,"Surveyor",null,1,{"v":20,"d":"20.00"},281.51,{"v":5630.2,"d":"5,630.20"}]
[null,"Assistant.Surveyor ",null,1,{"v":20,"d":"20.00"},106.83,{"v":2136.6,"d":"2,136.60"}]
[null,"Mason",null,8,{"v":8,"d":"8.00"},118.75,{"v":7600,"d":"7,600.00"}]
[null,"Carpenter",null,10,{"v":24,"d":"24.00"},{"v":125,"d":"125.00"},{"v":30000,"d":"30,000.00"}]
[null,"Helper",null,15,{"v":24,"d":"24.00"},{"v":62.5,"d":"62.50"},{"$f":"D59*E59*F59","v":{"v":22500,"d":"22,500.00"}}]
[null,"Labour",null,10,{"v":8,"d":"8.00"},{"v":62.5,"d":"62.50"},{"$f":"D60*E60*F60","v":{"v":5000,"d":"5,000.00"}}]
[]
[null,"Total  Manpower (A)",{"$nulls":4},{"$f":"SUM(G51:G60)","v":{"v":87829.31999999999,"d":"87,829.32"}}]
["B","Materials"]
[{"$nulls":3},"Unit","Quantity","Rate (Rs.)","Amount"]
[null,"Cement ",null,"Bag",{"$f":"(350/50)*72","v":{"v":504,"d":"504.00"}},{"v":535,"d":"535.00"},{"$f":"E65*F65","v":{"v":269640,"d":"269,640.00"}}]
[null,"Local Sand",null,"Cft",{"$f":"17*72","v":{"v":1224,"d":"1224.00"}},{"v":25,"d":"25.00"},{"$f":"E66*F66","v":{"v":30600,"d":"30,600.00"}},null,{"$f":"E66/35.32","v":34.65458663646659}]
[null,"Crushed",null,"Cft",{"$f":"32*72","v":{"v":2304,"d":"2304.00"}},{"v":41,"d":"41.00"},{"v":94464,"d":"94,464.00"},null,{"$f":"E67/35.32","v":65.2321630804077}]
[null,"Admixture",null,"Ltr",{"$f":"5.25*72","v":{"v":378,"d":"378.00"}},{"v":72,"d":"72.00"},{"v":27216,"d":"27,216.00"}]
[null,"Water",null,"1000LIT",15.45,{"v":120,"d":"120.00"},{"v":1854,"d":"1,854.00"}]
[null,"Shuttering (A)",null,"CM",{"v":72,"d":"72.00"},112.79,{"v":8120.88,"d":"8,120.88"}]
[]
[null,"Total Materials (B)",{"$nulls":4},{"$f":"SUM(G65:G70)","v":{"v":431894.88,"d":"431,894.88"}}]
["C","Equipment /Machinery"]
[{"$nulls":3},"No.","Hours","Rate (Rs.)","Amount (Rs.)"]
[null,"Front End Loader 1.50 Cu.m",null,1,{"v":2,"d":"2.00"},{"v":1364.75,"d":"1,364.75"},{"$f":"D75*E75*F75","v":{"v":2729.5,"d":"2,729.50"}}]
[null,"Water Tank Tow Type 12000 LTR.(INCLUDE.TRACTOR)",null,1,{"v":3,"d":"3.00"},{"v":1446.17,"d":"1,446.17"},{"v":4338.51,"d":"4,338.51"}]
[null,"Concrete Batching Plant.30 CUM/H",null,1,{"v":3,"d":"3.00"},{"v":600,"d":"600.00"},{"v":1800,"d":"1,800.00"}]
[null,"Concrete Transit mixer.6 Cu.m",null,6,{"v":4,"d":"4.00"},{"v":1605.14,"d":"1,605.14"},{"v":38523.36,"d":"38,523.36"}]
[null,"Pump 4'' Delivery (Diesel)",null,1,{"v":2,"d":"2.00"},{"v":625,"d":"625.00"},{"v":1250,"d":"1,250.00"}]
[null,"Vibrator (Pocker 1.5\")",null,2,{"v":6,"d":"6.00"},152.57,{"v":1830.84,"d":"1,830.84"}]
[null,"Tractor Trolley",null,1,{"v":4,"d":"4.00"},466.03,{"v":1864.12,"d":"1,864.12"}]
[]
[null,"Total Equipment / Machinery ( C )",{"$nulls":4},{"$f":"SUM(G75:G81)","v":{"v":52336.33,"d":"52,336.33"}}]
[null,"Summary"]
[]
[null,"Basic Cost For 72.00 CM ",{"$nulls":4},{"$f":"G62+G72+G83","v":{"v":572060.53,"d":"572,060.53"}}]
[null,"Basic Cost Per CM",{"$nulls":4},{"$f":"ROUND(G86/72,2)","v":{"v":7945.29,"d":"7,945.29"}},null,{"$f":"G87/35.315","v":{"v":224.98343480107604,"d":"224.98"}}]
[null,"Basic Cost Per CFT",{"$nulls":4},{"$f":"ROUND(G87/35.32,2)","v":224.95}]
[null,"OverHead & Profit (10 + 15)Percentage",{"$nulls":4},{"$f":"G88*0.25","v":{"v":56.2375,"d":"56.24"}}]
[null,"Total Cost Per CFT",{"$nulls":4},{"$f":"ROUND(SUM(G88:G89),2)","v":281.19}]
["ROYAL ORCHARD MULTAN"]
[{"$f":"A42","v":"CIVIL INFRASTRUCTURE WORKS"}]
[]
["RATE ANALYSIS"]
[null,"Concrete Class-A3 "]
[null,"Item # 401 a 3 (iii) ",{"$nulls":3},"Unit",{"v":72,"d":"72.00"},"CM"]
[null,"Item Desc.","Concrete Class-A3 (Elevated)Ratio 1:1.5:3 4000 PSI Cylinder Strength"]
[]
["A","Manpower"]
[null,"Description",null,"No.","Hours","Rate (Rs.)","Amount (Rs.)"]
[null,"Site Engineer",null,1,{"v":20,"d":"20.00"},267.07,{"$f":"D101*E101*F101","v":{"v":5341.4,"d":"5,341.40"}}]
[null,"Concrete Plant Engineer",null,1,{"v":4,"d":"4.00"},485.58,{"$f":"D102*E102*F102","v":{"v":1942.32,"d":"1,942.32"}}]
[null,"Forman Concrete",null,1,{"v":24,"d":"24.00"},{"v":150,"d":"150.00"},{"$f":"D103*E103*F103","v":{"v":3600,"d":"3,600.00"}}]
[null,"Supervisor",null,1,{"v":24,"d":"24.00"},169.95,{"$f":"D104*E104*F104","v":{"v":4078.7999999999997,"d":"4,078.80"}}]
[null,"Surveyor",null,1,{"v":20,"d":"20.00"},281.51,{"v":5630.2,"d":"5,630.20"}]
[null,"Assistant.Surveyor ",null,1,{"v":20,"d":"20.00"},106.83,{"v":2136.6,"d":"2,136.60"}]
[null,"Mason",null,8,{"v":8,"d":"8.00"},118.75,{"v":7600,"d":"7,600.00"}]
[null,"Carpenter",null,10,{"v":24,"d":"24.00"},{"v":125,"d":"125.00"},{"v":30000,"d":"30,000.00"}]
[null,"Helper",null,15,{"v":24,"d":"24.00"},{"v":62.5,"d":"62.50"},{"$f":"D109*E109*F109","v":{"v":22500,"d":"22,500.00"}}]
[null,"Labour",null,10,{"v":8,"d":"8.00"},{"v":62.5,"d":"62.50"},{"$f":"D110*E110*F110","v":{"v":5000,"d":"5,000.00"}}]
[]
[null,"Total  Manpower (A)",{"$nulls":4},{"$f":"SUM(G101:G110)","v":{"v":87829.31999999999,"d":"87,829.32"}}]
["B","Materials"]
[{"$nulls":3},"Unit","Quantity","Rate (Rs.)","Amount"]
[null,"Cement ",null,"Bag",{"$f":"(450/50)*72","v":{"v":648,"d":"648.00"}},{"v":535,"d":"535.00"},{"$f":"E115*F115","v":{"v":346680,"d":"346,680.00"}}]
[null,"Haro Sand",null,"Cft",{"$f":"16*72","v":{"v":1152,"d":"1152.00"}},{"v":25,"d":"25.00"},{"$f":"E116*F116","v":{"v":28800,"d":"28,800.00"}},null,{"$f":"E116/35.32","v":32.61608154020385}]
[null,"Crushed",null,"Cft",{"$f":"30*72","v":{"v":2160,"d":"2160.00"}},{"v":41,"d":"41.00"},{"v":88560,"d":"88,560.00"},null,{"$f":"E117/35.32","v":61.15515288788222}]
[null,"Admixture",null,"Ltr",{"$f":"6.75*72","v":{"v":486,"d":"486.00"}},{"v":72,"d":"72.00"},{"v":34992,"d":"34,992.00"}]
[null,"Water",null,"1000LIT",{"v":15,"d":"15.00"},{"v":120,"d":"120.00"},{"v":1800,"d":"1,800.00"}]
[null,"Shuttering (A)",null,"CM",{"v":72,"d":"72.00"},{"v":2474,"d":"2,474.00"},{"v":178128,"d":"178,128.00"}]
[]
[null,"Total Materials (B)",{"$nulls":4},{"$f":"SUM(G115:G120)","v":{"v":678960,"d":"678,960.00"}}]
["C","Equipment /Machinery"]
[{"$nulls":3},"No.","Hours","Rate (Rs.)","Amount (Rs.)"]
[null,"Front End Loader 1.50 Cu.m",null,1,{"v":2,"d":"2.00"},{"v":1364.75,"d":"1,364.75"},{"$f":"D125*E125*F125","v":{"v":2729.5,"d":"2,729.50"}}]
[null,"Water Tank Tow Type 12000 LTR.(INCLUDE.TRACTOR)",null,1,{"v":3,"d":"3.00"},{"v":1446.17,"d":"1,446.17"},{"v":4338.51,"d":"4,338.51"}]
[null,"Concrete Batching Plant.30 CUM/H",null,1,{"v":3,"d":"3.00"},{"v":600,"d":"600.00"},{"v":1800,"d":"1,800.00"}]
[null,"Concrete Transit mixer.6 Cu.m",null,6,{"v":4,"d":"4.00"},{"v":1605.14,"d":"1,605.14"},{"v":38523.36,"d":"38,523.36"}]
[null,"Pump 4'' Delivery (Diesel)",null,1,{"v":2,"d":"2.00"},{"v":625,"d":"625.00"},{"v":1250,"d":"1,250.00"}]
[null,"Vibrator (Pocker 1.5\")",null,2,{"v":6,"d":"6.00"},152.57,{"v":1830.84,"d":"1,830.84"}]
[null,"Tractor Trolley",null,1,{"v":4,"d":"4.00"},466.03,{"v":1864.12,"d":"1,864.12"}]
[]
[null,"Total Equipment / Machinery ( C )",{"$nulls":4},{"$f":"SUM(G125:G131)","v":{"v":52336.33,"d":"52,336.33"}}]
[null,"Summary"]
[]
[null,"Basic Cost For 72.00 CM ",{"$nulls":4},{"$f":"G112+G122+G133","v":{"v":819125.6499999999,"d":"819,125.65"}}]
[null,"Basic Cost Per CM",{"$nulls":4},{"$f":"ROUND(G136/72,2)","v":{"v":11376.75,"d":"11,376.75"}},null,{"$f":"G137/35.315","v":{"v":322.1506442021804,"d":"322.15"}}]
[null,"Basic Cost Per CFT",{"$nulls":4},{"$f":"ROUND(G137/35.32,2)","v":322.11}]
[null,"OverHead & Profit (10 + 15)Percentage",{"$nulls":4},{"$f":"G138*0.25","v":{"v":80.5275,"d":"80.53"}}]
[null,"Total Cost Per CFT",{"$nulls":4},{"$f":"ROUND(SUM(G138:G139),2)","v":402.64}]

{"sheet":"Bed Dressing","index":13,"n_rows":140,"n_cols":15,"rows_kept":140,"hidden":true,"merged":[[0,0,0,7],[6,2,6,5],[10,1,10,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[46,2,46,5],[50,1,50,2],[51,1,51,2],[52,1,52,2],[54,1,54,2],[55,1,55,2],[58,1,58,2],[59,1,59,2],[96,2,96,5],[100,1,100,2],[101,1,101,2],[102,1,102,2],[104,1,104,2],[105,1,105,2],[108,1,108,2],[109,1,109,2]]}
[{"$f":"+Conc!A1","v":"Etihad Town Phase-II, Lahore"}]
["CIVIL INFRASTRUCTURE WORKS"]
[]
["RATE ANALYSIS"]
[null,"Preparation of Drain Bed (Dressing)"]
[null,"Item # 003",{"$nulls":3},"Unit",{"v":900,"d":"900.00"},"Sft.",null,{"$f":"0.67+2+0.67","v":3.34},{"$f":"2+0.33+0.67","v":3},{"$f":"K6","v":3},{"$f":"0.67+2+0.67","v":3.34},{"$f":"SUM(J6:M6)","v":12.68},{"$f":"N6*100","v":1268}]
[null,"Item Desc.","Preparation of bed for construction of Drain",{"$nulls":10},{"$f":"N6*0.67","v":8.4956}]
[null,null,"Preparation of bed for construction of Drain",{"$nulls":10},{"$f":"N7*100","v":849.56}]
["A","Manpower",{"$nulls":7},{"$f":"G6/2","v":450}]
[null,"Description",null,"No.","Hours","Rate (Rs.)","Amount (Rs.)"]
[null,"Labour",null,2,{"v":8,"d":"8.00"},65.19,{"$f":"D11*E11*F11","v":{"v":1043.04,"d":"1,043.04"}}]
[]
[{"$nulls":11},{"$f":"2+0.67+0.67+0.5+0.5","v":4.34}]
[{"$nulls":11},{"$f":"L13*100","v":434}]
[]
[]
[null,"Total  Manpower (A)",{"$nulls":4},{"$f":"SUM(G11:G15)","v":{"v":1043.04,"d":"1,043.04"}}]
["B","Materials"]
[{"$nulls":3},"Unit","Quantity","Rate (Rs.)","Amount"]
[null,"Special Tools",null,"Ls",{"v":1,"d":"1.00"},{"v":1500,"d":"1,500.00"},{"$f":"E20*F20","v":{"v":1500,"d":"1,500.00"}},null,{"v":1,"d":"1.00"},{"$f":"+I20*1.54","v":1.54}]
[{"$nulls":8},1,{"$f":"+(1/7)*J20","v":0.22},{"$f":"+J21*35.32","v":7.7704}]
[{"$nulls":8},2,{"$f":"+J21*2","v":0.44},{"$f":"+J22*35.32","v":15.5408}]
[{"$nulls":8},4,{"$f":"+J21*4","v":0.88},{"$f":"+J23*35.32","v":31.0816}]
[]
[]
[null,"Total Materials (B)",{"$nulls":4},{"$f":"SUM(G20:G24)","v":{"v":1500,"d":"1,500.00"}}]
["C","Equipment /Machinery"]
[{"$nulls":3},"No.","Hours","Rate (Rs.)","Amount (Rs.)"]
[]
[]
[{"$nulls":9},"Water Tank Bowser Type 12000 Ltr."]
[]
[]
[null,"Total Equipment / Machinery ( C )",{"$nulls":4},{"$f":"SUM(G29:G32)","v":0}]
[null,"Summary"]
[]
[null,"Basic Cost For 900 Sft.",{"$nulls":4},{"$f":"G17+G26+G34","v":{"v":2543.04,"d":"2,543.04"}}]
[null,"Basic Cost Per Sft.",{"$nulls":4},{"$f":"ROUND(G37/G6,2)","v":2.83}]
[null,"OverHead & Profit (15)Percentage",{"$nulls":4},{"$f":"G38*15%","v":{"v":0.4245,"d":"0.42"}}]
[null,"Total Cost Per Sft.",{"$nulls":4},{"$f":"G38+G39","v":{"v":3.2545,"d":"3.25"}}]
[{"$f":"A1","v":"Etihad Town Phase-II, Lahore"}]
[{"$f":"A2","v":"CIVIL INFRASTRUCTURE WORKS"}]
[]
["RATE ANALYSIS"]
[null,"Concrete Class-A1"]
[null,"Item # 401 a1 (i)",{"$nulls":3},"Unit",{"v":72,"d":"72.00"},"CM"]
[null,"Item Desc.","Concrete Class-A1 (Under Ground) Ratio 1:2:4 3000 PSI Cylinder Strength"]
[]
["A","Manpower"]
[null,"Description",null,"No.","Hours","Rate (Rs.)","Amount (Rs.)"]
[null,"Site Engineer",null,1,{"v":20,"d":"20.00"},267.07,{"$f":"D51*E51*F51","v":{"v":5341.4,"d":"5,341.40"}}]
[null,"Concrete Plant Engineer",null,1,{"v":4,"d":"4.00"},485.58,{"$f":"D52*E52*F52","v":{"v":1942.32,"d":"1,942.32"}}]
[null,"Forman Concrete",null,1,{"v":24,"d":"24.00"},{"v":150,"d":"150.00"},{"$f":"D53*E53*F53","v":{"v":3600,"d":"3,600.00"}}]
[null,"Supervisor",null,1,{"v":24,"d":"24.00"},169.95,{"$f":"D54*E54*F54","v":{"v":4078.7999999999997,"d":"4,078.80"}}]
[null,"Surveyor",null,1,{"v":20,"d":"20.00"},281.51,{"v":5630.2,"d":"5,630.20"}]
[null,"Assistant.Surveyor ",null,1,{"v":20,"d":"20.00"},106.83,{"v":2136.6,"d":"2,136.60"}]
[null,"Mason",null,8,{"v":8,"d":"8.00"},118.75,{"v":7600,"d":"7,600.00"}]
[null,"Carpenter",null,10,{"v":24,"d":"24.00"},{"v":125,"d":"125.00"},{"v":30000,"d":"30,000.00"}]
[null,"Helper",null,15,{"v":24,"d":"24.00"},{"v":62.5,"d":"62.50"},{"$f":"D59*E59*F59","v":{"v":22500,"d":"22,500.00"}}]
[null,"Labour",null,10,{"v":8,"d":"8.00"},{"v":62.5,"d":"62.50"},{"$f":"D60*E60*F60","v":{"v":5000,"d":"5,000.00"}}]
[]
[null,"Total  Manpower (A)",{"$nulls":4},{"$f":"SUM(G51:G60)","v":{"v":87829.31999999999,"d":"87,829.32"}}]
["B","Materials"]
[{"$nulls":3},"Unit","Quantity","Rate (Rs.)","Amount"]
[null,"Cement ",null,"Bag",{"$f":"(350/50)*72","v":{"v":504,"d":"504.00"}},{"v":535,"d":"535.00"},{"$f":"E65*F65","v":{"v":269640,"d":"269,640.00"}}]
[null,"Local Sand",null,"Cft",{"$f":"17*72","v":{"v":1224,"d":"1224.00"}},{"v":25,"d":"25.00"},{"$f":"E66*F66","v":{"v":30600,"d":"30,600.00"}},null,{"$f":"E66/35.32","v":34.65458663646659}]
[null,"Crushed",null,"Cft",{"$f":"32*72","v":{"v":2304,"d":"2304.00"}},{"v":41,"d":"41.00"},{"v":94464,"d":"94,464.00"},null,{"$f":"E67/35.32","v":65.2321630804077}]
[null,"Admixture",null,"Ltr",{"$f":"5.25*72","v":{"v":378,"d":"378.00"}},{"v":72,"d":"72.00"},{"v":27216,"d":"27,216.00"}]
[null,"Water",null,"1000LIT",15.45,{"v":120,"d":"120.00"},{"v":1854,"d":"1,854.00"}]
[null,"Shuttering (A)",null,"CM",{"v":72,"d":"72.00"},112.79,{"v":8120.88,"d":"8,120.88"}]
[]
[null,"Total Materials (B)",{"$nulls":4},{"$f":"SUM(G65:G70)","v":{"v":431894.88,"d":"431,894.88"}}]
["C","Equipment /Machinery"]
[{"$nulls":3},"No.","Hours","Rate (Rs.)","Amount (Rs.)"]
[null,"Front End Loader 1.50 Cu.m",null,1,{"v":2,"d":"2.00"},{"v":1364.75,"d":"1,364.75"},{"$f":"D75*E75*F75","v":{"v":2729.5,"d":"2,729.50"}}]
[null,"Water Tank Tow Type 12000 LTR.(INCLUDE.TRACTOR)",null,1,{"v":3,"d":"3.00"},{"v":1446.17,"d":"1,446.17"},{"v":4338.51,"d":"4,338.51"}]
[null,"Concrete Batching Plant.30 CUM/H",null,1,{"v":3,"d":"3.00"},{"v":600,"d":"600.00"},{"v":1800,"d":"1,800.00"}]
[null,"Concrete Transit mixer.6 Cu.m",null,6,{"v":4,"d":"4.00"},{"v":1605.14,"d":"1,605.14"},{"v":38523.36,"d":"38,523.36"}]
[null,"Pump 4'' Delivery (Diesel)",null,1,{"v":2,"d":"2.00"},{"v":625,"d":"625.00"},{"v":1250,"d":"1,250.00"}]
[null,"Vibrator (Pocker 1.5\")",null,2,{"v":6,"d":"6.00"},152.57,{"v":1830.84,"d":"1,830.84"}]
[null,"Tractor Trolley",null,1,{"v":4,"d":"4.00"},466.03,{"v":1864.12,"d":"1,864.12"}]
[]
[null,"Total Equipment / Machinery ( C )",{"$nulls":4},{"$f":"SUM(G75:G81)","v":{"v":52336.33,"d":"52,336.33"}}]
[null,"Summary"]
[]
[null,"Basic Cost For 72.00 CM ",{"$nulls":4},{"$f":"G62+G72+G83","v":{"v":572060.53,"d":"572,060.53"}}]
[null,"Basic Cost Per CM",{"$nulls":4},{"$f":"ROUND(G86/72,2)","v":{"v":7945.29,"d":"7,945.29"}},null,{"$f":"G87/35.315","v":{"v":224.98343480107604,"d":"224.98"}}]
[null,"Basic Cost Per CFT",{"$nulls":4},{"$f":"ROUND(G87/35.32,2)","v":224.95}]
[null,"OverHead & Profit (10 + 15)Percentage",{"$nulls":4},{"$f":"G88*0.25","v":{"v":56.2375,"d":"56.24"}}]
[null,"Total Cost Per CFT",{"$nulls":4},{"$f":"ROUND(SUM(G88:G89),2)","v":281.19}]
["ROYAL ORCHARD MULTAN"]
[{"$f":"A42","v":"CIVIL INFRASTRUCTURE WORKS"}]
[]
["RATE ANALYSIS"]
[null,"Concrete Class-A3 "]
[null,"Item # 401 a 3 (iii) ",{"$nulls":3},"Unit",{"v":72,"d":"72.00"},"CM"]
[null,"Item Desc.","Concrete Class-A3 (Elevated)Ratio 1:1.5:3 4000 PSI Cylinder Strength"]
[]
["A","Manpower"]
[null,"Description",null,"No.","Hours","Rate (Rs.)","Amount (Rs.)"]
[null,"Site Engineer",null,1,{"v":20,"d":"20.00"},267.07,{"$f":"D101*E101*F101","v":{"v":5341.4,"d":"5,341.40"}}]
[null,"Concrete Plant Engineer",null,1,{"v":4,"d":"4.00"},485.58,{"$f":"D102*E102*F102","v":{"v":1942.32,"d":"1,942.32"}}]
[null,"Forman Concrete",null,1,{"v":24,"d":"24.00"},{"v":150,"d":"150.00"},{"$f":"D103*E103*F103","v":{"v":3600,"d":"3,600.00"}}]
[null,"Supervisor",null,1,{"v":24,"d":"24.00"},169.95,{"$f":"D104*E104*F104","v":{"v":4078.7999999999997,"d":"4,078.80"}}]
[null,"Surveyor",null,1,{"v":20,"d":"20.00"},281.51,{"v":5630.2,"d":"5,630.20"}]
[null,"Assistant.Surveyor ",null,1,{"v":20,"d":"20.00"},106.83,{"v":2136.6,"d":"2,136.60"}]
[null,"Mason",null,8,{"v":8,"d":"8.00"},118.75,{"v":7600,"d":"7,600.00"}]
[null,"Carpenter",null,10,{"v":24,"d":"24.00"},{"v":125,"d":"125.00"},{"v":30000,"d":"30,000.00"}]
[null,"Helper",null,15,{"v":24,"d":"24.00"},{"v":62.5,"d":"62.50"},{"$f":"D109*E109*F109","v":{"v":22500,"d":"22,500.00"}}]
[null,"Labour",null,10,{"v":8,"d":"8.00"},{"v":62.5,"d":"62.50"},{"$f":"D110*E110*F110","v":{"v":5000,"d":"5,000.00"}}]
[]
[null,"Total  Manpower (A)",{"$nulls":4},{"$f":"SUM(G101:G110)","v":{"v":87829.31999999999,"d":"87,829.32"}}]
["B","Materials"]
[{"$nulls":3},"Unit","Quantity","Rate (Rs.)","Amount"]
[null,"Cement ",null,"Bag",{"$f":"(450/50)*72","v":{"v":648,"d":"648.00"}},{"v":535,"d":"535.00"},{"$f":"E115*F115","v":{"v":346680,"d":"346,680.00"}}]
[null,"Haro Sand",null,"Cft",{"$f":"16*72","v":{"v":1152,"d":"1152.00"}},{"v":25,"d":"25.00"},{"$f":"E116*F116","v":{"v":28800,"d":"28,800.00"}},null,{"$f":"E116/35.32","v":32.61608154020385}]
[null,"Crushed",null,"Cft",{"$f":"30*72","v":{"v":2160,"d":"2160.00"}},{"v":41,"d":"41.00"},{"v":88560,"d":"88,560.00"},null,{"$f":"E117/35.32","v":61.15515288788222}]
[null,"Admixture",null,"Ltr",{"$f":"6.75*72","v":{"v":486,"d":"486.00"}},{"v":72,"d":"72.00"},{"v":34992,"d":"34,992.00"}]
[null,"Water",null,"1000LIT",{"v":15,"d":"15.00"},{"v":120,"d":"120.00"},{"v":1800,"d":"1,800.00"}]
[null,"Shuttering (A)",null,"CM",{"v":72,"d":"72.00"},{"v":2474,"d":"2,474.00"},{"v":178128,"d":"178,128.00"}]
[]
[null,"Total Materials (B)",{"$nulls":4},{"$f":"SUM(G115:G120)","v":{"v":678960,"d":"678,960.00"}}]
["C","Equipment /Machinery"]
[{"$nulls":3},"No.","Hours","Rate (Rs.)","Amount (Rs.)"]
[null,"Front End Loader 1.50 Cu.m",null,1,{"v":2,"d":"2.00"},{"v":1364.75,"d":"1,364.75"},{"$f":"D125*E125*F125","v":{"v":2729.5,"d":"2,729.50"}}]
[null,"Water Tank Tow Type 12000 LTR.(INCLUDE.TRACTOR)",null,1,{"v":3,"d":"3.00"},{"v":1446.17,"d":"1,446.17"},{"v":4338.51,"d":"4,338.51"}]
[null,"Concrete Batching Plant.30 CUM/H",null,1,{"v":3,"d":"3.00"},{"v":600,"d":"600.00"},{"v":1800,"d":"1,800.00"}]
[null,"Concrete Transit mixer.6 Cu.m",null,6,{"v":4,"d":"4.00"},{"v":1605.14,"d":"1,605.14"},{"v":38523.36,"d":"38,523.36"}]
[null,"Pump 4'' Delivery (Diesel)",null,1,{"v":2,"d":"2.00"},{"v":625,"d":"625.00"},{"v":1250,"d":"1,250.00"}]
[null,"Vibrator (Pocker 1.5\")",null,2,{"v":6,"d":"6.00"},152.57,{"v":1830.84,"d":"1,830.84"}]
[null,"Tractor Trolley",null,1,{"v":4,"d":"4.00"},466.03,{"v":1864.12,"d":"1,864.12"}]
[]
[null,"Total Equipment / Machinery ( C )",{"$nulls":4},{"$f":"SUM(G125:G131)","v":{"v":52336.33,"d":"52,336.33"}}]
[null,"Summary"]
[]
[null,"Basic Cost For 72.00 CM ",{"$nulls":4},{"$f":"G112+G122+G133","v":{"v":819125.6499999999,"d":"819,125.65"}}]
[null,"Basic Cost Per CM",{"$nulls":4},{"$f":"ROUND(G136/72,2)","v":{"v":11376.75,"d":"11,376.75"}},null,{"$f":"G137/35.315","v":{"v":322.1506442021804,"d":"322.15"}}]
[null,"Basic Cost Per CFT",{"$nulls":4},{"$f":"ROUND(G137/35.32,2)","v":322.11}]
[null,"OverHead & Profit (10 + 15)Percentage",{"$nulls":4},{"$f":"G138*0.25","v":{"v":80.5275,"d":"80.53"}}]
[null,"Total Cost Per CFT",{"$nulls":4},{"$f":"ROUND(SUM(G138:G139),2)","v":402.64}]