Time Binning of Locomotor Data in Excel
This Excel sheet allows you to define time bins in which data should be tabulated, i.e. simply see the total distance travelled by the animal in given time intervals during each trial. This works only for Locomotor results generated using ActualTrack.
- Download the TimeBinning.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 TimeBinning.xls file
- Select the 2 columns containing the bodycenter_x and bodycenter_y data from the trial data tab in the results file by selecting the column headings.
- Copy the selection.
- Select columns A and B on the data tab of the time binning sheet by selecting the columns headings.
- Paste the values from the clipboard.
Result: The time binned values are show in in cells E2:F98.
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.
