RBR Inventory Formatter is a web application developed to enhance efficiency at the circulation desk of Pollak Library. This tool processes .xls
files generated by the Alma library system by automatically removing unnecessary columns, adding custom ones (e.g., user initials, processing date), and formatting the data to be print-ready.
The app increased inventory processing speed by 200%, enabling staff to process six reading lists per hour instead of two. Built with modern technologies like Next.js, TypeScript, and TailwindCSS, the project showcases my ability to develop scalable, maintainable, and impactful tools for real-world use.
Features
- Automates
.xls
file processing by removing unnecessary columns. - Adds custom fields such as inventory dates and user initials.
- Outputs fully formatted
.xlsx
files ready for printing. - Customizable preferences saved locally for convenience.
- Supports light and dark themes for accessibility.
This application leverages ExcelJS to handle file processing, enabling seamless manipulation of .xls
files and generation of clean, formatted .xlsx
outputs. By utilizing Date-fns, the app efficiently manages and formats inventory timestamps. Additionally, FileSaver.js facilitates hassle-free downloads, ensuring that users can quickly obtain processed files ready for printing.