Skip to content

Setup of Google Spreadsheet

Yashar edited this page Feb 1, 2017 · 20 revisions

##Getting the Google Sheet Template

The example Google spreadsheet template can be found in the templates directory or copied directly from this hosted template. The template provides examples on how to format projects, resources, and specific dates.

Please Note: You will need to re-upload the sheet from the templates directory, or clone the sample hosted sheet on your own Google account before proceeding (i.e. you will need to be hosting your own sheet).

Adding/Managing Projects/Companies

###Adding a Project To add a project, simply add to column A (rows 2 and lower) a "slug" (No longer than four characters for formatting reasons) and then a hex color value one space after the slug.

###Adding a Company Key To add/update a company color key, add a name and hex value to cell A1. Additional companies/names will need to be pipe-delimited with a space.

Company 1 #FF0000 | Company 2 #008000 | Open #FFFFFF

Adding a Project to a Resource

To add a project to a resource, edit the specific day and type the project's "slug" into the field.

Marking a date as a "Deliverable"

Certain dates are needed to be marked as "Deliverables". In order to achieve this, append to a projects slug "-DLVR" in the date's field. This will mark the day with a red border in the build.