SCHEDULES

INTRODUCTION

Schedules are simply another form of Worksheet, but with multiple 'Value' columns, one for each measurable/pricing item in your Project. In other words, you have in Schedules, multiple columns each representing the quantity or cost of one or more items in the Project.

One typical example is 'strip footings'. In the Schedule you would list in separate columns, the footing's attributes - Excavation depth each end, it's width and depth. Having these details, you can now calculate in separate columns:

• Exc Vol
• Backfill Vol
• Cart away Vol
• Conc Vol
• Fabric reo area
• Ligatures in tonnes

Each of the above column's totals can then be 'linked' to an item in the Project.

THE PROCEDURE

1. Create the Schedule
• Click the cell in the current worksheet to 'hold' the Schedule
• Click on the Schedule button in the EDIT TAB
• Choose 'New' from the popup menu
• A dialog will appear
  
  
•  If you have a similar schedule in another Project, you can duplicate this one into this Project
• Click the SELECT button
• Navigate to the 'Schedules' folder of the source project
• Select the other Schedule
• click the 'check box' on the left to nominate this schedule
• Click the 'Duplicate' button
  The Source schedule is then copied into this Project and stored in the 'Schedules' folder.
  You can now edit this Schedule by simply double clicking on the 'holding cell'
• If you need to Initialize a new schedule
• 'Enter the Schedule's Name' e.g. 'StripFootingExcavation'
• Click 'Create'
  A 'Default' schedule is then copied into this Project and stored in the 'Schedules' folder.
  You can now edit this Schedule by simply double clicking on the 'holding cell'
  
2. Modify the Schedule to suit
• Double click on the holding cell
• Modify the Structure of this schedule to suit your requirements
• Enter some dummy data to make sure it is functioning properly
  Here is the Schedule that has been created for the rest of this Tutorial Section
  
  
  
3. Link this cell to a column in this Schedule
   
   Here is the Estimate Worksheet containing the items that we will be measuring in the schedule we have just created above:
   
   
• Select the cell that you want to link a column in the Schedule with; e.g. the QTY column for item 1.1 (Excavation)
• Click the 'Schedule' option in the Edit TAB
• Select 'Link to ..' in the popup menu
• Click the 'Browse' button
  A List of Schedules in the current Project will be shown
• Select the Schedule for our strip footings
• Click the 'Value Column Name' combo box and select the column you want the TOTAL of for this item in this worksheet
  In this case we will select 'Exc'
  
  
  
• Click the 'Link' button
• The 'link' is now stored in the cell and the Total of the column linked to shown
• Do the same for each of the other items contained in this Schedule
  
4. Any worksheet in any Section or Workup Sheet can link to a column in any Schedule in the same Project
5. Edit a Schedule's contents (as opposed to linking) is done by simply clicking on any 'Link' to that schedule
6. All Schedules are located in the Project->Schedules folder
7. You can 'Revert' a Schedule just the same as any Estimate Section