{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Examples","USER GUIDE","INPUT","RESULTS","CALC","CONVERSION","DO NOT DELETE"],"not_rendered":{"charts":16,"images":13,"macros":1,"external_links":0,"defined_names":12,"comments":1,"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":42,"n_cols":27,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
["IPART COLOUR CODES  FOR MODELS 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"]
[null,"Option 1 (best for models that will be used repeatedly)",null,null,null,null,{"$f":"G22","v":"numbers"},{"$f":"H22","v":"%"},"Option 2 (best for smaller models for once-off and/or own use)"]
[null,"Inputs",null,null,null,null,4442,0.08,"Inputs",67,0.03]
[null,"Links from other files (green)",null,null,null,null,null,null,{"$f":"B9","v":"Links from other files (green)"}]
[null,"Error check (check =0)",null,null,null,null,null,null,"Error check (check =0)"]
[null,"Error warnings, messages and unusual calculation assumptions",null,null,null,null,null,null,{"$f":"B11","v":"Error warnings, messages and unusual calculation assumptions"}]
[null,"Indicate change in formula across row with a double red line",null,null,null,null,null,null,"..change in formula across row with a double red line"]
[null,"Key outputs",null,null,null,null,null,null,{"$f":"B13","v":"Key outputs"}]
[null,"Note: can combine options, eg:"]
[null,"Example 1",null,"Inputs for model runs",null,"AND"]
[null,null,"Hard-coded protected inputs that can't be changed (eg credit ratio and ratings tables)"]
[]
[null,"Example 2",null,"Inputs can be links to other files in some runs"]
[null,null,null,"Attention can be drawn to different/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,"compulsory inputs (numbers and text)",null,null,null,null,234,0.24]
[null,"Forecast Inputs",null,null,null,null,667,0.05]
[null,"Error warnings and messages"]
[null,"Error check (check =0)"]
[]
[null,"QA notes - annotation or documenation by QA staff"]
[]
[]
["User Instructions - IPART CHARTS"]
[]
[null,"Dark blue","Lime","Red","Blue","Light gold","Green","Maroon","Light blue",null,null,"Blue solid","Lime solid","Red solid ","Blue  dashes","Lime  dashes ","Red  dashes",null,"X value","1st Y value","2nd Y value",null,null,"Black","Red 100%","Red 70%","Grey 40%"]
["1975-76",36.19,36.880000000000003,21.56,5.36,3.01,10,3.01,10,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,3.36,12,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,2.63,14,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,2.72,16,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,2.57,18,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.36,12,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,2.72,16,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,2,20,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":"USER GUIDE","index":1,"n_rows":206,"n_cols":2,"rows_kept":206,"cut":false,"hidden":false,"merged":[[204,1,204,17],[205,1,205,17]]}
[]
[null,"LANDHOLDER COMPENSATION MODEL"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"a NSW Department of Primary Industries, Leasing land - calculating a rental, January 2007, available at http://www.dpi.nsw.gov.au/__data/assets/pdf_file/0017/104093/leasing-land-calculating-a-rental.pdf  accessed 16 November 2015 "]
[null,"b IPART, Review of external benefits of public transport - Draft report, December 2014, p 36, available at http://www.ipart.nsw.gov.au/Home/Industries/Transport/Reviews/External_Benefits_of_Public_Transport/External_Benefits_for_Public_Transport/16_Dec_2014_-_Draft_Report/Draft_Report_-_Review_of_external_benefits_of_public_transport_-_December_2014 accessed 16 November 2015"]

{"sheet":"INPUT","index":2,"n_rows":36,"n_cols":37,"rows_kept":36,"cut":false,"hidden":false,"merged":[[30,1,30,3],[3,1,3,2],[35,1,35,8]]}
[null,"INPUTS"]
[null,"PART A.  Inputs for Compensation Payments"]
[null,"PLEASE ENTER VALUES ONLY IN COLOURED CELLS",null,"Unit","Fixed input",null,null,"Access Agreement Year"]
[null,null,null,null,null,null,{"$f":"IF('DO NOT DELETE'!A11<=Access_Period,'DO NOT DELETE'!A11,IF(AND(Access_Period>0,'DO NOT DELETE'!A11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":1},{"$f":"IF('DO NOT DELETE'!B11<=Access_Period,'DO NOT DELETE'!B11,IF(AND(Access_Period>0,'DO NOT DELETE'!B11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":2},{"$f":"IF('DO NOT DELETE'!C11<=Access_Period,'DO NOT DELETE'!C11,IF(AND(Access_Period>0,'DO NOT DELETE'!C11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":3},{"$f":"IF('DO NOT DELETE'!D11<=Access_Period,'DO NOT DELETE'!D11,IF(AND(Access_Period>0,'DO NOT DELETE'!D11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":4},{"$f":"IF('DO NOT DELETE'!E11<=Access_Period,'DO NOT DELETE'!E11,IF(AND(Access_Period>0,'DO NOT DELETE'!E11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":5},{"$f":"IF('DO NOT DELETE'!F11<=Access_Period,'DO NOT DELETE'!F11,IF(AND(Access_Period>0,'DO NOT DELETE'!F11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":6},{"$f":"IF('DO NOT DELETE'!G11<=Access_Period,'DO NOT DELETE'!G11,IF(AND(Access_Period>0,'DO NOT DELETE'!G11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":7},{"$f":"IF('DO NOT DELETE'!H11<=Access_Period,'DO NOT DELETE'!H11,IF(AND(Access_Period>0,'DO NOT DELETE'!H11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":8},{"$f":"IF('DO NOT DELETE'!I11<=Access_Period,'DO NOT DELETE'!I11,IF(AND(Access_Period>0,'DO NOT DELETE'!I11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":9},{"$f":"IF('DO NOT DELETE'!J11<=Access_Period,'DO NOT DELETE'!J11,IF(AND(Access_Period>0,'DO NOT DELETE'!J11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":10},{"$f":"IF('DO NOT DELETE'!K11<=Access_Period,'DO NOT DELETE'!K11,IF(AND(Access_Period>0,'DO NOT DELETE'!K11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":11},{"$f":"IF('DO NOT DELETE'!L11<=Access_Period,'DO NOT DELETE'!L11,IF(AND(Access_Period>0,'DO NOT DELETE'!L11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":12},{"$f":"IF('DO NOT DELETE'!M11<=Access_Period,'DO NOT DELETE'!M11,IF(AND(Access_Period>0,'DO NOT DELETE'!M11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":13},{"$f":"IF('DO NOT DELETE'!N11<=Access_Period,'DO NOT DELETE'!N11,IF(AND(Access_Period>0,'DO NOT DELETE'!N11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":14},{"$f":"IF('DO NOT DELETE'!O11<=Access_Period,'DO NOT DELETE'!O11,IF(AND(Access_Period>0,'DO NOT DELETE'!O11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":15},{"$f":"IF('DO NOT DELETE'!P11<=Access_Period,'DO NOT DELETE'!P11,IF(AND(Access_Period>0,'DO NOT DELETE'!P11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":16},{"$f":"IF('DO NOT DELETE'!Q11<=Access_Period,'DO NOT DELETE'!Q11,IF(AND(Access_Period>0,'DO NOT DELETE'!Q11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":17},{"$f":"IF('DO NOT DELETE'!R11<=Access_Period,'DO NOT DELETE'!R11,IF(AND(Access_Period>0,'DO NOT DELETE'!R11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":18},{"$f":"IF('DO NOT DELETE'!S11<=Access_Period,'DO NOT DELETE'!S11,IF(AND(Access_Period>0,'DO NOT DELETE'!S11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":19},{"$f":"IF('DO NOT DELETE'!T11<=Access_Period,'DO NOT DELETE'!T11,IF(AND(Access_Period>0,'DO NOT DELETE'!T11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":20},{"$f":"IF('DO NOT DELETE'!U11<=Access_Period,'DO NOT DELETE'!U11,IF(AND(Access_Period>0,'DO NOT DELETE'!U11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":"Rehabilitation"},{"$f":"IF('DO NOT DELETE'!V11<=Access_Period,'DO NOT DELETE'!V11,IF(AND(Access_Period>0,'DO NOT DELETE'!V11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":""},{"$f":"IF('DO NOT DELETE'!W11<=Access_Period,'DO NOT DELETE'!W11,IF(AND(Access_Period>0,'DO NOT DELETE'!W11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":""},{"$f":"IF('DO NOT DELETE'!X11<=Access_Period,'DO NOT DELETE'!X11,IF(AND(Access_Period>0,'DO NOT DELETE'!X11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":""},{"$f":"IF('DO NOT DELETE'!Y11<=Access_Period,'DO NOT DELETE'!Y11,IF(AND(Access_Period>0,'DO NOT DELETE'!Y11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":""},{"$f":"IF('DO NOT DELETE'!Z11<=Access_Period,'DO NOT DELETE'!Z11,IF(AND(Access_Period>0,'DO NOT DELETE'!Z11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":""},{"$f":"IF('DO NOT DELETE'!AA11<=Access_Period,'DO NOT DELETE'!AA11,IF(AND(Access_Period>0,'DO NOT DELETE'!AA11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":""},{"$f":"IF('DO NOT DELETE'!AB11<=Access_Period,'DO NOT DELETE'!AB11,IF(AND(Access_Period>0,'DO NOT DELETE'!AB11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":""},{"$f":"IF('DO NOT DELETE'!AC11<=Access_Period,'DO NOT DELETE'!AC11,IF(AND(Access_Period>0,'DO NOT DELETE'!AC11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":""},{"$f":"IF('DO NOT DELETE'!AD11<=Access_Period,'DO NOT DELETE'!AD11,IF(AND(Access_Period>0,'DO NOT DELETE'!AD11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":""},{"$f":"IF('DO NOT DELETE'!AE11<=Access_Period,'DO NOT DELETE'!AE11,IF(AND(Access_Period>0,'DO NOT DELETE'!AE11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":""}]
[null,"1. Land access agreement details"]
[null,null,"How long is your access agreement for? (Maximum is 30 years)","Year",20]
[null,"2. Landholding details"]
[null,null,"What is the total area of your land in hectares? If you have land area in a different unit, use the \"CONVERSION\" worksheet to convert into hectares.","Hectare",200]
[null,null,"What is the estimated value of your land per hectare in nominal terms (ie, including inflation)? If you have land value in a different unit, use the \"CONVERSION\" worksheet to convert into $/hectare.","Dollar per hectare",null,null,15000,null,null,null,18000]
[null,null,"What is the rental value of land as a percentage of land value?","Percent",null,null,0.08,null,null,null,0.09]
[null,"3. Estimated impacts"]
[null,"(a) ","Directly impacted land"]
[null,null,"What is the total area of land used by gas company?","Hectare",null,null,10,5.25]
[null,"(b) ","Residual land (your total land area excluding directly impacted land)"]
[null,null,"What is an estimated reduction in the value of residual land due to severance?","Percent",null,null,0,0]
[null,null,"What is an estimated reduction in the value of residual land due to injurious affection?","Percent",null,null,0.2,0.1]
[null,"(c)","How long is the rehabilitation period?","Weeks",52]
[null,"4.  Cost of landholder time and expert advice"]
[null,null,"How many hours did you spend negotiating your access agreement?","Hours in total",150]
[null,null,"How many hours do you expect to spend each year on matters related to you access agreement?","Hours per annum",50]
[null,null,"Enter an estimate of the value of your time","Per hour",50]
[null,null,"How much did you spend on fees for professional advice including GST?","Per agreement",40000]
[null,"5. Other assumption"]
[null,null,"What rate of return would you expect to earn on financial investments per year in nominal terms? You need this input only if you wish to calculate a lump-sum upfront payment.","Percent per annum",3.5000000000000003E-2]
[null,null,"Inflation rate","Percent",2.5000000000000001E-2]
[null,"PART B.  Inputs for Benefit Payments"]
[null,"PLEASE ENTER VALUES ONLY IN COLOURED CELLS",null,"Unit","Fixed input",null,null,"Access Agreement Year"]
[null,null,null,null,null,null,{"$f":"IF('DO NOT DELETE'!A11<=Access_Period,'DO NOT DELETE'!A11,\"\")","v":1},{"$f":"IF('DO NOT DELETE'!B11<=Access_Period,'DO NOT DELETE'!B11,\"\")","v":2},{"$f":"IF('DO NOT DELETE'!C11<=Access_Period,'DO NOT DELETE'!C11,\"\")","v":3},{"$f":"IF('DO NOT DELETE'!D11<=Access_Period,'DO NOT DELETE'!D11,\"\")","v":4},{"$f":"IF('DO NOT DELETE'!E11<=Access_Period,'DO NOT DELETE'!E11,\"\")","v":5},{"$f":"IF('DO NOT DELETE'!F11<=Access_Period,'DO NOT DELETE'!F11,\"\")","v":6},{"$f":"IF('DO NOT DELETE'!G11<=Access_Period,'DO NOT DELETE'!G11,\"\")","v":7},{"$f":"IF('DO NOT DELETE'!H11<=Access_Period,'DO NOT DELETE'!H11,\"\")","v":8},{"$f":"IF('DO NOT DELETE'!I11<=Access_Period,'DO NOT DELETE'!I11,\"\")","v":9},{"$f":"IF('DO NOT DELETE'!J11<=Access_Period,'DO NOT DELETE'!J11,\"\")","v":10},{"$f":"IF('DO NOT DELETE'!K11<=Access_Period,'DO NOT DELETE'!K11,\"\")","v":11},{"$f":"IF('DO NOT DELETE'!L11<=Access_Period,'DO NOT DELETE'!L11,\"\")","v":12},{"$f":"IF('DO NOT DELETE'!M11<=Access_Period,'DO NOT DELETE'!M11,\"\")","v":13},{"$f":"IF('DO NOT DELETE'!N11<=Access_Period,'DO NOT DELETE'!N11,\"\")","v":14},{"$f":"IF('DO NOT DELETE'!O11<=Access_Period,'DO NOT DELETE'!O11,\"\")","v":15},{"$f":"IF('DO NOT DELETE'!P11<=Access_Period,'DO NOT DELETE'!P11,\"\")","v":16},{"$f":"IF('DO NOT DELETE'!Q11<=Access_Period,'DO NOT DELETE'!Q11,\"\")","v":17},{"$f":"IF('DO NOT DELETE'!R11<=Access_Period,'DO NOT DELETE'!R11,\"\")","v":18},{"$f":"IF('DO NOT DELETE'!S11<=Access_Period,'DO NOT DELETE'!S11,\"\")","v":19},{"$f":"IF('DO NOT DELETE'!T11<=Access_Period,'DO NOT DELETE'!T11,\"\")","v":20},{"$f":"IF('DO NOT DELETE'!U11<=Access_Period,'DO NOT DELETE'!U11,\"\")","v":""},{"$f":"IF('DO NOT DELETE'!V11<=Access_Period,'DO NOT DELETE'!V11,\"\")","v":""},{"$f":"IF('DO NOT DELETE'!W11<=Access_Period,'DO NOT DELETE'!W11,\"\")","v":""},{"$f":"IF('DO NOT DELETE'!X11<=Access_Period,'DO NOT DELETE'!X11,\"\")","v":""},{"$f":"IF('DO NOT DELETE'!Y11<=Access_Period,'DO NOT DELETE'!Y11,\"\")","v":""},{"$f":"IF('DO NOT DELETE'!Z11<=Access_Period,'DO NOT DELETE'!Z11,\"\")","v":""},{"$f":"IF('DO NOT DELETE'!AA11<=Access_Period,'DO NOT DELETE'!AA11,\"\")","v":""},{"$f":"IF('DO NOT DELETE'!AB11<=Access_Period,'DO NOT DELETE'!AB11,\"\")","v":""},{"$f":"IF('DO NOT DELETE'!AC11<=Access_Period,'DO NOT DELETE'!AC11,\"\")","v":""},{"$f":"IF('DO NOT DELETE'!AD11<=Access_Period,'DO NOT DELETE'!AD11,\"\")","v":""},{"$f":"IF('DO NOT DELETE'!AE11<=Access_Period,'DO NOT DELETE'!AE11,\"\")","v":""}]
[null,"What is your benefit payment based on?",null,null,1]
[null,null,"In which year from Year 2 to Year 10 is the gas project expected to enter the production stage?","Year",4]
[null,{"$f":"\"Provide inputs below from Year \" &Production_Year","v":"Provide inputs below from Year 4"}]
[null,null,{"$f":"IF($E$29=1,'DO NOT DELETE'!$B$5:$B$7,IF($E$29=2,'DO NOT DELETE'!$C$5:$C$7,'DO NOT DELETE'!$D$5:$D$7))","v":"Gas company's statutory annual royalty payment  in nominal terms (ie, including inflation)"},{"$f":"IF($E$29=1,'DO NOT DELETE'!$B$14:$B$16,IF($E$29=2,'DO NOT DELETE'!$C$14:$C$16,'DO NOT DELETE'!$D$14:$D$16))","v":"Dollar per annum"},null,null,null,null,null,1500000]
[null,null,"% of royalty gas company contributes to incentive fund","Percent",null,null,null,null,null,5]
[null,null,"Total licence area for production","Hectares",null,null,null,null,null,22]
[]
[null,"Disclaimer:  This model was developed by the Independent Pricing and Regulatory Tribunal (IPART) as a benchmark guide for landholders in NSW.  We recommend that landholders seek professional advice when negotiating a land access and compensation agreement."]

{"sheet":"RESULTS","index":3,"n_rows":106,"n_cols":10,"rows_kept":106,"cut":false,"hidden":false,"merged":[[4,1,4,3],[2,5,2,7],[2,9,2,15],[2,1,2,2],[4,5,4,7],[3,5,3,7]]}
[null,"RESULTS"]
[null,"PART A. Compensation Payments",null,null,null,"PART B. Benefit Payments",null,null,null,"PART C.  Payment Schedule"]
[null,"Please select an option to get an estimate of your compensation.  Select \"Lump-sum Upfront Payment\" to get a single upfront payment. Select \"Annual Payments\" for a series of annual payments.  ",null,null,null,"A schedule of your benefit payments is provided below.  ",null,null,null,"The graph below shows compensation payment schedule over your access agreement period."]
[null,"Payment Structure: "]
[null,"Note: Where the costs of expert advice have been incurred by landholders, the first year compensation is higher due to the inclusion of the reimbursment of the costs of expert advice.",null,null,null,"Note: This model assumes the provision of benefit payments during the production stage of a CSG project.  Benefit payments are not mandatory and gas companies may choose to provide other in-kind benefits.  "]
[{"$f":"MAX(COUNT(B7:B106),COUNT(F7:F106))","v":20},"Beginning of Year","Annual Payment ($Nominal)",null,null,"Beginning of Year","Annual Payment ($Nominal)"]
[1,{"$f":"TRANSPOSE(CALC!D23:AH23)","v":1},{"$f":"TRANSPOSE(CALC!D28:AH28)","v":105100},null,null,{"$f":"TRANSPOSE(CALC!D36:AH36)","v":1},{"$f":"TRANSPOSE(CALC!D37:AH37)","v":""}]
[2,2,32974.25,null,null,2,""]
[3,3,33798.606249999997,null,null,3,""]
[4,4,34643.57140624999,null,null,4,""]
[5,5,42814.0322265625,null,null,5,17897.727272727272]
[6,6,43884.383032226564,null,null,6,18345.170454545452]
[7,7,44981.492608032226,null,null,7,18803.799715909088]
[8,8,46106.029923233036,null,null,8,19273.894708806813]
[9,9,47258.680671313858,null,null,9,19755.742076526978]
[10,10,48440.147688096687,null,null,10,20249.635628440152]
[11,11,49651.151380299103,null,null,11,20755.876519151152]
[12,12,50892.430164806574,null,null,12,21274.773432129932]
[13,13,52164.740918926742,null,null,13,21806.642767933175]
[14,14,53468.859441899906,null,null,14,22351.808837131503]
[15,15,54805.580927947398,null,null,15,22910.604058059791]
[16,16,56175.720451146073,null,null,16,23483.369159511283]
[17,17,57580.113462424721,null,null,17,24070.453388499063]
[18,18,59019.616298985347,null,null,18,24672.214723211535]
[19,19,60495.106706459963,null,null,19,25289.020091291819]
[20,20,62007.484374121457,null,null,20,25921.245593574113]
[21,"Rehabilitation",58010.85890999854,null,null,"",""]
[22,"","",null,null,"",""]
[23,"","",null,null,"",""]
[24,"","",null,null,"",""]
[25,"","",null,null,"",""]
[26,"","",null,null,"",""]
[27,"","",null,null,"",""]
[28,"","",null,null,"",""]
[29,"","",null,null,"",""]
[30,"","",null,null,"",""]
[31,"","",null,null,null,""]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[52]
[53]
[54]
[55]
[56]
[57]
[58]
[59]
[60]
[61]
[62]
[63]
[64]
[65]
[66]
[67]
[68]
[69]
[70]
[71]
[72]
[73]
[74]
[75]
[76]
[77]
[78]
[79]
[80]
[81]
[82]
[83]
[84]
[85]
[86]
[87]
[88]
[89]
[90]
[91]
[92]
[93]
[94]
[95]
[96]
[97]
[98]
[99]
[100]

{"sheet":"CALC","index":4,"n_rows":41,"n_cols":34,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[]
[null,"DETAILED CALCULATIONS"]
[null,"Inputs"]
[null,"Beginning of Year","Rehabilitation"]
[null,"Land value",{"$f":"IF(LOOKUP($C$4,INPUT!$G$4:$AK$4,INPUT!$G$9:$AK$9)=\"\",\"\",LOOKUP($C$4,INPUT!$G$4:$AK$4,INPUT!$G$9:$AK$9))","v":""}]
[null,"Rental rate",{"$f":"IF(LOOKUP($C$4,INPUT!$G$4:$AK$4,INPUT!$G$10:$AK$10)=\"\",\"\",LOOKUP($C$4,INPUT!$G$4:$AK$4,INPUT!$G$10:$AK$10))","v":""}]
[null,"Total land area used by gas company",{"$f":"IF(LOOKUP($C$4,INPUT!$G$4:$AK$4,INPUT!$G$13:$AK$13)=\"\",\"\",LOOKUP($C$4,INPUT!$G$4:$AK$4,INPUT!$G$13:$AK$13))","v":""}]
[null,"Severance",{"$f":"IF(LOOKUP($C$4,INPUT!$G$4:$AK$4,INPUT!$G$15:$AK$15)=\"\",\"\",LOOKUP($C$4,INPUT!$G$4:$AK$4,INPUT!$G$15:$AK$15))","v":""}]
[null,"Injurious affections",{"$f":"IF(LOOKUP($C$4,INPUT!$G$4:$AK$4,INPUT!$G$16:$AK$16)=\"\",\"\",LOOKUP($C$4,INPUT!$G$4:$AK$4,INPUT!$G$16:$AK$16))","v":""}]
[]
[null,"\\",0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31]
[null,"Beginning of Year",null,{"$f":"IF('DO NOT DELETE'!A11<=Access_Period,'DO NOT DELETE'!A11,IF(AND(Access_Period>0,'DO NOT DELETE'!A11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":1},{"$f":"IF('DO NOT DELETE'!B11<=Access_Period,'DO NOT DELETE'!B11,IF(AND(Access_Period>0,'DO NOT DELETE'!B11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":2},{"$f":"IF('DO NOT DELETE'!C11<=Access_Period,'DO NOT DELETE'!C11,IF(AND(Access_Period>0,'DO NOT DELETE'!C11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":3},{"$f":"IF('DO NOT DELETE'!D11<=Access_Period,'DO NOT DELETE'!D11,IF(AND(Access_Period>0,'DO NOT DELETE'!D11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":4},{"$f":"IF('DO NOT DELETE'!E11<=Access_Period,'DO NOT DELETE'!E11,IF(AND(Access_Period>0,'DO NOT DELETE'!E11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":5},{"$f":"IF('DO NOT DELETE'!F11<=Access_Period,'DO NOT DELETE'!F11,IF(AND(Access_Period>0,'DO NOT DELETE'!F11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":6},{"$f":"IF('DO NOT DELETE'!G11<=Access_Period,'DO NOT DELETE'!G11,IF(AND(Access_Period>0,'DO NOT DELETE'!G11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":7},{"$f":"IF('DO NOT DELETE'!H11<=Access_Period,'DO NOT DELETE'!H11,IF(AND(Access_Period>0,'DO NOT DELETE'!H11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":8},{"$f":"IF('DO NOT DELETE'!I11<=Access_Period,'DO NOT DELETE'!I11,IF(AND(Access_Period>0,'DO NOT DELETE'!I11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":9},{"$f":"IF('DO NOT DELETE'!J11<=Access_Period,'DO NOT DELETE'!J11,IF(AND(Access_Period>0,'DO NOT DELETE'!J11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":10},{"$f":"IF('DO NOT DELETE'!K11<=Access_Period,'DO NOT DELETE'!K11,IF(AND(Access_Period>0,'DO NOT DELETE'!K11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":11},{"$f":"IF('DO NOT DELETE'!L11<=Access_Period,'DO NOT DELETE'!L11,IF(AND(Access_Period>0,'DO NOT DELETE'!L11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":12},{"$f":"IF('DO NOT DELETE'!M11<=Access_Period,'DO NOT DELETE'!M11,IF(AND(Access_Period>0,'DO NOT DELETE'!M11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":13},{"$f":"IF('DO NOT DELETE'!N11<=Access_Period,'DO NOT DELETE'!N11,IF(AND(Access_Period>0,'DO NOT DELETE'!N11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":14},{"$f":"IF('DO NOT DELETE'!O11<=Access_Period,'DO NOT DELETE'!O11,IF(AND(Access_Period>0,'DO NOT DELETE'!O11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":15},{"$f":"IF('DO NOT DELETE'!P11<=Access_Period,'DO NOT DELETE'!P11,IF(AND(Access_Period>0,'DO NOT DELETE'!P11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":16},{"$f":"IF('DO NOT DELETE'!Q11<=Access_Period,'DO NOT DELETE'!Q11,IF(AND(Access_Period>0,'DO NOT DELETE'!Q11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":17},{"$f":"IF('DO NOT DELETE'!R11<=Access_Period,'DO NOT DELETE'!R11,IF(AND(Access_Period>0,'DO NOT DELETE'!R11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":18},{"$f":"IF('DO NOT DELETE'!S11<=Access_Period,'DO NOT DELETE'!S11,IF(AND(Access_Period>0,'DO NOT DELETE'!S11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":19},{"$f":"IF('DO NOT DELETE'!T11<=Access_Period,'DO NOT DELETE'!T11,IF(AND(Access_Period>0,'DO NOT DELETE'!T11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":20},{"$f":"IF('DO NOT DELETE'!U11<=Access_Period,'DO NOT DELETE'!U11,IF(AND(Access_Period>0,'DO NOT DELETE'!U11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":"Rehabilitation"},{"$f":"IF('DO NOT DELETE'!V11<=Access_Period,'DO NOT DELETE'!V11,IF(AND(Access_Period>0,'DO NOT DELETE'!V11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":""},{"$f":"IF('DO NOT DELETE'!W11<=Access_Period,'DO NOT DELETE'!W11,IF(AND(Access_Period>0,'DO NOT DELETE'!W11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":""},{"$f":"IF('DO NOT DELETE'!X11<=Access_Period,'DO NOT DELETE'!X11,IF(AND(Access_Period>0,'DO NOT DELETE'!X11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":""},{"$f":"IF('DO NOT DELETE'!Y11<=Access_Period,'DO NOT DELETE'!Y11,IF(AND(Access_Period>0,'DO NOT DELETE'!Y11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":""},{"$f":"IF('DO NOT DELETE'!Z11<=Access_Period,'DO NOT DELETE'!Z11,IF(AND(Access_Period>0,'DO NOT DELETE'!Z11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":""},{"$f":"IF('DO NOT DELETE'!AA11<=Access_Period,'DO NOT DELETE'!AA11,IF(AND(Access_Period>0,'DO NOT DELETE'!AA11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":""},{"$f":"IF('DO NOT DELETE'!AB11<=Access_Period,'DO NOT DELETE'!AB11,IF(AND(Access_Period>0,'DO NOT DELETE'!AB11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":""},{"$f":"IF('DO NOT DELETE'!AC11<=Access_Period,'DO NOT DELETE'!AC11,IF(AND(Access_Period>0,'DO NOT DELETE'!AC11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":""},{"$f":"IF('DO NOT DELETE'!AD11<=Access_Period,'DO NOT DELETE'!AD11,IF(AND(Access_Period>0,'DO NOT DELETE'!AD11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":""},{"$f":"IF('DO NOT DELETE'!AE11<=Access_Period,'DO NOT DELETE'!AE11,IF(AND(Access_Period>0,'DO NOT DELETE'!AE11=(Access_Period+1)),'DO NOT DELETE'!$AF$11,\"\"))","v":""}]
[null,"Land value",null,{"$f":"IF(D12>Access_Period,IF(D12=\"Rehabilitation\",IF($C$5=\"\",C13,$C$5),\"\"),IF(AND(D12<=Access_Period,INPUT!G9=\"\"),C13*(1+Inflation),INPUT!G9))","v":15000},{"$f":"IF(E12>Access_Period,IF(E12=\"Rehabilitation\",IF($C$5=\"\",D13,$C$5),\"\"),IF(AND(E12<=Access_Period,INPUT!H9=\"\"),D13*(1+Inflation),INPUT!H9))","v":15374.999999999998},{"$f":"IF(F12>Access_Period,IF(F12=\"Rehabilitation\",IF($C$5=\"\",E13,$C$5),\"\"),IF(AND(F12<=Access_Period,INPUT!I9=\"\"),E13*(1+Inflation),INPUT!I9))","v":15759.374999999996},{"$f":"IF(G12>Access_Period,IF(G12=\"Rehabilitation\",IF($C$5=\"\",F13,$C$5),\"\"),IF(AND(G12<=Access_Period,INPUT!J9=\"\"),F13*(1+Inflation),INPUT!J9))","v":16153.359374999995},{"$f":"IF(H12>Access_Period,IF(H12=\"Rehabilitation\",IF($C$5=\"\",G13,$C$5),\"\"),IF(AND(H12<=Access_Period,INPUT!K9=\"\"),G13*(1+Inflation),INPUT!K9))","v":18000},{"$f":"IF(I12>Access_Period,IF(I12=\"Rehabilitation\",IF($C$5=\"\",H13,$C$5),\"\"),IF(AND(I12<=Access_Period,INPUT!L9=\"\"),H13*(1+Inflation),INPUT!L9))","v":18450},{"$f":"IF(J12>Access_Period,IF(J12=\"Rehabilitation\",IF($C$5=\"\",I13,$C$5),\"\"),IF(AND(J12<=Access_Period,INPUT!M9=\"\"),I13*(1+Inflation),INPUT!M9))","v":18911.25},{"$f":"IF(K12>Access_Period,IF(K12=\"Rehabilitation\",IF($C$5=\"\",J13,$C$5),\"\"),IF(AND(K12<=Access_Period,INPUT!N9=\"\"),J13*(1+Inflation),INPUT!N9))","v":19384.03125},{"$f":"IF(L12>Access_Period,IF(L12=\"Rehabilitation\",IF($C$5=\"\",K13,$C$5),\"\"),IF(AND(L12<=Access_Period,INPUT!O9=\"\"),K13*(1+Inflation),INPUT!O9))","v":19868.632031249999},{"$f":"IF(M12>Access_Period,IF(M12=\"Rehabilitation\",IF($C$5=\"\",L13,$C$5),\"\"),IF(AND(M12<=Access_Period,INPUT!P9=\"\"),L13*(1+Inflation),INPUT!P9))","v":20365.347832031246},{"$f":"IF(N12>Access_Period,IF(N12=\"Rehabilitation\",IF($C$5=\"\",M13,$C$5),\"\"),IF(AND(N12<=Access_Period,INPUT!Q9=\"\"),M13*(1+Inflation),INPUT!Q9))","v":20874.481527832024},{"$f":"IF(O12>Access_Period,IF(O12=\"Rehabilitation\",IF($C$5=\"\",N13,$C$5),\"\"),IF(AND(O12<=Access_Period,INPUT!R9=\"\"),N13*(1+Inflation),INPUT!R9))","v":21396.343566027823},{"$f":"IF(P12>Access_Period,IF(P12=\"Rehabilitation\",IF($C$5=\"\",O13,$C$5),\"\"),IF(AND(P12<=Access_Period,INPUT!S9=\"\"),O13*(1+Inflation),INPUT!S9))","v":21931.252155178518},{"$f":"IF(Q12>Access_Period,IF(Q12=\"Rehabilitation\",IF($C$5=\"\",P13,$C$5),\"\"),IF(AND(Q12<=Access_Period,INPUT!T9=\"\"),P13*(1+Inflation),INPUT!T9))","v":22479.533459057977},{"$f":"IF(R12>Access_Period,IF(R12=\"Rehabilitation\",IF($C$5=\"\",Q13,$C$5),\"\"),IF(AND(R12<=Access_Period,INPUT!U9=\"\"),Q13*(1+Inflation),INPUT!U9))","v":23041.521795534423},{"$f":"IF(S12>Access_Period,IF(S12=\"Rehabilitation\",IF($C$5=\"\",R13,$C$5),\"\"),IF(AND(S12<=Access_Period,INPUT!V9=\"\"),R13*(1+Inflation),INPUT!V9))","v":23617.559840422782},{"$f":"IF(T12>Access_Period,IF(T12=\"Rehabilitation\",IF($C$5=\"\",S13,$C$5),\"\"),IF(AND(T12<=Access_Period,INPUT!W9=\"\"),S13*(1+Inflation),INPUT!W9))","v":24207.998836433351},{"$f":"IF(U12>Access_Period,IF(U12=\"Rehabilitation\",IF($C$5=\"\",T13,$C$5),\"\"),IF(AND(U12<=Access_Period,INPUT!X9=\"\"),T13*(1+Inflation),INPUT!X9))","v":24813.198807344183},{"$f":"IF(V12>Access_Period,IF(V12=\"Rehabilitation\",IF($C$5=\"\",U13,$C$5),\"\"),IF(AND(V12<=Access_Period,INPUT!Y9=\"\"),U13*(1+Inflation),INPUT!Y9))","v":25433.528777527787},{"$f":"IF(W12>Access_Period,IF(W12=\"Rehabilitation\",IF($C$5=\"\",V13,$C$5),\"\"),IF(AND(W12<=Access_Period,INPUT!Z9=\"\"),V13*(1+Inflation),INPUT!Z9))","v":26069.366996965979},{"$f":"IF(X12>Access_Period,IF(X12=\"Rehabilitation\",IF($C$5=\"\",W13,$C$5),\"\"),IF(AND(X12<=Access_Period,INPUT!AA9=\"\"),W13*(1+Inflation),INPUT!AA9))","v":26069.366996965979},{"$f":"IF(Y12>Access_Period,IF(Y12=\"Rehabilitation\",IF($C$5=\"\",X13,$C$5),\"\"),IF(AND(Y12<=Access_Period,INPUT!AB9=\"\"),X13*(1+Inflation),INPUT!AB9))","v":""},{"$f":"IF(Z12>Access_Period,IF(Z12=\"Rehabilitation\",IF($C$5=\"\",Y13,$C$5),\"\"),IF(AND(Z12<=Access_Period,INPUT!AC9=\"\"),Y13*(1+Inflation),INPUT!AC9))","v":""},{"$f":"IF(AA12>Access_Period,IF(AA12=\"Rehabilitation\",IF($C$5=\"\",Z13,$C$5),\"\"),IF(AND(AA12<=Access_Period,INPUT!AD9=\"\"),Z13*(1+Inflation),INPUT!AD9))","v":""},{"$f":"IF(AB12>Access_Period,IF(AB12=\"Rehabilitation\",IF($C$5=\"\",AA13,$C$5),\"\"),IF(AND(AB12<=Access_Period,INPUT!AE9=\"\"),AA13*(1+Inflation),INPUT!AE9))","v":""},{"$f":"IF(AC12>Access_Period,IF(AC12=\"Rehabilitation\",IF($C$5=\"\",AB13,$C$5),\"\"),IF(AND(AC12<=Access_Period,INPUT!AF9=\"\"),AB13*(1+Inflation),INPUT!AF9))","v":""},{"$f":"IF(AD12>Access_Period,IF(AD12=\"Rehabilitation\",IF($C$5=\"\",AC13,$C$5),\"\"),IF(AND(AD12<=Access_Period,INPUT!AG9=\"\"),AC13*(1+Inflation),INPUT!AG9))","v":""},{"$f":"IF(AE12>Access_Period,IF(AE12=\"Rehabilitation\",IF($C$5=\"\",AD13,$C$5),\"\"),IF(AND(AE12<=Access_Period,INPUT!AH9=\"\"),AD13*(1+Inflation),INPUT!AH9))","v":""},{"$f":"IF(AF12>Access_Period,IF(AF12=\"Rehabilitation\",IF($C$5=\"\",AE13,$C$5),\"\"),IF(AND(AF12<=Access_Period,INPUT!AI9=\"\"),AE13*(1+Inflation),INPUT!AI9))","v":""},{"$f":"IF(AG12>Access_Period,IF(AG12=\"Rehabilitation\",IF($C$5=\"\",AF13,$C$5),\"\"),IF(AND(AG12<=Access_Period,INPUT!AJ9=\"\"),AF13*(1+Inflation),INPUT!AJ9))","v":""},{"$f":"IF(AH12>Access_Period,IF(AH12=\"Rehabilitation\",IF($C$5=\"\",AG13,$C$5),\"\"),IF(AND(AH12<=Access_Period,INPUT!AK9=\"\"),AG13*(1+Inflation),INPUT!AK9))","v":""}]
[null,"Rental rate",null,{"$f":"IF(D12>Access_Period,IF(D12=\"Rehabilitation\",IF($C$6=\"\",C14,$C$6),\"\"),IF(AND(D12<=Access_Period,INPUT!G10=\"\"),C14,INPUT!G10))","v":0.08},{"$f":"IF(E12>Access_Period,IF(E12=\"Rehabilitation\",IF($C$6=\"\",D14,$C$6),\"\"),IF(AND(E12<=Access_Period,INPUT!H10=\"\"),D14,INPUT!H10))","v":0.08},{"$f":"IF(F12>Access_Period,IF(F12=\"Rehabilitation\",IF($C$6=\"\",E14,$C$6),\"\"),IF(AND(F12<=Access_Period,INPUT!I10=\"\"),E14,INPUT!I10))","v":0.08},{"$f":"IF(G12>Access_Period,IF(G12=\"Rehabilitation\",IF($C$6=\"\",F14,$C$6),\"\"),IF(AND(G12<=Access_Period,INPUT!J10=\"\"),F14,INPUT!J10))","v":0.08},{"$f":"IF(H12>Access_Period,IF(H12=\"Rehabilitation\",IF($C$6=\"\",G14,$C$6),\"\"),IF(AND(H12<=Access_Period,INPUT!K10=\"\"),G14,INPUT!K10))","v":0.09},{"$f":"IF(I12>Access_Period,IF(I12=\"Rehabilitation\",IF($C$6=\"\",H14,$C$6),\"\"),IF(AND(I12<=Access_Period,INPUT!L10=\"\"),H14,INPUT!L10))","v":0.09},{"$f":"IF(J12>Access_Period,IF(J12=\"Rehabilitation\",IF($C$6=\"\",I14,$C$6),\"\"),IF(AND(J12<=Access_Period,INPUT!M10=\"\"),I14,INPUT!M10))","v":0.09},{"$f":"IF(K12>Access_Period,IF(K12=\"Rehabilitation\",IF($C$6=\"\",J14,$C$6),\"\"),IF(AND(K12<=Access_Period,INPUT!N10=\"\"),J14,INPUT!N10))","v":0.09},{"$f":"IF(L12>Access_Period,IF(L12=\"Rehabilitation\",IF($C$6=\"\",K14,$C$6),\"\"),IF(AND(L12<=Access_Period,INPUT!O10=\"\"),K14,INPUT!O10))","v":0.09},{"$f":"IF(M12>Access_Period,IF(M12=\"Rehabilitation\",IF($C$6=\"\",L14,$C$6),\"\"),IF(AND(M12<=Access_Period,INPUT!P10=\"\"),L14,INPUT!P10))","v":0.09},{"$f":"IF(N12>Access_Period,IF(N12=\"Rehabilitation\",IF($C$6=\"\",M14,$C$6),\"\"),IF(AND(N12<=Access_Period,INPUT!Q10=\"\"),M14,INPUT!Q10))","v":0.09},{"$f":"IF(O12>Access_Period,IF(O12=\"Rehabilitation\",IF($C$6=\"\",N14,$C$6),\"\"),IF(AND(O12<=Access_Period,INPUT!R10=\"\"),N14,INPUT!R10))","v":0.09},{"$f":"IF(P12>Access_Period,IF(P12=\"Rehabilitation\",IF($C$6=\"\",O14,$C$6),\"\"),IF(AND(P12<=Access_Period,INPUT!S10=\"\"),O14,INPUT!S10))","v":0.09},{"$f":"IF(Q12>Access_Period,IF(Q12=\"Rehabilitation\",IF($C$6=\"\",P14,$C$6),\"\"),IF(AND(Q12<=Access_Period,INPUT!T10=\"\"),P14,INPUT!T10))","v":0.09},{"$f":"IF(R12>Access_Period,IF(R12=\"Rehabilitation\",IF($C$6=\"\",Q14,$C$6),\"\"),IF(AND(R12<=Access_Period,INPUT!U10=\"\"),Q14,INPUT!U10))","v":0.09},{"$f":"IF(S12>Access_Period,IF(S12=\"Rehabilitation\",IF($C$6=\"\",R14,$C$6),\"\"),IF(AND(S12<=Access_Period,INPUT!V10=\"\"),R14,INPUT!V10))","v":0.09},{"$f":"IF(T12>Access_Period,IF(T12=\"Rehabilitation\",IF($C$6=\"\",S14,$C$6),\"\"),IF(AND(T12<=Access_Period,INPUT!W10=\"\"),S14,INPUT!W10))","v":0.09},{"$f":"IF(U12>Access_Period,IF(U12=\"Rehabilitation\",IF($C$6=\"\",T14,$C$6),\"\"),IF(AND(U12<=Access_Period,INPUT!X10=\"\"),T14,INPUT!X10))","v":0.09},{"$f":"IF(V12>Access_Period,IF(V12=\"Rehabilitation\",IF($C$6=\"\",U14,$C$6),\"\"),IF(AND(V12<=Access_Period,INPUT!Y10=\"\"),U14,INPUT!Y10))","v":0.09},{"$f":"IF(W12>Access_Period,IF(W12=\"Rehabilitation\",IF($C$6=\"\",V14,$C$6),\"\"),IF(AND(W12<=Access_Period,INPUT!Z10=\"\"),V14,INPUT!Z10))","v":0.09},{"$f":"IF(X12>Access_Period,IF(X12=\"Rehabilitation\",IF($C$6=\"\",W14,$C$6),\"\"),IF(AND(X12<=Access_Period,INPUT!AA10=\"\"),W14,INPUT!AA10))","v":0.09},{"$f":"IF(Y12>Access_Period,IF(Y12=\"Rehabilitation\",IF($C$6=\"\",X14,$C$6),\"\"),IF(AND(Y12<=Access_Period,INPUT!AB10=\"\"),X14,INPUT!AB10))","v":""},{"$f":"IF(Z12>Access_Period,IF(Z12=\"Rehabilitation\",IF($C$6=\"\",Y14,$C$6),\"\"),IF(AND(Z12<=Access_Period,INPUT!AC10=\"\"),Y14,INPUT!AC10))","v":""},{"$f":"IF(AA12>Access_Period,IF(AA12=\"Rehabilitation\",IF($C$6=\"\",Z14,$C$6),\"\"),IF(AND(AA12<=Access_Period,INPUT!AD10=\"\"),Z14,INPUT!AD10))","v":""},{"$f":"IF(AB12>Access_Period,IF(AB12=\"Rehabilitation\",IF($C$6=\"\",AA14,$C$6),\"\"),IF(AND(AB12<=Access_Period,INPUT!AE10=\"\"),AA14,INPUT!AE10))","v":""},{"$f":"IF(AC12>Access_Period,IF(AC12=\"Rehabilitation\",IF($C$6=\"\",AB14,$C$6),\"\"),IF(AND(AC12<=Access_Period,INPUT!AF10=\"\"),AB14,INPUT!AF10))","v":""},{"$f":"IF(AD12>Access_Period,IF(AD12=\"Rehabilitation\",IF($C$6=\"\",AC14,$C$6),\"\"),IF(AND(AD12<=Access_Period,INPUT!AG10=\"\"),AC14,INPUT!AG10))","v":""},{"$f":"IF(AE12>Access_Period,IF(AE12=\"Rehabilitation\",IF($C$6=\"\",AD14,$C$6),\"\"),IF(AND(AE12<=Access_Period,INPUT!AH10=\"\"),AD14,INPUT!AH10))","v":""},{"$f":"IF(AF12>Access_Period,IF(AF12=\"Rehabilitation\",IF($C$6=\"\",AE14,$C$6),\"\"),IF(AND(AF12<=Access_Period,INPUT!AI10=\"\"),AE14,INPUT!AI10))","v":""},{"$f":"IF(AG12>Access_Period,IF(AG12=\"Rehabilitation\",IF($C$6=\"\",AF14,$C$6),\"\"),IF(AND(AG12<=Access_Period,INPUT!AJ10=\"\"),AF14,INPUT!AJ10))","v":""},{"$f":"IF(AH12>Access_Period,IF(AH12=\"Rehabilitation\",IF($C$6=\"\",AG14,$C$6),\"\"),IF(AND(AH12<=Access_Period,INPUT!AK10=\"\"),AG14,INPUT!AK10))","v":""}]
[null,"Total land area used by gas company",null,{"$f":"IF(D12>Access_Period,IF(D12=\"Rehabilitation\",IF($C$7=\"\",C15,$C$7),\"\"),IF(AND(D12<=Access_Period,INPUT!G13=\"\"),C15,INPUT!G13))","v":10},{"$f":"IF(E12>Access_Period,IF(E12=\"Rehabilitation\",IF($C$7=\"\",D15,$C$7),\"\"),IF(AND(E12<=Access_Period,INPUT!H13=\"\"),D15,INPUT!H13))","v":5.25},{"$f":"IF(F12>Access_Period,IF(F12=\"Rehabilitation\",IF($C$7=\"\",E15,$C$7),\"\"),IF(AND(F12<=Access_Period,INPUT!I13=\"\"),E15,INPUT!I13))","v":5.25},{"$f":"IF(G12>Access_Period,IF(G12=\"Rehabilitation\",IF($C$7=\"\",F15,$C$7),\"\"),IF(AND(G12<=Access_Period,INPUT!J13=\"\"),F15,INPUT!J13))","v":5.25},{"$f":"IF(H12>Access_Period,IF(H12=\"Rehabilitation\",IF($C$7=\"\",G15,$C$7),\"\"),IF(AND(H12<=Access_Period,INPUT!K13=\"\"),G15,INPUT!K13))","v":5.25},{"$f":"IF(I12>Access_Period,IF(I12=\"Rehabilitation\",IF($C$7=\"\",H15,$C$7),\"\"),IF(AND(I12<=Access_Period,INPUT!L13=\"\"),H15,INPUT!L13))","v":5.25},{"$f":"IF(J12>Access_Period,IF(J12=\"Rehabilitation\",IF($C$7=\"\",I15,$C$7),\"\"),IF(AND(J12<=Access_Period,INPUT!M13=\"\"),I15,INPUT!M13))","v":5.25},{"$f":"IF(K12>Access_Period,IF(K12=\"Rehabilitation\",IF($C$7=\"\",J15,$C$7),\"\"),IF(AND(K12<=Access_Period,INPUT!N13=\"\"),J15,INPUT!N13))","v":5.25},{"$f":"IF(L12>Access_Period,IF(L12=\"Rehabilitation\",IF($C$7=\"\",K15,$C$7),\"\"),IF(AND(L12<=Access_Period,INPUT!O13=\"\"),K15,INPUT!O13))","v":5.25},{"$f":"IF(M12>Access_Period,IF(M12=\"Rehabilitation\",IF($C$7=\"\",L15,$C$7),\"\"),IF(AND(M12<=Access_Period,INPUT!P13=\"\"),L15,INPUT!P13))","v":5.25},{"$f":"IF(N12>Access_Period,IF(N12=\"Rehabilitation\",IF($C$7=\"\",M15,$C$7),\"\"),IF(AND(N12<=Access_Period,INPUT!Q13=\"\"),M15,INPUT!Q13))","v":5.25},{"$f":"IF(O12>Access_Period,IF(O12=\"Rehabilitation\",IF($C$7=\"\",N15,$C$7),\"\"),IF(AND(O12<=Access_Period,INPUT!R13=\"\"),N15,INPUT!R13))","v":5.25},{"$f":"IF(P12>Access_Period,IF(P12=\"Rehabilitation\",IF($C$7=\"\",O15,$C$7),\"\"),IF(AND(P12<=Access_Period,INPUT!S13=\"\"),O15,INPUT!S13))","v":5.25},{"$f":"IF(Q12>Access_Period,IF(Q12=\"Rehabilitation\",IF($C$7=\"\",P15,$C$7),\"\"),IF(AND(Q12<=Access_Period,INPUT!T13=\"\"),P15,INPUT!T13))","v":5.25},{"$f":"IF(R12>Access_Period,IF(R12=\"Rehabilitation\",IF($C$7=\"\",Q15,$C$7),\"\"),IF(AND(R12<=Access_Period,INPUT!U13=\"\"),Q15,INPUT!U13))","v":5.25},{"$f":"IF(S12>Access_Period,IF(S12=\"Rehabilitation\",IF($C$7=\"\",R15,$C$7),\"\"),IF(AND(S12<=Access_Period,INPUT!V13=\"\"),R15,INPUT!V13))","v":5.25},{"$f":"IF(T12>Access_Period,IF(T12=\"Rehabilitation\",IF($C$7=\"\",S15,$C$7),\"\"),IF(AND(T12<=Access_Period,INPUT!W13=\"\"),S15,INPUT!W13))","v":5.25},{"$f":"IF(U12>Access_Period,IF(U12=\"Rehabilitation\",IF($C$7=\"\",T15,$C$7),\"\"),IF(AND(U12<=Access_Period,INPUT!X13=\"\"),T15,INPUT!X13))","v":5.25},{"$f":"IF(V12>Access_Period,IF(V12=\"Rehabilitation\",IF($C$7=\"\",U15,$C$7),\"\"),IF(AND(V12<=Access_Period,INPUT!Y13=\"\"),U15,INPUT!Y13))","v":5.25},{"$f":"IF(W12>Access_Period,IF(W12=\"Rehabilitation\",IF($C$7=\"\",V15,$C$7),\"\"),IF(AND(W12<=Access_Period,INPUT!Z13=\"\"),V15,INPUT!Z13))","v":5.25},{"$f":"IF(X12>Access_Period,IF(X12=\"Rehabilitation\",IF($C$7=\"\",W15,$C$7),\"\"),IF(AND(X12<=Access_Period,INPUT!AA13=\"\"),W15,INPUT!AA13))","v":5.25},{"$f":"IF(Y12>Access_Period,IF(Y12=\"Rehabilitation\",IF($C$7=\"\",X15,$C$7),\"\"),IF(AND(Y12<=Access_Period,INPUT!AB13=\"\"),X15,INPUT!AB13))","v":""},{"$f":"IF(Z12>Access_Period,IF(Z12=\"Rehabilitation\",IF($C$7=\"\",Y15,$C$7),\"\"),IF(AND(Z12<=Access_Period,INPUT!AC13=\"\"),Y15,INPUT!AC13))","v":""},{"$f":"IF(AA12>Access_Period,IF(AA12=\"Rehabilitation\",IF($C$7=\"\",Z15,$C$7),\"\"),IF(AND(AA12<=Access_Period,INPUT!AD13=\"\"),Z15,INPUT!AD13))","v":""},{"$f":"IF(AB12>Access_Period,IF(AB12=\"Rehabilitation\",IF($C$7=\"\",AA15,$C$7),\"\"),IF(AND(AB12<=Access_Period,INPUT!AE13=\"\"),AA15,INPUT!AE13))","v":""},{"$f":"IF(AC12>Access_Period,IF(AC12=\"Rehabilitation\",IF($C$7=\"\",AB15,$C$7),\"\"),IF(AND(AC12<=Access_Period,INPUT!AF13=\"\"),AB15,INPUT!AF13))","v":""},{"$f":"IF(AD12>Access_Period,IF(AD12=\"Rehabilitation\",IF($C$7=\"\",AC15,$C$7),\"\"),IF(AND(AD12<=Access_Period,INPUT!AG13=\"\"),AC15,INPUT!AG13))","v":""},{"$f":"IF(AE12>Access_Period,IF(AE12=\"Rehabilitation\",IF($C$7=\"\",AD15,$C$7),\"\"),IF(AND(AE12<=Access_Period,INPUT!AH13=\"\"),AD15,INPUT!AH13))","v":""},{"$f":"IF(AF12>Access_Period,IF(AF12=\"Rehabilitation\",IF($C$7=\"\",AE15,$C$7),\"\"),IF(AND(AF12<=Access_Period,INPUT!AI13=\"\"),AE15,INPUT!AI13))","v":""},{"$f":"IF(AG12>Access_Period,IF(AG12=\"Rehabilitation\",IF($C$7=\"\",AF15,$C$7),\"\"),IF(AND(AG12<=Access_Period,INPUT!AJ13=\"\"),AF15,INPUT!AJ13))","v":""},{"$f":"IF(AH12>Access_Period,IF(AH12=\"Rehabilitation\",IF($C$7=\"\",AG15,$C$7),\"\"),IF(AND(AH12<=Access_Period,INPUT!AK13=\"\"),AG15,INPUT!AK13))","v":""}]
[null,"Severance",null,{"$f":"IF(D12>Access_Period,IF(D12=\"Rehabilitation\",IF($C$8=\"\",C16,$C$8),\"\"),IF(AND(D12<=Access_Period,INPUT!G15=\"\"),C16,INPUT!G15))","v":0},{"$f":"IF(E12>Access_Period,IF(E12=\"Rehabilitation\",IF($C$8=\"\",D16,$C$8),\"\"),IF(AND(E12<=Access_Period,INPUT!H15=\"\"),D16,INPUT!H15))","v":0},{"$f":"IF(F12>Access_Period,IF(F12=\"Rehabilitation\",IF($C$8=\"\",E16,$C$8),\"\"),IF(AND(F12<=Access_Period,INPUT!I15=\"\"),E16,INPUT!I15))","v":0},{"$f":"IF(G12>Access_Period,IF(G12=\"Rehabilitation\",IF($C$8=\"\",F16,$C$8),\"\"),IF(AND(G12<=Access_Period,INPUT!J15=\"\"),F16,INPUT!J15))","v":0},{"$f":"IF(H12>Access_Period,IF(H12=\"Rehabilitation\",IF($C$8=\"\",G16,$C$8),\"\"),IF(AND(H12<=Access_Period,INPUT!K15=\"\"),G16,INPUT!K15))","v":0},{"$f":"IF(I12>Access_Period,IF(I12=\"Rehabilitation\",IF($C$8=\"\",H16,$C$8),\"\"),IF(AND(I12<=Access_Period,INPUT!L15=\"\"),H16,INPUT!L15))","v":0},{"$f":"IF(J12>Access_Period,IF(J12=\"Rehabilitation\",IF($C$8=\"\",I16,$C$8),\"\"),IF(AND(J12<=Access_Period,INPUT!M15=\"\"),I16,INPUT!M15))","v":0},{"$f":"IF(K12>Access_Period,IF(K12=\"Rehabilitation\",IF($C$8=\"\",J16,$C$8),\"\"),IF(AND(K12<=Access_Period,INPUT!N15=\"\"),J16,INPUT!N15))","v":0},{"$f":"IF(L12>Access_Period,IF(L12=\"Rehabilitation\",IF($C$8=\"\",K16,$C$8),\"\"),IF(AND(L12<=Access_Period,INPUT!O15=\"\"),K16,INPUT!O15))","v":0},{"$f":"IF(M12>Access_Period,IF(M12=\"Rehabilitation\",IF($C$8=\"\",L16,$C$8),\"\"),IF(AND(M12<=Access_Period,INPUT!P15=\"\"),L16,INPUT!P15))","v":0},{"$f":"IF(N12>Access_Period,IF(N12=\"Rehabilitation\",IF($C$8=\"\",M16,$C$8),\"\"),IF(AND(N12<=Access_Period,INPUT!Q15=\"\"),M16,INPUT!Q15))","v":0},{"$f":"IF(O12>Access_Period,IF(O12=\"Rehabilitation\",IF($C$8=\"\",N16,$C$8),\"\"),IF(AND(O12<=Access_Period,INPUT!R15=\"\"),N16,INPUT!R15))","v":0},{"$f":"IF(P12>Access_Period,IF(P12=\"Rehabilitation\",IF($C$8=\"\",O16,$C$8),\"\"),IF(AND(P12<=Access_Period,INPUT!S15=\"\"),O16,INPUT!S15))","v":0},{"$f":"IF(Q12>Access_Period,IF(Q12=\"Rehabilitation\",IF($C$8=\"\",P16,$C$8),\"\"),IF(AND(Q12<=Access_Period,INPUT!T15=\"\"),P16,INPUT!T15))","v":0},{"$f":"IF(R12>Access_Period,IF(R12=\"Rehabilitation\",IF($C$8=\"\",Q16,$C$8),\"\"),IF(AND(R12<=Access_Period,INPUT!U15=\"\"),Q16,INPUT!U15))","v":0},{"$f":"IF(S12>Access_Period,IF(S12=\"Rehabilitation\",IF($C$8=\"\",R16,$C$8),\"\"),IF(AND(S12<=Access_Period,INPUT!V15=\"\"),R16,INPUT!V15))","v":0},{"$f":"IF(T12>Access_Period,IF(T12=\"Rehabilitation\",IF($C$8=\"\",S16,$C$8),\"\"),IF(AND(T12<=Access_Period,INPUT!W15=\"\"),S16,INPUT!W15))","v":0},{"$f":"IF(U12>Access_Period,IF(U12=\"Rehabilitation\",IF($C$8=\"\",T16,$C$8),\"\"),IF(AND(U12<=Access_Period,INPUT!X15=\"\"),T16,INPUT!X15))","v":0},{"$f":"IF(V12>Access_Period,IF(V12=\"Rehabilitation\",IF($C$8=\"\",U16,$C$8),\"\"),IF(AND(V12<=Access_Period,INPUT!Y15=\"\"),U16,INPUT!Y15))","v":0},{"$f":"IF(W12>Access_Period,IF(W12=\"Rehabilitation\",IF($C$8=\"\",V16,$C$8),\"\"),IF(AND(W12<=Access_Period,INPUT!Z15=\"\"),V16,INPUT!Z15))","v":0},{"$f":"IF(X12>Access_Period,IF(X12=\"Rehabilitation\",IF($C$8=\"\",W16,$C$8),\"\"),IF(AND(X12<=Access_Period,INPUT!AA15=\"\"),W16,INPUT!AA15))","v":0},{"$f":"IF(Y12>Access_Period,IF(Y12=\"Rehabilitation\",IF($C$8=\"\",X16,$C$8),\"\"),IF(AND(Y12<=Access_Period,INPUT!AB15=\"\"),X16,INPUT!AB15))","v":""},{"$f":"IF(Z12>Access_Period,IF(Z12=\"Rehabilitation\",IF($C$8=\"\",Y16,$C$8),\"\"),IF(AND(Z12<=Access_Period,INPUT!AC15=\"\"),Y16,INPUT!AC15))","v":""},{"$f":"IF(AA12>Access_Period,IF(AA12=\"Rehabilitation\",IF($C$8=\"\",Z16,$C$8),\"\"),IF(AND(AA12<=Access_Period,INPUT!AD15=\"\"),Z16,INPUT!AD15))","v":""},{"$f":"IF(AB12>Access_Period,IF(AB12=\"Rehabilitation\",IF($C$8=\"\",AA16,$C$8),\"\"),IF(AND(AB12<=Access_Period,INPUT!AE15=\"\"),AA16,INPUT!AE15))","v":""},{"$f":"IF(AC12>Access_Period,IF(AC12=\"Rehabilitation\",IF($C$8=\"\",AB16,$C$8),\"\"),IF(AND(AC12<=Access_Period,INPUT!AF15=\"\"),AB16,INPUT!AF15))","v":""},{"$f":"IF(AD12>Access_Period,IF(AD12=\"Rehabilitation\",IF($C$8=\"\",AC16,$C$8),\"\"),IF(AND(AD12<=Access_Period,INPUT!AG15=\"\"),AC16,INPUT!AG15))","v":""},{"$f":"IF(AE12>Access_Period,IF(AE12=\"Rehabilitation\",IF($C$8=\"\",AD16,$C$8),\"\"),IF(AND(AE12<=Access_Period,INPUT!AH15=\"\"),AD16,INPUT!AH15))","v":""},{"$f":"IF(AF12>Access_Period,IF(AF12=\"Rehabilitation\",IF($C$8=\"\",AE16,$C$8),\"\"),IF(AND(AF12<=Access_Period,INPUT!AI15=\"\"),AE16,INPUT!AI15))","v":""},{"$f":"IF(AG12>Access_Period,IF(AG12=\"Rehabilitation\",IF($C$8=\"\",AF16,$C$8),\"\"),IF(AND(AG12<=Access_Period,INPUT!AJ15=\"\"),AF16,INPUT!AJ15))","v":""},{"$f":"IF(AH12>Access_Period,IF(AH12=\"Rehabilitation\",IF($C$8=\"\",AG16,$C$8),\"\"),IF(AND(AH12<=Access_Period,INPUT!AK15=\"\"),AG16,INPUT!AK15))","v":""}]
[null,"Injurious affections",null,{"$f":"IF(D12>Access_Period,IF(D12=\"Rehabilitation\",IF($C$9=\"\",C17,$C$9),\"\"),IF(AND(D12<=Access_Period,INPUT!G16=\"\"),C17,INPUT!G16))","v":0.2},{"$f":"IF(E12>Access_Period,IF(E12=\"Rehabilitation\",IF($C$9=\"\",D17,$C$9),\"\"),IF(AND(E12<=Access_Period,INPUT!H16=\"\"),D17,INPUT!H16))","v":0.1},{"$f":"IF(F12>Access_Period,IF(F12=\"Rehabilitation\",IF($C$9=\"\",E17,$C$9),\"\"),IF(AND(F12<=Access_Period,INPUT!I16=\"\"),E17,INPUT!I16))","v":0.1},{"$f":"IF(G12>Access_Period,IF(G12=\"Rehabilitation\",IF($C$9=\"\",F17,$C$9),\"\"),IF(AND(G12<=Access_Period,INPUT!J16=\"\"),F17,INPUT!J16))","v":0.1},{"$f":"IF(H12>Access_Period,IF(H12=\"Rehabilitation\",IF($C$9=\"\",G17,$C$9),\"\"),IF(AND(H12<=Access_Period,INPUT!K16=\"\"),G17,INPUT!K16))","v":0.1},{"$f":"IF(I12>Access_Period,IF(I12=\"Rehabilitation\",IF($C$9=\"\",H17,$C$9),\"\"),IF(AND(I12<=Access_Period,INPUT!L16=\"\"),H17,INPUT!L16))","v":0.1},{"$f":"IF(J12>Access_Period,IF(J12=\"Rehabilitation\",IF($C$9=\"\",I17,$C$9),\"\"),IF(AND(J12<=Access_Period,INPUT!M16=\"\"),I17,INPUT!M16))","v":0.1},{"$f":"IF(K12>Access_Period,IF(K12=\"Rehabilitation\",IF($C$9=\"\",J17,$C$9),\"\"),IF(AND(K12<=Access_Period,INPUT!N16=\"\"),J17,INPUT!N16))","v":0.1},{"$f":"IF(L12>Access_Period,IF(L12=\"Rehabilitation\",IF($C$9=\"\",K17,$C$9),\"\"),IF(AND(L12<=Access_Period,INPUT!O16=\"\"),K17,INPUT!O16))","v":0.1},{"$f":"IF(M12>Access_Period,IF(M12=\"Rehabilitation\",IF($C$9=\"\",L17,$C$9),\"\"),IF(AND(M12<=Access_Period,INPUT!P16=\"\"),L17,INPUT!P16))","v":0.1},{"$f":"IF(N12>Access_Period,IF(N12=\"Rehabilitation\",IF($C$9=\"\",M17,$C$9),\"\"),IF(AND(N12<=Access_Period,INPUT!Q16=\"\"),M17,INPUT!Q16))","v":0.1},{"$f":"IF(O12>Access_Period,IF(O12=\"Rehabilitation\",IF($C$9=\"\",N17,$C$9),\"\"),IF(AND(O12<=Access_Period,INPUT!R16=\"\"),N17,INPUT!R16))","v":0.1},{"$f":"IF(P12>Access_Period,IF(P12=\"Rehabilitation\",IF($C$9=\"\",O17,$C$9),\"\"),IF(AND(P12<=Access_Period,INPUT!S16=\"\"),O17,INPUT!S16))","v":0.1},{"$f":"IF(Q12>Access_Period,IF(Q12=\"Rehabilitation\",IF($C$9=\"\",P17,$C$9),\"\"),IF(AND(Q12<=Access_Period,INPUT!T16=\"\"),P17,INPUT!T16))","v":0.1},{"$f":"IF(R12>Access_Period,IF(R12=\"Rehabilitation\",IF($C$9=\"\",Q17,$C$9),\"\"),IF(AND(R12<=Access_Period,INPUT!U16=\"\"),Q17,INPUT!U16))","v":0.1},{"$f":"IF(S12>Access_Period,IF(S12=\"Rehabilitation\",IF($C$9=\"\",R17,$C$9),\"\"),IF(AND(S12<=Access_Period,INPUT!V16=\"\"),R17,INPUT!V16))","v":0.1},{"$f":"IF(T12>Access_Period,IF(T12=\"Rehabilitation\",IF($C$9=\"\",S17,$C$9),\"\"),IF(AND(T12<=Access_Period,INPUT!W16=\"\"),S17,INPUT!W16))","v":0.1},{"$f":"IF(U12>Access_Period,IF(U12=\"Rehabilitation\",IF($C$9=\"\",T17,$C$9),\"\"),IF(AND(U12<=Access_Period,INPUT!X16=\"\"),T17,INPUT!X16))","v":0.1},{"$f":"IF(V12>Access_Period,IF(V12=\"Rehabilitation\",IF($C$9=\"\",U17,$C$9),\"\"),IF(AND(V12<=Access_Period,INPUT!Y16=\"\"),U17,INPUT!Y16))","v":0.1},{"$f":"IF(W12>Access_Period,IF(W12=\"Rehabilitation\",IF($C$9=\"\",V17,$C$9),\"\"),IF(AND(W12<=Access_Period,INPUT!Z16=\"\"),V17,INPUT!Z16))","v":0.1},{"$f":"IF(X12>Access_Period,IF(X12=\"Rehabilitation\",IF($C$9=\"\",W17,$C$9),\"\"),IF(AND(X12<=Access_Period,INPUT!AA16=\"\"),W17,INPUT!AA16))","v":0.1},{"$f":"IF(Y12>Access_Period,IF(Y12=\"Rehabilitation\",IF($C$9=\"\",X17,$C$9),\"\"),IF(AND(Y12<=Access_Period,INPUT!AB16=\"\"),X17,INPUT!AB16))","v":""},{"$f":"IF(Z12>Access_Period,IF(Z12=\"Rehabilitation\",IF($C$9=\"\",Y17,$C$9),\"\"),IF(AND(Z12<=Access_Period,INPUT!AC16=\"\"),Y17,INPUT!AC16))","v":""},{"$f":"IF(AA12>Access_Period,IF(AA12=\"Rehabilitation\",IF($C$9=\"\",Z17,$C$9),\"\"),IF(AND(AA12<=Access_Period,INPUT!AD16=\"\"),Z17,INPUT!AD16))","v":""},{"$f":"IF(AB12>Access_Period,IF(AB12=\"Rehabilitation\",IF($C$9=\"\",AA17,$C$9),\"\"),IF(AND(AB12<=Access_Period,INPUT!AE16=\"\"),AA17,INPUT!AE16))","v":""},{"$f":"IF(AC12>Access_Period,IF(AC12=\"Rehabilitation\",IF($C$9=\"\",AB17,$C$9),\"\"),IF(AND(AC12<=Access_Period,INPUT!AF16=\"\"),AB17,INPUT!AF16))","v":""},{"$f":"IF(AD12>Access_Period,IF(AD12=\"Rehabilitation\",IF($C$9=\"\",AC17,$C$9),\"\"),IF(AND(AD12<=Access_Period,INPUT!AG16=\"\"),AC17,INPUT!AG16))","v":""},{"$f":"IF(AE12>Access_Period,IF(AE12=\"Rehabilitation\",IF($C$9=\"\",AD17,$C$9),\"\"),IF(AND(AE12<=Access_Period,INPUT!AH16=\"\"),AD17,INPUT!AH16))","v":""},{"$f":"IF(AF12>Access_Period,IF(AF12=\"Rehabilitation\",IF($C$9=\"\",AE17,$C$9),\"\"),IF(AND(AF12<=Access_Period,INPUT!AI16=\"\"),AE17,INPUT!AI16))","v":""},{"$f":"IF(AG12>Access_Period,IF(AG12=\"Rehabilitation\",IF($C$9=\"\",AF17,$C$9),\"\"),IF(AND(AG12<=Access_Period,INPUT!AJ16=\"\"),AF17,INPUT!AJ16))","v":""},{"$f":"IF(AH12>Access_Period,IF(AH12=\"Rehabilitation\",IF($C$9=\"\",AG17,$C$9),\"\"),IF(AND(AH12<=Access_Period,INPUT!AK16=\"\"),AG17,INPUT!AK16))","v":""}]
[null,{"$f":"INPUT!C32","v":"Gas company's statutory annual royalty payment  in nominal terms (ie, including inflation)"},null,{"$f":"IF(OR(D12<Production_Year,D12>Access_Period),\"\",IF(AND(D12>Production_Year,INPUT!G32=\"\"),C18*(1+Inflation),INPUT!G32))","v":""},{"$f":"IF(OR(E12<Production_Year,E12>Access_Period),\"\",IF(AND(E12>Production_Year,INPUT!H32=\"\"),D18*(1+Inflation),INPUT!H32))","v":""},{"$f":"IF(OR(F12<Production_Year,F12>Access_Period),\"\",IF(AND(F12>Production_Year,INPUT!I32=\"\"),E18*(1+Inflation),INPUT!I32))","v":""},{"$f":"IF(OR(G12<Production_Year,G12>Access_Period),\"\",IF(AND(G12>Production_Year,INPUT!J32=\"\"),F18*(1+Inflation),INPUT!J32))","v":1500000},{"$f":"IF(OR(H12<Production_Year,H12>Access_Period),\"\",IF(AND(H12>Production_Year,INPUT!K32=\"\"),G18*(1+Inflation),INPUT!K32))","v":1537499.9999999998},{"$f":"IF(OR(I12<Production_Year,I12>Access_Period),\"\",IF(AND(I12>Production_Year,INPUT!L32=\"\"),H18*(1+Inflation),INPUT!L32))","v":1575937.4999999995},{"$f":"IF(OR(J12<Production_Year,J12>Access_Period),\"\",IF(AND(J12>Production_Year,INPUT!M32=\"\"),I18*(1+Inflation),INPUT!M32))","v":1615335.9374999993},{"$f":"IF(OR(K12<Production_Year,K12>Access_Period),\"\",IF(AND(K12>Production_Year,INPUT!N32=\"\"),J18*(1+Inflation),INPUT!N32))","v":1655719.3359374991},{"$f":"IF(OR(L12<Production_Year,L12>Access_Period),\"\",IF(AND(L12>Production_Year,INPUT!O32=\"\"),K18*(1+Inflation),INPUT!O32))","v":1697112.3193359363},{"$f":"IF(OR(M12<Production_Year,M12>Access_Period),\"\",IF(AND(M12>Production_Year,INPUT!P32=\"\"),L18*(1+Inflation),INPUT!P32))","v":1739540.1273193345},{"$f":"IF(OR(N12<Production_Year,N12>Access_Period),\"\",IF(AND(N12>Production_Year,INPUT!Q32=\"\"),M18*(1+Inflation),INPUT!Q32))","v":1783028.6305023178},{"$f":"IF(OR(O12<Production_Year,O12>Access_Period),\"\",IF(AND(O12>Production_Year,INPUT!R32=\"\"),N18*(1+Inflation),INPUT!R32))","v":1827604.3462648755},{"$f":"IF(OR(P12<Production_Year,P12>Access_Period),\"\",IF(AND(P12>Production_Year,INPUT!S32=\"\"),O18*(1+Inflation),INPUT!S32))","v":1873294.4549214973},{"$f":"IF(OR(Q12<Production_Year,Q12>Access_Period),\"\",IF(AND(Q12>Production_Year,INPUT!T32=\"\"),P18*(1+Inflation),INPUT!T32))","v":1920126.8162945346},{"$f":"IF(OR(R12<Production_Year,R12>Access_Period),\"\",IF(AND(R12>Production_Year,INPUT!U32=\"\"),Q18*(1+Inflation),INPUT!U32))","v":1968129.9867018978},{"$f":"IF(OR(S12<Production_Year,S12>Access_Period),\"\",IF(AND(S12>Production_Year,INPUT!V32=\"\"),R18*(1+Inflation),INPUT!V32))","v":2017333.236369445},{"$f":"IF(OR(T12<Production_Year,T12>Access_Period),\"\",IF(AND(T12>Production_Year,INPUT!W32=\"\"),S18*(1+Inflation),INPUT!W32))","v":2067766.5672786809},{"$f":"IF(OR(U12<Production_Year,U12>Access_Period),\"\",IF(AND(U12>Production_Year,INPUT!X32=\"\"),T18*(1+Inflation),INPUT!X32))","v":2119460.7314606477},{"$f":"IF(OR(V12<Production_Year,V12>Access_Period),\"\",IF(AND(V12>Production_Year,INPUT!Y32=\"\"),U18*(1+Inflation),INPUT!Y32))","v":2172447.2497471636},{"$f":"IF(OR(W12<Production_Year,W12>Access_Period),\"\",IF(AND(W12>Production_Year,INPUT!Z32=\"\"),V18*(1+Inflation),INPUT!Z32))","v":2226758.4309908426},{"$f":"IF(OR(X12<Production_Year,X12>Access_Period),\"\",IF(AND(X12>Production_Year,INPUT!AA32=\"\"),W18*(1+Inflation),INPUT!AA32))","v":""},{"$f":"IF(OR(Y12<Production_Year,Y12>Access_Period),\"\",IF(AND(Y12>Production_Year,INPUT!AB32=\"\"),X18*(1+Inflation),INPUT!AB32))","v":""},{"$f":"IF(OR(Z12<Production_Year,Z12>Access_Period),\"\",IF(AND(Z12>Production_Year,INPUT!AC32=\"\"),Y18*(1+Inflation),INPUT!AC32))","v":""},{"$f":"IF(OR(AA12<Production_Year,AA12>Access_Period),\"\",IF(AND(AA12>Production_Year,INPUT!AD32=\"\"),Z18*(1+Inflation),INPUT!AD32))","v":""},{"$f":"IF(OR(AB12<Production_Year,AB12>Access_Period),\"\",IF(AND(AB12>Production_Year,INPUT!AE32=\"\"),AA18*(1+Inflation),INPUT!AE32))","v":""},{"$f":"IF(OR(AC12<Production_Year,AC12>Access_Period),\"\",IF(AND(AC12>Production_Year,INPUT!AF32=\"\"),AB18*(1+Inflation),INPUT!AF32))","v":""},{"$f":"IF(OR(AD12<Production_Year,AD12>Access_Period),\"\",IF(AND(AD12>Production_Year,INPUT!AG32=\"\"),AC18*(1+Inflation),INPUT!AG32))","v":""},{"$f":"IF(OR(AE12<Production_Year,AE12>Access_Period),\"\",IF(AND(AE12>Production_Year,INPUT!AH32=\"\"),AD18*(1+Inflation),INPUT!AH32))","v":""},{"$f":"IF(OR(AF12<Production_Year,AF12>Access_Period),\"\",IF(AND(AF12>Production_Year,INPUT!AI32=\"\"),AE18*(1+Inflation),INPUT!AI32))","v":""},{"$f":"IF(OR(AG12<Production_Year,AG12>Access_Period),\"\",IF(AND(AG12>Production_Year,INPUT!AJ32=\"\"),AF18*(1+Inflation),INPUT!AJ32))","v":""},{"$f":"IF(OR(AH12<Production_Year,AH12>Access_Period),\"\",IF(AND(AH12>Production_Year,INPUT!AK32=\"\"),AG18*(1+Inflation),INPUT!AK32))","v":""}]
[null,{"$f":"INPUT!C33","v":"% of royalty gas company contributes to incentive fund"},null,{"$f":"IF(OR(D12<Production_Year,D12>Access_Period),\"\",IF(AND(D12>Production_Year,INPUT!G33=\"\"),C19,INPUT!G33))","v":""},{"$f":"IF(OR(E12<Production_Year,E12>Access_Period),\"\",IF(AND(E12>Production_Year,INPUT!H33=\"\"),D19,INPUT!H33))","v":""},{"$f":"IF(OR(F12<Production_Year,F12>Access_Period),\"\",IF(AND(F12>Production_Year,INPUT!I33=\"\"),E19,INPUT!I33))","v":""},{"$f":"IF(OR(G12<Production_Year,G12>Access_Period),\"\",IF(AND(G12>Production_Year,INPUT!J33=\"\"),F19,INPUT!J33))","v":5},{"$f":"IF(OR(H12<Production_Year,H12>Access_Period),\"\",IF(AND(H12>Production_Year,INPUT!K33=\"\"),G19,INPUT!K33))","v":5},{"$f":"IF(OR(I12<Production_Year,I12>Access_Period),\"\",IF(AND(I12>Production_Year,INPUT!L33=\"\"),H19,INPUT!L33))","v":5},{"$f":"IF(OR(J12<Production_Year,J12>Access_Period),\"\",IF(AND(J12>Production_Year,INPUT!M33=\"\"),I19,INPUT!M33))","v":5},{"$f":"IF(OR(K12<Production_Year,K12>Access_Period),\"\",IF(AND(K12>Production_Year,INPUT!N33=\"\"),J19,INPUT!N33))","v":5},{"$f":"IF(OR(L12<Production_Year,L12>Access_Period),\"\",IF(AND(L12>Production_Year,INPUT!O33=\"\"),K19,INPUT!O33))","v":5},{"$f":"IF(OR(M12<Production_Year,M12>Access_Period),\"\",IF(AND(M12>Production_Year,INPUT!P33=\"\"),L19,INPUT!P33))","v":5},{"$f":"IF(OR(N12<Production_Year,N12>Access_Period),\"\",IF(AND(N12>Production_Year,INPUT!Q33=\"\"),M19,INPUT!Q33))","v":5},{"$f":"IF(OR(O12<Production_Year,O12>Access_Period),\"\",IF(AND(O12>Production_Year,INPUT!R33=\"\"),N19,INPUT!R33))","v":5},{"$f":"IF(OR(P12<Production_Year,P12>Access_Period),\"\",IF(AND(P12>Production_Year,INPUT!S33=\"\"),O19,INPUT!S33))","v":5},{"$f":"IF(OR(Q12<Production_Year,Q12>Access_Period),\"\",IF(AND(Q12>Production_Year,INPUT!T33=\"\"),P19,INPUT!T33))","v":5},{"$f":"IF(OR(R12<Production_Year,R12>Access_Period),\"\",IF(AND(R12>Production_Year,INPUT!U33=\"\"),Q19,INPUT!U33))","v":5},{"$f":"IF(OR(S12<Production_Year,S12>Access_Period),\"\",IF(AND(S12>Production_Year,INPUT!V33=\"\"),R19,INPUT!V33))","v":5},{"$f":"IF(OR(T12<Production_Year,T12>Access_Period),\"\",IF(AND(T12>Production_Year,INPUT!W33=\"\"),S19,INPUT!W33))","v":5},{"$f":"IF(OR(U12<Production_Year,U12>Access_Period),\"\",IF(AND(U12>Production_Year,INPUT!X33=\"\"),T19,INPUT!X33))","v":5},{"$f":"IF(OR(V12<Production_Year,V12>Access_Period),\"\",IF(AND(V12>Production_Year,INPUT!Y33=\"\"),U19,INPUT!Y33))","v":5},{"$f":"IF(OR(W12<Production_Year,W12>Access_Period),\"\",IF(AND(W12>Production_Year,INPUT!Z33=\"\"),V19,INPUT!Z33))","v":5},{"$f":"IF(OR(X12<Production_Year,X12>Access_Period),\"\",IF(AND(X12>Production_Year,INPUT!AA33=\"\"),W19,INPUT!AA33))","v":""},{"$f":"IF(OR(Y12<Production_Year,Y12>Access_Period),\"\",IF(AND(Y12>Production_Year,INPUT!AB33=\"\"),X19,INPUT!AB33))","v":""},{"$f":"IF(OR(Z12<Production_Year,Z12>Access_Period),\"\",IF(AND(Z12>Production_Year,INPUT!AC33=\"\"),Y19,INPUT!AC33))","v":""},{"$f":"IF(OR(AA12<Production_Year,AA12>Access_Period),\"\",IF(AND(AA12>Production_Year,INPUT!AD33=\"\"),Z19,INPUT!AD33))","v":""},{"$f":"IF(OR(AB12<Production_Year,AB12>Access_Period),\"\",IF(AND(AB12>Production_Year,INPUT!AE33=\"\"),AA19,INPUT!AE33))","v":""},{"$f":"IF(OR(AC12<Production_Year,AC12>Access_Period),\"\",IF(AND(AC12>Production_Year,INPUT!AF33=\"\"),AB19,INPUT!AF33))","v":""},{"$f":"IF(OR(AD12<Production_Year,AD12>Access_Period),\"\",IF(AND(AD12>Production_Year,INPUT!AG33=\"\"),AC19,INPUT!AG33))","v":""},{"$f":"IF(OR(AE12<Production_Year,AE12>Access_Period),\"\",IF(AND(AE12>Production_Year,INPUT!AH33=\"\"),AD19,INPUT!AH33))","v":""},{"$f":"IF(OR(AF12<Production_Year,AF12>Access_Period),\"\",IF(AND(AF12>Production_Year,INPUT!AI33=\"\"),AE19,INPUT!AI33))","v":""},{"$f":"IF(OR(AG12<Production_Year,AG12>Access_Period),\"\",IF(AND(AG12>Production_Year,INPUT!AJ33=\"\"),AF19,INPUT!AJ33))","v":""},{"$f":"IF(OR(AH12<Production_Year,AH12>Access_Period),\"\",IF(AND(AH12>Production_Year,INPUT!AK33=\"\"),AG19,INPUT!AK33))","v":""}]
[null,{"$f":"INPUT!C34","v":"Total licence area for production"},null,{"$f":"IF(OR(D12<Production_Year,D12>Access_Period),\"\",IF(AND(D12>Production_Year,INPUT!G34=\"\"),C20,INPUT!G34))","v":""},{"$f":"IF(OR(E12<Production_Year,E12>Access_Period),\"\",IF(AND(E12>Production_Year,INPUT!H34=\"\"),D20,INPUT!H34))","v":""},{"$f":"IF(OR(F12<Production_Year,F12>Access_Period),\"\",IF(AND(F12>Production_Year,INPUT!I34=\"\"),E20,INPUT!I34))","v":""},{"$f":"IF(OR(G12<Production_Year,G12>Access_Period),\"\",IF(AND(G12>Production_Year,INPUT!J34=\"\"),F20,INPUT!J34))","v":22},{"$f":"IF(OR(H12<Production_Year,H12>Access_Period),\"\",IF(AND(H12>Production_Year,INPUT!K34=\"\"),G20,INPUT!K34))","v":22},{"$f":"IF(OR(I12<Production_Year,I12>Access_Period),\"\",IF(AND(I12>Production_Year,INPUT!L34=\"\"),H20,INPUT!L34))","v":22},{"$f":"IF(OR(J12<Production_Year,J12>Access_Period),\"\",IF(AND(J12>Production_Year,INPUT!M34=\"\"),I20,INPUT!M34))","v":22},{"$f":"IF(OR(K12<Production_Year,K12>Access_Period),\"\",IF(AND(K12>Production_Year,INPUT!N34=\"\"),J20,INPUT!N34))","v":22},{"$f":"IF(OR(L12<Production_Year,L12>Access_Period),\"\",IF(AND(L12>Production_Year,INPUT!O34=\"\"),K20,INPUT!O34))","v":22},{"$f":"IF(OR(M12<Production_Year,M12>Access_Period),\"\",IF(AND(M12>Production_Year,INPUT!P34=\"\"),L20,INPUT!P34))","v":22},{"$f":"IF(OR(N12<Production_Year,N12>Access_Period),\"\",IF(AND(N12>Production_Year,INPUT!Q34=\"\"),M20,INPUT!Q34))","v":22},{"$f":"IF(OR(O12<Production_Year,O12>Access_Period),\"\",IF(AND(O12>Production_Year,INPUT!R34=\"\"),N20,INPUT!R34))","v":22},{"$f":"IF(OR(P12<Production_Year,P12>Access_Period),\"\",IF(AND(P12>Production_Year,INPUT!S34=\"\"),O20,INPUT!S34))","v":22},{"$f":"IF(OR(Q12<Production_Year,Q12>Access_Period),\"\",IF(AND(Q12>Production_Year,INPUT!T34=\"\"),P20,INPUT!T34))","v":22},{"$f":"IF(OR(R12<Production_Year,R12>Access_Period),\"\",IF(AND(R12>Production_Year,INPUT!U34=\"\"),Q20,INPUT!U34))","v":22},{"$f":"IF(OR(S12<Production_Year,S12>Access_Period),\"\",IF(AND(S12>Production_Year,INPUT!V34=\"\"),R20,INPUT!V34))","v":22},{"$f":"IF(OR(T12<Production_Year,T12>Access_Period),\"\",IF(AND(T12>Production_Year,INPUT!W34=\"\"),S20,INPUT!W34))","v":22},{"$f":"IF(OR(U12<Production_Year,U12>Access_Period),\"\",IF(AND(U12>Production_Year,INPUT!X34=\"\"),T20,INPUT!X34))","v":22},{"$f":"IF(OR(V12<Production_Year,V12>Access_Period),\"\",IF(AND(V12>Production_Year,INPUT!Y34=\"\"),U20,INPUT!Y34))","v":22},{"$f":"IF(OR(W12<Production_Year,W12>Access_Period),\"\",IF(AND(W12>Production_Year,INPUT!Z34=\"\"),V20,INPUT!Z34))","v":22},{"$f":"IF(OR(X12<Production_Year,X12>Access_Period),\"\",IF(AND(X12>Production_Year,INPUT!AA34=\"\"),W20,INPUT!AA34))","v":""},{"$f":"IF(OR(Y12<Production_Year,Y12>Access_Period),\"\",IF(AND(Y12>Production_Year,INPUT!AB34=\"\"),X20,INPUT!AB34))","v":""},{"$f":"IF(OR(Z12<Production_Year,Z12>Access_Period),\"\",IF(AND(Z12>Production_Year,INPUT!AC34=\"\"),Y20,INPUT!AC34))","v":""},{"$f":"IF(OR(AA12<Production_Year,AA12>Access_Period),\"\",IF(AND(AA12>Production_Year,INPUT!AD34=\"\"),Z20,INPUT!AD34))","v":""},{"$f":"IF(OR(AB12<Production_Year,AB12>Access_Period),\"\",IF(AND(AB12>Production_Year,INPUT!AE34=\"\"),AA20,INPUT!AE34))","v":""},{"$f":"IF(OR(AC12<Production_Year,AC12>Access_Period),\"\",IF(AND(AC12>Production_Year,INPUT!AF34=\"\"),AB20,INPUT!AF34))","v":""},{"$f":"IF(OR(AD12<Production_Year,AD12>Access_Period),\"\",IF(AND(AD12>Production_Year,INPUT!AG34=\"\"),AC20,INPUT!AG34))","v":""},{"$f":"IF(OR(AE12<Production_Year,AE12>Access_Period),\"\",IF(AND(AE12>Production_Year,INPUT!AH34=\"\"),AD20,INPUT!AH34))","v":""},{"$f":"IF(OR(AF12<Production_Year,AF12>Access_Period),\"\",IF(AND(AF12>Production_Year,INPUT!AI34=\"\"),AE20,INPUT!AI34))","v":""},{"$f":"IF(OR(AG12<Production_Year,AG12>Access_Period),\"\",IF(AND(AG12>Production_Year,INPUT!AJ34=\"\"),AF20,INPUT!AJ34))","v":""},{"$f":"IF(OR(AH12<Production_Year,AH12>Access_Period),\"\",IF(AND(AH12>Production_Year,INPUT!AK34=\"\"),AG20,INPUT!AK34))","v":""}]
[]
[null,"PART A.  Annual Compensation Payments"]
[null,"Beginning of Year",null,{"$f":"D12","v":1},{"$f":"E12","v":2},3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,"Rehabilitation","","","","","","","","","",""]
[null,"Rent for land",null,{"$f":"IF(OR(D$12<=Access_Period,D$12=\"Rehabilitation\"),D15*D13*D14,\"\")","v":12000},6457.4999999999991,6618.9374999999991,6784.410937499998,8505,8717.625,8935.5656249999993,9158.9547656249997,9387.9286347656252,9622.6268506347642,9863.1925219006316,10109.772334948146,10362.516643321849,10621.579559404894,10887.119048390015,11159.297024599764,11438.279450214759,11724.236436470126,12017.34234738188,12317.775906066425,12317.775906066425,"","","","","","","","","",""]
[null,"Payment for severance",null,{"$f":"IF(OR(D$12<=Access_Period,D$12=\"Rehabilitation\"),(Total_Landholding-D15)*D13*D14*D16,\"\")","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"","","","","","","","","",""]
[null,"Payment for injurious affections",null,{"$f":"IF(OR(D$12<=Access_Period,D$12=\"Rehabilitation\"),(Total_Landholding-D15)*D13*D14*D17,\"\")","v":45600},23954.25,24553.106249999997,25166.933906249993,31549.5,32338.237500000003,33146.693437500006,33975.360773437504,34824.744792773439,35695.363412592764,36587.747497907578,37502.441185355266,38440.002214989152,39401.002270363868,40386.027327122967,41395.678010301031,42430.569960558554,43491.334209572524,44578.617564811822,45693.083003932115,45693.083003932115,"","","","","","","","","",""]
[null,"Payment for landholder time",null,{"$f":"IF(D$12<=Access_Period,Initial_Time_Spent*Value_of_Time+Advice_Cost,\"\")","v":47500},{"$f":"IF(E$12<=Access_Period,Ongoing_Time_Spent*Value_of_Time*(1+Inflation)^(E12-$D$12),\"\")","v":2562.5},2626.5625,2692.2265624999995,2759.5322265624995,2828.5205322265615,2899.2335455322254,2971.714384170531,3046.0072437747945,3122.1574248691636,3200.2113604908927,3280.2166445031648,3362.2220606157439,3446.2776121311372,3532.4345524344153,3620.7454162452764,3711.264051651408,3804.0456529426924,3899.1467942662598,3996.6254641229166,"","","","","","","","","","",""]
[null,"Total Annual Payment ($Nominal)",null,{"$f":"IF(D$12<=Access_Period,SUM(D24:D27),IF(D$12=\"Rehabilitation\",SUM(D24:D27)*INPUT!$E$17/52,\"\"))","v":105100},{"$f":"IF(E$12<=Access_Period,SUM(E24:E27),IF(E$12=\"Rehabilitation\",SUM(E24:E27)*INPUT!$E$17/52,\"\"))","v":32974.25},{"$f":"IF(F$12<=Access_Period,SUM(F24:F27),IF(F$12=\"Rehabilitation\",SUM(F24:F27)*INPUT!$E$17/52,\"\"))","v":33798.606249999997},{"$f":"IF(G$12<=Access_Period,SUM(G24:G27),IF(G$12=\"Rehabilitation\",SUM(G24:G27)*INPUT!$E$17/52,\"\"))","v":34643.57140624999},{"$f":"IF(H$12<=Access_Period,SUM(H24:H27),IF(H$12=\"Rehabilitation\",SUM(H24:H27)*INPUT!$E$17/52,\"\"))","v":42814.0322265625},{"$f":"IF(I$12<=Access_Period,SUM(I24:I27),IF(I$12=\"Rehabilitation\",SUM(I24:I27)*INPUT!$E$17/52,\"\"))","v":43884.383032226564},{"$f":"IF(J$12<=Access_Period,SUM(J24:J27),IF(J$12=\"Rehabilitation\",SUM(J24:J27)*INPUT!$E$17/52,\"\"))","v":44981.492608032226},{"$f":"IF(K$12<=Access_Period,SUM(K24:K27),IF(K$12=\"Rehabilitation\",SUM(K24:K27)*INPUT!$E$17/52,\"\"))","v":46106.029923233036},{"$f":"IF(L$12<=Access_Period,SUM(L24:L27),IF(L$12=\"Rehabilitation\",SUM(L24:L27)*INPUT!$E$17/52,\"\"))","v":47258.680671313858},{"$f":"IF(M$12<=Access_Period,SUM(M24:M27),IF(M$12=\"Rehabilitation\",SUM(M24:M27)*INPUT!$E$17/52,\"\"))","v":48440.147688096687},{"$f":"IF(N$12<=Access_Period,SUM(N24:N27),IF(N$12=\"Rehabilitation\",SUM(N24:N27)*INPUT!$E$17/52,\"\"))","v":49651.151380299103},{"$f":"IF(O$12<=Access_Period,SUM(O24:O27),IF(O$12=\"Rehabilitation\",SUM(O24:O27)*INPUT!$E$17/52,\"\"))","v":50892.430164806574},{"$f":"IF(P$12<=Access_Period,SUM(P24:P27),IF(P$12=\"Rehabilitation\",SUM(P24:P27)*INPUT!$E$17/52,\"\"))","v":52164.740918926742},{"$f":"IF(Q$12<=Access_Period,SUM(Q24:Q27),IF(Q$12=\"Rehabilitation\",SUM(Q24:Q27)*INPUT!$E$17/52,\"\"))","v":53468.859441899906},{"$f":"IF(R$12<=Access_Period,SUM(R24:R27),IF(R$12=\"Rehabilitation\",SUM(R24:R27)*INPUT!$E$17/52,\"\"))","v":54805.580927947398},{"$f":"IF(S$12<=Access_Period,SUM(S24:S27),IF(S$12=\"Rehabilitation\",SUM(S24:S27)*INPUT!$E$17/52,\"\"))","v":56175.720451146073},{"$f":"IF(T$12<=Access_Period,SUM(T24:T27),IF(T$12=\"Rehabilitation\",SUM(T24:T27)*INPUT!$E$17/52,\"\"))","v":57580.113462424721},{"$f":"IF(U$12<=Access_Period,SUM(U24:U27),IF(U$12=\"Rehabilitation\",SUM(U24:U27)*INPUT!$E$17/52,\"\"))","v":59019.616298985347},{"$f":"IF(V$12<=Access_Period,SUM(V24:V27),IF(V$12=\"Rehabilitation\",SUM(V24:V27)*INPUT!$E$17/52,\"\"))","v":60495.106706459963},{"$f":"IF(W$12<=Access_Period,SUM(W24:W27),IF(W$12=\"Rehabilitation\",SUM(W24:W27)*INPUT!$E$17/52,\"\"))","v":62007.484374121457},{"$f":"IF(X$12<=Access_Period,SUM(X24:X27),IF(X$12=\"Rehabilitation\",SUM(X24:X27)*INPUT!$E$17/52,\"\"))","v":58010.85890999854},{"$f":"IF(Y$12<=Access_Period,SUM(Y24:Y27),IF(Y$12=\"Rehabilitation\",SUM(Y24:Y27)*INPUT!$E$17/52,\"\"))","v":""},{"$f":"IF(Z$12<=Access_Period,SUM(Z24:Z27),IF(Z$12=\"Rehabilitation\",SUM(Z24:Z27)*INPUT!$E$17/52,\"\"))","v":""},{"$f":"IF(AA$12<=Access_Period,SUM(AA24:AA27),IF(AA$12=\"Rehabilitation\",SUM(AA24:AA27)*INPUT!$E$17/52,\"\"))","v":""},{"$f":"IF(AB$12<=Access_Period,SUM(AB24:AB27),IF(AB$12=\"Rehabilitation\",SUM(AB24:AB27)*INPUT!$E$17/52,\"\"))","v":""},{"$f":"IF(AC$12<=Access_Period,SUM(AC24:AC27),IF(AC$12=\"Rehabilitation\",SUM(AC24:AC27)*INPUT!$E$17/52,\"\"))","v":""},{"$f":"IF(AD$12<=Access_Period,SUM(AD24:AD27),IF(AD$12=\"Rehabilitation\",SUM(AD24:AD27)*INPUT!$E$17/52,\"\"))","v":""},{"$f":"IF(AE$12<=Access_Period,SUM(AE24:AE27),IF(AE$12=\"Rehabilitation\",SUM(AE24:AE27)*INPUT!$E$17/52,\"\"))","v":""},{"$f":"IF(AF$12<=Access_Period,SUM(AF24:AF27),IF(AF$12=\"Rehabilitation\",SUM(AF24:AF27)*INPUT!$E$17/52,\"\"))","v":""},{"$f":"IF(AG$12<=Access_Period,SUM(AG24:AG27),IF(AG$12=\"Rehabilitation\",SUM(AG24:AG27)*INPUT!$E$17/52,\"\"))","v":""},{"$f":"IF(AH$12<=Access_Period,SUM(AH24:AH27),IF(AH$12=\"Rehabilitation\",SUM(AH24:AH27)*INPUT!$E$17/52,\"\"))","v":""}]
[]
[null,"PART B.  Annual Compensation Payments"]
[null,"Beginning of Year",null,{"$f":"IF(D11<=Access_Period,D11,\"\")","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,"","","","","","","","","","",""]
[null,"Lump-Sum Payment ($Nominal)",null,{"$f":"SUM(D33:AH33)","v":755349.01357605541}]
[null,"PV of Annual Payments ($Nominal)",null,{"$f":"IF(D23<=Access_Period,D28,\"\")","v":105100},{"$f":"IF(E23<=Access_Period,E28*(1+Interest_Rate)^-(E23-$D$23),\"\")","v":31859.178743961354},31551.360591845783,31246.516528156451,37309.955620274093,36949.472957276288,36592.473218558633,36238.922752678845,35888.788233329295,35542.036656195669,35198.63533584596,34858.551902649378,34521.754299725224,34188.210779921123,33857.889902820432,33530.760531778687,33206.791830988557,32885.953262573217,32568.214583707766,32253.545843768563,"","","","","","","","","","",""]
[]
[null,"PART C.  Benefit Payments"]
[null,"Beginning of Year",null,{"$f":"IF(D11<=Access_Period,D11,\"\")","v":1},2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,"","","","","","","","","","",""]
[null,{"$f":"\"Annual Total in Year \"& Production_Year+1 &\" Dollar (Nominal)\"","v":"Annual Total in Year 5 Dollar (Nominal)"},null,{"$f":"IF(AND(D36>Production_Year,D36<=Access_Period),IF(Incentive_Option=1,C18*(C19/100)*(C15/C20),IF(Incentive_Option=2,C18*C19/C20,C18)),\"\")","v":""},"","","",17897.727272727272,18345.170454545452,18803.799715909088,19273.894708806813,19755.742076526978,20249.635628440152,20755.876519151152,21274.773432129932,21806.642767933175,22351.808837131503,22910.604058059791,23483.369159511283,24070.453388499063,24672.214723211535,25289.020091291819,25921.245593574113,"","","","","","","","","","",""]
[]
[]
[null,"PART D.  Final Rehabilitation Payment",null,null,null,null,{"$f":"Incentive_Option","v":1}]
[null,"Rehabilitation",null,{"$f":"INDEX(D28:AH28,1,MATCH(B41,D23:AH23,0))","v":58010.85890999854}]

{"sheet":"CONVERSION","index":5,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,1,2,5]]}
[]
[null,"CONVERSION CALCULATOR"]
[null,"This Compensation Model calculates compensation based on land area in hectares and land value ($) per hectare.  If you have different units for your land area and value, please use the following calculator to convert your figures to hectares."]
[null,"Select your land and valuation unit:",1]
[]
[]
[null,{"$f":" \"Enter land area in \" & CHOOSE(C4,'DO NOT DELETE'!F4,'DO NOT DELETE'!F5,'DO NOT DELETE'!F6,'DO NOT DELETE'!F7)","v":"Enter land area in Square metre"},null,{"$f":"CHOOSE(C4,'DO NOT DELETE'!F4,'DO NOT DELETE'!F5,'DO NOT DELETE'!F6,'DO NOT DELETE'!F7)","v":"Square metre"},null,{"$f":"IF(ISNUMBER(C7),CHOOSE(C4,'DO NOT DELETE'!G4,'DO NOT DELETE'!G5,'DO NOT DELETE'!G6,'DO NOT DELETE'!G7)*C7,\"\")","v":""},"Hectares"]
[]
[null,{"$f":" \"Enter land value in $ per \" & CHOOSE(C4,'DO NOT DELETE'!F4,'DO NOT DELETE'!F5,'DO NOT DELETE'!F6,'DO NOT DELETE'!F7)","v":"Enter land value in $ per Square metre"},null,{"$f":"\"per \" & CHOOSE(C4,'DO NOT DELETE'!F4,'DO NOT DELETE'!F5,'DO NOT DELETE'!F6,'DO NOT DELETE'!F7)","v":"per Square metre"},null,{"$f":"IF(ISNUMBER(C9),C9*(1/CHOOSE(C4,'DO NOT DELETE'!G4,'DO NOT DELETE'!G5,'DO NOT DELETE'!G6,'DO NOT DELETE'!G7)),\"\")","v":""},"per Hectare"]

{"sheet":"DO NOT DELETE","index":6,"n_rows":16,"n_cols":32,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
["Benefit payment",null,null,null,null,"Conversion Chart"]
["Type","Payment based on",null,null,null,null,"Hectare"]
[null,"(1) Royalty payment","(2) Meeting target production","(3) Gas company provided an estimate of annual benefit payment",null,"Square metre",1E-4]
["Statutory annual royalty payment","Gas company's statutory annual royalty payment  in nominal terms (ie, including inflation)","Amount of money per well a gas company contributes to the incentive fund in the first year of production when meeting a target level of gas production in nominal terms (ie, including inflation)","An estimate of annual benefit payments in the first year of production in nominal terms (ie, including inflation)",null,"Square kilometre",100]
["Producing well meeting the target production","% of royalty gas company contributes to incentive fund","Total number of producing wells in licence area that exceed the production target","  ",null,"Acre",0.40468564223999998]
["Estimated annual benefit payment","Total licence area for production","Total number of eligible landholders in licence area","  ",null,"Square Yard",8.3612735999999998E-5]
[null,null,null,"   "]
[]
["Inputs for periodic update"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,"Rehabilitation"]
[]
[]
[null,"Dollar per annum","Dollar per producing wells","Dollar per annum"]
[null,"Percent","Wells"]
[null,"Hectares","Landholders"]