G38 spreadsheet

[huntz71]

Not sure if this is effecting anyone else when they download the spreadsheet, but G38 is not pulling the data from G11 properly.

It shows as an error, see example below.  It shows the same error in all 7 leagues that I am in.  

When entering in a new name into G11, the data doesn't register in G38.

Not a big issue, just throwing it out there!

 

Edited May 24, 2024 by huntz71

[James]

Are you mistaking the formula for an error message? Everything looks ok to me…

[huntz71]

When entering a different player in G11, that data doesn’t transfer to G38.

The formula should be =(G11)?

 

 

 

[orphans]

My WCFL line 38  shows a no named 124 year old player who has played 65 games last spread sheet he was making .950k and I was over the cap. Now his cap hit is 0 😊

[James]

12 hours ago, huntz71 said:

When entering a different player in G11, that data doesn’t transfer to G38.

The formula should be =(G11)?

 

 

 

If the formula in G38 was =G11, then G38 would show exactly what is in G11. Which would mean Demko’s GP would show up as “Thatcher Demko” instead of 219. 

[James]

So the way it actually works...  

 

The formula in cell A37 is =(G9), which transposes the name you have in G9 down into A37.  Cells D37 through R37 then lookup the contents of A37 in our database, and return some piece of information (team, position, age, AAV, etc).  

 

Row 38 is different from the others because of our roster flexibility (6D/3G vs. 7D/2G).  So A38 will bring down the name from G11 unless G11 is "GOALTENDER" (which indicates that you're carrying 7 D).  In that case, it would bring down the name from G10.  But the rest of Row 38 works just like the other rows... it looks up the contents of Column A and returns info about it.

[huntz71]

That makes sense.

 

when I download the page so I can play around with some player changes and  I enter in a new player, it does not change anything in line 38, no name or salary.  It’s the only line that does this.

If you are not seeing it, then I will concede and say it’s only when downloading it occurs.

Not a big deal, just thought it was strange it was happening.

 

 

[James]

Are you downloading it and then opening with Excel? Or just saving to your Google Drive and opening from there?

[huntz71]

I usually download and open with Excel.

I just tried it again using both methods and it doesn't change the data on line 38.

So it must be because of the roster flexibility.

 

I don't think its a big enough deal to worry about, unless its a quick fix.