{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["SIP Trunks","SIP Trunks Details","Currency"],"not_rendered":{"external_links":7,"defined_names":398},"read":"whole","date_system":"1900"}

{"sheet":"SIP Trunks","index":0,"n_rows":56,"n_cols":23,"rows_kept":56,"merged":[[2,1,2,6],[28,4,28,6],[28,7,28,11],[28,13,28,17],[28,19,28,20],[29,4,29,6],[32,0,34,0],[32,1,34,1],[36,0,42,0],[36,1,42,1],[43,0,44,0],[43,1,44,1],[45,0,48,0],[45,1,48,1],[54,1,54,11],[55,1,78,11]]}
[null,"Pricing Schedule : SIP Trunks"]
[]
[null,"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,"SIP Trunks"]
[null,"Prices MUST be quoted based on the SCOPE provided"]
[null,"Select the currency from the CURRENCY drop-down list in COLUMN \"F\""]
[]
[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,"SIP TRUNKS DETAILS: Provide the detailed requirements for the OT Environment"]
[]
[null,"NB: Provide details of pricing assumptions made in the submission IN TABLE 1"]
[]
[null,"Indicate the applicable CPA - IN COLUMN W to allow for Price Adjustments"]
[]
[null,"All Prices must be exclusive of VAT"]
[]
[]
[]
[null," ",{"$nulls":5},"PROJECT PHASE (FOR A PERIOD OF 1 YEAR)",{"$nulls":5},"OPERATIONS PHASE (ANNUAL COST FOR A PERIOD OF 9 YEARS)",{"$nulls":5},"TOTAL OVER 9 YEARS"]
["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",null,"Total Estimated Quantity","Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR",null,"Total [Nominated Currency]","Total in ZAR",null,"CONTRACT PRICE ADJUSTEMENT"]
[1,"Infrastructure (OT Requirements)","Replacement of the PRI/BRI infrastructure","sum",{"$f":"IF(F31=\"\",\"\",IF(F31=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(E31=\"\",\"\",IF(E31=\"Foreign\",VLOOKUP(F31,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},null,0,{"$f":"I31*$G31","v":0},{"$f":"'SIP Trunks Details'!L355","v":0},{"$f":"'SIP Trunks Details'!M355","v":0},null,null,0,{"$f":"O31*$G31","v":0},{"$f":"'SIP Trunks Details'!Q355","v":0},{"$f":"'SIP Trunks Details'!R355","v":0},null,{"$f":"Q31*9","v":0},{"$f":"R31*9","v":0}]
[2,"Software","Subscription","sum",{"$f":"IF(F32=\"\",\"\",IF(F32=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(E32=\"\",\"\",IF(E32=\"Foreign\",VLOOKUP(F32,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,0,{"$f":"I32*$G32","v":0},{"$f":"I32*$H32","v":0},{"$f":"J32*$H32","v":0},null,1,0,{"$f":"O32*$G32","v":0},{"$f":"O32*$N32","v":0},{"$f":"P32*$N32","v":0},null,{"$f":"Q32*9","v":0},{"$f":"R32*9","v":0}]
[3,"Implementation","MS Teams Phone Direct Routing","sum",{"$f":"IF(F33=\"\",\"\",IF(F33=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(E33=\"\",\"\",IF(E33=\"Foreign\",VLOOKUP(F33,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,0,0,0,0]
[null,null,"Number portability","sum",{"$f":"IF(F34=\"\",\"\",IF(F34=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(E34=\"\",\"\",IF(E34=\"Foreign\",VLOOKUP(F34,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,0,{"$f":"I34*$G34","v":0},{"$f":"I34*$H34","v":0},{"$f":"J34*$H34","v":0}]
[null,null,"Configuration","sum",{"$f":"IF(F35=\"\",\"\",IF(F35=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(E35=\"\",\"\",IF(E35=\"Foreign\",VLOOKUP(F35,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,0,{"$f":"I35*$G35","v":0},{"$f":"I35*$H35","v":0},{"$f":"J35*$H35","v":0}]
[4,"Voice Minutes","Voice Minutes","Per Minute",{"$f":"IF(F36=\"\",\"\",IF(F36=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(E36=\"\",\"\",IF(E36=\"Foreign\",VLOOKUP(F36,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,0,0,0,0,null,1,0,0,{"$f":"O36*$N36","v":0},{"$f":"P36*$N36","v":0},null,{"$f":"Q36*9","v":0},{"$f":"R36*9","v":0}]
[5,"Professional Services\n(As and When Required)","Unified Comms Engineer","Hourly",{"$f":"IF(F37=\"\",\"\",IF(F37=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(E37=\"\",\"\",IF(E37=\"Foreign\",VLOOKUP(F37,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1896,0,{"$f":"I37*$G37","v":0},{"$f":"I37*$H37","v":0},{"$f":"J37*$H37","v":0},null,656,0,0,0,0,null,{"$f":"Q37","v":0},{"$f":"R37","v":0}]
[null,null,"Project Manager","Hourly","Local","ZAR",{"$f":"IF(E38=\"\",\"\",IF(E38=\"Foreign\",VLOOKUP(F38,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1896,0,0,0,0,null,656,0,0,0,0,null,{"$f":"Q38","v":0},{"$f":"R38*9","v":0}]
[null,null,"Test Manager","Hourly",{"$f":"IF(F39=\"\",\"\",IF(F39=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(E39=\"\",\"\",IF(E39=\"Foreign\",VLOOKUP(F39,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1896,0,{"$f":"I39*$G39","v":0},{"$f":"I39*$H39","v":0},{"$f":"J39*$H39","v":0},null,656,0,{"$f":"O39*$G39","v":0},{"$f":"O39*$N39","v":0},{"$f":"P39*$N39","v":0},null,{"$f":"Q39","v":0},{"$f":"R39*9","v":0}]
[null,null,"Test Analyst (Unified Comms Engineer)","Hourly","Local","ZAR",{"$f":"IF(E40=\"\",\"\",IF(E40=\"Foreign\",VLOOKUP(F40,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1896,0,0,0,0,null,632,0,0,0,0,null,0,0]
[null,null,"Solution Architect","Hourly","Local","ZAR",{"$f":"IF(E41=\"\",\"\",IF(E41=\"Foreign\",VLOOKUP(F41,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1896,0,0,0,0,null,656,0,0,0,0,null,0,0]
[null,null,"Network Specialist","Hourly",{"$f":"IF(F42=\"\",\"\",IF(F42=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(E42=\"\",\"\",IF(E42=\"Foreign\",VLOOKUP(F42,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1368,0,{"$f":"I42*$G42","v":0},{"$f":"I42*$H42","v":0},{"$f":"J42*$H42","v":0},null,320,0,0,0,0,null,0,0]
[null,null,"Security Specialist","Hourly","Local","ZAR",{"$f":"IF(E43=\"\",\"\",IF(E43=\"Foreign\",VLOOKUP(F43,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1368,0,0,0,0,null,320,0,0,0,0,null,0,0]
[6,"Training","Skills Transfer","per Attendee","Local","ZAR",{"$f":"IF(E44=\"\",\"\",IF(E44=\"Foreign\",VLOOKUP(F44,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},20,0,0,0,0]
[null,null,"Seminars","per Attendee","Local","ZAR",{"$f":"IF(E45=\"\",\"\",IF(E45=\"Foreign\",VLOOKUP(F45,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},20,0,0,0,0]
[7,"Other\n(Applicable to the Proposed Services)","<Specify>","Sum","Local","ZAR",{"$f":"IF(E46=\"\",\"\",IF(E46=\"Foreign\",VLOOKUP(F46,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,0,0,0,0,null,1,0,{"$f":"O46*$G46","v":0},{"$f":"O46*$N46","v":0},{"$f":"P46*$N46","v":0},null,{"$f":"Q46*9","v":0},{"$f":"R46*9","v":0}]
[null,null,"<Specify>","Sum","Local","ZAR",{"$f":"IF(E47=\"\",\"\",IF(E47=\"Foreign\",VLOOKUP(F47,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,0,0,0,0,null,1,0,0,0,0,null,{"$f":"Q47*9","v":0},{"$f":"R47*9","v":0}]
[null,null,"<Specify>","Sum","Local","ZAR",{"$f":"IF(E48=\"\",\"\",IF(E48=\"Foreign\",VLOOKUP(F48,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,0,0,0,0,null,1,0,0,0,0,null,0,0]
[null,null,"<Specify>","Sum","Local","ZAR",{"$f":"IF(E49=\"\",\"\",IF(E49=\"Foreign\",VLOOKUP(F49,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,0,0,0,0,null,1,0,0,0,0,null,0,0]
[null,"Total ",{"$nulls":9},{"$f":"SUM(L31:L49)","v":0},{"$nulls":5},{"$f":"SUM(R31:R32,R36:R43,R46:R49)","v":0},null,null,{"$f":"SUM(U31:U32,U36:U43,U46:U49)","v":0}]
[]
[null,"GRAND TOTAL",{"$nulls":9},{"$f":"(L50)+(U50)","v":0}]
[]
[]
[null,"TABLE 1: PROVIDE ANY PRICING ASSUMPTIONS USED TO DETERMINE THE QUOTED PRICE"]
[null," "]

{"sheet":"SIP Trunks Details","index":1,"n_rows":355,"n_cols":21,"rows_kept":355,"merged":[[2,1,2,6],[6,4,6,6],[6,9,6,12],[6,14,6,17],[7,4,7,6],[8,0,21,0],[8,1,21,1],[22,0,35,0],[22,1,35,1],[36,0,49,0],[36,1,49,1],[50,0,63,0],[50,1,63,1],[64,0,77,0],[64,1,77,1],[78,0,91,0],[78,1,91,1],[92,0,105,0],[92,1,105,1],[106,0,119,0],[106,1,119,1],[126,4,126,6],[127,0,140,0],[127,1,140,1],[141,0,154,0],[141,1,154,1],[155,0,168,0],[155,1,168,1],[169,0,182,0],[169,1,182,1],[183,0,196,0],[183,1,196,1],[197,0,210,0],[197,1,210,1],[211,0,224,0],[211,1,224,1],[225,0,238,0],[225,1,238,1],[239,0,252,0],[239,1,252,1],[253,0,266,0],[253,1,266,1],[267,0,280,0],[267,1,280,1],[281,0,294,0],[281,1,294,1],[295,0,308,0],[295,1,308,1],[309,0,322,0],[309,1,322,1],[323,0,336,0],[323,1,336,1],[337,0,350,0],[337,1,350,1]]}
[null,"Pricing Schedule : SIP Trunks"]
[]
[null,{"$f":"'SIP Trunks'!B3:G3","v":"VENDOR NAME"}]
[]
[null,"OT PRIMARY SITES"]
[]
[null," ",{"$nulls":7},"PROJECT PHASE - COSTS",{"$nulls":4},"OPERATIONS PHASED COSTS (RECURRING COST OVER CONTRACT DURATION)"]
["Item Number","Category","Detailed Requirements","Unit charge","CURRENCY",null,null,"Total Estimated Quantity",null,"Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR",null,"Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR",null,null,"CONTRACT PRICE ADJUSTEMENT"]
[1,"Simmerpan (Bandwidth - 20mb/s) (Number of Calls - 240)",null,"sum",{"$f":"IF(F9=\"\",\"\",IF(F9=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(E9=\"\",\"\",IF(E9=\"Foreign\",VLOOKUP(F9,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,{"$f":"J9*$G9","v":0},{"$f":"J9*$H9","v":0},0,null,0,{"$f":"O9*$G9","v":0},{"$f":"O9*$H9","v":0},{"$f":"P9*$H9","v":0}]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E10=\"\",\"\",IF(E10=\"Foreign\",VLOOKUP(F10,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum",{"$f":"IF(F11=\"\",\"\",IF(F11=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(E11=\"\",\"\",IF(E11=\"Foreign\",VLOOKUP(F11,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,{"$f":"J11*$G11","v":0},{"$f":"J11*$H11","v":0},{"$f":"K11*$H11","v":0},null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E12=\"\",\"\",IF(E12=\"Foreign\",VLOOKUP(F12,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E13=\"\",\"\",IF(E13=\"Foreign\",VLOOKUP(F13,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E14=\"\",\"\",IF(E14=\"Foreign\",VLOOKUP(F14,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E15=\"\",\"\",IF(E15=\"Foreign\",VLOOKUP(F15,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E16=\"\",\"\",IF(E16=\"Foreign\",VLOOKUP(F16,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E17=\"\",\"\",IF(E17=\"Foreign\",VLOOKUP(F17,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E18=\"\",\"\",IF(E18=\"Foreign\",VLOOKUP(F18,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E19=\"\",\"\",IF(E19=\"Foreign\",VLOOKUP(F19,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E20=\"\",\"\",IF(E20=\"Foreign\",VLOOKUP(F20,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E21=\"\",\"\",IF(E21=\"Foreign\",VLOOKUP(F21,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E22=\"\",\"\",IF(E22=\"Foreign\",VLOOKUP(F22,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[2,"Duvha (Bandwidth - 20mb/s) (Number of Calls - 240)",null,"sum","Local","ZAR",{"$f":"IF(E23=\"\",\"\",IF(E23=\"Foreign\",VLOOKUP(F23,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E24=\"\",\"\",IF(E24=\"Foreign\",VLOOKUP(F24,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum",{"$f":"IF(F25=\"\",\"\",IF(F25=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(E25=\"\",\"\",IF(E25=\"Foreign\",VLOOKUP(F25,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,{"$f":"J25*$G25","v":0},{"$f":"J25*$H25","v":0},{"$f":"K25*$H25","v":0},null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E26=\"\",\"\",IF(E26=\"Foreign\",VLOOKUP(F26,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E27=\"\",\"\",IF(E27=\"Foreign\",VLOOKUP(F27,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E28=\"\",\"\",IF(E28=\"Foreign\",VLOOKUP(F28,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E29=\"\",\"\",IF(E29=\"Foreign\",VLOOKUP(F29,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E30=\"\",\"\",IF(E30=\"Foreign\",VLOOKUP(F30,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E31=\"\",\"\",IF(E31=\"Foreign\",VLOOKUP(F31,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E32=\"\",\"\",IF(E32=\"Foreign\",VLOOKUP(F32,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E33=\"\",\"\",IF(E33=\"Foreign\",VLOOKUP(F33,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E34=\"\",\"\",IF(E34=\"Foreign\",VLOOKUP(F34,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E35=\"\",\"\",IF(E35=\"Foreign\",VLOOKUP(F35,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E36=\"\",\"\",IF(E36=\"Foreign\",VLOOKUP(F36,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[3,"Bellvile (Bandwidth - 5mb/s) (Number of Calls - 60)",null,"sum","Local","ZAR",{"$f":"IF(E37=\"\",\"\",IF(E37=\"Foreign\",VLOOKUP(F37,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E38=\"\",\"\",IF(E38=\"Foreign\",VLOOKUP(F38,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum",{"$f":"IF(F39=\"\",\"\",IF(F39=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(E39=\"\",\"\",IF(E39=\"Foreign\",VLOOKUP(F39,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,{"$f":"J39*$G39","v":0},{"$f":"J39*$H39","v":0},{"$f":"K39*$H39","v":0},null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E40=\"\",\"\",IF(E40=\"Foreign\",VLOOKUP(F40,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E41=\"\",\"\",IF(E41=\"Foreign\",VLOOKUP(F41,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E42=\"\",\"\",IF(E42=\"Foreign\",VLOOKUP(F42,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E43=\"\",\"\",IF(E43=\"Foreign\",VLOOKUP(F43,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E44=\"\",\"\",IF(E44=\"Foreign\",VLOOKUP(F44,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E45=\"\",\"\",IF(E45=\"Foreign\",VLOOKUP(F45,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E46=\"\",\"\",IF(E46=\"Foreign\",VLOOKUP(F46,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E47=\"\",\"\",IF(E47=\"Foreign\",VLOOKUP(F47,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E48=\"\",\"\",IF(E48=\"Foreign\",VLOOKUP(F48,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E49=\"\",\"\",IF(E49=\"Foreign\",VLOOKUP(F49,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E50=\"\",\"\",IF(E50=\"Foreign\",VLOOKUP(F50,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[4,"Sunilaws (Bandwidth - 5mb/s) (Number of Calls - 60)",null,"sum","Local","ZAR",{"$f":"IF(E51=\"\",\"\",IF(E51=\"Foreign\",VLOOKUP(F51,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E52=\"\",\"\",IF(E52=\"Foreign\",VLOOKUP(F52,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E53=\"\",\"\",IF(E53=\"Foreign\",VLOOKUP(F53,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E54=\"\",\"\",IF(E54=\"Foreign\",VLOOKUP(F54,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E55=\"\",\"\",IF(E55=\"Foreign\",VLOOKUP(F55,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E56=\"\",\"\",IF(E56=\"Foreign\",VLOOKUP(F56,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E57=\"\",\"\",IF(E57=\"Foreign\",VLOOKUP(F57,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E58=\"\",\"\",IF(E58=\"Foreign\",VLOOKUP(F58,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E59=\"\",\"\",IF(E59=\"Foreign\",VLOOKUP(F59,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E60=\"\",\"\",IF(E60=\"Foreign\",VLOOKUP(F60,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E61=\"\",\"\",IF(E61=\"Foreign\",VLOOKUP(F61,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E62=\"\",\"\",IF(E62=\"Foreign\",VLOOKUP(F62,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E63=\"\",\"\",IF(E63=\"Foreign\",VLOOKUP(F63,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E64=\"\",\"\",IF(E64=\"Foreign\",VLOOKUP(F64,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[5,"Bloemfonein (Bandwidth - 2mb/s) (Number of Calls - 24)",null,"sum","Local","ZAR",{"$f":"IF(E65=\"\",\"\",IF(E65=\"Foreign\",VLOOKUP(F65,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E66=\"\",\"\",IF(E66=\"Foreign\",VLOOKUP(F66,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E67=\"\",\"\",IF(E67=\"Foreign\",VLOOKUP(F67,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E68=\"\",\"\",IF(E68=\"Foreign\",VLOOKUP(F68,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E69=\"\",\"\",IF(E69=\"Foreign\",VLOOKUP(F69,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E70=\"\",\"\",IF(E70=\"Foreign\",VLOOKUP(F70,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E71=\"\",\"\",IF(E71=\"Foreign\",VLOOKUP(F71,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E72=\"\",\"\",IF(E72=\"Foreign\",VLOOKUP(F72,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E73=\"\",\"\",IF(E73=\"Foreign\",VLOOKUP(F73,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,{"$f":"O73*$G73","v":0},{"$f":"O73*$H73","v":0},{"$f":"P73*$H73","v":0}]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E74=\"\",\"\",IF(E74=\"Foreign\",VLOOKUP(F74,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E75=\"\",\"\",IF(E75=\"Foreign\",VLOOKUP(F75,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E76=\"\",\"\",IF(E76=\"Foreign\",VLOOKUP(F76,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E77=\"\",\"\",IF(E77=\"Foreign\",VLOOKUP(F77,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E78=\"\",\"\",IF(E78=\"Foreign\",VLOOKUP(F78,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[6,"Blankenbergvlei (Bandwidth - 2mb/s) (Number of Calls - 24)",null,"sum","Local","ZAR",{"$f":"IF(E79=\"\",\"\",IF(E79=\"Foreign\",VLOOKUP(F79,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E80=\"\",\"\",IF(E80=\"Foreign\",VLOOKUP(F80,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E81=\"\",\"\",IF(E81=\"Foreign\",VLOOKUP(F81,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E82=\"\",\"\",IF(E82=\"Foreign\",VLOOKUP(F82,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E83=\"\",\"\",IF(E83=\"Foreign\",VLOOKUP(F83,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E84=\"\",\"\",IF(E84=\"Foreign\",VLOOKUP(F84,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E85=\"\",\"\",IF(E85=\"Foreign\",VLOOKUP(F85,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E86=\"\",\"\",IF(E86=\"Foreign\",VLOOKUP(F86,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E87=\"\",\"\",IF(E87=\"Foreign\",VLOOKUP(F87,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E88=\"\",\"\",IF(E88=\"Foreign\",VLOOKUP(F88,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E89=\"\",\"\",IF(E89=\"Foreign\",VLOOKUP(F89,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E90=\"\",\"\",IF(E90=\"Foreign\",VLOOKUP(F90,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E91=\"\",\"\",IF(E91=\"Foreign\",VLOOKUP(F91,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E92=\"\",\"\",IF(E92=\"Foreign\",VLOOKUP(F92,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[7,"Mkondeni (Bandwidth - 2mb/s) (Number of Calls - 24)",null,"sum","Local","ZAR",{"$f":"IF(E93=\"\",\"\",IF(E93=\"Foreign\",VLOOKUP(F93,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E94=\"\",\"\",IF(E94=\"Foreign\",VLOOKUP(F94,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E95=\"\",\"\",IF(E95=\"Foreign\",VLOOKUP(F95,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E96=\"\",\"\",IF(E96=\"Foreign\",VLOOKUP(F96,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E97=\"\",\"\",IF(E97=\"Foreign\",VLOOKUP(F97,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E98=\"\",\"\",IF(E98=\"Foreign\",VLOOKUP(F98,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E99=\"\",\"\",IF(E99=\"Foreign\",VLOOKUP(F99,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E100=\"\",\"\",IF(E100=\"Foreign\",VLOOKUP(F100,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E101=\"\",\"\",IF(E101=\"Foreign\",VLOOKUP(F101,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E102=\"\",\"\",IF(E102=\"Foreign\",VLOOKUP(F102,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum",{"$f":"IF(F103=\"\",\"\",IF(F103=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(E103=\"\",\"\",IF(E103=\"Foreign\",VLOOKUP(F103,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,{"$f":"J103*$G103","v":0},{"$f":"J103*$H103","v":0},{"$f":"K103*$H103","v":0},null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E104=\"\",\"\",IF(E104=\"Foreign\",VLOOKUP(F104,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E105=\"\",\"\",IF(E105=\"Foreign\",VLOOKUP(F105,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E106=\"\",\"\",IF(E106=\"Foreign\",VLOOKUP(F106,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[8,"Witbank (Bandwidth - 2mb/s) (Number of Calls - 24)",null,"sum","Local","ZAR",{"$f":"IF(E107=\"\",\"\",IF(E107=\"Foreign\",VLOOKUP(F107,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E108=\"\",\"\",IF(E108=\"Foreign\",VLOOKUP(F108,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E109=\"\",\"\",IF(E109=\"Foreign\",VLOOKUP(F109,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E110=\"\",\"\",IF(E110=\"Foreign\",VLOOKUP(F110,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E111=\"\",\"\",IF(E111=\"Foreign\",VLOOKUP(F111,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E112=\"\",\"\",IF(E112=\"Foreign\",VLOOKUP(F112,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E113=\"\",\"\",IF(E113=\"Foreign\",VLOOKUP(F113,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E114=\"\",\"\",IF(E114=\"Foreign\",VLOOKUP(F114,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E115=\"\",\"\",IF(E115=\"Foreign\",VLOOKUP(F115,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E116=\"\",\"\",IF(E116=\"Foreign\",VLOOKUP(F116,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E117=\"\",\"\",IF(E117=\"Foreign\",VLOOKUP(F117,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E118=\"\",\"\",IF(E118=\"Foreign\",VLOOKUP(F118,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E119=\"\",\"\",IF(E119=\"Foreign\",VLOOKUP(F119,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E120=\"\",\"\",IF(E120=\"Foreign\",VLOOKUP(F120,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":11},{"$f":"SUM(L9:L120)","v":0},{"$f":"SUM(M9:M120)","v":0},{"$nulls":3},{"$f":"SUM(Q9:Q120)","v":0},{"$f":"SUM(R9:R120)","v":0}]
[]
[]
[]
[null,"OT POWER STATIONS"]
[]
["Item Number","Category","Detailed Requirements","Unit charge","CURRENCY",null,null,"Total Estimated Quantity",null,"Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR",null,"Unit Price in Nominated Currency","Unit Price in ZAR","Total [Nominated Currency]","Total in ZAR",null,null,"CONTRACT PRICE ADJUSTEMENT"]
[1,"Tutuka Power Station (Bandwidth - 2mb/s) (Number of Calls - 24)",null,"sum",{"$f":"IF(F128=\"\",\"\",IF(F128=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(E128=\"\",\"\",IF(E128=\"Foreign\",VLOOKUP(F128,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,{"$f":"J128*$G128","v":0},{"$f":"J128*$H128","v":0},{"$f":"K128*$H128","v":0},null,0,{"$f":"O128*$G128","v":0},{"$f":"O128*$H128","v":0},{"$f":"P128*$H128","v":0}]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E129=\"\",\"\",IF(E129=\"Foreign\",VLOOKUP(F129,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E130=\"\",\"\",IF(E130=\"Foreign\",VLOOKUP(F130,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E131=\"\",\"\",IF(E131=\"Foreign\",VLOOKUP(F131,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E132=\"\",\"\",IF(E132=\"Foreign\",VLOOKUP(F132,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E133=\"\",\"\",IF(E133=\"Foreign\",VLOOKUP(F133,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E134=\"\",\"\",IF(E134=\"Foreign\",VLOOKUP(F134,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E135=\"\",\"\",IF(E135=\"Foreign\",VLOOKUP(F135,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E136=\"\",\"\",IF(E136=\"Foreign\",VLOOKUP(F136,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E137=\"\",\"\",IF(E137=\"Foreign\",VLOOKUP(F137,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E138=\"\",\"\",IF(E138=\"Foreign\",VLOOKUP(F138,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E139=\"\",\"\",IF(E139=\"Foreign\",VLOOKUP(F139,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E140=\"\",\"\",IF(E140=\"Foreign\",VLOOKUP(F140,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E141=\"\",\"\",IF(E141=\"Foreign\",VLOOKUP(F141,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[2,"Medupi Power Station (Bandwidth - 2mb/s) (Number of Calls - 24)",null,"sum","Local","ZAR",{"$f":"IF(E142=\"\",\"\",IF(E142=\"Foreign\",VLOOKUP(F142,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E143=\"\",\"\",IF(E143=\"Foreign\",VLOOKUP(F143,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E144=\"\",\"\",IF(E144=\"Foreign\",VLOOKUP(F144,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E145=\"\",\"\",IF(E145=\"Foreign\",VLOOKUP(F145,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E146=\"\",\"\",IF(E146=\"Foreign\",VLOOKUP(F146,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E147=\"\",\"\",IF(E147=\"Foreign\",VLOOKUP(F147,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E148=\"\",\"\",IF(E148=\"Foreign\",VLOOKUP(F148,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E149=\"\",\"\",IF(E149=\"Foreign\",VLOOKUP(F149,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E150=\"\",\"\",IF(E150=\"Foreign\",VLOOKUP(F150,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E151=\"\",\"\",IF(E151=\"Foreign\",VLOOKUP(F151,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E152=\"\",\"\",IF(E152=\"Foreign\",VLOOKUP(F152,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E153=\"\",\"\",IF(E153=\"Foreign\",VLOOKUP(F153,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E154=\"\",\"\",IF(E154=\"Foreign\",VLOOKUP(F154,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E155=\"\",\"\",IF(E155=\"Foreign\",VLOOKUP(F155,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[3,"Matla Power Station (Bandwidth - 2mb/s) (Number of Calls - 24)",null,"sum","Local","ZAR",{"$f":"IF(E156=\"\",\"\",IF(E156=\"Foreign\",VLOOKUP(F156,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E157=\"\",\"\",IF(E157=\"Foreign\",VLOOKUP(F157,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E158=\"\",\"\",IF(E158=\"Foreign\",VLOOKUP(F158,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E159=\"\",\"\",IF(E159=\"Foreign\",VLOOKUP(F159,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E160=\"\",\"\",IF(E160=\"Foreign\",VLOOKUP(F160,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E161=\"\",\"\",IF(E161=\"Foreign\",VLOOKUP(F161,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E162=\"\",\"\",IF(E162=\"Foreign\",VLOOKUP(F162,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E163=\"\",\"\",IF(E163=\"Foreign\",VLOOKUP(F163,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E164=\"\",\"\",IF(E164=\"Foreign\",VLOOKUP(F164,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E165=\"\",\"\",IF(E165=\"Foreign\",VLOOKUP(F165,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E166=\"\",\"\",IF(E166=\"Foreign\",VLOOKUP(F166,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E167=\"\",\"\",IF(E167=\"Foreign\",VLOOKUP(F167,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E168=\"\",\"\",IF(E168=\"Foreign\",VLOOKUP(F168,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E169=\"\",\"\",IF(E169=\"Foreign\",VLOOKUP(F169,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[4,"Matimba Power Station (Bandwidth - 2mb/s) (Number of Calls - 24)",null,"sum","Local","ZAR",{"$f":"IF(E170=\"\",\"\",IF(E170=\"Foreign\",VLOOKUP(F170,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E171=\"\",\"\",IF(E171=\"Foreign\",VLOOKUP(F171,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E172=\"\",\"\",IF(E172=\"Foreign\",VLOOKUP(F172,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E173=\"\",\"\",IF(E173=\"Foreign\",VLOOKUP(F173,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E174=\"\",\"\",IF(E174=\"Foreign\",VLOOKUP(F174,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E175=\"\",\"\",IF(E175=\"Foreign\",VLOOKUP(F175,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E176=\"\",\"\",IF(E176=\"Foreign\",VLOOKUP(F176,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E177=\"\",\"\",IF(E177=\"Foreign\",VLOOKUP(F177,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E178=\"\",\"\",IF(E178=\"Foreign\",VLOOKUP(F178,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E179=\"\",\"\",IF(E179=\"Foreign\",VLOOKUP(F179,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E180=\"\",\"\",IF(E180=\"Foreign\",VLOOKUP(F180,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E181=\"\",\"\",IF(E181=\"Foreign\",VLOOKUP(F181,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E182=\"\",\"\",IF(E182=\"Foreign\",VLOOKUP(F182,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E183=\"\",\"\",IF(E183=\"Foreign\",VLOOKUP(F183,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[5,"Majuba Power Station (Bandwidth - 2mb/s) (Number of Calls - 24)",null,"sum","Local","ZAR",{"$f":"IF(E184=\"\",\"\",IF(E184=\"Foreign\",VLOOKUP(F184,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E185=\"\",\"\",IF(E185=\"Foreign\",VLOOKUP(F185,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E186=\"\",\"\",IF(E186=\"Foreign\",VLOOKUP(F186,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E187=\"\",\"\",IF(E187=\"Foreign\",VLOOKUP(F187,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E188=\"\",\"\",IF(E188=\"Foreign\",VLOOKUP(F188,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E189=\"\",\"\",IF(E189=\"Foreign\",VLOOKUP(F189,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E190=\"\",\"\",IF(E190=\"Foreign\",VLOOKUP(F190,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E191=\"\",\"\",IF(E191=\"Foreign\",VLOOKUP(F191,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum",{"$f":"IF(F192=\"\",\"\",IF(F192=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(E192=\"\",\"\",IF(E192=\"Foreign\",VLOOKUP(F192,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,{"$f":"J192*$G192","v":0},{"$f":"J192*$H192","v":0},{"$f":"K192*$H192","v":0},null,0,{"$f":"O192*$G192","v":0},{"$f":"O192*$H192","v":0},{"$f":"P192*$H192","v":0}]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E193=\"\",\"\",IF(E193=\"Foreign\",VLOOKUP(F193,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E194=\"\",\"\",IF(E194=\"Foreign\",VLOOKUP(F194,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E195=\"\",\"\",IF(E195=\"Foreign\",VLOOKUP(F195,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E196=\"\",\"\",IF(E196=\"Foreign\",VLOOKUP(F196,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E197=\"\",\"\",IF(E197=\"Foreign\",VLOOKUP(F197,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[6,"Lethabo Power Station (Bandwidth - 2mb/s) (Number of Calls - 24)",null,"sum","Local","ZAR",{"$f":"IF(E198=\"\",\"\",IF(E198=\"Foreign\",VLOOKUP(F198,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E199=\"\",\"\",IF(E199=\"Foreign\",VLOOKUP(F199,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E200=\"\",\"\",IF(E200=\"Foreign\",VLOOKUP(F200,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E201=\"\",\"\",IF(E201=\"Foreign\",VLOOKUP(F201,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E202=\"\",\"\",IF(E202=\"Foreign\",VLOOKUP(F202,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E203=\"\",\"\",IF(E203=\"Foreign\",VLOOKUP(F203,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E204=\"\",\"\",IF(E204=\"Foreign\",VLOOKUP(F204,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E205=\"\",\"\",IF(E205=\"Foreign\",VLOOKUP(F205,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E206=\"\",\"\",IF(E206=\"Foreign\",VLOOKUP(F206,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E207=\"\",\"\",IF(E207=\"Foreign\",VLOOKUP(F207,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E208=\"\",\"\",IF(E208=\"Foreign\",VLOOKUP(F208,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E209=\"\",\"\",IF(E209=\"Foreign\",VLOOKUP(F209,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E210=\"\",\"\",IF(E210=\"Foreign\",VLOOKUP(F210,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E211=\"\",\"\",IF(E211=\"Foreign\",VLOOKUP(F211,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[7,"Kusile Power Station (Bandwidth - 2mb/s) (Number of Calls - 24)",null,"sum","Local","ZAR",{"$f":"IF(E212=\"\",\"\",IF(E212=\"Foreign\",VLOOKUP(F212,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E213=\"\",\"\",IF(E213=\"Foreign\",VLOOKUP(F213,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E214=\"\",\"\",IF(E214=\"Foreign\",VLOOKUP(F214,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E215=\"\",\"\",IF(E215=\"Foreign\",VLOOKUP(F215,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E216=\"\",\"\",IF(E216=\"Foreign\",VLOOKUP(F216,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E217=\"\",\"\",IF(E217=\"Foreign\",VLOOKUP(F217,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E218=\"\",\"\",IF(E218=\"Foreign\",VLOOKUP(F218,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E219=\"\",\"\",IF(E219=\"Foreign\",VLOOKUP(F219,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E220=\"\",\"\",IF(E220=\"Foreign\",VLOOKUP(F220,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E221=\"\",\"\",IF(E221=\"Foreign\",VLOOKUP(F221,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E222=\"\",\"\",IF(E222=\"Foreign\",VLOOKUP(F222,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E223=\"\",\"\",IF(E223=\"Foreign\",VLOOKUP(F223,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E224=\"\",\"\",IF(E224=\"Foreign\",VLOOKUP(F224,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E225=\"\",\"\",IF(E225=\"Foreign\",VLOOKUP(F225,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[8,"Kriel Power Station (Bandwidth - 2mb/s) (Number of Calls - 24)",null,"sum","Local","ZAR",{"$f":"IF(E226=\"\",\"\",IF(E226=\"Foreign\",VLOOKUP(F226,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E227=\"\",\"\",IF(E227=\"Foreign\",VLOOKUP(F227,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E228=\"\",\"\",IF(E228=\"Foreign\",VLOOKUP(F228,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E229=\"\",\"\",IF(E229=\"Foreign\",VLOOKUP(F229,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E230=\"\",\"\",IF(E230=\"Foreign\",VLOOKUP(F230,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E231=\"\",\"\",IF(E231=\"Foreign\",VLOOKUP(F231,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E232=\"\",\"\",IF(E232=\"Foreign\",VLOOKUP(F232,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E233=\"\",\"\",IF(E233=\"Foreign\",VLOOKUP(F233,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E234=\"\",\"\",IF(E234=\"Foreign\",VLOOKUP(F234,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E235=\"\",\"\",IF(E235=\"Foreign\",VLOOKUP(F235,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E236=\"\",\"\",IF(E236=\"Foreign\",VLOOKUP(F236,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E237=\"\",\"\",IF(E237=\"Foreign\",VLOOKUP(F237,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E238=\"\",\"\",IF(E238=\"Foreign\",VLOOKUP(F238,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E239=\"\",\"\",IF(E239=\"Foreign\",VLOOKUP(F239,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[9,"Komati Power Station (Bandwidth - 2mb/s) (Number of Calls - 24)",null,"sum",{"$f":"IF(F240=\"\",\"\",IF(F240=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(E240=\"\",\"\",IF(E240=\"Foreign\",VLOOKUP(F240,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,{"$f":"J240*$G240","v":0},{"$f":"J240*$H240","v":0},{"$f":"K240*$H240","v":0},null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E241=\"\",\"\",IF(E241=\"Foreign\",VLOOKUP(F241,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E242=\"\",\"\",IF(E242=\"Foreign\",VLOOKUP(F242,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E243=\"\",\"\",IF(E243=\"Foreign\",VLOOKUP(F243,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E244=\"\",\"\",IF(E244=\"Foreign\",VLOOKUP(F244,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E245=\"\",\"\",IF(E245=\"Foreign\",VLOOKUP(F245,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E246=\"\",\"\",IF(E246=\"Foreign\",VLOOKUP(F246,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E247=\"\",\"\",IF(E247=\"Foreign\",VLOOKUP(F247,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E248=\"\",\"\",IF(E248=\"Foreign\",VLOOKUP(F248,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E249=\"\",\"\",IF(E249=\"Foreign\",VLOOKUP(F249,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E250=\"\",\"\",IF(E250=\"Foreign\",VLOOKUP(F250,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E251=\"\",\"\",IF(E251=\"Foreign\",VLOOKUP(F251,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E252=\"\",\"\",IF(E252=\"Foreign\",VLOOKUP(F252,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E253=\"\",\"\",IF(E253=\"Foreign\",VLOOKUP(F253,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[10,"Kendal Power Station (Bandwidth - 2mb/s) (Number of Calls - 24)",null,"sum","Local","ZAR",{"$f":"IF(E254=\"\",\"\",IF(E254=\"Foreign\",VLOOKUP(F254,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E255=\"\",\"\",IF(E255=\"Foreign\",VLOOKUP(F255,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E256=\"\",\"\",IF(E256=\"Foreign\",VLOOKUP(F256,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,{"$f":"O256*$G256","v":0},{"$f":"O256*$H256","v":0},{"$f":"P256*$H256","v":0}]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E257=\"\",\"\",IF(E257=\"Foreign\",VLOOKUP(F257,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E258=\"\",\"\",IF(E258=\"Foreign\",VLOOKUP(F258,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E259=\"\",\"\",IF(E259=\"Foreign\",VLOOKUP(F259,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E260=\"\",\"\",IF(E260=\"Foreign\",VLOOKUP(F260,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E261=\"\",\"\",IF(E261=\"Foreign\",VLOOKUP(F261,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E262=\"\",\"\",IF(E262=\"Foreign\",VLOOKUP(F262,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E263=\"\",\"\",IF(E263=\"Foreign\",VLOOKUP(F263,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E264=\"\",\"\",IF(E264=\"Foreign\",VLOOKUP(F264,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E265=\"\",\"\",IF(E265=\"Foreign\",VLOOKUP(F265,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E266=\"\",\"\",IF(E266=\"Foreign\",VLOOKUP(F266,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E267=\"\",\"\",IF(E267=\"Foreign\",VLOOKUP(F267,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[11,"Hendrina Power Station (Bandwidth - 2mb/s) (Number of Calls - 24)",null,"sum","Local","ZAR",{"$f":"IF(E268=\"\",\"\",IF(E268=\"Foreign\",VLOOKUP(F268,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E269=\"\",\"\",IF(E269=\"Foreign\",VLOOKUP(F269,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E270=\"\",\"\",IF(E270=\"Foreign\",VLOOKUP(F270,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E271=\"\",\"\",IF(E271=\"Foreign\",VLOOKUP(F271,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E272=\"\",\"\",IF(E272=\"Foreign\",VLOOKUP(F272,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E273=\"\",\"\",IF(E273=\"Foreign\",VLOOKUP(F273,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E274=\"\",\"\",IF(E274=\"Foreign\",VLOOKUP(F274,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E275=\"\",\"\",IF(E275=\"Foreign\",VLOOKUP(F275,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E276=\"\",\"\",IF(E276=\"Foreign\",VLOOKUP(F276,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E277=\"\",\"\",IF(E277=\"Foreign\",VLOOKUP(F277,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E278=\"\",\"\",IF(E278=\"Foreign\",VLOOKUP(F278,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E279=\"\",\"\",IF(E279=\"Foreign\",VLOOKUP(F279,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E280=\"\",\"\",IF(E280=\"Foreign\",VLOOKUP(F280,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E281=\"\",\"\",IF(E281=\"Foreign\",VLOOKUP(F281,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[12,"Grootvlei Power Station (Bandwidth - 2mb/s) (Number of Calls - 24)",null,"sum","Local","ZAR",{"$f":"IF(E282=\"\",\"\",IF(E282=\"Foreign\",VLOOKUP(F282,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E283=\"\",\"\",IF(E283=\"Foreign\",VLOOKUP(F283,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E284=\"\",\"\",IF(E284=\"Foreign\",VLOOKUP(F284,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E285=\"\",\"\",IF(E285=\"Foreign\",VLOOKUP(F285,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E286=\"\",\"\",IF(E286=\"Foreign\",VLOOKUP(F286,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E287=\"\",\"\",IF(E287=\"Foreign\",VLOOKUP(F287,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E288=\"\",\"\",IF(E288=\"Foreign\",VLOOKUP(F288,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E289=\"\",\"\",IF(E289=\"Foreign\",VLOOKUP(F289,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E290=\"\",\"\",IF(E290=\"Foreign\",VLOOKUP(F290,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E291=\"\",\"\",IF(E291=\"Foreign\",VLOOKUP(F291,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E292=\"\",\"\",IF(E292=\"Foreign\",VLOOKUP(F292,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E293=\"\",\"\",IF(E293=\"Foreign\",VLOOKUP(F293,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E294=\"\",\"\",IF(E294=\"Foreign\",VLOOKUP(F294,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E295=\"\",\"\",IF(E295=\"Foreign\",VLOOKUP(F295,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[13,"Duvha Power Station (Bandwidth - 2mb/s) (Number of Calls - 24)",null,"sum","Local","ZAR",{"$f":"IF(E296=\"\",\"\",IF(E296=\"Foreign\",VLOOKUP(F296,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E297=\"\",\"\",IF(E297=\"Foreign\",VLOOKUP(F297,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E298=\"\",\"\",IF(E298=\"Foreign\",VLOOKUP(F298,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E299=\"\",\"\",IF(E299=\"Foreign\",VLOOKUP(F299,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E300=\"\",\"\",IF(E300=\"Foreign\",VLOOKUP(F300,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E301=\"\",\"\",IF(E301=\"Foreign\",VLOOKUP(F301,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E302=\"\",\"\",IF(E302=\"Foreign\",VLOOKUP(F302,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E303=\"\",\"\",IF(E303=\"Foreign\",VLOOKUP(F303,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum",{"$f":"IF(F304=\"\",\"\",IF(F304=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(E304=\"\",\"\",IF(E304=\"Foreign\",VLOOKUP(F304,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,{"$f":"J304*$G304","v":0},{"$f":"J304*$H304","v":0},{"$f":"K304*$H304","v":0},null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E305=\"\",\"\",IF(E305=\"Foreign\",VLOOKUP(F305,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E306=\"\",\"\",IF(E306=\"Foreign\",VLOOKUP(F306,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E307=\"\",\"\",IF(E307=\"Foreign\",VLOOKUP(F307,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E308=\"\",\"\",IF(E308=\"Foreign\",VLOOKUP(F308,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E309=\"\",\"\",IF(E309=\"Foreign\",VLOOKUP(F309,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[14,"Camden Power Station (Bandwidth - 2mb/s) (Number of Calls - 24)",null,"sum","Local","ZAR",{"$f":"IF(E310=\"\",\"\",IF(E310=\"Foreign\",VLOOKUP(F310,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E311=\"\",\"\",IF(E311=\"Foreign\",VLOOKUP(F311,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E312=\"\",\"\",IF(E312=\"Foreign\",VLOOKUP(F312,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E313=\"\",\"\",IF(E313=\"Foreign\",VLOOKUP(F313,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E314=\"\",\"\",IF(E314=\"Foreign\",VLOOKUP(F314,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E315=\"\",\"\",IF(E315=\"Foreign\",VLOOKUP(F315,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E316=\"\",\"\",IF(E316=\"Foreign\",VLOOKUP(F316,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E317=\"\",\"\",IF(E317=\"Foreign\",VLOOKUP(F317,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum",{"$f":"IF(F318=\"\",\"\",IF(F318=\"ZAR\",\"Local\",\"Foreign\"))","v":"Local"},"ZAR",{"$f":"IF(E318=\"\",\"\",IF(E318=\"Foreign\",VLOOKUP(F318,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,{"$f":"J318*$G318","v":0},{"$f":"J318*$H318","v":0},{"$f":"K318*$H318","v":0},null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E319=\"\",\"\",IF(E319=\"Foreign\",VLOOKUP(F319,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E320=\"\",\"\",IF(E320=\"Foreign\",VLOOKUP(F320,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,{"$f":"O320*$G320","v":0},{"$f":"O320*$H320","v":0},{"$f":"P320*$H320","v":0}]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E321=\"\",\"\",IF(E321=\"Foreign\",VLOOKUP(F321,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E322=\"\",\"\",IF(E322=\"Foreign\",VLOOKUP(F322,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E323=\"\",\"\",IF(E323=\"Foreign\",VLOOKUP(F323,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[15,"Arnot Power Station (Bandwidth - 2mb/s) (Number of Calls - 24)",null,"sum","Local","ZAR",{"$f":"IF(E324=\"\",\"\",IF(E324=\"Foreign\",VLOOKUP(F324,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E325=\"\",\"\",IF(E325=\"Foreign\",VLOOKUP(F325,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E326=\"\",\"\",IF(E326=\"Foreign\",VLOOKUP(F326,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E327=\"\",\"\",IF(E327=\"Foreign\",VLOOKUP(F327,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E328=\"\",\"\",IF(E328=\"Foreign\",VLOOKUP(F328,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E329=\"\",\"\",IF(E329=\"Foreign\",VLOOKUP(F329,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E330=\"\",\"\",IF(E330=\"Foreign\",VLOOKUP(F330,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E331=\"\",\"\",IF(E331=\"Foreign\",VLOOKUP(F331,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E332=\"\",\"\",IF(E332=\"Foreign\",VLOOKUP(F332,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E333=\"\",\"\",IF(E333=\"Foreign\",VLOOKUP(F333,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E334=\"\",\"\",IF(E334=\"Foreign\",VLOOKUP(F334,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E335=\"\",\"\",IF(E335=\"Foreign\",VLOOKUP(F335,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E336=\"\",\"\",IF(E336=\"Foreign\",VLOOKUP(F336,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E337=\"\",\"\",IF(E337=\"Foreign\",VLOOKUP(F337,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[16,"Koeberg Power Station (Bandwidth - 2mb/s) (Number of Calls - 24)",null,"sum","Local","ZAR",{"$f":"IF(E338=\"\",\"\",IF(E338=\"Foreign\",VLOOKUP(F338,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E339=\"\",\"\",IF(E339=\"Foreign\",VLOOKUP(F339,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E340=\"\",\"\",IF(E340=\"Foreign\",VLOOKUP(F340,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E341=\"\",\"\",IF(E341=\"Foreign\",VLOOKUP(F341,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E342=\"\",\"\",IF(E342=\"Foreign\",VLOOKUP(F342,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E343=\"\",\"\",IF(E343=\"Foreign\",VLOOKUP(F343,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E344=\"\",\"\",IF(E344=\"Foreign\",VLOOKUP(F344,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E345=\"\",\"\",IF(E345=\"Foreign\",VLOOKUP(F345,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E346=\"\",\"\",IF(E346=\"Foreign\",VLOOKUP(F346,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E347=\"\",\"\",IF(E347=\"Foreign\",VLOOKUP(F347,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E348=\"\",\"\",IF(E348=\"Foreign\",VLOOKUP(F348,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E349=\"\",\"\",IF(E349=\"Foreign\",VLOOKUP(F349,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E350=\"\",\"\",IF(E350=\"Foreign\",VLOOKUP(F350,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":3},"sum","Local","ZAR",{"$f":"IF(E351=\"\",\"\",IF(E351=\"Foreign\",VLOOKUP(F351,Currency!$E$20:$F$33,2,FALSE),1))","v":{"v":1,"d":"1.00"}},1,null,0,0,0,0,null,0,0,0,0]
[{"$nulls":11},{"$f":"SUM(L128:L351)","v":0},{"$f":"SUM(M128:M351)","v":0},{"$nulls":3},{"$f":"SUM(Q128:Q351)","v":0},{"$f":"SUM(R128:R351)","v":0}]
[]
[]
[{"$nulls":11},{"$f":"SUM(L352,L121)","v":0},{"$f":"SUM(M352,M121)","v":0},{"$nulls":3},{"$f":"SUM(Q352,Q121)","v":0},{"$f":"SUM(R352,R121)","v":0}]

{"sheet":"Currency","index":2,"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":"'SIP Trunks'!B3","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"}]