Centralized data Vetting Process: Difference between revisions
| Line 1: | Line 1: | ||
*'''need to make sure all in [[Data Appending Process]] is addressed.''' | *'''need to make sure all in [[Data Appending Process]] is addressed.''' | ||
== Checklist Tracker Sheet == | |||
This is still part of the old system as a cross check until we go totally with the new system. | |||
Print a ''checklist tracker sheet'' | |||
*My Documents | |||
*Open ''workbook2.xls'' | |||
*Change header to sent date (use Thurs date) | |||
*Print | |||
Check to see that everyone has sent | |||
*Regional | |||
*Output | |||
*check each folder to see who sent, and write the # on the tracker sheet | |||
**the data collector sends these files | |||
***there are only ''complete'' files in these xls cvs files | |||
**when viewing these in the xls file, the header is included as Line 1, so the actual # of files sent will be one less, e.g. if it says 11, then there were 10 files sent | |||
To check the ''incomplete'' files | |||
*make a copy of ''PDA_pending.mdb'' | |||
*put the copy on the desktop | |||
*prompts ''already a copy...'' | |||
*answer Yes | |||
*open PDA_Pending.mdb | |||
*check each site and write down the # of ''incomplete'' on the tracker sheet | |||
**when viewing these files the header is not included, so the # is how many files pending | |||
*close each file you have opened | |||
*close PDA_Pending.mdb | |||
Then | |||
*check L_Log | |||
*check L_PHI | |||
*check L_LogPhi | |||
*write these numbers on the tracker sheet | |||
== Pull down data == | == Pull down data == | ||
| Line 169: | Line 211: | ||
''' | ''' | ||
[[User:Srusnak|Srusnak]] | |||
[[User:Srusnak|Srusnak]] 13:25, 2014 July 30 (CDT) | |||
==clean ups== | ==clean ups== | ||