Changes between Version 31 and Version 32 of Tutorials/a0Basic/Tutorial3
- Timestamp:
- Dec 22, 2014, 3:57:32 PM (10 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
Tutorials/a0Basic/Tutorial3
v31 v32 232 232 === Microsoft Excel Example === 233 233 234 Alternatively Excel Sheet can be used to fetch data associated with an Experiment ID. Attachedis an example to access experiment data previously run on the grid console.234 Alternatively 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. 235 235 To retrieve data using this file: 236 236 1) Before running the file use Putty to set up a tunnel from ''localhost:6064'' to ''grid.orbit-lab.org:5054''. … … 238 238 2) Once the tunnel is set up, run the ResultServiceVBA file and enable any macros/ActiveX controls when prompted. 239 239 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)]] 242 247 243 248 This 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...