huntz71 Posted May 24 Report Share Posted May 24 (edited) 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 by huntz71 Quote Link to comment Share on other sites More sharing options...
James Posted May 25 Report Share Posted May 25 Are you mistaking the formula for an error message? Everything looks ok to me… Quote Link to comment Share on other sites More sharing options...
huntz71 Posted May 25 Author Report Share Posted May 25 When entering a different player in G11, that data doesn’t transfer to G38. The formula should be =(G11)? Quote Link to comment Share on other sites More sharing options...
orphans Posted May 25 Report Share Posted May 25 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 😊 Quote Link to comment Share on other sites More sharing options...
James Posted May 25 Report Share Posted May 25 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. Quote Link to comment Share on other sites More sharing options...
James Posted May 25 Report Share Posted May 25 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. Quote Link to comment Share on other sites More sharing options...
huntz71 Posted May 25 Author Report Share Posted May 25 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. Quote Link to comment Share on other sites More sharing options...
James Posted May 25 Report Share Posted May 25 Are you downloading it and then opening with Excel? Or just saving to your Google Drive and opening from there? Quote Link to comment Share on other sites More sharing options...
huntz71 Posted May 26 Author Report Share Posted May 26 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. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.