{"text_format":"3","workbook":"xlsx","n_sheets":9,"sheets":["Instructions","G1 Summary","G2_1 PM","G2_2 ILS","G3_Simulator","G4_Options","G5_Support_Base","G6_1_Support_Inflated","G6_2_Midlife_Upgrade"],"not_rendered":{"defined_names":8},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":23,"n_cols":4,"rows_kept":23,"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,"BIDDER :","Bidder Company name"]
[null,null,"Project Name","RADSIM Replacement Project"]
[null,null,"Foreign Currency:","FC"]
[null,null,"ROE: 1R=",0.1]
[null,null,"Date:"]
[]
[]
[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_Simulator","All material, software and equipment items and associated cost for the simulator"]
[null,null,"G4 Options","All optional items and associated costs"]
[null,null,"G5_Support_Base","All maintenance and support items and associated costs in base cost"]
[null,null,"G6_1_Support_Inflated","All maintenance and support items and associated costs with inflation"]
[null,null,"G6_2_Midlife_Upgrade","All mid-life upgrade items and associated costs"]
[]
[]
[]
[null,null,"VAT SHALL BE CLEARLY INDICATED ON THE G1 SUMMARY SHEET"]
[null,null,"THE BIDDER SHALL BE RESPONSIBLE FOR VERIFYING THAT THERE ARE NO ERRORS IN QUANTITIES, PRICING, CALCULATIONS AND TOTALS AS INDICATED ON THEIR SUBMITTED PRICING SCHEDULE"]

{"sheet":"G1 Summary","index":1,"n_rows":39,"n_cols":12,"rows_kept":39,"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"]
["(INCLUDING VALUE ADDED TAX)"]
["BIDDER :",null,{"$f":"Instructions!D3","v":"Bidder Company name"}]
["DESCRIPTION :",null,{"$f":"Instructions!D4","v":"RADSIM Replacement Project"}]
["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"]
[]
[]
[]
["G2","SERVICES"]
["G2.1","Project Management",{"$f":"$C$7","v":"FC"},null,{"$f":"'G2_1 PM'!E57","v":0},{"$f":"'G2_1 PM'!F57","v":0},{"$f":"'G2_1 PM'!G57","v":{"v":0.1,"d":"0.10"}},{"$f":"'G2_1 PM'!H57","v":0},null,{"$f":"'G2_1 PM'!J57","v":0},{"$f":"'G2_1 PM'!K57","v":0},{"$f":"'G2_1 PM'!L57","v":0}]
["G2.2","Integrated Logistic Support",{"$f":"$C$7","v":"FC"},null,{"$f":"'G2_2 ILS'!E57","v":0},{"$f":"'G2_2 ILS'!F57","v":0},{"$f":"'G2_2 ILS'!G57","v":{"v":0.1,"d":"0.10"}},{"$f":"'G2_2 ILS'!H57","v":0},null,{"$f":"'G2_2 ILS'!J57","v":0},{"$f":"'G2_2 ILS'!K57","v":0},{"$f":"'G2_2 ILS'!L57","v":0}]
[]
["G3","MATERIALS AND EQUIPMENT"]
["G3","Simulator",{"$f":"$C$7","v":"FC"},null,{"$f":"G3_Simulator!E113","v":0},{"$f":"G3_Simulator!F113","v":0},{"$f":"G3_Simulator!G113","v":{"v":0.1,"d":"0.10"}},{"$f":"G3_Simulator!H113","v":0},null,{"$f":"G3_Simulator!J113","v":0},{"$f":"G3_Simulator!K113","v":0},{"$f":"G3_Simulator!L113","v":0}]
[]
[null,"TOTAL EXCLUDING OPTIONS :",{"$f":"$C$7","v":"FC"},null,{"$f":"SUM(E17,E18,E21)","v":0},{"$f":"SUM(F17,F18,F21)","v":0},null,{"$f":"SUM(H17,H18,H21)","v":0},null,{"$f":"SUM(J17,J18,J21)","v":0},{"$f":"SUM(K17,K18,K21)","v":0},{"$f":"SUM(L17,L18,L21)","v":0}]
[]
["G4","OPTIONS",{"$f":"$C$7","v":"FC"},null,{"$f":"G4_Options!E$45","v":0},{"$f":"G4_Options!F$45","v":0},{"$f":"G4_Options!G$45","v":{"v":0.1,"d":"0.10"}},{"$f":"G4_Options!H$45","v":0},null,{"$f":"G4_Options!J$45","v":0},{"$f":"G4_Options!K$45","v":0},{"$f":"G4_Options!L$45","v":0}]
[]
[null,"TOTAL INCLUDING OPTIONS",{"$f":"$C$7","v":"FC"},null,{"$f":"E23+E25","v":0},{"$f":"F23+F25","v":0},null,{"$f":"H23+H25","v":0},null,{"$f":"J23+J25","v":0},{"$f":"K23+K25","v":0},{"$f":"L23+L25","v":0}]
[]
["G6","SUPPORT"]
["G6.1","Support (Inflated)",{"$f":"$C$7","v":"FC"},null,{"$f":"G6_1_Support_Inflated!E61","v":0},{"$f":"G6_1_Support_Inflated!F61","v":0},{"$f":"G6_1_Support_Inflated!G61","v":{"v":0.1,"d":"0.10"}},{"$f":"G6_1_Support_Inflated!H61","v":0},null,{"$f":"G6_1_Support_Inflated!J61","v":0},{"$f":"G6_1_Support_Inflated!K61","v":0},{"$f":"G6_1_Support_Inflated!L61","v":0}]
["G6.2","Midlife Upgrade",{"$f":"$C$7","v":"FC"},null,{"$f":"G6_2_Midlife_Upgrade!E49","v":0},{"$f":"G6_2_Midlife_Upgrade!F49","v":0},{"$f":"G6_2_Midlife_Upgrade!G49","v":{"v":0.1,"d":"0.10"}},{"$f":"G6_2_Midlife_Upgrade!H49","v":0},null,{"$f":"G6_2_Midlife_Upgrade!J49","v":0},{"$f":"G6_2_Midlife_Upgrade!K49","v":0},{"$f":"G6_2_Midlife_Upgrade!L49","v":0}]
[null,"TOTAL SUPPORT :",{"$f":"$C$7","v":"FC"},null,{"$f":"SUM(E30:E31)","v":0},{"$f":"SUM(F30:F31)","v":0},null,{"$f":"SUM(H30:H31)","v":0},null,{"$f":"SUM(J30:J31)","v":0},{"$f":"SUM(K30:K31)","v":0},{"$f":"SUM(L30:L31)","v":0}]
[]
[null,"GRAND TOTAL INCLUDING SUPPORT",{"$f":"$C$7","v":"FC"},null,{"$f":"E32+E23","v":0},{"$f":"F32+F23","v":0},null,{"$f":"H32+H23","v":0},null,0,0,0]
[null,"GRAND TOTAL INCLUDING SUPPORT AND OPTIONS",{"$f":"$C$7","v":"FC"},null,{"$f":"E25+E34","v":0},{"$f":"F25+F34","v":0},null,{"$f":"H25+H34","v":0},null,{"$f":"J25+J34","v":0},{"$f":"K25+K34","v":0},{"$f":"L25+L34","v":0}]
[]
[null,"VAT (15%)",{"$f":"$C$7","v":"FC"},null,{"$f":"E35*0.15","v":0},{"$f":"F35*0.15","v":0},null,0,null,0,0,0]
[]
[null,"GRAND TOTAL INCLUDING SUPPORT, OPTIONS AND VAT","FC",null,{"$f":"E37+E35","v":0},{"$f":"F37+F35","v":0},null,{"$f":"H37+H35","v":0},null,{"$f":"J37+J35","v":0},{"$f":"K37+K35","v":0},{"$f":"L37+L35","v":0}]

{"sheet":"G2_1 PM","index":2,"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.1"]
["(INCLUDE VALUE ADDED TAX ON SHEET \"G1: SUMMARY\")"]
["BIDDER :",{"$f":"Instructions!D3","v":"Bidder Company name"}]
["PROJECT :",{"$f":"Instructions!D4","v":"RADSIM Replacement Project"}]
["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","ROE: 1R = …","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 Management Plan",{"$f":"$B$7","v":"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":"IF(OR(J19>0,H19>0),H19+K19,0)","v":0}]
[null,"Master Project Schedule","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Work Breakdown Structure","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Resource Allocation Plan","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Test and Evaluation Master Plan","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Installation, Transitioning and Commissioning Plan","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Quality Assurance Plan","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Risk Management Plan","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]
[]
["2.1.2","Acceptance Tests",{"$nulls":3},0]
[null,"Factory Acceptance Test (Design Acceptance)",{"$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":"IF(OR(J32>0,H32>0),H32+K32,0)","v":0}]
[null,null,"FC",null,null,{"$f":"D33*E33","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G33<>0,F33/G33,0)","v":0},null,null,{"$f":"I33*J33","v":0},{"$f":"IF(OR(J33>0,H33>0),H33+K33,0)","v":0}]
[null,null,"FC",null,null,{"$f":"D34*E34","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G34<>0,F34/G34,0)","v":0},null,null,{"$f":"I34*J34","v":0},{"$f":"IF(OR(J34>0,H34>0),H34+K34,0)","v":0}]
[null,null,"FC",null,null,{"$f":"D35*E35","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G35<>0,F35/G35,0)","v":0},null,null,{"$f":"I35*J35","v":0},{"$f":"IF(OR(J35>0,H35>0),H35+K35,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]
[]
["2.1.3","Project Management Services",{"$nulls":3},0]
[null,"All PM Services",{"$f":"$B$7","v":"FC"},null,null,{"$f":"D42*E42","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G42<>0,F42/G42,0)","v":0},null,null,{"$f":"I42*J42","v":0},{"$f":"IF(OR(J42>0,H42>0),H42+K42,0)","v":0}]
[null,"Decommissioning and Disposal","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Installation and Commissioning","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]
[]
["2.1.4","Shipping, Insurance & Associated costs"]
[null,"Shipping",{"$f":"$B$7","v":"FC"},null,null,{"$f":"D49*E49","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G49<>0,F49/G49,0)","v":0},null,null,{"$f":"I49*J49","v":0},{"$f":"IF(OR(J49>0,H49>0),H49+K49,0)","v":0}]
[null,"Insurance","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:  G2.1"},null,null,{"$f":"SUM(E15:E56)","v":0},{"$f":"SUM(F15:F56)","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"SUM(H15:H56)","v":0},null,{"$f":"SUM(J15:J56)","v":0},{"$f":"SUM(K15:K56)","v":0},{"$f":"SUM(L15:L56)","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"]
["(INCLUDE VALUE ADDED TAX ON SHEET \"G1: SUMMARY\")"]
["BIDDER :",{"$f":"Instructions!D3","v":"Bidder Company name"}]
["PROJECT :",{"$f":"Instructions!D4","v":"RADSIM Replacement Project"}]
["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","ROE: 1R = …","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"},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":"IF(OR(J19>0,H19>0),H19+K19,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]
[]
["2.2.2","Documents"]
[null,"Integrated Logistic Support Plan",{"$f":"$B$7","v":"FC"},null,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},null,null,{"$f":"I27*J27","v":0},{"$f":"IF(OR(J27>0,H27>0),H27+K27,0)","v":0}]
[null,"As Built Documents","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Other documents","FC",null,null,{"$f":"D29*E29","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G29<>0,F29/G29,0)","v":0},null,null,{"$f":"I29*J29","v":0},0]
[null,null,"FC",null,null,{"$f":"D30*E30","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G30<>0,F30/G30,0)","v":0},null,null,{"$f":"I30*J30","v":0},0]
[null,null,"FC",null,null,{"$f":"D31*E31","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G31<>0,F31/G31,0)","v":0},null,null,{"$f":"I31*J31","v":0},0]
[null,null,"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},0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,{"$f":"D34*E34","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G34<>0,F34/G34,0)","v":0},null,null,{"$f":"I34*J34","v":0},{"$f":"IF(OR(J34>0,H34>0),H34+K34,0)","v":0}]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
["2.2.3","Spares"]
[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]
[]
["2.2.4","Warranty"]
[null,null,{"$f":"$B$7","v":"FC"},null,null,0,{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},0,null,null,0,{"$f":"IF(OR(J48>0,H48>0),H48+K48,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,{"$f":"D52*E52","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G52<>0,F52/G52,0)","v":0},null,null,{"$f":"I52*J52","v":0},0]
[null,null,"FC",null,null,{"$f":"D53*E53","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G53<>0,F53/G53,0)","v":0},null,null,{"$f":"I53*J53","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,{"$f":"+\"SUB-TOTAL:  \"&A15","v":"SUB-TOTAL:  G2.2"},null,null,{"$f":"SUM(E15:E56)","v":0},{"$f":"SUM(F15:F56)","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"SUM(H15:H56)","v":0},null,{"$f":"SUM(J15:J56)","v":0},{"$f":"SUM(K15:K56)","v":0},{"$f":"SUM(L15:L56)","v":0}]

{"sheet":"G3_Simulator","index":4,"n_rows":113,"n_cols":12,"rows_kept":113,"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"]
["(INCLUDE VALUE ADDED TAX ON SHEET \"G1: SUMMARY\")"]
["BIDDER :",{"$f":"Instructions!D3","v":"Bidder Company name"}]
["PROJECT :",{"$f":"Instructions!D4","v":"RADSIM Replacement Project"}]
["Item Nr:","G3"]
["Item Description:","SIMULATOR"]
["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\n{Equipment Common to all site}","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"]
[]
[]
[{"$f":"B5","v":"G3"},{"$f":"B6","v":"SIMULATOR"}]
["3.1","Hardware"]
[null,"{List all hardware required for the simulator- include relevant product information and quantities}"]
[null,"Power Supply Unit/s",{"$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,"Simulator Server/s","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Circuit Breaker/s","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"VCCS Configuration Equipment","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Flight Strip Printer","FC",4,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Equipment Cabinet","FC",1,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":"IF(OR(J23>0,H23>0),H23+K23,0)","v":0}]
[null,"Power Distribution Unit","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Headset Earpad (Pair)","FC",500,null,{"$f":"D25*E25","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G25<>0,F25/G25,0)","v":0},null,null,{"$f":"I25*J25","v":0},{"$f":"IF(OR(J25>0,H25>0),H25+K25,0)","v":0}]
[null,"Network Switch/es","FC",null,null,{"$f":"D26*E26","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G26<>0,F26/G26,0)","v":0},null,null,{"$f":"I26*J26","v":0},{"$f":"IF(OR(J26>0,H26>0),H26+K26,0)","v":0}]
[null,"Patch/ Brush Panel/s","FC",null,null,{"$f":"D27*E27","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G27<>0,F27/G27,0)","v":0},null,null,{"$f":"I27*J27","v":0},{"$f":"IF(OR(J27>0,H27>0),H27+K27,0)","v":0}]
[null,"Fibre Links","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Power Cables","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Network Cables","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Recording and Playback System","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Management and Control Equipment","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,{"$f":"D33*E33","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G33<>0,F33/G33,0)","v":0},null,null,{"$f":"I33*J33","v":0},{"$f":"IF(OR(J33>0,H33>0),H33+K33,0)","v":0}]
[]
["3.1.1","Controller Working Positions"]
[null,"Air Situational Display","FC",4,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Left-Side Auxiliary Display","FC",4,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Right-Side Auxiliary Display","FC",4,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"46\" Map Display","FC",4,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"VCCS","FC",4,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Audio Box","FC",8,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Controller Headset","FC",16,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Flight Strip Board","FC",4,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Keyboard","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,4,null,0,0]
[null,"Mouse","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,4,null,0,0]
[null,"Footswitch","FC",4,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,{"$f":"D47*E47","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G47<>0,F47/G47,0)","v":0},null,null,{"$f":"I47*J47","v":0},{"$f":"IF(OR(J47>0,H47>0),H47+K47,0)","v":0}]
[]
["3.1.2","Pseudo-Pilot Positions"]
[null,"Air Situational Display","FC",8,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Right-Side Auxiliary Display","FC",8,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"VCCS","FC",8,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Audio Box","FC",16,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Controller Headset","FC",32,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Keyboard","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,8,null,0,0]
[null,"Mouse","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,8,null,0,0]
[null,"Footswitch","FC",8,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,{"$f":"D58*E58","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G58<>0,F58/G58,0)","v":0},null,null,{"$f":"I58*J58","v":0},{"$f":"IF(OR(J58>0,H58>0),H58+K58,0)","v":0}]
[]
["3.1.3","Instructor Positions"]
[null,"Air Situational Display","FC",4,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Right-Side Auxiliary Display","FC",4,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"VCCS","FC",4,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Audio Box","FC",8,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Controller Headset","FC",8,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Instructor Headset","FC",8,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Keyboard","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,4,null,0,0]
[null,"Mouse","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,4,null,0,0]
[null,"Footswitch","FC",4,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,{"$f":"$B$7","v":"FC"},null,null,0,{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},0,null,null,0,0]
[]
["3.2","Software"]
[null,"{List all software required for the simulator}",{"$f":"$B$7","v":"FC"},null,null,{"$f":"D73*E73","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G73<>0,F73/G73,0)","v":0},null,null,{"$f":"I73*J73","v":0},{"$f":"IF(OR(J73>0,H73>0),H73+K73,0)","v":0}]
[null,"Simulator software","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Development software","FC",1,null,{"$f":"D75*E75","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G75<>0,F75/G75,0)","v":0},null,null,{"$f":"I75*J75","v":0},{"$f":"IF(OR(J75>0,H75>0),H75+K75,0)","v":0}]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
["3.3","Consoles"]
[null,"(All equipment as required, with at least the following headings.)"]
[null,"Consoles Designs",{"$f":"$B$7","v":"FC"},16,null,{"$f":"D80*E80","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G80<>0,F80/G80,0)","v":0},null,null,{"$f":"I80*J80","v":0},{"$f":"IF(OR(J80>0,H80>0),H80+K80,0)","v":0}]
[null,"Controller Consoles","FC",4,null,{"$f":"D81*E81","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G81<>0,F81/G81,0)","v":0},null,null,{"$f":"I81*J81","v":0},{"$f":"IF(OR(J81>0,H81>0),H81+K81,0)","v":0}]
[null,"Instructor Consoles","FC",4,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Pseudo-Pilot Consoles","FC",8,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Integrated Flight Strip Board","FC",4,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Display/ Monitor Mounting Arms","FC",12,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Map Display Mounting bracket","FC",4,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Equipment Storage Section","FC",16,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Maintenance Light","FC",16,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Cable Management System","FC",16,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Console Distribution Board","FC",16,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Rotary Isolator Switch","FC",16,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Power Distribution Units","FC",32,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"VCCS Mounting Bracket","FC",4,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"VCCS Mounting Module","FC",12,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,{"$f":"D95*E95","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G95<>0,F95/G95,0)","v":0},null,null,{"$f":"I95*J95","v":0},{"$f":"IF(OR(J95>0,H95>0),H95+K95,0)","v":0}]
[]
["3.4","Simulator Room Requirments"]
[null,"{List all items and services related to the simulator room preparation/ refurbishment}",{"$nulls":3},{"$f":"D98*E98","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G98<>0,F98/G98,0)","v":0},null,null,{"$f":"I98*J98","v":0},{"$f":"IF(OR(J98>0,H98>0),H98+K98,0)","v":0}]
[null,"Light Fittings",{"$f":"$B$7","v":"FC"},null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Ventilation grills","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,25,null,0,0]
[{"$nulls":5},0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
["3.5","Licenses"]
[null,"{List all individual licenses required for the software and hardware of the simulator system.}"]
[null,null,{"$f":"$B$7","v":"FC"},null,null,{"$f":"D105*E105","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G105<>0,F105/G105,0)","v":0},null,null,{"$f":"I105*J105","v":0},{"$f":"IF(OR(J105>0,H105>0),H105+K105,0)","v":0}]
[]
["3.6","Miscellaneous"]
[null,"{List 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.)"]
[null,"Flight Strip Paper Rolls (±25mm x ±145mm)",{"$f":"$B$7","v":"FC"},2000,null,{"$f":"D110*E110","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G110<>0,F110/G110,0)","v":0},null,null,{"$f":"I110*J110","v":0},{"$f":"IF(OR(J110>0,H110>0),H110+K110,0)","v":0}]
[null,"Flight Strip Paper Rolls (±25mm x ±200mm)","FC",2000,null,{"$f":"D111*E111","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G111<>0,F111/G111,0)","v":0},null,null,{"$f":"I111*J111","v":0},{"$f":"IF(OR(J111>0,H111>0),H111+K111,0)","v":0}]
[]
[null,{"$f":"+\"SUB-TOTAL:  \"&A15","v":"SUB-TOTAL:  G3"},null,null,{"$f":"SUM(E18:E112)","v":0},{"$f":"SUM(F18:F112)","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10"}},{"$f":"SUM(H18:H112)","v":0},null,null,{"$f":"SUM(K18:K112)","v":0},{"$f":"SUM(L18:L112)","v":0}]

{"sheet":"G4_Options","index":5,"n_rows":45,"n_cols":12,"rows_kept":45,"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 G4"]
["(INCLUDE VALUE ADDED TAX ON SHEET \"G1: SUMMARY\")"]
["TENDERER :",{"$f":"Instructions!D3","v":"Bidder Company name"}]
["PROJECT :",{"$f":"Instructions!D4","v":"RADSIM Replacement Project"}]
["Item Nr:","G4"]
["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","ROE: 1R = …","Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[{"$f":"B5","v":"G4"},{"$f":"B6","v":"Options"}]
["4.1"]
[null,"{List all products and services which are offered as options}"]
[null,"Debriefing Tablet",{"$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,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,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:  G4"},null,null,{"$f":"SUM(E17:E44)","v":0},{"$f":"SUM(F17:F44)","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"SUM(H17:H44)","v":0},null,{"$f":"SUM(J17:J44)","v":0},0,{"$f":"SUM(L17:L44)","v":0}]

{"sheet":"G5_Support_Base","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"]
["(INCLUDE VALUE ADDED TAX ON SHEET \"G1: SUMMARY\")"]
["TENDERER :",{"$f":"Instructions!D3","v":"Bidder Company name"}]
["PROJECT :",{"$f":"Instructions!D4","v":"RADSIM Replacement Project"}]
["Item Nr:","G5"]
["Item Description:","Support and Maintenance 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","ROE: 1R = …","Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[{"$f":"B5","v":"G5"},{"$f":"B6","v":"Support and Maintenance in base cost"}]
["5.1","{Details on the proposed maintenance and support contract must be included on this schedule}"]
[null,"Year 1",{"$f":"$B$7","v":"FC"},1,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},null,null,{"$f":"I17*J17","v":0},{"$f":"IF(OR(J17>0,H17>0),H17+K17,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,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]
["5.2","{Any other costs related to maintenance and support, not included under 5.1}"]
[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,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_1_Support_Inflated","index":7,"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"]
["(INCLUDE VALUE ADDED TAX ON SHEET \"G1: SUMMARY\")"]
["TENDERER :",{"$f":"Instructions!D3","v":"Bidder Company name"}]
["PROJECT :",{"$f":"Instructions!D4","v":"RADSIM Replacement Project"}]
["Item Nr:","G6.1"]
["Item Description:","Support and Maintenance 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","ROE: 1R = …","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 and Maintenance with inflation"}]
["6.1.1","{Details on the proposed maintenance and support contract must be included on this schedule}"]
[null,"Year 1",{"$f":"$B$7","v":"FC"},null,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},null,null,{"$f":"I17*J17","v":0},{"$f":"IF(OR(J17>0,H17>0),H17+K17,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,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]
["6.1.2","{Any other costs related to maintenance and support, not included under 5.1}"]
[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,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:  G6.1"},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_2_Midlife_Upgrade","index":8,"n_rows":49,"n_cols":12,"rows_kept":49,"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"]
["(INCLUDE VALUE ADDED TAX ON SHEET \"G1: SUMMARY\")"]
["BIDDER :",{"$f":"Instructions!D3","v":"Bidder Company name"}]
["PROJECT :",{"$f":"Instructions!D4","v":"RADSIM Replacement Project"}]
["Item Nr:","G6.2"]
["Item Description:","Midlife Upgrade"]
["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\n{Equipment Common to all site}","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"]
[]
[]
[{"$f":"B5","v":"G6.2"},{"$f":"B6","v":"Midlife Upgrade"}]
["6.2.1","Hardware"]
[null,"{List all hardware required for the simulator- upgrade include relevant product information and quantities}"]
[null,null,{"$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,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]
[]
["6.2.2","Software"]
[null,"{List all software required for the simulator upgrade}"]
[null,null,{"$f":"$B$7","v":"FC"},null,null,{"$f":"D37*E37","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G37<>0,F37/G37,0)","v":0},null,null,{"$f":"I37*J37","v":0},{"$f":"IF(OR(J37>0,H37>0),H37+K37,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]
[]
["6.2.3","Miscellaneous"]
[null,"{List items and services necessary for the installation, commissioning.}"]
[null,"(To be individually itemized and priced.)"]
[null,null,{"$f":"$B$7","v":"FC"},null,null,{"$f":"D44*E44","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G44<>0,F44/G44,0)","v":0},null,null,{"$f":"I44*J44","v":0},{"$f":"IF(OR(J44>0,H44>0),H44+K44,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,{"$f":"D46*E46","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G46<>0,F46/G46,0)","v":0},null,null,{"$f":"I46*J46","v":0},{"$f":"IF(OR(J46>0,H46>0),H46+K46,0)","v":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:  G6.2"},null,null,{"$f":"SUM(E18:E48)","v":0},{"$f":"SUM(F18:F48)","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10"}},{"$f":"SUM(H18:H48)","v":0},null,null,{"$f":"SUM(K18:K48)","v":0},{"$f":"SUM(L18:L48)","v":0}]