mrlambdin

Excel 2007 Datalink 2-D timestamp, data array

Discussion created by mrlambdin on Jun 6, 2013
Latest reply on Jun 6, 2013 by drabinowitz

Trying to create a spreadsheet that shows archived values in a 2-D array (if possible).  The time range for data retrieval is 6 years, from June-Aug, and I want to represent the data in this format:


 

                                                          0:00                                     1:00                                     2:00                                     3:00                                     4:00                                      ……                                6/1/1999                                                                                                                                                                                                                                                                    6/2/1999                                                                                                                                                                                                                                                                    6/3/1999                                                                                                                                                                                                                                                                    …….                                                                                                                                                                                                                                               

 

 

I've created a separate array, for concatenating the date/time into a PI timestamp, which looks like this:

 

                    6/1/1999 0:00                                     6/1/99
                    1:00                                     6/1/1999
                    2:00                                     6/1/99
                    3:00                                     ….                                6/2/1999
                    0:00                                     6/2/99
                    1:00                                     6/2/1999
                    2:00                                     6/2/99
                    3:00                                     ….                                6/3/1999
                    0:00                                     6/3/99
                    1:00                                     6/3/1999
                    2:00                                     6/3/99
                    3:00                                     ….                                6/4/1999
                    0:00                                     6/4/99
                    1:00                                     6/4/1999
                    2:00                                     6/4/99
                    3:00                                     ….                                ….                                     ….                                     ….                                     ….                                     ….           

 

I thought  "Timed Data" would work, but I can't figure out how to tell Datalink to use Row(#) in my concatenated timestamp sheet for the Timestamps, and then extend the result series down, instead of manually doing each date.  

 

Maybe this is simple and i just haven't drank enough coffee....

 

thanks in advance

 

 

 

 

Outcomes