WOFTracker: Statistics

I'm pretty sure, it's a bit hard, but...

Yeah, include what's the most expensive PP, and the most cheap PP.

-Number of dud letter calls, average number of those per episode, and also which letter is most associated with a dud

-Number of times a player couldn't solve the puzzle with just 1 missing letter

-Number of times all players have won $10,000 or more in a single episode

Bonus round stats:
-Times when all of their letters are the puzzle, and solve %
-Times when none of their letters are the puzzle, and solve %

I was actually planning on doing season statistics similar to that TPIR site as well. Only I don't have any kind of program like yours and I have no way of recording the show unless Rashad manages to sneak past Sony and upload Season 29 (no pressure against him).

I had already spent a lot of time coming up with a list, a lot of which has been covered by others already (LOL at "canned laughter" statistics, King )

This is what I put down. It's a long list, so bear with me. Apologies for the sloppiness. This was copied and pasted from the Notepad document I wrote them down on as soon as I thought of them:

Male contestants
Female contestants
Shows with 2 male contestants
Shows with 3 male contestants
Shows with 3 female contestants
Shows with teams
Toss Ups
Toss Ups won
Toss Up sweeps
Unsolved Toss Ups
Least % of puzzle revealed when Toss Up is solved
Toss Up "blanks"/missolves
Times first Toss Up did not reflect week's theme
How many times each letter was called
How often each letter was in the puzzle when it was called
How often each letter was called as a dud (and was aired)
The most instances of each letter to appear in a puzzle
How often each letter was called as the first of the round
Repeat calls of letter in puzzle
Repeat calls of letter not in puzzle
Times all vowels in puzzle were bought
Times all vowels in puzzle were bought consecutively
How often each wedge/token was spun by both contestants and Pat
Vowel calls on FP
Consonant calls on FP
Solves on FP
Turn saved by FP
Times prize wedge was picked up (if it's still around)
Times prize wedge was won
Highest prize wedge value
Lowest prize wedge value (will probably be $5000, but still)
Times prize wedge lost to Bankrupt
Times prize was not a trip/cruise
Times WC picked up
Used WC in main game
Used WC in bonus round
Times WC lost to Bankrupt
Times WC survived Bankrupts, but not used
Lowest value WC used on
Times gift tag picked up (if still around)
Times gift won
Times gift lost to Bankrupt
Known times gift was not cash or gift card
Jackpot wins
Highest Jackpot
Highest Jackpot won
Lowest Jackpot
Lowest Jackpot won
Mystery Stays
Mystery Flips
Biggest risk taken on Mystery
Times Bankrupt found
Times $10,000 found
Times $10,000 was known to be under Mystery A (near LAT)
Times $10,000 was known to be under Mystery B (near MDW)
Times $10,000 prize was won
Times $10,000 prize was lost to Bankrupt
Times MDW picked up
Times MDW lost to Bankrupt in same round
Times MDW not carried over into next round (besides Bankrupts)
Times MDW lost to Bankrupt in later round
Times MDW survived main game, but not taken to BR
Million Dollar Bonus Rounds
Red won round
Yellow won round
Blue won round
Red won maingame
Yellow won maingame
Blue won maingame
Gooseeggs
Speed-up comebacks
% episodes PP winner won maingame
Round 4 started with Final Spin
5 Round shows
6 Round shows
Quickest main round Solve (% of puzzle revealed)
Revealed Entire Puzzle
Missolves
Mispronounced Puzzle
Added/Forgot "S"
Most spendable cash Lost to Bankrupt
Most lost overall to Bankrupt, prizes included
Bonus Amount W-L Records
Total amount given away in BRs alone
Most won in Round
Most won in Speed-Up round
Highest Pre-BR winnings (both for single contestant and total among all 3)
Frequency of BR letters called
100K/1M envelope locations
Strongest Spin
Weakest Spin
Most Bankrupt hits in round/show
Most LAT hits in round/show
Highest PP prize
Lowest PP prize
Average PP prize value
PP trip was outside North America (now a rarity these days)
Highest car won (not counting 5k)
Lowest car won (not counting 5k)
Total value given away from non-guranteed prizes alone
Lowest maingame/final total of player
Lowest Pre-BR total among all 3 players
Lowest total show winnings
Highest total show winnings
Average total show winnings
BR W-L
Shortest BR puzzle
Longest BR puzzle
BR puzzle with most free letters (perecentage-wise)
Contestant calls all duds
Contestant fills in BR puzzle
Least amount of turns by contestant
BR category occurences/frequencies
Contestant fills in "I'M" "AND" "-ING" "THE," etc. intentionally (+ who won anyway)
Most lost to Bankrupts whole show
Most money not won in round
Edited Final Spins
Most big money hits in round
Most times same wedge was hit consecutively
Back-to-back Bankrupts
No money lost to bankrupt for whole show
Bankrupt not hit at all in entire show
PP Category frequency
First spin of round is penalty wedge
Bonus Trivia Categories + W-L record
Post-buzzer BR solves
Most missolves in round
Missolve (not counting BR) did not fit/used already-used letters
1/2 car picked up
1 1/2 car plate won
1/2 car won
Highest 1/2 car value
Lowest 1/2 car value
Obvious overhead spin edits
Most money earned in 1 spin/letter
Contestant asks for vowel on non-FP spin
BR player did not have family/friends in audience
Audience giveaways
Solved puzzle with one letter
Hgihest cash total (not prizes) given away per show
Lowest cash per show
Contestant finished show with all-cash total
Highest all-cash winnings
Perfect BR weeks
BR shutout weeks
Most given away in BRs in one week
Season total winnings
Largest second place total
Maingame sweeps
Largest third place total
Buzzed out
Wheel misplacements
Things/People puzzle did not contain "S"
WAYD puzzle did not contain "-ING"
shortest maingame puzzle
longest maingame puzzle
Did not start WAYD puzzle with N, G, or I
Category frequency (all puzzles)
2+ consecutive puzzles had same category
Total # Episodes
Episodes on location
Total money (throughout season) earned from Wild Card
Lowest winner
Highest winner
Smallest gap between final totals (pre-BR)
Longest Winning Streak (podium)
Longest Solving Streak (podium)
Longest BR win streak
Perfect rounds
Solved puzzle with less than half of puzzle revealed
Total amount throughout season not given away (money accumulated in a round by contestants who didn't solve the puzzle)
Times contestant solved for house minimum
Most instances of letter left not revealed
Most multiples left unrevealed in single puzzle
PP is R2
PP is R3
How many times each wedge on the Bonus Wheel was landed on
Most aired letter calls in single round
Least aired letter calls in single round
Total appearances of each letter in maingame puzzles (not counting Toss Ups)
Total appearances of each letter in BR puzzles
Total puzzles used per season
Total lost to Bankrupts throughout season
Total value of BR prizes lost throughout season
Longest BR prize streak (ex: 6 eps in a row where 30K was the prize)

OK everyone - the set of objects to store a single game's statistics is solidly done other than 1/2 car (I'm going to test with S27/8 episodes for now, and am hoping for a strong taping report / press release down the line, as it will take awhile to adjust for 1/2 car).

Here is the index / small documentation of the objects I'm using with their variable names. Some jargon and not very professional or anything, but I think you guys can see what I'm taking down well here:

• calledByPlayer, calledByRound – What letters are called per player (to see the average player's calling tendencies over a game, this is just for maingame), per round (so per round, max is 1), also including BR.
• calledFreqs – How much of calledByRound are in puzzle by round
• repeatedLetters – what letters and how often a letter is repeated per round
• firstLetter – on a blank maingame puzzle, interesting to see what is called
• spinLocations – Frequencies of hit wedges by round. Special one for Pat
• spinStrengths – per player. Also special one for Pat
• puzzleDissections – how many letters in each puzzle for EVERY round in game
• mainBuzzes –by round
• tossUpBlanks –by round (this is taking too long to answer)
• prizeResults – what happens to each cardboard, with custom enum, including the Mystery wedges (including "Was bankrupt" for a failed mystery wedge).
• winnings – per all rounds, so total winnings and average is an easy calculation.
• lostBanks, lachTrash – self-explanatory, per round and per player. I actually learned just recently "lach trash" is a J! term… but I've been mentally using it for bankrupts for awhile… lol
• missolves – self-explanatory, per round.
• catRound – listed by round, what categories are each round. Seeing what rounds categories show up in is interesting, but is better suited for the multi-game analysis.
• bigMoneyFreq, wasteFreq – only frequency of letter is important here, not the actual letter. Waste is for $0 spaces – cardboard.
• puzzleDetails – length, unfilled-filled ratio, vowel-consonant ratio, # of lines
• finalSpinFreq – Vowels excluded so total $ earned in final spin time can be calculated from Pat’s spin
• finalSpinLocation, finalSpinStrength – keeping track of Pat.
• freePlayActions, savedTurns – consonant called, vowel called, solve attempt, buzzed out while deciding (yes, this actually happened once). If repeat or dud or missolve, the fact a turn was saved by Free Play is recorded (buzzed is automatic save) in savedTurns.
• roundWinners – for each round, who wins it ("null", i.e. none, for triple stumpers and BR failures). Can correlate winners of certain rounds (T2, PP, toss-ups in general) to winning the game (which is stored in BR entry even if round isn’t won).
• thisWCUse – for maingame uses, self-explanatory. might expand to 4th letter for BRs, but it's hard to say the 4th letter is the WC letter sometimes, so that would make this data inconclusive. Still might though
• jackpotAmount, wasJackpotWon – self-explanatory
• bonusWedge, bonusAmount – self-explanatory
• riskedMoney, timesNotRisked, riskedCardboard – all data on Mystery landings can be derived from these.
• allVowelsBought, allConsonantsCalled – maingame only. This is a count of these occurences in the maingame, not separated by round (do you really want to know how many times all vowels were bought in R3 compared to R2? No.)
• lostTurns – sums up all duds, black & white hits, and buzzouts of a round. Best to store this lengthy calculation (duds requires a O(n) search). Maingame only.
• leftRightMDWHits – I needed this to make lostTurns functional. By round, I might add left/right separation for the heck of it but unlikely.
• perfectRounds – if lostTurns for a round is 0, the maingame round is added to the set of perfect rounds (comparison of perfect rounds in R1 compared to R2 for example, or perfect prize puzzle rounds, is interesting). A speed-up round is considered perfect if no speed-up buzzes occur along with usual R1-3 conditions, but the focus is on R1-3.
• pWheelAmount, ppAmount, carAmount – prize amounts.
• pp – this is useful storage, the Round the pp occurs in.
• third, second, winner, winningMargin – takes a sorted list of the final getTotalScores to work to get it done, but with a static size of 3 this isn't a problem. winner is used to check interesting potential correlations, such as…
• ppIsWinner, didPPMatter – easy with roundWinners and winningMargin
• gooseEggs – easy with roundWinners. if it's 2, there was a clean sweep.
• tossUpSweep – easy with roundWinners.
• highestMultLetters, highestMultFreq – for maingame, the frequency of the highest multiple left "on the board" and the letter(s) with that frequency
• females, males – the number of males/females. Couples supported.

I took into consideration what I had before with the lists above. Multi-game analysis will more include maximums, minimums, maybe streaks, and more (and this part I can afford to work on as Season 29 begins... I need the single game analysis polished now).

I'm trying to find out what letters are called in order from most frequent to least frequent. I created a thread last night, but I was referred to this thread.

Likely final list:

• calledByPlayer, calledByRound – What letters are called per player (to see the average player's calling tendencies over a game, this is just for maingame), per round (so per round, max is 1), also including BR for round.
• calledFreqs – How much of calledByRound are in puzzle by round
• repeatedLetters – what letters and how often a letter is repeated per round
• spinLocations – Frequencies of hit wedges by round. Special one for Pat
• spinStrengths, spinStrengthStats – per player. Also special one for Pat. Second summarizes the entire list in the first with OneVarStats
• puzzleDissections – how many letters in each puzzle for EVERY round in game
• mainBuzzes –by round
• tossUpBlanks –by round (this is taking too long to answer)
• prizeResults – what happens to each cardboard, with custom enum, including the Mystery wedges (including "Was bankrupt" for a failed mystery wedge) and 1/2 car wedges (completion, the two pieces that make up the winning car, and abandonment, when one claimed half is useless post-R3 or another person completes the car).
• winnings – per all rounds, so total winnings and average is an easy calculation.
• lostBanks, lachTrash – self-explanatory, per round and per player. I actually learned just recently "lach trash" is a J! term… but I've been mentally using it for bankrupts for awhile… lol
• missolves – self-explanatory, per round.
• roundCat – listed by round, what categories are each round. Seeing what rounds categories show up in is interesting, but is better suited for the multi-game analysis.
• bigMoneyFreq, wasteFreq – only frequency of letter is important here, not the actual letter. Waste is for $0 spaces – cardboard.
• puzzleDetails – length, unfilled-filled ratio, vowel-consonant ratio, # of lines
• rstlneGiven – a OneVarStats on this would be interesting ("given ratio" doesn't have much meaning on intentionally small puzzles like BR)
• finalSpinLocation, finalSpinStrength – keeping track of Pat.
• freePlayActions, savedTurns – consonant called, vowel called, solve attempt, buzzed out while deciding (yes, this actually happened once). If repeat or dud or missolve, the fact a turn was saved by Free Play is recorded (buzzed is automatic save) in savedTurns.
• roundWinners – for each round, who wins it ("null", i.e. none, for triple stumpers and BR failures). Can correlate winners of certain rounds (T2, PP, toss-ups in general) to winning the game (which is stored in BR entry even if round isn’t won).
• thisWCUse – for maingame uses, self-explanatory. might expand to 4th letter for BRs, but it's hard to say the 4th letter is the WC letter sometimes, so that would make this data inconclusive. Still might though
• jackpotAmount, wasJackpotWon – self-explanatory
• bonusWedge, bonusAmount – self-explanatory
• riskedMoney, timesNotRisked, riskedCardboard – all data on Mystery landings can be derived from these.
• allVowelsBought, allConsonantsCalled – maingame only. This is a count of these occurences in the maingame, not separated by round (do you really want to know how many times all vowels were bought in R3 compared to R2? No.)
• lostTurns – sums up all duds, black & white hits, and buzzouts of a round. Best to store this lengthy calculation (duds requires a O(n) search). Maingame only.
• leftRightMDWHits – I needed this to make lostTurns functional. By round, I might add left/right separation for the heck of it but unlikely.
• perfectRounds – if lostTurns for a round is 0, the maingame round is added to the set of perfect rounds (comparison of perfect rounds in R1 compared to R2 for example, or perfect prize puzzle rounds, is interesting). A speed-up round is considered perfect if no speed-up buzzes occur along with usual R1-3 conditions, but the focus is on R1-3.
• pWheelAmount, ppAmount, brCarAmount. halfCarAmount – prize amounts.
• pp – this is useful storage, the Round the pp occurs in.
• third, second, winner, winningMargin, secondaryMargin – takes a sorted list of the final getTotalScores to work to get it done, but with a static size of 3 this isn't a problem. winner is used to check interesting potential correlations, such as…
• amountOverMinimum – a measure of "efficiency" along with highestMultLetters
• finalMainWinnings – by player instead of by round.
• ppIsWinner, didPPMatter, speedUpComeback – easy with roundWinners, third/second/winner and winningMargin
• gooseEggs – easy with roundWinners. if it's 2, there was a clean sweep.
• tossUpSweep – easy with roundWinners.
• highestMultLetters – for maingame, the frequency of the highest multiple left "on the board" and the consonant(s) with that frequency (custom object as value)
• triviaBonus – which trivia category it was and its successfulness.
• females, males – the number of males/females. Couples supported.

When I click "All Reports" it says "Page Not Found"...

I still get the same message...