Year-end Report Data Templates
For Aquatic Scientific Collector Permit Holders
Scientific collection permit holders are required to provide their data to CPW within 30 days of the expiration date of their permit, using one the CPW approved forms. Please click on the appropriate files below to download a template for submitting your data to CPW. Data should be submitted as one separate Excel file per survey/collecting trip using one of the three data templates listed below.
NEW FOR 2013Data received by CPW is uploaded to its’ aquatic database using automated software which is designed to only read data off the templates provided below. Please read and follow the data entry instructions carefully. Data submission made in the old JakeOmatic or any other file format will NOT be accepted.
JakeOmatic Version 2.42
This fish survey analysis program is designed for fishery professionals to analyze data typically gathered during routine surveys. Common analyses such as the generation of length frequency histograms, population estimates, biomass estimates, relative weight, and relative stock density are all provided. The program is modular, with each module capable of analyzing commonly acquired fishery data. The three primary functions of the program are to analyze:
- Lake survey data (acquired with gill nets, electrofishing, traps, etc.)
- Stream survey data (2 pass removal population estimation)
- River/Lake survey data (mark-recapture population estimation)
The installer will place the program and a support folder in your Program Files folder on your computer that contains a JakeOmatic Manual 
. This manual should be consulted for more details on the program.
JakeOmatic executable zip (20 MB)
Note: this is a very large file. It could be slow to download depending upon your connection speed.
Fish Telemetry Analysis Program
This is companion software for Chapter 14 in the AFS book "Analysis and Interpretation of Freshwater Fisheries Data." This program performs three basic functions that are commonly used in the analysis of fish telemetry data.
-
Calculates the distance from fish locations to the nearest shoreline.
-
Determines if the distribution of fish locations are random (and provides a means to generate a distribution of the test statistic so that a P-value can be assessed).
-
Evaluates if habitat selection is occurring, and whether fish are selecting for habitat types in a similar fashion.
-
Calculates selection ratios for various habitat types.
The installer will place the program and a data folder on your computer that contains a manual. This manual should be consulted for more details on the program and its operation.
Fish Telemetry executable zip (13.7 MB)
Note: This is a very large file. It could be slow to download depending upon your connection.
Fish Telemetry Chapter 14 (2007) - Chapter 14 of the aforementioned "Analysis and Interpretation of Freshwater Fisheries Data."
QStrap Version 3.1
Evaluating taxonomic relationships with microsatellite or AFLP non-diagnostic markers has generated a need for more complex analysis software to evaluate population structure with genotype data. One program that has seen increasing popularity for making these determinations is Program STRUCTURE. While the program easily generates average admixture coefficients (q) to characterize levels of admixture, it does not provide confidence intervals around those values to yield insight into the precision of the estimated q. QStrap uses the estimated q values from STRUCTURE runs to bootstrap confidence intervals around admixture values.
The installer will place the program and a support folder in your Program Files folder that contains a QStrap Manual . This manual should be consulted for details on the program and installation.
QStrap executable zip (13.2 MB)
Note: This is a very large file. It could be slow to download depending upon your connection.