Build 2d Array

[bs2112]

I need to take the following string array of data

NOTE: spaces in the sample are for clarity only

Channel, Setting, Ouput

0          ,31        ,15.2

0          ,30        ,14.4

0          ,29        ,13.6

0          ,28        ,12.0

1          ,31        ,14.9

1          ,30        ,13.8

1          ,29        ,13.1

1          ,28        ,11.9

2          ,31        ,14.4

2          ,30        ,13.2

2          ,29        ,12.1

2          ,28        ,10.9

etc... for 20 channels

And translate this to format.

Row 1 = Channels

Rows 2 to x = Setting to reach implied output

Row 2 implied output is 14

Row 3 implied output is 13

Row 4 implied output is 12

and so on

0  ,   1,   2,....

30,  30,  31

29,  29,  30

28,  28,  29

The table above will eventually be hex coded and written to an eeprom.

I am not looking for the full solution, just enough to get me going in the right direction.

Thanks

Brian

[LV_Pro]

If your input is a string of comma separated variables, then try feeding it into the ""spreadsheet string to array" function which is found in the string function palette. You may have to follow with a "transpose 2D array" function to get it to the "shape" you want, and if the output, which is shown a decimal values in your input string, but described as integer values in your description are truly to be integers then you'll have to pay attention to that as well in the "array type" prototype fed into the spreadsheet function.