Founded in 2000, Florida based MGC Roofing and Construction manage roofing system replacement projects for the Government & Municipal, Hospital, Education, Corporate, Retail and Hospitality sectors throughout the United States.

The Challenge

As the business grew, MGC’s demand for more and better information systems grew with it. Due to volume, many manual processes were becoming unwieldy and they were in urgent need of system automation, application integration  and improved data consistency across the group of companies

Systems in use include Smartsheet, SQL server, and Excel. To get their project financial information, (in an SQL application), in front of their PMs, the data was extracted to Excel, manually transferred to Smartsheet weekly, and then an expensive third party tool was used to make sure everything was synchronized properly. The workflow was taking up too much of their time.

The Solution

First the existing Excel workbook that collected the data from the various companies’ financial information was stabilized and improved. There was now one version of the truth on the Excel side. Next, by introducing AppSheet, an application integration tool, with user interfaces on any device, the data in Excel and Smartsheet was synchronised in all directions producing one version of the truth in real time for all user views. Further, the App provided  the added benefits of improved communication between the PMs and the CEO, including collecting meeting notes and action items related to each project.

The Benefits

Michael now has his finger firmly on the pulse on the status of all his projects in real time, so too do his managers. Exceptions demanding immediate attention are properly defined and identified, including new job schedule immediately absorbed into the smooth workflow. The financial reporting is much improved, for example, project status against budget, progress against schedules, timescales all now completed to meet their requirements.

Testimonial

I am not easily satisfied by poorly performing systems but working with the team at Smarter Business Processes,  primarily Craig Williams and Mary Jane Pender, they helped me to scope out exactly what we required in 4 separate phases of activity and delivered each phase on time, on budget and to a very high standard.  My managers and I are delighted with the outcome and are now better equipped to fully  focus on our clients at a time when  multiple hurricanes are assaulting our Southern States.  Michael Levine – Chief Executive Officer – MGC Roofing and Construction Inc

The post Construction Company works smarter with Smartsheet and AppSheet solution appeared first on SmarterBusinessProcesses.

Providing increased efficiency, freedom and flexibility to complete the tasks at hand, and enhanced project communication and collaboration, mobile tools have real benefits for businesses.

Many contractors are using apps for project management to;

• Capture onsite real-time data,  location, signatures,  scan bar codes,  even work offline
• Keep track of project costs, budgets and timesheets
• Manage vendor, subcontractor and project details

See how our Smartsheet and AppSheet solution helped MGC Roofing and Construction

See our Sample Apps in Action – Try our favourite AppSheet Mobile Apps for free

Site Scout, an app for construction site inspections with GPS and images, that allows users to capture inspection information for specific sites.  Built with Google Sheets and AppSheet, the app automatically captures GPS locations, collections images, and allows customization of the collected data.

Quote Calculator enables contractors to calculate payment owed based on services rendered, and is a useful tool to quickly and easily calculate costs of services. The app allows users to input numerical data in to the app, calculate and display the results, and save the entry for future recall.

Repair Manual is a useful app for any business that needs to provide an instruction manual to employees or customers. This app has step-by-step instructions for repairing dry-wall, with helpful images that demonstrate each step clearly.

Timesheet  for tracking employee hours and wages,  This convenient app easily tracks log times in and out to compute hours and calculate total wages, providing all necessary information for accounting or human resources departments. This app uses information capture via forms, app formulas, virtual columns, references, and image display.

Our trial Apps are great for seeing what they can do. You’re welcome to copy, customize and make them your own but we do recommend letting us help you personalise the Apps to your exact requirements.

Payroll

Using mobile apps to file times sheets and process payroll can help boost efficiency, since workers can clock in on their mobile devices and report to work immediately on their mobile devices. GPS tracking and biometrics capabilities can also help reduce time fraud. And real-time information can be immediately processed via mobile apps, reducing response time and increasing efficiency.

 Project Management and Collaboration

Mobile apps can connect the various parties involved in any construction project, from architects to engineers to project managers. Mobile apps and devices can help actively manage activities, employees, information, and processes associated with a given project and even control scheduling. Mobile apps allow project managers to download blueprints, sync information in real-time, and communicate with the job site.

One popular app for project management  is the Photo Measures App, which allows users to measure dimensions captured in photos. It has a user-friendly interface, and users can quickly record and save measurement on a frequent basis.

Another app that helps reduce planning time and boost efficiency in construction projects is Plan Grid, which allows project managers to easily share plans, markups, photos, and reports with the entire project team from anywhere. PlanGrid can be used with or without an internet connection during construction to track revisions, document progress, and manage issues in the field while keeping everyone on the current set.

Mobile Apps Reduce Constructions Costs

According to Go Canvas, statistics show that 50 percent of a worker’s time while on the clock is devoted to wasteful activity caused by poor and outdated communication like paper forms and time wasted searching for information or recreating documents they couldn’t find.

Let AppSheet help you raise the roof on your construction job site with custom mobile apps. 

Complete our AppSheet Appraisal Form or simply Contact Us to discuss your needs.  We’d love to hear from you!

The post How Mobile Apps Can Increase Your Construction Site Productivity appeared first on SmarterBusinessProcesses.

For construction companies, Smartsheet delivers increased project efficiency and accountability by streamlining communication and documentation, ultimately boosting safety and profits.

Construction is the ultimate “just get it done” business. And Smartsheet is the collaborative work management solution that many of the world’s largest construction companies rely on to stay productive, communicate among far-flung teams, and document every step of every project.

See Case Study for MGC Roofing and Construction

Implementing AppSheet alongside Smartsheet has allowed us to extend Smartsheet’s capability, providing you with the ability to slice and dice data, creat dynamic dropdown capability, split tasks.  See more about Extending Smartsheet’s Capabilities with AppSheet

For those Spreadsheet users that like to provide selected mobile access for reports and updates using spreadsheets to not only source but to capture data,  location, signatures,  scan bar codes,  even work offline,  welcome to AppSheet .  

AppSheet lets you build mobile apps that will make it easier to gather the data, communicate to the right people, and helps turn that data into information, because AppSheet can access your existing spreadsheets directly.  See AppSheet Video

Field Operations

Improve work and project documentation by capturing issues in real-time, increase collaboration with proactive communication among project teams, vendors, and clients, and save time with accurate resource management.

Quality Control

Reduce testing and inspection errors with collaborative solutions, accelerate close out time, and improve job satisfaction by maintaining transparency between client and site crews.

Safety

Increase documentation accuracy during inspections, maintain comprehensive logs without additional steps, and accelerate resolution by connecting the right people at the right time.

Contact Us to discuss your Smartsheet and AppSheet needs.  We’d love to hear from you!

The post Smartsheet for Construction appeared first on SmarterBusinessProcesses.