{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Recap","Work Days Salary","Work Days Hourly","Payoff","Role Ids","ECF Works Day Understanding","PR Deduction Agreement","1st Paycheck"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":4,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Recap","index":0,"n_rows":195,"n_cols":16,"rows_kept":195,"cut":false,"hidden":false,"merged":[[13,9,13,12],[43,7,43,9],[45,7,45,9],[56,7,56,9],[57,7,57,9],[18,4,18,10],[19,4,19,10],[20,4,20,10],[22,1,22,3],[21,1,21,3],[19,1,19,3],[52,7,52,9],[47,7,47,9],[40,1,40,6],[41,1,41,6],[38,1,38,5],[38,7,38,9],[23,0,23,12],[32,2,32,5],[80,11,80,12],[78,11,78,12],[79,11,79,12],[16,5,16,9],[17,5,17,9],[80,9,80,10],[78,9,78,10],[79,9,79,10],[78,5,78,7],[79,5,79,7],[80,5,80,7],[62,1,62,6],[66,1,66,6],[70,1,70,6],[72,1,72,6],[75,1,75,6],[72,7,72,9],[73,7,73,9],[75,7,75,9],[71,1,71,6],[57,1,57,6],[53,7,53,9],[53,1,53,6],[67,1,67,6],[46,1,46,6],[44,1,44,6],[48,1,48,6],[68,1,68,6],[69,1,69,6],[58,1,58,6],[58,7,58,9],[59,7,59,9],[60,7,60,9],[61,7,61,9],[54,1,54,6],[54,7,54,9],[59,1,59,3],[59,4,59,6],[60,1,60,3],[60,4,60,6],[61,1,61,3],[61,4,61,6],[65,3,65,6],[35,7,35,9],[34,7,34,9],[36,7,36,9],[77,1,77,2],[51,1,51,6],[51,7,51,9],[43,1,43,6],[45,1,45,6],[62,7,62,9],[63,7,63,9],[64,7,64,9],[65,7,65,9],[66,7,66,9],[67,7,67,9],[68,7,68,9],[69,7,69,9],[70,7,70,9],[71,7,71,9],[73,1,73,6],[50,7,50,9],[50,1,50,6],[49,7,49,9],[49,1,49,6],[48,7,48,9],[40,7,40,9],[47,1,47,6],[44,7,44,9],[6,4,6,9],[20,1,20,3],[21,4,21,10],[41,7,41,9],[15,0,15,3],[15,5,15,9],[11,0,11,6],[11,8,11,11],[12,0,12,2],[13,0,13,2],[12,3,12,7],[13,3,13,7],[18,1,18,3],[8,11,8,12],[9,11,9,12],[8,9,8,10],[9,2,9,4],[9,0,9,1],[22,4,22,10],[37,7,37,9],[36,2,36,5]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,"EMPLOYEE CHANGE FORM"]
[]
["To: Stephanie Rodriguez, HR Director",null,null,null,null,null,null,null,null,"Printed ----->>>",null,{"$f":"NOW()","v":"2020-08-05T12:37:10.710"}]
["From: --------->>>",null,"Supervisor's Name",null,null,null,null,null,null,null,null,{"$f":"NOW()","v":44048.525818402777}]
[]
["Campus  ------>> Please place \"4\" on one Location",null,null,null,null,null,null,null,"Eligible for Bonus Pay? Yes or No ------->>>>"]
[]
[null,null,null," ",null,null,null,null,"Role ID:","Click for Drop Down List"]
[]
["Employee Name ---------->>",null,null,null,null,"Employee's Name"]
[]
["Place an \"4\" on Applicable Line"]
[null,null,null,null,"Line 1-6 AND 7-14  OR  15-24  AND Line 25"]
[null,null,null,null,"Line 1-6 AND 7-14  OR  15-24  AND Line 25"]
[null," ",null,null,"Line 1-6 AND 7-14  OR  15-24  AND Line 25"]
[null,null,null,null,"Line 1-6 AND 7-14  OR  15-24  AND Line 25"]
[null,null,null,null,"Line 1-6 AND 7-14  OR  15-24  AND Line 25"]
[]
["Line","Item"]
[]
[1,"Program","Fund","Func","Object","Sub Obj","Org","Year","PIC","Opt 3","Opt 4&5"]
[null,null,"X X X","X X","X X X X","X X","X X X ","X","XX","X","XX","Hourly","Salary"]
["1st ",{"$f":"+H57","v":" Base Pay"},null,null,null,null,null,null,null,null,null,0,0]
["2nd","Split GL",null,null,null,null,null,null,null,null,null,0,0]
["3rd","Other ",null,null,null,null,null,null,null,null,null,0,{"$f":"+I59","v":0}]
["4th","Other ",null,null,null,null,null,null,null,null,null,0,{"$f":"+J67","v":0}]
[null,{"$f":"SUM(B29:B32)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"(L29+L30+L31+L32)","v":0},{"$f":"(M29+M30+M31+M32)","v":0}]
[]
[{"$f":"+A27+1","v":2},"Please Enter the TRS Classification ----->>>",null,null,null,null,null,"Pick One"]
[]
[{"$f":"+A35+1","v":3},"Position:","Example: Math Teacher"]
[]
[{"$f":"+A37+1","v":4},"Leave Days To Be Taken by Employee"]
[]
[5,"Employment Start Date"]
[6,"Employment End Date"]
[]
[7,"Pay Start Date"]
[]
[{"$f":"+A44+1","v":8},"Pay End Date"]
[]
[{"$f":"+A46+1","v":9},"Hourly Rate \"Complete If Hourly Employee\"",null,null,null,null,null,{"$f":"H50/H49","v":{"$error":"#DIV/0!"}}]
[{"$f":"+A48+1","v":10},"Hours Per Day"]
[11,"Hourly Daily Rate \"Formula\" ----->> Line 7 X  Line 8",null,null,null,null,null,{"$f":"L33/H51","v":{"$error":"#DIV/0!"}}]
[12,"Work days to be worked ",null,null,null,null,null,{"$f":"+'Work Days Hourly'!D22","v":0}]
[11,"\"Actual\" Worked days for Payoffs",null,null,null,null,null,{"$f":"IF(H48=\"\",0,IF('Work Days Hourly'!D22>0,IF('Work Days Hourly'!E22>0,\"See Work Days Hourly Tap Col B\",'Work Days Hourly'!E22),'Work Days Hourly'!E22))","v":{"$error":"#DIV/0!"}}]
[12,"Annual \"Hourly\" Salary OR Amount Earned for Payoffs",null,null,null,null,null,{"$f":"L33","v":0}]
[13,"Remaining Bi-Monthly Pay Periods to Pay"]
[14,"Bi-Monthly Pay Period Rate  \"Formula\" ----->>",null,null,null,null,null,{"$f":"IF(H54=\"\",\"\",+H53/H54)","v":""}]
[]
[null,null,null,null,null,null,null," Base Pay"]
[{"$f":"+A55+1","v":15},"Total Years of Teaching  Experience "]
[{"$f":"+A58+1","v":16},"Base Salary \"Complete if Salary Employee\"",null,null,null,null,null,{"$f":"+M29+M30","v":0}]
[null,"Stipend - Please Select One ------->",null,null,"Pick One"]
[null,"Stipend - Please Select One ------->",null,null,"Pick One"]
[null,"Stipend - Please Select One ------->",null,null,"Pick One"]
[null,"      Teacher Certification  "]
[null,"      Performance Pay (TRS Eligible)"]
[null,"      Bonus (Not TRS Eligble)"]
[null,"      Other Pay (Type in)"]
[17,"Total Salary",null,null,null,null,null,{"$f":"SUM(H59:H66)","v":0}]
[18,"Work days \"Complete year\"",null,null,null,null,null,{"$f":"+'Work Days Salary'!$C$22","v":0}]
[19,"Daily Rate   \"Formula\" ----->>   Line 16 / Line 17",null,null,null,null,null,{"$f":"IF(H67=0,0,+H67/H68)","v":0}]
[20,"Work days for New Hires  & Returning Employees",null,null,null,null,null,{"$f":"IF('Work Days Salary'!$D$22=0,0,IF('Work Days Salary'!$E$22>0,\"Review Work Days Tap Col B\",IF('Work Days Salary'!$E$22>0,\"Review Work Days Tap C\",'Work Days Salary'!$D$22)))","v":0}]
[21,"\"Actual\" Worked days for PAYOFFS",null,null,null,null,null,{"$f":"IF('Work Days Salary'!$E$22=0,0,IF('Work Days Salary'!$D$22>0,\"Review Work Days Tap Col C\",IF('Work Days Salary'!$D$22>0,\"Review Work Days Tap C\",'Work Days Salary'!$E$22)))","v":0}]
[22,"Salary for New Hires, Returning Employees or Payoffs",null,null,null,null,null,{"$f":"IF(H69,IF(H70>0,H70*H69,IF(H69>0,H71*H69,0)))","v":false}]
[23,"Remaining Bi-Monthly Pay Periods to Pay"]
[24,"Bi-Monthly Pay Period Rate  \"Formula\" ----->> Line 20 / Line 21",null,null,null,null,null,{"$f":"IF(H73=\"\",0,+H72/H73)","v":0}]
[]
[25,"1st OR Last Paycheck "]
[]
[null,"Reviewed by"]
[null,"Employee Signature",null,null,null,null,null,null,null,"Revised --->>",null,"2018-08-09"]
[null,null,null,null,null,null,null,null,null,"Revision # --->>",null,42]
[null,"Por Vida Representative",null,null,null,null,null,null,null,"Date Signed --->>"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Click for Drop Down List"]
[null,null,null,null,null,null,"Amout Earned",null,null,{"$f":"+H72","v":false},null,null,null,null,"002 - Art Therapist"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"003 - Asst Principal"]
[null,null,null,null,null,null,"Amount Paid","09",15,0,null,null,null,null,"004 - Asst Superintendent"]
[null,null,null,null,null,null,null,null,30,null,null,null,null,null,"005 - Psychological Associate"]
[null,null,null,null,null,null,null,10,15,null,null,null,null,null,"006 - Audiologist"]
[null,null,null,null,null,null,null,null,31,null,null,null,null,null,"007 - Corrective Therapist"]
[null,null,null,null,null,null,null,11,15,null,null,null,null,null,"008 - Counselor"]
[null,null,null,null,null,null,null,null,"30",null,null,null,null,null,"011 - Educational Diagnostician"]
[null,null,null,null,null,null,null,"12","15",null,null,null,null,null,"012 - District Instructional Program Director"]
[null,null,null,null,null,null,null,null,"31",null,null,null,null,null,"013 - Librarian"]
[null,null,null,null,null,null,null,"01","15",null,null,null,null,null,"015 - Music Therapist"]
[null,null,null,null,null,null,null,null,"31",null,null,null,null,null,"016 - Occupational Therapist"]
[null,null,null,null,null,null,null,"02","15",null,null,null,null,null,"017 - Certified Orientation & Mobility Specialist"]
[null,null,null,null,null,null,null,null,"28",null,null,null,null,null,"018 - Physical Therapist"]
[null,null,null,null,null,null,null,"03","15",null,null,null,null,null,"019 - Physician"]
[null,null,null,null,null,null,null,null,"31",null,null,null,null,null,"020 - Principal"]
[null,null,null,null,null,null,null,"04","15",null,null,null,null,null,"021 - Recreational Therapist"]
[null,null,null,null,null,null,null,null,"30",null,null,null,null,null,"022 - School Nurse"]
[null,null,null,null,null,null,null,"05","15",null,null,null,null,null,"023 - LSSP Psychologist"]
[null,null,null,null,null,null,null,null,"31",null,null,null,null,null,"024 - Social Worker"]
[null,null,null,null,null,null,null,"06","15",null,null,null,null,null,"026 - Speech Therapist"]
[null,null,null,null,null,null,null,null,"30",null,null,null,null,null,"027 - Superintendent"]
[null,null,null,null,null,null,null,"07","15",null,null,null,null,null,"028 - Teacher Supervisor"]
[null,null,null,null,null,null,null,null,"31",null,null,null,null,null,"030 - Truant Officer"]
[null,null,null,null,null,null,null,"08","15",null,null,null,null,null,"032 - Work-Based Learning Site Coordinator"]
[null,null,null,null,null,null,null,null,"31",null,null,null,null,null,"033 - Educational Aide"]
[null,null,null,null,null,null,"Amount Paid",null,null,{"$f":"SUM(J104:J127)","v":0},null,null,null,null,"036 - Certified Intrepreter"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"040 - Athletic Director"]
[null,null,null,null,null,null,"Amount Due",null,null,{"$f":"+J102-J128","v":0},null,null,null,null,"041 - Teacher Facilitator"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"042 - Teacher Appraiser"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"043 - Business Manager"]
[null,null,null,null,null,null,"Normal Pay for Each Pay period",null,null,1683.22,null,null,null,null,"044 - Tax Assessor"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"045 - Director of Personnel/HR"]
[null,null,null,null,null,null,"Factor",null,null,{"$f":"+J130/J133","v":0},null,null,null,null,"047 - Substitute Teacher"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"054 - Department Head"]
[null,null,null,null,null,null,"Amount on Check",null,null,{"$f":"+J133*J135","v":0},null,null,null,null,"055 - Registrar"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"056 - Athletic Trainer"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"058 - Other Campus Professional Personnel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"060 - Executive Director"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"061 - Assistant Exectutive Director"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"062 - Component/Dept Director"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"063 - Coordinator/Manager/Supervisor"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"064 - Specialist/ Consultant"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"065 - Field Service Agent"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"079 - Other Education Service Center"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"087 - Teacher"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"100 - Instructional Materials Coord."," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"101 - Legal Services"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"102 - Communication Professional"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"103 - Research/Evaluation Prof."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"104 - Internal Auditor"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"105 - Security"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"106 - Dist./Campus Information Tech. Prof."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"107 - Food Service Professional"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"108 - Transportation "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"109 - Athletics"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"110 - Custodial"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"111 - Maintenance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"112 - Business Service Profssional"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"113 - Other District Exempt Prof. Auxiliary (non-instructional)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"114 - Other Campus Exempt Prof. Auxiliary"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"201 - Business/Finance (A/P, PR Clerk)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"202 - Campus Office/Clerical (Registrar, Secretary, etc) "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"203 - Central Office/ Clerical"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"204 - Child Nutrition"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"205 - Human Resources"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"206 - Information Technology"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"207 - Campus Technology Specialist"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"213 - Custodial"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"214 - Maintenance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"215 - Plumber"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"216 - Painter"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"217 - HVAC"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"218 - Electrician"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"219 - Warehouse"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"220 - Safety/Security"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"221 - Transportation"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"222 - Other Non-Exempt Auxiliary"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pick One"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1 - Professional"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2 - Teacher/Librarian"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3 - Support Staff"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4 - Bus Driver"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5 - Nurse/Counselor"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6 - Peace Officer"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7 - Food Service"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pick One"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ESL Stipend"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Special Ed Stipend"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"G&T Stipend"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coaching Stipend"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Master Degree Stipend"]

{"sheet":"Work Days Salary","index":1,"n_rows":37,"n_cols":5,"rows_kept":37,"cut":false,"hidden":false,"merged":[[34,1,34,4],[35,1,35,4],[36,1,36,4],[37,1,37,4],[38,1,38,4],[25,1,25,4],[27,1,27,4],[32,1,32,4],[33,1,33,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[4,0,4,4],[24,1,24,4],[26,1,26,4]]}
["Por Vida"]
["Work Day Schedule"]
["Printed"]
[{"$f":"NOW()","v":"2020-08-05T12:37:10.710"}]
[{"$f":"NOW()","v":44048.525818402777}]
[]
[null,null,"A","B","C"]
[null,null,"Work Days","# of Actual Work Days","# of Work Days For"]
[null,"MONTH","Complete Year",null,"Payoff"]
["2020-08-01",{"$f":"+A10","v":"2020-08-01"}]
[{"$f":"DATE(YEAR(A10),MONTH(A10)+1,1)","v":"2020-09-01"},{"$f":"+A11","v":"2020-09-01"}]
["2020-10-01","2020-10-01"]
["2020-11-01","2020-11-01"]
["2020-12-01","2020-12-01"]
["2021-01-01","2021-01-01"]
["2021-02-01","2021-02-01"]
["2021-03-01","2021-03-01"]
["2021-04-01","2021-04-01"]
["2021-05-01","2021-05-01"]
["2021-06-01","2021-06-01"]
[{"$f":"DATE(YEAR(A20),MONTH(A20)+1,1)","v":"2021-07-01"},"2021-07-01"]
[null,"Total Days",{"$f":"SUM(C10:C21)","v":0},{"$f":"SUM(D10:D21)","v":0},{"$f":"SUM(E10:E21)","v":0}]
[]
[]
["COLUMN","A = Please enter the number of days for each month that the employee is scheduled to work, ENTER in August Column A the same number "]
[null,"    of days that were entered for August in Column B IF applicable, if none were Entered in August Column B,  then Estimate the number of "]
[null,"    days for August in Column A."]
[]
[null,null,"10 Month Employee  = 190 days for Teachers and Instructional Staff"]
[null,null,"11 Month Employee  = 200 up to 205 days for Principals, campus administrative staff, coach and Janitor"]
[null,null,"12 Month Employee  = 233 days for Central Administation"]
[]
[]
[null,"B = Please enter the number of days for each month that the employee will work starting with the month the employee starts."]
[]
[]
[null,"C = Please enter the number of days for each month that the employee ACTUALLY WORKED."]

{"sheet":"Work Days Hourly","index":2,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":false,"merged":[[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[4,0,4,4],[30,1,30,4],[24,1,24,4],[26,1,26,4],[27,1,27,4],[28,1,28,4],[29,1,29,4]]}
["Por Vida"]
["Work Day Schedule"]
["Printed"]
[{"$f":"NOW()","v":"2020-08-05T12:37:10.710"}]
[{"$f":"NOW()","v":44048.525818402777}]
[]
[null,null,"A","B","C"]
[null,null,"Work Days","# of Actual Work Days","# of Work Days For"]
[null,"MONTH","Complete Year",null,"Payoff"]
["2020-08-01",{"$f":"+A10","v":"2020-08-01"}]
[{"$f":"DATE(YEAR(A10),MONTH(A10)+1,1)","v":"2020-09-01"},{"$f":"+A11","v":"2020-09-01"}]
["2020-10-01","2020-10-01"]
["2020-11-01","2020-11-01"]
["2020-12-01","2020-12-01"]
["2021-01-01","2021-01-01"]
["2021-02-01","2021-02-01"]
["2021-03-01","2021-03-01"]
["2021-04-01","2021-04-01"]
["2021-05-01","2021-05-01"]
["2021-06-01","2021-06-01"]
[{"$f":"DATE(YEAR(A20),MONTH(A20)+1,1)","v":"2021-07-01"},"2021-07-01"]
[null,"Total Days",{"$f":"SUM(C10:C21)","v":0},{"$f":"SUM(D10:D21)","v":0},{"$f":"SUM(E10:E21)","v":0}]
[]
[]
["COLUMN","A = N/A"]
[]
[null,"B = Please enter the number of days for each month that the employee will work starting with the month the employee starts."]
[]
[null,"C = Please enter the number of days for each month that the employee ACTUALLY WORKED."]

{"sheet":"Payoff","index":3,"n_rows":36,"n_cols":2,"rows_kept":36,"cut":false,"hidden":false,"merged":[[0,0,0,2]]}
["Payoff Calculation"]
["Name:",{"$f":"+Recap!F16","v":"Employee's Name"}]
["Days:"]
["Amount Earned:",{"$f":"+Recap!H72","v":false}]
[]
["Amount Paid:"]
[]
["2018-09-15",0]
[{"$f":"+A8+15","v":"2018-09-30"},0]
[{"$f":"+A9+15","v":"2018-10-15"},0]
[{"$f":"+A10+16","v":"2018-10-31"},0]
["2018-11-15",0]
["2018-11-30",0]
["2018-12-15",0]
[{"$f":"+A14+16","v":"2018-12-31"},0]
["2019-01-15",0]
[{"$f":"+A16+16","v":"2019-01-31"},0]
["2019-02-15",0]
[{"$f":"+A18+13","v":"2019-02-28"},0]
["2019-03-15",0]
[{"$f":"+A20+16","v":"2019-03-31"},0]
["2019-04-15",0]
["2019-04-30",0]
["2019-05-15",0]
["2019-05-30",0]
[{"$f":"+A25+16","v":"2019-06-15"},0]
["2019-06-30",0]
["2019-07-15",0]
[{"$f":"+A28+16","v":"2019-07-31"},0]
["2019-08-15",0]
[{"$f":"+A30+16","v":"2019-08-31"},0]
["Paid: ",{"$f":"SUM(B8:B31)","v":0}]
[]
["Payoff Amount:",{"$f":"+B4-B32","v":0}]
["Remaining pay checks:",1]
["GROSS",{"$f":"+B34/B35","v":0}]

{"sheet":"Role Ids","index":4,"n_rows":189,"n_cols":4,"rows_kept":189,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"l"]

{"sheet":"ECF Works Day Understanding","index":5,"n_rows":28,"n_cols":1,"rows_kept":28,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
["Employee Change Form \"ECF\"  Work Days Understanding"]
[]
[]
["The Employee Change Form has been explained to me.  I understand that I am"]
["getting paid for days that are outlined on the \"Worked Days Salary or Work Days Hourly Tab\"."]
["I understand if I leave Por Vida Academy, voluntarily or involuntarily, my remaining pay "]
["will be effected by any days I have not worked."]
[]
[]
[" "]
[]
[]
["________________________________"]
["Employee Name"]
[]
["________________________________"]
["Por Vida Representative"]
[]
[]
["________________________________"]
["Date Signed"]

{"sheet":"PR Deduction Agreement","index":6,"n_rows":43,"n_cols":3,"rows_kept":43,"cut":false,"hidden":false,"merged":[[7,0,7,2]]}
[]
[]
[]
[]
[]
[]
[]
["Payroll Deduction Authorization Agreement"]
[]
[]
["I, ____________________, understand and give permission to my employer, Por Vida Inc., to deduct"]
["monies from my paycheck to pay on my behalf for any outstanding balances such as; payroll "]
["advances, travel advances, cafeteria meal balances, non-sufficient fund charges, equipment charges,"]
["stop payment fees or any other outstanding balance I may owe the school district."]
[]
[]
["_________________________________                              _____________________"]
["Employee Signature                                                                Date               "]
[]
["_________________________________                              _____________________"]
["Por Vida Inc. - Director of H/R                                                 Date           "]
[]
["__________________________________________________________________"]
["Optional Payroll Deductions Authorization"]
[]
["I, _____________________, authorize Por Vida, Inc. to deduct from my payroll check the amount of "]
["$_____________ (monthly) for the following reason. "]
[]
["Description","Start Date","End Date"]
[]
[]
[]
[]
[]
["_________________________________                              _____________________"]
["Employee Signature                                                ","                           Date"]
[]
["________________________________                              _____________________"]
["Por Vida Inc. - Director of H/R                     ","                           Date"]
[]
[]
[]
["HRF – 3315"]

{"sheet":"1st Paycheck","index":7,"n_rows":18,"n_cols":6,"rows_kept":18,"cut":false,"hidden":false,"merged":[[15,3,15,4],[18,3,18,4],[19,3,19,4],[7,3,7,4],[7,5,7,10],[8,3,8,4],[8,5,8,10],[9,0,9,10],[13,3,13,4],[10,0,10,10],[6,3,6,4],[6,5,6,10],[1,0,2,11],[4,0,4,1],[4,3,4,4],[5,3,5,4],[5,5,5,10]]}
[]
["New Hire 1st paycheck"]
[]
["The schedule below will be used to determine the New Hire 1st pay day based on the date of hire, if hired mid-year (Section 25 of the ECF)"]
["Start date",null,"All Employee Paper Work (See Below)"]
["From","To","Due By:","1st pay check on ",null,"Example"]
["1st","7th","3 Business Days After Start Date","15th of the current month*",null,"i.e. employee hired between Jan 1-7, 1st paycheck will be Jan 15th "]
["8th","22nd","3 Business Days After Start Date","End of the current month* ",null,"i.e. employee hired between Jan 8-22, 1st paycheck will be Jan 31st"]
["23rd","31st","3 Business Days After Start Date","15th of the following month*",null,"i.e. employee hired between Jan 23-31, 1st pay check will be Feb 15th "]
["* Schedule applicable if all payerwork is submitted correctly and on time."]
["* Schedule does not apply to the new school year hires, their first check is Aug 31st"]
[]
[]
[]
[null,null,"I have read, understand, and agree to the information presented above."]
[]
[]
[null,null,"Employee Signature",null,"Date"]