Basic Tutorial - Excel Reports and Quickview

From SysCAD Documentation
Jump to navigation Jump to search
THE VIDEOS HERE SUPPLEMENT THE SysCADBasicTutorial.pdf, LOCATED IN THE SysCADxxx\Tutorial FOLDER. REFER TO SysCADBasicTutorial FOR DETAILED INSTRUCTIONS.

Navigation: Main_Page -> Tutorial Videos -> Basic Tutorial - Excel Reports and Quickview

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 Quickview

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 Basic SysCAD 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 Quickview 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 Quickview 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 Quickview

  • Section 11.3: Shows how to use Quickview 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 Quickview

  • Section 11.4: Shows how to use Quickview 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