Home

"user manual"

1. Communication Setting wa 5 Ss Updating the system information data failed 4 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 Communication Setup Utility Menu Help hola 6 Starting the Communication Setting Wizard After starting the communication setup utility select the lt lt Target Setting gt gt tab and click the Wizard button Cancel 7 Setting the logical station number Set 1 in Logical station number and click the next button This Communication Setting Wizard will set the communication information for ACT 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 z Back met Fos To the next page From the previous page Please select the PC side IF PC side UF Communication setting Time out 10000 ms Please select the PLC side IF PLC side IF cru module X Communication setting CPU type QO6UDH v ommunication Setting Wizard Netwo x Please select the Network Station type Host station Multiple CPU None The Communication
2. 15 Setting the lt lt Operation Interval gt gt tab V Set the Operation Interval Set the logging operation interval as follows Operation Daily C Weekly D C Monthly Day a day T Tl ies TT vWedne FT Trursde e Set the Operation Interval Selected i El Last day of the current month e Operation day A Daily Operation time Regular interval 5 seconds e Logging Time Zone Log Always TNN Regular interval Minutely zarda C Hourly nala C Time table HH nana E y Y El Logging Time zone Log Always Log only during the specified time zone Cell Area Name Logical Sta Operation Interval Device Trigger Handshake CSY Logging Mandatory Settings Notset Setalready OK Cancel Apply Optional Settings Notset Setalready el Settings Logging function 16 Applying the settings Y i Device Trigger Handshake CSV Logging Y Set the Operation Interval Click the 4nply button to enable the settings of the aD Daily C Weekly 7 C Monthly Day ay eee Cell Settings screen 7 Wednesde 5 He Check that the cell area is registered as shown on the left T Last day of the current month screen and click the or button Operation Regular interval Minutely al Hourly al Time table ore Secon 5 3 Yv Logging Time zone Log Always C Log only during the specified time zone Cell Are
3. 39 40 2 Setting MX Sheet This section explains the procedure of creating an Excel spreadsheet for monitor function Operating procedure x Save fis Oo Libraries Documents Organize v New folder Documents library A E Arrange by Folder y We Favorites Includes 2 locations E HE Desktop B Downloads Name Date modified Type El Recent Places Noi A Libraries Documents d Music G m Filename MX Sheet xls m Save as type Excel Workbook xlsx X Authors Add an author Tags Add a tag E Save Thumbnail ZH 9 M MX SheetLxlsx Microsoft Excel PE al GS GE CB Menu Commands Custom Toolbars Home Insert Pagelayout Formulas Data Review View Add Ins Tear XA MX SheetLxlsx Microsoft Excel Page layout Formulas Data Review View Add Ins Home Insert Automatic Save Setting K Automatic Print Setting O SS sss ys Use Access Data Operation Interval Device Trigger Handshake CSY Logging Use Monitor Cell Area Name Monitor function Cell Area B2 F2 Set the Color of Grid line Set the Color for Filling 7 Clear cell area at the start of communication Cell Display Direction Left to Right ba y Cell Area Name Logical Sta Operation Interval Device Trigger Handshake CS Logging Mandatory Settings Notset Setalready
4. 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 Professional E P asswor d i Show details Y Details User Account Control helps stop unauthorized changes to your computer After inputting the password click the button or the button The privilege escalation allowance screen on User Account Control screen is displayed as follows lt Windows Vista gt Don t run the program unless you know where it s from or you ve used it before Il GX755 D Password o E O O a gt Program name ActComm exe Publisher Unknown F l ActComm exe File origin Hard drive on this computer w Unidentified Publisher I don t know where this progra show denis E Change when these notifications appear Allow I trust this program I know where it s from or I ve used it before Y Details User Account Control helps stop unauthorized changes to your computer NE To the next page 33 34 From the previous 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 screen the error occurs as follow
5. File Home Insert Fage Layout Formulas Data Review Wiew Add Ins Team a o T ES MA Sheet 7 E a a PLB AB Ee Menu commands Custom Toolbars de _ O O a 5 2012 06 28 Thu 20 41 07 l so 2012 06 28 Thu 204112 a ss ol 2012 06 28 Thu 20 41 17 52 60 0 2012 06 28 Thu 20 41 22 57 65 0 2012 06 28 Thu 20 41 27 62 wf 0 2012 06 28 Thu 20 41 32 67 s o 2012 06 28 Thu 20 41 37 72 eof ol 2012 06 28 Thu 20 41 42 a esp ol ol a 2012 06 28 Thu 20 41 47 saf ay op ol a UE DA NE Sheetl 4 SHEETS aaa times are displayed Content of DO to D4 are depiayedi 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 31 2 Setting MX Sheet This section explains the procedure of creating an Excel spreadsheet for logging function Operating procedure Organize v New folder fazam 4 Arrange by Folder v Includes 2 locations A Y Favorites Name Date modified Type Size WE Desktop BR Downloads No items match your search SG Recent Places K Microsoft Excel Documents library Libraries E Documents 4 File name Bookl xlsx Save as type Excel Workbook xlsx Authors Add an author Tags Add a tag Save Thumbnail Add Ins Automatic Save Setting K Automatic Print Setting O Automatic Communication Startup Setting 4 SS Use Access Data Operation Interval
6. Fo y Write to Device Bit device Device Yo Force OFF Toggle force Word device Buffer memory Buffer memory Module start VO Device tex Address Setting value 16bit integer pec LC Monitor Util Sc Menu Online Help Device Batch Buffer Memory Entry Device 8 Writing to device Change the YO device status Double click the monitor display area of the lt lt Device Batch gt gt 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 Close button 9 Checking the device status Check that YO is turned on as set in step 8 After checking click the Stop monitor button and then the Exit button Device 1 FEDC BASS 7654 3210 0 FEDC BASS 7654 3210 q 20 0000 0000 0000 0000 0000 0000 0000 0000 A Yo 40 0000 0000 0000 0000 0000 0000 0000 0000 60 0000 0000 0000 0000 0000 0000 0000 0000 N B0 0000 0000 0000 0000 0000 0000 0000 0000 Yao 0000 0000 0000 0000 0000 0000 0000 0000 Yco 0000 0000 0000 0000 0000 0000 0000 0000 YEO 0000 0000 0000 0000 0000 0000 0000 0000 100 0000 0000 0000 0000 0000 0000 0000 0000 120 0000 0000 0000 0000 0000 0000 0000 0000 Y140 0000 0000 0000 0000 0000 0000 0000 0000 Stop monitor Y160 0000 0000 0000 0000 0000 0000 0000 00
7. 00 Ostrava Pustkovec Phone 420 595 691 150 Fax 420 595 691 199 Beijer Electronics A S Lykkeg rdsvej 17 DK 4000 Roskilde Phone 45 0 46 75 76 66 Fax 45 0 46 75 56 26 Beijer Electronics Eesti OU P rnu mnt 160i EE 11317 Tallinn Phone 372 0 6 51 81 40 Fax 372 0 6 5181 49 Beijer Electronics OY Peltoie 37 FIN 28400 Ulvila Phone 358 0 207 463 540 Fax 358 0 207 463 541 UTECO 5 Mavrogenous Str GR 18542 Piraeus Phone 30 211 1206 900 Fax 30 211 1206 999 MELTRADE Kft Fert utca 14 HU 1107 Budapest Phone 36 0 1 431 9726 Fax 36 0 1 431 9727 Beijer Electronics SIA Ritausmas iela 23 LV 1058 Riga Phone 371 0 784 2280 Fax 371 0 784 2281 Beijer Electronics UAB Savanoriu Pr 187 LT 02300 Vilnius Phone 370 0 5 232 3101 Fax 370 0 5 232 2980 AUSTRIA BELARUS BELGIUM BELGIUM BULGARIA CROATIA CZECH REPUBLIC DENMARK ESTONIA FINLAND GREECE HUNGARY LATVIA LITHUANIA e MITSUBISHI ELECTRIC ALFATRADE Ltd 99 Paola Hill Malta Paola PLA 1702 Phone 356 0 21 697 816 Fax 356 0 21 697 817 INTEHSIS srl bld Traian 23 1 MD 2060 Kishinev Phone 373 0 22 66 4242 Fax 373 0 22 66 4280 HIFLEX AUTOM TECHNIEK B V Wolweverstraat 22 NL 2984 CD Ridderkerk Phone 31 0 180 46 60 04 Fax 31 0 180 44 23 55 Koning amp Hartman b v Haarlerbergweg 21 23 NL 1101 CH Amsterdam Phone
8. 1 Select the lt lt Add Ins gt gt tab gt MX Sheet gt 1Shot Communication 2 1Shot Communication screen is displayed 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 Starting communication Select the lt lt Add Ins gt gt tab gt MX Sheet gt Start Communication to start monitor As the message is displayed click the vw button 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 X AE Book2 Microsoft Excel File Home Inset Fage Layout Formulas Data Review Wiew Add Ins Team Mx Sheet E idl Eel fain fet Ge HE ed Gee El Bs A Meru Commands Custom Toolbars A pc of ef 6 i Enter values to be written to DO D2 in order from left to right ejeg Bunun E9 43 44 2 Setting MX Sheet This section explains the procedure of creating an Excel spreadsheet for monitor function Operating procedure X Save A Owe FS Libraries Documents v p Search D
9. 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 MITSUBISHI ELECTRIC EUROPE B V German Branch Gothaer Stra e 8 D 40880 Ratingen Phone 49 0 2102 486 0 Fax 49 0 2102 486 1120 MITSUBISHI ELECTRIC EUROPE B V org sl CZECH REP Czech Branch Avenir Business Park Radlick 714 113a CZ 158 00 Praha 5 Phone 420 251 551 470 Fax 420 251 551 471 MITSUBISHI ELECTRIC EUROPE B V French Branch 25 Boulevard des Bouvets F 92741 Nanterre Cedex Phone 33 0 1 55 68 55 68 Fax 33 0 1 55 68 57 57 MITSUBISHI ELECTRIC EUROPE B V Irish Branch Westgate Business Park Ballymount IRL Dublin 24 Phone 353 0 1 4198800 Fax 353 0 1 4198890 MITSUBISHI ELECTRIC EUROPE B V Italian Branch Viale Colleoni 7 1 20864 Agrate Brianza MB Phone 39 039 60 53 1 Fax 39 039 60 53 312 MITSUBISHI ELECTRIC EUROPE B V Poland Branch Krakowska 50 PL 32 083 Balice Phone 48 0 12 630 47 00 Fax 48 0 12 630 47 01 MITSUBISHI ELECTRIC EUROPE B V 52 bld 3 Kosmodamianskaya nab 8 floor RU 115054 Moscow Phone 7 495 721 2070 Fax 7 495 721 2071 MITSUBISHI ELECTRIC EUROPE B V Spanish Branch Carretera de Rubi 76 80 E 08190 Sant Cugat del Vall s Barcelona Phone 902 131121 34
10. 31 0 20 587 76 00 Fax 31 0 20 587 76 05 Beijer Electronics AS Postboks 487 NO 3002 Drammen Phone 47 0 32 24 3000 Fax 47 0 32 84 85 77 Fonseca S A R Jodo Francisco do Casal 87 89 PT 3801 997 Aveiro Esgueira Phone 351 0 234 303 900 Fax 351 0 234 303 910 Sirius Trading amp Services srl Aleea Lacul Morii Nr 3 RO 060841 Bucuresti Sector 6 Phone 40 0 21 430 40 06 Fax 40 0 21 430 40 02 INEA RBT d o 0 Izletnicka 10 SER 113000 Smederevo Phone 381 0 26 615 401 Fax 381 0 26 615 401 SIMAP s r o Jana Derku 1671 SK 911 01 Trencin Phone 421 0 32 743 04 72 Fax 421 0 32 743 75 20 PROCONT spol s r o Pre ov K peln 1 A SK 080 01 Pre ov Phone 421 0 51 7580 611 Fax 421 0 51 7580 650 INEA RBT d 0 0 Stegne 11 SI 1000 Ljubljana Phone 386 0 1 513 8116 Fax 386 0 1 513 8170 Beijer Electronics AB Box 426 SE 20124 Malmo Phone 46 0 40 35 86 00 Fax 46 0 40 93 23 01 Omni Ray AG Im Sch rli 5 CH 8600 D bendorf Phone 41 0 44 802 28 80 Fax 41 0 44 802 28 28 GTS TURKEY Bayraktar Bulvari Nutuk Sok No 5 TR 34775 Yukar Dudullu Umraniye ISTANBUL Phone 90 0 216 526 39 90 Fax 90 0 216 526 3995 CSC Automation Ltd 4 B M Raskovoyi St UA 02660 Kiev Phone 380 0 44 494 33 55 Fax 380 0 44 494 33 66 MALTA MOLDOVA NETHERLANDS NETHERLANDS NORWAY PORTUGAL ROMANIA SERBIA SLO
11. Automatic Save Setting K Automatic Print Setting O Automatic Communication Startup Setting 4 Postomino PT E l e SI anl al al Communication will commence pa Is it OK Ri ed 9 e gt Add Ins Team Complete 38 18 Adjusting the display After 1 shot communication HHHF 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 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 20 Ending communication Select the lt lt Add Ins gt gt tab gt MX Sheet gt End Communication to end logging 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 x HAD PAX SheetLelsx Microsoft Excel File Home Inset Fage Layout Formulas Data Review wiew Add Ins Tear chety E A EA Menu Commands Custom Toolbars a E al A 6 H 1 3 Access data DO to D4 are displayed in order from left to right BULIOJUOA Z 9
12. B2 to D2 in this example on the left screen to specify the cell area in which monitor data is displayed 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 4 Setting the lt lt Use gt gt tab Set the following items on the lt lt Use gt gt tab After setting select the lt lt Access Data gt gt tab e Use Write e 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 GOBUDHCPU_USB v Communication Settings Device po E E ummm gt Sm O a Cell Area Name Logical Sta Operation Interval Device Trigger Handshake CSY Logging Mandatory Settings Notset Setalready OK Cancel Apply Optional Settings Notset Setalready m ell Settings Write function Use Access Data Operation Interval Device Trigger Handshake JV Set the Operation Interval Operation Daily C Weekly 7 Monthly Day a day C fa Tu i C lo r r i ne current month it Last day of tr v eta Regular interval Minutely Hourly Time table HH H Logical Sta Operation Interval Device Trigger Handshake CSW Logging Cell Area Name _ Mandatory Setti
13. Device Trigger Handshake CS Logging Use Logging y Cell Area Name Logging function Cell Area B2 611 Set the Color of Grid line Set the Color for Filling JV Clear cell area at the start of communication New data location Last Line y Display Contents D Add title JV Add date and time details Start Communication B Operation when cell is 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 JT Save to file File name to save Add date and time to File name Add sequential number to File name ooo gt ess Fix the File name Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CSY Logging Mandatory Settings Notset Setalready OK Cancel Apply Optional Settings Notset Setalready To the next page 32 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 e
14. Hourly Minute 2 Time table HH time Yv Cell Area Name Logical Sta Operation Interval Device Trigger Handshake CSY Logging Mandatory Settings Notset Setalready OK Cancel Apply Optional Settings Notset Setalready JV Set the Operation Interval Operation Daily C Weekly day C Monthly Day a r r T E X E Thu r rc Operation Regular interval Minutely E C Hourly Minute Time table Ma time 5 s v ya Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CS Logging Monitor function Monitor 1 GOBUDH Settings No settings No settings No settings Mandatory Settings Notset Setalready OK Cancel Optional Settings Notset Setalready 7 To the next page 5 gg e a NE 6 7 CHAPTER 6 OPERATING MX Sheet Setting the lt lt Access Data gt gt tab Set the device to be monitored as follows After setting select the lt lt Operation Interval gt gt tab Logical Station Number 1 e Device DO e Data type 16bit integer e Value DEC e Zoom 1 e No of cells 2 3 For the logical station number setting method refer to the following section gt 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 lt lt Operation Interval
15. gt gt tab Set the monitor operation interval as follows e Set the Operation Interval Selected e Operation day Daily e 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 From the previous page MX SheetLxlsx Microsoft Excel x dl 2 e 1 gt Home Insert Pagelayout Formulas Data Review View Add Ins Tear Cell Setting L Automatic Save Setting K Automatic Print Setting O I Automatic Communication Startup Setting A Start Communication B ae e G H Cell Area Name Monitor function gt OK cancel MX SheetLxlsx Microsoft Excel x el a e 1 gt Home Insert Pagelayout Formulas Data Review View Add Ins Tear Cell Setting L Automatic Save Setting K Automatic Print Setting O Automatic Communication Startup Setting A Communication will commence Is it OK MX SheetLxlsx Microsoft Excel XH I M e Add Ins Team eee PELLET EF e H_ i Complete 42 8 Checking the settings Check if the settings in steps 1 to 7 are correct by using the 1 shot communication function of MX Sheet Perform 1 shot communication in the following procedure
16. i O Enable all macros not recommended potentially dangerous code can run D can run D Developer Macro Settings Q Trust access to the VBA project object model z 7 After configuring the above settings click i button and exit Excel Nx Complete jasys XW Bulyjeysul au0jog p P E 15 3 1 2 Installation 1 Installing the product Operating procedure This package will not run unless MX Component Version 4 or above is installed When you want to install as it is please install MX Component Version 4 or above after installation of this package This package has already been installed There is a possibility for improper installation if you execute without uninstalling it oc C This package is not in proper operating environment Please install this package after executing EnvMEL Setup Exe from CD ROM Continued on next page 16 go gt Computer DVD RW Drive J gt 4 Search DVD RW Drive J Organize y Open Share with v New folder d a mseme Jonware COTpurarnorr E setup Ceorrcrrer MESUUICE re Favorites En sysl cab 8 userl cab HE Desktop y Cabinet File y Cabinet File my Downloads Recent Places DATA TAG a datal cab TAG File E Cabinet Fil 134 bytes Eo E A Libraries i n lang dat layout bin ES Documents DAT File BIN File a Music 4 45 KB 419 bytes Pictures os dat B Videos 6 LicCheck d
17. xlsx After specifying the file name click the button After completing the settings click the ok button From the previous page S Enable Automatic Save Name End of communication Date time Device Trigger fi y Automatic Sawe List Clear cell area Create New Edit Delete Line 1 Lot completion No settings No settings Settings No settings Close MX SheetLxlsx Microsoft Excel Mid My Home Insert Pagelayout Formulas Data Review View Add Ins Tear Mshet EEEE TEER Cell Setting L Automatic Save Setting K Automatic Print Setting O Automatic Communication Startup Setting 4 MX Sheet Es Communication will commence Is it OK Transfer settina Utility setting type Logical station number 1 QOBUDHCPU_USB y C Program setting type Connect Retry Times 9 R PLC Monitor Utility o O a Menu Online Help Device Batch Buffer Memory Entry Device D gt Monitor format Bit amp Word AR Display 16bit integer Data format DEC Bit order F 0 Q06UDH USB 1 Ni To the next page CHAPTER 6 OPERATING MX Sheet Specifying the automatic save conditions The automatic save name is added to the list Check that the check box of Enable is selected click the o button to close the Automatic Save List screen Starting commun
18. 00 Y180 0000 0000 0000 0000 0000 0000 0000 0000 Y1AO 0000 0000 0000 0000 0000 0000 0000 0000 x Mondor format ot gt Yico 0000 0000 0000 0000 0000 0000 0000 0000 r Display 16bit integer 1E0 0000 00 0 0 0000 Data format DEC Bit order F 0 QO06UDH USB 1 gt v es Search Docum p 9 B Libraries Documents gt Organize v Share with v New folder ann v O Favorites Documents library Are E BZ Desktop Includes 2 locations load 8 GAN EP auto20120629162902 x1sx E MX Sheet xlsx El Recent Pla 3 Libraries Document ad Music 5 Pictures Videos jE Computer p 2 items SS ae Complete 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 expla
19. 1 2 Functions Explained in This Manual 10 CHAPTER 2 OPERATING ENVIRONMENT 11 CHAPTER 3 INSTALLATION AND UNINSTALLATION 13 Salt Installation sas ie e ie o dk 13 3 1 1 Before installing MX She t ooooooooooronr tee teen eens 13 Sls E SA RI eee 16 so Installation Check oia a diia 23 3 1 4 Manual add in registration o ooooocooronronoa tenet nee 24 32 AUMINSAIAOM 22922 et ee ees owe me tn eho kek AR ee eee Se eae Re 2 CHAPTER 4 SYSTEM CONFIGURATION USED IN THIS MANUAL 29 CHAPTER 5 MX Sheet OPERATION PROCEDURE 30 CHAPTER 6 OPERATING MX Sheet 31 61 A o o sirk eat leh e dle alee e eet ae Bd Lee ot eae tee 31 6 2 WOMIOUNG podi ol seus eee ote alt ches salda 39 Oo WMO Dales australianas wad oes eet chia aie mulns eee 43 64 Aulomatic Saving i422 p ito ee bite a A A ee des 47 60 Automatic PANUNG 22 02 1d amd ped ea dee rl 51 6 6 Creating Using BUON 2 4 2 24050528 rs bose od MUSES bade HERS aa eee 53 APPENDIX 54 Appendix 1 Useful Functions of MX Sheet 0 0 00 eee nee 54 Appendix 1 1 Alarme SUMMA VS 2 IES AR EEES AAA 54 Appendix 1 2 Comment CISD Via aa A AAA AA Ada 55 Appendix 1 3 DENCIA da 55 Appendix 1 4 Hand shake sacado li ais lalo anda 56 Appendix 1 5 CSV ao le A eee ae a A A alia Bead ae eal a 57 Appendix 1 6 Automatic Communication Startup Setting lt oooo ooo 57 Appendix 1 7 Protect the MX Sheet Setting lt lt ooo ooo 58 Appe
20. 12 06 29 Fri 15 21 49 est e1000021 Communication error has occurred in the open close 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 y 4 linformation 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 99 Bumes Boj sou g xipuaddy J89US XN JO SUONDUNY njasN xIpuaddy REVISIONS The manual number is written at the bottom left of the back cover Print date Jul 2012 SH 081081ENG A First edition edition Japanese Manual Version SH 081079 A This manual confers no industrial 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 2012 MITSUBISHI ELECTRIC CORPORATION 60 MX Sheet Version 2 Operating Manual Introduction SW2DNC SHEET O NY E 13JU74 SH NA 081081ENG A 1207 KWIX a MITSUBISHI ELECTRIC CORPORATION HEAD OFFICE TOKYO BUILDING 2 7 3 MARUNOUCHI CHIYODA KU TOKYO 100 8310 JAPAN NAGOYA WORKS 1
21. 935653131 Fax 34 935891579 MITSUBISHI ELECTRIC EUROPE B V UK UK Branch Travellers Lane UK Hatfield Herts AL10 8XB Phone 44 0 1707 27 6100 Fax 44 0 1707 27 86 95 MITSUBISHI ELECTRIC CORPORATION Office Tower Z 14 F 8 12 1 chome Harumi Chuo Ku Tokyo 104 6212 Phone 81 3 622 160 60 Fax 81 3 622 160 75 MITSUBISHI ELECTRIC AUTOMATION Inc 500 Corporate Woods Parkway Vernon Hills IL 60061 Phone 1 847 478 21 00 Fax 1 847 478 22 53 EUROPE FRANCE IRELAND ITALY POLAND RUSSIA SPAIN JAPAN USA MITSUBISHI ELECTRIC me GEVA Wiener Stra e 89 AT 2500 Baden Phone 43 0 2252 85 55 20 Fax 43 0 2252 488 60 TECHNIKON Oktyabrskaya 19 Off 705 BY 220030 Minsk Phone 375 0 17 210 46 26 Fax 375 0 17 210 46 26 ESCO DRIVES 8 AUTOMATION Culliganlaan 3 BE 1831 Diegem Phone 32 0 2 717 64 30 Fax 32 0 2 717 64 31 Koning amp Hartman b v Woluwelaan 31 BE 1800 Vilvoorde Phone 32 0 2 257 02 40 Fax 32 0 2 257 02 49 INEA RBT d o o BOSNIA AND HERZEGOVINA Aleja Lipa 56 BA 71000 Sarajevo Phone 387 0 33 921 164 Fax 387 0 33 524 539 AKHNATON 4 Andrei Ljapchev Blvd PO Box 21 BG 1756 Sofia Phone 359 0 2 817 6000 Fax 359 0 2 97 44 06 1 INEA RBT d o o Losinjska 4 a HR 10000 Zagreb Phone 385 0 1 36 940 01 02 03 Fax 385 0 1 36 940 03 AutoCont C S s r o Technologick 374 6 CZ 708
22. HI 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 contact the Mitsubishi representa
23. MX Sheet Version 2 MITSUBISHI Introduction y S WwW i sr rogramming Mb intenance MELSOFT Integrated FA Software SW2DNC SHEET E SAFETY PRECAUTIONSO 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 AX CAUTION NWARNING Indicates that incorrect handling may cause hazardous conditions resulting in death or severe injury Indicates that incorrect handling may cause hazardous conditions N CAUTION resulting in minor or moderate injury or property damage Under some circumstances failure to observe the precautions given under AN 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 O 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 operates safely Furthermore for th
24. OK Cancel Apply Optional Settings Notset Setalready lt 7 To the next page 1 2 Saving the Excel book Start Excel and save the Excel book Specifying 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 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 lt lt Access Data gt gt tab e Use Monitor Cell Area Name Monitor function e Cell Area B2 F2 Cell Display Direction Left to Right From the previous page Use Access Data Operation Interval Device Trigger Handshake CS Logging Logical Station Number f1 QOBUDHCPU_USB gt Communication Settings Device Data Type Value Enel Zoom No of cells Dev points In unit Yp haracters f P pee vf sor 2 ee ee aes we 5 IR 35 la Cell Area Name Logical Sta Operation Interval Device Trigger Handshake CSY Logging Mandatory Settings Notset Setalready OK Cancel Apply Optional Settings Notset Setalready Y Set the Operation Interval Operation Daily C Weekly day C Monthly Day a E a E C sanesaa v E E Operation Regular interval Minutely mE
25. S Logging Logical Station Number fi QOBUDHCPU_USB No of characters Device Data Type Logical Sta Operation Interval Device Trigger Handshake CSY Logging Cell Area Name Use Mandatory Settings Notset Setalready Optional Settings Notset Setalready OK Cancel Apply To the next page 36 12 Checking the settings Check if the logical station number settings displayed on the lt lt Target setting gt gt tab of the Communication Setup Utility screen are correct After checking select the lt lt Connection test gt gt tab 13 Connection test Click the Test button to check that the programmable controller and personal computer are normally communicating After confirmation click the button to close the communication setup utility An error message is displayed if they are not communicating normally Check the error definition and remove the error 14 Setting the lt lt Access Data gt gt tab 4 2 Set the device to be logged as follows After setting click the lt lt Operation time gt gt tab e Logical Station Number 1 e Device DO e Data type 16bit integer e Value DEC e Zoom 1 e No of cells 2 0 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 CHAPTER 6 OPERATING MX Sheet From the previous page
26. 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 gt Page 24 Section 3 1 4 4998y49 UOne e sul ELE 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 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 rai 7 Home eee Calibri Ju Clipboard 2 LA Save Gal Save As ES Open Sif Close Recent New Print Save amp Send Help EJ Exit lt 7 To the next page 24 Start Excel and click the lt lt File gt gt tab Select Option CHAPTER 3 INSTALLATION AND UNINSTALLATION From the previous page SS ET me 3 Excel Options screen is displayed 3 View and manage Microsoft Office Add ins mt Select Add Ins and select Excel Add Ins from Proofing Add ins Save Name Location Type A a TP eer Active Application Add ins M g d th l k th b tt Language o on Acrobat PDFMaker Office COM Addin Ci ffice PDFMOfficeAddin dll COM Add in anage j an en Clic e utton Advanced Team Foundation Add in CA mblies TFSOfficeAd
27. UONDUNY njasN XIpuaddy 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 JV Enable check setting data Set the password Password optional El 5 Cell Settings Logging function Read only Use Access Data Operation Interval Device Trigger Handshake CSY Logging Use Logging Cell Area Name Logging function Cell Area E12 H13 Set the Color of Grid line J Set the Color for Filling JV Clear cell area at the start of communication New data location Last Line e Display Contents Add title V Add date and time details MX Sheet setting becomes unchangeable Operation when cell is full MX She VP Because the MX Sheet setting is protected 47 The contents of settings cannot be saved _ Cell Area 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 Setalready OK Cancel Apply Optional Settings Notset 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 c
28. Use Logging e Cell Area Name Logging function e Cell Area B2 G11 e New data location Last Line e Display Contents Add date and time details e Operation when cell is full To scroll CHAPTER 6 OPERATING MX Sheet From the previous page Cell Settings Logging function 5 Setting the logical station number on the lt lt Access Data gt gt tab Click the communication Settings button to start the communication setup utility for setting the logical station Logical Station Number w Communication Settings o j No of cells Dev points In unit number When the following screen is displayed click the button A i Do you execute programs as an administrator Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CSY Logging To change the communication settings select Yes When No is selected The communication settings cannot be changed Mandatory Settings Notset Setalready OK Cancel Apply Optional Settings Notset Setalready When logging on without administrator authority the password input screen is displayed as follows lt Windows 7 gt lt Windows Vista gt e 2 User Account Control Ls a User Account Control sz DI co Don t run the program unless you know where it s from or you ve used it before Program name ActComm exe Verified publisher Unknown i ActComm exe m Unidentified Publisher
29. VAKIA SLOVAKIA SLOVENIA SWEDEN SWITZERLAND UKRAINE TOO Kazpromavtomatika KAZAKHSTAN Ul Zhambyla 28 KAZ 100017 Karaganda Phone 7 7212 50 1000 Fax 7 7212 50 1150 MIDDLE EAST REPRESENTATIVES I C SYSTEMS LTD EGYPT 23 Al Saad Al Alee St EG Sarayat Maadi Cairo Phone 20 0 2 235 98 548 Fax 20 0 2 235 96 625 ILAN amp GAVISH Ltd 24 Shenkar St Kiryat Arie IL 49001 Petah Tiqva Phone 972 0 3 922 18 24 Fax 972 0 3 924 0761 GIRIT CELADON LTD 12 H aomanut Street IL 42505 Netanya Phone 972 0 9 863 39 80 Fax 972 0 9 885 24 30 CEG INTERNATIONAL Cebaco Center Block A Autostrade DORA Lebanon Beirut Phone 961 0 1 240 430 Fax 961 0 1 240 438 AFRICAN REPRESENTATIVE CBI Ltd SOUTH AFRICA Private Bag 2016 ZA 1600 Isando Phone 27 0 11 977 0770 Fax 27 0 11 977 0761 ISRAEL ISRAEL LEBANON Mitsubishi Electric Europe B V FA European Business Group Gothaer Stra e 8 D 40880 Ratingen Germany FACTORY AUTOMATION Tel 49 0 2102 4860 Fax 49 0 2102 4861120 info mitsubishi automation com www mitsubishi automation com
30. a Name Use Logical Sta Operation Interval Device Trigger Handshake CSY Logging Logging function Logging 1 Q06UDH Settings No settings No settings No settings as _ O O a gt Mandatory Settings Notset Setalready OK Cancel pp Optional Settings Notset Setalready ld I e 1 gt BookLosx 17 Checking the settings Home Insert Pagelayout Formulas Di crec 30 E SSeS Check if the settings from step 1 to 16 are correct by Cell Setting L g Automatic Save Settings using the 1 shot communication function of MX Sheet Automatic Print Setting O m an Perform 1 shot communication in the following procedure Start Communication B AAA 1 Select the lt lt Add Ins gt gt tab gt MX Sheet gt 1Shot Communication Shot Communication 2 As the 1Shot Communication screen is displayed CollArea Name A 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 Es To the next page 3 From the previous page lt Before adjustment gt A G D E E G H bie H ad cad um as o ojo lt After adjustment gt A MU e D E F G H bie BB jojo u a Jas v po BookLxlsx Microsoft Excel Insert Page Layout Formulas Data Review View Add Ins Jeg pap FA a a 5 28 Thu 20 41 07 Cell Setting L
31. allation In such a case close all applications and install EnvMEL lt Installation of EnvMEL gt Execute SETUP EXE in the EnvMEL folder within the product CD ROM After executing SETUP EXE install the product When user account control is enabled the following screen is displayed Click the button or Allow lt Windows 7 gt lt Windows Vista gt By User Account Control User Account Control Don t run the program unless you know where it s from or you ve used it before Program name SETUP EXE Publisher Unknown z SETUP EXE File origin CD DVD drive Unidentified Publisher Cancel See SS No I don t know where this program is from or what it s for 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 After executing the exe file reinstall the product If this product is not installed properly at this time restart the personal computer b The Program Compatibility Assistant screen may be displayed after installation Select This program installed correctly and restart the personal computer 5 gt Program Compatibility Assistant a 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 S
32. blishers you trust How can I decide which device software is safe to install Always trust software from MITSUBISHI ELECTRIC Would you like to install this device software Name MITSUBISHI ELECTRIC CORPORATION Universa IT Publisher MITSUBISHI ELECTRIC CORPORATION CORPORATION Always trust software from MITSUBISHI ELECTRIC Y You should only install driver software from publishers you trust How can decide which device software is safe to install lt 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 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 software vendor for software that has passed Windows Logo testing Continue Anyway STOP Installation Hardware Installation The software you are installing for this hardware MITSUBISHI 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
33. d in dll COM Add in Visual Studio Tools for Office Design Time Adaptor for Excel C x86 VSTOExcelAdaptor dll COM Add in cinc lt Microsoft Excel 2003 gt Quick Access Toolbar Analysis ToolPak CA raniAnalysisANALYS32 XLL Excel Add in mams Analysis ToolPak VBA C nyAnalysis VATPVBAEN XLAM Excel Add in Custom XML Data Ci ffice Office 14 0FFRHD DLL Document Inspector ree pate 10 caso Aton Select Tool gt Add Ins from the menu bar to display Trust Center Euro Currency Tools CA 4 Library EUROTOOL XLAM Excel Add in Financial Symbol XML CA hared Smart Tag MOFL DLL Action Headers and Footers Ci ffice Office 14 0FFRHD DLL Document Inspector Hidden Rows and Columns CiufficerOfficelMOFFRHD DLL Document Inspector the Ad d ns screen Hidden Worksheets Ci ffice Office 144 0FFRHD DLL Document Inspector Invisible Content CA ffice Officel4 OFFRHD DLL Document Inspector Microsoft Actions Pane 3 XML Expansion Pack Solver Add in Cira nASOLVERISOLVERXLAM Excel Add in lt Microsoft Excel 2007 gt Document Related Add ins No Document Related Add ins E L i Select the Option button and click the Publisher Adobe Systems Incorporated Compatibility No compatibility information available Location C Program FilestAdobeYAcrobat 10 0 PDFMaker Office PDFMOfficeAddin dll b u tto n Description Acrobat PDFMaker Office COM Addin Manage Saar Sirs Cance
34. e Min JV Set the Device trigger A a Communication Logical Station Number fi QOBUDHCPU_USB gt Settings Bit Device Device YO Condition when ON y Word Device the bit 0 15 7 Clear cell area after automatic save Specify the cell area name aa r File name to save C WisersiA4dminiDocumentstauto xlsx Browse Specify the sheet name Sheet1 gt 4 Add date and time to File name C Add sequential number to File name ooo gt 999 Fix the File name 2 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 Line 1 Lot completion Selected e Automatic Save Name e Set the Device trigger e Logical Station Number 1 Bit device Selected e Device 2 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 E 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
35. e following message is displayed after the installation amp 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 E 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 x 4d 0 0 gt Bookl Microsoft Excel Calibri r lt 3 Conditional Formatting 3 Insert gt Be 3 Ea 43 Format as Table J Delete e Z T b Paste com a m Sort amp Find amp a er wees A 0 0 E Cell Styles Bj Format 27 Filter Select Cells Editing Clipboard G a Styles 200 O02 O if 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 N m eee 52 Add in registration was not performed D D 4 VBA might not be installed D D Please register the add in manually from Excel after installing VBA u o O 5 19 20 From the previous page lt The screen of Windows Vista and Windows 7 gt Es Would you like to install this device software Name Jungo Jungo Mas Publisher MITSUBISHI ELECTRIC CORPORATION CORPORATION Y You should only install driver software from pu
36. e 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 CAUTION O 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 CONDITIONS OF USE FOR THE PRODUCTO 1 Mitsubishi programmable controller the PRODUCT shall be used in conditions N 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 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 MITSUBIS
37. ed then an add in is installed the following error 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 e Before installing MX Sheet close any other applications running on Windows e 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 e When installing MX Sheet log on as a user with the Administrator authority e For the required personal computer operating environment to install MX Sheet refer to the following chapter gt Page 11 CHAPTER 2 UOHE EJSU pE jasys XW Buljjeysul a10jog p P E 13 14 2 Security Setting of Excel The following explains the setting procedure of required Trust Center whe
38. ersion English version Programmable controller CPU QO6UDHCPU USB cable MR J3USBCBL3M Printer Printer compliant with the personal computer specifications 29 CHAPTER 5 MX Sheet OPERATION PROCEDURE This chapter explains the MX Sheet operation procedure Start Excel and save the Excel book a 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 000000000000000000000000000000000000000000000000000000000000000009090 30 CHAPTER 6 OPERATING MX Sheet 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 25 HD ESE Bookl Microsoft Excel o E 57
39. es 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 Device data C collection write Requesting device on the programmable controller side on the PC side Responding device on the programmable controller side 56 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 lo oy soy eol Simultaneous execution CSV file 2012 5 4 08 00 00 0 0 0 0 0 0 Save into CSV file 2012 5 4 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 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 Bul6Bo ASO G xipueddy 89US XN JO S
40. etup Launcher F Publisher InstallShield Software Corporation Location F EnvMEL SETUP EXE Reinstall using recommended settings O What settings are applied 21 uonejesul Z Le UOHE ESU pE 22 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 E7 SETUP EXE Properties 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 Help me choose the settings Compatibility mode E Run this program in compatibility mode for Windows XP Service Pack 3 Settings E Run in 256 colors E Run in 640 x 480 screen resolution E Disable visual themes F Disable desktop composition E Disable display scaling on hi Privilege Level E Run this program as an IIS Clear the check box Compatibility for all users If you have problems wijf this program and it worked correctly on an earlier version of Windows select the compatibility mode that matches that earfer version Compatibility Settings E Run in 256 colors E Run in 640 x 480 screen resolution E Disable visual themes E Disable desktop composition E Disable display scaling on
41. fault printer set within My Computer gt Printers is used to print the Excel spreadsheet when Automatic Print setting is selected D o gt a 3 D lt o TU 2 5 gt a Remark indicates the useful tip Remari coro oooonccocnonccnonocnconononnoncnnnncoronnnnacanonnos O The descriptions in this manual may be subject to change without prior notice e Symbols used in this manual The following shows the symbols used in this manual with descriptions and examples E MX Sheetloadsx Microsoft Excel Home Inset Page layout Formulas Data Review Wwiew Add Ins _ Ed 8 El Gi eee eee Cell Settings Data Operation Interval Device Trigger Handshake CS Logging Met Lise Logging Cell Area Mame Loganu faneto Cell Srea D1 2 Set the Color of Grid line Set the Color tor Filling 2 lf Clear cell area at the start of communication z 4 Mewy data location Last Line 5 Display Contents Add title W Add date and time details 6 z Operation when cell is full e To scroll i f Display from the beginning without clearing the cell area E f Display from the beginning after clearing the cell area a 10 E z EXA Pel S me 000 993 e Menunameonamenubar MX Sheet gt Cell Setting itemnameinascreen Operation when cell is full a L Keyboard key ER 0 C O TERMS This manual uses the terms listed in the following table unless othe
42. high DPI settings Privilege Level ia Run this program as an administrator ox J cms 1 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 E Show settings for all users 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 and the menu of MX Sheet are added When using Microsoft Excel 2003 MX Sheet is added to the menu bar x W9 e e Wels Booki Microsoft Excel El x Home Insert Pagelayout Formulas Data Review View Add Ins Team 0 DE ys Cell Setting L Automatic Save Setting K Automatic Print Setting O Ready 1 E MX Sheet icons and menu are displayed uoellesu pE Point If the Register add in is not selected on the Select add in register screen in step 7 Page 16
43. hu 20 41 32 si se 53 2012 06 28 Thu 20 41 37 6 6 6 Monitor Alarm summary function Comment display function Automatic save function Temperature within the normal range Excel book file Temperature over the upper limit HTML file CSV file Z Error log setting function Protect MX Sheet Create button function 2 z 5 setting function ER Kind Date Cell Area Name ErrorNo Contents n 2 Information 2012 06 29 Fri 15 21 47 0000000 Communication was started Protect MX Sheet setting Warning 2012 9 Fri 15 21 49 nic 50 of MXShBtnStart V Enable check setting data gt lt JSB wm Password optional Exit tart the IBM PC AT compatible D je 3 lt ErrorCode 1808502 Hex gt 5 EY r 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 Device data are accumulated as history 2012 06 28 Thu 20 41 07 2 a o ol ol 2012 06 28 Thu 20 53 24 el o ol a Al y po ls so y 2 Monitor function Page 39 Section 6 2 This function displays the device data collected from
44. ially available Microsoft Windows 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 SAGE TY FRECAUTIONS ree setae cae ite a ace acre erate pom ae A SUN E AAN Serena 1 CONDITIONS OF WSE FORTHE PRODUC Aisa o rel ald eee ee teres 2 INTRODUCTION ete ete Panini Ne o aN same aN Jae titan anys Mes Muay Ri Mena ON Jae teen Ue Ne 3 PRE EAT IAIN UAE ketenes A Say ts ot nee Aa tated en tous eters au Vere DE este yeas A coe 3 HOW TO READ THISMANYUAL wes ecw o deren pecan een mer wae gh 5 TERMS os Pa Rene fara ane 7 DEFINITIONS OF TERM Sis asa aera ete eae ae ee crue renee ny recta pie aan see aerate 8 CHAPTER 1 OVERVIEW 9 LT Waris MX Sheet iietra dae oe ede be ea ee bee eed 3 9
45. ication Select the lt lt Add Ins gt gt tab gt MX Sheet gt Start Communication to start communication As the message is displayed click the ves button 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 following items e Utility setting type Selected e Logical station number 1 Bulnes oneuwomny y 9 After completing the above settings click the button Specifying the monitor device Select the lt lt Device Batch gt gt tab of the PLC Monitor Utility screen and set the following items e Device YO After completing the settings click the _ Start monitor button 49 90 From the previous page sS Ri PLC Monitor Utility Menu Online Help Device Batch Buffer Memory Entry Device PP 20 000 00 0000 000 o o 30 0000 0000 0000 0000 o 40 0000 0000 0000 0000 o 50 0000 0000 0000 0000 o Ye 0000 0000 0000 0000 o Y 000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 YA 0000 000 o o Stop monitor YBO 0000 0000 0000 0000 d co 0000 0000 0000 0000 o w Monitor format Bitaword T YDO 0000 0000 0000 0000 0 Y YEO 0000 0000 0000 0000 o Display 16bit integer hd FO 000 0000 0000 0000 o Data format DEC y Bitorder
46. il DAT File gt 417 bytes Computer x e Setup bmp S PROCHECK dil z Bitmap image 393 KB Cu Network SETUP EXE SETUP INI CN Setup Launcher Jo Configuration settings InstallShield Software Corporation 79 bytes e setup lid INS File LID File 100 KB 49 bytes l SETUP EXE Date modified 6 8 2012 8 00 AM Date created 6 12 2012 9 19 AM F Application Size 58 5 KB Right click Start and select Explorer Click the drive in which the disk is inserted and double click SETUP EXE When user account control is enabled the following screen is displayed Click the button or Allow lt Windows 7 gt lt Windows Vista gt Y Show details Don t run the program unless you know where it s from or you ve used it before Program name SETUP EXE Publisher Unknown E 1 SETUP EXE File origin CD DVD drive Unidentified Publisher e Change when these notifications appear gt Cancel I don t know where this program is from or what it s for Allow Itrust this program I kn here it s from or I ve used it before f Y 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 MX Component If the message on the left is displayed click the Cancel button to uninstall MX Sheet then reinstall it If the message on the left is di
47. indows 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 Excel 2003 Microsoft Excel 2007 and Microsoft Excel 2010 32 bit version DEFINITIONS OF TERMS The following are the definitions of terms 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 0 1 Transmission speed Transmission control eee ee e ee ie all 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 onama a al a PTEE aa aol asl 2012 06 28 Thu 20 41 27 al a aajo a 2012 06 28 T
48. ins 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 METAL ES GG 2 Cell Setting MX Sheet gt Automatic Print Setting to display the Automatic Save Setting K g p Automatic Print Setting Automatic Print List screen aiia Es 2 Creating new automatic print conditions Enable Automatic Print Name End of communication Date time Device Trigger es Click the button to create new automatic print conditions Close inician A 3 Setting the automatic print conditions E Set the automatic print conditions as follows sa Daily C Weekly z C Monthly m E e Automatic Print Name Line 1 Daily report E mee et e Set the date and time Selected oO B e Operation day Daily A e Operation time Time table 17 00 Print Area Specify the sheet Sheet 1 and Sheet 3 After the settings click the ok button O E 1 Multiple spreadsheets can be selected To the next page 91 Bunulld oNeuWomny 9 92 From the previous page 4 Specifying the automatic print conditions Automatic Print Name End of communication Device Trigger Clear cell area Line 1 Dairy report No settings Settings No settings No settings The automatic ori nt name iS added to the list Check that the chec
49. is 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 xls GU gt Libraries Documents gt v Search Docum P Organize v Share with v New folder x We Favorites m3 Documents library E MZ Desktop Includes 2 locations D load 8 sis A auto20120629162902 xlsx HP MX SheetLoxlsx El Recent Pla Libraries Document Automatically saved Excel file a Music E Pictures F Videos 1 Computer a 2 items Bulnes onewojny y 9 47 2 Setting automatic save This section explains an Excel book automatic save setting procedure 1 Add Ins Cell Setting L Automatic Print Setting O 2 Automatic Save Name End of communication Device Trigger Clear cell area Save in F My Documents y e e Ely Name m Date modified MX SheetLxlsx 6 28 2012 6 47 PM Cancel File name Save as type MANTA a eed To the next page 48 3 Automatic Save Name Line 1 Lot completion Save at the end of communication Set the date and time Operation Daily C weekly TO Mo C Monthly day Alternate date when a date does not exist Last day of the current month X Operation Regular interval Hourly tim
50. it OK ee Y Complete Selecting Create Button Start Excel and specify the cell where the button is placed Select the lt lt Add Ins gt gt tab gt MX Sheet gt Create Button gt Start Communication Button The start communication button is placed in the specified cell position The display characters and character font of the created button can be changed For details refer to the following manual 11 MX Sheet Version 2 Operating Manual Starting communication Click the start communication button created in step 1 As the message is displayed click the ves button 53 uoyng Buisn Bunealo 99 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 Scrolling e Printing Excel spreadsheet e Saving Excel book The line operation ratio and other conditions can be checked easily by accumulating the alarm da
51. k box of Enable is selected click the close button to close the Automatic Print List screen Complete The automatic print setting is now completed Point 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 6 6 Creating Using button CHAPTER 6 OPERATING MX Sheet This section explains a convenient communication starting method by Create Button 1 Setting example Button type MX Sheet setting condition Start Communication button 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 MX SheetLxlsx Microsoft Excel 1 5 X i I Mes Home Insert Page Layout Formulas Data Review View Add Ins T mse PBR AA Cell Setting L Automatic Save Setting K Automatic Print Setting O Automatic Communication Startup Setting 4 Start Communication B 1Shot Communications Cut Cell Sreaf Copy Cell Area C Delete Cell Area D Change Sheet Name N Protect MX Sheet setting R End Communication Button E 1Shot Communication Button s Options D il EO 3 4 ME E 2 Communication will commence Is
52. l Add Ins Co Js 4 The Add ins screen is displayed Add Ins available La gt ok analysis TooPak VEA x Click the button Euro Currency Tools anani Solver Add in Browse Automation Analysis ToolPak Provides data analysis tools for statistical and engineering analysis 5 The Browse screen is displayed Browse OL Ji MELSOFT Sheet SrA s ww Select MXShMenu xla in File name and click the gt gt Organize v New folder gt fl E 7 z mD Microsoft Excel kams Gate moaned Ei Wi button lt a I Sample 10 12 2011 11 13 4M File folder y We Favorites E3 MxXShMenu xla 2 9 2011 7 38 PM Microsoft Excel Add In woe if 4 Cc HE Desktop EF MXShRibbon xlarn 10 9 2009 6 31 PM Microsoft Excel Add In MXShMenu xla IS stored into User specified folder v o ownloads jab gt i gt Sheet at installation o El o a 4 The installation destination folder is C Melsec Sheet if it is Documents not changed at installation a a Music n E Pictures EE videos A _ _ y 14 m b 9 File name MXShMenu xla v Add Ins y Analysis ToolPak Analysis ToolPak VBA Add In Lo 6 The Add Ins screen is displayed Euro Currency Tools Add Ins available Check that the MX Sheet check box is selected and RE Solver Addin click the button again Automation Install the add in that hides the
53. l Selected e Operation day Daily e Operation time Regular interval 5 seconds ejeg Bunun E9 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 46 From the previous page xx WHI gt MX SheetLxlsx Microsoft Excel 8 E Ph ias Mr amp He 5 dd E ES HA Home Insert Page Layout Formulas Data Review View Add Ins Tear Cell Setting L Automatic Save Setting K lj on Automatic Print Setting O Automatic Communication Startup Setting 4 Communication will commence Is it OK Complete Starting communication Select the lt lt Add Ins gt gt tab 5 gt MX Sheet gt Start Communication to start monitor As the message is displayed click the button Entering the written values Enter the values to be written to devices into the cell area specified in step 2 e Cell B2 1 value to be written to DO e Cell C2 2 value to be written to D1 e Cell D2 3 value to be written to D2 Check that the data on Excel are written to the programmable controller devices 10 Ending communication Select the lt lt Add Ins gt gt tab gt MX Sheet gt End Communication to end writing The Excel spreadsheet for write function is now completed CHAPTER 6 OPERATING MX Sheet 6 4 Automatic Saving Th
54. l Change lt Windows XP gt Select MX Sheet from the list of programs and click 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 Uninstall Change network 2 cB F Name Publisher or 1 MSXML 4 0 SP2 KB954430 Microsoft Corporation lm MSXML 4 0 SP2 KB973688 Et Developer2 EMX Component MX Sheet Trend Micro OfficeScan Client Trend Micro ES Visual Studio 2010 Tools for SQL Server Compact 3 5 Microsoft Corporation Web Deployment Tool the Change Remove Microsoft Corporation MITSUBISHI ELECTRIC When user account control is enabled the following screen is displayed Click the button or the button lt Windows 7 gt lt Windows Vista gt r User Account Control Microsoft Corporation El al m P T uoejjezsulUN ZS hh Do you want to allow the following program to make changes to this computer e Windows needs your permission to continue If you started this action continue Program name Uninstall or change an application E Uninstall or change an application K Verified publisher Microsoft Windows K y Microsoft Windows show detaiis Detaits User Account Control helps stop unauthorized changes to your computer Change when these notificatio
55. 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 T TETT 5129 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 k Microsoft Windows 7 Home Premium Operating System English version ds Microsoft Windows 7 Professional Operating System English version Microsoft Windows 7 Ultimate Operating System English version E Microsoft Windows 7 Enterprise Operating System English version p Required software Microsoft Excel 2003 English version Microsoft Excel 2007 English version gt or Microsoft Excel 2010 32 bit version English version MX Component MX Component Version 4 or later 1 Windows XP Professional 64 bit version and Windows Vista 64 bit version cannot be used 2 The following functions cannot be used If used this product may not operate normally Excel 4 e Acti
56. n using MX Sheet Operating procedure x H Home Insert lA Save Gal Save As BF Open Saf Close Recent New Print Save amp Send Help ECT EJ Exit To the next page 1 2 Select the lt lt File gt gt tab When using Microsoft Excel 2007 click the Office button Select Options When using Microsoft Excel 2007 click the E Eromen button CHAPTER 3 INSTALLATION AND UNINSTALLATION From the previous page 7 ae 3 Select Trust Center from the list on the General _ Y Help keep your documents safe and your computer secure and healthy a Finis left and click the Trust Center Settings button 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 Show the Microsoft Excel privacy statement Advanced Office com privacy statement Customer Experience Improvement Program Customize Ribbon Security 8 more Quick Access Toolbar Adi 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 Trust Center Settings aus E 4 Select Add ins from the list on
57. ndix 1 8 Erorlog Selina a A A A A AS o A 59 REVISION trad dr eo aca ene a rai ei aras la 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 describes the operating Automatic print condition Printed at 17 00 every day procedure of the function 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 Wild 9 is MX SheetLotox Microsoft Excel Selecting automatic save setting Er A AAA ed Start Excel and select the lt lt Add Ins gt gt tab gt Call Setting MX Sheet gt Automatic Print Setting to display the Atomatic Save Setting h LO nttomatic Print Sottino os k Automatic Save screen l MIA mm raan aime Cra Cas Creating new automatic print conditions Indicates the section O Click the button to create new automatic print of cu rrently open page Point P indicates conditions the particular attention Point If multiple printers are set within the personal computer the de
58. ngs Notset Setalready OK Cancel Apply Optional Settings Notset Setalready ings Write function Use Access Data Operation Interval Device Trigger Handshake JV Set the Operation Interval Operation Daily C Weekly 7 C Monthly Day a day T 7 7 y y i gt r ll as ne current month t y Last day of tr v pares Regular interval Minutely Hourly Time table HH wn ai Cell Area Name Logical Sta Operation Interval Device Trigger Handshake CSW Logging Write function Write 1 Q06UDH Settings No settings No settings Mandatory Settings Notset Setalready OK Cancel m Optional Settings Notset Setalready S To the next page 5 gg e a NE 6 7 CHAPTER 6 OPERATING MX Sheet Setting the lt lt Access Data gt gt tab Set the device to be written as follows After setting select the lt lt Operation Interval gt gt tab Logical Station Number 1 e Device DO e Data type 16bit integer e Value DEC e Zoom 1 e No of cells 2 3 For the logical station number setting method refer to the following section gt 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 lt lt Operation Interval gt gt tab Set the monitor operation interval as follows e Set the Operation Interva
59. ns appear 3 Click the button When not uninstalling MX Sheet click the No button to return to the preceding screen 1 Are you sure you want to completely remove MX Sheet and all of its SP components Components indicate the installed icons and files To the next page 2 From the previous page When the screen on the left is displayed uninstall is complete unlnstallShield will remove the software Mx Sheet from your computer Please wait while each of the following components is removed Shared program files 4 Cli ck the 3 Standard program files button to close the screen Folder items Program folders Program directories Program registry entries Complete CHAPTER 4 SYSTEM CONFIGURATION USED IN THIS MANUAL CHAPTER 4 SYSTEM CONFIGURATION USED IN THIS MANUAL This manual explains system configuration as follows d 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 3 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 v
60. ocuments Organize v New folder fay O Documents library Fe Favorites Includes 2 locations HE Desktop B Downloads El Recent Places a Name Date modified Type A Libraries E Documents d Music Filename MX Sheet xls 4 m r Save as type Excel Workbook xlsx Authors Add an author Tags Add a tag E Save Thumbnail gt seras 100 gt a a MX SheetLxlsx Microsoft Excel x H Wy OM Home Insert Pagelayout Formulas Data Review View Add Ins Tear PE al GS GE CB Menu Commands Custom Toolbars MX SheetLxlsx Microsoft Excel Home Insert Pagelayout Formulas Data Review View Add Ins Automatic Save Setting K Automatic Print Setting O Use Access Data Operation Interval Device Trigger Handshake Use Arite v Cell Area Name write function Cell Area B2 D2 Set the Color of Grid line Set the Color for Filling Clear cell area at the start of communication Let to Right ha Cell Display Direction Cell Area Name Logical Sta Operation Interval Device Trigger Handshake CSV Logging Mandatory Settings Notset Setalready OK Cancel Apply Optional Settings Notset lt Setalready S To the next page 1 Saving the Excel book Start Excel and save the Excel book 2 Specifying the cell area Drag the cell
61. ommunication 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 B E D E Kind Date Cell Area Name ErrorNo Contents y 2 Information 2012 06 29 Fri 15 21 47 00000000 Communication was started Warning 2012 06 29 Fri 15 21 49 est 21000021 Communication error has occurred in the open close of communication lt 00010003 Hex 01808502 Hex gt USB driver connect error Connection of the USB driver failed The corrective actionis 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 0000002 Communication was completed 2 Automatic Error Log sheet display change setting At error occurrence the Error Log sheet displayed can be automatically changed Communication error occurrence ME CRI OTB RCA ao CODINA ERIGIR CARRER ADA ESTE E Error Log sheet is displayed Automatic display change B E D E Kind JDate Cell Area Name ErrorNo Contents y 2 Information 2012 06 29 Fri 15 21 47 00000000 Communication was started Warning 20
62. rwise noted Term MX Sheet Personal computer PC CPU module MX Component Windows XP Windows Vista Windows 7 Excel 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 Professional Operating System English version Microsoft Windows 7 Ultimate Operating System English version and Microsoft Windows 7 Enterprise Operating System English version W
63. splayed install EnvMEL E Page 21 2 in this section After the operation is complete restart installation operation CHAPTER 3 INSTALLATION AND UNINSTALLATION From the previous page ys 2 Check that all applications is closed and click the OK There is a possibility for improper installation JO b utton A amp A if you execute without closing all the running applications Including If the applications are running close all running resident programs Ok applications 3 Starting 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 gt button Name Mitsubishi Company MITSUBISHI ELECTRIC Co 4 Check the registered name and company name Check if the registered content is correct and click the You have provided the following registration information Name Mitsubishi Yes button E MITSUBISHI ELECTRIC Co did In order to change the information click the No w w EAT TEE button to return to the previous screen N ls this registration information correct 50 a E Dm D o o J 5 Register the product ID Pl ter th duct ID of th duct j Please ind Erclatichaacian Enter the product ID and click the _ Next gt 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 pre
64. ta history Alarm data are accumulated as bit devices turn on off 2012 06 28 Thu 20 41 07 A A o ol 9 2012 06 28 Thu 20 53 24 vw e of of o po 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 withinthe normal range Temperature Temperature rise fall Temperature over the 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 gt Collecting Writing Collecting Writing device data device data KE H a H eS L l OFF Target functions Logging Monitor Write Alarm summary Comment display Automatic save Automatic print ejdsip juauuo z xipuaddy 1994yS XN JO SUONDUNY njasN xIpuaddy 99 Appendix 1 4 Handshake Setting a handshake between the programmable and personal computer ensur
65. tabs to Excel as Cancel instructed in step 6 and step 7 Mx Sheet MELSEC COMMUNICATION ADD IN MACRO 7 To the next page 25 From the previous page S G i MELSOFT Sheet 4p Search Sheet p 7 The Browse screen is displayed Select MXShRibbon xlam in File name and click the Organize v New folder v Fil a HE Desktop Name Date modified Type E Siz al ee ay ok oly de Downloads ENE button Di Sample 10 12 2011 11 13 4M File folder 5 Recent Places NS a a MxXShMenu xla 2 9 2011 7 38 PM Microsoft Excel Add In EJ MXShRibbon xlarn 10 9 2009 6 31 PM Microsoft Excel Add In Libraries f Ee Documents ad Music ls Pictures E Videos m JE Computer a Network v EAT 1 r File name MXShRibbon xlarn X Add Ins Madam ada ad M Add Ins available 8 The Add ins screen is displayed Batona n shoot adin D Check that Additional MX Sheet Add in is selected Analysis ToolPak VBA Euro Currency Tools and click the Lo button oan 2 R Cancel lt MX Sheet MELSEC COMMUNICATION ADD IN MACRO E AAA Book1 Microsoft Excel 9 Check that MX Sheet is added to the lt lt Add Ins gt gt Hame In lt art Dane ant Formulas Nata Reviews View Add Ins M A Thi L EN EM EN tab The icon buttons are also displayed The manual add in registra
66. that you stop this installation now and contact the hardware vendor for software that has passed Windows Logo testing Continue Anyway 1 STOP Installation Es 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 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 geeeeeeeecececesessssssseeseseceeeeesesossosssessssseseeeeeecesesesesssessssessseceeeeseeeeeeg AAA E AA 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 inst
67. the left Trusted Publishers Add ins and clear the items when they have the Require Application Add ins to be signed by Trusted Publisher Trusted Documents Disable notification for unsigned add ins code will remain disabled check marks a Disable all Application Add ins may impair functionality S ee 2 5 Select ActiveX Settings from the list on Trusted Publishers Trusted Locations ActiveX Settings for all Office Applications the left and select any item other than Trusted Locations Disable all controls without notification Prompt me before enabling Unsafe for Initialization UFI controls with additional restrictions and Safe for u D is a b e a CO ntro Is with O ut n otifi catio n u Pres Initialization SFI controls with minimal restrictions O Prompt me before enabling all controls with minimal restrictions Enable all controls without restrictions and without prompting not recommended potentially dangerous controls can run Trusted Documents mauv JELLY Protected View V Safe mode helps limit the control s access to your computer SS ER 6 Select Macro Settings from the list on the Trusted Publishers Macro Settings O os left and select Enable all macros not Disable all macros without notification Trusted Documents gt SS e _ STRATOS recommended potentially dangerous code 5 Add ins Disable all macros except digitally signed macros
68. the programmable controller in the cell area selected on an Excel spreadsheet a controller data are a 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 Personal computer PC AT compatible machine supporting the following operating systems CPU Refer to the table Operating systems and hardware requirements Required memory PC CPU module MELSEC Q series compatible PC CPU module CONTEC CO LTD product Available hard disk capacit IAE i Virtual memory available capacity is 512MB or
69. tion is complete Complete Point In case VBA is not installed when registering the add in MX Sheet cannot be used After installing VBA register the add in manually 26 CHAPTER 3 INSTALLATION AND UNINSTALLATION 3 2 Uninstallation This section explains MX Sheet unistallation Screens from Windows 7 are used except for different operations required in other operating systems Operating procedure 1 Select Start gt Control Panel gt Uninstall a program lt Windows XP gt Start gt Control Panel gt Add Remove Programs JQ g gt Control Panel v Adjust your computer s settings View by Category a System and Security Back up your computer Find and fix problems Appearance and Network and Internet ee Gi View network status and tasks g Personalization D User Accounts ia Change account type lt e Choose homegroup and sharing Change the theme options Change desktop background Adjust screen resolution 7 Hardware and Sound Clock L d ock Language an Region 3 View devices and printers Add a device Change keyboards or other input kal Programs methods Uninstall a program Change display language Bw Ease of Access Y Let Windows suggest settings Optimize visual display Get programs 2 Select MX Sheet from the list of programs and Q A gt Control Panel Programs Programs and Features 5 Control Panel Home select Uninstal
70. tive 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 ee Description lt Manual number model code gt MX Sheet Version 2 Operating Manual Explains the operation procedures setting and operation methods of lt SH 081080ENG 13JU73 gt MX Sheet Sold separately MX Component Version 4 Operating Manual Explains the setting and operation methods of each utility on MX lt SH 081084ENG 13JU75 gt 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 guarantee the commerc
71. vating the application with Windows compatible mode e Simplified user switch over e Remote desktop e Large font size Advanced setting of Display Properties e DPI setting other than 100 3 The following functions cannot be used e Windows XP Mode e Windows Touch 4 Excel spreadsheets created in the English environment are applicable to the English environment only cannot be used in the other environment 5 When using Microsoft Excel 2007 Microsoft Windows XP Service Pack 2 or later is required 6 When using Microsoft Excel 2010 32 bit version Microsoft Windows XP Service Pack 3 Microsoft Windows Vista Service Pack 1 or Microsoft Windows 7 or later is required Microsoft Excel 2010 64 bit version is not supported 11 12 Operating systems and hardware requirements Hardware requirements Operating system j cd CPU Memory Windows XP Windows Vista Intel 1GB or more Core 2 Duo 2GHz or higher is Windows 7 32 bit version recommended 2GB or more Windows 7 64 bit version Point O Considerations when using Microsoft Excel 2010 In order to use MX Sheet install Microsoft Excel 2010 32 bit version When installing MX Sheet on the personal computer where Microsoft Excel 2010 64 bit version is installed the following error message is displayed After MX Sheet is installed Microsoft Excel 2010 64 bit version is installed and start
72. vious page SS 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 Destination Folder CAMELSECA Browse 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 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 gt 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 Nest button For confirmation the message on the left is displayed Click the 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 th
73. wizard has finished collecting information Please Finish to build the logical station number Comment QOSUDHCPU_US3 Cancel Back Next gt D To the next page CHAPTER 6 OPERATING MX Sheet 8 Setting the personal computer side interface Set the following items and click the et button e PC side I F USB Time out 10000 9 Setting the programmable controller side interface Set the following items and click the e button e PLC side I F e CPU type CPU module QO6UDH 10 Selecting the communication path Set the following items and click the e button e Station type Host station e Multiple CPU None de _ O O a gt 11 Enter any word Q0O6UDHCPU_USB in this example and click the button 35 From the previous page sy Communication Setup Utility o 0 esa Menu Help Target setting List view Connection test Logical station number 1 Q06UDHCPU_USB SSS i PC IF USB CPU type QOBUDH Time out 10000 ms Multiple CPU None Exit x Communication Setup Utility Menu Help Target setting List view Connection test 4 Q06UDHCPU_USB Test Logical station number Communication diagnosis count Result Diagnosis count 0 Result CPU name Mean time of communication Cell Settings Logging function Use Access Data Operation Interval Device Trigger Handshake C

"user manual"

Contents

Download Pdf Manuals

Related Search

Related Contents

&quot;user manual&quot;

Contents

Download Pdf Manuals

Related Search

Related Contents

"user manual"