Appointment Scheduler - in Google Sheet - 19/02/2021 02:55 EST

Status: Closed
Prize: $20
Entries Received: 4
Winner: hozefazs

Winner

Contest Brief

Hello Friends,

I Manage to Get My solution in Google Sheet (Refer Attached Video), But Now I need some support to Create Same in Excel Sheet using VBA, Function, Micro + Any other Way.

I worked with people who live in a facility and I need a way to schedule their appointments. Right now I have 20 clients, but next month I will be given another 20, and then again the following month. I will categorize each client into sub-categories, low risk, moderate risk, and high risk. These sub-categories will determine who frequently I will be meeting with them. So, for example, although right now I have 20, by April I will have 60. I see clients five days a week (Mon to FRI ONLY), for 30 min intervals, between 12-2. So I would need a system to be developed that can take all of these variables, into consideration.

Schedule Times

12:00 PM -12:30 PM
12:30 PM -01:00 PM
01:00 PM -01:30 PM
01:30 PM -02:00 PM

Appointment frequency

HIGH RISK 1 WEEKLY HR01
MODERATE RISK 1 BI-WEEKLY MR01
LOW RISK 1 MONTHLY LR01
HIGH RISK 2 BI-WEEKLY HR02
MODERATE RISK 2 MONTHLY MR02
LOW RISK 2 MONTHLY LR02

If you have Any Suggestion rather than Google Sheet Let Me Know.

Best Regard
Indika Wickramasinghe

Recommended Skills

Winner

Get Entries Like This

Employer Feedback

“Expert for Both Google Sheet and Excel, Excellent Executor. ”

INDIKAWIC, Sri Lanka.

Top entries from this contest

agustinavilac Colombia

0
muzammilahmad27 Pakistan

0
goutamdam Bangladesh

0

Public Clarification Board

agustinavilac
- 1 week ago
I have made some modifications to the presented application which I explain in the following video:
https://youtu.be/3HYYp-QvDiw
- 1 week ago
hozefazs
- 1 week ago
I have pleaced the demo of the Automatic Scheduler made for you in my portfolio, as a video. Please go through the video. This is the only solution scalable to larger quantity of patients, and multiple categories, and the scheduling is done entirely automatically upto a year. Further logic changes and customization, please message me
- 1 week ago
1. Contest Holder
  - 1 week ago
  That is Great, But I got The Solution Through Google Sheet, But What About the Possibility to Create Same in Excel. using VBA. Also Please Apply for this Contest by Putting Only Snap. then we can discuss Further.
  - 1 week ago
Contest Holder
- 1 week ago
HI All,
If Any one Interest on Excel Solution with VBA I can Accept.

SO If you able to do Please Try tp give entry, Then I will Brief Through Chat.

Best Regard
Indika
- 1 week ago
1. hozefazs
  - 1 week ago
  dear Indika,
  my entry number 44 already does automatic scheduling using Google script. I will make a video and post it on my profile within 30 mins so you can see how it works.
  it will schedule for the entire year
  Hozefa
  - 1 week ago
juancarlosr23
- 1 week ago
Is it a file only you can enter information?
Once a client is scheduled in a day and hour for the first time, it should be scheduled at the same day and time every period required? or could it be variable according to avaliability?
- 1 week ago
rashida016245
- 1 week ago
Sir, You can finish your Google Sheet work by me. Because I have a lot of experience in Google Sheet.
#sealed
- 1 week ago
raziali
- 1 week ago
Please check my entry No. 45
- 1 week ago
Ma7aMaD3Li
- 1 week ago
could you check entry #35 and give me feedback, please.
- 1 week ago
Shakil3300
- 2 weeks ago
you can check entry number 26 . If you have to any change please contact with me.
- 2 weeks ago
uali0012
- 2 weeks ago
Please contact me.
- 2 weeks ago
1. jiichauhan716
  - 2 weeks ago
  hello sir
  - 2 weeks ago
Contest Holder
- 2 weeks ago
Please make sure to set Appointment Schedule for Next Few Months and Then you need to Provide Summary as well
- 2 weeks ago