Fishing Log via Spreadsheet

Originally Posted by
Just Steve
In my travels yesterday I drove to Portland for some Foo Foo coffee creamer (Caramel Macchiotta) this mornings coffee is much better because of it!
In other happenings.....
I asked OE if he had anything electronic in the way of a Fish Logbook, I have ones from a Lance Valentine class I took a decade ago that you hand write on..... I didn’t find a app I liked so that’s why I asked our computer wizard what he had.
Well quicker than you can say our Ginger snapped, Ionia Eagle made a in depth multi specie, freshwater/saltwater excel spreadsheet.....all the bells and whistles!
If anyone would like their very own, I’ll bet you could PM Captain Underpants for one!
Sent from my iPhone using Crappie.com
Its partially true, Steve said, you got anything? and I said no but I can find or make one.
After some internet search, every thing that looked kind of useful was $20.00, here $30.00 there, for full fledged programs, and thought that's Bull. I can make something for Steve at no cost, via Spreadsheet.
So I used Excel, and made a spread sheet, what fields do you want on it I asked? He pounded his magic hammer thrice on his phone, and I got an image showing me a very old (Might have even been rice paper) fish log.
From that I used some detective work, added some drop down menus, for things like Wind Direction, Sky, Species (28 Fresh Water, and 147 Salt Water) It will total your amount of fish, etc. & a Section for notes.
I took some time to lock the sheet from Steve so he could not change the distance of the fields. (He does not have this sheet yet, he is using a beta/test one from yesterday)
There are a few section, as you cross the spread sheet, there is the Date/Location type data, the Conditions, Presentation, Fish, and Notes.
Before you run off, and think, Man that's ALLOT, its not,.............also myself or anyone with Excel knowledge can make changes, its protected from Steve, but there is not a password.
OH did I mention that you can sort your data? Oh Yeah........ Its cool......
Feel free to use and enjoy.
OH did I mention that you can sort your data? Oh Yeah........ Its cool......
Hmmm, We can not add spreadsheets, as attachments, here, so you can use this link to download the file.
Save it to your desktop, and tinker, play, there is some test data as an example as well.
https://www.dropbox.com/s/6ce6todcxz...0Log.xlsx?dl=0
Here are some screen shots as well, with some made up test data


Custom Rods: Out-Snagging Berkly's 7-2 Since 2019 / Custom Rods: Collecting more dust that Berkley due to Covid Since 2020
Custom Rods: Not afraid to show, in 2021