Spreadsheet: john_arnold__15189__$7 & $9 stress results
Sheet: nine

SQL> /
EFF_DT | [NAME] | LOSS_95PERCENTILE_AMT
--------- | --------------- | ---------------------
2000-09-12 00:00:00 | AGG-GASIV | -99262262 | -42383340.019
2000-09-12 00:00:00 | ARUBA-SPLY-P | -227482.52
2000-09-12 00:00:00 | A_RING | -218466.28
2000-09-12 00:00:00 | BRAWNER | -15108360
2000-09-12 00:00:00 | B_MCKAY | -14038909
2000-09-12 00:00:00 | CUILLA | -2025841.1
2000-09-12 00:00:00 | [NAME] | -3.536e-05
2000-09-12 00:00:00 | C_METZ | -1368276.3
2000-09-12 00:00:00 | D_JENKINS | -4534696.1
2000-09-12 00:00:00 | D_JUNEK | -109233.14
2000-09-12 00:00:00 | E_BASS | -135231.88
2000-09-12 00:00:00 | E_PAO | -478151.82
2000-09-12 00:00:00 | FT-CAND-EGSC-10 | -19159579
2000-09-12 00:00:00 | FT-CAND-EGSC-11 | -302465.76
2000-09-12 00:00:00 | FT-CAND-EGSC-2 | -2346644.4
2000-09-12 00:00:00 | FT-CAND-EGSC-4 | -2659237.4
2000-09-12 00:00:00 | FT-CAND-EGSC-9 | -5814998.6
2000-09-12 00:00:00 | FT-CAND-EGSC-C1 | -294281.41
2000-09-12 00:00:00 | FT-CAND-EGSC-C2 | -21658.298
2000-09-12 00:00:00 | FT-CAND-ERMS-1 | -5.303e-06
2000-09-12 00:00:00 | FT-CAND-ERMS-2 | -6.244e-05
2000-09-12 00:00:00 | FT-CAND-PWR-P | -872168.07
2000-09-12 00:00:00 | FT-CENTRAL-BA1 | -10652752
2000-09-12 00:00:00 | FT-CENTRAL-GD1 | -666885
2000-09-12 00:00:00 | FT-CENTRAL-PR1 | -3751763.9
2000-09-12 00:00:00 | FT-DEN-B | -296698.65
2000-09-12 00:00:00 | FT-DENVER-P | -125850.68
2000-09-12 00:00:00 | FT-EAST-BAS0 | -14086918
2000-09-12 00:00:00 | FT-EAST-GD-GD1 | -29041.94
2000-09-12 00:00:00 | FT-EAST-PRC0 | -967112.04
2000-09-12 00:00:00 | FT-EOL-TEXAS-B | -0.00015735
2000-09-12 00:00:00 | FT-EOL-TEXAS-G | -135231.88
2000-09-12 00:00:00 | FT-EOL-TEXAS-P | -1.149e-05
2000-09-12 00:00:00 | FT-HPLC-BAS0 | -131596.09
2000-09-12 00:00:00 | FT-HPLC-PRC0 | -115768.81
2000-09-12 00:00:00 | FT-INT-C-MKT2-B | -203111.9
2000-09-12 00:00:00 | FT-INT-C-MKT2-G | -158846.7
2000-09-12 00:00:00 | FT-INT-C-MKT2-P | -273082.85
2000-09-12 00:00:00 | FT-INT-C-NEW-B | -164694.62
2000-09-12 00:00:00 | FT-INT-C-NEW-P | -144832.09
2000-09-12 00:00:00 | FT-INT-CE-MKT-B | -369541.17
2000-09-12 00:00:00 | FT-INT-CE-MKT-G | -10520.523
2000-09-12 00:00:00 | FT-INT-CE-MKT-P | -612970.44
2000-09-12 00:00:00 | FT-INT-CEN-M-G | -171256.76
2000-09-12 00:00:00 | FT-INT-CEN-M-P | -280130.15
2000-09-12 00:00:00 | FT-INT-CEN-M2-B | -1.409e-05
2000-09-12 00:00:00 | FT-INT-CEN-M2-P | -898922.85
2000-09-12 00:00:00 | FT-INT-CNT-M-B | -1.518e-05
2000-09-12 00:00:00 | FT-INT-M2-G | -216789.67
2000-09-12 00:00:00 | FT-INTRA-CENT-B | -569347.44
2000-09-12 00:00:00 | FT-INTRA-CENT-P | -2087448.8
2000-09-12 00:00:00 | FT-INTRA-GUL2-B | -24227.404
2000-09-12 00:00:00 | FT-INTRA-GUL2-G | -232597.61
2000-09-12 00:00:00 | FT-INTRA-GUL2-P | -32465.791
2000-09-12 00:00:00 | FT-INTRA-GULF-B | -2101.9486
2000-09-12 00:00:00 | FT-INTRA-GULF-G | -211681.46
2000-09-12 00:00:00 | FT-INTRA-GULF-P | -56870.629
2000-09-12 00:00:00 | FT-INTRA-ONT-BA | -1114955.6
2000-09-12 00:00:00 | FT-INTRA-ONT-GD | -59210.628
2000-09-12 00:00:00 | FT-INTRA-ONT-PR | -855911.57
2000-09-12 00:00:00 | FT-NGPL-STRG-B | -19541.043
2000-09-12 00:00:00 | FT-NGPL-STRG-P | -109233.6
2000-09-12 00:00:00 | FT-NORTHWEST-B | -9699586.5
2000-09-12 00:00:00 | FT-NORTHWEST-G | -27662.202
2000-09-12 00:00:00 | FT-NORTHWEST-P | -680549.68
2000-09-12 00:00:00 | FT-NY-BAS0 | -13719149
2000-09-12 00:00:00 | FT-NY-GD-GDL0 | -685710.84
2000-09-12 00:00:00 | FT-NY-PRC0 | -392843.05
2000-09-12 00:00:00 | FT-ONT-CEN-GD1 | -76558.698
2000-09-12 00:00:00 | FT-ONTARIO-BA1 | -328468.61
2000-09-12 00:00:00 | FT-ONTARIO-PR1 | -346686.73
2000-09-12 00:00:00 | FT-SOUTHEAST-1 | -1182557.9
2000-09-12 00:00:00 | FT-SOUTHEAST-GD | -29261.662
2000-09-12 00:00:00 | FT-TEXAS-BAS0 | -1381293.7
2000-09-12 00:00:00 | FT-TEXAS-PRC0 | -271771.14
2000-09-12 00:00:00 | FT-WEST-BAS0 | -32147112
2000-09-12 00:00:00 | FT-WEST-GD-GD1 | -303429.61
2000-09-12 00:00:00 | FT-WEST-OPT-B1 | -1090902.1
2000-09-12 00:00:00 | FT-WEST-OPT-P1 | -26632.983
2000-09-12 00:00:00 | FT-WEST-PRC0 | -63234.953
2000-09-12 00:00:00 | F_ERMIS | -9769000.2
2000-09-12 00:00:00 | F_STURM | -15024197
2000-09-12 00:00:00 | G-DAILY-BAS0 | -955497.46
2000-09-12 00:00:00 | G-DAILY-GDL0 | -1520858.9
2000-09-12 00:00:00 | G-DAILY-PRC0 | -891605.31
2000-09-12 00:00:00 | GAS-APEA PREP2 | -1.425e-07
2000-09-12 00:00:00 | GAS-APEA PREP3 | -3.536e-05
2000-09-12 00:00:00 | GD-CENTRAL-BAS | -72957.435
2000-09-12 00:00:00 | GD-CENTRAL-GDL | -947562.13
2000-09-12 00:00:00 | GD-CENTRAL-PRC | -553121.04
2000-09-12 00:00:00 | GD-MARKET-B | -5857.5609
2000-09-12 00:00:00 | GD-MARKET-G | -402408.12
2000-09-12 00:00:00 | GD-MARKET-P | -861474.06
2000-09-12 00:00:00 | GD-NEW-BAS0 | -11633072
2000-09-12 00:00:00 | GD-NEW-GDL0 | -3509442.1
2000-09-12 00:00:00 | GD-NEW-PRC0 | -2030009.9
2000-09-12 00:00:00 | GD-TEXAS-B | -143477.42
2000-09-12 00:00:00 | GD-TEXAS-GDL | -1116206.4
2000-09-12 00:00:00 | GD-TEXAS-P | -2384461.2
2000-09-12 00:00:00 | G_MCCLENDON | -1640012.2
2000-09-12 00:00:00 | G_STOREY | -756908.84
2000-09-12 00:00:00 | H_SHIVELY | -2649247
2000-09-12 00:00:00 | IM-CES-LGS-B | -335474.73
2000-09-12 00:00:00 | IMCAN-ERMS-XL4 | -442381.9
2000-09-12 00:00:00 | INTRA-CES-ENT-B | -130762.1
2000-09-12 00:00:00 | INTRA-CES-ENT-P | -4201.7056
2000-09-12 00:00:00 | INTRA-CES-LGS-P | -37238.433
2000-09-12 00:00:00 | INTRA-CES-TV-B | -132423.92
2000-09-12 00:00:00 | INTRA-CES-TV-P | -302417.35
2000-09-12 00:00:00 | INTRA-EA-PROM1 | -96077.195
2000-09-12 00:00:00 | INTRA-EMWMEH-P | -10093.714
2000-09-12 00:00:00 | INTRA-GULF1-PRC | -218466.28
2000-09-12 00:00:00 | INTRA-GULF3-PRC | -54616.571
2000-09-12 00:00:00 | INTRA-MKT4-PRC | -54616.571
2000-09-12 00:00:00 | INTRA-MKTEAST-B | -1412471.4
2000-09-12 00:00:00 | INTRA-MKTEAST-G | -358110.16
2000-09-12 00:00:00 | INTRA-MKTEAST-P | -3535940.5
2000-09-12 00:00:00 | INTRA-NE-PROM2 | -139240.93
2000-09-12 00:00:00 | INTRA-NORTHEA1 | -4920911.2
2000-09-12 00:00:00 | INTRA-NORTHEA2 | -586954.93
2000-09-12 00:00:00 | INTRA-NORTHEA3 | -938130.34
2000-09-12 00:00:00 | INTRA-NORTHEA4 | -1237833.8
2000-09-12 00:00:00 | INTRA-PRMPT-PHY | -23979.119
2000-09-12 00:00:00 | INTRA-PRMPT-PRC | -154546.38
2000-09-12 00:00:00 | INTRA-ST-COV-PR | -42635.809
2000-09-12 00:00:00 | INTRA-ST-COVE-B | -410.28323
2000-09-12 00:00:00 | INTRA-ST-HATT1 | -8875.5594
2000-09-12 00:00:00 | INTRA-ST-HATT3 | -20269.172
2000-09-12 00:00:00 | INTRA-ST-NAP-1 | -479682.23
2000-09-12 00:00:00 | INTRA-ST-NAP-3 | -75105.921
2000-09-12 00:00:00 | INTRA-TEXAS-B1 | -842124.57
2000-09-12 00:00:00 | INTRA-TEXAS-G1 | -153085.22
2000-09-12 00:00:00 | INTRA-TEXAS-P2 | -2664536
2000-09-12 00:00:00 | INTRA-TP1-P | -109233.14
2000-09-12 00:00:00 | INTRA-TP3-P | -3.536e-05
2000-09-12 00:00:00 | INTRA-TX-PROM2 | -516.78065
2000-09-12 00:00:00 | INTRA-WMWMEH-B | -249618.01
2000-09-12 00:00:00 | JOE_PARKS | -94261.475
2000-09-12 00:00:00 | J_ARNOLD | -3084696.3 | -5718581.2872
2000-09-12 00:00:00 | J_KAISER | -1259323.7
2000-09-12 00:00:00 | J_MCKAY | -23916815
2000-09-12 00:00:00 | J_SCHWIEGER | -7990332.1 |  |  |  |  |  | -1
2000-09-12 00:00:00 | J_THOLT | -1069920.6
2000-09-12 00:00:00 | J_WILLIAMS | -45311.259
2000-09-12 00:00:00 | K_HOLST | -31238587
2000-09-12 00:00:00 | K_STEVENS | -989304.6
2000-09-12 00:00:00 | LAVORATO-CND | -23916815 | -12320910.631 |  |  | Texas | 12016525 | 5210762.9824
2000-09-12 00:00:00 | LAVORATO-CNT | -21918933 | -12318614.704 |  |  | Financial | 9155470.2 | 5248281.7003
2000-09-12 00:00:00 | LAVORATO-EAST | -42798848 | -8714917.9797 |  |  | East | 42798848 | 8714917.9797
2000-09-12 00:00:00 | LAVORATO-FIN | -9155470.2 | -5248281.7003 |  |  | Central | 21918933 | 12318614.704
2000-09-12 00:00:00 | LAVORATO-TEXAS | -12016525 | -5210762.9824 |  |  | Canada | 23916815 | 12320910.631
2000-09-12 00:00:00 | LAVORATO-WEST | -69888629 | -38741468.963 |  |  | West | 69888629 | 38741468.963
2000-09-12 00:00:00 | L_MAY | -9878483.1
2000-09-12 00:00:00 | MGMT-WEST-BAS | -14040415
2000-09-12 00:00:00 | MGMT-WEST-GDL | -174543.32
2000-09-12 00:00:00 | MGMT-WEST-PRC | -229752.78
2000-09-12 00:00:00 | M_GRIGSBY | -12556446
2000-09-12 00:00:00 | M_LENHART | -605659.47
2000-09-12 00:00:00 | NG-ERMS-XL-PR1 | -1892932.7
2000-09-12 00:00:00 | NG-EXOTIC-PRC0 | -7080845.6
2000-09-12 00:00:00 | NG-LTX-PRC0 | -2191575.1
2000-09-12 00:00:00 | NG-MM-PRC | -648470.4
2000-09-12 00:00:00 | NG-OPT-XL-B | -390447.23
2000-09-12 00:00:00 | NG-OPT-XL-PRC0 | -268229.02
2000-09-12 00:00:00 | NG-OPT2-XL-B | -1530844.9
2000-09-12 00:00:00 | NG-PR-P | -819085.88
2000-09-12 00:00:00 | NG-PRICE-PRC0 | -8451374.8
2000-09-12 00:00:00 | OPTIONS-GDOPT1 | -16043.513
2000-09-12 00:00:00 | OPTIONS-PRICE1 | -9472851.5
2000-09-12 00:00:00 | OPTIONS-PRICE2 | -1362552.7
2000-09-12 00:00:00 | POLLAN | -308667.85
2000-09-12 00:00:00 | [NAME] | -13975456
2000-09-12 00:00:00 | P_KEAVEY | -1653195.4
2000-09-12 00:00:00 | P_LUCCI | -348868.3
2000-09-12 00:00:00 | RUSCITTI | -972110.21
2000-09-12 00:00:00 | ST-BAMMEL-BAS0 | -317208.46
2000-09-12 00:00:00 | ST-BAMMEL-HPL1 | -2563462.2
2000-09-12 00:00:00 | ST-BAMMEL-HPL4 | -6479352.6
2000-09-12 00:00:00 | ST-BAMMEL-PRC0 | -1542411.2
2000-09-12 00:00:00 | ST-ERMS-XL-PR1 | -96298.229
2000-09-12 00:00:00 | ST-MICHCON-CE1 | -1.1002667
2000-09-12 00:00:00 | ST-MICHCON-CE2 | -634752.06
2000-09-12 00:00:00 | ST-MICHCON-CE4 | -401613.49
2000-09-12 00:00:00 | S_HENDRICKSON | -54616.571
2000-09-12 00:00:00 | S_MULLHOLLAND | -454192.08
2000-09-12 00:00:00 | S_NEAL | -7598873.4 | -2233421.2107
2000-09-12 00:00:00 | S_SOUTH | -1073375.9
2000-09-12 00:00:00 | THURSTON | -635077.29
2000-09-12 00:00:00 | TOMASKI | -239867.38
2000-09-12 00:00:00 | T_DONAHOE | -268433.06
2000-09-12 00:00:00 | T_KUYKENDALL | -883070.03
2000-09-12 00:00:00 | T_MARTIN | -3689795.1
2000-09-12 00:00:00 | WEST-NW-BAS | -1073375.9
2000-09-12 00:00:00 | WEST-NW-PRC | -0.00030688
2000-09-12 00:00:00 | WEST-PERM-BAS | -561473.93
2000-09-12 00:00:00 | WEST-PERM-PRC | -218466.28
2000-09-12 00:00:00 | WEST-SJ-BAS | -880898.58
2000-09-12 00:00:00 | WEST-SJ-GDL | -1301.2682
2000-09-12 00:00:00 | WEST-SW-BAS | -1123554.9
2000-09-12 00:00:00 | WEST-SW-GDL | -91374.739
200 rows | selected.
SQL> spoo | l off