TJ looking into the formulas, with Anna's assistance as best she can by telephone and IM.  We had to dump the existing export deviation records and re-do the manuals that had been previously added incorrectly, so that type will have to be run through the process again for sure.

No additional progress on any of the other things that need to be done for September, with the exception of 3 days worth of Finals actualized without deviations.

Tomorrow is another day, and if Anna is back we'll get that much closer to completion of Prelims by weeks' end.  At least we didn't have a database crash today.

C
---------------------- Forwarded by Caroline Emmert/HOU/ECT on 04/11/2001 04:27 PM ---------------------------


Caroline Emmert
04/10/2001 04:01 PM
To:	Chris Stokley/HOU/ECT@ECT
cc:	 
Subject:	Deviation Actualization Update

Continue to have difficulties matching up volumes for Import Deviation, caused by an internal database functionality problem.  

Have analyzed the Instructed/Uninstructed settlement data provided by the ISO and created formulas for variance identification and allocation for all types of deviation, as well as special case handling (exceptions or export deviation for example).  Also looking into Region differences and working with Anna on how to incorporate region into the process.

Anna has added the functionality to be able to actualize by settlement file SeqID, but this needs to be tested (settlement database crash prohibited proper testing today).

Reviewed TJ's functionality for allocating dollar variances in Total 407 (after volumetric and related dollar variances are allocated, remaining dollar variances are applied to ECTstCA); provided feedback on same.

Need to accomplish the following  to wrap-up September:

Review formulas currently in database - revise if needed
Test formulas
Obtain valid allocations for variances (especially for 405)
Check results on new allocations for 402, 403 and 404 to see if formula changes made any difference, and if so, is difference good
Delete existing allocations (based on current formulas, may be invalid)
Send new allocations up to FSP
Run total 407
Re-run whole process for Finals
Finish Final actualizations (Brett left off at the 19th)

Anticipate completion of deviation stuff for Prelims complete by end of week, and finals by Tuesday next.

C