Integrations3 Live Northvale Alex Morgan
‹ GJ

Clearwater Juice 2

12 files · 34 runs
Mark outcome Start a proposal ⋮
Files12 12 of 12 selected
Add files
Proposals34⟲ All history
1730dc948af221h ago · 12 filesDone›
26387e052aaa813h ago · 2 filesawaiting_input›
⟲ History 34⤓ DownloadCarriersInsightsExplore⛶   ✕
Search proposals by name or id…
Select all
⟲ History 34⤓ DownloadCarriersInsightsExplore⛶   ✕
‹730dc948af22
✦ Proposal ▤ Run log
✓Set up✓Rate the lanes✓Price the bid4Review deliverableread it here, fix prices, check the totals5Deliver & share2 datasets
Rating plan
Review the agent's plan before rating
2 datasets
STRATEGY

Grouped the three 1544-row 'Data' sheets from the Bolingbrook and Canada files into a single dataset, rating only the latest version (20260410). The 523-row 'Data' sheet from the Midwest Vitalgreen file is treated as a separate dataset. Both datasets are routed to the API because they contain standard origin, destination, weight, and date columns. Excluded the 'Non Summit US data' and warehouse questionnaires as they contain aggregated annual data or non-shipment information.

Clearwater Juice Bolingbrook Data
version policy: latest
TMS API
Why this methodThe dataset contains standard shipment columns (origin and destination city, state, zip, weight, pallets, date) that map directly to the API.
GroupingThese sheets all contain 1544 rows with identical shipment columns (RefNo, SD, ShipCity, ConsCity, etc.). They are versions of the same dataset, so we use the latest file based on the date in the filename.
RATING SHEET(S)
Clearwater Juice 2/Clearwater Juice Bolingbrook Proposal 20260410.xlsx / Data
›FIELD MAPPING & SAMPLE

2/2 dataset(s) rated with valid data

Clearwater Juice Bolingbrook Data: All 2,224 lanes were successfully priced for a total cost of $1.28 million, averaging $574.37 per lane with costs ranging from $304.36 to $2,308.16. The transport mode for every lane is currently classified as 'Unknown'. Two significant anomalies require immediate attention: 19 extreme high-cost outliers were detected, and all 2,224 rows contain $0 or negative totals.; Midwest Vitalgreen Chicago RT: All 523 lanes were successfully priced, resulting in a total freight cost of $1.41 million and an average cost of $2,705 per lane. The freight mix is heavily dominated by Truckload (511 TL vs. 12 LTL), with individual lane costs ranging from $692.57 to $4,864.57. No pricing anomalies were detected in this batch.

Rated CSV
Clearwater Juice Bolingbrook Data · api · massrating 2224 priced · run 102843 Rated ⬇ TMS input
Midwest Vitalgreen Chicago RT · api · marketrating 523 priced · run 102844 Rated ⬇ TMS input
Customer deliverable
Rate tables + rated data → one workbook per dataset
Clearwater Juice Bolingbrook Data PALLET-BASED
LTLRates: 26 unique lane(s) probed on 'massrating' → $/pallet at 2/3/4/5/6/7/8/9; Rate Base = API distance, Minimum = min-break freight. Rules + Accessorials + LTLFSC/TLFSC from the standard Northvale tables.
Data · 2224 LTLRates · 26 LTLFSC · 60 TLFSC · 98 Rules · 13 Accessorials · 11
Download .xlsx (6) Share with client
TELL THE AGENT WHAT TO CHANGE
LTLRates e.g. "add a 10% markup" · "rebuild on a per-cwt basis" · "go back and mass-rate against ACME" Send
Edits target the selected sheet. Basis rebuilds & "go back to re-rate" apply to the whole dataset.
+ New sheet from a formula
Give an instruction and re-run this project — e.g. 'also add the Midwest lanes', 'drop rows missing weight', or 'rate the Vitalgreen sheet via the rate card instead'
Apply & re-run
Both summaries check out
Bolingbrook  2,224 × $574.37 = $1,277,399 ≈ $1.28M ✓
Vitalgreen           523 × $2,705   = $1,414,715 ≈ $1.41M ✓
freight mix  511 TL + 12 LTL = 523 = lane count ✓
The totals, the averages and the mode split all agree
Except these two, in one paragraph
SAYS
All 2,224 lanes were successfully priced for a total cost of $1.28 million … ranging from $304.36 to $2,308.16
ALSO SAYS
all 2,224 rows contain $0 or negative totals
a set totalling +$1.28M with a floor of $304.36
cannot also be entirely $0 or negative
One of the two is wrong — and a client would read both
Four of six sheets are the Reference page
LTLFSC  60  = Reference · Fuel surcharge, LTL
TLFSC   98  = Reference · Fuel surcharge, TL
Rules    13  = Reference · Rules
Accessorials 11 = Reference · Accessorials
─────────────────────────────
+ Data 2224 + LTLRates 26 = 6 sheets = Download .xlsx (6) ✓
"Stamped into every customer deliverable" — literally
KnowRFP · Project runs
One project
KnowRFP Agent
Proposal intelligence · Northvale
Live analysis
Lanes priced
0
Freight cost
0
Sheets shipped
0
Contradictions
0
Before this goes to a client
✓
Both datasets reconcile
2,224 × $574.37 and 523 × $2,705 land on the stated totals; 511 TL + 12 LTL = 523 exactly.
!
One paragraph contradicts itself
"$1.28 million, ranging from $304.36" and "all 2,224 rows contain $0 or negative totals".
!
The plan says 1,544 rows; the result says 2,224
It reports rating only the latest version — worth confirming which rows were priced.
✓
The shared tables really are stamped in
LTLFSC 60, TLFSC 98, Rules 13, Accessorials 11 — the Reference page, sheet for sheet.
KnowRFP Agent
Re-check the anomaly ruleDownload anyway
!
Two things to settle first
The $0-or-negative claim · 1,544 rows vs 2,224 lanes

12 files in.A priced workbook out.

Open one run and you get the agent's plan, why it grouped the sheets that way, what it priced, and the workbook it built — with your own rate tables already inside it.

Runs
34
Lanes priced
2,747
Sheets out
6

It shows its working,
then hands you the workbook.

Every run keeps the strategy, the grouping decision, the rated totals and the deliverable together — so you can check the reasoning before the client checks the price.

0:00
2:24 1x