{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Total Bid","Botshabelo","Mulamula","Oliphantshoek","Tshitale","Vuwani"],"not_rendered":{"images":1,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Total Bid","index":0,"n_rows":32,"n_cols":10,"rows_kept":32,"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],[28,1,31,1],[28,2,28,3],[28,4,28,5],[29,2,29,3],[30,2,30,3],[30,4,30,5],[31,2,31,3],[31,4,31,5]]}
[null,"SUPPLY CHAIN MANAGEMENT"]
[null,"Pricing schedule"]
["RFx No"]
["RFx Title","Total Bid for 5 Libraries"]
["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.89,"d":"R18.89"},null,null,"Mark with an X, which ROE is applicable"]
[null,"1 Euro",{"v":20.56,"d":"R20.56"}]
[null,"1 Pound (UK)",{"v":23.58,"d":"R23.58"}]
[]
[]
["Item No","Goods/Service description","Unit of measure","Forex %","Qty ","Unit Price \n(Excl VAT)","Line Price Y1","Forex Price portion","BRAND / MODEL (if applicable)","Price clarification comment"]
["No","Botshabelo Public Library",{"$nulls":4},{"$f":"SUBTOTAL(9,G21:G25)","v":0},{"$f":"SUBTOTAL(9,H21:H25)","v":0}]
[1,"Server Room",{"$nulls":4},{"$f":"SUBTOTAL(9,G21:G25)","v":0}]
["1.1","Botshabelo Public Library","Each",{"v":0,"d":"0%"},1,{"$f":"Botshabelo!$G$135","v":0},{"$f":"E21*F21","v":0},{"$f":"D21*G21","v":0}]
["1.2","Mulamula Public Library","Each",{"v":0,"d":"0%"},1,{"$f":"Mulamula!$G$140","v":0},{"$f":"E22*F22","v":0},{"$f":"D22*G22","v":0}]
["1.3","Oliphantshoek Public Library","Each",{"v":0,"d":"0%"},1,{"$f":"Oliphantshoek!G62","v":0},0,0]
["1.4","Tshitale Public Library","Each",{"v":0,"d":"0%"},1,{"$f":"Tshitale!G62","v":0},0,0]
["1.5","Vuwani Public Library","Each",{"v":0,"d":"0%"},1,{"$f":"Vuwani!G62","v":0},0,0]
[null,"TOTAL BID PRICE  (INCL VAT)",{"$nulls":4},{"$f":"SUBTOTAL(9,G19:G25)","v":0},{"$f":"SUBTOTAL(9,H19:H25)","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"]

{"sheet":"Botshabelo","index":1,"n_rows":141,"n_cols":10,"rows_kept":141,"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],[137,1,140,1],[137,2,137,3],[137,4,137,5],[138,2,138,3],[139,2,139,3],[139,4,139,5],[140,2,140,3],[140,4,140,5]]}
[null,"SUPPLY CHAIN MANAGEMENT"]
[null,"Pricing schedule"]
["RFx No"]
["RFx Title","Supply, Install, and Configure Network Solution of Five Libraries for the Limpopo Department of Sports, Arts and Culture - Botshabelo Public Library"]
["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.89,"d":"R18.89"},null,null,"Mark with an X, which ROE is applicable"]
[null,"1 Euro",{"v":20.56,"d":"R20.56"}]
[null,"1 Pound (UK)",{"v":23.58,"d":"R23.58"}]
[]
[]
["Item No","Goods/Service description","Unit of measure","Forex %","Qty ","Unit Price \n(Excl VAT)","Line Price Y1","Forex Price portion","BRAND / MODEL (if applicable)","Price clarification comment"]
["No","Botshabelo Public Library",{"$nulls":4},{"$f":"SUBTOTAL(9,G21:G132)","v":0},{"$f":"SUBTOTAL(9,H21:H44)","v":0}]
[1,"Server Room",{"$nulls":4},{"$f":"SUBTOTAL(9,G21:G44)","v":0}]
["1.1","Krone UTP CAT6 Data Point complete with 3m flylead and patchlead",null,{"v":0,"d":"0%"},2,0,{"$f":"E21*F21","v":0},{"$f":"D21*G21","v":0}]
["1.2","ADAPTER 22.5 X 45 LEGRAND HK SHUTTER",null,{"v":0,"d":"0%"},2,0,{"$f":"E22*F22","v":0},{"$f":"D22*G22","v":0}]
["1.3","KEYSTONE RJ45 KM8 C6 WHITE STP",null,{"v":0,"d":"0%"},2,0,0,0]
["1.4","Cover Plate P/O 50x50 E/O",null,{"v":0,"d":"0%"},2,0,0,0]
["1.5","Collar 50x50",null,{"v":0,"d":"0%"},2,0,0,0]
["1.6","Euromod Half Blank White",null,{"v":0,"d":"0%"},2,0,0,0]
["1.7","Electrical Normal Power Point  complete, excl CB.",null,{"v":0,"d":"0%"},5,0,0,0]
["1.8","Electrical Dedicated Power Point  complete, excl CB.",null,{"v":0,"d":"0%"},5,0,0,0]
["1.9","Cover 2 X 4 Vert White 16 Amp",null,{"v":0,"d":"0%"},5,0,0,0]
["1.10","Cover Socket 2 X 4 Vert Red Ded 16 Amp For MS2",null,{"v":0,"d":"0%"},5,0,0,0]
["1.11","Plugtop 16 Amp Red",null,{"v":0,"d":"0%"},5,0,0,0]
["1.12","Cable Surfex 6 X 2 Core + Earth","Per Meter",{"v":0,"d":"0%"},40,0,0,0]
["1.13","Cable Surfex 2.5 X 2 Core + Earth dedicated plugs & normal plugs","Per Meter",{"v":0,"d":"0%"},20,0,0,0]
["1.14","Dual Metal Channel (Incl Corners, End Caps Etc.) Easter Oak / Hospital Grey","Per Meter",{"v":0,"d":"0%"},9,0,0,0]
["1.15","Switches 48 PORT POE","Each",{"v":0,"d":"0%"},2,0,0,0]
["1.16","BRADY \"0\" - \"9\" 37/STRIP BLACK/WHITE",null,{"v":0,"d":"0%"},2,0,0,0]
["1.17","BRUSH PANEL SHORT BASE METAL",null,{"v":0,"d":"0%"},8,0,0,0]
["1.18","24 PORT PATCH PANEL CAT 6e LOADED",null,{"v":0,"d":"0%"},4,0,0,0]
["1.19","43U Cabinet. (Includes UPS, power surge protection, cabinet management, etc.)",null,{"v":0,"d":"0%"},1,0,0,0]
["1.20","Smart-UPS, 900 Watts /1500 VA, Input 230V /Output 230V, Interface Port USB, Rack mounted",null,{"v":0,"d":"0%"},1,0,0,0]
["1.21","Distribution Cabinet, Surface Mountable, White, 24 WAY",null,{"v":0,"d":"0%"},1,0,0,0]
["1.22","60a, Earth Leakage",null,{"v":0,"d":"0%"},1,0,0,0]
["1.23","60a 1 Phase CB/Isolator",null,{"v":0,"d":"0%"},1,0,0,0]
["1.24","25a, Circuit Breaker, Std Curve",null,{"v":0,"d":"0%"},15,0,0,0]
[2,"Computer Room",{"$nulls":3},0,{"$f":"SUBTOTAL(9, G46:G60)","v":0},{"$f":"SUBTOTAL(9, H46:H48)","v":0}]
["2.1","Krone UTP CAT6 Data Point complete with 3m flylead and patchlead",null,{"v":0,"d":"0%"},30,0,{"$f":"E46*F46","v":0},0]
["2.2","ADAPTER 22.5 X 45 LEGRAND HK SHUTTER",null,{"v":0,"d":"0%"},30,0,0,0]
["2.3","KEYSTONE RJ45 KM8 C6 WHITE STP",null,{"v":0,"d":"0%"},30,0,0,0]
["2.4","Cover Plate P/O 50x50 E/O",null,{"v":0,"d":"0%"},30,0,0,0]
["2.5","Collar 50x50",null,{"v":0,"d":"0%"},30,0,0,0]
["2.6","Acess point for WIFI AP, Surface mount CAT 6 Wall box",null,{"v":0,"d":"0%"},1,0,0,0]
["2.7","Internal Ceiling mount access point",null,{"v":0,"d":"0%"},1,0,0,0]
["2.8","Euromod Half Blank White",null,{"v":0,"d":"0%"},30,0,0,0]
["2.9","Electrical Normal Power Point  complete, excl CB.",null,{"v":0,"d":"0%"},30,0,0,0]
["2.10","Electrical Dedicated Power Point  complete, excl CB.",null,{"v":0,"d":"0%"},30,0,0,0]
["2.11","Cover 2 X 4 Vert White 16 Amp",null,{"v":0,"d":"0%"},30,0,0,0]
["2.12","Cover Socket 2 X 4 Vert Red Ded 16 Amp For MS2",null,{"v":0,"d":"0%"},30,0,0,0]
["2.13","Plugtop 16 Amp Red",null,{"v":0,"d":"0%"},30,0,0,0]
["2.14","Cable Surfex 2.5 X 2 Core + Earth Dedicated plugs & normal plugs","Per Meter",{"v":0,"d":"0%"},120,0,0,0]
["2.15","Dual Metal Channel (Incl Corners, End Caps Etc.) Easter Oak / Hospital Grey","Per Meter",{"v":0,"d":"0%"},20,0,0,0]
[3,"Study Place",{"$nulls":4},{"$f":"SUBTOTAL(9,G62:G88)","v":0},{"$f":"SUBTOTAL(9,H62:H88)","v":0}]
["3.1","Krone UTP CAT6 Data Point complete with 3m flylead and patchlead",null,{"v":0,"d":"0%"},32,0,0,0]
["3.2","ADAPTER 22.5 X 45 LEGRAND HK SHUTTER",null,{"v":0,"d":"0%"},32,0,0,0]
["3.3","KEYSTONE RJ45 KM8 C6 WHITE STP",null,{"v":0,"d":"0%"},32,0,0,0]
["3.4","Cover Plate P/O 50x50 E/O",null,{"v":0,"d":"0%"},32,0,0,0]
["3.5","Collar 50x50",null,{"v":0,"d":"0%"},32,0,0,0]
["3.6","Euromod Half Blank White",null,{"v":0,"d":"0%"},32,0,0,0]
["3.7","Electrical Normal Power Point  complete, excl CB.",null,{"v":0,"d":"0%"},32,0,0,0]
["3.8","Electrical Dedicated Power Point  complete, excl CB.",null,{"v":0,"d":"0%"},32,0,0,0]
["3.9","Cover 2 X 4 Vert White 16 Amp",null,{"v":0,"d":"0%"},32,0,0,0]
["3.10","Cover Socket 2 X 4 Vert Red Ded 16 Amp For MS2",null,{"v":0,"d":"0%"},32,0,0,0]
["3.11","Plugtop 16 Amp Red",null,{"v":0,"d":"0%"},32,0,0,0]
["3.12","Cable Surfex 2.5 X 2 Core + Earth Dedicated plugs & normal plugs","Per Metre",{"v":0,"d":"0%"},240,0,0,0]
["3.13","Dual Metal Channel (Incl Corners, End Caps Etc.) Easter Oak / Hospital Grey","Per Metre",{"v":0,"d":"0%"},20,0,0,0]
[4,"Childrens Room",{"$nulls":4},{"$f":"SUBTOTAL(9,G76:G88)","v":0},0]
["4.1","Krone UTP CAT6 Data Point complete with 3m flylead and patchlead",null,{"v":0,"d":"0%"},6,0,0,0]
["4.2","ADAPTER 22.5 X 45 LEGRAND HK SHUTTER",null,{"v":0,"d":"0%"},6,0,0,0]
["4.3","KEYSTONE RJ45 KM8 C6 WHITE STP",null,{"v":0,"d":"0%"},6,0,0,0]
["4.4","Cover Plate P/O 50x50 E/O",null,{"v":0,"d":"0%"},6,0,0,0]
["4.5","Collar 50x50",null,{"v":0,"d":"0%"},6,0,0,0]
["4.6","Euromod Half Blank White",null,{"v":0,"d":"0%"},6,0,0,0]
["4.7","Electrical Normal Power Point  complete, excl CB.",null,{"v":0,"d":"0%"},6,0,0,0]
["4.8","Electrical Dedicated Power Point  complete, excl CB.",null,{"v":0,"d":"0%"},6,0,0,0]
["4.9","Cover 2 X 4 Vert White 16 Amp",null,{"v":0,"d":"0%"},6,0,0,0]
["4.10","Cover Socket 2 X 4 Vert Red Ded 16 Amp For MS2",null,{"v":0,"d":"0%"},6,0,0,0]
["4.11","Plugtop 16 Amp Red",null,{"v":0,"d":"0%"},6,0,0,{"$f":"D86*G86","v":0}]
["4.12","Cable Surfex 2.5 X 2 Core + Earth Dedicated plugs & normal plugs","Per Metre",{"v":0,"d":"0%"},120,0,0,0]
["4.13","Dual Metal Channel (Incl Corners, End Caps Etc.) Easter Oak / Hospital Grey","Per Metre",{"v":0,"d":"0%"},10,0,0,0]
[5,"Librarian Office",{"$nulls":4},{"$f":"SUBTOTAL(9,G90:G102)","v":0},{"$f":"SUBTOTAL(9,H90:H102)","v":0}]
["5.1","Krone UTP CAT6 Data Point complete with 3m flylead and patchlead",null,{"v":0,"d":"0%"},6,0,0,0]
["5.2","ADAPTER 22.5 X 45 LEGRAND HK SHUTTER",null,{"v":0,"d":"0%"},6,0,0,0]
["5.3","KEYSTONE RJ45 KM8 C6 WHITE STP",null,{"v":0,"d":"0%"},6,0,0,0]
["5.4","Cover Plate P/O 50x50 E/O",null,{"v":0,"d":"0%"},6,0,0,0]
["5.5","Collar 50x50",null,{"v":0,"d":"0%"},6,0,0,0]
["5.6","Euromod Half Blank White",null,{"v":0,"d":"0%"},6,0,0,0]
["5.7","Electrical Normal Power Point  complete, excl CB.",null,{"v":0,"d":"0%"},6,0,0,0]
["5.8","Electrical Dedicated Power Point  complete, excl CB.",null,{"v":0,"d":"0%"},6,0,0,0]
["5.9","Cover 2 X 4 Vert White 16 Amp",null,{"v":0,"d":"0%"},6,0,0,0]
["5.10","Cover Socket 2 X 4 Vert Red Ded 16 Amp For MS2",null,{"v":0,"d":"0%"},6,0,0,0]
["5.11","Plugtop 16 Amp Red",null,{"v":0,"d":"0%"},6,0,0,0]
["5.12","Cable Surfex 2.5 X 2 Core + Earth Dedicated plugs & normal plugs","Per Metre",{"v":0,"d":"0%"},120,0,0,0]
["5.13","Dual Metal Channel (Incl Corners, End Caps Etc.) Easter Oak / Hospital Grey","Per Metre",{"v":0,"d":"0%"},15,0,0,0]
[6,"Reception Office",{"$nulls":4},{"$f":"SUBTOTAL(9,G104:G118)","v":0}]
["6.1","Krone UTP CAT6 Data Point complete with 3m flylead and patchlead",null,{"v":0,"d":"0%"},8,0,0,0]
["6.2","ADAPTER 22.5 X 45 LEGRAND HK SHUTTER",null,{"v":0,"d":"0%"},8,0,0,0]
["6.3","KEYSTONE RJ45 KM8 C6 WHITE STP",null,{"v":0,"d":"0%"},8,0,0,0]
["6.4","Cover Plate P/O 50x50 E/O",null,{"v":0,"d":"0%"},8,0,0,0]
["6.5","Collar 50x50",null,{"v":0,"d":"0%"},8,0,0,0]
["6.6","Acess point for WIFI AP, Surface mount CAT 6 wall box",null,{"v":0,"d":"0%"},1,0,0,0]
["6.7","Internal Ceiling mount access point",null,{"v":0,"d":"0%"},1,0,{"$f":"E110*F110","v":0},0]
["6.8","Euromod Half Blank White",null,{"v":0,"d":"0%"},8,0,0,0]
["6.9","Electrical Normal Power Point  complete, excl CB.",null,{"v":0,"d":"0%"},8,0,0,0]
["6.10","Electrical Dedicated Power Point  complete, excl CB.",null,{"v":0,"d":"0%"},8,0,0,0]
["6.11","Cover 2 X 4 Vert White 16 Amp",null,{"v":0,"d":"0%"},8,0,0,0]
["6.12","Cover Socket 2 X 4 Vert Red Ded 16 Amp For MS2",null,{"v":0,"d":"0%"},8,0,0,0]
["6.13","Plugtop 16 Amp Red",null,{"v":0,"d":"0%"},8,0,0,0]
["6.14","Cable Surfex 2.5 X 2 Core + Earth Dedicated plugs & normal plugs","Per Metre",{"v":0,"d":"0%"},60,0,0,0]
["6.15","Dual Metal Channel (Incl Corners, End Caps Etc.) Easter Oak / Hospital Grey","Per Metre",{"v":0,"d":"0%"},15,0,0,0]
[7,"Sundries/Infrastructure",{"$nulls":4},{"$f":"SUBTOTAL(9,G120:G124)","v":0},{"$f":"SUBTOTAL(9,H120:H124)","v":0}]
["7.1","Tape Brother White 9mm / BRADY \"0\" - \"9\" 37/STRIP BLACK/WHITE",null,{"v":0,"d":"0%"},2,0,0,0]
["7.2","Insulation Tape - Black",null,{"v":0,"d":"0%"},2,0,0,0]
["7.3","Knock Inns 6 X 55",null,{"v":0,"d":"0%"},300,0,0,0]
["7.4","M6 Flat Washer",null,{"v":0,"d":"0%"},100,0,0,0]
["7.5","Silicone",null,{"v":0,"d":"0%"},3,0,0,0]
[8,"Documentation",{"$nulls":4},{"$f":"SUBTOTAL(9,G126:G132)","v":0},{"$f":"SUBTOTAL(9,H126:H132)","v":0}]
["8.1","Test Data Point",null,{"v":0,"d":"0%"},86,0,0,0]
["8.2","UTP Labelling",null,{"v":0,"d":"0%"},172,0,0,0]
["8.3","Power Labelling",null,{"v":0,"d":"0%"},172,0,0,0]
["8.4","Schematic Layout Of Network",null,{"v":0,"d":"0%"},3,0,0,0]
["8.5","Data Certification",null,{"v":0,"d":"0%"},1,0,0,0]
["8.6","UTP Test Results",null,{"v":0,"d":"0%"},1,0,0,0]
["8.7","COC - Electrical Certification",null,{"v":0,"d":"0%"},1,0,0,0]
[null,"TOTAL BID PRICE  (EXCL VAT)",{"$nulls":4},{"$f":"SUBTOTAL(9,G19:G132)","v":0},{"$f":"SUBTOTAL(9,H19:H132)","v":0}]
[null,"VAT (@15%)",{"$nulls":4},{"$f":"G133*0.15","v":0}]
[null,"TOTAL  BID PRICE (INCL VAT)",{"$nulls":4},{"$f":"G133+G134","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"]

{"sheet":"Mulamula","index":2,"n_rows":146,"n_cols":10,"rows_kept":146,"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],[142,1,145,1],[142,2,142,3],[142,4,142,5],[143,2,143,3],[144,2,144,3],[144,4,144,5],[145,2,145,3],[145,4,145,5]]}
[null,"SUPPLY CHAIN MANAGEMENT"]
[null,"Pricing schedule"]
["RFx No"]
["RFx Title","Supply, Install, and Configure Network Solution of Five Libraries for the Limpopo Department of Sports, Arts and Culture - Mulamula Public Library"]
["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.89,"d":"R18.89"},null,null,"Mark with an X, which ROE is applicable"]
[null,"1 Euro",{"v":20.56,"d":"R20.56"}]
[null,"1 Pound (UK)",{"v":23.58,"d":"R23.58"}]
[]
[]
["Item No","Goods/Service description","Unit of measure","Forex %","Qty ","Unit Price \n(Excl VAT)","Line Price Y1","Forex Price portion","BRAND / MODEL (if applicable)","Price clarification comment"]
["No","Mulamula Public Library",{"$nulls":4},{"$f":"SUBTOTAL(9,G21:G137)","v":0},{"$f":"SUBTOTAL(9,H21:H137)","v":0}]
[1,"Reception",{"$nulls":4},{"$f":"SUBTOTAL(9,G22:G34)","v":0}]
["1.1","UTP CAT6e Data Point complete with flylead and patchlead","Per Point",{"v":0,"d":"0%"},3,0,{"$f":"E21*F21","v":0},{"$f":"D21*G21","v":0}]
["1.2","45deg ADAPTER PLATE for COMPACT","Each",{"v":0,"d":"0%"},3,0,{"$f":"E22*F22","v":0},{"$f":"D22*G22","v":0}]
["1.3","RJ 45 WHITE SHUTTER CAT 6 ","Each",{"v":0,"d":"0%"},3,0,0,0]
["1.4","TRUNKING FRAME 50 x 50","Each",{"v":0,"d":"0%"},3,0,0,0]
["1.5","25 X 50 BLANK ","Each",{"v":0,"d":"0%"},3,0,0,0]
["1.6","Electrical Dedicated Power Point  complete, excl CB.","Per Point",{"v":0,"d":"0%"},3,0,0,0]
["1.7","15a Dedicated Plugtop","Each",{"v":0,"d":"0%"},3,0,0,0]
["1.8","15a Plug Assembly, Dedicated Power, Color Red, For Mounting In P801 Metal Skirting","Each",{"v":0,"d":"0%"},3,0,0,0]
["1.9","Wire, Electrical, Surfex, 2.5 Mm2(Normal Plugs)","P/M",{"v":0,"d":"0%"},80,0,0,0]
["1.10","Electrical Normal Power Point  complete, excl CB.","Per Point",{"v":0,"d":"0%"},3,0,0,0]
["1.11","15a Standard Plugtop","Each",{"v":0,"d":"0%"},3,0,0,0]
["1.12","15a Plug Assembly, Normal Power,  For Mounting In P801 Metal Skirting","Each",{"v":0,"d":"0%"},3,0,0,0]
["1.13","Wire, Electrical, Surfex, 2.5 Mm2(Red Plugs)","P/M",{"v":0,"d":"0%"},80,0,0,0]
["1.14","Dual Metal Channel  (Incl Corners, End Caps Etc)","P/M",{"v":0,"d":"0%"},60,0,0,0]
[2,"Librarian Office",{"$nulls":4},{"$f":"SUBTOTAL(9, G36:G49)","v":0},{"$f":"SUBTOTAL(9, H36:H49)","v":0}]
["2.1","UTP CAT6e Data Point complete with flylead and patchlead","Per Point",{"v":0,"d":"0%"},3,0,0,0]
["2.2","45deg ADAPTER PLATE for COMPACT","Each",{"v":0,"d":"0%"},3,0,0,0]
["2.3","RJ 45 WHITE SHUTTER CAT 6 ","Each",{"v":0,"d":"0%"},3,0,0,0]
["2.4","TRUNKING FRAME 50 x 50","Each",{"v":0,"d":"0%"},3,0,0,0]
["2.5","25 X 50 BLANK ","Each",{"v":0,"d":"0%"},3,0,0,0]
["2.6","Electrical Dedicated Power Point  complete, excl CB.","Per Point",{"v":0,"d":"0%"},3,0,0,0]
["2.7","15a Dedicated Plugtop","Each",{"v":0,"d":"0%"},3,0,0,0]
["2.8","15a Plug Assembly, Dedicated Power, Color Red, For Mounting In P801 Metal Skirting","Each",{"v":0,"d":"0%"},3,0,0,0]
["2.9","Wire, Electrical, Surfex, 2.5 Mm2(Normal Plugs)","P/M",{"v":0,"d":"0%"},80,0,0,0]
["2.10","Electrical Normal Power Point  complete, excl CB.","Per Point",{"v":0,"d":"0%"},3,0,0,0]
["2.11","15a Standard Plugtop","Each",{"v":0,"d":"0%"},3,0,0,0]
["2.12","15a Plug Assembly, Normal Power,  For Mounting In P801 Metal Skirting","Each",{"v":0,"d":"0%"},3,0,0,0]
["2.13","Wire, Electrical, Surfex, 2.5 Mm2(Red Plugs)","P/M",{"v":0,"d":"0%"},80,0,0,0]
["2.14","Dual Metal Channel  (Incl Corners, End Caps Etc)","P/M",{"v":0,"d":"0%"},60,0,0,0]
[3,"Computer Room",{"$nulls":4},{"$f":"SUBTOTAL(9, G51:G66)","v":0},{"$f":"SUBTOTAL(9, H51:H66)","v":0}]
["3.1","UTP CAT6e Data Point complete with flylead and patchlead","Per Point",{"v":0,"d":"0%"},18,0,0,0]
["3.2","45deg ADAPTER PLATE for COMPACT","Each",{"v":0,"d":"0%"},18,0,0,0]
["3.3","RJ 45 WHITE SHUTTER CAT 6 ","Each",{"v":0,"d":"0%"},18,0,0,0]
["3.4","TRUNKING FRAME 50 x 50","Each",{"v":0,"d":"0%"},18,0,0,0]
["3.5","25 X 50 BLANK ","Each",{"v":0,"d":"0%"},18,0,0,0]
["3.6","Electrical Dedicated Power Point  complete, excl CB.","Per Point",{"v":0,"d":"0%"},18,0,0,0]
["3.7","15a Dedicated Plugtop","Each",{"v":0,"d":"0%"},18,0,0,0]
["3.8","15a Plug Assembly, Dedicated Power, Color Red, For Mounting In P801 Metal Skirting","Each",{"v":0,"d":"0%"},18,0,0,0]
["3.9","Wire, Electrical, Surfex, 2.5 Mm2(Normal Plugs)","P/M",{"v":0,"d":"0%"},140,0,0,0]
["3.10","Electrical Normal Power Point  complete, excl CB.","Per Point",{"v":0,"d":"0%"},18,0,0,0]
["3.11","Electrical 2 Pin 5 A Power outlet.","Per Point",{"v":0,"d":"0%"},2,0,0,0]
["3.12","15a Standard Plugtop","Each",{"v":0,"d":"0%"},18,0,0,0]
["3.13","15a Plug Assembly, Normal Power,  For Mounting In P801 Metal Skirting","Each",{"v":0,"d":"0%"},18,0,0,0]
["3.14","Wire, Electrical, Surfex, 2.5 Mm2(Red Plugs)","P/M",{"v":0,"d":"0%"},140,0,0,0]
["3.15","Dual Metal Channel  (Incl Corners, End Caps Etc)","P/M",{"v":0,"d":"0%"},160,0,0,0]
["3.16","Wifi/APS Connectors","Per Point",{"v":0,"d":"0%"},1,0,0,0]
[4,"Activity Room",{"$nulls":4},{"$f":"SUBTOTAL(9, G68:G83)","v":0},{"$f":"SUBTOTAL(9, H68:H83)","v":0}]
["4.1","UTP CAT6e Data Point complete with flylead and patchlead","Per Point",{"v":0,"d":"0%"},21,0,0,0]
["4.2","45deg ADAPTER PLATE for COMPACT","Each",{"v":0,"d":"0%"},21,0,0,0]
["4.3","RJ 45 WHITE SHUTTER CAT 6 ","Each",{"v":0,"d":"0%"},21,0,0,0]
["4.4","TRUNKING FRAME 50 x 50","Each",{"v":0,"d":"0%"},21,0,0,0]
["4.5","25 X 50 BLANK ","Each",{"v":0,"d":"0%"},21,0,0,0]
["4.6","Electrical Dedicated Power Point  complete, excl CB.","Per Point",{"v":0,"d":"0%"},21,0,0,0]
["4.7","15a Dedicated Plugtop","Each",{"v":0,"d":"0%"},21,0,0,0]
["4.8","15a Plug Assembly, Dedicated Power, Color Red, For Mounting In P801 Metal Skirting","Each",{"v":0,"d":"0%"},21,0,0,0]
["4.9","Wire, Electrical, Surfex, 2.5 Mm2(Normal Plugs)","P/M",{"v":0,"d":"0%"},120,0,0,0]
["4.10","Electrical Normal Power Point  complete, excl CB.","Per Point",{"v":0,"d":"0%"},21,0,0,0]
["4.11","Electrical 2 Pin 5 A Power outlet.","Per Point",{"v":0,"d":"0%"},1,0,0,0]
["4.12","15a Standard Plugtop","Each",{"v":0,"d":"0%"},21,0,0,0]
["4.13","15a Plug Assembly, Normal Power,  For Mounting In P801 Metal Skirting","Each",{"v":0,"d":"0%"},21,0,0,0]
["4.14","Wire, Electrical, Surfex, 2.5 Mm2(Red Plugs)","P/M",{"v":0,"d":"0%"},120,0,0,0]
["4.15","Dual Metal Channel  (Incl Corners, End Caps Etc)","P/M",{"v":0,"d":"0%"},160,0,0,0]
["4.16","Wifi/APS Connectors","Per Point",{"v":0,"d":"0%"},1,0,0,0]
[5,"Children Library",{"$nulls":4},{"$f":"SUBTOTAL(9, G85:G98)","v":0},{"$f":"SUBTOTAL(9, H85:H98)","v":0}]
["5.1","UTP CAT6e Data Point complete with flylead and patchlead","Per Point",{"v":0,"d":"0%"},8,0,0,0]
["5.2","45deg ADAPTER PLATE for COMPACT","Each",{"v":0,"d":"0%"},8,0,{"$f":"E86*F86","v":0},0]
["5.3","RJ 45 WHITE SHUTTER CAT 6 ","Each",{"v":0,"d":"0%"},8,0,0,0]
["5.4","TRUNKING FRAME 50 x 50","Each",{"v":0,"d":"0%"},8,0,0,0]
["5.5","25 X 50 BLANK ","Each",{"v":0,"d":"0%"},8,0,0,0]
["5.6","Electrical Dedicated Power Point  complete, excl CB.","Per Point",{"v":0,"d":"0%"},8,0,0,0]
["5.7","15a Dedicated Plugtop","Each",{"v":0,"d":"0%"},8,0,0,0]
["5.8","15a Plug Assembly, Dedicated Power, Color Red, For Mounting In P801 Metal Skirting","Each",{"v":0,"d":"0%"},8,0,0,0]
["5.9","Wire, Electrical, Surfex, 2.5 Mm2(Normal Plugs)","P/M",{"v":0,"d":"0%"},90,0,0,0]
["5.10","Electrical Normal Power Point  complete, excl CB.","Per Point",{"v":0,"d":"0%"},8,0,0,0]
["5.11","15a Standard Plugtop","Each",{"v":0,"d":"0%"},8,0,0,0]
["5.12","15a Plug Assembly, Normal Power,  For Mounting In P801 Metal Skirting","Each",{"v":0,"d":"0%"},8,0,0,0]
["5.13","Wire, Electrical, Surfex, 2.5 Mm2","P/M",{"v":0,"d":"0%"},90,0,0,0]
["5.14","Dual Metal Channel  (Incl Corners, End Caps Etc)","P/M",{"v":0,"d":"0%"},80,0,0,0]
[6,"Main Library",{"$nulls":4},{"$f":"SUBTOTAL(9, G100:G115)","v":0},{"$f":"SUBTOTAL(9, H100:H115)","v":0}]
["6.1","UTP CAT6e Data Point complete with flylead and patchlead","Per Point",{"v":0,"d":"0%"},10,0,0,0]
["6.2","45deg ADAPTER PLATE for COMPACT","Each",{"v":0,"d":"0%"},10,0,0,0]
["6.3","RJ 45 WHITE SHUTTER CAT 6 ","Each",{"v":0,"d":"0%"},10,0,0,0]
["6.4","TRUNKING FRAME 50 x 50","Each",{"v":0,"d":"0%"},10,0,0,0]
["6.5","25 X 50 BLANK ","Each",{"v":0,"d":"0%"},10,0,0,0]
["6.6","Electrical Dedicated Power Point  complete, excl CB.","Per Point",{"v":0,"d":"0%"},10,0,0,0]
["6.7","15a Dedicated Plugtop","Each",{"v":0,"d":"0%"},10,0,0,0]
["6.8","15a Plug Assembly, Dedicated Power, Color Red, For Mounting In P801 Metal Skirting","Each",{"v":0,"d":"0%"},10,0,0,0]
["6.9","Wire, Electrical, Surfex, 2.5 Mm2","P/M",{"v":0,"d":"0%"},170,0,0,0]
["6.10","Electrical Normal Power Point  complete, excl CB.","Per Point",{"v":0,"d":"0%"},10,0,0,0]
["6.11","Electrical 2 Pin 5 A Power outlet.","Per Point",{"v":0,"d":"0%"},2,0,0,0]
["6.12","15a Standard Plugtop","Each",{"v":0,"d":"0%"},10,0,0,0]
["6.13","15a Plug Assembly, Normal Power,  For Mounting In P801 Metal Skirting","Each",{"v":0,"d":"0%"},10,0,0,0]
["6.14","Wire, Electrical, Surfex, 2.5 Mm2(Red Plugs)","P/M",{"v":0,"d":"0%"},170,0,0,0]
["6.15","Dual Metal Channel  (Incl Corners, End Caps Etc) Easter Oak","P/M",{"v":0,"d":"0%"},140,0,0,0]
["6.16","Wifi/APS Connectors","Per Point",{"v":0,"d":"0%"},1,0,0,0]
[7,"Power Requirements (SUB BD)",{"$nulls":4},{"$f":"SUBTOTAL(9, G117:G120)","v":0},{"$f":"SUBTOTAL(9, H117:H120)","v":0}]
["7.1","Distribution Cabinet, Surface Mountable, White, 400mm X 300mm X 150mm","Each",{"v":0,"d":"0%"},1,0,0,0]
["7.2","60a, Earth Leakage, Heineman","Each",{"v":0,"d":"0%"},1,0,0,0]
["7.3","60a 1 Phase CB/Isolator","Each",{"v":0,"d":"0%"},1,0,0,0]
["7.4","25a, Circuit Breaker, Heinemann, Std Curve","Each",{"v":0,"d":"0%"},16,0,0,0]
[8,"Infrastructure/Sundries",{"$nulls":4},{"$f":"SUBTOTAL(9, G122:G132)","v":0},{"$f":"SUBTOTAL(9, H122:H132)","v":0}]
["8.1","Nail in Anchors Hilti 6 x 55","Each",{"v":0,"d":"0%"},100,0,0,0]
["8.2","Tape 9mm","Each",{"v":0,"d":"0%"},6,0,0,0]
["8.3","M6  Flat Washer","Each",{"v":0,"d":"0%"},100,0,0,0]
["8.4","Silicone","Each",{"v":0,"d":"0%"},4,0,0,0]
["8.5","BRADY \"0\"  - \"9\" 37/STRIP  BLACK/WHITE","Each",{"v":0,"d":"0%"},10,0,0,0]
["8.6","BRADY \"A\"  - \"Z\" 37/STRIP  BLACK/WHITE","Each",{"v":0,"d":"0%"},10,0,0,0]
["8.7","BRUSH PANEL SHORT BASE METAL","Each",{"v":0,"d":"0%"},3,0,0,0]
["8.8","24 PORT PATCH PANEL CAT 6e LOADED","Each",{"v":0,"d":"0%"},3,0,0,0]
["8.9","48 Port Switch","Each",{"v":0,"d":"0%"},2,0,0,0]
["8.10","1800BTU air-conditioner including installation","Each",{"v":0,"d":"0%"},1,0,0,0]
["8.11","25U Cabinet. (Includes UPS, power surge protection, cabinet management, etc)","Each",{"v":0,"d":"0%"},1,0,0,0]
[9,"Documentation",{"$nulls":4},{"$f":"SUBTOTAL(9, G134:G137)","v":0},{"$f":"SUBTOTAL(9, H134:H137)","v":0}]
["9.1","UTP testing and labeling","P/P",{"v":0,"d":"0%"},63,0,{"$f":"E134*F134","v":0},0]
["9.2","Power Testing and labeling","P/P",{"v":0,"d":"0%"},126,0,0,0]
["9.3","Cabling Certification","Each",{"v":0,"d":"0%"},1,0,0,0]
["9.4","Schematic Layout Of Network","P/H",{"v":0,"d":"0%"},4,0,0,0]
[null,"TOTAL BID PRICE  (EXCL VAT)",{"$nulls":4},{"$f":"SUBTOTAL(9,G19:G137)","v":0},{"$f":"SUBTOTAL(9,H19:H137)","v":0}]
[null,"VAT (@15%)",{"$nulls":4},{"$f":"G138*0.15","v":0}]
[null,"TOTAL  BID PRICE (INCL VAT)",{"$nulls":4},{"$f":"G138+G139","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"]

{"sheet":"Oliphantshoek","index":3,"n_rows":68,"n_cols":10,"rows_kept":68,"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],[64,1,67,1],[64,2,64,3],[64,4,64,5],[65,2,65,3],[66,2,66,3],[66,4,66,5],[67,2,67,3],[67,4,67,5]]}
[null,"SUPPLY CHAIN MANAGEMENT"]
[null,"Pricing schedule"]
["RFx No"]
["RFx Title","Supply, Install, and Configure Network Solution of Five Libraries for the Limpopo Department of Sports, Arts and Culture - Oliphantshoek Modular Library"]
["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.89,"d":"R18.89"},null,null,"Mark with an X, which ROE is applicable"]
[null,"1 Euro",{"v":20.56,"d":"R20.56"}]
[null,"1 Pound (UK)",{"v":23.58,"d":"R23.58"}]
[]
[]
["Item No","Goods/Service description","Unit of measure","Forex %","Qty ","Unit Price \n(Excl VAT)","Line Price Y1","Forex Price portion","BRAND / MODEL (if applicable)","Price clarification comment"]
[1,"Oliphantshoek Modular Library",{"$nulls":4},{"$f":"SUBTOTAL(9,G20:G59)","v":0},{"$f":"SUBTOTAL(9,H20:H59)","v":0}]
["1.1","Krone UTP CAT6 Data Point complete with 3m flylead and patchlead",null,{"v":0,"d":"0%"},30,0,{"$f":"E20*F20","v":0},{"$f":"D20*G20","v":0}]
["1.2","ADAPTER 22.5 X 45 LEGRAND HK SHUTTER",null,{"v":0,"d":"0%"},30,0,{"$f":"E21*F21","v":0},{"$f":"D21*G21","v":0}]
["1.3","KEYSTONE RJ45 KM8 C6 WHITE STP",null,{"v":0,"d":"0%"},30,0,0,0]
["1.4","Cover Plate P/O 50x50 E/O",null,{"v":0,"d":"0%"},30,0,0,0]
["1.5","Collar 50x50",null,{"v":0,"d":"0%"},30,0,0,0]
["1.6","Euromod Half Blank White",null,{"v":0,"d":"0%"},30,0,0,0]
["1.7","Surface mount DATA POINT",null,{"v":0,"d":"0%"},1,0,0,0]
["1.8","Electrical Normal Power Point  complete, excl CB.",null,{"v":0,"d":"0%"},30,0,0,0]
["1.9","Electrical Dedicated Power Point  complete, excl CB.",null,{"v":0,"d":"0%"},30,0,0,0]
["1.10","Cover 2 X 4 Vert White 16 Amp",null,{"v":0,"d":"0%"},30,0,0,0]
["1.11","Cover Socket 2 X 4 Vert Red Ded 16 Amp For MS2",null,{"v":0,"d":"0%"},30,0,0,0]
["1.12","Plugtop 16 Amp Red",null,{"v":0,"d":"0%"},30,0,0,0]
["1.13","Cable Surfex 6 X 2 Core + Earth","Metre",{"v":0,"d":"0%"},240,0,0,0]
["1.14","Dual Metal Channel (Incl Corners, End Caps Etc.) Easter Oak / Hospital Grey","Metre",{"v":0,"d":"0%"},65,0,0,0]
["1.15","yt2 Surface mount trunking","Metre",{"v":0,"d":"0%"},9,0,0,0]
["1.16","Switches 48 PORT POE",null,{"v":0,"d":"0%"},1,0,0,0]
["1.17","Internal Ceiling mount access point",null,{"v":0,"d":"0%"},1,0,0,0]
["1.18","BRADY \"0\" - \"9\" 37/STRIP BLACK/WHITE",null,{"v":0,"d":"0%"},2,0,0,0]
["1.19","BRUSH PANEL SHORT BASE METAL",null,{"v":0,"d":"0%"},4,0,0,0]
["1.20","24 PORT PATCH PANEL CAT 6e LOADED",null,{"v":0,"d":"0%"},2,0,0,0]
["1.21","15U Cabinet. (Includes UPS, power surge protection, cabinet management, etc.)",null,{"v":0,"d":"0%"},1,0,0,0]
["1.22","Smart-UPS, 900 Watts /1500 VA, Input 230V /Output 230V, Interface Port USB, Rack mounted",null,{"v":0,"d":"0%"},1,0,0,0]
["1.23","Distribution Cabinet, Surface Mountable, White, 400mm X 300mm X 150mm",null,{"v":0,"d":"0%"},1,0,0,0]
["1.24","60a, Earth Leakage",null,{"v":0,"d":"0%"},1,0,0,0]
["1.25","60a 1 Phase CB/Isolator",null,{"v":0,"d":"0%"},1,0,0,0]
["1.26","25a, Circuit Breaker, Std Curve",null,{"v":0,"d":"0%"},4,0,0,0]
[2,"Sundries/Infrastructure",{"$nulls":4},{"$f":"SUBTOTAL(9, G47:G51)","v":0},{"$f":"SUBTOTAL(9, H47:H51)","v":0}]
["2.1","Tape Brother White 9mm / BRADY \"0\" - \"9\" 37/STRIP BLACK/WHITE",null,{"v":0,"d":"0%"},2,0,{"$f":"E47*F47","v":0},0]
["2.2","Insulation Tape - Black",null,{"v":0,"d":"0%"},2,0,0,0]
["2.3","5mm x 20mm Pop rivets",null,{"v":0,"d":"0%"},200,0,0,0]
["2.4","M6 Flat Washer",null,{"v":0,"d":"0%"},200,0,0,0]
["2.5","Silicone",null,{"v":0,"d":"0%"},2,0,0,0]
[3,"Documentation",{"$nulls":4},{"$f":"SUBTOTAL(9, G53:G59)","v":0},{"$f":"SUBTOTAL(9, H53:H59)","v":0}]
["3.1","Test Data Point",null,{"v":0,"d":"0%"},31,0,{"$f":"E53*F53","v":0},0]
["3.2","UTP Labelling",null,{"v":0,"d":"0%"},62,0,0,0]
["3.3","Power Labelling",null,{"v":0,"d":"0%"},60,0,0,0]
["3.4","Schematic Layout Of Network",null,{"v":0,"d":"0%"},3,0,0,0]
["3.5","Data Certification",null,{"v":0,"d":"0%"},1,0,0,0]
["3.6","UTP Test Results",null,{"v":0,"d":"0%"},1,0,0,0]
["3.7","COC - Electrical Certification",null,{"v":0,"d":"0%"},1,0,0,0]
[null,"TOTAL BID PRICE  (EXCL VAT)",{"$nulls":4},{"$f":"SUBTOTAL(9,G19:G59)","v":0},{"$f":"SUBTOTAL(9,H19:H59)","v":0}]
[null,"VAT (@15%)",{"$nulls":4},{"$f":"G60*0.15","v":0}]
[null,"TOTAL  BID PRICE (INCL VAT)",{"$nulls":4},{"$f":"G60+G61","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"]

{"sheet":"Tshitale","index":4,"n_rows":68,"n_cols":10,"rows_kept":68,"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],[64,1,67,1],[64,2,64,3],[64,4,64,5],[65,2,65,3],[66,2,66,3],[66,4,66,5],[67,2,67,3],[67,4,67,5]]}
[null,"SUPPLY CHAIN MANAGEMENT"]
[null,"Pricing schedule"]
["RFx No"]
["RFx Title","Supply, Install, and Configure Network Solution of Five Libraries for the Limpopo Department of Sports, Arts and Culture - Tshitale Modular Library"]
["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.89,"d":"R18.89"},null,null,"Mark with an X, which ROE is applicable"]
[null,"1 Euro",{"v":20.56,"d":"R20.56"}]
[null,"1 Pound (UK)",{"v":23.58,"d":"R23.58"}]
[]
[]
["Item No","Goods/Service description","Unit of measure","Forex %","Qty ","Unit Price \n(Excl VAT)","Line Price Y1","Forex Price portion","BRAND / MODEL (if applicable)","Price clarification comment"]
[1,"Tshitale Modular Library",{"$nulls":4},{"$f":"SUBTOTAL(9,G20:G59)","v":0},{"$f":"SUBTOTAL(9,H20:H59)","v":0}]
["1.1","Krone UTP CAT6 Data Point complete with 3m flylead and patchlead",null,{"v":0,"d":"0%"},30,0,{"$f":"E20*F20","v":0},{"$f":"D20*G20","v":0}]
["1.2","ADAPTER 22.5 X 45 LEGRAND HK SHUTTER",null,{"v":0,"d":"0%"},30,0,{"$f":"E21*F21","v":0},{"$f":"D21*G21","v":0}]
["1.3","KEYSTONE RJ45 KM8 C6 WHITE STP",null,{"v":0,"d":"0%"},30,0,0,0]
["1.4","Cover Plate P/O 50x50 E/O",null,{"v":0,"d":"0%"},30,0,0,0]
["1.5","Collar 50x50",null,{"v":0,"d":"0%"},30,0,0,0]
["1.6","Euromod Half Blank White",null,{"v":0,"d":"0%"},30,0,0,0]
["1.7","Surface mount DATA POINT",null,{"v":0,"d":"0%"},1,0,0,0]
["1.8","Electrical Normal Power Point  complete, excl CB.",null,{"v":0,"d":"0%"},30,0,0,0]
["1.9","Electrical Dedicated Power Point  complete, excl CB.",null,{"v":0,"d":"0%"},30,0,0,0]
["1.10","Cover 2 X 4 Vert White 16 Amp",null,{"v":0,"d":"0%"},30,0,0,0]
["1.11","Cover Socket 2 X 4 Vert Red Ded 16 Amp For MS2",null,{"v":0,"d":"0%"},30,0,0,0]
["1.12","Plugtop 16 Amp Red",null,{"v":0,"d":"0%"},30,0,0,0]
["1.13","Cable Surfex 6 X 2 Core + Earth","Metre",{"v":0,"d":"0%"},240,0,0,0]
["1.14","Dual Metal Channel (Incl Corners, End Caps Etc.) Easter Oak / Hospital Grey","Metre",{"v":0,"d":"0%"},65,0,0,0]
["1.15","yt2 Surface mount trunking","Metre",{"v":0,"d":"0%"},9,0,0,0]
["1.16","Switches 48 PORT POE",null,{"v":0,"d":"0%"},1,0,0,0]
["1.17","Internal Ceiling mount access point",null,{"v":0,"d":"0%"},1,0,0,0]
["1.18","BRADY \"0\" - \"9\" 37/STRIP BLACK/WHITE",null,{"v":0,"d":"0%"},2,0,0,0]
["1.19","BRUSH PANEL SHORT BASE METAL",null,{"v":0,"d":"0%"},4,0,0,0]
["1.20","24 PORT PATCH PANEL CAT 6e LOADED",null,{"v":0,"d":"0%"},2,0,0,0]
["1.21","15U Cabinet. (Includes UPS, power surge protection, cabinet management, etc.)",null,{"v":0,"d":"0%"},1,0,0,0]
["1.22","Smart-UPS, 900 Watts /1500 VA, Input 230V /Output 230V, Interface Port USB, Rack mounted",null,{"v":0,"d":"0%"},1,0,0,0]
["1.23","Distribution Cabinet, Surface Mountable, White, 400mm X 300mm X 150mm",null,{"v":0,"d":"0%"},1,0,0,0]
["1.24","60a, Earth Leakage",null,{"v":0,"d":"0%"},1,0,0,0]
["1.25","60a 1 Phase CB/Isolator",null,{"v":0,"d":"0%"},1,0,0,0]
["1.26","25a, Circuit Breaker, Std Curve",null,{"v":0,"d":"0%"},4,0,0,0]
[2,"Infrastructure",{"$nulls":4},{"$f":"SUBTOTAL(9, G47:G51)","v":0},{"$f":"SUBTOTAL(9, H47:H51)","v":0}]
["2.1","Tape Brother White 9mm / BRADY \"0\" - \"9\" 37/STRIP BLACK/WHITE",null,{"v":0,"d":"0%"},2,0,{"$f":"E47*F47","v":0},0]
["2.2","Insulation Tape - Black",null,{"v":0,"d":"0%"},2,0,0,0]
["2.3","5mm x 20mm Pop rivets",null,{"v":0,"d":"0%"},200,0,0,0]
["2.4","M6 Flat Washer",null,{"v":0,"d":"0%"},200,0,0,0]
["2.5","Silicone",null,{"v":0,"d":"0%"},2,0,0,0]
[3,"Documentation",{"$nulls":4},{"$f":"SUBTOTAL(9, G53:G59)","v":0},{"$f":"SUBTOTAL(9, H53:H59)","v":0}]
["3.1","Test Data Point",null,{"v":0,"d":"0%"},31,0,{"$f":"E53*F53","v":0},0]
["3.2","UTP Labelling",null,{"v":0,"d":"0%"},62,0,0,0]
["3.3","Power Labelling",null,{"v":0,"d":"0%"},60,0,0,0]
["3.4","Schematic Layout Of Network",null,{"v":0,"d":"0%"},3,0,0,0]
["3.5","Data Certification",null,{"v":0,"d":"0%"},1,0,0,0]
["3.6","UTP Test Results",null,{"v":0,"d":"0%"},1,0,0,0]
["3.7","COC - Electrical Certification",null,{"v":0,"d":"0%"},1,0,0,0]
[null,"TOTAL BID PRICE  (EXCL VAT)",{"$nulls":4},{"$f":"SUBTOTAL(9,G19:G59)","v":0},{"$f":"SUBTOTAL(9,H19:H59)","v":0}]
[null,"VAT (@15%)",{"$nulls":4},{"$f":"G60*0.15","v":0}]
[null,"TOTAL  BID PRICE (INCL VAT)",{"$nulls":4},{"$f":"G60+G61","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"]

{"sheet":"Vuwani","index":5,"n_rows":68,"n_cols":10,"rows_kept":68,"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],[64,1,67,1],[64,2,64,3],[64,4,64,5],[65,2,65,3],[66,2,66,3],[66,4,66,5],[67,2,67,3],[67,4,67,5]]}
[null,"SUPPLY CHAIN MANAGEMENT"]
[null,"Pricing schedule"]
["RFx No"]
["RFx Title","Supply, Install, and Configure Network Solution of Five Libraries for the Limpopo Department of Sports, Arts and Culture - Vuwani Modular Library"]
["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.89,"d":"R18.89"},null,null,"Mark with an X, which ROE is applicable"]
[null,"1 Euro",{"v":20.56,"d":"R20.56"}]
[null,"1 Pound (UK)",{"v":23.58,"d":"R23.58"}]
[]
[]
["Item No","Goods/Service description","Unit of measure","Forex %","Qty ","Unit Price \n(Excl VAT)","Line Price Y1","Forex Price portion","BRAND / MODEL (if applicable)","Price clarification comment"]
[1,"Vuwani Modular Library",{"$nulls":4},{"$f":"SUBTOTAL(9,G20:G59)","v":0},{"$f":"SUBTOTAL(9,H20:H59)","v":0}]
["1.1","Krone UTP CAT6 Data Point complete with 3m flylead and patchlead",null,{"v":0,"d":"0%"},30,0,{"$f":"E20*F20","v":0},{"$f":"D20*G20","v":0}]
["1.2","ADAPTER 22.5 X 45 LEGRAND HK SHUTTER",null,{"v":0,"d":"0%"},30,0,{"$f":"E21*F21","v":0},{"$f":"D21*G21","v":0}]
["1.3","KEYSTONE RJ45 KM8 C6 WHITE STP",null,{"v":0,"d":"0%"},30,0,0,0]
["1.4","Cover Plate P/O 50x50 E/O",null,{"v":0,"d":"0%"},30,0,0,0]
["1.5","Collar 50x50",null,{"v":0,"d":"0%"},30,0,0,0]
["1.6","Euromod Half Blank White",null,{"v":0,"d":"0%"},30,0,0,0]
["1.7","Surface mount DATA POINT",null,{"v":0,"d":"0%"},1,0,0,0]
["1.8","Electrical Normal Power Point  complete, excl CB.",null,{"v":0,"d":"0%"},30,0,0,0]
["1.9","Electrical Dedicated Power Point  complete, excl CB.",null,{"v":0,"d":"0%"},30,0,0,0]
["1.10","Cover 2 X 4 Vert White 16 Amp",null,{"v":0,"d":"0%"},30,0,0,0]
["1.11","Cover Socket 2 X 4 Vert Red Ded 16 Amp For MS2",null,{"v":0,"d":"0%"},30,0,0,0]
["1.12","Plugtop 16 Amp Red",null,{"v":0,"d":"0%"},30,0,0,0]
["1.13","Cable Surfex 6 X 2 Core + Earth","Metre",{"v":0,"d":"0%"},240,0,0,0]
["1.14","Dual Metal Channel (Incl Corners, End Caps Etc.) Easter Oak / Hospital Grey","Metre",{"v":0,"d":"0%"},65,0,0,0]
["1.15","yt2 Surface mount trunking","Metre",{"v":0,"d":"0%"},9,0,0,0]
["1.16","Switches 48 PORT POE",null,{"v":0,"d":"0%"},1,0,0,0]
["1.17","Internal Ceiling mount access point",null,{"v":0,"d":"0%"},1,0,0,0]
["1.18","BRADY \"0\" - \"9\" 37/STRIP BLACK/WHITE",null,{"v":0,"d":"0%"},2,0,0,0]
["1.19","BRUSH PANEL SHORT BASE METAL",null,{"v":0,"d":"0%"},4,0,0,0]
["1.20","24 PORT PATCH PANEL CAT 6e LOADED",null,{"v":0,"d":"0%"},2,0,0,0]
["1.21","15U Cabinet. (Includes UPS, power surge protection, cabinet management, etc.)",null,{"v":0,"d":"0%"},1,0,0,0]
["1.22","Smart-UPS, 900 Watts /1500 VA, Input 230V /Output 230V, Interface Port USB, Rack mounted",null,{"v":0,"d":"0%"},1,0,0,0]
["1.23","Distribution Cabinet, Surface Mountable, White, 400mm X 300mm X 150mm",null,{"v":0,"d":"0%"},1,0,0,0]
["1.24","60a, Earth Leakage",null,{"v":0,"d":"0%"},1,0,0,0]
["1.25","60a 1 Phase CB/Isolator",null,{"v":0,"d":"0%"},1,0,0,0]
["1.26","25a, Circuit Breaker, Std Curve",null,{"v":0,"d":"0%"},4,0,0,0]
[8,"Infrastructure",{"$nulls":4},{"$f":"SUBTOTAL(9, G47:G51)","v":0},{"$f":"SUBTOTAL(9, H47:H51)","v":0}]
["8.1","Tape Brother White 9mm / BRADY \"0\" - \"9\" 37/STRIP BLACK/WHITE",null,{"v":0,"d":"0%"},2,0,{"$f":"E47*F47","v":0},{"$f":"D47*G47","v":0}]
["8.2","Insulation Tape - Black",null,{"v":0,"d":"0%"},2,0,0,0]
["8.3","5mm x 20mm Pop rivets",null,{"v":0,"d":"0%"},200,0,0,0]
["8.4","M6 Flat Washer",null,{"v":0,"d":"0%"},200,0,0,0]
["8.5","Silicone",null,{"v":0,"d":"0%"},2,0,0,0]
[9,"Documentation",{"$nulls":4},{"$f":"SUBTOTAL(9, G53:G59)","v":0},{"$f":"SUBTOTAL(9, H53:H59)","v":0}]
["9.1","Test Data Point",null,{"v":0,"d":"0%"},31,0,{"$f":"E53*F53","v":0},0]
[null,"UTP Labelling",null,{"v":0,"d":"0%"},62,0,0,0]
[null,"Power Labelling",null,{"v":0,"d":"0%"},60,0,0,0]
[null,"Schematic Layout Of Network",null,{"v":0,"d":"0%"},3,0,0,0]
["9.2","Data Certification",null,{"v":0,"d":"0%"},1,0,0,0]
["9.3","UTP Test Results",null,{"v":0,"d":"0%"},1,0,0,0]
["9.4","COC - Electrical Certification",null,{"v":0,"d":"0%"},1,0,0,0]
[null,"TOTAL BID PRICE  (EXCL VAT)",{"$nulls":4},{"$f":"SUBTOTAL(9,G19:G59)","v":0},{"$f":"SUBTOTAL(9,H19:H59)","v":0}]
[null,"VAT (@15%)",{"$nulls":4},{"$f":"G60*0.15","v":0}]
[null,"TOTAL  BID PRICE (INCL VAT)",{"$nulls":4},{"$f":"G60+G61","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"]