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)
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 Case: Using Excel as Data Entry
Use Case: Macro Parameter Entries
Use Case: TFL Titles and footnotes