71-South
is Blowin Smoke!
- Joined
- May 2, 2008
- Location
- Harrisonville, MO
Hey All,
I like to analyze the hell out of our scores after every competition. I don't do this to play the what if game so much as I do to figure out where we stumbled, what we need to work on, etc.
One of the things I'd like to be able to do is look at trends over time. This requires putting our scores in some kind of database, spreadsheet, app, etc. I couldn't find what I was looking for, so I'm developing one myself (a Windows application.) And I'm looking for help when it comes to what kind of information we can pull out of KCBS BBQ score sheets - either one off, or over time. I'm not looking for money on this thing. I highly doubt there would be enough potential users to make it a viable money maker anyway. If it turns out to be useful, I'll freely share it w/ Brethren members.
The working title at this point is "BBQ-Score-Guru". After a couple of evenings of coding, I have it to where I can input score and event information for each of the contests that we do. I'm going to add fields to keep overall competition notes for each contest, plus notes for each of the four categories.
Here's what the screen looks like for now once you've entered in data for a contest:
For each contest, you just enter the details, then punch in the judges' scores for the four categories and the program calculates the final scores in the upper right, grays out the scores in the grid that got thrown out, and shows you the alternate view for each meat down below.
The program looks at the contest date and uses the appropriate (2013 or 2014) weightings. If prior years are calculated in the same way, it'll be trivial to put those years' weightings in (if they're different.)
The main screen is far from finished. Right now, it just shows the contests I've entered and let's me edit/view them and/or enter new contests.
I may add a place to keep recipes, timelines, etc, so they'd be easy to keep in one place. Not sure about that yet. I'm kicking around ideas on trend reports that I could run on data (from the main screen), but I'm pretty early in that process.
So I ask you, Brethren, any ideas for the direction of this program? I've considered putting placings in for each contest, but that would require a sh*tload of data entry for each one, so I'm waffling on that.
Let me know if you have any ideas, questions, etc.
Thanks much,
Bret
I like to analyze the hell out of our scores after every competition. I don't do this to play the what if game so much as I do to figure out where we stumbled, what we need to work on, etc.
One of the things I'd like to be able to do is look at trends over time. This requires putting our scores in some kind of database, spreadsheet, app, etc. I couldn't find what I was looking for, so I'm developing one myself (a Windows application.) And I'm looking for help when it comes to what kind of information we can pull out of KCBS BBQ score sheets - either one off, or over time. I'm not looking for money on this thing. I highly doubt there would be enough potential users to make it a viable money maker anyway. If it turns out to be useful, I'll freely share it w/ Brethren members.
The working title at this point is "BBQ-Score-Guru". After a couple of evenings of coding, I have it to where I can input score and event information for each of the contests that we do. I'm going to add fields to keep overall competition notes for each contest, plus notes for each of the four categories.
Here's what the screen looks like for now once you've entered in data for a contest:
For each contest, you just enter the details, then punch in the judges' scores for the four categories and the program calculates the final scores in the upper right, grays out the scores in the grid that got thrown out, and shows you the alternate view for each meat down below.
The program looks at the contest date and uses the appropriate (2013 or 2014) weightings. If prior years are calculated in the same way, it'll be trivial to put those years' weightings in (if they're different.)
The main screen is far from finished. Right now, it just shows the contests I've entered and let's me edit/view them and/or enter new contests.
I may add a place to keep recipes, timelines, etc, so they'd be easy to keep in one place. Not sure about that yet. I'm kicking around ideas on trend reports that I could run on data (from the main screen), but I'm pretty early in that process.
So I ask you, Brethren, any ideas for the direction of this program? I've considered putting placings in for each contest, but that would require a sh*tload of data entry for each one, so I'm waffling on that.
Let me know if you have any ideas, questions, etc.
Thanks much,
Bret