yogi_Tabulate Letter Groups 'A' 'B' 'C' 'D' Etc Assess Groups 'B and C' 'C and D' 'D and E' And So On

Google Spreadsheet   Post  #2509

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Sep-08-2018

question by: Bram D Maat
https://productforums.google.com/forum/#!topic/docs/BMGttzjKSN8;context-place=forum/docs
IFS functions that adjust
Hello All,

I am a teacher, the students work in groups. Called Group A, B, C and D. The all create a lab report for an experiment.

I want the Groups to assess the work of other groups. 

Group A assesses Group B and C.

Groep B assesses Group C and D.

Group C assesses Group D and A.

Group D assesses Group A and B.

I can do this with IFS functions but the problem is this. See the example: 

https://docs.google.com/spreadsheets/d/1MUPiCfTQQWaZJ2Q7vEtTZWFuUpJzJ4CtGAnTgDuQd7k/edit?usp=sharing

The problem is this:

If I have more groups, let's say A,B,C,D and E then I want the function to understand that Group C needs to assess Group D and E instead of Group D an A.

I am not really clear how I set something like this up in a spreadsheet.

Hop to hear from you.

Bram

yogi_Rearrange Entries From 'Data Table' Of Open-Ended Number Of Columns And Rows In 'RowNo - Col No' And 'Values' Table

Google Spreadsheet   Post  #2508

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Sep-07-2018

question by: BPBC Tech
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/SiD3o67xGpk;context-place=mydiscussions
Calculating number of form submissions in Sheets for each individual

I am looking for help on how to query imported data, concatenate into a list in col1 and date sort by the values. Dataset example is the top table and the result i am looking for is the lower table. Thanks for any insight! 

yogi_Rearrange Entries In 'Data Table' in 'RowNo - Col No' And 'Values' Table - 2

Google Spreadsheet   Post  #2507

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Sep-06-2018

question by: BPBC Tech
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/SiD3o67xGpk;context-place=mydiscussions
Calculating number of form submissions in Sheets for each individual

I am looking for help on how to query imported data, concatenate into a list in col1 and date sort by the values. Dataset example is the top table and the result i am looking for is the lower table. Thanks for any insight! 

yogi_Rearrange Entries In 'Data Table' in 'RowNo - Col No' And 'Values' Table

Google Spreadsheet   Post  #2506

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Sep-06-2018

question by: BPBC Tech
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/SiD3o67xGpk;context-place=mydiscussions
Calculating number of form submissions in Sheets for each individual

I am looking for help on how to query imported data, concatenate into a list in col1 and date sort by the values. Dataset example is the top table and the result i am looking for is the lower table. Thanks for any insight! 

yogi_Tabulate Names And Number Of Times Registered From Data In Another Tab

Google Spreadsheet   Post  #2505

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Sep-03-2018

question by: Pamela Loveland
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/SiD3o67xGpk;context-place=mydiscussions
Formula help with a Dynamic list with concatenate and sorting from an imported data rangeWe are starting to use Google Forms to let people sign in to our run club meets. It has a very simple first and last name text entry box, and that's it. I would like to keep a running calculation of how often someone has signed in on a separate sheet in the same workbook, keeping in mind that someone may sign up slightly different sometimes. So maybe I'm Pamela one day and Pam another day - I'd want them both to count. So I'm thinking that it needs grouped by last name on exact match, then on first with a SQL type 'like', ie: where firstname like 'Pam%' or something. Then it should count those entries in that group. I've no idea how to go about this in the spreadsheet the form exports to, plus it'd have to use the same formula all the way down the columns as more and more rows get added. Help?!

yogi_Pull Stats Based on Data From Latest Date In Teacher!A:A

Google Spreadsheet   Post  #2504

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Sep-02-2018

question by: TSHIRES
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/LW6IGJSwRa4;context-place=mydiscussions
Nesting Formulas

I'm really new to this but I have been using =INDEX(A:A,COUNTA(A:A),1) to get the last value in a column and =Sheet1!A1 to get data from another sheet. Now I want to combine them.  I need to get the last value on the previous sheet and place it in my cell. I tried nesting them like this:

=Sheet1!A1(INDEX(A:A,COUNTA(A:A),1) ) 

and like this 

=INDEX(Teacher!BH:Teacher!BH,COUNTA(Teacher!BH:Teacher!BH),1))

and

=INDEX('Teacher!BH':'Teacher!BH',COUNTA('Teacher!BH':'Teacher!BH'),1)

but none of them worked. 

Here is my project. The data on the first two pages is collected with a form and then the thrid page is a report template that I can print out for parents.

yogi_Query Data Pivot By Year And Month Based On Timestamp Column

Google Spreadsheet   Post  #2503

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Sep-01-2018

question by: Martin Konstantin Herrmann
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/xyRkN7MkGXw;context-place=mydiscussions
2 Years of seperate Data, pivot by Year and month
Hey Folks,

so here is the Situation.

I have a form where ppl enter data, basically members that join our club.

There are timestamps on when each member joined and who recruited them.

So far so good.

I managed to get a pivot working to show me the simple count on each timestamp:

=QUERY('Rekr Rohdaten'!A:N; "select J, COUNT(J) where J is not null and not(J) contains 'Gründung' group by J pivot month(A)+1"; 1)

However the problem here is month(A)+1 does not care which year it is.

I'd like to pivot for yyyy-mm instead of only mm or yyyy but i have been unable to get the exact thing going.

However i dont want to just cut the timestamps on the source table since i need the dd as well for other queries.

=QUERY('Rekr Rohdaten'!A:N; "select * where J is not null and not(J) contains 'Gründung' format A'YYYY-MM', C'YYYY-MM'"; 1)

and then use

=QUERY('t5'!A:N; "select J, COUNT(J) where J is not null and not(J) contains 'Gründung' group by J pivot A"; 1)

which basically pulls out the date from the first query (since i haven't figured out how to nest these queries) it still somehow knows the format and adds back the days.

i tried pivot dateformat(A;'yyyy-mm';1) but this seems not to work either as it requires a day.

Anyone knows a solution to pivot a timestamp in the format of yyyy-mm so the years are split?

Thanks (: