Case Study #1

Excel File to Web

We were approached to convert an Excel calendar to a secure web portal. The portal eliminated the problems management faced updating and distributing updated calendar information.

It also created new value by adding unique dashboards for each installer, where they saw only the calendar information they needed. Further, install techs could upload pictures and videos against the job and acquired mobile access to job information and specs on the road.

Lastly, the project established a web portal the company could use to leverage future field based projects, where information is traditionally only on the network.

 

Case Study #1

Excel-based File - Problem #1

The Excel-based calendar was a static resource on the network. Updates were hard to communicate to the install team. New versions of the calendar were painful to distrubute to the team in the field. In addition, there were conflicts when several managers were viewing and editing the document at the same time.

Read More

Web Based Solution

With the web based solution each field installer had an individual dashboard (See our dashboard engine). The install team could login though their mobile devices to see an actuate version of the schedule, which was converted to a database driven web app. Management could update the schuedule from a friendly "Excel-like" management dashboard.

Read More

Excel-based File - Problem #2

The calendar represented jobs on schedule. All the information about start dates and job details were stored in a seperate database. This information had to be communicated seperately to the install team - information such as equipment specs, manuals, ect. Also, job start dates and calendar dates were being updated in two seperate places.

Read More

Web Based Solution

Inventore dolores aut laboriosam cum consequuntur delectus sequi! Eum est.

Read More

Clean Design and Code

Voluptatem ad provident non repudiandae veritatis beatae cupiditate amet reiciendis.

Read More

Latest Technologies

Inventore dolores aut laboriosam cum consequuntur delectus sequi! Eum est.

Read More