{"text_format":"3","workbook":"xlsx","n_sheets":28,"sheets":["Instructions","G1 SUMMARY","G2 FACT","G3 FAPE","G4 FAGG","G5 FAEL","G6 FAUT","G7 FALE","G8 FAPM","G9 FAVG","G10 FARB","G11 FABL","G12 FAKM","G13 FAUP","G14 ATA","G15 FAOR","G16 FALA","G17 FAWB","G18 FAGM","G19 FAPN","G20 FAPP","G21 FAKN","G22 FAMM","G23 FAGC","G24 SPECIAL EVENTS","G25 SPARES","G26_1 Support Contract","G26_2 Support Contract-Inflated"],"not_rendered":{"external_links":1,"defined_names":20},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":39,"n_cols":4,"rows_kept":39,"merged":[[2,3,2,4],[3,3,3,4],[4,3,4,4],[5,3,5,4],[6,3,6,4],[9,2,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[16,3,16,4],[20,3,20,4],[24,3,24,4],[33,3,33,4],[34,3,34,4],[35,3,35,4]]}
[]
[]
[null,null,"BIDDER :","Bidder Company name"]
[null,null,"Project Name","Portable VHF Radios"]
[null,null,"Foreign Currency:","FC"]
[null,null,"ROE: 1R=",0.1]
[null,null,"Date:","Insert Date"]
[]
[]
[null,null,"This file contains the following sheets:"]
[null,null,"G1 SUMMARY","Summary of all sheets."]
[null,null,"FACT","CAPE TOWN INTERNATIONAL AIRPORT "]
[null,null,"FAPE","PORT ELIZABETH INTERNATIONAL AIRPORT "]
[null,null,"FAGG","GEORGE AIRPORT "]
[null,null,"FAEL","EAST LONDON AIRPORT "]
[null,null,"FAUT","MTHATHA AIRPORT "]
[null,null,"FALE ","KING SHAKA INTERNATIONAL AIRPORT "]
[null,null,"FAPM","PIETMARITZBURG AIRPORT "]
[null,null,"FAVG","VIRGINIA AIRPORT "]
[null,null,"FARB","RICHARDS BAY AIRPORT "]
[null,null,"FABL","BRAM FISCHER INTERNATIONAL AIRPORT "]
[null,null,"FAKM","KIMBERLEY AIRPORT "]
[null,null,"FAUP","UPINGTON INTERNATIONAL AIRPORT "]
[null,null,"ATA","AVIATION TRAINING ACADEMY"]
[null,null,"FAOR ","OR  TAMBO INTERNATIONAL AIRPORT "]
[null,null,"FALA","LANSERIA INTERNATIONAL AIRPORT "]
[null,null,"FAWB","WONDERBOOM NATIONAL AIRPORT "]
[null,null,"FAGM ","RAND AIRPORT "]
[null,null,"FAPN","PILANESBURG INTERNATIONAL AIRPORT "]
[null,null,"FAPP ","POLOKWANE INTERNATIONAL AIRPORT "]
[null,null,"FAKN ","KRUGER MPUMALANGA INTERNATIONAL AIRPORT "]
[null,null,"FAMM ","MAHIKENG AIRPORT "]
[null,null,"SPARES","SPARES LIST"]
[null,null,"Support contract","Ad hoc support contract"]
[null,null,"Support contract with inflation","Ad hoc support contract with inflation"]
[]
[]
[]
[null,null,"All quoted prices shall include Value Added Tax (VAT)"]

{"sheet":"G1 SUMMARY","index":1,"n_rows":46,"n_cols":12,"rows_kept":46,"merged":[[0,0,0,1],[1,0,1,1],[2,0,2,1],[2,2,2,7],[3,0,3,1],[3,2,3,7],[4,0,4,1],[4,2,4,7],[5,0,5,1],[5,2,5,7],[6,0,6,1],[6,2,6,7],[7,0,7,1],[7,2,7,7],[9,2,10,7],[9,8,10,10],[9,11,10,11],[11,0,14,0],[11,1,14,1],[11,2,14,2],[11,4,14,4],[11,5,14,5],[11,6,14,6],[11,7,14,7],[11,9,14,9],[11,10,14,10],[11,11,14,11]]}
["BID PRICE SCHEDULE: APPENDIX G1"]
["(INCLUDING VALUE ADDED TAX)"]
["BIDDER :",null,{"$f":"Instructions!D3","v":"Bidder Company name"}]
["DESCRIPTION :",null,{"$f":"Instructions!D4","v":"Portable VHF Radios"}]
["Item Nr:",null,"G1"]
["Item Description:",null,"SUMMARY"]
["Foreign Currancy",null,{"$f":"Instructions!D5","v":"FC"}]
["ROE: 1R =",null,{"$f":"Instructions!D6","v":0.1}]
[]
[null,null,"Overseas Items",{"$nulls":5},"Local Items"]
[]
["Schedule Item Number","Description","Foreign Currency","Quantity","Foreign Amount Unit Cost","Foreign Amount  Total Cost","ROE: 1R = …","Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[]
[]
[null,"RADIO EQUIPMENT PER SITE "]
[]
[1,"CAPE INTERNATIONAL AIRPORT (FACT)",null,null,{"$f":"'G2 FACT'!E43","v":0},{"$f":"'G2 FACT'!F43","v":0},null,{"$f":"'G2 FACT'!H43","v":0},null,{"$f":"'G2 FACT'!J43","v":0},{"$f":"'G2 FACT'!K43","v":0},{"$f":"'G2 FACT'!L43","v":0}]
[2,"PORT ELIZABETH INTERNATION ATION AIRPORT (FAPE)",null,null,{"$f":"'G3 FAPE'!E43","v":0},{"$f":"'G3 FAPE'!F43","v":0},null,{"$f":"'G3 FAPE'!H43","v":0},null,{"$f":"'G3 FAPE'!J43","v":0},{"$f":"'G3 FAPE'!K43","v":0},{"$f":"'G3 FAPE'!L43","v":0}]
[3,"GEORGE AIRPORT (FAGG)",null,null,{"$f":"'G4 FAGG'!E42","v":0},{"$f":"'G4 FAGG'!F42","v":0},null,{"$f":"'G4 FAGG'!H42","v":0},null,{"$f":"'G4 FAGG'!J42","v":0},{"$f":"'G4 FAGG'!K42","v":0},{"$f":"'G4 FAGG'!L42","v":0}]
[4,"EAST LONDON  AIPRORT (FAEL)",null,null,{"$f":"'G5 FAEL'!E43","v":0},{"$f":"'G5 FAEL'!F43","v":0},null,{"$f":"'G5 FAEL'!H43","v":0},null,{"$f":"'G5 FAEL'!J43","v":0},{"$f":"'G5 FAEL'!K43","v":0},{"$f":"'G5 FAEL'!L43","v":0}]
[5,"MTHATHA AIRPORT (FAUT) ",null,null,{"$f":"'G6 FAUT'!E39","v":0},{"$f":"'G6 FAUT'!F39","v":0},null,{"$f":"'G6 FAUT'!H39","v":0},null,{"$f":"'G6 FAUT'!J39","v":0},{"$f":"'G6 FAUT'!K39","v":0},{"$f":"'G6 FAUT'!L39","v":0}]
[6,"KING SHAKA INTERNATATIONAL AIRPORT (FALE)",null,null,{"$f":"'G7 FALE'!E43","v":0},{"$f":"'G7 FALE'!F43","v":0},null,{"$f":"'G7 FALE'!H43","v":0},null,{"$f":"'G7 FALE'!J43","v":0},{"$f":"'G7 FALE'!K43","v":0},{"$f":"'G7 FALE'!L43","v":0}]
[7,"PIETMARITZBURG AIRPORT (FAPM)",null,null,{"$f":"'G8 FAPM'!E39","v":0},{"$f":"'G8 FAPM'!F39","v":0},null,{"$f":"'G8 FAPM'!H39","v":0},null,{"$f":"'G8 FAPM'!J39","v":0},{"$f":"'G8 FAPM'!K39","v":0},{"$f":"'G8 FAPM'!L39","v":0}]
[8,"VIRGINIA AIRPORT  (FAVG)",null,null,{"$f":"'G9 FAVG'!E39","v":0},{"$f":"'G9 FAVG'!F39","v":0},null,{"$f":"'G9 FAVG'!H39","v":0},null,{"$f":"'G9 FAVG'!J39","v":0},{"$f":"'G9 FAVG'!K39","v":0},{"$f":"'G9 FAVG'!L39","v":0}]
[9,"RICHARDSBAY AIRPORT (FARB)",null,null,{"$f":"'G10 FARB'!E39","v":0},{"$f":"'G10 FARB'!F39","v":0},null,{"$f":"'G10 FARB'!H39","v":0},null,{"$f":"'G10 FARB'!J39","v":0},{"$f":"'G10 FARB'!K39","v":0},{"$f":"'G10 FARB'!L39","v":0}]
[10,"BRAM FISCHER INTERNATIONAL AIRPORT (FABL)",null,null,{"$f":"'G11 FABL'!E43","v":0},{"$f":"'G11 FABL'!F43","v":0},null,{"$f":"'G11 FABL'!H43","v":0},null,{"$f":"'G11 FABL'!J43","v":0},{"$f":"'G11 FABL'!K43","v":0},{"$f":"'G11 FABL'!L43","v":0}]
[11,"KIMBERLEY AIRPORT  (FAKM)",null,null,{"$f":"'G12 FAKM'!E39","v":0},{"$f":"'G12 FAKM'!F39","v":0},null,{"$f":"'G12 FAKM'!H39","v":0},null,{"$f":"'G12 FAKM'!J39","v":0},{"$f":"'G12 FAKM'!K39","v":0},{"$f":"'G12 FAKM'!L39","v":0}]
[12,"UPINGTON INTERNATIONAL AIRPORT (FAUP)",null,null,{"$f":"'G13 FAUP'!E43","v":0},{"$f":"'G13 FAUP'!F43","v":0},null,{"$f":"'G13 FAUP'!H43","v":0},null,{"$f":"'G13 FAUP'!J43","v":0},{"$f":"'G13 FAUP'!K43","v":0},{"$f":"'G13 FAUP'!L43","v":0}]
[13,"AVIATION TRAINING ACADEMY",null,null,{"$f":"'G14 ATA'!E40","v":0},{"$f":"'G14 ATA'!F40","v":0},null,{"$f":"'G14 ATA'!H40","v":0},null,{"$f":"'G14 ATA'!J40","v":0},{"$f":"'G14 ATA'!K40","v":0},{"$f":"'G14 ATA'!L40","v":0}]
[14,"OR TAMBO INTERNATIONAL AIRPORT (FAOR)",null,null,{"$f":"'G15 FAOR'!E42","v":0},{"$f":"'G15 FAOR'!F42","v":0},null,{"$f":"'G15 FAOR'!H42","v":0},null,{"$f":"'G15 FAOR'!J42","v":0},{"$f":"'G15 FAOR'!K42","v":0},{"$f":"'G15 FAOR'!L42","v":0}]
[15,"LANSERIA INTERNATIONAL AIRPORT (FALA)",null,null,{"$f":"'G16 FALA'!E39","v":0},{"$f":"'G16 FALA'!F39","v":0},null,{"$f":"'G16 FALA'!H39","v":0},null,{"$f":"'G16 FALA'!J39","v":0},{"$f":"'G16 FALA'!K39","v":0},{"$f":"'G16 FALA'!L39","v":0}]
[16,"WONDERBOOM NATIONAL AIRPORT (FAWB)",null,null,{"$f":"'G17 FAWB'!E39","v":0},{"$f":"'G17 FAWB'!F39","v":0},null,{"$f":"'G17 FAWB'!H39","v":0},null,{"$f":"'G17 FAWB'!J39","v":0},{"$f":"'G17 FAWB'!K39","v":0},{"$f":"'G17 FAWB'!L39","v":0}]
[17,"RAND AIRPORT (FAGM)",null,null,{"$f":"'G18 FAGM'!E39","v":0},{"$f":"'G18 FAGM'!F39","v":0},null,{"$f":"'G18 FAGM'!H39","v":0},null,{"$f":"'G18 FAGM'!J39","v":0},{"$f":"'G18 FAGM'!K39","v":0},{"$f":"'G18 FAGM'!L39","v":0}]
[18,"PILANESBURG INTERNATIONAL AIRPORT (FAPN)",null,null,{"$f":"'G19 FAPN'!E39","v":0},{"$f":"'G19 FAPN'!F39","v":0},null,{"$f":"'G19 FAPN'!H39","v":0},null,{"$f":"'G19 FAPN'!J39","v":0},{"$f":"'G19 FAPN'!K39","v":0},{"$f":"'G19 FAPN'!L39","v":0}]
[19,"POLOKWANE INTERNATIONAL AIRPORT (FAPP)",null,null,{"$f":"'G20 FAPP'!E39","v":0},{"$f":"'G20 FAPP'!F39","v":0},null,{"$f":"'G20 FAPP'!H39","v":0},null,{"$f":"'G20 FAPP'!J39","v":0},{"$f":"'G20 FAPP'!K39","v":0},{"$f":"'G20 FAPP'!L39","v":0}]
[20,"KRUGER MPUMALANGA INTERNATIONAL AIRPORT (FAKN)",null,null,{"$f":"'G21 FAKN'!E39","v":0},{"$f":"'G21 FAKN'!F39","v":0},null,{"$f":"'G21 FAKN'!H39","v":0},null,{"$f":"'G21 FAKN'!J39","v":0},{"$f":"'G21 FAKN'!K39","v":0},{"$f":"'G21 FAKN'!L39","v":0}]
[21,"MAHIKENG AIRPORT (FAMM) ",null,null,{"$f":"'G22 FAMM'!E39","v":0},{"$f":"'G22 FAMM'!F39","v":0},null,{"$f":"'G22 FAMM'!H39","v":0},null,{"$f":"'G22 FAMM'!J39","v":0},{"$f":"'G22 FAMM'!K39","v":0},{"$f":"'G22 FAMM'!L39","v":0}]
[22,"GRAND CENTRAL AIRPORT (FAGC)",null,null,{"$f":"'G23 FAGC'!E39","v":0},{"$f":"'G23 FAGC'!F39","v":0},null,{"$f":"'G23 FAGC'!H39","v":0},null,{"$f":"'G23 FAGC'!J39","v":0},{"$f":"'G23 FAGC'!K39","v":0},{"$f":"'G23 FAGC'!L39","v":0}]
[23,"SPECIAL EVENTS",null,null,{"$f":"'G24 SPECIAL EVENTS'!E39","v":0},{"$f":"'G24 SPECIAL EVENTS'!F39","v":0},null,{"$f":"'G24 SPECIAL EVENTS'!H39","v":0},null,{"$f":"'G24 SPECIAL EVENTS'!J39","v":0},{"$f":"'G24 SPECIAL EVENTS'!K39","v":0},{"$f":"'G24 SPECIAL EVENTS'!L39","v":0}]
[24,"SPARES",null,null,{"$f":"'G25 SPARES'!E34","v":0},{"$f":"'G25 SPARES'!F34","v":0},null,{"$f":"'G25 SPARES'!H34","v":0},null,{"$f":"'G25 SPARES'!J34","v":0},{"$f":"'G25 SPARES'!K34","v":0},{"$f":"'G25 SPARES'!L34","v":0}]
[25,"Ad hoc support contract",null,null,{"$f":"'G26_2 Support Contract-Inflated'!E30","v":0},{"$f":"'G26_2 Support Contract-Inflated'!F30","v":0},null,{"$f":"'G26_2 Support Contract-Inflated'!H30","v":0},null,{"$f":"'G26_2 Support Contract-Inflated'!J30","v":0},{"$f":"'G26_2 Support Contract-Inflated'!K30","v":0},{"$f":"'G26_2 Support Contract-Inflated'!L30","v":0}]
[]
[]
[null,"GRAND TOTAL :",null,null,{"$f":"SUM(E19:E42)","v":0},{"$f":"SUM(F19:F42)","v":0},null,{"$f":"SUM(H19:H42)","v":0},{"$f":"SUM(I19:I42)","v":0},{"$f":"SUM(J19:J42)","v":0},{"$f":"SUM(K19:K42)","v":0},{"$f":"SUM(L19:L42)","v":0}]

{"sheet":"G2 FACT","index":2,"n_rows":43,"n_cols":12,"rows_kept":43,"merged":[[0,0,0,1],[1,0,1,1],[9,2,10,7],[9,8,10,10],[11,0,13,0],[11,1,13,1],[11,2,13,2],[11,4,13,4],[11,5,13,5],[11,6,13,6],[11,7,13,7],[11,9,13,9],[11,10,13,10],[11,11,13,11]]}
["BID PRICE SCHEDULE: APPENDIX G2"]
["(INCLUDING VALUE ADDED TAX)"]
["BIDDER:",{"$f":"Instructions!D3","v":"Bidder Company name"}]
["PROJECT:",{"$f":"Instructions!D4","v":"Portable VHF Radios"}]
["Item Nr:","G2"]
["SUB-PROJECT:","CAPE TOWN INTERNATIONAL AIRPORT "]
["Foreign Currancy","FC"]
["ROE: 1R =",{"$f":"0.1","v":0.1}]
[]
[null,null,"Overseas Items",{"$nulls":5},"Local Items"]
[]
["Schedule Item Number","Description","Foreign Currency","Quantity","Foreign Amount Unit Cost","Foreign Amount  Total Cost","ROE: 1R = …","Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[]
["G2","RADIO EQUIPMENT"]
["G2.1"]
[null,"VHF Transceivers/Radios ",{"$f":"$B$7","v":"FC"},7,null,{"$f":"D18*E18","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G18<>0,F18/G18,0)","v":0},null,null,{"$f":"I18*J18","v":0},{"$f":"K18+H18","v":0}]
[null,"Antennas","FC",7,null,{"$f":"D19*E19","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G19<>0,F19/G19,0)","v":0},null,null,{"$f":"I19*J19","v":0},{"$f":"K19+H19","v":0}]
[null,"Microphones  ","FC",7,null,{"$f":"D20*E20","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G20<>0,F20/G20,0)","v":0},null,null,{"$f":"I20*J20","v":0},{"$f":"K20+H20","v":0}]
[null,"Batteries and Battery Charger ","FC",7,null,{"$f":"D21*E21","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G21<>0,F21/G21,0)","v":0},null,null,{"$f":"I21*J21","v":0},{"$f":"K21+H21","v":0}]
[null,"Radio Case (Including handles and car mounting kit)","FC",7,null,{"$f":"D22*E22","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G22<>0,F22/G22,0)","v":0},null,null,{"$f":"I22*J22","v":0},{"$f":"K22+H22","v":0}]
["G3","DELIVERY"]
["G.3.1"]
[null,"Delivery of equipment for FACT (7 Radios)",{"$f":"$B$7","v":"FC"},1,null,null,{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G25<>0,F25/G25,0)","v":0},null,null,{"$f":"I25*J25","v":0},{"$f":"H25+K110","v":0}]
[]
["G4","MISCELLANEOUS"]
[null,"Manuals",{"$f":"$B$7","v":"FC"},2,null,{"$f":"D28*E28","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"SITE TOTAL :",null,null,{"$f":"SUM(E15:E32)","v":0},{"$f":"SUM(F15:F32)","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"SUM(H15:H32)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(J15:J32)","v":0},{"$f":"SUM(K15:K32)","v":0},{"$f":"SUM(L15:L32)","v":0}]
[]
["G5","Options"]
["G5.1",null,{"$f":"$B$7","v":"FC"},null,null,{"$f":"D36*E36","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G36<>0,F36/G36,0)","v":0},null,null,{"$f":"I36*J36","v":0},{"$f":"K36+H36","v":0}]
["G5.2",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,{"$f":"K37+H37","v":0}]
["G5.3",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.4",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.5",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.6",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"GRAND TOTAL :",null,null,{"$f":"SUM(E34:E42)+E33","v":0},{"$f":"SUM(F34:F42)+F33","v":0},null,{"v":0,"d":"0.00"},null,0,0,0]

{"sheet":"G3 FAPE","index":3,"n_rows":43,"n_cols":12,"rows_kept":43,"merged":[[0,0,0,1],[1,0,1,1],[9,2,10,7],[9,8,10,10],[11,0,13,0],[11,1,13,1],[11,2,13,2],[11,4,13,4],[11,5,13,5],[11,6,13,6],[11,7,13,7],[11,9,13,9],[11,10,13,10],[11,11,13,11]]}
["BID PRICE SCHEDULE: APPENDIX G3"]
["(INCLUDING VALUE ADDED TAX)"]
["BIDDER:",{"$f":"Instructions!D3","v":"Bidder Company name"}]
["PROJECT:",{"$f":"Instructions!D4","v":"Portable VHF Radios"}]
["Item Nr:","G3"]
["SUB-PROJECT:","PORT ELIZABETH INTERNATIONAL AIRPORT "]
["Foreign Currancy",{"$f":"'[1]Tenderer Info'!D4","v":"FC"}]
["ROE: 1R =",{"$f":"0.1","v":0.1}]
[]
[null,null,"Overseas Items",{"$nulls":5},"Local Items"]
[]
["Schedule Item Number","Description","Foreign Currency","Quantity","Foreign Amount Unit Cost","Foreign Amount  Total Cost","ROE: 1R = …","Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[]
["G2","RADIO EQUIPMENT"]
["G2.1"]
[null,"VHF Transceivers/Radios ",{"$f":"$B$7","v":"FC"},11,null,{"$f":"D18*E18","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G18<>0,F18/G18,0)","v":0},null,null,{"$f":"I18*J18","v":0},{"$f":"K18+H18","v":0}]
[null,"Antennas","FC",11,null,{"$f":"D19*E19","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G19<>0,F19/G19,0)","v":0},null,null,{"$f":"I19*J19","v":0},{"$f":"K19+H19","v":0}]
[null,"Microphones  ","FC",11,null,{"$f":"D20*E20","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G20<>0,F20/G20,0)","v":0},null,null,{"$f":"I20*J20","v":0},{"$f":"K20+H20","v":0}]
[null,"Batteries and Battery Charger ","FC",11,null,{"$f":"D21*E21","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G21<>0,F21/G21,0)","v":0},null,null,{"$f":"I21*J21","v":0},{"$f":"K21+H21","v":0}]
[null,"Radio Case (Including handles and car mounting kit)","FC",11,null,{"$f":"D22*E22","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G22<>0,F22/G22,0)","v":0},null,null,{"$f":"I22*J22","v":0},{"$f":"K22+H22","v":0}]
[null,"Mobile-vehicle antennas","FC",5,null,{"$f":"D23*E23","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G23<>0,F23/G23,0)","v":0},null,null,{"$f":"I23*J23","v":0},{"$f":"K23+H23","v":0}]
["G3","DELIVERY"]
["G.3.1"]
[null,"Delivery of equipment for FAPE (11 Radios)",{"$f":"$B$7","v":"FC"},1,null,null,{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G26<>0,F26/G26,0)","v":0},null,null,{"$f":"I26*J26","v":0},{"$f":"H26+K110","v":0}]
["G4","MISCELLANEOUS"]
[null,"Manuals",{"$f":"$B$7","v":"FC"},2,null,{"$f":"D28*E28","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"SITE TOTAL :",null,null,{"$f":"SUM(E15:E32)","v":0},{"$f":"SUM(F15:F32)","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"SUM(H15:H32)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(J15:J32)","v":0},{"$f":"SUM(K15:K32)","v":0},{"$f":"SUM(L15:L32)","v":0}]
[]
["G5","Options"]
["G5.1",null,{"$f":"$B$7","v":"FC"},null,null,{"$f":"D36*E36","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G36<>0,F36/G36,0)","v":0},null,null,{"$f":"I36*J36","v":0},{"$f":"K36+H36","v":0}]
["G5.2",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,{"$f":"K37+H37","v":0}]
["G5.3",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.4",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.5",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.6",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"GRAND TOTAL :",null,null,{"$f":"SUM(E34:E42)+E33","v":0},{"$f":"SUM(F34:F42)+F33","v":0},null,{"v":0,"d":"0.00"},null,0,0,0]

{"sheet":"G4 FAGG","index":4,"n_rows":42,"n_cols":12,"rows_kept":42,"merged":[[0,0,0,1],[1,0,1,1],[9,2,10,7],[9,8,10,10],[11,0,13,0],[11,1,13,1],[11,2,13,2],[11,4,13,4],[11,5,13,5],[11,6,13,6],[11,7,13,7],[11,9,13,9],[11,10,13,10],[11,11,13,11]]}
["BID PRICE SCHEDULE: APPENDIX G4"]
["(INCLUDING VALUE ADDED TAX)"]
["BIDDER :",{"$f":"Instructions!D3","v":"Bidder Company name"}]
["PROJECT:",{"$f":"Instructions!D4","v":"Portable VHF Radios"}]
["Item Nr:","G4"]
["SUB-PROJECT:","GEORGE  AIRPORT "]
["Foreign Currancy",{"$f":"'[1]Tenderer Info'!D4","v":"FC"}]
["ROE: 1R =",{"$f":"0.1","v":0.1}]
[]
[null,null,"Overseas Items",{"$nulls":5},"Local Items"]
[]
["Schedule Item Number","Description","Foreign Currency","Quantity","Foreign Amount Unit Cost","Foreign Amount  Total Cost","ROE: 1R = …","Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[]
["G2","RADIO EQUIPMENT"]
["G2.1"]
[null,"VHF Transceivers/Radios ",{"$f":"$B$7","v":"FC"},3,null,{"$f":"D18*E18","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G18<>0,F18/G18,0)","v":0},null,null,{"$f":"I18*J18","v":0},{"$f":"K18+H18","v":0}]
[null,"Antennas","FC",3,null,{"$f":"D19*E19","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G19<>0,F19/G19,0)","v":0},null,null,{"$f":"I19*J19","v":0},{"$f":"K19+H19","v":0}]
[null,"Microphones  ","FC",3,null,{"$f":"D20*E20","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G20<>0,F20/G20,0)","v":0},null,null,{"$f":"I20*J20","v":0},{"$f":"K20+H20","v":0}]
[null,"Batteries and Battery Charger ","FC",3,null,{"$f":"D21*E21","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G21<>0,F21/G21,0)","v":0},null,null,{"$f":"I21*J21","v":0},{"$f":"K21+H21","v":0}]
[null,"Radio Case (Including handles and car mounting kit)","FC",3,null,{"$f":"D22*E22","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G22<>0,F22/G22,0)","v":0},null,null,{"$f":"I22*J22","v":0},{"$f":"K22+H22","v":0}]
["G3","DELIVERY"]
["G.3.1"]
[null,"Delivery of equipment for FAGG (3 Radios)",{"$f":"$B$7","v":"FC"},1,null,null,{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G25<>0,F25/G25,0)","v":0},null,null,{"$f":"I25*J25","v":0},{"$f":"H25+K109","v":0}]
["G4","MISCELLANEOUS"]
[null,"Manuals",{"$f":"$B$7","v":"FC"},2,null,{"$f":"D27*E27","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"SITE TOTAL :",null,null,{"$f":"SUM(E15:E31)","v":0},{"$f":"SUM(F15:F31)","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"SUM(H15:H31)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(J15:J31)","v":0},{"$f":"SUM(K15:K31)","v":0},{"$f":"SUM(L15:L31)","v":0}]
[]
["G5","Options"]
["G5.1",null,{"$f":"$B$7","v":"FC"},null,null,{"$f":"D35*E35","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G35<>0,F35/G35,0)","v":0},null,null,{"$f":"I35*J35","v":0},{"$f":"K35+H35","v":0}]
["G5.2",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,{"$f":"K36+H36","v":0}]
["G5.3",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.4",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.5",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.6",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"GRAND TOTAL :",null,null,{"$f":"SUM(E33:E41)+E32","v":0},{"$f":"SUM(F33:F41)+F32","v":0},null,{"v":0,"d":"0.00"},null,0,0,0]

{"sheet":"G5 FAEL","index":5,"n_rows":43,"n_cols":12,"rows_kept":43,"merged":[[0,0,0,1],[1,0,1,1],[9,2,10,7],[9,8,10,10],[11,0,13,0],[11,1,13,1],[11,2,13,2],[11,4,13,4],[11,5,13,5],[11,6,13,6],[11,7,13,7],[11,9,13,9],[11,10,13,10],[11,11,13,11]]}
["BID PRICE SCHEDULE: APPENDIX G5"]
["(INCLUDING VALUE ADDED TAX)"]
["BIDDER:",{"$f":"Instructions!D3","v":"Bidder Company name"}]
["PROJECT:",{"$f":"Instructions!D4","v":"Portable VHF Radios"}]
["Item Nr:","G5"]
["SUB-PROJECT:","EAST LONDON  AIRPORT "]
["Foreign Currancy",{"$f":"'[1]Tenderer Info'!D4","v":"FC"}]
["ROE: 1R =",{"$f":"0.1","v":0.1}]
[]
[null,null,"Overseas Items",{"$nulls":5},"Local Items"]
[]
["Schedule Item Number","Description","Foreign Currency","Quantity","Foreign Amount Unit Cost","Foreign Amount  Total Cost","ROE: 1R = …","Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[]
["G2","RADIO EQUIPMENT"]
["G2.1"]
[null,"VHF Transceivers/Radios ",{"$f":"$B$7","v":"FC"},8,null,{"$f":"D18*E18","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G18<>0,F18/G18,0)","v":0},null,null,{"$f":"I18*J18","v":0},{"$f":"K18+H18","v":0}]
[null,"Antennas","FC",8,null,{"$f":"D19*E19","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G19<>0,F19/G19,0)","v":0},null,null,{"$f":"I19*J19","v":0},{"$f":"K19+H19","v":0}]
[null,"Microphones  ","FC",8,null,{"$f":"D20*E20","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G20<>0,F20/G20,0)","v":0},null,null,{"$f":"I20*J20","v":0},{"$f":"K20+H20","v":0}]
[null,"Batteries and Battery Charger ","FC",8,null,{"$f":"D21*E21","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G21<>0,F21/G21,0)","v":0},null,null,{"$f":"I21*J21","v":0},{"$f":"K21+H21","v":0}]
[null,"Radio Case (Including handles and car mounting kit)","FC",8,null,{"$f":"D22*E22","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G22<>0,F22/G22,0)","v":0},null,null,{"$f":"I22*J22","v":0},{"$f":"K22+H22","v":0}]
[null,"Mobile-vehicle antennas","FC",3,null,{"$f":"D23*E23","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G23<>0,F23/G23,0)","v":0},null,null,{"$f":"I23*J23","v":0},{"$f":"K23+H23","v":0}]
["G3","DELIVERY"]
["G.3.1"]
[null,"Delivery of equipment for FAEL, FAUT ( 9 Radios)",{"$f":"$B$7","v":"FC"},1,null,null,{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G26<>0,F26/G26,0)","v":0},null,null,{"$f":"I26*J26","v":0},{"$f":"H26+K110","v":0}]
["G4","MISCELLANEOUS"]
[null,"Manuals",{"$f":"$B$7","v":"FC"},null,null,{"$f":"D28*E28","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"SITE TOTAL :",null,null,{"$f":"SUM(E15:E32)","v":0},{"$f":"SUM(F15:F32)","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"SUM(H15:H32)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(J15:J32)","v":0},{"$f":"SUM(K15:K32)","v":0},{"$f":"SUM(L15:L32)","v":0}]
[]
["G5","Options"]
["G5.1",null,{"$f":"$B$7","v":"FC"},null,null,{"$f":"D36*E36","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G36<>0,F36/G36,0)","v":0},null,null,{"$f":"I36*J36","v":0},{"$f":"K36+H36","v":0}]
["G5.2",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,{"$f":"K37+H37","v":0}]
["G5.3",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.4",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.5",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.6",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"GRAND TOTAL :",null,null,{"$f":"SUM(E34:E42)+E33","v":0},{"$f":"SUM(F34:F42)+F33","v":0},null,{"v":0,"d":"0.00"},null,0,0,0]

{"sheet":"G6 FAUT","index":6,"n_rows":39,"n_cols":12,"rows_kept":39,"merged":[[0,0,0,1],[1,0,1,1],[9,2,10,7],[9,8,10,10],[11,0,13,0],[11,1,13,1],[11,2,13,2],[11,4,13,4],[11,5,13,5],[11,6,13,6],[11,7,13,7],[11,9,13,9],[11,10,13,10],[11,11,13,11]]}
["BID PRICE SCHEDULE: APPENDIX G6"]
["(INCLUDING VALUE ADDED TAX)"]
["BIDDER",{"$f":"Instructions!D3","v":"Bidder Company name"}]
["PROJECT:",{"$f":"Instructions!D4","v":"Portable VHF Radios"}]
["Item Nr:","G6"]
["SUB-PROJECT:","MTHATHA AIRPORT"]
["Foreign Currancy",{"$f":"'[1]Tenderer Info'!D4","v":"FC"}]
["ROE: 1R =",{"$f":"0.1","v":0.1}]
[]
[null,null,"Overseas Items",{"$nulls":5},"Local Items"]
[]
["Schedule Item Number","Description","Foreign Currency","Quantity","Foreign Amount Unit Cost","Foreign Amount  Total Cost","ROE: 1R = …","Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[]
["G2","RADIO EQUIPMENT"]
["G2.1"]
[null,"VHF Transceivers/Radios ",{"$f":"$B$7","v":"FC"},1,null,{"$f":"D18*E18","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G18<>0,F18/G18,0)","v":0},null,null,{"$f":"I18*J18","v":0},{"$f":"K18+H18","v":0}]
[null,"Antennas","FC",1,null,{"$f":"D19*E19","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G19<>0,F19/G19,0)","v":0},null,null,{"$f":"I19*J19","v":0},{"$f":"K19+H19","v":0}]
[null,"Microphones  ","FC",1,null,{"$f":"D20*E20","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G20<>0,F20/G20,0)","v":0},null,null,{"$f":"I20*J20","v":0},{"$f":"K20+H20","v":0}]
[null,"Batteries and Battery Charger ","FC",1,null,{"$f":"D21*E21","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G21<>0,F21/G21,0)","v":0},null,null,{"$f":"I21*J21","v":0},{"$f":"K21+H21","v":0}]
[null,"Radio Case (Including handles and car mounting kit)","FC",1,null,{"$f":"D22*E22","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G22<>0,F22/G22,0)","v":0},null,null,{"$f":"I22*J22","v":0},{"$f":"K22+H22","v":0}]
["G4","MISCELLANEOUS"]
[null,"Manuals",{"$f":"$B$7","v":"FC"},null,null,{"$f":"D24*E24","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"SITE TOTAL :",null,null,{"$f":"SUM(E15:E28)","v":0},{"$f":"SUM(F15:F28)","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"SUM(H15:H28)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(J15:J28)","v":0},{"$f":"SUM(K15:K28)","v":0},{"$f":"SUM(L15:L28)","v":0}]
[]
["G5","Options"]
["G5.1",null,{"$f":"$B$7","v":"FC"},null,null,{"$f":"D32*E32","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G32<>0,F32/G32,0)","v":0},null,null,{"$f":"I32*J32","v":0},{"$f":"K32+H32","v":0}]
["G5.2",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,{"$f":"K33+H33","v":0}]
["G5.3",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.4",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.5",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.6",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"GRAND TOTAL :",null,null,{"$f":"SUM(E30:E38)+E29","v":0},{"$f":"SUM(F30:F38)+F29","v":0},null,{"v":0,"d":"0.00"},null,0,0,0]

{"sheet":"G7 FALE","index":7,"n_rows":43,"n_cols":12,"rows_kept":43,"merged":[[0,0,0,1],[1,0,1,1],[9,2,10,7],[9,8,10,10],[11,0,13,0],[11,1,13,1],[11,2,13,2],[11,4,13,4],[11,5,13,5],[11,6,13,6],[11,7,13,7],[11,9,13,9],[11,10,13,10],[11,11,13,11]]}
["BID PRICE SCHEDULE: APPENDIX G7"]
["(INCLUDING VALUE ADDED TAX)"]
["BIDDER :",{"$f":"Instructions!D3","v":"Bidder Company name"}]
["PROJECT:",{"$f":"Instructions!D4","v":"Portable VHF Radios"}]
["Item Nr:","G7"]
["SUB-PROJECT:","KING SHAKA INTERNATIONAL AIRPORT "]
["Foreign Currancy",{"$f":"'[1]Tenderer Info'!D4","v":"FC"}]
["ROE: 1R =",{"$f":"0.1","v":0.1}]
[]
[null,null,"Overseas Items",{"$nulls":5},"Local Items"]
[]
["Schedule Item Number","Description","Foreign Currency","Quantity","Foreign Amount Unit Cost","Foreign Amount  Total Cost","ROE: 1R = …","Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[]
["G2","RADIO EQUIPMENT"]
["G2.1"]
[null,"VHF Transceivers/Radios ",{"$f":"$B$7","v":"FC"},11,null,{"$f":"D18*E18","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G18<>0,F18/G18,0)","v":0},null,null,{"$f":"I18*J18","v":0},{"$f":"K18+H18","v":0}]
[null,"Antennas","FC",11,null,{"$f":"D19*E19","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G19<>0,F19/G19,0)","v":0},null,null,{"$f":"I19*J19","v":0},{"$f":"K19+H19","v":0}]
[null,"Microphones  ","FC",11,null,{"$f":"D20*E20","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G20<>0,F20/G20,0)","v":0},null,null,{"$f":"I20*J20","v":0},{"$f":"K20+H20","v":0}]
[null,"Batteries and Battery Charger ","FC",11,null,{"$f":"D21*E21","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G21<>0,F21/G21,0)","v":0},null,null,{"$f":"I21*J21","v":0},{"$f":"K21+H21","v":0}]
[null,"Radio Case (Including handles and car mounting kit)","FC",11,null,{"$f":"D22*E22","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G22<>0,F22/G22,0)","v":0},null,null,{"$f":"I22*J22","v":0},{"$f":"K22+H22","v":0}]
[null,"Mobile-vehicle antennas","FC",3,null,{"$f":"D23*E23","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G23<>0,F23/G23,0)","v":0},null,null,{"$f":"I23*J23","v":0},{"$f":"K23+H23","v":0}]
["G3","DELIVERY"]
["G.3.1"]
[null,"Delivery of equipment for FALE, FAPM, FAVG, FARB (16 Radios)",{"$f":"$B$7","v":"FC"},1,null,null,{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G26<>0,F26/G26,0)","v":0},null,null,{"$f":"I26*J26","v":0},{"$f":"H26+K110","v":0}]
["G4","MISCELLANEOUS"]
[null,"Manuals",{"$f":"$B$7","v":"FC"},2,null,{"$f":"D28*E28","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"SITE TOTAL :",null,null,{"$f":"SUM(E15:E32)","v":0},{"$f":"SUM(F15:F32)","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"SUM(H15:H32)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(J15:J32)","v":0},{"$f":"SUM(K15:K32)","v":0},{"$f":"SUM(L15:L32)","v":0}]
[]
["G5","Options"]
["G5.1",null,{"$f":"$B$7","v":"FC"},null,null,{"$f":"D36*E36","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G36<>0,F36/G36,0)","v":0},null,null,{"$f":"I36*J36","v":0},{"$f":"K36+H36","v":0}]
["G5.2",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,{"$f":"K37+H37","v":0}]
["G5.3",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.4",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.5",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.6",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"GRAND TOTAL :",null,null,{"$f":"SUM(E34:E42)+E33","v":0},{"$f":"SUM(F34:F42)+F33","v":0},null,{"v":0,"d":"0.00"},null,0,0,0]

{"sheet":"G8 FAPM","index":8,"n_rows":39,"n_cols":12,"rows_kept":39,"merged":[[0,0,0,1],[1,0,1,1],[9,2,10,7],[9,8,10,10],[11,0,13,0],[11,1,13,1],[11,2,13,2],[11,4,13,4],[11,5,13,5],[11,6,13,6],[11,7,13,7],[11,9,13,9],[11,10,13,10],[11,11,13,11]]}
["BID PRICE SCHEDULE: APPENDIX G8"]
["(INCLUDING VALUE ADDED TAX)"]
["BIDDER:",{"$f":"Instructions!D3","v":"Bidder Company name"}]
["PROJECT:",{"$f":"Instructions!D4","v":"Portable VHF Radios"}]
["Item Nr:","G8"]
["SUB-PROJECT:","PIETMARITZBURG AIRPORT"]
["Foreign Currancy",{"$f":"'[1]Tenderer Info'!D4","v":"FC"}]
["ROE: 1R =",{"$f":"0.1","v":0.1}]
[]
[null,null,"Overseas Items",{"$nulls":5},"Local Items"]
[]
["Schedule Item Number","Description","Foreign Currency","Quantity","Foreign Amount Unit Cost","Foreign Amount  Total Cost","ROE: 1R = …","Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[]
["G2","RADIO EQUIPMENT"]
["G2.1"]
[null,"VHF Transceivers/Radios ",{"$f":"$B$7","v":"FC"},2,null,{"$f":"D18*E18","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G18<>0,F18/G18,0)","v":0},null,null,{"$f":"I18*J18","v":0},{"$f":"K18+H18","v":0}]
[null,"Antennas","FC",2,null,{"$f":"D19*E19","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G19<>0,F19/G19,0)","v":0},null,null,{"$f":"I19*J19","v":0},{"$f":"K19+H19","v":0}]
[null,"Microphones  ","FC",2,null,{"$f":"D20*E20","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G20<>0,F20/G20,0)","v":0},null,null,{"$f":"I20*J20","v":0},{"$f":"K20+H20","v":0}]
[null,"Batteries and Battery Charger ","FC",2,null,{"$f":"D21*E21","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G21<>0,F21/G21,0)","v":0},null,null,{"$f":"I21*J21","v":0},{"$f":"K21+H21","v":0}]
[null,"Radio Case (Including handles and car mounting kit)","FC",null,null,{"$f":"D22*E22","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G22<>0,F22/G22,0)","v":0},null,null,{"$f":"I22*J22","v":0},{"$f":"K22+H22","v":0}]
["G4","MISCELLANEOUS"]
[null,"Manuals",{"$f":"$B$7","v":"FC"},2,null,{"$f":"D24*E24","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"SITE TOTAL :",null,null,{"$f":"SUM(E15:E28)","v":0},{"$f":"SUM(F15:F28)","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"SUM(H15:H28)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(J15:J28)","v":0},{"$f":"SUM(K15:K28)","v":0},{"$f":"SUM(L15:L28)","v":0}]
[]
["G5","Options"]
["G5.1",null,{"$f":"$B$7","v":"FC"},null,null,{"$f":"D32*E32","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G32<>0,F32/G32,0)","v":0},null,null,{"$f":"I32*J32","v":0},{"$f":"K32+H32","v":0}]
["G5.2",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,{"$f":"K33+H33","v":0}]
["G5.3",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.4",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.5",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.6",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"GRAND TOTAL :",null,null,{"$f":"SUM(E30:E38)+E29","v":0},{"$f":"SUM(F30:F38)+F29","v":0},null,{"v":0,"d":"0.00"},null,0,0,0]

{"sheet":"G9 FAVG","index":9,"n_rows":39,"n_cols":12,"rows_kept":39,"merged":[[0,0,0,1],[1,0,1,1],[9,2,10,7],[9,8,10,10],[11,0,13,0],[11,1,13,1],[11,2,13,2],[11,4,13,4],[11,5,13,5],[11,6,13,6],[11,7,13,7],[11,9,13,9],[11,10,13,10],[11,11,13,11]]}
["BID PRICE SCHEDULE: APPENDIX G9"]
["(INCLUDING VALUE ADDED TAX)"]
["BIDDER:",{"$f":"Instructions!D3","v":"Bidder Company name"}]
["PROJECT:",{"$f":"Instructions!D4","v":"Portable VHF Radios"}]
["Item Nr:","G9"]
["SUB-PROJECT:","VIRGINIA AIRPORT"]
["Foreign Currancy",{"$f":"'[1]Tenderer Info'!D4","v":"FC"}]
["ROE: 1R =",{"$f":"0.1","v":0.1}]
[]
[null,null,"Overseas Items",{"$nulls":5},"Local Items"]
[]
["Schedule Item Number","Description","Foreign Currency","Quantity","Foreign Amount Unit Cost","Foreign Amount  Total Cost","ROE: 1R = …","Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[]
["G2","RADIO EQUIPMENT"]
["G2.1"]
[null,"VHF Transceivers/Radios ",{"$f":"$B$7","v":"FC"},2,null,{"$f":"D18*E18","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G18<>0,F18/G18,0)","v":0},null,null,{"$f":"I18*J18","v":0},{"$f":"K18+H18","v":0}]
[null,"Antennas","FC",2,null,{"$f":"D19*E19","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G19<>0,F19/G19,0)","v":0},null,null,{"$f":"I19*J19","v":0},{"$f":"K19+H19","v":0}]
[null,"Microphones  ","FC",2,null,{"$f":"D20*E20","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G20<>0,F20/G20,0)","v":0},null,null,{"$f":"I20*J20","v":0},{"$f":"K20+H20","v":0}]
[null,"Batteries and Battery Charger ","FC",2,null,{"$f":"D21*E21","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G21<>0,F21/G21,0)","v":0},null,null,{"$f":"I21*J21","v":0},{"$f":"K21+H21","v":0}]
[null,"Radio Case (Including handles and car mounting kit)","FC",2,null,{"$f":"D22*E22","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G22<>0,F22/G22,0)","v":0},null,null,{"$f":"I22*J22","v":0},{"$f":"K22+H22","v":0}]
["G4","MISCELLANEOUS"]
[null,"Manuals",{"$f":"$B$7","v":"FC"},2,null,{"$f":"D24*E24","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"SITE TOTAL :",null,null,{"$f":"SUM(E15:E28)","v":0},{"$f":"SUM(F15:F28)","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"SUM(H15:H28)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(J15:J28)","v":0},{"$f":"SUM(K15:K28)","v":0},{"$f":"SUM(L15:L28)","v":0}]
[]
["G5","Options"]
["G5.1",null,{"$f":"$B$7","v":"FC"},null,null,{"$f":"D32*E32","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G32<>0,F32/G32,0)","v":0},null,null,{"$f":"I32*J32","v":0},{"$f":"K32+H32","v":0}]
["G5.2",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,{"$f":"K33+H33","v":0}]
["G5.3",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.4",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.5",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.6",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"GRAND TOTAL :",null,null,{"$f":"SUM(E30:E38)+E29","v":0},{"$f":"SUM(F30:F38)+F29","v":0},null,{"v":0,"d":"0.00"},null,0,0,0]

{"sheet":"G10 FARB","index":10,"n_rows":39,"n_cols":12,"rows_kept":39,"merged":[[0,0,0,1],[1,0,1,1],[9,2,10,7],[9,8,10,10],[11,0,13,0],[11,1,13,1],[11,2,13,2],[11,4,13,4],[11,5,13,5],[11,6,13,6],[11,7,13,7],[11,9,13,9],[11,10,13,10],[11,11,13,11]]}
["BID PRICE SCHEDULE: APPENDIX G10"]
["(INCLUDING VALUE ADDED TAX)"]
["BIDDER:",{"$f":"Instructions!D3","v":"Bidder Company name"}]
["PROJECT:",{"$f":"Instructions!D4","v":"Portable VHF Radios"}]
["Item Nr:","G10"]
["SUB-PROJECT:","RICHARDS BAY AIRPORT "]
["Foreign Currancy",{"$f":"'[1]Tenderer Info'!D4","v":"FC"}]
["ROE: 1R =",{"$f":"0.1","v":0.1}]
[]
[null,null,"Overseas Items",{"$nulls":5},"Local Items"]
[]
["Schedule Item Number","Description","Foreign Currency","Quantity","Foreign Amount Unit Cost","Foreign Amount  Total Cost","ROE: 1R = …","Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[]
["G2","RADIO EQUIPMENT"]
["G2.1"]
[null,"VHF Transceivers/Radios ",{"$f":"$B$7","v":"FC"},1,null,{"$f":"D18*E18","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G18<>0,F18/G18,0)","v":0},null,null,{"$f":"I18*J18","v":0},{"$f":"K18+H18","v":0}]
[null,"Antennas","FC",1,null,{"$f":"D19*E19","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G19<>0,F19/G19,0)","v":0},null,null,{"$f":"I19*J19","v":0},{"$f":"K19+H19","v":0}]
[null,"Microphones  ","FC",1,null,{"$f":"D20*E20","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G20<>0,F20/G20,0)","v":0},null,null,{"$f":"I20*J20","v":0},{"$f":"K20+H20","v":0}]
[null,"Batteries and Battery Charger ","FC",1,null,{"$f":"D21*E21","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G21<>0,F21/G21,0)","v":0},null,null,{"$f":"I21*J21","v":0},{"$f":"K21+H21","v":0}]
[null,"Radio Case (Including handles and car mounting kit)","FC",1,null,{"$f":"D22*E22","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G22<>0,F22/G22,0)","v":0},null,null,{"$f":"I22*J22","v":0},{"$f":"K22+H22","v":0}]
["G4","MISCELLANEOUS"]
[null,"Manuals",{"$f":"$B$7","v":"FC"},1,null,{"$f":"D24*E24","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"SITE TOTAL :",null,null,{"$f":"SUM(E15:E28)","v":0},{"$f":"SUM(F15:F28)","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"SUM(H15:H28)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(J15:J28)","v":0},{"$f":"SUM(K15:K28)","v":0},{"$f":"SUM(L15:L28)","v":0}]
[]
["G5","Options"]
["G5.1",null,{"$f":"$B$7","v":"FC"},null,null,{"$f":"D32*E32","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G32<>0,F32/G32,0)","v":0},null,null,{"$f":"I32*J32","v":0},{"$f":"K32+H32","v":0}]
["G5.2",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,{"$f":"K33+H33","v":0}]
["G5.3",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.4",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.5",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.6",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"GRAND TOTAL :",null,null,{"$f":"SUM(E30:E38)+E29","v":0},{"$f":"SUM(F30:F38)+F29","v":0},null,{"v":0,"d":"0.00"},null,0,0,0]

{"sheet":"G11 FABL","index":11,"n_rows":43,"n_cols":12,"rows_kept":43,"merged":[[0,0,0,1],[1,0,1,1],[9,2,10,7],[9,8,10,10],[11,0,13,0],[11,1,13,1],[11,2,13,2],[11,4,13,4],[11,5,13,5],[11,6,13,6],[11,7,13,7],[11,9,13,9],[11,10,13,10],[11,11,13,11]]}
["BID PRICE SCHEDULE: APPENDIX G11"]
["(INCLUDING VALUE ADDED TAX)"]
["BIDDER:",{"$f":"Instructions!D3","v":"Bidder Company name"}]
["PROJECT:",{"$f":"Instructions!D4","v":"Portable VHF Radios"}]
["Item Nr:","G11"]
["SUB-PROJECT:","BRAM FISCHER INTERNATIONAL AIRPORT "]
["Foreign Currancy",{"$f":"'[1]Tenderer Info'!D4","v":"FC"}]
["ROE: 1R =",{"$f":"0.1","v":0.1}]
[]
[null,null,"Overseas Items",{"$nulls":5},"Local Items"]
[]
["Schedule Item Number","Description","Foreign Currency","Quantity","Foreign Amount Unit Cost","Foreign Amount  Total Cost","ROE: 1R = …","Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[]
["G2","RADIO EQUIPMENT"]
["G2.1"]
[null,"VHF Transceivers/Radios ",{"$f":"$B$7","v":"FC"},12,null,{"$f":"D18*E18","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G18<>0,F18/G18,0)","v":0},null,null,{"$f":"I18*J18","v":0},{"$f":"K18+H18","v":0}]
[null,"Antennas","FC",12,null,{"$f":"D19*E19","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G19<>0,F19/G19,0)","v":0},null,null,{"$f":"I19*J19","v":0},{"$f":"K19+H19","v":0}]
[null,"Microphones  ","FC",12,null,{"$f":"D20*E20","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G20<>0,F20/G20,0)","v":0},null,null,{"$f":"I20*J20","v":0},{"$f":"K20+H20","v":0}]
[null,"Batteries and Battery Charger ","FC",12,null,{"$f":"D21*E21","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G21<>0,F21/G21,0)","v":0},null,null,{"$f":"I21*J21","v":0},{"$f":"K21+H21","v":0}]
[null,"Radio Case (Including handles and car mounting kit)","FC",12,null,{"$f":"D22*E22","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G22<>0,F22/G22,0)","v":0},null,null,{"$f":"I22*J22","v":0},{"$f":"K22+H22","v":0}]
[null,"Mobile-vehicle antennas","FC",6,null,{"$f":"D23*E23","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G23<>0,F23/G23,0)","v":0},null,null,{"$f":"I23*J23","v":0},{"$f":"K23+H23","v":0}]
["G3","DELIVERY"]
["G.3.1"]
[null,"Delivery of equipment for FABL, FAKM (13 Radios)",{"$f":"$B$7","v":"FC"},1,null,null,{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G26<>0,F26/G26,0)","v":0},null,null,{"$f":"I26*J26","v":0},{"$f":"H26+K110","v":0}]
["G4","MISCELLANEOUS"]
[null,"Manuals",{"$f":"$B$7","v":"FC"},2,null,{"$f":"D28*E28","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"SITE TOTAL :",null,null,{"$f":"SUM(E15:E32)","v":0},{"$f":"SUM(F15:F32)","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"SUM(H15:H32)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(J15:J32)","v":0},{"$f":"SUM(K15:K32)","v":0},{"$f":"SUM(L15:L32)","v":0}]
[]
["G5","Options"]
["G5.1",null,{"$f":"$B$7","v":"FC"},null,null,{"$f":"D36*E36","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G36<>0,F36/G36,0)","v":0},null,null,{"$f":"I36*J36","v":0},{"$f":"K36+H36","v":0}]
["G5.2",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,{"$f":"K37+H37","v":0}]
["G5.3",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.4",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.5",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.6",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"GRAND TOTAL :",null,null,{"$f":"SUM(E34:E42)+E33","v":0},{"$f":"SUM(F34:F42)+F33","v":0},null,{"v":0,"d":"0.00"},null,0,0,0]

{"sheet":"G12 FAKM","index":12,"n_rows":39,"n_cols":12,"rows_kept":39,"merged":[[0,0,0,1],[1,0,1,1],[9,2,10,7],[9,8,10,10],[11,0,13,0],[11,1,13,1],[11,2,13,2],[11,4,13,4],[11,5,13,5],[11,6,13,6],[11,7,13,7],[11,9,13,9],[11,10,13,10],[11,11,13,11]]}
["BID PRICE SCHEDULE: APPENDIX G12"]
["(INCLUDING VALUE ADDED TAX)"]
["BIDDER",{"$f":"Instructions!D3","v":"Bidder Company name"}]
["PROJECT:",{"$f":"Instructions!D4","v":"Portable VHF Radios"}]
["Item Nr:","G12"]
["SUB-PROJECT:","KIMBERLEY AIRPORT "]
["Foreign Currancy",{"$f":"'[1]Tenderer Info'!D4","v":"FC"}]
["ROE: 1R =",{"$f":"0.1","v":0.1}]
[]
[null,null,"Overseas Items",{"$nulls":5},"Local Items"]
[]
["Schedule Item Number","Description","Foreign Currency","Quantity","Foreign Amount Unit Cost","Foreign Amount  Total Cost","ROE: 1R = …","Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[]
["G2","RADIO EQUIPMENT"]
["G2.1"]
[null,"VHF Transceivers/Radios ",{"$f":"$B$7","v":"FC"},1,null,{"$f":"D18*E18","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G18<>0,F18/G18,0)","v":0},null,null,{"$f":"I18*J18","v":0},{"$f":"K18+H18","v":0}]
[null,"Antennas","FC",1,null,{"$f":"D19*E19","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G19<>0,F19/G19,0)","v":0},null,null,{"$f":"I19*J19","v":0},{"$f":"K19+H19","v":0}]
[null,"Microphones  ","FC",1,null,{"$f":"D20*E20","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G20<>0,F20/G20,0)","v":0},null,null,{"$f":"I20*J20","v":0},{"$f":"K20+H20","v":0}]
[null,"Batteries and Battery Charger ","FC",1,null,{"$f":"D21*E21","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G21<>0,F21/G21,0)","v":0},null,null,{"$f":"I21*J21","v":0},{"$f":"K21+H21","v":0}]
[null,"Radio Case (Including handles and car mounting kit)","FC",1,null,{"$f":"D22*E22","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G22<>0,F22/G22,0)","v":0},null,null,{"$f":"I22*J22","v":0},{"$f":"K22+H22","v":0}]
["G4","MISCELLANEOUS"]
[null,"Manuals",{"$f":"$B$7","v":"FC"},null,null,{"$f":"D24*E24","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"SITE TOTAL :",null,null,{"$f":"SUM(E15:E28)","v":0},{"$f":"SUM(F15:F28)","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"SUM(H15:H28)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(J15:J28)","v":0},{"$f":"SUM(K15:K28)","v":0},{"$f":"SUM(L15:L28)","v":0}]
[]
["G5","Options"]
["G5.1",null,{"$f":"$B$7","v":"FC"},null,null,{"$f":"D32*E32","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G32<>0,F32/G32,0)","v":0},null,null,{"$f":"I32*J32","v":0},{"$f":"K32+H32","v":0}]
["G5.2",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,{"$f":"K33+H33","v":0}]
["G5.3",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.4",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.5",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.6",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"GRAND TOTAL :",null,null,{"$f":"SUM(E30:E38)+E29","v":0},{"$f":"SUM(F30:F38)+F29","v":0},null,{"v":0,"d":"0.00"},null,0,0,0]

{"sheet":"G13 FAUP","index":13,"n_rows":43,"n_cols":12,"rows_kept":43,"merged":[[0,0,0,1],[1,0,1,1],[9,2,10,7],[9,8,10,10],[11,0,13,0],[11,1,13,1],[11,2,13,2],[11,4,13,4],[11,5,13,5],[11,6,13,6],[11,7,13,7],[11,9,13,9],[11,10,13,10],[11,11,13,11]]}
["BID PRICE SCHEDULE: APPENDIX G13"]
["(INCLUDING VALUE ADDED TAX)"]
["BIDDER:",{"$f":"Instructions!D3","v":"Bidder Company name"}]
["PROJECT:",{"$f":"Instructions!D4","v":"Portable VHF Radios"}]
["Item Nr:","G13"]
["SUB-PROJECT:","UPINGTON INTERNATIONAL AIRPORT "]
["Foreign Currancy",{"$f":"'[1]Tenderer Info'!D4","v":"FC"}]
["ROE: 1R =",{"$f":"0.1","v":0.1}]
[]
[null,null,"Overseas Items",{"$nulls":5},"Local Items"]
[]
["Schedule Item Number","Description","Foreign Currency","Quantity","Foreign Amount Unit Cost","Foreign Amount  Total Cost","ROE: 1R = …","Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[]
["G2","RADIO EQUIPMENT"]
["G2.1"]
[null,"VHF Transceivers/Radios ",{"$f":"$B$7","v":"FC"},6,null,{"$f":"D18*E18","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G18<>0,F18/G18,0)","v":0},null,null,{"$f":"I18*J18","v":0},{"$f":"K18+H18","v":0}]
[null,"Antennas","FC",6,null,{"$f":"D19*E19","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G19<>0,F19/G19,0)","v":0},null,null,{"$f":"I19*J19","v":0},{"$f":"K19+H19","v":0}]
[null,"Microphones  ","FC",6,null,{"$f":"D20*E20","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G20<>0,F20/G20,0)","v":0},null,null,{"$f":"I20*J20","v":0},{"$f":"K20+H20","v":0}]
[null,"Batteries and Battery Charger ","FC",6,null,{"$f":"D21*E21","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G21<>0,F21/G21,0)","v":0},null,null,{"$f":"I21*J21","v":0},{"$f":"K21+H21","v":0}]
[null,"Radio Case (Including handles and car mounting kit)","FC",6,null,{"$f":"D22*E22","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G22<>0,F22/G22,0)","v":0},null,null,{"$f":"I22*J22","v":0},{"$f":"K22+H22","v":0}]
[null,"Mobile-vehicle antennas","FC",2,null,{"$f":"D23*E23","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G23<>0,F23/G23,0)","v":0},null,null,{"$f":"I23*J23","v":0},{"$f":"K23+H23","v":0}]
["G3","DELIVERY"]
["G.3.1"]
[null,"Delivery of equipment for FAUP (6 Radios)",{"$f":"$B$7","v":"FC"},1,null,null,{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G26<>0,F26/G26,0)","v":0},null,null,{"$f":"I26*J26","v":0},{"$f":"H26+K110","v":0}]
["G4","MISCELLANEOUS"]
[null,"Manuals",{"$f":"$B$7","v":"FC"},null,null,{"$f":"D28*E28","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"SITE TOTAL :",null,null,{"$f":"SUM(E15:E32)","v":0},{"$f":"SUM(F15:F32)","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"SUM(H15:H32)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(J15:J32)","v":0},{"$f":"SUM(K15:K32)","v":0},{"$f":"SUM(L15:L32)","v":0}]
[]
["G5","Options"]
["G5.1",null,{"$f":"$B$7","v":"FC"},null,null,{"$f":"D36*E36","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G36<>0,F36/G36,0)","v":0},null,null,{"$f":"I36*J36","v":0},{"$f":"K36+H36","v":0}]
["G5.2",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,{"$f":"K37+H37","v":0}]
["G5.3",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.4",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.5",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.6",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"GRAND TOTAL :",null,null,{"$f":"SUM(E34:E42)+E33","v":0},{"$f":"SUM(F34:F42)+F33","v":0},null,{"v":0,"d":"0.00"},null,0,0,0]

{"sheet":"G14 ATA","index":14,"n_rows":40,"n_cols":12,"rows_kept":40,"merged":[[0,0,0,1],[1,0,1,1],[9,2,10,7],[9,8,10,10],[11,0,13,0],[11,1,13,1],[11,2,13,2],[11,4,13,4],[11,5,13,5],[11,6,13,6],[11,7,13,7],[11,9,13,9],[11,10,13,10],[11,11,13,11]]}
["BID PRICE SCHEDULE: APPENDIX G14"]
["(INCLUDING VALUE ADDED TAX)"]
["BIDDER:",{"$f":"Instructions!D3","v":"Bidder Company name"}]
["PROJECT:",{"$f":"Instructions!D4","v":"Portable VHF Radios"}]
["Item Nr:","G14"]
["SUB-PROJECT:","AVIATION TRAINING ACADEMY"]
["Foreign Currancy",{"$f":"'[1]Tenderer Info'!D4","v":"FC"}]
["ROE: 1R =",{"$f":"0.1","v":0.1}]
[]
[null,null,"Overseas Items",{"$nulls":5},"Local Items"]
[]
["Schedule Item Number","Description","Foreign Currency","Quantity","Foreign Amount Unit Cost","Foreign Amount  Total Cost","ROE: 1R = …","Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[]
["G2","RADIO EQUIPMENT"]
["G2.1"]
[null,"VHF Transceivers/Radios ",{"$f":"$B$7","v":"FC"},2,null,{"$f":"D18*E18","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G18<>0,F18/G18,0)","v":0},null,null,{"$f":"I18*J18","v":0},{"$f":"K18+H18","v":0}]
[null,"Antennas","FC",2,null,{"$f":"D19*E19","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G19<>0,F19/G19,0)","v":0},null,null,{"$f":"I19*J19","v":0},{"$f":"K19+H19","v":0}]
[null,"Microphones  ","FC",2,null,{"$f":"D20*E20","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G20<>0,F20/G20,0)","v":0},null,null,{"$f":"I20*J20","v":0},{"$f":"K20+H20","v":0}]
[null,"Batteries and Battery Charger ","FC",2,null,{"$f":"D21*E21","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G21<>0,F21/G21,0)","v":0},null,null,{"$f":"I21*J21","v":0},{"$f":"K21+H21","v":0}]
[null,"Radio Case (Including handles and car mounting kit)","FC",2,null,{"$f":"D22*E22","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G22<>0,F22/G22,0)","v":0},null,null,{"$f":"I22*J22","v":0},{"$f":"K22+H22","v":0}]
[null,"Dummy Load","FC",2,{"$nulls":4},2]
["G4","MISCELLANEOUS"]
[null,"Manuals",{"$f":"$B$7","v":"FC"},2,null,{"$f":"D25*E25","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,{"$f":"D28*E28","v":0},{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"SITE TOTAL :",null,null,{"$f":"SUM(E15:E29)","v":0},{"$f":"SUM(F15:F29)","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"SUM(H15:H29)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(J15:J29)","v":0},{"$f":"SUM(K15:K29)","v":0},{"$f":"SUM(L15:L29)","v":0}]
[]
["G5","Options"]
["G5.1",null,{"$f":"$B$7","v":"FC"},null,null,{"$f":"D33*E33","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G33<>0,F33/G33,0)","v":0},null,null,{"$f":"I33*J33","v":0},{"$f":"K33+H33","v":0}]
["G5.2",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,{"$f":"K34+H34","v":0}]
["G5.3",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.4",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.5",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.6",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"GRAND TOTAL :",null,null,{"$f":"SUM(E31:E39)+E30","v":0},{"$f":"SUM(F31:F39)+F30","v":0},null,{"v":0,"d":"0.00"},null,0,0,0]

{"sheet":"G15 FAOR","index":15,"n_rows":42,"n_cols":12,"rows_kept":42,"merged":[[0,0,0,1],[1,0,1,1],[9,2,10,7],[9,8,10,10],[11,0,13,0],[11,1,13,1],[11,2,13,2],[11,4,13,4],[11,5,13,5],[11,6,13,6],[11,7,13,7],[11,9,13,9],[11,10,13,10],[11,11,13,11]]}
["BID PRICE SCHEDULE: APPENDIX G15"]
["(INCLUDING VALUE ADDED TAX)"]
["BIDDER:",{"$f":"Instructions!D3","v":"Bidder Company name"}]
["PROJECT:",{"$f":"Instructions!D4","v":"Portable VHF Radios"}]
["Item Nr:","G15"]
["SUB-PROJECT:","OR TAMBO INTERNATIONAL AIRPORT "]
["Foreign Currancy",{"$f":"'[1]Tenderer Info'!D4","v":"FC"}]
["ROE: 1R =",{"$f":"0.1","v":0.1}]
[]
[null,null,"Overseas Items",{"$nulls":5},"Local Items"]
[]
["Schedule Item Number","Description","Foreign Currency","Quantity","Foreign Amount Unit Cost","Foreign Amount  Total Cost","ROE: 1R = …","Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[]
["G2","RADIO EQUIPMENT"]
["G2.1"]
[null,"VHF Transceivers/Radios ",{"$f":"$B$7","v":"FC"},14,null,{"$f":"D18*E18","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G18<>0,F18/G18,0)","v":0},null,null,{"$f":"I18*J18","v":0},{"$f":"K18+H18","v":0}]
[null,"Antennas","FC",14,null,{"$f":"D19*E19","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G19<>0,F19/G19,0)","v":0},null,null,{"$f":"I19*J19","v":0},{"$f":"K19+H19","v":0}]
[null,"Microphones  ","FC",14,null,{"$f":"D20*E20","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G20<>0,F20/G20,0)","v":0},null,null,{"$f":"I20*J20","v":0},{"$f":"K20+H20","v":0}]
[null,"Batteries and Battery Charger ","FC",14,null,{"$f":"D21*E21","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G21<>0,F21/G21,0)","v":0},null,null,{"$f":"I21*J21","v":0},{"$f":"K21+H21","v":0}]
[null,"Radio Case (Including handles and car mounting kit)","FC",14,null,{"$f":"D22*E22","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G22<>0,F22/G22,0)","v":0},null,null,{"$f":"I22*J22","v":0},{"$f":"K22+H22","v":0}]
["G3","DELIVERY"]
["G.3.1"]
[null,"Delivery of equipment for ATA, FAOR, FALA, FAWB, FAGM, FAPN, FAPP, FAKN, FAMM, FAGC, Special Events, Spare (38 Radios)",{"$f":"$B$7","v":"FC"},1,null,null,{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G25<>0,F25/G25,0)","v":0},null,null,{"$f":"I25*J25","v":0},{"$f":"H25+K109","v":0}]
["G4","MISCELLANEOUS"]
[null,"Manuals",{"$f":"$B$7","v":"FC"},2,null,{"$f":"D27*E27","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"SITE TOTAL :",null,null,{"$f":"SUM(E15:E31)","v":0},{"$f":"SUM(F15:F31)","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"SUM(H15:H31)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(J15:J31)","v":0},{"$f":"SUM(K15:K31)","v":0},{"$f":"SUM(L15:L31)","v":0}]
[]
["G5","Options"]
["G5.1",null,{"$f":"$B$7","v":"FC"},null,null,{"$f":"D35*E35","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G35<>0,F35/G35,0)","v":0},null,null,{"$f":"I35*J35","v":0},{"$f":"K35+H35","v":0}]
["G5.2",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,{"$f":"K36+H36","v":0}]
["G5.3",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.4",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.5",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.6",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"GRAND TOTAL :",null,null,{"$f":"SUM(E33:E41)+E32","v":0},{"$f":"SUM(F33:F41)+F32","v":0},null,{"v":0,"d":"0.00"},null,0,0,0]

{"sheet":"G16 FALA","index":16,"n_rows":39,"n_cols":12,"rows_kept":39,"merged":[[0,0,0,1],[1,0,1,1],[9,2,10,7],[9,8,10,10],[11,0,13,0],[11,1,13,1],[11,2,13,2],[11,4,13,4],[11,5,13,5],[11,6,13,6],[11,7,13,7],[11,9,13,9],[11,10,13,10],[11,11,13,11]]}
["BID PRICE SCHEDULE: APPENDIX G16"]
["(INCLUDING VALUE ADDED TAX)"]
["BIDDER:",{"$f":"Instructions!D3","v":"Bidder Company name"}]
["PROJECT:",{"$f":"Instructions!D4","v":"Portable VHF Radios"}]
["Item Nr:","G16"]
["SUB-PROJECT:","LANSERIA INTERNATIONAL AIRPORT "]
["Foreign Currancy",{"$f":"'[1]Tenderer Info'!D4","v":"FC"}]
["ROE: 1R =",{"$f":"0.1","v":0.1}]
[]
[null,null,"Overseas Items",{"$nulls":5},"Local Items"]
[]
["Schedule Item Number","Description","Foreign Currency","Quantity","Foreign Amount Unit Cost","Foreign Amount  Total Cost","ROE: 1R = …","Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[]
["G2","RADIO EQUIPMENT"]
["G2.1"]
[null,"VHF Transceivers/Radios ",{"$f":"$B$7","v":"FC"},2,null,{"$f":"D18*E18","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G18<>0,F18/G18,0)","v":0},null,null,{"$f":"I18*J18","v":0},{"$f":"K18+H18","v":0}]
[null,"Antennas","FC",2,null,{"$f":"D19*E19","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G19<>0,F19/G19,0)","v":0},null,null,{"$f":"I19*J19","v":0},{"$f":"K19+H19","v":0}]
[null,"Microphones  ","FC",2,null,{"$f":"D20*E20","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G20<>0,F20/G20,0)","v":0},null,null,{"$f":"I20*J20","v":0},{"$f":"K20+H20","v":0}]
[null,"Batteries and Battery Charger ","FC",2,null,{"$f":"D21*E21","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G21<>0,F21/G21,0)","v":0},null,null,{"$f":"I21*J21","v":0},{"$f":"K21+H21","v":0}]
[null,"Radio Case (Including handles and car mounting kit)","FC",null,null,{"$f":"D22*E22","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G22<>0,F22/G22,0)","v":0},null,null,{"$f":"I22*J22","v":0},{"$f":"K22+H22","v":0}]
["G4","MISCELLANEOUS"]
[null,"Manuals",{"$f":"$B$7","v":"FC"},2,null,{"$f":"D24*E24","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"SITE TOTAL :",null,null,{"$f":"SUM(E15:E28)","v":0},{"$f":"SUM(F15:F28)","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"SUM(H15:H28)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(J15:J28)","v":0},{"$f":"SUM(K15:K28)","v":0},{"$f":"SUM(L15:L28)","v":0}]
[]
["G5","Options"]
["G5.1",null,{"$f":"$B$7","v":"FC"},null,null,{"$f":"D32*E32","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G32<>0,F32/G32,0)","v":0},null,null,{"$f":"I32*J32","v":0},{"$f":"K32+H32","v":0}]
["G5.2",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,{"$f":"K33+H33","v":0}]
["G5.3",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.4",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.5",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.6",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"GRAND TOTAL :",null,null,{"$f":"SUM(E30:E38)+E29","v":0},{"$f":"SUM(F30:F38)+F29","v":0},null,{"v":0,"d":"0.00"},null,0,0,0]

{"sheet":"G17 FAWB","index":17,"n_rows":39,"n_cols":12,"rows_kept":39,"merged":[[0,0,0,1],[1,0,1,1],[9,2,10,7],[9,8,10,10],[11,0,13,0],[11,1,13,1],[11,2,13,2],[11,4,13,4],[11,5,13,5],[11,6,13,6],[11,7,13,7],[11,9,13,9],[11,10,13,10],[11,11,13,11]]}
["BID PRICE SCHEDULE: APPENDIX G17"]
["(INCLUDING VALUE ADDED TAX)"]
["BIDDER:",{"$f":"Instructions!D3","v":"Bidder Company name"}]
["PROJECT:",{"$f":"Instructions!D4","v":"Portable VHF Radios"}]
["Item Nr:","G17"]
["SUB-PROJECT:","WONDERBOOM AIRPORT "]
["Foreign Currancy",{"$f":"'[1]Tenderer Info'!D4","v":"FC"}]
["ROE: 1R =",{"$f":"0.1","v":0.1}]
[]
[null,null,"Overseas Items",{"$nulls":5},"Local Items"]
[]
["Schedule Item Number","Description","Foreign Currency","Quantity","Foreign Amount Unit Cost","Foreign Amount  Total Cost","ROE: 1R = …","Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[]
["G2","RADIO EQUIPMENT"]
["G2.1"]
[null,"VHF Transceivers/Radios ",{"$f":"$B$7","v":"FC"},3,null,{"$f":"D18*E18","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G18<>0,F18/G18,0)","v":0},null,null,{"$f":"I18*J18","v":0},{"$f":"K18+H18","v":0}]
[null,"Antennas","FC",3,null,{"$f":"D19*E19","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G19<>0,F19/G19,0)","v":0},null,null,{"$f":"I19*J19","v":0},{"$f":"K19+H19","v":0}]
[null,"Microphones  ","FC",3,null,{"$f":"D20*E20","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G20<>0,F20/G20,0)","v":0},null,null,{"$f":"I20*J20","v":0},{"$f":"K20+H20","v":0}]
[null,"Batteries and Battery Charger ","FC",3,null,{"$f":"D21*E21","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G21<>0,F21/G21,0)","v":0},null,null,{"$f":"I21*J21","v":0},{"$f":"K21+H21","v":0}]
[null,"Radio Case (Including handles and car mounting kit)","FC",3,null,{"$f":"D22*E22","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G22<>0,F22/G22,0)","v":0},null,null,{"$f":"I22*J22","v":0},{"$f":"K22+H22","v":0}]
["G4","MISCELLANEOUS"]
[null,"Manuals",{"$f":"$B$7","v":"FC"},2,null,{"$f":"D24*E24","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"SITE TOTAL :",null,null,{"$f":"SUM(E15:E28)","v":0},{"$f":"SUM(F15:F28)","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"SUM(H15:H28)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(J15:J28)","v":0},{"$f":"SUM(K15:K28)","v":0},{"$f":"SUM(L15:L28)","v":0}]
[]
["G5","Options"]
["G5.1",null,{"$f":"$B$7","v":"FC"},null,null,{"$f":"D32*E32","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G32<>0,F32/G32,0)","v":0},null,null,{"$f":"I32*J32","v":0},{"$f":"K32+H32","v":0}]
["G5.2",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,{"$f":"K33+H33","v":0}]
["G5.3",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.4",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.5",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.6",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"GRAND TOTAL :",null,null,{"$f":"SUM(E30:E38)+E29","v":0},{"$f":"SUM(F30:F38)+F29","v":0},null,{"v":0,"d":"0.00"},null,0,0,0]

{"sheet":"G18 FAGM","index":18,"n_rows":39,"n_cols":12,"rows_kept":39,"merged":[[0,0,0,1],[1,0,1,1],[9,2,10,7],[9,8,10,10],[11,0,13,0],[11,1,13,1],[11,2,13,2],[11,4,13,4],[11,5,13,5],[11,6,13,6],[11,7,13,7],[11,9,13,9],[11,10,13,10],[11,11,13,11]]}
["BID PRICE SCHEDULE: APPENDIX G18"]
["(INCLUDING VALUE ADDED TAX)"]
["BIDDER:",{"$f":"Instructions!D3","v":"Bidder Company name"}]
["PROJECT:",{"$f":"Instructions!D4","v":"Portable VHF Radios"}]
["Item Nr:","G18"]
["SUB-PROJECT:","RAND AIRPORT "]
["Foreign Currancy",{"$f":"'[1]Tenderer Info'!D4","v":"FC"}]
["ROE: 1R =",{"$f":"0.1","v":0.1}]
[]
[null,null,"Overseas Items",{"$nulls":5},"Local Items"]
[]
["Schedule Item Number","Description","Foreign Currency","Quantity","Foreign Amount Unit Cost","Foreign Amount  Total Cost","ROE: 1R = …","Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[]
["G2","RADIO EQUIPMENT"]
["G2.1"]
[null,"VHF Transceivers/Radios ",{"$f":"$B$7","v":"FC"},1,null,{"$f":"D18*E18","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G18<>0,F18/G18,0)","v":0},null,null,{"$f":"I18*J18","v":0},{"$f":"K18+H18","v":0}]
[null,"Antennas","FC",1,null,{"$f":"D19*E19","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G19<>0,F19/G19,0)","v":0},null,null,{"$f":"I19*J19","v":0},{"$f":"K19+H19","v":0}]
[null,"Microphones  ","FC",1,null,{"$f":"D20*E20","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G20<>0,F20/G20,0)","v":0},null,null,{"$f":"I20*J20","v":0},{"$f":"K20+H20","v":0}]
[null,"Batteries and Battery Charger ","FC",1,null,{"$f":"D21*E21","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G21<>0,F21/G21,0)","v":0},null,null,{"$f":"I21*J21","v":0},{"$f":"K21+H21","v":0}]
[null,"Radio Case (Including handles and car mounting kit)","FC",1,null,{"$f":"D22*E22","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G22<>0,F22/G22,0)","v":0},null,null,{"$f":"I22*J22","v":0},{"$f":"K22+H22","v":0}]
["G4","MISCELLANEOUS"]
[null,"Manuals",{"$f":"$B$7","v":"FC"},1,null,{"$f":"D24*E24","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"SITE TOTAL :",null,null,{"$f":"SUM(E15:E28)","v":0},{"$f":"SUM(F15:F28)","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"SUM(H15:H28)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(J15:J28)","v":0},{"$f":"SUM(K15:K28)","v":0},{"$f":"SUM(L15:L28)","v":0}]
[]
["G5","Options"]
["G5.1",null,{"$f":"$B$7","v":"FC"},null,null,{"$f":"D32*E32","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G32<>0,F32/G32,0)","v":0},null,null,{"$f":"I32*J32","v":0},{"$f":"K32+H32","v":0}]
["G5.2",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,{"$f":"K33+H33","v":0}]
["G5.3",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.4",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.5",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.6",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"GRAND TOTAL :",null,null,{"$f":"SUM(E30:E38)+E29","v":0},{"$f":"SUM(F30:F38)+F29","v":0},null,{"v":0,"d":"0.00"},null,0,0,0]

{"sheet":"G19 FAPN","index":19,"n_rows":39,"n_cols":12,"rows_kept":39,"merged":[[0,0,0,1],[1,0,1,1],[9,2,10,7],[9,8,10,10],[11,0,13,0],[11,1,13,1],[11,2,13,2],[11,4,13,4],[11,5,13,5],[11,6,13,6],[11,7,13,7],[11,9,13,9],[11,10,13,10],[11,11,13,11]]}
["BID PRICE SCHEDULE: APPENDIX G19"]
["(INCLUDING VALUE ADDED TAX)"]
["BIDDER:",{"$f":"Instructions!D3","v":"Bidder Company name"}]
["PROJECT:",{"$f":"Instructions!D4","v":"Portable VHF Radios"}]
["Item Nr:","G19"]
["SUB-PROJECT:","PILANESBURG AIRPORT "]
["Foreign Currancy",{"$f":"'[1]Tenderer Info'!D4","v":"FC"}]
["ROE: 1R =",{"$f":"0.1","v":0.1}]
[]
[null,null,"Overseas Items",{"$nulls":5},"Local Items"]
[]
["Schedule Item Number","Description","Foreign Currency","Quantity","Foreign Amount Unit Cost","Foreign Amount  Total Cost","ROE: 1R = …","Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[]
["G2","RADIO EQUIPMENT"]
["G2.1"]
[null,"VHF Transceivers/Radios ",{"$f":"$B$7","v":"FC"},2,null,{"$f":"D18*E18","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G18<>0,F18/G18,0)","v":0},null,null,{"$f":"I18*J18","v":0},{"$f":"K18+H18","v":0}]
[null,"Antennas","FC",2,null,{"$f":"D19*E19","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G19<>0,F19/G19,0)","v":0},null,null,{"$f":"I19*J19","v":0},{"$f":"K19+H19","v":0}]
[null,"Microphones  ","FC",2,null,{"$f":"D20*E20","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G20<>0,F20/G20,0)","v":0},null,null,{"$f":"I20*J20","v":0},{"$f":"K20+H20","v":0}]
[null,"Batteries and Battery Charger ","FC",2,null,{"$f":"D21*E21","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G21<>0,F21/G21,0)","v":0},null,null,{"$f":"I21*J21","v":0},{"$f":"K21+H21","v":0}]
[null,"Radio Case (Including handles and car mounting kit)","FC",2,null,{"$f":"D22*E22","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G22<>0,F22/G22,0)","v":0},null,null,{"$f":"I22*J22","v":0},{"$f":"K22+H22","v":0}]
["G4","MISCELLANEOUS"]
[null,"Manuals",{"$f":"$B$7","v":"FC"},null,null,{"$f":"D24*E24","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"SITE TOTAL :",null,null,{"$f":"SUM(E15:E28)","v":0},{"$f":"SUM(F15:F28)","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"SUM(H15:H28)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(J15:J28)","v":0},{"$f":"SUM(K15:K28)","v":0},{"$f":"SUM(L15:L28)","v":0}]
[]
["G5","Options"]
["G5.1",null,{"$f":"$B$7","v":"FC"},null,null,{"$f":"D32*E32","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G32<>0,F32/G32,0)","v":0},null,null,{"$f":"I32*J32","v":0},{"$f":"K32+H32","v":0}]
["G5.2",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,{"$f":"K33+H33","v":0}]
["G5.3",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.4",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.5",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.6",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"GRAND TOTAL :",null,null,{"$f":"SUM(E30:E38)+E29","v":0},{"$f":"SUM(F30:F38)+F29","v":0},null,{"v":0,"d":"0.00"},null,0,0,0]

{"sheet":"G20 FAPP","index":20,"n_rows":39,"n_cols":12,"rows_kept":39,"merged":[[0,0,0,1],[1,0,1,1],[9,2,10,7],[9,8,10,10],[11,0,13,0],[11,1,13,1],[11,2,13,2],[11,4,13,4],[11,5,13,5],[11,6,13,6],[11,7,13,7],[11,9,13,9],[11,10,13,10],[11,11,13,11]]}
["BID PRICE SCHEDULE: APPENDIX G20"]
["(INCLUDING VALUE ADDED TAX)"]
["BIDDER:",{"$f":"Instructions!D3","v":"Bidder Company name"}]
["PROJECT:",{"$f":"Instructions!D4","v":"Portable VHF Radios"}]
["Item Nr:","G20"]
["SUB-PROJECT:","POLOKWANE AIRPORT "]
["Foreign Currancy",{"$f":"'[1]Tenderer Info'!D4","v":"FC"}]
["ROE: 1R =",{"$f":"0.1","v":0.1}]
[]
[null,null,"Overseas Items",{"$nulls":5},"Local Items"]
[]
["Schedule Item Number","Description","Foreign Currency","Quantity","Foreign Amount Unit Cost","Foreign Amount  Total Cost","ROE: 1R = …","Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[]
["G2","RADIO EQUIPMENT"]
["G2.1"]
[null,"VHF Transceivers/Radios ",{"$f":"$B$7","v":"FC"},2,null,{"$f":"D18*E18","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G18<>0,F18/G18,0)","v":0},null,null,{"$f":"I18*J18","v":0},{"$f":"K18+H18","v":0}]
[null,"Antennas","FC",2,null,{"$f":"D19*E19","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G19<>0,F19/G19,0)","v":0},null,null,{"$f":"I19*J19","v":0},{"$f":"K19+H19","v":0}]
[null,"Microphones  ","FC",2,null,{"$f":"D20*E20","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G20<>0,F20/G20,0)","v":0},null,null,{"$f":"I20*J20","v":0},{"$f":"K20+H20","v":0}]
[null,"Batteries and Battery Charger ","FC",2,null,{"$f":"D21*E21","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G21<>0,F21/G21,0)","v":0},null,null,{"$f":"I21*J21","v":0},{"$f":"K21+H21","v":0}]
[null,"Radio Case (Including handles and car mounting kit)","FC",2,null,{"$f":"D22*E22","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G22<>0,F22/G22,0)","v":0},null,null,{"$f":"I22*J22","v":0},{"$f":"K22+H22","v":0}]
["G4","MISCELLANEOUS"]
[null,"Manuals",{"$f":"$B$7","v":"FC"},2,null,{"$f":"D24*E24","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"SITE TOTAL :",null,null,{"$f":"SUM(E15:E28)","v":0},{"$f":"SUM(F15:F28)","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"SUM(H15:H28)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(J15:J28)","v":0},{"$f":"SUM(K15:K28)","v":0},{"$f":"SUM(L15:L28)","v":0}]
[]
["G5","Options"]
["G5.1",null,{"$f":"$B$7","v":"FC"},null,null,{"$f":"D32*E32","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G32<>0,F32/G32,0)","v":0},null,null,{"$f":"I32*J32","v":0},{"$f":"K32+H32","v":0}]
["G5.2",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,{"$f":"K33+H33","v":0}]
["G5.3",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.4",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.5",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.6",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"GRAND TOTAL :",null,null,{"$f":"SUM(E30:E38)+E29","v":0},{"$f":"SUM(F30:F38)+F29","v":0},null,{"v":0,"d":"0.00"},null,0,0,0]

{"sheet":"G21 FAKN","index":21,"n_rows":39,"n_cols":12,"rows_kept":39,"merged":[[0,0,0,1],[1,0,1,1],[9,2,10,7],[9,8,10,10],[11,0,13,0],[11,1,13,1],[11,2,13,2],[11,4,13,4],[11,5,13,5],[11,6,13,6],[11,7,13,7],[11,9,13,9],[11,10,13,10],[11,11,13,11]]}
["BID PRICE SCHEDULE: APPENDIX G21"]
["(INCLUDING VALUE ADDED TAX)"]
["BIDDER:",{"$f":"Instructions!D3","v":"Bidder Company name"}]
["PROJECT:",{"$f":"Instructions!D4","v":"Portable VHF Radios"}]
["Item Nr:","G21"]
["SUB-PROJECT:","KRUGER MPUMALANGA INTERNATIONAL AIRPORT "]
["Foreign Currancy",{"$f":"'[1]Tenderer Info'!D4","v":"FC"}]
["ROE: 1R =",{"$f":"0.1","v":0.1}]
[]
[null,null,"Overseas Items",{"$nulls":5},"Local Items"]
[]
["Schedule Item Number","Description","Foreign Currency","Quantity","Foreign Amount Unit Cost","Foreign Amount  Total Cost","ROE: 1R = …","Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[]
["G2","RADIO EQUIPMENT"]
["G2.1"]
[null,"VHF Transceivers/Radios ",{"$f":"$B$7","v":"FC"},4,null,{"$f":"D18*E18","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G18<>0,F18/G18,0)","v":0},null,null,{"$f":"I18*J18","v":0},{"$f":"K18+H18","v":0}]
[null,"Antennas","FC",4,null,{"$f":"D19*E19","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G19<>0,F19/G19,0)","v":0},null,null,{"$f":"I19*J19","v":0},{"$f":"K19+H19","v":0}]
[null,"Microphones  ","FC",4,null,{"$f":"D20*E20","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G20<>0,F20/G20,0)","v":0},null,null,{"$f":"I20*J20","v":0},{"$f":"K20+H20","v":0}]
[null,"Batteries and Battery Charger ","FC",4,null,{"$f":"D21*E21","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G21<>0,F21/G21,0)","v":0},null,null,{"$f":"I21*J21","v":0},{"$f":"K21+H21","v":0}]
[null,"Radio Case (Including handles and car mounting kit)","FC",4,null,{"$f":"D22*E22","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G22<>0,F22/G22,0)","v":0},null,null,{"$f":"I22*J22","v":0},{"$f":"K22+H22","v":0}]
["G4","MISCELLANEOUS"]
[null,"Manuals",{"$f":"$B$7","v":"FC"},2,null,{"$f":"D24*E24","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"SITE TOTAL :",null,null,{"$f":"SUM(E15:E28)","v":0},{"$f":"SUM(F15:F28)","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"SUM(H15:H28)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(J15:J28)","v":0},{"$f":"SUM(K15:K28)","v":0},{"$f":"SUM(L15:L28)","v":0}]
[]
["G5","Options"]
["G5.1",null,{"$f":"$B$7","v":"FC"},null,null,{"$f":"D32*E32","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G32<>0,F32/G32,0)","v":0},null,null,{"$f":"I32*J32","v":0},{"$f":"K32+H32","v":0}]
["G5.2",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,{"$f":"K33+H33","v":0}]
["G5.3",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.4",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.5",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.6",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"GRAND TOTAL :",null,null,{"$f":"SUM(E30:E38)+E29","v":0},{"$f":"SUM(F30:F38)+F29","v":0},null,{"v":0,"d":"0.00"},null,0,0,0]

{"sheet":"G22 FAMM","index":22,"n_rows":39,"n_cols":12,"rows_kept":39,"merged":[[0,0,0,1],[1,0,1,1],[9,2,10,7],[9,8,10,10],[11,0,13,0],[11,1,13,1],[11,2,13,2],[11,4,13,4],[11,5,13,5],[11,6,13,6],[11,7,13,7],[11,9,13,9],[11,10,13,10],[11,11,13,11]]}
["BID PRICE SCHEDULE: APPENDIX G22"]
["(INCLUDING VALUE ADDED TAX)"]
["BIDDER:",{"$f":"Instructions!D3","v":"Bidder Company name"}]
["PROJECT:",{"$f":"Instructions!D4","v":"Portable VHF Radios"}]
["Item Nr:","G22"]
["SUB-PROJECT:","MAHIKENG AIRPORT "]
["Foreign Currancy",{"$f":"'[1]Tenderer Info'!D4","v":"FC"}]
["ROE: 1R =",{"$f":"0.1","v":0.1}]
[]
[null,null,"Overseas Items",{"$nulls":5},"Local Items"]
[]
["Schedule Item Number","Description","Foreign Currency","Quantity","Foreign Amount Unit Cost","Foreign Amount  Total Cost","ROE: 1R = …","Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[]
["G2","RADIO EQUIPMENT"]
["G2.1"]
[null,"VHF Transceivers/Radios ",{"$f":"$B$7","v":"FC"},3,null,{"$f":"D18*E18","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G18<>0,F18/G18,0)","v":0},null,null,{"$f":"I18*J18","v":0},{"$f":"K18+H18","v":0}]
[null,"Antennas","FC",3,null,{"$f":"D19*E19","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G19<>0,F19/G19,0)","v":0},null,null,{"$f":"I19*J19","v":0},{"$f":"K19+H19","v":0}]
[null,"Microphones  ","FC",3,null,{"$f":"D20*E20","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G20<>0,F20/G20,0)","v":0},null,null,{"$f":"I20*J20","v":0},{"$f":"K20+H20","v":0}]
[null,"Batteries and Battery Charger ","FC",3,null,{"$f":"D21*E21","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G21<>0,F21/G21,0)","v":0},null,null,{"$f":"I21*J21","v":0},{"$f":"K21+H21","v":0}]
[null,"Radio Case (Including handles and car mounting kit)","FC",3,null,{"$f":"D22*E22","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G22<>0,F22/G22,0)","v":0},null,null,{"$f":"I22*J22","v":0},{"$f":"K22+H22","v":0}]
["G4","MISCELLANEOUS"]
[null,"Manuals",{"$f":"$B$7","v":"FC"},2,null,{"$f":"D24*E24","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"SITE TOTAL :",null,null,{"$f":"SUM(E15:E28)","v":0},{"$f":"SUM(F15:F28)","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"SUM(H15:H28)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(J15:J28)","v":0},{"$f":"SUM(K15:K28)","v":0},{"$f":"SUM(L15:L28)","v":0}]
[]
["G5","Options"]
["G5.1",null,{"$f":"$B$7","v":"FC"},null,null,{"$f":"D32*E32","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G32<>0,F32/G32,0)","v":0},null,null,{"$f":"I32*J32","v":0},{"$f":"K32+H32","v":0}]
["G5.2",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,{"$f":"K33+H33","v":0}]
["G5.3",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.4",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.5",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.6",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"GRAND TOTAL :",null,null,{"$f":"SUM(E30:E38)+E29","v":0},{"$f":"SUM(F30:F38)+F29","v":0},null,{"v":0,"d":"0.00"},null,0,0,0]

{"sheet":"G23 FAGC","index":23,"n_rows":39,"n_cols":12,"rows_kept":39,"merged":[[0,0,0,1],[1,0,1,1],[9,2,10,7],[9,8,10,10],[11,0,13,0],[11,1,13,1],[11,2,13,2],[11,4,13,4],[11,5,13,5],[11,6,13,6],[11,7,13,7],[11,9,13,9],[11,10,13,10],[11,11,13,11]]}
["BID PRICE SCHEDULE: APPENDIX G23"]
["(INCLUDING VALUE ADDED TAX)"]
["BIDDER:",{"$f":"Instructions!D3","v":"Bidder Company name"}]
["PROJECT:",{"$f":"Instructions!D4","v":"Portable VHF Radios"}]
["Item Nr:","G23"]
["SUB-PROJECT:","GRAND CENTRAL AIRPORT"]
["Foreign Currancy",{"$f":"'[1]Tenderer Info'!D4","v":"FC"}]
["ROE: 1R =",{"$f":"0.1","v":0.1}]
[]
[null,null,"Overseas Items",{"$nulls":5},"Local Items"]
[]
["Schedule Item Number","Description","Foreign Currency","Quantity","Foreign Amount Unit Cost","Foreign Amount  Total Cost","ROE: 1R = …","Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[]
["G2","RADIO EQUIPMENT"]
["G2.1"]
[null,"VHF Transceivers/Radios ",{"$f":"$B$7","v":"FC"},1,null,{"$f":"D18*E18","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G18<>0,F18/G18,0)","v":0},null,null,{"$f":"I18*J18","v":0},{"$f":"K18+H18","v":0}]
[null,"Antennas","FC",1,null,{"$f":"D19*E19","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G19<>0,F19/G19,0)","v":0},null,null,{"$f":"I19*J19","v":0},{"$f":"K19+H19","v":0}]
[null,"Microphones  ","FC",1,null,{"$f":"D20*E20","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G20<>0,F20/G20,0)","v":0},null,null,{"$f":"I20*J20","v":0},{"$f":"K20+H20","v":0}]
[null,"Batteries and Battery Charger ","FC",1,null,{"$f":"D21*E21","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G21<>0,F21/G21,0)","v":0},null,null,{"$f":"I21*J21","v":0},{"$f":"K21+H21","v":0}]
[null,"Radio Case (Including handles and car mounting kit)","FC",null,null,{"$f":"D22*E22","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G22<>0,F22/G22,0)","v":0},null,null,{"$f":"I22*J22","v":0},{"$f":"K22+H22","v":0}]
["G4","MISCELLANEOUS"]
[null,"Manuals",{"$f":"$B$7","v":"FC"},1,null,{"$f":"D24*E24","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"SITE TOTAL :",null,null,{"$f":"SUM(E15:E28)","v":0},{"$f":"SUM(F15:F28)","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"SUM(H15:H28)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(J15:J28)","v":0},{"$f":"SUM(K15:K28)","v":0},{"$f":"SUM(L15:L28)","v":0}]
[]
["G5","Options"]
["G5.1",null,{"$f":"$B$7","v":"FC"},null,null,{"$f":"D32*E32","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G32<>0,F32/G32,0)","v":0},null,null,{"$f":"I32*J32","v":0},{"$f":"K32+H32","v":0}]
["G5.2",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,{"$f":"K33+H33","v":0}]
["G5.3",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.4",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.5",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.6",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"GRAND TOTAL :",null,null,{"$f":"SUM(E30:E38)+E29","v":0},{"$f":"SUM(F30:F38)+F29","v":0},null,{"v":0,"d":"0.00"},null,0,0,0]

{"sheet":"G24 SPECIAL EVENTS","index":24,"n_rows":39,"n_cols":12,"rows_kept":39,"merged":[[0,0,0,1],[1,0,1,1],[9,2,10,7],[9,8,10,10],[11,0,13,0],[11,1,13,1],[11,2,13,2],[11,4,13,4],[11,5,13,5],[11,6,13,6],[11,7,13,7],[11,9,13,9],[11,10,13,10],[11,11,13,11]]}
["BID PRICE SCHEDULE: APPENDIX G24"]
["(INCLUDING VALUE ADDED TAX)"]
["BIDDER:",{"$f":"Instructions!D3","v":"Bidder Company name"}]
["PROJECT:",{"$f":"Instructions!D4","v":"Portable VHF Radios"}]
["Item Nr:","G24"]
["SUB-PROJECT:","SPECIAL EVENTS"]
["Foreign Currancy",{"$f":"'[1]Tenderer Info'!D4","v":"FC"}]
["ROE: 1R =",{"$f":"0.1","v":0.1}]
[]
[null,null,"Overseas Items",{"$nulls":5},"Local Items"]
[]
["Schedule Item Number","Description","Foreign Currency","Quantity","Foreign Amount Unit Cost","Foreign Amount  Total Cost","ROE: 1R = …","Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[]
["G2","RADIO EQUIPMENT"]
["G2.1"]
[null,"VHF Transceivers/Radios ",{"$f":"$B$7","v":"FC"},2,null,{"$f":"D18*E18","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G18<>0,F18/G18,0)","v":0},null,null,{"$f":"I18*J18","v":0},{"$f":"K18+H18","v":0}]
[null,"Antennas","FC",2,null,{"$f":"D19*E19","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G19<>0,F19/G19,0)","v":0},null,null,{"$f":"I19*J19","v":0},{"$f":"K19+H19","v":0}]
[null,"Microphones  ","FC",2,null,{"$f":"D20*E20","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G20<>0,F20/G20,0)","v":0},null,null,{"$f":"I20*J20","v":0},{"$f":"K20+H20","v":0}]
[null,"Batteries and Battery Charger ","FC",2,null,{"$f":"D21*E21","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G21<>0,F21/G21,0)","v":0},null,null,{"$f":"I21*J21","v":0},{"$f":"K21+H21","v":0}]
[null,"Radio Case (Including handles and car mounting kit)","FC",2,null,{"$f":"D22*E22","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G22<>0,F22/G22,0)","v":0},null,null,{"$f":"I22*J22","v":0},{"$f":"K22+H22","v":0}]
["G4","MISCELLANEOUS"]
[null,null,{"$f":"$B$7","v":"FC"},null,null,{"$f":"D24*E24","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"SITE TOTAL :",null,null,{"$f":"SUM(E15:E28)","v":0},{"$f":"SUM(F15:F28)","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"SUM(H15:H28)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(J15:J28)","v":0},{"$f":"SUM(K15:K28)","v":0},{"$f":"SUM(L15:L28)","v":0}]
[]
["G5","Options"]
["G5.1",null,{"$f":"$B$7","v":"FC"},null,null,{"$f":"D32*E32","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G32<>0,F32/G32,0)","v":0},null,null,{"$f":"I32*J32","v":0},{"$f":"K32+H32","v":0}]
["G5.2",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,{"$f":"K33+H33","v":0}]
["G5.3",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.4",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.5",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["G5.6",null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"GRAND TOTAL :",null,null,{"$f":"SUM(E30:E38)+E29","v":0},{"$f":"SUM(F30:F38)+F29","v":0},null,{"v":0,"d":"0.00"},null,0,0,0]

{"sheet":"G25 SPARES","index":25,"n_rows":34,"n_cols":12,"rows_kept":34,"merged":[[0,0,0,1],[1,0,1,1],[9,2,10,7],[9,8,10,10],[11,0,13,0],[11,1,13,1],[11,2,13,2],[11,4,13,4],[11,5,13,5],[11,6,13,6],[11,7,13,7],[11,9,13,9],[11,10,13,10],[11,11,13,11]]}
["BID PRICE SCHEDULE: APPENDIX G25"]
["(INCLUDING VALUE ADDED TAX)"]
["BIDDER:",{"$f":"Instructions!D3","v":"Bidder Company name"}]
["PROJECT:",{"$f":"Instructions!D4","v":"Portable VHF Radios"}]
["Item Nr:","G25"]
["SUB-PROJECT:","SPARES"]
["Foreign Currancy",{"$f":"'[1]Tenderer Info'!D4","v":"FC"}]
["ROE: 1R =",{"$f":"0.1","v":0.1}]
[]
[null,null,"Overseas Items",{"$nulls":5},"Local Items"]
[]
["Schedule Item Number","Description","Foreign Currency","Quantity","Foreign Amount Unit Cost","Foreign Amount  Total Cost","ROE: 1R = …","Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[]
["G6","SPARES"]
["G6.1"]
[null,"VHF Transceivers/Radios ",{"$f":"$B$7","v":"FC"},3,null,{"$f":"D18*E18","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G18<>0,F18/G18,0)","v":0},null,null,{"$f":"I18*J18","v":0},{"$f":"K18+H18","v":0}]
[null,"Antennas","FC",3,null,{"$f":"D19*E19","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G19<>0,F19/G19,0)","v":0},null,null,{"$f":"I19*J19","v":0},{"$f":"K19+H19","v":0}]
[null,"Microphones  ","FC",3,null,{"$f":"D20*E20","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G20<>0,F20/G20,0)","v":0},null,null,{"$f":"I20*J20","v":0},{"$f":"K20+H20","v":0}]
[null,"Batteries and Battery Charger ","FC",3,null,{"$f":"D21*E21","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G21<>0,F21/G21,0)","v":0},null,null,{"$f":"I21*J21","v":0},{"$f":"K21+H21","v":0}]
[null,"Radio Case (Including handles and car mounting kit)","FC",3,null,{"$f":"D22*E22","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G22<>0,F22/G22,0)","v":0},null,null,{"$f":"I22*J22","v":0},{"$f":"K22+H22","v":0}]
{"$rows_empty":11}
[null,"GRAND TOTAL :",null,null,{"$f":"SUM(E18:E22)","v":0},{"$f":"SUM(F18:F22)","v":0},null,{"$f":"SUM(H18:H22)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(J18:J22)","v":0},{"$f":"SUM(K18:K22)","v":0},{"$f":"SUM(L18:L22)","v":0}]

{"sheet":"G26_1 Support Contract","index":26,"n_rows":29,"n_cols":12,"rows_kept":29,"merged":[[0,0,0,1],[1,0,1,1],[9,2,10,7],[9,8,10,10],[11,0,13,0],[11,1,13,1],[11,2,13,2],[11,4,13,4],[11,5,13,5],[11,6,13,6],[11,7,13,7],[11,9,13,9],[11,10,13,10],[11,11,13,11]]}
["BID PRICE SCHEDULE: APPENDIX G25"]
["(INCLUDING VALUE ADDED TAX)"]
["BIDDER:",{"$f":"Instructions!D3","v":"Bidder Company name"}]
["PROJECT:",{"$f":"Instructions!D4","v":"Portable VHF Radios"}]
["Item Nr:","G26_1"]
["SUB-PROJECT:","Support Contract"]
["Foreign Currancy",{"$f":"'[1]Tenderer Info'!D4","v":"FC"}]
["ROE: 1R =",{"$f":"0.1","v":0.1}]
[]
[null,null,"Overseas Items",{"$nulls":5},"Local Items"]
[]
["Schedule Item Number","Description","Foreign Currency","Quantity","Foreign Amount Unit Cost","Foreign Amount  Total Cost","ROE: 1R = …","Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[]
["G26_1","Ad hoc support contract in base cost"]
[]
[null,"Year 1",{"$f":"$B$7","v":"FC"},null,null,{"$f":"D18*E18","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G18<>0,F18/G18,0)","v":0},null,null,{"$f":"I18*J18","v":0},{"$f":"K18+H18","v":0}]
[null,"Year 2","FC",null,null,{"$f":"D19*E19","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G19<>0,F19/G19,0)","v":0},null,null,{"$f":"I19*J19","v":0},{"$f":"K19+H19","v":0}]
[null,"Year 3","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Year 4","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Year 5","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Year 6","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Year 7","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Year 8","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Year 9","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Year 10","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,"GRAND TOTAL :",null,null,{"$f":"SUM(E18:E27)","v":0},{"$f":"SUM(F18:F27)","v":0},null,{"$f":"SUM(H18:H26)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(J18:J27)","v":0},{"$f":"SUM(K28:K28)+#REF!","v":{"$error":"#REF!"}},{"$f":"SUM(L28:L28)+#REF!","v":{"$error":"#REF!"}}]

{"sheet":"G26_2 Support Contract-Inflated","index":27,"n_rows":30,"n_cols":12,"rows_kept":30,"merged":[[0,0,0,1],[1,0,1,1],[9,2,10,7],[9,8,10,10],[11,0,13,0],[11,1,13,1],[11,2,13,2],[11,4,13,4],[11,5,13,5],[11,6,13,6],[11,7,13,7],[11,9,13,9],[11,10,13,10],[11,11,13,11]]}
["BID PRICE SCHEDULE: APPENDIX G25"]
["(INCLUDING VALUE ADDED TAX)"]
["BIDDER:",{"$f":"Instructions!D3","v":"Bidder Company name"}]
["PROJECT:",{"$f":"Instructions!D4","v":"Portable VHF Radios"}]
["Item Nr:","G26_1"]
["SUB-PROJECT:","Support Contract with inflation"]
["Foreign Currancy",{"$f":"'[1]Tenderer Info'!D4","v":"FC"}]
["ROE: 1R =",{"$f":"0.1","v":0.1}]
[]
[null,null,"Overseas Items",{"$nulls":5},"Local Items"]
[]
["Schedule Item Number","Description","Foreign Currency","Quantity","Foreign Amount Unit Cost","Foreign Amount  Total Cost","ROE: 1R = …","Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[]
["G26_2","Ad hoc support contract in base cost with inflation"]
[]
[null,"Year 1",{"$f":"$B$7","v":"FC"},null,null,{"$f":"D18*E18","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G18<>0,F18/G18,0)","v":0},null,null,{"$f":"I18*J18","v":0},{"$f":"K18+H18","v":0}]
[null,"Year 2","FC",null,null,{"$f":"D19*E19","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G19<>0,F19/G19,0)","v":0},null,null,{"$f":"I19*J19","v":0},{"$f":"K19+H19","v":0}]
[null,"Year 3","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Year 4","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Year 5","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Year 6","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Year 7","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Year 8","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Year 9","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Year 10","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[]
[null,"GRAND TOTAL :",null,null,{"$f":"SUM(E18:E27)","v":0},{"$f":"SUM(F18:F27)","v":0},null,{"$f":"SUM(H18:H27)","v":{"v":0,"d":"0.00"}},null,{"$f":"SUM(J18:J27)","v":0},{"$f":"SUM(K18:K27)","v":0},{"$f":"SUM(L18:L27)","v":0}]