<!DOCTYPE EasyDataTransform>
<root>
    <meta>
        <version value="83"/>
        <last_saved_by value="Olaf_W%C3%BCllenrath_using_Easy_Data_Transform_v2_11_0_on_macOS_26_3_arm64_at_2026_02_20_12_28_03"/>
        <locale value="en_GB"/>
        <id value="7e760509357007000b777a743c09"/>
        <snap_to_grid value="1"/>
        <notes/>
        <doc_path value="%2FUsers%2Folaf%2Ftmp%2Fbalance-correction%202.transform"/>
        <auto_run_on value="1"/>
    </meta>
    <inputs>
        <input pos="-329.4^314.1" 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="-329.4314.1" 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="499" custom_delimiter="%2A" ignore_repeated_delim="0" text="Account%20number%09Balance%20Month%201%09Balance%20Month%202%09Balance%20Month%203%09Balance%20Month%204%09Balance%20Month%205%09Balance%20Month%206%09Balance%20Month%207%09Balance%20Month%208%0D%0A2436%097664.22%098430.64%099273.7%0910201.07%0911221.18%0912343.3%0913577.63%0914935.39%0D%0A5420%092635.14%092898.65%093188.52%093507.37%093858.11%094243.92%094668.31%095135.14%0D%0A4756%098750.33%099625.36%0910587.9%0911646.69%0912811.36%0914092.5%0915501.75%0917051.93%0D%0A7899%098161.13%098977.24%099874.96%0910862.46%0911948.71%0913143.58%0914457.94%0915903.73%0D%0A2600%096791.75%097470.93%098218.02%099039.82%099943.8%0910938.18%0912032.0%0913235.2%0D%0A2951%099766.82%0910743.5%0911817.85%0912999.64%0914299.6%0915729.56%0917302.52%0919032.77%0D%0A1594%098354.5%099189.95%0910108.95%0911119.85%0912231.84%0913455.02%0914800.52%0916280.57%0D%0A2226%092042.16%092246.38%092471.02%092718.12%092989.93%093288.92%093617.81%093979.59%0D%0A2666%094478.54%094926.39%095419.03%095960.93%096557.02%097212.72%097933.99%098727.39%0D%0A6976%094193.36%094612.7%095073.97%095581.37%096139.51%096753.46%097428.81%098171.69%0D%0A8641%091491.34%091640.47%091804.52%091984.97%092183.47%092401.82%092642.0%092906.2%0D%0A4752%095753.44%096328.78%096961.66%097657.83%098423.61%099265.97%0910192.57%0911211.83%0D%0A1711%095920.01%096512.01%097163.21%097879.53%098667.48%099534.23%0910487.65%0911536.42%0D%0A1359%096585.77%097244.35%097968.79%098765.67%099642.24%0910606.46%0911667.11%0912833.82%0D%0A5505%091258.25%091384.08%091522.49%091674.74%091842.21%092026.43%092229.07%092451.98%0D%0A2741%09578.42%09636.26%09699.89%09769.88%09846.87%09931.56%091024.72%091127.19%0D%0A1863%097680.21%098448.23%099293.05%0910222.36%0911244.6%0912369.06%0913605.97%0914966.57%0D%0A3864%09917.23%091008.95%091109.85%091220.84%091342.92%091477.21%091624.93%091787.42%0D%0A8581%095659.21%096225.13%096847.64%097532.4%098285.64%099114.2%0910025.62%0911028.18%0D%0A6042%095687.82%096256.6%096882.26%097570.49%098327.54%099160.29%0910076.32%0911083.95" meta_text="%24%28CurrentDateTime%29" ignore_excel_hidden_rows="0" ignore_empty="0" encoding="Automatic" quote="1" simplify="1"/>
    </inputs>
    <transforms>
        <transform id="495" name="If" pos="149.4^314.1" pos_v12="149.4314.1">
            <parameters>
                <parameter type="7" name="New_Name" value="Sign%20correction"/>
                <parameter type="10" name="If" value="*StartIf*154000*EndIf*-1%2B1"/>
                <parameter type="5" name="Case_Sensitive" value="1"/>
            </parameters>
        </transform>
        <transform id="500" name="Calculate" pos="388.8^314.1" pos_v12="388.8314.1">
            <parameters>
                <parameter type="5" name="Auto_New_Name" value="0"/>
                <parameter type="7" name="New_Name" value="Corrected%20balance"/>
                <parameter type="6" name="Operation" value="%2A%20Multiply"/>
                <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="4"/>
                <parameter type="7" name="Constant2" value=""/>
            </parameters>
        </transform>
        <transform id="501" name="Gather" pos="-90^314.1" pos_v12="-90314.1">
            <parameters>
                <parameter type="1" name="Columns" value="23456789"/>
                <parameter type="7" name="Key_Column" value="Month"/>
                <parameter type="7" name="Value_Column" value="Balance"/>
            </parameters>
        </transform>
        <transform id="502" name="Spread" pos="867.6^314.1" pos_v12="867.6314.1">
            <parameters>
                <parameter type="0" name="Key_Column" value="2"/>
                <parameter type="0" name="Value_Column" value="3"/>
                <parameter type="7" name="Missing_Value" value=""/>
                <parameter type="8" name="Min_New_Cols" value="0"/>
                <parameter type="8" name="Max_New_Cols" value="100"/>
            </parameters>
        </transform>
        <transform id="503" name="Remove" pos="628.2^314.1" pos_v12="628.2314.1">
            <parameters>
                <parameter type="11" name="Columns" value="125"/>
            </parameters>
        </transform>
    </transforms>
    <outputs/>
    <charts/>
    <notes/>
    <connections>
        <connection start_id="495" end_id="500"/>
        <connection start_id="499" end_id="501"/>
        <connection start_id="500" end_id="503"/>
        <connection start_id="501" end_id="495"/>
        <connection start_id="503" end_id="502"/>
    </connections>
    <batch_values>
        <batch_value value="C%3A%5CUsers%5Candy%5CDesktop%5Cchart-batch%5Cout%5Coutput.csv" row="0" alias="output"/>
        <batch_value value="C%3A%5CUsers%5Candy%5CDesktop%5Cchart-batch%5Ci%2A.csv" row="0" alias="i1"/>
        <batch_value value="C%3A%5CUsers%5Candy%5CDesktop%5C%3A%3Aoutput1_%7Bi1%7D.csv" row="0" alias="output1"/>
        <batch_value value="C%3A%5CUsers%5Candy%5CDesktop%5Cchart-batch%5C%3A%3Aoutputx.csv" row="0" alias="output2"/>
        <batch_value value="C%3A%5CUsers%5Candy%5CDesktop%5Cchart-batch%5Cchart_%7Bi1%7D.png" row="0" alias="xxy"/>
        <batch_value value="C%3A%5CUsers%5Candy%5CDesktop%5Coutput2_%7Bi1%7D.csv" row="0" alias="xxsdadsa"/>
        <batch_value value="C%3A%5CUsers%5Candy%5CDesktop%5Cchart-batch%5Cout%5Coutput1.csv" row="0" alias="output12"/>
        <batch_value value="C%3A%5CUsers%5Candy%5CDesktop%5Cchart-batch%5Coutput1.html%5BEasy%20Data%20Transform%5D" row="0" alias="output13"/>
        <batch_value value="C%3A%5CUsers%5Candy%5CDesktop%5Cchart-batch%5Coutput1.xlsx%5B%3A%3AEasy%20Data%20Transform%5D" row="0" alias="output14"/>
        <batch_value value="C%3A%5CUsers%5Candy%5CDesktop%5Cchart-batch%5Cout%5Cchart4_%7Bi1%7D.png" row="0" alias="xx"/>
    </batch_values>
    <batch_logging path="C%3A%5CUsers%5Candy%5CDesktop%5Cchart-batch%5Ccb_log_%7Bdatetime%7D.txt" enabled="0" verbose="1" mode="0"/>
</root>
