Forums46
Topics538,096
Posts9,732,978
Members87,066
|
Most Online25,604 Feb 12th, 2024
|
|
|
Duck Hunting Log
#3541910
09/04/12 11:13 PM
|
Joined: Dec 2005
Posts: 35,501
Guy
OP
THF Celebrity
|
OP
THF Celebrity
Joined: Dec 2005
Posts: 35,501 |
I got an excel model I develop with macros, it is a duck hunting log, it is real slick I think. I been using this same model for years now, and every season I jazz it up a little more. I have let a few members use it, but I think it was probably to complicated before, you had to know excel to use it. But I got it now where anyone can use it I think, you just need excel. It has 2 tabs on it. 1 tab is called “Log”, this is where you input your information. The other tab is call “Season Summary”, it will summarize the data and generate a little chart for you. Below is the chart and my log for last season” Here is a link to the model. You have to be logged into google. https://docs.google.com/file/d/0B-_Yxdx4zpkybVZNSzVvOUhGSmc/editI think the model is pretty intuitive. I cleared out all my info I just put bogus info in there. On the summary tab, just go to cell C2 and change the season. There is a sort button you can click on sort by number of ducks shot. In column J right above the “J”, there is a “+”, click on that to open up Youth Season if you need that. On the Log tab, yellow cells are input cells, and red font will drive formulas. Post up any questions you have.
Last edited by Guy; 10/01/12 02:01 AM. Reason: link updated with 9-30-2012 model
|
|
|
Re: Duck Hunting Log
[Re: Guy]
#3541933
09/04/12 11:18 PM
|
Joined: Jan 2008
Posts: 11,928
#Hayraker
Chihuahua
|
Chihuahua
Joined: Jan 2008
Posts: 11,928 |
#sigline
|
|
|
Re: Duck Hunting Log
[Re: #Hayraker]
#3542560
09/05/12 02:04 AM
|
Joined: Dec 2005
Posts: 35,501
Guy
OP
THF Celebrity
|
OP
THF Celebrity
Joined: Dec 2005
Posts: 35,501 |
Here are some things that may not be intuitive:
Column C “Pr”, Pr stands for private, put a 1 if the spot was private or a 1 in column D “Pu” for public, if you care to tract that. This does drive stats on summary tab, that is why font is red. Column E “Spot” just informational as well as column F “Lake Level”, black font, so you can put whatever you want here, as well as “comments field” column AE.
|
|
|
Re: Duck Hunting Log
[Re: Guy]
#3542785
09/05/12 02:53 AM
|
Joined: Sep 2007
Posts: 5,029
TexasEd
THF Trophy Hunter
|
THF Trophy Hunter
Joined: Sep 2007
Posts: 5,029 |
Cool. I keep a narrative log with pictures in a word document. I do one for each year.
|
|
|
Re: Duck Hunting Log
[Re: TexasEd]
#3542806
09/05/12 02:57 AM
|
Joined: Jan 2010
Posts: 922
TrackQuack
Tracker
|
Tracker
Joined: Jan 2010
Posts: 922 |
Nice job, I'm sure plenty of people will use it
|
|
|
Re: Duck Hunting Log
[Re: TrackQuack]
#3542878
09/05/12 03:18 AM
|
Joined: Dec 2008
Posts: 12,295
Cody Malone
THF Celebrity
|
THF Celebrity
Joined: Dec 2008
Posts: 12,295 |
HF Whitetail / Exotic / S. African Safaris
Proudly Sponsored by: Horizon Firearms / Swarovski Optiks / Under Armour / Yeti Coolers / Costa Del Mar / Havalon Knives
Malone Outdoors, LLC C/254-722-9031 or E/ maloneoutdoors@yahoo.com
|
|
|
Re: Duck Hunting Log
[Re: Cody Malone]
#3543103
09/05/12 04:37 AM
|
Joined: Nov 2004
Posts: 14,768
jeh7mmmag
gramps
|
gramps
Joined: Nov 2004
Posts: 14,768 |
Nice job Guy. If you don't have Excel program you can download Open Office free and use its SS.
�Everybody needs beauty as well as bread, places to play in and pray in, where nature may heal and give strength to body and soul.� ~ John Muir
|
|
|
Re: Duck Hunting Log
[Re: jeh7mmmag]
#3543561
09/05/12 01:35 PM
|
Joined: Dec 2005
Posts: 35,501
Guy
OP
THF Celebrity
|
OP
THF Celebrity
Joined: Dec 2005
Posts: 35,501 |
Answering a PM: You must “enable macros” in excel for the macros to run. I have excel 2007, so it may be different if you have a different version, but left corner of excel mouse over Microsoft icon, it says “Office Button”, click on that, then click on “Excel Options”, then click on “Trust Center”, then “Trust Center Settings”, then “Macro Settings”. There are various levels of security options for enabling macros, I just enable them all. There was a period in the 90’s when there was excel viruses going around driven from excel macros, but I have not seen any of those any more since then, and I use excel every day. But if you are worried about it, try some of the other macro enable settings. Some of the setting will give you a pop up "Do you want to enable these macros?" something like that, like I said I do not mess with those settings.
|
|
|
Re: Duck Hunting Log
[Re: jeh7mmmag]
#3543565
09/05/12 01:36 PM
|
Joined: Dec 2005
Posts: 35,501
Guy
OP
THF Celebrity
|
OP
THF Celebrity
Joined: Dec 2005
Posts: 35,501 |
Nice job Guy. If you don't have Excel program you can download Open Office free and use its SS. Thanks James that is a good idea.
|
|
|
Re: Duck Hunting Log
[Re: Guy]
#3543631
09/05/12 01:55 PM
|
Joined: Mar 2012
Posts: 341
TX_WATERFOWL
Bird Dog
|
Bird Dog
Joined: Mar 2012
Posts: 341 |
Sunday, December 9, 2012....ha
|
|
|
Re: Duck Hunting Log
[Re: TX_WATERFOWL]
#3543642
09/05/12 01:58 PM
|
Joined: Dec 2005
Posts: 35,501
Guy
OP
THF Celebrity
|
OP
THF Celebrity
Joined: Dec 2005
Posts: 35,501 |
Sunday, December 9, 2012....ha Yeah, I got a bunch of bogos info in there, also shooting over limits lol. I just cleared my info out and randomly entered info. Here some other info that is not intuitive. You will notice on my log last season I shot 8 different species of ducks and that is all that is shown. But if you look on the log tab, there are 10 different species of ducks. The model will allow you to track 10. But last season I only shot 8. So on the summary tab, I only show 8, I have the last 2 hidden because they were blank last season. When I cleared all my info out and put bogus info in there, I forgot to unhide those 2 extra rows. To unhide the 2 additional slots for duck species, on row 16 to the left there is a “+”, click on that and it will unhide those rows.
|
|
|
Re: Duck Hunting Log
[Re: Guy]
#3543647
09/05/12 02:00 PM
|
Joined: Mar 2012
Posts: 341
TX_WATERFOWL
Bird Dog
|
Bird Dog
Joined: Mar 2012
Posts: 341 |
I still like the template a lot. I have never really kept track of the different species. Maybe I will give it a whirl this year.
|
|
|
Re: Duck Hunting Log
[Re: TX_WATERFOWL]
#3543654
09/05/12 02:04 PM
|
Joined: Mar 2012
Posts: 341
TX_WATERFOWL
Bird Dog
|
Bird Dog
Joined: Mar 2012
Posts: 341 |
Not allowing me to edit though.
|
|
|
Re: Duck Hunting Log
[Re: TX_WATERFOWL]
#3544110
09/05/12 04:33 PM
|
Joined: Aug 2011
Posts: 245
E-Tx
Woodsman
|
Woodsman
Joined: Aug 2011
Posts: 245 |
Well I couldn't edit before after adjusting the macro settings. And wouldn't you know it....this morning I open it up and am free to do whatever without any changes. Kind of weird, but it works.
Thanks for letting us use this excellent program.
|
|
|
Re: Duck Hunting Log
[Re: TX_WATERFOWL]
#3545319
09/05/12 10:41 PM
|
Joined: Dec 2005
Posts: 35,501
Guy
OP
THF Celebrity
|
OP
THF Celebrity
Joined: Dec 2005
Posts: 35,501 |
Not allowing me to edit though. Still having problems? There is no reason that you cannot edit it, other than you do not have macros enabled as the other poster mentioned above. Few things here: 1) If you have any questions, please post them here vs sending me a PM. Others can benefit from your questions, and also other members might be able to answer your question as well 2) I had a member PM me that they downloaded w/o having an account with google, so I guess you do not need to be logged in. This was my first time to use google docs 3) A member PMed me the following question: “How can I add another species of duck to where it still carries over the same forumlas and all that?” Answer: The model will allow you to track 10 species of ducks (or goose, or dove for that matter). You make those changes on the log tab. At the top, you will see the duck name. Example, model is save with Wood Duck in cell I9. Change that to what ever you want, and it will carry over to the summary tab. Keep in mind the order is different. The log tab the species of duck will be the order in which you put them, but on the summary tab, it will be in the order in which how many you shot. You must hit the “Sort” button to refresh.
|
|
|
Re: Duck Hunting Log
[Re: Guy]
#3548954
09/07/12 12:55 AM
|
Joined: Nov 2009
Posts: 610
GreyDuck
Tracker
|
Tracker
Joined: Nov 2009
Posts: 610 |
Great way to keep track of your season Guy.
|
|
|
Re: Duck Hunting Log
[Re: GreyDuck]
#3620256
10/01/12 01:52 AM
|
Joined: Dec 2005
Posts: 35,501
Guy
OP
THF Celebrity
|
OP
THF Celebrity
Joined: Dec 2005
Posts: 35,501 |
I just up loaded a new model, 9-30-2012. The last model the sort button was not working right. I think I fixed it.
There are 2 buttons now on Summary tab. The “Sort Table” button sorts results by species. “Reset Table” button resets order like what is in the log tab.
Post up if you have any questions. Like last time, I just put bogus data in the model for illustrative purpose. The “log” tab has not changed, so you can just copy paste from old to the new model. Past only yellow fields..
Let me know if you have any questions.
|
|
|
Re: Duck Hunting Log
[Re: Sims Custom Knives]
#3620370
10/01/12 02:09 AM
|
Joined: Dec 2005
Posts: 35,501
Guy
OP
THF Celebrity
|
OP
THF Celebrity
Joined: Dec 2005
Posts: 35,501 |
You could market it as an app for iphone They already have apps. I like spreadsheets, that is just me. If you like spreadsheets too you might like this.
|
|
|
Re: Duck Hunting Log
[Re: Guy]
#3630142
10/03/12 11:39 PM
|
Joined: Dec 2005
Posts: 35,501
Guy
OP
THF Celebrity
|
OP
THF Celebrity
Joined: Dec 2005
Posts: 35,501 |
I just up loaded a new model, 9-30-2012. Had a few e-mails requesting access, I forgot to update access to "public share", so anyone should be able to access it now.
|
|
|
Re: Duck Hunting Log
[Re: Guy]
#3634227
10/05/12 04:23 AM
|
Joined: Sep 2005
Posts: 6,466
ndhunter
THF Trophy Hunter
|
THF Trophy Hunter
Joined: Sep 2005
Posts: 6,466 |
I just up loaded a new model, 9-30-2012. Had a few e-mails requesting access, I forgot to update access to "public share", so anyone should be able to access it now. I think you are just bumping your own post. There were no PM's was there?
|
|
|
Re: Duck Hunting Log
[Re: ndhunter]
#3634471
10/05/12 12:43 PM
|
Joined: Dec 2005
Posts: 35,501
Guy
OP
THF Celebrity
|
OP
THF Celebrity
Joined: Dec 2005
Posts: 35,501 |
Actually about 15 google system emails requesting access.
|
|
|
Re: Duck Hunting Log
[Re: Guy]
#3634765
10/05/12 02:37 PM
|
Joined: Dec 2009
Posts: 2,149
TxDuck24
Veteran Tracker
|
Veteran Tracker
Joined: Dec 2009
Posts: 2,149 |
Awesome man just Got it and already got me some days on there
|
|
|
Re: Duck Hunting Log
[Re: TxDuck24]
#3634801
10/05/12 02:51 PM
|
Joined: Sep 2011
Posts: 249
Gill_97
Woodsman
|
Woodsman
Joined: Sep 2011
Posts: 249 |
that's cool. did anyone load this up on a windows phone and try it on there?
|
|
|
Moderated by bigbob_ftw, CCBIRDDOGMAN, Chickenman, Derek, DeRico, Duck_Hunter, hetman, jeh7mmmag, JustWingem, kmon11, kry226, kwrhuntinglab, Payne, pertnear, rifleman, sig226fan (Rguns.com), Superduty, TreeBass, txcornhusker
|