Hi,
Given Below is a sample time series (total cell value of date set is 1.68 Million Cells) :
A1 | A2 | ||||
Date | Time | Buy | Sell | Buy | Sell |
1/4/2012 | 00:00 - 00:15 | 5.5 | 10.7 | 11.1 | 11.5 |
1/4/2012 | 00:15 - 00:30 | 5.5 | 10.7 | 11.1 | 11.5 |
1/4/2012 | 00:30 - 00:45 | 5.5 | 10.7 | 11.1 | 11.5 |
1/4/2012 | 00:45 - 01:00 | 5.5 | 10.7 | 11.1 | 11.5 |
1/4/2012 | 01:00 - 01:15 | 5.5 | 7.7 | 11.1 | 11.5 |
1/4/2012 | 01:15 - 01:30 | 5.5 | 7.7 | 11.1 | 11.5 |
1/4/2012 | 01:30 - 01:45 | 5.5 | 7.7 | 11.1 | 11.5 |
1/4/2012 | 01:45 - 02:00 | 5.5 | 7.7 | 11.1 | 11.5 |
1/4/2012 | 02:00 - 02:15 | 5.5 | 7.7 | 11.1 | 81.5 |
The entire time series is:
1. Daily Data from April 2012 Onwards
2. Each day has 96 rows one row for each 15 Minute time block (96 Rows mer month)
3. There are 8 regions and buy and sell volume is separately given for each region (16 Columns)
Problem 1: I have two row headers date and time. Now each date is repeated 96 times for each time block
Problem 2: I have to column headers "Region" and Buy & Sell
Help Needed: How do I import this data and look at in three different ways:
1. By time block (example aggregate demand and supply for all days for the time block 00:00 - 00:15)
2. My Month (example aggregate buy and sell volumes for all April (2012+2013+2014+2015)
3. By Region (example aggregate buy and sell volumes for region A1)
Sample sheet for one month is attached