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. Ladder code is simply and It is essentially a copy of Visilogic example to save Trend on SD Card but I'm not able to understand where is the error. Any help or advise will be very appreciated. Regards Golzione
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;))))) C6 is input user makes (before in excel table, now it will be on display); G6 is just some result from previous math So for every "IF" I write conditions, then math formula. Then linearization. Then I can use that for information to compare whit encoder input to stop the motor and do some action (drill, cut, pierce...) And I still have not connected and configured encoder, but that will be question for another post if I don't figure it out.. Sorry for any mistakes, English is not my main. Best regards; Marko
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.