Motor Pool Vehicle Maintenance System

Chris
Solutions
June 1, 2023

Table of Contents

Business Problem

The client faced constraints in a low-margin sector without budget for commercial fleet tracking software. As operations expanded, monitoring vehicle maintenance and licensing renewals became increasingly challenging. They needed:

A centralized system to gather service and mileage data from technicians and drivers
Automated email notifications for timely service completion
License renewal reminders

Mission

Leverage Google Sheets, Forms, and Gmail to enhance an existing Fleet Manager spreadsheet and form system. Upgrade the underlying code to eliminate bugs while implementing new reminder functionality for management oversight.

Solution

Rather than patching existing code, the team chose complete reconstruction:

Established a data model enabling object-oriented programming
Designed for future scalability and product evolution
Retained the client’s familiar Fleet Manager interface
Delivered reliable backend code updates
Implemented dependable service reminders

Timeline

Completion: One month

Tags :

Image Conversion Using API

Business Problem The client required converting over 1,000 images from PNG to TIFF format. A manual approach would demand substantial time and resources.

Project and Vendor Management Tracking

Business Challenge A startup company needed to manage a complex vendor ecosystem. The organization employed independent contractors on short-term projects, requiring tracking of hundreds of projects with thousands of contractors along with multiple Statements of Work and invoices per contractor. Commercial solutions exceeded their budget constraints.

Google Sheets Data Aggregation

Business Problem The client faced efficiency challenges stemming from significant waste related to employees manually updating Google Sheets that fed business critical decision making information. Operating with over 150 concurrent projects, each requiring its own spreadsheet, leadership lacked an automated method to consolidate data across this distributed portfolio.