Tuesday, November 20, 2012

yogi_Synchronize Gold Spot Values From Data Set 2 With Data Set 1 Dates

                                          Google Spreadsheet   Post  #877
              Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Nov 20, 2012
user mqoue said: (http://productforums.google.com/forum/#!category-topic/docs/spreadsheets/TKlUbRjYFqc)
Merging two seperate sets of time data into one

Hello,

I'm trying to match up dates from store sales to the spot price of gold in order to see what level of correlation exists. I currently have two sets of data: 1) Dates and Total Sales for the day and 2) Date and Close Spot Price of Gold for the day

The issues I'm having is that some of the dates in data set 1 do not exist in data set 2 

All I'm trying to do is match up the Close Spot Price of Gold from data set 2 with the Dates and Total Sales in data set 1

Here is the link to the spreadsheet:

https://docs.google.com/a/mqoue.com/spreadsheet/ccc?key=0AlbhsLTIt0yMdFcyNm56YnQtSEdfc25hSWdZeWRTMHc#gid=0

Thank you for your help

Robert

--------------------------------------------------------------------------------
following is a solution to the problem