Excel Data Splitting Script
Budget: $2 – $8 USD
We're on the lookout for a capable developer to assist us in automating a time-consuming manual task involving Excel data processing. Our billing department manages a master sheet containing ride information for multiple individuals within a specific time frame. The current process necessitates manual copying of this data into separate Excel files for each person, which is not only time-intensive but also error-prone.
Problem Statement:
Our challenge centers around the automation of splitting a master Excel sheet containing daily ride data into individual Excel files for each person. Our ultimate aim is to eliminate the need for manual copying and pasting, reduce the likelihood of errors, and enhance overall operational efficiency.
Project Scope:
The script we require should be able to accomplish the following:
Load the master Excel sheet.
Identify distinct individuals based on a specified identifier (such as a column containing names or IDs).
Extract ride data for each individual and store it in a new Excel file named after the individual (e.g., "JohnDoe_rides.xlsx").
Preserve the formatting and structure of the original data in the extracted Excel files.
Offer clear, user-friendly instructions or prompts for running the script.
Support easy upload of new data every day.
Requirements:
Proficiency in a suitable programming language (e.g., Python) and relevant libraries (e.g., pandas, openpyxl) for efficient Excel data manipulation.
Capability to create an intuitive script that requires minimal user input.
Familiarity with data cleaning and handling potential data-related issues.
Prior experience in automating Excel tasks will be advantageous.
Deliverables:
At the conclusion of the project, we anticipate receiving the script and comprehensive guidelines for its successful execution. The script should be comprehensively documented and easy to comprehend.
Submission:
Interested applicants are encouraged to provide a concise overview of their proposed solution, alongside relevant experience and examples of similar projects they have completed.
Note:
Prior to expressing interest in this project, we suggest gaining a thorough understanding of the task. Feel free to request a sample of the master Excel sheet to acquaint yourself with the data structure.
We greatly appreciate your enthusiasm and look forward to collaborating with a skilled developer to optimize our Excel data processing!
Problem Statement:
Our challenge centers around the automation of splitting a master Excel sheet containing daily ride data into individual Excel files for each person. Our ultimate aim is to eliminate the need for manual copying and pasting, reduce the likelihood of errors, and enhance overall operational efficiency.
Project Scope:
The script we require should be able to accomplish the following:
Load the master Excel sheet.
Identify distinct individuals based on a specified identifier (such as a column containing names or IDs).
Extract ride data for each individual and store it in a new Excel file named after the individual (e.g., "JohnDoe_rides.xlsx").
Preserve the formatting and structure of the original data in the extracted Excel files.
Offer clear, user-friendly instructions or prompts for running the script.
Support easy upload of new data every day.
Requirements:
Proficiency in a suitable programming language (e.g., Python) and relevant libraries (e.g., pandas, openpyxl) for efficient Excel data manipulation.
Capability to create an intuitive script that requires minimal user input.
Familiarity with data cleaning and handling potential data-related issues.
Prior experience in automating Excel tasks will be advantageous.
Deliverables:
At the conclusion of the project, we anticipate receiving the script and comprehensive guidelines for its successful execution. The script should be comprehensively documented and easy to comprehend.
Submission:
Interested applicants are encouraged to provide a concise overview of their proposed solution, alongside relevant experience and examples of similar projects they have completed.
Note:
Prior to expressing interest in this project, we suggest gaining a thorough understanding of the task. Feel free to request a sample of the master Excel sheet to acquaint yourself with the data structure.
We greatly appreciate your enthusiasm and look forward to collaborating with a skilled developer to optimize our Excel data processing!