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

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

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

Employer Feedback

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

Profile image INDIKAWIC, Sri Lanka.

Top entries from this contest

View More Entries

Public Clarification Board

  • agustinavilac
    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
    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. INDIKAWIC
      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
  • INDIKAWIC
    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
      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
    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
    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
    raziali
    • 1 week ago

    Please check my entry No. 45

    • 1 week ago
  • Ma7aMaD3Li
    Ma7aMaD3Li
    • 1 week ago

    could you check entry #35 and give me feedback, please.

    • 1 week ago
  • Shakil3300
    Shakil3300
    • 2 weeks ago

    you can check entry number 26 . If you have to any change please contact with me.

    • 2 weeks ago
  • uali0012
    uali0012
    • 2 weeks ago

    Please contact me.

    • 2 weeks ago
    1. jiichauhan716
      jiichauhan716
      • 2 weeks ago

      hello sir

      • 2 weeks ago
  • INDIKAWIC
    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

Show more comments

How to get started with contests

  • Post your contest

    Post Your Contest Quick and easy

  • Get tons of entries

    Get Tons of Entries From around the world

  • Award the best entry

    Award the best entry Download the files - Easy!

Post a Contest Now or Join us Today!