Coral Point Count with Excel extensions (CPCe): A Visual Basic program for the determination of coral and substrate coverage using random point count methodology

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/.