DonationCoder.com forum
 
Read-only archive. This is a static copy of the DonationCoder.com forum. Reading and searching work as before; logging in, posting and private messages do not.
Archive of 2026-10-21 · About this archive · Main site

Author Topic: XL Data Analyzer - v1.00.01 - December 31, 2006  (Read 17,776 times)

wraith808

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 11,205
    • Participated in NANY Challenge Fourteen Times
    • Coding Snacks
    • Writer
    • Hardware Hacker
XL Data Analyzer - v1.00.01 - December 31, 2006
« on: January 01, 2007, 04:41 AM »
XL Data Analyzer - v1.00.01 - December 31, 2006

    * First public release.

WHAT IT DOES:
This program was born of a need to perform analysis on excel data.  Basically, if you have a column of scale (time, distance, etc) and a column of values for each member of the scale (blood pressure measured per second, for instance), you can enter different discrete values on your scale, and the program will scan that area of the excel sheet, and either average the values, find the floor of the values, or find the ceiling of the values.  So... let's say you had a spreadsheet of heart rates over time, and wanted to average the heart rates for discrete periods... you could enter the starting time, and ending time, and the program would average the heart rates over that period of time.

SCREENSHOT:


XL Data Analyzer
« Last Edit: September 09, 2015, 01:20 PM by wraith808 »

mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 40,931
    • Gathering Badge
    • Plugin Coding Medal
    • Participated in NANY Challenge Seventeen Times
    • Cody Award
    • Coding Snacks
    • Volunteers/Staff
Re: XL Data Analyzer - v1.00.01 - December 31, 2006
« Reply #1 on: January 01, 2007, 02:19 PM »
I can think of times when i could have really used this program - i will definitely keep it in my toolbox.  :up:

Original address: https://www.donationcoder.com/forum/index.php?topic=6816.0