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!
posted by daver (15 comments total)

This post was deleted for the following reason: Oops repost to ask mefi -- mathowie



 
what
posted by fixedgear at 9:51 AM on March 1, 2009


yikes
posted by zoomorphic at 9:52 AM on March 1, 2009


daver, I think you want AskMe, down the hall.
posted by GrammarMoses at 9:53 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


Wrong color!
posted by lee at 9:53 AM on March 1, 2009


You forgot the ask on your metafilter.
posted by Memo at 9:53 AM on March 1, 2009


post owie
posted by NoMich 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


The pictures of boobs are so awesome. Thank you!
posted by KokuRyu at 9:56 AM on March 1, 2009


NOT-BLUIST
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


metafilter: A hint please? A clue?
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


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


I don't understand why situation 3 is neutral. What is the criteria?
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