|
|
| 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 Wed date)
| |
| **click Insert
| |
| **Header & Footer
| |
| **Change the date
| |
| **File
| |
| **Print
| |
|
| |
| ==Check to see that everyone has sent==
| |
| *RegionalWRHA (wreath icon)
| |
| *Output (folder)
| |
| *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 complete files sent
| |
|
| |
| ==To check the ''incomplete'' files==
| |
| *make a copy of ''[[PDA Pending.mdb]]''
| |
| ***we have stopped sending to pda pending, what if anything is being used now? Ttenbergen 20:41, 2014 September 29 (CDT) {{discussion}}
| |
| **Regional
| |
| **Output
| |
| **right click PDA_pending.mdb
| |
| **Copy
| |
| *Paste 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
| |
| ***at the bottom it says ''Record __ of __''
| |
| *close each file you have opened
| |
| *close PDA_Pending.mdb
| |
|
| |
|
| == Pull data == | | == Pull data == |
| Line 57: |
Line 20: |
| '''**ALL 3 must be the same**''' | | '''**ALL 3 must be the same**''' |
|
| |
|
|
| |
| == cross-check tracker sheet ==
| |
| Double check these numbers against the tracker sheet, which compares the old to the new combined centralized numbers
| |
|
| |
| The ''complete'' numbers come from the xls csv file
| |
|
| |
| The ''incomplete'' numbers come from the [[PDA_Pending.mdb]] file
| |
| * {{discussion}} don't think so, we don't use that any more. Ttenbergen 22:27, 2014 September 29 (CDT)
| |
|
| |
|
| ==See who Sent== | | ==See who Sent== |
|
| |
| * Queries | | * Queries |
| * P_Count_Of_Sent (double click) | | * P_Count_Of_Sent (double click) |