Key Features
Feature 08
Create Activity Code dictionary
No more time wasting creating your Activity Code dictionary in Primavera manually, use the Create Activity Code dictionary feature to quickly create as many Activity Code dictionaries in Excel and upload to Primavera P6.
Feature 10
Schedule Assessment
Instantly audit the health of any Primavera P6 XER schedule without leaving Excel. The Schedule Assessment tool analyses your project against 45 configurable checks across Activities and Relationships — including open ends, missing predecessors/successors, high float, negative float, duplicate IDs, lag violations, and logic density issues.
Set your own thresholds for Total Float, Original Duration, Actual Completion Date, and lead/lag values. Select only the checks relevant to your project, save your preferences, and generate a detailed report in one click. Ideal for schedule reviewers, planners, and PMO teams performing DCMA 14-Point or custom schedule quality assessments.
Key checks include:
Zero OD
Zero RD
High/Low TF
High OD
Negative TF
Missing Predecessor/Successor
Unsatisfied Logic
SS/FF Lag violations
High Predecessor/Successor Density
and more.
Feature 11
Advanced XER Cleaner
Sanitise and anonymise Primavera P6 XER files before sharing them with clients, contractors, or third parties — without opening P6. The Advanced XER Cleaner gives you granular control over exactly what data stays and what gets removed or obfuscated.
Choose to remove or obfuscate sensitive project data across Resources, Activity Codes, Resource Codes, User Defined Fields, Expenses, Notebook entries, WPs and Docs, Feedback, Role Codes, and Assignment Codes. Options to zero out resource rates and units, blank out UDFs, and remove POBS data ensure commercially sensitive information never leaves your organisation accidentally.
Perfect for contractors submitting schedules to clients, planners sharing baseline XERs for review, or companies with data confidentiality requirements on live projects.
Feature 12
Excel Utilities
A productivity toolkit built directly into RANGA’s Excel ribbon, giving construction planners instant access to the most common spreadsheet operations — no macros, no VBA knowledge required.
Organised into six categories for fast access:
Range — Fill Down, Insert before/after, Color duplicates, Color unique values
Row — Insert N rows at once
Column — Insert N columns at once
Text — Trim text, Clean text, UPPER CASE, lower case, Proper Case, Sentence Case
Numbers — Change text to numbers (fixes imported data that won’t calculate)
Formula — Change formula to value (paste-as-value in one click)
Stop losing time on repetitive formatting tasks when working with exported XER data, resource sheets, or cost reports. Excel Utilities turns multi-step operations into single clicks.