<!DOCTYPE EasyDataTransform>
<root>
    <meta>
        <version value="77"/>
        <last_saved_by value="David_Vaughan_using_Easy_Data_Transform_v2_5_1_on_macOS_15_5_arm64_at_2025_05_25_16_50_35"/>
        <locale value="en_AU"/>
        <id value="7c77050c357307070b747a740d0a3c"/>
        <snap_to_grid value="1"/>
        <notes/>
        <doc_path value="%2FUsers%2Fdavid%2FDocuments%2FEDT%20transforms%2FRandom%20web%2FBooks.transform"/>
        <auto_run_on value="1"/>
    </meta>
    <inputs>
        <input pos="-90^-45" 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="-90-45" watching="0" medium="1" auto_fixed_widths="1" comment="Data.%20Use%20File%20input" 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="0" custom_delimiter="%2A" ignore_repeated_delim="0" text="publisher_number%09publisher_name%09isbn%09sku%09parent_isbn%09title%09NULL%20DOES%20NOT%20EXIST%09NULL%20DOES%20NOT%20EXIST%09NULL%20DOES%20NOT%20EXIST%09NULL%20DOES%20NOT%20EXIST%09NULL%20DOES%20NOT%20EXIST%09NULL%20DOES%20NOT%20EXIST%09author%09page_count%09binding_type%09book_type_id%09list_price%09wholesale_discount_%25%09PTD_Quantity%09PTD_avg_list_price%09NULL%20DOES%20NOT%20EXIST%09NULL%20DOES%20NOT%20EXIST%09NULL%20DOES%20NOT%20EXIST%09NULL%20DOES%20NOT%20EXIST%09NULL%20DOES%20NOT%20EXIST%09NULL%20DOES%20NOT%20EXIST%09NULL%20DOES%20NOT%20EXIST%09NULL%20DOES%20NOT%20EXIST%09NULL%20DOES%20NOT%20EXIST%09NULL%20DOES%20NOT%20EXIST%09NULL%20DOES%20NOT%20EXIST%09NULL%20DOES%20NOT%20EXIST%09NULL%20DOES%20NOT%20EXIST%09NULL%20DOES%20NOT%20EXIST%09PTD_extended_list%09PTD_avg_discount_%25%09PTD_extended_discount%09PTD_avg_wholesale_price%09PTD_extended_wholesale%09PTD_avg_print_charge%09PTD_extended_print_charge%09PTD_gross_pub_comp%09PTD_extended_adjustments%09PTD_extended_recovery%09PTD_pub_comp%09NULL%20DOES%20NOT%20EXIST%09NULL%20DOES%20NOT%20EXIST%09YTD_quantity%09YTD_avg_list_price%09YTD_extended_list_price%09YTD_avg_discount_%25%09YTD_extended_discount%09YTD_avg_wholesale_price%09YTD_extended_wholesale%09YTD_avg_print_charge%09YTD_extended_print_charge%09YTD_gross_pub_comp%09YTD_extended_adjustments%09YTD_extended_recovery%09YTD_pub_comp%09deferral_balance%09reporting_currency_code%09period_name%09original_deferral_amount%09PTD_return_quantity%09PTD_return_wholesale%09PTD_return_charge%09PTD_return_total%09YTD_return_quantity%09YTD_return_wholesale%09YTD_return_charge%09YTD_return_total%09PTD_net_quantity%09PTD_net_wholesale%09PTD_net_pub_comp%09YTD_net_quantity%09YTD_net_wholesale%09YTD_net_pub_comp%09returns_flag_value%09nonreturnable_date%09title_status_flag_value%09cancelled_date%09publisher_imprint%09customer_flexfield1%09customer_flexfield2%09customer_flexfield3%09customer_flexfield4%09customer_flexfield5%09isbn_13%09PTD_wholesale_tax%09PTD_print_charge_tax%09PTD_return_wholesale_tax%09PTD_return_charge_tax%09YTD_wholesale_tax%09YTD_print_charge_tax%09YTD_return_wholesale_tax%09YTD_return_charge_tax%09market%09sales_category%09Ptd_global_distribution_fee%0AIgnore%09Ignore%09Ignore%09Ignore%091-56091-526-9%09Race%20car%20vehicle%20dynamics%09Sales%20Source%09No%09Regular%09Order%20Number%09Invoice%20Number%09Retailer%09Ignore%09Ignore%09Perfectbound%20%28Trade%20Paper%09Ignore%09Ignore%09Ignore%092%09Average%20List%20Price%20and%20Unit%20Price%20Local%20Curreny%09Was%20a%20Return%3F%09Discount%20Given%09Currency%20Code%09Exchange%20Rate%09Unit%20Offer%20Price%20Local%20Currency%09198%090%0999%09200%09Unit%20Offer%20Price%20USD%09Total%20Sale%20USD%20Before%20Discount%09Discount%20Amount%20Per%20Unit%20USD%09Unit%20Offer%20Price%20After%20Discount%20USD%09Total%20Sale%20After%20Discount%20USD%09Ignore%09Ignore%09Ignore%09Ignore%09Ignore%09Ignore%09Print%20Manufacturing%20and%20Delivery%20Charge%09Ignore%09Ignore%09Ignore%09Total%20Royalty%20Local%20Currency%09Total%20Royalty%20Amount%20USD%09Notes%09Ignore%09Ignore%09Ignore%09Ignore%09Ignore%09Ignore%09Ignore%09Ignore%09Ignore%09Ignore%09Ignore%09Ignore%09Ignore%09Ignore%09Ignore%09Ignore%09Ignore%09Qty%20Returned%09Ignore%09Ignore%09Total%20Royalty%20Amount%20USD%09Ignore%09Ignore%09Ignore%09Ignore%09Ignore%09Ignore%09Ignore%09Ignore%09Ignore%09Ignore%09Ignore%09Ignore%09Ignore%09Ignore%09Ignore%09Ignore%09Ignore%09Ignore%09Ignore%09Ignore%09Ignore%09Ignore%09Ignore%09Ignore%09Ignore%09Ignore%09Ignore%09Ignore%09Ignore%09Marketplace%09Ignore%09ignore" meta_text="%24%28CurrentDateTime%29" ignore_excel_hidden_rows="0" ignore_empty="1" encoding="Automatic" quote="0" simplify="1"/>
        <input pos="-90^194.4" 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="-90194.4" watching="0" medium="1" auto_fixed_widths="1" comment="Currency%20table%20on%20clipboard%20or%20from%20file%0A" 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="4" custom_delimiter="%2A" ignore_repeated_delim="0" text="Code%09USD%20rate%0AAUD%090.65%0AGBP%091.35%0AUSD%091.00" meta_text="%24%28CurrentDateTime%29" ignore_excel_hidden_rows="0" ignore_empty="1" encoding="Automatic" quote="0" simplify="1"/>
    </inputs>
    <transforms>
        <transform id="1" name="Remove" pos="149.4^-45" comment="Remove%20the%20dross" pos_v12="149.4-45">
            <parameters>
                <parameter type="11" name="Columns" value="56789101112151920212223242526272829303132333441454647656898"/>
            </parameters>
        </transform>
        <transform id="2" name="Rename_Cols" pos="-90^74.7" comment="Name%20usefully" pos_v12="-9074.7">
            <parameters>
                <parameter type="13" name="RenameColumns" value="%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2AOrder%20noInvoice%20noRetailer%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A%2ANORENAME%2A"/>
            </parameters>
        </transform>
        <transform id="3" name="Replace_Multi" pos="149.4^74.7" comment="Fix%20binding%20type" pos_v12="149.474.7">
            <parameters>
                <parameter type="1" name="Columns" value="9"/>
                <parameter type="16" name="Replace" value="2Perfect.%2APaperback2.%2ALaminate.%2AHardcover2.%2ACloth.%2AHardcover"/>
                <parameter type="5" name="Case_Sensitive" value="1"/>
            </parameters>
        </transform>
        <transform id="5" name="Lookup" pos="149.4^194.4" comment="Get%20currency%20rate" pos_v12="149.4194.4">
            <parameters>
                <parameter type="5" name="Auto_New_Name" value="1"/>
                <parameter type="7" name="New_Name" value="Lookup"/>
                <parameter type="0" name="Top_Lookup_Column" value="14"/>
                <parameter type="0" name="Bottom_Lookup_Column" value="1"/>
                <parameter type="0" name="Bottom_Value_Column" value="2"/>
                <parameter type="6" name="Match_Type" value="Exact"/>
                <parameter type="8" name="Fuzziness" value="80"/>
                <parameter type="6" name="Bottom_Values_Used" value="First"/>
                <parameter type="6" name="Fuzzy_Bottom_Values_Used" value="First%20best"/>
                <parameter type="7" name="Delim" value="%2C"/>
                <parameter type="6" name="If_No_Match" value="Use%20no%20match%20value"/>
                <parameter type="7" name="Non_Matching_Value" value=""/>
                <parameter type="5" name="Case_Sensitive" value="1"/>
            </parameters>
        </transform>
        <transform id="6" name="Calculate" pos="-90^314.1" comment="Convert%20currency" pos_v12="-90314.1">
            <parameters>
                <parameter type="5" name="Auto_New_Name" value="0"/>
                <parameter type="7" name="New_Name" value="USD"/>
                <parameter type="6" name="Operation" value="%2A%20Multiply"/>
                <parameter type="6" name="Type1" value="Column"/>
                <parameter type="0" name="Column1" value="11"/>
                <parameter type="7" name="Constant1" value=""/>
                <parameter type="6" name="Type2" value="Column"/>
                <parameter type="0" name="Column2" value="33"/>
                <parameter type="7" name="Constant2" value=""/>
            </parameters>
        </transform>
        <transform id="7" name="Calculate" pos="149.4^314.1" comment="Do%20more%20calcs%20as%20required" pos_v12="149.4314.1">
            <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="6" name="Type1" value="Column"/>
                <parameter type="0" name="Column1" value="0"/>
                <parameter type="7" name="Constant1" value=""/>
                <parameter type="6" name="Type2" value="Column"/>
                <parameter type="0" name="Column2" value="0"/>
                <parameter type="7" name="Constant2" value=""/>
            </parameters>
        </transform>
    </transforms>
    <outputs/>
    <notes/>
    <connections>
        <connection start_id="0" end_id="1"/>
        <connection start_id="1" end_id="2"/>
        <connection start_id="2" end_id="3"/>
        <connection start_id="3" end_id="5"/>
        <connection start_id="4" end_id="5"/>
        <connection start_id="5" end_id="6"/>
        <connection start_id="6" end_id="7"/>
    </connections>
    <batch_values/>
    <batch_logging enabled="0" mode="0"/>
</root>
