If they can split by business unit they must have by company.  The FERC nor the partnerships will accept these charges unless we have the data to send the costs to them.  I really need something like yesterday.  I thought we had this resolved a long time ago.



 -----Original Message-----
From: 	Lewis, Greg  
Sent:	Monday, October 08, 2001 9:11 AM
To:	Botello, Mary
Cc:	Geaccone, Tracy
Subject:	RE: Password needed FW: ETS Statistics

The ISC does not have this information below the business unit level.  HR may be able to match the p-numbers up to company in a semi-automated fashion.  Or, you could use the number of documents and master data as the bases and exclude the user counts in the weighting. 

 -----Original Message-----
From: 	Botello, Mary  
Sent:	Monday, October 08, 2001 9:04 AM
To:	Lewis, Greg
Cc:	Geaccone, Tracy
Subject:	FW: Password needed FW: ETS Statistics
Importance:	High

	How much trouble would it be to have the list of users/licenses split by ETS company?

 -----Original Message-----
From: 	Geaccone, Tracy  
Sent:	Saturday, October 06, 2001 3:17 PM
To:	Botello, Mary
Subject:	FW: Password needed FW: ETS Statistics
Importance:	High

We should be able to use this to allocate SAP costs to companies.

 -----Original Message-----
From: 	Lewis, Greg  
Sent:	Friday, October 05, 2001 1:54 PM
To:	Geaccone, Tracy; Sullivan, Michael
Subject:	Password needed FW: ETS Statistics
Importance:	High

fyi the first workbook below (isc allocation metrics) has a password on it........  owl

 -----Original Message-----
From: 	Lewis, Greg  
Sent:	Friday, October 05, 2001 9:26 AM
To:	Geaccone, Tracy
Cc:	Schlaudraff, Christine; Sullivan, Michael
Subject:	ETS Statistics

Tracy,

These are the statistics provided by Chris Schlaudraff.

 << File: ISC Allocation Metrics.xls >> This is a recap at the business unit level.  The business unit allocation is weighted as follows:
			29.27% based on how many licenses we have.
			53.41% based on how many documents we have on the system.
			17.32% based on the amount of CO data (or master data) we have on the system.

 << File: Stats by company for ETS.xls >> This is the detail of the documents (# of FI docs & # of PO docs columns) and the CO data (all other columns) ETS has on the system.....by company.

 << File: ISC ets licenses.xls >>   This is a list of the ETS users/licenses.  It is not by company.  

Let me know if you have any questions,
Greg