adz235/day-sheet-processor

Day Sheet Processor & Categorizer

A fully client-side web app for processing container day sheets.

Features

• —📄 PDF Support — Parse IRS/BCP PDF status reports (green=AV, red=PB, blue=MD)
• —📊 Excel Support — Auto-detect DPW and JPC day sheets
• —🔍 CT Range Checker — Upload once in Settings, saved permanently in your browser
• —📋 Copy Numbers — One-click copy of filtered container numbers
• —📤 Export to Excel — Export sorted, categorised data

Grades

• —CT / CTRJT — Cold Treatment (auto-detected via Range Checker)
• —SMART — GPS-tracked containers (JPC, GPS=YES)
• —RF — Standard reefer (JPC, GPS=NO)
• —CAF / CA — From comments column
• —STD — Standard

Usage

1. 1.Open Settings (⚙️) and upload your CT Range Checker file once
2. 2.Drag & drop your day sheet (PDF or Excel) onto the main drop zone
3. 3.Filter, sort, and export