paper: Team 4904: Bot-Provoking Gantt Chart Tool
 

Thread created automatically to discuss a document in CD-Media.

Team 4904: Bot-Provoking Gantt Chart Tool by grem110

Re: paper: Team 4904: Bot-Provoking Gantt Chart Tool
 

What app do you suggest for .gsheet files?

Re: paper: Team 4904: Bot-Provoking Gantt Chart Tool
 

Google Sheets

Re: paper: Team 4904: Bot-Provoking Gantt Chart Tool
 

I tried that and it didn't work.
Shall try again.

Re: paper: Team 4904: Bot-Provoking Gantt Chart Tool
 

I also couldn't get it to open on my computer, but I got this URL when I tried opening it on my iPhone: https://docs.google.com/open?id=122brdqoANKJ6JEUoadh1lyKlxFFZrjQYIRlcW94PP Eo

Re: paper: Team 4904: Bot-Provoking Gantt Chart Tool
 

Even if you don't have Google Drive installed as an app, if open the .gsheet file on your computer, there's a parameter called "URL" which you can just paste into your browser to get to it.

Re: paper: Team 4904: Bot-Provoking Gantt Chart Tool
 

Looks familiar...I've been working on an excel sheet that's quite similar. Hmm. can't post an attachment in this forum, and it's not polished enough to be a white paper.

Anyway, other simple things I've done you may want to consider:

I have a column for "supporting" subteams for each task, then a calculated one which concatenates the lead and supporting groups. Then, you can filter on that combined column with "Contains" to limit the view to tasks which require just that group. I also have a subteam called "whole" which fills the combined cell with a concatenated list of all the subgroups so that everyone's limited view will still have milestones like kickoff, bag day, and key decisions.

I have columns which display the day-of-week of the start and end for each task.

My color coding is different - For non-task days, I have white and light gray alternating on a weekly scale. For task days, I have colors coded to the number of hours we plan to work that day; closed shop is palest, 6+ hours is brightest. (the number of hours is in a row just below the dates).

And OBTW, I've been selecting all of the "left side" cells and doing a custom sort, first on start date and second on end date to rearrange things when something is added or modified - this would be A4:F13 as your google sheet is now.

Re: paper: Team 4904: Bot-Provoking Gantt Chart Tool
 

Hi All,
Thanks for the feedback. Weird that the .gsheet doesn't work—do you have Google Drive for Desktop?

If you're having trouble, the browser link should work.

Re: paper: Team 4904: Bot-Provoking Gantt Chart Tool
 

For Content, this 2004 file from 365 is still very relevant. I use it as a template and I often refer people to it if they ask for a build season schedule. moe365.org/moementum2004/RobotBuild.xls

Re: paper: Team 4904: Bot-Provoking Gantt Chart Tool
 

FTFY