Booking charts

Closed Posted Aug 7, 2012 Paid on delivery
Closed Paid on delivery

i would like a software soloution for some booking charts. at the moment, i have a pen and paper based system. i work on a campsite, where by i need to show who is in each pitch and for how long. i need to be able to print out a list the days arrivals. and the days visits. We visit all our customers the day after they arrive and the day before they leave, howver if they are only here for 1 night we do not need a visit. if they are here for 2 nights we only do there departure visit.

i would also like to be able to assign members of staff to each item. for instance when i know who is leaving and who is arriving, i assign a staff member to go and clean that accomadtion. so i would like it somehow log who has done what and when, the same goes for each of the visits.

I have added a quick mock up of the chart layout we currently use. As i said before, we currently have a pen and paper based system. So this is only a mock up.

What i am after is to be able to input the customer onto the chart using some sort of form. i would then like the ability to drag the customer from one accommodation to another. All our bookings are sent to us 3 weeks in advance rather than on the day of arrival. however visits and cleans are only decided the day before they are to be done. as you can see from the mock up, i would like some way of being able to run a report that shows everyone that is arriving that day. i would also like to run a report that shows that days cleans. Cleans are done the day the customer leaves. we also re-clean the accommodation the day the next customer arrives - however both are done the same time if the accommodation is to be reused the same day. i would like to be able to assign a clean to each staff

visits are worked out the day they are to be done, so i would need some sort of form that shows me all the visits due for a selected day (selected as i work them out a day before, in order to have a day off), then be able to assign them to each staff

then after all work is assigned i would like to be able to print a report for each staff that shows them,

clean xxx
clean yyy
clean zzz
visit ggg (day after arrival visit)
visit hhh (day before departure visit)

I originally stated i would like it in excel, as i would need it to run on both mac and windows. i was originally planning on storing the excel file on a network attached storage drive in order to access it from both, however i am open to suggestions.

I must add swell, we have different types of accomodation which need to be kept seperate from each other. so once i have assigned a customer to an accomodation, i would to only be allowed to move them into another accomodation which is of the same type.

also the application needs to be able to have accomodation added or removed at any time. As the campsite im on is seasonal, i only want the current year stored. Then next year i would like to almost "reset it" and start over, as i will have all new staff, different customers, different accommodation and so on

Excel Visual Basic Website Design

Project ID: #2384350

About the project

11 proposals Remote project Active Sep 22, 2012

11 freelancers are bidding on average £172 for this job

thelogicgates1

Hi, Ready to start. Check PMB please.

£180 GBP in 10 days
(48 Reviews)
6.5
mrbrave

Lets discuss project in detail..Please see PMB for details how I will do this.

£200 GBP in 5 days
(115 Reviews)
5.7
pishty

I am interested in your project.

£180 GBP in 6 days
(32 Reviews)
5.7
ProfessionalBoss

I can do it

£250 GBP in 19 days
(21 Reviews)
4.9
atchayagandhi

Hi, A very simple application, we can deliver the expected solution. Kindly request you to refer your private message board for further details.

£150 GBP in 5 days
(5 Reviews)
4.6
sritechnocrat

Sri Technocrat is marvelous in its quality. We have been maintaining the quality in every field whether it is services or training. We have proved our stability. We have been working with the same grace & quality. Our More

£150 GBP in 20 days
(1 Review)
4.6
jaimecruz

Hi I'm really interested in your project. I'm an Excel Expert Programmer.

£200 GBP in 7 days
(9 Reviews)
4.2
piyushdpatel

Hi This is Piyush Patel I have 7 yrs of Exp in VBA,VB6,VB.net,SQL and MsAccess. I have developed many applications in VB6,VBA,VB.NET. Please Check My PM

£150 GBP in 7 days
(10 Reviews)
4.1
esalem

Hello, please see the PM for details.

£140 GBP in 6 days
(8 Reviews)
2.8
guruved

Bonjour! I have done similar projects and ready to begin yours as early as possible.

£150 GBP in 5 days
(0 Reviews)
0.0
urvashi2489

Hello, I have 6 years of experience in Visual basics and I have made a lot of these types of projects in it. I can complete this on time.

£145 GBP in 10 days
(0 Reviews)
0.0