{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Pricing Schedule","Summary of Pricing Schedule"],"read":"whole","date_system":"1900"}

{"sheet":"Pricing Schedule","index":0,"n_rows":104,"n_cols":7,"rows_kept":104,"merged":[[0,1,0,6],[1,1,1,6],[2,1,2,6]]}
[null,"THE SOUTH AFRICAN NATIONAL ROADS AGENCY SOC LIMITED"]
[null,"CONTRACT SANRAL N.003-010-2017/9 - ENV"]
[null,"FOR ENVIRONMENTAL SUBSERVICES ON CAPACITY IMPROVEMENTS ON NATIONAL ROUTE 3 SECTION 1 FROM WESTVILLE VIADUCT (KM 11.80) TO PARADISE VALLEY INTERCHANGE (KM 17.54)"]
[]
[null,"C2.2 PRICING SCHEDULE"]
[]
[]
[null,"Item",null,"Unit","Quantity","Rate \nR","Amount \nR"]
[null,"C 3200:"," Services Required in Project Design Phase"]
[]
[null,32.01,"Basic Assessment Process"]
[]
[null,"(a)","Pre-Application Phase"]
[null,"(a)(i)","Screening and Site Verification Report","LS",0,null,{"$f":"E14*F14","v":0}]
[null,null," "]
[null,"(c)","Basic Assessment Phase"]
[null,"(c)(i)","Undertake Basic Assessment Process & compile draft report & specific EMPr","LS",0,null,{"$f":"E17*F17","v":0}]
[null,"(c)(ii)","Prepare and submit Final Basic Assessment Report and specific EMPr","LS",0,null,{"$f":"E18*F18","v":0}]
[null,"(c)(iii)","Notify Interested and affected Parties","LS",0,null,{"$f":"E19*F19","v":0}]
[]
[null,"(d)","Appeal Process"]
[null,"(d)(i)","Prepare draft Response to Appeal/s","Hour",0,null,{"$f":"E22*F22","v":0}]
[]
[null,"Sub total","Carried forward to Payment Section Summary",{"$nulls":3},{"$f":"SUM(G14,G17,G18,G19,G22)","v":0}]
[]
[null,32.02,"Scoping and Environmental Impact Assessment Process"]
[]
[null,"(b)","Pre-Application Phase"]
[null,"(b)(i)","Screening and Site Verification","LS",0,null,{"$f":"E29*F29","v":0}]
[]
[null,"(c)","Scoping Phase "]
[null,"(c)(i)","Undertake Scoping Process & compile draft Scoping Report","LS",0,null,{"$f":"E32*F32","v":0}]
[null,"(c)(ii)","Finalise and submit Final Scoping Report","LS",0,null,{"$f":"E33*F33","v":0}]
[]
[null,"(d)","Impact Assessment Phase"]
[null,"(d)(i)","Prepare and submit Draft Impact Assessment Report ","LS",0,null,{"$f":"E36*F36","v":0}]
[null,"(d)(ii)","Prepare and submit Final Impact Assessment Report","LS",0,null,{"$f":"E37*F37","v":0}]
[null,"(d)(iii)","Notify Interested and Affected Parties        ","LS",0,null,{"$f":"E38*F38","v":0}]
[]
[null,"(e)","Appeal Process"]
[null,"(e)(i)","Prepare draft response to appeal/s","Hour",0,null,{"$f":"E41*F41","v":0}]
[]
[null,"Sub-total","Carried forward to Payment Section Summary",{"$nulls":3},{"$f":"SUM(G29,G32,G33,G36,G37,G38,G41)","v":0}]
[]
[null,32.03,"Specialist Studies"]
[null,"(a)","Fee for specialist studies","PS",0,null,{"$f":"E46*F46","v":0}]
[null,"(b)","Handling costs i.r.o sub-item 32.03 (a)","%",0,null,{"$f":"E47*F47","v":0}]
[]
[null,32.04,"Authorisations/Approvals for Material Sources "]
[null,"(a)","Price per Borrow Pit/Quarry","LS",0,null,{"$f":"E50*F50","v":0}]
[]
[null,"Sub-total","Carried forward to Payment Section Summary",{"$nulls":3},{"$f":"SUM(G46,G47,G50)","v":0}]
[]
[null,32.05,"Water Use Authorisation"]
[null,"(a)","Register water use/s in terms of applicable General Authorisation","LS",2,null,{"$f":"E55*F55","v":0}]
[]
[null,"Sub-total","Carried forward to Payment Section Summary",{"$nulls":3},{"$f":"SUM(G55)","v":0}]
[]
[null,"TOTAL","Carried forward to Pricing Schedule summary",{"$nulls":3},{"$f":"SUM(G57,G52,G43,G24)","v":0}]
[]
[null,"C 3300:"," Services required in Project Construction Phase"]
[null,33.01,"Monitoring Phase"]
[]
[null,"(a)","Environmental Awareness Training (once-off)","LS",1,null,{"$f":"E64*F64","v":0}]
[null,"(b)","Monthly Audits by ECO","No.",51,null,{"$f":"E65*F65","v":0}]
[null,"(c)","Submission of the monthly audit reports to DFFE (Director: Compliance Monitoring)","No.",51,null,{"$f":"E66*F66","v":0}]
[null,"(d)","Attending monthly Progress Meeting","No.",24,null,{"$f":"E67*F67","v":0}]
[]
[null,"Sub-total","Carried forward to Payment Section Summary",{"$nulls":3},{"$f":"SUM(G64:G67)","v":0}]
[]
[null,"TOTAL","Carried forward to Pricing Schedule summary",{"$nulls":3},{"$f":"SUM(G64:G67)","v":0}]
[]
[null,"C 3400: ","Other Services  "]
[null,34.01,"Closure of Material Sources"]
[null,"(a)","Borrow pits and/or quarries","No.",0,null,{"$f":"E75*F75","v":0}]
[]
[null,"Sub-total","Carried forward to Payment Section Summary",{"$nulls":3},{"$f":"G75","v":0}]
[]
[null,"TOTAL","Carried forward to Pricing Schedule Summary",{"$nulls":3},{"$f":"SUM(G75)","v":0}]
{"$rows_empty":24}
[null,"TOTAL","Carried forward to Summary of Pricing Schedule ",{"$nulls":3},{"$f":"SUM(G77,G71,G57,G52,G43,G24)","v":0}]

{"sheet":"Summary of Pricing Schedule","index":1,"n_rows":21,"n_cols":4,"rows_kept":21,"merged":[[0,1,0,3],[1,1,1,3],[2,1,2,3]]}
[null,"THE SOUTH AFRICAN NATIONAL ROADS AGENCY SOC LIMITED"]
[null,"CONTRACT SANRAL N.003-010-2017/9 - ENV"]
[null,"FOR ENVIRONMENTAL SUBSERVICES ON CAPACITY IMPROVEMENTS ON NATIONAL ROUTE 3 SECTION 1 FROM WESTVILLE VIADUCT (KM 11.80) TO PARADISE VALLEY INTERCHANGE (KM 17.54)"]
[]
[]
[null,"C2.3","SUMMARY OF PRICING SCHEDULE","AMOUNT"]
[]
[null,3200,"Services required in project design phase",{"$f":"'Pricing Schedule'!G59","v":0}]
[]
[null,3300,"Services required in project construction phase",{"$f":"'Pricing Schedule'!G71","v":0}]
[]
[null,3400,"Other Services",{"$f":"'Pricing Schedule'!G79","v":0}]
[]
[]
[]
[null,"SUB TOTAL",null,{"$f":"D12+D10+D8","v":0}]
[]
[null,"VAT (15%)",null,{"$f":"D16*15%","v":0}]
[]
[]
[null,"TENDER SUM CARRIED FORWARD TO FORM OF OFFER (C1.1.1)",null,{"$f":"D18+D16","v":0}]