You can enter data to a time grid by using spreadsheet.
You can enter one value at a time. You can also enter values for specific
time periods by working in the Estimates tab
below the graph paper grid.
Procedure
- To enter an estimate, in a spreadsheet, scroll to the required
time period and select the appropriate column for the data: low, likely,
or high.
- In a cell, type a value and press Enter.
- In the spreadsheet, select a cell. If you enter
only one value for a given period, investment analysis automatically
sets the remaining values in the row to match the estimate that you
entered.
- To enter the next point, go to the next time period and
type a value in a cell.
- Press Enter. A line is drawn between your
two explicit inputs and data is added where required. When more than
two time periods have data, a smooth curve of the points that you
entered is drawn. Values are added along the curve to determine any
unspecified estimates.
Note: - All the data that you explicitly enter is displayed in bold in
the spreadsheet.
- All data that the editor adds is displayed in unformatted text
in the spreadsheet.
- If you enter values in the incorrect time period, you must delete
data from the cells in that row. Double-click the data value, delete
the value, and press Enter. The value of $0.00 is
displayed. If value of $0.00 is displayed in bold,
delete the value again. You can also right-click to delete the estimate
in the graph paper section.