I have 1 year of Oracle table data ready to go into Excel. In Execl I'd like to count orders by 15 minute periods (buckets, on the quarter hour). Some 15 minute periods have many orders while some have 0. Is there an Excel function (or a series of a few steps) that will look at column A & B and populate subsequent columns in this way (i.e., columns E & F below)?
Original Data Columns
A (raw data timestamp) B (orders)
************************* ************
1/1/2010 1:05 AM, 1
1/1/2010 1:11 AM, 1
1/1/2010 1:20 AM, 1
1/1/2010 1:32 AM, 0
1/1/2010 1:48 AM, 1
for a whole year
...
Interim Columns (I supose would be necessary)
C (beginning minute
timestamp of buckets) D (orders)
************************* ************
1/1/2010 1:00 AM, 1
1/1/2010 1:00 AM, 1
1/1/2010 1:15 AM, 1
1/1/2010 1:30 AM, 0
1/1/2010 1:45 AM, 1
E (the ultimate goal column) F (orders aggregated into proper th bucket)
********************************* *************************************************
1/1/2010 1:00 AM 2
1/1/2010 1:15 AM 1
1/1/2010 1:30 AM 0
1/1/2010 1:45 AM 1
The purpose is to graph E & F for certain high volume order days of the year.
Thanks in advance!
Bookmarks