{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Schedule A","Summary"],"not_rendered":{"defined_names":14},"read":"whole","date_system":"1900"}

{"sheet":"Schedule A","index":0,"n_rows":39,"n_cols":9,"rows_kept":39,"merged":[[1,1,1,6],[2,1,2,6],[3,1,3,6],[4,1,4,6],[5,1,5,6],[21,2,21,5],[27,2,27,5],[32,2,32,5],[37,2,37,5],[38,2,38,5],[39,1,39,6]]}
[]
[null,"C2.2 PRICING SCHEDULE"]
[null,{"$f":"_Hlk64538433","v":"CONTRACT SANRAL R.030-080-2016/1ENV"}]
[null,"FOR ENVIRONMENTAL SUBSERVICES FOR THE IMPROVEMENT OF NATIONAL ROAD R30 SECTION 8 FROM KM 36.8 TO VENTERSDORP KM 68.646"]
[null,"SCHEDULE A"]
[null,"Section 3200: Services Required in Project Design Phase",{"$nulls":6},"CONTRACT SANRAL R.030-080-2016/1ENV"]
[null,"Item","Description","Unit","Quantity","Rate (R)","Amount (R)",null,"FOR ENVIRONMENTAL SUBSERVICES ON THE IMPROVEMENT OF NATIONAL ROAD R30 SECTION 8 FROM KM 36.8 TO VENTERSDORP KM 68.646"]
[]
[null,32.01,"Basic Assessment Process: "]
[]
[null,"(a)","Pre-Application Phase"]
[null,"(a)(i)","Screening and Site Verification Report","LS",1,null,{"$f":"ROUND(F12*E12,2)","v":0}]
[]
[null,"(c)","Basic Assessment Phase: "]
[null,"(c)(i)","Undertake Basic Assessment Process & compile draft report & specific EMPr","LS",1,null,{"$f":"ROUND(F15*E15,2)","v":0}]
[null,"(c)(ii)","Prepare and submit Final Basic Assessment Report and specific EMPr","LS",1,null,{"$f":"ROUND(F16*E16,2)","v":0}]
[null,"(c)(iii)","Notify Interested and Affected Parties","LS",1,null,{"$f":"ROUND(F17*E17,2)","v":0}]
[]
[null,"(d)","Appeal Process"]
[null,"(d)(i)","Prepare draft Response to Appeal/s","Hours",30,null,{"$f":"ROUND(F20*E20,2)","v":0}]
[]
[null,32.01,"Carried forward to payment section summary",{"$nulls":3},{"$f":"ROUND(SUM(G9:G21),2)","v":{"v":0,"d":"0.00"}}]
[]
[null,32.03,"Specialist Studies"]
[null,"(a)","Fee for specialist studies","PS",1,{"v":100000,"d":"100,000.00"},{"$f":"ROUND(F25*E25,2)","v":{"v":100000,"d":"100,000.00"}}]
[null,"(b)","Handling cost i.r.o. sub item 32.07 (a) and (b)","% ",{"$f":"G25","v":{"v":100000,"d":"100,000.00"}},null,{"$f":"ROUND(F26*E26,2)","v":0}]
[]
[null,32.03,"Carried forward to payment section summary",{"$nulls":3},{"$f":"ROUND(SUM(G24:G27),2)","v":{"v":100000,"d":"100,000.00"}}]
[]
[null,32.04,"Authoririsations/aprrovals for Material sources"]
[null,"(a)","Price per Borrow Pit /Quarry","LS",5,null,{"$f":"ROUND(F31*E31,2)","v":0}]
[]
[null,32.04,"Carried forward to payment section summary",{"$nulls":3},{"$f":"ROUND(SUM(G30:G32),2)","v":{"v":0,"d":"0.00"}}]
[]
[null,32.05,"Water Use Authorisation:"]
[null,"(a)","Register water use/s in terms of applicable General Authorisation","LS",1,null,{"$f":"ROUND(F36*E36,2)","v":0}]
[]
[null,32.05,"Carried forward to payment section summary",{"$nulls":3},{"$f":"ROUND(SUM(G35:G37),2)","v":{"v":0,"d":"0.00"}}]
[null,"C3200","Carried forward to Pricing Schedule summary\nSection 3200: Services Required in Project Design Phase",{"$nulls":3},{"$f":"G22+G28+G33+G38","v":{"v":100000,"d":"100,000.00"}}]

{"sheet":"Summary","index":1,"n_rows":22,"n_cols":5,"rows_kept":22,"merged":[[2,2,2,4],[3,2,5,4],[6,2,6,4],[10,2,10,3],[12,2,12,3],[14,2,14,3],[17,2,18,4],[21,2,22,4]]}
[]
[null,null,"CONTRACT SANRAL R.030-080-2016/1ENV"]
[null,null,"FOR ENVIRONMENTAL SUBSERVICES FOR THE IMPROVEMENT OF NATIONAL ROAD R30 SECTION 8 FROM KM 36.8 TO VENTERSDORP KM 68.646"]
[null,null,"C2.3 SUMMARY OF PRICING SCHEDULE"]
[]
[]
[null,null,"SCHEDULE A SUMMARY - R30-8"]
[]
[null,null,3200,"Services required in project design phase",{"$f":"'Schedule A'!G39","v":{"v":100000,"d":"R100,000.00"}}]
[]
[null,null,"SCHEDULE A SUB TOTAL",null,{"$f":"SUM(E9:E10)","v":{"v":100000,"d":"R100,000.00"}}]
[]
[null,null,"VAT (15%)",null,{"$f":"E11*15%","v":{"v":15000,"d":"R15,000.00"}}]
[]
[null,null,"QUOTATION SUM CARRIED FORWARD TO FORM OF QUOTATION",null,{"$f":"SUM(E11:E13)","v":{"v":115000,"d":"R115,000.00"}}]
[]
[]
[null,null,"NAME OF TENDERER: "]
[]
[]
[]
[null,null,"SIGNED BY TENDERER: "]