Automated Fuel and Fluid Management

Project goal: To design, test and build an automated system to record fuel consumption at the sponsor’s Tucson Proving Ground, where equipment testing uses thousands of gallons of diesel per week. The system replaces the current manual method of data collection with a mobile application that uses a tablet to collect and store fueling data, which is then sent to a sponsor server. A fabricated bracket allows the Windows tablet to be transported safely during data acquisition, after which reports are merged and produced automatically, and checked for quality using a custom application developed using Python and Visual Basic for Applications. The script then produces a final report that goes to billing and a report that identifies quality issues.