Aurora Tabular Editor: How to Configure, Edit, and Merge Project Data

Watch the Tutorials

The Aurora Tabular Editor brings project model and schedule data into a configurable, spreadsheet-style view. Users can review activity properties, make changes across multiple activities, and merge information from spreadsheets or other Aurora sessions.

Our three-part video series demonstrates how to use these capabilities, from configuring columns and saving views to filtering activities, making large-scale edits, and matching incoming data with existing model entries.

Part 1: Configure the Aurora Tabular Editor

A useful tabular view starts with the information you need to understand your model. Reviewing activity durations, checking schedule results, and preparing data for an update may each require a different selection of properties.

The first video introduces the Aurora Tabular Editor and explains how to configure its display. Selecting relevant columns helps users bring the properties they want to review or edit into one view. Sorting and adjusting column widths can make that information easier to navigate.

For example, a view intended to review durations might emphasize activity identifiers, names, and duration properties. A view intended to examine schedule results could instead focus on the corresponding schedule information.

Saving configurations also supports recurring work. Rather than rebuilding a display each time, users can return to a configuration suited to a particular review or update.

Part 2: Make Large-Scale Edits

Once the display is configured, the next challenge is updating the right activities efficiently. A change may apply to a specific group of jobs rather than every activity in the model.

The second video focuses on filtering and batch editing in the Aurora Tabular Editor. Filtering helps users narrow their attention to the most relevant information. Working with activities in a table makes it easier to review multiple properties together and apply changes across multiple entries.

Copying and pasting values between cells can reduce repetitive data entry. When several activities need the same property value, users can work with the relevant table entries rather than opening each activity separately.

Careful selection remains essential. Before making a large-scale change, one may wish to save out the current version possibly with a date & time info in the filename, then the users should confirm that the displayed activities and target columns correspond to the intended update before proceeding. Reviewing the resulting values helps confirm that the change was applied as expected.

Part 3: Merge Data from Multiple Sources

Project updates may come from spreadsheets or other Aurora sessions. Bringing that information into an existing model creates a matching problem: the incoming rows may not appear in the same order as the activities already in Aurora.

The third video introduces reference copy/paste for merging data into an Aurora model. This capability uses matching criteria to associate incoming information with corresponding model entries, rather than requiring perfect row alignment.

The approach is similar in concept to a spreadsheet lookup. It provides a way to transfer information based on a shared reference, making it useful when the source and destination organize their data differently.

For users managing repeated updates, this distinction matters. Correctly associating each incoming value with its intended activity is just as important as transferring the value itself.

Put the Three Tutorials Together

The series follows a practical progression: configure a useful view, focus on the activities that need changes, and match incoming information to existing model data.

Watch the three tutorials to explore how the Aurora Tabular Editor supports project data review and updates. For additional scheduling demonstrations and product tutorials, visit our Aurora Video Library.

Would you like a FREE Demo? Contact Us

Please enter your contact details, company name and a short message below and we will answer your query as soon as possible.

Contact Us