Google Sheet Machine Scheduling Enhancement
Budget: €8 – €30 EUR
Job Description:
We are seeking a highly skilled freelancer to enhance our machine work schedule in Google Sheet. The current schedule requires optimization to improve efficiency. The freelancer will be responsible for executing the requested modifications. The successful candidate must possess a comprehensive understanding of Google Sheets and demonstrate proficiency in implementing formulas, conditional formatting, and data validation to automate and optimize the schedule. Meticulous attention to detail and the ability to work independently are essential attributes for this role.
Required Skills:
- Proficiency in Google Sheets
- Expertise in organizing spreadsheets
- Proficient in data analysis
- Strong knowledge of formulas and functions
- Competence in conditional formatting
This project is expected to last for a duration of 2 weeks. We are seeking an entry level freelancer with prior experience in optimizing schedules using Google Sheets.
Key Responsibilities:
1. Implement a new column that automatically calculates and sums the "hours" required from various departments for each line, and converts it into a date considering the work schedule duration.
2. Establish a "priority" column for all departments and subsequently reorganize the departments based on their respective priorities. This will involve manual input in the main sheet while ensuring automatic sorting of corresponding works in the department sheets. Additionally, make this new column visible in the department sheets.
3. Accommodate changes while maintaining interconnectedness of the sheets through formulas, ensuring that inserted data remains intact even after adding new columns. Adjust formulas as necessary to preserve the integrity of relevant data.
4. Remove the existing "priority" column after successful implementation of the new one.
5. Protect the interconnected formulas from potential editing by implementing a popup error message or password.
6. Safeguard all sheets from editing and grant permission only to specific workers to modify their respective department columns.
7. Add an option to notify the completion of a job, automatically updating the calculated hours mentioned in point 1 if it ended before or after the expected time.
8. Integrate the "work sheet" column from the "WORK SCHEDULE" sheet into the formulas of the three "department 1" sheets.
9. Automatically apply the correct format to newly added lines by users.
10. When an additional job is added to the sheet, the point 7 have to recalculate and provide a new date. Ensure that other work dates affected by the insertion of this new job are also recalculated.
11. Notify the user before applying changes if a job has been moved multiple times or exceeds the delivery date. Additionally, create a column that automatically highlights the difference between the initial date and the last modification.
To review the Google Sheet, please use the following link:
https://docs.google.com/spreadsheets/d/1N6q4iiKd1CpUqPQD5qqQTG-nZoOTqdrftiATKT-XjDI/edit?usp=sharing
We are seeking a highly skilled freelancer to enhance our machine work schedule in Google Sheet. The current schedule requires optimization to improve efficiency. The freelancer will be responsible for executing the requested modifications. The successful candidate must possess a comprehensive understanding of Google Sheets and demonstrate proficiency in implementing formulas, conditional formatting, and data validation to automate and optimize the schedule. Meticulous attention to detail and the ability to work independently are essential attributes for this role.
Required Skills:
- Proficiency in Google Sheets
- Expertise in organizing spreadsheets
- Proficient in data analysis
- Strong knowledge of formulas and functions
- Competence in conditional formatting
This project is expected to last for a duration of 2 weeks. We are seeking an entry level freelancer with prior experience in optimizing schedules using Google Sheets.
Key Responsibilities:
1. Implement a new column that automatically calculates and sums the "hours" required from various departments for each line, and converts it into a date considering the work schedule duration.
2. Establish a "priority" column for all departments and subsequently reorganize the departments based on their respective priorities. This will involve manual input in the main sheet while ensuring automatic sorting of corresponding works in the department sheets. Additionally, make this new column visible in the department sheets.
3. Accommodate changes while maintaining interconnectedness of the sheets through formulas, ensuring that inserted data remains intact even after adding new columns. Adjust formulas as necessary to preserve the integrity of relevant data.
4. Remove the existing "priority" column after successful implementation of the new one.
5. Protect the interconnected formulas from potential editing by implementing a popup error message or password.
6. Safeguard all sheets from editing and grant permission only to specific workers to modify their respective department columns.
7. Add an option to notify the completion of a job, automatically updating the calculated hours mentioned in point 1 if it ended before or after the expected time.
8. Integrate the "work sheet" column from the "WORK SCHEDULE" sheet into the formulas of the three "department 1" sheets.
9. Automatically apply the correct format to newly added lines by users.
10. When an additional job is added to the sheet, the point 7 have to recalculate and provide a new date. Ensure that other work dates affected by the insertion of this new job are also recalculated.
11. Notify the user before applying changes if a job has been moved multiple times or exceeds the delivery date. Additionally, create a column that automatically highlights the difference between the initial date and the last modification.
To review the Google Sheet, please use the following link:
https://docs.google.com/spreadsheets/d/1N6q4iiKd1CpUqPQD5qqQTG-nZoOTqdrftiATKT-XjDI/edit?usp=sharing