Spreadsheet: 726657d1617356990-calculation-in-power-query-dayfile
Sheet: DayFIles

ShipmentNo | RType | RCustomerCategory | Rcity | Rzone | PalletPlace
2103191706 | SSS | A | ESKILSTUNA | D070-001 | 13.5
2103191708 | SSS | B | ESKILSTUNA | D070-001 | 10
2103191710 | SSS | A | TORSHALLA | D070-001 | 17
2103191712 | SSS | A | ENKOPING | D070-004 | 22
2103191713 | SSS | A | VASTERAS | D070-003 | 18
2103191714 | SSS | A | SALA | D070-004 | 2
2103191715 | SSS | A | VASTERAS | D070-003 | 18.5
2103191716 | SSS | A | VASTERAS | D070-003 | 9.5
2103191717 | SSS | A | VASTERAS | D070-003 | 15.5
2103191718 | HHH | A | VASTERAS | D070-003 | 2
2103222109 | SSS | B | ESKILSTUNA | D070-001 | 2
2103222111 | SSS | A | ENKOPING | D070-004 | 4
2103222112 | SSS | A | SALA | D070-004 | 15.5
2103222113 | HHH | A | ENKOPING | D070-004 | 3
2103222114 | HHH | C | ENKOPING | D070-004 | 0.5
2103222115 | HHH | A | ENKOPING | D070-004 | 0.5
2103232653 | SSS | A | HALLSTAHAMMAR | D070-003 | 11.5
2103232655 | SSS | A | ESKILSTUNA | D070-001 | 24
2103232660 | SSS | A | ENKOPING | D070-004 | 18.5
2103232661 | SSS | A | VASTERAS | D070-003 | 25.5
2103232662 | SSS | A | VASTERAS | D070-003 | 18
2103232663 | SSS | A | VASTERAS | D070-003 | 18.5
2103232664 | HHH | A | VASTERAS | D070-003 | 1.5
2103232665 | HHH | A | VASTERAS | D070-003 | 0.5
2103232666 | HHH | A | VASTERAS | D070-003 | 0.5
2103232667 | HHH | A | VASTERAS | D070-003 | 0.5
2103232668 | HHH | A | VASTERAS | D070-003 | 0.5
2103232669 | HHH | A | ESKILSTUNA | D070-001 | 0.5
2103243254 | SSS | A | HALLSTAHAMMAR | D070-003 | 5
2103243255 | SSS | B | ESKILSTUNA | D070-001 | 12.5
2103243256 | SSS | A | TORSHALLA | D070-001 | 10
2103243257 | DDD | A | SALA | D070-004 | 2
2103243258 | SSS | A | SALA | D070-004 | 8
2103243259 | SSS | A | VASTERAS | D070-003 | 29
2103243260 | HHH | D | VASTERAS | D070-003 | 0.5
2103243261 | SSS | A | VASTERAS | D070-003 | 10.5
2103243262 | HHH | A | VASTERAS | D070-003 | 0.5
2103243263 | SSS | B | SURAHAMMAR | D070-003 | 7
2103243264 | HHH | A | ENKOPING | D070-004 | 2.5
2103243265 | HHH | A | VASTERAS | D070-003 | 0.5
2103243266 | HHH | A | VASTERAS | D070-003 | 1
2103243267 | HHH | A | ENKOPING | D070-004 | 1.5
2103243268 | HHH | A | VASTERAS | D070-003 | 0.5
2103243269 | HHH | A | VASTERAS | D070-003 | 0.5
2103243270 | HHH | A | SALA | D070-004 | 0.5
2103253714 | SSS | A | ESKILSTUNA | D070-001 | 24
2103253716 | SSS | A | ENKOPING | D070-004 | 12
2103253717 | SSS | A | VASTERAS | D070-003 | 21
2103253718 | SSS | A | VASTERAS | D070-003 | 16.5
2103253719 | HHH | A | VASTERAS | D070-003 | 1
2103191731 | SSS | A | ESKILSTUNA | D070-001 | 5.5
2103191732 | HHH | C | ESKILSTUNA | D070-001 | 1
2103191733 | HHH | A | ESKILSTUNA | D070-001 | 2
2103191734 | HHH | D | ESKILSTUNA | D070-001 | 1
2103191735 | HHH | B | ESKILSTUNA | D070-001 | 1
2103191737 | HHH | B | ESKILSTUNA | D070-001 | 1.01
2103191738 | HHH | D | KVICKSUND | D070-001 | 1
2103191739 | SSS | A | VASTERAS | D070-003 | 6
2103191740 | SSS | A | SALA | D070-004 | 4.5
2103191741 | HHH | A | SALA | D070-004 | 6
2103191742 | HHH | A | VASTERAS | D070-003 | 3
2103191743 | HHH | A | VASTERAS | D070-003 | 4
2103191744 | HHH | A | VASTERAS | D070-003 | 1
2103191745 | HHH | A | ENKOPING | D070-004 | 4
2103191746 | HHH | A | VASTERAS | D070-003 | 1
2103191747 | HHH | A | ENKOPING | D070-004 | 1
2103191748 | HHH | A | VASTERAS | D070-003 | 3
2103191749 | SSS | A | HALLSTAHAMMAR | D070-003 | 5.5
2103222245 | SSS | B | ESKILSTUNA | D070-001 | 4.5
2103222248 | HHH | C | ESKILSTUNA | D070-001 | 1
2103222250 | HHH | A | ESKILSTUNA | D070-001 | 1
2103222254 | SSS | A | ENKOPING | D070-004 | 7
2103222255 | SSS | A | VASTERAS | D070-003 | 10
2103222256 | SSS | A | VASTERAS | D070-003 | 10
2103222257 | HHH | A | VASTERAS | D070-003 | 7
2103222258 | HHH | A | ENKOPING | D070-004 | 3
2103222259 | HHH | A | ENKOPING | D070-004 | 13
2103222260 | HHH | A | VASTERAS | D070-003 | 1
2103222261 | HHH | A | VASTERAS | D070-003 | 2
2103232831 | HHH | A | ESKILSTUNA | D070-001 | 6
2103232833 | HHH | A | ESKILSTUNA | D070-001 | 2
2103232834 | HHH | D | ESKILSTUNA | D070-001 | 1.01
2103232835 | HHH | A | ESKILSTUNA | D070-001 | 1
2103232836 | HHH | A | ESKILSTUNA | D070-001 | 1
2103232837 | HHH | B | VASTERAS | D070-003 | 1
2103232838 | HHH | C | VASTERAS | D070-003 | 1.01
2103232839 | HHH | D | VASTERAS | D070-003 | 1.01
2103232840 | SSS | A | VASTERAS | D070-003 | 3.5
2103232841 | HHH | A | VASTERAS | D070-003 | 1
2103232842 | SSS | B | SURAHAMMAR | D070-003 | 3
2103232843 | HHH | C | VASTERAS | D070-003 | 1.01
2103232844 | HHH | A | ENKOPING | D070-004 | 0.5
2103243489 | SSS | A | ESKILSTUNA | D070-001 | 13.5
2103243490 | SSS | B | ESKILSTUNA | D070-001 | 3
2103243492 | SSS | A | TORSHALLA | D070-001 | 9.5
2103243493 | HHH | C | ESKILSTUNA | D070-001 | 1.01
2103243494 | HHH | D | ESKILSTUNA | D070-001 | 1.01
2103243495 | HHH | D | ESKILSTUNA | D070-001 | 1
2103243496 | HHH | D | ESKILSTUNA | D070-001 | 2.01
2103243498 | HHH | A | ESKILSTUNA | D070-001 | 1
2103243499 | SSS | A | ENKOPING | D070-004 | 7.5
2103243500 | SSS | A | VASTERAS | D070-003 | 7.5
2103243501 | SSS | A | SALA | D070-004 | 3
2103243502 | SSS | A | VASTERAS | D070-003 | 1
2103243503 | SSS | A | VASTERAS | D070-003 | 6.5
2103254069 | HHH | A | ESKILSTUNA | D070-001 | 1
2103254070 | SSS | A | VASTERAS | D070-003 | 5.5
2103254071 | HHH | C | VASTERAS | D070-003 | 1.01
2103254072 | SSS | A | VASTERAS | D070-003 | 6.5
2103254073 | HHH | A | VASTERAS | D070-003 | 3
2103254074 | HHH | C | VASTERAS | D070-003 | 1
2103254075 | SSS | A | VASTERAS | D070-003 | 4
2103254076 | HHH | C | VASTERAS | D070-003 | 1
2103254077 | HHH | A | ENKOPING | D070-004 | 2
2103254078 | HHH | C | ENKOPING | D070-004 | 1.01
2103254079 | HHH | B | VASTERAS | D070-003 | 1
2103254080 | HHH | A | ENKOPING | D070-004 | 1
2103254081 | HHH | A | ENKOPING | D070-004 | 2
2103254082 | HHH | A | VASTERAS | D070-003 | 3
2103254083 | HHH | A | ENKOPING | D070-004 | 1
2103254084 | HHH | A | ENKOPING | D070-004 | 9
2103254085 | HHH | C | ENKOPING | D070-004 | 1
2103254086 | HHH | A | ENKOPING | D070-004 | 1.01