texashuntingforum.com logo
Main Menu
Advertisement
Affiliates
Advertisement
Newest Members
dtorgie, bluebiller, Time2GoHuntin, RobbiTX86, Droptine3030
72075 Registered Users
Top Posters(All Time)
dogcatcher 110,799
bill oxner 91,416
SnakeWrangler 65,534
stxranchman 60,296
Gravytrain 46,950
RKHarm24 44,585
rifleman 44,461
Stub 43,982
Forum Statistics
Forums46
Topics538,227
Posts9,734,543
Members87,075
Most Online25,604
Feb 12th, 2024
Print Thread
Page 2 of 2 1 2
Re: Duck Hunting Log [Re: Gill_97] #3634838 10/05/12 03:10 PM
Joined: Jul 2011
Posts: 6
N
NM-Aggie Offline
Green Horn
Offline
Green Horn
N
Joined: Jul 2011
Posts: 6
That's pretty good. You should figure out a way to add a column to each part of the season for weather. Cloudy, sunny, rainy, etc. Then you could graph the amount of birds taken in each weather condition. I could see this being an app for an iphone.

Re: Duck Hunting Log [Re: NM-Aggie] #3634873 10/05/12 03:25 PM
Joined: Sep 2008
Posts: 6,695
C
Cochise Offline
THF Trophy Hunter
Offline
THF Trophy Hunter
C
Joined: Sep 2008
Posts: 6,695
Originally Posted By: NM-Aggie
That's pretty good. You should figure out a way to add a column to each part of the season for weather. Cloudy, sunny, rainy, etc. Then you could graph the amount of birds taken in each weather condition. I could see this being an app for an iphone.


DU has an app that is similar. However it is FAR less detailed.

Guy's log is excellent.

Re: Duck Hunting Log [Re: Gill_97] #3636052 10/06/12 01:16 AM
Joined: Apr 2012
Posts: 1,061
B
Baylor_Bears Offline
Pro Tracker
Offline
Pro Tracker
B
Joined: Apr 2012
Posts: 1,061
Just got it, thats really great Guy. Appreciate it


Re: Duck Hunting Log [Re: Gill_97] #3636064 10/06/12 01:22 AM
Joined: Apr 2012
Posts: 1,061
B
Baylor_Bears Offline
Pro Tracker
Offline
Pro Tracker
B
Joined: Apr 2012
Posts: 1,061
Is there a way I can delete the youth and early teal seasons?


Re: Duck Hunting Log [Re: Baylor_Bears] #3636216 10/06/12 02:12 AM
Joined: Dec 2005
Posts: 35,502
Guy Online Content OP
THF Celebrity
OP Online Content
THF Celebrity
Joined: Dec 2005
Posts: 35,502
Originally Posted By: Baylor_Bears
Is there a way I can delete the youth and early teal seasons?

Yeah. On the “Season summary” tab, left click on column “D” (click on the “D”), this highlights the whole column, hold down over to column “I”, this highlights columns “D” thru “I”, then right click for pop-up menu and select “Hide”. Then go over to “Log” tab and clear out any data in Early Teal and Youth section, just highlight yellow fields and hit “delete” on keyboard and it will clear out data. And you can then highlight rows for Early Teal and Youth like you did columns, right click and hide.

You can also use same logic/instructions to hide only Early Teal or Youth.

Re: Duck Hunting Log [Re: Baylor_Bears] #3637324 10/06/12 07:27 PM
Joined: Dec 2005
Posts: 35,502
Guy Online Content OP
THF Celebrity
OP Online Content
THF Celebrity
Joined: Dec 2005
Posts: 35,502
Originally Posted By: Baylor_Bears
Is there a way I can delete the youth and early teal seasons?

Made some easy buttons. Ok, so this cold weather got me all thinking about ducks so I had to play with my model some more. grin

I loaded a new model, “Hunting Log Model 2012-10-06”. With the following fixes/enhancements:

1) On Log tab, added “Notes” at bottom, provides important notes.

2) Added buttons to Hide/Unhide Early Teal and Youth Season from Season Summary tab. To remove on Log tab, see “Notes” on log tab.

3) I noticed on the log tab when a season is blank with rows in the season, it shows as “skunk” and can mess-up year to date numbers. So I fixed that.

Here is the link to the new model.
https://docs.google.com/open?id=0B-_Yxdx4zpkybVh5WHZpMFV3R0k

Let me is there are any issues with it.

Re: Duck Hunting Log [Re: Guy] #3638153 10/07/12 03:30 AM
Joined: Sep 2005
Posts: 6,466
N
ndhunter Offline
THF Trophy Hunter
Offline
THF Trophy Hunter
N
Joined: Sep 2005
Posts: 6,466
Here you go, I will bump it again so you don't have to.

Re: Duck Hunting Log [Re: ndhunter] #3638900 10/07/12 04:04 PM
Joined: Sep 2008
Posts: 579
1
1 Year Wonder Offline
Tracker
Offline
Tracker
1
Joined: Sep 2008
Posts: 579


The Wonder

Piles-O-Mallards TM

All posts made by the Wonder are a lie, tale, fib or some other stretch of the truth.

Re: Duck Hunting Log [Re: 1 Year Wonder] #3639866 10/07/12 09:56 PM
Joined: Dec 2005
Posts: 35,502
Guy Online Content OP
THF Celebrity
OP Online Content
THF Celebrity
Joined: Dec 2005
Posts: 35,502
That is really good wonder, you come up with that all by yourself? How much time you spend on that? Bet yo momma be proud. loser8

Re: Duck Hunting Log [Re: Guy] #3640933 10/08/12 03:08 AM
Joined: Sep 2005
Posts: 6,466
N
ndhunter Offline
THF Trophy Hunter
Offline
THF Trophy Hunter
N
Joined: Sep 2005
Posts: 6,466
Originally Posted By: Guy
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/edit


I 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.


What about rounds per hunt or bird, seems like you would want to keep track of that...or not. Easy to keep up with, belt holds 25,how many empty loops at the end of the hunt. Lets you know how many spent hulls to look for at the end of the hunt. Another bump for you.

Last edited by ndhunter; 10/08/12 03:13 AM.
Re: Duck Hunting Log [Re: TX_WATERFOWL] #3641203 10/08/12 07:56 AM
Joined: Aug 2009
Posts: 233
L
lakesteak123 Offline
Woodsman
Offline
Woodsman
L
Joined: Aug 2009
Posts: 233
I just use a little log book/tally book. All of that looks cool but im a pencil and paper kinda guy!

Re: Duck Hunting Log [Re: Guy] #3641319 10/08/12 12:31 PM
Joined: Sep 2008
Posts: 579
1
1 Year Wonder Offline
Tracker
Offline
Tracker
1
Joined: Sep 2008
Posts: 579
Originally Posted By: Guy
That is really good wonder, you come up with that all by yourself? How much time you spend on that? Bet yo momma be proud. loser8


Nope, I stolt it from TOS.

Gotta give credit where credits due woot


The Wonder

Piles-O-Mallards TM

All posts made by the Wonder are a lie, tale, fib or some other stretch of the truth.

Re: Duck Hunting Log [Re: 1 Year Wonder] #3641380 10/08/12 01:09 PM
Joined: Mar 2009
Posts: 691
T
Texan1554 Offline
Tracker
Offline
Tracker
T
Joined: Mar 2009
Posts: 691
Guy appreciate you sharing this.

Have been using something similar for a while but didn't look as good as yours. I've taken yours and built on to it a little.

Added goose species, and another sheet to tally "Other Hunts" including dove, quail, deer, hogs, turkey etc... Also changed the skunk tally to a personal kill sum.

Made some room for weather and wind directions.

Anyway, it's based on your design here so thank you.

Re: Duck Hunting Log [Re: Gill_97] #3644413 10/09/12 12:53 PM
Joined: Sep 2010
Posts: 1,203
R
Rob Robertson Offline
Pro Tracker
Offline
Pro Tracker
R
Joined: Sep 2010
Posts: 1,203
Nothing to add. Just playing with my IPAd.






Re: Duck Hunting Log [Re: Rob Robertson] #3644424 10/09/12 12:58 PM
Joined: Jan 2008
Posts: 11,929
#
#Hayraker Offline
Chihuahua
Offline
Chihuahua
#
Joined: Jan 2008
Posts: 11,929
(humble brag)


#sigline
Re: Duck Hunting Log [Re: Gill_97] #4576350 09/17/13 08:31 PM
Joined: Sep 2010
Posts: 525
D
Dfwguy Offline
Tracker
Offline
Tracker
D
Joined: Sep 2010
Posts: 525
https://docs.google.com/file/d/0BwWVrMJHwEeAZGdDRHlHMXBRNUk/edit?usp=sharing

If you guys want Guy's hunting log, click on the above link. If the 'download' link doesn't work at the top center of the screen, try looking in top left --> File --> 'Download'. That should give you the ability to put on your machine.

Thanks Guy, sweet workbook!

Page 2 of 2 1 2
Previous Thread
Index
Next Thread

© 2004-2024 OUTDOOR SITES NETWORK all rights reserved USA and Worldwide
Powered by UBB.threads™ PHP Forum Software 7.7.3