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

{"sheet":"PRICING SCHEDULE","index":0,"n_rows":47,"n_cols":17,"rows_kept":47,"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],[16,7,16,9],[16,10,16,12],[43,1,46,1],[43,2,43,3],[43,4,43,5],[44,2,44,3],[45,2,45,3],[45,4,45,5],[46,2,46,3],[46,4,46,5]]}
[null,"SUPPLY CHAIN MANAGEMENT"]
[null,"Pricing schedule"]
["RFx No","RFB 2833/2023"]
["RFx Title","Supply, Deliver, Install, Configure, Maintenance and Support of Switches & Wireless Access Points for Limpopo Department of Transport & Community Safety"]
["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",{"v":18.9,"d":"R18.90"},null,null,"Mark with an X, which ROE is applicable"]
[null,"1 Euro",{"v":20.62,"d":"R20.62"}]
[null,"1 Pound (UK)",{"v":23.7,"d":"R23.70"}]
[]
[{"$nulls":4},"YEAR 1",null,null,"YEAR 2",null,null,"YEAR 3",null,null,"TOTAL"]
["Item No","Goods/Service description","Unit of measure","Forex %","Qty ","Unit Price \n(Excl VAT)","Line Price Y1","Qty","Unit Price \n(Excl VAT)","Line Price Y2","Qty","Unit Price \n(Excl VAT)","Line Price Y3","Line Price Term \n(Excl VAT)","Forex Price portion","BRAND / MODEL","Price clarification comment"]
[1,"SUPPLY, DELIVER, INSTALL AND CONFIGURE",{"$nulls":4},{"$f":"SUBTOTAL(9,G20:G29)","v":0},null,null,{"$f":"SUBTOTAL(9,J20:J29)","v":0},null,null,{"$f":"SUBTOTAL(9,M20:M29)","v":0},{"$f":"SUBTOTAL(9,N20:N29)","v":0},{"$f":"SUBTOTAL(9,O20:O29)","v":0}]
["1.1","48 Port POE Access Switches ","Each",{"v":0,"d":"0%"},32,0,{"$f":"E20*F20","v":0},0,null,{"$f":"H20*I20","v":0},0,null,{"$f":"K20*L20","v":0},{"$f":"SUM(G20,J20,M20)","v":0},{"$f":"D20*N20","v":0}]
["1.2","24 Port POE Aggregation/Distribution Switches ","Each",{"v":0,"d":"0%"},2,0,0,0,null,0,0,null,0,{"$f":"SUM(G21,J21,M21)","v":0},0]
["1.3","48 Port Core Switches","Each",{"v":0,"d":"0%"},2,0,0,0,null,0,0,null,0,0,0]
["1.4","Wireless Access Points","Each",{"v":0,"d":"0%"},60,0,0,0,null,0,0,null,0,0,0]
["1.5","Access Points Controller","Each",{"v":0,"d":"0%"},2,0,0,0,null,{"$f":"H24*I24","v":0},0,null,{"$f":"K24*L24","v":0},{"$f":"SUM(G24,J24,M24)","v":0},{"$f":"D24*N24","v":0}]
["1.6","SFP+, 10G Multimode Module (850nm, 0.3KM, LC)","Each",{"v":0,"d":"0%"},30,0,0,0,null,0,0,null,0,0,0]
["1.7","SC-LC multimode Fiber patch leads (1M)","Each",{"v":0,"d":"0%"},40,0,0,0,null,0,0,null,0,0,0]
["1.8","SC-LC multimode Fiber patch leads (2M)","Each",{"v":0,"d":"0%"},20,0,0,0,null,0,0,null,0,0,0]
["1.9","SC-LC multimode Fiber patch leads (3M)","Each",{"v":0,"d":"0%"},20,0,0,0,null,0,0,null,0,0,0]
["1.10","10gig stack Cables","Each",{"v":0,"d":"0%"},30,0,0,0,null,0,0,null,0,0,0]
["1.11","Access Switches License per device  - 36 months","Each",{"v":0,"d":"0%"},32,0,{"$f":"E30*F30*36","v":0},0,null,0,0,null,0,0,0]
["1.12","Aggregation/Distribution Switches License per device - 36 months","Each",{"v":0,"d":"0%"},2,0,{"$f":"E31*F31*36","v":0},0,null,0,0,null,0,0,0]
["1.13","Core Switches License per device - 36 months","Each",{"v":0,"d":"0%"},2,0,{"$f":"E32*F32*36","v":0},0,null,0,0,null,0,0,0]
["1.14","Wireless Access Points License per device - 36 months","Each",{"v":0,"d":"0%"},60,0,{"$f":"E33*F33*36","v":0},0,null,0,0,null,0,0,{"$f":"D33*N33","v":0}]
["1.15","Access Points Controlller License per device - 36 months","Each",{"v":0,"d":"0%"},2,0,{"$f":"E34*F34*30","v":0},0,null,0,0,null,0,0,0]
["1.16","Installation and configuration of the solution","Each",{"v":0,"d":"0%"},90,0,{"$f":"E35*F35","v":0},0,null,0,0,null,0,0,0]
["1.17","Training and Skills Transfer for 7 Technicians","Once-off",{"v":0,"d":"0%"},7,0,{"$f":"E36*F36","v":0},0,null,0,0,null,0,0,0]
[2,"SUPPORT MAINTNANCE",{"$nulls":4},{"$f":"SUBTOTAL(9, G38:G38)","v":0},null,null,{"$f":"SUBTOTAL(9, J38:J38)","v":0},null,null,{"$f":"SUBTOTAL(9, M38:M38)","v":0},{"$f":"SUBTOTAL(9, N38:N38)","v":0},{"$f":"SUBTOTAL(9, O38:O38)","v":0}]
["2.1","Support and Maintanance (16 hours per month)","Per Month",{"v":0,"d":"0%"},12,0,{"$f":"E38*F38","v":0},12,0,0,12,0,{"$f":"K38*L38","v":0},0,0]
[null,"TOTAL BID PRICE  (EXCL VAT)",{"$nulls":4},{"$f":"SUBTOTAL(9,G19:G38)","v":0},null,null,{"$f":"SUBTOTAL(9,J19:J38)","v":0},null,null,{"$f":"SUBTOTAL(9,M19:M38)","v":0},{"$f":"SUBTOTAL(9,N19:N38)","v":0},{"$f":"SUBTOTAL(9,O19:O38)","v":0}]
[null,"VAT (@15%)",{"$nulls":4},{"$f":"G39*0.15","v":0},null,null,{"$f":"J39*0.15","v":0},null,null,{"$f":"M39*0.15","v":0},{"$f":"N39*0.15","v":0}]
[null,"TOTAL  BID PRICE (INCL VAT)",{"$nulls":4},{"$f":"G39+G40","v":0},null,null,{"$f":"J39+J40","v":0},null,null,{"$f":"M39+M40","v":0},{"$f":"N39+N40","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"]