Forum

StabMe · Joined: Jul 29, 2016 Posts: 24

Jarek,

Can you give an example of a properly formatted excel file?

I am constructing a design that takes information of normative data for coherence training: mean values and theur standard deviations. Currently i am making a 4 channel design which is going to use 42 pairs of such values and later i'll be adding other parameters and making it by hands will become more cumbersome. I was thinking of using an existing Excel table which can be fed to the elements of the design. Search hasn't reveal any discussions on the topic here on the forum.

So basically, i need to read values from excel table which will then be accessible as outputs and used as constants in the design.

jarek · Joined: Oct 22, 2007 Posts: 960

There are many ways how an Excel file can be formatted. For example:

value1a,value2a,value3a
value1b,value2b,value3b

Make sure that there is the same number of channels in each line.

You can use ExcelFileWriter to create one and see how it looks.

StabMe · Joined: Jul 29, 2016 Posts: 24

Thank you, Jarek.

Another question a bit offtopic - how many Out channels can ExpressionEvaluator handle?

I am trying to process 42 input and output channels through one evaluator, each channel gets the same formula, only variable that changes is inout. Example:

Out1=Math.abs((0.86-In1)/0.1);OutN=Math.abs((0.83-InN)/0.08);Out42=Math.abs((0.72-In3)/0.08)

Two channels work nicely, but with 42 i get this error in the console:

C:\BioEraPro\tmp\ExprEval_1_Compute_Z_Score.java:11: cannot find symbol
symbol : variable In42
location: class ExprEval_1_Compute_Z_Score

Using 42 evaluators make it cumbersome, so i was hoping to get away with one which computes all the data.

----

And another question - is there a way to 'code' a design? I mean, if there could be a way to use code for creating/modifying designs, complex design could be released much faster.

jarek · Joined: Oct 22, 2007 Posts: 960

ExpressionEvaluator can currently be used with up to 28 inputs or outputs.

BioEra is a visual designer only. There no way to create/modify a design from a command line or API. Something like that would kind of defeat its purpose. Creating designs visually is in order to simplify this process and make it possible for non programmers to do.

StabMe · Joined: Jul 29, 2016 Posts: 24

Ok, thanks Jarek!