Kaup, Chester
Chester_Kaup at kindermorgan.com
Thu Mar 2 11:11:08 CST 2006
All of the wells may have a different number of data points. For example if well 1 has been on for 1 year it will have 12 data points. If well 2 has been on for 6 months it will have 6 data points. However many wells have data at a certain number of data points from the first data point get added together. Thus if 6 wells has data at the first point they are summed. If there are three wells that have data at the second point those three are added together. If only 2 wells have data at the last point only there data is summed. Thanks. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin - Beach Access Software Sent: Thursday, March 02, 2006 11:03 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Normalize Data by date Do each of the wells have the same number of dates? If not, what do you do when you get to the third date for well 1 and well2 doesn't have a third date? Rocky Kaup, Chester wrote: > Example data > Well_Number Production_Date Water_Volume > CO2_Volume > 1 1/1/2005 10 > 10 > 1 2/1/2005 20 > 15 > 1 3/1/2005 25 > 20 > 2 4/1/2005 50 > 35 > 2 5/1/2005 75 > 100 > 2 6/1/2005 44 > 87 > 3 10/1/2005 100 > 20 > 3 11/1/2005 200 > 40 > 4 2/1/2006 123 > 57 > 4 3/1/2006 44 > 23 > > To normalize the data what I need to do is sum the Water_Volumes and > CO2_Volumes for the first date for each well, second date etc. Thus for > dimensionless date 1 well 1 on 1/1/2005 is added to well 2 on 4/1/2005 > is added to well 3 on 10/1/2005 and is added to well 4 on 2/1/2006. For > Water_Volume on first date 10+50+100+123. For CO2_Volume on first date > 10+35+20+57. The again for the second date for sum wells etc. Hope this > makes sense. Thanks. > > -----Original Message----- > From: accessd-bounces at databaseadvisors.com > [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin > - Beach Access Software > Sent: Thursday, March 02, 2006 10:17 AM > To: Access Developers discussion and problem solving > Subject: Re: [AccessD] Normalize Data by date > > Chester: > > Sorry for the late reply. What exactly do you mean by "normalize back > to the first volume date"? Can you give an example? > > Regards, > > Rocky Smolin > Beach Access Software > 858-259-4334 > www.e-z-mrp.com > > > Kaup, Chester wrote: > >> I have a table with 4 columns of data. The fields are Well_Number, >> Production_Date, Water_Volume and CO2_Volume. I need to normalize >> > these > >> back to the first volume date separately for Water_Volume and >> CO2_Volume. ie sum the first volumes data together regardless of date >> and through the rest of the records. Hope I am making sense. I am at a >> loss of where to start. Thanks. >> >> >> >> Chester Kaup >> >> Engineering Technician >> >> Kinder Morgan CO2 Company, LLP >> >> Office (432) 688-3797 >> >> FAX (432) 688-3799 >> >> >> >> >> >> No trees were killed in the sending of this message. However a large >> number of electrons were terribly inconvenienced. >> >> >> >> >> > > -- Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com