Does BCP support derived data input in a spreadsheet-based process?
BCP is driven by Excel, which means if you can model your data requirements using a tabular (row-column) environment including business logic, then it will work the same way with BCP. For example, if you want to work with both the booking and ship date, the ship date can be an automatically calculated date based on either a fixed lead-time ratio or it can be specific to each part (unit). Any logic model in Excel driven by a formula is easily incorporated into BCP and the unit booking and shipment information can be captured in additional columns (right next to the forecast information or anywhere else in the Excel file). Also, since data entry is governed using cell-level access control, you can set it up such that an individual ship date can be adjusted manually if required. All changes are also tracked at the cell level so you can always know who has made what change and why.
