yogi_Create A Computed Column For Weight Loss In Column F For Successive Weekly Entries In Column E

                                          Google Spreadsheet   Post  #1270
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul 03, 2013
user Paul Deans (http://productforums.google.com/forum/?zx=en1uc39g9p3s#!category-topic/docs/spreadsheets/AUs2BaP79XI)
Weight Tracker Help and Ideas
Hi All,

Trying to put together a Weight Tracker "sheet" that will show progress as the weeks go by so weight and inches loss can be tracked weekly.

• I want the spreadsheet to utilise Green for weight loss and Red for weight gain as background colour and this would show on the sheet automatically upon data entry in column "C" and "D". This would be reflected on the weight and inches measurement from the week previous any ideas on how to get a formula to successfully do this?

I have shared the doc below and comments can be left.

Weight Tracker

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

yogi_Customized Use Of Filter Function Where No Selection Of A Parameter (left blank) Means All Choices

                                          Google Spreadsheet   Post  #1269
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul 02, 2013
user Tiago D'Ambrosio (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/kroiunx8sHo)
Filtering with multiple criteria
Hi there,

Tanks in advance for any help.

I'm trying to create a filtered version of a database, with multiple conditions.

The thing is, not all the entries of my database necessarily have all its fields filled. When a cell is empty, the entire entry stays off the filter, even if it meets all the criteria.

What I'm trying to do is what the D-functions do well: when I create a criteria array, the blank cells are ignored, as if there's no condition for that field.

Here is an example document I created:

https://docs.google.com/spreadsheet/ccc?key=0ApJu9nfCCTsNdGh3RzR1MWhYaGszOVQxMlZUY0JyeUE

The first sheet is the data itself.

The second one is the filter I'm trying to create.

The third one is an example, using a D-function: I want to do exactly what I did with this DCOUNT function, only that I don't want just the number of entries, but the whole entries themselves.

Hope someone can help me.

Cheers -- Tiago

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

I don't think it is a question regarding Filtering With Multiple Criteria ... it has to do with customizing the use of FILTER function so that no parameter selection (leaving it blank) means all values for that parameter

yogi_Start New ID Number In Column K From The Beginning On Cell Value Change In Column J

                                          Google Spreadsheet   Post  #1268
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul 02, 2013
user AlexEmbryo (http://productforums.google.com/forum/?zx=aif3093lky7l#!mydiscussions/docs/nVIeoFgcE_c)
Starting new ID numberfrom the beginning when the cell value change
I have a query function that generates the small table like this (Column A):

ColA  ColB

Text1  100

Text1  101

Text1  102

Text1  103

Text2  100

Text2  101

Text2  102

Text3  100

Text3  101

Text4  100

Text4  101

Text4  102

Text4  103

Text4  104

Text4  105

Text4  106

etc..

I would need to find an arrayformula or something else that would generate the ID number to column B. This ID number should start from the 100 every time when the text changed in column A. When I change some value in this Query, these ID numbers should be generate again because texts will change.

Of course I can use IF function, but I dont want to use it. Then I would need to delete some of them, when the column length is smaller.

Any ideas?

Alex

---

Hi Yogi,

This is the file (copy from the original).. https://docs.google.com/spreadsheet/ccc?key=0AkMVQyM7UcFddGVEaVFMX0VkaS1QZElQSFJIdnAwOHc&usp=sharing

In the last sheet is the problem. Cells are marked with yellow.

How to generate ID numbers to column K? This number is needed when there is text in column J. IF its empty, no number. The same name is mentioned only once in one "group", because Query will order them. I need numbering starting from 100 and then 101,102,103 etc. The numbering needs to start from the beginning (100) always when the name changed in column J.

Cheers!

Aleksi

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

yogi_Compute Total Amount By Weekday Based On Multiple Criteria

                                          Google Spreadsheet   Post  #1267
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul 02, 2013
user Corporate Analyst (http://productforums.google.com/forum/?zx=aif3093lky7l#!category-topic/docs/spreadsheets/NdbQ7KNuTH4)
use a date format as a day of the week in if criteria
Hi,

I have a list of date, value,etc and on a separate sheet i have to add all the values for Mondays.

Thanks.

---

Dear YogiAnand

Thank you for your revert.

I have shared a link for a sheet. under that tab called Date Calculation. 

https://docs.google.com/spreadsheet/ccc?key=0AuZwIvdMK8D5dE9IcFNsWHVWRGFRR2NrcGpNNlhhYnc&usp=sharing

Also on another topic i'm trying to merge multiple documents(7Sheets) into one sheet. From the advise i got i have entered the formulas into the master Sheet. Can you see if I have done so correctly.

I really appreciate your advise

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

yogi_Using Query Function With Names Containing Single Quote (such as Mary O'Connor)

                                          Google Spreadsheet   Post  #1266
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul 02, 2013
user Anthony Ubelhor (http://productforums.google.com/forum/?zx=aif3093lky7l#!category-topic/docs/spreadsheets/GuksEmNhKOU)
How do I put quotes w/in quotes in a cell formula? (')
'm getting a value error because of the single quote in the name O'Connor.

query(importrange("key","Current Students!A2:G997"); "select Col4,Col5,Col6,Col7 where Col6 contains 'Mary O'Connor' ")

Is there an equivalent to the html ' that I can insert in this formula?
----------------------------------------------------------------------------------------------------------------------------------------------------
I don't think it is a question on how to insert ' in names ... but rather how to QUERY data that has names containing ' (which is a character that is used in the select option of QUERY operations)

yogi_Setup To Record Sum Of Sales By Store Automatically And Dynamically

                                          Google Spreadsheet   Post  #1265
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul 01, 2013
user cossieWill (http://productforums.google.com/forum/?zx=6rcla7maju2x#!category-topic/docs/spreadsheets/hJJ7sa1Gt6A)
Query a range - group by column 1 and sum column 2

Hiya All

I cant work out how to create a overview for a simple data file I have.

I need to be able to group by the "store" and then count(sum i think) the values in "order total". More stores could be added, so having this part dynamic would be great.

Here is an example of the data and the desired result.

https://docs.google.com/spreadsheet/ccc?key=0AltNukvJFRJidFFSZ2htTlU5R1FQNE5sRnI0YlR2dUE

Thanks in advance

Will

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

yogi_Determine The Date Of The Last Specified Weekday N (+ or -) Months From Reference Date

                                          Google Spreadsheet   Post  #1264
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jul 01, 2013
user bobbaz (http://productforums.google.com/forum/?zx=6rcla7maju2x#!category-topic/docs/spreadsheets/WAHFE6fDYj4)
Find the following day of the week
I have searched a bit but I am unable to find a solution....

I am inputting a date (in this case the last day of the month) and want the next cell to provide me the date of the first Thursday of the following month.  Can someone point me in the right direction?

Thanks!

---

Edit:  That should read the last Thursday of the following month

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

following is a solution for a bit more generalized problem