Esc

↑↓ move↵ openIndex · Pagefind
Scheduling / Editing and progress tools: fill down, paste, Excel round-trip, Global Change, Progress Spotlight and the schedule log

Editing and progress tools: fill down, paste, Excel round-trip, Global Change, Progress Spotlight and the schedule log

Edit many activities at once with range selection, fill down and copy and paste to and from Excel, round-trip the activity table through an Excel workbook, copy activities with their logic, make rule-based Global Changes with a preview, status a period with Progress Spotlight and Update Progress, and read the schedule log after every calculation.

On this page

These are the tools a P6 scheduler reaches for when there’s a lot to change: select a block of cells and fill it down, paste a column from Excel, copy a fragnet of activities, apply a rule to every activity that matches, and status a whole period at once. Each one is a draft edit. It goes through the same validation as typing in a cell, it’s one undo step (Ctrl+Z), and nothing is saved until you save and calculate. After every calculation, the schedule log tells you what to look at.

You need Schedule admin and the desktop Planner. The touch view doesn’t do range selection.

Select a range of cells

In the activity table, select a rectangle of cells by:

  • Shift+click on a second cell,
  • Shift+arrow keys, Home, End, Page Up and Page Down,
  • click and drag with a mouse or pen, or
  • Ctrl+A for every shown cell.

The toolbar says what’s selected, and Clear selection or Esc clears it. Ranges follow the rows and columns on screen, so filter and sort first to line up the activities you want.

Fill down

Select a range and press Ctrl+D (or Ctrl+E), or choose Fill down from the toolbar or the right-click menu. The top cell of each column is copied to the cells below it in the range.

  • Every value is checked as if you’d typed it, so P6 duration-type rules and finish-constraint conventions apply.
  • Calculated columns, such as dates, float and status, are never written. The notice names any it left alone.
  • Cells that can’t take the value are skipped and listed, with the reason for each.

Copy and paste with Excel

  • Copy cells (Ctrl+C) copies the selection as tab-separated text that pastes straight into Excel or Google Sheets.
  • Paste cells (Ctrl+V in the grid, or Paste cells… for a text box that also works with a keyboard or on a tablet) writes a block from Excel into the grid, starting at the top-left of the selection or the active cell, down and to the right.
  • Up to 20,000 cells at a time. A paste doesn’t create rows: cells that fall outside the shown rows or columns aren’t pasted, and the notice counts them.
  • Invalid and calculated cells are skipped and listed, as with fill down.

Round-trip the activity table through Excel

For changes too big to paste, export the activity table to an Excel workbook, edit it offline or hand it to someone, and import it back as a reviewed update. This is P6’s Import from spreadsheet. It works on the current saved plan, so you need Schedule admin and a saved version.

  1. Export. Open Schedule › Import file. In the Update from Spreadsheet panel, choose Columns from layout (Classic Schedule or any layout you can see) and Export to Excel. The workbook has one row per activity: Activity ID (the match key), Activity Name, then the layout’s visible columns, codes and UDFs included. A Columns sheet records each header’s column key and whether it’s editable, so renaming a header doesn’t break the import.
  2. Edit names, durations, % complete, calendars, constraints, activity types, codes and UDFs. Keep the Activity ID column. Editable cells are written exactly as the grid’s inline editor shows them, so a cell you don’t touch imports unchanged.
  3. Upload the edited .xlsx (up to 1.5 MiB) and choose what to do with Unknown Activity IDs: Reject (list them), or Add as new activities.
  4. Preview changes. The preview counts matched rows, changed cells, new activities and rejected cells, and lists each change with its before and after value. Every edited cell is checked by the same parser as typing in the grid. Changed calculated cells (dates, float, status) and values the grid would refuse are listed as rejected, never applied.
  5. Apply. Apply as plan version N saves one new version, calculates it and records an audit event. If the plan changed after you exported or previewed, the apply is refused; preview again.

The import saves straight to a new version; it doesn’t go into an open Planner draft as an undo step. Save or discard your Planner draft first, and open the Planner afterwards to see the result. Through the API, use GET /schedule/spreadsheet and POST /schedule/spreadsheet/preview and /apply (Schedule API).

Copy and paste activities

Copy activities copies the selected rows, the activities you’ve marked, or the selected activity. Paste activities… adds copies after the selected activity. You choose:

  • New activity IDs: auto-numbered (the next free A-number), or the copied ID with a prefix or suffix. IDs kept in saved history are never reused.
  • Relationships: between the copied activities only, also to activities outside the copy, or none.
  • Include: resource assignments, activity codes, user-defined fields and the notebook.

The notice shows each old → new ID and how many links and assignments were added.

Global Change

Global Change… (in the grid toolbar or the right-click menu) changes fields on every activity that meets your criteria, the way P6’s Global Change does.

  1. Name a spec and set its IF criteria. These use the same builder as filters: any column, code or UDF, with nested All/Any groups.
  2. Add THEN rows for matching activities and, optionally, ELSE rows for the rest, up to 20 of each. A row can set a field to a value; add, subtract, multiply or divide; set it from another field combined with a value; or append text. Numeric results can be rounded, for example to the nearest half day.
  3. Preview changes. The preview lists every activity and field that would change, with its old and new value and the branch (THEN or ELSE) that changed it. Activities that can’t take a change are listed with the reason.
  4. Apply changes. The whole change is one undo step.

Only fields you author can be targets. Calculated values, such as dates, float, criticality and status, are never offered and never written. Writes go through the same editors as a manual edit, so duration-type rules and constraint conventions still apply. Specs are kept in the layout, up to 50; save the layout to keep them for next time.

Progress Spotlight and Update Progress

Progress Spotlight highlights the work that should progress between the data date and the next status date. Update Progress then fills in that progress “as planned”, for you to review.

  1. Turn on Spotlight in the Planner’s Progress Spotlight panel. The window runs from the data date for one interval of the Gantt timescale. You can pick day, week, month, quarter or year instead.
  2. Size the window. Use + and −, drag the dashed spotlight edge on the Gantt, or focus the edge and use the arrow keys. The window always moves by whole intervals, up to 366. Its end is the proposed new data date.
  3. Check the list. The spotlighted activities are the unfinished ones whose calculated remaining work overlaps the window. Level-of-effort and WBS-summary rows are left out. They’re tinted on the Gantt and listed in the panel; click an ID to select it.
  4. Update Progress. Choose Update Progress for all spotlighted activities, or Update Progress for the selected activity.
  5. Review. For each activity, the review shows what will be filled in. An activity due to start in the window gets an actual start on its planned start. One due to finish gets an actual finish and zero remaining duration. One still running has its remaining duration cut in proportion to the working days the window covers, and its duration % complete updated. Milestones in the window are marked achieved. Anything planned to start after the window is skipped, with the reason.
  6. Apply to draft. Tick Advance the data date to move the data date to the window’s end at the same time. The change is one undo step. Correct anything that didn’t go as planned, then save and calculate.

If an update period is open, the panel names it and offers Spotlight through the update data date. Progress you enter then goes into that period’s checks and review.

The spotlight reads the last calculation, so save and calculate first. With unsaved edits, it still uses the last calculated dates and says so.

The schedule log

Every save and calculate writes a schedule log with the calculation, like the log P6 offers after scheduling. Open Schedule log in the Planner to see:

  • the options used, the critical path definition, and critical and longest-path counts;
  • Open ends (no predecessor or no successor);
  • Activities with constraints;
  • Out-of-sequence progress;
  • Started activities missing an actual start;
  • Actual dates after the data date.

Each section counts every finding and lists up to 2,000. An entry is marked when the DCMA health check names the same activity, because the open-end, hard-constraint and actual-date sections use the same rules as DCMA checks 1, 5 and 9. Click an activity to go to it. Download log (.txt) and Download findings (.csv) save it. The log belongs to the saved calculation. With unsaved edits, the panel says to recalculate. Through the API, use GET /schedule/calculations/{id}/log.

  • Mistake: Filling down a whole column with the wrong filter on

    In the app: Check the N of M count and the selection description first. If it goes wrong, Ctrl+Z undoes the whole fill.

  • Mistake: Pasting more rows from Excel than are shown

    In the app: A paste never adds rows. Paste activities to create new ones, then paste their values.

  • Mistake: Editing the Start and Finish columns in an exported workbook

    In the app: Dates are calculated, so the import rejects them. Change durations, logic inputs or constraints instead.

  • Mistake: Applying a Global Change without previewing

    In the app: Preview shows every old and new value and which branch changed it. Read it, then apply.

  • Mistake: Saving an as-planned update unchecked

    In the app: Correct the activities that slipped or finished early before you save and calculate.

Keep exploring

Related across os.construction

Run it on your own project.

Start a 14-day free trial. Want a say in what ships next? Join the founding program.

Your role (optional)

14-day free trial. Pricing for paid plans isn't set yet. Talk to us. Already have an account? Sign in →

Ask the OS

Reading this page

Ask anything about this page. Answers use what you're reading as context.

Suggested

    AI · may be imperfect · sample data where shown

    Open file