HCBBS Forum (English)
Submit Chemical Projects / Find Solutions
Amplify Your Requirements on a Broader Chemical Platform *Engineering · Technology · Equipment · Solutions*
Submit Request

Seeking help with a problem regarding exporting a material balance table in HYSYS

2024-07-08View Original

Thread Content

The company requires that the material balance sheet include the contents shown in the table, but I can only export what is within the red boxes; I’m using the Excel export function. Do any of you know a way to add the required data manually?
Reply #22024-07-08
In HYSYS, if you need to add additional data to the material balance table that is not included in the default export options, you can try the following methods: 1. **Manually add data**: - After exporting the basic material balance table, you can use Excel or other similar software to manually add the additional data required. - Maintain the table format exported by HYSYS, and then enter additional data in the appropriate columns or rows. 2. **Custom Reports**: - In HYSYS, you can use the reporting function to create a custom material balance sheet. Using the Report Generator, you can choose to include more detailed information or specific calculation results. - Find “Report Generator” under the “Tools” menu, create a new report, and then add the desired data fields as needed. 3. **Using Spreadsheet Operations**: - Within HYSYS, the built-in Spreadsheet tool can also be used to process and display data. You can link the calculation results to a Spreadsheet, and then add, calculate, or modify data in it. - Open the built-in Spreadsheet, add the required data rows using ‘Add Rows’, and calculate and adjust the data through Formula Cells. 4. **Write scripts or macros**: - If you are familiar with programming, you can consider using HYSYS’s automation interfaces (such as VBScript or other scripting languages) to write scripts that generate material balance sheets meeting the company’s requirements. - This method enables batch processing and automated output, making it particularly suitable for situations where reports need to be generated repeatedly. Each method has its advantages and disadvantages; you can choose to use it based on your level of familiarity and specific needs. If you are not sure about how to proceed, it is recommended to consult experienced colleagues or refer to HYSYS’ official user guide and help documents, as these resources usually provide more detailed instructions. .
Reply #32024-07-30
You’re welcome! I’m glad I could help! If you have any other questions or need further assistance, feel free to ask at any time. Wish you success in your work! .

Submit a Project

**Looking for Chemical Technology, Equipment & Solutions?** No Registration Required Broader Platform Exposure | Global Chemical Service Provider Connections

Submit Request — Free Consultation

Disclaimer

This is an automated machine translation of the original thread. Some technical terms may have inaccuracies; the original text shall prevail. Click "View Original" at the top right to access the source page, which supports IP-based automatic real-time language translation. Please watch out for contact details and sales inducements to prevent fraud. All content and translations are for reference only, representing solely the poster's personal views. For enquiries, email service@hcbbs.com.