yogi_Pull List Data Row By Row For Corresponding ID Entry From Table In Sheet Named SourceData

                                          Google Spreadsheet   Post  #1425
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov 20, 2013
question by lsen (http://productforums.google.com/forum/?zx=bqadbhvesqoa#!mydiscussions/docs/47O-vkB-Dzw)
Arrayformula with Concatenate and filter, but problem with Filter


Found a small hiccup.

If a number is entered that is not on the source list, it is treated as if it wasn't there. but will populate the information of the next item that is on the list.

ID	List
1004	11/7/2013: Found Keys 11/8/2013: Called Client 11/9/2013: Client Called Office 11/10/2013: Client received Keys 11/11/2013: Played Games 11/12/2013: Victory Lap
56	11/7/2013: Contract Created 11/8/2013: Contract Verified 11/9/2013: Payment Verified
1	11/11/2013: Started to Run 11/12/2013: Ran 1 Mile 11/13/2013: Ran 2 Miles 11/14/2013: Bought supplies
1003	11/7/2013: Contract Created 11/8/2013: Contract Verified 11/9/2013: Payment Verified
1001	11/10/2013: Payment Received 11/11/2013: Contract Verified
1003	11/7/2013: Found Keys 11/8/2013: Called Client 11/9/2013: Client Called Office 11/10/2013: Client received Keys 11/11/2013: Played Games 11/12/2013: Victory Lap
1002	11/7/2013: Found Keys 11/8/2013: Called Client 11/9/2013: Client Called Office 11/10/2013: Client received Keys 11/11/2013: Played Games 11/12/2013: Victory Lap
1004	11/12/2013: Walked Home
1004	11/7/2013: Found Keys 11/8/2013: Called Client 11/9/2013: Client Called Office 11/10/2013: Client received Keys 11/11/2013: Played Games 11/12/2013: Victory Lap
1005
1004

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

yogi_Count Instances Of Clerks And Shipping Employees Working In Specified Shifts From Coded Data

                                          Google Spreadsheet   Post  #1424
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov 19, 2013
question by JFC1111 (http://productforums.google.com/forum/#!mydiscussions/docs/ZcGR3JpsmYA)
I would also like to be able to count the number of positions filled for each shift, and include this information in one cell I think using the concatenate function (clerks/shipping/other) would look like 4/2/1. What I can't wrap my head around is that some of the codes will be the same for each position, as well as codes that are for sick and vacation etc(which should not be counted). My thinking is that the formula will lookup what the "position code" is, and reference the corresponding date cell to see if a "shift code" is present. If true then count all for that "position code" and do it again for the next "position code" and combine all the totals using concatenate. 

Thanks so much

Jason

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

yogi_Count Instances of Names in Column A For A Specified Date (or all dates) In Column B

                                          Google Spreadsheet   Post  #1423
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov 17, 2013
post by Clare-Noel Holdinghaus question by ajta@0316 (http://productforums.google.com/forum/?zx=emvk7dhbcu1y#!mydiscussions/docs/oMozBKn-1mY)
ive read your post.. will this also work on TIMESTAMP, but i just want to filter the EXACT DATE regardless of the time?

10/29/2013	ubert
10/28/2013	ubert
10/30/2013	jessica
10/30/2013	ubert
10/30/2013	susan
10/30/2013	grace
10/30/2013	Aguilar
10/28/2013	ubert
10/31/2013	jhimpeter
10/26/2013	jessica
10/26/2013	angela
10/28/2013	ubert
10/28/2013	ubert
11/1/2013	marc
10/31/2013	jhimpeter
10/26/2013	jhimpeter
11/1/2013	jessica
11/1/2013	marc

Count how many times the name appeared on a specific date.. expected result will be something like:

jessica	4
marc	8
Ubert	16
Jhimpeter	5

may first idea would be:

given COL A = timestamp

        COL B = username

D2=unique(B:B)

E2=countif(B:B, D2)

however this would filter all entries regardless of the date... I would like countif based on specific date..

thanks!!

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

following is a solution to a bit more generalized problem

yogi_Compute Total Hours Worked Day By Day For All Shifts With Coded Info For Shifts And Hours

                                          Google Spreadsheet   Post  #1422
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov 15, 2013
question by JFC1111 (https://productforums.google.com/forum/#!topicsearchin/docs/after$3A2013$2F10$2F31$20AND$20-is$3Aduplicate$20AND$20-is$3Aresponded%7Csort:date/docs/ZcGR3JpsmYA)
Scheduled versus Actual Hours Worked

Its all explained in the file

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

Thanks

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

yogi_Compute Average Per Specified Criteria But Return N/A If All Related Values To Be Averaged Are N/A

yogi_Extract Entries In Separate Lines For Each ID From Table Of IDs And Entries In sheet named 'Expanded 2'

yogi_ Convert Longitude In Degrees And Minutes To Degrees and Thousandths Of Degrees

                                          Google Spreadsheet   Post  #1419
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Nov 13, 2013
question by superflycasanova (http://productforums.google.com/forum/?zx=3p34c7g6hlry#!category-topic/docs/spreadsheets/wDa38owgrAE)
converting a degree and minute longitude to a decimal degree longitude
I've got a list of longitudes that look like this in a spreadsheet

40°55.26 N

and I want to convert them to decimals

40.921

Is there a way of automating this procedure e.g. take the numbers before the ° add the decimal point and then add the numbers after the °/60 (and get rid of the N)?

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