Help with Power Pivot Data Analysis

[francisobrien2007]

Hello,

I have loaded a spreadsheet of time stamped instrument data for the analysis of a measured signal intensity versus time in seconds. The scan time for every line of data is in the timematrix table and the measured signal data is in the remaining tables.

I need to apply a fixed set of statistical calculations for specific time ranges for the entire dataset across the 20 data tables in the power pivot. I am including an example of data that I created manually but I am looking for something to automatically do this and then filter and analyze the data according to my needs. I am drowning in data and I need to summarize this into a simple to understand format.

Here is the link to download the data which is 92mb in size.

https://www.dropbox.com/s/bjzyxf2mq8uv8zv/PivotTableForum.xlsx?dl=0


Can anyone help?

Best,

Francis