Greetings!
I am seeking assistance in building an EXCEL file that will tell its user how many hours of a certain task must be completed per day to achieve a much higher total number of hours over the course of six months.
The US Department of Labor (DOL) has been sponsoring Apprenticeship Certifications to the US Navy for a long time. In the program a Sailor must complete X amount of hours in various tasks, after all hours have been documented as complete the DOL sends a Certificate of Apprenticeship Completion to the Sailor.
There are a few important rules that need to be followed when creating the formulas.
Here is an example of an apprenticeship tract:
COMPUTER OPERATOR
Total required hours (in the skills listed below): 2000
<tbody>
</tbody>
<tbody>
</tbody>
So in a nut shell, I want to create a file that I can type in the total hours required, the total hours in each category and have a formula tell me how I can evenly divide the hours over the course of a normal workday/week, while staying within the rules listed above.
I am seeking assistance in building an EXCEL file that will tell its user how many hours of a certain task must be completed per day to achieve a much higher total number of hours over the course of six months.
The US Department of Labor (DOL) has been sponsoring Apprenticeship Certifications to the US Navy for a long time. In the program a Sailor must complete X amount of hours in various tasks, after all hours have been documented as complete the DOL sends a Certificate of Apprenticeship Completion to the Sailor.
There are a few important rules that need to be followed when creating the formulas.
- A Sailor can only claim eight (8) hours per day, ten (10) if they are deployed.
- Hours cannot be claimed on Sundays
- Hours can be claimed on Saturdays if the Sailor is deployed.
- Some Sailors receive pre-registration credit, cutting the required hours in half.
Here is an example of an apprenticeship tract:
COMPUTER OPERATOR
Total required hours (in the skills listed below): 2000
Skill | Description | Hours |
A | COMPUTER OPERATION Monitor and control electronic computer ….. | 600 |
B | COMMUNICATION Communicating with supervisors, peers ….. | 400 |
C | ANALYZING DATA OR INFORMATION Operate spreadsheet programs ….. | 350 |
D | USE INTERNET AND INTRANET OR NETWORKING Navigate or research or execute or ….. | 250 |
E | PERIPHERAL EQUIPMENT Operate computer peripheral equipment ….. | 100 |
F | MEDIA ASSISTANCE Assist workers in classifying, cataloging ….. | 100 |
G | ERROR MONITORING Operate and observe computer and peripheral equipment ….. | 100 |
H | MAINTENANCE AND INSTRUCTIONS Read instructions and follow maintenance schedules….. | 100 |
<tbody>
</tbody>
Skill | A | B | C | D | E | F | G | H | Total |
Hours Required | 600.0 | 400.0 | 350.0 | 250.0 | 100.0 | 100.0 | 100.0 | 100.0 | 2,000.0 |
Pre-registration Credit | 300.0 | 200.0 | 175.0 | 125.0 | 50.0 | 50.0 | 50.0 | 50.0 | 1,000.0 |
Hours Submitted in all Semiannual Reports | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
Hours Remaining | 300.0 | 200.0 | 175.0 | 125.0 | 50.0 | 50.0 | 50.0 | 50.0 | 1,000.0 |
Hours Remaining % | 50.0 | 50.0 | 50.0 | 50.0 | 50.0 | 50.0 | 50.0 | 50.0 | 50.0 |
Hours Submitted in Weekly Logs* | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 | 0.0 |
<tbody>
</tbody>
So in a nut shell, I want to create a file that I can type in the total hours required, the total hours in each category and have a formula tell me how I can evenly divide the hours over the course of a normal workday/week, while staying within the rules listed above.
Last edited: