Jump to content

Search the Community

Showing results for tags 'Excel'.



More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


Forums

  • Our Community
    • Come on in!
  • News and Announcements
    • New! UniLogic V1.21 - Supports UniStream 5"
    • VisiLogic:9.8.64 - Link to mobile app, Ladder: 2x the Space!
    • New!!! ***** U90 Ladder*****
  • UniStream HMI + PLC Programmable Controllers & UniLogic Software
    • UniStream: Hardware
    • UniLogic Software
    • UniLogic UDFBs
  • Vision, Samba, Jazz and M90 PLC + HMIs & Software
    • Vision & Samba PLC + HMI Controllers & VisiLogic Software
    • Jazz, M91 PLCs and U90Ladder
  • Software Utilities
    • SD Card Suite
    • Remote Operator
    • Remote Access
    • DataXport and DataXls
    • UniDownloader
    • UniOPC
    • UniDDE
  • Utilities for .net and Visual Studio
    • Unitronics PCOM Protocol
    • COM Object ActiveX .dll
    • .NET driver
  • Project Design
    • ...I have a project...what hardware do I need?
  • User Application Stories
    • Just finished a great project?
  • Tips and Tricks
    • Best Programming Practices
    • Tips and Tricks
  • Job Board
    • Projects seeking Programmers
    • Programmers seeking Projects
  • General Discussion
    • We're Listening...
    • The Lounge
  • News and Announcements Copy

Calendars

  • Community Calendar

Blogs

  • Unitronics' Blog: PLCs, HMIs and more
  • Saragani's Blog
  • Simon's Blog
  • Ash Neilson's Blog
  • Joe Tauser's Blog
  • Unitronics en Español
  • Powered by AMPS
  • Alldrives UK's Blog
  • Unitronics, Howman Style
  • PLCNewbie's Blog
  • Telestar Automation Blog
  • Webinars Collection
  • Tim's Corner
  • Blog
  • TELESTAR (Italian)
  • i4 Automation
  • i4 Automation (UK)
  • Unistream UDFB's

Categories

  • From Headquarters: Sample Applications
    • From Headquarters: VisiLogic
    • From Unitronics: U90 Ladder applications
  • User-submitted Applications
    • From Users: VisiLogic applications
    • From Users: U90 Applications

Categories

  • Articles
    • Forum Integration
    • Frontpage
  • Pages
  • Miscellaneous
    • Databases
    • Templates
    • Media

Categories

  • New Features
  • Other

Found 3 results

  1. 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
  2. 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
  3. 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.
×