yogi_Convert An Array Of Names Into UserNames (lowercase without any special characters)

Google Spreadsheet   Post  #2015

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-12-2016

post by: Robert Andrews:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/TD8PeY05ufo;context-place=mydiscussions
Convert name to username?

How can I take a cell containing a full name and turn it in to a username - ie. no symbols or spaces, only text, preferably lower case?

Remember, names come in all shapes and sizes, with punctuation marks, middle names, spaces and all sorts.

Thanks.

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

yogi_In Table A:K Count Number Of Instances Of Each Entry In Column K

Google Spreadsheet   Post  #2014

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-10-2016

post by: MSG Crane:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/umbbrIQPzVU;context-place=forum/docs
Using multiple "count() where" arguments in a Google Query
Team,

Hoping for a little help...  I am building a charts dashboard and one of the charts is a line chart depiction of the total number of records that meet the following criteria in column "K":  "Start Usage", "Midpoint", and "End Usage".

In the end, I would like the query result to show the following so I can graph each submission type with different lines on the chart:

|    A   |                     B                  |                 C               |                 D                   |

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

|Date | Count of Start Usage | Count of Midpoint | Count of End Usage |

I feel like the way to do this is three iterations of count() where K = "???" on column D.  I can get it to work with one iteration of "count() where" but I cannot figure out how to get it to work three times in the same query... 

This works:

select A, count(D) where K = 'Start Usage' group by A

Query as it stands right now with coloring for clarity (need help):

select A, count(D) where K = 'Start Usage' label 'Count of Start Usage', count(D) where K = 'Midpoint' label 'Count of Midpoint', count(D) where K = 'End Usage' label 'Count of End Usage' group by A

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

yogi_Transpose Cross Tabbed data Into DataBase Style Layout

Google Spreadsheet   Post  #2013

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-09-2016

post by: aaron urban:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/hIaF4nvc_Bo;context-place=forum/docs

Index and Match?

https://docs.google.com/spreadsheets/d/1aZKphjUWSy5KcLT8YlRx62e-SUzUCwR7MzOJDwot3DM/edit?usp=sharing

I am trying to re arrange the information in a table and am stumped as to which functions to call.  I am looking for a specific output.

Any help would be greatly appreciated.

Thanks in advance!!!
-------------------------------------------------------------------------- 

yogi_Compute Row By Row Count Of Number Of Students Registered In Classes Listed In Columns F:K

Google Spreadsheet   Post  #2012

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-08-2016

post by: shcptech:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/osHoc8Nbm2o;context-place=mydiscussions
Count number of non-blank cells with an array?
I saw this asked in another discussion, but the formula did not work for me.

https://docs.google.com/a/shcp.edu/spreadsheets/d/1N6xy4DkhHbP9qndwpSXefc4wjIfASNk1fpwmTgAEJGw/edit?usp=sharing

I would like the first column to count the number of non blank cells in columns F-K and put the result in column A.data in the cells will constantly be updating, and in fact, at some point the contents will be numbers, and I would want to add the values in cells F-K and put the sum in Column A.

Thanks for your help!

Tim

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

yogi_Compute Month By Month Amount Spent And Running Balance Remaining From Monthly Budget Amount

Google Spreadsheet   Post  #2011

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-08-2016

post by: David Leichter:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/JEbGnQTIGjg;context-place=mydiscussions
Show Purchases Totaled for Each Month SUMIFS

I want to track spending, and make sure I stay under my organization's monthly budget.

Sheet Example

As you can see in the example below, Column A contains the dates a purchase was made, Column C contains the total amount. Over in Column G, I have the months of the year and in column H is the total spend for each month.

In Column H I have a formula that works, but I wonder if there is a more elegant solution:

=SUMIFS(C$2:C, A$2:A, "<2/1/2016", A$2:A, ">12/31/2015")

This causes all of the purchases with a January 2016 Date to be summed next to January. I then cut and paste this formula down the column manually changing the date range in the formula each time.

I tried all the following, and either got an error or $0, as my answer:

=SUMIFS(C$2:C, A$2:A, "MONTH=1")

=SUMIFS(C$2:C, A$2:A, "<2/1/2016 AND >12/31/2015")

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

yogi_Compute Row By Row Dollar Amount Of item Ordered With Prices In Column B And Order Dates In C:I

Google Spreadsheet   Post  #2010

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-08-2016

post by: R SIC:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/AS4HB1gJlo8;context-place=forum/docs
need help with a pricing sheet
Hello all, I've been reading up on a lot of posts on here and have learned quite a bit.  I was wondering if there was an easier way for me to accomplish something.  I work at a bar, and have several reps that I order from.  I created sheets for my orders so I can track my spending.  I have prices in column B, and quantity in column C, and a total price in cell C12.  I was wondering if there was an easier way to calculate the pricing, rather than add (C3*B3)+(C4*B4) etc.  Something similar to the C12:G12 formula, but with the addition of multiplying the price?  This sheet is rather short, but some of mine are upwards of 50 products, and I am constantly adding more products each month.  I appreciate any help!

https://docs.google.com/spreadsheets/d/17e9jYjmKjUd4C2HeJBwDtod-zT6wuQNjeZUPQzBUZyk/edit?usp=docslist_api

(hope the link worked)

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

yogi_For Selected Truck And Corresponding Part Pull Valus For Latest Date And Mileage From Sheet 'MTTO'

Google Spreadsheet   Post  #2009

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Jan-05-2016

post by: Eusebio Garza:

https://productforums.google.com/forum/#!topic/docs/V5pJOf2kH4w;context-place=forum/docs
Hi, want to know, how is the best way to get the last result in a spreadsheet.

Hi, im want to know the last result in a table, i put the example in the image. i cant do this with vlookup because the problem have multiple criteria, i find in a website, that MATCH & INDEX can do this, any help? I need the last result of the trucks with "Aceite 15" part.

THANKS IN ADVANCE

Captura de pantalla 2016-01-04 17.38.49.png

11 KB