From dozens of Excel files to a single source of truth: how Qstomize manages 185 R&D projects with Triskell
Unified portfolio, synchronized schedules and milestones, consolidated workloads: Qstomize has industrialized its R&D governance using a single solution connected to Renault’s information system (ERP + planning tool), with reliable, real-time synchronized data.
Key figures
185
projects migrated
50
users trained
6
Go-live in ~6 months
30
≈ 30% of one FTE saved
The project at a glance
Objective:
Deploy a single source of truth for R&D management—portfolio, schedules, workloads, and resources—fully integrated with Renault’s information system (ERP + planning tool).
In ~6 months:
185 projects migrated, 50 users trained, full cutover completed, and Excel files completely eliminated.
About Qstomize
For nearly 14 years, Qstomize, a Business Unit specializing in bespoke industrial transformations, has been supporting Renault Group in the development and production of customized solutions for passenger and commercial vehicles.
- 270,000 vehicles transformed per year.
- 326 employees across France and Europe.
- €123M in annual revenue.
Context
Qstomize managed more than 120 projects per year using a multitude of scattered Excel files: portfolios, schedules, workloads, resources, etc.
Each team relied on its own files, rarely aligned and often outdated.
Key challenges:
- Significant time losses.
- Low data reliability.
- Difficulty anticipating functional workloads.
- Lack of a consolidated portfolio view.
Under these conditions, feeding governance bodies or arbitrating projects on a solid factual basis was impossible.
Qstomize needed a single, structuring, and scalable tool to centralize information, secure R&D governance, and support the growth of its activity.
Why Triskell?
After reviewing market solutions, Triskell stood out thanks to:
- A flexible platform adaptable to Qstomize’s processes.
- A robust yet configurable foundation, ideal for engineering-specific requirements.
- A smooth, intuitive user experience accessible via a simple web interface.
- Full compatibility with Renault systems (ERP and planning tool).
The solution perfectly addressed the core need: unifying project, schedule, and workload management within a single environment.
Solution implemented
The Triskell solution now covers the full scope of operational and strategic project management:
- Full portfolio management (185 projects migrated).
- Individual project schedules with milestones and dependencies.
- Detailed workload management by function (design office, validation, testing, homologation, documentation, industrial processes, etc.).
- Consolidation of global workload and capacity planning.
- ERP integration (time tracking, purchasing data).
- Connection with Renault’s planning tool to synchronize milestones.
- Role-based access rights, multi-site access, and customer/production views.
The result: a unified, real-time, fully structured R&D governance framework.
Benefits
1. Significant time savings
- 30% of one FTE saved immediately on workload and resource management.
- Elimination of multiple updates across numerous Excel files.
2. Reliable, real-time data
- Automatic schedule updates.
- Instant consistency between workloads, milestones, and capacities.
3. Smoother governance processes
- Workload intake committees, schedule arbitrations, and operational reviews fully managed in Triskell.
4. A single, centralized tool
- Fully unified project portfolio.
- Complete elimination of Excel files: one single source of truth.
With Triskell, our Excel files have finally disappeared. All project information is now available in real time, accessible to everyone, and automatically synchronized.The gains in time, reliability, and operational fluidity were immediate.
Bettina Proux – Engineering Director at Qstomize
Company Overview
Industry
Automotive Engineering & Industrial Transformation
Type
Private
Region
France – Europe
Solution
R&D Project Portfolio Management
Workload & Capacity Planning
Website
Highlights
Business challenges
Fragmented project management
Low data reliability.
Lack of consolidated R&D portfolio visibility.
Difficulty anticipating engineering workloads.
Benefits
Single source of truth
Significant time savings
Real-time, and reliable data
Improved workload forecasting
Financial clarity
Request a demo of Triskell Software
Want to learn more? Request a free demo of Triskell Software and you will discover the PPM software that best suits your business needs.
