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
- Possible outcomes
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
- None: No combinations possible
- Timeout: Function could not calculate the results in the given time limit.
- 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⬇️
