The HACC Spreadsheet

Prepared by :

Gevers Goddard Jones Pty Ltd

Unit 9 8-10 Pensioner Guard Road North Fremantle

Phone:   9336 7717   Fax:  9336 7718

Email: resources@ggj.biz     Web:  www.ggj.biz

Ver 4.0  1/09/2004

Copyright 2004:  This spreadsheet can only be used by the service that has purchased it.  Any other use is a breach of copyright.

Your Service Name:

Acorn Aged Care Services

Start Date:

1/01/2005

USER INSTRUCTIONS

MACROS:  This spreadsheet needs to run macros in order to work properly.  Make sure your macro security level on your computer is set to medium.  You can check it by selecting Tools/Macro/Security.  Select the Medium setting.

1. You can only enter data in the cells colored blue, cream or red.

2. Enter the names of your staff in in the Staff Listing & Performance Reviews.  The names are then automatically copied to the Training Matrix.  Use the Staff & Performance Reviews sheet to record the scheduled and completion dates for performance reviews and any identified training needs.

3. If you need additional rows in a sheet position your cursor in column B and click on the Add Row button. Note that the new row is inserted above the selected cell.  Note also that you cannot add a row from the top row - you must be in the second row or lower.

4. To schedule a training event in the Training Calendar enter the date in the appropriate month (eg19) OR enter an S to show it is scheduled.  Months with training scheduled will show as cream.  Once training is completed enter a C in the month.  The month will now show as red.  The different colors will make it easier to see what training is scheduled and what has been completed.

5. To print a page click on the print icon or select File/Print.  The sheets are set up to print in color.

Please Note:  We can customise this spreadsheet to meet your requirements.  Telephone for details.