Data values instructions

General rules for the allowable data values for each column in the Partner Information worksheet and Special Allocations worksheet.
  • Do not change format properties for any cell for any reason.
  • A data field is optional unless noted otherwise.
  • All column values for which a single code can be selected from a list of codes must be blank if the column designation and/or list of codes do not apply to the subject partner.
  • Enter all dates in the format MM/DD/YYYY unless noted otherwise.
  • Dollar amounts can be either whole dollars or dollars and cents unless stipulated otherwise. The smallest allowable dollar values is -99,999,999,999.99; the largest is +99,999,999,999.99 unless noted otherwise. If the smallest or largest allowable dollar amount for any column is different, the column instructions will give the specifications.
  • Decimal fractions can have a maximum of eight (8) digits to the right of the decimal point (0.12345678) unless noted otherwise. The smallest allowable decimal fraction value is -1.0; the largest is +1.0. If the smallest allowable decimal fraction value for any column is not zero, the column instructions will specify the smallest allowable decimal fraction value for the column.
  • The special designation NONE is equivalent to zero for both dollar amounts and decimal fraction values unless noted otherwise.

Related content

Chat now

error-icon

Triva isn't available right now.

Check out the support page for our phone number and hours

error-close