SET RESOURCE AVAILABILITIES

From the main menu Click the Edit Resource Database Icon.

A Spreadsheet will appear for Resource information to be entered.

For each Resource your project needs enter the following:

Type a code of upto 4 characters. Press -> (Right Tab). Type a description for that code. Press -> (Right Tab).

Enter a Calendar Number for that resource. i.e. Availabilities will be set only on working days as specified by that Calendar.

Press -> (Right Tab).Enter the daily available Quantity. The quantity may be any unit (man days, hours etc) you wish. You must remember to specify quantities in the same unit when you come to enter resources on activities.

Press -> (Right Tab). Enter a date from which the resource is available and the date to which the resource is available. The default dates shown on the first line are Base Date to maximum end date (8 years). Also remember you can set different availabilities by: Entering another line with the same Code and Description and specifying a different Calendar, Quantity Available and 'From' and 'To' Dates.

Note that the Replicate, Copy and Paste facilities can be usefully employed to speed up input. For example to enter the same 'From' and 'To' date down all lines take the following actions:

1. Drag the mouse over the 'From' date in Line 1. Press Ctrl/C.

2. Click the mouse on the Heading. i.e. in the cell that has FromDate. The whole column will be highlighted.

3. Click File. Click Replicate.

4. Press Ctrl/V to paste the date copied.

5. Click OK.

6. Repeat the above procedures for the 'To' date. After all resources have been entered:

Click File. Click Exit. Click Yes to Save.

You can use this feature at any time to make changes. i.e. add more resources or to delete unwanted ones and to change quantities available.

Check Availabilities