<!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_26_21_08_47"/>
        <locale value="en_AU"/>
        <id value="7502050f317407090b7576010d0838"/>
        <snap_to_grid value="1"/>
        <notes/>
        <doc_path value="%2FUsers%2Fdavid%2Ftmp%2FEDT%2FPercentile.transform"/>
        <auto_run_on value="0"/>
    </meta>
    <inputs>
        <input pos="-568.8^-1481.4" ignored_rows="0" show_meta="0" json_arrays_as_rows="0" delimiter="0" name="Clipboard" pos_v12="-568.8-1481.4" watching="0" medium="1" ignore_excel_hidden="0" auto_fixed_widths="1" header="1" ignore_empty_cols="0" trim="1" file_type="0" id="31" custom_delimiter="%2A" ignore_repeated_delim="0" text="Code%09Price%09EPS%203M%20Rev%09Analysts%0AAHL%090.700%091.39%092%0ABWP%093.630%091.46%097%0ACGF%097.170%093.31%0913%0ACQR%093.530%09-8.31%0910%0AEMR%094.020%0935.16%093%0AIFM%091.765%091.51%096%0ANEU%0915.520%098.83%096%0ARMD%0933.490%092.22%0910%0ASPK%093.630%090.18%094%0AWEB%098.190%094.26%0916" meta_text="%24%28CurrentDateTime%29" ignore_empty="1" encoding="Automatic" quote="0" simplify="1"/>
    </inputs>
    <transforms>
        <transform id="8" name="Stats" pos="-329.4^-1361.7" comment="Get%2080th%20percentile%20value%2C%20marking%20the%20top%2020%25%20of%20EPS%20forecast%20growth%20revisions%203%20month%20value.%0A-%20Need%20to%20modify%20the%20above%20criterion%20if%20you%20want%20something%20other%20than%20the%20top%20quintile." pos_v12="-329.4-1361.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="22" name="Filter" pos="-90^-1242" comment="Keep%20only%20percentile%20value" pos_v12="-90-1242">
            <parameters>
                <parameter type="3" name="Columns" value="1110percentile"/>
                <parameter type="5" name="Case_Sensitive" value="0"/>
                <parameter type="5" name="Disable" value="0"/>
            </parameters>
        </transform>
        <transform id="23" name="Remove" pos="-329.4^-1002.6" comment="Remove%20all%20columns%20except%20the%20aforementioned%20percentile%20value" pos_v12="-329.4-1002.6">
            <parameters>
                <parameter type="11" name="Columns" value="3"/>
            </parameters>
        </transform>
        <transform id="24" name="Rename_Cols" pos="-568.8^-1361.7" comment="Rename%20the%20percentile%20value%20column%20to%20%22cutoff%22%20so%20it%20is%20different%20from%20the%20column%20name%20whence%20it%20came" pos_v12="-568.8-1361.7">
            <parameters>
                <parameter type="13" name="RenameColumns" value="cutoff"/>
            </parameters>
        </transform>
        <transform id="26" name="Cross" pos="-329.4^-1481.4" comment="Merge%20the%20original%20data%20set%20%28renamed%20and%20with%20extraneities%20removed%29%20with%20the%20discovered%20percentilve%20value%2C%20creating%20a%20new%20column." pos_v12="-329.4-1481.4">
            <parameters/>
        </transform>
        <transform id="27" name="Filter" pos="-90^-1601.1" comment="Keep%20top%20quintile%2C%20only%20the%20rows%20whose%20EPS%20forecast%203%20month%20revision%20is%20greater%20than%20or%20equal%20to%20the%20cutoff%20criterion" pos_v12="-90-1601.1">
            <parameters>
                <parameter type="3" name="Columns" value="1134%24%28cutoff%29"/>
                <parameter type="5" name="Case_Sensitive" value="1"/>
                <parameter type="5" name="Disable" value="0"/>
            </parameters>
        </transform>
        <transform id="28" name="Stack" pos="149.4^-1361.7" comment="Add%20back%20%20percentile%20row%20so%20it%20can%20be%20seen%20at%20bottom" pos_v12="149.4-1361.7">
            <parameters>
                <parameter type="6" name="Align_Cols" value="Header%20name"/>
                <parameter type="5" name="Only_First_Cols" value="0"/>
                <parameter type="5" name="Add_Separators" value="0"/>
                <parameter type="7" name="User_Defined_Row_Value" value="---"/>
            </parameters>
        </transform>
        <transform id="29" name="Remove" pos="-90^-1361.7" comment="Remove%20the%20%22cutoff%22%20column%20because%20we%20no%20longer%20need%20it" pos_v12="-90-1361.7">
            <parameters>
                <parameter type="11" name="Columns" value="1234"/>
            </parameters>
        </transform>
    </transforms>
    <outputs/>
    <notes/>
    <connections>
        <connection start_id="8" end_id="22"/>
        <connection start_id="22" end_id="23"/>
        <connection start_id="22" end_id="28"/>
        <connection start_id="23" end_id="24"/>
        <connection start_id="24" end_id="26"/>
        <connection start_id="26" end_id="27"/>
        <connection start_id="27" end_id="29"/>
        <connection start_id="29" end_id="28"/>
        <connection start_id="31" end_id="8"/>
        <connection start_id="31" end_id="26"/>
    </connections>
    <batch_values/>
    <batch_logging enabled="0" mode="0"/>
</root>
