Mitsubishi Electric SW2DNC-Sheet -E v2 Operating Manual
en
MX Sheet Version 2 Operating Manual (Introduction)
-SW2DNC-SHEET-E
1
SAFETY PRECAUTIONS (Read these precautions before using this product.)
Before using this product, please read this manual and the relevant manuals carefully and pay full attention
to safety to handle the product correctly.
The precautions given in this manual are concerned with this product. For the safety precautions of the
programmable controller system, refer to the User's Manual for the CPU module.
In this manual, the safety precautions are classified into two levels: " WARNING" and " CAUTION".
Under some circumstances, failure to observe the precautions given under " CAUTION" may lead to
serious consequences.
Make sure that the end users read this manual and then keep the manual in a safe place for future
reference.
[Design Instructions]
WARNING When data change, program change, or status control is performed from a personal computer to a
running programmable controller, create an interlock circuit outside the programmable controller to
ensure that the whole system always operates safely.
Furthermore, for the online operations performed from a personal computer to a programmable
controller CPU, the corrective actions against a communication error due to such as a cable
connection fault should be predetermined as a system.
CAUTION The online operations performed from a personal computer to a running programmable controller
CPU (forced output and operating status changes) must be executed after the manual has been
carefully read and the safety has been ensured.
The operation failure may cause the injury or machine damage.
WARNING
CAUTION
Indicates that incorrect handling may cause hazardous conditions,
resulting in death or severe injury.
Indicates that incorrect handling may cause hazardous conditions,
resulting in minor or moderate injury or property damage.
2
CONDITIONS OF USE FOR THE PRODUCT
(1) Mitsubishi programmable controller ("the PRODUCT") shall be used in conditions;
i) where any problem, fault or failure occurring in the PRODUCT, if any, shall not lead to any major
or serious accident; and
ii) where the backup and fail-safe function are systematically or automatically provided outside of
the PRODUCT for the case of any problem, fault or failure occurring in the PRODUCT.
(2) The PRODUCT has been designed and manufactured for the purpose of being used in general
industries.
MITSUBISHI SHALL HAVE NO RESPONSIBILITY OR LIABILITY (INCLUDING, BUT NOT
LIMITED TO ANY AND ALL RESPONSIBILITY OR LIABILITY BASED ON CONTRACT,
WARRANTY, TORT, PRODUCT LIABILITY) FOR ANY INJURY OR DEATH TO PERSONS OR
LOSS OR DAMAGE TO PROPERTY CAUSED BY the PRODUCT THAT ARE OPERATED OR
USED IN APPLICATION NOT INTENDED OR EXCLUDED BY INSTRUCTIONS, PRECAUTIONS,
OR WARNING CONTAINED IN 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;
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 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.
3
INTRODUCTION
Thank you for your patronage. We appreciate your purchase of the engineering software, MELSOFT.
This manual is designed for users to understand operations of MX Component.
Before using the product, thoroughly read this manual and related manuals to develop full familiarity with the functions and
performance of MX Component and supported modules to ensure correct use.
RELATED MANUALS
The manuals related to this product are shown below.
Refer to the following tables when ordering required manuals.
Note: MX Sheet Version 2 Operating Manual is included on the CD-ROM of the software package in a PDF file format.
Manuals in printed form are sold separately for single purchase. Order a manual by quoting the manual number
(model code) listed in the table above.
Remark
Mitsubishi Electric Corporation does not guarantee the commercially-available Microsoft Windows Operating System- based software products that are introduced in this manual.
The copyright of this software package is owned by Mitsubishi Electric Corporation.
Reprinting or reproducing the part of or entire this manual without prior permission of Mitsubishi Electric Corporation is prohibited.
Although we have made the utmost effort to follow the revisions of the software and hardware, in some cases, unsynchronized matter may occur.
The software license must be purchased per personal computer.
This software package (including this manual) must be used under the Software License Agreement only.
Mitsubishi shall have no responsibility or liability for any defects caused by operating this software package (including this manual).
The descriptions in this manual may be subject to change without prior notice.
Manual name
< Manual number, model code > Description
MX Sheet Version 2 Operating Manual
Explains the operation procedures, setting and operation methods of
MX Sheet. (Sold separately)
MX Component Version 4 Operating Manual
Explains the setting and operation methods of each utility on MX
Component. (Sold separately)
MX Component Version 4 Programming Manual
Explains the programming procedures, details and error codes for
ACT control. (Sold separately)
CONTENTS
4
CONTENTS
SAFETY PRECAUTIONS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1 CONDITIONS OF USE FOR THE PRODUCT . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 2 INTRODUCTION . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 RELATED MANUALS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 3 HOW TO READ THIS MANUAL . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 5 TERMS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7 DEFINITIONS OF TERMS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 8
CHAPTER 1 OVERVIEW 9
1.1 What is MX Sheet? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 9
1.2 Functions Explained in This Manual . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .10
CHAPTER 2 OPERATING ENVIRONMENT 11
CHAPTER 3 INSTALLATION AND UNINSTALLATION 14
3.1 Installation. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14
3.1.1 Before installing MX Sheet. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 14
3.1.2 Installation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17
3.1.3 Installation Check. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24
3.1.4 Manual add-in registration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25
3.2 Uninstallation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 28
CHAPTER 4 SYSTEM CONFIGURATION USED IN THIS MANUAL 30
CHAPTER 5 MX Sheet OPERATION PROCEDURE 31
CHAPTER 6 OPERATING MX Sheet 32
6.1 Logging . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .32
6.2 Monitoring . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 40
6.3 Writing Data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 44
6.4 Automatic Saving . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48
6.5 Automatic Printing. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .52
6.6 Creating/Using button . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 54
APPENDIX 55
Appendix 1 Useful Functions of MX Sheet . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .55
Appendix 1.1 Alarm summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 55
Appendix 1.2 Comment display. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 56
Appendix 1.3 Device trigger . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 56
Appendix 1.4 Handshake. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 57
Appendix 1.5 CSV logging . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 58
Appendix 1.6 Automatic Communication Startup Setting . . . . . . . . . . . . . . . . . . . . . . . . . . 58
Appendix 1.7 Protect the MX Sheet Setting . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 59
Appendix 1.8 Error log setting. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 60
REVISIONS . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 61
5
HOW TO READ THIS MANUAL
The following explains the page composition and symbols in this manual.
The contents of the example page used here are different from the actual contents for the intention of explaining how to read
this manual.
Indicates the section
of currently open page. indicates
the particular
attention.
indicates
the useful tip.
describes the operating
procedure of the function.
Indicates the chapter of
currently open page.
Operating procedure
Remark
6
Symbols used in this manual
The following shows the symbols used in this manual with descriptions and examples.
No. Notation Description Example
[ ] Menu name on a menu bar [MX Sheet][Cell Setting]
(Underline) Screen name Cell Settings screen
" " Item name in a screen "Operation when cell is full"
<< >> Tab name in a screen <
Button in a screen button
- Keyboard key key
7
TERMS
This manual uses the terms listed in the following table unless otherwise noted.
Term Description
MX Sheet Generic product name for SWnDNC-SHEET-E and SWnDNC-SHEET-EA (n: version)
-EA indicates a volume license product.
Personal computer Generic term for personal computers on which Windows operates
PC CPU module Abbreviation for MELSEC-Q series compatible PC CPU module (CONTEC CO., LTD.product)
MX Component Generic product name for SWnDNC-ACT-E and SWnDNC-ACT-EA (n: version)
-EA indicates a volume-license product.
Windows 7 or later Generic term for Windows 7, Windows 8, Windows 8.1, and Windows 10.
Excel
Generic term for Microsoft Excel 2003, Microsoft Excel 2007,
Microsoft Excel 2010 (32-bit version), Microsoft Excel 2013 (32-bit version), Microsoft Excel 2016
(32-bit version), and Microsoft Excel 2019 (32-bit version)
System label Generic term for label names assigned to each device
It can be used instead of devices in programs.
8
DEFINITIONS OF TERMS
The following are the definitions of terms used in this manual.
(1) Logical station number A number assigned to the group of data that is integrated from the connection target information required for
communication within the communication setup utility.
(2) 1 shot communication This function executes the function set to the selected cell area at any timing.
Personal computer
USB
Time-out period Transmission speed Transmission control
Connection target information on up to CPU to communicate with is combined into one data,
to which logical station number is assigned.
Q06UDHCPU
9
CHAPTER 1 OVERVIEW
1
1.1 W hat is M
X S
heet?
CHAPTER 1 OVERVIEW
1.1 What is MX Sheet?
MX Sheet is a communication support software package that enables device data collection by simple program-less
setting using Excel.
For details, refer to the following manual.
MX Sheet Version 2 Operating Manual
Programmable controller CPU
MX Sheet
Logging function, monitor function Write function Automatic print function
Alarm summary function Comment display function Automatic save function
Excel book file HTML file CSV file
Error log setting function Protect MX Sheet
setting function
Create button function
10
1.2 Functions Explained in This Manual
This manual explains the following MX Sheet functions.
(1) Logging function ( Page 32, Section 6.1) This function accumulates the device data collected from the programmable controller as a history in the cell area
selected on an Excel spreadsheet.
(2) Monitor function ( Page 40, Section 6.2) This function displays the device data collected from the programmable controller in the cell area selected on an
Excel spreadsheet.
(3) Write function ( Page 44, Section 6.3) This function writes the values entered on an Excel spreadsheet to programmable controller devices.
(4) Automatic save function ( Page 48, Section 6.4) This function saves the Excel book automatically, when the specified device is triggered at the specified time.
(5) Automatic print function ( Page 52, Section 6.5) This function prints the Excel book or specified Excel spreadsheets automatically, when the specified device is
triggered at the specified time.
(6) Create button function ( Page 54, Section 6.6) This function executes each of the Start Communication, End Communication and 1 Shot Communication by
clicking the created button.
Device data are accumulated
as history.
Programmable controller CPU
Programmable controller data
are displayed on Excel.
Programmable controller CPU
Values entered on Excel are
written to programmable
controller devices.
11
CHAPTER 2 OPERATING ENVIRONMENT
2
CHAPTER 2 OPERATING ENVIRONMENT
The following table indicates the operating environment of MX Sheet.
Item Description
Personal computer Microsoft Windows supported personal computer
CPU Intel Core2 Duo 2GHz or higher is recommended.
Required memory Recommended 1GB or more *1
PC CPU module MELSEC-Q series-compatible PC CPU module (CONTEC CO., LTD.product)*2
Available hard disk capacity At installation: 300MB or more. *3, *4
At operation: Virtual memory available capacity is 512MB or more.
Display Resolution 1024 768 dots or more
Operating system *5, *6, *7, *8
(32-bit/64-bit)
Microsoft Windows XP Professional Operating System (English version) SP3 or later
Microsoft Windows XP Home Edition Operating System (English version) SP3 or later
Microsoft Windows Vista Home Basic Operating System (English version) SP2 or later
Microsoft Windows Vista Home Premium Operating System (English version) SP2 or later
Microsoft Windows Vista Business Operating System (English version) SP2 or later
Microsoft Windows Vista Ultimate Operating System (English version) SP2 or later
Microsoft Windows Vista Enterprise Operating System (English version) SP2 or later
Microsoft Windows 7 Starter Operating System (English version)
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)
Microsoft Windows 7 Enterprise Operating System (English version)
Microsoft Windows 8 Operating System (English version)
Microsoft Windows 8 Pro Operating System (English version)
Microsoft Windows 8 Enterprise Operating System (English version)
Microsoft Windows 8.1 Operating System (English version)
Microsoft Windows 8.1 Pro Operating System (English version)
Microsoft Windows 8.1 Enterprise Operating System (English version)
Microsoft Windows 10 Home Operating System (English version)
Microsoft Windows 10 Pro Operating System (English version)
Microsoft Windows 10 Enterprise Operating System (English version)
Microsoft Windows 10 Education Operating System (English version)
12
*1 : For 64-bit Windows 7 or later, 2GB or more memory is required. *2 : Production of the PC CPU module was discontinued in March, 2011. *3 : When installing .NET Framework, at least 1GB of free space is required. *4 : This includes the required free space for installation of MX Component.
*5 : Windows XP Professional (64-bit version) and Windows Vista (64-bit version) cannot be used. *6 : .NET Framework 2.0 and .NET Framework 2.0 English Language Pack installation is required. *7 : When the following functions are used, this product may not run properly.
Application start-up in Windows compatibility mode Fast user switching Remote desktop Windows XP Mode Windows Touch or Touch Modern UI Client Hyper-V Virtual Desktops Tablet mode
Windows Hibernate and Standby *8 : In the following case, the screen of this product may not work properly.
The size of the text and/or other items on the screen are changed to values other than default values (such as 96 DPI, 100%, and 9 pt).
*9 : Excel spreadsheets created in the English environment are applicable to the English environment only, cannot be used in the other environment.
*10 : When using Microsoft Excel 2007, Microsoft Windows XP Service Pack 2 or later is required.
*11 : When using Microsoft Excel 2010 (32-bit version), Microsoft Windows XP Service Pack 3, Microsoft Windows
Vista Service Pack 1, Microsoft Windows 7 or later is required.
Microsoft Excel 2010 (64-bit version) is not supported.
*12 : When using Microsoft Excel 2013 (32-bit version), Windows 7 or later is required. Microsoft Excel 2013 (64-bit version) is not supported.
*13 : When using Microsoft Excel 2016 (32-bit version), Windows 7 or later is required. Microsoft Excel 2016 (64-bit version) is not supported.
*14 : When using Microsoft Excel 2019 (32-bit version), Windows 10 or later is required. Microsoft Excel 2019 (64-bit version) is not supported.
Required software -
Excel*9
Microsoft Excel 2003 (English version), Microsoft Excel 2007 (English version)*10,
Microsoft Excel 2010 (32-bit version) (English version)*11,
Microsoft Excel 2013 (32-bit version) (English version)*12,
Microsoft Excel 2016 (32-bit version) (English version)*13, or
Microsoft Excel 2019 (32-bit version) (English version)*14
MX Component MX Component Version 4 or later
Item Description
13
CHAPTER 2 OPERATING ENVIRONMENT
2
Considerations when using Microsoft Excel 2010 or later In order to use MX Sheet, install 32-bit version. When installing MX Sheet on the personal computer where 64-bit version is installed, the following error message is displayed.
After MX Sheet is installed, 64-bit Microsoft Excel 2010 or later is installed and started, then an add-in is installed, the following error message is displayed.
14
CHAPTER 3 INSTALLATION AND
UNINSTALLATION
This chapter explains the installation and uninstallation procedures of MX Sheet.
3.1 Installation
This section explains MX Sheet installation. Screens from Windows 7 are used except for different operations
required in other operating systems.
3.1.1 Before installing MX Sheet
(1) Considerations when installing MX Sheet
Before installing MX Sheet, close any other applications running on Windows.
The installer may not work normally because of the operating system's or other companies' update
programs, such as Windows Update or the Java update program, start automatically. Install MX Sheet after
configuring those update programs not to start automatically.
When installing MX Sheet, log on as a user with the Administrator authority.
For the required personal computer operating environment to install MX Sheet, refer to the following chapter.
Page 11, CHAPTER 2
When the screen is not displayed (installation does not start) at start of the installer, start the installer by the following methods.
Copy the installer to a directory in a shallow layer such as "C:\temp", and start it. Right-click SETUP.EXE, select [Run as administrator], and start the installer. Exit the resident software for a keyboard/mouse, and restart the installer.
If the problem cannot be solved by the above methods, check whether the personal computer used applies to the following conditions.
"ntvdm.exe" is high load in the task manager (the usage rate of one CPU core is the maximum).
The personal computer is equipped with the 6th generation Intel Core processor. An image is output by using the on-board video (CPU built-in).
Any of edition of 32-bit version Microsoft Windows 7 is used. If any of the above conditions are applied, the Windows system module "ntvdm.exe" may be executed abnormally due to an incomplete BIOS code on the personal computer side, which causes failure to install correctly. Please contact the used personal computer manufacturer, and obtain the corrected BIOS and apply it.
15
CHAPTER 3 INSTALLATION AND UNINSTALLATION
3
3.1 Installa tion
3.1.1 B efo
re insta lling
M X
S he
et
(2) Security Setting of Excel The following explains the setting procedure of required Trust Center when using MX Sheet.
Operating procedure
1. Select the <
When using Microsoft Excel 2007, click the
Office button.
2. Select [Options].
When using Microsoft Excel 2007, click the
button.
To the next page
16
From the previous page
3. Select "Trust Center" from the list on the
left and click the button.
4. Select "Add-ins" from the list on the left,
and clear the items when they have the
check marks.
5. Select "ActiveX Settings" from the list on
the left, and select any item other than
"Disable all controls without notification".
6. Select "Macro Settings" from the list on the
left, and select "Enable all macros (not
recommended; potentially dangerous code
can run)".
7. After configuring the above settings, click
the button, and exit Excel.
Complete!
17
CHAPTER 3 INSTALLATION AND UNINSTALLATION
3
3.1 Installa tion
3.1.2 Installation
3.1.2 Installation
(1) Installing the product
Operating procedure
1. Right-click [Start] and select [Explorer].
Click the drive in which the disk is inserted, and
double-click "SETUP.EXE".
When user account control is enabled, the following
screen is displayed.
Click the button.
If the message on the left is displayed, click the
button to install MX Sheet, and then install
MX Component.
If the message on the left is displayed, click the
button to uninstall MX Sheet, then reinstall it.
If the message on the left is displayed, click the
button to uninstall MX Sheet, then reinstall it.
(Message on the left is displayed if "SETUP.EXE" of MX
Sheet Version 2.08J or later is executed when MX
Sheet Version 2.07H or earlier is installed.)
If the message on the left is displayed, install EnvMEL
(Page 22, (2) in this section).
After the operation is complete, restart installation
operation.
Continued on next page
18
From the previous page
2. Check that all applications is closed and click the
button.
If the applications are running, close all running
applications.
3. Starting setup.
Enter the name and company name, and click the
button.
4. Check the registered name and company name.
Check if the registered content is correct, and click the
button.
In order to change the information, click the
button to return to the previous screen.
5. Register the product ID.
Enter the product ID and click the button.
The product ID is printed on the license certificate
included with the product.
To the next page
19
CHAPTER 3 INSTALLATION AND UNINSTALLATION
3
3.1 Installa tion
3.1.2 Installation
From the previous page
6. Specify the installation destination folder.
If do not change the destination folder, click the
button.
In order to change the destination folder, click the
button and specify a new drive and folder.
7. Register the MX Sheet to Excel as an add-in
software.
Select the check box when registering an add-in.
(The check box is selected by default.)
Click the button.
For confirmation, the message on the left is displayed.
Click the button.
To the next page
20
In order to allow MX Sheet available, register MX Sheet menu to Excel as an add-in software. Normally, register an add-in software as instructed in step 7. If the "Register add-in check box" is cleared in step 7, the following message is displayed after the installation.
For the manual MX Sheet add-in registration method, refer to the following section. Page 25, Section 3.1.4 When installing an add-in for Excel, the add-in that hides the tabs is automatically installed for the Excel.
If VBA is not installed when an add-in is installed for Excel, the following error message is displayed, and MX Sheet cannot be used. Register add-in manually after installing VBA.
Tab
21
CHAPTER 3 INSTALLATION AND UNINSTALLATION
3
3.1 Installa tion
3.1.2 Installation
From the previous page
8. When installing a MELSOFT product, the message
on the left may be displayed. Click the
button to continue the installation.
When using Windows XP, click the
button.
(The screen display may be different partially
depending on the used operating system. This does not
affect the operation.)
(We have checked the operation and confirmed that no
error occurs after the installation.)
When the message on the left is displayed, installation
is complete.
9. Click the button to close the screen.
When the following screen is displayed, select "Yes, I
want to restart my computer now.".
Complete!
22
(2) When message is displayed at start of installation The following explains the countermeasures when the message is displayed at start of installation.
(a) When starting the installation of this product, the "This package is not in proper
operating environment" message is displayed, disabling normal completion of
installation. In such a case, close all applications and perform the following
operation.
Operating procedure
1. Execute SETUP.EXE in the "EnvMEL" folder on the CD-ROM of this product.
After executing "SETUP.EXE", install the product.
When user account control is enabled, the following screen is displayed.
Click the button.
When using any of the following operating systems, refer to the corresponding technical bulletin.
When using Windows Vista
TECHNICAL BULLETIN No.FA-A-0008
When using Windows 7 TECHNICAL BULLETIN No.FA-A-0091
When using Windows 8 and 8.1 TECHNICAL BULLETIN No.FA-A-0153
When using Windows 10 TECHNICAL BULLETIN No.FA-A-0207
2. Install the product again.
If this product is not installed properly at this time, restart the personal computer.
23
CHAPTER 3 INSTALLATION AND UNINSTALLATION
3
3.1 Installa tion
3.1.2 Installation
(b) The Program Compatibility Assistant screen may be displayed after installation.
Select "This program installed correctly" and restart the personal computer.
If "Reinstall using recommended settings" is selected, the "Windows XP SP2 compatibility mode" is
automatically set. Disable the "Windows XP SP2 compatibility mode" by the following procedure, and install the
product again.
1. Right-click on the setup.exe icon of the installation
target in the Windows explorer, and open the
SETUP.EXE Properties screen.
2. Select the <
button.
3. Clear the "Run this program in compatibility mode
for:" check box of compatibility mode in the
<
button.
4. Click the button on the SETUP.EXE
Properties screen.
5. Install the product again. (Page 17, (1) in this
section)
Clear the check box.
24
3.1.3 Installation Check
Check whether MX Sheet is installed normally or not as follows.
Operating procedure
(1) Start Excel.
(2) Confirm if the <
Sheet are added.
When using Microsoft Excel 2003, [MX Sheet] is added to the menu bar.
If the "Register add-in" is not selected on the Select add-in register. screen in step 7 (Page 17, Section 3.1.2), the icons and the menu of MX Sheet are not registered. Register MX Sheet as an add-in software manually after installation. For the manual add-in registration method, refer to the following section. Page 25, Section 3.1.4
MX Sheet icons and menu are displayed.
25
CHAPTER 3 INSTALLATION AND UNINSTALLATION
3
3.1 Installa tion
3.1.4 M a
nual a dd-in registration
3.1.4 Manual add-in registration
[MX Sheet] menu is not registered to the <
register. screen in step 7 (Page 17, Section 3.1.2) during installation.
Add-in registration is required to use MX Sheet.
Register MX Sheet as an add-in software in the following procedure.
Operating procedure
1. Start Excel and click the <
2. Select [Option].
To the next page
26
From the previous page
3. Excel Options screen is displayed.
Select "Add-Ins" and select "Excel Add-Ins" from
"Manage", and then click the button.
Select [Tool] [Add-Ins] from the menu bar to display
the Add-Ins screen.
Select the Office button and click the
button.
4. The Add-Ins screen is displayed.
Click the button.
5. The Browse screen is displayed.
Select "MXShMenu.xla" in "File name" and click the
button.
"MXShMenu.xla" is stored into [User specified folder]*1
[Sheet] at installation.
*1 : The installation destination folder is "C:\Melsec\Sheet" if it is not changed at installation.
6. The Add-Ins screen is displayed.
Check that the "MX Sheet" check box is selected, and
click the button again.
Install the add-in that hides the tabs to Excel as
instructed in step 6 and step 7.
To the next page
27
CHAPTER 3 INSTALLATION AND UNINSTALLATION
3
3.1 Installa tion
3.1.4 M a
nual a dd-in registration
In case VBA is not installed when registering the add-in, MX Sheet cannot be used. After installing VBA, register the add-in manually.
From the previous page
7. The Browse screen is displayed.
Select "MXShRibbon.xlam" in "File name", and click the
button.
8. The Add-Ins screen is displayed.
Check that "Additional MX Sheet Add-in" is selected,
and click the button.
9. Check that [MX Sheet] is added to the <
tab.
The icon buttons are also displayed.
The manual add-in registration is complete.
Complete!
28
3.2 Uninstallation
This section explains MX Sheet unistallation.
Screens from Windows 7 are used except for different operations required in other operating systems.
Operating procedure
1. Select [Start] [Control Panel] "Uninstall a
program".
[Start] [Control Panel] "Add/Remove Programs"
2. Select "MX Sheet" from the list of programs and
select "Uninstall/Change".
Select "MX Sheet" from the list of programs and click
the "Change/Remove".
When user account control is enabled, the following
screen is displayed.
Click the button or the button.
3. Click the button.
When not uninstalling MX Sheet, click the
button to return to the preceding screen.
Components indicate the installed icons and files.
To the next page
29
CHAPTER 3 INSTALLATION AND UNINSTALLATION
3
3.2 U ninstallation
From the previous page
When the screen on the left is displayed, uninstall is
complete.
4. Click the button to close the screen.
5. Restart the personal computer.
Complete!
30
CHAPTER 4 SYSTEM CONFIGURATION USED IN
THIS MANUAL
This manual explains system configuration as follows.
System Equipment Description
Personal computer
Personal computer that satisfies the operating environment of MX Sheet.
For details, refer to the following chapter.
Page 11, CHAPTER 2.
Software
Operating system Microsoft Windows 7 Professional Operating System (English version)
MX Sheet MX Sheet Version 2
MX Component MX Component Version 4
Excel Microsoft Excel 2010 (32-bit version) (English version)
Programmable controller CPU Q06UDHCPU
USB cable MR-J3USBCBL3M
Printer Printer compliant with the personal computer specifications.
Personal computer
Printer
USB cable
MX Component MX Sheet
Programmable controller
CPU
31
CHAPTER 5 MX Sheet OPERATION PROCEDURE
5
CHAPTER 5 MX Sheet OPERATION PROCEDURE
This chapter explains the MX Sheet operation procedure.
*1 : Be sure to save the Excel book before performing the MX Sheet settings. MX Sheet cannot be set unless the Excel book is saved.
Remark
Refer to the Excel manual for Excel operation.
Select the function to be used, and set the
MX Sheet settings.
Start communication.
Logging function
Write function
Comment display function
Automatic print function
Monitor function
Alarm summary function
Automatic save function
End communication.
Complete
Start Excel and save the Excel book. *1
32
CHAPTER 6 OPERATING MX Sheet
This chapter explains the following functions with examples.
6.1 Logging
This section provides an example of creating an Excel spreadsheet using the logging function.
(1) Creation example Set the following Excel spreadsheet.
Function Reference Section
Logging function Page 32, Section 6.1
Monitor function Page 40, Section 6.2
Write function Page 44, Section 6.3
Automatic save function Page 48, Section 6.4
Automatic print function Page 52, Section 6.5
Create button function Page 54, Section 6.6
10 logging data are displayed.
The latest logging data is displayed on the last line.
Scrolled up in order.
Logging times are displayed. Content of D0 to D4 are displayed in order
from left to right.
33
CHAPTER 6 OPERATING MX Sheet
6
6.1 Lo gging
(2) Setting MX Sheet This section explains the procedure of creating an Excel spreadsheet for logging function.
Operating procedure
1. Saving the Excel book
Start Excel and save the Excel book.
2. Specifying the cell area
Drag the cell (B2 to G11 in this example) on the left
screen to specify the cell area in which logging data is
displayed.
3. Displaying the Cell Settings screen
Select the <
[Cell Setting] to display the Cell Settings screen.
4. Setting the <
Set the following items of the <
After setting, select the <
Use : Logging Cell Area Name : Logging function Cell Area : B2:G11 New data location : Last Line Display Contents : Add date and
time details Operation when cell is full: To scroll
To the next page
34
From the previous page
5. Setting the logical station number on the <
Data>> tab.
Click the button to start the
communication setup utility for setting the logical station
number.
When the following screen is displayed, click the
button.
When logging on without administrator authority, the
password input screen is displayed as follows.
After inputting the password, click the button or
the button.
The privilege escalation allowance screen on User
Account Control screen is displayed as follows.*1
*1 : In order to disable the appearance of the message above, refer to the following manual. MX Sheet Version 2 Operating Manual
To the next page
35
CHAPTER 6 OPERATING MX Sheet
6
6.1 Lo gging
From the previous page
Clicking the button or "Allow" executes the
communication setup utility with administrator authority.
When executing without administrator authority, the
communication setup data can be checked, however,
when clicking the button on the
Communication Setting Wizard screen, the error occurs
as follow.
6. Starting the Communication Setting Wizard
After starting the communication setup utility, select the
<
7. Setting the logical station number
Set "1" in "Logical station number" and click the
button.
To the next page
36
From the previous page
8. Setting the personal computer side interface
Set the following items and click the button.
PC side I/F : USB Time out : 10000