{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Certificated-Monthly","Classified-Monthly","Classified (Overtime)","Adjunct-Cert (Hourly)","Unclassified (Hourly)","Student Worker"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"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":"Certificated-Monthly","index":0,"n_rows":38,"n_cols":10,"rows_kept":38,"cut":false,"hidden":false,"merged":[[1,1,1,4],[5,7,5,9],[6,7,6,9],[7,7,7,9],[4,7,4,9],[3,7,3,9],[2,6,2,9],[1,6,1,9],[7,1,7,4],[2,1,2,4],[4,2,4,4],[5,2,5,4],[6,2,6,4],[3,2,3,4],[9,6,9,9],[9,1,9,4],[8,6,8,9],[8,1,8,4]]}
[]
[null,"CERTIFICATED MONTHLY",null,null,null,null,"Enter Split Funded Information Here:"]
[null,"Enter Budgeting Data Here:",null,null,null,null,"Use only if salary is split between managers"]
[null,"Title of Position:"]
[null,"Employee Salary:",null,null,null,null,"Org Code","Split Percentage"]
[null,"Include Health & Welfare (Y/N):","Y"]
[null,"Split Funded (Y/N):","n"]
[null,{"$f":"IF($C$6=\"Y\",\"Only Answer 'Y' for Health and Welfare if Employee is 75% Full Time or More\",IF($C$6=\"N\",\"\",IF($C$6=\"\",\"\",\"ERROR: Please Enter 'Y' or 'N' in Health and Welfare Cell\")))","v":"Only Answer 'Y' for Health and Welfare if Employee is 75% Full Time or More"}]
[null,{"$f":"IF($C$7=\"Y\",\"\",IF($C$7=\"N\",\"\",IF($C$7=\"\",\"\",\"ERROR: Please Enter 'Y' or 'N' in Split Funded Section\")))","v":""},null,null,null,null,{"$f":"IF(SUM(H6:H8)=1,\"\",IF(SUM(H6:H8)=0,\"\",\"Split Percentages must total to 100%\"))","v":""}]
[null,"Summary",null,null,null,null,"Split Funded Summary"]
[null,"Account Description","Account Code","Percentage","Amount",null,"Org Code (per Org)",{"$f":"IF(G6<>\"\",G6,\"\")","v":""},{"$f":"IF(G7<>\"\",G7,\"\")","v":""},{"$f":"IF(G8<>\"\",G8,\"\")","v":""}]
[]
[null,"Salary",null,null,{"$f":"$C$5","v":0},null,"Salary (per Org)",{"$f":"($H$6*$E13)","v":0},{"$f":"($H$7*$E13)","v":0},{"$f":"($H$8*$E13)","v":0}]
[]
[null,"STRS","311100/313000",0.191,{"$f":"D15*E$13","v":0},null,"STRS (per Org)",{"$f":"($H$6*$E15)","v":0},{"$f":"($H$7*$E15)","v":0},{"$f":"($H$8*$E15)","v":0}]
[null,"Medicare","335100/337000",1.4500000000000001E-2,{"$f":"D16*E$13","v":0},null,"Medicare (per Org)",{"$f":"($H$6*$E16)","v":0},{"$f":"($H$7*$E16)","v":0},{"$f":"($H$8*$E16)","v":0}]
[null,"Health & Welfare Costs","341100/343000",1,{"$f":"IF(C6=\"Y\",D17*C38,\"\")","v":24437},null,"Health & Welfare (per Org)",{"$f":"IFERROR($H$6*$E17,\"\")","v":0},{"$f":"IFERROR($H$7*$E17,\"\")","v":0},{"$f":"IFERROR($H$8*$E17,\"\")","v":0}]
[null,"SUI","351100/353100",5.0000000000000001E-4,{"$f":"D18*E$13","v":0},null,"SUI (per Org)",{"$f":"($H$6*$E18)","v":0},{"$f":"($H$7*$E18)","v":0},{"$f":"($H$8*$E18)","v":0}]
[null,"W/C","361100/363000",0.02,{"$f":"D19*E$13","v":0},null,"W/C (per Org)",{"$f":"($H$6*$E19)","v":0},{"$f":"($H$7*$E19)","v":0},{"$f":"($H$8*$E19)","v":0}]
[null,"CIL","371100/373000"," ",0,null,"CIL (per Org)",{"$f":"($H$6*$E20)","v":0},{"$f":"($H$7*$E20)","v":0},{"$f":"($H$8*$E20)","v":0}]
[null,"Total Benefits"," ",null,{"$f":"SUM($E15:$E20)","v":24437},null,"Total Benfits (per Org)",{"$f":"($H$6*$E21)","v":0},{"$f":"($H$7*$E21)","v":0},{"$f":"($H$8*$E21)","v":0}]
[]
[null,"Computers","641100/641300",null,1750,null,"Computers",{"$f":"($H$6*$E23)","v":0},{"$f":"($H$7*$E23)","v":0},{"$f":"($H$8*$E23)","v":0}]
[null,"District Telephone","430100",null,300,null,"District Telephone",0,0,0]
[null,"Local Printer","430100",null,250,null,"Local Printer",0,0,0]
[null,"Mileage","522000",null,100,null,"Mileage",0,0,0]
[null,"Office Supplies","430100",null,600,null,"Office Supplies",0,0,0]
[null,"Computer Software (Licensing Agreement)","430200",null,500,null,"Personal Computer Software",0,0,0]
[null,"Space (Furniture, Cabling, and IT)",null,null,7500,null,"Space (Furniture, Cabling, and IT)",{"$f":"($H$6*E29)","v":0},{"$f":"($H$7*E29)","v":0},{"$f":"($H$8*E29)","v":0}]
[null,"Training",null,null,1000,null,"Training",{"$f":"($H$6*$E30)","v":0},{"$f":"($H$7*$E30)","v":0},{"$f":"($H$8*$E30)","v":0}]
[null,"Travel","521000",null,500,null,"Travel",{"$f":"($H$6*$E31)","v":0},{"$f":"($H$7*$E31)","v":0},{"$f":"($H$8*$E31)","v":0}]
[null,"Utilities",null,null,250,null,"Utilities",{"$f":"($H$6*$E32)","v":0},{"$f":"($H$7*$E32)","v":0},{"$f":"($H$8*$E32)","v":0}]
[]
[null,"New Position Costs",null,null,{"$f":"SUM($E23:$E32)","v":12750},null,"Total Administrative Cost",{"$f":"($H$6*$E34)","v":0},{"$f":"($H$7*$E34)","v":0},{"$f":"($H$8*$E34)","v":0}]
[]
[null,"Total Salary & Benefits",null,null,{"$f":"SUM($E13,$E21,E34)","v":37187},null,"Total Salary & Benefits (per Org)",{"$f":"($H$6*$E36)","v":0},{"$f":"($H$7*$E36)","v":0},{"$f":"($H$8*$E36)","v":0}]
[]
[null,"*Health & Welfare Annual Costs",24437]

{"sheet":"Classified-Monthly","index":1,"n_rows":38,"n_cols":10,"rows_kept":38,"cut":false,"hidden":false,"merged":[[5,7,5,9],[5,2,5,4],[9,1,9,4],[9,6,9,9],[6,2,6,4],[7,1,7,4],[8,1,8,4],[6,7,6,9],[7,7,7,9],[8,6,8,9],[1,1,1,4],[2,1,2,4],[3,2,3,4],[4,2,4,4],[1,6,1,9],[2,6,2,9],[3,7,3,9],[4,7,4,9]]}
["g"]
[null,"CLASSIFIED MONTHLY",null,null,null,null,"Enter Split Funded Information Here:"]
[null,"Enter Budgeting Data Here:",null,null,null,null,"Use only if salary is split between managers"]
[null,"Title of Position:"]
[null,"Employee Salary:",null,null,null,null,"Org Code","Split  Percentage"]
[null,"Include Health & Welfare (Y/N):","Y"]
[null,"Split Funded (Y/N):","n"]
[null,{"$f":"IF($C$6=\"Y\",\"Only Answer 'Y' for Health and Welfare if Employee is 75% Full Time or More\",IF($C$6=\"N\",\"\",IF($C$6=\"\",\"\",\"ERROR: Please Enter 'Y' or 'N' in Health and Welfare Cell\")))","v":"Only Answer 'Y' for Health and Welfare if Employee is 75% Full Time or More"}]
[null,{"$f":"IF($C$7=\"Y\",\"\",IF($C$7=\"N\",\"\",IF($C$7=\"\",\"\",\"ERROR: Please Enter 'Y' or 'N' in Split Funded Section\")))","v":""},null,null,null,null,{"$f":"IF(SUM(H6:H8)=1,\"\",IF(SUM(H6:H8)=0,\"\",\"Split Percentages must total to 100%\"))","v":""}]
[null,"Summary",null,null,null,null,"Split Funded Summary"]
[null,"Account Description","Account Code","Percentage","Amount",null,"Org Code (per Org)",{"$f":"IF(G6<>\"\",G6,\"\")","v":""},{"$f":"IF(G7<>\"\",G7,\"\")","v":""},{"$f":"IF(G8<>\"\",G8,\"\")","v":""}]
[]
[null,"Salary",null,null,{"$f":"$C$5","v":0},null,"Salary (per Org)",{"$f":"($H$6*$E13)","v":0},{"$f":"($H$7*$E13)","v":0},{"$f":"($H$8*$E13)","v":0}]
[null,"OASDI","332000",6.2E-2,{"$f":"$D14*$E$13","v":0},null,"OASDI (per Org)",{"$f":"($H$6*$E14)","v":0},{"$f":"($H$7*$E14)","v":0},{"$f":"($H$8*$E14)","v":0}]
[null,"PERS","322000",0.26679999999999998,{"$f":"$D15*$E$13","v":0},null,"PERS (per Org)",{"$f":"($H$6*$E15)","v":0},{"$f":"($H$7*$E15)","v":0},{"$f":"($H$8*$E15)","v":0}]
[null,"Medicare","336000",1.4500000000000001E-2,{"$f":"$D16*$E$13","v":0},null,"Medicare (per Org)",{"$f":"($H$6*$E16)","v":0},{"$f":"($H$7*$E16)","v":0},{"$f":"($H$8*$E16)","v":0}]
[null,"Health & Welfare Costs","342000",1,{"$f":"IF(C6=\"Y\",D17*C38,\"\")","v":24437},null,"Health & Welfare (per Org)",{"$f":"IFERROR($H$6*$E17,\"\")","v":0},{"$f":"IFERROR($H$7*$E17,\"\")","v":0},{"$f":"IFERROR($H$8*$E17,\"\")","v":0}]
[null,"SUI","352000",5.0000000000000001E-4,{"$f":"$D18*$E$13","v":0},null,"SUI (per Org)",{"$f":"($H$6*$E18)","v":0},{"$f":"($H$7*$E18)","v":0},{"$f":"($H$8*$E18)","v":0}]
[null,"W/C","362000",0.02,{"$f":"$D19*$E$13","v":0},null,"W/C (per Org)",{"$f":"($H$6*$E19)","v":0},{"$f":"($H$7*$E19)","v":0},{"$f":"($H$8*$E19)","v":0}]
[null,"CIL","372000"]
[null,"Total Benefits",null,null,{"$f":"SUM($E14:$E19)","v":24437},null,"Total Benfits (per Org)",{"$f":"($H$6*$E21)","v":0},{"$f":"($H$7*$E21)","v":0},{"$f":"($H$8*$E21)","v":0}]
[]
[null,"Computers","641100/641300",null,1750,null,"Computers",{"$f":"($H$6*$E23)","v":0},{"$f":"($H$7*$E23)","v":0},{"$f":"($H$8*$E23)","v":0}]
[null,"District Telephone","430100",null,300,null,"District Telephone",0,0,0]
[null,"Local Printer","430100",null,250,null,"Local Printer",0,0,0]
[null,"Mileage","522000",null,100,null,"Mileage",0,0,0]
[null,"Office Supplies","430100",null,600,null,"Office Supplies",0,0,0]
[null,"Computer Software (Licensing Agreement)","430200",null,500,null,"Personal Computer Software",0,0,0]
[null,"Space (Furniture, Cabling, and IT)",null,null,7500,null,"Space (Furniture, Cabling, and IT)",{"$f":"($H$6*E29)","v":0},{"$f":"($H$7*E29)","v":0},{"$f":"($H$8*E29)","v":0}]
[null,"Training",null,null,1000,null,"Training",{"$f":"($H$6*$E30)","v":0},{"$f":"($H$7*$E30)","v":0},{"$f":"($H$8*$E30)","v":0}]
[null,"Travel","521000",null,500,null,"Travel",{"$f":"($H$6*$E31)","v":0},{"$f":"($H$7*$E31)","v":0},{"$f":"($H$8*$E31)","v":0}]
[null,"Utilities",null,null,250,null,"Utilities",{"$f":"($H$6*$E32)","v":0},{"$f":"($H$7*$E32)","v":0},{"$f":"($H$8*$E32)","v":0}]
[]
[null,"New Position Costs",null,null,{"$f":"SUM($E23:$E32)","v":12750},null,"Total Services and Supplies",{"$f":"($H$6*$E34)","v":0},{"$f":"($H$7*$E34)","v":0},{"$f":"($H$8*$E34)","v":0}]
[]
[null,"Total Salary & Benefits",null,null,{"$f":"SUM($E13,$E21,E34)","v":37187},null,"Total Salary & Benefits (per Org)",{"$f":"($H$6*$E36)","v":0},{"$f":"($H$7*$E36)","v":0},{"$f":"($H$8*$E36)","v":0}]
[]
[null,"*Health & Welfare Annual Costs",24437]

{"sheet":"Classified (Overtime)","index":2,"n_rows":24,"n_cols":10,"rows_kept":24,"cut":false,"hidden":false,"merged":[[7,7,7,9],[8,1,8,4],[8,6,8,9],[9,1,9,4],[9,6,9,9],[7,2,7,4],[4,2,4,4],[4,7,4,9],[5,2,5,4],[5,7,5,9],[6,2,6,4],[6,7,6,9],[1,1,1,4],[1,6,1,9],[2,1,2,4],[2,6,2,9],[3,2,3,4],[3,7,3,9]]}
[]
[null,"CLASSIFIED MONTHLY - OVERTIME",null,null,null,null,"Enter Split Funded Information Here:"]
[null,"Enter Budgeting Data Here:",null,null,null,null,"Use only if salary is split between managers"]
[null,"Title of Position:"]
[null,"Employee Base Rate:",null,null,null,null,"Org Code","Split  Percentage"]
[null,"Employee Overtime Rate:"]
[null,"Overtime Hours:"]
[null,"Split Funded (Y/N):"]
[null,{"$f":"IF($C$8=\"Y\",\"\",IF($C$8=\"N\",\"\",IF($C$8=\"\",\"\",\"ERROR: Please Enter 'Y' or 'N' in Split Funded Section\")))","v":""},null,null,null,null,{"$f":"IF(SUM(H6:H8)=1,\"\",IF(SUM(H6:H8)=0,\"\",\"Split Percentages must total to 100%\"))","v":""}]
[null,"Summary",null,null,null,null,"Split Funded Summary"]
[null,"Account Description","Account Code","Percentage","Amount",null,"Org Code (per Org)",{"$f":"IF(G6<>\"\",G6,\"\")","v":""},{"$f":"IF(G7<>\"\",G7,\"\")","v":""},{"$f":"IF(G8<>\"\",G8,\"\")","v":""}]
[]
[null,"Overtime Pay",null,null,{"$f":"IFERROR($C$6*$C$7,0)","v":0},null,"Overtime Pay (per Org)",{"$f":"($H$6*$E13)","v":0},{"$f":"($H$7*$E13)","v":0},{"$f":"($H$8*$E13)","v":0}]
[null,"OASDI","332000",6.2E-2,{"$f":"$D14*$E$13","v":0},null,"OASDI (per Org)",0,0,0]
[null,"PERS","322000",0.26679999999999998,{"$f":"$D15*$E$13","v":0},null,"STRS (per Org)",0,0,0]
[null,"Medicare","336000/335200",1.4500000000000001E-2,{"$f":"$D16*$E$13","v":0},null,"Medicare (per Org)",0,0,0]
[null,"SUI","352000/351200",5.0000000000000001E-4,{"$f":"$D17*$E$13","v":0},null,"SUI (per Org)",0,0,0]
[null,"W/C","362000/361200",0.02,{"$f":"$D18*$E$13","v":0},null,"W/C (per Org)",0,0,0]
[]
[null,"Total Overtime Benefits",null,null,{"$f":"SUM($E14:$E18)","v":0},null,"Total Overtime Benfits (per Org)",{"$f":"($H$6*$E20)","v":0},{"$f":"($H$7*$E20)","v":0},{"$f":"($H$8*$E20)","v":0}]
[]
[null,"Total Overtime Pay & Benefits",null,null,{"$f":"SUM($E13,$E20,)","v":0},null,"Total Overtime Pay/Ben (per Org)",{"$f":"($H$6*$E22)","v":0},{"$f":"($H$7*$E22)","v":0},{"$f":"($H$8*$E22)","v":0}]
[]
[null,"*Health & Welfare Annual Costs",24437]

{"sheet":"Adjunct-Cert (Hourly)","index":3,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[[9,1,9,4],[6,7,6,9],[7,7,7,9],[8,6,8,9],[9,6,9,9],[6,2,6,4],[7,1,7,4],[8,1,8,4],[4,7,4,9],[5,7,5,9],[1,1,1,4],[2,1,2,4],[5,2,5,4],[3,2,3,4],[4,2,4,4],[1,6,1,9],[2,6,2,9],[3,7,3,9]]}
[]
[null,"ADJUNCT/CERTIFICATED (HOURLY)",null,null,null,null,"Enter Split Funded Information Here:"]
[null,"Enter Budgeting Data Here:",null,null,null,null,"Use only if salary is split between managers"]
[null,"Title of Position:"]
[null,"Employee Rate/hr:",null,null,null,null,"Org Code","Split  Percentage"]
[null,"Hours:"]
[null,"Split Funded (Y/N):"]
[]
[null,{"$f":"IF($C$7=\"Y\",\"\",IF($C$7=\"N\",\"\",IF($C$7=\"\",\"\",\"ERROR: Please Enter 'Y' or 'N' in Split Funded Section\")))","v":""},null,null,null,null,{"$f":"IF(SUM(H6:H8)=1,\"\",IF(SUM(H6:H8)=0,\"\",\"Split Percentages must total to 100%\"))","v":""}]
[null,"Summary",null,null,null,null,"Split Funded Summary"]
[null,"Account Description","Account Code","Percentage","Amount",null,"Org Code (per Org)",{"$f":"IF(G6<>\"\",G6,\"\")","v":""},{"$f":"IF(G7<>\"\",G7,\"\")","v":""},{"$f":"IF(G8<>\"\",G8,\"\")","v":""}]
[]
[null,"Hrs x Rate",null,null,{"$f":"$C$5*$C$6","v":0},null,"Hrs x Rate (per Org)",{"$f":"($H$6*$E13)","v":0},{"$f":"($H$7*$E13)","v":0},{"$f":"($H$8*$E13)","v":0}]
[null,"STRS","311100/313000",0.191,{"$f":"$D14*$E$13","v":0},null,"STRS (per Org)",{"$f":"($H$6*$E14)","v":0},{"$f":"($H$7*$E14)","v":0},{"$f":"($H$8*$E14)","v":0}]
[null,"Medicare","335100/337000",1.4500000000000001E-2,{"$f":"$D15*$E$13","v":0},null,"Medicare (per Org)",{"$f":"($H$6*$E15)","v":0},{"$f":"($H$7*$E15)","v":0},{"$f":"($H$8*$E15)","v":0}]
[null,"SUI","351100/353100",5.0000000000000001E-4,0,null,"SUI (per Org)",{"$f":"($H$6*$E16)","v":0},{"$f":"($H$7*$E16)","v":0},{"$f":"($H$8*$E16)","v":0}]
[null,"W/C","361100/363000",0.02,{"$f":"$D17*$E$13","v":0},null,"W/C (per Org)",{"$f":"($H$6*$E17)","v":0},{"$f":"($H$7*$E17)","v":0},{"$f":"($H$8*$E17)","v":0}]
[]
[null,"Total Benefits",null,null,{"$f":"SUM(E14:E17)","v":0},null,"Total Benfits (per Org)",{"$f":"($H$6*$E19)","v":0},{"$f":"($H$7*$E19)","v":0},{"$f":"($H$8*$E19)","v":0}]
[]
[null,"Total Salary & Benefits",null,null,{"$f":"SUM(E13,E19)","v":0},null,"Total Salary & Benefits (per Org)",{"$f":"($H$6*$E21)","v":0},{"$f":"($H$7*$E21)","v":0},{"$f":"($H$8*$E21)","v":0}]

{"sheet":"Unclassified (Hourly)","index":4,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9],[2,1,2,4],[2,6,2,9],[3,2,3,4],[3,7,3,9],[4,2,4,4],[4,7,4,9],[5,2,5,4],[5,7,5,9],[6,2,6,4],[6,7,6,9],[22,1,22,4],[7,1,7,4],[7,7,7,9],[8,1,8,4],[8,6,8,9],[9,1,9,4],[9,6,9,9]]}
[]
[null,"UNCLASSIFIED (HOURLY)",null,null,null,null,"Enter Split Funded Information Here:"]
[null,"Enter Budgeting Data Here:",null,null,null,null,"Use only if salary is split between managers"]
[null,"Title of Position:"]
[null,"Employee Rate/hr:",null,null,null,null,"Org Code","Split  Percentage"]
[null,"Hours:",null,null,null,null,330000,0.5]
[null,"Split Funded (Y/N):",null,null,null,null,330100,0.5]
[null,{"$f":"IF($C$6>900,\"Unclassified workers cannot work hourly over 900 hours\",\"\")","v":""}]
[null,{"$f":"IF($C$7=\"Y\",\"\",IF($C$7=\"N\",\"\",IF($C$7=\"\",\"\",\"ERROR: Please Enter 'Y' or 'N' in Split Funded Section\")))","v":""},null,null,null,null,{"$f":"IF(SUM(H6:H8)=1,\"\",IF(SUM(H6:H8)=0,\"\",\"Split Percentages must total to 100%\"))","v":""}]
[null,"Summary",null,null,null,null,"Split Funded Summary"]
[null,"Account Description","Account Code","Percentage","Amount",null,"Org Code (per Org)",{"$f":"IF(G6<>\"\",G6,\"\")","v":330000},{"$f":"IF(G7<>\"\",G7,\"\")","v":330100},{"$f":"IF(G8<>\"\",G8,\"\")","v":""}]
[]
[null,"Hrs x Rate",null,null,{"$f":"$C$5*$C$6","v":0},null,"Hrs x Rate (per Org)",{"$f":"($H$6*$E13)","v":0},{"$f":"($H$7*$E13)","v":0},{"$f":"($H$8*$E13)","v":0}]
[null,"APPLE","381200/382000",3.7499999999999999E-2,{"$f":"$D14*$E$13","v":0},null,"APPLE (per Org)",{"$f":"($H$6*$E14)","v":0},{"$f":"($H$7*$E14)","v":0},{"$f":"($H$8*$E14)","v":0}]
[null,"Medicare","335200/336000",1.4500000000000001E-2,{"$f":"$D15*$E$13","v":0},null,"Medicare (per Org)",{"$f":"($H$6*$E15)","v":0},{"$f":"($H$7*$E15)","v":0},{"$f":"($H$8*$E15)","v":0}]
[null,"SUI","351200/352000",5.0000000000000001E-4,0,null,"SUI (per Org)",{"$f":"($H$6*$E16)","v":0},{"$f":"($H$7*$E16)","v":0},{"$f":"($H$8*$E16)","v":0}]
[null,"W/C","361200/362000",0.02,{"$f":"$D17*$E$13","v":0},null,"W/C (per Org)",{"$f":"($H$6*$E17)","v":0},{"$f":"($H$7*$E17)","v":0},{"$f":"($H$8*$E17)","v":0}]
[null,null," "]
[null,"Total Benefits",null,null,{"$f":"SUM(E14:E17)","v":0},null,"Total Benfits (per Org)",{"$f":"($H$6*$E19)","v":0},{"$f":"($H$7*$E19)","v":0},{"$f":"($H$8*$E19)","v":0}]
[]
[null,"Total Salary & Benefits",null,null,{"$f":"SUM(E13,E19)","v":0},null,"Total Salary & Benefits (per Org)",{"$f":"($H$6*$E21)","v":0},{"$f":"($H$7*$E21)","v":0},{"$f":"($H$8*$E21)","v":0}]

{"sheet":"Student Worker","index":5,"n_rows":18,"n_cols":10,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9],[2,1,2,4],[2,6,2,9],[3,2,3,4],[3,7,3,9],[4,2,4,4],[4,7,4,9],[5,2,5,4],[5,7,5,9],[6,2,6,4],[6,7,6,9],[19,1,19,4],[7,1,7,4],[7,7,7,9],[8,1,8,4],[8,6,8,9],[9,1,9,4],[9,6,9,9]]}
[]
[null,"STUDENT WORKER (HOURLY)",null,null,null,null,"Enter Split Funded Information Here:"]
[null,"Enter Budgeting Data Here:",null,null,null,null,"Use only if salary is split between managers"]
[null,"Title of Position:"]
[null,"Employee Rate/hr:",null,null,null,null,"Org Code","Split  Percentage"]
[null,"Hours:",null,null,null,null,null,0.1]
[null,"Split Funded (Y/N):",null,null,null,null,null,0.43]
[null,{"$f":"IF($C$6>900,\"Student workers cannot work hourly for more than 900 hours\",\"\")","v":""},null,null,null,null,null,0.47]
[null,{"$f":"IF($C$7=\"Y\",\"\",IF($C$7=\"N\",\"\",IF($C$7=\"\",\"\",\"ERROR: Please Enter 'Y' or 'N' in Split Funded Section\")))","v":""},null,null,null,null,{"$f":"IF(SUM(H6:H8)=1,\"\",IF(SUM(H6:H8)=0,\"\",\"Split Percentages must total to 100%\"))","v":""}]
[null," Summary",null,null,null,null,"Split Funded Summary"]
[null,"Account Description","Account Code","Percentage","Amount",null,"Org Code (per Org)",{"$f":"IF(G6<>\"\",G6,\"\")","v":""},{"$f":"IF(G7<>\"\",G7,\"\")","v":""},{"$f":"IF(G8<>\"\",G8,\"\")","v":""}]
[]
[null,"Hrs x Rate",null,null,{"$f":"$C$5*$C$6","v":0},null,"Hrs x Rate (per Org)",{"$f":"($H$6*$E13)","v":0},{"$f":"($H$7*$E13)","v":0},{"$f":"($H$8*$E13)","v":0}]
[null,"W/C",362000,0.02,{"$f":"$D14*$E$13","v":0},null,"W/C (per Org)",{"$f":"($H$6*$E14)","v":0},{"$f":"($H$7*$E14)","v":0},{"$f":"($H$8*$E14)","v":0}]
[]
[null,"Total Benefits",null,null,{"$f":"SUM(E14:E14)","v":0},null,"Total Benfits (per Org)",{"$f":"($H$6*$E16)","v":0},{"$f":"($H$7*$E16)","v":0},{"$f":"($H$8*$E16)","v":0}]
[null,null,null,null,{"$f":"IF(C6=\"Y\",D17*B25,\"\")","v":""}]
[null,"Total Salary & Benefits",null,null,{"$f":"SUM(E13,E16)","v":0},null,"Total Salary & Benefits (per Org)",{"$f":"($H$6*$E18)","v":0},{"$f":"($H$7*$E18)","v":0},{"$f":"($H$8*$E18)","v":0}]