{"text_format":"3","workbook":"xlsx","n_sheets":21,"sheets":["Total Bid","Alldays","Bakgoma","Burgersfort","Fetakgomo","Ga-Phaahla","Giyani","Groblersdal","Lebowakgomo","Mapodile","Marapong","Marblehall","Mogwadi","Moletjie","Mookgophong","Morebeng","Mutale","Phatantswane","Phokwane","Seshego","Vhembe"],"not_rendered":{"images":1},"read":"whole","date_system":"1900"}

{"sheet":"Total Bid","index":0,"n_rows":46,"n_cols":10,"rows_kept":46,"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],[42,1,45,1],[42,2,42,3],[42,4,42,5],[43,2,43,3],[44,2,44,3],[44,4,44,5],[45,2,45,3],[45,4,45,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,"ALLDAYS LIBRARY",{"$nulls":4},{"$f":"SUBTOTAL(9,G20:G39)","v":0},{"$f":"SUBTOTAL(9,H20:H39)","v":0}]
["1.1","Alldays Library","Each",{"v":0,"d":"0%"},1,{"$f":"Alldays!G56","v":0},{"$f":"E20*F20","v":0},{"$f":"D20*G20","v":0}]
["1.2","Bakgoma Library","Each",{"v":0,"d":"0%"},1,{"$f":"Bakgoma!G47","v":0},0,0]
["1.3","Burgersfort Library","Each",{"v":0,"d":"0%"},1,{"$f":"Burgersfort!G70","v":0},0,0]
["1.4","Fetakgomo Library","Each",{"v":0,"d":"0%"},1,{"$f":"Fetakgomo!G48","v":0},0,0]
["1.5","Ga-Phaahla Library","Each",{"v":0,"d":"0%"},1,{"$f":"'Ga-Phaahla'!G48","v":0},0,0]
["1.6","Giyani Library","Each",{"v":0,"d":"0%"},1,{"$f":"Giyani!G52","v":0},0,0]
["1.7","Groblersdal Library","Each",{"v":0,"d":"0%"},1,{"$f":"Groblersdal!G48","v":0},0,0]
["1.8","Lebowakgomo Library","Each",{"v":0,"d":"0%"},1,{"$f":"Lebowakgomo!G48","v":0},0,0]
["1.9","Mapodile Library","Each",{"v":0,"d":"0%"},1,{"$f":"Mapodile!G52","v":0},0,0]
["1.10","Marapong Library","Each",{"v":0,"d":"0%"},1,{"$f":"Marapong!G47","v":0},0,0]
["1.11","Marblehall Library","Each",{"v":0,"d":"0%"},1,{"$f":"Marblehall!G49","v":0},0,0]
["1.12","Mogwadi Library","Each",{"v":0,"d":"0%"},1,{"$f":"Mogwadi!G57","v":0},0,0]
["1.13","Moletjie Library","Each",{"v":0,"d":"0%"},1,{"$f":"Moletjie!G48","v":0},0,0]
["1.14","Mookgophong Library","Each",{"v":0,"d":"0%"},1,{"$f":"Mookgophong!G47","v":0},0,0]
["1.15","Morebeng Library","Each",{"v":0,"d":"0%"},1,{"$f":"Morebeng!G48","v":0},0,0]
["1.16","Mutale Library","Each",{"v":0,"d":"0%"},1,{"$f":"Mutale!G48","v":0},0,0]
["1.17","Phatantswane Library","Each",{"v":0,"d":"0%"},1,{"$f":"Phatantswane!G48","v":0},0,0]
["1.18","Phokwane Library","Each",{"v":0,"d":"0%"},1,{"$f":"Phokwane!G51","v":0},0,0]
["1.19","Seshego Library","Each",{"v":0,"d":"0%"},1,{"$f":"Seshego!G47","v":0},0,0]
["1.20","Vhembe Library","Each",{"v":0,"d":"0%"},1,{"$f":"Vhembe!G51","v":0},0,0]
[null,"TOTAL BID PRICE  (INCL VAT)",{"$nulls":4},{"$f":"SUBTOTAL(9,G19:G39)","v":0},{"$f":"SUBTOTAL(9,H19:H39)","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":"Alldays","index":1,"n_rows":62,"n_cols":10,"rows_kept":62,"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],[58,1,61,1],[58,2,58,3],[58,4,58,5],[59,2,59,3],[60,2,60,3],[60,4,60,5],[61,2,61,3],[61,4,61,5]]}
[null,"SUPPLY CHAIN MANAGEMENT"]
[null,"Pricing schedule"]
["RFx No"]
["RFx Title","Supply, Install, and Configure Network Solution of Twenty Libraries for the Limpopo Department of Sports, Arts and Culture - Alldays 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,"ALLDAYS LIBRARY",{"$nulls":4},{"$f":"SUBTOTAL(9,G20:G41)","v":0},{"$f":"SUBTOTAL(9,H20:H40)","v":0}]
["1.1","Test & Repair / replace flash mount and surface mount wall boxes","Each",{"v":0,"d":"0%"},24,0,{"$f":"E20*F20","v":0},{"$f":"D20*G20","v":0}]
["1.2","1 Meter Cat 5e / 6 Patch Lead","Each",{"v":0,"d":"0%"},24,0,{"$f":"E21*F21","v":0},{"$f":"D21*G21","v":0}]
["1.3","Krone UTP CAT6 Data Point complete with 3m flylead and patchlead","Each",{"v":0,"d":"0%"},9,0,0,0]
["1.4","ADAPTER 22.5 X 45 LEGRAND HK SHUTTER","Each",{"v":0,"d":"0%"},9,0,0,0]
["1.5","KEYSTONE RJ45 KM8 C6 WHITE STP","Each",{"v":0,"d":"0%"},9,0,0,0]
["1.6","Cover Plate P/O 50x50 E/O","Each",{"v":0,"d":"0%"},9,0,0,0]
["1.7","Collar 50x50","Each",{"v":0,"d":"0%"},9,0,0,0]
["1.8","Euromod Half Blank White","Each",{"v":0,"d":"0%"},9,0,0,0]
["1.9","CAT 6 Surface mount Data Point complete with 3m fly lead and patch lead for WiFi AP, WIFI/APS Connectors","Each",{"v":0,"d":"0%"},1,0,0,0]
["1.10","Electrical Normal Power Point  complete, excl CB.","Each",{"v":0,"d":"0%"},1,0,0,0]
["1.11","Electrical Dedicated Power Point  complete, excl CB.","Each",{"v":0,"d":"0%"},1,0,{"$f":"E30*F30","v":0},{"$f":"D30*G30","v":0}]
["1.12","Cover 2 X 4 Vert White 16 Amp","Each",{"v":0,"d":"0%"},1,0,{"$f":"E31*F31","v":0},{"$f":"D31*G31","v":0}]
["1.13","Cover Socket 2 X 4 Vert Red Ded 16 Amp For MS2","Each",{"v":0,"d":"0%"},1,0,0,0]
["1.14","Plugtop 16 Amp Red","Each",{"v":0,"d":"0%"},1,0,0,0]
["1.15","Cable Surfex 2,5 X 2 Core + Earth","Metre",{"v":0,"d":"0%"},50,0,0,0]
["1.16","yt2 Surface mount trunking","Metre",{"v":0,"d":"0%"},3,0,0,0]
["1.17","Switches 24 PORT POE","Each",{"v":0,"d":"0%"},1,0,0,0]
["1.18","Internal Ceiling mount access point","Each",{"v":0,"d":"0%"},1,0,0,0]
["1.19","BRUSH PANEL SHORT BASE METAL","Each",{"v":0,"d":"0%"},4,0,0,0]
["1.20","24 PORT PATCH PANEL CAT 6e LOADED","Each",{"v":0,"d":"0%"},2,0,0,0]
["1.21","Smart-UPS, 2000 Watts /1500 VA, Input 230V /Output 230V, Interface Port USB, Rack mounted","Each",{"v":0,"d":"0%"},1,0,0,0]
["1.22","Cabinet Cleaning, mounting existing switches, modems and Cable tying ","P/H",{"v":0,"d":"0%"},1,0,{"$f":"E41*F41","v":0},{"$f":"D41*G41","v":0}]
[2,"SUNDRIES/INFRASTRUCTURE",{"$nulls":4},{"$f":"SUBTOTAL(9, G43:G48)","v":0},{"$f":"SUBTOTAL(9, H43:H48)","v":0}]
["2.1","Tape Brother White 9mm / BRADY \"0\" - \"9\" 37/STRIP BLACK/WHITE","Each",{"v":0,"d":"0%"},2,0,0,0]
["2.2","BRADY \"0\" - \"9\" 37/STRIP BLACK/WHITE","Each",{"v":0,"d":"0%"},2,0,0,0]
["2.3","Insulation Tape - Black","Each",{"v":0,"d":"0%"},2,0,0,0]
["2.4","Knock Inns 6 X 55","Each",{"v":0,"d":"0%"},50,0,0,0]
["2.5","M6 Flat Washer","Each",{"v":0,"d":"0%"},50,0,0,0]
["2.6","Silicone","Each",{"v":0,"d":"0%"},1,0,0,0]
[3,"DOCUMENTATION",{"$nulls":4},{"$f":"SUBTOTAL(9, G50:G53)","v":0},{"$f":"SUBTOTAL(9, H50:H53)","v":0}]
["3.4","Schematic Layout Of Network (3 PRINTOUTS)","Each",{"v":0,"d":"0%"},3,0,{"$f":"E50*F50","v":0},{"$f":"D50*G50","v":0}]
["3.5","Data Certification","Each",{"v":0,"d":"0%"},1,0,0,0]
["3.6","UTP Test Results","Each",{"v":0,"d":"0%"},1,0,0,0]
["3.7","COC - Electrical Certification","Each",{"v":0,"d":"0%"},1,0,0,0]
[null,"TOTAL BID PRICE  (EXCL VAT)",{"$nulls":4},{"$f":"SUBTOTAL(9,G19:G53)","v":0},{"$f":"SUBTOTAL(9,H19:H53)","v":0}]
[null,"VAT (@15%)",{"$nulls":4},{"$f":"G54*0.15","v":0}]
[null,"TOTAL  BID PRICE (INCL VAT)",{"$nulls":4},{"$f":"G54+G55","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":"Bakgoma","index":2,"n_rows":53,"n_cols":10,"rows_kept":53,"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],[49,1,52,1],[49,2,49,3],[49,4,49,5],[50,2,50,3],[51,2,51,3],[51,4,51,5],[52,2,52,3],[52,4,52,5]]}
[null,"SUPPLY CHAIN MANAGEMENT"]
[null,"Pricing schedule"]
["RFx No"]
["RFx Title","Supply, Install, and Configure Network Solution of Twenty Libraries for the Limpopo Department of Sports, Arts and Culture - Bakgoma 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,"New Installations",{"$nulls":4},{"$f":"SUBTOTAL(9,G20:G31)","v":0},{"$f":"SUBTOTAL(9,H20:H31)","v":0}]
["1.1","New insulation-displacement connector UTP CAT6e Data Point complete with flylead and patchlead ","Each",{"v":0,"d":"0%"},10,0,{"$f":"E20*F20","v":0},{"$f":"D20*G20","v":0}]
["1.2","RJ 45 WHITE SHUTTER CAT 6e ","Each",{"v":0,"d":"0%"},10,0,{"$f":"E21*F21","v":0},{"$f":"D21*G21","v":0}]
["1.3","45deg ADAPTER PLATE for COMPACT ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.4","TRUNKING FRAME 50 x 50 ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.5","25 X 50 BLANK ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.6","New Electrical Normal Power Point complete. ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.9","Brush Panel ","Each",{"v":0,"d":"0%"},2,0,0,0]
["1.10","INSULATION-DISPLACEMENT CONNECTOR 24 PORT KM8 CAT 6e LOADED ","Each",{"v":0,"d":"0%"},1,0,0,0]
["1.11","Triple output kettle cord PC power cable ","Each",{"v":0,"d":"0%"},10,0,{"$f":"E28*F28","v":0},{"$f":"D28*G28","v":0}]
["1.12","Extra Flyleads ","Each",{"v":0,"d":"0%"},5,0,{"$f":"E29*F29","v":0},{"$f":"D29*G29","v":0}]
["1.13","New Electrical Dedicated Power Point complete ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.14","Electrical 2 Pin 5 A Power outlet ","Each",{"v":0,"d":"0%"},5,0,0,0]
[2,"Existing Cabling to be Maintained",{"$nulls":4},{"$f":"SUBTOTAL(9, G33:G39)","v":0},{"$f":"SUBTOTAL(9, H33:H39)","v":0}]
["2.1","UTP Testing, Fixing & Labelling","Each",{"v":0,"d":"0%"},38,0,0,0]
["2.2","UTP Labelling ","Each",{"v":0,"d":"0%"},94,0,0,0]
["2.3","Existing Cabling to be Maintained","Each",{"v":0,"d":"0%"},54,0,0,0]
["2.4","Add 2U Electrical Surge & Lighting Protection / Complete System for One V11/X.21 Interface / Unit Includes Equipment AC Power Surge Protector (Phase 3), AC Feed Power Trip-Switch & 15A Feed Socket for Cabinet, Optical Isolation Barrier & Surge Protection on V ","Each",{"v":0,"d":"0%"},1,0,0,0]
["2.5","Testing, Repair and /or replacement of cabinet Fan and cabinet power plugs ","Per Hour",{"v":0,"d":"0%"},2,0,0,0]
["2.6","Supply and installation of 4000VA UPS or Repair 230 APC Smart-UPS XL 2200VA RM 3U 230V ","Each",{"v":0,"d":"0%"},1,0]
["2.7","Cabinet Cleaning, mounting existing switches, modems and Cable tying ","Per Hour",{"v":0,"d":"0%"},1,0,0,0]
[3,"DOCUMENTATION",{"$nulls":4},{"$f":"SUBTOTAL(9, G41:G44)","v":0},{"$f":"SUBTOTAL(9, H41:H44)","v":0}]
["3.4","UTP Test Results (ALL LAN POINTS)","Each",{"v":0,"d":"0%"},1,0,{"$f":"E41*F41","v":0},{"$f":"D41*G41","v":0}]
["3.5","Manufacturer Data Point Certification ","Each",{"v":0,"d":"0%"},1,0,0,0]
["3.6","COC - Electrical Certification ","Each",{"v":0,"d":"0%"},1,0,0,0]
["3.7","Schematic Layout Of Network (4 PRINTOUTS)","Each",{"v":0,"d":"0%"},4,0,0,0]
[null,"TOTAL BID PRICE  (EXCL VAT)",{"$nulls":4},{"$f":"SUBTOTAL(9,G19:G44)","v":0},{"$f":"SUBTOTAL(9,H19:H44)","v":0}]
[null,"VAT (@15%)",{"$nulls":4},{"$f":"G45*0.15","v":0}]
[null,"TOTAL  BID PRICE (INCL VAT)",{"$nulls":4},{"$f":"G45+G46","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":"Burgersfort","index":3,"n_rows":76,"n_cols":10,"rows_kept":76,"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],[72,1,75,1],[72,2,72,3],[72,4,72,5],[73,2,73,3],[74,2,74,3],[74,4,74,5],[75,2,75,3],[75,4,75,5]]}
[null,"SUPPLY CHAIN MANAGEMENT"]
[null,"Pricing schedule"]
["RFx No"]
["RFx Title","Supply, Install, and Configure Network Solution of Twenty Libraries for the Limpopo Department of Sports, Arts and Culture - Burgersfort 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,"Burgersfort Library",{"$nulls":4},{"$f":"SUBTOTAL(9,G20:G29)","v":0},{"$f":"SUBTOTAL(9,H20:H28)","v":0}]
["1.1","Test & Repair / replace flash mount and surface mount wall boxes","Each",{"v":0,"d":"0%"},45,0,{"$f":"E20*F20","v":0},{"$f":"D20*G20","v":0}]
["1.2","1 Meter Cat 5e / 6 Patch Lead","Each",{"v":0,"d":"0%"},45,0,{"$f":"E21*F21","v":0},{"$f":"D21*G21","v":0}]
["1.3","CAT 6 Surface mount Data Point complete with 3m fly lead and patch lead for WiFi AP, WIFI/APS Connectors","Each",{"v":0,"d":"0%"},1,0,0,0]
["1.4","yt2 Surface mount trunking","Per Metre",{"v":0,"d":"0%"},9,0,0,0]
["1.5","Switch 24 PORT POE","Each",{"v":0,"d":"0%"},1,0,0,0]
["1.6","Internal Ceiling mount access point","Each",{"v":0,"d":"0%"},1,0,0,0]
["1.7","BRUSH PANEL SHORT BASE METAL","Each",{"v":0,"d":"0%"},2,0,0,0]
["1.8","24 PORT PATCH PANEL CAT 6e LOADED","Each",{"v":0,"d":"0%"},2,0,0,0]
["1.9","Smart-UPS, 2000 Watts /3 KVA, Input 230V /Output 230V, Interface Port USB, Rack mounted","Each",{"v":0,"d":"0%"},1,0,0,0]
["1.10","Cabinet Cleaning, mounting existing switches, modems and Cable tying ","Each",{"v":0,"d":"0%"},1,0,0,0]
[2,"Office 51",{"$nulls":3},0,{"$f":"SUBTOTAL(9, G31:G43)","v":0},{"$f":"SUBTOTAL(9, H31:H43)","v":0}]
["2.1","Krone UTP CAT6 Data Point complete with 3m flylead and patchlead","Each",{"v":0,"d":"0%"},10,0,{"$f":"E31*F31","v":0},{"$f":"D31*G31","v":0}]
["2.2","ADAPTER 22.5 X 45 LEGRAND HK SHUTTER","Each",{"v":0,"d":"0%"},10,0,0,0]
["2.3","KEYSTONE RJ45 KM8 C6 WHITE STP","Each",{"v":0,"d":"0%"},10,0,0,0]
["2.4","Cover Plate P/O 50x50 E/O","Each",{"v":0,"d":"0%"},10,0,0,0]
["2.5","Collar 50x50","Each",{"v":0,"d":"0%"},10,0,0,0]
["2.6","Euromod Half Blank White","Each",{"v":0,"d":"0%"},10,0,0,0]
["2.7","Electrical Normal Power Point  complete, excl CB.","Each",{"v":0,"d":"0%"},6,0,0,0]
["2.8","Electrical Dedicated Power Point  complete, excl CB.","Each",{"v":0,"d":"0%"},6,0,0,0]
["2.9","Cover 2 X 4 Vert White 16 Amp","Each",{"v":0,"d":"0%"},6,0,0,0]
["2.10","Cover Socket 2 X 4 Vert Red Ded 16 Amp For MS2","Each",{"v":0,"d":"0%"},6,0,0,0]
["2.11","Plugtop 16 Amp Red","Each",{"v":0,"d":"0%"},6,0,0,0]
["2.12","Cable Surfex 2.5 X 2 Core + Earth Dedicated plugs & normal plugs","Per Metre",{"v":0,"d":"0%"},100,0,0,0]
["2.13","Power Pole all including Core, Ceiling Flange, Floor location pad, Jack & Assembly","Each",{"v":0,"d":"0%"},1,0,0,0]
[3,"Office 52",{"$nulls":4},{"$f":"SUBTOTAL(9,G45:G57)","v":0},{"$f":"SUBTOTAL(9, H45:H57)","v":0}]
["3.1","Krone UTP CAT6 Data Point complete with 3m flylead and patchlead","Each",{"v":0,"d":"0%"},10,0,0,0]
["3.2","ADAPTER 22.5 X 45 LEGRAND HK SHUTTER","Each",{"v":0,"d":"0%"},10,0,0,0]
["3.3","KEYSTONE RJ45 KM8 C6 WHITE STP","Each",{"v":0,"d":"0%"},10,0,0,0]
["3.4","Cover Plate P/O 50x50 E/O","Each",{"v":0,"d":"0%"},10,0,0,0]
["3.5","Collar 50x50","Each",{"v":0,"d":"0%"},10,0,0,0]
["3.6","Euromod Half Blank White","Each",{"v":0,"d":"0%"},10,0,0,0]
["3.7","Electrical Normal Power Point  complete, excl CB.","Each",{"v":0,"d":"0%"},6,0,0,0]
["3.8","Electrical Dedicated Power Point  complete, excl CB.","Each",{"v":0,"d":"0%"},6,0,0,0]
["3.9","Cover 2 X 4 Vert White 16 Amp","Each",{"v":0,"d":"0%"},6,0,0,0]
["3.10","Cover Socket 2 X 4 Vert Red Ded 16 Amp For MS2","Each",{"v":0,"d":"0%"},6,0,0,0]
["3.11","Plugtop 16 Amp Red","Each",{"v":0,"d":"0%"},6,0,0,0]
["3.12","Cable Surfex 2.5 X 2 Core + Earth Dedicated plugs & normal plugs","Per Metre",{"v":0,"d":"0%"},100,0,0,0]
["3.13","Power Pole all including Core, Ceiling Flange, Floor location pad, Jack & Assembly","Each",{"v":0,"d":"0%"},1,0,0,0]
[4,"Sundries/Infrastructure",{"$nulls":4},{"$f":"SUBTOTAL(9,G59:G62)","v":0},{"$f":"SUBTOTAL(9,H59:H62)","v":0}]
["4.1","Tape Brother White 9mm / BRADY \"0\" - \"9\" 37/STRIP BLACK/WHITE","Each",{"v":0,"d":"0%"},4,0,0,0]
["4.2","BRADY \"0\" - \"9\" 37/STRIP BLACK/WHITE","Each",{"v":0,"d":"0%"},2,0,0,0]
["4.3","Insulation Tape - Black","Each",{"v":0,"d":"0%"},2,0,0,0]
["4.4","Silicone","Each",{"v":0,"d":"0%"},1,0,0,0]
[3,"DOCUMENTATION",{"$nulls":4},{"$f":"SUBTOTAL(9, G64:G67)","v":0},{"$f":"SUBTOTAL(9, H64:H67)","v":0}]
["3.4","UTP Test Results (ALL LAN POINTS)","Each",{"v":0,"d":"0%"},1,0,{"$f":"E64*F64","v":0},0]
["3.5","Manufacturer Data Point Certification ","Each",{"v":0,"d":"0%"},1,0,0,0]
["3.6","COC - Electrical Certification ","Each",{"v":0,"d":"0%"},1,0,0,0]
["3.7","Schematic Layout Of Network (4 PRINTOUTS)","Each",{"v":0,"d":"0%"},4,0,0,0]
[null,"TOTAL BID PRICE  (EXCL VAT)",{"$nulls":4},{"$f":"SUBTOTAL(9,G19:G67)","v":0},{"$f":"SUBTOTAL(9,H19:H67)","v":0}]
[null,"VAT (@15%)",{"$nulls":4},{"$f":"G68*0.15","v":0}]
[null,"TOTAL  BID PRICE (INCL VAT)",{"$nulls":4},{"$f":"G68+G69","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":"Fetakgomo","index":4,"n_rows":54,"n_cols":10,"rows_kept":54,"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],[50,1,53,1],[50,2,50,3],[50,4,50,5],[51,2,51,3],[52,2,52,3],[52,4,52,5],[53,2,53,3],[53,4,53,5]]}
[null,"SUPPLY CHAIN MANAGEMENT"]
[null,"Pricing schedule"]
["RFx No"]
["RFx Title","Supply, Install, and Configure Network Solution of Twenty Libraries for the Limpopo Department of Sports, Arts and Culture - Fetakgomo 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,"Fetakgomo Library",{"$nulls":4},{"$f":"SUBTOTAL(9,G20:G32)","v":0},{"$f":"SUBTOTAL(9,H20:H32)","v":0}]
["1.1","New insulation-displacement connector UTP CAT6e Data Point complete with flylead and patchlead ","Each",{"v":0,"d":"0%"},10,0,{"$f":"E20*F20","v":0},{"$f":"D20*G20","v":0}]
["1.2","RJ 45 WHITE SHUTTER CAT 6e ","Each",{"v":0,"d":"0%"},10,0,{"$f":"E21*F21","v":0},{"$f":"D21*G21","v":0}]
["1.3","45deg ADAPTER PLATE for COMPACT ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.4","TRUNKING FRAME 50 x 50 ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.5","25 X 50 BLANK ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.6","New Electrical Normal Power Point complete. ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.7","New Electrical Dedicated Power Point complete ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.8","Electrical 2 Pin 5 A Power outlet ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.9","Power Skirting 2 Compartment Supply & Install (2,4m length)","Per Metre",{"v":0,"d":"0%"},10,0,0,0]
["1.11","Brush Panel ","Each",{"v":0,"d":"0%"},1,0,{"$f":"E29*F29","v":0},{"$f":"D29*G29","v":0}]
["1.12","INSULATION-DISPLACEMENT CONNECTOR 24 PORT KM8 CAT 6e LOADED ","Each",{"v":0,"d":"0%"},1,0,{"$f":"E30*F30","v":0},{"$f":"D30*G30","v":0}]
["1.13","Triple output kettle cord PC power cable ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.14","Extra Flyleads ","Each",{"v":0,"d":"0%"},10,0,0,0]
[2,"SUNDRIES/INFRASTRUCTURE",{"$nulls":4},{"$f":"SUBTOTAL(9, G34:G40)","v":0},{"$f":"SUBTOTAL(9, H34:H40)","v":0}]
["2.1","UTP Testing, Fixing & Labelling","Each",{"v":0,"d":"0%"},68,0,0,0]
["2.2","UTP Labelling ","Each",{"v":0,"d":"0%"},136,0,0,0]
["2.3","Power Plugs Testing, Fixing and Labelling ","Each",{"v":0,"d":"0%"},52,0,0,0]
["2.4","Add 2U Electrical Surge & Lighting Protection / Complete System for One V11/X.21 Interface / Unit Includes Equipment AC Power Surge Protector (Phase 3), AC Feed Power Trip-Switch & 15A Feed Socket for Cabinet, Optical Isolation Barrier & Surge Protection on V","Each",{"v":0,"d":"0%"},1,0,0,0]
["2.5","Supply and installation of 4000VA UPS or Repair 230 APC Smart-UPS XL 2200VA RM 3U 230V ","Each",{"v":0,"d":"0%"},1,0,0,0]
["2.6","Cabinet Cleaning, mounting existing switches, modems and Cable tying ","Per Hour",{"v":0,"d":"0%"},1,0,0,0]
["2.7","Testing, Repair and /or replacement of cabinet Fan and cabinet power plugs ","Per Hour",{"v":0,"d":"0%"},1,0,0,0]
[3,"DOCUMENTATION",{"$nulls":4},{"$f":"SUBTOTAL(9, G42:G45)","v":0},{"$f":"SUBTOTAL(9, H42:H45)","v":0}]
["3.4","UTP Test Results (ALL LAN POINTS)","Each",{"v":0,"d":"0%"},1,0,{"$f":"E42*F42","v":0},{"$f":"D42*G42","v":0}]
["3.5","Manufacturer Data Point Certification ","Each",{"v":0,"d":"0%"},1,0,0,0]
["3.6","COC - Electrical Certification ","Each",{"v":0,"d":"0%"},1,0,0,0]
["3.7","Schematic Layout Of Network (4 PRINTOUTS)","Each",{"v":0,"d":"0%"},4,0,0,0]
[null,"TOTAL BID PRICE  (EXCL VAT)",{"$nulls":4},{"$f":"SUBTOTAL(9,G19:G45)","v":0},{"$f":"SUBTOTAL(9,H19:H45)","v":0}]
[null,"VAT (@15%)",{"$nulls":4},{"$f":"G46*0.15","v":0}]
[null,"TOTAL  BID PRICE (INCL VAT)",{"$nulls":4},{"$f":"G46+G47","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":"Ga-Phaahla","index":5,"n_rows":54,"n_cols":10,"rows_kept":54,"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],[50,1,53,1],[50,2,50,3],[50,4,50,5],[51,2,51,3],[52,2,52,3],[52,4,52,5],[53,2,53,3],[53,4,53,5]]}
[null,"SUPPLY CHAIN MANAGEMENT"]
[null,"Pricing schedule"]
["RFx No"]
["RFx Title","Supply, Install, and Configure Network Solution of Twenty Libraries for the Limpopo Department of Sports, Arts and Culture - Ga-Phaahla 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,"New Installations",{"$nulls":4},{"$f":"SUBTOTAL(9,G20:G32)","v":0},{"$f":"SUBTOTAL(9,H20:H32)","v":0}]
["1.1","New insulation-displacement connector UTP CAT6e Data Point complete with flylead and patchlead ","Each",{"v":0,"d":"0%"},10,0,{"$f":"E20*F20","v":0},{"$f":"D20*G20","v":0}]
["1.2","RJ 45 WHITE SHUTTER CAT 6e ","Each",{"v":0,"d":"0%"},10,0,{"$f":"E21*F21","v":0},{"$f":"D21*G21","v":0}]
["1.3","45deg ADAPTER PLATE for COMPACT ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.4","TRUNKING FRAME 50 x 50 ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.5","25 X 50 BLANK ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.6","New Electrical Normal Power Point complete. ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.7","New Electrical Dedicated Power Point complete ","Each",{"v":0,"d":"0%"},2,0,0,0]
["1.8","Electrical 2 Pin 5 A Power outlet ","Each",{"v":0,"d":"0%"},2,0,0,0]
["1.9","Power Skirting 2 Compartment Supply & Install (2,4 / 3.0m) lenght","Per Metre",{"v":0,"d":"0%"},12,0,0,0]
["1.11","Brush Panel ","Each",{"v":0,"d":"0%"},1,0,{"$f":"E29*F29","v":0},{"$f":"D29*G29","v":0}]
["1.12","INSULATION-DISPLACEMENT CONNECTOR 24 PORT KM8 CAT 6e LOADED ","Each",{"v":0,"d":"0%"},1,0,{"$f":"E30*F30","v":0},{"$f":"D30*G30","v":0}]
["1.13","Triple output kettle cord PC power cable ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.14","Extra Flyleads ","Each",{"v":0,"d":"0%"},10,0,0,0]
[2,"SUNDRIES/INFRASTRUCTURE",{"$nulls":4},{"$f":"SUBTOTAL(9, G34:G40)","v":0},{"$f":"SUBTOTAL(9, H34:H40)","v":0}]
["2.1","TP Testing,  Fixing & Labelling","Each",{"v":0,"d":"0%"},62,0,0,0]
["2.2","UTP Labelling ","Each",{"v":0,"d":"0%"},124,0,0,0]
["2.3","Power Plugs Testing, Fixing and Labelling ","Each",{"v":0,"d":"0%"},78,0,0,0]
["2.4","Add 2U Electrical Surge & Lighting Protection / Complete System for One V11/X.21 Interface / Unit Includes Equipment AC Power Surge Protector (Phase 3), AC Feed Power Trip-Switch & 15A Feed Socket for Cabinet, Optical Isolation Barrier & Surge Protection on V ","Each",{"v":0,"d":"0%"},1,0,0,0]
["2.5","Testing, Repair and /or replacement of cabinet Fan and cabinet power plugs ","Per Hour",{"v":0,"d":"0%"},1,0,0,0]
["2.6","Supply and installation of 4000VA UPS or Repair 230 APC Smart-UPS XL 2200VA RM 3U 230V ","Each",{"v":0,"d":"0%"},1,0,0,0]
["2.7","Cabinet Cleaning, mounting existing switches, modems and Cable tying ","Per Hour",{"v":0,"d":"0%"},1,0,0,0]
[3,"DOCUMENTATION",{"$nulls":4},{"$f":"SUBTOTAL(9, G42:G45)","v":0},{"$f":"SUBTOTAL(9, H42:H45)","v":0}]
["3.4","UTP Test Results (ALL LAN POINTS)","Each",{"v":0,"d":"0%"},1,0,0,0]
["3.5","Manufacturer Data Point Certification ","Each",{"v":0,"d":"0%"},1,0,0,0]
["3.6","COC - Electrical Certification ","Each",{"v":0,"d":"0%"},1,0,0,0]
["3.7","Schematic Layout Of Network (4 PRINTOUTS)","Each",{"v":0,"d":"0%"},4,0,0,0]
[null,"TOTAL BID PRICE  (EXCL VAT)",{"$nulls":4},{"$f":"SUBTOTAL(9,G19:G45)","v":0},{"$f":"SUBTOTAL(9,H19:H45)","v":0}]
[null,"VAT (@15%)",{"$nulls":4},{"$f":"G46*0.15","v":0}]
[null,"TOTAL  BID PRICE (INCL VAT)",{"$nulls":4},{"$f":"G46+G47","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":"Giyani","index":6,"n_rows":58,"n_cols":10,"rows_kept":58,"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],[54,1,57,1],[54,2,54,3],[54,4,54,5],[55,2,55,3],[56,2,56,3],[56,4,56,5],[57,2,57,3],[57,4,57,5]]}
[null,"SUPPLY CHAIN MANAGEMENT"]
[null,"Pricing schedule"]
["RFx No"]
["RFx Title","Supply, Install, and Configure Network Solution of Twenty Libraries for the Limpopo Department of Sports, Arts and Culture - Giyani 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,"Giyani LIBRARY",{"$nulls":4},{"$f":"SUBTOTAL(9,G20:G24)","v":0},{"$f":"SUBTOTAL(9,H20:H24)","v":0}]
["1.1","Test & Repair / replace flash mount and surface mount wall boxes, & Labelling","Each",{"v":0,"d":"0%"},16,0,{"$f":"E20*F20","v":0},{"$f":"D20*G20","v":0}]
["1.2","1 Meter Cat 5e / 6 Patch Lead","Each",{"v":0,"d":"0%"},16,0,{"$f":"E21*F21","v":0},{"$f":"D21*G21","v":0}]
["1.3","CAT 6 Surface mount Data Point complete with 3m fly lead and patch lead for WiFi AP, WIFI/APS Connectors","Each",{"v":0,"d":"0%"},1,0,0,0]
["1.4","yt2 Surface mount trunking","Per Metre",{"v":0,"d":"0%"},9,0,0,0]
["1.5","Internal Ceiling mount access point","Each",{"v":0,"d":"0%"},1,0,0,0]
[2,"Childrens Section",{"$nulls":4},{"$f":"SUBTOTAL(9, G26:G29)","v":0},{"$f":"SUBTOTAL(9, H26:H29)","v":0}]
["2.1","SINGLE DATA: Cradle + 2 x BLANKS + Outlet box + 1 x CLIPSAL S2000 MOD Cat6, Complete with Fly lead & Patch lead","Each",{"v":0,"d":"0%"},20,0,{"$f":"E26*F26","v":0},{"$f":"D26*G26","v":0}]
["2.2","SINGLE SWITCHED PLUG: 16A Monoblock White + Cradle + Outlet Box for power pole","Each",{"v":0,"d":"0%"},20,0,0,0]
["2.3","SINGLE SWITHED PLUG: 16A Monoblock RED + Cradle + Outlet Box for power pole","Each",{"v":0,"d":"0%"},20,0,0,0]
["2.4","Cable Surfex 2.5 X 2 Core + Earth Dedicated plugs & normal plugs","Per Metre",{"v":0,"d":"0%"},100,0,0,0]
[3,"Server Room",{"$nulls":4},{"$f":"SUBTOTAL(9,G31:G39)","v":0},{"$f":"SUBTOTAL(9,H31:H39)","v":0}]
["3.1","Switches 48 PORT POE","Each",{"v":0,"d":"0%"},1,0,0,0]
["3.2","BRUSH PANEL SHORT BASE METAL","Each",{"v":0,"d":"0%"},6,0,0,0]
["3.3","24 PORT PATCH PANEL CAT 6e LOADED","Each",{"v":0,"d":"0%"},2,0,0,0]
["3.4","24U Cabinet. (Includes UPS, power surge protection, cabinet management, etc.)","Each",{"v":0,"d":"0%"},1,0,0,0]
["3.5","Smart-UPS, 900 Watts /1500 VA, Input 230V /Output 230V, Interface Port USB, Floor Standing","Each",{"v":0,"d":"0%"},1,0,0,0]
["3.6","Distribution Cabinet, Surface Mountable, White, 400mm X 300mm X 150mm","Each",{"v":0,"d":"0%"},1,0,0,0]
["3.7","60a, Earth Leakage","Each",{"v":0,"d":"0%"},1,0,0,0]
["3.8","60a 1 Phase CB/Isolator","Each",{"v":0,"d":"0%"},1,0,0,0]
["3.9","25a, Circuit Breaker, Std Curve","Each",{"v":0,"d":"0%"},4,0,0,0]
[4,"Sundries / Infrastructure",{"$nulls":4},{"$f":"SUBTOTAL(9,G41:G44)","v":0},{"$f":"SUBTOTAL(9,H41:H44)","v":0}]
["4.1","Tape Brother White 9mm / BRADY \"0\" - \"9\" 37/STRIP BLACK/WHITE","Each",{"v":0,"d":"0%"},4,0,0,0]
["4.2","BRADY \"0\" - \"9\" 37/STRIP BLACK/WHITE","Each",{"v":0,"d":"0%"},2,0,0,0]
["4.3","Insulation Tape - Black","Each",{"v":0,"d":"0%"},2,0,0,0]
["4.4","Silicone","Each",{"v":0,"d":"0%"},1,0,0,0]
[4,"DOCUMENTATION",{"$nulls":4},{"$f":"SUBTOTAL(9, G46:G49)","v":0},{"$f":"SUBTOTAL(9, H46:H49)","v":0}]
["4.1","Schematic Layout Of Network (3 PRINTOUTS)","Each",{"v":0,"d":"0%"},3,0,{"$f":"E46*F46","v":0},0]
["3.2","Data Certification","Each",{"v":0,"d":"0%"},1,0,0,0]
["3.3","UTP Test Results","Each",{"v":0,"d":"0%"},1,0,0,0]
["3.4","COC - Electrical Certification","Each",{"v":0,"d":"0%"},1,0,0,0]
[null,"TOTAL BID PRICE  (EXCL VAT)",{"$nulls":4},{"$f":"SUBTOTAL(9,G19:G49)","v":0},{"$f":"SUBTOTAL(9,H19:H49)","v":0}]
[null,"VAT (@15%)",{"$nulls":4},{"$f":"G50*0.15","v":0}]
[null,"TOTAL  BID PRICE (INCL VAT)",{"$nulls":4},{"$f":"G50+G51","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":"Groblersdal","index":7,"n_rows":54,"n_cols":10,"rows_kept":54,"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],[50,1,53,1],[50,2,50,3],[50,4,50,5],[51,2,51,3],[52,2,52,3],[52,4,52,5],[53,2,53,3],[53,4,53,5]]}
[null,"SUPPLY CHAIN MANAGEMENT"]
[null,"Pricing schedule"]
["RFx No"]
["RFx Title","Supply, Install, and Configure Network Solution of Twenty Libraries for the Limpopo Department of Sports, Arts and Culture - Groblersdal 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,"Groblersdal Library",{"$nulls":4},{"$f":"SUBTOTAL(9,G20:G25)","v":0},{"$f":"SUBTOTAL(9,H20:H25)","v":0}]
["1.1","New insulation-displacement connector UTP CAT6e Data Point complete with flylead and patchlead ",null,{"v":0,"d":"0%"},10,0,{"$f":"E20*F20","v":0},{"$f":"D20*G20","v":0}]
["1.2","RJ 45 WHITE SHUTTER CAT 6e ",null,{"v":0,"d":"0%"},10,0,{"$f":"E21*F21","v":0},{"$f":"D21*G21","v":0}]
["1.3","45deg ADAPTER PLATE for COMPACT ",null,{"v":0,"d":"0%"},10,0,0,0]
["1.4","TRUNKING FRAME 50 x 50 ",null,{"v":0,"d":"0%"},10,0,0,0]
["1.5","New Electrical Normal Power Point complete. ",null,{"v":0,"d":"0%"},10,0,0,0]
["1.6","New Electrical Dedicated Power Point complete ",null,{"v":0,"d":"0%"},10,0,0,0]
[2,"Existing Cable to be Maintained",{"$nulls":4},{"$f":"SUBTOTAL(9, G27:G35)","v":0},{"$f":"SUBTOTAL(9, H27:H35)","v":0}]
["2.1","UTP Testing, Fixing & Labelling",null,{"v":0,"d":"0%"},31,0,{"$f":"E27*F27","v":0},{"$f":"D27*G27","v":0}]
["2.2","UTP Labelling ",null,{"v":0,"d":"0%"},82,0,0,0]
["2.3","Electrical 2 Pin 5 A Power outlet ",null,{"v":0,"d":"0%"},10,0,0,0]
["2.4","Power Plugs Testing, Fixing and Labelling ",null,{"v":0,"d":"0%"},46,0,0,0]
["2.5","Cabinet Cleaning, mounting existing switches, modems and Cable tying ",null,{"v":0,"d":"0%"},1,0,0,0]
["2.6","Testing and/or Replacement of 2U Electrical Surge & Lighting Protection / Complete System for One V11/X.21 Interface / Unit Includes Equipment AC Power Surge Protector (Phase 3), AC Feed Power Trip-Switch & 15A Feed Socket for Cabinet, Optical Isolation Barrier & Surge Protection on V ",null,{"v":0,"d":"0%"},1,0,0,0]
["2.7","Supply and installation of 4000VA UPS or Repair 230 APC Smart-UPS XL 2200VA RM 3U 230V ",null,{"v":0,"d":"0%"},1,0,0,0]
["2.8","Testing, Repair and /or replacement of cabinet Fan and cabinet power plugs ",null,{"v":0,"d":"0%"},1,0,0,0]
["2.9","Service and repair LG air conditioner",null,{"v":0,"d":"0%"},1,0,0,0]
[3,"Others",{"$nulls":4},{"$f":"SUBTOTAL(9,G37:G40)","v":0},{"$f":"SUBTOTAL(9,H37:H40)","v":0}]
["3.1","Brush Panel ",null,{"v":0,"d":"0%"},1,0,0,0]
["3.2","INSULATION-DISPLACEMENT CONNECTOR 24 PORT KM8 CAT 6e LOADED ",null,{"v":0,"d":"0%"},1,0,0,0]
["3.3","Triple output kettle cord PC power cable ",null,{"v":0,"d":"0%"},10,0,0,0]
["3.4","Extra Flyleads ",null,{"v":0,"d":"0%"},10,0,0,0]
[4,"DOCUMENTATION",{"$nulls":4},{"$f":"SUBTOTAL(9, G42:G45)","v":0},{"$f":"SUBTOTAL(9, H42:H45)","v":0}]
["4.1","UTP Test Results (ALL LAN POINTS)",null,{"v":0,"d":"0%"},1,0,{"$f":"E42*F42","v":0},0]
["4.2","Manufacturer Data Point Certification ",null,{"v":0,"d":"0%"},1,0,0,0]
["4.3","COC - Electrical Certification ",null,{"v":0,"d":"0%"},1,0,0,0]
["4.4","Schematic Layout Of Network (4 PRINTOUTS)",null,{"v":0,"d":"0%"},4,0,0,0]
[null,"TOTAL BID PRICE  (EXCL VAT)",{"$nulls":4},{"$f":"SUBTOTAL(9,G19:G45)","v":0},{"$f":"SUBTOTAL(9,H19:H45)","v":0}]
[null,"VAT (@15%)",{"$nulls":4},{"$f":"G46*0.15","v":0}]
[null,"TOTAL  BID PRICE (INCL VAT)",{"$nulls":4},{"$f":"G46+G47","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":"Lebowakgomo","index":8,"n_rows":54,"n_cols":10,"rows_kept":54,"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],[50,1,53,1],[50,2,50,3],[50,4,50,5],[51,2,51,3],[52,2,52,3],[52,4,52,5],[53,2,53,3],[53,4,53,5]]}
[null,"SUPPLY CHAIN MANAGEMENT"]
[null,"Pricing schedule"]
["RFx No"]
["RFx Title","Supply, Install, and Configure Network Solution of Twenty Libraries for the Limpopo Department of Sports, Arts and Culture - Lebowakgomo 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,"Lebowakgomo Library",{"$nulls":4},{"$f":"SUBTOTAL(9,G20:G32)","v":0},{"$f":"SUBTOTAL(9,H20:H32)","v":0}]
["1.1","New insulation-displacement connector UTP CAT6e Data Point complete with flylead and patchlead ",null,{"v":0,"d":"0%"},10,0,{"$f":"E20*F20","v":0},{"$f":"D20*G20","v":0}]
["1.2","RJ 45 WHITE SHUTTER CAT 6e ",null,{"v":0,"d":"0%"},10,0,{"$f":"E21*F21","v":0},{"$f":"D21*G21","v":0}]
["1.3","45deg ADAPTER PLATE for COMPACT ",null,{"v":0,"d":"0%"},10,0,0,0]
["1.4","TRUNKING FRAME 50 x 50 ",null,{"v":0,"d":"0%"},10,0,0,0]
["1.5","25 X 50 BLANK ",null,{"v":0,"d":"0%"},10,0,0,0]
["1.6","New Electrical Normal Power Point complete. ",null,{"v":0,"d":"0%"},10,0,0,0]
["1.7","New Electrical Dedicated Power Point complete ",null,{"v":0,"d":"0%"},5,0,0,0]
["1.8","Electrical 2 Pin 5 A Power outlet ",null,{"v":0,"d":"0%"},2,0,0,0]
["1.9","Power Skirting 2 Compartment Supply & Install 2,4m or 3m lenght0",null,{"v":0,"d":"0%"},12,0,0,0]
["1.10","Brush Panel ",null,{"v":0,"d":"0%"},2,0,{"$f":"E29*F29","v":0},{"$f":"D29*G29","v":0}]
["1.11","INSULATION-DISPLACEMENT CONNECTOR 24 PORT KM8 CAT 6e LOADED ",null,{"v":0,"d":"0%"},1,0,{"$f":"E30*F30","v":0},{"$f":"D30*G30","v":0}]
["1.12","Triple output kettle cord PC power cable ",null,{"v":0,"d":"0%"},10,0,0,0]
["1.13","Extra Flyleads ",null,{"v":0,"d":"0%"},15,0,0,0]
[2,"Existing Cabling to be Maintained",{"$nulls":4},{"$f":"SUBTOTAL(9, G34:G40)","v":0},{"$f":"SUBTOTAL(9, H34:H40)","v":0}]
["2.1","UTP Testing, Fixing  & Labelling",null,{"v":0,"d":"0%"},67,0,0,0]
["2.2","UTP Labelling ",null,{"v":0,"d":"0%"},134,0,0,0]
["2.3","Power Plugs Testing, Fixing and Labelling ",null,{"v":0,"d":"0%"},68,0,0,0]
["2.4","Add 2U Electrical Surge & Lighting Protection / Complete System for One V11/X.21 Interface / Unit Includes Equipment AC Power Surge Protector (Phase 3), AC Feed Power Trip-Switch & 15A Feed Socket for Cabinet, Optical Isolation Barrier & Surge Protection on V ",null,{"v":0,"d":"0%"},1,0,0,0]
["2.5","Testing, Repair and /or replacement of cabinet Fan and cabinet power plugs ",null,{"v":0,"d":"0%"},1,0,0,0]
["2.6","Supply and installation of 4000VA UPS or Repair 230 APC Smart-UPS XL 2200VA RM 3U 230V ",null,null,1,0,0,0]
["2.7","Cabinet Cleaning, mounting existing switches, modems and Cable tying",null,{"v":0,"d":"0%"},1,0,0,0]
[3,"DOCUMENTATION",{"$nulls":4},{"$f":"SUBTOTAL(9, G42:G45)","v":0},{"$f":"SUBTOTAL(9, H42:H45)","v":0}]
["3.1","UTP Test Results (ALL LAN POINTS)",null,{"v":0,"d":"0%"},1,0,{"$f":"E42*F42","v":0},0]
["3.2","Manufacturer Data Point Certification ",null,{"v":0,"d":"0%"},1,0,0,0]
["3.3","COC - Electrical Certification ",null,{"v":0,"d":"0%"},1,0,0,0]
["3.4","Schematic Layout Of Network (4 PRINTOUTS)",null,{"v":0,"d":"0%"},4,0,0,0]
[null,"TOTAL BID PRICE  (EXCL VAT)",{"$nulls":4},{"$f":"SUBTOTAL(9,G19:G45)","v":0},{"$f":"SUBTOTAL(9,H19:H45)","v":0}]
[null,"VAT (@15%)",{"$nulls":4},{"$f":"G46*0.15","v":0}]
[null,"TOTAL  BID PRICE (INCL VAT)",{"$nulls":4},{"$f":"G46+G47","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":"Mapodile","index":9,"n_rows":58,"n_cols":10,"rows_kept":58,"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],[54,1,57,1],[54,2,54,3],[54,4,54,5],[55,2,55,3],[56,2,56,3],[56,4,56,5],[57,2,57,3],[57,4,57,5]]}
[null,"SUPPLY CHAIN MANAGEMENT"]
[null,"Pricing schedule"]
["RFx No"]
["RFx Title","Supply, Install, and Configure Network Solution of Twenty Libraries for the Limpopo Department of Sports, Arts and Culture - Mapodile 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,"New Installations",{"$nulls":4},{"$f":"SUBTOTAL(9,G20:G31)","v":0},{"$f":"SUBTOTAL(9,H20:H31)","v":0}]
["1.1","New insulation-displacement connector UTP CAT6e Data Point complete with flylead and patchlead ","Each",{"v":0,"d":"0%"},10,0,{"$f":"E20*F20","v":0},{"$f":"D20*G20","v":0}]
["1.2","RJ 45 WHITE SHUTTER CAT 6e ","Each",{"v":0,"d":"0%"},10,0,{"$f":"E21*F21","v":0},{"$f":"D21*G21","v":0}]
["1.3","45deg ADAPTER PLATE for COMPACT ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.4","TRUNKING FRAME 50 x 50 ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.5","Power Skirting 2 Compartment Supply & Install (2,4m or 3m lrnght)","Each",{"v":0,"d":"0%"},4,0,0,0]
["1.6","Brush Panel ","Each",{"v":0,"d":"0%"},2,0,0,0]
["1.7","INSULATION-DISPLACEMENT CONNECTOR 24 PORT KM8 CAT 6e LOADED ","Each",{"v":0,"d":"0%"},1,0,0,0]
["1.8","Triple output kettle cord PC power cable ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.9","Extra Flyleads ","Each",{"v":0,"d":"0%"},15,0,0,0]
["1.10","25 X 50 BLANK ","Each",{"v":0,"d":"0%"},10,0,{"$f":"E29*F29","v":0},{"$f":"D29*G29","v":0}]
["1.11","New Electrical Normal Power Point complete. ","Each",{"v":0,"d":"0%"},10,0,{"$f":"E30*F30","v":0},{"$f":"D30*G30","v":0}]
["1.12","New Electrical Dedicated Power Point complete ","Each",{"v":0,"d":"0%"},10,0,0,0]
[2,"Existing Cabling to be Maintained",{"$nulls":4},{"$f":"SUBTOTAL(9, G33:G44)","v":0},{"$f":"SUBTOTAL(9, H33:H44)","v":0}]
["2.1"," Electrical Normal Power Point complete. ","Each",{"v":0,"d":"0%"},53,0,0,0]
["2.2","Electrical Dedicated Power Point complete ","Each",{"v":0,"d":"0%"},20,0,0,0]
["2.3","Electrical 2 Pin 5 A Power outlet ","Each",{"v":0,"d":"0%"},8,0,0,0]
["2.4","UTP Testing,  Fixing  & Labelling","Each",{"v":0,"d":"0%"},35,0,0,0]
["2.5","UTP Labelling ","Each",{"v":0,"d":"0%"},90,0,0,0]
["2.6","Power Plugs Testing, Fixing and Labelling ","Per Hour",{"v":0,"d":"0%"},4,0,0,0]
["2.7","Convert Red Power Plugs to Normal Power Plugs ","Each",{"v":0,"d":"0%"},10,0,0,0]
["2.8","Add 2U Electrical Surge & Lighting Protection / Complete System for One V11/X.21 Interface / Unit Includes Equipment AC Power Surge Protector (Phase 3), AC Feed Power Trip-Switch & 15A Feed Socket for Cabinet, Optical Isolation Barrier & Surge Protection on V ","Each",{"v":0,"d":"0%"},1,0,0,0]
["2.9","Testing, Repair and /or replacement of cabinet Fan and cabinet power plugs ","Per Hour",{"v":0,"d":"0%"},2,0,0,0]
["2.10","Supply and installation of 4000VA UPS or Repair 230 APC Smart-UPS XL 2200VA RM 3U 230V ","Each",{"v":0,"d":"0%"},1,0,0,0]
["2.11","Cabinet Cleaning, mounting existing switches, modems and Cable tying","Per Hour",{"v":0,"d":"0%"},1,0,0,0]
["2.12","Service of 1200 BTU air conditioner ","Per Hour",{"v":0,"d":"0%"},2,0,0,0]
[3,"DOCUMENTATION",{"$nulls":4},{"$f":"SUBTOTAL(9, G46:G49)","v":0},{"$f":"SUBTOTAL(9, H46:H49)","v":0}]
["3.1","UTP Test Results (ALL LAN POINTS)","Each",{"v":0,"d":"0%"},1,0,{"$f":"E46*F46","v":0},0]
["3.2","Manufacturer Data Point Certification ","Each",{"v":0,"d":"0%"},1,0,0,0]
["3.3","COC - Electrical Certification ","Each",{"v":0,"d":"0%"},1,0,0,0]
["3.4","Schematic Layout Of Network (4 PRINTOUTS)","Each",{"v":0,"d":"0%"},4,0,0,0]
[null,"TOTAL BID PRICE  (EXCL VAT)",{"$nulls":4},{"$f":"SUBTOTAL(9,G19:G49)","v":0},{"$f":"SUBTOTAL(9,H19:H49)","v":0}]
[null,"VAT (@15%)",{"$nulls":4},{"$f":"G50*0.15","v":0}]
[null,"TOTAL  BID PRICE (INCL VAT)",{"$nulls":4},{"$f":"G50+G51","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":"Marapong","index":10,"n_rows":53,"n_cols":10,"rows_kept":53,"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],[49,1,52,1],[49,2,49,3],[49,4,49,5],[50,2,50,3],[51,2,51,3],[51,4,51,5],[52,2,52,3],[52,4,52,5]]}
[null,"SUPPLY CHAIN MANAGEMENT"]
[null,"Pricing schedule"]
["RFx No"]
["RFx Title","Supply, Install, and Configure Network Solution of Twenty Libraries for the Limpopo Department of Sports, Arts and Culture - Marapong 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,"New Installation",{"$nulls":4},{"$f":"SUBTOTAL(9,G20:G31)","v":0},{"$f":"SUBTOTAL(9,H20:H31)","v":0}]
["1.1","New insulation-displacement connector UTP CAT6e Data Point complete with flylead and patchlead ","Each",{"v":0,"d":"0%"},10,0,{"$f":"E20*F20","v":0},{"$f":"D20*G20","v":0}]
["1.2","RJ 45 WHITE SHUTTER CAT 6e ","Each",{"v":0,"d":"0%"},10,0,{"$f":"E21*F21","v":0},{"$f":"D21*G21","v":0}]
["1.3","45deg ADAPTER PLATE for COMPACT ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.4","TRUNKING FRAME 50 x 50 ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.5","25 X 50 BLANK ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.6","New Electrical Normal Power Point complete. ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.7","Brush Panel ","Each",{"v":0,"d":"0%"},2,0,0,0]
["1.8","INSULATION-DISPLACEMENT CONNECTOR 24 PORT KM8 CAT 6e LOADED ","Each",{"v":0,"d":"0%"},1,0,0,0]
["1.9","Triple output kettle cord PC power cable ","Each",{"v":0,"d":"0%"},10,0,{"$f":"E28*F28","v":0},{"$f":"D28*G28","v":0}]
["1.10","Extra Flyleads ","Each",{"v":0,"d":"0%"},5,0,{"$f":"E29*F29","v":0},{"$f":"D29*G29","v":0}]
["1.11","New Electrical Dedicated Power Point complete ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.12","Electrical 2 Pin 5 A Power outlet ","Each",{"v":0,"d":"0%"},5,0,0,0]
[2,"Existing Cabling to be Maintained",{"$nulls":4},{"$f":"SUBTOTAL(9, G33:G39)","v":0},{"$f":"SUBTOTAL(9, H33:H39)","v":0}]
["2.1","UTP Testing, Fixing  & labelling","Each",{"v":0,"d":"0%"},38,0,0,0]
["2.2","UTP Labelling ","Each",{"v":0,"d":"0%"},76,0,0,0]
["2.3","Power Plugs Testing, Fixing and Labelling ","Per Hour",{"v":0,"d":"0%"},3,0,0,0]
["2.4","Add 2U Electrical Surge & Lighting Protection / Complete System for One V11/X.21 Interface / Unit Includes Equipment AC Power Surge Protector (Phase 3), AC Feed Power Trip-Switch & 15A Feed Socket for Cabinet, Optical Isolation Barrier & Surge Protection on V ","Each",{"v":0,"d":"0%"},1,0,0,0]
["2.5","Testing, Repair and /or replacement of cabinet Fan and cabinet power plugs ","Per Hour",{"v":0,"d":"0%"},1,0,0,0]
["2.6","Supply and installation of 4000VA UPS or Repair 230 APC Smart-UPS XL 2200VA RM 3U 230V ","Each",null,1,0,0,0]
["2.7","Cabinet Cleaning, mounting existing switches, modems and Cable tying ","Per Hour",{"v":0,"d":"0%"},1,0,0,0]
[3,"DOCUMENTATION",{"$nulls":4},{"$f":"SUBTOTAL(9, G41:G44)","v":0},{"$f":"SUBTOTAL(9, H41:H44)","v":0}]
["3.1","UTP Test Results (ALL LAN POINTS)","Each",{"v":0,"d":"0%"},1,0,{"$f":"E41*F41","v":0},0]
["3.2","Manufacturer Data Point Certification ","Each",{"v":0,"d":"0%"},1,0,0,0]
["3.3","COC - Electrical Certification ","Each",{"v":0,"d":"0%"},1,0,0,0]
["3.4","Schematic Layout Of Network (4 PRINTOUTS)","Each",{"v":0,"d":"0%"},4,0,0,0]
[null,"TOTAL BID PRICE  (EXCL VAT)",{"$nulls":4},{"$f":"SUBTOTAL(9,G19:G44)","v":0},{"$f":"SUBTOTAL(9,H19:H44)","v":0}]
[null,"VAT (@15%)",{"$nulls":4},{"$f":"G45*0.15","v":0}]
[null,"TOTAL  BID PRICE (INCL VAT)",{"$nulls":4},{"$f":"G45+G46","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":"Marblehall","index":11,"n_rows":55,"n_cols":10,"rows_kept":55,"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],[51,1,54,1],[51,2,51,3],[51,4,51,5],[52,2,52,3],[53,2,53,3],[53,4,53,5],[54,2,54,3],[54,4,54,5]]}
[null,"SUPPLY CHAIN MANAGEMENT"]
[null,"Pricing schedule"]
["RFx No"]
["RFx Title","Supply, Install, and Configure Network Solution of Twenty Libraries for the Limpopo Department of Sports, Arts and Culture - Marblehall 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,"Marblehall LIBRARY",{"$nulls":4},{"$f":"SUBTOTAL(9,G20:G26)","v":0},{"$f":"SUBTOTAL(9,H20:H26)","v":0}]
["1.1","Test & Repair / replace flash mount and surface mount wall boxes","Each",{"v":0,"d":"0%"},10,0,{"$f":"E20*F20","v":0},{"$f":"D20*G20","v":0}]
["1.2","1 Meter Cat 5e / 6 Patch Lead","Each",{"v":0,"d":"0%"},10,0,{"$f":"E21*F21","v":0},{"$f":"D21*G21","v":0}]
["1.3","Krone UTP CAT6 Data Point complete with 3m flylead and patchlead","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.4","ADAPTER 22.5 X 45 LEGRAND HK SHUTTER","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.5","KEYSTONE RJ45 KM8 C6 WHITE STP","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.6","Cover Plate P/O 50x50 E/O","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.7","Collar 50x50","Each",{"v":0,"d":"0%"},10,0,0,0]
[2,"Existing Cabling to be Maintained",{"$nulls":4},{"$f":"SUBTOTAL(9,G28:G35)","v":0},{"$f":"SUBTOTAL(9,H28:H35)","v":0}]
["2.1","CAT 6 Surface mount Data Point complete with 3m fly lead and patch lead for WiFi AP, WIFI/APS Connectors","Each",{"v":0,"d":"0%"},50,0,0,0]
["2.2","Electrical Normal Power Point  complete, excl CB.","Each",{"v":0,"d":"0%"},120,0,0,0]
["2.3","Electrical Dedicated Power Point  complete, excl CB.","Each",{"v":0,"d":"0%"},10,0,{"$f":"E30*F30","v":0},{"$f":"D30*G30","v":0}]
["2.4","Cover 2 X 4 Vert White 16 Amp","Each",{"v":0,"d":"0%"},48,0,{"$f":"E31*F31","v":0},{"$f":"D31*G31","v":0}]
["2.5","Cover Socket 2 X 4 Vert Red Ded 16 Amp For MS2","Per Hour",{"v":0,"d":"0%"},1,0,0,0]
["2.6","Plugtop 16 Amp Red","Per Hour",{"v":0,"d":"0%"},1,0,0,0]
["2.7","Cable Surfex 2,5 X 2 Core + Earth","Each",{"v":0,"d":"0%"},1,0,0,0]
["2.8","yt2 Surface mount trunking","Per Hour",{"v":0,"d":"0%"},1,0,0,0]
[3,"Others",{"$nulls":4},{"$f":"SUBTOTAL(9, G37:G41)","v":0},{"$f":"SUBTOTAL(9, H37:H41)","v":0}]
["3.1","Power Skirting 2 Compartment Supply & Install ","Per Metre",{"v":0,"d":"0%"},60,0,0,0]
["3.3","Brush Panel ","Each",{"v":0,"d":"0%"},2,0,0,0]
["3.4","INSULATION-DISPLACEMENT CONNECTOR 24 PORT KM8 CAT 6e LOADED ","Each",{"v":0,"d":"0%"},2,0,0,0]
["3.5","Triple output kettle cord PC power cable ","Each",{"v":0,"d":"0%"},20,0,0,0]
["3.6","Extra Flyleads ","Each",{"v":0,"d":"0%"},15,0,0,0]
[4,"DOCUMENTATION",{"$nulls":4},{"$f":"SUBTOTAL(9, G43:G46)","v":0},{"$f":"SUBTOTAL(9, H43:H46)","v":0}]
["4.1","UTP Test Results (ALL LAN POINTS)","Each",{"v":0,"d":"0%"},1,0,{"$f":"E43*F43","v":0},0]
["4.2","Manufacturer Data Point Certification ","Each",{"v":0,"d":"0%"},1,0,0,0]
["4.3","COC - Electrical Certification ","Each",{"v":0,"d":"0%"},1,0,0,0]
["4.4","Schematic Layout Of Network (4 PRINTOUTS)","Each",{"v":0,"d":"0%"},4,0,0,0]
[null,"TOTAL BID PRICE  (EXCL VAT)",{"$nulls":4},{"$f":"SUBTOTAL(9,G19:G46)","v":0},{"$f":"SUBTOTAL(9,H19:H46)","v":0}]
[null,"VAT (@15%)",{"$nulls":4},{"$f":"G47*0.15","v":0}]
[null,"TOTAL  BID PRICE (INCL VAT)",{"$nulls":4},{"$f":"G47+G48","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":"Mogwadi","index":12,"n_rows":63,"n_cols":10,"rows_kept":63,"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],[59,1,62,1],[59,2,59,3],[59,4,59,5],[60,2,60,3],[61,2,61,3],[61,4,61,5],[62,2,62,3],[62,4,62,5]]}
[null,"SUPPLY CHAIN MANAGEMENT"]
[null,"Pricing schedule"]
["RFx No"]
["RFx Title","Supply, Install, and Configure Network Solution of Twenty Libraries for the Limpopo Department of Sports, Arts and Culture - Mogwadi 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,"Mogwadi Library",{"$nulls":4},{"$f":"SUBTOTAL(9,G20:G42)","v":0},{"$f":"SUBTOTAL(9,H20:H42)","v":0}]
["1.1","Test & Repair / replace flash mount and surface mount wall boxes & Labelling","Each",{"v":0,"d":"0%"},31,0,{"$f":"E20*F20","v":0},{"$f":"D20*G20","v":0}]
["1.2","1 Meter Cat 5e / 6 Patch Lead","Each",{"v":0,"d":"0%"},31,0,{"$f":"E21*F21","v":0},{"$f":"D21*G21","v":0}]
["1.3","UTP CAT6 Data Point complete with 3m flylead and patchlead","Each",{"v":0,"d":"0%"},4,0,0,0]
["1.4","ADAPTER 22.5 X 45 LEGRAND HK SHUTTER","Each",{"v":0,"d":"0%"},4,0,0,0]
["1.5","KEYSTONE RJ45 KM8 C6 WHITE STP","Each",{"v":0,"d":"0%"},4,0,0,0]
["1.6","Cover Plate P/O 50x50 E/O","Each",{"v":0,"d":"0%"},4,0,0,0]
["1.7","Collar 50x50","Each",{"v":0,"d":"0%"},4,0,0,0]
["1.8","Euromod Half Blank White","Each",{"v":0,"d":"0%"},4,0,0,0]
["1.9","CAT 6 Surface mount Data Point complete with 3m fly lead and patch lead for WiFi AP, WIFI/APS Connectors","Each",{"v":0,"d":"0%"},1,0,0,0]
["1.10","Electrical Normal Power Point  complete, excl CB.","Each",{"v":0,"d":"0%"},4,0,0,0]
["1.11","Electrical Dedicated Power Point  complete, excl CB.","Each",{"v":0,"d":"0%"},4,0,{"$f":"E30*F30","v":0},{"$f":"D30*G30","v":0}]
["1.12","Cover 2 X 4 Vert White 16 Amp","Each",{"v":0,"d":"0%"},4,0,{"$f":"E31*F31","v":0},{"$f":"D31*G31","v":0}]
["1.13","Cover Socket 2 X 4 Vert Red Ded 16 Amp For MS2","Each",{"v":0,"d":"0%"},4,0,0,0]
["1.14","Plugtop 16 Amp Red","Each",{"v":0,"d":"0%"},4,0,0,0]
["1.15","Cable Surfex 2,5 X 2 Core + Earth","Per Metre",{"v":0,"d":"0%"},100,0,0,0]
["1.16","yt2 Surface mount trunking","Per Metre",{"v":0,"d":"0%"},3,0,0,0]
["1.17","Dual Metal Channel (Incl Corners, End Caps Etc.) Easter Oak / Hospital Grey","Per Metre",{"v":0,"d":"0%"},10,0,0,0]
["1.18","Switches 24 PORT POE","Each",{"v":0,"d":"0%"},1,0,0,0]
["1.19","Internal Ceiling mount access point","Each",{"v":0,"d":"0%"},1,0,0,0]
["1.20","BRUSH PANEL SHORT BASE METAL","Each",{"v":0,"d":"0%"},4,0,0,0]
["1.21","24 PORT PATCH PANEL CAT 6e LOADED","Each",{"v":0,"d":"0%"},2,0,0,0]
["1.22","Smart-UPS, 2000 Watts /3 KVA, Input 230V /Output 230V, Interface Port USB, Rack mounted","Each",{"v":0,"d":"0%"},1,0,0,0]
["1.23","Cabinet Cleaning, mounting existing switches, modems and Cable tying ","Each",{"v":0,"d":"0%"},1,0,0,0]
[2,"SUNDRIES/INFRASTRUCTURE",{"$nulls":4},{"$f":"SUBTOTAL(9, G44:G49)","v":0},{"$f":"SUBTOTAL(9, H44:H49)","v":0}]
["2.1","Tape Brother White 9mm / BRADY \"0\" - \"9\" 37/STRIP BLACK/WHITE","Each",{"v":0,"d":"0%"},2,0,0,0]
["2.2","BRADY \"0\" - \"9\" 37/STRIP BLACK/WHITE","Each",{"v":0,"d":"0%"},2,0,0,0]
["2.3","Insulation Tape - Black","Each",{"v":0,"d":"0%"},2,0,0,0]
["2.4","Knock Inns 6 X 55","Each",{"v":0,"d":"0%"},50,0,0,0]
["2.5","M6 Flat Washer","Each",{"v":0,"d":"0%"},50,0,0,0]
["2.6","Silicone","Each",{"v":0,"d":"0%"},1,0,0,0]
[3,"DOCUMENTATION",{"$nulls":4},{"$f":"SUBTOTAL(9, G51:G54)","v":0},{"$f":"SUBTOTAL(9, H51:H54)","v":0}]
["3.1","Schematic Layout Of Network (3 PRINTOUTS)","Each",{"v":0,"d":"0%"},3,0,{"$f":"E51*F51","v":0},0]
["3.2","Data Certification","Each",{"v":0,"d":"0%"},1,0,0,0]
["3.3","UTP Test Results","Each",{"v":0,"d":"0%"},1,0,0,0]
["3.4","COC - Electrical Certification","Each",{"v":0,"d":"0%"},1,0,0,0]
[null,"TOTAL BID PRICE  (EXCL VAT)",{"$nulls":4},{"$f":"SUBTOTAL(9,G19:G54)","v":0},{"$f":"SUBTOTAL(9,H19:H54)","v":0}]
[null,"VAT (@15%)",{"$nulls":4},{"$f":"G55*0.15","v":0}]
[null,"TOTAL  BID PRICE (INCL VAT)",{"$nulls":4},{"$f":"G55+G56","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":"Moletjie","index":13,"n_rows":54,"n_cols":10,"rows_kept":54,"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],[50,1,53,1],[50,2,50,3],[50,4,50,5],[51,2,51,3],[52,2,52,3],[52,4,52,5],[53,2,53,3],[53,4,53,5]]}
[null,"SUPPLY CHAIN MANAGEMENT"]
[null,"Pricing schedule"]
["RFx No"]
["RFx Title","Supply, Install, and Configure Network Solution of Twenty Libraries for the Limpopo Department of Sports, Arts and Culture - Moletjie 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,"Moletjie Library",{"$nulls":4},{"$f":"SUBTOTAL(9,G20:G32)","v":0},{"$f":"SUBTOTAL(9,H20:H32)","v":0}]
["1.1","New insulation-displacement connector UTP CAT6e Data Point complete with flylead and patchlead ","Each",{"v":0,"d":"0%"},10,0,{"$f":"E20*F20","v":0},{"$f":"D20*G20","v":0}]
["1.2","RJ 45 WHITE SHUTTER CAT 6e ","Each",{"v":0,"d":"0%"},10,0,{"$f":"E21*F21","v":0},{"$f":"D21*G21","v":0}]
["1.3","45deg ADAPTER PLATE for COMPACT ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.4","TRUNKING FRAME 50 x 50 ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.5","25 X 50 BLANK ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.6","New Electrical Normal Power Point complete. ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.7","New Electrical Dedicated Power Point complete. ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.8","Power Skirting 2 Compartment Supply & Install (2,4m / 3,0 m length)","Per Metre",{"v":0,"d":"0%"},12,0,0,0]
["1.9","Brush Panel ","Each",{"v":0,"d":"0%"},2,0,0,0]
["1.10","INSULATION-DISPLACEMENT CONNECTOR 24 PORT KM8 CAT 6e LOADED ","Each",{"v":0,"d":"0%"},1,0,{"$f":"E29*F29","v":0},{"$f":"D29*G29","v":0}]
["1.11","Triple output kettle cord PC power cable ","Each",{"v":0,"d":"0%"},10,0,{"$f":"E30*F30","v":0},{"$f":"D30*G30","v":0}]
["1.12","Extra Flyleads ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.13","Electrical 2 Pin 5 A Power outlet ","Each",{"v":0,"d":"0%"},2,0,0,0]
[2,"Existing cabling to be Maintained",{"$nulls":4},{"$f":"SUBTOTAL(9, G34:G40)","v":0},{"$f":"SUBTOTAL(9, H34:H40)","v":0}]
["2.1","UTP Testing, Fixing  & Labelling ","Each",{"v":0,"d":"0%"},32,0,0,0]
["2.2","UTP Labelling ","Each",{"v":0,"d":"0%"},84,0,0,0]
["2.3","Power Plugs Testing, Fixing and Labelling ","Each",{"v":0,"d":"0%"},35,0,0,0]
["2.4","Add 2U Electrical Surge & Lighting Protection / Complete System for One V11/X.21 Interface / Unit, Includes Equipment AC Power Surge Protector (Phase 3), AC Feed Power Trip-Switch & 15A Feed Socket for Cabinet, Optical Isolation Barrier & Surge Protection on V","Each",{"v":0,"d":"0%"},1,0,0,0]
["2.5","Testing, Repair and /or replacement of cabinet Fan and cabinet power plugs ","Per Hour",{"v":0,"d":"0%"},1,0,0,0]
["2.6","Supply and installation of 4000VA UPS or Repair 230 APC Smart-UPS XL 2200VA RM 3U 230V ","Each",null,1,0,0,0]
["2.7","Cabinet Cleaning, mounting existing switches, modems and Cable tying ","Per Hour",{"v":0,"d":"0%"},1,0,0,0]
[3,"DOCUMENTATION",{"$nulls":4},{"$f":"SUBTOTAL(9, G42:G45)","v":0},{"$f":"SUBTOTAL(9, H42:H45)","v":0}]
["3.1","UTP Test Results (ALL LAN POINTS)","Each",{"v":0,"d":"0%"},1,0,{"$f":"E42*F42","v":0},0]
["3.2","Manufacturer Data Point Certification ","Each",{"v":0,"d":"0%"},1,0,0,0]
["3.3","COC - Electrical Certification ","Each",{"v":0,"d":"0%"},1,0,0,0]
["3.4","Schematic Layout Of Network (4 PRINTOUTS)","Each",{"v":0,"d":"0%"},4,0,0,0]
[null,"TOTAL BID PRICE  (EXCL VAT)",{"$nulls":4},{"$f":"SUBTOTAL(9,G19:G45)","v":0},{"$f":"SUBTOTAL(9,H19:H45)","v":0}]
[null,"VAT (@15%)",{"$nulls":4},{"$f":"G46*0.15","v":0}]
[null,"TOTAL  BID PRICE (INCL VAT)",{"$nulls":4},{"$f":"G46+G47","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":"Mookgophong","index":14,"n_rows":53,"n_cols":10,"rows_kept":53,"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],[49,1,52,1],[49,2,49,3],[49,4,49,5],[50,2,50,3],[51,2,51,3],[51,4,51,5],[52,2,52,3],[52,4,52,5]]}
[null,"SUPPLY CHAIN MANAGEMENT"]
[null,"Pricing schedule"]
["RFx No"]
["RFx Title","Supply, Install, and Configure Network Solution of Twenty Libraries for the Limpopo Department of Sports, Arts and Culture - Mookgophong 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,"New Installation",{"$nulls":4},{"$f":"SUBTOTAL(9,G20:G31)","v":0},{"$f":"SUBTOTAL(9,H20:H31)","v":0}]
["1.1","New insulation-displacement connector UTP CAT6e Data Point complete with flylead and patchlead ","Each",{"v":0,"d":"0%"},10,0,{"$f":"E20*F20","v":0},{"$f":"D20*G20","v":0}]
["1.2","RJ 45 WHITE SHUTTER CAT 6e ","Each",{"v":0,"d":"0%"},10,0,{"$f":"E21*F21","v":0},{"$f":"D21*G21","v":0}]
["1.3","45deg ADAPTER PLATE for COMPACT ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.4","TRUNKING FRAME 50 x 50 ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.5","25 X 50 BLANK ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.6","New Electrical Normal Power Point complete. ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.7","New Electrical Dedicated Power Point complete ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.8","Power Skirting 2 Compartment Supply & Install (2,4m / 3,0m length)","Each",{"v":0,"d":"0%"},12,0,0,0]
["1.9","Brush Panel ","Each",{"v":0,"d":"0%"},2,0,0,0]
["1.10","INSULATION-DISPLACEMENT CONNECTOR 24 PORT KM8 CAT 6e LOADED ","Each",{"v":0,"d":"0%"},1,0,{"$f":"E29*F29","v":0},{"$f":"D29*G29","v":0}]
["1.11","Triple output kettle cord PC power cable ","Each",{"v":0,"d":"0%"},10,0,{"$f":"E30*F30","v":0},{"$f":"D30*G30","v":0}]
["1.12","Extra Flyleads ","Each",{"v":0,"d":"0%"},15,0,0,0]
[2,"Existing Cabling to be Maintained",{"$nulls":4},{"$f":"SUBTOTAL(9, G33:G39)","v":0},{"$f":"SUBTOTAL(9, H33:H39)","v":0}]
["2.1","UTP Testing, Fixing  & Labelling","Each",{"v":0,"d":"0%"},70,0,0,0]
["2.2","UTP Labelling ","Each",{"v":0,"d":"0%"},160,0,0,0]
["2.3","Power Plugs Testing, Fixing and Labelling ","Each",{"v":0,"d":"0%"},50,0,0,0]
["2.4","Add 2U Electrical Surge & Lighting Protection / Complete System for One V11/X.21 Interface / Unit Includes Equipment AC Power Surge Protector (Phase 3), AC Feed Power Trip-Switch & 15A Feed Socket for Cabinet, Optical Isolation Barrier & Surge Protection on V ","Each",{"v":0,"d":"0%"},1,0,0,0]
["2.5","Testing, Repair and /or replacement of cabinet Fan and cabinet power plugs ","Per Hour",{"v":0,"d":"0%"},1,0,0,0]
[null,"Supply and installation of 4000VA UPS or Repair 230 APC Smart-UPS XL 2200VA RM 3U 230V ","Each",{"v":0,"d":"0%"},1,0,0,0]
["2.6","Cabinet Cleaning, mounting existing switches, modems and Cable tying ","Per Hour",{"v":0,"d":"0%"},1,0,0,0]
[3,"DOCUMENTATION",{"$nulls":4},{"$f":"SUBTOTAL(9, G41:G44)","v":0},{"$f":"SUBTOTAL(9, H41:H44)","v":0}]
["3.1","UTP Test Results (ALL LAN POINTS)","Each",{"v":0,"d":"0%"},1,0,{"$f":"E41*F41","v":0},0]
["3.2","Manufacturer Data Point Certification ","Each",{"v":0,"d":"0%"},1,0,0,0]
["3.3","COC - Electrical Certification ","Each",{"v":0,"d":"0%"},1,0,0,0]
["3.4","Schematic Layout Of Network (4 PRINTOUTS)","Each",{"v":0,"d":"0%"},4,0,0,0]
[null,"TOTAL BID PRICE  (EXCL VAT)",{"$nulls":4},{"$f":"SUBTOTAL(9,G19:G44)","v":0},{"$f":"SUBTOTAL(9,H19:H44)","v":0}]
[null,"VAT (@15%)",{"$nulls":4},{"$f":"G45*0.15","v":0}]
[null,"TOTAL  BID PRICE (INCL VAT)",{"$nulls":4},{"$f":"G45+G46","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":"Morebeng","index":15,"n_rows":54,"n_cols":10,"rows_kept":54,"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],[50,1,53,1],[50,2,50,3],[50,4,50,5],[51,2,51,3],[52,2,52,3],[52,4,52,5],[53,2,53,3],[53,4,53,5]]}
[null,"SUPPLY CHAIN MANAGEMENT"]
[null,"Pricing schedule"]
["RFx No"]
["RFx Title","Supply, Install, and Configure Network Solution of Twenty Libraries for the Limpopo Department of Sports, Arts and Culture - Morebeng 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,"Morebeng Library",{"$nulls":4},{"$f":"SUBTOTAL(9,G20:G30)","v":0},{"$f":"SUBTOTAL(9,H20:H30)","v":0}]
["1.1","New insulation-displacement connector UTP CAT6e Data Point complete with flylead and patchlead ","Each",{"v":0,"d":"0%"},10,0,{"$f":"E20*F20","v":0},{"$f":"D20*G20","v":0}]
["1.2","RJ 45 WHITE SHUTTER CAT 6e ","Each",{"v":0,"d":"0%"},10,0,{"$f":"E21*F21","v":0},{"$f":"D21*G21","v":0}]
["1.3","45deg ADAPTER PLATE for COMPACT ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.4","TRUNKING FRAME 50 x 50 ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.5","New Electrical Normal Power Point complete. ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.6","New Electrical Dedicated Power Point complete ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.7","25 X 50 BLANK ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.8","Power Skirting 2 Compartment Supply & Install (2,4m / 3,0 m length)","Per Metre",{"v":0,"d":"0%"},12,0,0,0]
["1.9","INSULATION-DISPLACEMENT CONNECTOR 24 PORT KM8 CAT 6e LOADED ","Each",{"v":0,"d":"0%"},1,0,0,0]
["1.10","Triple output kettle cord PC power cable ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.11","Extra Flyleads ","Each",{"v":0,"d":"0%"},10,0,{"$f":"E30*F30","v":0},{"$f":"D30*G30","v":0}]
[2,"Existing Cabling to be Maintained",{"$nulls":4},{"$f":"SUBTOTAL(9, G32:G40)","v":0},{"$f":"SUBTOTAL(9, H32:H40)","v":0}]
["2.1","Electrical 2 Pin 5 A Power outlet ","Each",{"v":0,"d":"0%"},10,0,{"$f":"E32*F32","v":0},{"$f":"D32*G32","v":0}]
["2.2","UTP Testing, Fixing  & Labelling","Each",{"v":0,"d":"0%"},37,0,0,0]
["2.3","UTP Labelling ","Each",{"v":0,"d":"0%"},94,0,0,0]
["2.4","Power Plugs Testing, Fixing and Labelling ","Each",{"v":0,"d":"0%"},32,0,0,0]
["2.5","Brush Panel ","Each",{"v":0,"d":"0%"},2,0,0,0]
["2.6","Add 2U Electrical Surge & Lighting Protection / Complete System for One V11/X.21 Interface / Unit Includes Equipment AC Power Surge Protector (Phase 3), AC Feed Power Trip-Switch & 15A Feed Socket for Cabinet, Optical Isolation Barrier & Surge Protection on V ","Each",{"v":0,"d":"0%"},1,0,0,0]
["2.7","Testing, Repair and /or replacement of cabinet Fan and cabinet power plugs ","Per Hour",{"v":0,"d":"0%"},1,0,0,0]
["2.8","Supply and installation of 4000VA UPS or Repair 230 APC Smart-UPS XL 2200VA RM 3U 230V ","Each",{"v":0,"d":"0%"},1,0,0,0]
["2.9","Cabinet Cleaning, mounting existing switches, modems and Cable tying ","Per Hour",{"v":0,"d":"0%"},1,0,0,0]
[3,"DOCUMENTATION",{"$nulls":4},{"$f":"SUBTOTAL(9, G42:G45)","v":0},{"$f":"SUBTOTAL(9, H42:H45)","v":0}]
["3.1","UTP Test Results (ALL LAN POINTS)","Each",{"v":0,"d":"0%"},1,0,{"$f":"E42*F42","v":0},0]
["3.2","Manufacturer Data Point Certification ","Each",{"v":0,"d":"0%"},1,0,0,0]
["3.3","COC - Electrical Certification ","Each",{"v":0,"d":"0%"},1,0,0,0]
["3.4","Schematic Layout Of Network (4 PRINTOUTS)","Each",{"v":0,"d":"0%"},4,0,0,0]
[null,"TOTAL BID PRICE  (EXCL VAT)",{"$nulls":4},{"$f":"SUBTOTAL(9,G19:G45)","v":0},{"$f":"SUBTOTAL(9,H19:H45)","v":0}]
[null,"VAT (@15%)",{"$nulls":4},{"$f":"G46*0.15","v":0}]
[null,"TOTAL  BID PRICE (INCL VAT)",{"$nulls":4},{"$f":"G46+G47","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":"Mutale","index":16,"n_rows":54,"n_cols":10,"rows_kept":54,"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],[50,1,53,1],[50,2,50,3],[50,4,50,5],[51,2,51,3],[52,2,52,3],[52,4,52,5],[53,2,53,3],[53,4,53,5]]}
[null,"SUPPLY CHAIN MANAGEMENT"]
[null,"Pricing schedule"]
["RFx No"]
["RFx Title","Supply, Install, and Configure Network Solution of Twenty Libraries for the Limpopo Department of Sports, Arts and Culture - Mutale 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,"Mutale Library",{"$nulls":4},{"$f":"SUBTOTAL(9,G20:G30)","v":0},{"$f":"SUBTOTAL(9,H20:H30)","v":0}]
["1.1","New insulation-displacement connector UTP CAT6e Data Point complete with flylead and patchlead ","Each",{"v":0,"d":"0%"},10,0,{"$f":"E20*F20","v":0},{"$f":"D20*G20","v":0}]
["1.2","New RJ 45 WHITE SHUTTER CAT 6e ","Each",{"v":0,"d":"0%"},10,0,{"$f":"E21*F21","v":0},{"$f":"D21*G21","v":0}]
["1.3","New 45deg ADAPTER PLATE for COMPACT ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.4","New TRUNKING FRAME 50 x 50 ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.5","New 25 X 50 BLANK ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.6","New Electrical Normal Power Point complete. ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.7","New Electrical 2 Pin 5 A Power outlet ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.8","Power Skirting 2 Compartment Supply & Install (2,4m / 3,0m length)","Per Metre",{"v":0,"d":"0%"},12,0,0,0]
["1.9","Sundries and Consumables ","Each",{"v":0,"d":"0%"},1,0,0,0]
["1.10","INSULATION-DISPLACEMENT CONNECTOR 24 PORT KM8 CAT 6e LOADED ","Each",{"v":0,"d":"0%"},1,0,0,0]
["1.11","Brush Panel ","Each",{"v":0,"d":"0%"},2,0,{"$f":"E30*F30","v":0},{"$f":"D30*G30","v":0}]
[2,"SUNDRIES/INFRASTRUCTURE",{"$nulls":4},{"$f":"SUBTOTAL(9, G32:G40)","v":0},{"$f":"SUBTOTAL(9, H32:H40)","v":0}]
["2.1","Convert Red Power Plugs to Normal Power Plugs ","Each",{"v":0,"d":"0%"},18,0,{"$f":"E32*F32","v":0},{"$f":"D32*G32","v":0}]
["2.2","UTP Testing, Fixing  & Labelling","Each",{"v":0,"d":"0%"},64,0,0,0]
["2.3","UTP Labelling ","Each",{"v":0,"d":"0%"},148,0,0,0]
["2.4","Power Plugs Testing,  Fixing  & Labelling","Each",{"v":0,"d":"0%"},128,0,0,0]
["2.5","Relocate 27U Floor standing cabinet with all equipment inside to New Server room (includes power, Patch panels, Brash panels, UPS, Surge protector, Air Conditioner, UTP and power cabling.)","Per Hour",{"v":0,"d":"0%"},3,0,0,0]
["2.6","Relocate 1 x network point at Audio Visual room. ","Per Hour",{"v":0,"d":"0%"},1,0,0,0]
["2.7","Testing and repair/or Replacement of 2U Electrical Surge & Lighting Protection / Complete System for One V11/X.21 Interface / Unit Includes Equipment AC Power Surge Protector (Phase 3), AC Feed Power Trip-Switch & 15A Feed Socket for Cabinet, Optical Isolation Barrier & Surge Protection on V","Per Hour",{"v":0,"d":"0%"},1,0,0,0]
["2.8","Testing and repair/or replacement of 230 APC Smart-UPS XL 2200VA RM 3U 230V ","Per Hour",{"v":0,"d":"0%"},1,0,0,0]
["2.9","Cabinet Cleaning and Cable tying ","Per Hour",{"v":0,"d":"0%"},1,0,0,0]
[3,"DOCUMENTATION",{"$nulls":4},{"$f":"SUBTOTAL(9, G42:G45)","v":0},{"$f":"SUBTOTAL(9, H42:H45)","v":0}]
["3.1","UTP Test Results (ALL LAN POINTS)","Each",{"v":0,"d":"0%"},1,0,{"$f":"E42*F42","v":0},0]
["3.2","Manufacturer Data Point Certification ","Each",{"v":0,"d":"0%"},1,0,0,0]
["3.3","COC - Electrical Certification ","Each",{"v":0,"d":"0%"},1,0,0,0]
["3.4","Schematic Layout Of Network (4 PRINTOUTS)","Each",{"v":0,"d":"0%"},4,0,0,0]
[null,"TOTAL BID PRICE  (EXCL VAT)",{"$nulls":4},{"$f":"SUBTOTAL(9,G19:G45)","v":0},{"$f":"SUBTOTAL(9,H19:H45)","v":0}]
[null,"VAT (@15%)",{"$nulls":4},{"$f":"G46*0.15","v":0}]
[null,"TOTAL  BID PRICE (INCL VAT)",{"$nulls":4},{"$f":"G46+G47","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":"Phatantswane","index":17,"n_rows":54,"n_cols":10,"rows_kept":54,"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],[50,1,53,1],[50,2,50,3],[50,4,50,5],[51,2,51,3],[52,2,52,3],[52,4,52,5],[53,2,53,3],[53,4,53,5]]}
[null,"SUPPLY CHAIN MANAGEMENT"]
[null,"Pricing schedule"]
["RFx No"]
["RFx Title","Supply, Install, and Configure Network Solution of Twenty Libraries for the Limpopo Department of Sports, Arts and Culture - Phatantswane 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,"new Installations",{"$nulls":4},{"$f":"SUBTOTAL(9,G20:G31)","v":0},{"$f":"SUBTOTAL(9,H20:H31)","v":0}]
["1.1","ew insulation-displacement connector UTP CAT6e Data Point complete with flylead and patchlead ","Each",{"v":0,"d":"0%"},10,0,{"$f":"E20*F20","v":0},{"$f":"D20*G20","v":0}]
["1.2","RJ 45 WHITE SHUTTER CAT 6e ","Each",{"v":0,"d":"0%"},10,0,{"$f":"E21*F21","v":0},{"$f":"D21*G21","v":0}]
["1.3","45deg ADAPTER PLATE for COMPACT ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.4","TRUNKING FRAME 50 x 50 ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.5","25 X 50 BLANK ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.6","New Electrical Normal Power Point complete. ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.7","New Electrical Dedicated Power Point complete ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.8","Power Skirting 2 Compartment Supply & Install (2,4m /3,0m length)","Each",{"v":0,"d":"0%"},12,0,0,0]
["1.9","Brush Panel ","Each",{"v":0,"d":"0%"},2,0,0,0]
["1.10","INSULATION-DISPLACEMENT CONNECTOR 24 PORT KM8 CAT 6e LOADED ","Each",{"v":0,"d":"0%"},1,0,{"$f":"E29*F29","v":0},{"$f":"D29*G29","v":0}]
["1.11","Triple output kettle cord PC power cable ","Each",{"v":0,"d":"0%"},10,0,{"$f":"E30*F30","v":0},{"$f":"D30*G30","v":0}]
["1.12","Extra Flyleads ","Each",{"v":0,"d":"0%"},10,0,0,0]
[2,"Existing Cabling to be Maintained",{"$nulls":4},{"$f":"SUBTOTAL(9, G33:G40)","v":0},{"$f":"SUBTOTAL(9, H33:H40)","v":0}]
["2.1","UTP Testing, Fixing and Labelling ","Each",{"v":0,"d":"0%"},26,0,0,0]
["2.2","UTP Labelling ","Each",{"v":0,"d":"0%"},72,0,0,0]
["2.3","Power Plugs Testing, Fixing and Labelling ","Each",null,63,0,0,0]
["2.4","Electrical 2 Pin 5 A Power outlet ","Each",null,10,0,0,0]
["2.5","Add 2U Electrical Surge & Lighting Protection / Complete System for One V11/X.21 Interface / Unit Includes Equipment AC Power Surge Protector (Phase 3), AC Feed Power Trip-Switch & 15A Feed Socket for Cabinet, Optical Isolation Barrier & Surge Protection on V ","Each",{"v":0,"d":"0%"},1,0,0,0]
["2.6","Testing, Repair and /or replacement of cabinet Fan and cabinet power plugs ","Per Hour",{"v":0,"d":"0%"},1,0,0,0]
["2.7","Supply and installation of 4000VA UPS or Repair 230 APC Smart-UPS XL 2200VA RM 3U 230V ","Each",{"v":0,"d":"0%"},1,0,0,0]
["2.8","Cabinet Cleaning, mounting existing switches, modems and Cable tying ","Per Hour",{"v":0,"d":"0%"},1,0,0,0]
[3,"DOCUMENTATION",{"$nulls":4},{"$f":"SUBTOTAL(9, G42:G45)","v":0},{"$f":"SUBTOTAL(9, H42:H45)","v":0}]
["3.1","UTP Test Results (ALL LAN POINTS)","Each",{"v":0,"d":"0%"},1,0,{"$f":"E42*F42","v":0},0]
["3.2","Manufacturer Data Point Certification ","Each",{"v":0,"d":"0%"},1,0,0,0]
["3.3","COC - Electrical Certification ","Each",{"v":0,"d":"0%"},1,0,0,0]
["3.4","Schematic Layout Of Network (4 PRINTOUTS)","Each",{"v":0,"d":"0%"},4,0,0,0]
[null,"TOTAL BID PRICE  (EXCL VAT)",{"$nulls":4},{"$f":"SUBTOTAL(9,G19:G45)","v":0},{"$f":"SUBTOTAL(9,H19:H45)","v":0}]
[null,"VAT (@15%)",{"$nulls":4},{"$f":"G46*0.15","v":0}]
[null,"TOTAL  BID PRICE (INCL VAT)",{"$nulls":4},{"$f":"G46+G47","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":"Phokwane","index":18,"n_rows":57,"n_cols":10,"rows_kept":57,"merged":[[12,2,12,3],[13,2,13,3],[13,5,15,5],[14,2,14,3],[15,2,15,3],[17,4,17,6],[53,1,56,1],[53,2,53,3],[53,4,53,5],[54,2,54,3],[55,2,55,3],[55,4,55,5],[56,2,56,3],[56,4,56,5]]}
[null,"SUPPLY CHAIN MANAGEMENT"]
[null,"Pricing schedule"]
["RFx No"]
["RFx Title","Supply, Install, and Configure Network Solution of Twenty Libraries for the Limpopo Department of Sports, Arts and Culture - Phokwane Library"]
["Bidder Name "]
[]
["1. INSTRUCTION FOR COMPLETING THE PRICING SCHEDULE"]
["(a)  THIS PRICING SCHEDULE MUST BE SUBMITTED SEPARATELY FROM THE TECHNICAL RESPONSE, failing which the BID may be DISQUALIFIED."]
["(b)  Bidder must complete/enter YELLOW cells only"]
["(c)  Unit and Line prices must be VAT EXCLUSIVE and in South African Rand (ZAR) currency."]
["(e) 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"]
["(f)  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,"New Installation",{"$nulls":4},{"$f":"SUBTOTAL(9,G21:G31)","v":0},{"$f":"SUBTOTAL(9,H21:H31)","v":0}]
["1.1","New insulation-displacement connector UTP CAT6e Data Point complete with flylead and patchlead ","Each",{"v":0,"d":"0%"},10,0,{"$f":"E21*F21","v":0},{"$f":"D21*G21","v":0}]
["1.2","RJ 45 WHITE SHUTTER CAT 6e ","Each",{"v":0,"d":"0%"},10,0,{"$f":"E22*F22","v":0},{"$f":"D22*G22","v":0}]
["1.3","TRUNKING FRAME 50 x 50 ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.4","25 X 50 BLANK ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.5","New Electrical Normal Power Point complete. ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.6","New Electrical Dedicated Power Point complete ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.7","Power Skirting 2 Compartment Supply & Install (2,4m / 3,0m length)","Per Metre",{"v":0,"d":"0%"},12,0,0,0]
["1.8","Brush Panel ","Each",{"v":0,"d":"0%"},1,0,0,0]
["1.9","INSULATION-DISPLACEMENT CONNECTOR 24 PORT KM8 CAT 6e LOADED ","Each",{"v":0,"d":"0%"},1,0,{"$f":"E29*F29","v":0},{"$f":"D29*G29","v":0}]
["1.10","Triple output kettle cord PC power cable ","Each",{"v":0,"d":"0%"},10,0,{"$f":"E30*F30","v":0},{"$f":"D30*G30","v":0}]
["1.11","Extra Flyleads ","Each",{"v":0,"d":"0%"},10,0,0,0]
[2,"SUNDRIES/INFRASTRUCTURE",{"$nulls":4},{"$f":"SUBTOTAL(9, G33:G43)","v":0},{"$f":"SUBTOTAL(9, H33:H43)","v":0}]
["2.1","UTP Testing, Fixing and Labelling  ","Each",{"v":0,"d":"0%"},70,0,0,0]
["2.2","UTP Labelling ","Each",{"v":0,"d":"0%"},140,0,0,0]
["2.3","Power Plugs Testing, Fixing and Labelling ","Each",{"v":0,"d":"0%"},61,0,0,0]
["2.4","Relocate 27U Floor standing cabinet with all equipment inside to New Server room (includes power, Patch panels, Brash panels, UPS, Surge protector.) ","Per Hour",{"v":0,"d":"0%"},3,0,0,0]
["2.5","Relocate 1 x network point at Audio Visual room. ","Per Hour",{"v":0,"d":"0%"},1,0,0,0]
["2.6","Electrical 2 Pin 5 A Power outlet ","Each",{"v":0,"d":"0%"},10,0,0,0]
["2.7","Add 2U Electrical Surge & Lighting Protection / Complete System for One V11/X.21 Interface / Unit Includes Equipment AC Power Surge Protector (Phase 3), AC Feed Power Trip-Switch & 15A Feed Socket for Cabinet, Optical Isolation Barrier & Surge Protection on V ","Each",{"v":0,"d":"0%"},1,0,0,0]
["2.8","Testing, Repair and /or replacement of cabinet Fan and cabinet power plugs ","Per Hour",{"v":0,"d":"0%"},1,0,0,0]
["2.9","Supply and installation of 4000VA UPS or Repair 230 APC Smart-UPS XL 2200VA RM 3U 230V ","Each",{"v":0,"d":"0%"},1,0,0,0]
["2.10","Cabinet Cleaning, mounting existing switches, modems and Cable tying ","Per Hour",{"v":0,"d":"0%"},1,0,0,0]
["2.11","Service of 1200 BTU air conditioner ","Per Hour",{"v":0,"d":"0%"},2,0,0,0]
[3,"DOCUMENTATION",{"$nulls":4},{"$f":"SUBTOTAL(9, G45:G48)","v":0},{"$f":"SUBTOTAL(9, H45:H48)","v":0}]
["3.1","UTP Test Results (ALL LAN POINTS)","Each",{"v":0,"d":"0%"},1,0,{"$f":"E45*F45","v":0},0]
["3.2","Manufacturer Data Point Certification ","Each",{"v":0,"d":"0%"},1,0,0,0]
["3.3","COC - Electrical Certification ","Each",{"v":0,"d":"0%"},1,0,0,0]
["3.4","Schematic Layout Of Network (4 PRINTOUTS)","Each",{"v":0,"d":"0%"},4,0,0,0]
[null,"TOTAL BID PRICE  (EXCL VAT)",{"$nulls":4},{"$f":"SUBTOTAL(9,G20:G48)","v":0},{"$f":"SUBTOTAL(9,H20:H48)","v":0}]
[null,"VAT (@15%)",{"$nulls":4},{"$f":"G49*0.15","v":0}]
[null,"TOTAL  BID PRICE (INCL VAT)",{"$nulls":4},{"$f":"G49+G50","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":"Seshego","index":19,"n_rows":53,"n_cols":10,"rows_kept":53,"merged":[[12,2,12,3],[13,2,13,3],[13,5,15,5],[14,2,14,3],[15,2,15,3],[17,4,17,6],[49,1,52,1],[49,2,49,3],[49,4,49,5],[50,2,50,3],[51,2,51,3],[51,4,51,5],[52,2,52,3],[52,4,52,5]]}
[null,"SUPPLY CHAIN MANAGEMENT"]
[null,"Pricing schedule"]
["RFx No"]
["RFx Title","Supply, Install, and Configure Network Solution of Twenty Libraries for the Limpopo Department of Sports, Arts and Culture - Seshego Library"]
["Bidder Name "]
[]
["1. INSTRUCTION FOR COMPLETING THE PRICING SCHEDULE"]
["(a)  THIS PRICING SCHEDULE MUST BE SUBMITTED SEPARATELY FROM THE TECHNICAL RESPONSE, failing which the BID may be DISQUALIFIED."]
["(b)  Bidder must complete/enter YELLOW cells only"]
["(c)  Unit and Line prices must be VAT EXCLUSIVE and in South African Rand (ZAR) currency."]
["(e) 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"]
["(f)  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,"New Installations",{"$nulls":4},{"$f":"SUBTOTAL(9,G21:G29)","v":0},{"$f":"SUBTOTAL(9,H21:H29)","v":0}]
["1.1","New insulation-displacement connector UTP CAT6e Data Point complete with flylead and patchlead ","Each",{"v":0,"d":"0%"},10,0,{"$f":"E21*F21","v":0},{"$f":"D21*G21","v":0}]
["1.2","RJ 45 WHITE SHUTTER CAT 6e ","Each",{"v":0,"d":"0%"},10,0,{"$f":"E22*F22","v":0},{"$f":"D22*G22","v":0}]
["1.3","Power Skirting 2 Compartment Supply & Install (2,4m / 3,0m length)","Per Metre",{"v":0,"d":"0%"},12,0,0,0]
["1.4","Brush Panel ","Each",{"v":0,"d":"0%"},1,0,0,0]
["1.5","INSULATION-DISPLACEMENT CONNECTOR 24 PORT KM8 CAT 6e LOADED ","Each",{"v":0,"d":"0%"},1,0,0,0]
["1.6","Triple output kettle cord PC power cable ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.7","Extra Fly-leads ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.8","45deg ADAPTER PLATE for COMPACT ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.9","TRUNKING FRAME 50 x 50 ","Each",{"v":0,"d":"0%"},10,0,0,0]
[2,"Existing Cabling to be Maintained",{"$nulls":4},{"$f":"SUBTOTAL(9, G31:G39)","v":0},{"$f":"SUBTOTAL(9, H31:H39)","v":0}]
["2.1","UTP Testing, Fixing and Labelling ","Each",{"v":0,"d":"0%"},51,0,{"$f":"E31*F31","v":0},{"$f":"D31*G31","v":0}]
["2.2","UTP Labelling ","Each",{"v":0,"d":"0%"},122,0,0,0]
["2.3","Electrical Normal Power Point complete. ","Each",{"v":0,"d":"0%"},30,0,0,0]
["2.4","Electrical 2 Pin 5 A Power outlet ","Each",{"v":0,"d":"0%"},10,0,0,0]
["2.5","Power Plugs Testing, Fixing and Labelling ","Each",{"v":0,"d":"0%"},80,0,0,0]
["2.6","Cabinet Cleaning, mounting existing switches, modems and Cable tying ","Per Hour",{"v":0,"d":"0%"},1,0,0,0]
["2.7","Testing and/or Replacement of 2U Electrical Surge & Lighting Protection / Complete System for One V11/X.21 Interface / Unit Includes Equipment AC Power Surge Protector (Phase 3), AC Feed Power Trip-Switch & 15A Feed Socket for Cabinet, Optical Isolation Barrier & Surge Protection on V ","Per Hour",{"v":0,"d":"0%"},1,0,0,0]
["2.8","Supply and installation of 4000VA UPS or Repair 230 APC Smart-UPS XL 2200VA RM 3U 230V ","Each",{"v":0,"d":"0%"},1,0,0,0]
["2.9","Testing, Repair and /or replacement of cabinet Fan and cabinet power plugs","Per Hour",{"v":0,"d":"0%"},1,0,0,0]
[3,"DOCUMENTATION",{"$nulls":4},{"$f":"SUBTOTAL(9, G41:G44)","v":0},{"$f":"SUBTOTAL(9, H41:H44)","v":0}]
["3.1","UTP Test Results (ALL LAN POINTS)","Each",{"v":0,"d":"0%"},1,0,{"$f":"E41*F41","v":0},0]
["3.2","Manufacturer Data Point Certification ","Each",{"v":0,"d":"0%"},1,0,0,0]
["3.3","COC - Electrical Certification ","Each",{"v":0,"d":"0%"},1,0,0,0]
["3.4","Schematic Layout Of Network (4 PRINTOUTS)","Each",{"v":0,"d":"0%"},4,0,0,0]
[null,"TOTAL BID PRICE  (EXCL VAT)",{"$nulls":4},{"$f":"SUBTOTAL(9,G20:G44)","v":0},{"$f":"SUBTOTAL(9,H20:H44)","v":0}]
[null,"VAT (@15%)",{"$nulls":4},{"$f":"G45*0.15","v":0}]
[null,"TOTAL  BID PRICE (INCL VAT)",{"$nulls":4},{"$f":"G45+G46","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":"Vhembe","index":20,"n_rows":57,"n_cols":10,"rows_kept":57,"merged":[[12,2,12,3],[13,2,13,3],[13,5,15,5],[14,2,14,3],[15,2,15,3],[17,4,17,6],[53,1,56,1],[53,2,53,3],[53,4,53,5],[54,2,54,3],[55,2,55,3],[55,4,55,5],[56,2,56,3],[56,4,56,5]]}
[null,"SUPPLY CHAIN MANAGEMENT"]
[null,"Pricing schedule"]
["RFx No"]
["RFx Title","Supply, Install, and Configure Network Solution of Twenty Libraries for the Limpopo Department of Sports, Arts and Culture - Vhembe Library"]
["Bidder Name "]
[]
["1. INSTRUCTION FOR COMPLETING THE PRICING SCHEDULE"]
["(a)  THIS PRICING SCHEDULE MUST BE SUBMITTED SEPARATELY FROM THE TECHNICAL RESPONSE, failing which the BID may be DISQUALIFIED."]
["(b)  Bidder must complete/enter YELLOW cells only"]
["(c)  Unit and Line prices must be VAT EXCLUSIVE and in South African Rand (ZAR) currency."]
["(e) 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"]
["(f)  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,"New Installations",{"$nulls":4},{"$f":"SUBTOTAL(9,G21:G33)","v":0},{"$f":"SUBTOTAL(9,H21:H33)","v":0}]
["1.1","New insulation-displacement connector UTP CAT6e Data Point complete with flylead and patch lead ","Each",{"v":0,"d":"0%"},10,0,{"$f":"E21*F21","v":0},{"$f":"D21*G21","v":0}]
["1.2","New 45deg ADAPTER PLATE for COMPACT ","Each",{"v":0,"d":"0%"},10,0,{"$f":"E22*F22","v":0},{"$f":"D22*G22","v":0}]
["1.3","New RJ 45 WHITE SHUTTER CAT 6 ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.4","New TRUNKING FRAME 50 X 50 ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.5","New Electrical Dedicated Power Point complete, excl CB ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.6","New 15a Dedicated Plug top ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.7","New Wire, Electrical, Surfex, 2.5 Mm2 p/meter","Each",{"v":0,"d":"0%"},100,0,0,0]
["1.8","New Electrical Normal Power Point complete ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.9","15a Standard Plug top ","Each",{"v":0,"d":"0%"},10,0,0,0]
["1.10","Power Skirting (2,4m / 3,0m length)","Per Metre",{"v":0,"d":"0%"},12,0,0,0]
["1.11","INSULATION-DISPLACEMENT CONNECTOR 24 PORT KM8 CAT 6e LOADED ","Each",{"v":0,"d":"0%"},1,0,{"$f":"E31*F31","v":0},{"$f":"D31*G31","v":0}]
["1.12","Brush Panel","Each",{"v":0,"d":"0%"},2,0,{"$f":"E32*F32","v":0},{"$f":"D32*G32","v":0}]
["1.13","New 25 X 50 BLANK ","Each",{"v":0,"d":"0%"},10,0,0,0]
[2,"Existing Cabling to be Maintained",{"$nulls":4},{"$f":"SUBTOTAL(9, G35:G43)","v":0},{"$f":"SUBTOTAL(9, H35:H43)","v":0}]
["2.1","UTP Testing, Fixing and Labelling ","Each",{"v":0,"d":"0%"},26,0,0,0]
["2.2","UTP Labelling ","Each",null,72,0,0,0]
["2.3","Convert Red Power Plugs to Normal Power Plugs ","Each",null,25,0,0,0]
["2.4","Power Plugs Testing and fixing ","Each",null,58,0,0,0]
["2.5","Test/Repair/Replace Cooling 18000 BTU air-conditioner including installation ","Per Hour",{"v":0,"d":"0%"},3,0,0,0]
["2.6","Cabinet Cleaning and Cable tying ","Per Hour",{"v":0,"d":"0%"},1,0,0,0]
["2.7","Testing and repair/or Replacement of 2U Electrical Surge & Lighting Protection / Complete System for One V11/X.21 Interface / Unit Includes Equipment AC Power Surge Protector (Phase 3), AC Feed Power Trip-Switch & 15A Feed Socket for Cabinet, Optical Isolation Barrier & Surge Protection on V","Per Hour",{"v":0,"d":"0%"},1,0,0,0]
["2.8","Testing and repair/or replacement of 230 APC Smart-UPS XL 2200VA RM 3U 230V ","Per Hour",{"v":0,"d":"0%"},1,0,0,0]
["2.9","Electrical 2 Pin 5 A Power outlet. ","Each",{"v":0,"d":"0%"},15,0,0,0]
[3,"DOCUMENTATION",{"$nulls":4},{"$f":"SUBTOTAL(9, G45:G48)","v":0},{"$f":"SUBTOTAL(9, H45:H48)","v":0}]
["3.1","Test Data Point","Each",{"v":0,"d":"0%"},1,0,{"$f":"E45*F45","v":0},0]
["3.2","UTP Labelling","Each",{"v":0,"d":"0%"},1,0,0,0]
["3.3","Power Labelling","Each",{"v":0,"d":"0%"},1,0,0,0]
["3.4","Schematic Layout Of Network (3 PRINTOUTS)","Each",{"v":0,"d":"0%"},4,0,0,0]
[null,"TOTAL BID PRICE  (EXCL VAT)",{"$nulls":4},{"$f":"SUBTOTAL(9,G20:G48)","v":0},{"$f":"SUBTOTAL(9,H20:H48)","v":0}]
[null,"VAT (@15%)",{"$nulls":4},{"$f":"G49*0.15","v":0}]
[null,"TOTAL  BID PRICE (INCL VAT)",{"$nulls":4},{"$f":"G49+G50","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"]