{"text_format":"3","workbook":"xlsx","n_sheets":9,"sheets":["Instructions","G1 SUMMARY","G2_1 PMP","G2_2 ILS","G3 Supply","G4 Miscellaneous","G5 Options","G6_0 Support Contract (Base)","G6_1 Support Contract (Inflated"],"not_rendered":{"defined_names":11,"comments":2},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":18,"n_cols":4,"rows_kept":18,"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],[15,3,15,4],[16,3,16,4],[17,3,17,4]]}
[]
[]
[null,null,"TENDERER :","Tenderer  Company name"]
[null,null,"Project Name","ATNS/RFP09/03/2025/26/NAV_AIDS"]
[null,null,"Foreign Currency:","FC"]
[null,null,"ROE: 1R=",0.1]
[null,null,"Date:","2026-02-04"]
[]
[]
[null,null,"This file contains the following sheets:"]
[null,null,"G1 SUMMARY","Summary of all sheets."]
[null,null,"G2_1 PMP","Project management and associated costs."]
[null,null,"G2_2 ILS","Logistic Support and associated costs."]
[null,null,"G3_1 Supply","All items and associated cost on the equipment per site."]
[null,null,"G4 Miscellaneous","All miscellaneous items costs"]
[null,null,"G5 Options","All optional items and costs"]
[null,null,"G6_1 Support Contract (Base)","10 Year maintenance contract at base cost. Please provide details."]
[null,null,"G6_2 Support Contract (Inflated)","10 Year maintenance contract including inflation. Please provide details."]

{"sheet":"G1 SUMMARY","index":1,"n_rows":37,"n_cols":12,"rows_kept":37,"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,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]]}
["TENDER PRICE SCHEDULE: APPENDIX G1"]
[]
["TENDERER :",null,{"$f":"Instructions!D3","v":"Tenderer  Company name"}]
["DESCRIPTION :",null,{"$f":"Instructions!D4","v":"ATNS/RFP09/03/2025/26/NAV_AIDS"}]
["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",{"$f":"\"ROE: 1R = \"&C8","v":"ROE: 1R = 0.1"},"Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[]
["G2","SERVICES"]
["G2.1","Project Management",{"$nulls":3},{"$f":"'G2_1 PMP'!F54","v":0},null,{"$f":"'G2_1 PMP'!H54","v":0},null,null,{"$f":"'G2_1 PMP'!K54","v":0},{"$f":"'G2_1 PMP'!L54","v":0}]
["G2.2","Integrated Logistic Support",{"$nulls":3},{"$f":"'G2_2 ILS'!F57","v":0},null,{"$f":"'G2_2 ILS'!H57","v":0},null,null,{"$f":"'G2_2 ILS'!K57","v":0},{"$f":"'G2_2 ILS'!L57","v":0}]
[]
["G3","SUPPLY AND INSTALL"]
[{"$f":"'G3 Supply'!A17","v":"G3.1"},{"$f":"'G3 Supply'!B17","v":"Network Upgrade Components"},{"$nulls":3},{"$f":"'G3 Supply'!F17","v":0},null,{"$f":"'G3 Supply'!H17","v":0},null,null,{"$f":"'G3 Supply'!K17","v":0},{"$f":"'G3 Supply'!L17","v":0}]
[]
[]
["G4","MISCELLANEOUS",{"$nulls":3},{"$f":"'G4 Miscellaneous'!F42","v":0},null,{"$f":"'G4 Miscellaneous'!H42","v":0},null,null,{"$f":"'G4 Miscellaneous'!K42","v":0},{"$f":"'G4 Miscellaneous'!L42","v":0}]
[]
[]
[null,"TOTAL EQUIPMENT EXCLUDING OPTIONS :",{"$nulls":3},{"$f":"SUM(F15:F26)","v":0},null,{"$f":"SUM(H15:H26)","v":0},null,null,{"$f":"SUM(K15:K26)","v":0},{"$f":"SUM(L15:L26)","v":0}]
[]
["G5","OPTIONS",{"$nulls":3},{"$f":"'G5 Options'!F$61","v":0},null,{"$f":"'G5 Options'!H$61","v":0},null,null,{"$f":"'G5 Options'!K$61","v":0},{"$f":"'G5 Options'!L$61","v":0}]
[]
["G6.1","SUPPORT CONTRACT with Inflation",{"$nulls":3},{"$f":"'G6_1 Support Contract (Inflated'!F37","v":0},null,{"$f":"'G6_1 Support Contract (Inflated'!H37","v":0},null,null,{"$f":"'G6_1 Support Contract (Inflated'!K37","v":0},{"$f":"'G6_1 Support Contract (Inflated'!L37","v":0}]
[]
[null,"GRAND TOTAL :",{"$nulls":3},{"$f":"F29+F27+F31","v":0},null,{"$f":"H29+H27+H31","v":0},null,null,{"$f":"K29+K27+K31","v":0},{"$f":"L29+L27+L31","v":0}]
[]
[null,"VAT (15%)",null,{"v":0.15,"d":"15%"},{"$nulls":3},{"$f":"H33*D35","v":0},{"v":0.15,"d":"15%"},null,{"$f":"K33*I35","v":0},{"$f":"K35+H35","v":0}]
[]
[null,"GRAND TOTAL (Volume 1A Form of Bid):",{"$nulls":5},{"$f":"H33+H35","v":0},null,null,{"$f":"K33+K35","v":0},0]

{"sheet":"G2_1 PMP","index":2,"n_rows":54,"n_cols":12,"rows_kept":54,"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]]}
["TENDER PRICE SCHEDULE: APPENDIX G2.1"]
["(EXCLUDING VALUE ADDED TAX)"]
["TENDERER :",{"$f":"Instructions!D3","v":"Tenderer  Company name"}]
["PROJECT :",{"$f":"Instructions!D4","v":"ATNS/RFP09/03/2025/26/NAV_AIDS"}]
["Item Nr:","G2.1"]
["Item Description:","Project Management"]
["Foreign Currancy:",{"$f":"Instructions!D5","v":"FC"}]
["ROE: 1R =",{"$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",{"$f":"\"ROE: 1R = \"&B8","v":"ROE: 1R = 0.1"},"Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[{"$f":"B5","v":"G2.1"},{"$f":"B6","v":"Project Management"}]
[null,"{All project Management items, with at least the following items}"]
[]
["2.1.1","Documents:"]
[null,"Project Status Reports",{"$f":"$B$7","v":"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},1,null,{"$f":"I19*J19","v":0},{"$f":"IF(OR(J19>0,H19>0),H19+K19,0)","v":0}]
[null,"As-Built Drawings","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,"Master Project Schedule","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,"Safety Plan","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,null,"FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,null,"FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,null,"FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[]
["2.1.2","Acceptance Tests",{"$nulls":3},0]
[null,"Remote Sites",{"$f":"$B$7","v":"FC"},1,null,0,{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G28<>0,F28/G28,0)","v":0},1,null,{"$f":"I28*J28","v":0},{"$f":"IF(OR(J28>0,H28>0),H28+K28,0)","v":0}]
[null,"Maintenance Centres","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,null,{"$f":"$B$7","v":"FC"},1,null,{"$f":"D30*E30","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G30<>0,F30/G30,0)","v":0},1,null,{"$f":"I30*J30","v":0},{"$f":"IF(OR(J30>0,H30>0),H30+K30,0)","v":0}]
[null,null,"FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,null,"FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[]
["2.1.3","Project Management Services",{"$nulls":3},0]
[null,"All PM Services",{"$f":"$B$7","v":"FC"},1,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},1,null,{"$f":"I35*J35","v":0},{"$f":"IF(OR(J35>0,H35>0),H35+K35,0)","v":0}]
[null,"Network Topology Design ","FC",1,null,{"$f":"D36*E36","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G36<>0,F36/G36,0)","v":0},1,null,{"$f":"I36*J36","v":0},{"$f":"IF(OR(J36>0,H36>0),H36+K36,0)","v":0}]
[null,"Installation and Commissioning",{"$nulls":3},0]
[null,"Remote Sites","FC",1,null,{"$f":"D38*E38","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G38<>0,F38/G38,0)","v":0},1,null,{"$f":"I38*J38","v":0},{"$f":"IF(OR(J38>0,H38>0),H38+K38,0)","v":0}]
[null,"Maintenance Centres","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,null,"FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,null,"FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,null,"FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,"Decommissioning and Disposal"]
[null,"Remote Sites","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,"Maintenance Centres","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,null,"FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,null,"FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[]
["2.1.4","Shipping, Insurance & Associated costs"]
[null,"Shipping",{"$f":"$B$7","v":"FC"},1,null,{"$f":"D50*E50","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G50<>0,F50/G50,0)","v":0},1,null,{"$f":"I50*J50","v":0},{"$f":"IF(OR(J50>0,H50>0),H50+K50,0)","v":0}]
[null,"Insurance","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,null,"FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[]
[null,{"$f":"+\"SUB-TOTAL:  \"&A15","v":"SUB-TOTAL:  G2.1"},{"$nulls":3},{"$f":"SUM(F15:F52)","v":0},null,{"$f":"SUM(H15:H52)","v":0},null,null,{"$f":"SUM(K15:K52)","v":0},{"$f":"SUM(L15:L52)","v":0}]

{"sheet":"G2_2 ILS","index":3,"n_rows":57,"n_cols":12,"rows_kept":57,"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]]}
["TENDER PRICE SCHEDULE: APPENDIX G2.2"]
["(EXCLUDING VALUE ADDED TAX)"]
["TENDERER :",{"$f":"Instructions!D3","v":"Tenderer  Company name"}]
["PROJECT :",{"$f":"Instructions!D4","v":"ATNS/RFP09/03/2025/26/NAV_AIDS"}]
["Item Nr:","G2.2"]
["Item Description:","Integrated Logistic Support"]
["Foreign Currancy:",{"$f":"Instructions!D5","v":"FC"}]
["ROE: 1R =",{"$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",{"$f":"\"ROE: 1R = \"&B8","v":"ROE: 1R = 0.1"},"Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[{"$f":"B5","v":"G2.2"},{"$f":"B6","v":"Integrated Logistic Support"}]
[null,"{ All logistic support items with at least the following items}"]
[]
["2.2.1","Logistic Support Services"]
[null,"Logistic Support",{"$f":"$B$7","v":"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},1,null,{"$f":"I19*J19","v":0},{"$f":"IF(OR(J19>0,H19>0),H19+K19,0)","v":0}]
[null,"Training","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,null,"FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,null,"FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,null,"FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,null,"FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[]
["2.2.2","Documents"]
[null,"Integrated Logistic Support Plan",{"$f":"$B$7","v":"FC"},1,null,{"$f":"D27*E27","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G27<>0,F27/G27,0)","v":0},1,null,{"$f":"I27*J27","v":0},{"$f":"IF(OR(J27>0,H27>0),H27+K27,0)","v":0}]
[null,null,"FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,null,"FC",1,null,{"$f":"D29*E29","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G29<>0,F29/G29,0)","v":0},1,null,{"$f":"I29*J29","v":0},0]
[null,null,"FC",1,null,{"$f":"D30*E30","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G30<>0,F30/G30,0)","v":0},1,null,{"$f":"I30*J30","v":0},0]
[null,null,"FC",1,null,{"$f":"D31*E31","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G31<>0,F31/G31,0)","v":0},1,null,{"$f":"I31*J31","v":0},0]
[null,null,"FC",1,null,{"$f":"D32*E32","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G32<>0,F32/G32,0)","v":0},1,null,{"$f":"I32*J32","v":0},0]
[null,null,"FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,null,"FC",1,null,{"$f":"D34*E34","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G34<>0,F34/G34,0)","v":0},1,null,{"$f":"I34*J34","v":0},{"$f":"IF(OR(J34>0,H34>0),H34+K34,0)","v":0}]
[]
["2.2.3","Spares"]
[null,null,"FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,null,"FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,null,"FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,null,"FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,null,"FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,null,"FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,null,"FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,null,"FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,null,"FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[]
["2.2.4","Warranty"]
[null,null,{"$f":"$B$7","v":"FC"},1,null,0,{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},0,1,null,0,{"$f":"IF(OR(J48>0,H48>0),H48+K48,0)","v":0}]
[null,null,"FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,null,"FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,null,"FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,null,"FC",1,null,{"$f":"D52*E52","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G52<>0,F52/G52,0)","v":0},1,null,{"$f":"I52*J52","v":0},0]
[null,null,"FC",1,null,{"$f":"D53*E53","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G53<>0,F53/G53,0)","v":0},1,null,{"$f":"I53*J53","v":0},0]
[null,null,"FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,null,"FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[]
[null,{"$f":"+\"SUB-TOTAL:  \"&A15","v":"SUB-TOTAL:  G2.2"},null,null,{"$f":"SUM(E15:E55)","v":0},{"$f":"SUM(F15:F55)","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"SUM(H15:H55)","v":0},null,{"$f":"SUM(J15:J55)","v":0},{"$f":"SUM(K15:K55)","v":0},{"$f":"SUM(L15:L55)","v":0}]

{"sheet":"G3 Supply","index":4,"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]]}
["TENDER PRICE SCHEDULE: APPENDIX G3.1"]
["(EXCLUDING VALUE ADDED TAX)"]
["TENDERER :",{"$f":"Instructions!D3","v":"Tenderer  Company name"}]
["PROJECT :",{"$f":"Instructions!D4","v":"ATNS/RFP09/03/2025/26/NAV_AIDS"}]
["Item Nr:","G3"]
["Item Description:","CCTV"]
["Foreign Currancy:",{"$f":"Instructions!D5","v":"FC"}]
["ROE: 1R =",{"$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",{"$f":"\"ROE: 1R = \"&B8","v":"ROE: 1R = 0.1"},"Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[{"$f":"B5","v":"G3"},"SUPPLY AND INSTALL"]
[null,"(All equipment as required, with at least the following headings.)"]
["G3.1","Network Upgrade Components",{"$nulls":3},{"$f":"SUM(F19:F27)","v":0},null,{"$f":"SUM(H19:H27)","v":0},null,null,{"$f":"SUM(K19:K27)","v":0},{"$f":"SUM(L19:L27)","v":0}]
[]
[]
["G3.1.1","TSAT3500 modem (RT) (VOR/DVOR Sites)",null,36,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},{"$f":"D20","v":36},null,{"$f":"I20*J20","v":0},{"$f":"IF(OR(J20>0,H20>0),H20+K20,0)","v":0}]
["G3.1.2","TSAT3500 modem (RT) (DME-DME Sites)",null,10,null,{"$f":"D21*E21","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G21<>0,F21/G21,0)","v":0},{"$f":"D21","v":10},null,{"$f":"I21*J21","v":0},{"$f":"IF(OR(J21>0,H21>0),H21+K21,0)","v":0}]
["G3.1.3","Spare TSAT3500 modem",null,10,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},{"$f":"D22","v":10},null,{"$f":"I22*J22","v":0},{"$f":"IF(OR(J22>0,H22>0),H22+K22,0)","v":0}]
["G3.1.4","Installation Material (46 Sites)",null,46,null,{"$f":"D23*E23","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G23<>0,F23/G23,0)","v":0},{"$f":"D23","v":46},null,{"$f":"I23*J23","v":0},{"$f":"IF(OR(J23>0,H23>0),H23+K23,0)","v":0}]
["G3.1.5","Spare TSAT3500 HUB",null,2,null,0,{"v":0.1,"d":"0.10000"},0,2,null,0,0]
["G3.1.6","Workstations (Supervisory Terminal)",null,2,null,{"$f":"D25*E25","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G25<>0,F25/G25,0)","v":0},{"$f":"D25","v":2},null,{"$f":"I25*J25","v":0},{"$f":"IF(OR(J25>0,H25>0),H25+K25,0)","v":0}]
["G3.1.7","Network Topology Reconfiguration",null,1,null,{"$f":"D26*E26","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G26<>0,F26/G26,0)","v":0},{"$f":"D26","v":1},null,{"$f":"I26*J26","v":0},{"$f":"IF(OR(J26>0,H26>0),H26+K26,0)","v":0}]
[]
[]
[null,{"$f":"+\"SUB-TOTAL:  \"&A15","v":"SUB-TOTAL:  G3"},{"$nulls":3},{"$f":"SUM(F19:F28)","v":0},null,{"$f":"SUM(H19:H28)","v":0},null,null,{"$f":"SUM(K19:K28)","v":0},0]

{"sheet":"G4 Miscellaneous","index":5,"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]]}
["TENDER PRICE SCHEDULE: APPENDIX G4"]
["(EXCLUDING VALUE ADDED TAX)"]
["TENDERER :",{"$f":"Instructions!D3","v":"Tenderer  Company name"}]
["PROJECT :",{"$f":"Instructions!D4","v":"ATNS/RFP09/03/2025/26/NAV_AIDS"}]
["Item Nr:","G4"]
["Item Description:","MISCELLANEOUS"]
["Foreign Currancy:",{"$f":"Instructions!D5","v":"FC"}]
["ROE: 1R =",{"$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",{"$f":"\"ROE: 1R = \"&B8","v":"ROE: 1R = 0.1"},"Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[{"$f":"B5","v":"G4"},{"$f":"B6","v":"MISCELLANEOUS"}]
[null,"(Items and services necessary for the installation, commissioning, operation and maintenance of the system and not included elsewhere.)"]
[null,"(To be individually itemized and priced.)"]
[]
[4.1]
[null,null,{"$f":"$B$7","v":"FC"},null,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":"IF(OR(J20>0,H20>0),H20+K20,0)","v":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,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,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,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,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,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,null,"FC",null,null,{"$f":"D39*E39","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G39<>0,F39/G39,0)","v":0},null,null,{"$f":"I39*J39","v":0},0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,{"$f":"+\"SUB-TOTAL:  \"&A15","v":"SUB-TOTAL:  G4"},null,null,{"$f":"SUM(E20:E40)","v":0},{"$f":"SUM(F20:F40)","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"SUM(H20:H40)","v":0},null,{"$f":"SUM(J20:J40)","v":0},{"$f":"SUM(K20:K40)","v":0},{"$f":"SUM(L20:L40)","v":0}]

{"sheet":"G5 Options","index":6,"n_rows":61,"n_cols":12,"rows_kept":61,"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,3,13,3],[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]]}
["TENDER PRICE SCHEDULE: APPENDIX G5"]
["(EXCLUDING VALUE ADDED TAX)"]
["TENDERER :",{"$f":"Instructions!D3","v":"Tenderer  Company name"}]
["PROJECT :",{"$f":"Instructions!D4","v":"ATNS/RFP09/03/2025/26/NAV_AIDS"}]
["Item Nr:","G5"]
["Item Description:","OPTIONS"]
["Foreign Currancy:",{"$f":"Instructions!D5","v":"FC"}]
["ROE: 1R =",{"$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",{"$f":"\"ROE: 1R = \"&B8","v":"ROE: 1R = 0.1"},"Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[{"$f":"B5","v":"G5"},{"$f":"B6","v":"OPTIONS"}]
["G5.1"]
[null,"TSAT3500 modem (RT) Option for FAGG DME-DME Site",{"$f":"$B$7","v":"FC"},6,null,{"$f":"D17*E17","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G17<>0,F17/G17,0)","v":0},6,null,{"$f":"I17*J17","v":0},{"$f":"IF(OR(J17>0,H17>0),H17+K17,0)","v":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,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,null,"FC",null,null,{"$f":"D24*E24","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G24<>0,F24/G24,0)","v":0},null,null,{"$f":"I24*J24","v":0},{"$f":"IF(OR(J24>0,H24>0),H24+K24,0)","v":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,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,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,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,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,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,{"$f":"D41*E41","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G41<>0,F41/G41,0)","v":0},null,null,{"$f":"I41*J41","v":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,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,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,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,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,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,{"$f":"+\"SUB-TOTAL:  \"&A15","v":"SUB-TOTAL:  G5"},null,null,{"$f":"SUM(E17:E60)","v":0},{"$f":"SUM(F17:F60)","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"SUM(H17:H60)","v":0},null,{"$f":"SUM(J17:J60)","v":0},0,{"$f":"SUM(L17:L60)","v":0}]

{"sheet":"G6_0 Support Contract (Base)","index":7,"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]]}
["TENDER PRICE SCHEDULE: APPENDIX G6"]
["(EXCLUDING VALUE ADDED TAX)"]
["TENDERER :",{"$f":"Instructions!D3","v":"Tenderer  Company name"}]
["PROJECT :",{"$f":"Instructions!D4","v":"ATNS/RFP09/03/2025/26/NAV_AIDS"}]
["Item Nr:","G6.0"]
["Item Description:","Support Contract in base cost"]
["Foreign Currancy:",{"$f":"Instructions!D5","v":"FC"}]
["ROE: 1R =",{"$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",{"$f":"\"ROE: 1R = \"&B8","v":"ROE: 1R = 0.1"},"Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[{"$f":"B5","v":"G6.0"},{"$f":"B6","v":"Support Contract in base cost"}]
[null,"{Details of the proposed maintenance contract must be included on this price schedule}"]
[]
[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":"IF(OR(J18>0,H18>0),H18+K18,0)","v":0}]
[null,"Year 2","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,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,"Year 11","FC",null,null,{"$f":"D28*E28","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G28<>0,F28/G28,0)","v":0},null,null,{"$f":"I28*J28","v":0},{"$f":"IF(OR(J28>0,H28>0),H28+K28,0)","v":0}]
[null,"Year 12","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Year 13","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Year 14","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Year 15","FC",null,null,{"$f":"D32*E32","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G32<>0,F32/G32,0)","v":0},null,null,{"$f":"I32*J32","v":0},{"$f":"IF(OR(J32>0,H32>0),H32+K32,0)","v":0}]
[]
[null,{"$f":"+\"SUB-TOTAL:  \"&A15","v":"SUB-TOTAL:  G6.0"},null,null,{"$f":"SUM(E18:E33)","v":0},{"$f":"SUM(F18:F33)","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"SUM(H18:H33)","v":0},null,{"$f":"SUM(J18:J33)","v":0},{"$f":"SUM(K18:K33)","v":0},{"$f":"SUM(L18:L33)","v":0}]

{"sheet":"G6_1 Support Contract (Inflated","index":8,"n_rows":37,"n_cols":12,"rows_kept":37,"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]]}
["TENDER PRICE SCHEDULE: APPENDIX G6"]
["(EXCLUDING VALUE ADDED TAX)"]
["TENDERER :",{"$f":"Instructions!D3","v":"Tenderer  Company name"}]
["PROJECT :",{"$f":"Instructions!D4","v":"ATNS/RFP09/03/2025/26/NAV_AIDS"}]
["Item Nr:","G6.1"]
["Item Description:","Support Contract with Inflation"]
["Foreign Currancy:",{"$f":"Instructions!D5","v":"FC"}]
["ROE: 1R =",{"$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",{"$f":"\"ROE: 1R = \"&B8","v":"ROE: 1R = 0.1"},"Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[{"$f":"B5","v":"G6.1"},{"$f":"B6","v":"Support Contract with Inflation"}]
[null,"{Details of the proposed maintenance contract must be included on this price schedule}"]
[]
[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":"IF(OR(J18>0,H18>0),H18+K18,0)","v":0}]
[null,"Year 2","FC",null,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":"IF(OR(J19>0,H19>0),H19+K19,0)","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,"Year 11","FC",null,null,{"$f":"D28*E28","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G28<>0,F28/G28,0)","v":0},null,null,{"$f":"I28*J28","v":0},{"$f":"IF(OR(J28>0,H28>0),H28+K28,0)","v":0}]
[null,"Year 12","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Year 13","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Year 14","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Year 15","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[]
[]
[]
[null,{"$f":"+\"SUB-TOTAL:  \"&A15","v":"SUB-TOTAL:  G6.1"},null,null,{"$f":"SUM(E18:E36)","v":0},{"$f":"SUM(F18:F36)","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"SUM(H18:H36)","v":0},null,{"$f":"SUM(J18:J36)","v":0},{"$f":"SUM(K18:K36)","v":0},{"$f":"SUM(L18:L36)","v":0}]