Appendix A: Data Values: General Instructions

The following sections document the allowable data values for each column in the Partner Information worksheet and Special Allocations worksheet.

General rules for both worksheets are as follows:

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.
All dates must be entered 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.

Import/Export/pbridge_data_general_1.htm/TY2021

Last Modified: 03/20/2020

Last System Build: 10/18/2022