|
© 2007 KnowWare
International, Inc. DBA LifeStar
2253 S. Oneida St., Ste 3D
Denver, CO 80224
Jay Arthur
888-468-1537
303-756-9144
Email Us
We help people think!
|
|
Time Tracking Template
Purpose: To automate the collection of data for the time between
steps within a process (minutes, hours, days, etc).
To accelerate any process, you have to be able to measure and improve
the key steps in that process. To simplify and automate much of this data
collection, the QI Macros include a Time Tracking Template.
Since most people struggle with how to input dates and times into Excel,
we've created a macro to input those for you. Just click on the cells in
columns A, C and D and the template will populate the cell with the current
time and date.
The Process
- Click on the cell in column A to populate the current date.
- Click on the cell in column C when the process starts to populate
the date and time.
- Click on the cell in column D when the process stops to populate the
date and time.
- Populate columns B, E and F with other information about each event.
- Column G is calculated as the difference between the start and stop
time (columns C and D).
- Column H converts column G into minutes. This conversion is usually
necessary to run charts.
- Select the data in column H to run a chart.
- To edit dates or times in columns A, C and D, click on the cell you
want to edit and make changes in Excel's formula bar window.
The Time Tracking template is just one of the tools included in the QI
Macros for Excel SPC Software for Excel.
 Download
the FREE 30-day Evaluation copy of the QI Macros Excel SPC Software for Six
Sigma
Buy the QI Macros Now! Unconditional, No
Questions Asked, 90-day Money-Back Guarantee!
QI Macros Excel SPC Software for Histograms and Control Charts $139 Plus S&H
© 2007 KnowWare International Inc. (888) 468-1537
knowwareman@qimacros.com
Home
| Lean Six Sigma
| QI Macros
| KnowWare
| Site Map
|
Or Buy It Now!
Unconditional
90-Day
Money-Back
Guarantee
The QI Macros for Excel $139,
is an inexpensive easy to use set of Excel add-ins for statistical process control
and Lean Six Sigma. It draws line, pie, bar, pareto, box whisker, histogram (Cp,
Cpk), scatter and control charts (with stability analysis).
It contains over 70 fill in the blank templates such as the Ishikawa diagram,
QFD, DOE, FMEA, PPAP, and Gage R&R for MSA. Performs ANOVA, t-test, F-test,
and regression analysis.
Quantity Discounts
Customer Testimonials
Minitab Comparison
QI Macros FAQs
|
