Hi, someone could tell me the correct way to combine variable =LOGOVAR("ID") with Trend direction TD/TR in an Excel sheet.

I need to generate a table whit data of a temperature sensor vs time on the same sheet.

this could be possible?

Regards.

Hello guys 

I've made also a test with a chart and it is working just fine.

See the attachment.

So many thanks, my friend!

but I have another question:

There is any way to increase the data collection to more than 100 on the History data Number?

I need a large amount of data collection in a graph.

could we save the data log in separated cells for 3 variables? (without comma)  

Regards,

Lui

ixo65

I make a test with anlog signal.

I connected the AI1 of the base modulewith a controllable 0-10V signal and configured this in LOGO! program as PT100 / 1000 in the analogue amplifier. The output value of the analogue amplifier was mapped to the VW0 and the values of VW0 were logged (see video by link).
The correct syntax for me is "= LOGOVARLS ("VW0"; "TD").
According to the manual it should "= LOGOVARLS ("VW0", "TD") is not working by me.
For me it works only with a semicolon instead of a comma.
And important: After the semicolon must be inserted a space.

[snip]

I can't manage to see the trend values. I did pretty much the same in the video in previous post, just changing the variable length from VW0 to VD0 as it is mapped in my configuration.

See attached image.

Murillo Gumiero

The presence of arguments L and S or capital letters is irrelevant, also is the space between "ID" and "TD" or "TR". The ";" is mandatory, so the online help is incorrect when estate ",". 

The problem seems to be on Excel version.

As of the when the print was taken, Access Tool was runing on Excel H&B 2010. I've tried on Excel H&B 2013 and it is working fine, with the same function =logovar("VD"; "TD"). 

Thanks again. 

Murillo Gumiero