Booking charts explained better

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.


Compétences : Microsoft

en voir plus : quick sort explained, the better me, one night show, excel for mac, excel charts, charts, accommodation software, open input file php, php open input file, report chart, mac basic, access chart, mac visual basic excel, excel quick access, charts excel, log excel visual basic, excel file order form, instance excel, excel instance, excel based booking, leave system software, booking time system php, drag form access, customer excel form, using pen access

Concernant l'employeur :
( 0 commentaires ) France

Nº du projet : #2386818

2 freelance font une offre moyenne de £60 pour ce travail


Hi, I have experience with this project I am very happy to work with you in this project Best regards winnet21

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 7 jours
(0 Commentaires)

sir can u plz give me this.i will do

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% GBP en 5 jours
(0 Commentaires)