{ "skill": "Spreadsheets for a new office job (Google Sheets)", "fits": true, "total_hours": 22, "study_weeks": 8, "hours_per_week_needed": 4, "finish_week": 10, "finish_date": "2027-01-24", "order": [ "Basics: cells, rows, formatting", "Formulas: SUM, AVERAGE, IF", "Sorting, filters, and data cleanup", "Lookups: VLOOKUP and XLOOKUP", "Pivot tables", "Charts", "Capstone: weekly report" ], "weeks": [ { "week": 1, "start": "2026-11-16", "end": "2026-11-22", "label": "Nov 16 to Nov 22", "skipped": false, "after_goal": false, "items": [ { "topic": "Basics: cells, rows, formatting", "hours": 2 }, { "topic": "Formulas: SUM, AVERAGE, IF", "hours": 1 } ], "review_hours": 1, "milestones": [ "Rebuild your monthly budget in a sheet" ] }, { "week": 2, "start": "2026-11-23", "end": "2026-11-29", "label": "Nov 23 to Nov 29", "skipped": false, "after_goal": false, "items": [ { "topic": "Formulas: SUM, AVERAGE, IF", "hours": 3 } ], "review_hours": 1, "milestones": [] }, { "week": 3, "start": "2026-11-30", "end": "2026-12-06", "label": "Nov 30 to Dec 6", "skipped": false, "after_goal": false, "items": [ { "topic": "Sorting, filters, and data cleanup", "hours": 3 } ], "review_hours": 1, "milestones": [] }, { "week": 4, "start": "2026-12-07", "end": "2026-12-13", "label": "Dec 7 to Dec 13", "skipped": false, "after_goal": false, "items": [ { "topic": "Lookups: VLOOKUP and XLOOKUP", "hours": 3 } ], "review_hours": 1, "milestones": [] }, { "week": 5, "start": "2026-12-14", "end": "2026-12-20", "label": "Dec 14 to Dec 20", "skipped": false, "after_goal": false, "items": [ { "topic": "Lookups: VLOOKUP and XLOOKUP", "hours": 1 }, { "topic": "Pivot tables", "hours": 2 } ], "review_hours": 1, "milestones": [ "Join two lists of customers by email" ] }, { "week": 6, "start": "2026-12-21", "end": "2026-12-27", "label": "Dec 21 to Dec 27", "skipped": true, "after_goal": false, "items": [], "review_hours": 0, "milestones": [] }, { "week": 7, "start": "2026-12-28", "end": "2027-01-03", "label": "Dec 28 to Jan 3", "skipped": true, "after_goal": false, "items": [], "review_hours": 0, "milestones": [] }, { "week": 8, "start": "2027-01-04", "end": "2027-01-10", "label": "Jan 4 to Jan 10", "skipped": false, "after_goal": false, "items": [ { "topic": "Pivot tables", "hours": 2 }, { "topic": "Charts", "hours": 1 } ], "review_hours": 1, "milestones": [ "Sales by month and region from a raw export" ] }, { "week": 9, "start": "2027-01-11", "end": "2027-01-17", "label": "Jan 11 to Jan 17", "skipped": false, "after_goal": false, "items": [ { "topic": "Charts", "hours": 1 }, { "topic": "Capstone: weekly report", "hours": 2 } ], "review_hours": 1, "milestones": [] }, { "week": 10, "start": "2027-01-18", "end": "2027-01-24", "label": "Jan 18 to Jan 24", "skipped": false, "after_goal": false, "items": [ { "topic": "Capstone: weekly report", "hours": 1 } ], "review_hours": 1, "milestones": [ "A one-page weekly report you could hand a manager" ] } ] }