Message-ID: <14134145.1075841551336.JavaMail.evans@thyme> Date: Tue, 14 Aug 2001 08:56:25 -0700 (PDT) From: asem.atta@enron.com To: cara.semperger@enron.com Subject: RE: Further Testing of PSW Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-From: Atta, Asem X-To: Semperger, Cara X-cc: X-bcc: X-Folder: \ExMerge - Semperger, Cara\Deleted Items X-Origin: SEMPERGER-C X-FileName: cara semperger 6-26-02.PST Cara, Dont worry about the code for Ive taken the time to go through it and make it so that when you export from within our PreschedWS all it needs is a pre-existing PhysicalAndBookoutSummary_v2_54_WESTTestP.xls file with at least one previous detail entry and it will automatically create a new entry for the day with totals in each region's category. Do our best to make life easier ;> regards Asem x31700 -----Original Message----- From: Semperger, Cara Sent: Tuesday, August 14, 2001 10:13 AM To: Atta, Asem Subject: RE: Further Testing of PSW Asem, I could copy the sheet onto my local drive, but I have no idea about the code behind it and what I might have to do to it in order to make it work. C -----Original Message----- From: Atta, Asem Sent: Tuesday, August 14, 2001 7:45 AM To: Semperger, Cara Cc: Smith, Will; Venkataswami, Vishwanatha Subject: RE: Further Testing of PSW Cara, Understood, and your plan sounds fine.. any chance of you copying that production sheet onto your local machine and using it as your own 'test' copy then? The plan for having the reports merged with AggSchedVol data, talking with the team and Poston for info gathering, is a month after full initial release of our current phase. thanks Asem x31700 -----Original Message----- From: Semperger, Cara Sent: Monday, August 13, 2001 03:49 PM To: Atta, Asem Subject: RE: Further Testing of PSW What I meant was I would run one day and put test data in the production sheet (since there is not a test sheet of that), and then go get rid of that day when it looks like it calculated right. I know so little about that sheet, I am a typical user and just know what I want. How long after the initial release into production do you all think It will be until we get the project cleared to have this data merged with the AggSchedVol Data? That is the ultimate goal. Poston has his FSP data that will be part of this too. -----Original Message----- From: Atta, Asem Sent: Monday, August 13, 2001 1:44 PM To: Semperger, Cara Subject: RE: Further Testing of PSW Cara, Not a prob, the application wont look at the prod summary file unless you log in against PWRPRODN, so if you are logging against the test db's yer safe.. and for the summary to work it does require at least one previous summary detail in that excel file to work.. it uses that excel's defined macros and such to calculate the totals.. so doing a complete purge wouldnt do good.. do let me know if you have any questions about this.. be more than happy to help. regards Asem x31700 -----Original Message----- From: Semperger, Cara Sent: Monday, August 13, 2001 03:24 PM To: Atta, Asem Subject: RE: Further Testing of PSW Hi Asem; O:\Portland\WestDesk\SCHEDULING\PhysicalAndBookoutSummary_v2_54_WESTPROD.xls This is the right address. I am reluctant to add data to the production model, as it will mess up my reports. I might rename a test file with a strange date, and then purge it. That should work, eh? Thanks, C -----Original Message----- From: Atta, Asem Sent: Monday, August 13, 2001 1:20 PM To: Semperger, Cara Cc: Venkataswami, Vishwanatha; Smith, Will Subject: RE: Further Testing of PSW Cara, Reason for the error is that the file it was looking for was titled PhysicalAndBookoutSummary_v2_54_WESTTestP.xls . Ive gone ahead and made changes to the application to read the file named as such. Since we're talking about locations of these summary files.. is the production report located at O:\Portland\WestDesk\SCHEDULING\PhysicalAndBookoutSummary_v2_54_WESTPROD.xls ? unfortunately i dont have access to the directories to find out for myself. thanks Asem x31700 -----Original Message----- From: Venkataswami, Vishwanatha Sent: Monday, August 13, 2001 03:09 PM To: Atta, Asem Subject: FW: Further Testing of PSW -----Original Message----- From: Semperger, Cara Sent: Monday, August 13, 2001 03:08 PM To: Bentley, Corry; Poston, David; Smith, Will; Venkataswami, Vishwanatha Subject: Further Testing of PSW Good Afternoon, I tried to run the Physical and Bookout summary, and got this error "Unable to locate M:\Electric\Schedule\Process\WEST\Stage\PhysicalAndBookoutSummary_v2_54_WESTTest.xls" c