To modify the structure of a view, click on the [Modify] button at the right hand side of a view. To add a new view, click on the [New] button.
When you click on the [Modify] or [New] button, RaceMate will show the following "Edit View" form.
1. | View Name |
Caption of the view to be shown in the view list
2. | Description |
A descriptive long name for the view (up to 80 letters or 40 Chinese characters)
3. | Chinese Mode Equivalent |
You may switch between Chinese and English modes in RaceMate Professional Edition. The views of these two modes are independent of one another. The Chinese Mode Equivalent setting determines the Chinese view (the twin view of the current English view) that will get focus when you switch the language mode from English to Chinese.
4. | Starters View/Entries View |
Choose between showing starters and entries
5. | Show Formula |
When Show Formula is selected, whenever you position your mouse over a view column header, RaceMate will show the formula of the column at the right-top of the screen. It will be helpful to your view designing and testing work. After the view design is completed, you may want to turn it off to make the screen cleaner.
6. | Columns Locked |
Set the number of columns which will not be moved with other columns when you scroll the view left and right.
7. | Column List |
A list showing all columns of the view. When you select a column in the list, the details of the column will be shown in the controls on the right.
8. | Column Reposition Buttons |
You may drag a column reposition button to change the relative position of a column.
9. | Column ID |
Each column carries a unique Column ID. You may show the data of a column of another view in the current column by mapping the two columns via the Column ID. (See "Mapped to" below)
10. | Heading |
Column caption to be shown at the topic of a column
11. | Width |
Column width in pixels
12. | Type |
Data type of the column. The following data types are available:
Data Type |
Description |
Numeric |
Integer or decimal numbers. Maximum 20 digits including decimal part and decimal point |
Character |
Text. Maximum 254 characters (127 Chinese characters.) |
Multiline Text |
Block of text. No limited in number of characters. When you increase the row height, a vertical scrollbar will be show at the right edge of the grid cell. Accessing Multiline Text data is slower than accessing Character data. Very often we will use Character type instead of Multiline Text type except the text to be handle is large. |
Date |
Date |
Logical |
True or false. RaceMate will show a u for true and a blank cell for false. If the the logical column is editable, you may click on a cell to change its value from true to false, or vice versa. |
13. | Chars/Digits |
Maximum number of characters or digits allowed. A Chinese character will be treated as 2 English letters. For numeric columns, the number includes the decimal part and the dot.
14. | Decimal |
Number of digits in the decimal part. Applicable to numeric data only.
15. | Display Option Dropdown |
You can use it to choose among the options Always Shown, Always Hidden or Hide if No History.
16. | Built-In Item |
RaceMate predefines a set of built-in columns for retrieving data and doing statistics. When you select a built-in item from the built-in item list, the corresponding MCL function will be shown in the expression editing box below. You may convert a Built-In Item Column to a User-Defined Item Column by click on the User-Defined Item button. You may then edit and fine-tune the MCL function.
17. | User-Defined Item |
You may enter an MCL expression into the expression editing box to retrieve data or carry out statistics. See the sections of MCL Reference for detailed information about MCL expressions.
18. | User-Input Column |
For inputting notes or ratings. A user-input column can be of any of the five data types described above.
19. | Remark |
Remark about the column for your own reference
20. | Betting Index |
You can mark one (and only one) column as Betting Index. When we carry out an evaluation on the accuracy of the prediction model (i.e., the view), RaceMate will calculate the winning percentage (and investment return) of the horses with highest betting indexes. A view with a betting index defined is called a Prediction Model.
21. | Stat Column |
Stat Column is the short form of Statistical Column. When a view is used for statistics, you may mark one (and only one) column as Statistical Column. When statistics is carried out, RaceMate will calculate the following values for the column: Count, Sum, Maximum, Minimum, Average, Variance, and Standard Deviation. We call a view with a statistical column defined a Statistics Model.
22. | Stat Groups |
Stat Group is the short form of Statistical Group. You may define unlimited levels of Statistical Groups in a view. RaceMate will find the statistical figures of the statistical column within each group.
23. | Append |
Append a new column at the end
24. | Insert |
Insert a new column at the current position
25. | Delete |
Delete a column
26. | Advanced |
See Advanced Settings of View Columns for details
27. | Save+Exit |
Save changes and exit to the Race Data Form
28. | Cancel+Exit |
Abort changes and exit to the Race Data Form
29. | Reset |
Reset the structure of a built-in view to its factory settings. Resetting a view will remove the columns that you added and recall the columns that you deleted.
30. | Export |
Export the structure of a view into a disk. The structure can then be read into another RaceMate (of another computer). By using this function, you may transfer the structure of an English view into disk and import the structure into Chinese mode.
31. | Import |
Import structure of a view from disk
32. | Save Format |
In our daily RaceMate operation, we may reorder columns or change column widths of a view using the mouse. Clicking the small button at the left-top of the view will reset the view to its default settings. (The default settings of a user-defined view are the settings in the first save of the column definitions.) Sometimes, you may want the keep your recent changes and don't want them being reset accidentally. Clicking on the [Save Format] button will mark the current settings as the default. Future clicks on the left-top small reset button of a view will put the view into these saved settings.
33. | View Remark |
Remarks about the view for your future reference
34. | Show View Rmk |
Once this box is checked, when your mouse is positioned above the view name on the view list of the Race Data form, a popup window showing the view remark will be shown.
35. | Show Colm Rmk |
Once this box is checked, when your mouse is positioned above the heading of a view column in the Race Data form, a popup showing the remark about the column will be shown.
36. | Header Expression |
On the Race Data form, you can show MCL function results and text in the text box above the view table. The Header Expression box is for editing how to show such data. See the View Header page for details.
Page url: http://www.racematenet.com/english/help/index.html?creating_starter_views.htm