Coaching Tools
Communication Indicators and Forensics
This tools fills out the Communication Indicators worksheet programmatically. Use the CI worksheet when you are coaching, especially if you turn on the forensics, which will tell you which languages are contributing to a particular CI. It should allow you to ask deeper questions and help the client gain more insights in their profile.
Remember that when choosing to include forensics, do not distribute the sheet to the client!
If you select one of the Multiple tabs, you can generate multiple sheets at once from your group directory data, which can be useful for coaching a group or doing a group exercise.
Single
Multiple (CSV)
* Generate random test data
To use:
- Copy your group data from the group report into this Excel table
- Save as a CSV file locally.
- Open the CSV file in a text editor like WordPad (Windows) or TextEdit (Mac).
- Copy the CSV data and paste into the CSV Formatted Data field on this page.
- Click the submit button to see your report.
Multiple (JSON)
* Generate random test data
To use:
- Copy your group data from the group report into this Excel table.
- Save as a CSV file locally
- Go to the following web page: https://www.convertcsv.com/csv-to-json.htm.
CSV to JSON button. - Copy the contents of the Result Data field on that page into the JSON Formatted Data field on this page.
- Click the submit button to see your report.
N.B. JSON is best used programmatically. In this case, the JSON encoded data is appended to the URL. For example:
let person1 = { fullName: "John Smith", companyName: "Acme Inc", mover: 65, doer: 77, ... }; let person2 = { fullName: "Jane Doe", companyName: "Acme Inc", mover: 56, doer: 88, ... }; let data= [ person1, person2 ]; let cTargetURLPrefix = "https://www.relatematters.com/coaching-tools/CommunicationIndicators.html"; let str = JSON.stringify(data); let url = new URL(`${cTargetURLPrefix}?json=${encodeURIComponent(str)}`); window.location.href = url;
The data should be an array of objects, each of which should have keys equal to the column headers in the sample CSV and data values as specified per person.