Weekly Hubo-Speedo Difference Tracker
Budget: $250 – $750 NZD
Every week I’ll email you a fresh CSV that contains Hubo and Speedo readings. Your job is to import that file, calculate the Hubo-Speedo variance for each record, and append the new data to a running spreadsheet that I can open in Excel or Google Sheets.
The workflow should be straightforward:
• Open the emailed CSV.
• Preserve the original columns exactly as provided.
• Add a calculated column showing the Hubo-Speedo difference.
• Save the updated master file and return it to me in XLSX format before the next batch arrives.
Accuracy is crucial, so please build in any simple validation checks you normally use when handling CSV-to-spreadsheet conversions. I’m happy to answer questions or adjust the layout if it makes the weekly update smoother.
The workflow should be straightforward:
• Open the emailed CSV.
• Preserve the original columns exactly as provided.
• Add a calculated column showing the Hubo-Speedo difference.
• Save the updated master file and return it to me in XLSX format before the next batch arrives.
Accuracy is crucial, so please build in any simple validation checks you normally use when handling CSV-to-spreadsheet conversions. I’m happy to answer questions or adjust the layout if it makes the weekly update smoother.
Related categories:
Visual Basic
Data Processing
Data Entry
Excel
Excel VBA
Excel Macros
Data Visualization
Data Analysis