Hey Lynkfox...could you post a link to the form that lets you check your stats on the first post of the thread? as this gets longer its going to be harder to find your post
i cant actually do so, as the first post of this thread is not mine :P
However, i added it to the Sticky on the General Forums already.
and ive updated the Tracker (link in my sig) to have a link to the raw statistics doc as well
Alternatively, if you sign into google, and visit the page, then go to drive.google.com it will be linked there too.
Russ (Rabit) and I are considering building a form (in something like MS Access) that could be used to collect game stats when the Internet is not easily available.
Can anyone provide a data dictionary for the game stats -- something that describes, for each collected value, what the valid values are? I am assuming that instead of, for instance, the name of each hero, a number is substituted when collected results.
Also, were we to collect such stats, what would be the easiest format to provide them in and who should we email them to (or otherwise get a file) to? Would a comma separated value (CSV) file work well?
AND, if anyone wants to build this for us, please do let us know. Ideally, we'd like to have something that we could try out as early as when Christopher is doing game days in Indiana starting Wed, Apr 17th.
https://docs.google.com/spreadsheet/ccc?key=0AqClP82b_XgZdFVreEhkOWJYcmlvcDNMbWppejh5aGc#gid=0
Thats the raw data. If you have it print out in an Excell format in that exact manner, you can email me the excel file and ill just copy and paste it into the data there, all in one big block. And it will automatically be added to the stats, for calculation into next months report.
Only one little thing - its Tempest; Freedom (with a semi colon - its a mistake in the form and i just never fixed it cause it be a pain in my butt to adjust all the formulas now :P)
if you just copy paste from whats available so that it provides the exact same values, it will work properly.
http://boardgamegeek.com/thread/958015/environment-dificulty
The above thread at BGG made it realized that this statistics project hasn't been introduced at BGG (or had it?). Maybe we could post a thread there to collect more data? Or even add the link under "More Information"? Would that be appropriate?
I submitted a thread to bgg but I don’t think it ever got posted. If someone wants to do so again feel free to!
When I first heard about the stats project, the thought struck me that putting everything into Access would make automating stats much easier, though I'm not sure how licensing and stuff works, and I don't think OpenOffice has a bona fide database product like Access. If I subscribe to Office 365, I may grab a local copy of Lynkfox's stats sheet and drop it into Access to play around.
Please feel free to! People say ‘lynkfoxs’ project but it is a community project. I just am the curator, and I just used what was easily available and free. If someone has access to something more powerful or reliable then by all means… This is why I started the Dropbox with the files to dl
I've created a new thread in BGG. http://boardgamegeek.com/thread/960297/the-best-heroes-a-statistical-community-effort
Hopefully this will bring more data to the project and reach that threshold for unbiased stats.
As a side note, will you help to thumb that thread on BGG so that it's more visible to new visitors there?
Thanks!
I think this project might be better served as a web application. The idea of using a spreadsheet and a survey which automatically appends data to the spreadsheet is great for quickly getting an implementation set up without having to do the extra planning and development, but it appears that it's not flexible (such as inability to bulk import entries without manual involvement), and not very scalable (the fact it takes longer to post as the data gets larger seems to imply that the survey form locks the spreadsheet, downloads the entire spreadsheet, makes it's modifications, uploads the modified spreadsheet, then unlocks the spreadsheet, which would make it take longer and longer the larger the spreadsheet gets). Also, with a web application, many things which are manual now can be automatic and on demand (such as monthly reports, weekly reports, yearly reports, per hero reports, per villain reports, etc), and things which require people modifying the actual spreadsheet (such as looking up usernames) can be done without making such modifications. Also, creating services would also allow other programs more "direct" access to the data to allow things such as offline data collection with bulk posting and offline synchronization of data.
I would love to develop such a web application, and, in fact, have already done some planning in my head. I do not, however, have any current web hosting, and do not have the budget to purchase such web hosting. If someone who already has some website presence is willing to donate a directory or subdomain, that would be great. I prefer an ASP.NET + EF + SQL Server setup, but I'm not averse to something like PHP (though I haven't done any PHP work in some time) and any relational database system. I would also likely put all development files as a GitHub project so that others might help out. I would definately be looking for some designers to help with style and layout with CSS, as making websites look good isn't really a strong point of mine.
Well, there are two things that you have a bit wrong, Jay Man
1) I only lock the spreadsheet while I do the manual entry because that way i wont have some stats with 5000 games, some stats with 5001 games, some with 5002 games... ect you get? Now you might be right on how the Form itself works - i think its actually taking so long because i have a -ton- of calculations built into that document, which have to update everytime someone enters data - this is because of the manual entering ive been doing, but with #2 below, i can get rid of most of those. Even turned off, 150 calculations each taking half a second to go 'Nope! im off!' adds up, you know? but far faster than it having to update each actual caclcuation (most of whichi look across the entire /sheet/
2) Im working righte now on making it almost entirely automated in Excel - in that i just download the spreadsheet (takes about 20 seconds) open it up in proper excel not GDocs, wait for the calculations to update (Which it would much faster, cause there is no limit on Excel as there is online in Gdocs) and then upload the new Tracker. Take me probably 10 mins every month (or week!) once I get it all set up.
3) I am -alllllll for it-, however, the web application. As long as I still have control over the data and such, being the project curator. Its kinda my baby and I dont just want to give it up, ya know? :P But I too have no ability to host, or pay for a host. A kiddo really takes a chunk outta the paycheck.
oh, also the nice thing about the gdocs is that if I dissapear, then someone else can take it over with relative ease. If you're the sole developer on a web app, then unless we have another coder willing to volunteer their time, any problems or requests for new calculations/data entry ect would be on hold until such was found. To me thats not a big enough reason /not/ to go forward with a webapp deal, but im just puttin git out there :P
4/28/2013 6:27:28
I evidently played a game in which we won the game due to Hero Incapacitation. (Should be a loss. 
)
I collapsed into bed early last night, and have a long day at work today. But I hope to get the report updated tonight!
Woohoo, I'm excited! I played / entered kind of a ridiculous number of games last month . . .
I'm sorry guys. I didnt end up getting off work utnil id done a 14 hour day, and i have to be back at work at 6am tomorrow. My weekend is booked /full/ as well. Ill try to get to this saturday or sunday night, but no gaurantees. At the latest ill have it up by Monday night.
Sorry for the delay, but its the end of the school year, and there is a ton of extra work going on right now!
Looks like the update was done. Thank you for the hard work. It looks like the individual hero/villain stats were removed. Was this intentional? I liked being able to delve into each villain to see the delta between regular and advanced modes and other nitty gritty details.
There is a post below.
Yes, it was intentional - That takes up a huuuuge chunk of time, and i was seeing if people really used it. Ive decided a better way is to modify the 'look up your own stats' pageon the raw data to include and work with looking up a hero or a villian. So the data that most people want - How hard a villain or environment is, how effective overall a hero is, is all there, easy to find in comparison, and after a couple days ill have the look up a hero thing done so you can look up individual stats for heroes, villians, probably even environments, with up to date right then and there info!
Please change the XChylde17 entry from 3/10/13 to just "XChylde".
Look at how much of a difference there is between the most difficult and the second most difficult environments: 14%! Just more evidence (like we really needed it) that Rook City is an awful, awful place. I'm one for four in that hellhole.
I'm reasonably confident that Spite only having fought 11 games is a typo... especially given that he has 91 wins two columns over.