Custom dynamic spreadsheet with dependencies

$30-250 USD

Closed

Posted

almost 8 years ago

$30-250 USD

Paid on delivery

Create a sophisticated Gantt chart/timeline/calendar that autofills tasks backwards based on an end date? It’s for musical auditions, and I want the user to be able to put in their audition date, and their calendar will back fill will all the tasks that need to be done at certain points leading up to that date. Would possibly like to integrate this with a Google sheet, as a dynamic pdf, or as a dynamic online form.

Excel

Programming

Project ID: 10604886

About the project

9 proposals

Remote project

Active 8 yrs ago

Looking to make some money?

Email address

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

9 freelancers are bidding on average $153 USD for this job

@P0L

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.

$100 USD in 3 days

5.0

(499 reviews)

8.0

@elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards

$150 USD in 3 days

5.0

(328 reviews)

7.5

@mbertani

Hi, I would love to help you build your charts/dynamic calendar. I am a reporting analyst by trade and have over 8 years' experience building automated tools in Excel (very similar to what you are describing here) using advanced formulas and macros/VBA. I am US-based and bring a strong educational and professional background. I encourage you to check out my profile. I look forward to discussing this project with you further. Best regards, Marcelo

$125 USD in 3 days

5.0

(9 reviews)

4.5

@rpjuntereal

Your project looks very interesting. I've been recently dabbling with Google Scripts to do some cool stuff for my own needs. With all these in mind, I can help you achieve what you need. Using Google Scripts it would be possible for me to create a spreadsheet with a Gantt Chart given a set of parameters. Based on what I understand from your requirements, these parameters would be: 1. Task List (this would include all the details of each task, eg. Length, Description, etc.) 2. Audition date Also with Google Scripts, it would be possible to generate a PDF file that can be emailed to whoever is auditioning.

$150 USD in 5 days

5.0

(1 review)

0.2

@SharePointExper

Hey, I have 9 years of experience with project management. Let's chat so that I can help you create this spreadsheet today itself! Regards, Frank.

$150 USD in 1 day

0.0

(0 reviews)

0.0

@Denisakov

Hello there! Google Apps would be a perfect solution for you. As I see it, it would link on a website to the Google form, where user puts in a date and the e-mail and gets a printable pdf file after submission of the form. The data can be stored in the Spreadsheet and we can use a gantt chart to plot the data. Or perhaps we could just have a calendar like table with tasks written into the cells, which could be printed by weeks or maybe months. This all can be done from within the google apps. Let me know if you wish my help. Cheers, Denis

$222 USD in 7 days