Search the Community
Showing results for tags 'excel'.
Hi All, I'm using a VT570 to log some data to SD card. I realized a single Trend with 2 curve for 2 sensor. My goal is to log on a monthly basis this data on a file. File name is "MMYY.utr". Sample rate is 1 data every 5 minutes. When I export data from SD to Excel using the appropriate tool I always have DateTime column rollback in a strange way. All the datetime are correct till to 25th of month and then they are wrong (even if the logged data continues to be correct). Here under you can find some screenshots that I hope explain the issue better than my words.
Hi This is my second project, and I have a question. I'm using V430-J-34 (provided by user...) Whats the best way to round up or round down decimal numbers to whole numbers? Currently I'm using simple linealization to convert result of some math to some normal number. Problem is there is whole excel table of math to do, that I am currently working on to be in plc example: Fx=IF(AND(C6>=130;C6<220);C6-20;IF(AND(C6>=220;C6<310);(C6-40)/3+G6;IF(AND(C6>=310;C6<400);(C6-40)/4+G6;IF(AND(C6>=400;C6<490);(C6-40)/5+G6;IF(AND(C6>=490;C6<=600);(C6-40)/6+G6;))))
Hello, I can export data to Excel with DataXport without problems. Now I'd like to use a simple template (Intestation row + grid), I've checked the checkbox "Use Excel template", i've created it with the same PLC site name with *.xltx extension and placed it in this path "C:\Program Files (x86)\Unitronics\Unitronics DataXport\Excel Templates". PLC site name is "TestRugosita" and the template file name is "TestRugosita.xltx". Now, after doing all this stuff i've the same result as before: an Excel file without a template. Can you help me? Thank you so much
Just in case anyone was wondering, DataXport reads the template file in xlsx format by default. I haven't tried testing if the checkbox "Force Excel 2003 Extension" tells it to read in xls format, but I suspect that to be the case. It took me some time to find that at some point my dataxport installation folder had been renamed from \\Dataxport\ to \\Unitronics DataXport\, so I was putting the template in the wrong place. I think it might have been the windows migration wizard did this when taking the settings off my old Windows XP PC and loading them into the new Windows 7 PC.