Find Jobs
Hire Freelancers

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.
Project ID: 6201310

About the project

5 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hey mate Fellow aussie here :)! I recorded a voice message of my proposal: [login to view URL] Let me know if it works :)! Alex
$88 AUD in 5 days
5.0 (2 reviews)
2.3
2.3
5 freelancers are bidding on average $105 AUD for this job
User Avatar
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.
$100 AUD in 0 day
4.9 (209 reviews)
6.9
6.9
User Avatar
A proposal has not yet been provided
$210 AUD in 1 day
5.0 (111 reviews)
6.5
6.5
User Avatar
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 !
$66 AUD in 3 days
4.8 (63 reviews)
4.9
4.9
User Avatar
A proposal has not yet been provided
$61 AUD in 1 day
4.4 (16 reviews)
4.0
4.0

About the client

Flag of AUSTRALIA
Sydney, Australia
5.0
6
Payment method verified
Member since Oct 13, 2012

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.