Page 1 of 2

Google Sheets (2022 Release)

PostedCOLON Tue Sep 27, 2022 11:19 am
by Shoalzie
Screen Share Tutorial Video:
http://ss-onlinedesign.com/fantasy/bbkl ... torial.mp4

= = = = =

Sheets for all 32 teams have been created. I will share them with the respective GMs later today.

For now, the link the folder is here:
https://drive.google.com/drive/folders/ ... sp=sharing

I also updated the link in the forum to the new sheets.

Draft picks aren't full subscribed but you can view your rosters for now. You'll be able to edit your sheets when I share them with you.

Re: Google Sheets (2022 Release)

PostedCOLON Tue Sep 27, 2022 11:22 am
by Shoalzie
*POST RESERVED*

Notes and the video tutorial will hopefully be posted later this week or this weekend.

Re: Google Sheets (2022 Release)

PostedCOLON Tue Sep 27, 2022 11:44 am
by Shoalzie
Some general notes on this year's sheets:
  • Better lineup warning messages. You will know if your lineup is incorrect or invalid. Messages are a bit more descriptive. The Fantrax integration is still a big part of these sheets.
  • Some visual improvements. Color coordination with your team identity. The player photos no longer cover up the position descriptions.
  • It wasn't a wide-spread problem but teams with a lot of players at a certain position caused issues with data validation. I've added at 10 extra spots per position so we shouldn't have that issue again.

Re: Google Sheets (2022 Release)

PostedCOLON Tue Sep 27, 2022 4:17 pm
by Loki
Thanks! The sheet looks great, but I don't see any players when I open mine

Re: Google Sheets (2022 Release)

PostedCOLON Tue Sep 27, 2022 4:24 pm
by Shoalzie
You should be good now...looks like the weekly grids weren't subscribed.

I need to get caught up on the very end of the waiver draft, some of the recent trades and drops and today's free agent claims. Then I'll take a look through and everyone's stuff is populating the way it should.

Anyone waiting the "mobile-friendly" version of the sheet. I'll dig into that towards the end of the week. Everyone has a set of regular sheets for now.

Re: Google Sheets (2022 Release)

PostedCOLON Tue Sep 27, 2022 4:30 pm
by Matthew
My players still arent showing up

Re: Google Sheets (2022 Release)

PostedCOLON Tue Sep 27, 2022 6:42 pm
by Loki
Looks good for me now, thanks!

Re: Google Sheets (2022 Release)

PostedCOLON Tue Sep 27, 2022 6:46 pm
by dave1959
mine is gray and blank

Re: Google Sheets (2022 Release)

PostedCOLON Tue Sep 27, 2022 6:52 pm
by TheNudge
All I see is the picks, I’ve tried looking at the preseason sheet but it just didn’t work.

Re: Google Sheets (2022 Release)

PostedCOLON Tue Sep 27, 2022 6:58 pm
by Handsome&FairMike
TheNudge wroteCOLONAll I see is the picks, I’ve tried looking at the preseason sheet but it just didn’t work.
Same for me

Re: Google Sheets (2022 Release)

PostedCOLON Tue Sep 27, 2022 6:59 pm
by Sensfanjosh
Grey and blank for me as well.

Re: Google Sheets (2022 Release)

PostedCOLON Tue Sep 27, 2022 8:24 pm
by Shoalzie
Sorry guys...missed a step but your players are showing up now. Went through each team and got it resolved.

Re: Google Sheets (2022 Release)

PostedCOLON Tue Sep 27, 2022 10:40 pm
by Matthew
Works now and seems like a big improvement over past years (at least using it on my phone) much quicker

Re: Google Sheets (2022 Release)

PostedCOLON Wed Sep 28, 2022 7:02 am
by kimmer
is mine mobile or desktop? i access it mobile more
but wud like both

Re: Google Sheets (2022 Release)

PostedCOLON Wed Sep 28, 2022 7:19 am
by Arian The Insider
Looks great. Thanks!

Re: Google Sheets (2022 Release)

PostedCOLON Wed Sep 28, 2022 8:21 am
by Shoalzie
kimmer wroteCOLONis mine mobile or desktop? i access it mobile more
but wud like both

To build a hybrid sheet using both the checkbox and data entry would be worth looking into but it's not something I can make in time for this season. I will adapt a second set of sheets that uses checkboxes to populate your lineup (the mobile version) and hopefully have that ready by this weekend.

When I get it created, I'll leave it up to each of you which version you want to use. I don't have anything set up where you can use both in parallel. The only parallel with both sets of sheets is they'll pull your lineup information from Fantrax.

My big picture goal would be to build an actual web interface and move away from these online spreadsheets. That's going to be at least a year down the road. I'm almost hitting the limit of what we can do on a spreadsheet and the next step would be build actual web pages that would have adaptive design for a computer or a phone/tablet.

The reasons I've leaned so hard into sheets is I'm not web-savvy enough to build something from entirely scratch nor could I get it built over the course of a single offseason.

Re: Google Sheets (2022 Release)

PostedCOLON Wed Sep 28, 2022 10:01 am
by KapG
Thank you Scott :)!

Re: Google Sheets (2022 Release)

PostedCOLON Wed Sep 28, 2022 12:05 pm
by kyuss
Shoalzie wroteCOLON My big picture goal would be to build an actual web interface and move away from these online spreadsheets. That's going to be at least a year down the road. I'm almost hitting the limit of what we can do on a spreadsheet
but do we really need more than this? :ugeek:

Re: Google Sheets (2022 Release)

PostedCOLON Thu Sep 29, 2022 8:40 pm
by Matthew
Which day are roster submissions due by?

Re: Google Sheets (2022 Release)

PostedCOLON Thu Sep 29, 2022 8:51 pm
by Shoalzie
Shoalzie wroteCOLONRoster Submission: Tuesday, October 4 at 10:00 p.m.
Waiver Wire Opens: Wednesday, October 5 at noon


(All times in Eastern time)