CK model for Rates DB Ocean (requirements)
From UG
(→Current Business Process) |
(→Examples) |
||
| Line 71: | Line 71: | ||
===FE-US spreadsheet=== | ===FE-US spreadsheet=== | ||
| - | '''Rate or Data tab - | + | '''Rate or Data tab - columns A - U''' |
[[File:FE - US Columns A - U.JPG]] | [[File:FE - US Columns A - U.JPG]] | ||
| - | '''Rate or Data tab - | + | '''Rate or Data tab - columns V - AG''' |
[[File:FE-US Columns V - AG.JPG]] | [[File:FE-US Columns V - AG.JPG]] | ||
| Line 82: | Line 82: | ||
| - | '''Surcharge Tab | + | '''Surcharge Tab columns A - R''' |
[[File:FE-US Surcharges column A - R.JPG]] | [[File:FE-US Surcharges column A - R.JPG]] | ||
| - | '''Surcharge Tab | + | '''Surcharge Tab columns S - AI''' |
[[File:FE-US Surcharges column S - AI.JPG]] | [[File:FE-US Surcharges column S - AI.JPG]] | ||
| - | '''Surcharge Tab | + | '''Surcharge Tab columns AJ - AR''' |
[[File:FE-US Surcharges column AJ-AR.JPG]] | [[File:FE-US Surcharges column AJ-AR.JPG]] | ||
| Line 110: | Line 110: | ||
===EU-FE spreadsheet=== | ===EU-FE spreadsheet=== | ||
| - | '''Rate or Data tab - | + | '''Rate or Data tab - columns A - P''' |
[[File:EU-FE Columns A-P updated.JPG]] | [[File:EU-FE Columns A-P updated.JPG]] | ||
| - | '''Rate or Data tab - | + | '''Rate or Data tab - columns P - V''' |
[[File:EU-FE - columns P - V.JPG]] | [[File:EU-FE - columns P - V.JPG]] | ||
| Line 126: | Line 126: | ||
===EU-US spreadsheet=== | ===EU-US spreadsheet=== | ||
| - | '''Rate or Data tab - | + | '''Rate or Data tab - columns A - Q''' |
[[File:EU - US Columns A-Q.JPG]] | [[File:EU - US Columns A-Q.JPG]] | ||
| - | '''Rate or Data tab - | + | '''Rate or Data tab - columns R - AH''' |
[[File:EU-US Columns R - AH.JPG]] | [[File:EU-US Columns R - AH.JPG]] | ||
| - | '''Rate or Data tab - | + | '''Rate or Data tab - columns AI - AX''' |
[[File:EU-US AI - AX.JPG]] | [[File:EU-US AI - AX.JPG]] | ||
| - | '''Rate or Data tab - | + | '''Rate or Data tab - columns AY - BK''' |
[[File:EU - US Columns AY - BK updated.JPG]] | [[File:EU - US Columns AY - BK updated.JPG]] | ||
| Line 146: | Line 146: | ||
===US-FE spreadsheet=== | ===US-FE spreadsheet=== | ||
| - | '''Rate or Data tab - | + | '''Rate or Data tab - columns A - R''' |
[[File:US - FE Columns A - R.JPG]] | [[File:US - FE Columns A - R.JPG]] | ||
| - | '''Rate or Data tab - | + | '''Rate or Data tab - columns S - AY''' |
[[File:US - FE Columns S - AY.JPG]] | [[File:US - FE Columns S - AY.JPG]] | ||
| - | '''Rate or Data tab - | + | '''Rate or Data tab - columns AZ - BQ''' |
[[File:US - FE Columns AZ - BQ.JPG]] | [[File:US - FE Columns AZ - BQ.JPG]] | ||
| - | '''Rate or Data tab - | + | '''Rate or Data tab - columns BR - CA''' |
[[File:US - FE Columns BR - CA.JPG]] | [[File:US - FE Columns BR - CA.JPG]] | ||
| Line 165: | Line 165: | ||
===US-EU spreadsheet=== | ===US-EU spreadsheet=== | ||
| - | '''Rate or Data tab - | + | '''Rate or Data tab - columns A - R''' |
[[File:US- EU Columns A - R.JPG]] | [[File:US- EU Columns A - R.JPG]] | ||
| - | '''Rate or Data tab - | + | '''Rate or Data tab - columns S - AJ''' |
[[File:US - EU Columns S - AJ.JPG]] | [[File:US - EU Columns S - AJ.JPG]] | ||
| - | '''Rate or Data tab - | + | '''Rate or Data tab - columns AK - BA''' |
[[File:US-EU Columns AK - BAa.JPG]] | [[File:US-EU Columns AK - BAa.JPG]] | ||
| - | '''Rate or Data tab - | + | '''Rate or Data tab - columns BA - BR''' |
[[File:US - EU Columns BA - BR.JPG]] | [[File:US - EU Columns BA - BR.JPG]] | ||
Revision as of 16:30, 29 July 2011
Contents |
Info
0002690: [Rates DB] ..... <project>
0003097: [Rates DB] Implement phase 3 (CK model for FCL)
Glossary
FE - Far East
EU - European Union
US - United States
TAWB - Trans Atlantic west bound
TAEB - Trans Atlantic east bound
TPWB - Trans Pacific west bound
TPEB - Trans Pacific east bound
TEU - Twenty-foot equivalent unit
FEU - Forty-foot equivalent unit
For additional definitions please see Rates_DB#Glossary
Summary
The requirements for ocean FCL will be the same as the requirements covered in both:
CK model for Rates DB Air (requirements)
AND
Unlike Air, which has only one spreadsheet shared between offices, Ocean FCL has several spreadsheets, in different formats.
Each spreadsheet will be uploaded into the project mantis 2690 and mantis 3097 Implement phase 3 (CK model for FCL)
Current Business Process
The current business process for ocean FCL is similar to that of Air ( CK model for Rates DB Air (requirements) ).
The difference for ocean is that the information that is shared, is on multiple spreadsheets.
These spreadsheet are all in different formats.
Each spreadsheet is being updated by difference offices.
- EU-FE is handled by the Europe offices.
- London and Paris
- EU-US is handled by the New York office
- Inside Sales Team
- FE-EU is handled by Europe offices
- FE-US is handled by the Hong Kong office
- US-EU is handled by the New York office
- US-FE is handled by the New York office
These spreadsheets are also being shared through dropbox and are still password protected.
Examples
Most of the spreadsheets are to large, to take only one screen shot. So most of these will have multiple images.
FE-US spreadsheet
Rate or Data tab - columns A - U
Rate or Data tab - columns V - AG
Pivot Table
Surcharge Tab columns A - R
Surcharge Tab columns S - AI
Surcharge Tab columns AJ - AR
FE-EU spreadsheet
Rate or Data tab - colums A - O
Rate or Data tab - colums P - V
Pivot Table
EU-FE spreadsheet
Rate or Data tab - columns A - P
Rate or Data tab - columns P - V
Pivot Table
EU-US spreadsheet
Rate or Data tab - columns A - Q
Rate or Data tab - columns R - AH
Rate or Data tab - columns AI - AX
Rate or Data tab - columns AY - BK
Pivot Table
US-FE spreadsheet
Rate or Data tab - columns A - R
Rate or Data tab - columns S - AY
Rate or Data tab - columns AZ - BQ
Rate or Data tab - columns BR - CA
Pivot Table
US-EU spreadsheet
Rate or Data tab - columns A - R
Rate or Data tab - columns S - AJ
Rate or Data tab - columns AK - BA
Rate or Data tab - columns BA - BR
Pivot Table
