I require a review of car parking data for a one month period.
The data currently shows the entry and exit times for all vehicles. I require the data to be analysed to provide:
1. Entry volumes by 1 hour time intervals for each day
2. Exit volumes by 1 hour time intervals for each day
3. Car park occupancy by 1 hour time intervals for each day
The data for 1 and 2 can be shown as bar graph (or similar) with 3 being displayed via a bell curve (or similar) graph format.
The data is currently provided in pdf format and will be required to be converted to excel and aggregated to a master sheet with each day provided as a new tab plus a summary page showing results for points above.
The project will require a sample day period to be completed first (to ensure correct methodology) and then undertake for all days provided.
A sample of a single day data is attached