Slideshow
Web App
Displaying lumber prices on a kiosk.
Software that takes a spreadsheet and turns it into a table that makes it into images.
Spreadsheet
Reading a spreadsheet programatically and dumping it into categories like Spruce, Pressure Treated and Plywood.
Development
Taking the spreadsheet data and automating them into tables by categories to be converted into slideshow images.
Display
Using an android device and a browser with kiosk capabilities. Setup the browser to auto start when the Kiosk is turned on.
About
Lumber prices fluctuate frequently, and the hardware store previously updated them manually in both the point-of-sale system and a spreadsheet, which was displayed on a customer-facing kiosk. This manual process often led to pricing errors. I developed a streamlined solution: pricing is now exported directly from the point-of-sale system, while a user-uploaded spreadsheet automatically updates the slideshow without manual input.
Features
- • Publicly displays up-to-date lumber prices for customers •
- • Effortlessly upload an auto-generated spreadsheet through a secure webpage form •
- • Version 2 supports file submissions via custom software integrated with the Google API •
- • Currently in use across two kiosks •
- • Includes software update capabilities with forced updates when necessary •