yogi_Pull Calls From Log That Meet Specified Criteria

Google Spreadsheet   Post  #2252

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

question by: Sam Larimer

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

Need to filter results based on exclusion arrays (multiple strings)

SPREADSHEET IN QUESTION:

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

The title pretty much explains it. I am failing to have a manual import ignore certain strings if a specific contact was called or if the call was not connected. The "exclusion arrays" may change in nature and size.

Initially, I was playing around with the following

=Filter('All Calls'!D3:L50,

'All Calls'!F3:F50<>'All Calls'!A3:A12,

'All Calls'!J3:J50<>'All Calls'!B3:B7)

which clearly does not work as several of the filtered contacts are on the exclusionary array or it eliminates desired results. Feel free to edit space on tab "Location A" and thanks, in advance, for the help.

yogi_SetUp A Single Chart To Show Dynamically Via A dropDown Data For WeekNumber WeekDay Or AllDays

Google Spreadsheet   Post  #2206

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

question by Sam Larimer:

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

Using Data Validation for dynamic chart with different size range

I may be blindly searching for a how-to that does not exist, but is it possible to use data validation, formula in charts, dynamic ranges, etc. to create a dynamic chart that measures the same quantities but over different lengths of time?

Document in Question: Chart w/ Dynamic Range

Basically, I'm attempting to create a single chart that measures a float ratio and displays a month's data points by:

• date in month
• day name
• weekly average

However, all this data in one place would be very cluttered and/or useless for comparison. The next best option in my mind is a data-validation to choose which data range is pulled for the chart.

Chart type isn't too important. I have faith in you experts, but let me know if this is a wild goose chase

yogi_In Reference To Column A Provide Clean Names In Column C Considering Roster Names In Column I

Google Spreadsheet   Post  #2204

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

question by Sam Larimer:

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

CONDITIONALS: Replace out-of-order/cluttered names with clean names from given roster

An exported report gives names that contain extra characters, names out of order, or both. I need the names to be replaced in correct First Name Last Name order.

Document in question: Names in order

If column A contains strings of names and column I contains a cleaned up roster, reorganize and remove non-letter characters. Return "clean" name in column C.

The spreadsheet contains a goal return (column E) and match check (column F)

So far, I've only been able to reorganize names if they are in the form BBBB AAAA with only one space. The following issues still exist:

• Names that contain extra characters (1 or 2 plus signs) at the end of the last name field. "B++ A" should be "A B++"
• Names that contain multiple words in surname are reorganized from "B C A" to "C A B", but they should be "A B C"
• Optional: Names that are reported as "LastName, FirstName" reorganize as "FirstName LastName"...basically, I don't need something that only ignores plus signs. It should ignore any extra characters.

Now for the challenge. Avoid Google Script. I am extremely amateur at this stuff still and cannot code to save my life. This formula will need to be used and replicated in the future by other users in various applications.

Here's what I have currently. Feel free to scrap and start from scratch if it's as ugly as I think it is.

=IF(ISBLANK(A2),
A2,
IF(ISERROR(MATCH(A2,I:I,0)),
IF(ISERROR(MATCH(MID(A2&" "&A2,FIND(" ",A2)+1,LEN(A2)),I:I,0)),
A2,
MID(A2&" "&A2,FIND(" ",A2)+1,LEN(A2))),
A2))