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

SQL> /
EFF_DT | [NAME] | LOSS_95PERCENTILE_AMT
--------- | --------------- | ---------------------
2000-09-12 00:00:00 | AGG-GASIV | -75687694 | -42383340.019
2000-09-12 00:00:00 | ARUBA-SPLY-P | -176079.85
2000-09-12 00:00:00 | A_RING | -169100.95
2000-09-12 00:00:00 | BRAWNER | -7590168.5
2000-09-12 00:00:00 | B_MCKAY | -10104076
2000-09-12 00:00:00 | CUILLA | -1227229.6
2000-09-12 00:00:00 | [NAME] | -2.737e-05
2000-09-12 00:00:00 | C_METZ | -792741.49
2000-09-12 00:00:00 | D_JENKINS | -3477231.6
2000-09-12 00:00:00 | D_JUNEK | -84550.475
2000-09-12 00:00:00 | E_BASS | -135231.88
2000-09-12 00:00:00 | E_PAO | -576096.12
2000-09-12 00:00:00 | FT-CAND-EGSC-10 | -15455566
2000-09-12 00:00:00 | FT-CAND-EGSC-11 | -303849.72
2000-09-12 00:00:00 | FT-CAND-EGSC-2 | -1163374.8
2000-09-12 00:00:00 | FT-CAND-EGSC-4 | -1924429.4
2000-09-12 00:00:00 | FT-CAND-EGSC-9 | -2229956.8
2000-09-12 00:00:00 | FT-CAND-EGSC-C1 | -213945.97
2000-09-12 00:00:00 | FT-CAND-EGSC-C2 | -40634.803
2000-09-12 00:00:00 | FT-CAND-ERMS-1 | -5.303e-06
2000-09-12 00:00:00 | FT-CAND-ERMS-2 | -5.192e-05
2000-09-12 00:00:00 | FT-CAND-PWR-P | -872168.07
2000-09-12 00:00:00 | FT-CENTRAL-BA1 | -8307113
2000-09-12 00:00:00 | FT-CENTRAL-GD1 | -666885
2000-09-12 00:00:00 | FT-CENTRAL-PR1 | -3149624.8
2000-09-12 00:00:00 | FT-DEN-B | -257577.84
2000-09-12 00:00:00 | FT-DENVER-P | -98678.204
2000-09-12 00:00:00 | FT-EAST-BAS0 | -6806447.3
2000-09-12 00:00:00 | FT-EAST-GD-GD1 | -29041.94
2000-09-12 00:00:00 | FT-EAST-PRC0 | -757531.12
2000-09-12 00:00:00 | FT-EOL-TEXAS-B | -0.00011174
2000-09-12 00:00:00 | FT-EOL-TEXAS-G | -135231.88
2000-09-12 00:00:00 | FT-EOL-TEXAS-P | -8.888e-06
2000-09-12 00:00:00 | FT-HPLC-BAS0 | -61394.711
2000-09-12 00:00:00 | FT-HPLC-PRC0 | -85731.671
2000-09-12 00:00:00 | FT-INT-C-MKT2-B | -103596.25
2000-09-12 00:00:00 | FT-INT-C-MKT2-G | -158846.7
2000-09-12 00:00:00 | FT-INT-C-MKT2-P | -211376.19
2000-09-12 00:00:00 | FT-INT-C-NEW-B | -83560.467
2000-09-12 00:00:00 | FT-INT-C-NEW-P | -113294.42
2000-09-12 00:00:00 | FT-INT-CE-MKT-B | -188753.24
2000-09-12 00:00:00 | FT-INT-CE-MKT-G | -10520.523
2000-09-12 00:00:00 | FT-INT-CE-MKT-P | -493105.6
2000-09-12 00:00:00 | FT-INT-CEN-M-G | -171256.76
2000-09-12 00:00:00 | FT-INT-CEN-M-P | -216831.06
2000-09-12 00:00:00 | FT-INT-CEN-M2-B | -6.217e-06
2000-09-12 00:00:00 | FT-INT-CEN-M2-P | -695799.4
2000-09-12 00:00:00 | FT-INT-CNT-M-B | -6.797e-06
2000-09-12 00:00:00 | FT-INT-M2-G | -216789.67
2000-09-12 00:00:00 | FT-INTRA-CENT-B | -403241.95
2000-09-12 00:00:00 | FT-INTRA-CENT-P | -1649452.6
2000-09-12 00:00:00 | FT-INTRA-GUL2-B | -11494.087
2000-09-12 00:00:00 | FT-INTRA-GUL2-G | -232597.61
2000-09-12 00:00:00 | FT-INTRA-GUL2-P | -26027.1
2000-09-12 00:00:00 | FT-INTRA-GULF-B | -2761.5866
2000-09-12 00:00:00 | FT-INTRA-GULF-G | -211681.46
2000-09-12 00:00:00 | FT-INTRA-GULF-P | -44019.962
2000-09-12 00:00:00 | FT-INTRA-ONT-BA | -508859.63
2000-09-12 00:00:00 | FT-INTRA-ONT-GD | -59210.628
2000-09-12 00:00:00 | FT-INTRA-ONT-PR | -671457.87
2000-09-12 00:00:00 | FT-NGPL-STRG-B | -9691.0719
2000-09-12 00:00:00 | FT-NGPL-STRG-P | -84550.828
2000-09-12 00:00:00 | FT-NORTHWEST-B | -7325651
2000-09-12 00:00:00 | FT-NORTHWEST-G | -27662.202
2000-09-12 00:00:00 | FT-NORTHWEST-P | -510010.5
2000-09-12 00:00:00 | FT-NY-BAS0 | -9754114.7
2000-09-12 00:00:00 | FT-NY-GD-GDL0 | -656111.35
2000-09-12 00:00:00 | FT-NY-PRC0 | -295500.02
2000-09-12 00:00:00 | FT-ONT-CEN-GD1 | -76558.698
2000-09-12 00:00:00 | FT-ONTARIO-BA1 | -261071.62
2000-09-12 00:00:00 | FT-ONTARIO-PR1 | -283490.46
2000-09-12 00:00:00 | FT-SOUTHEAST-1 | -1073810.8
2000-09-12 00:00:00 | FT-SOUTHEAST-GD | -20942.458
2000-09-12 00:00:00 | FT-TEXAS-BAS0 | -300280.94
2000-09-12 00:00:00 | FT-TEXAS-PRC0 | -227564.77
2000-09-12 00:00:00 | FT-WEST-BAS0 | -23653016
2000-09-12 00:00:00 | FT-WEST-GD-GD1 | -303429.61
2000-09-12 00:00:00 | FT-WEST-OPT-B1 | -788333.67
2000-09-12 00:00:00 | FT-WEST-OPT-P1 | -19613.816
2000-09-12 00:00:00 | FT-WEST-PRC0 | -37865.021
2000-09-12 00:00:00 | F_ERMIS | -7695148.3
2000-09-12 00:00:00 | F_STURM | -12176870
2000-09-12 00:00:00 | G-DAILY-BAS0 | -702625.51
2000-09-12 00:00:00 | G-DAILY-GDL0 | -1159920.1
2000-09-12 00:00:00 | G-DAILY-PRC0 | -663599.43
2000-09-12 00:00:00 | GAS-APEA PREP2 | -1.425e-07
2000-09-12 00:00:00 | GAS-APEA PREP3 | -2.737e-05
2000-09-12 00:00:00 | GD-CENTRAL-BAS | -36351.432
2000-09-12 00:00:00 | GD-CENTRAL-GDL | -947562.13
2000-09-12 00:00:00 | GD-CENTRAL-PRC | -411240.29
2000-09-12 00:00:00 | GD-MARKET-B | -5678.2798
2000-09-12 00:00:00 | GD-MARKET-G | -373575.48
2000-09-12 00:00:00 | GD-MARKET-P | -667256.7
2000-09-12 00:00:00 | GD-NEW-BAS0 | -9112106.9
2000-09-12 00:00:00 | GD-NEW-GDL0 | -3509442.1
2000-09-12 00:00:00 | GD-NEW-PRC0 | -1611717.9
2000-09-12 00:00:00 | GD-TEXAS-B | -101971.54
2000-09-12 00:00:00 | GD-TEXAS-GDL | -1116206.4
2000-09-12 00:00:00 | GD-TEXAS-P | -1845670.2
2000-09-12 00:00:00 | G_MCCLENDON | -434371.18
2000-09-12 00:00:00 | G_STOREY | -626452.46
2000-09-12 00:00:00 | H_SHIVELY | -2054818.8
2000-09-12 00:00:00 | IM-CES-LGS-B | -161268.13
2000-09-12 00:00:00 | IMCAN-ERMS-XL4 | -342419.88
2000-09-12 00:00:00 | INTRA-CES-ENT-B | -54694.337
2000-09-12 00:00:00 | INTRA-CES-ENT-P | -3264.376
2000-09-12 00:00:00 | INTRA-CES-LGS-P | -29319.539
2000-09-12 00:00:00 | INTRA-CES-TV-B | -64233.752
2000-09-12 00:00:00 | INTRA-CES-TV-P | -235076.92
2000-09-12 00:00:00 | INTRA-EA-PROM1 | -65796.298
2000-09-12 00:00:00 | INTRA-EMWMEH-P | -7812.5596
2000-09-12 00:00:00 | INTRA-GULF1-PRC | -169100.95
2000-09-12 00:00:00 | INTRA-GULF3-PRC | -42275.237
2000-09-12 00:00:00 | INTRA-MKT4-PRC | -42275.238
2000-09-12 00:00:00 | INTRA-MKTEAST-B | -1062352.8
2000-09-12 00:00:00 | INTRA-MKTEAST-G | -358110.16
2000-09-12 00:00:00 | INTRA-MKTEAST-P | -2817746.7
2000-09-12 00:00:00 | INTRA-NE-PROM2 | -95439.815
2000-09-12 00:00:00 | INTRA-NORTHEA1 | -3639218.8
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 | -1009988.2
2000-09-12 00:00:00 | INTRA-PRMPT-PHY | -18001.628
2000-09-12 00:00:00 | INTRA-PRMPT-PRC | -116348.02
2000-09-12 00:00:00 | INTRA-ST-COV-PR | -33001.687
2000-09-12 00:00:00 | INTRA-ST-COVE-B | -538.75739
2000-09-12 00:00:00 | INTRA-ST-HATT1 | -4305.1927
2000-09-12 00:00:00 | INTRA-ST-HATT3 | -15755.758
2000-09-12 00:00:00 | INTRA-ST-NAP-1 | -230940.97
2000-09-12 00:00:00 | INTRA-ST-NAP-3 | -58134.749
2000-09-12 00:00:00 | INTRA-TEXAS-B1 | -417148.45
2000-09-12 00:00:00 | INTRA-TEXAS-G1 | -153085.22
2000-09-12 00:00:00 | INTRA-TEXAS-P2 | -2110914.7
2000-09-12 00:00:00 | INTRA-TP1-P | -84550.475
2000-09-12 00:00:00 | INTRA-TP3-P | -2.737e-05
2000-09-12 00:00:00 | INTRA-TX-PROM2 | -353.75193
2000-09-12 00:00:00 | INTRA-WMWMEH-B | -127446.97
2000-09-12 00:00:00 | JOE_PARKS | -121706.17
2000-09-12 00:00:00 | J_ARNOLD | -5507000.1
2000-09-12 00:00:00 | J_KAISER | -1142440.6
2000-09-12 00:00:00 | J_MCKAY | -16020529
2000-09-12 00:00:00 | J_SCHWIEGER | -5581480
2000-09-12 00:00:00 | J_THOLT | -786500.01
2000-09-12 00:00:00 | J_WILLIAMS | -41252.812
2000-09-12 00:00:00 | K_HOLST | -22951749
2000-09-12 00:00:00 | K_STEVENS | -852092.63
2000-09-12 00:00:00 | LAVORATO-CND | -16020529 | -12320910.631 |  |  |  | Financial | 4749582.1 | 5248281.7003
2000-09-12 00:00:00 | LAVORATO-CNT | -16963823 | -12318614.704 |  |  |  | Texas | 7942459.6 | 5210762.9824
2000-09-12 00:00:00 | LAVORATO-EAST | -28031553 | -8714917.9797 |  |  |  | Canada | 16020529 | 12320910.631
2000-09-12 00:00:00 | LAVORATO-FIN | -4749582.1 | -5248281.7003 |  |  |  | Central | 16963823 | 12318614.704
2000-09-12 00:00:00 | LAVORATO-TEXAS | -7942459.6 | -5210762.9824 |  |  |  | East | 28031553 | 8714917.9797
2000-09-12 00:00:00 | LAVORATO-WEST | -54608655 | -38741468.963 |  |  |  | West | 54608655 | 38741468.963
2000-09-12 00:00:00 | L_MAY | -7240124.7
2000-09-12 00:00:00 | MGMT-WEST-BAS | -10636724
2000-09-12 00:00:00 | MGMT-WEST-GDL | -174543.32 |  |  |  |  |  | -1
2000-09-12 00:00:00 | MGMT-WEST-PRC | -125797.05
2000-09-12 00:00:00 | M_GRIGSBY | -11106964
2000-09-12 00:00:00 | M_LENHART | -457898.34
2000-09-12 00:00:00 | NG-ERMS-XL-PR1 | -1473821.7
2000-09-12 00:00:00 | NG-EXOTIC-PRC0 | -5480860.2
2000-09-12 00:00:00 | NG-LTX-PRC0 | -1588438.6
2000-09-12 00:00:00 | NG-MM-PRC | -501234.26
2000-09-12 00:00:00 | NG-OPT-XL-B | -280252.9
2000-09-12 00:00:00 | NG-OPT-XL-PRC0 | -186541.24
2000-09-12 00:00:00 | NG-OPT2-XL-B | -1155302.5
2000-09-12 00:00:00 | NG-PR-P | -656904.47
2000-09-12 00:00:00 | NG-PRICE-PRC0 | -11415247
2000-09-12 00:00:00 | OPTIONS-GDOPT1 | -16043.513
2000-09-12 00:00:00 | OPTIONS-PRICE1 | -6900144
2000-09-12 00:00:00 | OPTIONS-PRICE2 | -1050441.4
2000-09-12 00:00:00 | POLLAN | -196961.59
2000-09-12 00:00:00 | [NAME] | -10821693
2000-09-12 00:00:00 | P_KEAVEY | -1268704.2
2000-09-12 00:00:00 | P_LUCCI | -320244.26
2000-09-12 00:00:00 | RUSCITTI | -667990.75
2000-09-12 00:00:00 | ST-BAMMEL-BAS0 | -161483.56
2000-09-12 00:00:00 | ST-BAMMEL-HPL1 | -1122552.5
2000-09-12 00:00:00 | ST-BAMMEL-HPL4 | -5073575.9
2000-09-12 00:00:00 | ST-BAMMEL-PRC0 | -1106178.8
2000-09-12 00:00:00 | ST-ERMS-XL-PR1 | -96298.229
2000-09-12 00:00:00 | ST-MICHCON-CE1 | -1.1002774
2000-09-12 00:00:00 | ST-MICHCON-CE2 | -547135.62
2000-09-12 00:00:00 | ST-MICHCON-CE4 | -365307.52
2000-09-12 00:00:00 | S_HENDRICKSON | -42275.238
2000-09-12 00:00:00 | S_MULLHOLLAND | -293271.33
2000-09-12 00:00:00 | S_NEAL | -5589744.2
2000-09-12 00:00:00 | S_SOUTH | -786470.44
2000-09-12 00:00:00 | THURSTON | -473856.4
2000-09-12 00:00:00 | TOMASKI | -119739.75
2000-09-12 00:00:00 | T_DONAHOE | -254279.11
2000-09-12 00:00:00 | T_KUYKENDALL | -700459.14
2000-09-12 00:00:00 | T_MARTIN | -2661937.6
2000-09-12 00:00:00 | WEST-NW-BAS | -786470.44
2000-09-12 00:00:00 | WEST-NW-PRC | -0.00022366
2000-09-12 00:00:00 | WEST-PERM-BAS | -406642.47
2000-09-12 00:00:00 | WEST-PERM-PRC | -169100.95
2000-09-12 00:00:00 | WEST-SJ-BAS | -699726.92
2000-09-12 00:00:00 | WEST-SJ-GDL | -1301.2682
2000-09-12 00:00:00 | WEST-SW-BAS | -771439.86
2000-09-12 00:00:00 | WEST-SW-GDL | -91374.739
200 rows | selected.
SQL> spoo | l off