{"text_format":"3","workbook":"xlsx","n_sheets":14,"sheets":["Instructions","Bidder Info","G1 SUMMARY","G2_1 Software","G2_2 EQ","G3 PMP","G4 ILS","G5_1 Spares","G5_2 Test Equipment","G5_0 Spares List","G6 Miscellaneous","G7 Options","G8_1 Support Contract (Base)","G8_2 Support Contract (Infl)"],"not_rendered":{"defined_names":12},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":34,"n_cols":4,"rows_kept":34,"merged":[[6,3,6,5],[9,2,9,4],[10,2,10,4],[11,2,11,4],[13,2,13,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[23,3,23,4],[24,3,24,4],[25,3,25,4],[26,3,26,4],[27,3,27,4],[28,3,28,4],[29,2,29,4],[30,3,30,4],[31,3,31,4],[32,3,32,4],[33,2,33,4],[34,3,34,4],[35,3,35,4]]}
[]
[]
[null,null,"BIDDER:",{"$f":"'Bidder Info'!C3","v":"Bidder :"}]
[null,null,"Foreign Currency:",{"$f":"'Bidder Info'!D4","v":"FC"}]
[null,null,"ROE: 1R=",{"$f":"'Bidder Info'!D5","v":0.12345}]
[null,null,"Date:","2024-03-01"]
[null,null,"Project Name:","VCS REPLACEMENT"]
[]
[]
[null,null,"Cells with a light grey background contains formulas and fixed information and should not be changed."]
[null,null,"Cells with a dark grey background contains fixed information, headings and formulas that must not be changed."]
[null,null,"Sheets with a blue tab colour must be completed by the Bidder."]
[]
[null,null,"This file contains the following sheets:"]
[null,null,"Bidder Info","Bidder supplied information to be used in subsequent sheets."]
[null,null,"G1 SUMMARY","Summary of all sheets."]
[null,null,"G2_1 Software","Softyware costs"]
[null,null,"G2_2 EQ","Equipment costs."]
[null,null,"G3 PMP","Overall project management and associated costs."]
[null,null,"G4 ILS","Overall logistic support and associated costs."]
[null,null,"G5_1 Spares","Proposed spares cost per equipment type"]
[null,null,"G5_2 Test Equipment","Test equipment cost"]
[null,null,"G5_0 Spares List","List of all spares/LRU's and costs."]
[null,null,"G6 Miscellaneous","All miscellaneous items costs"]
[null,null,"G7 Options","All optional items costs"]
[null,null,"G8_1 Support Contract (Base)","Maintenance and support contract in base cost"]
[null,null,"G8_2 Support Contract (Infl)","Maintenance and support contract including inflation"]
[]
[]
[null,null,"The total proposed spares cost per equipment type shall be captured on \"G5_1 Spares\", while the details spares list with costing shall be captured on \"G5_0 Spares\" for each equipment type."]
[]
[]
[]
[null,null,"Complete columns D,E,I & J on sheets C1 to C4 and the formula's will automatically calculate the totals."]

{"sheet":"Bidder Info","index":1,"n_rows":9,"n_cols":5,"rows_kept":9}
[]
[]
[null,null,"Bidder :","Bidder name","\"{Include name of Bidder}"]
[null,null,"Foreign Currency:","FC","\"{Include the foreign currency}"]
[null,null,"ROE: 1R=",0.12345,"\"{Include the quoted exchange rate}"]
[null,null,"Date:","2024-02-23"]
[]
[]
[null,null,"Do not change cells with grey background."]

{"sheet":"G1 SUMMARY","index":2,"n_rows":38,"n_cols":7,"rows_kept":38,"merged":[[0,0,0,1],[1,0,1,1],[5,2,6,4],[7,0,9,0],[7,1,9,1],[7,2,9,2],[7,3,9,3],[7,4,9,4],[7,5,9,5],[7,6,9,6]]}
["TENDER PRICE SCHEDULE: VOLUME 1C"]
["(EXCLUDING VALUE ADDED TAX)"]
["BIDDER :",{"$f":"'Bidder Info'!D3","v":"Bidder name"}]
["Project Name:","ATNS/TPQ/RPF051/23.24/ VCS REPLACEMENT"]
[]
[null,null,"Overseas Items",null,null,"Local Items"]
[]
["Schedule Item Number","Description","Foreign Amount  Total Cost",{"$f":"\"ROE: 1R = \"&'Bidder Info'!$D$5","v":"ROE: 1R = 0.12345"},"Total Foreign Cost in Rands","Local Amount Total Cost","Total Rands"]
[]
[]
[]
[null,"VCS SYSTEM"]
["G2.1",{"$f":"'G2_1 Software'!B6","v":"System Software"},{"$f":"'G2_1 Software'!F61","v":0},{"$f":"'G2_1 Software'!B8","v":{"v":0.12345,"d":"0.1235"}},{"$f":"'G2_1 Software'!H61","v":0},{"$f":"'G2_1 Software'!K61","v":0},{"$f":"'G2_1 Software'!L61","v":0}]
["G2.2",{"$f":"'G2_2 EQ'!B6","v":"Equipment"},{"$f":"'G2_2 EQ'!F98","v":0},{"$f":"'G2_2 EQ'!B8","v":{"v":0.12345,"d":"0.1235"}},{"$f":"'G2_2 EQ'!H98","v":0},{"$f":"'G2_2 EQ'!K98","v":0},{"$f":"'G2_2 EQ'!L98","v":0}]
[]
[null,"SERVICES"]
["G3",{"$f":"'G3 PMP'!B6","v":"Project Management"},{"$f":"'G3 PMP'!F56","v":0},{"$f":"'G3 PMP'!G56","v":{"v":0.12345,"d":"0.1235"}},{"$f":"'G3 PMP'!H56","v":0},{"$f":"'G3 PMP'!K56","v":0},{"$f":"'G3 PMP'!L56","v":0}]
["G4",{"$f":"'G4 ILS'!B6","v":"Integrated Logistic Support"},{"$f":"'G4 ILS'!F57","v":0},{"$f":"'G4 ILS'!G57","v":{"v":0.12345,"d":"0.1235"}},{"$f":"'G4 ILS'!H57","v":0},{"$f":"'G4 ILS'!K57","v":0},{"$f":"'G4 ILS'!L57","v":0}]
[]
["G5","SPARES & TEST EQUIPMENT"]
["G5.1",{"$f":"'G5_1 Spares'!B6","v":"Spares"},{"$f":"'G5_1 Spares'!F55","v":0},{"$f":"'G5_1 Spares'!G55","v":{"v":0.12345,"d":"0.1235"}},{"$f":"'G5_1 Spares'!H55","v":0},{"$f":"'G5_1 Spares'!K55","v":0},{"$f":"'G5_1 Spares'!L55","v":0}]
["G5.2",{"$f":"'G5_2 Test Equipment'!B6","v":"Test Equipment"},{"$f":"'G5_2 Test Equipment'!F42","v":0},{"$f":"'G5_2 Test Equipment'!G42","v":{"v":0.12345,"d":"0.1235"}},{"$f":"'G5_2 Test Equipment'!H42","v":0},{"$f":"'G5_2 Test Equipment'!K42","v":0},{"$f":"'G5_2 Test Equipment'!L42","v":0}]
[]
["G6","MISCELLANEOUS",{"$f":"'G6 Miscellaneous'!F42","v":0},{"$f":"'G6 Miscellaneous'!G42","v":{"v":0.12345,"d":"0.1235"}},{"$f":"'G6 Miscellaneous'!H42","v":0},{"$f":"'G6 Miscellaneous'!K42","v":0},{"$f":"'G6 Miscellaneous'!L42","v":0}]
[]
[null,"TOTAL:",{"$f":"SUM(C11:C25)","v":0},null,{"$f":"SUM(E11:E25)","v":0},{"$f":"SUM(F11:F25)","v":0},{"$f":"SUM(G11:G25)","v":0}]
[]
["G8.2",{"$f":"'G8_2 Support Contract (Infl)'!B6","v":"Support Maintenance Contract (Inflated)"},{"$f":"'G8_2 Support Contract (Infl)'!F41","v":0},{"$f":"'G8_2 Support Contract (Infl)'!G41","v":0},{"$f":"'G8_2 Support Contract (Infl)'!H41","v":0},{"$f":"'G8_2 Support Contract (Infl)'!K41","v":0},{"$f":"'G8_2 Support Contract (Infl)'!L41","v":0}]
[]
[null,"TOTAL Including Support Contract :",{"$f":"C26+C28","v":0},null,{"$f":"E26+E28","v":0},0,0]
[]
["G7","OPTIONS",{"$f":"'G7 Options'!F$53","v":0},{"$f":"'G7 Options'!G$53","v":{"v":0.12345,"d":"0.1235"}},{"$f":"'G7 Options'!H$53","v":0},{"$f":"'G7 Options'!K$53","v":0},{"$f":"'G7 Options'!L$53","v":0}]
["G9.1",{"$f":"'G7 Options'!B17","v":"OTHER OPTIONS 1"},{"$f":"'G7 Options'!F17","v":0},{"$f":"'G7 Options'!G17","v":0},{"$f":"'G7 Options'!H17","v":0},{"$f":"'G7 Options'!K17","v":0},{"$f":"'G7 Options'!L17","v":0}]
["G9.2",{"$f":"'G7 Options'!B26","v":"OTHER OPTIONS 2"},{"$f":"'G7 Options'!F26","v":0},{"$f":"'G7 Options'!G26","v":0},{"$f":"'G7 Options'!H26","v":0},{"$f":"'G7 Options'!K26","v":0},{"$f":"'G7 Options'!L26","v":0}]
["G9.3",{"$f":"'G7 Options'!B35","v":"OTHER OPTIONS 3"},{"$f":"'G7 Options'!F35","v":0},{"$f":"'G7 Options'!G35","v":0},{"$f":"'G7 Options'!H35","v":0},{"$f":"'G7 Options'!K35","v":0},{"$f":"'G7 Options'!L35","v":0}]
["G9.4",{"$f":"'G7 Options'!B44","v":"OTHER OPTIONS 4"},{"$f":"'G7 Options'!F44","v":0},{"$f":"'G7 Options'!G44","v":0},{"$f":"'G7 Options'!H44","v":0},{"$f":"'G7 Options'!K44","v":0},{"$f":"'G7 Options'!L44","v":0}]
[]
[null,"GRAND TOTAL (Inluding Options):",{"$f":"C30+C32","v":0},null,{"$f":"E30+E32","v":0},0,0]

{"sheet":"G2_1 Software","index":3,"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,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: VOLUME 1C"]
["(EXCLUDING VALUE ADDED TAX)"]
["BIDDER :",{"$f":"'Bidder Info'!D3","v":"Bidder name"}]
["PROJECT :",{"$f":"Instructions!$D$7","v":"VCS REPLACEMENT"}]
["Item Nr:","G2.1"]
["Item Description:","System Software"]
["Foreign Currancy",{"$f":"'Bidder Info'!D4","v":"FC"}]
["ROE: 1R =",{"$f":"'Bidder Info'!D5","v":0.12345}]
[]
[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 = \"&'Bidder Info'!$D$5","v":"ROE: 1R = 0.12345"},"Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[{"$f":"$B$5&\".1\"","v":"G2.1.1"},"Main System"]
[null,"Operating Software",{"$f":"$B$7","v":"FC"},null,null,{"$f":"D16*E16","v":0},{"$f":"$B$8","v":0.12345},{"$f":"IF(G16<>0,F16/G16,0)","v":0},null,null,{"$f":"I16*J16","v":0},{"$f":"IF(OR(J16>0,H16>0),H16+K16,0)","v":0}]
[null,"Application Software","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"..list other.","FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[{"$f":"$B$5&\".2\"","v":"G2.1.2"},"Technical and Controller User Software"]
[null,"Operating Software","FC",null,null,{"$f":"D24*E24","v":0},0.12345,{"$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,"Application Software","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"..list other.","FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[{"$f":"$B$5&\".3\"","v":"G2.1.3"},"Other"]
[null,"Remote Control and Monitoring","FC",null,null,{"$f":"D32*E32","v":0},0.12345,{"$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,"..list other.","FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,{"$f":"D39*E39","v":0},0.12345,{"$f":"IF(G39<>0,F39/G39,0)","v":0},null,null,{"$f":"I39*J39","v":0},{"$f":"IF(OR(J39>0,H39>0),H39+K39,0)","v":0}]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,{"$f":"D46*E46","v":0},0.12345,{"$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,{"$f":"D47*E47","v":0},0.12345,{"$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}]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,{"$f":"D58*E58","v":0},0.12345,{"$f":"IF(G58<>0,F58/G58,0)","v":0},null,null,{"$f":"I58*J58","v":0},0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[]
[null,{"$f":"+\"SUB-TOTAL:  \"&B5","v":"SUB-TOTAL:  G2.1"},{"$nulls":3},{"$f":"SUM(F15:F60)","v":0},null,{"$f":"SUM(H15:H60)","v":0},null,null,{"$f":"SUM(K15:K60)","v":0},{"$f":"SUM(L15:L60)","v":0}]

{"sheet":"G2_2 EQ","index":4,"n_rows":98,"n_cols":12,"rows_kept":98,"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: VOLUME 1C"]
["(EXCLUDING VALUE ADDED TAX)"]
["BIDDER :",{"$f":"'Bidder Info'!D3","v":"Bidder name"}]
["PROJECT :",{"$f":"Instructions!$D$7","v":"VCS REPLACEMENT"}]
["Item Nr:","G2.2"]
["Item Description:","Equipment"]
["Foreign Currancy",{"$f":"'Bidder Info'!D4","v":"FC"}]
["ROE: 1R =",{"$f":"'Bidder Info'!D5","v":0.12345}]
[]
[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 = \"&'Bidder Info'!$D$5","v":"ROE: 1R = 0.12345"},"Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[{"$f":"$B$5&\".1\"","v":"G2.2.1"},"Main System"]
[null,"Pietermaritzburg (FAPM)",{"$f":"$B$7","v":"FC"},null,null,{"$f":"D16*E16","v":0},{"$f":"$B$8","v":0.12345},{"$f":"IF(G16<>0,F16/G16,0)","v":0},null,null,{"$f":"I16*J16","v":0},{"$f":"IF(OR(J16>0,H16>0),H16+K16,0)","v":0}]
[null,"Virginia (FAVG)","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Wonderboom (FAWB)","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Polokwane (FAPP)","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Rand (FAGM)","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Upington (FAUP)","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Kimberley (FAKM)","FC",null,null,{"$f":"D22*E22","v":0},0.12345,{"$f":"IF(G22<>0,F22/G22,0)","v":0},null,null,{"$f":"I22*J22","v":0},{"$f":"IF(OR(J22>0,H22>0),H22+K22,0)","v":0}]
[null,"Pilanesberg, (FAPN)","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Mafikeng (FAMM)","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Kruger Mpumalanga (FAKN)","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Umtata (FAUT)","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Richards Bay (FARB)","FC",null,null,{"$f":"D27*E27","v":0},0.12345,{"$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,"Aviation Training Academy (ATA)","FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[{"$f":"$B$5&\".2\"","v":"G2.2.2"},"Interface Subsystem"]
[null,"Pietermaritzburg (FAPM)","FC",null,null,{"$f":"D31*E31","v":0},0.12345,{"$f":"IF(G31<>0,F31/G31,0)","v":0},null,null,{"$f":"I31*J31","v":0},{"$f":"IF(OR(J31>0,H31>0),H31+K31,0)","v":0}]
[null,"Virginia (FAVG)","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Wonderboom (FAWB)","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Polokwane (FAPP)","FC",null,null,{"$f":"D34*E34","v":0},0.12345,{"$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,"Rand (FAGM)","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Upington (FAUP)","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Kimberley (FAKM)","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Pilanesberg, (FAPN)","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Mafikeng (FAMM)","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Kruger Mpumalanga (FAKN)","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Umtata (FAUT)","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Richards Bay (FARB)","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Aviation Training Academy (ATA)","FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[{"$f":"$B$5&\".3\"","v":"G2.2.3"},"Technical Working Positions"]
[null,"Pietermaritzburg (FAPM)","FC",null,null,{"$f":"D46*E46","v":0},0.12345,{"$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,"Virginia (FAVG)","FC",null,null,{"$f":"D47*E47","v":0},0.12345,{"$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}]
[null,"Wonderboom (FAWB)","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Polokwane (FAPP)","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Rand (FAGM)","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Upington (FAUP)","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Kimberley (FAKM)","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Pilanesberg, (FAPN)","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Mafikeng (FAMM)","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Kruger Mpumalanga (FAKN)","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Umtata (FAUT)","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Richards Bay (FARB)","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Aviation Training Academy (ATA)","FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[{"$f":"$B$5&\".4\"","v":"G2.2.4"},"Controller Working Positions"]
[null,"Pietermaritzburg (FAPM)","FC",null,null,{"$f":"D61*E61","v":0},0.12345,{"$f":"IF(G61<>0,F61/G61,0)","v":0},null,null,{"$f":"I61*J61","v":0},{"$f":"IF(OR(J61>0,H61>0),H61+K61,0)","v":0}]
[null,"Virginia (FAVG)","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Wonderboom (FAWB)","FC",null,null,{"$f":"D63*E63","v":0},0.12345,{"$f":"IF(G63<>0,F63/G63,0)","v":0},null,null,{"$f":"I63*J63","v":0},{"$f":"IF(OR(J63>0,H63>0),H63+K63,0)","v":0}]
[null,"Polokwane (FAPP)","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Rand (FAGM)","FC",null,null,{"$f":"D65*E65","v":0},0.12345,{"$f":"IF(G65<>0,F65/G65,0)","v":0},null,null,{"$f":"I65*J65","v":0},{"$f":"IF(OR(J65>0,H65>0),H65+K65,0)","v":0}]
[null,"Upington (FAUP)","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Kimberley (FAKM)","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Pilanesberg, (FAPN)","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Mafikeng (FAMM)","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Kruger Mpumalanga (FAKN)","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Umtata (FAUT)","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Richards Bay (FARB)","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Aviation Training Academy (ATA)","FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[{"$f":"$B$5&\".5\"","v":"G2.2.5"},"Supporting Infrastructure"]
[null,"Equipment Cabinets","FC",13,null,0,0.12345,0,13,null,0,0]
[null,"Cabling","FC",13,null,0,0.12345,0,13,null,0,0]
[null,"Remote Control and Monitoring","FC",4,null,{"$f":"D78*E78","v":0},0.12345,{"$f":"IF(G78<>0,F78/G78,0)","v":0},4,null,{"$f":"I78*J78","v":0},{"$f":"IF(OR(J78>0,H78>0),H78+K78,0)","v":0}]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,{"$f":"D95*E95","v":0},0.12345,{"$f":"IF(G95<>0,F95/G95,0)","v":0},null,null,{"$f":"I95*J95","v":0},0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[]
[null,{"$f":"+\"SUB-TOTAL:  \"&B5","v":"SUB-TOTAL:  G2.2"},{"$nulls":3},{"$f":"SUM(F15:F97)","v":0},null,{"$f":"SUM(H15:H97)","v":0},null,null,{"$f":"SUM(K15:K97)","v":0},{"$f":"SUM(L15:L97)","v":0}]

{"sheet":"G3 PMP","index":5,"n_rows":56,"n_cols":12,"rows_kept":56,"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: VOLUME 1C"]
["(EXCLUDING VALUE ADDED TAX)"]
["BIDDER :",{"$f":"'Bidder Info'!D3","v":"Bidder name"}]
["PROJECT :",{"$f":"Instructions!$D$7","v":"VCS REPLACEMENT"}]
["Item Nr:","G3"]
["Item Description:","Project Management"]
["Foreign Currancy",{"$f":"'Bidder Info'!D4","v":"FC"}]
["ROE: 1R =",{"$f":"'Bidder Info'!D5","v":0.12345}]
[]
[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 = \"&'Bidder Info'!$D$5","v":"ROE: 1R = 0.12345"},"Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[{"$f":"B5","v":"G3"},{"$f":"B6","v":"Project Management"}]
[null,"{All project Management items, with at least the following items}"]
[]
[3.1,"Documents"]
[null,"Project Management Plan",{"$f":"$B$7","v":"FC"},null,null,{"$f":"D19*E19","v":0},{"$f":"$B$8","v":0.12345},{"$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,"Test and Evaluation Master Plan","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Installation, Transition and Commissioning Plan","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Risk Management Plan","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Quality Assurance Plan","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Resource Allocation Plan","FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[3.2,"Acceptance Tests",{"$nulls":3},0]
[null,"Factory Acceptance Test",{"$f":"$B$7","v":"FC"},null,null,{"$f":"D32*E32","v":0},{"$f":"$B$8","v":0.12345},{"$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,"Site Acceptance Test","FC",null,null,{"$f":"D33*E33","v":0},0.12345,{"$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},0.12345,{"$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},0.12345,{"$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,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[3.3,"Project Management Services",{"$nulls":3},0]
[null,"Services",{"$f":"$B$7","v":"FC"},null,null,{"$f":"D42*E42","v":0},{"$f":"$B$8","v":0.12345},{"$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,"Installation Services","FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[3.4,"Shipping, Insurance & Associated costs"]
[null,"Shipping",{"$f":"$B$7","v":"FC"},null,null,{"$f":"D49*E49","v":0},{"$f":"$B$8","v":0.12345},{"$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,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[]
[null,{"$f":"+\"SUB-TOTAL:  \"&A15","v":"SUB-TOTAL:  G3"},{"$nulls":3},{"$f":"SUM(F15:F55)","v":0},{"$f":"$B$8","v":0.12345},{"$f":"SUM(H15:H55)","v":0},null,null,{"$f":"SUM(K15:K55)","v":0},{"$f":"SUM(L15:L55)","v":0}]

{"sheet":"G4 ILS","index":6,"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: VOLUME 1C"]
["(EXCLUDING VALUE ADDED TAX)"]
["BIDDER :",{"$f":"'Bidder Info'!D3","v":"Bidder name"}]
["PROJECT :",{"$f":"Instructions!$D$7","v":"VCS REPLACEMENT"}]
["Item Nr:","G4"]
["Item Description:","Integrated Logistic Support"]
["Foreign Currancy",{"$f":"'Bidder Info'!D4","v":"FC"}]
["ROE: 1R =",{"$f":"'Bidder Info'!D5","v":0.12345}]
[]
[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 = \"&'Bidder Info'!$D$5","v":"ROE: 1R = 0.12345"},"Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[{"$f":"B5","v":"G4"},{"$f":"B6","v":"Integrated Logistic Support"}]
[null,"{ All logistic support items with at least the following items}"]
[]
[4.1,"Logistic Support Services"]
[null,"{Any other services costs}",{"$f":"$B$7","v":"FC"},null,null,{"$f":"D19*E19","v":0},{"$f":"$B$8","v":0.12345},{"$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,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[4.2,"Training"]
[null,"OEM Training",{"$f":"$B$7","v":"FC"},null,null,{"$f":"D27*E27","v":0},{"$f":"$B$8","v":0.12345},{"$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,"Training Manuals","FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,{"$f":"D29*E29","v":0},0.12345,{"$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},0.12345,{"$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},0.12345,{"$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},0.12345,{"$f":"IF(G32<>0,F32/G32,0)","v":0},null,null,{"$f":"I32*J32","v":0},0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[4.3,"Documents"]
[null,"Integrated Logistic Support Plan",{"$f":"$B$7","v":"FC"},null,null,0,{"$f":"$B$8","v":0.12345},0,null,null,0,{"$f":"IF(OR(J36>0,H36>0),H36+K36,0)","v":0}]
[null,"Configuration Management Plan","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Factory Acceptance Test Procedures","FC",null,null,0,0.12345,0,null,null,0,0]
[null,"Site Acceptance Test Procedures","FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,{"$f":"D42*E42","v":0},0.12345,{"$f":"IF(G42<>0,F42/G42,0)","v":0},null,null,{"$f":"I42*J42","v":0},0]
[null,null,"FC",null,null,{"$f":"D43*E43","v":0},0.12345,{"$f":"IF(G43<>0,F43/G43,0)","v":0},null,null,{"$f":"I43*J43","v":0},0]
[null,null,"FC",null,null,{"$f":"D44*E44","v":0},0.12345,{"$f":"IF(G44<>0,F44/G44,0)","v":0},null,null,{"$f":"I44*J44","v":0},0]
[null,null,"FC",null,null,{"$f":"D45*E45","v":0},0.12345,{"$f":"IF(G45<>0,F45/G45,0)","v":0},null,null,{"$f":"I45*J45","v":0},0]
[null,null,"FC",null,null,{"$f":"D46*E46","v":0},0.12345,{"$f":"IF(G46<>0,F46/G46,0)","v":0},null,null,{"$f":"I46*J46","v":0},0]
[4.4,"Logistic Support Cost during PBU"]
[null,"Minimum 12 Months PBU",{"$f":"$B$7","v":"FC"},null,null,0,{"$f":"$B$8","v":0.12345},0,null,null,0,{"$f":"IF(OR(J48>0,H48>0),H48+K48,0)","v":0}]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,{"$f":"D52*E52","v":0},0.12345,{"$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},0.12345,{"$f":"IF(G53<>0,F53/G53,0)","v":0},null,null,{"$f":"I53*J53","v":0},0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[]
[null,{"$f":"+\"SUB-TOTAL:  \"&A15","v":"SUB-TOTAL:  G4"},{"$nulls":3},{"$f":"SUM(F15:F56)","v":0},{"$f":"$B$8","v":0.12345},{"$f":"SUM(H15:H56)","v":0},null,null,{"$f":"SUM(K15:K56)","v":0},{"$f":"SUM(L15:L56)","v":0}]

{"sheet":"G5_1 Spares","index":7,"n_rows":55,"n_cols":12,"rows_kept":55,"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: VOLUME 1C"]
["(EXCLUDING VALUE ADDED TAX)"]
["BIDDER :",{"$f":"'Bidder Info'!D3","v":"Bidder name"}]
["PROJECT :",{"$f":"Instructions!$D$7","v":"VCS REPLACEMENT"}]
["Item Nr:","G5_1"]
["Item Description:","Spares"]
["Foreign Currancy",{"$f":"'Bidder Info'!D4","v":"FC"}]
["ROE: 1R =",{"$f":"'Bidder Info'!D5","v":0.12345}]
[]
[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 = \"&'Bidder Info'!$D$5","v":"ROE: 1R = 0.12345"},"Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[{"$f":"B5","v":"G5_1"},{"$f":"B6","v":"Spares"}]
[null,"{The list of proposed spares by the Bidder shall be detailed and priced below.}"]
[]
["5.1.1","Main System"]
[null,null,{"$f":"$B$7","v":"FC"},null,null,{"$f":"D19*E19","v":0},{"$f":"$B$8","v":0.12345},{"$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,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,{"$f":"IF(OR(J23>0,H23>0),H23+K23,0)","v":0}]
[null,null,"FC",null,null,{"$f":"D24*E24","v":0},0.12345,{"$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,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,{"$f":"D31*E31","v":0},0.12345,{"$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},0.12345,{"$f":"IF(G32<>0,F32/G32,0)","v":0},null,null,{"$f":"I32*J32","v":0},0]
["5.1.2","Other"]
[null,null,"FC",null,null,{"$f":"D34*E34","v":0},0.12345,{"$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,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,{"$f":"D38*E38","v":0},0.12345,{"$f":"IF(G38<>0,F38/G38,0)","v":0},null,null,{"$f":"I38*J38","v":0},0]
[null,null,"FC",null,null,{"$f":"D39*E39","v":0},0.12345,{"$f":"IF(G39<>0,F39/G39,0)","v":0},null,null,{"$f":"I39*J39","v":0},{"$f":"IF(OR(J39>0,H39>0),H39+K39,0)","v":0}]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,{"$f":"$B$7","v":"FC"},null,null,0,{"$f":"$B$8","v":0.12345},0,null,null,0,{"$f":"IF(OR(J45>0,H45>0),H45+K45,0)","v":0}]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[]
[null,{"$f":"+\"SUB-TOTAL:  \"&A15","v":"SUB-TOTAL:  G5_1"},{"$nulls":3},{"$f":"SUM(F15:F54)","v":0},{"$f":"$B$8","v":0.12345},{"$f":"SUM(H15:H54)","v":0},null,null,{"$f":"SUM(K15:K54)","v":0},{"$f":"SUM(L15:L54)","v":0}]

{"sheet":"G5_2 Test Equipment","index":8,"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: VOLUME 1C"]
["(EXCLUDING VALUE ADDED TAX)"]
["BIDDER :",{"$f":"'Bidder Info'!D3","v":"Bidder name"}]
["PROJECT :",{"$f":"Instructions!$D$7","v":"VCS REPLACEMENT"}]
["Item Nr:","G5.2"]
["Item Description:","Test Equipment"]
["Foreign Currancy",{"$f":"'Bidder Info'!D4","v":"FC"}]
["ROE: 1R =",{"$f":"'Bidder Info'!D5","v":0.12345}]
[]
[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 = \"&'Bidder Info'!$D$5","v":"ROE: 1R = 0.12345"},"Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[{"$f":"B5","v":"G5.2"},{"$f":"B6","v":"Test Equipment"}]
["5.2.1","Installation Test Equipment"]
[null,"{List of the test equipment shall be provided.}",{"$f":"$B$7","v":"FC"},null,null,{"$f":"D17*E17","v":0},{"$f":"$B$8","v":0.12345},{"$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,null,{"$f":"$B$7","v":"FC"},null,null,{"$f":"D18*E18","v":0},{"$f":"$B$8","v":0.12345},{"$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,{"$f":"D19*E19","v":0},0.12345,{"$f":"IF(G19<>0,F19/G19,0)","v":0},null,null,{"$f":"I19*J19","v":0},0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
["5.2.2","Maintenance Test Equipment"]
[null,"{List of the test equipment shall be provided.}",{"$f":"$B$7","v":"FC"},null,null,{"$f":"D27*E27","v":0},{"$f":"$B$8","v":0.12345},{"$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,null,"FC",null,null,{"$f":"D28*E28","v":0},0.12345,{"$f":"IF(G28<>0,F28/G28,0)","v":0},null,null,{"$f":"I28*J28","v":0},0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,{"$f":"D39*E39","v":0},0.12345,{"$f":"IF(G39<>0,F39/G39,0)","v":0},null,null,{"$f":"I39*J39","v":0},0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[]
[null,{"$f":"+\"SUB-TOTAL:  \"&A15","v":"SUB-TOTAL:  G5.2"},{"$nulls":3},{"$f":"SUM(F15:F41)","v":0},{"$f":"$B$8","v":0.12345},{"$f":"SUM(H15:H41)","v":0},null,null,{"$f":"SUM(K15:K41)","v":0},{"$f":"SUM(L15:L41)","v":0}]

{"sheet":"G5_0 Spares List","index":9,"n_rows":139,"n_cols":12,"rows_kept":139,"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: VOLUME 1C"]
["(EXCLUDING VALUE ADDED TAX)"]
["BIDDER :",{"$f":"'Bidder Info'!D3","v":"Bidder name"}]
["PROJECT :",{"$f":"Instructions!$D$7","v":"VCS REPLACEMENT"}]
["Item Nr:","G5_0"]
["Item Description:","Equipment Spares List"]
["Foreign Currancy",{"$f":"'Bidder Info'!D4","v":"FC"}]
["ROE: 1R =",{"$f":"'Bidder Info'!D5","v":0.12345}]
[]
[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 = \"&'Bidder Info'!$D$5","v":"ROE: 1R = 0.12345"},"Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[{"$f":"B5","v":"G5_0"},{"$f":"B6","v":"Equipment Spares List"}]
[null,"{Full list of spares available for the system and not nessecary recommended by the Bidder.}"]
[]
["5.0.1","Main System",{"$nulls":3},{"$f":"SUM(F19:F29)","v":0},{"$f":"$B$8","v":0.12345},{"$f":"SUM(H19:H29)","v":0},null,null,{"$f":"SUM(K19:K29)","v":0},{"$f":"SUM(L19:L29)","v":0}]
[1,null,{"$f":"$B$7","v":"FC"},null,null,{"$f":"D19*E19","v":0},0.12345,{"$f":"IF(G19<>0,F19/G19,0)","v":0},null,null,{"$f":"I19*J19","v":0},{"$f":"K19+H19","v":0}]
[2,null,"FC",null,null,{"$f":"D20*E20","v":0},0.12345,{"$f":"IF(G20<>0,F20/G20,0)","v":0},null,null,{"$f":"I20*J20","v":0},{"$f":"K20+H20","v":0}]
[3,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[4,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[5,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[6,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[7,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[8,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[9,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[10,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[]
["5.0.2",{"$nulls":4},{"$f":"SUM(F31:F41)","v":0},{"$f":"$B$8","v":0.12345},{"$f":"SUM(H31:H41)","v":0},null,null,{"$f":"SUM(K31:K41)","v":0},{"$f":"SUM(L31:L41)","v":0}]
[1,null,{"$f":"$B$7","v":"FC"},null,null,{"$f":"D31*E31","v":0},0.12345,{"$f":"IF(G31<>0,F31/G31,0)","v":0},null,null,{"$f":"I31*J31","v":0},{"$f":"K31+H31","v":0}]
[2,null,"FC",null,null,0,0.12345,0,null,null,0,{"$f":"K32+H32","v":0}]
[3,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[4,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[5,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[6,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[7,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[8,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[9,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[10,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[]
["5.0.3",{"$nulls":4},{"$f":"SUM(F43:F53)","v":0},{"$f":"$B$8","v":0.12345},{"$f":"SUM(H43:H53)","v":0},null,null,{"$f":"SUM(K43:K53)","v":0},{"$f":"SUM(L43:L53)","v":0}]
[1,null,{"$f":"$B$7","v":"FC"},null,null,{"$f":"D43*E43","v":0},0.12345,{"$f":"IF(G43<>0,F43/G43,0)","v":0},null,null,{"$f":"I43*J43","v":0},{"$f":"K43+H43","v":0}]
[2,null,"FC",null,null,0,0.12345,0,null,null,0,{"$f":"K44+H44","v":0}]
[3,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[4,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[5,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[6,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[7,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[8,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[9,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[10,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[]
["5.0.4",{"$nulls":4},{"$f":"SUM(F55:F65)","v":0},{"$f":"$B$8","v":0.12345},{"$f":"SUM(H55:H65)","v":0},null,null,{"$f":"SUM(K55:K65)","v":0},{"$f":"SUM(L55:L65)","v":0}]
[1,null,{"$f":"$B$7","v":"FC"},null,null,{"$f":"D55*E55","v":0},0.12345,{"$f":"IF(G55<>0,F55/G55,0)","v":0},null,null,{"$f":"I55*J55","v":0},{"$f":"K55+H55","v":0}]
[2,null,"FC",null,null,0,0.12345,0,null,null,0,{"$f":"K56+H56","v":0}]
[3,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[4,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[5,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[6,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[7,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[8,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[9,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[10,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[]
["5.0.5",{"$nulls":4},{"$f":"SUM(F67:F77)","v":0},0.12345,{"$f":"SUM(H67:H77)","v":0},null,null,{"$f":"SUM(K67:K77)","v":0},{"$f":"SUM(L67:L77)","v":0}]
[1,null,"FC",null,null,{"$f":"D67*E67","v":0},0.12345,{"$f":"IF(G67<>0,F67/G67,0)","v":0},null,null,{"$f":"I67*J67","v":0},{"$f":"K67+H67","v":0}]
[2,null,"FC",null,null,0,0.12345,0,null,null,0,{"$f":"K68+H68","v":0}]
[3,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[4,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[5,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[6,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[7,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[8,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[9,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[10,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[]
["5.0.6",{"$nulls":4},{"$f":"SUM(F79:F89)","v":0},0.12345,{"$f":"SUM(H79:H89)","v":0},null,null,{"$f":"SUM(K79:K89)","v":0},{"$f":"SUM(L79:L89)","v":0}]
[1,null,{"$f":"$B$7","v":"FC"},null,null,{"$f":"D79*E79","v":0},0.12345,{"$f":"IF(G79<>0,F79/G79,0)","v":0},null,null,{"$f":"I79*J79","v":0},{"$f":"K79+H79","v":0}]
[2,null,"FC",null,null,0,0.12345,0,null,null,0,{"$f":"K80+H80","v":0}]
[3,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[4,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[5,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[6,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[7,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[8,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[9,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[10,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[]
["5.0.7",{"$nulls":4},{"$f":"SUM(F91:F101)","v":0},0.12345,{"$f":"SUM(H91:H101)","v":0},null,null,{"$f":"SUM(K91:K101)","v":0},{"$f":"SUM(L91:L101)","v":0}]
[1,null,{"$f":"$B$7","v":"FC"},null,null,{"$f":"D91*E91","v":0},0.12345,{"$f":"IF(G91<>0,F91/G91,0)","v":0},null,null,{"$f":"I91*J91","v":0},{"$f":"K91+H91","v":0}]
[2,null,"FC",null,null,0,0.12345,0,null,null,0,{"$f":"K92+H92","v":0}]
[3,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[4,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[5,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[6,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[7,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[8,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[9,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[10,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[]
["5.0.8",{"$nulls":4},{"$f":"SUM(F103:F113)","v":0},0.12345,{"$f":"SUM(H103:H113)","v":0},null,null,{"$f":"SUM(K103:K113)","v":0},{"$f":"SUM(L103:L113)","v":0}]
[1,null,"FC",null,null,{"$f":"D103*E103","v":0},0.12345,{"$f":"IF(G103<>0,F103/G103,0)","v":0},null,null,{"$f":"I103*J103","v":0},{"$f":"K103+H103","v":0}]
[2,null,"FC",null,null,0,0.12345,0,null,null,0,{"$f":"K104+H104","v":0}]
[3,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[4,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[5,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[6,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[7,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[8,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[9,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[10,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[]
["5.0.9",{"$nulls":4},{"$f":"SUM(F115:F125)","v":0},0.12345,{"$f":"SUM(H115:H125)","v":0},null,null,{"$f":"SUM(K115:K125)","v":0},{"$f":"SUM(L115:L125)","v":0}]
[1,null,{"$f":"$B$7","v":"FC"},null,null,{"$f":"D115*E115","v":0},0.12345,{"$f":"IF(G115<>0,F115/G115,0)","v":0},null,null,{"$f":"I115*J115","v":0},{"$f":"K115+H115","v":0}]
[2,null,"FC",null,null,0,0.12345,0,null,null,0,{"$f":"K116+H116","v":0}]
[3,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[4,null,"FC",null,null,0,{"$f":"$B$8","v":0.12345},0,null,null,0,0]
[5,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[6,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[7,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[8,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[9,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[10,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[]
["5.0.10",{"$nulls":4},{"$f":"SUM(F127:F137)","v":0},{"$f":"$B$8","v":0.12345},{"$f":"SUM(H127:H137)","v":0},null,null,{"$f":"SUM(K127:K137)","v":0},{"$f":"SUM(L127:L137)","v":0}]
[1,null,{"$f":"$B$7","v":"FC"},null,null,{"$f":"D127*E127","v":0},0.12345,{"$f":"IF(G127<>0,F127/G127,0)","v":0},null,null,{"$f":"I127*J127","v":0},{"$f":"K127+H127","v":0}]
[2,null,"FC",null,null,0,0.12345,0,null,null,0,{"$f":"K128+H128","v":0}]
[3,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[4,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[5,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[6,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[7,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[8,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[9,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[10,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[]
[]
[null,{"$f":"+\"SUB-TOTAL:  \"&A15","v":"SUB-TOTAL:  G5_0"},{"$nulls":3},{"$f":"F18+F30+F42+F54+F66+F78+F90+F102+F114+F126","v":0},null,{"$f":"H18+H30+H42+H54+H66+H78+H90+H102+H114+H126","v":0},null,null,{"$f":"K18+K30+K42+K54+K66+K78+K90+K102+K114+K126","v":0},0]

{"sheet":"G6 Miscellaneous","index":10,"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: VOLUME 1C"]
["(EXCLUDING VALUE ADDED TAX)"]
["BIDDER :",{"$f":"'Bidder Info'!D3","v":"Bidder name"}]
["PROJECT :",{"$f":"Instructions!$D$7","v":"VCS REPLACEMENT"}]
["Item Nr:","G6"]
["Item Description:","MISCELLANEOUS"]
["Foreign Currancy",{"$f":"'Bidder Info'!D4","v":"FC"}]
["ROE: 1R =",{"$f":"'Bidder Info'!D5","v":0.12345}]
[]
[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 = \"&'Bidder Info'!$D$5","v":"ROE: 1R = 0.12345"},"Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[{"$f":"B5","v":"G6"},{"$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.)"]
[null,null,{"$f":"$B$7","v":"FC"},null,null,{"$f":"D18*E18","v":0},{"$f":"$B$8","v":0.12345},{"$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,{"$f":"D19*E19","v":0},0.12345,{"$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,{"$f":"D20*E20","v":0},0.12345,{"$f":"IF(G20<>0,F20/G20,0)","v":0},null,null,{"$f":"I20*J20","v":0},0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,{"$f":"D39*E39","v":0},0.12345,{"$f":"IF(G39<>0,F39/G39,0)","v":0},null,null,{"$f":"I39*J39","v":0},0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[]
[null,{"$f":"+\"SUB-TOTAL:  \"&A15","v":"SUB-TOTAL:  G6"},{"$nulls":3},{"$f":"SUM(F15:F41)","v":0},{"$f":"$B$8","v":0.12345},{"$f":"SUM(H15:H41)","v":0},null,null,{"$f":"SUM(K15:K41)","v":0},{"$f":"SUM(L15:L41)","v":0}]

{"sheet":"G7 Options","index":11,"n_rows":53,"n_cols":12,"rows_kept":53,"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: VOLUME 1C"]
["(EXCLUDING VALUE ADDED TAX)"]
["BIDDER :",{"$f":"'Bidder Info'!D3","v":"Bidder name"}]
["PROJECT :",{"$f":"Instructions!$D$7","v":"VCS REPLACEMENT"}]
["Item Nr:","G7"]
["Item Description:","OPTIONS"]
["Foreign Currancy",{"$f":"'Bidder Info'!D4","v":"FC"}]
["ROE: 1R =",{"$f":"'Bidder Info'!D5","v":0.12345}]
[]
[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 = \"&'Bidder Info'!$D$5","v":"ROE: 1R = 0.12345"},"Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[{"$f":"B5","v":"G7"},{"$f":"B6","v":"OPTIONS"}]
[]
["G7.1","OTHER OPTIONS 1",{"$nulls":3},{"$f":"SUM(F18:F24)","v":0},null,{"$f":"SUM(H18:H24)","v":0},null,null,{"$f":"SUM(K18:K24)","v":0},{"$f":"SUM(L18:L24)","v":0}]
[null,null,{"$f":"$B$7","v":"FC"},null,null,{"$f":"D18*E18","v":0},{"$f":"$B$8","v":0.12345},{"$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,0.12345,0,null,null,0,{"$f":"IF(OR(J19>0,H19>0),H19+K19,0)","v":0}]
[null,null,"FC",null,null,{"$f":"D20*E20","v":0},0.12345,{"$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,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,{"$f":"D22*E22","v":0},0.12345,{"$f":"IF(G22<>0,F22/G22,0)","v":0},null,null,{"$f":"I22*J22","v":0},{"$f":"IF(OR(J22>0,H22>0),H22+K22,0)","v":0}]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[]
["G7.2","OTHER OPTIONS 2",{"$nulls":3},{"$f":"SUM(F27:F34)","v":0},null,{"$f":"SUM(H27:H34)","v":0},null,null,{"$f":"SUM(K27:K34)","v":0},{"$f":"SUM(L27:L34)","v":0}]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,{"$f":"D28*E28","v":0},0.12345,{"$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,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[]
["G7.3","OTHER OPTIONS 3",{"$nulls":3},{"$f":"SUM(F36:F43)","v":0},null,{"$f":"SUM(H36:H43)","v":0},null,null,{"$f":"SUM(K36:K43)","v":0},{"$f":"SUM(L36:L43)","v":0}]
[null,null,"FC",null,null,{"$f":"D36*E36","v":0},0.12345,{"$f":"IF(G36<>0,F36/G36,0)","v":0},null,null,{"$f":"I36*J36","v":0},{"$f":"IF(OR(J36>0,H36>0),H36+K36,0)","v":0}]
[null,null,{"$f":"$B$7","v":"FC"},null,null,0,{"$f":"$B$8","v":0.12345},0,null,null,0,{"$f":"IF(OR(J37>0,H37>0),H37+K37,0)","v":0}]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,{"$f":"D40*E40","v":0},0.12345,{"$f":"IF(G40<>0,F40/G40,0)","v":0},null,null,{"$f":"I40*J40","v":0},{"$f":"IF(OR(J40>0,H40>0),H40+K40,0)","v":0}]
[null,null,"FC",null,null,{"$f":"D41*E41","v":0},0.12345,{"$f":"IF(G41<>0,F41/G41,0)","v":0},null,null,{"$f":"I41*J41","v":0},{"$f":"IF(OR(J41>0,H41>0),H41+K41,0)","v":0}]
[null,null,{"$f":"$B$7","v":"FC"},null,null,0,{"$f":"$B$8","v":0.12345},0,null,null,0,{"$f":"IF(OR(J42>0,H42>0),H42+K42,0)","v":0}]
[]
["G7.4","OTHER OPTIONS 4",{"$nulls":3},{"$f":"SUM(F45:F52)","v":0},null,{"$f":"SUM(H45:H52)","v":0},null,null,{"$f":"SUM(K45:K52)","v":0},{"$f":"SUM(L45:L52)","v":0}]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,{"$f":"D48*E48","v":0},0.12345,{"$f":"IF(G48<>0,F48/G48,0)","v":0},null,null,{"$f":"I48*J48","v":0},{"$f":"IF(OR(J48>0,H48>0),H48+K48,0)","v":0}]
[null,null,"FC",null,null,{"$f":"D49*E49","v":0},0.12345,{"$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,null,"FC",null,null,{"$f":"D50*E50","v":0},0.12345,{"$f":"IF(G50<>0,F50/G50,0)","v":0},null,null,{"$f":"I50*J50","v":0},{"$f":"IF(OR(J50>0,H50>0),H50+K50,0)","v":0}]
[null,null,"FC",null,null,{"$f":"D51*E51","v":0},0.12345,{"$f":"IF(G51<>0,F51/G51,0)","v":0},null,null,{"$f":"I51*J51","v":0},{"$f":"IF(OR(J51>0,H51>0),H51+K51,0)","v":0}]
[]
[null,{"$f":"+\"SUB-TOTAL:  \"&A15","v":"SUB-TOTAL:  G7"},{"$nulls":3},{"$f":"F17+F26+F35+F44","v":0},{"$f":"$B$8","v":0.12345},{"$f":"H17+H26+H35+H44","v":0},null,null,{"$f":"K17+K26+K35+K44","v":0},{"$f":"L17+L26+L35+L44","v":0}]

{"sheet":"G8_1 Support Contract (Base)","index":12,"n_rows":41,"n_cols":12,"rows_kept":41,"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: VOLUME 1C"]
["(EXCLUDING VALUE ADDED TAX)"]
["BIDDER:",{"$f":"'Bidder Info'!D3","v":"Bidder name"}]
["PROJECT :",{"$f":"Instructions!$D$7","v":"VCS REPLACEMENT"}]
["Item Nr:","G8_1"]
["Item Description:","Support & Maintenance Contract (BASE)"]
["Foreign Currancy",{"$f":"'Bidder Info'!D4","v":"FC"}]
["ROE: 1R =",{"$f":"'Bidder Info'!D5","v":0.12345}]
[]
[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 = \"&'Bidder Info'!$D$5","v":"ROE: 1R = 0.12345"},"Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[{"$f":"B5","v":"G8_1"},{"$f":"B6","v":"Support & Maintenance Contract (BASE)"}]
[null,"{Details of the proposed maintenance & Suppoort Contract in base-line costs must be included on this price schedule}"]
["Year 1",null,{"$f":"$B$7","v":"FC"},null,null,{"$f":"D17*E17","v":0},{"$f":"$B$8","v":0.12345},{"$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}]
["Year 2",null,"FC",null,null,0,0.12345,0,null,null,0,0]
["Year 3",null,"FC",null,null,0,0.12345,0,null,null,0,0]
["Year 4",null,"FC",null,null,0,0.12345,0,null,null,0,0]
["Year 5",null,"FC",null,null,0,0.12345,0,null,null,0,0]
["Year 6",null,"FC",null,null,0,0.12345,0,null,null,0,0]
["Year 7",null,"FC",null,null,0,0.12345,0,null,null,0,0]
["Year 8",null,"FC",null,null,0,0.12345,0,null,null,0,0]
["Year 9",null,"FC",null,null,0,0.12345,0,null,null,0,0]
["Year 10",null,"FC",null,null,0,0.12345,0,null,null,0,0]
["Year 11",null,"FC",null,null,0,0.12345,0,null,null,0,0]
["Year 12",null,"FC",null,null,0,0.12345,0,null,null,0,0]
["Year 13",null,"FC",null,null,0,0.12345,0,null,null,0,0]
["Year 14",null,"FC",null,null,0,0.12345,0,null,null,0,0]
["Year 15",null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[]
[null,{"$f":"+\"SUB-TOTAL:  \"&A15","v":"SUB-TOTAL:  G8_1"},{"$nulls":3},{"$f":"SUM(F15:F40)","v":0},null,{"$f":"SUM(H15:H40)","v":0},null,null,{"$f":"SUM(K15:K40)","v":0},{"$f":"SUM(L15:L40)","v":0}]

{"sheet":"G8_2 Support Contract (Infl)","index":13,"n_rows":41,"n_cols":12,"rows_kept":41,"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: VOLUME 1C"]
["(EXCLUDING VALUE ADDED TAX)"]
["BIDDER:",{"$f":"'Bidder Info'!D3","v":"Bidder name"}]
["PROJECT :",{"$f":"Instructions!$D$7","v":"VCS REPLACEMENT"}]
["Item Nr:","G8_2"]
["Item Description:","Support Maintenance Contract (Inflated)"]
["Foreign Currancy",{"$f":"'Bidder Info'!D4","v":"FC"}]
["ROE: 1R =",{"$f":"'Bidder Info'!D5","v":0.12345}]
[]
[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 = \"&'Bidder Info'!$D$5","v":"ROE: 1R = 0.12345"},"Total Foreign Cost in Rands","Quantity","Local Amount Unit Cost","Local Amount Total Cost","Total Rands"]
[]
[]
[{"$f":"B5","v":"G8_2"},{"$f":"B6","v":"Support Maintenance Contract (Inflated)"}]
[null,"{Details of the proposed maintenance and support contract, including all inflation and escalation costs, must be included on this price schedule}"]
["Year 1",null,{"$f":"$B$7","v":"FC"},null,null,{"$f":"D17*E17","v":0},{"$f":"$B$8","v":0.12345},{"$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}]
["Year 2",null,"FC",null,null,0,0.12345,0,null,null,0,0]
["Year 3",null,"FC",null,null,0,0.12345,0,null,null,0,0]
["Year 4",null,"FC",null,null,0,0.12345,0,null,null,0,0]
["Year 5",null,"FC",null,null,0,0.12345,0,null,null,0,0]
["Year 6",null,"FC",null,null,0,0.12345,0,null,null,0,0]
["Year 7",null,"FC",null,null,0,0.12345,0,null,null,0,0]
["Year 8",null,"FC",null,null,0,0.12345,0,null,null,0,0]
["Year 9",null,"FC",null,null,0,0.12345,0,null,null,0,0]
["Year 10",null,"FC",null,null,0,0.12345,0,null,null,0,0]
["Year 11",null,"FC",null,null,0,0.12345,0,null,null,0,0]
["Year 12",null,"FC",null,null,0,0.12345,0,null,null,0,0]
["Year 13",null,"FC",null,null,0,0.12345,0,null,null,0,0]
["Year 14",null,"FC",null,null,0,0.12345,0,null,null,0,0]
["Year 15",null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[null,null,"FC",null,null,0,0.12345,0,null,null,0,0]
[]
[null,{"$f":"+\"SUB-TOTAL:  \"&A15","v":"SUB-TOTAL:  G8_2"},{"$nulls":3},{"$f":"SUM(F15:F40)","v":0},null,{"$f":"SUM(H15:H40)","v":0},null,null,{"$f":"SUM(K15:K40)","v":0},{"$f":"SUM(L15:L40)","v":0}]