Desktop Application for Simplifying Spreadsheet Conversion Tasks

Dotsquares developed a desktop application for SES, automating pivot table conversions into predefined formats. With custom threshold settings and ID capture, it streamlined workflow, reduced manual effort, and boosted efficiency, enabling focus on strategic tasks in cost estimation.

Desktop Application for Simplifying Spreadsheet Conversion Tasks

The Client

Strategic Estimating Systems (SES), based in Houston, TX, is a leading global provider of economic evaluation solutions. Specialising in independent third-party cost estimation, SES offers cost estimator training, software implementation, project management, and project controls across various project stages, delivering precise and reliable services.


The Challenge

SES faced challenges in efficiently converting pivot table spreadsheets into a predefined format. They required customisation options to set threshold values and exclude specific fitting types like PIV, while ensuring compatibility with predefined symbols and abbreviations for pipe fittings. Manually capturing IDs from pivot tables without geographic identifiers was labour-intensive and prone to errors, necessitating a desktop application to automate these tasks and streamline the conversion process.

The Solution

Dotsquares developed a user-friendly desktop application for Windows and macOS to automate spreadsheet conversion tasks for SES. The application enables users to upload pivot table spreadsheets and convert them into a predefined format with high accuracy. Features include custom threshold settings, dedicated buttons to exclude specific fitting types, and direct ID capture from pivot tables, eliminating manual geographic identifier entry. The application provides the file path for easy access to transformed files, simplifying the workflow and enhancing user experience through an agile development approach.

The Results

The Excel automation application transformed SES’s workflow, enabling seamless transfer and sorting of large datasets from pivot tables into a defined format. Previously labour-intensive and time-consuming, the process now completes in minutes, boosting efficiency and productivity. By eliminating repetitive manual work, the tool allowed focus on strategic tasks, meeting SES’s needs and demonstrating Dotsquares’ ability to deliver impactful solutions.

THE DETAILS

Company: Strategic Estimating Systems

Location: United States

Industry: IT & Technology

Duration : 1 month

WHAT WE DID

Developed Desktop Application

Automated Spreadsheet Conversion

Enabled Threshold Settings

Excluded Specific Fittings

Streamlined ID Capture

Enhanced User Workflow

TECHNOLOGY WE USED

Python

PyQT

What can we
do for you?

sidebar

Unlock Savings — 10% Off On First Invoice

sidebar