I can do exactly what you need. I'm a computer science professional with extensive experience in QR codes generation and processing, automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, macros (VBA scripts), pivots, filters, and other advanced tools. I've done a lot of similar work. Please see reviews on my profile. It would be my pleasure to do your project.
Just FYI, I own a small business registered in the state of Illinois. I could bill you as an individual freelancer or as a business, whichever suits you better.
Please have a look at some Excel projects I've done:
https://www.freelancer.com/projects/Excel/Build-Excel-reports-dashboard/
https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/
https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/
https://www.freelancer.com/jobs/Excel-Mathematics/Convert-math-proofs-Excel-formulas/