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