Google Sheets (2022 Release)

[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.

[Shoalzie]

*POST RESERVED*

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

[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.

[Loki]

Thanks! The sheet looks great, but I don't see any players when I open mine

[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.

[Matthew]

My players still arent showing up

[Loki]

Looks good for me now, thanks!

[dave1959]

mine is gray and blank

[TheNudge]

All I see is the picks, I’ve tried looking at the preseason sheet but it just didn’t work.

[Handsome&FairMike]

All I see is the picks, I’ve tried looking at the preseason sheet but it just didn’t work.

Same for me

[Sensfanjosh]

Grey and blank for me as well.

[Shoalzie]

Sorry guys...missed a step but your players are showing up now. Went through each team and got it resolved.

[Matthew]

Works now and seems like a big improvement over past years (at least using it on my phone) much quicker

[kimmer]

is mine mobile or desktop? i access it mobile more
but wud like both

[Arian The Insider]

Looks great. Thanks!

[Shoalzie]

is 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.

[KapG]

Thank you Scott !

[kyuss]

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?

[Matthew]

Which day are roster submissions due by?

[Shoalzie]

Roster Submission: Tuesday, October 4 at 10:00 p.m.
Waiver Wire Opens: Wednesday, October 5 at noon

(All times in Eastern time)