BRAT Software

• 

  Builder Reporting and Analysis Tools

• 

  Create an estimate

Inspiration

Provide a full comparison of project costs across all phases: Estimate to Completion

What it does

Tracks project costs and elements through four key phases: Estimate, Contract, Planned, Actual with change control for Actual. One mouse click to create a Contract from Estimate, Plan from Contract, Actual from Plan. Stores all values for comparisons. Improves project planning, cost control, and estimates. Provides customer volume and payment insights. Change control includes reason for change. Improves schedule planning and enables cross-project comparisons for variable factors such as man, machine, and mother-nature. Reports highlight cost variances.

How I built it

Stared with the concept. Developed the database schema and tables. Added forms and reports. Developed VB scripts to handle updates and lock record sets.

Challenges I ran into

Defining the options for project elements. Each trade, general contractor, or specialty contractor may have different and discreet project elements to be tracked.

Accomplishments that I'm proud of

It works. My CFO likes it.

What I learned

Using VB to create nested SQL queries and updates

What's next for BRAT Software

Port to SQL with a C#/.Net front end

Built With

• access
• sql
• vb