Home

MX Sheet Version 1 Operating Manual

Contents

1. Text to Open W Advanced Columns Sort amp Filter Save i G H l J Save As gt Print gt Prepare gt ENRamALCUELo Send Publish gt alo bay a Close 15 16 17 18 2 2 The Excel Options screen appears Select Add Ins change the item in Manage to Excel Add ins and click Excel Options 5 ES View and manage Microsoft Office add ins Add ins Name Additional MX Sheet Add in Excel Add in Analysis ToolPak nalys32 xl Excel Add in Analysis ToolPak VBA atpvbaen xla Excel Add in Conditional Sum Wizard sumif xlam Excel Add in Custom XML Data Miles icel2 OFFRHD DLL Document Inspector Euro Currency Tools r Excel Add in aders and Footers C iles ice icel2 OFFRHD DLL Document Ins Hidden Rows and Columns A rosof ice Officel2 OFFRHD DLL Document Inspector Hidden Worksheets A M ice Officel2 OFFRHD DLL Document Inspector Internet Assistant VBA c ice Offi Library HTML A Excel Add in Invisible Content Cit ilesiMicrosoft Office Officel2 OFFRHD DLL Document Inspector lookup xlam Excel Add in D MELSEC Sheet MXShMenu xla Excel Add in solver xlam Excel Add in Additional MX Sheet Add in D MELSEC Sheet MXShRibbon xlam Description MELSEC COMMUNICATION ADD IN MACRO Manage Excel Add ins i 3 INSTALLATION AND UNINSTALLATION From the previous page Add Ins Aled 3 As the left screen appears click Browse Add Ins available Euro C
2. Start Communication from the menu bar to start writing As the confirmation dialog box appears click Yes 6 OPERATING MX Sheet MELSOFT From the previous page 9 Entering the written values Enter the values to be written to devices into the cell area specified in step 2 Cell B2 1 value to be written to DO Cell C2 2 value to be written to D1 Cell D2 3 value to be written to D2 Make sure that the data on Excel are written to the PLC devices 1 2 a 4 S MX Sheet Mt 10 Ending communication Choose MX Sheet End Communication from the menu bar to end writing q a End CornmunicationfE 15hot Communications Version Info 4 l Complete The Excel sheet for write function is now completed 6 OPERATING MX Sheet MELSOFT 6 4 Automatic Save This section explains a setting procedure for automatically saving the Excel book during MX Sheet operation 1 Setting example Automatic save condition Saved when the device YO turns on Automatically saved file name Date and time are added to the file auto xls f My Documents File Edit View Favorites Tools Help pack a DO search MES Folders wy x if Fea Address FR E p Ph N File and Folder Tasks ES My eBooks EY My Music T Make a new Folder a Publish this Folder to the OD iL My Pictures Microsoft Excel Worksheet 33 KB Web E Share this Folder Other Places E Desktop Automatica
3. lt 00010003 Hex 0160840b Hex gt Time out error Though the time out period had elapsed data could not be received The corrective action is as follows Review the time out value of the property Set it again on the communication settings utility Review the system e g PLC CPU module setting and cable status Retry the method Perform Close once and execute Open again Exit the program and restart the IBM PC AT compatible 5 lt ErrorCode 180840b Hex gt 3 Error log clear setting at communication start At the start of communication the error log can be cleared APP 7 APP 7 Microsoft Windows and Windows NT are registered trademarks of Microsoft Corporation in the United States and other countries Pentium is a registered trademark of Intel Corporation in the United States and other countries Other company and product names herein are either trademarks of registered trademarks of their respective owners SH NA 080347E J MX Sheet Version I Operating Manual Introduction MELS1 SHEET NY E 13JU34 SH NA 080347E J 1105 MEE a MITSUBISHI ELECTRIC CORPORATION HEAD OFFICE TOKYO BUILDING 2 7 3 MARUNOUCHI CHIYODA KU TOKYO 100 8310 JAPAN NAGOYA WORKS 1 14 YADA MINAMI 5 CHOME HIGASHI KU NAGOYA JAPAN When exported from Japan this manual does not require application to the Ministry of Economy Trade and Industry for service transaction permission Specifications subject to ch
4. 0 Number 44 gt Sheeti Sheet Sheet3 2 Ready 03 If VBA has not been installed when an add in is installed for Microsoft Excel 2007 or later the following error message appears and MX Sheet cannot be used Register add in manually after installing VBA Severe Se Add in registration was not performed VBA might not be installed Please register the add in manually from Excel after installing VBA 3 INSTALLATION AND UNINSTALLATION From the previous page Information e 1 Completed the installation of this product MELSOFT e When user account control is enabled the following screen appears Click Install This screen may appear in several times 7 Windows Security Ee Would you like to install this device software Name Jungo Jungo Mi Publisher MITSUBISHI ELECTRIC CORPORATION Install Don t Install E Always trust software from MITSUBISHI ELECTRIC CORPORATION You should only install driver software from publishers you trust How can I decide which device software is safe to install gt Windows Security Would you like to install this device software Name MITSUBISHI ELECTRIC CORPORATION Universa IT Publisher MITSUBISHI ELECTRIC CORPORATION E Always trust software from MITSUBISHI ELECTRIC Install Don t Install CORPORATION 4 You should only install driver software from
5. No Cancel O anceli ap When logging on without administrator authority the Optional Aoi Notset Set already o __cancet_ tve 99 g y i password input screen appears as follows lt Windows Vista gt lt Windows 7 gt f po User Account Control X Pg User Account Control 8 Wf An unidentified program wants access to your computer i O Do you want to allow the following program from an 52 unknown publisher to make changes to this computer Don t run the program unless you know where it s from or you ve used it Rett Program name ActComm exe E ActComm exe Verified publisher Unknown l Unidentified Publisher File origin Hard drive on this computer To continue type an administrator password and then click OK To continue type an administrator password and then click Yes GX755 D errr Professional E Password Password v Details OK Cancel v Show details User Account Control helps stop unauthorized changes to your computer To the next page 6 OPERATING MX Sheet MELSOFT From the previous page After inputting the password click or OK The privilege escalation allowance screen on User Account Control appears as follows lt Windows Vista gt lt Windows 7 gt Dira rara uw DEN Ay User Account Control 3 y An unidentified program wants access to your computer i Do you want to allow the follow
6. PLC Monitor Utility AE 9 Checking the device status Menu Online Help Device Batch Butter Memory Entry Device The YO device status has been changed as set in step 8 me o Check whether it has been changed or not HER A After checking click Stop monitor and then 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 ono oo OO Stop monitor 0000 0000 y 0000 0000 7 Monitor format Bit amp vVord v 0000 0000 0000 0000 Display 16bit integer X 0000 0000 Data format DEC a Bit order F 0 Host station 6 OPERATING MX Sheet MELSOFT From the previous page l IA aket 10 Checking the saved file Qui O 9 Osea Eras Y gt lt 10 The operation in step 8 activates the automatic save A na I setting function and saves the Excel book automatically 3 ear re o Start Explorer and check whether the file specified in step ES Shorts oder Y da 3 has been saved correctly ares After checking the file choose MX Sheet End One Communication from the menu bar to end See communication Setting coat The automatic save setting is now completed 6 OPERATING MX Sheet MELSOFT 6 5 Automatic Print This section explains a setting procedure for automatically printing the whole Excel book or specified Excel sheets during MX Sheet operation 1 Setting example Automatic print condition Printed at 17 00 every day Print area Sheet 1 and Sheet 3 are printed 2 Set
7. Cancel 11 When making a restart make sure that the Yes want to restart my computer now checkbox is marked and then click OK When not making a restart mark the No will restart my computer later checkbox and click OK 3 INSTALLATION AND UNINSTALLATION MELSOFT Note the following instructions when the installer is started from the hard disk drive of the personal computer for which Windows Vista has been installed If the Program Compatibility Assistant screen appears after the installation select This program installed correctly If Reinstall using recommended settings is selected by mistake Windows XP SP2 compatibility mode is set automatically Disable the Windows XP SP2 compatibility mode by following the procedure described below and perform the reinstallation 1 Right click on the setup exe icon of the installation target in the Windows explorer and open the setup Properties screen 2 Select the lt lt Compatibility gt gt tab and click Show settings for all users 3 Uncheck the Run this program in compatibility mode for check box of compatibility mode in the lt lt Compatibility for all users gt gt tab and click OK 4 Click on the setup Properties screen EM setup Properties xa Security Details Previous Versions General Compatibility Digital Signatures s with this progr md it we correctly on idows sele setup Properties a
8. Create Buttoni Protect MX Sheet setting R Options I Setting Data Export x Version Info E 2 Creating new automatic save conditions Create new automatic save conditions Click Create New 3 Setting the automatic save conditions Set the automatic save conditions as follows Set the date and time hii mal lesd Wedne i jursda d Frida V Set the Device trigger Logical Station Number 4 CPU COM_ 02 olaa lala lla Monthly et ose era Automatic Save Name Line 1 Lot completion Set the Device trigger Check Logical Station Number 1 cman Bit device Check Device YO Bit Device Device YO Condition hen ON v C Word Device bit Clear cell area after automatic save File name to save D Documents and Settings AdministratoriMy Documentstauto xls Browse Add date and time to File name C Add sequential number to File name Fix the File name Condition When ON Add date and time to File name Check 1 Refer to Section 6 1 for the logical station number AS setting method Cancel Set the file name to be saved automatically Clicking displays the Save As dialog box Save in E My Documents Jena Specify any save place and file name A My Music B My Pictures File name auto xls Save as type Excel book xls After specifying the file name click Save Save as ype Excel Book xs z cma A
9. Do not select Reinstall using recommended settings because the installer installs an incorrect module Program Compatibility Assistant This program might not have installed correctly If this program didn t install correctly try reinstalling using settings that are compatible with this version of Windows Program Setup Launcher Publisher InstallShield Software Corporation Location F EnvMEL SETUP EXE Reinstall using recommended settings Cancel 3 INSTALLATION AND UNINSTALLATION MELSOFT 3 1 3 Installation check Check whether MX Sheet has been installed normally or not as follows 1 Start Excel 2 If the MX Sheet item has been added to the menu bar MX Sheet has been installed normally lt Microsoft Excel 2003 or earlier gt lt Microsoft Excel 2007 or later gt EN Book1 Microsoft Excel satis EN File Edit View Insert Format Tools Data Window Mx Sheet M Help a e Review View Developer Add Ins os Deka amp ay amp ES Cell Settina L Cell Setting L Automatic Save Setting K Automatic Print Setting O i Wess 1004 44 gt Sheeti Sheet2 f Ready PJ MX Sheet icons and menu are displayed MX Sheet icons and menu are displayed 1 If the following screen appears during installation MX Sheet is not registered to the menu bar Failed in registration of the M Sheet menu Please carry out add in re
10. Timetable tire B i Ei 1 _ LE Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CSY Logging Monitor function Monitor 1 CPU CO Settings No settings No settings No settings essa ak ste MEMES A 8 Checking the settings vols Data Window Mx Sheet M Help Check whetherthe settings n I 1 o 7 Bee epee 2 A gt Cell Setting fL f pa A Automatic Save Setting K Automatic Print Settina O hn i Automatic Communication Startup Setting A Start Communication B B not by using the 1 shot communication function of MX Sheet Make 1 shot communication in the following procedure 1 Choose MX Sheet 1 Shot Communication from the menu bar 2 As the 1 Shot Communication dialog box appears select the cell area name set in step 4 monitor function in this example as the Cell Area Name 3 Click to start 1 shot communication 1Shot Communication S Cut Cell Area T Copy Cell Area C Delete Cell ee E Change Sheet Name N Create Button w Protect MX Sheet setting R OptionsiD Setting Data Export x version Info 15hot Communication Cell Area Hame To the next page 6 OPERATING MX Sheet MELSOFT From the previous page J ET 9 Starting communication Data Window mx Sheet M Help Choose MX Sheet Start Communication from the DOES PAR AE menu bar to start monitor
11. 02 11 02 AM H E DrvCommon PY MeShMenusla Microsoft Excel Add In 7227202 3 51 PM HL Easysocket MS hUtiLocs OCX File 7430 02 6 08 PM e Gppw Uninstaller exe Application 7 30 02 6 09 PM 6 3 Lit 0 Mneth H Gutp ES Sheet i object s selected 256KB El My Computer tig MxCom5 hConvr Eq wf Convert the communication setting Converting communication setting of MA LinkslevyvsDSF CSKP E Wer A or above to communication setting logical station numbers of Mx Component Progress w w Convert the Mx Chart used in Excel book Converting cell setting tag file alarm summary file and comment file of Mx Chart SvVs05F OLEX E er or above to Mx Sheet cell setting Progress So Excel Book C MyDocumentsiOLEXxIs S a Tag file The tag file name set in environment setting utility will be converted automaticaly Alarm summary file The alarm summary file name set in each cell settings will be converted automatically Comment file The comment file name set in each cell settings willbe converted automatically APP 5 APP 5 APPENDICES Appendix 1 8 Protect MX Sheet setting The MX Sheet setting can be protected by a password The user settings can be made unchangeable Protect MX Sheet setting Set the password Password optional cn Cell Settings Read only CS Logging Use Logging T MELSOFT Cell Area Name iV Clear cell area at the start of communication New data location Last Li
12. 1 Section 3 1 2 Section 3 2 Section 6 1 May 2011 SH NA 080347E J Addition Generic Terms and Abbreviations Chapter 2 Section 3 1 1 Section 3 1 2 Section 3 1 3 Section 3 1 4 Japanese Manual Version SH 080345 J This manual confers no industrial property rights or any rights of any other kind nor does it confer any patent licenses Mitsubishi Electric Corporation cannot be held responsible for any problems involving industrial property rights which may occur as a result of using the contents noted in this manual O 2002 MITSUBISHI ELECTRIC CORPORATION INTRODUCTION Thank you for choosing the Mitsubishi Integrated FA Software MELSOFT series Read this manual and make sure you understand the functions and performance of MELSOFT series thoroughly in advance to ensure correct use CONTENTS SAFETY PREGADTIONS tasas e ts o a ct o e E ARE ans ME laiU A 1 CONDITIONS OF USE FOR THE PRODUCT 2 00 0 ccc cece ccc ccecceccececcececceceecccueuecaunecauauceunecaeeauauseunensunenaes A 2 REVISION ett reece A A A A a a A A A 3 CONTENTS entitats eta de ed A 4 MANS o oo lo cd a E eo A 6 Generic Terns and ADDFEVIATIONS iu A desi exviowewnasn Vex exsedestsentaseeteel elt A 7 MSI A wun E AE a eta Sede ee oe See EES A 8 1 OVERVIEW 1 1to1 2 1 1 What IS MX Sheet 0 0 0 ccc ccc cccececceccececcececceccuceecuceuaeccuueceucauaecuuecaueuuuecseneeaeceueesuensuausaunaeteusesaenaueeeunenaenes 1 1 1 2 Fu unctions Explained imn This MA
13. Compatibility for all users Compatibility mode L If you have problems with this program and it worked correctly on an earlier version of Windows select the compatibility mode that matches that earlier version Run this program in compatibility mode for Compatibility mode Y Run this program in compatibility mode for Settings m ul ee ere Uncheck the check box Disable desktop composition Disable display scaling on high DP settings Run in 640 x 480 screen resolution Biiviece Level Disable visual themes Disable desktop composition Run this program as an administrator i mouce Disable display scaling on high DPI settings Privilege Level Run this program as an administrator OK pi Cancel Jl Apply 3 INSTALLATION AND UNINSTALLATION MELSOFT 2 When message appears at start of installation When starting the installation of this product the This package is not in proper operating environment message appears disabling normal completion of installation In such a case close all applications and perform the a or b operation a Installing dcom95 exe or Axdist exe Execute dcom95 exe or Axdist exe provided for MX Sheet Install MX Sheet after executing the exe file and restarting the personal computer Execute the exe file on the corresponding operating system as follows dcom95 exe Microsoft Windows 98 Operating System Axdist exe Microsoft W
14. Refer to Section 6 1 1 The End Communication or 1 Shot Communication button is also available 2 Creating the button and starting communication The following describes a procedure from button creation to a communication start using the button 1 Choosing Create Button saex sae Start Excel and specify the cell where the button will be placed Choose MX Sheet Create Button Start Communication Button on the menu bar 2 File Edit View Insert Format Tools Data Window Mx Sheet M Help DOBG quaiSliari a gt Cell Setting L Rg Gl M fala EB S A o automatic Save Setting k J32 y Automatic Print Set Ooo on amp WN The Start Communication Button is placed in the specified cell position 2 The display characters and character font of the created button can be changed Refer to the MX Sheet Version 1 Operating Manual for details MXShBtnStart 2 Starting communication Ey File Edit View Insert Format Tools Data Window MX Sheet M Help DESHAYS IDAS gt 4 aw Click the Start Communication Button created in Step 1 Mea Miho e BEEF AZAR BR arial alo B4 E 1 MA Cr MX Sheet Communication will commence Is ik OE 6 OPERATING MX Sheet MELSOFT MEMO APPENDICES MELSOFT APPENDICES Appendix 1 Useful Functions of MX Sheet In addition to the functions explained in this manual Chapter 6 MX Sheet has useful functions This secti
15. Set the automatic print conditions V Set the date and time ind Day a sli C Monty Set as indicated below Vednesd Mmursda Operation Daily C Weekly UE le Automatic Print Name Line 1 Daily report Set the date and time Check urde lay of the current th X Operation Regular interval Hourly Timetable HH mm a mo E ee caress Operation day Daily ene g Operation time Time table 17 00 r Print Area Specify the sheet Clear cell area after automatic print Sheet 1 and Sheet 3 1 Print Area Entire workbook Specify the sheet Sheet After making the above setting click OK 1 Multiple sheets can be specified Specify the corresponding sheet only 6 OPERATING MX Sheet MELSOFT From the previous page l a E 4 Specifying the automatic print conditions EI AT 3 e After making sure that the automatic print name has been added to the list and the Enable filed has a check mark click to close the Automatic print list l If multiple printers are set within the personal computer the default printer set within My Computer Printers is used to print the Excel sheet when Automatic Print setting is selected 6 OPERATING MX Sheet MELSOFT 6 6 Using the Button This section explains a convenient communication starting method by Create Button 1 Setting example Button type Start Communication button MX Sheet setting condition Logging setting
16. XP Windows Vista or Windows 7 is used the following new functions cannot be used If any of the following new functions is used this product may not operate normally Start of application in Windows compatible mode Fast user switching Remote desktop Big fonts Details setting of Screen properties 64 bit Windows XP and 64 bit Windows Vista are not supported 2 When Windows 7 is used the following new functions cannot be used Windows XP Mode Windows Touch 3 When MX Sheet is tried to be installed on the personal computer where 64 bit Microsoft Excel 2010 has been installed the following error message appears Information Excel 64bit version was installed in an environment can not perform the FP installation 4 When MX Sheet is installed 64 bit Microsoft Excel 2010 is installed and started then an add in is installed the following error message appears Microsoft Visual Basic for Applications Compile error in hidden module M amp ShExtern 4 This error commonly occurs when code is incompatible with the version platform or architecture of this application Click Help for information on how to correct this error E Help To use MX Sheet install 32 bit Microsoft Excel 2010 3 INSTALLATION AND UNINSTALLATION MELSOFT 3 INSTALLATION AND UNINSTALLATION This chapter explains the installation and uninstallation procedures of MX Sheet The screens used in this chapter are those of the Mic
17. changes to this computer 1 If you started this action continue gt install or change an application Un ied publisher Mi ft Wind kal Uninstall or change an application E ee a a a R Microsoft Windows pu oR User Account Control helps stop unauthorized changes to your computer To the next page 3 INSTALLATION AND UNINSTALLATION MELSOFT From the previous page Confirm File Deletion 3 The dialog asks if you really want to uninstall MX Sheet for confirmation To uninstall it click Yes When not uninstalling it click No Clicking returns to the previous screen S y Are you sure you want to completely remove MX Sheet and all of its components Components indicate the installed icons and files When the following screen appears clicking No to All deletes MX Sheet software package only Clicking Yes Yes To All deletes the common files of Windows based MELSOFT software and may not start normally Memove Shared PIA The system indicates that the following shared file is no longer used by any programe If any programe are still using this file and it 12 removed those programe may not function Are You sure you want to remove the shared file Leaving this file will not harm your system IF you are not sure what to do it i suggested that you choose to not remove this shared component File name Located irr EXMindowe systems
18. lt lt Access Data gt gt tab Cell Area B2611 Set the Color of Grid line B IV Set the Color for Filling El JV Clear cell area at the start of communication New data location Last Line v Display Contents Add title Y Add date and time details U se Log g in g iii y a p the beginning without clearing the cell area Cel Area N a m e Log g n g fu n cti O n C Display from the beginning after clearing the cell area Cell Area B 2 s G 1 1 New data location Last Line Display Contents Add date and time details Operation when cell is full To scroll 1 A a A A Cell Area Name Logical Sta Operation Interval Device Trigger Handshake CSV Logging Mandatory Settings Notset Setalready OK Cancel Apply Optional Settings Not set i Setalready EW 5 Setting the logical station number of the lt lt Access Data gt gt tab Access Data Operation Interval Device Trigger Handshake CSV Logging f Pl Click Communication Settings to start the Communication Setup Utility for setting the logical station number When the following screen appears click Yes F r Communication Setup Utility i e Do you execute programs as an administrator To change the communication settings select Yes When No is selected The communication settings cannot be changed Cell Area Name Logical Sta Operation Interval Device Trigger Handshake CSV Logging
19. start 1 shot communication Create Buttoni a 15hot Communicationi S Cut Cell Areal Th Copy Cell Greatly Delete Cell Area Di Protect Mx Sheet settingi Ei OptionsiI Setting Data Exportty version Info Gy 15hot Communication Cell Area Name ENTE gem areal To the next page TERM What is 1 shot communication This function executes the function set to the selected cell area at any timing 6 OPERATING MX Sheet MELSOFT From the previous page lt Before adjustment gt 18 Adjusting the display 1 2 After 1 shot communication HHHHHHH is displayed in the date time cell as shown on the left screen gt Adjust the cell width of Column B so that the date and time can be displayed 10 E lt After adjustment gt 0 0 40 M 2 UN 10 IA 19 Starting communication s Data Window Mx Sheet M Help Choose MX Sheet Start Communication from the ASF Cel Setting EE menu bar to start logging mm um A j F lS A Automatic Save Setting pzu As the confirmation dialog box appears click Yes Automatic Print Setting C Es Automatic Communication Startup Setting 4 H 7542 at Stark Cormmunication E DS 1Shot Conmmunication s Cut Cell Areal Th Copy Cell ArealC Paste Cell Area P Delete Cell Area D Change Sheet MametlW Create Button Protect Mx Sheet setting wauni Se
20. the privacy statements Show the Microsoft Office Excel privacy statement Microsoft Office Online privacy statement Customer Experience Improvement Program Security 8 more Learn more about protecting your privacy and security from Microsoft Office Online Microsoft Office Excel Trust Center The Trust Center contains security and privacy settings These settings help keep your computer secure We recommend that you do not change these settings Trust Center Settings F Trust Center Trusted Publishers Trusted Locations Add ins ActiveX Settings Add ins F Require Application Add ins to be signed by Trusted Publisher Disable notification for unsigned add ins code will remain disabled Disable all Application Add ins may impair functionality l Add ins r Trust Center Trusted Publishers Trusted Locations ActiveX Settings Macro Settings Macro Settings For macros in documents not in a trusted location Disable all macros without notification Disable all macros with notification Disable all macros except digitally signed macros Macro Settings Message Bar Trusted Publishers Trusted Locations External Content Privacy Options ActiveX Settings for all Office Applications For ActiveX controls in documents not in a trusted location Add ins Disable all controls without notification menre senno Promp
21. 2 URA A DIS 1 OVERVIEW MELSOFT 1 2 Functions Explained in This Manual This manual explains the following MX Sheet functions 1 Logging function refer to Section 6 1 This function accumulates the device data collected from the PLC as a history in the cell area selected on an Excel sheet 2002 07 31 Wed 16 32 36 2 1 0 0 O Device data are accumulated as history 2002 07 31 Wed 16 32 36 2 1 0 0 0 2002 07 31 Wed 16 32 46 12 6 o oof ol AAA ES A 2 Monitor function refer to Section 6 2 This function displays the device data collected from the PLC in the cell area selected on an Excel sheet 16 9 O O O PLC CPU 3 Write function refer to Section 6 3 This function writes the values entered on an Excel sheet to PLC devices 1 Z 3 Values entered on Excel are written to PLC devices 4 Automatic save function refer to Section 6 4 This function saves the Excel book automatically when the specified device is triggered at the specified time 5 Automatic print function refer to Section 6 5 This function prints the Excel book or specified Excel sheets automatically when the specified device is triggered at the specified time 6 Create button function refer to Section 6 6 This function executes each of the Start Communication End Communication and 1 Shot Communication functions by merely clicking the corresponding button created from Create Button 2 OPERATI
22. As the confirmation dialog box appears click Yes j pa A Automatic Save Settimg K Automatic Print Setting O EUA Automatic Communication Startup Setting A Start Communication B 1Shot Communication S Cut Cell Area T Copy Cell Area C Delete Cell Area D Change Sheet Name N Create Buttoni Protect MX Sheet setting R Options D Setting Data EXxport X version Info MX Sheet Communication will commence e Is ik OK c 10 Ending communication MX Shest M E Choose MX Sheet End Communication from the D menu bar to exit monitor _ After ending the communication delete the monitor data End Communication E 15hot Communication S version Info y Complete The Excel sheet for monitor function is now completed 6 OPERATING MX Sheet MELSOFT 6 3 Data Write This section provides an example of creating an Excel sheet using the write function 1 Creation example Set the following Excel sheet as instructed in 2 EJ Microsoft Excel MX Sheet Ms Sheet ht de 411 4 a he P A B DOE F G amp G H h k k Enter values to be written to DO D2 in order from left to right 6 OPERATING MX Sheet MELSOFT 2 Setting MX Sheet This section explains the procedure of creating an Excel sheet for monitor function dEl 1 Saving the Ex
23. Disable all controls without notification Select Macro Settings from the list shown on the left and select Enable all macros not recommended potentially dangerous code can run After configuring the above settings click OK and exit Excel 2010 3 INSTALLATION AND UNINSTALLATION MELSOFT 3 1 2 Installation 1 Installing the product 1 Start Windows after powering on the personal computer AA 2 Start Explorer and click the drive in which the Qu O Osea E Fors E CD ROM has been inserted Double click SETUP exe ea To display Explorer right click Start and select Explorer rate aa File and Folder Tasks SDI nstallShield Deleter CSN ONIe lc CICLE nstallShield Software Corpora m Rename this file Gy Move this file P Copy this file Publish this file to the Web 3 E mail this file X Delete this file Other Places y _sysl useri 200 KB 65 KB DATA TAS When user account control is enabled the j following screen appears Click Allow or Yes LicCheck dll j 181 61 51 53 le E PROCHECK dll BJ a ay lt Windows Vista gt lt Windows 7 gt User Account Control a 3 y User Account Control x betup Launcher 0 An unidentified program wants access to your computer 4 Do you want to allow the following program from an InstallShield Software Corpora f U prog y P W aay unkno
24. Installing Visual Basic for Applications hereafter abbreviated as VBA is required for Microsoft Office 2007 or later If not installed the following error message appears when add in is registered at MX Sheet installation and MX Sheet cannot be used f Severe Em Add in registration was not performed 7 VBA might not be installed Please register the add in manually from Excel after installing VBA 3 INSTALLATION AND UNINSTALLATION MELSOFT 4 Security Setting of Microsoft Excel 2007 The following explains the setting procedure of required Trust Center when using MX Sheet with Microsoft Excel 2007 1 Click Office button i N ame ae Page Layout A Cut Arial lt 53 Copy aste safi j F Format Fainter B Z Unj Clipboard F A B C 1 2 2 Click Excel Options L Recent Documents E F sen Il 7 Open Save N Save As P Frint b Prepare A Send e Publish r Close E Excel Options x Exit Excel l To the next page 3 INSTALLATION AND UNINSTALLATION From the previous page l Excel Options Popular Formulas Proofing Save Advanced Customize Add Ins Trust Center Resources Trust Center Y Help keep your documents safe and your computer secure and healthy Protecting your privacy Microsoft cares about your privacy For more information about how Microsoft Office Excel helps to protect your privacy please see
25. MX Sheet Version I MITSUBISHI Introduction ya S WwW i Ss rogramming Me intenance MELSOFT Integrated FA Software SW1D5C SHEET E e SAFETY PRECAUTIONS e Always read these instructions before using this equipment Before using this product please read this manual and the relevant manuals introduced in this manual carefully and pay full attention to safety to handle the product correctly The instructions given in this manual are concerned with this product For the safety instructions of the programmable controller system please read the CPU module user s manual In this manual the safety instructions are ranked as WARNING and ACAUTION gt A D D D a mm wae E E E Ca Y N e N WARNING Indicates that incorrect handling may cause hazardous conditions resulting in death or severe injury Indicates that incorrect handling may cause hazardous conditions Po al A CAUTION resulting in minor or moderate injury or property damage mm mm mm ms cc cm mc ms me ms ms mm cs ms mc cs ms mc ms me ms ms ms ce mm ms ms se ee oe ee ee a Note that the CAUTION level may lead to serious consequences according to the circumstances Always follow the instructions of both levels because they are important to personal safety Observe the precautions of both levels because they are important for personal and system safety Please save this manual in a convenient place so that you
26. NG ENVIRONMENT MELSOFT 2 OPERATING ENVIRONMENT The following table indicates the operating environment of MX Sheet Description IBM PC AT compatible Pentium 200MHz or higher IBM PC AT compatible personal computer installed with Computer personal applicable os computer Microsoft Windows 98 Operating System English version Microsoft Windows Millennium Edition Operating System English version Microsoft Windows NT Workstation Operating System Version 4 0 English version Microsoft Windows 2000 Professional Operating System English version Microsoft Windows XP Professional Operating System English version Microsoft Windows XP Home Edition Operating System English version Microsoft Windows Vista Home Basic Operating System English version Microsoft Windows Vista Home Premium Operating System English version Microsoft Windows Vista Business Operating System English version Microsoft Windows Vista Ultimate Operating System English version Microsoft Windows Vista Enterprise Operating System English version Microsoft Windows 7 Starter Operating System English version Microsoft Windows 7 Home Premium Operating System English version Microsoft Windows 7 Professional Operating System English version Microsoft Windows 7 Ultimate Operating System English version or Microsoft Windows 7 Enterprise Operating System English version Microso
27. NU lis ooo 1 2 SA SM e e o 3 1 3 1 1 Installation precaulonsS a rassiisubeiiresiani seii ei a eiei eia iaa a aaie 3 1 AA A A A A EA 3 7 AL A A ea ea E O eaten toe Pee O es oie eee eet 3 16 3 1 4 Manual add in registration cccccccssssscceccccceseeseecececceeeausseceeecceeeasueeeeeeeseeeaaaeeeeeesseeeuseseeeeeesssseaaaaes 3 17 G PARRE UE a 26 sous AN 3 21 4 SYSTEM CONFIGURATION USED IN THIS MANUAL 4 1to 4 2 5 MX Sheet OPERATION PROCEDURE 5 1 to 5 2 6 OPERATING MX Sheet 6 1 to 6 29 q A a a eee a a ee 6 1 0 2MONITOF apar da a a a e a 6 11 A A SN A A O A a 6 16 OF FAUTEON AUC SAV Sire a inaes E A ERA AI E A A nadia tn eh EA RATIOS 6 21 AN A 6 26 0 50 USING ME BUON asc 6 28 A 4 A 4 APPENDICES APP 1 to APP 7 Appendix 1 Useful Functions of MX Sheet ooonccccccccccccconcccnncccconononccnnnnnnnononnnnnnnnnnnonnnancnnnnnononnnanennnnnnnnns APP 1 Appendix 1 1 Alarm UA e a o APP 1 Appendix T2 Comment a IS Play isa cait ast cexl anni seit aaeioeslacts sei anutsadtansse dashed ont os APP 2 Appendix 1 3 Device AT Cc Fcc hee i Sec cd elidel toa APP 2 Appendix lA Ranas naked a a APP 3 PAD DETIODE TO CSV HOGGING brisas al esca e e APP 4 Appendix 1 6 Automatic Communication Startup Setting oooccccccnncccccoconnccnnnncnnnnnnnncnnnnnonononanenons APP 4 Appendix 1 7 Data conversion FUNCOM aa APP 5 Appendix 1 8 Protect MX Sheet Settig ooccccccccccooooncnnnccnnoconancnnnnnnnoconannnnnnnnnnnnn
28. O D E Logical Station Number 1 Device DO Data type 16bit integer Value DEC Zoom 1 No of cells 0 Cell Area Name Logical Sta Operation Interval Device Trigger Handshake CSY Logging 1 Refer to Section 6 1 for the logical station number ao Eee sang monda E 6 Setting the lt lt Operation Interval gt gt tab Set the monitor operation interval Monthy Make the following settings F Operation Interv al E Jevice Trigger Handshake CSY Logging Set the Operation Interval Operation Daily C Weekly Set the Operation Interval Check last aay ofthe curertimanth z Operation day Daily E Regular interval Minutely Hourly C Time table aH 5 HE Operation time Regular interval 5 seconds z i r m rc r rc r r Cell Area Name Logical Sta Operation Interval Device Trigger Handshake CSY Logging Mandatory Settings Notset Setalready OK E Apply Optional Settings Notset Setalready 1 To the next page 6 OPERATING MX Sheet MELSOFT From the previous page 1 Cell Settings Monitor function ES 7 Applying the settings E Sn GE Click Apply to enable the settings of the Cell Setting Operation Daily C Weekly E C Monthly di al O g b OX 2 After clicking Apply check that the cell area has been DTC registered as shown on the left screen and click OK Operation Regular interval Minutel Hourl
29. OFT 3 As the left screen appears make sure that all applications have been closed and click OK If the applications are running close all the running applications 4 Setup starts As the left screen appears read the information and click Next gt 5 Enter the name and company name and then click Next gt 6 Confirm the registered name and company name If they are correct click Yes To make a change click to return to the previous screen 3 INSTALLATION AND UNINSTALLATION From the previous page l Input ProductiD Please enter the product ID of the product Please input in single byte English characters lt Back Cancel Choose Destination Location The setup will install SWnD5 SHEET in the following directory Click Next to install in this directory Click Browse and select the directory for installing in other directory Click Cancel for not installing Destination Folder CAMELSECA Select add in register lt Back Cancel Warning Excel is started in order to carry out add in registration of the Mx Sheet menu to Excel t By starting Excel a message box is displayed and installation may stop In this case installation can be resumed by closing a message box To the next page 7 9 MELSOFT Register the product ID of the product Enter the product ID and click Next gt The product ID is described on the License certificate i
30. PONSIBILITY OR LIABILITY BASED ON CONTRACT WARRANTY TORT PRODUCT LIABILITY FOR ANY INJURY OR DEATH TO PERSONS OR LOSS OR DAMAGE TO PROPERTY CAUSED BY the PRODUCT THAT ARE OPERATED OR USED IN APPLICATION NOT INTENDED OR EXCLUDED BY INSTRUCTIONS PRECAUTIONS OR WARNING CONTAINED IN MITSUBISHI S USER INSTRUCTION AND OR SAFETY MANUALS TECHNICAL BULLETINS AND GUIDELINES FOR the PRODUCT Prohibited Application Prohibited Applications include but not limited to the use of the PRODUCT in e Nuclear Power Plants and any other power plants operated by Power companies and or any other cases in which the public could be affected if any problem or fault occurs in the PRODUCT e Railway companies or Public service purposes and or any other cases in which establishment of a special quality assurance system is required by the Purchaser or End User e Aircraft or Aerospace Medical applications Train equipment transport equipment such as Elevator and Escalator Incineration and Fuel devices Vehicles Manned transportation Equipment for Recreation and Amusement and Safety devices handling of Nuclear or Hazardous Materials or Chemicals Mining and Drilling and or other applications where there is a significant risk of injury to the public or property Notwithstanding the above restrictions Mitsubishi may in its sole discretion authorize use of the PRODUCT in one or more of the Prohibited Applications provided that the usage of the PRODUCT i
31. Recent Mew Print Save amp Send Help Exit To the next page 1 Click the lt lt File gt gt tab 2 Select Options 3 INSTALLATION AND UNINSTALLATION From the previous page l a Excel Options P eE General Y Help keep your documents safe and your computer secure and healthy Formulas Proofing Protecting your privacy Save Microsoft cares about your privacy For more information about how Microsoft Excel helps to protect your privacy please see the privacy statements Language f Show the Microsoft Excel privacy statement Advanced Office com privacy statement Customize Ribbon Quick Access Toolbar Add Ins Trust Center Customer Experience Improvement Program Security amp more Learn more about protecting your privacy and security from Office com Microsoft Trustworthy Computing Microsoft Excel Trust Center The Trust Center contains security and privag settings These settings help keep your computer secure We recommend that you do not change these settings Trust Center Settings fr Trust Center E ll Trusted Publishers Trusted Locations Trusted Documents jf Add ins Add ins Require Application Add ins to be signed by Trusted Publisher Disable notification for unsigned add ins code will remain disabled Disable all Application Add ins may impair functionality A Trust Center
32. Trusted Publishers Trusted Locations Trusted Documents Add ins ActiveX Settings Macro Settings Protected View ActiveX Settings for all Office Applications Disable all controls without notification Prompt me before enabling Unsafe for Initialization UFI controls with additional restrictions and Safe for Initialization SFI controls with minimal restrictions Prompt me before enabling all controls with minimal restrictions Enable all controls without restrictions and without prompting not recommended potentially dangerous controls can run Y Safe mode helps limit the control s access to your computer F Trust Center Trusted Publishers Trusted Locations Trusted Documents Add ins ActiveX Settings Macro Settings Protected View Macro Settings Disable all macros without notification Disable all macros with notification Disable all macros except digitally signed macros Enable all macros not recommended potentially dangerous code can run Developer Macro Settings Trust access to the VBA project object model l Complete 3 4 1 MELSOFT Select Trust Center from the list shown on the left and click Trust Center Settings Select Add ins from the list shown on the left and uncheck the items when they have the check marks Select ActiveX Settings from the list shown in the figure to left and select any item other than
33. Yes Toall No No to ll Remove Programs From Your Computer 4 When a message appears and shows that the files uninstallShield will remove the software Mx Sheet from your have been deleted click OK computer Please wait while each of the following components is removed Be sure to restart the personal computer if some files Shared program files remain undeleted Standard program files Folder items Program folders Program directories Program registry entries Uninstall successfully completed y Complete 3 INSTALLATION AND UNINSTALLATION MELSOFT When uninstallation is executed using any of the following OSes MX Sheet remains displayed in the application list of Add or Remove Programs if uninstallation is completed normally After uninstallation is completed restart Add or Remove Programs and check whether MX Sheet has been removed from the application list Windows 98 Windows Me Windows NT Workstation 4 0 3 INSTALLATION AND UNINSTALLATION MELSOFT MEMO 4 SYSTEM CONFIGURATION USED IN THIS MANUAL MELSOFT 4 SYSTEM CONFIGURATION USED IN THIS MANUAL This manual explains system configuration as follows MX Component MX Sheet LIV a CAPAS k L AR A System Equipment Equipment Description Personal computer that satisfies the operating environment of MX Sheet Personal computer Refer to Chapter 2 for details
34. aa so 60l Simultaneous execution CSV file 2002 05 04 08 00 00 O O 0 0 0 0 Save into CSV file 2002 05 04 08 00 10 10 20 30 40 50 60 Appendix 1 6 Automatic Communication Startup Setting Automatic Communication Startup Setting automatically starts communication with the PLC when the Excel book where MX Sheet settings have been made is started This setting eliminates the need of selecting Start Communication from the MX Sheet menu APP 4 APP 4 APPENDICES MELSOFT Appendix 1 7 Data conversion function The data conversion function converts the communication settings of MX Links SW3D5F CSKP E and various settings of MX Chart SW3D5F OLEX E into the logical station number of MX Component and cell settings of MX Sheet respectively This function ensures efficient utilization of the conventional assets lt Starting method gt Explorer gt MELSEC gt Sheet gt MXComShConv exe EN Exploring Sheet File Edt View Go Favortes Toole Help E 9 amp a aja x Back Forward Up Cut Copy Paste Undo Delete Properties Views Address C CAMELSEC Sheet Folders Melsec File Folder 7231 02 8 08 PM H E Act MComShCorw exe Application 230202 6 05 PM Ese ime Celink MMS home dll Application Extension 73002 6 04 PM a Common MMS hE nar dl Application Extension 77 30702 5 49 PM H Cskp MXShEngn ere Application 7 30 02 6 06 PM DNaviPlus MS hh eru dll Application Extension 7 16
35. agnosis count jo Setup Utility Da An error message appears if they are not communicating normally CPU name Check the error definition and remove the error Mean time of communication Gal seins Laine function Es 14 Setting the lt lt Access Data gt gt tab ata Operation Interval Device Trigg er Har ndshake cs Loggin E Set the device of which data to be logged Communication Settings a Make the following settings After setting click the lt lt Operation time gt gt tab _ _ gt En ee ee 2 as e e Logical Station Number 1 A gt A gt a es E pa gt gt a es Device DO po gt Se ees o A oS Data type 16bit integer e gt SS Ss AH A Value DEC Zoom 1 Cell Area Name Logical Sta Operation Interval Device Trigger Handshake CSY Logging N O of C ell S z 5 aamen E ol Bese Cell Settings Logging Ed 15 Setting the lt lt Operation Interval gt gt tab Iv Set the logging operation interval Operation Daily C Weekly Monthly E Make the following settings Set the Operation Interval Check n Regular interval Minutely oond a C Hourly iimte a C Timetable a Operation d ay Daily H Operation time Regular interval 5 seconds Se Logging Time Zone Log Always Log Always C Log only during the specified time zone Cell Area Name Logical Sta Operation Interval Device Trigger Handshake CSV Logging Mandatory Settings Not set RRR N
36. ange without notice
37. ase instal this package afer executing EnvMEL Setup Eve fiom CD ROM b of 2 When message appears at start of installation After the operation is complete restart installation operation To the next page 3 INSTALLATION AND UNINSTALLATION Install From the previous page t There is a possibility for improper installation e if you execute without closing all the running applications Including resident programs Ok Welcome User Information Welcome to the SWnD5 SHEET Setup program This program will install SWnD5 SHEET on your computer It is strongly recommended that you exit all Windows programs before running this Setup program Click Cancel to quit Setup and then close any programs you have running Click Next to continue with the Setup program WARNING This program is protected by copyright law and international treaties Unauthorized reproduction or distribution of this program or any portion of it may result in severe civil and criminal penalties and will be prosecuted to the maximum extent possible under law Cancel Type your name below You must also type the name of the company you work for Name Mitsubishi SSCS Company MITSUBISHI ELECTRIC Co lt Back Cancel Registration Confirmation ou have provided the following registration nbormatior Mame Mitzubizhi Company MITSUBISHI ELECTRIC Eo la this registration information correct To the next page MELS
38. c using methods of MX Sheet For details refer to the MX Sheet Version 1 Operating Manual Write function Logging function monitor function Automatic print function Logging Write Date D0 D 002 7 31 Wed 17 00 00 E AE bo D D2 D3 002 7 31 Wed 17 05 00 101 102 103 104 002 7 31 Wed 17 10 00 002 7 31 Wed 17 15 00 Monitor po oF D2 D3 Alarm summary function Generation 2002 07 31 Wed 16 57 30 Material storange Minor failure Comment display function Automatic save function Temperature within the normal range Temperature over the upper limit Generation 2002 07 31 Wed 16 57 30 Material storange Minor failure Restoration 2002 07 31 Wed 16 59 35 FA E A Excel book file Error log setting function Kind Date Cell Area Name ErrorNo Contents Informatior 2004 07 14 Wed 19 45 03 OO000000 Communication we Warning 2004 07 14 Wed 19 45 05 Logging function e1000021 Communication er lt 00010003 Hex 0 Time out error Though the time o1 The corrective acti Review the time o Set it again on the HTML file CSV file Protect MX Sheet setting function Protect MX Sheet setting Create button function MXShBtnStart Password optional 2222 Review the syster Retry the method Perform Close oni Exit the program lt ErrorCode 180641 00000002 Communication we MX Sheet Information 2004 07 14 Wed 19 45 13 CLO thaxagap RRA ERA ADA
39. can refer to it and always forward it to the end user Design Instructions AN WARNING e Build an interlock circuit outside the PLC system to ensure that the whole system always works safely when changing the data of the running PLC or controlling the PLC status from the personal computer In addition be sure to incorporate the corrective action into the system to deal with the communication error due to the poor cable connection while operating the PLC CPU online from the peripheral device Operating Precautions AN CAUTION e Read the manual carefully and confirm the safety before connecting a personal computer with the running CPU module to perform the online operation especially forced output and operating status change Misoperation may cause the machine damage or accidents e CONDITIONS OF USE FOR THE PRODUCT e 1 Mitsubishi programmable controller the PRODUCT shall be used in conditions 2 i where any problem fault or failure occurring in the PRODUCT if any shall not lead to any major or serious accident and li where the backup and fail safe function are systematically or automatically provided outside of the PRODUCT for the case of any problem fault or failure occurring in the PRODUCT The PRODUCT has been designed and manufactured for the purpose of being used in general industries MITSUBISHI SHALL HAVE NO RESPONSIBILITY OR LIABILITY INCLUDING BUT NOT LIMITED TO ANY AND ALL RES
40. cel Apply Optional Settings Notset Setalready To the next page 6 OPERATING MX Sheet From the previous page MELSOFT cel Settings Write fonction ES 7 Applying the settings Set the Operation Interval Operation Daily C Weekly C Monthly la E T ja e T y T j e i C Mi e A C Ti raid Regular interval Minutely Hourly Mimte 4 Time table aH 2 rt y Dan Cell Area Name Logical Sta Operation Interval Device Trigger Handshake CSV Logging Write function 1 CPU CO Settings No settings No settings Mandatory Settings Notset Setalready OK Cancel Optional Settings Notset Setalready s Data Window Mx Sheet M Help A KD Cell Setting L j pa A Automatic Save Setting K Automatic Print Settina O Automatic Communication Startup Setting 4 Start Communication B 1Shot Communication S Cut Cell Area T Copy Cell Area C aste Cell rea Delete Cell Area D Change Sheet Name N Create Button w Protect Mx Sheet setting R OptionstI Setting Data Export x version Info MX Sheet Communication will commence e Is ik OK To the next page Click to enable the settings of the Cell Setting dialog box After clicking Apply check that the cell area has been registered as shown on the left screen and click OK 8 Starting communication Choose MX Sheet
41. cel book Save in B My Documents y y a 5 Tools y my music Start Excel and save the Excel book Es 2 My Pictures History S My Documents File name Mx Sheet xls My Network J Places Save as type microsoft Excel Workbook Cancel J 2 Specifying the cell area Drag the cell B2 to D2 in this example on the left screen to specify the cell area in which written data will be entered E Microsoft Excel MX Sheet File Edit View Insert Format Tools Data Window Deua 6a k amm TT 3 Displaying the Cell Setting dialog box Data Window mx Sheet M Help o Choose MX Sheet Cell Setting from the menu bar to A o o E De BE display the Cell Setting dialog box A Automatic Save Settingtk p 7 U Automatic Print Setting D Automatic Communication Startup Setting a a Start CommunicationtB End CommunicationtE 1Shot Gommunication a Options IM Setting Data Export Version Info 4 6 OPERATING MX Sheet MELSOFT From the previous page Cell Settings 4 Setting the lt lt Use gt gt tab Use Set the setting items of the lt lt Use gt gt tab as follows Cell Area Name write iak Cell Area B2 D2 JV Set the Color of Grid line i V Set the Color for Filling i After setti ng 7 cl ick the lt lt Access Data gt gt ta b Cell Display Direction Left to Right Use Acc
42. ess Data Operation Interval Device Trigger Handshake Use Write Cell Area Name Write function Cell Area B2 D2 Cell Display Direction Left to Right Cell Area Name Logical Sta Operation Interval Device Trigger Handshake CSY Logging Mandatory Settings Notset Setalready OK Cancel Apply Optional Settings Notset Setalready Cell Settings Write function 5 Setting the lt lt Access Data gt gt tab Set the device where data will be written Make the following settings After setting click the lt lt Operation Interval gt gt tab Logical Station Number 1 Device DO Data type 16bit integer Value DEC Zoom 1 a a e aa a No of celle 3 1 Refer to Section 6 1 for the logical station number o id me a setting method Optional Settings Notset Setalready Coll Settings Write function 6 Setting the lt lt Operation Interval gt gt tab Use i Ope a va i Device Trigger Handshake IV Set the Operation Interval Set the write operation interval ge ee Make the following settings C Monthly rc E rc r aaa yl Set the Operation Interval Check oan Regular interval Minutely oond a Hourly iimte a C Timetable aH Operation d ay Daily 5 a Operation time Regular interval 5 seconds Cell Area Name Logical Sta Operation Interval Device Trigger Handshake CS Logging Mandatory Settings Notset Setalready OK Can
43. ft Excel 2000 English version Microsoft Excel 2002 English version Microsoft Excel 2003 English version Microsoft Excel 2007 English version or 32 bit Microsoft Excel 2010 English version MX Component MX Component version 3 01B or later 1 A Pentium 300MHz processor or higher is recommended when using Windows XP and 1GHz processor or higher is recommended when using Windows Vista or Windows 7 2 This product does not work with a multiprocessor IBM PC AT compatible personal computer because the driver is not compatible with it 3 Service Pack 3 or more is needed when using Windows NT Workstation 4 0 4 128MB or more is recommended for Windows XP 1GB or more is recommended for Windows Vista and 32 bit Windows 7 and 2GB or more is recommended for 64 bit Windows 7 5 Excel sheets created in the English environment can be used in the English environment only They cannot be used in the other environment 6 Windows XP Service Pack 2 or later is required for Microsoft Excel 2007 2 OPERATING ENVIRONMENT MELSOFT E 8 For 32 bit Microsoft Excel 2010 Windows XP Service Pack 3 Windows Vista Service Pack 1 or higher or Windows 7 or later is required 64 bit Microsoft Excel 2010 is not supported When executing the Communication Setup Utility with administrator authority from Excel MX Component Version 3 12N or later is required 1 When Windows
44. fter making the above settings click OK l To the next page 6 OPERATING MX Sheet From the previous page Automatic Save List E 4 Specifying the automatic save conditions E Laer cenaam S no aage Mostoge Ste oe After making sure that the automatic save name has been added to the list and the Enable filed has a check mark click to close the Automatic save list Pe cieo conica s Data Window MX Sheet M Help Choose MX Sheet Start Communication from the asjad eS O oo menu bar to start communication za wj T z i i 7 1 A Automatic Save Settina K po l As the confirmation dialog box appears click Yes Automatic Print SettingiQ ie Automatic Communication Startup Setting A 30 58 Start Communication B do 59 03 End comman atome e z 15hot Communication S tet 9 18 BS cutcell realT 19 23 a Copy Cell Area C a Paste Gell GreatPi Ee SE Delete Cell Area D El E 19 43 34 Change Sheet Mamech Create Buttoni Protect M Sheet setting R Options Li Setting Data Exportts Version Info g MX Sheet Communication will commence e Is ik OK amp 6 Starting the PLC Monitor Utility E eee From the Start menu choose All Programs aaa MELSOFT Application MX Component PLC Monitor Utility to start the PLC Monitor Utility As the Transfer setting dialog box appears make the following setting
45. fying the cell area Drag the cell B2 to F2 in this example on the left screen to specify the cell area in which monitor data will be displayed Diw OD 01 wN l SE E __ 3 Displaying the Cell Setting dialog box A ll ee Choose MX Sheet Cell Setting from the menu bar to he g Cell Setting L M A E N O a display the Cell Setting dialog box Automatic Print Setting O i ae JE Version Info Vv l To the next page 6 OPERATING MX Sheet MELSOFT From the previous page J ee 4 Setting the lt lt Use gt gt tab eee Set the setting items of the lt lt Use gt gt tab as follows cetareaname Mentor fun After setting click the lt lt Access Data gt gt tab Cell Area B2 F2 V Set the Color of Grid line i Y Set the Color for Filling i Cell Display Direction Left to Right Me U S e a M O n i to r Cell Area Name Monitor function Cell Area B2 F2 Cell Display Direction Left to Right Cell Area Name Logical Sta Operation Interval Device Trigger Handshake CSY Logging Mandatory Settings Notset Setalready OK Cancel Apply Optional Settings Notset Setalready Cell Settings Monitor function x 5 Setting the lt lt Access Data gt gt tab cvs rene Nn SVL Set the device of which data to be monitored Make the following settings AAA lo a After setting click the lt lt Operation Interval gt gt tab Te ee da a Wo
46. ger The device trigger function sets the device condition for device data collection write and collects or writes the device data when the set device condition holds lt Collecting Writing device data while bit device is on gt Collecting Writing Collecting Writing 1 device data device data A KE A KA OFF Target functions Logging Monitor Write Alarm summary Comment display Automatic save Automatic print APP 2 APP 2 APPENDICES MELSOFT Appendix 1 4 Handshake Setting a handshake between the PLC and personal computer ensures the device data collection write The handshake function determines whether to send data or not based on the send request and receive response signals exchanged between the personal computer and PLC before data updating When handshake begins with PLC side request SL LAIA A ELLE IL ESL OS SHELL ET IS CY Lo oe LELLI Responding device on the PC side Device data C collection write Requesting device on the PLC side Requesting device on the PC side Responding device on the PLC side APP 3 APP 3 APPENDICES MELSOFT Appendix 1 5 CSV logging The CSV logging function simultaneously displays device data on an Excel sheet using the logging or monitor function and saves collected data as a CSV file Using a single CSV file enables long term data collection file Display on Excel sheet
47. gistration manually in Excel 2 If the Register add in is not marked in the Select add in dialog box in step 9 of Section 3 1 2 the MX Sheet menu will not be registered to the menu bar Register MX Sheet as an add in software manually after installation Refer to Section 3 1 4 for the manual add in registration method 3 INSTALLATION AND UNINSTALLATION 3 1 4 Manual add in registration MELSOFT MX Sheet menu will not be registered to Excel if Register add in is not marked in Select add in dialog in step 9 of Section 3 1 2 during installation Add in registration is required to use MX Sheet Register MX Sheet as an add in software in the following procedure El Microsoft Excel Book1 Ex File Edit View Insert Format Tools Data Window Help O a kel amp a ml de e Spelling F7 te A Error Checking Speech gt Share Workbook Track Changes gt Protection gt Online Collaboration b Goal Seek Scenarios Formula Auditing gt Tools on the Web Customize Options To the next page Start Excel Choose Tools Add Ins from the menu bar to display the Add Ins dialog box i 1 For Microsoft Excel 2007 or later follow 2 1 and 2 2 2 1 Select Office button gt Excel Options Book1 Microsoft E a 9 View Add Ins TIME Reappl l Sort Filter Recent Documents New
48. gt gt tab and click Wizard l To the next page What is logical station A number assigned to the group of data that is integrated from the connection target information required for communication within the Communication Setup Utility 6 OPERATING MX Sheet MELSOFT From the previous page Communication Setting Wizard Introduction E 7 Setting the logical station number This Communication Setting Wizard wil set the Enter 1 in Logical station number and click Next gt communication information for 4CT You can press Back at any time to change your selections Please click Next to begin Please select the logical station number Logical station number 1 x Cancel Back Finist Communication Setting Wizard PC side Ea 8 Setting the personal computer side interface Please select the PC side UF Make the following settings and click Next gt PC side IF Serial v Communication setting Connect port COM1 gt PC side I F Serial Time ou 10000 ms Connect port COM1 Time out 10000 Ea 9 Setting the PLC side interface Make the following settings and click Next gt PLC sidelF CPU modue v Communication setting q AA CPU type aoze sal PLC side I F CPU module Transmission speed 19200 bps CPU type Q02 H a bran oi E Transmission speed 19200 Control DTR or RTS Control l To the next page 6 OPERATING MX Sheet MELSOFT From the previo
49. indows NT Workstation Operating System Version 4 0 Dcom95 exe and Axdist exe are in the Update folder on CD ROM 3 INSTALLATION AND UNINSTALLATION b MELSOFT Installing EnvMEL Execute Setup exe in the EnvMEL folder on this product CD ROM Install this product after executing the Setup exe x When user account control is enabled the following screen appears Click Allow or Yes lt Windows Vista gt lt Windows 7 gt User Account Control Pp User Account Control nese la An unidentified program wants access to your computer ga Do you want to allow the following program from an unknown publisher to make changes to this computer Don t run the program unless you know where it s from or you ve used it before C 7 SETUP EXE ds mime a WM Unidentified Publisher a TERR File origin CD DVD drive Cancel I don t know where this program is from or what it s for Y Show details Yes No Y Allow Itrust this program I know where it s from or I ve used it before Change when these notifications appear Lv Details User Account Control helps stop unauthorized changes to your computer After executing the above exe file install the product again If this product is not installed properly at this time reboot the personal computer x When the following screen appears regardless of the installation result select This program installed correctly
50. ing program from an z unknown publisher to make changes to this computer Don t run the program unless you know where it s from or you ve used it efore Program name ActComm exe l ActComm exe Publisher Unknown Unidentified Publisher File origin Hard drive on this computer gt Cancel i I don t know where this program is from or what it s for Y Show details Yes No _ gt Allow Change when these notifications appear I trust this program 1 know where it s from or I ve used it before pl User Account Control helps stop unauthorized changes to your computer Clicking Allow or executes the Communication Setup Utility with administrator authority When executing without administrator authority the Communication Setup data can be checked however when clicking finish button on the Communication Setting Wizard the error occurs as follows e Communication Setting wz EEES Updating the system information data failed There is a possibility without the operation authority Please execute it by the administrator authority user There is a possibility that the operating environment of the application is corrupt Re install the application and try again Ecco EY Ala 6 Starting the Communication Setting Wizard ee oee After starting the Communication Setup Utility click the Logical station number ba Wizard a a a E lt lt Target Setting
51. later install VBA If not installed the following error message appears and MX Sheet cannot be used Repairs to MXShMenu xla e Excel was able to open the file by repairing or removing the 1 unreadable content This workbook has lost its YBA project ActiveX controls and any other programmability related features Click to view log file listing repairs D IDOCUME 11alLOCALS 11TemplerrorO20720 01 xml 2 To manually install the add in MXShRibbon xlam for Microsoft Excel 2007 or later install VBA If not installed the following error message appears and MX Sheet cannot be used Microsoft Office Excel Microsoft Office Excel cannot access the file D MELSEC Sheet MxShRibbon xlam There are several possible reasons The file name or path does not exist The file is being used by another program The workbook you are trying to save has the same name as a currently open workbook 3 INSTALLATION AND UNINSTALLATION MELSOFT 3 2 Uninstallation This section explains MX Sheet unistallation E Control Panel aae 1 Select Add or Remove Programs from Control Panel File Edit View Favorites Tools Help Kp Bad E JO search j Folders 73 and double click it Adee be Ss a ow To display Control Panel select Start Control Panel Add or Administrative Date and Time Display Folder Options Tools 4 Opti rograms 1 p gt See aiso 2 S REMARK ni Game Internet Ke
52. llation of this software may impair contact the software vendor for software that has or destabilize the correct operation of your system passed Windows Logo testing either immediately or in the future Microsoft strongly recommends that you stop this installation now and contact the hardware vendor for software that has passed Windows Logo testing Continue Anyway d ion Continue Anyway STOP Installation 10 The left screen appears when installation is complete Click OK 3 INSTALLATION AND UNINSTALLATION From the previous page Restarting Windows Setup has finished copying files to your computer Before you can use the program you must restart Windows or your computer Choose one of the following options and click OF to finish setup MELSOFT When the left screen appears on Windows Vista regardless of the installation result choose This program installed correctly Do not choose Reinstall using recommended settings because the installer installs an incorrect module If choose reinstall MX Sheet with following POINT on the next page Program Compatibility Assistant This program might not have installed correctly If this program didn t install correctly try reinstalling using settings that are compatible with this version of Windows Program Setup Launcher Publisher InstallShield Software Corporation Location F EnwMEL SETUP EXE Reinstall using recommended settings
53. lly saved Excel file fn Shared Documents F My Computer amp My Network Places Details 6 OPERATING MX Sheet El Microsoft Excel Book1 xls MELSOFT 2 Setting automatic save This section explains an Excel book automatic save setting procedure File Edit View Insert Format Tools Data Window Mx Sheet M Help 1 Selecting automatic save setting OsGs 6RY BAS gt MAYO Mh o Ee AZ _ ea E 7 14 2004 4 31 38 PM T 2 2004 07 14 Wed 16 31 38 2004 07 14 Wed 16 31 43 a 2004 07 14 Wed 16 31 48 5 2004 07 14 Wed 16 31 53 6 2004 07 14 Wed 16 31 58 2004 07 14 Wed 16 32 03 8 2004 07 14 Wed 16 32 08 9 2004 07 14 Wed 16 32 13 10 2004 07 14 Wed 16 32 18 111 2004 07 14 Wed 16 32 23 12 13 14 15 16 17 18 19 20 21 Automatic Save List Enable Automatic Save Name End of communication Date time Device Trigger Clear cell area Automatic Save Automatic Save Name Line1 Lot completion Save at the end of communication E Z 12 2 E 27 is 21 E E Cell Setting L 2 E Automatic Save Setting k utomatic Print Setting O Start Excel and choose MX Sheet Automatic Save Setting from the menu bar to display the Automatic Save dialog box Start Communication B Ena Communication E 1Shot Communication S Cut Cell Area T Copy Cell Area C Delete Cell Area D Change Sheet Name N
54. m in File name on the displayed Browse screen and click OK Look in O Sheet 7 X gi Ar A My Recent Sample Documents Eit myshMenu xla E Desktop 25 meShRibbon xlam y My a Documents q Computer My Network rt 3 Places File name MxShRibbon xlam Files of type add ins xlam xla xdl ales 7 For Microsoft Excel 2007 or later check a Sheet Add in eee that Additional MX Sheet Add in is _ Analysis ToolPak VBA CARA E Conditional Sum Wizard perennes selected on the displayed Add Ins dialog B A Internet Assistant VBA Browse nl E box an d cl ck E Solver Add in Additional Mx Sheet Add in MELSEC COMMUNICATION ADD IN MACRO 8 Make sure that MX Sheet has been added to the menu bar The icon buttons are also displayed This means manual add in registration is complete indow MX Sheet M Help 8 22 Me gt Aral 1 For Microsoft Excel 2007 or later the lt lt Add Ins gt gt tab is added on the ribbon and MX Sheet group and icons are added to it Automatic Save Setting K Automatic Print Setting O Version Info V 157 4 4 mM Sheeti Sheet2 Sheet3 lt Ready 3 Registration complete 3 INSTALLATION AND UNINSTALLATION MELSOFT 1 To manually install the add in MXShMenu xla for Microsoft Excel 2007 or
55. ncluded in the product Specify the installation destination folder If you do not change the destination folder click Next gt If you change the destination folder click and specify a new drive and folder Register the MX Sheet to Excel as an add in software Mark the checkbox when registering an add in The checkbox is marked by default Click Next gt For confirmation the left message appears Click OK 3 INSTALLATION AND UNINSTALLATION MELSOFT To make MX Sheet available register it to Excel as an add in software Normally register an add in software as instructed in step 9 If the Register add in checkbox is unmarked in step 9 the following message appears after installation Information i Add in registration of the Mx Sheet menu was not performed Please carry out add in registration manually From Excel Refer to Section 3 1 4 for the manual MX Sheet add in registration method When installing an add in for Microsoft Excel 2007 or later the add in that hides the tabs is automatically installed for the Excel Da y ed e 3 Home Booki Microsoft Excel x Lo 4 z a g 2 if Sot amp Find amp 2 Filters Select Editing Insert Page Layout Formulas Data Review View Developer Add Ins 3 Insert 3 Delete Hel Format Cells Fa Conditional Formatting 43 Format as Table Cell Styles Styles General 7 Go Marine lt 0 00 00
56. ne hd Display Contents Add title V Add date and time details MX Sheet setting becomes unchangeable Operation when cell is full To scroll C Display from the beginning after clearing the cell area r m C Display from the beginning without clearing the cell area Cell Area A2 Set the Color of Grid line Set the Color for Filling Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CSY Logging Logging function Logging 1 006 115 Settings No settings No settings No settings Mandatory Settings Notset Setalready OK Cancel Optional Settings Mo dotset z Setalready 1 The password can be set or cancelled by choosing MX Sheet Protect MX Sheet setting Unprotect MX Sheet setting on the menu bar APP 6 APP 6 APPENDICES MELSOFT Appendix 1 9 Error log setting When communication is started an Error Log sheet that indicates the communication status of MX Sheet is created and the communication status error information and corrective actions are output To this Error Log sheet the following error log setting can be made by Option setting 1 Setting the error log types to be output The error log types Information Warning Error to be output can be specified Setting for outputting all error log A B E D E 1 Kind Date Cell Area Name ErrorNo Contents 2 Informatior 2004 07 14 Wed 17 31 05 OO000000 Communication was started Err
57. nnnnnnnnnnnnnnnnnannnnnns APP 6 Append T X Emror log Seting eea a a A A a a APP 7 Manuals The following manuals are relevant to this software package Refer to the table when ordering the manuals Relevant Manuals Manual Name Manual Number Model Code MX Sheet Version 1 Operating Manual SH 080348E Explains the operation procedures setting and operation methods of MX Sheet Sold separately 13JU35 MX Component Version 3 Operating Manual SH 0800271 Explains the setting and operation methods of each utility on MX Component Sold separately 13JU32 MX Component Version 3 Programming Manual SH 080272 Explains the programming procedures details and error codes for ACT control Sold separately 13JF66 Note The MX Sheet Version 1 Operating Manual is stored on CD ROM of the corresponding software package in PDF format Any of the manuals is available separately in printed form Please indicate its manual number model code in the above table when ordering the printed manual e We don t guarantee the commercially available Windows based software products that have been introduced in this manual e We hold the copyrights of this software package e No part of this manual may be transcribed or duplicated in any form without prior permission by Mitsubishi Electric Corporation e We have attempted to cover all the revisions of software and hardware but this manual may not contain the latest revisions e We assume that
58. nstructed in 2 E Microsoft Excel MX Sheet xls Mx SheetiM PJ hd PI J Pp 00 00 o Oo Oo a O 1 00 4 Oo 117 7 m c myo BIj Logging times are displayed DO to D4 contents are displayed in order 10 logging data are displayed from left to right The latest logging data is displayed on the last line Scrolled up in order 6 OPERATING MX Sheet MELSOFT 2 Setting MX Sheet This section explains the procedure of creating an Excel sheet for logging function leaf 1 Saving the Excel book B ocumen s v A Ci Ed Tools re tie Start Excel and save the Excel book Amy Pictures 2 Specifying the cell area Drag the cell B2 to G11 in this example on the left screen to specify the cell area in which logging data will be displayed l N 3 Displaying the Cell Setting dialog box rmat Tools Data Window Mx Sheet M Help i Ty mad O Choose MX Sheet Cell Setting from the menu bar to j A automatic Save Setting k display the Cell Setting dialog box Automatic Print Settina O OC a a EN Version Info To the next page 6 OPERATING MX Sheet MELSOFT From the oe page cell ES 4 Setting the lt lt Use gt gt tab se Access Data Operation Interval Device Trigger Handshake CSV Logging p Set the setting items of the lt lt Use gt gt tab as follows Cel Area nae 9990 funcion After setting click the
59. oS Microsoft Windows XP Professional Operating System English version MX Sheet MX Sheet Version 1 MX Component MX Component Version 3 01B Microsoft Excel 2002 English version PLC CPU QO2HCPU RS 232 cable QC30R2 Connect to COM1 on personal computer side Printer compliant with the personal computer specifications 4 SYSTEM CONFIGURATION USED IN THIS MANUAL MELSOFT MEMO 9 MX Sheet OPERATION PROCEDURE MELSOFT 9 MX Sheet OPERATION PROCEDURE This chapter explains the MX Sheet operation procedure Start Excel and save the Excel book Select the function to be used and make MX Sheet settings Logging function Monitor function Write function Alarm summary function Comment display function Automatic save function Automatic print function Start communication End communication Completion 1 Be sure to save the Excel book before making the MX Sheet settings MX Sheet cannot be set unless the Excel book is saved Refer to the Excel manual for Excel operation 9 MX Sheet OPERATION PROCEDURE MELSOFT MEMO 6 OPERATING MX Sheet MELSOFT 6 OPERATING MX Sheet This chapter explains the following functions with examples Reference Section Logging function Section 6 1 Monitor function Section 6 2 6 1 Logging This section provides an example of creating an Excel sheet using the logging function 1 Creation example Set the following Excel sheet as i
60. on provides the outlines and brief explanations of the functions For more details refer to the MX Sheet Version 1 Operating Manual Appendix 1 1 Alarm summary The alarm summary function converts the ON OFF information into the corresponding alarm comment character strings and accumulates them on an Excel sheet as an alarm history The followings are available by specifying in advance when the alarm history reaches the last line Scrolling Printing Excel sheet Saving Excel book The line operation ratio and other conditions can be checked easily by accumulating the alarm data history 2002 07 31 Wed 16 57 30 AGA ENANA CAI ESG Alarm data are accumulated as 2002 07 31 Wed 16 57 30 bit devices turn on off 2002 07 31 Wed 16 59 35 Io o EA APP 1 APP 1 APPENDICES MELSOFT Appendix 1 2 Comment display The comment display function converts a bit device value or word device value into the corresponding comment character strings and displays them on an Excel sheet A comment is displayed according to the change of device value In the following example the upper and lower limit values are set for a device so that the corresponding warning message will appear when the device value falls outside the range Temperature within the normal range Temperature within the normal range Temperature Temperature rise fall Temperature over the upper limit Temperature below the lower limit Appendix 1 3 Device trig
61. one software package will be used on one personal computer e We permit the user to use this software package including this manual based on the Software License Agreement e We are not liable for consequences or influences due to this software package including this manual e The specifications of this software package and the descriptions in this manual may be altered in future without prior notice Generic Terms and Abbreviations Unless otherwise stated this manual uses the following abbreviations and terms for the explanation of MX Sheet Generic Term Abbreviation MX Sheet Generic product name for product types SW1D5C SHEET E and SW1D5C SHEET EA EA indicates a volume license product IBM PC AT compatible Abbreviation of the IBM PC AT or its compatible personal computer Abbreviation of the MELSEC Q series corresponding PC CPU module PC CPU modul aes CONTEC CO LTD Personal computer Generic term of PC CPU module and IBM PC AT compatible Personal computer Generic product name for product types SW3D5C ACT E and SW3D5C ACT EA MX Component tae l EA indicates a volume license product Microsoft Windows 7 Starter Operating System Microsoft Windows 7 Home Premium Operating System Microsoft Windows 7 Professional Operating System Windows 7 Microsoft Windows 7 Ultimate Operating System and Microsoft Windows 7 Enterprise Operating System Note that the 32 bit version is designated as 32 bit Windo
62. or 2004 07 14 Wed 17 31 06 Monitor function e1000009 The specified logical station number is not set The corrective action is as follows Create the logical station number after performing communication E setting Warning 2004 07 14 Wed 17 31 08 Logging function e1000021 Communication error has occurred in the open close of communication lt 00010003 Hex 0160640b Hex gt Time out error Though the time out period had elapsed data could not be received The corrective action is as follows Review the time out value of the property Set it again on the communication settings utility Review the system e g PLC CPU module setting and cable status Retry the method Perform Close once and execute Open again Exit the program and restart the IBM PC AT compatible lt ErrorCode 160840b Hex gt Informatior 2004 07 14 Wed 17 31 40 00000002 Communication was completed 40004 2 Automatic Error Log sheet display change setting At error occurrence the Error Log sheet displayed can be automatically changed 7 ZARZA OPIS SPSS SSS LI ITF ALA EOS LL TR Communication error occurrence Error Log sheet is displayed Automatic display change A B Cc D 1 Kind Date Cell Area Name ErrorNo Contents 2 Informatior 2004 07 14 Wed 17 34 35 DODODODO Communication was started Warning 2004 07 14 Wed 17 34 36 Logging function e1000021 Communication error has occurred in the open close of communication
63. ot set ie ie o _Sancel two To the next page 6 OPERATING MX Sheet MELSOFT From the previous page l RSE REI gt x 16 Applying the settings Fees ag A Click Apply to enable the settings of the Cell Setting Operation Daily C Weekly dialog box After clicking Apply check that the cell area has been registered as shown on the left screen and click OK Operation Regular interval C Minutely AE C Hourly Mite C Time table pe i E de Logging Time zone Log Always C Log only during the specified time zone Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CSV Logging Logging function Logging 1 CPU CO Settings No settings No settings No settings Mandatory Settings Notset Setalready OK eat Optional Settings Notset Setalready J I 7 Crec e sting ls Data Window Mx Sheet M Help Check whether the settings in steps 1 to 16 are correct z E I IAE o B or not by using the 1 shot communication function of MX El j A Automatic Save Settimg K 7 U Automatic Print Setting O Sheet C Automatic Communication Startup Setting 4 H Make 1 shot communication in the following procedure Start CommunicationtE 1 Choose MX Sheet 1 Shot Communication from the menu bar 2 As the 1 Shot Communication dialog box appears select the cell area name set in step 4 logging function in this example as the Cell Area Name Sey 3 Click to
64. publishers you trust How can I decide which device software is safe to install The either of the following screens may appear behind the Windows Security screen Then press the keys to bring it to the front Click on the following screens CAWindows temp wdreg exe Error Bal CA Win o a Sej A Failed to install the INF file C Windows TEMP WINDRVR6 INF i iv wi WN AV wi i 4 f gt tse updating the driver hwid NINDRVR6 ith the INF file The Failed trying to install the driver system cannot find the file specified 7 For Windows XP the following screen may appear at installation Click Continue We checked operations in Windows XP Problems never occur after installation The following screen may appear behind another screen Then press the Alt keys to bring it to the front AAA Hardware Installation 1 The software you are installing has not passed Windows Logo The software you are installing for this hardware jad D yen ae ie with Windows lt P Tell me why MITSUBISHI GOT1000 USB Controller Continuing your installation of this software may impair has not passed Windows Logo testing to verify its compatibility or destabilize the correct operation of your system with Windows lt P Tell me why this testing is important either immediately or in the future Microsoft strongly recommends that you stop this installation now and Continuing your insta
65. rosoft Windows XP Professional Operating System Though they differ slightly from those of the other OSes refer to and perform operations 3 1 Installation This section explains MX Sheet installation 3 1 1 Installation precautions 1 Precautions on the OS Log on as the user who has the Administrator attributes when any of the following OSes is used Microsoft Windows NT Workstation Operating System Version 4 0 Microsoft Windows 2000 Professional Operating System Microsoft Windows XP Professional Operating System Microsoft Windows XP Home Edition Operating System Microsoft Windows Vista Home Basic Operating System Microsoft Windows Vista Home Premium Operating System Microsoft Windows Vista Business Operating System Microsoft Windows Vista Ultimate Operating System Microsoft Windows Vista Enterprise Operating System Microsoft Windows 7 Starter Operating System Microsoft Windows 7 Home Premium Operating System Microsoft Windows 7 Professional Operating System Microsoft Windows 7 Ultimate Operating System Microsoft Windows 7 Enterprise Operating System 3 INSTALLATION AND UNINSTALLATION MELSOFT 2 Software confirmation Make sure that the following software programs have been installed in the personal computer where MX Sheet will be installed MX Component Version 3 01B or later Microsoft Excel 2000 or later 3 Precautions on using Microsoft Excel 2007 or later
66. s Utility setting type Check Logical station number 1 After making the above settings click OK Connect Retry Times fo Cancel y To the next page 6 OPERATING MX Sheet MELSOFT From the previous page l aa I 7 Specifying the monitor device entes ete ene Bene Choose the lt lt Device Batch gt gt tab of the PLC Monitor Utility and make the following setting Device YO ee ica After making the above settings click Start monitor Data format DEC Bit order F 0 x Host station Exit PLC Monitor Utility oR 8 Writing to device Menu Online Help Device Batch Butter Memory Entry Device Change the YO device status O LE Double click the monitor display area of the lt lt Device co oe 9008 Batch gt gt tab 0000 0000 0000 0000 SOC ECL The Write to Device dialog box appears 0000 0000 0000 0000 oo00 Does ERE Forcibly turn on YO in the following procedure 0000 0000 0000 0000 20 909 000 016 Monitor format Bit amp vVord 0000 0000 o a 2 o k Display 16bit integer 4 T yq a D Ww Bit D a Data format DEC ype In evice In evice gt Click Force ON Host station Write to Device After making the above settings click Close Bit device Device YO Force OFF Toggle force Word device Buffer memory Device Buffer memory Module start 1 0 HEX Address Setting value 16bit integer DEC Set
67. s limited only for the specific applications agreed to by Mitsubishi and provided further that no special quality assurance or fail safe redundant or other safety features which exceed the general specifications of the PRODUCTs are required For details please contact the Mitsubishi representative in your region REVISIONS The manual number is given on the bottom left of the back cover Print Date_ Manual Number Aug 2002 SH NA 080347E A First edition Dec 2003 SH NA 080347E B Addition SOFTWARE USER REGISTRATION Correction Section 3 1 2 Aug 2004 SH NA 080347E C Addition Section 6 6 Appendix 1 8 Appendix 1 9 Correction Section 1 1 Section 1 2 Chapter 2 Section 3 1 1 Section 3 1 3 Section 6 1 Section 6 2 Section 6 3 Section 6 4 Section 6 5 Sep 2005 SH NA 080347E D Chapter 2 Section 6 1 Section 6 2 Section 6 3 SH Oct 2007 NA 080347E E Addition Generic Terms and Abbreviations Chapter 2 Section 3 1 1 Section 3 1 2 Section 3 1 3 Section 3 1 4 Section 3 2 May 2008 SH NA 080347E F Generic Terms and Abbreviations Chapter 2 Section 3 1 1 Section 3 1 2 Section 3 2 Jun 2009 SH NA 080347E G SOFTWARE USER REGISTRATION Manuals Section 3 1 2 Dec 2009 SH NA 080347E H CONDITIONS OF USE FOR THE PRODUCT SAFETY PRECAUTIONS SOFTWARE USER REGISTRATION May 2010 SH NA 080347E 1 Addition Generic Terms and Abbreviations Chapter 2 Section 3 1
68. t me before enabling Unsafe for Initialization UFI controls with additional restrictions and Safe for ActiveX Settings Initialization SFI controls with minimal restrictions Prompt me before enabling all controls with minimal restrictions Enable all controls without restrictions and without prompting not recommended potentially dangerous controls ican run V Safe mode helps limit the control s access to your computer y Complete 3 4 MELSOFT Select Trust Center from the list shown on the left and click Trust Center Settings Select Add ins from the list shown on the left and uncheck the items when they have the check marks Select Macro Settings from the list shown on the left and select Enable all macros not recommended potentially dangerous code can run Select Active X Settings from the list shown on the left and select Enables all controls without restrictions and without prompting not recommended potentially dangerous controls can run After completing all settings close Excel 2007 3 INSTALLATION AND UNINSTALLATION MELSOFT 5 Security Setting of Microsoft Excel 2010 The following explains the setting procedure of required Trust Center when using MX Sheet with Microsoft Excel 2010 Home Insert Page Layout Calibri al Save El save As ES Open Ga Close Info
69. ting automatic print This section explains an Excel sheet automatic print setting procedure El Microsoft Excel Book1 xls EN File Edit View Insert Format Tools Data Window MX Sheet M Help 1 Selecting automatic print setting DHA aaRS 8mp o Celsetting 2 za Pee PE 3 a Start Excel and choose MX Sheet Automatic Print Mey fio Ee EB SS S A aoai save setting A v 31 Aut tic Print Setting O 7 F E E u E E PN Re i Setting on the menu bar to display the Automatic Print e A B E ROtomaic COMmmunicaci n stare aSecuIngte H 2004 07 14 Wed 16 31 38 g Start communicaion a dialog box 3 2004 07 14 Wed 16 31 43 12 Ena Communication E 4 2004 07 14 Wed 16 31 48 E 7 Pry l a 2004 07 14 Wed 16 31 53 o AA 6 2004 07 14 Wed 16 31 58 E Cut Cell Area T Tee ed 16 32 E A Ea 2004 07 14 Wed 16 32 13 E AE 40 2004 07 14 Wed 16 32 18 o ee 11 2004 07 14 Wed 16 32 23 Damage Sheet Name N 12 13 Create Button w gt 4 Protect MX Sheet setting R a 6 Options I EA 18 Setting Data Export x 19 Em Version Info Automatic Print List ES 2 Creating new automatic print conditions nable somatic Pri ame na of communication e time evice rigger ear cell area 5 sai Create new automatic print conditions Click Create New Automatic Print 3 Setting the automatic print conditions Automatic Print Name Line1 Daily report T Print atthe end of communication
70. tting Data Sante Version Info thh MX Sheet Communication will commence e Is ik OK To the next page 6 OPERATING MX Sheet MELSOFT From the na page gt 20 Ending communication pa SA EA Choose MX Sheet End Communication from the x menu bar to end logging 26 19 Ar 1 26 22 FE 2627 de 1 26 32 m unicationiB 26 37 E End Cormunication E gt E Sines BAT ala a 26 57 7E Lar D2 az rao Info l Complete The Excel sheet for logging function is now completed 6 10 6 10 6 OPERATING MX Sheet MELSOFT 6 2 Monitor This section provides an example of creating an Excel sheet using the monitor function 1 Creation example Set the following Excel sheet as instructed in 2 EJ Microsoft Excel MX Sheet Ms Sheet ht de LU fe QC A B DOE F G amp G H 1 a 6 CA 0 0 0 h o toos ooh Access data DO to D4 are displayed in order from left to right 6 OPERATING MX Sheet MELSOFT 2 Setting MX Sheet This section explains the procedure of creating an Excel sheet for monitor function 1 Saving the Excel book Save in B My Documen ts y Aa a ar Tools my Music Start Excel and save the Excel book File name mx Sheet xls y E Save as type Imicrosoft Excel Workbook z Cancel J EA Microsoft Excel MX Sheet File Edit View Insert Format Tools Data Window MX Sheet M Help DEMANA EE a gt 214 2 Speci
71. urrency Tools Internet Assistant VBA L si irda aia Automation Analysis ToolPak Provides functions and interfaces for financial and scientific data analysis 4 As the left screen appears enter MXShMenu xla in E Sheet y Q X Ci ES Tools E E Do 0 File name and click OK p MxShMenu MXShMenu xla has been stored into User specified folder Sheet at installation My Documents 1 The installation destination folder will be C Melsec Sheet if it has not been changed at installation Favorites The following screen appears in Microsoft Excel File name G 1 Files of type 4add Ins Bengt 2007 or later Look in O Sheet My Recent Sample Documents E myshMenu xla 4 Desktop RF mxshRibbon xlam File name MxShMenu xla Mi Files of type add ins xlam Fada dl v 5 As the left screen appears make sure that the MX Add Ins available x2 Sheet checkbox is marked and click OK Analysis ToolPak VBA Conditional Sum Wizard Euro Currency Tools fa ee curacy om 2 For Microsoft Excel 2007 or later click gt again and install the add in that hides _ the tabs for Excel by operations 6 and 7 Mx Sheet MELSEC COMMUNICATION ADD IN MACRO To the next page 3 INSTALLATION AND UNINSTALLATION MELSOFT From the previous page j 6 For Microsoft Excel 2007 or later enter MXShRibbon xla
72. us page Communication Setting Wizard Network ES 10 Selecting the communication path lease sele e Network P i OOO EC Make the following settings and click Next gt Station type Host station Multiple CPU Multiple CPU None Cancel lt Back i Communication Setting Wizard Finished Ea 11 Enter any word CPU COM_Q0Z2H in this example and Me dee aa wizard has finished collecting cl ick F n ish M Please Finish to build the logical station number Comment CPU COM_ 02H E Communication Setup Utility 12 Check whether the logical station number settings Menu Help Target setting List view Connectiontest displayed on the lt lt Target setting gt gt tab of the Logical station number 1 cPu com_ao2 tts E __ Delete ije a _ SS Communication Setup Utility are correct or not Serial m iii After checking click the lt lt Connection test gt gt tab COM CPU type Q02 H 10000 ms Transmission speed 19200 bps Control DTR or RTS Multiple CPU None l To the next page 6 OPERATING MX Sheet MELSOFT From the previous page l El Communication Setup Utility A O 1 3 Connection test Menu Help Target seting List view Convection tea Click Test to make sure that the PLC and personal ogica ion number f cPu com eoa i e O Seas computer are normally communicating Communication diagnosis count 5 p 5 5 z 7 A ADA After confirmation click Exit to close the Communication Di
73. wn publisher to make changes to this computer ug Don t run the program unless you know where it s from or you ve used it setup lid before LID File le E Program name SETUP EXE 1 KB La SETUP EXE Publisher Vainos l Unidentified Publisher File origin CD DVD div gt Cancel E 5 oe I don t know where this program is from or what it s for gt Allow I trust this program I know where it s from or I ve used it before User Account Control helps stop unauthorized changes to your computer If the left message appears click OK install MX A Nail nl bei carol reir after installation of this package S h eet an d th en i n sta l M x Co m po ne nt Install If the left message appears click Cancel N This package has already been installed e There is a possibility For improper installation if you execute without uninstalling it u n i n stal l MX S h eet a n d th e n rei n sta l l it El If the left message appears operate as instructed ES Please instal this package after executing Update DCOMSS Exe from CD ROM in a of 2 When message appears at start of installation After the operation is complete restart installation operation Severe Xx This package is not in proper operating environment Please install this package after executing WUpdate4xdist Exe from CD ROM cds If the left screen appears operate as instructed in PO ar eee A x Ple
74. ws 7 and the 64 bit version is designated as 64 bit Windows 7 Generic term of Microsoft Windows Vista Home Basic Operating System Microsoft Windows Vista Home Premium Operating System Windows Vista Microsoft Windows Vista Business Operating System Microsoft Windows Vista Ultimate Operating System and Microsoft Windows Vista Enterprise Operating System Windows XP Generic term of Microsoft Windows XP Professional Operating System and Microsoft Windows XP Home Edition Operating System Definitions of Terms The terms used in this manual have the following meanings and definitions 1 Logical station number A number assigned to the group of data that is integrated from the connection target information required for communication within the Communication Setup Utility Personal computer A a Sp er ce 1 ZIT Yr CLES TBS EP TITAS IL IT ES CLEP FOI LIS Je LOD eee ee e eee ie al Connection target information on up to CPU to communicate with is combined into one data to which logical station number is assigned 2 1 shot communication This function executes the function set to the selected cell area at any timing MEMO A 9 1 OVERVIEW MELSOFT 1 OVERVIEW 1 1 What Is MX Sheet MX Sheet is a communication support software package that enables device data collection by simple program less setting using Excel This manual explains the basi
75. yboard il Mouse Network Windows Update Controllers Options Connections Help and Support f e Ea When any of Windows 98 Windows NT Workstation 4 0 and Windows 2000 Professional is used select a e Add or Remove Programs from Control Panel and double click it To display Control Panel select Start Control Panel Select Uninstall a program on the Control Panel in Windows Vista or Windows 7 d Power Options Printers ani i F B Aad or Remove Programs 2 Select MX Sheet and click Change Remove a gt Poses AR ra The left screen is that of Windows XP Professional MN The displayed screen varies with the OS convent Depending on the used OS perform the following operation lt Windows 98 or Windows NT Workstation 4 0 gt a Click the lt lt Install and Remove gt gt tab b Select MX Sheet c Click Add Remove lt Windows 2000 Professional gt a Click Add or Remove Programs b Select MX Sheet c Click Change Remove lt Windows Vista or Window 7 gt Select MX Component on the Uninstall or change a program screen and click Uninstall Change When user account control is enabled the following screen appears Click or Yes lt Windows Vista gt lt Windows 7 gt User Account Control E User Account Control Wind d he Do you want to allow the following program to make indows needs your permission to continue

Download Pdf Manuals

Related Search

Related Contents

この仕様書は, 福岡市農林水産局中央卸売市場食肉  Signal Generators Programming Guide  CLIENT WEB TOOL USER MANUAL (V 1.0.4538.17859 – 3)  Weed Eater 530087729 Trimmer User Manual  Manifest Schema Documentation - Comptroller of Customs and Excise  LIFESMART Infrared Heater - Northern Tool + Equipment  Fujitsu LIFEBOOK P8010  40901 BISEAL FIBER MF ESP rev1x  ASUS VivoBook F550CC-XX118H  Toshiba Satellite Radius 11 L15W-B1302  

Copyright © All rights reserved. Failed to retrieve file