Spreadsheet: 856917d1706074707-container-yard-location-in-graphical-summary-view-container-yard-finding
Sheet: H01-H02

[NAME] for Container Block 1H and 2H - Bird Eye View
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N
 | F | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 | E | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
1H | D | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | H01
 | C | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 | B | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 | A | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  | 85 | 83 | 81 | 79 | 77 | 75 | 73 | 71 | 69 | 67 | 65 | 63 | 61 | 59 | 57 | 55 | 53 | 51 | 49 | 47 | 45 | 43 | 41 | 39 | 37 | 35 | 33 | 31 | 29 | 27 | 25 | 23 | 21 | 19 | 17 | 15 | 13 | 11 | 9 | 7 | 5 | 3 | 1
 |  |  |  | Traffic Path
 |  | 85 | 83 | 81 | 79 | 77 | 75 | 73 | 71 | 69 | 67 | 65 | 63 | 61 | 59 | 57 | 55 | 53 | 51 | 49 | 47 | 45 | 43 | 41 | 39 | 37 | 35 | 33 | 31 | 29 | 27 | 25 | 23 | 21 | 19 | 17 | 15 | 13 | 11 | 9 | 7 | 5 | 3 | 1
 |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
2H |  | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | H02
 |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 | Section View
 |  |  |  |  |  |  |  |  |  |  |  |  | 40'
 |  |  |  |  |  |  |  |  |  |  |  |  | 1H52E1
 |  |  |  |  | A | B | C | D | E | F |  |  |  |  | A | B | C | D | E | F
 |  |  |  |  |  |  | 1H85 |  |  |  |  |  |  |  |  |  | 1H51
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1H85E2
 |  |  | 20' |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1H85E1
 |  |  | 1H83A2
 |  |  | 1H83A1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  |  |  |  | A |  | B |  | C |  | D |  | E
 |  |  |  |  | A | B | C | D | E | F |  |  |  |  | A | B | C | D | E | F |  |  |  |  |  |  |  | if this is 1H85 Stack
 |  |  |  |  |  |  | 1H83 |  |  |  |  |  |  |  |  |  | 1H53 |  |  |  |  |  |  |  |  |  | 1H85A1
 |  |  |  |  |  | 20' Contaianer |  |  |  |  |  |  |  |  |  | 40' [NAME] ( 02 X20'slots )
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Bird Eye view of container block
 |  |  |  |  | A | B | C | D | E | F
 |  |  |  |  |  |  | 1H81
 | Dear All
 | Good Day ,
 | I have a container list  which needs the yard location to be entered. My requirement is when a yard storage location of a container is entered in to the list , location to be appeared in a location graphical summary .
 | there are two types of containers.20 feet and 40 feet. if a 20' container is stored at a yard location eg. [NAME] 1H , stack 83, row A , tier 1 (Height ) then the yard location will read as 1H83A1.
 | for a 40' container need two 20' yard slots . if a 40 container stored at 1H52E1 means it occupies 1H51E1 and 1H53E1 then the container location will read as 1H52E1.here the stack number is 52 ( Even number, occupy 51 and 53 )
 | always a yard location are numbered 20' slots with odd numbers. An even number means a 40' container. Th4, once a 40' container is stored it can appear in the forst odd number slot in the graphical view and the adjacent number will be marks as blocked (X)
 | Attached excel has a list, 20 and 40 feet container locations as example.
 | Need,
 | 20 container location to appear in the graphical summary ( container number with a color that the container number is in the list
 | 40 container also to appear same in the graphical summary with adjacent 20 slot is marked as X