Energy balance to Excel.
A heat and material balance is the process engineering document that ties every process stream to its source unit, destination unit, mass flow, temperatures (in and out), pressures, heating duty, cooling duty, and the heat source or sink (steam HP / MP / LP, cooling water, refrigeration, fired heat). The heat and material balance is the foundation document for energy integration (pinch analysis), utility sizing, and process optimization; it is what the energy auditor reads to identify recovery opportunities and what the process simulator imports for case studies.
Upload a heat and material balance document and extract every stream into a structured spreadsheet. Stream id, source process unit, sink, heating duty, cooling duty, temperatures, mass flow, and enthalpies all read into the columns the energy auditor and the process optimizer use.
| Use | Primary fields | Output |
|---|---|---|
| Energy integration (pinch analysis) | Hot + cold composite streams | Pinch grid + minimum utility target |
| Utility sizing | Steam, CW, refrigeration duty totals | Per-utility header sizing |
| Process simulator import | Per-stream T / P / flow / composition | Aspen / HYSYS / ProMax case input |
| Capacity case studies | Stream conditions at design + turndown | Operating envelope curves |
| Sustainability reporting | Per-utility carbon intensity factor | Annualized emissions |
Fields extracted.
Every column the heat and material balance typically carries is read and shaped into a structured row. Missing fields stay blank, never invented.
- Stream id
- Source unit
- Destination unit
- Mass flow
- Temperature in
- Temperature out
- Pressure in
- Pressure out
- Heating duty
- Cooling duty
- Enthalpyper stream or per kg
- Heat source / sinksteam HP/MP/LP, cooling water, refrigeration, fired heat
- Notes
Export targets.
The extracted data ships in the format your team picks up and uses directly.
- .xlsxExcel workbook (heat and material balance)
- .csvCSV
- .xlsxPinch-analysis grid scaffold
From legacy file to clean register.
Common questions.
Can this feed a pinch-analysis workbook (Aspen Energy Analyzer, ProPI)?
Yes. The pinch-analysis grid scaffold export carries the hot and cold composite streams in the column shape these tools read. Per-stream heat capacity flow rate (CP × mass flow) carries through where the source document prints it; otherwise the duty / dT yields the same answer.
Does the export tie back to the PFD it came from?
When the heat and material balance and the PFD process as the same workspace, stream-id cross-references between the two documents link in the export. A stream on the PFD that disagrees with the balance surfaces in the workspace audit log.
Convert your file.
Upload a heat and material balance in any format, get every row read, every column shaped, every reference preserved, then export the workbook your team uses next.