{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["PRICING SCHEDULE"],"not_rendered":{"images":1,"defined_names":3},"read":"whole","date_system":"1900"}

{"sheet":"PRICING SCHEDULE","index":0,"n_rows":59,"n_cols":11,"rows_kept":59,"merged":[[11,2,11,3],[12,2,12,3],[12,5,14,5],[13,2,13,3],[14,2,14,3],[16,4,16,6],[55,1,58,1],[55,2,55,3],[55,4,55,5],[56,2,56,3],[57,2,57,3],[57,4,57,5],[58,2,58,3],[58,4,58,5]]}
[null,"SUPPLY CHAIN MANAGEMENT"]
[null,"Pricing schedule"]
["RFx No","2915-2024"]
["RFx Title","Supply, Installation, Configuration of Local Area Network (LAN) Equipment, i.e. Switches, Wireless Access Controller, Wireless AP and Network Modules for the Eastern Cape Provincial Treasury, and Hardware Warranty for a period of five (5) years"]
["Bidder Name "]
[]
["1. INSTRUCTION FOR COMPLETING THE PRICING SCHEDULE"]
["(a)  Bidder must complete/enter YELLOW cells only"]
["(b)  Unit and Line prices must be VAT EXCLUSIVE and in South African Rand (ZAR) currency."]
["(c) The price must include all cost to deliver the goods or render the service, including all applicable taxes, duty fees, logistics/delivery, storage, labour, overtime and subsistance and travel"]
["(d)  Prices that are dependent on Rate of Exchange (ROE) must use ROE indicated below, then enter in Column \"Forex %\" the percentage of the price that is ROE dependent (0% means the price is not ROE dependent)"]
[null,"Foreign currency","South African Rand (ZAR) exchange rate "]
[null,"1 US Dollar",{"$nulls":3},"Mark with an X, which ROE is applicable"]
[null,"1 Euro"]
[null,"1 Pound (UK)"]
[]
[{"$nulls":4},"YEAR 1",null,null,"TOTAL"]
["Item No","Goods/Service description","Unit of measure","Forex %","Qty ","Unit Price \n(Excl VAT)","Line Price Y1","Line Price Term \n(Excl VAT)","Forex Price portion","BRAND / MODEL","Price clarification comment"]
[1,"East London",{"$nulls":4},{"$f":"SUBTOTAL(9,G20:G23)","v":0},{"$f":"SUBTOTAL(9,H20:H23)","v":0},{"$f":"SUBTOTAL(9,I20:I23)","v":0}]
["1.1","48 port switches ","each",{"v":0,"d":"0%"},3,0,{"$f":"E20*F20","v":0},{"$f":"G20","v":0},{"$f":"D20*H20","v":0}]
["1.2","24 port switches","each",{"v":0,"d":"0%"},1,0,{"$f":"E21*F21","v":0},{"$f":"G21","v":0},{"$f":"D21*H21","v":0}]
["1.3","Wireless Access Points","each",{"v":0,"d":"0%"},4,0,0,0,{"$f":"D22*H22","v":0}]
["1.4","SFP Network Modules","each",{"v":0,"d":"0%"},2,0,0,0,{"$f":"D23*H23","v":0}]
[2,"Port Elizabeth",{"$nulls":4},{"$f":"SUBTOTAL(9,G25:G28)","v":0},{"$f":"SUBTOTAL(9,H25:H28)","v":0},{"$f":"SUBTOTAL(9,I25:I28)","v":0}]
["2.1","48 port switches ","each",{"v":0,"d":"0%"},3,0,{"$f":"E25*F25","v":0},{"$f":"G25","v":0},{"$f":"D25*H25","v":0}]
["2.2","24 port switches","each",{"v":0,"d":"0%"},1,0,{"$f":"E26*F26","v":0},{"$f":"G26","v":0},{"$f":"D26*H26","v":0}]
["2.3","Wireless Access Points","each",{"v":0,"d":"0%"},3,0,0,0,{"$f":"D27*H27","v":0}]
["2.4","SFP Network Modules","each",{"v":0,"d":"0%"},4,0,0,0,{"$f":"D28*H28","v":0}]
[3,"Mount Ayliff",{"$nulls":4},{"$f":"SUBTOTAL(9,G30:G32)","v":0},{"$f":"SUBTOTAL(9,H30:H32)","v":0},{"$f":"SUBTOTAL(9,I30:I32)","v":0}]
["3.1","48 port switches ","each",{"v":0,"d":"0%"},2,0,{"$f":"E30*F30","v":0},{"$f":"G30","v":0},{"$f":"D30*H30","v":0}]
["3.3","Wireless Access Points","each",{"v":0,"d":"0%"},1,0,{"$f":"E31*F31","v":0},{"$f":"G31","v":0},{"$f":"D31*H31","v":0}]
["3.4","SFP Network Modules","each",{"v":0,"d":"0%"},2,0,0,0,{"$f":"D32*H32","v":0}]
[4,"Aliwal North",{"$nulls":4},{"$f":"SUBTOTAL(9,G34:G36)","v":0},0,{"$f":"SUBTOTAL(9,I34:I36)","v":0}]
["4.1","48 port switches ","each",{"v":0,"d":"0%"},2,0,{"$f":"E34*F34","v":0},0,{"$f":"D34*H34","v":0}]
["4.3","Wireless Access Points","each",{"v":0,"d":"0%"},1,0,{"$f":"E35*F35","v":0},0,{"$f":"D35*H35","v":0}]
["4.4","SFP Network Modules","each",{"v":0,"d":"0%"},2,0,0,0,{"$f":"D36*H36","v":0}]
[5,"Queenstown",{"$nulls":4},{"$f":"SUBTOTAL(9,G38:G40)","v":0},0,{"$f":"SUBTOTAL(9,I38:I40)","v":0}]
["5.1","48 port switches ","each",{"v":0,"d":"0%"},2,0,{"$f":"E38*F38","v":0},0,{"$f":"D38*H38","v":0}]
["5.3","Wireless Access Points","each",{"v":0,"d":"0%"},2,0,{"$f":"E39*F39","v":0},0,{"$f":"D39*H39","v":0}]
["5.4","SFP Network Modules","each",{"v":0,"d":"0%"},2,0,0,0,{"$f":"D40*H40","v":0}]
[6,"Mthatha",{"$nulls":4},{"$f":"SUBTOTAL(9,G42:G44)","v":0},0,{"$f":"SUBTOTAL(9,I42:I44)","v":0}]
["6.1","48 port switches ","each",{"v":0,"d":"0%"},2,0,{"$f":"E42*F42","v":0},0,{"$f":"D42*H42","v":0}]
["6.3","Wireless Access Points","each",{"v":0,"d":"0%"},2,0,{"$f":"E43*F43","v":0},0,{"$f":"D43*H43","v":0}]
["6.4","SFP Network Modules","each",{"v":0,"d":"0%"},2,0,0,0,{"$f":"D44*H44","v":0}]
[7,"Hardware Warranty",{"$nulls":4},{"$f":"SUBTOTAL(9, G46:G47)","v":0},0,{"$f":"SUBTOTAL(9, I46:I47)","v":0}]
["7.1","Hardware must be covered with five (5) years vendor warranty and next business day onsite replacement.",null,{"v":0,"d":"0%"},1,0,{"$f":"E46*F46","v":0},0,{"$f":"D46*H46","v":0}]
["7.2","Hardware must be covered with five (5) years reseller next business day on-site replacement or repair.",null,{"v":0,"d":"0%"},1,0,0,0,{"$f":"D47*H47","v":0}]
[8,"Installation and dismantlement",{"$nulls":4},{"$f":"SUBTOTAL(9, G49:G50)","v":0},0,{"$f":"SUBTOTAL(9, I49:I50)","v":0}]
["8.1","Dismantling of existing equipment",null,{"v":0,"d":"0%"},1,0,{"$f":"E49*F49","v":0},0,{"$f":"D49*H49","v":0}]
["8.2","Installation and configuration of new equipment",null,{"v":0,"d":"0%"},1,0,0,0,{"$f":"D50*H50","v":0}]
[null,"TOTAL BID PRICE  (EXCL VAT)",{"$nulls":4},{"$f":"SUBTOTAL(9,G19:G47)","v":0},{"$f":"SUBTOTAL(9,H19:H47)","v":0},{"$f":"SUBTOTAL(9,I19:I47)","v":0}]
[null,"VAT (@15%)",{"$nulls":4},{"$f":"G51*0.15","v":0},{"$f":"H51*0.15","v":0}]
[null,"TOTAL  BID PRICE (INCL VAT)",{"$nulls":4},{"$f":"G51+G52","v":0},{"$f":"H51+H52","v":0}]
[]
[]
[null,"I, the bidder, confirm that the price(s) and rate(s) quoted cover all the goods and/or works specified in the bidding documents; that the price(s) or rate(s) cover all my obligations and I accept that any mistakes regarding price(s), rate(s) or calculations will be at my own risk.\n[Note: First convert to PDF, then add signature]"]
[null,null,"Name",null,"Capacity"]
[]
[null,null,"Signature (above)",null,"Date"]