{"text_format":"3","workbook":"xlsx","n_sheets":20,"sheets":["Main Menu","Control","General","Contextual","Input sheet","Basic Previously submitted data","Basic Output","Basic Output (USD)","Basic PPP Output","Advanced Input 1","Advanced Input 2","Advanced KPI output","Data Definitions","GBWG KPI Framework","Operational Performance KPIs","Previously submitted menu","Output menu","Financial Data - Inflation Rate","Financial Data - PPP","Financial Data - Exchange Rate"],"not_rendered":{"charts":6,"images":1,"macros":1,"external_links":3,"defined_names":51,"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Main Menu","index":0,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Control","index":1,"n_rows":32,"n_cols":11,"rows_kept":32,"merged":[[5,1,6,1],[5,3,6,3],[8,3,9,5],[11,3,12,5],[14,3,14,4],[24,3,24,4]]}
[]
[]
[]
[]
[]
[null,{"$f":"COUNTA(E16,E18,E22,E26,E30)/COUNTA(D16,D18,D22,D26,D30)","v":{"v":0.2,"d":"20%"}}]
[]
[]
[{"$nulls":3},"ANSP Control Sheet",{"$nulls":6},"Other (please comment)"]
[{"$nulls":10},"Jul 21 - Jun 22"]
[{"$nulls":10},"Aug 21 - Jul 22"]
[{"$nulls":3},"Provide key information about the ANSP. This sheet also contains any additional information that may be required to clarify the input as submitted. Please note that entries on this sheet will NOT automatically be included in the calculation of any final data submission values.",{"$nulls":6},"Sept 21 - Aug 22"]
[{"$nulls":10},"Oct 21 - Sept 22"]
[{"$nulls":10},"Nov 21 - Oct 22"]
[{"$nulls":3},"Submission characteristics",{"$nulls":6},"Dec 21 - Nov 22"]
[{"$nulls":3},"ANSP Name",{"$nulls":6},"Jan 22 - Dec 23"]
[{"$nulls":10},"Feb 22 - Jan 23"]
[{"$nulls":3},"Country",{"$nulls":6},"Mar 22 - Feb 23"]
[{"$nulls":10},"Apr 22 - Mar 23"]
[{"$nulls":3},"Current data year",2022,{"$nulls":5},"May 22 - Apr 23"]
[{"$nulls":10},"June 22 - May 23"]
[{"$nulls":3},"ANSP name for graphics",{"$nulls":6},"Apr 20 - Mar 21"]
[{"$nulls":10},"May 20 - Apr 21"]
[{"$nulls":10},"June 20 - May 21"]
[{"$nulls":3},"Additional information",null,"Comments ",{"$nulls":4},"Jul 20 - June 21"]
[{"$nulls":3},"Dates used for obtaining data","Other (please comment)"]
[]
[{"$nulls":3},"Methodology used for calculating “Average annual working hours”"]
[]
[{"$nulls":3},"Currency used to specify costs. (Local currency preferred)."]
[]
[{"$nulls":3},"Extraordinary/non-standard costs. List type of cost, year, and amount. e.g. significant capital expenses incurred in a given year or cost of providing flight services."]

{"sheet":"General","index":2,"n_rows":88,"n_cols":15,"rows_kept":88,"merged":[[8,2,10,7],[11,3,11,6],[24,2,25,2],[27,3,27,7],[29,3,29,7],[32,2,33,2],[48,2,48,3],[49,3,49,7],[51,3,51,7],[53,3,53,7],[55,3,55,7],[57,2,57,9],[61,2,62,2],[63,2,64,2],[68,2,68,9],[72,3,72,4],[72,5,72,9],[73,2,73,9],[76,2,76,9],[80,2,80,3],[81,3,81,4],[87,3,87,4]]}
[]
[]
[]
[]
[]
[]
[null,{"$f":"(COUNTA(D19,D50,D52,D54,D56,D73,D82,D88,D28,D30) + COUNTIF(B15:B88, \"Ticked\"))/COUNTA(C19,C50,C52,C54,C56,C59,C62,C67,C70,C73,C75,C78,C82,C84,C88,C25,C28,C30,C33,C36,C39,C42,C45)","v":{"v":0,"d":"0%"}}]
[]
[null,null,"ANSP general information"]
[{"$nulls":13},"Africa"]
[{"$nulls":13},"Asia Pacific"]
[{"$nulls":3},"This sheet contains general data questions that provide high level information about the ANSP.",{"$nulls":9},"Europe"]
[{"$nulls":13},"Latin America and Caribbean"]
[{"$nulls":13},"Middle East"]
[null,null,"Name"]
[]
[null,null,"Country"]
[]
[null,null,"Region"]
[]
[]
[null,null,"Information supporting report theme"]
[]
[]
[null,null,"Q1) How has your ANSP controlled costs in response to the drop in traffic during the pandemic? ","Redundancies / part-time working ","Renegotiation of key contracts","Reduced overtime ","Other opex cuts e.g. training and external advisory services ","Review or delay of CAPEX investments ","Other (please comment)","Comment"]
[null,{"$f":"IF(COUNTIF(D26:I26, TRUE)=0, \"No\", \"Ticked\")","v":"No"},null,false,false,false,false,false,false]
[]
[null,null,"a) What were the successes? "]
[]
[null,null,"b) What were the failures?"]
[]
[]
[null,null,"Q2) What local recovery measures have been put in place to help your ANSP recover lost income?","State loan","State grant","Alterations to ANS charging (e.g. increased unit rate) ","Other (please comment)","Comment"]
[null,{"$f":"IF(COUNTIF(D34:G34, TRUE)=0, \"No\", \"Ticked\")","v":"No"},null,false,false,false,false]
[]
[null,null,"Q3) How does your ANSP plan to improve cost scalability and resilience in light of the pandemic?","Performance based supplier contracts","Increased digitisation and digitalisation ","Revised organisation design e.g. review performance management, eliminate/relocate low-added value activities ","Other (please comment) ","Comment "]
[null,{"$f":"IF(COUNTIF(D37:G37, TRUE)=0, \"No\", \"Ticked\")","v":"No"},null,false,false,false,false]
[]
[null,null,"a) What percentage of total costs does your ANSP plan to make scalable in the future? ","0 - 10%","10 - 20%","20 - 30%",">30%","Not applicable "]
[null,{"$f":"IF(COUNTIF(D40:H40, TRUE)=0, \"No\", \"Ticked\")","v":"No"},null,false,false,false,false,false]
[]
[null,null,"Q4) What has been the effect of the pandemic on your ANSP's CAPEX programme?","Complete stop","Postponement of new projects","Repriortisaton of programme","Continuation as normal ","Other (please comment) ","Comment"]
[null,{"$f":"IF(COUNTIF(D43:H43, TRUE)=0, \"No\", \"Ticked\")","v":"No"},null,false,false,false,false,false]
[]
[null,null,"Q5) When do you foresee traffic  returning to 2019 levels in your country?","2021-2022","2023-2024","2025-2026","2027 and beyond","Please comment any additional information related to the traffic forecast. "]
[null,{"$f":"IF(COUNTIF(D46:G46, TRUE)=0, \"No\", \"Ticked\")","v":"No"},null,false,false,false,false]
[]
[]
[null,null,"Drivers/issues for ANSP performance "]
[null,null,"Does your ANSP have stated objectives? If so, what are they?"]
[]
[null,null,"In your opinion what are the main drivers or issues for performance within your region?"]
[]
[null,null,"What are the main iniatives you are undertaking to improve your performance?"]
[]
[null,null,"Were there any factors that impacted your individual ANSP performance in your fiscal year 2022, as shown in the KPIs in this report? For example, exceptional events in the year related to traffic",{"$nulls":10},0]
[]
[null,null,"Setup and governance"]
[null,null,"What is the legal status of the ANSP? "," A government department or authority that is subject to government accounting and treasury rules, and staff are employed under civil service pay and conditions?","A government entity empowered to manage and use the revenues it generates through charges for the services it provides? ","A corporatised entity wholly owned by the government with special status (not governed by normal commercial law but by a specific founding law or statute)?","A company established as a public-private partnership that remains part-owned by the government and provides services on behalf of the government? "," A private sector company that has no government ownership and provides services on behalf of the government either by statute or contract?"," Other (please comment)","Comment",{"$nulls":4},"Yes "]
[null,{"$f":"IF(COUNTIF(D60:I60, TRUE)=0, \"No\", \"Ticked\")","v":"No"},"Please place a tick in the most appropriate box, or provide a comment if Other",false,false,false,false,false,{"$nulls":6},"No"]
[]
[null,null,"How would you categorise your budget accountability? ","State-owned, joint-stock company","State-owned enterprise","State-owned, limited liability company","State Body","Autonomous State enterprise"]
[null,{"$f":"IF(COUNTIF(D63:H63:D65:I65, TRUE)=0, \"No\", \"Ticked\")","v":"No"},null,false,false,false,false,false]
[null,null,"Please place a tick in the most appropriate box, or provide a comment if Other. (For explanation of budget accountability categories please see defintions page). \n\n","State body (autonomous budget)","Independent administrative body","International organisation","Limited liability company","Joint-stock company (part-private)","Other  (please comment)","Comment"]
[null,{"$f":"IF(COUNTIF(D65:I65, TRUE)=0, \"No\", \"Ticked\")","v":"No"},null,false,false,false,false,false,false]
[]
[null,null,"How is the ANSP remunerated in respect to each revenue source? ","State budget allocation, based on e.g. passenger ticket tax or other tax revenues","Contractual payment from the state","Contractual payment from another ANSP"," En route or overflight charges","Terminal charges","Payment from airports","Other and Comment"]
[null,{"$f":"IF(COUNTA(D68:J68)>0, \"Ticked\", \"No\")","v":"No"},"Please reply with the % share for each revenue source, or provide a comment if Other"]
[]
[null,null,"If there is a mechanism to recover charges can you please comment on the nature of the arrangement?","Full cost recovery","Regulatory price cap (for those in SES performance scheme)","Negotiation with airspace users","Competition commission"," Other (please comment)","Comment"]
[null,{"$f":"IF(COUNTIF(D71:H71, TRUE)=0, \"No\", \"Ticked\")","v":"No"},"Please place a tick in the most appropriate box, or provide a comment if Other",false,false,false,false,false]
[]
[null,null,"Is your performance subject to regulatory oversight? (Yes or No)"]
[]
[null,null,"Is your performance subject to specific targets in any of the following areas?","Economic (efficiency or charging)","Capacity","Safety","Environment"," Other (please comment)","Comment"]
[null,{"$f":"IF(COUNTIF(D76:H76, TRUE)=0, \"No\", \"Ticked\")","v":"No"},"Please place a tick in the most appropriate box, or provide a comment if Other",null,null,false,false,false]
[]
[null,null,"If you are subject to any regulation, what is your relation to the regulator? ","No separation","Functional separation (i.e. same organisation, but different divisions or departments)","Organisational separation"," Other (please comment)","Comment"]
[null,{"$f":"IF(COUNTIF(D79:G79, TRUE)=0, \"No\", \"Ticked\")","v":"No"},"Please place a tick in the most appropriate box, or provide a comment if Other",null,null,false,false]
[]
[null,null,"Consultation"]
[null,null,"Do you run a consultation process with your customers on charges?"]
[]
[null,null,"If yes then how often is this done?","More frequent that quarterly","Quarterly or three times a year","Twice a year","Annual to once in two years","Less frequently than once in two years","Ad hoc"," Other (please comment)","Comment"]
[null,{"$f":"IF(COUNTIF(D85:J85, TRUE)=0, \"No\", \"Ticked\")","v":"No"},"Please place a tick in the most appropriate box, or provide a comment if Other",false,false,null,false,false,false,false]
[]
[null,null,"Use of the report"]
[null,null,"How does your ANSP make use of this report, and the associated submission process?"]

{"sheet":"Contextual","index":3,"n_rows":31,"n_cols":8,"rows_kept":31,"merged":[[8,3,10,7],[11,3,12,7]]}
[]
[]
[]
[]
[]
[null,{"$f":"COUNTA(F17,F18,F19:F22,F23,F26,F27,F29,F28,F30,F31)/COUNTA(E17,E18,E19:E22,E23,E26,E27,E28,E29,E30,E31)","v":{"v":0,"d":"0%"}}]
[null,{"$f":"COUNTA(G17,G18,G19:G22,G23,G26,G27,G29,G28,G30,G31)/COUNTA(E18,E19:E22,E23,E17,E27,E28,E29,E30,E31,E26)","v":{"v":0,"d":"0%"}}]
[]
[{"$nulls":3},"ANSP contextual information"]
[]
[]
[{"$nulls":3},"This sheet contains contextual data that provides fundamental information about the characteristics of the ANSP that will be useful during any comparison process. Please click on each metric for further definition."]
[]
[]
[]
[{"$nulls":4},"Operational data","Continental","Oceanic","Comments"]
[{"$nulls":3},{"$f":"+D16+1","v":1},"Sq. km. – oceanic and continental"]
[{"$nulls":3},2.1,"Percentage surveillance coverage at 30,000ft - primary radar"]
[{"$nulls":3},2.2,"Percentage surveillance coverage at 30,000ft - secondary radar"]
[{"$nulls":3},2.3,"Percentage surveillance coverage at 30,000ft - ADS-B"]
[{"$nulls":3},2.4,"Percentage surveillance coverage at 30,000ft - Space based ADS-B"]
[{"$nulls":3},2.5,"Percentage surveillance coverage at 30,000ft - ADS-C"]
[{"$nulls":3},3,"Number of FIRs"]
[]
[{"$nulls":4},"Facilities","Continental","Oceanic","Comments"]
[{"$nulls":3},4,"Number of ACC facilities"]
[{"$nulls":3},5,"Number of co-located ACC and approach facilities"]
[{"$nulls":3},6,"Number of stand-alone approach facilities"]
[{"$nulls":3},7,"Number of co-located approach and tower facilities"]
[{"$nulls":3},8,"Number of stand-alone towers"]
[{"$nulls":3},9,"Number of co-located ACC, approach and tower facilities"]

{"sheet":"Input sheet","index":4,"n_rows":66,"n_cols":30,"rows_kept":66,"merged":[[0,14,1048575,28],[8,4,10,9],[11,4,12,9],[30,7,32,8],[49,4,49,9]]}
[]
[]
[]
[]
[null,{"$f":"COUNTA(F16:F20,F22:F28,F37)/COUNTA(E16:E20,E22:E28,E37)","v":0}]
[null,{"$f":"COUNTA(G16:G20,G22:G23,G26:G28,G37)/COUNTA(E16:E20,E22:E23, E26:E28,E37)","v":0}]
[]
[]
[{"$nulls":4},"ANSP Input Sheet"]
[]
[]
[{"$nulls":4},"This is the sheet for input of the data that contributes to the KPIs that appear in the annual report. It also contains definitions for the data fields to aid data submission, please view these by clicking on the 'Definitions' button. Please enter data for the 2022 period, as specified in the 'Control' sheet."]
[]
[]
[{"$nulls":4},"Data","Continental","Oceanic ",{"$nulls":22},"Time recording system"]
[{"$nulls":4},"Total costs",{"$nulls":24},"Roster plan"]
[{"$nulls":4},"Total IFR flight hours",{"$nulls":24},"Contractual working hours + overtime - leave"]
[{"$nulls":4},"Total ATCO in operations hours",{"$nulls":24},"Please select"]
[{"$nulls":4},"Total ATCO in operations overtime hours"]
[{"$nulls":4},"Total employment cost for ATCOs in operations"]
[{"$nulls":4},"Total costs without employment cost for ATCOs in operations",{"$f":"F16-F20","v":0},{"$f":"G16-G20","v":0}]
[{"$nulls":4},"Number of ATCOs in operations (expressed in FTE)"]
[{"$nulls":4},"Total ANS Revenue"]
[{"$nulls":4},"Example price per 1000 km flight for A320"]
[{"$nulls":4},"Example consolidated price per 250 km flight for ATR72"]
[{"$nulls":4},"Number of Frontline Service Support Staff (expressed in FTE)"]
[{"$nulls":4},"Total ATCO in operations hours allocated to en-route"]
[{"$nulls":4},"Total en-route IFR flight hours"]
[]
[]
[{"$nulls":4},"Additional Input Data Information",null,"Comment:"]
[{"$nulls":4},"Does your IFR flight hours submission truly reflect the time from wheels-up to wheels-down, as per the definition? (Tick for yes) (If no, please comment)",false]
[{"$nulls":4},"Does your ANSP provide Surface Control Movement or other airport services (e.g. MET)? (Tick for yes) (If yes, please specify)"]
[{"$nulls":4},"Methodology used for calculating “Average annual working hours”. (Please, select from the drop-down list)","Please select"]
[{"$nulls":4},"Extraordinary/non-standard costs (e.g. significant capital expenses incurred in a given year or cost of providing flight services). If yes, provide the amount; and in comments section, describe type of cost, year or other details."]
[{"$nulls":5},"Continental (2022)","Oceanic (2022)"]
[{"$nulls":4},"Number of ATCOs in operations (expressed in actual headcount, not FTE)"]
[]
[]
[]
[]
[]
[]
[{"$nulls":4},"Financial information",2022]
[{"$nulls":4},"Exchange rate (national currency/USD)"]
[{"$nulls":5},{"$f":"Control!$E$20-4","v":2018},{"$f":"Control!$E$20-3","v":2019},{"$f":"Control!$E$20-2","v":2020},{"$f":"Control!$E$20-1","v":2021},{"$f":"Control!$E$20","v":2022}]
[{"$nulls":4},"PPP (national currency / USD)"]
[{"$nulls":4},"Inflation rate (%)"]
[]
[{"$nulls":4},"You have reached the end of the Basic Workbook, please select an option below"]
{"$rows_empty":15}
[{"$nulls":3},false]

{"sheet":"Basic Previously submitted data","index":5,"n_rows":42,"n_cols":9,"rows_kept":42,"merged":[[5,1,6,1],[5,4,9,7],[12,4,12,8],[43,9,45,9]]}
[]
[]
[]
[]
[]
[{"$nulls":4},"ANSP Previously Submitted Data"]
[]
[]
[]
[]
[]
[]
[{"$nulls":4},"This sheet contains the input data that was previously submitted by your ANSP. The data on this page can be edited for each previous year. If you would like to edit the 2022 data please do so in the 'Input' sheet."]
[]
[{"$nulls":3},"Continental",{"$f":"Control!$E$20-4","v":2018},{"$f":"Control!$E$20-3","v":2019},{"$f":"Control!$E$20-2","v":2020},{"$f":"Control!$E$20-1","v":2021},{"$f":"Control!$E$20","v":2022}]
[{"$nulls":3},"Total Costs",{"$nulls":4},{"$f":"'Input sheet'!F16","v":0}]
[{"$nulls":3},"Total IFR flight hours",{"$nulls":4},{"$f":"'Input sheet'!F17","v":0}]
[{"$nulls":3},"Total ATCO in operations hours",{"$nulls":4},{"$f":"'Input sheet'!F18","v":0}]
[{"$nulls":3},"Total ATCO in operations overtime hours",{"$nulls":4},{"$f":"'Input sheet'!F19","v":0}]
[{"$nulls":3},"Total employment cost for ATCOs in operations",{"$nulls":4},{"$f":"'Input sheet'!F20","v":0}]
[{"$nulls":3},"Other costs",{"$nulls":4},{"$f":"'Input sheet'!F21","v":0}]
[{"$nulls":3},"Number of ATCOs in operations (expressed in FTE)",{"$nulls":4},{"$f":"'Input sheet'!F22","v":0}]
[{"$nulls":3},"Total ANS Revenue",{"$nulls":4},{"$f":"'Input sheet'!F23","v":0}]
[{"$nulls":3},"Example price per 1000 km flight for A320",{"$nulls":4},{"$f":"'Input sheet'!F24","v":0}]
[{"$nulls":3},"Example consolidated price per 250 km flight for ATR72",{"$nulls":4},{"$f":"'Input sheet'!F25","v":0}]
[{"$nulls":3},"Number of Frontline Service Support Staff (expressed in FTE)",{"$nulls":4},{"$f":"'Input sheet'!F26","v":0}]
[{"$nulls":3},"Total ATCO in operations hours allocated to en-route",{"$nulls":4},{"$f":"'Input sheet'!F27","v":0}]
[{"$nulls":3},"En-route IFR flight hours",{"$nulls":4},{"$f":"'Input sheet'!F28","v":0}]
[]
[]
[{"$nulls":3},"Oceanic",{"$f":"Control!$E$20-4","v":2018},{"$f":"Control!$E$20-3","v":2019},{"$f":"Control!$E$20-2","v":2020},{"$f":"Control!$E$20-1","v":2021},{"$f":"Control!$E$20","v":2022}]
[{"$nulls":3},"Total Costs",{"$nulls":4},{"$f":"'Input sheet'!G16","v":0}]
[{"$nulls":3},"Total IFR flight hours",{"$nulls":4},{"$f":"'Input sheet'!G17","v":0}]
[{"$nulls":3},"Total ATCO in operations hours",{"$nulls":4},{"$f":"'Input sheet'!G18","v":0}]
[{"$nulls":3},"Total ATCO in operations overtime hours",{"$nulls":4},{"$f":"'Input sheet'!G19","v":0}]
[{"$nulls":3},"Total employment cost for ATCOs in operations",{"$nulls":4},{"$f":"'Input sheet'!G20","v":0}]
[{"$nulls":3},"Other costs",{"$nulls":4},{"$f":"'Input sheet'!G21","v":0}]
[{"$nulls":3},"Number of ATCOs in operations (expressed in FTE)",{"$nulls":4},{"$f":"'Input sheet'!G22","v":0}]
[{"$nulls":3},"Total ANS Revenue",{"$nulls":4},{"$f":"'Input sheet'!G23","v":0}]
[{"$nulls":3},"Number of Frontline Service Support Staff (expressed in FTE)",{"$nulls":4},{"$f":"'Input sheet'!G26","v":0}]
[{"$nulls":3},"Total ATCO in operations hours allocated to en-route",{"$nulls":4},{"$f":"'Input sheet'!G27","v":0}]
[{"$nulls":3},"En-route IFR flight hours",{"$nulls":4},{"$f":"'Input sheet'!G28","v":0}]

{"sheet":"Basic Output","index":6,"n_rows":128,"n_cols":12,"rows_kept":128,"merged":[[3,3,4,9],[6,3,7,9],[25,5,25,8],[26,5,26,8]]}
[]
[]
[]
[{"$nulls":3},"Output sheet "]
[]
[]
[{"$nulls":3},"This sheet shows the key performance indicators (KPIs) and respective input data in local currency for the ANSP for this year and years previous. Please scroll to Continental, Oceanic and Combined outputs."]
[]
[]
[]
[]
[{"$nulls":5},"Exchange rate"]
[{"$nulls":5},2019,2016,2017,2018,2019]
[{"$nulls":5},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"}]
[{"$nulls":5},"To edit financial information please return to the 'Input' sheet."]
[{"$nulls":5},"Inflation rates"]
[null,null,"Apply Inflation adjustment",null,null,{"$f":"Control!$E$20-4","v":2018},{"$f":"Control!$E$20-3","v":2019},{"$f":"Control!$E$20-2","v":2020},{"$f":"Control!$E$20-1","v":2021},{"$f":"Control!$E$20","v":2022}]
[{"$nulls":5},{"$f":"'Input sheet'!F48","v":{"v":0,"d":"0.00"}},{"$f":"'Input sheet'!G48","v":{"v":0,"d":"0.00"}},{"$f":"'Input sheet'!H48","v":{"v":0,"d":"0.00"}},{"$f":"'Input sheet'!I48","v":{"v":0,"d":"0.00"}},{"$f":"'Input sheet'!J48","v":{"v":0,"d":"0.00"}}]
[null,null,false]
[]
[{"$nulls":5},{"$f":"IF($C$19=TRUE, 1/(F14*F22), 1/F14)","v":{"v":1,"d":"1.00"}},{"$f":"IF($C$19=TRUE, 1/(G14*G22), 1/G14)","v":{"v":1,"d":"1.00"}},{"$f":"IF($C$19=TRUE, 1/(H14*H22), 1/H14)","v":{"v":1,"d":"1.00"}},{"$f":"IF($C$19=TRUE, 1/(I14*I22), 1/I14)","v":{"v":1,"d":"1.00"}},{"$f":"IF($C$19=TRUE, 1/(J14*J22), 1/J14)","v":{"v":1,"d":"1.00"}}]
[{"$nulls":4},"inlflation to apply",{"$f":"G22*(1+G18/100)","v":{"v":1,"d":"1.00"}},{"$f":"H22*(1+H18/100)","v":{"v":1,"d":"1.00"}},{"$f":"I22*(1+I18/100)","v":{"v":1,"d":"1.00"}},{"$f":"J22*(1+J18/100)","v":{"v":1,"d":"1.00"}},{"v":1,"d":"1.00"}]
[]
[]
[]
[]
[]
[null,null,"KPIs",null,null,{"$f":"Control!$E$20-4","v":2018},{"$f":"Control!$E$20-3","v":2019},{"$f":"Control!$E$20-2","v":2020},{"$f":"Control!$E$20-1","v":2021},{"$f":"Control!$E$20","v":2022},"2021-2022 AGR","2018-2022 CAGR"]
[null,null,"1 Unit cost",null,null,{"$f":"F30/F31","v":{"$error":"#DIV/0!"}},{"$f":"G30/G31","v":{"$error":"#DIV/0!"}},{"$f":"H30/H31","v":{"$error":"#DIV/0!"}},{"$f":"I30/I31","v":{"$error":"#DIV/0!"}},{"$f":"J30/J31","v":{"$error":"#DIV/0!"}},{"$f":"J29/I29 -1","v":{"$error":"#DIV/0!"}},{"$f":"(J29/F29)^(1/4) -1","v":{"$error":"#DIV/0!"}}]
[{"$nulls":4},"Total Costs",{"$f":"IFERROR('Basic Previously submitted data'!E16/F21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!F16/G21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!G16/H21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!H16/I21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!I16/J21,\"-      \")","v":0},{"$f":"J30/I30 -1","v":{"$error":"#DIV/0!"}},{"$f":"(J30/F30)^(1/4) -1","v":{"$error":"#DIV/0!"}}]
[{"$nulls":4},"IFR flight hours",{"$f":"'Basic Previously submitted data'!E17","v":0},{"$f":"'Basic Previously submitted data'!F17","v":0},{"$f":"'Basic Previously submitted data'!G17","v":0},{"$f":"'Basic Previously submitted data'!H17","v":0},{"$f":"'Basic Previously submitted data'!I17","v":0},{"$f":"J31/I31 -1","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,"2A ATCO employment costs",null,null,{"$f":"F33/F34","v":{"$error":"#DIV/0!"}},{"$f":"G33/G34","v":{"$error":"#DIV/0!"}},{"$f":"H33/H34","v":{"$error":"#DIV/0!"}},{"$f":"I33/I34","v":{"$error":"#DIV/0!"}},{"$f":"J33/J34","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"ATCO employment cost",{"$f":"IFERROR('Basic Previously submitted data'!E20/F21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!F20/G21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!G20/H21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!H20/I21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!I20/J21,\"-      \")","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"ATCO hours",{"$f":"'Basic Previously submitted data'!E18","v":0},{"$f":"'Basic Previously submitted data'!F18","v":0},{"$f":"'Basic Previously submitted data'!G18","v":0},{"$f":"'Basic Previously submitted data'!H18","v":0},{"$f":"'Basic Previously submitted data'!I18","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"2B ATCO productivity",null,null,{"$f":"F36/F37","v":{"$error":"#DIV/0!"}},{"$f":"G36/G37","v":{"$error":"#DIV/0!"}},{"$f":"H36/H37","v":{"$error":"#DIV/0!"}},{"$f":"I36/I37","v":{"$error":"#DIV/0!"}},{"$f":"J36/J37","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"IFR flight hours",{"$f":"'Basic Previously submitted data'!E17","v":0},{"$f":"'Basic Previously submitted data'!F17","v":0},{"$f":"'Basic Previously submitted data'!G17","v":0},{"$f":"'Basic Previously submitted data'!H17","v":0},{"$f":"'Basic Previously submitted data'!I17","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"ATCO hours",{"$f":"'Basic Previously submitted data'!E18","v":0},{"$f":"'Basic Previously submitted data'!F18","v":0},{"$f":"'Basic Previously submitted data'!G18","v":0},{"$f":"'Basic Previously submitted data'!H18","v":0},{"$f":"'Basic Previously submitted data'!I18","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"2C Other costs per IFR flight hour",null,null,{"$f":"F39/F40","v":{"$error":"#DIV/0!"}},{"$f":"G39/G40","v":{"$error":"#DIV/0!"}},{"$f":"H39/H40","v":{"$error":"#DIV/0!"}},{"$f":"I39/I40","v":{"$error":"#DIV/0!"}},{"$f":"J39/J40","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"Other costs",{"$f":"IFERROR('Basic Previously submitted data'!E21/F21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!F21/G21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!G21/H21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!H21/I21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!I21/J21,\"-      \")","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"IFR flight hours",{"$f":"'Basic Previously submitted data'!E17","v":0},{"$f":"'Basic Previously submitted data'!F17","v":0},{"$f":"'Basic Previously submitted data'!G17","v":0},{"$f":"'Basic Previously submitted data'!H17","v":0},{"$f":"'Basic Previously submitted data'!I17","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"2D Proportion of total costs made up of ATCO",null,null,{"$f":"F42/F43","v":{"$error":"#DIV/0!"}},{"$f":"G42/G43","v":{"$error":"#DIV/0!"}},{"$f":"H42/H43","v":{"$error":"#DIV/0!"}},{"$f":"I42/I43","v":{"$error":"#DIV/0!"}},{"$f":"J42/J43","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"ATCO employment cost",{"$f":"IFERROR('Basic Previously submitted data'!E20/F21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!F20/G21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!G20/H21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!H20/I21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!I20/J21,\"-      \")","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"Total Costs",{"$f":"IFERROR('Basic Previously submitted data'!E16/F21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!F16/G21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!G16/H21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!H16/I21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!I16/J21,\"-      \")","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"3A Unit ATCO employment costs",null,null,{"$f":"F45/F46","v":{"$error":"#DIV/0!"}},{"$f":"G45/G46","v":{"$error":"#DIV/0!"}},{"$f":"H45/H46","v":{"$error":"#DIV/0!"}},{"$f":"I45/I46","v":{"$error":"#DIV/0!"}},{"$f":"J45/J46","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"ATCO employment cost",{"$f":"IFERROR('Basic Previously submitted data'!E20/F21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!F20/G21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!G20/H21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!H20/I21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!I20/J21,\"-      \")","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"No. of ATCOs",{"$f":"'Basic Previously submitted data'!E22","v":0},{"$f":"'Basic Previously submitted data'!F22","v":0},{"$f":"'Basic Previously submitted data'!G22","v":0},{"$f":"'Basic Previously submitted data'!H22","v":0},{"$f":"'Basic Previously submitted data'!I22","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"3B Annual Working hours per ATCO in OPS",null,null,{"$f":"F48/F49","v":{"$error":"#DIV/0!"}},{"$f":"G48/G49","v":{"$error":"#DIV/0!"}},{"$f":"H48/H49","v":{"$error":"#DIV/0!"}},{"$f":"I48/I49","v":{"$error":"#DIV/0!"}},{"$f":"J48/J49","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"ATCO hours",{"$f":"'Basic Previously submitted data'!E18","v":0},{"$f":"'Basic Previously submitted data'!F18","v":0},{"$f":"'Basic Previously submitted data'!G18","v":0},{"$f":"'Basic Previously submitted data'!H18","v":0},{"$f":"'Basic Previously submitted data'!I18","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"No. of ATCOs",{"$f":"'Basic Previously submitted data'!E22","v":0},{"$f":"'Basic Previously submitted data'!F22","v":0},{"$f":"'Basic Previously submitted data'!G22","v":0},{"$f":"'Basic Previously submitted data'!H22","v":0},{"$f":"'Basic Previously submitted data'!I22","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"3C IFR hours per ATCO in OPS",null,null,{"$f":"F51/F52","v":{"$error":"#DIV/0!"}},{"$f":"G51/G52","v":{"$error":"#DIV/0!"}},{"$f":"H51/H52","v":{"$error":"#DIV/0!"}},{"$f":"I51/I52","v":{"$error":"#DIV/0!"}},{"$f":"J51/J52","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"IFR flight hours",{"$f":"'Basic Previously submitted data'!E17","v":0},{"$f":"'Basic Previously submitted data'!F17","v":0},{"$f":"'Basic Previously submitted data'!G17","v":0},{"$f":"'Basic Previously submitted data'!H17","v":0},{"$f":"'Basic Previously submitted data'!I17","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"No. of ATCOs",{"$f":"'Basic Previously submitted data'!E22","v":0},{"$f":"'Basic Previously submitted data'!F22","v":0},{"$f":"'Basic Previously submitted data'!G22","v":0},{"$f":"'Basic Previously submitted data'!H22","v":0},{"$f":"'Basic Previously submitted data'!I22","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"3D Ratio of frontline service staff to ATCO in OPS ",null,null,{"$f":"F54/F55","v":{"$error":"#DIV/0!"}},{"$f":"G54/G55","v":{"$error":"#DIV/0!"}},{"$f":"H54/H55","v":{"$error":"#DIV/0!"}},{"$f":"I54/I55","v":{"$error":"#DIV/0!"}},{"$f":"J54/J55","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"Frontline staff",{"$f":"'Basic Previously submitted data'!E26","v":0},{"$f":"'Basic Previously submitted data'!F26","v":0},{"$f":"'Basic Previously submitted data'!G26","v":0},{"$f":"'Basic Previously submitted data'!H26","v":0},{"$f":"'Basic Previously submitted data'!I26","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"No. of ATCOs",{"$f":"'Basic Previously submitted data'!E22","v":0},{"$f":"'Basic Previously submitted data'!F22","v":0},{"$f":"'Basic Previously submitted data'!G22","v":0},{"$f":"'Basic Previously submitted data'!H22","v":0},{"$f":"'Basic Previously submitted data'!I22","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"P1 ANS revenue per IFR flight hour",null,null,{"$f":"F57/F58","v":{"$error":"#DIV/0!"}},{"$f":"G57/G58","v":{"$error":"#DIV/0!"}},{"$f":"H57/H58","v":{"$error":"#DIV/0!"}},{"$f":"I57/I58","v":{"$error":"#DIV/0!"}},{"$f":"J57/J58","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"ANS Revenue",{"$f":"IFERROR('Basic Previously submitted data'!E23/F21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!F23/G21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!G23/H21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!H23/I21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!I23/J21,\"-      \")","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"IFR flight hours",{"$f":"'Basic Previously submitted data'!E17","v":0},{"$f":"'Basic Previously submitted data'!F17","v":0},{"$f":"'Basic Previously submitted data'!G17","v":0},{"$f":"'Basic Previously submitted data'!H17","v":0},{"$f":"'Basic Previously submitted data'!I17","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[null,null,"KPIs",null,null,{"$f":"Control!$E$20-4","v":2018},{"$f":"Control!$E$20-3","v":2019},{"$f":"Control!$E$20-2","v":2020},{"$f":"Control!$E$20-1","v":2021},{"$f":"Control!$E$20","v":2022},"2021-2022 AGR","2018-2022 CAGR"]
[null,null,"1 Unit cost",null,null,{"$f":"F65/F66","v":{"$error":"#DIV/0!"}},{"$f":"G65/G66","v":{"$error":"#DIV/0!"}},{"$f":"H65/H66","v":{"$error":"#DIV/0!"}},{"$f":"I65/I66","v":{"$error":"#DIV/0!"}},{"$f":"J65/J66","v":{"$error":"#DIV/0!"}},{"$f":"J64/I64 -1","v":{"$error":"#DIV/0!"}},{"$f":"(J64/F64)^(1/4) -1","v":{"$error":"#DIV/0!"}}]
[{"$nulls":4},"Total Costs",{"$f":"IFERROR('Basic Previously submitted data'!E32/F21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!F32/G21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!G32/H21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!H32/I21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!I32/J21,\"-      \")","v":0},{"$f":"J65/I65 -1","v":{"$error":"#DIV/0!"}},{"$f":"(J65/F65)^(1/4) -1","v":{"$error":"#DIV/0!"}}]
[{"$nulls":4},"IFR flight hours",{"$f":"'Basic Previously submitted data'!E33","v":0},{"$f":"'Basic Previously submitted data'!F33","v":0},{"$f":"'Basic Previously submitted data'!G33","v":0},{"$f":"'Basic Previously submitted data'!H33","v":0},{"$f":"'Basic Previously submitted data'!I33","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"2A ATCO employment costs",null,null,{"$f":"F68/F69","v":{"$error":"#DIV/0!"}},{"$f":"G68/G69","v":{"$error":"#DIV/0!"}},{"$f":"H68/H69","v":{"$error":"#DIV/0!"}},{"$f":"I68/I69","v":{"$error":"#DIV/0!"}},{"$f":"J68/J69","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"ATCO employment cost",{"$f":"IFERROR('Basic Previously submitted data'!E36/F21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!F36/G21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!G36/H21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!H36/I21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!I36/J21,\"-      \")","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"ATCO hours",{"$f":"'Basic Previously submitted data'!E34","v":0},{"$f":"'Basic Previously submitted data'!F34","v":0},{"$f":"'Basic Previously submitted data'!G34","v":0},{"$f":"'Basic Previously submitted data'!H34","v":0},{"$f":"'Basic Previously submitted data'!I34","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"2B ATCO productivity",null,null,{"$f":"F71/F72","v":{"$error":"#DIV/0!"}},{"$f":"G71/G72","v":{"$error":"#DIV/0!"}},{"$f":"H71/H72","v":{"$error":"#DIV/0!"}},{"$f":"I71/I72","v":{"$error":"#DIV/0!"}},{"$f":"J71/J72","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"IFR flight hours",{"$f":"'Basic Previously submitted data'!E33","v":0},{"$f":"'Basic Previously submitted data'!F33","v":0},{"$f":"'Basic Previously submitted data'!G33","v":0},{"$f":"'Basic Previously submitted data'!H33","v":0},{"$f":"'Basic Previously submitted data'!I33","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"ATCO hours",{"$f":"'Basic Previously submitted data'!E34","v":0},{"$f":"'Basic Previously submitted data'!F34","v":0},{"$f":"'Basic Previously submitted data'!G34","v":0},{"$f":"'Basic Previously submitted data'!H34","v":0},{"$f":"'Basic Previously submitted data'!I34","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"2C Other costs per IFR flight hour",null,null,{"$f":"F74/F75","v":{"$error":"#DIV/0!"}},{"$f":"G74/G75","v":{"$error":"#DIV/0!"}},{"$f":"H74/H75","v":{"$error":"#DIV/0!"}},{"$f":"I74/I75","v":{"$error":"#DIV/0!"}},{"$f":"J74/J75","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"Other costs",{"$f":"IFERROR('Basic Previously submitted data'!E37/F21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!F37/G21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!G37/H21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!H37/I21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!I37/J21,\"-      \")","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"IFR flight hours",{"$f":"'Basic Previously submitted data'!E33","v":0},{"$f":"'Basic Previously submitted data'!F33","v":0},{"$f":"'Basic Previously submitted data'!G33","v":0},{"$f":"'Basic Previously submitted data'!H33","v":0},{"$f":"'Basic Previously submitted data'!I33","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"2D Proportion of total costs made up of ATCO",null,null,{"$f":"F77/F78","v":{"$error":"#DIV/0!"}},{"$f":"G77/G78","v":{"$error":"#DIV/0!"}},{"$f":"H77/H78","v":{"$error":"#DIV/0!"}},{"$f":"I77/I78","v":{"$error":"#DIV/0!"}},{"$f":"J77/J78","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"ATCO employment cost",{"$f":"IFERROR('Basic Previously submitted data'!E36/F21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!F36/G21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!G36/H21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!H36/I21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!I36/J21,\"-      \")","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"Total Costs",{"$f":"IFERROR('Basic Previously submitted data'!E32/F21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!F32/G21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!G32/H21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!H32/I21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!I32/J21,\"-      \")","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"3A Unit ATCO employment costs",null,null,{"$f":"F80/F81","v":{"$error":"#DIV/0!"}},{"$f":"G80/G81","v":{"$error":"#DIV/0!"}},{"$f":"H80/H81","v":{"$error":"#DIV/0!"}},{"$f":"I80/I81","v":{"$error":"#DIV/0!"}},{"$f":"J80/J81","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"ATCO employment cost",{"$f":"IFERROR('Basic Previously submitted data'!E36/F21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!F36/G21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!G36/H21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!H36/I21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!I36/J21,\"-      \")","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"No. of ATCOs",{"$f":"'Basic Previously submitted data'!E38","v":0},{"$f":"'Basic Previously submitted data'!F38","v":0},{"$f":"'Basic Previously submitted data'!G38","v":0},{"$f":"'Basic Previously submitted data'!H38","v":0},{"$f":"'Basic Previously submitted data'!I38","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"3B Annual Working hours per ATCO in OPS",null,null,{"$f":"F83/F84","v":{"$error":"#DIV/0!"}},{"$f":"G83/G84","v":{"$error":"#DIV/0!"}},{"$f":"H83/H84","v":{"$error":"#DIV/0!"}},{"$f":"I83/I84","v":{"$error":"#DIV/0!"}},{"$f":"J83/J84","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"ATCO hours",{"$f":"'Basic Previously submitted data'!E34","v":0},{"$f":"'Basic Previously submitted data'!F34","v":0},{"$f":"'Basic Previously submitted data'!G34","v":0},{"$f":"'Basic Previously submitted data'!H34","v":0},{"$f":"'Basic Previously submitted data'!I34","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"No. of ATCOs",{"$f":"'Basic Previously submitted data'!E38","v":0},{"$f":"'Basic Previously submitted data'!F38","v":0},{"$f":"'Basic Previously submitted data'!G38","v":0},{"$f":"'Basic Previously submitted data'!H38","v":0},{"$f":"'Basic Previously submitted data'!I38","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"3C IFR hours per ATCO in OPS",null,null,{"$f":"F86/F87","v":{"$error":"#DIV/0!"}},{"$f":"G86/G87","v":{"$error":"#DIV/0!"}},{"$f":"H86/H87","v":{"$error":"#DIV/0!"}},{"$f":"I86/I87","v":{"$error":"#DIV/0!"}},{"$f":"J86/J87","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"IFR flight hours",{"$f":"'Basic Previously submitted data'!E33","v":0},{"$f":"'Basic Previously submitted data'!F33","v":0},{"$f":"'Basic Previously submitted data'!G33","v":0},{"$f":"'Basic Previously submitted data'!H33","v":0},{"$f":"'Basic Previously submitted data'!I33","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"No. of ATCOs",{"$f":"'Basic Previously submitted data'!E38","v":0},{"$f":"'Basic Previously submitted data'!F38","v":0},{"$f":"'Basic Previously submitted data'!G38","v":0},{"$f":"'Basic Previously submitted data'!H38","v":0},{"$f":"'Basic Previously submitted data'!I38","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"3D Ratio of frontline service staff to ATCO in OPS ",null,null,{"$f":"F89/F90","v":{"$error":"#DIV/0!"}},{"$f":"G89/G90","v":{"$error":"#DIV/0!"}},{"$f":"H89/H90","v":{"$error":"#DIV/0!"}},{"$f":"I89/I90","v":{"$error":"#DIV/0!"}},{"$f":"J89/J90","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"Frontline staff",{"$f":"'Basic Previously submitted data'!E40","v":0},{"$f":"'Basic Previously submitted data'!F40","v":0},{"$f":"'Basic Previously submitted data'!G40","v":0},{"$f":"'Basic Previously submitted data'!H40","v":0},{"$f":"'Basic Previously submitted data'!I40","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"No. of ATCOs",{"$f":"'Basic Previously submitted data'!E38","v":0},{"$f":"'Basic Previously submitted data'!F38","v":0},{"$f":"'Basic Previously submitted data'!G38","v":0},{"$f":"'Basic Previously submitted data'!H38","v":0},{"$f":"'Basic Previously submitted data'!I38","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"P1 ANS revenue per IFR flight hour",null,null,{"$f":"F92/F93","v":{"$error":"#DIV/0!"}},{"$f":"G92/G93","v":{"$error":"#DIV/0!"}},{"$f":"H92/H93","v":{"$error":"#DIV/0!"}},{"$f":"I92/I93","v":{"$error":"#DIV/0!"}},{"$f":"J92/J93","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"ANS Revenue",{"$f":"IFERROR('Basic Previously submitted data'!E39/F21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!F39/G21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!G39/H21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!H39/I21,\"-      \")","v":0},{"$f":"IFERROR('Basic Previously submitted data'!I39/J21,\"-      \")","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"IFR flight hours",{"$f":"'Basic Previously submitted data'!E33","v":0},{"$f":"'Basic Previously submitted data'!F33","v":0},{"$f":"'Basic Previously submitted data'!G33","v":0},{"$f":"'Basic Previously submitted data'!H33","v":0},{"$f":"'Basic Previously submitted data'!I33","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[null,null,"KPIs",null,null,{"$f":"Control!$E$20-4","v":2018},{"$f":"Control!$E$20-3","v":2019},{"$f":"Control!$E$20-2","v":2020},{"$f":"Control!$E$20-1","v":2021},{"$f":"Control!$E$20","v":2022},"2021-2022 AGR","2018-2022 CAGR"]
[null,null,"1 Unit cost",null,null,{"$f":"F100/F101","v":{"$error":"#DIV/0!"}},{"$f":"G100/G101","v":{"$error":"#DIV/0!"}},{"$f":"H100/H101","v":{"$error":"#DIV/0!"}},{"$f":"I100/I101","v":{"$error":"#DIV/0!"}},{"$f":"J100/J101","v":{"$error":"#DIV/0!"}},{"$f":"J99/I99 -1","v":{"$error":"#DIV/0!"}},{"$f":"(J99/F99)^(1/4) -1","v":{"$error":"#DIV/0!"}}]
[{"$nulls":4},"Total Costs",{"$f":"F30+F65","v":0},{"$f":"G30+G65","v":0},0,0,0,{"$f":"J100/I100 -1","v":{"$error":"#DIV/0!"}},{"$f":"(J100/F100)^(1/4) -1","v":{"$error":"#DIV/0!"}}]
[{"$nulls":4},"IFR flight hours",{"$f":"F31+F66","v":0},0,0,0,0,{"$error":"#DIV/0!"},{"$f":"(J101/F101)^(1/4) -1","v":{"$error":"#DIV/0!"}}]
[null,null,"2A ATCO employment costs",null,null,{"$f":"F103/F104","v":{"$error":"#DIV/0!"}},{"$f":"G103/G104","v":{"$error":"#DIV/0!"}},{"$f":"H103/H104","v":{"$error":"#DIV/0!"}},{"$f":"I103/I104","v":{"$error":"#DIV/0!"}},{"$f":"J103/J104","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"ATCO employment cost",{"$f":"F33+F68","v":0},0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"ATCO hours",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"2B ATCO productivity",null,null,{"$f":"F106/F107","v":{"$error":"#DIV/0!"}},{"$f":"G106/G107","v":{"$error":"#DIV/0!"}},{"$f":"H106/H107","v":{"$error":"#DIV/0!"}},{"$f":"I106/I107","v":{"$error":"#DIV/0!"}},{"$f":"J106/J107","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"IFR flight hours",{"$f":"F36+F71","v":0},0,{"$f":"H36+H71","v":0},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"ATCO hours",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"2C Other costs per IFR flight hour",null,null,{"$f":"F109/F110","v":{"$error":"#DIV/0!"}},{"$f":"G109/G110","v":{"$error":"#DIV/0!"}},{"$f":"H109/H110","v":{"$error":"#DIV/0!"}},{"$f":"I109/I110","v":{"$error":"#DIV/0!"}},{"$f":"J109/J110","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"Other costs",{"$f":"F39+F74","v":0},0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"IFR flight hours",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"2D Proportion of total costs made up of ATCO",null,null,{"$f":"F112/F113","v":{"$error":"#DIV/0!"}},{"$f":"G112/G113","v":{"$error":"#DIV/0!"}},{"$f":"H112/H113","v":{"$error":"#DIV/0!"}},{"$f":"I112/I113","v":{"$error":"#DIV/0!"}},{"$f":"J112/J113","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"ATCO employment cost",{"$f":"F42+F77","v":0},0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"Total Costs",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"3A Unit ATCO employment costs",null,null,{"$f":"F115/F116","v":{"$error":"#DIV/0!"}},{"$f":"G115/G116","v":{"$error":"#DIV/0!"}},{"$f":"H115/H116","v":{"$error":"#DIV/0!"}},{"$f":"I115/I116","v":{"$error":"#DIV/0!"}},{"$f":"J115/J116","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"ATCO employment cost",{"$f":"F45+F80","v":0},0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"No. of ATCOs",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"3B Annual Working hours per ATCO in OPS",null,null,{"$f":"F118/F119","v":{"$error":"#DIV/0!"}},{"$f":"G118/G119","v":{"$error":"#DIV/0!"}},{"$f":"H118/H119","v":{"$error":"#DIV/0!"}},{"$f":"I118/I119","v":{"$error":"#DIV/0!"}},{"$f":"J118/J119","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"ATCO hours",{"$f":"F48+F83","v":0},0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"No. of ATCOs",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"3C IFR hours per ATCO in OPS",null,null,{"$f":"F121/F122","v":{"$error":"#DIV/0!"}},{"$f":"G121/G122","v":{"$error":"#DIV/0!"}},{"$f":"H121/H122","v":{"$error":"#DIV/0!"}},{"$f":"I121/I122","v":{"$error":"#DIV/0!"}},{"$f":"J121/J122","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"IFR flight hours",{"$f":"F51+F86","v":0},0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"No. of ATCOs",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"3D Ratio of frontline service staff to ATCO in OPS ",null,null,{"$f":"F124/F125","v":{"$error":"#DIV/0!"}},{"$f":"G124/G125","v":{"$error":"#DIV/0!"}},{"$f":"H124/H125","v":{"$error":"#DIV/0!"}},{"$f":"I124/I125","v":{"$error":"#DIV/0!"}},{"$f":"J124/J125","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"Frontline staff",{"$f":"F54+F89","v":0},0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"No. of ATCOs",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"P1 ANS revenue per IFR flight hour",null,null,{"$f":"F127/F128","v":{"$error":"#DIV/0!"}},{"$f":"G127/G128","v":{"$error":"#DIV/0!"}},{"$f":"H127/H128","v":{"$error":"#DIV/0!"}},{"$f":"I127/I128","v":{"$error":"#DIV/0!"}},{"$f":"J127/J128","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"ANS Revenue",{"$f":"F57+F92","v":0},0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"IFR flight hours",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

{"sheet":"Basic Output (USD)","index":7,"n_rows":128,"n_cols":12,"rows_kept":128,"merged":[[3,3,4,9],[6,3,7,9],[25,5,25,8],[26,5,26,8]]}
[]
[]
[]
[{"$nulls":3},"Output sheet (USD)"]
[]
[]
[{"$nulls":3},"This sheet shows the key performance indicators (KPIs) and respective input data in USD for the ANSP for this year and years previous. Please scroll to Continental, Oceanic and Combined outputs."]
[]
[]
[]
[]
[{"$nulls":5},"To edit financial information please return to the 'Input' sheet."]
[{"$nulls":5},"Exchange rate"]
[null,null,"Apply Inflation adjustment",null,null,{"$f":"Control!E20","v":2022},2016,2017,2018,2019]
[{"$nulls":5},{"$f":"'Input sheet'!$F$45","v":{"v":0,"d":"0.00"}},{"$f":"'Input sheet'!$F$45","v":0},{"$f":"'Input sheet'!$F$45","v":0},{"$f":"'Input sheet'!$F$45","v":0},{"$f":"'Input sheet'!$F$45","v":0}]
[null,null,false,null,null,"Inflation rates"]
[{"$nulls":5},{"$f":"Control!$E$20-4","v":2018},{"$f":"Control!$E$20-3","v":2019},{"$f":"Control!$E$20-2","v":2020},{"$f":"Control!$E$20-1","v":2021},{"$f":"Control!$E$20","v":2022}]
[{"$nulls":5},{"$f":"'Input sheet'!F48","v":{"v":0,"d":"0.00"}},{"$f":"'Input sheet'!G48","v":{"v":0,"d":"0.00"}},{"$f":"'Input sheet'!H48","v":{"v":0,"d":"0.00"}},{"$f":"'Input sheet'!I48","v":{"v":0,"d":"0.00"}},{"$f":"'Input sheet'!J48","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":5},2015,2016,2017,2018,2019]
[{"$nulls":5},{"$f":"IF($C$16=TRUE, $F$15/(F22), $F$15)","v":0},{"$f":"IF($C$16=TRUE, $F$15/(G22), $F$15)","v":0},{"$f":"IF($C$16=TRUE, $F$15/(H22), $F$15)","v":0},{"$f":"IF($C$16=TRUE, $F$15/(I22), $F$15)","v":0},{"$f":"IF($C$16=TRUE, $F$15/(J22), $F$15)","v":0}]
[{"$nulls":4},"inlflation to apply",{"$f":"G22*(1+G18/100)","v":{"v":1,"d":"1.00"}},{"$f":"H22*(1+H18/100)","v":{"v":1,"d":"1.00"}},{"$f":"I22*(1+I18/100)","v":{"v":1,"d":"1.00"}},{"$f":"J22*(1+J18/100)","v":{"v":1,"d":"1.00"}},{"v":1,"d":"1.00"}]
[]
[]
[]
[]
[]
[null,null,"KPIs",null,null,{"$f":"Control!$E$20-4","v":2018},{"$f":"Control!$E$20-3","v":2019},{"$f":"Control!$E$20-2","v":2020},{"$f":"Control!$E$20-1","v":2021},{"$f":"Control!$E$20","v":2022},"2021-2022 AGR","2018-2022 CAGR"]
[null,null,"1 Unit cost",null,null,{"$f":"F30/F31","v":{"$error":"#VALUE!"}},{"$f":"G30/G31","v":{"$error":"#VALUE!"}},{"$f":"H30/H31","v":{"$error":"#VALUE!"}},{"$f":"I30/I31","v":{"$error":"#VALUE!"}},{"$f":"J30/J31","v":{"$error":"#VALUE!"}},{"$f":"J29/I29 -1","v":{"$error":"#VALUE!"}},{"$f":"(J29/F29)^(1/4) -1","v":{"$error":"#VALUE!"}}]
[{"$nulls":4},"Total Costs",{"$f":"IFERROR('Basic Previously submitted data'!E16/F21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!F16/G21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!G16/H21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!H16/I21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!I16/J21,\"-      \")","v":"-      "},{"$f":"J30/I30 -1","v":{"$error":"#VALUE!"}},{"$f":"(J30/F30)^(1/4) -1","v":{"$error":"#VALUE!"}}]
[{"$nulls":4},"IFR flight hours",{"$f":"'Basic Previously submitted data'!E17","v":0},{"$f":"'Basic Previously submitted data'!F17","v":0},{"$f":"'Basic Previously submitted data'!G17","v":0},{"$f":"'Basic Previously submitted data'!H17","v":0},{"$f":"'Basic Previously submitted data'!I17","v":0},{"$f":"J31/I31 -1","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,"2A ATCO employment costs",null,null,{"$f":"F33/F34","v":{"$error":"#VALUE!"}},{"$f":"G33/G34","v":{"$error":"#VALUE!"}},{"$f":"H33/H34","v":{"$error":"#VALUE!"}},{"$f":"I33/I34","v":{"$error":"#VALUE!"}},{"$f":"J33/J34","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"ATCO employment cost",{"$f":"IFERROR('Basic Previously submitted data'!E20/F21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!F20/G21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!G20/H21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!H20/I21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!I20/J21,\"-      \")","v":"-      "},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"ATCO hours",{"$f":"'Basic Previously submitted data'!E18","v":0},{"$f":"'Basic Previously submitted data'!F18","v":0},{"$f":"'Basic Previously submitted data'!G18","v":0},{"$f":"'Basic Previously submitted data'!H18","v":0},{"$f":"'Basic Previously submitted data'!I18","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"2B ATCO productivity",null,null,{"$f":"F36/F37","v":{"$error":"#DIV/0!"}},{"$f":"G36/G37","v":{"$error":"#DIV/0!"}},{"$f":"H36/H37","v":{"$error":"#DIV/0!"}},{"$f":"I36/I37","v":{"$error":"#DIV/0!"}},{"$f":"J36/J37","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"IFR flight hours",{"$f":"'Basic Previously submitted data'!E17","v":0},{"$f":"'Basic Previously submitted data'!F17","v":0},{"$f":"'Basic Previously submitted data'!G17","v":0},{"$f":"'Basic Previously submitted data'!H17","v":0},{"$f":"'Basic Previously submitted data'!I17","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"ATCO hours",{"$f":"'Basic Previously submitted data'!E18","v":0},{"$f":"'Basic Previously submitted data'!F18","v":0},{"$f":"'Basic Previously submitted data'!G18","v":0},{"$f":"'Basic Previously submitted data'!H18","v":0},{"$f":"'Basic Previously submitted data'!I18","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"2C Other costs per IFR flight hour",null,null,{"$f":"F39/F40","v":{"$error":"#VALUE!"}},{"$f":"G39/G40","v":{"$error":"#VALUE!"}},{"$f":"H39/H40","v":{"$error":"#VALUE!"}},{"$f":"I39/I40","v":{"$error":"#VALUE!"}},{"$f":"J39/J40","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"Other costs",{"$f":"IFERROR('Basic Previously submitted data'!E21/F21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!F21/G21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!G21/H21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!H21/I21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!I21/J21,\"-      \")","v":"-      "},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"IFR flight hours",{"$f":"'Basic Previously submitted data'!E17","v":0},{"$f":"'Basic Previously submitted data'!F17","v":0},{"$f":"'Basic Previously submitted data'!G17","v":0},{"$f":"'Basic Previously submitted data'!H17","v":0},{"$f":"'Basic Previously submitted data'!I17","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"2D Proportion of total costs made up of ATCO",null,null,{"$f":"F42/F43","v":{"$error":"#VALUE!"}},{"$f":"G42/G43","v":{"$error":"#VALUE!"}},{"$f":"H42/H43","v":{"$error":"#VALUE!"}},{"$f":"I42/I43","v":{"$error":"#VALUE!"}},{"$f":"J42/J43","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"ATCO employment cost",{"$f":"IFERROR('Basic Previously submitted data'!E20/F21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!F20/G21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!G20/H21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!H20/I21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!I20/J21,\"-      \")","v":"-      "},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"Total Costs",{"$f":"IFERROR('Basic Previously submitted data'!E16/F21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!F16/G21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!G16/H21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!H16/I21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!I16/J21,\"-      \")","v":"-      "},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,"3A Unit ATCO employment costs",null,null,{"$f":"F45/F46","v":{"$error":"#VALUE!"}},{"$f":"G45/G46","v":{"$error":"#VALUE!"}},{"$f":"H45/H46","v":{"$error":"#VALUE!"}},{"$f":"I45/I46","v":{"$error":"#VALUE!"}},{"$f":"J45/J46","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"ATCO employment cost",{"$f":"IFERROR('Basic Previously submitted data'!E20/F21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!F20/G21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!G20/H21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!H20/I21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!I20/J21,\"-      \")","v":"-      "},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"No. of ATCOs",{"$f":"'Basic Previously submitted data'!E22","v":0},{"$f":"'Basic Previously submitted data'!F22","v":0},{"$f":"'Basic Previously submitted data'!G22","v":0},{"$f":"'Basic Previously submitted data'!H22","v":0},{"$f":"'Basic Previously submitted data'!I22","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"3B Annual Working hours per ATCO in OPS",null,null,{"$f":"F48/F49","v":{"$error":"#DIV/0!"}},{"$f":"G48/G49","v":{"$error":"#DIV/0!"}},{"$f":"H48/H49","v":{"$error":"#DIV/0!"}},{"$f":"I48/I49","v":{"$error":"#DIV/0!"}},{"$f":"J48/J49","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"ATCO hours",{"$f":"'Basic Previously submitted data'!E18","v":0},{"$f":"'Basic Previously submitted data'!F18","v":0},{"$f":"'Basic Previously submitted data'!G18","v":0},{"$f":"'Basic Previously submitted data'!H18","v":0},{"$f":"'Basic Previously submitted data'!I18","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"No. of ATCOs",{"$f":"'Basic Previously submitted data'!E22","v":0},{"$f":"'Basic Previously submitted data'!F22","v":0},{"$f":"'Basic Previously submitted data'!G22","v":0},{"$f":"'Basic Previously submitted data'!H22","v":0},{"$f":"'Basic Previously submitted data'!I22","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"3C IFR hours per ATCO in OPS",null,null,{"$f":"F51/F52","v":{"$error":"#DIV/0!"}},{"$f":"G51/G52","v":{"$error":"#DIV/0!"}},{"$f":"H51/H52","v":{"$error":"#DIV/0!"}},{"$f":"I51/I52","v":{"$error":"#DIV/0!"}},{"$f":"J51/J52","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"IFR flight hours",{"$f":"'Basic Previously submitted data'!E17","v":0},{"$f":"'Basic Previously submitted data'!F17","v":0},{"$f":"'Basic Previously submitted data'!G17","v":0},{"$f":"'Basic Previously submitted data'!H17","v":0},{"$f":"'Basic Previously submitted data'!I17","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"No. of ATCOs",{"$f":"'Basic Previously submitted data'!E22","v":0},{"$f":"'Basic Previously submitted data'!F22","v":0},{"$f":"'Basic Previously submitted data'!G22","v":0},{"$f":"'Basic Previously submitted data'!H22","v":0},{"$f":"'Basic Previously submitted data'!I22","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"3D Ratio of frontline service staff to ATCO in OPS ",null,null,{"$f":"F54/F55","v":{"$error":"#DIV/0!"}},{"$f":"G54/G55","v":{"$error":"#DIV/0!"}},{"$f":"H54/H55","v":{"$error":"#DIV/0!"}},{"$f":"I54/I55","v":{"$error":"#DIV/0!"}},{"$f":"J54/J55","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"Frontline staff",{"$f":"'Basic Previously submitted data'!E26","v":0},{"$f":"'Basic Previously submitted data'!F26","v":0},{"$f":"'Basic Previously submitted data'!G26","v":0},{"$f":"'Basic Previously submitted data'!H26","v":0},{"$f":"'Basic Previously submitted data'!I26","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"No. of ATCOs",{"$f":"'Basic Previously submitted data'!E22","v":0},{"$f":"'Basic Previously submitted data'!F22","v":0},{"$f":"'Basic Previously submitted data'!G22","v":0},{"$f":"'Basic Previously submitted data'!H22","v":0},{"$f":"'Basic Previously submitted data'!I22","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"P1 ANS revenue per IFR flight hour",null,null,{"$f":"F57/F58","v":{"$error":"#VALUE!"}},{"$f":"G57/G58","v":{"$error":"#VALUE!"}},{"$f":"H57/H58","v":{"$error":"#VALUE!"}},{"$f":"I57/I58","v":{"$error":"#VALUE!"}},{"$f":"J57/J58","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"ANS Revenue",{"$f":"IFERROR('Basic Previously submitted data'!E23/F21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!F23/G21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!G23/H21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!H23/I21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!I23/J21,\"-      \")","v":"-      "},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"IFR flight hours",{"$f":"'Basic Previously submitted data'!E17","v":0},{"$f":"'Basic Previously submitted data'!F17","v":0},{"$f":"'Basic Previously submitted data'!G17","v":0},{"$f":"'Basic Previously submitted data'!H17","v":0},{"$f":"'Basic Previously submitted data'!I17","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[null,null,"KPIs",null,null,{"$f":"Control!$E$20-4","v":2018},{"$f":"Control!$E$20-3","v":2019},{"$f":"Control!$E$20-2","v":2020},{"$f":"Control!$E$20-1","v":2021},{"$f":"Control!$E$20","v":2022},"2021-2022 AGR","2018-2022 CAGR"]
[null,null,"1 Unit cost",null,null,{"$f":"F65/F66","v":{"$error":"#VALUE!"}},{"$f":"G65/G66","v":{"$error":"#VALUE!"}},{"$f":"H65/H66","v":{"$error":"#VALUE!"}},{"$f":"I65/I66","v":{"$error":"#VALUE!"}},{"$f":"J65/J66","v":{"$error":"#VALUE!"}},{"$f":"J64/I64 -1","v":{"$error":"#VALUE!"}},{"$f":"(J64/F64)^(1/4) -1","v":{"$error":"#VALUE!"}}]
[{"$nulls":4},"Total Costs",{"$f":"IFERROR('Basic Previously submitted data'!E32/F21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!F32/G21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!G32/H21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!H32/I21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!I32/J21,\"-      \")","v":"-      "},{"$f":"J65/I65 -1","v":{"$error":"#VALUE!"}},{"$f":"(J65/F65)^(1/4) -1","v":{"$error":"#VALUE!"}}]
[{"$nulls":4},"IFR flight hours",{"$f":"'Basic Previously submitted data'!E33","v":0},{"$f":"'Basic Previously submitted data'!F33","v":0},{"$f":"'Basic Previously submitted data'!G33","v":0},{"$f":"'Basic Previously submitted data'!H33","v":0},{"$f":"'Basic Previously submitted data'!I33","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"2A ATCO employment costs",null,null,{"$f":"F68/F69","v":{"$error":"#VALUE!"}},{"$f":"G68/G69","v":{"$error":"#VALUE!"}},{"$f":"H68/H69","v":{"$error":"#VALUE!"}},{"$f":"I68/I69","v":{"$error":"#VALUE!"}},{"$f":"J68/J69","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"ATCO employment cost",{"$f":"IFERROR('Basic Previously submitted data'!E36/F21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!F36/G21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!G36/H21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!H36/I21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!I36/J21,\"-      \")","v":"-      "},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"ATCO hours",{"$f":"'Basic Previously submitted data'!E34","v":0},{"$f":"'Basic Previously submitted data'!F34","v":0},{"$f":"'Basic Previously submitted data'!G34","v":0},{"$f":"'Basic Previously submitted data'!H34","v":0},{"$f":"'Basic Previously submitted data'!I34","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"2B ATCO productivity",null,null,{"$f":"F71/F72","v":{"$error":"#DIV/0!"}},{"$f":"G71/G72","v":{"$error":"#DIV/0!"}},{"$f":"H71/H72","v":{"$error":"#DIV/0!"}},{"$f":"I71/I72","v":{"$error":"#DIV/0!"}},{"$f":"J71/J72","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"IFR flight hours",{"$f":"'Basic Previously submitted data'!E33","v":0},{"$f":"'Basic Previously submitted data'!F33","v":0},{"$f":"'Basic Previously submitted data'!G33","v":0},{"$f":"'Basic Previously submitted data'!H33","v":0},{"$f":"'Basic Previously submitted data'!I33","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"ATCO hours",{"$f":"'Basic Previously submitted data'!E34","v":0},{"$f":"'Basic Previously submitted data'!F34","v":0},{"$f":"'Basic Previously submitted data'!G34","v":0},{"$f":"'Basic Previously submitted data'!H34","v":0},{"$f":"'Basic Previously submitted data'!I34","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"2C Other costs per IFR flight hour",null,null,{"$f":"F74/F75","v":{"$error":"#VALUE!"}},{"$f":"G74/G75","v":{"$error":"#VALUE!"}},{"$f":"H74/H75","v":{"$error":"#VALUE!"}},{"$f":"I74/I75","v":{"$error":"#VALUE!"}},{"$f":"J74/J75","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"Other costs",{"$f":"IFERROR('Basic Previously submitted data'!E37/F21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!F37/G21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!G37/H21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!H37/I21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!I37/J21,\"-      \")","v":"-      "},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"IFR flight hours",{"$f":"'Basic Previously submitted data'!E33","v":0},{"$f":"'Basic Previously submitted data'!F33","v":0},{"$f":"'Basic Previously submitted data'!G33","v":0},{"$f":"'Basic Previously submitted data'!H33","v":0},{"$f":"'Basic Previously submitted data'!I33","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"2D Proportion of total costs made up of ATCO",null,null,{"$f":"F77/F78","v":{"$error":"#VALUE!"}},{"$f":"G77/G78","v":{"$error":"#VALUE!"}},{"$f":"H77/H78","v":{"$error":"#VALUE!"}},{"$f":"I77/I78","v":{"$error":"#VALUE!"}},{"$f":"J77/J78","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"ATCO employment cost",{"$f":"IFERROR('Basic Previously submitted data'!E36/F21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!F36/G21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!G36/H21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!H36/I21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!I36/J21,\"-      \")","v":"-      "},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"Total Costs",{"$f":"IFERROR('Basic Previously submitted data'!E32/F21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!F32/G21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!G32/H21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!H32/I21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!I32/J21,\"-      \")","v":"-      "},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,"3A Unit ATCO employment costs",null,null,{"$f":"F80/F81","v":{"$error":"#VALUE!"}},{"$f":"G80/G81","v":{"$error":"#VALUE!"}},{"$f":"H80/H81","v":{"$error":"#VALUE!"}},{"$f":"I80/I81","v":{"$error":"#VALUE!"}},{"$f":"J80/J81","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"ATCO employment cost",{"$f":"IFERROR('Basic Previously submitted data'!E36/F21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!F36/G21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!G36/H21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!H36/I21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!I36/J21,\"-      \")","v":"-      "},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"No. of ATCOs",{"$f":"'Basic Previously submitted data'!E38","v":0},{"$f":"'Basic Previously submitted data'!F38","v":0},{"$f":"'Basic Previously submitted data'!G38","v":0},{"$f":"'Basic Previously submitted data'!H38","v":0},{"$f":"'Basic Previously submitted data'!I38","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"3B Annual Working hours per ATCO in OPS",null,null,{"$f":"F83/F84","v":{"$error":"#DIV/0!"}},{"$f":"G83/G84","v":{"$error":"#DIV/0!"}},{"$f":"H83/H84","v":{"$error":"#DIV/0!"}},{"$f":"I83/I84","v":{"$error":"#DIV/0!"}},{"$f":"J83/J84","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"ATCO hours",{"$f":"'Basic Previously submitted data'!E34","v":0},{"$f":"'Basic Previously submitted data'!F34","v":0},{"$f":"'Basic Previously submitted data'!G34","v":0},{"$f":"'Basic Previously submitted data'!H34","v":0},{"$f":"'Basic Previously submitted data'!I34","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"No. of ATCOs",{"$f":"'Basic Previously submitted data'!E38","v":0},{"$f":"'Basic Previously submitted data'!F38","v":0},{"$f":"'Basic Previously submitted data'!G38","v":0},{"$f":"'Basic Previously submitted data'!H38","v":0},{"$f":"'Basic Previously submitted data'!I38","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"3C IFR hours per ATCO in OPS",null,null,{"$f":"F86/F87","v":{"$error":"#DIV/0!"}},{"$f":"G86/G87","v":{"$error":"#DIV/0!"}},{"$f":"H86/H87","v":{"$error":"#DIV/0!"}},{"$f":"I86/I87","v":{"$error":"#DIV/0!"}},{"$f":"J86/J87","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"IFR flight hours",{"$f":"'Basic Previously submitted data'!E33","v":0},{"$f":"'Basic Previously submitted data'!F33","v":0},{"$f":"'Basic Previously submitted data'!G33","v":0},{"$f":"'Basic Previously submitted data'!H33","v":0},{"$f":"'Basic Previously submitted data'!I33","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"No. of ATCOs",{"$f":"'Basic Previously submitted data'!E38","v":0},{"$f":"'Basic Previously submitted data'!F38","v":0},{"$f":"'Basic Previously submitted data'!G38","v":0},{"$f":"'Basic Previously submitted data'!H38","v":0},{"$f":"'Basic Previously submitted data'!I38","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"3D Ratio of frontline service staff to ATCO in OPS ",null,null,{"$f":"F89/F90","v":{"$error":"#DIV/0!"}},{"$f":"G89/G90","v":{"$error":"#DIV/0!"}},{"$f":"H89/H90","v":{"$error":"#DIV/0!"}},{"$f":"I89/I90","v":{"$error":"#DIV/0!"}},{"$f":"J89/J90","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"Frontline staff",{"$f":"'Basic Previously submitted data'!E40","v":0},{"$f":"'Basic Previously submitted data'!F40","v":0},{"$f":"'Basic Previously submitted data'!G40","v":0},{"$f":"'Basic Previously submitted data'!H40","v":0},{"$f":"'Basic Previously submitted data'!I40","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"No. of ATCOs",{"$f":"'Basic Previously submitted data'!E38","v":0},{"$f":"'Basic Previously submitted data'!F38","v":0},{"$f":"'Basic Previously submitted data'!G38","v":0},{"$f":"'Basic Previously submitted data'!H38","v":0},{"$f":"'Basic Previously submitted data'!I38","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"P1 ANS revenue per IFR flight hour",null,null,{"$f":"F92/F93","v":{"$error":"#VALUE!"}},{"$f":"G92/G93","v":{"$error":"#VALUE!"}},{"$f":"H92/H93","v":{"$error":"#VALUE!"}},{"$f":"I92/I93","v":{"$error":"#VALUE!"}},{"$f":"J92/J93","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"ANS Revenue",{"$f":"IFERROR('Basic Previously submitted data'!E39/F21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!F39/G21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!G39/H21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!H39/I21,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!I39/J21,\"-      \")","v":"-      "},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"IFR flight hours",{"$f":"'Basic Previously submitted data'!E33","v":0},{"$f":"'Basic Previously submitted data'!F33","v":0},{"$f":"'Basic Previously submitted data'!G33","v":0},{"$f":"'Basic Previously submitted data'!H33","v":0},{"$f":"'Basic Previously submitted data'!I33","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[null,null,"KPIs",null,null,{"$f":"Control!$E$20-4","v":2018},{"$f":"Control!$E$20-3","v":2019},{"$f":"Control!$E$20-2","v":2020},{"$f":"Control!$E$20-1","v":2021},{"$f":"Control!$E$20","v":2022},"2021-2022 AGR","2018-2022 CAGR"]
[null,null,"1 Unit cost",null,null,{"$f":"F100/F101","v":{"$error":"#VALUE!"}},{"$f":"G100/G101","v":{"$error":"#VALUE!"}},{"$f":"H100/H101","v":{"$error":"#VALUE!"}},{"$f":"I100/I101","v":{"$error":"#VALUE!"}},{"$f":"J100/J101","v":{"$error":"#VALUE!"}},{"$f":"J99/I99 -1","v":{"$error":"#VALUE!"}},{"$f":"(J99/F99)^(1/4) -1","v":{"$error":"#VALUE!"}}]
[{"$nulls":4},"Total Costs",{"$f":"F30+F65","v":{"$error":"#VALUE!"}},{"$f":"G30+G65","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"J100/I100 -1","v":{"$error":"#VALUE!"}},{"$f":"(J100/F100)^(1/4) -1","v":{"$error":"#VALUE!"}}]
[{"$nulls":4},"IFR flight hours",{"$f":"F31+F66","v":0},0,0,0,0,{"$error":"#DIV/0!"},{"$f":"(J101/F101)^(1/4) -1","v":{"$error":"#DIV/0!"}}]
[null,null,"2A ATCO employment costs",null,null,{"$f":"F103/F104","v":{"$error":"#VALUE!"}},{"$f":"G103/G104","v":{"$error":"#VALUE!"}},{"$f":"H103/H104","v":{"$error":"#VALUE!"}},{"$f":"I103/I104","v":{"$error":"#VALUE!"}},{"$f":"J103/J104","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"ATCO employment cost",{"$f":"F33+F68","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"ATCO hours",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"2B ATCO productivity",null,null,{"$f":"F106/F107","v":{"$error":"#DIV/0!"}},{"$f":"G106/G107","v":{"$error":"#DIV/0!"}},{"$f":"H106/H107","v":{"$error":"#DIV/0!"}},{"$f":"I106/I107","v":{"$error":"#DIV/0!"}},{"$f":"J106/J107","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"IFR flight hours",{"$f":"F36+F71","v":0},0,{"$f":"H36+H71","v":0},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"ATCO hours",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"2C Other costs per IFR flight hour",null,null,{"$f":"F109/F110","v":{"$error":"#VALUE!"}},{"$f":"G109/G110","v":{"$error":"#VALUE!"}},{"$f":"H109/H110","v":{"$error":"#VALUE!"}},{"$f":"I109/I110","v":{"$error":"#VALUE!"}},{"$f":"J109/J110","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"Other costs",{"$f":"F39+F74","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"IFR flight hours",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"2D Proportion of total costs made up of ATCO",null,null,{"$f":"F112/F113","v":{"$error":"#VALUE!"}},{"$f":"G112/G113","v":{"$error":"#VALUE!"}},{"$f":"H112/H113","v":{"$error":"#VALUE!"}},{"$f":"I112/I113","v":{"$error":"#VALUE!"}},{"$f":"J112/J113","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"ATCO employment cost",{"$f":"F42+F77","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"Total Costs",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,"3A Unit ATCO employment costs",null,null,{"$f":"F115/F116","v":{"$error":"#VALUE!"}},{"$f":"G115/G116","v":{"$error":"#VALUE!"}},{"$f":"H115/H116","v":{"$error":"#VALUE!"}},{"$f":"I115/I116","v":{"$error":"#VALUE!"}},{"$f":"J115/J116","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"ATCO employment cost",{"$f":"F45+F80","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"No. of ATCOs",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"3B Annual Working hours per ATCO in OPS",null,null,{"$f":"F118/F119","v":{"$error":"#DIV/0!"}},{"$f":"G118/G119","v":{"$error":"#DIV/0!"}},{"$f":"H118/H119","v":{"$error":"#DIV/0!"}},{"$f":"I118/I119","v":{"$error":"#DIV/0!"}},{"$f":"J118/J119","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"ATCO hours",{"$f":"F48+F83","v":0},0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"No. of ATCOs",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"3C IFR hours per ATCO in OPS",null,null,{"$f":"F121/F122","v":{"$error":"#DIV/0!"}},{"$f":"G121/G122","v":{"$error":"#DIV/0!"}},{"$f":"H121/H122","v":{"$error":"#DIV/0!"}},{"$f":"I121/I122","v":{"$error":"#DIV/0!"}},{"$f":"J121/J122","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"IFR flight hours",{"$f":"F51+F86","v":0},0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"No. of ATCOs",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"3D Ratio of frontline service staff to ATCO in OPS ",null,null,{"$f":"F124/F125","v":{"$error":"#DIV/0!"}},{"$f":"G124/G125","v":{"$error":"#DIV/0!"}},{"$f":"H124/H125","v":{"$error":"#DIV/0!"}},{"$f":"I124/I125","v":{"$error":"#DIV/0!"}},{"$f":"J124/J125","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"Frontline staff",{"$f":"F54+F89","v":0},0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"No. of ATCOs",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"P1 ANS revenue per IFR flight hour",null,null,{"$f":"F127/F128","v":{"$error":"#VALUE!"}},{"$f":"G127/G128","v":{"$error":"#VALUE!"}},{"$f":"H127/H128","v":{"$error":"#VALUE!"}},{"$f":"I127/I128","v":{"$error":"#VALUE!"}},{"$f":"J127/J128","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"ANS Revenue",{"$f":"F57+F92","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"IFR flight hours",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

{"sheet":"Basic PPP Output","index":8,"n_rows":125,"n_cols":12,"rows_kept":125,"merged":[[3,3,4,9],[6,3,7,9],[22,5,22,8],[23,5,23,8]]}
[]
[]
[]
[{"$nulls":3},"PPP Output sheet"]
[]
[]
[{"$nulls":3},"This sheet shows the key performance indicators (KPIs) and respective input data with PPP conversion for the ANSP for this year and years previous. Please scroll to Continental, Oceanic and Combined outputs."]
[]
[{"$nulls":5},"To edit financial information please return to the 'Input' sheet."]
[{"$nulls":5},"PPP rates"]
[null,null,"Apply Inflation adjustment",null,null,{"$f":"Control!$E$20-4","v":2018},{"$f":"Control!$E$20-3","v":2019},{"$f":"Control!$E$20-2","v":2020},{"$f":"Control!$E$20-1","v":2021},{"$f":"Control!$E$20","v":2022}]
[{"$nulls":5},{"$f":"'Input sheet'!F47","v":{"v":0,"d":"0.00"}},{"$f":"'Input sheet'!G47","v":{"v":0,"d":"0.00"}},{"$f":"'Input sheet'!H47","v":{"v":0,"d":"0.00"}},{"$f":"'Input sheet'!I47","v":{"v":0,"d":"0.00"}},{"$f":"'Input sheet'!J47","v":{"v":0,"d":"0.00"}}]
[null,null,false,null,null,"Inflation rates"]
[{"$nulls":5},{"$f":"Control!$E$20-4","v":2018},{"$f":"Control!$E$20-3","v":2019},{"$f":"Control!$E$20-2","v":2020},{"$f":"Control!$E$20-1","v":2021},{"$f":"Control!$E$20","v":2022}]
[{"$nulls":5},{"$f":"'Input sheet'!F48","v":{"v":0,"d":"0.00"}},{"$f":"'Input sheet'!G48","v":{"v":0,"d":"0.00"}},{"$f":"'Input sheet'!H48","v":{"v":0,"d":"0.00"}},{"$f":"'Input sheet'!I48","v":{"v":0,"d":"0.00"}},{"$f":"'Input sheet'!J48","v":{"v":0,"d":"0.00"}}]
[{"$nulls":5},"PPP rates"]
[{"$nulls":5},2015,2016,2017,2018,2019]
[{"$nulls":5},{"$f":"IF($C$13=TRUE, F12/F19, F12)","v":0},{"$f":"IF($C$13=TRUE, G12/G19, G12)","v":0},{"$f":"IF($C$13=TRUE, H12/H19, H12)","v":0},{"$f":"IF($C$13=TRUE, I12/I19, I12)","v":0},{"$f":"IF($C$13=TRUE, J12/J19, J12)","v":0}]
[{"$nulls":4},"inlflation to apply",{"$f":"G19*(1+G15/100)","v":{"v":1,"d":"1.00"}},{"$f":"H19*(1+H15/100)","v":{"v":1,"d":"1.00"}},{"$f":"I19*(1+I15/100)","v":{"v":1,"d":"1.00"}},{"$f":"J19*(1+J15/100)","v":{"v":1,"d":"1.00"}},{"v":1,"d":"1.00"}]
[]
[]
[]
[]
[]
[null,null,"KPIs",null,null,{"$f":"Control!$E$20-4","v":2018},{"$f":"Control!$E$20-3","v":2019},{"$f":"Control!$E$20-2","v":2020},{"$f":"Control!$E$20-1","v":2021},{"$f":"Control!$E$20","v":2022},"2021-2022 AGR","2018-2022 CAGR"]
[null,null,"1 Unit cost",null,null,{"$f":"F27/F28","v":{"$error":"#VALUE!"}},{"$f":"G27/G28","v":{"$error":"#VALUE!"}},{"$f":"H27/H28","v":{"$error":"#VALUE!"}},{"$f":"I27/I28","v":{"$error":"#VALUE!"}},{"$f":"J27/J28","v":{"$error":"#VALUE!"}},{"$f":"J26/I26 -1","v":{"$error":"#VALUE!"}},{"$f":"(J26/F26)^(1/4) -1","v":{"$error":"#VALUE!"}}]
[{"$nulls":4},"Total Costs",{"$f":"IFERROR('Basic Previously submitted data'!E16/F18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!F16/G18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!G16/H18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!H16/I18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!I16/J18,\"-      \")","v":"-      "},{"$f":"J27/I27 -1","v":{"$error":"#VALUE!"}},{"$f":"(J27/F27)^(1/4) -1","v":{"$error":"#VALUE!"}}]
[{"$nulls":4},"IFR flight hours",{"$f":"'Basic Previously submitted data'!E17","v":0},{"$f":"'Basic Previously submitted data'!F17","v":0},{"$f":"'Basic Previously submitted data'!G17","v":0},{"$f":"'Basic Previously submitted data'!H17","v":0},{"$f":"'Basic Previously submitted data'!I17","v":0},{"$f":"J28/I28 -1","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,"2A ATCO employment costs",null,null,{"$f":"F30/F31","v":{"$error":"#VALUE!"}},{"$f":"G30/G31","v":{"$error":"#VALUE!"}},{"$f":"H30/H31","v":{"$error":"#VALUE!"}},{"$f":"I30/I31","v":{"$error":"#VALUE!"}},{"$f":"J30/J31","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"ATCO employment cost",{"$f":"IFERROR('Basic Previously submitted data'!E20/F18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!F20/G18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!G20/H18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!H20/I18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!I20/J18,\"-      \")","v":"-      "},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"ATCO hours",{"$f":"'Basic Previously submitted data'!E18","v":0},{"$f":"'Basic Previously submitted data'!F18","v":0},{"$f":"'Basic Previously submitted data'!G18","v":0},{"$f":"'Basic Previously submitted data'!H18","v":0},{"$f":"'Basic Previously submitted data'!I18","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"2B ATCO productivity",null,null,{"$f":"F33/F34","v":{"$error":"#DIV/0!"}},{"$f":"G33/G34","v":{"$error":"#DIV/0!"}},{"$f":"H33/H34","v":{"$error":"#DIV/0!"}},{"$f":"I33/I34","v":{"$error":"#DIV/0!"}},{"$f":"J33/J34","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"IFR flight hours",{"$f":"'Basic Previously submitted data'!E17","v":0},{"$f":"'Basic Previously submitted data'!F17","v":0},{"$f":"'Basic Previously submitted data'!G17","v":0},{"$f":"'Basic Previously submitted data'!H17","v":0},{"$f":"'Basic Previously submitted data'!I17","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"ATCO hours",{"$f":"'Basic Previously submitted data'!E18","v":0},{"$f":"'Basic Previously submitted data'!F18","v":0},{"$f":"'Basic Previously submitted data'!G18","v":0},{"$f":"'Basic Previously submitted data'!H18","v":0},{"$f":"'Basic Previously submitted data'!I18","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"2C Other costs per IFR flight hour",null,null,{"$f":"F36/F37","v":{"$error":"#VALUE!"}},{"$f":"G36/G37","v":{"$error":"#VALUE!"}},{"$f":"H36/H37","v":{"$error":"#VALUE!"}},{"$f":"I36/I37","v":{"$error":"#VALUE!"}},{"$f":"J36/J37","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"Other costs",{"$f":"IFERROR('Basic Previously submitted data'!E21/F18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!F21/G18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!G21/H18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!H21/I18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!I21/J18,\"-      \")","v":"-      "},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"IFR flight hours",{"$f":"'Basic Previously submitted data'!E17","v":0},{"$f":"'Basic Previously submitted data'!F17","v":0},{"$f":"'Basic Previously submitted data'!G17","v":0},{"$f":"'Basic Previously submitted data'!H17","v":0},{"$f":"'Basic Previously submitted data'!I17","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"2D Proportion of total costs made up of ATCO",null,null,{"$f":"F39/F40","v":{"$error":"#VALUE!"}},{"$f":"G39/G40","v":{"$error":"#VALUE!"}},{"$f":"H39/H40","v":{"$error":"#VALUE!"}},{"$f":"I39/I40","v":{"$error":"#VALUE!"}},{"$f":"J39/J40","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"ATCO employment cost",{"$f":"IFERROR('Basic Previously submitted data'!E20/F18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!F20/G18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!G20/H18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!H20/I18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!I20/J18,\"-      \")","v":"-      "},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"Total Costs",{"$f":"IFERROR('Basic Previously submitted data'!E16/F18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!F16/G18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!G16/H18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!H16/I18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!I16/J18,\"-      \")","v":"-      "},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,"3A Unit ATCO employment costs",null,null,{"$f":"F42/F43","v":{"$error":"#VALUE!"}},{"$f":"G42/G43","v":{"$error":"#VALUE!"}},{"$f":"H42/H43","v":{"$error":"#VALUE!"}},{"$f":"I42/I43","v":{"$error":"#VALUE!"}},{"$f":"J42/J43","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"ATCO employment cost",{"$f":"IFERROR('Basic Previously submitted data'!E20/F18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!F20/G18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!G20/H18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!H20/I18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!I20/J18,\"-      \")","v":"-      "},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"No. of ATCOs",{"$f":"'Basic Previously submitted data'!E22","v":0},{"$f":"'Basic Previously submitted data'!F22","v":0},{"$f":"'Basic Previously submitted data'!G22","v":0},{"$f":"'Basic Previously submitted data'!H22","v":0},{"$f":"'Basic Previously submitted data'!I22","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"3B Annual Working hours per ATCO in OPS",null,null,{"$f":"F45/F46","v":{"$error":"#DIV/0!"}},{"$f":"G45/G46","v":{"$error":"#DIV/0!"}},{"$f":"H45/H46","v":{"$error":"#DIV/0!"}},{"$f":"I45/I46","v":{"$error":"#DIV/0!"}},{"$f":"J45/J46","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"ATCO hours",{"$f":"'Basic Previously submitted data'!E18","v":0},{"$f":"'Basic Previously submitted data'!F18","v":0},{"$f":"'Basic Previously submitted data'!G18","v":0},{"$f":"'Basic Previously submitted data'!H18","v":0},{"$f":"'Basic Previously submitted data'!I18","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"No. of ATCOs",{"$f":"'Basic Previously submitted data'!E22","v":0},{"$f":"'Basic Previously submitted data'!F22","v":0},{"$f":"'Basic Previously submitted data'!G22","v":0},{"$f":"'Basic Previously submitted data'!H22","v":0},{"$f":"'Basic Previously submitted data'!I22","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"3C IFR hours per ATCO in OPS",null,null,{"$f":"F48/F49","v":{"$error":"#DIV/0!"}},{"$f":"G48/G49","v":{"$error":"#DIV/0!"}},{"$f":"H48/H49","v":{"$error":"#DIV/0!"}},{"$f":"I48/I49","v":{"$error":"#DIV/0!"}},{"$f":"J48/J49","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"IFR flight hours",{"$f":"'Basic Previously submitted data'!E17","v":0},{"$f":"'Basic Previously submitted data'!F17","v":0},{"$f":"'Basic Previously submitted data'!G17","v":0},{"$f":"'Basic Previously submitted data'!H17","v":0},{"$f":"'Basic Previously submitted data'!I17","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"No. of ATCOs",{"$f":"'Basic Previously submitted data'!E22","v":0},{"$f":"'Basic Previously submitted data'!F22","v":0},{"$f":"'Basic Previously submitted data'!G22","v":0},{"$f":"'Basic Previously submitted data'!H22","v":0},{"$f":"'Basic Previously submitted data'!I22","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"3D Ratio of frontline service staff to ATCO in OPS ",null,null,{"$f":"F51/F52","v":{"$error":"#DIV/0!"}},{"$f":"G51/G52","v":{"$error":"#DIV/0!"}},{"$f":"H51/H52","v":{"$error":"#DIV/0!"}},{"$f":"I51/I52","v":{"$error":"#DIV/0!"}},{"$f":"J51/J52","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"Frontline staff",{"$f":"'Basic Previously submitted data'!E26","v":0},{"$f":"'Basic Previously submitted data'!F26","v":0},{"$f":"'Basic Previously submitted data'!G26","v":0},{"$f":"'Basic Previously submitted data'!H26","v":0},{"$f":"'Basic Previously submitted data'!I26","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"No. of ATCOs",{"$f":"'Basic Previously submitted data'!E22","v":0},{"$f":"'Basic Previously submitted data'!F22","v":0},{"$f":"'Basic Previously submitted data'!G22","v":0},{"$f":"'Basic Previously submitted data'!H22","v":0},{"$f":"'Basic Previously submitted data'!I22","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"P1 ANS revenue per IFR flight hour",null,null,{"$f":"F54/F55","v":{"$error":"#VALUE!"}},{"$f":"G54/G55","v":{"$error":"#VALUE!"}},{"$f":"H54/H55","v":{"$error":"#VALUE!"}},{"$f":"I54/I55","v":{"$error":"#VALUE!"}},{"$f":"J54/J55","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"ANS Revenue",{"$f":"IFERROR('Basic Previously submitted data'!E23/F18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!F23/G18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!G23/H18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!H23/I18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!I23/J18,\"-      \")","v":"-      "},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"IFR flight hours",{"$f":"'Basic Previously submitted data'!E17","v":0},{"$f":"'Basic Previously submitted data'!F17","v":0},{"$f":"'Basic Previously submitted data'!G17","v":0},{"$f":"'Basic Previously submitted data'!H17","v":0},{"$f":"'Basic Previously submitted data'!I17","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[null,null,"KPIs",null,null,{"$f":"Control!$E$20-4","v":2018},{"$f":"Control!$E$20-3","v":2019},{"$f":"Control!$E$20-2","v":2020},{"$f":"Control!$E$20-1","v":2021},{"$f":"Control!$E$20","v":2022},"2021-2022 AGR","2018-2022 CAGR"]
[null,null,"1 Unit cost",null,null,{"$f":"F62/F63","v":{"$error":"#VALUE!"}},{"$f":"G62/G63","v":{"$error":"#VALUE!"}},{"$f":"H62/H63","v":{"$error":"#VALUE!"}},{"$f":"I62/I63","v":{"$error":"#VALUE!"}},{"$f":"J62/J63","v":{"$error":"#VALUE!"}},{"$f":"J61/I61 -1","v":{"$error":"#VALUE!"}},{"$f":"(J61/F61)^(1/4) -1","v":{"$error":"#VALUE!"}}]
[{"$nulls":4},"Total Costs",{"$f":"IFERROR('Basic Previously submitted data'!E32/F18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!F32/G18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!G32/H18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!H32/I18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!I32/J18,\"-      \")","v":"-      "},{"$f":"J62/I62 -1","v":{"$error":"#VALUE!"}},{"$f":"(J62/F62)^(1/4) -1","v":{"$error":"#VALUE!"}}]
[{"$nulls":4},"IFR flight hours",{"$f":"'Basic Previously submitted data'!E33","v":0},{"$f":"'Basic Previously submitted data'!F33","v":0},{"$f":"'Basic Previously submitted data'!G33","v":0},{"$f":"'Basic Previously submitted data'!H33","v":0},{"$f":"'Basic Previously submitted data'!I33","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"2A ATCO employment costs",null,null,{"$f":"F65/F66","v":{"$error":"#VALUE!"}},{"$f":"G65/G66","v":{"$error":"#VALUE!"}},{"$f":"H65/H66","v":{"$error":"#VALUE!"}},{"$f":"I65/I66","v":{"$error":"#VALUE!"}},{"$f":"J65/J66","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"ATCO employment cost",{"$f":"IFERROR('Basic Previously submitted data'!E36/F18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!F36/G18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!G36/H18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!H36/I18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!I36/J18,\"-      \")","v":"-      "},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"ATCO hours",{"$f":"'Basic Previously submitted data'!E34","v":0},{"$f":"'Basic Previously submitted data'!F34","v":0},{"$f":"'Basic Previously submitted data'!G34","v":0},{"$f":"'Basic Previously submitted data'!H34","v":0},{"$f":"'Basic Previously submitted data'!I34","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"2B ATCO productivity",null,null,{"$f":"F68/F69","v":{"$error":"#DIV/0!"}},{"$f":"G68/G69","v":{"$error":"#DIV/0!"}},{"$f":"H68/H69","v":{"$error":"#DIV/0!"}},{"$f":"I68/I69","v":{"$error":"#DIV/0!"}},{"$f":"J68/J69","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"IFR flight hours",{"$f":"'Basic Previously submitted data'!E33","v":0},{"$f":"'Basic Previously submitted data'!F33","v":0},{"$f":"'Basic Previously submitted data'!G33","v":0},{"$f":"'Basic Previously submitted data'!H33","v":0},{"$f":"'Basic Previously submitted data'!I33","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"ATCO hours",{"$f":"'Basic Previously submitted data'!E34","v":0},{"$f":"'Basic Previously submitted data'!F34","v":0},{"$f":"'Basic Previously submitted data'!G34","v":0},{"$f":"'Basic Previously submitted data'!H34","v":0},{"$f":"'Basic Previously submitted data'!I34","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"2C Other costs per IFR flight hour",null,null,{"$f":"F71/F72","v":{"$error":"#VALUE!"}},{"$f":"G71/G72","v":{"$error":"#VALUE!"}},{"$f":"H71/H72","v":{"$error":"#VALUE!"}},{"$f":"I71/I72","v":{"$error":"#VALUE!"}},{"$f":"J71/J72","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"Other costs",{"$f":"IFERROR('Basic Previously submitted data'!E37/F18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!F37/G18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!G37/H18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!H37/I18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!I37/J18,\"-      \")","v":"-      "},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"IFR flight hours",{"$f":"'Basic Previously submitted data'!E33","v":0},{"$f":"'Basic Previously submitted data'!F33","v":0},{"$f":"'Basic Previously submitted data'!G33","v":0},{"$f":"'Basic Previously submitted data'!H33","v":0},{"$f":"'Basic Previously submitted data'!I33","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"2D Proportion of total costs made up of ATCO",null,null,{"$f":"F74/F75","v":{"$error":"#VALUE!"}},{"$f":"G74/G75","v":{"$error":"#VALUE!"}},{"$f":"H74/H75","v":{"$error":"#VALUE!"}},{"$f":"I74/I75","v":{"$error":"#VALUE!"}},{"$f":"J74/J75","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"ATCO employment cost",{"$f":"IFERROR('Basic Previously submitted data'!E36/F18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!F36/G18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!G36/H18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!H36/I18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!I36/J18,\"-      \")","v":"-      "},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"Total Costs",{"$f":"IFERROR('Basic Previously submitted data'!E32/F18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!F32/G18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!G32/H18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!H32/I18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!I32/J18,\"-      \")","v":"-      "},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,"3A Unit ATCO employment costs",null,null,{"$f":"F77/F78","v":{"$error":"#VALUE!"}},{"$f":"G77/G78","v":{"$error":"#VALUE!"}},{"$f":"H77/H78","v":{"$error":"#VALUE!"}},{"$f":"I77/I78","v":{"$error":"#VALUE!"}},{"$f":"J77/J78","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"ATCO employment cost",{"$f":"IFERROR('Basic Previously submitted data'!E36/F18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!F36/G18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!G36/H18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!H36/I18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!I36/J18,\"-      \")","v":"-      "},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"No. of ATCOs",{"$f":"'Basic Previously submitted data'!E38","v":0},{"$f":"'Basic Previously submitted data'!F38","v":0},{"$f":"'Basic Previously submitted data'!G38","v":0},{"$f":"'Basic Previously submitted data'!H38","v":0},{"$f":"'Basic Previously submitted data'!I38","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"3B Annual Working hours per ATCO in OPS",null,null,{"$f":"F80/F81","v":{"$error":"#DIV/0!"}},{"$f":"G80/G81","v":{"$error":"#DIV/0!"}},{"$f":"H80/H81","v":{"$error":"#DIV/0!"}},{"$f":"I80/I81","v":{"$error":"#DIV/0!"}},{"$f":"J80/J81","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"ATCO hours",{"$f":"'Basic Previously submitted data'!E34","v":0},{"$f":"'Basic Previously submitted data'!F34","v":0},{"$f":"'Basic Previously submitted data'!G34","v":0},{"$f":"'Basic Previously submitted data'!H34","v":0},{"$f":"'Basic Previously submitted data'!I34","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"No. of ATCOs",{"$f":"'Basic Previously submitted data'!E38","v":0},{"$f":"'Basic Previously submitted data'!F38","v":0},{"$f":"'Basic Previously submitted data'!G38","v":0},{"$f":"'Basic Previously submitted data'!H38","v":0},{"$f":"'Basic Previously submitted data'!I38","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"3C IFR hours per ATCO in OPS",null,null,{"$f":"F83/F84","v":{"$error":"#DIV/0!"}},{"$f":"G83/G84","v":{"$error":"#DIV/0!"}},{"$f":"H83/H84","v":{"$error":"#DIV/0!"}},{"$f":"I83/I84","v":{"$error":"#DIV/0!"}},{"$f":"J83/J84","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"IFR flight hours",{"$f":"'Basic Previously submitted data'!E33","v":0},{"$f":"'Basic Previously submitted data'!F33","v":0},{"$f":"'Basic Previously submitted data'!G33","v":0},{"$f":"'Basic Previously submitted data'!H33","v":0},{"$f":"'Basic Previously submitted data'!I33","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"No. of ATCOs",{"$f":"'Basic Previously submitted data'!E38","v":0},{"$f":"'Basic Previously submitted data'!F38","v":0},{"$f":"'Basic Previously submitted data'!G38","v":0},{"$f":"'Basic Previously submitted data'!H38","v":0},{"$f":"'Basic Previously submitted data'!I38","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"3D Ratio of frontline service staff to ATCO in OPS ",null,null,{"$f":"F86/F87","v":{"$error":"#DIV/0!"}},{"$f":"G86/G87","v":{"$error":"#DIV/0!"}},{"$f":"H86/H87","v":{"$error":"#DIV/0!"}},{"$f":"I86/I87","v":{"$error":"#DIV/0!"}},{"$f":"J86/J87","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"Frontline staff",{"$f":"'Basic Previously submitted data'!E40","v":0},{"$f":"'Basic Previously submitted data'!F40","v":0},{"$f":"'Basic Previously submitted data'!G40","v":0},{"$f":"'Basic Previously submitted data'!H40","v":0},{"$f":"'Basic Previously submitted data'!I40","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"No. of ATCOs",{"$f":"'Basic Previously submitted data'!E38","v":0},{"$f":"'Basic Previously submitted data'!F38","v":0},{"$f":"'Basic Previously submitted data'!G38","v":0},{"$f":"'Basic Previously submitted data'!H38","v":0},{"$f":"'Basic Previously submitted data'!I38","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"P1 ANS revenue per IFR flight hour",null,null,{"$f":"F89/F90","v":{"$error":"#VALUE!"}},{"$f":"G89/G90","v":{"$error":"#VALUE!"}},{"$f":"H89/H90","v":{"$error":"#VALUE!"}},{"$f":"I89/I90","v":{"$error":"#VALUE!"}},{"$f":"J89/J90","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"ANS Revenue",{"$f":"IFERROR('Basic Previously submitted data'!E39/F18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!F39/G18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!G39/H18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!H39/I18,\"-      \")","v":"-      "},{"$f":"IFERROR('Basic Previously submitted data'!I39/J18,\"-      \")","v":"-      "},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"IFR flight hours",{"$f":"'Basic Previously submitted data'!E33","v":0},{"$f":"'Basic Previously submitted data'!F33","v":0},{"$f":"'Basic Previously submitted data'!G33","v":0},{"$f":"'Basic Previously submitted data'!H33","v":0},{"$f":"'Basic Previously submitted data'!I33","v":0},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[null,null,"KPIs",null,null,{"$f":"Control!$E$20-4","v":2018},{"$f":"Control!$E$20-3","v":2019},{"$f":"Control!$E$20-2","v":2020},{"$f":"Control!$E$20-1","v":2021},{"$f":"Control!$E$20","v":2022},"2021-2022 AGR","2018-2022 CAGR"]
[null,null,"1 Unit cost",null,null,{"$f":"F97/F98","v":{"$error":"#VALUE!"}},{"$f":"G97/G98","v":{"$error":"#VALUE!"}},{"$f":"H97/H98","v":{"$error":"#VALUE!"}},{"$f":"I97/I98","v":{"$error":"#VALUE!"}},{"$f":"J97/J98","v":{"$error":"#VALUE!"}},{"$f":"J96/I96 -1","v":{"$error":"#VALUE!"}},{"$f":"(J96/F96)^(1/4) -1","v":{"$error":"#VALUE!"}}]
[{"$nulls":4},"Total Costs",{"$f":"F27+F62","v":{"$error":"#VALUE!"}},{"$f":"G27+G62","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"J97/I97 -1","v":{"$error":"#VALUE!"}},{"$f":"(J97/F97)^(1/4) -1","v":{"$error":"#VALUE!"}}]
[{"$nulls":4},"IFR flight hours",{"$f":"F28+F63","v":0},0,0,0,0,{"$error":"#DIV/0!"},{"$f":"(J98/F98)^(1/4) -1","v":{"$error":"#DIV/0!"}}]
[null,null,"2A ATCO employment costs",null,null,{"$f":"F100/F101","v":{"$error":"#VALUE!"}},{"$f":"G100/G101","v":{"$error":"#VALUE!"}},{"$f":"H100/H101","v":{"$error":"#VALUE!"}},{"$f":"I100/I101","v":{"$error":"#VALUE!"}},{"$f":"J100/J101","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"ATCO employment cost",{"$f":"F30+F65","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"ATCO hours",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"2B ATCO productivity",null,null,{"$f":"F103/F104","v":{"$error":"#DIV/0!"}},{"$f":"G103/G104","v":{"$error":"#DIV/0!"}},{"$f":"H103/H104","v":{"$error":"#DIV/0!"}},{"$f":"I103/I104","v":{"$error":"#DIV/0!"}},{"$f":"J103/J104","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"IFR flight hours",{"$f":"F33+F68","v":0},0,{"$f":"H33+H68","v":0},0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"ATCO hours",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"2C Other costs per IFR flight hour",null,null,{"$f":"F106/F107","v":{"$error":"#VALUE!"}},{"$f":"G106/G107","v":{"$error":"#VALUE!"}},{"$f":"H106/H107","v":{"$error":"#VALUE!"}},{"$f":"I106/I107","v":{"$error":"#VALUE!"}},{"$f":"J106/J107","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"Other costs",{"$f":"F36+F71","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"IFR flight hours",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"2D Proportion of total costs made up of ATCO",null,null,{"$f":"F109/F110","v":{"$error":"#VALUE!"}},{"$f":"G109/G110","v":{"$error":"#VALUE!"}},{"$f":"H109/H110","v":{"$error":"#VALUE!"}},{"$f":"I109/I110","v":{"$error":"#VALUE!"}},{"$f":"J109/J110","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"ATCO employment cost",{"$f":"F39+F74","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"Total Costs",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,"3A Unit ATCO employment costs",null,null,{"$f":"F112/F113","v":{"$error":"#VALUE!"}},{"$f":"G112/G113","v":{"$error":"#VALUE!"}},{"$f":"H112/H113","v":{"$error":"#VALUE!"}},{"$f":"I112/I113","v":{"$error":"#VALUE!"}},{"$f":"J112/J113","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"ATCO employment cost",{"$f":"F42+F77","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"No. of ATCOs",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"3B Annual Working hours per ATCO in OPS",null,null,{"$f":"F115/F116","v":{"$error":"#DIV/0!"}},{"$f":"G115/G116","v":{"$error":"#DIV/0!"}},{"$f":"H115/H116","v":{"$error":"#DIV/0!"}},{"$f":"I115/I116","v":{"$error":"#DIV/0!"}},{"$f":"J115/J116","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"ATCO hours",{"$f":"F45+F80","v":0},0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"No. of ATCOs",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"3C IFR hours per ATCO in OPS",null,null,{"$f":"F118/F119","v":{"$error":"#DIV/0!"}},{"$f":"G118/G119","v":{"$error":"#DIV/0!"}},{"$f":"H118/H119","v":{"$error":"#DIV/0!"}},{"$f":"I118/I119","v":{"$error":"#DIV/0!"}},{"$f":"J118/J119","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"IFR flight hours",{"$f":"F48+F83","v":0},0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"No. of ATCOs",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"3D Ratio of frontline service staff to ATCO in OPS ",null,null,{"$f":"F121/F122","v":{"$error":"#DIV/0!"}},{"$f":"G121/G122","v":{"$error":"#DIV/0!"}},{"$f":"H121/H122","v":{"$error":"#DIV/0!"}},{"$f":"I121/I122","v":{"$error":"#DIV/0!"}},{"$f":"J121/J122","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"Frontline staff",{"$f":"F51+F86","v":0},0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[{"$nulls":4},"No. of ATCOs",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,null,"P1 ANS revenue per IFR flight hour",null,null,{"$f":"F124/F125","v":{"$error":"#VALUE!"}},{"$f":"G124/G125","v":{"$error":"#VALUE!"}},{"$f":"H124/H125","v":{"$error":"#VALUE!"}},{"$f":"I124/I125","v":{"$error":"#VALUE!"}},{"$f":"J124/J125","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"ANS Revenue",{"$f":"F54+F89","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[{"$nulls":4},"IFR flight hours",0,0,0,0,0,{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]

{"sheet":"Advanced Input 1","index":9,"n_rows":101,"n_cols":11,"rows_kept":101}
{"$rows_empty":7}
[null,null,{"$f":"COUNTA(K18,K20:K21, K23, K30, K42, K46:K47, K55:K57, K76:K77, K81, K92, K94, K101,K35,K37,K32)/COUNTA(F18,F35,F37,F20:F21, F23, F30:J30, F42, F46:F47, F55:F57, F76:F77, F81, F92, F94, F101, F32)","v":{"v":0,"d":"0%"}}]
[null,null,{"$f":"COUNTA(K18, K20:K21, K23, K31, K33, K42, K46, K48, K62:K64, K76:K77, K81, K93, K95, K101,K36,K38)/COUNTA(F18, F20:J21, F23, F31,F36,F38, F33, F42, F46, F48, F62:F64, F76:F77, F81, F93, F95, F101)","v":{"v":0,"d":"0%"}}]
[]
[]
[]
[]
[]
[]
[{"$nulls":5},"Productivity",{"$f":"Control!$E$20-4","v":2018},{"$f":"Control!$E$20-3","v":2019},{"$f":"Control!$E$20-2","v":2020},{"$f":"Control!$E$20-1","v":2021},{"$f":"Control!$E$20","v":2022}]
[{"$nulls":5},"En-route IFR flight hours",{"$nulls":4},{"$f":"'Input sheet'!F28+'Input sheet'!G28","v":0}]
[{"$nulls":5},"En-route VFR flight hours"]
[{"$nulls":5},"En-route ATCO in operations hours",{"$nulls":4},{"$f":"'Input sheet'!F27+'Input sheet'!G27","v":0}]
[{"$nulls":5},"Terminal ATCO in operations hours"]
[{"$nulls":5},"Tower ATCO in operations hours"]
[{"$nulls":5},"Combined Tower + Terminal ATCO in operations hours",{"$nulls":4},{"$f":"K21+K20","v":0}]
[{"$nulls":5},"Total ATCO in operations hours"]
[]
[]
[{"$nulls":5},"Activity",{"$f":"Control!$E$20-4","v":2018},{"$f":"Control!$E$20-3","v":2019},{"$f":"Control!$E$20-2","v":2020},{"$f":"Control!$E$20-1","v":2021},{"$f":"Control!$E$20","v":2022}]
[{"$nulls":5},"IFR flight hours (continental)",{"$nulls":4},{"$f":"'Input sheet'!F17","v":0}]
[{"$nulls":5},"IFR flight hours (oceanic)",{"$nulls":4},{"$f":"'Input sheet'!G17","v":0}]
[{"$nulls":5},"Total IFR flight hours",{"$nulls":4},{"$f":"K27+K28","v":0}]
[{"$nulls":5},"IFR airport movements controlled by ANSP (continental)"]
[{"$nulls":5},"Movement include switch (Eurocontrol countries) (1 or blank - see definition)"]
[{"$nulls":5},"IFR kilometres (continental)"]
[{"$nulls":5},"IFR kilometres (oceanic)"]
[{"$nulls":5},"Total IFR kilometres",{"$nulls":4},{"$f":"K32+K33","v":0}]
[{"$nulls":5},"IFR tonne hours (continental)"]
[{"$nulls":5},"IFR tonne hours (oceanic)"]
[{"$nulls":5},"IFR tonne km (continental)"]
[{"$nulls":5},"IFR tonne km (oceanic)"]
[]
[{"$nulls":5},"Staffing",{"$f":"Control!$E$20-4","v":2018},{"$f":"Control!$E$20-3","v":2019},{"$f":"Control!$E$20-2","v":2020},{"$f":"Control!$E$20-1","v":2021},{"$f":"Control!$E$20","v":2022}]
[]
[{"$nulls":5},"Total staff number (expressed in FTE)"]
[{"$nulls":5},"Number of ATCOs in operations (continental) (expressed in FTE)",{"$nulls":4},{"$f":"'Input sheet'!F22","v":0}]
[{"$nulls":5},"Number of ATCOs in operations (oceanic) (expressed in FTE)",{"$nulls":4},{"$f":"'Input sheet'!G22","v":0}]
[{"$nulls":5},"Total ATCOs in operations (expressed in FTE)",{"$nulls":4},{"$f":"K43+K44","v":0}]
[{"$nulls":5},"Average annual working hours for ATCO in operations"]
[{"$nulls":5},"Average annual working hours for ATCO in operations (continental)"]
[{"$nulls":5},"Average annual working hours for ATCO in operations (oceanic)"]
[{"$nulls":5},"Total ATCO in operations hours",{"$nulls":4},{"$f":"K50+K51","v":0}]
[{"$nulls":5},"Total ATCO in operations hours (continental)",{"$nulls":4},{"$f":"'Input sheet'!F18","v":0}]
[{"$nulls":5},"Total ATCO in operations hours (oceanic)",{"$nulls":4},{"$f":"'Input sheet'!G18","v":0}]
[]
[{"$nulls":5},"Continental Costs",{"$f":"Control!$E$20-4","v":2018},{"$f":"Control!$E$20-3","v":2019},{"$f":"Control!$E$20-2","v":2020},{"$f":"Control!$E$20-1","v":2021},{"$f":"Control!$E$20","v":2022}]
[]
[{"$nulls":5},"Operating costs (continental)"]
[{"$nulls":5},"Cost of capital (continental)"]
[{"$nulls":5},"Depreciation/amortization (continental)"]
[{"$nulls":5},"Total costs (continental)",{"$nulls":4},{"$f":"'Input sheet'!$F$16","v":0}]
[]
[{"$nulls":5},"Oceanic Costs",{"$f":"Control!$E$20-4","v":2018},{"$f":"Control!$E$20-3","v":2019},{"$f":"Control!$E$20-2","v":2020},{"$f":"Control!$E$20-1","v":2021},{"$f":"Control!$E$20","v":2022}]
[]
[{"$nulls":5},"Operating costs (oceanic)"]
[{"$nulls":5},"Cost of capital (oceanic)"]
[{"$nulls":5},"Depreciation/amortization (oceanic)"]
[{"$nulls":5},"Total costs (oceanic)",{"$nulls":4},{"$f":"'Input sheet'!$G$16","v":0}]
[]
[{"$nulls":5},"Total Costs",{"$f":"Control!$E$20-4","v":2018},{"$f":"Control!$E$20-3","v":2019},{"$f":"Control!$E$20-2","v":2020},{"$f":"Control!$E$20-1","v":2021},{"$f":"Control!$E$20","v":2022}]
[]
[{"$nulls":5},"Total Air Navigation Service cost",{"$nulls":4},{"$f":"K70+K75","v":0}]
[{"$nulls":5},"Total costs (continental and oceanic)",{"$nulls":4},{"$f":"K65+K58","v":0}]
[{"$nulls":5},"Total operating cost",{"$nulls":4},{"$f":"K62+K55","v":0}]
[{"$nulls":5},"Total cost of capital",{"$nulls":4},{"$f":"K63+K56","v":0}]
[{"$nulls":5},"Total depreciation/amortization",{"$nulls":4},{"$f":"K64+K57","v":0}]
[{"$nulls":5},"Total cost of capital and depreciation",{"$nulls":4},{"$f":"K72+K73","v":0}]
[{"$nulls":5},"Total costs (other)",{"$nulls":4},{"$f":"K76+K77","v":0}]
[{"$nulls":5},"Regulatory cost"]
[{"$nulls":5},"Other unique cost"]
[]
[{"$nulls":5},"Employment",{"$f":"Control!$E$20-4","v":2018},{"$f":"Control!$E$20-3","v":2019},{"$f":"Control!$E$20-2","v":2020},{"$f":"Control!$E$20-1","v":2021},{"$f":"Control!$E$20","v":2022}]
[]
[{"$nulls":5},"Total employment cost"]
[{"$nulls":5},"Employment cost for ATCOs in operations (continental)",{"$nulls":4},{"$f":"'Input sheet'!F20","v":0}]
[{"$nulls":5},"Employment cost for ATCOs in operations (oceanic)",{"$nulls":4},{"$f":"'Input sheet'!G20","v":0}]
[{"$nulls":5},"Total employment cost for ATCOs in operations",{"$nulls":4},{"$f":"K82+K83","v":0}]
[]
[{"$nulls":5},"Revenue",{"$f":"Control!$E$20-4","v":2018},{"$f":"Control!$E$20-3","v":2019},{"$f":"Control!$E$20-2","v":2020},{"$f":"Control!$E$20-1","v":2021},{"$f":"Control!$E$20","v":2022}]
[]
[{"$nulls":5},"Total ANS revenue (continental)",{"$nulls":4},{"$f":"'Input sheet'!F23","v":0}]
[{"$nulls":5},"Total ANS revenue (oceanic)",{"$nulls":4},{"$f":"'Input sheet'!G23","v":0}]
[{"$nulls":5},"Total ANS revenue",{"$nulls":4},{"$f":"K88+K89","v":0}]
[{"$nulls":5},"Assets and Capital Expenditure",{"$f":"Control!$E$20-4","v":2018},{"$f":"Control!$E$20-3","v":2019},{"$f":"Control!$E$20-2","v":2020},{"$f":"Control!$E$20-1","v":2021},{"$f":"Control!$E$20","v":2022}]
[{"$nulls":5},"Capital expenditure (continental)"]
[{"$nulls":5},"Capital expenditure (oceanic)"]
[{"$nulls":5},"NBV of fixed assets (continental end of year figure)"]
[{"$nulls":5},"NBV of fixed assets (oceanic end of year figure)"]
[]
[{"$nulls":5},"Other",{"$f":"Control!$E$20-4","v":2018},{"$f":"Control!$E$20-3","v":2019},{"$f":"Control!$E$20-2","v":2020},{"$f":"Control!$E$20-1","v":2021},{"$f":"Control!$E$20","v":2022}]
[]
[{"$nulls":5},"Example consolidated price per 1000 km flight for A320",{"$nulls":4},{"$f":"'Input sheet'!F24","v":0}]
[{"$nulls":5},"Example consolidated price per 250 km flight for ATR72",{"$nulls":4},{"$f":"'Input sheet'!F25","v":0}]
[{"$nulls":5},"Comments on example prices"]

{"sheet":"Advanced Input 2","index":10,"n_rows":61,"n_cols":11,"rows_kept":61}
{"$rows_empty":7}
[null,null,{"$f":"COUNTA(K15:K20,K23:K24,K29:K36, K38:K43,K46:K52)/COUNTA(F15:F20,F23:F24,F29:F36, F38:F43,F46:F52)","v":{"v":0,"d":"0%"}}]
[]
[]
[]
[]
[]
[{"$nulls":5},"Operational Data",{"$f":"Control!$E$20-4","v":2018},{"$f":"Control!$E$20-3","v":2019},{"$f":"Control!$E$20-2","v":2020},{"$f":"Control!$E$20-1","v":2021},{"$f":"Control!$E$20","v":2022}]
[{"$nulls":5},"Average flight hours per flight (decimal hours, continental) "]
[{"$nulls":5},"IFR tower movements (take-offs and landings only)"]
[{"$nulls":5},"VFR tower movements at ATCO attended aerodromes (controlled)"]
[{"$nulls":5},"VFR tower movements at aerodromes where an ANSP service other than ATC is provided (uncontrolled)"]
[]
[]
[{"$nulls":5},"Total VFR tower movements ",{"$nulls":4},{"$f":"SUM(K17:K18)","v":0}]
[{"$nulls":5},"En-route VFR flight hours",{"$nulls":4},{"$f":"K23+K24","v":0}]
[{"$nulls":5},"Total controlled VFR hours "]
[{"$nulls":5},"Total not controlled VFR hours"]
[]
[]
[{"$nulls":5},"Workforce",{"$f":"Control!$E$20-4","v":2018},{"$f":"Control!$E$20-3","v":2019},{"$f":"Control!$E$20-2","v":2020},{"$f":"Control!$E$20-1","v":2021},{"$f":"Control!$E$20","v":2022}]
[{"$nulls":5},"Number of ATCOs in operations (expressed in FTE)",{"$nulls":4},{"$f":"'Input sheet'!F22","v":0}]
[{"$nulls":5},"ATCOs in ACCs (expressed in FTE)"]
[{"$nulls":5},"ATCOs in terminal/ACCs (expressed in FTE)"]
[{"$nulls":5},"Approximate en-route ATCOs in terminal/ACCs (expressed in FTE)"]
[{"$nulls":5},"Approximate approach ATCOs in terminal/ACCs (expressed in FTE)"]
[{"$nulls":5},"ATCOs in terminal (expressed in FTE)"]
[{"$nulls":5},"ATCOs in combined terminal/tower (expressed in FTE)"]
[{"$nulls":5},"ATCOs in tower (expressed in FTE)"]
[{"$nulls":5},"ATCOs in combined ACC/tower/terminal (expressed in FTE)"]
[{"$nulls":5},"Number of Frontline Service Support Staff (expressed in FTE)",{"$nulls":4},{"$f":"'Input sheet'!$F$26+'Input sheet'!$G$26","v":0}]
[{"$nulls":5},"ATC assistants (expressed in FTE)"]
[{"$nulls":5},"OPS support (non-ATCOS) (expressed in FTE)"]
[{"$nulls":5},"Technical support staff for operational maintenance, monitoring and control (expressed in FTE)"]
[{"$nulls":5},"Technical support staff for planning and development (expressed in FTE)"]
[{"$nulls":5},"ATCOs on other duties (expressed in FTE)"]
[{"$nulls":5},"Outsourced Frontline Service Support (expressed in FTE)"]
[]
[{"$nulls":5},"Costs",{"$f":"Control!$E$20-4","v":2018},{"$f":"Control!$E$20-3","v":2019},{"$f":"Control!$E$20-2","v":2020},{"$f":"Control!$E$20-1","v":2021},{"$f":"Control!$E$20","v":2022}]
[{"$nulls":5},"Other Frontline support staff - Employment costs"]
[{"$nulls":5},"ATC assistants - Employment costs"]
[{"$nulls":5},"OPS support - Employment costs"]
[{"$nulls":5},"Technical support staff for operational maintenance,\nmonitoring and control - Employment costs"]
[{"$nulls":5},"Technical support staff for planning and development - Employment costs"]
[{"$nulls":5},"ATCOs on other duties - \nEmployment costs"]
[{"$nulls":5},"Outsourced Frontline Service Support costs"]
[{"$nulls":5},"Total operating cost",{"$nulls":4},{"$f":"'Advanced Input 1'!K71","v":0}]
[{"$nulls":5},"Operating costs (continental)",{"$nulls":4},{"$f":"'Advanced Input 1'!K55","v":0}]
[{"$nulls":5},"Operating costs (oceanic)",{"$nulls":4},{"$f":"'Advanced Input 1'!K62","v":0}]
[{"$nulls":5},"Non employment related costs",{"$nulls":4},{"$f":"IF(K53>0,K53-K61,0)","v":0}]
[{"$nulls":5},"ATCO employment \ncost",{"$nulls":4},{"$f":"K58+K59","v":0}]
[{"$nulls":5},"Employment cost for ATCOs in operations (continental)",{"$nulls":4},{"$f":"'Advanced Input 1'!K82","v":0}]
[{"$nulls":5},"Employment cost for ATCOs in operations (oceanic)",{"$nulls":4},{"$f":"'Advanced Input 1'!K83","v":0}]
[{"$nulls":5},"All other employment costs",{"$nulls":4},{"$f":"IF(K61>0, K61-K57-SUM(K47:K52),0)","v":0}]
[{"$nulls":5},"Total employment cost",{"$nulls":4},{"$f":"'Advanced Input 1'!K81","v":0}]

{"sheet":"Advanced KPI output","index":11,"n_rows":43,"n_cols":9,"rows_kept":43,"merged":[[3,3,4,6],[6,3,8,6]]}
[]
[]
[]
[{"$nulls":3},"Advanced KPI Output"]
[]
[]
[{"$nulls":3},"This sheet shows the Advanced KPI outputs for current and previous years, calculated from the Advanced inputs."]
[]
[]
[]
[null,null,"Productivity",null,{"$f":"Control!$E$20-4","v":2018},{"$f":"Control!$E$20-3","v":2019},{"$f":"Control!$E$20-2","v":2020},{"$f":"Control!$E$20-1","v":2021},{"$f":"Control!$E$20","v":2022}]
[null,null,"En route productivity",null,{"$f":"E14/E13","v":{"$error":"#DIV/0!"}},{"$f":"F14/F13","v":{"$error":"#DIV/0!"}},{"$f":"G14/G13","v":{"$error":"#DIV/0!"}},{"$f":"H14/H13","v":{"$error":"#DIV/0!"}},{"$f":"I14/I13","v":{"$error":"#DIV/0!"}}]
[{"$nulls":3},"Total ATCO in ops hours allocated to en-route",{"$f":"'Advanced Input 1'!G19","v":0},{"$f":"'Advanced Input 1'!H19","v":0},{"$f":"'Advanced Input 1'!I19","v":0},{"$f":"'Advanced Input 1'!J19","v":0},{"$f":"'Advanced Input 1'!K19","v":0}]
[{"$nulls":3},"En-route IFR hours",{"$f":"'Advanced Input 1'!G17","v":0},{"$f":"'Advanced Input 1'!H17","v":0},{"$f":"'Advanced Input 1'!I17","v":0},{"$f":"'Advanced Input 1'!J17","v":0},{"$f":"'Advanced Input 1'!K17","v":0}]
[null,null,"En route productivity (VFR Adjusted)",null,{"$f":"E16/E13","v":{"$error":"#DIV/0!"}},{"$f":"F16/F13","v":{"$error":"#DIV/0!"}},{"$f":"G16/G13","v":{"$error":"#DIV/0!"}},{"$f":"H16/H13","v":{"$error":"#DIV/0!"}},{"$f":"I16/I13","v":{"$error":"#DIV/0!"}}]
[{"$nulls":3},"IFR flight hours + VFR flight hours (En-route)",{"$f":"'Advanced Input 1'!G18+E14","v":0},{"$f":"'Advanced Input 1'!H18+F14","v":0},{"$f":"'Advanced Input 1'!I18+G14","v":0},{"$f":"'Advanced Input 1'!J18+H14","v":0},{"$f":"'Advanced Input 1'!K18+I14","v":0}]
[null,null,"Terminal and tower productivity",null,{"$f":"E19/E18","v":{"$error":"#DIV/0!"}},{"$f":"F19/F18","v":{"$error":"#DIV/0!"}},{"$f":"G19/G18","v":{"$error":"#DIV/0!"}},{"$f":"H19/H18","v":{"$error":"#DIV/0!"}},{"$f":"I19/I18","v":{"$error":"#DIV/0!"}}]
[{"$nulls":3},"Total ATCO in ops hours allocated to terminal/tower",{"$f":"'Advanced Input 1'!G20+'Advanced Input 1'!G21","v":0},{"$f":"'Advanced Input 1'!H20+'Advanced Input 1'!H21","v":0},{"$f":"'Advanced Input 1'!I20+'Advanced Input 1'!I21","v":0},{"$f":"'Advanced Input 1'!J20+'Advanced Input 1'!J21","v":0},{"$f":"'Advanced Input 1'!K20+'Advanced Input 1'!K21","v":0}]
[{"$nulls":3},"IFR airport movements (take-off and landings)",{"$f":"'Advanced Input 2'!G16","v":0},{"$f":"'Advanced Input 2'!H16","v":0},{"$f":"'Advanced Input 2'!I16","v":0},{"$f":"'Advanced Input 2'!J16","v":0},{"$f":"'Advanced Input 2'!K16","v":0}]
[null,null,"Terminal and tower productivity (VFR adjusted)",null,{"$f":"E21/E18","v":{"$error":"#DIV/0!"}},{"$f":"F21/F18","v":{"$error":"#DIV/0!"}},{"$f":"G21/G18","v":{"$error":"#DIV/0!"}},{"$f":"H21/H18","v":{"$error":"#DIV/0!"}},{"$f":"I21/I18","v":{"$error":"#DIV/0!"}}]
[{"$nulls":3},"IFR +VFR airport movements (take-off and landings)",{"$f":"E19+'Advanced Input 2'!G21","v":0},{"$f":"F19+'Advanced Input 2'!H21","v":0},{"$f":"G19+'Advanced Input 2'!I21","v":0},{"$f":"H19+'Advanced Input 2'!J21","v":0},{"$f":"I19+'Advanced Input 2'!K21","v":0}]
[null,null,"Tower productivity",null,{"$f":"E24/E23","v":{"$error":"#DIV/0!"}},{"$f":"F24/F23","v":{"$error":"#DIV/0!"}},{"$f":"G24/G23","v":{"$error":"#DIV/0!"}},{"$f":"H24/H23","v":{"$error":"#DIV/0!"}},{"$f":"I24/I23","v":{"$error":"#DIV/0!"}}]
[{"$nulls":3},"Total ATCO in ops hours allocated to tower",{"$f":"'Advanced Input 1'!G21","v":0},{"$f":"'Advanced Input 1'!H21","v":0},{"$f":"'Advanced Input 1'!I21","v":0},{"$f":"'Advanced Input 1'!J21","v":0},{"$f":"'Advanced Input 1'!K21","v":0}]
[{"$nulls":3},"IFR airport movements (take-off and landings)",{"$f":"E19","v":0},{"$f":"F19","v":0},{"$f":"G19","v":0},{"$f":"H19","v":0},{"$f":"I19","v":0}]
[null,null,"Tower productivity (VFR adjusted)",null,{"$f":"E26/E23","v":{"$error":"#DIV/0!"}},{"$f":"F26/F23","v":{"$error":"#DIV/0!"}},{"$f":"G26/G23","v":{"$error":"#DIV/0!"}},{"$f":"H26/H23","v":{"$error":"#DIV/0!"}},{"$f":"I26/I23","v":{"$error":"#DIV/0!"}}]
[{"$nulls":3},"IFR +VFR airport movements (take-off and landings)",{"$f":"E21","v":0},{"$f":"F21","v":0},{"$f":"G21","v":0},{"$f":"H21","v":0},{"$f":"I21","v":0}]
[]
[null,null,"Frontline Services",null,{"$f":"Control!$E$20-4","v":2018},{"$f":"Control!$E$20-3","v":2019},{"$f":"Control!$E$20-2","v":2020},{"$f":"Control!$E$20-1","v":2021},{"$f":"Control!$E$20","v":2022}]
[null,null,"IFR flight hours per frontline service staff",null,{"$f":"E30/E31","v":{"$error":"#DIV/0!"}},{"$f":"F30/F31","v":{"$error":"#DIV/0!"}},{"$f":"G30/G31","v":{"$error":"#DIV/0!"}},{"$f":"H30/H31","v":{"$error":"#DIV/0!"}},{"$f":"I30/I31","v":{"$error":"#DIV/0!"}}]
[{"$nulls":3},"IFR flight hours",{"$f":"'Advanced Input 1'!G29","v":0},{"$f":"'Advanced Input 1'!H29","v":0},{"$f":"'Advanced Input 1'!I29","v":0},{"$f":"'Advanced Input 1'!J29","v":0},{"$f":"'Advanced Input 1'!K29","v":0}]
[{"$nulls":3},"Other frontline support staff ",{"$f":"'Advanced Input 2'!G37","v":0},{"$f":"'Advanced Input 2'!H37","v":0},{"$f":"'Advanced Input 2'!I37","v":0},{"$f":"'Advanced Input 2'!J37","v":0},{"$f":"'Advanced Input 2'!K37","v":0}]
[null,null,"IFR flight hours per ATCO in operations",null,{"$f":"E33/E34","v":{"$error":"#DIV/0!"}},{"$f":"F33/F34","v":{"$error":"#DIV/0!"}},{"$f":"G33/G34","v":{"$error":"#DIV/0!"}},{"$f":"H33/H34","v":{"$error":"#DIV/0!"}},{"$f":"I33/I34","v":{"$error":"#DIV/0!"}}]
[{"$nulls":3},"IFR flight hours",{"$f":"E30","v":0},{"$f":"F30","v":0},{"$f":"G30","v":0},{"$f":"H30","v":0},{"$f":"I30","v":0}]
[{"$nulls":3},"ATCOs in operations",{"$f":"'Advanced Input 1'!G45","v":0},{"$f":"'Advanced Input 1'!H45","v":0},{"$f":"'Advanced Input 1'!I45","v":0},{"$f":"'Advanced Input 1'!J45","v":0},{"$f":"'Advanced Input 1'!K45","v":0}]
[null,null,"Frontline Service staff to ATCO in operations ratio",null,{"$f":"E36/E37","v":{"$error":"#DIV/0!"}},{"$f":"F36/F37","v":{"$error":"#DIV/0!"}},{"$f":"G36/G37","v":{"$error":"#DIV/0!"}},{"$f":"H36/H37","v":{"$error":"#DIV/0!"}},{"$f":"I36/I37","v":{"$error":"#DIV/0!"}}]
[{"$nulls":3},"Other frontline support staff ",{"$f":"E31","v":0},{"$f":"F31","v":0},0,0,{"$f":"I31","v":0}]
[{"$nulls":3},"ATCOs in operations",{"$f":"E34","v":0},{"$f":"F34","v":0},{"$f":"G34","v":0},{"$f":"H34","v":0},{"$f":"I34","v":0}]
[]
[null,null,"IFR Tonne",{"$f":"Control!$E$20","v":2022}]
[null,null,"IFR tonne hour (continental)",{"$f":"'Advanced Input 1'!K35","v":0}]
[null,null,"IFR tonne hour (oceanic)",{"$f":"'Advanced Input 1'!K36","v":0}]
[null,null,"IFR tonne kilometers (continental)",{"$f":"'Advanced Input 1'!K37","v":0}]
[null,null,"IFR tonne kilometers (oceanic)",{"$f":"'Advanced Input 1'!K38","v":0}]

{"sheet":"Data Definitions","index":12,"n_rows":113,"n_cols":7,"rows_kept":113,"merged":[[7,4,7,5],[8,4,8,5],[10,2,20,2],[10,3,13,3],[12,8,12,10],[14,3,15,3],[16,3,18,3],[19,3,20,3],[21,2,24,3],[25,2,25,3],[26,2,34,3],[35,2,59,2],[35,3,40,3],[41,3,43,3],[45,3,48,3],[49,3,52,3],[53,3,56,3],[57,3,59,3],[60,2,67,3],[68,2,72,3],[73,2,74,3],[75,2,97,2],[75,3,82,3],[83,3,97,3],[99,2,108,2],[99,3,108,3],[99,6,105,6],[110,2,112,3]]}
{"$rows_empty":7}
[{"$nulls":4},"Defintions in orange refer to data points collected within the input sheet for Basic input."]
[{"$nulls":4},"Definitions in grey signify summary data points that are the sum of two or more related data elements."]
[{"$nulls":4},"Data Element","Definition","Reference"]
[null,null,"Activity","Flight Hours","Total IFR flight hours (continental)","The sum of IFR flight-hours (non-oceanic) controlled by an ANSP's en-route centers (ACC) and approach control centers (APP). For any given flight, the flight-hours controlled are derived from the difference between the entry time and the exit time (as derived from the last Flight Plan received) in the controlled airspace. Where measurement entry time and exit time differ from wheels-up and wheels-down, the ANSP may apply a factor of one minute per continental arrival and departure. (Revised from two minutes to 1 minute May 2007 based on clarification from Eurocontrol and ASG).","D16 Continental ANS (process will add 1 minute per arrival and departure)"]
[{"$nulls":4},"Total IFR flight hours (oceanic)","The sum of oceanic IFR flight-hours controlled by an ANSP's en-route centers (ACC). For any given flight, the flight-hours controlled are derived from the difference between the entry time and the exit time (as derived from the last Flight Plan received) in the oceanic controlled airspace.","D16 Oceanic ANS"]
[{"$nulls":4},"Total IFR flight hours","Total number of controlled IFR flight hours in continental and oceanic airspace."]
[{"$nulls":4},"En-route IFR flight hours ","The time an aircraft is controlled by an ANSP outside of the terminal area. It is calculated as the difference between Total IFR flight hours and Terminal IFR flight hours, where Terminal IFR flight hours is equal to 12.5 * (total movements/60). This calculation assumes that aircraft spends on average 12.5 minutes in the Terminal Control Area. "]
[{"$nulls":3},"Movements","IFR airport movements controlled by ANSP (continental)","The number of movements, arrivals and departures at all controlled facilities for the ANSP.  This number will be used to add 1 minute to the IFR hours for ANSPs that do not record IFR hours from take-off to touch-down.","D18 (Terminal)"]
[{"$nulls":4},"Movement include switch (Eurocontrol countries)","Enter 1 in this column indicate the 1 minute adjustment has been applied, otherwise leave blank."]
[{"$nulls":3},"Kilometres","IFR kilometres (continental)","The sum of IFR non-oceanic kilometers controlled by an ANSP within continental (non-oceanic) airspace.","D36 (ACC's)"]
[{"$nulls":4},"IFR kilometres (oceanic)","The sum of IFR kilometers controlled by an ANSP within oceanic airspace. Note: oceanic airspace controlled by an ANSP has defined dimensions, for example ICAO designated oceanic area.","D36 (Oceanic)"]
[{"$nulls":4},"Total IFR kilometres","Total number of controlled IFR kilometers in continental and oceanic airspace."]
[{"$nulls":3},"IFR t.","IFR tonne hours","The sum of the tonne hours for all flights. For one flight the tonne hours is flight duration x MTOW (of that aircraft)"]
[{"$nulls":4},"IFR tonne km","The sum of the tonne km for all flights. For one flight the tonne km is flight distance x MTOW (of that aircraft)"]
[null,null,"Staffing (FTE)",null,"Total staff number (expressed in FTE)","Total number of staff (expressed in FTE).\n\nFull Time Equivalent (FTE): The equivalent of a single person carrying out a particular job or activity working on a full time basis during a year. A staff member who works part time, say half the hours of a normal employee, should be counted as half (0.5FTE) when assessing FTE staff numbers. ","C1 (En-route + terminal ANS)"]
[{"$nulls":4},"Number of ATCOs in operations (continental) (expressed in FTE)","See \"Total number of ATCOs in operations (expressed in FTE)\" below","C4 (Total en-route + terminal ANS)"]
[{"$nulls":4},"Number of ATCOs in operations (oceanic) (expressed in FTE)","See \"Total number of ATCOs in operations (expressed in FTE)\" below","C4 (Other ANS)"]
[{"$nulls":4},"Total number of ATCOs in operations (expressed in FTE)","The number (expressed in FTE) of ATCOs who are participating in an activity that is either directly related to the control of traffic or is a necessary requirement for ATCOs to be able to control traffic. Such activities include manning a position, refresher training and supervising on the job trainee controllers, but do not include participating in special projects, teaching at a training academy, or providing instruction in a simulator. Includes first-line supervisors. Does not include on-the-job training. An ATCO in operations should hold a valid ATCO license. \n\nThe number (expressed in FTE) should be calculated as an average based on the FTE number at the start of the year and the FTE number at the end of the year.\n\nDefinition of Full Time Equivalent (FTE) (Source: EUROCONTROL Specification for Information Disclosure – Version 2, October 2001): The equivalent of a single person carrying out a particular job or activity working on a full time basis during a year. A part time ATCO working half the hours of a normal ATCO, should be counted as a 0.5FTE. A full time ATCO working two thirds of his time on duty in OPS and one third of his time on teaching at a training academy would be counted as a 0.67 FTE ATCO in OPS and a 0.33 FTE ATCO on other duties."]
[null,null,"Staffing (actual headcount)",null,"Total number of ATCOs in operations (expressed in actual headcount, not FTE)","This number is not used in KPI framework and is collected only for information.\n\nThe actual number of ATCOs, expressed in actual number of people employed (actual headcount, not FTE), who are participating in an activity that is either directly related to the control of traffic or is a necessary requirement for ATCOs to be able to control traffic. These activities are the same as those listed in \"Total number of ATCOs in operations\" defintion above. \n\nThe actual number (headcount) of ATCOs in operations should be calculated as an average based on the actual number (headcount) at the start of the year and the actual number (headcount) at the end of the year."]
[null,null,"ATCO in operation hours",null,"Average annual working hours for ATCO in operations","Average of annual working hours for ATCO in operations in continental and oceanic.\n\nAverage annual working hours is the number of hours “ATCO in operations” spend on duty in operations, including breaks and overtime in operations. This figure could be available from a time recording system (using for example first clock-in and last clock-out times); it could be computed from the roster plan; or it could be calculated by adding the average overtime worked in operations to the contractual working hours and subtracting the average time an ATCO is not on duty in operations.","Average of Average Annual Working Hours for ATCOs in Operations (Continental)+(Oceanic)"]
[{"$nulls":4},"Average annual working hours for ATCO in operations (continental)","Same as above, but for continental ATCOs only","Sum (D22 (ACC(s) and APPs + TWR)) / sum (D21 (ACC(s) and APPs + TWR)) or D34 (Continental)"]
[{"$nulls":4},"Average annual working hours for ATCO in operations (oceanic)","Same as above, but for oceanic ATCOs only","D34 (Oceanic)"]
[{"$nulls":4},"Total ATCO in operations hours","\"Average annual working hours for ATCO in operations\" times the \"Total number of ATCOs in operations (expressed in FTE)\"","Formula: Sum of ATCOs in operations (continental) and ATCOs in operations (oceanic)"]
[{"$nulls":4},"Total ATCO in operations hours (continental)","\"Average annual working hours for ATCOs in operations\" times the \"Number of ATCOs in operations (continental) (expressed in FTE)\"","C4 (Total en-route + terminal ANS)"]
[{"$nulls":4},"Total ATCO in operations hours (oceanic)","\"Average annual working hours for ATCOs in operations\" times the \"Number of ATCOs in operations (oceanic) (expressed in FTE)\""]
[{"$nulls":4},"Total ATCO in operations overtime hours","The sum of \"Total ATCO in operation overtime hours (continental)\" and \"Total ATCO in operation overtime hours (oceanic)\"."]
[{"$nulls":4},"Total ATCO in operations overtime hours (continental)","The total time during which an “ATCO in OPS” is on duty in OPS in addition to the contractual working hours (continental) "]
[{"$nulls":4},"Total ATCO in operations overtime hours (oceanicl)","The total time during which an “ATCO in OPS” is on duty in OPS in addition to the contractual working hours (oceanic)","C4 (Other ANS)"]
[null,null,"Financial data","Total","Total Air Navigation Service cost","All costs incurred by the ANSP. Includes continental and oceanic operating costs, depreciation/amortization costs, and cost of capital, as well as regulatory costs and other unique costs. ","Formula: Sum of Total costs (other) and Total costs (continental) and Total costs (oceanic)"]
[{"$nulls":4},"Total costs (continental and oceanic)","The sum of \"Total costs (continental)\" and \"Total costs (oceanic)\".","Formula:  Sum of Total costs (continental) and Total costs (oceanic)"]
[{"$nulls":4},"Total operating cost","The sum of \"Operating costs (continental)\" and \"Operating costs (oceanic)\"","Formula:  Sum of Operating costs (continental) and Operating costs (oceanic)"]
[{"$nulls":4},"Total cost of capital","The sum of the \"Cost of capital (continental)\" and \"Cost of capital (oceanic)\"","Formula:  Sum of Cost of capital (continental) and Cost of capital (oceanic)"]
[{"$nulls":4},"Total depreciation/amortization","The sum of \"Depreciation/amortization (continental)\" and \"Depreciation/amortization (oceanic)\"","Formula:  Sum of Depreciation/amortization (continental) and Depreciation/amortization (oceanic)"]
[{"$nulls":4},"Total cost of capital and depreciation","The sum of the above two entries","Formula:  Sum of Total cost of capital and Total depreciation/amortization"]
[{"$nulls":3},"Other","Total costs (other)","Costs not directly related to providing ATC services. The sum of \"Regulatory costs\" and \"Other unique costs\". Should also equal \"Total Air Navigation Services cost\" minus \"Continental and oceanic cost of capital\", \"Depreciation/amortization\", and \"Operating costs\".","Formula:  Sum of Regulatory cost and Other unique cost"]
[{"$nulls":4},"Regulatory cost","Cost of services provided by the national government or other governing bodies for services such as regulatory functions and general and administrative support.","A21 - A27 (En-route + Terminal + Other ANS)"]
[{"$nulls":4},"Other unique cost","Internal ANSP costs, such as flight services and meteorological costs that are not otherwise captured by cost of capital, depreciation/amortization, operating, and/or regulatory costs. ","A28: MET Cost (Total ANS)"]
[{"$nulls":4},"Total costs (continental and oceanic)","The sum of Total costs (continental) and Total costs (oceanic)."]
[{"$nulls":3},"Continental costs","Total costs (continental)","The sum of operating costs, depreciation/amortization, and cost of capital related to providing continental ATC/ATFM services. Exceptional costs directly related to ATM/CNS service provision should be included. Meteorological costs and EUROCONTROL costs (if applicable) are not included.","Formula: Sum of Operating costs (continental) and Cost of capital (continental) and Depreciation/amortization (continental)"]
[{"$nulls":4},"Operating costs (continental)","This includes direct and indirect employment costs, non-staff operating expenses, and other costs incurred through the purchase of goods and services directly used to provide continental ANS services. This should include outsourced services such as communications, IT and external staff with short term assignments. Other items that are usually included in “Operating costs” include materials, energy, rent, and facilities & maintenance. Excludes the cost of providing MET services, which should be counted under \"Other unique costs\". ","A16 (En-route+terminal)+A17(En-route+terminal)"]
[{"$nulls":4},"Cost of capital (continental)","The \"Cost of capital (continental)\" falls into three categories. The first is the interest paid to the providers of debt capital.  The second is the appropriate cost of capital applied to equity capital.\n1. For ANSPs with both categories the cost of capital is the interest expense on debt capital plus the cost of capital on equity built into the ANSP charges. \n2 For ANSPs with only debt capital, the cost of capital is the interest expense.  \n3.For ANSPs with only debt capital, where the interest expense is born by the government and not reflected in the accounts of the ANSP, the cost of capital can be imputed by applying the interest rate on overall government borrowing to the ANSP capital.  ","A19 (En-route+terminal)"]
[{"$nulls":4},"Depreciation/amortization (continental)","Depreciation and capital lease amortization expenses related to the total fixed assets in operation associated with providing Continental services. Depreciation is the decrease of an asset in value due to wear and tear through use, action of the elements, inadequacy or obsolescence, normally over a predetermined period of time (depreciation period/book life of the asset.)  Amortization is the gradual extinguishment of the cost of an asset by periodic (annual) charges to expenses, usually applicable to intangible asset (e.g. development costs).  Excludes Depreciation/Amortization costs associated with MET services, which should be counted under \"Other Unique Costs\".","A18 (En-route+terminal)"]
[{"$nulls":3},"Oceanic costs","Total costs (oceanic)","The sum of operating costs, depreciation/amortization, and cost of capital related to providing continental ATC/ATFM services. Exceptional costs directly related to ATM/CNS service provision should be included. Meteorological costs and EUROCONTROL costs (if applicable) are not included.","Formula: Sum of Operating costs (oceanic) and Cost of capital (oceanic) and Depreciation/amortization (oceanic)"]
[{"$nulls":4},"Operating costs (oceanic)","Operating Costs (Oceanic) includes direct and indirect employment costs, non-staff operating expenses, and other costs incurred through the purchase of goods and services directly used to provide Oceanic ANS services. This should include outsourced services such as communications, IT and external staff with short term assignments. Other items that are usually included in “Operating costs” include materials, energy, rent, and facilities & maintenance. Excludes the cost of providing MET services, which should be counted under \"Other Unique Costs\". ","A16 (Other ANS)+A17(Other ANS)"]
[{"$nulls":4},"Cost of capital (oceanic)","The \"Cost of capital (oceanic)\" falls into three categories. The first is the interest paid to the providers of debt capital.  The second is the appropriate cost of capital applied to equity capital.\n1. For ANSPs with both categories the cost of capital is the interest expense on debt capital plus the cost of capital on equity built into the ANSP charges. \n2 For ANSPs with only debt capital, the cost of capital is the interest expense.  \n3.For ANSPs with only debt capital, where the interest expense is born by the government and not reflected in the accounts of the ANSP, the cost of capital can be imputed by applying the interest rate on overall government borrowing to the ANSP capital.  ","A19 (Other ANS)"]
[{"$nulls":4},"Depreciation/amortization (oceanic)","Depreciation and capital lease amortization expenses related to the total fixed assets in operation associated with providing continental services. Depreciation is the decrease of an asset in value due to wear and tear through use, action of the elements, inadequacy or obsolescence, normally over a predetermined period of time (depreciation period/book life of the asset.)  Amortization is the gradual extinguishment of the cost of an asset by periodic (annual) charges to expenses, usually applicable to intangible asset (e.g. development costs).  Excludes depreciation/amortization costs associated with MET services, which should be counted under \"Other unique costs\".","A18 (Other ANS)"]
[{"$nulls":3},"Employment costs","Total employment cost","Total staff costs.","C22 (Total ANS)"]
[{"$nulls":4},"Total employment cost for ATCOs in operations","Total employment costs (staff costs) including gross wages and salaries, payments for overtime and other bonuses, employer contribution to social security scheme and taxes, pension contributions and other benefits for “ATCOs in operations.” This should exclude: pension contributions paid by the employee (unless included within employment costs), mission related expenditures, including travel expenditures and training fees, as these should be considered operating costs. Staff numbers can be calculated as an average based on the FTE number at the start of the year and the FTE number at the end of the year.","Formula:  Sum of Employment cost for ATCOs in operations (continental) and Employment cost for ATCOs in operations (oceanic)"]
[{"$nulls":4},"Total employment cost for ATCOs in operations (continental)","See \"Total employment cost for ATCOs in operations\".","C23 (En-route + terminal ANS)"]
[{"$nulls":4},"Total employment cost for ATCOs in operations (oceanic)","See \"Total employment cost for ATCOs in operations\".","C23 (Other ANS)"]
[{"$nulls":3},"ANS Revenue","Total ANS revenue","The sum of \"Total ANS revenue (continental)\" and \"Total ANS revenue (oceanic)\".","Formula:  Sum of Total ANS revenue (continental) and Total ANS revenue (oceanic)"]
[{"$nulls":4},"Total ANS revenue (continental)","ANS revenue (continental) is ANS revenue (before adjustments from previous years) from the provision of enroute, and terminal ANS services. Revenue is exclusive of oceanic ANS services, and non-ANS revenue sources. (Eurocontrol ANSPs will use \"en-route and terminal revenues before adjustments” (items A1-A9).","A11 (En-route + Terminal)"]
[{"$nulls":4},"Total ANS revenue (oceanic)","ANS revenue (oceanic) is ANS revenue (before adjustments from previous years) from the provision of oceanic ANS services.  Revenue is exclusive of continental ANS services, and non-ANS revenue sources.  ","A11 (Oceanic Other ANS)"]
[null,null,"Price",null,"En route Price per Kilometre Flown for an A320","En route Price per Kilometre Flown for an A320 (77 metric tonnes)",{"v":0,"d":"0 "}]
[{"$nulls":4},"En route Price per Kilometre Flown for a B747-400","En route Price per Kilometre Flown for a B747-400 (396 metric tonnes)",{"v":0,"d":"0 "}]
[{"$nulls":4},"En route Price per Kilometre Flown for a DH8-300","En route Price per Kilometre Flown for a DH8-300 (18.6 metric tonnes)",{"v":0,"d":"0 "}]
[{"$nulls":4},"Terminal Price per Arrival and Departure for an A320","Terminal Price per Arrival and Departure for an A320 (77 metric tonnes)",{"v":0,"d":"0 "}]
[{"$nulls":4},"Terminal Price per Arrival and Departure for a B747-400","Terminal Price per Arrival and Departure for a B747-400 (396 metric tonnes)",{"v":0,"d":"0 "}]
[{"$nulls":4},"Terminal Price per Arrival and Departure for a DH8-300","Terminal Price per Arrival and Departure for a DH8-300 (18.6 metric tonnes)",{"v":0,"d":"0 "}]
[{"$nulls":4},"Example consolidated price per 1000 km flight for A320","The sum of en-route, approach, and terminal navigation charges for a theoretical continental flight of 1000 km (ie. distance between 2 apts is 1000 km.)  ANSP with location-specific pricing, will apply pricing related to highest IFR traffic (high demand) city-pair; ANSPs with national pricing regime will apply these charges to the theoretical continental flight. Amount excludes taxes, such as VAT."]
[{"$nulls":4},"Example consolidated price per 250 km flight for ATR72","The sum of en-route, approach, and terminal navigation charges for a theoretical continental flight of 250 km (ie. distance between 2 apts is 250 km.)  ANSP with location-specific pricing, will apply pricing related to a city-pair which does not have the highest IFR traffic, preferably that could be said to represent a national average. Both arrival & departure airports should be within the boundaries of the ANSP. ANSPs with national pricing regime will apply these charges to the theoretical continental flight. Amount excludes taxes, such as VAT."]
[null,null,"Assets and capital expenditure",null,"Total Capital expenditure","The sum of \"Capital expenditure (continental)\" and \"Capital expenditure (oceanic)\"."]
[{"$nulls":4},"Capital expenditure (continental) ","Also referred to as \"Capex in the year (continental)\", this is capital expenditure in the year, including capitalised labour, for assets relating to the provision of enroute and terminal ANS services. It is the sum of capital expenditures for land and buildings, systems and equipment and intangible assets","B37 (En-route and Terminal)"]
[{"$nulls":4},"NBV of fixed assets (continental end of year figure)","\"NBV of fixed assets (continental end of year figure)\" is the net book value at the end of year of assets related to the provision of enroute and terminal ANS service. It corresponds to the Gross Book Value of assets minus the cumulative depreciation at the end of year. ","B50 (En-route and Terminal)"]
[{"$nulls":4},"Capital expenditure (oceanic)","\"Capex in the year (oceanic)\" is capital expenditure in the year, including capitalised labour, for assets relating to the provision of oceanic ANS services. It is the sum of capital expenditures for land and buildings, systems and equipment and intangible assets","B37 (Other ANS)"]
[{"$nulls":4},"NBV of fixed assets (oceanic end of year figure)","\"NBV of fixed assets (oceanic end of year figure)\" is the net book value at the end of year of assets related to the provision of oceanic ANS service. It corresponds to the Gross Book Value of assets minus the cumulative depreciation at the end of year. ","B50 (Other ANS)"]
[null,null,"Other",null,"Currency","The currency, for example Euros, in which the cost data has been provided.","Section A:  \"Currency Used:\""]
[{"$nulls":4},"Units","Specify if data entry is in 1,000s, 1,000,000s or other factor, otherwise assumed 1."]
[null,null,"Additional Inputs","Operational data","Average flight hours per flight (decimal hours, continental) ","Calculated average flight hours for all activities (flights) included in flight hour computation. This value provides an indication of the average time a flight is in the ANSP controlled airspace. The total flight hours controlled by an ANSP in a year is the sum of the flight hours over the year by the flights controlled by a given ATC operational unit (ACC, terminal or tower). For any given flight, the number of flight hours is the difference between the entry time and the exit time in the controlled airspace (of the relevant operational unit) of the flight trajectory. This is divided by the movements in a year. The number of movements in a year is defined as the number of IFR flights that have been controlled over the year by the ANSP; wherein a flight may cross several ACCs. (Source: PRU Annex D)"]
[{"$nulls":4},"IFR tower movements (take-offs and landings only)","One movement each for arrivals and departures. Touch and Go or Go Around equals two movements. Include helicopters (if they are IFR)."]
[{"$nulls":4},"Total VFR tower movements ","VFR (Visual Flight Rules) counts at towers. VFR counts should be 1 for each take-off and for each landing, and 2 for each touch and go. Overflights should be excluded unless this is not possible in which case a comment should be provided. "]
[{"$nulls":4},"VFR tower movements at ATCO attended aerodromes (controlled)","The total tower movements at aerodromes where an ATC service is provided"]
[{"$nulls":4},"VFR tower movements at aerodromes where an ANSP service other than ATC is provided (uncontrolled)","The total tower movements at aerodromes where an ANSP provides a service other than Air Traffic Control (eg. Flight service)"]
[{"$nulls":4},"En-route VFR flight hours","Number of hours of flight undertaken in Visual Flight Rules. While the methodology for counting VFR flights is expected to be different across ANSPs, this figure should be consistent with the figures reported in \"Total VFR tower movements\"."]
[{"$nulls":4},"Total controlled VFR hours","The controlled count of VFR flight hours as calculated in \"Total VFR hours\"."]
[{"$nulls":4},"Total not controlled VFR hours","The non-controlled count of VFR flight hours as calculated in \"Total VFR hours\"."]
[{"$nulls":3},"Workforce (FTE)","ATCOs in ACCs (expressed in FTE)","Number of ATCOs deployed to these ACCs"]
[{"$nulls":4},"ATCOs in terminal/ACCs (expressed in FTE)","Number of ATCOs deployed in co-located ACC and terminal facilities"]
[{"$nulls":4},"Approximate en-route ATCOs (expressed in FTE)","The approximate number of co-located ATCOs in ACC and terminal facilities that provide en-route services "]
[{"$nulls":4},"Approximate terminal ATCOs (expressed in FTE)","The approximate number of co-located ATCOs in ACC and terminal facilities that provide terminal services "]
[{"$nulls":4},"ATCOs in terminal (expressed in FTE)","Number of ATCOs deployed to stand-alone terminal facilities"]
[{"$nulls":4},"ATCOs in combined terminal/tower (expressed in FTE)","Number of ATCOs deployed in co-located terminal and tower facilities"]
[{"$nulls":4},"ATCOs in towers (expressed in FTE)","Number of ATCOs deployed to stand-alone towers"]
[{"$nulls":4},"ATCOs in combined ACC/tower/terminal (expressed in FTE)","Number of ATCOs deployed in co-located ACC, terminal and tower facilities"]
[{"$nulls":4},"Number of Frontline Service Support Staff (expressed in FTE)","Sum of ATC assistants, ops support, OPS support (non-ATCOs), technical support staff for operational maintenance monitoring and control, technical support staff for planning and development, ATCOs on other duties, and outsourced frontline service support"]
[{"$nulls":4},"ATC assistants (expressed in FTE)","ATC assistants are employees assigned to perform non-traffic control functions in an ATC unit. This includes flight data assistants but excludes technical support staff. (Source: PRU C8)"]
[{"$nulls":4},"OPS support (non-ATCOs) (expressed in FTE)","Non-ATCO staff which fulfil the requirements of the operational ATM without being either administrative or technical support. These functions might include, inter alia, development of ATC procedures, airspace design, incident investigation and development of operational requirements, as well as staff working on FIS positions which do not hold a valid ATCO licence. (Source: PRU C9)"]
[{"$nulls":4},"Technical support staff for operational maintenance, monitoring and control (expressed in FTE)","The number of FTE technical support staff undertaking maintenance, monitoring and control for on-going operational activity. (Source: PRU C10)"]
[{"$nulls":4},"Technical support staff for planning and development (expressed in FTE)","The number of FTE technical support staff undertaking work intended to improve safety, capacity, efficiency or quality of service in the future. Such work would include planning, research & development, and the implementation of new systems. (Source: PRU C11)"]
[{"$nulls":4},"ATCOs on other duties (expressed in FTE)","“ATCOs on other duties” are an ATCO who is participating in an activity outside OPS such as special projects, teaching at a training academy, providing instruction in a simulator, or working in a full time management position. Staff working on FIS positions which do hold a valid ATCO licence should be reported here. (Source: PRU C5)"]
[{"$nulls":4},"Outsourced Frontline Service Support (expressed in FTE)","“Outsourced Frontline Service Support' covers any work performed by employees contracted externally, that is typically performed by frontline service support staff (i.e. ATC assistants, OPS support (non-ATCOs), technical support stadd for operational maintenance, monitoring & control, technical support staff for planning and development, ATCOs on other duties, and other frontline support staff)."]
[]
[null,null,"General information ","Budget accountability ","Joint-stock company (State-owned)","A company whose stock is owned by State shareholders."]
[{"$nulls":4},"State-owned enterprise ","A legal entity that is created by a government in order to partake in commercial activities on the government's behalf. It can be either wholly or partially owned by a government and is typically earmarked to participate in specific commercial activities."]
[{"$nulls":4},"Limited liability company (State-owned) ","A company whose owners (in this case the State) are legally responsible for its debts only to the extent of the amount of capital they invested."]
[{"$nulls":4},"State body ","A body established by or under an enactment and which is controlled, directly or indirectly, by a Minister of the Government."]
[{"$nulls":4},"Autonomous State enterprise","A State-owned entity that is created in order to partake in commercial activities on the government’s behalf, with legal and financial autonomy from the State."]
[{"$nulls":4},"State body (autonomous budget) ","A body established by or under an enactment and which is controlled, directly or indirectly, by a Minister of the Government, yet has control over its own budget."]
[{"$nulls":4},"Independent administrative body","An organisation that participates in running specific parts of an economy or society and is substantially separate from government and ministers."]
[{"$nulls":4},"International organisation ","An institution drawing membership from at least three states, having activities in several states, and whose members are held together by a formal agreement."]
[{"$nulls":4},"Limited liability company (State-owned) ","A private company whose owners are legally responsible for its debts only to the extent of the amount of capital they invested."]
[{"$nulls":4},"Joint-stock company (part-private) ","A company whose stock is owned jointly by State and private shareholders."]
[]
[null,null,"Trial operational performance KPIS",null,"KPI 1: Actual en-route extension vs. planned route (KEA/KEP)","Definition: Actual en-route distance flown compared to planned route. Might be split in actual vs GCD and planned vs GCD.\nMeasured in: The % excess distance or NM.\nData requirements for each actual flight trajectory: Departure and Destination airport; Entry and Exit points in the ‘Measured Areas’ (for which the KPI is computed, e.g. a State); Entry and Exit point in the ‘Reference Area’ (defined as a (sub)regional boundary considered, containing all ‘Measured areas’, e.g. States within the same ICAO Region); Distance flown / actual flight trajectory, derived from surveillance data (radar, ADS-B…). \nMeasurement: From the departure airport 40 NM ring to 40 NM ring around the arrival airport.\nAlternative metric(s): PRU’s Horizontal en-route flight inefficiency in actual flown trajectories (KEA); CANSO’s En-Route Direct Route Extension KPI."]
[{"$nulls":4},"KPI 2: Additional time in terminal airspace","Definition: as per ICAO KPI 08: Actual terminal airspace transit time compared to an unimpeded time.\nMeasured in: Minutes/flight (or NM per flight if not possible in min) and provided as yearly average.\nRequired data: Terminal airspace entry time, computed from surveillance data (radar, ADS-B…) and Actual landing time (ALDT) for each arriving flight.\nMeasurement: Provide name of airport(s) and n. of movements – report for airports above 80k movements, but up to a maximum of the top 5 airports. \nAlternative metric(s): PRUs’ Additional Arrival Sequencing and Metering Area (ASMA) Time; CANSO’s Arrival Flight Distance/Time Efficiency KPI."]
[{"$nulls":4},"KPI 3: Additional taxi-out time","Definition: as per ICAO KPI 02: Actual taxi-out time compared to an unimpeded/reference taxi-out time.\nMeasured in: Minutes/flight and provided as yearly average.\nRequired data: Actual off-block time (AOBT) and Actual take-off time (ATOT) for each departing flight.\nMeasurement: Provide name of airport(s) and n. of movements – report for airports above 80k movements, but up to a maximum of the top 5 airports \nAlternative metric(s): PRU’s Additional Taxi-out Time; CANSO’s Taxi-out Delay KPI."]

{"sheet":"GBWG KPI Framework","index":13,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Operational Performance KPIs","index":14,"n_rows":46,"n_cols":7,"rows_kept":46,"merged":[[2,4,2,6],[4,4,4,6],[8,2,10,2],[11,2,15,2],[16,2,20,2],[25,2,27,2],[28,2,41,2],[43,2,45,2]]}
[]
[]
[{"$nulls":4},"KPIs for measuring ANSP Operational Performance"]
[]
[{"$nulls":4},"This is the sheet for input of the Trial operational performance KPIs and to select CANSO Operational Performance KPIs that are monitored by the ANSP. Please enter data for the 2022 period, as specified in the 'Control' sheet."]
[]
[null,null,"Trial operational performance KPIs"]
[{"$nulls":4},"Input value","Comment:"]
[null,null,"KPI 1: Actual en-route extension vs. planned route (in % excess distance). See 'Definitions' for details. Please comment and use 40NM variant if possible. ","Actual vs planned route (2022)"]
[{"$nulls":3},"Actual  route vs great circle distance (2022)"]
[{"$nulls":3},"Planned route vs great circle distance (2022)"]
[null,null,"KPI 2: Additional time in terminal airspace (in minutes/flight and provided as yearly average). See 'Definitions' for details. Please comment, provide names of airports and number of movements for which values are reported. Report for airports above 80k movements, but up to a maximum of the top 5 airports.","Airport #1 (2022) -  Please, insert ICAO code"]
[{"$nulls":3},"Airport #2 (2022) -  Please, insert ICAO code"]
[{"$nulls":3},"Airport #3 (2022) -  Please, insert ICAO code"]
[{"$nulls":3},"Airport #4 (2022) -  Please, insert ICAO code"]
[{"$nulls":3},"Airport #5 (2022) -  Please, insert ICAO code"]
[null,null,"KPI 3: Additional taxi-out time (in minutes/flight and provided as yearly average). See 'Definitions' for details. Please comment, provide names of airports  and number of movements for which values are reported. Report for airports above 80k movements, but up to a maximum of the top 5 airports.","Airport #1 (2022) -  Please, insert ICAO code"]
[{"$nulls":3},"Airport #2 (2022) -  Please, insert ICAO code"]
[{"$nulls":3},"Airport #3 (2022) -  Please, insert ICAO code"]
[{"$nulls":3},"Airport #4 (2022) -  Please, insert ICAO code"]
[{"$nulls":3},"Airport #5 (2022) -  Please, insert ICAO code"]
[]
[null,null,"CANSO Operational Performance KPIs"]
[]
[null,null,"KPA","Key Performance Indicators (KPIs)","Example KPI Form Definitions","Monitored","Comment"]
[null,null,"Capacity","Declared Capacity","Target acceptance rate for a facility or sector"]
[{"$nulls":3},"Capacity Efficiency","Percentage of Demand Accommodated by Facility's Capacity and Actual Demand",false]
[{"$nulls":3},"Delay Attributed to Capacity Limits","Total or Average Delay by Airport\nTotal or Average Facility Attributable Delay"]
[null,null,"Efficiency","Gate Departure Delay","Number of Gate Departure Delayed Aircraft\nAverage Gate Departure Delay per Flight\nAverage Gate Departure Delay per Delayed Flight",false]
[{"$nulls":3},"Taxi Out Delay","Number of Taxi-Out Delayed Aircraft\nAverage Taxi-Out Delay per Flight\nAverage Taxi-Out Delay per Delayed Flight"]
[{"$nulls":3},"Calculated Take-Off Time Compliance","Calculated Take-Off Time Compliance\nNumber of Early Departures\nNumber of Late Departures"]
[{"$nulls":3},"Terminal Departure Flight Distance/Time Efficiency","Number of Departing Aircraft Delayed in the Terminal Airspace\nAverage Departure Delay per Flight\nAverage Departure Delay per Delayed Flight"]
[{"$nulls":3},"Terminal Departure Level Flight Efficiency","Actual level flight time/distance from take-off to 40/100 NM circle."]
[{"$nulls":3},"En Route Direct Route Extension","Average of Total Actual Flight Distance/Time above that obtained from a great circle benchmark"]
[{"$nulls":3},"Filed Flight Plan En Route Extension","Average of Total Filed Distance/Time above that obtained from a great circle benchmark"]
[{"$nulls":3},"Arrival Flight Distance/Time Efficiency","Total or Average Excess Minutes or Miles by Aircraft Group, Operating Configuration, or Arrival Airport"]
[{"$nulls":3},"Arrival Level Flight Efficiency","Actual level flight time/distance from 40/100 NM circle landing.",false]
[{"$nulls":3},"Arrival Runway Occupancy Time","Average Runway Occipancy Time Per Aircraft Category",false]
[{"$nulls":3},"Taxi In Delay","Number of Taxi-In Aircraft Delayed\nAverage Taxi-In Delay per Flight\nAverage Taxi-In Delay per Delayed Aircraft",false]
[{"$nulls":3},"Gate Arrival Delay","Number of Gate Arrival Delayed Aircraft\nAverage Gate Arrival Delay per Flight\nAverage Gate Arrival Delay per Delayed Flight"]
[{"$nulls":3},"ATM Attributable Delay","Delay against a schedule or a filed time that can be attributed to ATM"]
[{"$nulls":3},"Average Flight Time Between City Pairs","Average Travel Time Between City Pairs"]
[null,null,"Capacity and Efficiency","Operational Availability","(Maximum facility service hours minus outage time divided by maximum facility service hours)"]
[null,null,"Predictability","Capacity Variation","Difference between the 85th and 15th percentile declared capacity for a facility."]
[{"$nulls":3},"Travel Time Variation","Difference between the 85th and 15th percentile travel time for a phase of flight for a city pair"]
[{"$nulls":3},"Flight Plan Variation","Difference between the 85th and 15th percentile flight plan distance or time for a city pair"]

{"sheet":"Previously submitted menu","index":15,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Output menu","index":16,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Financial Data - Inflation Rate","index":17,"n_rows":197,"n_cols":11,"rows_kept":197}
["Country","Units","2017","2018","2019","2020","2021","2022"]
["Afghanistan","Percent change",5,0.6,2.3,5.6,"no data","no data",null,"Source"]
["Albania","Percent change",2,2,1.4,1.6,2,6.7,null,"IMF data download","https://www.imf.org/external/datamapper/PCPIPCH@WEO/OEMDC/ADVEC/WEOWORLD"]
["Algeria","Percent change",5.6,4.3,2,2.4,7.2,9.3]
["Andorra","Percent change",2.6,1.3,0.7,0.3,1.7,6.2]
["Angola","Percent change",29.8,19.6,17.1,22.3,25.8,21.4]
["Antigua and Barbuda","Percent change",2.4,1.2,1.4,1.1,1.6,7.5]
["Argentina","Percent change",25.7,34.3,53.5,42,48.4,72.4]
["Armenia","Percent change",1.2,2.5,1.4,1.2,7.2,8.7]
["Aruba","Percent change",-1,3.6,3.9,-1.3,0.7,5.5]
["Australia","Percent change",2,1.9,1.6,0.9,2.8,6.6]
["Austria","Percent change",2.2,2.1,1.5,1.4,2.8,8.6]
["Azerbaijan","Percent change",12.8,2.3,2.7,2.8,6.7,13.8]
["Bahamas, The","Percent change",1.5,2.3,2.5,0,3.2,5.6]
["Bahrain","Percent change",1.4,2.1,1,-2.3,-0.6,3.6]
["Bangladesh","Percent change",5.4,5.8,5.5,5.6,5.6,6.1]
["Barbados","Percent change",4.4,3.7,4.1,2.9,3,9.4]
["Belarus","Percent change",6,4.9,5.6,5.5,9.5,14.8]
["Belgium","Percent change",2.2,2.3,1.2,0.4,3.2,10.3]
["Belize","Percent change",1.1,0.3,0.2,0.1,3.2,6.3]
["Benin","Percent change",1.8,0.8,-0.9,3,1.7,1.5]
["Bhutan","Percent change",4.3,3.7,2.8,4.2,8.1,5.9]
["Bolivia","Percent change",2.8,2.3,1.8,0.9,0.7,1.7]
["Bosnia and Herzegovina","Percent change",0.8,1.4,0.6,-1.1,2,14]
["Botswana","Percent change",3.3,3.2,2.7,1.9,6.7,12.2]
["Brazil","Percent change",3.4,3.7,3.7,3.2,8.3,9.3]
["Brunei Darussalam","Percent change",-1.3,1.1,-0.4,1.9,1.5,3.7]
["Bulgaria","Percent change",1.2,2.6,2.5,1.2,2.8,13]
["Burkina Faso","Percent change",1.5,2,-3.2,1.9,3.9,14.1]
["Burundi","Percent change",1.6,-4,-0.7,7.3,8.3,18.9]
["Cabo Verde","Percent change",0.8,1.3,1.1,0.6,1.9,7.9]
["Cambodia","Percent change",2.9,2.4,2,2.9,3,5.3]
["Cameroon","Percent change",0.6,1.1,2.5,2.5,2.3,5.3]
["Canada","Percent change",1.6,2.3,1.9,0.7,3.4,6.8]
["Central African Republic","Percent change",4.2,1.6,2.8,0.9,4.3,5.8]
["Chad","Percent change",-0.9,4,-1,4.5,-0.8,5.3]
["Chile","Percent change",2.2,2.3,2.3,3,4.5,11.6]
["China, People's Republic of","Percent change",1.6,2.1,2.9,2.4,0.9,1.9]
["Colombia","Percent change",4.3,3.2,3.5,2.5,3.5,10.2]
["Comoros","Percent change",0.1,1.7,3.7,0.8,1.5,12]
["Congo, Dem. Rep. of the","Percent change",35.7,29.3,4.7,11.4,9,9]
["Congo, Republic of ","Percent change",0.4,1.2,0.4,1.4,2,3.5]
["Costa Rica","Percent change",1.6,2.2,2.1,0.7,1.7,8.3]
["Croatia","Percent change",1.1,1.5,0.8,0.1,2.6,10.7]
["Cyprus","Percent change",0.7,0.8,0.5,-1.1,2.2,8.1]
["Czech Republic","Percent change",2.5,2.1,2.8,3.2,3.8,15.1]
["Côte d'Ivoire","Percent change",0.6,0.6,0.8,2.4,4.2,5.2]
["Denmark","Percent change",1.1,0.7,0.7,0.3,1.9,8.5]
["Djibouti","Percent change",0.6,0.1,3.3,1.8,1.2,5.5]
["Dominica","Percent change",0.3,1,1.5,-0.7,0.5,7.5]
["Dominican Republic","Percent change",3.3,3.6,1.8,3.8,8.2,8.8]
["Ecuador","Percent change",0.4,-0.2,0.3,-0.3,0.1,3.5]
["Egypt","Percent change",23.5,20.9,13.9,5.7,4.5,8.5]
["El Salvador","Percent change",1,1.1,0.1,-0.4,3.5,7.2]
["Equatorial Guinea","Percent change",0.7,1.3,1.2,4.8,-0.1,5]
["Eritrea","Percent change",-13.3,-14.4,-16.4,4.8,4.5,7.4]
["Estonia","Percent change",3.7,3.4,2.3,-0.6,4.5,19.4]
["Eswatini","Percent change",6.2,4.8,2.6,3.9,3.7,4.8]
["Ethiopia","Percent change",10.7,13.8,15.8,20.4,26.8,33.9]
["Fiji","Percent change",3.3,4.1,1.8,-2.6,0.2,4.5]
["Finland","Percent change",0.8,1.2,1.1,0.4,2.1,7.2]
["France","Percent change",1.2,2.1,1.3,0.5,2.1,5.9]
["Gabon","Percent change",2.7,4.8,2,1.3,1.1,4.3]
["Gambia, The","Percent change",8,6.5,7.1,5.9,7.4,11.5]
["Georgia","Percent change",6,2.6,4.9,5.2,9.6,11.9]
["Germany","Percent change",1.7,1.9,1.4,0.4,3.2,8.7]
["Ghana","Percent change",12.4,9.8,7.1,9.9,10,31.9]
["Greece","Percent change",1.1,0.8,0.5,-1.3,0.6,9.3]
["Grenada","Percent change",0.9,0.8,0.6,-0.7,1.2,2.7]
["Guatemala","Percent change",4.4,3.8,3.7,3.2,4.3,6.9]
["Guinea","Percent change",8.9,9.8,9.5,10.6,12.6,10.5]
["Guinea-Bissau","Percent change",-0.2,0.4,0.3,1.5,3.3,7.9]
["Guyana","Percent change",1.9,1.3,2.1,0.7,5.1,6.5]
["Haiti","Percent change",10.6,11.4,17.3,22.9,15.9,27.6]
["Honduras","Percent change",3.9,4.3,4.4,3.5,4.5,9.1]
["Hong Kong SAR","Percent change",1.5,2.4,2.9,0.3,1.6,1.9]
["Hungary","Percent change",2.4,2.8,3.4,3.3,5.1,14.5]
["Iceland","Percent change",1.8,2.7,3,2.9,4.5,8.3]
["India","Percent change",3.6,3.4,4.8,6.2,5.5,6.7]
["Indonesia","Percent change",3.8,3.3,2.8,2,1.6,4.2]
["Iran","Percent change",9.6,30.2,34.6,36.4,40.1,49]
["Iraq","Percent change",0.2,0.4,-0.2,0.6,6,5]
["Ireland","Percent change",0.3,0.7,0.9,-0.5,2.4,8.1]
["Israel","Percent change",0.2,0.8,0.8,-0.6,1.5,4.4]
["Italy","Percent change",1.3,1.2,0.6,-0.1,1.9,8.7]
["Jamaica","Percent change",4.4,3.7,3.9,5.2,5.9,9.5]
["Japan","Percent change",0.5,1,0.5,0,-0.3,2.5]
["Jordan","Percent change",3.6,4.5,0.7,0.4,1.3,4.2]
["Kazakhstan","Percent change",7.4,6,5.2,6.8,8,15]
["Kenya","Percent change",8,4.7,5.2,5.3,6.1,7.6]
["Kiribati","Percent change",0.4,0.6,-1.8,2.5,3,5.3]
["Korea, Republic of","Percent change",1.9,1.5,0.4,0.5,2.5,5.1]
["Kosovo","Percent change",1.5,1.1,2.7,0.2,3.3,11.7]
["Kuwait","Percent change",1.5,0.6,1.1,2.1,3.4,3.9]
["Kyrgyz Republic","Percent change",3.2,1.5,1.1,6.3,11.9,13.9]
["Lao P.D.R.","Percent change",0.8,2,3.3,5.1,3.8,23]
["Latvia","Percent change",2.9,2.6,2.7,0.1,3.2,17.2]
["Lebanon","Percent change",4.5,6.1,2.9,84.9,"no data","no data"]
["Lesotho","Percent change",4.4,4.8,5.2,5,6,8.2]
["Liberia","Percent change",12.4,23.5,27,17,7.8,7.6]
["Libya","Percent change",28,-1.2,0.2,2.8,3.7,4.5]
["Lithuania","Percent change",3.7,2.5,2.2,1.1,4.6,18.9]
["Luxembourg","Percent change",2.1,2,1.7,0,3.5,8.1]
["Macao SAR","Percent change",1.2,3,2.8,0.8,0,1]
["Madagascar","Percent change",8.6,8.6,5.6,4.2,5.8,8.2]
["Malawi","Percent change",11.5,9.2,9.4,8.6,9.3,20.8]
["Malaysia","Percent change",3.8,1,0.7,-1.1,2.5,3.4]
["Maldives","Percent change",2.3,1.4,1.3,-1.6,0.2,2.6]
["Mali","Percent change",1.8,1.7,-2.9,0.5,4,10.1]
["Malta","Percent change",1.3,1.7,1.5,0.8,0.7,6.1]
["Marshall Islands","Percent change",0.1,0.8,-0.5,-0.2,3.5,6.2]
["Mauritania","Percent change",2.3,3.1,2.3,2.3,3.8,9.6]
["Mauritius","Percent change",3.7,3.2,0.5,2.5,4,10.8]
["Mexico","Percent change",6,4.9,3.6,3.4,5.7,7.9]
["Micronesia, Fed. States of","Percent change",0.1,1.1,2.2,0.9,2.1,5]
["Moldova","Percent change",6.5,3.6,4.8,3.8,5.1,28.6]
["Mongolia","Percent change",4.3,6.8,7.3,3.7,7.1,15.2]
["Montenegro","Percent change",2.4,2.6,0.4,-0.2,2.4,13]
["Morocco","Percent change",0.7,1.6,0.2,0.6,1.4,6.6]
["Mozambique","Percent change",15.1,3.9,2.8,3.1,5.7,9.8]
["Myanmar","Percent change",4.6,5.9,8.6,5.7,3.6,16.2]
["Namibia","Percent change",6.1,4.3,3.7,2.2,3.6,6.1]
["Nauru","Percent change",5.1,0.5,4.3,-6.6,1.2,2.6]
["Nepal","Percent change",4.5,4.1,4.6,6.1,3.6,6.3]
["Netherlands","Percent change",1.3,1.6,2.7,1.1,2.8,11.6]
["New Zealand","Percent change",1.9,1.6,1.6,1.7,3.9,7.2]
["Nicaragua","Percent change",3.9,4.9,5.4,3.7,4.9,10.4]
["Niger","Percent change",0.2,2.8,-2.5,2.9,3.8,4.2]
["Nigeria","Percent change",16.5,12.1,11.4,13.2,17,18.8]
["North Macedonia ","Percent change",1.4,1.5,0.8,1.2,3.2,14.2]
["Norway","Percent change",1.9,2.8,2.2,1.3,3.5,5.8]
["Oman","Percent change",1.6,0.9,0.1,-0.9,1.5,2.8]
["Pakistan","Percent change",4.1,3.9,6.7,10.7,8.9,12.1]
["Palau","Percent change",1.1,2,0.6,0.7,0.4,8.7]
["Panama","Percent change",0.9,0.8,-0.4,-1.6,1.6,2.9]
["Papua New Guinea","Percent change",5.4,4.7,3.7,4.9,4.5,6.6]
["Paraguay","Percent change",3.6,4,2.8,1.8,4.8,9.8]
["Peru","Percent change",2.8,1.3,2.1,1.8,4,7.9]
["Philippines","Percent change",2.9,5.3,2.4,2.4,3.9,5.8]
["Poland","Percent change",2,1.6,2.3,3.4,5.1,14.4]
["Portugal","Percent change",1.6,1.2,0.3,-0.1,0.9,8.1]
["Puerto Rico","Percent change",1.8,1.3,0.1,-0.5,2.3,4.3]
["Qatar","Percent change",0.4,0.3,-0.7,-2.7,2.3,5]
["Romania","Percent change",1.3,4.6,3.8,2.6,5,13.8]
["Russian Federation","Percent change",3.7,2.9,4.5,3.4,6.7,13.8]
["Rwanda","Percent change",4.8,1.4,2.4,7.7,0.8,13.9]
["Saint Kitts and Nevis","Percent change",0.7,-1,-0.3,-0.6,0.2,2.7]
["Saint Lucia","Percent change",0.1,2.6,0.5,-1.8,2.4,6.7]
["Saint Vincent and the Grenadines","Percent change",2.2,2.3,0.9,-0.6,1.6,5.7]
["Samoa","Percent change",1.3,3.7,2.2,1.5,-3,8.7]
["San Marino","Percent change",1,1.8,1,0.2,2.1,7.1]
["Saudi Arabia","Percent change",-0.8,2.5,-2.1,3.4,3.1,2.5]
["Senegal","Percent change",1.1,0.5,1,2.5,2.2,9.7]
["Serbia","Percent change",3.1,2,1.9,1.6,4.1,12]
["Seychelles","Percent change",2.9,3.7,1.8,1.2,9.8,2.7]
["Sierra Leone","Percent change",18.2,16,14.8,13.4,11.9,27.2]
["Singapore","Percent change",0.6,0.4,0.6,-0.2,2.3,6.1]
["Slovak Republic","Percent change",1.4,2.5,2.8,2,2.8,12.1]
["Slovenia","Percent change",1.4,1.7,1.6,-0.1,1.9,8.8]
["Solomon Islands","Percent change",0.5,3.5,1.6,3,-0.1,5.5]
["Somalia","Percent change",4,4.3,4.5,4.3,4.6,6.8]
["South Africa","Percent change",5.3,4.6,4.1,3.3,4.5,6.9]
["South Sudan, Republic of","Percent change",187.9,83.5,51.2,24,5.3,17.6]
["Spain","Percent change",2,1.7,0.7,-0.3,3.1,8.3]
["Sri Lanka","Percent change",6.6,4.3,4.3,4.6,6,46.4]
["Sudan","Percent change",32.4,63.3,51,163.3,359.1,138.8]
["Suriname","Percent change",22,6.9,4.4,34.9,59.1,52.5]
["Sweden","Percent change",1.9,2,1.7,0.7,2.7,8.1]
["Switzerland","Percent change",0.5,0.9,0.4,-0.7,0.6,2.8]
["Syria","Percent change","no data","no data","no data","no data","no data","no data"]
["São Tomé and Príncipe","Percent change",5.7,7.9,7.7,9.8,8.1,18]
["Taiwan Province of China","Percent change",1.1,1.5,0.5,-0.2,1.8,2.9]
["Tajikistan","Percent change",7.3,3.8,7.8,8.6,8.7,6.6]
["Tanzania","Percent change",5.3,3.5,3.4,3.3,3.7,4.4]
["Thailand","Percent change",0.7,1.1,0.7,-0.8,1.2,6.1]
["Timor-Leste","Percent change",0.5,2.3,0.9,0.5,3.8,7]
["Togo","Percent change",-0.2,0.9,0.7,1.8,4.3,7.6]
["Tonga","Percent change",7.2,6.8,3.3,0.4,1.4,8.5]
["Trinidad and Tobago","Percent change",1.9,1,1,0.6,1.1,5.8]
["Tunisia","Percent change",5.3,7.3,6.7,5.6,5.7,8.3]
["Turkey","Percent change",11.1,16.3,15.2,12.3,19.6,{"$error":"#N/A"}]
["Turkmenistan","Percent change",8,13.3,5.1,7.6,15,11.5]
["Tuvalu","Percent change",4.1,2.2,3.5,1.6,3,11.5]
["Uganda","Percent change",5.6,2.6,2.3,2.8,2.2,6.8]
["Ukraine","Percent change",14.4,10.9,7.9,2.7,9.4,20.2]
["United Arab Emirates","Percent change",2,3.1,-1.9,-2.1,0.2,4.8]
["United Kingdom","Percent change",2.7,2.5,1.8,0.9,2.6,9.1]
["United States","Percent change",2.1,2.4,1.8,1.2,4.7,8]
["Uruguay","Percent change",6.2,7.6,7.9,9.8,7.7,9.1]
["Uzbekistan","Percent change",13.9,17.5,14.5,12.9,10.8,11.4]
["Vanuatu","Percent change",3.1,2.4,2.7,5.3,3,4.6]
["Venezuela","Percent change",438.1,65374.1,19906,2355.1,1588.5,200.9]
["Vietnam","Percent change",3.5,3.5,2.8,3.2,1.9,3.2]
["West Bank and Gaza","Percent change",0.2,-0.2,1.6,-0.7,1.2,3.7]
["Yemen","Percent change",30.4,27.6,12,23.1,63.8,29.1]
["Zambia","Percent change",6.6,7,9.2,15.7,20.5,11]
["Zimbabwe","Percent change",0.9,10.6,255.3,557.2,98.5,193.4]

{"sheet":"Financial Data - PPP","index":18,"n_rows":196,"n_cols":11,"rows_kept":196}
["Country","Unit ","2017","2018","2019","2020","2021","2022"]
["Afghanistan","National currency per US dollar",17.206,17.152,17.95,19.123,"no data","no data",null,"Sources"]
["Albania","National currency per US dollar",41.231,40.862,40.649,40.437,41.124,40.478,null,"IMF data download","https://www.imf.org/external/datamapper/PPPEX@WEO/OEMDC/ADVEC/WEOWORLD/SAU"]
["Algeria","National currency per US dollar",38.856,40.63,39.553,37.666,41.366,47.621]
["Andorra","National currency per US dollar",0.63,0.622,0.619,0.619,0.606,0.596]
["Angola","National currency per US dollar",92.952,117.268,139.589,159.547,212.518,227.098]
["Antigua and Barbuda","National currency per US dollar",2.094,2.093,2.06,2.071,2.021,2.028]
["Argentina","National currency per US dollar",10.257,14.228,21.096,29.16,42.953,67.446]
["Armenia","National currency per US dollar",155.971,156.541,155.384,156.631,160.772,161.182]
["Aruba","National currency per US dollar",1.351,1.349,1.399,1.342,1.336,1.21]
["Australia","National currency per US dollar",1.466,1.464,1.484,1.478,1.498,1.503]
["Austria","National currency per US dollar",0.77,0.766,0.765,0.773,0.755,0.74]
["Azerbaijan","National currency per US dollar",0.505,0.554,0.543,0.497,0.578,0.657]
["Bahamas, The","National currency per US dollar",0.901,0.89,0.89,0.774,0.791,0.807]
["Bahrain","National currency per US dollar",0.187,0.191,0.188,0.175,0.184,0.186]
["Bangladesh","National currency per US dollar",29.738,30.495,31.239,32.333,32.708,31.278]
["Barbados","National currency per US dollar",2.203,2.211,2.292,2.318,2.285,2.256]
["Belarus","National currency per US dollar",0.609,0.667,0.712,0.787,0.854,0.932]
["Belgium","National currency per US dollar",0.773,0.766,0.766,0.767,0.768,0.754]
["Belize","National currency per US dollar",1.375,1.346,1.337,1.294,1.282,1.279]
["Benin","National currency per US dollar",216.774,212.965,208.557,212.005,205.089,200.552]
["Bhutan","National currency per US dollar",19.208,19.379,19.291,19.765,19.892,19.912]
["Bolivia","National currency per US dollar",2.749,2.767,2.699,2.618,2.552,2.502]
["Bosnia and Herzegovina","National currency per US dollar",0.676,0.679,0.684,0.677,0.665,0.738]
["Botswana","National currency per US dollar",4.734,4.626,4.56,4.701,4.63,4.856]
["Brazil","National currency per US dollar",2.182,2.226,2.28,2.368,2.526,2.584]
["Brunei Darussalam","National currency per US dollar",0.647,0.69,0.655,0.577,0.901,0.737]
["Bulgaria","National currency per US dollar",0.674,0.686,0.71,0.731,0.745,0.805]
["Burkina Faso","National currency per US dollar",208.757,208.032,203.083,209.875,199.687,207.865]
["Burundi","National currency per US dollar",654.896,621.382,615.481,644.387,671.071,734.733]
["Cabo Verde","National currency per US dollar",48.477,48.068,47.489,46.519,45.956,45.247]
["Cambodia","National currency per US dollar",1428.354,1438.439,1458.88,1400.136,1383.014,1338.419]
["Cameroon","National currency per US dollar",232.801,231.64,230.221,228.634,225.361,220.831]
["Canada","National currency per US dollar",1.205,1.196,1.192,1.187,1.232,1.23]
["Central African Republic","National currency per US dollar",286.829,283.761,285.526,287.383,285.019,282.732]
["Chad","National currency per US dollar",243.655,243.459,242.959,234.892,241.822,248.101]
["Chile","National currency per US dollar",411.264,408.07,411.134,441.762,456.629,453.206]
["China, People's Republic of","National currency per US dollar",4.184,4.229,4.242,4.244,4.138,4.036]
["Colombia","National currency per US dollar",1314.787,1343.573,1372.795,1374.846,1406.632,1511.777]
["Comoros","National currency per US dollar",190.126,187.472,192.46,191.881,184.806,179.44]
["Congo, Dem. Rep. of the","National currency per US dollar",645.391,818.442,836.225,881.928,993.845,946.511]
["Congo, Republic of ","National currency per US dollar",297.674,358.779,350.076,298.334,344.119,324.272]
["Costa Rica","National currency per US dollar",350.817,350.144,352.82,349.163,342.033,338.481]
["Croatia","National currency per US dollar",3.327,3.315,3.319,3.276,3.247,0.436]
["Cyprus","National currency per US dollar",0.615,0.607,0.603,0.589,0.579,0.577]
["Czech Republic","National currency per US dollar",12.378,12.399,12.655,13.054,13.06,13.05]
["Côte d'Ivoire","National currency per US dollar",253.746,249.399,245.507,244.966,241.777,235.954]
["Denmark","National currency per US dollar",6.852,6.742,6.673,6.765,6.662,6.701]
["Djibouti","National currency per US dollar",106.023,103.925,105.488,106.084,103.058,98.572]
["Dominica","National currency per US dollar",1.738,1.714,1.709,1.676,1.618,1.705]
["Dominican Republic","National currency per US dollar",21.613,21.979,22.138,22.908,23.77,24.103]
["Ecuador","National currency per US dollar",0.535,0.532,0.525,0.517,0.509,0.504]
["Egypt","National currency per US dollar",3.267,3.874,4.324,4.539,4.567,4.683]
["El Salvador","National currency per US dollar",0.463,0.459,0.455,0.447,0.447,0.454]
["Equatorial Guinea","National currency per US dollar",248.934,266.257,255.832,229.196,278.51,364.097]
["Eritrea","National currency per US dollar",5.47,4.979,4.655,4.865,4.948,4.704]
["Estonia","National currency per US dollar",0.534,0.542,0.55,0.541,0.548,0.601]
["Eswatini","National currency per US dollar",6.206,6.231,6.274,6.362,6.262,5.828]
["Ethiopia","National currency per US dollar",8.521,9.276,10.221,11.942,13.881,17.223]
["Fiji","National currency per US dollar",0.939,0.93,0.936,0.91,0.884,0.822]
["Finland","National currency per US dollar",0.863,0.86,0.858,0.861,0.849,0.82]
["France","National currency per US dollar",0.766,0.756,0.753,0.763,0.738,0.713]
["Gabon","National currency per US dollar",279.766,292.827,292.149,262.294,300.583,347.589]
["Gambia, The","National currency per US dollar",15.286,15.967,16.667,17.134,17.26,17.889]
["Georgia","National currency per US dollar",0.805,0.82,0.847,0.898,0.956,0.961]
["Germany","National currency per US dollar",0.741,0.738,0.74,0.742,0.735,0.723]
["Ghana","National currency per US dollar",1.764,1.905,2.03,2.149,2.286,2.829]
["Greece","National currency per US dollar",0.576,0.562,0.553,0.542,0.531,0.53]
["Grenada","National currency per US dollar",1.69,1.639,1.664,1.639,1.593,1.51]
["Guatemala","National currency per US dollar",3.933,3.887,3.959,4.015,3.949,3.869]
["Guinea","National currency per US dollar",3216.035,3362.728,3632.334,3976.775,4299.484,4029.436]
["Guinea-Bissau","National currency per US dollar",222.749,206.158,195.543,191.283,188.609,193.492]
["Guyana","National currency per US dollar",105.353,99.924,101.074,73.609,81.981,89.566]
["Haiti","National currency per US dollar",28.498,29.859,34.483,41.085,47.075,56.845]
["Honduras","National currency per US dollar",10.362,10.317,10.554,10.911,10.945,11.042]
["Hong Kong SAR","National currency per US dollar",6.011,6.086,6.101,6.063,5.851,5.575]
["Hungary","National currency per US dollar",134.363,137.588,141.612,148.203,152.361,152.28]
["Iceland","National currency per US dollar",137.122,137.465,141.063,144.341,146.617,150.505]
["India","National currency per US dollar",20.648,20.949,21.073,21.989,23.138,22.966]
["Indonesia","National currency per US dollar",4695.659,4761.217,4752.309,4675.221,4758.677,4852.375]
["Iran","National currency per US dollar",13061.295,16772.709,21386.796,29704.344,41690.986,65367.55]
["Iraq","National currency per US dollar",560.761,616.975,590.728,505.359,689.375,753.07]
["Ireland","National currency per US dollar",0.791,0.778,0.797,0.778,0.744,0.732]
["Israel","National currency per US dollar",3.745,3.69,3.694,3.685,3.63,3.512]
["Italy","National currency per US dollar",0.687,0.678,0.672,0.673,0.649,0.624]
["Jamaica","National currency per US dollar",67.582,69.343,70.238,72.336,75.81,74.214]
["Japan","National currency per US dollar",105.379,102.919,101.754,101.444,96.51,90.684]
["Jordan","National currency per US dollar",0.3,0.298,0.298,0.294,0.286,0.278]
["Kazakhstan","National currency per US dollar",121.253,129.327,136.752,140.958,149.69,172.319]
["Kenya","National currency per US dollar",40.185,40.909,42.035,43.687,43.722,43.694]
["Kiribati","National currency per US dollar",1.152,1.143,1.101,1.123,1.115,1.154]
["Korea, Republic of","National currency per US dollar",871.696,855.47,833.381,834.269,819.526,775.082]
["Kosovo","National currency per US dollar",0.34,0.337,0.334,0.335,0.331,0.347]
["Kuwait","National currency per US dollar",0.177,0.193,0.189,0.161,0.193,0.228]
["Kyrgyz Republic","National currency per US dollar",16.959,17.184,17.548,18.445,20.51,22.819]
["Lao P.D.R.","National currency per US dollar",2789.109,2776.273,2791.667,2847.417,2888.456,3157.211]
["Latvia","National currency per US dollar",0.484,0.491,0.495,0.489,0.501,0.55]
["Lebanon","National currency per US dollar",734.776,756.785,775.873,1299.446,"no data","no data"]
["Lesotho","National currency per US dollar",5.506,5.671,5.879,6.13,6.264,6.397]
["Liberia","National currency per US dollar",0.461,0.437,0.416,0.417,0.441,0.443]
["Libya","National currency per US dollar",0.606,0.689,0.57,0.68,1.27,1.535]
["Lithuania","National currency per US dollar",0.442,0.447,0.451,0.452,0.462,0.504]
["Luxembourg","National currency per US dollar",0.844,0.839,0.829,0.854,0.876,0.876]
["Macao SAR","National currency per US dollar",5.155,5.213,5.245,5.17,4.927,4.608]
["Madagascar","National currency per US dollar",1013.435,1071.923,1121.767,1156.643,1178.197,1183.021]
["Malawi","National currency per US dollar",251.074,260.246,275.431,289.228,300.101,327.504]
["Malaysia","National currency per US dollar",1.655,1.626,1.599,1.568,1.591,1.576]
["Maldives","National currency per US dollar",8.161,8.221,7.99,7.923,7.737,7.37]
["Mali","National currency per US dollar",214.509,212.563,212.841,211.442,208.385,208.442]
["Malta","National currency per US dollar",0.578,0.577,0.58,0.582,0.568,0.558]
["Marshall Islands","National currency per US dollar",1.135,1.125,1.1,1.152,1.145,1.124]
["Mauritania","National currency per US dollar",11.126,11.203,11.48,11.743,12.376,12.534]
["Mauritius","National currency per US dollar",16.882,16.727,16.516,16.537,16.426,16.656]
["Mexico","National currency per US dollar",8.871,9.093,9.303,9.561,9.844,9.625]
["Micronesia, Fed. States of","National currency per US dollar",1.07,1.143,1.148,1.145,1.122,1.094]
["Moldova","National currency per US dollar",5.572,5.616,5.814,5.948,6.069,6.877]
["Mongolia","National currency per US dollar",791.436,834.504,901.594,923.88,1004.547,1093.221]
["Montenegro","National currency per US dollar",0.351,0.353,0.354,0.349,0.35,0.359]
["Morocco","National currency per US dollar",4.023,3.972,3.956,3.942,3.83,3.824]
["Mozambique","National currency per US dollar",22.856,22.992,23.73,24.034,24.436,23.671]
["Myanmar","National currency per US dollar",366.713,377.662,394.27,412.853,413.987,450.376]
["Namibia","National currency per US dollar",7.021,7.16,7.078,7.4,7.351,7.126]
["Nauru","National currency per US dollar",1.296,1.318,1.328,1.341,1.327,1.504]
["Nepal","National currency per US dollar",31.235,31.835,32.743,33.52,33.341,33.732]
["Netherlands","National currency per US dollar",0.778,0.779,0.788,0.797,0.784,0.766]
["New Zealand","National currency per US dollar",1.453,1.45,1.465,1.497,1.469,1.431]
["Nicaragua","National currency per US dollar",10.807,10.835,11.232,11.748,11.835,11.935]
["Niger","National currency per US dollar",258.46,258.561,254.33,253.493,251.78,240.984]
["Nigeria","National currency per US dollar",115.978,124.858,135.402,144.291,152.568,158.01]
["North Macedonia ","National currency per US dollar",19.043,19.329,19.154,19.088,19.437,19.269]
["Norway","National currency per US dollar",9.922,10.335,10.105,9.625,10.805,13.038]
["Oman","National currency per US dollar",0.2,0.219,0.207,0.199,0.218,0.231]
["Pakistan","National currency per US dollar",33.589,34.084,36.29,39.3,41.734,44.113]
["Palau","National currency per US dollar",1.088,1.061,1.024,1.053,1.016,0.875]
["Panama","National currency per US dollar",0.497,0.489,0.481,0.467,0.458,0.439]
["Papua New Guinea","National currency per US dollar",2.307,2.473,2.456,2.56,2.638,2.81]
["Paraguay","National currency per US dollar",2534.377,2523.768,2554.09,2580.55,2617.442,2657.593]
["Peru","National currency per US dollar",1.749,1.743,1.744,1.803,1.857,1.815]
["Philippines","National currency per US dollar",19.385,19.641,19.43,19.513,19.174,18.805]
["Poland","National currency per US dollar",1.737,1.717,1.741,1.791,1.821,1.874]
["Portugal","National currency per US dollar",0.575,0.572,0.572,0.576,0.556,0.546]
["Puerto Rico","National currency per US dollar",0.905,0.936,0.906,0.915,0.9,0.884]
["Qatar","National currency per US dollar",2.346,2.576,2.418,2.028,2.385,2.671]
["Romania","National currency per US dollar",1.604,1.664,1.746,1.792,1.81,1.916]
["Russian Federation","National currency per US dollar",24.05,25.838,26.212,26.062,29.127,31.743]
["Rwanda","National currency per US dollar",325.126,315.564,317.759,339.914,334.461,344.569]
["Saint Kitts and Nevis","National currency per US dollar",2.04,1.973,1.997,1.933,1.864,1.632]
["Saint Lucia","National currency per US dollar",1.996,1.959,1.975,1.871,1.848,1.77]
["Saint Vincent and the Grenadines","National currency per US dollar",1.59,1.573,1.584,1.584,1.529,1.424]
["Samoa","National currency per US dollar",1.905,1.882,1.875,1.857,1.805,1.847]
["San Marino","National currency per US dollar",0.683,0.681,0.674,0.669,0.653,0.624]
["Saudi Arabia","National currency per US dollar",1.649,1.863,1.795,1.62,1.785,1.932]
["Senegal","National currency per US dollar",246.787,239.005,239.704,240.367,236.369,234.352]
["Serbia","National currency per US dollar",40.795,40.63,40.891,41.393,42.163,43.313]
["Seychelles","National currency per US dollar",7.969,7.994,7.91,7.58,7.881,7.453]
["Sierra Leone","National currency per US dollar",2244.995,2500.065,2645.304,2899.115,3062.001,3353.773]
["Singapore","National currency per US dollar",0.886,0.896,0.877,0.841,0.84,0.895]
["Slovak Republic","National currency per US dollar",0.503,0.501,0.504,0.51,0.502,0.502]
["Slovenia","National currency per US dollar",0.568,0.566,0.568,0.568,0.56,0.559]
["Solomon Islands","National currency per US dollar",7.728,7.769,7.729,7.897,7.904,7.762]
["Somalia","National currency per US dollar",0.356,0.35,0.368,0.392,0.392,0.395]
["South Africa","National currency per US dollar",6.427,6.525,6.699,6.968,7.137,6.969]
["South Sudan, Republic of","National currency per US dollar",35.505,58.792,72.894,102.108,133.647,597.12]
["Spain","National currency per US dollar",0.63,0.623,0.62,0.619,0.608,0.593]
["Sri Lanka","National currency per US dollar",49.39,50.084,50.55,51.658,52.424,74.053]
["Sudan","National currency per US dollar",4.619,7.094,10.654,27.822,76.914,136.567]
["Suriname","National currency per US dollar",2.578,2.661,2.729,3.907,5.701,8.012]
["Sweden","National currency per US dollar",8.719,8.72,8.785,8.833,8.732,8.6]
["Switzerland","National currency per US dollar",1.18,1.161,1.139,1.12,1.091,1.042]
["Syria","National currency per US dollar","no data","no data","no data","no data","no data","no data"]
["São Tomé and Príncipe","National currency per US dollar",10.055,10.076,10.589,11.045,10.935,12.014]
["Taiwan Province of China","National currency per US dollar",15.73,15.272,14.981,14.995,15.137,14.072]
["Tajikistan","National currency per US dollar",2.231,2.233,2.274,2.284,2.293,2.381]
["Tanzania","National currency per US dollar",885.083,878.093,874.448,875.261,875.547,854.775]
["Thailand","National currency per US dollar",12.845,12.724,12.625,12.324,12.041,11.716]
["Timor-Leste","National currency per US dollar",0.409,0.394,0.419,0.346,0.434,0.488]
["Togo","National currency per US dollar",239.722,237.278,236.7,236.868,231.546,222.545]
["Tonga","National currency per US dollar",1.74,1.787,1.891,1.8,1.753,1.701]
["Trinidad and Tobago","National currency per US dollar",4.162,4.202,4.137,3.95,3.834,4.431]
["Tunisia","National currency per US dollar",0.794,0.838,0.88,0.935,0.946,0.937]
["Turkey","National currency per US dollar",1.373,1.562,1.747,1.982,2.431,{"$error":"#N/A"}]
["Turkmenistan","National currency per US dollar",1.623,1.65,1.825,1.866,2.036,2.296]
["Tuvalu","National currency per US dollar",1.352,1.417,1.48,1.479,1.459,1.491]
["Uganda","National currency per US dollar",1270.608,1308.593,1314.949,1331.135,1305.179,1307.878]
["Ukraine","National currency per US dollar",5.916,6.664,7.087,7.672,9.213,11.109]
["United Arab Emirates","National currency per US dollar",2.222,2.348,2.204,1.996,2.141,2.25]
["United Kingdom","National currency per US dollar",0.682,0.68,0.681,0.707,0.681,0.668]
["United States","National currency per US dollar",1,1,1,1,1,1]
["Uruguay","National currency per US dollar",23.294,24.366,25.978,28.5,30.091,30.576]
["Uzbekistan","National currency per US dollar",1432.907,1777.095,2058.547,2270.919,2475.938,2614.223]
["Vanuatu","National currency per US dollar",124.292,125.285,127.119,127.866,126.659,121.857]
["Vietnam","National currency per US dollar",7395.338,7469.454,7474.995,7505.038,7406.023,7200.255]
["West Bank and Gaza","National currency per US dollar",2.036,1.977,2.003,1.953,1.9,1.85]
["Yemen","National currency per US dollar",164.766,184.825,194.96,233.778,373.026,341.536]
["Zambia","National currency per US dollar",4.193,4.398,4.651,5.227,6.016,6.279]
["Zimbabwe","National currency per US dollar",0.641,1.032,5.482,36.236,79.481,323.017]

{"sheet":"Financial Data - Exchange Rate","index":19,"n_rows":109,"n_cols":7,"rows_kept":109}
["Country","Measure","2021","2022"]
["Albania","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",103.52,{"v":113.041666666667,"d":"113.04"},null,"Sources"]
["Algeria","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":135.064058333333,"d":"135.06"},{"v":141.994975,"d":"141.99"},null,"IMF data download","https://data.imf.org/?sk=4C514D48-B6BA-49ED-8AB9-52B0C1A0179B&sId=1390030341854"]
["Andorra","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":0.845376564367945,"d":"0.85"},{"v":0.950915533962108,"d":"0.95"}]
["Angola","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":631.441955506727,"d":"631.44"},{"v":460.567511631462,"d":"460.57"}]
["Anguilla","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":2.7,"d":"2.70"},{"v":2.7,"d":"2.70"}]
["Antigua and Barbuda","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":2.7,"d":"2.70"},{"v":2.7,"d":"2.70"}]
["Argentina","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":94.9907416666667,"d":"94.99"},{"v":130.61655,"d":"130.62"}]
["Armenia","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":503.769674961652,"d":"503.77"},{"v":435.6661796523,"d":"435.67"}]
["Aruba","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",1.79,1.79]
["Australia","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":1.33122425957081,"d":"1.33"},{"v":1.44166445896522,"d":"1.44"}]
["Azerbaijan","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":1.7,"d":"1.70"},{"v":1.7,"d":"1.70"}]
["Bahamas","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":1,"d":"1.00"},{"v":1,"d":"1.00"}]
["Bahrain, Kingdom of","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":0.376,"d":"0.38"},{"v":0.376,"d":"0.38"}]
["Bangladesh","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":85.08376325,"d":"85.08"},{"v":91.7454544396961,"d":"91.75"}]
["Barbados","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":2,"d":"2.00"},{"v":2,"d":"2.00"}]
["Belarus, Rep. of","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":2.538675,"d":"2.54"},{"v":2.6261,"d":"2.63"}]
["Belize","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":2,"d":"2.00"},{"v":2,"d":"2.00"}]
["Benin","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":554.602599205008,"d":"554.60"},{"v":623.937311932306,"d":"623.94"}]
["Bermuda","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":1,"d":"1.00"},{"v":1,"d":"1.00"}]
["Bhutan","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":73.9393482494058,"d":"73.94"},{"v":78.5975702918448,"d":"78.60"}]
["Bolivia","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",6.91,6.91]
["Bosnia and Herzegovina","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":1.65360615435868,"d":"1.65"},{"v":1.85932587706093,"d":"1.86"}]
["Botswana","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":11.0872583333333,"d":"11.09"},{"v":12.3688083333333,"d":"12.37"}]
["Brazil","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":5.39440078962503,"d":"5.39"},{"v":5.16397029102111,"d":"5.16"}]
["Brunei Darussalam","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":1.34380696297339,"d":"1.34"},{"v":1.37895639652216,"d":"1.38"}]
["Bulgaria","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":1.653775,"d":"1.65"},{"v":1.86014166666667,"d":"1.86"}]
["Burkina Faso","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":554.530675033104,"d":"554.53"},{"v":623.759700911182,"d":"623.76"}]
["Burundi","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":1975.95088138768,"d":"1,975.95"},{"v":2034.30663430472,"d":"2,034.31"}]
["Cabo Verde","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":93.2180924116109,"d":"93.22"},{"v":105.530782711447,"d":"105.53"}]
["Cambodia","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":4098.72279505889,"d":"4,098.72"},{"v":4102.03786482335,"d":"4,102.04"}]
["Cameroon","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":554.530675033104,"d":"554.53"},{"v":623.759700911182,"d":"623.76"}]
["Canada","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":1.2538769021268,"d":"1.25"},{"v":1.30155477474355,"d":"1.30"}]
["Cayman Islands","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":0.83333,"d":"0.83"},{"v":0.83333,"d":"0.83"}]
["Central African Rep.","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":554.530675033104,"d":"554.53"},{"v":623.759700911182,"d":"623.76"}]
["Chad","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":554.530675033104,"d":"554.53"},{"v":623.759700911182,"d":"623.76"}]
["Chile","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":758.955378658977,"d":"758.96"},{"v":873.314189543014,"d":"873.31"}]
["China, P.R.: Hong Kong","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":7.77325,"d":"7.77"},{"v":7.83141666666667,"d":"7.83"}]
["China, P.R.: Macao","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":8.00553175,"d":"8.01"},{"v":8.06520608333333,"d":"8.07"}]
["China, P.R.: Mainland","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":6.44897518024316,"d":"6.45"},{"v":6.73715811237119,"d":"6.74"}]
["Colombia","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":3743.58981919687,"d":"3,743.59"},{"v":4256.19416666667,"d":"4,256.19"}]
["Comoros, Union of the","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":415.955849148115,"d":"415.96"},{"v":467.184261187176,"d":"467.18"}]
["Congo, Dem. Rep. of the","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":1989.39147122828,"d":"1,989.39"},"-"]
["Congo, Rep. of","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":554.530675033104,"d":"554.53"},{"v":623.759700911182,"d":"623.76"}]
["Costa Rica","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":620.784720014081,"d":"620.78"},{"v":647.135817631363,"d":"647.14"}]
["Côte d'Ivoire","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":554.530675033104,"d":"554.53"},{"v":623.759700911182,"d":"623.76"}]
["Croatia, Rep. of","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":6.36008316666667,"d":"6.36"},{"v":7.1597415,"d":"7.16"}]
["Curaçao and Sint Maarten","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",1.79,1.79]
["Curaçao, Kingdom of the Netherlands","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",1.79,1.79]
["Czech Rep.","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":21.6781666666667,"d":"21.68"},{"v":23.357,"d":"23.36"}]
["Denmark","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":6.2871130825,"d":"6.29"},{"v":7.0761518625,"d":"7.08"}]
["Djibouti","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":177.721,"d":"177.72"},{"v":177.721,"d":"177.72"}]
["Dominica","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":2.7,"d":"2.70"},{"v":2.7,"d":"2.70"}]
["Dominican Rep.","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":57.2211166666667,"d":"57.22"},{"v":55.1409916666667,"d":"55.14"}]
["Ecuador","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":1,"d":"1.00"},{"v":1,"d":"1.00"}]
["Egypt, Arab Rep. of","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":15.6445272777113,"d":"15.64"},{"v":19.1604397412204,"d":"19.16"}]
["El Salvador","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":1,"d":"1.00"},{"v":1,"d":"1.00"}]
["Equatorial Guinea, Rep. of","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":554.530675033104,"d":"554.53"},{"v":623.759700911182,"d":"623.76"}]
["Eritrea, The State of","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":15.075,"d":"15.08"},{"v":15.075,"d":"15.08"}]
["Eswatini, Kingdom of","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":14.7834351395784,"d":"14.78"},{"v":16.3622830559282,"d":"16.36"}]
["Euro Area","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":0.84549413889045,"d":"0.85"},{"v":0.949623753156941,"d":"0.95"}]
["Fiji, Rep. of","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":2.07063333333333,"d":"2.07"},{"v":2.2014069869585,"d":"2.20"}]
["French Polynesia","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":100.880222566186,"d":"100.88"},{"v":113.474367224106,"d":"113.47"}]
["Iran, Islamic Rep. of","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":42000,"d":"42,000.00"},"-"]
["Isle of Man","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":0.727064944688322,"d":"0.73"},{"v":0.811301715827773,"d":"0.81"}]
["Israel","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":3.23019832251082,"d":"3.23"},{"v":3.35961440158189,"d":"3.36"}]
["Japan","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":109.754323839417,"d":"109.75"},{"v":131.498140443764,"d":"131.50"}]
["Jersey","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":0.727064944688322,"d":"0.73"},{"v":0.811301715827773,"d":"0.81"}]
["Jordan","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",0.71,0.71]
["Kazakhstan, Rep. of","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":425.9075,"d":"425.91"},{"v":460.165,"d":"460.17"}]
["Kenya","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":109.637746592367,"d":"109.64"},{"v":117.865989201683,"d":"117.87"}]
["Kiribati","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":1.33122425957081,"d":"1.33"},{"v":1.44166445896522,"d":"1.44"}]
["Korea, Rep. of","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":1143.95166666667,"d":"1,143.95"},{"v":1291.44666666667,"d":"1,291.45"}]
["Kosovo, Rep. of","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":0.845376564367945,"d":"0.85"},{"v":0.950915533962108,"d":"0.95"}]
["Kuwait","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":0.301643110769949,"d":"0.30"},{"v":0.306250154417754,"d":"0.31"}]
["Kyrgyz Rep.","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":84.6408220065285,"d":"84.64"},"-"]
["Lebanon","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":1507.5,"d":"1,507.50"},{"v":1507.5,"d":"1,507.50"}]
["Lesotho, Kingdom of","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":14.7786782139167,"d":"14.78"},{"v":16.3558534845,"d":"16.36"}]
["Solomon Islands","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":8.03010299104932,"d":"8.03"},"-"]
["South Africa","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":14.7786782139167,"d":"14.78"},{"v":16.3558534845,"d":"16.36"}]
["South Sudan, Rep. of","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":306.354619937276,"d":"306.35"},"-"]
["St. Kitts and Nevis","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":2.7,"d":"2.70"},{"v":2.7,"d":"2.70"}]
["St. Lucia","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":2.7,"d":"2.70"},{"v":2.7,"d":"2.70"}]
["St. Vincent and the Grenadines","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":2.7,"d":"2.70"},{"v":2.7,"d":"2.70"}]
["Suriname","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":18.238666375,"d":"18.24"},{"v":24.709174756579,"d":"24.71"}]
["Sweden","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":8.57656671607378,"d":"8.58"},{"v":10.114251277564,"d":"10.11"}]
["Switzerland","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":0.913845833333333,"d":"0.91"},{"v":0.9548325,"d":"0.95"}]
["Taiwan Province of China","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":28.0235,"d":"28.02"},{"v":29.8063333333333,"d":"29.81"}]
["Tajikistan, Rep. of","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":11.30885,"d":"11.31"},{"v":11.031075,"d":"11.03"}]
["Thailand","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":31.9770934417717,"d":"31.98"},{"v":35.0613502144776,"d":"35.06"}]
["Timor-Leste, Dem. Rep. of","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":1,"d":"1.00"},{"v":1,"d":"1.00"}]
["Togo","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":554.530675033104,"d":"554.53"},{"v":623.759700911182,"d":"623.76"}]
["Tonga","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":2.26310728305551,"d":"2.26"},{"v":2.32792982731644,"d":"2.33"}]
["Trinidad and Tobago","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":6.75853004916294,"d":"6.76"},{"v":6.75412896099475,"d":"6.75"}]
["Tunisia","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":2.79446666666667,"d":"2.79"},{"v":3.1036,"d":"3.10"}]
["Uganda","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":3587.05170733908,"d":"3,587.05"},{"v":3689.81738566862,"d":"3,689.82"}]
["Ukraine","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":27.2861893833333,"d":"27.29"},{"v":32.3423016,"d":"32.34"}]
["United Arab Emirates","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":3.6725,"d":"3.67"},{"v":3.6725,"d":"3.67"}]
["United Kingdom","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":0.727064944688322,"d":"0.73"},{"v":0.811301715827773,"d":"0.81"}]
["United States","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":1,"d":"1.00"},{"v":1,"d":"1.00"}]
["Uruguay","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":43.554575,"d":"43.55"},{"v":41.1710833333333,"d":"41.17"}]
["Uzbekistan, Rep. of","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":10609.464390809,"d":"10,609.46"},{"v":11050.145422363,"d":"11,050.15"}]
["Vietnam","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":23159.7825925926,"d":"23,159.78"},{"v":23271.2125,"d":"23,271.21"}]
["Yemen, Rep. of","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":1035.46718555887,"d":"1,035.47"},{"v":1110.2028088357,"d":"1,110.20"}]
["Zambia","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":20.0184865859688,"d":"20.02"},{"v":16.9375943252989,"d":"16.94"}]
["Zimbabwe","Exchange Rates, National Currency Per U.S. Dollar, Period Average, Rate",{"v":88.5524472597436,"d":"88.55"},{"v":374.954362604663,"d":"374.95"}]
["Romania",null,4.16,{"v":4.688475,"d":"4.69"},null,"https://data.oecd.org/conversion/exchange-rates.htm"]
["Moldova",null,{"v":17.7633778352,"d":"17.76"},{"v":18.8971896198157,"d":"18.90"},null,"xe.com/currencytables/"]
["Norway",null,8.59,{"v":9.61416666666667,"d":"9.61"},null,"https://data.oecd.org/conversion/exchange-rates.htm"]