Work Log Instructional: Difference between revisions

From Open Source Ecology
Jump to navigation Jump to search
No edit summary
No edit summary
Line 1: Line 1:
=Usage=
=Usage=
To log tasks, click on Work Log and fill in all the fields. '''The link to the work product is the most important''', as it allows for evaluation.
To log tasks, click on Work Log and fill in all the fields. '''The link to the work product is the most important''', as it allows for evaluation by any observer.





Revision as of 01:28, 1 September 2012

Usage

To log tasks, click on Work Log and fill in all the fields. The link to the work product is the most important, as it allows for evaluation by any observer.


Modification

To add new contributors to Work Log and to separate Work Log by contributors:

  1. Create a new sheet
  2. Rename it with Name, the name of the contributor
  3. type in =filter('Sorted'!A:D,'Sorted'!B:B="Name") into boz A1 in the spreadsheet.

Status Log is sorted by =SORT( 'Status Log'!A2:Z ; 1 ; FALSE ) to produce the Sorted sheet.

That's it. Individual name sheet depends on the Sorted sheet having columns A through D, where the selector is the Name.