Problem

Many companies are still tracking Maintenance projects and their Inspection of work done with Excel spreadsheets.

Using Excel as a database is fairly common practice in companies that don't have on-staff database programmers that can provide these types of data intensive applications.

Solution

Instead of using spreadsheets, the heart of this system is a database residing in Microsoft's Azure Cloud. This allows 'authorized' employees to access the data from anywhere, whether if be inside the company's network or out in the field doing inspection work.

Using a database has many advantages over Excel spreadsheets:

Enforcement of companywide standardization of data and reports
It is comprehensive, enabling users to get a clear picture of all projects
All Data can be backed up in one location
Data Calculation formulas reside in one place, not individual spreadsheets
Data replication is minimized as spreadsheets aren't required to be copied from machine to machine
Data integrity improves due to consistent data validation rules

Click the "Project List" link to interact with 7 "demo data" projects to see how the system works.

Try if Free

Try the system for free on your first project.

2-3 days to get your company database initialized.
You enter your contractor contact information (names, email addresses)
You enter the line items of your project.

That's it. You are good to go.

Current Features

Project List

Shows a list of active Projects with links to the Project and Weekly Progress pages.

Inspector Uploads

Inspectors download an app to their phone, tablet or laptop. That app allows them to download a project to be inspected. Once an inspection has taken place and the inspector logs the completed work, they upload it to the central database.

Weekly Progress

Shows all Project Line Items and the Weekly Progress as reported by the Inspector. YTD unit totals, YTD unit total variance, YTD $ total and YTD $ variance. Sub totals, Project tax and grand totals are shown.

Project

Shows a list of Line Items with their associated Qty, Units, Unit Cost and Total Bid. This page also allow you to 'cut and paste' from an excel bid sheet to automatically import the data into the project.

Bid Request

Shows a list of Projects and a list of Companies (contractors). When you select one of each it builds an email (and shows the text on the page for review) to send to the contractor, inviting them to submit a bid on the selected Project. The email has a unique secure link that takes them to the Bid Sheet page where they can enter Line Items and their Qty, Units and Unit Costs. No need for spreadsheets. The system records when and who the Bid Requests are sent to. This history is shown on the page.

Bid Sheet

As mentioned above, this page is a data entry form where the contractor can key in their bid. All bids are stored in the database allowing you to select the winning bid.

Companies

A list of companies, their contact’s name, email and phone number. As mentioned above, this is the list used when selecting who to send a Bid Request to.

OilAndGasWorks

Your Company Name