Time Binning of Zone Entries and Behavior Occurrences in Excel
This Excel sheet allows you to define time bins in which data should be tabulated, i.e. simply see the total time spent in a zone or undertaking a behavior by the animal in given time intervals during each trial. This works for both Scored Behaviors using ActualScore and Zone entries generated using ActualTrack.
- Download the TimeBinningZones+Behaviors.xls file and open both the results file and this file in Excel.
- Enter the time bin length in seconds in the green configuration tab on the TimeBinningZones+Behaviors.xls file
- Select the Zone or Behavior column from the trial data tab in the results file by selecting the column heading.
- Copy the selection.
- Select column A on the data tab of the time binning sheet by selecting the column headings.
- Paste the values from the clipboard.
Result: The time binned values are show in in column C of the Trial tab.
Please let us know if you need any help with this analysis or have done your own analysis of results and would be willing to share it with other users so we can add it to the site.
