<!DOCTYPE EasyDataTransform>
<root>
    <meta>
        <version value="70"/>
        <last_saved_by value="Olaf_W%C3%BCllenrath_using_Easy_Data_Transform_v1_46_4_on_macOS_14_2_at_2024_02_11_19_21_20"/>
        <locale value="de_DE"/>
        <id value="7d030508327007030b7576010c0b3808"/>
        <snap_to_grid value="1"/>
        <notes/>
        <doc_path value="%2FUsers%2Folaf%2FDesktop%2FNTP%20Time%20tranform.transform"/>
        <auto_run_on value="1"/>
    </meta>
    <inputs>
        <input pos="388.8^-882.9" ignored_rows="0" show_meta="0" json_arrays_as_rows="0" delimiter="0" name="Clipboard" pos_v12="388.8-882.9" watching="0" medium="1" ignore_excel_hidden="0" auto_fixed_widths="1" header="1" ignore_empty_cols="0" trim="1" file_type="0" id="69" custom_delimiter="%2A" ignore_repeated_delim="0" text="Day%2CSeconds%0A60006%2C%22136%2C250%22%0A60006%2C%22167%2C716%22%0A60006%2C%22174%2C239%22%0A60006%2C%22758%2C237%22%0A60006%2C%221158%2C250%22%0A60006%2C%221251%2C245%22%0A60006%2C%221360%2C250%22%0A60006%2C%222222%2C250%22%0A60006%2C%222279%2C717%22%0A60006%2C%222295%2C250%22%0A60006%2C%222332%2C237%22%0A60006%2C%222436%2C250%22%0A60006%2C%222883%2C239%22%0A60006%2C%223328%2C716%22%0A60006%2C%223369%2C252%22%0A60006%2C%223475%2C250%22%0A60006%2C%224332%2C252%22%0A60006%2C%224412%2C718%22%0A60006%2C%224439%2C238%22%0A60006%2C%224989%2C239%22%0A60006%2C%225377%2C253%22%0A60006%2C%225449%2C250%22%0A60006%2C%225483%2C238%22%0A60006%2C%225605%2C256%22%0A60006%2C%226038%2C238%22%0A60006%2C%226513%2C255%22%0A60006%2C%226575%2C720%22%0A60006%2C%227484%2C250%22%0A60006%2C%227563%2C251%22%0A60006%2C%227582%2C240%22%0A60006%2C%227706%2C251%22%0A60006%2C%228174%2C239%22%0A60006%2C%228560%2C250%22%0A60006%2C%228666%2C240%22%0A60006%2C%228702%2C718%22%0A60006%2C%228760%2C252%22%0A60006%2C%229210%2C239%22%0A60006%2C%229621%2C251%22%0A60006%2C%229705%2C250%22%0A60006%2C%229709%2C238%22%0A60006%2C%229797%2C254%22%0A60006%2C%2210669%2C253%22%0A60006%2C%2210855%2C716%22%0A60006%2C%2211269%2C237%22%0A60006%2C%2211741%2C250%22%0A60006%2C%2211833%2C238%22%0A60006%2C%2211833%2C250%22%0A60006%2C%2211893%2C253%22%0A60006%2C%2211935%2C717%22%0A60006%2C%2212859%2C252%22%0A60006%2C%2212964%2C716%22%0A60006%2C%2212965%2C250%22%0A60006%2C%2213393%2C237%22%0A60006%2C%2213879%2C250%22%0A60006%2C%2213932%2C252%22%0A60006%2C%2213951%2C237%22%0A60006%2C%2214033%2C251%22%0A60006%2C%2214431%2C240%22%0A60006%2C%2215066%2C719%22%0A60006%2C%2215095%2C251%22%0A60006%2C%2215966%2C251%22%0A60006%2C%2215999%2C250%22%0A60006%2C%2216047%2C239%22%0A60006%2C%2216560%2C239%22%0A60006%2C%2217008%2C250%22%0A60006%2C%2217189%2C250%22%0A60006%2C%2217193%2C719%22%0A60006%2C%2217614%2C237%22%0A60006%2C%2218124%2C250%22%0A60006%2C%2218146%2C238%22%0A60006%2C%2218262%2C716%22%0A60006%2C%2218676%2C237%22%0A60006%2C%2219171%2C255%22%0A60006%2C%2219221%2C238%22%0A60006%2C%2219292%2C250%22%0A60006%2C%2219718%2C239%22%0A60006%2C%2220226%2C252%22%0A60006%2C%2220230%2C250%22%0A60006%2C%2220307%2C239%22%0A60006%2C%2220372%2C250%22%0A60006%2C%2220415%2C717%22%0A60006%2C%2220801%2C238%22%0A60006%2C%2221436%2C250%22%0A60006%2C%2221484%2C717%22%0A60006%2C%2222340%2C251%22%0A60006%2C%2222365%2C250%22%0A60006%2C%2222451%2C238%22%0A60006%2C%2222471%2C250%22%0A60006%2C%2222951%2C237%22%0A60006%2C%2223376%2C251%22%0A60006%2C%2223429%2C250%22%0A60006%2C%2223477%2C241%22%0A60006%2C%2223581%2C718%22%0A60006%2C%2223982%2C241%22%0A60006%2C%2224539%2C256%22%0A60006%2C%2225059%2C239%22%0A60006%2C%2225437%2C251%22%0A60006%2C%2225554%2C251%22%0A60006%2C%2225563%2C251%22%0A60006%2C%2225569%2C238%22%0A60006%2C%2225694%2C716%22%0A60006%2C%2226498%2C250%22%0A60006%2C%2226595%2C238%22%0A60006%2C%2226647%2C252%22%0A60309%2C%221180%2C220%22%0A60309%2C%221938%2C305%22%0A60309%2C%222892%2C231%22%0A60309%2C%223968%2C229%22%0A60309%2C%226103%2C231%22%0A60309%2C%226876%2C221%22%0A60309%2C%227753%2C241%22%0A60309%2C%228412%2C218%22%0A60309%2C%2210264%2C230%22%0A60309%2C%2212252%2C222%22%0A60309%2C%2213020%2C224%22%0A60309%2C%2213055%2C234%22%0A60309%2C%2213212%2C221%22%0A60309%2C%2213700%2C228%22%0A60309%2C%2213832%2C229%22%0A60309%2C%2214232%2C228%22%0A60309%2C%2214363%2C229%22%0A60309%2C%2215388%2C219%22%0A60309%2C%2215415%2C228%22%0A60309%2C%2215811%2C228%22%0A60309%2C%2216570%2C243%22%0A60309%2C%2217372%2C219%22%0A60309%2C%2218012%2C221%22%0A60309%2C%2218075%2C241%22%0A60309%2C%2218172%2C228%22%0A60309%2C%2219228%2C222%22%0A60309%2C%2220380%2C222%22%0A60309%2C%2220834%2C302%22%0A60309%2C%2221276%2C218%22%0A60309%2C%2221788%2C220%22%0A60309%2C%2222380%2C233%22%0A60309%2C%2223418%2C240%22%0A60309%2C%2223691%2C232%22%0A60309%2C%2223952%2C233%22%0A60309%2C%2224085%2C231%22%0A60309%2C%2224735%2C229%22%0A60309%2C%2225436%2C223%22%0A60309%2C%2226034%2C232%22%0A60309%2C%2226460%2C219%22%0A60309%2C%2227401%2C235%22%0A60309%2C%2228380%2C220%22%0A60309%2C%2228700%2C219%22%0A60309%2C%2229980%2C220%22%0A60309%2C%2231132%2C221%22%0A60309%2C%2231885%2C228%22%0A60309%2C%2232412%2C223%22%0A60309%2C%2232668%2C218%22%0A60309%2C%2234140%2C223%22%0A60309%2C%2234500%2C232%22%0A60309%2C%2235996%2C218%22%0A60309%2C%2236700%2C218%22%0A60309%2C%2238044%2C221%22%0A60309%2C%2238693%2C232%22%0A60309%2C%2238876%2C218%22%0A60309%2C%2239802%2C234%22%0A60309%2C%2240857%2C228%22%0A60309%2C%2242140%2C222%22%0A60309%2C%2243036%2C218%22%0A60309%2C%2244764%2C218%22%0A60309%2C%2245020%2C218%22%0A60309%2C%2245340%2C218%22%0A60309%2C%2245916%2C218%22%0A60309%2C%2246695%2C229%22%0A60309%2C%2246963%2C231%22%0A60309%2C%2248550%2C242%22%0A60309%2C%2248576%2C241%22%0A60309%2C%2249485%2C229%22%0A60309%2C%2251100%2C220%22%0A60309%2C%2251427%2C230%22%0A60309%2C%2252996%2C235%22%0A60309%2C%2253852%2C218%22%0A60309%2C%2254156%2C241%22" meta_text="%24%28CurrentDateTime%29" ignore_empty="1" encoding="Automatic" quote="0" simplify="1"/>
    </inputs>
    <transforms>
        <transform id="9" name="Calculate" pos="628.2^-882.9" comment="Caculate%20Day%20to%20Unix%20format%20at%2001%3A00" pos_v12="628.2-882.9">
            <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="0" name="Column1" value="1"/>
                <parameter type="6" name="Type2" value="Constant"/>
                <parameter type="0" name="Column2" value="0"/>
                <parameter type="7" name="Constant2" value="86400000"/>
            </parameters>
        </transform>
        <transform id="10" name="Calculate" pos="867.6^-882.9" pos_v12="867.6-882.9">
            <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="0" name="Column1" value="3"/>
                <parameter type="6" name="Type2" value="Constant"/>
                <parameter type="0" name="Column2" value="0"/>
                <parameter type="7" name="Constant2" value="3506720400000"/>
            </parameters>
        </transform>
        <transform id="11" name="Calculate" pos="1107^-882.9" comment="Seconds%20to%20Msec" pos_v12="1107-882.9">
            <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="0" name="Column1" value="2"/>
                <parameter type="6" name="Type2" value="Constant"/>
                <parameter type="0" name="Column2" value="0"/>
                <parameter type="7" name="Constant2" value="1000"/>
            </parameters>
        </transform>
        <transform id="12" name="Calculate" pos="1346.4^-882.9" pos_v12="1346.4-882.9">
            <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="0" name="Column1" value="5"/>
                <parameter type="6" name="Type2" value="Column"/>
                <parameter type="0" name="Column2" value="4"/>
                <parameter type="7" name="Constant2" value=""/>
            </parameters>
        </transform>
        <transform id="13" name="Calculate" pos="1585.8^-882.9" pos_v12="1585.8-882.9">
            <parameters>
                <parameter type="5" name="Auto_New_Name" value="1"/>
                <parameter type="7" name="New_Name" value="Calculate"/>
                <parameter type="6" name="Operation" value="MSecsToDateTime"/>
                <parameter type="0" name="Column1" value="6"/>
                <parameter type="6" name="Type2" value="Column"/>
                <parameter type="0" name="Column2" value="0"/>
                <parameter type="7" name="Constant2" value=""/>
            </parameters>
        </transform>
        <transform id="14" name="Rename_Cols" pos="1825.2^-882.9" pos_v12="1825.2-882.9">
            <parameters>
                <parameter type="13" name="RenameColumns" value="%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2ADate_time"/>
            </parameters>
        </transform>
        <transform id="15" name="Remove" pos="2064.6^-882.9" pos_v12="2064.6-882.9">
            <parameters>
                <parameter type="11" name="Columns" value="127"/>
            </parameters>
        </transform>
    </transforms>
    <outputs/>
    <notes>
        <note id="17" comment="Unix%20basis%20at%2001%3A00%0A" pos_v12="628.2-1002.6" color="255%1F255%1F255" arrow="3"/>
        <note id="18" comment="Normalise%20date%20to%20the%20count" pos_v12="867.6-1002.6" color="255%1F255%1F255" arrow="3"/>
        <note id="19" comment="Seconds%20to%20Msec" pos_v12="1107-1002.6" color="255%1F255%1F255" arrow="3"/>
        <note id="20" comment="Add%20Date%20Msec%20%2B%20Time%20MSec" pos_v12="1346.4-1002.6" color="255%1F255%1F255" arrow="3"/>
        <note id="21" comment="Get%20Date_time%20out%20of%20Unix%20format" pos_v12="1585.8-1002.6" color="255%1F255%1F255" arrow="3"/>
    </notes>
    <connections>
        <connection start_id="9" end_id="10"/>
        <connection start_id="10" end_id="11"/>
        <connection start_id="11" end_id="12"/>
        <connection start_id="12" end_id="13"/>
        <connection start_id="13" end_id="14"/>
        <connection start_id="14" end_id="15"/>
        <connection start_id="69" end_id="9"/>
    </connections>
    <batch_values>
        <batch_value value="%2FUsers%2Folaf%2Ferwecon%2FTKG_63%2FGutachten%2FEntega%2F2023%2FNTP-Files21112023%2FCirPack_G4_R101_OF%2FMGC_OF%2Floopstat%2A" row="0" alias="loopstats"/>
        <batch_value value="%2FUsers%2Folaf%2Ferwecon%2FTKG_63%2FGutachten%2FEntega%2F2023%2FNTP-Files21112023%2FCirPack_G4_R101_OF%2FMGC_OF%2Floopstat_combined.tsv" row="0" alias="BHXDSI5"/>
    </batch_values>
    <batch_logging path="%2FUsers%2Folaf%2Ferwecon%2FTKG_63%2FGutachten%2FColt%2F2022%2FNetzwerk%2Fntpstats%2FLoopstats_Reformat%20Colt%202022_log_%7Bdatetime%7D.txt" enabled="0" mode="0"/>
</root>
