Free WinSPC Trial Request a Demo

QualTrend & Custom Web Reporter

Location: DataNet Quality Systems Headquarters

Length: 3 days

What will the attendee take away from this training?

  • An understanding of how to manipulate, correct, and view your data through hands-on practice
  • An ability to create reports in CWR
  • Skill in outputting analyses and graphs to hard copy, files
  • Confidence in publishing reports to the web
  • Knowledge of how to customize QualTrend/CWR to your needs by learning macro building

Who Should Attend?

New users, individuals who will be the key contacts for the software, any user of CWR/QualTrend who is interested in learning more about it.

Prerequisites

  • Familiarity with Quality and SPC
  • Some experience in writing macro programs

Course Outline

  • Introduction to Custom Web Reporter
  • Custom Web Reporter Interface
  • Getting Data
    • Connecting to databases
    • Querying the database
    • Saving Data
  • Data Editing Commands
    • Rename
    • Formatting data
    • Labeling data
  • Data Manipulation Commands
    • Data Creation
    • Copying data
    • Data Management tools – Merge, Match Merge, Concatenate, Missing Values
    • Deleting data
  • Computations, Sorts, and Filters
    • Filtering data
    • Computing data
    • Sorting data
  • Statistical Tools
    • Frequency Tables
    • Multi-way Statistics
    • Frequency Distributions
  • Basic Graphs and Statistics
    • Bar Chart
    • Pie Chart
    • Histogram
    • Box plots
    • XY plots
    • Scatter plots
    • Common Chart Options
    • Multiple Charts
  • Control Charts
    • Variable
      • X bar
      • R chart
      • S chart
      • Individual
      • Mean
      • Moving Average
      • Moving Range
      • Cumulative Sum
      • Process Capability
    • Attribute
      • C Chart
      • NP Chart
      • P Chart
      • U Chart
      • Pareto Chart
  • Recording/Writing Macros
    • Macro Editor
    • Parameters
    • Special macro commands
    • Macro Logic Structures
    • Creating custom reports
  • Web Output
    • Begin web logging
    • Output the reports on the web
  • WinSPC Interaction
    • Connecting to the WinSPC Database
    • Getting Data from the WinSPC database
    • Creating reports and viewing the output
    • Methods specific to the mining of WinSPC data tables
  • Special Custom Web Reporter Commands
  • The basics of Custom Web Reporter’s Standard Form Language