timeline-creator

Overview

timeline-creator generates a Qiscus-style project timeline (.xlsx) from a project assessment. Upload the assessment screenshot or spreadsheet and it transcribes the items directly — no retyping — then schedules them into the standard three-phase structure: Initiation → Development → Quality Management.

Dates are computed with WORKDAY.INTL formulas referencing an Indonesian-holidays named range, so the schedule stays correct when you adjust it in Excel. Development runs sequentially by default; items can be grouped to run in parallel to compress the schedule toward a target go-live date.

What It Asks For

Seven things, always confirmed before generating:

1. Client name
2. Project name
3. PM name(s)
4. Live expectation date (optional — used to suggest parallelization if the sequential schedule overruns)
5. Items to run in parallel (optional)
6. Kick-off estimation date
7. Item order confirmation — whether to follow the assessment order or reorder

Output

A styled .xlsx with two sheets:

• Main sheet — project header, phased task table (number, items, task, detail, duration, start/due dates, status dropdown), a color-coded calendar grid by inventory category, and a TOTAL MANDAYS sum that should always match the assessment total
• Holidays sheet — Indonesian public holidays, referenced by the scheduling formulas

How to Access

Get the skill from the shared Drive folder and install it into your Claude skills.

Example Prompts

Create a timeline for [Client] — here's the assessment screenshot.
Kick-off June 16, target live before August.

Build a project schedule from this assessment xlsx. Run the bot
development and widget items in parallel.

Related Tools

• kick-off-deck — embeds this timeline as a native Gantt slide