Spreadsheet: 546444d1510057108-need-help-on-formula-weekly-numbers
Sheet: Data

Service | Week selection | Projection |  |  | Deepsea |  |  |  |  |  |  | Departure(Rotation)
 | based departure pk | WK | Vessel | Allocation | Utlztn(TEU) | Utlztn(TON) | PK budget | Perf% | Total Teus | all | Total Tons | AE | PK
A001 |  | 36 | A001A | 437 |  |  |  |  |  | 5099 | 5109 | 60 | 142
 |  | 37 | A001B | 638 |  |  |  |  |  |  | 7800 | 64.25 | 338.25
Europe Only |  | 38 | [NAME] | 542 |  |  |  |  |  |  | 6619 | 2.25 | 293
 |  | 39 | A001D | 414 |  |  |  |  |  |  | 6619 |  | 251
 |  | 40 | A001E | 614 |  |  |  |  |  |  | 6619 | 260 | 286
 |  | 41 | A001F | 614 |  |  |  |  |  | 4224 | 6619 | 24 | 242
 |  | 42 | A001G | 614 |  |  |  |  |  |  | 6619 | 29 | 280
 |  | 43 | A001H | 585 |  |  |  |  |  |  | 6619 | 32 | 309
 | Last Week | 44 | A001I | 601 |  |  |  |  |  |  | 6619 | 3.25 | 399
 | Current week | 45 | A001J | 631 |  |  | 342 |  |  |  | 6619 |  | 320
 | Next week | 46 | A001K | 601 |  |  | 342 |  |  |  | 6619 |  | 300
 |  | 47 | A001L | 601 |  |  | 342 |  |  |  | 6619 |  | 300
 |  | 48 | A001M | 601 |  |  | 342 |  |  |  | 6619 |  | 300
 |  | 49 | A001N | 601 |  |  | 342 |  |  |  | 6619 |  | 300
 |  | 50 | A001O | 601 |  |  | 342 |  |  |  | 6619 |  | 300
 |  | 51 | A001P | 601 |  |  | 342 |  |  |  | 6619 |  | 300
 |  | 52 | A001Q | 601 |  |  | 342 |  |  |  | 6619 |  | 300
B001 |  | 36 | B001A | 65 |  |  | 135 |  |  |  | 451 |  | 61
 |  | 37 | B001B | 135 |  |  | 135 |  |  |  |  |  | 73.25
 |  | 38 | B001C | 135 |  |  | 135 |  |  | 1843 |  |  | 156
Europe Only |  | 39 | B001D | 135 |  |  | 135 |  |  | 920 |  |  | 106
 |  | 40 | B001E | 140 |  |  | 140 |  |  |  |  |  | 138
 |  | 41 | B001F | 140 |  |  | 140 |  |  |  |  |  | 95
 |  | 42 | B001G | 140 |  |  | 140 |  |  |  |  |  | 129
 |  | 43 | B001H | 161 |  |  | 140 |  |  |  |  |  | 118
 | Last Week | 44 | B001I | 175 |  |  | 140 |  |  |  |  |  | 65
 | Current week | 45 | B001J | 175 |  |  | 140 |  |  |  |  |  | 120
 | Next week | 46 | B001K | 175 |  |  | 140 |  |  |  |  |  | 150
 |  | 47 | B001L | 175 |  |  | 140 |  |  |  |  |  | 120
 |  | 48 | B001M | 175 |  |  | 140 |  |  |  |  |  | 120
 |  | 49 | B001N | 175 |  |  | 140 |  |  |  |  |  | 120
 |  | 50 | B001O | 175 |  |  | 140 |  |  |  |  |  | 120
 |  | 51 | B001P | 175 |  |  | 140 |  |  |  |  |  | 120
 |  | 52 | B001Q | 175 |  |  | 140 |  |  |  |  |  | 120
C001 |  | 36 | C001A | 334 |  |  |  |  |  |  |  |  | 152
 |  | 37 | C001B | 334 |  |  |  |  |  |  |  |  | 247
US Only |  | 38 | C001C | 364 |  |  |  |  |  |  |  |  | 277
 |  | 39 | C001D | 308 |  |  |  |  |  |  |  |  | 246
 |  | 40 | C001E | 308 |  |  |  |  |  |  |  |  | 282
 |  | 41 | C001F | 364 |  |  |  |  |  |  |  |  | 316
 |  | 42 | C001G | 364 |  |  |  |  |  |  |  |  | 316
 |  | 43 | C001H | 364 |  |  |  |  |  |  |  |  | 316
 | Last Week | 44 | C001I | 364 |  |  |  |  |  |  |  |  | 316
 | Current week | 45 | C001J | 364 |  |  |  |  |  |  |  |  | 316
 | Next week | 46 | C001K | 364 |  |  |  |  |  |  |  |  | 316
 |  | 47 | C001L | 364 |  |  |  |  |  |  |  |  | 316
 |  | 48 | C001M | 308 |  |  | 308 |  |  |  |  |  | 233
 |  | 49 | C001N | 308 |  |  |  |  |  |  |  |  | 233
 |  | 50 | C001O | 364 |  |  |  |  |  |  |  |  | 208
 |  | 51 | C001P | 364 |  |  |  |  |  |  |  |  | 316
 |  | 52 | C001Q | 364 |  |  |  |  |  |  |  |  | 275
D001 |  | 36 | D001A | 526 |  |  |  |  |  |  |  | 0 | 66
Med- Only |  | 37 | D001B | 520 |  |  |  |  |  |  |  | 21 | 105
 |  | 38 | D001C | 506 |  |  |  |  |  |  |  | 18 | 138
 |  | 39 | D001D | 506 |  |  |  |  |  |  |  | 31 | 145
 |  | 40 | D001E | 712 |  |  |  |  |  |  |  |  | 146
 |  | 41 | D001F | 712 |  |  | 318 |  |  |  |  | 9 | 105
 |  | 42 | D001G | 712 |  |  |  |  |  |  |  | 3 | 189.25
 |  | 43 | D001H | 712 |  |  |  |  |  |  |  | 2 | 165
 | Last Week | 44 | D001I | 756 |  |  |  |  |  |  |  | 15
 | Current week | 45 | D001J | 756 |  |  |  |  |  |  |  | 2
 | Next week | 46 | D001K | 756 |  |  |  |  |  |  |  |  | 230
 |  | 47 | D001L | 756 |  |  |  |  |  |  |  |  | 230
 |  | 48 | D001M | 756 |  |  |  |  |  |  |  |  | 230
 |  | 49 | [NAME] | 756 |  |  |  |  |  |  |  |  | 230
 |  | 50 | D001O | 756 |  |  |  |  |  |  |  |  | 230
 |  | 51 | D001P | 756 |  |  |  |  |  |  |  |  | 230
 |  | 52 | [NAME] | 756 |  |  |  |  |  |  |  |  | 230
E001 |  | 36 | E001A | 500 |  |  |  |  |  |  |  |  | 220
MM-Trade |  | 37 | E001B | 500 |  |  |  |  |  |  |  |  | 226.25
 |  | 38 | E001C | 500 |  |  |  |  |  |  |  |  | 293.75
 |  | 39 | E001D | 500 |  |  |  |  |  |  |  |  | 381
 |  | 40 | E001E | 500 |  |  |  |  |  |  |  |  | 282
 |  | 41 | E001F | 500 |  |  | 500 |  |  |  |  |  | 363.75
 |  | 42 | E001G | 500 |  |  |  |  |  |  |  |  | 446.25
 |  | 43 | E001H | 500 |  |  |  |  |  |  |  |  | 474
 | Last Week | 44 | E001I | 500 |  |  |  |  |  |  |  |  | 344
 | Current week | 45 | E001J | 500 |  |  |  |  |  |  |  |  | 380
 | Next week | 46 | E001K | 500 |  |  |  |  |  |  |  |  | 450
 |  | 47 | E001L | 500 |  |  |  |  |  |  |  |  | 450
 |  | 48 | E001M | 500 |  |  |  |  |  |  |  |  | 450
 |  | 49 | E001N | 500 |  |  |  |  |  |  |  |  | 450
 |  | 50 | E001O | 500 |  |  |  |  |  |  |  |  | 450
 |  | 51 | E001P | 500 |  |  |  |  |  |  |  |  | 450
 |  | 52 | E001Q | 500 |  |  |  |  |  |  |  |  | 450