nich2pat Posted September 11, 2018 Share Posted September 11, 2018 (edited) Does anybody else keep statistics of their pinball playing? I started doing this a few months ago for the sited ACDC premium pin that is at my work (University of Newcastle) After 100 games with my basic spreadsheet I sent it off to one of the academics who works in the Mathematics and Applied Statistics section of the University who I have been helping out with her course content. I knew there was some cool stuff that could be applied to the data and I got an email back saying this: "I've had a look at your pinball data. You must have mad skillz haha. Pivot tables are for any kind of data summary especially across multiple variables and they make it easy to apply filters etc. as well. So your main sheet where you've got average score and the % of games that you got the different multiballs these can all be done in pivot tables too. In the red tab I had a look at comparing the average score for games where you did or did not get each of the types of multiball. Seems like scores are about 100 million higher on average whenever you get at least one multiball. I'm sure this isn't news to you though! If you click in the pivot table it should come up with the Fields option window to the right and you can see the choices I made for the 'values' and 'columns'. in the blue tab I had a look at whether game order on the day was related to winning Awards. The overall award rate was 10% (I had to create a new variable in the base dataset that simply flags whether or not there was a comment in your original Award column.) Looks like most of the time you play 3 or 4 games on the day, and for some reason the really big outlier scores tended to happen more often on game #1 or game #3 . The scatterplots on that page show the scores over time with the red markers showing games associated with Awards. It looks like the blue markers (normal games) have a steady amount of variance but then there are these outlier games where you get massive scores and Awards. And it does seem as though these outlier games have become more likely over time since the start of the dataset. In the tab for Daily average score you can see the pattern as well. And lastly I had a look at whether you were getting the multiballs more frequently over time. Extra ball seems to be the rarest and worth the most points and the proportion of games per month that you're getting the extra ball has increased over the three months. There's a bit more daily variation though. But you can look at this type of thing for the other types of multiballs too. If you keep recording the data it should be easier to see if any patterns are emerging." This was the original file I sent. Columns for Score, The 3 different multiballs, extra balls, cost, encore (dreaming I know) and any high score awards/song champion etc This one is the updated version Extra Ball Frequency Over Time Daily Average Score Characteristics of a Winning Game Average Score by Multiball Basically it seems like a lot of jargon to me and probably a lot of you too :) Was thinking of putting some other values in like "Number of Songs Played" and "Game Time" What other data would be helpful in tracking progress?PINBALL STATS ACDC_nw.xls.zip Edited September 11, 2018 by nich2pat Link to comment Share on other sites More sharing options...
Nic Noben Posted September 11, 2018 Share Posted September 11, 2018 Haha *mind blown*. I try to keep track of which ball I'm on. Sometimes, I even remember I'm on two warnings ;) - - - Updated - - - On a serious note Pat, I find what I try to remember is how I drained, every ball. Try write that down, the last shot you took and what drained you from which flipper. You'll soon find a pattern between days where you can't seem to get a good score and the usual suspects. Especially on a Ritchie design. Link to comment Share on other sites More sharing options...
capsule Posted September 11, 2018 Share Posted September 11, 2018 I do through Matchplay. Actually, I do it for every single one of you :-) The more you participate in tournaments where scores are recorded (mostly from qualifying) , the more data you'll get. It's a work in progress (notably, I want to add a "compare against another player" feature) but there you go: https://encapsulated.com.au/pinscores/ Also the crawler is only run manually for now, and I need to give it the matchplay ID of the player I want to crawl (it will also crawl the results of all the players that went to the same competitions, but not all their own competitions). This probably needs to be addressed but I'm concerned by the crawling times... Link to comment Share on other sites More sharing options...
Nic Noben Posted September 11, 2018 Share Posted September 11, 2018 I also run a slack bot that derives stats from matchplay events such as this... Handy, to give an idea of the difficulty of getting to finals at recurring events. Link to comment Share on other sites More sharing options...
Andyj965 Posted September 11, 2018 Share Posted September 11, 2018 Try using splunk. It's pretty cool what you can do with data once it's in there. Up to 500mb a day is a free licence Sent from my SM-G930F using Tapatalk Link to comment Share on other sites More sharing options...
timmychap Posted September 11, 2018 Share Posted September 11, 2018 Nice @capsule! Although I note I seem to have some Transformers and Transporter scores mixed together.... And Antar (avatar) scores. An issue with Crawling no? haven't they just pit together an API for games over in the states? To allow standardisation across events and platforms? Think it is being added to Matchplay. Link to comment Share on other sites More sharing options...
capsule Posted September 11, 2018 Share Posted September 11, 2018 Nice @capsule! Although I note I seem to have some Transformers and Transporter scores mixed together.... Yeah, parsing game names is sometimes challenging. Hopefully the new opdb makes things easier. I have to look into this. Sent from my iPhone using Aussie Arcade Link to comment Share on other sites More sharing options...
nich2pat Posted September 11, 2018 Author Share Posted September 11, 2018 Updated with spreadsheet attachment. Cheers @Arcade King Link to comment Share on other sites More sharing options...
bossninja17 Posted September 12, 2018 Share Posted September 12, 2018 Back when pinball was facing a ban in states of the US as it was alleged to be a game of chance, it was proven (by Roger Sharpe) to be a game of skill - and that was EM days. Certainly worthy of scientific study but I play for enjoyment. Sent from my CPH1701 using Aussie Arcade mobile app Link to comment Share on other sites More sharing options...
Malone Posted September 12, 2018 Share Posted September 12, 2018 (edited) I'm not usually that much excited by statistics, but in the first year I played Wildball I did this poster of "statistics" for the season. wildball stats_FIn-.pdf - - - Updated - - - Wow! @capsule Edited September 12, 2018 by Malone added a .jpeg Link to comment Share on other sites More sharing options...
nich2pat Posted September 12, 2018 Author Share Posted September 12, 2018 Back when pinball was facing a ban in states of the US as it was alleged to be a game of chance, it was proven (by Roger Sharpe) to be a game of skill - and that was EM days. Certainly worthy of scientific study but I play for enjoyment. I also play for enjoyment, but I also like to see statistics Link to comment Share on other sites More sharing options...
toads Posted September 12, 2018 Share Posted September 12, 2018 I'm not usually that much excited by statistics, but in the first year I played Wildball I did this poster of "statistics" for the season. [ATTACH]135501[/ATTACH] [ATTACH=CONFIG]135502[/ATTACH] - - - Updated - - - Wow! @capsule Your even recording down what people are eating? Getting a bit personal there. Link to comment Share on other sites More sharing options...
Malone Posted September 12, 2018 Share Posted September 12, 2018 Your even recording down what people are eating? Getting a bit personal there. If you say so, though it's what we all ate at the meets as provided by our hosts. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now