Excel assignment
llmurbayz
leave.xlsxDocumentation
| Branco, Inc. | |
| Date Created: | |
| Created By: | |
| Purpose: | To record and summarize vacation and family leave data for |
| employees of Branco, Inc. |
Employee Data
| Name | Job Status | Years Employed | Vacation Leave | Used Vacation Leave | Remaining Vacation Leave | Family Leave | Used Family Leave | Remaning Family Leave |
| Abba | FT | 0.1 | 5 | 0 | ||||
| Abbot | FT | 4.0 | 7 | 0 | ||||
| Adtkins | FT | 5.7 | 4 | 1 | ||||
| Andrews | FT | 8.8 | 3 | 0 | ||||
| Baker | PT | 2.5 | 0 | 3 | ||||
| Berg | FT | 4.5 | 4 | 1 | ||||
| Bergeman | FT | 10.0 | 4 | 2 | ||||
| Blake | CN | 0.3 | 0 | 0 | ||||
| Bliss | FT | 1.0 | 6 | 3 | ||||
| Borchardt | CN | 1.0 | 0 | 0 | ||||
| Captian | FT | 3.7 | 3 | 5 | ||||
| Carey | PT | 2.4 | 0 | 1 | ||||
| Chi | FT | 1.9 | 3 | 2 | ||||
| Chou | FT | 0.4 | 3 | 0 | ||||
| Christain | FT | 9.4 | 1 | 2 | ||||
| Clarke | FT | 2.2 | 5 | 0 | ||||
| Crawford | PT | 0.3 | 0 | 0 | ||||
| Czeller | FT | 7.3 | 0 | 0 | ||||
| Cziecwski | PT | 2.7 | 0 | 1 | ||||
| Davidson | FT | 10.0 | 4 | 4 | ||||
| Davis | FT | 0.5 | 3 | 2 | ||||
| Dawes | FT | 9.9 | 2 | 1 | ||||
| Doering | FT | 8.7 | 2 | 0 | ||||
| Dolan | FT | 2.2 | 0 | 3 | ||||
| Donell | CN | 0.5 | 0 | 0 | ||||
| Douglas | FT | 4.6 | 1 | 0 | ||||
| Earle | FT | 6.8 | 7 | 1 | ||||
| Faber | PT | 0.4 | 0 | 0 | ||||
| Frase | FT | 6.3 | 0 | 3 | ||||
| Fuller | PT | 2.9 | 0 | 3 | ||||
| Gere | FT | 7.2 | 1 | 4 | ||||
| Gorecki | FT | 0.6 | 2 | 0 | ||||
| Green | FT | 2.8 | 4 | 2 | ||||
| Greenwood | FT | 3.0 | 4 | 3 | ||||
| Hayden | FT | 1.0 | 7 | 2 | ||||
| Hennings | FT | 3.8 | 2 | 4 | ||||
| Hensel | PT | 3.5 | 3 | 1 | ||||
| Hildeberg | FT | 4.2 | 4 | 0 | ||||
| Hogan | FT | 8.9 | 6 | 3 | ||||
| Howard | FT | 2.9 | 5 | 2 | ||||
| Isaacs | FT | 7.4 | 5 | 3 | ||||
| Jessup | FT | 0.5 | 2 | 1 | ||||
| Karls | FT | 4.2 | 3 | 2 | ||||
| Kaufmann | FT | 2.8 | 1 | 1 | ||||
| Knuteson | PT | 3.7 | 5 | 1 | ||||
| Koch | PT | 3.7 | 5 | 2 | ||||
| Lasek | PT | 3.1 | 7 | 3 | ||||
| Laszewski | PT | 1.5 | 0 | 0 | ||||
| Lawton | FT | 10.0 | 4 | 1 | ||||
| Lee | FT | 9.5 | 2 | 1 | ||||
| Lei | FT | 9.8 | 0 | 0 | ||||
| Mahanez | FT | 5.4 | 4 | 2 | ||||
| Menendez | PT | 0.7 | 0 | 0 | ||||
| Meyer | PT | 2.1 | 0 | 3 | ||||
| Miller | FT | 4.0 | 3 | 3 | ||||
| Nelson | FT | 9.5 | 4 | 3 | ||||
| Nevers | FT | 8.4 | 3 | 2 | ||||
| Nieland | FT | 3.3 | 7 | 3 | ||||
| Okanawa | FT | 3.3 | 7 | 3 | ||||
| Palmer | FT | 0.5 | 4 | 3 | ||||
| Patterson | PT | 0.2 | 0 | 0 | ||||
| Paulson | PT | 0.4 | 0 | 0 | ||||
| Peshek | PT | 4.6 | 0 | 3 | ||||
| Phman | FT | 9.2 | 7 | 0 | ||||
| Pia | PT | 0.9 | 0 | 0 | ||||
| Quinonese | FT | 4.1 | 1 | 2 | ||||
| Raab | FT | 11.7 | 4 | 2 | ||||
| Rabin | FT | 2.8 | 2 | 1 | ||||
| Ratcliffe | FT | 6.7 | 1 | 2 | ||||
| Raulings | PT | 1.1 | 0 | 0 | ||||
| Ricard | PT | 0.9 | 0 | 0 | ||||
| Roche | FT | 10.1 | 1 | 2 | ||||
| Rodriguez | FT | 2.2 | 2 | 1 | ||||
| Rosenblum | FT | 15.0 | 7 | 1 | ||||
| Roy | PT | 1.2 | 0 | 0 | ||||
| Ryan | PT | 1.8 | 0 | 0 | ||||
| Sanchez | FT | 5.4 | 6 | 2 | ||||
| Santoirre | FT | 1.6 | 2 | 2 | ||||
| Schorr | CN | 0.8 | 0 | 0 | ||||
| Shapiro | CN | 0.5 | 0 | 0 | ||||
| Sidney | CN | 0.5 | 0 | 0 | ||||
| Takayma | FT | 14.6 | 5 | 2 | ||||
| Tallard | FT | 4.1 | 4 | 0 | ||||
| Thomas | PT | 0.9 | 0 | 0 | ||||
| Tracy | FT | 6.7 | 4 | 0 | ||||
| Unlaughten | PT | 1.1 | 0 | 0 | ||||
| Vaughn | FT | 10.3 | 1 | 3 | ||||
| Veronese | FT | 8.3 | 5 | 1 | ||||
| Vos | PT | 2.7 | 0 | 1 | ||||
| Walters | FT | 1.4 | 5 | 3 | ||||
| Weigstein | FT | 4.6 | 3 | 0 | ||||
| Whitman | FT | 6.8 | 5 | 0 | ||||
| Whorle | FT | 1.8 | 2 | 1 | ||||
| Whyte | FT | 5.5 | 4 | 2 | ||||
| Williams | PT | 1.1 | 0 | 0 | ||||
| Woods | FT | 7.7 | 10 | 3 | ||||
| Wu | FT | 4.5 | 6 | 2 | ||||
| Wu | FT | 4.8 | 7 | 1 | ||||
| Young | FT | 5.8 | 5 | 0 | ||||
| Zellner | FT | 8.5 | 15 | 2 | ||||
| Ziegler | FT | 9.0 | 7 | 3 | ||||
| Zou | FT | 8.8 | 13 | 0 |
Leave Summary
| Leave Summary | |||||
| Vacation Leave | Number Eligible | Total Days | Days Used | Days Remaining | |
| 17-day | |||||
| 12-day | |||||
| 7-day | |||||
| none | |||||
| Total | |||||
| Family Leave | Number Eligible | Total Days | Days Used | Days Remaining | |
| 5-day | |||||
| 3-day | |||||
| none | |||||
| Total | |||||
