PDA

View Full Version : Score tracking and averages Excel sheet


Balls Casten
10-27-2010, 11:00 AM
Ok, too much time in the hotel room again and had to keep occupied.

Put together a spreadsheet (excel) to track and compare our contests scores. Just enter info into yellow cells.
Feel free to copy or use as you wish.

http://smokerspurgatory.com/spscoretracking.xls (http://smokerspurgatory.com/spscoretracking.xls)

Also open to any change suggestions.

(any data base or programmer guys know how we could make this a program so that you could view only the info you wanted?)

BBQ_Mayor
10-27-2010, 12:38 PM
Looks a lot like what I had made up. Don't have it with me at the moment but I'll post when I get a chance.

As far as a program, you have it pretty much ready in Excel. Few tweaks and your set.

pat
10-27-2010, 02:42 PM
Damn Doug doesn't the hotel have a bar?

Buster Dog BBQ
10-27-2010, 02:46 PM
This brings up an interesting questions. What's more important...score or place? I personally think place.

Balls Casten
10-27-2010, 04:41 PM
Looks a lot like what I had made up. Don't have it with me at the moment but I'll post when I get a chance.

As far as a program, you have it pretty much ready in Excel. Few tweaks and your set.

I'd like to see it Ray. PM me if you have any input regarding makeing it a progam/data base.

Balls Casten
10-27-2010, 04:45 PM
Damn Doug doesn't the hotel have a bar?

I've been trying to cut the cord on that place. $9 drinks add up quick the way I pour them down.

Scores or wins? Im going with scores, get the scores and the wins will take care of them selves. But I'd take at least one win. :-D

Bob=O
10-27-2010, 06:01 PM
This is a good history on overall preformance by you, but it doesn't tell you how you turned in your entry, glazed ribs with what, chicken cooked with what?, brisket cooked to what temp at turnin, wood, weather, huminity, How many beers, start times, turn-in times, too many variables left out, so that 6 months from now you have a idea what you did. Wil you actually use the info at a later date and how many do.

Buster Dog BBQ
10-27-2010, 08:17 PM
I've been trying to cut the cord on that place. $9 drinks add up quick the way I pour them down.

Scores or wins? Im going with scores, get the scores and the wins will take care of them selves. But I'd take at least one win. :-D
I think placement tells you a better picture on your progress then scores. I have had many of contest where my score would have been 1st in a different contest.

Balls Casten
10-27-2010, 08:31 PM
And our best rib score of the year didnt place.
We may be in a differnt boat than you too. Your average scores may be as high as they are going to get, or as high as one could expect. Us .. we are still getting some 140's & 150's, so we have room to improve.

Buster Dog BBQ
10-27-2010, 08:41 PM
And our best rib score of the year didnt place.
We may be in a differnt boat than you too. Your average scores may be as high as they are going to get, or as high as one could expect. Us .. we are still getting some 140's & 150's, so we have room to improve.
Good point.

5-0 BBQ
10-28-2010, 02:52 AM
Looks cool I am going to give it a try. Thanks!

Spydermike72
10-28-2010, 07:19 PM
I actually went a little further and made charts based on our scores... Let me get a clean one and I will post it.

Divemaster
10-29-2010, 09:37 AM
We actually take it a step further where we compare our scores to those of the GC. We've all been at contests where our placing was say 6th overall but would have taken the GC at another contest. It's that ratio that tells us if we are really improving.

2Fat
10-29-2010, 10:46 AM
guess I don't worry too much after the contest is over what the scores were--either the judges liked the product or not---probably going to turn in a similar meat the next week anyway--cook the meat well consistently and the scores will fall right in line--imo anyway

best place for last weeks scores are in next weeks chimney

Spydermike72
10-29-2010, 11:30 AM
I actually went a little further and made charts based on our scores... Let me get a clean one and I will post it.

Ok, here it is. It is pretty much self explanatory, On the Scoresheets enter your scores from the Comps that you cook for both the Overall and the individual categories. Once you do that the graphs will populate on the sheets that say Chicken,Overall etc...

I think it gives you a good way to track your team over a period of time.

As every manager knows, you can only manage what you measure... :becky:

Rich Parker
10-29-2010, 11:41 AM
Ok, here it is. It is pretty much self explanatory, On the Scoresheets enter your scores from the Comps that you cook for both the Overall and the individual categories. Once you do that the graphs will populate on the sheets that say Chicken,Overall etc...

I think it gives you a good way to track your team over a period of time.

As every manager knows, you can only manage what you measure... :becky:

Does this mean Scott and Bruce are going to be looking for a new team next season?

Divemaster
10-29-2010, 01:10 PM
Does this mean Scott and Bruce are going to be looking for a new team next season?
Ouch....