yogi_Pull Abbreviations From SpreadsheetA And Present Them As Terms Based On A Lookup Table

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

user1294 said:
How to replace multiple strings in imported data range??
Hello!
I have 2 spreadsheets: one with raw data table and the other empty.
raw data has abbreviations (Abs, AVRG, TTL etc.) which I need to be full readable words (absolute, average, total etc.) in the second (empty) spreadsheet.
I'm using importrange function
maybe I should use script to create custom function??
please help, I'm a newbie))
-------------------------------------
following is a solution to the problem

yogi_Sum Up And Display Expenses By Type

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

user surfjabroni said:
Formula for expenses, count, countif?
Hi folks I am a total newbie to this so excuse my lack of knowledge:
I have the expenses name listed in column A (ie comcast phone, Radisson etc..) their type in Column B (ie communications, mileage, hotel etc...) and the cost of each item in column C.
I am looking for a formula that looks for all items that are "communications" and sums the total. This needs to be repeated for expenditure type.
Thanks in advance. I hope I made myself clear :)
--------------------------------------
following is a solution to the problem

yogi_Recreating Form For Entity Evaluation Program For Select Answers

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

user ms.sudderth said:
I am trying to recreate these forms that teachers created and now I want to email the completed recreated forms.
---------------------------------------
following is a solution to the problem based on simulated data as in your spreadsheet. In this solution I chose to do the following:

1) not display (withhold) the information regarding Attendance
    so the response to that question will be blank

2) in regard to Contact Info ... I provided a default answer:
    on file

yogi_Pull Data For When Bills Are Due Between Biweekly Pay Periods

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

use Xenopule said:
How can I pull data based on day of the month
I'm working on putting my monthly budget into Docs, and I want to do something to this effect:
•Page 1: An overview of what bills are due this pay period (every two weeks)
•Page 2: A list of each bill, how much is due, and the day of the month they're due on
I want to be able to pull the appropriate data from Page 2 to Page 1 given the two weeks between paychecks.
Optimally I'd like it to automatically adjust the two weeks (payday is the 9th, let's say, and it automatically pulls the dates between the 9th and 22nd without me changing any data), but I'm willing to have a dedicated cell that I punch in a new date and it calculates from there (or even two cells to calculate between those two days).
I'll happily expand on any confusion!
--------------------------------
following is a solution to the problem:

yogi_Extract Details Of The Most Recent Game Played From Data In Different Spreadsheets

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

user jkelley said:
Show only the most recent date in a spreasheet
Ok here is something kind of crazy. I have multiple different sheets that contain scores for sports games in the following format.
Date, @/vs, Opponent, Score
The first 3 columns are pre-filled at the beginning of the season and the score field updated as we go. The different sheets are all embedded in a webpages for public use. Now what I want to do is have the latest score show up in a separate sheet combining all the sheets together. For instance when I update the score today the "summary page" shows the new score I just added and the latest scores from the other sports.
Any thoughts?
Thanks
--------------------------------
following is a solution to the problem ... where I have merged the data from different spreadsheets and then queried the data for the most recent game actually played

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