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

  • Estado: Closed
  • Premio: $20
  • Propuestas recibidas: 4
  • Ganador: hozefazs

Resumen del concurso

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

Habilidades recomendadas

Comentarios del empleador

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

Imagen del perfil INDIKAWIC, Sri Lanka.

Principales propuestas de este concurso

Ver más participaciones

Tablero de aclaración pública

  • agustinavilac
    agustinavilac
    • 1 semana atrás

    I have made some modifications to the presented application which I explain in the following video:
    https://youtu.be/3HYYp-QvDiw

    • 1 semana atrás
  • hozefazs
    hozefazs
    • 1 semana atrás

    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 semana atrás
    1. INDIKAWIC
      Organizador del concurso
      • 1 semana atrás

      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 semana atrás
  • INDIKAWIC
    Organizador del concurso
    • 1 semana atrás

    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 semana atrás
    1. hozefazs
      hozefazs
      • 1 semana atrás

      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 semana atrás
  • juancarlosr23
    juancarlosr23
    • 1 semana atrás

    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 semana atrás
  • rashida016245
    rashida016245
    • 1 semana atrás

    Sir, You can finish your Google Sheet work by me. Because I have a lot of experience in Google Sheet.
    #sealed

    • 1 semana atrás
  • raziali
    raziali
    • 1 semana atrás

    Please check my entry No. 45

    • 1 semana atrás
  • Ma7aMaD3Li
    Ma7aMaD3Li
    • 2 semanas atrás

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

    • 2 semanas atrás
  • Shakil3300
    Shakil3300
    • 2 semanas atrás

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

    • 2 semanas atrás
  • uali0012
    uali0012
    • 2 semanas atrás

    Please contact me.

    • 2 semanas atrás
    1. jiichauhan716
      jiichauhan716
      • 2 semanas atrás

      hello sir

      • 2 semanas atrás
  • INDIKAWIC
    Organizador del concurso
    • 2 semanas atrás

    Please make sure to set Appointment Schedule for Next Few Months and Then you need to Provide Summary as well

    • 2 semanas atrás

Mostrar más comentarios

Cómo comenzar con los concursos

  • Publica tu concurso

    Publica tu concurso Fácil y rápido

  • Recibe montones de propuestas

    Consigue toneladas de propuestas De todo el mundo

  • Elige la mejor propuesta

    Elige la mejor propuesta ¡Descarga fácilmente los archivos!

Publica un concurso ahora o únete a nosotros hoy