Hi,
I have a huge excel file that contains hundreds of thousands of rows and all of them are according to the pattern below:
I really need your help in order to cut all irrelevant data and remain only with what is interesting to me.
The data I wish to get at the end is marked in yellow and should be accordingly ( number and date):
705F3E6202208 20200324_101659
70EQ130003618 20200324_101659
70EQ130003701 20200324_101659
In case of number appears twice I want to print only the latest date it has.
Additional list for possible debug:
Thanks a lot!!
I have a huge excel file that contains hundreds of thousands of rows and all of them are according to the pattern below:
<LOT ID="DD43;1;False;1"><TRAY ID="1" TIMESTAMP="20200324_101659"> |
<A0 ID="705F3E6202208"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A0> |
<B0 ID="70EQ130003618"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B0> |
<C0 ID="70EQ130003701"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C0> |
<D0 ID="70EQ130001964"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D0> |
<A1 ID="70TP214002654"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A1> |
<B1 ID="70EQ130001987"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B1> |
<C1 ID="70EQ130001934"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C1> |
<D1 ID="70TP214001385"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D1> |
<A2 ID="70EQ130001797"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A2> |
<B2 ID="70EQ130000058"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B2> |
<C2 ID="70EQ130001775"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C2> |
<D2 ID="705F3E6202218"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D2> |
<A3 ID="70EQ130003977"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A3> |
<B3 ID="70EQ130000234"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B3> |
<C3 ID="70EQ130003763"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C3> |
<D3 ID="705F3E6201705"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D3> |
<A4 ID="70EQ130003747"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A4> |
<B4 ID="70EQ130000220"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B4> |
<C4 ID="705F3E6201824"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C4> |
<D4 ID="707Y6X7201512"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D4> |
<A5 ID="707Y6X7200621"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A5> |
<B5 ID="707Y6X7201966"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B5> |
<C5 ID="705F3E6201509"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C5> |
<D5 ID="707Y6X7201914"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D5> |
</TRAY> |
</LOT> |
I really need your help in order to cut all irrelevant data and remain only with what is interesting to me.
The data I wish to get at the end is marked in yellow and should be accordingly ( number and date):
705F3E6202208 20200324_101659
70EQ130003618 20200324_101659
70EQ130003701 20200324_101659
In case of number appears twice I want to print only the latest date it has.
Additional list for possible debug:
<LOT ID="123"><TRAY ID="1" TIMESTAMP="20200324_095310"> |
<A0 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A0> |
<B0 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B0> |
<C0 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C0> |
<D0 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D0> |
<A1 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A1> |
<B1 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B1> |
<C1 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C1> |
<D1 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D1> |
<A2 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A2> |
<B2 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B2> |
<C2 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C2> |
<D2 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D2> |
<A3 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A3> |
<B3 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B3> |
<C3 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C3> |
<D3 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D3> |
<A4 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A4> |
<B4 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B4> |
<C4 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C4> |
<D4 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D4> |
</TRAY> |
</LOT> |
<LOT ID="123"><TRAY ID="1" TIMESTAMP="20200324_095941"> |
<A0 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A0> |
<B0 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B0> |
<C0 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C0> |
<D0 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D0> |
<A1 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A1> |
<B1 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B1> |
<C1 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C1> |
<D1 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D1> |
<A2 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A2> |
<B2 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B2> |
<C2 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C2> |
<D2 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D2> |
<A3 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A3> |
<B3 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B3> |
<C3 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C3> |
<D3 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D3> |
<A4 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A4> |
<B4 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B4> |
<C4 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C4> |
<D4 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D4> |
</TRAY> |
</LOT> |
<LOT ID="test"><TRAY ID="1" TIMESTAMP="20200324_100413"> |
<A0 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A0> |
<B0 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B0> |
<C0 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C0> |
<D0 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D0> |
<A1 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A1> |
<B1 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B1> |
<C1 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C1> |
<D1 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D1> |
<A2 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A2> |
<B2 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B2> |
<C2 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C2> |
<D2 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D2> |
<A3 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A3> |
<B3 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B3> |
<C3 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C3> |
<D3 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D3> |
<A4 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A4> |
<B4 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B4> |
<C4 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C4> |
<D4 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D4> |
</TRAY> |
</LOT> |
<LOT ID="test"><TRAY ID="1" TIMESTAMP="20200324_100656"> |
<A0 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A0> |
<B0 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B0> |
<C0 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C0> |
<D0 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D0> |
<A1 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A1> |
<B1 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B1> |
<C1 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C1> |
<D1 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D1> |
<A2 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A2> |
<B2 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B2> |
<C2 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C2> |
<D2 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D2> |
<A3 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A3> |
<B3 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B3> |
<C3 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C3> |
<D3 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D3> |
<A4 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A4> |
<B4 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B4> |
<C4 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C4> |
<D4 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D4> |
</TRAY> |
</LOT> |
<LOT ID="test"><TRAY ID="1" TIMESTAMP="20200324_100738"> |
<A0 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A0> |
<B0 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B0> |
<C0 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C0> |
<D0 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D0> |
<A1 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A1> |
<B1 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B1> |
<C1 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C1> |
<D1 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D1> |
<A2 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A2> |
<B2 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B2> |
<C2 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C2> |
<D2 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D2> |
<A3 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A3> |
<B3 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B3> |
<C3 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C3> |
<D3 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D3> |
<A4 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A4> |
<B4 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B4> |
<C4 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C4> |
<D4 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D4> |
</TRAY> |
</LOT> |
<LOT ID="DD1;1;False;1"><TRAY ID="1" TIMESTAMP="20200324_101659"> |
<A0 ID="705F3E6202208"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A0> |
<B0 ID="70EQ130003618"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B0> |
<C0 ID="70EQ130003701"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C0> |
<D0 ID="70EQ130001964"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D0> |
<A1 ID="70TP214002654"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A1> |
<B1 ID="70EQ130001987"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B1> |
<C1 ID="70EQ130001934"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C1> |
<D1 ID="70TP214001385"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D1> |
<A2 ID="70EQ130001797"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A2> |
<B2 ID="70EQ130000058"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B2> |
<C2 ID="70EQ130001775"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C2> |
<D2 ID="705F3E6202218"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D2> |
<A3 ID="70EQ130003977"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A3> |
<B3 ID="70EQ130000234"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B3> |
<C3 ID="70EQ130003763"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C3> |
<D3 ID="705F3E6201705"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D3> |
<A4 ID="70EQ130003747"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A4> |
<B4 ID="70EQ130000220"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B4> |
<C4 ID="705F3E6201824"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C4> |
<D4 ID="707Y6X7201512"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D4> |
<A5 ID="707Y6X7200621"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A5> |
<B5 ID="707Y6X7201966"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B5> |
<C5 ID="705F3E6201509"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C5> |
<D5 ID="707Y6X7201914"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D5> |
</TRAY> |
</LOT> |
<LOT ID="DD1;1;False;1"><TRAY ID="2" TIMESTAMP="20200326_101705"> |
<A0 ID="707Y6X7201800"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A0> |
<B0 ID="707Y6X7202155"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B0> |
<C0 ID="707Y6X7202495"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C0> |
<D0 ID="707Y6X7201818"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D0> |
<A1 ID="707Y6X7202837"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A1> |
<B1 ID="707Y6X7201811"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B1> |
<C1 ID="707Y6X7201671"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C1> |
<D1 ID="707Y6X7202174"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D1> |
<A2 ID="707Y6X7201938"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A2> |
<B2 ID="707Y6X7200684"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B2> |
<C2 ID="707Y6X7201577"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C2> |
<D2 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1></LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D2> |
<A3 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A3> |
<B3 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B3> |
<C3 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C3> |
<D3 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D3> |
<A4 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A4> |
<B4 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B4> |
<C4 ID="705F3E6202208"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C4> |
<D4 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D4> |
<A5 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></A5> |
<B5 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></B5> |
<C5 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></C5> |
<D5 ID="#EMPTY"><ROTATION>0</ROTATION><LINE1>#EMPTY</LINE1><LINE2></LINE2><LINE3></LINE3><LINE4></LINE4></D5> |
</TRAY> |
</LOT> |