{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Instructions to PM-don't print","Instructions","B-summary","B1-Daily rates","B2-deliverables"],"not_rendered":{"images":2,"external_links":1,"defined_names":1,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Instructions to PM-don't print","index":0,"n_rows":10,"n_cols":1,"rows_kept":10,"merged":[[7,0,7,9],[8,0,8,9],[9,0,9,9]]}
{"$rows_empty":7}
["INSTRUCTIONS FOR PROJECT MANAGERS - do not print as part of bid"]
["Complete Intructions, B and B2 - red only"]
["See comments on spreadsheet to assist compiling"]

{"sheet":"Instructions","index":1,"n_rows":28,"n_cols":3,"rows_kept":28,"merged":[[7,0,7,12],[8,2,8,12],[10,0,10,12],[11,0,11,12],[12,0,12,12],[13,0,13,12],[14,0,14,12],[15,0,15,12],[17,0,17,12],[18,0,18,12],[19,0,19,12],[20,0,20,12],[21,0,21,12],[22,0,22,12],[23,0,23,12],[24,0,24,12],[25,0,25,12],[26,0,26,12],[27,0,27,12],[28,0,28,12]]}
{"$rows_empty":7}
["PRICE INSTRUCTIONS"]
["DOT/13/2026/CS",null,"APPOINTMENT OF A SERVICE PROVIDER TO RENDER MAINTENANCE TO EXISTING ELECTRONIC SECURITY SYSTEM INCLUDING PROCUREMENT, DELIVERY, REPLACEMENT, INSTALLATION AND COMMISSIONING OF ANY NEW ELECTRONIC SECURITY SYSTEM WHEN REQUIRED AT THE NATIONAL DEPARTMENT OF TRANSPORT FOR A PERIOD OF 36 MONTHS\n"]
[]
["1.  STRUCTURE OF THE TENDER"]
["This spreadsheet  contains the financial response templates for the bid. The bid pricing submission instructions in this document must be read in conjunction with instructions or notes embedded in the various tabs of spreadsheet (Pricing Schedule)."]
[]
["2.  GENERAL INSTRUCTIONS FOR COMPLETING THE PRICING SCHEDULE TEMPLATES"]
["2.1  Tender submission format"]
["2.1.1 Bidders must submit  a paper copy and a protected electronic copy of the Pricing Schedule.\n         In the event of a discrepancy, the paper copy will prevail."]
["2.1.2 Bidders must complete B-Summary and B2-deliverables. B1-Daily rates is optional, if applicable."]
["2.1.2 Bidders must sign all paper copies of their Pricing Schedule."]
["2.2  Input spreadsheets"]
["2.2.1 The Pricing Schedule templates are contained within the one (1) Excel Workbook"]
["2.2.2 Bidders must not  make any changes to the spreadsheets or change the formatting of the Pricing Schedule."]
["2.2.3 Cells are formatted to automatically indicate South African Rands, ordinary text fields and percentages (%) where \n         applicable."]
["2.2.4 Input cells FOR BIDDERS are highlighted in  YELLOW on spreadsheet B. For B1 and B2, bidders must complete all. \n        The Bidder must complete all the relevant input cells for the bid. "]
["2.2.5 Bidders may provide additional breakdown in delivrables are broken up into activities"]
["2.3  Currency and VAT"]
["2.3.1 All Bidders’ pricing must be quoted in South African Rands (ZAR)."]
["2.3.2 The Pricing Schedule template is designed such that VAT will be calculated on Bidders’ input pricing; therefore Bidders \n         must complete the templates with unit prices excluding VAT."]
["2.3.3 If a Bidder is not VAT registered, please indicate and delete the formulas for Spreadsheet B-Summary J35."]

{"sheet":"B-summary","index":2,"n_rows":48,"n_cols":13,"rows_kept":48,"merged":[[1,6,4,10],[6,1,6,2],[6,3,6,5],[6,6,6,8],[6,9,6,10],[7,6,7,8],[9,1,9,2],[9,3,9,10],[11,1,11,2],[11,3,11,10],[14,1,14,4],[14,8,14,10],[15,1,15,4],[16,1,16,4],[17,1,17,4],[18,1,18,4],[20,1,20,10],[21,1,24,8],[21,9,24,10],[26,1,26,8],[27,2,27,8],[28,2,28,8],[29,2,29,8],[30,2,30,8],[31,2,31,8],[32,2,32,8],[33,1,33,8],[34,1,34,8],[35,1,35,8],[37,1,38,10],[40,1,40,4],[40,6,42,10],[41,1,44,4],[44,6,44,11],[45,1,45,4],[45,6,45,11],[46,1,46,4],[47,1,47,4]]}
[]
[{"$nulls":6},"ANNEXURE B\nPricing Schedule"]
[]
[]
[]
[]
[null,"Bid ref. number:",null,"DOT/13/2026/CS",null,null,"Expected project start date:"]
[{"$nulls":6},"Expected duration (Months)"]
[]
[null,"Description of bid:",null,"APPOINTMENT OF A SERVICE PROVIDER TO RENDER MAINTENANCE TO EXISTING ELECTRONIC SECURITY SYSTEM INCLUDING PROCUREMENT, DELIVERY, REPLACEMENT, INSTALLATION AND COMMISSIONING OF ANY NEW ELECTRONIC SECURITY SYSTEM WHEN REQUIRED AT THE NATIONAL DEPARTMENT OF TRANSPORT FOR A PERIOD OF 36 MONTHS\n"]
[]
[null,"Name of bidder:"]
[]
[{"$nulls":5},"Max","Score"]
[null,"PPPFA points allocation",{"$nulls":4},{"$f":"SUM(G16:G18)","v":0},null,"Indicative project time frames"]
[null,"% Black Ownership",{"$nulls":6},"Start","End","Duration"]
[null,"% Black Ownership: Women "]
[null,"% Black Ownership: BDG",{"$nulls":7},"Months"]
[null,"BDG Details:"]
[]
[null,"TOTAL BID PRICE  incl. VAT"]
[null,"1. Total price required to produce/deliver all goods/services included in the Tor.\n2. Please ensure that this price matches the price indicated on SBD 1.\n3. This price will be used for PPPFA comparison purposes.",{"$nulls":7},{"$f":"J36","v":0}]
[]
[]
[]
[]
[null,"PART 1: COSTING OF SERVICES"]
[null,1,"Fully inclusive resource cost for all deliverables (B3)",{"$nulls":6},{"$f":"'B2-deliverables'!G26","v":0}]
[null,2,"Travel and subsistence cost"]
[null,3,"Printing / stationery cost"]
[null,4,"Communication cost"]
[null,5,"Other"]
[null,6,"Other"]
[null,"TOTAL (EXCL VAT)",{"$nulls":7},{"$f":"SUM(J28:J33)","v":0}]
[null,"VAT",{"$nulls":7},{"$f":"SUM(J34*15%)","v":0}]
[null,"TOTAL (INCL VAT)",{"$nulls":7},{"$f":"SUM(J34:J35)","v":0},null,null,{"$f":"SUM(J34)+(J34*15%)","v":0}]
[]
[null,"Bidders may only complete yellow cells.  Any changes to formulas in this spread sheet will invalidate the bid"]
[]
[]
[null,"Confirmation by bidder",{"$nulls":4},"Bidders must print and sign all worksheets (Summary and Annexures B1 to B2)"]
[null,"Signature"]
[]
[]
[{"$nulls":6},"Orange coloured cells to be completed by DOT"]
[null,"Name:",{"$nulls":4},"Yellow coloured cells to be completed by bidder"]
[null,"Designation:"]
[null,"Date:"]

{"sheet":"B1-Daily rates","index":3,"n_rows":25,"n_cols":5,"rows_kept":25,"merged":[[0,2,0,4],[2,0,2,4],[3,0,3,2],[3,3,3,4],[23,2,27,2],[24,1,27,1]]}
["DOT/13/2026/CS",null,"APPOINTMENT OF A SERVICE PROVIDER TO RENDER MAINTENANCE TO EXISTING ELECTRONIC SECURITY SYSTEM INCLUDING PROCUREMENT, DELIVERY, REPLACEMENT, INSTALLATION AND COMMISSIONING OF ANY NEW ELECTRONIC SECURITY SYSTEM WHEN REQUIRED AT THE NATIONAL DEPARTMENT OF TRANSPORT FOR A PERIOD OF 36 MONTHS"]
[]
["Annexure B1: Proposed Team Daily Rates"]
[{"$f":"\"Bidder Name: \"&'[1]Bid Summary'!D12","v":"Bidder Name: "}]
["#","Name of team member","Role (As specified in ToR)","Daily rate","Days"]
[1,{"$nulls":3},{"$f":"[1]Deliverables!AB4","v":0}]
[2,{"$nulls":3},{"$f":"[1]Deliverables!AB5","v":0}]
[3,{"$nulls":3},{"$f":"[1]Deliverables!AB6","v":0}]
[4,{"$nulls":3},{"$f":"[1]Deliverables!AB7","v":0}]
[5,{"$nulls":3},{"$f":"[1]Deliverables!AB8","v":0}]
[6,{"$nulls":3},{"$f":"[1]Deliverables!AB9","v":0}]
[7,{"$nulls":3},{"$f":"[1]Deliverables!AB10","v":0}]
[8,{"$nulls":3},{"$f":"[1]Deliverables!AB11","v":0}]
[9,{"$nulls":3},{"$f":"[1]Deliverables!AB12","v":0}]
[10,{"$nulls":3},{"$f":"[1]Deliverables!AB13","v":0}]
[11,{"$nulls":3},{"$f":"[1]Deliverables!AB14","v":0}]
[12,{"$nulls":3},{"$f":"[1]Deliverables!AB15","v":0}]
[13,{"$nulls":3},{"$f":"[1]Deliverables!AB16","v":0}]
[14,{"$nulls":3},{"$f":"[1]Deliverables!AB17","v":0}]
[15,{"$nulls":3},{"$f":"[1]Deliverables!AB18","v":0}]
["O","Other","Other",null,{"$f":"[1]Deliverables!AB19","v":0}]
[{"$nulls":4},{"$f":"SUM(E6:E21)","v":0}]
[]
[null,"Bidder signature"]
[null,"Signature"]

{"sheet":"B2-deliverables","index":4,"n_rows":30,"n_cols":23,"rows_kept":30,"merged":[[0,2,0,22],[2,0,2,6],[3,0,3,3],[3,4,3,6],[3,7,3,22],[27,6,31,21],[28,1,31,1]]}
["DOT/13/2026/CS",null,"APPOINTMENT OF A SERVICE PROVIDER TO RENDER MAINTENANCE TO EXISTING ELECTRONIC SECURITY SYSTEM INCLUDING PROCUREMENT, DELIVERY, REPLACEMENT, INSTALLATION AND COMMISSIONING OF ANY NEW ELECTRONIC SECURITY SYSTEM WHEN REQUIRED AT THE NATIONAL DEPARTMENT OF TRANSPORT FOR A PERIOD OF 36 MONTHS"]
[]
["Annexure B2: Costing per deliverable"]
[{"$nulls":7},"Days allocated per team member"]
["#","Deliverable / Activities description","Person Days","Start","End","Duration (Days)","Cost \n(EXCL VAT)",1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,"O"]
[1,null,{"$f":"SUM(H6:W6)","v":0},null,null,{"$f":"E6-D6","v":0},{"$f":"SUM(AD6:AS6)","v":0}]
[2,null,{"$f":"SUM(H7:W7)","v":0},null,null,{"$f":"E7-D7","v":0},{"$f":"SUM(AD7:AS7)","v":0}]
[3,null,{"$f":"SUM(H8:W8)","v":0},null,null,{"$f":"E8-D8","v":0},0]
[4,null,0,null,null,0,0]
[5,null,0,null,null,0,0]
[6,null,0,null,null,0,0]
[7,null,0,null,null,0,0]
[8,null,0,null,null,0,0]
[9,null,0,null,null,0,0]
[10,null,0,null,null,0,0]
[11,null,0,null,null,0,0]
[12,null,0,null,null,0,0]
[13,null,0,null,null,0,0]
[14,null,0,null,null,0,0]
[15,null,0,null,null,0,0]
[16,null,0,null,null,0,0]
[17,null,0,null,null,0,0]
[18,null,0,null,null,0,0]
[19,null,0,null,null,0,0]
[20,null,0,null,null,0,0]
[null,null,{"$f":"SUM(C6:C25)","v":0},null,null,{"$f":"SUM(F6:F25)","v":0},{"$f":"SUM(G6:G25)","v":0},{"$f":"SUM(H6:H25)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Bidder signature",null,"Start",{"$f":"MIN(D6:D25)","v":"00:00:00"},null,"The start date for bid purposes is the expected date of award as indicated in proposal.  The start date for contract management purposes will be the actual date of award of the bid.  "]
[null,"Signature",null,"End",{"$f":"MAX(E6:E25)","v":"00:00:00"}]
[{"$nulls":3},"Duration",{"$f":"IF(E29-E28<0,0,E29-E28)","v":0}]