QualTrend & CWR

Topics Covered

• 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