Development of a software solution that transforms Excel files in various formats into a single standard Excel format

Project Category: Software

Have A Chat!

About our project

Dynamic Risk Assessment Systems, Inc. has a tool for predicting potential areas of failure in oil and gas pipeline networks. The data used in their analysis needs to be in a structured format. Their current system of manually changing the format of files is slow and tedious. They require an efficient way to take semi-structured Excel files and transform them into a structured format for loading into their system. 

The solution will be a complete web-based solution as requested. It will have a user interface that will allow users to do the following: Upload their files (up to 25 files) to our system for transformation. Transform various input excel files into standard formats. Save the transformations as presets for the future. Having the ability to have backups of their files saved in our database for future usage. The system will have 2 types of users that provide different levels of access. Clients can only access the conversion of the files. Clients can upload and download input/output files, as well as defining input format and view the transformation history. The administrator can add, delete and modify the standard output type. The administrator also has all the functionality of a client.

Meet our team members

Hsiang-Wen (Vincent) Cheng
Yi-Fan (Frankie) Chen
Jiaxuan Tong
Terry Hung
Bennie He
Cheng Chen

Details about our design

HOW OUR DESIGN ADDRESSES PRACTICAL ISSUES

Our project provides solution for simplifying and automates process for files transformation. It also provides functionalities for text recognition/categorizations.

WHAT MAKES OUR DESIGN INNOVATIVE

Our project is innovative in the way that it is easy to use web solution. It provides an efficient and scalable platform with a high degree of usability that solves our sponsor’s need.

WHAT MAKES OUR DESIGN SOLUTION EFFECTIVE

It has high level of flexibility toward user’s need of transformation.

It is extremely easy to use! Couple simple clicks are all you need to complete an transformation!

HOW WE VALIDATED OUR DESIGN SOLUTION

We set validation tests at the very beginning of our design phases. We validate each tests after implementation!

We achieve a 76% success rate overall.

FEASIBILITY OF OUR DESIGN SOLUTION

Our project delivers all requirements, objectives and goals. The project is developed in a timely and efficient manner.

Partners and mentors

We want to thank the many people who helped us with this project. Our beloved Teacher Assistant Tariq Shoura, our Academic Advisor Emmanuel Onu, and a big thank you to our sponsor representative Joshua Chung.

Our photo gallery