PreviousNext
TRAC v8 Reference > Setting Up Your Historic Data > Excel (XLS, XLSX, CSV) Formats > Entire spreadsheet vs. named range
Entire spreadsheet vs. named range

You may either devote an entire worksheet to the data (recommended) or specify a portion of a worksheet by giving it the range name BFSDATA.

In a multi-worksheet workbook the data are assumed to reside in the first (topmost) worksheet unless an alternate sheet has been specified by naming it BFSDATA.

The cell references in the examples below assume that the entire worksheet has been devoted to the Forecast Pro database. If you opt to specify a named range, cell A1 in the examples will correspond to the cell in the uppermost left corner of your named range.

PreviousNext