Example SysCAD Excel Reports

From SysCAD Documentation
Jump to navigation Jump to search

Navigation: User Guide ➔ Example Projects ➔ Example Excel Reports

Getting Started and Installation SysCAD Licensing Training Tutorial Guidelines and Examples
Getting Started Download
Software
Installation
Instructions
SysCAD Files SysCAD Licensing License Options Crypkey Software Training Information Training Preparation Tutorial Overview Tutorial Videos Modelling
Guidelines
Example Projects Example Reports Example PGM Files FAQ

Latest SysCAD Version: 03 May 2021 - SysCAD 9.3 Build 138.28537

Example Reports
Project Report Flowsheet Report Project Criteria Report Sensitivity Analysis Default Reports

Related Links: Excel Reports


File Location

This file is stored in ..\SysCADXXX\Examples\01 Reports\Project Report.xlsm

Brief Description

This is an example project report created for the Nickel Copper Project. It shows some possible report layouts to best present SysCAD data. The report layout maybe used as a "template" for user reports. Many of the worksheets only require minor changes to work with other projects.

This file contains a number of report types, these include:

  1. Macro to Start SysCAD from Excel using COM Automation. Please see "Main" Tab.
  2. Set Tag List Report - Used to set a list of user specified values from Excel to SysCAD. Please See "Criteria" Tab, Column G.
  3. Tag List Report - Used to retrieve data from SysCAD into Excel as a list. Please see "Criteria" Tab, Column D.
  4. Tag Table Report - Used to retrieve data from SysCAD into Excel as a table. Please see Tabs Streams, as well as the individual flowsheet tabs.
  5. Excel Tag Select Reports - Used to retrieve data from SysCAD into Excel as a table. Please see Mass Balance tab.
NOTE that the example SysCAD reports may have the SysCAD Tag columns/rows hidden by outline. Please open these up to see the hidden columns/rows, as shown below:
ReportOutline.png

Excel Worksheet Tabs

Main:

  • This worksheet contains an Excel Visual Basic Code to run SysCAD from Excel.
  • The macro will load the Demo Nickel Copper Project, sets the project with the criteria input values, solves the project, then retrieves the model values from SysCAD.
    ExcelReportExample3.png
  • This macro allows the end user not familiar with SysCAD to use the software run scenarios, where user changes some input values in Excel and views the SysCAD results after the run has completed.
  • NOTES:
    1. User may need to register COM Automation before this macro can be executed correctly.
    2. Make sure the project file path is correct.

Criteria:

This worksheet REQUIRES USER INPUT. The aim of this worksheet is to list the key process indicators, or design criteria for the SysCAD model.
Please see Project Criteria Report for how to edit this worksheet.

Mass Balance:

This report is created using tag select, which means the SysCAD Tags will update to match the pre-defined criteria. In this case, the report will search the SysCAD project to return all Feeders and Sinks (excluding cross page connectors) in the project to check for total in and total out mass balance.
The SysCAD Tags are located on Column D. Columns B and C are description only.
This report will work with any project, user may need to modify the elemental balance to suit their project. For example: If your project has no elemental Co but would like to check elemental Al, then Change All Co to Al in columns B and D.
ExcelReportExample4.png
NOTE: If mass does not balance, it could be due to left over tags from previous in the report. Check for the <<End>> Marker in Rows 8, 15, 32 and 37. The <<End>> markers indicate the end of the TagSelect query, if there are more than one <<End>> in a single Row, then delete the entries after the first <<End>>.

Individual Flowsheet Tabs:

These reporting pages contain:
  • SysCAD flowsheet - Flowsheets can be copied by using the Copy bitmap command. Alternatively, user can use MS Windows Snip & Sketch Snip and sketch.png application to make a copy of the flowsheet.
  • Cell A2 has Data Validation setup, user can select from the list a variable to display on the flowsheet. Indicated by Button Small 1.png
ExcelReportExample5.png
  • The values being displayed are from Excel Lookup, which are set up on Row 49. For example, Cell D49 has the following VLookup set up:
ExcelReportExample6.png
  • The results from the VLookup are displayed in  text boxes , as shown below.
ExcelReportExample5a.png
Hint: To place the  text box  to the right location, change the variable selection (A2) to "Stream Number", this will make stream matching much easier.
  • The SysCAD Report Table are hidden by outline, Rows 50 to 75. Change the reporting tag / or reporting variables in rows 50 to 75 if required to suit your project.