Category : Education
I'm just starting to work with this app, have taken mock data and then exporting it and uploading it to Excel to test its functions. The following steps are an outline of how I took timestamp data and converted it into summary data (say if you want to calculate total behaviors in a session or the rate of behavior in a session): 1. Open email 2. Copy body text of email 3. Paste into Notepad (or similar simple text editor which can save as csv) 4. (Save as .csv (change file type to "all files", give the file a name ending with ".csv" (no quotes) 5. Open with Excel 6. Save as excel spreadsheet with client name and type of data (eg, DA, FA, etc) as title 7. Place cursor in empty cell 8. (Consider setting up mini summary table with Item names in rows, sum and rate in columns prior to going further to stay organized) 9. Open Formulas tab 10. Select More Functions 11. Select Statistical 12. Use COUNTIF formula 13. Select "Item" row without header for Range 14. Type in an item name for Criteria 15. Click OK Optional steps in paratheses.
Really like the ability to customize labels. Nice clean data entry mechanism. Would like to see some means of aggregating and consolidating entries over multiple days, so a period of days or weeks can be seen together without having to copy/paste from individual days. It might do that already, haven't seen that in the guide though.