ny92mike Posted August 28, 2019 Share Posted August 28, 2019 Just now, SirA1 said: I do data entry for a living, trust me BDL is easy peasy after processing 200+ things a day. omg...I'd kill myself. I really enjoy creating the formulas but loathe typing in the information...haha. Link to comment Share on other sites More sharing options...
ny92mike Posted August 28, 2019 Share Posted August 28, 2019 2 minutes ago, SirA1 said: I do data entry for a living, trust me BDL is easy peasy after processing 200+ things a day. Well I'll at least set it up to make it easier to type the data over. Link to comment Share on other sites More sharing options...
ny92mike Posted August 28, 2019 Share Posted August 28, 2019 3 hours ago, TedLavie said: Personnally not a fan because it takes a while to scroll down the whole player list. But I don't have ny issue with typos, so I'll roll with whatever people prefer Well there is that...lol. . 1 Link to comment Share on other sites More sharing options...
ny92mike Posted August 28, 2019 Share Posted August 28, 2019 @Hockey5djh You informed me about the duplicate bids showing up in the team pages, I just pushed out a change to the formula that should clean all of those issues up. Thanks man. 1 Link to comment Share on other sites More sharing options...
ny92mike Posted August 28, 2019 Share Posted August 28, 2019 @Jlash @bcb1213 @Hockey5djh @Counselor @wwhickok @Whicker @BringinDaPain @SirA1 @MD4L @PR @Ragnarok @RuskieTitan @WFLukic @SwoleXmad @pheltzbahr @TedLavie We got action! The Hungarian Hippos just announced that they've signed some depth to their roster in offensive guard Brian Winters and cornerback Dominique "I'm not retired" Rodgers-Cromartie to vet min salaries. Also being reported Portland has signed the following to vet mins. Joe Flacco, Devin Funchess, Greg Mancz and Clay Matthews. Expect others to be signed soon. These players will officially be added to their team rosters tomorrow. 3 Link to comment Share on other sites More sharing options...
ny92mike Posted August 28, 2019 Share Posted August 28, 2019 @TedLavie @SirA1 Updating the Player Database sheet in the main workbook. Two sheets (Shark tank awarded contracts and shark tank import) were added to the master wb. Once players are awarded in the shark tank, they are imported into the shark tank IMPORT sheet. I used a formula in column A, flagging the names to signify if they need to be added to the Shark tank Awarded Contracts sheet. If they need to be added, copy row starting with column I thru AH and use cntrl shift V to paste just the values into the shark tank awarded contracts sheet. This will give you a record without any formulas. Once you get the player added to that sheet, travel to the player database and enter the bdl team name, contract amount, contract length and roster status/ Signed Shark Tank...Done. Once they are added to the player database sheet their names will be removed the shark tank workbook so it's important that you copy the info to the Shark Tank Awarded Contracts sheet first. Hope this helps...if you're confused don't worry so am I. 2 Link to comment Share on other sites More sharing options...
WFLukic Posted August 28, 2019 Share Posted August 28, 2019 Is the awarded contracts section going to have all players or just your own? Link to comment Share on other sites More sharing options...
TedLavie Posted August 28, 2019 Share Posted August 28, 2019 22 minutes ago, WFLukic said: Is the awarded contracts section going to have all players or just your own? All. Your players will appear in green in your team tab Link to comment Share on other sites More sharing options...
PR Posted August 28, 2019 Share Posted August 28, 2019 39 minutes ago, TedLavie said: All. Your players will appear in green in your team tab Nope Link to comment Share on other sites More sharing options...
TedLavie Posted August 28, 2019 Share Posted August 28, 2019 17 minutes ago, PR said: Nope Hmmm I will check that today Link to comment Share on other sites More sharing options...
Xmad Posted August 28, 2019 Share Posted August 28, 2019 I don't know who Greg Mancz is. Link to comment Share on other sites More sharing options...
MD4L Posted August 28, 2019 Share Posted August 28, 2019 Just now, SwoleXmad said: I don't know who Greg Mancz is. Texans O-Line 1 Link to comment Share on other sites More sharing options...
Xmad Posted August 28, 2019 Share Posted August 28, 2019 39 minutes ago, MD4L said: Texans O-Line It was a joke but I appreciate this. Link to comment Share on other sites More sharing options...
Hockey5djh Posted August 28, 2019 Share Posted August 28, 2019 13 hours ago, ny92mike said: IMPORTANT: This form is not linked to the official shark tank workbook. This is just to show you guys something that would make it easier on all of us. So check this out. Rather than requiring a manual entry of the player name and pos and making sure that it matches exactly. I've loaded all the names into the form, which we would update when players are added and or removed from the tank. This wouldn't have worked last year because of the amount of entries being added but it's working now. https://docs.google.com/forms/d/e/1FAIpQLSeU__LTo1y5kzc3EahxWSHf_k5ANTHyJKwRIo4OKYv2F-OxEw/viewform?usp=sf_link Give it a look and let me know if you guys wanna switch to this as it would prevent a ton of typo issues that we've been dealing with. I'd rather copy/paste. Scrolling to find each player would take forever. 1 Link to comment Share on other sites More sharing options...
Hockey5djh Posted August 28, 2019 Share Posted August 28, 2019 12 hours ago, TedLavie said: So @Jlash @bcb1213 @Hockey5djh @Counselor @wwhickok @Whicker @BringinDaPain @SirA1 @MD4L @PR @Ragnarok @RuskieTitan @WFLukic @SwoleXmad @pheltzbahr Do any of you want to switch back to the forum for the rest of the Shark Tank? It's been almost 48hr, time to make a decision I'm good with sticking to the form. Link to comment Share on other sites More sharing options...
Recommended Posts