Work Payout Calculator
This app helps a user track work hours, mileage, and payouts for each day within a week.
The Problem
Managing work hours and mileage across multiple payers manually can be tedious and error-prone. Created a streamlined solution that simplifies the input, calculation, and management of work hours, mileage reimbursement, and payout splits between two distinct payers. Additionally, certain days needed special handling due to irregularities in time formats, dates, and payouts.
Minimum Requirements
- Clearly handle scenarios involving two separate payers, splitting costs equitably.
- Provide user-friendly interfaces for input correction, week selection, and printing reports.
- Store and save user settings, these settings are stored using browser cookies and persist between sessions.
Taking advantage of Google Cloud Vision
Users can upload an image of their hours sheet. The uploaded image is processed (converted to black & white) to enhance OCR accuracy. The image data is sent to Google Vision API for text extraction. Extracted text is parsed intelligently: It identifies weekdays, dates, times, and mileage. It accounts for common OCR errors, like incorrect dates or missing am/pm. Parsed data is automatically grouped into corresponding weeks. The app prompts the user to map parsed weeks to actual calendar weeks.