Pasco County Extension
Master Gardener Monthly Time Sheets

Para la traduccíon al español, marque aqui.


Links to the forms (please note the directions below):

The EXCEL and WORD forms listed above have been created for the Master Gardeners to report their volunteer hours via email.  For those who may not have the 2003 version of either software, there is a PDF file that they can print, manually fill the form out and then either fax or mail it.  It would be greatly appreciated that anyone who has any problems with these forms either call Sherry at the Extension office or email her at ssteiert@pascocountyfl.net.  Sherry wants to know what type of problems you may have using the forms.

  • DIRECTIONS FOR MICROSOFT WORD FORM:  (1) create a folder on your hard drive; (2) after selecting the link that will bring up the form on your screen, save the file to the folder you created on your hard drive.  Make note of the name of the file.  Open your Microsoft Word software, bring up the file you saved, which will have the file extension .HTML or .HTM, and save the file with the extension .DOC, which is the WORD file extension. (NOTE:  you can save the file with the extension .DOT which is a template file, by selecting the drop-down box located to the right of "SAVE AS TYPE" at the bottom of the "SAVE AS" dialogue box.  A template file can never be overwritten; when you go to save your report for the month, you will always have to name the file with the .DOC extension. To bring up the template file, select FILE, NEW.  A large dialogue box appears on the right side of your screen that pertains to templates you have access to in Microsoft WORD.  Select "TEMPLATES ON MY COMPUTER."  Another page will come up that will have your volunteer hours form template.  Select it to bring the file up, fill it out and name it the month/year you are reporting, making sure you have the .DOC file extension.

    In Microsoft Word a formula can be used to total a column, but it will not recalculate if a number has been added or deleted (as it can in the Excel form); therefore, upon completion of your WORD form, place your cursor in the pink cell at the bottom of the column to be totaled; select "TABLE/FORMULA" in the Toolbar; you will see the default equation (=SUM(ABOVE) in the formula box.  Choose OK and a total of the numbers in the cell you placed your cursor will be seen.  Note:  if you wish to skip a row, place a zero in the correct cell of the skipped row for the formula to work.  Also, after using the formula to add the existing numbers in the column, it will not recalculate if you add a figure in another cell of the same column; the formula must be replaced in the pink cell.

    The form can easily be emailed by sending it as a file attachment.
  • DIRECTIONS FOR MICROSOFT EXCEL FORM:  Directions are the same as above for the WORD form, except the extension for EXCEL files is .XLS.  Also the extension for EXCEL templates is .XLT.  Formulas have been added and all cells with formulas and headings have been locked.  Addition is automatic and no recalculation is necessary.  This is because EXCEL is an accounting/spreadsheet program, whereas WORD is a word processing program. 

    The form can easily be emailed by sending it as a file attachment.

    Para la traduccíon al español, escoja la bandera española arriba. Spanish flag
    El servicio tradutor utilizado aqui puede hacerle publicidad a una variedad de bienes o servicios. La Universidad de Florida y el Servicio de Extension de IFAS no tiene ningún control sobre aquel publicidad, ni aproba los bienes o servicios así ofrecidos.

    Top