{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Examples","Journal","Cover","Results","Inputs","ABS CPI","ABS PPI","PPI T17","ABS WPI","Calculations--->","BCC Preferred","BCC Option 1 RBA WPI","BCC Preferred with true-up"],"not_rendered":{"charts":29,"images":1,"macros":1,"external_links":0,"defined_names":7,"comments":7,"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":"Examples","index":0,"n_rows":44,"n_cols":27,"rows_kept":44,"cut":false,"hidden":true,"merged":[]}
[]
[null,"IPART colour codes for models, spreadsheets and information requests"]
[null,"NB  ALWAYS DESCRIBE THE COLOUR CODE USED IN YOUR MODEL "]
[null,"Note: If you use the formats for the inputs provided in this template, input cells will always be unprotected even when you protect the worksheet"]
[null,null,null,null,null,null,null,"use this column cell to \"paint\" input cells for numbers (NOT for percentages)"]
[null,null,null,null,null,null,null,null,"use this column cell to \"paint\" input cells for percentages (NOT numbers)"]
[null,"Models and spreadsheets"]
[null,null,null,null,null,null,"numbers","%"]
[null,"Inputs",null,null,null,null,4232,0.08]
[null,"Inputs with default values, default values are shown in italics next to or below ",null,null,null,null,34345,0.08]
[null,"Hard-coded values used that should not be changed, e.g. credit ratings or '1' at the start of an index series."]
[null,"Key outputs"]
[null,"Links from other files (green)"]
[null,"Error check (check =0)"]
[null,"Error warnings, messages and unusual calculation assumptions"]
[null,"Indicate change in formula across row with a double red line"]
[null,"Note:  You can combine options for inputs, e.g.:",null,null,"Inputs can be links to other files "]
[null,null,null,null,"You can drawn attention to unusual inputs "]
[]
[null,null,null,null,null,null,null,"use this column cell to \"paint\" input cells for numbers (NOT for percentages)"]
[null,"Information Requests",null,null,null,null,null,null,"use this column cell to \"paint\" input cells for percentages (NOT numbers)"]
[null,null,null,null,null,null,"numbers","%"]
[null,"Inputs for historical years (actual values)",null,null,null,null,234,0.24]
[null,"Forecast inputs",null,null,null,null,6667,0.05]
[null,"Error warnings and messages"]
[null,"Error check (check =0)"]
[]
[null,"QA notes - annotation or documentation by QA staff"]
[]
[]
[]
[]
["User Instructions - IPART CHARTS"]
[]
[null,"Data 1","Data 2","Data 3","Data 4","Data 5","Data 6","Data 7","Data 8",null,null,"Data 1","Data 2","Data 3","Data 4","Data 5","Data 6",null,"X value","1st Y value","2nd Y value",null,null,"Blue","Grey","Turquoise","Grey-80%"]
["1975-76",36.19,36.880000000000003,21.56,5.36,3.01,10,5.2,13,null,"1975-76",33.19,36.880000000000003,21.56,5.36,3.01,10,null,1.8,10,17,null,"1975-76",33.19,36.880000000000003,21.56,5.36]
["1983-84",39.39,32.020000000000003,21.6,7.01,3.36,12,6.6,15,null,"1983-84",39.39,32.020000000000003,21.6,7.01,3.36,12,null,2.2999999999999998,12,9,null,"1983-84",39.39,32.020000000000003,21.6,7.01]
["1988-89",42.78,29.91,18.350000000000001,6.33,2.63,14,5.7,16,null,"1988-89",42.78,29.91,18.350000000000001,6.33,2.63,14,null,3.7,16,14,null,"1988-89",42.78,29.91,18.350000000000001,6.33]
["1993-94",42.13,26.53,21.6,7.01,2.72,16,3,17,null,"1993-94",42.13,26.53,21.6,7.01,2.72,16,null,4.0999999999999996,8,23,null,"1993-94",42.13,26.53,21.6,7.01]
["1996-97",41.69,24.76,23.98,7,2.57,18,3.5,19,null,"1996-97",41.69,24.76,23.98,7,2.57,18,null,5.5,14,27,null,"1996-97",41.69,24.76,23.98,7]
["1997-98",39.39,32.020000000000003,21.6,7.01,3.36,12,3.8,13,null,"1997-98",39.39,32.020000000000003,21.6,7.01,3.36,12,null,null,null,null,null,"1997-98",39.39,32.020000000000003,21.6,7.01]
["1998-99",42.13,26.53,21.6,7.01,2.72,16,3.2,18,null,"1998-99",42.13,26.53,21.6,7.01,2.72,16,null,null,null,null,null,"1998-99",42.13,26.53,21.6,7.01]
["1999-00",45,22,26,8,2,20,4,22,null,"1999-00",45,22,26,8,2,20,null,null,null,null,null,"1999-00",45,22,26,8]
["–  en rule for when needed"]

{"sheet":"Journal","index":1,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Journal of structural changes made to model/spreadsheet"]
[]
[null,"Changes since Draft report (D23/9745)"]
[null,"Please paste the name of the updated version in the box below (file name)"]
[]
[null,"<Enter file name here>"]
[]
[null,"Description of changes:","Worksheet:","Made by:","Date","Notes"]
[null,"SIGNIFICANT STRUCTURAL CHANGES MADE IN THIS VERSION"]
[null,"Simplified "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"OTHER CHANGES"]
[]
[]
[]
[]
[null,"CORRECTIONS TO BE MADE AFTER next date (next step)"]
[]
[]
[]
[]
[null,"ALTERATIONS TO BE MADE AFTER       Next date  (next step)"]

{"sheet":"Cover","index":2,"n_rows":39,"n_cols":4,"rows_kept":39,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Review of rate peg methodology - Draft report Base Cost Change (BCC) options"]
[null,"How we calculated 3 of the options provided in our Review of rate peg methodology, Draft Report, June 2023"]
[null,"available here"]
[null,"MODELLER:",null,"Bee Thompson"]
[null,"email",null,"Bee_Thompson@ipart.nsw.gov.au"]
[]
[]
[null,"WHAT IS THE PURPOSE OF MODEL?"]
[null,"The Local Government Cost Index (LGCI) is a component of the rate peg.  Due to timing requirements, the LGCI (and rate peg) reflects change  in costs with a 2 yr lag."]
[null,"We are reviewing our rate peg methodology. Our draft decision is to replace the replace the LGCI with a forward-looking 3-factor Base Cost Change model (BCC)."]
[null,"We propose to replace the LGCI with a forward-looking Base Cost Change (BCC) with 3 components:"]
[null,"●","employee costs"]
[null,"●","asset costs"]
[null,"●","other operating costs"]
[null,"IPART, Review of the rate peg methodology Draft Report, June 2023"]
[]
[null,"This model calculates what the BCC would have been between 2016-17 and 2023-24 under different assumptions for changes in employee costs, asset costs and other operating costs,"]
[null,"as reported in Table 3.3 in our Draft report (p47). "]
[null,"Specifically, it calculates a BCC using, for the 3 cost categories respectively"]
[null,"●","Preferred BCC: Award increase (with RBA WPI forecasts in years when Award increases are unknown at the time we set the rate peg), PPI - adjusted CPI forecasts and RBA CPI forecasts."]
[null,"●","Option 1: Only RBA WPI forecasts, PPI - adjusted CPI forecasts and RBA CPI forecasts."]
[null,"●","Preferred BCC with true-ups: as for Preferred  BCC with  true-ups for all 3 components. "]
[]
[null,"The model calculates BCCs for"]
[null,"●","3 council groupings"]
[null,"●","NSW as a whole (single group)"]
[null,"The model also reproduces Figure 3.1 in the Draft Report (p30), which compares changes in CPI, LGCI and a our 'preferred' BCC over a number of years. "]
[]
[]
[null,"COLOUR CODE  <Required for all models/spreadsheets. See 'Examples' for the full list of potential colour codes>"]
[null,"This model uses standard IPART colour coding:"]
[null,"Blue cells indicate inputs"]
[null,"Blue font indicates IPART hard-coded values used that should not be changed"]
[null,"Key outputs"]
[null,"Pink font indicates calculation checks"]
[null,"Red indicates assumptions made in calculations"]
[null,"Red double line means formula changes across row"]

{"sheet":"Results","index":3,"n_rows":93,"n_cols":7,"rows_kept":93,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"Cover!$B$3","v":"Review of rate peg methodology - Draft report Base Cost Change (BCC) options"}]
[]
[null,"RESULTS"]
[]
[]
[null,"Table 1","BCC with alternative ways to measure changes in employee and asset cost "]
[null,null,"ΔLGCI in","ΔCPIa\n","Preferred BCC\n","Option 1\n","Preferred BCC "]
[null,null," rate peg",null,"Awardb","RBA WPI","with true-upd"]
[null,null,null,null,"PPIc\n","PPIc\n"]
[null,null,null,null,"CPI","CPI"]
[null,{"$f":"Inputs!$B$31","v":"Metropolitan"}]
[null,{"$f":"Inputs!C15","v":"2016-17"},{"$f":"Inputs!E15","v":1.78E-2},{"$f":"'ABS CPI'!N130","v":1.7082179132040354E-2},{"$f":"'BCC Preferred'!J34","v":2.8000000000000001E-2},{"$f":"'BCC Option 1 RBA WPI'!$J34","v":2.8000000000000001E-2},{"$f":"'BCC Preferred with true-up'!$J34","v":2.1000000000000001E-2}]
[null,{"$f":"Inputs!C16","v":"2017-18"},{"$f":"Inputs!E16","v":1.4681046807007325E-2},{"$f":"'ABS CPI'!N131","v":1.9291874716296009E-2},{"$f":"'BCC Preferred'!J35","v":2.5000000000000001E-2},{"$f":"'BCC Option 1 RBA WPI'!$J35","v":2.5000000000000001E-2},{"$f":"'BCC Preferred with true-up'!$J35","v":1.2E-2}]
[null,{"$f":"Inputs!C17","v":"2018-19"},{"$f":"Inputs!E17","v":2.2851007673318824E-2},{"$f":"'ABS CPI'!N132","v":1.6477399242930346E-2},{"$f":"'BCC Preferred'!J36","v":2.4E-2},{"$f":"'BCC Option 1 RBA WPI'!$J36","v":2.4E-2},{"$f":"'BCC Preferred with true-up'!$J36","v":1.4999999999999999E-2}]
[null,{"$f":"Inputs!C18","v":"2019-20"},{"$f":"Inputs!E18","v":2.6886639341236362E-2},{"$f":"'ABS CPI'!N133","v":1.3362541073384415E-2},{"$f":"'BCC Preferred'!J37","v":2.3E-2},{"$f":"'BCC Option 1 RBA WPI'!$J37","v":2.4E-2},{"$f":"'BCC Preferred with true-up'!$J37","v":2.1000000000000001E-2}]
[null,{"$f":"Inputs!C19","v":"2020-21"},{"$f":"Inputs!E19","v":2.5641145174779556E-2},{"$f":"'ABS CPI'!N134","v":1.6212710765239891E-2},{"$f":"'BCC Preferred'!J38","v":2.1000000000000001E-2},{"$f":"'BCC Option 1 RBA WPI'!$J38","v":2.1000000000000001E-2},{"$f":"'BCC Preferred with true-up'!$J38","v":2.1000000000000001E-2}]
[null,{"$f":"Inputs!C20","v":"2021-22"},{"$f":"Inputs!E20","v":1.7725351562649427E-2},{"$f":"'ABS CPI'!N135","v":4.4458625824292719E-2},{"$f":"'BCC Preferred'!J39","v":1.7000000000000001E-2},{"$f":"'BCC Option 1 RBA WPI'!$J39","v":1.4E-2},{"$f":"'BCC Preferred with true-up'!$J39","v":7.0000000000000001E-3}]
[null,{"$f":"Inputs!C21","v":"2022-23"},{"$f":"Inputs!E21","v":8.6806206492882065E-3},null,{"$f":"'BCC Preferred'!J40","v":2.1000000000000001E-2},{"$f":"'BCC Option 1 RBA WPI'!$J40","v":2.4E-2},{"$f":"'BCC Preferred with true-up'!$J40","v":1.9E-2}]
[null,{"$f":"Inputs!C22","v":"2023-24"},{"$f":"Inputs!E22","v":3.7000000000000005E-2},null,{"$f":"'BCC Preferred'!J41","v":4.1000000000000002E-2},{"$f":"'BCC Option 1 RBA WPI'!$J41","v":4.1000000000000002E-2},{"$f":"'BCC Preferred with true-up'!$J41","v":6.2E-2}]
[null,{"$f":"Inputs!$B$34","v":"Regional "}]
[null,{"$f":"B13","v":"2016-17"},1.78E-2,{"$f":"D13","v":1.7082179132040354E-2},{"$f":"'BCC Preferred'!J46","v":2.8000000000000001E-2},{"$f":"'BCC Option 1 RBA WPI'!$J46","v":2.8000000000000001E-2},{"$f":"'BCC Preferred with true-up'!$J46","v":2.1000000000000001E-2}]
[null,"2017-18",1.4681046807007325E-2,1.9291874716296009E-2,{"$f":"'BCC Preferred'!J47","v":2.5000000000000001E-2},{"$f":"'BCC Option 1 RBA WPI'!$J47","v":2.5000000000000001E-2},{"$f":"'BCC Preferred with true-up'!$J47","v":1.0999999999999999E-2}]
[null,"2018-19",2.2851007673318824E-2,1.6477399242930346E-2,{"$f":"'BCC Preferred'!J48","v":2.4E-2},{"$f":"'BCC Option 1 RBA WPI'!$J48","v":2.4E-2},{"$f":"'BCC Preferred with true-up'!$J48","v":1.4E-2}]
[null,"2019-20",2.6886639341236362E-2,1.3362541073384415E-2,{"$f":"'BCC Preferred'!J49","v":2.3E-2},{"$f":"'BCC Option 1 RBA WPI'!$J49","v":2.4E-2},{"$f":"'BCC Preferred with true-up'!$J49","v":2.1000000000000001E-2}]
[null,"2020-21",2.5641145174779556E-2,1.6212710765239891E-2,{"$f":"'BCC Preferred'!J50","v":2.1000000000000001E-2},{"$f":"'BCC Option 1 RBA WPI'!$J50","v":2.1000000000000001E-2},{"$f":"'BCC Preferred with true-up'!$J50","v":2.1999999999999999E-2}]
[null,"2021-22",1.7725351562649427E-2,4.4458625824292719E-2,{"$f":"'BCC Preferred'!J51","v":1.6E-2},{"$f":"'BCC Option 1 RBA WPI'!$J51","v":1.4E-2},{"$f":"'BCC Preferred with true-up'!$J51","v":7.0000000000000001E-3}]
[null,"2022-23",8.6806206492882065E-3,null,{"$f":"'BCC Preferred'!J52","v":2.1000000000000001E-2},{"$f":"'BCC Option 1 RBA WPI'!$J52","v":2.3E-2},{"$f":"'BCC Preferred with true-up'!$J52","v":1.7999999999999999E-2}]
[null,"2023-24",3.7000000000000005E-2,null,{"$f":"'BCC Preferred'!J53","v":4.1000000000000002E-2},{"$f":"'BCC Option 1 RBA WPI'!$J53","v":4.1000000000000002E-2},{"$f":"'BCC Preferred with true-up'!$J53","v":6.4000000000000001E-2}]
[null,{"$f":"Inputs!$B$35","v":"Rural"}]
[null,{"$f":"B22","v":"2016-17"},1.78E-2,{"$f":"D22","v":1.7082179132040354E-2},{"$f":"'BCC Preferred'!J58","v":2.8000000000000001E-2},{"$f":"'BCC Option 1 RBA WPI'!$J58","v":2.8000000000000001E-2},{"$f":"'BCC Preferred with true-up'!$J58","v":2.1000000000000001E-2}]
[null,"2017-18",1.4681046807007325E-2,1.9291874716296009E-2,{"$f":"'BCC Preferred'!J59","v":2.5000000000000001E-2},{"$f":"'BCC Option 1 RBA WPI'!$J59","v":2.5000000000000001E-2},{"$f":"'BCC Preferred with true-up'!$J59","v":1.0999999999999999E-2}]
[null,"2018-19",2.2851007673318824E-2,1.6477399242930346E-2,{"$f":"'BCC Preferred'!J60","v":2.4E-2},{"$f":"'BCC Option 1 RBA WPI'!$J60","v":2.4E-2},{"$f":"'BCC Preferred with true-up'!$J60","v":1.2999999999999999E-2}]
[null,"2019-20",2.6886639341236362E-2,1.3362541073384415E-2,{"$f":"'BCC Preferred'!J61","v":2.3E-2},{"$f":"'BCC Option 1 RBA WPI'!$J61","v":2.4E-2},{"$f":"'BCC Preferred with true-up'!$J61","v":2.1000000000000001E-2}]
[null,"2020-21",2.5641145174779556E-2,1.6212710765239891E-2,{"$f":"'BCC Preferred'!J62","v":2.1000000000000001E-2},{"$f":"'BCC Option 1 RBA WPI'!$J62","v":2.1000000000000001E-2},{"$f":"'BCC Preferred with true-up'!$J62","v":2.1999999999999999E-2}]
[null,"2021-22",1.7725351562649427E-2,4.4458625824292719E-2,{"$f":"'BCC Preferred'!J63","v":1.6E-2},{"$f":"'BCC Option 1 RBA WPI'!$J63","v":1.4E-2},{"$f":"'BCC Preferred with true-up'!$J63","v":7.0000000000000001E-3}]
[null,"2022-23",8.6806206492882065E-3,null,{"$f":"'BCC Preferred'!J64","v":2.1000000000000001E-2},{"$f":"'BCC Option 1 RBA WPI'!$J64","v":2.3E-2},{"$f":"'BCC Preferred with true-up'!$J64","v":1.7999999999999999E-2}]
[null,"2023-24",3.7000000000000005E-2,null,{"$f":"'BCC Preferred'!J65","v":4.2000000000000003E-2},{"$f":"'BCC Option 1 RBA WPI'!$J65","v":4.2000000000000003E-2},{"$f":"'BCC Preferred with true-up'!$J65","v":6.5000000000000002E-2}]
[]
[null,"NSW"]
[null,{"$f":"B13","v":"2016-17"},1.78E-2,{"$f":"D13","v":1.7082179132040354E-2},{"$f":"'BCC Preferred'!J74","v":2.8000000000000001E-2},{"$f":"'BCC Option 1 RBA WPI'!$J74","v":2.8000000000000001E-2},{"$f":"'BCC Preferred with true-up'!$J74","v":2.1000000000000001E-2}]
[null,"2017-18",1.4681046807007325E-2,1.9291874716296009E-2,{"$f":"'BCC Preferred'!J75","v":2.5000000000000001E-2},{"$f":"'BCC Option 1 RBA WPI'!$J75","v":2.5000000000000001E-2},{"$f":"'BCC Preferred with true-up'!$J75","v":1.2E-2}]
[null,"2018-19",2.2851007673318824E-2,1.6477399242930346E-2,{"$f":"'BCC Preferred'!J76","v":2.4E-2},{"$f":"'BCC Option 1 RBA WPI'!$J76","v":2.4E-2},{"$f":"'BCC Preferred with true-up'!$J76","v":1.4E-2}]
[null,"2019-20",2.6886639341236362E-2,1.3362541073384415E-2,{"$f":"'BCC Preferred'!J77","v":2.3E-2},{"$f":"'BCC Option 1 RBA WPI'!$J77","v":2.4E-2},{"$f":"'BCC Preferred with true-up'!$J77","v":2.1000000000000001E-2}]
[null,"2020-21",2.5641145174779556E-2,1.6212710765239891E-2,{"$f":"'BCC Preferred'!J78","v":2.1000000000000001E-2},{"$f":"'BCC Option 1 RBA WPI'!$J78","v":2.1000000000000001E-2},{"$f":"'BCC Preferred with true-up'!$J78","v":2.1000000000000001E-2}]
[null,"2021-22",1.7725351562649427E-2,4.4458625824292719E-2,{"$f":"'BCC Preferred'!J79","v":1.7000000000000001E-2},{"$f":"'BCC Option 1 RBA WPI'!$J79","v":1.4E-2},{"$f":"'BCC Preferred with true-up'!$J79","v":7.0000000000000001E-3}]
[null,"2022-23",8.6806206492882065E-3,null,{"$f":"'BCC Preferred'!J80","v":2.1000000000000001E-2},{"$f":"'BCC Option 1 RBA WPI'!$J80","v":2.3E-2},{"$f":"'BCC Preferred with true-up'!$J80","v":1.7999999999999999E-2}]
[null,"2023-24",3.7000000000000005E-2,null,{"$f":"'BCC Preferred'!J81","v":4.1000000000000002E-2},{"$f":"'BCC Option 1 RBA WPI'!$J81","v":4.1000000000000002E-2},{"$f":"'BCC Preferred with true-up'!$J81","v":6.3E-2}]
[null,"a Australian CPI, average of four quarters to June each year."]
[null,"b Award when know at the time we set the rate peg, otherwise RBA WPI forecast"]
[null,"c PPI adjusted ΔCPI forecast"]
[null,"d Preferred BCC with true-ups: for employee costs, true-up to the Award in the 2nd year of each Award period; "]
[null,"  for asset costs, true-up to actual ΔPPI (Road and bridge construction); for other costs, true-up to actual ΔCPI (Australia). "]
[]
[]
[]
[]
[]
[null,"Figure 1","Comparison of changes in the LGCI, draft BCC and measures of CPI"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Table 2","Comparison of ΔLGCI (without lag), actual and forecast ΔCPI and average BCC"]
[null,null,"ΔLGCI (without lag)","CPI Actual","CPI Forecast","Average BCC"]
[null,{"$f":"Inputs!C48","v":"2011-12"},{"$f":"Inputs!E12","v":3.6917898325247167E-2},{"$f":"'ABS CPI'!N125","v":2.3023791250959436E-2},{"$f":"Inputs!H48","v":2.8749999999999998E-2}]
[null,{"$f":"Inputs!C49","v":"2012-13"},{"$f":"Inputs!E13","v":2.8114063416978086E-2},{"$f":"'ABS CPI'!N126","v":2.2755688922230677E-2},{"$f":"Inputs!H49","v":3.6250000000000004E-2}]
[null,{"$f":"Inputs!C50","v":"2013-14"},{"$f":"Inputs!E14","v":2.4699048258998824E-2},{"$f":"'ABS CPI'!N127","v":2.7139364303178315E-2},{"$f":"Inputs!H50","v":2.5000000000000001E-2}]
[null,{"$f":"Inputs!C51","v":"2014-15"},{"$f":"Inputs!E15","v":1.78E-2},{"$f":"'ABS CPI'!N128","v":1.7138776481790075E-2},{"$f":"Inputs!H51","v":2.5000000000000001E-2}]
[null,{"$f":"Inputs!C52","v":"2015-16"},{"$f":"Inputs!E16","v":1.4681046807007325E-2},{"$f":"'ABS CPI'!N129","v":1.3807629300257585E-2},{"$f":"Inputs!H52","v":3.0000000000000002E-2}]
[null,{"$f":"Inputs!C53","v":"2016-17"},{"$f":"Inputs!E17","v":2.2851007673318824E-2},{"$f":"'ABS CPI'!N130","v":1.7082179132040354E-2},{"$f":"Inputs!H53","v":2.5000000000000001E-2}]
[null,{"$f":"Inputs!C54","v":"2017-18"},{"$f":"Inputs!E18","v":2.6886639341236362E-2},{"$f":"'ABS CPI'!N131","v":1.9291874716296009E-2},{"$f":"Inputs!H54","v":0.02}]
[null,{"$f":"Inputs!C55","v":"2018-19"},{"$f":"Inputs!E19","v":2.5641145174779556E-2},{"$f":"'ABS CPI'!N132","v":1.6477399242930346E-2},{"$f":"Inputs!H55","v":2.375E-2}]
[null,{"$f":"Inputs!C56","v":"2019-20"},{"$f":"Inputs!E20","v":1.7725351562649427E-2},{"$f":"'ABS CPI'!N133","v":1.3362541073384415E-2},{"$f":"Inputs!H56","v":2.2499999999999999E-2},{"$f":"'BCC Preferred'!J77","v":2.3E-2}]
[null,{"$f":"Inputs!C57","v":"2020-21"},{"$f":"Inputs!E21","v":8.6806206492882065E-3},{"$f":"'ABS CPI'!N134","v":1.6212710765239891E-2},{"$f":"Inputs!H57","v":1.95E-2},{"$f":"'BCC Preferred'!J78","v":2.1000000000000001E-2}]
[null,{"$f":"Inputs!C58","v":"2021-22"},{"$f":"Inputs!E22","v":3.7000000000000005E-2},{"$f":"'ABS CPI'!N135","v":4.4458625824292719E-2},{"$f":"Inputs!H58","v":1.125E-2},{"$f":"'BCC Preferred'!J79","v":1.7000000000000001E-2}]
[null,{"$f":"Inputs!C59","v":"2022-23"},null,null,{"$f":"Inputs!H59","v":1.8750000000000003E-2},{"$f":"'BCC Preferred'!J80","v":2.1000000000000001E-2}]
[null,{"$f":"Inputs!C60","v":"2023-24"},null,null,{"$f":"Inputs!H60","v":3.9E-2},{"$f":"'BCC Preferred'!J81","v":4.1000000000000002E-2}]

{"sheet":"Inputs","index":4,"n_rows":127,"n_cols":18,"rows_kept":127,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"Cover!$B$3","v":"Review of rate peg methodology - Draft report Base Cost Change (BCC) options"}]
[]
[null,"INPUTS"]
[]
[]
[1,{"$f":"\"Table \"&A7","v":"Table 1"},"Historical Rate Pegs (before population factor)"]
[null,null,"Year",null,null,"Change in LGCI",null,null,null,null,null,null,null,null,null,null,null,"Sources"]
[null,"Rate Peg for 1 July ","FY","Last data quarter","% change in annual average","Minus productivity adjustment","Plus Carbon tax adjustment","Plus other adjustments",null,"Rate Peg before population factor"]
[null,2011,{"$f":"B10&\"-\"&RIGHT(B10+1,2)","v":"2011-12"},"Sep-2010",3.00970460644856E-2,2E-3,0,0,null,{"$f":"E10+G10+H10-F10","v":2.8097046064485598E-2},null,null,null,null,null,null,null,"IPART information"]
[null,{"$f":"B10+1","v":2012},"2012-13","Sep-2011",3.3774819409069234E-2,2.2000000000000001E-3,4.0000000000000001E-3,0,null,3.5574819409069237E-2,null,null,null,null,null,null,null,"Rate peg also available here"]
[null,2013,"2013-14","Sep-2012",3.6917898325247167E-2,2E-3,-1E-3,0,null,3.3917898325247164E-2]
[null,2014,"2014-15","Sep-2013",2.8114063416978086E-2,2E-3,-3.0000000000000001E-3,0,null,2.3114063416978088E-2]
[null,2015,"2015-16","Sep-2014",2.4699048258998824E-2,4.0000000000000002E-4,0,0,null,2.4299048258998823E-2]
[null,2016,"2016-17","Sep-2015",1.78E-2,0,0,0,null,1.78E-2]
[null,2017,"2017-18","Sep-2016",1.4681046807007325E-2,1.3344097616441201E-5,0,0,null,1.4667702709390884E-2]
[null,2018,"2018-19","Sep-2017",2.2851007673318824E-2,0,0,0,null,2.2851007673318824E-2]
[null,2019,"2019-20","Jun-2018",2.6886639341236362E-2,0,0,0,null,2.6886639341236362E-2]
[null,2020,"2020-21","Jun-2019",2.5641145174779556E-2,0,0,0,null,2.5641145174779556E-2]
[null,2021,"2021-22","Jun-2020",1.7725351562649427E-2,0,0,1.9238386230476369E-3,null,1.9649190185697066E-2]
[null,2022,"2022-23","Jun-2021",8.6806206492882065E-3,0,0,-1.8867652145119346E-3,null,6.793855434776272E-3]
[null,2023,"2023-24","Jun-2022",{"$f":"3.5%+0.2%","v":3.7000000000000005E-2},0,0,0,null,3.7000000000000005E-2]
[]
[]
[]
[]
[{"$f":"A7+1","v":2},{"$f":"\"Table \"&A27","v":"Table 2"},"Weights (General Fund, 3-year average)"]
[]
[null,null,null,"Number of councils","Other (incl. materials and contracts)","Employee costs","Depreciation","Total","Check = 0",null,null,null,null,null,null,null,null,"Calculated from Financial data returns "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"provided to OLG (General Fund)"]
[null,"Metropolitan",null,null,0.41,0.41,0.18000000000000005,{"$f":"SUM(E31:G31)","v":1},{"$f":"H31-1","v":0},null,null,null,null,null,null,null,null,"3-year average 2019-20 to 2021-22"]
[null,"Metropolitan",null,null,0.41,0.41,0.18000000000000005,1,0]
[null,"Metropolitan fringe",null,null,0.4,0.41,0.18999999999999995,1,0]
[null,"Regional ",null,null,0.4,0.37,0.22999999999999998,1,0]
[null,"Rural",null,null,0.38,0.36,0.26,1,0]
[null,"Large rural",null,null,0.38,0.36,0.26,1,0]
[null,"Rural",null,null,0.37,0.38,0.25,1,0]
[null,"NSW",null,null,0.4,0.39,0.20999999999999996,{"$f":"SUM(E38:G38)","v":1},{"$f":"H38-1","v":0}]
[]
[]
[]
[]
[{"$f":"A27+1","v":3},{"$f":"\"Table \"&A43","v":"Table 3"},"CPI for BCC options (other costs)"]
[null,"BCC for 1 July ","BCC for FY","Report date for forecasts","Forecast to June"]
[null,null,null,null,null,null,null,null,null,null,"True-up"]
[null,null,null,null,null,"RBA CPI forecast",null,null,"Average of 4 quarters to June","Average of 4 quarters to June"]
[null,"CPI forecasts for the year the rate peg applies",null,null,null,"Forecast to December","Forecast to June","Average of Yr to Dec and Yr to June","Australia CPI, lagged actual","lagged PPI","True-up for actual CPI (lagged 2 yrs)","RBA CPI  forecast + CPI  true-up"]
[null,{"$f":"B10","v":2011},{"$f":"B48&\"-\"&RIGHT(B48,2)+1","v":"2011-12"},"Aug- 10",{"$f":"B48+1","v":2012},2.75E-2,0.03,{"$f":"AVERAGE(F48:G48)","v":2.8749999999999998E-2},{"$f":"'ABS CPI'!N123","v":2.3211875843454743E-2},{"$f":"'ABS PPI'!D119","v":-1.0479434110558516E-3}]
[null,2012,{"$f":"B49&\"-\"&RIGHT(B49,2)+1","v":"2012-13"},"Aug- 11",2013,3.5000000000000003E-2,3.7499999999999999E-2,{"$f":"AVERAGE(F49:G49)","v":3.6250000000000004E-2},{"$f":"'ABS CPI'!N124","v":3.1126351886045844E-2},{"$f":"'ABS PPI'!D120","v":2.8324154209284025E-2},null,null,null,null,null,null,null,"Actuals:"]
[null,2013,"2013-14","Aug- 12",2014,2.5000000000000001E-2,{"$f":"(2%+3%)/2","v":2.5000000000000001E-2},2.5000000000000001E-2,{"$f":"'ABS CPI'!N125","v":2.3023791250959436E-2},{"$f":"'ABS PPI'!D121","v":2.0147921448610218E-2},{"$f":"I50-$H48","v":-5.7262087490405622E-3},{"$f":"$H50+K50","v":1.9273791250959439E-2},null,null,null,null,null,"Calculated from ABS CPI data"]
[null,2014,"2014-15","Aug- 13",2015,2.5000000000000001E-2,{"$f":"(2%+3%)/2","v":2.5000000000000001E-2},2.5000000000000001E-2,{"$f":"'ABS CPI'!N126","v":2.2755688922230677E-2},{"$f":"'ABS PPI'!D122","v":1.2249999999999872E-2},{"$f":"I51-$H49","v":-1.3494311077769328E-2},1.1505688922230674E-2,null,null,null,null,null,"6401.0 Consumer Price Index, Australia"]
[null,2015,"2015-16","Aug- 14",2016,3.0000000000000002E-2,{"$f":"(2.5%+3.5%)/2","v":3.0000000000000002E-2},3.0000000000000002E-2,{"$f":"'ABS CPI'!N127","v":2.7139364303178315E-2},{"$f":"'ABS PPI'!D123","v":2.123981229933336E-2},2.1393643031783136E-3,3.2139364303178319E-2,null,null,null,null,null,"TABLES 1 and 2. CPI: All Groups, Index Numbers and Percentage Changes"]
[null,2016,"2016-17","Aug- 15",2017,2.5000000000000001E-2,{"$f":"(2%+3%)/2","v":2.5000000000000001E-2},2.5000000000000001E-2,{"$f":"'ABS CPI'!N128","v":1.7138776481790075E-2},{"$f":"'ABS PPI'!D124","v":9.9153567110035201E-3},-7.8612235182099269E-3,1.7138776481790075E-2]
[null,2017,"2017-18","Aug- 16",2018,0.02,{"$f":"(1.5%+2.5%)/2","v":0.02},0.02,{"$f":"'ABS CPI'!N129","v":1.3807629300257585E-2},{"$f":"'ABS PPI'!D125","v":1.4846743295019005E-2},-1.6192370699742418E-2,3.8076293002575826E-3]
[null,2018,"2018-19","Aug- 17",2019,2.2499999999999999E-2,2.5000000000000001E-2,2.375E-2,{"$f":"'ABS CPI'!N130","v":1.7082179132040354E-2},{"$f":"'ABS PPI'!D126","v":1.0382255781028915E-2},-7.9178208679596476E-3,1.5832179132040353E-2,null,null,null,null,null,"Forecasts:"]
[null,2019,"2019-20","Aug- 18",2020,2.2499999999999999E-2,2.2499999999999999E-2,2.2499999999999999E-2,{"$f":"'ABS CPI'!N131","v":1.9291874716296009E-2},{"$f":"'ABS PPI'!D127","v":1.6113965436711952E-2},-7.0812528370399128E-4,2.1791874716296008E-2,null,null,null,null,null,"All CPI  from RBA Statement on Monetary Policy"]
[null,2020,"2020-21","Aug- 19",2021,1.9E-2,0.02,1.95E-2,{"$f":"'ABS CPI'!N132","v":1.6477399242930346E-2},{"$f":"'ABS PPI'!D128","v":2.0225235578027911E-2},-7.2726007570696541E-3,1.2227399242930346E-2,null,null,null,null,null,"RBA Statement on Monetary Policy"]
[null,2021,"2021-22","Aug- 20",2022,0.01,1.2500000000000001E-2,1.125E-2,{"$f":"'ABS CPI'!N133","v":1.3362541073384415E-2},{"$f":"'ABS PPI'!D129","v":9.9121423744086279E-3},-9.137458926615584E-3,2.1125410733844156E-3,null,null,null,null,null,"Appendix: Forecasts (although some of the earlies ones may be in the chapter on Economic Outlook)"]
[null,2022,"2022-23","Aug- 21",2023,1.7500000000000002E-2,0.02,1.8750000000000003E-2,{"$f":"'ABS CPI'!N134","v":1.6212710765239891E-2},{"$f":"'ABS PPI'!D130","v":4.6843631496764626E-3},-3.2872892347601095E-3,1.5462710765239893E-2]
[null,2023,"2023-24","Aug- 22",2024,4.2999999999999997E-2,3.5000000000000003E-2,{"$f":"AVERAGE(F60:G60)","v":3.9E-2},{"$f":"'ABS CPI'!N135","v":4.4458625824292719E-2},{"$f":"'ABS PPI'!D131","v":4.2628774422735383E-2},3.3208625824292723E-2,7.2208625824292716E-2]
[]
[]
[]
[]
[]
[]
[{"$f":"A43+1","v":4},{"$f":"\"Table \"&A67","v":"Table 4"},"Labour costs for BCC options"]
[null,"WPI forecasts for the year the rate peg applies",null,null,null,null,null,null,null,null,"Superannuation guarantee",null,"Labour cost options"]
[null,null,null,null,null,null,null,null,null,null,null,null,"(including additional superannuation contributions)",null,null,null,null,"Actuals:"]
[null,{"$f":"B44","v":"BCC for 1 July "},{"$f":"C44","v":"BCC for FY"},"Report date for forecasts","Forecast to June","Forecast to December","Forecast to June",{"$f":"H47","v":"Average of Yr to Dec and Yr to June"},"Aust, Private and Public WPI, lagged actual","True-up for actual WPI","Actual super guarantee %","Increase in super included in costs","RBA forecast","RBA forecast + WPI  true-up","Award with RBA forecast when Award not available","Award with RBA forecast and true-up",null,"Calculated from  ABS WPI data"]
[null,{"$f":"B48","v":2011},"2011-12","NSW budget statement, June",{"$f":"B71+1","v":2012},{"$f":"G71","v":3.7499999999999999E-2},3.7499999999999999E-2,{"$f":"AVERAGE(F71:G71)","v":3.7499999999999999E-2},{"$f":"'ABS WPI'!P119","v":3.1249999999999778E-2},null,0.09,0,{"$f":"H71+L71","v":3.7499999999999999E-2},null,{"$f":"CHOOSE(O89,F89+L71,M71)","v":3.7499999999999999E-2},{"$f":"SUM(H89:I89)+L71","v":2.1499999999999998E-2},null,"6345.0 Wage Price Index, Australia"]
[null,2012,"2012-13",{"$f":"D71","v":"NSW budget statement, June"},2013,0.04,0.04,{"$f":"AVERAGE(F72:G72)","v":0.04},{"$f":"'ABS WPI'!P120","v":3.7818181818181973E-2},null,0.09,{"$f":"(K72-K71)","v":0},0.04,null,3.2500000000000001E-2,3.2500000000000001E-2,null,"Table 1. Total Hourly Rates of Pay Excluding Bonuses: Sector, Original, Seasonally Adjusted and Trend"]
[null,2013,"2013-14",{"$f":"D72","v":"NSW budget statement, June"},2014,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,{"$f":"'ABS WPI'!P121","v":3.620649380985741E-2},{"$f":"I73-$H71","v":-1.293506190142589E-3},9.2499999999999999E-2,2.5000000000000022E-3,3.7500000000000006E-2,{"$f":"M73+J73","v":3.6206493809857417E-2},3.5000000000000003E-2,3.5000000000000003E-2]
[null,2014,"2014-15","NSW budget statement, June",2015,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,{"$f":"'ABS WPI'!P122","v":3.313796212804343E-2},-6.8620378719565708E-3,9.5000000000000001E-2,2.5000000000000022E-3,3.7500000000000006E-2,3.0637962128043435E-2,3.7500000000000006E-2,3.7500000000000006E-2,null,"Forecasts:"]
[null,2015,"2015-16","NSW budget statement, June",2016,3.5000000000000003E-2,3.5000000000000003E-2,3.5000000000000003E-2,{"$f":"'ABS WPI'!P123","v":2.618372245254208E-2},-8.8162775474579236E-3,9.5000000000000001E-2,0,3.5000000000000003E-2,2.618372245254208E-2,2.7000000000000003E-2,1.8000000000000002E-2,null,"WPI from 2020 from RBA Statement on Monetary Policy"]
[null,2016,"2016-17","NSW budget statement, June",2017,2.75E-2,2.75E-2,2.75E-2,{"$f":"'ABS WPI'!P124","v":2.4027216670210461E-2},-1.0972783329789543E-2,9.5000000000000001E-2,0,2.75E-2,1.6527216670210457E-2,2.7999999999999997E-2,2.7999999999999997E-2,null,"RBA Statement on Monetary Policy"]
[null,2017,"2017-18","NSW budget statement, June",2018,2.75E-2,2.75E-2,2.75E-2,{"$f":"'ABS WPI'!P125","v":2.1179401993355551E-2},-1.3820598006644452E-2,9.5000000000000001E-2,0,2.75E-2,1.3679401993355548E-2,2.75E-2,2.75E-2,null,"Appendix: Forecasts (although some of the earlies ones may be in the chapter on Economic Outlook)"]
[null,2018,"2018-19","NSW budget statement, June",2019,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,{"$f":"'ABS WPI'!P126","v":1.9520130134200731E-2},-7.9798698657992696E-3,9.5000000000000001E-2,0,2.5000000000000001E-2,1.7020130134200732E-2,2.5000000000000001E-2,2.1000000000000001E-2]
[null,2019,"2019-20","NSW budget statement, June",2020,{"$f":"G79","v":2.75E-2},2.75E-2,2.75E-2,{"$f":"'ABS WPI'!P127","v":2.0542481053051453E-2},-6.9575189469485467E-3,9.5000000000000001E-2,0,2.75E-2,2.0542481053051453E-2,2.5000000000000001E-2,2.5000000000000001E-2,null,"WPI up to 2019"]
[null,2020,"2020-21",{"$f":"D57","v":"Aug- 19"},2021,2.3E-2,2.4E-2,2.35E-2,{"$f":"'ABS WPI'!P128","v":2.3255813953488413E-2},-1.744186046511588E-3,9.5000000000000001E-2,0,2.35E-2,2.1755813953488412E-2,2.35E-2,2.35E-2,null,"\" NSW economic performance and outlook\", usually ch 2 or 3 depending in year"]
[null,2021,"2021-22",{"$f":"D58","v":"Aug- 20"},2022,1.2500000000000001E-2,1.4999999999999999E-2,1.375E-2,{"$f":"'ABS WPI'!P129","v":2.1008403361344463E-2},-6.491596638655537E-3,{"$f":"K80+0.5%","v":0.1},5.0000000000000044E-3,1.8750000000000003E-2,1.2258403361344466E-2,2.5000000000000005E-2,1.6500000000000004E-2,null,"NSW Budget statement, published June"]
[null,2022,"2022-23",{"$f":"D59","v":"Aug- 21"},2023,2.5000000000000001E-2,2.5000000000000001E-2,2.5000000000000001E-2,{"$f":"'ABS WPI'!P130","v":1.5151515151515138E-2},-8.348484848484862E-3,{"$f":"K81+0.5%","v":0.10500000000000001},5.0000000000000044E-3,3.0000000000000006E-2,2.1651515151515144E-2,2.5000000000000005E-2,2.5000000000000005E-2,null,"https://www.budget.nsw.gov.au/budget-archives"]
[null,2023,"2023-24",{"$f":"D60","v":"Aug- 22"},2024,3.5999999999999997E-2,3.7999999999999999E-2,3.6999999999999998E-2,{"$f":"'ABS WPI'!P131","v":2.3770038695411833E-2},1.0020038695411832E-2,{"$f":"K82+0.5%","v":0.11000000000000001},5.0000000000000044E-3,4.2000000000000003E-2,5.2020038695411837E-2,4.2000000000000003E-2,4.2000000000000003E-2,null,"Super guarantee percentage:"]
[]
[null,"NSW Local Government  Award  increases "]
[null,"Note: The Award is set for a 3 yr period. Every 3rd year, the final outcome is know too late to include in the rate peg. ",null,null,null,null,null,null,null,null,null,null,null,null,"Labour cost "]
[null,"Therefore, we do a true-up in the 2nd year of each Award period (difference between previous and current award)",null,null,null,null,null,null,null,null,null,null,null,null,"1=Award"]
[null,null,null,null,null,"Award rate, no lag","Award rate known? ","Award & RBA forecast","True-up ",null,null,null,null,null,"2 = RBA forecast",null,null," Award"]
[null,{"$f":"B48","v":2011},"2011-12",null,null,2.1499999999999998E-2,"No",{"$f":"F89","v":2.1499999999999998E-2},0,null,"Yes",null,null,null,{"$f":"IF(G89=$K$90,2,1)","v":2}]
[null,2012,"2012-13",null,null,3.2500000000000001E-2,"Yes",{"$f":"F90","v":3.2500000000000001E-2},{"$f":"F89-H89","v":0},null,"No",null,null,null,1]
[null,2013,"2013-14",null,null,3.2500000000000001E-2,"Yes",{"$f":"F91","v":3.2500000000000001E-2},0,null,null,null,null,null,1]
[null,2014,"2014-15",null,null,2.6000000000000002E-2,"No",{"$f":"H74","v":3.5000000000000003E-2},0,null,null,null,null,null,2]
[null,2015,"2015-16",null,null,2.7000000000000003E-2,"Yes",{"$f":"F93","v":2.7000000000000003E-2},{"$f":"F92-H92","v":-9.0000000000000011E-3},null,null,null,null,null,1]
[null,2016,"2016-17",null,null,2.7999999999999997E-2,"Yes",{"$f":"F94","v":2.7999999999999997E-2},0,null,null,null,null,null,1,null,null,"Superannuation guarantee"]
[null,2017,"2017-18",null,null,2.35E-2,"No",{"$f":"H77","v":2.75E-2},0,null,null,null,null,null,2,null,null,"https://www.ato.gov.au/rates/key-superannuation-rates-and-thresholds/?anchor=Superguaranteepercentage#Superguaranteepercentage"]
[null,2018,"2018-19",null,null,2.5000000000000001E-2,"Yes",{"$f":"F96","v":2.5000000000000001E-2},-4.0000000000000001E-3,null,null,null,null,null,1]
[null,2019,"2019-20",null,null,2.5000000000000001E-2,"Yes",{"$f":"F97","v":2.5000000000000001E-2},0,null,null,null,null,null,1]
[null,2020,"2020-21",null,null,1.4999999999999999E-2,"No",{"$f":"H80","v":2.35E-2},0,null,null,null,null,null,2]
[null,2021,"2021-22",null,null,0.02,"Yes",{"$f":"F99","v":0.02},{"$f":"F98-H98","v":-8.5000000000000006E-3},null,null,null,null,null,1]
[null,2022,"2022-23",null,null,0.02,"Yes",{"$f":"F100","v":0.02},0,null,null,null,null,null,1]
[null,2023,"2023-24",null,null,null,"No",{"$f":"H83","v":3.6999999999999998E-2},0,null,null,null,null,null,2]
[]
[]
[]
[]
[]
[{"$f":"A67+1","v":5},{"$f":"\"Table \"&A107","v":"Table 5"},"PPI for asset costs"]
[null,null,null,null,null,null,"PPI and PPI premiums",null,null,"Asset costs factor with true-up"]
[null,{"$f":"B44","v":"BCC for 1 July "},{"$f":"C44","v":"BCC for FY"},null,null,null," Road and bridge construction New South Wales (lagged)","PPI premium over CPI (lagged)","PPI  premium, average over past 5 yrs (lagged)","'Forecast PPI' = Forecast CPI + 5 yr PPI premium","Actual PPI ( not lagged)","True-up to be applied 2 yrs later","Asset cost increaset = True-upt-2 + 5 yr premiumt  + CPI forecastt ","check = 0"]
[null,{"$f":"B111-1","v":2006},null,null,null,null,{"$f":"'PPI T17'!AV111","v":4.4822793606671407E-2},{"$f":"G110-'ABS CPI'!M118","v":1.9962632015621207E-2},"na",null,null,null,null,"na"]
[null,2007,null,null,null,null,{"$f":"'PPI T17'!AV112","v":4.8220818091120776E-2},{"$f":"G111-'ABS CPI'!M119","v":1.820262524697247E-2},"na",null,null,null,null,"na"]
[null,2008,null,null,null,null,{"$f":"'PPI T17'!AV113","v":4.6002538071065802E-2},{"$f":"G112-'ABS CPI'!M120","v":1.8625440632149326E-2},"na",null,null,null,null,"na"]
[null,{"$f":"B114-1","v":2009},null,null,null,null,{"$f":"'PPI T17'!AV114","v":4.4889293296936694E-2},{"$f":"G113-'ABS CPI'!M121","v":1.5089866362839377E-2},"na",null,null,null,null,"na"]
[null,{"$f":"B115-1","v":2010},null,null,null,null,{"$f":"'PPI T17'!AV115","v":4.00580551523948E-2},{"$f":"G114-'ABS CPI'!M122","v":9.173247139039109E-3},{"$f":"AVERAGE($H110:$H114)","v":1.6210762279324296E-2},null,null,null,null,"na"]
[null,{"$f":"B48","v":2011},"2011-12",null,null,null,{"$f":"'PPI T17'!AV116","v":2.5955902874686076E-2},{"$f":"G115-'ABS CPI'!M123","v":2.7440270312313331E-3},1.2767041282446323E-2,null,null,null,null,{"$f":"G115-'ABS CPI'!M123-H115","v":0}]
[null,2012,"2012-13",null,null,null,{"$f":"'PPI T17'!AV117","v":2.6115342763873617E-2},{"$f":"G116-'ABS CPI'!M124","v":-3.692095906661752E-3},8.3880970517194783E-3,null,null,null,null,{"$f":"G116-'ABS CPI'!M124-H116","v":0}]
[null,2013,"2013-14",null,null,null,{"$f":"'PPI T17'!AV118","v":6.0710498409331848E-2},{"$f":"G117-'ABS CPI'!M125","v":3.5864186933921793E-2},1.1835846312073971E-2,{"$f":"H50+I117","v":3.6835846312073969E-2},{"$f":"G119","v":3.0412744388124358E-2},{"$f":"K117-J117","v":-6.4231019239496118E-3},null,{"$f":"G117-'ABS CPI'!M125-H117","v":0}]
[null,2014,"2014-15",null,null,null,{"$f":"'PPI T17'!AV119","v":3.5491127218195473E-2},{"$f":"G118-'ABS CPI'!M126","v":9.9975006248440579E-3},1.0817373164474908E-2,3.5817373164474905E-2,1.8037011009604198E-2,{"$f":"K118-J118","v":-1.7780362154870707E-2},null,{"$f":"G118-'ABS CPI'!M126-H118","v":0}]
[null,2015,"2015-16",null,null,null,{"$f":"'PPI T17'!AV120","v":3.0412744388124358E-2},{"$f":"G119-'ABS CPI'!M127","v":4.5779893308490749E-3},9.8983216028369018E-3,3.9898321602836906E-2,8.5135757017946734E-3,{"$f":"K119-J119","v":-3.1384745901042232E-2},{"$f":"L117+I119+H52","v":3.3475219678887294E-2},{"$f":"G119-'ABS CPI'!M127-H119","v":0}]
[null,2016,"2016-17",null,null,null,{"$f":"'PPI T17'!AV121","v":1.8037011009604198E-2},{"$f":"G120-'ABS CPI'!M128","v":-1.2074651129903025E-3},9.1080231739925736E-3,3.4108023173992572E-2,9.3543235227013799E-3,-2.4753699651291192E-2,1.6327661019121868E-2,{"$f":"G120-'ABS CPI'!M128-H120","v":0}]
[null,2017,"2017-18",null,null,null,{"$f":"'PPI T17'!AV122","v":8.5135757017946734E-3},{"$f":"G121-'ABS CPI'!M129","v":-6.6379394497204647E-3},{"$f":"AVERAGE($H117:$H121)","v":8.5188544653808321E-3},2.8518854465380834E-2,2.1247739602169968E-2,-7.271114863210866E-3,-2.8658914356614017E-3,{"$f":"G121-'ABS CPI'!M129-H121","v":0}]
[null,2018,"2018-19",null,null,null,{"$f":"'PPI T17'!AV123","v":9.3543235227013799E-3},{"$f":"G122-'ABS CPI'!M130","v":-1.08523354899277E-2},-8.2445001938906697E-4,2.2925549980610933E-2,3.7627268702965733E-2,1.47017187223548E-2,-1.828149670680259E-3,{"$f":"G122-'ABS CPI'!M130-H122","v":0}]
[null,2019,"2019-20",null,null,null,{"$f":"'PPI T17'!AV124","v":2.1247739602169968E-2},{"$f":"G123-'ABS CPI'!M131","v":7.660830637949978E-4},-2.6707335315988789E-3,1.9829266468401122E-2,7.4658703071672772E-3,{"$f":"K123-J123","v":-1.2363396161233844E-2},1.2558151605190254E-2,{"$f":"G123-'ABS CPI'!M131-H123","v":0}]
[null,2020,"2020-21",null,null,null,{"$f":"'PPI T17'!AV125","v":3.7627268702965733E-2},{"$f":"G124-'ABS CPI'!M132","v":2.1085583656649032E-2},6.3078533356111246E-4,2.0130785333561111E-2,1.1433410967605084E-2,-8.6973743659560267E-3,3.4832504055915911E-2,{"$f":"G124-'ABS CPI'!M132-H124","v":0}]
[null,2021,"2021-22",null,null,null,{"$f":"'PPI T17'!AV126","v":7.4658703071672772E-3},{"$f":"G125-'ABS CPI'!M133","v":-2.9485362886236821E-3},2.8257109843443651E-4,1.1532571098434436E-2,5.2334100900146563E-2,{"$f":"K125-J125","v":4.080152980171213E-2},-8.3082506279940835E-4,{"$f":"G125-'ABS CPI'!M133-H125","v":0}]
[null,2022,"2022-23",null,null,null,{"$f":"'PPI T17'!AV127","v":1.1433410967605084E-2},{"$f":"G126-'ABS CPI'!M134","v":-3.5977249568099889E-3},8.9061399701653168E-4,1.9640613997016533E-2,null,null,1.0943239631060508E-2,{"$f":"G126-'ABS CPI'!M134-H126","v":0}]
[null,2023,"2023-24",null,null,null,{"$f":"'PPI T17'!AV128","v":5.2334100900146563E-2},{"$f":"G127-'ABS CPI'!M135","v":1.3197227618995777E-2},5.7005266188012273E-3,4.470052661880123E-2,null,null,8.5502056420513367E-2,{"$f":"G127-'ABS CPI'!M135-H127","v":0}]

{"sheet":"ABS CPI","index":5,"n_rows":135,"n_cols":14,"rows_kept":135,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Source:","https://www.abs.gov.au/statistics/economy/price-indexes-and-inflation/consumer-price-index-australia/sep-quarter-2022#data-downloads"]
[]
[null,"Time Series Workbook"]
[]
[]
[null,"6401.0 Consumer Price Index, Australia"]
[null,"TABLES 1 and 2. CPI: All Groups, Index Numbers and Percentage Changes"]
[]
[null,null,"Index Numbers ;  All groups CPI ;  Sydney ;","Index Numbers ;  All groups CPI ;  Melbourne ;","Index Numbers ;  All groups CPI ;  Brisbane ;","Index Numbers ;  All groups CPI ;  Adelaide ;","Index Numbers ;  All groups CPI ;  Perth ;","Index Numbers ;  All groups CPI ;  Hobart ;","Index Numbers ;  All groups CPI ;  Darwin ;","Index Numbers ;  All groups CPI ;  Canberra ;","Index Numbers ;  All groups CPI ;  Australia ;",null,"Sydney","Australia"]
[null,"Unit","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers"]
[null,"Series Type","Original","Original","Original","Original","Original","Original","Original","Original","Original"]
[null,"Data Type","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX"]
[null,"Frequency","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter"]
[null,"Collection Month",3,3,3,3,3,3,3,3,3]
[null,"Series Start","1948-09-01","1948-09-01","1948-09-01","1948-09-01","1948-09-01","1948-09-01","1980-09-01","1948-09-01","1948-09-01"]
[null,"Series End","2022-09-01","2022-09-01","2022-09-01","2022-09-01","2022-09-01","2022-09-01","2022-09-01","2022-09-01","2022-09-01"]
[null,"No. Obs",297,297,297,297,297,297,169,297,297]
[null,"Series ID","A2325806K","A2325811C","A2325816R","A2325821J","A2325826V","A2325831L","A2325836X","A2325841T","A2325846C"]
[]
[null,"2000-06-01",70.900000000000006,70.900000000000006,68.3,69.5,69.099999999999994,71,71.099999999999994,69.900000000000006,70.2]
[null,"2000-09-01",73.5,73.599999999999994,71,72.099999999999994,71.599999999999994,73.7,73.5,72.5,72.900000000000006]
[null,"2000-12-01",73.8,73.900000000000006,71.2,72.2,71.8,73.7,73.900000000000006,72.8,73.099999999999994]
[null,"2001-03-01",74.8,74.7,71.8,73,72.2,74.2,73.900000000000006,73.3,73.900000000000006]
[null,"2001-06-01",75.400000000000006,75.099999999999994,72.5,73.599999999999994,73.2,74.900000000000006,74.7,74,74.5]
[null,"2001-09-01",75.599999999999994,75.5,72.599999999999994,73.7,73.3,74.599999999999994,74.900000000000006,74,74.7]
[null,"2001-12-01",76.3,76.099999999999994,73.5,74.400000000000006,73.900000000000006,75.2,75.5,74.900000000000006,75.400000000000006]
[null,"2002-03-01",77,76.900000000000006,74.2,75,74.5,75.900000000000006,75.7,75.3,76.099999999999994]
[null,"2002-06-01",77.5,77.3,74.7,75.7,75,76.900000000000006,76.3,76.2,76.599999999999994]
[null,"2002-09-01",77.900000000000006,77.900000000000006,75.3,76.400000000000006,75.7,77.2,76.599999999999994,76.599999999999994,77.099999999999994]
[null,"2002-12-01",78.400000000000006,78.5,75.7,77.099999999999994,76,77.5,77,77.3,77.599999999999994]
[null,"2003-03-01",79.400000000000006,79.599999999999994,76.7,78.7,76.599999999999994,78.599999999999994,77.7,78.099999999999994,78.599999999999994]
[null,"2003-06-01",79.400000000000006,79.599999999999994,76.7,78.599999999999994,76.5,79.099999999999994,78,78.099999999999994,78.599999999999994]
[null,"2003-09-01",79.5,80.099999999999994,77.5,79.2,77.2,79.2,77.900000000000006,78.8,79.099999999999994]
[null,"2003-12-01",80.2,80.3,78,79.599999999999994,77.5,79.7,78.3,79.3,79.5]
[null,"2004-03-01",80.900000000000006,81.099999999999994,78.7,80.400000000000006,77.8,80.3,78.599999999999994,79.900000000000006,80.2]
[null,"2004-06-01",81.2,81.3,79.099999999999994,80.900000000000006,78.599999999999994,81,78.900000000000006,80.400000000000006,80.599999999999994,null,{"$f":"AVERAGE(C34:C37)/AVERAGE(C30:C33)-1","v":2.1263091082196039E-2},{"$f":"AVERAGE(K34:K37)/AVERAGE(K30:K33)-1","v":2.4046168643796051E-2}]
[null,"2004-09-01",81.599999999999994,81.5,79.400000000000006,81.2,79.099999999999994,81.400000000000006,79.599999999999994,80.8,80.900000000000006]
[null,"2004-12-01",82.3,82.1,80,81.7,79.8,82.4,79.8,81.2,81.5]
[null,"2005-03-01",82.7,82.7,80.7,82.2,80.400000000000006,83.1,80.2,81.599999999999994,82.1]
[null,"2005-06-01",83.2,83,81.099999999999994,82.7,81.5,83.5,80.900000000000006,82.1,82.6,null,{"$f":"AVERAGE(C38:C41)/AVERAGE(C34:C37)-1","v":2.4860161591050201E-2},{"$f":"AVERAGE(K38:K41)/AVERAGE(K34:K37)-1","v":2.4107701941139759E-2}]
[null,"2005-09-01",84,83.9,81.599999999999994,83.6,82.4,84.3,81.8,83.1,83.4]
[null,"2005-12-01",84.3,84.3,82.3,83.9,83,84.8,82.2,83.7,83.8]
[null,"2006-03-01",85,85,83,84.7,83.8,85.4,82.9,84.5,84.5]
[null,"2006-06-01",86.4,86.2,84.5,85.8,85.4,86.4,84.4,86,85.9,null,{"$f":"AVERAGE(C42:C45)/AVERAGE(C38:C41)-1","v":3.0018192844148306E-2},{"$f":"AVERAGE(K42:K45)/AVERAGE(K38:K41)-1","v":3.2100275145215518E-2}]
[null,"2006-09-01",87.2,86.8,85.2,86.8,86.3,87.1,85.8,86.6,86.7]
[null,"2006-12-01",87,86.7,85.1,86.5,86.6,86.8,86.3,86.4,86.6]
[null,"2007-03-01",86.9,86.9,85.5,86.3,86.8,87.3,86.3,86.5,86.6]
[null,"2007-06-01",87.9,87.9,86.7,87.3,88,88.4,87.5,87.7,87.7,null,{"$f":"AVERAGE(C46:C49)/AVERAGE(C42:C45)-1","v":2.7377097438916476E-2},{"$f":"AVERAGE(K46:K49)/AVERAGE(K42:K45)-1","v":2.962085308056861E-2}]
[null,"2007-09-01",88.3,88.6,87.5,88,88.6,88.6,88.5,88.4,88.3]
[null,"2007-12-01",89.1,89.5,88.4,88.9,89.3,89.4,88.8,89.2,89.1]
[null,"2008-03-01",90.3,90.7,89.6,90.1,90.5,90.5,89.6,90.5,90.3]
[null,"2008-06-01",91.7,91.8,91.1,91.3,92,91.5,90.9,91.6,91.6,null,{"$f":"AVERAGE(C50:C53)/AVERAGE(C46:C49)-1","v":2.9799426934097317E-2},{"$f":"AVERAGE(K50:K53)/AVERAGE(K46:K49)-1","v":3.3659378596087475E-2}]
[null,"2008-09-01",92.7,92.9,92.4,92.5,92.9,92.5,92.5,93,92.7]
[null,"2008-12-01",92.4,92.3,92.2,92.2,92.6,92.3,92.1,92.6,92.4]
[null,"2009-03-01",92.5,92.6,92.4,92.2,92.5,92.5,92.2,92.9,92.5]
[null,"2009-06-01",92.9,92.9,92.9,92.7,93.3,93,93.2,93.5,92.9,null,{"$f":"AVERAGE(C54:C57)/AVERAGE(C50:C53)-1","v":3.0884808013355691E-2},{"$f":"AVERAGE(K54:K57)/AVERAGE(K50:K53)-1","v":3.1171722794322454E-2}]
[null,"2009-09-01",93.9,93.4,94.2,93.7,94,94.1,95,94.3,93.8]
[null,"2009-12-01",94.4,94,94.5,94.1,94.5,94.7,94.9,94.7,94.3]
[null,"2010-03-01",95.2,95.2,95.2,94.6,95.6,95.4,95.4,95.3,95.2]
[null,"2010-06-01",95.6,95.8,95.9,95.3,96.5,95.8,96.2,95.6,95.8,null,{"$f":"AVERAGE(C58:C61)/AVERAGE(C54:C57)-1","v":2.3211875843454743E-2},{"$f":"AVERAGE(K58:K61)/AVERAGE(K54:K57)-1","v":2.3211875843454743E-2}]
[null,"2010-09-01",96.3,96.3,96.9,96.2,96.9,96.8,97.2,96.3,96.5]
[null,"2010-12-01",96.7,96.9,97.4,96.5,97,96.9,97.1,96.7,96.9]
[null,"2011-03-01",98.2,98.5,98.6,98.1,98.1,98.2,98.2,98.1,98.3]
[null,"2011-06-01",99.2,99.2,99.6,99,99.4,99.1,99.2,99.2,99.2,null,{"$f":"AVERAGE(C62:C65)/AVERAGE(C58:C61)-1","v":2.9807438670535369E-2},{"$f":"AVERAGE(K62:K65)/AVERAGE(K58:K61)-1","v":3.1126351886045844E-2}]
[null,"2011-09-01",99.9,99.8,99.9,100,99.6,99.9,99.9,99.8,99.8]
[null,"2011-12-01",99.8,99.9,99.7,100,99.8,100,99.5,100.1,99.8]
[null,"2012-03-01",99.9,99.9,99.9,99.9,100,100.3,99.9,99.7,99.9]
[null,"2012-06-01",100.5,100.4,100.5,100.2,100.5,99.9,100.7,100.3,100.4,null,{"$f":"AVERAGE(C66:C69)/AVERAGE(C62:C65)-1","v":2.4846311475410054E-2},{"$f":"AVERAGE(K66:K69)/AVERAGE(K62:K65)-1","v":2.3023791250959436E-2}]
[null,"2012-09-01",102.2,101.6,101.6,101.7,101.6,100.6,102,101.4,101.8]
[null,"2012-12-01",102.3,102,101.9,102.1,101.9,101,102,101.8,102]
[null,"2013-03-01",102.7,102.4,102,102.1,102.4,101.3,103.7,101.9,102.4]
[null,"2013-06-01",103.1,102.6,102.5,102.3,103,101.7,104.6,102.5,102.8,null,{"$f":"AVERAGE(C70:C73)/AVERAGE(C66:C69)-1","v":2.5493626593351415E-2},{"$f":"AVERAGE(K70:K73)/AVERAGE(K66:K69)-1","v":2.2755688922230677E-2}]
[null,"2013-09-01",104.3,104,103.8,103.7,104.2,102.6,105.5,103.1,104]
[null,"2013-12-01",105,104.8,104.6,104.4,104.9,103.6,106.5,104.1,104.8]
[null,"2014-03-01",105.6,105.3,105.2,105.1,105.6,104.1,107.4,104.6,105.4]
[null,"2014-06-01",106,105.9,105.8,105.5,106.4,104.5,108.1,104.8,105.9,null,{"$f":"AVERAGE(C74:C77)/AVERAGE(C70:C73)-1","v":2.5834755057275283E-2},{"$f":"AVERAGE(K74:K77)/AVERAGE(K70:K73)-1","v":2.7139364303178315E-2}]
[null,"2014-09-01",106.6,106.1,106.5,105.9,106.9,104.6,108.3,105.2,106.4]
[null,"2014-12-01",106.8,106.3,106.7,106.2,107,104.7,108.5,105.3,106.6]
[null,"2015-03-01",107.3,106.4,106.7,106.3,107.1,105,108.3,105.2,106.8]
[null,"2015-06-01",108.3,107.1,107.4,106.8,107.7,105.1,108.3,105.6,107.5,null,{"$f":"AVERAGE(C78:C81)/AVERAGE(C74:C77)-1","v":1.92444761225945E-2},{"$f":"AVERAGE(K78:K81)/AVERAGE(K74:K77)-1","v":1.7138776481790075E-2}]
[null,"2015-09-01",108.6,107.6,108.1,107.1,108.1,105.7,108.7,105.8,108]
[null,"2015-12-01",108.9,108.3,108.5,107.3,108.6,106.6,109,106,108.4]
[null,"2016-03-01",108.7,108.2,108.5,107,107.9,106.4,108,106.2,108.2]
[null,"2016-06-01",109.3,108.6,109,107.5,108.2,106.4,108.3,106.4,108.6,null,{"$f":"AVERAGE(C82:C85)/AVERAGE(C78:C81)-1","v":1.5151515151515138E-2},{"$f":"AVERAGE(K82:K85)/AVERAGE(K78:K81)-1","v":1.3807629300257585E-2}]
[null,"2016-09-01",110.4,109.1,109.7,108.4,108.6,107.1,108.7,107.3,109.4]
[null,"2016-12-01",110.9,109.9,110.2,108.7,109,108,108.6,107.9,110]
[null,"2017-03-01",111.3,110.9,110.5,109.1,109,108.9,108.5,108.6,110.5]
[null,"2017-06-01",111.7,111,111,109.2,109,108.9,108.8,108.6,110.7,null,{"$f":"AVERAGE(C86:C89)/AVERAGE(C82:C85)-1","v":2.020665901262908E-2},{"$f":"AVERAGE(K86:K89)/AVERAGE(K82:K85)-1","v":1.7082179132040354E-2}]
[null,"2017-09-01",112.5,111.5,111.4,110.4,109.5,109.2,109.4,109.6,111.4]
[null,"2017-12-01",113.3,112.3,112.3,111.2,109.9,110.3,109.7,110.3,112.1]
[null,"2018-03-01",113.6,113.3,112.4,111.6,110,111.1,109.7,111.2,112.6]
[null,"2018-06-01",114,113.8,112.9,112.1,110.2,111.5,110.1,111.6,113,null,{"$f":"AVERAGE(C90:C93)/AVERAGE(C86:C89)-1","v":2.048165653837497E-2},{"$f":"AVERAGE(K90:K93)/AVERAGE(K86:K89)-1","v":1.9291874716296009E-2}]
[null,"2018-09-01",114.7,114,113.4,112.4,110.8,112.2,110.8,112.3,113.5]
[null,"2018-12-01",115.2,114.6,114,113,111.3,113.6,111,113.1,114.1]
[null,"2019-03-01",115.1,114.7,114.1,113.1,111.2,113.4,110.1,113.2,114.1]
[null,"2019-06-01",115.9,115.3,114.8,113.7,112,114.1,111,113.5,114.8,null,{"$f":"AVERAGE(C94:C97)/AVERAGE(C90:C93)-1","v":1.6541685046316701E-2},{"$f":"AVERAGE(K94:K97)/AVERAGE(K90:K93)-1","v":1.6477399242930346E-2}]
[null,"2019-09-01",116.5,115.9,115.5,114.5,112.6,114.7,111.3,114.3,115.4]
[null,"2019-12-01",117.1,116.9,116.3,115.4,113.1,116.7,111.5,115,116.2]
[null,"2020-03-01",117.4,117.8,116.2,115.8,113.5,117.2,111.8,115.5,116.6]
[null,"2020-06-01",114.7,115.7,113.6,114.6,112.1,115.6,109,112.8,114.4,null,{"$f":"AVERAGE(C98:C101)/AVERAGE(C94:C97)-1","v":1.0414406595790959E-2},{"$f":"AVERAGE(K98:K101)/AVERAGE(K94:K97)-1","v":1.3362541073384415E-2}]
[null,"2020-09-01",116.8,116.7,116.2,115.7,114.1,116.7,110.8,115.4,116.2]
[null,"2020-12-01",118,118.4,117.5,116.5,113,117.6,111.5,116.3,117.2]
[null,"2021-03-01",118.5,118.8,118.2,117.2,114.6,118.5,114.4,117.3,117.9]
[null,"2021-06-01",119.4,119.1,119.2,117.8,116.8,119.8,115.6,118.2,118.8,null,{"$f":"AVERAGE(C102:C105)/AVERAGE(C98:C101)-1","v":1.5031135924415073E-2},{"$f":"AVERAGE(K102:K105)/AVERAGE(K98:K101)-1","v":1.6212710765239891E-2}]
[null,"2021-09-01",120.2,120.1,120.7,118.6,117.7,120.2,117.3,119.7,119.7]
[null,"2021-12-01",121.6,121.4,122.6,120.4,119.4,122.9,118.2,120.9,121.3]
[null,"2022-03-01",123.7,124.2,125.3,122.7,123.3,125.4,120.7,123.6,123.9]
[null,"2022-06-01",125.7,126.4,127.9,125.3,125.4,127.6,123.2,125.6,126.1,null,{"$f":"AVERAGE(C106:C109)/AVERAGE(C102:C105)-1","v":3.9136873281150786E-2},{"$f":"AVERAGE(K106:K109)/AVERAGE(K102:K105)-1","v":4.4458625824292719E-2}]
[null,"2022-09-01",128.6,129,130.19999999999999,128.6,124.8,130.5,125.5,128,128.4]
[null,"2022-12-01",130.9,131.1,132.1,130.80000000000001,129.30000000000001,132.4,126.6,129.5,130.80000000000001]
[null,"2023-03-01",132.69999999999999,132.69999999999999,134.6,132.4,130.4,134,128.19999999999999,131.30000000000001,132.6]
[]
[]
[]
[null,"Inflation, average of 4 quarters to June"]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M10","v":"Sydney"},"Australia"]
[null,{"$f":"B41","v":"2005-06-01"},null,null,null,null,null,null,null,null,null,null,{"$f":"M41","v":2.4860161591050201E-2},{"$f":"N41","v":2.4107701941139759E-2}]
[null,{"$f":"B45","v":"2006-06-01"},null,null,null,null,null,null,null,null,null,null,{"$f":"M45","v":3.0018192844148306E-2},{"$f":"N45","v":3.2100275145215518E-2}]
[null,{"$f":"B49","v":"2007-06-01"},null,null,null,null,null,null,null,null,null,null,{"$f":"M49","v":2.7377097438916476E-2},{"$f":"N49","v":2.962085308056861E-2}]
[null,{"$f":"B53","v":"2008-06-01"},null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(M$21:M$109,MATCH($B121,$B$21:$B$109,0))","v":2.9799426934097317E-2},3.3659378596087475E-2]
[null,{"$f":"B57","v":"2009-06-01"},null,null,null,null,null,null,null,null,null,null,3.0884808013355691E-2,3.1171722794322454E-2]
[null,{"$f":"B61","v":"2010-06-01"},null,null,null,null,null,null,null,null,null,null,2.3211875843454743E-2,2.3211875843454743E-2]
[null,{"$f":"B65","v":"2011-06-01"},null,null,null,null,null,null,null,null,null,null,2.9807438670535369E-2,3.1126351886045844E-2]
[null,{"$f":"B69","v":"2012-06-01"},null,null,null,null,null,null,null,null,null,null,2.4846311475410054E-2,2.3023791250959436E-2]
[null,{"$f":"B73","v":"2013-06-01"},null,null,null,null,null,null,null,null,null,null,2.5493626593351415E-2,2.2755688922230677E-2]
[null,{"$f":"B77","v":"2014-06-01"},null,null,null,null,null,null,null,null,null,null,2.5834755057275283E-2,2.7139364303178315E-2]
[null,{"$f":"B81","v":"2015-06-01"},null,null,null,null,null,null,null,null,null,null,1.92444761225945E-2,1.7138776481790075E-2]
[null,{"$f":"B85","v":"2016-06-01"},null,null,null,null,null,null,null,null,null,null,1.5151515151515138E-2,1.3807629300257585E-2]
[null,{"$f":"B89","v":"2017-06-01"},null,null,null,null,null,null,null,null,null,null,2.020665901262908E-2,1.7082179132040354E-2]
[null,{"$f":"B93","v":"2018-06-01"},null,null,null,null,null,null,null,null,null,null,2.048165653837497E-2,1.9291874716296009E-2]
[null,{"$f":"B97","v":"2019-06-01"},null,null,null,null,null,null,null,null,null,null,1.6541685046316701E-2,1.6477399242930346E-2]
[null,{"$f":"B101","v":"2020-06-01"},null,null,null,null,null,null,null,null,null,null,1.0414406595790959E-2,1.3362541073384415E-2]
[null,{"$f":"B105","v":"2021-06-01"},null,null,null,null,null,null,null,null,null,null,1.5031135924415073E-2,1.6212710765239891E-2]
[null,{"$f":"B109","v":"2022-06-01"},null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(M$21:M$109,MATCH($B135,$B$21:$B$109,0))","v":3.9136873281150786E-2},4.4458625824292719E-2]

{"sheet":"ABS PPI","index":6,"n_rows":131,"n_cols":4,"rows_kept":131,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Source:","https://www.abs.gov.au/statistics/economy/price-indexes-and-inflation/producer-price-indexes-australia/dec-2022#data-downloads"]
[]
[null,"Time Series Workbook"]
[]
[]
[null,"6427.0 Producer Price Indexes, Australia"]
[null,"Table 1. Final demand, Index Numbers and Percentage Changes."]
[null,null,"Index Numbers ;  Final ;  Total (Source) ;"]
[null,"Unit","Index Numbers","All"]
[null,"Series Type","Original"]
[null,"Data Type","INDEX"]
[null,"Frequency","Quarter"]
[null,"Collection Month",3]
[null,"Series Start","1998-09-01"]
[null,"Series End","2022-12-01"]
[null,"No. Obs","1900-04-07"]
[null,"Series ID","A2314865F"]
[]
[]
[null,"2000-06-01",74.400000000000006]
[null,"2000-09-01",74.8]
[null,"2000-12-01",75.900000000000006]
[null,"2001-03-01",75.8]
[null,"2001-06-01",77]
[null,"2001-09-01",76.8]
[null,"2001-12-01",77.2]
[null,"2002-03-01",77.3]
[null,"2002-06-01",77.5]
[null,"2002-09-01",77.8]
[null,"2002-12-01",78.2]
[null,"2003-03-01",78.8]
[null,"2003-06-01",78.5]
[null,"2003-09-01",79]
[null,"2003-12-01",79]
[null,"2004-03-01",79.5]
[null,"2004-06-01",80.400000000000006]
[null,"2004-09-01",81.5]
[null,"2004-12-01",82.4]
[null,"2005-03-01",82.4]
[null,"2005-06-01",83.1]
[null,"2005-09-01",84.3]
[null,"2005-12-01",84.9]
[null,"2006-03-01",85.5]
[null,"2006-06-01",86.8]
[null,"2006-09-01",87.7]
[null,"2006-12-01",87.9]
[null,"2007-03-01",87.9]
[null,"2007-06-01",88.8,{"$f":"AVERAGE(C46:C49)/AVERAGE(C42:C45)-1","v":3.1625183016105396E-2}]
[null,"2007-09-01",89.8]
[null,"2007-12-01",90.4]
[null,"2008-03-01",92.1]
[null,"2008-06-01",93,{"$f":"AVERAGE(C50:C53)/AVERAGE(C46:C49)-1","v":3.6900369003689981E-2}]
[null,"2008-09-01",94.8]
[null,"2008-12-01",96.1]
[null,"2009-03-01",95.8]
[null,"2009-06-01",95,{"$f":"AVERAGE(C54:C57)/AVERAGE(C50:C53)-1","v":4.4894607172187406E-2}]
[null,"2009-09-01",95.1]
[null,"2009-12-01",94.7]
[null,"2010-03-01",95.6]
[null,"2010-06-01",95.9,{"$f":"AVERAGE(C58:C61)/AVERAGE(C54:C57)-1","v":-1.0479434110558516E-3}]
[null,"2010-09-01",97.2]
[null,"2010-12-01",97.3]
[null,"2011-03-01",98.4]
[null,"2011-06-01",99.2,{"$f":"AVERAGE(C62:C65)/AVERAGE(C58:C61)-1","v":2.8324154209284025E-2}]
[null,"2011-09-01",99.8]
[null,"2011-12-01",100.1]
[null,"2012-03-01",99.8]
[null,"2012-06-01",100.3,{"$f":"AVERAGE(C66:C69)/AVERAGE(C62:C65)-1","v":2.0147921448610218E-2}]
[null,"2012-09-01",100.9]
[null,"2012-12-01",101.1]
[null,"2013-03-01",101.4]
[null,"2013-06-01",101.5,{"$f":"AVERAGE(C70:C73)/AVERAGE(C66:C69)-1","v":1.2249999999999872E-2}]
[null,"2013-09-01",102.8]
[null,"2013-12-01",103]
[null,"2014-03-01",103.9]
[null,"2014-06-01",103.8,{"$f":"AVERAGE(C74:C77)/AVERAGE(C70:C73)-1","v":2.123981229933336E-2}]
[null,"2014-09-01",104]
[null,"2014-12-01",104.1]
[null,"2015-03-01",104.6]
[null,"2015-06-01",104.9,{"$f":"AVERAGE(C78:C81)/AVERAGE(C74:C77)-1","v":9.9153567110035201E-3}]
[null,"2015-09-01",105.8]
[null,"2015-12-01",106.1]
[null,"2016-03-01",105.9]
[null,"2016-06-01",106,{"$f":"AVERAGE(C82:C85)/AVERAGE(C78:C81)-1","v":1.4846743295019005E-2}]
[null,"2016-09-01",106.3]
[null,"2016-12-01",106.8]
[null,"2017-03-01",107.3]
[null,"2017-06-01",107.8,{"$f":"AVERAGE(C86:C89)/AVERAGE(C82:C85)-1","v":1.0382255781028915E-2}]
[null,"2017-09-01",108]
[null,"2017-12-01",108.6]
[null,"2018-03-01",109.1]
[null,"2018-06-01",109.4,{"$f":"AVERAGE(C90:C93)/AVERAGE(C86:C89)-1","v":1.6113965436711952E-2}]
[null,"2018-09-01",110.3]
[null,"2018-12-01",110.8]
[null,"2019-03-01",111.2]
[null,"2019-06-01",111.6,{"$f":"AVERAGE(C94:C97)/AVERAGE(C90:C93)-1","v":2.0225235578027911E-2}]
[null,"2019-09-01",112.1]
[null,"2019-12-01",112.4]
[null,"2020-03-01",112.6]
[null,"2020-06-01",111.2,{"$f":"AVERAGE(C98:C101)/AVERAGE(C94:C97)-1","v":9.9121423744086279E-3}]
[null,"2020-09-01",111.7]
[null,"2020-12-01",112.3]
[null,"2021-03-01",112.8]
[null,"2021-06-01",113.6,{"$f":"AVERAGE(C102:C105)/AVERAGE(C98:C101)-1","v":4.6843631496764626E-3}]
[null,"2021-09-01",114.9]
[null,"2021-12-01",116.4]
[null,"2022-03-01",118.3]
[null,"2022-06-01",120,{"$f":"AVERAGE(C106:C109)/AVERAGE(C102:C105)-1","v":4.2628774422735383E-2}]
[null,"2022-09-01",122.3]
[null,"2022-12-01",123.2]
[null,"2023-03-01",124.4]
[]
[]
[null,"Inflation, average of 4 quarters to June"]
[null,null,null,{"$f":"D10","v":"All"}]
[null,{"$f":"B53","v":"2008-06-01"},null,{"$f":"INDEX(D$21:D$109,MATCH($B117,$B$21:$B$109,0))","v":3.6900369003689981E-2}]
[null,{"$f":"B57","v":"2009-06-01"},null,4.4894607172187406E-2]
[null,{"$f":"B61","v":"2010-06-01"},null,-1.0479434110558516E-3]
[null,{"$f":"B65","v":"2011-06-01"},null,2.8324154209284025E-2]
[null,{"$f":"B69","v":"2012-06-01"},null,2.0147921448610218E-2]
[null,{"$f":"B73","v":"2013-06-01"},null,1.2249999999999872E-2]
[null,{"$f":"B77","v":"2014-06-01"},null,2.123981229933336E-2]
[null,{"$f":"B81","v":"2015-06-01"},null,9.9153567110035201E-3]
[null,{"$f":"B85","v":"2016-06-01"},null,1.4846743295019005E-2]
[null,{"$f":"B89","v":"2017-06-01"},null,1.0382255781028915E-2]
[null,{"$f":"B93","v":"2018-06-01"},null,1.6113965436711952E-2]
[null,{"$f":"B97","v":"2019-06-01"},null,2.0225235578027911E-2]
[null,{"$f":"B101","v":"2020-06-01"},null,9.9121423744086279E-3]
[null,{"$f":"B105","v":"2021-06-01"},null,4.6843631496764626E-3]
[null,{"$f":"B109","v":"2022-06-01"},null,{"$f":"INDEX(D$21:D$109,MATCH($B131,$B$21:$B$109,0))","v":4.2628774422735383E-2}]

{"sheet":"PPI T17","index":7,"n_rows":128,"n_cols":48,"rows_kept":128,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Source:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"https://www.abs.gov.au/statistics/economy/price-indexes-and-inflation/producer-price-indexes-australia/dec-2022#data-downloads"]
[]
[null,null,"Index Number ;  30 Building construction Australia ;","Index Number ;  30 Building construction New South Wales ;","Index Number ;  30 Building construction Victoria ;","Index Number ;  30 Building construction Queensland ;","Index Number ;  30 Building construction South Australia ;","Index Number ;  30 Building construction Western Australia ;","Index Number ;  30 Building construction Tasmania ;","Index Number ;  30 Building construction Northern Territory ;","Index Number ;  30 Building construction Australian Capital Territory ;","Index Number ;  3011 House construction Australia ;","Index Number ;  3011 House construction New South Wales ;","Index Number ;  3011 House construction Victoria ;","Index Number ;  3011 House construction Queensland ;","Index Number ;  3011 House construction South Australia ;","Index Number ;  3011 House construction Western Australia ;","Index Number ;  3011 House construction Tasmania ;","Index Number ;  3011 House construction Northern Territory ;","Index Number ;  3011 House construction Australian Capital Territory ;","Index Number ;  3019 Other residential building construction Australia ;","Index Number ;  3019 Other residential building construction New South Wales ;","Index Number ;  3019 Other residential building construction Victoria ;","Index Number ;  3019 Other residential building construction Queensland ;","Index Number ;  3019 Other residential building construction South Australia ;","Index Number ;  3019 Other residential building construction Western Australia ;","Index Number ;  3019 Other residential building construction Tasmania ;","Index Number ;  3019 Other residential building construction Northern Territory ;","Index Number ;  3019 Other residential building construction Australian Capital Territory ;","Index Number ;  3020 Non-residential building construction Australia ;","Index Number ;  3020 Non-residential building construction New South Wales ;","Index Number ;  3020 Non-residential building construction Victoria ;","Index Number ;  3020 Non-residential building construction Queensland ;","Index Number ;  3020 Non-residential building construction South Australia ;","Index Number ;  3020 Non-residential building construction Western Australia ;","Index Number ;  3020 Non-residential building construction Tasmania ;","Index Number ;  3020 Non-residential building construction Northern Territory ;","Index Number ;  3020 Non-residential building construction Australian Capital Territory ;","Index Number ;  31 Heavy and civil engineering construction Australia ;","Index Number ;  3101 Road and bridge construction Australia ;","Index Number ;  3101 Road and bridge construction New South Wales ;","Index Number ;  3101 Road and bridge construction Victoria ;","Index Number ;  3101 Road and bridge construction Queensland ;","Index Number ;  3101 Road and bridge construction South Australia ;","Index Number ;  3101 Road and bridge construction Western Australia ;","Index Number ;  3109 Other heavy and civil engineering construction Australia ;","Road and bridge construction Australia ;"," Road and bridge construction New South Wales ;"]
[null,"Unit","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers"]
[null,"Series Type","Original","Original","Original","Original","Original","Original","Original","Original","Original","Original","Original","Original","Original","Original","Original","Original","Original","Original","Original","Original","Original","Original","Original","Original","Original","Original","Original","Original","Original","Original","Original","Original","Original","Original","Original","Original","Original","Original","Original","Original","Original","Original","Original","Original"]
[null,"Data Type","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX"]
[null,"Frequency","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter"]
[null,"Collection Month",3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3,3]
[null,"Series Start","1996-09-01","1998-09-01","1998-09-01","1998-09-01","1998-09-01","1998-09-01","1998-09-01","1998-09-01","1998-09-01","1996-09-01","1998-09-01","1998-09-01","1998-09-01","1998-09-01","1998-09-01","1998-09-01","1998-09-01","1998-09-01","1996-09-01","1996-09-01","1996-09-01","1996-09-01","1996-09-01","1996-09-01","1996-09-01","1996-09-01","1996-09-01","1996-09-01","1996-09-01","1996-09-01","1996-09-01","1996-09-01","1996-09-01","1996-09-01","1996-09-01","1996-09-01","2007-03-01","1997-09-01","1998-09-01","1998-09-01","1998-09-01","1998-09-01","1998-09-01","2007-03-01"]
[null,"Series End","2018-06-01","2018-06-01","2018-06-01","2018-06-01","2018-06-01","2018-06-01","2018-06-01","2018-06-01","2018-06-01","2018-06-01","2018-06-01","2018-06-01","2018-06-01","2018-06-01","2018-06-01","2018-06-01","2018-06-01","2018-06-01","2018-06-01","2018-06-01","2018-06-01","2018-06-01","2018-06-01","2018-06-01","2018-06-01","2018-06-01","2018-06-01","2018-06-01","2018-06-01","2018-06-01","2018-06-01","2018-06-01","2018-06-01","2018-06-01","2018-06-01","2018-06-01","2018-06-01","2018-06-01","2018-06-01","2018-06-01","2018-06-01","2018-06-01","2018-06-01","2018-06-01"]
[null,"No. Obs",88,80,80,80,80,80,80,80,80,88,80,80,80,80,80,80,80,80,88,88,88,88,88,88,88,88,88,88,88,88,88,88,88,88,88,88,46,84,80,80,80,80,80,46]
[null,"Series ID","A2333649T","A2333670K","A2333691W","A2333712W","A2333733J","A2333754V","A2333775F","A2333796T","A2333817T","A2333652F","A2333673T","A2333694C","A2333715C","A2333736R","A2333757A","A2333778L","A2333799X","A2333820F","A2333655L","A2333676X","A2333697K","A2333718K","A2333739W","A2333760R","A2333781A","A2333802A","A2333823L","A2333658V","A2333679F","A2333700L","A2333721X","A2333742K","A2333763W","A2333784J","A2333805J","A2333826V","A85219099L","A2333664R","A2333685A","A2333706A","A2333727L","A2333748X","A2333769K","A85220823L"]
[null,"2001-09-01",66.599999999999994,67.900000000000006,71.599999999999994,62.2,70.3,56.3,60.2,53.7,65.599999999999994,68,72.5,73.8,61.8,70.400000000000006,53.9,58.9,53.5,67.599999999999994,67.3,65.8,70.599999999999994,68.3,69.2,60.3,59.9,54.8,63.2,65.3,65,69.099999999999994,62.9,69.900000000000006,60.2,60.9,53.7,62.6,null,63.4,64.5,64,60.6,63.2,65.5]
[null,"2001-12-01",67,68.2,72.3,62.4,71.400000000000006,56.6,60.4,54,67.2,68.7,73.099999999999994,75.2,61.9,71.599999999999994,54.2,59.2,53.9,68.900000000000006,67.7,66.2,70.599999999999994,68.599999999999994,70.099999999999994,60.7,60,54.9,65,65.599999999999994,65.099999999999994,69.2,63.4,70.900000000000006,60.6,61,53.9,64.5,null,62.7,63,64,60,62.9,65.5]
[null,"2002-03-01",67.599999999999994,68.7,72.8,63.3,72.3,57.1,60.6,54.4,67.5,69,73.3,75.099999999999994,62.8,72.5,54.5,59.6,54.8,69.3,68.5,66.8,72.099999999999994,69.400000000000006,71.599999999999994,61.6,60,55,65.400000000000006,66.3,65.7,70.099999999999994,64.2,71.7,61.4,60.9,53.9,64.7,null,63.6,64.8,64.099999999999994,60.7,62.5,66.099999999999994]
[null,"2002-06-01",68.3,69.400000000000006,73.099999999999994,64.2,73.400000000000006,57.4,61.9,55.2,68.400000000000006,69.7,74.099999999999994,75.7,63.8,73.400000000000006,54.6,61.7,55.9,70.599999999999994,69.3,67.7,72.3,70.5,72.7,61.9,60.3,55.7,66.2,66.900000000000006,66.2,70.3,65.2,72.900000000000006,61.8,61.5,54.4,65.099999999999994,null,65.099999999999994,66.8,65.8,62.4,63,67]
[null,"2002-09-01",68.900000000000006,70.099999999999994,73.3,65.599999999999994,74,57.6,63.3,55.8,69.3,70.3,74.5,75.900000000000006,65.2,74.5,55,62.9,56.6,71.3,70.2,68.599999999999994,72.400000000000006,72,72.7,62.3,61.9,56.1,66.900000000000006,67.599999999999994,67.2,70.400000000000006,66.400000000000006,72.900000000000006,61.9,63.1,55.1,66.2,null,66,67.8,66.8,63,63.8,67.3]
[null,"2002-12-01",69.400000000000006,70.3,73.7,66.5,74.599999999999994,58.2,63.7,55.9,70,70.8,74.8,76.400000000000006,66.099999999999994,75.5,55.5,63.7,56.6,72.2,70.599999999999994,68.900000000000006,72.599999999999994,72.8,72.8,62.8,62.1,56.1,67.400000000000006,67.900000000000006,67.2,70.599999999999994,67.5,72.900000000000006,62.5,62.9,55.2,66.7,null,67,68.7,67.599999999999994,64.400000000000006,65.400000000000006,68]
[null,"2003-03-01",70.5,71.3,75.099999999999994,67.400000000000006,75.099999999999994,59.1,65.7,56.9,71.3,71.900000000000006,75.8,78.099999999999994,67,76.099999999999994,56.1,66.5,58.4,73.7,71.599999999999994,70,73.8,73.5,72.8,64.099999999999994,63.3,56.6,69,69,68.3,71.7,68.5,73.2,64,63.9,55.7,67.599999999999994,null,67.8,69.599999999999994,68.3,65.3,66.2,68.7]
[null,"2003-06-01",72.2,73.3,77.099999999999994,69.3,75.7,60.6,66.7,56.9,72.900000000000006,73.3,76.2,80.099999999999994,69.7,76.599999999999994,57.6,68.400000000000006,58.4,76.400000000000006,74,73,75.900000000000006,75.3,73.2,65.7,63.4,56.7,69.7,70.8,71,73.7,69.7,73.900000000000006,65.5,64,55.8,68.099999999999994,null,68.8,70.099999999999994,70.400000000000006,65.8,67.400000000000006,69.5]
[null,"2003-09-01",73.7,74.900000000000006,77.5,71.5,77,62.1,67.400000000000006,57.1,75.7,74.599999999999994,77.099999999999994,80.400000000000006,72.900000000000006,78,59.4,68.8,58.5,79.099999999999994,75.599999999999994,74.7,76.400000000000006,77.2,73.5,66.8,64.8,57,72.900000000000006,72.400000000000006,73.2,74.099999999999994,71.400000000000006,75.400000000000006,66.599999999999994,64.900000000000006,55.9,70.900000000000006,null,69.3,70.8,70.900000000000006,66.599999999999994,67,69.400000000000006]
[null,"2003-12-01",74.599999999999994,76,77.5,73.3,78.3,63.3,68.099999999999994,58,76.2,75.599999999999994,77.8,80.2,75.599999999999994,80,60.6,69.599999999999994,60.2,80,76.8,76,76.900000000000006,79.099999999999994,73.8,67.8,65.099999999999994,57.6,72.900000000000006,73.3,74.5,74.400000000000006,72.599999999999994,75.599999999999994,67.7,65.5,56.2,70.900000000000006,null,69.900000000000006,71.5,71.099999999999994,67.599999999999994,67.5,69.7]
[null,"2004-03-01",76.5,78.900000000000006,79.099999999999994,75,79.8,64.400000000000006,69.3,58.3,77.2,76.400000000000006,78.7,80.7,76.599999999999994,81.7,61.8,71.5,60.9,80.400000000000006,79.8,80,79.599999999999994,81,76.7,68.8,65.400000000000006,57.6,74.2,76.099999999999994,78.599999999999994,77.099999999999994,74.8,76.400000000000006,68.7,65.900000000000006,56.2,72.599999999999994,null,70.3,72.400000000000006,71.3,68.2,67.2,70]
[null,"2004-06-01",78.2,80.2,80.8,78,80.3,65.900000000000006,70.7,60.5,77.5,77.599999999999994,80,81.5,78.2,82.4,63.3,73.8,63.1,81,81.7,81.5,81.400000000000006,84.7,76.900000000000006,70.099999999999994,65.7,59.8,74.400000000000006,78.3,80,79.900000000000006,79,76.599999999999994,70.3,66.3,58.6,72.5,null,71,73.099999999999994,71.2,69.900000000000006,67.400000000000006,70.400000000000006,null,{"$f":"AVERAGE(AN22:AN25)/AVERAGE(AN18:AN21)-1","v":4.0430267062314451E-2},{"$f":"AVERAGE(AO22:AO25)/AVERAGE(AO18:AO21)-1","v":4.1998551774076853E-2}]
[null,"2004-09-01",79.400000000000006,81.099999999999994,82.2,79.099999999999994,80.400000000000006,67.8,72.7,62.2,77.8,78.599999999999994,80.8,82.6,78.7,82.3,64.8,75.099999999999994,64.8,81.3,82.8,82.2,82.4,86.1,77.2,72.599999999999994,68.8,60.8,74.8,79.8,81,82.1,80.3,77.099999999999994,73,68.900000000000006,60.4,72.8,null,71.8,74,71.599999999999994,70.8,68.8,70.7]
[null,"2004-12-01",81.099999999999994,83.3,82.8,80.7,81.5,70.400000000000006,74.900000000000006,64.3,79.5,79.8,82.1,83,80.099999999999994,83.5,67.099999999999994,79,65.2,81.400000000000006,85.2,85.2,83.3,87.9,78.900000000000006,75,68.900000000000006,64.3,77.099999999999994,81.8,83.7,82.8,82.3,77.7,76,69.099999999999994,63.4,76.400000000000006,null,72.7,74.8,72.099999999999994,71.7,70,72.8]
[null,"2005-03-01",82.6,84.2,83.8,83.3,83.6,72.599999999999994,76.599999999999994,65.8,81.599999999999994,81,83.2,84.1,80.400000000000006,83.8,70,80.8,66.8,81.599999999999994,86.9,86.2,84.1,91.9,83.3,76.2,70.5,65.8,81.400000000000006,83.6,84.3,83.7,86.3,82.5,77.5,70.7,65,80.400000000000006,null,73.400000000000006,75.5,72.400000000000006,72.599999999999994,70.400000000000006,73.8]
[null,"2005-06-01",83.5,84.9,83.7,84.9,84,74.8,77.3,69.099999999999994,82.7,81.7,83.9,84,80.8,84,72.5,81.599999999999994,68.7,82.4,87.8,86.5,83.8,94.2,84.4,78,70.8,70.2,83,84.7,85.2,83.5,88.9,83.3,79.3,71.3,69.2,81.900000000000006,null,74.2,76.400000000000006,72.599999999999994,73.3,71.7,75.3,null,{"$f":"AVERAGE(AN26:AN29)/AVERAGE(AN22:AN25)-1","v":4.135472370766502E-2},{"$f":"AVERAGE(AO26:AO29)/AVERAGE(AO22:AO25)-1","v":4.4822793606671407E-2}]
[null,"2005-09-01",84.4,84.9,84.5,86.4,85.1,77.2,78.099999999999994,70.099999999999994,83.3,82.7,84.2,85.8,80.599999999999994,84.7,75.2,81.900000000000006,69.599999999999994,83.1,88.5,86.5,83.6,96.7,86.6,79.8,71.900000000000006,70.8,83.5,85.4,84.9,83.4,91.4,85.1,81.099999999999994,72.900000000000006,70.3,82.3,null,75.599999999999994,77.400000000000006,73.7,75.2,73.3,76.900000000000006]
[null,"2005-12-01",85.1,85.6,84.1,87.8,85.7,79.8,78.5,71.2,84.7,83.4,84.5,85.8,81.3,85,78.400000000000006,81.900000000000006,71.2,84.1,89.4,87.4,82.8,98.7,87.2,81.7,72.8,71.5,84.9,86.1,85.9,82.6,93.2,85.9,82.8,73.7,71.099999999999994,84.3,null,76.8,78.400000000000006,75,76.7,74.099999999999994,78.3]
[null,"2006-03-01",85.8,85.9,83.9,89,86.2,82.2,79.5,72.8,85.9,83.7,84.3,85,81.3,85.7,81.3,83.5,73.400000000000006,84.8,90.3,87.7,83.1,100.7,88.1,83.2,73,72.599999999999994,86.5,87.2,86.8,82.8,95.1,86.6,84.4,74.2,72.400000000000006,86,null,77.8,79.3,75.599999999999994,78,74.599999999999994,79.7]
[null,"2006-06-01",87,86.9,84.6,90.3,87.1,85,80.2,75,86.9,84.7,84.7,85.5,82.5,86.4,84.5,84.2,76.5,85.6,91.5,88.8,84.5,101.9,89.1,85.5,73.3,74.099999999999994,87.5,88.6,88.2,83.8,96.6,87.4,87.1,74.7,74.099999999999994,87,null,79.3,80.099999999999994,77.2,80.099999999999994,76,82.1,null,{"$f":"AVERAGE(AN30:AN33)/AVERAGE(AN26:AN29)-1","v":5.9568640876412005E-2},{"$f":"AVERAGE(AO30:AO33)/AVERAGE(AO26:AO29)-1","v":4.8220818091120776E-2}]
[null,"2006-09-01",87.8,87.7,84.2,91.6,87.9,87.7,82.4,77,87.2,84.8,84.6,84.2,82.7,86.9,86.8,84.5,79.099999999999994,86.2,92.9,89.9,84.9,104.2,90.3,88.7,78,75.599999999999994,87.6,90.1,89.6,84.5,98.6,88.7,90.3,78.900000000000006,75.7,87.1,null,80.5,81.7,77.7,81.7,76.8,83.2]
[null,"2006-12-01",88.5,87.4,86,92.4,88.3,89.3,83.1,79.8,88.3,85.3,84.4,85.4,83.1,86.9,87.8,84.5,82.4,86.8,93.4,89.3,86.5,105.4,91.3,90.9,81.7,78,88.8,91.2,89.5,87,99.7,89.8,92.7,80.099999999999994,78.3,88.8,null,81,82,78.8,82.1,77.400000000000006,83.3]
[null,"2007-03-01",89.4,87.3,87.3,94.2,88.7,90.5,83.8,81.5,88.9,86.2,84.8,86,86,86.8,88.7,85.1,83.6,87,94,89.2,87.3,106.6,92.5,92.7,82.1,80.2,90.6,92.1,89,89.5,100.9,91.2,94.6,80.8,80.3,89.6,84,81.400000000000006,82.7,78.900000000000006,82.5,78.099999999999994,83.8,85.5]
[null,"2007-06-01",90.6,88.2,88.9,95.5,90.2,92.2,85.6,82.9,89.7,87.1,85.4,86.5,87.6,88.5,89.7,87.3,84.2,87.4,95.4,90.2,89.8,108,93.5,95.2,83.4,82.3,91.3,93.8,90.2,92.3,101.9,92.2,97.1,82,82.2,90.9,84.6,82.1,83.3,79.5,83.2,78.599999999999994,85,86,{"$f":"AVERAGE(AN34:AN37)/AVERAGE(AN30:AN33)-1","v":5.0080775444264924E-2},{"$f":"AVERAGE(AO34:AO37)/AVERAGE(AO30:AO33)-1","v":4.6002538071065802E-2}]
[null,"2007-09-01",91.9,89,90.5,96.8,91.4,93.8,86.6,84.8,90.5,88.2,86.5,87.3,88.6,89.7,90.5,88.8,86.5,88.9,96.6,90.6,92.5,109.7,94.5,98.2,83.9,84,91.5,95.2,90.8,94.6,103.4,93.6,100,82.5,83.7,91.1,85.7,83.5,84.5,80.599999999999994,85,79.5,86.7,87]
[null,"2007-12-01",93.2,89.8,92.1,98.6,92,95.1,87.3,86.3,91.4,89.5,86.9,89.1,91.5,90.2,90.9,89.7,87.5,89.9,97.7,91.6,93.7,110.1,95.1,101,84,85.9,92.3,96.4,91.9,96,104,94.3,103.1,82.8,85.5,91.9,86.6,84.9,85.6,81.7,87.3,80.8,88.6,87.6]
[null,"2008-03-01",94.9,91.5,94.4,99.9,94,96.4,88.6,87.6,92,91.1,88.8,91.1,93.1,92.5,91.2,89.9,88.3,90.1,99.5,93.1,96.5,111,96.7,104.5,86.9,87.3,92.8,98.4,93.7,98.7,105.2,95.8,105.7,86.2,87.1,92.7,87.7,86.3,86.4,82.9,89.5,82.3,90.5,88.6]
[null,"2008-06-01",96.4,94,94.8,101.5,95.3,98.1,90,89.2,93.4,92.1,90,91.5,94.5,93.9,92,91.1,89.1,91.3,101.4,96,97.1,112.7,97.9,107.2,88.1,89.5,93.9,100.4,97,99.1,107.1,97.1,109.1,88,89.2,94.3,89.2,88,88,84.2,91.8,84.2,92,89.9,{"$f":"AVERAGE(AN38:AN41)/AVERAGE(AN34:AN37)-1","v":5.4461538461538339E-2},{"$f":"AVERAGE(AO38:AO41)/AVERAGE(AO34:AO37)-1","v":4.4889293296936694E-2}]
[null,"2008-09-01",98,95.3,96,103.8,97.8,99.8,91.4,91.1,95.7,93.4,90.9,92,96.6,95.8,93.4,92,90.6,94.8,103.1,97.5,98.9,114.3,100.7,109,89.6,91.8,95.7,102.6,98.9,101.1,110,100.5,111.3,90.3,91.3,96.1,92.1,90.8,89.4,86.5,97.2,87.4,94.8,92.9]
[null,"2008-12-01",97.6,95.8,93,104.2,98.7,100.6,91.8,92.9,96.2,93.6,91.5,90.7,97.8,97,94.4,92,92.3,94.7,102.6,98.4,94.6,114.2,101,110.6,90.4,93.5,96.7,101.3,99.1,96.1,109.4,100.9,111.6,91.5,93.1,96.9,93.9,91.9,89.7,88.6,98.6,89.9,94.8,95.1]
[null,"2009-03-01",96.2,95.3,91.2,101.2,98.5,99.3,92.1,94.4,96.4,93.1,91.5,89.7,97.1,97.2,94,92,93.6,94.7,100.1,98,92.2,107.6,100.7,107.7,91.3,95,97.1,98.8,97.9,93.2,104.6,100.1,108.3,92.5,94.7,97.1,94.2,91.1,89.7,88.5,95.3,89.9,93.8,96]
[null,"2009-06-01",95.9,95.7,90.4,100.5,98.3,98.9,92.5,95.5,96.6,94.4,93.4,91.6,97.9,97.7,94.1,92.5,94.6,95.8,98.3,97.5,87.9,105.3,100.2,106.8,91.3,96.5,96.9,96.9,97.1,89.3,102.1,98.9,107,92.5,95.8,96.9,94,90.8,89.5,87.8,95.2,90.5,94.1,95.9,{"$f":"AVERAGE(AN42:AN45)/AVERAGE(AN38:AN41)-1","v":6.3904289466005126E-2},{"$f":"AVERAGE(AO42:AO45)/AVERAGE(AO38:AO41)-1","v":4.00580551523948E-2}]
[null,"2009-09-01",96,95.1,92.7,98.9,98.6,98.5,96,95.9,96.5,95.6,94.1,94.6,98,98.4,94.4,95.9,94.9,96.8,97,96.1,89.4,101.7,99.8,105.3,94.9,96.8,96.4,96,95.6,90.9,98.6,98.5,105.6,96.2,96.3,96.4,94,91.6,91,88.4,95.5,91.4,93.4,95.4]
[null,"2009-12-01",96.3,95.6,93.2,99,98.7,98.4,96.1,96.3,96.6,96.1,94.9,95.5,98,98.7,94.7,96.1,95.1,96.8,97.1,96.3,89.3,101.8,99.7,105,94.9,97.4,96.5,96.1,95.9,90.9,98.8,98.4,104.8,96.2,96.8,96.5,93.8,92.2,91.6,89.9,95.7,91.8,93.6,94.7]
[null,"2010-03-01",96.9,96.5,93.7,99.3,99.5,99,97.4,97.1,97,96.9,95.8,96,98.8,99.6,95.9,96.7,95.8,97.1,97.5,97.5,89.5,101.6,100.4,104.5,97.7,98.3,97,96.5,96.6,91.7,98.7,99.1,104.2,98.7,97.5,97,94.3,92.6,92.2,89.5,96.4,92.8,94,95.4]
[null,"2010-06-01",97.2,96.6,94.8,99,100.2,99,97.8,98,98,97.5,96.2,97,99,100,97.2,97,96.1,98.5,97.3,97.2,90.4,101.1,101.3,101.7,98.7,99.6,97.8,96.7,96.6,92.9,97.8,100.1,102.2,99.2,98.7,97.8,94.6,93.2,92.8,90.2,96.6,94.6,94,95.5,{"$f":"AVERAGE(AN46:AN49)/AVERAGE(AN42:AN45)-1","v":1.371365880416886E-2},{"$f":"AVERAGE(AO46:AO49)/AVERAGE(AO42:AO45)-1","v":2.5955902874686076E-2}]
[null,"2010-09-01",98.1,96.9,97.1,99.3,100.7,99.2,99.9,98.9,98.8,98,96.4,97.5,99.6,100.5,97.5,99.5,97.5,99.5,98.7,97.7,95.7,101.1,101.9,101.6,100.1,100.2,98.7,98,96.9,97,97.8,100.9,102.1,100.5,99.5,98.6,95.9,93.6,93,90.5,97.4,94.8,95,97.3]
[null,"2010-12-01",98.8,98,98.2,99.6,101.1,99.3,100,99.9,99.1,98.8,97.5,98.2,100.5,100.6,97.8,99.5,98.7,99.5,99.2,98.8,97,100.4,102.3,101.6,100.4,100.9,99.1,98.8,98.1,98.6,97.5,101.6,102.1,100.9,100.3,99,96.4,94.4,93.5,93.3,97.3,95,94,97.6]
[null,"2011-03-01",99.1,98.4,98.3,100.2,101,99,100.1,100.2,99.7,99.6,98.5,99.5,101,101.4,98,99.6,99.1,100.2,98.9,98.8,95.5,100.9,100.3,100.1,100.5,101.1,99.6,98.5,98.1,97.6,98.3,100.5,100.7,101,100.6,99.5,96.5,94.6,93.4,93.6,97.8,95.2,94.5,97.7]
[null,"2011-06-01",100.2,99.6,100.6,101,100.6,99.2,100.2,100.3,100.3,100.1,99.6,99.9,101.7,101.2,98.5,99.7,99.5,100.3,100.5,99.6,100.8,101.7,99.8,100,100.5,101.1,100.5,100.2,99.5,101.6,99.2,99.8,100.6,101,100.6,100.2,98.6,98.2,97.3,98.3,100.3,97.6,97.6,98.8,{"$f":"AVERAGE(AN50:AN53)/AVERAGE(AN46:AN49)-1","v":3.0303030303030498E-2},{"$f":"AVERAGE(AO50:AO53)/AVERAGE(AO46:AO49)-1","v":2.6115342763873617E-2}]
[null,"2011-09-01",100,99.7,100.6,99.7,99.7,99.5,100.1,99.6,100.7,99.9,99.4,100.3,100.1,100.1,99.1,99.9,99.4,100.3,100,100,100.6,99.6,99.1,100,100.4,99.8,101,100.1,99.9,101,99.2,99.3,100.2,100.4,99.8,100.8,98.7,98.1,98.5,98.4,98,97.5,97.8,99.1]
[null,"2011-12-01",100.1,100,100.4,100.2,100,99.7,100.2,99.7,100,100,100,100,100.1,100.2,99.6,99.9,99.5,100.3,100.2,100,100.6,100.4,99.4,100,100.6,99.8,99.9,100.3,99.9,101,100.2,99.7,100,100.6,99.8,99.8,99.6,99.3,99.2,99,99.1,100.4,99.7,99.8]
[null,"2012-03-01",99.9,100,99.5,100,99.9,100,99.9,100.2,99.8,100,100.2,99.8,99.9,99.8,100.1,100.1,100.5,99.7,99.8,99.9,99.4,100.1,100.1,100,99.6,100,99.7,99.7,99.9,99,100.2,100,100,99.6,99.9,99.9,100.4,100.6,100.7,100.8,100.4,101,100.5,100.3]
[null,"2012-06-01",100.1,100.3,99.5,100,100.4,100.8,99.9,100.5,99.5,100.2,100.4,99.9,99.9,99.8,101.3,100.1,100.6,99.7,100,100.2,99.4,99.9,101.4,100,99.4,100.3,99.3,99.9,100.3,99,100.4,101.1,99.9,99.4,100.5,99.5,101.3,102,101.7,101.9,102.5,101.1,101.9,100.8,{"$f":"AVERAGE(AN54:AN57)/AVERAGE(AN50:AN53)-1","v":5.0420168067226934E-2},{"$f":"AVERAGE(AO54:AO57)/AVERAGE(AO50:AO53)-1","v":6.0710498409331848E-2}]
[null,"2012-09-01",100.3,101.2,98.8,101.4,100.6,100.6,97.4,99.9,99.7,100.8,103,98.2,103.5,100.2,100.9,95.5,102.5,99.7,99.9,100.3,99.4,99.8,101.5,100,98.6,99,99.6,99.9,100.3,99,100.4,101.2,99.9,98.6,98.8,99.7,102,102.8,102.5,103,103.3,102.5,102.6,101.5]
[null,"2012-12-01",100.2,101.5,98.5,100.9,101,100.7,97.3,100.4,99.6,100.9,104.4,96.3,105.1,100.9,101.5,95.5,103,99.9,100,100,101,98,101.7,99.5,98.5,99.4,99.5,99.6,100,99.9,98.5,101.4,99.6,98.5,99.2,99.5,102.4,103.2,103.4,103.3,103.5,102.9,102.6,101.9]
[null,"2013-03-01",101,101.9,100.8,100.8,101.2,101.2,97,101,99.7,102.8,105.5,101.2,104.4,100.8,102.9,95.6,104.2,100,100.1,100,101,98.1,101.8,99.5,98.4,99.6,99.5,99.6,100,99.9,98.8,101.7,99.3,97.6,99.7,99.5,102.7,103.8,103.9,104.3,104.1,103.4,103.2,102.1]
[null,"2013-06-01",101.6,102.3,101.2,101.7,101.4,102.1,97.2,102.2,100,103.9,106.2,102,106.4,101.1,104.5,96.2,105.7,99.8,100.2,100.2,100.9,98.2,102,99.5,98.4,100.5,100,100,100.3,100.3,99.1,101.9,99.6,97.6,100.8,100.1,103.5,104.4,104.5,104.7,104.5,104.6,103.8,103,{"$f":"AVERAGE(AN58:AN61)/AVERAGE(AN54:AN57)-1","v":3.5500000000000087E-2},{"$f":"AVERAGE(AO58:AO61)/AVERAGE(AO54:AO57)-1","v":3.5491127218195473E-2}]
[null,"2013-09-01",101.9,103,101,101.9,101.6,102.7,97.1,104.1,100.4,104.3,108.1,101.4,106.1,101.3,106,96.4,106.3,99.5,100.3,100.3,100.9,98.7,102.1,99.5,98.1,102.4,100.4,100.1,100.3,100.3,99.6,102.1,99.6,97.2,103.5,100.7,104.4,105,105.1,105.8,105.5,106.1,102.5,104.1]
[null,"2013-12-01",102.2,103.8,100.8,102.4,101.4,103.5,97,104.6,100.9,105.2,109.1,102.2,107.2,100.7,107.6,96.4,106.7,100.3,100.3,101,100.1,98.8,102.2,99.5,98,102.7,100.9,100.1,101,99.3,99.7,102.3,99.6,97,104.1,101.1,105.1,106.1,106.7,106.6,106.1,107,104.4,104.6]
[null,"2014-03-01",102.5,104.4,100.3,103,101.7,104.1,97.2,104.7,101.2,105.3,109.7,101,108.1,100.8,108.9,96.8,106.8,99.9,100.7,101.7,100.1,99.5,102.4,99.5,98.3,102.7,101.4,100.4,101.5,99.3,100,102.7,99.6,97,104.1,101.7,105.9,106.3,107.1,106.8,106.7,107.6,104.1,105.6]
[null,"2014-06-01",103.7,105.5,102.7,103.8,101.8,104.3,97.7,104.9,101.9,107,111.6,104.2,109.1,100.8,109.6,97.2,106.9,100.1,101.6,102.4,101.7,100.6,102.5,99.3,99.2,102.9,102.2,101.2,102.2,101.3,100.6,102.8,99.6,97.5,104.5,102.6,106.2,106.8,108,107.1,107,107.9,104.5,105.8,{"$f":"AVERAGE(AN62:AN65)/AVERAGE(AN58:AN61)-1","v":2.4142926122646013E-2},{"$f":"AVERAGE(AO62:AO65)/AVERAGE(AO58:AO61)-1","v":3.0412744388124358E-2}]
[null,"2014-09-01",104.7,107,103.4,105.7,101.8,104.6,98,105.7,102.2,108.2,114,105.5,109.5,100.9,110,97.8,107,101.1,102.4,103.4,101.8,102.8,102.5,99.3,99.2,103.7,102.4,102.2,103.4,101.4,103.6,102.9,99.7,97.5,105.6,102.7,106.7,107.3,108.5,107.3,107.4,109.8,104.8,106.4]
[null,"2014-12-01",105.3,107.6,103.8,106.9,101.9,105.1,98.3,105.8,102.8,109.4,115.6,106.4,111.7,101.2,111.1,98.3,107,102.3,102.5,103.4,101.8,103.6,102.5,99.3,99.8,103.9,102.7,102.4,103.4,101.4,104.1,102.9,99.7,97.7,105.8,102.9,106.8,106.4,108.7,107.2,104.9,109.9,104,106.9]
[null,"2015-03-01",106.1,108.8,103.9,108.8,102.7,105.5,98.5,106,102.8,110.4,118.2,106.4,112.4,102.9,112.1,98.3,107.4,101.6,103.2,103.9,101.9,106.4,102.7,99.3,100.6,103.9,103,103.1,103.8,101.6,106.8,103,99.6,98,105.8,103.3,107.1,106.6,108.7,107.1,105.3,109.8,104.3,107.2]
[null,"2015-06-01",106.9,110.3,104.8,109.2,102.9,105.6,99.3,106.7,102.9,112,121.1,108.5,113.4,103.3,112.8,99.4,107.8,100.2,103.5,104.8,101.9,106.4,102.6,98.9,101.2,104.5,103.7,103.3,104.7,101.6,106.8,102.9,99.3,98.4,106.8,103.8,107.4,106.9,108.7,107.4,106.3,108.9,104.2,107.6,{"$f":"AVERAGE(AN66:AN69)/AVERAGE(AN62:AN65)-1","v":7.0721357850069833E-3},{"$f":"AVERAGE(AO66:AO69)/AVERAGE(AO62:AO65)-1","v":1.8037011009604198E-2}]
[null,"2015-09-01",107.4,112.1,104.8,109.6,102.9,105.4,101,105.9,103,112.8,122.7,109.5,114.3,103.4,112.4,103,107.7,100.4,103.5,106.9,100.2,106.5,102.7,98.9,101.4,103.5,103.8,103.6,106.5,101,106.9,102.9,99.2,98.6,105.7,103.9,107.5,107.2,109.7,107.6,106.4,110,103.7,107.6]
[null,"2015-12-01",107.8,112.1,105.2,110.7,103,105.5,102.6,106.4,103.7,112.9,122.4,109.9,114.2,103.5,112.3,103.7,108,100.7,104.3,107,100.7,109.2,102.8,99.1,104.6,104,104.7,104.2,106.6,101.6,108.4,103,99.5,100.8,106.3,104.6,107.8,107.9,109.8,109.7,107.3,111,103.6,107.6]
[null,"2016-03-01",108,112.4,105.4,111.7,103.2,104.4,102.9,106.8,104,112.9,122.7,110.4,114.6,103.8,110.1,104.3,108.1,102.2,104.7,107.3,100.5,111,104,99.1,104.6,103.5,104.7,104.6,106.9,101.5,109.6,103.3,99.3,100.8,105.7,104.6,107.6,107.4,109.4,107.5,107.2,110.6,103,107.6]
[null,"2016-06-01",108.5,113.4,105.5,112.9,103.8,104.4,103.9,104.7,105.2,113.8,124.5,111.4,115.7,104.1,110,105.5,108.2,102.6,105.1,108.1,99.9,112.8,104.7,99.3,105.5,101.2,106.2,104.9,107.7,101.3,110.6,103.7,99.3,101.7,103.5,105.9,107.1,106.4,109.4,105.1,104.7,110.6,103.4,107.4,{"$f":"AVERAGE(AN70:AN73)/AVERAGE(AN66:AN69)-1","v":3.9794007490638883E-3},{"$f":"AVERAGE(AO70:AO73)/AVERAGE(AO66:AO69)-1","v":8.5135757017946734E-3}]
[null,"2016-09-01",108.9,114.3,105.4,114,104.2,104.1,104.8,104,105.5,114.3,125,112.4,116.5,104.4,109.6,105.8,108.1,102.7,105.5,108.9,99.3,114.5,105.1,99.3,106.8,100.3,106.6,105.1,108.6,100.4,111.6,104.1,99,103.5,102.6,106.2,107.2,106.4,110,104.2,104.6,111.3,103.6,107.4]
[null,"2016-12-01",109.8,116,105.7,115.7,104.4,104.2,104.8,104.2,106.2,115,126.2,113.6,116.6,104.3,109.8,105.7,108,103.2,106.5,110.6,99.2,116.9,105.6,99.3,106.8,100.4,107.5,106.2,110.8,100.3,114.4,104.6,99,103.5,102.9,107,107.4,107.2,110.6,103.9,106.5,112.1,104.3,107.5]
[null,"2017-03-01",110.5,117.1,106.3,117.1,104.6,103.8,105.8,104.6,106.7,116.3,128.4,115.2,119.3,104.7,109.2,105.7,108.2,103.6,106.9,111.2,99.2,117.6,105.7,99.2,110,100.9,108,106.5,111.4,100.3,115.1,104.7,98.8,105.4,103.5,107.6,107.9,107.6,110.6,104.4,107.8,113.4,104.5,108]
[null,"2017-06-01",111.5,118.8,106.8,118.6,104.7,103.8,107.1,105.2,107.4,117.3,129.30000000000001,116.6,121.3,104.6,109.1,106.4,108.4,104.1,107.8,113.3,99.2,118.8,106.1,99.2,112.2,101.2,108.7,107.4,113.5,100.3,116.1,105,98.8,107.4,104.4,108.3,108.8,108.4,111.2,105.9,108.9,114.2,104.6,108.9,{"$f":"AVERAGE(AN74:AN77)/AVERAGE(AN70:AN73)-1","v":1.6320820704127659E-3},{"$f":"AVERAGE(AO74:AO77)/AVERAGE(AO70:AO73)-1","v":9.3543235227013799E-3}]
[null,"2017-09-01",112,119.9,107.7,118.3,105.2,103.5,107.5,105.3,108.4,118.3,130.9,119.1,120.5,105.2,109.2,106.5,108.7,104.9,108,114.1,99.2,118.5,106.4,97.8,112.7,101.3,109.7,107.7,114.4,100.3,116.5,105.3,98.4,108.2,104.5,109.4,109.5,109.4,111.5,109,109.6,115.4,104.8,109.6]
[null,"2017-12-01",112.5,120.5,108.2,118.9,106.1,103.3,108.4,105.5,109.3,119.3,131.6,120.4,122.6,106.4,108.9,107.2,108.7,106.6,108.2,114.7,99.3,118.1,107.1,97.8,113.6,101.7,110.4,107.9,114.9,100.3,116.4,105.9,98.4,109.5,104.7,110.1,110.2,110.3,112.3,109.6,110.7,117.1,106.1,110.3]
[null,"2018-03-01",112.9,121.6,108.6,119.5,107.4,102.3,108.9,105.5,110,120,134.1,121.1,123.9,108.3,106.8,107.7,108.7,107.3,108.5,115.2,99.5,118.2,108.1,97.8,114.2,101.7,111,108.2,115.5,100.6,116.6,106.7,98.2,109.9,104.7,110.8,110.8,111.7,113,113.7,111.3,119,106.4,110.6]
[null,"2018-06-01",114.2,122.8,111,119.7,107.6,102.1,110.6,105.5,110.8,121.2,134.9,123.8,124.4,107.9,106.4,110.6,108.8,108.5,109.9,116.8,101.7,118.2,108.7,97.8,114.8,101.7,111.5,109.4,116.6,103,116.7,107.4,98.2,110.5,104.7,111.6,112.5,113.3,115,117.1,112.5,118,106.8,112.4,{"$f":"AVERAGE(AN78:AN81)/AVERAGE(AN74:AN77)-1","v":3.5148975791433834E-2},{"$f":"AVERAGE(AO78:AO81)/AVERAGE(AO74:AO77)-1","v":2.1247739602169968E-2}]
[null,"2018-09-01",114.6,124.2,111,120,107.4,102.1,111.5,105.1,111.6,121,135.6,122.5,124.8,106.9,106.3,111,109.4,109.7,110.8,118.6,102.2,118.2,109,97.8,116.3,100.9,112.2,110.1,118.1,103.5,116.9,107.6,98.2,111.8,103.7,112.4,113.6,114.9,116.6,119,114,120.1,107.8,113.3]
[null,"2018-12-01",115.1,125.1,111.5,119.7,108.2,102.2,111.7,105.3,112.5,121.3,136.80000000000001,122.8,124.2,107.6,106.5,111,109.5,110.8,111.4,119.2,102.8,118.6,109.8,97.8,116.7,101,113.1,110.5,118.9,104.2,116.6,108.4,98.2,112.4,104,113.2,114.7,115.8,117,121,115,121.5,108.3,114.5]
[null,"2019-03-01",115.3,126.1,111,119.9,108.8,102.2,112,104.7,112.4,120.9,138,121,123.6,108,106.5,111.4,108.2,110.2,111.9,120.1,102.9,119.5,110.6,97.8,117.2,100.8,113.1,111,119.8,104.2,117.1,109.2,98.2,112.5,103.7,113.2,115.3,115.8,117.3,120.6,115,121.2,108.5,115.1]
[null,"2019-06-01",115.8,127,111.5,119.6,109,102.4,114.4,104.5,113.1,120.3,137.19999999999999,120,122.5,108,107,114.3,108.7,110.2,112.9,121.5,104.1,119.5,110.8,97.8,119.3,100.4,113.9,111.9,121.5,105.5,117.1,109.4,98.2,114.4,103.2,114.1,115.9,116.4,117.9,120.7,115.6,122.1,109,115.8,{"$f":"AVERAGE(AN82:AN85)/AVERAGE(AN78:AN81)-1","v":4.0926467281313217E-2},{"$f":"AVERAGE(AO82:AO85)/AVERAGE(AO78:AO81)-1","v":3.7627268702965733E-2}]
[null,"2019-09-01",115.8,126.8,111.4,119.9,108.8,102.5,116.1,104.9,113.6,120,136.1,119.8,122.7,107.2,107.4,117.1,109.4,109.3,113.1,121.5,104.1,120.5,111,97.8,120,100.8,114.7,112,121.5,105.5,117.1,109.7,98.2,115.1,103.5,115,116.6,116.9,118.5,122,115.8,122,109.1,116.5]
[null,"2019-12-01",116,126.4,112.2,120.5,109.4,102.4,117.8,105.2,114.5,120.7,134.5,122,124,108.6,107,119.1,110.1,110.5,113.2,121.5,104.1,120.5,111.2,97.8,121.9,100.8,115.6,112.1,121.5,105.5,117.4,109.8,98.2,116.3,103.6,115.9,116.8,117.1,118.3,122.6,116,122.3,109.9,116.8]
[null,"2020-03-01",116,126.2,112.4,119.9,109.8,102.9,118.3,105.4,114.8,121.4,136.69999999999999,122.7,122.5,109.3,108.3,119.7,110.6,109.7,112.7,120.4,104.1,120.5,111.5,97.8,122.5,100.8,116.1,111.8,120.6,105.5,117.4,110,98.2,116.9,103.6,116.5,117,116.7,118,121.5,115.7,122.1,109.9,117.1]
[null,"2020-06-01",116.2,125.8,112.8,120.1,109.6,103.6,117.8,107.2,115,121.3,136.1,122,123.1,108.7,110.4,119.9,111.4,110,113,120.1,105.1,120.5,111.5,97.8,121,102.6,116.3,112.1,120.4,106.4,117.4,110,98.2,116.2,105.8,116.7,117.1,115.8,117.5,120,114.8,120.7,108.9,117.5,{"$f":"AVERAGE(AN86:AN89)/AVERAGE(AN82:AN85)-1","v":7.7770576798446012E-3},{"$f":"AVERAGE(AO86:AO89)/AVERAGE(AO82:AO85)-1","v":7.4658703071672772E-3}]
[null,"2020-09-01",116.2,125.9,113.1,119.4,107.5,105.1,118.2,107.8,115.5,122,136,122.8,122.8,108.4,115,120.9,111.4,111.8,112.6,119.9,105.1,119.4,108.5,97.8,121,103.6,116.3,111.9,120.7,106.4,116.5,106.9,98.2,116.2,106.7,116.7,117.2,116.1,118.6,118.7,115.2,120.2,108.9,117.6]
[null,"2020-12-01",116.9,125.4,114.1,121.2,107.9,106.8,120.4,107.9,115.6,124.2,137.30000000000001,124.7,126.4,109.7,119.3,123.1,111.4,112.3,112.4,118.7,105.4,119.6,108.3,97.9,123.9,103.6,116.4,112.1,119.7,107.2,118,106.7,98.7,117.8,106.7,116.8,117.6,116.8,119.6,119.3,115.7,121.6,109.3,117.8]
[null,"2021-03-01",117.8,125.3,114.7,122.2,109.4,110.1,123.9,108,115.7,125.9,136.80000000000001,126.6,128.30000000000001,112.3,125.4,124.3,111.7,111.4,112.8,118.7,105.4,120.1,109.3,99.8,130.30000000000001,104,116.7,112.6,119.7,107.3,118.8,107.6,100.6,122.4,106.8,117.1,117.9,116.6,118.6,119.8,114.7,122.8,110.4,118.3]
[null,"2021-06-01",120,129.1,115.6,124.4,110.7,113.5,129.1,108.3,116.5,128.1,139.69999999999999,127.2,131.5,114.2,129.4,130.5,112.3,113.5,114.9,122.7,106.5,121.1,110.1,102.5,135.30000000000001,104.1,117.2,114.9,123.7,108.2,120.8,108.7,103.7,126.6,107,117.7,119.9,118.6,120.9,122.2,116.1,125.1,112.7,120.3,{"$f":"AVERAGE(AN90:AN93)/AVERAGE(AN86:AN89)-1","v":3.4297963558413969E-3},{"$f":"AVERAGE(AO90:AO93)/AVERAGE(AO86:AO89)-1","v":1.1433410967605084E-2}]
[null,"2021-09-01",122.5,130.80000000000001,116.7,130.80000000000001,112.6,116.1,133.9,111.3,118.2,132.80000000000001,145.1,130.19999999999999,140.69999999999999,118.2,131.1,137.9,118.4,119.6,116.1,123.2,106.6,125.2,110.8,104.9,139,105.2,117.6,116.6,124.2,108.5,126.5,109.3,107.1,129.4,109.1,118.1,122.5,120.3,122.2,123.5,117.7,127.3,115.6,123.1]
[null,"2021-12-01",126,135.5,118.1,135.6,115.8,122.3,138.6,112.7,119.5,138,149,132.9,149.9,125.7,138.30000000000001,147.80000000000001,119.2,123.4,118.7,127.5,107.2,129.1,111.6,110.2,139.5,106.2,118.1,119.3,129.30000000000001,109.2,128.4,110.1,112.7,130.6,111,118.8,124.2,121.9,123.4,124.9,119,130.5,119.4,124.8]
[null,"2022-03-01",129.69999999999999,139.1,121.3,139.69999999999999,118.7,128.5,141.30000000000001,115.4,121.2,144.80000000000001,155.30000000000001,139,157.9,130.9,150.9,149,121.6,128.1,120.8,130,108.9,131.1,113.2,113.1,143.9,108.7,119,121.7,132.1,111.2,130.80000000000001,111.9,115.8,134.1,113.8,119.6,127.1,125.2,126.9,128.30000000000001,121.8,134.4,122.7,127.7]
[null,"2022-06-01",134.6,144,126.3,146.1,122.2,132.1,147.30000000000001,119.4,122.9,153.5,162.80000000000001,149.69999999999999,168.9,136.9,156.5,153.6,125.1,133.4,123.7,134.4,111,134,115.4,115.1,152.19999999999999,112.6,119.7,125,135.69999999999999,113.5,135.6,113.8,118.6,140.4,118.1,120.4,130.69999999999999,129,130.19999999999999,132.30000000000001,126.4,138.69999999999999,126.2,131.19999999999999,{"$f":"AVERAGE(AN94:AN97)/AVERAGE(AN90:AN93)-1","v":6.0457167271950274E-2},{"$f":"AVERAGE(AO94:AO97)/AVERAGE(AO90:AO93)-1","v":5.2334100900146563E-2}]
[null,"2022-09-01",138.19999999999999,147.9,129.80000000000001,150.1,126.5,133.6,154.5,121.8,124.7,160,170.3,156.4,174.7,146.19999999999999,159.6,164.2,126,139.4,125.9,136.69999999999999,112.9,137.1,117.3,115.3,153.80000000000001,115,120.5,127.3,138.5,115.6,138.9,115.2,118.9,143.30000000000001,120.9,121.3,134.19999999999999,132.5,133.4,135.80000000000001,129.5,146.5,128.4,134.69999999999999]
[null,"2022-12-01",140.4,150.1,133.19999999999999,151.19999999999999,129.19999999999999,133.9,156.19999999999999,122.9,125.1,161.80000000000001,173.3,157.5,176.4,148.9,161.1,166.1,125,139.4,128.30000000000001,138.30000000000001,117.6,137.1,120.1,115.4,155.5,116.1,120.9,129.69999999999999,140.80000000000001,119.7,139.9,117.8,118.3,144.69999999999999,122.8,121.9,136.1,135.30000000000001,136.5,136.6,134,149.9,130.69999999999999,136.4]
[null,"2023-03-01"]
[null,"2023-06-01",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AVERAGE(AN98:AN101)/AVERAGE(AN94:AN97)-1","v":7.8968573730862301E-2},{"$f":"AVERAGE(AO98:AO101)/AVERAGE(AO94:AO97)-1","v":7.3801472050925021E-2}]
[null,"<add>"]
[null,"<add>"]
[null,"<add>"]
[]
[]
[]
[]
[null,"Increase in PPI, average of 4 quarters to June"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AV4","v":" Road and bridge construction New South Wales ;"},{"$f":"AW4","v":0},{"$f":"AX4","v":0},{"$f":"AY4","v":0},{"$f":"AE2","v":"https://www.abs.gov.au/statistics/economy/price-indexes-and-inflation/producer-price-indexes-australia/dec-2022#data-downloads"},{"$f":"AU4","v":"Road and bridge construction Australia ;"},{"$f":"AV4","v":" Road and bridge construction New South Wales ;"}]
[1,{"$f":"B29","v":"2005-06-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AU29","v":4.135472370766502E-2},{"$f":"AV29","v":4.4822793606671407E-2}]
[{"$f":"A111+1","v":2},{"$f":"B33","v":"2006-06-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AU33","v":5.9568640876412005E-2},{"$f":"AV33","v":4.8220818091120776E-2}]
[{"$f":"A112+1","v":3},{"$f":"B37","v":"2007-06-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AU37","v":5.0080775444264924E-2},{"$f":"AV37","v":4.6002538071065802E-2}]
[4,{"$f":"B41","v":"2008-06-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AU41","v":5.4461538461538339E-2},{"$f":"AV41","v":4.4889293296936694E-2}]
[5,{"$f":"B45","v":"2009-06-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AU45","v":6.3904289466005126E-2},{"$f":"AV45","v":4.00580551523948E-2}]
[6,{"$f":"B49","v":"2010-06-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AU49","v":1.371365880416886E-2},{"$f":"AV49","v":2.5955902874686076E-2}]
[7,{"$f":"B53","v":"2011-06-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AU53","v":3.0303030303030498E-2},{"$f":"AV53","v":2.6115342763873617E-2}]
[8,{"$f":"B57","v":"2012-06-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AU57","v":5.0420168067226934E-2},{"$f":"AV57","v":6.0710498409331848E-2}]
[9,{"$f":"B61","v":"2013-06-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AU61","v":3.5500000000000087E-2},{"$f":"AV61","v":3.5491127218195473E-2}]
[10,{"$f":"B65","v":"2014-06-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AU65","v":2.4142926122646013E-2},{"$f":"AV65","v":3.0412744388124358E-2}]
[11,{"$f":"B69","v":"2015-06-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AU69","v":7.0721357850069833E-3},{"$f":"AV69","v":1.8037011009604198E-2}]
[12,{"$f":"B73","v":"2016-06-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AU73","v":3.9794007490638883E-3},{"$f":"AV73","v":8.5135757017946734E-3}]
[13,{"$f":"B77","v":"2017-06-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AU77","v":1.6320820704127659E-3},{"$f":"AV77","v":9.3543235227013799E-3}]
[14,{"$f":"B81","v":"2018-06-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AU81","v":3.5148975791433834E-2},{"$f":"AV81","v":2.1247739602169968E-2}]
[15,{"$f":"B85","v":"2019-06-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AU85","v":4.0926467281313217E-2},{"$f":"AV85","v":3.7627268702965733E-2}]
[16,{"$f":"B89","v":"2020-06-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AU89","v":7.7770576798446012E-3},{"$f":"AV89","v":7.4658703071672772E-3}]
[17,{"$f":"B93","v":"2021-06-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AU93","v":3.4297963558413969E-3},{"$f":"AV93","v":1.1433410967605084E-2}]
[18,{"$f":"B97","v":"2022-06-01"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AU97","v":6.0457167271950274E-2},{"$f":"AV97","v":5.2334100900146563E-2}]

{"sheet":"ABS WPI","index":8,"n_rows":131,"n_cols":28,"rows_kept":131,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Source:","https://www.abs.gov.au/statistics/economy/price-indexes-and-inflation/wage-price-index-australia/sep-2022#data-downloads"]
[]
[null,"Time Series Workbook"]
[]
[]
[null,"6345.0 Wage Price Index, Australia"]
[null,"Table 1. Total Hourly Rates of Pay Excluding Bonuses: Sector, Original, Seasonally Adjusted and Trend",null,null,null,null,null,null,null,"Table 4b. Total Hourly Rates of Pay Excluding Bonuses: Public Sector by State, Original (Quarterly Index Numbers)"]
[null,null,null,null,null,null,null,null,null,null,"Table 2b. Total Hourly Rates of Pay Excluding Bonuses: All Sectors by State, Original (Quarterly Index Numbers)"]
[null,null,"Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Australia ;  Private ;  All industries ;","Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Australia ;  Public ;  All industries ;","Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Australia ;  Private and Public ;  All industries ;","Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Australia ;  Private ;  All industries ;","Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Australia ;  Public ;  All industries ;","Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Australia ;  Private and Public ;  All industries ;",null,"Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  New South Wales ;  Public ;  All industries ;","Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  New South Wales ;  Private and Public ;  All industries ;",null,null,{"$f":"C10","v":"Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Australia ;  Private ;  All industries ;"},{"$f":"D10","v":"Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Australia ;  Public ;  All industries ;"},{"$f":"E10","v":"Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Australia ;  Private and Public ;  All industries ;"},{"$f":"F10","v":"Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Australia ;  Private ;  All industries ;"},{"$f":"G10","v":"Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Australia ;  Public ;  All industries ;"},{"$f":"H10","v":"Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  Australia ;  Private and Public ;  All industries ;"},{"$f":"J10","v":"Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  New South Wales ;  Public ;  All industries ;"},{"$f":"K10","v":"Quarterly Index ;  Total hourly rates of pay excluding bonuses ;  New South Wales ;  Private and Public ;  All industries ;"}]
[null,"Unit","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers","Index Numbers",null,"Index Numbers","Index Numbers"]
[null,"Series Type","Original","Original","Original","Seasonally Adjusted","Seasonally Adjusted","Seasonally Adjusted",null,"Original","Original",null,null,"Original","Original","Original","Seasonally Adjusted","Seasonally Adjusted","Seasonally Adjusted",{"$f":"J12","v":"Original"},"Original"]
[null,"Data Type","INDEX","INDEX","INDEX","INDEX","INDEX","INDEX",null,"INDEX","INDEX"]
[null,"Frequency","Quarter","Quarter","Quarter","Quarter","Quarter","Quarter",null,"Quarter","Quarter"]
[null,"Collection Month",3,3,3,3,3,3,null,3,3]
[null,"Series Start","1997-09-01","1997-09-01","1997-09-01","1997-09-01","1997-09-01","1997-09-01",null,"1997-09-01","1997-09-01"]
[null,"Series End","2022-09-01","2022-09-01","2022-09-01","2022-09-01","2022-09-01","2022-09-01",null,"2022-09-01","2022-09-01"]
[null,"No. Obs",101,101,101,101,101,101,null,101,101]
[null,"Series ID","A2603039T","A2603989W","A2603609J","A2713846W","A2713852T","A2713849C",null,"A2599999R","A2599619A"]
[]
[null,"2000-06-01",72.900000000000006,70.7,72.3,73,70.8,72.5,null,69.8,72.7]
[null,"2000-09-01",73.8,71.5,73.2,73.7,71.400000000000006,73.099999999999994,null,70.599999999999994,73.900000000000006]
[null,"2000-12-01",74.400000000000006,72,73.8,74.400000000000006,72,73.8,null,71,74.3]
[null,"2001-03-01",75.099999999999994,72.900000000000006,74.599999999999994,75,72.8,74.5,null,71.900000000000006,75]
[null,"2001-06-01",75.5,73.400000000000006,75,75.7,73.599999999999994,75.2,null,72.2,75.5]
[null,"2001-09-01",76.400000000000006,74.099999999999994,75.8,76.3,74.099999999999994,75.7,null,72.900000000000006,76.400000000000006]
[null,"2001-12-01",76.900000000000006,74.599999999999994,76.400000000000006,76.900000000000006,74.599999999999994,76.3,null,73.2,76.900000000000006]
[null,"2002-03-01",77.400000000000006,75.400000000000006,76.900000000000006,77.400000000000006,75.2,76.900000000000006,null,74.3,77.400000000000006]
[null,"2002-06-01",77.900000000000006,75.7,77.400000000000006,78.099999999999994,75.900000000000006,77.5,null,74.400000000000006,77.8]
[null,"2002-09-01",79,76.599999999999994,78.3,78.8,76.5,78.2,null,75.099999999999994,78.900000000000006]
[null,"2002-12-01",79.5,77.2,78.900000000000006,79.5,77.2,78.900000000000006,null,75.7,79.400000000000006]
[null,"2003-03-01",80.099999999999994,78.5,79.7,80.099999999999994,78.3,79.7,null,78,80.400000000000006]
[null,"2003-06-01",80.5,78.900000000000006,80.099999999999994,80.7,79.099999999999994,80.3,null,78.3,80.8]
[null,"2003-09-01",81.400000000000006,80.2,81.099999999999994,81.400000000000006,80.099999999999994,81,null,80.099999999999994,81.900000000000006]
[null,"2003-12-01",82.2,80.8,81.900000000000006,82.2,80.900000000000006,81.8,null,80.5,82.6]
[null,"2004-03-01",82.7,81.8,82.5,82.8,81.599999999999994,82.5,null,81.900000000000006,83.3]
[null,"2004-06-01",83.2,82,82.9,83.5,82.3,83.1,null,82.1,83.8]
[null,"2004-09-01",84.3,83.3,84,84.2,83.2,83.9,null,83.2,84.7]
[null,"2004-12-01",85.1,84.2,84.8,85,84.2,84.8,null,83.7,85.2]
[null,"2005-03-01",85.8,85.4,85.7,85.8,85.3,85.7,null,85.8,86.4]
[null,"2005-06-01",86.5,85.8,86.3,86.7,86.2,86.5,null,85.9,87.1]
[null,"2005-09-01",87.6,87.2,87.5,87.5,87.1,87.4,null,88.1,88.3]
[null,"2005-12-01",88.4,88,88.3,88.4,87.9,88.2,null,88.5,88.9]
[null,"2006-03-01",89.3,89,89.2,89.3,88.9,89.2,null,89.7,89.9]
[null,"2006-06-01",90,89.7,89.9,90.2,89.9,90.1,null,90,90.5]
[null,"2006-09-01",90.9,90.9,90.9,91,90.8,90.9,null,92,91.6]
[null,"2006-12-01",91.7,91.9,91.8,91.9,91.9,91.9,null,92.5,92.3]
[null,"2007-03-01",92.7,92.8,92.8,92.8,92.7,92.8,null,93.4,93.3]
[null,"2007-06-01",93.5,93.4,93.5,93.7,93.7,93.8,null,93.9,93.9,null,null,{"$f":"AVERAGE(C46:C49)/AVERAGE(C42:C45)-1","v":3.7996059667886328E-2},4.2667420175190873E-2,3.9729501267962819E-2,3.9392234102419765E-2,4.3244771057094455E-2,4.0856579318117925E-2,{"$f":"AVERAGE(J46:J49)/AVERAGE(J42:J45)-1","v":4.3502666292450032E-2},3.7751677852349008E-2,{"$error":"#DIV/0!"}]
[null,"2007-09-01",94.7,94.9,94.8,94.7,94.7,94.7,null,95.7,95.2]
[null,"2007-12-01",95.7,95.7,95.7,95.6,95.6,95.6,null,96.1,95.9]
[null,"2008-03-01",96.6,96.5,96.6,96.6,96.4,96.6,null,97.3,96.8]
[null,"2008-06-01",97.6,97,97.5,97.8,97.3,97.7,null,97.4,97.6,null,null,{"$f":"AVERAGE(C50:C53)/AVERAGE(C46:C49)-1","v":4.2841648590021819E-2},4.0921409214092153E-2,4.2276422764227606E-2,4.141851651326478E-2,4.0368463830940282E-2,4.1147807255007995E-2,{"$f":"AVERAGE(J50:J53)/AVERAGE(J46:J49)-1","v":3.9537385691231997E-2},3.8803556992724308E-2,{"$error":"#DIV/0!"}]
[null,"2008-09-01",98.7,98.3,98.6,98.8,98.2,98.7,null,98.2,98.7]
[null,"2008-12-01",99.8,99.7,99.8,99.7,99.6,99.7,null,99.7,99.7]
[null,"2009-03-01",100.5,100.7,100.5,100.5,100.6,100.6,null,100.7,100.5]
[null,"2009-06-01",101,101.4,101.1,101.2,101.6,101.4,null,101.4,101.2,null,null,{"$f":"AVERAGE(C54:C57)/AVERAGE(C50:C53)-1","v":4.0041601664066562E-2},4.1655818797188271E-2,4.0041601664066562E-2,4.0291135950091039E-2,4.1666666666666519E-2,4.1081643265730605E-2,{"$f":"AVERAGE(J54:J57)/AVERAGE(J50:J53)-1","v":3.4928848641655907E-2},3.7872892347600384E-2,{"$error":"#DIV/0!"}]
[null,"2009-09-01",101.8,102.8,102,101.6,102.7,101.8,null,103.5,102.2]
[null,"2009-12-01",102.3,103.8,102.7,102.3,103.7,102.6,null,104,102.6]
[null,"2010-03-01",103.1,105,103.6,103.1,104.9,103.6,null,105.2,103.6]
[null,"2010-06-01",103.8,105.4,104.2,104,105.7,104.4,null,105.3,104.2,null,null,{"$f":"AVERAGE(C58:C61)/AVERAGE(C54:C57)-1","v":2.750000000000008E-2},4.2239440139965057E-2,3.1249999999999778E-2,2.6986506746626615E-2,4.2499999999999982E-2,2.9970029970030065E-2,{"$f":"AVERAGE(J58:J61)/AVERAGE(J54:J57)-1","v":4.4999999999999929E-2},3.1242189452636904E-2]
[null,"2010-09-01",105.4,106.9,105.7,105.2,106.8,105.5,null,107.4,105.8]
[null,"2010-12-01",106.3,107.9,106.6,106.2,107.8,106.6,null,107.7,106.5]
[null,"2011-03-01",107.2,108.8,107.6,107.2,108.7,107.6,null,108.9,107.6]
[null,"2011-06-01",107.8,109.3,108.2,108,109.6,108.4,null,109.5,108.2,null,null,{"$f":"AVERAGE(C62:C65)/AVERAGE(C58:C61)-1","v":3.8199513381995009E-2},3.8129496402877772E-2,3.7818181818181973E-2,3.7956204379562042E-2,3.812949640287755E-2,3.8069835111542272E-2,{"$f":"AVERAGE(J62:J65)/AVERAGE(J58:J61)-1","v":3.7081339712918604E-2},3.756665050896757E-2]
[null,"2011-09-01",109.3,110.4,109.5,109.1,110.3,109.3,null,110.4,109.5]
[null,"2011-12-01",110.3,111.3,110.5,110.2,111.2,110.4,null,111.4,110.5]
[null,"2012-03-01",111.2,112.2,111.4,111.2,112.1,111.5,null,112.3,111.4]
[null,"2012-06-01",112,112.9,112.2,112.2,113.2,112.5,null,112.8,112,null,null,{"$f":"AVERAGE(C66:C69)/AVERAGE(C62:C65)-1","v":3.7731427232247539E-2},3.2109032109031821E-2,3.620649380985741E-2,3.7740271917487078E-2,3.2109032109032265E-2,3.6440084092501657E-2,{"$f":"AVERAGE(J66:J69)/AVERAGE(J62:J65)-1","v":3.0911188004613788E-2},3.5739313244569137E-2]
[null,"2012-09-01",113.3,114.2,113.5,113.1,114.1,113.4,null,114.5,113.5]
[null,"2012-12-01",114.1,114.9,114.3,114,114.9,114.2,null,114.8,114]
[null,"2013-03-01",114.7,115.7,115,114.8,115.6,115,null,115.5,114.6]
[null,"2013-06-01",115.3,116.1,115.5,115.6,116.4,115.7,null,115.8,115.1,null,null,{"$f":"AVERAGE(C70:C73)/AVERAGE(C66:C69)-1","v":3.2971996386630398E-2},3.1557743957027817E-2,3.313796212804343E-2,3.3431217528800516E-2,3.1781557743957078E-2,3.2905116069416263E-2,{"$f":"AVERAGE(J70:J73)/AVERAGE(J66:J69)-1","v":3.0655627657193874E-2},3.1123139377537301E-2]
[null,"2013-09-01",116.4,117.2,116.6,116.3,117.1,116.4,null,116.8,116.1]
[null,"2013-12-01",117,118.1,117.2,116.9,118,117.2,null,117.7,116.8]
[null,"2014-03-01",117.7,119.1,118,117.8,119,118.1,null,118.7,117.6]
[null,"2014-06-01",118.2,119.5,118.5,118.4,119.7,118.7,null,118.9,118,null,null,{"$f":"AVERAGE(C74:C77)/AVERAGE(C70:C73)-1","v":2.6016615653694952E-2},2.820568453026695E-2,2.618372245254208E-2,2.6010928961748503E-2,2.7765726681127978E-2,2.6401920139646595E-2,{"$f":"AVERAGE(J74:J77)/AVERAGE(J70:J73)-1","v":2.4967433782023374E-2},2.4715660542432127E-2]
[null,"2014-09-01",119.3,120.4,119.5,119.1,120.3,119.4,null,120.3,119.1]
[null,"2014-12-01",119.9,121.3,120.2,119.8,121.2,120.1,null,120.7,119.6]
[null,"2015-03-01",120.3,122.1,120.7,120.4,122,120.8,null,121.4,120.1]
[null,"2015-06-01",120.8,122.5,121.2,121,122.7,121.4,null,121.6,120.5,null,null,{"$f":"AVERAGE(C78:C81)/AVERAGE(C74:C77)-1","v":2.3439164713402905E-2},2.6165857775902079E-2,2.4027216670210461E-2,2.3221133361738255E-2,2.6171380329252703E-2,2.4022108843537504E-2,{"$f":"AVERAGE(J78:J81)/AVERAGE(J74:J77)-1","v":2.5206524041516687E-2},2.3052294557097008E-2]
[null,"2015-09-01",121.8,123.7,122.2,121.6,123.6,122.1,null,123.3,121.7]
[null,"2015-12-01",122.3,124.3,122.7,122.2,124.3,122.7,null,123.5,122.1]
[null,"2016-03-01",122.7,125,123.2,122.8,125,123.3,null,124.1,122.6]
[null,"2016-06-01",123.1,125.4,123.7,123.4,125.6,123.9,null,124.3,123.1,null,null,{"$f":"AVERAGE(C82:C85)/AVERAGE(C78:C81)-1","v":1.9987507807620153E-2},2.4881760230310634E-2,2.1179401993355551E-2,2.019571101394968E-2,2.5298231180584052E-2,2.1382603280049706E-2,{"$f":"AVERAGE(J82:J85)/AVERAGE(J78:J81)-1","v":2.3140495867768562E-2},2.1281034842478785E-2]
[null,"2016-09-01",124.1,126.5,124.6,123.9,126.4,124.4,null,126.2,124.2]
[null,"2016-12-01",124.5,127.2,125.1,124.4,127.2,125,null,126.4,124.7]
[null,"2017-03-01",124.9,128,125.6,125,127.9,125.7,null,127.3,125.2]
[null,"2017-06-01",125.4,128.5,126.1,125.6,128.69999999999999,126.3,null,127.5,125.6,null,null,{"$f":"AVERAGE(C86:C89)/AVERAGE(C82:C85)-1","v":1.8371096142069776E-2},2.3675762439807402E-2,1.9520130134200731E-2,1.8163265306122334E-2,2.3470411233700972E-2,1.9105691056910734E-2,{"$f":"AVERAGE(J86:J89)/AVERAGE(J82:J85)-1","v":2.4636510500807951E-2},2.0837589376915266E-2]
[null,"2017-09-01",126.4,129.5,127.1,126.2,129.4,126.9,null,129.19999999999999,126.8]
[null,"2017-12-01",126.9,130.30000000000001,127.7,126.8,130.30000000000001,127.6,null,129.4,127.2]
[null,"2018-03-01",127.4,131,128.19999999999999,127.4,131,128.19999999999999,null,130.30000000000001,127.8]
[null,"2018-06-01",127.9,131.5,128.69999999999999,128.19999999999999,131.69999999999999,129,null,130.5,128.30000000000001,null,null,{"$f":"AVERAGE(C90:C93)/AVERAGE(C86:C89)-1","v":1.944277410302675E-2},2.3716189729517723E-2,2.0542481053051453E-2,1.9442774103026528E-2,2.3912191297530638E-2,2.0542481053051453E-2,{"$f":"AVERAGE(J90:J93)/AVERAGE(J86:J89)-1","v":2.3649980291683192E-2},2.0812487492495535E-2]
[null,"2018-09-01",129.19999999999999,132.69999999999999,130,128.9,132.69999999999999,129.80000000000001,null,132.5,129.80000000000001]
[null,"2018-12-01",129.80000000000001,133.6,130.6,129.69999999999999,133.6,130.5,null,133,130.30000000000001]
[null,"2019-03-01",130.30000000000001,134.19999999999999,131.19999999999999,130.4,134.1,131.19999999999999,null,133.6,130.80000000000001]
[null,"2019-06-01",130.80000000000001,135,131.80000000000001,131.1,135.19999999999999,132,null,133.9,131.30000000000001,null,null,{"$f":"AVERAGE(C94:C97)/AVERAGE(C90:C93)-1","v":2.2611089264648054E-2},2.5272831705916321E-2,2.3255813953488413E-2,2.2611089264648276E-2,2.5267993874425354E-2,2.3060386945475964E-2,{"$f":"AVERAGE(J94:J97)/AVERAGE(J90:J93)-1","v":2.6184058529071796E-2},2.3720839051166509E-2]
[null,"2019-09-01",132,136,132.9,131.80000000000001,135.9,132.69999999999999,null,135.69999999999999,132.6]
[null,"2019-12-01",132.6,136.6,133.5,132.5,136.5,133.4,null,136.1,133.1]
[null,"2020-03-01",133.1,137.30000000000001,134.1,133.19999999999999,137.30000000000001,134.1,null,136.80000000000001,133.6]
[null,"2020-06-01",133,137.9,134.1,133.30000000000001,138,134.4,null,137,133.6,null,null,{"$f":"AVERAGE(C98:C101)/AVERAGE(C94:C97)-1","v":2.0380696019996147E-2},2.2969187675070168E-2,2.1008403361344463E-2,2.0572966737165688E-2,2.2591486183719534E-2,2.1203438395415608E-2,{"$f":"AVERAGE(J98:J101)/AVERAGE(J94:J97)-1","v":2.3639774859286922E-2},2.0490233626962784E-2]
[null,"2020-09-01",133.69999999999999,138.4,134.69999999999999,133.4,138.30000000000001,134.5,null,137.5,134.4]
[null,"2020-12-01",134.4,138.80000000000001,135.4,134.30000000000001,138.69999999999999,135.30000000000001,null,137.6,134.9]
[null,"2021-03-01",135.1,139.4,136.1,135.19999999999999,139.30000000000001,136.1,null,138.30000000000001,135.6]
[null,"2021-06-01",135.5,139.69999999999999,136.5,135.9,139.80000000000001,136.80000000000001,null,138.5,136,null,null,{"$f":"AVERAGE(C102:C105)/AVERAGE(C98:C101)-1","v":1.507442999811559E-2},1.5516611902153921E-2,1.5151515151515138E-2,1.5071590052750716E-2,1.5336863246302679E-2,1.5151515151515138E-2,{"$f":"AVERAGE(J102:J105)/AVERAGE(J98:J101)-1","v":1.1546920821114748E-2},1.5012197410396055E-2]
[null,"2021-09-01",136.80000000000001,140.69999999999999,137.69999999999999,136.5,140.6,137.5,null,139.69999999999999,137.19999999999999]
[null,"2021-12-01",137.6,141.69999999999999,138.5,137.5,141.6,138.4,null,140.69999999999999,138.1]
[null,"2022-03-01",138.30000000000001,142.5,139.30000000000001,138.4,142.4,139.30000000000001,null,141.30000000000001,138.9]
[null,"2022-06-01",139.19999999999999,143.1,140.1,139.5,143.19999999999999,140.4,null,141.4,139.6,null,null,{"$f":"AVERAGE(C106:C109)/AVERAGE(C102:C105)-1","v":2.4503434193428486E-2},2.1031817364731253E-2,2.3770038695411833E-2,2.4313288789903353E-2,2.1039381406221747E-2,2.3770038695411833E-2,{"$f":"AVERAGE(J106:J109)/AVERAGE(J102:J105)-1","v":2.0293531436854417E-2},2.3849140321686058E-2]
[null,"2022-09-01",141.5,144,142.1,141.19999999999999,144.1,141.9,null,142.19999999999999,141.5]
[null,"2022-12-01",142.6,145.19999999999999,143.19999999999999,142.4,145.1,143,null,144.19999999999999,142.69999999999999]
[null,"2023-03-01",143.6,146.69999999999999,144.30000000000001,null,null,null,null,145,143.69999999999999]
[]
[]
[null,"Change in WPI, average of 4 quarters to June",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Indices"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Aust, Private","Aust, Public","Aust, Private and Public",null,null,null,"NSW, Public","NSW, Private and Public",null,null,{"$f":"N116","v":"Aust, Private"},{"$f":"O116","v":"Aust, Public"},"Aust, Private and Public",{"$f":"T116","v":"NSW, Public"},{"$f":"U116","v":"NSW, Private and Public"}]
[null,{"$f":"B53","v":"2008-06-01"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(N$21:N$109,MATCH($B117,$B$21:$B$109,0))","v":4.2841648590021819E-2},4.0921409214092153E-2,4.2276422764227606E-2,null,null,null,3.9537385691231997E-2,3.8803556992724308E-2]
[null,{"$f":"B57","v":"2009-06-01"},null,null,null,null,null,null,null,null,null,null,null,4.0041601664066562E-2,4.1655818797188271E-2,4.0041601664066562E-2,null,null,null,3.4928848641655907E-2,3.7872892347600384E-2]
[null,{"$f":"B61","v":"2010-06-01"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(N$21:N$109,MATCH($B119,$B$21:$B$109,0))","v":2.750000000000008E-2},4.2239440139965057E-2,3.1249999999999778E-2,null,null,null,4.4999999999999929E-2,3.1242189452636904E-2]
[null,{"$f":"B65","v":"2011-06-01"},null,null,null,null,null,null,null,null,null,null,null,3.8199513381995009E-2,3.8129496402877772E-2,3.7818181818181973E-2,null,null,null,3.7081339712918604E-2,3.756665050896757E-2]
[null,{"$f":"B69","v":"2012-06-01"},null,null,null,null,null,null,null,null,null,null,null,3.7731427232247539E-2,3.2109032109031821E-2,3.620649380985741E-2,null,null,null,3.0911188004613788E-2,3.5739313244569137E-2]
[null,{"$f":"B73","v":"2013-06-01"},null,null,null,null,null,null,null,null,null,null,null,3.2971996386630398E-2,3.1557743957027817E-2,3.313796212804343E-2,null,null,null,3.0655627657193874E-2,3.1123139377537301E-2]
[null,{"$f":"B77","v":"2014-06-01"},null,null,null,null,null,null,null,null,null,null,null,2.6016615653694952E-2,2.820568453026695E-2,2.618372245254208E-2,null,null,null,2.4967433782023374E-2,2.4715660542432127E-2,null,null,100,100,100,100,100]
[null,{"$f":"B81","v":"2015-06-01"},null,null,null,null,null,null,null,null,null,null,null,2.3439164713402905E-2,2.6165857775902079E-2,2.4027216670210461E-2,null,null,null,2.5206524041516687E-2,2.3052294557097008E-2,null,null,{"$f":"X123*(1+N124)","v":102.34391647134029},{"$f":"Y123*(1+O124)","v":102.6165857775902},102.40272166702104,{"$f":"AA123*(1+T124)","v":102.52065240415166},102.30522945570971]
[null,{"$f":"B85","v":"2016-06-01"},null,null,null,null,null,null,null,null,null,null,null,1.9987507807620153E-2,2.4881760230310634E-2,2.1179401993355551E-2,null,null,null,2.3140495867768562E-2,2.1281034842478785E-2,null,null,{"$f":"X124*(1+N125)","v":104.38951630087364},{"$f":"Y124*(1+O125)","v":105.1698670605613},{"$f":"Z124*(1+P125)","v":104.57155007442059},104.89303113747087,104.48239060832445]
[null,{"$f":"B89","v":"2017-06-01"},null,null,null,null,null,null,null,null,null,null,null,1.8371096142069776E-2,2.3675762439807402E-2,1.9520130134200731E-2,null,null,null,2.4636510500807951E-2,2.0837589376915266E-2,null,null,106.30726614106115,107.65984384891328,106.61280034020837,107.47722940055074,106.65955176093918]
[null,{"$f":"B93","v":"2018-06-01"},null,null,null,null,null,null,null,null,null,null,null,1.944277410302675E-2,2.3716189729517723E-2,2.0542481053051453E-2,null,null,null,2.3649980291683192E-2,2.0812487492495535E-2,null,null,108.37417430215214,110.21312513188437,108.80289177120986,110.01906375767848,108.87940234791891]
[null,{"$f":"B97","v":"2019-06-01"},null,null,null,null,null,null,null,null,null,null,null,2.2611089264648054E-2,2.5272831705916321E-2,2.3255813953488413E-2,null,null,null,2.6184058529071796E-2,2.3720839051166509E-2,null,null,110.82463243128063,112.99852289512557,111.33319157984265,112.89980936242321,111.4621131270011]
[null,{"$f":"B101","v":"2020-06-01"},null,null,null,null,null,null,null,null,null,null,null,2.0380696019996147E-2,2.2969187675070168E-2,2.1008403361344463E-2,null,null,null,2.3639774859286922E-2,2.0490233626962784E-2,null,null,113.08331557639038,115.59400717450943,113.67212417605782,115.56873543740731,113.74599786552831]
[null,{"$f":"B105","v":"2021-06-01"},null,null,null,null,null,null,null,null,null,null,null,1.507442999811559E-2,1.5516611902153921E-2,1.5151515151515138E-2,null,null,null,1.1546920821114748E-2,1.5012197410396055E-2,null,null,114.78798210100149,117.38763452205109,115.39442908781628,116.90319847489941,115.4535752401281]
[null,{"$f":"B109","v":"2022-06-01"},null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX(N$21:N$109,MATCH($B131,$B$21:$B$109,0))","v":2.4503434193428486E-2},2.1031817364731253E-2,{"$f":"INDEX(P$21:P$109,MATCH($B131,$B$21:$B$109,0))","v":2.3770038695411833E-2},null,null,null,2.0293531436854417E-2,2.3849140321686058E-2,null,null,117.60068186660983,119.85650981219669,118.13735913246863,119.27557720821862,118.20704375667026]

{"sheet":"Calculations--->","index":9,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Deliberately blank worksheet"]

{"sheet":"BCC Preferred","index":10,"n_rows":98,"n_cols":10,"rows_kept":98,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"Cover!$B$3","v":"Review of rate peg methodology - Draft report Base Cost Change (BCC) options"}]
[]
[null,"Calculation of Preferred BCC using Award/RBA WPI for employee costs"]
[null," "]
[]
[]
[null,"Table 1","Selected changes in costs"]
[]
[]
[null,{"$f":"Inputs!B44","v":"BCC for 1 July "},{"$f":"Inputs!C44","v":"BCC for FY"},{"$f":"Inputs!D44","v":"Report date for forecasts"},{"$f":"Inputs!E44","v":"Forecast to June"},null,"Other costs","Labour costs","Asset costs"]
[]
[]
[null,"Selected option",null,null,null,null,{"$f":"Inputs!F46","v":"RBA CPI forecast"},{"$f":"Inputs!O70","v":"Award with RBA forecast when Award not available"},{"$f":"Inputs!J109","v":"'Forecast PPI' = Forecast CPI + 5 yr PPI premium"}]
[null,{"$f":"Inputs!B48","v":2011},{"$f":"Inputs!C48","v":"2011-12"},{"$f":"Inputs!D48","v":"Aug- 10"},{"$f":"Inputs!E48","v":2012},null,{"$f":"Inputs!H48","v":2.8749999999999998E-2},{"$f":"Inputs!O71","v":3.7499999999999999E-2}]
[null,{"$f":"Inputs!B49","v":2012},{"$f":"Inputs!C49","v":"2012-13"},{"$f":"Inputs!D49","v":"Aug- 11"},{"$f":"Inputs!E49","v":2013},null,{"$f":"Inputs!H49","v":3.6250000000000004E-2},{"$f":"Inputs!O72","v":3.2500000000000001E-2}]
[null,{"$f":"Inputs!B50","v":2013},{"$f":"Inputs!C50","v":"2013-14"},{"$f":"Inputs!D50","v":"Aug- 12"},{"$f":"Inputs!E50","v":2014},null,{"$f":"Inputs!H50","v":2.5000000000000001E-2},{"$f":"Inputs!O73","v":3.5000000000000003E-2}]
[null,{"$f":"Inputs!B51","v":2014},{"$f":"Inputs!C51","v":"2014-15"},{"$f":"Inputs!D51","v":"Aug- 13"},{"$f":"Inputs!E51","v":2015},null,{"$f":"Inputs!H51","v":2.5000000000000001E-2},{"$f":"Inputs!O74","v":3.7500000000000006E-2}]
[null,{"$f":"Inputs!B52","v":2015},{"$f":"Inputs!C52","v":"2015-16"},{"$f":"Inputs!D52","v":"Aug- 14"},{"$f":"Inputs!E52","v":2016},null,{"$f":"Inputs!H52","v":3.0000000000000002E-2},{"$f":"Inputs!O75","v":2.7000000000000003E-2}]
[null,{"$f":"Inputs!B53","v":2016},{"$f":"Inputs!C53","v":"2016-17"},{"$f":"Inputs!D53","v":"Aug- 15"},{"$f":"Inputs!E53","v":2017},null,{"$f":"Inputs!H53","v":2.5000000000000001E-2},{"$f":"Inputs!O76","v":2.7999999999999997E-2},{"$f":"Inputs!$J120","v":3.4108023173992572E-2}]
[null,{"$f":"Inputs!B54","v":2017},{"$f":"Inputs!C54","v":"2017-18"},{"$f":"Inputs!D54","v":"Aug- 16"},{"$f":"Inputs!E54","v":2018},null,{"$f":"Inputs!H54","v":0.02},{"$f":"Inputs!O77","v":2.75E-2},{"$f":"Inputs!$J121","v":2.8518854465380834E-2}]
[null,{"$f":"Inputs!B55","v":2018},{"$f":"Inputs!C55","v":"2018-19"},{"$f":"Inputs!D55","v":"Aug- 17"},{"$f":"Inputs!E55","v":2019},null,{"$f":"Inputs!H55","v":2.375E-2},{"$f":"Inputs!O78","v":2.5000000000000001E-2},{"$f":"Inputs!$J122","v":2.2925549980610933E-2}]
[null,{"$f":"Inputs!B56","v":2019},{"$f":"Inputs!C56","v":"2019-20"},{"$f":"Inputs!D56","v":"Aug- 18"},{"$f":"Inputs!E56","v":2020},null,{"$f":"Inputs!H56","v":2.2499999999999999E-2},{"$f":"Inputs!O79","v":2.5000000000000001E-2},{"$f":"Inputs!$J123","v":1.9829266468401122E-2}]
[null,{"$f":"Inputs!B57","v":2020},{"$f":"Inputs!C57","v":"2020-21"},{"$f":"Inputs!D57","v":"Aug- 19"},{"$f":"Inputs!E57","v":2021},null,{"$f":"Inputs!H57","v":1.95E-2},{"$f":"Inputs!O80","v":2.35E-2},{"$f":"Inputs!$J124","v":2.0130785333561111E-2}]
[null,{"$f":"Inputs!B58","v":2021},{"$f":"Inputs!C58","v":"2021-22"},{"$f":"Inputs!D58","v":"Aug- 20"},{"$f":"Inputs!E58","v":2022},null,{"$f":"Inputs!H58","v":1.125E-2},{"$f":"Inputs!O81","v":2.5000000000000005E-2},{"$f":"Inputs!$J125","v":1.1532571098434436E-2}]
[null,{"$f":"Inputs!B59","v":2022},{"$f":"Inputs!C59","v":"2022-23"},{"$f":"Inputs!D59","v":"Aug- 21"},{"$f":"Inputs!E59","v":2023},null,{"$f":"Inputs!H59","v":1.8750000000000003E-2},{"$f":"Inputs!O82","v":2.5000000000000005E-2},{"$f":"Inputs!$J126","v":1.9640613997016533E-2}]
[null,{"$f":"Inputs!B60","v":2023},{"$f":"Inputs!C60","v":"2023-24"},{"$f":"Inputs!D60","v":"Aug- 22"},{"$f":"Inputs!E60","v":2024},null,{"$f":"Inputs!H60","v":3.9E-2},{"$f":"Inputs!O83","v":4.2000000000000003E-2},{"$f":"Inputs!$J127","v":4.470052661880123E-2}]
[]
[]
[null,"Table 2","3-factor BCC 3 groups"]
[null,"Metropolitan",null,{"$f":"D$11","v":"Report date for forecasts"},{"$f":"E$11","v":"Forecast to June"},null,{"$f":"G11","v":"Other costs"},{"$f":"H11","v":"Labour costs"},"Asset costs","3-factor BCC"]
[null,"Selected option",null,null,null,null,null,null,null,"(rounded)"]
[null,"Weight",null,null,null,null,{"$f":"Inputs!E$31","v":0.41},{"$f":"Inputs!F$31","v":0.41},{"$f":"Inputs!G$31","v":0.18000000000000005},{"$f":"SUM(G33:I33)-1","v":0}]
[null,{"$f":"C$20","v":"2016-17"},null,{"$f":"D$20","v":"Aug- 15"},{"$f":"E$20","v":2017},null,{"$f":"G$20","v":2.5000000000000001E-2},{"$f":"H$20","v":2.7999999999999997E-2},{"$f":"I$20","v":3.4108023173992572E-2},{"$f":"ROUND(SUMPRODUCT($G$33:$I$33,G34:I34),3)","v":2.8000000000000001E-2}]
[null,{"$f":"C$21","v":"2017-18"},null,{"$f":"D$21","v":"Aug- 16"},{"$f":"E$21","v":2018},null,{"$f":"G$21","v":0.02},{"$f":"H$21","v":2.75E-2},{"$f":"I21","v":2.8518854465380834E-2},{"$f":"ROUND(SUMPRODUCT($G$33:$I$33,G35:I35),3)","v":2.5000000000000001E-2}]
[null,{"$f":"C$22","v":"2018-19"},null,{"$f":"D$22","v":"Aug- 17"},{"$f":"E$22","v":2019},null,{"$f":"G$22","v":2.375E-2},{"$f":"H$22","v":2.5000000000000001E-2},2.2925549980610933E-2,2.4E-2]
[null,{"$f":"C$23","v":"2019-20"},null,{"$f":"D$23","v":"Aug- 18"},{"$f":"E$23","v":2020},null,{"$f":"G$23","v":2.2499999999999999E-2},{"$f":"H$23","v":2.5000000000000001E-2},1.9829266468401122E-2,2.3E-2]
[null,{"$f":"C$24","v":"2020-21"},null,{"$f":"D$24","v":"Aug- 19"},{"$f":"E$24","v":2021},null,{"$f":"G$24","v":1.95E-2},{"$f":"H$24","v":2.35E-2},2.0130785333561111E-2,2.1000000000000001E-2]
[null,{"$f":"C$25","v":"2021-22"},null,{"$f":"D$25","v":"Aug- 20"},{"$f":"E$25","v":2022},null,{"$f":"G$25","v":1.125E-2},{"$f":"H$25","v":2.5000000000000005E-2},1.1532571098434436E-2,1.7000000000000001E-2]
[null,{"$f":"C$26","v":"2022-23"},null,{"$f":"D$26","v":"Aug- 21"},{"$f":"E$26","v":2023},null,{"$f":"G$26","v":1.8750000000000003E-2},{"$f":"H$26","v":2.5000000000000005E-2},1.9640613997016533E-2,2.1000000000000001E-2]
[null,{"$f":"C$27","v":"2023-24"},null,{"$f":"D$27","v":"Aug- 22"},{"$f":"E$27","v":2024},null,{"$f":"G$27","v":3.9E-2},{"$f":"H$27","v":4.2000000000000003E-2},4.470052661880123E-2,4.1000000000000002E-2]
[]
[null,{"$f":"Inputs!$B$34","v":"Regional "}]
[null,"Selected option"]
[null,"Weight",null,null,null,null,{"$f":"Inputs!E$34","v":0.4},{"$f":"Inputs!F$34","v":0.37},{"$f":"Inputs!G$34","v":0.22999999999999998},{"$f":"SUM(G45:I45)-1","v":0}]
[null,{"$f":"C$20","v":"2016-17"},null,{"$f":"D$20","v":"Aug- 15"},{"$f":"E$20","v":2017},null,{"$f":"G$20","v":2.5000000000000001E-2},{"$f":"H$20","v":2.7999999999999997E-2},{"$f":"I20","v":3.4108023173992572E-2},{"$f":"ROUND(SUMPRODUCT($G$45:$I$45,G46:I46),3)","v":2.8000000000000001E-2}]
[null,{"$f":"C$21","v":"2017-18"},null,{"$f":"D$21","v":"Aug- 16"},{"$f":"E$21","v":2018},null,{"$f":"G$21","v":0.02},{"$f":"H$21","v":2.75E-2},2.8518854465380834E-2,{"$f":"ROUND(SUMPRODUCT($G$45:$I$45,G47:I47),3)","v":2.5000000000000001E-2}]
[null,{"$f":"C$22","v":"2018-19"},null,{"$f":"D$22","v":"Aug- 17"},{"$f":"E$22","v":2019},null,{"$f":"G$22","v":2.375E-2},{"$f":"H$22","v":2.5000000000000001E-2},2.2925549980610933E-2,2.4E-2]
[null,{"$f":"C$23","v":"2019-20"},null,{"$f":"D$23","v":"Aug- 18"},{"$f":"E$23","v":2020},null,{"$f":"G$23","v":2.2499999999999999E-2},{"$f":"H$23","v":2.5000000000000001E-2},1.9829266468401122E-2,2.3E-2]
[null,{"$f":"C$24","v":"2020-21"},null,{"$f":"D$24","v":"Aug- 19"},{"$f":"E$24","v":2021},null,{"$f":"G$24","v":1.95E-2},{"$f":"H$24","v":2.35E-2},2.0130785333561111E-2,2.1000000000000001E-2]
[null,{"$f":"C$25","v":"2021-22"},null,{"$f":"D$25","v":"Aug- 20"},{"$f":"E$25","v":2022},null,{"$f":"G$25","v":1.125E-2},{"$f":"H$25","v":2.5000000000000005E-2},1.1532571098434436E-2,1.6E-2]
[null,{"$f":"C$26","v":"2022-23"},null,{"$f":"D$26","v":"Aug- 21"},{"$f":"E$26","v":2023},null,{"$f":"G$26","v":1.8750000000000003E-2},{"$f":"H$26","v":2.5000000000000005E-2},1.9640613997016533E-2,2.1000000000000001E-2]
[null,{"$f":"C$27","v":"2023-24"},null,{"$f":"D$27","v":"Aug- 22"},{"$f":"E$27","v":2024},null,{"$f":"G$27","v":3.9E-2},{"$f":"H$27","v":4.2000000000000003E-2},4.470052661880123E-2,4.1000000000000002E-2]
[]
[null,{"$f":"Inputs!$B$35","v":"Rural"}]
[null,"Selected option"]
[null,"Weight",null,null,null,null,{"$f":"Inputs!E$35","v":0.38},{"$f":"Inputs!F$35","v":0.36},{"$f":"Inputs!G$35","v":0.26},{"$f":"SUM(G57:I57)-1","v":0}]
[null,{"$f":"C$20","v":"2016-17"},null,{"$f":"D$20","v":"Aug- 15"},{"$f":"E$20","v":2017},null,{"$f":"G$20","v":2.5000000000000001E-2},{"$f":"H$20","v":2.7999999999999997E-2},{"$f":"I20","v":3.4108023173992572E-2},{"$f":"ROUND(SUMPRODUCT($G$57:$I$57,G58:I58),3)","v":2.8000000000000001E-2}]
[null,{"$f":"C$21","v":"2017-18"},null,{"$f":"D$21","v":"Aug- 16"},{"$f":"E$21","v":2018},null,{"$f":"G$21","v":0.02},{"$f":"H$21","v":2.75E-2},2.8518854465380834E-2,{"$f":"ROUND(SUMPRODUCT($G$57:$I$57,G59:I59),3)","v":2.5000000000000001E-2}]
[null,{"$f":"C$22","v":"2018-19"},null,{"$f":"D$22","v":"Aug- 17"},{"$f":"E$22","v":2019},null,{"$f":"G$22","v":2.375E-2},{"$f":"H$22","v":2.5000000000000001E-2},2.2925549980610933E-2,2.4E-2]
[null,{"$f":"C$23","v":"2019-20"},null,{"$f":"D$23","v":"Aug- 18"},{"$f":"E$23","v":2020},null,{"$f":"G$23","v":2.2499999999999999E-2},{"$f":"H$23","v":2.5000000000000001E-2},1.9829266468401122E-2,2.3E-2]
[null,{"$f":"C$24","v":"2020-21"},null,{"$f":"D$24","v":"Aug- 19"},{"$f":"E$24","v":2021},null,{"$f":"G$24","v":1.95E-2},{"$f":"H$24","v":2.35E-2},2.0130785333561111E-2,2.1000000000000001E-2]
[null,{"$f":"C$25","v":"2021-22"},null,{"$f":"D$25","v":"Aug- 20"},{"$f":"E$25","v":2022},null,{"$f":"G$25","v":1.125E-2},{"$f":"H$25","v":2.5000000000000005E-2},1.1532571098434436E-2,1.6E-2]
[null,{"$f":"C$26","v":"2022-23"},null,{"$f":"D$26","v":"Aug- 21"},{"$f":"E$26","v":2023},null,{"$f":"G$26","v":1.8750000000000003E-2},{"$f":"H$26","v":2.5000000000000005E-2},1.9640613997016533E-2,2.1000000000000001E-2]
[null,{"$f":"C$27","v":"2023-24"},null,{"$f":"D$27","v":"Aug- 22"},{"$f":"E$27","v":2024},null,{"$f":"G$27","v":3.9E-2},{"$f":"H$27","v":4.2000000000000003E-2},4.470052661880123E-2,4.2000000000000003E-2]
[]
[]
[]
[]
[null,"Table 4","3-factor BCC, NSW total"]
[null,"NSW",null,null,null,null,{"$f":"G11","v":"Other costs"},{"$f":"H11","v":"Labour costs"},{"$f":"I11","v":"Asset costs"},"3-factor BCC"]
[null,"Weight",null,null,null,null,{"$f":"Inputs!E$38","v":0.4},{"$f":"Inputs!F$38","v":0.39},{"$f":"Inputs!G$38","v":0.20999999999999996},{"$f":"SUM(G72:I72)-1","v":0}]
[null,{"$f":"B19","v":2015},null,{"$f":"D19","v":"Aug- 14"},2016,null,{"$f":"G19","v":3.0000000000000002E-2},2.7000000000000003E-2]
[null,2016,null,"Aug- 15",2017,null,2.5000000000000001E-2,2.7999999999999997E-2,{"$f":"I20","v":3.4108023173992572E-2},{"$f":"ROUND(SUMPRODUCT($G$72:$I$72,G74:I74),3)","v":2.8000000000000001E-2}]
[null,2017,null,"Aug- 16",2018,null,0.02,2.75E-2,2.8518854465380834E-2,{"$f":"ROUND(SUMPRODUCT($G$72:$I$72,G75:I75),3)","v":2.5000000000000001E-2}]
[null,2018,null,"Aug- 17",2019,null,2.375E-2,2.5000000000000001E-2,2.2925549980610933E-2,2.4E-2]
[null,2019,null,"Aug- 18",2020,null,2.2499999999999999E-2,2.5000000000000001E-2,1.9829266468401122E-2,2.3E-2]
[null,2020,null,"Aug- 19",2021,null,1.95E-2,2.35E-2,2.0130785333561111E-2,2.1000000000000001E-2]
[null,2021,null,"Aug- 20",2022,null,1.125E-2,2.5000000000000005E-2,1.1532571098434436E-2,1.7000000000000001E-2]
[null,2022,null,"Aug- 21",2023,null,1.8750000000000003E-2,2.5000000000000005E-2,1.9640613997016533E-2,2.1000000000000001E-2]
[null,2023,null,"Aug- 22",2024,null,3.9E-2,4.2000000000000003E-2,4.470052661880123E-2,4.1000000000000002E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"#REF!+1","v":{"$error":"#REF!"}}]

{"sheet":"BCC Option 1 RBA WPI","index":11,"n_rows":98,"n_cols":10,"rows_kept":98,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"Cover!$B$3","v":"Review of rate peg methodology - Draft report Base Cost Change (BCC) options"}]
[]
[null,"Calculation of Option 1  BCC using only RBA WPI forecasts for employee costs"]
[null," "]
[]
[]
[null,"Table 1","Selected changes in costs"]
[]
[]
[null,{"$f":"Inputs!B44","v":"BCC for 1 July "},{"$f":"Inputs!C44","v":"BCC for FY"},{"$f":"Inputs!D44","v":"Report date for forecasts"},{"$f":"Inputs!E44","v":"Forecast to June"},null,"Other costs","Labour costs","Asset costs"]
[]
[]
[null,"Selected option",null,null,null,null,{"$f":"Inputs!F46","v":"RBA CPI forecast"},{"$f":"Inputs!M70","v":"RBA forecast"},{"$f":"Inputs!J109","v":"'Forecast PPI' = Forecast CPI + 5 yr PPI premium"}]
[null,{"$f":"Inputs!B48","v":2011},{"$f":"Inputs!C48","v":"2011-12"},{"$f":"Inputs!D48","v":"Aug- 10"},{"$f":"Inputs!E48","v":2012},null,{"$f":"Inputs!H48","v":2.8749999999999998E-2},{"$f":"Inputs!M71","v":3.7499999999999999E-2}]
[null,{"$f":"Inputs!B49","v":2012},{"$f":"Inputs!C49","v":"2012-13"},{"$f":"Inputs!D49","v":"Aug- 11"},{"$f":"Inputs!E49","v":2013},null,{"$f":"Inputs!H49","v":3.6250000000000004E-2},{"$f":"Inputs!M72","v":0.04}]
[null,{"$f":"Inputs!B50","v":2013},{"$f":"Inputs!C50","v":"2013-14"},{"$f":"Inputs!D50","v":"Aug- 12"},{"$f":"Inputs!E50","v":2014},null,{"$f":"Inputs!H50","v":2.5000000000000001E-2},{"$f":"Inputs!M73","v":3.7500000000000006E-2}]
[null,{"$f":"Inputs!B51","v":2014},{"$f":"Inputs!C51","v":"2014-15"},{"$f":"Inputs!D51","v":"Aug- 13"},{"$f":"Inputs!E51","v":2015},null,{"$f":"Inputs!H51","v":2.5000000000000001E-2},{"$f":"Inputs!M74","v":3.7500000000000006E-2}]
[null,{"$f":"Inputs!B52","v":2015},{"$f":"Inputs!C52","v":"2015-16"},{"$f":"Inputs!D52","v":"Aug- 14"},{"$f":"Inputs!E52","v":2016},null,{"$f":"Inputs!H52","v":3.0000000000000002E-2},{"$f":"Inputs!M75","v":3.5000000000000003E-2}]
[null,{"$f":"Inputs!B53","v":2016},{"$f":"Inputs!C53","v":"2016-17"},{"$f":"Inputs!D53","v":"Aug- 15"},{"$f":"Inputs!E53","v":2017},null,{"$f":"Inputs!H53","v":2.5000000000000001E-2},{"$f":"Inputs!M76","v":2.75E-2},{"$f":"Inputs!$J120","v":3.4108023173992572E-2}]
[null,{"$f":"Inputs!B54","v":2017},{"$f":"Inputs!C54","v":"2017-18"},{"$f":"Inputs!D54","v":"Aug- 16"},{"$f":"Inputs!E54","v":2018},null,{"$f":"Inputs!H54","v":0.02},{"$f":"Inputs!M77","v":2.75E-2},{"$f":"Inputs!$J121","v":2.8518854465380834E-2}]
[null,{"$f":"Inputs!B55","v":2018},{"$f":"Inputs!C55","v":"2018-19"},{"$f":"Inputs!D55","v":"Aug- 17"},{"$f":"Inputs!E55","v":2019},null,{"$f":"Inputs!H55","v":2.375E-2},{"$f":"Inputs!M78","v":2.5000000000000001E-2},{"$f":"Inputs!$J122","v":2.2925549980610933E-2}]
[null,{"$f":"Inputs!B56","v":2019},{"$f":"Inputs!C56","v":"2019-20"},{"$f":"Inputs!D56","v":"Aug- 18"},{"$f":"Inputs!E56","v":2020},null,{"$f":"Inputs!H56","v":2.2499999999999999E-2},{"$f":"Inputs!M79","v":2.75E-2},{"$f":"Inputs!$J123","v":1.9829266468401122E-2}]
[null,{"$f":"Inputs!B57","v":2020},{"$f":"Inputs!C57","v":"2020-21"},{"$f":"Inputs!D57","v":"Aug- 19"},{"$f":"Inputs!E57","v":2021},null,{"$f":"Inputs!H57","v":1.95E-2},{"$f":"Inputs!M80","v":2.35E-2},{"$f":"Inputs!$J124","v":2.0130785333561111E-2}]
[null,{"$f":"Inputs!B58","v":2021},{"$f":"Inputs!C58","v":"2021-22"},{"$f":"Inputs!D58","v":"Aug- 20"},{"$f":"Inputs!E58","v":2022},null,{"$f":"Inputs!H58","v":1.125E-2},{"$f":"Inputs!M81","v":1.8750000000000003E-2},{"$f":"Inputs!$J125","v":1.1532571098434436E-2}]
[null,{"$f":"Inputs!B59","v":2022},{"$f":"Inputs!C59","v":"2022-23"},{"$f":"Inputs!D59","v":"Aug- 21"},{"$f":"Inputs!E59","v":2023},null,{"$f":"Inputs!H59","v":1.8750000000000003E-2},{"$f":"Inputs!M82","v":3.0000000000000006E-2},{"$f":"Inputs!$J126","v":1.9640613997016533E-2}]
[null,{"$f":"Inputs!B60","v":2023},{"$f":"Inputs!C60","v":"2023-24"},{"$f":"Inputs!D60","v":"Aug- 22"},{"$f":"Inputs!E60","v":2024},null,{"$f":"Inputs!H60","v":3.9E-2},{"$f":"Inputs!M83","v":4.2000000000000003E-2},{"$f":"Inputs!$J127","v":4.470052661880123E-2}]
[]
[]
[null,"Table 2","3-factor BCC 3 groups"]
[null,"Metropolitan",null,{"$f":"D$11","v":"Report date for forecasts"},{"$f":"E$11","v":"Forecast to June"},null,{"$f":"G11","v":"Other costs"},{"$f":"H11","v":"Labour costs"},"Asset costs","3-factor BCC"]
[null,"Selected option",null,null,null,null,null,null,null,"(rounded)"]
[null,"Weight",null,null,null,null,{"$f":"Inputs!E$31","v":0.41},{"$f":"Inputs!F$31","v":0.41},{"$f":"Inputs!G$31","v":0.18000000000000005},{"$f":"SUM(G33:I33)-1","v":0}]
[null,{"$f":"C$20","v":"2016-17"},null,{"$f":"D$20","v":"Aug- 15"},{"$f":"E$20","v":2017},null,{"$f":"G$20","v":2.5000000000000001E-2},{"$f":"H$20","v":2.75E-2},{"$f":"I$20","v":3.4108023173992572E-2},{"$f":"ROUND(SUMPRODUCT($G$33:$I$33,G34:I34),3)","v":2.8000000000000001E-2}]
[null,{"$f":"C$21","v":"2017-18"},null,{"$f":"D$21","v":"Aug- 16"},{"$f":"E$21","v":2018},null,{"$f":"G$21","v":0.02},{"$f":"H$21","v":2.75E-2},{"$f":"I21","v":2.8518854465380834E-2},{"$f":"ROUND(SUMPRODUCT($G$33:$I$33,G35:I35),3)","v":2.5000000000000001E-2}]
[null,{"$f":"C$22","v":"2018-19"},null,{"$f":"D$22","v":"Aug- 17"},{"$f":"E$22","v":2019},null,{"$f":"G$22","v":2.375E-2},{"$f":"H$22","v":2.5000000000000001E-2},2.2925549980610933E-2,2.4E-2]
[null,{"$f":"C$23","v":"2019-20"},null,{"$f":"D$23","v":"Aug- 18"},{"$f":"E$23","v":2020},null,{"$f":"G$23","v":2.2499999999999999E-2},{"$f":"H$23","v":2.75E-2},1.9829266468401122E-2,2.4E-2]
[null,{"$f":"C$24","v":"2020-21"},null,{"$f":"D$24","v":"Aug- 19"},{"$f":"E$24","v":2021},null,{"$f":"G$24","v":1.95E-2},{"$f":"H$24","v":2.35E-2},2.0130785333561111E-2,2.1000000000000001E-2]
[null,{"$f":"C$25","v":"2021-22"},null,{"$f":"D$25","v":"Aug- 20"},{"$f":"E$25","v":2022},null,{"$f":"G$25","v":1.125E-2},{"$f":"H$25","v":1.8750000000000003E-2},1.1532571098434436E-2,1.4E-2]
[null,{"$f":"C$26","v":"2022-23"},null,{"$f":"D$26","v":"Aug- 21"},{"$f":"E$26","v":2023},null,{"$f":"G$26","v":1.8750000000000003E-2},{"$f":"H$26","v":3.0000000000000006E-2},1.9640613997016533E-2,2.4E-2]
[null,{"$f":"C$27","v":"2023-24"},null,{"$f":"D$27","v":"Aug- 22"},{"$f":"E$27","v":2024},null,{"$f":"G$27","v":3.9E-2},{"$f":"H$27","v":4.2000000000000003E-2},4.470052661880123E-2,4.1000000000000002E-2]
[]
[null,{"$f":"Inputs!$B$34","v":"Regional "}]
[null,"Selected option"]
[null,"Weight",null,null,null,null,{"$f":"Inputs!E$34","v":0.4},{"$f":"Inputs!F$34","v":0.37},{"$f":"Inputs!G$34","v":0.22999999999999998},{"$f":"SUM(G45:I45)-1","v":0}]
[null,{"$f":"C$20","v":"2016-17"},null,{"$f":"D$20","v":"Aug- 15"},{"$f":"E$20","v":2017},null,{"$f":"G$20","v":2.5000000000000001E-2},{"$f":"H$20","v":2.75E-2},{"$f":"I20","v":3.4108023173992572E-2},{"$f":"ROUND(SUMPRODUCT($G$45:$I$45,G46:I46),3)","v":2.8000000000000001E-2}]
[null,{"$f":"C$21","v":"2017-18"},null,{"$f":"D$21","v":"Aug- 16"},{"$f":"E$21","v":2018},null,{"$f":"G$21","v":0.02},{"$f":"H$21","v":2.75E-2},2.8518854465380834E-2,{"$f":"ROUND(SUMPRODUCT($G$45:$I$45,G47:I47),3)","v":2.5000000000000001E-2}]
[null,{"$f":"C$22","v":"2018-19"},null,{"$f":"D$22","v":"Aug- 17"},{"$f":"E$22","v":2019},null,{"$f":"G$22","v":2.375E-2},{"$f":"H$22","v":2.5000000000000001E-2},2.2925549980610933E-2,2.4E-2]
[null,{"$f":"C$23","v":"2019-20"},null,{"$f":"D$23","v":"Aug- 18"},{"$f":"E$23","v":2020},null,{"$f":"G$23","v":2.2499999999999999E-2},{"$f":"H$23","v":2.75E-2},1.9829266468401122E-2,2.4E-2]
[null,{"$f":"C$24","v":"2020-21"},null,{"$f":"D$24","v":"Aug- 19"},{"$f":"E$24","v":2021},null,{"$f":"G$24","v":1.95E-2},{"$f":"H$24","v":2.35E-2},2.0130785333561111E-2,2.1000000000000001E-2]
[null,{"$f":"C$25","v":"2021-22"},null,{"$f":"D$25","v":"Aug- 20"},{"$f":"E$25","v":2022},null,{"$f":"G$25","v":1.125E-2},{"$f":"H$25","v":1.8750000000000003E-2},1.1532571098434436E-2,1.4E-2]
[null,{"$f":"C$26","v":"2022-23"},null,{"$f":"D$26","v":"Aug- 21"},{"$f":"E$26","v":2023},null,{"$f":"G$26","v":1.8750000000000003E-2},{"$f":"H$26","v":3.0000000000000006E-2},1.9640613997016533E-2,2.3E-2]
[null,{"$f":"C$27","v":"2023-24"},null,{"$f":"D$27","v":"Aug- 22"},{"$f":"E$27","v":2024},null,{"$f":"G$27","v":3.9E-2},{"$f":"H$27","v":4.2000000000000003E-2},4.470052661880123E-2,4.1000000000000002E-2]
[]
[null,{"$f":"Inputs!$B$35","v":"Rural"}]
[null,"Selected option"]
[null,"Weight",null,null,null,null,{"$f":"Inputs!E$35","v":0.38},{"$f":"Inputs!F$35","v":0.36},{"$f":"Inputs!G$35","v":0.26},{"$f":"SUM(G57:I57)-1","v":0}]
[null,{"$f":"C$20","v":"2016-17"},null,{"$f":"D$20","v":"Aug- 15"},{"$f":"E$20","v":2017},null,{"$f":"G$20","v":2.5000000000000001E-2},{"$f":"H$20","v":2.75E-2},{"$f":"I20","v":3.4108023173992572E-2},{"$f":"ROUND(SUMPRODUCT($G$57:$I$57,G58:I58),3)","v":2.8000000000000001E-2}]
[null,{"$f":"C$21","v":"2017-18"},null,{"$f":"D$21","v":"Aug- 16"},{"$f":"E$21","v":2018},null,{"$f":"G$21","v":0.02},{"$f":"H$21","v":2.75E-2},2.8518854465380834E-2,{"$f":"ROUND(SUMPRODUCT($G$57:$I$57,G59:I59),3)","v":2.5000000000000001E-2}]
[null,{"$f":"C$22","v":"2018-19"},null,{"$f":"D$22","v":"Aug- 17"},{"$f":"E$22","v":2019},null,{"$f":"G$22","v":2.375E-2},{"$f":"H$22","v":2.5000000000000001E-2},2.2925549980610933E-2,2.4E-2]
[null,{"$f":"C$23","v":"2019-20"},null,{"$f":"D$23","v":"Aug- 18"},{"$f":"E$23","v":2020},null,{"$f":"G$23","v":2.2499999999999999E-2},{"$f":"H$23","v":2.75E-2},1.9829266468401122E-2,2.4E-2]
[null,{"$f":"C$24","v":"2020-21"},null,{"$f":"D$24","v":"Aug- 19"},{"$f":"E$24","v":2021},null,{"$f":"G$24","v":1.95E-2},{"$f":"H$24","v":2.35E-2},2.0130785333561111E-2,2.1000000000000001E-2]
[null,{"$f":"C$25","v":"2021-22"},null,{"$f":"D$25","v":"Aug- 20"},{"$f":"E$25","v":2022},null,{"$f":"G$25","v":1.125E-2},{"$f":"H$25","v":1.8750000000000003E-2},1.1532571098434436E-2,1.4E-2]
[null,{"$f":"C$26","v":"2022-23"},null,{"$f":"D$26","v":"Aug- 21"},{"$f":"E$26","v":2023},null,{"$f":"G$26","v":1.8750000000000003E-2},{"$f":"H$26","v":3.0000000000000006E-2},1.9640613997016533E-2,2.3E-2]
[null,{"$f":"C$27","v":"2023-24"},null,{"$f":"D$27","v":"Aug- 22"},{"$f":"E$27","v":2024},null,{"$f":"G$27","v":3.9E-2},{"$f":"H$27","v":4.2000000000000003E-2},4.470052661880123E-2,4.2000000000000003E-2]
[]
[]
[]
[]
[null,"Table 4","3-factor BCC, NSW total"]
[null,"NSW",null,null,null,null,{"$f":"G11","v":"Other costs"},{"$f":"H11","v":"Labour costs"},{"$f":"I11","v":"Asset costs"},"3-factor BCC"]
[null,"Weight",null,null,null,null,{"$f":"Inputs!E$38","v":0.4},{"$f":"Inputs!F$38","v":0.39},{"$f":"Inputs!G$38","v":0.20999999999999996},{"$f":"SUM(G72:I72)-1","v":0}]
[null,{"$f":"B19","v":2015},null,{"$f":"D19","v":"Aug- 14"},2016,null,{"$f":"G19","v":3.0000000000000002E-2},3.5000000000000003E-2]
[null,2016,null,"Aug- 15",2017,null,2.5000000000000001E-2,2.75E-2,{"$f":"I20","v":3.4108023173992572E-2},{"$f":"ROUND(SUMPRODUCT($G$72:$I$72,G74:I74),3)","v":2.8000000000000001E-2}]
[null,2017,null,"Aug- 16",2018,null,0.02,2.75E-2,2.8518854465380834E-2,{"$f":"ROUND(SUMPRODUCT($G$72:$I$72,G75:I75),3)","v":2.5000000000000001E-2}]
[null,2018,null,"Aug- 17",2019,null,2.375E-2,2.5000000000000001E-2,2.2925549980610933E-2,2.4E-2]
[null,2019,null,"Aug- 18",2020,null,2.2499999999999999E-2,2.75E-2,1.9829266468401122E-2,2.4E-2]
[null,2020,null,"Aug- 19",2021,null,1.95E-2,2.35E-2,2.0130785333561111E-2,2.1000000000000001E-2]
[null,2021,null,"Aug- 20",2022,null,1.125E-2,1.8750000000000003E-2,1.1532571098434436E-2,1.4E-2]
[null,2022,null,"Aug- 21",2023,null,1.8750000000000003E-2,3.0000000000000006E-2,1.9640613997016533E-2,2.3E-2]
[null,2023,null,"Aug- 22",2024,null,3.9E-2,4.2000000000000003E-2,4.470052661880123E-2,4.1000000000000002E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"#REF!+1","v":{"$error":"#REF!"}}]

{"sheet":"BCC Preferred with true-up","index":12,"n_rows":98,"n_cols":10,"rows_kept":98,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"Cover!$B$3","v":"Review of rate peg methodology - Draft report Base Cost Change (BCC) options"}]
[]
[null,"Calculation of Preferred BCC with true-ups"]
[null," "]
[]
[]
[null,"Table 1","Selected changes in costs"]
[]
[]
[null,{"$f":"Inputs!B44","v":"BCC for 1 July "},{"$f":"Inputs!C44","v":"BCC for FY"},{"$f":"Inputs!D44","v":"Report date for forecasts"},{"$f":"Inputs!E44","v":"Forecast to June"},null,"Other costs","Labour costs","Asset costs"]
[]
[]
[null,"Selected option",null,null,null,null,{"$f":"Inputs!L47","v":"RBA CPI  forecast + CPI  true-up"},{"$f":"Inputs!P70","v":"Award with RBA forecast and true-up"},"Forecast PPI\" + true-up"]
[null,{"$f":"Inputs!B48","v":2011},{"$f":"Inputs!C48","v":"2011-12"},{"$f":"Inputs!D48","v":"Aug- 10"},{"$f":"Inputs!E48","v":2012},null,null,{"$f":"Inputs!P71","v":2.1499999999999998E-2}]
[null,{"$f":"Inputs!B49","v":2012},{"$f":"Inputs!C49","v":"2012-13"},{"$f":"Inputs!D49","v":"Aug- 11"},{"$f":"Inputs!E49","v":2013},null,null,{"$f":"Inputs!P72","v":3.2500000000000001E-2}]
[null,{"$f":"Inputs!B50","v":2013},{"$f":"Inputs!C50","v":"2013-14"},{"$f":"Inputs!D50","v":"Aug- 12"},{"$f":"Inputs!E50","v":2014},null,{"$f":"Inputs!L50","v":1.9273791250959439E-2},{"$f":"Inputs!P73","v":3.5000000000000003E-2}]
[null,{"$f":"Inputs!B51","v":2014},{"$f":"Inputs!C51","v":"2014-15"},{"$f":"Inputs!D51","v":"Aug- 13"},{"$f":"Inputs!E51","v":2015},null,{"$f":"Inputs!L51","v":1.1505688922230674E-2},{"$f":"Inputs!P74","v":3.7500000000000006E-2}]
[null,{"$f":"Inputs!B52","v":2015},{"$f":"Inputs!C52","v":"2015-16"},{"$f":"Inputs!D52","v":"Aug- 14"},{"$f":"Inputs!E52","v":2016},null,{"$f":"Inputs!L52","v":3.2139364303178319E-2},{"$f":"Inputs!P75","v":1.8000000000000002E-2}]
[null,{"$f":"Inputs!B53","v":2016},{"$f":"Inputs!C53","v":"2016-17"},{"$f":"Inputs!D53","v":"Aug- 15"},{"$f":"Inputs!E53","v":2017},null,{"$f":"Inputs!L53","v":1.7138776481790075E-2},{"$f":"Inputs!P76","v":2.7999999999999997E-2},{"$f":"Inputs!$M120","v":1.6327661019121868E-2}]
[null,{"$f":"Inputs!B54","v":2017},{"$f":"Inputs!C54","v":"2017-18"},{"$f":"Inputs!D54","v":"Aug- 16"},{"$f":"Inputs!E54","v":2018},null,{"$f":"Inputs!L54","v":3.8076293002575826E-3},{"$f":"Inputs!P77","v":2.75E-2},{"$f":"Inputs!$M121","v":-2.8658914356614017E-3}]
[null,{"$f":"Inputs!B55","v":2018},{"$f":"Inputs!C55","v":"2018-19"},{"$f":"Inputs!D55","v":"Aug- 17"},{"$f":"Inputs!E55","v":2019},null,{"$f":"Inputs!L55","v":1.5832179132040353E-2},{"$f":"Inputs!P78","v":2.1000000000000001E-2},{"$f":"Inputs!$M122","v":-1.828149670680259E-3}]
[null,{"$f":"Inputs!B56","v":2019},{"$f":"Inputs!C56","v":"2019-20"},{"$f":"Inputs!D56","v":"Aug- 18"},{"$f":"Inputs!E56","v":2020},null,{"$f":"Inputs!L56","v":2.1791874716296008E-2},{"$f":"Inputs!P79","v":2.5000000000000001E-2},{"$f":"Inputs!$M123","v":1.2558151605190254E-2}]
[null,{"$f":"Inputs!B57","v":2020},{"$f":"Inputs!C57","v":"2020-21"},{"$f":"Inputs!D57","v":"Aug- 19"},{"$f":"Inputs!E57","v":2021},null,{"$f":"Inputs!L57","v":1.2227399242930346E-2},{"$f":"Inputs!P80","v":2.35E-2},{"$f":"Inputs!$M124","v":3.4832504055915911E-2}]
[null,{"$f":"Inputs!B58","v":2021},{"$f":"Inputs!C58","v":"2021-22"},{"$f":"Inputs!D58","v":"Aug- 20"},{"$f":"Inputs!E58","v":2022},null,{"$f":"Inputs!L58","v":2.1125410733844156E-3},{"$f":"Inputs!P81","v":1.6500000000000004E-2},{"$f":"Inputs!$M125","v":-8.3082506279940835E-4}]
[null,{"$f":"Inputs!B59","v":2022},{"$f":"Inputs!C59","v":"2022-23"},{"$f":"Inputs!D59","v":"Aug- 21"},{"$f":"Inputs!E59","v":2023},null,{"$f":"Inputs!L59","v":1.5462710765239893E-2},{"$f":"Inputs!P82","v":2.5000000000000005E-2},{"$f":"Inputs!$M126","v":1.0943239631060508E-2}]
[null,{"$f":"Inputs!B60","v":2023},{"$f":"Inputs!C60","v":"2023-24"},{"$f":"Inputs!D60","v":"Aug- 22"},{"$f":"Inputs!E60","v":2024},null,{"$f":"Inputs!L60","v":7.2208625824292716E-2},{"$f":"Inputs!P83","v":4.2000000000000003E-2},{"$f":"Inputs!$M127","v":8.5502056420513367E-2}]
[]
[]
[null,"Table 2","3-factor BCC 3 groups"]
[null,"Metropolitan",null,{"$f":"D$11","v":"Report date for forecasts"},{"$f":"E$11","v":"Forecast to June"},null,{"$f":"G11","v":"Other costs"},{"$f":"H11","v":"Labour costs"},"Asset costs","3-factor BCC"]
[null,"Selected option",null,null,null,null,null,null,null,"(rounded)"]
[null,"Weight",null,null,null,null,{"$f":"Inputs!E$31","v":0.41},{"$f":"Inputs!F$31","v":0.41},{"$f":"Inputs!G$31","v":0.18000000000000005},{"$f":"SUM(G33:I33)-1","v":0}]
[null,{"$f":"C$20","v":"2016-17"},null,{"$f":"D$20","v":"Aug- 15"},{"$f":"E$20","v":2017},null,{"$f":"G$20","v":1.7138776481790075E-2},{"$f":"H$20","v":2.7999999999999997E-2},{"$f":"I$20","v":1.6327661019121868E-2},{"$f":"ROUND(SUMPRODUCT($G$33:$I$33,G34:I34),3)","v":2.1000000000000001E-2}]
[null,{"$f":"C$21","v":"2017-18"},null,{"$f":"D$21","v":"Aug- 16"},{"$f":"E$21","v":2018},null,{"$f":"G$21","v":3.8076293002575826E-3},{"$f":"H$21","v":2.75E-2},{"$f":"I21","v":-2.8658914356614017E-3},{"$f":"ROUND(SUMPRODUCT($G$33:$I$33,G35:I35),3)","v":1.2E-2}]
[null,{"$f":"C$22","v":"2018-19"},null,{"$f":"D$22","v":"Aug- 17"},{"$f":"E$22","v":2019},null,{"$f":"G$22","v":1.5832179132040353E-2},{"$f":"H$22","v":2.1000000000000001E-2},-1.828149670680259E-3,1.4999999999999999E-2]
[null,{"$f":"C$23","v":"2019-20"},null,{"$f":"D$23","v":"Aug- 18"},{"$f":"E$23","v":2020},null,{"$f":"G$23","v":2.1791874716296008E-2},{"$f":"H$23","v":2.5000000000000001E-2},1.2558151605190254E-2,2.1000000000000001E-2]
[null,{"$f":"C$24","v":"2020-21"},null,{"$f":"D$24","v":"Aug- 19"},{"$f":"E$24","v":2021},null,{"$f":"G$24","v":1.2227399242930346E-2},{"$f":"H$24","v":2.35E-2},3.4832504055915911E-2,2.1000000000000001E-2]
[null,{"$f":"C$25","v":"2021-22"},null,{"$f":"D$25","v":"Aug- 20"},{"$f":"E$25","v":2022},null,{"$f":"G$25","v":2.1125410733844156E-3},{"$f":"H$25","v":1.6500000000000004E-2},-8.3082506279940835E-4,7.0000000000000001E-3]
[null,{"$f":"C$26","v":"2022-23"},null,{"$f":"D$26","v":"Aug- 21"},{"$f":"E$26","v":2023},null,{"$f":"G$26","v":1.5462710765239893E-2},{"$f":"H$26","v":2.5000000000000005E-2},1.0943239631060508E-2,1.9E-2]
[null,{"$f":"C$27","v":"2023-24"},null,{"$f":"D$27","v":"Aug- 22"},{"$f":"E$27","v":2024},null,{"$f":"G$27","v":7.2208625824292716E-2},{"$f":"H$27","v":4.2000000000000003E-2},8.5502056420513367E-2,6.2E-2]
[]
[null,{"$f":"Inputs!$B$34","v":"Regional "}]
[null,"Selected option"]
[null,"Weight",null,null,null,null,{"$f":"Inputs!E$34","v":0.4},{"$f":"Inputs!F$34","v":0.37},{"$f":"Inputs!G$34","v":0.22999999999999998},{"$f":"SUM(G45:I45)-1","v":0}]
[null,{"$f":"C$20","v":"2016-17"},null,{"$f":"D$20","v":"Aug- 15"},{"$f":"E$20","v":2017},null,{"$f":"G$20","v":1.7138776481790075E-2},{"$f":"H$20","v":2.7999999999999997E-2},{"$f":"I20","v":1.6327661019121868E-2},{"$f":"ROUND(SUMPRODUCT($G$45:$I$45,G46:I46),3)","v":2.1000000000000001E-2}]
[null,{"$f":"C$21","v":"2017-18"},null,{"$f":"D$21","v":"Aug- 16"},{"$f":"E$21","v":2018},null,{"$f":"G$21","v":3.8076293002575826E-3},{"$f":"H$21","v":2.75E-2},-2.8658914356614017E-3,{"$f":"ROUND(SUMPRODUCT($G$45:$I$45,G47:I47),3)","v":1.0999999999999999E-2}]
[null,{"$f":"C$22","v":"2018-19"},null,{"$f":"D$22","v":"Aug- 17"},{"$f":"E$22","v":2019},null,{"$f":"G$22","v":1.5832179132040353E-2},{"$f":"H$22","v":2.1000000000000001E-2},-1.828149670680259E-3,1.4E-2]
[null,{"$f":"C$23","v":"2019-20"},null,{"$f":"D$23","v":"Aug- 18"},{"$f":"E$23","v":2020},null,{"$f":"G$23","v":2.1791874716296008E-2},{"$f":"H$23","v":2.5000000000000001E-2},1.2558151605190254E-2,2.1000000000000001E-2]
[null,{"$f":"C$24","v":"2020-21"},null,{"$f":"D$24","v":"Aug- 19"},{"$f":"E$24","v":2021},null,{"$f":"G$24","v":1.2227399242930346E-2},{"$f":"H$24","v":2.35E-2},3.4832504055915911E-2,2.1999999999999999E-2]
[null,{"$f":"C$25","v":"2021-22"},null,{"$f":"D$25","v":"Aug- 20"},{"$f":"E$25","v":2022},null,{"$f":"G$25","v":2.1125410733844156E-3},{"$f":"H$25","v":1.6500000000000004E-2},-8.3082506279940835E-4,7.0000000000000001E-3]
[null,{"$f":"C$26","v":"2022-23"},null,{"$f":"D$26","v":"Aug- 21"},{"$f":"E$26","v":2023},null,{"$f":"G$26","v":1.5462710765239893E-2},{"$f":"H$26","v":2.5000000000000005E-2},1.0943239631060508E-2,1.7999999999999999E-2]
[null,{"$f":"C$27","v":"2023-24"},null,{"$f":"D$27","v":"Aug- 22"},{"$f":"E$27","v":2024},null,{"$f":"G$27","v":7.2208625824292716E-2},{"$f":"H$27","v":4.2000000000000003E-2},8.5502056420513367E-2,6.4000000000000001E-2]
[]
[null,{"$f":"Inputs!$B$35","v":"Rural"}]
[null,"Selected option"]
[null,"Weight",null,null,null,null,{"$f":"Inputs!E$35","v":0.38},{"$f":"Inputs!F$35","v":0.36},{"$f":"Inputs!G$35","v":0.26},{"$f":"SUM(G57:I57)-1","v":0}]
[null,{"$f":"C$20","v":"2016-17"},null,{"$f":"D$20","v":"Aug- 15"},{"$f":"E$20","v":2017},null,{"$f":"G$20","v":1.7138776481790075E-2},{"$f":"H$20","v":2.7999999999999997E-2},{"$f":"I20","v":1.6327661019121868E-2},{"$f":"ROUND(SUMPRODUCT($G$57:$I$57,G58:I58),3)","v":2.1000000000000001E-2}]
[null,{"$f":"C$21","v":"2017-18"},null,{"$f":"D$21","v":"Aug- 16"},{"$f":"E$21","v":2018},null,{"$f":"G$21","v":3.8076293002575826E-3},{"$f":"H$21","v":2.75E-2},-2.8658914356614017E-3,{"$f":"ROUND(SUMPRODUCT($G$57:$I$57,G59:I59),3)","v":1.0999999999999999E-2}]
[null,{"$f":"C$22","v":"2018-19"},null,{"$f":"D$22","v":"Aug- 17"},{"$f":"E$22","v":2019},null,{"$f":"G$22","v":1.5832179132040353E-2},{"$f":"H$22","v":2.1000000000000001E-2},-1.828149670680259E-3,1.2999999999999999E-2]
[null,{"$f":"C$23","v":"2019-20"},null,{"$f":"D$23","v":"Aug- 18"},{"$f":"E$23","v":2020},null,{"$f":"G$23","v":2.1791874716296008E-2},{"$f":"H$23","v":2.5000000000000001E-2},1.2558151605190254E-2,2.1000000000000001E-2]
[null,{"$f":"C$24","v":"2020-21"},null,{"$f":"D$24","v":"Aug- 19"},{"$f":"E$24","v":2021},null,{"$f":"G$24","v":1.2227399242930346E-2},{"$f":"H$24","v":2.35E-2},3.4832504055915911E-2,2.1999999999999999E-2]
[null,{"$f":"C$25","v":"2021-22"},null,{"$f":"D$25","v":"Aug- 20"},{"$f":"E$25","v":2022},null,{"$f":"G$25","v":2.1125410733844156E-3},{"$f":"H$25","v":1.6500000000000004E-2},-8.3082506279940835E-4,7.0000000000000001E-3]
[null,{"$f":"C$26","v":"2022-23"},null,{"$f":"D$26","v":"Aug- 21"},{"$f":"E$26","v":2023},null,{"$f":"G$26","v":1.5462710765239893E-2},{"$f":"H$26","v":2.5000000000000005E-2},1.0943239631060508E-2,1.7999999999999999E-2]
[null,{"$f":"C$27","v":"2023-24"},null,{"$f":"D$27","v":"Aug- 22"},{"$f":"E$27","v":2024},null,{"$f":"G$27","v":7.2208625824292716E-2},{"$f":"H$27","v":4.2000000000000003E-2},8.5502056420513367E-2,6.5000000000000002E-2]
[]
[]
[]
[]
[null,"Table 4","3-factor BCC, NSW total"]
[null,"NSW",null,null,null,null,{"$f":"G11","v":"Other costs"},{"$f":"H11","v":"Labour costs"},{"$f":"I11","v":"Asset costs"},"3-factor BCC"]
[null,"Weight",null,null,null,null,{"$f":"Inputs!E$38","v":0.4},{"$f":"Inputs!F$38","v":0.39},{"$f":"Inputs!G$38","v":0.20999999999999996},{"$f":"SUM(G72:I72)-1","v":0}]
[null,{"$f":"B19","v":2015},null,{"$f":"D19","v":"Aug- 14"},2016,null,{"$f":"G19","v":3.2139364303178319E-2},1.8000000000000002E-2]
[null,2016,null,"Aug- 15",2017,null,1.7138776481790075E-2,2.7999999999999997E-2,{"$f":"I20","v":1.6327661019121868E-2},{"$f":"ROUND(SUMPRODUCT($G$72:$I$72,G74:I74),3)","v":2.1000000000000001E-2}]
[null,2017,null,"Aug- 16",2018,null,3.8076293002575826E-3,2.75E-2,-2.8658914356614017E-3,{"$f":"ROUND(SUMPRODUCT($G$72:$I$72,G75:I75),3)","v":1.2E-2}]
[null,2018,null,"Aug- 17",2019,null,1.5832179132040353E-2,2.1000000000000001E-2,-1.828149670680259E-3,1.4E-2]
[null,2019,null,"Aug- 18",2020,null,2.1791874716296008E-2,2.5000000000000001E-2,1.2558151605190254E-2,2.1000000000000001E-2]
[null,2020,null,"Aug- 19",2021,null,1.2227399242930346E-2,2.35E-2,3.4832504055915911E-2,2.1000000000000001E-2]
[null,2021,null,"Aug- 20",2022,null,2.1125410733844156E-3,1.6500000000000004E-2,-8.3082506279940835E-4,7.0000000000000001E-3]
[null,2022,null,"Aug- 21",2023,null,1.5462710765239893E-2,2.5000000000000005E-2,1.0943239631060508E-2,1.7999999999999999E-2]
[null,2023,null,"Aug- 22",2024,null,7.2208625824292716E-2,4.2000000000000003E-2,8.5502056420513367E-2,6.3E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"#REF!+1","v":{"$error":"#REF!"}}]