Spreadsheet: 120650d1315424330-help-with-if-formula-regarding-xy-scatter-chart-charts
Sheet: PWLF 1

BASE | Y = | X = | YC = |  |  |  |  |  |  |  |  | STDEV |  |  |  |  |  |  |  |  | WLFs
 | MMHRS | [NAME] | Predicted Man-hours | Current Auth | Delta | X2 | Y2 | XY | TSS | SSE | SSR | 1 | 1 | OUT OF CONTROL |  | Linear | Power | Ratio | Parabola |  | [NAME] | X2 Veh Auth | [NAME]
BEALE AFB, CA | 498.1874911911972 | 3326 | 516.6438984284637 | 498.1874911911972 | 18.45640723726643 | 11062276 | 248190.7763793792 | 1656971.595701922 | 59803.40433214034 | 340.6389681078207 | 51117.11249492234 | 549.8396095832474 | 483.44818727368 |  |  | 3326 | #N/A | #N/A | #N/A |  | 3326 | 4637 | 49
DAVIS-MONTHAN AFB, AZ | 885.8616123096135 | 6262 | 894.5920834271707 | 885.8616123096135 | 8.730471117557158 | 39212644 | 784750.7961637881 | 5547265.4162828 | 20485.27381637536 | 76.22112593449974 | 23060.62329864585 | 927.7877945819544 | 861.396372272387 |  |  | 6262 | #N/A | #N/A | #N/A |  | 6262 | 8194 | 120
DYESS AFB, TX | 720.1788817444415 | 5184 | 755.8222798070732 | 720.1788817444415 | 35.64339806263172 | 26873856 | 518657.6217106742 | 3733407.322963185 | 508.7711165693423 | 1270.451825451219 | 171.2811597630369 | 789.0179909618569 | 722.6265686522895 | Yes |  | 5184 | #N/A | #N/A | #N/A |  | 5184 | 5931 | 59
ELLSWORTH AFB, SD | 496.4220313257607 | 3159 | 495.1461644724745 | 496.4220313257607 | -1.275866853286118 | 9979281 | 246434.8331855945 | 1568197.196958078 | 60669.99822905366 | 1.62783622731422 | 61300.15075382819 | 528.3418756272582 | 461.9504533176909 |  |  | 3159 | #N/A | #N/A | #N/A |  | 3159 | 4051 | 31
HOLLOMAN AFB, NM | 563.2703665836561 | 3162 | 495.5323513100072 | 563.2703665836561 | -67.7380152736489 | 9998244 | 317273.5058712864 | 1781060.899137521 | 32207.49613448759 | 4588.438713213091 | 61109.06892121279 | 528.7280624647909 | 462.3366401552236 | Yes |  | 3162 | #N/A | #N/A | #N/A |  | 3162 | 4792 | 80
LANGLEY AFB, VA | 1076.070257841813 | 7876 | 1102.360602019784 | 1076.070257841813 | 26.29034417797106 | 62031376 | 1157927.199811746 | 8475129.350762118 | 111112.5028014054 | 691.182196996177 | 129330.6908807557 | 1135.556313174568 | 1069.164890865 |  |  | 7876 | #N/A | #N/A | #N/A |  | 7876 | 12250 | 297
MOODY AFB, GA | 655.4874941839585 | 4530 | 671.6335492249361 | 655.4874941839585 | 16.14605504097767 | 20520900 | 429663.8550315649 | 2969358.348653332 | 7612.0988248958 | 260.6950933862805 | 5055.393120367942 | 704.8292603797198 | 638.4378380701525 |  |  | 4530 | #N/A | #N/A | #N/A |  | 4530 | 5266 | 99
MOUNTAIN HOME AFB, ID | 580.4512802152433 | 4081 | 613.8342525408697 | 580.4512802152433 | 33.38297232562638 | 16654561 | 336923.6887035149 | 2368821.674558408 | 26335.95279608203 | 1114.422841293537 | 16615.36066863977 | 647.0299636956534 | 580.638541386086 | Yes |  | 4081 | #N/A | #N/A | #N/A |  | 4081 | 5000 | 38
NELLIS AFB, NV | 1181.634759326085 | 8155 | 1138.275977910329 | 1181.634759326085 | -43.35878141575631 | 66504025 | 1396260.704447615 | 9636231.462304223 | 192633.1418357726 | 1879.983925859335 | 156452.7941688025 | 1171.471689065113 | 1105.080266755545 | Yes |  | 8155 | #N/A | #N/A | #N/A |  | 8155 | 11651 | 156
OFFUTT AFB, NE | 819.1229100767533 | 5457 | 790.9652820225524 | 819.1229100767533 | -28.15762805420093 | 29778849 | 670962.3418126089 | 4469953.720288843 | 5835.137711499878 | 792.852017638723 | 2326.175829043675 | 824.1609931773361 | 757.7695708677687 |  |  | 5457 | #N/A | #N/A | #N/A |  | 5457 | 9258 | 209
SEYMOUR JOHNSON AFB, NC | 635.010991057381 | 4259 | 636.7480049011455 | 635.010991057381 | 1.73701384376443 | 18139081 | 403238.9587636773 | 2704511.810913386 | 11604.42698026856 | 3.01721709342928 | 11233.2085740212 | 669.9437160559291 | 603.5522937463618 |  |  | 4259 | #N/A | #N/A | #N/A |  | 4259 | 5264 | 52
SHAW AFB, SC | 801.1199678989958 | 5537 | 801.2635976900922 | 801.1199678989958 | 0.1436297910963731 | 30658369 | 641793.2029664881 | 4435801.26225674 | 3408.823512477922 | 0.02062951689038777 | 3425.615830308994 | 834.4593088448759 | 768.0678865353085 |  |  | 5537 | #N/A | #N/A | #N/A |  | 5537 | 6777 | 142