The Scheduler Agent compares the work plan with progress on site every week, and tells you early which work items are falling behind. It reads one workbook. This guide shows how to set it up in three steps, with a picture of every screen.
- 1Get the templateChoose, preview, download. About 5 minutes.
- 2Fill in plan and progressThe plan once; progress every week.
- 3Check, then sendAlready have an S-curve or weekly report? Check it here.
Step 1 · Get the template
Choose Schedule & progress. If the Cost Agent reads the same workbook, choose Cost + Schedule (complete): the RAB Upah tab is shared.
- Yellow title: a column you fill in.
- Blue title: calculated by a formula. Don’t type in it.
- Rows 5–6: fictional EXAMPLES. Replace or delete them.
Then press Download .xlsx (open it in Excel, or upload it to Google Drive) or Create in Google Drive (sign in with your Google account).
Step 2 · Fill in plan and progress
The first two tabs and the planned dates are filled once, from the approved schedule. Progress is updated every week up to the cut-off.
Three terms to know
- Bobot (weight): how big one work item is compared with the whole project. Structure worth 40% of the labour RAB weighs 40%.
- Cumulative: the total up to the cut-off, not just this week. Foundations at 90% means 90% of the foundations are done.
- Project progress = the sum of weight × progress of every item. Structure 40% × 45% done = 18 points.
2a · Petunjuk & Info Proyek
Project details, once at the start.
- Project code, name, block or scope, number of units
- Planned start and finish from the approved schedule
- Progress cut-off: the last day the weekly report covers
Common mistake: Use the same cut-off date as the cost report, so cost and progress compare the same week.
2b · RAB Upah
The list of work items and their weight. The Scheduler Agent uses it to know how big each item is.
- Work item, planned quantity, unit, planned labour rate
- Kode Pekerjaan (work code), for example UPH-01: the same code is used in Jadwal & Progres and Laporan Mingguan
- Bobot % (weight) is calculated from each item’s value; all items add up to 100%
Common mistake: If you already filled RAB Upah for the Cost Agent, use that same tab. Don’t make a second work list with different codes.
2c · Jadwal & Progres
The plan for each work item and its progress. One row per work item per reporting period.
- Work code and description, as in RAB Upah
- Planned start, planned finish, duration (days), weight %
- Period start and cut-off, planned % and actual physical % (cumulative up to the cut-off), status
Common mistake: Don’t move the planned dates because work is late. The original plan stays; the delay shows as the gap between planned and actual.
2d · Laporan Mingguan
The weekly report, one row per work item.
- Report number, week number, period start, period end (cut-off)
- Progress this week only and cumulative (up to the cut-off), planned and actual
- Planned and actual quantity, status, obstacles, next step, prepared and checked by, evidence (photos, opname)
Common mistake: Don’t add last week’s cumulative progress to this week’s: the cumulative figure already includes every earlier week.
Planned and actual costs are covered in the cost report guide.
Watch each column being filled
Choose a tab and press Play: each column is highlighted with a fictional example and how to fill it.
What is this tab? Name, block, number of units, start and finish dates, and the report cut-off date. Every agent reads the project details from here.
Fill column B (Isi) for every label. Labels with Wajib? = Ya are needed by the Cost and Scheduler agents. The values in column B are fictional EXAMPLES.
| Field / cell and what it means | Example entry |
|---|---|
| B5Kode ProyekA short code you choose for this project, for example its block and number. Use the same code on every tab and report. | CONTOH-C5 |
| B6Nama ProyekThe project or housing estate name as written in the contract. | Proyek Contoh Mentari |
| B7Blok / LingkupThe part of the project this workbook covers, for example one block or a range of unit numbers. | Blok C5 Kios |
| B8Tipe UnitThe type of building, for example Kiosk, Shophouse, or Type 36/60 (building area / land area). | Kios |
| B9Jumlah UnitNumber of units in scope. | 12 |
| B10Tanggal Mulai RencanaProject/activity start date, not the RAB document date. | 2026-04-01 |
| B11Tanggal Selesai RencanaThe date the work is planned to finish, from the contract or original schedule. The Scheduler Agent measures delay against it. | 2026-08-31 |
| B12Cut-off Biaya AktualLast date of material and labour costs recorded. | 2026-06-23 |
| B13Cut-off ProgresLast physical progress date. | 2026-06-23 |
| B14Cut-off Analisis BersamaMust equal the cost and progress cut-offs to compare them. | 2026-06-23 |
| B15Definisi Biaya AktualPlanned/revised values must not be treated as actual cost. | Biaya yang telah terjadi atau diterima |
| B16Dibuat / Diperiksa OlehWho is responsible for the data. | Tim Proyek Contoh |
| B17Terakhir DiperbaruiDate the workbook was updated. | 2026-06-23 |
| B18Catatan LingkupExclusions, scope changes, or purchases before installation. | DATA CONTOH FIKTIF: ganti semua nilai sebelum digunakan. |
| B19Nomor UnitUnit numbers/range in scope. | 1–12 |
| B20Lokasi ProyekProject location as in the original RAB. | Karang Joang, Balikpapan |
| B21Tahun ProyekYear the project runs. | 2026 |
| B22Status ProyekChoose: Rencana, Berjalan, Selesai, Ditunda or Dibatalkan. | Berjalan |
| B23Tanggal Persetujuan RABDate the baseline RAB was approved; not an actuals update date. | 2026-04-09 |
| B24Mata UangUse IDR for rupiah values. | IDR |
| B25Dasar Bobot ProgresSay whether progress is weighted by material+labour, labour only or material only. | Total Biaya Langsung |
| B26Disetujui OlehWho approved the reporting-period data. | Project Manager Contoh |
| B27Tanggal Persetujuan DataDate the cost and progress data were approved. | 2026-06-24 |
All worksheet instructions
Petunjuk & Info Proyek
Fill column B (Isi) for every label. Labels with Wajib? = Ya are needed by the Cost and Scheduler agents. The values in column B are fictional EXAMPLES.
- B5 Kode Proyek: A short code you choose for this project, for example its block and number. Use the same code on every tab and report.
- B6 Nama Proyek: The project or housing estate name as written in the contract.
- B7 Blok / Lingkup: The part of the project this workbook covers, for example one block or a range of unit numbers.
- B8 Tipe Unit: The type of building, for example Kiosk, Shophouse, or Type 36/60 (building area / land area).
- B9 Jumlah Unit: Number of units in scope.
- B10 Tanggal Mulai Rencana: Project/activity start date, not the RAB document date.
- B11 Tanggal Selesai Rencana: The date the work is planned to finish, from the contract or original schedule. The Scheduler Agent measures delay against it.
- B12 Cut-off Biaya Aktual: Last date of material and labour costs recorded.
- B13 Cut-off Progres: Last physical progress date.
- B14 Cut-off Analisis Bersama: Must equal the cost and progress cut-offs to compare them.
- B15 Definisi Biaya Aktual: Planned/revised values must not be treated as actual cost.
- B16 Dibuat / Diperiksa Oleh: Who is responsible for the data.
- B17 Terakhir Diperbarui: Date the workbook was updated.
- B18 Catatan Lingkup: Exclusions, scope changes, or purchases before installation.
- B19 Nomor Unit: Unit numbers/range in scope.
- B20 Lokasi Proyek: Project location as in the original RAB.
- B21 Tahun Proyek: Year the project runs.
- B22 Status Proyek: Choose: Rencana, Berjalan, Selesai, Ditunda or Dibatalkan.
- B23 Tanggal Persetujuan RAB: Date the baseline RAB was approved; not an actuals update date.
- B24 Mata Uang: Use IDR for rupiah values.
- B25 Dasar Bobot Progres: Say whether progress is weighted by material+labour, labour only or material only.
- B26 Disetujui Oleh: Who approved the reporting-period data.
- B27 Tanggal Persetujuan Data: Date the cost and progress data were approved.
RAB Upah
Rows 5–6 are fictional EXAMPLES: replace or delete them. Fill the yellow cells; grey cells are calculated. Hover a column title for a note on how to fill it.
- B5 Uraian Pekerjaan: Budget item or work item. Enter: Specific text. Example: Pekerjaan pondasi
- C5 Volume Rencana: Quantity in the approved RAB. Enter: Zero or a positive number. Example: 12
- D5 Satuan: Unit of measure. Enter: unit, m, m², m³, kg, zak, batang, ls and the like. Example: unit
- E5 Harga Upah Rencana: Baseline price or rate per unit. Enter: Zero or a positive rupiah amount. Example: 5,000,000
- F5 Total Upah Rencana: Calculated; don’t type here. Baseline value of the item. Enter: Volume × unit price; a rupiah amount. Formula: Volume Rencana × Harga Upah Rencana.
- G5 Bobot %: Calculated; don’t type here. Item share of the baseline value. Enter: 0%–100%; all items should total 100%. Formula: Amount ÷ total of all items.
- H5 Kode Pekerjaan: Links RAB, actual cost, schedule and progress. Enter: A unique, consistent text code. Example: UPH-01
- I5 Tanggal/Versi RAB: Approved baseline version. Enter: YYYY-MM-DD or a clear version code. Example: 2026-03-20 Note: recording it once in Petunjuk & Info Proyek → Tanggal Persetujuan RAB is enough; add this column only if rows come from different versions.
- J5 Sumber Sheet: Name of the old sheet the row came from, for tracing. Enter: Text; e.g. RAB Material Lama. Example: RAB Upah Lama
- K5 Range Sumber: Cell range the row came from, for tracing. Enter: A cell range; e.g. C12:H12. Example: B12:H12
- L5 Catatan: Any extra remarks. Enter: Free text.
Jadwal & Progres
Rows 5–6 are fictional EXAMPLES: replace or delete them. Fill the yellow cells; grey cells are calculated. Hover a column title for a note on how to fill it.
- A5 Kode Pekerjaan: Links RAB, actual cost, schedule and progress. Enter: A unique, consistent text code. Example: UPH-01
- B5 Uraian Pekerjaan: Budget item or work item. Enter: Specific text. Example: Pekerjaan pondasi
- C5 Mulai Rencana: Baseline dates of each activity. Enter: YYYY-MM-DD. Example: 2026-04-01
- D5 Selesai Rencana: Baseline dates of each activity. Enter: YYYY-MM-DD. Example: 2026-05-15
- E5 Durasi (hari): Activity length. Enter: A positive whole number. Example: 45
- F5 Bobot %: Activity weight in project progress. Enter: 0%–100%; should total 100%. Example: 30%
- G5 Awal Periode: Progress measurement period. Enter: YYYY-MM-DD. Example: 2026-06-17
- H5 Cut-off: Progress measurement period. Enter: YYYY-MM-DD. Example: 2026-06-23
- I5 Progres Rencana %: Cumulative progress that should be reached. Enter: 0%–100%. Example: 30%
- J5 Progres Aktual Fisik %: Cumulative progress actually reached. Enter: 0%–100%. Example: 30%
- K5 Status: Activity state. Enter: Belum Mulai; Berjalan; Selesai; Tertunda. Example: Selesai
- L5 Sumber Sheet / LM: Sheet or weekly report the progress came from. Enter: Text; e.g. LM 12. Example: LM Contoh 12
- M5 Range Sumber: Cell range the row came from, for tracing. Enter: A cell range; e.g. C12:H12. Example: D5:J12
- N5 Catatan: Any extra remarks. Enter: Free text.
Laporan Mingguan
Rows 5–6 are fictional EXAMPLES: replace or delete them. Fill the yellow cells; grey cells are calculated. Hover a column title for a note on how to fill it.
- A5 No. Laporan: Report identity and week number. Enter: Report text/code and a positive whole number. Example: LM-CONTOH-12
- B5 Minggu Ke-: Report identity and week number. Enter: Report text/code and a positive whole number. Example: 12
- C5 Awal Periode: Week range and cut-off date. Enter: YYYY-MM-DD. Example: 2026-06-17
- D5 Akhir Periode / Cut-off: Week range and cut-off date. Enter: YYYY-MM-DD. Example: 2026-06-23
- E5 Kode Pekerjaan: Links RAB, actual cost, schedule and progress. Enter: A unique, consistent text code. Example: UPH-01
- F5 Uraian Pekerjaan: Budget item or work item. Enter: Specific text. Example: Pekerjaan pondasi
- G5 Bobot %: Activity weight in project progress. Enter: 0%–100%; should total 100%. Example: 30%
- H5 Progres Rencana Mingguan %: Weighted contribution of that week only. Enter: 0%–100%. Example: 10%
- I5 Progres Aktual Mingguan %: Weighted contribution of that week only. Enter: 0%–100%. Example: 8%
- J5 Progres Rencana Kumulatif %: Weighted contribution up to the cut-off. Enter: 0%–100%; all activities add up to project progress. Example: 30%
- K5 Progres Aktual Kumulatif %: Weighted contribution up to the cut-off. Enter: 0%–100%; all activities add up to project progress. Example: 30%
- L5 Volume Rencana: Target and achieved quantity. Enter: Zero or a positive number. Example: 12
- M5 Volume Aktual: Target and achieved quantity. Enter: Zero or a positive number. Example: 12
- N5 Satuan: Unit of measure. Enter: unit, m, m², m³, kg, zak, batang, ls and the like. Example: unit
- O5 Status: Activity state. Enter: Belum Mulai; Berjalan; Selesai; Tertunda. Example: Selesai
- P5 Kendala: Obstacles affecting progress. Enter: Short text; enter Tidak ada if none. Example: Tidak ada
- Q5 Tindak Lanjut: Corrective action or next step. Enter: Concrete text; add who and by when if known. Example: Lanjut ke pekerjaan dinding
- R5 Dibuat Oleh: Who prepared and who checked the report. Enter: Name, team or role. Example: Tim Lapangan Contoh
- S5 Diperiksa Oleh: Who prepared and who checked the report. Enter: Name, team or role. Example: Pengawas Contoh
- T5 Sumber / Bukti: Progress reference. Enter: Photo, opname, BAST, report number or where the evidence is. Example: Foto/BAST-EX-001
- U5 Catatan: Any extra remarks. Enter: Free text.
Step 3 · Already have an S-curve or weekly report? Check it
Many teams already keep an S-curve, a Gantt schedule and weekly reports. Upload the workbook below: the tool recognises the per-item schedule and adds the missing columns. S-curves and weekly reports are left as they are, with an explanation of where their data goes. Your values and formulas are not changed, and the file isn’t sent anywhere.
Workbook in a mess? Follow the fix plan
A first workbook from site often mixes several blocks in one tab, writes dates and numbers as text, or lays out progress with the dates across the columns. The tool does more than match columns: for each sheet it says what it is, where its data should go, and what to fix. The easiest route: download a template in Step 1, then move the data across sheet by sheet following this plan.
Complete your workbook
Upload one .xlsx file containing all sheets, or select a Google workbook. Then choose how to complete it. Data is processed in your browser. Google writes happen only when you choose Save.
No workbook yet? Start from a template. Using your own workbook? Check it here so the columns the agent needs are added.
2. Choose the workbook
Use Google Sheets
Connect your account and choose which workbooks to share. You can still upload local files below.
Whole-workbook report
Every sheet is checked automatically. Tables are recognised from their column headers, not just sheet names. Correct any wrong detection on each sheet.
What was detected
Details per sheet
Links between sheets from matching IDs
This report counts existing data; it does not invent missing amounts or dates and does not total costs. A link is proven only when every ID finds one unique match.
Optional: fill blank cells from another workbook
Choose a second workbook of the same report type. Each table is matched to the same template table in that workbook using the template’s ID (for example Proyek/Blok + Unit + No. Invoice). Only blank cells are filled, including ticked new columns; rows without a match or with repeated IDs are skipped, and source rows are never appended. A workbook in another format (an old RAB into the Format Komander, say) works too: rows are matched by item name, and you tick each suggestion before it is filled.
Save to Google Sheets
Only blank cells are filled. Avoid simultaneous edits while saving. Changes since loading will be checked again.
Review all Google changes
New columns remain blank without source data. Existing values and formulas are not overwritten. Review column order and agent readiness after merging; this tool does not certify the workbook for agent import.
How to open the result in Google Sheets
Download the copy, upload it to Google Drive, and open with Google Sheets. Choose File → Save as Google Sheets. Your original workbook stays unchanged. For a new workbook with all template tabs, formulas and validations, use Create my Google workbook above.
Before you send it to the agent
- The EXAMPLE rows are replaced or deleted.
- Work codes are exactly the same in RAB Upah, Jadwal & Progres and Laporan Mingguan.
- The weights of all work items add up to 100%.
- Planned dates were not moved because of delays.
- Actual progress is cumulative up to the cut-off, with evidence (photos, opname).
- The cut-off matches the cost report.
Workbook glossary · Opname and baseline filling guide
Ready to use the Komander agents on your projects?
When your workbook is complete, apply for a pilot: we help connect your project data to the Finance, Cost and Scheduler agents and review the first reports with you.
Send to melwani@komander.ai. Your workbook check result is included when there is one; the workbook itself is not sent.
Common questions
What goes into a weekly construction progress report?
For each work item: this week and cumulative progress, plan against actual, site problems and next steps. It shows whether the project is on schedule.
How do I calculate physical progress?
Multiply each work item’s progress by its weight (its value divided by the total budget) and add them up. An item weighted 10% that is 50% done adds 5% to project progress.
What is schedule deviation?
The difference between planned and actual progress on the same date. A negative deviation means the project is behind: 45% planned and 40% actual is a deviation of minus 5%.
What is an opname?
A site measurement of completed work, usually a quantity or a percentage per item. It is the basis for actual progress and for paying labour contractors.
What about work measured in m3, such as cut and fill?
Progress can be recorded as a volume. The percentage is actual volume divided by planned volume: 79,108 of 85,000 m3 is 93%.