{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Recap","Work Days Salary","Work Days Hourly","Payoff","Role Ids","ECF Works Day Understanding","PR Deduction Agreement"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"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":185,"n_cols":16,"rows_kept":185,"cut":false,"hidden":false,"merged":[[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],[36,7,36,9],[40,7,40,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],[47,1,47,6],[68,1,68,6],[69,1,69,6],[53,1,53,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],[35,7,35,9],[65,3,65,6],[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],[34,7,34,9],[67,1,67,6],[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],[46,1,46,6],[44,1,44,6],[48,1,48,6]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,"EMPLOYEE CHANGE FORM"]
[]
["To: Angela Cruz-Garcia, HR Admin",null,null,null,null,null,null,null,null,"Printed ----->>>",null,{"$f":"NOW()","v":"2022-07-25T11:37:14.920"}]
["From: --------->>>",null,"Supervisor's Name",null,null,null,null,null,null,null,null,{"$f":"NOW()","v":44767.484200462961}]
[]
["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",null,null,null,null,null,8]
[11,"Hourly Daily Rate \"Formula\" ----->> Line 7 X  Line 8",null,null,null,null,null,{"$f":"L33/'Work Days Hourly'!C22","v":{"$error":"#DIV/0!"}}]
[12,"Work days to be worked ",null,null,null,null,null,{"$f":"IF('Work Days Hourly'!D22>0,'Work Days Hourly'!D22,0)","v":0}]
[11,"\"Actual\" Worked days for Payoffs",null,null,null,null,null,{"$f":"IF('Work Days Hourly'!E22>0,'Work Days Hourly'!E22,0)","v":0}]
[12,"Annual \"Hourly\" Salary OR Amount Earned for Payoffs",null,null,null,null,null,{"$f":"L33+IF(H51>0,H51*H50,H52*H50)","v":{"$error":"#DIV/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,"2022-07-25"]
[null,null,null,null,null,null,null,null,null,"Revision # --->>",null,44]
[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/Deputy 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 - School 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/Visiting Teacher"]
[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,"040 - Athletic Director"]
[null,null,null,null,null,null,"Amount Paid",null,null,{"$f":"SUM(J104:J127)","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,"Amount Due",null,null,{"$f":"+J102-J128","v":0},null,null,null,null,"043 - Business Manager"]
[null,null,null,null,null,null,null,null,null,null,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,"Normal Pay for Each Pay period",null,null,1683.22,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,"Factor",null,null,{"$f":"+J130/J133","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,"Amount on Check",null,null,{"$f":"+J133*J135","v":0},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,"115 - Psychiatric Nurse"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"116 - Licensed Clinical Social Worker"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"117 - Licensed Professional Counselor"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"118 - Licensed Marriage and Family therapist"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"119 - Family and Community Liason"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"120 - Instructional Coach"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"033 - Educational Aide"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"036 - Certified Interpreter"]
[]
[]
[]
[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":[[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],[34,1,34,4],[35,1,35,4],[36,1,36,4],[37,1,37,4],[38,1,38,4]]}
["Por Vida"]
["Work Day Schedule"]
["Printed"]
[{"$f":"NOW()","v":"2022-07-25T11:37:14.920"}]
[{"$f":"NOW()","v":44767.484200462961}]
[]
[null,null,"A","B","C"]
[null,null,"Work Days","# of Actual Work Days","# of Work Days For"]
[null,"MONTH","Complete Year",null,"Payoff"]
["2022-08-01",{"$f":"+A10","v":"2022-08-01"}]
[{"$f":"DATE(YEAR(A10),MONTH(A10)+1,1)","v":"2022-09-01"},{"$f":"+A11","v":"2022-09-01"}]
["2022-10-01","2022-10-01"]
["2022-11-01","2022-11-01"]
["2022-12-01","2022-12-01"]
["2023-01-01","2023-01-01"]
["2023-02-01","2023-02-01"]
["2023-03-01","2023-03-01"]
["2023-04-01","2023-04-01"]
["2023-05-01","2023-05-01"]
["2023-06-01","2023-06-01"]
[{"$f":"DATE(YEAR(A20),MONTH(A20)+1,1)","v":"2023-07-01"},"2023-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":[[26,1,26,4],[27,1,27,4],[28,1,28,4],[29,1,29,4],[30,1,30,4],[24,1,24,4],[0,0,0,4],[1,0,1,4],[2,0,2,4],[3,0,3,4],[4,0,4,4]]}
["Por Vida"]
["Work Day Schedule"]
["Printed"]
[{"$f":"NOW()","v":"2022-07-25T11:37:14.920"}]
[44767.484200462961]
[]
[null,null,"A","B","C"]
[null,null,"Work Days","# of Actual Work Days","# of Work Days For"]
[null,"MONTH","Complete Year",null,"Payoff"]
["2022-08-01",{"$f":"+A10","v":"2022-08-01"}]
[{"$f":"DATE(YEAR(A10),MONTH(A10)+1,1)","v":"2022-09-01"},"2022-09-01"]
["2022-10-01","2022-10-01"]
["2022-11-01","2022-11-01"]
["2022-12-01","2022-12-01"]
["2023-01-01","2023-01-01"]
["2023-02-01","2023-02-01"]
["2023-03-01","2023-03-01"]
["2023-04-01","2023-04-01"]
["2023-05-01","2023-05-01"]
["2023-06-01","2023-06-01"]
["2023-07-01","2023-07-01"]
[null,"Total Days",{"$f":"SUM(C10:C21)","v":0},0,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:"]
[]
["2022-09-15",0]
[{"$f":"+A8+15","v":"2022-09-30"},0]
[{"$f":"+A9+15","v":"2022-10-15"},0]
[{"$f":"+A10+16","v":"2022-10-31"},0]
["2022-11-15",0]
["2022-11-30",0]
["2022-12-15",0]
[{"$f":"+A14+16","v":"2022-12-31"},0]
["2023-01-15",0]
[{"$f":"+A16+16","v":"2023-01-31"},0]
["2023-02-15",0]
[{"$f":"+A18+13","v":"2023-02-28"},0]
["2023-03-15",0]
[{"$f":"+A20+16","v":"2023-03-31"},0]
["2023-04-15",0]
["2023-04-30",0]
["2023-05-15",0]
["2023-05-30",0]
[{"$f":"+A25+16","v":"2023-06-15"},0]
["2023-06-30",0]
["2023-07-15",0]
[{"$f":"+A28+16","v":"2023-07-31"},0]
["2023-08-15",0]
[{"$f":"+A30+16","v":"2023-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":77,"n_cols":5,"rows_kept":77,"cut":false,"hidden":false,"merged":[[74,0,74,5],[75,0,75,5],[76,0,76,5],[68,1,68,4],[69,1,69,4],[70,1,70,4],[71,1,71,4],[72,1,72,4],[73,1,73,4],[62,1,62,4],[63,1,63,4],[64,1,64,4],[65,1,65,4],[66,1,66,4],[67,1,67,4],[56,1,56,4],[57,1,57,4],[58,1,58,4],[59,1,59,4],[60,1,60,4],[61,1,61,4],[50,1,50,4],[51,1,51,4],[52,1,52,4],[53,1,53,4],[54,1,54,4],[55,1,55,4],[44,1,44,4],[45,1,45,4],[46,1,46,4],[47,1,47,4],[48,1,48,4],[49,1,49,4],[38,1,38,4],[39,1,39,4],[40,1,40,4],[41,1,41,4],[42,1,42,4],[43,1,43,4],[32,1,32,4],[33,1,33,4],[34,1,34,4],[35,1,35,4],[36,1,36,4],[37,1,37,4],[26,1,26,4],[27,1,27,4],[28,1,28,4],[29,1,29,4],[30,1,30,4],[31,1,31,4],[20,1,20,4],[21,1,21,4],[22,1,22,4],[23,1,23,4],[24,1,24,4],[25,1,25,4],[14,1,14,4],[15,1,15,4],[16,1,16,4],[17,1,17,4],[18,1,18,4],[19,1,19,4],[8,1,8,4],[9,1,9,4],[10,1,10,4],[11,1,11,4],[12,1,12,4],[13,1,13,4],[2,1,2,4],[3,1,3,4],[4,1,4,4],[5,1,5,4],[6,1,6,4],[7,1,7,4]]}
["Code Table Id","Name","XML Name","Date Issued","Date Updated"]
["C021","ROLE-ID","TX-StaffRoleType","1987-04-02","2021-09-01"]
["Code","Translation"]
[null,"PROFESSIONAL"]
[2,"Art Therapist:\nServes as Art Therapist"]
[3,"Assistant Principal:\nAssists the principal of a particular campus in any duties the principal may deem appropriate"]
[4,"Assistant/Associate/Deputy Superintendent:\nAssists the superintendent of a particular school district in any duties the superintendent may deem appropriate. Persons assigned to this role usually perform functions associated with more than one campus"]
[5,"Psychological Associate:\nServes under the Licensed Specialist in School Psychology (LSSP) or psychologist to provide guidance and counseling services to students"]
[6,"Audiologist:\nThe person who provides audiological services to students with hearing impairments"]
[7,"Corrective Therapist:\nServes as Corrective Therapist"]
[8,"School Counselor:\nProvides guidance and counseling services to students"]
[11,"Educational Diagnostician:\nProvides educational diagnostic services and individualized education program development"]
[12,"District Instructional Program Director or Executive Director:\nServes under the superintendent, or higher grade instructional administrative officer, as the key specialist for a major instructional, instructional related, or pupil service program. Responsibilities may include curriculum development or supervision of programs or personnel whose assignments require certification or licensure. Only degreed, certified personnel may be placed in this\ncategory. Examples include, but are not limited to staff serving as Director of Guidance and Counseling, Director of Curriculum, Director of Librarians, Director of Bilingual/ESL, Career and Technical Director, Director of Special Ed, and Director of Social Studies"]
[13,"Librarian:\nSupervises library/learning resources center, or functions as one of several librarians, or learning resource specialists, on a major campus"]
[15,"Music Therapist:\nServes as Music Therapist"]
[16,"Occupational Therapist:\nServes as Occupational Therapist"]
[17,"Certified Orientation and Mobility Specialist (COMS)"]
[18,"Physical Therapist:\nServes as Physical Therapist"]
[19,"Physician:\nServes as school Physician"]
[20,"Principal:\nServes as the instructional leader of the school whose duties include selecting teachers for the campus, setting education objectives, developing budgets for the campus, and working with school professionals to prepare individual development plans"]
[21,"Recreational Therapist:\nServes as Recreational Therapist"]
["Code","Translation"]
[22,"School Nurse:\nA person that complies with TEC 21.003(b), \"is licensed by the state agency that licenses that profession\", [Nurse Practitioner (NP), Registered Nurse (RN), Licensed Vocational Nurse (LVN)] is employed/contracted by the school district, and whose primary job responsibility is that of school nurse. Only persons licensed by the state agency that licenses nurses may be employed as a school nurse"]
[23,"LSSP/Psychologist:\nServes as Licensed Specialist in School Psychology/Psychologist"]
[24,"Social Worker:\nServes as the school social worker to provide comprehensive social services as a part of an education team. Social workers must be licensed by the Texas State Board of Examiners and must hold a bachelor’s or master’s degree"]
[26,"Speech Therapist/Speech-Language Pathologist:\nServes as provider of speech-language pathology/speech therapy services"]
[27,"Superintendent/Chief Administrative Officer/Chief Executive Officer/President:\nThe educational leader and administrative manager of the school district"]
[28,"Teacher Supervisor:\nProvides consultant services to teachers in a grade level, adjacent grades, in a teaching field, or group of related fields"]
[30,"Truant Officer/Visiting Teacher:\nDirects activities related to promoting and improving school attendance. Such certified staff members provide home, school, and community liaison services"]
[32,"Work-Based Learning Site Coordinator:\nThe code for a Career and Technical Education teacher (087) assigned to career preparation work-based learning experiences is changed from 087 to 032 when visiting a student training site for the purpose of evaluating the student and consulting the employer"]
[40,"Athletic Director:\nUsed only when the staff member with such a title is performing administrative tasks directing the athletic program.  Responsibilities may include supervision of coaches and other personnel in the athletic program.  It is not used when coaching duties are being performed"]
[41,"Teacher Facilitator:\nServes as an exemplary role model in assisting teachers with improving their classroom performance"]
[42,"Teacher Appraiser:\nServes as an appraiser in the Texas Teacher Appraisal System"]
[43,"Business Manager:\nServes as business manager or Chief Financial Officer (CFO)"]
[44,"Tax Assessor And/Or Collector:\nServes as district tax assessor, tax collector, or tax assessor-collector"]
[45,"Director Of Personnel/Human Resources:\nServes as personnel or human resources director"]
[47,"Substitute Teacher:\nA person who serves in a classroom in the absence of a teacher certified for that assignment where the teacher has quit, died, or been terminated; or, a person who is permanently hired to substitute on an as-needed basis.\n(See StaffResponsibilitiesExtension complex type, Data Element Reporting Requirements, Chart A - Coding for Substitute and Absent Regular Staff)"]
[54,"Department Head:\nServes as head or chairman of a subject area department on a campus"]
[55,"Registrar:\nServes as school or district registrar"]
[56,"Athletic Trainer:\nServes as a trainer in the athletics program"]
["Code","Translation"]
[60,"Executive Director:\nServes as the chief executive officer of an education service center"]
[61,"Assistant/Associate/Deputy Executive Director:\nAssists the education service center executive director"]
[62,"Component/Department Director:\nDirects and manages the program activities of a component or department of an education service center"]
[63,"Coordinator/Manager/Supervisor:\nCoordinates, manages, and/or supervises specific programs and services of an education service center"]
[64,"Specialist/Consultant:\nProvides technical assistance and professional development in various areas of an education service center"]
[65,"Field Service Agent:\nProvides coordinated assistance to districts and campuses"]
[79,"Other Education Service Center Professional Personnel:\nServes as professional staff member at an ESC. Do not use this role unless no other role applies to the staff member"]
[87,"Teacher:\n(combination of former codes 025 and 029)\nA professional employee who is required to hold a valid teacher certificate or permit in order to perform some type of instruction to students"]
[100,"Instructional Materials Coordinator"]
[101,"Legal Services"]
[102,"Communications Professional (Including but not limited to Public Information Officer, Community Liaison)"]
[103,"Research/Evaluation Professional (Including but not limited to Analysis, Grant Writers)"]
[104,"Internal Auditor"]
[105,"Security (Including but not limited to Chief of Police, Investigators, Police Officers)"]
[106,"District/Campus Information Technology Professional (Including but not limited to Programmer/Analyst, Network Specialist, Database Administrator, PEIMS Coordinator, Other)"]
[107,"Food Service Professional (including but not limited to Dietician)"]
[108,"Transportation"]
[109,"Athletics (Other than Athletic Director)"]
[110,"Custodial – Staff serving in a professional/management role"]
[111,"Maintenance – Staff serving in a professional/management role"]
[112,"Business Services Professional (Including but not limited to Accounting, Budget, Professional Payroll Staff)"]
[113,"Other District Exempt Professional Auxiliary:\nAssign this role to district staff who are professional-level, non-instructional staff who cannot be classified in any other role regardless of where assigned. Physical work location is not a determining factor."]
[114,"Other Campus Exempt Professional Auxiliary:\nServes as a professional staff member at one or more campuses. Do not use this role unless no other role applies to the staff member.\nSome examples of staff who are to be shown with this role are:\n• campus volunteer coordinators\n• dean and\n• instructional officers assigned to a campus"]
[115,"Psychiatric Nurse"]
[116,"Licensed Clinical Social Worker"]
[117,"Licensed Professional Counselor"]
["Code","Translation"]
[118,"Licensed Marriage and Family Therapist"]
[119,"Family and Community Liaison"]
[120,"Instructional Coach"]
[null,"PARAPROFESSIONAL/OTHER"]
[33,"Educational Aide:\nPerforms routine classroom tasks under the general supervision of a certified teacher or teaching team"]
[36,"Certified Interpreter:\nA state or nationally certified interpreter for the deaf who translates/transliterates for students who are deaf or hard of hearing, according to ARD committee recommendations.\n(Certified interpreters may be either professional or para-professional, depending on district classification)"]
["This code table is used in the following data element(s):                                       This code table is used in the following complex type(s):"]
["E0721 ROLE-ID                                                                                                       30090 StaffResponsibilitiesExtension"]
["30305 / 50300 TeacherSectionAssociationExtension"]

{"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"]