Automated calendar using Google Sheets (project timeline)

완료 등록 시간: 3년 전 착불
완료 착불

Hello,

I am looking for a Google Sheets (spreadsheet formulas) expert to create an auto-generated calendar based on a list of data inputs. The goal is to create a calendar project milestones timeline.

The sheet will use two tabs:

tab 1 - the auto-generated calendar

tab 2 - data that will provide the information needed to create the calendar

The data tab 2 would list the source data in the following format:

Milestone name Start Date Duration (in days) End Date Adjustments Days

The Milestone name will automatically populate in the day or days calendar cell(s) that are specified by the Start and End Days. Adjustment Days can be ignored by the GAF freelancer. That allows me to adjust the subsequent days.

The Data tab 2 is already coded the way I need it to work, so you may just use the data to collect data for the calendar coding.

The Calendar

I created a non-working mock-up of what I need in an automated calendar.

What I require for a completed project:

1) The calendar should be automatically generated based on the data available in tab 2

2) The format should look like the mock-up: Mon Tue Wed Thur Fri Sat Sun (Saturday and Sunday are minimized)

3) Each day of the month, should allow up to 2 different milestones (to allow overlap). Again, review the mock-up.

4) Each calendar date is uniquely color-coded to represent a unique milestone. Can this be accomplished using formulas? If not, I can use Conditional formatting.

5) The calendar should be able to handle up to 12 months of milestone events. Tab 2 currently has 22 milestone events for demonstration purposes.

6) The calendar must be entirely self-contained and cannot use any external plug-ins.

7) All calendar calculations must be done using formulas. This means no pivot tables, filters, etc.

Payment will be released upon satisfactory testing of automation and meeting the requirements of this project.

On acceptance of freelancer, I will supply a Google sheet with 3 tabs:

Tab 1 - Automatic Calendar - Blank calendar tab (where the work can be done)

Tab 2 - Data Input (sample data to feed the calendar)

Tab 3 - Mock-up calendar

Deadline of project: ~ 2 - 3 days?

Project time: 1 - 3 hours for a skilled Google Sheets author

Skills:

- Google Sheets formula expertise

- Excel formulas expertise (Important: The final project must be in Google Sheets)

Successful bidders:

- I will only chat with bidders who have demonstrated that they have read and understood my requirements.

엑셀 Google Sheets Google Cloud Platform

프로젝트 ID: #26878115

프로젝트 소개

18 건(제안서) 재택 근무형 프로젝트 서비스 이용 중: 3년 전

수상자:

BogdanM7

Greetings, This seems like a neat little project, I might even adapt it for myself later. Using Start Date, Duration and End Date is redundant, which 2 of them would you prefer using? If it *does* happen that a day c 기타

$50 USD (2일 이내)
(1 리뷰)
1.7

이 일자리에 대한 프리랜서 18 명의 평균 입찰가: $125

schoudhary1553

Hi, Greetings! ✅checked your project details: Automated calendar using Google Sheets (project timeline) ✅Completed Time: In project deadline We have worked on 600 + Projects. I have 6 + years of the experience i 기타

$220 USD (4일 이내)
(374 리뷰)
8.1
finecodervw

Hi, I have gone through project description and attachment and have few queries which I would like to discuss with you. Keen to work on this project. Recently completed Google Sheets/Google Maps based projects with 기타

$150 USD (4일 이내)
(65 리뷰)
5.9
dfexcel

Hi, Thank you for the meticulously detailed out job description and for the mock-up provided. I have the expertise in google sheets formulas necessary to deliver this Project. Please revert to discuss and finalize at t 기타

$250 USD (3일 이내)
(18 리뷰)
5.6
akritisood94

Hello I am a Google sheets, Google Data Studio, Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros.

$140 USD (1일 이내)
(82 리뷰)
5.8
ravinderkumar248

Hi there. I can create an auto-generated calendar based on a list of data inputs. I am an Excel expert and have been working on process automation projects since 10 years. Please consider me for this job, I am well v 기타

$95 USD (2일 이내)
(71 리뷰)
5.4
WycOj

Dear client, I can help you with your project of data entry in excel, VBA, excel macros, VB, ready to start right now, message me and let is discuss about the project and time. Ready to start right away

$89 USD (7일 이내)
(24 리뷰)
4.3
emilianoreyes70

Hi! I have it ready as a mock-up.. I am an engIneer and Excel/VBA/Macro expert and Google Scrpit , Google Sheets expert too. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, Visual Basic Ap 기타

$80 USD (3일 이내)
(17 리뷰)
4.4
Emmyope93

Hi, Good day. I understand you need a good automated calendar done in Google sheet. A work that provides accurate computations while being easy to understand. I will like to assist you on this project as I have a great 기타

$77 USD (3일 이내)
(4 리뷰)
3.2
badriqbal

Hello, I can help to complete your project. I have done similar projects in past and will deliver exactly what you need. Please visit my profile to see my work. Please invite me for a chat and let's discuss this furt 기타

$140 USD (7일 이내)
(4 리뷰)
2.5
akshaydhiman6304

I think I'm better for this job Relevant Skills and Experience I have experience of about 1yr

$30 USD (3일 이내)
(0 리뷰)
0.0
datascarb11

Data entry

$156 USD (3일 이내)
(0 리뷰)
0.0
Chinmayranjan

Will perform the work that you want. Make your spreadsheet awesome with my Technical skills that will help you with your business.

$56 USD (2일 이내)
(0 리뷰)
0.0
Mahmooduhassan

Hi, i am Mahmood full-time freelancer Digital Marketer, SEO expert, video editor and Excel expert. i would like to take over this project and also want to ask some question about your project Automated calendar using 기타

$250 USD (2일 이내)
(0 리뷰)
0.0
Eksha17

I am the best candidate that you are looking for. I have great efficiency of working. I guarantee you that your work will be completed will before the deadline. Work will be done as per your demands. Relevant Skills a 기타

$167 USD (3일 이내)
(0 리뷰)
0.0
sandeshlamba0001

I will complete this in 4 days And if yo want to complete in with in a day I will do it faster I am a biginer Help me

$40 USD (4일 이내)
(0 리뷰)
0.0
aazamalik368

Hi there, I have read requirements to format the file properly and in proper way so that it can be printed out and can do this work accurately and fast. I am expert in Data entry, Excel, Data Processing file conversion 기타

$100 USD (1일 이내)
(0 리뷰)
0.0
krishiuiet

Hie.. U can consider me for this project.. I have had done similar exercise in past

$156 USD (3일 이내)
(0 리뷰)
0.0