Supporting data and calculations for energy use and CO₂ screening of oily ship-waste treatment at the Haydarpaşa Port Reception Facility

Published: 20 October 2026| Version 1 | DOI: 10.17632/92h3y4ymwj.1
Contributors:
,
,

Description

This dataset contains the operational inventory, source extracts, and calculations supporting an energy-use and conditional CO₂ screening analysis of oily ship-waste treatment at the Haydarpaşa Port Reception Facility in İstanbul, Türkiye. Source_Extracts.pdf reproduces original inventory Tables 10–13 and selected explanatory passages from the authors’ retained study records, compiled from facility-supplied operating information. Supplementary_Information_ESPA.docx documents transcription, assumptions, accounting boundaries, and sensitivity analyses. Calculations_ESPA.xlsx provides the input quantities and visible formulas for delivered-energy accounting, electricity–fuel CO₂ crossover conditions, alternative reference-volume assumptions, Turkish electricity-factor scenarios, and conditional capacity and sludge-stoichiometry checks. The primary reconstruction uses one cubic meter of accepted ship waste. Conflicting references to treated wastewater are documented and examined through structural sensitivity analysis. National electricity factors represent contextual scenarios rather than measured historical site emissions. The files enable source-transcription checks and reproduction of the calculations. Original meter series, matched quantity–volume records, and the historical openLCA model are not available. The dataset supports screening under explicit assumptions and does not constitute a complete life-cycle assessment or a new monitoring campaign.

Files

Steps to reproduce

1. Read Supplementary_Information_ESPA.docx for the inventory boundary, reference-volume assumptions, transcription conventions, and calculation methods. Compare the SourceInputs worksheet in Calculations_ESPA.xlsx with Tables 10–13 and the explanatory passages reproduced in Source_Extracts.pdf. 2. Open Calculations_ESPA.xlsx in Microsoft Excel with automatic calculation enabled. The workbook contains visible formulas and requires no macros or external workbook links. 3. For the primary reconstruction, retain a = 1 and r = 1 in cells B6 and B7 of the Parameters worksheet. The reconstructed inventory gives 90.03 kWh of electricity and 5.88 kg of fuel oil per reference cubic meter. Fuel energy is 237.552 MJ and direct fuel-combustion CO₂ is 18.3865248 kg per reference cubic meter. 4. Review EnergyCO2 for delivered-energy accounting and conditional CO₂ results, and MaterialsFreight for material inputs and freight calculations. ElectricityContext presents the official Turkish electricity-factor scenarios separately from the illustrative default g = 0.4 kg CO₂/kWh in Parameters!B8. 5. To examine sensitivity, vary Parameters!B6 (a), B7 (r), and B8 (g), keeping a > 0, r ≥ 0, and g ≥ 0. These inputs define accounting scenarios rather than additional measured operating data. 6. Review CapacityContext and SludgeCheck alongside the supplementary explanations. These are conditional consistency checks and should not be interpreted as measurements of actual throughput, equipment efficiency, or sludge production.

Institutions

Categories

Environmental Engineering, Waste Management, Energy Efficiency, Wastewater

Licence