This report has fully customizable content that is formatted as a multiple worksheet Excel book. Before you create the report, you must visit the Report Options Dialog: Custom Excel Tab in order to specify what information you wish to have included in the report (select Reports } Options from the main menu, and then visit the ‘Custom XL’ tab). The content of the report is organized in sections and each section contains one or more sub-sections.The sub-sections may also contain multiple items that may be included/excluded. Each section included in the report will end up as a separate worksheet in the ‘xls’ file. The sections which may be included are:
1. General
2. Materials
3. Utilities
4. Stream Summary
5. Unit Procedures
6. Equipment
7. Scheduling
8. Wastes
9. Consumables
10. Storage Units
11. Labor
12. EPA
Some sections may contain as little as one sub-section with one item; others may contain several sub-sections with multiple items within each sub-section. Some sub-sections allow you to include tables (e.g. stream summary table, or equipment contents) or charts (e.g. operations gantt chart, or a selected material’s resource consumption or inventory chart).
This section may include any of the following sub-sections:
● Description: this can contain any information related to the process as a whole: the process flowsheet, the name of the file, the name of the engineer responsible for the project, the name of the project, etc.
● Size: this reports the process throughput (batch size) and/or the annual throughput.
● Scheduling (available for batch processes only): this can include scheduling information such as the process batch time, cycle time, number of batches per year, bottleneck equipment, etc. More-detailed scheduling information can also be included as a separate worksheet (as part of the ‘Scheduling’ section (see below).
● Economics: any key economic figures of the process: total capital investments, total revenues, operating cost etc.
● Project Indices: indices resulting from the economic evaluation of the project (gross margin, return on investment, payback time, IRR before & after tax etc.)
This section may include any of the following sub-sections:
● Tables: this may include tables presenting the consumption, output, or cost of selected material(s) as well as the overall material balances. The Entering Material Demand Breakdown tree can also be exported to this section.
● Charts: this includes pure component or stock mixture consumption tracking charts, material output charts, and inventory charts.
This section may include any of the following sub-sections:
● Tables: items in this sub-section include demand tables for all power types or heat transfer agents, as well as the cost tables of these resources. Tables for utility loads associated with each individual operation may also be generated. The Heat Transfer Agent Demand Breakdown and Power Demand Breakdown trees can also be exported to this section.
● Charts: items in this sub-section include consumption and/or inventory charts for heat transfer agents, and power demand /generation charts for a selected power type.
This section contains only one sub-section with one item: the stream summary table of the process.
This section includes sub-sections that each map to a selected procedure in the process. For each of the selected procedure(s), the Activity Overview Table (which describes the list of activities carried out by the operations in the procedure’s queue) is included.
This section may include any of the following sub-sections:
● Tables: This can include a summary listing of all equipment resources included in the process, as well as the equipment contents of a selected equipment resource.
● Charts: two possible items may be included here: the equipment occupancy chart for the process and the throughput analysis charts (Utilization factors and Throughput potential).
This section may include the following sub-sections:
● Key Scheduling Variables: this includes the process batch time, cycle time, number of batches per year, minimum cycle time, maximum number of batches per year, available & utilized annual operating time, the longest procedure, and the bottleneck equipment.
● Charts: this can include the equipment occupancy chart and/or the operation/equipment gantt charts.
This section includes only one sub-section: the Waste Generation Tables. There may be up to five items included in this sub-section: up to four tables dedicated to each of the four distinct waste types allowed by the application (solid, aqueous, organic and emissions), and a fifth table presenting all waste cumulatively.
This section includes a table with all the consumables used in the process. The table shows consumable demand amounts and cost. The Consumable Usage Breakdown tree can also be exported to this section.
This section can include charts of supply unit material demand and receiving unit material deposit as well as the inventory charts for the material storage units.
This section may include any of the following sub-sections:
● Tables: items in this sub-section may include a demand table for all labor types, as well as the cost table of all the labor type resources. The Labor Demand Breakdown tree can also be exported to this section.
● Charts: this includes consumption charts for each selected labor type associated with the selected Unit Procedures chosen in the Unit Procedures section of this dialog.
This section can include the EPA-MACT report. EPA-MACT report options are transfered from the normal EPA-MACT Emissions Report (EPA) and carried over as is to the EPA section of the Custom Excel Report.