Using Calc as a scheduling tool help
Posted: Wed Mar 04, 2009 10:35 pm
I am a work study student working with a non-profit agency in New Jersey. I have developed a scheduling tool for reserving vehicles on a per month basis through use of a protected and shared excel 2007 workbook. The file is located on the company’s server and the employees can reserve cars available from anywhere with internet access. The actual spreadsheet has thirty-one tabs that represent the days of the month, the columns represent the vehicles and the rows represent the times of the day. The users of the tool add records with their names into the tab for the month of which the vehicle needs to be reserved, and simply use the drag option to make the reservation. The tool contains rules which turn the cells different colors as to the names that are added.
An example of this tool can be found here: https://mcares.webexone.com/default.asp?link= . Click on enter as guest and the Vehicle_Template file is located in the links section. The tool works great and it is a part of the day to day operations of the agency. There are however, a few problems when it comes to the maintenance of this tool. It is very time consuming to add new vehicles to the database and to create new databases for each month of the year, which are frequent operations.
I know the Open Office.otg program is highly customizable.-Is there a way to use the calc program to develop a tool much like the one I have developed. Also is there a way to customize the program to make the editing of locked cells less time consuming.
Any suggestions would be very much appreciated.
An example of this tool can be found here: https://mcares.webexone.com/default.asp?link= . Click on enter as guest and the Vehicle_Template file is located in the links section. The tool works great and it is a part of the day to day operations of the agency. There are however, a few problems when it comes to the maintenance of this tool. It is very time consuming to add new vehicles to the database and to create new databases for each month of the year, which are frequent operations.
I know the Open Office.otg program is highly customizable.-Is there a way to use the calc program to develop a tool much like the one I have developed. Also is there a way to customize the program to make the editing of locked cells less time consuming.
Any suggestions would be very much appreciated.