weekly-report-generator
Automatically generates a 1-page weekly progress report PPTX based on Obsidian daily notes. Trigger this skill on Saturdays. It (1) Identifies the date range from last Saturday to this Saturday, (2) R
Files2
View on GitHubSKILL.mdskills/weekly-report-generator/SKILL.md
GitHubWeekly Report Generator
Generates a single-slide weekly PPTX report for the user, summarizing research and project progress from Obsidian daily notes. The audience is the supervisor — only meaningful research/project work matters.
Template Rules (CRITICAL)
The template already has:
- A slide master containing the user's name and the lab logo in the header area.
- A blue task line near the top (e.g.
任务:Project A,重点研发(Project B)、科研C). - Two body sections:
本周进展:(with bullet points) and下周计划:(with bullet points).
DO NOT:
- Add, move, or modify any title/header text box. The name and logo come from the slide master — leave them alone.
- Add a second slide. Everything must fit on ONE slide.
- Delete or rearrange existing placeholder shapes.
- Change fonts or color scheme — follow what the template already uses.
DO:
- Only edit the body text inside the existing text placeholders for
本周进展and下周计划. - Update the task line date range if one exists.
- Keep the slide layout and structure identical to the template.
Content Rules
What to Include
- Research work (科研): paper reading, experiments, algorithm design, simulation results, data analysis, writing.
- Project work (项目): engineering tasks, development milestones, testing, demos, deployments.
- Summarize by topic/theme, not by day. Group related items across the week.
What to Exclude
- Tool setup, environment configuration, agent/IDE tweaks (e.g. "配置了XXX环境", "装了XXX插件").
- Personal or administrative items unrelated to research/projects.
- Trivial items that don't reflect meaningful progress.
Tone
- Concise, professional, teacher-facing. Highlight outcomes and progress, not process.
- Use short bullet points (one line each when possible). Avoid long paragraphs.
Formatting Rules
- Line spacing: Use consistent, moderate line spacing (1.0–1.2×). Avoid overly sparse layouts or cramped text.
- Font size: Body bullets ~14–16pt. Section headers (
本周进展:,下周计划:) bold, ~18–20pt. - Bullet count: Aim for 3–6 bullets under
本周进展and 2–4 under下周计划. Condense if needed to keep the slide clean and readable. - Whitespace balance:
本周进展section should take roughly 60% of the body area,下周计划the remaining 40%. Adjust spacing so neither section looks empty or overflowing.
Workflow
- Calculate Dates: Determine the range — previous Saturday (MMDD) to this Saturday (MMDD).
- Read Daily Notes: Scan
50 Archive/Daily Notes/for each date in range. Look for sections under今日已毕or equivalent daily log headings. - Filter & Summarize: Extract only 科研/项目 items. Group by theme across the week into concise bullet points.
- Fill Template: Use the
pptxskill to edit the template. Only modify body text placeholders — never touch the slide master, header, or layout structure. Ensure the result is exactly 1 slide. - Output: Save as
00 Inbox/UserName_YYYY_MMDD_MMDD_week_report.pptx.
QA Checklist
Before delivering, verify:
- Exactly 1 slide
- Header area (name + logo) is untouched — matches template exactly
-
本周进展and下周计划sections are both present and populated - No tool/config/setup items leaked into the content
- Line spacing is even and the slide doesn't look cramped or sparse
- No placeholder text (e.g.
xxxx,1.) left over from template