Changes between Version 31 and Version 32 of Tutorials/a0Basic/Tutorial3


Ignore:
Timestamp:
Dec 22, 2014, 3:57:32 PM (10 years ago)
Author:
nilanjan
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Tutorials/a0Basic/Tutorial3

    v31 v32  
    232232=== Microsoft Excel Example ===
    233233
    234 Alternatively Excel Sheet can be used to fetch data associated with an Experiment ID. Attached is an example to access experiment data previously run on the grid console.
     234Alternatively Excel Sheet can be used to fetch data associated with an Experiment ID. ResultServiceVBA.xlsm (under the attachment) is an example to access experiment data previously run on the grid console.
    235235To retrieve data using this file:
    236236 1) Before running the file use Putty to set up a tunnel from ''localhost:6064'' to ''grid.orbit-lab.org:5054''.
     
    238238 2) Once the tunnel is set up, run the ResultServiceVBA file and enable any macros/ActiveX controls when prompted.
    239239
    240  3) In cell B2 copy and paste your Experiment ID, then click on ''Fetch'' to retrieve the data.
    241 
     240 3) In cell B1 (under Sheet1) copy and paste your Experiment ID, then click on ''Fetch'' to retrieve the data.
     241  ''Sheet1'' will contain the ''List of Tables'' that are available. A new sheet will be created for each table and populated with available data.
     242
     243
     244[[Image(Tutorials/a0Basic:ResultServiceVBA_Sheet1)]]
     245
     246[[Image(Tutorials/a0Basic:ResultServiceVBA_IperfTransfer)]]
    242247
    243248This excel file was run using Microsoft Office 2010 on Windows 7 64-bit. A successful execution of this file may be affected by several factors - Window Operating System, Microsoft Office version, Windows security updates, permission level on User Account, ActiveX controls configuration/updates, etc...