Introductory Tutorial - Excel Reports and Quick View

From SysCAD Documentation
Jump to navigation Jump to search
IMPORTANT: The videos here supplement the SysCAD Introductory Tutorial located in the install directory at SysCADxxx\Tutorial\SysCADIntroductoryTutorial.pdf (or SysCADBasicTutorial.pdf in earlier versions). Refer to this document for detailed instructions.

Navigation: User Guide ➔ Tutorial ➔ Tutorial Videos ➔ Excel Reports and Quick View

Section 2
Creating a SysCAD Project
Section 3
Project Configuration and Species Database
Section 4
Access Window and Quick View
Section 5
Chemical Reactions
Section 6
Trend Windows, PID and Ratio Controllers
Section 7
Merging and Modifying Projects
Section 8
General Controllers
Section 9
Makeups and EHX
Section 10
Graphics Window and Bulk Tag Change
Section 11
Excel Reports and Quick View

Latest SysCAD Version: 25 October 2024 - SysCAD 9.3 Build 139.36522

Related Links: Excel Reports, Excel Get Tag Reports, Excel Set Tag Reports, Excel Tag Select Reports, Adding and Executing Excel Reports, Excel Trend Reports, Quick View - Data for Excel Reports


Section 11 Overview

Please use these videos together with Section 11 of the SysCAD Introductory Tutorial, which is distributed with the SysCAD full install.

We will continue to use the project that we have constructed and modified in the previous sections of the Tutorial.

In this section we will look at:

  1. Creating and Generating a simple Excel report with a list of values (a Tag List report);
  2. Use Quick View to set up a Tag Select report in Excel;
  3. Generate an Excel Report from SysCAD and also discusses a common error when generating Excel reports;
  4. Use Quick View to set up a Table report with selected streams in Excel;
  5. Create a Set Tag report in Excel (send values from Excel to SysCAD);
  6. Process the Excel Set Tag List Report created in the previous exercise.

Create and Generate an Excel Tag List Report

  • Section 11.2: Shows how to create and generate an Excel tag list report.
  • YouTube link (Allows you to watch in Full Screen mode)
  • Build 135.15600

Set up a Table report using Quick View

  • Section 11.3: Shows how to use Quick View to report selected pipes to a table in Excel.
  • YouTube link (Allows you to watch in Full Screen mode)
  • Build 135.15600

Set up a Tag Select report using Quick View

  • Section 11.4: Shows how to use Quick View to set up a select report table in Excel.
  • YouTube link (Allows you to watch in Full Screen mode)
  • Build 135.15600

Generate a Report from SysCAD

  • Section 11.4: Shows how to generate an Excel Report from SysCAD and also discusses a common error when generating Excel reports.
  • YouTube link (Allows you to watch in Full Screen mode)
  • Build 135.15600

Create a Set Tag report in Excel

  • Section 11.5: Shows how to use create a Set Tag List report in Excel.
  • YouTube link (Allows you to watch in Full Screen mode)
  • Build 135.15600


Process a Set Tag report in SysCAD

  • Section 11.5: Shows how to Process a Set Tag List report - i.e. set tags in SysCAD from Excel.
  • YouTube link (Allows you to watch in Full Screen mode)
  • Build 135.15600