Upload Load Data
Upload your Excel load list to refresh the dashboard with current open loads.
Load list Excel file
The system will extract all open "ready" loads, group duplicates, calculate costs and recommendations, then save the updated data.
Drop your Excel file here
or click to browse Β· .xlsx, .xls supported
Processing...
Last upload summary
From data currently loaded in dashboard
Total open loads
β
Grouped lines
β
Loads with km data
β
Edit Distances
Override calculated km values with exact road distances. Saved values are used permanently β OSRM not called again for these routes.
Route distance overrides
Edit km values below. Orange = estimated, Green = confirmed.
| Route | km | Status | Own cost |
|---|
Fleet Rates
Set cost rates used in carry vs sell calculations. Changes apply immediately to dashboard recommendations.
Operating costs per km
These rates are multiplied by route distance to calculate own fleet carrying cost.
β¬/km
β¬/km
β¬
If carry vs sell profit difference is within this amount β "Too close to call"
%
Deducted from SPOT sell price to calculate net sell profit
VIP clients
These clients always prefer own/contracted fleet. One per line.
Decision Rules
Adjust the logic that drives carry vs sell recommendations and price alerts.
Price escalation triggers
When to suggest increasing expedition price for unsold loads.
%
%
%
β¬
Season pricing multiplier
Apply extra markup during end of month/quarter/year
Price decrease suggestion
Suggest -10% when load would sell easily (client price >90% of SPOT)
API Keys
Configure API keys for AI chat and routing. Keys are stored in your browser only β never sent to any server.
Anthropic API key
Required for the AI chatbot. Get yours at console.anthropic.com β API Keys β Create key.
How to get your API key (5 minutes):
- Go to console.anthropic.com and sign up / log in
- Click API Keys in the left menu
- Click Create Key β name it "UTL Dashboard"
- Copy the key (starts with
sk-ant-) and paste it above - Add a small amount of credit ($10 lasts weeks of daily use)
Google Maps API key (optional)
For exact truck road distances instead of estimates. Free tier: 40,000 requests/month.
About Platform
UTL Load Decision Center β version and system info.
Platform version
v3.0
Built for
United Transline UAB
Hosted on
Hostinger
Data storage
Browser localStorage (no server)
Distance engine
Pre-calculated + OSRM fallback
AI model
Claude claude-sonnet-4-6 via Anthropic API
Change password
Edit login.html line 1 β const PASSWORD = '...'
login.html