new PDA - EDA 2.xlsx - Google Sheets

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AR	AS
1	Vessel Type			SDR Valuation
2				SDR Valuation	SC Net Tonnage																												PUT WEIGHT		TOTAL EGP		Total USD		SURCHARGE amount		Final total
3				0	First 5000				Next 5000				Next 10000				Next 20000				Next 30000				Next 50000				Rest				PUT WEIGHT		TOTAL EGP		Total USD		SURCHARGE amount		Final total
4	TYPE	Laden	Ballast	SURCHARGE	Laden		Ballast		Laden		Ballast		Laden		Ballast		Laden		Ballast		Laden		Ballast		Laden		Ballast		Laden		Ballast		Laden	Ballast	Laden	Ballast	Laden	Ballast	Laden	Ballast	TOTAL LADEN	TOTAL BALLAST	Container Ships Southbound Ships
5	Tankers of Crude Oil ballast		0	5%	11.04	0	9.40	0	7.82	0	6.64	0	5.91	0	5.04	0	2.93	0	2.50	0	2.53	0	2.14	0	2.17	0	1.85	0	2.13	0	1.82	0		0	0	0	0	0	0	0	0	0	No of Tiers on weather Deck	Levied Surcharge on Normal Tolls
6	Tankers of Crude Oil laden	0		15%	11.04	0	9.40	0	7.82	0	6.64	0	5.91	0	5.04	0	2.93	0	2.50	0	2.53	0	2.14	0	2.17	0	1.85	0	2.13	0	1.82	0	0		0	0	0	0	0	0	0	0	1	22%
7	Tankers of Petroleum Products laden	0		25%	11.04	0	9.40	0	7.82	0	6.64	0	5.91	0	5.04	0	3.93	0	2.50	0	3.84	0	2.14	0	3.46	0	1.85	0	3.34	0	1.82	0	0		0	0	0	0	0	0	0	0	2	26%
8	Tankers of Petroleum Products ballast		0	15%	11.04	0	9.40	0	7.82	0	6.64	0	5.91	0	5.04	0	3.93	0	2.50	0	3.84	0	2.14	0	3.46	0	1.85	0	3.34	0	1.82	0		0	0	0	0	0	0	0	0	0	3	30%
9	Dry Bulk Carriers	0	0	10%	10.13	0	8.62	0	7.74	0	6.58	0	6.12	0	5.21	0	2.24	0	1.89	0	1.97	0	1.68	0	1.85	0	1.58	0	1.77	0	1.50	0	0	0	0	0	0	0	0	0	0	0	4	38%
10	LPG Carriers	0	0	20%	11.60	0	9.87	0	8.40	0	7.14	0	6.22	0	5.29	0	5.05	0	4.30	0	4.42	0	3.76	0	4.13	0	3.51	0	4.13	0	3.51	0	0	0	0	0	0	0	0	0	0	0	5	45%
11	LNG Carriers	0	0	7%	10.42	0	8.87	0	8.11	0	6.89	0	7.02	0	5.97	0	5.43	0	4.61	0	5.03	0	4.27	0	4.8	0	4.08	0	4.67	0	3.97	0	0	0	0	0	0	0	0	0	0	0	6	49%
12	Chemical Carriers & Liquid Bulk	0	0	20%	11.55	0	9.81	0	8.92	0	7.58	0	7.12	0	6.06	0	5.19	0	4.42	0	4.63	0	3.94	0	4.35	0	3.70	0	4.27	0	3.63	0	0	0	0	0	0	0	0	0	0	0	7	51%
13	General Cargo Ships	0	0	14%	10.08	0	8.58	0	7.78	0	6.62	0	5.42	0	4.61	0	4.07	0	3.45	0	3.94	0	3.36	0	3.87	0	3.30	0	3.80	0	3.22	0	0	0	0	0	0	0	0	0	0	0	8	53%
14	Ro/Ro Ships	0	0	14%	10.08	0	8.58	0	7.50	0	6.37	0	5.83	0	4.97	0	4.21	0	3.59	0	3.94	0	3.36	0	3.8	0	3.22	0	3.65	0	3.12	0	0	0	0	0	0	0	0	0	0	0	9	55%
15	Vehicle Carriers NB	0	0	14%	11.04	0	9.4	0	7.58	0	6.45	0	5.67	0	4.83	0	4.05	0	3.45	0	3.82	0	3.25	0	3.01	0	2.56	0	2.88	0	2.44	0	0	0	0	0	0	0	0	0	0	0	10	57%
16	Vehicle Carriers SB	0	0	7%	11.04	0	9.4	0	7.58	0	6.45	0	5.67	0	4.83	0	4.05	0	3.45	0	3.82	0	3.25	0	3.01	0	2.56	0	2.88	0	2.44	0	0	0	0	0	0	0	0	0	0	0	11	59%
17	Passenger Ships	0	0	10%	9.97	0	8.48	0	7.00	0	5.96	0	5.77	0	4.91	0	4.08	0	3.48	0	4.03	0	3.42	0	3.9	0	3.31	0	3.76	0	3.19	0	0	0	0	0	0	0	0	0	0	0	Add 2% to be applied on each extra Container over over The Eleventh
18	Special Floating Units		0	14%	11.98	0	0	0	7.94	0	0	0	7.14	0	0	0	5.06	0	0	0	4.76	0	0	0	4.31	0	0	0	4.16	0	0	0	0	0	0	0	0.00	0	0	0	0.00	0
19	Other Vessels	0	0	14%	10.54	0	8.96	0	7.10	0	6.04	0	5.97	0	5.08	0	4.35	0	3.70	0	4.21	0	3.59	0	3.94	0	3.36	0	3.8	0	3.22	0	0	0	0	0	0	0	0	0	0	0
20	Container Ships SB	0	0	11	11.04	0	9.4	0	7.58	0	6.45	0	5.89	0	5.00	0	4.13	0	3.51	0	3.82	0	3.25	0	3.01	0	2.56	0	2.94	0	2.52	0	0	0	0	0	0	0	0	0	0	0
21	Container Ships NB	0	0	15	11.04	0	9.4	0	7.58	0	6.45	0	5.89	0	5.00	0	4.13	0	3.51	0	3.82	0	3.25	0	3.01	0	2.56	0	2.94	0	2.52	0	0	0	0	0	0	0	0	0	0	0
22	TOTAL																																				0	0	0	0		0
23																																											Container Ships Northbound Ships
24																																											No of Tiers on weather Deck	Levied Surcharge on Normal Tolls
25																																											1	25%
26																																											2	34%
27																																											3	42%
28																																											4	60%
29																																											5	68%
30																																											6	76%
31																																											7	83%
32																																											8	89%
33																																											9	94%
34																																											10	98%
35																																											11	101%
36																																											Add 2% to be applied on each extra Container er over The Eleventh
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100