{"text_format":"3","workbook":"xlsx","n_sheets":12,"sheets":["Instructions","G1 SUMMARY","G2_1 PMP","G2_2 ILS","G3_1 FALE","G3_2 FAPM","G3_3 FAVG","G3_4 FARB","G4 Miscellaneous","G5 Options","G6_1 Support Contract (Base)","G6_2 Support Contract (Inflated"],"not_rendered":{"defined_names":13},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":18,"n_cols":4,"rows_kept":18,"merged":[[2,3,2,4],[3,3,3,4],[4,3,4,4],[5,3,5,4],[6,3,6,4],[9,2,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[13,3,13,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,4]]}
[]
[]
[null,null,"TENDERER :","Tenderer  Company name"]
[null,null,"Project Name","FALE Region Security Project"]
[null,null,"Foreign Currency:","FC"]
[null,null,"ROE: 1R=",0.1]
[null,null,"Date:","2023-06-12"]
[]
[]
[null,null,"This file contains the following sheets:"]
[null,null,"G1 SUMMARY","Summary of all sheets."]
[null,null,"G2_1 PMP","Project management and associated costs."]
[null,null,"G2_2 ILS","Logistic Support and associated costs."]
[null,null,"G3_1 to 4","All items and associated cost on the equipment per site."]
[null,null,"G4 Miscellaneous","All miscellaneous items costs"]
[null,null,"G5 Options","All optional items and costs"]
[null,null,"G6_1 Support Contract (Base)","10 Year maintenance contract at base cost. Please provide details."]
[null,null,"G6_2 Support Contract (Inflated)","10 Year maintenance contract including inflation. Please provide details."]

{"sheet":"G1 SUMMARY","index":1,"n_rows":41,"n_cols":12,"rows_kept":41,"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"]
["(EXCLUDING VALUE ADDED TAX)"]
["TENDERER :",null,{"$f":"Instructions!D3","v":"Tenderer  Company name"}]
["DESCRIPTION :",null,{"$f":"Instructions!D4","v":"FALE Region Security 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",null,null,{"$f":"'G2_1 PMP'!E57","v":0},{"$f":"'G2_1 PMP'!F57","v":0},{"$f":"'G2_1 PMP'!G57","v":{"v":0.1,"d":"0.1000"}},{"$f":"'G2_1 PMP'!H57","v":0},null,{"$f":"'G2_1 PMP'!J57","v":0},{"$f":"'G2_1 PMP'!K57","v":0},{"$f":"'G2_1 PMP'!L57","v":0}]
["G2.2","Integrated Logistic Support",null,null,{"$f":"'G2_2 ILS'!E57","v":0},{"$f":"'G2_2 ILS'!F57","v":0},{"$f":"'G2_2 ILS'!G41","v":{"v":0.1,"d":"0.1000"}},{"$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"]
["G3.1","FALE",null,null,{"$f":"'G3_1 FALE'!E79","v":0},{"$f":"'G3_1 FALE'!F79","v":0},{"$f":"'G3_1 FALE'!G79","v":{"v":0.1,"d":"0.1000"}},{"$f":"'G3_1 FALE'!H79","v":0},{"$f":"'G3_1 FALE'!I79","v":0},{"$f":"'G3_1 FALE'!J79","v":0},{"$f":"'G3_1 FALE'!K79","v":0},{"$f":"'G3_1 FALE'!L79","v":0}]
["G3.2","FAPM",null,null,{"$f":"'G3_2 FAPM'!E68","v":0},{"$f":"'G3_2 FAPM'!F68","v":0},{"$f":"'G3_2 FAPM'!G68","v":{"v":0.1,"d":"0.1000"}},{"$f":"'G3_2 FAPM'!H68","v":0},{"$f":"'G3_2 FAPM'!I68","v":0},{"$f":"'G3_2 FAPM'!J68","v":0},{"$f":"'G3_2 FAPM'!K68","v":0},{"$f":"'G3_2 FAPM'!L68","v":0}]
["G3.3","FAVG",null,null,{"$f":"'G3_3 FAVG'!E66","v":0},{"$f":"'G3_3 FAVG'!F66","v":0},{"$f":"'G3_3 FAVG'!G66","v":{"v":0.1,"d":"0.1000"}},{"$f":"'G3_3 FAVG'!H66","v":0},{"$f":"'G3_3 FAVG'!I66","v":0},{"$f":"'G3_3 FAVG'!J66","v":0},{"$f":"'G3_3 FAVG'!K66","v":0},{"$f":"'G3_3 FAVG'!L66","v":0}]
["G3.4","FARB",null,null,{"$f":"'G3_4 FARB'!E61","v":0},{"$f":"'G3_4 FARB'!F61","v":0},{"$f":"'G3_4 FARB'!G61","v":{"v":0.1,"d":"0.1000"}},{"$f":"'G3_4 FARB'!H61","v":0},{"$f":"'G3_4 FARB'!I61","v":0},{"$f":"'G3_4 FARB'!J61","v":0},{"$f":"'G3_4 FARB'!K61","v":0},{"$f":"'G3_4 FARB'!L61","v":0}]
[]
["G4","MISCELLANEOUS",null,null,{"$f":"'G4 Miscellaneous'!E42","v":0},{"$f":"'G4 Miscellaneous'!F42","v":0},{"$f":"'G4 Miscellaneous'!G42","v":{"v":0.1,"d":"0.1000"}},{"$f":"'G4 Miscellaneous'!H42","v":0},null,{"$f":"'G4 Miscellaneous'!J42","v":0},{"$f":"'G4 Miscellaneous'!K42","v":0},{"$f":"'G4 Miscellaneous'!L42","v":0}]
[]
[]
[null,"TOTAL EQUIPMENT EXCLUDING OPTIONS :",null,null,{"$f":"SUM(E15:E28)","v":0},{"$f":"SUM(F15:F28)","v":0},null,{"$f":"SUM(H15:H28)","v":0},null,{"$f":"SUM(J15:J28)","v":0},{"$f":"SUM(K15:K28)","v":0},{"$f":"SUM(L15:L28)","v":0}]
[]
["G5","OPTIONS",null,null,{"$f":"'G5 Options'!E$61","v":0},{"$f":"'G5 Options'!F$61","v":0},{"$f":"'G5 Options'!G$61","v":{"v":0.1,"d":"0.1000"}},{"$f":"'G5 Options'!H$61","v":0},null,{"$f":"'G5 Options'!J$61","v":0},{"$f":"'G5 Options'!K$61","v":0},{"$f":"'G5 Options'!L$61","v":0}]
[]
["G6.1","SUPPORT CONTRACT with Inflation",null,null,{"$f":"'G6_2 Support Contract (Inflated'!E41","v":0},{"$f":"'G6_2 Support Contract (Inflated'!F41","v":0},{"$f":"'G6_2 Support Contract (Inflated'!G41","v":{"v":0.1,"d":"0.1000"}},{"$f":"'G6_2 Support Contract (Inflated'!H41","v":0},{"$f":"'G6_2 Support Contract (Inflated'!I41","v":0},{"$f":"'G6_2 Support Contract (Inflated'!J41","v":0},{"$f":"'G6_2 Support Contract (Inflated'!K41","v":0},{"$f":"'G6_2 Support Contract (Inflated'!L41","v":0}]
[]
[]
[null,"GRAND TOTAL :",null,null,{"$f":"E31+E29+E33","v":0},{"$f":"F31+F29+F33","v":0},null,{"$f":"H31+H29+H33","v":0},null,{"$f":"J31+J29+J33","v":0},0,0]
[]
[null,"VAT",{"$nulls":5},{"$f":"H36*0.15","v":0},null,null,{"$f":"K36*0.15","v":0},{"$f":"L36*0.15","v":0}]
[]
[]
[null,"GRAND TOTAL (Volume 1A Form of Bid):",{"$nulls":5},{"$f":"H36+H38","v":0},null,null,{"$f":"K36+K38","v":0},0]

{"sheet":"G2_1 PMP","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"]
["(EXCLUDING VALUE ADDED TAX)"]
["TENDERER :",{"$f":"Instructions!D3","v":"Tenderer  Company name"}]
["PROJECT :",{"$f":"Instructions!D4","v":"FALE Region Security 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 Status Reports",{"$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,"As-Built Drawings","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Master Project Schedule","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Safety 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]
[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.2","Acceptance Tests",{"$nulls":3},0]
[null,null,{"$f":"$B$7","v":"FC"},null,null,{"$f":"D32*E32","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G32<>0,F32/G32,0)","v":0},null,null,{"$f":"I32*J32","v":0},{"$f":"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,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.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:E55)","v":0},{"$f":"SUM(F15:F55)","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"SUM(H15:H55)","v":0},null,{"$f":"SUM(J15:J55)","v":0},{"$f":"SUM(K15:K55)","v":0},{"$f":"SUM(L15:L55)","v":0}]

{"sheet":"G2_2 ILS","index":3,"n_rows":57,"n_cols":12,"rows_kept":57,"merged":[[0,0,0,1],[1,0,1,1],[9,2,10,7],[9,8,10,10],[11,0,13,0],[11,1,13,1],[11,2,13,2],[11,4,13,4],[11,5,13,5],[11,6,13,6],[11,7,13,7],[11,9,13,9],[11,10,13,10],[11,11,13,11]]}
["TENDER PRICE SCHEDULE: APPENDIX G2.2"]
["(EXCLUDING VALUE ADDED TAX)"]
["TENDERER :",{"$f":"Instructions!D3","v":"Tenderer  Company name"}]
["PROJECT :",{"$f":"Instructions!D4","v":"FALE Region Security 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,"Training","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,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"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:E55)","v":0},{"$f":"SUM(F15:F55)","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"SUM(H15:H55)","v":0},null,{"$f":"SUM(J15:J55)","v":0},{"$f":"SUM(K15:K55)","v":0},{"$f":"SUM(L15:L55)","v":0}]

{"sheet":"G3_1 FALE","index":4,"n_rows":79,"n_cols":12,"rows_kept":79,"merged":[[0,0,0,1],[1,0,1,1],[9,2,10,7],[9,8,10,10],[11,0,13,0],[11,1,13,1],[11,2,13,2],[11,4,13,4],[11,5,13,5],[11,6,13,6],[11,7,13,7],[11,9,13,9],[11,10,13,10],[11,11,13,11]]}
["TENDER PRICE SCHEDULE: APPENDIX G3.1"]
["(EXCLUDING VALUE ADDED TAX)"]
["TENDERER :",{"$f":"Instructions!D3","v":"Tenderer  Company name"}]
["PROJECT :",{"$f":"Instructions!D4","v":"FALE Region Security Project"}]
["Item Nr:","G3.1"]
["Item Description:","King Shaka ATSU"]
["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.1"},{"$f":"B6","v":"King Shaka ATSU"}]
[null,"(All equipment as required, with at least the following headings.)"]
[]
[null,"Access Control System"]
[null,"Access Control Management System",{"$f":"$B$7","v":"FC"},1,null,{"$f":"D19*E19","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G19<>0,F19/G19,0)","v":0},1,null,{"$f":"I19*J19","v":0},{"$f":"IF(OR(J19>0,H19>0),H19+K19,0)","v":0}]
[null,"Proximity Readers","FC",36,null,{"$f":"D20*E20","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G20<>0,F20/G20,0)","v":0},36,null,{"$f":"I20*J20","v":0},0]
[null,"Outdoor Proximity Readers (IP67)","FC",6,null,{"$f":"D21*E21","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G21<>0,F21/G21,0)","v":0},6,null,{"$f":"I21*J21","v":0},{"$f":"IF(OR(J21>0,H21>0),H21+K21,0)","v":0}]
[null,"Outdoor Waterproof Housing","FC",6,null,0,{"v":0.1,"d":"0.10000"},0,6,null,0,0]
[null,"Door Controllers","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Bypass Key Switches","FC",17,null,0,{"v":0.1,"d":"0.10000"},0,17,null,0,0]
[null,"Bypass Keys","FC",10,null,0,{"v":0.1,"d":"0.10000"},0,10,null,0,0]
[null,"Green Call Point","FC",17,null,{"$f":"D26*E26","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G26<>0,F26/G26,0)","v":0},17,null,{"$f":"I26*J26","v":0},0]
[null,"User Registration Workstation","FC",2,null,0,{"v":0.1,"d":"0.10000"},0,2,null,0,0]
[null,"RFID Cards","FC",500,null,0,{"v":0.1,"d":"0.10000"},0,500,null,0,0]
[null,"PVC Cards","FC",500,null,0,{"v":0.1,"d":"0.10000"},0,500,null,0,0]
[null,"Biometric Reader/Writer","FC",2,null,0,{"v":0.1,"d":"0.10000"},0,2,null,0,0]
[null,"Card Printer","FC",2,null,0,{"v":0.1,"d":"0.10000"},0,2,null,0,0]
[null,"Card Printing Templates","FC",3,null,0,{"v":0.1,"d":"0.10000"},0,3,null,0,0]
[null,"Printer Ribbons","FC",2,null,0,{"v":0.1,"d":"0.10000"},0,2,null,0,0]
[null,"Locking Mechanism","FC",17,null,0,{"v":0.1,"d":"0.10000"},0,17,null,0,0]
[null,"Automatic Door Closures","FC",17,null,0,{"v":0.1,"d":"0.10000"},0,17,null,0,0]
[null,"Door Open/Close Sensors","FC",17,null,0,{"v":0.1,"d":"0.10000"},0,17,null,0,0]
[null,"FALE Guard House"]
[null,"Turnstile Control Cards","FC",2,null,0,{"v":0.1,"d":"0.10000"},0,2,null,0,0]
[null,"Boom Gate Control Cards","FC",4,null,0,{"v":0.1,"d":"0.10000"},0,4,null,0,0]
[null,"Spike Barrier Control Cards","FC",2,null,{"$f":"D40*E40","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G40<>0,F40/G40,0)","v":0},2,null,{"$f":"I40*J40","v":0},{"$f":"IF(OR(J40>0,H40>0),H40+K40,0)","v":0}]
[null,"Loop Detectors","FC",4,null,0,{"v":0.1,"d":"0.10000"},0,4,null,0,0]
[null,"Loop Connection Wiring","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Corrosion Treatment and Paint","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,{"$f":"D44*E44","v":0},{"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,"CCTV System"]
[null,"32-channel NVR","FC",1,null,{"$f":"D46*E46","v":0},{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,"Outdoor Bullet Cameras (50m IR Range)","FC",8,null,0,{"v":0.1,"d":"0.10000"},0,8,null,0,0]
[null,"Indoor Dome Cameras","FC",14,null,0,{"v":0.1,"d":"0.10000"},0,14,null,0,0]
[null,"Outdoor Dome Cameras","FC",4,null,0,{"v":0.1,"d":"0.10000"},0,4,null,0,0]
[null,"Additional Cameras","FC",6,null,0,{"v":0.1,"d":"0.10000"},0,6,null,0,0]
[null,"Reception Monitor Position","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,"ATC Monitor Position","FC",2,null,0,{"v":0.1,"d":"0.10000"},0,2,null,0,0]
[null,"FALE Guard House Operator Positions","FC",2,null,0,{"v":0.1,"d":"0.10000"},0,2,null,0,0]
[null,"Equipment Room Operator Position","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,"PoE Switches","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,{"$f":"D56*E56","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G56<>0,F56/G56,0)","v":0},null,null,{"$f":"I56*J56","v":0},{"$f":"IF(OR(J56>0,H56>0),H56+K56,0)","v":0}]
[null,"Intrude Alarm System"]
[null,"Alarm System (5 Zone)","FC",1,null,{"$f":"D58*E58","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G58<>0,F58/G58,0)","v":0},1,null,{"$f":"I58*J58","v":0},{"$f":"IF(OR(J58>0,H58>0),H58+K58,0)","v":0}]
[null,"Control Panel","FC",4,null,0,{"v":0.1,"d":"0.10000"},0,4,null,0,0]
[null,"Magnetic Contacts","FC",6,null,0,{"v":0.1,"d":"0.10000"},0,6,null,0,0]
[null,"Infrared Strips","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Fixed Panic Buttons","FC",4,null,{"$f":"D62*E62","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G62<>0,F62/G62,0)","v":0},4,null,{"$f":"I62*J62","v":0},{"$f":"IF(OR(J62>0,H62>0),H62+K62,0)","v":0}]
[null,"Wireless Panic Buttons","FC",2,null,0,{"v":0.1,"d":"0.10000"},0,2,null,0,0]
[null,null,"FC",null,null,{"$f":"D64*E64","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G64<>0,F64/G64,0)","v":0},null,null,{"$f":"I64*J64","v":0},{"$f":"IF(OR(J64>0,H64>0),H64+K64,0)","v":0}]
[null,"Additional Items"]
[null,"Equipment Cabinet (Floor Standing)","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,"CAT6 Ethernet Cable","FC",null,null,{"$f":"D67*E67","v":0},{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Network Switches","FC",null,null,{"$f":"D68*E68","v":0},{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Fibre Interfaces","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Patch Panels","FC",null,null,{"$f":"D70*E70","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G70<>0,F70/G70,0)","v":0},null,null,{"$f":"I70*J70","v":0},{"$f":"IF(OR(J70>0,H70>0),H70+K70,0)","v":0}]
[null,"Electrical Compliance Certificate","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,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":"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},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"},{"$f":"IF(G78<>0,F78/G78,0)","v":0},null,null,{"$f":"I78*J78","v":0},{"$f":"IF(OR(J78>0,H78>0),H78+K78,0)","v":0}]
[null,{"$f":"+\"SUB-TOTAL:  \"&A15","v":"SUB-TOTAL:  G3.1"},null,null,{"$f":"SUM(E15:E78)","v":0},{"$f":"SUM(F15:F78)","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"SUM(H15:H78)","v":0},null,null,{"$f":"SUM(K15:K78)","v":0},{"$f":"SUM(L15:L78)","v":0}]

{"sheet":"G3_2 FAPM","index":5,"n_rows":68,"n_cols":12,"rows_kept":68,"merged":[[0,0,0,1],[1,0,1,1],[9,2,10,7],[9,8,10,10],[11,0,13,0],[11,1,13,1],[11,2,13,2],[11,4,13,4],[11,5,13,5],[11,6,13,6],[11,7,13,7],[11,9,13,9],[11,10,13,10],[11,11,13,11]]}
["TENDER PRICE SCHEDULE: APPENDIX G3.1"]
["(EXCLUDING VALUE ADDED TAX)"]
["TENDERER :",{"$f":"Instructions!D3","v":"Tenderer  Company name"}]
["PROJECT :",{"$f":"Instructions!D4","v":"FALE Region Security Project"}]
["Item Nr:","G3.2"]
["Item Description:","Pietermaritzburg ATSU"]
["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.2"},{"$f":"B6","v":"Pietermaritzburg ATSU"}]
[null,"(All equipment as required, with at least the following headings.)"]
[]
[null,"Access Control System"]
[null,"Access Control Management System",{"$f":"$B$7","v":"FC"},1,null,{"$f":"D19*E19","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G19<>0,F19/G19,0)","v":0},1,null,{"$f":"I19*J19","v":0},{"$f":"IF(OR(J19>0,H19>0),H19+K19,0)","v":0}]
[null,"Proximity Readers","FC",8,null,0,{"v":0.1,"d":"0.10000"},0,8,null,0,0]
[null,"Outdoor Proximity Readers (IP67)","FC",2,null,0,{"v":0.1,"d":"0.10000"},0,2,null,0,0]
[null,"Outdoor Waterproof Housing","FC",2,null,0,{"v":0.1,"d":"0.10000"},0,2,null,0,0]
[null,"Door Controllers","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Bypass Key Switches","FC",5,null,0,{"v":0.1,"d":"0.10000"},0,5,null,0,0]
[null,"Bypass Keys","FC",4,null,0,{"v":0.1,"d":"0.10000"},0,4,null,0,0]
[null,"Green Call Point","FC",5,null,0,{"v":0.1,"d":"0.10000"},0,5,null,0,0]
[null,"User Registration Workstation","FC",0,null,0,{"v":0.1,"d":"0.10000"},0,0,null,0,0]
[null,"RFID Cards","FC",50,null,0,{"v":0.1,"d":"0.10000"},0,50,null,0,0]
[null,"PVC Cards","FC",100,null,0,{"v":0.1,"d":"0.10000"},0,100,null,0,0]
[null,"Biometric Reader/Writer","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,"Card Printer","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,"Printer Ribbons","FC",2,null,0,{"v":0.1,"d":"0.10000"},0,2,null,0,0]
[null,"Locking Mechanism","FC",5,null,0,{"v":0.1,"d":"0.10000"},0,5,null,0,0]
[null,"Automatic Door Closures","FC",5,null,0,{"v":0.1,"d":"0.10000"},0,5,null,0,0]
[null,"Door Open/Close Sensors","FC",5,null,0,{"v":0.1,"d":"0.10000"},0,5,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"CCTV System"]
[null,"8-channel NVR","FC",1,null,{"$f":"D38*E38","v":0},{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,"Indoor Dome Cameras","FC",3,null,0,{"v":0.1,"d":"0.10000"},0,3,null,0,0]
[null,"Outdoor Bullet Cameras","FC",2,null,0,{"v":0.1,"d":"0.10000"},0,2,null,0,0]
[null,"Additional Cameras","FC",0,null,0,{"v":0.1,"d":"0.10000"},0,0,null,0,0]
[null,"PoE Switches","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,"Intrude Alarm System"]
[null,"Alarm System (1 Zone)","FC",1,null,{"$f":"D45*E45","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G45<>0,F45/G45,0)","v":0},1,null,{"$f":"I45*J45","v":0},{"$f":"IF(OR(J45>0,H45>0),H45+K45,0)","v":0}]
[null,"Control Panel","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,"Magnetic Contacts","FC",2,null,0,{"v":0.1,"d":"0.10000"},0,2,null,0,0]
[null,"Fixed Panic Buttons","FC",2,null,0,{"v":0.1,"d":"0.10000"},0,2,null,0,0]
[null,"Motion Detectors","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Intercom System"]
[null,"Gate Station","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,"Handset","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Additional Items"]
[null,"System Integration PC","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,"Equipment Cabinet (Wall Mounted)","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,"CAT6 Ethernet Cable","FC",null,null,{"$f":"D58*E58","v":0},{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Network Switches","FC",null,null,{"$f":"D59*E59","v":0},{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Electrical Compliance Certificate","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,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":"D64*E64","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G64<>0,F64/G64,0)","v":0},null,null,{"$f":"I64*J64","v":0},0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},{"$f":"IF(G67<>0,F67/G67,0)","v":0},null,null,{"$f":"I67*J67","v":0},{"$f":"IF(OR(J67>0,H67>0),H67+K67,0)","v":0}]
[null,{"$f":"+\"SUB-TOTAL:  \"&A15","v":"SUB-TOTAL:  G3.2"},null,null,{"$f":"SUM(E15:E67)","v":0},{"$f":"SUM(F15:F67)","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"SUM(H15:H67)","v":0},null,null,{"$f":"SUM(K15:K67)","v":0},{"$f":"SUM(L15:L67)","v":0}]

{"sheet":"G3_3 FAVG","index":6,"n_rows":66,"n_cols":12,"rows_kept":66,"merged":[[0,0,0,1],[1,0,1,1],[9,2,10,7],[9,8,10,10],[11,0,13,0],[11,1,13,1],[11,2,13,2],[11,4,13,4],[11,5,13,5],[11,6,13,6],[11,7,13,7],[11,9,13,9],[11,10,13,10],[11,11,13,11]]}
["TENDER PRICE SCHEDULE: APPENDIX G3.1"]
["(EXCLUDING VALUE ADDED TAX)"]
["TENDERER :",{"$f":"Instructions!D3","v":"Tenderer  Company name"}]
["PROJECT :",{"$f":"Instructions!D4","v":"FALE Region Security Project"}]
["Item Nr:","G3.3"]
["Item Description:","Viginia ATSU"]
["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.3"},{"$f":"B6","v":"Viginia ATSU"}]
[null,"(All equipment as required, with at least the following headings.)"]
[]
[null,"Access Control System"]
[null,"Access Control Management System",{"$f":"$B$7","v":"FC"},1,null,{"$f":"D19*E19","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G19<>0,F19/G19,0)","v":0},1,null,{"$f":"I19*J19","v":0},{"$f":"IF(OR(J19>0,H19>0),H19+K19,0)","v":0}]
[null,"Proximity Readers","FC",6,null,0,{"v":0.1,"d":"0.10000"},0,6,null,0,0]
[null,"Door Controllers","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Bypass Key Switches","FC",3,null,0,{"v":0.1,"d":"0.10000"},0,3,null,0,0]
[null,"Bypass Keys","FC",4,null,0,{"v":0.1,"d":"0.10000"},0,4,null,0,0]
[null,"Green Call Point","FC",3,null,0,{"v":0.1,"d":"0.10000"},0,3,null,0,0]
[null,"User Registration Workstation","FC",0,null,0,{"v":0.1,"d":"0.10000"},0,0,null,0,0]
[null,"RFID Cards","FC",50,null,0,{"v":0.1,"d":"0.10000"},0,50,null,0,0]
[null,"PVC Cards","FC",100,null,0,{"v":0.1,"d":"0.10000"},0,100,null,0,0]
[null,"Biometric Reader/Writer","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,"Card Printer","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,"Printer Ribbons","FC",2,null,0,{"v":0.1,"d":"0.10000"},0,2,null,0,0]
[null,"Locking Mechanism","FC",3,null,0,{"v":0.1,"d":"0.10000"},0,3,null,0,0]
[null,"Automatic Door Closures","FC",3,null,0,{"v":0.1,"d":"0.10000"},0,3,null,0,0]
[null,"Door Open/Close Sensors","FC",3,null,0,{"v":0.1,"d":"0.10000"},0,3,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"CCTV System"]
[null,"8-channel NVR","FC",1,null,{"$f":"D36*E36","v":0},{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,"Indoor Dome Cameras","FC",3,null,0,{"v":0.1,"d":"0.10000"},0,3,null,0,0]
[null,"Outdoor Bullet Cameras","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,"Additional Cameras","FC",0,null,0,{"v":0.1,"d":"0.10000"},0,0,null,0,0]
[null,"PoE Switches","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,"Intrude Alarm System"]
[null,"Alarm System (1 Zone)","FC",1,null,{"$f":"D43*E43","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G43<>0,F43/G43,0)","v":0},1,null,{"$f":"I43*J43","v":0},{"$f":"IF(OR(J43>0,H43>0),H43+K43,0)","v":0}]
[null,"Control Panel","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,"Magnetic Contacts","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,"Fixed Panic Buttons","FC",2,null,0,{"v":0.1,"d":"0.10000"},0,2,null,0,0]
[null,"Motion Detectors","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Intercom System"]
[null,"Gate Station","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,"Handset","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Additional Items"]
[null,"System Integration PC","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,"Equipment Cabinet (Wall Mounted)","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,"CAT6 Ethernet Cable","FC",null,null,{"$f":"D56*E56","v":0},{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Network Switches","FC",null,null,{"$f":"D57*E57","v":0},{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Electrical Compliance Certificate","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,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":"D62*E62","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G62<>0,F62/G62,0)","v":0},null,null,{"$f":"I62*J62","v":0},0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,{"$f":"+\"SUB-TOTAL:  \"&A15","v":"SUB-TOTAL:  G3.3"},null,null,{"$f":"SUM(E15:E65)","v":0},{"$f":"SUM(F15:F65)","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"SUM(H15:H65)","v":0},null,null,{"$f":"SUM(K15:K65)","v":0},{"$f":"SUM(L15:L65)","v":0}]

{"sheet":"G3_4 FARB","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,4,13,4],[11,5,13,5],[11,6,13,6],[11,7,13,7],[11,9,13,9],[11,10,13,10],[11,11,13,11]]}
["TENDER PRICE SCHEDULE: APPENDIX G3.1"]
["(EXCLUDING VALUE ADDED TAX)"]
["TENDERER :",{"$f":"Instructions!D3","v":"Tenderer  Company name"}]
["PROJECT :",{"$f":"Instructions!D4","v":"FALE Region Security Project"}]
["Item Nr:","G3.4"]
["Item Description:","Richards Bay ATSU"]
["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.4"},{"$f":"B6","v":"Richards Bay ATSU"}]
[null,"(All equipment as required, with at least the following headings.)"]
[]
[null,"Access Control System"]
[null,"Access Control Management System",{"$f":"$B$7","v":"FC"},1,null,{"$f":"D19*E19","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G19<>0,F19/G19,0)","v":0},1,null,{"$f":"I19*J19","v":0},{"$f":"IF(OR(J19>0,H19>0),H19+K19,0)","v":0}]
[null,"Proximity Readers","FC",3,null,0,{"v":0.1,"d":"0.10000"},0,3,null,0,0]
[null,"Outdoor Proximity Readers (IP67)","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,"Outdoor Waterproof Housing","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,"Door Controllers","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Bypass Key Switches","FC",2,null,0,{"v":0.1,"d":"0.10000"},0,2,null,0,0]
[null,"Bypass Keys","FC",4,null,0,{"v":0.1,"d":"0.10000"},0,4,null,0,0]
[null,"Green Call Point","FC",2,null,0,{"v":0.1,"d":"0.10000"},0,2,null,0,0]
[null,"User Registration Workstation","FC",0,null,0,{"v":0.1,"d":"0.10000"},0,0,null,0,0]
[null,"RFID Cards","FC",50,null,0,{"v":0.1,"d":"0.10000"},0,50,null,0,0]
[null,"PVC Cards","FC",100,null,0,{"v":0.1,"d":"0.10000"},0,100,null,0,0]
[null,"Biometric Reader/Writer","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,"Card Printer","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,"Printer Ribbons","FC",2,null,0,{"v":0.1,"d":"0.10000"},0,2,null,0,0]
[null,"Locking Mechanism","FC",2,null,0,{"v":0.1,"d":"0.10000"},0,2,null,0,0]
[null,"Automatic Door Closures","FC",2,null,0,{"v":0.1,"d":"0.10000"},0,2,null,0,0]
[null,"Door Open/Close Sensors","FC",2,null,0,{"v":0.1,"d":"0.10000"},0,2,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"CCTV System"]
[null,"8-channel NVR","FC",1,null,{"$f":"D38*E38","v":0},{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,"Indoor Dome Cameras","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,"Outdoor Bullet Cameras","FC",0,null,0,{"v":0.1,"d":"0.10000"},0,0,null,0,0]
[null,"Additional Cameras","FC",0,null,0,{"v":0.1,"d":"0.10000"},0,0,null,0,0]
[null,"PoE Switches","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,{"$f":"D43*E43","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G43<>0,F43/G43,0)","v":0},null,null,{"$f":"I43*J43","v":0},{"$f":"IF(OR(J43>0,H43>0),H43+K43,0)","v":0}]
[null,"Intercom System"]
[null,"Gate Station","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,"Handset","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Additional Items"]
[null,"System Integration PC","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,"Equipment Cabinet (Wall Mounted)","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,null,0,0]
[null,"CAT6 Ethernet Cable","FC",null,null,{"$f":"D51*E51","v":0},{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Network Switches","FC",null,null,{"$f":"D52*E52","v":0},{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Electrical Compliance Certificate","FC",1,null,0,{"v":0.1,"d":"0.10000"},0,1,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":"D57*E57","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G57<>0,F57/G57,0)","v":0},null,null,{"$f":"I57*J57","v":0},0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,{"$f":"+\"SUB-TOTAL:  \"&A15","v":"SUB-TOTAL:  G3.4"},null,null,{"$f":"SUM(E15:E60)","v":0},{"$f":"SUM(F15:F60)","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"SUM(H15:H60)","v":0},null,null,{"$f":"SUM(K15:K60)","v":0},{"$f":"SUM(L15:L60)","v":0}]

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

{"sheet":"G5 Options","index":9,"n_rows":61,"n_cols":12,"rows_kept":61,"merged":[[0,0,0,1],[1,0,1,1],[9,2,10,7],[9,8,10,10],[11,0,13,0],[11,1,13,1],[11,2,13,2],[11,3,13,3],[11,4,13,4],[11,5,13,5],[11,6,13,6],[11,7,13,7],[11,9,13,9],[11,10,13,10],[11,11,13,11]]}
["TENDER PRICE SCHEDULE: APPENDIX G5"]
["(EXCLUDING VALUE ADDED TAX)"]
["TENDERER :",{"$f":"Instructions!D3","v":"Tenderer  Company name"}]
["PROJECT :",{"$f":"Instructions!D4","v":"FALE Region Security Project"}]
["Item Nr:","G5"]
["Item Description:","OPTIONS"]
["Foreign Currancy",{"$f":"Instructions!D5","v":"FC"}]
["ROE: 1R =",{"$f":"Instructions!D6","v":0.1}]
[]
[null,null,"Overseas Items",{"$nulls":5},"Local Items"]
[]
["Schedule Item Number","Description","Foreign Currency","Quantity","Foreign Amount Unit Cost","Foreign Amount  Total Cost","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":"OPTIONS"}]
["G5.1"]
[null,null,{"$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,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,{"$f":"D24*E24","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G24<>0,F24/G24,0)","v":0},null,null,{"$f":"I24*J24","v":0},{"$f":"IF(OR(J24>0,H24>0),H24+K24,0)","v":0}]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,{"$f":"D41*E41","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G41<>0,F41/G41,0)","v":0},null,null,{"$f":"I41*J41","v":0},0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,null,"FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[]
[null,{"$f":"+\"SUB-TOTAL:  \"&A15","v":"SUB-TOTAL:  G5"},null,null,{"$f":"SUM(E17:E60)","v":0},{"$f":"SUM(F17:F60)","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"SUM(H17:H60)","v":0},null,{"$f":"SUM(J17:J60)","v":0},0,{"$f":"SUM(L17:L60)","v":0}]

{"sheet":"G6_1 Support Contract (Base)","index":10,"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: APPENDIX G6"]
["(EXCLUDING VALUE ADDED TAX)"]
["TENDERER :",{"$f":"Instructions!D3","v":"Tenderer  Company name"}]
["PROJECT :",{"$f":"Instructions!D4","v":"FALE Region Security Project"}]
["Item Nr:","G6.1"]
["Item Description:","Support Contract in base cost"]
["Foreign Currancy",{"$f":"Instructions!D5","v":"FC"}]
["ROE: 1R =",{"$f":"Instructions!D6","v":0.1}]
[]
[null,null,"Overseas Items",{"$nulls":5},"Local Items"]
[]
["Schedule Item Number","Description","Foreign Currency","Quantity","Foreign Amount Unit Cost","Foreign Amount  Total Cost","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 Contract in base cost"}]
[null,"{Details of the proposed maintenance contract must be included on this price schedule}"]
[]
[null,"Year 1",{"$f":"$B$7","v":"FC"},null,null,{"$f":"D18*E18","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G18<>0,F18/G18,0)","v":0},null,null,{"$f":"I18*J18","v":0},{"$f":"IF(OR(J18>0,H18>0),H18+K18,0)","v":0}]
[null,"Year 2","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Year 3","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Year 4","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Year 5","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Year 6","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Year 7","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Year 8","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Year 9","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Year 10","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,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(E18:E40)","v":0},{"$f":"SUM(F18:F40)","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"SUM(H18:H40)","v":0},null,{"$f":"SUM(J18:J40)","v":0},{"$f":"SUM(K18:K40)","v":0},0]

{"sheet":"G6_2 Support Contract (Inflated","index":11,"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: APPENDIX G6"]
["(EXCLUDING VALUE ADDED TAX)"]
["TENDERER :",{"$f":"Instructions!D3","v":"Tenderer  Company name"}]
["PROJECT :",{"$f":"Instructions!D4","v":"FALE Region Security Project"}]
["Item Nr:","G6.2"]
["Item Description:","Support Contract with Inflation"]
["Foreign Currancy",{"$f":"Instructions!D5","v":"FC"}]
["ROE: 1R =",{"$f":"Instructions!D6","v":0.1}]
[]
[null,null,"Overseas Items",{"$nulls":5},"Local Items"]
[]
["Schedule Item Number","Description","Foreign Currency","Quantity","Foreign Amount Unit Cost","Foreign Amount  Total Cost","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":"Support Contract with Inflation"}]
[null,"{Details of the proposed maintenance contract must be included on this price schedule}"]
[]
[null,"Year 1",{"$f":"$B$7","v":"FC"},null,null,{"$f":"D18*E18","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"IF(G18<>0,F18/G18,0)","v":0},null,null,{"$f":"I18*J18","v":0},{"$f":"IF(OR(J18>0,H18>0),H18+K18,0)","v":0}]
[null,"Year 2","FC",null,null,{"$f":"D19*E19","v":0},{"v":0.1,"d":"0.10000"},{"$f":"IF(G19<>0,F19/G19,0)","v":0},null,null,{"$f":"I19*J19","v":0},{"$f":"IF(OR(J19>0,H19>0),H19+K19,0)","v":0}]
[null,"Year 3","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Year 4","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Year 5","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Year 6","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Year 7","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Year 8","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Year 9","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,"Year 10","FC",null,null,0,{"v":0.1,"d":"0.10000"},0,null,null,0,0]
[null,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.2"},null,null,{"$f":"SUM(E18:E40)","v":0},{"$f":"SUM(F18:F40)","v":0},{"$f":"$B$8","v":{"v":0.1,"d":"0.10000"}},{"$f":"SUM(H18:H40)","v":0},null,{"$f":"SUM(J18:J40)","v":0},{"$f":"SUM(K18:K40)","v":0},0]