Main siteMain site  ForumForum  ForumSearch  Private messageEmail contact  RegisterRegister  Log inLog in 
Topic: ExcelFileReader
Reply to topic
Author Message
StabMe



Joined: Jul 29, 2016
Posts: 24

PostPosted: May 28, 2022 3:42 PM    Post subject: ExcelFileReader

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

PostPosted: May 28, 2022 8:39 PM    Post subject:

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

PostPosted: May 29, 2022 9:47 AM    Post subject:

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

PostPosted: May 29, 2022 1:22 PM    Post subject:

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

PostPosted: May 29, 2022 1:54 PM    Post subject:

Ok, thanks Jarek!
Reply to topic