Create Account

I think we have too many PTs
#19
(This post was last modified: 08-08-2022, 03:45 PM by leviadan. Edited 1 time in total.)

08-08-2022, 03:38 PMKeven Wrote:
08-08-2022, 10:56 AMleviadan Wrote: I will say that we have had discussions about doing combined claims-- it was posted in the PT suggestion thread a while back. The idea being every Wednesday or something I'd post a combined claim for whatever we have graded. So one claim a week with 4-15 TPE depending on what's been graded.

I really like the idea, but to be honest the main barrier is my technical knowledge. I don't know the first thing about spreadsheets, and finding a simple and fast way to aggregate all the grades is just completely beyond me. If people have ideas or solutions that are easy to understand I'm more than happy to hear them. It's something I'd love to implement but I just don't even know where to start.

I'm not 100% sure how all the separate grading systems work for PTs vs primetimes vs predictions etc. but I can provide an initial idea based on a max earners article I assembled a while ago. Aggregating TPE by name shouldn't be too difficult as long as there's a bit of consistency with how the data is pasted in.

This spreadsheet shows proof of concept: https://docs.google.com/spreadsheets/d/1...sp=sharing

As soon as something has been graded, the list of users and TPE earned can be pasted into sheet2 instead of immediately as a claim on the site. Then once per week the results can be copied from sheet1 as one big claim. Once the claim has been posted on the site, the data from sheet2 can be cleared and/or archived in case it needs to change and a new week can begin. This would work great assuming two conditions are met:
1. Names are always spelt correctly.
2. The delimiter between names and TPE claimable is consistent and the number of TPE earned is listed beside every name with no additional text.

Neither of these conditions were met when I worked with the S61 data and the majority of the work I had to do came from cleaning the data and fixing those issues. I imagine this could be a very quick and viable system as long as everyone posting a claim is aware of those things. Once again, I don't know what the process looks like so if this isn't viable then that's fine too.

I actually had someone DM me as soon as I posted this and they essentially got it built over lunch. It works pretty much exactly the way you say it does, and our names are always right because we scrape them via a bot. This is all to say that thanks to people much smarter than me, and pending some further working out of the details, a combined weekly claim is certainly likely in the near future.

[Image: pin1_1.gif?ex=663a63f4&is=66391274&hm=70...8f89c3f46&]
Reply


Messages In This Thread
RE: I think we have too many PTs - by Merica - 08-08-2022, 09:52 AM
RE: I think we have too many PTs - by Merica - 08-08-2022, 11:01 PM
RE: I think we have too many PTs - by Chevy - 08-08-2022, 09:54 AM
RE: I think we have too many PTs - by leviadan - 08-08-2022, 09:58 AM
RE: I think we have too many PTs - by luke - 08-08-2022, 10:19 AM
RE: I think we have too many PTs - by WannabeFinn - 08-08-2022, 10:36 AM
RE: I think we have too many PTs - by RAmenAmen - 08-08-2022, 10:51 AM
RE: I think we have too many PTs - by leviadan - 08-08-2022, 10:56 AM
RE: I think we have too many PTs - by Keven - 08-08-2022, 03:38 PM
RE: I think we have too many PTs - by leviadan - 08-08-2022, 03:42 PM
RE: I think we have too many PTs - by Keven - 08-08-2022, 03:57 PM
RE: I think we have too many PTs - by leviadan - 08-08-2022, 04:07 PM
RE: I think we have too many PTs - by Ragnar - 08-08-2022, 11:02 AM
RE: I think we have too many PTs - by NJBadApple - 08-08-2022, 11:44 AM
RE: I think we have too many PTs - by Evok - 08-08-2022, 03:18 PM
RE: I think we have too many PTs - by Evok - 08-08-2022, 03:18 PM
RE: I think we have too many PTs - by marco999 - 08-08-2022, 04:09 PM
RE: I think we have too many PTs - by RashfordU - 08-08-2022, 05:42 PM
RE: I think we have too many PTs - by jumpSeat - 08-09-2022, 02:15 AM
RE: I think we have too many PTs - by brickwall35 - 08-09-2022, 09:57 AM
RE: I think we have too many PTs - by Anthique - 08-11-2022, 11:44 AM



Users browsing this thread:
1 Guest(s)




Navigation

 

Extra Menu

 

About us

The Simulation Hockey League is a free online forums based sim league where you create your own fantasy hockey player. Join today and create your player, become a GM, get drafted, sign contracts, make trades and compete against hundreds of players from around the world.