MX Sheet Version 1 Operating Manual (Introduction)
Contents
1. Create Button W Protect MX Sheet setting R Options D Setting Data Export x version Info V 15hot Communication Cell Area To the next page Check whether the settings in steps 1 to 7 are correct or not by using the 1 shot communication function of MX Sheet Make 1 shot communication in the following procedure 1 Choose MX Sheet 1 Shot Communication from the menu bar 2 As the 1 Shot Communication dialog box appears select the cell area name set in step 4 monitor function in this example as the Cell Area Name 3 Click to start 1 shot communication 6 OPERATING MX Sheet From the previous page MELSOFT TT 5 Staring communication Data Window Sheet M Help A Cell Setting L A automatic Save Setting k Automatic Print Setting O uen Automatic Communication Startup Setting Start Communication B 1Shot Communication S Cut Cell Area T Cell Area C Delete Cell Area D Change Sheet Name N Create Button W Protect MX Sheet settina R Options D Setting Data Export x Version Info V MX Sheet Communication will commence Is ik QE Choose MX Sheet Start Communication from the menu bar to start monitor As the confirmation dialog box appears click Yes 10 Ending communication MX Shee2. G H l J Save As gt i Print gt 2 Prepare d Send gt 7 Publish f ai Close 1 Excel Options Exit Excel 15 16 17 18 2 2 The Excel Options screen appears Select Add Ins and click the button Excel Options Popul i 2 iid 2 View and manage Microsoft Office add ins Formulas Add ins Name Additional MX Sheet Add in D MELSEC Sheet MXShRibbon xlam Excel Add in Analysis ToolPa analys32 xll Excel Add in Analysis ToolPak VBA atpvbaen xlam Excel Add in Conditional Sum Wizard sumif xlam Excel Add in Custom XML Data Office Officel2 OFFRHD DLL Document Inspector Euro Currency Tools eu m Excel Add in Headers and Footers rosoft Office Officel2 OFFRHD DLL Document Inspector Hidden Rows and Columns rosoft Office Officel2 OFFRHD DLL Document Inspector Hidden Worksheets A Document Inspector Toso Internet Assistant VBA B soft ice Offic Library HTML XLAM Excel Add in nvisible Content Office Officel2 OFFRHD DLL Document Inspector Lookup Wizard lookup xlam Excel Add in MX Sheet D MELSEC Sheet MXShMenu xla Excel Add in Solver Add in solver xlam Excel Add in Add in Additional MX Sheet Add in Publisher Location D MELSEC Sheet MXShRibbon xlam Description MELSEC COMMUNICATION ADD IN MACRO Manage Excel Add ins v _cancer_ 3 INSTALLATION AND UNINSTALLATION MELSOFT From t
3. menu bar to start logging E ja A Automatic Save B J U A s the confirmation dialog box appears click Yes Automatic Print Sekting a 9 pp Automatic Communication Startup Setkingr H 7 52 Stark B 15hat Communication 5 Cut Cell Area T Copy Cell Area c Paste Cell Area P Delete Cell Area D Change Sheet Create Button Frotect Sheet sekting R OptionsrI Setting Data version Infa V MX Sheet Communication will commence T Is ik QE To the next page 6 OPERATING MX Sheet From the previous page MELSOFT 20 Ending communication 28 19 Ac 28 22 42 28 27 4E 28 32 52 1 26 37 8 28 42 28 47 28 52 26 57 7E 27 02 82 MX Sheet M End Communication E 15hot Communication version Info Complete Choose MX Sheet End Communication from the menu bar to end logging The Excel sheet for logging function is now completed 6 OPERATING MX Sheet MELSOFT 6 2 Monitor This section provides an example of creating an Excel sheet using the monitor function 1 Creation example Set the following Excel sheet as instructed in 2 Microsoft Excel MX Sheet Access data DO to D4 are displayed in order from left to right 6 OPERATING MX Sheet MELSOFT
4. 3 INSTALLATION AND UNINSTALLATION This chapter explains the installation and uninstallation procedures of MX Sheet The screens used in this chapter are those of the Microsoft Windows XP Professional Operating System Though they differ slightly from those of the other OSs refer to and perform operations 3 1 Installation This section explains MX Sheet installation 3 1 1 Installation precautions 1 Precautions on the OS Log on as the user who has the Administrator attributes when any of the following OSs is used Microsoft Windows NT Workstation Operating System Version 4 0 Microsoft Windows 2000 Professional Operating System Microsoft Windows XP Professional Operating System Microsoft Windows XP Home Edition Operating System Microsoft Windows Vista Home Basic Operating System Microsoft Windows Vista Home Premium Operating System Microsoft Windows Vista Business Operating System Microsoft Windows Vista Ultimate Operating System Microsoft Windows Vista Enterprise Operating System 2 Software confirmation Make sure that the following software programs have been installed in the personal computer where MX Sheet will be installed MX Component Version 3 01B or later Microsoft Excel 2000 or later 3 Precautions on using Microsoft Excel 2007 Installing Visual Basic for Applications hereafter abbreviated as VBA is required for Microsoft Office 2007 If not installed the following error messag
5. MELSOFT 12 When making a restart make sure that the Yes want to restart my computer now checkbox is marked and then click OK When not making a restart mark the No will restart my computer later checkbox and click OK Note the following instructions when the installer is started from the hard disk drive of the personal computer for which Windows Vista has been installed If the Program Compatibility Assistant screen appears after the installation choose This program installed correctly If Reinstall using recommended settings is selected by mistake Windows XP SP2 compatibility mode is set automatically Disable the Windows XP SP2 compatibility mode by following the procedure described below and perform the reinstallation 1 Right click on the setup exe icon of the installation target in the Windows explorer and open the setup Properties screen 2 Select the Compatibility tab and click the Show settings for all users button 3 Uncheck the Run this program in compatibility mode for check box of compatibility mode in the Compatibility for all users tab and click the button 4 Click the button on the setup Properties screen setup Properties 2 Security Details Previous Versions General Compatibility i Digtal Signatures If you have problems with this program and it worked correctly or an earlier version of Windows select the com
6. AL 9 ara 10 B4 E CO RO Communication will commence Is ik OK APPENDICES MELSOFT APPENDICES Appendix 1 Useful Functions of MX Sheet In addition to the functions explained in this manual Chapter 6 MX Sheet has useful functions This section provides the outlines and brief explanations of the functions For more details refer to the MX Sheet Version 1 Operating Manual Appendix 1 1 Alarm summary The alarm summary function converts the ON OFF information into the corresponding alarm comment character strings and accumulates them on an Excel sheet as an alarm history The followings are available by specifying in advance when the alarm history reaches the last line Scrolling Printing Excel sheet Saving Excel book The line operation ratio and other conditions can be checked easily by accumulating the alarm data history 2002 07 31 Wed 16 57 30 ppm ac bit devices turn on off py APP 1 APP 1 APPENDICES MELSOFT Appendix 1 2 Comment display The comment display function converts a bit device value or word device value into the corresponding comment character strings and displays them on an Excel sheet A comment is displayed according to the change of device value In the following example the upper and lower limit values are set for a device so that the corresponding warning message will appear when the device value falls outside the range Temperature within the
7. Sheet settina R Options D 18 Setting Data Export X Version Info V Automatic Save List Enable Automatic Save Name End of communication Date time Device Trigger Clear cell area Automatic Save Automatic Save Name Line1 Lot completion Save at the end of communication Set the date and time Set the Device trigger Logical Station Number 4 CPU COM_ 02 Bit Device C Word Device Device yo Condition When ON Clear cell area after automatic save File name to save D Documents and Settings AdministratoriMy Documents auto xls Browse date and time to File name Add sequential number to File name C Fix the File name oo ess Cancel Save in My Documents ze a My Music Pictures Save as type Excel Book Cancel To the next page Communication Settings 1 Selecting automatic save setting 2 Start Excel and choose MX Sheet Automatic Save Setting from the menu bar to display the Automatic Save dialog box amp 2 Creating new automatic save conditions Create new automatic save conditions Click the Create New button 3 Setting the automatic save conditions Set the automatic save conditions as follows Automatic Save Name Line 1 Lot completion Set the Device trigger Check Logical Station Number a Bit device Check Device YO Condition When ON Add
8. MELSOFT Communication Setup Utility 315 3 1 3 Connection test Menu Help Target setting List view Connection test Logical station number 1 CPLI _ 02 Communication diagnosis count 5 Result Diagnosis count 0 Result CPU name Mean time of communication Logical Station Number 1 CPU COM G02H X mee n Word oe a 15 Cell Area Name Logical Sta Operation Interval Device Trigger Handshake CSV Logging Mandatory Settings Motset Setalready Apply Optional Settings Notset Setalready Cell Settings Logging iss access Dale OSS Set the Operation Interval Operation Daily C Weekly day Operation Regular interval 7 Minutely aE C Hourly Mime C Time table 2 B Logging Time zone Log Always C Log only during the specified time zone Cell Area Name Logical Sta Operation Interval Device Trigger Handshake CSV Logging Mandatory Settings Motset Setalready Optional Settings Notset Setalready To the next page Click to make sure that the PLC and personal computer are normally communicating After confirmation click to close the Communication Setup Utility An error message appears if they are not communicating normally Check the error definition and remove the error 14 Setting the Access Data gt gt tab Set the device of which data to be l
9. v To the next page 6 OPERATING MX Sheet From the previous page Cell Settings Cell Area Name Write function Cell Area BZD2 v Set the Color of Grid line m Set the Color for Filling _ Left to Right 5 2 Cell Display Direction Cell Area Name Logical Sta Operation Interval Device Trigger Handshake CSV Logging Mandatory Settings Motset Setalready Optional Settings Notset Setalready Cell Settings Write function Logical Station Number 1 CPU COM Q02H Cell Name Logical Sta Operation Interval Device Trigger Handshake CSV Logging Mandatory Settings Motset Setalready Optional Settings Notset Setalready Cancel Apply Cell Settings Write function Use Set the Operation Interval Operation Daily day C Weekly C Monthly r r rc Operation Regular interval Minutely Second 4 C Hourly Timetable time xdi E x OK Cancel Apply Cell Area Name Logical Sta Operation Interval Device Trigger Handshake CSV Logging Mandatory Settings Setalready Optional Settings Motset Setalready MELSOFT 4 Setting the lt lt Use gt gt tab Set the setting items of the lt lt Use gt gt tab as follows After setting click the Access Data tab Write Write function 2 02 Left to Righ
10. 1 5 CSV TOGGIFIG coats boc om hc coded APP 4 Appendix 1 6 Automatic Communication Startup APP 4 Appendix 1 7 Data conversion function sci dedu APP 5 Appendix 1 8 Protect MX Sheet App 6 ADBODOIDCTS ETTOP log Seting 7 Manuals The following manuals are relevant to this software package Refer to the table when ordering the manuals Relevant Manuals Manual Name Manual Number Model Code MX Sheet Version 1 Operating Manual SH 080348E Explains the operation procedures setting and operation methods of MX Sheet Sold separately 13JU35 MX Component Version 3 Operating Manual SH 0800271 Explains the setting and operation methods of each utility on MX Component Sold separately 134432 MX Component Version 3 Programming Manual SH 080272 Explains the programming procedures details and error codes for ACT control Sold separately 13JF66 Note The MX Sheet Version 1 Operating Manual is included on the CD ROM with the corresponding software package as a set Any of the manuals is available separately in printed form Please indicate its manual number model code in the above table when ordering the printed manual e We don t guarantee the commercially available Windows based software products that have been introduced in this manual e We hold the copyr
11. 2 Setting MX Sheet This section explains the procedure of creating an Excel sheet for monitor function 1 Saving the Excel book Save in E My Documents x Tools ry Music Start Excel and save the Excel book File name Sheet xls Save as type Microsoft Excel Workbook Microsoft Excel MX Sheet 2 Specifying the cell area File Edit View Insert Format Tools Data Window Sheet M Help Drag the cell B2 to F2 in this example on the left screen EN specify the cell area in which monitor data will be i displayed H 3 Displaying the Cell Setting dialog box mop Choose MX Sheet Cell Setting from the menu bar to Cell Settina L display the Cell Setting dialog box B A automatic Save Setting k Automatic Print Setting O GE Version Info V l To the next page 6 OPERATING MX Sheet From the previous page Cau ston 4 Setting the lt lt Use gt gt tab Set the setting items of the lt lt Use gt gt tab as follows After setting click the Access Data tab Monitor Cell Area Name Monitor function Cell Area B2 F2 v Set the Color of Grid line m Set the Color for Filling Cell Display Direction Left to Right Y U S e Cell Area Name Cell Area Cell Display Direction Cell Area Name Logical Sta O
12. PC side IF Serial Communication setting Connect port COM1 side Serial Time out 10000 Connect port COM1 Time out 10000 9 Setting the PLC side interface ee Make the following settings and click Next gt PLC side IF CPU module X Communication setting CPU type aoz PLC side I F CPU module Transmission speed 19200 bps CPU type QO2 H Conta LLLI Transmission speed 19200 Control DTR or RTS Control To the next page 6 OPERATING MX Sheet MELSOFT From the previous page Communication Setting Wizard Network 10 Selecting the communication path OL T EMB Make the following settings and click Next Station type Host station Multiple CPU e Multiple CPU None td 11 Enter any word CPU COM QO2H in this example and The Communication wizard has finished collecting cl ick Fi n IS h information Please Finish to build the logical station number Comment CPU COM Q02H E Communication Setup Utility 12 Check whether the logical station number settings or displayed on the lt lt Target setting gt gt tab of the Lacanin ouo 11 Communication Setup Utility are correct or not Serial AH After checking click the Connection test gt gt tab COM1 CPU type G 2 H 10000 ms Transmission speed 19200 bps Control DTR or RTS Multiple CPLI None To the next page 6 OPERATING MX Sheet From the previous page
13. Setting complete The automatic save setting is now completed 6 OPERATING MX Sheet 6 5 Automatic Print MELSOFT This section explains a setting procedure for automatically printing the whole Excel book or specified Excel sheets during MX Sheet operation 1 Setting example Automatic print condition Printed at 17 00 every day Print area Sheet 1 and Sheet are printed 2 Setting automatic print This section explains an Excel sheet automatic print setting procedure Microsoft Excel Book1 xls i File Edit View Insert Format Tools Data Window Sheet M Help 1 Selecting automatic print setting amp 6 Cell Setting L a 9 Start Excel and choose MX Sheet Automatic Print Meal 1 5 ty E ic Pri eaa e 103 i Setting on the menu bar to display the Automatic Print 2 2004 07714 Wed 16 31 38 dialog box EH 2004 07 14 Wed 16 31 43 1 2004 07 14 Wed 16 31 48 5 5 2004 07 14 Wed 16 31 53 kae aorta 6 2004 07 14 Wed 16 31 58 Cut Cell Area Sue ama e Bs f d 2004 07 14 Wed 16 32 13 z 7101 2004 07 14 Wed 16 32 18 N ces 2004 07 14 Wed 15 32 23 Change Sheet 1 13 Create Buttoni 4 Protect Mx Sheet setting R 5 Options I 18 Setting Data Export X 19 20 Version Info V Automatic Print List 2 Creating new automatic print condit
14. cad 3 1 SM EP etsi ntt UEM xp EH 3 2 Sar o Gossau iet Med a con a MM D pa tet ET ce cedat ov en evite ab oca ata 3 10 3 4 Manual add in er peperere rrr pe vae Eni Daa e evo a pee Ue Mines dus mend eu Es 3 11 MP SU MP LIS I cL EDEN DIM Dd 3 15 4 SYSTEM CONFIGURATION USED IN THIS MANUAL o Sheet OPERATION PROCEDURE o 1to5 2 6 OPERATING MX Sheet 6 1to 6 27 PS 6 1 OZ Vi eT Co 6 10 omen E EU o ae 6 15 D AUEOITIBUE 9 md au Doa UO can aas UM suas erate ida cvv sites elm ade ut ts id 6 20 COAVN a FM a 6 25 OI m 6 27 4 4 APPENDICES APP 1to APP 7 Appendix 1 Useful Functions of MX 5 APP 1 Appendix 1 1 Alarm SUMMAN sce irae bandied bec ea eee ee die canis APP 1 Appendix T2 Comment disBldVisn Set su epa M SE E E SLE APP 2 Appendix T 9 Device sauces onte APP 2 Appendix lA 5 eA a reget er eoe APP 3 ADDEDODC
15. date and time to File name Check 1 Refer to Section 6 1 for the logical station number setting method Set the file name to be saved automatically Clicking displays the Save As dialog box Specify any save place and file name File name Save as type auto xls Excel book xls After specifying the file name click Save After making the above settings click OK 6 OPERATING MX Sheet From the previous page Automatic Save List 4 Specifying the automatic save conditions Cee After making sure that the automatic save name has been added to the list and the Enable filed has a check mark click the Close button to close the Automatic save list 5 Starting communication s Data Window sheet M Help Choose MX Sheet Start Communication from the Sues 3 menu bar to start communication 1 m E A Automatic Save Sekking K 7 U A s the confirmation dialog box appears click Yes Automatic Print g pp 5 Automatic Communication Startup Setting A H 58 58 Start Commounicatiant B 59 03 54 59 08 FE 722 50 13 Bd 1Shot Cammunication S 29 18 Cut Cell Area T 59 23 4 Copy Cell Area C 59 25 ell Delete Cell Area D 29 43 94 Change Sheet Create Buttonit k Protect MX Sheet setting R Optionst T Setting Data Exporkr x Version Info tw MX S
16. install MX atu nce Loe ee ee after installation of this package S h eet d th en sta M X Co m po ne nt Install If the left message appears click Cancel N This package has already been installed There is a possibility For improper installation if you execute without uninstalling it u n sta M X S h eet a n d th e n rei n sta it If the left message appears operate as instructed Q Please instal this package after executing Update DCOMSS Exe from CD ROM in a of 2 When message appears at start of installation After the operation is complete restart installation operation Severe C3 This package is not in proper operating environment Please install this package after executing M pdate Axdist Exe from CD ROM 285956 If the left screen appears operate as instructed M TE Please ital tis package efter executing SErvMEL Setup Exe from CD ROM b of 2 When message appears at start of installation After the operation is complete restart installation operation To the next page 3 INSTALLATION AND UNINSTALLATION Install From the previous page There is a possibility For improper installation e if you execute without closing all the running applications Including resident programs Welcome User Information Welcome to the SWnD5 SHEET Setup program This program will install SWnD5 SHEET on your computer It is stron
17. normal range Temperature within the normal range Temperature Temperature rise fall Temperature over the upper limit Temperature below the lower limit Appendix 1 3 Device trigger The device trigger function sets the device condition for device data collection write and collects or writes the device data when the set device condition holds lt Collecting Writing device data while bit device is on Collecting Writing Collecting Writing device data device data 194 0 Li L OFF Target functions Logging Monitor Write Alarm summary Comment display gt Automatic save Automatic print APP 2 APP 2 APPENDICES MELSOFT Appendix 1 4 Handshake APP 3 Setting a handshake between the PLC and personal computer ensures the device data collection write The handshake function determines whether to send data or not based on the send request and receive response signals exchanged between the personal computer and PLC before data updating When handshake begins with PLC side request T D TY LER IIIT SSL II SS SLL ETS CY Y 2 Responding device on the PC side Device data C collection write Requesting device on the PLC side Requesting device on the PC side Responding device on the PLC side APP 3 APPENDICES MELSOFT Appendix 1 5 CSV logging The CSV logging function simultaneously dis
18. or not by using the 1 shot communication function of MX Sheet Automatic Print Sekting C C Automatic Communication Startup Setting H Make 1 shot communication in the following procedure Start Communication B 1 Choose MX Sheet 1 Shot Communication from A the menu bar 2 As the 1 Shot Communication dialog box appears select the cell area name set in step 4 logging function in this example as the Cell Area Name CUENTEN 3 Click to start 1 shot communication Create 15hot Communicationi 57 Cut Cell Areat T Copy Cell Greatly Delete Cell Area D Protect Sheet settingi Et Optionst Setting Data Expartix version Info fy 1Shot Communication Cell amp rea To the next page TERM What is 1 shot communication This function executes the function set to the selected cell area at any timing 6 OPERATING MX Sheet MELSOFT From the previous page Before adjustment 18 Adjusting the display After 1 shot communication 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 5 0 After adjustment 00 401 4E CO 19 Starting communication p De Slee Choose MX Sheet Start Communication from the
19. 002 English version Microsoft Excel 2003 English version or Microsoft Excel 2007 English version MX Component Component version 3 01B or later 1 A Pentium 300MHz processor or higher is recommended when using Windows XP and 1GHz processor or higher is recommended when using Windows Vista 2 This product does not work with a multiprocessor IBM PC AT compatible personal computer because the driver is not compatible with it 3 Service Pack 3 or more is needed when using Windows NT Workstation 4 0 4 128MB or more is recommended when using Windows XP and 1GB or more is recommended when using Windows Vista 5 40GB or more having 15GB free space at minimum is recommended for Windows Vista 6 Excel sheets created in the English environment can be used in the English environment only They cannot be used in the other environment 7 Windows XP Service Pack 2 or later is required for Microsoft Excel 2007 2 OPERATING ENVIRONMENT MELSOFT When Microsoft Windows XP or Windows Vista is used the following new functions cannot be used If any of the following new functions is used this product may not operate normally Start of application in Windows compatible mode Fast user switching Remote desktop Big fonts Details setting of Screen properties Additionally 64 bit OS is not available 2 OPERATING ENVIRONMENT MELSOFT MEMO 3 INSTALLATION AND UNINSTALLATION MELSOFT
20. 7E E Addition Generic Terms and Abbreviations Chapter 2 Section 3 1 1 Section 3 1 2 Section 3 1 3 Section 3 1 4 Section 3 2 May 2008 SH NA 080347E F Generic Terms and Abbreviations Chapter 2 Section 3 1 1 Section 3 1 2 Section 3 2 Japanese Manual Version SH 080345 F This manual confers no industrial property rights or any rights of any other kind nor does it confer any patent licenses Mitsubishi Electric Corporation cannot be held responsible for any problems involving industrial property rights which may occur as a result of using the contents noted in this manual 2002 MITSUBISHI ELECTRIC CORPORATION SOFTWARE USER REGISTRATION After agreeing to the terms of the Software License Agreement included in the package please access the MELFANSweb Home page http www MitsubishiElectric co jp melfansweb and make a software user registration User registration is free of charge You can also make a registration by faxing or mailing the Software Registration Card packed with the product 1 Software Registration You can make a software registration by accessing the MELFANSweb Home Page or faxing or mailing the Software Registration Card packed with the product After you have made a software registration we will register the user and send the Software registration confirmation together with the user ID The latest information of new product version up and other will be available b
21. MX Sheet Version 1 MITSUBISHI Introduction wu 2 rogramming IM intenance MELSOFT Integrated FA Software _ SW1D5C SHEET E e SAFETY PRECAUTIONS e Always read these instructions before using this equipment Before using this product please read this manual and the relevant manuals introduced in this manual carefully and pay full attention to safety to handle the product correctly The instructions given in this manual are concerned with this product For the safety instructions of the programmable controller system please read the CPU module user s manual In this manual the safety instructions are ranked as DANGER and CAUTION em Indicates that incorrect handling may cause hazardous conditions DANGER resulting in death or severe injury Indicates that incorrect handling may cause hazardous conditions resulting in medium or slight personal injury or physical damage a N CAUTION eae Cl Note that the CAUTION level may lead to serious consequences according to the circumstances Always follow the instructions of both levels because they are important to personal safety Please s
22. Microsoft Windows Vista Home Basic Operating System Microsoft Windows Vista Home Premium Operating System Windows Vista Microsoft Windows Vista Business Operating System Microsoft Windows Vista Ultimate Operating System and Microsoft Windows Vista Enterprise Operating System Generic term of Microsoft Windows XP Professional Operating System and Windows XP Microsoft Windows XP Home Edition Operating System Definitions of Terms The terms used in this manual have the following meanings and definitions 1 Logical station number A number assigned to the group of data that is integrated from the connection target information required for communication within the Communication Setup Utility Personal computer _ _ 1 c Connection target information on up to CPU to communicate with is combined into one data to which logical station number is assigned 2 1 shot communication This function executes the function set to the selected cell area at any timing MEMO A 8 1 OVERVIEW MELSOFT 1 OVERVIEW 1 1 What Is MX Sheet MX Sheet is a communication support software package that enables device data collection by simple
23. UBISHI ELECTRIC CORPORATION HEAD OFFICE TOKYO BUILDING 2 7 3 MARUNOUCHI CHIYODA KU TOKYO 100 8310 JAPAN NAGOYA WORKS 1 14 YADA MINAMI 5 CHOME HIGASHI KU NAGOYA JAPAN When exported from Japan this manual does not require application to the Ministry of Economy Trade and Industry for service transaction permission Specifications subject to change without notice
24. any of the following OSs MX Sheet remains displayed in the application list of Add or Remove Programs if uninstallation is completed normally After uninstallation is completed restart Add or Remove Programs and check whether MX Sheet has been removed from the application list Windows 98 Windows Me Windows NT Workstation 4 0 4 SYSTEM CONFIGURATION USED IN THIS MANUAL MELSOFT 4 SYSTEM CONFIGURATION USED IN THIS MANUAL This manual explains system configuration as follows A MX Component MX Sheet System Equipment Description Personal computer that satisfies the operating environment of MX Sheet Personal computer Refer to Chapter 2 for details Microsoft Windows XP Professional Operating System English version MX Sheet MX Sheet Version 1 Software MX Component Version 3 01B Microsoft Excel 2002 English version Printer Printer compliant with the personal computer specifications 4 SYSTEM CONFIGURATION USED IN THIS MANUAL MELSOFT MEMO 5 MX Sheet OPERATION PROCEDURE MELSOFT 5 MX Sheet OPERATION PROCEDURE This chapter explains the MX Sheet operation procedure Start Excel and save the Excel book Select the function to be used and make MX Sheet settings Logging function Monitor function Write function Alarm summary function Comment display function Automatic save function Automatic print function Start communication End communicatio
25. ave this manual in a convenient place so that you can refer to it and always forward it to the end user Design Instructions 4 DANGER e Build an interlock circuit outside the PLC system to ensure that the whole system always works safely when changing the data of the running PLC or controlling the PLC status from the personal computer In addition be sure to incorporate the corrective action into the system to deal with the communication error due to the poor cable connection while operating the PLC CPU online from the peripheral device Operating Precautions N CAUTION e Read the manual carefully and confirm the safety before connecting a personal computer with the running CPU module to perform the online operation especially forced output and operating status change Misoperation may cause the machine damage or accidents REVISIONS The manual number is given on the bottom left of the back cover Print Date Manual Number Aug 2002 SH NA 080347E A First edition Dec 2003 SH NA 080347E B Addition SOFTWARE USER REGISTRATION Correction Section 3 1 2 Aug 2004 SH NA 080347E C Addition oection 6 6 Appendix 1 8 Appendix 1 9 Correction Section 1 1 Section 1 2 Chapter 2 Section 3 1 1 Section 3 1 3 Section 6 1 Section 6 2 Section 6 3 Section 6 4 Section 6 5 Sep 2005 NA 080347E D Correction Chapter 2 Section 6 1 Section 6 2 Section 6 3 Oct 2007 NA 08034
26. e in Bit Device 2 Click Force After making the above settings click Close Monitor format Bit amp vord Host station Write to Device Bit device Close Ss Device YO Force OFF Toggle force Word device Buffer memory Device C Buffer memory Module start 1 0 HEX Address Setting value integer DEC Set PLC Monitor Utility fi 9 Checking the device status The YO device status has been changed as set in step 8 Device Check whether it has been changed or not YO Menu Online Help Device Batch Butter Memory Entry Device 8 After checking click and then 0000 0000 0000 0000 0000 0000 00020 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 Host station Monitor format Display Data format Bit order Stop monitor Bit amp Word 16bit integer DEC 0 6 OPERATING MX Sheet MELSOFT From the previous page rc 10 Checking the saved file O Sls pru The operation in step 8 activates the automatic save p setting function and saves the Excel book automatically p eer Start Explorer and check whether the file specified in step ig sr ite 3 has been saved correctly Other Paces After checking the file choose MX Sheet End Communication from the menu bar to end communication
27. e appears when add in is registered at MX Sheet installation and MX Sheet cannot be used Add in registration was not performed WEA might nat be installed Please register the add in manually From Excel after installing VBA 3 INSTALLATION AND UNINSTALLATION MELSOFT 3 1 2 Installation 1 Installing the product 1 Start Windows after powering on the personal computer SEE ian tears teeta 2 Start Explorer and click the drive in which the Aseh E Foes CD ROM has been inserted Address zi Double click SETUP exe xU NN To display Explorer right click Start and choose Explorer AI File and Folder Tasks Rename this file jy Move this file P Copy this file ae oa X Delete this fie d When user account control is enabled in Windows Vista the following screen appears m Click Allow User Account Control gt e An unidentified program wants access to your computer rp Don t run the program unless you know where it s from or you ve used it File before SETUP EXE Unidentified Publisher 1 gt Cancel I don t know where this program is from or what it s for Allow I trust this program I know where it s from I ve used it before Details User Account Control helps stop unauthorized changes to your computer If the left message appears click OK
28. e exe file and restarting the personal computer Execute the exe file on the corresponding operating system as follows dcom95 exe Microsoft Windows 98 Operating System Axdist exe Microsoft Windows NT Workstation Operating System Version 4 0 95 Axdist exe are in the Update folder on CD ROM 3 INSTALLATION AND UNINSTALLATION b Installing EnvMEL MELSOFT Execute Setup exe in the EnvMEL folder on this product CD ROM Install this product after executing the Setup exe When user account control is enabled in Windows Vista the following screen appears Click Allow User Account Control 4 An unidentified program wants access to your computer Don t run the program unless you know where it s from or you ve used it before 0 SETUP EXE LEH Unidentified Publisher Cancel I don t know where this program is from or what it s for Allow Itrust this program I know where it s from or I ve used it before Details User Account Control helps stop unauthorized changes to your computer After executing the above exe file install the product again If this product is not installed properly at this time reboot the personal computer When the following screen appears on Windows Vista regardless of the installation result choose This program installed correctly Do not choose Reinstall using recommended settin
29. ease enter the product ID of the product Please input in single byte English characters ooo lt Back Cancel Choose Destination Location 8 The setup will install SWnD5 SHEET in the following directory Click Next to install in this directory Click Browse and select the directory for installing in other directory Click Cancel for not installing Destination Folder C AMELSEC lt Back Next gt Cancel l To the next page MELSOFT 7 Register the product ID of the product Enter the product ID and click the Next The product ID is printed on the Software User Registration card opecify the installation destination folder If you do not change the destination folder click Next If you change the destination folder click and specify a new drive and folder The following screen appears in Windows Vista Click Install this driver software anyway This screen may appear in several times x Windows Security Windows can t verify the publisher of this driver software gt Don t install this driver software You should check your manufacturer s website for updated driver software for your device Install this driver software anyway Only install driver software obtained from your manufacturer s website or E disc Unsigned software from other sources may harm your computer or steal information i v See details The either of the following
30. een and click Uninstall Change When user account control is enabled in Windows Vista the following screen appears Click the button User Account Control e Windows needs your permission to continue If you started this action continue Uninstall or change an application Microsoft Windows v Details Continue User Account Control helps stop unauthorized changes to your computer 3 INSTALLATION AND UNINSTALLATION MELSOFT From the previous page Confirm File Deletion 3 The dialog asks if you really want to uninstall MX J Are you sure you want to completely remove Sheet and all of its components 9 heet for confi rm ation To uninstall it click Yes When not uninstalling it click Vo Clicking returns to the previous screen Components indicate the installed icons and files Remove Programs From Your Computer 4 When a message appears and shows that the files unlnstallS hield will remove the software M Sheet from your have been deleted Click computer Please wait while each of the following components is removed Be sure to restart the personal computer if some files Y Shared program files remain undeleted v Standard program files Folder items Program folders Program directories Program registry entries Uninstall successfully completed Complete When uninstallation is executed using
31. eration Interval gt gt tab Set the monitor operation interval Make the following settings Set the Operation Interval Check Operation day Daily Operation time Regular interval 5 seconds 6 OPERATING MX Sheet From the previous page Cell Settings Monitor fun E Device Trigger Handshake CSV Logging Set the Operation Interval Operation Daily C Weekly day C Monthly r rc r r Last day ofthe current monta z ore Regular interval Minutely excea C Hourly Time table Cell Area Use Logical Operation Interval Device Trigger Handshake CSV Logging Monitor function Monitor 1 CPU Settings No settings settings No settings Mandatory Settings Motset Setalready OK xS Optional Settings Notset Setalready MELSOFT 7 Applying the settings Click to enable the settings of the Cell Setting dialog box After clicking Apply check that the cell area has been registered as shown on the left screen and click OK l 8 Checking the settings 205 Data Window Sheet M Help 3m Cell Settina L 9G zB j Automatic Save Settina K Automatic Print Setting O Automatic Communication Startup Setting Start Communication B 1Shot Communication S Cut Cell Area T Copy Area C Delete Cell Area D Change Sheet
32. error log types to be output The error log types Information Warning Error to be output can be specified Setting for outputting all error log A B C D E 1 Kind Date Cell Area Name ErrorNo Contents 2 nformatior 2004 07 14 Wed 17 31 05 00000000 Communication was started Error 2004 07 14 Wed 17 31 06 Monitor function e1000009 The specified logical station number is not set The corrective action is as follows Create the logical station number after performing communication 3 setting Warning 2004 07 14 Wed 17 31 08 Logging function e1000021 Communication error has occurred in the open close of communication lt 00010003 01808406 gt Time out error Though the time out period had elapsed data could not be received The corrective action is as follows Review the time out value of the property Set it again on the communication settings utility Review the system e g PLC CPU module setting and cable status Retry the method Perform Close once and execute Open again Exit the program and restart the IBM PC AT compatible ErrorCode 180840b Hex Informatior 2004 07 14 Wed 17 31 40 00000002 Communication was completed 10 4 2 Automatic Error Log sheet display change setting At error occurrence the Error Log sheet displayed can be automatically changed L 44 LI ITF LL TR Communication error occurrence Erro
33. gly recommended that you exit all Windows programs before running this Setup program Click Cancel to quit Setup and then close any programs you have running Click Next to continue with the Setup program WARNING This program is protected by copyright law and international treaties Unauthorized reproduction or distribution of this program or any portion of it may result in severe civil and criminal penalties and will be prosecuted to the maximum extent possible under law Cancel your name below Y ou must also type the name of the company you work for Name Missi Company MITSUBISHI ELECTRIC Co lt Back Cancel Registration Confirmation You have provided the following registration information Mame Mibsubishi Company MITSUBISHI ELECTRIC Ca ls this registration information correct To the next page MELSOFT 3 As the left screen appears make sure that all applications have been closed and click the OK If the applications are running close all the running applications 4 Setup starts As the left screen appears read the information and click the Next gt 5 Enter the name and company name and then click the Next gt 6 Confirm the registered name and company name If they are correct click the Yes To make a change click the to return to the previous screen 3 INSTALLATION AND UNINSTALLATION From the previous page Input ProductiD Pl
34. gs because the installer installs an incorrect module 7 Program Compatibility Assistant This program might not have installed correctly If this program didn t install correctly try reinstalling using settings that are compatible with this version of Windows Program Setup Launcher Publisher InstallShield Software Corporation Location F EnvMEL SETUP EXE Reinstall using recommended settings Cancel 3 INSTALLATION AND UNINSTALLATION MELSOFT 3 1 3 Installation check Check whether MX Sheet has been installed normally or not as follows 1 Start Excel 2 If the MX Sheet item has been added to the menu bar MX Sheet has been installed normally lt Microsoft Excel 2003 or earlier Microsoft Excel 2007 File Edit View Insert Format Tools Data Window Sheet M Help ay e Review View Developer Add Ins Deka Cell Settina L Cell Setting L Automatic Save Setting K Automatic Print Setting O 4 gt M 1 Sheet2 p Ready 23 MX Sheet icons and menu are displayed MX Sheet icons and menu are displayed 1 If the following screen appears during installation MX Sheet is not registered to the menu bar Failed in registration of the Mx Sheet menu Please carry out add in registration manually in Excel 2 If the Register add in is not marked in the Select add in d
35. hRibbon xlam in File name on the Documents P MxshMenu xla Desktop displayed Browse screen and click the Ces button qc Computer My Network 3 Places Filename wxshRibbon xlam Files of type Add Ins xla lf 7 Only for Microsoft Excel 2007 confirm that Additional MX Sheet Add in Analysis ToolPak mer T erdien Sum Wer checkbox on the displayed Add Ins Internet Assistan i Dried dialog box is selected and click the Solver Add in button Additional Mx Sheet Add in MELSEC COMMUNICATION ADD IN MACRO 8 Make sure that MX Sheet has been added to the menu bar The icon buttons are also displayed This means manual add in registration is complete indow Sheet M Help amp z 211 Ma D T Aral 1 For Microsoft Excel 2007 the Add Ins tab is added on the ribbon and MX Sheet group and icons are added to it Automatic Save Setting K Automatic Print Setting O Version Info V 157 M 4 gt Sheet1 Sheet3 2 Ready Registration complete 3 INSTALLATION AND UNINSTALLATION MELSOFT 1 To manually register MKShMenu xla to add in in Microsoft Excel 2007 install VBA If not installed the following error message appears and MX Sheet canno
36. he previous page Add Ins 3 3 As the left screen appears click Browse Add Ins available Euro Currency Tools Internet Assistant Lookup Wizard Solver Add in Automation Provides Functions and interfaces For Financial and scientific data analysis Analysis ToolPak 4 Asthe left screen appears enter MXShMenu xla in v Tools v DES zie E MESI File name and click OK MXShMenu xla has been stored into User 1 specified folder Sheet at installation My Documents 1 The installation destination folder will be C Melsec Sheet if it has not been changed at installation Favorites The following screen appears in Microsoft Excel Files of type Add Ins Cancel 2007 Look in Sheet D O 8 Desktop ir MoShRibbon xam bum T xla xll 4 5 As the left screen appears make sure that the MX Add Ins available 2 puce Sheet checkbox is marked and click OK 1 pda a Conditional Sum Wizar cumaii To 2 For Microsoft Excel 2007 click the Browse button again and register add in that hides the Add Automation tabs to Excel by operations 6 and 7 Mx Sheet MELSEC COMMUNICATION ADD IN MACRO To the next page 3 INSTALLATION AND UNINSTALLATION MELSOFT From the previous page 6 Only for Microsoft Excel 2007 enter eer Ere MXS
37. heet Communication will commence Is it OK 6 Starting the PLC Monitor Utility D From the Start menu choose All Programs apum MELSOFT Application MX Component PLC Monitor Utility to start the PLC Monitor Utility As the Transfer setting dialog box appears make the following settings Utility setting type Check Logical station number 1 After making the above settings click OK Connect Retry Times 0 Cancel To the next page 6 OPERATING MX Sheet MELSOFT From the previous page PLC Monitor Utility TETTE 7 Specifying the monitor device Device Batch Buffer Memory Entry Device Choose the Device Batch tab of the PLC Monitor Utility and make the following setting Device YO After making the above settings click Start monitor Monitor format Bit amp vord Display 16bit integer Data format DEC Bit order F Host station 8 Writing to device Change the YO device status Device Double click the monitor display area of the lt lt Device yo Device Batch Butter Memory Entry Device IEEE Batch tab 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 0000 The Write to Device dialog box appears Forcibly turn on YO in the following procedure 0000 0000 0000 0000 0000 0000 0000 0000 0000 00200 f Display 16bit integer poce Coo ZZ 1 Type YO in Devic
38. heets automatically when the specified device is triggered at the specified time 6 Create button function refer to Section 6 6 This function executes each of the Start Communication End Communication and 1 Shot Communication functions by merely clicking the corresponding button created from Create Button 2 OPERATING ENVIRONMENT MELSOFT 2 OPERATING ENVIRONMENT The following table indicates the operating environment of MX Sheet IBM PC AT compatible Pentium 200MHz or higher IBM PC AT compatible personal computer installed with Computer personal applicable 05 computer Microsoft Windows 98 Operating System English version Microsoft Windows Millennium Edition Operating System English version Microsoft Windows NT Workstation Operating System Version 4 0 English version 3 Microsoft Windows 2000 Professional Operating System English version Microsoft Windows XP Professional Operating System English version Microsoft Windows XP Home Edition Operating System English version Microsoft Windows Vista Home Basic Operating System English version Microsoft Windows Vista Home Premium Operating System English version Microsoft Windows Vista Business Operating System English version Microsoft Windows Vista Ultimate Operating System English version or Microsoft Windows Vista Enterprise Operating System English version Microsoft Excel 2000 English version Microsoft Excel 2
39. his example on the left screen to specify the cell area in which logging data will be displayed l EN 5 Displaying the Cell Setting dialog box rmat Tools Data Window Mx Sheet M Help Tu a Choose MX Sheet Cell Setting from the menu bar to display the Cell Setting dialog box 1 2 Automatic Save Setting k Automatic Print Setting O SS Ss Version Info l To the next page 6 OPERATING MX Sheet MELSOFT From the aides page LICE c 4 Setting the lt lt Use gt gt tab Set the setting items of the lt lt Use gt gt tab as follows Cel Area nane 20009 tureton After setting click the lt lt Access Data gt gt tab Cell Area B2 G11 v Set the Color of Grid line m Set the Color for Filling m Clear cell area at the start of communication New data location Last Line Display Contents Add title Add date and time details Use Logging beginning without clearing the cell area Cell Area Name Logging function Display from the beginning after clearing the cell area Cell Area 2 G 1 1 hs i New data location Last Line Display Contents Add date and time details Operation when cell is full To scroll Mandatory Settings Motset Setalready Cancel Optional Settings Not Setalready ums 3 5 Setting the logical station number the lt lt Access Data tab Click Communication Set
40. ialog box in step 9 of Section 3 1 2 the MX Sheet menu will not be registered to the menu bar Register MX Sheet as an add in software manually after installation Refer to Section 3 1 4 for the manual add in registration method 3 INSTALLATION AND UNINSTALLATION 3 1 4 Manual add in registration MELSOFT MX Sheet menu will not be registered to Excel if Register add in is not marked in Select add in dialog in step 9 of Section 3 1 2 during installation Add in registration is required to use MX Sheet Register MX Sheet as an add in software in the following procedure Microsoft Excel Book1 Gs File Edit Insert Format Tools Data Window Help c4 ai E d d Spelling F7 Y p Error Checking Speech Share Workbook Track Changes Protection Online Collaboration Goal Seek Scenarios Formula Auditing Tools on the Web Customize Options To the next page Start Excel Choose Tools Add Ins from the menu bar to display the Add Ins dialog box 1 For Microsoft Excel 2007 follow 2 1 and 2 2 2 1 Select Office button Excel Options y H2 Booki Microsoft E E Recent Documents New Z A Y Reappl Sort Filter Y Text to 7 Open 2 Advanced Columns Sort amp Filter gt
41. ights of this software package e No part of this manual may be transcribed or duplicated in any form without prior permission by Mitsubishi Electric Corporation e We have attempted to cover all the revisions of software and hardware but this manual may not contain the latest revisions e We assume that one software package will be used on one personal computer e We permit the user to use this software package including this manual based on the Software License Agreement e We are not liable for consequences or influences due to this software package including this manual e he specifications of this software package and the descriptions in this manual may be altered in future without prior notice Generic Terms and Abbreviations Unless otherwise stated this manual uses the following abbreviations and terms for the explanation of MX Sheet Generic Term Abbreviation Generic product name for product types SW1D5C SHEET E and SW1D5C SHEET EA MX Sheet EA indicates a volume license product IBM PC AT compatible Abbreviation of the IBM PC AT or its compatible personal computer Abbreviation of the MELSEC Q series corresponding PC CPU module PC CPU modul spl CONTEC CO LTD Personal computer Generic term of PC CPU module and IBM PC AT compatible Personal computer Generic product name for product types SW3D5C ACT E and SW3D5C ACT EA MX Component EA indicates a volume license product Generic term of
42. ions Enable Automatic Print Name of communication Date time Device Trigger Clear cell area Automatic Print Automatic Print Name Line1 Daily report Print at the end of communication Set the date and time Operation Daily C Weekly day E ir up Operation Regular interval C Hourly time Set the Device trigger Clear cell area after automatic print Print Area 7 Entire workbook Specify the sheet Sheet Sheet2 Sheet3 Create new automatic print conditions Click the Create New button 3 Setting the automatic print conditions Set the automatic print conditions Set as indicated below c meme T E Automatic Print Name Line 1 Daily report Set the date and time Check Operation day Daily Operation time Time table 17 00 Print Area Specify the sheet Sheet 1 and Sheet 3 1 After making the above setting click OK ErrorLog 1 Multiple sheets can be specified opecify the corresponding sheet only 6 OPERATING MX Sheet MELSOFT From the previous page Automatic Print List E 4 Specifying the automatic print conditions TIU zw After making sure that the automatic print name has been added to the list and the Enable filed has a check mark click the Close button to close the Automatic print list l If multiple printers are set within the personal computer the default printer set within My Compu
43. lose on Exit the program Password optional lt ErrorCode 180941 Informatior 2004 07 14 Wed 19 45 13 00000002 Communication wi MX Sheet ESS STR RTI SES ETT LIZ IIIA UA ZI EAA EEE IEE 1 OVERVIEW MELSOFT 1 2 Functions Explained in This Manual This manual explains the following MX Sheet functions 1 Logging function refer to Section 6 1 This function accumulates the device data collected from the PLC as a history in the cell area selected on an Excel sheet 2002 07 31 Wed 16 32 36 2 1 o of ol ee he ee See oes ae Perry Device data are accumulated as history 2002 07 31 Wed 16 32 36 2 1 0 TCD 2002 07 31 Wed 16 32 46 127 ee o of ol e ee E e e E 2 Monitor function refer to Section 6 2 This function displays the device data collected from the PLC in the cell area selected on an Excel sheet 16 8 0 0 0 PLC CPU 3 Write function refer to Section 6 3 This function writes the values entered on an Excel sheet to PLC devices Values entered on Excel are written to PLC devices 4 Automatic save function refer to Section 6 4 This function saves the Excel book automatically when the specified device is triggered at the specified time 5 Automatic print function refer to Section 6 5 This function prints the Excel book or specified Excel s
44. m the Cell Setting L VL Err menu bar to start writing F Automatic Save 0 As the confirmation dialog box appears click Yes INE PNE Automatic Communication Startup Setting A Im 7 Start Communication B 1Shot Communication S Cut Cell Area T Cell Area C Delete Cell Area D Change Sheet Create Button W gt Protect Sheet setting R Options Setting Data Export X Version InFa V MX Sheet Communication will commence L Is ik QE To the next page 6 OPERATING MX Sheet MELSOFT From the previous page 9 Entering the written values Enter the values to be written to devices into the cell area specified in step 2 Cell B2 1 value to be written to DO Cell C2 2 value to be written to D1 Cell D2 3 value to be written to D2 Make sure that the data on Excel are written to the PLC devices 1 2 3 4 5 Sheet M 10 Ending communication Choose MX Sheet End Communication from the menu bar to end writing 21 End Cammunication E 1Shot Communicatiant5 version Info iY l Complete The Excel sheet for write function is now completed 6 OPERATING MX Sheet MELSOFT 6 4 Automatic Save This section explains a setting procedure for automatically saving the Excel book during MX Sheet operation 1 Setting e
45. me v chenge or EB Microsoft Office XP Professional with FrontPage Size 243 00MB Programs i9 MX Component E 3 MX Sheet Size 1 59MB cae Used rarely Add New Last Used On 7 12 2002 Programs To change this program or remove it From your computer click Change Remove ChangejRemove Add Remove Windows Components Close To the next page 1 Choose Add or Remove Programs from Control Panel and double click it To display Control Panel choose Start gt Control Panel When any of Windows 98 Windows NT Workstation 4 0 and Windows 2000 Professional is used choose Add or Remove Programs from Control Panel and double click it To display Control Panel choose Start gt Control Panel Chose Uninstall a program on the Control Panel in Windows Vista 2 Select MX Sheet and click Change Remove The left screen is that of Windows XP Professional The displayed screen varies depending on the OS Perform the following operations when any of Windows 98 Windows NT Workstation 4 0 Windows 2000 Professional or Windows Vista is used lt Windows 98 or Windows NT Workstation 4 0 gt a Click the Install and Remove tab b Select MX Sheet c Click Add Remove lt Windows 2000 Professional gt a Click Add or Remove Programs b Select MX Sheet c Click Change Remove lt Windows Vista gt Choose MX Component on the Uninstall or change a program scr
46. n Completion 1 Be sure to save the Excel book before making the MX Sheet settings MX Sheet cannot be set unless the Excel book is saved Refer to the Excel manual for Excel operation 5 MX Sheet OPERATION PROCEDURE MELSOFT MEMO 6 OPERATING MX Sheet MELSOFT 6 OPERATING MX Sheet This chapter explains the following functions with examples Reference Section Logging function Section 6 1 Monitor function Section 6 2 6 1 Logging This section provides an example of creating an Excel sheet using the logging function 1 Creation example Set the following Excel sheet as instructed in 2 Microsoft Excel MX Sheet xls Mx SheetiM 20040114 ved 20 41 10 2004 0714 20 41 1 20442714 Wed 20 41 1 2D D 42714 Wed 20 41 72 2004 7714 Wed 20 41 72 2004 7714 Wed 20 41 3 2D D 47714 Ved 20 41 3 2DD 42714 Wed 20 41 4 2047 14 Wed 20 41 4 2004 7714 Wed 20 41 5 UE are displayed DO to D4 contents are displayed in order from left to right 10 logging data are displayed The latest logging data is displayed on the last line Scrolled up in order 6 OPERATING MX Sheet MELSOFT 2 Setting MX Sheet This section explains the procedure of creating an Excel sheet for logging function 1 Saving the Excel book Save in E My Documents C Tools ally muse Start Excel and save the Excel book 2 Pictures 2 Specifying the cell area Drag the cell B2 to G11 in t
47. n dll Application Extension 77 30 02 PM Common 5 dll Application Extension 20 02 5 43 PM EL Cskp MXShEngn exe Application 7 30 02 6 06 PM DNaviPlus 5 hh eru dll Application Extension 7 16 02 11 02 AM EC DrvCommon T5 MXShMenu sla Microsoft Excel Add In 7727 02 3 51 PM HL Easysocket MXEhLltiLacs OCX File 7 30 02 6 08 PM i Gppw Uninstaller exe Application 7 30 02 6 09 Lit g EC 2 25 Sheet 1 abject s selected 256KB gl Computer HH hConY wv Convert the communication setting Converting communication setting of Ms Links ev Vv 3DsSF CSIKP E Ver or above to communication setting logical station number of Mx Component Progress w Convert the Ma Chart used in Excel book Converting cell setting tag file alarm summary file and comment file of hx Chart SvVs05F OLEX E or above to Mx Sheet cell setting Progress Excel Book DocumentsiLEXods Tag file The tag file name set in environment setting utility will be converted automatically Alarm summary file The alarm summary file name set in each cell settings will be converted automatically Comment file The comment file name set in each cell settings willbe converted automatically 000 APP 5 APP 5 APPENDICES MELSOFT Appendix 1 8 Protect MX Sheet setting The MX Sheet setting can be protected by a password The
48. ogged Make the following settings After setting click the Operation time gt gt tab Logical Station Number 1 Device DO Data type 16bit integer Value DEC Zoom 1 No of cells 25 15 Setting the lt lt Operation Interval gt gt tab Set the logging operation interval Make the following settings Set the Operation Interval Check Operation day Daily Operation time Regular interval 5b seconds Logging Time Zone Log Always 6 OPERATING MX Sheet MELSOFT From the previous page Cell Settings Logging function 16 Applying the settings Se Ep ge Click to enable the settings of the Cell Setting ee SEN dialog box After clicking Apply check that the cell area has been registered as shown on the left screen and click OK E Minutely d Hourly Minte Time table 2 EE Operation time Regular interval 5 s Logging Time zone Log Always C Log only during the specified time zone Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CSV Logging Logging function Logging 1 CPU CO Settings No settings settings No settings Mandatory Settings Setalready Optional Settings Notset Setalready l 17 Checking the settings ls Data Window Mx Sheet M Help Check whether the settings in steps 1 to 16 are correct 2 CA SR NN sons us d
49. out add in registration manually From Excel Refer to Section 3 1 4 for the manual MX Sheet add in registration method When registering add in in Microsoft Excel 2007 add in that hides the tabs is automatically registered to Excel On 3 M Booki Microsoft Excel aX Insert Page Layout Formulas Data Review View Calibri ij B ZZ UA Paste Developer Add Ins General 3 Conditional Formatting 5 aj dFormatas Table Delete Z EI zA eem Sort amp Find amp t gt Cell Styles Format 227 Filter Select Alignment Number Styles Cells Editing ay 3 INSTALLATION AND UNINSTALLATION MELSOFT If VBA is not installed when add in is registered in Microsoft Excel 2007 the following error message appears and MX Sheet cannot be used Register add in manually after installing VBA Add in registration was not performed might not be installed Please register the add in manually From Excel after installing From the previous page When user account control is enabled in Windows Vista the following screen appears Click Install this driver software anyway 4 Windows Security amp Windows can t verify the publisher of this driver software Don t install this driver software You should check your manufacturer s website for
50. patibility mode that setup Properties Compatibility for all users Compatibility mode f you have problems with this program and it worked correctly Run this program in compatibility mode for penis edades ich Ps HON ONES MISSE aoe za E on an earlier version of Windows select the compatibility mode that matches that earlier version Compatibility mode Settings V Run this program in compatibility mode for Run in 256 colors Run in 640 x 480 screen resolution wo Dad pen Uncheck the check box F Disable desktop composition Run in 256 colors Disable display scaling on high settings Run in 640 480 screen resolution Disable visual themes Privilege Level Disable desktop composition Run this program as an administrator x POSEE ESO E Disable display scaling on high DPI settings Privilege Level this program as an administrator OK Apply 3 INSTALLATION AND UNINSTALLATION MELSOFT 2 When message appears at start of installation When starting the installation of this product the This package is not in proper operating environment message appears disabling normal completion of installation In such a case close all applications and perform the a or b operation a Installing dcom95 exe or Axdist exe Execute dcom95 exe or Axdist exe provided for MX Sheet Install MX Sheet after executing th
51. peration Interval Device Trigger Handshake CSV Logging Mandatory Settings Motset Setalready Optional Settings Notset Setalready OK Cancel Apply Cell Settings Monitor function MELSOFT Monitor Monitor function 2 2 Left to Right 5 Setting the Access Data tab Set the device of which data to be monitored Make the following settings ume ser c 5 Logical Station Number After setting click the Operation Interval gt gt tab 1 Cell Area Name Logical Operation Interval Device Trigger Handshake CSV Logging Mandatory Settings Motset Setalready Cancel Apply Optional Settings Notset Setalready Cell Settings Monitor function Use Access Data operation Interval i Device Trigger Handshake CS Loggin Set the Operation Interval Operation Daily C Weekly day C Monthly r r r ik Regular interval C Minutely Second C Hourly C Time table 5 n Cell Area Name Logical Operation Interval Device Trigger Handshake CSV Logging Mandatory Settings Motset Setalready C Optional Settings Motsel Setalready Apply Device DO Data type 16bit integer Value DEC Zoom 1 No of cells zO 1 Refer to Section 6 1 for the logical station number setting method 6 Setting the lt lt Op
52. plays device data on an Excel sheet using the logging or monitor function and saves collected data as a CSV file Using a single CSV file enables long term data collection file Display on Excel sheet pd _ 40 50 60 Simultaneous execution CSV file 2002 05 04 08 00 00 0 0 0 0 0 0 Save into CSV file 2002 05 04 08 00 10 10 20 30 40 50 60 Appendix 1 6 Automatic Communication Startup Setting Automatic Communication Startup Setting automatically starts communication with the PLC when the Excel book where MX Sheet settings have been made is started This setting eliminates the need of selecting Start Communication from the MX Sheet menu APP 4 APP 4 APPENDICES MELSOFT Appendix 1 7 Data conversion function The data conversion function converts the communication settings of MX Links SW3D5F CSKP E and various settings of MX Chart SW3D5F OLEX E into the logical station number of MX Component and cell settings of MX Sheet respectively This function ensures efficient utilization of the conventional assets Starting method Explorer MELSEC Sheet MXComShConv exe Exploring Sheet Edt Go Favortes Toole Help EE D aja x Back Forward Up Cut Copy Paste Undo Delete Properties Views Address CAMELSECNSheet Folders E File Falder 131102 8 08 PM Act M LamShConv exe Application 30 02 6 05 EC 5 hCom
53. program less setting using Excel This manual explains the basic using methods of MX Sheet For details refer to the MX Sheet Version 1 Operating Manual Logging function monitor funciton Write function Automatic print function Logging Write D D2 D3 002 7 31 Wed 17 00 0 TIS 0 2 002 7 31 Wed 17 05 0 101 102 103 002 7 31 Wed 17 10 0 002 7 31 Wed 17 15 0 NINO h3 002 7 31 Wed 17 20 0 002 7 31 Wed 17 25 0 hJ 07 Co n2 24103101 co 2 gt 1002 Alarm summary function Comment display function Automatic save function 2002 07 31 Wed 16 57 30 Temperature within the normal range Temperature over the upper limit n 2002 07 31 Wed 16 57 3 Excel book file 3 2002 07 31 Wed 16 59 35 po abo HTML file CSV file Error log setting function Protect MX Sheet Create button function Kind Area Name ErrorNo Contents setting function Information 2004 07 14 Wed 19 45 03 00000000 Communication we Warming 2004 07 14 Wed 19 45 05 Logging function e1000021 Communication er lt 00010003 Hex 0 MXShBtnStart Time out error Though the time o The corrective acti Review the time o Set it again on the Cancel Review the syster Retry the method Perform C
54. r Log sheet is displayed Automatic display change A B C D 1 Kind Date Cell Area Name ErrorNo Contents 2 Informatior 2004 07 14 Wed 17 34 35 00000000 Communication was started Warning 2004 07 14 Wed 17 34 36 Logging function e1000021 Communication error has occurred in the open close of communication lt 00010003 01808406 gt Time out error Though the time out period had elapsed data could not be received The corrective action is as follows Review the time out value of the property Set it again on the communication settings utility Review the system e g PLC CPU module setting and cable status Retry the method Perform Close once and execute Open again Exit the program and restart the IBM PC AT compatible 3 zErrorCode 180840b Hex 3 Error log clear setting at communication start At the start of communication the error log can be cleared APP 7 APP 7 Microsoft Windows and Windows NT are registered trademarks of Microsoft Corporation in the United otates and other countries Pentium is a registered trademark of Intel Corporation in the United States and other countries Other company and product names herein are either trademarks of registered trademarks of their respective owners SPREAD Copyright C 1998 Far Point Technologies Inc SH NA 080347E F MX Sheet Version I Operating Manual Introduction MELS1 SHEET NY E 13JU34 SH NA 080347E F 0805 MEE MITS
55. screens may appear behind the Windows Security screen Then press the keys to bring it to the front Click on the following screens CAWindows temp wdreg exe Error Failed to install the INF file C Windows TEMP WINDRVR6 INF S67 Error updating the driver hwid WINDRVR6 with the INF file The system cannot find the file specified CAWindows temp wdreg exe Error Failed trying to install the driver 3 INSTALLATION AND UNINSTALLATION MELSOFT From the previous page Select add in register 9 Register the MX Sheet to Excel as an add in software Do you want to register add in Sheet menu to Excel Mark the checkbox when registering an add in The checkbox is marked by default Click Next lt Back Cancel Warning For confirmation the left message appears Excel is started in order to carry out add in registration of the Mx Sheet menu to Excel CI ick OK 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 e make MX Sheet available register it to Excel as an add in software Normally register an add in software as instructed in step 9 If the Register add in checkbox is unmarked in step 9 the following message appears after installation Information 1 Add in registration of the Mx Sheet menu was not performed Please carry
56. t Use Cell Area Name Cell Area Cell Display Direction 5 Setting the Access Data tab Set the device where data will be written Make the following settings After setting click the Operation Interval gt gt tab Logical Station Number 1 Device DO Data type 16bit integer Value DEC Zoom 1 No of cells 1 Refer to Section 6 1 for the logical station number setting method 6 Setting the Operation Interval tab Set the write operation interval Make the following settings Check Daily Regular interval 5 seconds Set the Operation Interval Operation day Operation time 6 OPERATING MX Sheet MELSOFT From the previous page Cell Settings Write function 7 Applying the settings Click to enable the settings of the Cell Setting pedo Gom C Wet C Wow 5 dialog box After clicking Apply check that the cell area has been registered as shown on the left screen and click Operation Regular interval Minutely C Hourly TEA Timetable time 5 5 Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CSV Logging Write function Write 1 CPU CO Settings No settings settings Mandatory Settings Motset Setalready OK Cancel Optional Settings Notset Setalready l 8 Starting communication s Data Window Sheet M Help Choose MX Sheet Start Communication fro
57. t M End Communication E 1Shot Communication S Version Info V l Complete Choose MX Sheet End Communication from the menu bar to exit monitor After ending the communication delete the monitor data The Excel sheet for monitor function is now completed 6 OPERATING MX Sheet MELSOFT 6 3 Data Write This section provides an example of creating an Excel sheet using the write function 1 Creation example Set the following Excel sheet as instructed in 2 Microsoft Excel MX Sheet Ms Sheetr M Enter values to be written to DO D2 in order from left to right 6 OPERATING MX Sheet MELSOFT 2 Setting MX Sheet This section explains the procedure of creating an Excel sheet for monitor function 1 Saving the Excel book D My documents e6 amp C5 Ed Tos Bey musi Start Excel and save the Excel book 2 Specifying the cell area ig ea Drag the cell B2 to D2 in this example on the left screen hDcH OSS8I T LBA T to specify the cell area in which written data will be entered El ER 3 Displaying the Setting dialog box Data Window Sheet M Help Choose MX Sheet Cell Setting from the menu bar to lt d display the Cell Setting dialog box E Automatic Save Setting E fu Automatic Prink version InFo
58. t be used Repairs to MXShMenu xla e Excel was able to open the File by repairing or removing the 1 unreadable content This workbook has lost its project ActiveX controls and any other programmability related features Click to view log file listing repairs D ADOCUME 1lalLOCALS 11Templerror020720 01 2 To manually register MXShRibbon xlam to add in in Microsoft Excel 2007 install VBA If not installed the following error message appears and MX Sheet cannot be used Microsoft Office Excel Microsoft Office Excel cannot access the file D MELSEC Sheet MxShRibbon xlam There are several possible reasons The name or path does not exist is being used by another program The workbook you are trying to save has the same name as a currently open workbook 3 INSTALLATION AND UNINSTALLATION 3 2 Uninstallation MELSOFT This section explains MX Sheet unistallation amp Control Panel File Edit View Favorites Tools Help eae A Back d Search f Folders Address gt Control Panel vil Go 0 Add or Administrative Date and Time Display Folder Options Tools ograms cz A Z i wA See Also v i Mou ni Internet Keyboard s Network L Windows Update Options Connections Help and Support Taskbar and User Accounts Add or Remove Programs Currently installed programs Sort Na
59. ter Printers is used to print the Excel sheet when Automatic Print setting is selected 6 OPERATING MX Sheet MELSOFT 6 6 Using the Button This section explains a convenient communication starting method by Create Button 1 Setting example Button type Start Communication button MX Sheet setting condition Logging setting Refer to Section 6 1 1 The End Communication or 1 Shot Communication button is also available 2 Creating the button and starting communication The following describes a procedure from button creation to a communication start using the button T T Data Window Sheet M Help 1 h ng C reate B utto i 2 Bay t Cell Setting L 2 1 E an ae ye 188 58 8 Start Excel and specify the cell where the button will be i placed Choose MX Sheet Create Button Start Communication Button on the menu bar C C1 ER CON The Start Communication Button is placed in the specified cell position 2 The display characters and character font of the created button can be changed Refer to the MX Sheet Version 1 Operating Manual for details MXShBtnStart 2 Starting communication a File Edit View Insert Format Tools Data Window Sheet M Help gt mam Click the Start Communication Button created in Step 1 BEA
60. tings to start the Communication i Setup Utility for setting the logical station number No of cells EL Cell Area Name Logical Sta Operation Interval Device Trigger Handshake CSV Logging Mandatory Settings Motset Setalready Cancel Apply Optional Settings Notset Setalready Communication Setup Utility 6 Starting the Communication Setting Wizard Menu Help Target setting Lit view Connection test After starting the Communication Setup Utility click the Logical station number izard pue Target Setting gt gt tab and click Wizard What is logical station A number assigned to the group of data that is integrated from the connection target information required for communication within the Communication Setup Utility 6 OPERATING MX Sheet MELSOFT From the previous page Communication Setting Wizard Introduction 7 Setting the logical station number This Communication Setting Wizard will set the Enter 1 in Logical station number and click Next 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 m om Dn Communication Setting Wizard PC side 8 Setting the personal computer side interface Make the following settings and click Next
61. updated driver software for your device Install this driver software anyway Only install driver software obtained from your manufacturer s website or disc Unsigned software from other sources may harm your computer or steal information See details Information 10 The left screen appears when installation is complete Click OK 1 Completed the installation of this product Program Compatibility Assistant 11 When the left screen appears on Windows Vista regardless of the installation result choose This This program might not have installed correctly program installed correctly If this program didn t install correctly try reinstalling using settings that are compatible with this version of Windows a Ea une Der Do not choose Reinstall using recommended Publisher InstallShield Software Corporation Location F EnvMEL SETUP EXE settings because the installer installs an incorrect module If choose reinstall MX Sheet with following POINT on the next page Reinstall using recommended settings Cancel What settings applied To the next page 3 INSTALLATION AND UNINSTALLATION From the previous page Restarting Windows Setup has finished copying files to your computer Before you can use the program you must restart Windows or your computer Choose of the following options and click OF to finish setup
62. user settings can be made unchangeable Protect MX Sheet setting Set the password Password optional cn Cell Settings Read only CSV Logging Use Logging Cell Area Name Cell Area A2 Set the Color of Grid line Set the Color for Filling Clear cell area at the start of communication New data location Last Line Display Contents Add title Add date and time details MX Sheet setting becomes unchangeable Operation when cellis full To scroll C Display from the beginning without clearing the cell area C Display from the beginning after clearing the cell area Use Logical Operation Interval Device Trigger Handshake CS Logging Logging function Logging 1 006 115 Settings No settings No settings No settings Mandatory Settings Motset Setalready OK Cancel Optional Settings Notset Setalready 1 The password can be set or cancelled by choosing MX Sheet Protect MX Sheet setting Unprotect MX Sheet setting on the menu bar APP 6 APP 6 APPENDICES MELSOFT Appendix 1 9 Error log setting When communication is started an Error Log sheet that indicates the communication status of MX Sheet is created and the communication status error information and corrective actions are output To this Error Log sheet the following error log setting can be made by Option setting 1 Setting the
63. xample Automatic save condition Saved when the device YO turns on Automatically saved file name Date and time are added to the file auto xls i My Documents File Edit View Favorites Tools Help Back ii 22 Search m Folders la E X lz Address File and Folder Tasks n2 L My eBooks gt My Music Make a new Falder Publish this Folder to the As web 9 Pictures EI Share this Folder L Other Places 2 Desktop Automatically saved Excel file Shared Documents 4 Computer amp My Network Places Details 6 OPERATING MX Sheet MELSOFT 2 Setting automatic save This section explains an Excel book automatic save setting procedure Microsoft Excel Book1 xls E File Edit View Insert Format Tools Data Window Mx Sheet M Help t ev Cell Setting L b rS amp J Iv 2 2 utomatic Print Setting Q Automatic Communication Startup Setting A 2004 07 14 Wed 16 31 38 E un E 2004 07 14 Wed 16 31 43 12 2004 07 14 Wed 16 31 48 2004 07 14 Wed 16 31 53 2 2004 07 14 Wed 16 31 58 2004 07 14 Wed 16 32 03 2 2004 07 14 Wed 16 32 08 JE 2004 07 14 Wed 15 32 13 2004 07 14 Wed 16 32 18 21 2004 07 14 Wed 15 32 23 E 1Shot Communication S Cut Cell Area T Cell Area C Delete Cell Area D Change Sheet Name N 13 Create Buttoni 15 Protect
64. y direct mail 2 Notes on Contact Please ask questions concretely and clearly using terms listed in the manual When requesting us to solve a problem provide us with detailed information for reproducing the problem In addition contact the respective manufacturers when asking questions about the operating system OS or the other vender s software products User registration is valid only in Japan INTRODUCTION Thank you for choosing the Mitsubishi Integrated FA Software MELSOFT series Read this manual and make sure you understand the functions and performance of MELSOFT series thoroughly in advance to ensure correct use CONTENTS ene ne Pe ee ne nT ORT ECR A REVISIONS se CM ese PL MR T CLP A SOFTWARE USER fREGISTRATION et ve ee ERE OE Es E Dee ERE o PERDU A a SORE OO E NR TNT A SERERE ICT A Generic Terms and nade petere oe Dee Fu Nae A EE MEIN A 1 OVERVIEW 1 1to 1 1 1 What Is MX Sheet 1 1 2 F nctons Explained mn This Manuals raean ee eiu 1 NN BP gt Se SCAN AUON ceo etate LU ai rana 3 1 9L Installation usos tide denn
Download Pdf Manuals
Related Search