yogi_Put Data From A Google Form Into Different Sheets Depending On Answer

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

JesterJef said:
Data from a form to be divided into 5-6 different sheets depending on answer
I have a Form that filters all answers into one sheet. From there I need to divide out the data (Name, Phone, etc) based on the answer.
Ex. Joe fills out the form and he answer that he wants to attend Friday, he adds his phone number and how many will attend with him. Bill does the same but wants to attend Saturday.
I need to divide out all those attending the event on Friday from those attending Saturday, etc.
How do I put all my Friday answers into one sheet and the Saturday answers in another?
-----------------------------------------------------------

yogi_Extract Unique Content For Each Respondent Submitted Via Google Form

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

jacrvr said:
Is there a formula to filter and eliminate duplicate data across multiple columns?
I am a teacher that is trying to design a spreadsheet to help assess student writing. The spreadsheet consists of seven columns:
(A -Timestap); (B-Student Name); (C - content); (D- organization); (E-word choice); (F-sentence structure); (G-conventions)
When data is added to the spreadsheet through a form, it looks something like this:
7/5/2011 1:31:31 Blake Including a conclusion
7/5/2011 1:09:41 Justin Establishing a purpose
7/5/2011 9:45:35 Justin Establishing a purpose, Narrowing down topic, Including details
7/4/2011 23:07:33 Katie Establishing a purpose, Sequencing ideas, Including million dollar words
I would like to have a formula that will take a students' name from column B and match it with data entries pertaining to that student from columns C through G. However, I am hoping not have repeated information. Thus, the output for Justin (from the sample data above) would look something like:
Justin Establishing a purpose, Narrowing down topic, Including details
Rather than:
Justin Establishing a purpose, Establishing a purpose, Narrowing down topic, Including details
----------------------------------------------------------------

yogi_Compute Stats For Tips Earned By Morning, Evening, Day Of Week

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

laxifist said:
How do I create a cell that determines the average tips earned on a certain day of the week?
I have a spreadsheet that tracks tips earned at my job. I would like to be able to determine the day of the week that averages the highest tips. The second question is whether a morning or evening shift pays the most on average. To go even further would be to determine a combination of both of these! I have "day of the week" and "morning/evening" shift notated in the row with other pertinent data. I would like to track this on a monthly basis because results should vary based on the time of year.
Thanks for explaining how to do this!
-----------------------------------------------------------

yogi_Search In Multiple Columns And Post Result In Another Column

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
numlock said:

I am going over phone usage and and am trying to figure something out.

I have free service within my company and 5 friends but on the printout from the company it dosent differentiate between phone calls to friends/company and others.
In column B I have the type of service
In column D I have the phone number that called/texted
In K2:K6 I have the list of friends and in L2 I have the other number within the company.
What I want is the formula to look through column D and column B. If the service is "cell phone" and the phone number is in K2:K6 enter the value "friends" in column J. If it is in L2 I want the value in column J to be "company". If the number is not in either of those two ranges I want it to use what is in column B.
Is this possible?
---------------------------------------------------------

yogi_Compute Sigma Code Of Numerals In A String

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

sigma code of a numeral in a single cell
is there a way to add the numerals in a number in a single cell?
For example, I have the number 2,345. I'd like to add the individual numbers together: 2+3+4+5=14
THEN take that '14' and get 1+4 =5.
I'm taking large numbers generated by my spreadsheet and getting their sigma codes to do a little prime number research
---------------------------------------------------------

yogi_Sum Up Two Columns And Compute Running Total

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

Hi eddieg71 said:
trying to put one set number in one column 2column either debit or credit and 3rd column sum
-----------------------------------------------------------

yogi_Highlight Months With 5 WeekEnds In Specified Years

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com

Computing Months With 5 WeekEnds
In this solution I used the logic that for a month to have 5 WeekEnds,
1) the first day of the month must be a Friday
and
2) the month must have 31 days in it
It turns out that July-2011 has 5 WeekEnds for that extra rest and relaxation this summer -- so ENJOY!