RBR Inventory Formatter

Web Development

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.

Image 0
Image 1