Parse Data in single Table into several smaller Tables
Budget: $10 – $30 USD
I am looking for a freelancer to help me with parsing data in a single table and creating several smaller tables from it. The input table has 6 columns, but only data from 3 columns will be used. The data consists of a mix of numerical and textual information. I would like to create 5-7 smaller tables from the input table.
Data is on Sheet 1 and the output will be on second sheet called "Report Sheet."
The data to be parsed out of Sheet 1 are:
The Date, Max Speed and Number of Vehicles
The DDMMYYYY format used is textural. It needs to be changed into a proper MMDDYYYY Format in the Report Sheet.
When parsing the Date and Time ignore the Time. We don't need the Time to be reported in the Report Sheet. As an example if Sheet 1 has the following information it will aggregated and shown like this.
SHEET 1 - Data to be parsed
Date. Number of Vehicles. Max Speed
15/08/2023 19:00 3 30
15/08/2023 19:30 6 30
15/08/2023 21:00 2 30
18/08/2023 21:00 7 30
18/08/2023 22:00 19 30
REPORT SHEET - Parsed Data
Date Number of Vehicles. Max Speed
08/15/2023 11 30
08/18/2023 26 30
There are 5 different speed ranges to be parsed into 5-separate tabes which needs to be based on the min/max cells in the Report Sheet.
Thanks,
Mark
Ideal Skills and Experience:
- Strong experience in data parsing and manipulation
- Proficiency in working with mixed numerical and textual data
- Knowledge of database management and table creation
- Attention to detail to ensure accurate data extraction and table creation
Data is on Sheet 1 and the output will be on second sheet called "Report Sheet."
The data to be parsed out of Sheet 1 are:
The Date, Max Speed and Number of Vehicles
The DDMMYYYY format used is textural. It needs to be changed into a proper MMDDYYYY Format in the Report Sheet.
When parsing the Date and Time ignore the Time. We don't need the Time to be reported in the Report Sheet. As an example if Sheet 1 has the following information it will aggregated and shown like this.
SHEET 1 - Data to be parsed
Date. Number of Vehicles. Max Speed
15/08/2023 19:00 3 30
15/08/2023 19:30 6 30
15/08/2023 21:00 2 30
18/08/2023 21:00 7 30
18/08/2023 22:00 19 30
REPORT SHEET - Parsed Data
Date Number of Vehicles. Max Speed
08/15/2023 11 30
08/18/2023 26 30
There are 5 different speed ranges to be parsed into 5-separate tabes which needs to be based on the min/max cells in the Report Sheet.
Thanks,
Mark
Ideal Skills and Experience:
- Strong experience in data parsing and manipulation
- Proficiency in working with mixed numerical and textual data
- Knowledge of database management and table creation
- Attention to detail to ensure accurate data extraction and table creation