Spreadsheet: kam_keiser__17772__EastGulf3&4 Calc  Procedures
Sheet: Calc Procedures

 | East Gulf3 and East Gulf4 P&L and Position Calculation Procedures
 | BookAdmin:  [NAME] (Ext. 53579)
 | Morning Procedures
Note: | the region file mentioned below is the file found at O:\ERMS\erms-adm\Firmtrade\2001\0601\Regions\Intro-East Gulf0601.xls
 | the minibench file menitoned below is the file found at O:\ERMS\erms-adm\Firmtrade\Benchmark\2001\Jun-01\HS-IM-East-Gulf.xls
1 | Open the region file at O:\ERMS\erms-adm\Firmtrade\2001\0601\Regions\Intro-East Gulf0601.xls
2 | Go to the "Gulf3 Sum" tab, Click on "Copy Physical-Gulf3" Macro, so that the prior day MTD P/L is copied.
3 | Go to the "Gulf4 Summ" tab, Click on "Copy Physical-Gulf4" Macro, so that the prior day MTD P/L is copied.
4 | Go to the "Total Summary" tab, Click on "Copy Physical-Total" Macro, so that the prior day MTD P/L is copied.
5 | Go to the "Gulf3 Sum" tab, update the date (in Blue) and Accrued date (in Blue). These dates can be found on the Postid Tab Column B for current
 | date and column H for Accrued dates
6 | Go to the [NAME], update the current date as today's date
7 | Click on "Copy Daily" Macro so that the prior day's P&L will be copied.
8 | Open the TAGG-MetaCalc application, and input the prior day Metaid (in red) on the [NAME] tab.  [NAME] this metaid, and Click on Calculate and Refresh
 | buttons, and input the copied metaid and price,basis and index postids on the Postid tab
9 | Open the CopyPostID application, the UserID is EastGulf and the password is EastGulf.
10 | Click on "Copy Post_ID' menu, and wait for 2 seconds - The current postids for physical, transport, omicrons and gas daily will be copied.
11 | Input these postids into the [NAME] tab, make sure they match correctly.
Important: [NAME] first and then use "Copy Post_ID' macro, because the spreadsheet requires that the numbers for price basis index postids
should be smaller than the numbers for gas daily postids.
12 | Open the TAGG-Meta Calc application and input the new deal postid (I.e. 79743) and update the date as today's date. Click on "Change" button
 | and change the date as the today's date.
13 | Go to PortCalc in the Unix system to update the postids for Gas Daily index and Gas Daily for TDS positions. Specifically, to update the postids for Gas Daily Index, update Today's
 | date as current date and Period day as the last business date. To update the postids for TDS positions, update the Today as current date and Prior day as yesterday's date
 | and change the Liquidation Date as one business day after the current date ( e.g. if the current date is June 12,2001, the Liquidation date is June 13, 2001)
14 | Save the region file.
15 | Open the Minibentch file at O:\ERMS\erms-adm\Firmtrade\Benchmark\2001\Jun-01\HS-IM-East-Gulf.xls
16 | Go to "Run Query" and update the date (in pink) as the current date
17 | Save the Minibench file
 | Afternoon Procedures
18 | Use TAGG-Meta Calc to Calc the new deal metaid ([NAME])
19 | Go to [NAME] By Risk Type on PortCalc in the Unix system, input the new deal postids for price, basis and index, and press F8
 | twice to print out the new deal report for Price, Basis and Index.
20 | Open "EnronOnline Production Cluster" , user name is ytian, and password is "goodluck!". Click on my computer\C:\Click Trade\StackManager\EOLReports
 | User name is ytian, and Password is yuantian. When EOL Report Launcher is open, click on "Transaction Summary" and Launch button.
21 | To print out the financial new deals, input " East Gulf3" and "East Gulf4" in Couterparties. To print out the physical new deals, input "[NAME]"
 | as the Traders.
22 | Check new deals by comparing the information on EOL new deal report and deal tickets with the new deal report from the new deal [NAME].
 | This is only to check the financial new deals, and to make sure all the new deals on EOL and deal tickets have been captured in the new deal [NAME].
23 | Use PorCalc to [NAME] the postids for Physical, transport, omicrons, gas daily (P&L and positions), gas daily index, and gas daily for TDS positions
24 | Use TAGG-Meta Calc to Calc the current metaid. After the calc is done, check the box for "Official Books" to officialize these postids.
25 | After the current [NAME] is done, Go to the region file and the "Input" tab, and click on "Top Pages" macro.
26 | After the current [NAME] is done, Go to the Report in the Unix system, Click on Top Page button, and input the postids for Price, Basis and Index
 | to print out the top pages
27 | Check the top pages by comparing the printed top pages with the "Top Pages" ,i.e.. Check if the values  ( e.g. curve shift, new deal, and deal value)
 | are the same
28 | Open Microsoft Access application and open C:\WeaponX\EastFinancial Reports, input the Price,Basis, Index and Gas Daily current and prior
 | postids, click on "Get it!"
29 | After the status is "completed", print out the curveshift reports, changed deals reports and new deal report. The new deal reports for Price, Basis and Index can also be printed as in step 18 from
 | the Unix System.
30 | After the Transport postids are done with the calculation, open the WeaponX X (25.9 version for both Gulf3 and Gulf4), and input current transport
 | postid and previous postid.  Click on "Value against W.A.C.O.G." and input the current WACOG. Enter the date for "apply WACOG to Previous price"
 | as the date on column, and enter the date for "apply WACOG to Current Price" and "On or Before Date (mm/dd/yyyy) as the date on column J.
 | WACOG for June
 | Book | WACOG
 | Gulf 3 - | 3.63
 | Gulf 4 - | 3.654
31 | When the WeaponX is done, print out the Desk Level Summary, Curve Shift Report, New Deal Report, and Change Deal Report.
32 | When the WeaponX for Gulf3 is done, input the values on the Desk Level Summary for Gulf 3 into the WeaponX tab on the Region file by clicking the "Gulf3" Macro which will automatically fill
33 | the desk level summary values into the WeaponX tab.
34 | When the WeaponX for Gulf4 is done, input the values on the Desk Level Summary for Gulf 4 into the WeaponX tab on the Region file by clicking the "Gulf4" Macro which will automatically fill
 | the desk level summary values into the WeaponX tab.
35 | Check the values on the printed Desk Level Summary with the values on the WeaponX tab in Region file, and make sure they match each other well.
36 | After the physical and financial omicron postids are done calculating,  click on "Intramonth" button on Report page in Unix System. Click on "Physical
 | [NAME]", input physical omicron postid under"Intramonth Post Id", and input "financial omicron postid under Gas Daily Post ID,  change the "Type" to
 | "Summary". Click on Print/Run to print out the Omicron Report
37 | Find if there are any "Hedged Values" on the Omicron Report by finding if there are pub codes that are in Gulf 3 and Gulf 4 on the Omicron Report.
 | Input the  "Hedged values" in the Gulf 3 and Gulf4 in the "Gulf 3 Physical" and "Gulf4 Physical" accordingly.
38 | After all the postids for positions are done calculating, officailize these postid (I.e. Physical, Gas Daily postid for positions) by putting 1 in the Official COB Book in PortCalc.
39 | After all the postids are officialized, go to the minibench file at O:\ERMS\erms_adm\Frimtrade\Benchmark\2001\June-01\HS-IM-East-Gulf,
 | Click on "Hedge Strip" Macro, GMRS Positions macro, "FIX GRMS DETAIL" Macro
40 | Go to the Report page in the UNIX system, Click on "P&L Summ" button, Click on Hedge Strip by Pub box, and input postids for
 | physical positions, gas daily position, price,basis and index positions, and gas daily index positions to print out the hedge strips for position postids
41 | Go the minibench file and go to the "Financial Book Position" tab, check each postion(i.e. price, basis, index, gas daily,gas daily index
 | and physical MTM positions) with the hedge strip.  Make sure they are the same.
42 | Go to the Website http://rac.enron.com/riskMamtControls/index.html, Username is ytian, Password is goodluck!
43 | Go to the Exception Reports, click on Active/Inactive Book Listing, Admin ID is ytian, click on Display Both, and click on Search
 | print out the  Post_Id/Book_Id List, and market sure the PostIDs match the BookID and Status is ACTIVE.
Important :MKT5 does not exist anymore, so the status for EAST-MKT5 is inactive .
44 | Final Check
 | 1 | Check WeaponX report for the P&L resonablness on the physical deals (e.g. is there 0 price in the new deal report, are the gains& losses in Changed Deal Report reasonable?)
 | 2 | Is the Liquidation day at the bottom of Gulf3 Sum and [NAME] tab close to 0
 | 3 | P&L reasonableness
 | 4 | Is there a big position change?
 | 5 | Are the positions officialized?
45 | [NAME] that the East Gulf P&L has been saved to the region
46 | Sign off the printed P&L sheet from [NAME] and give it to [NAME]
47 | Sign off a printed minibench and give it to [NAME]
48 | save the region file as a daily file at O:\Erms\1intra\East\Intra-East\Gulf\June-01\Intra-East Gulf 06xx.xls
49 | Go to the P&L total file at ERMS\1intra\East\positions\June-2001\East P&L current date.xls to update the link |  |  |  |  |  |  |  |  |  | Intra-East Gulf Current Month.xls
.
50 | Go to the YTD tab on the Regions file, input the Storage values for Gulf4 on P&L totals into the Box3 and check P&L in Box 1 with the P&L on
 | the P&L total  file.
51 | Check the Box4 with the P&L Total on P&L Total file
52 | Go to the position total file at ERMS\1intra\East\postions\June-2001\current date.xls to update the link |  |  |  |  |  |  |  |  |  | HS_IM-East-Gulf.xls.
53 | Check the positions on the minibench file with the positions on the position total file.
54 | Go to Business Application\TDS\TDS Position Load, the user name is ytian_pc, and the password is ytian_pc
55 | Load the East Gulf3 and East Gulf4 positions by putting East-Gulf3 and East-Gulf4 as the desk names and clicking on "Load Positions" button
Reports for Traders
1 | P&L Report on Gulf3 Sum and [NAME] tab.
2 | The Financial deals - The new deals, curve shift and changed deal reports that explains Financial Trading P&L
3 | The Physical deals - The WeaponX report for including everything and excluding gas daily
4 | An individual position report -
 | a | Go to the Position Total file, highlight the positions for East Gulf3, set the highlighted area as print area, and print it out as one page (legal size)
 | b | Go to the Position Total file, highlight the positions for East Gulf4, set the highlighted area as print area, and print it out as one page (legal size)
5 | MTM Physical Report - print out the hedge strip for MTM Physical positions from the Unix system
Reports for record
1 | P&L Report on Gulf3 Sum and [NAME] tab.
2 | The Financial deals - The new deals, curve shift and changed deal reports that explains Financial Trading P&L
3 | The Physical deals - The WeaponX report for including everything and excluding gas daily
4 | The Top Pages for financial deals ( price, basis and index deals, gas daily P&L )
5 | The Hedge Strips for position postids ( MTM Physical postids, price, basis, index, gas daily, gas daily index )
6 | EOL Report - financial and physical new deal report
7 | Deal tickets
8 | Printed copy of Post_Id and Book_Id list on step 39
9 | Printed minibench
IF you are the last one to finish the P&L and Postion Report, You should also do the following:
1 | Print out a copy of East P&L totals file
2 | Print out a copy of East Positions totals file - "Positions Totals" tab and "FT_Books" tab
3 | Make 16 copies of the P&L and Positions totals, give one copy to [NAME], and hand out the other 15 copies to the traders whose names are on
 | the P&L and Position totals file.