Spreadsheet: 864637d1711726158-conditional-formatting-with-if-command-testing
Sheet: TABLE

Characteristic | Feature | Nominal | UL | LL | Actual | Unit | Min Concession Limit | Max Concession Limit | Status
1U | Diameter | 7 | 0.1 | -0.1 | 7 | [NAME] |  |  | PASS | IF Actual is between UL and LL, unless Min and/or Max Concession are present, overwriting UL / LL | 1) | Everything between A and G should be empty, CSV will pull everything in
1V | Diameter | 7 | 0.1 | -0.1 | 7 | [NAME] |  |  | FAIL | IF Actual is not between UL and LL, or [NAME] limit if they are present | 2) | Data > Get from CSV > Select file in Report Folder
1W | Diameter | 7 | 0.1 | -0.1 | 7 | [NAME] |  |  |  |  | 3) | Copy measurement value and "Paste as Value" from A2 in table
2U | Position | 0 | 0.85 | 0 | 0 | [NAME] |  |  |  |  | 3) | Right Click 1U > Sort > Custom Sort > Select "1U, 1V, 1W"
2V | Position | 0 | 0.85 | 0 | 0 | [NAME] |  |  |  |  | 4) | PASS/FAIL is generated automatically, when a Min or [NAME] concession limit is added it will use those values, else leave blank
2W | Position | 0 | 0.85 | 0 | 0 | [NAME] |  |  |  |  | Note** MMC is pulled in automatically from CMM
4_INT | Diameter | 12.5 | 0.1 | -0.1 | 12.5 | [NAME] |  |  |  |  | Test using 'CSV EXAMPLE' sheet
4_INT_FORM | Circularity | 0 | 0.2 | 0 | 0 | [NAME]
4_EXT | Diameter | 12.5 | 0.1 | -0.1 | 12.5 | [NAME]
4_EXT_FORM | Circularity | 0 | 0.2 | 0 | 0 | [NAME]
5_INT | Position of axis | 0 | 0.6 | 0 | 0 | [NAME]
5_EXT | Position of axis | 0 | 0.6 | 0 | 0 | [NAME]
6_INT | Parallelism | 0 | 0.2 | 0 | 0 | [NAME]
6_EXT | Parallelism | 0 | 0.2 | 0 | 0 | [NAME]
7_INT | Position X | -0.075 | 0.075 | -0.1 | -0.075 | [NAME]
7_EXT | Position X | -0.075 | 0.075 | -0.1 | -0.075 | [NAME]
8 | Diameter | 8 | 0.022 | 0 | 8 | [NAME]
9 | Position | 0 | 0.1 | 0 | 0 | [NAME]
10 | Diameter | 8 | 0.022 | 0 | 8 | [NAME]
11 | Position | 0 | 0.1 | 0 | 0 | [NAME]
12_A1 | Diameter | 6.8 | 0.1 | 0 | 6.8 | [NAME]
12_A2 | Diameter | 6.8 | 0.1 | 0 | 6.8 | [NAME]
12_A3 | Diameter | 6.8 | 0.1 | 0 | 6.8 | [NAME]
12_A4 | Diameter | 6.8 | 0.1 | 0 | 6.8 | [NAME]
12_A5 | Diameter | 6.8 | 0.1 | 0 | 6.8 | [NAME]
12_A6 | Diameter | 6.8 | 0.1 | 0 | 6.8 | [NAME]
12_A7 | Diameter | 6.8 | 0.1 | 0 | 6.8 | [NAME]
12_A8 | Diameter | 6.8 | 0.1 | 0 | 6.8 | [NAME]
13_A1 | Position of axis | 0 | 0.7 | 0 | 0.001 | [NAME]
13_A2 | Position of axis | 0 | 0.7 | 0 | 0.001 | [NAME]
13_A3 | Position of axis | 0 | 0.7 | 0 | 0.001 | [NAME]
13_A4 | Position of axis | 0 | 0.7 | 0 | 0.001 | [NAME]
13_A5 | Position of axis | 0 | 0.7 | 0 | 0.001 | [NAME]
13_A6 | Position of axis | 0 | 0.7 | 0 | 0.001 | [NAME]
13_A7 | Position of axis | 0 | 0.7 | 0 | 0.001 | [NAME]
13_A8 | Position of axis | 0 | 0.7 | 0 | 0.001 | [NAME]
14 | Diameter | 52.25 | 0.48 | -0.19 | 52.25 | [NAME]
15 | Position of axis | 0 | 0.73 | 0 | 0 | [NAME]
16 | Flatness | 0 | 0.3 | 0 | 0 | [NAME]
17 | Position X | 16.505 | 0.65 | -0.65 | 16.555 | [NAME]
18 | Position X | 52.15 | 0.25 | -0.25 | 52.1 | [NAME]
19 | Position X | 93.15 | 0.65 | -0.65 | 93.15 | [NAME]
20_A1 | Diameter | 6.6 | 0.1 | -0.1 | 6.6 | [NAME]
20_A2 | Diameter | 6.6 | 0.1 | -0.1 | 6.6 | [NAME]
20_A3 | Diameter | 6.6 | 0.1 | -0.1 | 6.6 | [NAME]
20_A4 | Diameter | 6.6 | 0.1 | -0.1 | 6.6 | [NAME]
20_A5 | Diameter | 6.6 | 0.1 | -0.1 | 6.6 | [NAME]
20_A6 | Diameter | 6.6 | 0.1 | -0.1 | 6.6 | [NAME]
20_A7 | Diameter | 6.6 | 0.1 | -0.1 | 6.6 | [NAME]
20_A8 | Diameter | 6.6 | 0.1 | -0.1 | 6.6 | [NAME]
21_A1 | Position | 0 | 0.3 | 0 | 0.001 | [NAME]
21_A2 | Position | 0 | 0.3 | 0 | 0.001 | [NAME]
21_A3 | Position | 0 | 0.3 | 0 | 0.001 | [NAME]
21_A4 | Position | 0 | 0.3 | 0 | 0.001 | [NAME]
21_A5 | Position | 0 | 0.3 | 0 | 0.001 | [NAME]
21_A6 | Position | 0 | 0.3 | 0 | 0.001 | [NAME]
21_A7 | Position | 0 | 0.3 | 0 | 0.001 | [NAME]
21_A8 | Position | 0 | 0.3 | 0 | 0.001 | [NAME]
22 | [NAME] calculation | 25.397 | 0.077 | 0 | 25.435
23 | Diameter | 10 | 0.028 | 0.013 | 10 | [NAME]
24 | Position of axis | 0 | 0.05 | 0 | 0 | [NAME]
25 | Diameter | 10 | 0.028 | 0.013 | 10 | [NAME]
26 | Position of axis | 0 | 0.05 | 0 | 0.001 | [NAME]
Spline_GO | [NAME] calculation | 1 | 0 | 0 | 1
Spline_NOGO | [NAME] calculation | 0 | 0 | 0 | 0
Phase_Panel | [NAME] calculation | 1 | 0 | 0 | 1