Virginia Commonwealth University Automates Inventory for Enhanced Simulation Center Efficiency

Virginia Commonwealth University's simulation center faced significant challenges with manual inventory management, including incompatible barcode scanning and a heavy burden of daily data reconciliation. By integrating Sheetgo with their Google Workspace, the team implemented a fully automated system for equipment check-in/check-out, report generation, and data accuracy, leading to substantial time savings and improved operational efficiency across the department.

The simulation center at Virginia Commonwealth University was hampered by a labor-intensive, manual inventory management process. Their previous system, which relied on SmartSheets, proved inadequate due to an unsmoothed barcode scanning process and incompatibility with non-iOS devices, forcing staff to implement cumbersome workarounds. This critical lack of automation created a significant manual burden for daily data reconciliation, equipment check-in, and check-out procedures. Furthermore, the finance department struggled with commission reporting due to the manual nature of data entry. Cumulatively, these inefficiencies resulted in staff spending double the desired time on inventory tasks, negatively impacting the simulation center's overall operational effectiveness and resource allocation.

Sheetgo delivered a comprehensive automation solution that seamlessly integrated with Virginia Commonwealth University's existing Google Workspace. This enabled the simulation center to establish a streamlined, end-to-end process for inventory management, eliminating the need to toggle between disparate software platforms. Sheetgo's flexible automation layer allowed for the implementation of custom, user-friendly forms for data input, including an integrated barcode scanning function compatible with all devices, directly addressing previous compatibility issues. Data was automatically transferred between these input forms and central spreadsheets, automating equipment check-in/check-out procedures and generating necessary reports. This automated approach eradicated human errors, drastically improved data accuracy, and freed up considerable staff time previously spent on manual reconciliation. The customizability of the solution also extended to improving the finance department's commission reporting, ensuring greater efficiency and reliability.