Find Jobs
Hire Freelancers

Created a google sheets document

$250-750 USD

Closed
Posted over 7 years ago

$250-750 USD

Paid on delivery
I am looking for a bid on how much it would cost to get a document created for me. The document would be a year calendar with 4 names that would somehow generate into another sheet every two weeks to easily make a schedule. I am looking to for a couple formulas to calculate that every other Saturday a specific person works and then the weekends that person doesn't work, one of the other 3 people fill in. I would like it to be a master schedule with a link that creates on another sheet that we could "generate" a bi-weekly schedule so that only two weeks could be printed at a time so that we could allow for requested days off. The two-week schedule I've been able to figure out, but making a master sheet that would then generate into a separate sheet that would be easily done by a computer illiterate person (me) is where the difficulty is coming in. Does this make sense? Below is how I imagined the generated copy would look, but the master and getting it to feed into another sheet to generate is where I am having a hard time. Please let me know if you have questions or if this is even possible. Thank you for your time. Monday Tuesday Wednesday Thursday Friday Saturday Terry 8:30 - 4:30 8:30 - 4:30 8:30 - 1:00 8:30 - 4:30 8:30 - 4:30 9-4 Sam M. 10:30 - 6:30 10:00 - 5:00 10:30 - 6:30 Off 11:00 - 6:30 Off Corrie Off 11:00 - 6:30 Off 11:00 - 6:30 11:00 - 6:30 Off Sam P. 10:00 - 6:00 10:30 - 6:30 10:00 - 6:00 10:30 - 6:30 10:00 - 5:00 Off Monday Tuesday Wednesday Thursday Friday Saturday 11/7 11/8 11/9 11/10 11/11 11/12 Terry 8:30 - 4:30 8:30 - 4:30 8:30 - 1:00 8:30 - 4:30 8:30 - 4:30 9-4 Sam M. 10:30 - 6:30 10:00 - 5:00 10:30 - 6:30 Off 11:00 - 6:30 Off Corrie Off 11:00 - 6:30 Off 11:00 - 6:30 11:00 - 6:30 Off Sam P. 10:00 - 6:00 10:30 - 6:30 10:00 - 6:00 10:30 - 6:30 10:00 - 5:00 Off
Project ID: 11838233

About the project

16 proposals
Remote project
Active 7 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
16 freelancers are bidding on average $374 USD for this job
User Avatar
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.
$350 USD in 3 days
4.9 (300 reviews)
7.2
7.2
User Avatar
Hello. 30 % of employers hiring me once hired me again. I have experience in the same. I CAN do this job, and do it well!
$250 USD in 10 days
5.0 (120 reviews)
6.5
6.5
User Avatar
Hi, I read your project and i am ready with my team to start now. please give me a chance to show our talent. we are working last 4 years under a owner now we just want to grow up ourselves. I think you will Give me a Chance to show my skill. Money is not fact we can discuss about payment upon discussion. Waiting For you respond. I have sample to show you. Thanks
$333 USD in 10 days
5.0 (40 reviews)
6.2
6.2
User Avatar
I want to discuss this project with you further, let me know the best suitable time for you to schedule the meeting, Feel free to message me at any time, i used to be online 14 hrs in a day on this website so probably you will get a quick response from my end
$773 USD in 18 days
5.0 (3 reviews)
5.5
5.5
User Avatar
Hi there - My name is Jhalak. I’ve read your brief and can see that you’d like to build an Website. My team has years experience designing and developing mobile apps and Websites as well as SEO.I would approach your project by starting with wireframes and getting the site completed, before starting the actual development phase. I am highly qualified for this project and would love to speak with you further about taking this project on. If you'd like to view my previous work, take a look at my Freelancer Portfolio. Regards, Jhalak Thanks, Diamond looking forward for your reply.
$277 USD in 10 days
4.9 (65 reviews)
5.5
5.5
User Avatar
I recently worked on a work schedule calendar project. Every situation is different, but take a look at my portfolio and see what I can do. Here is how I would approach the project based on your description. Generate an Excel tab with every week of the year (Master Schedule). I would add a button that would populate another tab which could then be printed out. Does it matter what hours the 4 employees work? Do they need to overlap? I want to make sure this project works for you, so I upload various versions of the Excel files as I am going along. This way you can provide feedback immediately and neither of us wastes time. I look forward to working with you.
$350 USD in 5 days
5.0 (3 reviews)
4.4
4.4
User Avatar
Hello Sir, I am an expert Google Sheet developer and can certainly help you here. I can also have the functionality to send emails with schedule in case you are interested. Thx Aanvik
$250 USD in 3 days
4.9 (6 reviews)
3.6
3.6
User Avatar
A proposal has not yet been provided
$277 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
This is Aporna Biswas who has more skills in data entry, social media, web scraping and search engine optimization. I have done many projects basis on my skills. I work in my local area and other marketplaces. Thanks
$250 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$333 USD in 10 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I know your heart is set on Google Sheets, but consider this. My browser-based cloud database application service INCLUDES ALL SERVICES in a single plan: DESIGN, DEVELOPMENT, HOSTING, TRAINING, and SUPPORT --one low monthly fee to fully support your application needs. Your "documents" can be implemented as Reports from a Database. By developing your application with database software, it simplifies the tasks you are trying to accomplish since data elements are separated from the logic. I will do all the developing for you and guide you toward a workflow solution that will satisfy you. I can set up your CUSTOM Work Scheduler database application on a production Transaction Editor (TEd) cloud server within a week for just $250. * Spreadsheet ease-of-use * Forms processing * Customer/Vendor/Employee Portals * Custom reporting * Accountability of a database * Save SEARCHES and SORT on multiple columns * Recover from mistakes with CHANGE HISTORY LOG * Column and Row-defined MULTI-USER ACCESS * EMAIL PDF proposals/orders/bills/invoices/requisitions/reports * IMPORT/EXPORT multiple file formats * SCHEDULED and EVENT-based updates * Automated NOTIFICATIONS * Flexible WORKFLOW Management * Highly RELIABLE and SECURE * and so much more... Search for "Konduit Transaction Editor". Contact me for a demonstration.
$277 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I've done a similar thing using Google Sheets and Apps Scripts before. Ill refund the money if its not done in 48h.
$250 USD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
I am a research student living in London. I am in need due to unlawful cancellation of my scholarship. Therefore, I need to earn money to afford my living cost and tuition fee. I would like to help you on your project. Thank you.
$400 USD in 5 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED STATES
United States
0.0
0
Member since Oct 19, 2016

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) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
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.