<!DOCTYPE EasyDataTransform>
<root>
    <meta>
        <version value="70"/>
        <last_saved_by value="Easy_Data_Transform_v1_46_5_on_Windows_10_Version_2009_at_2024_05_07_00_10_58"/>
        <locale value="en_US"/>
        <snap_to_grid value="1"/>
        <notes/>
        <doc_path value="T%3A%5CEDT%5CSplitingCellstoCreateNewRow.transform"/>
        <auto_run_on value="0"/>
    </meta>
    <inputs>
        <input pos="-90^194.4" ignored_rows="0" show_meta="0" json_arrays_as_rows="0" delimiter="0" name="Clipboard" pos_v12="-90194.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="48" custom_delimiter="%2A" ignore_repeated_delim="0" text="Project%20Name%2CHours%0D%0AProject%20ABC%2C525%0D%0AProject%20Delta%2C160" meta_text="%24%28CurrentDateTime%29" ignore_empty="1" encoding="Automatic" quote="0" simplify="1"/>
        <input pos="-90^673.2" ignored_rows="0" show_meta="0" json_arrays_as_rows="0" delimiter="0" name="Clipboard" pos_v12="-90673.2" watching="0" medium="1" ignore_excel_hidden="0" auto_fixed_widths="1" header="1" ignore_empty_cols="0" trim="1" file_type="0" id="61" custom_delimiter="%2A" ignore_repeated_delim="0" text="Project%20Name%2CHours%0D%0AProject%20ABC%2C525%0D%0AProject%20Delta%2C160" meta_text="%24%28CurrentDateTime%29" ignore_empty="1" encoding="Automatic" quote="0" simplify="1"/>
    </inputs>
    <transforms>
        <transform id="50" name="Javascript" pos="149.4^194.4" pos_v12="149.4194.4">
            <parameters>
                <parameter type="7" name="New_Name" value="Hours"/>
                <parameter type="6" name="Type_As" value="Number%2FBoolean%2FString"/>
                <parameter type="12" name="Script" value="const%20list%20%3D%20%5B%5D%3B%0Alet%20sum%20%3D%200%3B%0Alet%20number%20%3D%20%24%28Hours%29%0Awhile%20%28sum%20%3C%20number%29%20%7B%0Aconst%20nextValue%20%3D%20Math.min%28100%2C%20number%20-%20sum%29%3B%0Alist.push%28nextValue.toString%28%29%29%3B%0Asum%20%2B%3D%20nextValue%3B%0A%7D%0A%0Areturn%20list.join%28%27%2C%27%29%3B"/>
            </parameters>
        </transform>
        <transform id="51" name="Split" pos="388.8^194.4" pos_v12="388.8194.4">
            <parameters>
                <parameter type="0" name="Columns" value="3"/>
                <parameter type="6" name="Delimiter_Type" value="Text%20delimiter"/>
                <parameter type="7" name="Delimiter" value="%2C"/>
                <parameter type="7" name="Lengths" value="2%2C1%2C%2A"/>
                <parameter type="6" name="Into" value="Rows"/>
                <parameter type="6" name="Order" value="Current"/>
                <parameter type="5" name="Keep_Empty" value="0"/>
                <parameter type="8" name="Min_New_Cols" value="0"/>
                <parameter type="8" name="Max_New_Cols" value="100"/>
            </parameters>
        </transform>
        <transform id="56" name="New_Col" pos="-90^314.1" pos_v12="-90314.1">
            <parameters>
                <parameter type="7" name="New_Name" value="Count"/>
                <parameter type="7" name="New_Value" value="1"/>
            </parameters>
        </transform>
        <transform id="57" name="Total" pos="149.4^314.1" pos_v12="149.4314.1">
            <parameters>
                <parameter type="5" name="Auto_New_Name" value="0"/>
                <parameter type="7" name="New_Name" value="Batch%20Name"/>
                <parameter type="0" name="Column" value="4"/>
                <parameter type="0" name="By" value="1"/>
            </parameters>
        </transform>
        <transform id="58" name="Replace_Multi" pos="388.8^314.1" pos_v12="388.8314.1">
            <parameters>
                <parameter type="1" name="Columns" value="5"/>
                <parameter type="16" name="Replace" value="0%24%28Batch%20Name%29B-%24%28Batch%20Name%29"/>
                <parameter type="5" name="Case_Sensitive" value="0"/>
            </parameters>
        </transform>
        <transform id="59" name="Remove" pos="-90^433.8" pos_v12="-90433.8">
            <parameters>
                <parameter type="11" name="Columns" value="135"/>
            </parameters>
        </transform>
        <transform id="60" name="Reorder" pos="149.4^433.8" pos_v12="149.4433.8">
            <parameters>
                <parameter type="4" name="Columns" value="132"/>
            </parameters>
        </transform>
        <transform id="62" name="Javascript" pos="149.4^673.2" pos_v12="149.4673.2">
            <parameters>
                <parameter type="7" name="New_Name" value="Batch%20Name"/>
                <parameter type="6" name="Type_As" value="Number%2FBoolean%2FString"/>
                <parameter type="12" name="Script" value="const%20list%20%3D%20%5B%5D%3B%0Alet%20sum%20%3D%200%3B%0Alet%20batch%20%3D%201%3B%0Alet%20number%20%3D%20%24%28Hours%29%0Awhile%20%28sum%20%3C%20number%29%20%7B%0Aconst%20nextValue%20%3D%20Math.min%28100%2C%20number%20-%20sum%29%3B%0Alist.push%28%27B-%27%2Bbatch.toString%28%29%2B%27%7C%27%2BnextValue.toString%28%29%29%3B%0Asum%20%2B%3D%20nextValue%3B%0Abatch%2B%2B%3B%0A%0A%7D%0A%0Areturn%20list.join%28%27%2C%27%29%3B%0A"/>
            </parameters>
        </transform>
        <transform id="63" name="Split" pos="388.8^673.2" pos_v12="388.8673.2">
            <parameters>
                <parameter type="0" name="Columns" value="3"/>
                <parameter type="6" name="Delimiter_Type" value="Text%20delimiter"/>
                <parameter type="7" name="Delimiter" value="%2C"/>
                <parameter type="7" name="Lengths" value="2%2C1%2C%2A"/>
                <parameter type="6" name="Into" value="Rows"/>
                <parameter type="6" name="Order" value="Current"/>
                <parameter type="5" name="Keep_Empty" value="0"/>
                <parameter type="8" name="Min_New_Cols" value="0"/>
                <parameter type="8" name="Max_New_Cols" value="100"/>
            </parameters>
        </transform>
        <transform id="64" name="Split" pos="-90^792.9" pos_v12="-90792.9">
            <parameters>
                <parameter type="0" name="Columns" value="3"/>
                <parameter type="6" name="Delimiter_Type" value="Text%20delimiter"/>
                <parameter type="7" name="Delimiter" value="%7C"/>
                <parameter type="7" name="Lengths" value="2%2C1%2C%2A"/>
                <parameter type="6" name="Into" value="Columns"/>
                <parameter type="6" name="Order" value="Current"/>
                <parameter type="5" name="Keep_Empty" value="0"/>
                <parameter type="8" name="Min_New_Cols" value="0"/>
                <parameter type="8" name="Max_New_Cols" value="100"/>
            </parameters>
        </transform>
        <transform id="65" name="Remove" pos="149.4^792.9" pos_v12="149.4792.9">
            <parameters>
                <parameter type="11" name="Columns" value="145"/>
            </parameters>
        </transform>
        <transform id="66" name="Rename_Cols" pos="388.8^792.9" pos_v12="388.8792.9">
            <parameters>
                <parameter type="13" name="RenameColumns" value="%2ANORENAME%2ABatch%20NameHours"/>
            </parameters>
        </transform>
    </transforms>
    <outputs/>
    <notes/>
    <connections>
        <connection start_id="48" end_id="50"/>
        <connection start_id="50" end_id="51"/>
        <connection start_id="51" end_id="56"/>
        <connection start_id="56" end_id="57"/>
        <connection start_id="57" end_id="58"/>
        <connection start_id="58" end_id="59"/>
        <connection start_id="59" end_id="60"/>
        <connection start_id="61" end_id="62"/>
        <connection start_id="62" end_id="63"/>
        <connection start_id="63" end_id="64"/>
        <connection start_id="64" end_id="65"/>
        <connection start_id="65" end_id="66"/>
    </connections>
    <batch_values/>
    <batch_logging enabled="0" mode="0"/>
</root>
