{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["JMT"],"read":"whole","date_system":"1900"}

{"sheet":"JMT","index":0,"n_rows":54,"n_cols":6,"rows_kept":54,"merged":[[0,1,0,5],[7,1,7,4],[12,1,12,4],[17,1,17,4],[24,1,24,4],[31,1,31,4],[37,1,37,4],[40,1,40,5],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[47,1,47,2],[49,1,49,2],[51,1,51,2],[53,1,53,3]]}
["JMT","Pricing Schedule"]
["Services by Disciplines as per the Activity Schedule"]
["ITEM","Description","Unit","Quantity","Rate","Amount"]
["3.2.1","Project Manager - Personnel"]
[null,"a) Construction Project Manager","Hour",1000,null,{"$f":"D5*E5","v":{"v":0,"d":"R0.00"}}]
["3.2.4","Construction Health and Safety Agent - Personnel"]
[null,"a) Construction Health and Safety Agent","Hour",800,null,{"$f":"D7*E7","v":{"v":0,"d":"R0.00"}}]
[null,"Subtotal",{"$nulls":3},{"$f":"SUM(F5:F7)","v":{"v":0,"d":"R0.00"}}]
[]
["ITEM","Description","Unit","Quantity","Rate","Amount"]
["3.2.2","Civil Engineer (Pavements) - Personnel"]
[null,"a) Category B","Hour",1000,null,{"$f":"D12*E12","v":{"v":0,"d":"R0.00"}}]
[null,"Subtotal",{"$nulls":3},{"$f":"SUM(F12:F12)","v":{"v":0,"d":"R0.00"}}]
[]
["ITEM","Description","Unit","Quantity","Rate","Amount"]
["3.2.3","Quantity Surveyor - Personnel"]
[null,"a) Principals","Hour",1000,null,{"$f":"D17*E17","v":{"v":0,"d":"R0.00"}}]
[null,"Subtotal",{"$nulls":3},{"$f":"SUM(F17:F17)","v":{"v":0,"d":"R0.00"}}]
[]
["ITEM","Description","Unit","Quantity","Rate","Amount"]
[null,"Provisional Sum - Additional Works"]
["3.2.7","a) Professional Structural Engineer","Prov. Sum (PS)",1,{"v":150000,"d":"R150,000.00"},{"$f":"D22*E22","v":{"v":150000,"d":"R150,000.00"}}]
[{"$f":"A22","v":"3.2.7"},"b) Professional Electrical Engineer","Prov. Sum (PS)",1,{"v":100000,"d":"R100,000.00"},{"$f":"D23*E23","v":{"v":100000,"d":"R100,000.00"}}]
["3.3.2.1","c) Environmental Assessment Practitioner (EAP) ","Prov. Sum (PS)",1,{"v":150000,"d":"R150,000.00"},{"v":150000,"d":"R150,000.00"}]
[null,"Subtotal",{"$nulls":3},{"$f":"SUM(F22:F24)","v":{"v":400000,"d":"R400,000.00"}}]
[]
["ITEM","Description","Unit","Quantity","Rate","Amount"]
["3.2.5","Construction Monitoring"]
[null,"a) Resident Engineer - Pavements","Month",6,null,{"$f":"E29*D29","v":{"v":0,"d":"R0.00"}}]
[null,"b) Assistant Resident Engineer - Pavements","Month",6,null,{"$f":"E30*D30","v":{"v":0,"d":"R0.00"}}]
[null,"c) Disbursments i.r.t. 3.2.6 personnel","Prov. Sum (PS)",1,{"v":300000,"d":"R300,000.00"},{"v":300000,"d":"R300,000.00"}]
[null,"Subtotal",{"$nulls":3},{"$f":"SUM(F29:F31)","v":{"v":300000,"d":"R300,000.00"}}]
[]
["ITEM","Miscellaneous","Unit","Quantity","Rate","Amount"]
["3.2.6",{"$f":"B34","v":"Miscellaneous"}]
[null,"a) Airport Permits and Parking etc.","Prov. Sum (PS)",1,{"v":100000,"d":"R100,000.00"},{"$f":"E36*D36","v":{"v":100000,"d":"R100,000.00"}}]
[null,"b) Disbursement","Prov. Sum (PS)",1,{"v":100000,"d":"R100,000.00"},{"$f":"E37*D37","v":{"v":100000,"d":"R100,000.00"}}]
[null,"Subtotal",{"$nulls":3},{"$f":"SUM(F36:F37)","v":{"v":200000,"d":"R200,000.00"}}]
[]
[]
["C2.3","Summary of Pricing Schedule"]
[]
["3.2.2.","Main Services (Activity 1 to 6)",{"$nulls":3},{"$f":"F8+F13+F18+F25","v":{"v":400000,"d":"R400,000.00"}}]
[{"$f":"A28","v":"3.2.5"},{"$f":"B28","v":"Construction Monitoring"},{"$nulls":3},{"$f":"F32","v":{"v":300000,"d":"R300,000.00"}}]
[{"$f":"A35","v":"3.2.6"},{"$f":"B35","v":"Miscellaneous"},{"$nulls":3},{"$f":"F38","v":{"v":200000,"d":"R200,000.00"}}]
[null,"Subtotal",{"$nulls":3},{"$f":"SUM(F43:F45)","v":{"v":900000,"d":"R900,000.00"}}]
[]
[null,"Contigencies (10%)",{"$nulls":3},{"$f":"0.1*F46","v":{"v":90000,"d":"R90,000.00"}}]
[]
[null,"Subtotal (Excl. VAT)",{"$nulls":3},{"$f":"F48+F46","v":{"v":990000,"d":"R990,000.00"}}]
[]
[null,"Vat (15%)",{"$nulls":3},{"$f":"F50*0.15","v":{"v":148500,"d":"R148,500.00"}}]
[]
[null,"Total Amount/ Tender Sum (Carried to Form of Offer C.1.1.1)",{"$nulls":3},{"$f":"F52+F50","v":{"v":1138500,"d":"R1,138,500.00"}}]