Photographic and video methods are frequently used to increase the efficiency of coral reef monitoring efforts. The
random point count method is commonly used on still images or frame-grabbed video to estimate the community statistics
of benthos. A matrix of randomly distributed points is overlaid on an image, and the species or substrate-type lying
beneath each point is visually identified. Coral Point Count with Excel extensions (CPCe) is a standalone Visual Basic
program which automates, facilitates, and speeds the random point count analysis process. CPCe includes automatic
frame-image sequencing, single-click species/substrate labeling, auto-advancement of data point focus, zoom in/out, zoom
hold, and specification of random point number, distribution type, and frame border location. Customization options
include user-specified coral/substrate codes and data point shape, size, and color. CPCe can also perform image calibration
and planar area and length calculation of benthic features. The ability to automatically generate analysis spreadsheets in
Microsoft Excel based upon the supplied species/substrate codes is a significant feature. Data from individual frames can
be combined to produce both inter- and intra-site comparisons. Spreadsheet contents include header information,
statistical parameters of each species/substrate type (relative abundance, mean, standard deviation, standard error) and the
calculation of the Shannon–Weaver diversity index for each species. Additional information can be found at http://
www.nova.edu/ocean/cpce/.