Spreadsheet of camera pictures

[8 POINTS OR BETTER]

I'm putting together a spreadsheet to log my trail camera info. If any one does this I'd like some ideals on ways to log each individual bucks ID's. Do you give them a ID#, name, ect. Also it would be nice to see some spreadsheets, or different ideals.

 

[CopperHead77]

You might try the buckspy software,it's pretty good for logging all that info.

 

[BSK]

BuckSpy is pretty darn good (the professional version).

I use relational databases to hold my trail-cam data, but the info I collect is:

For each photo

Date
Time
Camera site #
Total # of deer in picture
# of bucks in picture
# of does in picture
# of fawns in picture
# of unidentifiable deer in picture
Unique bucks in photograph ID #s (and I use a five digit number for each unique buck. The first two digits are the year and the last three digits are his unique number for that year, with the very first buck identified for the year getting 001 and then moving up in number as new bucks are identified. For example, buck 07012 is the 12th unique buck identified in 2007).


I then have a separate database for camera sites (locations). I can link the two database (and this can be done with macros between spreadsheets) on the camera site #.

The camera site data is:

Camera site #
Date camera placed there
Date camera removed
Whether the camera site is baited or unbaited
Description of camera location by feature being covered (and I use a series of "keywords" here, such as "scrape," "saltlick," "trail," "food plot" etc. I leave room to use multiple keywords if necessary, such as "saltlick" and "trail" for a salt lick that is along a trail.)

 

[8 POINTS OR BETTER]

Thanks BSK that is the knid of info I was looking for.

 

[cbcs1987]

Heres what I do simply using my documents.
Create a folder for all trail cam pics
make sub folders inside trail cam folder for different cam locations.
Then inside each of those create 12 folders (January-December)
Inside of the monthly folders create folders for the different moon phases.
Now just upload the pictures into the proper folders and you will be surprised at how it seems a routine is developed in deer movement

 

[Football Hunter]

BSK, you didnt say {picture of buck over corn pile}lol

 

[BSK]

BSK, you didnt say {picture of buck over corn pile}lol

That's because I no longer use food-based attactants in my "baited" camera censuses. Not only was I worried about aflatoxin problems with corn used in summer, I've found that using corn as the camera bait loses its effectiveness over time. The first few years you use this technique in a given area, it works great. But with more years of use, older bucks become very wary of it, and getting them on film at corn bait-piles becomes nearly impossible.

I have not had this problem using salt licks as the camera bait. They don't appear to lose their effectiveness over time. After running camera censuses at these sites for half a dozen years, I still get pictures of fully mature bucks.

Two years ago a ran "duel" baited photo censuses on the same property at the same time--a full corn-based baited census at the same time as a salt lick baited census. The corn-baited sites produce few if any pictures of the older bucks I was getting at the salt licks.

 

[Anonymous]

The first few years you use this technique in a given area, it works great. But with more years of use, older bucks become very wary of it, and getting them on film at corn bait-piles becomes nearly impossible.

Must be nice problem to have! Not an issue for me!