Page 4 of 10
Re: 2016-17 BBKL Google Sheets
PostedCOLON Sun Aug 28, 2016 10:43 am
by koomzzz
Shoalzie wroteCOLONIf there's not been problems of late, I think we go league-wide with this any time. If you haven't sent me your Gmail, please do so. I'll work on getting those out to everyone.
Current contract info is about 2/3 done. I'd like to be done with it before Labor Day weekend but it might end up being that following week.
Should the contract info be auto-updating? or do you have it set up to import when you are finished?
Re: 2016-17 BBKL Google Sheets
PostedCOLON Sun Aug 28, 2016 11:20 am
by Shoalzie
I'll check your sheet...
Re: 2016-17 BBKL Google Sheets
PostedCOLON Sun Aug 28, 2016 3:00 pm
by Shoalzie
Yes, it is updating...it just depends on what team your players are with. I'm able to get a lot more done if I just do the team-by-team thing on General Fanager. I'll get back to the birthdate and GP after I enter all the contracts. I seem to think everyone would prefer to know their cap situation when they look at their roster. I'm quite confident all the data entry will be done by the end of September.
Re: 2016-17 BBKL Google Sheets
PostedCOLON Sun Aug 28, 2016 4:24 pm
by Handsome&FairMike
holy shit scott... you're entering it all manually?
Re: 2016-17 BBKL Google Sheets
PostedCOLON Sun Aug 28, 2016 6:29 pm
by koomzzz
Shoalzie wroteCOLONYes, it is updating...it just depends on what team your players are with. I'm able to get a lot more done if I just do the team-by-team thing on General Fanager. I'll get back to the birthdate and GP after I enter all the contracts. I seem to think everyone would prefer to know their cap situation when they look at their roster. I'm quite confident all the data entry will be done by the end of September.
None of the contracts that are on the sheet now were there earlier today... Also are positions supposed to be populated or is that manual entry on our end?
Re: 2016-17 BBKL Google Sheets
PostedCOLON Sun Aug 28, 2016 9:44 pm
by Shoalzie
On "Roster", you fill in A and B. For the weekly sheet, you fill in A through D.
You fill in your active roster on "Roster" and the weekly sheet will reference that sheet but you still have to fill in those names and positions. If you are missing a name on "Roster" and you have them on the weekly sheet, the data shouldn't appear. "Roster" is more of a summary page. Just update it when you get a new player. You move any former players to that bottom section so you don't screw up your old sheets.
Re: 2016-17 BBKL Google Sheets
PostedCOLON Sun Aug 28, 2016 10:25 pm
by bills09
So basically I just enter the player names not the birthdates etc.
Re: 2016-17 BBKL Google Sheets
PostedCOLON Sun Aug 28, 2016 10:50 pm
by bills09
Only issues I'm seeing is Alex Pietrangelo not showing up with cap figures and Jaromir Jagr as unsigned.
Re: 2016-17 BBKL Google Sheets
PostedCOLON Mon Aug 29, 2016 5:41 am
by Shoalzie
You've found one of the important things with these new sheets...you had Pietrangelo's name spelled right but you had a space after it. I removed the space and the contract info showed up.
Jagr and any other player that doesn't have their contract info entered in the database will appear as "Unsigned". It's a default value in the column because there's about 5000 players in the Fantrax database and only about 1500 will have signed contracts. In my database, a player won't appeared signed unless I enter a few pieces of information.
I haven't gotten to Florida yet in the team-by-team. I'm going by the total salaries list on General Fanager's home page...working top to bottom. I'm surprised Florida is 4th from the bottom in terms of team salary with all the cash they've spent this summer. For what I have left to do with contracts, it's Dallas down to Carolina. 13 teams left...I started on the Stars yesterday.
Re: 2016-17 BBKL Google Sheets
PostedCOLON Mon Aug 29, 2016 8:11 am
by bills09
No rush brother just wanted to let you know.
Re: 2016-17 BBKL Google Sheets
PostedCOLON Mon Aug 29, 2016 8:52 am
by Shoalzie
bills09 wroteCOLONSo basically I just enter the player names not the birthdates etc.
Correct.
Re: 2016-17 BBKL Google Sheets
PostedCOLON Mon Aug 29, 2016 9:01 am
by KapG
How's this all working? Someone wanna give me a rundown?
Re: 2016-17 BBKL Google Sheets
PostedCOLON Mon Aug 29, 2016 9:51 am
by Shoalzie
New sheets for this year (and hopefully going forward). Sheets reference a player database where you don't have to look up and enter the info yourself. I'll maintain the database. Database will be ready before the start of the season.
Send me your email If you want to start using your sheet.
Re: 2016-17 BBKL Google Sheets
PostedCOLON Mon Aug 29, 2016 9:53 am
by KapG
Shoalzie wroteCOLONNew sheets for this year (and hopefully going forward). Sheets reference a player database where you don't have to look up and enter the info yourself. I'll maintain the database. Database will be ready before the start of the season.
Send me your email If you want to start using your sheet.
Wow, this sounds amazing.
I can't even imagine how much time this took you to do shoalzie!! So big, big thanks
!
Re: 2016-17 BBKL Google Sheets
PostedCOLON Mon Aug 29, 2016 10:35 am
by Arian The Insider
someone buy this man some beers
Re: 2016-17 BBKL Google Sheets
PostedCOLON Mon Aug 29, 2016 10:37 am
by Lee
Arian The Insider wroteCOLONsomeone buy this man some beers
is it because you're not old enough?
Re: 2016-17 BBKL Google Sheets
PostedCOLON Mon Aug 29, 2016 12:38 pm
by Arian The Insider
Lee wroteCOLONArian The Insider wroteCOLONsomeone buy this man some beers
is it because you're not old enough?
because i'm a broke student
Re: 2016-17 BBKL Google Sheets
PostedCOLON Mon Aug 29, 2016 2:07 pm
by CAM
Id be up for getting mine ready Scott if you dont mind. Thanks. I can pm you my addy.
Re: 2016-17 BBKL Google Sheets
PostedCOLON Mon Aug 29, 2016 4:29 pm
by The BBKL Insider
Id buy everyone beers in the US. It's dirt cheap down there.
Re: 2016-17 BBKL Google Sheets
PostedCOLON Tue Aug 30, 2016 8:40 am
by KapG
Got your email Scott, ty sir!!
I'll fiddle around with it and get it all worked out in the next couple weeks before I head out to vegas