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.
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.
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.
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 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.