Parrish Waters Project (Fall 2016)


Parrish Waters (rwaters)

Create a way to map mice/rat on a grid and show paths that were taken of 1 – 8 mice over a period of time. Would want heat map of where they stay the longest.

This one involves excel, and extrapolating X-Y position from a grid of ‘readers’.

The project would read in a series of excel files and then plot the data based on a set of totals.  The is a grid that is shown in the below screenshot of where the mice can possibly go.  He would like to do a line drawing of the where the mice go based on a time selection.  He would like to choose which mice to display.  In addition he would then like to use a heat map to display how long a mouse stays in a specific location.