AnsweredAssumed Answered

Create variables from Excel

Question asked by dagefo on Aug 20, 2014
Latest reply on Aug 20, 2014 by dagefo

Hello. I have an excel table which contains a list of wind turbine IDs and their associated sound power levels at various octave bands.

The table roughly looks like this...

 

ID63Hz125Hz
250Hz500Hz1000Hz2000Hz4000Hz8000Hz
T1979.489.498.1100.2100.597.996.090.2

 

Previous I have manually input the variables for each turbine as an array in the following format

T19 = [79.4, 89.4, 98.1, 100.2, 100.5, 97.9, 96.0, 90.2]

 

Now I am looking of a way to automate many lines from an excel table to automatically create a variable like I have done manually. I have successfully been able to print the data in the correct format but obviously this isn't setting it as a variable.

 

Does anyone have any ideas how I could achieve this?

 

Many thanks for your help

David

Outcomes