I'm just starting out in Access, so this might not be right, but it appears that the best way to do this might be to use an Excel chart as an unbound OLE object and supply the data through VBA code. This sound right? Give me a few days to get some access code for stddev functi...
6 months ago Thomas C Verified Customer QI Macros SPC Software for Excel Excellent product with extensive capability but at a great price. An unmatched product and very user friendly 7 months ago Scott G Verified Customer QI Macros SPC Software for Excel I have used QIMacros for years now, a...
How to Teach Statistical Process Control (SPC)Lately I've become concerned about how people learn statistical process control. Most trainers teach participants how to do all of the calculations manually and then show them how to do it using a tool like the QI Macros for Excel SPC Software....
This is an SPC chart controlled by a slicer that operates a powerpivot table. This is then copied (by cell formula) into a "normal" table where the average, UCL, LCL and Erlang are calculated which are just basic calculations involving average and standard deviation. To make it work t...
Not necessarily. Using fewer data (30 in this case) to arrive at a positive conclusion about capability means that monitoring the production process for continual process improvement could start earlier. By extrapolating the natural process limits—i.e., the 3-sigma limits on the chart for indivi...
This is better than a five-sigma process, i.e., one in which there are five process standard deviations between the mean and the specification limit, which means it is well able to meet the upper specification limit. The center line of the SPC chart for individual meas...
I've noticed recently I take for granted some extensions methods I've been using for a while now that I use on a fairly frequent basis. From getting a file as base64 quickly to to just doing simple JSON operations, here are 5 day to day extension methods
Don’t get caught up in excessive detail. Chart Wizard i incredible and you can always chose your own if you have to drill down deeper. Life changing program. 7 months ago Walter G Verified Customer QI Macros SPC Software for Excel QI Macros SPC allows us to show our customers that we...
How to Change Control Chart Stability Rules in QI Macros Click on the QI Macros menu, Control Charts (SPC), and then Control Charts Rules: Select the control chart rules you want to use. Depending on how fast your version of Excel is, you should see QI Macros updating the rules file. ...
X bar R Chart formula * "Introduction to Statistical Quality Control,"Douglas C. Montgomery * The secret formula to ignoring all other formulas: QI Macros SPC Software! QI Macros is an easy to use add-in for Excel that installs a new tab on Excel's toolbar. ...