Partner Bridge: Worksheet Operations: Special Allocations Worksheet

The Special Allocations worksheet includes partner identification (names and numbers), special allocations codes and descriptions, and allocation ratios and dollar amounts applicable to each partner.

The worksheet is populated in stages, each of which must be completed in sequence:

Enter the special allocation codes and descriptions.
1. On the Control worksheet, set the worksheet process control drop list to the Setup Codes option.
2. Click the Setup Codes button on the worksheet and respond to the prompts. This applies format properties to the cells on rows 4 and 5 that represent the special allocation codes and descriptions.
3. When the procedure is complete, enter the special allocation codes and descriptions in one of two ways:
  1. Manually enter the codes and descriptions using the keyboard.
  2. Copy the codes and descriptions from an Excel source and paste the copied data into the appropriate cells on the worksheet using the Paste Special > Values function (see Partner Bridge: Copy and Paste: Special Allocations Worksheet).
Audit the special allocation codes and descriptions.
1. On the Control worksheet, set the worksheet process control drop list to the Audit Codes option.
2. Click the Audit Codes button on the worksheet and respond to prompts. The process confirms that special allocation codes meet system requirements, and corresponding descriptions are truncated if necessary.
3. If terminal errors are encountered during the audit, you will receive a message. Correct the errors and submit the worksheet for audit again by clicking the Audit Codes button. Repeat this process until there are no terminal errors.
4. If no terminal errors are encountered, the worksheet process control drop list on the Control worksheet is automatically set to the Copy Partners option.
Copy the partner names and numbers from the Partner Information worksheet to the Special Allocations worksheet.
1. Click the Copy Partners button on the worksheet and respond to the prompts.
  
  The partner copy process will be terminated if the Partner Info process control drop list on the Control worksheet is not set to the Complete option.
2. All partner allocation ratios and dollar amounts are erased from the worksheet.
3. The partner names and numbers are copied from the Partner Information worksheet. This is the only approved means of populating the worksheet with partner identification. Any other method will invalidate the worksheet, and the workbook will not be supported.
4. The partner allocation ratio and dollar amount cells are formatted and validation properties are applied. Validation properties prevent the entry of invalid data types and values.
5. When the partner copy process is successfully completed, the Spec Allocations process control drop list on the Control worksheet is automatically set to In Process to facilitate the step in the worksheet completion.
Enter the partner allocation ratios and dollar amounts in one of two ways:
1. Manually enter the ratios and dollar amounts using the keyboard.
2. Copy the ratios and dollar amounts from an Excel source and paste the copied data into the appropriate cells on the worksheet using the Paste Special > Values function.
  
  The format properties and validation properties of the allocation ratio and dollar amount worksheet cells must not be changed for any reason, and using the Paste function will change the format properties to those of the Excel source.
Audit the partner allocation ratios and dollar amounts and create the Special Allocations DIF file.
1. Click the Make DIF button on the worksheet and respond to the prompts.
  
  The partner allocations audit process will be terminated if the Spec Allocations process control drop list on the Control worksheet is not set to the In Process option.
2. The partner allocation ratios and dollar amounts are audited for compliance to data type, smallest and largest values, and other factors.
3. If terminal errors are encountered, the errors are recorded on the Audit Errors - SA worksheet, and the corresponding worksheet cells are painted bright yellow. Correct the errors and submit the worksheet for audit again by clicking the Make DIF button. Repeat this process until no errors are encountered.
4. If no terminal errors are encountered, you will have the option to create the Special Allocations DIF file, and the Save As dialog will give you the option to save the file anywhere on your workstation or network.
5. If the Special Allocations DIF file is successfully completed, set the Spec Allocations process control drop list on the Control worksheet to the Completed option. This prevents the audit process for the worksheet if the Make DIF button is inadvertently clicked.
  If it is necessary to add one or more partners to the Partner Information worksheet after the Special Allocations worksheet is populated with partner identification, even if the Special Allocations DIF file has been successfully created, you must repopulate the worksheet with partner identification by executing the partner copy process again (click the Copy Partners button).

Import/Export/pbridge_special_allocations_worksheet_2.htm/TY2021

Last Modified: 03/20/2020

Last System Build: 10/18/2022