AutoEstimator Capital Construction Project Estimation Utility

AutoSoft Systems

2 Round Hill Court

East Greenwich, RI 02818

401.885.3631

401.884.5653 Fax

401.996.3631 Cell

AMDG

Decision Ready Information!

autosoft@aol.com

Commercial & custom multi-user computer software for a variety of applications including performance metrics, statistical analysis, data extraction and merger from multiple large databases, computer simulation and management information systems. Founded in 1982.

We know Excel! Whenever possible, Excel is the user interface, VBA is the programming language, ODBC connects to the database of your choice.

Pharmaceutical & Biotech

Construction Management

AMDG

AutoEstimator
Capital Construction Project Estimation Utility

The profitability of a project depends, in part, on the accuracy of the cost estimation. AutoEstimator is an easy to use utility to assist in this process.

The interface is (of course) Microsoft Excel. However, the interface file is opened "read-only" since all of the data is stored in a back end multi-user Microsoft Access database. This allows multiple users to simultaneously work with the AutoEstimator.

The Main Screen lists all of the projects that have been saved.

Note how all of the commands are placed in the left margin:

The CLONE command allows the user to clone an existing project to create a new project, with the existing project as the starting point.

The BACKUP APP command allows the developer (me or your VBA expert) to modify and backup the application

The BACKUP DB command backs up the Microsoft Access database. This command also executes whenever anyone opens the file.

Every screen has context sensitive HELP, displayed and hidden with the red HELP button:

ATTRIBUTES brings up the Attributes Screen. Attributes are user-defined properties that are used by AutoEstimator. This screen shot displays the "Project Status" attributes, which can be configured for the specific installation:

The PROJECT Screen is where the user enters basic project data. As with all AutoSoft tools, pale yellow cells indicate places where data entry is allowed. Unsaved changes are pink until the user clicks the green SAVE button.

The REVISIONS screen tracks the unlimited number of Revisions that can be managed for a single project. Note the CLONE button which allows one to use one revision as the starting point for another. Note the "Budget Sheet", "Clarifications", "Exclusions" and "Exhibit C" columns, which tell the user how many records there are in each of these categories.

Double - clicking on a Revision brings you to this screen, where basic information for the Revision is entered.

The EDIT BUDGET screen is where most of the "heavy lifting" is performed. Here the user builds up the estimate one cost code at a time. There are many different features on this screen that facilitate the estimation process, far too many to cover in this overview. Call AutoSoft for a demo of the many features, which can be done via Webex, screen sharing and the telephone.

The Clarification Screen:

The Exclusions Screen:

The Exhibit C Screen:

There are a number of Reports that are available as both Excel and PDF files. This is one of them:

Of course, AutoSoft can customize the reports as desired.

AutoEstimator comes pre-loaded with industry standard Cost Codes, however these can be edited if so desired.

Contact AutoSoft Systems for a demo of this powerful utility.

AutoSoft Systems | 2 Round Hill Court, East Greenwich, Rhode Island, USA 02818 | 401.885.3631 | Fax: 401.884.5653 | Mobile: 401.996.3631

This web page was last updated at 10/03/2016 07:21 AM and is written in EXCEL!

AXIOM is a Trademark of Consona - USYS is a Trademark of Zumbach - AutoSoft Systems is not affiliated with Consona nor Zumbach