Create a spreadsheet with automated functions & conditional formatting
$10-100 AUD
Completed
Posted over 9 years ago
$10-100 AUD
Paid on delivery
Create an automated spreadsheet.
Preferably in Numbers.
See mock ups as attached.
13 week Schedule planner in 3 parts
1. Summary page -
highlighting number of rostered per area and total
function to click on date to link to daily sheet
function to click on week to view weekly planner.
2. Weekly planner.
13 weeks
function to check box if person is on or off.
Names automatically link to daily when ticked on
when time is entered it automatically fills the daily planner
un-ticked days are locked from being edited.
3. Daily Planner
automatic times import to lock non work time - keeping work time to be able to be edited.
automatic names imported.
each week to have a separate sheet
each day to fit to an A4 page for printing.
Automation of functions is the most important part.
Formatting and design is important.
Please be honest in your ability to complete the requirements before even bidding.
Hello, I am top excel developer on this forum with 200+ five star reviews and with a completion rate of 90%. I have understood your requirement and I am sure I can implement this. Check my past reviews for your reference. Eagerly waiting for your reply so that i can start with the implementation.
Hi there, please share the sheet, we like to have a look at it, going through the requirements, looks like we may have to use Excel VBA. Please reply, we can discuss further, thanks !