S
Susan
Please help with the following spreadsheet. I hope it's readable.
CTA 01T Fund
Hourly Beginning Total Leave Hrs Charged Ending Leave
$ Balance
Wages Balance Taken This to CTA this Balance
Allocation at End of
Pay Period Pay Period
% for 01T PP
$40.28 500.00 24.50 31.00 458.00
45.00 $18,448.24
$47.79 620.00 2.00 76.00 543.00
55.00 $25,949.97
$45.23 870.00 0.00 53.00 817.00
78.00 $36,952.91
$47.81 1120.00 33.25 46.75 1040.00
100.00 $49,722.40
$45.50 360.00 0.50 46.00 313.75
32.00 $14,275.63
$47.88 1060.00 5.00 75.00 980.25
95.00 $46,934.37
$209,799.90 Total CTA Funds Remaining
$192,283.52
I need 26 workbook tabs of this spreadsheet that update the balances each
pay period. The ending balance contains a formula to calculate time off,
hours worked and the percentage charged to each fund for time off hours.
There will be 5 or 6 of the above columns in each spreadsheet for all of the
funds employees work in.
Susan
CTA 01T Fund
Hourly Beginning Total Leave Hrs Charged Ending Leave
$ Balance
Wages Balance Taken This to CTA this Balance
Allocation at End of
Pay Period Pay Period
% for 01T PP
$40.28 500.00 24.50 31.00 458.00
45.00 $18,448.24
$47.79 620.00 2.00 76.00 543.00
55.00 $25,949.97
$45.23 870.00 0.00 53.00 817.00
78.00 $36,952.91
$47.81 1120.00 33.25 46.75 1040.00
100.00 $49,722.40
$45.50 360.00 0.50 46.00 313.75
32.00 $14,275.63
$47.88 1060.00 5.00 75.00 980.25
95.00 $46,934.37
$209,799.90 Total CTA Funds Remaining
$192,283.52
I need 26 workbook tabs of this spreadsheet that update the balances each
pay period. The ending balance contains a formula to calculate time off,
hours worked and the percentage charged to each fund for time off hours.
There will be 5 or 6 of the above columns in each spreadsheet for all of the
funds employees work in.
Susan