Latest on where we stand with day after interval meter data.

 -----Original Message-----
From: 	Rutledge, John  
Sent:	Thursday, August 16, 2001 6:38 AM
To:	Stokley, Chris
Cc:	Alvarez, Charles
Subject:	Re: FW: CES2423 Project Proposal

Chris--

I guess you must be in Portland--I left a voice mail for you yesterday.

Anyway, I don't know exactly who here at Enron is responsible for representing our priorities for these matters to CSC. I talked to Geoff Goodfellow in Dublin and he suggested Bob Gresh or Brenda Herod. These are names I've seen in the recent barrage of emails, but I have not met either of them and don't know their exact involvement in all of this. I have also asked Geoff to confirm that, assuming this process was elevated to the highest priority, we could be getting the data around 7:30 a.m.

The database you mentioned is definitely not "ready to go." The meter data we're getting from the MV-90 system is just that: a list of meter numbers and readings.  I am assuming (perhaps incorrectly) that just having a database of meters without their associated sites, account, clients, etc. isn't going to be useful to anyone. I am working on putting something very basic together to show Michael Frazier sometime early next week. I will also get back to you on the file-processing time once I've run a few tests.

Let's get together and iron out some of the specifics of what *you* need from this data. I'm free all day tomorrow.

--John





From:	Chris Stokley/ENRON@enronXgate <mailto:Stokley/ENRON@enronXgate> on 08/15/2001 06:47 PM
To:	John Rutledge/HOU/EES@EES <mailto:Rutledge/HOU/EES@EES>
cc:	 
Subject:	FW: CES2423 Project Proposal

John,
	I have not heard back from you on the items listed below, where do you stand on these questions


							Chris

 -----Original Message-----
From: 	Stokley, Chris  
Sent:	Tuesday, August 14, 2001 6:27 AM
To:	Rutledge, John
Subject:	RE: CES2423 Project Proposal

John,

	Could you tell me who I would speak to in order to find out the priorities that are pushing this process back to 11:00am? Also, how much time does it take you to get this file into the database once you receive the file from CSC? This is making the assumption that the database is configured and ready to go. What are you currently seeing in the way of missing data coming in from these files on a daily basis.


								Chris
								503-807-8959

 -----Original Message-----
From: 	Rutledge, John  
Sent:	Wednesday, August 08, 2001 11:18 AM
To:	Winter, Maurice; Stokley, Chris; Frazier, Michael
Cc:	Alvarez, Charles
Subject:	CES2423 Project Proposal

Have attached the project proposal as returned by CSC. I am also summarizing a discussion I had with Geoff Goodfellow of CSC:

Since CSC is using a third-party, packaged application to produce this file, they are limited in their ability to deliver exactly what we want (in the context of the 51 hour, $4,883.62 estimate).

We requested that missing data (e.g., phone line down) be backfilled in a later day's file, but this is not possible because the process to produce this file only queries on meter data for a specific date, not all data received on a specific date. For example, if they ran it today, for 7 August, we would receive all meter data for that date, but they would have actually received more than that on the 7th, perhaps data dated 6 Aug for meters that failed to dial in on that day. Getting this data will require further development (read: mo' money).

Also, the file is 26MB, of which more that 25% is blank spaces on the end of each line. Again, since this is an external application, I have been told that it is not possible to eliminate this extra space. (Not a killer, since we won't actually be putting it in the database, but it just adds to processing/network overhead.)

I have also been told that file delivery will occur between 11 a.m. and 12 p.m. daily. This is because of current priorities, but even at the earliest, we won't be able to get it before 7:30 a.m. (Data is collected from 12 a.m. to 6 a.m., the report run takes 1 hour 30 minutes, a file is produced at 7:30.)

--John





---------------------- Forwarded by John Rutledge/HOU/EES on 08/08/2001 10:57 AM ---------------------------


jthoma56@csc.com <mailto:jthoma56@csc.com> on 08/07/2001 04:11:43 PM
To:	rgresch@enron.com <mailto:rgresch@enron.com>
cc:	jjackson@enron.com <mailto:jjackson@enron.com>, john.rutledge@enron.com <mailto:john.rutledge@enron.com>, kenny.ha@enron.com <mailto:kenny.ha@enron.com> 
Subject:	CES2423 Project Proposal


Bob -
Attached is the Project Proposal and Purchase Order document for the MV-90
Data Download (CES2423) Work Request.  Please review the documents at your
earliest convenience.  If the offer is acceptable to EESO, please forward
your acceptance to my attention via electronic mail attached to this
submission.
If you have any questions or require additional information, please contact
me at 614-737-1345.

Best Regards -
Jim
(See attached file: CES2423.MV90 Project Proposa 080701.doc)
 - CES2423.MV90 Project Proposa 080701.doc << File: CES2423.MV90 Project Proposa 080701.doc >>