yogi_Present Statistical Data In Column Chart And Bar Chart

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

user hihi said:
how can i make a pivot table? I have to make a graph with how many male, female, and both sexes had different types of leukemia in 1997 and 1999.
The data is shown in:
https://docs.google.com/viewer?a=v&pid=forums&srcid=MDIyMTM4Mzk3OTYzNDIwOTIzNTEBMDYyMTc3NTk2NDAxODE1MzEzNzcBMTM4ODk0NDcuMjU1MS4xMzI4NDc4OTQ3MDAxLkphdmFNYWlsLmdlby1kaXNjdXNzaW9uLWZvcnVtc0B2YnljMjIBNAFnb29nbGVwcm9kdWN0Zm9ydW1zLmNvbQ
-----------------------------------------
following is a solutionto the problem ...
the data is chartable as presented -- I have created a Column Chart associated with tabular data in Sheet1, and a Bar Chart associated with tabular data in Sheet2

yogi_Set Up Time Sheet For Specified Month And Year For Multiple Entries Per Day

Yogi Anand, D.Eng, P.E.                                         Google Spreadsheet                            www.energyefficientbuild.com
user dooc said:
Help with ARRAYFORMULA
Hi,
If someone could help it would be much appreciated. English is not my primary language but i will try to explain as best as i can.
I have found this formula:
=ARRAYFORMULA(IFERROR(MID( TEXT( VALUE( F8 &"-"& F7&"-"&ROW(A13:A33)-12); "yyEEE");3;3)))
basically, i enter month and year (2 for February and 2012), in cells F7 and F8 and it automatically populates from row A13 to row A46 with names of days for that month.
That's my biggest problem, is it possible to change this formula so it is not populating rows continuously ? I need to have name of days for example in cells A13, A17, A21..... .
-----------------
I suggested the OP try the foolowing formula:
=ArrayFormula(if(mod(row(A13:A46),4)=1,IFERROR(MID( TEXT( VALUE( F8 &"-"& F7&"-"&ROW(A13:A46)-12); "yyEEE");3;3)),""))
However the goal posts seem to have been changed on this SuperBowl Day as noted in OP's update
-----------------
update
Hi yogia,
Thank you for your effort it is much appreciated, but i'm sorry to say it is still not what i need. With your formula day names are not continuously populated. I have attached example of what i need, and i have entered names of days where they should be for one week, but i need it to be automatically populated for whole month.
Hope it will be useful to better understand my problem.
https://docs.google.com/viewer?a=v&pid=forums&srcid=MDIyMTM4Mzk3OTYzNDIwOTIzNTEBMDUwMjc3Nzg5MTA1MjY1Mzc2NTEBOTg5NzM1LjMzMzYuMTMyODQ0MTU5OTMzOC5KYXZhTWFpbC5nZW8tZGlzY3Vzc2lvbi1mb3J1bXNAeXFvZTEyATQBZ29vZ2xlcHJvZHVjdGZvcnVtcy5jb20
------------------------------------------
Well, let us see if I hit the goal this time in regard to solution to the problem

yogi_Match A Specified Phrase In Column A of SpreadsheetB And Pull Data From Matching Row In Column F

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

Ok so, I have a friend that has their own Spreadsheet. What I would like to do is, have my spreadsheet search theirs in the A column for a specific word. Once it finds that word, I want it to return the value in the F column, same row. Example:
Search A column for "Crash". Once it finds "Crash", return F column of the same row, which is "20".
Any idea how I do this?
------------------------------------
following is a solution to the problem

I pulled into SpreadsheetA (poster's spreadsheet) the required matching data from SpreadsheetB (poster's friend's spreadsheet.

yogi_Count Number Of Occurences Of Dates As Labels In Style 01/01/2012 Across A Row

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

user sticknrudder said:
For example:
A1 A2 A3 ..... A7
Person    Location A.            Location B        Totals
John   1/1/12,1/2/12,1/5/12    1/7/12,1/12/12         5
Jane
Alan
Alana
...
...
...
All I want is a sum of the number of occurences of "*/*/*" in each cell, summed in that last row. Sorry, this is really basic, but I cannot figure this out and it's killing me.
---------------------------------------
following is a solution to the problem

yogi_Tryouts_20120203h1-fr-Publising List View

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

yogi_Group The Entities In A Column By Specified Categories And Present The Breakdown Graphically

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

use annetteit said:
hello,
i've done a questionnaire and i have a column with the age of all the people that have answered this questionnaire.
i would like to group the ages of the people in 3 categories ranging from 20 - 35, 36-50 , 50+
how can google docs sort the column with the ages of people into these 3 categories so i know how many people there are in each categories and can see it graphically?
---------------------------------
following is a solution to the problem

yogi_Create List Of Employee And The Related Amount For Each Employee's Individual Sheet

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

user beejizzle said:
I have this Summary sheet with names in column A of my workers, each worker has a own Sheet with his name. And it list a amount from a cell in that sheet
If I have the sheets "Summary", "John", "Josh", "Mike" then the column a in summary would be (and column B would have the amount):
John John!B1
Josh Josh!B1
Mike Mike!B1
Now if I add one new sheet is it possible to have it autoadded below "Mike" ? I know I could enter a pre-added value but then I couldnt name the sheets to a specefic name cause I wouldnt know in advance. Can I use sheets GID somehow or do I have to like pre-add like 20 sheets for coming workers and pre-name the sheets to like Worker1 , Worker2 etc?
Hope you understand
----------------------------------
following is a solution to the problem