# Anyone good with Excel? **URL:** \ **Category:** NYSpeed Off Topic\ **Created:** [August 26, 2008, 8:57am UTC](https://forums.speedlife.net/t/anyone-good-with-excel/53883 "2008-08-26T08:57:49Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![drvnkd](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/drvnkd/32/109615_2.png) [@drvnkd](https://forums.speedlife.net/u/drvnkd)\ **Post date:** [August 26, 2008, 8:57am UTC](https://forums.speedlife.net/t/anyone-good-with-excel/53883/1 "2008-08-26T08:57:49Z")
I have no Idea what functions to look at for some data analysis. I have a sheet with thousands or rows, and hundreds of columns. 1 row for every minute. I would like to generate a summary over smaller time segments. Nothing difficult, just averaging data over a given time frame and putting those numbers into a summary sheet. My problem is that the manual method it time consuming and The relevant time for tests is not consistent (some 30 min, some 4 hours) I suck at making sheets that are smarter than I am and I do not know VB. Any thoughts? ---
**Author:** ![ILCisDEAD](https://avatars.discourse-cdn.com/v4/letter/i/a87d85/32.png) [@ILCisDEAD](https://forums.speedlife.net/u/ILCisDEAD)\ **Post date:** [August 26, 2008, 8:59am UTC](https://forums.speedlife.net/t/anyone-good-with-excel/53883/2 "2008-08-26T08:59:39Z")
umm. better example? or sample ---
**Author:** ![drvnkd](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/drvnkd/32/109615_2.png) [@drvnkd](https://forums.speedlife.net/u/drvnkd)\ **Post date:** [August 26, 2008, 9:15am UTC](https://forums.speedlife.net/t/anyone-good-with-excel/53883/3 "2008-08-26T09:15:00Z")
Not sure how to explain it. Data collection is automated. It generates a sheet and adds a new row every minute. I need to get data from that sheet, average it over X minutes, and return the average to a summary page. ? ---
**Author:** ![LZ1](https://avatars.discourse-cdn.com/v4/letter/l/7ab992/32.png) [@LZ1](https://forums.speedlife.net/u/LZ1)\ **Post date:** [August 26, 2008, 10:26am UTC](https://forums.speedlife.net/t/anyone-good-with-excel/53883/4 "2008-08-26T10:26:14Z")
So you have something that constantly writes data to spreadsheet and you want run querys on the data? and generate reports? Have you heard of a database? It’s a new technology… Regardless of my jackass comments [http://www.bettersolutions.com/excel/EDH113/LA710411616.htm](http://www.bettersolutions.com/excel/EDH113/LA710411616.htm) will that help? ---
**Author:** ![drvnkd](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/drvnkd/32/109615_2.png) [@drvnkd](https://forums.speedlife.net/u/drvnkd)\ **Post date:** [August 26, 2008, 10:34am UTC](https://forums.speedlife.net/t/anyone-good-with-excel/53883/5 "2008-08-26T10:34:43Z")
The average If idea looks promising. I don’t mind copying the data into the same workbook. I could use a database… But then all my spreadsheets that are generated from a BASIC module in my PLC would go to waste. ---
**Author:** ![ILCisDEAD](https://avatars.discourse-cdn.com/v4/letter/i/a87d85/32.png) [@ILCisDEAD](https://forums.speedlife.net/u/ILCisDEAD)\ **Post date:** [August 26, 2008, 10:37am UTC](https://forums.speedlife.net/t/anyone-good-with-excel/53883/6 "2008-08-26T10:37:25Z")
why not post a sample of what you want… or the entire thing who cares… It would be 190823047129834123 times easier ---
**Author:** ![sureshot](https://yyz2.discourse-cdn.com/flex034/user_avatar/forums.speedlife.net/sureshot/32/7578_2.png) [@sureshot](https://forums.speedlife.net/u/sureshot)\ **Post date:** [August 26, 2008, 10:43am UTC](https://forums.speedlife.net/t/anyone-good-with-excel/53883/7 "2008-08-26T10:43:09Z")
> [@LZ](#): > > So you have something that constantly writes data to spreadsheet and you want run querys on the data? and generate reports? > > Have you heard of a database? It’s a new technology… > > Regardless of my jackass comments > > [http://www.bettersolutions.com/excel/EDH113/LA710411616.htm](http://www.bettersolutions.com/excel/EDH113/LA710411616.htm) > > will that help? I offer nothing to this thread, however I’d like to give a :lol: and a :word: to this post.