Actual Workflow

From carrier source files to a ready-to-use Dynamic Ratesheet

This page shows the complete process using actual files. Rate Forge accepts different carrier Excel layouts, processes them according to established contract rules, and produces one consistent rate sheet for searching and comparison.

Input

Prepare the original carrier files

Source files do not need to follow the same layout. The two Excel files below use different columns, worksheets, colors, and rate structures. Rate Forge processes each file according to its established contract rules.

Original Hapag-Lloyd rate file with POL, POD, ramp, and container-size rate columns — **Source file 1** WCM_S26NEA117_TPEB A-N FAK Guideline - Update #20-2026 Jul 1st to Jul 14th.xlsx

Original Worldlog LLC rate file organized by region, destination, and container size — **Source file 2** Worldlog LLC 26-1410TPC Appx (Rates) amn6.xlsx

Upload

Upload the source files to Rate Forge

Select one or more contract files. Rate Forge shows the original file names and sizes before processing. Confirm the pricing date, then start the conversion. Original file names must be retained because they help identify the contract type.

Two source files selected in Rate Forge with the pricing date ready for conversion — **Upload confirmation** Two source contracts are selected and the pricing date is set to July 10, 2026. The blue button starts the conversion.

Complete

Wait for completion and download the result

When processing is finished, the green status shows that the job is completed and the generated files become available for download. In this example, Rate Forge produced and downloaded the WCM Dynamic Ratesheet.

Rate Forge showing a completed conversion and the WCM Dynamic Ratesheet download — **Completed and downloaded** Output file: WCM Dynamic Ratesheet (SC 26-27) ver.260710.xlsx

Output

Open the generated Dynamic Ratesheet

The output consolidates different source contracts into one consistent rate-search format. Users can select the origin, pricing date, and other criteria to review currently applicable rates from different carriers.

Dynamic Ratesheet search screen showing destination and carrier rates by origin and date — **Final output format** One rate sheet can show multiple carriers, destinations, and container sizes for comparison. Click the image to enlarge it.

What this workflow means

Users do not need to manually rearrange each carrier's spreadsheet. Rate Forge applies established contract rules to standardize the data, calculate applicable rates, and produce the final rate sheet. New or unsupported layouts and missing reference data are still routed for manual review.

Open Rate Forge