paper: Team 4904: Bot-Provoking Gantt Chart Tool

[grem110]

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

Team 4904: Bot-Provoking Gantt Chart Tool (http://www.chiefdelphi.com/media/papers/3296?) by grem110

[Taylor]

What app do you suggest for .gsheet files?

[Conor Ryan]

What app do you suggest for .gsheet files?

Google Sheets

[Taylor]

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

[Drewit]

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

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

[Bkeeneykid]

What app do you suggest for .gsheet files?

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.

[GeeTwo]

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.

[grem110]

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 (https://docs.google.com/spreadsheets/d/1SQ2jE29FHuJQ6I35FGo6rcIZyK18i_dvgb_BXa_z9ZE/edit?usp=sharing) should work.

[Conor Ryan]

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

[GeeTwo]

FTFY

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/moementum/moementum2004/RobotBuild.xls (http://moe365.org/moementum/moementum2004/RobotBuild.xls)