To speed up your implementation you can use our google sheets template to prepare your reporting.
Create your personal copy
In order to get your copy of the templateg go to the template and Make a copy of the file by clicking 'File' and then 'Save a copy'.
Make a copy of the google sheets to avoid exposing your credentials
Start building your reports
After you made your personal copy of the file enter your emailadres, password and select the entity that you want to build a reporting for.
Structure of the template
The definitions can be made in the the tabsheets that are highlighted in yellow. Each tabsheet is constructed in a similar manner with:
- The definition: this is the part that needs to be saved as a CSV file to be uploaded into Monitr.
- Extra information: fields that help you creating your definition.
- Detailed validations: Validations rules applied to each row of your definition, to avoid having errors when uploading your CSV file into Monitr.
- Validation Summary: This gives an overview of the status of each validation (out of the detailed validation). A brief summary of the validation rule is given.
More information on how to create the defition for each tabsheet can be found here: