{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["EH_Summary","Dx_License","Dx_Implement. and Support","NTCSA_License","NTCSA_Implement. and Support","Currency"],"not_rendered":{"external_links":11,"defined_names":422},"read":"whole","date_system":"1900"}

{"sheet":"EH_Summary","index":0,"n_rows":38,"n_cols":10,"rows_kept":38,"merged":[[3,1,3,6],[8,1,21,1],[22,1,35,1]]}
[]
[null,"Costing : Enterprise Historian"]
[]
[null,"VENDOR NAME"]
[]
[]
[]
[null,null,"ENVIRONMENT","DESCRIPTION","YEAR 1","YEAR 2","YEAR 3","YEAR 4","YEAR 5"]
[null,"Dx","PRODUCTION ENVIRONMENT","Subscription service",{"$f":"Dx_License!E28","v":0},{"$f":"Dx_License!F28","v":0},{"$f":"Dx_License!G28","v":0},{"$f":"Dx_License!H28","v":0},{"$f":"Dx_License!I28","v":0}]
[null,null,"PRE-PRODUCTION ENVIRONMENT","Subscription service",{"$f":"Dx_License!E29","v":0},{"$f":"Dx_License!F29","v":0},{"$f":"Dx_License!G29","v":0},{"$f":"Dx_License!H29","v":0},{"$f":"Dx_License!I29","v":0}]
[null,null,"DISASTER RECOVERY ENVIRONMENT","Subscription service",{"$f":"Dx_License!E30","v":0},{"$f":"Dx_License!F30","v":0},{"$f":"Dx_License!G30","v":0},{"$f":"Dx_License!H30","v":0},{"$f":"Dx_License!I30","v":0}]
[null,null,"QUALITY ASSURANCE ENVIRONMENT","Subscription service",{"$f":"Dx_License!E31","v":0},{"$f":"Dx_License!F31","v":0},{"$f":"Dx_License!G31","v":0},{"$f":"Dx_License!H31","v":0},{"$f":"Dx_License!I31","v":0}]
[null,null,"DEVELOPMENT ENVIRONMENT","Subscription service",{"$f":"Dx_License!E32","v":0},{"$f":"Dx_License!F32","v":0},{"$f":"Dx_License!G32","v":0},{"$f":"Dx_License!H32","v":0},{"$f":"Dx_License!I32","v":0}]
[null,null,"TRAINING ENVIRONMENT","Subscription service",{"$f":"Dx_License!E33","v":0},{"$f":"Dx_License!F33","v":0},{"$f":"Dx_License!G33","v":0},{"$f":"Dx_License!H33","v":0},{"$f":"Dx_License!I33","v":0}]
[null,null,"TOTAL",null,{"$f":"SUM(E9:E14)","v":0},{"$f":"SUM(F9:F14)","v":0},{"$f":"SUM(G9:G14)","v":0},{"$f":"SUM(H9:H14)","v":0},{"$f":"SUM(I9:I14)","v":0}]
[null,null,"SUB TOTAL",{"$f":"SUM(E15,F15,G15,H15,I15)","v":0}]
[]
[null,null,"SOLUTION IMPLEMENTATION",{"$f":"'Dx_Implement. and Support'!D144","v":0}]
[null,null,"SOLUTION SUPPORT",{"$f":"'Dx_Implement. and Support'!D146","v":0}]
[null,null,"SUB TOTAL",{"$f":"SUM(D18,D19)","v":0}]
[]
[null,null,"GRAND TOTAL",{"$nulls":6},{"$f":"SUM(D16,D20)","v":0}]
[null,"NTCSA","PRODUCTION ENVIRONMENT","Subscription service",{"$f":"NTCSA_License!E28","v":0},{"$f":"NTCSA_License!F28","v":0},{"$f":"NTCSA_License!G28","v":0},{"$f":"NTCSA_License!H28","v":0},{"$f":"NTCSA_License!I28","v":0}]
[null,null,"PRE-PRODUCTION ENVIRONMENT","Subscription service",{"$f":"NTCSA_License!E29","v":0},{"$f":"NTCSA_License!F29","v":0},{"$f":"NTCSA_License!G29","v":0},{"$f":"NTCSA_License!H29","v":0},{"$f":"NTCSA_License!I29","v":0}]
[null,null,"DISASTER RECOVERY ENVIRONMENT","Subscription service",{"$f":"NTCSA_License!E30","v":0},{"$f":"NTCSA_License!F30","v":0},{"$f":"NTCSA_License!G30","v":0},{"$f":"NTCSA_License!H30","v":0},{"$f":"NTCSA_License!I30","v":0}]
[null,null,"QUALITY ASSURANCE ENVIRONMENT","Subscription service",{"$f":"NTCSA_License!E31","v":0},{"$f":"NTCSA_License!F31","v":0},{"$f":"NTCSA_License!G31","v":0},{"$f":"NTCSA_License!H31","v":0},{"$f":"NTCSA_License!I31","v":0}]
[null,null,"DEVELOPMENT ENVIRONMENT","Subscription service",{"$f":"NTCSA_License!E32","v":0},{"$f":"NTCSA_License!F32","v":0},{"$f":"NTCSA_License!G32","v":0},{"$f":"NTCSA_License!H32","v":0},{"$f":"NTCSA_License!I32","v":0}]
[null,null,"TRAINING ENVIRONMENT","Subscription service",{"$f":"NTCSA_License!E33","v":0},{"$f":"NTCSA_License!F33","v":0},{"$f":"NTCSA_License!G33","v":0},{"$f":"NTCSA_License!H33","v":0},{"$f":"NTCSA_License!I33","v":0}]
[null,null,"TOTAL",null,{"$f":"SUM(E23:E28)","v":0},{"$f":"SUM(F23:F28)","v":0},{"$f":"SUM(G23:G28)","v":0},{"$f":"SUM(H23:H28)","v":0},{"$f":"SUM(I23:I28)","v":0}]
[null,null,"SUB TOTAL",{"$f":"SUM(E29,F29,G29,H29,I29)","v":0}]
[]
[null,null,"SOLUTION IMPLEMENTATION",{"$f":"'NTCSA_Implement. and Support'!D144","v":0}]
[null,null,"SOLUTION SUPPORT",{"$f":"'NTCSA_Implement. and Support'!D146","v":0}]
[null,null,"SUB TOTAL",{"$f":"SUM(D32,D33)","v":0}]
[]
[null,null,"GRAND TOTAL",{"$nulls":6},{"$f":"SUM(D30,D34)","v":0}]
[]
[null,"ENTERPRISE HISTORIAN SOLUTION - TOTAL",{"$nulls":7},{"$f":"SUM(J22,J36)","v":0}]

{"sheet":"Dx_License","index":1,"n_rows":174,"n_cols":30,"rows_kept":174,"merged":[[1,1,1,7],[25,1,25,8],[27,1,32,1],[36,1,36,11],[37,8,37,11],[37,12,37,15],[37,16,37,19],[37,20,37,23],[37,24,37,27],[38,5,38,7],[39,0,40,0],[41,0,42,0],[59,1,59,11],[60,8,60,11],[60,12,60,15],[60,16,60,19],[60,20,60,23],[60,24,60,27],[61,5,61,7],[82,1,82,11],[83,8,83,11],[83,12,83,15],[83,16,83,19],[83,20,83,23],[83,24,83,27],[84,5,84,7],[105,1,105,11],[106,8,106,11],[106,12,106,15],[106,16,106,19],[106,20,106,23],[106,24,106,27],[107,5,107,7],[115,0,116,0],[117,0,118,0],[119,0,121,0],[122,0,131,0],[128,1,128,11],[129,8,129,11],[129,12,129,15],[129,16,129,19],[129,20,129,23],[129,24,129,27],[130,5,130,7],[132,0,135,0],[136,0,137,0],[138,0,143,0],[144,0,145,0],[151,1,151,11],[152,8,152,11],[152,12,152,15],[152,16,152,19],[152,20,152,23],[152,24,152,27],[153,5,153,7],[155,0,158,0],[159,0,160,0],[161,0,166,0],[167,0,168,0]]}
[]
[null,{"$f":"EH_Summary!B4","v":"VENDOR NAME"}]
[]
[]
[]
[null,"IMPORTANT NOTES"]
[null,"All cells highlighted in GREEN must be completed"]
[null,"Quoted prices MUST be in ZAR, EXCLUDING VAT and ESCALATIONS"]
[]
[null,"Dx Historian"]
[null,"Prices MUST be quoted based on the SCOPE provided"]
[null,"Select the currency from the CURRENCY drop-down list in COLUMN \"G\""]
[]
[null,"Capture the applicable Currency, ROE and ROE Published Date on the \"Currency sheet\". "]
[null,"The adjustments for prevailing rates and the basis for future price adjustments will be determined at time of contracting. "]
[null,"Exchange rate variations may not be claimed for the local mark-up in the pricing structure"]
[]
[null,"NB: PROVIDE THE REQUIRED SUBSCRIPTION LICENSES for the different Environments as per the TABLES below"]
[]
[null,"Provide Contract Price Adjustment Formula in COLUMN AD"]
[]
[null,"All Prices must be exclusive of VAT"]
[]
[]
[]
[null,"SUMMARY BASED ON 2 MILLION TAGS"]
[null,null,"ENVIRONMENT","DESCRIPTION","YEAR 1","YEAR 2","YEAR 3","YEAR 4","YEAR 5","TOTAL"]
[null,"ENTERPRISE HISTORIAN","PRODUCTION ENVIRONMENT","Subscription service",{"$f":"L55","v":0},{"$f":"P55","v":0},{"$f":"T55","v":0},{"$f":"X55","v":0},{"$f":"AB55","v":0},{"$f":"SUM(E28:I28)","v":0}]
[null,null,"PRE-PRODUCTION ENVIRONMENT","Subscription service",{"$f":"L78","v":0},{"$f":"P78","v":0},{"$f":"T78","v":0},{"$f":"X78","v":0},{"$f":"AB78","v":0},{"$f":"SUM(E29:I29)","v":0}]
[null,null,"DISASTER RECOVERY ENVIRONMENT","Subscription service",{"$f":"L101","v":0},{"$f":"P101","v":0},{"$f":"T101","v":0},{"$f":"X101","v":0},{"$f":"AB101","v":0},0]
[null,null,"QUALITY ASSURANCE ENVIRONMENT","Subscription service",{"$f":"L124","v":0},{"$f":"P124","v":0},{"$f":"T124","v":0},{"$f":"X124","v":0},{"$f":"AB124","v":0},0]
[null,null,"DEVELOPMENT ENVIRONMENT","Subscription service",{"$f":"L147","v":0},{"$f":"P147","v":0},{"$f":"T147","v":0},{"$f":"X147","v":0},{"$f":"AB147","v":0},0]
[null,null,"TRAINING ENVIRONMENT","Subscription service",{"$f":"L170","v":0},{"$f":"P170","v":0},{"$f":"T170","v":0},{"$f":"X170","v":0},{"$f":"AB170","v":0},0]
[{"$nulls":3},"TOTAL",{"$f":"SUM(E28:E33)","v":0},{"$f":"SUM(F28:F33)","v":0},0,0,0,{"$f":"SUM(J28,K28,L28,M28,N28)","v":0}]
[]
[]
[null,{"$f":"C28","v":"PRODUCTION ENVIRONMENT"}]
[{"$nulls":8},"Year 1",{"$nulls":3},"Year 2",{"$nulls":3},"Year 3",{"$nulls":3},"Year 4",{"$nulls":3},"Year 5"]
[null,"PART NUMBER",null,"DESCRIPTION","TOTAL ESTIMATED QUANTITIES","CURRENCY",null,null,"Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR",null,"CONTRACT PRICE ADJUSTMENT"]
[{"$nulls":5},{"$f":"IF(G40=\"\",\"\",IF(G40=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(F40=\"\",\"\",IF(F40=\"Foreign\",VLOOKUP(G40,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,{"$f":"I40*$H40","v":0},{"$f":"I40*$E40","v":0},{"$f":"J40*$E40","v":0},0,{"$f":"M40*$H40","v":0},{"$f":"M40*$E40","v":0},{"$f":"N40*$E40","v":0},0,{"$f":"Q40*$H40","v":0},{"$f":"Q40*$E40","v":0},{"$f":"R40*$E40","v":0},0,{"$f":"U40*$H40","v":0},{"$f":"U40*$E40","v":0},{"$f":"V40*$E40","v":0},0,{"$f":"Y40*$H40","v":0},{"$f":"Y40*$E40","v":0},{"$f":"Z40*$E40","v":0}]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F41=\"\",\"\",IF(F41=\"Foreign\",VLOOKUP(G41,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,{"$f":"I41*$H41","v":0},{"$f":"I41*$E41","v":0},{"$f":"J41*$E41","v":0},0,{"$f":"M41*$H41","v":0},0,0,0,{"$f":"Q41*$H41","v":0},0,0,0,{"$f":"U41*$H41","v":0},0,0,0,{"$f":"Y41*$H41","v":0},0,0]
[{"$nulls":5},{"$f":"IF(G42=\"\",\"\",IF(G42=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(F42=\"\",\"\",IF(F42=\"Foreign\",VLOOKUP(G42,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F43=\"\",\"\",IF(F43=\"Foreign\",VLOOKUP(G43,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F44=\"\",\"\",IF(F44=\"Foreign\",VLOOKUP(G44,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F45=\"\",\"\",IF(F45=\"Foreign\",VLOOKUP(G45,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F46=\"\",\"\",IF(F46=\"Foreign\",VLOOKUP(G46,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F47=\"\",\"\",IF(F47=\"Foreign\",VLOOKUP(G47,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F48=\"\",\"\",IF(F48=\"Foreign\",VLOOKUP(G48,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F49=\"\",\"\",IF(F49=\"Foreign\",VLOOKUP(G49,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F50=\"\",\"\",IF(F50=\"Foreign\",VLOOKUP(G50,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F51=\"\",\"\",IF(F51=\"Foreign\",VLOOKUP(G51,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},{"$f":"IF(G52=\"\",\"\",IF(G52=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(F52=\"\",\"\",IF(F52=\"Foreign\",VLOOKUP(G52,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,{"$f":"I52*$H52","v":0},{"$f":"I52*$E52","v":0},{"$f":"J52*$E52","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F53=\"\",\"\",IF(F53=\"Foreign\",VLOOKUP(G53,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F54=\"\",\"\",IF(F54=\"Foreign\",VLOOKUP(G54,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},{"$f":"SUM(L40:L54)","v":0},{"$nulls":3},{"$f":"SUM(P40:P54)","v":0},{"$nulls":3},{"$f":"SUM(T40:T54)","v":0},{"$nulls":3},{"$f":"SUM(X40:X54)","v":0},{"$nulls":3},{"$f":"SUM(AB40:AB54)","v":0}]
[]
[{"$nulls":11},{"$f":"SUM(L55,P55,P55,T55,X55,AB55)","v":0}]
[]
[]
[null,{"$f":"C29","v":"PRE-PRODUCTION ENVIRONMENT"}]
[{"$nulls":8},"Year 1",{"$nulls":3},"Year 2",{"$nulls":3},"Year 3",{"$nulls":3},"Year 4",{"$nulls":3},"Year 5"]
[null,"PART NUMBER",null,"DESCRIPTION","TOTAL ESTIMATED QUANTITIES","CURRENCY",null,null,"Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR",null,"CONTRACT PRICE ADJUSTMENT"]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F63=\"\",\"\",IF(F63=\"Foreign\",VLOOKUP(G63,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,{"$f":"M63*$H63","v":0},{"$f":"M63*$E63","v":0},{"$f":"N63*$E63","v":0},0,{"$f":"Q63*$H63","v":0},{"$f":"Q63*$E63","v":0},{"$f":"R63*$E63","v":0},0,{"$f":"U63*$H63","v":0},{"$f":"U63*$E63","v":0},{"$f":"V63*$E63","v":0},0,{"$f":"Y63*$H63","v":0},{"$f":"Y63*$E63","v":0},{"$f":"Z63*$E63","v":0}]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F64=\"\",\"\",IF(F64=\"Foreign\",VLOOKUP(G64,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F65=\"\",\"\",IF(F65=\"Foreign\",VLOOKUP(G65,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F66=\"\",\"\",IF(F66=\"Foreign\",VLOOKUP(G66,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F67=\"\",\"\",IF(F67=\"Foreign\",VLOOKUP(G67,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F68=\"\",\"\",IF(F68=\"Foreign\",VLOOKUP(G68,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F69=\"\",\"\",IF(F69=\"Foreign\",VLOOKUP(G69,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F70=\"\",\"\",IF(F70=\"Foreign\",VLOOKUP(G70,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F71=\"\",\"\",IF(F71=\"Foreign\",VLOOKUP(G71,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F72=\"\",\"\",IF(F72=\"Foreign\",VLOOKUP(G72,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F73=\"\",\"\",IF(F73=\"Foreign\",VLOOKUP(G73,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F74=\"\",\"\",IF(F74=\"Foreign\",VLOOKUP(G74,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},{"$f":"IF(G75=\"\",\"\",IF(G75=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(F75=\"\",\"\",IF(F75=\"Foreign\",VLOOKUP(G75,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,{"$f":"I75*$H75","v":0},{"$f":"I75*$E75","v":0},{"$f":"J75*$E75","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F76=\"\",\"\",IF(F76=\"Foreign\",VLOOKUP(G76,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F77=\"\",\"\",IF(F77=\"Foreign\",VLOOKUP(G77,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},{"$f":"SUM(L63:L77)","v":0},{"$nulls":3},{"$f":"SUM(P63:P77)","v":0},{"$nulls":3},{"$f":"SUM(T63:T77)","v":0},{"$nulls":3},{"$f":"SUM(X63:X77)","v":0},{"$nulls":3},{"$f":"SUM(AB63:AB77)","v":0}]
[]
[{"$nulls":11},{"$f":"SUM(L78,P78,P78,T78,X78,AB78)","v":0}]
[]
[]
[null,{"$f":"C30","v":"DISASTER RECOVERY ENVIRONMENT"}]
[{"$nulls":8},"Year 1",{"$nulls":3},"Year 2",{"$nulls":3},"Year 3",{"$nulls":3},"Year 4",{"$nulls":3},"Year 5"]
[null,"PART NUMBER",null,"DESCRIPTION","TOTAL ESTIMATED QUANTITIES","CURRENCY",null,null,"Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR",null,"CONTRACT PRICE ADJUSTMENT"]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F86=\"\",\"\",IF(F86=\"Foreign\",VLOOKUP(G86,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,{"$f":"M86*$H86","v":0},{"$f":"M86*$E86","v":0},{"$f":"N86*$E86","v":0},0,{"$f":"Q86*$H86","v":0},{"$f":"Q86*$E86","v":0},{"$f":"R86*$E86","v":0},0,{"$f":"U86*$H86","v":0},{"$f":"U86*$E86","v":0},{"$f":"V86*$E86","v":0},0,{"$f":"Y86*$H86","v":0},{"$f":"Y86*$E86","v":0},{"$f":"Z86*$E86","v":0}]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F87=\"\",\"\",IF(F87=\"Foreign\",VLOOKUP(G87,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F88=\"\",\"\",IF(F88=\"Foreign\",VLOOKUP(G88,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F89=\"\",\"\",IF(F89=\"Foreign\",VLOOKUP(G89,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F90=\"\",\"\",IF(F90=\"Foreign\",VLOOKUP(G90,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F91=\"\",\"\",IF(F91=\"Foreign\",VLOOKUP(G91,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F92=\"\",\"\",IF(F92=\"Foreign\",VLOOKUP(G92,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F93=\"\",\"\",IF(F93=\"Foreign\",VLOOKUP(G93,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F94=\"\",\"\",IF(F94=\"Foreign\",VLOOKUP(G94,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F95=\"\",\"\",IF(F95=\"Foreign\",VLOOKUP(G95,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F96=\"\",\"\",IF(F96=\"Foreign\",VLOOKUP(G96,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F97=\"\",\"\",IF(F97=\"Foreign\",VLOOKUP(G97,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},{"$f":"IF(G98=\"\",\"\",IF(G98=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(F98=\"\",\"\",IF(F98=\"Foreign\",VLOOKUP(G98,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,{"$f":"I98*$H98","v":0},{"$f":"I98*$E98","v":0},{"$f":"J98*$E98","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F99=\"\",\"\",IF(F99=\"Foreign\",VLOOKUP(G99,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F100=\"\",\"\",IF(F100=\"Foreign\",VLOOKUP(G100,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},{"$f":"SUM(L86:L100)","v":0},{"$nulls":3},{"$f":"SUM(P86:P100)","v":0},{"$nulls":3},{"$f":"SUM(T86:T100)","v":0},{"$nulls":3},{"$f":"SUM(X86:X100)","v":0},{"$nulls":3},{"$f":"SUM(AB86:AB100)","v":0}]
[]
[{"$nulls":11},{"$f":"SUM(L101,P101,P101,T101,X101,AB101)","v":0}]
[]
[]
[null,{"$f":"C31","v":"QUALITY ASSURANCE ENVIRONMENT"}]
[{"$nulls":8},"Year 1",{"$nulls":3},"Year 2",{"$nulls":3},"Year 3",{"$nulls":3},"Year 4",{"$nulls":3},"Year 5"]
[null,"PART NUMBER",null,"DESCRIPTION","TOTAL ESTIMATED QUANTITIES","CURRENCY",null,null,"Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR",null,"CONTRACT PRICE ADJUSTMENT"]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F109=\"\",\"\",IF(F109=\"Foreign\",VLOOKUP(G109,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,{"$f":"M109*$H109","v":0},{"$f":"M109*$E109","v":0},{"$f":"N109*$E109","v":0},0,{"$f":"Q109*$H109","v":0},{"$f":"Q109*$E109","v":0},{"$f":"R109*$E109","v":0},0,{"$f":"U109*$H109","v":0},{"$f":"U109*$E109","v":0},{"$f":"V109*$E109","v":0},0,{"$f":"Y109*$H109","v":0},{"$f":"Y109*$E109","v":0},{"$f":"Z109*$E109","v":0}]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F110=\"\",\"\",IF(F110=\"Foreign\",VLOOKUP(G110,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F111=\"\",\"\",IF(F111=\"Foreign\",VLOOKUP(G111,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F112=\"\",\"\",IF(F112=\"Foreign\",VLOOKUP(G112,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F113=\"\",\"\",IF(F113=\"Foreign\",VLOOKUP(G113,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F114=\"\",\"\",IF(F114=\"Foreign\",VLOOKUP(G114,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F115=\"\",\"\",IF(F115=\"Foreign\",VLOOKUP(G115,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},{"$f":"IF(G116=\"\",\"\",IF(G116=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(F116=\"\",\"\",IF(F116=\"Foreign\",VLOOKUP(G116,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F117=\"\",\"\",IF(F117=\"Foreign\",VLOOKUP(G117,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},{"$f":"IF(G118=\"\",\"\",IF(G118=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(F118=\"\",\"\",IF(F118=\"Foreign\",VLOOKUP(G118,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F119=\"\",\"\",IF(F119=\"Foreign\",VLOOKUP(G119,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},{"$f":"IF(G120=\"\",\"\",IF(G120=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(F120=\"\",\"\",IF(F120=\"Foreign\",VLOOKUP(G120,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},{"$f":"IF(G121=\"\",\"\",IF(G121=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(F121=\"\",\"\",IF(F121=\"Foreign\",VLOOKUP(G121,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,{"$f":"I121*$H121","v":0},{"$f":"I121*$E121","v":0},{"$f":"J121*$E121","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F122=\"\",\"\",IF(F122=\"Foreign\",VLOOKUP(G122,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F123=\"\",\"\",IF(F123=\"Foreign\",VLOOKUP(G123,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},{"$f":"SUM(L109:L123)","v":0},{"$nulls":3},{"$f":"SUM(P109:P123)","v":0},{"$nulls":3},{"$f":"SUM(T109:T123)","v":0},{"$nulls":3},{"$f":"SUM(X109:X123)","v":0},{"$nulls":3},{"$f":"SUM(AB109:AB123)","v":0}]
[]
[{"$nulls":11},{"$f":"SUM(L124,P124,P124,T124,X124,AB124)","v":0}]
[]
[]
[null,{"$f":"C32","v":"DEVELOPMENT ENVIRONMENT"}]
[{"$nulls":8},"Year 1",{"$nulls":3},"Year 2",{"$nulls":3},"Year 3",{"$nulls":3},"Year 4",{"$nulls":3},"Year 5"]
[null,"PART NUMBER",null,"DESCRIPTION","TOTAL ESTIMATED QUANTITIES","CURRENCY",null,null,"Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR",null,"CONTRACT PRICE ADJUSTMENT"]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F132=\"\",\"\",IF(F132=\"Foreign\",VLOOKUP(G132,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,{"$f":"M132*$H132","v":0},{"$f":"M132*$E132","v":0},{"$f":"N132*$E132","v":0},0,{"$f":"Q132*$H132","v":0},{"$f":"Q132*$E132","v":0},{"$f":"R132*$E132","v":0},0,{"$f":"U132*$H132","v":0},{"$f":"U132*$E132","v":0},{"$f":"V132*$E132","v":0},0,{"$f":"Y132*$H132","v":0},{"$f":"Y132*$E132","v":0},{"$f":"Z132*$E132","v":0}]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F133=\"\",\"\",IF(F133=\"Foreign\",VLOOKUP(G133,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F134=\"\",\"\",IF(F134=\"Foreign\",VLOOKUP(G134,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F135=\"\",\"\",IF(F135=\"Foreign\",VLOOKUP(G135,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F136=\"\",\"\",IF(F136=\"Foreign\",VLOOKUP(G136,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F137=\"\",\"\",IF(F137=\"Foreign\",VLOOKUP(G137,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F138=\"\",\"\",IF(F138=\"Foreign\",VLOOKUP(G138,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,{"$f":"I138*$H138","v":0},{"$f":"I138*$E138","v":0},{"$f":"J138*$E138","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F139=\"\",\"\",IF(F139=\"Foreign\",VLOOKUP(G139,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F140=\"\",\"\",IF(F140=\"Foreign\",VLOOKUP(G140,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,{"$f":"I140*$H140","v":0},{"$f":"I140*$E140","v":0},{"$f":"J140*$E140","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F141=\"\",\"\",IF(F141=\"Foreign\",VLOOKUP(G141,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F142=\"\",\"\",IF(F142=\"Foreign\",VLOOKUP(G142,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F143=\"\",\"\",IF(F143=\"Foreign\",VLOOKUP(G143,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F144=\"\",\"\",IF(F144=\"Foreign\",VLOOKUP(G144,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F145=\"\",\"\",IF(F145=\"Foreign\",VLOOKUP(G145,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F146=\"\",\"\",IF(F146=\"Foreign\",VLOOKUP(G146,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total ",{"$nulls":9},{"$f":"SUM(L132:L146)","v":0},{"$nulls":3},{"$f":"SUM(P132:P146)","v":0},{"$nulls":3},{"$f":"SUM(T132:T146)","v":0},{"$nulls":3},{"$f":"SUM(X132:X146)","v":0},{"$nulls":3},{"$f":"SUM(AB132:AB146)","v":0}]
[]
[{"$nulls":11},{"$f":"SUM(L147,P147,P147,T147,X147,AB147)","v":0}]
[]
[]
[null,{"$f":"C33","v":"TRAINING ENVIRONMENT"}]
[{"$nulls":8},"Year 1",{"$nulls":3},"Year 2",{"$nulls":3},"Year 3",{"$nulls":3},"Year 4",{"$nulls":3},"Year 5"]
[null,"PART NUMBER",null,"DESCRIPTION","TOTAL ESTIMATED QUANTITIES","CURRENCY",null,null,"Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR",null,"CONTRACT PRICE ADJUSTMENT"]
[{"$nulls":5},{"$f":"IF(G155=\"\",\"\",IF(G155=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(F155=\"\",\"\",IF(F155=\"Foreign\",VLOOKUP(G155,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,{"$f":"I155*$H155","v":0},{"$f":"I155*$E155","v":0},{"$f":"J155*$E155","v":0},0,{"$f":"M155*$H155","v":0},{"$f":"M155*$E155","v":0},{"$f":"N155*$E155","v":0},0,{"$f":"Q155*$H155","v":0},{"$f":"Q155*$E155","v":0},{"$f":"R155*$E155","v":0},0,{"$f":"U155*$H155","v":0},{"$f":"U155*$E155","v":0},{"$f":"V155*$E155","v":0},0,{"$f":"Y155*$H155","v":0},{"$f":"Y155*$E155","v":0},{"$f":"Z155*$E155","v":0}]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F156=\"\",\"\",IF(F156=\"Foreign\",VLOOKUP(G156,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F157=\"\",\"\",IF(F157=\"Foreign\",VLOOKUP(G157,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F158=\"\",\"\",IF(F158=\"Foreign\",VLOOKUP(G158,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F159=\"\",\"\",IF(F159=\"Foreign\",VLOOKUP(G159,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F160=\"\",\"\",IF(F160=\"Foreign\",VLOOKUP(G160,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F161=\"\",\"\",IF(F161=\"Foreign\",VLOOKUP(G161,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F162=\"\",\"\",IF(F162=\"Foreign\",VLOOKUP(G162,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F163=\"\",\"\",IF(F163=\"Foreign\",VLOOKUP(G163,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F164=\"\",\"\",IF(F164=\"Foreign\",VLOOKUP(G164,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F165=\"\",\"\",IF(F165=\"Foreign\",VLOOKUP(G165,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F166=\"\",\"\",IF(F166=\"Foreign\",VLOOKUP(G166,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F167=\"\",\"\",IF(F167=\"Foreign\",VLOOKUP(G167,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F168=\"\",\"\",IF(F168=\"Foreign\",VLOOKUP(G168,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F169=\"\",\"\",IF(F169=\"Foreign\",VLOOKUP(G169,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total ",{"$nulls":9},{"$f":"SUM(L155:L169)","v":0},{"$nulls":3},{"$f":"SUM(P155:P169)","v":0},{"$nulls":3},{"$f":"SUM(T155:T169)","v":0},{"$nulls":3},{"$f":"SUM(X155:X169)","v":0},{"$nulls":3},{"$f":"SUM(AB155:AB169)","v":0}]
[]
[null,"GRAND TOTAL",{"$nulls":9},{"$f":"SUM(L170,P170,P170,T170,X170,AB170)","v":0}]
[]
[null,"Overall Total",{"$nulls":9},{"$f":"SUM(L172,L149,L126,L103,L80,L57)","v":0}]

{"sheet":"Dx_Implement. and Support","index":2,"n_rows":148,"n_cols":35,"rows_kept":148,"merged":[[1,2,1,7],[26,6,26,8],[26,9,26,12],[27,6,27,8],[28,1,38,1],[28,2,38,2],[41,1,44,1],[41,2,44,2],[48,2,48,6],[50,2,55,2],[56,2,61,2],[62,2,67,2],[68,2,73,2],[74,2,79,2],[80,2,85,2],[86,2,97,2],[98,2,104,2],[105,2,110,2],[111,2,116,2],[117,2,122,2],[125,9,125,32],[126,5,126,7],[126,9,126,12],[126,14,126,17],[126,19,126,22],[126,24,126,27],[126,29,126,32],[127,5,127,7],[129,1,136,1],[129,2,136,2]]}
[]
[null,null,{"$f":"EH_Summary!B4","v":"VENDOR NAME"}]
[]
[]
[]
[null,null,"IMPORTANT NOTES"]
[null,null,"All cells highlighted in GREEN must be completed"]
[null,null,"Quoted prices MUST be in ZAR, EXCLUDING VAT and ESCALATIONS"]
[]
[null,null,"Dx Historian"]
[null,null,"Prices MUST be quoted based on the SCOPE provided"]
[null,null,"Estimated quantities are based on the required number of Licenses"]
[null,null,"Select the currency from the CURRENCY drop-down list in COLUMN \"H\""]
[]
[null,null,"Capture the applicable Currency, ROE and ROE Published Date on the \"Currency sheet\". "]
[null,null,"The adjustments for prevailing rates and the basis for future price adjustments will be determined at time of contracting. "]
[null,null,"Exchange rate variations may not be claimed for the local mark-up in the pricing structure"]
[]
[null,null,"NB: Provide details on the CONTRACT PRICE ADJUSTMENT in Column O for Solution Implementation and Column AI for the Maintenance phase. "]
[null,null,"Provide Cash-Flow projections for the Solution Implementation phase"]
[null,null,"Provide the Detailed Resource plan for the Implementation phase in TABLE 1: RESOURCES FOR IMPLEMENTATION"]
[]
[null,null,"All Prices must be exclusive of VAT"]
[]
[]
[]
[null,null," ",{"$nulls":6},"SOLUTION IMPLEMENTATION"]
[null,"Item Number","Category","Description","Total Estimated Quantity","Unit charge","CURRENCY",null,null,"Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR",null,"CONTRACT PRICE ADJUSTMENT"]
[null,1,"Solution Implementation \n(Applicable Stages)","Infrastructure Provisioning",1,"sum",{"$f":"IF(H29=\"\",\"\",IF(H29=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(G29=\"\",\"\",IF(G29=\"Foreign\",VLOOKUP(H29,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,{"$f":"J29*$I29","v":0},{"$f":"J29*$E29","v":0},{"$f":"H56*I29","v":0}]
[{"$nulls":3},"Infrastructure Configuration",1,"sum",{"$f":"IF(H30=\"\",\"\",IF(H30=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(G30=\"\",\"\",IF(G30=\"Foreign\",VLOOKUP(H30,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},{"$f":"H62*I30","v":0}]
[{"$nulls":3},"Installation of Enterprise Historian components",1,"sum","Local","ZAR",{"$f":"IF(G31=\"\",\"\",IF(G31=\"Foreign\",VLOOKUP(H31,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,{"$f":"H68*I31","v":0}]
[{"$nulls":3},"Provisioning of redundant data collectors",7,"sum","Local","ZAR",{"$f":"IF(G32=\"\",\"\",IF(G32=\"Foreign\",VLOOKUP(H32,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,{"$f":"H74*I32","v":0}]
[{"$nulls":3},"Installation of redundant data collectors",7,"sum",{"$f":"IF(H33=\"\",\"\",IF(H33=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(G33=\"\",\"\",IF(G33=\"Foreign\",VLOOKUP(H33,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},{"$f":"H80*I33","v":0}]
[{"$nulls":3},"Migration of eDNA datasets",1,"sum","Local","ZAR",{"$f":"IF(G34=\"\",\"\",IF(G34=\"Foreign\",VLOOKUP(H34,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,{"$f":"H86*I34","v":0}]
[{"$nulls":3},"Enterprise Historian Interfaces (Integration)",1,"sum","Local","ZAR",{"$f":"IF(G35=\"\",\"\",IF(G35=\"Foreign\",VLOOKUP(H35,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,{"$f":"H98*I35","v":0}]
[{"$nulls":3},"Implementation of Pilots",1,"sum","Local","ZAR",{"$f":"IF(G36=\"\",\"\",IF(G36=\"Foreign\",VLOOKUP(H36,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},{"$f":"H105*I36","v":0}]
[{"$nulls":3},"Testing and Bug fixes",1,"sum","Local","ZAR",{"$f":"IF(G37=\"\",\"\",IF(G37=\"Foreign\",VLOOKUP(H37,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,{"$f":"H111*I37","v":0}]
[{"$nulls":3},"Deployment",1,"sum","Local","ZAR",{"$f":"IF(G38=\"\",\"\",IF(G38=\"Foreign\",VLOOKUP(H38,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,{"$f":"H117*I38","v":0}]
[{"$nulls":3},"Stabilisation & Go-Live Support",1,"sum","Local","ZAR",{"$f":"IF(G39=\"\",\"\",IF(G39=\"Foreign\",VLOOKUP(H39,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,{"$f":"H123*I39","v":0}]
[null,2,"Project Management","Project Management",1,"sum","Local","ZAR",{"$f":"IF(G40=\"\",\"\",IF(G40=\"Foreign\",VLOOKUP(H40,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0]
[null,3,"Changes Management","Change Management",1,"sum",{"$f":"IF(H41=\"\",\"\",IF(H41=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(G41=\"\",\"\",IF(G41=\"Foreign\",VLOOKUP(H41,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,{"$f":"J41*$I41","v":0},{"$f":"J41*$E41","v":0},{"$f":"K41*$E41","v":0}]
[null,4,"Training","System user",1,"sum","Local","ZAR",{"$f":"IF(G42=\"\",\"\",IF(G42=\"Foreign\",VLOOKUP(H42,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0]
[{"$nulls":3},"System Administrator",1,"sum","Local","ZAR",{"$f":"IF(G43=\"\",\"\",IF(G43=\"Foreign\",VLOOKUP(H43,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0]
[{"$nulls":3},"Train the Trainer (Including User Manuals)",1,"sum","Local","ZAR",{"$f":"IF(G44=\"\",\"\",IF(G44=\"Foreign\",VLOOKUP(H44,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0]
[{"$nulls":3},"Skills Transfer",1,"sum","Local","ZAR",{"$f":"IF(G45=\"\",\"\",IF(G45=\"Foreign\",VLOOKUP(H45,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,{"$f":"K45*$E45","v":0}]
[null,null,"Total ",{"$nulls":9},{"$f":"SUM(M29:M45)","v":0}]
[]
[]
[null,null,"TABLE 1: RESOURCES FOR IMPLEMENTATION"]
[null,null,"Stage","Skill / Service","No. of Hours / Quantity","Hourly Rate / Unit Rate","Total"]
[null,null,"Infrastructure Provisioning","Solution Architect",0,0,{"$f":"F51*E51","v":0}]
[{"$nulls":3},"Technical Architect",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0,{"$f":"SUM(G51:G56)","v":0}]
[null,null,"Infrastructure Configuration","Solution Architect",0,0,{"$f":"F57*E57","v":0}]
[{"$nulls":3},"Technical Architect",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0,{"$f":"SUM(G57:G62)","v":0}]
[null,null,"Installation of Enterprise Historian components","Implementation Specialists",0,0,0]
[{"$nulls":3},"Technical Application Specialist",0,0,0]
[{"$nulls":3},"Data Engineers",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0,{"$f":"SUM(G63:G68)","v":0}]
[null,null,"Provisioning of redundant data collectors","Application Engineer",0,0,0]
[{"$nulls":3},"Implementation Specialists"]
[{"$nulls":3},"Technical Application Specialist",0,0,{"$f":"F71*E71","v":0}]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0,{"$f":"SUM(G69:G74)","v":0}]
[null,null,"Installation of redundant data collectors","Application Engineer",0,0,{"$f":"F75*E75","v":0}]
[{"$nulls":3},"Implementation Specialists"]
[{"$nulls":3},"Technical Application Specialist",0,0,{"$f":"F77*E77","v":0}]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0,{"$f":"SUM(G75:G80)","v":0}]
[null,null,"Migration of eDNA datasets","eDNA System and Process Engineer",0,0,0]
[{"$nulls":3},"Technical Application Specialist",0,0,0]
[{"$nulls":3},"Data Engineers",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0,{"$f":"SUM(G81:G86)","v":0}]
[null,null,"Enterprise Historian Interfaces (Integration)","Integration Architect",0,0,0]
[{"$nulls":3},"Integration Developer",0,0,0]
[{"$nulls":3},"Technical Architect",0,0,0]
[{"$nulls":3},"Data Engineers",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,{"$f":"F92*E92","v":0}]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0,{"$f":"SUM(G87:G98)","v":0}]
[null,null,"Implementation of Pilots","Technical Architect",0,0,{"$f":"F99*E99","v":0}]
[{"$nulls":3},"Data Engineers",0,0,0]
[{"$nulls":3},"Implementation Specialists",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0,{"$f":"SUM(G99:G105)","v":0}]
[null,null,"Testing and Bug fixes","Senior Tester",0,0,0]
[{"$nulls":3},"Intermediate Tester",0,0,0]
[{"$nulls":3},"Performance Engineer",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0,{"$f":"SUM(G106:G111)","v":0}]
[null,null,"Deployment","Implementation Specialist",0,0,0]
[{"$nulls":3},"Technical Application Specialist",0,0,0]
[{"$nulls":3},"Data Engineers",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0,{"$f":"SUM(G112:G117)","v":0}]
[null,null,"Stabilisation & Go-Live Support","Implementation Specialist",0,0,0]
[{"$nulls":3},"Technical Application Specialist",0,0,0]
[{"$nulls":3},"Data Engineers",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0,{"$f":"SUM(G118:G123)","v":0}]
[]
[]
[{"$nulls":9},"CONTRACT EXECUTION"]
[null,null," ",{"$nulls":6},"YEAR 1",{"$nulls":4},"YEAR 2",{"$nulls":4},"YEAR 3",{"$nulls":4},"YEAR 4",{"$nulls":4},"YEAR 5"]
[null,"Item Number","Category","Description","Unit charge","CURRENCY",null,null,"Total Estimated Quantity","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Total Estimated Quantity","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Total Estimated Quantity","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Total Estimated Quantity","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Total Estimated Quantity","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR",null,"CONTRACT PRICE ADJUSTMENT"]
[null,1,"Support","Technical Support","sum",{"$f":"IF(G129=\"\",\"\",IF(G129=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(F129=\"\",\"\",IF(F129=\"Foreign\",VLOOKUP(G129,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,0,{"$f":"J129*$H129","v":0},{"$f":"J129*$I129","v":0},{"$f":"K129*$I129","v":0},1,0,{"$f":"O129*$H129","v":0},{"$f":"O129*$N129","v":0},{"$f":"P129*$N129","v":0},1,0,{"$f":"T129*$H129","v":0},{"$f":"T129*$S129","v":0},{"$f":"U129*$S129","v":0},1,0,{"$f":"Y129*$H129","v":0},{"$f":"Y129*$X129","v":0},{"$f":"Z129*$X129","v":0},1,0,{"$f":"AD129*$H129","v":0},{"$f":"AD129*$AC129","v":0},{"$f":"AE129*$AC129","v":0}]
[null,2,"Professional Services - System Specific Resources \n(As per SoW)\n","<Specify the resource>","Hourly","Local","ZAR",{"$f":"IF(F130=\"\",\"\",IF(F130=\"Foreign\",VLOOKUP(G130,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,0,{"$f":"J130*$H130","v":0},{"$f":"J130*$I130","v":0},0,1,0,{"$f":"O130*$H130","v":0},{"$f":"O130*$N130","v":0},0,1,0,{"$f":"T130*$H130","v":0},{"$f":"T130*$S130","v":0},0,1,0,{"$f":"Y130*$H130","v":0},{"$f":"Y130*$X130","v":0},{"$f":"Z130*$X130","v":0},1,0,{"$f":"AD130*$H130","v":0},{"$f":"AD130*$AC130","v":0},{"$f":"AE130*$AC130","v":0}]
[{"$nulls":3},"<Specify the resource>","Hourly","Local","ZAR",{"$f":"IF(F131=\"\",\"\",IF(F131=\"Foreign\",VLOOKUP(G131,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,0,{"$f":"J131*$H131","v":0},0,0,1,0,{"$f":"O131*$H131","v":0},0,0,1,0,{"$f":"T131*$H131","v":0},0,0,1,0,{"$f":"Y131*$H131","v":0},0,0,1,0,{"$f":"AD131*$H131","v":0},0,0]
[{"$nulls":3},"<Specify the resource>","Hourly","Local","ZAR",{"$f":"IF(F132=\"\",\"\",IF(F132=\"Foreign\",VLOOKUP(G132,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,0,0,0,0,1,0,0,0,0,1,0,0,0,0,1,0,0,0,0,1,0,0,0,0]
[{"$nulls":3},"<Specify the resource>","Hourly",{"$f":"IF(G133=\"\",\"\",IF(G133=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(F133=\"\",\"\",IF(F133=\"Foreign\",VLOOKUP(G133,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,0,{"$f":"J133*$H133","v":0},{"$f":"J133*$I133","v":0},{"$f":"K133*$I133","v":0},1,0,{"$f":"O133*$H133","v":0},{"$f":"O133*$N133","v":0},{"$f":"P133*$N133","v":0},1,0,{"$f":"T133*$H133","v":0},{"$f":"T133*$S133","v":0},{"$f":"U133*$S133","v":0},1,0,{"$f":"Y133*$H133","v":0},{"$f":"Y133*$X133","v":0},{"$f":"Z133*$X133","v":0},1,0,{"$f":"AD133*$H133","v":0},{"$f":"AD133*$AC133","v":0},{"$f":"AE133*$AC133","v":0}]
[{"$nulls":3},"<Specify the resource>","Hourly","Local","ZAR",{"$f":"IF(F134=\"\",\"\",IF(F134=\"Foreign\",VLOOKUP(G134,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,0,0,0,0,1,0,0,0,0,1,0,0,0,0,1,0,0,0,0,1,0,0,0,0]
[{"$nulls":3},"<Specify the resource>","Hourly",{"$f":"IF(G135=\"\",\"\",IF(G135=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(F135=\"\",\"\",IF(F135=\"Foreign\",VLOOKUP(G135,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,0,{"$f":"J135*$H135","v":0},{"$f":"J135*$I135","v":0},{"$f":"K135*$I135","v":0},1,0,{"$f":"O135*$H135","v":0},{"$f":"O135*$N135","v":0},{"$f":"P135*$N135","v":0},1,0,{"$f":"T135*$H135","v":0},{"$f":"T135*$S135","v":0},{"$f":"U135*$S135","v":0},1,0,{"$f":"Y135*$H135","v":0},{"$f":"Y135*$X135","v":0},{"$f":"Z135*$X135","v":0},1,0,{"$f":"AD135*$H135","v":0},{"$f":"AD135*$AC135","v":0},{"$f":"AE135*$AC135","v":0}]
[{"$nulls":3},"<Specify the resource>","Hourly","Local","ZAR",{"$f":"IF(F136=\"\",\"\",IF(F136=\"Foreign\",VLOOKUP(G136,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,0,0,0,0,1,0,0,0,0,1,0,0,0,0,1,0,0,0,0,1,0,0,0,0]
[{"$nulls":3},"<Specify the resource>","Hourly","Local","ZAR",{"$f":"IF(F137=\"\",\"\",IF(F137=\"Foreign\",VLOOKUP(G137,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,0,0,0,0,1,0,0,0,0,1,0,0,0,0,1,0,0,0,0,1,0,0,0,0]
[null,null,"Total ",{"$nulls":9},{"$f":"SUM(M129:M129,M130:M137)","v":0},{"$nulls":4},{"$f":"SUM(R129:R129,R130:R137)","v":0},{"$nulls":4},{"$f":"SUM(W129:W129,W130:W137)","v":0},{"$nulls":4},{"$f":"SUM(AB129:AB129,AB130:AB137)","v":0},{"$nulls":4},{"$f":"SUM(AG129:AG129,AG130:AG137)","v":0}]
[]
[null,null,"GRAND TOTAL",{"$nulls":9},{"$f":"SUM(M138,R138,W138,AB138,AG138)","v":0}]
[]
[]
[]
[null,null,"SOLUTION IMPLEMENTATION",{"$f":"M46","v":0}]
[]
[null,null,"SOLUTION SUPPORT",{"$f":"M140","v":0}]
[]
[null,null,"GRAND TOTAL",{"$f":"SUM(D144,D146)","v":0}]

{"sheet":"NTCSA_License","index":3,"n_rows":174,"n_cols":30,"rows_kept":174,"merged":[[1,1,1,7],[25,1,25,8],[27,1,32,1],[36,1,36,11],[37,8,37,11],[37,12,37,15],[37,16,37,19],[37,20,37,23],[37,24,37,27],[38,5,38,7],[39,0,40,0],[41,0,42,0],[59,1,59,11],[60,8,60,11],[60,12,60,15],[60,16,60,19],[60,20,60,23],[60,24,60,27],[61,5,61,7],[82,1,82,11],[83,8,83,11],[83,12,83,15],[83,16,83,19],[83,20,83,23],[83,24,83,27],[84,5,84,7],[105,1,105,11],[106,8,106,11],[106,12,106,15],[106,16,106,19],[106,20,106,23],[106,24,106,27],[107,5,107,7],[115,0,116,0],[117,0,118,0],[119,0,121,0],[122,0,131,0],[128,1,128,11],[129,8,129,11],[129,12,129,15],[129,16,129,19],[129,20,129,23],[129,24,129,27],[130,5,130,7],[132,0,135,0],[136,0,137,0],[138,0,143,0],[144,0,145,0],[151,1,151,11],[152,8,152,11],[152,12,152,15],[152,16,152,19],[152,20,152,23],[152,24,152,27],[153,5,153,7],[155,0,158,0],[159,0,160,0],[161,0,166,0],[167,0,168,0]]}
[]
[null,{"$f":"EH_Summary!B4","v":"VENDOR NAME"}]
[]
[]
[]
[null,"IMPORTANT NOTES"]
[null,"All cells highlighted in GREEN must be completed"]
[null,"Quoted prices MUST be in ZAR, EXCLUDING VAT and ESCALATIONS"]
[]
[null,"NTCSA Historian"]
[null,"Prices MUST be quoted based on the SCOPE provided"]
[null,"Select the currency from the CURRENCY drop-down list in COLUMN \"G\""]
[]
[null,"Capture the applicable Currency, ROE and ROE Published Date on the \"Currency sheet\". "]
[null,"The adjustments for prevailing rates and the basis for future price adjustments will be determined at time of contracting. "]
[null,"Exchange rate variations may not be claimed for the local mark-up in the pricing structure"]
[]
[null,"NB: PROVIDE THE REQUIRED SUBSCRIPTION LICENSES for the different Environments as per the TABLES below"]
[]
[null,"Provide Contract Price Adjustment Formula in COLUMN AD"]
[]
[null,"All Prices must be exclusive of VAT"]
[]
[]
[]
[null,"SUMMARY BASED ON 2 MILLION TAGS"]
[null,null,"ENVIRONMENT","DESCRIPTION","YEAR 1","YEAR 2","YEAR 3","YEAR 4","YEAR 5","TOTAL"]
[null,"ENTERPRISE HISTORIAN","PRODUCTION ENVIRONMENT","Subscription service",{"$f":"L55","v":0},{"$f":"P55","v":0},{"$f":"T55","v":0},{"$f":"X55","v":0},{"$f":"AB55","v":0},{"$f":"SUM(E28:I28)","v":0}]
[null,null,"PRE-PRODUCTION ENVIRONMENT","Subscription service",{"$f":"L78","v":0},{"$f":"P78","v":0},{"$f":"T78","v":0},{"$f":"X78","v":0},{"$f":"AB78","v":0},{"$f":"SUM(E29:I29)","v":0}]
[null,null,"DISASTER RECOVERY ENVIRONMENT","Subscription service",{"$f":"L101","v":0},{"$f":"P101","v":0},{"$f":"T101","v":0},{"$f":"X101","v":0},{"$f":"AB101","v":0},0]
[null,null,"QUALITY ASSURANCE ENVIRONMENT","Subscription service",{"$f":"L124","v":0},{"$f":"P124","v":0},{"$f":"T124","v":0},{"$f":"X124","v":0},{"$f":"AB124","v":0},0]
[null,null,"DEVELOPMENT ENVIRONMENT","Subscription service",{"$f":"L147","v":0},{"$f":"P147","v":0},{"$f":"T147","v":0},{"$f":"X147","v":0},{"$f":"AB147","v":0},0]
[null,null,"TRAINING ENVIRONMENT","Subscription service",{"$f":"L170","v":0},{"$f":"P170","v":0},{"$f":"T170","v":0},{"$f":"X170","v":0},{"$f":"AB170","v":0},0]
[{"$nulls":3},"TOTAL",{"$f":"SUM(E28:E33)","v":0},{"$f":"SUM(F28:F33)","v":0},0,0,0,{"$f":"SUM(J28,K28,L28,M28,N28)","v":0}]
[]
[]
[null,{"$f":"C28","v":"PRODUCTION ENVIRONMENT"}]
[{"$nulls":8},"Year 1",{"$nulls":3},"Year 2",{"$nulls":3},"Year 3",{"$nulls":3},"Year 4",{"$nulls":3},"Year 5"]
[null,"PART NUMBER",null,"DESCRIPTION","TOTAL ESTIMATED QUANTITIES","CURRENCY",null,null,"Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR",null,"CONTRACT PRICE ADJUSTMENT"]
[{"$nulls":5},{"$f":"IF(G40=\"\",\"\",IF(G40=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(F40=\"\",\"\",IF(F40=\"Foreign\",VLOOKUP(G40,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,{"$f":"I40*$H40","v":0},{"$f":"I40*$E40","v":0},0,0,{"$f":"M40*$H40","v":0},{"$f":"M40*$E40","v":0},0,0,{"$f":"Q40*$H40","v":0},{"$f":"Q40*$E40","v":0},0,0,{"$f":"U40*$H40","v":0},{"$f":"U40*$E40","v":0},0,0,{"$f":"Y40*$H40","v":0},{"$f":"Y40*$E40","v":0},0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F41=\"\",\"\",IF(F41=\"Foreign\",VLOOKUP(G41,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,{"$f":"I41*$H41","v":0},0,0,0,{"$f":"M41*$H41","v":0},0,0,0,{"$f":"Q41*$H41","v":0},0,0,0,{"$f":"U41*$H41","v":0},0,0,0,{"$f":"Y41*$H41","v":0},0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F42=\"\",\"\",IF(F42=\"Foreign\",VLOOKUP(G42,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F43=\"\",\"\",IF(F43=\"Foreign\",VLOOKUP(G43,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F44=\"\",\"\",IF(F44=\"Foreign\",VLOOKUP(G44,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F45=\"\",\"\",IF(F45=\"Foreign\",VLOOKUP(G45,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F46=\"\",\"\",IF(F46=\"Foreign\",VLOOKUP(G46,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F47=\"\",\"\",IF(F47=\"Foreign\",VLOOKUP(G47,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F48=\"\",\"\",IF(F48=\"Foreign\",VLOOKUP(G48,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F49=\"\",\"\",IF(F49=\"Foreign\",VLOOKUP(G49,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F50=\"\",\"\",IF(F50=\"Foreign\",VLOOKUP(G50,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F51=\"\",\"\",IF(F51=\"Foreign\",VLOOKUP(G51,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F52=\"\",\"\",IF(F52=\"Foreign\",VLOOKUP(G52,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F53=\"\",\"\",IF(F53=\"Foreign\",VLOOKUP(G53,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F54=\"\",\"\",IF(F54=\"Foreign\",VLOOKUP(G54,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},{"$f":"SUM(L40:L54)","v":0},{"$nulls":3},{"$f":"SUM(P40:P54)","v":0},{"$nulls":3},{"$f":"SUM(T40:T54)","v":0},{"$nulls":3},{"$f":"SUM(X40:X54)","v":0},{"$nulls":3},{"$f":"SUM(AB40:AB54)","v":0}]
[]
[{"$nulls":11},{"$f":"SUM(L55,P55,P55,T55,X55,AB55)","v":0}]
[]
[]
[null,{"$f":"C29","v":"PRE-PRODUCTION ENVIRONMENT"}]
[{"$nulls":8},"Year 1",{"$nulls":3},"Year 2",{"$nulls":3},"Year 3",{"$nulls":3},"Year 4",{"$nulls":3},"Year 5"]
[null,"PART NUMBER",null,"DESCRIPTION","TOTAL ESTIMATED QUANTITIES","CURRENCY",null,null,"Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR",null,"CONTRACT PRICE ADJUSTMENT"]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F63=\"\",\"\",IF(F63=\"Foreign\",VLOOKUP(G63,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,{"$f":"I63*$E63","v":0},0,0,{"$f":"M63*$H63","v":0},{"$f":"M63*$E63","v":0},0,0,{"$f":"Q63*$H63","v":0},{"$f":"Q63*$E63","v":0},0,0,{"$f":"U63*$H63","v":0},{"$f":"U63*$E63","v":0},0,0,{"$f":"Y63*$H63","v":0},{"$f":"Y63*$E63","v":0},0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F64=\"\",\"\",IF(F64=\"Foreign\",VLOOKUP(G64,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F65=\"\",\"\",IF(F65=\"Foreign\",VLOOKUP(G65,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F66=\"\",\"\",IF(F66=\"Foreign\",VLOOKUP(G66,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F67=\"\",\"\",IF(F67=\"Foreign\",VLOOKUP(G67,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F68=\"\",\"\",IF(F68=\"Foreign\",VLOOKUP(G68,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F69=\"\",\"\",IF(F69=\"Foreign\",VLOOKUP(G69,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F70=\"\",\"\",IF(F70=\"Foreign\",VLOOKUP(G70,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F71=\"\",\"\",IF(F71=\"Foreign\",VLOOKUP(G71,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F72=\"\",\"\",IF(F72=\"Foreign\",VLOOKUP(G72,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F73=\"\",\"\",IF(F73=\"Foreign\",VLOOKUP(G73,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F74=\"\",\"\",IF(F74=\"Foreign\",VLOOKUP(G74,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F75=\"\",\"\",IF(F75=\"Foreign\",VLOOKUP(G75,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F76=\"\",\"\",IF(F76=\"Foreign\",VLOOKUP(G76,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F77=\"\",\"\",IF(F77=\"Foreign\",VLOOKUP(G77,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},{"$f":"SUM(L63:L77)","v":0},{"$nulls":3},{"$f":"SUM(P63:P77)","v":0},{"$nulls":3},{"$f":"SUM(T63:T77)","v":0},{"$nulls":3},{"$f":"SUM(X63:X77)","v":0},{"$nulls":3},{"$f":"SUM(AB63:AB77)","v":0}]
[]
[{"$nulls":11},{"$f":"SUM(L78,P78,P78,T78,X78,AB78)","v":0}]
[]
[]
[null,{"$f":"C30","v":"DISASTER RECOVERY ENVIRONMENT"}]
[{"$nulls":8},"Year 1",{"$nulls":3},"Year 2",{"$nulls":3},"Year 3",{"$nulls":3},"Year 4",{"$nulls":3},"Year 5"]
[null,"PART NUMBER",null,"DESCRIPTION","TOTAL ESTIMATED QUANTITIES","CURRENCY",null,null,"Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR",null,"CONTRACT PRICE ADJUSTMENT"]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F86=\"\",\"\",IF(F86=\"Foreign\",VLOOKUP(G86,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,{"$f":"M86*$H86","v":0},{"$f":"M86*$E86","v":0},0,0,{"$f":"Q86*$H86","v":0},{"$f":"Q86*$E86","v":0},0,0,{"$f":"U86*$H86","v":0},{"$f":"U86*$E86","v":0},0,0,{"$f":"Y86*$H86","v":0},{"$f":"Y86*$E86","v":0},0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F87=\"\",\"\",IF(F87=\"Foreign\",VLOOKUP(G87,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F88=\"\",\"\",IF(F88=\"Foreign\",VLOOKUP(G88,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F89=\"\",\"\",IF(F89=\"Foreign\",VLOOKUP(G89,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F90=\"\",\"\",IF(F90=\"Foreign\",VLOOKUP(G90,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F91=\"\",\"\",IF(F91=\"Foreign\",VLOOKUP(G91,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F92=\"\",\"\",IF(F92=\"Foreign\",VLOOKUP(G92,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F93=\"\",\"\",IF(F93=\"Foreign\",VLOOKUP(G93,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F94=\"\",\"\",IF(F94=\"Foreign\",VLOOKUP(G94,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F95=\"\",\"\",IF(F95=\"Foreign\",VLOOKUP(G95,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F96=\"\",\"\",IF(F96=\"Foreign\",VLOOKUP(G96,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F97=\"\",\"\",IF(F97=\"Foreign\",VLOOKUP(G97,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F98=\"\",\"\",IF(F98=\"Foreign\",VLOOKUP(G98,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F99=\"\",\"\",IF(F99=\"Foreign\",VLOOKUP(G99,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F100=\"\",\"\",IF(F100=\"Foreign\",VLOOKUP(G100,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},{"$f":"SUM(L86:L100)","v":0},{"$nulls":3},{"$f":"SUM(P86:P100)","v":0},{"$nulls":3},{"$f":"SUM(T86:T100)","v":0},{"$nulls":3},{"$f":"SUM(X86:X100)","v":0},{"$nulls":3},{"$f":"SUM(AB86:AB100)","v":0}]
[]
[{"$nulls":11},{"$f":"SUM(L101,P101,P101,T101,X101,AB101)","v":0}]
[]
[]
[null,{"$f":"C31","v":"QUALITY ASSURANCE ENVIRONMENT"}]
[{"$nulls":8},"Year 1",{"$nulls":3},"Year 2",{"$nulls":3},"Year 3",{"$nulls":3},"Year 4",{"$nulls":3},"Year 5"]
[null,"PART NUMBER",null,"DESCRIPTION","TOTAL ESTIMATED QUANTITIES","CURRENCY",null,null,"Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR",null,"CONTRACT PRICE ADJUSTMENT"]
[{"$nulls":5},{"$f":"IF(G109=\"\",\"\",IF(G109=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(F109=\"\",\"\",IF(F109=\"Foreign\",VLOOKUP(G109,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,{"$f":"M109*$H109","v":0},{"$f":"M109*$E109","v":0},0,0,{"$f":"Q109*$H109","v":0},{"$f":"Q109*$E109","v":0},0,0,{"$f":"U109*$H109","v":0},{"$f":"U109*$E109","v":0},0,0,{"$f":"Y109*$H109","v":0},{"$f":"Y109*$E109","v":0},0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F110=\"\",\"\",IF(F110=\"Foreign\",VLOOKUP(G110,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F111=\"\",\"\",IF(F111=\"Foreign\",VLOOKUP(G111,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F112=\"\",\"\",IF(F112=\"Foreign\",VLOOKUP(G112,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F113=\"\",\"\",IF(F113=\"Foreign\",VLOOKUP(G113,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F114=\"\",\"\",IF(F114=\"Foreign\",VLOOKUP(G114,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F115=\"\",\"\",IF(F115=\"Foreign\",VLOOKUP(G115,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F116=\"\",\"\",IF(F116=\"Foreign\",VLOOKUP(G116,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F117=\"\",\"\",IF(F117=\"Foreign\",VLOOKUP(G117,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F118=\"\",\"\",IF(F118=\"Foreign\",VLOOKUP(G118,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F119=\"\",\"\",IF(F119=\"Foreign\",VLOOKUP(G119,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F120=\"\",\"\",IF(F120=\"Foreign\",VLOOKUP(G120,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F121=\"\",\"\",IF(F121=\"Foreign\",VLOOKUP(G121,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F122=\"\",\"\",IF(F122=\"Foreign\",VLOOKUP(G122,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F123=\"\",\"\",IF(F123=\"Foreign\",VLOOKUP(G123,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":11},{"$f":"SUM(L109:L123)","v":0},{"$nulls":3},{"$f":"SUM(P109:P123)","v":0},{"$nulls":3},{"$f":"SUM(T109:T123)","v":0},{"$nulls":3},{"$f":"SUM(X109:X123)","v":0},{"$nulls":3},{"$f":"SUM(AB109:AB123)","v":0}]
[]
[{"$nulls":11},{"$f":"SUM(L124,P124,P124,T124,X124,AB124)","v":0}]
[]
[]
[null,{"$f":"C32","v":"DEVELOPMENT ENVIRONMENT"}]
[{"$nulls":8},"Year 1",{"$nulls":3},"Year 2",{"$nulls":3},"Year 3",{"$nulls":3},"Year 4",{"$nulls":3},"Year 5"]
[null,"PART NUMBER",null,"DESCRIPTION","TOTAL ESTIMATED QUANTITIES","CURRENCY",null,null,"Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR",null,"CONTRACT PRICE ADJUSTMENT"]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F132=\"\",\"\",IF(F132=\"Foreign\",VLOOKUP(G132,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,{"$f":"M132*$H132","v":0},{"$f":"M132*$E132","v":0},0,0,{"$f":"Q132*$H132","v":0},{"$f":"Q132*$E132","v":0},0,0,{"$f":"U132*$H132","v":0},{"$f":"U132*$E132","v":0},0,0,{"$f":"Y132*$H132","v":0},{"$f":"Y132*$E132","v":0},0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F133=\"\",\"\",IF(F133=\"Foreign\",VLOOKUP(G133,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F134=\"\",\"\",IF(F134=\"Foreign\",VLOOKUP(G134,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F135=\"\",\"\",IF(F135=\"Foreign\",VLOOKUP(G135,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F136=\"\",\"\",IF(F136=\"Foreign\",VLOOKUP(G136,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F137=\"\",\"\",IF(F137=\"Foreign\",VLOOKUP(G137,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F138=\"\",\"\",IF(F138=\"Foreign\",VLOOKUP(G138,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,{"$f":"I138*$H138","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F139=\"\",\"\",IF(F139=\"Foreign\",VLOOKUP(G139,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F140=\"\",\"\",IF(F140=\"Foreign\",VLOOKUP(G140,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F141=\"\",\"\",IF(F141=\"Foreign\",VLOOKUP(G141,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F142=\"\",\"\",IF(F142=\"Foreign\",VLOOKUP(G142,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F143=\"\",\"\",IF(F143=\"Foreign\",VLOOKUP(G143,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F144=\"\",\"\",IF(F144=\"Foreign\",VLOOKUP(G144,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F145=\"\",\"\",IF(F145=\"Foreign\",VLOOKUP(G145,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F146=\"\",\"\",IF(F146=\"Foreign\",VLOOKUP(G146,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total ",{"$nulls":9},{"$f":"SUM(L132:L146)","v":0},{"$nulls":3},{"$f":"SUM(P132:P146)","v":0},{"$nulls":3},{"$f":"SUM(T132:T146)","v":0},{"$nulls":3},{"$f":"SUM(X132:X146)","v":0},{"$nulls":3},{"$f":"SUM(AB132:AB146)","v":0}]
[]
[{"$nulls":11},{"$f":"SUM(L147,P147,P147,T147,X147,AB147)","v":0}]
[]
[]
[null,{"$f":"C33","v":"TRAINING ENVIRONMENT"}]
[{"$nulls":8},"Year 1",{"$nulls":3},"Year 2",{"$nulls":3},"Year 3",{"$nulls":3},"Year 4",{"$nulls":3},"Year 5"]
[null,"PART NUMBER",null,"DESCRIPTION","TOTAL ESTIMATED QUANTITIES","CURRENCY",null,null,"Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR",null,"CONTRACT PRICE ADJUSTMENT"]
[{"$nulls":5},{"$f":"IF(G155=\"\",\"\",IF(G155=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(F155=\"\",\"\",IF(F155=\"Foreign\",VLOOKUP(G155,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,{"$f":"I155*$H155","v":0},{"$f":"I155*$E155","v":0},0,0,{"$f":"M155*$H155","v":0},{"$f":"M155*$E155","v":0},0,0,{"$f":"Q155*$H155","v":0},{"$f":"Q155*$E155","v":0},0,0,{"$f":"U155*$H155","v":0},{"$f":"U155*$E155","v":0},0,0,{"$f":"Y155*$H155","v":0},{"$f":"Y155*$E155","v":0},0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F156=\"\",\"\",IF(F156=\"Foreign\",VLOOKUP(G156,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F157=\"\",\"\",IF(F157=\"Foreign\",VLOOKUP(G157,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F158=\"\",\"\",IF(F158=\"Foreign\",VLOOKUP(G158,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F159=\"\",\"\",IF(F159=\"Foreign\",VLOOKUP(G159,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F160=\"\",\"\",IF(F160=\"Foreign\",VLOOKUP(G160,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F161=\"\",\"\",IF(F161=\"Foreign\",VLOOKUP(G161,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F162=\"\",\"\",IF(F162=\"Foreign\",VLOOKUP(G162,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F163=\"\",\"\",IF(F163=\"Foreign\",VLOOKUP(G163,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F164=\"\",\"\",IF(F164=\"Foreign\",VLOOKUP(G164,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F165=\"\",\"\",IF(F165=\"Foreign\",VLOOKUP(G165,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F166=\"\",\"\",IF(F166=\"Foreign\",VLOOKUP(G166,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F167=\"\",\"\",IF(F167=\"Foreign\",VLOOKUP(G167,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F168=\"\",\"\",IF(F168=\"Foreign\",VLOOKUP(G168,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[{"$nulls":5},"Local","ZAR",{"$f":"IF(F169=\"\",\"\",IF(F169=\"Foreign\",VLOOKUP(G169,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Total ",{"$nulls":9},{"$f":"SUM(L155:L169)","v":0},{"$nulls":3},{"$f":"SUM(P155:P169)","v":0},{"$nulls":3},{"$f":"SUM(T155:T169)","v":0},{"$nulls":3},{"$f":"SUM(X155:X169)","v":0},{"$nulls":3},{"$f":"SUM(AB155:AB169)","v":0}]
[]
[null,"GRAND TOTAL",{"$nulls":9},{"$f":"SUM(L170,P170,P170,T170,X170,AB170)","v":0}]
[]
[null,"Overall Total",{"$nulls":9},{"$f":"SUM(L172,L149,L126,L103,L80,L57)","v":0}]

{"sheet":"NTCSA_Implement. and Support","index":4,"n_rows":148,"n_cols":35,"rows_kept":148,"merged":[[1,2,1,7],[26,6,26,8],[26,9,26,12],[27,6,27,8],[28,1,38,1],[28,2,38,2],[41,1,44,1],[41,2,44,2],[48,2,48,6],[50,2,55,2],[56,2,61,2],[62,2,67,2],[68,2,73,2],[74,2,79,2],[80,2,85,2],[86,2,97,2],[98,2,104,2],[105,2,110,2],[111,2,116,2],[117,2,122,2],[125,9,125,32],[126,5,126,7],[126,9,126,12],[126,14,126,17],[126,19,126,22],[126,24,126,27],[126,29,126,32],[127,5,127,7],[129,1,136,1],[129,2,136,2]]}
[]
[null,null,{"$f":"EH_Summary!B4","v":"VENDOR NAME"}]
[]
[]
[]
[null,null,"IMPORTANT NOTES"]
[null,null,"All cells highlighted in GREEN must be completed"]
[null,null,"Quoted prices MUST be in ZAR, EXCLUDING VAT and ESCALATIONS"]
[]
[null,null,"NTCSA Historian"]
[null,null,"Prices MUST be quoted based on the SCOPE provided"]
[null,null,"Estimated quantities are based on the required number of Licenses"]
[null,null,"Select the currency from the CURRENCY drop-down list in COLUMN \"H\""]
[]
[null,null,"Capture the applicable Currency, ROE and ROE Published Date on the \"Currency sheet\". "]
[null,null,"The adjustments for prevailing rates and the basis for future price adjustments will be determined at time of contracting. "]
[null,null,"Exchange rate variations may not be claimed for the local mark-up in the pricing structure"]
[]
[null,null,"NB: Provide details on the CONTRACT PRICE ADJUSTMENT in Column O for Solution Implementation and Column AI for the Maintenance phase. "]
[null,null,"Provide Cash-Flow projections for the Solution Implementation phase"]
[null,null,"Provide the Detailed Resource plan for the Implementation phase in TABLE 1: RESOURCES FOR IMPLEMENTATION"]
[]
[null,null,"All Prices must be exclusive of VAT"]
[]
[]
[]
[null,null," ",{"$nulls":6},"SOLUTION IMPLEMENTATION"]
[null,"Item Number","Category","Description","Total Estimated Quantity","Unit charge","CURRENCY",null,null,"Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR",null,"CONTRACT PRICE ADJUSTMENT"]
[null,1,"Solution Implementation \n(Applicable Stages)","Infrastructure Provisioning",1,"sum",{"$f":"IF(H29=\"\",\"\",IF(H29=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(G29=\"\",\"\",IF(G29=\"Foreign\",VLOOKUP(H29,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,{"$f":"J29*$I29","v":0},{"$f":"J29*$E29","v":0},{"$f":"H56*I29","v":0}]
[{"$nulls":3},"Infrastructure Configuration",1,"sum","Local","ZAR",{"$f":"IF(G30=\"\",\"\",IF(G30=\"Foreign\",VLOOKUP(H30,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},{"$f":"H62*I30","v":0}]
[{"$nulls":3},"Installation of Enterprise Historian components",1,"sum","Local","ZAR",{"$f":"IF(G31=\"\",\"\",IF(G31=\"Foreign\",VLOOKUP(H31,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,{"$f":"H68*I31","v":0}]
[{"$nulls":3},"Provisioning of redundant data collectors",7,"sum","Local","ZAR",{"$f":"IF(G32=\"\",\"\",IF(G32=\"Foreign\",VLOOKUP(H32,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,{"$f":"H74*I32","v":0}]
[{"$nulls":3},"Installation of redundant data collectors",7,"sum","Local","ZAR",{"$f":"IF(G33=\"\",\"\",IF(G33=\"Foreign\",VLOOKUP(H33,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},{"$f":"H80*I33","v":0}]
[{"$nulls":3},"Migration of eDNA datasets",1,"sum","Local","ZAR",{"$f":"IF(G34=\"\",\"\",IF(G34=\"Foreign\",VLOOKUP(H34,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,{"$f":"H86*I34","v":0}]
[{"$nulls":3},"Enterprise Historian Interfaces (Integration)",1,"sum","Local","ZAR",{"$f":"IF(G35=\"\",\"\",IF(G35=\"Foreign\",VLOOKUP(H35,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,{"$f":"H98*I35","v":0}]
[{"$nulls":3},"Implementation of Pilots",1,"sum","Local","ZAR",{"$f":"IF(G36=\"\",\"\",IF(G36=\"Foreign\",VLOOKUP(H36,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},{"$nulls":3},{"$f":"H105*I36","v":0}]
[{"$nulls":3},"Testing and Bug fixes",1,"sum","Local","ZAR",{"$f":"IF(G37=\"\",\"\",IF(G37=\"Foreign\",VLOOKUP(H37,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,{"$f":"H111*I37","v":0}]
[{"$nulls":3},"Deployment",1,"sum","Local","ZAR",{"$f":"IF(G38=\"\",\"\",IF(G38=\"Foreign\",VLOOKUP(H38,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,{"$f":"H117*I38","v":0}]
[{"$nulls":3},"Stabilisation & Go-Live Support",1,"sum","Local","ZAR",{"$f":"IF(G39=\"\",\"\",IF(G39=\"Foreign\",VLOOKUP(H39,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,{"$f":"H123*I39","v":0}]
[null,2,"Project Management","Project Management",1,"sum","Local","ZAR",{"$f":"IF(G40=\"\",\"\",IF(G40=\"Foreign\",VLOOKUP(H40,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0]
[null,3,"Changes Management","Change Management",1,"sum","Local","ZAR",{"$f":"IF(G41=\"\",\"\",IF(G41=\"Foreign\",VLOOKUP(H41,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0]
[null,4,"Training","System user",1,"sum","Local","ZAR",{"$f":"IF(G42=\"\",\"\",IF(G42=\"Foreign\",VLOOKUP(H42,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0]
[{"$nulls":3},"System Administrator",1,"sum","Local","ZAR",{"$f":"IF(G43=\"\",\"\",IF(G43=\"Foreign\",VLOOKUP(H43,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0]
[{"$nulls":3},"Train the Trainer (Including User Manuals)",1,"sum","Local","ZAR",{"$f":"IF(G44=\"\",\"\",IF(G44=\"Foreign\",VLOOKUP(H44,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,0]
[{"$nulls":3},"Skills Transfer",1,"sum","Local","ZAR",{"$f":"IF(G45=\"\",\"\",IF(G45=\"Foreign\",VLOOKUP(H45,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},0,0,0,{"$f":"K45*$E45","v":0}]
[null,null,"Total ",{"$nulls":9},{"$f":"SUM(M29:M45)","v":0}]
[]
[]
[null,null,"TABLE 1: RESOURCES FOR IMPLEMENTATION"]
[null,null,"Stage","Skill / Service","No. of Hours / Quantity","Hourly Rate / Unit Rate","Total"]
[null,null,"Infrastructure Provisioning","Solution Architect",0,0,{"$f":"F51*E51","v":0}]
[{"$nulls":3},"Technical Architect",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0,{"$f":"SUM(G51:G56)","v":0}]
[null,null,"Infrastructure Configuration","Solution Architect",0,0,0]
[{"$nulls":3},"Technical Architect",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0,{"$f":"SUM(G57:G62)","v":0}]
[null,null,"Installation of Enterprise Historian components","Implementation Specialists",0,0,0]
[{"$nulls":3},"Technical Application Specialist",0,0,0]
[{"$nulls":3},"Data Engineers",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0,{"$f":"SUM(G63:G68)","v":0}]
[null,null,"Provisioning of redundant data collectors","Application Engineer",0,0,0]
[{"$nulls":3},"Implementation Specialists"]
[{"$nulls":3},"Technical Application Specialist",0,0,{"$f":"F71*E71","v":0}]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0,{"$f":"SUM(G69:G74)","v":0}]
[null,null,"Installation of redundant data collectors","Application Engineer",0,0,0]
[{"$nulls":3},"Implementation Specialists"]
[{"$nulls":3},"Technical Application Specialist",0,0,{"$f":"F77*E77","v":0}]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0,{"$f":"SUM(G75:G80)","v":0}]
[null,null,"Migration of eDNA datasets","eDNA System and Process Engineer",0,0,0]
[{"$nulls":3},"Technical Application Specialist",0,0,0]
[{"$nulls":3},"Data Engineers",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0,{"$f":"SUM(G81:G86)","v":0}]
[null,null,"Enterprise Historian Interfaces (Integration)","Integration Architect",0,0,0]
[{"$nulls":3},"Integration Developer",0,0,0]
[{"$nulls":3},"Technical Architect",0,0,0]
[{"$nulls":3},"Data Engineers",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0,{"$f":"SUM(G87:G98)","v":0}]
[null,null,"Implementation of Pilots","Technical Architect",0,0,0]
[{"$nulls":3},"Data Engineers",0,0,0]
[{"$nulls":3},"Implementation Specialists",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0,{"$f":"SUM(G99:G105)","v":0}]
[null,null,"Testing and Bug fixes","Senior Tester",0,0,0]
[{"$nulls":3},"Intermediate Tester",0,0,0]
[{"$nulls":3},"Performance Engineer",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0,{"$f":"SUM(G106:G111)","v":0}]
[null,null,"Deployment","Implementation Specialist",0,0,0]
[{"$nulls":3},"Technical Application Specialist",0,0,0]
[{"$nulls":3},"Data Engineers",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0,{"$f":"SUM(G112:G117)","v":0}]
[null,null,"Stabilisation & Go-Live Support","Implementation Specialist",0,0,0]
[{"$nulls":3},"Technical Application Specialist",0,0,0]
[{"$nulls":3},"Data Engineers",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0]
[{"$nulls":3},"<Please specify>",0,0,0,{"$f":"SUM(G118:G123)","v":0}]
[]
[]
[{"$nulls":9},"CONTRACT EXECUTION"]
[null,null," ",{"$nulls":6},"YEAR 1",{"$nulls":4},"YEAR 2",{"$nulls":4},"YEAR 3",{"$nulls":4},"YEAR 4",{"$nulls":4},"YEAR 5"]
[null,"Item Number","Category","Description","Unit charge","CURRENCY",null,null,"Total Estimated Quantity","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Total Estimated Quantity","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Total Estimated Quantity","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Total Estimated Quantity","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR","Total Estimated Quantity","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR",null,"CONTRACT PRICE ADJUSTMENT"]
[null,1,"Support","Technical Support","sum",{"$f":"IF(G129=\"\",\"\",IF(G129=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(F129=\"\",\"\",IF(F129=\"Foreign\",VLOOKUP(G129,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,0,{"$f":"J129*$H129","v":0},{"$f":"J129*$I129","v":0},{"$f":"K129*$I129","v":0},1,0,{"$f":"O129*$H129","v":0},{"$f":"O129*$N129","v":0},{"$f":"P129*$N129","v":0},1,0,{"$f":"T129*$H129","v":0},{"$f":"T129*$S129","v":0},{"$f":"U129*$S129","v":0},1,0,{"$f":"Y129*$H129","v":0},{"$f":"Y129*$X129","v":0},{"$f":"Z129*$X129","v":0},1,0,{"$f":"AD129*$H129","v":0},{"$f":"AD129*$AC129","v":0},{"$f":"AE129*$AC129","v":0}]
[null,2,"Professional Services - System Specific Resources \n(As per SoW)\n","<Specify the resource>","Hourly","Local","ZAR",{"$f":"IF(F130=\"\",\"\",IF(F130=\"Foreign\",VLOOKUP(G130,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,0,{"$f":"J130*$H130","v":0},{"$f":"J130*$I130","v":0},0,1,0,{"$f":"O130*$H130","v":0},{"$f":"O130*$N130","v":0},0,1,0,{"$f":"T130*$H130","v":0},{"$f":"T130*$S130","v":0},0,1,0,{"$f":"Y130*$H130","v":0},{"$f":"Y130*$X130","v":0},0,1,0,{"$f":"AD130*$H130","v":0},{"$f":"AD130*$AC130","v":0},0]
[{"$nulls":3},"<Specify the resource>","Hourly","Local","ZAR",{"$f":"IF(F131=\"\",\"\",IF(F131=\"Foreign\",VLOOKUP(G131,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,0,{"$f":"J131*$H131","v":0},0,0,1,0,{"$f":"O131*$H131","v":0},0,0,1,0,{"$f":"T131*$H131","v":0},0,0,1,0,{"$f":"Y131*$H131","v":0},0,0,1,0,{"$f":"AD131*$H131","v":0},0,0]
[{"$nulls":3},"<Specify the resource>","Hourly","Local","ZAR",{"$f":"IF(F132=\"\",\"\",IF(F132=\"Foreign\",VLOOKUP(G132,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,0,0,0,0,1,0,0,0,0,1,0,0,0,0,1,0,0,0,0,1,0,0,0,0]
[{"$nulls":3},"<Specify the resource>","Hourly","Local","ZAR",{"$f":"IF(F133=\"\",\"\",IF(F133=\"Foreign\",VLOOKUP(G133,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,0,0,0,0,1,0,0,0,0,1,0,0,0,0,1,0,0,0,0,1,0,0,0,0]
[{"$nulls":3},"<Specify the resource>","Hourly","Local","ZAR",{"$f":"IF(F134=\"\",\"\",IF(F134=\"Foreign\",VLOOKUP(G134,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,0,0,0,0,1,0,0,0,0,1,0,0,0,0,1,0,0,0,0,1,0,0,0,0]
[{"$nulls":3},"<Specify the resource>","Hourly","Local","ZAR",{"$f":"IF(F135=\"\",\"\",IF(F135=\"Foreign\",VLOOKUP(G135,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,0,0,0,0,1,0,0,0,0,1,0,0,0,0,1,0,0,0,0,1,0,0,0,0]
[{"$nulls":3},"<Specify the resource>","Hourly","Local","ZAR",{"$f":"IF(F136=\"\",\"\",IF(F136=\"Foreign\",VLOOKUP(G136,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,0,0,0,0,1,0,0,0,0,1,0,0,0,0,1,0,0,0,0,1,0,0,0,0]
[{"$nulls":3},"<Specify the resource>","Hourly","Local","ZAR",{"$f":"IF(F137=\"\",\"\",IF(F137=\"Foreign\",VLOOKUP(G137,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,0,0,0,0,1,0,0,0,0,1,0,0,0,0,1,0,0,0,0,1,0,0,0,0]
[null,null,"Total ",{"$nulls":9},{"$f":"SUM(M129:M129,M130:M137)","v":0},{"$nulls":4},{"$f":"SUM(R129:R129,R130:R137)","v":0},{"$nulls":4},{"$f":"SUM(W129:W129,W130:W137)","v":0},{"$nulls":4},{"$f":"SUM(AB129:AB129,AB130:AB137)","v":0},{"$nulls":4},{"$f":"SUM(AG129:AG129,AG130:AG137)","v":0}]
[]
[null,null,"GRAND TOTAL",{"$nulls":9},{"$f":"SUM(M138,R138,W138,AB138,AG138)","v":0}]
[]
[]
[]
[null,null,"SOLUTION IMPLEMENTATION",{"$f":"M46","v":0}]
[]
[null,null,"SOLUTION SUPPORT",{"$f":"M140","v":0}]
[]
[null,null,"GRAND TOTAL",{"$f":"SUM(D144,D146)","v":0}]

{"sheet":"Currency","index":5,"n_rows":33,"n_cols":8,"rows_kept":33,"merged":[[1,1,1,5],[6,2,6,7],[7,1,9,1],[7,2,7,7],[7,15,7,20],[8,2,8,7],[9,2,9,7],[10,2,10,7],[11,2,11,7],[12,1,14,1],[12,2,12,7],[13,2,13,7],[14,2,14,7],[17,2,17,7]]}
[]
[null,{"$f":"Dx_License!B2:H2","v":"VENDOR NAME"}]
[]
[null,"EXCHANGE RATES FOR MULTIPLE CURRENCIES"]
[]
[null,"NOTES:"]
[null,1,"The table below needs to be completed if the Employer will be exposed to any currency fluctuation as stipulated in Secondary Clause X3.  For conversion of the foreign portions to Rand, please use the South African Reserve Bank's (SARB) exchange rate at 12:00 on the day of advertisement of the bid.  This is in terms of the Preferential Procurement Policy Framework Act (PPPFA) with which the Employer has to comply.\nNB: Tenderers must submit proof of the SARB rate(s) of exchange used  "]
[null,2,"The following URL (electronic route) is to be followed to access the relevant SARB rates on their web pages:\n"]
[null,null,"www.resbank.co.za"]
[null,null,"-  Select Research\n-  Then select Rates\n-  Click on \"Select historical exchange rates and other interest rates\"\n-  Clicking on the exchange rate in the following page opens the daily rates per currency and SA Rand"]
[null,3,"The Employer deals only in the currencies listed below unless other currencies are specifically approved for this tender.  Kindly notify the Employer of any currency that the tenderer intends to use, but is not stipulated in the table, to consider sanctioning such currency.  Sufficient time must be allowed for the assessment and to respond to such request.  The onus is on the tenderer to submit a bid with approved currencies"]
[null,4,"The format in which the exchange rate must be inserted in the table is:  1 (One) Foreign Currency = R Amount  (i.e. the Rand amount for one of each foreign currency applicable).  Exchange rates must be rounded to 4 decimals\n\nNB :  Only the USD/ZAR, GBP/ZAR and EUR/ZAR are published in this way on the SARB web pages above.  The Rand rate with the other currencies must be inverted (1/Foreign Currency Rate) in order to list it in the required format in the table below\n"]
[null,5,"All information in the table below must conform with all other equivalent information in the offer. "]
[null,null,"Payment in terms of Payment Method 2  is considered as a \"foreign payment\" although it will be effected in South African Rand. However, amounts for  \"F.O.R. Price-Goods supplied from Imported Items\", are NOT considered as \"foreign payments\""]
[null,null,"If more than one payment method apply for a currency, the Tenderer must request an additional row be inserted in the table in order to split the values and identify the relevant method.   "]
[]
[]
[null,null,"MULTIPLE CURRENCIES"]
[null,null,"No","Currency Description","Code","Exchange Rate Currency 1,00 =","Date Published","Source"]
[null,null,1,"Australian Dollar","AUD"]
[null,null,2,"Canadian Dollar","CAN"]
[null,null,3,"Swiss Franc","CHF"]
[null,null,4,"Danish Krone","DKK"]
[null,null,5,"European Currency","EUR"]
[null,null,6,"British Pound","GBP"]
[null,null,7,"Hong Kong Dollar","HKD"]
[null,null,8,"Japanese Yen","JPY"]
[null,null,9,"Norwegian Krone","NOK"]
[null,null,10,"New Zealand Dollar","NZD"]
[null,null,11,"Swedish Krone","SEK"]
[null,null,12,"Singapore Dollar","SGD"]
[null,null,13,"United States Dollar","USD"]
[null,null,14,"South African Rand","ZAR",{"v":1,"d":"R 1.000000"}]