Excel Assignment
rfeliz12
NP_EX19_EOM3-1_RichardFeliz_1.xlsxDocumentation
| New Perspectives Excel 2019 | Module 3: End of Module Project 1 | |
| Barrel Barnard Consulting | |
| PERFORM CALCULATIONS WITH FORMULAS AND FUNCTIONS | |
| Author: | Richard Feliz |
| Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website. | |
Timesheet
| Reporting Period Hours | Timesheet due | |||||||||
| Name | ||||||||||
| Period start | 2/1/21 | |||||||||
| Period end | Summary | Balances | ||||||||
| Date completed | Week # | 1 | Period Start | Period End | ||||||
| Worked | ||||||||||
| Hours Worked | Holiday | |||||||||
| Week # | Mon | Vacation | 56.00 | |||||||
| 1 | 8 | 8.5 | 7.5 | 4 | 0 | Sick | 24.00 | |||
| 2 | 8 | 7.5 | 9 | 7.5 | 8 | Comp | 6.50 | |||
| 0 | 8 | 8.5 | 8.5 | 7 | Total | 86.50 | ||||
| 9 | 8.5 | 8 | 9.5 | 9 | ||||||
| Hours Used | Hours worked per day | |||||||||
| Week # | Hours Worked | Other Hours Used | Total Hours For Week | |||||||
| Holiday | Vacation | Sick | Comp | Average | ||||||
| 1 | 10.00 | 2.00 | 12.00 | Maximum | ||||||
| 2 | Minimum | |||||||||
| 3 | 8.00 | 8.00 | ||||||||
| 4 | ||||||||||
