At each study review.
Suggested for your taskOriginal Studio 3 / A connected everyday workflow
Semester Workload & Study Workbook
Turn a deadline into sessions that fit the week.
Link subjects, assessment stages, study sessions and readings to a twenty-week workload and a live next-deadline list.
- Format
- Excel · .xlsx
- Inside
- 9 worksheets
- Included
- Clean file + example + guide
Check the capacity and fitWho it is for, supplied record limits and software requirements
The everyday problem
What is due next, and how much study work still needs a place?
A deadline list can grow while the study week stays unchanged. Connect subjects, assessments, readings and actual sessions, then compare planned hours with the weekly capacity you chose. Completed time is recorded effort, not a prediction of learning or grades.
Optional guideNeed help getting started?Choose where to begin. All listed files are included.
Add the complete product to your cart whenever you’re ready. Use this guide only if you’d like help choosing what to open first; your choices do not change the product or its price.
Guide step 1 of 4
What would you like to do?
Pick a useful task, or build your own selection.
Which sheets would you explore first?
Choose your starting points. The workbook keeps all its connected sheets and formulas; this does not remove or rebuild worksheets.
Nothing selected yet.
Before planning the term.
Suggested for your taskBefore filling another week.
Suggested for your taskWhen setting up subjects.
Suggested for your taskWhen a course requirement is confirmed.
Suggested for your taskBefore and after a study session.
Suggested for your taskWhen a reading supports a task.
Suggested for your taskWhen a class arrangement changes.
Suggested for your taskFor your first session.
Suggested for your taskWhich file would you open first?
Both files are included. Choose which one you would open first in a desktop spreadsheet application.
Your starting plan.
Your first file or method
Both XLSX files, all 9 connected sheets and the single included guide remain in the complete kit. Your selection identifies where to begin.
Read the complete setup guideYour choices help you understand the complete product. They do not alter its contents or price.
Both XLSX files, all 9 connected sheets and the single included guide remain in the complete kit. Your selection identifies where to begin.
Read the tasks, contents and file choices
Useful starting tasks
Follow essay A-001 into a study week.. Use the included START_HERE.pdf guide to follow one complete task in a disposable example copy.
Choose my own starting points. Explore the contents and select only the parts you would use first.
Contents to explore
- Dashboard: At each study review.
- Settings: Before planning the term.
- Workload: Before filling another week.
- Subjects: When setting up subjects.
- Assessments: When a course requirement is confirmed.
- Sessions: Before and after a study session.
- Reading: When a reading supports a task.
- Timetable: When a class arrangement changes.
- Start: For your first session.
Both files are included. Choose which one you would open first in a desktop spreadsheet application.
Explore the worked example: Fictional records show how the sheets work together. Save a disposable copy before trying a change. semester-study-example.xlsx
Start my own working copy: Open the clean workbook after reading the guide. Keep the original and save a copy for your own records. semester-study-clean.xlsx
Follow the complete first taskUse the included guide and a disposable example copy.
Your first useful session / Start with the example
Follow essay A-001 into a study week.
Follow this one complete task before entering your own records. Keep the blank original and save a working copy.
Find the assessment
Design history essay A-001 is due 12 October and estimated at eight hours.
Trace its sessions
Two active sessions plan 4.5 hours. The completed session records 1.5 hours; the cancelled session contributes neither.
Review the real week
A-001 has 6.5 estimated hours remaining. Week 5 shows 5.5 planned and 1.5 actual study hours across subjects. Choose the next session within your capacity.
EVERY WORKSHEET / ACTUAL EXAMPLE FILE
See what you enter.
Understand what updates.
Inspect all 9 sheets. These are images of the delivered example, with fictional records. Open an image to read its full detail.
Actual example worksheet. Image only; entries are made in your downloaded workbook.
Dashboard
Outstanding assessments, estimated remaining work and reading follow-ups.
- You enter
- No routine entry
- Calculated or supplied reference
- Outstanding assessments, next deadlines and reading count
Actual example worksheet. Image only; entries are made in your downloaded workbook.
Settings
Before planning the term.
- You enter
- First Monday, review date and weekly available study hours
- Calculated or supplied reference
- Date and capacity checks
Actual example worksheet. Image only; entries are made in your downloaded workbook.
Workload
Planned and completed effort against a chosen weekly capacity.
- You enter
- No routine entry
- Calculated or supplied reference
- 20 weeks of planned, actual, capacity and due work
Actual example worksheet. Image only; entries are made in your downloaded workbook.
Subjects
When setting up subjects.
- You enter
- Stable subject ID, name and weekly target
- Calculated or supplied reference
- Linked record checks
Actual example worksheet. Image only; entries are made in your downloaded workbook.
Assessments
One assessment links to the sessions you actually record.
- You enter
- ID, subject, due date, estimated hours and stage
- Calculated or supplied reference
- Linked planned and actual hours; remaining estimated work
Actual example worksheet. Image only; entries are made in your downloaded workbook.
Sessions
Each session requires an assessment ID; its subject is derived from that assessment.
- You enter
- Session ID, required assessment ID, date, status, planned and actual hours
- Calculated or supplied reference
- Subject ID derived from the assessment; session validity and linked workload
Actual example worksheet. Image only; entries are made in your downloaded workbook.
Reading
When a reading supports a task.
- You enter
- ID, subject, optional assessment, source, target date and status
- Calculated or supplied reference
- Outstanding reading checks
Actual example worksheet. Image only; entries are made in your downloaded workbook.
Timetable
When a class arrangement changes.
- You enter
- Day, start/end, subject, location and reference
- Calculated or supplied reference
- Input warnings; manual weekly class reference
Actual example worksheet. Image only; entries are made in your downloaded workbook.
Start
For your first session.
- You enter
- No routine entry
- Calculated or supplied reference
- Definitions, capacities and first-use instructions
Follow the supplied fictional exampleRead the inputs and the result together
From the supplied fictional example
A deadline becomes a practical next session.
A-001 is the next deadline. The full fictional example has 18.5 estimated hours remaining across two outstanding assessments, 7.5 planned study hours and 3.5 valid actual hours. Timetable entries remain a reference and do not add sessions.
- Essay estimate / completed
- 8.0 h / 1.5 h
- Weekly capacity
- 12.0 h
- A-001 remaining estimate
- 6.5 h
- Week 5 planned / actual
- 5.5 h / 1.5 h
- Outstanding assessments
- 2
TRY THE WORKFLOW / FREE
Put a session into a real week.
A complete small browser tool to try the planning method. It is separate from the linked records in the downloadable workbook.
From setup to a regular review
How you use it.
Open the 3-step setup and review routineInputs, calculations and the decision each step supports
- 01
Confirm the term
You enterChoose the first Monday, review date, weekly capacity and subject IDs.
CalculatedTwenty reporting weeks and validation checks form the review frame.
Your next stepCopy requirements from your actual course; keep IDs stable.
- 02
Give the assessment a session
You enterEnter an assessment, estimate and deadline, then link dated study sessions and readings.
CalculatedValid Planned and Completed sessions feed the workload; completed actual hours reduce estimated work remaining.
Your next stepCompare the planned week with the time you really have.
- 03
Review what happened
You enterRecord completed time, cancel unused plans and advance the review date.
CalculatedNext deadlines, remaining work and reading follow-ups update from valid records.
Your next stepChoose the next concrete session; the workbook does not submit or reschedule your work.
9 sheets. Inspect each one.Inputs, outputs and when to use every worksheet
DashboardOpen sheet details
Editable inputs
- No routine entry
Calculated or reference
- Outstanding assessments, next deadlines and reading count
At each study review.
Inspect the actual Dashboard sheetSettingsOpen sheet details
Editable inputs
- First Monday, review date and weekly available study hours
Calculated or reference
- Date and capacity checks
Before planning the term.
Inspect the actual Settings sheetSubjectsOpen sheet details
Editable inputs
- Stable subject ID, name and weekly target
Calculated or reference
- Linked record checks
When setting up subjects.
Inspect the actual Subjects sheetAssessmentsOpen sheet details
Editable inputs
- ID, subject, due date, estimated hours and stage
Calculated or reference
- Linked planned and actual hours; remaining estimated work
When a course requirement is confirmed.
Inspect the actual Assessments sheetSessionsOpen sheet details
Editable inputs
- Session ID, required assessment ID, date, status, planned and actual hours
Calculated or reference
- Subject ID derived from the assessment; session validity and linked workload
Before and after a study session.
Inspect the actual Sessions sheetWorkloadOpen sheet details
Editable inputs
- No routine entry
Calculated or reference
- 20 weeks of planned, actual, capacity and due work
Before filling another week.
Inspect the actual Workload sheetReadingOpen sheet details
Editable inputs
- ID, subject, optional assessment, source, target date and status
Calculated or reference
- Outstanding reading checks
When a reading supports a task.
Inspect the actual Reading sheetTimetableOpen sheet details
Editable inputs
- Day, start/end, subject, location and reference
Calculated or reference
- Input warnings; manual weekly class reference
When a class arrangement changes.
Inspect the actual Timetable sheetStartOpen sheet details
Editable inputs
- No routine entry
Calculated or reference
- Definitions, capacities and first-use instructions
For your first session.
Inspect the actual Start sheetCompare with a manual starting pointWhat the connected workbook adds
| What is included | The free browser workflow | Semester Workload & Study Workbook 1.0 |
|---|---|---|
| Scope | One quote or a seven-day manual session plan. | Linked stable-ID records across nine worksheets. |
| History | A local draft with manual JSON backup. | Separate input registers and calculated review views. |
| Instructions | Inline scope and assumptions. | Fictional example, clean workbook and illustrated guides. |
Files, capacities and practical limitsRead these before choosing your working copy
The download
Files with a purpose.
semester-study-clean.xlsx
Clean connected workbook with marked inputs, formulas, checks and built-in navigation.
semester-study-example.xlsx
Separate fictional worked records covering a complete routine.
START_HERE.pdf
Your single guide to setup, the first useful task, file recovery, practical limits and license.
English. Study hours and workload; no grade or learning measurement. Spreadsheet software is separate.
Before you choose
Fit and practical limits.
- A student organising one 20-week term with manually confirmed assessment dates.
- An adult learner comparing planned study sessions with the time available around work and home.
Understand the boundaries.
- 20 subjects, 200 assessments, 500 study sessions, 200 reading records, 50 timetable entries and 20 reporting weeks.
- Manual course requirements, dates, estimates and capacity. The first term date is a Monday; timetable rows do not generate sessions.
- Remaining effort is max(0, entered estimate minus recorded valid completed hours); it is not a learning or grade forecast.
- Cancelled sessions are excluded. Future completed sessions are flagged; actual effort is limited by your review date.
- No course-system integration, submission, reminders, automatic rescheduling or grade calculations.
- Native Excel verification remains pending. Resolve input warnings before using the summaries.
Native Excel verification remains pending. Google Sheets and Numbers support has not been established.
Semester Workload & Study Workbook / Version 1.0
Your own working copy.
Clean workbook, separate example and one START_HERE.pdf guide covering setup, practical limits and the internal-use license.
Desktop spreadsheet software required; it is not included. Native Excel compatibility is still awaiting verification.
Private preview. Purchases are unavailable while the files and delivery are verified.
Questions about this workbook
The details that affect your choice.
Does the file connect to an external service?
No. Records and review dates are entered manually. The supplied workbook has no macros, external connections or account.
What happens at the row limit?
The documented capacities are fixed. Extending them requires extending formulas and validations; automatic expansion is not advertised.
How should I start?
Follow the illustrated first task in the fictional example, then save a working copy of the clean file. Blue cells are inputs; grey cells contain formulas.