Techno-Economic Assessment of Biomass Pre-Processing (TEABPP) - Initial techno-economic results - Spreadsheet tool
收藏资源简介：
The techno-economic project will provide a greater understanding of the options available to modify or improve the physical and chemical characteristics of different types of UK-derived 2nd generation energy biomass feedstocks, that may otherwise reduce the cost-effective performance of conversion technologies<br><br>This Excel tool presents techno-economic assessments of a library of representative biomass value chains producing heat, power, combined heat and power, or syngas. Costs are present day (projected future costs not considered), and prices or profits are not be considered.The tool does not consider uncertainty ranges, feedstock characteristics or sensitivity analyses. This Excel tool is a pre-cursor to the more sophisticated gPROMS model produced later in the project. <br><br>Note:This workbook is very large, and reliant on the interaction between thousands of different input parameters and formulaeIn particular, the “Chain choice” tab contains a Data table with over a large number of rows and 3 columns, which is computationally heavy, and often leads to cycling between chains/volatile values changingIt is therefore a very strong recommendation for the user to configure your Excel to NOT automatically update all formulaeTo do this, go to File > Options > Formulas > and select “Automatic except for data tables”.You can then use the Excel safely, and if you want to refresh the Data table results, hit “F9” and wait about 2 minutes.The Data table will be refreshed when the “Data Table: 1” status at the bottom right of the Excel window disappears. If you hit “F9”Then move to another cell or tab, the table will not have updated.Youmay also find that you cannot have any other spreadsheet open at the same time.
本技术经济项目将深化对各类可行方案的认知，这些方案可用于调整或优化不同类型英国来源第二代能源生物质原料（2nd generation energy biomass feedstocks）的物理与化学特性；若未采用此类方案，则可能降低转化技术的成本效益表现。 本Excel工具可对涵盖供热、发电、热电联产或合成气生产的典型生物质价值链库开展技术经济评估。本次评估仅采用现行成本（不考虑预测的未来成本），且未纳入价格或利润相关考量。该工具未考虑不确定性范围、原料特性或敏感性分析。本Excel工具为本项目后续开发的更复杂gPROMS模型的原型。 注意：本工作簿体量庞大，依赖数千组不同输入参数与公式之间的交互运算。具体而言，"Chain choice（链选择）"选项卡中包含一个数据表格，该表格包含大量行与3列，计算负荷极高，且常会出现价值链切换或易变数值波动的循环运算问题。因此强烈建议用户将Excel配置为不自动更新所有公式。具体操作路径为：依次点击"文件>选项>公式"，并选择"除数据表格外自动更新"。完成配置后即可安全使用该Excel工具；若需刷新数据表格结果，请按下"F9"键并等待约2分钟。当Excel窗口右下角的"数据表格：1"状态提示消失时，数据表格即完成刷新。若按下"F9"后立即切换至其他单元格或选项卡，表格将不会完成更新。此外，用户可能会发现无法同时打开其他电子表格文件。
