Home / Monte Carlo / Additional Tools / Scorecard / Scorecard How-To
Scorecard How-To¶
This walkthrough creates a scorecard and charts it. None of the three commands runs a simulation or reads a Monte Carlo model.
Sample Data¶
Five parts on the Part sheet, each with a quantity per assembly and a mean, a standard deviation and two specification limits. That is the Continuous Variable route into the scorecard, the first of the three the sheet offers.
The Part sheet carries its headings in row 12 and its data rows from 13 down. Column C holds the DPU formula the template already has, so the two blocks below skip it: the names go in column B and the numbers in columns D to I.
Press the first button, click cell B12, and press Ctrl+V.
| Part Name |
|---|
| Base plate |
| Spacer |
| Bearing shim |
| Cover |
| Gasket |
Then press the second button, click cell D12, and press Ctrl+V.
| Qty | Target | Mean | StdDev | LSL | USL |
|---|---|---|---|---|---|
| 4 | 25.00 | 25.02 | 0.025 | 24.90 | 25.10 |
| 2 | 12.50 | 12.50 | 0.018 | 12.44 | 12.56 |
| 1 | 3.20 | 3.21 | 0.008 | 3.18 | 3.22 |
| 2 | 8.40 | 8.38 | 0.025 | 8.32 | 8.48 |
| 1 | 1.60 | 1.60 | 0.022 | 1.55 | 1.65 |
Each block's own heading row lands on the sheet's heading row, which carries the same words, and the five parts land in rows 13 through 17.
Steps¶
-
QXL Monte Carlo New > Additional Tools > Scorecard > New Scorecard.
A new workbook is made from the Score Card.xltx template in the Templates folder of the installed product. There is nothing to set: Excel is handed the template.
-
Fill in the scorecard with your parts, processes and performance metrics.
Use the two blocks above: the names into B12 and the numbers into D12, on the Part sheet.
-
Scorecard > Pareto All, with that scorecard as the active sheet.
Every part, process and performance metric becomes a bar, largest first.
What the sheet computes, and the order of the bars¶
The DPU column fills itself in as you paste. For continuous variable data the template's own formula in column C is the normal tail below the LSL plus the tail above the USL, each multiplied by the quantity, so a part fitted twice into the assembly counts twice:
| Part | Qty | DPU |
|---|---|---|
| Bearing shim | 1 | 0.105738 |
| Gasket | 1 | 0.023043 |
| Cover | 2 | 0.016458 |
| Base plate | 4 | 0.002752 |
| Spacer | 2 | 0.001716 |
The summary block at the top of the sheet then reads 10 total parts, a Total DPU of 0.149707, a Yield of 0.860960 and a dpmo of 14,971.
Pareto All draws those five in exactly that order, largest first: Bearing shim, Gasket, Cover, Base plate, Spacer.
The Bearing shim is first by a factor of four and a half, and it is the part with the smallest tolerance and the smallest quantity. The Base plate goes into every assembly four times and sits second from last. That reversal is the point of the scorecard: how much a part contributes depends on how tightly it is held against its limits, not on how many of them there are.
-
Scorecard > Pareto Rollup on the same sheet.
The four summary rows become the bars instead.
Which sheet gets charted¶
The active one. Both Pareto commands read the sheet in front of you, so if you have more than one scorecard open, activate the one you mean before running either command.
Things to try next¶
- Run Pareto All before filling anything in. With nothing to chart the command says so rather than drawing an empty chart.
- Change a value and re-run. The chart is redrawn from the sheet as it stands.
- Compare the two Paretos. All is the detail, Rollup is the summary, and they answer different questions about the same sheet.