All the data for all time periods is located in the same column, not row.
The data I need to work with is in the ID, Date & Time and Var2 columns.
The data reports in 14 different ID#'s every 5 minutes.
I need to be able to sudtract the value on Var2 & ID#1 & time 0:00:55 by the value on Var2 ID#1 & time 0:00:00 to get the 12:00am total. Then I need to multiply each of the Var2 values by a number to get a total. Once I have all the ID#'s totals for each time range I need to then add them all together to get a complete total of all ID's for that time(At 12:00am - add ID #1.1, 1.2, 1.3,1.4....etc)
I have to do that same calculation for every hour or everyday for every ID#. That is just 1 report, I have over 100 that have to be done daily.
Example -
ID # Date & Time Var1 Var2 Var3 Var4
| 1.1 |
4/19/2007 0:00 |
2122250 |
16978 |
80414 |
1559457 |
| 1.2 |
4/19/2007 0:00 |
3566875 |
28535 |
75349 |
2788825 |
| 1.3 |
4/19/2007 0:00 |
3937000 |
31496 |
60839 |
3024292 |
| 1.4 |
4/19/2007 0:00 |
3016375 |
24131 |
31982 |
1917679 |
| 1.5 |
4/19/2007 0:00 |
6871125 |
30799 |
65872 |
2055366 |
| 1.6 |
4/19/2007 0:00 |
7034125 |
56273 |
56273 |
1218811 |
I hope this clears it up a bit.
Thanks,
Troy S.
IP Logged
