Fishing Log
Pedro
Posted 6/19/2007 3:13 PM (#261487)
Subject: Fishing Log





Posts: 670


Location: Otsego, MN
Just curious what you guys use and how detailed you get with it?
I used to use a giant Calender like the ones teachers have on their desks for planning, but now I am thinking about putting it all on the computer.

I take lake. wind, water temp, then if there is fish action I put down the lure, depth, time, type of structure.

butterwheels
Posted 6/19/2007 3:14 PM (#261488 - in reply to #261487)
Subject: Re: Fishing Log





Posts: 143


i'm working one out with microsoft excel. i'm fairly proficent with that program, so it just made sense to use it.
Bytor
Posted 6/19/2007 3:30 PM (#261491 - in reply to #261488)
Subject: Re: Fishing Log





Location: The Yahara Chain
I have one on excel that I started using in 2005. It works great. I wish that I had started using it sooner. I can email you a copy if you want to see it.
esoxaddict
Posted 6/19/2007 3:37 PM (#261494 - in reply to #261487)
Subject: Re: Fishing Log





Posts: 8781


Date
Time
Species
Length
Girth
Lake
Spot
Sky Conditions
Air Temp
Water Temp
Water Clarity
Water Color
Wind Speed
Wind Direction
Moon Phase
Moonrise
Moon Transit
Moonset
Sunrise
Sun Transit
Sunset
Major(s)
Minor(s)
Depth
Depth where fish was caught
Bottom coposition
Structure
Lure type
Presentation

Mine's in excel, too.
esox50
Posted 6/19/2007 6:40 PM (#261512 - in reply to #261487)
Subject: Re: Fishing Log





Posts: 2024


Try doing a search in these forums. I think Travis Kopke posted an Excel template for the log he uses which I have also used ever since (I think it was posted in 2005). If not, email me and I'll shoot you my modified template.

EA's is extremely detailed. Mine has most of the same stuff - lake, date, water temp, sky, cover, structure, bait, lunar phase, wind speed/direction, and a section to write notes I feel were imperative to the catch.
CiscoKid
Posted 6/20/2007 7:20 AM (#261572 - in reply to #261487)
Subject: RE: Fishing Log





Posts: 1906


Location: Oconto Falls, WI
Here is the old thread with my excel log, as well as others information.

http://muskie.outdoorsfirst.com/board/forums/thread-view.asp?tid=18...
dedicated angler
Posted 6/20/2007 8:58 AM (#261585 - in reply to #261487)
Subject: RE: Fishing Log


I have a log I started in excel back on 1999
I have moved it to MS Access Database This allows me to run queries against me existing data.

I Track the following
Lake
time of trip & duration
locations
structures
Moonphase
Weather - temp, wind etc
Water temp
Baits, presentations
Notes
Lakemaps
Photos
Anglers
And this year I will add GSP Locations once I get a GSP unit
Jomusky
Posted 6/20/2007 8:54 PM (#261685 - in reply to #261585)
Subject: RE: Fishing Log




Posts: 1185


Location: Wishin I Was Fishin'
Woud you be willing to share the access database?
Steve Fiorio
Posted 6/20/2007 9:59 PM (#261692 - in reply to #261487)
Subject: RE: Fishing Log


Hello if anyone would be so kind as to send me a copy of the excel or any other type of log so I can start my own that would be great!!!!
Thanks
Steve
[email protected]
esox50
Posted 6/21/2007 7:07 AM (#261707 - in reply to #261487)
Subject: Re: Fishing Log





Posts: 2024


Steve,

You've got mail.
CommonSense Guy
Posted 6/21/2007 11:05 AM (#261747 - in reply to #261487)
Subject: RE: Fishing Log




Posts: 136


join muskies in and you can keep a fish list on their site forever.
dedicated angler
Posted 6/21/2007 12:29 PM (#261760 - in reply to #261685)
Subject: RE: Fishing Log


I think it will fit on a CD so if you have MS Access I can send it. Drop me a note and we can talk more about it.

[email protected]
stdevos
Posted 6/21/2007 6:04 PM (#261811 - in reply to #261760)
Subject: RE: Fishing Log





Posts: 416


Location: Madtown, WI
For those using excel, why use it just as a database when you could use it (with a little know how) to produce any type of statistic imaginable? For the past 4 years I have every single active fish logged (Follow, Hit, Lost, or Boated musky) and my spreadsheet automatically produces statistics for every lake, lure, angler, and month (and am thinking about including moon phase and weather patterns) after I enter a trip. I've even went as far as creating a formula to calculate every trip a grade. Then with excel you can sort by your best days, which can be very useful. Also, you can use excel to produce charts and graphs to compare lakes/months/lures to each other.

For what it's worth, I log date, time, lake, weather conditions, wind, air and water temps, # of follows, hits, boated, or lost musky, and enter remarks about which pattern was producing the best.