ny92mike Posted February 8, 2020 Author Share Posted February 8, 2020 @mountainpd said that his private wb glitched showing #N/A in place of his available cap...anyone else having this issue? Quote Link to comment Share on other sites More sharing options...
DTMW78 Posted February 8, 2020 Share Posted February 8, 2020 @ny92mike No problems here. Quote Link to comment Share on other sites More sharing options...
RedGold Posted February 8, 2020 Share Posted February 8, 2020 Mine was doing it for a bit, I just kept refreshing. It fixed itself, just gotta make sure it doesn’t do that before you grab the bids 1 Quote Link to comment Share on other sites More sharing options...
BowserBroncos Posted February 8, 2020 Share Posted February 8, 2020 1 hour ago, ny92mike said: @mountainpd said that his private wb glitched showing #N/A in place of his available cap...anyone else having this issue? I had this but went back by itself, but only in the unofficial cap. This happened in the Denver workbook. For Chicago the unoffical showed -17 billion, also went back by itself. Quote Link to comment Share on other sites More sharing options...
cortes02 Posted February 8, 2020 Share Posted February 8, 2020 My workbook looks good so far. Still showing the cap space. Peace!!! Quote Link to comment Share on other sites More sharing options...
ny92mike Posted February 8, 2020 Author Share Posted February 8, 2020 I did two things last night that might of caused it...The first was I linked the available cap to the fa sorting sheet for each team. Which it worked fine at first glance. That is when I noticed a team was several million over yet the bids were still being accepted. Went to review what might be causing it and discovered that going over the cap creates a nasty loop after that I went back to the fa sorting workbook and noticed several teams with the error #N/A and that I had also lost connection with the internet. So I'm not sure if the loop caused an overload to just how many and how fast it can calculate changes with several linked workbooks in play or if getting kicked of the internet during that time had a hand or not. Outside of being over the cap and the bids saying that they are within the validation range for it to pass through, I believe the glitch is good. I'll definitely monitor it when I copy the data over to make sure that the bids are coming in correctly. @samsel23 If you'll be around during that time I could really use the help. If any of you guys notice anything that looks like a glitch or an issue once the workbook fully loads let me know. Quote Link to comment Share on other sites More sharing options...
RedGold Posted February 8, 2020 Share Posted February 8, 2020 I should be around most of the day @ny92mike 1 Quote Link to comment Share on other sites More sharing options...
EaglesPeteC Posted February 8, 2020 Share Posted February 8, 2020 I’m good with my teams. Juan was working in his book today so his is good 1 Quote Link to comment Share on other sites More sharing options...
squire12 Posted February 8, 2020 Share Posted February 8, 2020 Anyone interested in discussing some pre FA trades, PM @FinneasGageor myself Quote Link to comment Share on other sites More sharing options...
mountainpd Posted February 8, 2020 Share Posted February 8, 2020 8 minutes ago, squire12 said: Anyone interested in discussing some pre FA trades, PM @FinneasGageor myself pick pm, pick me Quote Link to comment Share on other sites More sharing options...
mountainpd Posted February 8, 2020 Share Posted February 8, 2020 Who’s gonna be the biggest free agent signing variance to apy requirement? 1 Quote Link to comment Share on other sites More sharing options...
ny92mike Posted February 8, 2020 Author Share Posted February 8, 2020 Just had another glitch with Denver's team @BowserBroncos it's fixed but I think after this round, we are going to have to come up with a different solution. I really believe that there are just too many links to this current system and with so many people changing bids and or just reviewing stuff it's creating some unwanted issues. Obviously I don't have the time to do much now, but after this first round I think something must happen...Another glitch at the wrong time could really mess some stuff up. Spent the last 20 minutes trying to figure out the problem, and really never felt that I did it just kinda fixed itself....Which is even scarier because I don't have a quick place I can go to fix it. May need to put the brakes on round two until I can resolve this, which will likely require new workbooks. Pretty bummed at all the issues with this years mock, really sorry about this guys. At this rate, can't see myself doing this again next year, just getting to be too much. Arizona CardinalsARI@LuckyNumber11 Atlanta FalconsATL @EaglesPeteC Baltimore RavensBAL@ravens5520 Buffalo BillsBUF@nayad Carolina PanthersCAR@PR Chicago BearsCHI @BowserBroncos Cincinnati BengalsCIN@sparky151 Cleveland BrownsCLE@cortes02 Dallas CowboysDAL@D82 Denver BroncosDEN@BowserBroncos@FRock24Detroit LionsDET@winitall Green Bay PackersGB@squire12 Houston TexansHOU@jch1911 Indianapolis ColtsIND@Counselor Jacksonville JaguarsJAC@Trojan Kansas City ChiefsKC@samsel23@TedLavieLos Angeles ChargersLAC@wwhickok Los Angeles RamsLAR@jrry32@yoinesh123Miami DolphinsMIA@mountainpd Minnesota VikingsMIN@MikeT14 New Orleans SaintsNO@whodatOL New England PatriotsNE@Deadpulse New York GiantsNYG@YogiBiz@ny92mikeNew York JetsNYJ@KingOfTheDot Las Vegas RaidersLVR@DTMW78 Philadelphia EaglesPHI@EaglesPeteC Pittsburgh SteelersPIT@Cbrunn San Francisco 49ersSF@Justone2 Seattle SeahawksSEA@Juan7637 Tampa Bay BuccaneersTB@rackcs Tennessee TitansTEN@bcb1213 Washington RedskinsWAS@mike23md Quote Link to comment Share on other sites More sharing options...
jrry32 Posted February 8, 2020 Share Posted February 8, 2020 16 minutes ago, mountainpd said: Who’s gonna be the biggest free agent signing variance to apy requirement? D.J. Humphries? Quote Link to comment Share on other sites More sharing options...
ny92mike Posted February 8, 2020 Author Share Posted February 8, 2020 3 minutes ago, jrry32 said: D.J. Humphries? PFF grading system didn't care much for him but I believe you are right, without looking. Heck I'm not even to that point of being able to pull that data from the sorting workbook, scared to touch it to be honest. 1 Quote Link to comment Share on other sites More sharing options...
ny92mike Posted February 8, 2020 Author Share Posted February 8, 2020 Just as I say that, the Jets wb screws up....what a ******* nightmare. 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.