Flowsheet Report Example

From SysCAD Documentation
Jump to navigation Jump to search

Navigation: User Guide ➔ Getting Started ➔ Example Projects ➔ Flowsheet Report Example

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\Flowsheet Report Example.xlsx (This report was added in Feb 2020)

Brief Description

This is an example project report created for the Nickel Copper Project. The report layout maybe used as a "template" for user reports.

Note that this worksheet is also part of the Project Report.xlsm workbook. It has been extracted as a standalone workbook in Build138 and later.

Excel Worksheet Tabs

There are two flowsheet report layouts:
  1. BFD (1 Variable)
    • 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 (MS Excel Menu "Data - Data Validation"), 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 (in the coloured text boxes) 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:
    FlowsheetReportExample.png
    Hint: To place the  text boxes  to the right locations, 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 to show the correct species / variables for your project.
  2. BFD (3 Variables)
    • This worksheet is similar to the one described above, except it has been set up with 3 lookup variables.
    ExcelFlowsheetReport-3vars.png

Notes on BFD / flowsheet report tables:

  • These are created using SysCAD_TagTable (instead of SysCAD_TagSelect), this is to avoid streams numbers being updated and moved, as these are referenced by display text boxes.
  • Recommend creating a separate worksheet to check for the list of tags, and then update the tag list on the BFD page manually by appending the new tags to the end of the list.
BFDstreamChecks.png