Sentinels Statistics Project

Thanks

Hmm... Something seems to be up with the stats project. The games I've logged after 2/12/18 aren't showing up. I clicked on a few other names in the contributers tab and didn't see any with games from after 2/12.

For a second I thought I had been banned from the project but now I see other contributers are not able to addi games afters 2/12. Does anyone know if the project is done updating?

Just checked the back-end spreadsheet, and yeah, after 2/12 there are no more entries. lynkfox will have to look into it.

Thanks for setting up that model and the auto updating. I really enjoy seeing the coefficients. Would it be a pain to merge the challenge mode for Agent of gloom spite and for skinwalker gloomy. Right now I am pretty sure that people are more likely to enter games as agent of gloom spite if they lose and skinwalker gloom if they win. The games are actually identical but I don't expect the coeficients to merge because it is sort of odd to enter the game as skin walker gloom if you never even got to that phase of the game and it is odd to enter the game as agent spite if it was hours ago that you defeated him and moved on to gloom. Like I said though, I really appreciate the work that has been put in.

i'm... stumped. I think it has to do with the new forms. its still getting responses (you can see them in the Individual section on the /form/ from the editors side - last active response beside my Tests is from 2/18 by abnelson ) but none of them are showing up on the spreadsheet.

 

i'll keep looking at it.

Doesn’t Google have a maximum size for their spreadsheets?

Oh. May need a new form address: https://goo.gl/forms/cQccMUcaXlqBumME3

 

(welll, the old link still works, thats just a shorter one)

Not since the new update, a few years ago. (we definitely ran into that issue at about 10k entries)

 

Its been accepting allt he data, but it hasn't been getting into the sheets. Anything from the last week is in there, but not in the sheet it seems. Going over it with MindWanderer now to see what I need to do or help in order to get the script working properly.

That link and the old one go to exactly the same place when fully resolved.

I don't think there's anything I can do if the data doesn't go into the sheet somehow.

Okay. It seems to be accepting new entries again. Seems I say, but its hard to tell.

 

Any entry entered between 2/12/18 after 11pm est and 2/18/18 about 2pmest  insn't going to be in the site Mindwanderer puts up. They are in the system, but not in the spreedsheet. I don't think that we'll get them either. No idea what happened. I'll keep an eye on it and see.

 

If anyone else sees something like that, just send me a pm so I can jump on it as early as posisble.

Seems like there may be an issue with new entries again.

Wanted to note that there still seems to be a problem where new entries aren't being recorded.

Hey all.

 

My daughter was born in Jan, so it has been a couple of very hectic months for me. I poked around, and the entries were all there - just the Google Form wasn't sending them into the Sheet for Mindwarnder to parse into his webpage.

 

Seems to be resolved for the moment (May even have got the missing stuff from the last time this happened, hah!)

 

 

I'm looking into learning SQL now to move us to something more permenant and better able to handle this number of responses. We are well into the 50k response range I believe, and its getting more and more clear we're running up against the limits of googlesheets. 

 

So if anyone out there is an SQL/Access/some other database admin who wants to donate some freetime to setting something up, let me know xD

As it happens, I can do SQL, too.  Not an expert, but I can get by.  I could just code up a whole new form and host it myself, if that's the direction you're going.  The advantage of GDocs is that it's easy to share and collaborate.  I don't know if it's possible or advisable to host any of this stuff on the wiki server, so it's not all just on me.

Congratulations lynkfox.

Data will be wonky today due to very old data being magically restored somehow.  This includes some of the old data format options.  I think I corrected them all but the website will take time to process the update and I won't be able to double-check the results until tomorrow.

Edit: It looks good to me now.  Please let me know if you see anything wonky.

I’m not seeing anything weird… data looks fine.

 

The wiki server could very well host it, i think. Wiki uses sql databases, and its just a normal webserver. public_html directory and everything. We could probably make that work without to much issue. 

 

Not that I know how to install a database onto a server without something like the mediawiki install wrapper but… xD

 

No hurry. what we've done should fix it for a couple more years, lol. We'll see what happens.

The system does appear to accepting new entries. It however appears that previously logged entries between 2/18/18 and 4/26/18 are now no longer logged. I know that in April they were there but presumably one of the fixes created a small bug that meant that data did not get included. Thank you for everything!