Select Page

custom Excel project: Case Study

Outcomes

Custom Excel Services Strategic Technologies Fort Collins

Improved communication between facilitators and risk assessment team

Custom Excel Services Strategic Technologies Denver

Created a way to customize the methodology for risk assessment as well as the reporting to management

Custom Excel Services Strategic Technologies

Designed a unique workflow to accommodate many types of risk assessment scenarios

Company: Strategic Technologies
Custom Excel Services Strategic TechnologiesGoal:  To more efficiently manage a risk assessment and strategy selection facilitation using an Excel application and reporting.

Custom Excel Services
Strategic Technologies

What We Built

Strategic Technologies works with sophisticated oil facilities across the world, but they had been relying on outdated software to perform a crucial risk assessment and strategy selection process.  This project aimed to allow users to use some of Excel’s built-in features in combination with highly advanced Excel forms and logic, so that the users could more efficiently make their strategy decisions as a team.

The processes used for this application involved a large number of worksheets and various methodologies for each user or facility.  The solution we created included variable features to allow the user to customize the data entry screens, the custom columns and menu assignments.  Each user could then customize the risk assessment process individually.

In addition, we designed several custom forms to help facilitate the speed of data entry. These forms connected data using several user defined functions, conditional formatting, and many more features.

Last, we added a custom report writer feature which allowed the user to choose the data to include in a report. Pre-built graphs were added with various styles available as well.

Custom Excel Services Strategic Technologies
“This is freaking amazing. It looks to be everything we ever wanted. Thanks so much for all your hard work!” Liz Smartt

VDC Engineer, Hensel Phelps

Need help with your custom Excel project?

Custom Excel Services Strategic Technologies