{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Menu","1. Declaration under S53A","2. Notes to Complete Analysis","3. Landfill Data - to Complete","4. Financial Data - To Complete","5. Section 53A Analysis","6. Comments - To Complete","7. Data Sheet"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":9,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Menu","index":0,"n_rows":16,"n_cols":2,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,"Welcome. This application is intended for use by licensees of the Environmental Protection Agency in"]
[null,"connection with reporting obligations under Section 53A of the Waste Management Act, 1996 "]
[null,"(as amended)."]
[]
[null,"You can navigate the application using the menu system below (you will need to \"Enable Macros\" or"]
[null,"if you get a Security Warning: Macros have been disabled message please click on \"Options\" above"]
[null,"and choose \"Enable this content\"). Alternatively you can navigate by clicking on the tabs at the bottom "]
[null,"of the screen. If you have any technical queries in relation to the use of this application please contact"]
[null,"[insert contact details here]."]

{"sheet":"1. Declaration under S53A","index":1,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":false,"merged":[[2,0,2,3]]}
[]
[]
["Please click on the declaration below to edit the information in square brackets. Insert the required information, print on letterhead and sign."]

{"sheet":"2. Notes to Complete Analysis","index":2,"n_rows":82,"n_cols":2,"rows_kept":82,"cut":false,"hidden":false,"merged":[[3,0,3,1]]}
[]
[]
[]
["Notes to Assist Completion of the Detailed Analysis Supporting the Statement of Compliance with Section 53A:"]
[]
["Please read these notes carefully prior to the completion of the Detailed Analysis spreadsheet"]
[]
[]
["Note",1]
[null,"Section 53A (sections 1 to 4) of the Waste Management Act, 1996 (as amended) states the following:"]
[null,"(1)   The operator of a landfill facility (other than an internal landfill facility), or such other facility for the disposal of waste as may be prescribed for the purposes of this subsection, shall impose charges in respect of the disposal of waste at the facility."]
[null,"(2)   Subject to subsection (3), different amounts of charges may be imposed under subsection (1) in respect of different disposals of waste at the facility concerned."]
[null,"(3)   The amount or amounts of charges imposed under subsection (1) shall be such as the operator of the facility concerned determines is likely to ensure that the result specified in subsection (4) is achieved."]
[null,"(4)   The result referred to in subsection (3) is that the aggregate of the amount of charges imposed by the operator, in relation to the facility concerned, during the relevant period will not be less than the amount that would meet the following costs (irrespective of whether those costs, or any of them, have been or will be met from other financial measures available to the operator), namely –"]
[null,"(a)   the costs incurred by the operator in the acquisition or development, or both (as the case may be), of the facility,"]
[null,"(b)   the costs of operating the facility during the relevant period (including the costs of making any financial provision under section 53), and"]
[null,"(c)   the estimated costs, during a period of not less than 30 years or such greater period as may be prescribed, of the closure, restoration, remediation or aftercare of the facility."]
[]
["Note",{"$f":"B9+1","v":2}]
[null,"Section 53A requires charges to be imposed during the \"relevant period\".  The EPA hereby specifies that the start of the relevant period is the date of commencement of waste disposal in the landfill and the end of the relevant period is the predicted date of cessation of waste disposal in the landfill.  It should be noted that although the relevant period during which charges must be imposed necessarily relates to the period of waste disposal, the costs that must be met by those charges includes costs incurred outside the relevant period, i.e. acquisition, development, closure, restoration, remediation and aftercare costs.  "]
[]
["Note",{"$f":"B19+1","v":3}]
[null,"Landfill operators must complete the Worsksheet - \"3. Landfill Data - To Complete\"."]
[null,"Landfill operators must complete the Worsksheet - \"4. Financial Data - To Complete\"."]
[null,"Worksheet 5. \"Section 53A Analysis\" summarises the data that you have completed and provides an indication of Section 53A Compliance.  No information needs to be input in this Worksheet."]
[null,"Landfill operators must complete the Worksheet - \"6. Comments - to Complete\" if you have any queries or points of clarification that you would like to make as part of your submission."]
[]
["Note",{"$f":"B22+1","v":4}]
[null,"In the Worksheet - \"3. Landfill Data - To Complete\", please note the following very carefully for Inputs 5, 6 and 7:"]
[null,"(1)   The total disposal capacity of the landfill facility refers to the disposal capacity over the entire lifecycle, i.e. the disposal capacity of full cells plus active cells plus any cells to be constructed in the future.  It should not be confused with total constructed disposal capacity or remaining disposal capacity."]
[null,"(2)   The total disposal capacity should be based on fully consented landfill only, i.e. the parts of the landfill with both planning permission and waste licence."]
[null,"(3)   The capacity is defined by the top of the basal/side liner system and base of the final capping system."]
[null,"(4)   The total disposal capacity refers to waste for disposal only.  A deduction should be made for cover materials left or to be left in-situ."]
[]
["Note",{"$f":"B28+1","v":5}]
[null,"In the Worksheet - \"3. Landfill Data - To Complete\", please note the following very carefully for Input 8:"]
[null,"(1)   The Total Constructed Disposal Capacity refers to the capacity over the entire lifecycle of cells constructed to date, i.e. the capacity of full cells plus active cells plus any cells constructed but not yet in use.  It should not be confused with Total Disposal Capacity or remaining disposal capacity."]
[null,"(2)   The capacity is defined by the top of the basal/side liner system and base of the final capping system."]
[null,"(3)   Total disposal capacity refers to waste for disposal only.  A deduction should be made for cover materials left or to be left in-situ."]
[]
["Note",{"$f":"B35+1","v":6}]
[null,"In the Worksheet - \"4. Financial Data - to Complete\", please input all the data requested (marked in light grey) as positive numbers except where there is (1) a debit i.e. cost in the Revenue section or (2) a credit i.e. income in the Cost sections."]
[null,"Cells marked in green denote cells where the data is automatically completed and hence where you do NOT need to input data to."]
[null,"Cells marked in dark grey should be entirely ignored and no data should be input to these."]
[]
["Note",{"$f":"B41+1","v":7}]
[null,"In the Worksheet - \"4. Financial Data - to Complete\", please complete all the data requested as follows:"]
[null,"- Sections A to D for ALL relevant years (including, if relevant, the \"Total Estimated Prior to Y/E in 2003/2004\" column) up to the year covered by the Section 53A analysis."]
[null,"- Sections E1-E5, which represent total numbers, potentially covering the full lifecycle (including post closure) of the landfill."]
[null,"- Do NOT enter any data in years following the year of the return in question."]
[]
["Note",{"$f":"B46+1","v":8}]
[null,"Do not overwrite formulae or add in columns or rows in any circumstance.  There is a separate row at the end of each section for \"Other\" items."]
[]
["Note",{"$f":"B52+1","v":9}]
[null,"All revenues and costs (operating and capital) should be stated excluding VAT."]
[]
["Note",{"$f":"B55+1","v":10}]
[null,"We ask for landfill levy to be input in both the revenue and operating cost sections such that it will net off to zero.  However, if your financial data excludes it altogether you may put zero into each."]
[]
["Note",{"$f":"B58+1","v":11}]
[null,"Section 53A refers to landfill facilities and the \"disposal of waste at the facility concerned\" and therefore the analysis must exclude revenues and costs unrelated to landfill.  For example, revenues and costs in relation to a composting facility or civic amenity located on site must be EXCLUDED from the analysis."]
[]
["Note",{"$f":"B61+1","v":12}]
[null,"The financial year during which Section 53A was enacted (i.e. 12 July 2004) must be split between two periods - (1) \"Previous Y/E to 11 July 2004\" and (2) \"12 July 2004 to next Y/E\".  You may use a reasonable estimate to split this year."]
[]
["Note",{"$f":"B64+1","v":13}]
[null,"The model allocates (1) Acquisition, (2) Development, and (3) Closure, Remediation, Aftercare and Management Plan (\"CRAMP\") costs to the period prior to the introduction of Section 53A and the period after the introduction of Section 53A (on a year by year basis).  The amount of these costs to be allocated to each year is calculated on the basis of the following:"]
[null,"E1: Tonnage/M3 for Year in question divided by Total Disposal Capacity (in Tonnage/M3)"]
[null,"E2: Tonnage/M3 for Year in question divided by Total Constructed Disposal Capacity (in Tonnage/M3)"]
[null,"E3: Tonnage/M3 for Year in question divided by Total Constructed Disposal Capacity (in Tonnage/M3)"]
[null,"E4: Tonnage/M3 for Year in question divided by Total Constructed Disposal Capacity (in Tonnage/M3)"]
[null,"E5: Tonnage/M3 for Year in question divided by Total Disposal Capacity (in Tonnage/M3)"]
[]
["Note",{"$f":"B67+1","v":14}]
[null,"The \"Adjusted Operating Profit Calculation\" is used for the purposes of making your data consistent with Section 53A and to avoid the double counting of costs.  For example, acquisition and development costs are separately deducted (in part or in full) in this model and therefore if we allowed a separate deduction for depreciation charges, this would represent a double count.  For similar reasons, if there are non cash charges such as Leachate, CRAMP or remediation provisions charged through your Profit & Loss Account then there could be a double count as we ask for the total numbers (over the entire lifecycle) for these items elsewhere."]
[]
["Note",{"$f":"B75+1","v":15}]
[null,"Please correct any Error Messages such as \"Error\", \"No Tonnage\", etc.  They generally result from an omission or data inconsistency."]
[]
["Note",{"$f":"B78+1","v":16}]
[null,"If you have any queries please contact [Person's Name], [Title] on [Telephone Number] or [e-mail address]."]

{"sheet":"3. Landfill Data - to Complete","index":3,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[[18,2,18,3],[22,2,22,3]]}
[]
[]
[]
["Landfill Information Required under Section 53A of the Waste Management Act, 1996 (as amended):"]
[]
[null,"PLEASE E-MAIL THIS WORKBOOK TO: [E-mail address of Relevant EPA staff member]"]
[]
[1,"Year Covered by Section 53A Statement",2011]
[{"$f":"1+A8","v":2},"End of Financial Year which is Covered by this Statement e.g. 31 March 2011, 31 December 2011, etc","2011-12-31"]
[{"$f":"1+A9","v":3},"Licence Registration Number","W1000-002"]
[{"$f":"1+A10","v":4},"Is this Analysis being Completed by you in Weight (Tonnes) or Cubic Capacity (M3)? PLEASE KEEP CONSISTENT THROUGHOUT","Tonnes"]
[5,"Total Disposal Capacity of Landfill Site (over entire lifecycle/relevant period) in either Tonnes/M3 - INPUT NUMBER ONLY",1000000,"Please refer to Note 4 in \"Notes to Complete Analysis\""]
[6,"Total Disposal Capacity of Site based on Planning Permission Restriction (if any) in either Tonnes/M3 - INPUT NUMBER ONLY",900000,"Please refer to Note 4 in \"Notes to Complete Analysis\""]
[7,"If the landfill is to be closed early what will the reduced Total Disposal Capacity be in either Tonnes or M3? - INPUT NUMBER ONLY",null,"Please refer to Note 4 in \"Notes to Complete Analysis\""]
[8,"Total Constructed Disposal Capacity in either Tonnes or M3?  INPUT NUMBER ONLY",800000,"Please refer to Note 5 in \"Notes to Complete Analysis\""]
[null,null,{"$f":"IF(C12=\"\",\"\",IF(C15<>\"\",\"\",\"Error - Total Constructed Capacity must be Input\"))","v":""}]
[null,null,{"$f":"IFERROR(IF(C15>'5. Section 53A Analysis'!C28,\"Error - Total Constructed Disposal Capacity Exceeds Total Disposal Capacity\",\"\"),\"\")","v":""}]
[{"$f":"A15+1","v":9},"Is the Landfill Facility compliant with Section 53A of the Waste Management Act, 1996 (as amended)? Yes or No","Yes"]
[{"$f":"A18+1","v":10},"If the answer is Yes but \"5. Section 53A Analysis\" suggests that the Landfill may not be compliant with Section 53A of the Waste Management Act, 1996 (as amended) please describe why you consider that the Landfill is compliant"]
[]
[]
[{"$f":"A19+1","v":11},"Please indicate if you wish the information supplied to be deemed confidential (Yes/No)","No"]
[{"$f":"A22+1","v":12},"Please clarify why you wish the information to be deemed confidential"]
[{"$f":"A23+1","v":13},"Name of Person Who Completed this Return","John Smith"]
[{"$f":"A24+1","v":14},"Position/Title of Person Who Completed this Return","Finance Director"]

{"sheet":"4. Financial Data - To Complete","index":4,"n_rows":147,"n_cols":32,"rows_kept":147,"cut":false,"hidden":false,"merged":[[6,3,6,4]]}
[]
[]
[]
["Financial Data to Complete - Supporting Statement of Compliance with Section 53A:"]
[]
[null,null,null,null,null,"COMPLETE DATA UP TO THE YEAR UNDER REVIEW"]
[null,null,null,"Pre- Section 53A",null,"Post Section 53A - Calendar Year or Financial Year Ended During"]
["Section",null,null,"Total Estimated Prior to Y/E in 2003/2004","Previous Y/E to 11 July 2004","12 July 2004 to next Y/E",2005,2006,2007,2008,2009,2010,2011,2012,2013,2014,2015,2016,2017,2018,2019,2020,2021,2022,2023,2024,2025,2026,2027,2028,2029,"2030 forward (cumulative)"]
[]
[null,null,null,{"$f":"IF('3. Landfill Data - to Complete'!$C$11>0,'3. Landfill Data - to Complete'!$C$11,\"\")","v":"Tonnes"},{"$f":"IF('3. Landfill Data - to Complete'!$C$11>0,'3. Landfill Data - to Complete'!$C$11,\"\")","v":"Tonnes"},{"$f":"IF('3. Landfill Data - to Complete'!$C$11>0,'3. Landfill Data - to Complete'!$C$11,\"\")","v":"Tonnes"},{"$f":"IF('3. Landfill Data - to Complete'!$C$11>0,'3. Landfill Data - to Complete'!$C$11,\"\")","v":"Tonnes"},{"$f":"IF('3. Landfill Data - to Complete'!$C$11>0,'3. Landfill Data - to Complete'!$C$11,\"\")","v":"Tonnes"},{"$f":"IF('3. Landfill Data - to Complete'!$C$11>0,'3. Landfill Data - to Complete'!$C$11,\"\")","v":"Tonnes"},{"$f":"IF('3. Landfill Data - to Complete'!$C$11>0,'3. Landfill Data - to Complete'!$C$11,\"\")","v":"Tonnes"},{"$f":"IF('3. Landfill Data - to Complete'!$C$11>0,'3. Landfill Data - to Complete'!$C$11,\"\")","v":"Tonnes"},{"$f":"IF('3. Landfill Data - to Complete'!$C$11>0,'3. Landfill Data - to Complete'!$C$11,\"\")","v":"Tonnes"},{"$f":"IF('3. Landfill Data - to Complete'!$C$11>0,'3. Landfill Data - to Complete'!$C$11,\"\")","v":"Tonnes"},{"$f":"IF('3. Landfill Data - to Complete'!$C$11>0,'3. Landfill Data - to Complete'!$C$11,\"\")","v":"Tonnes"},{"$f":"IF('3. Landfill Data - to Complete'!$C$11>0,'3. Landfill Data - to Complete'!$C$11,\"\")","v":"Tonnes"},{"$f":"IF('3. Landfill Data - to Complete'!$C$11>0,'3. Landfill Data - to Complete'!$C$11,\"\")","v":"Tonnes"},{"$f":"IF('3. Landfill Data - to Complete'!$C$11>0,'3. Landfill Data - to Complete'!$C$11,\"\")","v":"Tonnes"},{"$f":"IF('3. Landfill Data - to Complete'!$C$11>0,'3. Landfill Data - to Complete'!$C$11,\"\")","v":"Tonnes"},{"$f":"IF('3. Landfill Data - to Complete'!$C$11>0,'3. Landfill Data - to Complete'!$C$11,\"\")","v":"Tonnes"},{"$f":"IF('3. Landfill Data - to Complete'!$C$11>0,'3. Landfill Data - to Complete'!$C$11,\"\")","v":"Tonnes"},{"$f":"IF('3. Landfill Data - to Complete'!$C$11>0,'3. Landfill Data - to Complete'!$C$11,\"\")","v":"Tonnes"},{"$f":"IF('3. Landfill Data - to Complete'!$C$11>0,'3. Landfill Data - to Complete'!$C$11,\"\")","v":"Tonnes"},{"$f":"IF('3. Landfill Data - to Complete'!$C$11>0,'3. Landfill Data - to Complete'!$C$11,\"\")","v":"Tonnes"},{"$f":"IF('3. Landfill Data - to Complete'!$C$11>0,'3. Landfill Data - to Complete'!$C$11,\"\")","v":"Tonnes"},{"$f":"IF('3. Landfill Data - to Complete'!$C$11>0,'3. Landfill Data - to Complete'!$C$11,\"\")","v":"Tonnes"},{"$f":"IF('3. Landfill Data - to Complete'!$C$11>0,'3. Landfill Data - to Complete'!$C$11,\"\")","v":"Tonnes"},{"$f":"IF('3. Landfill Data - to Complete'!$C$11>0,'3. Landfill Data - to Complete'!$C$11,\"\")","v":"Tonnes"},{"$f":"IF('3. Landfill Data - to Complete'!$C$11>0,'3. Landfill Data - to Complete'!$C$11,\"\")","v":"Tonnes"},{"$f":"IF('3. Landfill Data - to Complete'!$C$11>0,'3. Landfill Data - to Complete'!$C$11,\"\")","v":"Tonnes"},{"$f":"IF('3. Landfill Data - to Complete'!$C$11>0,'3. Landfill Data - to Complete'!$C$11,\"\")","v":"Tonnes"},{"$f":"IF('3. Landfill Data - to Complete'!$C$11>0,'3. Landfill Data - to Complete'!$C$11,\"\")","v":"Tonnes"},{"$f":"IF('3. Landfill Data - to Complete'!$C$11>0,'3. Landfill Data - to Complete'!$C$11,\"\")","v":"Tonnes"}]
["A","Tonnage/M3 Data"]
[]
[null,"Waste Accepted for Disposal",null,250000,24000,23000,48000,49000,50000,47500,47000,45000,44000]
[null,"Waste Accepted for Cover",null,4500,500,500,1000,1000,1000,800,800,700,700]
[null,"Other - Please specify Nature here: "]
[null,"Total in Tonnes/M3",null,{"$f":"SUM(D13:D15)","v":254500},{"$f":"SUM(E13:E15)","v":24500},23500,49000,50000,51000,48300,47800,45700,44700,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,{"$f":"IF(D16=0,\"No Tonnage\",\"\")","v":""},{"$f":"IF(E16=0,\"No Tonnage\",\"\")","v":""},"","","","","","","","","No Tonnage","No Tonnage","No Tonnage","No Tonnage","No Tonnage","No Tonnage","No Tonnage","No Tonnage","No Tonnage","No Tonnage","No Tonnage","No Tonnage","No Tonnage","No Tonnage","No Tonnage","No Tonnage","No Tonnage","No Tonnage","No Tonnage"]
[]
[null,"Waste Accepted for Disposal - Split as Follows (if available):"]
[null,"Received from 3rd Parties",null,null,{"$f":"E13*0.75","v":18000},{"$f":"F13*0.75","v":17250},36000,36750,37500,35625,35250,33750,33000]
[null,"Received from Related Parties (i.e. from within same group of companies or County Council)",null,null,{"$f":"E13*0.25","v":6000},{"$f":"F13*0.25","v":5750},12000,12250,12500,11875,11750,11250,11000]
[null,"Total Waste Accepted for Disposal in Tonnes/M3",null,null,{"$f":"E13","v":24000},{"$f":"F13","v":23000},48000,49000,50000,47500,47000,45000,44000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,{"$f":"IF(AND(OR(E21<>\"\",E22<>\"\"),E23<>SUM(E21:E22)),\"Split must equal total\",\"\")","v":""},{"$f":"IF(AND(OR(F21<>\"\",F22<>\"\"),F23<>SUM(F21:F22)),\"Split must equal total\",\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
[null,null,null,null,"€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000"]
[]
["B","Revenue Data - EXCLUDING VAT"]
[]
[null,"Revenue from Waste Accepted for Disposal ex Levy",null,null,2640000,2530000,5720000,5390000,5000000,4512500,3760000,2475000,2420000]
[null,"Revenue from Waste Accepted for Cover"]
[null,"Landfill Levy Collected",null,null,360000,345000,720000,735000,750000,831250,940000,1125000,1800000]
[null,"Revenue from Gas Utilisation"]
[null,"Other - Please specify Nature here: [                                                                                                               ]"]
[null,"Total Revenue excluding VAT",null,null,{"$f":"SUM(E31:E35)","v":3000000},{"$f":"SUM(F31:F35)","v":2875000},6440000,6125000,5750000,5343750,4700000,3600000,4220000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Total Revenue excluding VAT - Split as Follows (if available):"]
[null,"Received from 3rd Parties",null,null,{"$f":"E36*0.75","v":2250000},{"$f":"F36*0.75","v":2156250},4830000,4593750,4312500,4007812.5,3525000,2700000,3165000]
[null,"Received from Related Parties (i.e. from within same group of companies or County Council)",null,null,{"$f":"E36*0.25","v":750000},{"$f":"F36*0.25","v":718750},1610000,1531250,1437500,1335937.5,1175000,900000,1055000]
[null,"Total Revenue excluding VAT",null,null,{"$f":"SUM(E39:E40)","v":3000000},{"$f":"SUM(F39:F40)","v":2875000},6440000,6125000,5750000,5343750,4700000,3600000,4220000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,{"$f":"IF(D41>D36,\"Error\",\"\")","v":""},{"$f":"IF(AND(OR(E39<>\"\",E40<>\"\"),E41<>E36),\"Row 41 must equal Row 36\",\"\")","v":""},{"$f":"IF(AND(OR(F39<>\"\",F40<>\"\"),F41<>F36),\"Row 41 must equal Row 36\",\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
["C","Operating Cost Data - EXCLUDING VAT"]
[null,"Fill in as positive number unless amount is a Credit"]
[null,"Landfill Site Operating Costs",null,null,485000,475000,975000,1000000,970000,930000,900000,840000,800000]
[null,"Administration Costs",null,null,85000,80000,170000,180000,160000,155000,150000,140000,125000]
[null,"Landfill Levy Payment",null,null,360000,345000,720000,735000,750000,831250,940000,1125000,1800000]
[null,"CRAMP Costs Provided For in the Profit and Loss Account/Income Statement but not actually paid",null,null,100000,100000,200000,200000,200000,200000,200000,200000,200000]
[null,"Leachate Costs Provided for in the Profit and Loss Account/Income Statement but not actually paid",null,null,25000,25000,50000,55000,55000,60000,60000,65000,65000]
[null,"Other Remediation Costs Provided for in the Profit and Loss Account/Income Statement but not actually paid"]
[null,"Depreciation of Fixed Assets - THIS MUST BE COMPLETED IF YOU HAVE A DEPRECIATION CHARGE",null,null,30000,25000,60000,65000,65000,70000,70000,75000,75000]
[null,"Allocated Costs - allocated from central body"]
[null,"Community Levy",null,null,12000,11500,24000,24500,25000,23750,23500,22500,22000]
[null,"All Other Costs (not listed separately above)"]
[null,"Total Operating costs excluding VAT",null,null,{"$f":"SUM(E47:E56)","v":1097000},{"$f":"SUM(F47:F56)","v":1061500},2199000,2259500,2225000,2270000,2343500,2467500,3087000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Operating Profit",null,null,{"$f":"E36-E57","v":1903000},1813500,4241000,3865500,3525000,3073750,2356500,1132500,1133000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Do Revenues Exceed Operating Costs?",null,null,{"$f":"IF(E59>-0.01,\"Yes\",\"No\")","v":"Yes"},"Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes","Yes"]
[null,"Does the Levy in Revenue Equal the Levy in Operating Costs?",null,null,{"$f":"IF(E33<>E49,\"Error on Levy\",\"\")","v":""},{"$f":"IF(F33<>F49,\"Error on Levy\",\"\")","v":""},"","","","","","","","","","","","","","","","","","","","","","","","","",""]
[]
["D","Adjusted Operating Profit Calculation:"]
[null,{"$f":"B59","v":"Operating Profit"},null,null,{"$f":"E59","v":1903000},1813500,4241000,3865500,3525000,3073750,2356500,1132500,1133000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Add Back Items Covered Separately below - CRAMP and Remediation Provisions, Acquisition and Development Costs:"]
[]
[null,{"$f":"B50","v":"CRAMP Costs Provided For in the Profit and Loss Account/Income Statement but not actually paid"},null,null,{"$f":"E50","v":100000},100000,200000,200000,200000,200000,200000,200000,200000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"B51","v":"Leachate Costs Provided for in the Profit and Loss Account/Income Statement but not actually paid"},null,null,{"$f":"E51","v":25000},25000,50000,55000,55000,60000,60000,65000,65000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"B52","v":"Other Remediation Costs Provided for in the Profit and Loss Account/Income Statement but not actually paid"},null,null,{"$f":"E52","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,{"$f":"B53","v":"Depreciation of Fixed Assets - THIS MUST BE COMPLETED IF YOU HAVE A DEPRECIATION CHARGE"},null,null,{"$f":"E53","v":30000},25000,60000,65000,65000,70000,70000,75000,75000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"Capping Costs Actual Paid and included in Operating Costs above for waste collected pre 12 July 2004"]
[null,"Leachate Costs Actual Paid and included in Operating Costs above for waste collected pre 12 July 2004"]
[null,"Other Items that you feel are appropriate to add-back/deduct - please provide a brief explanation below"]
[null,"Description of Item:"]
[]
[]
[]
[]
[]
[null,"Total Addbacks",null,null,{"$f":"SUM(E68:E74)","v":155000},{"$f":"SUM(F68:F74)","v":150000},310000,320000,320000,330000,330000,340000,340000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"Adjusted Operating Profit",null,null,{"$f":"E64+E81","v":2058000},1963500,4551000,4185500,3845000,3403750,2686500,1472500,1473000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,"€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000","€'000"]
["E1","Shared Infrastructure Acquisition and Development Costs - INCURRED TO DATE:"]
[]
[null,"Cost of Land",5500000]
[null,"Cost of Roads and Infrastructure",4300000]
[null,"Cost of Site Facilities e.g. Buildings, gas flares, etc",2700000]
[null,"Cost of Plant, Machinery and Vehicles",950000]
[null,"Cost of All Other Capital Items not covered above"]
[null,"Total Shared Infrastructure Acquisition and Development Costs - INCURRED TO DATE",{"$f":"SUM(C88:C92)","v":13450000}]
[null,"% Allocation to Post Introduction of Section 53A (Tonnage/M3 for Year divided by Total Disposal Capacity)",null,null,null,{"$f":"IFERROR(F$13/'5. Section 53A Analysis'!$C$28,\"\")","v":2.5555555555555557E-2},{"$f":"IFERROR(G$13/'5. Section 53A Analysis'!$C$28,\"\")","v":5.3333333333333337E-2},{"$f":"IFERROR(H$13/'5. Section 53A Analysis'!$C$28,\"\")","v":5.4444444444444441E-2},{"$f":"IFERROR(I$13/'5. Section 53A Analysis'!$C$28,\"\")","v":5.5555555555555552E-2},{"$f":"IFERROR(J$13/'5. Section 53A Analysis'!$C$28,\"\")","v":5.2777777777777778E-2},{"$f":"IFERROR(K$13/'5. Section 53A Analysis'!$C$28,\"\")","v":5.2222222222222225E-2},{"$f":"IFERROR(L$13/'5. Section 53A Analysis'!$C$28,\"\")","v":0.05},{"$f":"IFERROR(M$13/'5. Section 53A Analysis'!$C$28,\"\")","v":4.8888888888888891E-2},{"$f":"IFERROR(N$13/'5. Section 53A Analysis'!$C$28,\"\")","v":0},{"$f":"IFERROR(O$13/'5. Section 53A Analysis'!$C$28,\"\")","v":0},{"$f":"IFERROR(P$13/'5. Section 53A Analysis'!$C$28,\"\")","v":0},{"$f":"IFERROR(Q$13/'5. Section 53A Analysis'!$C$28,\"\")","v":0},{"$f":"IFERROR(R$13/'5. Section 53A Analysis'!$C$28,\"\")","v":0},{"$f":"IFERROR(S$13/'5. Section 53A Analysis'!$C$28,\"\")","v":0},{"$f":"IFERROR(T$13/'5. Section 53A Analysis'!$C$28,\"\")","v":0},{"$f":"IFERROR(U$13/'5. Section 53A Analysis'!$C$28,\"\")","v":0},{"$f":"IFERROR(V$13/'5. Section 53A Analysis'!$C$28,\"\")","v":0},{"$f":"IFERROR(W$13/'5. Section 53A Analysis'!$C$28,\"\")","v":0},{"$f":"IFERROR(X$13/'5. Section 53A Analysis'!$C$28,\"\")","v":0},{"$f":"IFERROR(Y$13/'5. Section 53A Analysis'!$C$28,\"\")","v":0},{"$f":"IFERROR(Z$13/'5. Section 53A Analysis'!$C$28,\"\")","v":0},{"$f":"IFERROR(AA$13/'5. Section 53A Analysis'!$C$28,\"\")","v":0},{"$f":"IFERROR(AB$13/'5. Section 53A Analysis'!$C$28,\"\")","v":0},{"$f":"IFERROR(AC$13/'5. Section 53A Analysis'!$C$28,\"\")","v":0},{"$f":"IFERROR(AD$13/'5. Section 53A Analysis'!$C$28,\"\")","v":0},{"$f":"IFERROR(AE$13/'5. Section 53A Analysis'!$C$28,\"\")","v":0},{"$f":"IFERROR(AF$13/'5. Section 53A Analysis'!$C$28,\"\")","v":0}]
[null,"Total Shared Infrasructure Acquisition and Development Costs - INCURRED TO DATE - Allocated Year by Year",null,null,null,{"$f":"IFERROR($C$93*F94,\"\")","v":343722.22222222225},{"$f":"IFERROR($C$93*G94,\"\")","v":717333.33333333337},{"$f":"IFERROR($C$93*H94,\"\")","v":732277.77777777775},747222.22222222213,709861.11111111112,702388.88888888888,672500,657555.55555555562,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
["E2","Cell Development Costs - INCURRED TO DATE:"]
[]
[null,"Costs of Cell Construction",6000000]
[null,"Other Cell Related Costs",500000]
[null,"Total Cell Development Costs - INCURRED TO DATE",{"$f":"SUM(C100:C101)","v":6500000}]
[null,"% Allocation to Post Introduction of Section 53A (Tonnage/M3 for Year divided by Total Constructed Disposal Capacity)",null,null,null,{"$f":"IFERROR(F$13/'5. Section 53A Analysis'!$C$41,\"\")","v":2.8750000000000001E-2},{"$f":"IFERROR(G$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0.06},{"$f":"IFERROR(H$13/'5. Section 53A Analysis'!$C$41,\"\")","v":6.1249999999999999E-2},{"$f":"IFERROR(I$13/'5. Section 53A Analysis'!$C$41,\"\")","v":6.25E-2},{"$f":"IFERROR(J$13/'5. Section 53A Analysis'!$C$41,\"\")","v":5.9374999999999997E-2},{"$f":"IFERROR(K$13/'5. Section 53A Analysis'!$C$41,\"\")","v":5.8749999999999997E-2},{"$f":"IFERROR(L$13/'5. Section 53A Analysis'!$C$41,\"\")","v":5.6250000000000001E-2},{"$f":"IFERROR(M$13/'5. Section 53A Analysis'!$C$41,\"\")","v":5.5E-2},{"$f":"IFERROR(N$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(O$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(P$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(Q$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(R$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(S$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(T$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(U$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(V$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(W$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(X$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(Y$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(Z$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(AA$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(AB$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(AC$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(AD$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(AE$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(AF$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0}]
[null,"Total Cell Development Costs - INCURRED TO DATE - Allocated Year by Year",null,null,null,{"$f":"IFERROR($C$102*F103,\"\")","v":186875},{"$f":"IFERROR($C$102*G103,\"\")","v":390000},{"$f":"IFERROR($C$102*H103,\"\")","v":398125},406250,385937.5,381875,365625,357500,0,{"$f":"IFERROR($C$102*O103,\"\")","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
["E3","Capping Costs for Constructed Cells Only - INCURRED AND TO BE INCURRED AT A LATER DATE:"]
[]
[null,"Cost of Capping incurred",3500000]
[null,"Cost of Capping to be incurred",1500000]
[null,"Total Capping Costs for Constructed Cells Only - INCURRED AND TO BE INCURRED AT A LATER DATE",{"$f":"SUM(C109:C110)","v":5000000}]
[null,"% Allocation to Post Introduction of Section 53A (Tonnage/M3 for Year divided by Total Constructed Disposal Capacity)",null,null,null,{"$f":"IFERROR(F$13/'5. Section 53A Analysis'!$C$41,\"\")","v":2.8750000000000001E-2},{"$f":"IFERROR(G$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0.06},{"$f":"IFERROR(H$13/'5. Section 53A Analysis'!$C$41,\"\")","v":6.1249999999999999E-2},{"$f":"IFERROR(I$13/'5. Section 53A Analysis'!$C$41,\"\")","v":6.25E-2},{"$f":"IFERROR(J$13/'5. Section 53A Analysis'!$C$41,\"\")","v":5.9374999999999997E-2},{"$f":"IFERROR(K$13/'5. Section 53A Analysis'!$C$41,\"\")","v":5.8749999999999997E-2},{"$f":"IFERROR(L$13/'5. Section 53A Analysis'!$C$41,\"\")","v":5.6250000000000001E-2},{"$f":"IFERROR(M$13/'5. Section 53A Analysis'!$C$41,\"\")","v":5.5E-2},{"$f":"IFERROR(N$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(O$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(P$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(Q$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(R$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(S$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(T$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(U$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(V$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(W$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(X$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(Y$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(Z$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(AA$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(AB$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(AC$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(AD$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(AE$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(AF$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0}]
[null,"Total Capping Costs for Constructed Cells Only - INCURRED AND TO BE INCURRED AT A LATER DATE - Allocated Year by Year",null,null,null,{"$f":"IFERROR($C$111*F112,\"\")","v":143750},{"$f":"IFERROR($C$111*G112,\"\")","v":300000},306250,312500,296875,293750,281250,275000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
["E4","Leachate Costs for Constructed Cells Only to Landfill Closure Date - INCURRED AND TO BE INCURRED AT A LATER DATE:"]
[]
[null,"Cost of Leachate Collection, Transport and Disposal incurred",4250000]
[null,"Cost of Leachate Collection, Transport and Disposal to be incurred until the Landfill Closure Date",1450000]
[null,"Total Leachate Costs for Constructed Cells Only - INCURRED AND TO BE INCURRED AT A LATER DATE",{"$f":"SUM(C118:C119)","v":5700000}]
[null,"% Allocation to Post Introduction of Section 53A (Tonnage/M3 for Year divided by Total Constructed Disposal Capacity)",null,null,null,{"$f":"IFERROR(F$13/'5. Section 53A Analysis'!$C$41,\"\")","v":2.8750000000000001E-2},{"$f":"IFERROR(G$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0.06},{"$f":"IFERROR(H$13/'5. Section 53A Analysis'!$C$41,\"\")","v":6.1249999999999999E-2},{"$f":"IFERROR(I$13/'5. Section 53A Analysis'!$C$41,\"\")","v":6.25E-2},{"$f":"IFERROR(J$13/'5. Section 53A Analysis'!$C$41,\"\")","v":5.9374999999999997E-2},{"$f":"IFERROR(K$13/'5. Section 53A Analysis'!$C$41,\"\")","v":5.8749999999999997E-2},{"$f":"IFERROR(L$13/'5. Section 53A Analysis'!$C$41,\"\")","v":5.6250000000000001E-2},{"$f":"IFERROR(M$13/'5. Section 53A Analysis'!$C$41,\"\")","v":5.5E-2},{"$f":"IFERROR(N$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(O$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(P$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(Q$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(R$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(S$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(T$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(U$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(V$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(W$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(X$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(Y$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(Z$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(AA$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(AB$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(AC$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(AD$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(AE$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0},{"$f":"IFERROR(AF$13/'5. Section 53A Analysis'!$C$41,\"\")","v":0}]
[null,"Total Leachate Costs for Constructed Cells Only - INCURRED AND TO BE INCURRED AT A LATER DATE - Allocated Year by Year",null,null,null,{"$f":"IFERROR($C$120*F121,\"\")","v":163875},{"$f":"IFERROR($C$120*G121,\"\")","v":342000},349125,356250,338437.5,334875,320625,313500,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
["E5","Restoration and Aftercare Costs Post Site Closure - TO BE INCURRED AT A LATER DATE"]
[]
[null,"Cost of Leachate Collection, Transport and Disposal - post site closure",2050000]
[null,"Cost of Monitoring",800000]
[null,"Cost of Security",600000]
[null,"Cost of Aftercare",800000]
[null,"Cost of All Other Items not covered above",800000]
[null,"Net Income (if any)  e.g. Utilisation of gas to produce electricity - include full costs of generating such income.  Enter Profit as Minus"]
[null,"Description of Item: Such Income must have a sound basis for inclusion"]
[]
[]
[]
[]
[]
[null,"Total Restoration and Aftercare Costs Post Site Closure - TO BE INCURRED AT A LATER DATE",{"$f":"SUM(C127:C132)","v":5050000}]
[null,"% Allocation to Post Introduction of Section 53A (Tonnage/M3 for Year divided by Total Disposal Capacity)",null,null,null,{"$f":"IFERROR(F$13/'5. Section 53A Analysis'!$C$28,\"\")","v":2.5555555555555557E-2},{"$f":"IFERROR(G$13/'5. Section 53A Analysis'!$C$28,\"\")","v":5.3333333333333337E-2},{"$f":"IFERROR(H$13/'5. Section 53A Analysis'!$C$28,\"\")","v":5.4444444444444441E-2},{"$f":"IFERROR(I$13/'5. Section 53A Analysis'!$C$28,\"\")","v":5.5555555555555552E-2},{"$f":"IFERROR(J$13/'5. Section 53A Analysis'!$C$28,\"\")","v":5.2777777777777778E-2},{"$f":"IFERROR(K$13/'5. Section 53A Analysis'!$C$28,\"\")","v":5.2222222222222225E-2},{"$f":"IFERROR(L$13/'5. Section 53A Analysis'!$C$28,\"\")","v":0.05},{"$f":"IFERROR(M$13/'5. Section 53A Analysis'!$C$28,\"\")","v":4.8888888888888891E-2},{"$f":"IFERROR(N$13/'5. Section 53A Analysis'!$C$28,\"\")","v":0},{"$f":"IFERROR(O$13/'5. Section 53A Analysis'!$C$28,\"\")","v":0},{"$f":"IFERROR(P$13/'5. Section 53A Analysis'!$C$28,\"\")","v":0},{"$f":"IFERROR(Q$13/'5. Section 53A Analysis'!$C$28,\"\")","v":0},{"$f":"IFERROR(R$13/'5. Section 53A Analysis'!$C$28,\"\")","v":0},{"$f":"IFERROR(S$13/'5. Section 53A Analysis'!$C$28,\"\")","v":0},{"$f":"IFERROR(T$13/'5. Section 53A Analysis'!$C$28,\"\")","v":0},{"$f":"IFERROR(U$13/'5. Section 53A Analysis'!$C$28,\"\")","v":0},{"$f":"IFERROR(V$13/'5. Section 53A Analysis'!$C$28,\"\")","v":0},{"$f":"IFERROR(W$13/'5. Section 53A Analysis'!$C$28,\"\")","v":0},{"$f":"IFERROR(X$13/'5. Section 53A Analysis'!$C$28,\"\")","v":0},{"$f":"IFERROR(Y$13/'5. Section 53A Analysis'!$C$28,\"\")","v":0},{"$f":"IFERROR(Z$13/'5. Section 53A Analysis'!$C$28,\"\")","v":0},{"$f":"IFERROR(AA$13/'5. Section 53A Analysis'!$C$28,\"\")","v":0},{"$f":"IFERROR(AB$13/'5. Section 53A Analysis'!$C$28,\"\")","v":0},{"$f":"IFERROR(AC$13/'5. Section 53A Analysis'!$C$28,\"\")","v":0},{"$f":"IFERROR(AD$13/'5. Section 53A Analysis'!$C$28,\"\")","v":0},{"$f":"IFERROR(AE$13/'5. Section 53A Analysis'!$C$28,\"\")","v":0},{"$f":"IFERROR(AF$13/'5. Section 53A Analysis'!$C$28,\"\")","v":0}]
[null,"Total Restoration and Aftercare Costs Post Site Closure - TO BE INCURRED AT A LATER DATE - Allocated Year by Year",null,null,null,{"$f":"IFERROR($C$139*F140,\"\")","v":129055.55555555556},{"$f":"IFERROR($C$139*G140,\"\")","v":269333.33333333337},274944.44444444444,280555.55555555556,266527.77777777775,263722.22222222225,252500,246888.88888888891,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[null,"CALCULATION OF SECTION 53A ANALYSIS YEAR BY YEAR (D - E1 - E2 - E3 - E4 - E5)",null,null,null,{"$f":"IFERROR(F83-F95-F104-F113-F122-F141,\"\")","v":996222.22222222225},{"$f":"IFERROR(G83-G95-G104-G113-G122-G141,\"\")","v":2532333.333333333},2124777.7777777775,1742222.2222222225,1406111.1111111112,709888.88888888876,-420000,-377444.4444444445,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[null,"ACCUMULATED CALCULATION OF SECTION 53A ANALYSIS (D - E1 - E2 - E3 - E4 - E5)",null,null,null,{"$f":"IFERROR(F145,\"\")","v":996222.22222222225},{"$f":"IFERROR(F147+G145,\"\")","v":3528555.555555555},{"$f":"IFERROR(G147+H145,\"\")","v":5653333.3333333321},7395555.5555555541,8801666.666666666,9511555.5555555541,9091555.5555555541,8714111.1111111101,8714111.1111111101,8714111.1111111101,8714111.1111111101,8714111.1111111101,8714111.1111111101,8714111.1111111101,8714111.1111111101,8714111.1111111101,8714111.1111111101,8714111.1111111101,8714111.1111111101,8714111.1111111101,8714111.1111111101,8714111.1111111101,8714111.1111111101,8714111.1111111101,8714111.1111111101,8714111.1111111101,8714111.1111111101]

{"sheet":"5. Section 53A Analysis","index":5,"n_rows":49,"n_cols":4,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Summary Analysis of Section 53A Data:"]
[]
[]
[]
["Section","Description","€'000","% of Total Cost"]
[]
["D","Adjusted Operating Profit to Date since introduction of Section 53A",{"$f":"SUM('4. Financial Data - To Complete'!F83:AF83)","v":23580750}]
[]
["E1","Allocation of: Shared Infrastructure Acquisition and Development Costs - Incurred to Date",{"$f":"-SUM('4. Financial Data - To Complete'!F95:AF95)","v":-5282861.1111111119},{"$f":"IFERROR(-C12/'4. Financial Data - To Complete'!C93,\"\")","v":0.39277777777777784}]
[]
["E2","Allocation of: Cell Development Costs - Incurred to Date",{"$f":"-SUM('4. Financial Data - To Complete'!F104:AF104)","v":-2872187.5},{"$f":"IFERROR(-C14/'4. Financial Data - To Complete'!C102,\"\")","v":0.44187500000000002}]
[]
["E3","Allocation of: Capping Costs for Constructed Cells Only - Incurred and to be Incurred at a Later Date",{"$f":"-SUM('4. Financial Data - To Complete'!F113:AF113)","v":-2209375},{"$f":"IFERROR(-C16/'4. Financial Data - To Complete'!C111,\"\")","v":0.44187500000000002}]
[]
["E4","Allocation of: Leachate Costs for Constructed Cells Only - Incurred and to be Incurred at a Later Date",{"$f":"-SUM('4. Financial Data - To Complete'!F122:AF122)","v":-2518687.5},{"$f":"IFERROR(-C18/'4. Financial Data - To Complete'!C120,\"\")","v":0.44187500000000002}]
[]
["E5","Allocation of: Restoration and Aftercare Costs Post Site Closure - To be Incurred at a Later Date",{"$f":"-SUM('4. Financial Data - To Complete'!F141:AF141)","v":-1983527.777777778},{"$f":"IFERROR(-C20/'4. Financial Data - To Complete'!C139,\"\")","v":0.39277777777777784}]
[]
[null,"ACCUMULATED SURPLUS POST INTRODUCTION OF SECTION 53A (D + E1 + E2 + E3 + E4 + E5)",{"$f":"C10+C12+C14+C16+C18+C20","v":8714111.1111111101}]
[]
[]
[]
[null,"Summary of Total Disposal Capacity of Landfill Facility:",{"$f":"IF('3. Landfill Data - to Complete'!$C$11>0,'3. Landfill Data - to Complete'!$C$11,\"\")","v":"Tonnes"}]
[]
[null,"Total Disposal Capacity of Landfill Facility",{"$f":"IFERROR(SMALL('3. Landfill Data - to Complete'!C12:C14,COUNTIF('3. Landfill Data - to Complete'!C12:C14,0)+1),\"\")","v":900000},1]
[]
[null,"Less: Capacity used prior to Introduction of Section 53A",{"$f":"-SUM('4. Financial Data - To Complete'!D13:E13)","v":-274000},{"$f":"IFERROR(-C30/$C$28,\"\")","v":0.30444444444444446}]
[]
[null,"Capacity to be used following Introduction of Section 53A",{"$f":"SUM(C28:C30)","v":626000},{"$f":"IFERROR(C32/$C$28,\"\")","v":0.69555555555555559}]
[]
[null,"Less: Capacity Used to date following Introduction of Section 53A",{"$f":"-SUM('4. Financial Data - To Complete'!F13:AF13)","v":-353500},{"$f":"IFERROR(-C34/$C$28,\"\")","v":0.39277777777777778}]
[]
[null,"Current remaining Overall Landfill Capacity pertaining to Section 53A Period",{"$f":"SUM(C32:C34)","v":272500},{"$f":"IFERROR(C36/$C$28,\"\")","v":0.30277777777777776}]
[]
[]
[null,"Summary of Total Constructed Disposal Capacity of Landfill Facility:",{"$f":"IF('3. Landfill Data - to Complete'!$C$11>0,'3. Landfill Data - to Complete'!$C$11,\"\")","v":"Tonnes"}]
[]
[null,"Total Capacity of Cells Constructed to Date",{"$f":"'3. Landfill Data - to Complete'!C15","v":800000},1]
[]
[null,"Less: Capacity used prior to Introduction of Section 53A",{"$f":"C30","v":-274000},{"$f":"IFERROR(-C43/$C$41,\"\")","v":0.34250000000000003}]
[]
[null,"Capacity to be used following Introduction of Section 53A",{"$f":"SUM(C41:C43)","v":526000},{"$f":"IFERROR(C45/$C$41,\"\")","v":0.65749999999999997}]
[]
[null,"Less: Capacity Used to date following Introduction of Section 53A",{"$f":"C34","v":-353500},{"$f":"IFERROR(-C47/$C$41,\"\")","v":0.44187500000000002}]
[]
[null,"Current remaining Cell Capacity pertaining to Section 53A Period",{"$f":"SUM(C45:C48)","v":172500},{"$f":"IFERROR(C49/$C$41,\"\")","v":0.21562500000000001}]

{"sheet":"6. Comments - To Complete","index":6,"n_rows":33,"n_cols":4,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Notes to Completion of Detailed Analysis Supporting Compliance with Section 53A:"]
[]
[]
["Number","Worksheet ref","Matter of Note","Your Comment/Query"]
[]
[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]

{"sheet":"7. Data Sheet","index":7,"n_rows":44,"n_cols":4,"rows_kept":44,"cut":false,"hidden":true,"merged":[]}
["DO NOT ATTEMPT TO AMEND THIS DATA"]
[]
[]
["Units","Years","Compliance","Worksheet comments"]
["Tonnes",2011,"Yes",1]
["M3",2012,"No",2]
[null,2013,null,3]
[null,2014,null,4]
[null,2015,null,5]
[null,2016,null,"Other"]
[null,2017]
[null,2018]
[null,2019]
[null,2020]
[null,2021]
[null,2022]
[null,2023]
[null,2024]
[null,2025]
[null,2026]
[null,2027]
[null,2028]
[null,2029]
[null,2030]
[null,2031]
[null,2032]
[null,2033]
[null,2034]
[null,2035]
[null,2036]
[null,2037]
[null,2038]
[null,2039]
[null,2040]
[null,2041]
[null,2042]
[null,2043]
[null,2044]
[null,2045]
[null,2046]
[null,2047]
[null,2048]
[null,2049]
[null,2050]