Home

MX Sheet Version 1 Operating Manual

1. 6 68 Comment display function 3 1 6 60 Comment SUM siat 6 69 Communication 10 2 Communication Setup Ultility 6 9 7 3 Comparison between MX Sheet and MX Chart ibd uen vus oa utri amets deines APP 2 Contents to save 6 34 Conversion Log File 20 5 CODY Cell 12 2 CSV HOGGING dou osten 3 1 6 34 6 45 Cut Cell ATQ tesi eate 12 1 D Data conversion function 3 1 20 1 Data Rus 6 12 6 67 Delete Cell Area 12 5 BV ee 6 14 6 59 Device Trigger 3 1 6 21 7 2 Displayed Contents 6 3 Index 1 E End Communication 10 3 ErrorLog 19 1 F FUNCION 3 1 Handshake 3 1 6 24 How to create the Excel sheet APP 10 allum APP 14 I ICONS a dU ERA 5 1 AED OEE EE T E EET A EEE 6 14 L Logging 3 1 6 2 Logging Time zone 6 15 Logical Station Number
2. 6 10 7 7 Men et 5 1 Monitor function 3 1 6 35 MAC RAFT HERES 20 1 MX COMPONENT sineira 2 1 20 1 MX Sheet menu 5 1 MXComShConv exe 20 2 20 3 N New data location 6 3 6 55 INO OF lA ENTE 6 14 No of 6 13 No of lines to be saved 6 32 6 34 6 45 Number of set devices 6 8 6 54 O Off time String 6 56 6 60 On time String 6 56 6 60 Operation day 6 15 7 4 Operation Interval 6 15 6 42 6 51 6 62 6 71 Operation time 6 15 6 42 6 51 6 71 7 5 Operation when cell is full 6 4 P Paste Cell Area 12 3 Preset cell 6 9 Processing of MX Sheet APP 5 Processing speed of MX Sheet APP 3 R Remote password 6 8 7 3 a3IS lare vi ee 5 1 5 Sample 18 1 Setting Data Export 3 1
3. Optional Settings Notset Setalready Detailed Item Description l Explanation 6 CELL SETTING MELSOFT 2 Setting examples and operation timing The following shows the handshake setting examples and operation timing a When Start with the request from the PLC is selected Device Bit device Setting example Cell Settings Logging functon Use Access Data Operation Interval Device Trigger Handshake CSV Logging Set Handshake Start with the request from the PLC Start with the request from the PC Responding device on the PC side Set Handshake Marked IEN Start with the request from the PLC Marked Responding device on the PC side i Bit device Marked Device M100 Requesting device B collectiwrite Value ON Bit Device Requesting device on the PLC side em el Bit device Marked pii Device MO vae Condition When ON Monitoring time 10 seconds Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CSV Logging Logging functon Logging 1 Modem_ Settings Settings Settings Settings Mandatory Settings Notset Setalready Optional Settings Notset Setalready lt Operation timing gt ON M100 3 5 Responding device OFF on the PC side 2 Device data collection ON MO Requesting device OFF on the PLC side Time out monitoring Monitoring tim
4. c Excel 2007 or later is used on 64 bit Windows 7 l e http www microsoft com downloads en Microsoft NET Framework dotNetFx40 Full x86 x64 exe details aspx displaylang en amp Family ID 0 4 0 Extended a391abd 25c1 4fc0 919f b21f31ab88b7 http www microsoft com downloads en vstor40_x64 exe details aspx FamilyID 06C32242 2289 4471 93AA CE96AA5CBC36 1 The file is in the DOTNET folder 2 If the website cannot be accessed refer to d Microsoft Visual Studio 2010 Tools for Office Runtime x64 d If a website shown in MEL S b or c cannot be accessed URL as of March 4 2011 Opemtin The module related to Microsoft NET Framework can be http msdn microsoft com en us netframework l obtained Read the explanation the displayed page The module related to Microsoft Visual Studio 2010 Tools for http www microsoft com downloads en default aspx Office Runtime can be obtained Search for Visual Studio 2010 Tools for Office Runtime on the displayed page APP 24 APP 24 APPENDICES MELSOFT Check if the required NET Framework and the related module are installed or not by the following operations e When using Windows XP Select Start Control Panel Add or Remove Programs e When using Windows Vista or Windows 7 Select Start Control Panel Uninstall a program Q A gt Control Panel gt Programs gt Programs and Features
5. 12 Cell editing Chapter 12 Chapter 12 describes cell editing cutting copying pasting and deletion of cell area 13 The sheet name changing method Chapter 13 Chapter 13 describes the sheet name changing method Definitions of Terms 14 Create Button Chapter 14 Chapter 14 describes the creation of the Start Communication End Communication and 1 Shot Communication buttons 15 Protect Unprotect MX Sheet setting Chapter 15 Chapter 15 describes Protect Unprotect MX Sheet setting by password 16 Options Chapter 16 Chapter 16 describes Options for setting the output format of an error log sheet 17 The setting data export Chapter 17 Chapter 17 describes the setting data export 18 The error log checking method Chapter 19 Chapter 19 describes the error log checking method 19 The data utilization method of MX Chart Chapter 20 Chapter 20 describes the data utilization method of MX Chart 20 The version confirmation method Appendix 1 Appendix 1 describes the version confirmation method of MX Sheet 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 c1 _ _ 1 Serial COM1 Time out period Baud rate t
6. 6 Device M100 File name to save D Documents and SettingsWy DocumentsYCS V cs Browse a i Monitoring Add date and time to File name lime Add sequential number to File name 000 999 Requesting device Collect irite 10 s C Fix the File name Contents to save Add Device name to the first line onthe PLC side Bit Device C Word Device D Device Condition hen ON bd Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CS Logging Monitor function Monitor 1 Modem_ Settings Settings Settings Settings CelAreaName Use Logical Sta Operation Interval Device Trigger Handshake CSV Logging Monitor function Monitor 1 Modem Settings Settings Settings Settings Mandatory Settings Notset Setalready OK Cancel Optional Settings Notset Setalready Mandatory Settings Notset Setalready OK Cancel Apply Optional Settings Setalready 6 CELL SETTING MELSOFT 6 3 1 Setting of the Use tab This section describes the setting of the lt lt Use gt gt tab for use of the monitor function In the lt lt Use gt gt tab set the cell area and monitor data display direction 1 lt lt Use gt gt tab Cell Settings Monitor function ccess Data peration Interva Device Trigger Handshake CSV Logging Cell Monitor function m Setthe Color of
7. The following indicates the file name format when data is saved Add sequential number to File name 00 extension Extension set in File name to save File number File name set in File name to save Fix the File name The file set in File name to save is overwritten by data 1 A UNC path name server name path name cannot be specified as a file name After assigning the network drive specify the path name 2 and xlsb are Workbook format extensions added to Excel 2007 or later 3 For the continuous operation when saving data automatically in HTML format refer to APPENDIX 7 4 In the case of an Excel file or HTML file the whole Excel book is saved However in the case of a CSV file only the data of the target sheet is saved 6 CELL SETTING MELSOFT g preset cell areas The cell areas already set to the Excel book are displayed The following operations are available by selecting the cell area name in the preset cell areas 1 Reading the settings Choose and double click the cell area name to read the settings of the selected cell area name to the Cell Setting dialog box 2 Deleting the settings Choose the cell area name and press the key to erase all the settings of the selected cell area name 6 CELL SETTING MELSOFT 6 2 2 Setting of the Access Data tab This section describes the setting of the lt lt Access Data gt gt tab for use of the logging fu
8. Lf Logging Time zone Log Always Log only during the specified time zone Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CSV Logging Logging function Logging 1 Modem Settings Settings Settings Settings Mandatory Settings Motset Setalready Optional Settings Notset Setalready OK Cancel lt lt Handshake gt gt tab Cell Settings Logging function Use Access Data Operation Interval Device Trigger f Handshake CSV Logging Set Handshake Start with the request from the PLC Start with the request from the PC Responding device on the PC side Bit Device Word Device Device M100 i Monitoring itime Requesting device Collect irite i 10 s on the PLC side Bit Device Word Device D Device o Condition When ON 5 m Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CS Logging Logging function Logging 1 Modem Settings Settings Settings Settings Mandatory Settings Motset Setalready Optional Settings Notset Setalready Required setting Refer to Section 6 2 1 Required setting Refer to Section 6 2 3 Set as necessary Refer to Section 6 2 5 Access Data gt gt tab Cell Settings Logging function peration Interval Device Trigger Handshake CSV Logging Logical Station Number 1 Modem QJ71C24 X Communi
9. Automatic print list from the menu bar 2 Automatic print list dialog box Automatic Print List i i Device Trigger Create New Line1 daily i No settings Line2daily No settings No settings Settings No settings LineSdaily Settings No settings No settings Settings Line1 weekly No settings Settings No settings No settings Line1 monthly No settings Settings No settings Settings Line2monthly No settings Settings No settings Settings Line3monthly No settings Settings No settings Settings Detailed Item Description Explanation Display a list of automatic print names created in the Automatic print dialog box refer to Section 8 2 a Automatic print name list Create new automatic print setting data EU Change the contents of the existing automatic print setting data Delete Delete the selected automatic print name from the automatic print name list Close the Automatic print list dialog box 8 AUTOMATIC PRINT SETTING MELSOFT 3 Detailed explanation a Automatic print name list Checked when new data is created Display the automatic print names created in the Automatic print dialog box T Display whether the Print at the end of communication check box in the Automatic print End of communication dialog box is checked or not in the form of Settings or No settings Display whether the Set the date and time check box in the Automatic print dialog bo
10. CSV Logging Comment display Comment 1 Modem Settings Settings Settings Mandatory Settings Notset Setalready Optional Settings Setalready Mandatory Settings Notset Setalready Optional Settings Setalready 6 CELL SETTING MELSOFT 6 6 1 Setting of the Use tab This section describes the setting of the lt lt Use gt gt tab for use of the comment display function In the lt lt Use gt gt tab set the cell area 1 lt lt Use gt gt tab Cell Settings Comment display function terva Device Trigger Handshake Use Comment Cell Area Name Comment display function Cell Area B2 v Set the Color of Grid line v Set the Color for Filling Clear cell area at the start of communication Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CS Logging Comment display Comment 1 Modem_ Settings Settings Settings Mandatory Settings Not set Set already OK Cancel Optional Settings Motset Setalready m Detailed Item Description Explanation Use Set the function to be used for the specified cell area Choose Comment when using the comment display function Set the name of the specified cell area Cell Area Name Maximum number of cell area names 500 Cell Area Enter the value to specify the cell area 2 a Coloro Set whether the specified cell area is provided with grid lin
11. OK Cancel Optional Settings Motset Setalready Detailed Item Description Explanation Set the Device Set the Device Trigger Set when the device trigger is used Section 6 2 4 a Device conditions Set the device conditions b Preset cell areas The settings of the cell areas preset to the Excel book are displayed Section 6 2 1 2 Detailed explanation The setting of the Device Trigger tab for use of the alarm summary function is the same as that of the Device Trigger tab for use of the logging function Refer to Section 6 2 4 for details 6 CELL SETTING MELSOFT 6 6 When Comment Is Selected This section describes the Cell Setting dialog box when Comment is selected from Use of the lt lt Use gt gt tab lt lt Use gt gt tab Access Data tab Cell Settings Comment display function Cell Settings Comment display function Access Data Comment Data Operation Interval Device Trigger Handshake Req u red setti n g comment Data Operation Interval Device Trigger Handshake Req Uu red setti n g ss Comment Logical Station Number Modem curia sss Cel area Name COPEN Tron Refer to Section ee Refer to Section Cell Area 2 7 V Setthe Color of Grid line B Iv Setthe Color for Filling 6 6 2 Clear cell area at the start of communication 6 6 1 Cell Area Name Use Logical Sta Operation Interval Device Trig
12. Monitor function Write function Alarm summary function Refer to Chapters 6 to 8 Comment display function Automatic save function Automatic print function Start communication Refer to Section 10 1 Completion 1 Before starting MX Sheet settings save the Excel book If not MX Sheet cannot be set Communication efficiency changes depending on the MX Sheet setting Refer to APPENDIX 3 and APPENDIX 5 Refer to the Excel manual for how to operate Excel 4 MX Sheet OPERATION PROCEDURE MELSOFT lt Administrator authority when setting changing communication setup on Windows Vista and Windows 7 Administrator authority is required for setting changing communication setup 1 Administrator authority in case of Windows Vista and Windows 7 1 When user account control UAC is enabled All users including administrator are fixed at and operate as standard user To execute programs in administrator authority specify Run as administrator When executing Excel with administrator authority even if selecting NO for Do you execute programs as an administrator executes with administrator authority 2 When user account control UAC is disabled Programs can be executed by login user 2 When setting changing the communication setup on Windows Vista and Windows 7 The following three methods are available to set change the communication setup Execute Communication Setup
13. Refer to Section 16 1 19 2 19 2 20 DATA CONVERSION FUNCTION MELSOFT 20 DATA CONVERSION FUNCTION This chapter describes the function to convert the Excel book created using MX Chart into the Excel book for MX Sheet 20 1 Data Conversion Function This section explains the data conversion functions the relevant system configuration and utility 1 Function list The following table lists the data conversion functions This function converts automatically the communication settings made using the utilities of MX Links into the communication settings logical station numbers of MX Component ENCORE gan uh S converts automatically the set data of MX Chart into the cell settings of MX 2 System configuration The following table indicates the system configuration that executes the data conversion function Personal computer where any of the following OSes operates and MX Links and MX Chart have been installed 1 Microsoft Windows 98 Operating System English version Conversion of MX Links data Personal computer Microsoft Windows NT Workstation Operating System Version 4 0 English version MX Links SW3D5F CSKP E Version 10B or later MX Chart SW3D5F OLEX E Version 00 or later Conversion source Excel book Excel book created using Excel 97 English version or Excel 2000 English version 2 1 The utilities of MX Links must have been set for communication 2 MX Chart must have been
14. The settings of the cell areas preset to the Excel book are displayed Section 6 2 1 2 Detailed explanation a Device The device registered to the lt lt Access Data gt gt tab is displayed b ON time String Enter the character string to be displayed in the cell when the registered device turns on Number of characters Up to 16 c OFF time String Enter the character string to be displayed in the cell when the registered device turns off Number of characters Up to 16 d Alarm String Enter an alarm character string Number of characters Up to 40 e Status String Enter a status character string Number of characters Up to 16 6 CELL SETTING MELSOFT 3 Setting example The following shows the lt lt Alarm Data gt gt tab setting example and the data displayed on the Excel sheet lt lt Alarm Data gt gt tab setting example ON in Mee Minor fius Device MO time String Generation OFF time String Restoration Alarm String Material storage Status String Minor failure Operation of M0 ON 1 2 Data displayed on Excel sheet Displayed in order of date and time of occurrence alarm character string and status character string Generation 2002 08 01 Thu 16 18 12 Material storage Minor failure Restoration 2002 08 01 Thu 16 18 32 ee po 1 Displayed in the cell when MO is on od 2 Displayed in the cell when MO is off
15. To display the lt lt Developer gt gt tab choose lt lt File gt gt tab Options Choose Customize Ribbon select Developer and click OK Excel Options 9 15 General Customize the Ribbon Formulas Choose commands from Customize the Ribbon Proofing Popular Commands Main Tabs dj All Chart Types n Main Tabs language t Borders 3 E V Home Advanced a Calculate Now Clipboard Center 9 Font Customize Ribbon E Conditional Formatting gt Alignment 85 Connections E Number Quick Access Toolbar B Copy 9 Styles Vf Custom Sort 3 Cells 8 Editing Trust Center A Decrease Font Size V Insert 99 Delete Cells V Page Layout Delete Sheet Columns Formulas 3 Delete Sheet Rows 3 V Data E mail Add V Review fay gt Fill Color gt amp V View Ys Filter Remove GIR Developer Font i V Add Ins A Font Color gt V Background Removal 8f Format Cells Format Painter 825 Freeze Panes A Increase Font Size g Insert Cells fe Insert Function Insert Sheet Columns a Insert Sheet Rows New Tab New Group b Mados Customizations i Fa Merge amp Center 3 Name Manager Import Export OK Cancel The lt lt Developer gt gt
16. opecify the cell on the Excel sheet where the button will be placed and choose MX Sheet Create Button Start Communication Button on the menu bar n Excel 2007 or later choose the Add Ins gt gt tab MX Sheet Create Button Start Communication Button The button is placed in the specified cell position Use the property setting of the property page to change the display characters on the button set whether the start message will be displayed or hidden at execution of the button function and change the type size of the display character font on the button Refer to 2 3 14 1 14 CREATE BUTTON MELSOFT 2 Property page starting method Control Toolbox x amp Y ml lAl v To the next page 14 2 1 Click in the Control Toolbox to select the Design Mode To display the Control Toolbox check the Control Toolbox on the lt lt Toolbars gt gt Tab in the dialog box that is displayed by choosing Tools Customize in the Excel menu 1 In Excel 2007 or later click 572 in the lt lt Developer gt gt tab Excel 2007 To display the lt lt Developer gt gt tab choose Office button Excel Options e 1 Microsoft E 1 View Add Ins Recent Documents New al AIZ KK Clear Z A REPI EE gt u zi Sort Filter v Text to Open 4 Advanced Columns Sort amp F
17. tab appears 9 c gt Book Microsoft Excel m Home Insert Pagelayout Formulas Data Review View Developer Add Ins 7 xX EH E 2 Record Macro SN Bf Properties f Map Properties 1 gt E DY PA lt gt 2 isl Use Relative References G view Code 4j Expansion Packs 7 Export Visual Macros Insert Design Source 2 Basic Macro Security RunDialog Refresh Data Code Controls XML 2 Choose MXShBtnStart Control Object Properties in the menu displayed by right clicking the created button with the mouse 3 The property page starts Set the properties shown in 3 sign for Excel 2007 or later to exit Mode 14 CREATE BUTTON MELSOFT 3 Property setting Set the Caption ShowMessage and Font properties 1 lt lt Caption gt gt tab Edit the Caption display characters on the button of the button MXS5ShBtnStart Control Properties Caption 5 hBtnStart 2 Show Message tab Set whether the following Start Communication message will be displayed or not when the Start Communication button is clicked MX 5heet t Communication will commence sit OFF Shaw essage TRUE TRUE Display FALSE Not display 3 lt lt Font gt gt tab Set the type and size of the Caption font MXShBtnStart Control Properties Property Mame Font Font Font Style Size Arial Regular 1125 Tp
18. time taken for saving a file may lengthen Cell range 12 columns x 30 rows 128 columns x 32768 rows 255 columns x 65535 rows Time Time Time Excel 2000 0 112 Less than 1 Excel 2010 sar __0035 Lessthant 4 45 1 Excel 2010 binary format 0022 Lessthan ose 2 s Measurement condition 1 type is set for cell settings application logging Measurement environment Intel 2 Duo E8400 3 0GHz 1GB MM Windows XP Professional SP3 APP 4 APP 4 APPENDICES MELSOFT APPENDIX 4 PROCESSING MX Sheet This section explains the processing of MX Sheet Appendix 4 1 Collection Delay and Data Dropout On MX Sheet collection delay data dropout or similar problem may occur depending on the communication time with the PLC and the collection timing of device data The following explains the collection delay and data dropout 1 Collection delay Device data collection delay will occur depending on the communication time with the PLC and the corresponding processing time Collection delay occurs only when Operation time is set to Regular interval When a collection delay occurs it will be registered to the ErrorLog sheet as error information When a collection delay occurs check the ErrorLog sheet The following explains the cases where a collection delay occurs a When the actual communication time is longer than the specified operation interval When the communicati
19. 1 Function List of MX Sheet The following table lists the functions of MX Sheet Function Name Description nii Available Cells Points Section Accumulates device data collected from PLC in cell range NETT 256 columns Logging selected on Excel as history s pelis X 65536 rows a device data collected from PLC in cell range selected on 2000 points 2000 Section 6 3 Writes values entered on Excel to PLC devices 2000 points 2000 Section 6 4 Converts ON OFF data of bit devices into alarm comment eum Alarm summary character strings that are set separately and accumulates them 2000 points X 65536 rows Section 6 5 on Excel sheet as alarm history Cease tacos Converts bit or word device values into comment character 1 point 5 Section 6 6 did strings that are set separately and displays them on Excel sheet P Collects Writes device data when set device conditions set for l Device trigger Section 6 2 4 collection write are met Handshake Sets handshake with PLC for secure device data collection write Section 6 2 5 Displays device data on Excel sheet with logging or monitor S V logging function and simultaneously saves collected data as a CSV file 2 Automatically saves Excel book Chapter 7 Automatic print Automatically prints Excel book Chapter 8 ATO Automatically starts communication with PLC when Excel book is communication started startup oo This function starts communication wi
20. 10 3 TOST S Onrmulicadlobi o Ll terunt ack etal d tes ate alt Lec uate LEE REEL ua an cU Set SOUL tal 10 1 10 2 Communicator Eri tpe usse od unum cue UE LC e cba a DURS ERE 10 3 11 1 SHOT COMMUNICATION 11 1to11 2 12 CELL EDITING 12 1to 12 5 LX 12 1 12 2 COD VING ME CEATA A 12 2 12 3 PAS NG ME cele e 12 3 124 Deleting ANG CCMA M 12 5 13 CHANGING THE SHEET NAME 13 1 to 13 2 14 Create Button 14 1to 14 7 T4 T tart COMMUNICATION BUOM eis oi pU See e nutes ex pu dep tear erp e eter ee E eeu 14 1 14 2 End Goimmubicaloh BETOT EE NAE e DIE IRAE uS Reader Rus 14 6 14 9 TShot Communication BUNTON sse ono ERE ERE e E or bet Pa s at t PII PM rn pu MEUS E IUE 14 7 15 Protect Unprotect MX Sheet setting 15 1to 15 4 15 1 Protect MX Sheet setting nennen nennen nennen sinn nena nsn rasis nana 15 1 12 UNDFOLECTIVIX NCC SOMING e rS 15 4 16 Options 16 1 to 16 2 io Seting OM Tete IGOR OG cides 16 1 20 1 Data Conversion Function ise 20 1 20 2 Operation Procedure of 5 20 3 o Cl SION LOQ CMM 20 5 20 4 Precau
21. 17 1 Start Communication 10 1 Stats SMN Y 6 56 T Telephone line connectivity time zone 6 13 Transport dct APP 13 U SIM OS 6 1 V Version Info APP 1 IW Write function reser 3 1 6 43 Z Vise REM ME UON RENS 6 12 6 47 Index 2 Index 2 Microsoft Windows and Windows NT Windows Vista are registered trademarks of Microsoft Corporation in the United States and other countries Pentium is a registered trademark of Intel Corporation in the United States and other countries Other company and product names herein are either trademarks of registered trademarks of their respective owners SH NA 080348E K MX Sheet Version 1 Operating Manual MELS1 SHEET O E 13JU35 SH NA 080348E K 1105 MEE a MITSUBISHI ELECTRIC CORPORATION HEAD OFFICE TOKYO BUILDING 2 7 3 MARUNOUCHI CHIYODA KU TOKYO 100 8310 JAPAN NAGOYA WORKS 1 14 YADA MINAMI 5 CHOME HIGASHI KU NAGOYA JAPAN When exported from Japan this manual does not require application to the Ministry of Economy Trade and Industry for service transaction permission Specifications subject to change without notice
22. 2 e Excel Uptions Screen appears oelec Trust Center Headers and Footers CA Microsoft Office Officel4 OFFRHD DLL Document Inspector Hidden Rows and Columns CA Microsoft Office Officel4 OFFRHD DLL Document Inspector a n Hidden Worksheets CA Microsoft Office Ofticel OFFRHD DLL Document Inspector Ins change the item in Manage to COM Add ins Invisible Content C Microsoft Office Office14 OFFRHD DLL Document Inspector 7 7 Microsoft Actions Pane 3 XML Expansion Pack MX Sheet C MELSEC Sheet MXShMenu xla Excel Add in d k G Solver Add in C e Officel4 Library SOLVER SOLVER XLAM Excel Add in a n C IC O Document Related Add ins No Document Related Add ins vo Document Related Disabled Application Add ins 24 Add in MXShRibbon Publisher lt None gt Compatibility No compatibility information available Location C MELSEC Sheet MXShRibbon vstolvstolocal Description Additional MX Sheet Add in Manage ENEE COM Add Ins 4 In the COM Add Ins dialog box check that Add Ins available OK c r EAIMxShRibbon a MXShRibbon is displayed and its check box is Team Foundation Add n Cancel selected Location C MELSEC Sheet MXShRibbon vsto vstolocal Load Behavior Load at Startup Checked APP 26 APP 26 APPENDICES MELSOFT APPENDIX 10 ADDED EXTENDED FUNCTIONS The following shows the functions added
23. 20 6 20 DATA CONVERSION FUNCTION MELSOFT Precautions on cell areas and sheet names 1 When the cell area name has been set to invalid in the Cell area name valid invalid dialog box of MX Chart the Set the Operation Interval checkbox of the lt lt Operation Interval gt gt tab is unmarked in the Cell Setting dialog box of MX Sheet to make the cell area setting invalid 2 If a non existing Excel sheet has been set in the Cell area name valid invalid dialog box of MX Chart data conversion is continued ignoring the settings of the non existing Excel sheet Precautions on devices 1 When the data types of the following devices have been set to other than Bit on MX Chart the settings are not converted for MX Sheet e TT timer contact e TC timer coil e CT counter contact e CC counter coil e STT retentive timer contact e SIC retentive timer coil Precautions on alarm summary conversion 1 When a handshake has been set in the cell area used for the alarm summary of MX Chart the handshake settings are not converted The alarm summary function of MX Sheet does not support a handshake 2 If device settings overlap in the cell area for the alarm summary of MX Chart the settings made second and later are not converted Precautions on simple logging conversion 1 If Interrupt logging has been set in Display option when reach to the end of cell areas of the Logging setup revision dialog bo
24. 3s Operation interval 2s waiting time set to 3s occurs Time Time necessary for communication 5s ON M100 OFF ON MO OFF 1 Requesting device check time 2 Communication time 3 Handshake processing time 1 2 3 is time necessary for communication APP 6 APP 6 APPENDICES MELSOFT 2 Data dropout The data to be collected may dropout depending on the communication time with the PLC and the collection timing of device data The following explains the cases where a data dropout occurs a When the actual communication time is longer than the specified operation interval When the communication time with the PLC is longer than the operation interval the data to be collected dropouts If a data dropout has occurred increase the operation interval setting of MX Sheet Example When Operation time has been set to Hourly Omin 1min 2min but the communication time with the PLC is longer than 1min If previous data collection is still being executed when it has reached the operation time as shown below a data dropout occurs on MX Sheet 12 00 12 01 12 02 Time Communication time 1min 30s Since data at 12 00 is being collected data at 12 01 is not collected b Data dropout when device trigger function is used When the device trigger condition holds for the specified operation time the condition cannot be checked and the data to be collected dropouts If a data dropout oc
25. 6 38 0 9 I Set ng ortne Use an e dash Ra ua Sus aan Msn a DD EL EVA GS aan 6 39 6 3 2 Setting of the Access Data tab us casio it sos oe ent ec eque esctgeii eq egescd dei ex ecu 6 42 6 3 3 Setting of the Operation Interval tab siseste aei a 6 43 6 3 4 Setting of the Device Trigger tab cccccssssseccccccceessseeceeccceeeuseeeeeeeceeaaueeceeeceeesaaaseceeeesseeesaaaseeeness 6 44 6 5 5 Set ng or the MANASNAKES TAD ac ab ao cou o gae d uaa osque Tu EE i va ups 6 45 0 5 0 Setting ertne CSV HOGGING TaD a Dato ubi oodd 6 46 Ae VV CTE VV FINS Selected oen ete ha N 6 47 6 4 1 Setting of the Use 6 48 6 4 2 Seting of tie Access Data a Ai eed 6 50 6 4 3 Setting of the Operation Interval 6 52 644 Setting of the Device Trigger oie Eo ode bon rete poa es Eos ies ies cane eat 6 53 6 4 5 Setting of the Handshake Bb peser aims suae peus eund 6 54 6 5 When Alarm Summary IS Selected n2 meae o ha ad 6 55 Soie ci lgo WS TAD e ccc PEE 6 56 6 5 2 Setting of the AGcess Data taD E Rest Dau Nonis iu VU ard 6 59 6 0 0 SeuInGg O1 Binz M et 6 61 6 5 4 Setting of
26. 6 CELL SETTING MELSOFT 6 5 4 Setting of the Operation Interval tab This section describes the setting of the lt lt Operation Interval gt gt tab for use of the alarm summary function In the lt lt Operation Interval gt gt tab set the operation interval for the function of the cell area 1 Operation Interval gt gt tab Cell Settings Alarm summary function Use Access Data Alarm Data Interva n Regular interval 5 s Telephone line connectivity time zone Bein connected state always from the start of the communication Connect during the specified time zones only Cell amp rea Name Use Logical Stati Operation Interval Device Trigger Handshake CSV Logging Alarm summary f Alarm summary 1 Settings Settings Mandatory Settings Motset Setalready OK Cancel Optional Settings Notset Setalready Detailed Explanation Regular interval Set the operation interval of the alarm summary function 2 a Set the telephone line connection timing and disconnection timing Section 6 2 3 a Preset cell areas The settings of the cell areas preset to the Excel book are displayed Section 6 2 1 1 Telephone line connectivity time zone is displayed when the logical station number selected in Logical Station Number of the lt lt Access Data gt gt tab is the one for modem communication 2 Detailed explanation With the exceptio
27. Description Excel book name Excel sheet name Logging Logging is performed for DO to D4 at 1 second intervals Monitor display their assigned comments and write the device data D10 to D12 at intervals of 5 seconds Alarm Summary Alarm summary is performed using MO to M4 Monitor Write Conditioning Monitor and write the device data using device trigger Logging Conditioning Logging is performed using handshake Save the data on the Excel sheet automatically when M20 turns on Automatic save is described in Excel sheet Sample1 xls Monitor Comment Write Sample2 xls Automatic Save Logging Sheet Monitor Comment Write Sheet Alarm Summary Sheet Microsoft Excel Sample1 xls Microsoft Excel Sample1 xls Microsoft Excel Sample1 m mr Edt Insert Format Tools Data Window MX Sheet M Hel Elle Edit view Insert Format Tools Data Window Help File Edit View Insert Format Tools Data Window Help UTE qs v v 5 zi File Edit View Insert Format Tools Data Window MXSheet M Hel Fle Edi view Insert Format Tools Data Window MX Sheet
28. Description s Explanation Clear cell Make setting when clearing the cell area data after automatic print 4 b automatic print From the list select the cell area name that will be the target of Clear cell Specify the cell area name pe 4 c area after automatic print Set the area where automatic print will be performed 4 d Register the newly created or edited Automatic print name to the Automatic print list dialog box 4 e 4 Detailed explanation With the exception of the following items the setting of the Automatic Print dialog box is the same as that of the Automatic Save dialog box Refer to Chapter 7 for details a Automatic print name Attach specific names to the automatic print setting data Up to 50 automatic print names can be registered b Clear cell area after automatic print oet whether the data of the cell area selected in the Specify the cell area name will be cleared or not after automatic print is performed To clear the cell area data after automatic print check the check box c Specify the cell area name From the list box select the Cell Area Name of the cell area whose data will be cleared after automatic print Multiple names can be selected The list box displays all Cell Area Names set in the Cell Settings dialog box d Print Area oet the area where automatic print will be performed 1 Entire workbook The entire Excel
29. E mail Windows Mail e Documents uil Welcome Center b Backup Status and Configuration TA Music Pictures gt Windows Media Player Search 2 Small Business Resources g Windows Fax and Scan Windows Meeting Space s Windows Photo Gallery a Windows Live Messenger Download Vv Paint j gt All Programs Start Search Recent Items Computer Network Connect To Control Panel Default Programs Help and Support gt E gt Control Panel Control Panel Home nm System and Maintenance Classic View a Get started with Windows Back up your computer Security Check for updates Check this computer s security status Irewa Network and Internet Connect to the Internet View network status and tasks Set up file sharing Hardware and Sound Printer Mouse Programs Uninstall a program Change startup programs Mobile PC A Change battery settings Adjust commonly used mobility settings i gy Allow a program through Windows Play CDs or other media automatically User Accounts Add or remove user accoun ts Appearance and j Personalization Change desktop background Customize colors n resolution Clock Language and Region Change keyboards or other input methods Ease of Access Let Windows suggest settings Optimize visual display Additional Options next page APP 16 2 Select User Accounts APP 16 APPENDIC
30. Excel d 3G TM 6 13 21 PM B C D E F End Communication E 2007 09 04 Tue 18 13 21 2007 09 04 Tue 18 13 26 2007 09 04 Tue 18 13 31 2007 09 04 Tue 18 13 36 2007 09 04 Tue 18 13 41 2007 09 04 Tue 18 13 46 2007 09 04 Tue 18 13 51 2007 09 04 Tue 18 13 56 2007 09 04 Tue 18 14 01 2007 09 04 Tue 18 14 06 2007 09 04 Tue 18 14 11 1Shot Communication S oo oO oO oO 0 02 000 098 Version Info V M 4 gt Sheeti Sheet2 Sheet3 ErrorLog 2 Status during Communication d Tab Only the lt lt Add Ins gt gt tab can be selected e Group Only MX Sheet can be selected f MX Sheet menu Only Communication End 1 Shot Communication and Version Info can be selected g Icon Only the Communication End and 1 Shot Communication icons can be selected b Display of task bar During communication with the PLC using MX Sheet the following icon is displayed on the task bar of Windows Icon is displayed on task bar 4 Confirmation at communication error If an error occurs at the start of communication or during communication the error information is displayed on the ErrorLog sheet When a communication error has occurred end MX Sheet communication and correct the error in accordance with the corrective action on the ErrorLog sheet Refer to Chapter 19 for details of the ErrorLog sheet Microsoft Excel MX Sheet i File Edit view I
31. Gridline Bil M Setthe Color for Filling B Clear cell area at the start of communication Cell Display Direction Left to Right v Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CSY Logging Monitor function Monitor 1 Modem_ Settings Settings Settings Settings Mandatory Settings Not set Set already OK Cancel Optional Settings Notset Setalready Set the function to be used for the specified cell area Choose Monitor when using the monitor function Set the name of the specified cell area Cell Area Name Maximum number of cell area names 1000 Cell Area Enter the value to specify the cell area Qa Set the Color of Grid line Set whether the specified cell area is provided with grid lines including color designation or not Section 6 2 1 Set the Color for Setthe Color for Filling Set whether the specified cell area is colored or not When Clear cell area at the start of communication has a check mark the data in the cell area specified at the start of communication is cleared Default no check Clear cell area at the start of communication Set the monitor data display sequence Left to Right Monitor data are displayed from left to right in the specified cell area in Cell Display Direction order Top to Bottom Monitor data are displayed from top to bottom in the specified cell area in order 6 CELL SETTING MELSOFT 2 Detailed explanation Wi
32. M Hel a TD tb Ej zs D 3 SQ Be Sn Saw ela P TmesNewRomn ii BZU DSM A SRY BAS A MB E Tes New Roman DS MA SRY BET noA EE A7 E Tes NewRoman piri AP LOE ds ardt En G 2 gn g z 2 HEB RgGgOP woo A 1 i z A B 3 D E F 3 H 1 J K L M NET B D F J K 1 Alarm Information 2 Date Alarm State 3 Generation 2002 07 04 Tim 19 47 24 Equipment 2 emergency stop concernment Comment Write 4 Generation 2002 07 04 Thu 19 47 29 Equipment 1 emergency stop concemmment 2002 07 02 Tue 15 0415 10 5 Restoration 2002 07 04 Thu 19 47 29 Equipment 2 emergency stop concemment 2002 07 02 Tue 15 0416 6 Generation 2002 07 04 Tim 19 47 29 Line 3 stop Warning 2002707702 Tue 15 0417 e Dii 7 Generation 200200704 Tim 19 47 39 Line 1 stop Warming 2002 07 02 Tue 150418 EP x Dia 8 Generation 2002 07 04 Thu 19 47 39 Line 2 stop Warning 2002 07 02 Tue 15 04 19 9 Restoration 2002 07 04 Tha 19 47 44 Equipment 1 emergency stop concemment 10 Restoration 2002 07 04 Thu 19 47 49 Line 1 stop Warming 1 Restoration 2002 07 04 Tha 19 47 49 Line 3 stop Waring 2002707702 Tue 150421 ea 12 Generation 2002 07 04 Thu 19 47 54 Equipment 2 emergency stop concemment 3002 07 09 150422 9 Contents 13 Generation 2002 07 04 Tha 19 47 59 Equipment 1 emergency stop
33. Name Use Logical Sta Operation Interval Device Trigger Handshake CSV Logging Alarm summary f Alarm summary 1 Modem Settings Settings Mandatory Settings Not set 1 Setaleady Optional Settings Setalready Alarm Data gt gt tab Cell Settings Alarm summary function Alarm Data i Operation Interval Device Trigger Deke ON time String OFF time String Alarm String EE m9 MI Generation Restoration Generation Restoration Ma o Bo Generation Restoration B Generation Restoration Yo Generation Restoration pu c 1 Generation Restoration Gao 1 Generation Restoration Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CS Logging Alarm summary f Alarm summary 1 Modem Settings Settings Mandatory Settings Notset Setalready Optional Settings Setalready Device Trigger tab Cell Settings Alarm summary function Use Access Data Alarm Data Operation Inters v Set the Device Trigger Bit Device Word Device Device 00 Condition Range 100 os Cel AreaName Use Logical Sta Operation Interval Device Trigger Handshake CSV Logging Alarm summary f Alarm summary 1 Modem_ Settings Settings Mandatory Settings Notset Setalready Optional Settings Setalready Access Da
34. The settings of the cell areas preset to the Excel book are displayed Section 6 2 1 2 Detailed explanation With the exception of the following item the setting of the lt lt Use gt gt tab for use of the alarm summary function is the same as that of the lt lt Use gt gt tab for use of the logging function Refer to Section 6 2 1 for details a Cell Area oet the cell area to be used by the alarm summary function 1 Setting examples Refer to Section 6 2 1 for the Cell Area setting examples 2 Setting ranges The following indicates the possible setting ranges of the cell area and number of specified cell areas Number of cells 4 columns indispensable X 65536 rows Number of specified cell areas 16 1 When displaying the elapsed time and number of occurrences in the Alarm Summary increase the number of columns by 1 respectively 6 columns are required to display both b Display Contents 1 Add title check box oet whether the title for the column item indicated in the following table will be displayed or not on the first line of the set Cell Area When displaying the title check the check box On time String Off time String Refer to Section 6 5 3 The On time String is displayed when the device turns from OFF to ON or ON OFF the Off time String is displayed when the device turns from ON to OFF Date and time when the device turns from OFF to ON or from ON to OFF Alarm String set to the device Refer
35. bO to b7 b8 to b15 and D1 bO to b7 b8 to b15 are displayed in this order ABCD EFGH DO bO to b7 b8 to 615 and D1 bO to b7 b8 to b15 data is displayed 6 CELL SETTING MELSOFT 6 Zoom The device value read from the PLC is multiplied by the zoom ratio and displayed in the cell When Data Type has been set to Bit or Character string the Zoom setting is not possible When the Value is set to HEX the Zoom setting is not possible Setting range 0 001 to 1000 PLC Excel Set Zoom to 0 1 DO EJ Displayed 2 5 on Excel 7 No of cells Set the number of cells to be used for the device set in Device within the area specified in Cell Area Device data display example Setting example of Access Data tab of Lip DEC 1 sss Device DO Data type 16 bitinteger TF HESS REESE SCENES Number of cells 3 The device data are displayed on Excel as shown below 3 points are displayed in order starting with DO oo lt DO Di D2 __ B w jf 0p aall These are set as the cell area but not used 8 Dev Points The points of the devices to be consecutively read starting with the device number set in Device are displayed 9 In unit The unit of the device to be shown in the cell is displayed e The number of set devices The number of device points and others set to the cell area are di
36. designation or not Set the Color for Filling Set whether the specified cell area is colored or not When Clear cell area at the start of communication has a check mark the data in the cell area specified at the start of communication is cleared Default check Section 6 2 1 Set the latest data display position of the alarm summary e Last Line New data location The latest data is displayed at the last of the specified cell area First Line The latest data is displayed at the first of the specified cell area Bisslavad Contente Set whether the title elapsed time and number of occurrences will be iii added to the Alarm Summary or not To the next page Clear cell area at the start of communication 6 56 6 56 6 CELL SETTING MELSOFT D Detailed Item Description Explanation Set the operation to be performed when the specified cell area is full To scroll The displayed contents are scrolled and displayed Display from the first without clearing the cell area The data currently displayed in the cell area are overwritten and the alarm summary is resumed Operating when cell is full Before the alarm summary is resumed the Excel sheet can be printed Section 6 2 1 and saved Display from the first after clearing the cell area The data displayed in the cell area are erased and the alarm summary is resumed Before the alarm summary is resumed the Excel sheet can be printed and saved a Preset cell areas
37. log options 16 1 Used to execute setting Chapter data export 17 Used to display the MX Appendix 15hot Communication 5 Prokeck Tx Sheek settingi R Unprokeck Mi Sheek settingi Ri Optionstl Setting Data Exportti version Info gw 1 Can be selected after start of communication 2 Can be selected after the cell area has been cut or copied 0 2 0 2 6 CELL SETTING MELSOFT 6 CELL SETTING This chapter describes cell setting required to operate MX Sheet 6 1 Operation of Cell Setting Dialog Box This section explains the displaying procedure and setting item change of the Cell Setting dialog box In the Cell Setting dialog box its setting items change automatically depending on the selected function 1 Displaying Cell Setting dialog box Choose MX Sheet Cell Setting from the menu bar 2 Setting items of Cell Setting dialog box The setting of the Cell Setting dialog box can be changed by selecting Use of the lt lt Use gt gt tab Cell Settings Lise Access Data Operation Interval De Cell Area Mame Selecting Use changes setting items Cell Area Alarm summary Comment The following table indicates the function outlines and relevant sections for options of use Reference Section Logging Set when using the logging function Section 6 2 Set when using the monitor function Section 6 3 Set when using the write function
38. range of H3 L12 is written to Devices D0 D49 15 18 lt Read conditions lt Write conditions 16 n When the value of is turned ON Device trigger When the value of M1 is turned ON Device trigger 17 18 2 The data when reading is saved to a CSV file CSV Logging 18 18 Save file name gt When the value is not altogether written to the cell range 18 20 CAMelsec Sheet SaveCSV csv it can t be written to PLC 20 21 21 22 5 r 22 23 All communication setting of this sample program is set up by Logical Station Number 1 s 23 24 24 25 25 26 26 E is 27 28 x D 28 M Monitor Write Conditioning Logging Conditioning Automatic save 41 M MN Monitor Write Conditioning Logging Conditioning Automatic save 141 Belo M MN Monitor Write Conditioning Logging Conditioning Automatic save 41 Ready Ready Ready 18 1 18 1 18 SAMPLE PROGRAMS MELSOFT MEMO 19 ERRORLOG SHEET MELSOFT 19 ERRORLOG SHEET This chapter describes the ErrorLog sheet that displays the communication status of MX Sheet The communication status error information and corrective action of MX Sheet are displayed in the ErrorLog sheet Troubleshooting can be performed by confirming the corrective action displayed in the ErrorLog sheet 1 ErrorLog sheet Microsoft Excel MX Sheet File Edit wiew Insert Format Tools Data Window Sheet M Help D c
39. set to the Excel book for data conversion 20 1 20 1 20 DATA CONVERSION FUNCTION MELSOFT The following OSes and conversion source Excel book do not support the data conversion function Compatible Version Microsoft Windows 95 Operating System English version Microsoft Windows Millennium Edition Operating System English version Microsoft Windows 2000 Professional Operating System English version Microsoft Windows XP English version Microsoft Windows Vista English version Microsoft Windows 7 English version Conversion source Excel book Excel 95 English version 20 2 3 Utility Data conversion function uses MXComShConv exe stored in the following folder User specified folder 1 Sheet MXComShConv exe 1 This will be Melsec when the installation destination folder has not been changed at installation 4 Data conversion function procedure The following indicates the data conversion function procedure Start MXComShConv exe Set the data conversion function in the MXComShConv dialog box pud the conversion log file and check the converted Refer to Section 20 3 ata Start the new Excel book and check the cell settings Refer to Section 20 4 Start the Communication Setup Utility and conduct a Refer to MX Component communication test on the new logical station number Operating Manual Completion Refer to Section 20 2
40. setting Set when operation is to be performed when the device value is within the specified Value setting range Word device 6 CELL SETTING MELSOFT 5 Value Enter the values used for Condition Setting range 32768 to 32767 lt When Range has been set in Condition gt When Range has been set in Condition enter the values in Value as shown below Word Devic e Device D Condition Range v Value ENS Enter the upper limit value of the range Enter the lower limit value of the range 6 CELL SETTING MELSOFT 6 2 5 Setting of the Handshake tab This section describes the setting of the lt lt Handshake gt gt tab for use of the logging function In the lt lt Handshake gt gt tab set the handshake requesting source and handshake processing 1 lt lt Handshake gt gt tab Cell Settings Logging function Set Handshake Start with the request from the PLC C Start with the request from the PC Responding device on the PC side Bit Device Value ON v Word Device 0 e Device M100 E i Monitoring i itime Requesting device 2 Collecti vrite 10 on the PLC side Bit Device Word Device Device Condition Ahen ON v Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CS Logging Logging function Logging 1 Modem_ Settings Settings Settings Settings Mandatory Settings Notset Setalready OK
41. the Operation Interval 6 63 6 5 5 Setting of the Device Trigger tab oe tee exe ec o Pede te pec iet Eee duce Pee ene ae exu one rues ee xu 6 64 6 6 When Comment Is Selected tere been etie bo eb peu Dee edem ns eem exitu nebst etat 6 65 6 6 1 Setting of the 25 a P 6 66 6 6 2 5et ng or iecACCess Data ARAB BANA tcd lu PvE pecu den 6 67 6 6 3 Setting of the Comment Data tab nnnn aaa nnn nnns 6 69 6 6 4 Setting of the Operation Interval tab lllssseeeeeesissseseeeee nennen nennen nennen nnn nnne nnns 6 72 6 6 5 Setting of tne Device Trigger Eu et eee leet aac uae 6 73 0 6 6 Setting or the Handshake 6 74 7 AUTOMATIC SAVE SETTING T 1to 7 9 7 1 Operating of Automatic save list Dialog 7 1 7 2 Setting of the Automatic save Dialog BOX ccccccsssssseeeeececeeeesseeeeeecceeeaaseceeeeeesaaaaseeeeeesseeaasseseeeeeesseaas 7 4 8 AUTOMATIC PRINT SETTING 8 1to8 5 8 1 Operating of Automatic print list Dialog BOX ssseeeessessseseeeeee nnne nnnm 8 1 8 2 Setting of the Automatic print Dialog nenne nnns 8 2 10 COMMUNICATION START AND COMMUNICATION END 10 1 to
42. the cell area name in Cell Area Name displays the cell area on the Excel sheet 11 1 11 1 11 1 SHOT COMMUNICATION MELSOFT MEMO In 11 12 CELL EDITING MELSOFT 12 CELL EDITING This chapter describes how to edit the cell area set using MX Sheet 12 1 Cutting the Cell Area This section explains the procedure to delete the settings of the selected cell area and paste them to another cell area 1 Displaying Cut Cell Area dialog box Choose MX Sheet Cut Cell Area from the menu bar 2 Cut Cell Area dialog box Cut Cell Area Cell Area Nee Cancel Cell Area Name Choose the cell area name to be cut can be clicked after the cell area name is selected in Cell Area Name Click on to cut the cell area Used to close the Cut Cell Area dialog box REMARK Paste the cell area after cutting it Refer to Section 12 3 for pasting the cell area 2 1 i21 12 CELL EDITING MELSOFT 12 2 Copying the Cell Area This section explains the procedure to copy the settings of the selected cell area to another cell area 1 Displaying Copy Cell Area dialog box Choose MX Sheet Copy Cell Area 28 from the menu bar 2 Copy Cell Area dialog box Copy Cell Area CeisreaName I Cancel Cell Area Name Choose the cell area name to be cut can be clicked after the cell area name is selected in Cell Area Name Click on to copy the cell area Used to close t
43. to make communication simultaneously Modem communication When communication via modem is to be made by MX Sheet MX Sheet GX Developer and other applications e g user applications utilizing MX Component cannot perform communication simultaneously If simultaneous communication is attempted using MX Sheet GX Developer and other applications a fault such as a communication error telephone line disconnection will occur When making communication via modem using MX Sheet check that GX Developer and other applications do not use modems 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 SAFE IY PRE LOIN arin Se ara ait ent pssst ed penta ED M Ded rr Air etU futi Linse eto dn A 1 CONDITIONS OF USE FOR THE PRODUCT sees mmn rrr riens A 2 COINS MER RR IE EON E CM A 3 Operaung PrecaulloriS s s 352524 0 2 560 etas oi iate to Eo ul cueste A 5 CONTENT eR m T A 13 AVES TRIS 17 Generic Terms and Abbreviations ccccccccscecceccececcecucceccecuececuecauaecuunecuucuuaecsenecsusaunecsunecsenseauseesausensenanaenass A 18 MNT INTUS TES TEMERE A 19 Definitions of Terms sesese em n
44. to Section 6 5 3 Status String set to the device Refer to Section 6 5 3 Elapsed time from when the device turns ON until it turns OFF Refer to 2 Elapsed time Number of times when the device turned from OFF to ON after the start of communication Refer to 3 Number of occurrences 6 CELL SETTING MELSOFT The title display line will not be the target of cell area clear at the start of communication or clear when cell is full When the Cell Area is set at multiple locations the title is displayed for only the Cell Area specified first 2 Add elapsed time check box oet whether the elapsed time from when the device set on the Access Data tab turns ON until it turns OFF will be displayed in the Alarm Summary or not When displaying the elapsed time check the check box The display format is hour minute second Example Display when the elapsed time is 1 minute 25 seconds 0 01 25 When the device is ON at the start of communication the time from when communication starts until the device turns OFF is displayed as the elapsed time 3 Add number of occurrences check box Set whether the number of times when the device set on the Access Data gt gt tab turns from OFF to ON after the start of communication will be displayed in the Alarm Summary or not When displaying the number of occurrences check the check box In this case the Clear cell area at the start of communication check box must ha
45. to be monitored Number of set devices The number of devices currently set is displayed Preset cell areas The settings of the cell areas preset to the Excel book are displayed Section 6 2 1 1 Remote password is displayed when the logical station number selected in Logical Station Number of the lt lt Access Data gt gt tab is the one for the password function compatible module 2 Detailed explanation The setting of the lt lt Access Data gt gt tab for use of the monitor function is the same as that of the lt lt Access Data gt gt tab for use of the logging function Refer to Section 6 2 2 for details 6 CELL SETTING MELSOFT 6 3 3 Setting of the Operation Interval tab This section describes the setting of the lt lt Operation Interval gt gt tab for use of the monitor function In the lt lt Operation Interval gt gt tab set the day time and time zone of the activation of the function for the cell area 1 Operation Interval gt gt tab Cell Settings Monitor function Set the Operation Interval _ Operation Daily C Weekly Monthly day r r Operation Regular interval Minutely Hourly C Time table HH time zi z Telephone line connectivity time zone C Be in connected state always from the start of the communication Connect during the specified time zones only G Connect each time dep
46. v Search Programs and Features Control Panel Home Uninstall or change a program View installed updates To uninstall a program select it from the list and then click Uninstall Change or Repair dy Turn Windows features on or Organize v Publisher um Microsoft NET Framework 4 Client Profile m Microsoft NET Framework 4 Extended a Microsoft Office Professional Plus 2010 8 Microsoft Visual Studio 2010 Tools for Office Runtime x86 MSXML 4 0 5 2 KB954430 MSXML 4 0 5 2 KB973688 Microsoft Corporation Microsoft Corporation Microsoft Corporation Microsoft Corporation Microsoft Corporation Microsoft Corporation Installed Or 3 30 2011 3 30 2011 3 30 2011 3 30 2011 12 22 2010 12 22 2010 Component 3 30 2011 n Sheet 3 30 2011 7 7 Currently installed programs Total size 392 MB 20 programs installed Check if the Add or Remove Programs screen or the Uninstall or a change a program screen displays the required NET Framework and the related module 3 Execution of MXShRegRCom exe After installing NET Framework and the related module execute MXShRegRCom exe in the folder where MX Sheet has been installed CAMELSECSheetV when the installation location folder was not changed at installation When the user account control is enabled the following screen appears Click or Yes lt Windows Vista gt lt Windows 7 g
47. warning message The user account control function has been added to Windows Vista and Windows 7 By this function a warning message appears when executing Excel with Administrator authority Refer to Chapter 4 lt Windows Vista gt Windows 7 r r User Account Control y User Account Control CC 4 Do you want to allow the following program from an CC Y unknown publisher to make changes to this computer If you started this program continue Program name EXCEL EXE xz Microsoft Office Excel lass Microsoft Corporation P File origin Hard drive on this computer WW Details j Show details Yes E 2 User Account Control helps stop unauthorized changes to your computer Change when these notifications appear APP 15 APP 15 APPENDICES MELSOFT Appendix 8 2 Methods for preventing the warning message The user account control UAC function prevents a crash e g prevention of start up of a program which executes unintended operation Before setting this function grasp that the security function offered by UAC will be disabled and fully understand the risk The following two methods are available for preventing a warning message 1 Disabling the user account control function The following shows a procedure for disabling the user account control function Internet fi 1 Select Start Control Panel Internet Explorer my
48. 0 0 18 0 2002 08 02 10 53 04 41 0 0 0 0 19 0 2002 08 02 Fri 10 53 05 42 0 0 0 0 M 20 0 21 I4 4 WNSheet1 Shestz Sheets TE gt i Sheet1 Sheet2 Sheets X ErrorLog Is BEES F NUM pe 7 Ready re NUM E 1 OVERVIEW MELSOFT 6 Improvement of operability by buttons By creating buttons the Start Communication End Communication and 1 Shot Communication functions can be executed by merely clicking the corresponding buttons Operability is improved as compared to the execution of the functions from the menu Example Start Communication Mz Sheet M Help Cell Automatic Save Setting k After displaying the MX Sheet menu Automatic Print Setting O9 select the Start Communication Automatic Communication Startup Sekking amp Start Communication 1 5 Communication s Cut Cell 4reafTi Start Communication Copy Cell Area c Delete Cell Area D Change Sheet Create Butbont yy k Protect Mx Sheet 1 Setting Data Version Info gwi 2 SYSTEM CONFIGURATION MELSOFT 2 SYSTEM CONFIGURATION The system configuration for MX Sheet is the same as that for MX Component Version 3 For details refer to the MX Component Version 3 Operating Manual 2 1 Operating Environment The following table indicates the operating environment of MX Sheet Description IBM PC A
49. 15 18 2002 06 26 Wed 18 15 19 2002 06 26 Wed 18 15 20 2002 06 26 Wed 18 15 21 2002 06 26 Wed 18 15 22 2002 06 26 Wed 18 15 23 m By computer _ 2 Convenient use of HTML file The data collected by MX Sheet can be snapshot monitored from a business destination office or other place via the Internet intranet with the plant side personal computer personal computer where MX Sheet is operating used as a Web server Web server VAL Plant conditions can be HTML file is created Internet by automatic save Intranet MX Sheet is snapshot monitored from function of MX Sheet unnecessary office and business destination APP 14 APP 14 APPENDICES MELSOFT 3 Continuous operation when saving data automatically in HTML format Do not operate MX Sheet continuously when the Automatic save function is set to save data in HTML format For operating MX Sheet continuously exit and reactivate Excel periodically If data are saved repeatedly in HTML format with the Automatic save function Excel may not operate properly The time for allowable continuous operation differs according to the operating environment APPENDIX 8 Warning Message Appears on Windows Vista and Windows 7 Appendix 8 1 Overview of
50. 2 6 No of lines to be saved Set the number of lines to be saved Set the file name to save a Preset cell areas The settings of the cell areas preset to the Excel book are displayed Section 6 2 1 2 Detailed explanation The setting of the lt lt CSV Logging gt gt tab for use of the monitor function is the same as that of the lt lt CSV Logging gt gt tab for use of the logging function Refer to Section 6 2 6 for details 6 CELL SETTING 6 4 When Write Is Selected MELSOFT This section describes the Cell Setting dialog box when Write is selected from Use of the lt lt Use gt gt tab lt lt Use gt gt tab Cell Settings Write function Access Data Operation Interval Device Trigger Handshake Use Write m Cell Area Name Cell Area 82 05 7 Setthe Color of Grid line B Setthe Color for Filing 8 Clear cell area at the start of communication Left to Right function Cell Display Direction Cell Area Name Logical Sta Operation Interval Device Trigger Handshake CSV Logging Write function i 1 Modem Settings Settings Settings Mandatory Settings Notsel Setalready Optional Settings Setalready Operation Interval tab Cell Settings Write function Use Access Data Device Trigger Handshake Set the Operation Interval Operation Daily C Weekly day Monthly r r r r r r Operation Regular interva
51. 20 2 20 DATA CONVERSION FUNCTION MELSOFT 20 2 Operation Procedure of MXComShConv exe This section explains the operation procedure of MXComShConv exe used for the data conversion function 1 Install MX Component and MX Sheet into the personal computer where MX Links and MX Chart have been installed Set various settings of MX Links and MX Chart correctly 2 Double click MXComShConv exe stored in the File Edit View Go Favorites Tools Help e fa X Back EGET Up Cut Copy Paste Undo Delete Properties Views fo OWI n g fo d e User S eci ified folder 1 Sheet Folders p EC Mel File Folder 7 31 02 8 08 PM CI 256KB Application 7 30 02 6 05 PM M XCo m S h Co nv E exe HI Celink 144KB Application Extension 7 30 02 6 04 PM 8 Common gt MXShE 18KB Application Extension 7 30 02 5 49 PM H MXShEnan exe 112KB Application 7 30 02 6 06 PM kA Ca DNaviPlus MxShMenu dll 4KB Application Extension 7 16 02 11 02 4M 1 a This will be Melsec when the installation aL isi 16 MxShMenusla 358KB Microsoft Excel Add In 7 27 02 3 51 PM GL Easysocket 8 MXSHUtiLocx 588KB OCX File 7 30 02 6 08 PM d 3 emu rink oe ae destination folder has not been changed at 8 3 Mneth amp C installation E Sheet j C Sample zi 1 object s selected 2
52. 20 DATA CONVERSION FUNCTION From the previous page Mz Sheet Lonvert 20 4 Complete Display the Conversion Log File MELSOFT 5 After all data are converted the left dialog box appears Click on to start the conversion log file Check the logical station numbers registered to the conversion log file and the log messages such as the error information that occurred during conversion The conversion log file is saved automatically as a txt file after the data conversion function is executed Refer to Section 20 3 for the save destination and details of the conversion log file Data conversion is complete The new Excel book is saved under the following file name in the same folder as the conversion source Excel book Cnv kkkkkkk XIs LL Conversion source Excel book name After data conversion start the new Excel book and perform a check on the MX Sheet settings and a communication test on the logical station number Refer to Section 20 4 for the precautions on the new Excel book 20 4 20 DATA CONVERSION FUNCTION MELSOFT 20 3 Conversion Log File This section explains the save destination and display data of the conversion log file 1 Save destination of conversion log file The conversion log file is saved in the following folder as a txt file Temporary folder 1 ConvLogMXLinks ToMXCom txt 1 The conversion log file is saved in the following folder when the temporary folder setting h
53. 30 0000002 Communication was completed MN Sheet1 Sheet2 Sheet3 X ErrorLog 4 2m Ready NUM SCRL Item Description 612180 P Explanation The type of the communication status is displayed 2 b The date and time when the communication status is changed are displayed The displayed time is the date and time of the personal computer where MX Sheet is operating Cell Area Name The cell area name where the communication status is changed is displayed The error number of the error that has occurred is displayed The details of the communication status is displayed Contents The error definition error code and corrective action are displayed when an error occurs 2 Details a ErrorLog sheet The following table indicates the ErrorLog sheet specifications Maximum number of display lines 2000 lines fixed New data location The last line has the latest data Operating when cell is full Overwritten in due order starting with the first line 19 1 19 1 19 ERRORLOG SHEET MELSOFT b Kind The following table indicates the communication statuses displayed in Kind Communication Status Status Description Displayed when the communication with the PLC starts and ends Information during 1 shot communication et Displayed when a fatal error occurred and the function of the cell area stopped Warning Displayed when communication error or collection delay occurs c Date Date di
54. 5 166 2 0 0 0 If 0 1 to 0 9 seconds are set to the Regular interval on the Operation Interval gt gt tab the date and time to be written to the CSV file will be in the yyyy mm dd hh mm ss format Example When 0 2 seconds interval is set Datel ime 00 01 08 2004 04 23 10 00 2004 04 23 10 00 2 2004 04 23 10 00 42 2004 04 23 10 00 42 2004 04 23 10 00 72 2004 04 23 10 00 2 2004 04 23 10 00 2 No of lines to be saved oet the number of lines to be saved into a single CSV file Setting range 1 to 9999999 1 1 Set any of 1 to 65535 when using the CSV file on Excel 0 4 3740 10 0 45 0 34 0 56 0 83 U 67 0 8 0 78 0 62 0 89 0 55 1 101 0 4 1 0 3 6 CELL SETTING MELSOFT d File name to save Set the CSV file name to save Description Sets the saving location and file name of the CSV file Adds the date and time data to the file name set in File name to save and saves it In CSV logging data is added until the data in the CSV file reach the number of lines set in No of lines to be saved When they reach the set number of lines a new CSV file is created The following shows the file name when data are saved 20020523183536 csv Add date and time to File name Seconds Minutes Hours Day Month Year File name set in File name to save Adds the file number to the file name set in File name to save and saves it The serial number can be set in a ra
55. 5 14 44 2002 08 01 Thu 15 14 49 2002 08 01 Thu 15 14 54 2 When First Line is selected 2002 05 01 Thu 15 23 24 8 9 2002 08 01 Thu 15 23 19 3j Displayed Contents 1 Add title check box MELSOFT Old data New data New data Old data Set whether the date and time and the title for device name will be displayed or not at the first line of the Cell Area When displaying the title check the check box Display example When Add date and time details is checked and the devices D100 to D103 are set The device name set on the Access Data tab is displayed D100 D101 D102 D103 communication or clear when cell is full e When the Cell Area is set at multiple locations the title is displayed for only the Cell Area specified first Example When the Cell Area on the lt lt Use gt gt tab is set to B2 E4 B6 E8 1 2 5 4 5 h 0 g Date time 20040713 Tue 14 57 25 20040713 Tue 14 57 31 2004 0113 Tue 14 57 35 2004 0213 Tue 14 57 41 204412713 Tue 14 57 45 6 CELL SETTING MELSOFT 2 Add date and time details check box Set whether the logging date and time are added to the cell area set in the Cell Area or not When adding the date and time check the check box In this case the leftmost column of the logging data area is used for the date and time One item of logging data decreases The date and time column displays the date and time of the person
56. 56KB IB My Computer ud MXComShConv v Convertthe communication setting onverting communication setting of Mx Links SVVW3D5F CSKP E ver B or above to communication setting logical station number of MX Component 3 The MXComShConv dialog box appears Set the following items and click on Execute Convert the communication setting Mark the check box when converting the set data of MX Links Convert the MX Chart used in Excel book Mark the check box when converting the set data of MX Chart Progress 0 96 v Convert the MX Chart used in Excel book 5 STi ett E ala z D g teg fite y file and comment file of MX Chart SVV3D5F OLEX E ver amp or above to MX Sheet cell setting Progress Excel Book DocumentsYOLEX xls i ert C tag C name Se L E qu Ww WVI Be COMYerted aurora 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 will be converted automatically E xcel bo O k eue ca Enter the save place and file name of the Excel book to be converted OLEX message 4 The left screen appears during conversion of the Excel Status of the tag management process is abnormal Start the tag management book for MX Chart process correctly before Excel A Click on OK To the next page 20 3 20 3
57. 9 48 49 Line 2 stop Warning 2002 07 02 Tue 15 04 37 29 Generation 2002 07 04 Thu 19 48 54 Equipment 2 emergency stop concemment 2002 07 02 Tue 15 04 38 30 Generation 2002 07 04 Tim 19 48 59 Equipment 1 emergency stop concemment 2002 07 02 Tue 15 0439 Restoration 2002 07 04 Tha 19 48 59 Equipment 2 emergency stop concemment 2002 07 02 Tue 15 04 40 32 Generation 200200704 Tim 19 48 59 Line 3 stop Warning 2002 07 02 Tue 15 04 41 5 Eu 2DOE ICT OFITUS SON s 35 Alarm information is displayed by ON OFF of the bit information on MO M4 2002 07 02 Tue 15 04 43 36 2002 07 02 15 04 44 37 Contents M gt MN Logging Monitor Comment Write Alarm Summary i off The vahie of devices DO D4 is displayed at interval of 1second Ready NUM SCRL All commumication setting of this sample program is set up by Logicalstatiommmber 1 Monitor Write Conditioning SheetMonitor Logging Conditioning Sheet Automatic Save Sheet Microsoft Excel Sample2 EMR Microsoft Excel Sample2 Baa Microsoft Excel Sample2 CER 8 File Edit Insert Format Tools Data Window She
58. Area 82 05 Set the Color of Grid line m Set the Color for Filling m cel area the start of communication 6 3 1 ho m 3 e E 6 3 2 Do liie eec ft es Dim sisse a pm eec D300 Data No of cells Dev points In unit Cell Display Direction Left to Right X Real v DEG 0 mp wa LM M E Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CSV Logging Monitor function Monitor 1 Modem Settings Settings Settings Settings Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CSV Logging Monitor function Monitor 1 Modem Settings Settings Settings Settings Mandatory Settings Notset Setalready Optional Settings Motset Setalready Mandatory Settings Motset Setalready Optional Settings Motset Setalready Operation Interval tab Device Trigger tab Cell Settings Monitor function Cell Settings Monitor function Use Access Data Device Trigger Handshake CSV Lagging Req Uu red setti n g Use Access Data Operation Intery Handshake CSV Logging S et as n ecessa ry Set the Operation Interval Set the Device Trigger Operation Daily C Weekly day PIRE Refer to Section EN Refer to Section 6 3 3 m 6 3 4 42 Device 00 Condition Range v Value 100 r r r r r r
59. E EPL 1 OVERVIEW MELSOFT 1 1 Features This section explains the features of MX Sheet 1 Program less and easy setting PLC device data can be collected written by making simple setting without programming MX Sheet Excel Microsoft Excel Book1 xls Cell Settings i File Edit View Insert Format Tools Data Window Sheet M Help ARAY x fe 2121 d 4 100 e KE Mealy hi B2 Date time se Access Data Iperation Interval Use Logging v Cell Area Name Logging Function Cell Area B2611 Set the Color of Grid line m JV Clear cell area at the start of communication New data location Last Line v Display Contents Add title V Add date and time details Date time 2004 07 13 Tue 18 04 26 2004 07 13 Tue 18 04 31 2004 07 13 Tue 18 04 36 2004 07 13 Tue 18 04 41 2004 07 13 Tue 18 04 46 Making simple setting Operation when cellis full To scroll C Display from the beginning without clearing the cell area 2004 07 13 Tue 18 04 51 2004 07 13 Tue 18 04 56 2004 07 13 Tue 18 05 01 2004 07 13 Tue 18 05 06 C Display from the beginning after clearing the cell area PLC device data are displayed on Excel sheet Cell Area Name Logical Sta Operation Interval Device Trigger Handshake CSV Logging a rag ine eS Se 2 Collection write of device data using a wide ra
60. E5 Area set to Sheet 2 0 Ethernet DO 16 bit integer Sheet 1 Excel sheet where device data will be displayed actually Sheet 2 Excel sheet where device data will be collected B C D Line monitor D D5 pp CBC D9 D10 D15 Dip DIF IB D19 E ine A Sheet2 A2 5 2182 LineB Sheet2143 Sheet21B3 Sheet2 C3 ineC zSheet2lA4 Sheet2lB4 Sheet2lC4 LineD Sheet2lA5 Sheet2lB5 Sheet2lC5 0 01 amp 0 N Set Sheet 1 to refer to cells of Sheet 2 APP 12 APP 12 APPENDICES MELSOFT APPENDIX 6 PROCEDURE TO TRANSPORT DATA TO OTHER PERSONAL COMPUTER This section explains the procedure to transport the settings of MX Sheet from a development personal computer to an on site personal computer MX Sheet and MX Component must have been installed in the personal computer where the settings of MX Sheet will be transported Start 1 Start the Communication Setup Utility and execute the export of the communication settings 2 Operation on development personal computer Copy the following files to the on site personal computer Excel book of MX Sheet Export file of Communication Setup Utility Start the Communication Setup Utility and import the export file created on the development personal computer 2 Operation on on site personal computer N z Start the Excel book of MX Sheet and recheck the settings Completion 1 The Excel book for MX Sheet should have
61. EN E 10 14 Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CSY Logging Comment display Comment 1 Modem Settings Settings Settings Mandatory Settings Motset Setalready OK Cancel Optional Settings Notset Setalready m Detailed Item Description l Explanation Select the logical station number required for making Logical Station Number mE communication COP IAE E Used to start the Communication Setup Utility to set a new logical Section 6 2 2 station number and change the settings Enter the password when the password has been set to the Remote password 1 d hos target PLC la Aceessdat data Set the devices use for the comment display function Qm Number of set devices The number of devices currently set is displayed Section 6 2 2 Preset cell areas The settings of the cell areas preset to the Excel book are displayed Section 6 2 1 1 Remote password is displayed when the logical station number selected in Logical Station Number of the lt lt Access Data gt gt tab is the one for the password function compatible module 6 CELL SETTING MELSOFT 2 Detailed explanation With the exception of the following items the setting of the lt lt Access Data gt gt tab for use of the comment display function is the same as that of the lt lt Access Data gt gt tab for use of the logging function Refer to Section 6 2 2
62. ES MELSOFT From preceding page Je 3 Select User Accounts Control Panel Home User Accounts em and Maintenance Change your account picture e Add or remove user accounts Security Change your Windows password Network and Internet Windows CardSpace Hardware and Sound Manage Information Cards that are used to log on to online services Programs Mobile PC User Accounts Appearance and Personalization Clock Language and Region Ease of Access Additional Options Classic View r e O H gt Control Panel User Accounts User Accounts v 4 Search LL OMNEA O OSANENO eee Tasks 4 Select Turn User Account Control on or off Make changes to your user account Create a password reset disk Manage your network Change your password passwords Remove your password Manage your file encryption Change your picture rtificates certificate e Change your account name Configure advanced user pionie piopeities e Change your account type Change my environment variables e Manage another account e Turn User Account Control on or off r 27 CETTNA 5 Deselect Turn on User Account Control UAC to Turn on User Account Control UAC to make your computer more secure m ake yo u r com puter m ore secu re User Account Control UAC can help prevent unauthorized changes to your computer We recommend th
63. EU XB o amp x 20 7T Aral G1 Y f A B C D Kind Cell Area Name ErrorNo Contents Informatior 2002 08 01 Thu 16 18 11 0000000 Communication was started Informatior 2002 08 01 Thu 15 18 41 0000002 Communication was completed Informatior 2002 08 01 Thu 16 23 06 0000000 Communication was started Warning 2002 08 01 Thu 16 23 12 a e1000035 Not able to display the collection data since the cell is under editing The corrective action is as follows Close editing of cell Closing the dialog message box displayed in the Excel Informatior 2002 06 01 Thu 16 24 05 0000002 Communication was completed Informatior 2002 08 01 Thu 15 43 17 0000000 Communication was started Error 2002 08 01 Thu 16 43 21 Logging function e1000020 Communication error has occurred in the connection disconnection of telephone line lt O0010003 Hex f202640b Hex gt There was a communication failure Following causes can be considered depending on the status Communication time over Break in cable the specified port not supported mistake in specifying the COM port Modem s power is switched OFF The corrective action is as follows Check whether the cable is broken Check whether the specified port is not supported Check whether correct COM port is set Check if the modem power is switched OFF For detailed troubleshooting please refer to the details of the error code 180840b Hex 8 lt ErrorCode f202840b Hex gt 9 Informatior 2002 08 01 Thu 15 43
64. First Second Third Fourth Fifth Sixth 60s 60s 60s 60s 60s Time Device data collection is executed 6 19 6 CELL SETTING MELSOFT b When using communication other than modem communication Log only during the specified time zone 1 Setting example The following setting example shows that logging is performed in the specified time zone only Cell Settings Logging function Set the Operation Interval Operation Daily Weekly Sunday Monthly Day 2 NL Set the Operation Interval Marked uesday Wednesday E Operation day ee Weekly Marked NE LUN 21 Friday Marked feet Regular interval Minutely 7a Mi Time table Operation time E E Hourly 0 minutes Logging Time zone Logging Time zone Log only during the specified time zone Marked ere 10 BE i ow m c Time zone 10 00 to 13 00 F Logical Sta Operation Interval Device Trigger Handshake CSV Logging Settings Settings Settings Cell Area Name Use Logging function Logging 1 CPU_COM Settings Mandatory Settings Motset Setalready Optional Settings Motset Setalready 2 Operation timing The following shows the operation timing in the setting example Every Friday 9 00 10 00 11 00 12 00 13 00 14 00 Time Device data collection is executed Device data collection is not executed 6 20 6 CELL SETTING MELSOFT c When using modem
65. Friday 17 00 Set the DeLogical Sti Device The bit Condition Password No settings Clear cell Specify the cell area name Settings Logging function Print Area Sheet name to print Specify the Sheet 86 lt Automati Automatic Communication Startup Settings d 87 Settings SETBook1 Ready NUM 2 17 2 17 SETTING DATA EXPORT MELSOFT a Cell Setting The settings of the sheet name and cell setting are displayed b Automatic Save The settings of automatic save are displayed c Automatic Print The settings of automatic print are displayed d Automatic Communication Startup The settings of automatic communication startup are displayed 17 3 17 3 18 SAMPLE PROGRAMS MELSOFT 18 SAMPLE PROGRAMS This chapter describes the sample programs registered at MX Sheet installation 1 Sample programs a Sample programs The sample programs are attached for reference when creating user programs Please use them on customer s own responsibility b Logical station number 1 is assigned to all sample programs as logical station number by default To use the sample programs make the settings for the logical station number 1 or assign other logical station number and make the setting for the number 2 Sample program list The following table indicates the sample programs Sample1 xls Sample2 xls that are registered by choosing User specified folder Sheet Sample at MX Sheet installation Sample Program
66. ILITY FOR ANY INJURY OR DEATH TO PERSONS OR LOSS OR DAMAGE TO PROPERTY CAUSED BY the PRODUCT THAT ARE OPERATED OR USED IN APPLICATION NOT INTENDED OR EXCLUDED BY INSTRUCTIONS PRECAUTIONS OR WARNING CONTAINED IN MITSUBISHI S USER INSTRUCTION AND OR SAFETY MANUALS TECHNICAL BULLETINS AND GUIDELINES FOR the PRODUCT Prohibited Application Prohibited Applications include but not limited to the use of the PRODUCT in e Nuclear Power Plants and any other power plants operated by Power companies and or any other cases in which the public could be affected if any problem or fault occurs in the PRODUCT 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 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
67. If the sheet name is changed from the VBA program delete the program part that changes the sheet name 13 1 13 CHANGING THE SHEET NAME MELSOFT MEMO 13 2 13 2 14 CREATE BUTTON 14 Create Button MELSOFT The following explains the Start Communication End Communication and 1 Shot Communication execution button creation procedures and the property setting By merely clicking the created button Start Communication End Communication or 1 Shot Communication operation can be performed and easily operated 14 1 Start Communication Button Create the button for execution of Start Communication and paste it to an Excel sheet 1 Button pasting method Microsoft Excel Book1 xls File Edit View Insert Format Tools Data Window Sheet M Help X BF x CelsetinaQ mE mam 2 10 CHEFS SAW 2 Automatic Save Setting K Automatic Print Setting O Automatic Communication Startup Setting A H a 1 2 Start Communication B 3 4 gae 5 1Shot Communication S 5 Cut Cell Area T 7 Copy Cell Area C 8 9 10 Delete Cell Area D 11 Change Sheet Name N 12 13 Create Button W 4 Start Communication Button B End Communication Button E Protect Sheet setting R 15 9g 1Shot Communication Button S Options D 18 Setting Data Export X Version Info V 2 MXShBtnStart a 14 1 1 2
68. Local Policies Audit Policy User Rights Assigr T Security Options j Windows Firewall witl Public Key Policies Software Restriction F 3 IP Security Policies or Policy Network security LDAP client signing requirements bie Network security Minimum session security for NTLM SSP based including secure RPC clients bie Network security Minimum session security for NTLM SSP based including secure RPC servers be Recovery console Allow automatic administrative logon bie Recovery console Allow floppy copy and access to all drives and all folders 1 Shutdown Allow system to be shut down without having to log on bie Shutdown Clear virtual memory pagefile ie System cryptography Force strong key protection for user keys stored on the computer bie System cryptography Use FIPS compliant algorithms for encryption hashing and signing bie System objects Require case insensitivity for non Windows subsystems bie System objects Strengthen default permissions of internal system objects e g Symbolic Links 2 System settings Optional subsystems System settings Use Certificate Rules on Windows Executables for Software Restriction Policies bic User Account Control Admin Approval Mode for the Built in Administrator account 28 User Account Control Behavior of the elevation prompt for administrators in Admin Approval Mode Prompt for consent p bie User Account Control Behavior of the elevation prompt f
69. M5 Ul Gothic Effects Tp cuNSimSun c Strikeout underline Tp ocmPMingLill Tp SimHei Sample Tp SimSun AaBbYyZz 14 4 14 4 14 CREATE BUTTON MELSOFT When the button was created or any property was changed save the Excel book Do not execute Grouping Ungroup from the right click menu of the button Executing Ungroup will disable the button from functioning e If the font size is set on the lt lt Font gt gt Tab of the property a value error different from the set font size may be displayed when the lt lt Font gt gt Tab is displayed next time Example When the font size is set to 8 8 25 will be displayed next time e f Split Freeze Panes or New Window in the Window menu is executed for the Excel sheet where buttons have been placed correct operation may not be performed e g the buttons remain displayed or the buttons cannot be clicked e fthe zoom of Excel is set to a large magnification the button may be displayed above the row column number When this phenomenon has occurred click the button The button will then move to the correct position Microsoft Excel Book1 xls Vi Insert Format Tools Data Window MX Sheet M Help 46a x 2 2 d 4 300 2 arial Bic B i RA S ALI 414 MN Sheeti Sheet2 X Sheet3 ErrorLog Ready e f a button is created in design mode and then the mode
70. MX Sheet Version I MITSUBISHI EA N MELSOFT wp 2 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 WARNING and NCAUTION a rc ae A N T N WARNING Indicates that incorrect handling may cause hazardous conditions resulting in death or severe injury Indicates that incorrect handling may cause hazardous conditions Po A CAUTION resulting in minor or moderate injury or property damage mm mm mm ms cc cm mc ms Q ms me ms mm se ee Note that the NCAUTION 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 keep this manual in a convenient place so that you can refer to it and always forward it to the end user Design Instruction
71. N Excel 2007 OR LATER FOR WHICH AUTOMATIC COMMUNICATION STARTUP HAS BEEN SET IS OPENED APP 21 APPENDDSO9 T SIUSIOFIS reses druide ia eee eee ee APP 21 APFENDIX 9 2 EE APP 21 APPENDIX 9 9 COM CCUVE os Street utr a duro hound ao dette Debe ad APP 22 APPENDIX 10 ADDED EXTENDED FUNCTIONS iix itn dt mnt nts Sag ito tt c tt nuc c eben e stus APP 27 INDEX Index 1 to Index 2 Manuals The following manuals are relevant to for 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 Introduction SH 080347E Explains the installation method function outlines and operation methods of MX Sheet Version 1 13JU34 Sold separately MX Component Version 3 Operating Manual SH 0800271 Explains the setting and operation methods of each utility on MX Component Sold separately 13JU32 MX Component Version 3 Programming Manual SH 080272 Explains the programming procedures details and error codes for ACT control Sold separately 13JF66 Note The MX Sheet Version 1 Operating Manual Introduction is stored on CD ROM of the corresponding software package in PDF format Any of the manuals is available separately in printed form Please indicate its manual number model code in the above table when ordering the printed manual Generic Terms and Abbreviations Unless
72. PP 10 APP 10 APPENDICES MELSOFT 2 Communication efficiency and access data setting When one type of device is set as multiple devices the efficiency of communication with the PLC decreases The following setting example indicates the case where one type of device is specified consecutively lt Setting example gt Maximum value Minimum value Current value OO HII a Inefficient setting If the above setting example is divided into three access data as indicated below MX Sheet recognizes them as three types of devices and executes communication decreasing communication efficiency of o pem nete James zoom reete Dev pint Cs nee i 3 p eee s 2 joce 1 h h wes b Efficient setting If the above setting example is integrated into one access data as indicated below MX Sheet recognizes it as one type of device and executes communication improving communication efficiency Lope meme quie este pene Pipe see ioe m Any of the following settings prevents the improvement of communication efficiency even if efficient setting has been made 1 When Data Type has been set to Bit the device number setting of Device is not a multiple of 16 2 CN200 current value of 32 bit counter device or later of the FXCPU has been set APP 11 APP 11 APPENDICES MELSOFT 3 Communica
73. Right Cell Display Direction Write data are set from left to right in the specified cell area in order Top to Bottom Write data are set from top to bottom in the specified cell area in order 6 CELL SETTING MELSOFT 2 Detailed explanation With the exception of the following items the setting of the lt lt Use gt gt tab for use of the write function is the same as that of the lt lt Use gt gt tab for use of the logging function Refer to Section 6 2 1 for details a The Cell Area Set the cell area to be used by the write function 1 Setting examples Refer to Section 6 2 1 for the Cell Area setting examples 2 Setting ranges The following indicates the possible setting ranges of the cell area and number of specified cell areas Number of cells 2000 Number of specified cell areas 16 b Cell Display Direction Set the written data cell sequence 1 When Left to Right is selected When cell area B2 D5 is set to Left to Right Cell sequence is set in order of 1 to 12 2 When Top to Bottom is selected When cell area B2 D5 is set to Top to Bottom gt Cell sequence is set in order of 1 to 12 6 CELL SETTING MELSOFT 6 4 2 Setting of the Access Data tab This section describes the setting of the lt lt Access Data gt gt tab for use of the write function In the lt lt Access Data gt gt tab set the logical station number required for communication with the PLC and
74. Section 6 4 Set when using the alarm summary function Section 6 5 Set when using the comment display function Section 6 6 6 CELL SETTING 6 2 When Logging Is Selected MELSOFT This section describes the Cell Setting dialog box when Logging is selected from Use of the lt lt Use gt gt tab lt lt Use gt gt tab Cell Settings Logging function Access Data 9 peration Interv al Device Trigger Handshake CSV Logging Logging Cell Area Name L 89ina function mee Set the Color for Filing Clear cell area at the start of communication Last Line Add title Add date and time details New data location Display Contents Operation when cellis full To scroll Display from the beginning without clearing the cell area C Display from the beginning after clearing the cell area r Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CSV Logging Logging function Logging 1 Modem_ Settings Settings Settings Settings Mandatory Settings Mot set i Setalready Optional Settings Notset Setalready OK Cancel lt lt Operation Interval gt gt tab Cell Settings Logging function Use Access Data evice Trigger Handshake CSV Lagging Set the Operation Interval Operation Daily Weekly day Iu C Monthly p D D r Operation Regular interval Minutely Second 4 C Hourly C Time table time 5 s
75. Settings Motset Setalready Detailed Item Description Explanation Set Handshake Handshake Set when using a handshake a Requesting source setting Set the requesting source of the handshake Section 6 2 5 b Handshake processing Set the handshake processing Preset cell areas The settings of the cell areas preset to the Excel book are displayed Section 6 2 1 2 Detailed explanation The setting of the lt lt Handshake gt gt tab for use of the write function is the same as that of the lt lt Handshake gt gt tab for use of the logging function Refer to Section 6 2 5 for details 6 CELL SETTING 6 5 When Alarm Summary Is Selected MELSOFT This section describes the Cell Setting dialog box when Alarm summary is selected from Use of the lt lt Use gt gt tab lt lt Use gt gt tab Cell Settings Alarm summary function ccess Data Alarm Data Operation Interval Device Trigger Use Alarm summary m Alarm summary function Cell Area Name Cell Area 82 6 7 Setthe Color of Grid line B Setthe Color for Filing JE Clear cell area at the start of communication New data location Last Line X Display Contents Add title Add elapsed time Add number of occurrences Operation when cellis full To scroll Display from the beginning without clearing the cell area C Display from the beginning after clearing the cell area Bi et Save to file Cell Area
76. T Pentium 200MHz or higher 1 IBM PC AT compatible personal computer installed with compatible 2 Computer applicable OS personal computer PC CPU module MELSEC Q series compatible PC CPU module CONTEC CO LTD 64MB or more System Software Required Exce 1 2 3 4 5 6 T 8 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 m Microsoft Windows 2000 Professional Operating System English version Microsoft Windows XP Professional Operating System English version Microsoft Windows XP Home Edition Operating System English version Microsoft Windows Vista Home Basic Operating System English version Microsoft Windows Vista Home Premium Operating System English version Microsoft Windows Vista Business Operating System English version Microsoft Windows Vista Ultimate Operating System English version Microsoft Windows Vista Enterprise Operating System English version Microsoft Windows 7 Starter Operating System English version Microsoft Windows 7 Home Premium Operating System English version Microsoft Windows 7 Professional Operating System English version Microsoft Windows 7 Ultimate Operating System English version or Microsoft Windows 7 Enterprise Operating System English ve
77. TION FOR ERRORS OCCURRED WHEN Excel 2007 OR LATER FOR WHICH AUTOMATIC COMMUNICATION STARTUP HAS BEEN SET IS OPENED When an Excel book for which automatic communication startup has been set is opened with Microsoft Excel 2007 or later the following situations may occur refer to Chapter 9 Appendix 9 1 Situations Excel does not respond Either of the following errors occurs MXShtngn X Microsoft Visual Basic Ex MxShComninitialiset Error cOO00102 800ac472 m i Can t execute code in break mode Appendix 9 2 Error Cause The errors occur if the following three conditions are met 1 MX Sheet Version 1 08J or later is used 2 An Excel book for which MX Sheet automatic communication startup has been set is opened 3 An Excel book is opened with Microsoft Excel 2007 or later APP 21 APP 21 APPENDICES MELSOFT Appendix 9 3 Corrective Action Take an action in the following flow Is MX Sheet Version 1 10L or Check the version by selecting MX Sheet Version Info on Excel earlier used Yes No Obtain data for the update from your local representative Update MX Sheet Is Windows XP SP2 or earlier or Set cr said used Check the Service Pack for the operating environment Yes Install the required Service Pack Check the NET Framework and the related module not yet installed and install it Refer to 1 Insta
78. TUP SETTING This chapter describes the settings for starting communication with the PLC automatically at the start of the Excel book 1 Displaying Automatic Communication Startup setting Disabled dialog box Choose MX Sheet Automatic Communication Startup setting from the menu bar 2 Dialog boxes a Dialog boxes for Automatic Communication Startup setting When the automatic communication startup setting has not been set to the Excel book being edited the following dialog box appears MX Sheet Automatic Communication Startup setting of the Excel Workbook currently open will be done Is it Click on to set the automatic communication startup setting to the Excel book being edited When the automatic communication startup setting has been made communication with the PLC is started automatically at the start of the set Excel book As the following dialog box appears click on OK MX Sheet Automatic Communication Startup setting was done to the Excel Workbook currently open Please reload the Excel Workbook in order to enable the settings After editing the Excel book restart the Excel book to make the automatic communication startup setting valid b Automatic Communication Startup Disabled dialog box When the automatic communication startup setting has been set to the Excel book being edited the following dialog box appears MX Sheet iex Automatic Communication Star
79. Use gt gt Tab When Logging is selected and Add date and time details is checked on the lt lt Use gt gt Tab e When Alarm Summary is selected on the lt lt Use gt gt Tab e When Character string is specified as the Data Type on the lt lt Access Data gt gt Tab e When HEX is specified as the Value on the lt lt Access Data gt gt Tab A 7 Precautions on editing cells and Excel sheets 1 Save function If either of the following settings has been made to the Excel book where the ActiveX controls and forms have been applied continuous operation of the personal computer will cause insufficient memory If insufficient memory has occurred shut down the personal computer periodically e Save function of MX Sheet automatic save function or save is performed when cell is full e Save function is called in a VBA program Excel 2007 or later may require much time to save a Book than Excel 2003 or earlier For expected time refer to APPENDIX 3 4 Changing of Excel sheet name When changing the sheet name of the Excel sheet where MX Sheet has been set change it from MX Sheet Change Sheet Name It can also be changed from the toolbar icons or a right click of the mouse If the sheet name is changed directly from Excel or from a VBA program MX Sheet will not operate normally If this happens due to sheet name change set the previous sheet name again ErrorLog sheet a Setting of sheet protection w
80. Utility of MX Component with Administrator authority and make setting change the setting Execute the Communication Setup Utility with administrator authority from Excel for setting changing Execute Excel with Administrator authority and make setting change the setting When executing Excel with administrator authority the operations such as opening the file by dragging and dropping cannot be executed o MX Sheet MENU SELECTION METHOD 5 MX Sheet MENU SELECTION METHOD MELSOFT MX Sheet can be operated from the menu bar toolbar icons and right click of the mouse When using Excel 2007 or later operate from the ribbon This chapter describes the displaying method and details of the MX Sheet menu options 1 Displaying method a Using the menu bar Excel 2003 or earlier Choose MX Sheet from the menu bar b Using the toolbar icons Excel 2003 or earlier Choose View gt Toolbars on the menu bar and click on MX Sheet c Using the right click of the mouse opecify the cell area and right click the mouse d Displaying the lt lt Add Ins gt gt tab Excel 2007 or later Choose the Add Ins tab MX Sheet on the ribbon Menu bar Mx Sheet M Help Cell Automatic Save Setting K Automatic Print Setting O Automatic Communication Startup Setting Start Communication B 1Shot Communication S Cut Cell Area T Copy Cell Area C Delete Cell A
81. a When user account control is enabled the E Documents e Computer Management 11 2 2006 9 54 PM J neue E E following screen appears Music fayjInternet Information Services IS Manager 9 4 2007 11 45 AM a ees Click Continue or Yes Folders sh Local Security Policy 11 2 2006 9 56 PM Public fap Memory Diagnostics Tool 11 2 2006 9 53 PM fam Print Management 11 2 2006 9 55 PM jM Computer ris Network Reliability and Performance Monitor 11 2 2006 9 53 PM Control Panel ali Services 11 2 2006 9 53 PM S A c3 i n E System Configuration 11 2 2006 9 53 PM lt W d V t gt lt W d 7 gt Administrative Tools S AutoPlay Task Scheduler 11 2 2006 9 54 PM l n OWS IS a l n OWS Backup and Restore EP Windows Firewall with Advanced Security 11 2 2006 9 53 PM r Default Programs User Account Control fj User Account Control Ease of Access Cente gt eb A Fonts Windows needs your permission to continue Do you want to allow the following program from an unknown publisher to make changes to this computer 13 items If you started this action continue Microsoft Management Console Progam name Mi ft Wind Publisher Unknown moons File origin Hard drive on this computer v Details V Show details Yes User Account Control helps stop unauthorized changes to your computer Cha
82. al computer where MX Sheet has been installed 2002 08 01 Thu 15 14 34 a Indicates the time as hours minutes seconds Indicates the day of the week as Sun Sunday Mon Monday Tue Tuesday Wed Wednesday Thu Thursday Fri Friday Sat Saturday Indicates the date as year month day The above date and time can be edited on Excel If the cell setting is edited again after editing on Excel the setting on Excel are invalid 6 CELL SETTING MELSOFT f Operating when cell is full oet the operation to be performed when the cell area is full of logging data When New data location is set for First Line Display from the beginning without clearing the cell area cannot be chosen 1 When To scroll is selected When New data location is set for Last Line Scrolled down 2 When Display from the beginning without clearing the cell area is selected When the cell is full Excel sheet print or Excel book save can also be performed First data Sixth data Data are Second data Second data overwritten beginning with Third data Print or save 2 Third data the first data Excel sheet Fourth data Fourth data Fifth data Fifth data 3 When Display from the beginning after clearing the cell area is selected When the cell is full Excel sheet print or Excel book save can also be performed First data Sixth data Third data Erased when Excel sheet 4 When Print the Excel sheet
83. as not been changed When Windows 98 is used Windows Temp When Windows NT Workstation 4 0 is used Temp 2 Display data of conversion log file With the conversion log file the new logical station numbers and the log messages such as the error information that occurred during conversion can be checked amp j ConvLogMXLinksT oMXCom txt Notepad Links Ladder logic test utility Converted into a logical station number of HX Component MX Links CPU USB utility Channel No 141 Logical station No 8 Converted into a logica Cell Name Logging Name BATCH WORD TAG Not able to convert the logical station number Conversion from logical station number set by tag setting to HX Component s logical Log message during conversion is saved 20 5 20 5 20 DATA CONVERSION FUNCTION MELSOFT 20 4 Precautions on Excel Book after Data Conversion Function Execution After the data conversion function is executed the settings in the Excel book have been converted for MX Sheet This section describes things to be cautioned Be sure to start the Excel book and recheck the settings after executing the data conversion function This section describes the precautions in the following order 1 Precautions logical station numbers 2 Precautions cell areas and sheet names 3 Precautions devices 4 Precautions alarm summary conversion 5 Precautions simple logging conversion 6 Precautions automatic save and aut
84. as preset to the Excel book are displayed Section 6 2 1 2 Detailed explanation The setting of the lt lt Handshake gt gt tab for use of the comment display function is the same as that of the lt lt Handshake gt gt tab for use of the logging function Refer to Section 6 2 5 for details 6 CELL SETTING MELSOFT MEMO 7 AUTOMATIC SAVE SETTING MELSOFT 7 AUTOMATIC SAVE SETTING The following explains the setting contents for saving the Excel book or Excel sheet CSV format during MX Sheet operation hereafter abbreviated to the Automatic save setting data 7 1 Operation of Automatic save list Dialog Box In the Automatic save list dialog box manage the automatic save conditions in the form of a list 1 Displaying Automatic save list dialog box Choose MX Sheet Automatic save list f 2 Automatic save list dialog box Automatic Save List Enable Automatic Save Name End of communication Date time Device Trigger Clear cell area Create New Line1 daily Settings No settings Settings Settings Line2daily No settings No settings Settings No settings LineSdaily Settings No settings No settings Settings Line1 monthly No settings Settings No settings Settings Line2monthly Settings Settings No settings Settings Line3monthly Settings Settings No settings Settings Detailed Item Description Explanation IK K K K K Display a list of automatic save names created in
85. at you leave UAC turned on to help protect your computer F Use User Account Control UAC to help protect your computer Setting completion APP 17 APP 17 APPENDICES 2 Allowing the warning message without showing it MELSOFT The following shows a procedure for allowing a warning message without sh Internet t Internet Explorer E mail Windows Mail urs Welcome Center Backup Status and Configuration Windows Media Player E Small Business Resources pl Windows Fax and Scan g Windows Meeting Space ag Windows Photo Gallery a Windows Live Messenger Download V Paint gt AllPrograms owing it ZA Documents Pictures Music Search Recent Items Computer Network Connect To Control Panel Default Programs Help and Support GO Control Panel gt Classic View Control Panel Home System and Maintenance Get started with Windows Back up your computer Security Check for updates Check this computer s security status e Allow a program through Windows Firewall Network and Internet Connect to the Internet View network status and tasks Set up file sharing Hardware and Sound Play CDs or other media automatically Printer Mouse Programs Uninstall a program Change startup programs Mobile PC Change battery settings Adjust commonly used mobility settings Control Panel Name Category Con
86. ation Regular interval Minutely C Hourly Time table time Telephone line connectivity time zone re Bein connected state always from the start of the communication Connect during the specified time zones only Connect each time depending on the operation interval Cell amp rea Name Use Logical Sta Operation Interval Device Trigger Handshake CSV Logging Comment display Comment 1 Modem Settings Settings Settings Mandatory Settings Motset Setalready 2 Cancel Optional Settings Notset Setalready i 008 Set the telephone line connection timing and disconnection timing Section 6 2 3 a Preset cell areas The settings of the cell areas preset to the Excel book are displayed Section 6 2 1 1 Telephone line connectivity time zone is displayed when the logical station number selected in Logical Station Number of the Access Data gt gt tab is the one for modem communication 2 Detailed explanation With the exception of the following item the setting of the Operation Interval tab for use of the comment display function is the same as that of the Operation Interval tab for use of the logging function Refer to Section 6 2 3 for details a Operation time The setting except for Regular interval is the same as that of the logging function Refer to Section 6 2 3 for the setting except for Regular interval 1 When Regular interval is selected D
87. been created on the development personal computer 2 For the import and export operations of communication settings refer to the MX Component Operating Manual APP 13 APP 13 APPENDICES MELSOFT APPENDIX 7 HTML FILE This section explains the HTML file saved during MX Sheet operation 1 HTML file MX Sheet allows an HTML file to be saved automatically into the folder specified when any of the following functions is used Logging function when cell is full e Alarm summary function when cell is full Automatic save setting D Documents and SettingsDesktop E ae DER File Edit View Favorites Tools Help A gt x a A J Search Sie Favorites media QA Adress Documents and Settings Desktop HTML htm S MX Sheet Factory A D 2002 06 26 Wed 18 14 54 2002 06 26 Wed 18 14 55 2002 06 26 Wed 18 14 56 2002 06 26 Wed 18 14 57 2002 06 26 Wed 18 14 58 2002 06 26 Wed 18 14 59 2002 06 26 Wed 18 15 00 2002 06 26 Wed 18 15 01 2002 06 26 Wed 18 15 02 2002 06 26 Wed 18 15 03 2002 06 26 Wed 18 15 04 2002 06 26 Wed 18 15 05 2002 06 26 Wed 18 15 08 2002 06 26 Wed 18 15 07 2002 06 26 Wed 18 15 08 2002 06 26 Wed 18 15 09 2002 06 26 Wed 18 15 10 8 2002 06 26 VVed 18 15 11 1 3 5 7 9 1113 15 17 19 21 23 25 27 29 2002 06 26 Wed 18 15 12 2002 06 26 Wed 18 15 13 2002 06 26 Wed 18 15 14 2002 06 26 Wed 18 15 15 2002 06 26 Wed 18 15 16 2002 06 26 Wed 18 15 17 2002 06 26 Wed 18
88. book all sheets where automatic print setting has been made is printed automatically 2 Specify the sheet Automatic print is executed for the specified sheet only Multiple sheets can be selected and printed simultaneously 8 AUTOMATIC PRINT SETTING MELSOFT e Register the newly created or edited automatic print setting data When the registration is completed the automatic print name and settings are displayed as described below in the Automatic print list dialog box Display in Automatic print list The automatic print name and settings are additionally displayed at the bottom of the list and enable is checked When automatic print The automatic print name and settings are additionally name is changed displayed at the bottom of the list and enable is checked The automatic print name and settings are displayed in the When automatic print same position of the list name is the same When the settings are changed the new settings are displayed Create New When registering the existing automatic print setting data under a different automatic print name change the automatic print name in the Automatic print dialog box e When multiple printers are set to a single personal computer the Excel sheet where automatic print is set is output from the printer specified to Set as Default in Printers in My Computer 9 AUTOMATIC COMMUNICATION STARTUP SETTING MELSOFT 9 AUTOMATIC COMMUNICATION STAR
89. cal Station Number 1 Modem GJ71C24 X Refe r to S e ct Communication Settings 6 4 1 Data Type No of cells Dev points In unit moo e oC Do liie eec e t Dim wise p pm eec D300 Real mmber Cell Area Name Logical Sta Operation Interval Device Trigger Handshake CSV Logging Write function i 1 Modem Settings Settings Settings Mandatory Settings Optional Settings Mo 1 Setaleady i Setalready lt lt Device Trigger gt gt tab Cell Settings Write function Use Access Data Operation Inters Handshake Required setting Set the Device Trigger Refer to Section 6 4 3 C BitDevice Word Device Device 00 Condition Range v Value 100 gt 200 _CellAreaName Use Write function Write 1 Modem Settings Settings Settings Mandatory Settings Setalready Optional Settings Setalready Set as necessary Refer to Section 6 4 5 Logical Sta Operation Interval Device Trigger Handshake CSV Logging Cancel Apply Required setting Refer to Section 6 4 2 Set as necessary Refer to Section 6 4 4 6 CELL SETTING MELSOFT 6 4 1 Setting of the Use tab This section describes the setting of the lt lt Use gt gt tab for use of the write function In the lt lt Use gt gt tab set the cell area and display directio
90. cation Settings Em integer Y DEC 32bit integer v DEC lt S SS 3 Real mmber Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CSV Logging Logging function Logging 1 Modem Settings Settings Settings Settings Mandatory Settings Notset Setalready Optional Settings Not se Setalready OK Cancel Device Trigger tab Cell Settings Logging function Use Access Data Operation Inter Device Trigget Handshake CSV Logging Set the Device Trigger Bit Device Word Device Device 00 Condition Range v Value 100 gt 200 cone Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CS Logging Logging function Logging 1 Modem Settings Settings Settings Settings Mandatory Settings Notset Setalready Optional Settings Setalready lt lt CSV Logging gt gt tab Cell Settings Logging function Use Access Data Operation Interval Device Trigger Handshake Save as CSV file Contents to save Add Device name to the first line No of lines to be saved 1000 Settings My Documents CSV csv Browse File name to save Add date and time to File name Add sequential number to File name 000 gt 999 C Fix the File name Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CSV Logging Lo
91. cel and then save the file in one of the new file formats Some cells or styles in this workbook contain formatting that is not supported by the selected file format These formats will be converted to the closest format available E E a g g g i LS BE BS Bg Check compatibility when saving this workbook Cancel Copy to New Sheet i Continue 5 Operation guarantee according to version 6 Due to the upgrade the functions of the MX Sheet have been added extended Operate the Excel book where MX Sheet functions are set with the MX Sheet whose version is the same or later than the set MX Sheet for operation guarantee For description of the added extended functions refer to APPENDIX 8 Excel sheet where buttons are placed When the Start Communication End Communication or 1 Shot Communication button placed on the Excel sheet is focused do not log off from Windows or exit from Windows without closing the Excel book To do so will display the following message and disable exit from Excel lll Microsoft Excel Eg 1 Cannot quit Microsoft Excel 7 Size of saved Excel file according to Format Cells On Excel Format Cells increases the saved file size Also on MX Sheet the size of the saved Excel file may become several M bytes or more since Format Cells is changed according to the setting Example e When Set the Color of Grid line or Set the Color of Filling is checked on the lt lt
92. cell area in the order of the numbers shown on the left of the Access Data tab Device data display example Setting example of Access Data gt gt tab Data numbers The device data are displayed on Excel as shown below Displayed in order of data numbers Data No 1 Data No 2 Data No 3 D2 vO wil W2 B2 2 Device Enter the device to be accessed Enter the device name and device number in this order Refer to Section 3 2 for the accessible devices 6 CELL SETTING MELSOFT 3 Data Type Set the data type to be displayed in the cell Available Device The bit devices set in Device are displayed in a single cell in units Bit device Bit of one bit Word device Designated bits for word device set in Device are displayed in a Bit specification single cell in units of one bit e g 00 0 Displayed in a single cell in units of 1 word 16 bits starting with the x1 Bit device 16 bit integer device number set in Device 32768 to 32767 TNR Displayed in a single cell in units of 1 word starting with the device x1 number set in Device Displayed in a single cell in units of 2 words 32 bits starting with x1 32 bit int Bit devi It integer the device number set Device 2147483648 to 2147483647 Word device 1 number set in Device The data of the device number set in Device are displayed in the Bit device 2 Ch S
93. communication 1 Setting example The setting example in the case of modem communication is shown below Cell Settings Logging function Use Access Data d Set the Operation Interval Operation Daily C Weekly C Monthly iid Set the Operation Interval Marked F Operation day z Daily Marked Ei Operation time Operation Reguer interval Sesoni mE Time table Ug 17 Hourly 0 minutes Telephone line connectivity time zone e Connect each time depending A p on the operation interval Marked from the start of the communication C Connect during the specified time zones only Connect each time Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CSV Logging Logging function Logging 1 Modem Settings Settings Settings Settings Mandatory Settings Motset Setalready OK Cancel Apply Optional Settings Motset Setalready 2 Operation timing The following shows the operation timing in the setting example 9 00 10 00 11 00 Time Connection of telephone line Device data collection is executed Los MGE cu Los mda c ape d ar Los Disconnection of telephone line 6 CELL SETTING MELSOFT 6 2 4 Setting of the Device Trigger tab This section describes the setting of the lt lt Device Trigger gt gt tab for use of the logging function In the lt lt Device Trigger gt gt tab set the device c
94. compatible module 6 CELL SETTING MELSOFT 2 Detailed explanation With the exception of the following item the setting of the lt lt Access Data gt gt tab for use of the write function is the same as that of the lt lt Access Data gt gt tab for use of the logging function Refer to Section 6 2 2 for details a Access data The setting except for Zoom is the same as that of the logging function Refer to Section 6 2 2 for the setting except for Zoom 1 Zoom The value entered into the cell is multiplied by the zoom ratio and written to the PLC device When Data Type has been set to Bit or Character string the Zoom setting is not possible When the Value is set to HEX the Zoom setting is not possible Setting range 0 001 to 1000 Excel Set Zoom to 0 1 DO 4000 ti Enter 1000 into cell 100 is written to PLC When Zoom is set for the write data and fractional decimals occurs in the data to be actually written to PLC set Real number in Data type 6 CELL SETTING MELSOFT 6 4 3 Setting of the Operation Interval tab This section describes the setting of the lt lt Operation Interval gt gt tab for use of the write function In the lt lt Operation Interval gt gt tab set the day time and time zone of the activation of the function for the cell area will be activated 1 Operation Interval gt gt tab Cell Settings Write function Set
95. concernment 2002 07 02 Tue 150423 tT The value of Devices D10 D12 are displayed and write to PLC at intervals of 5 seconds Monitor Comment Write 14 Restoration 2002 07 04 Tha 19 47 59 Equipment 2 emergency stop concemment 2002 07 02 Tue 15 04 24 5 15 Restoration 2002 07 04 Tim 19 48 04 Line 2 stop Waming 2002 07 02 Tue 15 04 25 16 Generation 2002 07 04 Tim 19 48 09 Line 1 stop Warning 2002 07 02 Tue 15 04 26 P 17 Restoration 2002 07 04 Thm 19 48 14 Equipment 1 emergency stop concenument 2002 07 02 Tue 15 04 27 e 18 Generation 2002 07 04 Thm 19 48 14 Line 3 stop Warning 2002 07 02 Tue 15 0428 19 Restoration 2002 07 04 Tha 19 48 19 Line 1 stop Warming 2002 07 02 Tue 15 0429 2 20 Generation 2002 07 04 Tim 19 48 24 Equipment 2 emergency stop concernment ove fer ea 2 Gentian 20000794 Te 94529 Era T eration 1 emergency stop _ concermment EET E x E 23 Restoration 20020704 Thu 19 48 29 Equipment 2 emergency stop concemmment E 24 Restoration 2002 07 04 Thu 19 48 34 Line 3 stop Warming 2002 07 02 Tue 15 04 33 13 5 7 9 11 13 15 17 19 21 23 25 27 29 25 Generation 2002 07 04 Thu 19 48 39 Line 1 stop Waring 2002 07 02 Tue 15 04 34 26 Restoration 2002 07 04 Tha 19 48 44 Equipment 1 emergency stop concermment 2002 07 02 Tue 15 04 35 27 Restoration 2002 07 04 TIm 19 48 49 Line 1 stop Warming 2002707702 Tue 15 04 36 Start End 28 Restoration 2002 07 04 Thu 1
96. cters Set the number of characters to be displayed in a single cell Setting range 40 Depending on the value set in No of characters and device data the character strings may not be displayed in the cell The following are the examples of setting 1 to 4 in No of characters Example When displaying the character strings stored in DO to D3 b15 to b8 b7 to bO U J N m Co I When No of characters is set to 1 gt The data is displayed in a single cell in units of 1 word 16 bits Only the character stored in bO to b7 of DO is displayed The character stored in b8 to b15 of DO is not displayed G E DO bO to b7 data is displayed lt When No of characters is set to 2 gt The data is displayed in a single cell in units of 1 word 16 bits The character strings stored in bO to b7 and b8 to b15 are displayed in this order AB GH t DO bO to b7 b8 to b15 data is displayed lt When No of characters is set to 3 gt The data is displayed in a single cell in units of 2 words 32 bits The character strings stored in DO bO to b7 b8 to b15 and D1 bO to b7 are displayed The character string stored in b8 to b15 of D1 is not displayed EFG L DO bO to b7 b8 to b15 and D1 b0 to b7 data is displayed i When No of characters is set to 4 gt The data is displayed in a single cell in units of 2 words 32 bits The character strings stored in DO
97. ctivation 2 c Logging Time zone 1 Set the time zone of the logging activation 2 d a Preset cell areas The settings of the cell areas preset to the Excel book are displayed Section 6 2 1 1 If the logical station number selected in Logical Station Number of the lt lt Access Data gt gt tab is the one for modem communication Logging Time zone is switched to Telephone line connectivity time zone D A Detailed Telephone line connectivity time zone tem escription Explana tio n e Be in connected state always Sets the timing of connection and disconnection of the telephone line from the start of the communication Connect during the specified time zones only Telephone line Connect each time yt s depending on the operation interval connectivity time zone 6 CELL SETTING MELSOFT 2 Detailed explanation a Set the Operation Interval To make the settings of cell area invalid or to use the function of cell area for 1 shot communication only remove the check mark Do not remove the check mark for the case of ordinary operation b Operation day oet the operation day of device data collection 1 When Daily is selected Operation is performed every day 2 When Weekly is selected Operation is performed on the specified day of the week only Multiple days of the week can be set 3 When Monthly is selected Operation is performed on the specified days only If the specifie
98. curs during use of the device trigger decrease the operation interval setting of MX Sheet Example When BO When ON has been set as the device trigger condition operation interval is 60s If the device trigger condition holds for the specified operation time as shown below a data dropout occurs on MX Sheet Device trigger condition is checked at every operation time OFF Condition has held but data collection is not executed since condition does not hold for condition check Data collection is executed when condition holds Note that if a data dropout occurs during use of the device trigger error information is not registered to the ErrorLog sheet APP 7 APP 7 APPENDICES MELSOFT c Data dropout when handshake function is used When the requesting device condition holds for the specified operation time the data to be collected dropouts If a data dropout occurs during use of the handshake decrease the operation interval setting of MX Sheet Example When the PLC side requesting device has been set to MO and the PC side responding device to M100 operation interval is 60s If the requesting device condition holds for the operation time as shown below a data dropout occurs on MX Sheet Requesting device is checked at every operation time ON M100 OFF ON MO OFF Requesting device condition has held but data collection is not executed since condition does not hold fo
99. d 3 After device data is collected the D200 value is changed to 1 4 The D100 value is changed to other than 100 5 The D200 value is changed to 0 6 CELL SETTING MELSOFT c When Start with the request from the PC is selected Device Bit device lt Setting example gt Cell Settings Logging functon C Start with the request from the PLC Set Handshake Marked meo si LM Start with the request from the PC Marked EN of Requesting device on the PC side Bit device Marked I Device M100 Responding device Collectiv tite Value ON Responding device on the PLC side C Word Device o o Bit device Marked Device MO pe Condition When ON Monitoring time 10 seconds Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CSV Logging Logging functon Logging 1 Modem_ Settings Settings Settings Settings Mandatory Settings Notset Setalready Optional Settings Setalready Cancel Apply lt Operation timing gt 4 M100 S v O Requesting device OFF on the PC side 3 Device data collection ON 2 5 Responding device OFF on the PLC side Time out monitoring Monitoring time 1 M100 is turned on 2 When MO turns on processing in 3 is started 3 Device data is collected 4 After device data is collected M100 is turned off 5 MO is turne
100. d day does not exist in some months an alternate day can be specified Number of days that can be set 31 When 15th is set Operation is performed on the 15th every month e g January 15 February 15 March 15 When 31st is set Excepting February April June September and November operation is performed on the 31st every month For February April June September and November set the alternate day and processing in Alternate day when a date does not exist The following table indicates the setting items of Alternate day when a date does not exist Last day of the current month Operation is performed on the last day of February April June September or November First day of the next month Operation is performed on the first day of the next month Operation is not performed in February April June September and November c Operation time oet the operation time of device data collection 1 When Regular interval is selected Device data is collected at the set second intervals When modem communication is used and Connect each time depending is set in Telephone line set 30 seconds or more to Regular interval oetting range 0 1 to 0 9 in units of 0 1 seconds 1 to 3600 in units of 1 second When the date and time are added the date and time displayed on the Excel sheet will be in the yyyy mm dd ddd hh mm ss format if the setting is 0 1 to 0 9 seconds Example When 0 2 seconds in
101. d off Time out monitoring is not executed between 4 and 5 above If the operation in 5 is not performed in the PLC device data collection is not executed when the handshake conditions are satisfied at the next time 6 CELL SETTING MELSOFT d When Start with the request from the PC is selected Device Word device lt Setting example gt Cell Settings Logging functon C Start with the request from the PLC Requesting device Set Handshake Marked voeem vie M vae 0 Start with the request from the PC Marked S Word Device Requesting device on the PC side Device 0200 Word device Marked the bit 0 15 Device D200 Responding device Value 1 left 0 right on the PLC side Bit Device Responding device on the PLC side IDA Word device Marked o EE Device D100 Condition Condition value 100 Value 100 Cell amp rea Name Use Logical Sta Operation Interval Device Trigger Handshake CSV Logging Monitoring time 10 seconds Logging functon Logging 1 Modem_ Settings Settings Settings Settings Mandatory Settings Notset Setalready Cancel Apply Optional Settings Setalready lt Operation timing gt D200 Requesting device on the PC side D100 Responding device on the PLC side Time out monitoring Monitoring time 1 The D200 value is changed to 1 2 When the D100 value reac
102. device trigger Whether the device trigger conditions are satisfied or not is checked at intervals of 1 second 7 AUTOMATIC SAVE SETTING MELSOFT g Device conditions 1 Logical Station Number Choose the logical station number used for the device trigger If the logical station number has already been set the number appears in the list box and can be selected If the logical station number has not been set click on Communication Setting and set a new logical station number 2 Communication Setting button This button is used to start the Communication Setup Utility to set a new logical station number and change the settings oelect Run as administrator when the screen appears asking if execute programs with administrator authority or not After starting the Communication Setup Utility click on and set a new logical station number and change the settings with the Communication Setting Wizard For the detailed explanation of the Communication Setup Utility and Communication Setting Wizard refer to the MX Component Operating Manual 3 Remote password Remote password box appears when the setting of the logical station number selected in Logical Station Number includes information on the connection to the module with the password function When the password has been set to the connection target PLC enter the password It need not be entered when the password has not been set 4 Device type oet the type of th
103. dy Detailed Item Description Explanation Set the Device Set the Device Trigger Set when the device trigger is used Section 6 2 4 a Device conditions Set the device conditions b Preset cell areas The settings of the cell areas preset to the Excel book are displayed Section 6 2 1 2 Detailed explanation The setting of the Device Trigger tab for use of the write function is the same as that of the Device Trigger tab for use of the logging function Refer to Section 6 2 4 for details 6 CELL SETTING MELSOFT 6 4 5 Setting of the Handshake tab This section describes the setting of the lt lt Handshake gt gt tab for use of the write function In the lt lt Handshake gt gt tab set the handshake requesting source and handshake processing 1 lt lt Handshake gt gt tab Cell Settings Write function Set Handshake Start with the request from the PLC Start with the request from the PC Responding device on the PC side Bit Device Value JON E Word Device Device M100 98 e n Monitoring Requesting device D Collect rite o 5 on the PLC side Bit Device C Word Device Device E Condition WhenON when OFF Cell Area Name Logical Sta Operation Interval Device Trigger Handshake CS Logging Write function i 1 Modem Settings Settings Settings Mandatory Settings Notset Setalready 2 OK Cancel Optional
104. e 1 When MO turns on processing in 2 is started 2 Device data is collected 3 After device data is collected M100 is turned on 4 MO is turned off 5 M100 is turned off 6 CELL SETTING MELSOFT b When Start with the request from the PLC is selected Device Word device lt Setting example gt Cell Settings Logging functon Set Handshake Marked Start with the request from the PLC Marked NI Responding device on the PC side Start with the request from the PC Word device Marked y Value 1 Value 10 Device D200 SUES Value 1 left O right EMEN Requesting device on the PLC side hebt 079 mmm Word device Marked Device D100 ee oe CollectArite Con di tion Bit Device Value 100 Word Device E D X X Monitoring time 10 seconds E m Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CSV Logging Logging functon Logging 1 Modem_ Settings Settings Settings Settings Mandatory Settings Notset Setalready Optional Settings Notset Setalready Cancel lt Operation timing gt Responding device 22 on the PC side 2 1 1 1 1 1 1 Device data collection 1 1 1 1 1 1 1 1 Requesting device on the PLC side Time out monitoring Monitoring time 1 When the D100 value reaches 100 processing in 2 is started 2 Device data is collecte
105. e P C side 2 TO 27 bf Timeout Error DO lat chdog time iP side END 6 CELL SETTING MELSOFT 6 2 6 Setting of the CSV Logging tab This section describes the setting of the CSV Logging gt gt tab for use of the logging function In the CSV Logging tab the file name and the saving contents with which logging data is saved to CSV file 1 CSV Logging tab Cell Settings Logging function v Save as CSV file Contents to save Add Device name to the first line No of lines to be saved 1000 File name to save Settings My DocumentsiCS csv Browse Add date and time to File name C Add sequential number to File name C Fix the File name Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CSV Logging Logging function Logging 1 Modem Settings Settings Settings Settings Mandatory Settings Notset Setalready OK Cancel Apply Optional Settings Motset Setalready Detailed Item Description l Explanation 6 CELL SETTING MELSOFT 2 Detailed explanation a b Save as CSV file When using the CSV logging be sure to mark Save as CSV file Contents to save Activate this setting when adding the device name to the first line of the data to be saved into a CSV file Device name is added to first line Datel ime DO DT D 03 D4 2002 07 10 15 97 09 25 1656 2 0 0 0 2002 0 710 15 5 14 2
106. e button for execution of 1 Shot Communication and paste it to an Excel sheet 1 Button pasting method Similar to the Start Communication Button Refer to Section 14 1 1 Choose MX Sheet Create Button 1 Shot Communication Button in the menu 2 Property page starting method Similar to the Start Communication Button Refer to Section 14 1 2 Choose MXShBin1 Shot Control Object Properties in the menu 3 Property setting Set the Caption CellAreaName and Font properties Similar to the Start Communication Button Refer to Section 14 1 3 1 lt lt CellAreaName gt gt Tab The Cell Area Name list displays all Cell Area Names of Logging Monitor Write and Comment in the Excel book Check the check box for the Cell Area Name that will be the target of 1 Shot Communication Up to 10 Cell Area Names can be checked MXShBtn15hot Control Properties Caption CellAreaN ame Fonts Cel rmaName SheetName Use Sheets Manitor Sheets Logging Sheets Write Sheets Comment 14 7 15 PROTECT UNPROTECT MX SHEET SETTING MELSOFT 15 Protect Unprotect MX Sheet setting The following explains Protect MX Sheet setting and Unprotect MX Sheet setting by a password 15 1 Protect MX Sheet setting Protect the MX Sheet setting by a password so that the setting contents cannot be changed The setting contents cannot be edited until the MX Sheet setting is unprotected 1 Displaying Protect MX Sheet s
107. e device ranges of MX Sheet 1 Accessible CPUs The accessible CPUs in MX Sheet are the same as those in MX Component Version 3 For details refer to the MX Component Version 3 Operating Manual 2 Accessible device ranges The accessible device ranges in MX Sheet are the same as those in MX Component Version 3 with the exception of the following item For details refer to the MX Component Version 3 Operating Manual 1 Device extension representation MX Sheet does not allow access to any device by word designation for bit device e g K4X0 K8MO and bit designation for word device e g DO 0 W 01 1 When using MX Sheet Version1 06 G or later device setting by bit designation for word device e g 00 0 is only possible the setting on Access Data gt gt tab 3 Specifying GOT timer contact devices and counter contact devices In the cell settings of MX Sheet Refer to Chapter 6 timer contact devices TT and counter contact devices CT which are the device representation of GOT can be entered The entered TT and CT are automatically changed to TS and CS respectively 4 MX Sheet OPERATION PROCEDURE MELSOFT 4 MX Sheet OPERATION PROCEDURE The following indicates the MX Sheet operation procedure Refer to the MX Sheet Operating Manual Introduction Start Excel and save the Excel book 1 Select the function to be used and make MX Sheet settings Logging function
108. e device used for PC side Word device Bit Word device Bit specification processing is set for ON Word device Bit Word device Bit specification processing is set for OFF Set th f th dd d for PC sid processing LM S Set when the value of the device used for PC side 6 CELL SETTING MELSOFT 2 PLC side processing Device type Set the device type used for PLC side processing Set when a bit device is used for PLC side processing Set when a word device is used for PLC side processing e Device Enter the device used for PLC side processing Enter the device name and device number in this order When specifying the bit use of the word device enter the bit number in the bit e Condition Set the conditions of the device used for PLC side processing Device Bit device device ON Set when the value of the device used for PLC side COEG processing is set for ON Bit Uc TE device device Set when the value of the device used for PLC side Word device e processing is set for OFF Bit specification Set when the PLC side device value is equal to the Value device e Value Set the value of the device used for PLC side processing This can be set only when has been selected in Condition 3 Monitoring time oet the time during which the PC side device monitors the PLC side device oetting range 1 to 3600 The monitoring time changes depending on the re
109. e device used for the device trigger Set when using a bit device for the device trigger Set when using a word device for the device trigger 5 Device Enter the device used for the device trigger Enter the device name and device number in this order 6 the bit oet the corresponding bit of the word device Setting range 0 to 15 7 Condition Set the device trigger conditions Available Device Set when automatic save is to be performed when the bit ET device turns on Set when automatic save is to be performed when the OFF M Word device corresponding bit of the word device turns on value 1 Set when automatic save is to be performed when the bit device turns off ON Set when automatic save is to be performed when the OFF 2 Word device corresponding bit of the word device turns off value 0 When OFF Bit device 7 AUTOMATIC SAVE SETTING h i 0 MELSOFT Clear cell area after automatic save Set whether the data of the cell area selected in the Specify the cell area name will be cleared or not after automatic save is performed To clear the cell area data after automatic save check the check box Specify the cell area name From the list box select the Cell Area Name of the cell area whose data will be cleared after automatic save Multiple names can be selected The list box displays all Cell Area Names set in the Cell Setti
110. e menu the details of MX Sheet set in the Excel book are output to the CSV file After setting data export the following dialog box appears MX Sheet 1 The output af the setting details was completed File name D Documents and Settings My Gocuments SETMs Sheet csv 2 Save destination of CSV file After setting data export MX Sheet saves the CSV file in the folder where the original Excel book is saved Bi My Documents File Edit Favorites Tools Help KJ 4 F Search i Folders ab Address My Documents Folders SETMX Sheet 3 Desktop Microsoft Excel Comma Separ Omm i My Music y MX Sheet B My Pictures Microsoft Excel Worksheet Computer 42 KB J My Network Places Recycle Bin My Pictures My Music 3 File name of CSV file The following indicates the file name of the CSV file SET 65 Excel book name that executed setting data export i223 1723 17 SETTING DATA EXPORT MELSOFT 4 Saved contents of CSV file The following shows the contents of the CSV file saved by the setting data export Bg File Edit View Insert Format Tools Data Window MX Sheet M Help x D c ES 887 5B x 4 Zi iy 100 2 ana E3 5 amp b t amp 1 0 BEF SSA M28 B K ed lt Sheet Na Sheet 1 2 Use Use Cell Area Cell Area New data Operation Print the E Save to file File name Save method z Loggin
111. e setting of the Device Trigger tab for use of the monitor function is the same as that of the Device Trigger tab for use of the logging function Refer to Section 6 2 4 for details 6 CELL SETTING MELSOFT 6 3 5 Setting of the Handshake tab This section describes the setting of the lt lt Handshake gt gt tab for use of the monitor function In the lt lt Handshake gt gt tab set the handshake requesting source and handshake processing 1 lt lt Handshake gt gt tab Cell Settings Monitor function Set Handshake Start with the request from the PLC Start with the request from the PC Responding device on the PC side Bit Device Value v Word Device 0 e ol Device 100 E i Monitoring i Requesting device 2 collectirite s on the PLC side i Bit Device Word Device Device Condition Ahen ON Cell amp rea Name Use Logical Sta Operation Interval Device Trigger Handshake CS Logging Monitor function Monitor 1 Modem Settings Settings Settings Settings Mandatory Settings Motset Setalready OK Optional Settings Motset Setalready Cancel Detailed Item Description Explanation Set Handshake Handshake Set when using a handshake a Requesting source setting Set the requesting source of the handshake Section 6 2 5 b Handshake processing Set the handshake processing C Preset cel
112. en the monitor and logging functions have been executed using the personal computer of the following performance The performance values indicate the numbers of device points where no collection delay will occur when only one cell area has been set to the Excel book and the device data of D device are collected by the monitor or logging function If multiple cell areas have been set reduce the number of device points per cell to maintain the same performance The actual performance values vary depending on the performance or similar of the personal computer Use the performance values given in this section as reference values OS Windows XP Professional CPU Pentium III G00MHz Memory 256MB Excel Excel 2002 Ce aman CELA TE e LY RU Cell area Only one Setting example 1 The setting example 1 indicates the case where only one access data is set Setting example 2 The setting example 2 indicates the case where two or more access data are set No of O eee L3 pss wor Gl 1 Performance values for computer link communication The following table indicates the performance values when the monitor and logging functions are executed using computer link communication CPU type ASACPU Connected module AJ71UC24 19200bps Number of Device Points Function Operation Interval Setting example 1 Setting example 2 120 points 30 poi
113. ending on the operation interval Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CS Logging Monitor function Monitor 1 Modem_ Settings Settings Settings Settings Mandatory Settings Notset Setalready OK Cancel Apply Optional Settings Motset Setalready Detailed Explanation Set the Operation Interval Set the operation of the cell area valid or invalid Section 6 2 3 Operation day Set the operation day of the monitor function activation Operation time Set the operation time of the monitor function activation 2 a Set the telephone line connection timing and disconnection timing Section 6 2 3 a Preset cell areas The settings of the cell areas preset to the Excel book are displayed Section 6 2 1 1 Telephone line connectivity time zone is displayed when the logical station number selected in Logical Station Number of the lt lt Access Data gt gt tab is the one for modem communication 2 Detailed explanation With the exception of the following item the setting of the Operation Interval gt gt tab for use of the monitor function is the same as the setting of the Operation Interval gt gt tab for use of the logging function Refer to Section 6 2 3 for details a Operation time The setting except for Regular interval is the same as that of the logging function Refer to Section 6 2 3 for the setting except for Regular int
114. erating System How to Use This Manual This manual is organized with sections representing each aspect of MX Sheet Refer to the respective section when you need to know the following 1 2 3 4 5 6 7 9 The features Section 1 1 Section 1 1 gives the features The system configuration and operating environment Section 2 1 Section 2 1 provides the operating environment The functions performance and applicable PLC CPUs of MX Sheet Sections 3 1 to 3 2 Section 3 1 lists the functions of MX Sheet and Section 3 2 gives information on the applicable PLC CPUs The operation procedure of MX Sheet Chapter 4 Chapter 4 provides the operation procedure of MX Sheet The menu of MX Sheet Chapter 5 Chapter 5 describes the MX Sheet menu selection method The cell setting methods of MX Sheet Chapter 6 Chapter 6 describes the MX Sheet cell setting methods Automatic save setting Chapter 7 Chapter 7 describes the automatic save setting of each data Automatic print setting Chapter 8 Chapter 8 describes the automatic print setting of each data Automatic communication startup setting Chapter 9 Chapter 9 describes the automatic communication startup setting of each function 10 Communication start and communication end Chapter 10 Chapter 10 describes communication start and communication end 11 1 shot communication Chapter 11 Chapter 11 describes 1 shot communication
115. ere cell as character strings aracter strin j The data of the device number set in Device are displayed in the Word device 2 cell as character strings Displayed in a single cell in units of 2 words 32 bits starting with Bit device i 1 Real number the device number set in Device Displayed in a single cell in units of 2 words starting with the device 21 value lt 21 0 Displayed in a single cell in units of 2 words starting with the device Word device M number set in Device 1 The displayed value changes depending on the Zoom setting Refer to 6 for details 2 The unit and the number of displayed characters of the read data change depending on the No of characters setting Refer to 5 for details 4 Value Select the display format of the value to be displayed in the cell from DEC and HEX Depending on the Data Type the Value and Zoom can be selected set as described below Cell data display Data Type Cannotbeselected _ Cannot be set Displayed in decima 16 bit integer Cannot be set Display in 4 digit hexadecimal ex O3EB in 4 Displayed in decimal 32 bit integer in 8 HEX Display in 8 digit hexadecimal Cannot be set Character String Cannot be selected Cannot be set Character string is displayed ex ABCD Cannot be selected Real number is displayed ex 1 36E 36 6 CELL SETTING MELSOFT 5 No of chara
116. erval 1 When Regular interval is selected Device data is collected at the set second intervals When modem communication is used and Telephone line connectivity time zone is set to Connect each time depending on the operation interval set Regular interval to 30 seconds or more Setting range 0 1 to 0 9 in units of 0 1 seconds 1 to 3600 in units of 1 second 6 43 6 43 6 CELL SETTING MELSOFT 6 3 4 Setting of the Device Trigger tab This section describes the setting of the lt lt Device Trigger gt gt tab for use of the monitor function In the lt lt Device Trigger gt gt tab set the device conditions for the device trigger 1 lt lt Device Trigger gt gt tab Cell Settings Monitor function Set the Device Trigger C Bit Device Word Device Device po Condition Range Value 100 gt 200 Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CSY Logging Monitor function Monitor 1 Modem_ Settings Settings Settings Settings Mandatory Settings Notset Setalready OK Cancel Optional Settings Motset Setalready Detailed Item Description Explanation Set the Device Set the Device Trigger Set when the device trigger is used Section 6 2 4 a Device conditions Set the device conditions b Preset cell areas The settings of the cell areas preset to the Excel book are displayed Section 6 2 1 2 Detailed explanation Th
117. es including color designation or not Section 6 2 4 Set the Color for Filling the Color for Set the Color for Filling Set whether the specified cell area is colored or not When Clear cell area at the start of communication has a check Clear cell area at the mark the data in the cell area specified at the start of start of communication communication is cleared Default no check a Preset cell areas The settings of the cell areas preset to the Excel book are displayed Section 6 2 1 2 Detailed explanation With the exception of the following item the setting of the lt lt Use gt gt tab for use of the comment display function is the same as that of the lt lt Use gt gt tab for use of the logging function Refer to Section 6 2 1 for details a Cell Area Set the cell area to be used by the comment display function oetting range 1 Section 6 3 1 6 CELL SETTING MELSOFT 6 6 2 Setting of the Access Data tab This section describes the setting of the lt lt Access Data gt gt tab for use of the comment display function In the lt lt Access Data gt gt tab set the logical station number required for communication with the PLC and the device data to be used for the comment display function 1 lt lt Access Data gt gt tab Cell Settings Comment display function iterva Device Trigger Handshake Logical Station Number 11 Modem QJ71C24 X Communication Settings ES ES
118. es not overlap those of the other Excel books Color designation a Color designation When using Excel 2003 or earlier and specifying any of the following colors for Set the Color of Grid line or Set the Color for Filling on the lt lt Use gt gt tab the actual display color differs from the specified color Basic colors E O mmm BH MEN b Color designation from Excel If the line color and cell filling color have been specified from Format Cells of Excel the colors specified in Set the Color of Grind line and Set the Color for Filling of the lt lt Use gt gt tab are made invalid A 6 Custom colors c Compatibility check In Excel 2007 or later when setting colors to a Book in Excel from 97 to 2003 version with Cell Settings of MX Sheet if specifying the color of on the following screen the Compatibility Checker screen appears on the Excel at saving the Book lt Compatibility Checker screen gt Microsoft Office Excel Compatibility Checker Basic colors The following features in this workbook are not supported by earlier versions of Excel These features may be lost or degraded when you save this i gt lt gt lt gt lt lt x Xx workbook in an earlier file format Click Continue to save the workbook E bb MEE NE E B E Ps EX ES SZ ES E Summary Number of occurrences EM EXE EB ES EE Minor loss of fidelity o anyway To keep all of your features click Can
119. ess toolbar Office button 9 Add Ins ES ES E EI E eo Ld MXSheet E Big Hd a RE Menu Commands Custom Toolbars e Excel 2010 hides tabs on the ribbon Although the lt lt File gt gt tab and the quick access toolbar are displayed do not operate them during communications Quick access toolbar 3 E Bookl xlsx lt lt File gt gt tab gt Add Ins Team Mxsneet 8 ES mu B RE GS ee Ej BA Menu Commands Custom Toolbars Al 8 Mouse cursor during communication 9 While MX Sheet is communicating the mouse cursor setting of an Excel sheet is fixed to the one of Normal Select in Mouse Properties Mouse Properties Buttons Pointers Pointer Options Hardware Scheme Windows Default system scheme Customize Normal Select Help Select Busy Precision Select R Working In Background E X T v v Enable pointer shadow Patna Change to Design Mode of Excel during communication For Excel during communication do not change to the Design Mode using the toolbar or similar means To do so may disable normal operation of MX Sheet Control Toolbox P Riz c at ADR 10 Continuous operation when saving data automatically in HTML format Do not operate MX Sheet continuously when the Automatic save function is set to save data in HTML forma
120. et M Help 8x 1 Ele Edit Insert Format Tool Data Window MXSheet M Help 8 File Edit Insert Format Tools Data Window Sheet M Help Tef HSn SRY X E amp r A MEG T i BZU Hy O A T DEHAU X8 o AEA 0 0 7 1 BZ U Ey O A T Dees SRAY X8 o amp x 5 fM C 7 TimesnewRoman 11 B Z U T S20 BESS See HESS S22 OSE Li fe Al fe B c D iE G H 1 J K L M DUBIE s B B B E E s i i R E 5 is I A B c D E F G H 1 J K iL M d 2 Menitor Device Trigger CSV Logging Write Device Trigger 20 D Dz ps Da 2 Automatic save 3 1 2 3 4 5 Contents 3 4 6 3 8 10 1 DO D4 are Logginged taking a handshake with a PLC 4 Contents 5 11 12 13 14 15 2 When this range of Logging is filled this Excel Book is saved automatically 5 When M20 turns on this ExcelBook is saved 8 16 17 18 19 20 lt Save file name gt 8 Save file name 7 2 22 23 24 25 SAMELSECShestSareLog xi 7 CAMELSEC Sheet AutoSave xls Add Date and Time to Filename 8 26 27 28 29 30 lt Handshake conditions 8 9 31 32 33 34 35 From PLC 9 11 41 42 43 44 45 MIL is tamed on from a PC side Automatically 11 12 46 47 48 49 50 4 When M11 is tumed on M10 is tumed off by the PLC side 12 13 5 When M10 is tumed off M11 is tumed off by the PC side Automatically 13 14 Contents Contents 4 14 15 LThe data of devices 00 049 is read to the cell range of B3 F12 The value of cell
121. etting dialog box Choose MX Sheet Protect MX Sheet setting from the menu bar When Protect MX Sheet setting has been set the Protect MX Sheet setting menu is not displayed and the Unprotect MX Sheet setting menu is displayed 2 Protect MX Sheet setting dialog box Protect MX Sheet setting Enable check setting data Password optional onn Detailed Item Description Explanation l The menu that can be selected when Protect MX Sheet setting has been set Enable check setting data l l 3 a changes depending on whether a check mark exists or not Enter the password for protecting the setting contents Password optional The password may also be registered as a blank The Confirm Password dialog box is displayed When the password is blank however the Confirm Password dialog box is not displayed and the MX Sheet setting is protected The Protect MX Sheet setting dialog box is closed The MX Sheet setting is not protected 15 1 15 1 15 PROTECT UNPROTECT MX SHEET SETTING MELSOFT 3 Detailed explanation a Enable check setting data Depending on whether No check setting contents cannot be confirmed or Check setting contents can be confirmed is selected the menu that can be selected when Protect MX Sheet setting has been set changes as described in the following table Communication Start O O PasingteCelAra DeeigteCelArea Changing the ShestName
122. etting has not been set the Unprotect MX Sheet setting menu is not displayed When the password is blank the Unprotect MX Sheet setting dialog box is not displayed and the MX Sheet setting is unprotected 2 Unprotect MX Sheet setting dialog box Unprotect MX Sheet setting cana Enter the password set the Protect MX Sheet setting dialog box The Unprotect MX Sheet setting dialog box is closed and the MX Sheet setting is unprotected The MX Sheet menu selection and setting screen editing restriction are cancelled The Unprotect MX Sheet setting dialog box is closed The MX Sheet setting is not unprotected 15 4 15 4 16 OPTIONS MELSOFT 16 Options Make Option setting for specifying the Error log sheet output format etc To display the Options dialog box choose MX Sheet Options on the menu bar 16 1 Setting of the error log Set the Error log sheet output format on the lt lt Error log gt gt tab in the Options dialog box Refer to Chapter 19 for details of the Error log sheet lt lt Error log gt gt tab Options v Display error log w Information Blue W Warning Pink W Error Red Display Error Log sheet when an error occurs Clear error log at the start of communication Ok Cancel Set whether the information warning error that occurred during the execution of Display error log communication will be displayed in the Error log sheet or no
123. etup conversion 1 If Comm Status of the Communication settings gt gt tab has been set to invalid in the Tag setup utility of MX Chart the Set the Operation Interval check box of the Operation Interval gt gt tab is unmarked to make the cell area settings invalid in the Cell Setting dialog box of MX Sheet If the collection conditions and handshake have been set in the Extended dialog box of MX Chart they are converted into the settings of the Device Trigger tab and lt lt Handshake gt gt tab of the Cell Setting dialog box of MX Sheet Also in the Extended dialog box of MX Chart the logical station numbers in the collection conditions and handshake are not converted for MX Sheet If the ms unit setting has been made in Comm Period name of the Tag setup utility of MX Chart it is rounded up to the second unit and converted into MX Sheet However when the following functions are used 0 5s to 0 9s settings are not rounded up e Monitor function e Write function e Alarm summary function e Comment display function Precautions on OLEX functions 1 Be sure to delete the user program which uses OLEX functions after converting the Excel book which uses the OLEX functions OLEX function will not work on MX Sheet 20 8 APPENDICES MELSOFT APPENDICES APPENDIX 1 VERSION CONFIRMATION This section explains how to confirm the MX Sheet version Confirm the MX Sheet version in the Produc
124. evice Set when operation is to be performed only once when the bit device turns on Werddevic Set when operation is to be performed only once the corresponding bit of the word device turns on value 1 Bit devis Set when operation is to be performed only once when the bit device turns off Ward device Set when operation is to be performed only once when the corresponding bit of the word device turns off value O Bit device Set when operation is to be performed while the bit device is on Set when operation is to be performed while the corresponding bit of the word device is on value 1 Set when operation is to be performed while the bit device is off Wistdd vica Set when operation is to be performed while the corresponding bit of the word device is off value 0 Waorddavics Set when operation is to be performed when the device value is equal to the Value setting aes Word device Set when operation Is to be performed when the device value is not equal to the Value setting m Word device Set when operation is to be performed when the device value is equal to or less than the Value setting 2 Word Gace Set when operation is to be performed when the device value is less than the Value setting Se Word davies Set when operation is to be performed when the device value is equal to or greater than the Value setting Wonddvi s Set when operation Is to be performed when the device value is greater than the Value
125. evice data is collected at the set second intervals When modem communication is used and Telephone line connectivity time zone is set to Connect each time depending on the operation interval set Regular interval to 30 seconds or more Setting range 0 5 to 0 9 in units of 0 1 seconds 1 to 3600 in units of 1 second 6 72 6 72 6 CELL SETTING MELSOFT 6 6 5 Setting of the Device Trigger tab This section describes the setting of the lt lt Device Trigger gt gt tab for use of the comment display function In the lt lt Device Trigger gt gt tab set the device conditions for the device trigger 1 lt lt Device Trigger gt gt tab Cell Settings Comment display function Set the Device Trigger C Bit Device Word Device Device po Condition Range Value 100 gt 200 Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CS Logging Comment display Comment 1 Modem_ Settings Settings Settings Mandatory Settings Notset Setalready OK Cancel Optional Settings Notset Setalready Detailed Item Description Explanation Set the Device Set the Device Trigger Set when the device trigger is used Section 6 2 4 a Device conditions Set the device conditions b Preset cell areas The settings of the cell areas preset to the Excel book are displayed Section 6 2 1 2 Detailed explanation The setting of the Device Trigger tab for u
126. extended to the MX Sheet due to upgrade Compatible Added extended m Reference Description Versions Functions Section Under the following operating systems MX Sheet can be operated regardless of administrator authority Operating Microsoft Windows NT Workstation Operating System Version 4 0 l Section 2 1 Environment e Microsoft Windows 2000 Professional Operating System e Microsoft Windows XP Professional Operating System e Microsoft Windows XP Home Edition Operating System Excel Microsoft Excel 2003 English version Section 2 1 lt lt Use gt gt tab settings Cell Settings lt lt Access Data gt gt Enabled to express the numeric in hexadecimal Chapter 6 tab settings Cell Settings Operation Interval gt gt Enabled to set data collection at 0 1 second interval Chapter 6 tab settings The following options can be set on the lt lt Error log gt gt tab Versio Erori Clears error log at the start of communication Section 1 030 9 Selects the display format of error log 16 1 Automatically displays the error log sheet when an error occurs Logging Enabled to automatically create a title in the display area of Section 6 2 Logging Alarm Summary Alarm Summary e Enabled to set CSV file format to save Excel book when the cell is Section 6 5 full Alarm Summary Enabled to display the number of occurrences and elapsed time Section 6 5 Enabled to clear a desired cell range a
127. for details 16 bit integer 32768 to 32767 32 bit integer 2147483648 to 2147483647 a Access data 1 Device oet the device used for the comment display function Enter the device name and device number in this order Refer to Section 3 2 for the accessible devices 2 Data Type oet the data type of the device used for the comment display function Device That Can be n Item Description Specified Bit device Word device Bit specification Bit device Bit device Word device The bit devices set in Device are displayed in a single cell in units of one bit Designated bits for word device set in Device are displayed in a single cell in units of one bit e g 00 0 Set when 1 word 16 bits starting from the device number set in Device is used for the comment display function Set when the word device set in Device is used for the comment display function Set when 2 words 32 bits starting from the device number set in Device are used for the comment display function Set when 2 words starting from the device number set in Device are used for the comment display function 6 CELL SETTING MELSOFT 6 6 3 Setting of the Comment Data tab This section describes the setting of the lt lt Comment Data gt gt tab for use of the comment display function In the lt lt Comment Data gt gt tab set the comment data to be displayed in the cell area 1 lt lt Comment Data g
128. fter performing Automatic Chapter 7 save Automatic print Enabled to make multiple setting of Automatic Save Automatic Print Automatic print condition Chapter 8 Enabled to save a file as a CSV file using Automatic Save dialog box Communication Start Chapter 10 Or Enabled to create the buttons for operation and paste them in Excel Communication End host poti EE Chapter 11 Shot Communication Chapter 14 Protect MX Sheet Enabled to protect the setting by means of password Chapter 15 To the next page APP 27 APP 27 APPENDICES MELSOFT Compatible Added extended M Reference Description Versions Functions Section Enabled to extend the settable number of points in a cell range Monitor 1000 points 2000 points Write 1000 points 2000 points Access Data Chapter 6 Verion absens Alarm Summary 300 points 2000 points 1066 9 Enabled to set the device up as word device with bit specification by device specification the access data Cell Settings Enabled to set the operation interval at 1 minute and lt lt QOperation Interval gt gt 6 n second interval tab settings Operating NS Version Windows Vista English version Section 2 1 108 Environment Microsoft Excel 2007 English version Section 2 1 Version Enabled to specify GOT timer contact devices and counter Section 3 2 1 09K 9 contac
129. g Logging furB2 G11 Last Line To scroll No setting No settings 4 5 Access CLogical 51 Device Data Type Device poiiln unit Password 6 1 Modem_ D100 16bit integ 3 Word No settings 7 X100 Bit 2 Bit 8 a 9 lt Operatior Operation Daily Weekly Monthly Regular int Hourly Time Table Logging Logging Time zone Settings Daily 5 Log Always Device Tr Device Device The bit Condition No settings lt Handshal Handshake No settings CSV Log CSV LoggiNo of linesFile name Save method No settings D Automati Automatic Save Line1 daily Automatic Save Settings Save at the end of communication Settings Set the da Daily Weekly Monthly Regular int Hourly Time table b No settings Set the DeLogical SteDevice bit Condition Password No settings Clear cell Specify the cell area name No settings File name Save method C data da Add date and time to File name 44 lt Automati Automatic Print Name 45 Line daily 46 47 Automatic Print 48 No settings 49 50 Print at the end of communication 51 Settings Set the da Daily Weekly Monthly Regular int Hourly Time table No settings Set the DeLogical StzDevice Thebit Condition Password Settings 1 Modem When ON No settings Clear cell Specify the cell area name Settings Print Area Sheet name to print C Entire workbook Line1l weekly Automatic Print settings Print at the end of communication No settings Set the da Daily Weekly Monthly Regular int Hourly Time table Settings
130. ger Handshake CSV Logging Comment display Comment 1 Modem Settings Settings Settings Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CSV Logging Comment display Comment 1 Modem Settings Settings Settings Mandatory Settings Not set i Setaleady Optional Settings Motset Setalready Mandatory Settings Mot se 1 Setalready Optional Settings Not se i Setaleady lt lt Comment Data gt gt tab Cell Settings Comment display function Cell Settings Comment display function Use Access Data eration Interval Device Trigger Handshake Req Uu red setti n g Use Access Data Comment Data Device Trigger Handshake S et as n ecessa ry Set the Operation Interval Refer to Section Operation Day C ey Toss Coa Refer to Section 6 6 4 Device DO Data Type 160 integer value DEC Range Lower Range Upper Conunent String 32767 Temperature upper limit over 6 6 x 3 Operation Regular interval Minutely C Hourly Time table time 5 s Telephone line connectivity time zone Bein connected state always from the start of the communication Connect during the specified time zones only Connect each time depending on the operation interval Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CSV Logging Cell Area Name Use Logical Sta Operati
131. gging function Logging 1 Modem Settings Settings Settings Settings Mandatory Settings Notset Setalready Optional Settings Setalready OK Cancel Apply Required setting Refer to Section 6 2 2 Set as necessary Refer to Section 6 2 4 Set as necessary Refer to Section 6 2 6 6 CELL SETTING MELSOFT 6 2 1 Setting of the Use tab This section describes the setting of the lt lt Use gt gt tab for use of the logging function In the lt lt Use gt gt tab set the cell area logging data display position displayed contents and operation when the cell is full 1 lt lt Use gt gt tab Cell Settings Logging function Access Data Or ation Int al Device Trigger Handshake CSV Logging Logging Cell Area 099119 function B2 65 Set the Color of Grid line Set the Color for Filling Clear cell area at the start of communication New data location Last Line v Display Contents Add title Add date and time details 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 Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CS Logging Logging function Logging 1 Modem_ Settings Settings Settings Settings Mandatory Settings Not set Setalready Cancel Optional Settings Setalread
132. gt tab MX Sheet gt Start Communication 6 Excel 200 or later Or click the Start Communication Button refer to Section 14 1 2 Explanation of Start Communication dialog box MX Sheet Communication will commence sit OK Click on to start communication between the Excel book being edited and the PLC and read write device data 3 Display of Excel book and task bar during communication The following shows how the Excel book which is communicating with the PLC using MX Sheet and the task bar are displayed a Display of Excel book lt Excel 2003 or earlier gt Microsoft Excel Book1 xls eee eee ea ee a b E im E c em n n w e pate time 2004 07 13 Tue 18 11 06 C 2004 07 13 Tue 18 11 11 2004 07 13 Tue 18 04 36 2004 07 13 Tue 18 04 41 2004 07 13 Tue 18 04 46 2004 07 13 Tue 18 04 51 2004 07 13 Tue 16 04 56 2004 07 13 Tue 18 05 01 2004 07 13 Tue 18 05 06 End Communication E 1Shot Communication S Version Info V Status during Communication a Menu bar Only MX Sheet can be selected b Icons Only the End Communication and 1 Shot Communication icons can be selected c MX Sheet menu Only End Communication 1 Shot Communication and Version Info can be selected 10 1 10 1 10 COMMUNICATION START AND COMMUNICATION END MELSOFT lt Excel 2007 or later gt Book1 xlsx Microsoft
133. he Copy Cell Area dialog box Paste the cell area after copying it Refer to Section 12 3 for pasting the cell area 129 12 2 12 CELL EDITING MELSOFT 12 3 Pasting the Cell Area This section explains the procedure to paste the cut or copied cell area to another cell area 1 Displaying Paste Cell Area dialog box Choose MX Sheet Paste Cell Area 8 from the menu bar 2 Paste Cell Area dialog box Paste Cell Area Target Cell area E15 J24 for Paste operation Target Cell area name oqging function for Paste operation Source Cell area for the Paste operation Target Cell area for l Enter the cell area to be pasted Paste operation Target Cell area name Enter the cell area name to be pasted 1 for Paste operation Source Cell area for the The cut or copied cell area is displayed Paste operation he OK can be clicked after the Target Cell area for Paste operation and Target Cell area name for Paste operation are set Click on to copy the cell area Used to close the Paste Cell Area dialog box 1 When pasting the cell area after copying it enter into Target Cell area name for Paste Operation the cell area name that differs from the copied cell area name Paste the cell area after cutting or copying it The cell area cannot be pasted unless the cell area has been selected by cutting or copying it 12 3 12 3 12 CELL EDITING 12 4 MELSOFT 3 Precautions for pas
134. he alarm summary Enter the device name and device number in this order 3 Dev Points The points of the devices to be consecutively registered starting with the device number set in Device are displayed b The number of set devices The number of device points registered to the cell area and the number of device points that can be registered are displayed 128 800 Indicates the number of device points that can be registered to the cell area Indicates the number of device points that has been registered to the cell area 6 CELL SETTING MELSOFT 6 5 3 Setting of the Alarm Data tab This section describes the setting of the lt lt Alarm Data gt gt tab for use of the alarm summary function In the lt lt Alarm Data gt gt tab set the character strings to be displayed in the cell area 1 lt lt Alarm Data gt gt tab Cell Settings Alarm summary function Use i Operation Interval Device Trigger Sane Generation Restoration Generation Restoration Cell amp rea Name Use Logical Sta Operation Interval Device Trigger Handshake CSV Logging Alarm summary f Alarm summary 1 Modem Settings Settings Mandatory Settings Notset Setalready 2 OK Cancel Optional Settings Motset Setalready Item Description peeled P Explanation a Alarm data Set the alarm data to be used for the alarm summary function 2 a to e b Preset cell areas
135. hes 100 processing in 3 is started 3 Device data is collected 4 After device data is collected the D200 value is changed to 0 5 The D100 value is changed to other than 100 Time out monitoring is not executed between 4 and 5 above If the operation in 5 is not performed in the PLC device data collection is not executed when the handshake conditions are satisfied at the next time 6 CELL SETTING MELSOFT 3 Detailed explanation a Set Handshake When using a handshake be sure to mark Set Handshake b Requesting source setting Set the requesting source for a device data collection start Start with the request Set when starting device data collection at the request of from the PLC the PLC Start with the request Set when starting device data collection at the request of from the PC the personal computer c Handshake processing Set the handshake processing on the personal computer side and PLC side 1 PC side processing Device type oet the device type used for PC side processing Set when a bit device is used for PC side processing Set when a word device is used for PC side processing e Device Enter the device used for PC side processing Enter the device name and device number in this order When specifying a bit of the word device enter the bit number in the bit e Value Set the value of the device used for PC side processing Available Device Set when the value of th
136. icrosoft Windows XP Home Edition Operating System Windows Vista or Windows 7 is used the following new functions cannot be used If any of the following new functions is used this product may not operate normally Start of application in Windows compatible mode Fast user switching Remote desktop Big fonts Details setting of Screen properties 64 bit Windows XP and 64 bit Windows Vista are not supported 2 When Windows 7 is used the following new functions cannot be used Windows XP Mode Windows Touch 3 When MX Sheet is tried to be installed on the personal computer where 64 bit Microsoft Excel 2010 has been installed the following error message appears Information CX Excel 64bit version was installed in an environment can not perform the F installation 4 When MX Sheet is installed 64 bit Microsoft Excel 2010 is installed and started then an add in is installed the following error message appears Microsoft Visual Basic for Applications Compile error in hidden module MAShExtern amp 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 i Help To use MX Sheet install 32 bit Microsoft Excel 2010 3 FUNCTION LIST OF MX Sheet MELSOFT 3 FUNCTION LIST OF MX Sheet This chapter describes the functions of MX Sheet accessible CPUs and accessible devices 3
137. iew etc of Excel If the communication of MX Sheet is started with the preview setting of Excel active a memory leak will occur Simultaneous communication from multiple Excel books Multiple Excel books where MX Sheet setting has been made cannot be started on a single personal computer to make communication simultaneously When communicating Excel book is double started Do not make a double start restart of the Excel book that is communicating using MX Sheet If such operation is performed the following dialog box appears Click No to interrupt a double start restart Microsoft Excel 1 MX Sheet xls is already open Reopening will cause any changes you made to be discarded Do you want to reopen Mx Sheet xls When logoff shutdown is executed during communication Do not log off or shut down the personal computer during usual communication or 1 shot communication Log off or shut down the personal computer after terminating the communication with the PLC and exiting from Excel If logoff or shutdown of the personal computer is executed during communication the following symptoms will be observed In this case take corrective actions to restore the system a Symptom When MX Sheet setting is made only the frame of Excel is displayed b Corrective action In the following procedure remove the hide attributes of the Excel book and overwrite the Excel book to restore the system 1 Choose Window Unhide in
138. ilter G H J Al Save As gt Print gt Prepare gt Send c Publish gt K Ld Close aec 15 16 17 18 l Select Show Developer tab in the Ribbon and click OK B Change the most popular options in Excel Top options for working with Excel v Show Mini Toolbar on selection Color scheme Blue ScreenTip style Show feature descriptions in ScreenTips Create lists for use in sorts and fill sequences When creating new workbooks Use this font Body Font Font size 11 M Default view for new sheets Normal View Include this many sheets Personalize your copy of Microsoft Office Username mtc Choose the languages you want to use with Microsoft Office 14 2 14 CREATE BUTTON From the previous page 4 A CO 14 3 Microsoft Excel Book1 xls i File Edit View Insert Format Tools Data Window Sheet M Help Dc EG amp el tT BAS Bre 2 2 Mm 4 BE zm Vga yw MXShBtnStart1 vv EMBED MXSHBTNS MXShBtnStartCtrl 1 A B D r n MXShBinStat h oo cut Paste MxshBtnStart Control Object Show Picture Toolbar Grouping Order 9 Format Object MXShBtnStart Control Properties Caption MXShBtnStart Cancel When the property setting is finished click Bg from the Design Mode MELSOFT Excel 2010
139. int is performed using the device trigger 2 Displaying Automatic Print dialog box In the Automatic print list dialog box click or Edit 3 Automatic Print dialog box Automatic Print Automatic Print Name Line1 weekly Print at the end of communication Set the date and time Sunday Operation Daily Weekly Monday Monthly day Tuesday Wednesday Thursday Friday Saturday Operation Regular interval C Hourly Time table HH time Set the Device trigger Clear cell area after automatic print lt Print Area Entire workbook Specify the sheet lt gt OK Cancel Detailed ltem Description EE NEN Automatic Automatic printname name Manage the automatic print setting data with specific names Print at the end of Set when performing automatic print at the end of communication communication Section 7 1 Set the date and time the date and Set the date and time Set when performing automatic print at the specified date and time Operation day Set the operation day when automatic print is performed at the specified date and time mn Set the operation time when automatic print is performed at the specified Operation time i date and time Set the device trigger Set when performing automatic print using the device trigger a Device conditions Set the device conditions for the device trigger To the next page 8 3 8 3 8 AUTOMATIC PRINT SETTING MELSOFT Item
140. ion 7 2 Correction Operating Precautions Generic Terms and Abbreviations Section 2 1 Section 3 1 Chapter 5 Section 6 2 1 Section 7 2 Section 10 1 oection 10 2 Section 14 1 Section 20 1 Appendix 2 Appendix 8 Section 6 2 1 Section 6 3 1 Section 6 4 1 Section 6 5 1 Section 6 6 1 Section 6 6 3 Correction Operating Precautions Manuals Packing List Section 6 2 1 oection 7 2 Appendix 7 Appendix 8 1 Print Date Manual Number Dec 2009 SH NA 080348E I Addition CONDITIONS OF USE FOR THE PRODUCT Correction SAFETY PRECAUTIONS Section 3 2 Chapter 9 May 2010 SH NA 080348E J Addition Operating Precautions Generic Terms and Abbreviations Section 2 1 Section 7 2 Chapter 4 Section 6 2 2 Section 20 1 Appendix 1 Appendix 8 Appendix 9 Correction Section 6 2 5 Section 6 4 2 May 2011 SH NA 080348E K New Addition Appendix 9 Addition Operating Precautions Generic Terms and Abbreviations Section 2 1 Chapter 5 Section 6 2 1 Section 6 2 6 Section 7 2 Chapter 9 section 10 1 Section 10 2 Section 14 1 Appendix 3 Appendix 9 Correction Appendix 9 changed to Appendix 10 Japanese Manual Version SH 080346 K 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
141. is ended and set repeatedly the button may not be clicked In this case minimize and restore the Excel book window This enables the button to be clicked When moving a button or changing button size after creating it the button is not checked for its position e Ifthe button position exceeds the supported range 256 columns x65536 rows when Excel from 97 to 2003 version is saved in book format any of the following occurs depending on the button size button position height of the row and or cell width 1 When saved Book is reopened the button is reduced or moved so that it is fit within the supported range 2 The button has disappeared when saved Book is reopened 3 The Compatibility Checker screen appears on the Excel at saving the Book 14 5 14 5 14 CREATE BUTTON MELSOFT 14 2 End Communication Button Create the button for execution of End Communication and paste it to an Excel sheet 1 Button pasting method Similar to the Start Communication Button Refer to Section 14 1 1 Choose MX Sheet Create Button End Communication Button in the menu 2 Property page starting method Similar to the Start Communication Button Refer to Section 14 1 2 Choose MXShBtnEnd Control Object Properties in the menu 3 Property setting oet the Caption and Font properties Refer to Section 14 1 3 14 6 14 6 14 CREATE BUTTON MELSOFT 14 3 1 Shot Communication Button 14 7 Create th
142. is selected The Excel sheet is printed when the cell is full After completion of print all data are erased and logging is resumed This item can be selected when Operating when cell is full is set to 2 or 3 Fourth data Fifth data 6 CELL SETTING MELSOFT 5 When Save to file is selected The Excel book is saved when the cell is full After completion of save all data are erased and logging is resumed This item can be selected when Operating when cell is full is set to 2 or 3 When choosing Save to file make the following settings for the file where data will be saved Description The storage location and file name is set for the Excel book to be saved when the cell is full File name to save The Excel file xls Xlsx xism Xlsb or HTML file htm or CSV file csv can be set as the file type The file set in File name to save saves data with the date and time added to its file name The following indicates a file name format when data is saved 9 0020523183536 extension Extension set to File name to save Seconds Minutes Hours Day Month Year File name set in File name to save Add date and time to File name The file set in File name to save saves data with a number added to its file name A serial number can be set within the range of 000 to 999 When the number is reached to the last the file of the first number is overwritten by the newly saving file
143. l Minutely Hourly C Timetable lime B Telephone line connectivity time zone Be in connected state always from the start of the communication Connect during the specified time zones only Connect each time depending on the operation interval e Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CSV Logging Write function Write 1 Modem Settings Settings Settings Mandatory Settings Notset Setalready Optional Settings Notset Setalready Cancel Apply lt lt Handshake gt gt tab Cell Settings Write function Use Access Data Operation Interval Device Trigger Set Handshake Start with the request from the PLC Start with the request from the PC Responding device on the PC side Bit Device Value ON vi C Word Device OL Device M100 i Monitoring time Requesting device B Colectirite i 10 s on the PLC side i Bit Device C Word Device Device Condition Vhen ON Cell Area Name Logical Sta Operation Interval Device Trigger Handshake CSV Logging Write function i 1 Modem Settings Settings Settings Mandatory Settings Notset Setalready Optional Settings Notset Setalready OK Cancel lt lt Access Data gt gt tab Cell Settings Write function Req u red setti ng eration Interval Device Trigger Handshake Logi
144. l areas The settings of the cell areas preset to the Excel book are displayed Section 6 2 1 2 Detailed explanation The setting of the lt lt Handshake gt gt tab for use of the monitor function is the same as that of the Handshake tab for use of the logging function Refer to Section 6 2 5 for details 6 CELL SETTING MELSOFT 6 3 6 Setting of the CSV Logging tab This section describes the setting of the lt lt CSV Logging gt gt tab for use of the monitor function In the lt lt CSV Logging gt gt tab set the file name and the saving contents with which the monitor data is saved into the CSV file 1 CSV Logging tab Cell Settings Monitor function Save as CSV file Contents to save Add Device to the first line No of lines to be saved 1000 File name to save D Documents and Settings My Documents Sv cs Browse Add date and time to File name Add sequential number to File name Fix the File name Cell amp rea Name Use Logical Sta Operation Interval Device Trigger Handshake CSV Logging Monitor function Monitor 1 Modem Settings Settings Settings Settings Mandatory Settingst Not set Setalready 2 OK Cancel Apply Optional Settings Not set Setalready Detailed Item Description Explanation Save as CSV file as CSV file Set when using the CSV logging Contents to save Set when adding the device name to the first line l Section 6
145. l be deleted can be clicked after the cell area name is selected in Cell Area Name Click on to delete the cell area Used to close the Delete Cell Area dialog box 12 5 12 5 13 CHANGING THE SHEET NAME MELSOFT 13 CHANGING THE SHEET NAME 13 1 This chapter describes the changing the sheet name of the Excel sheet where MX Sheet has been set In the Change Sheet Name dialog box choose a Excel sheet and set a new name for the sheet Always change the sheet name of the Excel sheet where MX Sheet has been set from the Change Sheet Name dialog box If the sheet name is changed from Excel directly or from a VBA program MX Sheet will not operate normally 1 2 Displaying Change Sheet Name dialog box Choose MX Sheet Change Sheet Name from the menu bar Change Sheet Name dialog box Change Sheet Name sheet name before change sheet name after change Cancel Sheet name before Select the Excel sheet of which sheet name to be changed change Sheet name after change Enter a new sheet name can be clicked after the Sheet name before change and Sheet name after change are selected Click on to change the sheet name Used to close the Change Sheet Name dialog box Changing the sheet name If the sheet name of the Excel sheet where MX Sheet has been set is changed from Excel directly or from a VBA program return the sheet name to the old one from Excel
146. led a communication error will occur during communication with the PLC Do not set the following functions on the personal computer e Resume function e Suspend function e Power saving function e Standby mode Precautions on setting MX Sheet 1 2 3 4 Word designation for bit and bit designation for word In the following tabs and dialog boxes word designation for bit e g KA4MO and bit designation for word e g 00 0 cannot be set 1 Access Data tab 2 Device Trigger Tab 3 lt lt Handshake gt gt tab 4 Automatic Save dialog box 5 Automatic Print dialog box 1 When using MX Sheet Version 1 06 G or later the device can be set by means of bit designated for word device e g 00 0 Reading character strings When character strings are read from the PLC the device data which prefix is either of the following characters are not displayed normally on an Excel sheet When reading character strings from the PLC make proper setting so that either of the following characters will not be prefixed 1 equal 2 single quotation Save of Excel sheets If the file name specified in the Automatic Save dialog box or Operating when cell is full of the lt lt Use gt gt tab already exists the old data is discarded and overwritten Make proper setting so that the file name specified in the Automatic Save dialog box or Operating when cell is full of the lt lt Use gt gt tab do
147. ll area The data displayed in the cell area are erased and logging is resumed Before logging is resumed the Excel sheet can be printed and saved a Preset cell areas The settings of the cell areas preset to the Excel book are displayed 2 g 2 Detailed explanation a Cell Area oet the cell area to be used by the logging function 1 Setting examples Operating when cell is full When a single cell range is specified B2 to D5 gt B2 D5 e Enter the cell numbers with in between lt 4 Cell area from B2 to D5 Number of cells 12 2 3 4 5 b n When multiple cell areas are specified B2 to D5 Specified cell area 1 and B8 to D11 Specified cell area 2 gt B2 D5 B8 011 E m Specified cell area 2 Enter the cell areas with in between Specified cell area 1 1 E 3 Specified cell area 1 Specified cell areas 1 and 2 B2 to D5 are displayed in this order In this case E Number of specified cell area 2 g Number of cells 24 g Specified cell area 2 10 B8 to D11 11 12 13 2 Setting ranges The following indicates the available setting ranges for the cell area and number of specified cell areas e Cell area When date and time are added 255 columns x 65536 rows When date and time are not added 256 columns x 65536 rows Number of specified cell areas Up to 16 6 CELL SETTING MELSOFT b Set the Color of Grid line and Set the Color for Filli
148. llation of Service Pack Refer to 2 Checking and installation of NET Framework and the related module Execute MXShRegRCom Check that the action works End Refer to 3 Execution of MXShRegRCom exe Refer to 4 Checking if the action works rd de uis a Update MX Sheet or install Service Pack NET Framework and the related module using the administrator account APP 22 APP 22 APPENDICES MELSOFT 1 Installation of Service Pack Install the Service Pack required for the used OS Used OS URL as of March 4 2011 l l http windows microsoft com en us windows help learn how to Windows XP Windows XP Service Pack 3 l install windows xp service pack 3 sp3 l http windows microsoft com en US windows vista Learn how to Windows Vista Windows Vista Service Pack 2 install Windows Vista Service Pack 2 SP2 2 Checking and installation of NET Framework and the related module The following tables list NET Frameworks and the related modules required for each operating environment If they are not installed install them in the order listed in a b or c The installers of NET Frameworks and the related modules are stored on the CD ROM provided with MX Sheet Version 1 11M or later If the CD ROM is not obtained visit the website shown in a b or c a Excel 2007 is used on Windows XP NET Framework and the Order File name o
149. ly Timetable HH E a H E Set the Device trigger E E esl 7 s Iu Clear cell area after automatic save Specify the cell area name File name to save C dataidatal xls Browse Add date and time to File name C Add sequential number to File name C Fix the File name OK Cancel Detailed Item Description p Automatic save name save name Manage the automatic save setting data with specific names EN Save atthe endo Set when performing automatic save at the end of communication 2 b aie Set the date andtime the date and time Set when performing automatic save at the specified date and time Set the operation day when automatic save is performed at the specified date and time To the next page 7 AUTOMATIC SAVE SETTING MELSOFT n Detailed Item Description Explanation Operan ine Set the operation time when automatic save is performed at the specified 4 e date and time Set the device trigger Set when performing automatic save using the device trigger 4 f a Device conditions Set the device conditions for the device trigger 4 g CAFEEN AIEA Make setting when clearing the cell area data after automatic save 4 h automatic save he list the list select the d area name that will be the target of Clear cell A i area after automatic save b Save file setting Set
150. mm mne menn remet ne mee rere reines re reser se pire sese se eire re sese sese A 20 meiienE I Tc A 21 1 OVERVIEW 1 1to 1 4 cs ie el mc ce cay ee 1 2 2 SYSTEM CONFIGURATION 2 1to2 2 Environttielibs 2 1 3 FUNCTION LIST OF MX Sheet 3 1to3 2 9 1 EUnclon 3 1 3 2 Accessible CPUs and Accessible Device Ranges 3 2 4 MX Sheet OPERATION PROCEDURE 4 1to4 o MX Sheet MENU SELECTION METHOD o 1to 5 2 6 CELL SETTING 6 1to 6 75 6 1 Operation of Gell Set ng Dialog BOX idi err oi ees to 6 1 6 2 VVNEMEOGGING I5 Selected testem duoi uoce Ser DU ea 6 2 0 2 1 Setng OF TNE Use Tabs ee aO Eu II Eo np Epio mim pta inen mun n 6 3 6 2 2 Setting of the Access Data tab uias ooi totum 6 11 6 2 3 Setting of the Operation Interval tab llsseseeeeeeiesssseeeeee enne nnne nnns 6 16 6 2 4 Setting or the Device Trigger tab sut ssi apu eni 6 22 6 2 5 orte Handshake TAD Se aeo are Ro sei oun orien Riedie sinus tour 6 25 06 2 0 Seung or ine CSV LOGGING lab Ob aoa ot T Fev ee 6 35 6 9 VV Mel Mobltor IS Selected hs ed ese ete eS Unt close na ein ee
151. munication e E Used to start the Communication Setup Utility to set a new logical Section 6 2 2 station number and change the settings Enter the password when the password has been set to the Remote password 1 77 target PLC Access data data Set the devices use for the alarm summary function Qe Number of set devices The number of devices currently set is displayed 2 b Preset cell areas The settings of the cell areas preset to the Excel book are displayed Section 6 2 1 1 Remote password is displayed when the logical station number selected in Logical Station Number of the lt lt Access Data tab is the one for the password function compatible module 6 CELL SETTING MELSOFT 2 Detailed explanation With the exception of the following items the setting of the lt lt Access Data gt gt tab for use of the alarm summary function is the same as that of the lt lt Access Data gt gt tab for use of the logging function Refer to Section 6 2 2 for details a Access data 1 Registration order Data are displayed in the lt lt Alarm Data gt gt tab in the order of the numbers shown on the left of the lt lt Access Data gt gt tab Setting example of lt lt Access Data gt gt tab ON time String Mi Generation i i BO Displayed in order Data No 2 of data numbers Data No 3 2 Device Only the bit device can be specified for t
152. n from the menu bar Excel 2003 or earlier Choose lt lt Add Ins gt gt tab MX Sheet End Communication Excel 2007 or later Or click the End Communication Button refer to Section 14 2 2 Confirmation at communication end At the end of communication MX Sheet displays the communication end message on the ErrorLog sheet Confirm the message on the ErrorLog sheet at the end of communication Refer to Chapter 19 for details of the ErrorLog sheet Excel 2003 or earlier Microsoft Excel MX Sheet ei G9 File Edit View Insert Format Tools Data Window Sheet M Help Ac OSH AR SRY SBA SFo m Bxr s 3 C wa 0 Bru FB Y ie A B E D E 1 Kind Date Cell Area Name ErrorNo Contents nformatio OI 31 Wed 15 57 IC ammunication wa arted E romanor 20020761 Wes 1656 14 30000002 Communication was complied At end of communication communication end message is displayed on ErrorLog sheet Excel 2007 or later Cin id 9 E Bookl xlsx Microsoft Excel i 3 Home Insert Page Layout Formulas Data Review View Developer Add Ins Q9 Mshet BEDS ew Menu Commands Custom Toolbars B11 A B D E 1 Kind Date Cell Area Name ErrorNo Contents 2 nformation 2007 09 04 Tue 18 13 20 00000000 Communication was started 3 Information 2007 09 04 Tue 18 15 05 00000002 Communication was completed 4 At end of communication comm
153. n of the following item the setting of the Operation Interval gt gt tab for use of the alarm summary function is the same as that of the Operation Interval gt gt tab for use of the logging function Refer to Section 6 2 3 for details a Regular interval Device data is collected at the set second intervals Setting range 0 1 to 0 9 in units of 0 1 seconds 1 to 3600 in units of 1 second If 0 1 to 0 9 seconds are set to the Regular interval on the Operation Interval gt gt tab the ON OFF time displayed on the Excel sheet will be in the yyyy mm dd ddd hh mm ss format Example When 0 2 seconds interval is set and the ON time is 11 hours 5 minutes 2 seconds 80 2004 07 13 Tue 16 55 41 6 63 6 63 6 CELL SETTING MELSOFT 6 5 5 Setting of the Device Trigger tab This section describes the setting of the lt lt Device Trigger gt gt tab for use of the alarm summary function In the lt lt Device Trigger gt gt tab set the device conditions for the device trigger 1 lt lt Device Trigger gt gt tab Cell Settings Alarm summary function Use Access Data Alarm Data Op w Set the Device Trigger Bit Device Word Device Device po Condition Range Value 100 gt 200 Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CSY Logging Alarm summary f Alarm summary 1 Modem Settings Settings Mandatory Settings Motset Setalready
154. n of written data 1 lt lt Use gt gt tab Cell Settings Write function f Us Access Data peration Interva Device Trigger Handshake Write b Cell Area ite function Cell Area B2 G5 Set the Color of Grid line Set the Color for Filling m Clear cell area at the start of communication Cell Display Direction Left to Right v Cell Area Name Logical Sta Operation Interval Device Trigger Handshake CS Logging Write function i 1 Modem_ Settings Settings Settings Mandatory Settings Motset Setalready Optional Settings Motset Setalready Set the function to be used for the specified cell area Choose Write when M Detailed Item Description l Explanation using the write function Set the name of the specified cell area Cell Area Name Maximum number of cell area names 1000 Cell Area Enter the value to specify the cell area oa Set whether the specified cell area is provided with grid lines including Set the Color of Grid line color designation or not Section 6 2 1 Set the Color for Set the Color for Filling Set whether the specified cell area is colored or not When Clear cell area at the start of communication has a check mark the Clear cell area at the 0n data in the cell area specified at the start of communication is cleared Section 6 3 1 start of communication Default no check Set the input cells for the write data e Left to
155. n the CD ROM URL as of March 4 2011 related module http microsoft com downloads en Microsoft NET Framework p WWW mlI w dotnetfx35 exe details aspx displaylang en amp FamilylD a 3 5 SP1 E did d b993421f 5d1a 4134d 8319 81da479ab0d7 http microsoft com downloads en Microsoft NET Framework p WWW mlI w 4 0 Extended dotNetFx4O Full x86 x64 exe details aspx displaylang en amp FamilyID 0 a391abd 25c1 4fc0 919f b21f31ab88b7 http www microsoft com downloads en vstor40_x86 exe details aspx FamilyID 06C32242 2289 Microsoft Visual Studio 2010 Tools for Office Runtime x86 4471 93AA CE96AA5CBC36 1 The file is in the DOTNET folder 2 If the website cannot be accessed refer to d APP 23 APP 23 APPENDICES MELSOFT b Excel 2010 is used on Windows XP or Excel 2007 or later is used on Windows Vista or 32 bit Windows 7 NET Framework and the Order File name on the CD ROM URL as of March 4 2011 related module l a http www microsoft com downloads en Microsoft NET Framework 4 0 Extended dotNetFx40 Full x86 x64 exe details aspx displaylang en amp FamilyID 0 a391abd 25c1 4fc0 919f b21f31ab88b7 http www microsoft com downloads en vstor40_x86 exe details aspx FamilyID 06C32242 2289 4471 93AA CE96AA5CBC36 1 The file is in the DOTNET folder 2 If the website cannot be accessed refer to d Microsoft Visual Studio 2010 Tools for Office Runtime x86
156. name File name to save C WatawWatal xls Browse Add date and time to File name C Add sequential number to File name rd C Fix the File name OK Cancel When the automatic save name list is double clicked or the key is pressed with the clicked line highlighted that operation has the same function as d The selected automatic save name is deleted When the key is pressed with the clicked line highlighted that operation has the same function as 7 AUTOMATIC SAVE SETTING MELSOFT 7 2 Setting of the Automatic Save Dialog Box In the Automatic Save dialog box set the save timing and file name 1 Save timing The following 3 save timings are available for the automatic save setting All of them can be set at a time e Automatic save is performed at the end of communication Detailed explanation 4 b e Automatic save is performed at a specified time Detailed explanation 4 c to e Automatic save is performed using the device trigger Detailed explanation 4 f to g 2 Displaying Automatic Save dialog box In the Automatic save list dialog box click or Edit 3 Automatic Save dialog box Automatic Save Automatic Save Name Linet weekly Save at the end of communication Set the date and time Sunday Operation Daily Weekly Monday Monthly day Tuesday Wednesday Thursday Friday Saturday Operation Regular interval C Hour
157. nction In the lt lt Access Data gt gt tab set the logical station number required for communication with the PLC and the device data to be collected in the cell area 1 lt lt Access Data gt gt tab Cell c function Operation Interval Device Trigger Handshake CSV Logging Logical Station Number 1 Modem QJ71C24 X Communication Settings No of a mo vE os arme cbe spem Word L3 Do parue Word E Cell Area Use Logical Sta Operation Interval Device Trigger Handshake CS Logging Logging function Logging 1 Modem Settings Settings Settings Settings Mandatory Settings Motset Setalready Cancel Optional Settings Motset Setalready m Detailed Item Description Explanation Select the logical station number required for makin communication Used to start the Communication Setup Utility to set a new logical Communication settings Communication settings station number and change the settings Enter the password when the password has been set to the 2 c Remote password 1 P connection target PLC Set the devices to be logged Qd Tem of set devices The number of devices currently set is displayed aye Preset cell areas The settings of the cell areas preset to the Excel book are displayed Section 6 2 1 1 Remote password is displayed when the logical station number selected in Logical Station N
158. ng oet the colors of cell area grid lines and cell filling Depending on the selection all area may be colored gray Refer to the Operating Precautions for details c Clear cell area at the start of communication Set whether the cell area will be cleared or not at the start of communication 1 Display example in the case where Clear cell area at the start of communication is checked lt Before the start of communication gt 2004 05 24 Mon 13 00 00 et ___ 3 lt At the start of communication gt i At the completion of the first collection gt E 2 Display example in the case where Clear cell area at the start of communication is not checked lt Before the start of communication gt 2004 05 24 Mon 13 00 00 __ eS NNNM lt At the start of communication gt 2004 05 24 Mon 13 00 00 2004 05 24 Mon 13 00 05 2004 05 24 Mon 13 00 10 i At the completion of the first collection gt 2004 05 24 Mon 13 00 00 2004 05 24 Mon 13 00 05 2004 05 24 Mon 13 00 10 2004 05 24 Mon 15 00 00 6 CELL SETTING d e Title gt Date Time Collection data 2004 05 24 Mon 13 24 14 30 100 0 37 e The title display line will not be the target of cell area clear at the start of New data location oet the newest data location when the logging function is used 1 When Last Line is selected 2002 08401 Thu 15 14 34 2002 08401 Thu 15 14 38 2002 06 01 Thu 1
159. nge from 000 to 999 When the number reaches the last the data of the next file are overwritten to the file of the first number In CSV logging data is added until the data in the CSV file reach the number of lines set in No of lines to be saved Add sequential number to File name When they reach the set number of lines a new CSV file is created The following shows the file name when data are saved 000 csv File number File name set in File name to save Overwrites data to the CSV file set in File name to save Fix the File name In CSV logging data is added until the data in the CSV file reach the number of lines set in No of lines to be saved 1 A UNC path name Wserver name path name cannot be specified as a file name After assigning the network drive specify the path name 6 CELL SETTING MELSOFT 6 3 When Monitor Is Selected This section describes the Cell Setting dialog box when Monitor is selected from Use of the lt lt Use gt gt tab lt lt Use gt gt tab Access Data gt gt tab Cell Settings Monitor function Cell Settings Monitor function ccess Data Operation Interval Device Trigger Handshake CS Logging Req Uu red setti ng peration Interval Device Trigger TERES CSV Logging Req Uu red setti Ng Logical Station Number 1 Modem GJ71C24 X Use Monitor Ad O Refer to Section Communication Setings Refer to Section Cell
160. nge of communication paths MX Sheet uses MX Component for communication between the PLC and personal computer Using a variety of communication paths supported by MX Component system configuration that meets user s requirement can be achieved lt Examples of communication using MX Component gt Lr ITO CY Y 3 Y 3 4 4 003 GATTI SL LTTE aaa SII Z ESSA SLL LOL ITT Y C1 ry oy ZI EE 2020002 Er LES Modem communication Gateway function communication 1 OVERVIEW MELSOFT 3 Each function can be controlled by device condition The condition of device data collection write can be set to PLC devices The execution of any MX Sheet function can be controlled from the PLC side lt When device data is collected written while bit device is on gt Device data is Device data is collected written collected written a le Corresponding functions Logging Monitor Write Alarm summary Comment display Automatic save Automatic print 4 Data logging using CSV file Using the logging or monitor function device data can be displayed on Excel sheet and simultaneously collected data can be saved into a CSV file Long term data collection is enabled by a single CSV file Display on Excel sheet did 40 50 680 Simultane
161. nge when these notifications appear Local Security Policy 5 Select Local Policies File Action View Help B Security Settings Name Description gt Account Policies Account Policies Password and account lockout policies F Local Policies Auditing user rights and security options polici Windows Firewall with Adv Windows Firewall with Advanced Security Public Key Policies 2 Software Restriction Policies 3 IP Security Policies on Local Internet Protocol Security IPsec Administratio gt Local Policies gt Windows Firewall with Advanced Seci 23 Public Key Policies gt Software Restriction Policies D 3 IP Security Policies on Local Compute Local Security 6 Select Security Options File Action View Help Af X Bb Security Settings Name Description gt Account Policies Audit Policy Audit Policy gt lig Local Policies User Rights Assignment User Rights Assignment gt Windows Firewall with Advanced Seci 3 z z cm Public Key Policies Security Options Security Options gt L7 Software Restriction Policies 3 IP Security Policies on Local Compute i To next page APP 19 APP 19 APPENDICES From preceding page Local Security Poli File Action View Help B E Security Settings Account Policies
162. ngs dialog box save file setting 1 2 3 4 5 File name to save Set the storage location and file name of the Excel book to be saved automatically The Excel file 5 xIsx xIsm xIsb or HTML file htm or CSV file csv is available as the file type 1 xlsx xlsm and xlsb are Workbook format extensions added to Excel 2007 or later 2 For the continuous operation when saving data automatically in HTML format refer to APPENDIX 7 opecify the sheet name Select the sheet name to be saved from the combo box It can be specified only when the File name to save is a CSV file Add date and time to File name The data and time data are added to the file name set in File name to save The following indicates the file name format when data is saved 20020523183536 extension Extension set to File name to save Seconds Minutes Hours Day Month Year File name set in File name to save Add sequential number to File name The file number is added to the file name set in File name to save A serial number can be set within the range from 000 to 999 When the number reaches the last the data of the next file are overwritten to the file of the first number The following indicates the file name format when data is saved 000 extension Extension set in File name to save File number File name set in File name to save Fix the File name Data is overwri
163. nsert Format Tools Data Window MxSheet M Help HRSA GRY o amp gt 2 2 da C BRED B c D Kind Date Cell Area Name ErrorNo Contents Informatior 2002 07 31 Wed 16 57 23 00000000 Communication was started Informatior 2002 07 31 Wed 16 58 14 00000002 Communication was completed Informatior 2002 08 01 Thu 14 00 04 00000000 Communication was started Warning 2002 08 01 Thu 14 00 05 Logging function e1000021 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 action is as follows Exit the program and restart the IBM PC AT compatible Reinstall MX Component lt ErrorCode 1808502 Hex gt lt At occurrence of communication Warning 2002 08 01 Thu 14 04 06 Logging function e1000021 Communication error has occurred in the open close of communication error error information is lt 00010003 Hex 01808502 Hex gt n B displayed on ErrorLog sheet 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 10 2 10 2 10 COMMUNICATION START AND COMMUNICATION END MELSOFT 10 2 Communication End This section explains the procedure to end MX Sheet communication 1 Ending communication Choose MX Sheet End Communicatio
164. nts Monitor function 260 points 70 points 1400 points 400 points is sd 200 points 70 points Logging function bss 1024 points 400 points 1 This number of device points applies to the case the data type is set to a character string APP 3 APP 3 APPENDICES MELSOFT 2 Performance values for Ethernet communication The following table indicates the performance values when the monitor and logging functions are executed using Ethernet communication CPU type Q25HCPU Connected module QJ71E71 10Mbps Operation Number of Device Points Function XN Setting example 1 Setting example 2 05s 5s 4000 points 800 points Monitor function ds 12000 points 1792 points 5s 20000 points 10000 points l aso 5120 points 1792 points Logging function 2120 points 2120 points 1 This number of device points applies to the case the data type is set to a character string 3 Scroll processing performance of Excel The following table indicates the times required by Excel for scroll processing when the logging function is used The following times applies to the case only Excel has been started on the personal computer 4 File size at save and required time The following table shows references for file size at save and time taken for saving a file depending on Excel version Book format In Excel 2007 or later especially in standard format file size may increase or
165. o communicate with the PLC The following setting example indicates the case where the same communication path has been set to multiple cell areas lt Setting example gt C Li E 1 2 Model name DO to D3 3 Lot Ma 05 to DE 4 5 Maximum value Maximum value 5 Minimum value Minimum value Current value D12 Current value a Inefficient setting When the above setting example is divided into four cell areas as indicated in the following table MX Sheet executes communication four times This causes communication load to increase decreasing communication efficiency Access Data Settings Operation Cell Area Name Cell Area Logical station Number of Device setting nterva number cells Product type 0 Ethernet DO Character string 0 Ethemet D5 Character string C5 C7 0 Ethemet D10 16 bit integer E 0 Ethemet D20 16 bit integer b Efficient setting When the above setting example is integrated into one cell area as indicated in the following table the collection write of device data is completed by making communication once This enables communication load to decrease improving communication efficiency Access Data Settings Operation Cell Area Name Cell Area Logical station Number of Device setting nterva number cells D10 16 bit integer DO Character string Product information C2 C3 C5 C7 E5 E7 0 Ethernet Ee creed 1s interval D20 16 bit integer A
166. o o x 0x CreateButton x O UmroedMXSheetseling J O Versiono 1 O Menu that can be selected x Menu that cannot be selected 1 Read only is displayed after the title of the following dialog box related to the Cell Settings Automatic save setting and Automatic print setting The setting contents can be confirmed but cannot be changed Cell Settings Automatic Save list e Automatic Save Automatic Print list e Automatic Print 15 2 15 2 15 PROTECT UNPROTECT MX SHEET SETTING MELSOFT b The Confirm Password dialog box is displayed Enter the password entered in the Protect MX Sheet setting dialog box again Confirm Password Reenter passvvord ta proceed Caution If you lose or forget the password it cannot be recovered cn The Confirm Password dialog box is closed and the MX Sheet setting is protected The Confirm Password dialog box is closed The MX Sheet setting is not protected If the MX Sheet setting is protected the properties of the Start Communication End Communication and 1 Shot Communication buttons can be edited 15 3 15 3 15 PROTECT UNPROTECT MX SHEET SETTING MELSOFT 15 2 Unprotect MX Sheet setting The MX Sheet setting is unprotected and the setting contents can be changed 1 Displaying Unprotect MX Sheet setting dialog box Choose MX Sheet Unprotect MX Sheet setting from the menu bar When Protect MX Sheet s
167. ogging save lines 9999999 lines Number of device points 2000 points a 1000 points Number of cell areas that be set 1000 1 Excel book Write function TO 0 1s to 3600s 0 5s to 3600s Communication interval time designation time designation Number of device points 2000 points 300 points Alarm summary Number of history lines 65536 lines 300 lines function Number of cell areas that can be set 100 1 Excel book Communication interval 0 1s to 3600s 0 5s to 3600s Number of device points Number of comments 1000 comments mM 1 Excel book display function Maximum number of registered points 500 1 Excel boo TUN 0 15 to 3600s 0 5s to 3600s Communication interval time designation time designation Automatic Time designation Available save automatic Device trigger designation Available print function Automatic save format Excel file HTML file CSV file Excel file For logging function Available For monitor function Available 1 shot 7 T For write function Available communication For alarm summary function For comment function Available A Available OLEXRead function macro Available OLEXWrite function 1 This number of device points applies to the case word device data is collected written in 16 bit integer APP 2 APP 2 APPENDICES MELSOFT APPENDIX 3 PROCESSING SPEED OF MX Sheet This section explains the performance values and the scroll processing performance of Excel wh
168. omatic print conversion 7 Precautions tag setup conversion 8 Precautions on OLEX functions Precautions on logical station numbers 1 When only the data of MX Chart have been converted by the data conversion function the Logical Station Numbers in the lt lt Access Data gt gt tabs are all converted into O in the cell settings of MX Sheet 2 When setting has been made using the direct station number system in Network of the Tag Setup Utility of MX Chart the Logical Station Numbers in the Access Data gt gt tabs are all converted into O in the Cell Setting dialog box of MX Sheet 3 When converting the MX Links communication settings for MX Component data conversion function automatically searches the empty MX Component logical station numbers and assigns the numbers to the communication settings MX Component logical station MX Component logical station numbers numbers after data conversion Logical Station Comment Number ioe Serial direct Q25HCPU Logical Station Number LEN Serial direct Q25HCPU Serial direct Q2ACPU Data conversion Serial direct Q2ACPU Computer link connection Q25HCPU Comment execution gt Ethernet connection Q25HCPU Ethernet connection Q2ACPU MX Links logical station numbers Logical Station Number Computer link connection Q25HCPU suse comecen cashcru Computer link connection Q2ACPU USB connection Q25HCPU 20 6
169. on Install Don t Install Microsoft Office Customization Installer Publisher cannot be verified X Are you sure you want to install this customization E Name MXShRibbon MXShRibbon From file C MELSEC Sheet MXShRibbon vsto Publisher Unknown Publisher While Office customizations can be useful they can potentially harm your computer If you do not trust the source do not install this software More Information Install Don t Install cx 3 lt Office 2007 gt General td View and manage Microsoft Office Add ins an Select Office button Excel Options Proofing Add ins Save Name a Location Type Office 201 0 gt Active Application Add ins Language guag MXShRibbon C MELSEC Sheet MXShRibbon vsto vstolocal COM Add in S t F L gt gt t b O ti Advanced Team Foundation Add in C EVPrivateAssembliesVTFSOfficeAdd in dl Add in e ec e a gt p IO n S Customize Ribbon Application Add ins Additional MX Sheet Add in C MELSEC Sheet MXShRibbon xlam Excel Add in Quick Access Toolbar Analysis ToolPak C e Officel4 Library Analysis ANALYS32 XLL_ Excel Add in rx Analysis ToolPak VBA C ffice14 Library Analysis ATPVBAEN XLAM Excel Add in Add Ins Custom XML Data C Microsoft Office Officel4 OFFRHD DLL Document Inspector T h E t S t Ad d Euro Currency Tools C Office Office14 Libran EUROTOOLXLAM Excel Add in
170. on Interval Device Trigger Handshake CSV Logging Comment display Comment 1 Modem Settings Settings Settings Comment display Comment 1 Modem Settings Settings Settings Mandatory Settings Motset Setalready Optional Settings Notset Setalready Mandatory Settings Notset Setalready OK Cancel Optional Settings Notset Setalready lt lt Device Trigger gt gt tab lt lt Handshake gt gt tab Cell Settings Comment display function Cell Settings Comment display function Use Access Data Comment Data Operation Interval S et as n ecessa ry Use Access Data Comment Data Operation Interval Device Trigger Set as n ecessa ry Set the Device Trigger Set Handshake Refe r to S ectio n Start with the request fromthe PLC Start with the request from the PC Refe r to S ectio n Responding device on the PC side Word Device 6 6 5 Bit Device 6 6 6 Word Device Device 00 Condition Range v 100 vi 9 Device 100 E IMonitoring lime 10 E Bit Device H Requesting device e CollectAvrite E on the PLC side Bit Device Word Device Device n Condition When ON X Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CSV Logging Comment display Comment 1 Modem Settings Settings Settings Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake
171. on time with the PLC is longer than the operation interval of MX Sheet a device data collection delay occurs Example Operation time is set to Regular interval 3s but the communication time with the PLC is 5s Operation interval 2s waiting time set to 3s Occurs Time Communication time 5s Since communication time is longer actual operation interval is 5s APP 5 APP 5 APPENDICES MELSOFT b Collection delay when device trigger function is used When the sum of the device trigger condition check time and the communication time with PLC is longer than the operation interval of MX Sheet a collection delay occurs during the next device trigger condition check Example When BO When ON has been set as the device trigger condition operation interval is 3s Operation interval 2s waiting time set to 3s Occurs Time Time necessary for communication 5s 1 Device trigger condition check time 2 Communication time ON BO OFF 1 2 is time necessary for communication c Collection delay when handshake function is used When the sum of the requesting device check time the communication time with PLC and the handshake processing time is longer than the operation interval of MX Sheet a collection delay occurs during the next requesting device check Example When the PLC side requesting device has been set to MO and the PC side responding device to M100 operation interval is
172. onditions for the device trigger 1 lt lt Device Trigger gt gt tab Cell Settings Logging function Set the Device Trigger C Bit Device Word Device Device po Condition Range Value 100 gt 200 Cell amp rea Name Use Logical Sta Operation Interval Device Trigger Handshake CSY Logging Logging function Logging 1 Modem_ Settings Settings Settings Settings Mandatory Settings Notset Setalready OK Cancel Optional Settings Notset Setalready Detailed Item Description l Explanation Set the Device Trigger Set when the device trigger is used Da a Device conditions Set the device conditions 2 b b Preset cell areas The settings of the cell areas preset to the Excel book are displayed Section 6 2 1 6 CELL SETTING MELSOFT 2 Detailed explanation a Set the Device Trigger When using the device trigger be sure to mark Set the Device Trigger b Device conditions oet the device conditions for the device trigger 1 Device type oet the type of the device used for the device trigger Set when using a bit device for the device trigger Set when using a word device for the device trigger 2 Device Enter the device used for the device trigger Enter the device name and device number in this order 3 the bit oet the corresponding bit of the word device Setting range 0 to 15 4 Condition Set the device trigger condition Available D
173. only in the specified time zone Number of settings 4 When Operation day has been set to Weekly or Monthly do not make the following setting that will span two days 3 When Connect each time depending on the operation interval is selected The telephone line is connected and disconnected according to the settings of Operation day and Operation time 6 18 6 18 6 CELL SETTING MELSOFT 3 Setting examples a When using communication other than modem communication Log Always 1 Setting example The following setting example shows that logging is always performed at regular intervals Cell Settings function ce Trigger Handshake CS ogging Set the Operation Interval Operation Daily C Weekly day Set the Operation Interval Marked Operation day r r r r Daily Marked Operation time Regular interval Minutely eens a Hourly C Time table Regular interval 60 seconds E Logging Time zone ES Log Always Marked Logging Time zone Log Always C Log only during the specified time zone Operation Interval Device Trigger Handshake CSV Logging Cell Area Name Use Logical Settings No settings settings No settings Logging function Logging TERG Mandatory Settings Notset Setalready Optional Settings Not set Setalready 2 Operation timing The following shows the operation timings in the setting example
174. or standard users User Account Control Detect application installations and prompt for elevation be User Account Control Only elevate executables that are signed and validated bie User Account Control Only elevate UlAccess applications that are installed in secure locations bie User Account Control Run all administrators in Admin Approval Mode bie User Account Control Switch to the secure desktop when prompting for elevation bie User Account Control Virtualize file and registry write failures to per user locations Security Setting Negotiate signing No minimum No minimum Disabled Disabled Enabled Disabled Not Defined Disabled Enabled Enabled Posix Disabled Disabled Prompt for credentials Enabled Disabled Enabled Enabled Enabled Enabled APP 20 User Account Control Behavior of the elevation prompt for ad Local Security Setting Explain User Account Control Behavior of the elevation prompt for administrators in Admin Approval Mode Elevate without prompting Prompt for credentials Prompt for consent Setting completion MELSOFT 7 Select User Account Control Behavior of the elevation prompt for administrators in Admin Approval Mode Prompt for consent 8 Select Elevate without prompting on the lt lt Local Security Setting gt gt tab and click OK APP 20 APPENDICES MELSOFT APPENDIX 9 AC
175. orkbook protection Do not set Protect Sheet and Protect Workbook to the ErrorLog sheet If such setting is made the ErrorLog sheet will not operate normally b Sheet name In the Excel book where MX Sheet has been set do not give the name ErrorLog to newly created worksheet chart or dialog sheet If this happens the ErrorLog sheet created by MX Sheet will not operate normally Application error occurring during use of Excel 2000 If an application error occurs at an exit from Excel 2000 check the symptoms and corrective measures at the following URL site as of July 2002 1 http www microsoft com JAPAN support kb articles p3 19 8 02 asp Document number JP319802 Title XL2000 Opening the file that has been sent using Outlook Express results in a forced end at an exit from Excel 1 The URL is valid as of July 2002 If the URL has been changed confirm the above document number and title and contact Microsoft Corporation Precautions on communication 1 5 Communication between personal computer and PLC When PLC device data are collected written using MX Sheet the communication restrictions that apply to MX Component also occur between the personal computer and PLC For the restrictions on communications between the personal computer and PLC refer to the MX Component Operating Manual Preview setting of Excel When starting the communication of MX Sheet do not activate the preview setting print prev
176. otherwise stated this manual uses the following abbreviations and terms for the explanation of MX Sheet EA indicates a volume license product Abbreviation of the MELSEC Q series corresponding PC CPU module PC CPU module 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 MX Links Generic product name of the product type SW3D5F CSKP E MX Chart Generic product name of the product type SW3D5F OLEX E Microsoft Windows 7 Starter Operating System Microsoft Windows 7 Home Premium Operating System Microsoft Windows 7 Professional Operating System Windows 7 Microsoft Windows 7 Ultimate Operating System and Microsoft Windows 7 Enterprise Operating System Note that the 32 bit version is designated as 32 bit Windows 7 and the 64 bit version is designated as 64 bit Windows 7 Generic term of Microsoft Windows Vista Home Basic Operating System Microsoft Windows Vista Home Premium Operating System Windows Vista Microsoft Windows Vista Business Operating System Microsoft Windows Vista Ultimate Operating System and Microsoft Windows Vista Enterprise Operating System Generic term of Microsoft Windows XP Professional Operating System and Windows XP M a e Microsoft Windows XP Home Edition Op
177. ous execution CSV file 2002 05 04 08 00 00 0 0 0 0 0 0 2002 05 04 08 00 10 10 20 30 40 50 60 No con b Compatibility with MX Chart MX Sheet can convert the set data of MX Chart into those of MX Sheet The communication settings of MX Links and various settings of MX Chart can be converted into the logical station numbers of MX Component and cell settings of MX Sheet respectively to utilize old assets efficiently E Save into CSV file Ei Hi Cnv 5 Ele Edit view Insert Format Tools Data Window Sheet M Help la x DSHS el t 8m o B c ara A1 x A B E aoa E reru qq m J Fl 2002 08 02 Fri 10 52 47 25 42 0 0 0 1 2002 08 02 Fri 10 52 48 26 42 0 0 0 2 2002 08 02 Fri 10 53 52 34 2 0 0 0 2002 08 02 Fri 10 52 49 27 43 0 0 0 3 002 08 02 Fri 10 53 53 35 3 0 0 0 2002 08 02 Fri 10 52 50 28 43 0 0 0 4 002 08 02 Fri 10 53 54 36 0 0 0 2002 08 02 Fri 10 52 51 29 44 0 0 5 2002 08 02 Fri 10 53 55 37 4 0 0 0 2002 08 02 Fri 10 52 52 30 44 0 0 0 8 2002 08 02 Fri 10 53 56 38 4 0 0 0 a TEE 3 m B 7 2002 08 02 F 5 0 0 0 0 8 102 084 0 9 0 10 0 Ch 12 2 0 D 13 2 0 0 14 0 0 15 0 2002 08 02 Fri 10 53 01 38 48 0 0 16 0 2002 08 02 Fri 10 53 02 38 49 0 0 0 17 0 2002 08 02 Fri 10 53 03 40 49 0
178. own below since the time when data has been actually read exceeds the regular interval Unlike with collection delay the error information is not p in the ErrorLog sheet 2002418401 Thu 13 08 25 32 2002 08 01 Thu 13 08 26 REA 2002 08 01 Thu 13 08 28 2002 08 01 Thu 13 08 28 27 ZUUmZUS UTThuT3U0829 356 28 Causes e Multiple cell areas have been set to the Excel book e Multiple cell areas use the same communication path Operation time of the Operation Interval tab has been set to Regular interval Time of 13 08 27 is incorrectly displayed as 13 08 28 Corrective actions e Decrease the number of cells set to the Excel book Increase the Regular interval setting e Reexamine the cell area settings Refer to APPENDIX 5 APP 9 APP 9 APPENDICES MELSOFT APPENDIX 5 CREATING THE Excel SHEET FOR MX Sheet When collecting writing device data by using MX Sheet the efficiency of communication with the PLC varies depending on the cell area settings The following provides the example of setting cell area for more effective communication 1 Communication efficiency and cell area specifying method When multiple cell areas have been set MX Sheet executes communication with the PLC in order of the cell areas When the same communication path has been set to multiple cell areas communication efficiency decreases since all cell areas use one communication path t
179. provided further that no special quality assurance or fail safe redundant or other safety features which exceed the general specifications of the PRODUCTS are required For details please contact the Mitsubishi representative in your region REVISIONS The manual number is given on the bottom left of the back cover Print Date Manual Number Aug 2002 SH NA 080348E A First edition Dec 2003 SH Aug 2004 SH Sep 2005 SH Nov 2006 SH NA 080348E E Oct 2007 SH May 2008 SH Jun 2009 SH NA 080348E B NA 080348E C NA 080348E D NA 080348E F NA 080348E G NA 080348E H Correction Section 6 2 1 Section 6 3 1 Section 6 4 1 Section 6 5 1 Section 17 4 Appendix 2 New Addition Chapter 14 Chapter 15 Chapter 16 Operating Precautions How to Use This Manual Section 1 1 oection 2 1 Section 3 1 Chapter 4 Chapter 5 Section 6 1 Section 6 2 Section 6 3 Section 6 4 Section 6 5 Section 6 6 Chapter 7 Chapter 8 oection 10 1 Section 10 2 Chapter 11 Section 12 1 Section 12 3 Chapter 14 to 17 changed to Chapter 17 to 20 Appendix 2 Appendix 3 Appendix 5 New Addition Appendix 8 Precautions on setting MX Sheet Section 2 1 Section 3 1 Section 3 2 Section 6 2 Section 6 2 2 Section 6 2 3 Section 6 3 Section 6 3 3 Section 6 4 Section 6 4 3 Section 6 5 Section 6 5 4 Section 6 6 oection 6 6 2 Section 6 6 4 Appendix 2 Correction Sect
180. questing source setting The following table indicates the monitoring time Requesting Source Setting Monitoring time Monitoring is executed from the time when the PC side responding device is set to the time when the PLC side Start with the request from the requesting device is reset If the PLC side responding device PLC is not reset after the elapse of the monitoring time the collected device data is discarded and the error log is displayed in the ErrorLog sheet Monitoring is executed from the time when the PC side requesting device is set to the time when the PLC side responding device is set If the PLC side requesting device is not set after the elapse of the monitoring time the error log is displayed in the ErrorLog sheet Start with the request from the PC 6 CELL SETTING MELSOFT 4 Sample ladders for handshake The following is the sample ladders for handshake used in the setting examples in 2 a When Start with the request from the PLC is selected Device Bit device X100 0 Ie ANNs M10 ata col Data col lection onditio trigger M10 M100 TO ata col Respondi Watchdog Requesti lection g devic time P ng devic rigger on the C side e on the PC 2 PLC MO K200 TO equesti Watchdog g devic time F on the C side PLC 2 TO 12 Timeout Error DO 6 CELL SETTING MELSOFT b When Start with the request from the PLC is selected Device Word device
181. r Operation Regular interval Minutely Second 4 C Hourly Timetable time 5 3 Telephone line connectivity time zone co Bein connected state always from the start of the communication Connect during the specified time zones only Connect each time depending on the operation interval Cell amp rea Name Use Logical Sta Operation Interval Device Trigger Handshake CSV Logging Monitor function Monitor 1 Modem Settings Settings Settings Settings Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CSV Logging Monitor function Monitor 1 Modem Settings Settings Settings Settings Mandatory Settings Notset Setalready OK Cancel Apply Optional Settings Notset Setalready Mandatory Settings Notset Setalready OK Cancel Optional Settings Setalready lt lt Handshake gt gt tab lt lt CSV Logging gt gt tab Cell Settings Monitor function Cell Settings Monitor function Use Access Data Operation Interval Device Trigger CS Logging S et as n ecessa ry Use Access Data Operation Interval Device Trigger Handshake S et as n ecessa ry Set Handshake Save as CSV file Start with the request fromthe PLC Start with the request from the PC Refe r to S ectio n Responding device Refer to Section Bit Device Value JON x i 1000 x No of lines to be saved Word Device
182. r condition check Data collection is executed when requesting device condition holds REMARK Note that if a data dropout occurs during use of the handshake error information is not registered to the ErrorLog sheet APP 8 APP 8 APPENDICES MELSOFT 3 Data dropout when modem communication function is used When modem communication function is used and Telephone line connectivity time zone is set for Connect each time depending on the operation interval a data dropout occurs due to use of a modem To collect PLC device data using modem communication function set MX Sheet while considering the modem connection time If a data dropout occurs during modem communication increase the operation interval setting of MX Sheet As operation interval set time longer than sum of 1 2 3 Operation interval Time 1 2 _ 1 Time to connect to modem 2 Communication time Time necessary for modem 3 Time to disconnect from modem communication Appendix 4 2 Date and Time When the logging function and CSV logging are used the date and time in the cell area and the CSV file may not be displayed correctly The following describes an example of the incorrect display the causes and corrective actions lt Example when Regular interval is set to 1s gt Although communication is made at the specified interval the date and time are not displayed correctly as sh
183. ransmission control c c c c _ Connection information up to CPU of the communication target station is integrated into one data to which logical station number is assigned Packing List The MX Sheet consists of the following products Product Name Quantity MX Sheet Version 1 1 license product CD ROM SW 1DS5C SHEET E License certificate End user software license agreement mi a MX Sheet Version 1 Volume license product CD ROM SW 1D5C SHEET EA End user software license agreement License certificate 1 The number of included license agreements is equivalent to the number of licenses 1 OVERVIEW MELSOFT 1 OVERVIEW MX Sheet is a communication support software package that allows device data collection etc by simple program less setting using Excel Logging function monitor function Write function Automatic print function Write po b r2 vs un i Sane Logging 002 7 31 Wed 17 00 00 h3 002 7 31 Wed 17 20 00 002 7 31 Wed 17 25 00 002 7 31 Wed 17 30 00 2002 7 31 Wed 17 35 00 Alarm summary function Comment display function Automatic save function Temperature within the normal range Temperature over the upper limit Excel book file HTML file MX Sheet CSV file agama IRV SIRE EL
184. re displayed in order of 1 to 12 6 CELL SETTING MELSOFT 6 3 2 Setting of the Access Data tab This section describes the setting of the lt lt Access Data gt gt tab for use of the monitor function In the lt lt Access Data gt gt tab set the logical station number required for communication with the PLC and the device data to be collected in the cell area 1 lt lt Access Data gt gt tab Cell Settings Monitor function Operation Interval Device Trigger Handshake CS Logging Logical Station Number 11 Modem GJ71C24 X Communication Settings No of m os ne al puo paie pmo peeeems m m Cell Area Use Logical Sta Operation Interval Device Trigger Handshake CSV Logging Monitor function Monitor 1 Modem Settings Settings Settings Settings Mandatory Settings Motset Setalready Cancel Optional Settings lotset Setalready m Detailed Item Description l Explanation Select the logical station number required for making Logical Station Number mE communication Used to start the Communication Setup Utility to set a new logical Communication settings station number and change the settings Section 6 2 2 Enter the password when the password has been set to the Remote password 1 d hos n ERR PLC la Aceessdat data ISetthedevicestobemonitored db o 000 the devices
185. rea D Change Sheet Name N Create Button W Protect Sheet setting R Options I Setting Data Export x Version Info V Toolbar Icons Right click of mouse go Cut Copy Paste Paste Special Insert Delete Clear Contents Insert Comment Format Cells Pick From List Add Watch Hyperlink MX Sheet Cell Settina L MX Sheet 1Shot Communication S MX Sheet Cut Cell Area T MX Sheet Copy Cell Area C MX Sheet Paste Cell Area P MX Sheet Delete Cell Area D lt lt Add Ins gt gt tab MxSheet 89 Ej be RE GI Cell Setting L Automatic Save Setting K Automatic Print Setting O Automatic Communication Startup Setting A Start Communication B 1Shot Communication S Cut Cell Area T Copy Cell Area C Delete Cell Area D Change Sheet Name N Create Button W Protect MX Sheet setting R Options D Setting Data Export X Version Info V If the Excel sheet type is other than the worksheet the MX Sheet menu is not displayed When using MX Sheet make setting on the worksheet o MX Sheet MENU SELECTION METHOD MELSOFT 2 MX Sheet menu details The following table details the items of the MX Sheet menu Item ww Reference Description Menu bar Right click Section Cell Setting L Fed Mx Sheet Cell settinaiL i eee Chapter
186. result of using the contents noted in this manual 2002 MITSUBISHI ELECTRIC CORPORATION Operating Precautions This section provides precautions in the following order 1 2 3 4 5 6 Precautions on OS and personal computer Precautions on setting MX Sheet Precautions on editing cells and Excel sheets Precautions on communication Precautions on use of VBA Precautions on use of other MELSOFT products 7 N N Precautions on OS and personal computer 1 When using of 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 Windows Vista and Windows 7 To make change Communication Settings a user who has an administrator authority must log on The administrator authority is also required to execute the data conversion function refer to Chapter 20 If the user account that does not have the administrator authority is used to execute the data conversion function MX Links MX Chart data cannot be converted 2 Coexistence of different Excel versions When different versions of Excel exist in a single personal computer MX Sheet will not operate normally For example Excel 2000 and Excel 2002 cannot coexist 3 Resume function etc of personal computer If any of the following has been set to the personal computer where MX Sheet is instal
187. rsion Microsoft Excel 2000 English version Microsoft Excel 2002 English version Microsoft Excel 2003 English version Microsoft Excel 2007 English version or 32 bit Microsoft Excel 2010 English version MX Component MX Component version 3 01B or later A Pentium 300MHz processor or higher is recommended for Windows XP Professional and Windows XP Home Edition 1GHz or higher is recommended for Windows Vista and Windows 7 This product does not work with a multiprocessor IBM PC AT compatible personal computer because the driver is not compatible with it Service Pack 3 or more is needed when using Windows NT Workstation 4 0 128MB or more is recommended for Windows XP 1GB or more is recommended for Windows Vista and 32 bit Windows 7 and 2GB or more is recommended for 64 bit Windows 7 Excel sheets created in the English environment can be used in the English environment only They cannot be used in other environment Windows XP Service Pack 2 or later is required for Excel 2007 For 32 bit Microsoft Excel 2010 Windows XP Service Pack 3 Windows Vista Service Pack 1 or higher or Windows 7 or later is required 64 bit Microsoft Excel 2010 is not supported When executing the Communication Setup Utility with administrator authority from Excel MX Component Version 3 12N or later is required 2 1 2 1 2 SYSTEM CONFIGURATION MELSOFT 1 When Windows XP Professional Operating System M
188. s N WARNING e Build an interlock circuit outside the PLC system to ensure that the whole system always works safely when changing the data of the running PLC or controlling the PLC status from the personal computer In addition be sure to incorporate the corrective action into the system to deal with the communication error due to the poor cable connection while operating the PLC CPU online from the peripheral device Operating Precautions N CAUTION e Read the manual carefully and confirm the safety before connecting a personal computer to the running CPU module to perform the online operation especially forced output and operating status change Incorrect operation may cause the machine damage and accidents e CONDITIONS OF USE FOR THE PRODUCT e 1 Mitsubishi programmable controller the PRODUCT shall be used in conditions 2 i where any problem fault or failure occurring in the PRODUCT if any shall not lead to any major or serious accident and li where the backup and fail safe function are systematically or automatically provided outside of the PRODUCT for the case of any problem fault or failure occurring in the PRODUCT The PRODUCT has been designed and manufactured for the purpose of being used in general industries MITSUBISHI SHALL HAVE NO RESPONSIBILITY OR LIABILITY INCLUDING BUT NOT LIMITED TO ANY AND ALL RESPONSIBILITY OR LIABILITY BASED ON CONTRACT WARRANTY TORT PRODUCT LIAB
189. se of the comment display function is the same as that of the Device Trigger tab for use of the logging function Refer to Section 6 2 4 for details 6 CELL SETTING MELSOFT 6 6 6 Setting of the Handshake tab This section describes the setting of the lt lt Handshake gt gt tab for use of the comment display function In the lt lt Handshake gt gt tab set the handshake requesting source and handshake processing 1 lt lt Handshake gt gt tab Cell Settings Comment display function Set Handshake Start with the request from the PLC C Start with the request from the PC Responding device on the PC side Bit Device Value ON v Word Device 0 Device 100 F i Monitoring i time Requesting device 2 Colectrite j 10 s onthe PLC side i Bit Device Word Device Device Condition When ON v Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CS Logging Comment display Comment 1 Modem Settings Settings Settings Mandatory Settings Notset Setalready OK Cancel Optional Settings Notset Setalready Detailed Item Description Explanation Set Handshake Handshake Set when using a handshake a Requesting source setting Set the requesting source of the handshake Section 6 2 5 b Handshake processing Set the handshake processing Preset cell areas The settings of the cell are
190. setting 6 Automatic Save Settinglk ERE SU save setting T t ke automati hapt Automatic Print SettinglO Chapter print setting 8 Used to make automatic Chapter 9 communication startup setting Automatic Communication Startup Setting A Used to start Section Start ication ark Communication B communication 10 1 A Used to end Section Ena rene Communication 1 10 2 rh Used t ke 1 shot Chapt 1 5hot Communication S Ms Sheer 15hot Communication s i ud nd communication 11 ES Section Cut Cell Areat T Sheet Cut Cell Areal T Used to cut a cell area 124 EXC Section 5 Copy Cell Area c Ig Ms Sheet Copy Cell Greatly Used to copy a cell area 12 2 Used to paste cell Section Paste Cell 4 P Sheet Paste Call A Pas aste Cell Area P EH eet Paste Cell Areal F 2 E t let ll ti Delete Cell Area fed Ms Sheet Delete Cell GreafD4 die ze area 12 4 m Used to change the Chapter Ch Sheet M REY Create Buttoni EN x Create the Start Section Communication Button 14 1 Stark Communication Buttont B Create the End Section Communication Button 14 2 End Communication ButtontEt Create the 1 Shot Section Communication Button 14 3 Protect the MX Sheet Section Unprotect the MX Sheet Section setting 15 2 Set the error
191. splayed Indicates the number of device points set for the logging function in the cell area Indicates the number of cells available for the cell area Indicates the number of cells where the device has been set in the cell area 6 15 6 15 6 CELL SETTING MELSOFT 6 2 3 Setting of the Operation Interval tab This section describes the setting of the lt lt Operation Interval gt gt tab for use of the logging function In the lt lt Operation Interval gt gt tab set the day time and time zone of the activation of the function for the cell area 1 Operation Interval gt gt tab Cell Settings Logging function V Set the Operation Interval Operation Daily C Weekly day C Monthly r r m r r Operation Regular interval Minutely eee rs C Hourly Time table HH si EN Logging Time zone Log Always C Log only during the specified time zone Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CS Logging Logging function Logging 1 Modem_ Settings Settings Settings Settings Mandatory Settings Notset Setalready OK Cancel Optional Settings Motset Setalready Detailed Item Description Explanation Set the Operation Interval Set the operation of the cell area valid or invalid 2 a Operation day Set the operation day of the logging activation 2 b Operation time Set the operation time of the logging a
192. splays the date and time of the personal computer at ErrorLog sheet registration 2002 09 11 Thu 15 14 34 E Indicates the time as hour minute second Indicates the day of the week as Sun Sunday Mon Monday Tue Tuesday Wed Wednesday Thu Thursday Fri Friday Sat Saturday Indicates the date as year month day d Cell Area Name The cell area name registered to the ErrorLog sheet is displayed It is not displayed when the communication starts and ends e Error No The error number is displayed Please specify the error number when inquiring about errors f Contents The data displayed in Contents are shown below Error definition is displayed The communication error has accurred in access data processing lt 00200104 Hex 01808503 gt USB driver send error Data send failed Review the system e g PLE CPU module setting and cable status Make USB setting on the control panel device manger af the OS Retry the method Exit the program and restart the IBM PC AT compatible lt Errorlode 1608503 Hex gt Corrective action for error is displayed e f the same error occurs twice or more successively in the same cell area only the error information of the first error will be registered to the ErrorLog sheet The error information of the second error or later will not displayed Make setting related to the Error Log sheet output format in the Options dialog box
193. string with the lowest data number is displayed Be sure to prevent double setting of the setting ranges 6 CELL SETTING MELSOFT 3 Setting example The following shows the setting examples in the cases where the data type is set to Bit and 16 bit integer a When data type is set to Bit Comment data gt gt tab setting example Device Data Type Hit DEC Bo coe T OFF M u 1 While MO is on Error occurrence is displayed in the cell 2 While MO is off Normal operation is displayed in the cell b When data type is set to 16 bit integer Comment data tab setting example Device D Data Type 16bit integer DEC Operation of DO 1 2 10000 1500 1 If the DO value is 10000 or more Temperature upper limit over is displayed in the cell 2 If the DO value is less than 10000 no comment character string is displayed 6 CELL SETTING MELSOFT 6 6 4 Setting of the Operation Interval tab This section describes the setting of the lt lt Operation Interval gt gt tab for use of the comment display function In the lt lt Operation Interval gt gt tab set the day time and time zone of the activation of the function for the cell area 1 Operation Interval gt gt tab Cell Settings Comment display function Use Access Data Comment Data f Ope Set the Operation Interval Operation day Daily C Weekly C Monthly Oper
194. t y User Account Control Do you want allow the following program make changes to this computer Program name REGIST MELSEC COMMUNICATION COM ADD IN r User Account Control If you started this program continue Verified publisher MITSUBISHI ELECTRIC CORPORATION C REGIST MELSEC COMMUNICATION COM ADD IN File origin Hard drive on this computer MITSUBISHI ELECTRIC CORPORATION v Details L Con nue Cancel Y Show details User Account Control helps stop unauthorized changes to your computer MXShRegRCom The message shown in the figure to the left appears to notify the completion Click OK SEX COM add in registration has been carried out successfully If you have already start Excel Excel please restart APP 25 APP 25 APPENDICES MELSOFT 4 Checking if the action works The following explains how to check if the action works or not 1 Start Excel Microsoft Office Customization Installer 2 When either of the screens to the left is displayed Publisher has been verified v click Are you sure you want to install this customization Name MXShRibbon MXShRibbon From file C MELSEC Sheet MXShRibbon vsto Publisher MITSUBISHI ELECTRIC CORPORATION While Office customizations can be useful they can potentially harm your computer If you do not trust the source do not install this software More Informati
195. t Check Display No check Not display Set whether the information message blue during the execution of communication will be Information Blue 1 displayed in the Error log sheet or not Check Display No check Not display Set whether the warning message pink during the execution of communication will be Warning Pink 1 displayed in the Error log sheet or not Check Display No check Not display Set whether the error message red during the execution of communication will be displayed Error Red 1 in the Error log sheet or not Check Display No check Not display Set whether the display will be switched to the Error log sheet or not if a warning or error Display Error Log sheet occurs during the execution of communication when an error occurs Check Display will be switched to the Error log sheet No check Display will not be switched to the Error log sheet Clear error log at the start Set whether the Error log will be cleared or not at the start of communication of communication Check clear No check Not clear 1 Setting can be made only when the Display error log check box has been checked 16 1 16 1 16 OPTIONS MELSOFT MEMO 17 SETTING DATA EXPORT MELSOFT 17 SETTING DATA EXPORT This chapter describes the procedure to output the settings of MX Sheet to a CSV file 1 Setting Data Export procedure Choose MX Sheet Setting Data Export from the menu bar By selecting the abov
196. t For operating MX Sheet continuously exit and reactivate Excel periodically If data are saved repeatedly in HTML format with the Automatic save function Excel may not operate properly The time for allowable continuous operation differs according to the operating environment Precautions on use of VBA 1 Incorporation of VBA program When incorporating a user created VBA program into the Excel sheet where MX Sheet has been set check the operation of the VBA program first and then perform MX Sheet programming for the Excel sheet VBA program creation MX Sheet utilizes OLE Automation for communication Do not perform the following on VBA programs 1 Do not execute the DoEvents method in a For Next loop 2 FileFilter is ignored in the GetSaveAsFileName method 3 Do not execute the Reset method in the Excel menu Precautions on use of other MELSOFT products 1 MX Component version MX Component Version 3 01B or later is required to use MX Sheet If MX Component Version 3 00A or earlier is used MX Sheet does not operate normally Logical station number Before deleting the logical station number from the Communication Setup Utility of MX Component check that the logical station number to be deleted is not used in MX Sheet If the logical station number used in MX Sheet is deleted MX Sheet does not operate normally Coexistence with MX Chart MX Sheet and MX Chart cannot be installed in a single personal computer
197. t tab for use of the write function is the same as that of the lt lt Operation Interval gt gt tab for use of the logging function Refer to Section 6 2 3 for details a Operation time The setting except for Regular interval is the same as the that of the logging function Refer to Section 6 2 3 for the setting except for Regular interval 1 When Regular interval is selected Device data is collected at the set second intervals When modem communication is used and Telephone line connectivity time zone is set to Connect each time depending on the operation interval set Regular interval to 30 seconds or more Setting range 0 1 to 0 9 in units of 0 1 seconds 1 to 3600 in units of 1 second 6 52 6 52 6 CELL SETTING MELSOFT 6 4 4 Setting of the Device Trigger tab This section describes the setting of the lt lt Device Trigger gt gt tab for use of the write function In the lt lt Device Trigger gt gt tab set the device conditions for the device trigger 1 lt lt Device Trigger gt gt tab Cell Settings Write function V Set the Device Trigger C Bit Device Word Device Device po Condition Range Value 100 gt 200 Cell amp rea Name Logical Sta Operation Interval Device Trigger Handshake CSY Logging Write function i 1 Modem_ Settings Settings Settings Mandatory Settings Notset Setalready OK Cancel Optional Settings Setalrea
198. t gt tab Cell Settings Comment display function iperation Interval Device Trigger Handshake Value Comment display Comment 1 Modem_ Settings Settings Settings Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CS Logging Mandatory Settings Not set Set already OK Cancel Optional Settings Motset Setalready Detailed Item Description The device set in Device of the lt lt Access Data gt gt tab is Value The contents setto the Value on the lt lt Access Data gt gt tab are displayed 6 CELL SETTING MELSOFT 2 Detailed explanation a Comment data 1 2 3 Range Lower and Range Upper oet the lower and upper limit values of the device The setting range changes depending on the data type The following table indicates the setting range of each data type Data Type Setting Range ON 0 OFF 16 bit integer 32768 to 32767 32 bit integer 2147483648 to 2147483647 Comment String Enter the comment character string to be displayed in the cell Number of characters up to 40 Character Color Set the color of the comment character string displayed in the cell Depending on the specified colors all colors may turn to gray Refer to the Operating Precautions for details If multiple comment data are set and their setting ranges are overlapped the comment character
199. t devices Chapter 6 Versi O ti M aiii Hi 32 bit Windows 7 English version Section 2 1 1 10L Environment O ti Version ii i 64 bit Windows 7 English version Section 2 1 141M Environment 32 bit Microsoft Excel 2010 English version Section 2 1 1 This number of device points is applied to the case the word device is set as 16 bit integer The settable device points depend on the device data type etc APP 28 APP 28 APPENDICES MELSOFT MEMO APP 29 APP 29 INDEX 1 1 Shot Communication 3 1 11 1 A Access data 6 10 6 41 6 49 6 58 6 66 Accessible 3 2 Accessible device ranges 3 2 Aa 6 60 WING EUR TET 6 60 Alarm summary function 3 1 6 54 Automatic Communication Startup setting MUN ene NUNG PEOR ee 3 1 9 1 Automatic print function 3 1 8 1 Automatic save function 3 1 7 1 C Cell 6 3 6 38 6 47 6 55 6 65 Cell Display Direction 6 38 6 47 Cell Setting dialog box 6 1 Change Sheet 13 1 Color Tor TMG cite it o det e toss 6 3 COlOF OF grid Ies eom ede one beds 6 3 Comment Data
200. t information about MX Sheet dialog box 1 Displaying Product information about MX Sheet dialog box Choose MX Sheet Version Info from the menu bar Product information about MX Sheet Excel Communication Support Tool MX Sheet Version 1 101 SW1DSC SHEET E COP Y RIGHT C 2002 MITSUBISHI ELECTRIC CORPORATIOM ALL RIGHTS RESERVED This product is licensed to Name Mitsubishi Company MITSUBISHI ELECRRIC Co ProductlD B Warning This product 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 extension possible under the law APP 1 APP 1 APPENDICES MELSOFT APPENDIX 2 COMPARISON BETWEEN MX Sheet AND MX Chart The following table indicates comparison between MX Sheet and MX Chart 0 1s to 3600s 1s to 3600s Logging function Communication interval time designation time designation Save print when cell is full Available Number of CSV logging save points 256 points Number of CSV logging save lines 9999999 lines Number of device points 2000 points P 1000 points Number of cell areas that can be set 1000 1 Excel book NE 0 1s to 3600s 0 5s to 3600s Monitor function Communication interval time designation time designation Number of CSV logging save points 1000 points Number of CSV l
201. ta tab Cell Settings Alarm summary function Required setting arm Data Operation Interval Device Trigger Logical Station Number 1 Modem_QJ71024 X Refe r to S e ct Communication Settings 6 5 1 fo 22208 Ss Logical Sta Operation Interval Device Trigger Handshake CSV Logging Alarm summary f Alarm summary 1 Modem Settings Settings Cell Area Name Use Mandatory Settings Motset Setalready Optional Settings Motset Setalready Operation Interval gt gt tab Cell Settings Alarm summary functio Set as necessary Refer to Section 6 5 3 ml uj S ut 5d Regular interval Telephone line connectivity time zone connected state always from the start of the communication Connect during the specified time zones only Cell Area Name Use Logical Stati Operation Interval Device Trigger Handshake CS Logging Alarm summary f Alarm summary 1 Modem Q Settings Settings Mandatory Settings Notset Setalready Optional Settings Setalready Set as necessary Refer to Section 6 5 5 OK Cancel Required setting Refer to Section 6 5 2 Set as necessary Refer to Section 6 5 4 6 CELL SETTING MELSOFT 6 5 1 Setting of the Use tab This section describes the setting of the lt lt Use gt gt tab for
202. ternate day can be specified Number of days that can be set 31 When 15th is set Operation is performed on the 15th every month e g January 15 February 15 March 15 When 31st is set Excepting February April June September and November operation is performed on the 31st every month For February April June September and November set the alternate day and processing in Alternate day when a date does not exist The following table indicates the setting items of Alternate day when a date does not exist the Operation is performed on the last day of February April June September or November Operation is performed on the first day of the First day of the next month PR l y next month Operation is not performed in February April N t June September and November Operation time Set the operation time of automatic save 1 When Regular interval is selected The Excel book is saved at the set minute intervals Setting range 1 to 1440 When Regular interval is set to 5 gt The Excel book is saved at intervals of 5 minutes e g 8 05 8 10 8 15 2 When Hourly is selected Automatic save is performed at the specified minute every hour Number of times that can be set 60 3 When Time table is selected Automatic save is performed at the specified time Number of times that can be set 50 Set the Device trigger oet this when performing automatic save using the
203. terval is set Date time 204773 Tue 14 57 18 2047713 Tue 14 57 20 2047 73 Tue 14 57 20 2004 07 13 Tue 14 57 20 2004 07 13 Tue 14 57 20 2004 07 15 Tue 14 57 20 2004 07 13 Tue 14 57 21 6 CELL SETTING MELSOFT 2 When Minutely is selected Device data is collected at the specified second every minute Number of times that can be set 60 3 When Hourly is selected Device data is collected at the specified minute every hour Number of times that can be set 60 4 When Time table is selected Device data is collected at the specified time Number of times that can be set 50 d Logging Time zone oet the time zone for logging 1 When Log Always is selected Logging is always performed at the specified operation time of the operation day 2 When Log only during the specified time zone is selected Logging is performed in the specified time zone only Number of settings 4 When Operation day has been set to Weekly or Monthly do not make the following setting that will span two days e Telephone line connectivity time zone oet the time zone for connection with the telephone line 1 When Be in connected state always from the start of the communication is selected The telephone line is connected upon start of MX Sheet communication and is kept connected until termination of MX Sheet communication 2 When Connect during the specified time zone only is selected The telephone line is connected
204. th the PLC Section 10 1 This function ends communication with the PLC Section 10 2 Chapter 9 1 shot Executes functions set in the selected cell range at any desired a Chapter 11 communication timing This function creates buttons to facilitate Start Communication Create Button A i Chapter 14 End Communication and 1 Shot Communication operations Protect Unprotect This function sets cancels the password for protecting the MX Chapter 15 MS Sheet setting Sheet setting 3 This function sets the output format of the error log sheet Chapter 16 pu ode Outputs MX Sheet settings in CSV file format Chapter 17 Converts communication settings of MX Links SW3D5F CSKPE and various settings of MX Chart SW3D5F OLEXE into logical station numbers of MX Component and cell settings of MX Sheet respectively Data conversion Chapter 20 1 This number of device points refers to the case where word device data are collected written in 16 bit integer The number of device points that can be set changes depending on the device data type etc 2 One Excel file one Excel book accepts 100 cell area setting 3 One Excel file one Excel book accepts 1000 cell area setting 4 Only bit devices can be set 5 One Excel file one Excel book accepts 500 cell area setting 3 FUNCTION LIST OF MX Sheet MELSOFT 3 2 Accessible CPUs and Accessible Device Ranges This section describes the accessible CPUs and accessibl
205. th the exception of the following items the setting of the lt lt Use gt gt tab for use of the monitor function is the same as that of the lt lt Use gt gt tab for use of the logging function Refer to Section 6 2 1 for details a Cell Area Set the cell area to be used by the monitor function 1 Setting examples Refer to Section 6 2 1 for the Cell Area setting examples 2 Setting ranges The following indicates the possible setting ranges of the cell area and number of specified cell areas Number of cells 2000 Number of specified cell areas 16 b Clear cell area at the start of communication Set whether the cell area will be cleared or not at the start of communication 1 Display example in the case where Clear cell area at the start of communication is checked lt Before the start of communication gt lt At the start of communication gt i At the completion of the first collection gt 6 CELL SETTING MELSOFT 2 Display example in the case where Clear cell area at the start of communication is not checked lt Before the start of communication gt c Cell Display Direction Set the monitor data display sequence 1 When Left to Right is selected lt When cell area B2 D5 is set to Left to Right gt Monitor data are displayed in order of 1 to 12 2 When Top to Bottom is selected lt When cell area B2 D5 is set to Top to Bottom gt Monitor data a
206. the Automatic save a Automatic save name list dialog box refer to Section 7 2 Create new automatic save setting data 5 oE the contents of the existing automatic save setting data oE Delete Delete the selected automatic save name from the automatic save name list Close the Automatic save list dialog box 7 AUTOMATIC SAVE SETTING MELSOFT 3 Detailed explanation a Automatic save name list Enable Check the one to be automatically saved Checked when new data is created Display the automatic save names created in the Automatic save dialog box T Display whether the Save at the end of communication check box in the Automatic save End of communication dialog box is checked or not in the form of Settings or No settings Display whether the Set the date and time check box in the Automatic save dialog box is Date time checked or not in the form of Settings or No settings Display whether the Set the Device trigger check box in the Automatic save dialog box is checked or not in the form of Settings or No settings Pisani uma Display whether the Clear cell area after automatic save check box in the Automatic save dialog box is checked or not in the form of Settings or No settings b Create New button When is clicked the Automatic save dialog box is displayed Refer to Section 7 2 for the setting operation Device trigger Automatic Save Automatic Sa
207. the Excel menu 1 Help Window 2 Choose the hidden Excel book and click OK Unhide workbook 3 As the Excel book appears save the Excel book 6 USB communication If the USB cable is connected disconnected the PLC CPU is reset or PLC is powered on off frequently during communication with the PLC CPU a communication error occurs and communication cannot be returned to normal If this happens disconnect the USB cable completely leave it for 5 seconds or more and reconnect it An error may occur at the time of initial communication after the above operation however communication will be made normally at and after the second time 7 Excel operation during communication a If Excel is in either of the following status MX Sheet cannot execute operations on Excel e g display into cells or save or print of an Excel book e A cell is in input status e g a cell is double clicked or the cursor is at the formula bar e A message box or a dialog box is displayed on Excel Minimize the number of input processes on Excel during communications b The operation of Excel during communication is restricted as follows e Excel 2000 2002 2003 hides the menu bar and toolbar e Excel 2007 hides tabs on the ribbon Although the office button and the quick access toolbar are displayed do not operate them during communications 4 Quick acc
208. the Operation Interval Operation Daily Weekly Monthly day Last day of the current month Operation Regular interval Minutely Time table E time B NN Telephone line connectivity time zone Bein connected state always from the start of the communication Connect during the specified time zones only y Connect each time depending on the operation interval Cell amp rea Name Logical Sta Operation Interval Device Trigger Handshake CS Logging Write function 1 Modem_ Settings Settings Settings Mandatory Settings Not set Set already 3 OK Cancel Apply Optional Settings Setalready Detailed Explanation Set the Operation Interval Set the operation of the cell area valid or invalid z Section 6 2 3 Operation day Set the operation day of the write function activation Operation time Set the operation time of the write function activation 2 a Set the telephone line connection timing and disconnection timing Section 6 2 3 a Preset cell areas The settings of the cell areas preset to the Excel book are displayed Section 6 2 1 1 Telephone line connectivity time zone is displayed when the logical station number selected in Logical Station Number of the lt lt Access Data gt gt tab is the one for modem communication 2 Detailed explanation With the exception of the following item the setting of the lt lt Operation Interval gt g
209. the device data to be written from the cell area 1 lt lt Access Data gt gt tab Cell Setting Write function nterva Device Trigger Handshake Logical Station Number Modem GJ71C24 Communication Settings No of Zoom No of cells Dev points l bit integer 32bit integer haracter string Bit C Real z ole El t3 aya 4 4 Cell amp rea Name Logical Sta Operation Interval Device Trigger Handshake CSV Logging Write function i 1 Modem Settings Settings Settings Mandatory Settings Not set Set already OK Cancel Optional Settings Setalready m Detailed Item Description l Explanation Logical Station Number Select the logical station number required for making communication e E Used to start the Communication Setup Utility to set a new logical Section 6 2 2 station number and change the settings Enter the password when the password has been set to the Remote password 1 ooa hes target PLC la Aceessdat data Set the devices where data will be written 2y a Number of set devices The number of devices currently set is displayed Section 6 2 2 Preset cell areas The settings of the cell areas preset to the Excel book are displayed Section 6 2 1 1 Remote password is displayed when the logical station number selected in Logical Station Number of the lt lt Access Data tab is the one for the password function
210. the file name to automatically save data 4 j 4 k OK Register the newly created or edited Automatic save name to the Automatic save list dialog box 1 A UNC path name Wserver name path name cannot be specified as a file name After assigning the network drive specify the path name 4 Detailed explanation a Automatic save name Attach specific names to the automatic save setting data Up to 50 automatic save names can be registered b Save at the end of communication Set this when performing automatic save at the end of communication When Clear cell area at the start of communication has been checked on the lt lt Use gt gt tab in the Cell Settings dialog box MX Sheet clears the target cell area data at the start of communication and starts data collection To save the data at the end of communication check Save at the end of communication c Set the date and time oet this when performing automatic save at the specified date and time 7 AUTOMATIC SAVE SETTING d e MELSOFT Operation day oet the operation day of the automatic save function 1 When Daily is selected oave is performed every day 2 When Weekly is selected Save is performed on the specified day of the week only Multiple days of the week can be set 3 When Monthly is selected Save is performed on the specified days only If the specified day does not exist in some months an al
211. ting the cell Paste the cell area while paying attention to the followings a Paste starting cell in cell area The paste starting cell in the cell area is the cell selected on the Excel sheet 14 1 Select cell and past cell area 1 2 3 4 5 6 i 8 2 Paste cell area using selected cell as paste starting cell 01 amp CO N b Overlap of cell areas If the paste area overlaps the other cell area that is already set the selected cell cannot be pasted Paste the cell after checking the other cell area Cell area to be pasted 67 CO ND 20020801 Thu 17 19 05 5 of o 2002 08 01 Thu 17 19 11 3 5 of o 2002 08 01 Thu 17 19 16 Ofi 3 25 of Q0 20020801 Thu 17 19 21 25 PORED he eg 31 25 00 20020801 Thu 17 19 31 o 9 35 of 2002 06 01 Thu 17 19 36 0 g 5 of o 20020801 Thu 17 19 41 o 5 of o Already set cell area As cell area enclosed by dotted lines overlaps cell area cannot be pasted 12 4 12 CELL EDITING MELSOFT 12 4 Deleting the Cell Area This section explains the procedure to delete the settings of the cell area 1 Displaying Delete Cell Area dialog box Choose MX Sheet Delete Cell Area from the menu bar 2 Delete Cell Area dialog box Delete Cell Area Cell Srea Cell Area Name Choose the cell area name of which settings wil
212. tion efficiency and use of Excel function cell reference When inconsecutive device data are displayed on Excel the efficiency of communication with the PLC decreases if multiple cell areas are set The following setting example indicates the case where inconsecutive device data are displayed on Excel lt Setting example gt Line DOT D2 LineB D5 06 JD d 0 Cn E CO 3 a Inefficient setting When the above setting example is divided into four cell areas as indicated in the following table MX Sheet executes communication four times This causes communication load to increase decreasing communication efficiency Access Data Settings Operation Cell Area Name Cell Area Logical station Number of Device setting nterva number cells b Efficient setting When the above setting example is integrated into one cell area as indicated in the following table and device data are collected in the other Excel sheet Sheet 2 this decreases communication load improving communication efficiency Set cell reference so that Excel sheet 1 which actually displays the device data will refer to the corresponding cells within Excel sheet2 which collects the device data MX Sheet need not be set in the Excel sheet where device data will be displayed actually Sheet 1 Access Data Settings Operation Cell Area Name Cell Area Logical station Number of interval Device setting nterva number cells A2
213. tions on Excel Book after Data Conversion Function Execution 20 6 APPENDICES APP 1 to APP 29 APPENDIX 1 VERSION CONFIRMATION 2cccccscceccecceccececcecccceccuccuccucceccucteecueneeaeeaeeaceeeeeeeeunesneeneees APP 1 APPENDIX 2 COMPARISON BETWEEN MX Sheet AND MX Chart APP 2 APPENDIX PROCESSING SPEED OF MX Sheet APP 3 APPENDIX 4 PROCESSING MX APP 5 Appendix 4 1 Collection Delay and Data APP 5 ADDendbe4d 2 Date and rig eset otiose ee ee en APP 9 APPENDIX 5 CREATING THE Excel SHEET FOR MX Sheet esses nnne APP 10 APPENDIX 6 PROCEDURE TO TRANSPORT DATA TO OTHER PERSONAL COMPUTER APP 13 APPENDIX f ATMEL FLE nre luce tote buio oso cu feces eters APP 14 APPENDIX 8 Warning Message Appears on Windows Vista and Windows 7 APP 15 Appendix 8 1 Overview of warning message sssssssssssseesseeeeennnnn nennen nain nnns snnt nnns APP 15 Appendix 8 2 Methods for preventing the warning MESSAGE cccccceessesseeeeeeeeecaeeseeeeeeeeessaaaeeeeeees APP 16 APPENDIX 9 ACTION FOR ERRORS OCCURRED WHE
214. trol Panel Home User Accounts Add or remove user accounts Appearance and Personalization Change desktop background Customize colors Adjust screen resolution Clock Language and Region Change keyboards or other input methods Ease of Access Let Windows suggest settings Optimize visual display Additional Options APP 18 Administrativ AutoPlay Backup and Color Date and Hardware Tools Restore Management Time 3 969 5 Device Ease of Folder Fonts Game Indexing Manager Acce Options Controllers Options iSCSI Initiator Keyboard Offline Files Penand People Near a 3 a Mm Personaliz Phone and Power Printers Problem Programs Modem Options Reports and Features 8 Regional and Scannersand Security Speech Sync Center Language Cameras Recogniti g L a amp Tablet PC Taskbar and Welcome Windows Settings Start Menu Center Anytim ae ety amp Windows Windows Windows Windows Windows Windows Defender Firewall Mobilit Sidebar SideShow Update To next page Default Programs Internet Options Performance Informatio E Network and Sharing Ce System Windows CardSpace 1 Select Start Control Panel 2 Select Classic View 3 Select Administrative Tools APP 18 APPENDICES MELSOFT From preceding page 4 Select Local Security Policy lt i
215. tten to the file set in File name to save 7 AUTOMATIC SAVE SETTING MELSOFT k Register the newly created or edited automatic save setting data When the registration is completed the automatic save name and settings are displayed as described below in the Automatic save list dialog box Display in Automatic save list The automatic save name and settings are additionally displayed at the bottom of the list and enable is checked When automatic save The automatic save name and settings are additionally name is changed displayed at the bottom of the list and enable is checked The automatic save name and settings are displayed in the When automatic save same position of the list Create New name is the same When the settings are changed the new settings are displayed When registering the existing automatic save setting data under a different automatic save name change the automatic save name in the Automatic save dialog box 8 AUTOMATIC PRINT SETTING MELSOFT 8 AUTOMATIC PRINT SETTING The following explains the setting contents for printing the Excel book or Excel sheet CSV format during MX Sheet operation hereafter abbreviated to the Automatic print setting data 8 1 Operation of Automatic print list Dialog Box In the Automatic print list dialog box manage the automatic print conditions in the form of a list 1 Displaying Automatic print list dialog box Choose MX Sheet
216. tup setting of the Excel Workbook currently open will be disabled Is ik OK Click on to cancel the automatic communication startup setting of the Excel book being edited 9 AUTOMATIC COMMUNICATION STARTUP SETTING MELSOFT 1 For the automatic communication startup setting do not save the Excel book under the hidden status An error occurs when starting the Excel book and MX Sheet cannot be used In such case save the Excel book under the display status and restart Excel To display the Excel book choose Window Unhide from the menu bar 2 When an Excel book on which the automatic communication startup has been set is opened with Excel 2007 or later the following symptoms may occur Excel does not respond Either of the following errors occurs MXShEngn e gt MxShComninitialiset3 Error 0000102 200 472 Microsoft Visual Basic i Can t execute code in break mode If the symptoms described above occur refer to APPENDIX 9 and install the COM add in MXShRibbon 10 COMMUNICATION START AND COMMUNICATION END MELSOFT 10 COMMUNICATION START AND COMMUNICATION END This chapter describes the start and end of MX Sheet communication 10 1 Communication Start This section explains the procedure to start MX Sheet communication manually 1 Starting communication Choose MX Sheet Start Communication 59 from the menu bar Excel 2003 or earlier Choose lt lt Add Ins gt
217. umber of the Access Data tab is the one for the password function compatible module 6 CELL SETTING MELSOFT 2 Detailed explanation a Logical Station Number Choose the logical station number required for communication If the logical station number has already been set the number appears in the list box and can be selected If the logical station number has not been set click on Communication Settings and set a new logical station number Communication settings This button is used to start the Communication Setup Utility to set a new logical station number and change the settings Select Run as administrator when the screen appears asking if execute programs with administrator authority or not After starting the Communication Setup Utility click on and set a new logical station number and change the settings with the Communication Setting Wizard For the detailed explanation of the Communication Setup Utility and Communication Setting Wizard refer to the MX Component Operating Manual Remote password Remote password box appears when the setting of the logical station number selected in Logical Station Number includes information on the connection to the module with the password function When the password has been set to the connection target PLC enter the password It need not be entered when the password has not been set Access data 1 Order of display Data are displayed in the
218. unication end message is displayed on ErrorLog sheet 10 3 10 3 11 1 SHOT COMMUNICATION MELSOFT 11 1 SHOT COMMUNICATION This chapter describes 1 shot communication function that makes communication with the selected cell area only once at any timing The 1 Shot Communication dialog box is used to set a cell area and execute 1 shot communication for the cell area 1 1 shot communication function ignores the device trigger and handshake settings made to the cell area and makes communication only once 2 1 shot communication function cannot work with the alarm summary function 1 Displaying 1 Shot Communication dialog box Choose MX Sheet 1 Shot Communication SE from the menu bar Or click the 1 Shot Communication Button refer to Section 14 3 2 1 Shot Communication dialog box 15hot Communication Cell Area Mame Choose the cell area for 1 shot communication Cell Area Name Only the cell area name set in the currently selected Excel sheet is displayed in Cell Area Name can be clicked after the cell area is selected in Cell Area OK Name Click on to execute 1 shot communication Used to close the 1 Shot Communication dialog box 1 After selecting the cell area set on the Excel sheet with the mouse or similar device start 1 shot communication by clicking OK in the 1 Shot Communication dialog box This displays the cell area name specified in Cell Area Name 2 Setting
219. use of the alarm summary function In the lt lt Use gt gt tab set the cell area display position of alarm data and operation in the case where cell is full 1 lt lt Use gt gt tab Cell Settings Alarm summary function ata arm Data Iperation Interval Device Trigger Alarm summary Cul Ar there Alarm summary function Cell Area B2 E6 Set the Color of Grid line B Set the Color for Filling i Clear cell area at the start of communication New data location Last Line v Display Contents Add title Add elapsed time Add number of occurrences Operation when cellis ful To scroll Display from the beginning without clearing the cell area Display from the beginning after clearing the cell area Cell Area Name Use Logical Sta Operation Interval Device Trigger Handshake CSY Logging Alarm summary f Alarm summary 1 Modem Settings Settings Mandatory Settings Not set J Set already OK Cancel Optional Settings Mot set Setalready Detailed Item Description Explanation Set the function to be used for the specified cell area Choose Alarm summary when using the alarm summary function h f th ifi Set e name of the specified cell area Maximum number of cell area names 100 Cell Area Enter the value to specify the cell area 2 a Set the Color of Grid line Set whether the specified cell area is provided with grid lines including color
220. ve Name Save at the end of communication Set the date and time e C Mirte MES Set the Device trigger BEST ues dan ea Clear cell area after automatic save lt gt File name to save Browse Add date and time to File name C Add sequential number to File name C Fix the File name OK Cancel 7 AUTOMATIC SAVE SETTING MELSOFT c In the setting of the selected automatic save name the Automatic save dialog box is displayed Refer to Section 7 2 for the setting operation Automatic Save List Enable Automatic Save Name End of communication Date time Device Trigger Clear cell area Create New Linetdaily Settings No settings Settings Settings Line2daily No settings No settings Settings No settings LineSdaily Settings No settings No settings Settings Line1 weekly No settings Line 1 monthly No settings No settings Line2monthly Settings No settings Line Smonthly Settings No settings Automatic Save Automatic Save Name Line1 weekly Save at the end of communication Set the date and time Sunday Operation Daily Weekly M Monday Monthly day Tuesday Wednesday Thursday Friday Saturday Ue ea ore TRE Operation Regular interval Hourly Timetable HH time Set the Device trigger Logical Station Mumbe Clear cell area after automatic save Specify the cell area
221. ve been checked When the device is ON at the start of communication it is counted as the first alarm When the number of occurrences exceeds 65535 it returns to 0 Display contents example on the Excel sheet when Add title Add elapsed time and Add number of occurrences are all checked Generation 2004 05 24 Mon 15 05 20 Pars Abnormal fault Mejrfalue Mo o o Generation 2004 05 24 Mon 15 05 31 Parts 2 Quantity Mmorfeure h ____ sakes Casa Waite tenn E Iie anon 6 CELL SETTING MELSOFT 6 5 2 Setting of the Access Data tab This section describes the setting of the lt lt Access Data gt gt tab for use of the alarm summary function In the lt lt Access Data gt gt tab set the logical station number required for communication with the PLC and the device data to be used for the alarm summary function 1 lt lt Access Data gt gt tab Cell Settings Alarm summary function rm Data Operation Interval Device Trigger Logical Station Number 11 Modem GJ71C24 Communication Settings Cell Area Name Logical Sta Operation Interval Device Trigger Handshake CSV Logging Alarm summary f Alarm summary 1 Modem Settings Settings Mandatory Settings Motset Setalready Cancel Optional Settings Notset Setalready m Detailed Item Description l Explanation Logical Station Number Select the logical station number required for making com
222. x is Date time checked or not in the form of Settings or No settings Display whether the Set the Device trigger check box in the Automatic print dialog box is checked or not in the form of Settings or No settings Cleaners Display whether the Clear cell area after automatic print check box in the Automatic print dialog box is checked or not in the form of Settings or No settings b Create New When is clicked the Automatic print dialog box is displayed Refer to Section 8 2 for the setting operation c In the setting of the selected automatic print name the Automatic print dialog box is displayed Refer to Section 8 2 for the setting operation Device trigger When the automatic print name list is double clicked or the key is pressed with the clicked line highlighted that operation has the same function as d The selected automatic print name is deleted When the key is pressed with the clicked line highlighted that operation has the same function as 8 AUTOMATIC PRINT SETTING MELSOFT 8 2 Setting of the Automatic Print Dialog Box In the Automatic Print dialog box set the print timing and print area 1 Print timing The following 3 timings are available for the automatic print setting All of them can be set at a time Refer to Chapter 7 for details e Automatic print is performed at the end of communication e Automatic print is performed at a specified time e Automatic pr
223. x of MX Chart Operating when cell is full of the lt lt Use gt gt tab is changed to Display from the beginning after clearing the cell area in the Cell Setting dialog box of MX Sheet 2 Display option in the Logging setup revision dialog box of MX Chart is converted into the following display format on MX Sheet 2002 05 22 Wed 18 31 08 Indicates the time as hour minute second Indicates the day of the week as Sun Sunday Mon Monday Tue Tuesday Wed Wednesday Thu Thursday Fri Friday Sat Saturday Indicates the date as year month day 3 If multiple cells of different column widths have been set in Cell Area of the Logging setup revision dialog box of MX Chart the column widths of the cell area are converted into the same minimum column width in the cell area 20 7 20 7 20 DATA CONVERSION FUNCTION MELSOFT Precautions on automatic save and automatic print conversion 1 If At refresh timing has been set in Save timing of the Automatic Save Setting dialog box of MX Chart Save Automatically check box is unmarked to make the automatic save settings invalid in the Automatic Save dialog box of MX Sheet If At refresh timing has been set in Print timing of the Automatic Print Setting dialog box of MX Chart Print Automatically check box is unmarked to make the automatic print settings invalid in the Automatic Print dialog box of MX Sheet Precautions on tag s
224. x100 0 ke Sis M10 ata col Data col ion lection itio trigger SM460 M10 3 lt gt Kl D200 _ T K100 D100 Respondi Requesti ng devic ng devic e on the e on the PC PLC K200 K100 0100 Requesti Watchdog ng devic Time P e on the C side PLC 2 K1 D200 MOV KO D100 Respondi Request ng devic ng devic e on the e on the PC FLC Watchdog Time P C side 2 TO 25 Timeout Error DO atchdog Time P side 5 END c When Start with the request from the PC is selected Device Bit device M100 X100 0 __ _ is M10 equesti Other da Data col g devic ta colle lection on the ction co trigger PC ndition MIO M100 TO ata col Requesti Watchdog Respondi lection g devic time P ng devic rigger on the C side e on the PC 2 PLC MO K200 TO espondi Watchdog q devic time P on the side PLC 2 TO 13 5 Timeout Error DO atchdog time P C side 6 CELL SETTING MELSOFT d When Start with the request from the PC is selected Device Word device OH Kl D200 s M10 Requesti Data col ng devic lection e on the trigger 5 4090 M10 X100 5 K100 D100 ata col Data col Respondi lection lection ng devic rigger conditio e on the n PLC K200 K100 Respondi Watchdog ng devic time e on the C side PLC 2 KO p200 MOV KG D100 Requesti Respondi ng devic ng devic e on the e on the PC PLC TO Watchdog tim
225. y Set the function to be used for the specified cell area Choose Logging when using the logging function Set the name of the specified cell area Cell Area Name Maximum number of cell area names 100 Cell Area Enter the value to specify the cell area Qa Set the Color of Grid line Set whether the specified cell area is provided with grid lines including color designation or not Set the Color for Setthe Color for Filling Set whether the specified cell area is colored or not When Clear cell area at the start of communication has a check mark the data in the cell area specified at the start of communication is cleared Default check Set the latest data display position of the logging data Last Line New data location The latest data is displayed at the lost of the specified cell area First Line The latest data is displayed at the first of the specified cell area Clear cell area at the start of communication To the next page 6 3 6 3 6 CELL SETTING MELSOFT n Detailed Item Description Explanation Set the operation to be performed when the specified cell area is full To scroll The displayed contents are scrolled and displayed Display from the first without clearing the cell area The data currently displayed in the cell area are overwritten and logging is resumed Before logging is resumed the Excel sheet can be printed and saved Display from the first after clearing the ce

MX Sheet Version 1 Operating Manual

Contents

Download Pdf Manuals

Related Search

Related Contents