OSE: Team Status Log - Formula Fixes

[Simon Walter-Hansen]

Aaron and Marcin,

I made some quick formula improvements to the Status Log Spreadsheet:

https://docs.google.com/spreadsheet/ccc?key=0Aj7WbjRT9mlmdDBDdDFUVEktLUN6d0xTT2l4d2t4U0E#gid=0

Summary:

When referencing a single column, use [col X] : [col X] ex. A:A

When referencing multiple columns as a group, use [col X] : [col Y] ex. A:F

Benefits:

The formulas derived will work indefinitely (millions of rows), instead of having to be reformulated as the spreadsheet grows (A2:F1007 means it stops filtering after 1007 rows)

Formulas will not be transmuted by adding/shifting rows.

FYI, I believe there are online scrum software that will do all of the calculations and maintain a kanban board in one package. Might be of interest to look into, as it would eliminate some of the work in updating several places. Mia counted something like 136 online Agile/Scrum software solutions. Some free, some paid. There could be an awesome package ready to use!

Cheers!

-Simon