Encerrado

Build a Scheduling Program or Spreadsheet

I am looking to build a scheduling program (or complex spreadsheet if easier) for an entertainment facility (kids birthday parties). The entertainment facility has six zones and can have 2-4 birthday parties at any one time. We want a program that makes sure we dont have more than one birthday party scheduled in the same zone at the same time (20 minute increments). Inputs and outputs are listed below.

Inputs

Guest Name [Text]

Party Booker

Party Host [Text][Dropdown Menu]

Party Room [Drop Down] [A or B]

Party Date [Calendar]

Party Start Time [Drop Down by Half hour 8AM -8PM]

Party Activity Length [Drop Down] [1, 1.5, 2., 2.5]

Party Theme

Number of Players

Activity 1 [Drop Down: Ropes, Rock Wall, Playground, Free Play, VR, Ninja, Trampoline] (repeat this drop down for each activity)

Activity 2

Activity 3

Activity 4 {only if party more than 1 hours}

Activity 5 {only if party more than 1.5 hours}

Activity 6 {only if party 2 hours}

Functionalities

In any 20 minute increment only allow one party to book Ropes, Rockwall, VR or Ninja. [Only allow 2 parties on Trampolines]

Generate number of themed parties (both number of parties and total guests at such party) by theme.

Generate printout on a per day/week basis (you can select):

• Party Room bookings (i.e. list of all parties in Party Room A/B

• Schedule at each activity (e.g. I want to print out a list of parties by time (with guest name and host) that will be using Rock Wall (or Ninja, etc.)

• Schedule of Parties and activity list for each Party Host (e.g. Host Stephanie has a party at 1PM, and the activities are 1 Rock Wall, 1:20 Ninja, 1:40 VR, 2:00 Party Room A with [Spiderman] Theme.

• List of all Parties with start name and guest name and party room (for front desk)

Utilities

*List of Party Host/bookers Names will need to be able to be changed (easily update list) (as staff will come and go)

*Ability to enter into each reservation and change if needed.

Habilidades: Coding, Excel VBA

Veja mais: writer needed freelance basis write sports articles, setting styles program style needed, processor scheduling program java simulation round robin, google sheets schedule generator., job scheduling software, free scheduling app, google sheets schedule template, employee schedule template, google sheets employee schedule, work schedule maker, open source employee scheduling software, excel scheduling program, access scheduling program, content writer needed term basis, process scheduling program java, build p2p program, basic qualification needed sap basis course, mysql volunteer scheduling program, excel spreadsheet stock cost basis, drag drop scheduling program

Acerca do Empregador:
( 0 comentários ) Peekskill, United States

ID do Projeto: #19403540

25 freelancers estão ofertando em média $465 para esse trabalho

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( Mais

$700 USD in 5 dias
(47 Comentários)
6.9
schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Mais

$400 USD in 10 dias
(17 Comentários)
5.2
P0L

Hello, I’m an Excel expert and I can design a scheduling spreadsheet for your entertainment facility. Please check my profile and contact me to discuss further details. Regards.

$400 USD in 10 dias
(10 Comentários)
5.0
polarjin2017

This is Excel /VBA result which I 've done [login to view URL] This is what i have done in Excel/VBA/MACRO. Just Crreating forms, query, Macro, custom formula, etc... I;ve done so many jobs in excel like l Mais

$250 USD in 3 dias
(12 Comentários)
4.7
SShtv

Hello, I am interested in your proposal and I am ready to solve your task. I have a large and successful practical experience of processing and analyzing data in Excel, including using the VBA. These are screenshots Mais

$250 USD in 5 dias
(14 Comentários)
4.5
ksriniravi

Greetings! Thanks for very succinct and clear requirements! Being a full time freelancer working exclusively on Excel based projects, I work on such Excel based solutions (involving Excel VBA) every single day. I Mais

$250 USD in 5 dias
(13 Comentários)
4.2
dgled

Hi, I did a lot of similar projects and can show you an example I did lately. I can suggest to you a module in Microsoft Excel which enables to add/update records on flexible bulletin forms. Excel validates the informa Mais

$555 USD in 10 dias
(3 Comentários)
4.9
dinhfreedom

Dear sir. Your project attracted my attention at first glance, because I've extensive experience in Excel VBA Programming. I'm really confident about your project, and very eager to join your project. If we have a c Mais

$500 USD in 10 dias
(1 Comentário)
3.4
dobreiiita

Hello I am programming expert and interested in the project. I have reviewed your requirements regarding scheduling application you are looking for and I would like to help you out with that. Please communicate to d Mais

$250 USD in 10 dias
(2 Comentários)
3.1
RushService

Feel fee to contact me forBuild a Scheduling Program or Spreadsheet .Shoot me message to discuss further more details .We provide the comments,images,videos,demos and live sessions in order to help the [login to view URL] Mais

$250 USD in 3 dias
(3 Comentários)
2.7
zu02

Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Excel /VB. Such programs better to solve via Ms Access. I can build it via Excel and via Access-which of way you'll p Mais

$555 USD in 10 dias
(3 Comentários)
2.8
elqueabandona

Hello, my name is Cristian, i am Excel/VBA expert. I am in the top 5 of freelancers in this area and i have more than 240 projects successfully completed here. i work alone, i do not have a team or outsource the pro Mais

$400 USD in 10 dias
(2 Comentários)
2.7
Max01

hello hope you are doing well I am interested to work on this project. Gladly waiting to serve you with my extensive skills. We can develop a web-based program.

$750 USD in 15 dias
(3 Comentários)
3.0
xinglong717

I have many experiences in Excel VBA developing and data mining. I'm software engineer and algorithm expert. Your task is suitable with me. I'm also perfected in C, C++, C#, SQL, PHP .... Thank you.

$250 USD in 10 dias
(1 Comentário)
2.0
musthree

I will need a bit of clarification about the terms you are using to understand better and create the functionality better. I can create this app based on Excel in a very easy to use design but actually it seems to bet Mais

$750 USD in 4 dias
(1 Comentário)
1.1
flviovargas

Hello! I have understood your need and believe that I can develop the best solution for You with a smart sheet, where in one sheet you perform the markings and check availability of resources and in another is gener Mais

$300 USD in 9 dias
(0 Comentários)
0.0
balogh68

I am an Excel and VBA expert, I can do this job for you. I have been working with Excel as a Finance Manager for the past twenty years.

$251 USD in 2 dias
(0 Comentários)
0.0
lavizsolutions

Hi there, Greetings, kindly share me some details so that can estimate time and cost. Please check once.. 1. Case Management system. [login to view URL] you can Mais

$1000 USD in 20 dias
(0 Comentários)
0.0
vikaskumar394599

give me to do the work

$555 USD in 10 dias
(0 Comentários)
0.0
rclevenger

I’m a vba ninja, I’ve worked in Finance for 15 years and have created every kind of report and dashboard using automation you can imagine. I’m sure I could do the task for you and once completed. I could create you a Mais

$833 USD in 3 dias
(0 Comentários)
0.0