What
What is the quality of this data entry?
- What is the quality of Excel file data entry?
- What is the quality of macro parameter values?
What is the quality of this output? e.g. TFL (Tables, Figures and Listings)
Question
Is it possible to avoid the issue to occurs?
- Limit the number of characters entered in free text
- Limit the type of data entry: number, text, date, email, hyperlink…
- Provide limited number of possible values
Is it possible to get an autofix?
Autofix without notification
- Upcase values
- Remove multiple consecutive blanks
Autofix with notification (note, warning, error)
- Keep the first letter
- Use the default value (e.g. default macro parameter value)
Is it possible to get a direct feedback i.e. exactly when the issue is created, in order to be able to fix it directly?
Is it possible to include the queries all together
Use Cases
Use Case: Using Excel as Data Entry
Use Case: Macro Parameter Entries
Use Case: TFL Titles and footnotes