{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Introduction","General input data","1 Value chain emissions","2 Prevented emissions - totals","2b Prevented emissions -details","3 Forest","4 Wood-based products","Summary of Assessment","Blad1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":0,"comments":8,"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":"Introduction","index":0,"n_rows":52,"n_cols":2,"rows_kept":52,"cut":false,"hidden":false,"merged":[[50,0,50,1]]}
["Carbon dynamics of wood and wood-based products - assessment at the corporate level "]
["version 2024-11-25"]
[]
["Background"]
["This template shows the calculations for reporting corporate impact of wood-based products on the global climate according to the CLEAR model."]
["Purpose: To assess the climate effect of the wood and wood-based products put on the market by a corporation during a defined period of time (normally one year or a sequence of years)"]
[]
["For an overview of the CLEAR model, see report by Holmgren & Strömgren 2024:"]
["1187-2024-manual-for-reporting-corporate-impact-of-wood-based-products-on-the-global-climate.pdf (skogforsk.se)"]
[]
["Components in the CLEAR model"]
["1 Value chain emissions for wood-based products"]
["2 Prevented emissions from counterfactual products"]
["    3 Change of carbon stored in forest"]
["    4 Change of carbon stored in wood-based products"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Methodology Steps","See worksheet:"]
["1. Define the time period(s) for the assessment","General Input Data"]
["2. Define the set of product categories/uses that are included in the assessment, provide production data and conversions to CO2e for each","General Input Data"]
["3. Work through each of the four components to assess climate effect of each "," 1, 2b, 3 and 4"]
["4. The summary assessment is provided ","Summary of Assessment"]
[]
["General instruction on data input:"]
["Cells are color-coded to identify the cells where data are entered, as follows:"]
["Cells where data are entered manually"]
["Cells where data is copied/calculated based on  other cells - NO manual input to be made in these cells"]
["Cells where constants / conversion factors are provided "]
["Cells with no data"]
[]
[]
["Version information"]
["2024-11-25","Published version"]

{"sheet":"General input data","index":1,"n_rows":25,"n_cols":9,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,9],[3,1,3,4],[9,0,10,0],[9,2,9,4],[16,6,16,8],[9,1,10,1],[4,1,4,4],[10,6,10,9],[12,6,12,9],[13,6,13,9],[8,0,8,4]]}
["General input data"]
[]
[]
["Corporation name","Name of Corporation"]
["Notes on assessment process","Eg purpose and general info on data input / corporate setting"]
[]
["Time periods (years) and Marketed wood-based product categories by the corporation. Product categories are identified only in the first year/time period"]
[]
["Time period XXX"]
["Product category ","Product use","Marketed volumes",null,null,null,"Colour coding:"]
[null,null,"quantity","unit","tCO2e",null,"Cells where data are entered manually"]
["Product category 1",null,100,null,100,null,"Cells where data is copied/calculated based on  other cells - NO manual input to be made in these cells"]
["Product category 2",null,100,null,100,null,"Cells where with constants / conversion factors are provided "]
[null,null,null,null,null,null,"Cells with no data"]
[]
[null,null,null,null,null,null,"Factors"]
[null,null,null,null,null,null,"Conversion factors used, example"]
[null,null,null,null,null,null,"Solid wood products",0.91749999999999998,"tCO2e/m3"]
[null,null,null,null,null,null,"Massa",{"$f":"0.45*3.67","v":1.6515},"tCO2e/t"]
[null,null,null,null,null,null,"Uncoated paper",{"$f":"0.4*3.67","v":1.468},"tCO2e/t"]
[null,null,null,null,null,null,"Coated paper",{"$f":"0.3*3.67","v":1.101},"tCO2e/t"]
[null,null,null,null,null,null,"Liner",{"$f":"0.4*3.67","v":1.468},"tCO2e/t"]
[null,null,null,null,null,null,"Bioenergy, general conversion",0.45,"tCO2e/MWh"]
[null,null,null,null,null,null,"(Bio)diesel",2.64,"tCO2e/m3"]
[null,null,null,null,null,null,"Stem wood to total living biomass",1.375,"tCO2e/m3sk"]

{"sheet":"1 Value chain emissions","index":2,"n_rows":50,"n_cols":4,"rows_kept":50,"cut":false,"hidden":false,"merged":[[0,0,0,2],[13,0,13,1],[15,0,15,1],[22,0,23,0],[22,2,23,2],[8,0,8,1],[11,0,11,1],[12,0,12,1],[2,0,6,1],[7,0,7,1]]}
["Component 1: Value chain emissions for wood-based products"]
[null,null,null,"Colour coding:"]
["Value chain emissions refer to all fossil/process emissions required for the manufacturing and delivery of the considered wood-based products in the defined time period. In LCA language this corresponds to Cradle to Gate. In the current assessment, emissions from Gate to Grave may be included for comparing with alternative products. This is covered under the Displacement component.",null,null,"Cells where data are entered manually"]
[null,null,null,"Cells where data is copied/calculated based on  other cells - NO manual input to be made in these cells"]
[null,null,null,"Cells where constants / conversion factors are provided "]
[null,null,null,"Cells with no data"]
[]
[]
["The GHG Protocol is a suitable methodology for value chain emissions in a defined time period, such as a year. It is also a broadly adopted methodology used in many corporate annual reports. Data can therefore be readily available from other corporate reporting processes. The same structure using scopes  is applied:"]
["Scope 1 emissions for direct emissions by the corporation"]
["Scope 2 for indirect emissions from corporate energy use"]
["Scope 3 for indirect emissions upstream or downstream in the value chain"]
["Note that Scope 3 emissions for downstream use phase (Gate to Grave) are not included here, but covered (when applicable) in the Displcement component"]
["Note also that the upcoming GHG Protocol approach to include biogenic emissions is not included here, as this is covered by the Forest carbon balance and Product carbon storage components"]
[]
["Detailed methodologies for GHG Protocol application is available, see key references below:"]
["https://ghgprotocol.org/sites/default/files/standards/ghg-protocol-revised.pdf "]
["https://ghgprotocol.org/sites/default/files/standards/Corporate-Value-Chain-Accounting-Reporing-Standard_041613_2.pdf "]
["https://ghgprotocol.org/sites/default/files/standards/Scope3_Calculation_Guidance_0.pdf "]
[]
[]
[{"$f":"'General input data'!A9","v":"Time period XXX"}]
["Emission category (List can be made more detailed as required)","Emissions Cradle to Gate","Notes"]
[null,"tCO2e"]
["Scope 1",10]
["Scope 2",20]
["Scope 3",30]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Total",{"$f":"SUM(B25:B49)","v":60}]

{"sheet":"2 Prevented emissions - totals","index":3,"n_rows":42,"n_cols":12,"rows_kept":42,"cut":false,"hidden":false,"merged":[[11,17,11,19],[14,6,14,7],[14,1,16,1],[14,2,16,2],[15,3,16,3],[15,4,16,4],[14,3,14,5],[15,5,16,5],[14,8,14,9],[14,10,14,11],[8,1,8,4],[9,1,9,4],[10,1,10,4],[7,1,7,4],[10,17,10,19]]}
["Component 2: Prevented emissions from counterfactual products (Summary)"]
[]
["This sheet summarizes the details on sheet 2b Preventet emissions -details"]
["It is locked to avoid unwanted edits",null,"Den är inte låst nu!"]
[]
[]
[null,"Colour coding:"]
[null,"Cells where data are entered manually"]
[null,"Cells where data is copied/calculated based on  other cells - NO manual input to be made in these cells"]
[null,"Cells where constants / conversion factors are provided "]
[null,"Cells with no data"]
[]
[]
[null,{"$f":"'General input data'!A9","v":"Time period XXX"}]
[null,"Product category","Product use","Marketed volumes",null,null,"First use",null,"Final use (energy)",null,"Total Displacement"]
[null,null,null,"quantity","unit of measure","in tCO2e","Displacement Factor (from details sheet)","Prevented emissions","Displacement Factor (from details sheet)","Prevented emissions","Overall Displacement Factor","Total Prevented emissions"]
["cat",null,null,null,null,null,"tCO2e/tCO2e","tCO2e","tCO2e/tCO2e","tCO2e","tCO2e/tCO2e","tCO2e"]
[0,{"$f":"IF('General input data'!A12<>\"\",'General input data'!A12,\"\")","v":"Product category 1"},{"$f":"IF('General input data'!B12<>\"\",'General input data'!B12,\"\")","v":""},{"$f":"IF('General input data'!C12<>\"\",'General input data'!C12,\"\")","v":100},{"$f":"IF('General input data'!D12<>\"\",'General input data'!D12,\"\")","v":""},{"$f":"IF('General input data'!E12<>\"\",'General input data'!E12,\"\")","v":100},{"$f":"IF(F18<>0,OFFSET('2b Prevented emissions -details'!$I$69,A18*12,0),\"\")","v":-1},{"$f":"IF(F18<>\"\",OFFSET('2b Prevented emissions -details'!$K$69,A18*12,0),\"\")","v":-100},{"$f":"IF(D18<>\"\",OFFSET('2b Prevented emissions -details'!$N$69,12*A18,0),\"\")","v":-0.33},{"$f":"IF(F18<>\"\",OFFSET('2b Prevented emissions -details'!$P$69,A18*12,0),\"\")","v":-33},{"$f":"IF(F18<>\"\",OFFSET('2b Prevented emissions -details'!$S$69,A18*12,0),\"\")","v":-1.33},{"$f":"IF(F18<>\"\",OFFSET('2b Prevented emissions -details'!$R$69,A18*12,0),\"\")","v":-133}]
[1,{"$f":"IF('General input data'!A13<>\"\",'General input data'!A13,\"\")","v":"Product category 2"},{"$f":"IF('General input data'!B13<>\"\",'General input data'!B13,\"\")","v":""},{"$f":"IF('General input data'!C13<>\"\",'General input data'!C13,\"\")","v":100},{"$f":"IF('General input data'!D13<>\"\",'General input data'!D13,\"\")","v":""},{"$f":"IF('General input data'!E13<>\"\",'General input data'!E13,\"\")","v":100},{"$f":"IF(F19<>0,OFFSET('2b Prevented emissions -details'!$I$69,A19*12,0),\"\")","v":-0.7},{"$f":"IF(F19<>\"\",OFFSET('2b Prevented emissions -details'!$K$69,A19*12,0),\"\")","v":-70},{"$f":"IF(D19<>\"\",OFFSET('2b Prevented emissions -details'!$N$69,12*A19,0),\"\")","v":-6.9999999999999993E-2},{"$f":"IF(F19<>\"\",OFFSET('2b Prevented emissions -details'!$P$69,A19*12,0),\"\")","v":-6.9999999999999991},{"$f":"IF(F19<>\"\",OFFSET('2b Prevented emissions -details'!$S$69,A19*12,0),\"\")","v":-0.76999999999999991},{"$f":"IF(F19<>\"\",OFFSET('2b Prevented emissions -details'!$R$69,A19*12,0),\"\")","v":-77}]
[2,{"$f":"IF('General input data'!A14<>\"\",'General input data'!A14,\"\")","v":""},{"$f":"IF('General input data'!B14<>\"\",'General input data'!B14,\"\")","v":""},{"$f":"IF('General input data'!C14<>\"\",'General input data'!C14,\"\")","v":""},{"$f":"IF('General input data'!D14<>\"\",'General input data'!D14,\"\")","v":""},{"$f":"IF('General input data'!E14<>\"\",'General input data'!E14,\"\")","v":""},{"$f":"IF(F20<>0,OFFSET('2b Prevented emissions -details'!$I$69,A20*12,0),\"\")","v":""},{"$f":"IF(F20<>\"\",OFFSET('2b Prevented emissions -details'!$K$69,A20*12,0),\"\")","v":""},{"$f":"IF(D20<>\"\",OFFSET('2b Prevented emissions -details'!$N$69,12*A20,0),\"\")","v":""},{"$f":"IF(F20<>\"\",OFFSET('2b Prevented emissions -details'!$P$69,A20*12,0),\"\")","v":""},{"$f":"IF(F20<>\"\",OFFSET('2b Prevented emissions -details'!$S$69,A20*12,0),\"\")","v":""},{"$f":"IF(F20<>\"\",OFFSET('2b Prevented emissions -details'!$R$69,A20*12,0),\"\")","v":""}]
[3,{"$f":"IF('General input data'!A15<>\"\",'General input data'!A15,\"\")","v":""},{"$f":"IF('General input data'!B15<>\"\",'General input data'!B15,\"\")","v":""},{"$f":"IF('General input data'!C15<>\"\",'General input data'!C15,\"\")","v":""},{"$f":"IF('General input data'!D15<>\"\",'General input data'!D15,\"\")","v":""},{"$f":"IF('General input data'!E15<>\"\",'General input data'!E15,\"\")","v":""},{"$f":"IF(F21<>0,OFFSET('2b Prevented emissions -details'!$I$69,A21*12,0),\"\")","v":""},{"$f":"IF(F21<>\"\",OFFSET('2b Prevented emissions -details'!$K$69,A21*12,0),\"\")","v":""},{"$f":"IF(D21<>\"\",OFFSET('2b Prevented emissions -details'!$N$69,12*A21,0),\"\")","v":""},{"$f":"IF(F21<>\"\",OFFSET('2b Prevented emissions -details'!$P$69,A21*12,0),\"\")","v":""},{"$f":"IF(F21<>\"\",OFFSET('2b Prevented emissions -details'!$S$69,A21*12,0),\"\")","v":""},{"$f":"IF(F21<>\"\",OFFSET('2b Prevented emissions -details'!$R$69,A21*12,0),\"\")","v":""}]
[4,{"$f":"IF('General input data'!A16<>\"\",'General input data'!A16,\"\")","v":""},{"$f":"IF('General input data'!B16<>\"\",'General input data'!B16,\"\")","v":""},{"$f":"IF('General input data'!C16<>\"\",'General input data'!C16,\"\")","v":""},{"$f":"IF('General input data'!D16<>\"\",'General input data'!D16,\"\")","v":""},{"$f":"IF('General input data'!E16<>\"\",'General input data'!E16,\"\")","v":""},{"$f":"IF(F22<>0,OFFSET('2b Prevented emissions -details'!$I$69,A22*12,0),\"\")","v":""},{"$f":"IF(F22<>\"\",OFFSET('2b Prevented emissions -details'!$K$69,A22*12,0),\"\")","v":""},{"$f":"IF(D22<>\"\",OFFSET('2b Prevented emissions -details'!$N$69,12*A22,0),\"\")","v":""},{"$f":"IF(F22<>\"\",OFFSET('2b Prevented emissions -details'!$P$69,A22*12,0),\"\")","v":""},{"$f":"IF(F22<>\"\",OFFSET('2b Prevented emissions -details'!$S$69,A22*12,0),\"\")","v":""},{"$f":"IF(F22<>\"\",OFFSET('2b Prevented emissions -details'!$R$69,A22*12,0),\"\")","v":""}]
[5,{"$f":"IF('General input data'!A17<>\"\",'General input data'!A17,\"\")","v":""},{"$f":"IF('General input data'!B17<>\"\",'General input data'!B17,\"\")","v":""},{"$f":"IF('General input data'!C17<>\"\",'General input data'!C17,\"\")","v":""},{"$f":"IF('General input data'!D17<>\"\",'General input data'!D17,\"\")","v":""},{"$f":"IF('General input data'!E17<>\"\",'General input data'!E17,\"\")","v":""},{"$f":"IF(F23<>0,OFFSET('2b Prevented emissions -details'!$I$69,A23*12,0),\"\")","v":""},{"$f":"IF(F23<>\"\",OFFSET('2b Prevented emissions -details'!$K$69,A23*12,0),\"\")","v":""},{"$f":"IF(D23<>\"\",OFFSET('2b Prevented emissions -details'!$N$69,12*A23,0),\"\")","v":""},{"$f":"IF(F23<>\"\",OFFSET('2b Prevented emissions -details'!$P$69,A23*12,0),\"\")","v":""},{"$f":"IF(F23<>\"\",OFFSET('2b Prevented emissions -details'!$S$69,A23*12,0),\"\")","v":""},{"$f":"IF(F23<>\"\",OFFSET('2b Prevented emissions -details'!$R$69,A23*12,0),\"\")","v":""}]
[6,{"$f":"IF('General input data'!A18<>\"\",'General input data'!A18,\"\")","v":""},{"$f":"IF('General input data'!B18<>\"\",'General input data'!B18,\"\")","v":""},{"$f":"IF('General input data'!C18<>\"\",'General input data'!C18,\"\")","v":""},{"$f":"IF('General input data'!D18<>\"\",'General input data'!D18,\"\")","v":""},{"$f":"IF('General input data'!E18<>\"\",'General input data'!E18,\"\")","v":""},{"$f":"IF(F24<>0,OFFSET('2b Prevented emissions -details'!$I$69,A24*12,0),\"\")","v":""},{"$f":"IF(F24<>\"\",OFFSET('2b Prevented emissions -details'!$K$69,A24*12,0),\"\")","v":""},{"$f":"IF(D24<>\"\",OFFSET('2b Prevented emissions -details'!$N$69,12*A24,0),\"\")","v":""},{"$f":"IF(F24<>\"\",OFFSET('2b Prevented emissions -details'!$P$69,A24*12,0),\"\")","v":""},{"$f":"IF(F24<>\"\",OFFSET('2b Prevented emissions -details'!$S$69,A24*12,0),\"\")","v":""},{"$f":"IF(F24<>\"\",OFFSET('2b Prevented emissions -details'!$R$69,A24*12,0),\"\")","v":""}]
[7,{"$f":"IF('General input data'!A19<>\"\",'General input data'!A19,\"\")","v":""},{"$f":"IF('General input data'!B19<>\"\",'General input data'!B19,\"\")","v":""},{"$f":"IF('General input data'!C19<>\"\",'General input data'!C19,\"\")","v":""},{"$f":"IF('General input data'!D19<>\"\",'General input data'!D19,\"\")","v":""},{"$f":"IF('General input data'!E19<>\"\",'General input data'!E19,\"\")","v":""},{"$f":"IF(F25<>0,OFFSET('2b Prevented emissions -details'!$I$69,A25*12,0),\"\")","v":""},{"$f":"IF(F25<>\"\",OFFSET('2b Prevented emissions -details'!$K$69,A25*12,0),\"\")","v":""},{"$f":"IF(D25<>\"\",OFFSET('2b Prevented emissions -details'!$N$69,12*A25,0),\"\")","v":""},{"$f":"IF(F25<>\"\",OFFSET('2b Prevented emissions -details'!$P$69,A25*12,0),\"\")","v":""},{"$f":"IF(F25<>\"\",OFFSET('2b Prevented emissions -details'!$S$69,A25*12,0),\"\")","v":""},{"$f":"IF(F25<>\"\",OFFSET('2b Prevented emissions -details'!$R$69,A25*12,0),\"\")","v":""}]
[8,{"$f":"IF('General input data'!A20<>\"\",'General input data'!A20,\"\")","v":""},{"$f":"IF('General input data'!B20<>\"\",'General input data'!B20,\"\")","v":""},{"$f":"IF('General input data'!C20<>\"\",'General input data'!C20,\"\")","v":""},{"$f":"IF('General input data'!D20<>\"\",'General input data'!D20,\"\")","v":""},{"$f":"IF('General input data'!E20<>\"\",'General input data'!E20,\"\")","v":""},{"$f":"IF(F26<>0,OFFSET('2b Prevented emissions -details'!$I$69,A26*12,0),\"\")","v":""},{"$f":"IF(F26<>\"\",OFFSET('2b Prevented emissions -details'!$K$69,A26*12,0),\"\")","v":""},{"$f":"IF(D26<>\"\",OFFSET('2b Prevented emissions -details'!$N$69,12*A26,0),\"\")","v":""},{"$f":"IF(F26<>\"\",OFFSET('2b Prevented emissions -details'!$P$69,A26*12,0),\"\")","v":""},{"$f":"IF(F26<>\"\",OFFSET('2b Prevented emissions -details'!$S$69,A26*12,0),\"\")","v":""},{"$f":"IF(F26<>\"\",OFFSET('2b Prevented emissions -details'!$R$69,A26*12,0),\"\")","v":""}]
[9,{"$f":"IF('General input data'!A21<>\"\",'General input data'!A21,\"\")","v":""},{"$f":"IF('General input data'!B21<>\"\",'General input data'!B21,\"\")","v":""},{"$f":"IF('General input data'!C21<>\"\",'General input data'!C21,\"\")","v":""},{"$f":"IF('General input data'!D21<>\"\",'General input data'!D21,\"\")","v":""},{"$f":"IF('General input data'!E21<>\"\",'General input data'!E21,\"\")","v":""},{"$f":"IF(F27<>0,OFFSET('2b Prevented emissions -details'!$I$69,A27*12,0),\"\")","v":""},{"$f":"IF(F27<>\"\",OFFSET('2b Prevented emissions -details'!$K$69,A27*12,0),\"\")","v":""},{"$f":"IF(D27<>\"\",OFFSET('2b Prevented emissions -details'!$N$69,12*A27,0),\"\")","v":""},{"$f":"IF(F27<>\"\",OFFSET('2b Prevented emissions -details'!$P$69,A27*12,0),\"\")","v":""},{"$f":"IF(F27<>\"\",OFFSET('2b Prevented emissions -details'!$S$69,A27*12,0),\"\")","v":""},{"$f":"IF(F27<>\"\",OFFSET('2b Prevented emissions -details'!$R$69,A27*12,0),\"\")","v":""}]
[10,{"$f":"IF('General input data'!A22<>\"\",'General input data'!A22,\"\")","v":""},{"$f":"IF('General input data'!B22<>\"\",'General input data'!B22,\"\")","v":""},{"$f":"IF('General input data'!C22<>\"\",'General input data'!C22,\"\")","v":""},{"$f":"IF('General input data'!D22<>\"\",'General input data'!D22,\"\")","v":""},{"$f":"IF('General input data'!E22<>\"\",'General input data'!E22,\"\")","v":""},{"$f":"IF(F28<>0,OFFSET('2b Prevented emissions -details'!$I$69,A28*12,0),\"\")","v":""},{"$f":"IF(F28<>\"\",OFFSET('2b Prevented emissions -details'!$K$69,A28*12,0),\"\")","v":""},{"$f":"IF(D28<>\"\",OFFSET('2b Prevented emissions -details'!$N$69,12*A28,0),\"\")","v":""},{"$f":"IF(F28<>\"\",OFFSET('2b Prevented emissions -details'!$P$69,A28*12,0),\"\")","v":""},{"$f":"IF(F28<>\"\",OFFSET('2b Prevented emissions -details'!$S$69,A28*12,0),\"\")","v":""},{"$f":"IF(F28<>\"\",OFFSET('2b Prevented emissions -details'!$R$69,A28*12,0),\"\")","v":""}]
[11,{"$f":"IF('General input data'!A23<>\"\",'General input data'!A23,\"\")","v":""},{"$f":"IF('General input data'!B23<>\"\",'General input data'!B23,\"\")","v":""},{"$f":"IF('General input data'!C23<>\"\",'General input data'!C23,\"\")","v":""},{"$f":"IF('General input data'!D23<>\"\",'General input data'!D23,\"\")","v":""},{"$f":"IF('General input data'!E23<>\"\",'General input data'!E23,\"\")","v":""},{"$f":"IF(F29<>0,OFFSET('2b Prevented emissions -details'!$I$69,A29*12,0),\"\")","v":""},{"$f":"IF(F29<>\"\",OFFSET('2b Prevented emissions -details'!$K$69,A29*12,0),\"\")","v":""},{"$f":"IF(D29<>\"\",OFFSET('2b Prevented emissions -details'!$N$69,12*A29,0),\"\")","v":""},{"$f":"IF(F29<>\"\",OFFSET('2b Prevented emissions -details'!$P$69,A29*12,0),\"\")","v":""},{"$f":"IF(F29<>\"\",OFFSET('2b Prevented emissions -details'!$S$69,A29*12,0),\"\")","v":""},{"$f":"IF(F29<>\"\",OFFSET('2b Prevented emissions -details'!$R$69,A29*12,0),\"\")","v":""}]
[12,{"$f":"IF('General input data'!A24<>\"\",'General input data'!A24,\"\")","v":""},{"$f":"IF('General input data'!B24<>\"\",'General input data'!B24,\"\")","v":""},{"$f":"IF('General input data'!C24<>\"\",'General input data'!C24,\"\")","v":""},{"$f":"IF('General input data'!D24<>\"\",'General input data'!D24,\"\")","v":""},{"$f":"IF('General input data'!E24<>\"\",'General input data'!E24,\"\")","v":""},{"$f":"IF(F30<>0,OFFSET('2b Prevented emissions -details'!$I$69,A30*12,0),\"\")","v":""},{"$f":"IF(F30<>\"\",OFFSET('2b Prevented emissions -details'!$K$69,A30*12,0),\"\")","v":""},{"$f":"IF(D30<>\"\",OFFSET('2b Prevented emissions -details'!$N$69,12*A30,0),\"\")","v":""},{"$f":"IF(F30<>\"\",OFFSET('2b Prevented emissions -details'!$P$69,A30*12,0),\"\")","v":""},{"$f":"IF(F30<>\"\",OFFSET('2b Prevented emissions -details'!$S$69,A30*12,0),\"\")","v":""},{"$f":"IF(F30<>\"\",OFFSET('2b Prevented emissions -details'!$R$69,A30*12,0),\"\")","v":""}]
[13,{"$f":"IF('General input data'!A25<>\"\",'General input data'!A25,\"\")","v":""},{"$f":"IF('General input data'!B25<>\"\",'General input data'!B25,\"\")","v":""},{"$f":"IF('General input data'!C25<>\"\",'General input data'!C25,\"\")","v":""},{"$f":"IF('General input data'!D25<>\"\",'General input data'!D25,\"\")","v":""},{"$f":"IF('General input data'!E25<>\"\",'General input data'!E25,\"\")","v":""},{"$f":"IF(F31<>0,OFFSET('2b Prevented emissions -details'!$I$69,A31*12,0),\"\")","v":""},{"$f":"IF(F31<>\"\",OFFSET('2b Prevented emissions -details'!$K$69,A31*12,0),\"\")","v":""},{"$f":"IF(D31<>\"\",OFFSET('2b Prevented emissions -details'!$N$69,12*A31,0),\"\")","v":""},{"$f":"IF(F31<>\"\",OFFSET('2b Prevented emissions -details'!$P$69,A31*12,0),\"\")","v":""},{"$f":"IF(F31<>\"\",OFFSET('2b Prevented emissions -details'!$S$69,A31*12,0),\"\")","v":""},{"$f":"IF(F31<>\"\",OFFSET('2b Prevented emissions -details'!$R$69,A31*12,0),\"\")","v":""}]
[14,{"$f":"IF('General input data'!A26<>\"\",'General input data'!A26,\"\")","v":""},{"$f":"IF('General input data'!B26<>\"\",'General input data'!B26,\"\")","v":""},{"$f":"IF('General input data'!C26<>\"\",'General input data'!C26,\"\")","v":""},{"$f":"IF('General input data'!D26<>\"\",'General input data'!D26,\"\")","v":""},{"$f":"IF('General input data'!E26<>\"\",'General input data'!E26,\"\")","v":""},{"$f":"IF(F32<>0,OFFSET('2b Prevented emissions -details'!$I$69,A32*12,0),\"\")","v":""},{"$f":"IF(F32<>\"\",OFFSET('2b Prevented emissions -details'!$K$69,A32*12,0),\"\")","v":""},{"$f":"IF(D32<>\"\",OFFSET('2b Prevented emissions -details'!$N$69,12*A32,0),\"\")","v":""},{"$f":"IF(F32<>\"\",OFFSET('2b Prevented emissions -details'!$P$69,A32*12,0),\"\")","v":""},{"$f":"IF(F32<>\"\",OFFSET('2b Prevented emissions -details'!$S$69,A32*12,0),\"\")","v":""},{"$f":"IF(F32<>\"\",OFFSET('2b Prevented emissions -details'!$R$69,A32*12,0),\"\")","v":""}]
[15,{"$f":"IF('General input data'!A27<>\"\",'General input data'!A27,\"\")","v":""},{"$f":"IF('General input data'!B27<>\"\",'General input data'!B27,\"\")","v":""},{"$f":"IF('General input data'!C27<>\"\",'General input data'!C27,\"\")","v":""},{"$f":"IF('General input data'!D27<>\"\",'General input data'!D27,\"\")","v":""},{"$f":"IF('General input data'!E27<>\"\",'General input data'!E27,\"\")","v":""},{"$f":"IF(F33<>0,OFFSET('2b Prevented emissions -details'!$I$69,A33*12,0),\"\")","v":""},{"$f":"IF(F33<>\"\",OFFSET('2b Prevented emissions -details'!$K$69,A33*12,0),\"\")","v":""},{"$f":"IF(D33<>\"\",OFFSET('2b Prevented emissions -details'!$N$69,12*A33,0),\"\")","v":""},{"$f":"IF(F33<>\"\",OFFSET('2b Prevented emissions -details'!$P$69,A33*12,0),\"\")","v":""},{"$f":"IF(F33<>\"\",OFFSET('2b Prevented emissions -details'!$S$69,A33*12,0),\"\")","v":""},{"$f":"IF(F33<>\"\",OFFSET('2b Prevented emissions -details'!$R$69,A33*12,0),\"\")","v":""}]
[16,{"$f":"IF('General input data'!A28<>\"\",'General input data'!A28,\"\")","v":""},{"$f":"IF('General input data'!B28<>\"\",'General input data'!B28,\"\")","v":""},{"$f":"IF('General input data'!C28<>\"\",'General input data'!C28,\"\")","v":""},{"$f":"IF('General input data'!D28<>\"\",'General input data'!D28,\"\")","v":""},{"$f":"IF('General input data'!E28<>\"\",'General input data'!E28,\"\")","v":""},{"$f":"IF(F34<>0,OFFSET('2b Prevented emissions -details'!$I$69,A34*12,0),\"\")","v":""},{"$f":"IF(F34<>\"\",OFFSET('2b Prevented emissions -details'!$K$69,A34*12,0),\"\")","v":""},{"$f":"IF(D34<>\"\",OFFSET('2b Prevented emissions -details'!$N$69,12*A34,0),\"\")","v":""},{"$f":"IF(F34<>\"\",OFFSET('2b Prevented emissions -details'!$P$69,A34*12,0),\"\")","v":""},{"$f":"IF(F34<>\"\",OFFSET('2b Prevented emissions -details'!$S$69,A34*12,0),\"\")","v":""},{"$f":"IF(F34<>\"\",OFFSET('2b Prevented emissions -details'!$R$69,A34*12,0),\"\")","v":""}]
[17,{"$f":"IF('General input data'!A29<>\"\",'General input data'!A29,\"\")","v":""},{"$f":"IF('General input data'!B29<>\"\",'General input data'!B29,\"\")","v":""},{"$f":"IF('General input data'!C29<>\"\",'General input data'!C29,\"\")","v":""},{"$f":"IF('General input data'!D29<>\"\",'General input data'!D29,\"\")","v":""},{"$f":"IF('General input data'!E29<>\"\",'General input data'!E29,\"\")","v":""},{"$f":"IF(F35<>0,OFFSET('2b Prevented emissions -details'!$I$69,A35*12,0),\"\")","v":""},{"$f":"IF(F35<>\"\",OFFSET('2b Prevented emissions -details'!$K$69,A35*12,0),\"\")","v":""},{"$f":"IF(D35<>\"\",OFFSET('2b Prevented emissions -details'!$N$69,12*A35,0),\"\")","v":""},{"$f":"IF(F35<>\"\",OFFSET('2b Prevented emissions -details'!$P$69,A35*12,0),\"\")","v":""},{"$f":"IF(F35<>\"\",OFFSET('2b Prevented emissions -details'!$S$69,A35*12,0),\"\")","v":""},{"$f":"IF(F35<>\"\",OFFSET('2b Prevented emissions -details'!$R$69,A35*12,0),\"\")","v":""}]
[18,{"$f":"IF('General input data'!A30<>\"\",'General input data'!A30,\"\")","v":""},{"$f":"IF('General input data'!B30<>\"\",'General input data'!B30,\"\")","v":""},{"$f":"IF('General input data'!C30<>\"\",'General input data'!C30,\"\")","v":""},{"$f":"IF('General input data'!D30<>\"\",'General input data'!D30,\"\")","v":""},{"$f":"IF('General input data'!E30<>\"\",'General input data'!E30,\"\")","v":""},{"$f":"IF(F36<>0,OFFSET('2b Prevented emissions -details'!$I$69,A36*12,0),\"\")","v":""},{"$f":"IF(F36<>\"\",OFFSET('2b Prevented emissions -details'!$K$69,A36*12,0),\"\")","v":""},{"$f":"IF(D36<>\"\",OFFSET('2b Prevented emissions -details'!$N$69,12*A36,0),\"\")","v":""},{"$f":"IF(F36<>\"\",OFFSET('2b Prevented emissions -details'!$P$69,A36*12,0),\"\")","v":""},{"$f":"IF(F36<>\"\",OFFSET('2b Prevented emissions -details'!$S$69,A36*12,0),\"\")","v":""},{"$f":"IF(F36<>\"\",OFFSET('2b Prevented emissions -details'!$R$69,A36*12,0),\"\")","v":""}]
[19,{"$f":"IF('General input data'!A31<>\"\",'General input data'!A31,\"\")","v":""},{"$f":"IF('General input data'!B31<>\"\",'General input data'!B31,\"\")","v":""},{"$f":"IF('General input data'!C31<>\"\",'General input data'!C31,\"\")","v":""},{"$f":"IF('General input data'!D31<>\"\",'General input data'!D31,\"\")","v":""},{"$f":"IF('General input data'!E31<>\"\",'General input data'!E31,\"\")","v":""},{"$f":"IF(F37<>0,OFFSET('2b Prevented emissions -details'!$I$69,A37*12,0),\"\")","v":""},{"$f":"IF(F37<>\"\",OFFSET('2b Prevented emissions -details'!$K$69,A37*12,0),\"\")","v":""},{"$f":"IF(D37<>\"\",OFFSET('2b Prevented emissions -details'!$N$69,12*A37,0),\"\")","v":""},{"$f":"IF(F37<>\"\",OFFSET('2b Prevented emissions -details'!$P$69,A37*12,0),\"\")","v":""},{"$f":"IF(F37<>\"\",OFFSET('2b Prevented emissions -details'!$S$69,A37*12,0),\"\")","v":""},{"$f":"IF(F37<>\"\",OFFSET('2b Prevented emissions -details'!$R$69,A37*12,0),\"\")","v":""}]
[20,{"$f":"IF('General input data'!A32<>\"\",'General input data'!A32,\"\")","v":""},{"$f":"IF('General input data'!B32<>\"\",'General input data'!B32,\"\")","v":""},{"$f":"IF('General input data'!C32<>\"\",'General input data'!C32,\"\")","v":""},{"$f":"IF('General input data'!D32<>\"\",'General input data'!D32,\"\")","v":""},{"$f":"IF('General input data'!E32<>\"\",'General input data'!E32,\"\")","v":""},{"$f":"IF(F38<>0,OFFSET('2b Prevented emissions -details'!$I$69,A38*12,0),\"\")","v":""},{"$f":"IF(F38<>\"\",OFFSET('2b Prevented emissions -details'!$K$69,A38*12,0),\"\")","v":""},{"$f":"IF(D38<>\"\",OFFSET('2b Prevented emissions -details'!$N$69,12*A38,0),\"\")","v":""},{"$f":"IF(F38<>\"\",OFFSET('2b Prevented emissions -details'!$P$69,A38*12,0),\"\")","v":""},{"$f":"IF(F38<>\"\",OFFSET('2b Prevented emissions -details'!$S$69,A38*12,0),\"\")","v":""},{"$f":"IF(F38<>\"\",OFFSET('2b Prevented emissions -details'!$R$69,A38*12,0),\"\")","v":""}]
[21,{"$f":"IF('General input data'!A33<>\"\",'General input data'!A33,\"\")","v":""},{"$f":"IF('General input data'!B33<>\"\",'General input data'!B33,\"\")","v":""},{"$f":"IF('General input data'!C33<>\"\",'General input data'!C33,\"\")","v":""},{"$f":"IF('General input data'!D33<>\"\",'General input data'!D33,\"\")","v":""},{"$f":"IF('General input data'!E33<>\"\",'General input data'!E33,\"\")","v":""},{"$f":"IF(F39<>0,OFFSET('2b Prevented emissions -details'!$I$69,A39*12,0),\"\")","v":""},{"$f":"IF(F39<>\"\",OFFSET('2b Prevented emissions -details'!$K$69,A39*12,0),\"\")","v":""},{"$f":"IF(D39<>\"\",OFFSET('2b Prevented emissions -details'!$N$69,12*A39,0),\"\")","v":""},{"$f":"IF(F39<>\"\",OFFSET('2b Prevented emissions -details'!$P$69,A39*12,0),\"\")","v":""},{"$f":"IF(F39<>\"\",OFFSET('2b Prevented emissions -details'!$S$69,A39*12,0),\"\")","v":""},{"$f":"IF(F39<>\"\",OFFSET('2b Prevented emissions -details'!$R$69,A39*12,0),\"\")","v":""}]
[22,{"$f":"IF('General input data'!A34<>\"\",'General input data'!A34,\"\")","v":""},{"$f":"IF('General input data'!B34<>\"\",'General input data'!B34,\"\")","v":""},{"$f":"IF('General input data'!C34<>\"\",'General input data'!C34,\"\")","v":""},{"$f":"IF('General input data'!D34<>\"\",'General input data'!D34,\"\")","v":""},{"$f":"IF('General input data'!E34<>\"\",'General input data'!E34,\"\")","v":""},{"$f":"IF(F40<>0,OFFSET('2b Prevented emissions -details'!$I$69,A40*12,0),\"\")","v":""},{"$f":"IF(F40<>\"\",OFFSET('2b Prevented emissions -details'!$K$69,A40*12,0),\"\")","v":""},{"$f":"IF(D40<>\"\",OFFSET('2b Prevented emissions -details'!$N$69,12*A40,0),\"\")","v":""},{"$f":"IF(F40<>\"\",OFFSET('2b Prevented emissions -details'!$P$69,A40*12,0),\"\")","v":""},{"$f":"IF(F40<>\"\",OFFSET('2b Prevented emissions -details'!$S$69,A40*12,0),\"\")","v":""},{"$f":"IF(F40<>\"\",OFFSET('2b Prevented emissions -details'!$R$69,A40*12,0),\"\")","v":""}]
[23,{"$f":"IF('General input data'!A35<>\"\",'General input data'!A35,\"\")","v":""},{"$f":"IF('General input data'!B35<>\"\",'General input data'!B35,\"\")","v":""},{"$f":"IF('General input data'!C35<>\"\",'General input data'!C35,\"\")","v":""},{"$f":"IF('General input data'!D35<>\"\",'General input data'!D35,\"\")","v":""},{"$f":"IF('General input data'!E35<>\"\",'General input data'!E35,\"\")","v":""},{"$f":"IF(F41<>0,OFFSET('2b Prevented emissions -details'!$I$69,A41*12,0),\"\")","v":""},{"$f":"IF(F41<>\"\",OFFSET('2b Prevented emissions -details'!$K$69,A41*12,0),\"\")","v":""},{"$f":"IF(D41<>\"\",OFFSET('2b Prevented emissions -details'!$N$69,12*A41,0),\"\")","v":""},{"$f":"IF(F41<>\"\",OFFSET('2b Prevented emissions -details'!$P$69,A41*12,0),\"\")","v":""},{"$f":"IF(F41<>\"\",OFFSET('2b Prevented emissions -details'!$S$69,A41*12,0),\"\")","v":""},{"$f":"IF(F41<>\"\",OFFSET('2b Prevented emissions -details'!$R$69,A41*12,0),\"\")","v":""}]
[null,"TOTALS",null,{"$f":"SUM(D18:D41)","v":200},null,{"$f":"SUM(F18:F41)","v":200},null,{"$f":"SUM(H18:H41)","v":-170},null,{"$f":"SUM(J18:J41)","v":-40},{"$f":"-L42/F42","v":1.05},{"$f":"SUM(L18:L41)","v":-210}]

{"sheet":"2b Prevented emissions -details","index":4,"n_rows":369,"n_cols":19,"rows_kept":369,"cut":false,"hidden":false,"merged":[[54,17,55,17],[54,1,56,1],[54,4,56,4],[54,8,54,12],[54,13,54,16],[55,2,55,3],[54,2,54,3],[55,6,55,7],[54,6,54,7],[0,0,0,12],[32,4,32,6],[33,4,33,6],[34,4,34,6],[35,4,35,6],[27,4,27,6],[29,4,29,6],[30,4,30,6],[31,4,31,6],[28,1,28,6],[4,0,4,4],[5,1,5,4],[18,0,18,4],[14,0,14,4],[15,0,15,4],[2,0,2,4],[45,4,45,6],[53,1,53,18],[48,1,48,4],[49,1,49,4],[50,1,50,4],[51,1,51,4],[39,4,39,6],[40,4,40,6],[9,1,9,4],[10,1,10,4],[44,4,44,6],[13,0,13,4],[11,1,11,4],[20,0,20,4],[41,4,41,6],[36,1,36,6],[42,4,42,6],[43,4,43,6],[21,0,21,4],[24,1,24,4],[25,1,25,4],[16,0,16,4],[6,1,6,4],[7,1,7,4],[8,1,8,4],[37,4,37,6],[38,4,38,6],[17,0,17,4]]}
["Component 2b: Prevented emissions - Detailed calculations"]
[]
["This sheet is to enter details for each identified use of each identified products category. Details are summarized on the previous sheet."]
[]
["Prevented emissions refers to the  emissions that would be caused by counterfactual non-wood based products. "]
[null,"Prevented emissions is ONLY calculated for products volumes marketed by the corporation in the defined time period. Internally used biomass (eg for energy) does not render any prevented emissions."]
[null,"Marketed wood-based products may be produced by virgin wood material, recycled material or a mix of the two. Prevented emissions calculations do not distinguish between the source of wood-based material used."]
[null,"Displacement Factors (DFs) are calculated for equal functional units and normally refers to the biogenic carbon mass (CO2e) of the wood based product / Cradle to Gate emissions of the alternative product (CO2e), ie a unitless factor. "]
[null,"Differences in between wood/non-wood products regarding user phase emissions (gate to grave) may be included as well. These can be higher or lower for the wood-based product "]
[null,"Prevented emissions are calulated for the first use of marketed wood-based products and for the final use for energy for the corresponding products during the time period in question"]
[null,"Prevented emissions from downstream recycled uses are not included. (Although all products marketed by a corporation are assigned a first-use DF, regardless of the proportion of recycled material used, see above)"]
[]
["Assessment starts from the product categories on the General input data, which are automatically copied"]
["Then for each product category:"]
["1. Identify product uses to include in the assessment"]
["2. Assign Displacement Factor for the  First Use of each product use"]
["3. Assign proportion of volume that leads to First Use prevented emisisons (ie excluding spill and other inefficiencies)"]
["4. Assign Displacement Factor for Final use for energy for recovered product material (usually as energy)"]
["5. Assign proportion of volume that leads to Final Use during the time period (possibly using inflow/outflow assumptions for long lived products)"]
["Note"]
["Default (Tier 1) DFs are provided on this sheet. Own DFs (Tier 2) can be calculated from LCAs/EPDs or other research literature."]
["Given that several corporations along the value chain can assess DF based on the same products/material, DFs across corporations cannot be added without considering possible doublecounting."]
[]
[null,"Displacement Factors"]
[null,"For references of displacement factors, see separate list available at the webpage for CLEAR:"]
[null,"https://www.skogforsk.se/CLEAR"]
[]
[null,"Product category","Displaced product","Displacement factor tCO2e/tCO2e","Remarks"]
[null,"1. Default factors when corporate-specific data are not available (Tier 1)"]
[null,"Roundwood ","Combination of marketed products after processing",0.5,"For volume under bark. Assumes that roundwood is used as sawnwood to the extent possible and for fibre based products and energy for the remaining biomass."]
[null,"Sawn wood","Various non-wood construction materials",1.2,"Can be used for general applications of first uses for sawn wood. Some uses lead to highe DFs (eg windows, doors), some to lower (eg pallets)"]
[null,"Wood-based panels","Various non-wood materials",1,"Can be used for general applications of panels for first use"]
[null,"Paper packaging","Packaging from plastic, glass or metal",1,"Displacement of glass and metal packaging generally renders higher displacement factors, but are not distinguished here"]
[null,"Other fibre based products","None identified",0,"Many fibre based products will render displacement sometimes with high DFs, but are not distinguished in this indicative list. However, generally final use for energy recovery will lead to displacement."]
[null,"Bioenergy products (solid products, heat or electricity)","Corresponding energy product based on fossil fuels",0.8,"Depending on the fossil fuel displaced, the displacement factor can b higher or lower, but this is not distinguished here"]
[null,"Liquid biofuels","Corresponding liquid fossil fuel",1.2,"Emissions from fossil fuel include emissions from upstream extraction and refining"]
[null,"2. Corporate-specific factors used in this assessment"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Colour coding:"]
[null,"Cells where data are entered manually"]
[null,"Cells where data is copied/calculated based on  other cells - NO manual input to be made in these cells"]
[null,"Cells where constants / conversion factors are provided "]
[null,"Cells with no data"]
[]
[null,{"$f":"'General input data'!A9","v":"Time period XXX"}]
[null,"Product category",null,null,"Product uses considered",null,null,null,"First use",null,null,null,null,"Final use (energy)",null,null,null,"Assessed prevented emissions","Assessed DF for Product category "]
[null,null,"Total volume",null,null,"Fraction of total volume","Volume delivered for this use",null,"Displacement Factor","Fraction of use volume leading to prevented emissions","Assessed prevented emissions","Recycling rate on total product volume","Comment/assumptions","Displacement Factor","Fraction of use volume leading to prevented emissions","Assessed prevented emissions","Comment/assumptions",null,"Weighted Overall Displacement Factor over total category volume"]
[null,null,"in market unit","tCO2e",null,"0..1","in market unit","tCO2e","tCO2e/tCO2e","0..1","tCO2e","0..1",null,"tCO2e/tCO2e","0..1","tCO2e",null,"tCO2e","tCO2e/tCO2e"]
[0,{"$f":"IF(OFFSET('General input data'!A$12,A58,0)<>\"\",OFFSET('General input data'!A$12,A58,0),\"\")","v":"Product category 1"},{"$f":"IF(OFFSET('General input data'!C$12,A58,0)<>\"\",OFFSET('General input data'!C$12,A58,0),\"\")","v":100},{"$f":"IF(OFFSET('General input data'!E$12,A58,0)<>\"\",OFFSET('General input data'!E$12,A58,0),\"\")","v":100},"Product use 1",0.2,{"$f":"IF(F58>0,C$58*F58,\"\")","v":20},{"$f":"IF(F58>0,D$58*F58,\"\")","v":20},1,1,{"$f":"IF(J58<>\"\",-I58*J58*H58,\"\")","v":-20},1,null,1,0.2,{"$f":"IF(O58<>\"\",-N58*O58*H58,\"\")","v":-4},null,{"$f":"IF(H58<>\"\",K58+P58,\"\")","v":-24}]
[null,null,null,null,"Product use 2",0.3,{"$f":"IF(F59>0,C$58*F59,\"\")","v":30},{"$f":"IF(F59>0,D$58*F59,\"\")","v":30},1,1,{"$f":"IF(J59<>\"\",-I59*J59*H59,\"\")","v":-30},0,null,1,0.3,{"$f":"IF(O59<>\"\",-N59*O59*H59,\"\")","v":-9},null,{"$f":"IF(H59<>\"\",K59+P59,\"\")","v":-39}]
[null,null,null,null,"Product use 3",0.5,50,50,1,1,{"$f":"IF(J60<>\"\",-I60*J60*H60,\"\")","v":-50},null,null,1,0.4,{"$f":"IF(O60<>\"\",-N60*O60*H60,\"\")","v":-20},null,{"$f":"IF(H60<>\"\",K60+P60,\"\")","v":-70}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,{"$f":"IF(H61<>\"\",K61+P61,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,{"$f":"IF(F68*$D$58>0,F68*$D$58,\"\")","v":""},null,null,null,null,"Fraction with no first use identified:",1,{"$f":"IF(D58<>\"\",(1-F69),\"\")","v":0},{"$f":"IF(O68<>\"\",O68*D58,\"\")","v":0},null,""]
[null,null,null,null,"Total/weighted average:",{"$f":"IF(SUM(F58:F68)>0,SUM(F58:F68),\"\")","v":1},{"$f":"IF(SUM(G58:G68)>0,SUM(G58:G68),\"\")","v":100},100,{"$f":"IF(D58<>\"\",K69/D58,\"\")","v":-1},null,{"$f":"IF(D58<>\"\",SUM(K58:K67),\"\")","v":-100},{"$f":"IF(D58<>\"\",SUMPRODUCT('[1]2b Prevented emissions -details'!F58:F59,L58:L59),\"\")","v":0.3},null,{"$f":"IF(D58<>\"\",P69/D58,\"\")","v":-0.33},null,{"$f":"IF(D58<>\"\",SUM(P58:P68),\"\")","v":-33},null,{"$f":"IF(D58<>\"\",SUM(R58:R68),\"\")","v":-133},{"$f":"IF(D58<>\"\",I69+N69,\"\")","v":-1.33}]
[1,{"$f":"IF(OFFSET('General input data'!A$12,A70,0)<>\"\",OFFSET('General input data'!A$12,A70,0),\"\")","v":"Product category 2"},{"$f":"IF(OFFSET('General input data'!C$12,A70,0)<>\"\",OFFSET('General input data'!C$12,A70,0),\"\")","v":100},{"$f":"IF(OFFSET('General input data'!E$12,A70,0)<>\"\",OFFSET('General input data'!E$12,A70,0),\"\")","v":100},"Product use 1",0.2,{"$f":"IF(F70>0,C$70*F70,\"\")","v":20},{"$f":"IF(F70>0,D$70*F70,\"\")","v":20},1,0.7,{"$f":"IF(J70<>\"\",-I70*J70*H70,\"\")","v":-14},null,null,0.7,0.1,{"$f":"IF(O70<>\"\",-N70*O70*H70,\"\")","v":-1.4},null,{"$f":"IF(H70<>\"\",K70+P70,\"\")","v":-15.4}]
[null,null,null,null,"Product use 2",0.3,{"$f":"IF(F71>0,C$70*F71,\"\")","v":30},{"$f":"IF(F71>0,D$70*F71,\"\")","v":30},1,0.7,{"$f":"IF(J71<>\"\",-I71*J71*H71,\"\")","v":-21},null,null,0.7,0.1,{"$f":"IF(O71<>\"\",-N71*O71*H71,\"\")","v":-2.0999999999999996},null,{"$f":"IF(H71<>\"\",K71+P71,\"\")","v":-23.1}]
[null,null,null,null,"Product use 3",0.5,50,50,1,0.7,{"$f":"IF(J72<>\"\",-I72*J72*H72,\"\")","v":-35},null,null,0.7,0.1,{"$f":"IF(O72<>\"\",-N72*O72*H72,\"\")","v":-3.4999999999999996},null,{"$f":"IF(H72<>\"\",K72+P72,\"\")","v":-38.5}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,{"$f":"IF(H73<>\"\",K73+P73,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,{"$f":"IF(F80*$D$58>0,F80*$D$58,\"\")","v":""},null,null,null,null,"Fraction with no first use identified:",1,{"$f":"IF(D70<>\"\",(1-F81),\"\")","v":0},{"$f":"IF(O80<>\"\",O80*D70,\"\")","v":0},null,""]
[null,null,null,null,"Total/weighted average:",{"$f":"IF(SUM(F70:F80)>0,SUM(F70:F80),\"\")","v":1},{"$f":"IF(SUM(G70:G80)>0,SUM(G70:G80),\"\")","v":100},100,{"$f":"IF(D70<>\"\",K81/D70,\"\")","v":-0.7},null,{"$f":"IF(D70<>\"\",SUM(K70:K79),\"\")","v":-70},{"$f":"IF(D70<>\"\",SUMPRODUCT(F70:F71,L70:L71),\"\")","v":0},null,{"$f":"IF(D70<>\"\",P81/D70,\"\")","v":-6.9999999999999993E-2},null,{"$f":"IF(D70<>\"\",SUM(P70:P80),\"\")","v":-6.9999999999999991},null,{"$f":"IF(D70<>\"\",SUM(R70:R80),\"\")","v":-77},{"$f":"IF(D70<>\"\",I81+N81,\"\")","v":-0.76999999999999991}]
[2,{"$f":"IF(OFFSET('General input data'!A$12,A82,0)<>\"\",OFFSET('General input data'!A$12,A82,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!C$12,A82,0)<>\"\",OFFSET('General input data'!C$12,A82,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!E$12,A82,0)<>\"\",OFFSET('General input data'!E$12,A82,0),\"\")","v":""},null,null,{"$f":"IF(F82>0,C$214*F82,\"\")","v":""},{"$f":"IF(F82>0,D$214*F82,\"\")","v":""},null,null,{"$f":"IF(J82<>\"\",-I82*J82*H82,\"\")","v":""},null,null,null,null,{"$f":"IF(O82<>\"\",-N82*O82*H82,\"\")","v":""},null,{"$f":"IF(H82<>\"\",K82+P82,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(F83>0,C$214*F83,\"\")","v":""},{"$f":"IF(F83>0,D$214*F83,\"\")","v":""},null,null,{"$f":"IF(J83<>\"\",-I83*J83*H83,\"\")","v":""},null,null,null,null,{"$f":"IF(O83<>\"\",-N83*O83*H83,\"\")","v":""},null,{"$f":"IF(H83<>\"\",K83+P83,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,{"$f":"IF(J84<>\"\",-I84*J84*H84,\"\")","v":""},null,null,null,null,{"$f":"IF(O84<>\"\",-N84*O84*H84,\"\")","v":""},null,{"$f":"IF(H84<>\"\",K84+P84,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,{"$f":"IF(H85<>\"\",K85+P85,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,{"$f":"IF(F92*$D$58>0,F92*$D$58,\"\")","v":""},null,null,null,null,"Fraction with no first use identified:",null,{"$f":"IF(D82<>\"\",(1-F93),\"\")","v":""},{"$f":"IF(O92<>\"\",O92*D82,\"\")","v":""},null,""]
[null,null,null,null,"Total/weighted average:",{"$f":"IF(SUM(F82:F92)>0,SUM(F82:F92),\"\")","v":""},{"$f":"IF(SUM(G82:G92)>0,SUM(G82:G92),\"\")","v":""},"",{"$f":"IF(D82<>\"\",K93/D82,\"\")","v":""},null,{"$f":"IF(D82<>\"\",SUM(K82:K91),\"\")","v":""},{"$f":"IF(D82<>\"\",SUMPRODUCT(F82:F83,L82:L83),\"\")","v":""},null,{"$f":"IF(D82<>\"\",P93/D82,\"\")","v":""},null,{"$f":"IF(D82<>\"\",SUM(P82:P92),\"\")","v":""},null,{"$f":"IF(D82<>\"\",SUM(R82:R92),\"\")","v":""},{"$f":"IF(D82<>\"\",I93+N93,\"\")","v":""}]
[3,{"$f":"IF(OFFSET('General input data'!A$12,A94,0)<>\"\",OFFSET('General input data'!A$12,A94,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!C$12,A94,0)<>\"\",OFFSET('General input data'!C$12,A94,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!E$12,A94,0)<>\"\",OFFSET('General input data'!E$12,A94,0),\"\")","v":""},null,null,{"$f":"IF(F94>0,C$214*F94,\"\")","v":""},{"$f":"IF(F94>0,D$214*F94,\"\")","v":""},null,null,{"$f":"IF(J94<>\"\",-I94*J94*H94,\"\")","v":""},null,null,null,null,{"$f":"IF(O94<>\"\",-N94*O94*H94,\"\")","v":""},null,{"$f":"IF(H94<>\"\",K94+P94,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(F95>0,C$214*F95,\"\")","v":""},{"$f":"IF(F95>0,D$214*F95,\"\")","v":""},null,null,{"$f":"IF(J95<>\"\",-I95*J95*H95,\"\")","v":""},null,null,null,null,{"$f":"IF(O95<>\"\",-N95*O95*H95,\"\")","v":""},null,{"$f":"IF(H95<>\"\",K95+P95,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,{"$f":"IF(J96<>\"\",-I96*J96*H96,\"\")","v":""},null,null,null,null,{"$f":"IF(O96<>\"\",-N96*O96*H96,\"\")","v":""},null,{"$f":"IF(H96<>\"\",K96+P96,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,{"$f":"IF(H97<>\"\",K97+P97,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,{"$f":"IF(F104*$D$58>0,F104*$D$58,\"\")","v":""},null,null,null,null,"Fraction with no first use identified:",null,{"$f":"IF(D94<>\"\",(1-F105),\"\")","v":""},{"$f":"IF(O104<>\"\",O104*D94,\"\")","v":""},null,""]
[null,null,null,null,"Total/weighted average:",{"$f":"IF(SUM(F94:F104)>0,SUM(F94:F104),\"\")","v":""},{"$f":"IF(SUM(G94:G104)>0,SUM(G94:G104),\"\")","v":""},"",{"$f":"IF(D94<>\"\",K105/D94,\"\")","v":""},null,{"$f":"IF(D94<>\"\",SUM(K94:K103),\"\")","v":""},{"$f":"IF(D94<>\"\",SUMPRODUCT(F94:F95,L94:L95),\"\")","v":""},null,{"$f":"IF(D94<>\"\",P105/D94,\"\")","v":""},null,{"$f":"IF(D94<>\"\",SUM(P94:P104),\"\")","v":""},null,{"$f":"IF(D94<>\"\",SUM(R94:R104),\"\")","v":""},{"$f":"IF(D94<>\"\",I105+N105,\"\")","v":""}]
[4,{"$f":"IF(OFFSET('General input data'!A$12,A106,0)<>\"\",OFFSET('General input data'!A$12,A106,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!C$12,A106,0)<>\"\",OFFSET('General input data'!C$12,A106,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!E$12,A106,0)<>\"\",OFFSET('General input data'!E$12,A106,0),\"\")","v":""},null,null,{"$f":"IF(F106>0,C$214*F106,\"\")","v":""},{"$f":"IF(F106>0,D$214*F106,\"\")","v":""},null,null,{"$f":"IF(J106<>\"\",-I106*J106*H106,\"\")","v":""},null,null,null,null,{"$f":"IF(O106<>\"\",-N106*O106*H106,\"\")","v":""},null,{"$f":"IF(H106<>\"\",K106+P106,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(F107>0,C$214*F107,\"\")","v":""},{"$f":"IF(F107>0,D$214*F107,\"\")","v":""},null,null,{"$f":"IF(J107<>\"\",-I107*J107*H107,\"\")","v":""},null,null,null,null,{"$f":"IF(O107<>\"\",-N107*O107*H107,\"\")","v":""},null,{"$f":"IF(H107<>\"\",K107+P107,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,{"$f":"IF(J108<>\"\",-I108*J108*H108,\"\")","v":""},null,null,null,null,{"$f":"IF(O108<>\"\",-N108*O108*H108,\"\")","v":""},null,{"$f":"IF(H108<>\"\",K108+P108,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,{"$f":"IF(H109<>\"\",K109+P109,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,{"$f":"IF(F116*$D$58>0,F116*$D$58,\"\")","v":""},null,null,null,null,"Fraction with no first use identified:",null,{"$f":"IF(D106<>\"\",(1-F117),\"\")","v":""},{"$f":"IF(O116<>\"\",O116*D106,\"\")","v":""},null,""]
[null,null,null,null,"Total/weighted average:",{"$f":"IF(SUM(F106:F116)>0,SUM(F106:F116),\"\")","v":""},{"$f":"IF(SUM(G106:G116)>0,SUM(G106:G116),\"\")","v":""},"",{"$f":"IF(D106<>\"\",K117/D106,\"\")","v":""},null,{"$f":"IF(D106<>\"\",SUM(K106:K115),\"\")","v":""},{"$f":"IF(D106<>\"\",SUMPRODUCT(F106:F107,L106:L107),\"\")","v":""},null,{"$f":"IF(D106<>\"\",P117/D106,\"\")","v":""},null,{"$f":"IF(D106<>\"\",SUM(P106:P116),\"\")","v":""},null,{"$f":"IF(D106<>\"\",SUM(R106:R116),\"\")","v":""},{"$f":"IF(D106<>\"\",I117+N117,\"\")","v":""}]
[5,{"$f":"IF(OFFSET('General input data'!A$12,A118,0)<>\"\",OFFSET('General input data'!A$12,A118,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!C$12,A118,0)<>\"\",OFFSET('General input data'!C$12,A118,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!E$12,A118,0)<>\"\",OFFSET('General input data'!E$12,A118,0),\"\")","v":""},null,null,{"$f":"IF(F118>0,C$214*F118,\"\")","v":""},{"$f":"IF(F118>0,D$214*F118,\"\")","v":""},null,null,{"$f":"IF(J118<>\"\",-I118*J118*H118,\"\")","v":""},null,null,null,null,{"$f":"IF(O118<>\"\",-N118*O118*H118,\"\")","v":""},null,{"$f":"IF(H118<>\"\",K118+P118,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(F119>0,C$214*F119,\"\")","v":""},{"$f":"IF(F119>0,D$214*F119,\"\")","v":""},null,null,{"$f":"IF(J119<>\"\",-I119*J119*H119,\"\")","v":""},null,null,null,null,{"$f":"IF(O119<>\"\",-N119*O119*H119,\"\")","v":""},null,{"$f":"IF(H119<>\"\",K119+P119,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,{"$f":"IF(J120<>\"\",-I120*J120*H120,\"\")","v":""},null,null,null,null,{"$f":"IF(O120<>\"\",-N120*O120*H120,\"\")","v":""},null,{"$f":"IF(H120<>\"\",K120+P120,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,{"$f":"IF(H121<>\"\",K121+P121,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,{"$f":"IF(F128*$D$58>0,F128*$D$58,\"\")","v":""},null,null,null,null,"Fraction with no first use identified:",null,{"$f":"IF(D118<>\"\",(1-F129),\"\")","v":""},{"$f":"IF(O128<>\"\",O128*D118,\"\")","v":""},null,""]
[null,null,null,null,"Total/weighted average:",{"$f":"IF(SUM(F118:F128)>0,SUM(F118:F128),\"\")","v":""},{"$f":"IF(SUM(G118:G128)>0,SUM(G118:G128),\"\")","v":""},"",{"$f":"IF(D118<>\"\",K129/D118,\"\")","v":""},null,{"$f":"IF(D118<>\"\",SUM(K118:K127),\"\")","v":""},{"$f":"IF(D118<>\"\",SUMPRODUCT(F118:F119,L118:L119),\"\")","v":""},null,{"$f":"IF(D118<>\"\",P129/D118,\"\")","v":""},null,{"$f":"IF(D118<>\"\",SUM(P118:P128),\"\")","v":""},null,{"$f":"IF(D118<>\"\",SUM(R118:R128),\"\")","v":""},{"$f":"IF(D118<>\"\",I129+N129,\"\")","v":""}]
[6,{"$f":"IF(OFFSET('General input data'!A$12,A130,0)<>\"\",OFFSET('General input data'!A$12,A130,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!C$12,A130,0)<>\"\",OFFSET('General input data'!C$12,A130,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!E$12,A130,0)<>\"\",OFFSET('General input data'!E$12,A130,0),\"\")","v":""},null,null,{"$f":"IF(F130>0,C$214*F130,\"\")","v":""},{"$f":"IF(F130>0,D$214*F130,\"\")","v":""},null,null,{"$f":"IF(J130<>\"\",-I130*J130*H130,\"\")","v":""},null,null,null,null,{"$f":"IF(O130<>\"\",-N130*O130*H130,\"\")","v":""},null,{"$f":"IF(H130<>\"\",K130+P130,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(F131>0,C$214*F131,\"\")","v":""},{"$f":"IF(F131>0,D$214*F131,\"\")","v":""},null,null,{"$f":"IF(J131<>\"\",-I131*J131*H131,\"\")","v":""},null,null,null,null,{"$f":"IF(O131<>\"\",-N131*O131*H131,\"\")","v":""},null,{"$f":"IF(H131<>\"\",K131+P131,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,{"$f":"IF(J132<>\"\",-I132*J132*H132,\"\")","v":""},null,null,null,null,{"$f":"IF(O132<>\"\",-N132*O132*H132,\"\")","v":""},null,{"$f":"IF(H132<>\"\",K132+P132,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,{"$f":"IF(H133<>\"\",K133+P133,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,{"$f":"IF(F140*$D$58>0,F140*$D$58,\"\")","v":""},null,null,null,null,"Fraction with no first use identified:",null,{"$f":"IF(D130<>\"\",(1-F141),\"\")","v":""},{"$f":"IF(O140<>\"\",O140*D130,\"\")","v":""},null,""]
[null,null,null,null,"Total/weighted average:",{"$f":"IF(SUM(F130:F140)>0,SUM(F130:F140),\"\")","v":""},{"$f":"IF(SUM(G130:G140)>0,SUM(G130:G140),\"\")","v":""},"",{"$f":"IF(D130<>\"\",K141/D130,\"\")","v":""},null,{"$f":"IF(D130<>\"\",SUM(K130:K139),\"\")","v":""},{"$f":"IF(D130<>\"\",SUMPRODUCT(F130:F131,L130:L131),\"\")","v":""},null,{"$f":"IF(D130<>\"\",P141/D130,\"\")","v":""},null,{"$f":"IF(D130<>\"\",SUM(P130:P140),\"\")","v":""},null,{"$f":"IF(D130<>\"\",SUM(R130:R140),\"\")","v":""},{"$f":"IF(D130<>\"\",I141+N141,\"\")","v":""}]
[7,{"$f":"IF(OFFSET('General input data'!A$12,A142,0)<>\"\",OFFSET('General input data'!A$12,A142,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!C$12,A142,0)<>\"\",OFFSET('General input data'!C$12,A142,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!E$12,A142,0)<>\"\",OFFSET('General input data'!E$12,A142,0),\"\")","v":""},null,null,{"$f":"IF(F142>0,C$214*F142,\"\")","v":""},{"$f":"IF(F142>0,D$214*F142,\"\")","v":""},null,null,{"$f":"IF(J142<>\"\",-I142*J142*H142,\"\")","v":""},null,null,null,null,{"$f":"IF(O142<>\"\",-N142*O142*H142,\"\")","v":""},null,{"$f":"IF(H142<>\"\",K142+P142,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(F143>0,C$214*F143,\"\")","v":""},{"$f":"IF(F143>0,D$214*F143,\"\")","v":""},null,null,{"$f":"IF(J143<>\"\",-I143*J143*H143,\"\")","v":""},null,null,null,null,{"$f":"IF(O143<>\"\",-N143*O143*H143,\"\")","v":""},null,{"$f":"IF(H143<>\"\",K143+P143,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,{"$f":"IF(J144<>\"\",-I144*J144*H144,\"\")","v":""},null,null,null,null,{"$f":"IF(O144<>\"\",-N144*O144*H144,\"\")","v":""},null,{"$f":"IF(H144<>\"\",K144+P144,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,{"$f":"IF(H145<>\"\",K145+P145,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,{"$f":"IF(F152*$D$58>0,F152*$D$58,\"\")","v":""},null,null,null,null,"Fraction with no first use identified:",null,{"$f":"IF(D142<>\"\",(1-F153),\"\")","v":""},{"$f":"IF(O152<>\"\",O152*D142,\"\")","v":""},null,""]
[null,null,null,null,"Total/weighted average:",{"$f":"IF(SUM(F142:F152)>0,SUM(F142:F152),\"\")","v":""},{"$f":"IF(SUM(G142:G152)>0,SUM(G142:G152),\"\")","v":""},"",{"$f":"IF(D142<>\"\",K153/D142,\"\")","v":""},null,{"$f":"IF(D142<>\"\",SUM(K142:K151),\"\")","v":""},{"$f":"IF(D142<>\"\",SUMPRODUCT(F142:F143,L142:L143),\"\")","v":""},null,{"$f":"IF(D142<>\"\",P153/D142,\"\")","v":""},null,{"$f":"IF(D142<>\"\",SUM(P142:P152),\"\")","v":""},null,{"$f":"IF(D142<>\"\",SUM(R142:R152),\"\")","v":""},{"$f":"IF(D142<>\"\",I153+N153,\"\")","v":""}]
[8,{"$f":"IF(OFFSET('General input data'!A$12,A154,0)<>\"\",OFFSET('General input data'!A$12,A154,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!C$12,A154,0)<>\"\",OFFSET('General input data'!C$12,A154,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!E$12,A154,0)<>\"\",OFFSET('General input data'!E$12,A154,0),\"\")","v":""},null,null,{"$f":"IF(F154>0,C$214*F154,\"\")","v":""},{"$f":"IF(F154>0,D$214*F154,\"\")","v":""},null,null,{"$f":"IF(J154<>\"\",-I154*J154*H154,\"\")","v":""},null,null,null,null,{"$f":"IF(O154<>\"\",-N154*O154*H154,\"\")","v":""},null,{"$f":"IF(H154<>\"\",K154+P154,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(F155>0,C$214*F155,\"\")","v":""},{"$f":"IF(F155>0,D$214*F155,\"\")","v":""},null,null,{"$f":"IF(J155<>\"\",-I155*J155*H155,\"\")","v":""},null,null,null,null,{"$f":"IF(O155<>\"\",-N155*O155*H155,\"\")","v":""},null,{"$f":"IF(H155<>\"\",K155+P155,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,{"$f":"IF(J156<>\"\",-I156*J156*H156,\"\")","v":""},null,null,null,null,{"$f":"IF(O156<>\"\",-N156*O156*H156,\"\")","v":""},null,{"$f":"IF(H156<>\"\",K156+P156,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,{"$f":"IF(H157<>\"\",K157+P157,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,{"$f":"IF(F164*$D$58>0,F164*$D$58,\"\")","v":""},null,null,null,null,"Fraction with no first use identified:",null,{"$f":"IF(D154<>\"\",(1-F165),\"\")","v":""},{"$f":"IF(O164<>\"\",O164*D154,\"\")","v":""},null,""]
[null,null,null,null,"Total/weighted average:",{"$f":"IF(SUM(F154:F164)>0,SUM(F154:F164),\"\")","v":""},{"$f":"IF(SUM(G154:G164)>0,SUM(G154:G164),\"\")","v":""},"",{"$f":"IF(D154<>\"\",K165/D154,\"\")","v":""},null,{"$f":"IF(D154<>\"\",SUM(K154:K163),\"\")","v":""},{"$f":"IF(D154<>\"\",SUMPRODUCT(F154:F155,L154:L155),\"\")","v":""},null,{"$f":"IF(D154<>\"\",P165/D154,\"\")","v":""},null,{"$f":"IF(D154<>\"\",SUM(P154:P164),\"\")","v":""},null,{"$f":"IF(D154<>\"\",SUM(R154:R164),\"\")","v":""},{"$f":"IF(D154<>\"\",I165+N165,\"\")","v":""}]
[9,{"$f":"IF(OFFSET('General input data'!A$12,A166,0)<>\"\",OFFSET('General input data'!A$12,A166,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!C$12,A166,0)<>\"\",OFFSET('General input data'!C$12,A166,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!E$12,A166,0)<>\"\",OFFSET('General input data'!E$12,A166,0),\"\")","v":""},null,null,{"$f":"IF(F166>0,C$214*F166,\"\")","v":""},{"$f":"IF(F166>0,D$214*F166,\"\")","v":""},null,null,{"$f":"IF(J166<>\"\",-I166*J166*H166,\"\")","v":""},null,null,null,null,{"$f":"IF(O166<>\"\",-N166*O166*H166,\"\")","v":""},null,{"$f":"IF(H166<>\"\",K166+P166,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(F167>0,C$214*F167,\"\")","v":""},{"$f":"IF(F167>0,D$214*F167,\"\")","v":""},null,null,{"$f":"IF(J167<>\"\",-I167*J167*H167,\"\")","v":""},null,null,null,null,{"$f":"IF(O167<>\"\",-N167*O167*H167,\"\")","v":""},null,{"$f":"IF(H167<>\"\",K167+P167,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,{"$f":"IF(J168<>\"\",-I168*J168*H168,\"\")","v":""},null,null,null,null,{"$f":"IF(O168<>\"\",-N168*O168*H168,\"\")","v":""},null,{"$f":"IF(H168<>\"\",K168+P168,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,{"$f":"IF(H169<>\"\",K169+P169,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,{"$f":"IF(F176*$D$58>0,F176*$D$58,\"\")","v":""},null,null,null,null,"Fraction with no first use identified:",null,{"$f":"IF(D166<>\"\",(1-F177),\"\")","v":""},{"$f":"IF(O176<>\"\",O176*D166,\"\")","v":""},null,""]
[null,null,null,null,"Total/weighted average:",{"$f":"IF(SUM(F166:F176)>0,SUM(F166:F176),\"\")","v":""},{"$f":"IF(SUM(G166:G176)>0,SUM(G166:G176),\"\")","v":""},"",{"$f":"IF(D166<>\"\",K177/D166,\"\")","v":""},null,{"$f":"IF(D166<>\"\",SUM(K166:K175),\"\")","v":""},{"$f":"IF(D166<>\"\",SUMPRODUCT(F166:F167,L166:L167),\"\")","v":""},null,{"$f":"IF(D166<>\"\",P177/D166,\"\")","v":""},null,{"$f":"IF(D166<>\"\",SUM(P166:P176),\"\")","v":""},null,{"$f":"IF(D166<>\"\",SUM(R166:R176),\"\")","v":""},{"$f":"IF(D166<>\"\",I177+N177,\"\")","v":""}]
[10,{"$f":"IF(OFFSET('General input data'!A$12,A178,0)<>\"\",OFFSET('General input data'!A$12,A178,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!C$12,A178,0)<>\"\",OFFSET('General input data'!C$12,A178,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!E$12,A178,0)<>\"\",OFFSET('General input data'!E$12,A178,0),\"\")","v":""},null,null,{"$f":"IF(F178>0,C$178*F178,\"\")","v":""},{"$f":"IF(F178>0,D$178*F178,\"\")","v":""},null,null,{"$f":"IF(J178<>\"\",-I178*J178*H178,\"\")","v":""},null,null,null,null,{"$f":"IF(O178<>\"\",-N178*O178*H178,\"\")","v":""},null,{"$f":"IF(H178<>\"\",K178+P178,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(F179>0,C$178*F179,\"\")","v":""},{"$f":"IF(F179>0,D$178*F179,\"\")","v":""},null,null,{"$f":"IF(J179<>\"\",-I179*J179*H179,\"\")","v":""},null,null,null,null,{"$f":"IF(O179<>\"\",-N179*O179*H179,\"\")","v":""},null,{"$f":"IF(H179<>\"\",K179+P179,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,{"$f":"IF(J180<>\"\",-I180*J180*H180,\"\")","v":""},null,null,null,null,{"$f":"IF(O180<>\"\",-N180*O180*H180,\"\")","v":""},null,{"$f":"IF(H180<>\"\",K180+P180,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,{"$f":"IF(H181<>\"\",K181+P181,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,{"$f":"IF(F188*$D$58>0,F188*$D$58,\"\")","v":""},null,null,null,null,"Fraction with no first use identified:",null,{"$f":"IF(D178<>\"\",(1-F189),\"\")","v":""},{"$f":"IF(O188<>\"\",O188*D178,\"\")","v":""},null,""]
[null,null,null,null,"Total/weighted average:",{"$f":"IF(SUM(F178:F188)>0,SUM(F178:F188),\"\")","v":""},{"$f":"IF(SUM(G178:G188)>0,SUM(G178:G188),\"\")","v":""},"",{"$f":"IF(D178<>\"\",K189/D178,\"\")","v":""},null,{"$f":"IF(D178<>\"\",SUM(K178:K187),\"\")","v":""},{"$f":"IF(D178<>\"\",SUMPRODUCT(F178:F179,L178:L179),\"\")","v":""},null,{"$f":"IF(D178<>\"\",P189/D178,\"\")","v":""},null,{"$f":"IF(D178<>\"\",SUM(P178:P188),\"\")","v":""},null,{"$f":"IF(D178<>\"\",SUM(R178:R188),\"\")","v":""},{"$f":"IF(D178<>\"\",I189+N189,\"\")","v":""}]
[11,{"$f":"IF(OFFSET('General input data'!A$12,A190,0)<>\"\",OFFSET('General input data'!A$12,A190,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!C$12,A190,0)<>\"\",OFFSET('General input data'!C$12,A190,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!E$12,A190,0)<>\"\",OFFSET('General input data'!E$12,A190,0),\"\")","v":""},null,null,{"$f":"IF(F190>0,C$214*F190,\"\")","v":""},{"$f":"IF(F190>0,D$214*F190,\"\")","v":""},null,null,{"$f":"IF(J190<>\"\",-I190*J190*H190,\"\")","v":""},null,null,null,null,{"$f":"IF(O190<>\"\",-N190*O190*H190,\"\")","v":""},null,{"$f":"IF(H190<>\"\",K190+P190,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(F191>0,C$214*F191,\"\")","v":""},{"$f":"IF(F191>0,D$214*F191,\"\")","v":""},null,null,{"$f":"IF(J191<>\"\",-I191*J191*H191,\"\")","v":""},null,null,null,null,{"$f":"IF(O191<>\"\",-N191*O191*H191,\"\")","v":""},null,{"$f":"IF(H191<>\"\",K191+P191,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,{"$f":"IF(J192<>\"\",-I192*J192*H192,\"\")","v":""},null,null,null,null,{"$f":"IF(O192<>\"\",-N192*O192*H192,\"\")","v":""},null,{"$f":"IF(H192<>\"\",K192+P192,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,{"$f":"IF(H193<>\"\",K193+P193,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,{"$f":"IF(F200*$D$58>0,F200*$D$58,\"\")","v":""},null,null,null,null,"Fraction with no first use identified:",null,{"$f":"IF(D190<>\"\",(1-F201),\"\")","v":""},{"$f":"IF(O200<>\"\",O200*D190,\"\")","v":""},null,""]
[null,null,null,null,"Total/weighted average:",{"$f":"IF(SUM(F190:F200)>0,SUM(F190:F200),\"\")","v":""},{"$f":"IF(SUM(G190:G200)>0,SUM(G190:G200),\"\")","v":""},"",{"$f":"IF(D190<>\"\",K201/D190,\"\")","v":""},null,{"$f":"IF(D190<>\"\",SUM(K190:K199),\"\")","v":""},{"$f":"IF(D190<>\"\",SUMPRODUCT(F190:F191,L190:L191),\"\")","v":""},null,{"$f":"IF(D190<>\"\",P201/D190,\"\")","v":""},null,{"$f":"IF(D190<>\"\",SUM(P190:P200),\"\")","v":""},null,{"$f":"IF(D190<>\"\",SUM(R190:R200),\"\")","v":""},{"$f":"IF(D190<>\"\",I201+N201,\"\")","v":""}]
[12,{"$f":"IF(OFFSET('General input data'!A$12,A202,0)<>\"\",OFFSET('General input data'!A$12,A202,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!C$12,A202,0)<>\"\",OFFSET('General input data'!C$12,A202,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!E$12,A202,0)<>\"\",OFFSET('General input data'!E$12,A202,0),\"\")","v":""},null,null,{"$f":"IF(F202>0,C$214*F202,\"\")","v":""},{"$f":"IF(F202>0,D$214*F202,\"\")","v":""},null,null,{"$f":"IF(J202<>\"\",-I202*J202*H202,\"\")","v":""},null,null,null,null,{"$f":"IF(O202<>\"\",-N202*O202*H202,\"\")","v":""},null,{"$f":"IF(H202<>\"\",K202+P202,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(F203>0,C$214*F203,\"\")","v":""},{"$f":"IF(F203>0,D$214*F203,\"\")","v":""},null,null,{"$f":"IF(J203<>\"\",-I203*J203*H203,\"\")","v":""},null,null,null,null,{"$f":"IF(O203<>\"\",-N203*O203*H203,\"\")","v":""},null,{"$f":"IF(H203<>\"\",K203+P203,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,{"$f":"IF(J204<>\"\",-I204*J204*H204,\"\")","v":""},null,null,null,null,{"$f":"IF(O204<>\"\",-N204*O204*H204,\"\")","v":""},null,{"$f":"IF(H204<>\"\",K204+P204,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,{"$f":"IF(H205<>\"\",K205+P205,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,{"$f":"IF(F212*$D$58>0,F212*$D$58,\"\")","v":""},null,null,null,null,"Fraction with no first use identified:",null,{"$f":"IF(D202<>\"\",(1-F213),\"\")","v":""},{"$f":"IF(O212<>\"\",O212*D202,\"\")","v":""},null,""]
[null,null,null,null,"Total/weighted average:",{"$f":"IF(SUM(F202:F212)>0,SUM(F202:F212),\"\")","v":""},{"$f":"IF(SUM(G202:G212)>0,SUM(G202:G212),\"\")","v":""},"",{"$f":"IF(D202<>\"\",K213/D202,\"\")","v":""},null,{"$f":"IF(D202<>\"\",SUM(K202:K211),\"\")","v":""},{"$f":"IF(D202<>\"\",SUMPRODUCT(F202:F203,L202:L203),\"\")","v":""},null,{"$f":"IF(D202<>\"\",P213/D202,\"\")","v":""},null,{"$f":"IF(D202<>\"\",SUM(P202:P212),\"\")","v":""},null,{"$f":"IF(D202<>\"\",SUM(R202:R212),\"\")","v":""},{"$f":"IF(D202<>\"\",I213+N213,\"\")","v":""}]
[13,{"$f":"IF(OFFSET('General input data'!A$12,A214,0)<>\"\",OFFSET('General input data'!A$12,A214,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!C$12,A214,0)<>\"\",OFFSET('General input data'!C$12,A214,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!E$12,A214,0)<>\"\",OFFSET('General input data'!E$12,A214,0),\"\")","v":""},null,null,{"$f":"IF(F214>0,C$214*F214,\"\")","v":""},{"$f":"IF(F214>0,D$214*F214,\"\")","v":""},null,null,{"$f":"IF(J214<>\"\",-I214*J214*H214,\"\")","v":""},null,null,null,null,{"$f":"IF(O214<>\"\",-N214*O214*H214,\"\")","v":""},null,{"$f":"IF(H214<>\"\",K214+P214,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(F215>0,C$214*F215,\"\")","v":""},{"$f":"IF(F215>0,D$214*F215,\"\")","v":""},null,null,{"$f":"IF(J215<>\"\",-I215*J215*H215,\"\")","v":""},null,null,null,null,{"$f":"IF(O215<>\"\",-N215*O215*H215,\"\")","v":""},null,{"$f":"IF(H215<>\"\",K215+P215,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,{"$f":"IF(J216<>\"\",-I216*J216*H216,\"\")","v":""},null,null,null,null,{"$f":"IF(O216<>\"\",-N216*O216*H216,\"\")","v":""},null,{"$f":"IF(H216<>\"\",K216+P216,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,{"$f":"IF(H217<>\"\",K217+P217,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,{"$f":"IF(F224*$D$58>0,F224*$D$58,\"\")","v":""},null,null,null,null,"Fraction with no first use identified:",null,{"$f":"IF(D214<>\"\",(1-F225),\"\")","v":""},{"$f":"IF(O224<>\"\",O224*D214,\"\")","v":""},null,""]
[null,null,null,null,"Total/weighted average:",{"$f":"IF(SUM(F214:F224)>0,SUM(F214:F224),\"\")","v":""},{"$f":"IF(SUM(G214:G224)>0,SUM(G214:G224),\"\")","v":""},"",{"$f":"IF(D214<>\"\",K225/D214,\"\")","v":""},null,{"$f":"IF(D214<>\"\",SUM(K214:K223),\"\")","v":""},{"$f":"IF(D214<>\"\",SUMPRODUCT(F214:F215,L214:L215),\"\")","v":""},null,{"$f":"IF(D214<>\"\",P225/D214,\"\")","v":""},null,{"$f":"IF(D214<>\"\",SUM(P214:P224),\"\")","v":""},null,{"$f":"IF(D214<>\"\",SUM(R214:R224),\"\")","v":""},{"$f":"IF(D214<>\"\",I225+N225,\"\")","v":""}]
[14,{"$f":"IF(OFFSET('General input data'!A$12,A226,0)<>\"\",OFFSET('General input data'!A$12,A226,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!C$12,A226,0)<>\"\",OFFSET('General input data'!C$12,A226,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!E$12,A226,0)<>\"\",OFFSET('General input data'!E$12,A226,0),\"\")","v":""},null,null,{"$f":"IF(F226>0,C$214*F226,\"\")","v":""},{"$f":"IF(F226>0,D$214*F226,\"\")","v":""},null,null,{"$f":"IF(J226<>\"\",-I226*J226*H226,\"\")","v":""},null,null,null,null,{"$f":"IF(O226<>\"\",-N226*O226*H226,\"\")","v":""},null,{"$f":"IF(H226<>\"\",K226+P226,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(F227>0,C$214*F227,\"\")","v":""},{"$f":"IF(F227>0,D$214*F227,\"\")","v":""},null,null,{"$f":"IF(J227<>\"\",-I227*J227*H227,\"\")","v":""},null,null,null,null,{"$f":"IF(O227<>\"\",-N227*O227*H227,\"\")","v":""},null,{"$f":"IF(H227<>\"\",K227+P227,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,{"$f":"IF(J228<>\"\",-I228*J228*H228,\"\")","v":""},null,null,null,null,{"$f":"IF(O228<>\"\",-N228*O228*H228,\"\")","v":""},null,{"$f":"IF(H228<>\"\",K228+P228,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,{"$f":"IF(H229<>\"\",K229+P229,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,{"$f":"IF(F236*$D$58>0,F236*$D$58,\"\")","v":""},null,null,null,null,"Fraction with no first use identified:",null,{"$f":"IF(D226<>\"\",(1-F237),\"\")","v":""},{"$f":"IF(O236<>\"\",O236*D226,\"\")","v":""},null,""]
[null,null,null,null,"Total/weighted average:",{"$f":"IF(SUM(F226:F236)>0,SUM(F226:F236),\"\")","v":""},{"$f":"IF(SUM(G226:G236)>0,SUM(G226:G236),\"\")","v":""},"",{"$f":"IF(D226<>\"\",K237/D226,\"\")","v":""},null,{"$f":"IF(D226<>\"\",SUM(K226:K235),\"\")","v":""},{"$f":"IF(D226<>\"\",SUMPRODUCT(F226:F227,L226:L227),\"\")","v":""},null,{"$f":"IF(D226<>\"\",P237/D226,\"\")","v":""},null,{"$f":"IF(D226<>\"\",SUM(P226:P236),\"\")","v":""},null,{"$f":"IF(D226<>\"\",SUM(R226:R236),\"\")","v":""},{"$f":"IF(D226<>\"\",I237+N237,\"\")","v":""}]
[15,{"$f":"IF(OFFSET('General input data'!A$12,A238,0)<>\"\",OFFSET('General input data'!A$12,A238,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!C$12,A238,0)<>\"\",OFFSET('General input data'!C$12,A238,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!E$12,A238,0)<>\"\",OFFSET('General input data'!E$12,A238,0),\"\")","v":""},null,null,{"$f":"IF(F238>0,C$214*F238,\"\")","v":""},{"$f":"IF(F238>0,D$214*F238,\"\")","v":""},null,null,{"$f":"IF(J238<>\"\",-I238*J238*H238,\"\")","v":""},null,null,null,null,{"$f":"IF(O238<>\"\",-N238*O238*H238,\"\")","v":""},null,{"$f":"IF(H238<>\"\",K238+P238,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(F239>0,C$214*F239,\"\")","v":""},{"$f":"IF(F239>0,D$214*F239,\"\")","v":""},null,null,{"$f":"IF(J239<>\"\",-I239*J239*H239,\"\")","v":""},null,null,null,null,{"$f":"IF(O239<>\"\",-N239*O239*H239,\"\")","v":""},null,{"$f":"IF(H239<>\"\",K239+P239,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,{"$f":"IF(J240<>\"\",-I240*J240*H240,\"\")","v":""},null,null,null,null,{"$f":"IF(O240<>\"\",-N240*O240*H240,\"\")","v":""},null,{"$f":"IF(H240<>\"\",K240+P240,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,{"$f":"IF(H241<>\"\",K241+P241,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,{"$f":"IF(F248*$D$58>0,F248*$D$58,\"\")","v":""},null,null,null,null,"Fraction with no first use identified:",null,{"$f":"IF(D238<>\"\",(1-F249),\"\")","v":""},{"$f":"IF(O248<>\"\",O248*D238,\"\")","v":""},null,""]
[null,null,null,null,"Total/weighted average:",{"$f":"IF(SUM(F238:F248)>0,SUM(F238:F248),\"\")","v":""},{"$f":"IF(SUM(G238:G248)>0,SUM(G238:G248),\"\")","v":""},"",{"$f":"IF(D238<>\"\",K249/D238,\"\")","v":""},null,{"$f":"IF(D238<>\"\",SUM(K238:K247),\"\")","v":""},{"$f":"IF(D238<>\"\",SUMPRODUCT(F238:F239,L238:L239),\"\")","v":""},null,{"$f":"IF(D238<>\"\",P249/D238,\"\")","v":""},null,{"$f":"IF(D238<>\"\",SUM(P238:P248),\"\")","v":""},null,{"$f":"IF(D238<>\"\",SUM(R238:R248),\"\")","v":""},{"$f":"IF(D238<>\"\",I249+N249,\"\")","v":""}]
[16,{"$f":"IF(OFFSET('General input data'!A$12,A250,0)<>\"\",OFFSET('General input data'!A$12,A250,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!C$12,A250,0)<>\"\",OFFSET('General input data'!C$12,A250,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!E$12,A250,0)<>\"\",OFFSET('General input data'!E$12,A250,0),\"\")","v":""},null,null,{"$f":"IF(F250>0,C$214*F250,\"\")","v":""},{"$f":"IF(F250>0,D$214*F250,\"\")","v":""},null,null,{"$f":"IF(J250<>\"\",-I250*J250*H250,\"\")","v":""},null,null,null,null,{"$f":"IF(O250<>\"\",-N250*O250*H250,\"\")","v":""},null,{"$f":"IF(H250<>\"\",K250+P250,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(F251>0,C$214*F251,\"\")","v":""},{"$f":"IF(F251>0,D$214*F251,\"\")","v":""},null,null,{"$f":"IF(J251<>\"\",-I251*J251*H251,\"\")","v":""},null,null,null,null,{"$f":"IF(O251<>\"\",-N251*O251*H251,\"\")","v":""},null,{"$f":"IF(H251<>\"\",K251+P251,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,{"$f":"IF(J252<>\"\",-I252*J252*H252,\"\")","v":""},null,null,null,null,{"$f":"IF(O252<>\"\",-N252*O252*H252,\"\")","v":""},null,{"$f":"IF(H252<>\"\",K252+P252,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,{"$f":"IF(H253<>\"\",K253+P253,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,{"$f":"IF(F260*$D$58>0,F260*$D$58,\"\")","v":""},null,null,null,null,"Fraction with no first use identified:",null,{"$f":"IF(D250<>\"\",(1-F261),\"\")","v":""},{"$f":"IF(O260<>\"\",O260*D250,\"\")","v":""},null,""]
[null,null,null,null,"Total/weighted average:",{"$f":"IF(SUM(F250:F260)>0,SUM(F250:F260),\"\")","v":""},{"$f":"IF(SUM(G250:G260)>0,SUM(G250:G260),\"\")","v":""},"",{"$f":"IF(D250<>\"\",K261/D250,\"\")","v":""},null,{"$f":"IF(D250<>\"\",SUM(K250:K259),\"\")","v":""},{"$f":"IF(D250<>\"\",SUMPRODUCT(F250:F251,L250:L251),\"\")","v":""},null,{"$f":"IF(D250<>\"\",P261/D250,\"\")","v":""},null,{"$f":"IF(D250<>\"\",SUM(P250:P260),\"\")","v":""},null,{"$f":"IF(D250<>\"\",SUM(R250:R260),\"\")","v":""},{"$f":"IF(D250<>\"\",I261+N261,\"\")","v":""}]
[17,{"$f":"IF(OFFSET('General input data'!A$12,A262,0)<>\"\",OFFSET('General input data'!A$12,A262,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!C$12,A262,0)<>\"\",OFFSET('General input data'!C$12,A262,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!E$12,A262,0)<>\"\",OFFSET('General input data'!E$12,A262,0),\"\")","v":""},null,null,{"$f":"IF(F262>0,C$214*F262,\"\")","v":""},{"$f":"IF(F262>0,D$214*F262,\"\")","v":""},null,null,{"$f":"IF(J262<>\"\",-I262*J262*H262,\"\")","v":""},null,null,null,null,{"$f":"IF(O262<>\"\",-N262*O262*H262,\"\")","v":""},null,{"$f":"IF(H262<>\"\",K262+P262,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(F263>0,C$214*F263,\"\")","v":""},{"$f":"IF(F263>0,D$214*F263,\"\")","v":""},null,null,{"$f":"IF(J263<>\"\",-I263*J263*H263,\"\")","v":""},null,null,null,null,{"$f":"IF(O263<>\"\",-N263*O263*H263,\"\")","v":""},null,{"$f":"IF(H263<>\"\",K263+P263,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,{"$f":"IF(J264<>\"\",-I264*J264*H264,\"\")","v":""},null,null,null,null,{"$f":"IF(O264<>\"\",-N264*O264*H264,\"\")","v":""},null,{"$f":"IF(H264<>\"\",K264+P264,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,{"$f":"IF(H265<>\"\",K265+P265,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,{"$f":"IF(F272*$D$58>0,F272*$D$58,\"\")","v":""},null,null,null,null,"Fraction with no first use identified:",null,{"$f":"IF(D262<>\"\",(1-F273),\"\")","v":""},{"$f":"IF(O272<>\"\",O272*D262,\"\")","v":""},null,""]
[null,null,null,null,"Total/weighted average:",{"$f":"IF(SUM(F262:F272)>0,SUM(F262:F272),\"\")","v":""},{"$f":"IF(SUM(G262:G272)>0,SUM(G262:G272),\"\")","v":""},"",{"$f":"IF(D262<>\"\",K273/D262,\"\")","v":""},null,{"$f":"IF(D262<>\"\",SUM(K262:K271),\"\")","v":""},{"$f":"IF(D262<>\"\",SUMPRODUCT(F262:F263,L262:L263),\"\")","v":""},null,{"$f":"IF(D262<>\"\",P273/D262,\"\")","v":""},null,{"$f":"IF(D262<>\"\",SUM(P262:P272),\"\")","v":""},null,{"$f":"IF(D262<>\"\",SUM(R262:R272),\"\")","v":""},{"$f":"IF(D262<>\"\",I273+N273,\"\")","v":""}]
[18,{"$f":"IF(OFFSET('General input data'!A$12,A274,0)<>\"\",OFFSET('General input data'!A$12,A274,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!C$12,A274,0)<>\"\",OFFSET('General input data'!C$12,A274,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!E$12,A274,0)<>\"\",OFFSET('General input data'!E$12,A274,0),\"\")","v":""},null,null,{"$f":"IF(F274>0,C$214*F274,\"\")","v":""},{"$f":"IF(F274>0,D$214*F274,\"\")","v":""},null,null,{"$f":"IF(J274<>\"\",-I274*J274*H274,\"\")","v":""},null,null,null,null,{"$f":"IF(O274<>\"\",-N274*O274*H274,\"\")","v":""},null,{"$f":"IF(H274<>\"\",K274+P274,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(F275>0,C$214*F275,\"\")","v":""},{"$f":"IF(F275>0,D$214*F275,\"\")","v":""},null,null,{"$f":"IF(J275<>\"\",-I275*J275*H275,\"\")","v":""},null,null,null,null,{"$f":"IF(O275<>\"\",-N275*O275*H275,\"\")","v":""},null,{"$f":"IF(H275<>\"\",K275+P275,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,{"$f":"IF(J276<>\"\",-I276*J276*H276,\"\")","v":""},null,null,null,null,{"$f":"IF(O276<>\"\",-N276*O276*H276,\"\")","v":""},null,{"$f":"IF(H276<>\"\",K276+P276,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,{"$f":"IF(H277<>\"\",K277+P277,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,{"$f":"IF(F284*$D$58>0,F284*$D$58,\"\")","v":""},null,null,null,null,"Fraction with no first use identified:",null,{"$f":"IF(D274<>\"\",(1-F285),\"\")","v":""},{"$f":"IF(O284<>\"\",O284*D274,\"\")","v":""},null,""]
[null,null,null,null,"Total/weighted average:",{"$f":"IF(SUM(F274:F284)>0,SUM(F274:F284),\"\")","v":""},{"$f":"IF(SUM(G274:G284)>0,SUM(G274:G284),\"\")","v":""},"",{"$f":"IF(D274<>\"\",K285/D274,\"\")","v":""},null,{"$f":"IF(D274<>\"\",SUM(K274:K283),\"\")","v":""},{"$f":"IF(D274<>\"\",SUMPRODUCT(F274:F275,L274:L275),\"\")","v":""},null,{"$f":"IF(D274<>\"\",P285/D274,\"\")","v":""},null,{"$f":"IF(D274<>\"\",SUM(P274:P284),\"\")","v":""},null,{"$f":"IF(D274<>\"\",SUM(R274:R284),\"\")","v":""},{"$f":"IF(D274<>\"\",I285+N285,\"\")","v":""}]
[19,{"$f":"IF(OFFSET('General input data'!A$12,A286,0)<>\"\",OFFSET('General input data'!A$12,A286,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!C$12,A286,0)<>\"\",OFFSET('General input data'!C$12,A286,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!E$12,A286,0)<>\"\",OFFSET('General input data'!E$12,A286,0),\"\")","v":""},null,null,{"$f":"IF(F286>0,C$214*F286,\"\")","v":""},{"$f":"IF(F286>0,D$214*F286,\"\")","v":""},null,null,{"$f":"IF(J286<>\"\",-I286*J286*H286,\"\")","v":""},null,null,null,null,{"$f":"IF(O286<>\"\",-N286*O286*H286,\"\")","v":""},null,{"$f":"IF(H286<>\"\",K286+P286,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(F287>0,C$214*F287,\"\")","v":""},{"$f":"IF(F287>0,D$214*F287,\"\")","v":""},null,null,{"$f":"IF(J287<>\"\",-I287*J287*H287,\"\")","v":""},null,null,null,null,{"$f":"IF(O287<>\"\",-N287*O287*H287,\"\")","v":""},null,{"$f":"IF(H287<>\"\",K287+P287,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,{"$f":"IF(J288<>\"\",-I288*J288*H288,\"\")","v":""},null,null,null,null,{"$f":"IF(O288<>\"\",-N288*O288*H288,\"\")","v":""},null,{"$f":"IF(H288<>\"\",K288+P288,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,{"$f":"IF(H289<>\"\",K289+P289,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,{"$f":"IF(F296*$D$58>0,F296*$D$58,\"\")","v":""},null,null,null,null,"Fraction with no first use identified:",null,{"$f":"IF(D286<>\"\",(1-F297),\"\")","v":""},{"$f":"IF(O296<>\"\",O296*D286,\"\")","v":""},null,""]
[null,null,null,null,"Total/weighted average:",{"$f":"IF(SUM(F286:F296)>0,SUM(F286:F296),\"\")","v":""},{"$f":"IF(SUM(G286:G296)>0,SUM(G286:G296),\"\")","v":""},"",{"$f":"IF(D286<>\"\",K297/D286,\"\")","v":""},null,{"$f":"IF(D286<>\"\",SUM(K286:K295),\"\")","v":""},{"$f":"IF(D286<>\"\",SUMPRODUCT(F286:F287,L286:L287),\"\")","v":""},null,{"$f":"IF(D286<>\"\",P297/D286,\"\")","v":""},null,{"$f":"IF(D286<>\"\",SUM(P286:P296),\"\")","v":""},null,{"$f":"IF(D286<>\"\",SUM(R286:R296),\"\")","v":""},{"$f":"IF(D286<>\"\",I297+N297,\"\")","v":""}]
[20,{"$f":"IF(OFFSET('General input data'!A$12,A298,0)<>\"\",OFFSET('General input data'!A$12,A298,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!C$12,A298,0)<>\"\",OFFSET('General input data'!C$12,A298,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!E$12,A298,0)<>\"\",OFFSET('General input data'!E$12,A298,0),\"\")","v":""},null,null,{"$f":"IF(F298>0,C$214*F298,\"\")","v":""},{"$f":"IF(F298>0,D$214*F298,\"\")","v":""},null,null,{"$f":"IF(J298<>\"\",-I298*J298*H298,\"\")","v":""},null,null,null,null,{"$f":"IF(O298<>\"\",-N298*O298*H298,\"\")","v":""},null,{"$f":"IF(H298<>\"\",K298+P298,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(F299>0,C$214*F299,\"\")","v":""},{"$f":"IF(F299>0,D$214*F299,\"\")","v":""},null,null,{"$f":"IF(J299<>\"\",-I299*J299*H299,\"\")","v":""},null,null,null,null,{"$f":"IF(O299<>\"\",-N299*O299*H299,\"\")","v":""},null,{"$f":"IF(H299<>\"\",K299+P299,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,{"$f":"IF(J300<>\"\",-I300*J300*H300,\"\")","v":""},null,null,null,null,{"$f":"IF(O300<>\"\",-N300*O300*H300,\"\")","v":""},null,{"$f":"IF(H300<>\"\",K300+P300,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,{"$f":"IF(H301<>\"\",K301+P301,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,{"$f":"IF(F308*$D$58>0,F308*$D$58,\"\")","v":""},null,null,null,null,"Fraction with no first use identified:",null,{"$f":"IF(D298<>\"\",(1-F309),\"\")","v":""},{"$f":"IF(O308<>\"\",O308*D298,\"\")","v":""},null,""]
[null,null,null,null,"Total/weighted average:",{"$f":"IF(SUM(F298:F308)>0,SUM(F298:F308),\"\")","v":""},{"$f":"IF(SUM(G298:G308)>0,SUM(G298:G308),\"\")","v":""},"",{"$f":"IF(D298<>\"\",K309/D298,\"\")","v":""},null,{"$f":"IF(D298<>\"\",SUM(K298:K307),\"\")","v":""},{"$f":"IF(D298<>\"\",SUMPRODUCT(F298:F299,L298:L299),\"\")","v":""},null,{"$f":"IF(D298<>\"\",P309/D298,\"\")","v":""},null,{"$f":"IF(D298<>\"\",SUM(P298:P308),\"\")","v":""},null,{"$f":"IF(D298<>\"\",SUM(R298:R308),\"\")","v":""},{"$f":"IF(D298<>\"\",I309+N309,\"\")","v":""}]
[21,{"$f":"IF(OFFSET('General input data'!A$12,A310,0)<>\"\",OFFSET('General input data'!A$12,A310,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!C$12,A310,0)<>\"\",OFFSET('General input data'!C$12,A310,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!E$12,A310,0)<>\"\",OFFSET('General input data'!E$12,A310,0),\"\")","v":""},null,null,{"$f":"IF(F310>0,C$214*F310,\"\")","v":""},{"$f":"IF(F310>0,D$214*F310,\"\")","v":""},null,null,{"$f":"IF(J310<>\"\",-I310*J310*H310,\"\")","v":""},null,null,null,null,{"$f":"IF(O310<>\"\",-N310*O310*H310,\"\")","v":""},null,{"$f":"IF(H310<>\"\",K310+P310,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(F311>0,C$214*F311,\"\")","v":""},{"$f":"IF(F311>0,D$214*F311,\"\")","v":""},null,null,{"$f":"IF(J311<>\"\",-I311*J311*H311,\"\")","v":""},null,null,null,null,{"$f":"IF(O311<>\"\",-N311*O311*H311,\"\")","v":""},null,{"$f":"IF(H311<>\"\",K311+P311,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,{"$f":"IF(J312<>\"\",-I312*J312*H312,\"\")","v":""},null,null,null,null,{"$f":"IF(O312<>\"\",-N312*O312*H312,\"\")","v":""},null,{"$f":"IF(H312<>\"\",K312+P312,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,{"$f":"IF(H313<>\"\",K313+P313,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,{"$f":"IF(F320*$D$58>0,F320*$D$58,\"\")","v":""},null,null,null,null,"Fraction with no first use identified:",null,{"$f":"IF(D310<>\"\",(1-F321),\"\")","v":""},{"$f":"IF(O320<>\"\",O320*D310,\"\")","v":""},null,""]
[null,null,null,null,"Total/weighted average:",{"$f":"IF(SUM(F310:F320)>0,SUM(F310:F320),\"\")","v":""},{"$f":"IF(SUM(G310:G320)>0,SUM(G310:G320),\"\")","v":""},"",{"$f":"IF(D310<>\"\",K321/D310,\"\")","v":""},null,{"$f":"IF(D310<>\"\",SUM(K310:K319),\"\")","v":""},{"$f":"IF(D310<>\"\",SUMPRODUCT(F310:F311,L310:L311),\"\")","v":""},null,{"$f":"IF(D310<>\"\",P321/D310,\"\")","v":""},null,{"$f":"IF(D310<>\"\",SUM(P310:P320),\"\")","v":""},null,{"$f":"IF(D310<>\"\",SUM(R310:R320),\"\")","v":""},{"$f":"IF(D310<>\"\",I321+N321,\"\")","v":""}]
[22,{"$f":"IF(OFFSET('General input data'!A$12,A322,0)<>\"\",OFFSET('General input data'!A$12,A322,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!C$12,A322,0)<>\"\",OFFSET('General input data'!C$12,A322,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!E$12,A322,0)<>\"\",OFFSET('General input data'!E$12,A322,0),\"\")","v":""},null,null,{"$f":"IF(F322>0,C$214*F322,\"\")","v":""},{"$f":"IF(F322>0,D$214*F322,\"\")","v":""},null,null,{"$f":"IF(J322<>\"\",-I322*J322*H322,\"\")","v":""},null,null,null,null,{"$f":"IF(O322<>\"\",-N322*O322*H322,\"\")","v":""},null,{"$f":"IF(H322<>\"\",K322+P322,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(F323>0,C$214*F323,\"\")","v":""},{"$f":"IF(F323>0,D$214*F323,\"\")","v":""},null,null,{"$f":"IF(J323<>\"\",-I323*J323*H323,\"\")","v":""},null,null,null,null,{"$f":"IF(O323<>\"\",-N323*O323*H323,\"\")","v":""},null,{"$f":"IF(H323<>\"\",K323+P323,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,{"$f":"IF(J324<>\"\",-I324*J324*H324,\"\")","v":""},null,null,null,null,{"$f":"IF(O324<>\"\",-N324*O324*H324,\"\")","v":""},null,{"$f":"IF(H324<>\"\",K324+P324,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,{"$f":"IF(H325<>\"\",K325+P325,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,{"$f":"IF(F332*$D$58>0,F332*$D$58,\"\")","v":""},null,null,null,null,"Fraction with no first use identified:",null,{"$f":"IF(D322<>\"\",(1-F333),\"\")","v":""},{"$f":"IF(O332<>\"\",O332*D322,\"\")","v":""},null,""]
[null,null,null,null,"Total/weighted average:",{"$f":"IF(SUM(F322:F332)>0,SUM(F322:F332),\"\")","v":""},{"$f":"IF(SUM(G322:G332)>0,SUM(G322:G332),\"\")","v":""},"",{"$f":"IF(D322<>\"\",K333/D322,\"\")","v":""},null,{"$f":"IF(D322<>\"\",SUM(K322:K331),\"\")","v":""},{"$f":"IF(D322<>\"\",SUMPRODUCT(F322:F323,L322:L323),\"\")","v":""},null,{"$f":"IF(D322<>\"\",P333/D322,\"\")","v":""},null,{"$f":"IF(D322<>\"\",SUM(P322:P332),\"\")","v":""},null,{"$f":"IF(D322<>\"\",SUM(R322:R332),\"\")","v":""},{"$f":"IF(D322<>\"\",I333+N333,\"\")","v":""}]
[23,{"$f":"IF(OFFSET('General input data'!A$12,A334,0)<>\"\",OFFSET('General input data'!A$12,A334,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!C$12,A334,0)<>\"\",OFFSET('General input data'!C$12,A334,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!E$12,A334,0)<>\"\",OFFSET('General input data'!E$12,A334,0),\"\")","v":""},null,null,{"$f":"IF(F334>0,C$214*F334,\"\")","v":""},{"$f":"IF(F334>0,D$214*F334,\"\")","v":""},null,null,{"$f":"IF(J334<>\"\",-I334*J334*H334,\"\")","v":""},null,null,null,null,{"$f":"IF(O334<>\"\",-N334*O334*H334,\"\")","v":""},null,{"$f":"IF(H334<>\"\",K334+P334,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(F335>0,C$214*F335,\"\")","v":""},{"$f":"IF(F335>0,D$214*F335,\"\")","v":""},null,null,{"$f":"IF(J335<>\"\",-I335*J335*H335,\"\")","v":""},null,null,null,null,{"$f":"IF(O335<>\"\",-N335*O335*H335,\"\")","v":""},null,{"$f":"IF(H335<>\"\",K335+P335,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,{"$f":"IF(J336<>\"\",-I336*J336*H336,\"\")","v":""},null,null,null,null,{"$f":"IF(O336<>\"\",-N336*O336*H336,\"\")","v":""},null,{"$f":"IF(H336<>\"\",K336+P336,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,{"$f":"IF(H337<>\"\",K337+P337,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,{"$f":"IF(F344*$D$58>0,F344*$D$58,\"\")","v":""},null,null,null,null,"Fraction with no first use identified:",null,{"$f":"IF(D334<>\"\",(1-F345),\"\")","v":""},{"$f":"IF(O344<>\"\",O344*D334,\"\")","v":""},null,""]
[null,null,null,null,"Total/weighted average:",{"$f":"IF(SUM(F334:F344)>0,SUM(F334:F344),\"\")","v":""},{"$f":"IF(SUM(G334:G344)>0,SUM(G334:G344),\"\")","v":""},"",{"$f":"IF(D334<>\"\",K345/D334,\"\")","v":""},null,{"$f":"IF(D334<>\"\",SUM(K334:K343),\"\")","v":""},{"$f":"IF(D334<>\"\",SUMPRODUCT(F334:F335,L334:L335),\"\")","v":""},null,{"$f":"IF(D334<>\"\",P345/D334,\"\")","v":""},null,{"$f":"IF(D334<>\"\",SUM(P334:P344),\"\")","v":""},null,{"$f":"IF(D334<>\"\",SUM(R334:R344),\"\")","v":""},{"$f":"IF(D334<>\"\",I345+N345,\"\")","v":""}]
[24,{"$f":"IF(OFFSET('General input data'!A$12,A346,0)<>\"\",OFFSET('General input data'!A$12,A346,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!C$12,A346,0)<>\"\",OFFSET('General input data'!C$12,A346,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!E$12,A346,0)<>\"\",OFFSET('General input data'!E$12,A346,0),\"\")","v":""},null,null,{"$f":"IF(F346>0,C$214*F346,\"\")","v":""},{"$f":"IF(F346>0,D$214*F346,\"\")","v":""},null,null,{"$f":"IF(J346<>\"\",-I346*J346*H346,\"\")","v":""},null,null,null,null,{"$f":"IF(O346<>\"\",-N346*O346*H346,\"\")","v":""},null,{"$f":"IF(H346<>\"\",K346+P346,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(F347>0,C$214*F347,\"\")","v":""},{"$f":"IF(F347>0,D$214*F347,\"\")","v":""},null,null,{"$f":"IF(J347<>\"\",-I347*J347*H347,\"\")","v":""},null,null,null,null,{"$f":"IF(O347<>\"\",-N347*O347*H347,\"\")","v":""},null,{"$f":"IF(H347<>\"\",K347+P347,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,{"$f":"IF(J348<>\"\",-I348*J348*H348,\"\")","v":""},null,null,null,null,{"$f":"IF(O348<>\"\",-N348*O348*H348,\"\")","v":""},null,{"$f":"IF(H348<>\"\",K348+P348,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,{"$f":"IF(H349<>\"\",K349+P349,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,{"$f":"IF(F356*$D$58>0,F356*$D$58,\"\")","v":""},null,null,null,null,"Fraction with no first use identified:",null,{"$f":"IF(D346<>\"\",(1-F357),\"\")","v":""},{"$f":"IF(O356<>\"\",O356*D346,\"\")","v":""},null,""]
[null,null,null,null,"Total/weighted average:",{"$f":"IF(SUM(F346:F356)>0,SUM(F346:F356),\"\")","v":""},{"$f":"IF(SUM(G346:G356)>0,SUM(G346:G356),\"\")","v":""},"",{"$f":"IF(D346<>\"\",K357/D346,\"\")","v":""},null,{"$f":"IF(D346<>\"\",SUM(K346:K355),\"\")","v":""},{"$f":"IF(D346<>\"\",SUMPRODUCT(F346:F347,L346:L347),\"\")","v":""},null,{"$f":"IF(D346<>\"\",P357/D346,\"\")","v":""},null,{"$f":"IF(D346<>\"\",SUM(P346:P356),\"\")","v":""},null,{"$f":"IF(D346<>\"\",SUM(R346:R356),\"\")","v":""},{"$f":"IF(D346<>\"\",I357+N357,\"\")","v":""}]
[25,{"$f":"IF(OFFSET('General input data'!A$12,A358,0)<>\"\",OFFSET('General input data'!A$12,A358,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!C$12,A358,0)<>\"\",OFFSET('General input data'!C$12,A358,0),\"\")","v":""},{"$f":"IF(OFFSET('General input data'!E$12,A358,0)<>\"\",OFFSET('General input data'!E$12,A358,0),\"\")","v":""},null,null,{"$f":"IF(F358>0,C$214*F358,\"\")","v":""},{"$f":"IF(F358>0,D$214*F358,\"\")","v":""},null,null,{"$f":"IF(J358<>\"\",-I358*J358*H358,\"\")","v":""},null,null,null,null,{"$f":"IF(O358<>\"\",-N358*O358*H358,\"\")","v":""},null,{"$f":"IF(H358<>\"\",K358+P358,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(F359>0,C$214*F359,\"\")","v":""},{"$f":"IF(F359>0,D$214*F359,\"\")","v":""},null,null,{"$f":"IF(J359<>\"\",-I359*J359*H359,\"\")","v":""},null,null,null,null,{"$f":"IF(O359<>\"\",-N359*O359*H359,\"\")","v":""},null,{"$f":"IF(H359<>\"\",K359+P359,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,{"$f":"IF(J360<>\"\",-I360*J360*H360,\"\")","v":""},null,null,null,null,{"$f":"IF(O360<>\"\",-N360*O360*H360,\"\")","v":""},null,{"$f":"IF(H360<>\"\",K360+P360,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,{"$f":"IF(H361<>\"\",K361+P361,\"\")","v":""}]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,"","",null,null,"",null,null,null,null,"",null,""]
[null,null,null,null,null,null,null,{"$f":"IF(F368*$D$58>0,F368*$D$58,\"\")","v":""},null,null,null,null,"Fraction with no first use identified:",null,{"$f":"IF(D358<>\"\",(1-F369),\"\")","v":""},{"$f":"IF(O368<>\"\",O368*D358,\"\")","v":""},null,""]
[null,null,null,null,"Total/weighted average:",{"$f":"IF(SUM(F358:F368)>0,SUM(F358:F368),\"\")","v":""},{"$f":"IF(SUM(G358:G368)>0,SUM(G358:G368),\"\")","v":""},"",{"$f":"IF(D358<>\"\",K369/D358,\"\")","v":""},null,{"$f":"IF(D358<>\"\",SUM(K358:K367),\"\")","v":""},{"$f":"IF(D358<>\"\",SUMPRODUCT(F358:F359,L358:L359),\"\")","v":""},null,{"$f":"IF(D358<>\"\",P369/D358,\"\")","v":""},null,{"$f":"IF(D358<>\"\",SUM(P358:P368),\"\")","v":""},null,{"$f":"IF(D358<>\"\",SUM(R358:R368),\"\")","v":""},{"$f":"IF(D358<>\"\",I369+N369,\"\")","v":""}]

{"sheet":"3 Forest","index":5,"n_rows":48,"n_cols":8,"rows_kept":48,"cut":false,"hidden":false,"merged":[[15,0,15,2],[16,0,16,2],[20,7,21,7],[20,4,21,4],[0,0,0,7],[20,0,22,0],[20,1,22,1],[20,6,21,6],[20,2,20,3],[20,5,21,5],[9,4,9,7],[11,4,11,7],[12,4,12,7],[10,4,10,7],[3,0,3,2],[4,0,4,2],[5,0,5,2],[7,0,7,2]]}
["Component 3: Change of carbon stored in forest"]
[]
["Forest carbon balance is assessed for Forest Management Unit(s) defined by the corporation"]
["Depending on data availability and complexity, the corporation may define one or several FMUs"]
["All forest area owned by the corporation should be included. Forest areas not owned by the corporation, but where wood is sourced may be included."]
["When data are insufficient, but other documentation of long-term forest management is available (eg certification, legislation, national trends), the change in forest carbon for a FMU may be set to 0"]
[]
["Assessment of an FMU should address each carbon pool defined by IPCC Guidelines for GHG inventories, ie"]
["Living biomass",null,null,null,"Colour coding:"]
["Dead biomass",null,null,null,"Cells where data are entered manually"]
["Litter",null,null,null,"Cells where data is copied/calculated based on  other cells - NO manual input to be made in these cells"]
["Organic soils",null,null,null,"Cells where constants / conversion factors are provided "]
["Mineral soils",null,null,null,"Cells with no data"]
[]
["A range of different methodological options exist and no specific guidelines are provided here."]
["For carbon change assessments where the total stock is not known, an arbitrary t0 stock shall be used (eg for soil carbon)"]
["For clarity, carbon pools for a FMU may be split on several lines"]
[]
[]
[{"$f":"'General input data'!A9","v":"Time period XXX"}]
["Forest Management Unit","Owner","Area",null,"Carbon stock t0","Carbon stock t1","Assessed change in forest carbon stock","Carbon stock  per hectare at t1"]
[null,null,"Total forest","Proportion attributed to this assessment"]
[null,null,"ha","0..1","tCO2e","tCO2e","tCO2e","tCO2e/ha"]
["All my forest",null,100,1,300,330,{"$f":"IF(E24<\"\",-(F24-E24),\"\")","v":-30},{"$f":"IF(F24<\"\",F24/C24,\"\")","v":3.3}]
[null,null,null,null,null,null,{"$f":"IF(E25<\"\",-(F25-E25),\"\")","v":""},{"$f":"IF(F25<\"\",F25/C25,\"\")","v":""}]
[null,null,null,null,null,null,"",{"$f":"IF(F26<\"\",F26/C26,\"\")","v":""}]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
[null,null,null,null,null,null,"",""]
["TOTALS",null,{"$f":"SUM(C24:C27)","v":100},null,null,null,{"$f":"SUM(G24:G47)","v":-30},"n.appl."]

{"sheet":"4 Wood-based products","index":6,"n_rows":42,"n_cols":16,"rows_kept":42,"cut":false,"hidden":false,"merged":[[9,0,9,4],[10,0,10,4],[4,0,4,4],[5,0,5,4],[6,0,6,4],[7,0,7,4],[8,0,8,4],[0,0,0,6],[14,2,14,4],[14,0,16,0],[14,1,16,1],[25,12,25,15],[8,8,8,10],[24,8,24,15],[14,6,15,6],[14,5,15,5],[2,8,2,11],[4,8,4,11],[5,8,5,11],[3,8,3,11],[25,11,26,11],[2,0,2,4],[3,0,3,4]]}
["Component 4: Change of carbon stored in wood-based products"]
[null,null,null,null,null,null,null,null,"Colour coding:"]
["The carbon storage in wood-based products is assessed as the net increase of storage in the specified time period",null,null,null,null,null,null,null,"Cells where data are entered manually"]
["This corresponds to the national-level reporting of Harvested Wood Products (HWP) under the LULUCF methodology",null,null,null,null,null,null,null,"Cells where data is copied/calculated based on  other cells - NO manual input to be made in these cells"]
["The basic logic is that the net increase of wood-based material in existing products is reported",null,null,null,null,null,null,null,"Cells where constants / conversion factors are provided "]
["This is the difference between inflow of products (ie the marketed products by the corporation) and the outflow of corresponding products from the pool during the same period",null,null,null,null,null,null,null,"Cells with no data"]
["The outflow is estimated based on half-lives for different product categories and including recycling rates - following the IPCC methodology for national reporting."]
["A HWP Coefficient is assigned to each product category, that representes the proportion of the inflow that results in a net increase of the pool."]
["The HWP Coefficient is the only additional data required on this sheet",null,null,null,null,null,null,null,"Tier 1 HWP Coefficients"]
["A range of Tier 1 HWP Coefficients are provided to the right.",null,null,null,null,null,null,null,"Product category /Commodity class","HWP Coefficient","Notes"]
["Alternatively, the user may assign other, custom, HWP Coefficients, altough this is either a judgement call or the result of complex analyses.",null,null,null,null,null,null,null,"Sawn wood",0.3,"Assumes 35 years halftime"]
[null,null,null,null,null,null,null,null,"Wood-based panels",0.2,"Assumes 25 years halftime"]
[null,null,null,null,null,null,null,null,"Fibre / Paper",0.05,"Assumes 2 years halftime and a recycling rate of 30%"]
[{"$f":"'General input data'!A9","v":"Time period XXX"},null,null,null,null,null,null,null,"Wood-based energy",0,"Wood-based energy are assumed to instantly oxidize"]
["Product category","Product use","Marketed volumes",null,null,"HWP Coefficient","Assessed HWP carbon storage contribution",null,"Roundwood under bark",0.1,"Assumes 25% of volume resulting in sawnwood products or panels and 25% of volume resulting in fibre/paper product and 50% for wood-based energy products or no products which arenot leading to carbon storage"]
[null,null,"quantity","unit of measure","in tCO2e"]
[null,null,null,null,null,"tCO2e/tCO2e","tCO2e",null,"Alternative Tier 1 HWP Coefficient for fibre/paper products depending on knowledge of recycling rate"]
[{"$f":"IF('General input data'!A12<>\"\",'General input data'!A12,\"\")","v":"Product category 1"},{"$f":"IF('General input data'!B12<>\"\",'General input data'!B12,\"\")","v":""},{"$f":"IF('General input data'!C12<>\"\",'General input data'!C12,\"\")","v":100},{"$f":"IF('General input data'!D12<>\"\",'General input data'!D12,\"\")","v":""},{"$f":"IF('General input data'!E12<>\"\",'General input data'!E12,\"\")","v":100},0.2,{"$f":"IF(E18<>\"\",-E18*F18,\"\")","v":-20},null,"Recycling rate","HWP Coefficient"]
[{"$f":"IF('General input data'!A13<>\"\",'General input data'!A13,\"\")","v":"Product category 2"},{"$f":"IF('General input data'!B13<>\"\",'General input data'!B13,\"\")","v":""},{"$f":"IF('General input data'!C13<>\"\",'General input data'!C13,\"\")","v":100},{"$f":"IF('General input data'!D13<>\"\",'General input data'!D13,\"\")","v":""},{"$f":"IF('General input data'!E13<>\"\",'General input data'!E13,\"\")","v":100},0.1,{"$f":"IF(E19<>\"\",-E19*F19,\"\")","v":-10},null,0,0.03]
[{"$f":"IF('General input data'!A14<>\"\",'General input data'!A14,\"\")","v":""},{"$f":"IF('General input data'!B14<>\"\",'General input data'!B14,\"\")","v":""},{"$f":"IF('General input data'!C14<>\"\",'General input data'!C14,\"\")","v":""},{"$f":"IF('General input data'!D14<>\"\",'General input data'!D14,\"\")","v":""},{"$f":"IF('General input data'!E14<>\"\",'General input data'!E14,\"\")","v":""},null,"",null,"30% (as above)",0.05]
[{"$f":"IF('General input data'!A15<>\"\",'General input data'!A15,\"\")","v":""},{"$f":"IF('General input data'!B15<>\"\",'General input data'!B15,\"\")","v":""},{"$f":"IF('General input data'!C15<>\"\",'General input data'!C15,\"\")","v":""},{"$f":"IF('General input data'!D15<>\"\",'General input data'!D15,\"\")","v":""},{"$f":"IF('General input data'!E15<>\"\",'General input data'!E15,\"\")","v":""},null,"",null,0.5,0.06]
[{"$f":"IF('General input data'!A16<>\"\",'General input data'!A16,\"\")","v":""},{"$f":"IF('General input data'!B16<>\"\",'General input data'!B16,\"\")","v":""},{"$f":"IF('General input data'!C16<>\"\",'General input data'!C16,\"\")","v":""},{"$f":"IF('General input data'!D16<>\"\",'General input data'!D16,\"\")","v":""},{"$f":"IF('General input data'!E16<>\"\",'General input data'!E16,\"\")","v":""},null,"",null,0.7,0.1]
[{"$f":"IF('General input data'!A17<>\"\",'General input data'!A17,\"\")","v":""},{"$f":"IF('General input data'!B17<>\"\",'General input data'!B17,\"\")","v":""},{"$f":"IF('General input data'!C17<>\"\",'General input data'!C17,\"\")","v":""},{"$f":"IF('General input data'!D17<>\"\",'General input data'!D17,\"\")","v":""},{"$f":"IF('General input data'!E17<>\"\",'General input data'!E17,\"\")","v":""},null,"",null,0.9,0.25]
[{"$f":"IF('General input data'!A18<>\"\",'General input data'!A18,\"\")","v":""},{"$f":"IF('General input data'!B18<>\"\",'General input data'!B18,\"\")","v":""},{"$f":"IF('General input data'!C18<>\"\",'General input data'!C18,\"\")","v":""},{"$f":"IF('General input data'!D18<>\"\",'General input data'!D18,\"\")","v":""},{"$f":"IF('General input data'!E18<>\"\",'General input data'!E18,\"\")","v":""},null,""]
[{"$f":"IF('General input data'!A19<>\"\",'General input data'!A19,\"\")","v":""},{"$f":"IF('General input data'!B19<>\"\",'General input data'!B19,\"\")","v":""},{"$f":"IF('General input data'!C19<>\"\",'General input data'!C19,\"\")","v":""},{"$f":"IF('General input data'!D19<>\"\",'General input data'!D19,\"\")","v":""},{"$f":"IF('General input data'!E19<>\"\",'General input data'!E19,\"\")","v":""},null,"",null,"Alternative Tier 1 HWP Coefficients for roundwood when additional information is available (HWP Coefficient = a+b)"]
[{"$f":"IF('General input data'!A20<>\"\",'General input data'!A20,\"\")","v":""},{"$f":"IF('General input data'!B20<>\"\",'General input data'!B20,\"\")","v":""},{"$f":"IF('General input data'!C20<>\"\",'General input data'!C20,\"\")","v":""},{"$f":"IF('General input data'!D20<>\"\",'General input data'!D20,\"\")","v":""},{"$f":"IF('General input data'!E20<>\"\",'General input data'!E20,\"\")","v":""},null,"",null,"(a) Fraction of roundwood resulting in sawnwood and wood based panels.","Contribution to roundwood HWP Coefficient",null,"(b) Fraction of roundwood resulting in fibre/paper products:","Contribution to roundwood HWP Coefficient by recycling rate"]
[{"$f":"IF('General input data'!A21<>\"\",'General input data'!A21,\"\")","v":""},{"$f":"IF('General input data'!B21<>\"\",'General input data'!B21,\"\")","v":""},{"$f":"IF('General input data'!C21<>\"\",'General input data'!C21,\"\")","v":""},{"$f":"IF('General input data'!D21<>\"\",'General input data'!D21,\"\")","v":""},{"$f":"IF('General input data'!E21<>\"\",'General input data'!E21,\"\")","v":""},null,"",null,0.2,7.0000000000000007E-2,null,null,"No recycling","Recycling: 30%","Recycling: 50%","Recycling: 70%"]
[{"$f":"IF('General input data'!A22<>\"\",'General input data'!A22,\"\")","v":""},{"$f":"IF('General input data'!B22<>\"\",'General input data'!B22,\"\")","v":""},{"$f":"IF('General input data'!C22<>\"\",'General input data'!C22,\"\")","v":""},{"$f":"IF('General input data'!D22<>\"\",'General input data'!D22,\"\")","v":""},{"$f":"IF('General input data'!E22<>\"\",'General input data'!E22,\"\")","v":""},null,"",null,"25% (as above)",0.09,null,0,0,"n.appl","n.appl","n.appl"]
[{"$f":"IF('General input data'!A23<>\"\",'General input data'!A23,\"\")","v":""},{"$f":"IF('General input data'!B23<>\"\",'General input data'!B23,\"\")","v":""},{"$f":"IF('General input data'!C23<>\"\",'General input data'!C23,\"\")","v":""},{"$f":"IF('General input data'!D23<>\"\",'General input data'!D23,\"\")","v":""},{"$f":"IF('General input data'!E23<>\"\",'General input data'!E23,\"\")","v":""},null,"",null,0.3,0.11,null,0.1,-4.0000000000000001E-3,-5.0000000000000001E-3,-7.0000000000000001E-3,-0.01]
[{"$f":"IF('General input data'!A24<>\"\",'General input data'!A24,\"\")","v":""},{"$f":"IF('General input data'!B24<>\"\",'General input data'!B24,\"\")","v":""},{"$f":"IF('General input data'!C24<>\"\",'General input data'!C24,\"\")","v":""},{"$f":"IF('General input data'!D24<>\"\",'General input data'!D24,\"\")","v":""},{"$f":"IF('General input data'!E24<>\"\",'General input data'!E24,\"\")","v":""},null,"",null,0.4,0.14000000000000001,null,0.2,-5.0000000000000001E-3,-8.0000000000000002E-3,-1.2999999999999999E-2,-2.1000000000000001E-2]
[{"$f":"IF('General input data'!A25<>\"\",'General input data'!A25,\"\")","v":""},{"$f":"IF('General input data'!B25<>\"\",'General input data'!B25,\"\")","v":""},{"$f":"IF('General input data'!C25<>\"\",'General input data'!C25,\"\")","v":""},{"$f":"IF('General input data'!D25<>\"\",'General input data'!D25,\"\")","v":""},{"$f":"IF('General input data'!E25<>\"\",'General input data'!E25,\"\")","v":""},null,"",null,0.5,0.18,null,"25% (as above)",-6.0000000000000001E-3,-0.01,-1.4E-2,-2.4E-2]
[{"$f":"IF('General input data'!A26<>\"\",'General input data'!A26,\"\")","v":""},{"$f":"IF('General input data'!B26<>\"\",'General input data'!B26,\"\")","v":""},{"$f":"IF('General input data'!C26<>\"\",'General input data'!C26,\"\")","v":""},{"$f":"IF('General input data'!D26<>\"\",'General input data'!D26,\"\")","v":""},{"$f":"IF('General input data'!E26<>\"\",'General input data'!E26,\"\")","v":""},null,"",null,0.7,0.25,null,0.3,-7.0000000000000001E-3,-0.02,-2.5000000000000001E-2,-3.6999999999999998E-2]
[{"$f":"IF('General input data'!A27<>\"\",'General input data'!A27,\"\")","v":""},{"$f":"IF('General input data'!B27<>\"\",'General input data'!B27,\"\")","v":""},{"$f":"IF('General input data'!C27<>\"\",'General input data'!C27,\"\")","v":""},{"$f":"IF('General input data'!D27<>\"\",'General input data'!D27,\"\")","v":""},{"$f":"IF('General input data'!E27<>\"\",'General input data'!E27,\"\")","v":""},null,"",null,0.9,0.32]
[{"$f":"IF('General input data'!A28<>\"\",'General input data'!A28,\"\")","v":""},{"$f":"IF('General input data'!B28<>\"\",'General input data'!B28,\"\")","v":""},{"$f":"IF('General input data'!C28<>\"\",'General input data'!C28,\"\")","v":""},{"$f":"IF('General input data'!D28<>\"\",'General input data'!D28,\"\")","v":""},{"$f":"IF('General input data'!E28<>\"\",'General input data'!E28,\"\")","v":""},null,""]
[{"$f":"IF('General input data'!A29<>\"\",'General input data'!A29,\"\")","v":""},{"$f":"IF('General input data'!B29<>\"\",'General input data'!B29,\"\")","v":""},{"$f":"IF('General input data'!C29<>\"\",'General input data'!C29,\"\")","v":""},{"$f":"IF('General input data'!D29<>\"\",'General input data'!D29,\"\")","v":""},{"$f":"IF('General input data'!E29<>\"\",'General input data'!E29,\"\")","v":""},null,""]
[{"$f":"IF('General input data'!A30<>\"\",'General input data'!A30,\"\")","v":""},{"$f":"IF('General input data'!B30<>\"\",'General input data'!B30,\"\")","v":""},{"$f":"IF('General input data'!C30<>\"\",'General input data'!C30,\"\")","v":""},{"$f":"IF('General input data'!D30<>\"\",'General input data'!D30,\"\")","v":""},{"$f":"IF('General input data'!E30<>\"\",'General input data'!E30,\"\")","v":""},null,""]
[{"$f":"IF('General input data'!A31<>\"\",'General input data'!A31,\"\")","v":""},{"$f":"IF('General input data'!B31<>\"\",'General input data'!B31,\"\")","v":""},{"$f":"IF('General input data'!C31<>\"\",'General input data'!C31,\"\")","v":""},{"$f":"IF('General input data'!D31<>\"\",'General input data'!D31,\"\")","v":""},{"$f":"IF('General input data'!E31<>\"\",'General input data'!E31,\"\")","v":""},null,""]
[{"$f":"IF('General input data'!A32<>\"\",'General input data'!A32,\"\")","v":""},{"$f":"IF('General input data'!B32<>\"\",'General input data'!B32,\"\")","v":""},{"$f":"IF('General input data'!C32<>\"\",'General input data'!C32,\"\")","v":""},{"$f":"IF('General input data'!D32<>\"\",'General input data'!D32,\"\")","v":""},{"$f":"IF('General input data'!E32<>\"\",'General input data'!E32,\"\")","v":""},null,""]
[{"$f":"IF('General input data'!A33<>\"\",'General input data'!A33,\"\")","v":""},{"$f":"IF('General input data'!B33<>\"\",'General input data'!B33,\"\")","v":""},{"$f":"IF('General input data'!C33<>\"\",'General input data'!C33,\"\")","v":""},{"$f":"IF('General input data'!D33<>\"\",'General input data'!D33,\"\")","v":""},{"$f":"IF('General input data'!E33<>\"\",'General input data'!E33,\"\")","v":""},null,""]
[{"$f":"IF('General input data'!A34<>\"\",'General input data'!A34,\"\")","v":""},{"$f":"IF('General input data'!B34<>\"\",'General input data'!B34,\"\")","v":""},{"$f":"IF('General input data'!C34<>\"\",'General input data'!C34,\"\")","v":""},{"$f":"IF('General input data'!D34<>\"\",'General input data'!D34,\"\")","v":""},{"$f":"IF('General input data'!E34<>\"\",'General input data'!E34,\"\")","v":""},null,""]
[{"$f":"IF('General input data'!A35<>\"\",'General input data'!A35,\"\")","v":""},{"$f":"IF('General input data'!B35<>\"\",'General input data'!B35,\"\")","v":""},{"$f":"IF('General input data'!C35<>\"\",'General input data'!C35,\"\")","v":""},{"$f":"IF('General input data'!D35<>\"\",'General input data'!D35,\"\")","v":""},{"$f":"IF('General input data'!E35<>\"\",'General input data'!E35,\"\")","v":""},null,""]
["TOTALS",null,{"$f":"SUM(C18:C30)","v":200},null,{"$f":"SUM(E18:E30)","v":200},null,{"$f":"SUM(G18:G41)","v":-30}]

{"sheet":"Summary of Assessment","index":7,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[12,2,12,3],[13,2,13,3],[14,2,14,3],[4,0,4,3],[7,1,7,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[7,5,7,8],[8,5,8,8],[0,0,0,12],[6,1,6,3],[5,1,5,3],[5,5,5,8],[6,5,6,8],[2,0,2,3],[3,0,3,3]]}
["Summary of Assessment"]
[]
["This sheet summarizes assessment of the four individual components that together describe the climate effect of wood and wood-based products at the corporate level. "]
["Note: A minus sign denotes a net sink of CO2e (less CO2 in the atmosphere) and a plus sign denotes a net source of CO2 (more CO2 in the atmosphere)."]
["Caution: The different components do not have the exact same characteristics and caution has to be taken when interpreting the total climate effect",null,null,null,null,"Colour coding:"]
["Corporation",{"$f":"'General input data'!B4","v":"Name of Corporation"},null,null,null,"Cells where data are entered manually"]
["Notes",null,null,null,null,"Cells where data is copied/calculated based on  other cells - NO manual input to be made in these cells"]
["Year",{"$f":"'General input data'!A9","v":"Time period XXX"},null,null,null,"Cells where constants / conversion factors are provided "]
[null,null,null,null,null,"Cells with no data"]
["Component","tCO2e"," Comment"]
["1 Value chain emissions for wood-based products",{"$f":"IF('1 Value chain emissions'!B50<>0,'1 Value chain emissions'!B50,\"\")","v":60},"  Positive values relates to emissions of CO2e"]
["2 Prevented emissions from counterfactual products",{"$f":"IF('2 Prevented emissions - totals'!L42<>0,'2 Prevented emissions - totals'!L42,\"\")","v":-210},"  Negative values relates to decreased emissions of CO2e"]
["  3 Change of carbon stored in forest",{"$f":"IF('3 Forest'!G48<>0,'3 Forest'!G48,\"\")","v":-30},"  Negative values relates to increase in carbon stock"]
["  4 Change of carbon stored in wood-based products",{"$f":"IF('4 Wood-based products'!G42<>0,'4 Wood-based products'!G42,\"\")","v":-30},"  Negative values relates to increase in carbon stock"]
["Total climate effect",{"$f":"SUM(B11:B14)","v":-210},"  Negative values relates to a climate benefit (less CO2e in the atmosphere)"]

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