{"text_format":"3","workbook":"xlsx","n_sheets":29,"sheets":["Main Summary","Variation","Abstract of Cost","1.Dism of Road","8. Raising MH","11.Str Exc..","13 GG","14 PCC","1.Dismantling PCC","2.Sub Base","3 Dry Rammed","4. Stone Ballast","5. Brickwork","6. Plaster","7.Pointing","8. PCC148 ","9. Steel R","9. Steel M","10. RCC ","11.UPVC","12 RCC Cover","Analysis Rcc cover 6\"","13.RCC Pipe 9\"","14. Select Fill","15.Desilting","16. theremopore","17. Bailing","18.Marble Strip","Dis of Pcc Analysis"],"not_rendered":{"external_links":145,"defined_names":7164},"read":"whole","date_system":"1900"}

{"sheet":"Main Summary","index":0,"n_rows":52,"n_cols":6,"rows_kept":52,"merged":[[0,0,0,5],[1,0,1,5],[2,2,2,3],[2,4,2,5],[3,0,3,5],[32,4,32,5]]}
["PROJECT NAME"]
["INTERIM PAYMENT CERTIFICATE NO. "]
[null,"Contractor:","Client : ",null,"Consultant: "]
["ABSTRACT OF COST/MAIN SUMMARY"]
["Sr. No.","Item Description","B.O.Q.  Amount\n(Rs.)","Previous Amount\n(Rs.)","This Bill  Amount (Rs.)","Upto Date Amount\n(Rs.)"]
[null,"BOQ Amount =",{"$f":"'Abstract of Cost'!F27","v":{"v":47619049.111169204,"d":"47,619,049"}},{"$f":"'Abstract of Cost'!H27","v":{"v":1698064.7276418,"d":"1,698,065"}},{"$f":"'Abstract of Cost'!J27","v":{"v":7427019.876824992,"d":"7,427,020"}},{"$f":"D6+E6","v":{"v":9125084.604466792,"d":"9,125,085"}}]
["A","TOTAL Total",{"$f":"SUM(C6:C6)","v":{"v":47619049.111169204,"d":"47,619,049"}},{"$f":"SUM(D6:D6)","v":{"v":1698064.7276418,"d":"1,698,065"}},{"$f":"SUM(E6:E6)","v":{"v":7427019.876824992,"d":"7,427,020"}},{"$f":"SUM(F6:F6)","v":{"v":9125084.604466792,"d":"9,125,085"}}]
["B","Add All Items  4.20% Above T.S",{"$f":"C7*4.2%","v":{"v":2000000.0626691068,"d":"2,000,000"}},{"$f":"D7*4.2%","v":{"v":71318.7185609556,"d":"71,319"}},{"v":311934.8348266497,"d":"311,935"},{"$f":"D8+E8","v":{"v":383253.5533876053,"d":"383,254"}}]
["C","Net  BOQ Amount (C= A+B) =",{"$f":"SUM(C7:C8)","v":{"v":49619049.17383831,"d":"49,619,049"}},{"$f":"SUM(D7:D8)","v":{"v":1769383.4462027554,"d":"1,769,383"}},{"$f":"SUM(E7:E8)","v":{"v":7738954.711651642,"d":"7,738,955"}},{"v":9508338.157854397,"d":"9,508,338"}]
["D","Non BOQ Amount =",null,{"$f":"'Abstract of Cost'!H67","v":{"v":28602574.45344519,"d":"28,602,574"}},{"$f":"'Abstract of Cost'!J67","v":{"v":5357336.363133525,"d":"5,357,336"}},{"v":33959910.816578716,"d":"33,959,911"}]
["F","Total Amount (F= C+ D+E)",{"$f":"SUM(C9:C10)","v":{"v":49619049.17383831,"d":"49,619,049"}},{"$f":"D9+D10","v":{"v":30371957.899647944,"d":"30,371,958"}},{"$f":"E9+E10","v":{"v":13096291.074785165,"d":"13,096,291"}},{"v":43468248.97443311,"d":"43,468,249"}]
["G","ADD 5 % PST ON (F) =",{"$f":"C11*5%","v":{"v":2480952.4586919155,"d":"2,480,952.46"}},{"$f":"D11*5%","v":{"v":1518597.8949823973,"d":"1,518,598"}},{"$f":"E11*5%","v":{"v":654814.5537392583,"d":"654,815"}},{"$f":"F11*5%","v":{"v":2173412.4487216556,"d":"2,173,412"}}]
["H","Total Amount Rs. (H= F+G)",{"$f":"SUM(C11:C12)-1","v":{"v":52100000.63253023,"d":"52,100,001"}},{"$f":"SUM(D11:D12)","v":{"v":31890555.79463034,"d":"31,890,556"}},{"$f":"SUM(E11:E12)","v":{"v":13751105.628524425,"d":"13,751,106"}},{"v":45641661.423154764,"d":"45,641,661"}]
[null,"Deductions"]
[1," Secured Advance"]
[2,"Retention money @10% on 5 million"]
[3,"5% remaining amount"]
[4,"D/d of 5% PST"]
[5,"D/d of 8 % Income Tax"]
["I","Total Deductions"]
["J","Net Payable Amount (J= H-I)"]
[]
[]
[]
[]
[]
[]
["Project  Manager:________________",{"$nulls":3},"Resident Engineer:______________"]
["Contractor.",{"$nulls":3},"Consultant."]
{"$rows_empty":22}
[{"$nulls":4},16740.9]

{"sheet":"Variation","index":1,"n_rows":19,"n_cols":12,"rows_kept":19,"merged":[[0,1,0,7],[1,0,1,7],[2,0,2,7],[3,0,3,7],[4,0,6,0],[4,1,6,1],[4,2,6,2],[4,3,5,5],[4,6,5,6],[4,7,5,7],[14,1,14,6],[15,0,15,7],[16,0,16,1],[16,5,16,7],[17,0,17,1],[17,5,17,7],[18,0,18,1],[18,5,18,7]]}
["Subject: ",{"$f":"'Main Summary'!A1","v":"PROJECT NAME"}]
["Contractor:- "]
["Abstract of Quantity & Cost"]
["Variation # 3"]
["Item No","Description of items","Unit","Qty",null,null,"Contractor","Amount"]
[]
[{"$nulls":3}," As per TS ","Up to Date Qty.","Variation","Rate","(Rs.)"]
[null,"BOQ Items"]
["VO",{"$f":"'Abstract of Cost'!B16","v":"Raising of manhole i/c C.I Ring "},{"$f":"'Abstract of Cost'!C16","v":"Nos"},{"$f":"'Abstract of Cost'!D16","v":56},{"$f":"'Abstract of Cost'!K16","v":{"v":64,"d":"64.00"}},{"$f":"E9-D9","v":{"v":8,"d":"8.00"}},{"$f":"'Abstract of Cost'!E16","v":{"v":12056.13,"d":"12,056.13"}},{"$f":"G9*F9/1","v":{"v":96449.04,"d":"96,449"}}]
["VO",{"$f":"'Abstract of Cost'!B25","v":"P/L PCC1:2:4"},{"$f":"'Abstract of Cost'!C25","v":"%Cft"},{"$f":"'Abstract of Cost'!D25","v":149.71},{"$f":"'Abstract of Cost'!K25","v":{"v":13065.000875000002,"d":"13,065.00"}},{"$f":"E10-D10","v":{"v":12915.290875000002,"d":"12,915.29"}},{"$f":"'Abstract of Cost'!E25","v":{"v":58636.2,"d":"58,636.20"}},{"$f":"G10*F10/100","v":{"v":7573035.788046751,"d":"7,573,036"}}]
[null,{"$f":"'Abstract of Cost'!A28","v":"Non BOQ ITEMS"}]
["VO",{"$f":"'Abstract of Cost'!B29","v":"Dismantling of PCC 1:2:4 including its removal from site"},{"$f":"'Abstract of Cost'!C29","v":"%Cft"},{"$f":"'Abstract of Cost'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Abstract of Cost'!K29","v":{"v":18319.71234101333,"d":"18,319.71"}},{"$f":"E12-D12","v":{"v":18319.71234101333,"d":"18,319.71"}},{"$f":"'Abstract of Cost'!E29","v":{"v":16519.3,"d":"16,519.30"}},{"$f":"G12*F12/100","v":{"v":3026288.240749015,"d":"3,026,288"}}]
["VO",{"$f":"'Abstract of Cost'!B31","v":"Providing and laying sub-base course of stone product of approved quality and grade including placing, mixing, spreading and compaction of sub-base material to required depth, camber, grade to achieve 100% maximum modified AASHO dry density, including carriage of all material to site of work except gravel and aggregate."},{"$f":"'Abstract of Cost'!C31","v":"% Cft"},{"$f":"'Abstract of Cost'!D31","v":0},{"$f":"'Abstract of Cost'!K31","v":{"v":18963.70980668534,"d":"18,963.71"}},{"$f":"E13-D13","v":{"v":18963.70980668534,"d":"18,963.71"}},{"$f":"'Abstract of Cost'!E31","v":{"v":24249.21,"d":"24,249.21"}},{"$f":"G13*F13/100","v":{"v":4598549.814813722,"d":"4,598,550"}}]
["VO",{"$f":"'Abstract of Cost'!B54","v":"Providing and fixing, 6\" (150 mm) thick R.C.C. manhole cover for  22\" as per standard drawing STD/PD No. 6 of 1977, complete in all respects.  I/C FRAME COMPLETE IN \nALL RESPECT"},{"$f":"'Abstract of Cost'!C54","v":"Per Set"},{"$f":"'Abstract of Cost'!D54","v":0},{"$f":"'Abstract of Cost'!K54","v":{"v":28,"d":"28.00"}},{"$f":"E14-D14","v":{"v":28,"d":"28.00"}},{"$f":"'Abstract of Cost'!E54","v":{"v":16257.15,"d":"16,257.15"}},{"$f":"G14*F14/1","v":{"v":455200.2,"d":"455,200"}}]
[{"$nulls":7},{"$f":"SUM(H9:H14)","v":{"v":15749523.083609488,"d":"15,749,523"}},{"$nulls":3},{"v":49267271.3570649,"d":"49,267,271"}]
[]
[]
["QS Contractor",{"$nulls":4},"Residant Engineer"]
["Contractor",{"$nulls":4},"Consultant"]

{"sheet":"Abstract of Cost","index":2,"n_rows":543,"n_cols":18,"rows_kept":543,"merged":[[0,0,0,11],[1,2,1,8],[1,9,1,11],[2,0,2,11],[3,0,3,11],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,4,5],[4,6,4,7],[4,8,4,9],[4,10,4,11],[6,0,6,5],[26,0,26,4],[27,0,27,11],[66,0,66,4],[228,2,228,3]]}
[{"$f":"+Variation!B1","v":"PROJECT NAME"}]
[null,"Contractor:- ","Client :- ",{"$nulls":6},"Consultant: "]
["INTERIM PAYMENT CERTIFICATE NO. "]
["ABSTRACT OF COST"]
["Sr. No. ","Description of items","Unit","As Per T.S ",null,null,"Previous Bill",null,"This Bill",null,"Up to Date"]
[{"$nulls":3},"Quantity ","Rate","Amount (Rs.)","Quantity ","Amount (Rs.)","Quantity ","Amount (Rs.)","Quantity","Amount (Rs.)"]
["BOQ ITEMS"]
[1,"Dismantling of road metling i/c removal from site","%Cft",{"v":19262.2,"d":"19,262.20"},{"v":4023.91,"d":"4,023.91"},{"$f":"D8*E8/100","v":{"v":775093.5920200001,"d":"775,094"}},{"v":1917.25,"d":"1,917.25"},null,{"$f":"'1.Dism of Road'!M15","v":{"v":-8.303147306666915,"d":"(8.30)"}},null,{"$f":"G8+I8","v":{"v":1908.946852693333,"d":"1,908.95"}}]
[null,"Reduce Rate @ 97 %",null,null,{"$f":"E8*97%","v":{"v":3903.1926999999996,"d":"3,903.19"}},null,null,{"v":73290.99375124999,"d":"73,291"},null,{"$f":"L9-H9","v":{"v":1218.8804499559337,"d":"1,219"}},null,{"$f":"K8*E9/100","v":{"v":74509.87420120592,"d":"74,510"}}]
[{"$f":"A8+1","v":2},"Regular excavation i/c removal from site","%0Cft",{"v":4834.06,"d":"4,834.06"},{"v":18142.3,"d":"18,142.30"},{"$f":"D10*E10/1000","v":{"v":87700.966738,"d":"87,701"}},0,0,null,{"$f":"I10*E10/1000","v":0},{"$f":"I10","v":0},{"$f":"J10","v":0}]
[{"$f":"A10+1","v":3},"Providing and laying road edging of 3\" (75 mm) wide and 9\" (225 mm) deep brick on end,complete in all respects","Rft",{"v":9668.12,"d":"9,668.12"},{"v":72.2,"d":"72.20"},{"$f":"D11*E11/1","v":{"v":698038.2640000001,"d":"698,038"}},0,0,null,{"$f":"I11*E11/100","v":0},{"$f":"I11","v":0},{"$f":"J11","v":0}]
[4,"Providing and laying Base course of stone product of  approved quality and grade, including placing, mixing, spreading and compaction of  sub-base material  to required depth, camber, grade to achieve 100% maximum modified AASHTO dry density, including carriage of all material to site of work except gravel and aggregate.","%Cft",{"v":57837.94,"d":"57,837.94"},{"v":32366.2,"d":"32,366.20"},{"$f":"D12*E12/100","v":{"v":18719943.33628,"d":"18,719,943"}}]
[5,"Providing and laying bituminous priming coat , using 10 lbs. kerosene oil and 10 lbs.binder per 100 Sft. or 0.5 Kg","%sft",{"v":115675.88,"d":"115,675.88"},{"v":2198.6,"d":"2,198.60"},{"$f":"D13*E13/100","v":{"v":2543249.89768,"d":"2,543,250"}},0,0,null,{"$f":"E13*I13","v":0},{"$f":"I13","v":0},0]
[6,"Providing and laying bituminous tack coat , using 10 lbs. of bitumen per 100 Sf t (0.49 Kg of bitumen per sq.m.)","%sft",{"v":12424.89,"d":"12,424.89"},{"v":1172.85,"d":"1,172.85"},{"$f":"D14*E14/100","v":{"v":145725.322365,"d":"145,725"}},0,0,null,{"$f":"E14*I14","v":0},0,0]
[7,"P/L 2\" thick plant mixed Carpeting using 4.5% bitumen content","%sft",{"v":128100.78,"d":"128,100.78"},{"v":17480.7,"d":"17,480.70"},{"$f":"D15*E15/100","v":{"v":22392913.04946,"d":"22,392,913"}},0,0,null,{"$f":"I15*E15/100","v":0},0,0]
[8,"Raising of manhole i/c C.I Ring ","Nos",{"v":56,"d":"56.00"},{"v":12056.13,"d":"12,056.13"},{"$f":"D16*E16","v":{"v":675143.2799999999,"d":"675,143"}},{"$f":"'8. Raising MH'!M9","v":0},0,{"$f":"'8. Raising MH'!M10","v":{"v":64,"d":"64.00"}},null,{"$f":"I16+G16","v":{"v":64,"d":"64.00"}}]
[null,"Reduce Rate @ 95 %",null,null,{"$f":"E16*95%","v":{"v":11453.323499999999,"d":"11,453.32"}},null,null,{"$f":"G16*E17/100","v":0},null,{"$f":"L17-H17","v":{"v":733012.7039999999,"d":"733,013"}},null,{"$f":"K16*E17/1","v":{"v":733012.7039999999,"d":"733,013"}}]
[{"$f":"A16+1","v":9},"Painting Traffic Lane Marking of specified width (1.5mm thick),with Thermoplastic (TP)Paint including Glass Beads, complete in all respect, as approved and directed by Engineer incharge 5\" wide","Rft",{"v":11228.12,"d":"11,228.12"},47.85,{"$f":"D18*E18","v":{"v":537265.542,"d":"537,266"}},0,null,null,{"$f":"I18*E18","v":0},{"$f":"I18","v":0}]
[10,"Providing & fixing Cat Eyes of size 4\" x 4\" x 3/4\" duly casted with specified material having plastic strip containing mini retro-reflective glass beads of color white/red/yellow having specifid reflections, quality & shape i/c the cost of self built in 1","Nos",{"v":936,"d":"936.00"},509.65,{"$f":"D19*E19","v":{"v":477032.39999999997,"d":"477,032"}},0,null,null,{"$f":"I19*E19","v":0},{"$f":"I19","v":0}]
[11,"Structure excavation for sewer i/c removal from site","%0Cft",299.42,{"v":17913.61,"d":"17,913.61"},{"$f":"D20*E20/1000","v":{"v":5363.6931062,"d":"5,364"}},{"v":2812.9,"d":"2,812.90"},null,{"$f":"'11.Str Exc..'!L13","v":{"v":-0.4450000000001637,"d":"(0.45)"}},null,{"$f":"I20+G20","v":{"v":2812.455,"d":"2,812.46"}}]
[null,"Reduce Rate @ 97 %",null,null,{"$f":"E20*97%","v":{"v":17376.2017,"d":"17,376.20"}},null,null,{"v":47869.73389054999,"d":"47,870"},null,{"$f":"L21-H21","v":{"v":1000.0514616235087,"d":"1,000"}},null,{"$f":"K20*E21/1000","v":{"v":48869.7853521735,"d":"48,870"}}]
[{"$f":"A20+1","v":12},"Providing, fixing, testing and commissioning of μ-PV C (Unpl asticized Polyvinyl Chloride )Nikasi/ wast e pipe make of Dadex /Popular/Beta or equivalent, plain / socket ended conforming to code EN-1329 of specified SDR (St andard Dimensi on Ratio) includi","Rft",149.71,463.75,{"$f":"D22*E22/1","v":{"v":69428.0125,"d":"69,428"}},0,null,null,{"$f":"I22*E22/100","v":0},0]
[13,"Constructed standered gully grating chamber, 3'x2.5' (900x750 m) complete in all respect (b) concrete Gully trap","Nos",{"v":19,"d":"19.00"},{"v":21282.5,"d":"21,282.50"},{"$f":"D23*E23/1","v":{"v":404367.5,"d":"404,368"}},{"v":40,"d":"40.00"},null,{"$f":"'13 GG'!M11","v":{"v":8,"d":"8.00"}},null,{"$f":"G23+I23","v":{"v":48,"d":"48.00"}}]
[null,"Reduce Rate @ 97 %",null,null,{"$f":"E23*97%","v":{"v":20644.024999999998,"d":"20,644.03"}},null,null,{"v":808735,"d":"808,735"},null,{"$f":"L24-H24","v":{"v":182178.19999999995,"d":"182,178"}},null,{"$f":"K23*E24","v":{"v":990913.2,"d":"990,913"}},{"$f":"K23*E23*95%","v":{"v":970482,"d":"970,482"}}]
[{"$f":"A23+1","v":14},"P/L PCC1:2:4","%Cft",149.71,{"v":58636.2,"d":"58,636.20"},{"$f":"D25*E25/100","v":{"v":87784.25502,"d":"87,784"}},{"v":1379.0118749999997,"d":"1,379.01"},0,{"$f":"'14 PCC'!M32","v":{"v":11685.989000000001,"d":"11,685.99"}},null,{"$f":"I25+G25","v":{"v":13065.000875000002,"d":"13,065.00"}}]
[null,"Reduce Rate @ 95 %",null,null,{"$f":"E25*95%","v":{"v":55704.38999999999,"d":"55,704.39"}},null,null,{"v":768169,"d":"768,169.00"},null,{"$f":"L26-H26","v":{"v":6509610.040913412,"d":"6,509,610"}},null,{"$f":"K25*E26/100","v":{"v":7277779.040913412,"d":"7,277,779"}},{"$f":"J26+H26","v":{"v":7277779.040913412,"d":"7,277,779"}}]
["Total BOQ ITEMS",{"$nulls":4},{"$f":"SUM(F8:F26)","v":{"v":47619049.111169204,"d":"47,619,049"}},null,{"$f":"SUM(H8:H26)","v":{"v":1698064.7276418,"d":"1,698,065"}},null,{"$f":"SUM(J8:J26)","v":{"v":7427019.876824992,"d":"7,427,020"}},null,{"$f":"SUM(L8:L26)","v":{"v":9125084.604466792,"d":"9,125,085"}},{"$f":"J27+H27","v":{"v":9125084.604466792,"d":"9,125,085"}}]
["Non BOQ ITEMS",{"$nulls":15},{"$f":"F27*4.2%","v":{"v":2000000.0626691068,"d":"2,000,000.06"}},{"$f":"F27*5%","v":{"v":2380952.45555846,"d":"2,380,952.46"}}]
[1,"Dismantling of PCC 1:2:4 including its removal from site","%Cft",{"v":0,"d":"0.00"},{"v":16519.3,"d":"16,519.30"},{"$f":"D29*E29/100","v":0},{"v":6919.932341013331,"d":"6,919.93"},null,{"$f":"'1.Dismantling PCC'!M61","v":{"v":11399.78,"d":"11,399.78"}},null,{"$f":"I29+G29","v":{"v":18319.71234101333,"d":"18,319.71"}},{"$nulls":5},{"$f":"#REF!+#REF!+#REF!","v":{"$error":"#REF!"}}]
[null,"Reduce Rate @ 97 %",null,null,{"$f":"E29*97%","v":{"v":16023.721,"d":"16,023.72"}},null,null,{"v":1028811.9448881135,"d":"1,028,812"},null,{"$f":"L30-H30","v":{"v":1906687.648638431,"d":"1,906,688"}},null,{"$f":"K29*E30/100","v":{"v":2935499.5935265445,"d":"2,935,500"}}]
[2,"Providing and laying sub-base course of stone product of approved quality and grade including placing, mixing, spreading and compaction of sub-base material to required depth, camber, grade to achieve 100% maximum modified AASHO dry density, including carriage of all material to site of work except gravel and aggregate.","% Cft",{"v":0,"d":"0.00"},{"v":24249.21,"d":"24,249.21"},{"$f":"D31*E31/100","v":0},{"v":10037.139056685342,"d":"10,037.14"},null,{"$f":"'2.Sub Base'!O23","v":{"v":8926.570749999997,"d":"8,926.57"}},null,{"$f":"I31+G31","v":{"v":18963.70980668534,"d":"18,963.71"}},null,{"$f":"K31*E32/100","v":{"v":4460593.32036931,"d":"4,460,593"}}]
[null,"Reduce Rate @ 97 %",null,null,{"$f":"E31*97%","v":{"v":23521.733699999997,"d":"23,521.73"}},null,null,{"v":2312230.581455265,"d":"2,312,231"},null,{"$f":"L32-H32","v":{"v":2148362.7389140446,"d":"2,148,363"}},null,{"$f":"K31*E32/100","v":{"v":4460593.32036931,"d":"4,460,593"}}]
[{"$f":"A31+1","v":3},"Dry rammed brick ballast 1.5\" to 2\" gauge  Ch. 6 Page 41 item 2","% Cft",{"v":0,"d":"0.00"},{"v":12144,"d":"12,144.00"},{"$f":"D33*E33/100","v":0},230.79,null,{"$f":"'3 Dry Rammed'!K10","v":0},null,{"$f":"I33+G33","v":230.79},null,{"$f":"K33*E34/100","v":{"v":27186.323472000004,"d":"27,186"}}]
[null,"Reduce Rate @ 97 %",null,null,{"$f":"E33*97%","v":{"v":11779.68,"d":"11,779.68"}},null,null,{"v":26625.780719999995,"d":"26,626"},null,{"$f":"L34-H34","v":{"v":560.5427520000085,"d":"561"}},null,{"$f":"K33*E34/100","v":{"v":27186.323472000004,"d":"27,186"}}]
[{"$f":"A33+1","v":4},"Cement concrete brick or stone  ballast 1.5\" to 2\" gauge, in foundation and plinth ( 1 : 6 : 12) Ch. 6 Page 41 item 3","100 Cft",null,{"v":28201.8,"d":"28,201.80"},null,127.17,null,{"$f":"'4. Stone Ballast'!K11","v":0},null,{"$f":"I35+G35","v":127.17},null,{"$f":"K35*E36/100","v":{"v":34788.3021882,"d":"34,788"}}]
[null,"Reduce Rate @ 97 %",null,null,{"$f":"E35*97%","v":{"v":27355.746,"d":"27,355.75"}},null,null,{"v":34071.017607,"d":"34,071"},null,{"$f":"L36-H36","v":{"v":717.2845812000014,"d":"717"}},null,{"$f":"K35*E36/100","v":{"v":34788.3021882,"d":"34,788"}}]
[{"$f":"A35+1","v":5},"Pacca brick work other than building upto 10ft. (3 m) height. i) cement, sand mortar:- Ratio 1:3 + Extra for pacca brick work in steining of wells or any other circular masonry.(Rs.43,862.40 + Rs.3,707.30).","% Cft",{"v":0,"d":"0.00"},{"$f":"43862.4+3707.3","v":{"v":47569.700000000004,"d":"47,569.70"}},null,{"v":968.147859375,"d":"968"},null,{"$f":"'5. Brickwork'!J14","v":0},null,{"$f":"I37+G37","v":{"v":968.147859375,"d":"968.15"}}]
[null,"Reduce Rate @ 97 %",null,null,{"$f":"E37*97%","v":{"v":46142.609000000004,"d":"46,142.61"}},null,null,{"v":414490.5290349985,"d":"414,491"},null,{"$f":"L38-H38","v":{"v":32238.152258277696,"d":"32,238"}},null,{"$f":"K37*E38/100","v":{"v":446728.6812932762,"d":"446,729"}}]
[{"$f":"A37+1","v":6},"Cement plaster 1:3 upto 20' (6.00 m) height:-b) ½\" (13 mm) thick","% Sft",{"v":0,"d":"0.00"},{"v":4617.95,"d":"4,617.95"},{"$f":"D39*E39/100","v":0},{"v":1505.0746125,"d":"1,505"},null,{"$f":"'6. Plaster'!J14","v":0},null,{"$f":"I39+G39","v":{"v":1505.0746125,"d":"1,505.07"}}]
[null,"Reduce Rate @ 97 %",null,null,{"$f":"E39*97%","v":{"v":4479.411499999999,"d":"4,479.41"}},null,null,{"v":62553.23376114937,"d":"62,553"},null,{"$f":"L40-H40","v":{"v":4865.2515147560625,"d":"4,865"}},null,{"$f":"K39*E40/100","v":{"v":67418.48527590543,"d":"67,418"}}]
[{"$f":"A39+1","v":7},"Cement pointing flush upto 20' height  in (1:2) Ch. 11 Page 76 item 16","% Sft",{"v":0,"d":"0.00"},{"v":4310.75,"d":"4,310.75"},{"$f":"E41*D41/100","v":0},{"v":1076.6530124999997,"d":"1076.65"},null,{"$f":"'7.Pointing'!J13","v":0},null,{"$f":"I41+G41","v":{"v":1076.6530124999997,"d":"1,076.65"}}]
[null,"Reduce Rate @ 97 %",null,null,{"$f":"E41*97%","v":{"v":4181.4275,"d":"4,181.43"}},null,null,{"v":41770.63776270937,"d":"41,771"},null,{"$f":"L42-H42","v":{"v":3248.8273815440552,"d":"3,249"}},null,{"$f":"K41*E42/100","v":{"v":45019.46514425342,"d":"45,019"}}]
[{"$f":"A41+1","v":8},"Cement concrete plain including placing , compacting finishing and curing complete ( including washing of stone aggregate) Ch. 6 Page 2 item 5) (1:4:8)","% Cft",{"v":0,"d":"0.00"},{"v":48485.4,"d":"48,485.40"},{"$f":"E43*D43/100","v":0},{"v":4320.377663,"d":"4320.38"},null,{"$f":"'8. PCC148 '!J22","v":0},null,{"$f":"I43+G43","v":{"v":4320.377663,"d":"4,320.38"}}]
[null,"Reduce Rate @ 97 %",null,null,{"$f":"E43*97%","v":{"v":47030.838,"d":"47,030.84"}},null,null,{"v":1885277.5,"d":"1,885,278"},null,{"$f":"L44-H44","v":{"v":146632.3196737161,"d":"146,632"}},null,{"$f":"K43*E44/100","v":{"v":2031909.819673716,"d":"2,031,910"}}]
[{"$f":"A43+1","v":9},"Fabrication of mild steel  reinforcement for cement concrete , including cutting ,bending laying in position,  making joints, and fastening including the cost of binding wire and labour charges for binding of steel reinforcement (also includes removal of ","% Kg",{"v":0,"d":"0.00"},{"v":35224.5,"d":"35,224.50"},0,{"v":27158.102883091626,"d":"27158.10"},null,{"$f":"'9. Steel R'!J18+'9. Steel M'!J17","v":0},null,{"$f":"I45+G45","v":{"v":27158.102883091626,"d":"27,158.10"}}]
[null,"Reduce Rate @ 97 %",null,null,{"$f":"E45*97%","v":{"v":34167.765,"d":"34,167.77"}},null,null,{"v":8609674.4,"d":"8,609,674"},null,{"$f":"L46-H46","v":{"v":669642.3715529721,"d":"669,642"}},null,{"$f":"K45*E46/100","v":{"v":9279316.771552972,"d":"9,279,317"}}]
[10,"Providing and laying reinforceed cement concrete (including pre stressed concrete), using coarse sand and screened graded and washed aggregate , in required shape and design, including form moulds, shuttering, lifting, compacting, curing, rendering,and fi b) Precast reinforced cement concrete and prestressed reinforced cement concrete in columns, beams, lintels, stair cases, shelves, etc. :- a (1:1.5:3)","P Cft",{"v":0,"d":"0.00"},746.37,null,{"v":15562.460785333336,"d":"15562.46"},null,{"$f":"'10. RCC '!J25","v":0},null,{"$f":"I47+G47","v":{"v":15562.460785333336,"d":"15,562.46"}}]
[null,"Reduce Rate @ 97 %",null,null,{"$f":"E47*97%","v":{"v":723.9789,"d":"723.98"}},null,null,{"v":10453771.4,"d":"10,453,771"},null,{"$f":"L48-H48","v":{"v":813121.8406587634,"d":"813,122"}},null,{"$f":"K47*E48/1","v":{"v":11266893.240658764,"d":"11,266,893"}},{"$f":"J48+H48","v":{"v":11266893.240658764,"d":"11,266,893"}}]
[null,"Deduction Chenab Sand",null,null,{"v":-20.6,"d":"(20.60)"},{"$nulls":4},{"$f":"K47*E49","v":{"v":-320586.69217786676,"d":"-320,587"}},null,{"$f":"J49","v":{"v":-320586.69217786676,"d":"(320,587)"}}]
[{"$f":"A47+1","v":11},"Providing, fixing, testing and commissioning of µ-PVC (Unplasticized Polyvinyl Chloride ) Nikasi/ waste pipe make of Dadex /Popular/Beta or equivalent, plain /socket ended conforming to code EN-1329 of specified SDR (Standard Dimension Ratio) including the cost of specials and Solvents complete in all respect as approved and directed by the Engineer Incharge. Ch 19 Page 118 Item 47 b (2\" Dia)","P Rft",{"v":0,"d":"0.00"},{"v":112.4,"d":"112.40"},{"$f":"D50*E50","v":0},{"v":468,"d":"468.00"},null,{"$f":"'11.UPVC'!J14","v":0},null,{"$f":"I50+G50","v":{"v":468,"d":"468.00"}},null,{"$f":"K50*E51","v":{"v":51025.104,"d":"51,025"}}]
[null,"Reduce Rate @ 97 %",null,null,{"$f":"E50*97%","v":{"v":109.028,"d":"109.03"}},null,null,{"v":49973.04,"d":"49,973"},null,{"$f":"L51-H51","v":{"v":1052.0639999999985,"d":"1,052"}},null,{"$f":"K50*E51/1","v":{"v":51025.104,"d":"51,025"}}]
[{"$f":"A50+1","v":12},"Providing and fixing, 6\" thick R.C.C manhole cover, 22\" I/d, with Tee shaped C.I frame of 20\" clear I/d ( frame weighing 37.324 Kg or one mound), as per standard drawing STD/PD No. 5 of 1977, complete in all respects.  Ch. 21 Page 139 item 16","Per Set",null,{"v":25221.2,"d":"25,221.20"},{"$f":"D52*E52","v":0},{"v":28,"d":"28.00"},null,{"$f":"-G52","v":{"v":-28,"d":"(28.00)"}},null,{"$f":"I52+G52","v":0}]
[null,"Reduce Rate @ 95 %",null,null,{"$f":"E52*95%","v":{"v":23960.14,"d":"23,960.14"}},null,null,{"v":564954.8800000001,"d":"564,955"},null,{"$f":"-H53","v":{"v":-564954.8800000001,"d":"-564,955"}},null,{"$f":"K52*E53/1","v":0}]
[12,"Providing and fixing, 6\" (150 mm) thick R.C.C. manhole cover for  22\" as per standard drawing STD/PD No. 6 of 1977, complete in all respects.  I/C FRAME COMPLETE IN \nALL RESPECT","Per Set",null,{"v":16257.15,"d":"16,257.15"},{"$f":"D54*E54","v":0},null,null,{"$f":"'12 RCC Cover'!J12","v":{"v":28,"d":"28.00"}},null,{"$f":"I54+G54","v":{"v":28,"d":"28.00"}}]
[null,"Reduce Rate @ 97 %",null,null,{"$f":"E54*97%","v":{"v":15769.4355,"d":"15,769.44"}},{"$nulls":4},{"$f":"L55-H55","v":{"v":441544.194,"d":"441,544"}},null,{"$f":"K54*E55/1","v":{"v":441544.194,"d":"441,544"}}]
[{"$f":"A52+1","v":13},"Providing and laying R.C.C. pipe, moulded with cement  concrete 1:1½:3, with spigot socket or collar joint, etc. including cost of reinforcement, conforming to B.S. 5911: Part I: 1981, Class \"L\" including carriage of pipe from factory to site of work, lowering in trenches to correct alignment and grade, jointing, cutting pipes where necessary, finishing and testing, etc., complete. Chapter - 21 Page 136 Item 01 (9\" dia)","P Rft",null,{"v":590.6,"d":"590.60"},{"$f":"D56*E56","v":0},{"v":312,"d":"312.00"},null,{"$f":"'13.RCC Pipe 9\"'!J14","v":0},null,{"$f":"I56+G56","v":{"v":312,"d":"312.00"}}]
[null,"Reduce Rate @ 95 %",null,null,{"$f":"E56*95%","v":561.07},null,null,{"v":165840.48,"d":"165,840"},null,{"$f":"L57-H57","v":{"v":9213.360000000015,"d":"9,213"}},null,{"$f":"K56*E57/1","v":{"v":175053.84000000003,"d":"175,054"}}]
[{"$f":"A56+1","v":14},"P/L of Select Fill material  including ploughing and mixing with blade grade or disc harrow or other suitable equipment and compaction by mechanical means at OMC and dressing to designed section, complete in all respect 95% to 100% maximum modified AASHTO dry-density with vibratory roller.Mixing, Moisterning earth to optimum moisture contant in layer etc. complete with tractor complete with rotorator blade.","1000 Cft",{"v":0,"d":"0.00"},{"v":36364.15,"d":"36,364.15"},{"$f":"D58*E58","v":0},{"v":1526.6815199999999,"d":"1526.68"},null,{"$f":"'14. Select Fill'!J11","v":0},null,{"$f":"I58+G58","v":{"v":1526.6815199999999,"d":"1,526.68"}}]
[null,"Reduce Rate @ 97 %",null,null,{"$f":"E58*97%","v":{"v":35273.2255,"d":"35,273.23"}},null,null,{"v":49964.8282159572,"d":"49,965"},null,{"$f":"L59-H59","v":{"v":3886.1533056855624,"d":"3,886"}},{"$f":"I59+G59","v":0},{"$f":"K58*E59/1000","v":{"v":53850.98152164276,"d":"53,851"}}]
[15,"Desilting of Sewer through winch machine including hire chargfes for two No. winch machines, operator for operating of winch machines, POL, etc.complete in all respects. Sewer 36\" Dia","P/Rft",{"v":0,"d":"0.00"},889.98,{"$f":"E60*D60","v":0},{"v":3400,"d":"3,400"},null,{"$f":"'15.Desilting'!J13","v":0},null,{"$f":"I60+G60","v":{"v":3400,"d":"3,400.00"}}]
[null,"Reduce Rate @ 97 %",null,null,{"$f":"E60*97%","v":{"v":863.2806,"d":"863.28"}},null,null,{"v":2874632.4,"d":"2,874,632"},null,{"$f":"L61-H61","v":{"v":60521.64000000013,"d":"60,522"}},null,{"$f":"K60*E61/1","v":{"v":2935154.04,"d":"2,935,154"}}]
[16,"Providing and fixing theremopore (foamed polythene)\n sheet in horizontal and vertical expansion joints:  a) 1\" (25 mm) thick thermopore sheet","Sft",{"v":0,"d":"0.00"},{"v":26.7,"d":"26.70"},{"$f":"E62*D62","v":0},{"v":205.92000000000002,"d":"205.92"},null,{"$f":"'16. theremopore'!J11","v":0},null,{"$f":"I62+G62","v":{"v":205.92000000000002,"d":"205.92"}}]
[null,"Reduce Rate @ 97 %",null,null,{"$f":"E62*97%","v":{"v":25.898999999999997,"d":"25.90"}},null,null,{"v":5224.4,"d":"5,224"},null,{"$f":"L63-H63","v":{"v":108.72208000000046,"d":"109"}},null,{"$f":"K62*E63/1","v":{"v":5333.12208,"d":"5,333"}}]
[17,"Providing and fixing marble strip of any shade for dividing\n the mosaic flooring into panels a) Size 1½\" x 3/8\" (40 x 10 mm)","Rft",null,{"v":38.3,"d":"38.30"},{"$f":"E64*D64","v":0},624,null,{"$f":"'18.Marble Strip'!J10","v":0},null,{"$f":"I64+G64","v":{"v":624,"d":"624.00"}}]
[null,"Reduce Rate @ 97 %",null,null,{"$f":"E64*97%","v":{"v":37.150999999999996,"d":"37.15"}},null,null,{"v":22707.4,"d":"22,707"},null,{"$f":"L65-H65","v":{"v":474.8239999999969,"d":"475"}},null,{"$f":"K64*E65/1","v":{"v":23182.224,"d":"23,182"}}]
[]
["Total Non BOQ ITEMS",{"$nulls":6},{"$f":"SUM(H29:H66)","v":{"v":28602574.45344519,"d":"28,602,574"}},null,{"$f":"SUM(J29:J66)","v":{"v":5357336.363133525,"d":"5,357,336"}},null,{"$f":"SUM(L29:L66)","v":{"v":33959910.816578716,"d":"33,959,911"}},{"$f":"J67+H67","v":{"v":33959910.816578716,"d":"33,959,911"}}]
{"$rows_empty":56}
[{"$nulls":3},3.14]
{"$rows_empty":48}
[{"$nulls":3},3.14]
{"$rows_empty":47}
[{"$nulls":9},{"$f":"SUM(J213:J220)","v":0}]
[]
[]
[19,"Transportation of earth all types when the total distance, including the lead covered in the item of work, is more than 1000 ft. Upto 5 mile."]
[null,"Total qty of sand filling",{"$nulls":7},{"v":135864.101760386,"d":"135864.10"}]
[{"$nulls":8},"Total",{"$f":"SUM(J224:J225)","v":{"v":135864.101760386,"d":"135864.10"}}]
[20,"Carriage of 100 Cft. (2.83 cu.m) of all materials like stoneggregate, spawl, kankar lime (unslaked), surkhi, etc.by truck or by any other means owned by the contractor. (Lead upto 193 Km)"]
[null,"Total of qty of curshed stone",{"$nulls":7},{"v":11195.99625,"d":"11196.00"}]
[null,"PCC 1:2:4",{"v":2869.018628,"d":"2869.02"},null,0.88,"-",null,null,"-",{"$f":"E229*C229","v":{"v":2524.73639264,"d":"2524.74"}}]
[{"$nulls":8},"Total",{"$f":"SUM(J228:J229)","v":{"v":13720.73264264,"d":"13720.73"}}]
{"$rows_empty":250}
[{"$nulls":3},3.14]
{"$rows_empty":61}
[{"$nulls":3},3.14]

{"sheet":"1.Dism of Road","index":3,"n_rows":20,"n_cols":14,"rows_kept":20,"merged":[[0,0,0,13],[1,1,1,5],[1,6,1,8],[1,11,1,13],[2,0,2,13],[3,0,3,13],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,4,5],[4,6,5,6],[4,7,5,7],[4,8,4,10],[4,11,5,11],[4,12,5,12],[4,13,5,13],[12,1,12,11],[13,1,13,11],[14,1,14,11],[19,0,19,3]]}
[{"$f":"+'Abstract of Cost'!A1","v":"PROJECT NAME"}]
[null,"Contractor:- ",{"$nulls":4},"Client : ",{"$nulls":4},"Consultant: "]
["IPC NO. 03"]
[{"$f":"'Abstract of Cost'!B8","v":"Dismantling of road metling i/c removal from site"}]
["S.No.","IPC No.","ReQ.No","Date","Chainage",null,"No.","Length (ft)","Width (ft)",null,null,"Avg. Thickness (ft)","Quantity (Cft)","Remarks"]
[{"$nulls":4},"From","To",null,null,"Start","End","Average"]
[null,1,"1800 RD to 1900 RD",null,{"v":1800,"d":"18+00"},{"v":1900,"d":"19+00"},1,{"v":100,"d":"100.00"},25.83,23.17,{"v":24.5,"d":"24.50"},0.16,{"$f":"H7*K7*L7","v":{"v":392,"d":"392.00"}}]
[null,1,"1900 RD to 2000 RD",null,{"v":1900,"d":"19+00"},{"v":2000,"d":"20+00"},1,{"v":100,"d":"100.00"},{"$f":"J7","v":23.17},24.66,{"v":23.915,"d":"23.92"},0.16,382.64]
[null,1,"2000 RD to 2100 RD",null,{"v":2000,"d":"20+00"},{"v":2100,"d":"21+00"},1,{"v":100,"d":"100.00"},24.66,{"v":23,"d":"23.00"},23.83,0.16,{"v":381.28000000000003,"d":"381.28"}]
[null,1,"2100 RD to 2200 RD",null,{"v":2100,"d":"21+00"},{"v":2200,"d":"22+00"},1,{"v":100,"d":"100.00"},{"v":23,"d":"23.00"},{"$f":"(35+29+30)/3","v":{"v":31.333333333333332,"d":"31.33"}},{"v":27.166666666666664,"d":"27.17"},0.16,{"v":434.66666666666663,"d":"434.67"}]
[null,1,"2200 RD to 2270 RD",null,{"v":2200,"d":"22+00"},{"v":2260,"d":"22+60"},1,{"v":70,"d":"70.00"},{"v":31.333333333333332,"d":"31.33"},{"v":27,"d":"27.00"},{"v":29.166666666666664,"d":"29.17"},0.16,{"v":326.66666666666663,"d":"326.67"}]
[null,null,"Deduction Manhole",{"$nulls":3},-6,3.14,null,null,{"$f":"1.66*1.66","v":{"v":2.7556,"d":"2.76"}},0.16,{"$f":"PRODUCT(G12:L12)","v":{"v":-8.30648064,"d":"-8.31"}}]
[null," Total Quantity (Cft) = ",{"$nulls":10},{"$f":"SUM(M7:M12)","v":{"v":1908.946852693333,"d":"1908.95"}}]
[null,"Already Paid Quantity (CFT) = ",{"$nulls":10},1917.25]
[null,"This Bill Quantity (CFT) = ",{"$nulls":10},{"$f":"M13-M14","v":{"v":-8.303147306666915,"d":"-8.30"}}]
[]
[]
[]
["Quantity Surveyor:___________________",{"$nulls":10},"Quantity Surveyor:______________"]
["Contractor.",{"$nulls":10},"Consultant."]

{"sheet":"8. Raising MH","index":4,"n_rows":15,"n_cols":14,"rows_kept":15,"merged":[[0,0,0,13],[1,1,1,5],[1,6,1,7],[1,11,1,13],[2,0,2,13],[3,0,3,13],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,4,5],[4,6,5,6],[4,7,5,7],[4,8,4,10],[4,11,5,11],[4,12,5,12],[4,13,5,13],[7,1,7,11],[8,1,8,11],[9,1,9,11],[14,0,14,3]]}
[{"$f":"+'1.Dism of Road'!A1:N1","v":"PROJECT NAME"}]
[null,"Contractor:- ",{"$nulls":4},"Client : ",{"$nulls":4},"Consultant: "]
[{"$f":"'11.Str Exc..'!A3:M3","v":"IPC NO. 03"}]
[{"$f":"'Abstract of Cost'!B16","v":"Raising of manhole i/c C.I Ring "}]
["S.No.","IPC No.","ReQ.No","Date","Chainage",null,"No.","Length (ft)","Width (ft)",null,null,"Avg. Thickness (ft)","Quantity (Cft)","Remarks"]
[{"$nulls":4},"From","To",null,null,"Start","End","Average"]
[null,1,{"$nulls":4},64,{"$nulls":5},{"$f":"G7","v":{"v":64,"d":"64.00"}}]
[null," Total Quantity (Each) = ",{"$nulls":10},{"$f":"SUM(M7:M7)","v":{"v":64,"d":"64.00"}}]
[null,"Already Paid Quantity (Each) = ",{"$nulls":10},{"v":0,"d":"0.00"}]
[null,"This Bill Quantity (Each) = ",{"$nulls":10},{"$f":"M8-M9","v":{"v":64,"d":"64.00"}}]
[]
[]
[]
["Quantity Surveyor:___________________",{"$nulls":10},"Quantity Surveyor:______________"]
["Contrctor.",{"$nulls":10},"Consultant."]

{"sheet":"11.Str Exc..","index":5,"n_rows":18,"n_cols":17,"rows_kept":18,"merged":[[0,0,0,12],[1,1,1,4],[1,5,1,8],[1,10,1,12],[2,0,2,12],[3,0,3,12],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,4,4],[4,5,5,5],[4,6,5,6],[4,7,4,9],[4,10,5,10],[4,11,5,11],[4,12,5,12],[6,2,6,4],[7,2,7,4],[8,2,8,4],[9,1,9,10],[10,1,10,10],[11,1,11,10],[12,1,12,10],[17,0,17,2]]}
[{"$f":"+'8. Raising MH'!A1:N1","v":"PROJECT NAME"}]
[null,"Contractor:-",{"$nulls":3},"Client : ",{"$nulls":4},"Consultant: "]
[{"$f":"'1.Dism of Road'!A3:N3","v":"IPC NO. 03"}]
[{"$f":"'Abstract of Cost'!B20","v":"Structure excavation for sewer i/c removal from site"}]
["S.No.","IPC No.","Date","Chainage",null,"No.","Length (ft)","Width (ft)",null,null,"Avg. Thickness (ft)","Quantity (Cft)","Remarks"]
[{"$nulls":3},"From","To",null,null,"Start","End","Average"]
[null,null,"Rcc Pipe 9\" dia",null,null,1,{"v":312,"d":"312.00"},null,null,2.25,2.92,{"$f":"PRODUCT(F7:K7)","v":2049.84}]
[null,null,"Deduction of Manhole ",null,null,-6,{"v":7,"d":"7.00"},null,null,2.25,2.92,{"$f":"PRODUCT(F8:K8)","v":-275.94},{"$nulls":4},{"$f":"312/6","v":52}]
[null,null,"Manholes on 9\" dia lines",null,null,6,3.14,null,{"v":3.5,"d":"3.50"},{"v":3.5,"d":"3.50"},{"v":4.5,"d":"4.50"},{"$f":"PRODUCT(F9:K9)","v":{"v":1038.555,"d":"1038.56"}}]
[{"$nulls":15},{"$f":"F8*8","v":-48}]
[null,"Already Paid Quantity (CFT) = ",{"$nulls":9},{"$f":"SUM(L7:L10)","v":{"v":2812.455,"d":"2812.46"}}]
[null,"Already Paid Quantity (CFT) = ",{"$nulls":9},{"v":2812.9,"d":"2812.90"}]
[null,"This Bill Quantity (CFT) = ",{"$nulls":9},{"$f":"L11-L12","v":{"v":-0.4450000000001637,"d":"-0.45"}}]
[]
[]
[]
["Quantity Surveyor:___________________",{"$nulls":9},"Quantity Surveyor:______________"]
["Contractor.",{"$nulls":9},"Consultant."]

{"sheet":"13 GG","index":6,"n_rows":16,"n_cols":14,"rows_kept":16,"merged":[[0,0,0,13],[1,1,1,5],[1,6,1,7],[1,11,1,13],[2,0,2,13],[3,0,3,13],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,4,5],[4,6,5,6],[4,7,5,7],[4,8,4,10],[4,11,5,11],[4,12,5,12],[4,13,5,13],[8,1,8,11],[9,1,9,11],[10,1,10,11],[15,0,15,3]]}
[{"$f":"+'11.Str Exc..'!A1:M1","v":"PROJECT NAME"}]
[null,"Contractor:- ",{"$nulls":4},"Client : ",{"$nulls":4},"Consultant: "]
[{"$f":"'11.Str Exc..'!A3:M3","v":"IPC NO. 03"}]
[{"$f":"'Abstract of Cost'!B23","v":"Constructed standered gully grating chamber, 3'x2.5' (900x750 m) complete in all respect (b) concrete Gully trap"}]
["S.No.","IPC No.","ReQ.No","Date","Chainage",null,"No.","Length (ft)","Width (ft)",null,null,"Avg. Thickness (ft)","Quantity (Cft)","Remarks"]
[{"$nulls":4},"From","To",null,null,"Start","End","Average"]
[null,1,"Along Anum Road",{"$nulls":3},40,{"$nulls":5},{"$f":"G7","v":{"v":40,"d":"40.00"}}]
[{"$nulls":6},8,{"$nulls":5},{"$f":"G8","v":{"v":8,"d":"8.00"}}]
[null," Total Quantity (Each) = ",{"$nulls":10},{"$f":"SUM(M7:M8)","v":{"v":48,"d":"48.00"}}]
[null,"Already Paid Quantity (Each) = ",{"$nulls":10},{"v":40,"d":"40.00"}]
[null,"This Bill Quantity (Each) = ",{"$nulls":10},{"$f":"M9-M10","v":{"v":8,"d":"8.00"}}]
[]
[]
[]
["Quantity Surveyor:___________________",{"$nulls":10},"Quantity Surveyor:______________"]
["Contractor.",{"$nulls":10},"Consultant."]

{"sheet":"14 PCC","index":7,"n_rows":37,"n_cols":17,"rows_kept":37,"merged":[[0,0,0,13],[1,1,1,5],[1,6,1,7],[1,11,1,13],[2,0,2,13],[3,0,3,13],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,4,5],[4,6,5,6],[4,7,5,7],[4,8,4,10],[4,11,5,11],[4,12,5,12],[4,13,5,13],[6,2,6,5],[7,2,7,5],[8,2,8,5],[9,2,9,5],[10,2,10,5],[11,2,11,5],[12,2,12,5],[13,2,13,5],[14,2,14,5],[15,2,15,5],[16,2,16,5],[17,2,17,5],[18,2,18,5],[19,2,19,5],[20,2,20,5],[21,2,21,5],[22,2,22,5],[23,2,23,5],[24,2,24,5],[25,2,25,5],[26,2,26,5],[27,2,27,5],[28,2,28,5],[29,1,29,11],[30,1,30,11],[31,1,31,11],[36,0,36,3]]}
[{"$f":"+'13 GG'!A1:N1","v":"PROJECT NAME"}]
[null,"Contractor:- ",{"$nulls":4},"Client : ",{"$nulls":4},"Consultant: "]
[{"$f":"'13 GG'!A3:N3","v":"IPC NO. 03"}]
[{"$f":"'Abstract of Cost'!B25","v":"P/L PCC1:2:4"}]
["S.No.","IPC No.","ReQ.No","Date","Chainage",null,"No.","Length (ft)","Width (ft)",null,null,"Avg. Thickness (ft)","Quantity (Cft)","Remarks"]
[{"$nulls":4},"From","To",null,null,"Start","End","Average"]
[null,null,"Benching "]
[null,null,"Manhole 6' Dia",{"$nulls":3},6,3.14,null,{"$f":"4.5/2","v":2.25},{"$f":"4.5/2","v":2.25},{"$f":"(1+0.75)/2","v":{"v":0.875,"d":"0.88"}},{"$f":"PRODUCT(G8:L8)","v":{"v":83.45531249999999,"d":"83.46"}},null,null,{"$f":"L8*K8*H8*G8","v":37.09125},{"$f":"4.25/2","v":2.125}]
[null,null,"Deduction of Pipe Area",{"$nulls":3},{"$f":"-6/2","v":-3},{"v":4.5,"d":"4.50"},null,null,{"v":0.375,"d":"0.38"},{"v":0.375,"d":"0.38"},{"$f":"PRODUCT(G9:L9)","v":{"v":-1.8984375,"d":"-1.90"}}]
[null,null,"Manhole 7.5' Dia",{"$nulls":3},22,3.14,null,null,{"$f":"3*3","v":{"v":9,"d":"9.00"}},{"$f":"(1+0.75)/2","v":{"v":0.875,"d":"0.88"}},{"$nulls":3},{"$f":"L10*K10*H10*G10","v":544.0050000000001},{"$f":"4.25/2","v":2.125}]
[null,null,"Deduction of Pipe Area",{"$nulls":3},{"$f":"-22/2","v":-11},{"v":6,"d":"6.00"},null,null,{"v":1.5,"d":"1.50"},{"v":1.5,"d":"1.50"}]
[null,null,"Shoulder PCC",{"$nulls":12},{"$f":"L12*K12*H12*G12","v":0},{"$f":"4.25/2","v":2.125}]
[null,null,"1400-RD to 1500 RD",{"$nulls":3},1,{"v":100,"d":"100.00"},null,null,{"v":0.745000000000001,"d":"0.75"},0.67,{"$f":"PRODUCT(G13:L13)","v":{"v":49.91500000000007,"d":"49.92"}},null,{"v":24.745,"d":"24.75"},24,{"$f":"O13-P13","v":{"v":0.745000000000001,"d":"0.75"}}]
[null,null,"1500 RD to 1600 RD",{"$nulls":3},1,{"v":100,"d":"100.00"},null,null,{"v":0.9100000000000001,"d":"0.91"},0.67,{"v":60.97000000000001,"d":"60.97"},null,24.91,24,{"$f":"O14-P14","v":{"v":0.9100000000000001,"d":"0.91"}}]
[null,null,"1600 RD to 1700 RD",{"$nulls":3},1,{"v":100,"d":"100.00"},null,null,{"v":1.7100000000000009,"d":"1.71"},0.67,{"v":114.57000000000006,"d":"114.57"},null,25.71,24,{"v":1.7100000000000009,"d":"1.71"}]
[null,null,"1700 RD to 1800 RD",{"$nulls":3},1,{"v":100,"d":"100.00"},null,null,{"v":2,"d":"2.00"},0.67,{"v":134,"d":"134.00"},null,{"v":26,"d":"26.00"},24,{"v":2,"d":"2.00"}]
[null,null,"1800 RD to 1900 RD",{"$nulls":3},1,{"v":100,"d":"100.00"},null,null,{"v":0.5,"d":"0.50"},0.67,{"v":33.5,"d":"33.50"},null,{"v":24.5,"d":"24.50"},24,{"v":0.5,"d":"0.50"}]
[null,null,"1900 RD to 2000 RD",{"$nulls":3},1,{"v":100,"d":"100.00"},{"$nulls":6},{"v":23.915,"d":"23.92"},24,{"v":-0.08500000000000085,"d":"-0.09"}]
[null,null,"2000 RD to 2100 RD",{"$nulls":3},1,{"v":100,"d":"100.00"},{"$nulls":6},23.83,24,{"v":-0.1700000000000017,"d":"-0.17"}]
[null,null,"2100 RD to 2200 RD",{"$nulls":3},1,{"v":100,"d":"100.00"},null,null,{"v":3.1666666666666643,"d":"3.17"},0.67,{"v":212.16666666666652,"d":"212.17"},null,{"v":27.166666666666664,"d":"27.17"},24,{"v":3.1666666666666643,"d":"3.17"}]
[null,null,"2200 RD to 2300 RD",{"$nulls":3},1,{"v":100,"d":"100.00"},null,null,{"v":5.166666666666664,"d":"5.17"},0.67,{"v":346.1666666666665,"d":"346.17"},null,{"v":29.166666666666664,"d":"29.17"},24,{"v":5.166666666666664,"d":"5.17"}]
[null,null,"2300 RD to 2370 RD",{"$nulls":3},1,{"v":100,"d":"100.00"},null,null,{"v":5.166666666666664,"d":"5.17"},0.67,{"v":346.1666666666665,"d":"346.17"},null,{"v":29.166666666666664,"d":"29.17"},24,{"v":5.166666666666664,"d":"5.17"}]
[null,null,"Road 1",{"$nulls":3},1,{"v":203,"d":"203.00"},null,null,{"v":13,"d":"13.00"},{"v":0.5,"d":"0.50"},{"$f":"PRODUCT(G23:L23)","v":{"v":1319.5,"d":"1319.50"}},null,{"v":29.166666666666664,"d":"29.17"},24,{"$f":"O23-P23","v":{"v":5.166666666666664,"d":"5.17"}}]
[null,null,"Road 2",{"$nulls":3},1,{"v":225,"d":"225.00"},null,null,{"v":14,"d":"14.00"},{"v":0.5,"d":"0.50"},{"$f":"PRODUCT(G24:L24)","v":{"v":1575,"d":"1575.00"}},null,{"v":29.166666666666664,"d":"29.17"},24,{"$f":"O24-P24","v":{"v":5.166666666666664,"d":"5.17"}}]
[null,null,"Road 3",{"$nulls":3},1,{"v":276,"d":"276.00"},null,null,{"v":15,"d":"15.00"},{"v":0.5,"d":"0.50"},{"$f":"PRODUCT(G25:L25)","v":{"v":2070,"d":"2070.00"}},null,{"v":29.166666666666664,"d":"29.17"},24,{"$f":"O25-P25","v":{"v":5.166666666666664,"d":"5.17"}}]
[null,null,"Road 4",{"$nulls":3},1,{"v":343,"d":"343.00"},null,null,23.67,{"v":0.5,"d":"0.50"},{"v":4059.405,"d":"4059.41"},null,{"v":29.166666666666664,"d":"29.17"},24,{"v":5.166666666666664,"d":"5.17"}]
[null,null,"Deduction Manhole ",{"$nulls":3},-64,3.142,null,null,{"$f":"1.75*1.75","v":{"v":3.0625,"d":"3.06"}},{"v":0.5,"d":"0.50"},{"v":-307.916,"d":"-307.92"}]
[null,null,"Footpath",{"$nulls":11},{"v":29.166666666666664,"d":"29.17"},24,{"$f":"O28-P28","v":{"v":5.166666666666664,"d":"5.17"}}]
[{"$nulls":6},1,{"v":1800,"d":"1800.00"},null,null,{"v":5,"d":"5.00"},0.33,{"$f":"PRODUCT(G29:L29)","v":{"v":2970,"d":"2970.00"}},null,{"v":29.166666666666664,"d":"29.17"},24,{"v":5.166666666666664,"d":"5.17"}]
[null," Total Quantity (Cft) = ",{"$nulls":10},{"$f":"SUM(M8:M29)","v":{"v":13065.000875000002,"d":"13065.00"}}]
[null,"Already Paid Quantity (Cft) = ",{"$nulls":10},{"v":1379.0118749999997,"d":"1379.01"}]
[null,"This Bill Quantity (Cft) = ",{"$nulls":10},{"$f":"M30-M31","v":{"v":11685.989000000001,"d":"11685.99"}}]
[]
[]
[]
["Quantity Surveyor:___________________",{"$nulls":10},"Quantity Surveyor:______________"]
["Contractor:",{"$nulls":10},"Consultant:"]

{"sheet":"1.Dismantling PCC","index":8,"n_rows":69,"n_cols":14,"rows_kept":69,"merged":[[0,0,0,13],[1,1,1,5],[1,6,1,7],[1,11,1,13],[2,0,2,13],[3,0,3,13],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,4,5],[4,6,5,6],[4,7,5,7],[4,8,4,10],[4,11,5,11],[4,12,5,12],[4,13,5,13],[12,2,12,3],[58,1,58,11],[59,1,59,11],[60,1,60,11],[68,0,68,3],[71,0,71,3]]}
[{"$f":"+'14 PCC'!A1:N1","v":"PROJECT NAME"}]
[null,"Contractor:- ",{"$nulls":4},"Client : ",{"$nulls":4},"Consultant: "]
[{"$f":"'13 GG'!A3:N3","v":"IPC NO. 03"}]
[{"$f":"'Abstract of Cost'!#REF!","v":{"$error":"#REF!"}}]
["S.No.","IPC No.","ReQ.No","Date","Chainage",null,"No.","Length (ft)","Width (ft)",null,null,"Avg. Thickness (ft)","Quantity (Cft)","Remarks"]
[{"$nulls":4},"From","To",null,null,"Start","End","Average"]
[null,1,"1800 RD to 1900 RD",null,{"v":1800,"d":"18+00"},{"v":1900,"d":"19+00"},1,{"v":100,"d":"100.00"},null,null,{"v":24.5,"d":"24.50"},0.58,{"$f":"H7*K7*L7*G7","v":{"v":1421,"d":"1421.00"}}]
[null,1,"1900 RD to 2000 RD",null,{"v":1900,"d":"19+00"},{"v":2000,"d":"20+00"},1,{"v":100,"d":"100.00"},null,null,{"v":23.915,"d":"23.92"},0.58,{"$f":"H8*K8*L8*G8","v":1387.07}]
[null,1,"2000 RD to 2100 RD",null,{"v":2000,"d":"20+00"},{"v":2100,"d":"21+00"},1,{"v":100,"d":"100.00"},null,null,23.83,0.58,{"v":1382.1399999999999,"d":"1382.14"}]
[null,1,"2100 RD to 2200 RD",null,{"v":2100,"d":"21+00"},{"v":2200,"d":"22+00"},1,{"v":100,"d":"100.00"},null,null,{"v":27.166666666666664,"d":"27.17"},0.58,{"v":1575.6666666666665,"d":"1575.67"}]
[null,1,"2200 RD to 2270 RD",null,{"v":2200,"d":"22+00"},{"v":2260,"d":"22+60"},1,{"v":70,"d":"70.00"},null,null,{"v":29.166666666666664,"d":"29.17"},0.58,{"v":1184.1666666666665,"d":"1184.17"}]
[null,null,"Deduction Manhole",{"$nulls":3},-6,3.14,null,null,{"$f":"1.66*1.66","v":{"v":2.7556,"d":"2.76"}},0.58,{"$f":"PRODUCT(G12:L12)","v":{"v":-30.110992319999998,"d":"-30.11"}}]
[null,null,"Ramps"]
[{"$nulls":6},1,{"v":5,"d":"5.00"},null,null,{"v":2,"d":"2.00"},{"v":4,"d":"4.00"},{"v":40,"d":"40.00"}]
[{"$nulls":6},1,{"v":11,"d":"11.00"},null,null,{"v":5,"d":"5.00"},{"v":1,"d":"1.00"},{"v":55,"d":"55.00"}]
[{"$nulls":6},1,{"v":18,"d":"18.00"},null,null,{"v":1.5,"d":"1.50"},{"v":1.5,"d":"1.50"},{"v":40.5,"d":"40.50"}]
[{"$nulls":6},1,{"v":5,"d":"5.00"},null,null,{"v":6,"d":"6.00"},{"v":1,"d":"1.00"},{"v":30,"d":"30.00"}]
[{"$nulls":6},1,{"v":21,"d":"21.00"},null,null,{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":84,"d":"84.00"}]
[{"$nulls":6},1,{"v":2,"d":"2.00"},null,null,{"v":2,"d":"2.00"},{"v":1.5,"d":"1.50"},{"v":6,"d":"6.00"}]
[{"$nulls":6},1,{"v":2,"d":"2.00"},null,null,{"v":1.5,"d":"1.50"},{"v":2,"d":"2.00"},{"v":6,"d":"6.00"}]
[{"$nulls":6},1,{"v":18,"d":"18.00"},null,null,{"v":5,"d":"5.00"},{"v":2,"d":"2.00"},{"v":180,"d":"180.00"}]
[{"$nulls":6},1,{"v":37,"d":"37.00"},null,null,{"v":5,"d":"5.00"},{"v":1,"d":"1.00"},{"v":185,"d":"185.00"}]
[{"$nulls":6},1,{"v":20,"d":"20.00"},null,null,{"v":5,"d":"5.00"},{"v":1,"d":"1.00"},{"v":100,"d":"100.00"}]
[{"$nulls":6},1,{"v":4,"d":"4.00"},null,null,{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":16,"d":"16.00"}]
[{"$nulls":6},1,{"v":25,"d":"25.00"},null,null,{"v":5,"d":"5.00"},{"v":2,"d":"2.00"},{"v":250,"d":"250.00"}]
[{"$nulls":6},1,{"v":45,"d":"45.00"},null,null,{"v":3,"d":"3.00"},{"v":1.5,"d":"1.50"},{"v":202.5,"d":"202.50"}]
[{"$nulls":6},1,{"v":3,"d":"3.00"},null,null,{"v":2,"d":"2.00"},{"v":3,"d":"3.00"},{"v":18,"d":"18.00"}]
[{"$nulls":6},1,{"v":4.5,"d":"4.50"},null,null,{"v":3,"d":"3.00"},{"v":1,"d":"1.00"},{"v":13.5,"d":"13.50"}]
[{"$nulls":6},1,{"v":6,"d":"6.00"},null,null,{"v":2,"d":"2.00"},{"v":3,"d":"3.00"},{"v":36,"d":"36.00"}]
[{"$nulls":6},1,{"v":7,"d":"7.00"},null,null,{"v":1.5,"d":"1.50"},{"v":1,"d":"1.00"},{"v":10.5,"d":"10.50"}]
[{"$nulls":6},1,{"v":16,"d":"16.00"},null,null,{"v":1.5,"d":"1.50"},{"v":1,"d":"1.00"},{"v":24,"d":"24.00"}]
[{"$nulls":6},1,{"v":4,"d":"4.00"},null,null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"}]
[{"$nulls":6},1,{"v":8,"d":"8.00"},null,null,{"v":2,"d":"2.00"},{"v":1.5,"d":"1.50"},{"v":24,"d":"24.00"}]
[{"$nulls":6},1,{"v":19,"d":"19.00"},null,null,{"v":1.5,"d":"1.50"},{"v":1,"d":"1.00"},{"$f":"H34*K34*L34*G34","v":{"v":28.5,"d":"28.50"}}]
[{"$nulls":6},1,{"v":10,"d":"10.00"},null,null,{"v":1.5,"d":"1.50"},{"v":4,"d":"4.00"},{"v":60,"d":"60.00"}]
[{"$nulls":6},1,{"v":20.5,"d":"20.50"},null,null,{"v":1.5,"d":"1.50"},{"v":0.5,"d":"0.50"},{"v":15.375,"d":"15.38"}]
[{"$nulls":6},1,{"v":8,"d":"8.00"},null,null,{"v":1.5,"d":"1.50"},{"v":1,"d":"1.00"},{"v":12,"d":"12.00"}]
[{"$nulls":6},1,{"v":10,"d":"10.00"},null,null,{"v":2,"d":"2.00"},{"v":0.5,"d":"0.50"},{"v":10,"d":"10.00"}]
[{"$nulls":6},1,{"v":11,"d":"11.00"},null,null,{"v":2,"d":"2.00"},{"v":1,"d":"1.00"},{"v":22,"d":"22.00"}]
[{"$nulls":6},1,{"v":4.5,"d":"4.50"},null,null,{"v":1.5,"d":"1.50"},{"v":1,"d":"1.00"},6.75]
[{"$nulls":6},1,{"v":18,"d":"18.00"},null,null,{"v":5,"d":"5.00"},{"v":0.5,"d":"0.50"},{"v":45,"d":"45.00"}]
[{"$nulls":6},1,{"v":8,"d":"8.00"},null,null,{"v":3,"d":"3.00"},{"v":2,"d":"2.00"},{"v":48,"d":"48.00"}]
[{"$nulls":6},1,{"v":22.5,"d":"22.50"},null,null,{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":90,"d":"90.00"}]
[{"$nulls":6},1,{"v":11,"d":"11.00"},null,null,{"v":4,"d":"4.00"},{"v":1,"d":"1.00"},{"v":44,"d":"44.00"}]
[{"$nulls":6},1,{"v":6,"d":"6.00"},null,null,{"v":3,"d":"3.00"},{"v":1,"d":"1.00"},{"v":18,"d":"18.00"}]
[{"$nulls":6},1,{"v":10,"d":"10.00"},null,null,{"v":2,"d":"2.00"},{"v":1,"d":"1.00"},{"v":20,"d":"20.00"}]
[{"$nulls":6},1,{"v":13,"d":"13.00"},null,null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"$f":"H47*K47*L47*G47","v":{"v":13,"d":"13.00"}}]
[{"$nulls":6},1,{"v":33,"d":"33.00"},null,null,{"v":3,"d":"3.00"},{"v":1.5,"d":"1.50"},{"v":148.5,"d":"148.50"}]
[{"$nulls":6},1,{"v":8,"d":"8.00"},null,null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":8,"d":"8.00"}]
[{"$nulls":6},1,{"v":15,"d":"15.00"},null,null,{"v":2.5,"d":"2.50"},{"v":1.5,"d":"1.50"},56.25]
[{"$nulls":6},1,{"v":37,"d":"37.00"},null,null,{"v":1.5,"d":"1.50"},{"v":1,"d":"1.00"},{"v":55.5,"d":"55.50"}]
[{"$nulls":6},1,{"v":25,"d":"25.00"},null,null,{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":100,"d":"100.00"}]
[{"$nulls":6},1,{"v":8,"d":"8.00"},null,null,{"v":5,"d":"5.00"},{"v":1,"d":"1.00"},{"v":40,"d":"40.00"}]
[{"$nulls":6},1,{"v":28,"d":"28.00"},null,null,{"v":5,"d":"5.00"},{"v":1.5,"d":"1.50"},{"v":210,"d":"210.00"}]
[null,null,{"$f":"'2.Sub Base'!B16","v":"Road 1"},{"$nulls":3},{"v":1,"d":"1.00"},{"$f":"'2.Sub Base'!D16","v":{"v":203,"d":"203.00"}},null,null,{"$f":"'2.Sub Base'!G16","v":{"v":13,"d":"13.00"}},{"v":0.5,"d":"0.50"},{"v":1319.5,"d":"1319.50"}]
[null,null,{"$f":"'2.Sub Base'!B17","v":"Road 2"},{"$nulls":3},{"v":1,"d":"1.00"},{"$f":"'2.Sub Base'!D17","v":{"v":225,"d":"225.00"}},null,null,{"$f":"'2.Sub Base'!G17","v":{"v":14,"d":"14.00"}},{"v":0.5,"d":"0.50"},{"v":1575,"d":"1575.00"}]
[null,null,{"$f":"'2.Sub Base'!B18","v":"Road 3"},{"$nulls":3},{"v":1,"d":"1.00"},{"$f":"'2.Sub Base'!D18","v":{"v":276,"d":"276.00"}},null,null,{"$f":"'2.Sub Base'!G18","v":{"v":15,"d":"15.00"}},{"v":0.5,"d":"0.50"},{"v":2070,"d":"2070.00"}]
[null,null,{"$f":"'2.Sub Base'!B19","v":"Road 4"},{"$nulls":3},{"v":1,"d":"1.00"},{"$f":"'2.Sub Base'!D19","v":{"v":343,"d":"343.00"}},null,null,{"$f":"'2.Sub Base'!G19","v":23.67},{"v":0.5,"d":"0.50"},{"v":4059.405,"d":"4059.41"}]
[null," Total Quantity (Cft) = ",{"$nulls":10},{"$f":"SUM(M7:M58)","v":{"v":18319.71234101333,"d":"18319.71"}}]
[null,"Already Paid Quantity (CFT) = ",{"$nulls":10},{"v":6919.932341013331,"d":"6919.93"}]
[null,"This Bill Quantity (CFT) = ",{"$nulls":10},{"$f":"M59-M60","v":11399.78}]
[]
[]
[]
[]
[]
[]
["Quantity Surveyor:___________________",{"$nulls":10},"Quantity Surveyor:______________"]
["Contractor:",{"$nulls":10},"Consultant:"]

{"sheet":"2.Sub Base","index":9,"n_rows":26,"n_cols":15,"rows_kept":26,"merged":[[0,0,0,14],[1,1,1,7],[1,8,1,11],[1,12,1,14],[2,0,2,14],[3,0,3,14],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,4,6],[4,7,4,10],[4,11,4,13],[4,14,5,14],[5,7,5,8],[5,9,5,10],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4],[6,5,7,5],[25,0,25,3]]}
[{"$f":"+'1.Dismantling PCC'!A1:N1","v":"PROJECT NAME"}]
[null,"Contractor:- ",{"$nulls":6},"   Client : ",{"$nulls":3},"Consultant: "]
["IPC NO. 03"]
[{"$f":"'Abstract of Cost'!B31","v":"Providing and laying sub-base course of stone product of approved quality and grade including placing, mixing, spreading and compaction of sub-base material to required depth, camber, grade to achieve 100% maximum modified AASHO dry density, including carriage of all material to site of work except gravel and aggregate."}]
["Sr.No","Reduced Distance","No","L","Width",null,null,"Reduced Level",{"$nulls":3},"Depths",null,null,"Qty."]
[{"$nulls":4},"Start","End","Avr.","Start",null,"End",null,"Start","End","Average"]
[1,{"$f":"A7+A7","v":2},{"$f":"B7+1","v":3},{"$f":"C7+1","v":4},{"$f":"D7+1","v":5},{"$f":"E7+1","v":6},{"$f":"F7+1","v":7},"Bed","Sub Base","Bed","Sub Base",{"$f":"K8+1","v":12},{"$f":"L7+1","v":13},{"$f":"M7+1","v":14},{"$f":"N7+1","v":15}]
[{"$nulls":6},"(5+6)/2",{"$f":"G7+1","v":8},{"$f":"H8+1","v":9},{"$f":"I8+1","v":10},{"$f":"J8+1","v":11},"(9-8)","(11-10)","(12+13)/2","(3x4x7x14)"]
[null,"1800 RD to 1900 RD",1,100,25.83,23.17,{"$f":"(E9+F9)/2","v":{"v":24.5,"d":"24.50"}},98.39,99.24,98.24,{"$f":"100.08-0.83","v":99.25},{"$f":"I9-H9","v":{"v":0.8499999999999943,"d":"0.85"}},{"$f":"K9-J9","v":{"v":1.0100000000000051,"d":"1.01"}},{"$f":"(L9+M9)/2","v":0.9299999999999997},{"$f":"D9*G9*N9","v":{"v":2278.499999999999,"d":"2278.50"}}]
[null,"1900 RD to 2000 RD",1,{"$f":"D9","v":100},{"$f":"F9","v":23.17},24.66,{"v":23.915,"d":"23.92"},{"$f":"J9","v":98.24},99.25,98.68,{"$f":"100.1-0.83","v":99.27},{"v":1.0100000000000051,"d":"1.01"},{"v":0.5899999999999892,"d":"0.59"},{"$f":"(L10+M10)/2","v":0.7999999999999972},{"$f":"D10*G10*N10","v":{"v":1913.1999999999932,"d":"1913.20"}}]
[null,"2000 RD to 2100 RD",1,100,24.66,{"v":23,"d":"23.00"},23.83,98.68,99.27,98.17,{"$f":"100.11-0.83","v":99.28},{"v":0.5899999999999892,"d":"0.59"},{"v":1.1099999999999994,"d":"1.11"},0.8499999999999943,{"v":2025.5499999999865,"d":"2025.55"}]
[null,"2100 RD to 2200 RD",1,100,{"v":23,"d":"23.00"},{"$f":"(35+29+30)/3","v":{"v":31.333333333333332,"d":"31.33"}},{"v":27.166666666666664,"d":"27.17"},98.17,99.28,{"v":98.6,"d":"98.60"},{"$f":"100.12-0.83","v":99.29},{"v":1.1099999999999994,"d":"1.11"},{"v":0.6900000000000119,"d":"0.69"},0.9000000000000057,{"v":2445.0000000000155,"d":"2445.00"}]
[null,"2200 RD to 2270 RD",1,70,{"v":31.333333333333332,"d":"31.33"},{"v":27,"d":"27.00"},{"v":29.166666666666664,"d":"29.17"},{"v":98.6,"d":"98.60"},99.29,98.24,{"$f":"100.13-0.83","v":{"v":99.3,"d":"99.30"}},{"v":0.6900000000000119,"d":"0.69"},{"v":1.0600000000000023,"d":"1.06"},0.8750000000000071,{"v":1786.4583333333478,"d":"1786.46"}]
[null,"Deduction Manhole ",-28,3.14,{"$nulls":3},{"$f":"1.67*1.67","v":{"v":2.7889,"d":"2.79"}},{"$nulls":5},{"$f":"SUM(N9:N13)/5","v":0.8710000000000008},{"$f":"PRODUCT(C14:N14)","v":{"v":-213.5692766480002,"d":"-213.57"}}]
[null,"Deduction Gully Grating",-48,{"v":3,"d":"3.00"},{"$nulls":3},{"v":2.5,"d":"2.50"},{"$nulls":5},0.66,{"$f":"PRODUCT(C15:N15)","v":{"v":-237.60000000000002,"d":"-237.60"}}]
[null,"Road 1",1,{"v":203,"d":"203.00"},null,null,{"v":13,"d":"13.00"},{"$nulls":6},0.5,{"$f":"D16*G16*N16","v":{"v":1319.5,"d":"1319.50"}}]
[null,"Road 2",1,{"v":225,"d":"225.00"},null,null,{"v":14,"d":"14.00"},{"$nulls":6},0.5,{"$f":"D17*G17*N17","v":{"v":1575,"d":"1575.00"}}]
[null,"Road 3",1,{"v":276,"d":"276.00"},null,null,{"v":15,"d":"15.00"},{"$nulls":6},0.5,{"v":2070,"d":"2070.00"}]
[null,"Road 4",1,{"v":343,"d":"343.00"},null,null,23.67,{"$nulls":6},0.5,{"v":4059.405,"d":"4059.41"}]
[null,"Deduction Manhole ",-12,{"v":3.142,"d":"3.14"},null,null,{"$f":"1.75*1.75","v":{"v":3.0625,"d":"3.06"}},{"$nulls":6},0.5,{"$f":"D20*G20*N20*C20","v":{"v":-57.73425,"d":"-57.73"}}]
[null," Total Quantity (Cft) = ",{"$nulls":12},{"$f":"SUM(O9:O20)","v":{"v":18963.70980668534,"d":"18963.71"}}]
[null,"Already Paid Quantity (CFT) = ",{"$nulls":12},{"v":10037.139056685342,"d":"10037.14"}]
[null,"This Bill Quantity (CFT) = ",{"$nulls":12},{"$f":"O21-O22","v":{"v":8926.570749999997,"d":"8926.57"}}]
[]
["Quantity Surveyor:___________________",{"$nulls":9},"Quantity Surveyor:___________________"]
["Contractor:",{"$nulls":10},"Consultant:"]

{"sheet":"3 Dry Rammed","index":10,"n_rows":15,"n_cols":12,"rows_kept":15,"hidden":true,"merged":[[0,0,0,11],[1,1,1,3],[1,4,1,7],[1,9,1,11],[2,0,2,11],[3,0,3,11],[4,0,5,0],[4,1,5,1],[4,2,4,3],[4,4,5,4],[4,5,5,5],[4,6,4,8],[4,9,5,9],[4,10,5,10],[4,11,5,11],[6,1,6,3],[7,1,7,9],[8,1,8,9],[9,1,9,9],[14,0,14,1]]}
["CONSTRUCTION OF ROAD FROM  FEROZEPUR ROAD TO ANAM ROAD, LAHORE"]
[null,"Contractor:- M/s Stallions Construction Co.",null,null,"Client : LDA",{"$nulls":4},"Consultant: NESPAK (Pvt) Ltd."]
["IPC NO. 03"]
["Dry rammed brick ballast 1.5\" to 2\" gauge  Ch. 6 Page 41 item 2"]
["S.No.","IPC No.","Chainage",null,"No.","Length (ft)","Width (ft)",null,null,"Avg. Thickness (ft)","Quantity (Cft)","Remarks"]
[null,null,"From","To",null,null,"Start","End","Average"]
[null,"New Manhole",null,null,6,3.14,null,null,{"$f":"3.5*3.5","v":12.25},{"v":1,"d":"1.00"},{"$f":"PRODUCT(E7:J7)","v":230.79}]
[null," Total Quantity (Cft) = ",{"$nulls":8},{"$f":"SUM(K7)","v":230.79}]
[null,"Already Paid Quantity (CFT) = ",{"$nulls":8},230.79]
[null,"This Bill Quantity (CFT) = ",{"$nulls":8},{"$f":"K8-K9","v":{"v":0,"d":"0.00"}}]
[]
[]
[]
["Quantity Surveyor:___________________",{"$nulls":8},"Quantity Surveyor:______________"]
["M/s Stallions Construction Co.",{"$nulls":8},"NESPAK (Pvt) Limited"]

{"sheet":"4. Stone Ballast","index":11,"n_rows":16,"n_cols":12,"rows_kept":16,"hidden":true,"merged":[[0,0,0,11],[1,1,1,3],[1,4,1,8],[1,9,1,11],[2,0,2,11],[3,0,3,11],[4,0,5,0],[4,1,5,1],[4,2,4,3],[4,4,5,4],[4,5,5,5],[4,6,4,8],[4,9,5,9],[4,10,5,10],[4,11,5,11],[6,1,6,3],[8,1,8,9],[9,1,9,9],[10,1,10,9],[15,0,15,1]]}
["CONSTRUCTION OF ROAD FROM  FEROZEPUR ROAD TO ANAM ROAD, LAHORE"]
[null,"Contractor:- M/s Stallions Construction Co.",null,null,"Client : LDA",{"$nulls":4},"Consultant: NESPAK (Pvt) Ltd."]
["IPC NO. 03"]
[{"$f":"'Abstract of Cost'!B35","v":"Cement concrete brick or stone  ballast 1.5\" to 2\" gauge, in foundation and plinth ( 1 : 6 : 12) Ch. 6 Page 41 item 3"}]
["S.No.","IPC No.","Chainage",null,"No.","Length (ft)","Width (ft)",null,null,"Avg. Thickness (ft)","Quantity (Cft)","Remarks"]
[null,null,"From","To",null,null,"Start","End","Average"]
[null,"New Manhole",null,null,6,3.14,null,{"v":3,"d":"3.00"},{"v":3,"d":"3.00"},0.75,{"$f":"PRODUCT(E7:J7)","v":127.17}]
[]
[null," Total Quantity (Cft) = ",{"$nulls":8},{"$f":"SUM(K7:K8)","v":127.17}]
[null,"Already Paid Quantity (CFT) = ",{"$nulls":8},127.17]
[null,"This Bill Quantity (CFT) = ",{"$nulls":8},{"$f":"K9-K10","v":{"v":0,"d":"0.00"}}]
[]
[]
[]
["Quantity Surveyor:___________________",{"$nulls":8},"Quantity Surveyor:______________"]
["M/s Stallions Construction Co.",{"$nulls":8},"NESPAK (Pvt) Limited"]

{"sheet":"5. Brickwork","index":12,"n_rows":19,"n_cols":14,"rows_kept":19,"hidden":true,"merged":[[0,0,0,10],[1,1,1,2],[1,3,1,7],[1,8,1,10],[2,0,2,11],[3,0,3,10],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,4,7],[4,8,5,8],[4,9,5,9],[4,10,5,10],[11,1,11,8],[12,1,12,8],[13,1,13,8],[18,0,18,2]]}
["CONSTRUCTION OF ROAD FROM  FEROZEPUR ROAD TO ANAM ROAD, LAHORE"]
[null,"Contractor:- M/s Stallions Construction Co.",null,"Client : LDA",{"$nulls":4},"Consultant: NESPAK (Pvt) Ltd."]
["IPC NO. 03"]
[{"$f":"'Abstract of Cost'!B37","v":"Pacca brick work other than building upto 10ft. (3 m) height. i) cement, sand mortar:- Ratio 1:3 + Extra for pacca brick work in steining of wells or any other circular masonry.(Rs.43,862.40 + Rs.3,707.30)."}]
["S.No.","IPC No.","Date","No.","Length (ft)","Width (ft)",null,null,"Avg. Thickness (ft)","Quantity (Cft)","Remarks"]
[{"$nulls":5},"Start","End","Average"]
[]
[null,null,"Repair of 36\" dia ",22,3.14,null,0.75,{"$f":"(2.58+6.75)/2","v":{"v":4.665,"d":"4.67"}},{"v":3,"d":"3.00"},{"$f":"PRODUCT(D8:I8)","v":{"v":725.08095,"d":"725.08"}},"Dome"]
[null,null,"9\" dia manhole",6,3.14,null,0.75,5.25,1.16,{"$f":"PRODUCT(D9:I9)","v":{"v":86.05169999999998,"d":"86.05"}}]
[null,null,"9\" dia manhole",6,3.14,null,0.75,{"$f":"(2.58+5.25)/2","v":{"v":3.915,"d":"3.92"}},{"v":3,"d":"3.00"},{"$f":"PRODUCT(D10:I10)","v":{"v":165.95684999999997,"d":"165.96"}},"Dome"]
[null,null,"D/D for pipe",-12,3.14,null,{"$f":"1.125/2","v":{"v":0.5625,"d":"0.56"}},{"$f":"1.125/2","v":{"v":0.5625,"d":"0.56"}},0.75,{"$f":"PRODUCT(D11:I11)","v":{"v":-8.941640625,"d":"-8.94"}}]
[null," Total Quantity (Cft) = ",{"$nulls":7},{"$f":"SUM(J8:J11)","v":{"v":968.147859375,"d":"968.15"}},{"$nulls":3},{"$f":"1.125/2","v":0.5625}]
[null,"Already Paid Quantity (CFT) = ",{"$nulls":7},{"v":968.147859375,"d":"968.15"}]
[null,"This Bill Quantity (CFT) = ",{"$nulls":7},{"$f":"J12-J13","v":{"v":0,"d":"0.00"}}]
[]
[]
[]
["Quantity Surveyor:___________________",{"$nulls":7},"Quantity Surveyor:______________"]
["M/s Stallions Construction Co.",{"$nulls":7},"NESPAK (Pvt) Limited"]

{"sheet":"6. Plaster","index":13,"n_rows":19,"n_cols":14,"rows_kept":19,"hidden":true,"merged":[[0,0,0,10],[1,1,1,2],[1,3,1,7],[1,8,1,10],[2,0,2,11],[3,0,3,10],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,4,7],[4,8,5,8],[4,9,5,9],[4,10,5,10],[11,1,11,8],[12,1,12,8],[13,1,13,8],[18,0,18,2]]}
["CONSTRUCTION OF ROAD FROM  FEROZEPUR ROAD TO ANAM ROAD, LAHORE"]
[null,"Contractor:- M/s Stallions Construction Co.",null,"Client : LDA",{"$nulls":4},"Consultant: NESPAK (Pvt) Ltd."]
["IPC NO. 03"]
[{"$f":"'Abstract of Cost'!B39","v":"Cement plaster 1:3 upto 20' (6.00 m) height:-b) ½\" (13 mm) thick"}]
["S.No.","IPC No.","Date","No.","Length (ft)","Width (ft)",null,null,"Avg. Thickness (ft)","Quantity (Cft)","Remarks"]
[{"$nulls":5},"Start","End","Average"]
[]
[null,null,"Repair of 36\" dia ",22,3.14,null,null,{"$f":"(3.33+7.5)/2","v":{"v":5.415,"d":"5.42"}},{"v":3,"d":"3.00"},{"$f":"PRODUCT(D8:I8)","v":{"v":1122.2046,"d":"1122.20"}},"Dome",{"$f":"1.83+0.75+0.75","v":3.33},{"$f":"6.75+0.75","v":7.5},{"$f":"(M8+L8)/2","v":5.415}]
[null,null,"9\" dia manhole",6,3.14,null,null,{"v":6,"d":"6.00"},1.16,{"$f":"PRODUCT(D9:I9)","v":{"v":131.1264,"d":"131.13"}},null,{"$f":"6-1.5","v":4.5}]
[null,null,"9\" dia manhole",6,3.14,null,null,{"$f":"(3.33+6)/2","v":{"v":4.665,"d":"4.67"}},{"v":3,"d":"3.00"},{"$f":"PRODUCT(D10:I10)","v":{"v":263.6658,"d":"263.67"}},"Dome"]
[null,null,"D/D for pipe",-12,3.14,null,null,{"$f":"1.125/2","v":{"v":0.5625,"d":"0.56"}},{"$f":"1.125/2","v":{"v":0.5625,"d":"0.56"}},{"$f":"PRODUCT(D11:I11)","v":{"v":-11.9221875,"d":"-11.92"}},null,{"$f":"0.75+0.16+0.16","v":1.07},{"$f":"1.125/2","v":0.5625}]
[null," Total Quantity (Sft) = ",{"$nulls":7},{"$f":"SUM(J8:J11)","v":{"v":1505.0746125,"d":"1505.07"}}]
[null,"Already Paid Quantity (SFT) = ",{"$nulls":7},{"v":1505.0746125,"d":"1505.07"}]
[null,"This Bill Quantity (SFT) = ",{"$nulls":7},{"$f":"J12-J13","v":{"v":0,"d":"0.00"}}]
[]
[]
[]
["Quantity Surveyor:___________________",{"$nulls":7},"Quantity Surveyor:______________"]
["M/s Stallions Construction Co.",{"$nulls":7},"NESPAK (Pvt) Limited"]

{"sheet":"7.Pointing","index":14,"n_rows":18,"n_cols":14,"rows_kept":18,"hidden":true,"merged":[[0,0,0,10],[1,1,1,2],[1,3,1,4],[1,8,1,10],[2,0,2,11],[3,0,3,10],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,4,7],[4,8,5,8],[4,9,5,9],[4,10,5,10],[10,1,10,8],[11,1,11,8],[12,1,12,8],[17,0,17,2]]}
["CONSTRUCTION OF ROAD FROM  FEROZEPUR ROAD TO ANAM ROAD, LAHORE"]
[null,"Contractor:- M/s Stallions Construction Co.",null,"Client : LDA",{"$nulls":4},"Consultant: NESPAK (Pvt) Ltd."]
["IPC NO. 03"]
[{"$f":"'Abstract of Cost'!B41","v":"Cement pointing flush upto 20' height  in (1:2) Ch. 11 Page 76 item 16"}]
["S.No.","IPC No.","Date","No.","Length (ft)","Width (ft)",null,null,"Avg. Thickness (ft)","Quantity (Cft)","Remarks"]
[{"$nulls":5},"Start","End","Average"]
[null,null,"Repair of 36\" dia ",22,3.14,null,null,{"$f":"(1.83+6)/2","v":{"v":3.915,"d":"3.92"}},{"v":3,"d":"3.00"},{"$f":"PRODUCT(D7:I7)","v":{"v":811.3445999999999,"d":"811.34"}},"Dome",{"$f":"1.83","v":1.83},{"$f":"6","v":6},{"$f":"(M7+L7)/2","v":3.915}]
[null,null,"9\" dia manhole",6,3.14,null,null,{"v":4.5,"d":"4.50"},1.16,{"$f":"PRODUCT(D8:I8)","v":{"v":98.34479999999999,"d":"98.34"}},null,{"$f":"(5+1.83)/2","v":3.415}]
[null,null,"9\" dia manhole",6,3.14,null,null,{"$f":"(1.83+4.5)/2","v":{"v":3.165,"d":"3.17"}},{"v":3,"d":"3.00"},{"$f":"PRODUCT(D9:I9)","v":{"v":178.8858,"d":"178.89"}},"Dome"]
[null,null,"D/D for pipe",-12,3.14,null,null,{"$f":"1.125/2","v":{"v":0.5625,"d":"0.56"}},{"$f":"1.125/2","v":{"v":0.5625,"d":"0.56"}},{"$f":"PRODUCT(D10:I10)","v":{"v":-11.9221875,"d":"-11.92"}},null,{"$f":"0.75+0.16+0.16","v":1.07}]
[null," Total Quantity (Cft) = ",{"$nulls":7},{"$f":"SUM(J7:J10)","v":{"v":1076.6530124999997,"d":"1076.65"}}]
[null,"Already Paid Quantity (CFT) = ",{"$nulls":7},{"v":1076.6530124999997,"d":"1076.65"}]
[null,"This Bill Quantity (CFT) = ",{"$nulls":7},{"$f":"J11-J12","v":{"v":0,"d":"0.00"}}]
[]
[]
[]
["Quantity Surveyor:___________________",{"$nulls":7},"Quantity Surveyor:______________"]
["M/s Stallions Construction Co.",{"$nulls":7},"NESPAK (Pvt) Limited"]

{"sheet":"8. PCC148 ","index":15,"n_rows":27,"n_cols":15,"rows_kept":27,"hidden":true,"merged":[[0,0,0,10],[1,1,1,2],[1,3,1,7],[1,8,1,10],[2,0,2,11],[3,0,3,10],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,4,7],[4,8,5,8],[4,9,5,9],[4,10,5,10],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,8],[20,1,20,8],[21,1,21,8],[26,0,26,2]]}
["CONSTRUCTION OF ROAD FROM  FEROZEPUR ROAD TO ANAM ROAD, LAHORE"]
[null,"Contractor:- M/s Stallions Construction Co.",null,"Client : LDA",{"$nulls":4},"Consultant: NESPAK (Pvt) Ltd."]
["IPC NO. 03"]
[{"$f":"'Abstract of Cost'!B43","v":"Cement concrete plain including placing , compacting finishing and curing complete ( including washing of stone aggregate) Ch. 6 Page 2 item 5) (1:4:8)"}]
["S.No.","IPC No.","Date","No.","Length (ft)","Width (ft)",null,null,"Avg. Thickness (ft)","Quantity (Cft)","Remarks"]
[{"$nulls":5},"Start","End","Average"]
[null,"1400-RD to 1500 RD",null,1,100,null,null,{"v":24.745,"d":"24.75"},{"$f":"2/12","v":{"v":0.16666666666666666,"d":"0.17"}},{"$f":"PRODUCT(D7:I7)","v":{"v":412.41666666666663,"d":"412.42"}}]
[null,"1500 RD to 1600 RD",null,1,{"$f":"E7","v":100},null,null,24.91,{"$f":"2/12","v":{"v":0.16666666666666666,"d":"0.17"}},{"v":415.16666666666663,"d":"415.17"}]
[null,"1600 RD to 1700 RD",null,1,100,null,null,25.71,{"v":0.16666666666666666,"d":"0.17"},{"v":428.5,"d":"428.50"}]
[null,"1700 RD to 1800 RD",null,1,100,null,null,{"v":26,"d":"26.00"},{"v":0.16666666666666666,"d":"0.17"},{"v":433.3333333333333,"d":"433.33"}]
[null,"1800 RD to 1900 RD",null,1,100,null,null,{"v":24.5,"d":"24.50"},{"v":0.16666666666666666,"d":"0.17"},{"$f":"PRODUCT(D11:I11)","v":{"v":408.3333333333333,"d":"408.33"}}]
[null,"1900 RD to 2000 RD",null,1,100,null,null,{"v":23.915,"d":"23.92"},{"v":0.16666666666666666,"d":"0.17"},{"v":398.5833333333333,"d":"398.58"},null,{"$f":"H12-24","v":{"v":-0.08500000000000085,"d":"-0.09"}}]
[null,"2000 RD to 2100 RD",null,1,100,null,null,23.83,{"v":0.16666666666666666,"d":"0.17"},{"v":397.16666666666663,"d":"397.17"},null,{"$f":"H13-24","v":{"v":-0.1700000000000017,"d":"-0.17"}}]
[null,"2100 RD to 2200 RD",null,1,100,null,null,{"v":27.166666666666664,"d":"27.17"},{"v":0.16666666666666666,"d":"0.17"},{"v":452.7777777777777,"d":"452.78"},null,{"$f":"H14-24","v":{"v":3.1666666666666643,"d":"3.17"}}]
[null,"2200 RD to 2300 RD",null,1,100,null,null,{"v":29.166666666666664,"d":"29.17"},{"v":0.16666666666666666,"d":"0.17"},{"v":486.1111111111111,"d":"486.11"}]
[null,"2300 RD to 2370 RD",null,1,100,null,null,{"v":29.166666666666664,"d":"29.17"},{"v":0.16666666666666666,"d":"0.17"},{"$f":"PRODUCT(D16:I16)","v":{"v":486.1111111111111,"d":"486.11"}}]
[null,"Chowk",null,0.5,37,null,null,{"v":30,"d":"30.00"},{"v":0.16666666666666666,"d":"0.17"},{"v":92.5,"d":"92.50"}]
[null,"Deduction Manhole ",null,-28,3.14,null,{"$f":"3.33/2","v":{"v":1.665,"d":"1.67"}},{"$f":"3.33/2","v":{"v":1.665,"d":"1.67"}},{"v":0.16666666666666666,"d":"0.17"},{"$f":"PRODUCT(D18:I18)","v":{"v":-40.622336999999995,"d":"-40.62"}},{"$nulls":4},{"$f":"2370-1400","v":970}]
[null,"Deduction Gully Grating",null,-40,3,null,null,{"v":2.5,"d":"2.50"},{"v":0.16666666666666666,"d":"0.17"},{"$f":"PRODUCT(D19:I19)","v":{"v":-50,"d":"-50.00"}}]
[null," Total Quantity (Cft) = ",{"$nulls":7},{"$f":"SUM(J7:J19)","v":{"v":4320.377663,"d":"4320.38"}}]
[null,"Already Paid Quantity (CFT) = ",{"$nulls":7},{"v":4320.377663,"d":"4320.38"}]
[null,"This Bill Quantity (CFT) = ",{"$nulls":7},{"$f":"J20-J21","v":{"v":0,"d":"0.00"}}]
[]
[]
[]
["Quantity Surveyor:___________________",{"$nulls":7},"Quantity Surveyor:______________"]
["M/s Stallions Construction Co.",{"$nulls":7},"NESPAK (Pvt) Limited"]

{"sheet":"9. Steel R","index":16,"n_rows":21,"n_cols":16,"rows_kept":21,"hidden":true,"merged":[[0,0,0,10],[1,1,1,2],[1,3,1,7],[1,8,1,10],[2,0,2,11],[3,0,3,10],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,4,7],[4,8,5,8],[4,9,5,9],[4,10,5,10],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,8],[13,1,13,8],[14,1,14,8],[15,1,15,8],[16,1,16,8],[17,1,17,8],[20,0,20,2]]}
["CONSTRUCTION OF ROAD FROM  FEROZEPUR ROAD TO ANAM ROAD, LAHORE"]
[null,"Contractor:- M/s Stallions Construction Co.",null,"Client : LDA",{"$nulls":4},"Consultant: NESPAK (Pvt) Ltd."]
["IPC NO. 03"]
[{"$f":"'Abstract of Cost'!B45","v":"Fabrication of mild steel  reinforcement for cement concrete , including cutting ,bending laying in position,  making joints, and fastening including the cost of binding wire and labour charges for binding of steel reinforcement (also includes removal of "}]
["S.No.","IPC No.","Date","No.","Length (ft)","Width (ft)",null,null,"Avg. Thickness (ft)","Quantity (Cft)","Remarks"]
[{"$nulls":5},"Start","End","Average"]
[{"$nulls":3},"Spacing","Dia#","No of Member","No ","Cut Length","Unit Weight in KG","Total Weight in KG"]
[null,"75x24 Panal"]
[null,"Main Bars",null,"7\"c/c",4,2,{"$f":"75/0.58+1","v":{"v":130.31034482758622,"d":"130"}},11.75,{"$f":"(E9*E9/24)/2.204","v":{"v":0.30248033877797936,"d":"0.302"}},{"$f":"PRODUCT(F9:I9)","v":{"v":926.2834553685044,"d":"926.28"}}]
[null,"Disst Bars",null,"7\"c/c",4,2,{"$f":"12/0.58+1","v":{"v":21.689655172413794,"d":"22"}},{"v":75,"d":"75.00"},{"$f":"(E10*E10/24)/2.204","v":{"v":0.30248033877797936,"d":"0.302"}},{"$f":"PRODUCT(F10:I10)","v":{"v":984.1041366793914,"d":"984.10"}},{"$nulls":4},{"$f":"2370-1400","v":970},{"$f":"O10*24","v":{"v":23280,"d":"23280.00"}}]
[null,"Tie Bars",null,"12'' c/c",4,{"v":1,"d":"1.00"},{"v":76,"d":"76.00"},{"v":3,"d":"3.00"},{"$f":"(E11*E11/24)/2.204","v":{"v":0.30248033877797936,"d":"0.302"}},{"$f":"PRODUCT(F11:I11)","v":{"v":68.96551724137929,"d":"68.97"}}]
[null,"Dowel Bars",null,"12'' c/c",8,{"v":2,"d":"2.00"},{"v":12,"d":"12.00"},{"v":3,"d":"3.00"},{"$f":"(E12*E12/24)/2.204","v":{"v":1.2099213551119175,"d":"1.210"}},{"$f":"PRODUCT(F12:I12)","v":{"v":87.11433756805806,"d":"87.11"}}]
[null,"Total Steel in KG for (75x24)=1800 Sft Area",{"$nulls":7},{"$f":"SUM(J9:J12)","v":{"v":2066.467446857333,"d":"2066.47"}},{"$nulls":5},{"$f":"75*24","v":1800}]
[null,"Steel in KG for per Sft",{"$nulls":7},{"$f":"J13/1800","v":{"v":1.1480374704762961,"d":"1.15"}}]
[null,"Regid Area  ",{"$nulls":7},{"v":23282.765978,"d":"23282.77"}]
[null,"Total Steel Qty",{"$nulls":7},{"$f":"J15*J14","v":{"v":26729.487759074687,"d":"26729.49"}}]
[null,"Already Paid",{"$nulls":7},{"v":26729.487759074687,"d":"26729.49"}]
[null,"This Bill",{"$nulls":7},{"$f":"J16-J17","v":{"v":0,"d":"0.00"}}]
[]
["Quantity Surveyor:___________________",{"$nulls":7},"Quantity Surveyor:______________"]
["M/s Stallions Construction Co.",{"$nulls":7},"NESPAK (Pvt) Limited"]

{"sheet":"9. Steel M","index":17,"n_rows":19,"n_cols":16,"rows_kept":19,"hidden":true,"merged":[[0,0,0,10],[1,1,1,2],[1,3,1,7],[1,8,1,10],[2,0,2,11],[3,0,3,10],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,4,7],[4,8,5,8],[4,9,5,9],[4,10,5,10],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,8],[15,1,15,8],[16,1,16,8],[18,0,18,2]]}
["CONSTRUCTION OF ROAD FROM  FEROZEPUR ROAD TO ANAM ROAD, LAHORE"]
[null,"Contractor:- M/s Stallions Construction Co.",null,"Client : LDA",{"$nulls":4},"Consultant: NESPAK (Pvt) Ltd."]
["IPC NO. 03"]
[{"$f":"'Abstract of Cost'!B45","v":"Fabrication of mild steel  reinforcement for cement concrete , including cutting ,bending laying in position,  making joints, and fastening including the cost of binding wire and labour charges for binding of steel reinforcement (also includes removal of "}]
["S.No.","IPC No.","Date","No.","Length (ft)","Width (ft)",null,null,"Avg. Thickness (ft)","Quantity (Cft)","Remarks"]
[{"$nulls":5},"Start","End","Average"]
[{"$nulls":3},"Spacing","Dia#","No","No of Member","Cut Length","Unit Weight in KG","Total Weight in KG"]
[null,"75x24 Panal"]
[null,"Circular Bars Outer",null,null,4,2,28,{"$f":"3.14*3.08","v":{"v":9.6712,"d":"9.67"}},{"$f":"(E9*E9/24)/2.204","v":{"v":0.30248033877797936,"d":"0.302"}},{"$f":"PRODUCT(F9:I9)","v":{"v":163.81947973381727,"d":"163.82"}}]
[null,"Circular Bars Mid",null,null,4,2,28,{"$f":"3.14*2.58","v":{"v":8.1012,"d":"8.10"}},{"v":0.30248033877797936,"d":"0.302"},{"v":137.22540834845734,"d":"137.23"},{"$nulls":4},{"$f":"2370-1400","v":970},{"$f":"O10*24","v":{"v":23280,"d":"23280.00"}}]
[null,"Circular Bars Inner",null,null,4,1,28,{"$f":"3.14*2.16","v":{"v":6.782400000000001,"d":"6.78"}},{"v":0.30248033877797936,"d":"0.302"},{"v":57.44319419237749,"d":"57.44"}]
[null,"Bottom Main Bars",null,null,4,8,28,0.66,{"v":0.30248033877797936,"d":"0.302"},{"v":44.71869328493647,"d":"44.72"}]
[null,"Top Main Bars",null,null,4,8,28,{"v":0.375,"d":"0.38"},{"v":0.30248033877797936,"d":"0.302"},{"v":25.408348457350268,"d":"25.41"}]
[null,"Vertical Bars",null,null,0,8,28,{"v":0.375,"d":"0.38"},{"v":0,"d":"0.000"},{"v":0,"d":"0.00"}]
[null,"Total Steel in KG ",{"$nulls":7},{"$f":"SUM(J9:J14)","v":{"v":428.61512401693886,"d":"428.62"}},{"$nulls":5},{"$f":"75*24","v":1800}]
[null,"Already Paid",{"$nulls":7},{"v":428.61512401693886,"d":"428.62"},{"$nulls":5},{"$f":"75*24","v":1800}]
[null,"This Bill",{"$nulls":7},{"$f":"J15-J16","v":{"v":0,"d":"0.00"}},{"$nulls":5},{"$f":"75*24","v":1800}]
["Quantity Surveyor:___________________",{"$nulls":7},"Quantity Surveyor:______________"]
["M/s Stallions Construction Co.",{"$nulls":7},"NESPAK (Pvt) Limited"]

{"sheet":"10. RCC ","index":18,"n_rows":30,"n_cols":15,"rows_kept":30,"hidden":true,"merged":[[0,0,0,10],[1,1,1,2],[1,3,1,7],[1,8,1,10],[2,0,2,11],[3,0,3,10],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,4,7],[4,8,5,8],[4,9,5,9],[4,10,5,10],[6,1,6,2],[7,1,7,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[15,1,15,2],[16,1,16,2],[17,1,17,2],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,8],[23,1,23,8],[24,1,24,8],[29,0,29,2]]}
["CONSTRUCTION OF ROAD FROM  FEROZEPUR ROAD TO ANAM ROAD, LAHORE"]
[null,"Contractor:- M/s Stallions Construction Co.",null,"Client : LDA",{"$nulls":4},"Consultant: NESPAK (Pvt) Ltd."]
["IPC NO. 03"]
[{"$f":"'Abstract of Cost'!B47","v":"Providing and laying reinforceed cement concrete (including pre stressed concrete), using coarse sand and screened graded and washed aggregate , in required shape and design, including form moulds, shuttering, lifting, compacting, curing, rendering,and fi b) Precast reinforced cement concrete and prestressed reinforced cement concrete in columns, beams, lintels, stair cases, shelves, etc. :- a (1:1.5:3)"}]
["S.No.","IPC No.","Date","No.","Length (ft)","Width (ft)",null,null,"Avg. Thickness (ft)","Quantity (Cft)","Remarks"]
[{"$nulls":5},"Start","End","Average"]
[null,"1400-RD to 1500 RD",null,1,100,null,null,{"v":24,"d":"24.00"},{"$f":"8/12","v":{"v":0.6666666666666666,"d":"0.67"}},{"$f":"PRODUCT(D7:I7)","v":{"v":1600,"d":"1600.00"}},null,{"v":24.745,"d":"24.75"}]
[null,"1500 RD to 1600 RD",null,1,{"$f":"E7","v":100},null,null,{"v":24,"d":"24.00"},{"v":0.6666666666666666,"d":"0.67"},{"v":1600,"d":"1600.00"},null,24.91]
[null,"1600 RD to 1700 RD",null,1,100,null,null,{"v":24,"d":"24.00"},{"v":0.6666666666666666,"d":"0.67"},{"v":1600,"d":"1600.00"},null,25.71]
[null,"1700 RD to 1800 RD",null,1,100,null,null,{"v":24,"d":"24.00"},{"v":0.6666666666666666,"d":"0.67"},{"v":1600,"d":"1600.00"},null,{"v":26,"d":"26.00"}]
[null,"1800 RD to 1900 RD",null,1,100,null,null,{"v":24,"d":"24.00"},{"v":0.6666666666666666,"d":"0.67"},{"v":1600,"d":"1600.00"},null,{"v":24.5,"d":"24.50"}]
[null,"1900 RD to 2000 RD",null,1,{"$f":"E11","v":100},null,null,{"v":23.915,"d":"23.92"},{"v":0.6666666666666666,"d":"0.67"},{"v":1594.3333333333333,"d":"1594.33"},null,{"v":23.915,"d":"23.92"}]
[null,"2000 RD to 2100 RD",null,1,100,null,null,{"v":24,"d":"24.00"},{"v":0.6666666666666666,"d":"0.67"},{"v":1600,"d":"1600.00"},null,23.83]
[null,"2100 RD to 2200 RD",null,1,100,null,null,{"v":24,"d":"24.00"},{"v":0.6666666666666666,"d":"0.67"},{"v":1600,"d":"1600.00"},null,{"v":27.166666666666664,"d":"27.17"}]
[null,"2200 RD to 2300 RD",null,1,100,null,null,{"v":24,"d":"24.00"},{"v":0.6666666666666666,"d":"0.67"},{"v":1600,"d":"1600.00"},null,{"v":29.166666666666664,"d":"29.17"}]
[null,"2300 RD to 2370 RD",null,1,70,null,null,{"v":24,"d":"24.00"},{"v":0.6666666666666666,"d":"0.67"},{"$f":"PRODUCT(D16:I16)","v":{"v":1120,"d":"1120.00"}},null,{"v":29.166666666666664,"d":"29.17"}]
[null,"1400 to 2370",null,0.5,37,null,null,{"v":30,"d":"30.00"},{"v":0.6666666666666666,"d":"0.67"},{"$f":"PRODUCT(D17:I17)","v":{"v":370,"d":"370.00"}}]
[null,"Deduction Manhole ",null,-28,3.14,null,{"$f":"3.33/2","v":{"v":1.665,"d":"1.67"}},{"$f":"3.33/2","v":{"v":1.665,"d":"1.67"}},{"v":0.6666666666666666,"d":"0.67"},{"v":-162.48934799999998,"d":"-162.49"},{"$nulls":4},{"$f":"2370-1400","v":970}]
[null,"Deduction Gully Grating",null,-40,3,null,null,{"v":2.5,"d":"2.50"},{"v":0.6666666666666666,"d":"0.67"},{"v":-200,"d":"-200.00"}]
[null,"Deduction Theremopore",null,-13,24,null,null,0.08,{"v":0.6666666666666666,"d":"0.67"},-16.64]
[null,"Deduction Marble Strip",null,-624,24,null,null,0.03,{"v":0.125,"d":"0.13"},-56.16,null,null,1.83,{"$f":"1.83+1.5","v":3.33}]
[null,"Around Manhole",null,28,3.14,null,2.58,0.75,{"v":0.6666666666666666,"d":"0.67"},{"v":113.4168,"d":"113.42"},{"$nulls":3},{"$f":"(M21+N21)/2","v":2.58}]
[null," Total Quantity (Cft) = ",{"$nulls":7},{"$f":"SUM(J7:J22)","v":{"v":15562.460785333336,"d":"15562.46"}}]
[null,"Already Paid Quantity (CFT) = ",{"$nulls":7},{"v":15562.460785333336,"d":"15562.46"}]
[null,"This Bill Quantity (CFT) = ",{"$nulls":7},{"$f":"J23-J24","v":{"v":0,"d":"0.00"}}]
[]
[]
[]
["Quantity Surveyor:___________________",{"$nulls":7},"Quantity Surveyor:______________"]
["M/s Stallions Construction Co.",{"$nulls":7},"NESPAK (Pvt) Limited"]

{"sheet":"11.UPVC","index":19,"n_rows":19,"n_cols":13,"rows_kept":19,"hidden":true,"merged":[[0,0,0,10],[1,1,1,2],[1,3,1,7],[1,8,1,10],[2,0,2,11],[3,0,3,10],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,4,7],[4,8,5,8],[4,9,5,9],[4,10,5,10],[11,1,11,8],[12,1,12,8],[13,1,13,8],[18,0,18,2]]}
["CONSTRUCTION OF ROAD FROM  FEROZEPUR ROAD TO ANAM ROAD, LAHORE"]
[null,"Contractor:- M/s Stallions Construction Co.",null,"Client : LDA",{"$nulls":4},"Consultant: NESPAK (Pvt) Ltd."]
["IPC NO. 03"]
[{"$f":"'Abstract of Cost'!B50","v":"Providing, fixing, testing and commissioning of µ-PVC (Unplasticized Polyvinyl Chloride ) Nikasi/ waste pipe make of Dadex /Popular/Beta or equivalent, plain /socket ended conforming to code EN-1329 of specified SDR (Standard Dimension Ratio) including the cost of specials and Solvents complete in all respect as approved and directed by the Engineer Incharge. Ch 19 Page 118 Item 47 b (2\" Dia)"}]
["S.No.","IPC No.","Date","No.","Length (ft)","Width (ft)",null,null,"Avg. Thickness (ft)","Quantity (Cft)","Remarks"]
[{"$nulls":5},"Start","End","Average"]
[]
[null,null,"1400 to 2370",{"$f":"13*24","v":312},1.5,{"$nulls":4},{"$f":"E8*D8","v":{"v":468,"d":"468.00"}},"Update",null,{"$f":"970/75","v":12.933333333333334}]
[]
[]
[]
[null,"Total Quantity (RFT) = ",{"$nulls":7},{"$f":"SUM(J8:J11)","v":{"v":468,"d":"468.00"}}]
[null,"Already Paid Quantity (RFT) = ",{"$nulls":7},{"v":468,"d":"468.00"}]
[null,"This Bill Quantity (RFT) = ",{"$nulls":7},{"$f":"J12-J13","v":{"v":0,"d":"0.00"}}]
[]
[]
[]
["Quantity Surveyor:___________________",{"$nulls":7},"Quantity Surveyor:______________"]
["M/s Stallions Construction Co.",{"$nulls":7},"NESPAK (Pvt) Limited"]

{"sheet":"12 RCC Cover","index":20,"n_rows":17,"n_cols":11,"rows_kept":17,"merged":[[0,0,0,10],[1,1,1,2],[1,3,1,7],[1,8,1,10],[2,0,2,11],[3,0,3,10],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,4,7],[4,8,5,8],[4,9,5,9],[4,10,5,10],[9,1,9,8],[10,1,10,8],[11,1,11,8],[16,0,16,3]]}
[{"$f":"+'2.Sub Base'!A1:O1","v":"PROJECT NAME"}]
[null,"Contractor:- ",null,"Client : ",{"$nulls":4},"Consultant: "]
["IPC NO. 03"]
[{"$f":"'Abstract of Cost'!B54","v":"Providing and fixing, 6\" (150 mm) thick R.C.C. manhole cover for  22\" as per standard drawing STD/PD No. 6 of 1977, complete in all respects.  I/C FRAME COMPLETE IN \nALL RESPECT"}]
["S.No.","IPC No.","Date","No.","Length (ft)","Width (ft)",null,null,"Avg. Thickness (ft)","Quantity (Cft)","Remarks"]
[{"$nulls":5},"Start","End","Average"]
[{"$nulls":3},28,{"$nulls":5},{"$f":"D7","v":{"v":28,"d":"28.00"}}]
[]
[]
[null," Total Quantity (Each) = ",{"$nulls":7},{"$f":"SUM(J7:J9)","v":{"v":28,"d":"28.00"}}]
[null,"Already Paid Quantity (Each) = "]
[null,"This Bill Quantity (Each) = ",{"$nulls":7},{"$f":"J10-J11","v":{"v":28,"d":"28.00"}}]
[]
[]
[]
["Quantity Surveyor:___________________",{"$nulls":7},"Quantity Surveyor:______________"]
["Contractor:",{"$nulls":7},"Consultant:"]

{"sheet":"Analysis Rcc cover 6\"","index":21,"n_rows":8,"n_cols":6,"rows_kept":8,"merged":[[0,0,0,5]]}
["ANALYSIS OF RATE FOR  OF MANHOLE COVER I/C FRAME COMPLETE IN \nALL RESPECT"]
["MRS REF","Description","Rate","Quantity","Amount","Unit"]
["Chapter-21 Item 17","Providing and fixing, 6\" (150 mm) thick R.C.C. manhole cover for  22\" as per standard drawing STD/PD No. 6 of 1977, complete in all respects.",{"v":7949.9,"d":"7949.90"},{"v":1,"d":"1.00"},{"$f":"D3*C3","v":{"v":7949.9,"d":"7949.90"}},"Each"]
["Chapter-21 Item 14"," Fixing manhole frame and cover in R.C.C. slab including carriage to site.",537.25,{"v":1,"d":"1.00"},{"$f":"D4*C4","v":537.25},"Each"]
["NPUT RATES OF MATERIAL FOR 1st BI-ANNUAL-2024 (01.01.2024 TO 30.06.2024) 18.014  ","T.Iron and M.S Flat",{"$f":"259","v":{"v":259,"d":"259.00"}},{"v":25,"d":"25.00"},{"v":6475,"d":"6475.00"},"KG"]
[null,"Total",null,null,{"$f":"SUM(E3:E5)","v":14962.15}]
[null,"Add 20 % contractor profit on item no 3",null,null,{"$f":"E5*20%","v":{"v":1295,"d":"1295.00"}}]
[null," Rate Per No ",null,null,{"$f":"SUM(E6:E7)","v":16257.15},"Per Set"]

{"sheet":"13.RCC Pipe 9\"","index":22,"n_rows":19,"n_cols":13,"rows_kept":19,"hidden":true,"merged":[[0,0,0,10],[1,1,1,2],[1,3,1,7],[1,8,1,10],[2,0,2,11],[3,0,3,10],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,4,7],[4,8,5,8],[4,9,5,9],[4,10,5,10],[11,1,11,8],[12,1,12,8],[13,1,13,8],[18,0,18,2]]}
["CONSTRUCTION OF ROAD FROM  FEROZEPUR ROAD TO ANAM ROAD, LAHORE"]
[null,"Contractor:- M/s Stallions Construction Co.",null,"Client : LDA",{"$nulls":4},"Consultant: NESPAK (Pvt) Ltd."]
["IPC NO. 03"]
[{"$f":"'Abstract of Cost'!B56","v":"Providing and laying R.C.C. pipe, moulded with cement  concrete 1:1½:3, with spigot socket or collar joint, etc. including cost of reinforcement, conforming to B.S. 5911: Part I: 1981, Class \"L\" including carriage of pipe from factory to site of work, lowering in trenches to correct alignment and grade, jointing, cutting pipes where necessary, finishing and testing, etc., complete. Chapter - 21 Page 136 Item 01 (9\" dia)"}]
["S.No.","IPC No.","Date","No.","Length (ft)","Width (ft)",null,null,"Avg. Thickness (ft)","Quantity (Cft)","Remarks"]
[{"$nulls":5},"Start","End","Average"]
[]
[null,null,"1400 to 2370",1,256,{"$nulls":4},{"$f":"E8*D8","v":{"v":256,"d":"256.00"}},null,null,{"$f":"970/75","v":12.933333333333334}]
[{"$nulls":3},1,56,{"$nulls":4},{"$f":"E9*D9","v":{"v":56,"d":"56.00"}}]
[]
[]
[null,"Total Quantity (RFT) = ",{"$nulls":7},{"$f":"SUM(J8:J11)","v":{"v":312,"d":"312.00"}}]
[null,"Already Paid Quantity (RFT) = ",{"$nulls":7},{"v":312,"d":"312.00"}]
[null,"This Bill Quantity (RFT) = ",{"$nulls":7},{"$f":"J12-J13","v":{"v":0,"d":"0.00"}}]
[]
[]
[]
["Quantity Surveyor:___________________",{"$nulls":7},"Quantity Surveyor:______________"]
["M/s Stallions Construction Co.",{"$nulls":7},"NESPAK (Pvt) Limited"]

{"sheet":"14. Select Fill","index":23,"n_rows":16,"n_cols":14,"rows_kept":16,"hidden":true,"merged":[[0,0,0,10],[1,1,1,2],[1,3,1,7],[1,8,1,10],[2,0,2,11],[3,0,3,10],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,4,7],[4,8,5,8],[4,9,5,9],[4,10,5,10],[6,1,6,2],[7,1,7,2],[8,1,8,8],[9,1,9,8],[10,1,10,8],[15,0,15,2]]}
["CONSTRUCTION OF ROAD FROM  FEROZEPUR ROAD TO ANAM ROAD, LAHORE"]
[null,"Contractor:- M/s Stallions Construction Co.",null,"Client : LDA",{"$nulls":4},"Consultant: NESPAK (Pvt) Ltd."]
["IPC NO. 03"]
[{"$f":"'Abstract of Cost'!B58","v":"P/L of Select Fill material  including ploughing and mixing with blade grade or disc harrow or other suitable equipment and compaction by mechanical means at OMC and dressing to designed section, complete in all respect 95% to 100% maximum modified AASHTO dry-density with vibratory roller.Mixing, Moisterning earth to optimum moisture contant in layer etc. complete with tractor complete with rotorator blade."}]
["S.No.","IPC No.","Date","No.","Length (ft)","Width (ft)",null,null,"Avg. Thickness (ft)","Quantity (Cft)","Remarks"]
[{"$nulls":5},"Start","End","Average"]
[null,"Rcc Pipe 9\" dia",null,1,{"$f":"312-42","v":270},null,null,2.25,2.92,{"$f":"PRODUCT(D7:I7)","v":{"v":1773.8999999999999,"d":"1773.90"}}]
[null,"Deduction of Pipe Dia",null,{"$f":"-312+42","v":-270},3.14,null,null,{"$f":"1.08/2","v":0.54},{"$f":"1.08/2","v":0.54},{"$f":"PRODUCT(D8:I8)","v":{"v":-247.21848000000006,"d":"-247.22"}},{"$nulls":3},{"$f":"312-42","v":270}]
[null," Total Quantity (Cft) = ",{"$nulls":7},{"$f":"SUM(J7:J8)","v":{"v":1526.6815199999999,"d":"1526.68"}}]
[null,"Already Paid Quantity (CFT) = ",{"$nulls":7},{"v":1526.6815199999999,"d":"1526.68"}]
[null,"This Bill Quantity (CFT) = ",{"$nulls":7},{"$f":"J9-J10","v":{"v":0,"d":"0.00"}}]
[]
[]
[]
["Quantity Surveyor:___________________",{"$nulls":7},"Quantity Surveyor:______________"]
["M/s Stallions Construction Co.",{"$nulls":7},"NESPAK (Pvt) Limited"]

{"sheet":"15.Desilting","index":24,"n_rows":18,"n_cols":13,"rows_kept":18,"hidden":true,"merged":[[0,0,0,10],[1,1,1,2],[1,3,1,7],[1,8,1,10],[2,0,2,11],[3,0,3,10],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,4,7],[4,8,5,8],[4,9,5,9],[4,10,5,10],[10,1,10,8],[11,1,11,8],[12,1,12,8],[17,0,17,2]]}
["CONSTRUCTION OF ROAD FROM  FEROZEPUR ROAD TO ANAM ROAD, LAHORE"]
[null,"Contractor:- M/s Stallions Construction Co.",null,"Client : LDA",{"$nulls":4},"Consultant: NESPAK (Pvt) Ltd."]
["IPC NO. 03"]
[{"$f":"'Abstract of Cost'!B60","v":"Desilting of Sewer through winch machine including hire chargfes for two No. winch machines, operator for operating of winch machines, POL, etc.complete in all respects. Sewer 36\" Dia"}]
["S.No.","IPC No.","Date","No.","Length (ft)","Width (ft)",null,null,"Avg. Thickness (ft)","Quantity (Cft)","Remarks"]
[{"$nulls":5},"Start","End","Average"]
[null,null,"36\" dia sewer",1,800,{"$nulls":4},{"$f":"E7*D7","v":{"v":800,"d":"800.00"}},null,null,{"$f":"970/75","v":12.933333333333334}]
[null,null,"One side Anum Road",1,800,{"$nulls":4},{"$f":"E8*D8","v":{"v":800,"d":"800.00"}},null,null,{"$f":"970/75","v":12.933333333333334}]
[null,null,"Other sdie Anum Road",1,800,{"$nulls":4},{"$f":"E9*D9","v":{"v":800,"d":"800.00"}},null,null,{"$f":"970/75","v":12.933333333333334}]
[null,null,"Feroze Pur road",1,1000,{"$nulls":4},{"$f":"E10*D10","v":{"v":1000,"d":"1,000.00"}},null,null,{"$f":"970/75","v":12.933333333333334}]
[null,"Total Quantity (RFT) = ",{"$nulls":7},{"$f":"SUM(J7:J10)","v":{"v":3400,"d":"3400.00"}}]
[null,"Already Paid Quantity (RFT) = ",{"$nulls":7},{"v":3400,"d":"3400.00"}]
[null,"This Bill Quantity (RFT) = ",{"$nulls":7},{"$f":"J11-J12","v":{"v":0,"d":"0.00"}}]
[]
[]
[]
["Quantity Surveyor:___________________",{"$nulls":7},"Quantity Surveyor:______________"]
["M/s Stallions Construction Co.",{"$nulls":7},"NESPAK (Pvt) Limited"]

{"sheet":"16. theremopore","index":25,"n_rows":16,"n_cols":15,"rows_kept":16,"hidden":true,"merged":[[0,0,0,10],[1,1,1,2],[1,3,1,7],[1,8,1,10],[2,0,2,11],[3,0,3,10],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,4,7],[4,8,5,8],[4,9,5,9],[4,10,5,10],[8,1,8,8],[9,1,9,8],[10,1,10,8],[15,0,15,2]]}
["CONSTRUCTION OF ROAD FROM  FEROZEPUR ROAD TO ANAM ROAD, LAHORE"]
[null,"Contractor:- M/s Stallions Construction Co.",null,"Client : LDA",{"$nulls":4},"Consultant: NESPAK (Pvt) Ltd."]
["IPC NO. 03"]
[{"$f":"'Abstract of Cost'!B62","v":"Providing and fixing theremopore (foamed polythene)\n sheet in horizontal and vertical expansion joints:  a) 1\" (25 mm) thick thermopore sheet"}]
["S.No.","IPC No.","Date","No.","Length (ft)","Width (ft)",null,null,"Avg. Thickness (ft)","Quantity (Cft)","Remarks"]
[{"$nulls":5},"Start","End","Average"]
[{"$nulls":14},{"$f":"970/75","v":12.933333333333334}]
[null,null,"1400 to 2370",13,24,{"$nulls":3},0.66,{"$f":"PRODUCT(D8:I8)","v":{"v":205.92000000000002,"d":"205.92"}},null,{"$f":"1.83+0.75+0.75","v":3.33},{"$f":"6.75+0.75","v":7.5},{"$f":"(M8+L8)/2","v":5.415}]
[null," Total Quantity (Sft) = ",{"$nulls":7},{"$f":"SUM(J8:J8)","v":{"v":205.92000000000002,"d":"205.92"}}]
[null,"Already Paid Quantity (SFT) = ",{"$nulls":7},{"v":205.92000000000002,"d":"205.92"}]
[null,"This Bill Quantity (SFT) = ",{"$nulls":7},{"$f":"J9-J10","v":{"v":0,"d":"0.00"}}]
[]
[]
[]
["Quantity Surveyor:___________________",{"$nulls":7},"Quantity Surveyor:______________"]
["M/s Stallions Construction Co.",{"$nulls":7},"NESPAK (Pvt) Limited"]

{"sheet":"17. Bailing","index":26,"n_rows":40,"n_cols":11,"rows_kept":40,"hidden":true,"merged":[[0,0,0,10],[1,1,1,3],[1,6,1,8],[1,9,1,10],[2,0,2,10],[3,0,3,10],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,6,5,6],[4,7,5,7],[4,8,5,8],[4,9,5,9],[4,10,5,10],[33,1,33,8],[34,1,34,8],[39,0,39,3]]}
["CONSTRUCTION OF ROAD FROM  FEROZEPUR ROAD TO ANAM ROAD, LAHORE"]
[null,"Contractor:- M/s Stallions Construction Co.",{"$nulls":4},"   Client : LDA",null,null,"Consultant: NESPAK (Pvt) Ltd."]
["IPC NO. 02"]
[{"$f":"'Abstract of Cost'!#REF!","v":{"$error":"#REF!"}}]
["S.No.","IPC No.","ReQ.No","Date","No of Pups","Day","Hours","Min","Sec","Quantity (Cft)","Remarks"]
[]
[{"$nulls":3},"27.08.2024",1,{"v":1,"d":"1.00"},{"v":8,"d":"8.00"},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"$f":"E7*F7*G7*H7*I7","v":{"v":28800,"d":"28,800.00"}},"03 Pumps"]
[{"$nulls":3},"28.08.2024",1,{"v":1,"d":"1.00"},{"v":8,"d":"8.00"},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"$f":"E8*F8*G8*H8*I8","v":{"v":28800,"d":"28,800.00"}}]
[{"$nulls":3},"29.08.2024",1,{"v":1,"d":"1.00"},{"v":8,"d":"8.00"},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"v":28800,"d":"28,800.00"}]
[{"$nulls":3},"30.08.2024",1,{"v":1,"d":"1.00"},{"v":8,"d":"8.00"},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"v":28800,"d":"28,800.00"}]
[{"$nulls":3},"31.08.2024",1,{"v":1,"d":"1.00"},{"v":8,"d":"8.00"},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"v":28800,"d":"28,800.00"}]
[{"$nulls":3},"01.09.2024",1,{"v":1,"d":"1.00"},{"v":8,"d":"8.00"},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"v":28800,"d":"28,800.00"}]
[{"$nulls":3},"02.09.2024",1,{"v":1,"d":"1.00"},{"v":8,"d":"8.00"},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"v":28800,"d":"28,800.00"}]
[{"$nulls":3},"03.09.2024",1,{"v":1,"d":"1.00"},{"v":8,"d":"8.00"},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"v":28800,"d":"28,800.00"}]
[{"$nulls":3},"04.09.2024",1,{"v":1,"d":"1.00"},{"v":8,"d":"8.00"},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"v":28800,"d":"28,800.00"}]
[{"$nulls":3},"05.09.2024",1,{"v":1,"d":"1.00"},{"v":8,"d":"8.00"},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"v":28800,"d":"28,800.00"}]
[{"$nulls":3},"06.09.2024",1,{"v":1,"d":"1.00"},{"v":8,"d":"8.00"},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"v":28800,"d":"28,800.00"}]
[{"$nulls":3},"07.09.2024",1,{"v":1,"d":"1.00"},{"v":8,"d":"8.00"},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"v":28800,"d":"28,800.00"}]
[{"$nulls":3},"08.09.2024",1,{"v":1,"d":"1.00"},{"v":8,"d":"8.00"},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"v":28800,"d":"28,800.00"}]
[{"$nulls":3},"09.09.2024",1,{"v":1,"d":"1.00"},{"v":8,"d":"8.00"},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"v":28800,"d":"28,800.00"}]
[{"$nulls":3},"10.09.2024",1,{"v":1,"d":"1.00"},{"v":8,"d":"8.00"},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"v":28800,"d":"28,800.00"}]
[{"$nulls":3},"11.09.2024",1,{"v":1,"d":"1.00"},{"v":8,"d":"8.00"},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"v":28800,"d":"28,800.00"}]
[{"$nulls":3},"12.09.2024",1,{"v":1,"d":"1.00"},{"v":8,"d":"8.00"},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"v":28800,"d":"28,800.00"}]
[{"$nulls":3},"13.09.2024",1,{"v":1,"d":"1.00"},{"v":8,"d":"8.00"},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"v":28800,"d":"28,800.00"}]
[{"$nulls":3},"14.09.2024",1,{"v":1,"d":"1.00"},{"v":8,"d":"8.00"},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"v":28800,"d":"28,800.00"}]
[{"$nulls":3},"15.09.2024",1,{"v":1,"d":"1.00"},{"v":8,"d":"8.00"},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"v":28800,"d":"28,800.00"}]
[{"$nulls":3},"16.09.2024",1,{"v":1,"d":"1.00"},{"v":8,"d":"8.00"},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"v":28800,"d":"28,800.00"}]
[{"$nulls":3},"17.09.2024",1,{"v":1,"d":"1.00"},{"v":8,"d":"8.00"},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"v":28800,"d":"28,800.00"}]
[{"$nulls":3},"18.09.2024",1,{"v":1,"d":"1.00"},{"v":8,"d":"8.00"},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"v":28800,"d":"28,800.00"}]
[{"$nulls":3},"19.09.2024",1,{"v":1,"d":"1.00"},{"v":8,"d":"8.00"},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"v":28800,"d":"28,800.00"}]
[{"$nulls":3},"20.09.2024",1,{"v":1,"d":"1.00"},{"v":8,"d":"8.00"},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"v":28800,"d":"28,800.00"}]
[{"$nulls":3},"21.09.2024",1,{"v":1,"d":"1.00"},{"v":8,"d":"8.00"},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"v":28800,"d":"28,800.00"}]
[{"$nulls":3},"22.09.2024",1,{"v":1,"d":"1.00"},{"v":8,"d":"8.00"},{"v":60,"d":"60.00"},{"v":60,"d":"60.00"},{"v":28800,"d":"28,800.00"}]
[null," Total Quantity (Cft) = ",{"$nulls":7},{"$f":"SUM(J7:J33)","v":{"v":777600,"d":"777,600.00"}}]
[null,"80% efficiency of pump",{"$nulls":7},{"$f":"J34*80%","v":{"v":622080,"d":"622,080.00"}}]
[]
[]
[]
["Quantity Surveyor:___________________",{"$nulls":6},"Quantity Surveyor:___________________"]
["M/s Stallions Construction Co.",{"$nulls":6},"NESPAK (Pvt) Limited"]

{"sheet":"18.Marble Strip","index":27,"n_rows":15,"n_cols":13,"rows_kept":15,"hidden":true,"merged":[[0,0,0,10],[1,1,1,2],[1,3,1,7],[1,8,1,10],[2,0,2,11],[3,0,3,10],[4,0,5,0],[4,1,5,1],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,4,7],[4,8,5,8],[4,9,5,9],[4,10,5,10],[7,1,7,8],[8,1,8,8],[9,1,9,8],[14,0,14,2]]}
["CONSTRUCTION OF ROAD FROM  FEROZEPUR ROAD TO ANAM ROAD, LAHORE"]
[null,"Contractor:- M/s Stallions Construction Co.",null,"Client : LDA",{"$nulls":4},"Consultant: NESPAK (Pvt) Ltd."]
["IPC NO. 03"]
[{"$f":"'Abstract of Cost'!B64","v":"Providing and fixing marble strip of any shade for dividing\n the mosaic flooring into panels a) Size 1½\" x 3/8\" (40 x 10 mm)"}]
["S.No.","IPC No.","Date","No.","Length (ft)","Width (ft)",null,null,"Avg. Thickness (ft)","Quantity (Cft)","Remarks"]
[{"$nulls":5},"Start","End","Average"]
[null,null,"1400 to 2370",26,24,{"$nulls":4},{"$f":"E7*D7","v":{"v":624,"d":"624.00"}},null,null,{"$f":"970/25","v":38.8}]
[null,"Total Quantity (RFT) = ",{"$nulls":7},{"$f":"SUM(J7:J7)","v":{"v":624,"d":"624.00"}},null,null,{"$f":"M7/3","v":12.933333333333332}]
[null,"Already Paid Quantity (RFT) = ",{"$nulls":7},{"v":624,"d":"624.00"},null,null,{"$f":"M8*2","v":25.866666666666664}]
[null,"This Bill Quantity (RFT) = ",{"$nulls":7},{"$f":"J8-J9","v":{"v":0,"d":"0.00"}}]
[]
[]
[]
["Quantity Surveyor:___________________",{"$nulls":7},"Quantity Surveyor:______________"]
["M/s Stallions Construction Co.",{"$nulls":7},"NESPAK (Pvt) Limited"]

{"sheet":"Dis of Pcc Analysis","index":28,"n_rows":21,"n_cols":5,"rows_kept":21,"hidden":true,"merged":[[0,0,0,3],[1,0,1,3],[13,3,13,4],[14,3,14,4],[16,0,16,1],[17,0,17,1],[18,0,18,1]]}
["Rate Analysis For Dismantling of PCC i/c removal from site up to 5 km"]
["MRS, 1st BI-ANNUAL-2024 (01.01.2024 to 30.06.2024)DISTRICT LAHORE"]
["MRS REF","Description","Rate","Unit"]
["Ch:4 Item 19 ( C )"," Dismantling cement concrete 1:2:4",15681.6,"100 Cft"]
["Ch:1 Item 1 1st KM","Carriage of 100 Cft. (2.83 cu.m) of all materials like stone aggregate, spawl, kankar lime (unslaked), surkhi, etc. or 150 Cft. (4.25 cu.m) of timber, by truck or by any other means owned by the contractor. 1st KM",352.65,"100 Cft"]
[null,"2nd KM",168.65]
[null,"3rd KM",132.75]
[null,"4th KM",94.9]
[null,"5th KM",88.75]
[null,"6th KM"]
[null,"Total",{"$f":"SUM(C4:C9)","v":{"v":16519.3,"d":"16519.30"}},"100 Cft"]
[]
[]
[]
[]
[null,"1000 cft",null,null,{"v":12672.6,"d":"12,672.60"}]
["1st 400 m",null,1,5410.5,{"$f":"D17*C17","v":{"v":5410.5,"d":"5410.50"}}]
["0.4 KM to 1.6 KM PER 100 M",null,12,22.05,{"$f":"D18*C18","v":264.6}]
["1.6 KM to 8 KM PER 400 M",null,16,378.25,{"$f":"D19*C19","v":6052}]
[{"$nulls":4},-202.89]
[{"$nulls":4},{"$f":"SUM(E16:E20)","v":{"v":24196.809999999998,"d":"24,196.81"}}]