Stumbleupon Facebook Twitter Digg Google Delicious Linkedin
TechNews

How can I modify the template?

Posted: 06 Feb 2012

Tags: How can I modify the template How can modify the template


How can I modify the template?

Source: www.americommerce.com

Question:

I found this model and it met all my needs but he amended need and I can not understand how to change. Basically, I need the ability to have a capacity of 78. Kentucky school buses have different configurations to allow an additional exit door. I also need all the numbers exchanged on the page of table to seat for the odd numbers are on the right and the numbers to the left.

Here is the link. http://Office.Microsoft.com/en-us/templates/school-bus-seating-chart-updated-TC030008004.aspx

Any help would be greatly appreciated.

Answer:

Go to the sheet forms and remove protection of this
In column g adapt if the formulas in column "lines" on your 78 seats. If you have only your bus 78 you can distribute with formulas and enter the appropriate values.

Map of Variables (unprotect it), remove the validation in the cell of the capacity of the Bus and enter the 78 or adapt the Validation list to include 78 (select the cell, data, validating the data, Source)

To switch from left to right:
On the SeatingChart map, Unprotect Sheet. Adapt the arrangements for low B9 and AB9 downwards depending

Probably the best to restore protection leaves before saving it as a template

Peter Thornton

Rate this article:


  • Pages:
  • 1

0 Comments

Add Your Comment !