Home

MX Sheet Version 2 Operating Manual

1. e Change when these notifications appear gt Allow j Itrust this program I know where it s from or I ve used it before v Details User Account Control helps stop unauthorized changes to your computer If the message on the left is displayed click the OK button to install MX Sheet and then install A This package will not run unless MX Component Version 4 or above is installed MX Component When you want to install as it is please install MX Component Version4 or above after installation of this package If the message on the left is displayed click the Cancel button to uninstall MX Sheet then reinstall it This package has already been installed There is a possibility for improper installation if you execute without uninstalling it If the message on the left is displayed install EnvMEL Page 21 2 in this section This package is not in proper operating environment I I I I giri tear uil pear RD After the operation is complete restart installation Macc operation Continued on next page 16 CHAPTER 3 INSTALLATION AND UNINSTALLATION From the previous page 2 Check that all applications is closed and click the pem oe OK button There is a possibility for improper installation if you execute without closing all the running applications Including i a ane If the applications are running close all running applications 3 Starting
2. Mandatory Settings Notset Setalready OK Cancel Apply Optional Settings Notset Setalready Use v Set the Operation Interval Operation Daily C Weekly Sunday C Monthly Day lal day Monday E Tue FL We Lir y Frid Alternate date when a date does not exist F Saturday Last day of the current month z oeren Regular interval Minutely Second 4 C Hourly Minute 4 C Time table HH Mw 4 5 s Cell Area Name Logical Sta Operation Interval Device Trigger Handshake CSV Logging Mandatory Settings Motset Setalready OK Cancel Apply Optional Settings Notset Setalready Use v Set the Operation Interval Operation Daily C Weekly Sunday C Monthly Day a day Monday Tue F We day Thursday Friday Alternate date when a date does not exist Saturday Last day of the current month Operation Regular interval 7 Minutely z a C Hourly 4 C Timetable ove comes mme 5 s Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CSV Logging Monitor function Monitor 1 GOBLIDH Settings No settings No settings No settings Mandatory Settings Notset Setalready OK Cancel Optional Settings Notset Setalready To the next page 5 1 2 ec oe 6 f
3. Line 1 Lot completion Selected e Automatic Save Name e Set the Device trigger Logical Station Number 1 Bit device Selected e Device YO e Condition When ON e Add date and time to File name Selected For the logical station number setting method refer to the following section K gt Page 31 Section 6 1 The labels can be set to Device Set the file name to be saved automatically Clicking the Browse button displays the Save As screen Specify any save place and file name e Filename auto xlsx e Save as type Excel Workbook xlsx After specifying the file name click the button After completing the settings click the OK button CHAPTER 6 OPERATING MX Sheet From the previous page 4 Specifying the automatic save conditions Automatic Save Name End of communication Device Trigger Clear cel ll area ettings Line 1 Lot completion No settings No settings S No settings The automatic save name is added to the list Check that the check box of Enable is selected click the amp es button to close the Automatic Save List screen 5 Starting communication aie Select the lt lt Add Ins gt gt tab gt MX Sheet gt ee Start Communication to start communication Automatic Save Setting K asta Nae PA sena As the message is displayed click the Automatic Communication Startup Setting amp button Communication will commenc
4. 2 1 0 oA o eee Vend Device data are accumulated as history 2012 06 28 Thu 20 41 07 2 1 o of X ol 2012 06 28 Thu 20 53 24 e o of ol o S p p p S po oq oq d 1 E 2 Monitor function Page 39 Section 6 2 This function displays the device data collected from the programmable controller in the cell area selected on an Excel spreadsheet eer controller data are eer on Excel Programmable controller CPU 3 Write function Page 43 Section 6 3 This function writes the values entered on an Excel spreadsheet to programmable controller devices Values entered on Excel are written to programmable controller devices Programmable controller CPU 4 Automatic save function Page 47 Section 6 4 This function saves the Excel book automatically when the specified device is triggered at the specified time 5 Automatic print function Page 51 Section 6 5 This function prints the Excel book or specified Excel spreadsheets automatically when the specified device is triggered at the specified time 6 Create button function Page 53 Section 6 6 This function executes each of the Start Communication End Communication and 1 Shot Communication by clicking the created button 10 CHAPTER 2 OPERATING ENVIRONMENT CHAPTER 2 OPERATING ENVIRONMENT The following table indicates the operating environment of MX Sheet Item Description Pers
5. 9 When the system label is set to Device 1 is displayed to No of cells and cannot be changed 6 Setting the Operation Interval tab Set the monitor operation interval as follows e Set the Operation Interval Selected Operation day Daily Operation time Regular interval 5 seconds ejeg Bunun 9 f Applying the settings Click the Apply button to enable the settings of the Cell Settings screen Check that the cell area is registered as shown on the left screen and click the OK button 45 From the previous page Z MX Sheet Lxlsx Microsoft Exce 8 Starting communication ata Add Ins Ins EBBHZzzgr Select the lt lt Add Ins gt gt tab gt MX Sheet gt sd Start Communication to start monitor Automatic Save Setting K NURSE PIER ace As the message is displayed click the Love l Automatic Communication Startup Setting amp E UON 1 e LLLI UL button Communication will commence Is it OK 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 Check that the data on Excel are written to the programmable controller devices V7 ii 9 e l MX SheetLxlsx Microsoft Exce 10 Ending communication File Add Ins HEBEESREZESIS 5 Select the lt
6. A MX Component Programmable controller CPU System Equipment Description Personal computer that satisfies the operating environment of MX Sheet Personal computer For details refer to the following chapter K Page 11 CHAPTER 2 Operating system Microsoft Windows 7 Professional Operating System English version MX Sheet MX Sheet Version 2 Software MX Component MX Component Version 4 Microsoft Excel 2010 32 bit version English version Programmable controller CPU QO6UDHCPU USB cable MR J3USBCBL3M Printer Printer compliant with the personal computer specifications 29 CHAPTER 5 wx 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 set the 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 Complete 1 Be sure to save the Excel book before performing the MX Sheet settings MX Sheet cannot be set unless the Excel book is saved Refer to the Excel manual for Excel operation e e o E E E O9 O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O O 30 CHAPTER 6 OPERATING MX Sheet
7. CHAPTER 6 OPERATING MX Sheet This chapter explains the following functions with examples Function Reference Section Logging function Page 31 Section 6 1 Monitor function Page 39 Section 6 2 Write function Page 43 Section 6 3 Automatic save function Page 47 Section 6 4 Automatic print function Page 51 Section 6 5 Create button function Page 53 Section 6 6 6 1 Logging This section provides an example of creating an Excel spreadsheet using the logging function 1 Creation example Set the following Excel spreadsheet ac ld Cris Bookl Microsoft Excel x File Home Insert Fage Layout Formulas Data Review View Add Ins Team a E o m ES wxsneet Eg BB EB BB SAGES Sw Menu Commands Custom Toolbars Pe 1st re o 6 Ip o T O e a ae 2012 06 28 Thu 2041 07 af so o Sod por2 o6 2eThu20 aa2 av ss o vo v 2012 06 28 Thu 20 41 17 2 60 of 0 o 2012 06 28 Thu 20 41 22 saf s 0 0 o 2012 06 28 Thu 20 41 27 62 w of of o 2012 06 28 Thu 20 41 32 e 75 2012 06 28 Thu 20 41 37 zaf s80 of 0 o 2012 06 28 Thu 20 41 42 77 s88 0 0 o 2012 06 28 Thu 20 41 47 saf so 0 0 9D T HE 100 Logging times are displayed Content of DO to D4 are displayed in order 10 logging data are displayed from left to right The latest logging data is display
8. CHAPTER 6 OPERATING MX Sheet Setting the Access Data gt gt tab Set the device to be monitored as follows After setting select the Operation Interval tab Logical Station Number 1 e Device DO e Data type 16bit integer e Value DEC Zoom 1 e No of cells D For the logical station number setting method refer to the following section KL Page 31 Section 6 1 The labels can be set to Device When the system label is set to Device 1 is displayed to No of cells and cannot be changed Setting the Operation Interval gt gt tab Set the monitor operation interval as follows e Set the Operation Interval Selected Operation day Daily Operation time Regular interval 5 seconds BULOJN z 9 Applying the settings Click the Apply button to enable the settings of the Cell Settings screen Check that the cell area is registered as shown on the left screen and click the OK button 41 42 From the previous page File Add Ins Ei ES EL GE GE RE CZ GE ELL Cell Setting L Automatic Save Setting K Automatic Print Setting O Automatic Communication Startup Setting amp Start Communication B Bee ESTE Complete 8 Checking the settings REBEHZZSE Check if the settings in steps 1 to 7 are correct by using Cell Setting the 1 shot communication function of MX Sheet MNA Perform 1 shot communication in the fo
9. Mm MELSOFT WW MITSUBISHI ELECTRIC MX Sh eet Version 2 Operating Manual Introduction O eration Mb intenance MELSOFT Integrated FA Software SW2DNC SHEET E SAFETY PRECAUTIONSG Read these precautions before using this product Before using this product please read this manual and the relevant manuals carefully and pay full attention to safety to handle the product correctly The precautions given in this manual are concerned with this product For the safety precautions of the programmable controller system refer to the User s Manual for the CPU module In this manual the safety precautions are classified into two levels N WARNING and N CAUTION NWARNING Indicates that incorrect handling may cause hazardous conditions resulting in death or severe injury Indicates that incorrect handling may cause hazardous conditions NCAUTION resulting in minor or moderate injury or property damage Under some circumstances failure to observe the precautions given under A CAUTION may lead to serious Consequences Make sure that the end users read this manual and then keep the manual in a safe place for future reference Design Instructions NWARNING When data change program change or status control is performed from a personal computer to a running programmable controller create an interlock circuit outside the programmable controller to ensure that the whole system always operate
10. 000 Automatic Print List screen Auitoamatic Coarmminication Ctarbkiin Catina Add Ins eal ome Insel Page Layout Fo wxsneet E EB EJ HE GE RE CD G8 E D B 2 Creating new automatic print conditions Click the button to create new automatic print conditions Automatic Print Name End of communication Device Trigger Clear cell area Thurs Alternate date when a date does not exist o C1 gt A TT Oo 3 Setting the automatic print conditions 3 Automatic Print Name Line 1 Dairy report Q EIU ED ET Set the automatic print conditions as follows o creton Daily C Weekly E did Monthly E Ej Wednesd ay EL gt Een b queas orent Automatic Print Name Line 1 Daily report Sono C Regular interval C Hourly e Set the date and time Selected m Operation day Daily i05 Operation time Time table 17 00 Print Area Specify the sheet BitDevice Device Condition wen ON C Word Ee bit 0 15 Sheet 1 and Sheet 3 Clear cell area after automatic print iii f After the settings click the button aiia 1 Multiple spreadsheets can be selected Print Area Entire workbook Specify the sheet ra Sheet2 ErrorLog lt r To the next page 91 52 From the previous page Automatic Print Name End of communication Device Trigger Clear cell are
11. 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 Specify the installation destination folder If do not change the destination folder click the Next button In order to change the destination folder click the Browse button and specify a new drive and folder Register the MX Sheet to Excel as an add in software Select the check box when registering an add in The check box is selected by default Click the Next gt button For confirmation the message on the left is displayed Click the i button CHAPTER 3 INSTALLATION AND UNINSTALLATION Point In order to allow MX Sheet available register MX Sheet menu to Excel as an add in software Normally register an add in software as instructed in step 7 If the Register add in check box is cleared in step 7 the following message is displayed after the installation i Add in registration of the MX Sheet menu was not performed Please carry out add in registration manually from Excel For the manual MX Sheet add in registration method refer to the following section KL Page 24 Section 3 1 4 When installing an add in for Excel the add in that hides the tabs is automatically installed for the Excel amp zi P m gj Format as Table v w av d Tab Paste AMT EN 30 50 E cell Styles lt 2 Filter Select Clipboa
12. ss C Fix the File name Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CS Logging Mandatory Settings Motset Setalready OK Cancel Apply Optional Settings Notset Setalready To the next page Saving the Excel book Start Excel and save the Excel book 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 is displayed Displaying the Cell Settings screen Select the lt lt Add Ins gt gt tab gt MX Sheet gt Cell Setting to display the Cell Settings screen Setting the lt lt Use gt gt tab Set the following items of the lt lt Use gt gt tab After setting select the lt lt Access Data gt gt tab Use Logging Cell Area Name Logging function Cell Area B2 G11 New data location Last Line Display Contents Add date and time details Operation when cell is full To scroll From the previous page ata Operation Interval Device Trigger Handshake CSV Logging Logical Station Number m Communication Settings ign ic No of T E 2 ry g T S a Value Cell Area Name amp Mandatory Settings Notset Setalready OK Cancel Apply Optional Settings Notset Setalready S To the next page Logical Sta Operation Interval Device Trigge
13. Access e Let Windows suggest settings Optimize visual display gms QO a gt Control Panel Programs Programs and Features v 4 Search Progra P Control Panel Home Uninstall or change a program View installed updates To uninstall a program select it from the list and then click Uninstall Turn Windows features on or Change or Repair off Install a program from the Organize v Uninstall Change v network Name Publisher 8 MSXML 4 0 SP2 KB954430 MSXML 4 0 SP2 KB973688 Microsoft Corporation Microsoft Corporation Em Developer2 MITSUBISHI ELECTRIC MX Component tr MX Sheet QS Trend Micro OfficeScan Client Trend Micro EE Visual Studio 2010 Tools for SQL Server Compact 3 5 Microsoft Corporation Q web Deployment Tool Microsoft Corporation E m gt n Are you sure you want to completely remove MX Sheet and all of its components To the next page 1 Select Start gt Control Panel gt Uninstall a program Windows XP gt Start gt Control Panel gt Add Remove Programs 2 Select MX Sheet from the list of programs and select Uninstall Change Windows XP gt Select MX Sheet from the list of programs and click the Change Remove When user account control is enabled the following screen is displayed Click the button or the
14. Application Add ins may impair functionality Non Trusted Publishers Trusted Locations Trusted Documents Arr inc miaeuu actum 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 V Safe mode helps limit the control s access to your computer X Trusted Publishers Trusted Locations Trusted Documents Add ins ArtivaY Cattinac riUutccicu VIC 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 Nun Complete CHAPTER 3 INSTALLATION AND UNINSTALLATION Select Trust Center from the list on the left and click the button Select Add ins from the list on the left and clear the items when they have the check marks Select ActiveX Settings from the list on
15. CLAN EGENTES Create Button gt Start Communication Button Start Communication B 1Shot Communication S Cut Cell Areal Copy Cell Area C Delete Cell Area D Change Sheet Name N Protect MX Sheet settina R End Communication Button E Options 1Shot Communication Button S The start communication button is placed in the specified cell position 1 The display characters and character font of the created button can be changed For details refer to the following manual JA MX Sheet Version 2 Operating Manual uoyng Burspy DuneeJ 9 9 2 Starting communication Click the start communication button created in step 1 As the message is displayed click the Love button Communication will commence Is it OR Dee i Complete 53 APPENDIX Appendix 1 Useful Functions of MX Sheet In addition to the functions explained in this manual Page 31 CHAPTER 6 MX Sheet has useful functions This section provides the outlines and brief explanations of the functions For more details refer to the following manual MX Sheet Version 2 Operating Manual Appendix 1 1 Alarm summary 04 The alarm summary function converts the ON OFF information into the corresponding alarm comment character strings and accumulates them on an Excel spreadsheet as an alarm history The following are available by specifying in advance when the alarm history reaches the last line e S
16. Start Excel and save the Excel book Specifying the cell area Drag the cell B2 to D2 in this example on the left screen to specify the cell area in which monitor data is displayed Displaying the Cell Settings screen Select the lt lt Add Ins gt gt tab gt MX Sheet gt Cell Setting to display the Cell Settings screen Setting the lt lt Use gt gt tab Set the following items on the lt lt Use gt gt tab After setting select the Access Data tab Use Write Cell Area Name Write function Cell Area B2 D2 Cell Display Direction Left to Right From the previous page Use Access Data Operation Interval Device Trigger Handshake Logical Station Number 1 OBUDHCPU_USB Data Type IEEE ue SS ee se Fee BEEN EN EE M BEEN BEEN EE e BEEN EE EE 8 BEEN Cell Area Name Logical Sta Operation Interval Device Trigger Handshake CSV Logging Mandatory Settings Notset Setalready OK Cancel Apply Optional Settings Notset Setalready ell Settings Write function Use Access Data Operation Interval Device Trigger Handshake JV Set the Operation Interval Operation Daily C Weekly Sunday C Monthly Day a day Monday Tuesday M Wednesday M Thu y Friday Alternate date when a date does not exist Saturday Last day of the current month Ope
17. current month Operation Regular interval Minutely C Hourly C Time table k BE Logging Time zone Log Always C Log only during the specified time zone Cell Area Name Use Logging function Logging Logical Sta Operation Interval Device Trigger Handshake CSV Logging 1 Q06UDH Settings No settings No settings No settings Mandatory Settings Notset Setalready Optional Settings Notset Setalready Booklxlsx X id I e 1 Home Insert Pagelayout Formulas Di wxsnet Ed GB Ed Gd SESS Cell Setting L Automatic Save Setting K Automatic Print Setting O _ Automatic Communication Startup Setting amp Start Communication B End Communication E Cell Area Name Eeee kO cen S To the next page CHAPTER 6 OPERATING MX Sheet 15 Setting the Operation Interval gt gt tab Set the logging operation interval as follows 16 Applying the settings Set the Operation Interval Operation day Operation time Logging Time Zone Selected Daily Regular interval 5 seconds Log Always Click the Apply button to enable the settings of the Cell Settings screen Check that the cell area is registered as shown on the left screen and click the OK button 17 Checking the settings o T O e a 5 ae Check if the settings from step 1 to 16 are correct by using the
18. de ac Gi Jo o deo doce dit of Appendix 1 6 Automatic Communication Startup Setting ee eee 57 Appendix 1 7 Protect the MX Sheet Setting oaoa a 58 Appendix 1 8 Eror log SeN MD A ee eee 59 REVISIONS cae bo ead oboe a ee ae ee eee ee eae ae eee bee ee 60 HOW TO READ THIS MANUAL The following explains the page composition and symbols in this manual The contents of the example page used here are different from the actual contents for the intention of explaining how to read this manual Indicates the chapter of currently open page 6 5 Automatic Printing This section explains a setting procedure for automatically saving the Excel book during MX Sheet operation Operating procedure 1 Setting example Automatic print condition Printed at 17 00 every day describes the operating Print area Sheet 1 and Sheet 3 are printed procedure of the function 2 Setting automatic print This section explains an Excel spreadsheet automatic print setting procedure Operating procedure Eid js MX SheetLodsx Microsoft Excel Selecting automatic save setting Ss Oo r Start Excel and select the lt lt Add Ins gt gt tab gt Cell Setting MX Sheet gt Automatic Print Setting to display the p omenaa Automatic Save screen Creating new automatic print conditions Indicates the section Click the button to create new automatic print of curre ntly open page E Point indicates
19. message is displayed Compile error in hidden module MXShExtern 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 CHAPTER 3 INSTALLATION AND UNINSTALLATION CHAPTER 3 INSTALLATION AND UNINSTALLATION This chapter explains the installation and uninstallation procedures of MX Sheet 3 1 installation This section explains MX Sheet installation Screens from Windows 7 are used except for different operations required in other operating systems 3 1 1 Before installing MX Sheet 1 Considerations when installing MX Sheet Before installing MX Sheet close any other applications running on Windows The installer may not work normally because of the operating system s or other companies update programs such as Windows Update or the Java update program start automatically Install MX Sheet after configuring those update programs not to start automatically When installing MX Sheet log on as a user with the Administrator authority For the required personal computer operating environment to install MX Sheet refer to the following chapter k Page 11 CHAPTER 2 uone Ejsu pE jeeus XW Buijejsur euojeg L L 13 14 2 Security Setting of Excel The following explains the setting procedure of required Trust Center when using MX Sheet Operating procedure Paste C
20. screen is displayed select Yes want to restart my computer now 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 OK to finish setup Neccccsevceeeceeeeecenesececscecesessescscccoscsecenessseceeeeeeseseresssscscssoosenenecesenes CHAPTER 3 INSTALLATION AND UNINSTALLATION 2 When message is displayed at start of installation The following explains the countermeasures when the message is displayed at start of installation a When starting the installation of this product the This package is not in proper operating environment message is displayed disabling normal completion of installation In such a case close all applications and perform the following operation Operating procedure 1 Execute SETUP EXE in the EnvMEL folder on the CD ROM of this product After executing SETUP EXE install the product When user account control is enabled the following screen is displayed Click the button or Allow Windows 7 or later Windows Vista gt P A Don t run the program unless you know where it s from or you ve used it before Program name SETUP EXE Publisher Unknown B SETUP EXE File origin CD DVD drive Unidentified Publisher gt Cancel MM Sm quss I don t know where this program is from or what it s for gt Allow I trust this program I know where i
21. 1 shot communication function of MX Sheet Perform 1 shot communication in the following procedure 1 Select the lt lt Add Ins gt gt tab gt MX Sheet gt 1Shot Communication 2 As the 1Shot Communication screen is displayed select the cell area name set in step 4 Logging function in this example as the Cell Area Name 3 Click the OK button to start 1 shot communication 3 38 From the previous page S7 lt Before adjustment gt 18 Adjusting the display After 1 shot communication HHHHHH is displayed in the date time cell as shown on the left screen Adjust the cell width of Column B so that the date and time can be displayed After adjustment b n Oo E E E E els Il I B 19 Starting communication Select the lt lt Add Ins gt gt tab gt MX Sheet gt Start Communication to start logging As the message is displayed click the button Add Ins Cell Setting L Automatic Save Settina K Automatic Print Setting O Automatic Communication Startup Setting amp End Communication E Communication will commence Is it OK 9 9 20 Ending communication Select the lt lt Add Ins gt gt tab gt MX Sheet gt Ed i8 B x E s Cell Setting D End Communication to end logging Automatic Save Setting K Add Ins Automatic Print Setting O Automatic Communication Startup Setting A 5 28
22. OPERATING ENVIRONMENT 11 CHAPTER 3 INSTALLATION AND UNINSTALLATION 13 3 1 Installation llis RR RR eee eens 13 3 1 1 Before installing MX Sheet 0 0 0 0 0 0 c ccc RIRs 13 3 1 2 Installation liiieeeee eee RR RR rre 16 SES WEE eite c CRREEEUTEITSO DET T ETE QUU DOTT 23 3 1 4 Manual add in registration e ice so wee We kee CROCO CER RO ewe ne bo OR cs 24 2 2 HEnDnsiallauOl coeno sz eersSeItLend EPUM CURISESRPUEEEEU E RET REETEES EAS PE MEE E 2 CHAPTER 4 SYSTEM CONFIGURATION USED IN THIS MANUAL 29 CHAPTER 5 MX Sheet OPERATION PROCEDURE 30 CHAPTER 6 OPERATING MX Sheet 31 D EOIN 0359522939 2 145229 eae ou neeu ls sedesque es id Rie ut eeu be dcs a RN vas 31 D IMoOnNOnnGs 2s ose hee TREE OS RR eSI REPRE MEI HE Sa ES qn 39 Cr ee ce ee OTT 43 64 Atitomatic Saving 42 lt lt choinde oni ceastdunctevlawedddieecse be db ka ea aa 47 605 Automatic Pinin p54 nese cose aneteeuce QUU LITT LITTERE 51 Bo Creating Using DEOR 3 4 46 Rd nm tei Doleo aod Babee ween Eb 3 os 53 APPENDIX 54 Appendix 1 Useful Functions of MX Sheet 0 0 0 cece eens 54 Appendix 1 1 Alam SUMMARY i ss ores Poe ACE Se ee ee FORE CUR Ios 54 Appendix 1 2 Comment display s Ge ee 3x aae Oe ee 3X ee ew ae ew ede das 95 Appendix 1 3 Device MOJE EET ETE EET CICE EC TIL t C EIL TU EIL 9D Appendix 1 4 Handshakes 1 owes D cee Doe ie dab ee be oe Sois Scam Itb de DUREE dh ee ee 56 Appendix 1 5 CSV logge s sonde sane dox v ordo Lo
23. 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 is 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 cont
24. Thu 20 41 07 l Start Communication B j D Jj z Complete The Excel spreadsheet for logging function is now completed CHAPTER 6 OPERATING MX Sheet 6 2 Monitoring This section provides an example of creating an Excel spreadsheet using the monitor function 1 Creation example Set the following Excel spreadsheet Fal ld A jF MX Sheetlxlsx Microsoft Excel File Home Insert Page layout Formulas Data Review Wiews Add Ins Team wxsheet PROGRESS ee Menu Commands Custom Toolbars B2 E fe 1 ae UN Se ee Sa CN aes 1 3p o s o a Access data DO to D4 are displayed in order from left to right BuHOJUON Z 9 39 2 Setting MX Sheet This section explains the procedure of creating an Excel spreadsheet for monitor function Operating procedure 1 Saving the Excel book ES Libraries Documents gt v Search Documents 2 Organize New folder i Start Excel and save the Excel book Documents library i Al by Folder v Xr Favorites Includes 2 locations ange y E RE Desktop B Downloads g Name Date modified Type Size SB Recent Places No items match your search Libraries B Documents 2 Music m omo hd File name MX Sheet xls Save as type Excel Workbook xlsx Authors Add an author Tags Add a tag Save Thumbnail Hide Folders Tools iG I MX SheetLxlsx Microsoft Exce z Specifying the cell area Add In
25. a Line 1 Dairy report No settings Settings No settings No settings Edit Complete Point Specifying the automatic print conditions The automatic print name is added to the list Check that the check box of Enable is selected click the close button to close the Automatic Print List screen The automatic print setting is now completed If multiple printers are set within the personal computer the default printer set within Start gt Control Panel gt Hardware and Sound gt Devices and Printers is used to print the Excel spreadsheet when Automatic Print setting is selected CHAPTER 6 OPERATING MX Sheet 6 6 Creating Using 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 Page 31 Section 6 1 2 Creating the button and starting communication The following describes a procedure from button creation to a communication start using the button X id 9 amp 1 MX SheetLxlsx Microsoft Excel 1 Selecting C reate Button Home Insert Page Layout Formulas Data Review View Add Ins T i H Start Excel and specify the cell where the button is west Eg B Ed HD S GE GE EZ GB SS D peetty Cell Setting L placed Im Select the lt lt Add Ins gt gt tab gt MX Sheet gt Automatic Print Setting O aiccosdceeed ens
26. act the Mitsubishi representative in your region INTRODUCTION Thank you for your patronage We appreciate your purchase of the Mitsubishi integrated FA software MELSOFT series This manual is designed for users to understand operations of MX Component Before using the product thoroughly read this manual and related manuals to develop full familiarity with the functions and performance of MX Component and supported modules to ensure correct use RELATED MANUALS The manuals related to this product are shown below Refer to the following tables when ordering required manuals Manual name mE Description lt Manual number model code gt MX Sheet Version 2 Operating Manual Explains the operation procedures setting and operation methods of SH 081080ENG 13JU73 MX Sheet Sold separately MX Component Version 4 Operating Manual Explains the setting and operation methods of each utility on MX SH 081084ENG 13JU75 Component Sold separately MX Component Version 4 Programming Manual Explains the programming procedures details and error codes for lt SH 081085ENG 13JW12 gt ACT control Sold separately Note MX Sheet Version 2 Operating Manual is included on the CD ROM of the software package in a PDF file format Manuals in printed form are sold separately for single purchase Order a manual by quoting the manual number model code listed in the table above Mitsubishi Electric Corporation does not g
27. age Visual Studio Tools for Office Design Time Adaptor for Excel C x86 WSTOExcelAdaptor dll COM Add in General fz g gt E View and manage Microsoft Office Add ins Formulas Proofing Add ins Save Name Location Type c Language Active Application Add ins Acrobat PDFMaker Office COM Addin Ci ffice PDFM OfficeAddin dll COM Add in Advanced Team Foundation Add in CX mbliesXTFSOfficeAdd in dll COM Add in Customize Ribbon Inactive Application Add ins Analysis ToolPak Analysis ToolPak VBA Custom XML Data Date XML Euro Currency Tools Financial Symbol XML Quick Access Toolbar Trust Center CA raryAnalysisVANALYS32 XLL Excel Add in CA nAAnalysisy amp TPVBAEN XLAM Excel Add in CA ffice Officel4 OFFRHD DLL Document Inspector C hared Smart Tag MOFL DLL Action gl CA A ALibranAEUROTOOL XLAM Excel Add in CA hared Smart Tag MOFL DLL Action Headers and Footers CA ffice OfficelL4 OFFRHD DLL Document Inspector Hidden Rows and Columns C ffice Officel4 OFFRHD DLL DocumentInspector Hidden Worksheets Ci ffice Officel4 OFFRHD DLL Document Inspector Invisible Content CA fficeXOffice44OFFRHD DLL Document Inspector Microsoft Actions Pane 3 XML Expansion Pack Solver Add in CA ranASOLVERASOLVER XLAM Excel Add in Document Related Add ins No Document Related Add ins Add in Acrobat PDFMaker Office COM Addin Publisher Adobe Systems Incorporated Compatibility No compatibility infor
28. and the menu of MX Sheet are added When using Microsoft Excel 2003 MX Sheet is added to the menu bar j HI S fle Bookl Microsoft Excel o o sx Home Inset Pagelayout Formulas Data Review View Add Ins Team 9 c3 pH ES Automatic Save Setting K Automatic Print Setting O MX Sheet icons and menu are displayed uone Ejsu pE Point If the Register add in is not selected on the Select add in register screen in step 7 Page 16 Section 3 1 2 the icons and the menu of MX Sheet are not registered Register MX Sheet as an add in software manually after installation For the manual add in registration method refer to the following section Page 24 Section 3 1 4 YOIOYD uonejejsu ELS 23 3 1 4 Manual add in registration MX Sheet menu is not registered to the lt lt Add Ins gt gt tab if Register add in is not selected on the Select add in register screen in step 7 1 gt Page 16 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 Operating procedure 1 Start Excel and click the lt lt File gt gt tab Kil c I Calibri X ici 2 Select Option lp Save EL Save As EF Open Cd Close Recent New Print Save amp Send Help Ej Exit V7 To the next page 24 From the previous p
29. atic save function Temperature within the normal range Temperature over the upper limit Excel book file 2012 06 28 Thu 20 41 17 Material storange 2012 06 28 Thu 20 43 53 Material storange a HTML file CSV file m Error log setting function Protect MX Sheet Create button function F m z 5 setting function Kind iDate Cell Area Name ErrorNo Contents o 2 Information 2012 06 29 Fri 15 21 47 o0000000 Communication was started Protect Sheet setting Warning 2012 06 29 Fri 15 21 49 est 21000021 Communication error has occurred in the open close of MXxShBtnStart communication lt 00010003 Hex 01808502 Hex gt v Enable check setting data x USB driver connect error h 02 Connection of the USB driver failed Pess Word Contona 2 The corrective action is as follows sees D Exit the program and restart the IBM PC AT compatible D Reinstall MX Component Check USB driver installation Cancel 3 lt ErrorCode 1808502 Hex gt 4 Information 2012 06 29 Fri 15 21 57 00000002 Communication was completed Programmable controller CPU 1 2 Functions Explained in This Manual This manual explains the following MX Sheet functions 1 Logging function Page 31 Section 6 1 This function accumulates the device data collected from the programmable controller as a history in the cell area selected on an Excel spreadsheet 2012 06 28 Thu 20 41 07
30. button Windows 7 or later i Do you want to allow the following program to make amp changes to this computer ia Program name Uninstall or change an application K Verified publisher Microsoft Windows v Show details Change when these notifications appear 1 3 Click the button When not uninstalling MX Sheet click the Na button to return to the preceding screen Components indicate the installed icons and files Windows Vista gt r User Account Control uonejejsuluf Z y Windows needs your permission to continue J If you started this action continue ia Uninstall or change an application K Microsoft Windows Details User Account Control helps stop unauthorized changes to your computer 2 28 From the previous page unlnstallShield will remove the software M x Sheet from your computer Please wait while each of the following components is removed Shared program files 4 Standard program files Folder items 5 s Program folders Program directories Program registry entries Complete When the screen on the left is displayed uninstall is complete Click the button to close the screen Restart the personal computer CHAPTER 4 SYSTEM CONFIGURATION USED IN THIS MANUAL CHAPTER 4 svsTEM CONFIGURATION USED IN THIS MANUAL This manual explains system configuration as follows
31. conditions the particular o attention o Point 3 If multiple printers are set within the personal computer the default printer set within My Computer gt Printers is used to amp print the Excel spreadsheet when Automatic Print setting is selected indicates a the useful tip G BD eem IMMMMIIIIIeHIeIHeHeHeHHeHy The descriptions in this manual may be subject to change without prior notice v9090900900090000900000089000000000000000000090009000000000005250000900009000000000 e Symbols used in this manual The following shows the symbols used in this manual with descriptions and examples hx Sheetlxlsx Microsoft Excel Hame Insert Page Layout Formulas Data Review view Access Data Operation Interval Device Trigger Handshake CSV Logging Use Logging e Cell Area Name CO9gIng function Cell Area D1 al Set the Color of Grid line Set the Color for Filling jf Clear cell area at the start of communication 2 4 Mewe data location Last Line T 5 Display Contents Add title jf Add date and time details EM Operation when cell is full To scroll j Display fram the beginning without clearing the cell area 8 Display from the beginning after clearing the cell area E E 10 Eire a A non E Menunameonamenubar MXSheetj Cel Setting Underline Underline Screenname Cell Settings screen _ I Operation when cell is fu
32. creen is displayed as follows lt Windows 7 or later gt lt Windows Vista gt User Account Controle a m it Cc Don t run the program unless you know where it s from or you ve used it before Program name ActC Publisher Unknown E 1 ActComm exe Unidentified Publisher File origin Hard drive on this computer S show detaits Change when these notifications appear gt Allow I trust this program I know where it s from or I ve used it before v Details User Account Control helps stop unauthorized changes to your computer ___ LL o LIGDAGR 1 In order to disable the appearance of the message above refer to the following manual LL MX Sheet Version 2 Operating Manual 33 34 From the previous page Son i List view Connection test Logical station number Delete f This Communication Setting Wizard will set the communication information for amp CT 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 v To the next page Clicking the button or Allow executes the communication setup utility with administrator authority When executing without administrator authority the communication setup data can be checked however when clicking the button on the Communication Setting Wizard
33. crolling Printing Excel spreadsheet e Saving Excel book The line operation ratio and other conditions can be checked easily by accumulating the alarm data history Alarm data are accumulated as bit devices turn on off 2012 06 28 Thu 20 41 07 A A ot 2012 06 28 Thu 20 53 24 f e of of o o p S p P S EE NENNEN ENS CENE NE APPENDIX 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 spreadsheet 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 is displayed when the device value falls outside the range Temperature within the normal range Temperature within the normal range Temperature Temperature c rise fall Temperature overthe upper limit Temperature below the lower limit Appendix 1 3 Device trigger 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 Collecting Writing Collecting Writing device data device data 4 4 d1 Ll L OFF Target functions Logging Monitor Write A
34. dy OK Cancel Apply Optional Settings Notset lt Setalready 1 The password can be set or canceled by selecting the lt lt Add Ins gt gt tab gt MX Sheet gt Protect MX Sheet setting Unprotect MX Sheet setting 08 APPENDIX Appendix 1 8 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 set 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 C UBL E Kind Date Cell Area Name ErrorNo Contents 2 Information 2012 06 29 Fri 15 21 47 00000000 Communication was started Warning 2012 06 29 Fri 15 21 49 est el000021 Communication error has occurred in the open cl ose of communication lt 00010003 Hex 01808502 Hex USB driver connect error Connection of the USB driver failed The corrective action is as follows Exit the program and restart the IBM PC AT compatible Reinstall MX Component Check USB driver installation 3 lt ErrorCode 1808502 Hex gt 4 Information 2012 06 29 Fri 15 21 57 00000002 Communication was completed 2 Automatic Error Log sheet display change setting At error occurrence the Error Log
35. e Is it OK 6 Starting the programmable monitor utility From the Start menu select All Programs gt MELSOFT Application gt MX Component gt PLC Monitor Utility to start the PLC controller monitor utility As the Transfer setting screen is displayed set the Program setting type following items Utility setting type Selected Logical station number 1 Bulaes onewojiny p 9 After completing the above settings click the o button Connect Retry Times n f Specifying the monitor device Select the Device Batch tab of the PLC Monitor Utility screen and set the following items Menu Online Help Device Batch Buffer Memory Entry Device e Device YO After completing the settings click the button To the next page 49 From the previous page Menu Online Help Device Batch Buffer Memory Entry Device Yeo 0000000000 70 0000000000 Y80 000000000 00000000 00 YBO 0000000000 Yco 0000000000 YDO 0000000000 YEO 00000000 00 tart monitor M ortor torrat wa Dispey wwe gt Data format DEC zl z Bit order F 0 4 4 Q06UDH uss 1 Bit device _ s Device YO Force OFF Toggle force M Word device Buffer memory Device C Buffer memory Module start VO Address e Setting val
36. ect the Office button and click the button The Add Ins screen is displayed Click the button The Browse screen is displayed Select MXShMenu xla in File name and click the button MXShMenu xla is stored into User specified folder c Sheet at installation The installation destination folder is C Melsec Sheet if it is not changed at installation The Add Ins screen is displayed Check that the MX Sheet check box is selected and click the button again Install the add in that hides the tabs to Excel as instructed in step 6 and step 7 25 uoneJisiDaiJ ul ppe jenueyy ri e Le uore eisu From the previous page F3 OW i MELSOFT Sheet mes Organize v New folder RE Desktop Name v 4 Search Sheet p Date modified Type n Downloads SS Recent Places Libraries a Documents a Music E Pictures z Videos jM Computer Ge Network File name MXShRibbon xlam 10 12 2011 11 13 AM 2 9 2011 7 38 PM 10 9 2009 6 31 PM d Sample E MXShMenu xla WF MXShRibbon xlam w 54 File folder Microsoft Excel Add In Microsoft Excel Add In Tools v OK Add Ins available Cancel Browse Automation Solver Add in MX Sheet MELSEC COMMUNICATION ADD IN MACRO Insert Pane avoit v Add Ins xlam xla xll z v Cancel Booki Microsoft Excel Formulas Data Complete Point In case VBA i
37. ed on the last line Scrolled up in order 31 2 Setting MX Sheet This section explains the procedure of creating an Excel spreadsheet for logging function Operating procedure 32 x Organize New folder lt e E Microsoft Excel Documents library cuc Includes 2 locations F Favorites Name i Date modified Type Size RE Desktop n Downloads No items match your search SS Recent Places Libraries Documents vn Filename Bookl xlsx Save as type Excel Workbook xIsx Authors Add an author Tags Add atag Save Thumbnail Add Ins ES B3 EA Ed ES B3 D S MERE E Automatic Save Setting K Automatic Print Setting O Automatic Communication Startup Setting amp Start Communication B F Ra Use Access Data Operation Interval Device Trigger Handshake CSV Lagging Use Logging Cell Area Name Logging function Cell Area B2 611 Set the Color of Grid line Set the Color for Filling V Clear cell area at the start of communication New data location Last Line x Display Contents Addtitle v Add date and time details Operation when cellis full To scroll Display from the beginning without clearing the cell area Display from the beginning after clearing the cell area Print the Excel sheet Save to file File name to save Browse Add date and time to File name Add sequential number to File name ooo gt
38. er from left to right ejeg Bunun 9 43 2 Setting MX Sheet This section explains the procedure of creating an Excel spreadsheet for monitor function Operating procedure ES Libraries Documents gt v Search Documents 2 Organize v New folder Documents library z Arrange by Folder v Includes 2 locations Favorites RE Desktop B Downloads g Name Date modified Type Size Recent Places E No items match your search Libraries B Documents 2 Music v ES File name MX Sheet xls Save as type Excel Workbook xlsx Authors Add an author Tags Add a tag Save Thumbnail Hide Folders Tools File Mxsheet Bi BB E m S E REGE Add Ins ES B3 ER Menu Commands Custom Toolbars H4 5 EE S 1 Add Ins Automatic Save Setting K Automatic Print Settina Q 7 Use Access Data Operation Interval Device Trigger Handshake Use Write Cell Area Name rte tuno 0000000000 colaen Bene Set the Color of Grid line Set the Color for Filing Clear cell area at the start of communication Cell Display Direction Let to Right Cell amp rea Name Use Logical Sta Operation Interval Device Trigger Handshake CSV Logging Mandatory Settings Motset Setalready OK Cancel Apply Optional Settings Notset Setalready To the next page 44 Saving the Excel book
39. ibility mode F Run this program in compatibility mode for Windows XP Service Pack 3 Settings F Run in 256 colors F Run in 640 x 480 screen resolution F Disable visual themes emma e eee eee eee nee eee eee eee correctly on ity mode that is program and it worked correctly off indows select the compatibility mode Windows XP Service Pack 3 Settings F Run in 256 colors F Run in 640 x 480 screen resolution Disable visual themes Disable display scaling on high DPI settings Privilege Level Run this program as an administrator Right click on the setup exe icon of the installation target in the Windows explorer and open the SETUP EXE Properties screen Select the lt lt Compatibility gt gt tab and click the button Clear 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 the button Click the button on the SETUP EXE Properties screen Install the product again gt Page 16 1 in this section CHAPTER 3 INSTALLATION AND UNINSTALLATION 3 1 3 Installation Check Check whether MX Sheet is installed normally or not as follows Operating procedure 1 Start Excel 2 Confirm if the lt lt Add Ins gt gt tab is added and the icons
40. ication Setthe date and time 7 Sunday Day l Operation Daily C Weekly Monday C Monthly o day Tuesday Wednesday Thursday Alternate date when a date does not exist Friday Saturday last day of the current month Operation Regular interval C Hourly Minute a C Timetable HH mm 4 time Imi Min B E v Set the Device trigger r Communication Logical Station Number f4 GOBUDHCPU_USB hdi Settings BitDevice Device YO Condition wen ON C Word Device the bit 0 15 Clear cell area after automatic save Specify the cell area name FS vr atthe r File name to save C WserstAdminDocumentstauto xisx Browse Specify the sheet name Sheet1 1 Add date and time to File name C Add sequential number to File name 000 gt 999 C Fix the File name OK Cancel 2 x Save in E My Documents amp ex Fev Name 7 Date modified EP MX Sheetlxlsx 6 28 2012 6 47 PM autos Save as type Rr Ren Ed File name To the next page 48 Selecting automatic save setting Start Excel and select the lt lt Add Ins gt gt tab gt MX Sheet gt Automatic Save Setting to display the Automatic Save List screen Creating new automatic save conditions Click the button to create new automatic save conditions Setting the automatic save conditions Set the automatic save conditions as follows
41. ing automatically starts communication with the programmable controller when the Excel book where MX Sheet settings have been set is started This setting eliminates the need of selecting Start Communication from the MX Sheet menu ButB60 ASO G xipueddy J898US XN Jo suonounJ jnjes xipueddy Of Appendix 1 7 Protect the MX Sheet Setting The MX Sheet setting can be protected by a password The user settings can be set to unchangeable v Enable check setting data Password optional MX Sheet setting becomes unchangeable Set the password Cell Settings Logging function Read only C28 Use Access Data Operation Interval Device Trigger Handshake CSV Logging Use Logging Y Cell amp rea Name Logging function E12 H13 Set the Color of Grid line Setthe Color for Filling v Clear cell area at the start of communication Last Line Add title JV Add date and time details Cell Area New data location Display Contents Operation when cell is full UN AX Sheet Because the MX Sheet setting is protected The contents of settings cannot be saved Add sequential number to File name 000 1999 C Fix the File name Cell amp rea Name Use Logical Sta Operation Interval Device Trigger Handshake CSV Logging Logging function Logging 1 Q06UDH Settings No settings No settings No settings Mandatory Settings Notset Setalrea
42. larm summary Comment display Automatic save Automatic print e dsip juswwoy Z xipueddy J89US XN Jo suonounJ jnjes xipueddy OD Appendix 1 4 Handshake Setting a handshake between the programmable 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 programmable controller before data updating When handshake begins with programmable controller side request Responding device on the PC side Requesting device on the programmable controller side Requesting device on the PC side Responding device on the programmable controller side 06 APPENDIX Appendix 1 5 csv logging The CSV logging function simultaneously displays device data on an Excel spreadsheet 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 spreadsheet 40 5o eol Simultaneous execution CSV file 2012 5 4 08 00 00 0 0 0 0 0 0 save into Ce ale 2012 5 4 08 00 10 10 20 30 40 50 60 Appendix 1 6 Automatic Communication Startup Setting Automatic Communication Startup Sett
43. lipboard lp Save Gal Save As EF Open Cj Close Recent New Print Save amp Send Help Ej Exit nS To the next page 1 2 Select the lt lt File gt gt tab When using Microsoft Excel9 2007 click the Office button Select Options When using Microsoft Excel 2007 click the B mopem button From the previous page Sur General Formulas Proofing Save language Advanced Customize Ribbon Quick Access Toolbar Add_iInc 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 Excel helps to protect your privacy please see the privacy statements Show the Microsoft Excel privacy statement Office com privacy statement 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 privacy settings These settings help keep your computer secure We recommend that you do not change these settings NT Trusted Publishers Trusted Locations Trusted Documents Add ins Require Application Add ins to be signed by Trusted Publisher Disable notification for unsigned add ins code will remain disabled Disable all
44. ll 1 Keyboard key Enter key TERMS This manual uses the terms listed in the following table unless otherwise noted Term MX Sheet Personal computer PC CPU module MX Component Windows XP Windows Vista Windows 7 Windows 8 Windows 8 1 Windows 7 or later Excel System label Description Generic product name for SWnDNC SHEET E and SWnDNC SHEET EA n version EA indicates a volume license product Generic term for personal computers on which Windows operates Abbreviation for MELSEC Q series compatible PC CPU module CONTEC CO LTD product Generic product name for SWnDNC ACT E and SWnDNC ACT EA n version EA indicates a volume license product Generic term for Microsoft Windows XP Professional Operating System English version and Microsoft Windows XP Home Edition Operating System English version Generic term for 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 and Microsoft Window Vista Enterprise Operating System English version Generic term for Microsoft Windows 7 Starter Operating System English version Microsoft Windows 7 Home Premium Operating System English version Microsoft Windows 7 Professio
45. llowing Automatic meer oe Startup Setting amp proced ure Start Communication B 1 Select the lt lt Add Ins gt gt tab gt MX Sheet gt 1 Shot Communication 2 1Shot Communication screen is displayed CelAreaName SERRE Select the cell area name set in step 4 monitor function in this example as the Cell Area Name 3 Click the OK button to start 1 shot communication l MX SheetLxlsx Microsoft Exce 9 Starting communication Ee Select the lt lt Add Ins gt gt tab c MX Sheet gt Start Cell Setting U Communication to start monitor Automatic Save Setting K Automatic Print Setting O i 1 i Wes Automatic Communication Startup Setting amp AS the iL asd gt displayed click the Love button Communication will commence Is it OK Iri MX Sheetlodsx M ice 10 Ending communication Select the lt lt Add Ins gt gt tab gt MX Sheet gt End Communication to exit monitor After ending the communication delete the monitor data The Excel spreadsheet for monitor function is now completed CHAPTER 6 OPERATING MX Sheet 6 3 Writing Data This section provides an example of creating an Excel spreadsheet using the write function 1 Creation example Set the following Excel spreadsheet ltd 6 eis File Add Ins Mx Sheet H BB ES mj E GE RE EZ E ESI ew Menu commands Custom Toolbars J a EN e eT Tr Ts a 1 Enter values to be written to DO D2 in ord
46. lt Add Ins gt gt tab gt MX Sheet gt cell Seting End Communication to end writing Automatic Save Setting K Automatic Print Setting O l Automatic Communication Startup Setting amp l Start Communication B e F 6 H Complete The Excel spreadsheet for write function is now completed 46 CHAPTER 6 OPERATING MX Sheet 6 4 Automatic Saving This section explains a setting procedure for automatically saving the Excel book during MX Sheet operation 1 Setting example Automatic save condition Save when the device YO turns on Automatically saved file name Add date and time to the file auto xlsx Eas j e wey 5 Libraries Documents v Search Docum P Organize Share with New folder v Fill e yr Favorites Documents library RE Desktop Includes 2 locations Download 3 Recent Pla Arrange by Folder EP 3uto20120629162902 xl 5x GH MX Sheetlalsx Libraries Document Automatically saved Excel file RU Music Pictures RM Videos iM Computer E Er 2 items 47 Bulaes onewojny p 9 2 Setting automatic save This section explains an Excel book automatic save setting procedure 1 Add Ins Cell Setting L Automatic Print Setting O Automatic Save Name End of communication Device Trigger Clear cell area Automatic Save Name Line 1 Lot completion Save at the end of commun
47. mation available Location CAProgram Files Adobe Acrobat 10 0 PDFMaker Office PDFMOfficeAddin dll Acrobat PDFMaker Office COM Addin Description Analysis ToolPak VBA Euro Currency Tools Cancel Solver Add in Analysis ToolPak Provides data analysis tools For statistical and engineering analysis gO Ji MELSOFT Sheet s Search Sheet p Organize v New folder fl 9 Kl Microsoft Excel Name Date modified Type i Siz Je Sample 10 12 2011 11 13 AM File folder we Favorites EF MXShMenu xla 2 9 2011 7 38 PM Microsoft Excel Add In EE Desktop ig MXShRibbon xlam 10 9 2009 6 31 PM Microsoft Excel Add In m Downloads T E Recent Places Libraries a Documents 2 Music ig Pictures B Video dil ee adl 1 rr File name MXShMenu xla Add Ins available Analysis ToolPak Analysis ToolPak VBA Euro Currency Tools Solver Add in Automation MX Sheet MELSEC COMMUNICATION ADD IN MACRO S7 To the next page 3 s s CHAPTER 3 INSTALLATION AND UNINSTALLATION Excel Options screen is displayed Select Add Ins and select Excel Add Ins from Manage and then click the button Microsoft Excel 2003 Select Tool gt Add Ins from the menu bar to display the Add Ins screen Microsoft Excel 2007 Sel
48. me gt gt tab characters Logical Station Number 1 Device DO e Data type 16bit integer e Value DEC e Zoom ed No of cells 2 5 Cell Area Name Logical Sta Operation interval Device Trigger Handshake CSV Logging 1 The labels can be set to Device 2 When the system label is set to Device 1 is displayed to No of cells and cannot be changed Mandatory Settings Notset Setalready OK Cancel Apply Optional Settings Motset Setalready NUT To the next page From the previous page v Set the Operation Interval Operation Daily day C Weekly C Monthly Low Alternate date when a date does not exist jaturda Last day of the current month v Sra Regular interval C Minutely a Hourly vn Minute C Time table peo H1 Logging Time zone Frid LLELLL Log Always C Log only during the specified time zone Cell Area Name Logical Sta Operation Interval Device Trigger Handshake CSV Logging Mandatory Settings Notset Setalready Optional Settings Notset Setalready OK Cancel Apply Use Access Data v Set the Operation Interval Operation Daily C Weekly Sunday C Monthly Day lAl day E Monday Tuesday Wednesday Ei Thursday Jg Frid Alternate date n a date does not exist jaturda Last Last day ofthe current month v of the
49. nal Operating System English version Microsoft Windows 7 Ultimate Operating System English version and Microsoft Windows 7 Enterprise Operating System English version Windows 7 32 bit version is used for indicating 32 bit version only and Windows 7 64 bit version is used for indicating 64 bit version only Generic term for Microsoft Windows 8 Operating System English version Microsoft Windows 8 Pro Operating System English version and Microsoft Windows 8 Enterprise Operating System English version Windows 8 32 bit version is used for indicating 32 bit version only and Windows 8 64 bit version is used for indicating 64 bit version only Generic term for Microsoft Windows 8 1 Operating System English version Microsoft Windows 8 1 Pro Operating System English version and Microsoft Windows 8 1 Enterprise Operating System English version Windows 8 1 32 bit version is used for indicating 32 bit version only and Windows 8 1 64 bit version is used for indicating 64 bit version only Generic term for Windows T Windows 8 and Windows 8 1 Generic term for Microsoft Excel 2003 Microsoft Excel 2007 Microsoft Excel 2010 32 bit version and Microsoft Excel 2013 32 bit version Generic term for label names assigned to each device It can be used instead of devices in programs DEFINITIONS OF TERMS The following are the definitions of term
50. ny 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 2012 MITSUBISHI ELECTRIC CORPORATION 60 Memo 61 Microsoft Windows Windows Vista Windows XP Excel are trademarks or registered trademarks of Microsoft Corporation in the United States and other countries All other company names and product names used in this manual are trademarks or registered trademarks of their respective companies 62 MX Sheet Version 2 Operating Manual Introduction SW2DNC SHEET O NY E 13JU74 SH NA 081081ENG D 1405 KWIX 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 change without notice
51. oftware may impair or destabilize the correct operation of your system either immediately or in the future Microsoft strongly recommends that you stop this installation now and contact the software vendor for software that has passed Windows Logo testing Continue Anyway f STOP Installation Hardware Installation The software you are installing for this hardware MITSLIBISHI Easysocket Driver has not passed Windows Logo testing to verify its compatibility with Windows XP Tell me why this testing is important Continuing your installation of this software may impair or destabilize the correct operation of your system 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 STOP Installation Completed the installation of this product v Complete When installing a MELSOFT product the message on the left may be displayed Click the button to continue the installation When using Windows XP click the button The screen display may be different partially depending on the used operating system This does not affect the operation We have checked the operation and confirmed that no error occurs after the installation When the message on the left is displayed installation is complete Click the OK button to close the screen When the following
52. onal computer Windows supported personal computer Intel Core 2 Duo 2GHz or higher is recommended CPU Required memory Recommended 1GB or more 1 PC CPU module MELSEC Q series compatible PC CPU module CONTEC CO LTD product At installation 300MB or more Available hard disk capacity l o At operation Virtual memory available capacity is 512MB or more Display Resolution 1024 x 768 dots or more Microsoft Windows XP Professional Operating System English version SP3 or later Microsoft Windows XP Home Edition Operating System English version SP3 or later Microsoft Windows Vista Home Basic Operating System English version SP2 or later Microsoft Windows Vista Home Premium Operating System English version SP2 or later Microsoft Windows Vista Business Operating System English version SP2 or later Microsoft Windows Vista Ultimate Operating System English version SP2 or later Microsoft Windows Vista Enterprise Operating System English version SP2 or later Microsoft Windows 7 Starter Operating System English version a Oo P tem 4 5 6 Microsoft Windows 7 Home Premium Operating System English version A perating system gt Microsoft Windows 7 Professional Operating System English version Microsoft Windows 7 Ultimate Operating System English version i Microsoft windows 7 Enterprise Operating System English version i Microsoft windows 8 Operating System English
53. r Handshake CSV Logging CHAPTER 6 OPERATING MX Sheet 5 Setting the logical station number on the Access Data tab Click the _ communication settings button to start the communication setup utility for setting the logical station number When the following screen is displayed click the button i Do you execute programs as an administrator To change the communication settings select Yes When No is selected The communication settings cannot be changed When logging on without administrator authority the password input screen is displayed as follows lt Windows 7 or later gt lt Windows Vista gt B User Account Control 3 p kserAccount Conirof Don t run the program unless you know where it s from or you ve used it before F 1 ActComm exe Unidentified Publisher To continue type an administrator password and then click OK Program name ActComm exe Verified publisher Unknown File origin Hard drive on this computer To continue type an administrator password and then click Yes pp Professional E GX755 D Password 1 1 Passwor d Denis User Account Control helps stop unauthorized changes to your computer v Show details L After inputting the password click the button or the button The privilege escalation allowance screen on User 1 o O el a 5 ae Account Control s
54. ration Regular interval C Minutely HH MM time s Cell Area Name Logical Sta Operation Interval Device Trigger Handshake CSV Logging Mandatory Settings Notset Setalready OK Cancel Apply Optional Settings Notset Setalready Use Access Data Operation Interval Device Trigger Handshake v Set the Operation Interval Operation Daily C Weekly Sunday C Monthly Day 4 day m r r Th Friday Alternate date when a date does not exist Last day of the current month _ Saturday Y ee Regular interval Minutely Second 4 C Hourly Minute 4 C Timetable HH MM 4 iiid Cell Area Name Logical Sta Operation Interval Device Trigger Handshake CSV Logging Write function Write 1 Q06UDH Settings No settings No settings Mandatory Settings Notset Setalready OK Cancel Optional Settings Notset Setalready To the next page CHAPTER 6 OPERATING MX Sheet 5 Setting the Access Data gt gt tab Set the device to be written as follows After setting select the Operation Interval tab Logical Station Number 1 e Device DO e Data type 16bit integer e Value DEC Zoom 1 e No of cells 3 1 For the logical station number setting method refer to the following section KL Page 31 Section 6 1 2 The labels can be set to Device
55. rd m f VBA is not installed when an add in is installed for Excel the following error message is displayed and MX Sheet cannot be used Register add in manually after installing VBA w w o N 2 Add in registration was not performed a D VBA might not be installed D T Please register the add in manually from Excel after installing VBA a O cT 2 19 20 From the previous page NT The screen of Windows Vista and Windows 7 or later 8 Would you like to install this device software Name Jungo Jungo A Publisher MITSUBISHI ELECTRIC CORPORATION il ea ry You should only install driver software from publishers you trust How can I decide which device software is safe to install Always trust software from MITSUBISHI ELECTRIC CORPORATION Would you like to install this device software Name MITSUBISHI ELECTRIC CORPORATION Universa P s Publisher MITSUBISHI ELECTRIC CORPORATION Install Don un You should only install driver software from publishers you trust How can I decide which device software is safe to install Always trust software from MITSUBISHI ELECTRIC CORPORATION The screen of Windows XP gt Software Installation The software you are installing has not passed windows Logo testing to verify its compatibility with Windows XP Tell me why this testing is important Continuing your installation of this s
56. s m M Drag the cell B2 to F2 in this example on the left screen to specify the cell area in which monitor data is Menu Commands Custom Toolbars d isplayed ra se 4 al C 3 Displaying the Cell Settings screen Select the lt lt Add Ins gt gt tab gt MX Sheet gt Cell Setting to display the Cell Settings screen Add Ins Automatic Save Setting K Automatic Print Settina Q e Use Access Data o ation Interval Device Trigger Handshake CSV Logging s 4 Setting the lt lt Use gt gt tab Use montor s Set the following items on the lt lt Use gt gt tab Cell Area Name Monitor function After setting select the Access Data tab Cell Area B2 F2 Set the Color of Grid line Set the Color for Filling J7 Clear cell area at the start of communication Cell Display Direction ret to Right v e Use Monitor Cell Area Name Monitor function e Cell Area B2 F2 Cell Display Direction Left to Right Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CSV Logging Mandatory Settings Notset Setalready OK Cancel Apply Optional Settings Motset Setalready To the next page From the previous page Use Access Data Operation Interval Device Trigger Handshake CSV Logging Logical Station Number f1 QOBUDHCPU_USB X Communication Settings _Cell Area Name
57. s not installed when registering the add in MX Sheet cannot be used After installing VBA register the add in manually 26 Review View Add Ins f The Browse screen is displayed Select MXShRibbon xlam in File name and click the button 8 The Add ins screen is displayed Check that Additional MX Sheet Add in is selected and click the button 9 Check that MX Sheet is added to the lt lt Add Ins gt gt tab The icon buttons are also displayed The manual add in registration is complete 3 2 Uninstallation This section explains MX Sheet unistallation CHAPTER 3 INSTALLATION AND UNINSTALLATION Screens from Windows 7 are used except for different operations required in other operating systems Operating procedure c Jm v 4t Search Control P Qo A gt Control Panel Adjust your computer s settings View by Category System and Security User Accounts Back up your computer I Change account type Find and fix problems dignus zi Appearance and _ Network and Internet il ppe und View network status and tasks Personalization Choose homegroup and sharing Change the theme options Change desktop background Adjust screen resolution Hardware and Sound M View devices and printers Clock Language and Add a device ci Region lt Change keyboards or other input Programs iid Uninstall a program Get programs Change display language e Ease of
58. s safely Furthermore for the online operations performed from a personal computer to a programmable controller CPU the corrective actions against a communication error due to such as a cable connection fault should be predetermined as a system NCAUTION The online operations performed from a personal computer to a running programmable controller CPU forced output and operating status changes must be executed after the manual has been carefully read and the safety has been ensured The operation failure may cause the injury or machine damage G CONDITIONS OF USE FOR THE PRODUCTO 1 Mitsubishi programmable controller the PRODUCT shall be used in conditions e i where any problem fault or failure occurring in the PRODUCT if any shall not lead to any major or serious accident and ii 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 RESPONSIBILITY OR LIABILITY BASED ON CONTRACT WARRANT Y 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
59. s used in this manual 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 1 ARTT T 1 Transmission speed Transmission control e c c a c c c c o 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 CHAPTER 1 OVERVIEW CHAPTER 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 For details refer to the following manual LA MX Sheet Version 2 Operating Manual Logging function monitor function Write function Automatic print function Write D1 D2 D3 buywpmemaw i 3 a bmipsemTuoeau x aol aa 2012 06 28 Thu 20 41 27 aj 42 aajo a 2012 06 28 Thu 20 41 32 Sa S2 S3 sal 2012 06 28 Thu 20 41 37 62 63 64 Monitor Alarm summary function Comment display function Autom
60. screen the error occurs as follow F Communication Setting V3 Updating the system information data failed There isa ibility wi the operation authority Please execute it by the administrator authority user There is a possibility that the operating environment of the application is corrupt Starting the Communication Setting Wizard After starting the communication setup utility select the Target Setting gt gt tab and click the Wizard button Setting the logical station number Set 1 in Logical station number and click the ex button CHAPTER 6 OPERATING MX Sheet From the previous page 8 Setting the personal computer side interface Please select the PC side I F PC side uF Communication setting Time out 10000 ges Set the following items and click the ex button e PC side I F USB e Time out 10000 9 Setting the programmable controller side interface Please select the PLC side IF Set the following items and click the e button 5s side b _ 9 CPU type Co PLC side I F CPU module CPU type QOGUDH 10 Selecting the communication path Please select the Network SOS Set the following items and click the we button o uo o Station type Host station Multiple CPU None amp a 11 Enter any word QOGUDHCPU USB in this example and click the b
61. setup Enter the name and company name and click the Type your name below You must also type the name of the company you work for Next button Name Mitsubishi Company MITSUBISHI ELECTRIC Co B Cancel 4 Check the registered name and company name Check if the registered content is correct and click the Y ou have provided the following registration information Name Mitsubishi Yes button C MITSLIBISHI ELECTRIC Co i j j ompany In order to change the information click the Oo wo button to return to the previous screen Is this registration information correct uone pesu Z L uone Eisu L 5 Register the product ID PI ter th duct ID of th duct I iesu pedis Enter the product ID and click the wee button The product ID is printed on the license certificate included with the product lt Back Cancel To the next page 17 18 From the previous page S7 lt Destination Folder C SMELSEC Browse The setup will install Sw nDN 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 lt Back Cancel Do you want to register add in MX Sheet menu to Excel v Register add in lt Back Cancel Excel is started in order to carry out add in registration of the MX Sheet menu to Excel
62. sh version Microsoft Excel 2007 English version 10 Excel 2 Microsoft Excel 2010 32 bit version English version Or Microsoft Excel 2013 32 bit version English version 1 MX Component MX Component Version 4 or later 9 TS ibi Re 512 Excel spreadsheets created in the English environment are applicable to the English environment only cannot be used in the other environment When using Microsoft Excel 2007 Microsoft Windows XP Service Pack 2 or later is required When using Microsoft Excel 2010 32 bit version Microsoft Windows XP Service Pack 3 Microsoft Windows Vista Service Pack 1 Microsoft Windows 7 or later is required Microsoft Excel 2010 64 bit version is not supported When using Microsoft Excel 2013 32 bit version Windows 7 or later is required Microsoft Excel 2013 64 bit version is not supported Point Considerations when using Microsoft Excel 2010 or later In order to use MX Sheet install Microsoft Excel 2010 32 bit version or later When installing MX Sheet on the personal computer where Microsoft Excel 2010 64 bit version or rater is installed the following error message is displayed ai Excel 64bit version was installed in an environment can not perform the SL installation After MX Sheet is installed Microsoft Excel 2010 64 bit version or later is installed and started then an add in is installed the following error
63. sheet displayed can be automatically changed RET Communication error CLEP ET SA ROPE COLLET D DRE Occu rrence Error Log sheet is displayed Automatic display change 4 i B s ESSE E Kind Date Cell Area Name ErrorNo Contents Information 2012 06 29 Fri 15 21 47 00000000 Communication was started Warning 2012 06 29 Fri 15 21 49 est e1000021 Communication error has occurred in the open close of communication 0 0010003 Hex 01808502 Hex M USB driver connect error Connection of the USB driverfailed The corrective action is as follows Exit the program and restart the IBM PC AT compatible Reinstall MX Component Check USB driver installation 3 lt ErrorCode 1808502 Hex gt 4 Information 2012 06 29 Fri 15 21 57 00000002 Communication was completed 3 Error log clear setting at communication start At the start of communication the error log can be cleared 59 Bunjes Hoj 10444 g xipueddy 99uS XN Jo suonounJ jnjes xipueddy REVISIONS The manual number is written at the bottom left of the back cover Print date Jul 2012 SH 081081ENG A First edition Aug 2013 SH 081081ENG B TERMS Chapter 2 Section 3 1 2 Section 3 2 Section 6 1 Section 6 2 Dec 2013 SH 081081ENG C TERMS Chapter 2 May 2014 SH 081081ENG D TERMS Chapter 2 Chapter 3 Japanese Manual Version SH 081079 D This manual confers no industrial rights or a
64. t s from or I ve used it before Change when these notifications appear v Details W C2 User Account Control helps stop unauthorized changes to your computer UM N e _ 2 25 O o D s Om Point T 2 O 2 When using Windows 8 and Windows 8 1 refer to the following document e TECHNICAL BULLETIN No FA A 0153 2 Install the product again If this product is not installed properly at this time restart the personal computer 21 22 b The Program Compatibility Assistant screen may be displayed after installation Select This program installed correctly and restart the personal computer 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 Publisher InstallShield Software Corporation LE Program Setup Launcher Location F EnvMEL SETUP EXE 8 Reinstall using recommended settings o What settings are applied If Reinstall using recommended settings is selected the Windows XP SP2 compatibility mode is automatically set Disable the Windows XP SP2 compatibility mode by the following procedure and install the product again SE if you have problems with this program and it worked an earlier version of Windows select the compatibil matches that earlier version Help me choose the settings Compat
65. tch tab to display the Write to Device screen Forcibly turn on YO in the following procedure 1 Enter YO in Device in Bit Device 2 Click the button After completing the above settings click the cse button Checking the device status Check that YO is turned on as set in step 8 After checking click the Step monitor button and then the __xt__ button 10 Checking the saved file The operation in step 8 activates the automatic save setting function and saves the Excel book automatically Start Explorer and check if the file specified in step 3 is saved correctly After checking the file select the lt lt Add Ins gt gt tab gt MX Sheet gt End Communication to end communication The automatic save setting is now completed CHAPTER 6 OPERATING MX Sheet 6 5 Automatic Printing This section explains a setting procedure for automatically printing the whole Excel book or specified Excel sheets during the 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 Setting automatic print This section explains an Excel spreadsheet automatic print setting procedure Operating procedure 1 Selecting automatic print setting Start Excel and select the lt lt Add Ins gt gt tab gt ge settmgi MX Sheet gt Automatic Print Setting to display the Automatic Save Setting K o automstePintSengOh
66. the left and select any item other than Disable all controls without notification Select Macro Settings from the list on the left and select Enable all macros not recommended potentially dangerous code can run After configuring the above settings click the button and exit Excel 15 jeeus XW Buiejsur eojeg LL Le uone eisu 3 1 2 Installation 1 Installing the product Operating procedure Ss f Right click Start and select Explorer eG z Computer DVD RW Drive v 4 Search DVD RW Drive J Orpon source x 0 XX Favorites rli acm me a m When user account control is enabled the following P E Cabinet File beares cem screen is displayed ES Documents ner a Music 445KB 419 bytes Cli amp amp 3 ick the button or Allow Pictures a d B Videos S LicCheck dll iet zm ud Windows 7 or later Windows Vista gt I Computer F e Setup bmp Ee PROCHECK dll oe image LE Setup Launcher 1 Ps Configuration settings InstallShield Software Corporation 79 bytes j paaka the program unless you know where it s from or you ve used it ID uA Pes es LE SETUP EXE e 100 KB udi 49 bytes I File origin CD DVD drive Unidentified Publisher SETUP EXE Date modified 6 8 2012 8 00 AM Date created 6 12 2012 9 19 AM Show details Cx Mn
67. uarantee the commercially available Microsoft Windows9 Operating System based software products that are introduced in this manual The copyright of this software package is owned by Mitsubishi Electric Corporation Reprinting or reproducing the part of or entire this manual without prior permission of Mitsubishi Electric Corporation is prohibited Although we have made the utmost effort to follow the revisions of the software and hardware in some cases unsynchronized matter may occur The software license must be purchased per personal computer This software package including this manual must be used under the Software License Agreement only Mitsubishi shall have no responsibility or liability for any defects caused by operating this software package including this manual The descriptions in this manual may be subject to change without prior notice CONTENTS SARETYRECAUBIONSS SE UE ER ME MC ete OIA ae cd tn eR teas Em Nic 1 CONDITIONS OF USRFORTHE PRODUCT cnt Et edente Ea net eat eee OE ME LE 2 INTRODUCTION AE cT pu HE cu E UR 3 RELATED VANUIAIES s muc e edet E m MOS LEE TIAS REC ue E tM 3 HOW TO READ THIS MANWAL EE o TH A cM ibo E n do qu 5 TERMS Bierce AEA A E EE E EI EI ei NA A AA E DM E A eA NC ANEA T7 IDEE TIRE NS OF TERMS ecu ea E E e E nio od toon a E E ce E A A 8 CHAPTER 1 OVERVIEW 9 tI Whati MX Sheel ss sius 000655500400 cemg e a E urbe ai 9 1 2 Functions Explained in This Manual lle 10 CHAPTER 2
68. ue 16bit integer pec EE Device Batch Buffer Memory Entry Device 1 FEDC BASS 7654 3210 FEDC BA9B 7654 3210 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 aoeupH use Stop monitor Monitor format Bit Display 16bit integer Data format DEC z z 4 4 Bit order F 0 Ow ES gt Libraries Documents gt Search Docum P Organize v Share with v wr Favorites RE Desktop Download E Recent Pla LU 13 Libraries B Document 2 Music i Pictures B video 1M Computer e 2items New folder 8 v i e Documents library Includes 2 locations E auto20120629162902 xlsx NUS Complete I MX SheetLxlsx Arrange by Folder v Writing to device Change the YO device status Double click the monitor display area of the Device Ba
69. utton The Communication wizard has finished collecting information Please Finish to build the logical station number Comment GOBUDHCPU US3 Nt To the next page 35 From the previous page ES ECE xl 12 Checking the settings Teste rive eres Check if the logical station number settings displayed on Logical station number f1 0BUDHCPU_USB the Target setting tab of the Communication Setup Utility screen are correct BEN lt i After checking select the lt lt Connection test gt gt tab Multiple CPU None Exit por c 1 3 Connection test enu elp Target setting List view Connection test Logosi station nuno FE Click the Test button to check that the programmable Communication diagnosis cout s controller and personal computer are normally EOS communicating Diagnosis count 0 I After confirmation click the button to close the Result communication setup utility CPU name 3 M 0 ms j a Remy T du An error message is displayed if they are not communicating normally Check the error definition and remove the error s Logging function 14 Setting the Access Data gt gt tab Use Access Data Operation interval Device Trigger Handshake CSV Logging Logical Station Number 1 QOBUDHCPU_USB Set the device to be logged as follows m E No of After setting click the lt lt Operation ti
70. version E Microsoft Windows 8 Pro Operating System English version B Microsoft windows 8 Enterprise Operating System English version i Microsoft Windows 8 1 Operating System English version X Microsoft Windows 8 1 Pro Operating System English version Microsoft Windows 8 1 Enterprise Operating System English version i 1 For Windows 7 64 bit version Windows 8 64 bit version or Windows 8 1 64 bit version 2GB or more memory is required 2 When installing NET Framework at least 1GB of free space is required 9 This includes the required free space for installation of MX Component 4 Windows XP Professional 64 bit version and Windows Vista 64 bit version cannot be used 5 NET Framework 2 0 and NET Framework 2 0 English Language Pack installation is required 6 The following functions cannot be used If used this product may not operate normally Activating the application with Windows9 compatible mode e Simplified user switch over Remote desktop Large font size Advanced setting of Display Properties DPI setting other than 100 set the size of text and illustration other than smaller 100 e Windows Hibernate and Standby f The following functions cannot be used e Windows XP Mode e Windows Touch 8 The following functions cannot be used e Modern UI Client Hyper V Touch 11 12 Item Description Required software Microsoft Excel 2003 Engli

MX Sheet Version 2 Operating Manual

Contents

Download Pdf Manuals

Related Search

Related Contents