|
IndyASQ Section 0903, American Society for Quality, Indianapolis, Indiana MEMBERSHIP STATUS REPORT |
|||||
|
WI-MSR |
Rev. 0 |
Page 1 |
Date: 7/27/01 |
||
|
Initiated by: W. Haas |
Approved by: |
Issued by: |
|||
To prepare a monthly Membership Status Report for the Executive Committee.
An Internet connected computer system with MS Excel, WinZip, and Email programs.
A copy of the ASQ Database Manual.
3.1 Download monthly Membership Lists (Volunteers Only) data from:
3.2 Extract the SECT0903.ZIP files.
3.3 Open SECTION.XLS file in MS Excel.
3.4 Sort MEMBERTYPE column AA.
3.5 Select and print the Sustaining Members names identified as "U" in column AA.
3.6 Print list.
3.7 Create a PivotTable MEMBERTYPE from column AA.
3.8 Start PivotTable Wizard.
* Drag the MEMBER box into the DATA AREA.
* Drag the MEMBER box into the ROW AREA.
3.9 Print table.
3.10 Open ACTIVITY.XLS file in MS Excel.
3.11 Create a PivotTable REASON from column CI.
3.12 Start PivotTable Wizard.
* Drag the REASON box into the DATA AREA.
* Drag the REASON box into the ROW AREA.
3.13 Print table.
3.14 Open 2001ASQC.XLS in MS Excel.
3.15 Enter data from the PivotTables into the appropriate cells (examples attached). Update the sustaining member's list at the bottom.
3.16 Print report and provide handouts at the Exec Committee Meeting.
3.17 Send the MEMBERSHIP STATUS INFORMATION report to the Exec Committee using the IndyASQ Exec Committee email list.