Excel Action List So far the action list

Excel Action List So far the action list was a simple word file, updated whenever needed The list got long (54 active actions) Hans-Günther Moser MPI für Physik -Difficult to organize -Difficult to manage -Difficult to extract specific action -no history -Better to organize like a database - Keep a complete history -Use tags to select actions according to status (active/done) category (workpackage) names This can easily be achieved using an Excel spreadsheet In addition google docs allows www viewing and editing of such an document PXD EVO 20. 7. 2010

Basic Spreadsheet Hans-Günther Moser MPI für Physik PXD EVO 20. 7. 2010

Content Hans-Günther Moser MPI für Physik PXD EVO 20. 7. 2010

WWW access Hans-Günther Moser MPI für Physik -easy WWW base access for viewing (and editing) -Excel functions should be available Google docs does the job • You need to open an google docs account • Ýou need to be include in the ‚share‘ list Access: http: //spreadsheets. google. com/ccc? key=0 Ap. DEG 8 lko. Hcwd. FI 5 LTl. UZmg 1 WDl. IT 3 Vod. DZj. Uj. BBU 2 c&hl=en &pli=1#gid=0 PXD EVO 20. 7. 2010

Google Docs View In order to use filtering: open ‚view‘ and select ‚list view‘ Hans-Günther Moser MPI für Physik PXD EVO 20. 7. 2010

List View Hans-Günther Moser MPI für Physik PXD EVO 20. 7. 2010

Filter Hans-Günther Moser MPI für Physik PXD EVO 20. 7. 2010

Result Hans-Günther Moser MPI für Physik Multiple filters are possible: e. g. onle ‚active‘ actions of a certain WP PXD EVO 20. 7. 2010

Next Hans-Günther Moser MPI für Physik PXD EVO 20. 7. 2010