Scheduler design

[DennisJones]

I am trying to create a system for scheduling instructors during the working day. We currently have a paper based system where we fill in boxes on a grid to represent half hour slots for each of up to about 7 instructors. I am looking for something that can be filled in on a computer screen and networked around three locations. So first of all can you network a spreadsheet?
Assuming that you can network excel, the easiest (and crudest) method I have thought of is to use a separate workbook grid for each day (but how would I create say a year's supply of workbooks in advance?). Not very elegant eh?

Hopefully someone has a better set of ideas.
thanks

Dennis

 

[shades]

Howdy. Don't necessarily have a ready made solution. But networking with Excel can be done, but it will be harder to maintain and will require stricter guidelines on use. Access is the better route to go.

Also, for clarification, there are three different locations, and a total of seven instructors? And you want any combination of them?
________
GLASS PIPES

 

[DennisJones]

Sorry my terminology is confusing, there are three places where there is a computer to access and update the data hence the need for some sort of multiuser system. The seven instructors all work at the same physical location but take clients out individually, at the momnt we use a paper diary with a grid layout with instructors having a column each and the day divided into half hour slots as rows of the grid. We just fill in the boxes when each instructor is booked, the problem is that the diary is invariably in the wrong place when an enquiry comes in by phone.