{"text_format":"1","workbook":"xlsx","n_sheets":27,"sheets":["MAIN MENU","INSTRUCTIONS","INFO OP","INFO OSR","INFO BIAR","INFO IB","INFO AM","INFO DS","INFO ROEPC","DATA OP","DATA  OSR","DATA BIAR","DATA IB","DATA AM","DATA DS","DATA ROEPC","CALC OP","CALC OSR","CALC BIAR","CALC IB","CALC AM","CALC DS","CALC ROEPC","RESULTS","POPULATION","Sheet1","Sheet2"],"not_rendered":{"charts":7,"images":10,"macros":1,"external_links":0,"defined_names":26,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"MAIN MENU","index":0,"n_rows":39,"n_cols":18,"rows_kept":39,"cut":false,"hidden":false,"merged":[[3,3,3,5],[4,12,5,14],[8,8,11,10],[13,8,16,10],[23,8,26,10],[18,8,21,10],[5,3,8,5],[13,12,16,14],[33,8,36,10],[38,8,41,10],[8,12,11,14],[18,12,21,14],[23,12,26,14],[28,12,31,14],[28,8,31,10],[13,17,16,19],[13,20,16,20],[38,12,41,14],[42,12,43,14],[5,17,8,19],[17,17,17,19],[33,12,36,14],[3,17,3,19],[5,8,5,10],[5,20,8,20],[9,17,10,19],[9,20,10,20]]}
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Self Assessment Tool"]
[null,null,null,"START HERE",null,null,null,null,null,null,null,null,null,null,null,null,null,"END HERE"]
[null,null,null,null,null,null,null,null,null,null,null,null,"RESULTS"]
[null,null,null,"How To Instructions",null,null,null,null,"ENTER DATA HERE",null,null,null,null,null,null,null,null,"Overall Results"]
[]
[]
[null,null,null,null,null,null,null,null,"Operating Performance Data",null,null,null,"Operating Performance Result"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Own Source Revenue Data",null,null,null,"Own Source Revenue Result"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Building and Infrastructure Asset Renewal Data",null,null,null,"Building and Infrastructure Asset Renewal Result"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Infrastructure Backlog Data",null,null,null,"Infrastructure Backlog Result"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Asset Maintenance Data",null,null,null,"Asset Maintenance Result"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Debt Service Data",null,null,null,"Debt Service Result"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Real Operating  Expenditure Per Capita Data",null,null,null,"Real Operating Expenditure Per Capita Result"]

{"sheet":"INSTRUCTIONS","index":1,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[[2,11,5,13],[7,11,10,13],[4,1,4,2]]}
[]
[null,"INSTRUCTIONS"]
[]
[]
[null,null,null,"The Council of the Shire of Wakool"]
[null,"COUNCILS ARE TO USE ONLY GENERAL FUND DATA FOR THIS PURPOSE"]

{"sheet":"INFO OP","index":2,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[[11,1,11,10],[12,1,12,10],[5,1,5,10],[4,1,4,10],[3,1,3,10],[6,1,6,10],[7,1,7,10],[8,1,8,10],[9,1,9,10]]}
[]
[null,"OPERATING PERFORMANCE RATIO"]
[null,{"$f":"INSTRUCTIONS!D5","v":"The Council of the Shire of Wakool"}]
[null,"Total continuing operating revenue (exc. capital grants and contributions) less operating expenses"]
[null,"Total continuing operating revenue (exc. capital grants and contributions) "]
[]
[null,"Description and Rationale for Criteria:"]
[null,"·         TCorp in their review of financial sustainability of local government found that operating performance was a core measure of financial sustainability."]
[null,"·         Ongoing operating deficits are unsustainable and they are one of the key financial sustainability challenges facing the sector as a whole. While operating deficits are acceptable over a short period, consistent deficits will not allow Councils to maintain or increase their assets and services or execute their infrastructure plans."]
[null,"·         Operating performance ratio is an important measure as it provides an indication of how a Council generates revenue and allocates expenditure (e.g. asset maintenance, staffing costs). It is an indication of continued capacity to meet on-going expenditure requirements."]
[]
[null,"Description and Rationale for Benchmark:"]
[null,"·         TCorp recommended that all Councils should be at least break even operating position or better, as a key component of financial sustainability. Consistent with this recommendation the benchmark for this criteria is greater than or equal to break even over a 3 year period."]

{"sheet":"INFO OSR","index":3,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[[11,1,11,10],[12,1,12,10],[10,1,10,10],[5,1,5,10],[3,1,3,10],[4,1,4,10],[6,1,6,10],[7,1,7,10],[8,1,8,10]]}
[]
[null,"OWN SOURCE REVENUE RATIO"]
[null,{"$f":"INSTRUCTIONS!D5","v":"The Council of the Shire of Wakool"}]
[null,"Total continuing operating revenue less all grants and contributions"]
[null,"Total continuing operating revenue inclusive of capital grants and contributions"]
[null,"\n\n"]
[null,"Description and Rationale for Criteria:"]
[null,"·         Own source revenue measures the degree of reliance on external funding sources (e.g. grants and contributions). This ratio measures fiscal flexibility and robustness. Financial flexibility increases as the level of own source revenue increases. It also gives councils greater ability to manage external shocks or challenges."]
[null,"·         Councils with higher own source revenue have greater ability to control or manage their own operating performance and financial sustainability."]
[]
[null,"Description and Rationale for Benchmark:"]
[null,"·         TCorp has used a benchmark for own source revenue of greater than 60 per cent of total operating revenue. All Councils should aim to meet or exceed this benchmark over a three year period."]
[null,"·         It is acknowledged that many councils have limited options in terms of increasing its own source revenue, especially in rural areas. However, 60 per cent is considered the lowest level at which councils have the flexibility necessary to manage external shocks and challenges."]

{"sheet":"INFO BIAR","index":4,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[[8,1,8,10],[9,1,9,10],[12,1,12,10],[13,1,13,10],[11,1,11,10],[6,1,6,10],[1,1,1,10],[3,1,3,10],[4,1,4,10],[7,1,7,10]]}
[]
[null,"BUILDING AND INFRASTRUCTURE ASSET RENEWAL RATIO"]
[null,{"$f":"INSTRUCTIONS!D5","v":"The Council of the Shire of Wakool"}]
[null,"Asset renewals (building and infrastructure)"]
[null,"Depreciation, amortisation and impairment (building and infrastructure)"]
[]
[null,"\n\n"]
[null,"Description and Rationale for Criteria:"]
[null,"·         The building and infrastructure renewals ratio represents the replacement or refurbishment of existing assets to an equivalent capacity or performance, as opposed to the acquisition of new assets or the refurbishment of old assets that increase capacity or performance. The ratio compares the proportion spent on infrastructure asset renewals and the asset’s deterioration."]
[null,"·         This is a consistent measure that can be applied across councils of different sizes and locations. A higher ratio is an indicator of strong performance."]
[]
[null,"Description and Rationale for Benchmark:"]
[null,"·         Performance of less than one hundred percent indicates that a Council’s existing assets are deteriorating faster than they are being renewed and that potentially council’s infrastructure backlog is worsening. Councils with consistent asset renewals deficits will face degradation of building and infrastructure assets over time."]
[null,"·         Given that a ratio of greater than one hundred percent is adopted, to recognise that capital expenditures are sometimes lumpy and can be lagged, performance is averaged over three years."]

{"sheet":"INFO IB","index":5,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[[11,1,11,11],[12,1,12,11],[3,1,3,11],[4,1,4,11],[10,1,10,11],[6,1,6,11],[7,1,7,11],[8,1,8,11],[9,1,9,11]]}
[]
[null,"INFRASTRUCTURE BACKLOG RATIO"]
[null,{"$f":"INSTRUCTIONS!D5","v":"The Council of the Shire of Wakool"}]
[null,"Estimated cost to bring assets to a satisfactory condition"]
[null,"Total (WDV) of infrastructure, buildings, other structures and depreciable land improvement assets"]
[]
[null,"Description and Rationale for Criteria:"]
[null,"·         The infrastructure backlog ratio indicates the proportion of backlog against the total value of the Council’s infrastructure assets. It is a measure of the extent to which asset renewal is required to maintain or improve service delivery in a sustainable way.  This measures how councils are managing their infrastructure which is so critical to effective community sustainability."]
[null,"·         It is acknowledged, that the reliability of infrastructure data within NSW local government is mixed. However, as asset management practices within councils improve, it is anticipated that infrastructure reporting data reliability and quality will increase."]
[null,"·         This is a consistent measure that can be applied across councils of different sizes and locations. A low ratio is an indicator of strong performance."]
[null,"Description and Rationale for Benchmark:"]
[null,"·         High infrastructure backlog ratios and an inability to reduce this ratio in the near future indicate an underperforming Council in terms of infrastructure management and delivery. Councils with increasing infrastructure backlogs will experience added pressure in maintaining service delivery and financing current and future infrastructure demands."]
[null,"·         TCorp adopted a benchmark of less than 2 per cent to be consistently applied across councils. The application of this benchmark reflects the State Government’s focus on reducing infrastructure backlogs."]

{"sheet":"INFO AM","index":6,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[[12,1,12,10],[11,1,11,10],[5,1,5,10],[3,1,3,4],[4,1,4,4],[6,1,6,10],[10,1,10,10],[7,1,7,10],[8,1,8,10]]}
[]
[null,"ASSET MAINTENANCE RATIO"]
[null,{"$f":"INSTRUCTIONS!D5","v":"The Council of the Shire of Wakool"}]
[null,"Actual asset maintenance"]
[null,"Required asset maintenance"]
[null,"\n"]
[null,"Description and Rationale for Criteria:"]
[null,"·         The asset maintenance ratio reflects the actual asset maintenance expenditure relative to the required asset maintenance as measured by an individual council."]
[null,"·         The ratio provides a measure of the rate of asset degradation (or renewal) and therefore has a role in informing asset renewal and capital works planning."]
[]
[null,"Description and Rationale for Benchmark:"]
[null,"·         The benchmark adopted is greater than one hundred percent, which implies that asset maintenance expenditure exceeds the council identified requirements. This benchmark is consistently adopted by the NSW Treasury Corporation (TCORP). A ratio of less than one hundred percent indicates that there may be a worsening infrastructure backlog."]
[null,"·         Given that a ratio of greater than one hundred percent is adopted, to recognise that maintenance expenditure is sometimes lumpy and can be lagged, performance is averaged over three years."]

{"sheet":"INFO DS","index":7,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[[13,1,13,10],[14,1,14,10],[5,1,5,10],[3,1,3,10],[4,1,4,10],[6,1,6,10],[12,1,12,10],[7,1,7,10],[8,1,8,10],[9,1,9,10],[10,1,10,10]]}
[]
[null,"DEBT SERVICE RATIO"]
[null,{"$f":"INSTRUCTIONS!D5","v":"The Council of the Shire of Wakool"}]
[null,"Cost of debt service  (interest expense & principal repayments)"]
[null,"Total continuing operating revenue (exc. capital grants and contributions)"]
[null,"\n\n"]
[null,"Description and Rationale for Criteria:"]
[null,"·         Prudent and active debt management is a key part of Councils’ approach to both funding and managing infrastructure and services over the long term."]
[null,"·         Prudent debt usage can also assist in smoothing funding costs and promoting intergenerational equity. Given the long life of many council assets it is appropriate that the cost of these assets should be equitably spread across the current and future generations of users and ratepayers. Effective debt usage allows councils to do this."]
[null,"·         Inadequate use of debt may mean that councils are forced to raise rates that a higher than necessary to fund long life assets or inadequately fund asset maintenance and renewals. It is also a strong proxy indicator of a council’s strategic capacity."]
[null,"·         Council’s effectiveness in this area is measured by the Debt Service Ratio."]
[]
[null,"Description and Rationale for Benchmark:"]
[null,"·         As outlined above, it is appropriate for Councils to hold some level of debt given their role in the provision and maintenance of key infrastructure and services for their community. It is considered reasonable for Councils to maintain a Debt Service Ratio  of greater than 0 and less than or equal to 20 per cent."]
[null,"·         Councils with low or zero debt may incorrectly place the funding burden on current ratepayers when in fact it should be spread across generations, who also benefit from the assets. Likewise high levels of debt generally indicate a weakness in financial sustainability and/or poor balance sheet management."]

{"sheet":"INFO ROEPC","index":8,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[13,1,13,10],[14,1,14,10],[4,1,4,10],[12,1,12,10],[5,1,5,10],[6,1,6,10],[7,1,7,10],[10,1,10,10],[8,2,8,10],[9,2,9,10]]}
[]
[null,"REAL OPERATING EXPENDITURE PER CAPITA"]
[null,{"$f":"INSTRUCTIONS!D5","v":"The Council of the Shire of Wakool"}]
[]
[null,"Description and Rationale for Criteria:"]
[null,"·         At the outset it is acknowledged the difficulty in measuring public sector efficiency. This is because there is a range of difficulty in reliably and accurately measuring output."]
[null,"·         The capacity to secure economies of scale over time is a key indicator of operating efficiency. The capacity to secure efficiency improvements can be measured with respect to a range of factors, for example population, assets, and financial turnover."]
[null,"·         It is challenging to measure productivity changes over time. To overcome this, changes in real per capita expenditure was considered to assess how effectively Councils:"]
[null,null,"-          can realise natural efficiencies as population increases (through lower average cost of service delivery and representation); and"]
[null,null,"-          can make necessary adjustments to maintain current efficiency if population is declining (e.g. appropriate reductions in staffing or other costs)."]
[null,"·         Assuming that service levels remain constant, decline in real expenditure per capita indicates efficiency improvements (i.e. the same level of output per capita is achieved with reduced expenditure)."]
[]
[null,"Description and Rationale for Benchmark:"]
[null,"·         The measure 'trends in real expenditure per capita' reflects how the value of inflation adjusted inputs per person has grown over time.  In the calculation, the expenditure is deflated by the Consumer Price Index (for 2009-11) and the Local Government Cost Index (for 2011-14) as published by the Independent Pricing and Regulatory Tribunal (IPART).    It is acknowledged that efficiency and service levels are impacted by a broad range of factors, and that it is unreasonable to establish an absolute benchmark across Councils. It is also acknowledged that council service levels are likely to change for a variety of reasons however, it is important that councils prioritise or set service levels in conjunction with their community, in the context of their development of their Integrated Planning and Reporting."]
[null,"·         Councils  will be assessed on a joint consideration of the direction and magnitude of their improvement or deterioration in real expenditure per capita.  Given that efficiency improvements require some time for the results to be fully achieved and as a result, this analysis will be based on a 5-year trend."]

{"sheet":"DATA OP","index":9,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[[4,9,4,11],[31,1,31,6],[29,1,29,6]]}
[]
[null,"GENERAL FUND - OPERATING PERFORMANCE DATA"]
[null,{"$f":"INSTRUCTIONS!D5","v":"The Council of the Shire of Wakool"}]
[null,null,"2011-12                         GENERAL FUND DATA                              $000",null,"2012-13                            GENERAL FUND DATA                                      $000",null,"2013-14                          GENERAL FUND DATA                                       $000"]
[null,"Note 21- Income Statement - Income - Total Income from continuing operations ",16146,null,16906,null,14707]
[]
[null,"Note 21 - Income Statement - Income - Grants & Contributions Provided For Capital Purposes ",3053,null,826,null,1240]
[]
[null,"Note 21 - Income Statement - Income - Net gain from the disposal of assets",0,null,27,null,0]
[]
[null,"Note 21 - Income Statement - Income - Net share of interests in joint ventures/associates using the equity method",0,null,0,null,0]
[]
[null,"# Interest & Investment Revenue - Fair value adjustments - Investments",0,null,0,null,0]
[]
[null,"# Interest & Investment Revenue - Fair value adjustments - Other",0,null,0,null,0]
[]
[null,"# Other Revenues - Fair value adjustments - investment properties",0,null,0,null,0]
[]
[null,"# Other Revenues - Reversal of IPPE revaluation decrements previously expensed",0,null,0,null,0]
[]
[null,"Note 21 -  Income Statement - Expenses - Total expenses from continuing operations ",15307,null,15503,null,15059]
[]
[null,"Note 21 - Income Statement - Expenses - Net Loss from the disposal of assets",211,null,0,null,189]
[]
[null,"Note 21 - Income Statement  - Expenses - Net share of interests in joint ventures/associates using the equity method",0,null,0,null,0]
[]
[null,"* Other Expenses - Revaluation Decrements",0,null,0,null,0]
[]
[]
[null,"# For reporting purposes the consolidated data comes from Note 3. For this purpose, only enter data that relates to the General Fund"]
[]
[null,"* For reporting purposes the consolidated data comes from Note 4. For this purpose, only enter data that relates to the General Fund"]

{"sheet":"DATA  OSR","index":10,"n_rows":24,"n_cols":7,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[null,"GENERAL FUND - OWN SOURCE REVENUE DATA"]
[null,{"$f":"INSTRUCTIONS!D5","v":"The Council of the Shire of Wakool"}]
[null,null,"2011-12                                   GENERAL FUND DATA                                      $000",null,"2012-13                 GENERAL FUND DATA                           $000",null,"2013-14                             GENERAL FUND DATA                           $000"]
[null,"Note 21- Income Statement - Income - Total Income from continuing operations ",{"$f":"'DATA OP'!C5","v":16146},null,{"$f":"'DATA OP'!E5","v":16906},null,{"$f":"'DATA OP'!G5","v":14707}]
[]
[null,"Note 21 - Income Statement - Income - Operating Revenues - Grants & Contributions Provided For Operating Purposes ",{"$f":"6811-2480-1701","v":2630},null,{"$f":"9176-1555-1724","v":5897},null,{"$f":"6441-1104-669","v":4668}]
[]
[null,"Note 21 - Income Statement - Income - Grants & Contributions Provided For Capital Purposes ",{"$f":"'DATA OP'!C7","v":3053},null,{"$f":"'DATA OP'!E7","v":826},null,{"$f":"'DATA OP'!G7","v":1240}]
[]
[null,"Note 21 - Income Statement - Income - Net gain from the disposal of assets",{"$f":"'DATA OP'!C9","v":0},null,{"$f":"'DATA OP'!E9","v":27},null,{"$f":"'DATA OP'!G9","v":0}]
[]
[null,"Note 21 - Income Statement - Income - Net share of interests in joint ventures/associates using the equity method",{"$f":"'DATA OP'!C11","v":0},null,{"$f":"'DATA OP'!E11","v":0},null,{"$f":"'DATA OP'!G11","v":0}]
[]
[null,"# Interest & Investment Revenue - Fair value adjustments - Investments",{"$f":"'DATA OP'!C13","v":0},null,{"$f":"'DATA OP'!E13","v":0},null,{"$f":"'DATA OP'!G13","v":0}]
[]
[null,"# Interest & Investment Revenue - Fair value adjustments - Other",{"$f":"'DATA OP'!C15","v":0},null,{"$f":"'DATA OP'!E15","v":0},null,{"$f":"'DATA OP'!G15","v":0}]
[]
[null,"# Other Revenues - Fair value adjustments - investment properties",{"$f":"'DATA OP'!C17","v":0},null,{"$f":"'DATA OP'!E17","v":0},null,{"$f":"'DATA OP'!G17","v":0}]
[]
[null,"# Other Revenues - Reversal of IPPE revaluation decrements previously expensed",{"$f":"'DATA OP'!C19","v":0},null,{"$f":"'DATA OP'!E19","v":0},null,0]
[]
[]
[null,"#  See Operating Performance data sheet notes."]

{"sheet":"DATA BIAR","index":11,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[8,1,8,6],[1,1,1,6]]}
[]
[null,"GENERAL FUND - BUILDING AND INFRASTRUCTURE ASSET RENEWAL DATA"]
[null,{"$f":"INSTRUCTIONS!D5","v":"The Council of the Shire of Wakool"}]
[null,null,"2011-12                              GENERAL FUND  DATA                              $000",null,"2012-13                                 GENERAL FUND DATA                               $000",null,"2013-14                                   GENERAL FUND DATA                                  $000"]
[null,"# Building and Infrastructure Renewals",3789,null,4334,null,5061]
[]
[null,"# Depreciation, Amortisation and Impairment (Building and Infrastructure)",6530,null,5124,null,4837]
[]
[null,"# For reporting purposes the consolidated data comes from Note 13 (11-12, 12-13) and Special Schedule 7 (13-14).  For this purpose, only enter data that relates to the General Fund."]

{"sheet":"DATA IB","index":12,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[9,1,9,3],[11,1,11,3],[1,1,1,4]]}
[]
[null,"GENERAL FUND - INFRASTRUCTURE BACKLOG DATA"]
[null,{"$f":"INSTRUCTIONS!D5","v":"The Council of the Shire of Wakool"}]
[null,null,null,"2013-14                                 GENERAL FUND DATA                                $000"]
[null,"# Estimated cost to bring assets to a satisfactory condition",null,43986]
[]
[null,"* Total (written down value) of infrastructure, buildings, other structures & depreciable land improvement assets.",null,159078]
[]
[]
[null,"#  For reporting purposes the consolidated data is collected from Special Schedule 7.  For this purpose, only enter data that relates to the General Fund."]
[]
[null,"* For reporting purposes the consolidated data comes from Note 9/Special Schedule 7 .  For this purpose, only enter data that relates to the General Fund."]

{"sheet":"DATA AM","index":13,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[8,1,8,6]]}
[]
[null,"GENERAL FUND - ASSET MAINTENANCE DATA"]
[null,{"$f":"INSTRUCTIONS!D5","v":"The Council of the Shire of Wakool"}]
[null,null,"2011-12                                 GENERAL FUND DATA                                $000",null,"2012-13                                 GENERAL FUND DATA                                $000",null,"2013-14                                 GENERAL FUND DATA                                $000"]
[null,"# Actual Annual Maintenance",3193,null,2209,null,2463]
[]
[null,"# Required Annual Maintenance",3517,null,2230,null,2340]
[]
[null,"# For reporting purposes the consolidated data comes from Special Schedule 7.  For this purpose, only enter data that relates to the General Fund."]

{"sheet":"DATA DS","index":14,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[[26,1,26,6],[28,1,28,6]]}
[]
[null,"GENERAL FUND - DEBT SERVICE DATA "]
[null,{"$f":"INSTRUCTIONS!D5","v":"The Council of the Shire of Wakool"}]
[null,null,"2011-12                             GENERAL FUND DATA            $000",null,"2012-13                                     GENERAL FUND DATA                   $000",null,"2013-14                            GENERAL FUND DATA                     $000"]
[null,"@ Financing Activities - Payments - Borrowings & Advances",545,null,536,null,711]
[]
[null,"* Interest Charges - Interest on Loans",206,null,163,null,240]
[]
[null,"Note 21- Income Statement - Income - Total Income from continuing operations ",{"$f":"'DATA OP'!C5","v":16146},null,{"$f":"'DATA OP'!E5","v":16906},null,{"$f":"'DATA OP'!G5","v":14707}]
[]
[null,"Note 21 - Income Statement - Income - Grants & Contributions Provided For Capital Purposes ",{"$f":"'DATA OP'!C7","v":3053},null,{"$f":"'DATA OP'!E7","v":826},null,{"$f":"'DATA OP'!G7","v":1240},null,null,null," "]
[]
[null,"Note 21 - Income Statement - Income - Net gain from the disposal of assets",{"$f":"'DATA OP'!C9","v":0},null,{"$f":"'DATA OP'!E9","v":27},null,{"$f":"'DATA OP'!G9","v":0}]
[]
[null,"Note 21 - Income Statement - Income - Net share of interests in joint ventures/associates using the equity method",{"$f":"'DATA OP'!C11","v":0},null,{"$f":"'DATA OP'!E11","v":0},null,{"$f":"'DATA OP'!G11","v":0}]
[]
[null,"# Interest & Investment Revenue - Fair value adjustments - Investments",{"$f":"'DATA OP'!C13","v":0},null,{"$f":"'DATA OP'!E13","v":0},null,{"$f":"'DATA OP'!G13","v":0}]
[]
[null,"# Interest & Investment Revenue - Fair value adjustments - Other",{"$f":"'DATA OP'!C15","v":0},null,{"$f":"'DATA OP'!E15","v":0},null,{"$f":"'DATA OP'!G15","v":0}]
[]
[null,"# Other Revenues - Fair value adjustments - investment properties",{"$f":"'DATA OP'!C17","v":0},null,{"$f":"'DATA OP'!E17","v":0},null,{"$f":"'DATA OP'!G17","v":0}]
[]
[null,"# Other Revenues - Reversal of IPPE revaluation decrements previously expensed",{"$f":"'DATA OP'!C19","v":0},null,{"$f":"'DATA OP'!E19","v":0},null,{"$f":"'DATA OP'!G19","v":0}]
[]
[null,"Note:- Figures to be entered as positive amounts"]
[]
[null,"@ For reporting purposes the consolidated data comes from the Statement of Cashflows. For this purpose, only enter data that relates to the General Fund."]
[]
[null,"* For reporting purposes the consolidated data comes from Note 4. For this purpose, only enter data that relates to the General Fund"]
[null,"# See Operating Performance data sheet note"]

{"sheet":"DATA ROEPC","index":15,"n_rows":18,"n_cols":11,"rows_kept":18,"cut":false,"hidden":false,"merged":[[15,1,15,10]]}
[]
[null,"GENERAL FUND - REAL OPERATING EXPENDITURE PER CAPITA DATA "]
[null,{"$f":"INSTRUCTIONS!D5","v":"The Council of the Shire of Wakool"}]
[]
[null,"# Population Data ",{"$f":"IF(ISERROR(VLOOKUP(B3,POPULATION!B9:Y160,17,FALSE)),\"\",VLOOKUP(B3,POPULATION!B9:Y160,17,FALSE))","v":4174.5},null,{"$f":"IF(ISERROR(VLOOKUP(B3,POPULATION!B9:Y160,19,FALSE)),\"\",VLOOKUP(B3,POPULATION!B9:Y160,19,FALSE))","v":4106.5},null,{"$f":"IF(ISERROR(VLOOKUP(B3,POPULATION!B9:Y160,21,FALSE)),\"\",VLOOKUP(B3,POPULATION!B9:Y160,21,FALSE))","v":4055.5},null,{"$f":"IF(ISERROR(VLOOKUP(B3,POPULATION!B9:Y160,23,FALSE)),\"\",VLOOKUP(B3,POPULATION!B9:Y160,23,FALSE))","v":4008.5},null,{"$f":"IF(ISERROR(VLOOKUP(B3,POPULATION!B9:Y160,24,FALSE)),\"\",VLOOKUP(B3,POPULATION!B9:Y160,24,FALSE))","v":3979}]
[null,null,"2009-10                             GENERAL FUND DATA                    $000",null,"2010-11                               GENERAL FUND DATA                      $000",null,"2011-12                               GENERAL FUND DATA                        $000",null,"2012-13                                   GENERAL FUND DATA                 $000",null,"2013-14                             GENERAL FUND DATA                         $000"]
[null,"Note 21 -  Income Statement - Expenses - Total expenses from continuing operations ",20360,null,15569,null,{"$f":"'DATA OP'!C21","v":15307},null,{"$f":"'DATA OP'!E21","v":15503},null,{"$f":"'DATA OP'!G21","v":15059}]
[]
[null,"Note 21 - Income Statement - Expenses - Net Loss from the disposal of assets",7541,null,381,null,{"$f":"'DATA OP'!C23","v":211},null,{"$f":"'DATA OP'!E23","v":0},null,{"$f":"'DATA OP'!G23","v":189}]
[]
[null,"Note 21 - Income Statement  - Expenses - Net share of interests in joint ventures/associates using the equity method",0,null,0,null,{"$f":"'DATA OP'!C25","v":0},null,{"$f":"'DATA OP'!E25","v":0},null,{"$f":"'DATA OP'!G25","v":0}]
[]
[null,"* Other Expenses - Revaluation Decrements",0,null,0,null,{"$f":"'DATA OP'!C27","v":0},null,{"$f":"'DATA OP'!E27","v":0},null,{"$f":"'DATA OP'!G27","v":0}]
[]
[]
[null,"# Australian Bureau of Statistics, Regional Population Growth, Australia - Table 1. Estimated Resident Population, Local Government Areas, New South Wales - Released 3.4.2014. The population data has been averaged over 2 calendar years except for the 2013-14 year where the population data for 2013 has been used."]
[]
[null,"* See Operating Performance data sheet note."]

{"sheet":"CALC OP","index":16,"n_rows":51,"n_cols":29,"rows_kept":51,"cut":false,"hidden":false,"merged":[[35,10,36,10],[40,8,41,8],[40,10,41,10],[46,8,47,8],[46,10,47,10],[50,1,50,11],[7,6,7,8],[8,6,8,8],[9,6,9,8],[18,9,18,11],[35,8,36,8],[15,9,17,11],[7,1,7,2],[30,1,30,9],[31,1,31,9],[35,11,36,11],[40,11,41,11],[46,11,47,11],[35,1,36,1],[40,1,41,1],[46,1,47,1]]}
[]
[null,"GENERAL FUND - OPERATING PERFORMANCE  RESULT"]
[null,{"$f":"INSTRUCTIONS!D5","v":"The Council of the Shire of Wakool"}]
[]
[null,"BENCHMARK AND RESULT"]
[null,"Benchmark:-","Greater or equal to break-even average over 3 years"]
[]
[null,null,null,"2011-12","2012-13","2013-14","Average over 3 years"]
[null,"Result",null,{"$f":"IF(ISERR(SUM(('DATA OP'!C5-'DATA OP'!C7-'DATA OP'!C9-'DATA OP'!C11-'DATA OP'!C13-'DATA OP'!C15-'DATA OP'!C17-'DATA OP'!C19-'DATA OP'!C21-'DATA OP'!C23-'DATA OP'!C25-'DATA OP'!C27)/SUM('DATA OP'!C5-'DATA OP'!C7-'DATA OP'!C9-'DATA OP'!C11-'DATA OP'!C13-'DATA OP'!C15-'DATA OP'!C17-'DATA OP'!C19))),\"\",SUM(('DATA OP'!C5-'DATA OP'!C7-'DATA OP'!C9-'DATA OP'!C11-'DATA OP'!C13-'DATA OP'!C15-'DATA OP'!C17-'DATA OP'!C19-'DATA OP'!C21-'DATA OP'!C23-'DATA OP'!C25-'DATA OP'!C27)/SUM('DATA OP'!C5-'DATA OP'!C7-'DATA OP'!C9-'DATA OP'!C11-'DATA OP'!C13-'DATA OP'!C15-'DATA OP'!C17-'DATA OP'!C19)))","v":-0.18521347284808676},{"$f":"IF(ISERR(SUM(('DATA OP'!E5-'DATA OP'!E7-'DATA OP'!E9-'DATA OP'!E11-'DATA OP'!E13-'DATA OP'!E15-'DATA OP'!E17-'DATA OP'!E19-'DATA OP'!E21-'DATA OP'!E23-'DATA OP'!E25-'DATA OP'!E27)/SUM('DATA OP'!E5-'DATA OP'!E7-'DATA OP'!E9-'DATA OP'!E11-'DATA OP'!E13-'DATA OP'!E15-'DATA OP'!E17-'DATA OP'!E19))),\"\",SUM(('DATA OP'!E5-'DATA OP'!E7-'DATA OP'!E9-'DATA OP'!E11-'DATA OP'!E13-'DATA OP'!E15-'DATA OP'!E17-'DATA OP'!E19-'DATA OP'!E21-'DATA OP'!E23-'DATA OP'!E25-'DATA OP'!E27)/SUM('DATA OP'!E5-'DATA OP'!E7-'DATA OP'!E9-'DATA OP'!E11-'DATA OP'!E13-'DATA OP'!E15-'DATA OP'!E17-'DATA OP'!E19)))","v":3.4261508752258148E-2},{"$f":"IF(ISERR(SUM(('DATA OP'!G5-'DATA OP'!G7-'DATA OP'!G9-'DATA OP'!G11-'DATA OP'!G13-'DATA OP'!G15-'DATA OP'!G17-'DATA OP'!G19-'DATA OP'!G21-'DATA OP'!G23-'DATA OP'!G25-'DATA OP'!G27)/SUM('DATA OP'!G5-'DATA OP'!G7-'DATA OP'!G9-'DATA OP'!G11-'DATA OP'!G13-'DATA OP'!G15-'DATA OP'!G17-'DATA OP'!G19))),\"\",SUM(('DATA OP'!G5-'DATA OP'!G7-'DATA OP'!G9-'DATA OP'!G11-'DATA OP'!G13-'DATA OP'!G15-'DATA OP'!G17-'DATA OP'!G19-'DATA OP'!G21-'DATA OP'!G23-'DATA OP'!G25-'DATA OP'!G27)/SUM('DATA OP'!G5-'DATA OP'!G7-'DATA OP'!G9-'DATA OP'!G11-'DATA OP'!G13-'DATA OP'!G15-'DATA OP'!G17-'DATA OP'!G19)))","v":-0.13224920175243188},{"$f":"IF(ISERR(AVERAGE(SUM(J36,J41,J47)/SUM(J37,J42,J48))),\"\",AVERAGE(SUM(J36,J41,J47)/SUM(J37,J42,J48)))","v":-8.5795414544857201E-2}]
[null,"Benchmark",null,0,0,0,0]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"MEETS THE FFTF BENCHMARK"]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(G9>=0,\"YES\",\"NO\")","v":"NO"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"This is how we calculated the council's result….."]
[null,"(Figures are carried over from the data sheet and are in $000)"]
[]
[null,"Total continuing operating revenue (exc. capital grants and contributions) less operating expenses"]
[null,"Total continuing operating revenue (exc. capital grants and contributions) "]
[null,null," (",{"$f":"VLOOKUP('DATA OP'!B5,'DATA OP'!B5:G27,2,FALSE)","v":16146},"-",{"$f":"VLOOKUP('DATA OP'!B7,'DATA OP'!B5:G27,2,FALSE)","v":3053},"-",{"$f":"VLOOKUP('DATA OP'!B9,'DATA OP'!B5:G27,2,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA OP'!B11,'DATA OP'!B5:G27,2,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA OP'!B13,'DATA OP'!B5:G27,2,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA OP'!B15,'DATA OP'!B5:G27,2,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA OP'!B17,'DATA OP'!B5:G27,2,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA OP'!B19,'DATA OP'!B5:G27,2,FALSE)","v":0},")","-","(",{"$f":"VLOOKUP('DATA OP'!B21,'DATA OP'!B5:G27,2,FALSE)","v":15307},"-",{"$f":"VLOOKUP('DATA OP'!B23,'DATA OP'!B5:G27,2,FALSE)","v":211},"-",{"$f":"VLOOKUP('DATA OP'!B25,'DATA OP'!B5:G27,2,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA OP'!B27,'DATA OP'!B5:G27,2,FALSE)","v":0},")"]
[null,null,"(",{"$f":"VLOOKUP('DATA OP'!B5,'DATA OP'!B5:G27,2,FALSE)","v":16146},"-",{"$f":"VLOOKUP('DATA OP'!B7,'DATA OP'!B5:G27,2,FALSE)","v":3053},"-",{"$f":"VLOOKUP('DATA OP'!B9,'DATA OP'!B6:G28,2,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA OP'!B11,'DATA OP'!B6:G28,2,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA OP'!B13,'DATA OP'!B6:G28,2,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA OP'!B15,'DATA OP'!B6:G28,2,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA OP'!B17,'DATA OP'!B6:G28,2,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA OP'!B19,'DATA OP'!B6:G28,2,FALSE)","v":0},")"]
[]
[null,"2011-12",{"$f":"CONCATENATE(C33,D33,E33,F33,G33,H33,I33,J33,K33,L33,M33,N33,O33,P33,Q33,R33,S33,T33,U33,V33,W33,X33,Y33,Z33,AA33,AB33,AC33)","v":" (16146-3053-0-0-0-0-0-0)-(15307-211-0-0)"},null,null,null,null,null,"=",{"$f":"SUM(('DATA OP'!C5-'DATA OP'!C7-'DATA OP'!C9-'DATA OP'!C11-'DATA OP'!C13-'DATA OP'!C15-'DATA OP'!C17-'DATA OP'!C19-'DATA OP'!C21-'DATA OP'!C23-'DATA OP'!C25-'DATA OP'!C27))","v":-2425},"=",{"$f":"D9","v":-0.18521347284808676}]
[null,null,{"$f":"CONCATENATE(D34,E34,F34,G34,H34,I34,J34,K34,L34,M34,N34,O34,P34,Q34,R34,)","v":"16146-3053-0-0-0-0-0-0"},null,null,null,null,null,null,{"$f":"SUM('DATA OP'!C5-'DATA OP'!C7-'DATA OP'!C9-'DATA OP'!C11-'DATA OP'!C13-'DATA OP'!C15-'DATA OP'!C17-'DATA OP'!C19)","v":13093}]
[]
[null,null," (",{"$f":"VLOOKUP('DATA OP'!B5,'DATA OP'!B5:G27,4,FALSE)","v":16906},"-",{"$f":"VLOOKUP('DATA OP'!B7,'DATA OP'!B5:G27,4,FALSE)","v":826},"-",{"$f":"VLOOKUP('DATA OP'!B9,'DATA OP'!B5:G27,4,FALSE)","v":27},"-",{"$f":"VLOOKUP('DATA OP'!B11,'DATA OP'!B5:G27,4,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA OP'!B13,'DATA OP'!B5:G27,4,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA OP'!B15,'DATA OP'!B5:G27,4,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA OP'!B17,'DATA OP'!B5:G27,4,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA OP'!B19,'DATA OP'!B5:G27,4,FALSE)","v":0},")","-","(",{"$f":"VLOOKUP('DATA OP'!B21,'DATA OP'!B5:G27,4,FALSE)","v":15503},"-",{"$f":"VLOOKUP('DATA OP'!B23,'DATA OP'!B5:G27,4,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA OP'!B25,'DATA OP'!B5:G27,4,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA OP'!B27,'DATA OP'!B5:G27,4,FALSE)","v":0},")"]
[null,null,"÷ SUM(",{"$f":"VLOOKUP('DATA OP'!B5,'DATA OP'!B5:G27,4,FALSE)","v":16906},"-",{"$f":"VLOOKUP('DATA OP'!B7,'DATA OP'!B6:G28,4,FALSE)","v":826},"-",{"$f":"VLOOKUP('DATA OP'!B9,'DATA OP'!B6:G28,4,FALSE)","v":27},"-",{"$f":"VLOOKUP('DATA OP'!B11,'DATA OP'!B6:G28,4,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA OP'!B13,'DATA OP'!B6:G28,4,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA OP'!B15,'DATA OP'!B6:G28,4,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA OP'!B17,'DATA OP'!B6:G28,4,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA OP'!B19,'DATA OP'!B6:G28,4,FALSE)","v":0},")"]
[null,"2012-13",{"$f":"CONCATENATE(C39,D39,E39,F39,G39,H39,I39,J39,K39,L39,M39,N39,O39,P39,Q39,R39,S39,T39,U39,V39,W39,X39,Y39,Z39,AA39,AB39,AC39)","v":" (16906-826-27-0-0-0-0-0)-(15503-0-0-0)"},null,null,null,null,null,"=",{"$f":"SUM('DATA OP'!E5-'DATA OP'!E7-'DATA OP'!E9-'DATA OP'!E11-'DATA OP'!E13-'DATA OP'!E15-'DATA OP'!E17-'DATA OP'!E19-'DATA OP'!E21-'DATA OP'!E23-'DATA OP'!E25-'DATA OP'!E27)","v":550},"=",{"$f":"E9","v":3.4261508752258148E-2}]
[null,null,{"$f":"CONCATENATE(D40,E40,F40,G40,H40,I40,J40,K40,L40,M40,N40,O40,P40,Q40,R40)","v":"16906-826-27-0-0-0-0-0"},null,null,null,null,null,null,{"$f":"SUM('DATA OP'!E5-'DATA OP'!E7-'DATA OP'!E9-'DATA OP'!E11-'DATA OP'!E13-'DATA OP'!E15-'DATA OP'!E17-'DATA OP'!E19)","v":16053}]
[]
[]
[null,null," (",{"$f":"VLOOKUP('DATA OP'!B5,'DATA OP'!B5:G27,6,FALSE)","v":14707},"-",{"$f":"VLOOKUP('DATA OP'!B7,'DATA OP'!B5:G27,6,FALSE)","v":1240},"-",{"$f":"VLOOKUP('DATA OP'!B9,'DATA OP'!B5:G27,6,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA OP'!B11,'DATA OP'!B5:G27,6,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA OP'!B13,'DATA OP'!B5:G27,6,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA OP'!B15,'DATA OP'!B5:G27,6,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA OP'!B17,'DATA OP'!B5:G27,6,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA OP'!B19,'DATA OP'!B5:G27,6,FALSE)","v":0},")","-","(",{"$f":"VLOOKUP('DATA OP'!B21,'DATA OP'!B5:G27,6,FALSE)","v":15059},"-",{"$f":"VLOOKUP('DATA OP'!B23,'DATA OP'!B5:G27,6,FALSE)","v":189},"-",{"$f":"VLOOKUP('DATA OP'!B25,'DATA OP'!B5:G27,6,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA OP'!B27,'DATA OP'!B5:G27,6,FALSE)","v":0},")"]
[null,null,"÷ SUM(",{"$f":"VLOOKUP('DATA OP'!B5,'DATA OP'!B5:G28,6,FALSE)","v":14707},"-",{"$f":"VLOOKUP('DATA OP'!B7,'DATA OP'!B6:G28,6,FALSE)","v":1240},"-",{"$f":"VLOOKUP('DATA OP'!B9,'DATA OP'!B6:G28,6,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA OP'!B11,'DATA OP'!B6:G28,6,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA OP'!B13,'DATA OP'!B6:G28,6,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA OP'!B15,'DATA OP'!B6:G28,6,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA OP'!B17,'DATA OP'!B6:G28,6,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA OP'!B19,'DATA OP'!B6:G28,6,FALSE)","v":0},")"]
[null,"2013-14",{"$f":"CONCATENATE(C45,D45,E45,F45,G45,H45,I45,J45,K45,L45,M45,N45,O45,P45,Q45,R45,S45,T45,U45,V45,W45,X45,Y45,Z45,AA45,AB45,AC45)","v":" (14707-1240-0-0-0-0-0-0)-(15059-189-0-0)"},null,null,null,null,null,"=",{"$f":"SUM('DATA OP'!G5-'DATA OP'!G7-'DATA OP'!G9-'DATA OP'!G11-'DATA OP'!G13-'DATA OP'!G15-'DATA OP'!G17-'DATA OP'!G19-'DATA OP'!G21-'DATA OP'!G23-'DATA OP'!G25-'DATA OP'!G27)","v":-1781},"=",{"$f":"F9","v":-0.13224920175243188}]
[null,null,{"$f":"CONCATENATE(D46,E46,F46,G46,H46,I46,J46,K46,L46,M46,N46,O46,P46,Q46,R46)","v":"14707-1240-0-0-0-0-0-0"},null,null,null,null,null,null,{"$f":"SUM('DATA OP'!G5-'DATA OP'!G7-'DATA OP'!G9-'DATA OP'!G11-'DATA OP'!G13-'DATA OP'!G15-'DATA OP'!G17-'DATA OP'!G19)","v":13467}]
[]
[]
[null,"Note: Both numerator and denominator in this calculation excludes fair value adjustments, reversal of revaluation decrements, net gain/losses on sale of assets and net share/loss of interests in joint ventures"]

{"sheet":"CALC OSR","index":17,"n_rows":43,"n_cols":21,"rows_kept":43,"cut":false,"hidden":false,"merged":[[7,6,7,8],[8,6,8,8],[9,6,9,8],[34,8,35,8],[39,8,40,8],[42,1,42,9],[24,1,24,8],[25,1,25,8],[13,9,13,11],[15,9,15,11],[29,6,30,6],[34,6,35,6],[39,6,40,6],[29,8,30,8],[29,1,30,1],[34,1,35,1],[39,1,40,1],[29,9,30,9],[34,9,35,9],[39,9,40,9]]}
[]
[null,"GENERAL FUND - OWN SOURCE REVENUE RESULT"]
[null,{"$f":"INSTRUCTIONS!D5","v":"The Council of the Shire of Wakool"}]
[]
[null,"BENCHMARK AND RESULT"]
[null,"Benchmark:- ",null,"Greater than 60% average over 3 years"]
[]
[null,null,null,"2011-12","2012-13","2013-14","Average over 3 years"]
[null,"Result",null,{"$f":"IF(ISERROR(SUM('DATA  OSR'!C5-'DATA  OSR'!C7-'DATA  OSR'!C9-'DATA  OSR'!C11-'DATA  OSR'!C13-'DATA  OSR'!C15-'DATA  OSR'!C17-'DATA  OSR'!C19-'DATA  OSR'!C21)/SUM('DATA  OSR'!C5-'DATA  OSR'!C11-'DATA  OSR'!C13-'DATA  OSR'!C15-'DATA  OSR'!C17-'DATA  OSR'!C19-'DATA  OSR'!C21)),\"\",SUM('DATA  OSR'!C5-'DATA  OSR'!C7-'DATA  OSR'!C9-'DATA  OSR'!C11-'DATA  OSR'!C13-'DATA  OSR'!C15-'DATA  OSR'!C17-'DATA  OSR'!C19-'DATA  OSR'!C21)/SUM('DATA  OSR'!C5-'DATA  OSR'!C11-'DATA  OSR'!C13-'DATA  OSR'!C15-'DATA  OSR'!C17-'DATA  OSR'!C19-'DATA  OSR'!C21))","v":0.64802427845906108},{"$f":"IF(ISERROR(SUM('DATA  OSR'!E5-'DATA  OSR'!E7-'DATA  OSR'!E9-'DATA  OSR'!E11-'DATA  OSR'!E13-'DATA  OSR'!E15-'DATA  OSR'!E17-'DATA  OSR'!E19-'DATA  OSR'!E21)/SUM('DATA  OSR'!E5-'DATA  OSR'!E11-'DATA  OSR'!E13-'DATA  OSR'!E15-'DATA  OSR'!E17-'DATA  OSR'!E19-'DATA  OSR'!E21)),\"\",SUM('DATA  OSR'!E5-'DATA  OSR'!E7-'DATA  OSR'!E9-'DATA  OSR'!E11-'DATA  OSR'!E13-'DATA  OSR'!E15-'DATA  OSR'!E17-'DATA  OSR'!E19-'DATA  OSR'!E21)/SUM('DATA  OSR'!E5-'DATA  OSR'!E11-'DATA  OSR'!E13-'DATA  OSR'!E15-'DATA  OSR'!E17-'DATA  OSR'!E19-'DATA  OSR'!E21))","v":0.60169441317613603},{"$f":"IF(ISERR(SUM('DATA  OSR'!G5-'DATA  OSR'!G7-'DATA  OSR'!G9-'DATA  OSR'!G11-'DATA  OSR'!G13-'DATA  OSR'!G15-'DATA  OSR'!G17-'DATA  OSR'!G19-'DATA  OSR'!G21)/SUM('DATA  OSR'!G5-'DATA  OSR'!G11-'DATA  OSR'!G13-'DATA  OSR'!G15-'DATA  OSR'!G17-'DATA  OSR'!G19-'DATA  OSR'!G21)),\"\",SUM('DATA  OSR'!G5-'DATA  OSR'!G7-'DATA  OSR'!G9-'DATA  OSR'!G11-'DATA  OSR'!G13-'DATA  OSR'!G15-'DATA  OSR'!G17-'DATA  OSR'!G19-'DATA  OSR'!G21)/SUM('DATA  OSR'!G5-'DATA  OSR'!G11-'DATA  OSR'!G13-'DATA  OSR'!G15-'DATA  OSR'!G17-'DATA  OSR'!G19-'DATA  OSR'!G21))","v":0.59828653022370304},{"$f":"IF(ISERR(AVERAGE(SUM(H30,H35,H40)/SUM(H31,H36,H41))),\"\",AVERAGE(SUM(H30,H35,H40)/SUM(H31,H36,H41)))","v":0.61631609821503397}]
[null,"Benchmark",null,0.6,0.6,0.6,0.6]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"MEETS THE FFTF BENCHMARK"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(G9>60%,\"YES\",\"NO\")","v":"YES"}]
[]
[]
[]
[]
[]
[]
[null,"This is how we calculated the council's result….."]
[null,"(Figures are carried over from the data sheet and are in $000)"]
[null,"Total continuing operating revenue less all grants and contributions"]
[null,"Total continuing operating revenue inclusive of capital grants and contributions"]
[]
[null,"2011/12","=SUM (",{"$f":"VLOOKUP('DATA  OSR'!B5,'DATA  OSR'!$B$5:$G$21,2,FALSE)","v":16146},"-",{"$f":"VLOOKUP('DATA  OSR'!B7,'DATA  OSR'!$B$5:$G$21,2,FALSE)","v":2630},"-",{"$f":"VLOOKUP('DATA  OSR'!B9,'DATA  OSR'!$B$5:$G$21,2,FALSE)","v":3053},"-",{"$f":"VLOOKUP('DATA  OSR'!B11,'DATA  OSR'!$B$5:$G$21,2,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA  OSR'!B13,'DATA  OSR'!$B$5:$G$21,2,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA  OSR'!B15,'DATA  OSR'!$B$5:$G$21,2,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA  OSR'!B17,'DATA  OSR'!$B$5:$G$21,2,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA  OSR'!B19,'DATA  OSR'!$B$5:$G$21,2,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA  OSR'!B21,'DATA  OSR'!$B$5:$G$21,2,FALSE)","v":0},")"]
[null,null,"÷ SUM(",{"$f":"VLOOKUP('DATA  OSR'!B5,'DATA  OSR'!$B$5:$G$21,2,FALSE)","v":16146},"-",{"$f":"VLOOKUP('DATA  OSR'!B11,'DATA  OSR'!$B$5:$G$21,2,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA  OSR'!B13,'DATA  OSR'!$B$5:$G$21,2,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA  OSR'!B15,'DATA  OSR'!$B$5:$G$21,2,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA  OSR'!B17,'DATA  OSR'!$B$5:$G$21,2,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA  OSR'!B19,'DATA  OSR'!$B$5:$G$21,2,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA  OSR'!B21,'DATA  OSR'!$B$5:$G$21,2,FALSE)","v":0},")"]
[null,"2011-12",{"$f":"CONCATENATE(D28,E28,F28,G28,H28,I28,J28,K28,L28,M28,N28,O28,P28,Q28,R28,S28,T28)","v":"16146-2630-3053-0-0-0-0-0-0"},null,null,null,"=",{"$f":"SUM('DATA  OSR'!C5-'DATA  OSR'!C7-'DATA  OSR'!C9-'DATA  OSR'!C11-'DATA  OSR'!C13-'DATA  OSR'!C15-'DATA  OSR'!C17-'DATA  OSR'!C19-'DATA  OSR'!C21)","v":10463},"=",{"$f":"D9","v":0.64802427845906108}]
[null,null,{"$f":"CONCATENATE(D29,,E29,F29,G29,H29,I29,J29,K29,L29,M29,N29,O29,P29)","v":"16146-0-0-0-0-0-0"},null,null,null,null,{"$f":"SUM('DATA  OSR'!C5-'DATA  OSR'!C11-'DATA  OSR'!C13-'DATA  OSR'!C15-'DATA  OSR'!C17-'DATA  OSR'!C19-'DATA  OSR'!C21)","v":16146}]
[null,"2012/13","=SUM (",{"$f":"VLOOKUP('DATA  OSR'!B5,'DATA  OSR'!$B$5:$G$27,4,FALSE)","v":16906},"-",{"$f":"VLOOKUP('DATA  OSR'!B7,'DATA  OSR'!$B$5:$G$27,4,FALSE)","v":5897},"-",{"$f":"VLOOKUP('DATA  OSR'!B9,'DATA  OSR'!$B$5:$G$27,4,FALSE)","v":826},"-",{"$f":"VLOOKUP('DATA  OSR'!B11,'DATA  OSR'!$B$5:$G$27,4,FALSE)","v":27},"-",{"$f":"VLOOKUP('DATA  OSR'!B13,'DATA  OSR'!$B$5:$G$27,4,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA  OSR'!B15,'DATA  OSR'!$B$5:$G$27,4,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA  OSR'!B17,'DATA  OSR'!$B$5:$G$27,4,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA  OSR'!B19,'DATA  OSR'!$B$5:$G$27,4,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA  OSR'!B21,'DATA  OSR'!$B$5:$G$27,4,FALSE)","v":0},")"]
[null,null,"÷ SUM(",{"$f":"VLOOKUP('DATA  OSR'!B5,'DATA  OSR'!$B$5:$G$27,4,FALSE)","v":16906},"-",{"$f":"VLOOKUP('DATA  OSR'!B11,'DATA  OSR'!$B$5:$G$27,4,FALSE)","v":27},"-",{"$f":"VLOOKUP('DATA  OSR'!B13,'DATA  OSR'!$B$5:$G$27,4,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA  OSR'!B15,'DATA  OSR'!$B$5:$G$27,4,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA  OSR'!B17,'DATA  OSR'!$B$5:$G$27,4,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA  OSR'!B19,'DATA  OSR'!$B$5:$G$27,4,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA  OSR'!B21,'DATA  OSR'!$B$5:$G$27,4,FALSE)","v":0},")"]
[]
[null,"2012-13",{"$f":"CONCATENATE(D32,E32,F32,G32,H32,I32,J32,K32,L32,M32,N32,O32,P32,Q32,R32,S32,T32)","v":"16906-5897-826-27-0-0-0-0-0"},null,null,null,"=",{"$f":"SUM('DATA  OSR'!E5-'DATA  OSR'!E7-'DATA  OSR'!E9-'DATA  OSR'!E11-'DATA  OSR'!E13-'DATA  OSR'!E15-'DATA  OSR'!E17-'DATA  OSR'!E19-'DATA  OSR'!E21)","v":10156},"=",{"$f":"E9","v":0.60169441317613603}]
[null,null,{"$f":"CONCATENATE(D33,E33,F33,G33,H33,I33,J33,K33,L33,M33,N33,O33,P33)","v":"16906-27-0-0-0-0-0"},null,null,null,null,{"$f":"SUM('DATA  OSR'!E5-'DATA  OSR'!E11-'DATA  OSR'!E13-'DATA  OSR'!E15-'DATA  OSR'!E17-'DATA  OSR'!E19-'DATA  OSR'!E21)","v":16879}]
[null,"2013/14","=SUM (",{"$f":"VLOOKUP('DATA  OSR'!B5,'DATA  OSR'!$B$5:$G$21,6,FALSE)","v":14707},"-",{"$f":"VLOOKUP('DATA  OSR'!B7,'DATA  OSR'!$B$5:$G$21,6,FALSE)","v":4668},"-",{"$f":"VLOOKUP('DATA  OSR'!B9,'DATA  OSR'!$B$5:$G$21,6,FALSE)","v":1240},"-",{"$f":"VLOOKUP('DATA  OSR'!B11,'DATA  OSR'!$B$5:$G$21,6,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA  OSR'!B13,'DATA  OSR'!$B$5:$G$21,6,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA  OSR'!B15,'DATA  OSR'!$B$5:$G$21,6,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA  OSR'!B17,'DATA  OSR'!$B$5:$G$21,6,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA  OSR'!B19,'DATA  OSR'!$B$5:$G$21,6,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA  OSR'!B21,'DATA  OSR'!$B$5:$G$21,6,FALSE)","v":0},")"]
[null,null,"÷ SUM(",{"$f":"VLOOKUP('DATA  OSR'!B5,'DATA  OSR'!$B$5:$G$21,6,FALSE)","v":14707},"-",{"$f":"VLOOKUP('DATA  OSR'!B11,'DATA  OSR'!$B$5:$G$21,6,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA  OSR'!B13,'DATA  OSR'!$B$5:$G$21,6,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA  OSR'!B15,'DATA  OSR'!$B$5:$G$21,6,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA  OSR'!B17,'DATA  OSR'!$B$5:$G$21,6,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA  OSR'!B19,'DATA  OSR'!$B$5:$G$21,6,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA  OSR'!B21,'DATA  OSR'!$B$5:$G$21,6,FALSE)","v":0},")"]
[]
[null,"2013-14",{"$f":"CONCATENATE(D37,E37,F37,G37,H37,I37,J37,K37,L37,M37,N37,O37,P37,Q37,R37,S37,T37)","v":"14707-4668-1240-0-0-0-0-0-0"},null,null,null,"=",{"$f":"SUM('DATA  OSR'!G5-'DATA  OSR'!G7-'DATA  OSR'!G9-'DATA  OSR'!G11-'DATA  OSR'!G13-'DATA  OSR'!G15-'DATA  OSR'!G17-'DATA  OSR'!G19-'DATA  OSR'!G21)","v":8799},"=",{"$f":"F9","v":0.59828653022370304}]
[null,null,{"$f":"CONCATENATE(D38,,E38,F38,G38,H38,I38,J38,K38,L38,M38,N38,O38,P38)","v":"14707-0-0-0-0-0-0"},null,null,null,null,{"$f":"SUM('DATA  OSR'!G5-'DATA  OSR'!G11-'DATA  OSR'!G13-'DATA  OSR'!G15-'DATA  OSR'!G17-'DATA  OSR'!G19-'DATA  OSR'!G21)","v":14707}]
[]
[null,"Note: Both numerator and denominator in this calculation excludes fair value adjustments, reversal of revaluation decrements, net gain on sale of assets and net share of interests in joint ventures"]

{"sheet":"CALC BIAR","index":18,"n_rows":39,"n_cols":9,"rows_kept":39,"cut":false,"hidden":false,"merged":[[37,1,38,1],[34,4,35,4],[6,5,6,6],[7,5,7,6],[8,5,8,6],[37,4,38,4],[31,3,32,3],[34,3,35,3],[37,3,38,3],[31,4,32,4],[28,1,28,6],[29,1,29,7],[14,8,14,10],[1,1,1,7],[31,1,32,1],[34,1,35,1],[16,8,16,10]]}
[]
[null,"GENERAL FUND - BUILDING AND INFRASTRUCTURE ASSET RENEWAL RESULT"]
[null,{"$f":"INSTRUCTIONS!D5","v":"The Council of the Shire of Wakool"}]
[null,"BENCHMARK AND RESULT"]
[null,"Benchmark:-","Greater than 100% average over 3 years"]
[]
[null,null,"2011-12","2012-13","2013-14","Average over 3 years"]
[null,"Result",{"$f":"IF(ISERR('DATA BIAR'!C5/'DATA BIAR'!C7),\"\",'DATA BIAR'!C5/'DATA BIAR'!C7)","v":0.58024502297090352},{"$f":"IF(ISERR('DATA BIAR'!E5/'DATA BIAR'!E7),\"\",'DATA BIAR'!E5/'DATA BIAR'!E7)","v":0.8458235753317721},{"$f":"IF(ISERR('DATA BIAR'!G5/'DATA BIAR'!G7),\"\",'DATA BIAR'!G5/'DATA BIAR'!G7)","v":1.0463096960926195},{"$f":"IF(ISERR(AVERAGE(SUM(C32,C35,C38)/SUM(C33,C36,C39))),\"\",AVERAGE(SUM(C32,C35,C38)/SUM(C33,C36,C39)))","v":0.79946637559881151}]
[null,"Benchmark",1,1,1,1]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"MEETS THE FFTF BENCHMARK"]
[]
[null,null,null,null,null,null,null,null,{"$f":"IF(F8>100%,\"YES\",\"NO\")","v":"NO"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"This is how we calculated the council's result….."]
[null,"(Figures are carried over from the data sheet and are in $000)"]
[null,"Asset renewals (building and infrastructure)"]
[null,"Depreciation, amortisation and impairment (building and infrastructure)"]
[]
[null,"2011-12",{"$f":"VLOOKUP('DATA BIAR'!B5,'DATA BIAR'!B5:G7,2,FALSE)","v":3789},"=",{"$f":"C8","v":0.58024502297090352}]
[null,null,{"$f":"VLOOKUP('DATA BIAR'!B7,'DATA BIAR'!B5:G8,2,FALSE)","v":6530}]
[]
[null,"2012-13",{"$f":"VLOOKUP('DATA BIAR'!B5,'DATA BIAR'!B5:G8,4,FALSE)","v":4334},"=",{"$f":"D8","v":0.8458235753317721}]
[null,null,{"$f":"VLOOKUP('DATA BIAR'!B7,'DATA BIAR'!B5:G8,4,FALSE)","v":5124}]
[]
[null,"2013-14",{"$f":"VLOOKUP('DATA BIAR'!B5,'DATA BIAR'!B5:G8,6,FALSE)","v":5061},"=",{"$f":"E8","v":1.0463096960926195}]
[null,null,{"$f":"VLOOKUP('DATA BIAR'!B7,'DATA BIAR'!B5:G8,6,FALSE)","v":4837}]

{"sheet":"CALC IB","index":19,"n_rows":32,"n_cols":7,"rows_kept":32,"cut":false,"hidden":false,"merged":[[27,1,27,8],[28,1,28,8],[30,1,31,1],[6,6,6,8],[7,5,7,7],[8,5,8,7],[15,6,15,8],[17,6,17,8],[30,3,31,3],[30,4,31,4]]}
[]
[null,"GENERAL FUND - INFRASTRUCTURE BACKLOG RESULT"]
[null,{"$f":"INSTRUCTIONS!D5","v":"The Council of the Shire of Wakool"}]
[null,"BENCHMARK AND RESULT"]
[null,"Benchmark:-","Less than 2%"]
[]
[null,null,"2013-14"]
[null,"Result",{"$f":"IF(ISERR('DATA IB'!D5/'DATA IB'!D7),\"\",'DATA IB'!D5/'DATA IB'!D7)","v":0.27650586504733526}]
[null,"Benchmark",0.02]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"MEETS THE FFTF BENCHMARK"]
[]
[null,null,null,null,null,null,{"$f":"IF(C8<2%,\"YES\",\"NO\")","v":"NO"}]
[]
[]
[]
[]
[]
[]
[]
[null,"This is how we calculated the council's result….."]
[null,"(Figures are carried over from the data sheet and are in $000)"]
[null,"Estimated cost to bring assets to a satisfactory condition"]
[null,"Total (WDV) of infrastructure, buildings, other structures and depreciable land improvement assets"]
[]
[null,"2013-14",{"$f":"VLOOKUP('DATA IB'!B5,'DATA IB'!B5:D7,3,FALSE)","v":43986},"=",{"$f":"C8","v":0.27650586504733526}]
[null,null,{"$f":"VLOOKUP('DATA IB'!B7,'DATA IB'!B5:D7,3,FALSE)","v":159078}]

{"sheet":"CALC AM","index":20,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[[15,9,15,11],[17,9,17,11],[31,4,32,4],[34,4,35,4],[37,4,38,4],[31,5,32,5],[34,5,35,5],[37,5,38,5],[31,1,32,1],[34,1,35,1],[37,1,38,1],[6,6,6,8],[7,6,7,8],[8,6,8,8],[28,1,28,4],[29,1,29,4]]}
[]
[null,"GENERAL FUND - ASSET MAINTENANCE RESULT"]
[null,{"$f":"INSTRUCTIONS!D5","v":"The Council of the Shire of Wakool"}]
[null,"BENCHMARK AND RESULT"]
[null,"Benchmark:-",null,"Greater than 100% average over 3 years"]
[]
[null,null,null,"2011-12","2012-13","2013-14","Average over 3 years"]
[null,"Result",null,{"$f":"IF(ISERR('DATA AM'!C5/'DATA AM'!C7),\"\",'DATA AM'!C5/'DATA AM'!C7)","v":0.90787603070798972},{"$f":"IF(ISERR('DATA AM'!E5/'DATA AM'!E7),\"\",'DATA AM'!E5/'DATA AM'!E7)","v":0.99058295964125564},{"$f":"IF(ISERR('DATA AM'!G5/'DATA AM'!G7),\"\",'DATA AM'!G5/'DATA AM'!G7)","v":1.0525641025641026},{"$f":"IF(ISERR(AVERAGE(SUM(D32,D35,D38)/SUM(D33,D36,D39))),\"\",AVERAGE(SUM(D32,D35,D38)/SUM(D33,D36,D39)))","v":0.97254853468529734}]
[null,"Benchmark",null,1,1,1,1]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"MEETS THE FFTF BENCHMARK"]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(G8>100%,\"YES\",\"NO\")","v":"NO"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"This is how we calculated the council's result….."]
[null,"(Figures are carried over from the data sheet and are in $000)"]
[null,"Actual asset maintenance"]
[null,"Required asset maintenance"]
[]
[null,"2011-12",null,{"$f":"VLOOKUP('DATA AM'!B5,'DATA AM'!B5:G7,2,FALSE)","v":3193},"=",{"$f":"D8","v":0.90787603070798972}]
[null,null,null,{"$f":"VLOOKUP('DATA AM'!B7,'DATA AM'!B5:G7,2,FALSE)","v":3517}]
[]
[null,"2012-13",null,{"$f":"VLOOKUP('DATA AM'!B5,'DATA AM'!B5:G7,4,FALSE)","v":2209},"=",{"$f":"E8","v":0.99058295964125564}]
[null,null,null,{"$f":"VLOOKUP('DATA AM'!B7,'DATA AM'!B5:G7,4,FALSE)","v":2230}]
[]
[null,"2013-14",null,{"$f":"VLOOKUP('DATA AM'!B5,'DATA AM'!B5:G7,6,FALSE)","v":2463},"=",{"$f":"F8","v":1.0525641025641026}]
[null,null,null,{"$f":"VLOOKUP('DATA AM'!B7,'DATA AM'!B5:G7,6,FALSE)","v":2340}]

{"sheet":"CALC DS","index":21,"n_rows":46,"n_cols":19,"rows_kept":46,"cut":false,"hidden":false,"merged":[[45,1,45,9],[32,1,33,1],[37,1,38,1],[6,7,6,9],[7,7,7,9],[8,7,8,9],[9,7,9,9],[37,8,38,8],[32,9,33,9],[37,9,38,9],[32,8,33,8],[42,1,43,1],[12,10,13,12],[15,10,15,12],[42,2,42,5],[37,2,37,5],[32,2,32,5],[27,1,27,9],[28,1,28,9],[42,8,43,8],[42,9,43,9],[32,6,33,6],[37,6,38,6],[42,6,43,6]]}
[]
[null,"GENERAL FUND - DEBT SERVICE RESULT"]
[null,{"$f":"INSTRUCTIONS!D5","v":"The Council of the Shire of Wakool"}]
[null,"BENCHMARK AND RESULT"]
[null,"Benchmark:-",null,"Greater than 0 and less than or equal to 20% average over 3 years"]
[]
[null,null,null,null,"2011-12","2012-13","2013-14","Average over 3 years"]
[null,"Result",null,null,{"$f":"IF(ISERR(SUM('DATA DS'!C5+'DATA DS'!C7)/SUM('DATA DS'!C9-'DATA DS'!C11-'DATA DS'!C13-'DATA DS'!C15-'DATA DS'!C17-'DATA DS'!C19-'DATA DS'!C21)),\"\",(SUM('DATA DS'!C5+'DATA DS'!C7)/SUM('DATA DS'!C9-'DATA DS'!C11-'DATA DS'!C13-'DATA DS'!C15-'DATA DS'!C17-'DATA DS'!C19-'DATA DS'!C21)))","v":5.7358894065531199E-2},{"$f":"IF(ISERR(SUM('DATA DS'!E5+'DATA DS'!E7)/SUM('DATA DS'!E9-'DATA DS'!E11-'DATA DS'!E13-'DATA DS'!E15-'DATA DS'!E17-'DATA DS'!E19-'DATA DS'!E21)),\"\",SUM('DATA DS'!E5+'DATA DS'!E7)/SUM('DATA DS'!E9-'DATA DS'!E11-'DATA DS'!E13-'DATA DS'!E15-'DATA DS'!E17-'DATA DS'!E19-'DATA DS'!E21))","v":4.3543262941506261E-2},{"$f":"IF(ISERR(SUM('DATA DS'!E5+'DATA DS'!E7)/SUM('DATA DS'!E9-'DATA DS'!E11-'DATA DS'!E13-'DATA DS'!E15-'DATA DS'!E17-'DATA DS'!E19-'DATA DS'!E21)),\"\",SUM('DATA DS'!G5+'DATA DS'!G7)/SUM('DATA DS'!G9-'DATA DS'!G11-'DATA DS'!G13-'DATA DS'!G15-'DATA DS'!G17-'DATA DS'!G19-'DATA DS'!G21))","v":7.0617063934061045E-2},{"$f":"IF(ISERR(AVERAGE(SUM(H33,H38,H43)/SUM(H34,H39,H44))),\"\",AVERAGE(SUM(H33,H38,H43)/SUM(H34,H39,H44)))","v":5.6344308075000585E-2}]
[null,"Benchmark 1 >",null,null,0,0,0,0]
[null,"Benchmark 2 <",null,null,0.2,0.2,0.2,0.2]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"MEETS THE FFTF BENCHMARK"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(H8>0%,IF(H8<=20%,\"YES\",\"NO\"),\"NO\")","v":"YES"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"This is how we calculated the council's result….."]
[null,"(Figures are carried over from the data sheet and are in $000)"]
[null,"Cost of debt service (interest expense & principal repayments)"]
[null,"Total continuing operating revenue (exc. capital grants and contributions)"]
[]
[null,"2011/12",null,"=SUM (",{"$f":"VLOOKUP('DATA DS'!B5,'DATA DS'!$B$5:$G$21,2,FALSE)","v":545},"+",{"$f":"VLOOKUP('DATA DS'!B7,'DATA DS'!$B$5:$G$21,2,FALSE)","v":206},")"]
[null,null,null,"÷ SUM(",{"$f":"VLOOKUP('DATA DS'!B9,'DATA DS'!$B$5:$G$21,2,FALSE)","v":16146},"-",{"$f":"VLOOKUP('DATA DS'!B11,'DATA DS'!$B$5:$G$21,2,FALSE)","v":3053},"-",{"$f":"VLOOKUP('DATA DS'!B13,'DATA DS'!$B$5:$G$21,2,FALSE)","v":0},null,"-",{"$f":"VLOOKUP('DATA DS'!B15,'DATA DS'!$B$5:$G$21,2,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA DS'!B17,'DATA DS'!$B$5:$G$21,2,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA DS'!B19,'DATA DS'!$B$5:$G$21,2,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA DS'!B21,'DATA DS'!$B$5:$G$21,2,FALSE)","v":0},")"]
[null,"2011-12",{"$f":"CONCATENATE(E31,F31,G31)","v":"545+206"},null,null,null,"=",{"$f":"SUM('DATA DS'!C5+'DATA DS'!C7)","v":751},"=",{"$f":"E8","v":5.7358894065531199E-2}]
[null,null,null,{"$f":"CONCATENATE(E32,F32,G32,H32,I32,K32,L32,M32,N32,O32,P32,Q32,R32)","v":"16146-3053-0-0-0-0-0"},null,null,null,{"$f":"SUM('DATA DS'!C9-'DATA DS'!C11-'DATA DS'!C13-'DATA DS'!C15-'DATA DS'!C17-'DATA DS'!C19-'DATA DS'!C21)","v":13093}]
[]
[null,"2012/13",null,"=SUM (",{"$f":"VLOOKUP('DATA DS'!B5,'DATA DS'!$B$5:$G$21,4,FALSE)","v":536},"+",{"$f":"VLOOKUP('DATA DS'!B7,'DATA DS'!$B$5:$G$21,4,FALSE)","v":163},")"]
[null,null,null,"÷ SUM(",{"$f":"VLOOKUP('DATA DS'!B9,'DATA DS'!$B$5:$G$21,4,FALSE)","v":16906},"-",{"$f":"VLOOKUP('DATA DS'!B11,'DATA DS'!$B$5:$G$21,4,FALSE)","v":826},"-",{"$f":"VLOOKUP('DATA DS'!B13,'DATA DS'!$B$5:$G$21,4,FALSE)","v":27},null,"-",{"$f":"VLOOKUP('DATA DS'!B15,'DATA DS'!$B$5:$G$21,4,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA DS'!B17,'DATA DS'!$B$5:$G$21,4,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA DS'!B19,'DATA DS'!$B$5:$G$21,4,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA DS'!B21,'DATA DS'!$B$5:$G$21,4,FALSE)","v":0},")"]
[null,"2012-13",{"$f":"CONCATENATE(E36,F36,G36)","v":"536+163"},null,null,null,"=",{"$f":"SUM('DATA DS'!E5+'DATA DS'!E7)","v":699},"=",{"$f":"F8","v":4.3543262941506261E-2}]
[null,null,null,{"$f":"CONCATENATE(E37,F37,G37,H37,I37,K37,L37,M37,N37,O37,P37,Q37,R37)","v":"16906-826-27-0-0-0-0"},null,null,null,{"$f":"SUM('DATA DS'!E9-'DATA DS'!E11-'DATA DS'!E13-'DATA DS'!E15-'DATA DS'!E17-'DATA DS'!E19-'DATA DS'!E21)","v":16053}]
[]
[null,"2013/14",null,"=SUM (",{"$f":"VLOOKUP('DATA DS'!B5,'DATA DS'!$B$5:$G$21,6,FALSE)","v":711},"+",{"$f":"VLOOKUP('DATA DS'!B7,'DATA DS'!$B$5:$G$21,6,FALSE)","v":240},")"]
[null,null,null,"÷ SUM(",{"$f":"VLOOKUP('DATA DS'!B9,'DATA DS'!$B$5:$G$21,6,FALSE)","v":14707},"-",{"$f":"VLOOKUP('DATA DS'!B11,'DATA DS'!$B$5:$G$21,6,FALSE)","v":1240},"-",{"$f":"VLOOKUP('DATA DS'!B13,'DATA DS'!$B$5:$G$21,6,FALSE)","v":0},null,"-",{"$f":"VLOOKUP('DATA DS'!B15,'DATA DS'!$B$5:$G$21,6,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA DS'!B17,'DATA DS'!$B$5:$G$21,6,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA DS'!B19,'DATA DS'!$B$5:$G$21,6,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA DS'!B21,'DATA DS'!$B$5:$G$21,6,FALSE)","v":0},")"]
[null,"2013-14",{"$f":"CONCATENATE(E41,F41,G41)","v":"711+240"},null,null,null,"=",{"$f":"SUM('DATA DS'!G5+'DATA DS'!G7)","v":951},"=",{"$f":"G8","v":7.0617063934061045E-2}]
[null,null,null,{"$f":"CONCATENATE(E42,F42,G42,H42,I42,K42,L42,M42,N42,O42,P42,Q42,R42)","v":"14707-1240-0-0-0-0-0"},null,null,null,{"$f":"SUM('DATA DS'!G9-'DATA DS'!G11-'DATA DS'!G13-'DATA DS'!G15-'DATA DS'!G17-'DATA DS'!G19-'DATA DS'!G21)","v":13467}]
[]
[null,"Note: The denominator in this calculation excludes fair value adjustments, reversal of revaluation decrements, net gain on sale of assets and net share of interests in joint ventures"]

{"sheet":"CALC ROEPC","index":22,"n_rows":58,"n_cols":13,"rows_kept":58,"cut":false,"hidden":false,"merged":[[1,1,1,8],[12,10,12,12],[34,7,35,7],[39,7,40,7],[44,7,45,7],[14,10,14,12],[34,8,35,8],[39,8,40,8],[44,8,45,8],[44,1,45,1],[44,5,45,5],[49,5,50,5],[54,8,55,8],[49,7,50,7],[57,1,57,8],[28,3,29,3],[28,6,29,6],[28,1,29,2],[34,5,35,5],[39,5,40,5],[34,1,35,1],[39,1,40,1],[49,1,50,1],[54,1,55,1],[49,8,50,8],[54,7,55,7],[54,5,55,5]]}
[]
[null,"GENERAL FUND - REAL OPERATING EXPENDITURE PER CAPITA RESULT"]
[null,{"$f":"INSTRUCTIONS!D5","v":"The Council of the Shire of Wakool"}]
[null,"BENCHMARK AND RESULT"]
[null,"Benchmark:-","A decrease in Real Operating Expenditure per capita over time "]
[]
[null,null,"2009-10","2010-11","2011-12","2012-13","2013-14"]
[null,"Result",{"$f":"IF(ISERROR(SUM('DATA ROEPC'!C7-'DATA ROEPC'!C9-'DATA ROEPC'!C11-'DATA ROEPC'!C13)*(1-E30)/'DATA ROEPC'!C5),\"\",SUM('DATA ROEPC'!C7-'DATA ROEPC'!C9-'DATA ROEPC'!C11-'DATA ROEPC'!C13)*(1-E30)/'DATA ROEPC'!C5)","v":3.0001588214157384},{"$f":"IF(ISERROR(SUM('DATA ROEPC'!E7-'DATA ROEPC'!E9-'DATA ROEPC'!E11-'DATA ROEPC'!E13)*(1-E30)*(1-F30)/'DATA ROEPC'!E5),\"\",SUM('DATA ROEPC'!E7-'DATA ROEPC'!E9-'DATA ROEPC'!E11-'DATA ROEPC'!E13)*(1-E30)*(1-F30)/'DATA ROEPC'!E5)","v":3.5050567928893215},{"$f":"IF(ISERROR(SUM('DATA ROEPC'!G7-'DATA ROEPC'!G9-'DATA ROEPC'!G11-'DATA ROEPC'!G13)*(1-E30)*(1-F30)*(1-H30)/'DATA ROEPC'!G5),\"\",SUM('DATA ROEPC'!G7-'DATA ROEPC'!G9-'DATA ROEPC'!G11-'DATA ROEPC'!G13)*(1-E30)*(1-F30)*(1-H30)/'DATA ROEPC'!G5)","v":3.4218070257181599},{"$f":"(IF(ISERROR(SUM('DATA ROEPC'!I7-'DATA ROEPC'!I9-'DATA ROEPC'!I11-'DATA ROEPC'!I13)*(1-E30)*(1-F30)*(1-H30)*(1-I30)/'DATA ROEPC'!I5),\"\",SUM('DATA ROEPC'!I7-'DATA ROEPC'!I9-'DATA ROEPC'!I11-'DATA ROEPC'!I13)*(1-E30)*(1-F30)*(1-H30)*(1-I30)/'DATA ROEPC'!I5))","v":3.4343853093055756},{"$f":"IF(ISERROR(SUM('DATA ROEPC'!I7-'DATA ROEPC'!I9-'DATA ROEPC'!I11-'DATA ROEPC'!I13)*(1-E30)*(1-F30)*(1-H30)*(1-I30)*(1-J30)/'DATA ROEPC'!I5),\"\",SUM('DATA ROEPC'!I7-'DATA ROEPC'!I9-'DATA ROEPC'!I11-'DATA ROEPC'!I13)*(1-E30)*(1-F30)*(1-H30)*(1-I30)*(1-J30)/'DATA ROEPC'!I5)","v":3.3073130528612693}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"MEETS THE FFTF BENCHMARK"]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(ISERROR(IF(LINEST(C8:G8)>0,\"No\",\"Yes\")),\"\",IF(LINEST(C8:G8)>0,\"No\",\"Yes\"))","v":"No"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"This is how we calculated the council's result….."]
[null,"(Figures are carried over from the data sheet and are in $000)"]
[]
[null,"Expenditure deflated by:",null,"CPI:-","2009-10","2010-11","LGCI:-","2011-12","2012-13","2013-14"]
[null,null,null,null,2.3E-2,0.03,null,0.03,3.4000000000000002E-2,3.6999999999999998E-2]
[]
[]
[null,"2009/11",null," =SUM(",{"$f":"VLOOKUP('DATA ROEPC'!B7,'DATA ROEPC'!$B$5:$K$13,2,FALSE)","v":20360},"-",{"$f":"VLOOKUP('DATA ROEPC'!B9,'DATA ROEPC'!$B$5:$K$13,2,FALSE)","v":7541},"-",{"$f":"VLOOKUP('DATA ROEPC'!B11,'DATA ROEPC'!$B$5:$K$13,2,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA ROEPC'!B13,'DATA ROEPC'!$B$5:$K$13,2,FALSE)","v":0},"x","(1-.023)"]
[null,null,null,"÷",{"$f":"VLOOKUP('DATA ROEPC'!B5,'DATA ROEPC'!B5:K13,2,FALSE)","v":4174.5}]
[null,"2009-10",null,{"$f":"CONCATENATE(E33,F33,G33,H33,I33,J33,K33,L33,M33)","v":"20360-7541-0-0x(1-.023)"},null,"=",{"$f":"SUM('DATA ROEPC'!C7-'DATA ROEPC'!C9-'DATA ROEPC'!C11-'DATA ROEPC'!C13)*(1-E30)","v":12524.163},"=",{"$f":"C8","v":3.0001588214157384}]
[null,null,null,{"$f":"CONCATENATE(E34)","v":"4174.5"},null,null,{"$f":"D36","v":"4174.5"}]
[null,"2010/11",null," =SUM(",{"$f":"VLOOKUP('DATA ROEPC'!B7,'DATA ROEPC'!$B$5:$K$13,4,FALSE)","v":15569},"-",{"$f":"VLOOKUP('DATA ROEPC'!B9,'DATA ROEPC'!$B$5:$K$13,4,FALSE)","v":381},"-",{"$f":"VLOOKUP('DATA ROEPC'!B11,'DATA ROEPC'!$B$5:$K$13,4,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA ROEPC'!B13,'DATA ROEPC'!$B$5:$K$13,4,FALSE)","v":0},"x(1-.023)x(1-.03)"]
[null,null,null,"÷",{"$f":"VLOOKUP('DATA ROEPC'!B5,'DATA ROEPC'!B5:K13,4,FALSE)","v":4106.5}]
[]
[null,"2010-11",null,{"$f":"CONCATENATE(E37,F37,G37,H37,I37,J37,K37,L37)","v":"15569-381-0-0x(1-.023)x(1-.03)"},null,"=",{"$f":"SUM('DATA ROEPC'!E7-'DATA ROEPC'!E9-'DATA ROEPC'!E11-'DATA ROEPC'!E13)*(1-E30)*(1-F30)","v":14393.515719999999},"=",{"$f":"D8","v":3.5050567928893215}]
[null,null,null,{"$f":"E38","v":4106.5},null,null,{"$f":"D41","v":4106.5}]
[null,"2011/12",null," =SUM(",{"$f":"VLOOKUP('DATA ROEPC'!B7,'DATA ROEPC'!$B$5:$K$13,6,FALSE)","v":15307},"-",{"$f":"VLOOKUP('DATA ROEPC'!B9,'DATA ROEPC'!$B$5:$K$13,6,FALSE)","v":211},"-",{"$f":"VLOOKUP('DATA ROEPC'!B11,'DATA ROEPC'!$B$5:$K$13,6,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA ROEPC'!B13,'DATA ROEPC'!$B$5:$K$13,6,FALSE)","v":0},"x(1-.023)x(1-.03)x(1-.03)"]
[null,null,null,"÷",{"$f":"VLOOKUP('DATA ROEPC'!B5,'DATA ROEPC'!B5:K14,6,FALSE)","v":4055.5}]
[]
[null,"2011-12",null,{"$f":"CONCATENATE(E42,F42,G42,H42,I42,J42,K42,L42)","v":"15307-211-0-0x(1-.023)x(1-.03)x(1-.03)"},null,"=",{"$f":"SUM('DATA ROEPC'!G7-'DATA ROEPC'!G9-'DATA ROEPC'!G11-'DATA ROEPC'!G13)*(1-E30)*(1-F30)*(1-H30)","v":13877.138392799998},"=",{"$f":"E8","v":3.4218070257181599}]
[null,null,null,{"$f":"E43","v":4055.5},null,null,{"$f":"D46","v":4055.5}]
[null,"2012/13",null," =SUM(",{"$f":"VLOOKUP('DATA ROEPC'!B7,'DATA ROEPC'!$B$5:$K$13,8,FALSE)","v":15503},"-",{"$f":"VLOOKUP('DATA ROEPC'!B9,'DATA ROEPC'!$B$5:$K$13,8,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA ROEPC'!B11,'DATA ROEPC'!$B$5:$K$13,8,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA ROEPC'!B13,'DATA ROEPC'!$B$5:$K$13,8,FALSE)","v":0},"x(1-.023)x(1-.03)x(1-.03)x(1-.034)"]
[null,null,null,"÷",{"$f":"VLOOKUP('DATA ROEPC'!B5,'DATA ROEPC'!B5:K14,8,FALSE)","v":4008.5}]
[]
[null,"2012-13",null,{"$f":"CONCATENATE(E47,F47,G47,H47,I47,J47,K47,L47)","v":"15503-0-0-0x(1-.023)x(1-.03)x(1-.03)x(1-.034)"},null,"=",{"$f":"SUM('DATA ROEPC'!I7-'DATA ROEPC'!I9-'DATA ROEPC'!I11-'DATA ROEPC'!I13)*(1-E30)*(1-F30)*(1-H30)*(1-I30)","v":13766.7335123514},"=",{"$f":"F8","v":3.4343853093055756}]
[null,null,null,{"$f":"E48","v":4008.5},null,null,{"$f":"D51","v":4008.5}]
[null,"2013/14",null," =SUM(",{"$f":"VLOOKUP('DATA ROEPC'!B7,'DATA ROEPC'!$B$5:$K$13,10,FALSE)","v":15059},"-",{"$f":"VLOOKUP('DATA ROEPC'!B9,'DATA ROEPC'!$B$5:$K$13,10,FALSE)","v":189},"-",{"$f":"VLOOKUP('DATA ROEPC'!B11,'DATA ROEPC'!$B$5:$K$13,10,FALSE)","v":0},"-",{"$f":"VLOOKUP('DATA ROEPC'!B13,'DATA ROEPC'!$B$5:$K$13,10,FALSE)","v":0},"x(1-.023)x(1-.03)x(1-.03)x(1-.034)x(1-.037)"]
[null,null,null,"÷",{"$f":"VLOOKUP('DATA ROEPC'!B5,'DATA ROEPC'!B5:K14,10,FALSE)","v":3979}]
[]
[null,"2013-14",null,{"$f":"CONCATENATE(E52,F52,G52,H52,I52,J52,K52,L52)","v":"15059-189-0-0x(1-.023)x(1-.03)x(1-.03)x(1-.034)x(1-.037)"},null,"=",{"$f":"SUM('DATA ROEPC'!K7-'DATA ROEPC'!K9-'DATA ROEPC'!K11-'DATA ROEPC'!K13)*(1-E30)*(1-F30)*(1-H30)*(1-I30)*(1-J30)","v":12716.055487164076},"=",{"$f":"G8","v":3.3073130528612693}]
[null,null,null,{"$f":"E53","v":3979},null,null,{"$f":"D56","v":3979}]
[]
[null,"Note: The numerator in this calculation excludes revaluation decrements, net loss from disposal of assets and net loss of interests in joint ventures."]

{"sheet":"RESULTS","index":23,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":false,"merged":[[11,4,11,10],[19,4,19,10],[9,4,9,10]]}
[]
[]
[]
[null,null,null,null,null,null,null,"Criteria Results"]
[]
[]
[]
[null,null,{"$f":"INSTRUCTIONS!D5","v":"The Council of the Shire of Wakool"}]
[null,null,null,null,"BENCHMARK",null,null,null,null,null,null,"RESULT","MEETS FFTF BENCHMARK"]
[null,null,null,null,"Operating Performance Ratio (greater or equal to break-even average over 3 years)",null,null,null,null,null,null,{"$f":"'CALC OP'!G9","v":-8.5795414544857201E-2},{"$f":"IF(L10>=0,\"YES\",\"NO\")","v":"NO"},{"$f":"IF(M10=\"NO\",0,1)","v":0}]
[null,null,null,null,"Own Source Revenue Ratio (greater than 60% average over 3 years)",null,null,null,null,null,null,{"$f":"'CALC OSR'!G9","v":0.61631609821503397},{"$f":"IF(L11>60%,\"YES\",\"NO\")","v":"YES"},{"$f":"IF(M11=\"NO\",0,1)","v":1}]
[null,null,null,null,"Building and Infrastructure Asset Renewal Ratio (greater than 100% average over 3 years) ",null,null,null,null,null,null,{"$f":"'CALC BIAR'!F8","v":0.79946637559881151},{"$f":"IF(L12>100%,\"YES\",\"NO\")","v":"NO"},0]
[]
[]
[null,null,null,null," Infrastructure Backlog Ratio (less than 2%) ",null,null,null,null,null,null,{"$f":"'CALC IB'!C8","v":0.27650586504733526},{"$f":"IF(L15<2%,\"YES\",\"NO\")","v":"NO"},0]
[null,null,null,null,"Asset Maintenance Ratio  (greater than 100% average over 3 years)",null,null,null,null,null,null,{"$f":"'CALC AM'!G8","v":0.97254853468529734},{"$f":"IF(L16>100%,\"YES\",\"NO\")","v":"NO"},0]
[null,null,null,null,"Debt Service Ratio (greater than 0 and less than or equal to 20% average over 3 years) ",null,null,null,null,null,null,{"$f":"'CALC DS'!H8","v":5.6344308075000585E-2},{"$f":"IF(L17<20*AND(L17>0),\"YES\",\"NO\")","v":"YES"},1]
[]
[]
[null,null,null,null,"A decrease in Real Operating Expenditure per capita over time",null,null,null,null,null,null,{"$f":"IF(ISERROR(IF(LINEST('CALC ROEPC'!C8:G8)>0,\"Increasing\",\"Decreasing\")),\"\",IF(LINEST('CALC ROEPC'!C8:G8)>0,\"Increasing\",\"Decreasing\"))","v":"Increasing"},{"$f":"IF(ISERROR(IF(LINEST('CALC ROEPC'!C8:G8)>0,\"NO\",\"YES\")),\"\",IF(LINEST('CALC ROEPC'!C8:G8)>0,\"NO\",\"YES\"))","v":"NO"},{"$f":"IF(M20=\"NO\",0,1)","v":0}]
[]
[]
[null,null,null,null,"OVERALL RESULT",null,null,{"$f":"M26","v":4}]
[]
[null,null,null,null,{"$f":"IF(M26=0,\"The Council meets all seven of the Fit for the Future Criteria\",\"The Council does not meet all seven of the Fit for the Future Criteria\")","v":"The Council does not meet all seven of the Fit for the Future Criteria"}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(M10:M17,\"NO\")","v":4}]

{"sheet":"POPULATION","index":24,"n_rows":164,"n_cols":30,"rows_kept":164,"cut":false,"hidden":true,"merged":[]}
["Australian Bureau of Statistics",null,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24]
["3218.0  Regional Population Growth, Australia",null,null,null,null,null,"Released 3.4.2014"]
["Table 1. Estimated Resident Population, Local Government Areas, New South Wales"]
[]
[null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Change"]
[null,null,null,2003,2004,"average population 2003-04",2005,"average population 2004-05",2006,"average population 2005-06",2007,"average population 2006-07",2008,"average population 2007-08",2009,"average population 2008-09",2010,"average population 2009-10",2011,"average population 2010-11","2012r","average population 2011-12","2013p","average population 2012-13","2013-14","2012r-2013p",null,null,"Area","Population density 2013"]
["LGA code","Local Government Area",null,"no.","no.",null,"no.",null,"no.",null,"no.",null,"no.",null,"no.",null,"no.",null,"no.",null,"no.",null,"no.",null,"2013 data","%","no.",null,"km2","persons/km2"]
[null,"Select your Council",2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24]
[10050,"Albury City Council",4,46180,46505,46342.5,47004,46754.5,47566,47285,48140,47853,48518,48329,48814,48666,49222,49018,49451,49336.5,49709,49580,50243,49976,50243,1.1000000000000001,534,null,305.89999999999998,164.2]
[10110,"Armidale Dumaresq Council",4,24346,24171,24258.5,24115,24143,24146,24130.5,24275,24210.5,24573,24424,24862,24717.5,25046,24954,25158,25102,25298,25228,25343,25320.5,25343,0.2,45,null,4230.8,6]
[10150,"Ashfield Council",2,40501,40614,40557.5,40832,40723,41269,41050.5,41916,41592.5,42207,42061.5,42766,42486.5,43038,42902,43538,43288,43744,43641,44175,43959.5,44175,1,431,null,8.3000000000000007,5334.4]
[10200,"Auburn City Council",3,61406,63318,62362,65924,64621,67819,66871.5,70232,69025.5,72630,71431,74920,73775,76640,75780,77779,77209.5,80540,79159.5,83367,81953.5,83367,3.5,2827,null,32.5,2567]
[10250,"Ballina Shire Council",4,38870,39120,38995,39305,39212.5,39537,39421,39824,39680.5,40020,39922,40295,40157.5,40571,40433,40747,40659,41015,40881,41335,41175,41335,0.8,320,null,484.7,85.3]
[10300,"Balranald Shire Council",9,2661,2596,2628.5,2545,2570.5,2507,2526,2473,2490,2433,2453,2404,2418.5,2381,2392.5,2353,2367,2340,2346.5,2371,2355.5,2371,1.3,31,null,21693.1,0.1]
[10350,"Bankstown City Council",3,171975,172208,172091.5,173282,172745,175789,174535.5,179352,177570.5,182679,181015.5,185770,184224.5,188185,186977.5,190851,189518,193605,192228,196974,195289.5,196974,1.7,3369,null,76.8,2564.8000000000002]
[10470,"Bathurst Regional Council",4,36084,36245,36164.5,36547,36396,36916,36731.5,37272,37094,37904,37588,38848,38376,39484,39166,39960,39722,40368,40164,41051,40709.5,41051,1.7,683,null,3816.4,10.8]
[10550,"Bega Valley Shire Council",4,31056,31406,31231,31608,31507,31829,31718.5,32183,32006,32367,32275,32620,32493.5,32962,32791,33128,33045,33242,33185,33313,33277.5,33313,0.2,71,null,6279,5.3]
[10600,"Bellingen Shire Council",11,12705,12672,12688.5,12682,12677,12716,12699,12773,12744.5,12787,12780,12837,12812,12891,12864,12923,12907,12858,12890.5,12854,12856,12854,0,-4,null,1600.4,8]
[10650,"Berrigan Shire Council",10,8035,8014,8024.5,8076,8045,8160,8118,8204,8182,8237,8220.5,8282,8259.5,8291,8286.5,8297,8294,8330,8313.5,8365,8347.5,8365,0.4,35,null,2065.9,4]
[10750,"Blacktown City Council",3,268806,271434,270120,275206,273320,278894,277050,284925,281909.5,292002,288463.5,299450,295726,306601,303025.5,312346,309473.5,318038,315192,325185,321611.5,325185,2.2000000000000002,7147,null,240.1,1354.3]
[10800,"Bland Shire Council",10,6453,6360,6406.5,6263,6311.5,6212,6237.5,6178,6195,6113,6145.5,6101,6107,6049,6075,6021,6035,6056,6038.5,6010,6033,6010,-0.8,-46,null,8557.7000000000007,0.7]
[10850,"Blayney Shire Council",10,6562,6598,6580,6649,6623.5,6741,6695,6821,6781,6900,6860.5,7041,6970.5,7143,7092,7217,7180,7279,7248,7330,7304.5,7330,0.7,51,null,1524.9,4.8]
[10900,"Blue Mountains City Council",7,76651,76436,76543.5,75971,76203.5,75600,75785.5,76198,75899,77102,76650,77869,77485.5,78227,78048,78553,78390,78748,78650.5,79225,78986.5,79225,0.6,477,null,1431.2,55.4]
[10950,"Bogan Shire Council",9,3052,3027,3039.5,2964,2995.5,2939,2951.5,2972,2955.5,2992,2982,2999,2995.5,3013,3006,3009,3011,3034,3021.5,3037,3035.5,3037,0.1,3,null,14600.5,0.2]
[11000,"Bombala Council",9,2590,2576,2583,2577,2576.5,2589,2583,2567,2578,2534,2550.5,2516,2525,2503,2509.5,2484,2493.5,2428,2456,2401,2414.5,2401,-1.1000000000000001,-27,null,3946.6,0.6]
[11050,"Boorowa Council",9,2399,2396,2397.5,2379,2387.5,2350,2364.5,2355,2352.5,2366,2360.5,2413,2389.5,2451,2432,2479,2465,2529,2504,2558,2543.5,2558,1.1000000000000001,29,null,2578,1]
[11100,"The Council of the City of Botany Bay",9,37228,37081,37154.5,37215,37148,37453,37334,38041,37747,39018,38529.5,40026,39522,40909,40467.5,41504,41206.5,42294,41899,43292,42793,43292,2.4,998,null,21.7,1996.2]
[11150,"Bourke Shire Council",8,3642,3494,3568,3349,3421.5,3185,3267,3073,3129,3046,3059.5,3013,3029.5,3033,3023,3053,3043,3029,3041,2996,3012.5,2996,-1.1000000000000001,-33,null,41604.5,0.1]
[11200,"Brewarrina Shire Council",4,2078,2039,2058.5,2029,2034,2004,2016.5,1961,1982.5,1944,1952.5,1900,1922,1878,1889,1874,1876,1874,1874,1940,1907,1940,3.5,66,null,19165.2,0.1]
[11250,"Broken Hill City Council",2,20403,20111,20257,19915,20013,19753,19834,19708,19730.5,19604,19656,19421,19512.5,19267,19344,19151,19209,19123,19137,19048,19085.5,19048,-0.4,-75,null,170.3,111.9]
[11300,"Burwood Council",4,30980,31370,31175,31696,31533,32199,31947.5,32893,32546,33343,33118,33708,33525.5,33835,33771.5,34176,34005.5,34707,34441.5,35298,35002.5,35298,1.7,591,null,7.1,4951.8999999999996]
[11350,"Byron Shire Council",11,29952,30141,30046.5,30130,30135.5,30125,30127.5,30174,30149.5,30347,30260.5,30537,30442,30664,30600.5,30712,30688,31024,30868,31612,31318,31612,1.9,588,null,565.79999999999995,55.9]
[11400,"Cabonne Council",6,12482,12506,12494,12543,12524.5,12634,12588.5,12706,12670,12799,12752.5,12929,12864,13071,13000,13211,13141,13476,13343.5,13695,13585.5,13695,1.6,219,null,6023.9,2.2999999999999998]
[11450,"Camden Council",7,48441,48925,48683,49990,49457.5,50628,50309,52178,51403,53736,52957,55377,54556.5,56846,56111.5,58439,57642.5,60661,59550,63248,61954.5,63248,4.3,2587,null,201.3,314.3]
[11500,"Campbelltown City Council",3,148743,147587,148165,147220,147403.5,146538,146879,147159,146848.5,148407,147783,149986,149196.5,150318,150152,151173,150745.5,152639,151906,154538,153588.5,154538,1.2,1899,null,312.10000000000002,495.1]
[11520,"City of Canada Bay Council",9,64060,65350,64705,66951,66150.5,68309,67630,70196,69252.5,72320,71258,75332,73826,77709,76520.5,80065,78887,82271,81168,84906,83588.5,84906,3.2,2635,null,19.899999999999999,4268]
[11550,"Canterbury City Council",9,134341,133462,133901.5,133836,133649,134789,134312.5,136803,135796,139725,138264,142023,140874,143933,142978,145089,144511,146829,145959,148853,147841,148853,1.4,2024,null,33.6,4434.8999999999996]
[11600,"Carrathool Shire Council",4,3143,3054,3098.5,2947,3000.5,2863,2905,2827,2845,2784,2805.5,2778,2781,2732,2755,2681,2706.5,2699,2690,2792,2745.5,2792,3.4,93,null,18932.5,0.1]
[11700,"Central Darling Shire Council",3,2218,2163,2190.5,2096,2129.5,2000,2048,2003,2001.5,2003,2003,2029,2016,2045,2037,2059,2052,2083,2071,2070,2076.5,2070,-0.6,-13,null,53493.8,0]
[11720,"Cessnock City Council",4,47181,47266,47223.5,47305,47285.5,47426,47365.5,48302,47864,49303,48802.5,50218,49760.5,51304,50761,52485,51894.5,53355,52920,54313,53834,54313,1.8,958,null,1965.4,27.6]
[11730,"Clarence Valley Council",4,48509,48631,48570,48853,48742,49149,49001,49524,49336.5,49818,49671,50433,50125.5,50993,50713,51287,51140,51332,51309.5,51043,51187.5,51043,-0.6,-289,null,10428.799999999999,4.9000000000000004]
[11750,"Cobar Shire Council",10,5082,5037,5059.5,5028,5032.5,5044,5036,5042,5043,4988,5015,4954,4971,4946,4950,4883,4914.5,4902,4892.5,5024,4963,5024,2.5,122,null,45571,0.1]
[11800,"Coffs Harbour City Council",5,64574,65448,65011,65957,65702.5,66657,66307,67567,67112,68574,68070.5,69358,68966,70373,69865.5,70972,70672.5,71085,71028.5,71798,71441.5,71798,1,713,null,1173.7,61.2]
[11860,"Conargo Shire Council",8,1769,1740,1754.5,1717,1728.5,1701,1709,1687,1694,1658,1672.5,1626,1642,1607,1616.5,1585,1596,1578,1581.5,1543,1560.5,1543,-2.2000000000000002,-35,null,8737.9,0.2]
[12000,"Coolamon Shire Council",9,4072,4066,4069,4072,4069,4097,4084.5,4116,4106.5,4145,4130.5,4187,4166,4216,4201.5,4236,4226,4287,4261.5,4276,4281.5,4276,-0.3,-11,null,2430.9,1.8]
[12050,"Cooma-Monaro Shire Council",11,9784,9838,9811,9911,9874.5,9980,9945.5,9991,9985.5,10003,9997,10051,10027,10085,10068,10131,10108,10173,10152,10073,10123,10073,-1,-100,null,5184.5,1.9]
[12150,"Coonamble Shire Council",9,4578,4476,4527,4394,4435,4305,4349.5,4253,4279,4233,4243,4223,4228,4224,4223.5,4226,4225,4238,4232,4279,4258.5,4279,1,41,null,9915.9,0.4]
[12200,"Cootamundra Shire Council",10,7529,7494,7511.5,7494,7494,7483,7488.5,7451,7467,7419,7435,7471,7445,7508,7489.5,7546,7527,7622,7584,7625,7623.5,7625,0,3,null,1523.8,5]
[12300,"Corowa Shire Council",11,10819,10910,10864.5,11027,10968.5,11216,11121.5,11220,11218,11233,11226.5,11298,11265.5,11318,11308,11324,11321,11387,11355.5,11410,11398.5,11410,0.2,23,null,2329.3000000000002,4.9000000000000004]
[12350,"Cowra Shire Council",1,12849,12804,12826.5,12774,12789,12754,12764,12688,12721,12591,12639.5,12548,12569.5,12533,12540.5,12523,12528,12640,12581.5,12551,12595.5,12551,-0.7,-89,null,2808.7,4.5]
[12500,"Deniliquin Council",11,8029,7863,7946,7723,7793,7586,7654.5,7541,7563.5,7452,7496.5,7446,7449,7366,7406,7303,7334.5,7336,7319.5,7376,7356,7376,0.5,40,null,143.19999999999999,51.5]
[12600,"Dubbo City Council",4,38506,38567,38536.5,38653,38610,38834,38743.5,39004,38919,39204,39104,39626,39415,40068,39847,40246,40157,40614,40430,40975,40794.5,40975,0.9,361,null,3425.7,12]
[12700,"Dungog Shire Council",4,8312,8233,8272.5,8263,8248,8245,8254,8245,8245,8286,8265.5,8415,8350.5,8457,8436,8556,8506.5,8706,8631,8884,8795,8884,2,178,null,2250,3.9]
[12750,"Eurobodalla Shire Council",10,34855,35326,35090.5,35662,35494,35855,35758.5,36103,35979,36301,36202,36462,36381.5,36807,36634.5,37082,36944.5,37104,37093,37234,37169,37234,0.4,130,null,3428.2,10.9]
[12850,"Fairfield City Council",4,186489,185562,186025.5,185740,185651,186117,185928.5,187872,186994.5,190654,189263,193557,192105.5,195174,194365.5,196479,195826.5,198465,197472,201427,199946,201427,1.5,2962,null,101.5,1984.1]
[12900,"Forbes Shire Council",3,9907,9744,9825.5,9610,9677,9540,9575,9573,9556.5,9526,9549.5,9562,9544,9495,9528.5,9469,9482,9533,9501,9664,9598.5,9664,1.4,131,null,4718.1000000000004,2]
[12950,"Gilgandra Shire Council",10,4706,4660,4683,4652,4656,4618,4635,4532,4575,4471,4501.5,4498,4484.5,4529,4513.5,4515,4522,4483,4499,4488,4485.5,4488,0.1,5,null,4832,0.9]
[13010,"Glen Innes Severn Council",9,8870,8876,8873,8907,8891.5,8987,8947,8919,8953,8907,8913,8926,8916.5,8939,8932.5,8911,8925,8903,8907,8905,8904,8905,0,2,null,5480.4,1.6]
[13050,"Gloucester Shire Council",10,4866,4850,4858,4858,4854,4879,4868.5,4851,4865,4845,4848,4874,4859.5,4929,4901.5,4991,4960,5015,5003,4974,4994.5,4974,-0.8,-41,null,2950.2,1.7]
[13100,"Gosford City Council",10,160737,160501,160619,160733,160617,161158,160945.5,162272,161715,164469,163370.5,166396,165432.5,167686,167041,168323,168004.5,169574,168948.5,170752,170163,170752,0.7,1178,null,941.1,181.4]
[13310,"Goulburn Mulwaree Council",7,26576,26559,26567.5,26615,26587,26695,26655,26803,26749,27166,26984.5,27654,27410,28083,27868.5,28363,28223,28745,28554,29230,28987.5,29230,1.7,485,null,3220,9.1]
[13320,"Great Lakes Council",4,32890,33146,33018,33372,33259,33576,33474,33996,33786,34400,34198,34856,34628,35369,35112.5,35737,35553,35977,35857,36312,36144.5,36312,0.9,335,null,3373.3,10.8]
[13340,"Greater Hume Shire Council",4,10189,10126,10157.5,10036,10081,9999,10017.5,9985,9992,9988,9986.5,10009,9998.5,10060,10034.5,10072,10066,10140,10106,10176,10158,10176,0.4,36,null,5749.3,1.8]
[13380,"Greater Taree City Council",11,45258,45734,45496,46051,45892.5,46124,46087.5,46478,46301,46846,46662,47212,47029,47650,47431,48090,47870,48403,48246.5,48846,48624.5,48846,0.9,443,null,3729.1,13.1]
[13450,"Griffith City Council",4,24277,24235,24256,24329,24282,24450,24389.5,24583,24516.5,24817,24700,25100,24958.5,25264,25182,25395,25329.5,25493,25444,25425,25459,25425,-0.3,-68,null,1639.9,15.5]
[13500,"Gundagai Shire Council",4,3763,3754,3758.5,3762,3758,3771,3766.5,3750,3760.5,3749,3749.5,3759,3754,3766,3762.5,3762,3764,3767,3764.5,3747,3757,3747,-0.5,-20,null,2457.1,1.5]
[13550,"Gunnedah Shire Council",9,12036,11892,11964,11792,11842,11782,11787,11879,11830.5,11987,11933,12151,12069,12344,12247.5,12519,12431.5,12618,12568.5,12688,12653,12688,0.6,70,null,4987.3999999999996,2.5]
[13650,"Guyra Shire Council",11,4393,4353,4373,4344,4348.5,4333,4338.5,4324,4328.5,4350,4337,4419,4384.5,4478,4448.5,4520,4499,4557,4538.5,4645,4601,4645,1.9,88,null,4389.6000000000004,1.1000000000000001]
[13660,"Gwydir Shire Council",9,5573,5492,5532.5,5442,5467,5428,5435,5307,5367.5,5210,5258.5,5167,5188.5,5131,5149,5102,5116.5,5117,5109.5,5104,5110.5,5104,-0.3,-13,null,9262.4,0.6]
[13700,"Harden Shire Council",10,3720,3680,3700,3665,3672.5,3668,3666.5,3662,3665,3661,3661.5,3652,3656.5,3661,3656.5,3695,3678,3716,3705.5,3762,3739,3762,1.2,46,null,1868.3,2]
[13800,"Hawkesbury City Council",9,62530,62032,62281,61698,61865,61725,61711.5,62262,61993.5,63066,62664,63618,63342,63982,63800,64353,64167.5,64639,64496,65114,64876.5,65114,0.7,475,null,2774.6,23.5]
[13850,"Hay Shire Council",6,3582,3538,3560,3512,3525,3483,3497.5,3394,3438.5,3292,3343,3209,3250.5,3153,3181,3085,3119,3015,3050,2962,2988.5,2962,-1.8,-53,null,11326,0.3]
[13950,"Holroyd City Council",9,89413,89792,89602.5,91042,90417,92752,91897,95335,94043.5,98038,96686.5,100097,99067.5,102076,101086.5,104079,103077.5,106164,105121.5,108889,107526.5,108889,2.6,2725,null,40.200000000000003,2709.9]
[14000,"The Council of the Shire of Hornsby",3,154504,155124,154814,155587,155355.5,155848,155717.5,157411,156629.5,159382,158396.5,161377,160379.5,162808,162092.5,163783,163295.5,165160,164471.5,166855,166007.5,166855,1,1695,null,462.1,361.1]
[14100,"The Council of the Municipality of Hunters Hill",3,13512,13631,13571.5,13636,13633.5,13662,13649,13716,13689,13742,13729,13835,13788.5,13854,13844.5,13897,13875.5,14162,14029.5,14491,14326.5,14491,2.2999999999999998,329,null,5.7,2534.6999999999998]
[14150,"Hurstville City Council",11,74564,74809,74686.5,75458,75133.5,76007,75732.5,77392,76699.5,78916,78154,80468,79692,81796,81132,82810,82303,83755,83282.5,84859,84307,84859,1.3,1104,null,22.7,3734.3]
[14200,"Inverell Shire Council",8,15723,15708,15715.5,15765,15736.5,15845,15805,15973,15909,16118,16045.5,16320,16219,16476,16398,16584,16530,16678,16631,16727,16702.5,16727,0.3,49,null,8594.9,1.9]
[14250,"Jerilderie Shire Council",10,1804,1754,1779,1708,1731,1675,1691.5,1626,1650.5,1595,1610.5,1586,1590.5,1568,1577,1538,1553,1524,1531,1504,1514,1504,-1.3,-20,null,3373.1,0.4]
[14300,"Junee Shire Council",4,5861,5854,5857.5,5882,5868,5943,5912.5,5942,5942.5,5978,5960,6054,6016,6105,6079.5,6132,6118.5,6160,6146,6227,6193.5,6227,1.1000000000000001,67,null,2030,3.1]
[14350,"Kempsey Shire Council",2,27466,27608,27537,27936,27772,28032,27984,28193,28112.5,28431,28312,28775,28603,28960,28867.5,29128,29044,29286,29207,29361,29323.5,29361,0.3,75,null,3375.7,8.6999999999999993]
[14400,"The Council of the Municipality of Kiama",3,19836,19784,19810,19690,19737,19626,19658,19809,19717.5,19933,19871,20219,20076,20522,20370.5,20806,20664,20870,20838,21047,20958.5,21047,0.8,177,null,257.7,81.7]
[14450,"Kogarah City Council",10,52619,53367,52993,54032,53699.5,54579,54305.5,55359,54969,56371,55865,57511,56941,58244,57877.5,58916,58580,59768,59342,60411,60089.5,60411,1.1000000000000001,643,null,15.5,3885.5]
[14500,"Ku-ring-gai Council",10,106559,105839,106199,104883,105361,104459,104671,105551,105005,107976,106763.5,110464,109220,112643,111553.5,114604,113623.5,116596,115600,119027,117811.5,119027,2.1,2431,null,85.4,1393.8]
[14550,"Kyogle Council",5,9590,9525,9557.5,9507,9516,9491,9499,9491,9491,9490,9490.5,9514,9502,9544,9529,9537,9540.5,9534,9535.5,9538,9536,9538,0,4,null,3584,2.7]
[14600,"Lachlan Shire Council",2,7233,7090,7161.5,6956,7023,6829,6892.5,6733,6781,6692,6712.5,6678,6685,6663,6670.5,6701,6682,6736,6718.5,6748,6742,6748,0.2,12,null,14965.4,0.5]
[14650,"Lake Macquarie City Council",11,188171,188415,188293,188547,188481,188503,188525,189672,189087.5,191478,190575,193585,192531.5,195263,194424,196811,196037,198598,197704.5,200796,199697,200796,1.1000000000000001,2198,null,648,309.89999999999998]
[14700,"Lane Cove Municipal Council",2,31695,31599,31647,31538,31568.5,31527,31532.5,31678,31602.5,31918,31798,32308,32113,32803,32555.5,33233,33018,33603,33418,33996,33799.5,33996,1.2,393,null,10.5,3244]
[14750,"Leeton Shire Council",4,11755,11681,11718,11590,11635.5,11562,11576,11502,11532,11457,11479.5,11461,11459,11432,11446.5,11406,11419,11501,11453.5,11539,11520,11539,0.3,38,null,1167,9.9]
[14800,"Leichhardt Municipal Council",7,50661,50859,50760,50914,50886.5,51243,51078.5,52095,51669,53133,52614,54115,53624,54969,54542,55642,55305.5,56364,56003,57266,56815,57266,1.6,902,null,10.5,5428.2]
[14850,"Lismore City Council",10,42681,42764,42722.5,43011,42887.5,43338,43174.5,43636,43487,43750,43693,43940,43845,44190,44065,44348,44269,44501,44424.5,44637,44569,44637,0.3,136,null,1287.8,34.700000000000003]
[14870,"City of Lithgow Council",9,20418,20357,20387.5,20272,20314.5,20186,20229,20277,20231.5,20352,20314.5,20621,20486.5,20732,20676.5,20850,20791,21003,20926.5,21118,21060.5,21118,0.5,115,null,4511.8999999999996,4.7]
[14900,"Liverpool City Council",4,163835,165627,164731,167472,166549.5,169868,168670,172875,171371.5,177372,175123.5,181712,179542,184910,183311,188088,186499,191401,189744.5,195355,193378,195355,2.1,3954,null,305.39999999999998,639.6]
[14920,"Liverpool Plains Shire Council",2,7859,7797,7828,7736,7766.5,7717,7726.5,7720,7718.5,7717,7718.5,7718,7717.5,7738,7728,7761,7749.5,7789,7775,7763,7776,7763,-0.3,-26,null,5082.3,1.5]
[14950,"Lockhart Shire Council",3,3404,3330,3367,3267,3298.5,3237,3252,3203,3220,3171,3187,3159,3165,3133,3146,3098,3115.5,3081,3089.5,3021,3051,3021,-1.9,-60,null,2895.9,1]
[15050,"Maitland City Council",4,59167,60440,59803.5,61961,61200.5,63505,62733,65143,64324,66244,65693.5,67268,66756,68561,67914.5,69924,69242.5,71891,70907.5,73447,72669,73447,2.2000000000000002,1556,null,391.5,187.6]
[15150,"Manly Council",11,38575,38646,38610.5,38627,38636.5,39026,38826.5,39775,39400.5,39852,39813.5,40938,40395,41899,41418.5,42818,42358.5,43412,43115,44232,43822,44232,1.9,820,null,14.4,3081.3]
[15200,"Marrickville Council",2,74965,74516,74740.5,74740,74628,75090,74915,76470,75780,78035,77252.5,79225,78630,80388,79806.5,81121,80754.5,81735,81428,82523,82129,82523,1,788,null,16.5,4995.5]
[15270,"Mid-Western Regional Council",10,21862,21706,21784,21647,21676.5,21641,21644,21887,21764,22186,22036.5,22469,22327.5,22774,22621.5,23020,22897,23532,23276,23843,23687.5,23843,1.3,311,null,8752.7999999999993,2.7]
[15300,"Moree Plains Shire Council",9,15457,15028,15242.5,14693,14860.5,14407,14550,14155,14281,14070,14112.5,14019,14044.5,14032,14025.5,14043,14037.5,14175,14109,14250,14212.5,14250,0.5,75,null,17906,0.8]
[15350,"Mosman Municipal Council",11,27680,27737,27708.5,27538,27637.5,27570,27554,27900,27735,28422,28161,28761,28591.5,29131,28946,29351,29241,29614,29482.5,29983,29798.5,29983,1.2,369,null,8.6999999999999993,3465.8]
[15500,"Murray Shire Council",11,6271,6320,6295.5,6394,6357,6552,6473,6757,6654.5,6906,6831.5,7017,6961.5,7119,7068,7184,7151.5,7318,7251,7418,7368,7418,1.4,100,null,4344.5,1.7]
[15550,"Murrumbidgee Shire Council",11,2598,2574,2586,2565,2569.5,2544,2554.5,2483,2513.5,2444,2463.5,2406,2425,2380,2393,2350,2365,2416,2383,2503,2459.5,2503,3.6,87,null,3506.7,0.7]
[15650,"Muswellbrook Shire Council",10,15402,15402,15402,15467,15434.5,15639,15553,15713,15676,15749,15731,15878,15813.5,16108,15993,16328,16218,16673,16500.5,16851,16762,16851,1.1000000000000001,178,null,3405,4.9000000000000004]
[15700,"Nambucca Shire Council",10,17849,18136,17992.5,18247,18191.5,18299,18273,18456,18377.5,18695,18575.5,18892,18793.5,19140,19016,19235,19187.5,19365,19300,19529,19447,19529,0.8,164,null,1491.4,13.1]
[15750,"Narrabri Shire Council",5,14050,13784,13917,13592,13688,13477,13534.5,13359,13418,13303,13331,13349,13326,13394,13371.5,13438,13416,13529,13483.5,13685,13607,13685,1.2,156,null,13014.1,1.1000000000000001]
[15800,"Narrandera Shire Council",2,6433,6307,6370,6221,6264,6149,6185,6103,6126,6069,6086,6093,6081,6105,6099,6115,6110,6078,6096.5,6030,6054,6030,-0.8,-48,null,4116.2,1.5]
[15850,"Narromine Shire Council",10,6863,6777,6820,6734,6755.5,6691,6712.5,6676,6683.5,6726,6701,6748,6737,6815,6781.5,6832,6823.5,6860,6846,6872,6866,6872,0.2,12,null,5260.4,1.3]
[15900,"Newcastle City Council",4,143613,144834,144223.5,145914,145374,146623,146268.5,148524,147573.5,150553,149538.5,151895,151224,153483,152689,155550,154516.5,157346,156448,158553,157949.5,158553,0.8,1207,null,186.8,848.9]
[15950,"North Sydney Council",11,59583,60271,59927,60850,60560.5,61512,61181,62476,61994,63484,62980,64762,64123,65850,65306,66747,66298.5,67888,67317.5,69248,68568,69248,2,1360,null,10.5,6612.3]
[16100,"Oberon Council",11,5243,5209,5226,5193,5201,5179,5186,5166,5172.5,5161,5163.5,5192,5176.5,5207,5199.5,5209,5208,5221,5215,5270,5245.5,5270,0.9,49,null,3626.9,1.5]
[16150,"Orange City Council",3,36721,36501,36611,36410,36455.5,36374,36392,36801,36587.5,37401,37101,37904,37652.5,38660,38282,39419,39039.5,40160,39789.5,40869,40514.5,40869,1.8,709,null,283.89999999999998,143.9]
[16180,"Palerang Council",7,11529,11837,11683,12172,12004.5,12703,12437.5,13291,12997,13782,13536.5,14232,14007,14591,14411.5,14857,14724,15092,14974.5,15306,15199,15306,1.4,214,null,5146.8,3]
[16200,"Parkes Shire Council",2,14807,14690,14748.5,14627,14658.5,14600,14613.5,14643,14621.5,14755,14699,14835,14795,14984,14909.5,15083,15033.5,15163,15123,15087,15125,15087,-0.5,-76,null,5954.9,2.5]
[16250,"Parramatta City Council",5,147310,148882,148096,150439,149660.5,152948,151693.5,157095,155021.5,161894,159494.5,166816,164355,171080,168948,174783,172931.5,178874,176828.5,184622,181748,184622,3.2,5748,null,61.4,3009]
[16350,"Penrith City Council",4,176610,175589,176099.5,175799,175694,176067,175933,177280,176673.5,179851,178565.5,181901,180876,182948,182424.5,184589,183768.5,187103,185846,190428,188765.5,190428,1.8,3325,null,404.6,470.6]
[16370,"Pittwater Council",4,55837,55610,55723.5,55943,55776.5,56252,56097.5,56680,56466,57137,56908.5,58672,57904.5,59577,59124.5,60455,60016,61256,60855.5,62070,61663,62070,1.3,814,null,90.3,687.2]
[16380,"Port Macquarie-Hastings Council",3,67960,68987,68473.5,69659,69323,69947,69803,71097,70522,72528,71812.5,73317,72922.5,74460,73888.5,75232,74846,76046,75639,76563,76304.5,76563,0.7,517,null,3683,20.8]
[16400,"Port Stephens Council",4,60410,61256,60833,61918,61587,62132,62025,63425,62778.5,64316,63870.5,65521,64918.5,66447,65984,67214,66830.5,68042,67628,68935,68488.5,68935,1.3,893,null,858.5,80.3]
[16470,"Queanbeyan City Council",3,35613,35946,35779.5,36714,36330,37367,37040.5,37711,37539,38359,38035,38958,38658.5,39659,39308.5,39987,39823,40250,40118.5,40568,40409,40568,0.8,318,null,172.4,235.4]
[16550,"Randwick City Council",3,124252,124088,124170,124596,124342,125346,124971,128229,126787.5,131136,129682.5,133975,132555.5,136006,134990.5,137792,136899,139530,138661,142310,140920,142310,2,2780,null,36.299999999999997,3917.1]
[16610,"Richmond Valley Council",4,21213,21167,21190,21256,21211.5,21728,21492,22067,21897.5,22291,22179,22417,22354,22597,22507,22717,22657,22716,22716.5,22749,22732.5,22749,0.1,33,null,3047.4,7.5]
[16650,"Rockdale City Council",5,93370,94063,93716.5,94897,94480,95752,95324.5,97790,96771,100538,99164,102501,101519.5,103386,102943.5,103481,103433.5,105185,104333,106712,105948.5,106712,1.5,1527,null,28.2,3781.5]
[16700,"Ryde City Council",4,98929,99089,99009,99527,99308,100344,99935.5,102453,101398.5,104602,103527.5,105983,105292.5,107319,106651,108712,108015.5,110842,109777,112545,111693.5,112545,1.5,1703,null,40.5,2780.7]
[16900,"Shellharbour City Council",10,60815,61382,61098.5,61863,61622.5,62243,62053,62916,62579.5,63956,63436,64778,64367,65597,65187.5,66218,65907.5,66869,66543.5,67797,67333,67797,1.4,928,null,147.4,460.1]
[16950,"Shoalhaven City Council",2,88861,89374,89117.5,90173,89773.5,90505,90339,91497,91001,92351,91924,93754,93052.5,95154,94454,96203,95678.5,97047,96625,97694,97370.5,97694,0.7,647,null,4567,21.4]
[17000,"Singleton Council",3,21671,21886,21778.5,22254,22070,22535,22394.5,22663,22599,22860,22761.5,23063,22961.5,23335,23199,23523,23429,23787,23655,23751,23769,23751,-0.2,-36,null,4892.8,4.9000000000000004]
[17050,"Snowy River Shire Council",4,7336,7348,7342,7378,7363,7439,7408.5,7515,7477,7610,7562.5,7674,7642,7747,7710.5,7771,7759,7935,7853,8087,8011,8087,1.9,152,null,6030.4,1.3]
[17100,"Strathfield Municipal Council",10,30256,31242,30749,32143,31692.5,33030,32586.5,34219,33624.5,35343,34781,36592,35967.5,37002,36797,37239,37120.5,37664,37451.5,38358,38011,38358,1.8,694,null,13.9,2759.6]
[17150,"Sutherland Shire Council",10,212719,211907,212313,211460,211683.5,211230,211345,213161,212195.5,216400,214780.5,219065,217732.5,220060,219562.5,220250,220155,221283,220766.5,223192,222237.5,223192,0.9,1909,null,333.6,669.1]
[17200,"Council of the City of Sydney",2,145079,152892,148985.5,158834,155863,164597,161715.5,169056,166826.5,172985,171020.5,177150,175067.5,180748,178949,183281,182014.5,187690,185485.5,191918,189804,191918,2.2999999999999998,4228,null,26.7,7181.1]
[17310,"Tamworth Regional Council",2,54016,54111,54063.5,54363,54237,54887,54625,55607,55247,56148,55877.5,56814,56481,57650,57232,58228,57939,58976,58602,59743,59359.5,59743,1.3,767,null,9884.2000000000007,6]
[17350,"Temora Shire Council",4,6123,6039,6081,6016,6027.5,6008,6012,5977,5992.5,5959,5968,5936,5947.5,5951,5943.5,5953,5952,5983,5968,5995,5989,5995,0.2,12,null,2802,2.1]
[17400,"Tenterfield Shire Council",7,6709,6650,6679.5,6630,6640,6666,6648,6731,6698.5,6796,6763.5,6882,6839,6941,6911.5,6990,6965.5,6997,6993.5,6973,6985,6973,-0.3,-24,null,7322.3,1]
[17420,"The Hills Shire Council",9,154342,157991,156166.5,161315,159653,164132,162723.5,166054,165093,169508,167781,173074,171291,175748,174411,177014,176381,180130,178572,183563,181846.5,183563,1.9,3433,null,400.5,458.4]
[17450,"Tumbarumba Shire Council",7,3668,3633,3650.5,3620,3626.5,3622,3621,3572,3597,3530,3551,3506,3518,3495,3500.5,3484,3489.5,3520,3502,3521,3520.5,3521,0,1,null,4392.5,0.8]
[17500,"Tumut Shire Council",9,11384,11160,11272,11080,11120,11062,11071,11069,11065.5,11045,11057,11141,11093,11233,11187,11272,11252.5,11307,11289.5,11316,11311.5,11316,0.1,9,null,4566.6000000000004,2.5]
[17550,"Tweed Shire Council",11,77868,79555,78711.5,80382,79968.5,81531,80956.5,83060,82295.5,84842,83951,86539,85690.5,87722,87130.5,88437,88079.5,88974,88705.5,90114,89544,90114,1.3,1140,null,1307.4000000000001,68.900000000000006]
[17620,"Upper Hunter Shire Council",5,13335,13235,13285,13281,13258,13333,13307,13374,13353.5,13599,13486.5,13801,13700,13983,13892,14206,14094.5,14528,14367,14650,14589,14650,0.8,122,null,8096.1,1.8]
[17640,"Upper Lachlan Shire Council",11,7195,7192,7193.5,7185,7188.5,7209,7197,7229,7219,7276,7252.5,7333,7304.5,7379,7356,7422,7400.5,7555,7488.5,7586,7570.5,7586,0.4,31,null,7127.5,1.1000000000000001]
[17650,"Uralla Shire Council",10,5912,5885,5898.5,5888,5886.5,5894,5891,5930,5912,5996,5963,6129,6062.5,6198,6163.5,6241,6219.5,6273,6257,6370,6321.5,6370,1.5,97,null,3226.5,2]
[17700,"Urana Shire Council",10,1365,1327,1346,1303,1315,1281,1292,1259,1270,1235,1247,1217,1226,1202,1209.5,1185,1193.5,1180,1182.5,1157,1168.5,1157,-1.9,-23,null,3356,0.3]
[17750,"Wagga Wagga City Council",8,56897,57211,57054,57761,57486,58518,58139.5,59493,59005.5,60329,59911,61061,60695,61503,61282,61781,61642,61781,61781,62149,61965,62149,0.6,368,null,4825.8999999999996,12.9]
[17800,"The Council of the Shire of Wakool",4,4695,4609,4652,4538,4573.5,4468,4503,4325,4396.5,4255,4290,4209,4232,4140,4174.5,4073,4106.5,4038,4055.5,3979,4008.5,3979,-1.5,-59,null,7520.5,0.5]
[17850,"Walcha Council",9,3257,3244,3250.5,3244,3244,3259,3251.5,3210,3234.5,3172,3191,3154,3163,3137,3145.5,3119,3128,3104,3111.5,3087,3095.5,3087,-0.5,-17,null,6261.3,0.5]
[17900,"Walgett Shire Council",10,7800,7517,7658.5,7312,7414.5,7129,7220.5,6979,7054,6883,6931,6914,6898.5,6908,6911,6797,6852.5,6813,6805,6785,6799,6785,-0.4,-28,null,22308.5,0.3]
[17950,"Warren Shire Council",9,3111,3008,3059.5,2919,2963.5,2814,2866.5,2786,2800,2789,2787.5,2807,2798,2840,2823.5,2862,2851,2903,2882.5,2910,2906.5,2910,0.2,7,null,10753.8,0.3]
[18000,"Warringah Council",3,135796,136182,135989,137171,136676.5,138322,137746.5,140629,139475.5,142853,141741,144890,143871.5,146774,145832,148423,147598.5,150358,149390.5,152636,151497,152636,1.5,2278,null,149.4,1022]
[18020,"Warrumbungle Shire Council",10,10446,10258,10352,10155,10206.5,10034,10094.5,9952,9993,9925,9938.5,9930,9927.5,9921,9925.5,9898,9909.5,9859,9878.5,9778,9818.5,9778,-0.8,-81,null,12371.1,0.8]
[18050,"Waverley Council",2,62778,62988,62883,63435,63211.5,64294,63864.5,65279,64786.5,66458,65868.5,67394,66926,68082,67738,68698,68390,69515,69106.5,70706,70110.5,70706,1.7,1191,null,9.1999999999999993,7649.7]
[18100,"Weddin Shire Council",9,3768,3756,3762,3737,3746.5,3722,3729.5,3710,3716,3715,3712.5,3720,3717.5,3733,3726.5,3759,3746,3744,3751.5,3711,3727.5,3711,-0.9,-33,null,3408.6,1.1000000000000001]
[18150,"Wellington Council",10,8554,8458,8506,8385,8421.5,8314,8349.5,8311,8312.5,8645,8478,8840,8742.5,8881,8860.5,8833,8857,8839,8836,8955,8897,8955,1.3,116,null,4110.1000000000004,2.2000000000000002]
[18200,"Wentworth Shire Council",10,7009,6946,6977.5,6915,6930.5,6926,6920.5,6963,6944.5,6964,6963.5,6932,6948,6910,6921,6837,6873.5,6838,6837.5,6832,6835,6832,-0.1,-6,null,26256.7,0.3]
[18250,"Willoughby City Council",3,63389,64414,63901.5,65578,64996,66481,66029.5,67809,67145,68434,68121.5,69512,68973,70256,69884,71139,70697.5,72032,71585.5,73155,72593.5,73155,1.6,1123,null,22.4,3261.6]
[18350,"Wingecarribee Shire Council",4,43257,43348,43302.5,43402,43375,43532,43467,44054,43793,44539,44296.5,45165,44852,45761,45463,46126,45943.5,46487,46306.5,47054,46770.5,47054,1.2,567,null,2688.4,17.5]
[18400,"Wollondilly Shire Council",6,39215,39830,39522.5,40411,40120.5,40969,40690,41589,41279,42401,41995,43145,42773,43828,43486.5,44607,44217.5,45362,44984.5,46295,45828.5,46295,2.1,933,null,2555.9,18.100000000000001]
[18450,"Wollongong City Council",5,190475,190641,190558,190721,190681,190909,190815,192770,191839.5,195437,194103.5,197887,196662,200468,199177.5,202068,201268,203181,202624.5,205231,204206,205231,1,2050,null,684,300]
[18500,"Woollahra Municipal Council",2,52998,52723,52860.5,52655,52689,52995,52825,53564,53279.5,54076,53820,54862,54469,55497,55179.5,56320,55908.5,57032,56676,57677,57354.5,57677,1.1000000000000001,645,null,12.3,4699.1000000000004]
[18550,"Wyong Shire Council",7,138582,139498,139040,140670,140084,141893,141281.5,144227,143060,147869,146048,150400,149134.5,152675,151537.5,154334,153504.5,155844,155089,157358,156601,157358,1,1514,null,739.8,212.7]
[18710,"Yass Valley Council",11,12772,13058,12915,13247,13152.5,13500,13373.5,13916,13708,14310,14113,14714,14512,15227,14970.5,15615,15421,15981,15798,16270,16125.5,16270,1.8,289,null,3998.1,4.0999999999999996]
[18750,"Young Shire Council",11,11912,11984,11948,12102,12043,12195,12148.5,12249,12222,12310,12279.5,12402,12356,12527,12464.5,12619,12573,12709,12664,12699,12704,12699,-0.1,-10,null,2692.7,4.7]
[]
[19399,"Unincorporated NSW",null,1162,1135,null,1114,null,1095,null,1100,null,1107,null,1107,null,1114,null,1119,null,1130,null,1121,null,null,-0.8,-9,null,93213.5,0]
[]
[null,"TOTAL NEW SOUTH WALES",null,6620715,6650735,null,6693206,null,6742690,null,6834156,null,6943461,null,7053755,null,7144292,null,7218529,null,7307183,null,7410399,null,null,1.4,103216,null,800808.8,9.3000000000000007]

{"sheet":"Sheet1","index":25,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet2","index":26,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}