Notes to modify this workbook:

1.  Each worksheet is protected and only the cells in the data entry areas of each zone's sheets are unlocked.

a.

These data areas are date, FC, nest, Mote nest #, address, actual hatch date, #empty shells,

#unhatched eggs, # pipped live and dead, and # live and dead in nest.

b.

To unprotect a worksheet.  Select Tools, Protection, Unprotect Sheet (if last option says "Protect Sheet"

sheet is already unprotected).

2.  The gridlines and column and row headings have been hidded in the worksheets.  To show them select:  Tools, Options,

View, check boxes for Gridlines and  Row and Column Headers.

3.  Each Zone's worksheet contains formulas in 3 sections of the worksheet (each Zone's worksheet is identical).

a.

In the Data Entry section, the columns highlighted in yellow (Calc. Hatch Date, Total Clutch, Hatchlings Emerged,

and % Success) are formulas as follows:

1)

Calculated Hatch Date formula:   =if(nest=1,date+55," ")

If a crawl is marked as a nest (with a 1 in the nest column) this formula calculates

the hatch date by adding 55 days to the date of the crawl. If nest doesn't contain "1", a blank

space occupies the cells of this collumn (as in false crawls and unused rows).

2)

Total Clutch Formula:  = #empty shells + #unhatched eggs + #pipped live + #pipped dead

3)

Hatchlings Emerged Formula:  = #empty shells - #dead in nest - # live in nest

4)

% Success Formula:  = hatchlings emerged / total clutch

NOTE:

These formulas are nested in =IF statements which show values only if a nest is excavated

=IF statements are as follows:  =if(logical test, value if true, value if false)

These =IF statements are used to keep the worksheet uncluttered by useless numbers.

b.

In each Zone's worksheet, Row 10 is hidden and contains formulas.  If Row 10 is unhidden, the yellow highlighted

cells contain the formulas.  These formulas sum the quantities in each column for all nests in the zone

(i.e. total empy shells in zone, total unhatched eggs in zone, total pipped live,…, & hatchlings emerged).

Cell P10 contains the formula to calculate the zones overall % success (=total of all clutches / total of all emerged).

c.

The boxed "Summary for Zone _" section simply totals the Number of False Crawls, Number of Nests, Number of

Nests Hatched, the zones overall % Success Rate, and Nesting Turtle and Hatched Nests Disorientations.

4.  Manatee Co Summary worksheet provides the totals for all nests in Manatee County and is used to provide the public with this

general information.  The formulas in this worksheet summarize the data from each Zone's worksheet.

This worksheet's cells are ALL locked.

5.  To update for the new year, go to sheet "Zone A" cell "A3" and change the year.  This will change the year on the other zone sheets.

Then go to sheet "Manatee Co Summary" cell "B3" and change the year in this cell.  Workbook is now ready for the new year.

6.  This workbook was created by Cathy Wilson, 2/24/06.  Please contact with any questions.