UPLOADS
SETTINGS
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
—
🚛 Planning file — truck positions
Upload your Planningas Excel to update truck positions in the Trucks tab immediately
📋
Drop your planning Excel here
or click to browse · Planningas .xlsx file
Data Backup & Restore
Your data lives in the browser. Back it up regularly so you never lose bids, load history or user accounts.
⚠️
Last backup: Never
Back up regularly. Data is lost if browser storage is cleared or you switch computers.
📥 Export all data
Downloads a single JSON file with all your data
📤 Restore from backup
Restores data from a previously downloaded backup file
📂
Drop backup JSON here
or click to browse · .json files only
First time setup?
If you had data in localStorage before installing the database backend, migrate it to the server now:
Storage overview
KeyDescriptionSizeRecordsAction
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):
  1. Go to console.anthropic.com and sign up / log in
  2. Click API Keys in the left menu
  3. Click Create Key → name it "UTL Dashboard"
  4. Copy the key (starts with sk-ant-) and paste it above
  5. Add a small amount of credit ($10 lasts weeks of daily use)
📧 Email inbox credentials
For reading load offers from info@transdirekta.lt. Stored securely in the database — never lost when files are updated.
After saving, go to email_runner.html to fetch and parse load offers.
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