Home › Technical articles

Đọc bằng tiếng Việt

What is MES: functions, signs you have outgrown Excel, custom software or MES on Ignition

TDL Industrial Automation · Last updated:

An MES sits at ISA-95 level 3, between ERP and the PLCs. The usual MES functions, the signs a plant has outgrown spreadsheets, three routes compared (Excel and paper, custom software, an MES product such as Ignition with Sepasoft), starting with OEE on one line, and the questions to answer before buying.

A manufacturing execution system (MES) is the plant software at ISA-95 level 3, between ERP and the PLCs: it receives work orders, records what each line actually made, with which materials and which stops, and keeps that record tied to orders, lots and equipment. Plants usually get there by one of three routes: spreadsheets and paper filled in by people, software written for the plant, or a commercial MES product. The example used here for the third route is Ignition with Sepasoft MES modules, the platform covered on TDL's MES page.

What an MES does

Wikipedia describes an MES as a computerised system that tracks and documents how raw materials become finished goods, and notes that this "as-built" record matters in regulated industries such as food, beverage and pharmaceuticals. In ISA-95 terms it sits at level 3, between ERP at level 4 and process control at levels 0 to 2. The ISA-95 article covers the levels, the level 3 activities and the ERP interface, so they are not repeated here.

The function list most often quoted comes from MESA International. Rockwell Automation's Plex eBook on MES gives the eleven functions defined in 1997: operations and detailed sequencing, resource allocation and status, document control, process management, data collection and acquisition, quality management, labour management, dispatching production units, product tracking and genealogy, performance analysis, and maintenance management. The model was updated in 2004 (c-MES) and again in 2008. On 30 June 2026 ISA announced that, effective that day, it has assumed certain assets of MESA International, including its educational programmes and content, as MESA International ceases operation.

On a plant project, the functions usually asked for are these:

Function What it records Where the data usually comes from
Work orders product, quantity, line and order status ERP or the planner; status from the line
Production tracking good and reject quantities per order, shift and line PLC counters, vision systems, checkweighers
OEE and downtime machine states, start and end of each stop, stop reasons PLC states and alarm words, operator input
Track and trace (genealogy) which material lots went into which finished lot material movements, lot scans
Quality and SPC samples, test results, control-chart rule violations manual entry or automatic sampling
Recipes and changeover settings and material amounts per product, changes made outside the recipe MES recipe store, operator terminals
MES sits between ERP and the control layerThree layers: ERP at level 4, MES at level 3 with its main functions, PLCs and machines in the control layer; between each pair, the data that goes down and the data that comes up.MES sits between ERP and the control layerERPlevel 4 · planning, materials, costingDown to MESwork orders and quantitiesproduct and material master dataUp to ERPgood and scrap quantitiesmaterials consumedorder statusMESlevel 3 · manufacturing operationsWork ordersProduction trackingOEE and downtimeTrack and traceQuality, SPCRecipes, changeoverDown to the linesettings per productorder startUp to MESmachine states, stop causesgood and reject countslot and barcode IDsControllevels 0 – 2 · PLCs, machines, scanners, scalesLevels per ISA-95 (see TDL’s ISA-95 article). Data examples from Sepasoft modulepages and the Rockwell Automation (Plex) “What Is MES” eBook. Figure: drawn by TDL.
Figure 1: MES sits between ERP and the control layer. On a phone, swipe sideways to see the whole figure.

OEE and downtime is often the first function a plant uses. Its formula, availability × performance × quality as Vorne's oee.com gives it, and a worked example are in the OEE article. The historian article covers the time-series store that often sits beside an MES.

Signs a plant has outgrown spreadsheets

Most MES functions start life as a spreadsheet or a paper form. In a joint OEE webinar, Inductive Automation and Sepasoft describe early tracking as manual entry on paper, in spreadsheets or on chalkboards, and contrast it with automatic recording, which times downtime events to the second and reduces the time operators spend on data entry. Plex's eBook adds that an ERP link removes the need to type the same data twice. Typical signs that a spreadsheet has reached its limit:

  • Figures are typed in at the end of the shift, and short stops never reach the sheet.
  • The same numbers are typed again into ERP, and the two disagree at month end.
  • Tracing one finished lot back to its raw-material lots takes days.
  • Several copies of the workbook circulate, and only one person can repair its formulas.
  • Each line uses its own list of stop reasons, so lines cannot be compared.

Three paths

Excel and paper

Spreadsheets need nothing new to start, but the data is typed by people after the event, with no PLC link unless someone builds one. Excel for Microsoft 365 has Show Changes, which lists who changed which cell, when, and the previous value, for the past 365 days. Microsoft also lists its gaps: edits from older or one-time-purchase versions are not tracked, uploading or saving a copy of the file can clear the list, and values changed by VBA may have no previous value. That helps with a shared workbook; it still records only what someone typed.

Custom software

The second route is software written in-house or by a contractor, often a database with web forms and sometimes a direct read of PLC tags. It can follow the plant's own way of working exactly. The risks: the knowledge tends to stay with one or two developers, nobody else can change it without the source code and documentation, and every operating system or database upgrade becomes the owner's project. In the same webinar, Inductive Automation and Sepasoft advise using built-in functions and ready-made components over complex custom solutions where possible; they sell such products, so read that as a vendor's view.

An MES product or MES modules on a platform

Many vendors sell MES software; the two examples here are in no particular order. Siemens describes Opcenter Execution as a family of MES products with variants for discrete, process, electronics, medical device, pharmaceutical and semiconductor production. AVEVA describes its MES as prebuilt, modular capability packages that can be deployed in stages, on premises or in a hybrid setup with the cloud.

The example TDL works with is Ignition with Sepasoft modules:

  • Platform. Ignition is licensed by the server, with unlimited clients, tags and projects; modules are bought as needed. Every Sepasoft module requires Ignition, and Sepasoft's Production module is always installed with the others.
  • Modules. OEE Downtime, Track & Trace, SPC, Settings & Changeover and Batch Procedure, plus Business Connector, Web Services and the Interface for SAP ERP for links to other systems.
  • Licensing. Perpetual licences. OEE Downtime, Track & Trace, SPC and Settings & Changeover are licensed per physical production site, with unlimited lines, machines and users; Batch Procedure and the connector modules are licensed per server. Support plans include upgrades while the plan is active.
  • OEE Downtime. Collection can be automatic, manual or mixed; in the most common setup the start and end of each event are recorded automatically and operators split events or add notes. Detection modes decide which machine is blamed when a line stops, for example the first cell to go down.
  • Track & Trace, Settings & Changeover. Track & Trace follows product from raw materials to finished goods, including consumables and by-products, and Sepasoft aligns it with ISA-95. Settings & Changeover stores settings and material amounts per product, and its variance log records settings changed at an operator terminal outside the recipe system.
  • PLC link. Ignition's Logix driver talks to ControlLogix over EtherNet/IP and is optimised for firmware 21 and later.
Three paths: Excel, custom software, an MES productThree columns: Excel and paper with manual entry, software written in-house or by a contractor, and an MES product or modules on a platform such as Ignition with Sepasoft; four traits each.Three paths: Excel, custom software, an MES productExcel and papertyped in by peopleCustom softwarein-house or contractorMES producte.g. Ignition + SepasoftStarts todayexisting tools, no projectFits the processwritten for the plant’s ownway of workingFunctions existconfigured ratherthan writtenEntered after the eventend of shift, frommemory or notesCan read the PLCsif the developer buildsthe interfaceReads the PLCsdrivers, states, counts,stop reasonsPartial change historyold versions, copies,VBA lose the trailKnowledge in few headsonly whoever holds thesource and documents canchange itVendor upgradeswhile the support planis activeTied to one personthe author knowsthe formulasUpgrades are a projectOS and database changesfall on the ownerLicences and learningper site or server; engineersmust learn itColumn 3 from Sepasoft (licensing, upgrades) and Inductive Automation (Logix driver) documents;column 1 from Microsoft’s Show Changes pages; the rest is TDL’s assessment. Figure: drawn by TDL.
Figure 2: Three paths: Excel, custom software, an MES product. On a phone, swipe sideways to see the whole figure.

Comparison

Vendor facts come from the cited documents; the rest is TDL's assessment.

Criterion Excel and paper Custom software MES product or modules
Data entry and quality typed by people, after the event as designed: forms, PLC reads or both states and counts from the PLC; operators add reasons
Link to PLC data none without extra work only if built and maintained platform drivers, such as Ignition's Logix driver
Audit trail and traceability Show Changes, with Microsoft's listed gaps only what was programmed genealogy is a product function; check audit features against your requirements
Who changes it when the process changes the sheet owner the developer, in code engineers, in configuration
Dependence on one person high high, unless code and documents are handed over lower: vendor documents and training courses exist
Upgrades and support office updates each change is paid work vendor releases; Sepasoft upgrades while a support plan is active
Licence model office licences already in place no product licence; agree source-code ownership Ignition per server; Sepasoft core modules per site, Batch Procedure and connectors per server

Configuration has its own trap. Sepasoft's documentation says that renaming an item in the production model creates a new item and disables the old one, and data recorded against the old item is not available to the new one, so it recommends naming every item correctly at the start.

Start small, then add modules

The OEE webinar advises a pilot on the line where the impact is largest, kept simple. TDL's MES page describes the same path: OEE Downtime on one line first, with Track & Trace, Settings & Changeover or SPC added when the plant needs them. The OEE page, with its in-browser calculator, suggests the bottleneck line or one with frequent changeovers.

  1. One line, OEE and downtime. Machine states, counts and stop reasons come from the PLC; missing signals are added with small program changes (see connecting existing equipment).
  2. More lines, one set of stop reasons. Every line uses the same lists, so lines can be compared; for plants with several sites, Sepasoft lists sharing standardised downtime reasons across sites as a multi-site feature of its Enterprise tier.
  3. Further functions when needed. Lot genealogy, quality sampling, settings per product.
  4. The ERP link. Orders come down, quantities and material use go up. On Ignition the Sepasoft options are Business Connector, Web Services and the Interface for SAP ERP.
Start small: OEE on one line, then expandFour steps: OEE and downtime on one line; more lines with one set of stop reasons; track and trace, SPC and changeover when needed; then the ERP link. The right column names the matching Sepasoft module.Start small: OEE on one line, then expandSTEPSEPASOFT MODULE (EXAMPLE)One line: OEE and downtimestates, counts, stop reasons from the PLC; thebottleneck line or one with many changeoversOEE DowntimeMore lines, one set of stop reasonsthe same state and reason lists onevery line, so lines can be comparedOEE Downtime(site licence)Add functions when neededlot genealogy, quality sampling, settings per productTrack & TraceSPCSettings & ChangeoverLink to ERPorders come down,quantities and materials go up, no retypingBusiness ConnectorWeb ServicesInterface for SAP ERP1234Sequence after the Inductive Automation and Sepasoft OEE webinar (start witha pilot line) and TDL’s MES page; module names from Sepasoft. Figure: drawn by TDL.
Figure 3: Start small: OEE on one line, then expand. On a phone, swipe sideways to see the whole figure.

Where a plant uses or chooses Sepasoft modules, TDL connects them to the line PLCs, so machine states, counts, alarms and recipe values come from the existing controllers. TDL also builds OEE dashboards on Ignition, FactoryTalk View SE or AVEVA System Platform with a historian.

Questions to answer before buying

  • Which question must the system answer first? For example, why one line loses an hour per shift, or which customers received product from a given raw-material lot.
  • What do the PLCs already hold? Machine states, counts, alarm words, and what must be added.
  • Who owns the master data? Products, ideal rates, stop reasons and shift calendars each need one owner.
  • What crosses to ERP? Each message, its direction and how often.
  • Which records must be kept? For how long, who may correct them, and whether an auditor will read them.
  • What does the licence cover? Sites, servers, and redundant, development and test systems, which Sepasoft sells as add-on licences.
  • Where does the server sit on the network? See the IEC 62443 article.

Frequently asked questions

What is the difference between MES and ERP?

ERP, at ISA-95 level 4, plans orders, materials and costs. An MES, at level 3, records what each line actually made, with which materials and which stops. ERP sends work orders down; the MES sends back quantities, material use and order status.

Can Excel be used as an MES?

Spreadsheets can cover some MES functions, with data typed in after the event and no PLC link unless someone builds one. Show Changes in Excel for Microsoft 365 keeps cell changes for 365 days, but Microsoft lists gaps such as edits from older versions, saved copies and values changed by VBA.

Is OEE software the same as an MES?

OEE and downtime is one MES function among several. Many plants start with it on one line; in the Sepasoft suite it is one module, and the others can be added later.

How are Sepasoft MES modules licensed?

With perpetual licences. OEE Downtime, Track & Trace, SPC and Settings & Changeover are licensed per physical production site with unlimited lines, machines and users; Batch Procedure and the connector modules per server. All of them require Ignition, which is licensed per server.

Do the PLC programs have to change to connect an MES?

Only where the data is missing. Ignition's Logix driver reads ControlLogix tags over EtherNet/IP, so existing machine states, counts and alarm words are read as they are, and missing signals are added with small program changes.

Sources

Read 2 November 2026. This article paraphrases the sources and does not quote them; read the original documents before designing or working on a system.

Related services:
OEE and downtime monitoring MES on Ignition (Sepasoft)