Dear everyone!
I've got a problem I'm hoping somebody may be able to help with!
Basically, I analyze a collection of plots which I update every day in Excel. They are simple line plots and they basically fluctuate up and down like oscillators but are by no means "neat" oscillations, rather they GENERALLY go up and down between two "extremes" but always a bit jagged and rough (that's ok, that's part of my analysis). I update (with one new plot per day) and monitor between 100-200 of these charts in Excel every day for agricultural use all year round.
My need: I need Excel to automatically assess each chart and decide which is the most coherent as a "neat oscillator" and basically rank them (from the best [neatest, most smoothest and reliable] output in terms of being a pure oscillator with minimum noise all the way down the worst one [most noisy, incoherent and simply messy]). I want to run the query every day or week to keep track of which chart is, quite simply, the nicest the view and analyze in terms of being a pure and simple fluctuating oscillator.
Now I know it sounds quite complex but I have been thinking hard and basically all it comes down to is having a set of pre-defined rules that make an oscillator-type chart "the most coherent" and simply programming these rules into Excel for it to be able to rank multiple charts. But I'm new to VB, a bit better at Excel as a whole, but no expert. Plus I'm thinking (hoping) there may be a simple solution I have missed: maybe some form of built-in function in Excel (2007 I use) which is a statistical function I've never heard of that does exactly what I need..... but I'm not betting there is!!
Of course, by using my human eye and brain I can rank them by using discretion and saying "hmmm, that one looks like a neater oscillator than that one.." etc.. but because I use so many charts, and maybe more in the future, I really want to be able to update the plots, click a button and see a rank of best to worst.
The result? I want to instantly see that the oscillations in chart A are more predictable and reliable than chart B, and chart E are more than chart K, etc... so I know which agricultural methods work more consistently year on year throughout seasons with minimal error and noise.
Any takers?!! I am soooo grateful for any help on this one. Please ask as many questions as you want to if you need to, I'm just hoping some brainy person out there has the answer.
Many thanks
Holiday (oh, and Merry Xmas everyone)
I've got a problem I'm hoping somebody may be able to help with!
Basically, I analyze a collection of plots which I update every day in Excel. They are simple line plots and they basically fluctuate up and down like oscillators but are by no means "neat" oscillations, rather they GENERALLY go up and down between two "extremes" but always a bit jagged and rough (that's ok, that's part of my analysis). I update (with one new plot per day) and monitor between 100-200 of these charts in Excel every day for agricultural use all year round.
My need: I need Excel to automatically assess each chart and decide which is the most coherent as a "neat oscillator" and basically rank them (from the best [neatest, most smoothest and reliable] output in terms of being a pure oscillator with minimum noise all the way down the worst one [most noisy, incoherent and simply messy]). I want to run the query every day or week to keep track of which chart is, quite simply, the nicest the view and analyze in terms of being a pure and simple fluctuating oscillator.
Now I know it sounds quite complex but I have been thinking hard and basically all it comes down to is having a set of pre-defined rules that make an oscillator-type chart "the most coherent" and simply programming these rules into Excel for it to be able to rank multiple charts. But I'm new to VB, a bit better at Excel as a whole, but no expert. Plus I'm thinking (hoping) there may be a simple solution I have missed: maybe some form of built-in function in Excel (2007 I use) which is a statistical function I've never heard of that does exactly what I need..... but I'm not betting there is!!
Of course, by using my human eye and brain I can rank them by using discretion and saying "hmmm, that one looks like a neater oscillator than that one.." etc.. but because I use so many charts, and maybe more in the future, I really want to be able to update the plots, click a button and see a rank of best to worst.
The result? I want to instantly see that the oscillations in chart A are more predictable and reliable than chart B, and chart E are more than chart K, etc... so I know which agricultural methods work more consistently year on year throughout seasons with minimal error and noise.
Any takers?!! I am soooo grateful for any help on this one. Please ask as many questions as you want to if you need to, I'm just hoping some brainy person out there has the answer.
Many thanks
Holiday (oh, and Merry Xmas everyone)
