Search the Community
Showing results for tags 'Excel'.
Found 3 results
Marko984 posted a topic in Vision & Samba PLC + HMI Controllers & VisiLogic SoftwareHi 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.