changing data with diadem

[leiabcn]

Hi,
I have and xls file with daily feed intakes and because of electronic problems some feed intakes which had to be zero are negative. I would like to programatically change these data from negative values to zero. These data are in "CONSS" column.
I attached you an example file.
I am using DIAdem 9.0.

Thank you!

N.R

[Walter_Rick]

Hi Leiabcn,

If you've loaded the Excel file into DIAdem you can use the following formula to set all values less than 0 to 0. The result is written back to the channel.

call formulacalc("Ch('CONSS') := (ch('CONSS')<=0) * 0 + (ch('CONSS')>0) * ch('CONSS')")

Greetings

Walter