<!DOCTYPE EasyDataTransform>
<root>
    <meta>
        <version value="79"/>
        <last_saved_by value="Olaf_W%C3%BCllenrath_using_Easy_Data_Transform_v2_7_0_on_macOS_15_6_arm64_at_2025_08_01_16_45_13"/>
        <locale value="de_DE"/>
        <id value="7d7705083775070a0b747a740c083c01"/>
        <snap_to_grid value="1"/>
        <notes/>
        <doc_path value="%2FUsers%2Folaf%2FDownloads%2FegilDOTnet%202.transform"/>
        <auto_run_on value="1"/>
    </meta>
    <inputs>
        <input pos="-90^-45" ignored_rows="0" show_meta="0" json_arrays_as_rows="0" delimiter="0" ignore_excel_hidden_cols="0" schema_in_use="0" name="Clipboard" schema_extra_cols="0" pos_v12="-90-45" watching="0" medium="1" auto_fixed_widths="1" header="1" schema_missing_cols="0" ignore_empty_cols="0" schema_reorder_cols="0" trim="1" meta_col_name="Meta%20Info" file_type="0" id="1436" custom_delimiter="%2A" ignore_repeated_delim="0" text="Stock%20No%20%09Length%20%09Physical%20Stock%0A26%20%093000%20%095%2C2%0A36%20%094000%20%099%2C1" meta_text="%24%28CurrentDateTime%29" ignore_excel_hidden_rows="0" ignore_empty="1" encoding="Automatic" quote="0" simplify="1"/>
    </inputs>
    <transforms>
        <transform id="1437" name="Calculate" pos="149.4^-45" pos_v12="149.4-45">
            <parameters>
                <parameter type="5" name="Auto_New_Name" value="1"/>
                <parameter type="7" name="New_Name" value="Num"/>
                <parameter type="6" name="Operation" value="Ceiling"/>
                <parameter type="6" name="Type1" value="Column"/>
                <parameter type="0" name="Column1" value="3"/>
                <parameter type="7" name="Constant1" value=""/>
                <parameter type="6" name="Type2" value="Constant"/>
                <parameter type="0" name="Column2" value="0"/>
                <parameter type="7" name="Constant2" value=""/>
            </parameters>
        </transform>
        <transform id="1441" name="New_Rows" pos="1107^-45" pos_v12="1107-45">
            <parameters>
                <parameter type="6" name="Number_How_Name" value="Set%20from%20a%20column"/>
                <parameter type="0" name="Number_Col_Name" value="5"/>
                <parameter type="8" name="Number_Const_Name" value="0"/>
                <parameter type="6" name="As_Name" value="Copied%20row%28s%29"/>
                <parameter type="7" name="User_Defined_Row_Value" value="---"/>
                <parameter type="6" name="Location_Name" value="Above%20each%20row"/>
                <parameter type="6" name="For_Name" value="Every%20row"/>
                <parameter type="0" name="Match_Column_Name" value="0"/>
                <parameter type="6" name="Match_Type_Name" value="%3D%20%20%20Equal%20to"/>
                <parameter type="7" name="Match_Value_Name" value=""/>
                <parameter type="5" name="Match_Case_Sensitive" value="1"/>
            </parameters>
        </transform>
        <transform id="1444" name="Calculate" pos="388.8^-45" pos_v12="388.8-45">
            <parameters>
                <parameter type="5" name="Auto_New_Name" value="1"/>
                <parameter type="7" name="New_Name" value="Calculate"/>
                <parameter type="6" name="Operation" value="%2B%20Add"/>
                <parameter type="6" name="Type1" value="Column"/>
                <parameter type="0" name="Column1" value="4"/>
                <parameter type="7" name="Constant1" value=""/>
                <parameter type="6" name="Type2" value="Constant"/>
                <parameter type="0" name="Column2" value="0"/>
                <parameter type="7" name="Constant2" value="1"/>
            </parameters>
        </transform>
        <transform id="1445" name="Unfill" pos="1585.8^-45" pos_v12="1585.8-45">
            <parameters>
                <parameter type="1" name="Columns" value="23"/>
                <parameter type="6" name="Direction" value="Down"/>
                <parameter type="6" name="For" value="Rows%20with%20same%20key%20value"/>
                <parameter type="0" name="Key_Column" value="1"/>
            </parameters>
        </transform>
        <transform id="1447" name="Calculate" pos="628.2^-45" pos_v12="628.2-45">
            <parameters>
                <parameter type="5" name="Auto_New_Name" value="1"/>
                <parameter type="7" name="New_Name" value="Calculate"/>
                <parameter type="6" name="Operation" value="Floor"/>
                <parameter type="6" name="Type1" value="Column"/>
                <parameter type="0" name="Column1" value="3"/>
                <parameter type="7" name="Constant1" value=""/>
                <parameter type="6" name="Type2" value="Constant"/>
                <parameter type="0" name="Column2" value="0"/>
                <parameter type="7" name="Constant2" value=""/>
            </parameters>
        </transform>
        <transform id="1448" name="Calculate" pos="867.6^-45" pos_v12="867.6-45">
            <parameters>
                <parameter type="5" name="Auto_New_Name" value="1"/>
                <parameter type="7" name="New_Name" value="Calculate"/>
                <parameter type="6" name="Operation" value="-%20Subtract"/>
                <parameter type="6" name="Type1" value="Column"/>
                <parameter type="0" name="Column1" value="3"/>
                <parameter type="7" name="Constant1" value=""/>
                <parameter type="6" name="Type2" value="Column"/>
                <parameter type="0" name="Column2" value="6"/>
                <parameter type="7" name="Constant2" value=""/>
            </parameters>
        </transform>
        <transform id="1450" name="Copy" pos="1825.2^-45" pos_v12="1825.2-45">
            <parameters>
                <parameter type="1" name="Columns" value="1"/>
                <parameter type="8" name="Copies" value="1"/>
            </parameters>
        </transform>
        <transform id="1451" name="Offset" pos="2064.6^-45" pos_v12="2064.6-45">
            <parameters>
                <parameter type="1" name="Columns" value="9"/>
                <parameter type="8" name="Offset_Amount" value="1"/>
                <parameter type="6" name="Offset_Direction" value="Up"/>
                <parameter type="5" name="Wraparound" value="0"/>
                <parameter type="7" name="New_Value" value=""/>
            </parameters>
        </transform>
        <transform id="1452" name="If" pos="2304^-45" pos_v12="2304-45">
            <parameters>
                <parameter type="7" name="New_Name" value="If"/>
                <parameter type="10" name="If" value="*StartIf*110%24%289%29*EndIf*%24%287%29*StartIf*220*EndIf*%24%286%29"/>
                <parameter type="5" name="Case_Sensitive" value="1"/>
            </parameters>
        </transform>
        <transform id="1453" name="Calculate" pos="2782.8^-45" pos_v12="2782.8-45">
            <parameters>
                <parameter type="5" name="Auto_New_Name" value="1"/>
                <parameter type="7" name="New_Name" value="Calculate"/>
                <parameter type="6" name="Operation" value="%2A%20Multiply"/>
                <parameter type="6" name="Type1" value="Column"/>
                <parameter type="0" name="Column1" value="8"/>
                <parameter type="7" name="Constant1" value=""/>
                <parameter type="6" name="Type2" value="Column"/>
                <parameter type="0" name="Column2" value="11"/>
                <parameter type="7" name="Constant2" value=""/>
            </parameters>
        </transform>
        <transform id="1454" name="Copy" pos="1346.4^-45" pos_v12="1346.4-45">
            <parameters>
                <parameter type="1" name="Columns" value="2"/>
                <parameter type="8" name="Copies" value="1"/>
            </parameters>
        </transform>
        <transform id="1455" name="If" pos="2543.4^-45" pos_v12="2543.4-45">
            <parameters>
                <parameter type="7" name="New_Name" value="If"/>
                <parameter type="10" name="If" value="*StartIf*1061*EndIf*1%24%2810%29"/>
                <parameter type="5" name="Case_Sensitive" value="1"/>
            </parameters>
        </transform>
        <transform id="1456" name="Remove" pos="3022.2^-45" pos_v12="3022.2-45">
            <parameters>
                <parameter type="11" name="Columns" value="12312"/>
            </parameters>
        </transform>
        <transform id="1457" name="Slide" pos="3261.6^-45" pos_v12="3261.6-45">
            <parameters>
                <parameter type="1" name="Columns" value="34"/>
                <parameter type="6" name="Direction" value="Left"/>
            </parameters>
        </transform>
        <transform id="1458" name="Remove" pos="3501^-45" pos_v12="3501-45">
            <parameters>
                <parameter type="11" name="Columns" value="123"/>
            </parameters>
        </transform>
        <transform id="1459" name="Calculate" pos="149.4^74.7" pos_v12="149.474.7">
            <parameters>
                <parameter type="5" name="Auto_New_Name" value="1"/>
                <parameter type="7" name="New_Name" value="Num"/>
                <parameter type="6" name="Operation" value="Ceiling"/>
                <parameter type="6" name="Type1" value="Column"/>
                <parameter type="0" name="Column1" value="3"/>
                <parameter type="7" name="Constant1" value=""/>
                <parameter type="6" name="Type2" value="Constant"/>
                <parameter type="0" name="Column2" value="0"/>
                <parameter type="7" name="Constant2" value=""/>
            </parameters>
        </transform>
        <transform id="1461" name="Calculate" pos="628.2^74.7" pos_v12="628.274.7">
            <parameters>
                <parameter type="5" name="Auto_New_Name" value="1"/>
                <parameter type="7" name="New_Name" value="Calculate"/>
                <parameter type="6" name="Operation" value="Floor"/>
                <parameter type="6" name="Type1" value="Column"/>
                <parameter type="0" name="Column1" value="3"/>
                <parameter type="7" name="Constant1" value=""/>
                <parameter type="6" name="Type2" value="Constant"/>
                <parameter type="0" name="Column2" value="0"/>
                <parameter type="7" name="Constant2" value=""/>
            </parameters>
        </transform>
        <transform id="1462" name="Calculate" pos="867.6^74.7" pos_v12="867.674.7">
            <parameters>
                <parameter type="5" name="Auto_New_Name" value="1"/>
                <parameter type="7" name="New_Name" value="Calculate"/>
                <parameter type="6" name="Operation" value="-%20Subtract"/>
                <parameter type="6" name="Type1" value="Column"/>
                <parameter type="0" name="Column1" value="3"/>
                <parameter type="7" name="Constant1" value=""/>
                <parameter type="6" name="Type2" value="Column"/>
                <parameter type="0" name="Column2" value="5"/>
                <parameter type="7" name="Constant2" value=""/>
            </parameters>
        </transform>
        <transform id="1463" name="New_Rows" pos="1107^74.7" pos_v12="110774.7">
            <parameters>
                <parameter type="6" name="Number_How_Name" value="Set%20from%20a%20column"/>
                <parameter type="0" name="Number_Col_Name" value="4"/>
                <parameter type="8" name="Number_Const_Name" value="0"/>
                <parameter type="6" name="As_Name" value="Copied%20row%28s%29"/>
                <parameter type="7" name="User_Defined_Row_Value" value="---"/>
                <parameter type="6" name="Location_Name" value="Above%20each%20row"/>
                <parameter type="6" name="For_Name" value="Every%20row"/>
                <parameter type="0" name="Match_Column_Name" value="0"/>
                <parameter type="6" name="Match_Type_Name" value="%3D%20%20%20Equal%20to"/>
                <parameter type="7" name="Match_Value_Name" value=""/>
                <parameter type="5" name="Match_Case_Sensitive" value="1"/>
            </parameters>
        </transform>
        <transform id="1464" name="Copy" pos="1346.4^74.7" pos_v12="1346.474.7">
            <parameters>
                <parameter type="1" name="Columns" value="2"/>
                <parameter type="8" name="Copies" value="1"/>
            </parameters>
        </transform>
        <transform id="1465" name="Unfill" pos="1585.8^74.7" pos_v12="1585.874.7">
            <parameters>
                <parameter type="1" name="Columns" value="23"/>
                <parameter type="6" name="Direction" value="Down"/>
                <parameter type="6" name="For" value="Rows%20with%20same%20key%20value"/>
                <parameter type="0" name="Key_Column" value="1"/>
            </parameters>
        </transform>
        <transform id="1466" name="Copy" pos="1825.2^74.7" pos_v12="1825.274.7">
            <parameters>
                <parameter type="1" name="Columns" value="1"/>
                <parameter type="8" name="Copies" value="1"/>
            </parameters>
        </transform>
        <transform id="1467" name="Offset" pos="2064.6^74.7" pos_v12="2064.674.7">
            <parameters>
                <parameter type="1" name="Columns" value="8"/>
                <parameter type="8" name="Offset_Amount" value="1"/>
                <parameter type="6" name="Offset_Direction" value="Up"/>
                <parameter type="5" name="Wraparound" value="0"/>
                <parameter type="7" name="New_Value" value=""/>
            </parameters>
        </transform>
        <transform id="1468" name="If" pos="2304^74.7" pos_v12="230474.7">
            <parameters>
                <parameter type="7" name="New_Name" value="If"/>
                <parameter type="10" name="If" value="*StartIf*110%24%288%29*EndIf*%24%286%29*StartIf*220*EndIf*1"/>
                <parameter type="5" name="Case_Sensitive" value="1"/>
            </parameters>
        </transform>
        <transform id="1470" name="Calculate" pos="2782.8^74.7" pos_v12="2782.874.7">
            <parameters>
                <parameter type="5" name="Auto_New_Name" value="1"/>
                <parameter type="7" name="New_Name" value="Calculate"/>
                <parameter type="6" name="Operation" value="%2A%20Multiply"/>
                <parameter type="6" name="Type1" value="Column"/>
                <parameter type="0" name="Column1" value="7"/>
                <parameter type="7" name="Constant1" value=""/>
                <parameter type="6" name="Type2" value="Column"/>
                <parameter type="0" name="Column2" value="9"/>
                <parameter type="7" name="Constant2" value=""/>
            </parameters>
        </transform>
        <transform id="1471" name="Remove" pos="3022.2^74.7" pos_v12="3022.274.7">
            <parameters>
                <parameter type="11" name="Columns" value="12310"/>
            </parameters>
        </transform>
        <transform id="1472" name="Slide" pos="3261.6^74.7" pos_v12="3261.674.7">
            <parameters>
                <parameter type="1" name="Columns" value="34"/>
                <parameter type="6" name="Direction" value="Left"/>
            </parameters>
        </transform>
        <transform id="1473" name="Remove" pos="3501^74.7" pos_v12="350174.7">
            <parameters>
                <parameter type="11" name="Columns" value="123"/>
            </parameters>
        </transform>
    </transforms>
    <outputs/>
    <notes>
        <note id="1474" comment="Need%20adaptation%20in%20the%20two%20%24%28x%29%20statements" pos_v12="2304194.4" color="255%1F255%1F255" arrow="1"/>
    </notes>
    <connections>
        <connection start_id="1436" end_id="1459"/>
        <connection start_id="1436" end_id="1437"/>
        <connection start_id="1437" end_id="1444"/>
        <connection start_id="1441" end_id="1454"/>
        <connection start_id="1444" end_id="1447"/>
        <connection start_id="1445" end_id="1450"/>
        <connection start_id="1447" end_id="1448"/>
        <connection start_id="1448" end_id="1441"/>
        <connection start_id="1450" end_id="1451"/>
        <connection start_id="1451" end_id="1452"/>
        <connection start_id="1452" end_id="1455"/>
        <connection start_id="1453" end_id="1456"/>
        <connection start_id="1454" end_id="1445"/>
        <connection start_id="1455" end_id="1453"/>
        <connection start_id="1456" end_id="1457"/>
        <connection start_id="1457" end_id="1458"/>
        <connection start_id="1459" end_id="1461"/>
        <connection start_id="1461" end_id="1462"/>
        <connection start_id="1462" end_id="1463"/>
        <connection start_id="1463" end_id="1464"/>
        <connection start_id="1464" end_id="1465"/>
        <connection start_id="1465" end_id="1466"/>
        <connection start_id="1466" end_id="1467"/>
        <connection start_id="1467" end_id="1468"/>
        <connection start_id="1468" end_id="1470"/>
        <connection start_id="1470" end_id="1471"/>
        <connection start_id="1471" end_id="1472"/>
        <connection start_id="1472" end_id="1473"/>
    </connections>
    <batch_values/>
    <batch_logging enabled="0" mode="0"/>
</root>
