VirtualSpeech score reader

XR Meditation study · reads session report pages and fills VS1 / VS2 scores by participant ID
1

Load the master sheet

Nothing loaded yet. The first sheet must have columns ID, StartDate, EndDate, Station, StartDate2, EndDate2, Station ID2, VS1_Ovr … VS2_Dlvry.
2

Load the session report pages

or drag the SP26 (or FA25) folder here. Subfolders by date are fine.
No reports loaded. File names must look like 2026-02-18--16-15--abbyj--user-10.html.
3

Review the matches

IDDateStnPrePost VS1 (first speech)VS2 (second speech)In sheet nowCheck
Load the sheet and the reports to see matches.
Reports not assigned to anyone (0)
    Files that could not be read (0)
      How matching works
      • A report belongs to the participant whose pre survey is on the same date and whose station number equals the user-N in the file name (the headset login). If the pre and post surveys list different stations, both are accepted.
      • The report's time must fall between the pre survey start and the post survey end (15 minutes of slack either side). With no post survey, anything within 4 hours of the pre survey counts.
      • The earlier report is VS1, the later is VS2. With three or more, the two whose typed names match each other are used and the rest are listed as unassigned.
      • If a headset's reports match nobody's recorded station that day but fit exactly one participant who has no reports, they are proposed for that participant and flagged in red for confirmation (a station typed wrong in Qualtrics).
      • The post survey normally starts a few minutes after the VS2 report finishes. That gap breaks ties and is flagged when it is unusual.
      • Anything odd is flagged in the Check column. Use the dropdowns to override; overridden rows get a green edge and are marked Manual in the export.
      • Scores already in the sheet are shown for comparison and are not overwritten unless you tick the box at the bottom.
      The CSV is keyed by ID and has the six score columns plus file names, typed names, and flags. The workbook download keeps values, column widths, and date formats but not fonts or frozen panes; if that matters, use the CSV and merge it into the master file.