Table of Contents

AA_Filter CSV

This functions gives comma separated values containing amounts of opposite sign which can be probably used for calculating knock off suggestions. The function consists of 3 parameters:
  • Available Amount Range: User has to select the range based on “Amount” column.
  • Current Amount: User has to select the amount against which the comma separated values have to be generated
  • Set limit: The user can set limit to number of comma separated values that shall be displayed in the final result. If set limit is not provided, default is 100.
    • Possible outcomes
      • no_values: No suitable amounts found for calculating knockoff
      • Normal Result – Comma Separated values: amount 1,amount 2,amount 3

AA_Knockoff

This function generates various possible combinations, the aggregate of which matches the targeted amount selected by the user. This function consists of 5 parameters:
  • Target: User has to select the target amount against which possible combinations are required.
  • available_amt_array: User has to write AA_Filter_CSV function
  • limit_results_num: User can restrict the number of possible combinations that shall be fetched by the function. If the maximum limit is not provided, default is 4.
  • available_amt_rng_limit: User can restrict the number of comma separated values that shall be considered by the function for suggesting possible combination. If the maximum limit is not provided, default is 100.
  • timeout_secs: This allows user to restrict the processing time taken to calculate the final result. If the maximum second is not provided, default is 10.
  • Possible outcomes
  1. None: No combinations possible
  2. Timeout: Function could not calculate the results in the given time limit.
  3. Normal Result – Possible combinations: [amount 1, amount 2] ; [amount 1, amount 2, amount 3]
  • Once the result is generated by the function, user should do paste special values to avoid recalculation every time on file open or data change.
  • NOTE: IF YOU RETAIN THE FORMULA IN THE FILE AND IF THAT FILE IS OPENED ON A SYSTEM WHICH DOES NOT HAVE THE LICENSED COPY OF KNOCK OFF FUNCTIONS THEN THE FORMULA WILL START SHOWING #NAME ERROR, HENCE IT IS IMPORTANT TO USE PASTE SPECIAL BEFORE CIRCULATING THE FILE.

Example: In the table below, we have multiple values available in “Amount in local cur” column. We have restricted the range for comma separated values at 50, number of possible combinations to 1 and timeout secs to 10

 

Output showing possible combination