<!DOCTYPE EasyDataTransform>
<root>
    <meta>
        <version value="71"/>
        <last_saved_by value="David_Vaughan_using_Easy_Data_Transform_v1_46_6_on_macOS_14_6_at_2024_08_27_16_29_26"/>
        <locale value="en_AU"/>
        <id value="7702050e317307090b7576010c0838"/>
        <snap_to_grid value="1"/>
        <notes/>
        <doc_path value="%2FUsers%2Fdavid%2Ftmp%2FEDT%2FPercentile%202.1.transform"/>
        <auto_run_on value="0"/>
    </meta>
    <inputs>
        <input pos="-90^-45" ignored_rows="0" show_meta="3" json_arrays_as_rows="0" delimiter="0" name="Clipboard" pos_v12="-90-45" watching="0" medium="1" ignore_excel_hidden="0" auto_fixed_widths="1" header="1" ignore_empty_cols="0" trim="1" file_type="0" id="0" custom_delimiter="%2A" ignore_repeated_delim="0" text="Code%09Price%09EPS%203M%20Rev%0AAHL%090.700%0911.5%0ABWP%093.630%092.3%0ACGF%097.170%0918%0ACQR%093.530%09-3.4%0AEMR%094.020%09-4.7%0AIFM%091.765%0910.9%0ANEU%0915.520%0913.4%0ARMD%0933.490%099.8%0ASPK%093.630%0914.1%0AWEB%098.190%09-0.8%0AAHL%090.700%099.7%0ABWP%093.630%099.4%0ACGF%097.170%09-1.6%0ACQR%093.530%091.9%0AEMR%094.020%0911.7%0AIFM%091.765%0910.8%0ANEU%0915.520%0912.7%0ARMD%0933.490%09-5%0ASPK%093.630%0919.9%0AWEB%098.190%09-1.7" meta_text="%24%28DataRows%29" ignore_empty="1" encoding="Automatic" quote="0" simplify="1"/>
    </inputs>
    <transforms>
        <transform id="10" name="Sort" pos="388.8^-45" pos_v12="388.8-45">
            <parameters>
                <parameter type="2" name="Columns" value="-3"/>
                <parameter type="5" name="Rank_Add" value="0"/>
                <parameter type="6" name="Rank_Types" value="Minimum"/>
                <parameter type="0" name="Rank_By" value="0"/>
            </parameters>
        </transform>
        <transform id="11" name="Row_Num" pos="-90^74.7" pos_v12="-9074.7">
            <parameters>
                <parameter type="7" name="New_Name" value="Row%20Num"/>
                <parameter type="8" name="Start_At" value="1"/>
                <parameter type="8" name="Increment" value="1"/>
                <parameter type="8" name="Every" value="1"/>
            </parameters>
        </transform>
        <transform id="12" name="Filter" pos="388.8^74.7" pos_v12="388.874.7">
            <parameters>
                <parameter type="3" name="Columns" value="1167%24%28Calculate%2912Percen"/>
                <parameter type="5" name="Case_Sensitive" value="0"/>
                <parameter type="5" name="Disable" value="0"/>
            </parameters>
        </transform>
        <transform id="13" name="Remove" pos="-90^194.4" pos_v12="-90194.4">
            <parameters>
                <parameter type="11" name="Columns" value="123"/>
            </parameters>
        </transform>
        <transform id="14" name="Stats" pos="149.4^74.7" comment="Adjust%20Calculate%20with%20Stats" pos_v12="149.474.7">
            <parameters>
                <parameter type="1" name="Columns" value="3"/>
                <parameter type="6" name="Calculation" value="Percentile%20%28exclusive%29"/>
                <parameter type="8" name="Percentile" value="80"/>
                <parameter type="6" name="On" value="Columns"/>
            </parameters>
        </transform>
        <transform id="15" name="Calculate" pos="149.4^-45" comment="Val%202%20%3D%201%20-%20percentile" pos_v12="149.4-45">
            <parameters>
                <parameter type="5" name="Auto_New_Name" value="0"/>
                <parameter type="7" name="New_Name" value="Calculate"/>
                <parameter type="6" name="Operation" value="%2A%20Multiply"/>
                <parameter type="0" name="Column1" value="4"/>
                <parameter type="6" name="Type2" value="Constant"/>
                <parameter type="0" name="Column2" value="0"/>
                <parameter type="7" name="Constant2" value="0.2"/>
            </parameters>
        </transform>
    </transforms>
    <outputs/>
    <notes/>
    <connections>
        <connection start_id="0" end_id="15"/>
        <connection start_id="10" end_id="11"/>
        <connection start_id="11" end_id="14"/>
        <connection start_id="12" end_id="13"/>
        <connection start_id="14" end_id="12"/>
        <connection start_id="15" end_id="10"/>
    </connections>
    <batch_values/>
    <batch_logging enabled="0" mode="0"/>
</root>
