Analysis of series on a graph

[Ca1icoJack]

Is it possible for excel to calculate the number of series which at some point go out of tolerance?

e.g. If a series 1 is the lower tolerance and series 2 is the upper tolerance can I check to see whether series 3 lies within this range or not?

The number of values used for the upper tolerance, lower tolerance and other series are not equal so I cannot compare values this way, nor are the x-axis values the same.

Thank you for your help

 

[SkipVought]

Hi,

The number of values used for the upper tolerance, lower tolerance and other series are not equal so I cannot compare values this way, nor are the x-axis values the same.

Perhaps you could post an example of your source data that illustrates this condition.

the number of series which at some point go out of tolerance?

What does that mean?



Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[Ca1icoJack]

Basically the upper tolerance has a greater number of data points than the lower or actual measured data.

By that I mean that if I am analysing 100 data series I'd like to know how many go outside of the upper tolerance and how many outside of the lower tolerance. So if you drew two curves on a graph, one upper and one lower, most other series should lie within them. If a point doesn't that series will fail the test.

I can't upload the data anywhere so I'm afraid you'll have to make do with my explanations.

 

[SkipVought]

I can't upload the data anywhere so I'm afraid you'll have to make do with my explanations.

REALLY???

Example:
[tt]
Ser1 Ser2 Ser3
11 22 33
22 33 44
33 44 55
[/tt]
Hmmmmmmmmmm.......

You can do better than that!

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[Ca1icoJack]

Here's a full set of tolerances, we only use the tolerances from x = ~0 to x = ~1 so some at the bottom are unused.

Columns in pairs: Nominal, Lower, Upper, Actual.

Nominal and Actual are y then x
Lower and upper are x then y

Nominal Lower Tolerance Upper Tolerance Actual
y x x y x y y x
0.0060 0.0000 0.0800 -0.2756 -0.0750 0.2983 0.0592 0.0000
0.0060 0.0011 0.0808 -0.2756 -0.0739 0.2984 0.0616 0.0006
0.0060 0.0021 0.0817 -0.2756 -0.0729 0.2985 0.0648 0.0012
0.0061 0.0032 0.0825 -0.2756 -0.0718 0.2985 0.0641 0.0018
0.0061 0.0042 0.0833 -0.2756 -0.0708 0.2985 0.0641 0.0025
0.0060 0.0053 0.0841 -0.2756 -0.0697 0.2984 0.0706 0.0032
0.0059 0.0064 0.0850 -0.2757 -0.0686 0.2982 0.0844 0.0040
0.0057 0.0074 0.0858 -0.2758 -0.0676 0.2980 0.1008 0.0048
0.0057 0.0085 0.0866 -0.2758 -0.0665 0.2980 0.1092 0.0056
0.0058 0.0096 0.0875 -0.2758 -0.0654 0.2981 0.1039 0.0063
0.0059 0.0106 0.0883 -0.2757 -0.0644 0.2983 0.0911 0.0069
0.0060 0.0117 0.0891 -0.2756 -0.0633 0.2983 0.0839 0.0076
0.0059 0.0128 0.0900 -0.2757 -0.0622 0.2982 0.0819 0.0082
0.0057 0.0139 0.0908 -0.2758 -0.0611 0.2980 0.0843 0.0089
0.0056 0.0149 0.0916 -0.2759 -0.0601 0.2979 0.0902 0.0097
0.0056 0.0160 0.0925 -0.2759 -0.0590 0.2978 0.0971 0.0104
0.0056 0.0171 0.0933 -0.2759 -0.0579 0.2978 0.1053 0.0112
0.0055 0.0181 0.0942 -0.2760 -0.0569 0.2977 0.1139 0.0121
0.0055 0.0192 0.0950 -0.2760 -0.0558 0.2977 0.1183 0.0130
0.0055 0.0203 0.0958 -0.2760 -0.0547 0.2977 0.1138 0.0139
0.0056 0.0214 0.0967 -0.2759 -0.0536 0.2978 0.1004 0.0148
0.0058 0.0224 0.0975 -0.2758 -0.0526 0.2981 0.0797 0.0156
0.0059 0.0235 0.0984 -0.2757 -0.0515 0.2983 0.0582 0.0164
0.0061 0.0246 0.0992 -0.2756 -0.0504 0.2985 0.0437 0.0174
0.0061 0.0257 0.1000 -0.2755 -0.0493 0.2986 0.0404 0.0183
0.0060 0.0268 0.1009 -0.2756 -0.0482 0.2984 0.0486 0.0193
0.0058 0.0278 0.1017 -0.2758 -0.0472 0.2981 0.0624 0.0204
0.0056 0.0289 0.1026 -0.2759 -0.0461 0.2979 0.0735 0.0214
0.0056 0.0300 0.1034 -0.2759 -0.0450 0.2978 0.0829 0.0224
0.0057 0.0311 0.1042 -0.2758 -0.0439 0.2980 0.0896 0.0234
0.0058 0.0322 0.1051 -0.2757 -0.0428 0.2982 0.0925 0.0242
0.0059 0.0332 0.1059 -0.2757 -0.0418 0.2982 0.0917 0.0250
0.0059 0.0343 0.1068 -0.2757 -0.0407 0.2982 0.0879 0.0258
0.0059 0.0354 0.1076 -0.2757 -0.0396 0.2983 0.0845 0.0266
0.0061 0.0365 0.1085 -0.2756 -0.0385 0.2985 0.0918 0.0275
0.0062 0.0376 0.1093 -0.2755 -0.0374 0.2987 0.1146 0.0285
0.0063 0.0387 0.1102 -0.2754 -0.0363 0.2989 0.1404 0.0297
0.0064 0.0398 0.1110 -0.2753 -0.0352 0.2990 0.1632 0.0309
0.0065 0.0408 0.1119 -0.2752 -0.0342 0.2992 0.1798 0.0321
0.0069 0.0419 0.1127 -0.2749 -0.0331 0.2997 0.1875 0.0333
0.0078 0.0430 0.1136 -0.2743 -0.0320 0.3009 0.1865 0.0344
0.0093 0.0441 0.1144 -0.2732 -0.0309 0.3031 0.1742 0.0355
0.0119 0.0452 0.1153 -0.2713 -0.0298 0.3066 0.1488 0.0365
0.0155 0.0463 0.1162 -0.2687 -0.0287 0.3117 0.1210 0.0377
0.0201 0.0474 0.1170 -0.2654 -0.0276 0.3181 0.1082 0.0389
0.0255 0.0485 0.1179 -0.2614 -0.0265 0.3257 0.1111 0.0402
0.0319 0.0496 0.1187 -0.2567 -0.0254 0.3346 0.1148 0.0416
0.0392 0.0507 0.1196 -0.2514 -0.0243 0.3449 0.1090 0.0431
0.0473 0.0518 0.1204 -0.2455 -0.0232 0.3563 0.1023 0.0444
0.0560 0.0529 0.1213 -0.2391 -0.0221 0.3684 0.1026 0.0457
0.0648 0.0540 0.1222 -0.2327 -0.0210 0.3807 0.1031 0.0469
0.0735 0.0551 0.1230 -0.2263 -0.0199 0.3929 0.0978 0.0482
0.0824 0.0562 0.1239 -0.2198 -0.0188 0.4054 0.0931 0.0496
0.0915 0.0573 0.1248 -0.2132 -0.0177 0.4181 0.0922 0.0509
0.1006 0.0585 0.1257 -0.2065 -0.0165 0.4309 0.0998 0.0522
0.1097 0.0596 0.1266 -0.1999 -0.0154 0.4435 0.1164 0.0535
0.1184 0.0608 0.1275 -0.1936 -0.0142 0.4557 0.1301 0.0550
0.1264 0.0620 0.1284 -0.1877 -0.0130 0.4670 0.1417 0.0566
0.1335 0.0632 0.1294 -0.1825 -0.0118 0.4770 0.1595 0.0581
0.1395 0.0644 0.1304 -0.1782 -0.0106 0.4853 0.1753 0.0594
0.1444 0.0657 0.1314 -0.1746 -0.0093 0.4922 0.1703 0.0607
0.1484 0.0670 0.1323 -0.1717 -0.0080 0.4977 0.1483 0.0621
0.1514 0.0683 0.1334 -0.1695 -0.0067 0.5019 0.1282 0.0636
0.1536 0.0696 0.1344 -0.1679 -0.0054 0.5050 0.1231 0.0651
0.1551 0.0709 0.1354 -0.1668 -0.0041 0.5071 0.1256 0.0667
0.1563 0.0723 0.1365 -0.1659 -0.0027 0.5088 0.1221 0.0685
0.1574 0.0736 0.1376 -0.1651 -0.0014 0.5104 0.1142 0.0703
0.1588 0.0750 0.1387 -0.1640 0.0000 0.5124 0.1123 0.0720
0.1604 0.0764 0.1398 -0.1629 0.0014 0.5146 0.1178 0.0737
0.1622 0.0779 0.1409 -0.1616 0.0029 0.5170 0.1207 0.0754
0.1640 0.0793 0.1421 -0.1603 0.0043 0.5196 0.1157 0.0770
0.1660 0.0808 0.1432 -0.1589 0.0058 0.5223 0.1043 0.0787
0.1681 0.0823 0.1444 -0.1573 0.0073 0.5253 0.0983 0.0804
0.1704 0.0838 0.1456 -0.1556 0.0088 0.5285 0.0998 0.0820
0.1729 0.0853 0.1468 -0.1538 0.0103 0.5321 0.1017 0.0837
0.1757 0.0869 0.1480 -0.1518 0.0119 0.5359 0.0996 0.0854
0.1784 0.0885 0.1493 -0.1498 0.0135 0.5398 0.0989 0.0870
0.1812 0.0901 0.1505 -0.1477 0.0151 0.5437 0.1063 0.0887
0.1840 0.0917 0.1518 -0.1457 0.0167 0.5476 0.1176 0.0904
0.1868 0.0933 0.1531 -0.1436 0.0183 0.5515 0.1266 0.0923
0.1896 0.0950 0.1544 -0.1416 0.0200 0.5555 0.1323 0.0942
0.1924 0.0967 0.1558 -0.1396 0.0217 0.5594 0.1390 0.0961
0.1950 0.0984 0.1571 -0.1376 0.0234 0.5631 0.1454 0.0980
0.1975 0.1002 0.1585 -0.1358 0.0252 0.5666 0.1452 0.0999
0.1999 0.1019 0.1599 -0.1341 0.0269 0.5699 0.1375 0.1018
0.2022 0.1037 0.1613 -0.1324 0.0287 0.5730 0.1318 0.1038
0.2044 0.1056 0.1628 -0.1308 0.0306 0.5761 0.1285 0.1057
0.2066 0.1074 0.1642 -0.1292 0.0324 0.5793 0.1232 0.1077
0.2089 0.1093 0.1657 -0.1275 0.0343 0.5824 0.1158 0.1096
0.2111 0.1112 0.1672 -0.1259 0.0362 0.5855 0.1098 0.1116
0.2133 0.1131 0.1687 -0.1243 0.0381 0.5886 0.1088 0.1135
0.2155 0.1151 0.1703 -0.1227 0.0401 0.5918 0.1176 0.1155
0.2180 0.1170 0.1719 -0.1209 0.0420 0.5951 0.1341 0.1176
0.2205 0.1190 0.1735 -0.1190 0.0440 0.5987 0.1442 0.1196
0.2232 0.1211 0.1751 -0.1171 0.0461 0.6024 0.1479 0.1218
0.2258 0.1231 0.1767 -0.1152 0.0481 0.6061 0.1528 0.1238
0.2284 0.1252 0.1784 -0.1133 0.0502 0.6097 0.1602 0.1259
0.2310 0.1273 0.1801 -0.1114 0.0523 0.6134 0.1654 0.1280
0.2336 0.1295 0.1818 -0.1095 0.0545 0.6170 0.1649 0.1301
0.2362 0.1316 0.1835 -0.1076 0.0566 0.6207 0.1596 0.1323
0.2389 0.1339 0.1853 -0.1056 0.0589 0.6245 0.1526 0.1344
0.2417 0.1361 0.1871 -0.1036 0.0611 0.6283 0.1480 0.1367
0.2445 0.1384 0.1889 -0.1015 0.0634 0.6323 0.1479 0.1390
0.2473 0.1407 0.1907 -0.0994 0.0657 0.6363 0.1541 0.1414
0.2501 0.1430 0.1926 -0.0974 0.0680 0.6402 0.1632 0.1437
0.2530 0.1453 0.1945 -0.0953 0.0703 0.6442 0.1677 0.1460
0.2560 0.1477 0.1964 -0.0931 0.0727 0.6484 0.1755 0.1483
0.2591 0.1501 0.1983 -0.0908 0.0751 0.6528 0.1855 0.1506
0.2625 0.1526 0.2003 -0.0884 0.0776 0.6574 0.1963 0.1530
0.2660 0.1551 0.2023 -0.0858 0.0801 0.6624 0.2105 0.1555
0.2698 0.1576 0.2043 -0.0830 0.0826 0.6677 0.2245 0.1579
0.2741 0.1601 0.2064 -0.0799 0.0851 0.6738 0.2282 0.1604
0.2789 0.1627 0.2085 -0.0764 0.0877 0.6804 0.2185 0.1627
0.2840 0.1653 0.2106 -0.0727 0.0903 0.6876 0.2040 0.1651
0.2895 0.1680 0.2127 -0.0687 0.0930 0.6952 0.1866 0.1675
0.2951 0.1707 0.2149 -0.0646 0.0957 0.7032 0.1724 0.1701
0.3009 0.1734 0.2171 -0.0603 0.0984 0.7113 0.1630 0.1727
0.3068 0.1761 0.2193 -0.0561 0.1011 0.7195 0.1585 0.1755
0.3126 0.1789 0.2216 -0.0518 0.1039 0.7277 0.1580 0.1783
0.3185 0.1817 0.2239 -0.0475 0.1067 0.7359 0.1544 0.1811
0.3244 0.1846 0.2262 -0.0432 0.1096 0.7441 0.1535 0.1840
0.3303 0.1875 0.2286 -0.0389 0.1125 0.7524 0.1631 0.1868
0.3361 0.1905 0.2310 -0.0346 0.1155 0.7606 0.1693 0.1896
0.3420 0.1934 0.2335 -0.0304 0.1184 0.7687 0.1667 0.1924
0.3479 0.1965 0.2360 -0.0260 0.1215 0.7770 0.1581 0.1951
0.3542 0.1995 0.2385 -0.0214 0.1245 0.7859 0.1451 0.1978
0.3613 0.2027 0.2410 -0.0163 0.1277 0.7958 0.1378 0.2005
0.3692 0.2058 0.2436 -0.0105 0.1308 0.8068 0.1566 0.2031
0.3781 0.2090 0.2463 -0.0040 0.1340 0.8194 0.1883 0.2058
0.3884 0.2123 0.2490 0.0035 0.1373 0.8338 0.2183 0.2086
0.4000 0.2155 0.2517 0.0120 0.1405 0.8500 0.2591 0.2116
0.4129 0.2189 0.2544 0.0214 0.1439 0.8681 0.3134 0.2146
0.4270 0.2223 0.2573 0.0317 0.1473 0.8878 0.3691 0.2176
0.4419 0.2257 0.2601 0.0426 0.1507 0.9086 0.4149 0.2207
0.4573 0.2291 0.2630 0.0538 0.1541 0.9302 0.4409 0.2238
0.4729 0.2327 0.2659 0.0652 0.1577 0.9521 0.4463 0.2268
0.4885 0.2362 0.2689 0.0766 0.1612 0.9739 0.4428 0.2298
0.5038 0.2398 0.2719 0.0878 0.1648 0.9954 0.4390 0.2329
0.5190 0.2435 0.2750 0.0989 0.1685 1.0166 0.4385 0.2361
0.5340 0.2473 0.2782 0.1098 0.1723 1.0377 0.4422 0.2396
0.5488 0.2511 0.2814 0.1206 0.1761 1.0583 0.4515 0.2432
0.5628 0.2549 0.2847 0.1309 0.1799 1.0779 0.4675 0.2467
0.5760 0.2589 0.2880 0.1405 0.1839 1.0965 0.4864 0.2504
0.5884 0.2629 0.2914 0.1496 0.1879 1.1138 0.4972 0.2542
0.6002 0.2670 0.2949 0.1582 0.1920 1.1303 0.5189 0.2580
0.6119 0.2711 0.2985 0.1667 0.1961 1.1467 0.5553 0.2618
0.6242 0.2754 0.3021 0.1757 0.2004 1.1639 0.5744 0.2655
0.6377 0.2797 0.3058 0.1855 0.2047 1.1828 0.6007 0.2693
0.6534 0.2840 0.3095 0.1970 0.2090 1.2047 0.6259 0.2731
0.6723 0.2884 0.3133 0.2108 0.2134 1.2312 0.6614 0.2770
0.6955 0.2929 0.3172 0.2277 0.2179 1.2637 0.7195 0.2810
0.7239 0.2975 0.3212 0.2484 0.2225 1.3034 0.8088 0.2852
0.7581 0.3021 0.3252 0.2734 0.2271 1.3514 0.8925 0.2895
0.7986 0.3068 0.3293 0.3030 0.2318 1.4081 0.9796 0.2938
0.8455 0.3116 0.3335 0.3372 0.2366 1.4738 1.0658 0.2981
0.8992 0.3164 0.3377 0.3764 0.2414 1.5488 1.1455 0.3026
0.9603 0.3213 0.3421 0.4210 0.2463 1.6345 1.2747 0.3072
1.0310 0.3263 0.3465 0.4726 0.2513 1.7333 1.4025 0.3121
1.1103 0.3314 0.3510 0.5305 0.2564 1.8445 1.5276 0.3170
1.1948 0.3366 0.3556 0.5922 0.2616 1.9628 1.6708 0.3223
1.2815 0.3419 0.3603 0.6555 0.2669 2.0841 1.8157 0.3276
1.3702 0.3473 0.3652 0.7202 0.2723 2.2083 1.9371 0.3331
1.4630 0.3528 0.3702 0.7880 0.2778 2.3382 2.0761 0.3387
1.5602 0.3585 0.3753 0.8590 0.2835 2.4743 2.1857 0.3447
1.6586 0.3643 0.3806 0.9308 0.2893 2.6120 2.2659 0.3507
1.7541 0.3702 0.3860 1.0005 0.2952 2.7457 2.3716 0.3571
1.8460 0.3763 0.3916 1.0676 0.3013 2.8745 2.4541 0.3635
1.9411 0.3826 0.3973 1.1370 0.3076 3.0076 2.4866 0.3701
2.0453 0.3890 0.4032 1.2130 0.3140 3.1534 2.5036 0.3773
2.1511 0.3956 0.4094 1.2903 0.3206 3.3016 2.5189 0.3846
2.2472 0.4024 0.4157 1.3605 0.3274 3.4361 2.5633 0.3921
2.3270 0.4093 0.4221 1.4187 0.3343 3.5478 2.6146 0.3999
2.3900 0.4164 0.4288 1.4647 0.3414 3.6360 2.5942 0.4079
2.4383 0.4235 0.4355 1.4999 0.3485 3.7036 2.5417 0.4159
2.4801 0.4309 0.4425 1.5305 0.3559 3.7622 2.4889 0.4240
2.5226 0.4383 0.4496 1.5615 0.3633 3.8216 2.4246 0.4321
2.5631 0.4459 0.4569 1.5910 0.3709 3.8783 2.3485 0.4403
2.5993 0.4536 0.4643 1.6175 0.3786 3.9290 2.2975 0.4487
2.6355 0.4613 0.4719 1.6439 0.3863 3.9797 2.2330 0.4571
2.6774 0.4692 0.4795 1.6745 0.3942 4.0383 2.1745 0.4655
2.7350 0.4772 0.4874 1.7165 0.4022 4.1190 2.1449 0.4739
2.8069 0.4852 0.4953 1.7690 0.4102 4.2196 2.0675 0.4824
2.8776 0.4932 0.5032 1.8207 0.4182 4.3187 2.0548 0.4908
2.9256 0.5012 0.5112 1.8557 0.4262 4.3859 2.0794 0.4993
2.9431 0.5093 0.5193 1.8684 0.4343 4.4103 2.1186 0.5077
2.9439 0.5173 0.4973 1.8590 0.5823 4.4114 2.1185 0.5162
2.9428 0.5253 0.5053 1.8582 0.5903 4.4099 2.0982 0.5246
2.9431 0.5333 0.5133 1.8585 0.5983 4.4104 2.0831 0.5330
2.9299 0.5412 0.5212 1.8488 0.6062 4.3919 2.1248 0.5413
2.8954 0.5490 0.5290 1.8236 0.6140 4.3435 2.2024 0.5496
2.8393 0.5567 0.5367 1.7827 0.6217 4.2650 2.2313 0.5577
2.7668 0.5643 0.5443 1.7298 0.6293 4.1636 2.2546 0.5657
2.6865 0.5716 0.5516 1.6711 0.6366 4.0510 2.2863 0.5738
2.5973 0.5788 0.5588 1.6060 0.6438 3.9262 2.3156 0.5819
2.4889 0.5857 0.5657 1.5269 0.6507 3.7745 2.3166 0.5895
2.3559 0.5926 0.5726 1.4298 0.6576 3.5883 2.3195 0.5969
2.2001 0.5993 0.5793 1.3160 0.6643 3.3701 2.3030 0.6044
2.0313 0.6059 0.5859 1.1929 0.6709 3.1339 2.2991 0.6119
1.8656 0.6123 0.5923 1.0719 0.6773 2.9018 2.2341 0.6189
1.7172 0.6186 0.5986 0.9636 0.6836 2.6941 2.1599 0.6257
1.5878 0.6247 0.6047 0.8691 0.6897 2.5129 2.0828 0.6322
1.4691 0.6307 0.6107 0.7824 0.6957 2.3467 2.0418 0.6386
1.3569 0.6366 0.6166 0.7005 0.7016 2.1896 1.9778 0.6448
1.2529 0.6425 0.6225 0.6246 0.7075 2.0441 1.8912 0.6507
1.1703 0.6483 0.6283 0.5643 0.7133 1.9284 1.7710 0.6565
1.1104 0.6540 0.6340 0.5206 0.7190 1.8446 1.6498 0.6621
1.0646 0.6596 0.6396 0.4871 0.7246 1.7804 1.5844 0.6677
1.0252 0.6651 0.6451 0.4584 0.7301 1.7253 1.5003 0.6730
0.9900 0.6706 0.6506 0.4327 0.7356 1.6760 1.3953 0.6782
0.9601 0.6759 0.6559 0.4109 0.7409 1.6341 1.2794 0.6832
0.9392 0.6812 0.6612 0.3956 0.7462 1.6048 1.2143 0.6882
0.9270 0.6863 0.6663 0.3867 0.7513 1.5878 1.1504 0.6930
0.9163 0.6914 0.6714 0.3789 0.7564 1.5728 1.0897 0.6976
0.9030 0.6963 0.6763 0.3692 0.7613 1.5542 1.0092 0.7019
0.8872 0.7012 0.6812 0.3577 0.7662 1.5321 0.9259 0.7063
0.8689 0.7060 0.6860 0.3443 0.7710 1.5064 0.8591 0.7107
0.8480 0.7106 0.6906 0.3290 0.7756 1.4772 0.7979 0.7149
0.8247 0.7152 0.6952 0.3120 0.7802 1.4446 0.7175 0.7189
0.7994 0.7197 0.6997 0.2936 0.7847 1.4092 0.6507 0.7228
0.7726 0.7241 0.7041 0.2740 0.7891 1.3716 0.6032 0.7266
0.7446 0.7284 0.7084 0.2536 0.7934 1.3325 0.5659 0.7304
0.7162 0.7326 0.7126 0.2328 0.7976 1.2926 0.5314 0.7340
0.6877 0.7367 0.7167 0.2120 0.8017 1.2527 0.4919 0.7375
0.6596 0.7408 0.7208 0.1915 0.8058 1.2135 0.4621 0.7410
0.6325 0.7448 0.7248 0.1717 0.8098 1.1754 0.4359 0.7446
0.6066 0.7487 0.7287 0.1528 0.8137 1.1392 0.4136 0.7482
0.5823 0.7526 0.7326 0.1351 0.8176 1.1053 0.3756 0.7519
0.5598 0.7564 0.7364 0.1187 0.8214 1.0738 0.3323 0.7555
0.5391 0.7601 0.7401 0.1035 0.8251 1.0447 0.3006 0.7590
0.5198 0.7638 0.7438 0.0895 0.8288 1.0178 0.2825 0.7625
0.5022 0.7675 0.7475 0.0766 0.8325 0.9931 0.2744 0.7658
0.4861 0.7710 0.7510 0.0649 0.8360 0.9706 0.2590 0.7690
0.4717 0.7746 0.7546 0.0544 0.8396 0.9504 0.2399 0.7721
0.4588 0.7780 0.7580 0.0449 0.8430 0.9323 0.2284 0.7753
0.4472 0.7814 0.7614 0.0364 0.8464 0.9160 0.2178 0.7784
0.4365 0.7848 0.7648 0.0286 0.8498 0.9011 0.2097 0.7815
0.4266 0.7881 0.7681 0.0214 0.8531 0.8873 0.2041 0.7846
0.4174 0.7914 0.7714 0.0147 0.8564 0.8743 0.1991 0.7877
0.4086 0.7946 0.7746 0.0082 0.8596 0.8620 0.1916 0.7907
0.4001 0.7978 0.7778 0.0020 0.8628 0.8501 0.1798 0.7937
0.3917 0.8009 0.7809 -0.0040 0.8659 0.8384 0.1746 0.7968
0.3835 0.8040 0.7840 -0.0100 0.8690 0.8270 0.1793 0.7999
0.3754 0.8070 0.7870 -0.0159 0.8720 0.8156 0.1920 0.8030
0.3674 0.8100 0.7900 -0.0218 0.8750 0.8043 0.2049 0.8061
0.3595 0.8129 0.7929 -0.0276 0.8779 0.7933 0.2145 0.8092
0.3519 0.8158 0.7958 -0.0331 0.8808 0.7826 0.2231 0.8123
0.3444 0.8186 0.7986 -0.0386 0.8836 0.7721 0.2389 0.8153
0.3371 0.8215 0.8015 -0.0439 0.8865 0.7619 0.2653 0.8182
0.3299 0.8242 0.8042 -0.0492 0.8892 0.7519 0.2894 0.8209
0.3229 0.8270 0.8070 -0.0543 0.8920 0.7421 0.3034 0.8236
0.3160 0.8297 0.8097 -0.0593 0.8947 0.7325 0.3078 0.8262
0.3093 0.8323 0.8123 -0.0642 0.8973 0.7231 0.3006 0.8290
0.3029 0.8349 0.8149 -0.0689 0.8999 0.7140 0.2841 0.8318
0.2967 0.8375 0.8175 -0.0734 0.9025 0.7053 0.2621 0.8344
0.2907 0.8401 0.8201 -0.0778 0.9051 0.6970 0.2389 0.8369
0.2850 0.8426 0.8226 -0.0819 0.9076 0.6891 0.2229 0.8394
0.2796 0.8450 0.8250 -0.0859 0.9100 0.6815 0.2071 0.8419
0.2745 0.8475 0.8275 -0.0896 0.9125 0.6743 0.1872 0.8443
0.2698 0.8499 0.8299 -0.0931 0.9149 0.6677 0.1723 0.8466
0.2653 0.8523 0.8323 -0.0963 0.9173 0.6614 0.1691 0.8490
0.2611 0.8546 0.8346 -0.0994 0.9196 0.6555 0.1718 0.8514
0.2569 0.8569 0.8369 -0.1024 0.9219 0.6497 0.1712 0.8538
0.2529 0.8592 0.8392 -0.1053 0.9242 0.6441 0.1637 0.8562
0.2491 0.8614 0.8414 -0.1082 0.9264 0.6387 0.1482 0.8586
0.2453 0.8636 0.8436 -0.1109 0.9286 0.6335 0.1366 0.8610
0.2416 0.8658 0.8458 -0.1136 0.9308 0.6283 0.1348 0.8634
0.2379 0.8680 0.8480 -0.1163 0.9330 0.6231 0.1373 0.8657
0.2342 0.8701 0.8501 -0.1190 0.9351 0.6179 0.1367 0.8681
0.2306 0.8722 0.8522 -0.1217 0.9372 0.6128 0.1327 0.8704
0.2268 0.8743 0.8543 -0.1244 0.9393 0.6075 0.1299 0.8726
0.2228 0.8763 0.8563 -0.1274 0.9413 0.6019 0.1291 0.8748
0.2184 0.8783 0.8583 -0.1305 0.9433 0.5958 0.1271 0.8769
0.2138 0.8803 0.8603 -0.1339 0.9453 0.5893 0.1243 0.8790
0.2090 0.8823 0.8623 -0.1374 0.9473 0.5826 0.1344 0.8811
0.2041 0.8842 0.8642 -0.1410 0.9492 0.5758 0.1499 0.8832
0.1993 0.8861 0.8661 -0.1445 0.9511 0.5690 0.1618 0.8854
0.1947 0.8880 0.8680 -0.1479 0.9530 0.5626 0.1762 0.8876
0.1906 0.8898 0.8698 -0.1509 0.9548 0.5568 0.1960 0.8897
0.1872 0.8917 0.8717 -0.1534 0.9567 0.5520 0.2189 0.8917
0.1846 0.8935 0.8735 -0.1553 0.9585 0.5484 0.2417 0.8937
0.1829 0.8953 0.8753 -0.1565 0.9603 0.5460 0.2590 0.8958
0.1822 0.8970 0.8770 -0.1570 0.9620 0.5450 0.2540 0.8979
0.1825 0.8988 0.8788 -0.1567 0.9638 0.5456 0.2333 0.9001
0.1840 0.9005 0.8805 -0.1557 0.9655 0.5475 0.2149 0.9022
0.1863 0.9022 0.8822 -0.1540 0.9672 0.5509 0.2004 0.9043
0.1897 0.9039 0.8839 -0.1515 0.9689 0.5555 0.1865 0.9061
0.1939 0.9055 0.8855 -0.1484 0.9705 0.5615 0.1724 0.9076
0.1989 0.9072 0.8872 -0.1448 0.9722 0.5684 0.1595 0.9091
0.2040 0.9088 0.8888 -0.1411 0.9738 0.5756 0.1475 0.9106
0.2089 0.9104 0.8904 -0.1375 0.9754 0.5824 0.1251 0.9121
0.2130 0.9120 0.8920 -0.1345 0.9770 0.5883 0.1018 0.9137
0.2161 0.9135 0.8935 -0.1323 0.9785 0.5925 0.0871 0.9152
0.2176 0.9150 0.8950 -0.1311 0.9800 0.5947 0.0746 0.9169
0.2174 0.9165 0.8965 -0.1313 0.9815 0.5943 0.0606 0.9186
0.2151 0.9179 0.8979 -0.1330 0.9829 0.5911 0.0461 0.9203
0.2107 0.9193 0.8993 -0.1362 0.9843 0.5849 0.0324 0.9220
0.2043 0.9207 0.9007 -0.1409 0.9857 0.5760 0.0228 0.9238
0.1960 0.9221 0.9021 -0.1469 0.9871 0.5645 0.0313 0.9256
0.1860 0.9234 0.9034 -0.1542 0.9884 0.5503 0.0487 0.9274
0.1741 0.9246 0.9046 -0.1629 0.9896 0.5338 0.0611 0.9292
0.1605 0.9259 0.9059 -0.1728 0.9909 0.5147 0.0724 0.9310
0.1454 0.9271 0.9071 -0.1839 0.9921 0.4935 0.0858 0.9327
0.1292 0.9283 0.9083 -0.1957 0.9933 0.4708 0.1002 0.9344
0.1126 0.9295 0.9095 -0.2078 0.9945 0.4476 0.1130 0.9358
0.0964 0.9307 0.9107 -0.2196 0.9957 0.4250 0.1225 0.9373
0.0812 0.9319 0.9119 -0.2307 0.9969 0.4037 0.1308 0.9387
0.0679 0.9331 0.9131 -0.2404 0.9981 0.3850 0.1364 0.9402
0.0569 0.9342 0.9142 -0.2485 0.9992 0.3696 0.1389 0.9416
0.0482 0.9354 0.9154 -0.2548 1.0004 0.3574 0.1413 0.9431
0.0415 0.9365 0.9165 -0.2597 1.0015 0.3481 0.1402 0.9446
0.0365 0.9377 0.9177 -0.2634 1.0027 0.3410 0.1327 0.9462
0.0328 0.9389 0.9189 -0.2661 1.0039 0.3359 0.1261 0.9477
0.0300 0.9400 0.9200 -0.2681 1.0050 0.3320 0.1267 0.9492
0.0278 0.9412 0.9212 -0.2697 1.0062 0.3290 0.1309 0.9506
0.0259 0.9424 0.9224 -0.2711 1.0074 0.3263 0.1368 0.9521
0.0240 0.9435 0.9235 -0.2725 1.0085 0.3236 0.1410 0.9536
0.0226 0.9447 0.9247 -0.2735 1.0097 0.3217 0.1400 0.9551
0.0220 0.9459 0.9259 -0.2739 1.0109 0.3208 0.1419 0.9565
0.0220 0.9470 0.9270 -0.2740 1.0120 0.3208 0.1525 0.9578
0.0222 0.9481 0.9281 -0.2738 1.0131 0.3210 0.1658 0.9590
0.0223 0.9492 0.9292 -0.2737 1.0142 0.3212 0.1743 0.9601
0.0220 0.9504 0.9304 -0.2739 1.0154 0.3208 0.1732 0.9612
0.0207 0.9515 0.9315 -0.2749 1.0165 0.3190 0.1607 0.9625
0.0183 0.9526 0.9326 -0.2767 1.0176 0.3156 0.1407 0.9637
0.0149 0.9537 0.9337 -0.2791 1.0187 0.3108 0.1208 0.9649
0.0111 0.9548 0.9348 -0.2819 1.0198 0.3055 0.1081 0.9660
0.0073 0.9559 0.9359 -0.2847 1.0209 0.3002 0.1053 0.9671
0.0036 0.9571 0.9371 -0.2873 1.0221 0.2951 0.1051 0.9683
0.0004 0.9582 0.9382 -0.2897 1.0232 0.2906 0.1006 0.9695
-0.0022 0.9593 0.9393 -0.2916 1.0243 0.2869 0.0958 0.9706
-0.0039 0.9604 0.9404 -0.2929 1.0254 0.2845 0.0980 0.9716
-0.0046 0.9615 0.9415 -0.2934 1.0265 0.2836 0.1126 0.9727
-0.0046 0.9627 0.9427 -0.2934 1.0277 0.2835 0.1302 0.9737
-0.0046 0.9638 0.9438 -0.2933 1.0288 0.2836 0.1353 0.9747
-0.0046 0.9649 0.9449 -0.2933 1.0299 0.2836 0.1237 0.9758
-0.0046 0.9660 0.9460 -0.2933 1.0310 0.2836 0.1047 0.9771
-0.0047 0.9672 0.9472 -0.2934 1.0322 0.2835 0.0881 0.9782
-0.0047 0.9683 0.9483 -0.2935 1.0333 0.2834 0.0799 0.9792
-0.0048 0.9694 0.9494 -0.2935 1.0344 0.2833 0.0869 0.9801
-0.0048 0.9705 0.9505 -0.2935 1.0355 0.2833 0.1029 0.9809
-0.0048 0.9717 0.9517 -0.2935 1.0367 0.2833 0.1149 0.9817
-0.0048 0.9728 0.9528 -0.2935 1.0378 0.2833 0.1199 0.9825
-0.0048 0.9739 0.9539 -0.2935 1.0389 0.2833 0.1190 0.9834
-0.0047 0.9750 0.9550 -0.2935 1.0400 0.2834 0.1140 0.9843
-0.0047 0.9762 0.9562 -0.2934 1.0412 0.2835 0.1082 0.9852
-0.0046 0.9773 0.9573 -0.2934 1.0423 0.2835 0.1029 0.9861
-0.0047 0.9784 0.9584 -0.2934 1.0434 0.2835 0.0942 0.9870
-0.0048 0.9796 0.9596 -0.2935 1.0446 0.2833 0.0807 0.9879
-0.0050 0.9807 0.9607 -0.2936 1.0457 0.2831 0.0723 0.9888
-0.0050 0.9818 0.9618 -0.2936 1.0468 0.2830 0.0741 0.9897
-0.0049 0.9829 0.9629 -0.2936 1.0479 0.2831 0.0842 0.9905
-0.0048 0.9841 0.9641 -0.2935 1.0491 0.2833 0.0977 0.9912
-0.0048 0.9852 0.9652 -0.2935 1.0502 0.2833 0.1100 0.9918
-0.0047 0.9863 0.9663 -0.2934 1.0513 0.2834 0.1180 0.9925
-0.0046 0.9875 0.9675 -0.2934 1.0525 0.2836 0.1186 0.9933
-0.0045 0.9886 0.9686 -0.2933 1.0536 0.2837 0.1197 0.9941
-0.0044 0.9898 0.9698 -0.2932 1.0548 0.2838 0.1243 0.9949
-0.0044 0.9909 0.9709 -0.2932 1.0559 0.2839 0.1291 0.9956
-0.0044 0.9920 0.9720 -0.2932 1.0570 0.2838 0.1381 0.9963
-0.0045 0.9932 0.9732 -0.2933 1.0582 0.2837 0.1543 0.9970
-0.0046 0.9943 0.9743 -0.2934 1.0593 0.2836 0.1771 0.9975
-0.0047 0.9954 0.9754 -0.2934 1.0604 0.2835 0.1972 0.9981
-0.0046 0.9966 0.9766 -0.2934 1.0616 0.2835 0.2084 0.9987
-0.0046 0.9977 0.9777 -0.2933 1.0627 0.2836 0.2052 0.9993
-0.0045 0.9989 0.9789 -0.2933 1.0639 0.2837 0.1926 1.0000
-0.0045 1.0000 0.9800 -0.2933 1.0650 0.2837 0.0000 0.0000

 

[SkipVought]

Do you expect ANY value pair to be outside of tolerance?

If so which value pair?

If not, give me such an example.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

The reason I asked the question is, that I cannot see ANY out-of-tolerance values in the data you posted.

I am using these headings and Named Ranges...
[tt]
yNom
xNom
xLT
yLT
xUT
yUT
yAct
xAct
[/tt]
This is my formula for testing Actual to the lower tolerance...
[tt]
=IF(ISNA(MATCH($H2,xLT,1)),"",IF(G2<INDEX(yLT,MATCH($H2,xLT,1),1),TRUE,FALSE))
[/tt]
Some of your xAct & xNom are LESS THAN or GREATER THAN any xLT values, BTW.

You would use a similar formula for upper tolerance.

I forced a condition to test my formula and return a TRUE.




Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[Ca1icoJack]

What do you mean by value pair? As I said, none of the x values are the same so I can't simply compare values.

I'm not sure whether the data I provided you with would pass or fail.

 

[SkipVought]

Are you sure that you want some help? You certainly are not being forthcoming with cogent data.

What do you mean by value pair

an x,y pair (a point)

Have you not looked at your chart? There are NO, NADA, NONE, data points out of tolerance. Or am I smokin' dope?

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[Ca1icoJack]

I was just providing a random set of data with which you could look at the tolerance bands. I didn't check whether the set was a pass or fail. This is a set which fails those bands. And yes, I do want help, I'm just finding it difficult to explain exactly what I want.

y x
0.0131 0.0000
0.0160 0.0004
0.0214 0.0008
0.0317 0.0014
0.0460 0.0019
0.0541 0.0025
0.0510 0.0032
0.0398 0.0037
0.0259 0.0041
0.0111 0.0045
-0.0012 0.0049
0.0000 0.0053
0.0000 0.0057
-0.0034 0.0062
0.0112 0.0066
0.0381 0.0071
0.0690 0.0076
0.0930 0.0081
0.1099 0.0085
0.1216 0.0088
0.1329 0.0092
0.1492 0.0097
0.1654 0.0103
0.1718 0.0110
0.1693 0.0116
0.1710 0.0121
0.1778 0.0127
0.1812 0.0134
0.1855 0.0142
0.1899 0.0149
0.1932 0.0156
0.1923 0.0164
0.1910 0.0173
0.1931 0.0181
0.1922 0.0190
0.1842 0.0197
0.1659 0.0204
0.1388 0.0213
0.1105 0.0222
0.0940 0.0232
0.0874 0.0243
0.0804 0.0253
0.0760 0.0263
0.0810 0.0274
0.0886 0.0285
0.0997 0.0295
0.1075 0.0306
0.1102 0.0316
0.1112 0.0326
0.1144 0.0335
0.1166 0.0344
0.1135 0.0352
0.1157 0.0362
0.1288 0.0372
0.1514 0.0384
0.1759 0.0398
0.1976 0.0411
0.2137 0.0423
0.2211 0.0435
0.2180 0.0447
0.2070 0.0460
0.1893 0.0473
0.1674 0.0487
0.1444 0.0500
0.1183 0.0513
0.0896 0.0526
0.0778 0.0540
0.0961 0.0554
0.1218 0.0569
0.1400 0.0585
0.1549 0.0601
0.1682 0.0617
0.1804 0.0631
0.1893 0.0645
0.1819 0.0658
0.1564 0.0672
0.1361 0.0686
0.1282 0.0700
0.1258 0.0717
0.1287 0.0735
0.1382 0.0753
0.1476 0.0771
0.1436 0.0788
0.1299 0.0806
0.1194 0.0824
0.1097 0.0842
0.0942 0.0860
0.0767 0.0877
0.0634 0.0893
0.0598 0.0909
0.0793 0.0927
0.1163 0.0945
0.1516 0.0964
0.1806 0.0982
0.2037 0.0998
0.2114 0.1015
0.2053 0.1034
0.2020 0.1053
0.2051 0.1072
0.2001 0.1091
0.1828 0.1112
0.1647 0.1133
0.1584 0.1154
0.1613 0.1176
0.1634 0.1198
0.1577 0.1220
0.1416 0.1242
0.1239 0.1263
0.1064 0.1284
0.0878 0.1304
0.0802 0.1325
0.0956 0.1346
0.1247 0.1368
0.1564 0.1390
0.1867 0.1412
0.2151 0.1435
0.2424 0.1458
0.2673 0.1480
0.2778 0.1503
0.2718 0.1526
0.2652 0.1548
0.2634 0.1571
0.2665 0.1596
0.2749 0.1622
0.2875 0.1649
0.2982 0.1676
0.2933 0.1703
0.2661 0.1730
0.2277 0.1756
0.1894 0.1782
0.1609 0.1809
0.1437 0.1836
0.1371 0.1864
0.1405 0.1893
0.1601 0.1923
0.1958 0.1952
0.2317 0.1981
0.2572 0.2010
0.2665 0.2038
0.2611 0.2065
0.2460 0.2091
0.2282 0.2118
0.2133 0.2148
0.2046 0.2178
0.2004 0.2210
0.1907 0.2243
0.2227 0.2275
0.3073 0.2308
0.3821 0.2342
0.4562 0.2375
0.5346 0.2408
0.6116 0.2440
0.6845 0.2473
0.7591 0.2505
0.7935 0.2536
0.7859 0.2568
0.8125 0.2599
0.9808 0.2629
1.3931 0.2666
1.8373 0.2712
2.3119 0.2757
2.8160 0.2804
3.2828 0.2851
3.6848 0.2899
4.0746 0.2947
4.3827 0.2993
4.5821 0.3038
4.6779 0.3085
4.6492 0.3134
4.4883 0.3197
4.2685 0.3277
4.0229 0.3357
3.7110 0.3437
3.3407 0.3516
2.8360 0.3596
2.3347 0.3676
1.8396 0.3756
1.3513 0.3836
0.8788 0.3916
0.4323 0.3996
0.0248 0.4076
0.0000 0.4156
0.0000 0.4236
-0.0475 0.4316
0.0769 0.4396
0.2047 0.4475
0.3319 0.4555
0.4569 0.4635
0.5880 0.4715
0.7315 0.4795
0.8583 0.4875
0.9723 0.4954
1.0937 0.5034
1.2126 0.5114
1.3250 0.5194
1.4379 0.5273
1.5394 0.5352
1.6195 0.5431
1.6529 0.5510
1.6550 0.5589
1.6672 0.5667
1.6937 0.5744
1.7684 0.5820
1.8405 0.5895
1.9252 0.5970
2.0169 0.6045
2.1108 0.6120
2.1988 0.6195
2.2562 0.6269
2.3117 0.6341
2.3565 0.6412
2.4574 0.6481
2.5259 0.6548
2.5611 0.6613
2.5868 0.6672
2.6044 0.6731
2.5959 0.6786
2.5476 0.6835
2.4244 0.6884
2.2353 0.6933
2.0258 0.6983
1.7972 0.7030
1.5828 0.7074
1.3917 0.7108
1.2312 0.7142
1.0812 0.7176
0.9465 0.7210
0.7445 0.7243
0.5802 0.7277
0.4646 0.7312
0.3673 0.7346
0.2651 0.7380
0.1691 0.7414
0.0946 0.7447
0.0482 0.7481
0.0672 0.7515
0.0827 0.7549
0.0992 0.7583
0.1122 0.7618
0.1321 0.7654
0.1515 0.7689
0.1670 0.7723
0.1897 0.7755
0.2262 0.7787
0.2667 0.7820
0.2960 0.7852
0.3112 0.7884
0.3239 0.7916
0.3293 0.7948
0.3267 0.7979
0.3197 0.8009
0.3130 0.8039
0.2984 0.8068
0.2770 0.8098
0.2620 0.8127
0.2465 0.8156
0.2363 0.8184
0.2314 0.8210
0.2251 0.8236
0.2136 0.8263
0.2126 0.8290
0.2198 0.8317
0.2275 0.8344
0.2367 0.8371
0.2479 0.8398
0.2604 0.8425
0.2749 0.8451
0.2886 0.8477
0.2922 0.8502
0.2934 0.8528
0.2930 0.8553
0.2868 0.8578
0.2739 0.8600
0.2562 0.8622
0.2370 0.8643
0.2142 0.8664
0.1779 0.8685
0.1375 0.8706
0.0993 0.8727
0.0670 0.8748
0.0446 0.8769
0.0384 0.8790
0.0411 0.8812
0.0419 0.8833
0.0524 0.8855
0.0715 0.8877
0.0968 0.8899
0.1243 0.8922
0.1480 0.8944
0.1588 0.8966
0.1585 0.8989
0.1605 0.9010
0.1708 0.9031
0.1883 0.9049
0.2081 0.9067
0.2246 0.9085
0.2303 0.9104
0.2154 0.9123
0.1916 0.9142
0.1803 0.9160
0.1772 0.9177
0.1694 0.9195
0.1537 0.9214
0.1355 0.9233
0.1233 0.9252
0.1302 0.9270
0.1516 0.9286
0.1702 0.9301
0.1809 0.9317
0.1885 0.9333
0.1916 0.9351
0.1861 0.9368
0.1819 0.9384
0.1893 0.9400
0.2020 0.9414
0.2113 0.9429
0.2156 0.9444
0.2161 0.9458
0.2187 0.9474
0.2297 0.9489
0.2412 0.9503
0.2429 0.9516
0.2370 0.9528
0.2271 0.9541
0.2116 0.9554
0.1876 0.9566
0.1617 0.9578
0.1415 0.9590
0.1204 0.9601
0.0936 0.9611
0.0663 0.9621
0.0431 0.9631
0.0326 0.9642
0.0359 0.9652
0.0402 0.9663
0.0418 0.9674
0.0492 0.9685
0.0639 0.9697
0.0763 0.9708
0.0827 0.9720
0.0849 0.9732
0.0902 0.9745
0.1045 0.9757
0.1181 0.9768
0.1259 0.9778
0.1386 0.9786
0.1559 0.9795
0.1729 0.9804
0.1794 0.9812
0.1735 0.9820
0.1634 0.9829
0.1499 0.9839
0.1326 0.9848
0.1077 0.9857
0.0877 0.9865
0.0844 0.9874
0.0952 0.9883
0.0989 0.9891
0.0959 0.9898
0.1049 0.9905
0.1335 0.9912
0.1624 0.9919
0.1812 0.9926
0.1859 0.9933
0.1846 0.9941
0.1957 0.9949
0.2116 0.9956
0.2182 0.9962
0.2096 0.9967
0.2005 0.9974
0.1938 0.9980
0.1852 0.9986
0.1739 0.9990
0.1703 0.9992
0.1702 0.9995
0.1646 0.9997
0.1506 1.0000

Thank you for your help.

 

[SkipVought]

I'm just finding it difficult to explain exactly what I want.

Yes, I can see, but you're the only one who can, and so far you are failing miserably!

You must construct a set of data, where you can PREDICT the outcome and then test your process to see if it yields the predicted results.

That is your task!

BTW, I already gave you a workable solution example, from the meager data you have provided.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[Ca1icoJack]

I'll try using your solution from earlier then. If it were possible to upload the full set of data I could show you, since I can't I'll continue on my own. Thank you for the help though

 

[SkipVought]

As I stated earlier, I forced an out-of-tolerance condition on a yAct value and got a TRUE.

Make a similar formula for the upper. The TRUE values will indicate an out-of-tolerance condition.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}