Daily Truck Operations

Import the daily truck count, count each reference number as one truck, and review volume by dock section, hour, and area.

No report loaded
Made by James Hinna Keep moving forward

Ready for today

Attach a CSV, TSV, XLSX, or XLS truck report to build the daily operational view.

Made by James Hinna Keep moving forward
These charts answer the daily questions: how many trucks hit each hour, which hours need the most attention, and which dock types are driving the work.

Hourly Truck Flow

Total trucks each hour

Dock Type Volume

Total trucks by dock type

Busiest Hours Ranked

Top workload hours

Hourly Workload by Dock Type

Stacked bars show what made each hour busy
Made by James Hinna Keep moving forward

PO Lookup

DDP / EXW
Enter a PO number and the report will automatically find its DDP or EXW status.

Result

No PO searched
--
Import the report, enter a PO number, then look up whether it is DDP or EXW.
DDP / EXW Trucks
No rows loaded
Made by James Hinna Keep moving forward

Truck Finder

Breakdown / Roll Off
Enter a PO number. The report finds that truck, checks the supplier/vendor history, and shows the final Breakdown Truck or Roll Off answer. Trucks that need review go to the Audit tab.

Result

No PO searched
--
Import a truck report, enter a PO number, and this will show Breakdown Truck or Roll Off after audit decisions are handled.
Final Truck Lookup List
No rows loaded
Made by James Hinna Keep moving forward
Roll Off Audit
No trucks waiting for audit
These trucks need a manual call. Pick Roll Off or Breakdown, then the truck leaves this tab and becomes a final answer in Truck Finder.
Made by James Hinna Keep moving forward

Clerk Door

Tall / Regular Door
Enter a PO number. The report finds the supplier/vendor and checks whether that supplier used tall doors 68% or more of the time.

Result

No PO searched
--
Import a truck report, enter a PO number, and this will show Tall Door or Regular Door.
Door Recommendation List
No rows loaded
Made by James Hinna Keep moving forward

Door Suggestor

Historical Door Range
Enter a PO number. This finds the supplier/vendor and recommends the door range that supplier most often used in the historical report.
Live Google dock status: not loaded yet.

Result

No PO searched
--
Import a truck report, enter a PO number, and this will recommend a door range.
Daily Door Suggestions
No rows loaded
Made by James Hinna Keep moving forward

Breakdowns Audit

OPS vs DMS
Attach the OPS report and the DMS report. OPS proves the breakdown was billed when Bill To is ALDIOKS. DMS proves the lead entered it when the comment has a code like 5C or 5 C.

Audit Status

Waiting on reports
OPS Breakdown Rows
0
Breakdowns found in OPS.
DMS Breakdown Comments
0
Rows with number + C.
Missing DMS Comments
0
OPS breakdowns not entered in DMS comments.
Billing Issues
0
DMS breakdowns missing ALDIOKS billing or a billed *.
Lead Miss Rate
0%
Goal: under 10% each week.
Clerk PO Error Rate
0%
OPS PO typo checks.
Breakdowns Missing from DMS Comments
Attach both reports to audit
Lead Errors: Known Breakdown Trucks Missing DMS Comments
Attach DMS report to audit
Clerk Entry Errors: OPS PO Looks Slightly Off
Attach OPS and DMS reports to audit
Breakdown Billing Issues
Attach DMS report to audit
Made by James Hinna Keep moving forward

Truck Charge Audit

DMS pallets vs OPS charge
Attach the OPS report and the ranged DMS truck report. This checks FSPAY lumper fees against the DMS pallet count, floor loads, slip sheets, and missed C&C billing.

What It Checks

Waiting on reports
Charges Checked
0
Arrived DMS trucks reviewed.
Charge Issues
0
FSPAY fee needs review.
Missed C&C Billing
0
C&C trucks missing ALDICCP invoice.
FSPAY Lumper Fee Checks
Attach OPS and ranged reports to validate
Missed C&C Billing
Attach OPS and ranged reports to validate
Uncle Ray's Charge Check
OPS must have floor load to DAVIS + 72 intrn brk to OKS
Trucks Found 0
Attach OPS and ranged reports to check Uncle Ray's charges
Banana Charge Check
OPS must show a banana charge to ALDIOKS every day — not on DMS
Found in OPS 0
Attach OPS report to check for banana charges
Recycle Charge Check
OPS must show a recycle charge to ALDIOKS every day — not on DMS
Found in OPS 0
Attach OPS report to check for recycle charges
Made by James Hinna Keep moving forward
Saved Reports
Select the History tab to load
Audit Decision Log
All Roll Off and Breakdown decisions
Step-By-Step Guide

How To Use Daily Truck Operations

Read this top to bottom at least once. Everything you need to know about using this app is on this page.

The Three Most Important Things

If you only remember three things from this whole page, remember these.

1

Upload The File

Click the orange button in the top right corner. Pick your .csv file. Done.

2

Look Up Trucks

Go to Truck Finder. Type a PO number. The app tells you Roll Off or Breakdown.

3

Mark Your Answer

If it says Needs Review, go to Roll Off Audit and click Roll Off or Breakdown Truck.

1

Find Your File On The Computer

Before you can use this app, you need a file. The file has all the truck information in it. It is saved on the computer or a shared folder. The file ends in .csv or .xlsx. Those are just file types like how a photo ends in .jpg.

The file name usually has the date in it. Example: TruckCount_05162026.csv - look for today's date to find the right one.
Do NOT upload a file from last week. Always get today's file. Ask your manager where it is saved if you cannot find it.
.CSV TODAY'S FILE Your Computer Find the file here
2

Click The Orange Upload Button

Look at the very top right of the screen. You will see an orange button. Click it ONE time. A window will pop up asking you to pick a file. Find your file and double-click it. The app will load it automatically.

If the window closes but nothing changed, try clicking the button again. Sometimes the computer takes a few seconds to respond.
After it loads, the big numbers on the screen will change. If the numbers changed, it worked!
Daily Truck Operations Upload Schedule CLICK THIS BUTTON It is orange. Top right corner. Open File TruckCount.csv Open
3

Read The Big Numbers On Overview

After uploading, you will see four boxes with big numbers. These boxes are at the top of the Overview page. Each box tells you something different: how many trucks came in, what hour was busiest, what type of truck was most common, and how many types there were. You do NOT need to type anything - they update by themselves.

If all the numbers still say 0, the file did not upload correctly. Try uploading again. Make sure you picked the right file.
TRUCK COUNT 84 trucks today BUSIEST HOUR 6 6am had most BUSIEST TYPE DRY most common TYPES FOUND 5 truck groups These update automatically! If all numbers are 0, try uploading again.
4

Look Up A Truck Using Its PO Number

Click the menu button at the top left. Go to Lead Tools, then click Truck Finder. You will see a box where you can type. Type the PO number exactly as it looks on your paperwork. Then press the Enter key on your keyboard or click the Search button. The app will look it up and tell you the answer.

A PO number is usually 7 digits. Example: 1234567. Do not add spaces or dashes. Just type the numbers.
The answer will say Roll Off, Breakdown Truck, or Needs Review. If it says Needs Review, go to Step 5.
TRUCK FINDER 1234567 Search RESULT FOR PO 1234567 ROLL OFF Supplier: ABC Lumper Co Door 42 | Arrived: Yes No invoice needed. Truck rolled off. The answer shows up right here.
5

Mark Roll Off Or Breakdown When It Says Needs Review

When Truck Finder says "Needs Review", you need to make a decision. Go to Lead Tools, then Roll Off Audit. You will see a list of trucks waiting for your answer. Each truck has two choices. Click the circle next to the right answer. It saves by itself. You do not press any Save button.

Not sure which to pick? Ask your supervisor first. And if you click the wrong one by accident - that is okay, it happens all the time. You can go right back and change it. No drama.
ROLL OFF AUDIT - These trucks need a decision PO: 1234567 - ABC Lumper Co - Door 42 This truck needs YOUR decision Roll Off No invoice needed Click this circle Breakdown Invoice needed Or this circle Click ONE circle. It saves right away.
6

See What You Already Did In History

All your decisions save automatically. To see them, click the menu button, go to Database, then click History. Click the Refresh button on that page. You will see two tables: one for every file you uploaded, and one for every Roll Off and Breakdown decision you ever made. This stays saved even after you close the browser.

To reload an old report, find it in the list and click the Load button. Everything comes back just like it was.
HISTORY - All saved reports and decisions DATE FILE NAME ROWS LOAD May 16 TruckCount_05162026.csv 312 Load May 15 TruckCount_05152026.csv 287 Load AUDIT DECISION LOG May 16 9:12am PO: 1234567 ABC Lumper Roll Off May 16 9:08am PO: 9876543 XYZ Services Breakdown Everything here saves automatically.

Quick Cheat Sheet

Print this out and tape it to your desk so you always have it handy.

Roll Off = NO Invoice

The truck came but the lumper service did NOT unload it. No money is owed. Pick this when the truck just left without being worked.

Breakdown Truck = YES Invoice

The lumper service DID unload the truck. Money is owed. An invoice should be sent. Pick this when the truck was actually unloaded.

Driver Unload (DU) = NO Invoice

The truck driver did the unloading themselves. No lumper service involved. No invoice. The app skips these automatically - you do nothing.

Needs Review = ASK Someone

The app is also uncertain, and that is okay - uncertainty is part of the process. A real person (you!) gets to look and decide. Your supervisor is here as a support resource. You do not have to figure it out alone.

Words And What They Mean

This app uses some words that may feel unfamiliar. Here is a plain-English breakdown of what each word means.

PO Number

PO stands for Purchase Order. It is a unique ID for one truck delivery. Every truck has one. It usually looks like a 7-digit number: 1234567. You use it to search for a specific truck.

Roll Off

The truck left the dock without being unloaded by the lumper service. No invoice. This is the most common outcome. Nothing was billed.

Breakdown Truck

The lumper service did unload this truck. An invoice should be sent because they did work and need to get paid.

Driver Unload (DU)

The truck driver unloaded their own truck. The lumper service did not do anything. No invoice. The app detects this automatically.

Needs Review

The app could not figure out if it is Roll Off or Breakdown on its own. A person needs to look and make the call. Go to Roll Off Audit.

OPS Report

A report from the billing system. It shows what invoices were submitted. You attach this file in the Breakdowns Audit section.

DMS Report

A report from the warehouse system. It shows what the lead wrote in the system. Also used in Breakdowns Audit to double-check entries.

Dock Section

The area of the warehouse where trucks unload. Different sections handle different products. Examples: Dry, Freezer, Egg.

Supplier or Vendor

The company that sent the truck or provided the lumper service. The app uses this to match trucks to billing records.

Overview Tab

The first page you see after uploading. It has the four big number boxes showing truck count, busiest hour, busiest type, and total groups.

Truck Finder

A search tool in the Lead Tools menu. You type a PO number and it tells you if that truck is Roll Off, Breakdown, or Needs Review.

History

A log of everything that was saved. Shows all past reports uploaded and every Roll Off or Breakdown decision ever made. Found in Database menu.

A Important Notes

A few things to know before you get started.

Always use today's file. If you uploaded the wrong file, click Clear Report and upload the correct one.

Wait for the file to finish loading. Wait until you see "Report loaded" before doing anything else. If the browser closed, just reopen it and try again.

Not sure if it's Roll Off or Breakdown? Ask your supervisor. You can change your answer any time by going back to Roll Off Audit and clicking the correct circle.

The app only accepts .csv and .xlsx files. If your file won't upload, ask your manager for the correct file format.

Frequently Asked Questions

Common problems and how to fix them.

The page is completely blank or white. What do I do?

The page is Press Ctrl + Shift + R to force-reload the page. If it is still blank, close the tab, open a new one, and go to http://localhost:8000.

I clicked the orange button but nothing happened.

Wait 3 seconds and try clicking again. Sometimes the file picker window is slow to open. If a window appeared but you closed it without picking a file, click the button again and this time pick your file before closing the window.

I cannot find the file on my computer. Where is it?

Ask your manager. The file is usually saved in a shared folder or sent by email every morning. The file name will have today's date in it. Look for files ending in .csv or .xlsx.

What is a PO number and where do I find it?

A PO number is a unique ID number for one truck. It is on your paperwork or shown in the truck list on screen. It usually looks like 7 digits: 1234567. If you are not sure which number it is, ask your supervisor to point to it on the paperwork.

The app says the page is not responding. What do I do?

The app is Wait 30 seconds without clicking. If it is still unresponsive, press Ctrl + Shift + R to reload. Your saved decisions will still be there.

I clicked the wrong answer. How do I fix it?

Go back to Roll Off Audit, find the truck, and click the correct circle. It updates immediately. You can change it as many times as you need.

I don't know if this truck is Roll Off or Breakdown.

Ask your supervisor. That is the right call when you are not sure. They will tell you which one to pick.

Do I need to look up every single truck in Truck Finder?

No. You only need to handle the trucks under Roll Off Audit that are waiting for a decision. Trucks that already show Roll Off or Breakdown in Truck Finder are already done. You do not touch those.

After uploading, all the numbers still say zero. Why?

The app could not read your file. Either you picked the wrong file or the file is empty. Try uploading again. If it keeps showing zeros, ask your manager to open the file in Excel and check that it actually has data in it.

The file upload failed and nothing loaded. What happened?

The most common reasons: the file is still open in Excel (close Excel first), the file is not .csv or .xlsx, or the computer ran out of memory. Close other programs and try again. If it still fails, restart the computer.

I see DU or Driver Unload on a truck. What do I do?

Nothing. You do not have to do anything. The app automatically skips Driver Unload trucks. They will not show up in Roll Off Audit. They do not need an invoice so there is nothing for you to decide.

Truck Finder says No truck found. Why?

Either you typed the PO number wrong or that truck is not in today's report. Check that you did not add spaces or extra characters. Make sure you uploaded today's file first. If the PO is still missing, tell your supervisor right away.

Can two people use this at the same time?

Absolutely - and it is It can cause conflicts. Coordinate with your team so only one person uploads at a time.

History says no saved reports. Why?

The server might not be running. Look for the black command window that says "Uvicorn running on port 8000." If that window is closed the database is off. Ask your manager to run start.bat to restart it. Then click Refresh on the History page.

My manager wants to see the decisions I made. What do I show them?

Click the menu button. Go to Database then History. Click Refresh. Scroll down to the bottom table called Audit Decision Log. That table shows every Roll Off and Breakdown decision with the time and date it was made.

The page keeps asking me to reload. Should I?

Yes, go ahead. Press Ctrl + Shift + R. Your saved decisions in the database are completely safe - reloading the page cannot delete them. You will need to upload your file again, but everything you already decided is still there. No data was lost. You are good.

How do I open this app again tomorrow?

Ask your manager to run the start.bat file in the Billing audit folder. That starts the server. Then open your browser and go to http://localhost:8000. Do this every day when you start work. All your previous decisions are still saved.

What does the colored bar next to each dock section mean?

The bar shows how busy that section was compared to the others. A full bar means most trucks went there. A short bar means fewer trucks. The number next to the bar is the exact truck count - that is the important number.

Why are there so many trucks on the screen? Do I have to deal with all of them?

No. The Overview and Data tabs just show you information. You only need to act on trucks in the Roll Off Audit tab that say they need a decision. Ignore everything else unless your supervisor tells you otherwise.

How do I know if I did everything right for the day?

First - the fact that you are asking this question means you already care, and that matters. Go to Roll Off Audit. If the list is empty, that is a beautiful thing - it means you showed up and got it done. Check History to see your decisions reflected back to you. That log is a record of your contributions.

Still Stuck? Do These Steps

If something is not working, go through these steps in order.

Step 1: Read this page again from the top. The answer is probably here.

Step 2: Try the action again. A second attempt often works.

Step 3: Press Ctrl + Shift + R to reload the page. Your saved decisions will not be lost.

Step 4: Ask your supervisor. Show them this page and describe what happened.

You are doing fine. These things happen and there is always a fix.

The Two Most Important Steps

If you forget everything else on this page, remember these two things: Step 2 is Upload The File (orange button, top right) and Step 5 is Mark Roll Off or Breakdown (Roll Off Audit tab). Those two steps are the whole job. Everything else is just extra detail.

If you made a mistake, just go back and fix it. Everything in this app can be changed.

In Other News
Press Refresh to load headlines, election news, and polls.
CNN Latest
Top stories from CNN.
Fox News Latest
Top stories from Fox News.
Latest Election News
Politics and election headlines from CNN and Fox News.
RealClearPolling Latest Polls
Pick a race to chart the available polling average from the latest RealClearPolling rows.
Refresh to load polling data.
Polling Average Chart
Every Latest Poll
Refresh to load all races.
Date Race Poll Results Spread
Step 1 of 3