yogi_CrossTab Judges Scores By Contestant From A List

                                          Google Spreadsheet   Post  #1019

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Feb 07, 2013

post by user: Timothy Green said:(http://productforums.google.com/forum/?zx=jkl1wboolo4r#!category-topic/docs/spreadsheets/X_0GmKlRUhE)
Best way to re-organize data generated by a form?

Hello,

 

I'm trying to generate a score report for an Essay Contest, and am very new at formulas/functions/data sorting.

Each contestant had their essays read by three different judges.  The judges selected "Yes" or "No" to the question - "should this essay move on to the next round of judging?"

 

So, each essay should get three "Yes" or "No" scores - and I need to find out a way to display their scores so my supervisor can quickly tell who's moving on to the next round and who isn't.

The problem is that the spreadsheet has been populated by the form with these Columns - A: "Contestant Name", B: "Judge's Name", C: "Score". 

 

So I have a report something like this:

 

  A                B               C

Carl            Jane         Yes

Cassie        Jane         No

Connie        John        No

Caleb          Jim          Yes

Cam           Joe           No

Cassie        John         No

Caleb          Jill            Yes

Caleb          John         No

Cassie        Jill             No

Cam           Jim            Yes

Cam           John          No

Carl            John          No

Carl            Jill              Yes

Callie          Joe            No

...etc

 

Is there a formula that will allow me to quickly count up and organize the data to see each Contestant with their scores in the same Row?

For example, can I somehow transpose the data from these columns into columns like this?

 

A: "Contestant"  B: "Judge 1" C: "Judge 1's Score"  D: "Judge 2"  E: "Judge 2's Score"  F: "Judge 3"  D: "Judge 3's score"

 

Many thanks for any help you can offer...

 

Tim

-----------------------------------------------------------------------------------------------------------------

following is a solution to the problem

yogi_Compute Row By Row Sum Of Multiple Product Values Based On Their Specified Costs

                                          Google Spreadsheet   Post  #1018

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Feb 07, 2013

post by user: Jeremy816 said:(http://productforums.google.com/forum/?zx=jkl1wboolo4r#!category-topic/docs/spreadsheets/slUf9tEhfMo)

Applying a formula to new rows added by forms

Good morning!

I have a spreadsheet that is going to be used to keep track of orders that are submitted through a form.

I'm trying to find/create a formula that would automatically sum up values in a single row and multiply those values by the cost, thus getting a price for the order that was just submitted.

I've tried looking into the =arrayformula() as well as =query() but I can't seem to get it to work for specifically what I need.

Any help would be greatly appreciated!

Thanks

Jeremy

---

	Order Total	Timestamp	Username	Product 1	Product 2	Product 3	Product 4	Product 5	Product 6

	$350.00	2/6/2013 12:36:12	test	0	1	2	3	4	0
	$140.00	2/6/2013 14:49:05	test	1	3
	$350.00	2/6/2013 21:57:45	test	1	2	3	4	0	0
	$5,950.00		test	14	50	50	40	10	6

This is the general layout of what I have.  I'm unable to publish to people outside of my work domain.

I also don't have access to Adam's sheet on mmult() usage.  I've also looked into that mmult() in conjunction with the arrayformula() but I'm afraid it's a bit complex for me.

------------------------------------------------------------------------------------------

although the use of MMULT function for a problem like this is more systematic ... in the following solution I have also included a formulation without using the MMULT function