{"text_format":"3","workbook":"xlsx","n_sheets":10,"sheets":["Adhoc Water Quality ","Saldanha","Cape Town","Mossel Bay","Port Elizabeth","Ngqura","East London","Durban","Richards Bay","Bid Summary"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"Adhoc Water Quality ","index":0,"n_rows":71,"n_cols":28,"rows_kept":71,"merged":[[0,0,14,3],[0,4,0,9],[15,0,17,0],[15,1,17,1],[15,2,17,2],[15,3,17,3],[15,4,15,6],[15,7,15,9],[15,10,15,12],[15,13,15,15],[15,16,15,18],[15,19,15,21],[15,22,15,24],[15,25,15,27],[17,4,17,27],[18,0,19,0],[21,0,25,0],[26,0,33,0],[34,0,35,0],[36,0,41,0],[42,0,47,0],[48,0,69,0],[70,0,70,3]]}
["Notes: \na) A summary table of analytes to be analysed as per the South African Water Quality Guidelines for Coastal Marine Waters: Natural Environment and Mariculture Use for ad hoc chemical and microbiological laboratory analysis is provided below to guide the paramaters that should be priced.  \nb) Bidder should populate the Unit Price column for each parameter to be analysed for all the ports. \nc) Bidders must note that the input of unit prices in this sheet auto-populate in the individual Port sheets for line item \"10 SAMPLE COLLECTION AND ANALYSIS FOR AD HOC WATER QUALITY (POLLUTION INVESTIGATION)\".\nd) Bidders are required to input rates only in green shaded cells."]
{"$rows_empty":14}
["Catergory ","Parameter ","Unit","Limit","Saldahna",null,null,"Cape Town",null,null,"Mossel Bay",null,null,"Port Elizabeth",null,null,"Ngqura",null,null,"East London",null,null,"Durban",null,null,"Richards Bay"]
[{"$nulls":4},"Quanity","Unit Price","YR1 Price (Exc VAT)","Quanity","Unit Price","YR1 Price (Exc VAT)","Quanity","Unit Price","YR1 Price (Exc VAT)","Quanity","Unit Price","YR1 Price (Exc VAT)","Quanity","Unit Price","YR1 Price (Exc VAT)","Quanity","Unit Price","YR1 Price (Exc VAT)","Quanity","Unit Price","YR1 Price (Exc VAT)","Quanity","Unit Price","YR1 Price (Exc VAT)"]
[]
["Conventional (laboratory) Calibrated desktop water quality meter","Salinity",null,0.01,10,null,{"$f":"E19*F19","v":0},10,null,{"$f":"H19*I19","v":0},10,null,{"$f":"K19*L19","v":0},10,null,{"$f":"N19*O19","v":0},10,null,{"$f":"Q19*R19","v":0},10,null,{"$f":"T19*U19","v":0},10,null,{"$f":"W19*X19","v":0},10,null,{"$f":"Z19*AA19","v":0}]
[null,"pH",null,0.01,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
["Microalgal biomass (laboratory)\n­\t750 mL filtered sample\n­\t24 hr 90% acetone extraction\n­\tCalibrated desktop fluorometer","Chlorophyll-a","µg/L",0.025,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
["Nutrients (dissolved) (laboratory)\n­\tSyringe filter in field\n­\tAnalysed using an autoanalyser","Ammonia","µg/L",5,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,"Nitrate","µg/L",1,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,"Nitrite","µg/L",5,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,"Orthophosphate","µg/L",5,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,"Silica","µg/L",25,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
["Metals (dissolved) (laboratory)\n­\tSyringe filter in field\n­\tAnalysed using ICP-MS, ICP-OES, and Flow Injection Mercury System","Arsenic","µg/L",0.5,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,"Cadmium","µg/L",0.2,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,"Copper","µg/L",1,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,"Chromium","µg/L",0.5,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,"Manganese","µg/L",2,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,"Mercury","µg/L",0.04,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,"Lead","µg/L",0.2,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,"Zinc","µg/L",5,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
["Microbiology (discrete samples)\n­\tAutoclaved sample containers","E. coli","cfu","1-10",10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,"Faecal streptococci","cfu","1-10",10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
["Total recoverable hydrocarbons (laboratory)\n­\tPreserve with sulphuric acid\n­\tGas Chromatograph-Flame Ionisation Detection","C6-C10 ","µg/L",20,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,"C6-C10 minus BTEXN ","µg/L",20,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,">C10-C16 ","µg/L",100,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,">C10-C16 minus Naphthalene","µg/L",100,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,">C16-C34 ","µg/L",100,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,">C34-C40 ","µg/L",100,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
["BTEXN (laboratory)\n­\tPreserve with sulphuric acid\n­\tGas Chromatograph-Mass Spectrometry ","Benzene","µg/L",1,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,"Toluene","µg/L",2,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,"Ethylbenzene","µg/L",2,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,"meta- and para-Xylene","µg/L",2,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,"ortho-Xylene","µg/L",2,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,"Naphthalene","µg/L",5,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
["Polycyclic aromatic hydrocarbons (laboratory)\n­\tGas Chromatograph-Mass Spectrometry ","3-Methylcholanthrene ","µg/L",0.1,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,"2-Methylnaphthalene","µg/L",0.1,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,"7,12-Dimethylbenz(a)anthracene ","µg/L",0.1,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,"Naphthalene","µg/L",0.1,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,"Acenaphthylene","µg/L",0.1,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,"Acenaphthene","µg/L",0.1,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,"Fluorene","µg/L",0.1,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,"Phenanthrene","µg/L",0.1,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,"Anthracene","µg/L",0.1,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,"Fluoranthene","µg/L",0.1,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,"Pyrene","µg/L",0.1,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,"Benz(a)anthracene","µg/L",0.1,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,"Chrysene","µg/L",0.1,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,"Benzo(b+j)fluoranthene","µg/L",0.1,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,"Benzo(k)fluoranthene","µg/L",0.1,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,"Benzo(a)pyrene","µg/L",0.05,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,"Indeno(1,2,3-cd)pyrene","µg/L",0.1,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,"Dibenz(a,h)anthracene","µg/L",0.1,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,"Benzo(g,h,i)perylene","µg/L",0.1,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,"Benzo(e)pyrene","µg/L",0.1,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,"Coronene","µg/L",0.1,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
[null,"Perylene","µg/L",0.1,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0,10,null,0]
["Sub Total ",{"$nulls":5},{"$f":"SUM(G19:G70)","v":0},null,null,{"$f":"SUM(J19:J70)","v":0},null,null,{"$f":"SUM(M19:M70)","v":0},null,null,{"$f":"SUM(P19:P70)","v":0},null,null,{"$f":"SUM(S19:S70)","v":0},null,null,{"$f":"SUM(V19:V70)","v":0},null,null,{"$f":"SUM(Y19:Y70)","v":0},null,null,{"$f":"SUM(AB19:AB70)","v":0}]

{"sheet":"Saldanha","index":1,"n_rows":47,"n_cols":7,"rows_kept":47,"merged":[[1,1,1,6],[2,1,2,6],[3,1,3,6],[4,1,16,6],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,5],[25,1,28,1],[29,1,29,4],[32,1,32,2],[32,4,40,6]]}
[]
[null,"SALDANHA"]
[null,"PROVISION OF THE MARINE LONG-TERM ECOLOGICAL MONITORING PROGRAM FOR THE PORTS OF RICHARDS BAY, DURBAN, EAST LONDON, NGQURA, \nPORT ELIZABETH, MOSSEL BAY, CAPE TOWN AND SALDANHA FOR FIVE (5) YEARS "]
[null,"SECTION 4: PRICING AND DELIVERY SCHEDULE"]
[null,"Pricing Notes: \n\na) Bidder must ensure that the pricing is inclusive of all related costs, including 3 replicates taken for each sediment sample as per standard practice. Any cost not specified in the pricing schedule will not be considered/accepted by Transnet.\nb) Respondents are to note that if the price offered by the highest scoring bidder is not market-related, Transnet may not award the contract to that Respondent.     \nTransnet may:\n(i) negotiate a market-related price with the Respondent scoring the highest points or cancel the RFP;\n(ii) if that Respondent does not agree to a market-related price, negotiate a market-related price with the Respondent scoring the second highest points or cancel the RFP;\n(iii) if the Respondent scoring the second highest points does not agree to a market-related price, negotiate a market-related price with the Respondent scoring the third highest points or cancel the RFP.\n(iv) If a market-related price is not agreed with the Respondent scoring the third highest points, Transnet must cancel the RFP.\nc) Prices must be quoted in South African Rand inclusive of VAT.\nd) Disbursements not specifically priced for will not be considered/accepted by Transnet. The overall cost quoted shall be inclusive of all travel and accommodation costs that will be required to complete the scope of work in full per respective port (where applicable). Accommodation and Flights shall be arranged at Government Rates (3-star accommodation) and Economy Class Flights and Basic Car Hire (Group B). Disbursements will be reimbursed at cost price upon presentation of an undisputed invoice. Any disbursement invoiced that is not in line with the aforementioned guidelines will not be accepted by Transnet for payment.  Bidders may be required to provide a detailed breakdown of projected disbursement costs upon request by Transnet prior to finalisation of award.\ne) To facilitate like-for-like comparison bidders must submit pricing strictly in accordance with this pricing schedule and not utilise a different format. Deviation from this pricing schedule or not quoting on every line item for all eight Ports will result in a bid being declared non-responsive.\nf) Respondents, if awarded the contract, are required to indicate that their prices quoted for Year 1 would be kept firm and fixed. Escalations from Year 2 to Year 5 must be capped at CPI projection percentages YR2 3.1%, YR3.0%, YR4 2.9%, YR5 3.0% respectively. The contract price for Year 2 to Year 5 will be revised based on actual inflation increases as published by the Stats SA.\ng) Bidders are required to input prices exclusive of VAT in the green shaded cells. The sheet contains a formula for calculation of subtotals, grand total and VAT. \nh)Totals will automatically be reflected on the bid summary sheet. "]
{"$rows_empty":13}
[null,"Description",null,"Unit of Measure","Quanity","Rate","YEAR 1 (Excl. VAT)\n"]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 24 SAMPLING POINTS FOR SEDIMENT - WINTER\n*All materials, equipment, analysis & labour required for sediments must be considered as per the proposed scope of work. The standard practice is to collect 3 replicate per grab samples, which should be composited for physical and chemical analysis in the lab. ",null,"Sum",1,null,{"$f":"F20*E20","v":{"v":0,"d":"R0.00"}}]
[null,"10 SAMPLE COLLECTION AND ANALYSIS FOR AD HOC WATER QUALITY (POLLUTION INVESTIGATION)\n*All materials, equipment, analysis & labour required for water quality must be considered as per the proposed scope of work",null,"Sum",1,null,{"$f":"'Adhoc Water Quality '!G71","v":{"v":0,"d":"R0.00"}}]
[null,"REPORT COMPILATION \n*The bidder will submit a total of 2 reports in a year, the first report will be the Sediment Quality analysis results, mainly used for the Dredging Permit application and then the full report at the end of the year for all the monitoring done. ",null,"Sum",1,null,{"$f":"F22*E22","v":{"v":0,"d":"R0.00"}}]
[null,"SAFETY FILE\n*Contractor compliance checklist to include all Ports specific requirements (incl. the annual compliance updates as and when required for the duration of the contract)",null,"EA",1,null,{"v":0,"d":"R0.00"}]
[null,"Sub-Total YR 1 ",{"$nulls":4},{"$f":"SUM(G20:G23)","v":{"v":0,"d":"R0.00"}}]
[null,null,"Item","Unit of Measure","Quanity","Rate","YEAR 1  (Excl. VAT)"]
[null,"Disbursements \n* The disbursement cost will be based on an estimated cost per year for each port. But will be paid based on actual cost incured inline with the above price notes  ","Flights (Economy class)","Sum",1,null,{"$f":"F26*E26","v":{"v":0,"d":"R0.00"}}]
[null,null,"Accommodation (3-star) ","Sum",1,null,{"$f":"F27*E27","v":{"v":0,"d":"R0.00"}}]
[null,null,"Car Hire (Group B)","Sum",1,null,{"v":0,"d":"R0.00"}]
[null,null,"Parking","Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"Total Price for all Disbursement (ZAR) (Excl. VAT). Refer to pricing notes above*",{"$nulls":4},{"$f":"SUM(G26:G29)","v":{"v":0,"d":"R0.00"}}]
[]
[]
[null,"Sub-Totals (Excl. VAT)",null,null,"Pricing Note – Escalation Formula\n\nYear 1 (YR1): The price is fixed, with no escalation applied.\n\nYear 2 (YR2): Escalation of 3.1% is applied to the full YR1 subtotal. Formula:\nYR2 = YR1 × (1 + 3.1%)\n\nYear 3 (YR3): Escalation of 3.0% is applied to the full YR2 subtotal. Formula:\nYR3 = YR2 × (1 + 3.0%)\n\nYear 4 (YR4): Escalation of 2.9% is applied to the full YR3 subtotal. Formula:\nYR4 = YR3 × (1 + 2.9%)\n\nYear 5 (YR5): Escalation of 3.0% is applied to the full YR4 subtotal. Formula:\nYR5 = YR4 × (1 + 3.0%)"]
["A","Port of Saldanha",{"$f":"SUM(G24:G24)","v":{"v":0,"d":"R0.00"}}]
["B","Disbursements",{"$f":"SUM(G30:G30)","v":{"v":0,"d":"R0.00"}}]
["C","Subtotal YR1 (Excl. VAT) [A+B]",{"$f":"SUM(C34:C35)","v":{"v":0,"d":"R0.00"}}]
["D","YR2 Escalation at 3.1%",{"$f":"C36*(1+3.1%)","v":{"v":0,"d":"R0.00"}}]
["E","YR3 Escalation at 3.0%",{"$f":"C37*(1+3%)","v":{"v":0,"d":"R0.00"}}]
["F","YR4 Escalation at 2.9%",{"$f":"C38*(1+2.9%)","v":{"v":0,"d":"R0.00"}}]
["G","YR5 Escalation at 3.0%",{"$f":"C39*(1+3%)","v":{"v":0,"d":"R0.00"}}]
["H","Total carried to Bid summary [C+D+E+F-G]",{"$f":"SUM(C36:C40)","v":{"v":0,"d":"R0.00"}}]
[]
[]
[null,"Bidder: "]
[null,"Bidder Respresentative Name: "]
[null,"Signature:"]
[null,"VAT registered (Yes / No):"]

{"sheet":"Cape Town","index":2,"n_rows":52,"n_cols":7,"rows_kept":52,"merged":[[1,1,1,6],[2,1,2,6],[3,1,3,6],[4,1,16,6],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,5],[30,1,33,1],[34,1,34,4],[37,1,37,2],[37,4,45,6]]}
[]
[null,"CAPE TOWN"]
[null,"PROVISION OF THE MARINE LONG-TERM ECOLOGICAL MONITORING PROGRAM FOR THE PORTS OF RICHARDS BAY, DURBAN, EAST LONDON, NGQURA, \nPORT ELIZABETH, MOSSEL BAY, CAPE TOWN AND SALDANHA FOR FIVE (5) YEARS "]
[null,"SECTION 4: PRICING AND DELIVERY SCHEDULE"]
[null,"Pricing Notes: \n\na) Bidder must ensure that the pricing is inclusive of all related costs, including 3 replicates taken for each sediment and benthic sample as per standard practice. Any cost not specified in the pricing schedule will not be considered/accepted by Transnet.\nb) Respondents are to note that if the price offered by the highest scoring bidder is not market-related, Transnet may not award the contract to that Respondent.     \nTransnet may:\n(i) negotiate a market-related price with the Respondent scoring the highest points or cancel the RFP;\n(ii) if that Respondent does not agree to a market-related price, negotiate a market-related price with the Respondent scoring the second highest points or cancel the RFP;\n(iii) if the Respondent scoring the second highest points does not agree to a market-related price, negotiate a market-related price with the Respondent scoring the third highest points or cancel the RFP.\n(iv) If a market-related price is not agreed with the Respondent scoring the third highest points, Transnet must cancel the RFP.\nc) Prices must be quoted in South African Rand inclusive of VAT.\nd) Disbursements not specifically priced for will not be considered/accepted by Transnet. The overall cost quoted shall be inclusive of all travel and accommodation costs that will be required to complete the scope of work in full per respective port (where applicable). Accommodation and Flights shall be arranged at Government Rates (3-star accommodation) and Economy Class Flights and Basic Car Hire (Group B). Disbursements will be reimbursed at cost price upon presentation of an undisputed invoice. Any disbursement invoiced that is not in line with the aforementioned guidelines will not be accepted by Transnet for payment.  Bidders may be required to provide a detailed breakdown of projected disbursement costs upon request by Transnet prior to finalisation of award.\ne) To facilitate like-for-like comparison bidders must submit pricing strictly in accordance with this pricing schedule and not utilise a different format. Deviation from this pricing schedule or not quoting on every line item for all eight Ports will result in a bid being declared non-responsive.\nf) Respondents, if awarded the contract, are required to indicate that their prices quoted for Year 1 would be kept firm and fixed. Escalations from Year 2 to Year 5 must be capped at CPI projection percentages YR2 3.1%, YR3.0%, YR4 2.9%, YR5 3.0% respectively. The contract price for Year 2 to Year 5 will be revised based on actual inflation increases as published by the Stats SA.\ng) Bidders are required to input prices exclusive of VAT in the green shaded cells. The sheet contains a formula for calculation of subtotals, grand total and VAT. \nh)Totals will automatically be reflected on the bid summary sheet. "]
{"$rows_empty":13}
[null,"Description",null,"Unit of Measure","Quanity","Rate","YEAR 1 (Excl. VAT)\n"]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 17 SAMPLING POINTS FOR SEDIMENT - WINTER\n*All materials, equipment, analysis & labour required for sediments must be considered as per the proposed scope of work. The standard practice is to collect 3 replicate per grab samples, which should be composited for physical and chemical analysis in the lab and then 3 replicate per grab samples for benthic microfauna, which will be analysed as separate samples in the lab.",null,"Sum",1,null,{"$f":"E20*F20","v":{"v":0,"d":"R0.00"}}]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 12 SAMPLING POINTS FOR WATER QUALITY (PRIMARY SAMPLING POINTS) - SUMMER\n*All materials, equipment, analysis & labour required for sediments must be considered as per the proposed scope of work",null,"Sum",1,null,{"$f":"E21*F21","v":{"v":0,"d":"R0.00"}}]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 12 SAMPLING POINTS FOR WATER QUALITY (PRIMARY SAMPLING POINTS) - WINTER\n*All materials, equipment, analysis & labour required for sediments must be considered as per the proposed scope of work",null,"Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 9 SAMPLING POINTS FOR WATER QUALITY (IN SITU SAMPLING POINT) - SUMMER\n*All materials, equipment, analysis & labour required for sediments must be considered as per the proposed scope of work",null,"Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 9 SAMPLING POINTS FOR WATER QUALITY (IN SITU SAMPLING POINT) - WINTER\n*All materials, equipment, analysis & labour required for sediments must be considered as per the proposed scope of work",null,"Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 8 SAMPLING POINTS FOR MUSSELS - WINTER\n*All materials, equipment, analysis & labour required for sediments must be considered as per the proposed scope of work",null,"Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"10 SAMPLE COLLECTION AND ANALYSIS FOR AD HOC WATER QUALITY (POLLUTION INVESTIGATION)\n*All materials, equipment, analysis & labour required for water quality must be considered as per the proposed scope of work",null,"Sum",1,null,{"$f":"'Adhoc Water Quality '!J71","v":{"v":0,"d":"R0.00"}}]
[null,"REPORT COMPILATION \n*The bidder will submit a total of 2 reports in a year, the first report will be the Sediment Quality analysis results, mainly used for the Dredging Permit application and then the full report at the end of the year for all the monitoring done. ",null,"Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"SAFETY FILE\n*Contractor compliance checklist to include all Ports specific requirements (incl. the annual compliance updates as and when required for the duration of the contract)",null,"EA",1,null,{"v":0,"d":"R0.00"}]
[null,"Sub-Total YR 1 ",{"$nulls":4},{"$f":"SUM(G20:G28)","v":{"v":0,"d":"R0.00"}}]
[null,null,"Item","Unit of Measure","Quanity","Rate","YEAR 1  (Excl. VAT)"]
[null,"Disbursements \n* The disbursement cost will be based on an estimated cost per year for each port. But will be paid based on actual cost incured inline with the above price notes  ","Flights (Economy class)","Sum",1,null,{"$f":"E31*F31","v":{"v":0,"d":"R0.00"}}]
[null,null,"Accommodation (3-star) ","Sum",1,null,{"$f":"E32*F32","v":{"v":0,"d":"R0.00"}}]
[null,null,"Car Hire (Group B)","Sum",1,null,{"v":0,"d":"R0.00"}]
[null,null,"Parking","Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"Total Price for all Disbursement (ZAR) (Excl. VAT). Refer to pricing notes above*",{"$nulls":4},{"$f":"SUM(G31:G34)","v":{"v":0,"d":"R0.00"}}]
[]
[]
[null,"Sub-Totals (Excl. VAT)",null,null,"Pricing Note – Escalation Formula\n\nYear 1 (YR1): The price is fixed, with no escalation applied.\n\nYear 2 (YR2): Escalation of 3.1% is applied to the full YR1 subtotal. \nFormula:\nYR2 = YR1 × (1 + 3.1%)\n\nYear 3 (YR3): Escalation of 3.0% is applied to the full YR2 subtotal. \nFormula:\nYR3 = YR2 × (1 + 3.0%)\n\nYear 4 (YR4): Escalation of 2.9% is applied to the full YR3 subtotal. \nFormula:\nYR4 = YR3 × (1 + 2.9%)\n\nYear 5 (YR5): Escalation of 3.0% is applied to the full YR4 subtotal. \nFormula:\nYR5 = YR4 × (1 + 3.0%)"]
["A","Port of Cape Town",{"$f":"SUM(G29:G29)","v":{"v":0,"d":"R0.00"}}]
["B","Disbursements",{"$f":"SUM(G35:G35)","v":{"v":0,"d":"R0.00"}}]
["C","Subtotal YR1 (Excl. VAT) [A+B]",{"$f":"SUM(C39:C40)","v":{"v":0,"d":"R0.00"}}]
["D","YR2 Escalation at 3.1%",{"$f":"C41*(1+3.1%)","v":{"v":0,"d":"R0.00"}}]
["E","YR3 Escalation at 3.0%",{"$f":"C42*(1+3%)","v":{"v":0,"d":"R0.00"}}]
["F","YR4 Escalation at 2.9%",{"$f":"C43*(1+2.9%)","v":{"v":0,"d":"R0.00"}}]
["G","YR5 Escalation at 3.0%",{"$f":"C44*(1+3%)","v":{"v":0,"d":"R0.00"}}]
["H","Total carried to Bid summary [C+D+E+F-G]",{"$f":"SUM(C41:C45)","v":{"v":0,"d":"R0.00"}}]
[]
[]
[null,"Bidder: "]
[null,"Bidder Respresentative Name: "]
[null,"Signature:"]
[null,"VAT registered (Yes / No):"]

{"sheet":"Mossel Bay","index":3,"n_rows":52,"n_cols":7,"rows_kept":52,"merged":[[1,1,1,6],[2,1,2,6],[3,1,3,6],[4,1,16,6],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,5],[30,1,33,1],[34,1,34,4],[37,1,37,2],[37,4,45,6]]}
[]
[null,"MOSSEL BAY"]
[null,"PROVISION OF THE MARINE LONG-TERM ECOLOGICAL MONITORING PROGRAM FOR THE PORTS OF RICHARDS BAY, DURBAN, EAST LONDON, NGQURA, \nPORT ELIZABETH, MOSSEL BAY, CAPE TOWN AND SALDANHA FOR FIVE (5) YEARS "]
[null,"SECTION 4: PRICING AND DELIVERY SCHEDULE"]
[null,"Pricing Notes: \n\na) Bidder must ensure that the pricing is inclusive of all related costs, including 3 replicates taken for each sediment and benthic sample as per standard practice. Any cost not specified in the pricing schedule will not be considered/accepted by Transnet.\nb) Respondents are to note that if the price offered by the highest scoring bidder is not market-related, Transnet may not award the contract to that Respondent.     \nTransnet may:\n(i) negotiate a market-related price with the Respondent scoring the highest points or cancel the RFP;\n(ii) if that Respondent does not agree to a market-related price, negotiate a market-related price with the Respondent scoring the second highest points or cancel the RFP;\n(iii) if the Respondent scoring the second highest points does not agree to a market-related price, negotiate a market-related price with the Respondent scoring the third highest points or cancel the RFP.\n(iv) If a market-related price is not agreed with the Respondent scoring the third highest points, Transnet must cancel the RFP.\nc) Prices must be quoted in South African Rand inclusive of VAT.\nd) Disbursements not specifically priced for will not be considered/accepted by Transnet. The overall cost quoted shall be inclusive of all travel and accommodation costs that will be required to complete the scope of work in full per respective port (where applicable). Accommodation and Flights shall be arranged at Government Rates (3-star accommodation) and Economy Class Flights and Basic Car Hire (Group B). Disbursements will be reimbursed at cost price upon presentation of an undisputed invoice. Any disbursement invoiced that is not in line with the aforementioned guidelines will not be accepted by Transnet for payment.  Bidders may be required to provide a detailed breakdown of projected disbursement costs upon request by Transnet prior to finalisation of award.\ne) To facilitate like-for-like comparison bidders must submit pricing strictly in accordance with this pricing schedule and not utilise a different format. Deviation from this pricing schedule or not quoting on every line item for all eight Ports will result in a bid being declared non-responsive.\nf) Respondents, if awarded the contract, are required to indicate that their prices quoted for Year 1 would be kept firm and fixed. Escalations from Year 2 to Year 5 must be capped at CPI projection percentages YR2 3.1%, YR3.0%, YR4 2.9%, YR5 3.0% respectively. The contract price for Year 2 to Year 5 will be revised based on actual inflation increases as published by the Stats SA.\ng) Bidders are required to input prices exclusive of VAT in the green shaded cells. The sheet contains a formula for calculation of subtotals, grand total and VAT. \nh)Totals will automatically be reflected on the bid summary sheet. "]
{"$rows_empty":13}
[null,"Description",null,"Unit of Measure","Quanity","Rate","YEAR 1 (Excl. VAT)\n"]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 9 SAMPLING POINTS FOR SEDIMENT - WINTER\n*All materials, equipment, analysis & labour required for sediments must be considered as per the proposed scope of work. The standard practice is to collect 3 replicate per grab samples, which should be composited for physical and chemical analysis in the lab and then 3 replicate per grab samples for benthic microfauna, which will be analysed as separate samples in the lab.",null,"Sum",1,null,{"$f":"E20*F20","v":{"v":0,"d":"R0.00"}}]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 7 SAMPLING POINTS FOR WATER QUALITY (PRIMARY SAMPLING POINTS) - SUMMER\n*All materials, equipment, analysis & labour required for sediments must be considered as per the proposed scope of work",null,"Sum",1,null,{"$f":"E21*F21","v":{"v":0,"d":"R0.00"}}]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 7 SAMPLING POINTS FOR WATER QUALITY (PRIMARY SAMPLING POINTS) - WINTER\n*All materials, equipment, analysis & labour required for sediments must be considered as per the proposed scope of work",null,"Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 7 SAMPLING POINTS FOR WATER QUALITY (IN SITU SAMPLING POINT) - SUMMER\n*All materials, equipment, analysis & labour required for sediments must be considered as per the proposed scope of work",null,"Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 7 SAMPLING POINTS FOR WATER QUALITY (IN SITU SAMPLING POINT) - WINTER\n*All materials, equipment, analysis & labour required for sediments must be considered as per the proposed scope of work",null,"Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 3 SAMPLING POINTS FOR MUSSELS - WINTER\n*All materials, equipment, analysis & labour required for sediments must be considered as per the proposed scope of work",null,"Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"10 SAMPLE COLLECTION AND ANALYSIS FOR AD HOC WATER QUALITY (POLLUTION INVESTIGATION)\n*All materials, equipment, analysis & labour required for water quality must be considered as per the proposed scope of work",null,"Sum",1,null,{"$f":"'Adhoc Water Quality '!M71","v":{"v":0,"d":"R0.00"}}]
[null,"REPORT COMPILATION \n*The bidder will submit a total of 2 reports in a year, the first report will be the Sediment Quality analysis results, mainly used for the Dredging Permit application and then the full report at the end of the year for all the monitoring done. ",null,"Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"SAFETY FILE\n*Contractor compliance checklist to include all Ports specific requirements (incl. the annual compliance updates as and when required for the duration of the contract)",null,"EA",1,null,{"v":0,"d":"R0.00"}]
[null,"Sub-Total YR 1",{"$nulls":4},{"$f":"SUM(G20:G28)","v":{"v":0,"d":"R0.00"}}]
[null,null,"Item","Unit of Measure","Quanity","Rate","YEAR 1  (Excl. VAT)"]
[null,"Disbursements \n* The disbursement cost will be based on an estimated cost per year for each port. But will be paid based on actual cost incured inline with the above price notes  ","Flights (Economy class)","Sum",1,null,{"$f":"E31*F31","v":{"v":0,"d":"R0.00"}}]
[null,null,"Accommodation (3-star) ","Sum",1,null,{"$f":"E32*F32","v":{"v":0,"d":"R0.00"}}]
[null,null,"Car Hire (Group B)","Sum",1,null,{"v":0,"d":"R0.00"}]
[null,null,"Parking","Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"Total Price for all Disbursement (ZAR) (Excl. VAT). Refer to pricing notes above*",{"$nulls":4},{"$f":"SUM(G31:G34)","v":{"v":0,"d":"R0.00"}}]
[]
[]
[null,"Sub-Totals (Excl. VAT)",null,null,"Pricing Note – Escalation Formula\n\nYear 1 (YR1): The price is fixed, with no escalation applied.\n\nYear 2 (YR2): Escalation of 3.1% is applied to the full YR1 subtotal. Formula:\nYR2 = YR1 × (1 + 3.1%)\n\nYear 3 (YR3): Escalation of 3.0% is applied to the full YR2 subtotal. Formula:\nYR3 = YR2 × (1 + 3.0%)\n\nYear 4 (YR4): Escalation of 2.9% is applied to the full YR3 subtotal. Formula:\nYR4 = YR3 × (1 + 2.9%)\n\nYear 5 (YR5): Escalation of 3.0% is applied to the full YR4 subtotal. Formula:\nYR5 = YR4 × (1 + 3.0%)"]
["A","Port of Mossel Bay",{"$f":"SUM(G29:G29)","v":{"v":0,"d":"R0.00"}}]
["B","Disbursements",{"$f":"SUM(G35:G35)","v":{"v":0,"d":"R0.00"}}]
["C","Subtotal YR1 (Excl. VAT) [A+B]",{"$f":"SUM(C39:C40)","v":{"v":0,"d":"R0.00"}}]
["D","YR2 Escalation at 3.1%",{"$f":"C41*(1+3.1%)","v":{"v":0,"d":"R0.00"}}]
["E","YR3 Escalation at 3.0%",{"$f":"C42*(1+3%)","v":{"v":0,"d":"R0.00"}}]
["F","YR4 Escalation at 2.9%",{"$f":"C43*(1+2.9%)","v":{"v":0,"d":"R0.00"}}]
["G","YR5 Escalation at 3.0%",{"$f":"C44*(1+3%)","v":{"v":0,"d":"R0.00"}}]
["H","Total carried to Bid summary [C+D+E+F-G]",{"$f":"SUM(C41:C45)","v":{"v":0,"d":"R0.00"}}]
[]
[]
[null,"Bidder: "]
[null,"Bidder Respresentative Name: "]
[null,"Signature:"]
[null,"VAT registered (Yes / No):"]

{"sheet":"Port Elizabeth","index":4,"n_rows":51,"n_cols":7,"rows_kept":51,"merged":[[1,1,1,6],[2,1,2,6],[3,1,3,6],[4,1,16,6],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,5],[30,1,33,1],[34,1,34,4],[37,1,37,2],[37,4,45,6]]}
[]
[null,"PORT ELIZABETH"]
[null,"PROVISION OF THE MARINE LONG-TERM ECOLOGICAL MONITORING PROGRAM FOR THE PORTS OF RICHARDS BAY, DURBAN, EAST LONDON, NGQURA,\n PORT ELIZABETH, MOSSEL BAY, CAPE TOWN AND SALDANHA FOR FIVE (5) YEARS "]
[null,"SECTION 4: PRICING AND DELIVERY SCHEDULE"]
[null,"Pricing Notes: \n\na) Bidder must ensure that the pricing is inclusive of all related costs, including 3 replicates taken for each sediment and benthic sample as per standard practice. Any cost not specified in the pricing schedule will not be considered/accepted by Transnet.\nb) Respondents are to note that if the price offered by the highest scoring bidder is not market-related, Transnet may not award the contract to that Respondent.     \nTransnet may:\n(i) negotiate a market-related price with the Respondent scoring the highest points or cancel the RFP;\n(ii) if that Respondent does not agree to a market-related price, negotiate a market-related price with the Respondent scoring the second highest points or cancel the RFP;\n(iii) if the Respondent scoring the second highest points does not agree to a market-related price, negotiate a market-related price with the Respondent scoring the third highest points or cancel the RFP.\n(iv) If a market-related price is not agreed with the Respondent scoring the third highest points, Transnet must cancel the RFP.\nc) Prices must be quoted in South African Rand inclusive of VAT.\nd) Disbursements not specifically priced for will not be considered/accepted by Transnet. The overall cost quoted shall be inclusive of all travel and accommodation costs that will be required to complete the scope of work in full per respective port (where applicable). Accommodation and Flights shall be arranged at Government Rates (3-star accommodation) and Economy Class Flights and Basic Car Hire (Group B). Disbursements will be reimbursed at cost price upon presentation of an undisputed invoice. Any disbursement invoiced that is not in line with the aforementioned guidelines will not be accepted by Transnet for payment.  Bidders may be required to provide a detailed breakdown of projected disbursement costs upon request by Transnet prior to finalisation of award.\ne) To facilitate like-for-like comparison bidders must submit pricing strictly in accordance with this pricing schedule and not utilise a different format. Deviation from this pricing schedule or not quoting on every line item for all eight Ports will result in a bid being declared non-responsive.\nf) Respondents, if awarded the contract, are required to indicate that their prices quoted for Year 1 would be kept firm and fixed. Escalations from Year 2 to Year 5 must be capped at CPI projection percentages YR2 3.1%, YR3.0%, YR4 2.9%, YR5 3.0% respectively. The contract price for Year 2 to Year 5 will be revised based on actual inflation increases as published by the Stats SA.\ng) Bidders are required to input prices exclusive of VAT in the green shaded cells. The sheet contains a formula for calculation of subtotals, grand total and VAT. \nh)Totals will automatically be reflected on the bid summary sheet. "]
{"$rows_empty":13}
[null,"Description",null,"Unit of Measure","Quanity","Rate","YEAR 1 (Excl. VAT)\n"]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 16 SAMPLING POINTS FOR SEDIMENT - WINTER\n*All materials, equipment, analysis & labour required for sediments must be considered as per the proposed scope of work. The standard practice is to collect 3 replicate per grab samples, which should be composited for physical and chemical analysis in the lab and then 3 replicate per grab samples for benthic microfauna, which will be analysed as separate samples in the lab.",null,"Sum",1,null,{"$f":"E20*F20","v":{"v":0,"d":"R0.00"}}]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 10 SAMPLING POINTS FOR WATER QUALITY (PRIMARY SAMPLING POINTS) - SUMMER\n*All materials, equipment, analysis & labour required for sediments must be considered as per the proposed scope of work",null,"Sum",1,null,{"$f":"E21*F21","v":{"v":0,"d":"R0.00"}}]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 10 SAMPLING POINTS FOR WATER QUALITY (PRIMARY SAMPLING POINTS) - WINTER\n*All materials, equipment, analysis & labour required for sediments must be considered as per the proposed scope of work",null,"Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 8 SAMPLING POINTS FOR WATER QUALITY (IN SITU SAMPLING POINT) - SUMMER\n*All materials, equipment, analysis & labour required for sediments must be considered as per the proposed scope of work",null,"Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 8 SAMPLING POINTS FOR WATER QUALITY (IN SITU SAMPLING POINT) - WINTER\n*All materials, equipment, analysis & labour required for sediments must be considered as per the proposed scope of work",null,"Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 6 SAMPLING POINTS FOR MUSSELS - WINTER\n*All materials, equipment, analysis & labour required for sediment must be considered as per the proposed scope of work",null,"Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"10 SAMPLE COLLECTION AND ANALYSIS FOR AD HOC WATER QUALITY (POLLUTION INVESTIGATION)\n*All materials, equipment, analysis & labour required for water quality must be considered as per the proposed scope of work",null,"Sum",1,null,{"$f":"'Adhoc Water Quality '!P71","v":{"v":0,"d":"R0.00"}}]
[null,"REPORT COMPILATION \n*The bidder will submit a total of 2 reports in a year, the first report will be the Sediment Quality analysis results, mainly used for the Dredging Permit application and then the full report at the end of the year for all the monitoring done. ",null,"Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"SAFETY FILE\n*Contractor compliance checklist to include all Ports specific requirements (incl. the annual compliance updates as and when required for the duration of the contract)",null,"EA",1,null,{"v":0,"d":"R0.00"}]
[null,"Sub-Total YR 1",{"$nulls":4},{"$f":"SUM(G20:G28)","v":{"v":0,"d":"R0.00"}}]
[null,null,"Item","Unit of Measure","Quanity","Rate","YEAR 1  (Excl. VAT)"]
[null,"Disbursements \n* The disbursement cost will be based on an estimated cost per year for each port. But will be paid based on actual cost incured inline with the above price notes  ","Flights (Economy class)","Sum",1,null,{"$f":"E31*F31","v":{"v":0,"d":"R0.00"}}]
[null,null,"Accommodation (3-star) ","Sum",1,null,{"$f":"E32*F32","v":{"v":0,"d":"R0.00"}}]
[null,null,"Car Hire (Group B)","Sum",1,null,{"v":0,"d":"R0.00"}]
[null,null,"Parking","Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"Total Price for all Disbursement (ZAR) (Excl. VAT). Refer to pricing notes above*",{"$nulls":4},{"$f":"SUM(G31:G34)","v":{"v":0,"d":"R0.00"}}]
[]
[]
[null,"Sub-Totals (Excl. VAT)",null,null,"Pricing Note – Escalation Formula\n\nYear 1 (YR1): The price is fixed, with no escalation applied.\n\nYear 2 (YR2): Escalation of 3.1% is applied to the full YR1 subtotal. Formula:\nYR2 = YR1 × (1 + 3.1%)\n\nYear 3 (YR3): Escalation of 3.0% is applied to the full YR2 subtotal. Formula:\nYR3 = YR2 × (1 + 3.0%)\n\nYear 4 (YR4): Escalation of 2.9% is applied to the full YR3 subtotal. Formula:\nYR4 = YR3 × (1 + 2.9%)\n\nYear 5 (YR5): Escalation of 3.0% is applied to the full YR4 subtotal. Formula:\nYR5 = YR4 × (1 + 3.0%)"]
["A","Port of Port Elizabeth",{"$f":"SUM(G29:G29)","v":{"v":0,"d":"R0.00"}}]
["B","Disbursements",{"$f":"SUM(G35:G35)","v":{"v":0,"d":"R0.00"}}]
["C","Subtotal YR1 (Excl. VAT) [A+B]",{"$f":"SUM(C39:C40)","v":{"v":0,"d":"R0.00"}}]
["D","YR2 Escalation at 3.1%",{"$f":"C41*(1+3.1%)","v":{"v":0,"d":"R0.00"}}]
["E","YR3 Escalation at 3.0%",{"$f":"C42*(1+3%)","v":{"v":0,"d":"R0.00"}}]
["F","YR4 Escalation at 2.9%",{"$f":"C43*(1+2.9%)","v":{"v":0,"d":"R0.00"}}]
["G","YR5 Escalation at 3.0%",{"$f":"C44*(1+3%)","v":{"v":0,"d":"R0.00"}}]
["H","Total carried to Bid summary [C+D+E+F-G]",{"$f":"SUM(C41:C45)","v":{"v":0,"d":"R0.00"}}]
[]
[null,"Bidder: "]
[null,"Bidder Respresentative Name: "]
[null,"Signature:"]
[null,"VAT registered (Yes / No):"]

{"sheet":"Ngqura","index":5,"n_rows":52,"n_cols":7,"rows_kept":52,"merged":[[1,1,1,6],[2,1,2,6],[3,1,3,6],[4,1,16,6],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,5],[30,1,33,1],[34,1,34,4],[37,1,37,2],[37,4,45,6]]}
[]
[null,"NGQURA"]
[null,"PROVISION OF THE MARINE LONG-TERM ECOLOGICAL MONITORING PROGRAM FOR THE PORTS OF RICHARDS BAY, DURBAN, EAST LONDON, NGQURA, \nPORT ELIZABETH, MOSSEL BAY, CAPE TOWN AND SALDANHA FOR FIVE (5) YEARS "]
[null,"SECTION 4: PRICING AND DELIVERY SCHEDULE"]
[null,"Pricing Notes: \n\na) Bidder must ensure that the pricing is inclusive of all related costs, including 3 replicates taken for each sediment and benthic sample as per standard practice. Any cost not specified in the pricing schedule will not be considered/accepted by Transnet.\nb) Respondents are to note that if the price offered by the highest scoring bidder is not market-related, Transnet may not award the contract to that Respondent.     \nTransnet may:\n(i) negotiate a market-related price with the Respondent scoring the highest points or cancel the RFP;\n(ii) if that Respondent does not agree to a market-related price, negotiate a market-related price with the Respondent scoring the second highest points or cancel the RFP;\n(iii) if the Respondent scoring the second highest points does not agree to a market-related price, negotiate a market-related price with the Respondent scoring the third highest points or cancel the RFP.\n(iv) If a market-related price is not agreed with the Respondent scoring the third highest points, Transnet must cancel the RFP.\nc) Prices must be quoted in South African Rand inclusive of VAT.\nd) Disbursements not specifically priced for will not be considered/accepted by Transnet. The overall cost quoted shall be inclusive of all travel and accommodation costs that will be required to complete the scope of work in full per respective port (where applicable). Accommodation and Flights shall be arranged at Government Rates (3-star accommodation) and Economy Class Flights and Basic Car Hire (Group B). Disbursements will be reimbursed at cost price upon presentation of an undisputed invoice. Any disbursement invoiced that is not in line with the aforementioned guidelines will not be accepted by Transnet for payment.  Bidders may be required to provide a detailed breakdown of projected disbursement costs upon request by Transnet prior to finalisation of award.\ne) To facilitate like-for-like comparison bidders must submit pricing strictly in accordance with this pricing schedule and not utilise a different format. Deviation from this pricing schedule or not quoting on every line item for all eight Ports will result in a bid being declared non-responsive.\nf) Respondents, if awarded the contract, are required to indicate that their prices quoted for Year 1 would be kept firm and fixed. Escalations from Year 2 to Year 5 must be capped at CPI projection percentages YR2 3.1%, YR3.0%, YR4 2.9%, YR5 3.0% respectively. The contract price for Year 2 to Year 5 will be revised based on actual inflation increases as published by the Stats SA.\ng) Bidders are required to input prices exclusive of VAT in the green shaded cells. The sheet contains a formula for calculation of subtotals, grand total and VAT. \nh)Totals will automatically be reflected on the bid summary sheet. "]
{"$rows_empty":13}
[null,"Description",null,"Unit of Measure","Quanity","Rate","YEAR 1 (Excl. VAT)\n"]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 9 SAMPLING POINTS FOR SEDIMENT - WINTER\n*All materials, equipment, analysis & labour required for sediments must be considered as per the proposed scope of work. The standard practice is to collect 3 replicate per grab samples, which should be composited for physical and chemical analysis in the lab and then 3 replicate per grab samples for benthic microfauna, which will be analysed as separate samples in the lab.",null,"Sum",1,null,{"$f":"E20*F20","v":{"v":0,"d":"R0.00"}}]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 7 SAMPLING POINTS FOR WATER QUALITY (PRIMARY SAMPLING POINTS) - SUMMER\n*All materials, equipment, analysis & labour required for sediments must be considered as per the proposed scope of work",null,"Sum",1,null,{"$f":"E21*F21","v":{"v":0,"d":"R0.00"}}]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 7 SAMPLING POINTS FOR WATER QUALITY (PRIMARY SAMPLING POINTS) - WINTER\n*All materials, equipment, analysis & labour required for sediments must be considered as per the proposed scope of work",null,"Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 5 SAMPLING POINTS FOR WATER QUALITY (IN SITU SAMPLING POINT) - SUMMER\n*All materials, equipment, analysis & labour required for sediments must be considered as per the proposed scope of work",null,"Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 5 SAMPLING POINTS FOR WATER QUALITY (IN SITU SAMPLING POINT) - WINTER\n*All materials, equipment, analysis & labour required for sediments must be considered as per the proposed scope of work",null,"Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 3 SAMPLING POINTS FOR MUSSELS - WINTER\n*All materials, equipment, analysis & labour required for sediments must be considered as per the proposed scope of work",null,"Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"10 SAMPLE COLLECTION AND ANALYSIS FOR AD HOC WATER QUALITY (POLLUTION INVESTIGATION)\n*All materials, equipment, analysis & labour required for water quality must be considered as per the proposed scope of work",null,"Sum",1,null,{"$f":"'Adhoc Water Quality '!S71","v":{"v":0,"d":"R0.00"}}]
[null,"REPORT COMPILATION \n*The bidder will submit a total of 2 reports in a year, the first report will be the Sediment Quality analysis results, mainly used for the Dredging Permit application and then the full report at the end of the year for all the monitoring done. ",null,"Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"SAFETY FILE\n*Contractor compliance checklist to include all Ports specific requirements (incl. the annual compliance updates as and when required for the duration of the contract)",null,"EA",1,null,{"v":0,"d":"R0.00"}]
[null,"Sub-Total YR 1",{"$nulls":4},{"$f":"SUM(G20:G28)","v":{"v":0,"d":"R0.00"}}]
[null,null,"Item","Unit of Measure","Quanity","Rate","YEAR 1  (Excl. VAT)"]
[null,"Disbursements \n* The disbursement cost will be based on an estimated cost per year for each port. But will be paid based on actual cost incured inline with the above price notes  ","Flights (Economy class)","Sum",1,null,{"$f":"E31*F31","v":{"v":0,"d":"R0.00"}}]
[null,null,"Accommodation (3-star) ","Sum",1,null,{"$f":"E32*F32","v":{"v":0,"d":"R0.00"}}]
[null,null,"Car Hire (Group B)","Sum",1,null,{"v":0,"d":"R0.00"}]
[null,null,"Parking","Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"Total Price for all Disbursement (ZAR) (Excl. VAT). Refer to pricing notes above*",{"$nulls":4},{"$f":"SUM(G31:G34)","v":{"v":0,"d":"R0.00"}}]
[]
[]
[null,"Sub-Totals (Excl. VAT)",null,null,"Pricing Note – Escalation Formula\n\nYear 1 (YR1): The price is fixed, with no escalation applied.\n\nYear 2 (YR2): Escalation of 3.1% is applied to the full YR1 subtotal. Formula:\nYR2 = YR1 × (1 + 3.1%)\n\nYear 3 (YR3): Escalation of 3.0% is applied to the full YR2 subtotal. Formula:\nYR3 = YR2 × (1 + 3.0%)\n\nYear 4 (YR4): Escalation of 2.9% is applied to the full YR3 subtotal. Formula:\nYR4 = YR3 × (1 + 2.9%)\n\nYear 5 (YR5): Escalation of 3.0% is applied to the full YR4 subtotal. Formula:\nYR5 = YR4 × (1 + 3.0%)"]
["A","Port of Ngqura",{"$f":"SUM(G29:G29)","v":{"v":0,"d":"R0.00"}}]
["B","Disbursements",{"$f":"SUM(G35:G35)","v":{"v":0,"d":"R0.00"}}]
["C","Subtotal YR1 (Excl. VAT) [A+B]",{"$f":"SUM(C39:C40)","v":{"v":0,"d":"R0.00"}}]
["D","YR2 Escalation at 3.1%",{"$f":"C41*(1+3.1%)","v":{"v":0,"d":"R0.00"}}]
["E","YR3 Escalation at 3.0%",{"$f":"C42*(1+3%)","v":{"v":0,"d":"R0.00"}}]
["F","YR4 Escalation at 2.9%",{"$f":"C43*(1+2.9%)","v":{"v":0,"d":"R0.00"}}]
["G","YR5 Escalation at 3.0%",{"$f":"C44*(1+3%)","v":{"v":0,"d":"R0.00"}}]
["H","Total carried to Bid summary [C+D+E+F-G]",{"$f":"SUM(C41:C45)","v":{"v":0,"d":"R0.00"}}]
[]
[]
[null,"Bidder: "]
[null,"Bidder Respresentative Name: "]
[null,"Signature:"]
[null,"VAT registered (Yes / No):"]

{"sheet":"East London","index":6,"n_rows":52,"n_cols":7,"rows_kept":52,"merged":[[1,1,1,6],[2,1,2,6],[3,1,3,6],[4,1,16,6],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,5],[30,1,33,1],[34,1,34,4],[37,1,37,2],[37,4,45,6]]}
[]
[null,"EAST LONDON"]
[null,"PROVISION OF THE MARINE LONG-TERM ECOLOGICAL MONITORING PROGRAM FOR THE PORTS OF RICHARDS BAY, DURBAN, EAST LONDON, NGQURA,\n PORT ELIZABETH, MOSSEL BAY, CAPE TOWN AND SALDANHA FOR FIVE (5) YEARS "]
[null,"SECTION 4: PRICING AND DELIVERY SCHEDULE"]
[null,"Pricing Notes: \n\na) Bidder must ensure that the pricing is inclusive of all related costs, including 3 replicates taken for each sediment and benthic sample as per standard practice. Any cost not specified in the pricing schedule will not be considered/accepted by Transnet.\nb) Respondents are to note that if the price offered by the highest scoring bidder is not market-related, Transnet may not award the contract to that Respondent.     \nTransnet may:\n(i) negotiate a market-related price with the Respondent scoring the highest points or cancel the RFP;\n(ii) if that Respondent does not agree to a market-related price, negotiate a market-related price with the Respondent scoring the second highest points or cancel the RFP;\n(iii) if the Respondent scoring the second highest points does not agree to a market-related price, negotiate a market-related price with the Respondent scoring the third highest points or cancel the RFP.\n(iv) If a market-related price is not agreed with the Respondent scoring the third highest points, Transnet must cancel the RFP.\nc) Prices must be quoted in South African Rand inclusive of VAT.\nd) Disbursements not specifically priced for will not be considered/accepted by Transnet. The overall cost quoted shall be inclusive of all travel and accommodation costs that will be required to complete the scope of work in full per respective port (where applicable). Accommodation and Flights shall be arranged at Government Rates (3-star accommodation) and Economy Class Flights and Basic Car Hire (Group B). Disbursements will be reimbursed at cost price upon presentation of an undisputed invoice. Any disbursement invoiced that is not in line with the aforementioned guidelines will not be accepted by Transnet for payment.  Bidders may be required to provide a detailed breakdown of projected disbursement costs upon request by Transnet prior to finalisation of award.\ne) To facilitate like-for-like comparison bidders must submit pricing strictly in accordance with this pricing schedule and not utilise a different format. Deviation from this pricing schedule or not quoting on every line item for all eight Ports will result in a bid being declared non-responsive.\nf) Respondents, if awarded the contract, are required to indicate that their prices quoted for Year 1 would be kept firm and fixed. Escalations from Year 2 to Year 5 must be capped at CPI projection percentages YR2 3.1%, YR3.0%, YR4 2.9%, YR5 3.0% respectively. The contract price for Year 2 to Year 5 will be revised based on actual inflation increases as published by the Stats SA.\ng) Bidders are required to input prices exclusive of VAT in the green shaded cells. The sheet contains a formula for calculation of subtotals, grand total and VAT. \nh)Totals will automatically be reflected on the bid summary sheet. "]
{"$rows_empty":13}
[null,"Description",null,"Unit of Measure","Quanity","Rate","YEAR 1 (Excl. VAT)\n"]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 11 SAMPLING POINTS FOR SEDIMENT - WINTER\n*All materials, equipment, analysis & labour required for sediments must be considered as per the proposed scope of work. The standard practice is to collect 3 replicate per grab samples, which should be composited for physical and chemical analysis in the lab and then 3 replicate per grab samples for benthic microfauna, which will be analysed as separate samples in the lab.",null,"Sum",1,null,{"$f":"E20*F20","v":{"v":0,"d":"R0.00"}}]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 6 SAMPLING POINTS FOR WATER QUALITY (PRIMARY SAMPLING POINTS) - SUMMER\n*All materials, equipment, analysis & labour required for sediments must be considered as per the proposed scope of work",null,"Sum",1,null,{"$f":"E21*F21","v":{"v":0,"d":"R0.00"}}]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 6 SAMPLING POINTS FOR WATER QUALITY (PRIMARY SAMPLING POINTS) - WINTER\n*All materials, equipment, analysis & labour required for sediments must be considered as per the proposed scope of work",null,"Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 7 SAMPLING POINTS FOR WATER QUALITY (IN SITU SAMPLING POINT) - SUMMER\n*All materials, equipment, analysis & labour required for sediments must be considered as per the proposed scope of work",null,"Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 7 SAMPLING POINTS FOR WATER QUALITY (IN SITU SAMPLING POINT) - WINTER\n*All materials, equipment, analysis & labour required for sediments must be considered as per the proposed scope of work",null,"Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 2 SAMPLING POINTS FOR MUSSELS - WINTER\n*All materials, equipment, analysis & labour required for sediments must be considered as per the proposed scope of work",null,"Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"10 SAMPLE COLLECTION AND ANALYSIS FOR AD HOC WATER QUALITY (POLLUTION INVESTIGATION)\n*All materials, equipment, analysis & labour required for water quality must be considered as per the proposed scope of work",null,"Sum",1,null,{"$f":"'Adhoc Water Quality '!V71","v":{"v":0,"d":"R0.00"}}]
[null,"REPORT COMPILATION \n*The bidder will submit a total of 2 reports in a year, the first report will be the Sediment Quality analysis results, mainly used for the Dredging Permit application and then the full report at the end of the year for all the monitoring done. ",null,"Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"SAFETY FILE\n*Contractor compliance checklist to include all Ports specific requirements (incl. the annual compliance updates as and when required for the duration of the contract)",null,"EA",1,null,{"v":0,"d":"R0.00"}]
[null,"Sub-Total YR 1",{"$nulls":4},{"$f":"SUM(G20:G28)","v":{"v":0,"d":"R0.00"}}]
[null,null,"Item","Unit of Measure","Quanity","Rate","YEAR 1  (Excl. VAT)"]
[null,"Disbursements \n* The disbursement cost will be based on an estimated cost per year for each port. But will be paid based on actual cost incured inline with the above price notes  ","Flights (Economy class)","Sum",1,null,{"$f":"E31*F31","v":{"v":0,"d":"R0.00"}}]
[null,null,"Accommodation (3-star) ","Sum",1,null,{"$f":"E32*F32","v":{"v":0,"d":"R0.00"}}]
[null,null,"Car Hire (Group B)","Sum",1,null,{"v":0,"d":"R0.00"}]
[null,null,"Parking","Sum",1,null,{"$f":"E34*F34","v":{"v":0,"d":"R0.00"}}]
[null,"Total Price for all Disbursement (ZAR) (Excl. VAT). Refer to pricing notes above*",{"$nulls":4},{"$f":"SUM(G31:G34)","v":{"v":0,"d":"R0.00"}}]
[]
[]
[null,"Sub-Totals (Excl. VAT)",null,null,"Pricing Note – Escalation Formula\n\nYear 1 (YR1): The price is fixed, with no escalation applied.\n\nYear 2 (YR2): Escalation of 3.1% is applied to the full YR1 subtotal. Formula:\nYR2 = YR1 × (1 + 3.1%)\n\nYear 3 (YR3): Escalation of 3.0% is applied to the full YR2 subtotal. Formula:\nYR3 = YR2 × (1 + 3.0%)\n\nYear 4 (YR4): Escalation of 2.9% is applied to the full YR3 subtotal. Formula:\nYR4 = YR3 × (1 + 2.9%)\n\nYear 5 (YR5): Escalation of 3.0% is applied to the full YR4 subtotal. Formula:\nYR5 = YR4 × (1 + 3.0%)"]
["A","Port of East London",{"$f":"SUM(G29:G29)","v":{"v":0,"d":"R0.00"}}]
["B","Disbursements",{"$f":"SUM(G35:G35)","v":{"v":0,"d":"R0.00"}}]
["C","Subtotal YR1 (Excl. VAT) [A+B]",{"$f":"SUM(C39:C40)","v":{"v":0,"d":"R0.00"}}]
["D","YR2 Escalation at 3.1%",{"$f":"C41*(1+3.1%)","v":{"v":0,"d":"R0.00"}}]
["E","YR3 Escalation at 3.0%",{"$f":"C42*(1+3%)","v":{"v":0,"d":"R0.00"}}]
["F","YR4 Escalation at 2.9%",{"$f":"C43*(1+2.9%)","v":{"v":0,"d":"R0.00"}}]
["G","YR5 Escalation at 3.0%",{"$f":"C44*(1+3%)","v":{"v":0,"d":"R0.00"}}]
["H","Total carried to Bid summary [C+D+E+F-G]",{"$f":"SUM(C41:C45)","v":{"v":0,"d":"R0.00"}}]
[]
[]
[null,"Bidder: "]
[null,"Bidder Respresentative Name: "]
[null,"Signature:"]
[null,"VAT registered (Yes / No):"]

{"sheet":"Durban","index":7,"n_rows":52,"n_cols":7,"rows_kept":52,"merged":[[1,1,1,6],[2,1,2,6],[3,1,3,6],[4,1,16,6],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,5],[30,1,33,1],[34,1,34,4],[37,1,37,2],[37,4,45,6]]}
[]
[null,"DURBAN"]
[null,"PROVISION OF THE MARINE LONG-TERM ECOLOGICAL MONITORING PROGRAM FOR THE PORTS OF RICHARDS BAY, DURBAN, EAST LONDON, NGQURA,\n PORT ELIZABETH, MOSSEL BAY, CAPE TOWN AND SALDANHA FOR FIVE (5) YEARS "]
[null,"SECTION 4: PRICING AND DELIVERY SCHEDULE"]
[null,"Pricing Notes: \n\na) Bidder must ensure that the pricing is inclusive of all related costs, including 3 replicates taken for each sediment and benthic sample as per standard practice. Any cost not specified in the pricing schedule will not be considered/accepted by Transnet.\nb) Respondents are to note that if the price offered by the highest scoring bidder is not market-related, Transnet may not award the contract to that Respondent.     \nTransnet may:\n(i) negotiate a market-related price with the Respondent scoring the highest points or cancel the RFP;\n(ii) if that Respondent does not agree to a market-related price, negotiate a market-related price with the Respondent scoring the second highest points or cancel the RFP;\n(iii) if the Respondent scoring the second highest points does not agree to a market-related price, negotiate a market-related price with the Respondent scoring the third highest points or cancel the RFP.\n(iv) If a market-related price is not agreed with the Respondent scoring the third highest points, Transnet must cancel the RFP.\nc) Prices must be quoted in South African Rand inclusive of VAT.\nd) Disbursements not specifically priced for will not be considered/accepted by Transnet. The overall cost quoted shall be inclusive of all travel and accommodation costs that will be required to complete the scope of work in full per respective port (where applicable). Accommodation and Flights shall be arranged at Government Rates (3-star accommodation) and Economy Class Flights and Basic Car Hire (Group B). Disbursements will be reimbursed at cost price upon presentation of an undisputed invoice. Any disbursement invoiced that is not in line with the aforementioned guidelines will not be accepted by Transnet for payment.  Bidders may be required to provide a detailed breakdown of projected disbursement costs upon request by Transnet prior to finalisation of award.\ne) To facilitate like-for-like comparison bidders must submit pricing strictly in accordance with this pricing schedule and not utilise a different format. Deviation from this pricing schedule or not quoting on every line item for all eight Ports will result in a bid being declared non-responsive.\nf) Respondents, if awarded the contract, are required to indicate that their prices quoted for Year 1 would be kept firm and fixed. Escalations from Year 2 to Year 5 must be capped at CPI projection percentages YR2 3.1%, YR3.0%, YR4 2.9%, YR5 3.0% respectively. The contract price for Year 2 to Year 5 will be revised based on actual inflation increases as published by the Stats SA.\ng) Bidders are required to input prices exclusive of VAT in the green shaded cells. The sheet contains a formula for calculation of subtotals, grand total and VAT. \nh)Totals will automatically be reflected on the bid summary sheet. "]
{"$rows_empty":13}
[null,"Description",null,"Unit of Measure","Quanity","Rate","YEAR 1 (Excl. VAT)\n"]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 29 SAMPLING POINTS FOR SEDIMENT - WINTER\n*All materials, equipment, analysis & labour required for sediments must be considered as per the proposed scope of work. The standard practice is to collect 3 replicate per grab samples, which should be composited for physical and chemical analysis in the lab and then 3 replicate per grab samples for benthic microfauna, which will be analysed as separate samples in the lab.",null,"Sum",1,null,{"$f":"E20*F20","v":{"v":0,"d":"R0.00"}}]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 15 SAMPLING POINTS FOR WATER QUALITY (PRIMARY SAMPLING POINTS) - SUMMER\n*All materials, equipment, analysis & labour required for sediments must be considered as per the proposed scope of work",null,"Sum",1,null,{"$f":"E21*F21","v":{"v":0,"d":"R0.00"}}]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 15 SAMPLING POINTS FOR WATER QUALITY (PRIMARY SAMPLING POINTS) - WINTER\n*All materials, equipment, analysis & labour required for sediments must be considered as per the proposed scope of work",null,"Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 5 SAMPLING POINTS FOR WATER QUALITY (IN SITU SAMPLING POINT) - SUMMER\n*All materials, equipment, analysis & labour required for sediments must be considered as per the proposed scope of work",null,"Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 5 SAMPLING POINTS FOR WATER QUALITY (IN SITU SAMPLING POINT) - WINTER\n*All materials, equipment, analysis & labour required for sediments must be considered as per the proposed scope of work",null,"Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 8 SAMPLING POINTS FOR MUSSELS - WINTER\n*All materials, equipment, analysis & labour required for sediments must be considered as per the proposed scope of work",null,"Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"10 SAMPLE COLLECTION AND ANALYSIS FOR AD HOC WATER QUALITY (POLLUTION INVESTIGATION)\n*All materials, equipment, analysis & labour required for water quality must be considered as per the proposed scope of work",null,"Sum",1,null,{"$f":"'Adhoc Water Quality '!Y71","v":{"v":0,"d":"R0.00"}}]
[null,"REPORT COMPILATION \n*The bidder will submit a total of 2 reports in a year, the first report will be the Sediment Quality analysis results, mainly used for the Dredging Permit application and then the full report at the end of the year for all the monitoring done. ",null,"Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"SAFETY FILE\n*Contractor compliance checklist to include all Ports specific requirements (incl. the annual compliance updates as and when required for the duration of the contract)",null,"EA",1,null,{"v":0,"d":"R0.00"}]
[null,"Sub-Total YR 1 ",{"$nulls":4},{"$f":"SUM(G20:G28)","v":{"v":0,"d":"R0.00"}}]
[null,null,"Item","Unit of Measure","Quanity","Rate","YEAR 1  (Excl. VAT)"]
[null,"Disbursements \n* The disbursement cost will be based on an estimated cost per year for each port. But will be paid based on actual cost incured inline with the above price notes  ","Flights (Economy class)","Sum",1,null,{"$f":"E31*F31","v":{"v":0,"d":"R0.00"}}]
[null,null,"Accommodation (3-star) ","Sum",1,null,{"$f":"E32*F32","v":{"v":0,"d":"R0.00"}}]
[null,null,"Car Hire (Group B)","Sum",1,null,{"v":0,"d":"R0.00"}]
[null,null,"Parking","Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"Total Price for all Disbursement (ZAR) (Excl. VAT). Refer to pricing notes above*",{"$nulls":4},{"$f":"SUM(G31:G34)","v":{"v":0,"d":"R0.00"}}]
[]
[]
[null,"Sub-Totals (Excl. VAT)",null,null,"Pricing Note – Escalation Formula\n\nYear 1 (YR1): The price is fixed, with no escalation applied.\n\nYear 2 (YR2): Escalation of 3.1% is applied to the full YR1 subtotal. Formula:\nYR2 = YR1 × (1 + 3.1%)\n\nYear 3 (YR3): Escalation of 3.0% is applied to the full YR2 subtotal. Formula:\nYR3 = YR2 × (1 + 3.0%)\n\nYear 4 (YR4): Escalation of 2.9% is applied to the full YR3 subtotal. Formula:\nYR4 = YR3 × (1 + 2.9%)\n\nYear 5 (YR5): Escalation of 3.0% is applied to the full YR4 subtotal. Formula:\nYR5 = YR4 × (1 + 3.0%)"]
["A","Port of Durban",{"$f":"SUM(G29:G29)","v":{"v":0,"d":"R0.00"}}]
["B","Disbursements",{"$f":"SUM(G35:G35)","v":{"v":0,"d":"R0.00"}}]
["C","Subtotal YR1 (Excl. VAT) [A+B]",{"$f":"SUM(C39:C40)","v":{"v":0,"d":"R0.00"}}]
["D","YR2 Escalation at 3.1%",{"$f":"C41*(1+3.1%)","v":{"v":0,"d":"R0.00"}}]
["E","YR3 Escalation at 3.0%",{"$f":"C42*(1+3%)","v":{"v":0,"d":"R0.00"}}]
["F","YR4 Escalation at 2.9%",{"$f":"C43*(1+2.9%)","v":{"v":0,"d":"R0.00"}}]
["G","YR5 Escalation at 3.0%",{"$f":"C44*(1+3%)","v":{"v":0,"d":"R0.00"}}]
["H","Total carried to Bid summary [C+D+E+F-G]",{"$f":"SUM(C41:C45)","v":{"v":0,"d":"R0.00"}}]
[]
[]
[null,"Bidder: "]
[null,"Bidder Respresentative Name: "]
[null,"Signature:"]
[null,"VAT registered (Yes / No):"]

{"sheet":"Richards Bay","index":8,"n_rows":52,"n_cols":7,"rows_kept":52,"merged":[[1,1,1,6],[2,1,2,6],[3,1,3,6],[4,1,16,6],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[23,1,23,2],[24,1,24,2],[25,1,25,2],[26,1,26,2],[27,1,27,2],[28,1,28,5],[30,1,33,1],[34,1,34,4],[37,1,37,2],[37,4,45,6]]}
[]
[null,"RICHARDS BAY"]
[null,"PROVISION OF THE MARINE LONG-TERM ECOLOGICAL MONITORING PROGRAM FOR THE PORTS OF RICHARDS BAY, DURBAN, EAST LONDON, NGQURA,\n PORT ELIZABETH, MOSSEL BAY, CAPE TOWN AND SALDANHA FOR FIVE (5) YEARS "]
[null,"SECTION 4: PRICING AND DELIVERY SCHEDULE"]
[null,"Pricing Notes: \n\na) Bidder must ensure that the pricing is inclusive of all related costs, including 3 replicates taken for each sediment and benthic sample as per standard practice. Any cost not specified in the pricing schedule will not be considered/accepted by Transnet.\nb) Respondents are to note that if the price offered by the highest scoring bidder is not market-related, Transnet may not award the contract to that Respondent.     \nTransnet may:\n(i) negotiate a market-related price with the Respondent scoring the highest points or cancel the RFP;\n(ii) if that Respondent does not agree to a market-related price, negotiate a market-related price with the Respondent scoring the second highest points or cancel the RFP;\n(iii) if the Respondent scoring the second highest points does not agree to a market-related price, negotiate a market-related price with the Respondent scoring the third highest points or cancel the RFP.\n(iv) If a market-related price is not agreed with the Respondent scoring the third highest points, Transnet must cancel the RFP.\nc) Prices must be quoted in South African Rand inclusive of VAT.\nd) Disbursements not specifically priced for will not be considered/accepted by Transnet. The overall cost quoted shall be inclusive of all travel and accommodation costs that will be required to complete the scope of work in full per respective port (where applicable). Accommodation and Flights shall be arranged at Government Rates (3-star accommodation) and Economy Class Flights and Basic Car Hire (Group B). Disbursements will be reimbursed at cost price upon presentation of an undisputed invoice. Any disbursement invoiced that is not in line with the aforementioned guidelines will not be accepted by Transnet for payment.  Bidders may be required to provide a detailed breakdown of projected disbursement costs upon request by Transnet prior to finalisation of award.\ne) To facilitate like-for-like comparison bidders must submit pricing strictly in accordance with this pricing schedule and not utilise a different format. Deviation from this pricing schedule or not quoting on every line item for all eight Ports will result in a bid being declared non-responsive.\nf) Respondents, if awarded the contract, are required to indicate that their prices quoted for Year 1 would be kept firm and fixed. Escalations from Year 2 to Year 5 must be capped at CPI projection percentages YR2 3.1%, YR3.0%, YR4 2.9%, YR5 3.0% respectively. The contract price for Year 2 to Year 5 will be revised based on actual inflation increases as published by the Stats SA.\ng) Bidders are required to input prices exclusive of VAT in the green shaded cells. The sheet contains a formula for calculation of subtotals, grand total and VAT. \nh)Totals will automatically be reflected on the bid summary sheet. "]
{"$rows_empty":13}
[null,"Description",null,"Unit of Measure","Quanity","Rate","YEAR 1 (Excl. VAT)\n"]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 23 SAMPLING POINTS FOR SEDIMENT - WINTER\n*All materials, equipment, analysis & labour required for sediments must be considered as per the proposed scope of work. The standard practice is to collect 3 replicate per grab samples, which should be composited for physical and chemical analysis in the lab and then 3 replicate per grab samples for benthic microfauna, which will be analysed as separate samples in the lab.",null,"Sum",1,null,{"$f":"E20*F20","v":{"v":0,"d":"R0.00"}}]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 11 SAMPLING POINTS FOR WATER QUALITY (PRIMARY SAMPLING POINTS) - SUMMER\n*All materials, equipment, analysis & labour required for sediments must be considered as per the proposed scope of work",null,"Sum",1,null,{"$f":"E21*F21","v":{"v":0,"d":"R0.00"}}]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 11 SAMPLING POINTS FOR WATER QUALITY (PRIMARY SAMPLING POINTS) - WINTER\n*All materials, equipment, analysis & labour required for sediments must be considered as per the proposed scope of work",null,"Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 6 SAMPLING POINTS FOR WATER QUALITY (IN SITU SAMPLING POINT) - SUMMER\n*All materials, equipment, analysis & labour required for sediments must be considered as per the proposed scope of work",null,"Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 6 SAMPLING POINTS FOR WATER QUALITY (IN SITU SAMPLING POINT) - WINTER\n*All materials, equipment, analysis & labour required for sediments must be considered as per the proposed scope of work",null,"Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"SAMPLE COLLECTION AND ANALYSIS OF 6 SAMPLING POINTS FOR MUSSELS - WINTER\n*All materials, equipment, analysis & labour required for sediments must be considered as per the proposed scope of work",null,"Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"10 SAMPLE COLLECTION AND ANALYSIS FOR AD HOC WATER QUALITY (POLLUTION INVESTIGATION)\n*All materials, equipment, analysis & labour required for water quality must be considered as per the proposed scope of work",null,"Sum",1,null,{"$f":"'Adhoc Water Quality '!AB71","v":{"v":0,"d":"R0.00"}}]
[null,"REPORT COMPILATION \n*The bidder will submit a total of 2 reports in a year, the first report will be the Sediment Quality analysis results, mainly used for the Dredging Permit application and then the full report at the end of the year for all the monitoring done. ",null,"Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"SAFETY FILE\n*Contractor compliance checklist to include all Ports specific requirements (incl. the annual compliance updates as and when required for the duration of the contract)",null,"EA",1,null,{"v":0,"d":"R0.00"}]
[null,"Sub-Total YR 1 ",{"$nulls":4},{"$f":"SUM(G20:G28)","v":{"v":0,"d":"R0.00"}}]
[null,null,"Item","Unit of Measure","Quanity","Rate","YEAR 1  (Excl. VAT)"]
[null,"Disbursements \n* The disbursement cost will be based on an estimated cost per year for each port. But will be paid based on actual cost incured inline with the above price notes  ","Flights (Economy class)","Sum",1,null,{"$f":"E31*F31","v":{"v":0,"d":"R0.00"}}]
[null,null,"Accommodation (3-star) ","Sum",1,null,{"$f":"E32*F32","v":{"v":0,"d":"R0.00"}}]
[null,null,"Car Hire (Group B)","Sum",1,null,{"v":0,"d":"R0.00"}]
[null,null,"Parking","Sum",1,null,{"v":0,"d":"R0.00"}]
[null,"Total Price for all Disbursement (ZAR) (Excl. VAT). Refer to pricing notes above*",{"$nulls":4},{"$f":"SUM(G31:G34)","v":{"v":0,"d":"R0.00"}}]
[]
[]
[null,"Sub-Totals (Excl. VAT)",null,null,"Pricing Note – Escalation Formula\n\nYear 1 (YR1): The price is fixed, with no escalation applied.\n\nYear 2 (YR2): Escalation of 3.1% is applied to the full YR1 subtotal. Formula:\nYR2 = YR1 × (1 + 3.1%)\n\nYear 3 (YR3): Escalation of 3.0% is applied to the full YR2 subtotal. Formula:\nYR3 = YR2 × (1 + 3.0%)\n\nYear 4 (YR4): Escalation of 2.9% is applied to the full YR3 subtotal. Formula:\nYR4 = YR3 × (1 + 2.9%)\n\nYear 5 (YR5): Escalation of 3.0% is applied to the full YR4 subtotal. Formula:\nYR5 = YR4 × (1 + 3.0%)"]
["A","Port of Richards Bay",{"$f":"SUM(G29:G29)","v":{"v":0,"d":"R0.00"}}]
["B","Disbursements",{"$f":"SUM(G35:G35)","v":{"v":0,"d":"R0.00"}}]
["C","Subtotal YR1 (Excl. VAT) [A+B]",{"$f":"SUM(C39:C40)","v":{"v":0,"d":"R0.00"}}]
["D","YR2 Escalation at 3.1%",{"$f":"C41*(1+3.1%)","v":{"v":0,"d":"R0.00"}}]
["E","YR3 Escalation at 3.0%",{"$f":"C42*(1+3%)","v":{"v":0,"d":"R0.00"}}]
["F","YR4 Escalation at 2.9%",{"$f":"C43*(1+2.9%)","v":{"v":0,"d":"R0.00"}}]
["G","YR5 Escalation at 3.0%",{"$f":"C44*(1+3%)","v":{"v":0,"d":"R0.00"}}]
["H","Total carried to Bid summary [C+D+E+F-G]",{"$f":"SUM(C41:C45)","v":{"v":0,"d":"R0.00"}}]
[]
[]
[null,"Bidder: "]
[null,"Bidder Respresentative Name: "]
[null,"Signature:"]
[null,"VAT registered (Yes / No):"]

{"sheet":"Bid Summary","index":9,"n_rows":22,"n_cols":2,"rows_kept":22,"merged":[[1,0,1,2],[4,0,4,2],[5,0,5,2],[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],[18,1,18,2],[19,1,19,2],[20,1,20,2],[21,1,21,2]]}
[]
["PROVISION OF THE MARINE LONG-TERM ECOLOGICAL MONITORING PROGRAM FOR THE \nPORTS OF RICHARDS BAY, DURBAN, EAST LONDON, NGQURA, PORT ELIZABETH, MOSSEL BAY, \nCAPE TOWN AND SALDANHA FOR FIVE (5) YEARS "]
[]
[]
["BID SUMMARY PER PORT (YEAR 1 TO YEAR 5)"]
["Totals brought forward from Richards Bay, Durban, East London, Ngqura, Port Elizabeth, Mossel Bay,\nCape Town & Saldanha"]
["TOTAL PRICE INCLUDING DISBURSEMENTS AND ESCALATIONS (EXCLUDING VAT) brought forward from - Port of Saldanha",{"$f":"Saldanha!C41","v":{"v":0,"d":"R0.00"}}]
["TOTAL PRICE INCLUDING DISBURSEMENTS AND ESCALATIONS (EXCLUDING VAT) brought forward from - Port of Cape Town",{"$f":"'Cape Town'!C46","v":{"v":0,"d":"R0.00"}}]
["TOTAL PRICE INCLUDING DISBURSEMENTS AND ESCALATIONS (EXCLUDING VAT) brought forward from - Port of Mossel Bay",{"$f":"'Mossel Bay'!C46","v":{"v":0,"d":"R0.00"}}]
["TOTAL PRICE INCLUDING DISBURSEMENTS AND ESCALATIONS (EXCLUDING VAT) brought forward from -Port of Port Elizabeth",{"$f":"'Port Elizabeth'!C46","v":{"v":0,"d":"R0.00"}}]
["TOTAL PRICE INCLUDING DISBURSEMENTS AND ESCALATIONS (EXCLUDING VAT) brought forward from - Port of Ngqura",{"$f":"Ngqura!C46","v":{"v":0,"d":"R0.00"}}]
["TOTAL PRICE INCLUDING DISBURSEMENTS AND ESCALATIONS (EXCLUDING VAT) brought forward from - Port of East London",{"$f":"'East London'!C46","v":{"v":0,"d":"R0.00"}}]
["PRICE INCLUDING DISBURSEMENTS AND ESCALATIONS  (EXCLUDING VAT) brought forward from - Port of Durban",{"$f":"Durban!C46","v":{"v":0,"d":"R0.00"}}]
["TOTAL PRICE INCLUDING DISBURSEMENTS AND ESCALATIONS (EXCLUDING VAT)  brought forward from - Port of Richards Bay",{"$f":"'Richards Bay'!C46","v":{"v":0,"d":"R0.00"}}]
["TOTAL EXCL. VAT",{"$f":"SUM(B7:B14)","v":{"v":0,"d":"R0.00"}}]
["15% VAT",{"$f":"B15*0.15","v":{"v":0,"d":"R0.00"}}]
[" TOTAL INCL. VAT",{"$f":"SUM(B15:B16)","v":{"v":0,"d":"R0.00"}}]
[]
["Bidder: "]
["Bidder Respresentative Name: "]
["Signature:"]
["VAT registered (Yes / No):"]