Section: 8. APPLICATION INTERNALS
Subsection: 8.2 Notes Application Internals
Topic: Scorecard Calculations


Scorecard Data Transfer

The Scorecard form gets all it's values from the Excel spreadsheet. During the data transfer, these are pasted in the field tmp_descat the bottom of the form from the Windows clipboard. The Notes macro Get Values and Trends invokes the Excel macro get_flds via a DDE function call. The get_flds macro copies a range of values from the DataXfer page in the Excel workbook to the clipboard. The Get Values and Trends macro then navigates to the tmp_desc field in the form and pastes the clipboard contents into the field.

Results and Trend Calculations

The result numbers in the Scorecard are all calculated in the Excel spreadsheet. Each data field in the Notes Scorecard form is a calculated field that simply extracts its value from the data transfer field tmp_desc at the bottom of the form. Scorecard result values equal the respective values in the transfer field string. The trend values are a code in the transfer field string that the Notes trend fields convert to a character that displays as the corresponding symbol in the monotype sorts font. The trend values and their corresponding symbol are as follows:

Trend Direction Value Char Symbol

Improving 1 s s
Declining -1 t t
Even 0 u u
Not Available 6 6 6