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,
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.