Saturday, July 20, 2013

yogi_Count Instances Of Specified Characteristics Over Specified Time Intervals

                                          Google Spreadsheet   Post  #1295
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul 20, 2013
user post by Aaron Issacs (http://productforums.google.com/forum/?zx=cxfn6lem6psg#!searchin/docs/InOverMyHead/docs/2xTx95hiPVk/CMg7MEWUbzcJ)
Need help sorting, filtering, and summing my list. May be in over my head on this one.
After one of you wizards put up a single line capable of performing this bit of shifting and sorting, I'll look at it and think to myself - I want his brain, lol.  

Looking to filter (Sheet1/UniqueID) 123's data into (Sheet2) "123'sTotals".  As shown in the Shared Spreadsheet below, I want to use the Legend Column Header 'EMOTIONS' on Sheet1 as Row Headers in Sheet2.  Then, sum the total number of 10's (Happy's), 9's (Funny's), 8's...1's, by EMOTION into blocks of time (every 5 minutes) with reference to the Timestamp on Sheet1.  

https://docs.google.com/spreadsheet/ccc?key=0ApqhD3KILxoPdFNKWVpRS3Vwdmt5cE55UlVQd2pEb2c&usp=sharing

Any help is appreciated!  Thank you.

Aaron
----------------------------------------------------------------------------------------------------------------------------------------------------------