---
name: "timeline-creator"
description: "Generate a Qiscus-style project timeline .xlsx from an assessment — phased task table, WORKDAY formulas with Indonesian holidays, calendar grid, and mandays totals."
type: skill
roles: ["Project Management"]
activities: ["Planning", "Project Delivery"]
tags: ["Timeline", "Gantt", "XLSX", "Project Planning"]
owner: "Yayan Adipraja"
sourceUrl: "https://drive.google.com/drive/folders/1VzbIiJQjtGUf9vEbcscRyrlE4s8_v3PW"
---

# timeline-creator

> Generate a Qiscus-style project timeline .xlsx from an assessment — phased task table, WORKDAY formulas with Indonesian holidays, calendar grid, and mandays totals.

## 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](https://drive.google.com/drive/folders/1VzbIiJQjtGUf9vEbcscRyrlE4s8_v3PW) 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](/tools/kick-off-deck/) — embeds this timeline as a native Gantt slide