PEP Instructions
       Disclaimer: Users of this spreadsheet should not attempt to modify any existing formulas, cell formats, etc. This template can be used to create a 
       batch upload for PEP data. Users should read the instructions very carefully before entering data. If a cell contains a formula, you must either 
       overwrite the formula with actual data, or leave the formula in tact. If formulas are erased, the template will not work properly. The formulas are copied 
       down to row 300; therefore, if you have more than 300 employees, you will need to copy and paste the existing formulas as far down as you need to 
       accomodate the total number of employees in your district/charter.
                       NOTE: These instructions are out of date and need to be updated. Use the Ordered Import instead of Round 1, Round 2, Round 3.
       Round 1
              1Save this document with a new file name to preserve the original template file.
              2Fill out the "PEP Demographic Record (100)" tab with staff information. Note: It is recommended that all data be entered sorted by SSN or last and first name.
              3Be careful not to delete any cells with pre-populated values or formulas (i.e., =REPT(" ",2).
              4Use the PEP 2016-2017 User Guide to verify the allowed values for all inputs.
              5Drag down prepopulated cells to desired row.
              6Verify in Column BJ that all TXT strings in Column BI are correct number of characters.
              7Fill out the "PEP Site-Position Record (200)" tab with site position information.
              8Repeat steps 3-5 for tab "PEP Site Position Record (200)". Note: It is recommended that all data be entered sorted by SSN or last and first name.
              9Verify in Column AE that all TXT strings in Column AD are correct number of characters.
             10Use Column AC to verify that total entered salary equals salary on record for each staff member.
             11Go to "Ordered Import" tab.
             12Drag down first row formulas to capture all 100 and 200 records.
             13Copy data in Column C to notepad.
             14Upload .txt file to PEP system using Windows.
             15Once submission is error free, go to "Round 1" tab and paste-special the values.
             16Run the following reports: LEA summary, LEA detail, and Questionable salaries.
             17If any reports seem wrong, find the errors and correct them.
       Round 2
              1Copy and paste the "Round 1" values into the "Round 2" tab.
              2Fill out the "PEP Class Schedule (210)" tab.
              3Be careful not to delete any cells with pre-populated values.
              4Use the PEP 2016-2017 User Guide to verify the allowed values for all inputs.
              5Drag down prepopulated cells to desired row.
              6Verify in Column BF that all TXT strings in Column BE are correct number of characters.
              7Copy data from "Ordered Import" to "Ordered Import (2)".
              8Copy data from "PEP Class Schedule (210)" to "Ordered Import (2)". Sort by SSN and Record. 
              9Copy data in Column C to notepad.
             10Upload .txt file to PEP system using Windows.
          11Run the following reports: HQ Summary, HQ Detail, Questionable Salaries, Report by Class SISR53
          12If any reports seem wrong, find the errors and correct them.
      Round 3
           1Update staff information with actual salary in tabs 100 and 200.
           2Update staff information with actual employment end dates in tab 200.
           3Use Column AC in the 200 tab to verify that total entered salary equals actual salary on record for each staff member.
           4Verify that all txt strings have correct number of characters.
           5Copy data from "Ordered Import" to "Ordered Import (3)".
           6Copy data from "PEP Non-Attendance Record (300)" to "Ordered Import (3). Sort by SSN and Record
           7Copy data in Column C to notepad.
           8Upload .txt file to PEP system using Windows.
           9Once submission is error free, go to "Ordered Import (3)" tab and paste-special the values. Sort by SSN and record type
          10Run the following reports: HQ Detail, HQ Summary, and Questionable salaries.
          11If any reports seem wrong, find the errors and correct them.
          12If necessary, submit 300 records for relevant staff manually.
Disclaimer: Users of this spreadsheet should not attempt to modify any existing formulas, cell formats, etc. This template can be used to create a 
batch upload for PEP data. Users should read the instructions very carefully before entering data. If a cell contains a formula, you must either 
overwrite the formula with actual data, or leave the formula in tact. If formulas are erased, the template will not work properly. The formulas are copied 
down to row 300; therefore, if you have more than 300 employees, you will need to copy and paste the existing formulas as far down as you need to 
NOTE: These instructions are out of date and need to be updated. Use the Ordered Import instead of Round 1, Round 2, Round 3.
Note: It is recommended that all data be entered sorted by SSN or last and first name.
Be careful not to delete any cells with pre-populated values or formulas (i.e., =REPT(" ",2).
that all TXT strings in Column BI are correct number of characters.
Note: It is recommended that all data be entered sorted by SSN or last and first name.
that all TXT strings in Column AD are correct number of characters.
 to verify that total entered salary equals salary on record for each staff member.
Verify in Column BF that all TXT strings in Column BE are correct number of characters.
Copy data from "PEP Class Schedule (210)" to "Ordered Import (2)". Sort by SSN and Record. 
Run the following reports: HQ Summary, HQ Detail, Questionable Salaries, Report by Class SISR53
Use Column AC in the 200 tab to verify that total entered salary equals actual salary on record for each staff member.
Copy data from "PEP Non-Attendance Record (300)" to "Ordered Import (3). Sort by SSN and Record
Once submission is error free, go to "Ordered Import (3)" tab and paste-special the values. Sort by SSN and record type