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...
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