Spreadsheet: andy_zipper__343__New Co Nuke outage stress
Sheet: Sheet2

PRICE CD | RISK_TYPE_CD | COMMODITY_CD | CURRENCY_CD | PEAKNESS_CD | REFERENCE_DT | DELTA_POSITION_QTY | GAMMA | Stress Amt | Stress PNL | Region
NG | P | NG | USD |  | 2002-01-01 00:00:00 | -26250000 |  | 0.25 | -6562500 | NG
NG | P | NG | USD |  | 2002-02-01 00:00:00 | -11250000 |  | 0.23 | -2587500 | NG
NG | P | NG | USD |  | 2002-03-01 00:00:00 | -11250000 |  | 0.2 | -2250000 | NG
NG | P | NG | USD |  | 2002-04-01 00:00:00 | -5625000 |  | 0.18 | -1012500 | NG
NG | P | NG | USD |  | 2002-05-01 00:00:00 | -5625000 |  | 0.17 | -956250 | NG
NG | P | NG | USD |  | 2002-06-01 00:00:00 | -5625000 |  | 0.15 | -843750 | NG
NG | P | NG | USD |  | 2002-07-01 00:00:00 | -5625000 |  | 0.13 | -731250 | NG
NG | P | NG | USD |  | 2002-08-01 00:00:00 | -5625000 |  | 0.1 | -562500 | NG
NG | P | NG | USD |  | 2002-09-01 00:00:00 | -5625000 |  | 0.1 | -562500 | NG
NG | P | NG | USD |  | 2002-10-01 00:00:00 | -5625000 |  | 0.1 | -562500 | NG
NG | P | NG | USD |  | 2002-11-01 00:00:00 | -5625000 |  | 0.09 | -506250 | NG
NG | P | NG | USD |  | 2002-12-01 00:00:00 | -5625000 |  | 0.09 | -506250 | NG
NG | P | NG | USD |  | 2003-01-01 00:00:00 | -3750000 |  | 0.07 | -262500 | NG
NG | P | NG | USD |  | 2003-02-01 00:00:00 | -3750000 |  | 0.06 | -225000 | NG
NG | P | NG | USD |  | 2003-03-01 00:00:00 | -3750000 |  | 0.05 | -187500 | NG
NG | P | NG | USD |  | 2003-04-01 00:00:00 | -3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2003-05-01 00:00:00 | -3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2003-06-01 00:00:00 | -3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2003-07-01 00:00:00 | -3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2003-08-01 00:00:00 | -3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2003-09-01 00:00:00 | -3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2003-10-01 00:00:00 | -3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2003-11-01 00:00:00 | -3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2003-12-01 00:00:00 | -3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2004-01-01 00:00:00 | 3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2004-02-01 00:00:00 | 3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2004-03-01 00:00:00 | 3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2004-04-01 00:00:00 | 3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2004-05-01 00:00:00 | 3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2004-06-01 00:00:00 | 3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2004-07-01 00:00:00 | 3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2004-08-01 00:00:00 | 3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2004-09-01 00:00:00 | 3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2004-10-01 00:00:00 | 3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2004-11-01 00:00:00 | 3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2004-12-01 00:00:00 | 3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2005-01-01 00:00:00 | 3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2005-02-01 00:00:00 | 3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2005-03-01 00:00:00 | 3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2005-04-01 00:00:00 | 3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2005-05-01 00:00:00 | 3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2005-06-01 00:00:00 | 3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2005-07-01 00:00:00 | 3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2005-08-01 00:00:00 | 3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2005-09-01 00:00:00 | 3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2005-10-01 00:00:00 | 3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2005-11-01 00:00:00 | 3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2005-12-01 00:00:00 | 3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2006-01-01 00:00:00 | -3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2006-02-01 00:00:00 | -3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2006-03-01 00:00:00 | -3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2006-04-01 00:00:00 | -3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2006-05-01 00:00:00 | -3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2006-06-01 00:00:00 | -3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2006-07-01 00:00:00 | -3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2006-08-01 00:00:00 | -3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2006-09-01 00:00:00 | -3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2006-10-01 00:00:00 | -3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2006-11-01 00:00:00 | -3750000 |  | 0 | 0 | NG
NG | P | NG | USD |  | 2006-12-01 00:00:00 | -3750000 |  | 0 | 0 | NG
NGI-SOCAL | D | NG | USD |  | 2002-01-01 00:00:00 | 3000000 | 0 | -2.5 | -7500000 | Socal
NGI-SOCAL | D | NG | USD |  | 2002-02-01 00:00:00 | 1500000 | 0 | -2.5 | -3750000 | Socal
NGI-SOCAL | D | NG | USD |  | 2002-03-01 00:00:00 | 1500000 | 0 | -2.5 | -3750000 | Socal
NGI-SOCAL | D | NG | USD |  | 2002-04-01 00:00:00 | 900000 | 0 | -2.25 | -2025000 | Socal
NGI-SOCAL | D | NG | USD |  | 2002-05-01 00:00:00 | 900000 | 0 | -2.25 | -2025000 | Socal
NGI-SOCAL | D | NG | USD |  | 2002-06-01 00:00:00 | 900000 | 0 | -2.25 | -2025000 | Socal
NGI-SOCAL | D | NG | USD |  | 2002-07-01 00:00:00 | 900000 | 0 | -2.15 | -1935000 | Socal
NGI-SOCAL | D | NG | USD |  | 2002-08-01 00:00:00 | 900000 | 0 | -1.75 | -1575000 | Socal
NGI-SOCAL | D | NG | USD |  | 2002-09-01 00:00:00 | 900000 | 0 | -1.75 | -1575000 | Socal
NGI-SOCAL | D | NG | USD |  | 2002-10-01 00:00:00 | 900000 | 0 | -1.4 | -1260000 | Socal
NGI-SOCAL | D | NG | USD |  | 2002-11-01 00:00:00 | 600000 | 0 | -1.5 | -900000 | Socal
NGI-SOCAL | D | NG | USD |  | 2002-12-01 00:00:00 | 600000 | 0 | -1.5 | -900000 | Socal
NGI-SOCAL | D | NG | USD |  | 2003-01-01 00:00:00 | 600000 | 0 | -1.5 | -900000 | Socal
NGI-SOCAL | D | NG | USD |  | 2003-02-01 00:00:00 | 600000 | 0 | -1.5 | -900000 | Socal
NGI-SOCAL | D | NG | USD |  | 2003-03-01 00:00:00 | 600000 | 0 | -1.5 | -900000 | Socal
NGI-MALIN | D | NG | USD |  | 2002-01-01 00:00:00 | -1500000 | 0 | -2.5 | 3750000 | Socal
NGI-MALIN | D | NG | USD |  | 2002-02-01 00:00:00 | -750000 | 0 | -2.5 | 1875000 | Socal
NGI-MALIN | D | NG | USD |  | 2002-03-01 00:00:00 | -750000 | 0 | -2.5 | 1875000 | Socal
NGI-MALIN | D | NG | USD |  | 2002-04-01 00:00:00 | -450000 | 0 | -2.25 | 1012500 | Socal
NGI-MALIN | D | NG | USD |  | 2002-05-01 00:00:00 | -450000 | 0 | -2.25 | 1012500 | Socal
NGI-MALIN | D | NG | USD |  | 2002-06-01 00:00:00 | -450000 | 0 | -2.25 | 1012500 | Socal
NGI-MALIN | D | NG | USD |  | 2002-07-01 00:00:00 | -450000 | 0 | -2.15 | 967500 | Socal
NGI-MALIN | D | NG | USD |  | 2002-08-01 00:00:00 | -450000 | 0 | -1.75 | 787500 | Socal
NGI-MALIN | D | NG | USD |  | 2002-09-01 00:00:00 | -450000 | 0 | -1.75 | 787500 | Socal
NGI-MALIN | D | NG | USD |  | 2002-10-01 00:00:00 | -450000 | 0 | -1.4 | 630000 | Socal
NGI-MALIN | D | NG | USD |  | 2002-11-01 00:00:00 | -300000 | 0 | -1.5 | 450000 | Socal
NGI-MALIN | D | NG | USD |  | 2002-12-01 00:00:00 | -300000 | 0 | -1.5 | 450000 | Socal
NGI-MALIN | D | NG | USD |  | 2003-01-01 00:00:00 | -300000 | 0 | -1.5 | 450000 | Socal
NGI-MALIN | D | NG | USD |  | 2003-02-01 00:00:00 | -300000 | 0 | -1.5 | 450000 | Socal
NGI-MALIN | D | NG | USD |  | 2003-03-01 00:00:00 | -300000 | 0 | -1.5 | 450000 | Socal
NGI-PGE/CG | D | NG | USD |  | 2002-01-01 00:00:00 | 3000000 | 0 | -2.5 | -7500000 | Socal
NGI-PGE/CG | D | NG | USD |  | 2002-02-01 00:00:00 | 1500000 | 0 | -2.5 | -3750000 | Socal
NGI-PGE/CG | D | NG | USD |  | 2002-03-01 00:00:00 | 1500000 | 0 | -2.5 | -3750000 | Socal
NGI-PGE/CG | D | NG | USD |  | 2002-04-01 00:00:00 | 900000 | 0 | -2.25 | -2025000 | Socal
NGI-PGE/CG | D | NG | USD |  | 2002-05-01 00:00:00 | 900000 | 0 | -2.25 | -2025000 | Socal
NGI-PGE/CG | D | NG | USD |  | 2002-06-01 00:00:00 | 900000 | 0 | -2.25 | -2025000 | Socal
NGI-PGE/CG | D | NG | USD |  | 2002-07-01 00:00:00 | 900000 | 0 | -2.15 | -1935000 | Socal
NGI-PGE/CG | D | NG | USD |  | 2002-08-01 00:00:00 | 900000 | 0 | -1.75 | -1575000 | Socal
NGI-PGE/CG | D | NG | USD |  | 2002-09-01 00:00:00 | 900000 | 0 | -1.75 | -1575000 | Socal
NGI-PGE/CG | D | NG | USD |  | 2002-10-01 00:00:00 | 900000 | 0 | -1.4 | -1260000 | Socal
NGI-PGE/CG | D | NG | USD |  | 2002-11-01 00:00:00 | 600000 | 0 | -1.5 | -900000 | Socal
NGI-PGE/CG | D | NG | USD |  | 2002-12-01 00:00:00 | 600000 | 0 | -1.5 | -900000 | Socal
NGI-PGE/CG | D | NG | USD |  | 2003-01-01 00:00:00 | 600000 | 0 | -1.5 | -900000 | Socal
NGI-PGE/CG | D | NG | USD |  | 2003-02-01 00:00:00 | 600000 | 0 | -1.5 | -900000 | Socal
NGI-PGE/CG | D | NG | USD |  | 2003-03-01 00:00:00 | 600000 | 0 | -1.5 | -900000 | Socal
IF-NWPL_ROCKY_M | D | NG | USD |  | 2002-01-01 00:00:00 | -3000000 | 0 | -1.5 | 4500000 | Rocky
IF-NWPL_ROCKY_M | D | NG | USD |  | 2002-02-01 00:00:00 | -1500000 | 0 | -1.5 | 2250000 | Rocky
IF-NWPL_ROCKY_M | D | NG | USD |  | 2002-03-01 00:00:00 | -1500000 | 0 | -1.3 | 1950000 | Rocky
IF-NWPL_ROCKY_M | D | NG | USD |  | 2002-04-01 00:00:00 | -1500000 | 0 | -1.2 | 1800000 | Rocky
IF-NWPL_ROCKY_M | D | NG | USD |  | 2002-05-01 00:00:00 | -1500000 | 0 | -1.1 | 1650000 | Rocky
IF-NWPL_ROCKY_M | D | NG | USD |  | 2002-06-01 00:00:00 | -1500000 | 0 | -1 | 1500000 | Rocky
IF-NWPL_ROCKY_M | D | NG | USD |  | 2002-07-01 00:00:00 | -1500000 | 0 | -0.95 | 1425000 | Rocky
IF-NWPL_ROCKY_M | D | NG | USD |  | 2002-08-01 00:00:00 | -1500000 | 0 | -0.9 | 1350000 | Rocky
IF-NWPL_ROCKY_M | D | NG | USD |  | 2002-09-01 00:00:00 | -1500000 | 0 | -0.9 | 1350000 | Rocky
IF-NWPL_ROCKY_M | D | NG | USD |  | 2002-10-01 00:00:00 | -1500000 | 0 | -0.9 | 1350000 | Rocky
IF-NWPL_ROCKY_M | D | NG | USD |  | 2002-11-01 00:00:00 | -600000 | 0 | -0.9 | 540000 | Rocky
IF-NWPL_ROCKY_M | D | NG | USD |  | 2002-12-01 00:00:00 | -600000 | 0 | -0.9 | 540000 | Rocky
IF-NWPL_ROCKY_M | D | NG | USD |  | 2003-01-01 00:00:00 | -600000 | 0 | -0.9 | 540000 | Rocky
IF-NWPL_ROCKY_M | D | NG | USD |  | 2003-02-01 00:00:00 | -600000 | 0 | -0.9 | 540000 | Rocky
IF-NWPL_ROCKY_M | D | NG | USD |  | 2003-03-01 00:00:00 | -600000 | 0 | -0.9 | 540000 | Rocky
IF-ELPO/SJ | D | NG | USD |  | 2002-01-01 00:00:00 | 1000000 | 0 | -1.5 | -1500000 | Rocky
IF-ELPO/SJ | D | NG | USD |  | 2002-02-01 00:00:00 | 600000 | 0 | -1.5 | -900000 | Rocky
IF-ELPO/SJ | D | NG | USD |  | 2002-03-01 00:00:00 | 600000 | 0 | -1.3 | -780000 | Rocky
IF-ELPO/SJ | D | NG | USD |  | 2002-04-01 00:00:00 | 600000 | 0 | -1.2 | -720000 | Rocky
IF-ELPO/SJ | D | NG | USD |  | 2002-05-01 00:00:00 | 600000 | 0 | -1.1 | -660000 | Rocky
IF-ELPO/SJ | D | NG | USD |  | 2002-06-01 00:00:00 | 600000 | 0 | -1 | -600000 | Rocky
IF-ELPO/SJ | D | NG | USD |  | 2002-07-01 00:00:00 | 600000 | 0 | -0.95 | -570000 | Rocky
IF-ELPO/SJ | D | NG | USD |  | 2002-08-01 00:00:00 | 600000 | 0 | -0.9 | -540000 | Rocky
IF-ELPO/SJ | D | NG | USD |  | 2002-09-01 00:00:00 | 600000 | 0 | -0.9 | -540000 | Rocky
IF-ELPO/SJ | D | NG | USD |  | 2002-10-01 00:00:00 | 600000 | 0 | -0.9 | -540000 | Rocky
IF-ELPO/SJ | D | NG | USD |  | 2002-11-01 00:00:00 | 600000 | 0 | -0.9 | -540000 | Rocky
IF-ELPO/SJ | D | NG | USD |  | 2002-12-01 00:00:00 | 600000 | 0 | -0.9 | -540000 | Rocky
IF-ELPO/SJ | D | NG | USD |  | 2003-01-01 00:00:00 | 600000 | 0 | -0.9 | -540000 | Rocky
IF-ELPO/SJ | D | NG | USD |  | 2003-02-01 00:00:00 | 600000 | 0 | -0.9 | -540000 | Rocky
IF-ELPO/SJ | D | NG | USD |  | 2003-03-01 00:00:00 | 600000 | 0 | -0.9 | -540000 | Rocky