Manpower

Location on ribbon: Tab DVD Cons → Group Schedule → Menu Reports

Command ID: btnManpower

PRO feature

This command is part of the PRO plan. STANDARD accounts activated before 01/07/2026 keep access until their licence expires; other Standard accounts get an upgrade prompt when they click it.

What it does

Reads the manpower column on the schedule sheet (it recognises headings such as Nhân lực, Manpower or Crew), sums the workers active on each day, and plots a weekly peak histogram with an average reference line. Weeks whose peak is more than 10% above the average are highlighted in red as over-allocated, levelling candidates. This is the feasibility check most programmes skip: the logic looks fine, but one week demands 400 workers when the site can only accommodate 250.

How to use

1. Open a schedule sheet whose manpower column is filled in per activity. Without such a column the command still runs and falls back to counting concurrent activities.
2. Run Auto Calc so start and finish dates are current — the histogram spreads each crew over the activity's actual dates.
3. Go to Tab DVD Cons → group Schedule → menu Reports → click Manpower.
4. The command runs immediately: no dialog, no selection needed.
5. Read the chart: each column is one week's peak headcount, the horizontal line is the average, and weeks more than 10% above it are highlighted in red.
6. Go back to the schedule, shift activities that still have positive float out of the peak weeks, then rerun to see whether the curve has flattened.

Video tutorial

Narrated in Vietnamese, with Vietnamese subtitles. Nhân lực và Cân bằng nhân lực · 6 min 08 s · 14 cases · Download the video · Practice workbook for the video

Commands in this video: Manpower · Level resources

Chapters (18)

1. Giới thiệu
2. Mở lệnh
3. 1 · Cột Nhân lực
4. 2 · Cộng theo ngày làm việc
5. 3 · Tên cột được nhận
6. 4 · Dòng tổng không cộng trùng
7. 5 · Ô trống, ô ghi chữ
8. 6 · Phân bổ không đều
9. 7 · Cân bằng: không kéo dài
10. 8 · Báo cáo, áp, hoàn tác
11. 9 · Kiểm lại bằng Nhân lực
12. 10 · Trần quá thấp
13. 11 · Ép theo giới hạn
14. 12 · Khoá việc đã làm
15. 13 · Giữ quan hệ công tác
16. 14 · Khi nhập sai
17. Mẹo
18. Kết thúc

Illustrated walkthrough

Practice

Download this command's sample workbook — the data matches the pictures below (sheet Schedule), so you can follow each step right away.

Step 1. Open the schedule sheet with a Manpower column (1) — the crew size per day for each activity (without it the command counts concurrent activities instead). Run Auto Calc so the dates are current.

Step 2. On the ribbon, open the DVD Cons tab → Schedule group → open Reports → choose Manpower.

Step 3. The command runs straight away, with no dialog. The Nhan luc 2026-09-28 sheet shows a peak of 48 workers on 01/10/2026 (1) and the weekly peak table — the 3 over-allocated weeks (more than 10% above the 27.7-worker average) are shaded red (2). The weekly-peak column chart with a dashed average line sits to the right, from column F.

Step 4. Go back to the schedule, move activities that have float out of the peak weeks (or use Level resources), then run the command again to check.

Example

Fit-out package on an office tower, planned average of 180 workers. The histogram reports:

Week	Peak headcount	Against average
W31	165	Below average
W32	172	Below average
W33	268	Over-allocated
W34	254	Over-allocated
W35	141	Below average

Weeks 33–34 stack tiling, painting and ceiling crews on top of each other. The site manager pushes the ceiling crew back by one week (that activity still has 6 days of float) — the peak drops to 210, which fits the accommodation capacity without moving the completion date.

Notes

• The command is read-only: it never levels resources or moves dates for you — the decision to reschedule stays yours.
• The manpower heading must be one the command recognises (Nhân lực / Manpower / Crew); any other name sends it to the concurrent-activity fallback.
• Values are weekly peaks, not weekly averages, so the chart is a capacity and peak-load check.
• Non-working days of the workbook calendar (weekly rest days, holidays) carry no manpower, so the peaks, the average and the total man-days reflect the days actually worked.
• Blank manpower cells on some activities make the curve read lower than reality — fill them in before drawing conclusions.
• The chart sheet is regenerated on each run, and Ctrl+Z will not undo it.

Related

• Cash-flow — the same time-spreading logic applied to cost instead of labour.
• 3-Week Lookahead — inspect the weeks flagged as over-allocated in detail.
• Auto Calc — recompute dates and float before levelling anything.
• Gantt Chart — look at the bars to see which activities still have float to spend.