{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["R C KPI Form","Guidelines","gCO2 tonne-km"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"R C KPI Form","index":0,"n_rows":41,"n_cols":2,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,1,2,2],[24,0,24,1],[8,0,8,1]]}
[null,"2021 KPI FORM - TRANSPORT"]
[]
[]
[]
["Company Name"]
["Email address of your company RC lead & main contact"]
["Period (Year)"]
[]
["1. Tonnage handled during the reported year"]
["IN"]
["OUT"]
["Total",{"$f":"SUM(B10:B11)","v":0}]
[]
["2.    Number of Operators and other staff (Per 31 December 2021)"]
["2.1 Number of Operators - incl. Subcontractors"]
["2.2 Number of Office staff"]
[]
["3. Number of Incidents"]
["Death"]
["Losttime-Injury"]
["Loss of Product (plastic pellets / OCS guideline)"]
["Loss of all other chemical Products (non-plastic pellets)"]
["Total",{"$f":"SUM(B19:B22)","v":0}]
[]
["4. Split of (forklift or other) trucks used for handling"]
["Electric"]
["LNG/LPG"]
["Gasoil/Diesel"]
["Alternative Combustion (Hybrid/Hydrogen Cells..)"]
[]
["5. Emission KPI's (Optional for the year 2021 KPI Report)"]
["CO2E Emissions Scope 1 (MT)"]
["CO2E Emissions Scope 2 (MT)"]
["CO2E Emissions Scope 3 (MT)"]
[]
["6. Emission Reduction Program (Obligatory)"]
["Has the company defined the objectives to reduce its emission intensity? \n(ref. SQAS WH 10.3.8.2) - answer: YES / NO","YES / NO"]
["Does the company have a multi-annual programme to reach the company's emission objectives? \n(ref. SQAS WH 10.3.8.2) - answer: YES / NO","YES / NO"]
["Describe briefly 2 examples of your emission reduction programme which have been succesful for your company in the past year:"]
["1.\n\n"]
["2.\n\n"]

{"sheet":"Guidelines","index":1,"n_rows":239,"n_cols":1,"rows_kept":239,"cut":false,"hidden":false,"merged":[]}
["Definitions of KPI’s required"]
[]
["1. Number of km operated per year for chemical goods transportation in Europe (mio.km/year)"]
["Performance Measure"]
["Total million kilometres (of all modes) executed for the chemical industry including subcontractors."]
[]
["Purpose"]
["Reflects the total number of km (road and intermodal) done by the LSP and subcontractors for the chemical industry. This KPI allows relative performance data to clarify the importance of the RC scheme."]
[]
["Definitions"]
["Chemicals: All chemical products, including not only finished products, but also samples, raw materials, intermediates, wastes, etc., whether or not classified as dangerous according to the UN Recommendations for the Transport of Dangerous Goods (Cefic definition)."]
["Chemical Goods: the definition applied by Cefic and ICCA is accepted by ECTA, meaning that includes all products made by chemical producers, for instance includes fine chemicals, organic chemicals, sulphuric acid and minerals. There is no restriction to Petrochemicals, but fuel distribution (LPG, petrol, etc) is not included in the chemical transport market under ECTA RC scheme."]
[]
["Reporting Instructions"]
["Calculate all km for chemical producers, irrespective of the modal choice of the transport. Include km estimates for intermodal legs."]
[]
["Includes all modes and transit between loading and final destination, includes trips to and from terminals, cleaning stations and includes empty legs."]
[]
[]
[]
["1a. Number of Moves (Orders) per year"]
["This is calculated from actual moves as per collections / deliveries performed including subcontractors. "]
[]
[]
["2. Tonnes carried per year"]
["A calculation from moves made and payload carried per annum including subcontractors."]
[]
[]
["3. & 3a. Number of employees – Drivers/subcontractors and office/planning staff"]
[]
["Performance Measure"]
["Number of FTE employees in the RC LSP (including subcontractors)."]
[]
["Purpose"]
["Shows how many people are employed by the RC LSP and indicates the number of people who are in contact with the concept of Responsible Care."]
[]
["Definitions"]
["As applied in social legislation to calculate FTE (Full Time Equivalent)."]
[]
["Reporting Instructions"]
["FTE equivalent. Use figures of annual reports."]
[]
[]
[]
["3b. & 3c. Training days per driver/subcontractors and office/planning staff per year"]
[]
["Performance Measure"]
["This KPI measures the number of training days per driver/office staff per year."]
["This is to measure the overall training for the company. Subcontractors are included in this reporting."]
[]
["This KPI allows the LSP to express the impact of investments in training."]
[]
["Purpose"]
["To be able to measure the importance of total personnel training for the movement of chemical goods."]
[]
["Definitions"]
["ADR: \"European Agreement Concerning the International Carriage of Dangerous Goods by Road\", Volume II, by the United Nations, last revision."]
[]
["BBS: Behaviour Based Safety training, refers to the ECTA/CEFIC documents \"Behaviour Based Safety – Guidelines for safe driving of road freight vehicles\" from October 2003 as well as “Behaviour Based Safety – Guidelines for the safe loading and unloading of road freight vehicles\" from November 2004 (issue 2 from March 2007)."]
[]
["European Directive 2003/59/EC – Initial qualification and periodic training for drivers of road vehicles for the carriage of goods or passengers"]
[]
["Reporting Instructions"]
["Drivers"]
["All training days can be included for example ADR training, load securing, internal training, defensive driving, BBS, statutory training, etc. Average of training days per driver/office staff per year should meet or exceed the EU directive."]
[]
["3d. Driver days absence per annum"]
[]
["This KPI is self explanatory and should include all absences that are not notified prior to being absent."]
[]
[]
[]
["4. Mode of transport used"]
[]
["Performance Measure"]
["Gives percentage split of transport modes used including subcontractors."]
[]
["Purpose"]
["To follow up the environmental choices made in logistics for chemical products."]
[]
["Definitions"]
["Road is transport handled under drivers' care from loading to unloading sites."]
["Intermodal transport: Movement of goods (in one and the same loading unit or a vehicle) by successive modes of transport without handling of the goods themselves when changing modes. Other used terms are multimodal transport or combined transport."]
[]
["European Conference of Ministers of Transport (ECMT) defines multimodal (intermodal) transport as the \"carriage of goods by at least two different modes of transport\"."]
[]
["For transport policy purposes the ECMT restricts the term combined transport to cover: \"Intermodal transport where the major part of the European journey is by rail, inland waterways or sea and any initial and/or final leg carried out by road are as short as possible\"."]
["Reporting Instructions"]
["There should only be two categories: road and intermodal. Report as a percentage; the total must be 100%."]
[]
[]
[]
["5. Number of incidents with motor vehicles for the year – whilst in transit"]
[]
["Performance Measure"]
["This KPI measures accidents whilst in transit on the road, including subcontractors."]
[]
["Purpose"]
["To be able to calculate an industry average, identify weak points and have in place an improvement plan."]
[]
["Definitions (definitions according to Cefic)"]
["Accidents: Any occurrence involving a commercial motor vehicle on highway, national or local roads resulting in a fatality, injury to a person requiring immediate treatment away from the scene of the accident, disabling damage to a vehicle requiring it to be towed from the scene, loss of product or involvement of authorities."]
["Transport: The \"in-transit\" transport of chemicals by motor vehicles between the site of a supplying company and that of the final destination, excluding transport activities at loading and unloading premises of the supplying chemical company and the final destination."]
[]
["Death: when death results from the accident (up to 30 days after the accident) irrespective whether or not the chemical product contributed to the death."]
["Injury: where the injury requires intensive medical treatment, or requires a stay in hospital of at least one day, or results in the inability to work for at least three consecutive days irrespective of whether or not the chemical product contributed to the injury."]
[]
["Loss of product: any release of product"]
[]
["·         Dangerous goods – release of product of more than 50 kg or litres;"]
["·         Non-dangerous goods – release of more than 1000 kg or litres."]
[]
["Damage: any damage exceeding EURO 20.000 to the property of any party (including environmental cleaning up), resulting from the transport incident, irrespective of whether or not the chemical product contributed to the damage."]
[]
["Involvement of authorities: direct involvement of the authorities or emergency services in the transport accident/incident or the evacuation of persons or closure of public traffic routes for three hours or more caused by the transport accident/incident."]
[]
["Rollover: the vehicle and associated equipment (tank/container) has rolled over onto its side."]
[]
["Reporting Instructions"]
["This KPI does not apply to rail, shipping or barge movements. This KPI applies to all intermodal road movements."]
[]
["All inputs must be reported in numbers."]
["For all incidents happening on the road, the reporting should be split between those occurring to own fleet and subcontractors."]
[]
[]
[]
["6. Number of incidents at loading points for this year"]
[]
["Performance Measure"]
["This KPI measures accidents whilst at loading point, including subcontractors."]
[]
["Purpose"]
["To be able to calculate an industry average, identify weak points and have in place an improvement plan."]
[]
["Definitions (definitions according to Cefic)"]
["Accidents: Any occurrence at a loading point resulting in a fatality, injury to a person requiring immediate treatment away from the scene of the accident, disabling damage to a vehicle requiring it to be towed from the scene, loss of product or involvement of authorities."]
["Death: when death results from the accident (up to 30 days after the accident) irrespective whether or not the chemical product contributed to the death."]
["Injury: where the injury requires intensive medical treatment, or requires a stay in hospital of at least one day, or results in the inability to work for at least three consecutive days irrespective of whether or not the chemical product contributed to the injury."]
[]
["Loss of product: any release of product"]
[]
["·         Dangerous goods – release of product of more than 50 kg or litres;"]
["·         Non-dangerous goods – release of more than 1000 kg or litres."]
[]
["Damage: any damage exceeding EURO 20.000 to the property of any party (including environmental cleaning up), resulting from the incident, irrespective of whether or not the chemical product contributed to the damage."]
[]
["Involvement of authorities: direct involvement of the authorities or emergency services in the incident or the evacuation of persons."]
[]
["Reporting Instructions"]
["This KPI applies to all occurrences (as defined) at the loading point. "]
["All inputs must be reported in numbers."]
[]
["For all incidents, the reporting should be split between those occurring to own fleet and subcontractors."]
[]
[]
[]
["6a. Number of incidents at unloading points for this year"]
[]
["Performance Measure"]
["This KPI measures incidents whilst at unloading point, including subcontractors."]
[]
["Purpose"]
["To be able to calculate an industry average, identify weak points and have in place an improvement plan."]
[]
["Definitions (definitions according to Cefic)"]
["Accidents: Any occurrence at an unloading point resulting in a fatality, injury to a person requiring immediate treatment away from the scene of the accident, disabling damage to a vehicle requiring it to be towed from the scene, loss of product or involvement of authorities."]
["Death: when death results from the accident (up to 30 days after the accident) irrespective whether or not the chemical product contributed to the death."]
["Injury: where the injury requires intensive medical treatment, or requires a stay in hospital of at least one day, or results in the inability to work for at least three consecutive days irrespective of whether or not the chemical product contributed to the injury."]
[]
["Loss of product: any release of product"]
[]
["·         Dangerous goods – release of product of more than 50 kg or litres;"]
["·         Non-dangerous goods – release of more than 1000 kg or litres."]
[]
["Damage: any damage exceeding EURO 20.000 to the property of any party (including environmental cleaning up), resulting from the incident, irrespective of whether or not the chemical product contributed to the damage."]
[]
["Involvement of authorities: direct involvement of the authorities or emergency services in the incident or the evacuation of persons."]
[]
["Reporting Instructions"]
["This KPI applies to all occurrences (as defined) at the unloading point. "]
[]
["All inputs must be reported in numbers."]
[]
["For all incidents, the reporting should be split between those occurring to own fleet and subcontractors."]
[]
[]
[]
["7. Split of trucks used for chemical transport"]
[]
["Performance Measure"]
["This KPI reflects the percentage of trucks of each Euro category used, allows ECTA to measure the implementation levels of new technologies. Subcontracted trucks included."]
[]
["Purpose"]
["The purpose of this KPI is to keep a track of the overall evolution of new engine technology."]
[]
["Definitions"]
["EEV – European Enhanced Vehicle: term used in the European emission standards for the definition of a \"clean vehicle\" >3.5 tonne in the category M2 and M3. The standard lies between the levels of Euro V and Euro VI."]
[]
["The classifications for vehicle types are defined by:"]
[]
["·         Commission Directive 2001/116/EC of 20 December 2001, adapting to technical progress Council Directive 70/156/EEC on the approximation of the laws of the Member States relating to the type-approval of motor vehicles and their trailers."]
[]
["·         Directive 2002/24/EC of the European Parliament and of Council of 18 March 2002 relating to the type approval of two or three-wheeled motor vehicles and repealing Council Directive 92/61/EEC."]
[]
["Reporting Instructions"]
[]
["Report as a percentage; the total must be 100%. (including subcontractor trucks)"]
["Report in absolute \"number of owned operated trucks\" (=without subcontracted trucks)"]
[]
[]
["8 a, b & c. Energy Based data"]
[]
["Performance Measure and Formula"]
["}  CO2 = fuel consumption (in litres) x CO2-factor (2.9 kgs/litre consumed)"]
[]
["This KPI measures the litres consumed."]
[]
["Purpose"]
["To measure the environmental improvement change within the LSP achieved by e.g. Euro engine change, training conducted etc..."]
[]
["Definitions"]
["The total fuel consumed within the year for kilometres operated."]
[]
["Reporting Instructions"]
["The LSP should report data that includes all fuel consumed for all road movements, this should be related to goods carried."]
[]
[]
[]
["9. Activity Based data"]
[]
["For calculation of Fuel Consumption and CO2 production, see the report \"Measuring and Managing CO2 emissions of European chemical transport\" by Prof Alan McKinnon."]
[]
["CO2 = tons transported x average transport distance x CO2-emission factor per ton-km"]
[]
[]
[]
["10. Total Tonnes CO2"]
[]
["This is derived as a result of one of the above 2 formulas. "]

{"sheet":"gCO2 tonne-km","index":2,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["according to \"Measuring and Managing CO2 Emissions of European Chemical Transport\" by Professor Alan McKinnon and Dr Maja Piecyk"]
["Table 8"]
[]
["Transport mode","gCO2/tonne-km"]
["Road Transport",62]
["Rail Transport",22]
["Barge transport",31]
["Short sea",16]
["Intermodal road/rail",26]
["Intermodal road/barge",34]
["Intermodal road/short sea",21]