Calculating trend against multi-state situations
March 1, 2009 9:50 AM Subscribe
A math owie: How do I determine the trend of situations with multiple scenarios and states week by week?
I have a feeling this is an easy problem, but dang if I ain't blocked.
I'm building a scorecard that tracks the state of several situations, each with several scenarios inside it (let's say 4 situations with 8 scenarios each).
The situations each have 4 states they can be in, black, red, yellow and green. The goal is for all situations in a scenario to go green. What I need to do is understand whether a situation is getting better overall between this week and last.
That's a lotta lotta words, which might be better explained by looking at this spreadsheet:
http://spreadsheets.google.com/ccc?key=pjeoQuRDvgeqk9zY5a2XWLw (should be viewable by all)
A hint please? A clue? Thank you!
I have a feeling this is an easy problem, but dang if I ain't blocked.
I'm building a scorecard that tracks the state of several situations, each with several scenarios inside it (let's say 4 situations with 8 scenarios each).
The situations each have 4 states they can be in, black, red, yellow and green. The goal is for all situations in a scenario to go green. What I need to do is understand whether a situation is getting better overall between this week and last.
That's a lotta lotta words, which might be better explained by looking at this spreadsheet:
http://spreadsheets.google.com/ccc?key=pjeoQuRDvgeqk9zY5a2XWLw (should be viewable by all)
A hint please? A clue? Thank you!
This post was deleted for the following reason: Oops repost to ask mefi -- mathowie
yikes
posted by zoomorphic at 9:52 AM on March 1, 2009
posted by zoomorphic at 9:52 AM on March 1, 2009
Administrator: Please hope me! Sorry, this was meant for ask.meta. Here I was worried about asking dumb question, I should have been worried about posting on the wrong color page.
posted by daver at 9:53 AM on March 1, 2009
posted by daver at 9:53 AM on March 1, 2009
The goal is for all situations in a scenario to go green.
Snap! If we solve this, the query magically moves to AskMe.
posted by terranova at 9:55 AM on March 1, 2009
Snap! If we solve this, the query magically moves to AskMe.
posted by terranova at 9:55 AM on March 1, 2009
NOT-BLUIST
posted by BrotherCaine at 9:56 AM on March 1, 2009
posted by BrotherCaine at 9:56 AM on March 1, 2009
Love is the cheapest thing. It is also the thing with the most value. YMMV.
what I might've said in the cheapest thing chatfilter
posted by geekyguy at 9:57 AM on March 1, 2009
what I might've said in the cheapest thing chatfilter
posted by geekyguy at 9:57 AM on March 1, 2009
metafilter: A hint please? A clue?
posted by cjorgensen at 9:58 AM on March 1, 2009
posted by cjorgensen at 9:58 AM on March 1, 2009
The goal is for all situations in a scenario to go green.
This. is. unintentionally. awesome.
posted by joe lisboa at 9:59 AM on March 1, 2009
This. is. unintentionally. awesome.
posted by joe lisboa at 9:59 AM on March 1, 2009
The situations each have 4 states they can be in, black, red, yellow and green.
Four red states: Texas, Alabama, Mississippi, and West Virginia.
posted by terranova at 9:59 AM on March 1, 2009
Four red states: Texas, Alabama, Mississippi, and West Virginia.
posted by terranova at 9:59 AM on March 1, 2009
I don't understand why situation 3 is neutral. What is the criteria?
posted by BrotherCaine at 9:59 AM on March 1, 2009
posted by BrotherCaine at 9:59 AM on March 1, 2009
« Older This is what normal human genitalia look like | That's where I play tower defense games! Newer »
This thread has been archived and is closed to new comments
posted by fixedgear at 9:51 AM on March 1, 2009