ny92mike Posted August 31, 2019 Share Posted August 31, 2019 As for it updating slow, which I know it sucks. Part of that is the design, just a ton of if statements to get the results but if @TedLavie wants to try removing the importrange formula that collects the player database from the master wb. It's possible that it speeds it up some. Knowing what we know now, there are some things we can try with the formulas that could potentially speed it up a little too, but I don't dare attempt any of that until this is over. 1 Link to comment Share on other sites More sharing options...
Xmad Posted August 31, 2019 Share Posted August 31, 2019 4 minutes ago, ny92mike said: Just read, "spreadsheet isn't accurate". Is it because it isn't accounting for the sub 500?...which I forget what that means. Nah the sub 500 has no bearing on the cap. I'm just saying it wasn't 100% accurate early on (I.E counting invalid bids) It's perfectly fine now. 1 Link to comment Share on other sites More sharing options...
ny92mike Posted August 31, 2019 Share Posted August 31, 2019 Just now, SwoleXmad said: Nah the sub 500 has no bearing on the cap. I'm just saying it wasn't 100% accurate early on (I.E counting invalid bids) It's perfectly fine now. Gotcha. 1 Link to comment Share on other sites More sharing options...
ny92mike Posted August 31, 2019 Share Posted August 31, 2019 While I'm here talking about this. Would having the player exp / age being listed in the player database sheet be useful? 1 Link to comment Share on other sites More sharing options...
Xmad Posted August 31, 2019 Share Posted August 31, 2019 1 minute ago, ny92mike said: While I'm here talking about this. Would having the player exp / age being listed in the player database sheet be useful? I think you can simplify this to rookie vs. non rookies. anyone whose gonna get bid on is gonna get googled and their age/team/exp will be right there. Link to comment Share on other sites More sharing options...
MD4L Posted August 31, 2019 Share Posted August 31, 2019 Welcome the newest member of the Cuba Smugglers Tyrann Mathieu 2 Link to comment Share on other sites More sharing options...
BringinDaPain Posted August 31, 2019 Share Posted August 31, 2019 Guys, I am here.. Have been here, just haven't seen anything worth commenting on.. @ny92mike you interested in co GM Carolina? If not I will look else where.. Link to comment Share on other sites More sharing options...
Jlash Posted August 31, 2019 Author Share Posted August 31, 2019 57 minutes ago, BringinDaPain said: Guys, I am here.. Have been here, just haven't seen anything worth commenting on.. @ny92mike you interested in co GM Carolina? If not I will look else where.. I think he's already been scooped up? 1 Link to comment Share on other sites More sharing options...
PR Posted August 31, 2019 Share Posted August 31, 2019 Something got messed up as rookies are listed as veterans 1 Link to comment Share on other sites More sharing options...
MD4L Posted August 31, 2019 Share Posted August 31, 2019 1 hour ago, Jlash said: I think he's already been scooped up? The only thing we were missing from BDP was abrupt Jlash slander. Link to comment Share on other sites More sharing options...
Jlash Posted August 31, 2019 Author Share Posted August 31, 2019 5 minutes ago, MD4L said: The only thing we were missing from BDP was abrupt Jlash slander. I was waiting for it. Link to comment Share on other sites More sharing options...
Whicker Posted August 31, 2019 Share Posted August 31, 2019 I don't feel as if PR's recent bids ought to have counted. Am I wrong? Link to comment Share on other sites More sharing options...
Jlash Posted August 31, 2019 Author Share Posted August 31, 2019 6 minutes ago, Whicker said: I don't feel as if PR's recent bids ought to have counted. Am I wrong? What happened? Link to comment Share on other sites More sharing options...
Whicker Posted August 31, 2019 Share Posted August 31, 2019 1 minute ago, Jlash said: What happened? According to the spreadsheet, the current bids he has will put him $1837 over the cap. His Adam Humphries bid was $1050 so, according to the spreadsheet, his Derek Carr bid put him over. Link to comment Share on other sites More sharing options...
Jlash Posted August 31, 2019 Author Share Posted August 31, 2019 Just now, Whicker said: According to the spreadsheet, the current bids he has will put him $1837 over the cap. His Adam Humphries bid was $1050 so, according to the spreadsheet, his Derek Carr bid put him over. As long as the spreadsheet hasn't updated and you're right, I believe whatever bid put him over the cap would be invalid. Link to comment Share on other sites More sharing options...
Recommended Posts