Step 6: Complete the Mapping to Import FMEA Information

(Continuing the worked example from import-configuration-guide-fmea-example-item-mapping.md, using the same source spreadsheet with items and failure mode information in one sheet.)

3.2.2.1 Step 6a: Fill in the Name of the Worksheet of the XLSX File From Which the FMEA Data Will Be Imported

The purpose of filling in the name of the Worksheet is for MADE to know from which worksheet the FMEA data will be pulled. This field is case sensitive, so the user needs to write the worksheet name exactly as it appears in the XLSX file.

To complete: Select FMECA tab, enter Worksheet name (Figure 15 shows Worksheet field, initially with an error "There are missing mandatory parameters in the fmea data import configuration").

3.2.2.2 Step 6b: Set the Number of Header Rows in the XLSX File

The number entered into the Header Rows is the number of rows MADE will skip when reading in data from the XLSX file. For this example, Header rows is 6.

3.2.2.3 Step 6c: Define FMEA Mapping

Table 3: FMEA property definition

MADE Property	Property Type	Comment
*Item Number	Text	Mandatory mapping. Key property that ties together item and FMEA information
*Function	Text	Mandatory mapping
*Failure Mode	Text	Mandatory mapping
*Failure Mode ID	Text	Mandatory mapping
Failure Cause	Text
Local Effects	Text
Next Effects	Text
End Effect	Text
Detection Methods	Text	Define custom separator if required.
Compensating Provisions	Text	Define custom separator if required.
Prevention Controls	Text	Define custom separator if required.
Substantiation Actions	Text	Define custom separator if required.
MIL-STD-1629A – Failure Effect Probability	Text
MIL-STD-1629A – Failure Mode Ratio	Text
MIL-STD-1629A – Failure Rate	Text
MIL-STD-1629A – Probability of Occurrence	Text
MIL-STD-1629A – Severity Classification	Text
MIL-STD-1629A – Operating Time	Text
MIL-STD-1629A – Failure Mode Criticality Number	Text
MIL-STD-1629A – Item Criticality Number	Text
MIL-STD-882E - Probability	Text
MIL-STD-882E – Probability Level	Text
MIL-STD-882E - Severity	Text
MIL-STD-882E – Severity Category	Text
MIL-STD-882E – Risk Assessment Code	Text
RPN - Occurrence	Text
RPN - Severity	Text
RPN - Detection	Text
RPN – Risk Priority Number	Text
Narrative	Text
Comment	Text
Parent Item Number	Text

3.2.2.3.1 Mapping Rules

• Enter the column header name from the source file in the Name column. This is optional, but if entered, it must match with the respective column header name in the source file.
• Properties (Item Number, Function, & Failure Mode) must be mapped.
• If the source file has multiple Detection Methods defined in one cell for a failure mode, the software considers ',' as the default separator, importing different methods as separate entries. This approach also applies to Compensating Provisions, Prevention Controls, and Substantiation Actions.
  • Users can change the separator by clicking in the corresponding cell in the Configuration column, then clicking on Custom to open a dialog and define the separator used in the source file.

Figure 16 ("Ability to define Custom separator") shows the "Detection Methods configuration" dialog: "Configure the separator and splitting behavior of the List parameter." Separator radio options: Comma (default), New line, Custom (with text field); Trim values: Yes / No. Resulting Configuration column value shown as "Separator: ',', Trim: Yes".

To create a mapping (Figure 17): Click plus to add a row, enter Name (optional), select MADE property. Example: Column A → Name = "ID number" → MADE Property = "Item Number" → Type = Text → Validation = N/A.

The next two columns in the source file are Item Name and LCN (columns B & C) — item properties already mapped in the Item tab. Therefore it is necessary to define these properties in the FMEA Data tab and instruct the software to ignore them for FMEA mapping:

Figure 18 shows: A → ID number → Item Number → Text; B → Item Name → Ignored → N/A; C → LCN → Ignored → N/A.

The next two columns in the source file are Item Function and Failure Modes (columns D & E):

Figure 19 shows: D → Item Function → Function → Text; E → Failure Modes → Failure Mode → Text.

Continue the process to map all the columns in the source file. Figure 20 ("Complete mapping of FMEA information") shows the final full mapping for all columns A through AI:

Column	Name	MADE Property	Type	Configuration
A	Item Number (LCN)	Item Number	Text
B	Nomenclature	Ignored	N/A
C	Function Num	Ignored	N/A
D	Item Function	Function	Text
E	Functional Failure Letter	Ignored	N/A
F	Failure Mode	Failure Mode	Text
G	Mission Phase/Operational Mode	Local Effects	Text
H	Local Effects	Next Effects	Text
I	Next Higher Effects	End Effect	Text
J	End Effects	(continues; see row K)
K	Failure Detection Method	Detection Methods	Text	Separator: ',', Trim: Yes
L	Failure Isolation Method	Ignored	N/A
M	Compensating Provisions	Compensating Provisions	Text	Separator: ',', Trim: Yes
N	Severity Classification	MIL-STD-1629A - Severity Class.	Text
O	Estimated MTBF	Ignored	N/A
P	Failure Rate	MIL-STD-1629A - Failure Rate	Text
Q	Failure Rate Data Source	Ignored	N/A
R	Failure Effect Probability	MIL-STD-1629A - Failure Effect Probability	Text
S	Operating Time / Period of Exposure	MIL-STD-1629A - Operating Time	Text
T	Failure Mode Criticality	MIL-STD-1629A - Failure Mode Criticality Number	Text
U	Probability of Occurrence	MIL-STD-1629A - Probability of Occurrence	Text
V	Hazard Risk Index	Ignored	N/A
W	Item Criticality Number	MIL-STD-1629A - Item Criticality Number	Text
X	SCFN IDs	Ignored	N/A
Y	Unique Fault Identifier	Ignored	N/A
Z	Failure Mode Tested?	Ignored	N/A
AA	Test Plan Num	Ignored	N/A
AB	Isolation (Ambiguity Group)	Ignored	N/A
AC	Ambiguity Group Size	Ignored	N/A
AD	Detected Failure Rate	Ignored	N/A
AE	Isolated Failure Rate	Ignored	N/A
AF	Remarks	Comment	Text
AG	Failure Mode Ratio	MIL-STD-1629A - Failure Mode Ratio	Text
AH	LCN	Ignored	N/A

(Note on source fidelity: the table above is transcribed from the compact screenshot in Figure 20 of the source PDF; a small number of cell-to-column-letter alignments in rows G-K are reconstructed from context since the screenshot text was partially compressed. The mapping principle — item-identifying columns ignored, failure-mode/effects columns mapped to their corresponding MIL-STD-1629A / RPN / Detection-Method properties — is accurately preserved regardless of the exact column-letter alignment.)

This complete worked mapping table is the single most reusable artifact in this guide for anyone building a new FMEA import configuration: it shows, column-by-column, how a real-world FMECA spreadsheet's headers (item number/LCN, nomenclature, function, failure mode, local/next/end effects, detection method, compensating provisions, severity classification, failure rate, failure effect probability, operating time, failure mode/item criticality numbers) map onto MADE's internal FMEA property names.