CK model for Rates DB Ocean (requirements)
From UG
| Line 73: | Line 73: | ||
===FE-EU spreadsheet=== | ===FE-EU spreadsheet=== | ||
| - | File:FE-EU columns A - O.JPG | + | [[File:FE-EU columns A - O.JPG]] |
| - | File:FE - EU Columns P - V.JPG | + | [[File:FE - EU Columns P - V.JPG]] |
| - | File:FE-EU Pivot table.JPG | + | [[File:FE-EU Pivot table.JPG]] |
===EU-FE spreadsheet=== | ===EU-FE spreadsheet=== | ||
| - | File:EU-FE Columns A-P.JPG | + | [[File:EU-FE Columns A-P.JPG]] |
| - | File:EU-FE - columns P - V.JPG | + | [[File:EU-FE - columns P - V.JPG]] |
| - | File:EU-FE Pivot Table.JPG | + | [[File:EU-FE Pivot Table.JPG]] |
===EU-US spreadsheet=== | ===EU-US spreadsheet=== | ||
| - | File:EU - US Columns A-Q.JPG | + | [[File:EU - US Columns A-Q.JPG]] |
| - | File:EU-US Columns R - AH.JPG | + | [[File:EU-US Columns R - AH.JPG]] |
| - | File:EU-US AI - AX.JPG | + | [[File:EU-US AI - AX.JPG]] |
| - | File:EU - US Columns AY - BK.JPG | + | [[File:EU - US Columns AY - BK.JPG]] |
| - | File:EU-US Pivot Table.JPG | + | [[File:EU-US Pivot Table.JPG]] |
===US-FE spreadsheet=== | ===US-FE spreadsheet=== | ||
| - | File:US - FE Columns A - R.JPG | + | [[File:US - FE Columns A - R.JPG]] |
| - | File:US - FE Columns S - AY.JPG | + | [[File:US - FE Columns S - AY.JPG]] |
| - | File:US - FE Columns AZ - BQ.JPG | + | [[File:US - FE Columns AZ - BQ.JPG]] |
| - | File:US - FE Columns BR - CA.JPG | + | [[File:US - FE Columns BR - CA.JPG]] |
| - | File:US-FE Pivot table.JPG | + | [[File:US-FE Pivot table.JPG]] |
===US-EU spreadsheet=== | ===US-EU spreadsheet=== | ||
Revision as of 19:40, 27 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
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 - colums A - U
Rate or Data tab - colums V - AG
Pivot Table
Surcharge Tab column A - R
Surcharge Tab column S - AI
Surcharge Tab column AJ - AR
FE-EU spreadsheet
EU-FE spreadsheet
EU-US spreadsheet
US-FE spreadsheet
US-EU spreadsheet
File:US- EU Columns A - R.JPG File:US - EU Columns S - AJ.JPG File:US-EU Columns AK - BAa.JPG File:US - EU Columns BA - BR.JPG File:US-EU Pivot table.JPG
