here is the file.  You would change the two curve tabs and the publish tabs are linked up.  The BOM file is unchanged.  The two basis files now only have basis curves in them.  Let me know any changes you would like.  Thanks.
PL
 

 -----Original Message-----
From: 	Grigsby, Mike  
Sent:	Tuesday, January 15, 2002 9:43 AM
To:	Love, Phillip M.
Subject:	RE: phys/gd curve file

Just to be more clear.  The file will combine the Gas Daily index and the Physical Index curves.  The Gas Daily BOM can remain in a separate file.

Thanks,
Mike

 -----Original Message-----
From: 	Love, Phillip M.  
Sent:	Tuesday, January 15, 2002 9:41 AM
To:	Grigsby, Mike
Subject:	RE: phys/gd curve file

absolutely.  I will make the changes and have something to you this afternoon.
PL


 -----Original Message-----
From: 	Grigsby, Mike  
Sent:	Tuesday, January 15, 2002 9:35 AM
To:	Love, Phillip M.
Subject:	RE: phys/gd curve file

Thanks.  Can we combine the file for Gas Daily and Physical Index curves - I will be updating this file and the Balance of the month file.  Keith Holst will update the CA basis, while Frank Ermis updates the ROX and SW file.

Mike

 -----Original Message-----
From: 	Love, Phillip M.  
Sent:	Monday, January 14, 2002 2:21 PM
To:	Grigsby, Mike
Subject:	phys/gd curve file

Attached is the curve file for phys and gas daily.  I made this extremely simple on our first pass, but I left in the tabs that were in the old/current file.  All you would do would be to go to the fin tab and hard code balance of month price for each of the curve locations(yellow column).  This will then set the gas daily curve.  We will continue to true up to gas daily each day.  You may want to also reset the next day's curve as well, since this is a hardcode, you simply type over the previous day's load.  The phys tab pulls from the fin tab and adds the phys prem to it.  We can increase the complexity of this file by adding formulas or tabs if you like.  I figure you will want to keep your model and I can pull info from there as well.  I simply wanted to start out at a baseline and build it to best fit your needs.  Please let me know what you would like to see changed and we will do it.  Thanks.
PL
 << File: West phys curve.xls >>