Game Predictions Suggestion - Forms

[PDXBaller]

I would change the IF() formula to point to specific cells to find which game has which winner rather than relying on someone to manually edit the "outlaws" or "otters" sections of it.

Yeah that's a great idea! That way the grader can indicate who won which game in another column and have the TPE earned be based on that result through a vlookup. I'll need to play around with that more since this is a WIP.

[Zoone16]

The fact that one can enter any username though could lead to someone inputting other people's usernames for their teams' benefit and/or to opposition's detriment.


Yes... someone had to be that guy.... it's my job in real life... sorry not sorry.

[PDXBaller]

The fact that one can enter any username though could lead to someone inputting other people's usernames for their teams' benefit and/or to opposition's detriment.


Yes... someone had to be that guy.... it's my job in real life... sorry not sorry.

Yeah I definitely thought about that as well and there's no way for me to verify the user unless we write some API to pass along credentials from jcink (I don't even think that's possible). That's the most glaring hole I can see...someone making predictions for other people or purposely messing up predictions for opposing teams like you mentioned.

[124715]

I like this idea. Only concern is that people will post as somone else. For example me posting as an inactive on my team so they can update or whatever.

I like the autograding though. This would also make it a ton easier for people to write articles on the predictions, as it provides an easy data collection vehicle.

Edit: one suggestion, in the "TPE Earned" column, try pressing the button to lower the # of decimal places shown, so we don't even have to manually round. Just a copy/paste into the Claim Thread.

[PDXBaller]

I like this idea. Only concern is that people will post as somone else. For example me posting as an inactive on my team so they can update or whatever.

I like the autograding though. This would also make it a ton easier for people to write articles on the predictions, as it provides an easy data collection vehicle.

Edit: one suggestion, in the "TPE Earned" column, try pressing the button to lower the # of decimal places shown, so we don't even have to manually round. Just a copy/paste into the Claim Thread.

Done! Now you can easily see how many TPE you earned.

[PDXBaller]

Idea for user verification!

What if we have everyone create a passcode to enter when they submit their predictions? That way we can verify their identity!

On the back end, I can write a formula to cross reference their form response with their passcode to accept or reject their predictions.

[37thchamber]

there's no way for me to verify the user unless we write some API to pass along credentials from jcink (I don't even think that's possible).

in theory it is. sort of.

it comes back to what was said before about automating some of the player updating process. the login details for the forum are in a table somewhere, and there's (theoretically) no reason we couldn't generate API keys and add them to that table (for example), and pass them to other applications we piggyback off this forum's database (like googledocs/forms).

it all comes down to what permissions jcink gives admin when it comes to the forum database, really. on an independent server, im about 90% certain i could write something to do this though.

What if we have everyone create a passcode to enter when they submit their predictions? That way we can verify their identity!

Nothing stopping teammates from getting player passcodes and doing PTs for them that way though

[PDXBaller]

in theory it is. sort of.

it comes back to what was said before about automating some of the player updating process. the login details for the forum are in a table somewhere, and there's (theoretically) no reason we couldn't generate API keys and add them to that table (for example), and pass them to other applications we piggyback off this forum's database (like googledocs/forms).

it all comes down to what permissions jcink gives admin when it comes to the forum database, really. on an independent server, im about 90% certain i could write something to do this though.

That would be awesome if you could get access to that table to see if it's possible. That way we would be able to verify someone's identity.

Nothing stopping teammates from getting player passcodes and doing PTs for them that way though

I don't see anything stopping teammates from giving passwords to each other and logging into their accounts to do it either. I guess the mods can see IPs and track those, but I don't know if the graders are trained to verify each entry is from a unique IP or already identified as a possible duplicate in the Shared IP thread.