Create Account

Small issue with Player Analyze
#1

Hello, I don't know who to report this to, so I'll just leave it here.

Player Analyze sheet (https://docs.google.com/spreadsheets/d/1...2134427858), the SHL sheet, is capped at 600 rows.

we currently have 600+ players

The consequence of this is sheets that rely on Player Analyze, like the Ratings Transfer sheet (https://docs.google.com/spreadsheets/d/1...=485699230), namely Columns I through N which offer an easy importable range for other spreadsheets to use, has players left off. Players like Zoltan Topalo, who is alphabetically beyond the 600 player limit in the player analyze. Zoltan is correctly in the other columns, sorted by teams, but in my experience these columns are less reliable (for whatever reason) to import for internal data tracking in our sheets, so we've been using Columns I through N which are simply sorted by alphabetically.

I'm not sure how that tab is populated, but if its not too much trouble you may want to expand it as our league expands.

near as I can tell, the SHL Budget 2.0 imports things differently and doesn't seem to have any issue, but from what i've been told the Database tab imports from the Ratings Transfer sheet so you may want to get that checked out soon.

[Image: premierbromanov.gif]




Fuck the penaltys
ARGARGARHARG
[Image: EePsAwN.png][Image: sXDU6JX.png][Image: eaex9S1.png]
Reply
#2

Looks the sheet has been updated, although I think a function like " ={db!N2:N} " on the SHL sheet should help so that it doesn't have to be updated manually

[Image: Dextaria.gif]


[Image: Niz2wua.png]  [Image: iB9r7kM.png]  [Image: 6by0kBi.png]
Thanks to @DELIRIVM, @Moreorless89 and @ValorX77 for the sigs!
Reply
#3

11-04-2020, 05:29 PMDextaria Wrote: Looks the sheet has been updated, although I think a function like " ={db!N2:N} "  on the SHL sheet should help so that it doesn't have to be updated manually
it was updated, now those pesky 3 extra players show up

[Image: premierbromanov.gif]




Fuck the penaltys
ARGARGARHARG
[Image: EePsAwN.png][Image: sXDU6JX.png][Image: eaex9S1.png]
Reply




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.