{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["BYA PAL Calc - Biweekly","BYA PAL Calc - Monthly"],"read":"whole","date_system":"1900"}

{"sheet":"BYA PAL Calc - Biweekly","index":0,"n_rows":20,"n_cols":9,"rows_kept":20,"merged":[[0,0,0,8],[3,0,3,8],[5,0,5,8],[9,0,9,8],[10,0,10,8],[11,2,11,8],[12,2,12,8],[13,2,13,8],[15,0,15,8],[16,2,16,8],[17,2,17,8],[18,2,18,8]]}
["Biweekly Position - Time Based Pay"]
["If you have an hourly rate plug it here.","Cumulitive hours spent in the last four pay periods devided by 4.",{"$nulls":5},"Hours Taken:\nFor Calculation purposes, enter number of hours to claim to not exceed remaining balance.\n\nKEEP TRACK of Submissions","Amount To Submit:\nUse this amount to submit a One-Time pay using \"RGC\" earn code"]
["Hourly Rate","AVG Hours Spent Per PP based on Previous Periods","Job FTE or FTE Per PP Based on AVG Hours","Admin Leave Max","Admin Leave Max Based on FTE","Previous Admin Leave Takes","Remaining Admin Leave Balance","Current Pay Period Takes not to Exceed Remaining Balance","One Time Pay"]
["Example 1"]
[{"v":23,"d":"$23.00"},12.5,{"$f":"B5/80","v":{"v":0.15625,"d":"0.156"}},128,{"$f":"C5*D5","v":{"v":20,"d":"20.0"}},{"v":0,"d":"0.0"},{"$f":"E5-F5","v":{"v":20,"d":"20.0"}},{"v":10,"d":"10.0"},{"$f":"A5*H5","v":{"v":230,"d":"$230.00"}}]
["Example 2"]
[{"v":32,"d":"$32.00"},{"v":20,"d":"20.0"},{"$f":"B7/80","v":{"v":0.25,"d":"0.250"}},128,{"$f":"C7*D7","v":{"v":32,"d":"32.0"}},{"v":0,"d":"0.0"},{"$f":"E7-F7","v":{"v":32,"d":"32.0"}},{"v":40,"d":"40.0"},{"$f":"A7*H7","v":{"v":1280,"d":"$1,280.00"}}]
[]
[]
["Biweekly Position - Flat Dollar Amount Based Pay (Pay is the same every pay period regardless of hours spent)"]
["Example 1"]
["Pay Rate per PP",{"v":500,"d":"$500.00"},"This amount is paid to employee on a monthly basis regardless of time spent"]
["Hours Per PP",80,"Biweekly Hours"]
["Pay Rate",{"$f":"B12/B13","v":{"v":6.25,"d":"$6.25"}},"Calculated Hourly rate "]
[{"v":6.25,"d":"$6.25"},80,{"$f":"B15/80","v":{"v":1,"d":"1.000"}},128,{"$f":"C15*D15","v":{"v":128,"d":"128.0"}},{"v":0,"d":"0.0"},{"$f":"E15-F15","v":{"v":128,"d":"128.0"}},{"v":80,"d":"80.0"},{"$f":"A15*H15","v":{"v":500,"d":"$500.00"}}]
["Example 2"]
["Pay Rate per PP",{"v":3500,"d":"$3,500.00"},"This amount is paid to employee every pay period regardless of time spent"]
["Hours Per PP",80,"Biweekly Hours"]
["Pay Rate",{"$f":"B17/B18","v":{"v":43.75,"d":"$43.75"}},"Calculated Hourly rate "]
[{"v":43.75,"d":"$43.75"},80,{"$f":"B20/80","v":{"v":1,"d":"1.000"}},128,{"$f":"C20*D20","v":{"v":128,"d":"128.0"}},{"v":0,"d":"0.0"},{"$f":"E20-F20","v":{"v":128,"d":"128.0"}},{"v":80,"d":"80.0"},{"$f":"A20*H20","v":{"v":3500,"d":"$3,500.00"}}]

{"sheet":"BYA PAL Calc - Monthly","index":1,"n_rows":20,"n_cols":9,"rows_kept":20,"merged":[[0,0,0,8],[3,0,3,8],[5,0,5,8],[9,0,9,8],[10,0,10,8],[11,2,11,8],[12,2,12,8],[13,2,13,8],[15,0,15,8],[16,2,16,8],[17,2,17,8],[18,2,18,8]]}
["Monthly Position - Time Based Pay"]
["If you have an hourly rate plug it here.","Cumulitive hours spent in the last two pay periods devided by 2.\nEx: 50 Total Hours\nAvg = 25",{"$nulls":5},"Hours Taken:\nFor Calculation purposes, enter number of hours to claim to not exceed remaining balance.\n\nKEEP TRACK of Submissions","Amount To Submit:\nUse this amount to submit a One-Time pay using \"RGC\" earn code"]
["Hourly Rate","AVG Hours Spent Per PP based on Previous Periods","Job FTE or FTE Per PP Based on AVG Monthly Hours","Admin Leave Max","Admin Leave Max Based on FTE","Previous Admin Leave Takes","Remaining Admin Leave Balance","Current Pay Period Takes not to Exceed Remaining Balance","One Time Pay"]
["Example 1"]
[{"v":38,"d":"$38.00"},{"v":25,"d":"25.0"},{"$f":"B5/174","v":{"v":0.14367816091954022,"d":"0.144"}},128,{"$f":"C5*D5","v":{"v":18.39080459770115,"d":"18.4"}},{"v":0,"d":"0.0"},{"$f":"E5-F5","v":{"v":18.39080459770115,"d":"18.4"}},{"v":10,"d":"10.0"},{"$f":"A5*H5","v":{"v":380,"d":"$380.00"}}]
["Example 2"]
[{"v":55,"d":"$55.00"},{"v":20,"d":"20.0"},{"$f":"B7/174","v":{"v":0.11494252873563218,"d":"0.115"}},128,{"$f":"C7*D7","v":{"v":14.71264367816092,"d":"14.7"}},{"v":0,"d":"0.0"},{"$f":"E7-F7","v":{"v":14.71264367816092,"d":"14.7"}},{"v":20,"d":"20.0"},{"$f":"A7*H7","v":{"v":1100,"d":"$1,100.00"}}]
[]
[]
["Monthly Position - Flat Dollar Amount Based Pay (Pay is the same every pay period regardless of hours spent)"]
["Example 1"]
["Pay Rate per PP",{"v":500,"d":"$500.00"},"This amount is paid to employee on a monthly basis regardless of time spent"]
["Hours Per PP",174,"Average Monthly Hours "]
["Pay Rate",{"$f":"B12/B13","v":{"v":2.8735632183908044,"d":"$2.87"}},"Calculated Hourly rate "]
[{"$f":"B14","v":{"v":2.8735632183908044,"d":"$2.87"}},174,{"$f":"B15/B15","v":{"v":1,"d":"1.000"}},128,{"$f":"C15*D15","v":{"v":128,"d":"128.0"}},{"v":0,"d":"0.0"},{"$f":"E15-F15","v":{"v":128,"d":"128.0"}},{"v":80,"d":"80.0"},{"$f":"A15*H15","v":{"v":229.88505747126436,"d":"$229.89"}}]
["Example 2"]
["Pay Rate per PP",{"v":3500,"d":"$3,500.00"},"This amount is paid to employee on a monthly basis regardless of time spent"]
["Hours Per PP",174,"Average Monthly Hours "]
["Pay Rate",{"$f":"B17/B18","v":{"v":20.114942528735632,"d":"$20.11"}},"Calculated Hourly rate "]
[{"$f":"B19","v":{"v":20.114942528735632,"d":"$20.11"}},174,{"$f":"B20/B20","v":{"v":1,"d":"1.000"}},128,{"$f":"C20*D20","v":{"v":128,"d":"128.0"}},{"v":0,"d":"0.0"},{"$f":"E20-F20","v":{"v":128,"d":"128.0"}},{"v":80,"d":"80.0"},{"$f":"A20*H20","v":{"v":1609.1954022988507,"d":"$1,609.20"}}]