Message-ID: <33170086.1075858504847.JavaMail.evans@thyme> Date: Fri, 27 Apr 2001 13:23:00 -0700 (PDT) From: caroline.emmert@enron.com To: volume_management_portland@enron.com Subject: Details for Changes to Settle15 and SettleSupplemental Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-From: Emmert, Caroline X-To: Volume_Management_Portland X-cc: X-bcc: X-Folder: \Stokley, Chris (Non-Privileged)\Chris Stokley\Volume Mang. X-Origin: Stokley-C X-FileName: Stokley, Chris (Non-Privileged).pst Details of Changes: The changes to SettleSupp were in the rate formula. The original formula said, :"=IF(AK4>0,Curves!i49,Curves!I42), which means that if the volume in AK4 is greater than zero, use the Inc (I49 reference) price, otherwise use the Dec (I42 reference). The problem was that the references were backwards, so I switched them to be . . .Curves!I42,Curves!I49. That made the correct price come in. This affected the 405 part of SettleSupp only, no other charges were modified. For 403, the rate formula was "=IF(AK20<0,CURVES!I81,CURVES!i88" which means that if the deviation volume was less than zero, use the Inc, otherwise use the Dec. I changed it so that it reads . . .(AK20>0,CURVES!i81. . .) so that it would use the Inc if the dev volume is greater than zero. I confirmed that the dev volume calcs were correct first. In all of my test runs, both of these changes pulled in the correct Inc or Dec rate, and applied it to the correct dev volume. Caroline ---------------------- Forwarded by Caroline Emmert/HOU/ECT on 04/27/2001 08:29 AM --------------------------- Caroline Emmert 04/27/2001 07:54 AM To: Volume_Management_Portland cc: Subject: Changes to Settle15 and SettleSupplemental There were changes on made on 4/24 to both Settle15 and SettleSupplemental related to the rate calc. The old versions have been copied off into the Backup directory with today's date, and the new versions have been saved as Settle15_TenMinute.xls and SettleSupplemental.xls. Caroline