3.4 Input Entry Simplified or full

3.4 Input Entry
Simplified or full input can be selected, (see below), but in either case it will be seen that:

 When cells are selected most include ‘pop up’ text with guidance relevant to the particular input. Occasional
longer notes can be accessed by ‘pointing’ the cursor at the red Excel ‘comment’ tag.
 White cells indicate areas where data may be input into the model.
 Cells appear orange when an input is required (e.g. costs for declared units).
 Cell values may be copied via Edit->Paste Special->Values but must NOT BE CUT as this reassigns formula.
 Most cells have warnings for entries outside a feasible value range. Warnings will be given when the inputs are
outside the expected range, and give an indication of the source of the problem, as fig 1a below. Notice this is
designed for simple error trapping of clearly erroneous input, it is no way intended to guide values the HCA
would deem reasonable.

Fig 1a - Input error warning
 Timings are entered as any format Excel recognises as dates (e.g. dd/mm/yyyy) . Invalid dates are barred,
otherwise incorrect results would be produced. Restrictions are based on prior input e.g. see Fig 1b.


Fig 1b - Input error restriction.
 It is possible to select the ‘Warnings’ sheet (with Red ‘ Tab’) at any time, and this will produce a list of mandatory
inputs that remain to be entered.
 Phasing, cost and revenue input sheets are automatically ‘compacted’ to only show tenures and property types
that have units entered.
 The top line of input sheets shows the resulting valuation once a consistent set of input has been made. Prior to
this it displays an ‘incompletion warning’. The list of missing inputs can be found at any time by moving to the
‘Warning’ sheet.
Only sheets with green ‘tabs’ at the bottom of the screen are input sheets in which users are able to enter data, for
example as in fig 2.


Fig 2 - Tabs for input sheets
The grey tabs are for output sheets which may be examined to examine results (but are only valid when no ‘incompletion’
warnings remain, see fig 3.


Fig 3 - Tabs for output sheets

Kết quả (Việt) 1:

3.4 Input Entry Simplified or full input can be selected, (see below), but in either case it will be seen that:  When cells are selected most include ‘pop up’ text with guidance relevant to the particular input. Occasional longer notes can be accessed by ‘pointing’ the cursor at the red Excel ‘comment’ tag.  White cells indicate areas where data may be input into the model.  Cells appear orange when an input is required (e.g. costs for declared units).  Cell values may be copied via Edit->Paste Special->Values but must NOT BE CUT as this reassigns formula.  Most cells have warnings for entries outside a feasible value range. Warnings will be given when the inputs are outside the expected range, and give an indication of the source of the problem, as fig 1a below. Notice this is designed for simple error trapping of clearly erroneous input, it is no way intended to guide values the HCA would deem reasonable. Fig 1a - Input error warning  Timings are entered as any format Excel recognises as dates (e.g. dd/mm/yyyy) . Invalid dates are barred, otherwise incorrect results would be produced. Restrictions are based on prior input e.g. see Fig 1b. Fig 1b - Input error restriction.  It is possible to select the ‘Warnings’ sheet (with Red ‘ Tab’) at any time, and this will produce a list of mandatory inputs that remain to be entered.  Phasing, cost and revenue input sheets are automatically ‘compacted’ to only show tenures and property types có đơn vị nhập. • Đầu dòng đầu vào tờ Hiển thị kết quả định giá một khi một bộ phù hợp đầu vào đã được thực hiện. Trước khi đó sẽ hiển thị một cảnh báo incompletion'. Danh sách thiếu đầu vào có thể được tìm thấy bất kỳ lúc nào bằng cách di chuyển các 'Cảnh báo' tờ. Chỉ các trang với màu xanh lá cây 'tab' ở dưới cùng của màn hình đang đầu vào tờ trong đó người dùng có thể nhập dữ liệu, cho Ví dụ như trong hình 2. Hình 2 – tab cho đầu vào tờ Các tab màu xám cho đầu ra tờ mà có thể được kiểm tra để kiểm tra kết quả (nhưng là chỉ có giá trị khi không có 'incompletion' cảnh báo vẫn còn, xem hình 3. Hình 3 - tab cho đầu ra tờ