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.
- 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.
- 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.
- 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. - 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- Update Progress. Choose Update Progress for all spotlighted activities, or Update Progress for the selected activity.
- 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.
- 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.
Related
Keep exploring
Related across os.construction
- DocsP6 compatibility: settings, import, export and what round-tripsHow closely os.construction matches Primavera P6. Which scheduling settings the engine honours, which P6 calculated fields it works out, what crosses an XER or P6 XML file in both directions, the measured agreement with P6's own dates and costs, and the limits that remain.
- GlossaryProgress SpotlightA P6 view feature that highlights the activities that should have progressed between the current data date and a new one, as a guide for statusing.
- DocsViews and layouts: filters, Group & Sort, columns, Network and Trace LogicOpen and save P6-style layouts for yourself, the project or the company, export and import them as files, build filters with nested All/Any criteria and highlight mode, group and sort to five levels with totals, choose from 45 core columns plus baseline, cost, units and earned value columns, draw a progress line, read the logic in the Activity Network, Trace Logic and Assignments views, and roll the plan up in the WBS window.
- GlossarySchedule BaselineA preserved reference plan used to compare later progress and forecast dates against the agreed planning basis.
- BlogA construction schedule audit you can actually act onReview schedule logic, contract requirements and field evidence separately, then turn findings into specific actions with owners and due dates.
- BlogHow to build a three-week look-ahead schedule the field will actually useThe master schedule says what has to happen. The three-week look-ahead says who does it, where, and what has to be cleared first. Here is how to pull it from the master, break it down to crew level, screen every activity for constraints, get commitments from the trades, and roll it forward each week, with a worked example.
Was this helpful?
Run it on your own project.
Start a 14-day free trial. Want a say in what ships next? Join the founding program.
14-day free trial. Pricing for paid plans isn't set yet. Talk to us. Already have an account? Sign in →