Classifying materials

Classifying Materials by Subset Classes of Cost

Cost classification is the breakdown of costs into similar categories and sub-categories, and it can be done with various methods (for example, ABC Activity-Based costing, Marginal and Absorption costing) and for different reasons, depending upon the reason for use. The main areas in which costs can be classified are inventory planning, control, stock valuation and decisions making.

Inventory ABC Classification allows you to identify the small amount of products that usually account for most of your sales dollars (example, 80/20 rule). Here's one quick method for determining your ABC ranking based on Annual Sales Volume:

Calculate the 12 month dollar usage for all of your products.
Rank the items in descending order by the dollar usage.
The "A" items are the top 80% of the total annual usage dollars.
The "B" items make up the next 15% of total annual usage.
The "C" items are the remaining items are the remaining 5% with >0 usage in the past 12 months.
Zero-usage items can be labeled as "D" class.

I will not touch on the different methods of product costing in manufacturing (you can read more..) but to only show you the coding of materials classes such as the raw materials used in production or the spares parts support in equipments after-sale market.

Table 7.1 shows a typical corporate example of classification scheme in which all materials are assigned to a specified range of cost valuation classes. Table 7.2 shows a sub-classification by breaking down the main material classes into further smaller subsets of classes. The difference between the two is that an organization has classes in Table 7.1 loaded into computer system for the materials, whereas the sub-classes in Table 7.2 are loaded only onto your own spreadsheet or database for special planning and control purposes. How do you use such a long classification of costs? You would apply these Class Codes in areas of inventory planning and demand forecasting. Such technique will be very useful in materials planning such as managing inventory turns, customers service levels analysis, setting safety stock level and reorder point, apply these classes using Pareto analysis to identify and implement strategy to control expensive slow-moving stock items, manipulating stock replenishment strategy and so on.

You can also Download my sample worksheet which contains the VB macro for identifying the unit costs and assign the correct Class Codes as in Table 7.2, to all the part numbers in the worksheet. Here is the syntax:

You can easily combine these material codes, especially for the strategic control of the expensive A Classes material, with the materials stocking decision analysis syntax in my Excel VBA page.

Dim cls As Byte, mClass As String, remk As Byte, Remark As String
Rows("1:2").Cells.Find(What:="Class", After:=[A1]).Select
cls = ActiveCell.Column
Rows("1:2").Cells.Find(What:="*remark*", After:=[A1]).Select
remk = ActiveCell.Column
mClass = Cells(i, cls).Value
Remark = Cells(i, remk).Value

For i = 2 To lastrow
If mClass like "A*" Then
     Remark = "stocking permission require from global inventory management"
ElseIf mClass Like Not "A*" Then
     Call Opt_Plan_analysis       ' calling macro named "Opt_Plan_analysis" from this module procedure
   ' do your analysis....
End If
Next i

Class	Cost Range:	→	Class	Cost Range:
A+	>$30,000.00		A1	> $30,000.00
A	$20,000.01 to $30,000.00		A2	$25,000.01 to $30,000.00
B	$14000.01 to $20,000.00		A3	$20,000.01 to $25,000.00
C	$8,000.01 to $14,000.00		B1	$18,000.01 to $20,000.00
D	$3000.01 to $8000.00		B2	$16,000.01 to $18,000.00
E	$1500.01 to $3000.00		B3	$14,000.01 to $16,000.00
F	$750.01 to $1500.00		C1	$12,000.01 to $14,000.00
G	$100.01 to $750.00		C2	$10,000.01 to $12,000.00
H	$1.01 to $100.00		C3	$8,000.01 to $10,000.00
I	<$1.01		D1	$6,000.01 to $8,000.00
Table 7.1 An example of classification by unit costs			D2	$4,000.01 to $6,000.00
Table 7.1 An example of classification by unit costs			D3	$3,000.01 to $4,000.00
			E1	$2,000.01 to $3,000.00
			E2	$1,750.01 to $2,000.00
			E3	$1,500.01 to$1,750.00
			F1	$1,250.01 to $1,500.00
			F2	$1,000.01 to $1,250.00
			F3	$750.01 to $1,000.00
			G1	$500.01 to $750.00
			G2	$250.01 to $500.00
			G3	$100.01 to $250.00
			H1	$50.01 to $100.00
			H2	$10.01 to $50.00
			H3	$1.01 to $10.00
			I1	$0.51 to $1.00
			I2	$0.11 to $0.50
			I3	$0.01 to $0.10

			Table 7.2 A further cascaded material classes for more efficient inventory planning and control

Go To Top

Categorizing Materials Usage Rate by
Sales Orders Event-Count

Orders events in this case refers to the customers' demand or simply the number of Purchase Order Items that customers have placed over the periods which you want to measure. Although Order Events classification is often being used to measure the magnitude of orders activity at the Global Inventory and Continental DC levels, you can also use it to classify demand events happened at the Regional level and even past deliveries from your local warehouses. This method of classifying inventory by demand events is more efficient than the other methodology using MOD (Months Of Demand) - which is computing the number of months in which demand had occurred. MOD method would be more suitable for use in analyzing materials that are experiencing demand in the Introduction and Growth stages of the product's life cycle. In those cases you are more likely to observe a consumption pattern with many continuing months or even more than a year of demand inactivity.

Another drawback with the MOD method is that your analysis may show that certain category of inventory are having high MOD, say with values ranging from 8 to 10, over the past one year. In reality, those inventories that show having 10 months of historical demand may actually mean only one or two customers who had made a few purchases only. On the contrary, analyzing the historical demand of pattern of your inventories using Order Events would be able to reveal not only the frequency of months of orders activity, but would be able to tell how high the business volume within each particular months. With such level of detailed information, you are able to make a better inventory investment decision - what parts to stock, to increase or reduce by how much and by when, optimizing your replenishment strategy to buy in the right parts, at the right amount and at the right time before your safety stocks are depleted, and efficiently transfer the slow-moving inventories to the central distribution depot. For example, you can have a globally very fast-moving part but which is locally a slow-consuming stock item. You would want to be able to quickly identify what those parts are, what the holding costs are, and able to redistribute them elsewhere where market demands are higher, turnaround the cash flow, meeting financial budget, achieving high inventory turns and higher gross profit margins.

Below in Table 7.3 I tabulate out the seven classes where you can effectively categorizing your inventory by past orders events, with their specifications in descriptions. The right-side of the table demonstrate by events count how each part will meet the criteria of qualifying for the different classes. You can download the worksheet example.

		Number of Customers Orders fulfilled in last 12 months
Usage Rate	Occurrence	M_-1(last month)	M_-2	M_-3	M_-4	M_-5	M_-6	M_-7	M_-8	M_-9	M_-10	M_-11	M_-12
Very-Fast	Usage in every month in last 12 months	3	1	1	1	1	1	1	1	1	1	1	1
	Number of Purchase Orders was >12 in last 12 months	2	1	1	1	1	1	1	1	1	1	1	1
	Last usage from now is within a month
Fast	Usage within the last 3 months	2			1	1	1	1	1	1	1	1	1
	Number of Purchase Orders was between 10 to 12 in last 12 months	1			1	1	1	1	1	1	1	1	1
	Mean of time between order events was within a month
Upper-Medium	Usage within the last 3 months			2	1	1	1	1	1	1	1	1	1
	Number of Purchase Orders was between 10 to 12 in last 12 months			1	1	1	1	1	1	1	1	1	1
	Mean of time between order events was within 3 months
Medium	Usage within the last 6 months						2	1	1	1	1	1	1
	Number of Purchase Orders was between 7 to 9 in last 12 months						1	1	1	1	1	1	1
	Mean of time between order events was within 6 months
Lower-Medium	Usage within the last 6 months							2	1	1		1	1
	Number of Purchase Orders was between 5 to 6 in last 12 months							1	1	1		1	1
	Mean of time between order events was within 6 months
Slow	Usage within the last 9 months									2	1	1	1
	Number of Purchase Orders was between 3 to 4 in last 12 months									1		1	1
	Mean of time between order events was within 9 months
Very-Slow	The remaining parts										2	1	1

Table 7.3 categorizing inventory by past orders events and criteria qualification

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O
1	Part Number	Material Class	M_-1(last month)	M_-2	M_-3	M_-4	M_-5	M_-6	M_-7	M_-8	M_-9	M_-10	M_-11	M_-12	<<Formulas>>:
2	Part A1	G3	2	6	4	4	6	2	3	2	3	2	2	1	Very-Fast
3	Part B1	D3	1	4	3	4	2		1	2	1	4	2	2	Fast
4	Part C1	D3			6		4	2	2	4		1	7	2	Upper-Medium
5	Part A2	C3	2	1		1				1		1			Lower-Medium
6	Part A12	A2	1	1	1								1		Slow
7	Part A13	F3	2	1	2	4	4	1	4		2	2	4		Fast
8	Part A33	C2			1		3		1	2				1	Medium

Table 7.4 Using Excel formulas to determine material orders-event classes

In cell O2 of the above sample spreadsheet, you can type in the following formula, and then copy it down column O.
You can also download here the worksheet Example.

=IF(AND(COUNTIF(T8:AE8,">0")=12,SUM(T8:AE8)>12,T8>0),"Very-Fast",IF(AND(SUM(T8:V8)>0,SUM(T8:AE8)>9,T8>0),"Fast",
IF(AND(SUM(T8:V8)>0,SUM(T8:AE8)>9,SUM(T8:V8)>0),"Upper-Medium",IF(AND(SUM(T8:Y8)>0,SUM(T8:AE8)>6),"Medium",
IF(AND(SUM(T8:Y8)>0,SUM(T8:AE8)>4),"Lower-Medium",IF(AND(SUM(T8:AB8)>0,SUM(T8:AE8)>2),"Slow","Very-Slow"))))))

Go To Top

Classifying Materials by Strategic Attributes (SA)

You can also categorize your inventory according to the various characteristics and conditions that are specific to the equipments they are built in as shown in Table 7.5. I have included many conditions for the inventory planning that are seen as common to the many industries. I also developed a VB Program based on the specific conditions that the materials are confined to, and it automatically assigns the Strategic Attributes which recommend to you the strategically-planned inventory stocking decisions. If you have more factors to be considered and you want to reconfigure your strategic criteria, you can easily amend my code to suit your requirement. Here is the syntax. and and worksheet example.

Below are the explanation to the different strategic attributes for stocking decisions as shown in table 7.5

Lead Time Order (LTO)
● Parts with expected usage so low, frequently fail and unpredictable, that we don’t want to carry inventory.
● These parts are not critical to a tool’s function.
● Safety Stock level should be Zero. Product Divisions may override.

Strategic Stock (SS1, SS2, etc)
● Minimum of 1 (SS1) or 2 (SS2) stocked globally.
● Stocking at the CDC is usually recommended.
● Low failure type spare parts, but is critical to function of equipment.

Vital Part (VITAL)
● Allow to stock closer to the customer when customer had experienced machines down due to parts stockout.
● Contractual equipments down waiting or part - threshold from 4 to 24 hours.
● Minimum of 1 stocked in Central Distribution Center.
● Can be high failure type spare parts, critical to function of equipment.

PLAN
● "Use local planning strategy and analysis tool to set safety stock levels based on demand, install base, agreement contract, etc."

Stock In Multiples (SIM)
● Multiple in which parts should be stocked. Example, part is used in a change-out qty of 4 each time. (SIM4)

Conditions name:	Description:
LLT	long lead time stock item (> 30days)
MLT	medium lead time stock item (8 to 30 days)
SLT	short lead time stock item (within 7days)
ITO	in transition to become obsolete material within 6 months from current time of checking
ITI	in transition to become inactive material within 6 months from current time of checking
SL6	part that has a limited shelf life with expiry date within 6 months from now
FAIL	part that experiences high failure rate.
DAMAGE	part when failed will cause damage to other components of the tool.
CRITICAL	part that seldom fail but is critical to the functionality of equipment.

Part Number	LLT	MLT	SLT	ITO	ITI	SL6	SIM	FAIL	DAMAGE	CRITICAL	Assigning Strategic Attributes:
	Y			Y			4				PLAN-SIM4
	Y				Y						PLAN
	Y					Y	8				LTO-SIM8
	Y							Y			LTO
	Y								Y		LTO
	Y									Y	VITAL
	Y								Y	Y	SS1
	Y							Y	Y		PLAN
	Y					Y	4	Y			LTO-SIM4
	Y				Y	Y					LTO
	Y			Y		Y					LTO
	Y			Y		Y		Y			LTO
	Y			Y		Y		Y	Y		LTO
	Y			Y		Y	8	Y	Y	Y	SS1-SIM8
	Y			Y				Y			PLAN
	Y			Y			2	Y	Y		PLAN-SIM2
	Y			Y				Y	Y	Y	SS1
	Y			Y					Y		PLAN
	Y			Y					Y	Y	SS1
	Y			Y						Y	SS1
	Y			Y		Y		Y		Y	SS1
	Y			Y				Y		Y	SS1
	Y			Y		Y				Y	VITAL
	Y			Y		Y			Y	Y	VITAL
	Y						2	Y	Y	Y	SS2-SIM2
	Y					Y		Y	Y	Y	SS1
	Y					Y				Y	SS1
	Y					Y		Y		Y	SS1
	Y					Y		Y	Y		LTO
	Y					Y	10	Y	Y	Y	SS1-SIM10
	Y					Y			Y		LTO
	Y					Y	8		Y	Y	SS1-SIM8
	Y							Y		Y	VITAL
		Y		Y			4				PLAN-SIM4
		Y			Y						PLAN
		Y				Y	8				PLAN-SIM8
		Y						Y			LTO
		Y							Y		PLAN
		Y								Y	VITAL
		Y							Y	Y	SS1
		Y						Y	Y		LTO
		Y				Y	4	Y			LTO-SIM4
		Y			Y	Y					LTO
		Y		Y		Y					LTO
		Y		Y		Y		Y			LTO
		Y		Y		Y		Y	Y		LTO
		Y		Y		Y	8	Y	Y	Y	SS1-SIM8
		Y		Y				Y			LTO
		Y		Y			2	Y	Y		LTO-SIM2
		Y		Y				Y	Y	Y	SS1
		Y		Y					Y		PLAN
		Y		Y					Y	Y	SS1
		Y		Y						Y	SS1
		Y		Y		Y		Y		Y	LTO
		Y		Y				Y		Y	LTO
		Y		Y		Y				Y	VITAL
		Y		Y		Y			Y	Y	VITAL
		Y					2	Y	Y	Y	SS1-SIM2
		Y				Y		Y	Y	Y	SS1
		Y				Y		Y			LTO
		Y				Y		Y		Y	SS1
		Y				Y		Y	Y		LTO
		Y				Y	10	Y	Y	Y	SS1-SIM10
		Y				Y			Y		LTO
		Y				Y	8		Y	Y	VITAL-SIM8
		Y				Y				Y	VITAL
		Y						Y		Y	VITAL
			Y	Y			4				PLAN-SIM4
			Y		Y						PLAN
			Y			Y	8				PLAN-SIM8
			Y					Y			LTO
			Y						Y		PLAN
			Y							Y	PLAN
			Y						Y	Y	PLAN
			Y					Y	Y		LTO
			Y			Y	4	Y			LTO-SIM4
			Y		Y	Y					PLAN
			Y	Y		Y					LTO
			Y	Y		Y		Y			LTO
			Y	Y		Y		Y	Y		LTO
			Y	Y		Y	8	Y	Y	Y	LTO-SIM8
			Y	Y				Y			LTO
			Y	Y			2	Y	Y		LTO-SIM2
			Y	Y				Y	Y	Y	LTO
			Y	Y					Y		PLAN
			Y	Y					Y	Y	PLAN
			Y	Y						Y	PLAN
			Y	Y		Y		Y		Y	LTO
			Y	Y				Y		Y	LTO
			Y	Y		Y				Y	PLAN
			Y	Y		Y			Y	Y	PLAN
			Y				2	Y	Y	Y	LTO-SIM2
			Y			Y		Y	Y	Y	LTO
			Y			Y		Y			LTO
			Y			Y		Y		Y	LTO
			Y			Y		Y	Y		LTO
			Y			Y	10	Y	Y	Y	LTO-SIM10
			Y			Y			Y		PLAN
			Y			Y	8		Y	Y	PLAN-SIM8
			Y			Y				Y	PLAN
			Y					Y		Y	LTO

Table 7.5. Assigning strategic attributes for recommending stocking decisions

Go To Top

Next challenge for you

Next table example below show you a more realistic scenario where you would have to consider the various historical usage pattern and current conditions, Cost Classes, strategic stocking attributes, exception rule for the materials in the different warehouses, or even many other important factors you may have. With all these useful information, you would eventually want to devise a purchasing and inventory stocking strategy where you can determine the optimal and cost-effective levels in Minimum Order Quantity, opting for Lot-For-Lot method, utilizing Reorder Point stock replenishment and what your target safety stock levels should be while commit to meeting customers' Service Level at any time. Minimum Order Quantities method would be suitable for cheap cost materials where you want to save on administrative and logistic costs by ordering less frequently, achieving purchasing economies of scale. Lot-For-Lot method is usually used for final product, top-level assemblies or sub-assemblies. Reorder Point is preferred for the high volume transaction materials to prevent the safety stock being dipped into or preventing stockout situation.

You can use what I have already shown you in visual basic programming to automate your inventory management decisions base upon the various criteria, however complex they may be - I want to tell you there is no problem to achieve this. If you are interested to apply this inventory management Model to your business, you will certainly have some challenge ahead because you definitely don't want the analysis to be a very manual process for your planners. You should make it productive, fast, efficient, fool-proof and error-free business process by automating all the analysis tasks - avoid the repeated filtering, find, match, vlookup, long formulas, etc. Here is one example of a relevant analysis that I previously did. You can study it but again, if you need my assistance, you are welcome to write to me.

				Past 12 months historical demand
Ware house	Part Number	Material Class	Movers	M-1 (last Mth)	M-2	M-3	M-4	M-5	M-6	M-7	M-8	M-9	M-10	M-11	M-12	Strategic Stocking Attributes	Min. Order Qty	Lot- For- Lot	Re- Order Level	Safety Stock Level	Exception Conditions
C	010-01152173	G3	Very-Fast	2	6	4	4	6	2	3	2	3	2	2	1	PLAN-SIM4
A	010-02372356	D3	Fast	1	4	3	4	2		1	2	1	4	2	2	PLAN
D	010-02977446	D3	Upper-Medium			6		4	2	2	4		1	7	2	LTO-SIM8
B	010-03244486	C3	Lower-Medium	2	1		1				1		1			LTO
D	010-03254488	A2	Slow	1	1	1								1		LTO
A	010-03291494	F3	Fast	2	1	2	4	4	1	4		2	2	4		VITAL
A	010-322M498	C2	Fast	1	3		7	2	1	1			1	1		SS1					machine down x2
B	010-04138620	E1	Slow			2	1									PLAN
D	010-449M666	C3	Upper-Medium		1	2	2	1	1			1	2		1	LTO-SIM4
C	010-08151227	G1	Very-Slow								1					LTO
C	010-1020430	E3	Very-Slow		1							1				LTO
A	010-11490224	C2	Very-Slow											1		LTO
D	010-11491224	C3	Very-Slow							1				1		LTO
D	010-11747261	G1	Very-Slow		1	1										SS1-SIM8					machine down x2
B	010-11997299	D1	Slow			1	1	1								PLAN
A	010-13149471	G3	Lower-Medium		1		1						1	3		SS2

Go To Top

' VB code for cascading down main material classes into subsets of each class. Edit to suit your need.
Sub classify_costs()
Dim c As Integer, r As Integer, i As Long, lastrow As Long
lastrow = Cells(65536, 1).End(xlUp).Row
Rows("1:4").Cells.Find(What:="Standard*", After:=[A1]).Select
ActiveCell.Select
c = ActiveCell.Column
r = ActiveCell.Offset(1, 0).Row
ActiveCell.Offset(0, 1).EntireColumn.Insert
ActiveCell.Offset(, 1).Value = "Material Class"
For i = r To lastrow
    Select Case Cells(i, c).Value
    Case Is <= 0.1
         Cells(i, c + 1).Value = "I3"
    Case Is <= 0.5
         Cells(i, c + 1).Value = "I2"
    Case Is <= 1
         Cells(i, c + 1).Value = "I1"
    Case Is <= 10
         Cells(i, c + 1).Value = "H3"
    Case Is <= 50
         Cells(i, c + 1).Value = "H2"
    Case Is < 100
         Cells(i, c + 1).Value = "H1"
    Case Is <= 250
         Cells(i, c + 1).Value = "G3"
    Case Is <= 500
         Cells(i, c + 1).Value = "G2"
    Case Is < 750
         Cells(i, c + 1).Value = "G1"
    Case Is <= 1000
         Cells(i, c + 1).Value = "F3"
    Case Is <= 1250
         Cells(i, c + 1).Value = "F2"
    Case Is < 1500
         Cells(i, c + 1).Value = "F1"
    Case Is <= 1750
         Cells(i, c + 1).Value = "E3"
    Case Is <= 2000
         Cells(i, c + 1).Value = "E2"
    Case Is < 3000
         Cells(i, c + 1).Value = "E1"
    Case Is <= 4000
         Cells(i, c + 1).Value = "D3"
    Case Is <= 6000
         Cells(i, c + 1).Value = "D2"
    Case Is < 8000
         Cells(i, c + 1).Value = "D1"
    Case Is <= 10000
         Cells(i, c + 1).Value = "C3"
    Case Is <= 12000
         Cells(i, c + 1).Value = "C2"
    Case Is <= 14000
         Cells(i, c + 1).Value = "C1"
    Case Is <= 16000
         Cells(i, c + 1).Value = "B3"
    Case Is <= 18000
         Cells(i, c + 1).Value = "B2"
    Case Is <= 20000
         Cells(i, c + 1).Value = "B1"
    Case Is <= 25000
         Cells(i, c + 1).Value = "A3"
    Case Is <= 30000
         Cells(i, c + 1).Value = "A2"
    Case Is > 30000
         Cells(i, c + 1).Value = "A1"
    Case Else
         Cells(i, c + 1).Value = ""
    End Select
Next
End Sub

Go To Top

' categorize your inventory according to the various characteristics and conditions that are specific to the equipments they are built in
Sub strategic_attributes()

Dim LLT As String, MLT As String, SLT As String, ITO As String, ITI As String, SL6 As String, SIM As Integer, FAIL As String, _
DMG As String, CRT As String, SSA As String

Dim i As Long, lastrow As Long, lltm As Byte, mltm As Byte, sltm As Byte, itobs As Byte, itina As Byte, sl As Byte, simult As Byte, _
hfail As Byte, dam As Byte, crit As Byte, ssatt As Byte

    If Rows("1:1").Cells.Find(What:="SSA", After:=[A1]) Is Nothing Then
        Range("IV1").End(xlToLeft).Offset(, 1).Select
        Selection.Value = "SSA:"
    End If
With Application
lastrow = Application.Range("A" & .Rows.Count).End(xlUp).Row
End With
Rows("1:1").Cells.Find(What:="LLT", After:=[A1]).Select
lltm = ActiveCell.Column
Rows("1:1").Cells.Find(What:="MLT", After:=[A1]).Select
mltm = ActiveCell.Column
Rows("1:1").Cells.Find(What:="SLT", After:=[A1]).Select
sltm = ActiveCell.Column
Rows("1:1").Cells.Find(What:="ITO", After:=[A1]).Select
itobs = ActiveCell.Column
Rows("1:1").Cells.Find(What:="ITI", After:=[A1]).Select
itina = ActiveCell.Column
Rows("1:1").Cells.Find(What:="SL6", After:=[A1]).Select
sl = ActiveCell.Column
Rows("1:1").Cells.Find(What:="SIM", After:=[A1]).Select
simult = ActiveCell.Column
Rows("1:1").Cells.Find(What:="FAIL", After:=[A1]).Select
hfail = ActiveCell.Column
Rows("1:1").Cells.Find(What:="DAMAGE", After:=[A1]).Select
dam = ActiveCell.Column
Rows("1:1").Cells.Find(What:="CRITICAL", After:=[A1]).Select
crit = ActiveCell.Column
Rows("1:1").Cells.Find(What:="SSA", After:=[A1]).Select
ssatt = ActiveCell.Column

For i = 2 To lastrow
LLT = Cells(i, lltm).Value
MLT = Cells(i, mltm).Value
SLT = Cells(i, sltm).Value
ITO = Cells(i, itobs).Value
ITI = Cells(i, itina).Value
SL6 = Cells(i, sl).Value
SIM = Cells(i, simult).Value
FAIL = Cells(i, hfail).Value
DMG = Cells(i, dam).Value
'CRT = Application.WorksheetFunction.Range(Cells(i, dam).Offset(, 1)).Value
CRT = Cells(i, crit).Value
SSA = Cells(i, ssatt).Value

On Error Resume Next
If SIM > 0 Then
If LLT = "Y" Then ' measuring LLT
    If MLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "" And DMG = "" And CRT = "" Then
        SSA = "PLAN" & "-SIM" & SIM
    ElseIf MLT = "" And SLT = "" And ITO = "" And ITI = "Y" And SL6 = "" And FAIL = "" And DMG = "" And CRT = "" Then
        SSA = "PLAN" & "-SIM" & SIM
    ElseIf MLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "" And DMG = "" And CRT = "" Then
        SSA = "LTO" & "-SIM" & SIM
    ElseIf MLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "" And CRT = "" Then
        SSA = "LTO" & "-SIM" & SIM
    ElseIf MLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "" And FAIL = "" And DMG = "Y" And CRT = "" Then
        SSA = "LTO" & "-SIM" & SIM
    ElseIf MLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "" And FAIL = "" And DMG = "" And CRT = "Y" Then
        SSA = "VITAL" & "-SIM" & SIM
    ElseIf MLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "" And FAIL = "" And DMG = "Y" And CRT = "Y" Then
        SSA = "SS1" & "-SIM" & SIM
    ElseIf MLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "Y" And CRT = "" Then
        SSA = "PLAN" & "-SIM" & SIM
    ElseIf MLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "" And CRT = "" Then
        SSA = "LTO" & "-SIM" & SIM
    ElseIf MLT = "" And SLT = "" And ITO = "" And ITI = "Y" And SL6 = "Y" And FAIL = "" And DMG = "" And CRT = "" Then
        SSA = "LTO" & "-SIM" & SIM
    ElseIf MLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "Y" And FAIL = "" And DMG = "" And CRT = "" Then
        SSA = "LTO" & "-SIM" & SIM
    ElseIf MLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "" And CRT = "" Then
        SSA = "LTO" & "-SIM" & SIM
    ElseIf MLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "Y" And CRT = "" Then
        SSA = "LTO" & "-SIM" & SIM
    ElseIf MLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "Y" And CRT = "Y" Then
        SSA = "SS1" & "-SIM" & SIM
    ElseIf MLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "" And CRT = "" Then
        SSA = "PLAN" & "-SIM" & SIM
    ElseIf MLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "Y" And CRT = "" Then
        SSA = "PLAN" & "-SIM" & SIM
    ElseIf MLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "Y" And CRT = "Y" Then
        SSA = "SS1" & "-SIM" & SIM
    ElseIf MLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "" And DMG = "Y" And CRT = "" Then
        SSA = "PLAN" & "-SIM" & SIM
    ElseIf MLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "" And DMG = "Y" And CRT = "Y" Then
        SSA = "SS1" & "-SIM" & SIM
    ElseIf MLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "" And DMG = "" And CRT = "Y" Then
        SSA = "SS1" & "-SIM" & SIM
    ElseIf MLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "" And CRT = "Y" Then
        SSA = "SS1" & "-SIM" & SIM
    ElseIf MLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "" And CRT = "Y" Then
        SSA = "SS1" & "-SIM" & SIM
    ElseIf MLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "Y" And FAIL = "" And DMG = "" And CRT = "Y" Then
        SSA = "VITAL" & "-SIM" & SIM
    ElseIf MLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "Y" And FAIL = "" And DMG = "Y" And CRT = "Y" Then
        SSA = "VITAL" & "-SIM" & SIM
    ElseIf MLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "Y" And CRT = "Y" Then
        SSA = "SS2" & "-SIM" & SIM
    ElseIf MLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "Y" And CRT = "Y" Then
        SSA = "SS1" & "-SIM" & SIM
    ElseIf MLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "" And DMG = "" And CRT = "Y" Then
        SSA = "SS1" & "-SIM" & SIM
    ElseIf MLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "" And CRT = "Y" Then
        SSA = "SS1" & "-SIM" & SIM
    ElseIf MLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "Y" And CRT = "" Then
        SSA = "LTO" & "-SIM" & SIM
    ElseIf MLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "Y" And CRT = "Y" Then
        SSA = "SS1" & "-SIM" & SIM
    ElseIf MLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "" And DMG = "Y" And CRT = "" Then
        SSA = "LTO" & "-SIM" & SIM
    ElseIf MLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "" And DMG = "Y" And CRT = "Y" Then
        SSA = "SS1" & "-SIM" & SIM
    ElseIf MLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "" And CRT = "Y" Then
        SSA = "VITAL" & "-SIM" & SIM
    End If

ElseIf MLT = "Y" Then ' measuring MLT
    If LLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "" And DMG = "" And CRT = "" Then
        SSA = "PLAN" & "-SIM" & SIM
    ElseIf LLT = "" And SLT = "" And ITO = "" And ITI = "Y" And SL6 = "" And FAIL = "" And DMG = "" And CRT = "" Then
        SSA = "PLAN" & "-SIM" & SIM
    ElseIf LLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "" And DMG = "" And CRT = "" Then
        SSA = "PLAN" & "-SIM" & SIM
    ElseIf LLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "" And CRT = "" Then
        SSA = "LTO" & "-SIM" & SIM
    ElseIf LLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "" And FAIL = "" And DMG = "Y" And CRT = "" Then
        SSA = "PLAN" & "-SIM" & SIM
    ElseIf LLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "" And FAIL = "" And DMG = "" And CRT = "Y" Then
        SSA = "VITAL" & "-SIM" & SIM
    ElseIf LLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "" And FAIL = "" And DMG = "Y" And CRT = "Y" Then
        SSA = "SS1" & "-SIM" & SIM
    ElseIf LLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "Y" And CRT = "" Then
        SSA = "LTO" & "-SIM" & SIM
    ElseIf LLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "" And CRT = "" Then
        SSA = "LTO" & "-SIM" & SIM
    ElseIf LLT = "" And SLT = "" And ITO = "" And ITI = "Y" And SL6 = "Y" And FAIL = "" And DMG = "" And CRT = "" Then
        SSA = "LTO" & "-SIM" & SIM
    ElseIf LLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "Y" And FAIL = "" And DMG = "" And CRT = "" Then
        SSA = "LTO" & "-SIM" & SIM
    ElseIf LLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "" And CRT = "" Then
        SSA = "LTO" & "-SIM" & SIM
    ElseIf LLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "Y" And CRT = "" Then
        SSA = "LTO" & "-SIM" & SIM
    ElseIf LLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "Y" And CRT = "Y" Then
        SSA = "SS1" & "-SIM" & SIM
    ElseIf LLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "" And CRT = "" Then
        SSA = "LTO" & "-SIM" & SIM
    ElseIf LLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "Y" And CRT = "" Then
        SSA = "LTO" & "-SIM" & SIM
    ElseIf LLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "Y" And CRT = "Y" Then
        SSA = "SS1" & "-SIM" & SIM
    ElseIf LLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "" And DMG = "Y" And CRT = "" Then
        SSA = "PLAN" & "-SIM" & SIM
    ElseIf LLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "" And DMG = "Y" And CRT = "Y" Then
        SSA = "SS1" & "-SIM" & SIM
    ElseIf LLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "" And DMG = "" And CRT = "Y" Then
        SSA = "SS1" & "-SIM" & SIM
    ElseIf LLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "" And CRT = "Y" Then
        SSA = "LTO" & "-SIM" & SIM
    ElseIf LLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "" And CRT = "Y" Then
        SSA = "LTO" & "-SIM" & SIM
    ElseIf LLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "Y" And FAIL = "" And DMG = "" And CRT = "Y" Then
        SSA = "VITAL" & "-SIM" & SIM
    ElseIf LLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "Y" And FAIL = "" And DMG = "Y" And CRT = "Y" Then
        SSA = "VITAL" & "-SIM" & SIM
    ElseIf LLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "Y" And CRT = "Y" Then
        SSA = "SS1" & "-SIM" & SIM
    ElseIf LLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "Y" And CRT = "Y" Then
        SSA = "SS1" & "-SIM" & SIM
    ElseIf LLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "F" And DMG = "" And CRT = "" Then
        SSA = "LTO" & "-SIM" & SIM
    ElseIf LLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "" And CRT = "Y" Then
        SSA = "SS1" & "-SIM" & SIM
    ElseIf LLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "Y" And CRT = "" Then
        SSA = "LTO" & "-SIM" & SIM
    ElseIf LLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "Y" And CRT = "Y" Then
        SSA = "VITAL" & "-SIM" & SIM
    ElseIf LLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "" And DMG = "Y" And CRT = "" Then
        SSA = "LTO" & "-SIM" & SIM
    ElseIf LLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "" And DMG = "Y" And CRT = "Y" Then
        SSA = "VITAL" & "-SIM" & SIM
    ElseIf LLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "" And DMG = "" And CRT = "Y" Then
        SSA = "VITAL" & "-SIM" & SIM
    ElseIf LLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "" And CRT = "Y" Then
        SSA = "VITAL" & "-SIM" & SIM
    End If

ElseIf SLT = "Y" Then ' measuring SLT
    If LLT = "" And MLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "" And DMG = "" And CRT = "" Then
        SSA = "PLAN" & "-SIM" & SIM
    ElseIf LLT = "" And MLT = "" And ITO = "" And ITI = "Y" And SL6 = "" And FAIL = "" And DMG = "" And CRT = "" Then
        SSA = "PLAN" & "-SIM" & SIM
    ElseIf LLT = "" And MLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "" And DMG = "" And CRT = "" Then
        SSA = "PLAN" & "-SIM" & SIM
    ElseIf LLT = "" And MLT = "" And ITO = "" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "" And CRT = "" Then
        SSA = "LTO" & "-SIM" & SIM
    ElseIf LLT = "" And MLT = "" And ITO = "" And ITI = "" And SL6 = "" And FAIL = "" And DMG = "Y" And CRT = "" Then
        SSA = "PLAN" & "-SIM" & SIM
    ElseIf LLT = "" And MLT = "" And ITO = "" And ITI = "" And SL6 = "" And FAIL = "" And DMG = "" And CRT = "Y" Then
        SSA = "PLAN" & "-SIM" & SIM
    ElseIf LLT = "" And MLT = "" And ITO = "" And ITI = "" And SL6 = "" And FAIL = "" And DMG = "Y" And CRT = "Y" Then
        SSA = "PLAN" & "-SIM" & SIM
    ElseIf LLT = "" And MLT = "" And ITO = "" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "Y" And CRT = "" Then
        SSA = "LTO" & "-SIM" & SIM
    ElseIf LLT = "" And MLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "" And CRT = "" Then
        SSA = "LTO" & "-SIM" & SIM
    ElseIf LLT = "" And MLT = "" And ITO = "" And ITI = "Y" And SL6 = "Y" And FAIL = "" And DMG = "" And CRT = "" Then
        SSA = "PLAN" & "-SIM" & SIM
    ElseIf LLT = "" And MLT = "" And ITO = "Y" And ITI = "" And SL6 = "Y" And FAIL = "" And DMG = "" And CRT = "" Then
        SSA = "LTO" & "-SIM" & SIM
    ElseIf LLT = "" And MLT = "" And ITO = "Y" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "" And CRT = "" Then
        SSA = "LTO" & "-SIM" & SIM
    ElseIf LLT = "" And MLT = "" And ITO = "Y" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "Y" And CRT = "" Then
        SSA = "LTO" & "-SIM" & SIM
    ElseIf LLT = "" And MLT = "" And ITO = "Y" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "Y" And CRT = "Y" Then
        SSA = "LTO" & "-SIM" & SIM
    ElseIf LLT = "" And MLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "" And CRT = "" Then
        SSA = "LTO" & "-SIM" & SIM
    ElseIf LLT = "" And MLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "Y" And CRT = "" Then
        SSA = "LTO" & "-SIM" & SIM
    ElseIf LLT = "" And MLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "Y" And CRT = "Y" Then
        SSA = "LTO" & "-SIM" & SIM
    ElseIf LLT = "" And MLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "" And DMG = "Y" And CRT = "" Then
        SSA = "PLAN" & "-SIM" & SIM
    ElseIf LLT = "" And MLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "" And DMG = "Y" And CRT = "Y" Then
        SSA = "PLAN" & "-SIM" & SIM
    ElseIf LLT = "" And MLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "" And DMG = "" And CRT = "Y" Then
        SSA = "PLAN" & "-SIM" & SIM
    ElseIf LLT = "" And MLT = "" And ITO = "Y" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "" And CRT = "Y" Then
        SSA = "LTO" & "-SIM" & SIM
    ElseIf LLT = "" And MLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "" And CRT = "Y" Then
        SSA = "LTO" & "-SIM" & SIM
    ElseIf LLT = "" And MLT = "" And ITO = "Y" And ITI = "" And SL6 = "Y" And FAIL = "" And DMG = "" And CRT = "Y" Then
        SSA = "PLAN" & "-SIM" & SIM
    ElseIf LLT = "" And MLT = "" And ITO = "Y" And ITI = "" And SL6 = "Y" And FAIL = "" And DMG = "Y" And CRT = "Y" Then
        SSA = "PLAN" & "-SIM" & SIM
    ElseIf LLT = "" And MLT = "" And ITO = "" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "Y" And CRT = "Y" Then
        SSA = "LTO" & "-SIM" & SIM
    ElseIf LLT = "" And MLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "Y" And CRT = "Y" Then
        SSA = "LTO" & "-SIM" & SIM
    ElseIf LLT = "" And MLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "F" And DMG = "" And CRT = "" Then
        SSA = "LTO" & "-SIM" & SIM
    ElseIf LLT = "" And MLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "" And CRT = "Y" Then
        SSA = "LTO" & "-SIM" & SIM
    ElseIf LLT = "" And MLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "Y" And CRT = "" Then
        SSA = "LTO" & "-SIM" & SIM
    ElseIf LLT = "" And MLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "Y" And CRT = "Y" Then
        SSA = "LTO" & "-SIM" & SIM
    ElseIf LLT = "" And MLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "" And DMG = "Y" And CRT = "" Then
        SSA = "PLAN" & "-SIM" & SIM
    ElseIf LLT = "" And MLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "" And DMG = "Y" And CRT = "Y" Then
        SSA = "PLAN" & "-SIM" & SIM
    ElseIf LLT = "" And MLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "" And DMG = "" And CRT = "Y" Then
        SSA = "PLAN" & "-SIM" & SIM
    ElseIf LLT = "" And MLT = "" And ITO = "" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "" And CRT = "Y" Then
        SSA = "LTO" & "-SIM" & SIM
    End If
End If

''''''''''''''''' if SIM is blank
ElseIf SIM = 0 Or SIM = vbNullString Then
If LLT = "Y" Then ' measuring LLT
    If MLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "" And DMG = "" And CRT = "" Then
        SSA = "PLAN"
    ElseIf MLT = "" And SLT = "" And ITO = "" And ITI = "Y" And SL6 = "" And FAIL = "" And DMG = "" And CRT = "" Then
        SSA = "PLAN"
    ElseIf MLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "" And DMG = "" And CRT = "" Then
        SSA = "LTO"
    ElseIf MLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "" And CRT = "" Then
        SSA = "LTO"
    ElseIf MLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "" And FAIL = "" And DMG = "Y" And CRT = "" Then
        SSA = "LTO"
    ElseIf MLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "" And FAIL = "" And DMG = "" And CRT = "Y" Then
        SSA = "VITAL"
    ElseIf MLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "" And FAIL = "" And DMG = "Y" And CRT = "Y" Then
        SSA = "SS1"
    ElseIf MLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "Y" And CRT = "" Then
        SSA = "PLAN"
    ElseIf MLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "" And CRT = "" Then
        SSA = "LTO"
    ElseIf MLT = "" And SLT = "" And ITO = "" And ITI = "Y" And SL6 = "Y" And FAIL = "" And DMG = "" And CRT = "" Then
        SSA = "LTO"
    ElseIf MLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "Y" And FAIL = "" And DMG = "" And CRT = "" Then
        SSA = "LTO"
    ElseIf MLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "" And CRT = "" Then
        SSA = "LTO"
    ElseIf MLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "Y" And CRT = "" Then
        SSA = "LTO"
    ElseIf MLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "Y" And CRT = "Y" Then
        SSA = "SS1"
    ElseIf MLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "" And CRT = "" Then
        SSA = "PLAN"
    ElseIf MLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "Y" And CRT = "" Then
        SSA = "PLAN"
    ElseIf MLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "Y" And CRT = "Y" Then
        SSA = "SS1"
    ElseIf MLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "" And DMG = "Y" And CRT = "" Then
        SSA = "PLAN"
    ElseIf MLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "" And DMG = "Y" And CRT = "Y" Then
        SSA = "SS1"
    ElseIf MLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "" And DMG = "" And CRT = "Y" Then
        SSA = "SS1"
    ElseIf MLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "" And CRT = "Y" Then
        SSA = "SS1"
    ElseIf MLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "" And CRT = "Y" Then
        SSA = "SS1"
    ElseIf MLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "Y" And FAIL = "" And DMG = "" And CRT = "Y" Then
        SSA = "VITAL"
    ElseIf MLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "Y" And FAIL = "" And DMG = "Y" And CRT = "Y" Then
        SSA = "VITAL"
    ElseIf MLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "Y" And CRT = "Y" Then
        SSA = "SS2"
    ElseIf MLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "Y" And CRT = "Y" Then
        SSA = "SS1"
    ElseIf MLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "" And DMG = "" And CRT = "Y" Then
        SSA = "SS1"
    ElseIf MLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "" And CRT = "Y" Then
        SSA = "SS1"
    ElseIf MLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "Y" And CRT = "" Then
        SSA = "LTO"
    ElseIf MLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "Y" And CRT = "Y" Then
        SSA = "SS1"
    ElseIf MLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "" And DMG = "Y" And CRT = "" Then
        SSA = "LTO"
    ElseIf MLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "" And DMG = "Y" And CRT = "Y" Then
        SSA = "SS1"
    ElseIf MLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "" And CRT = "Y" Then
        SSA = "VITAL"
    End If

ElseIf MLT = "Y" Then ' measuring MLT
    If LLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "" And DMG = "" And CRT = "" Then
        SSA = "PLAN"
    ElseIf LLT = "" And SLT = "" And ITO = "" And ITI = "Y" And SL6 = "" And FAIL = "" And DMG = "" And CRT = "" Then
        SSA = "PLAN"
    ElseIf LLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "" And DMG = "" And CRT = "" Then
        SSA = "PLAN"
    ElseIf LLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "" And CRT = "" Then
        SSA = "LTO"
    ElseIf LLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "" And FAIL = "" And DMG = "Y" And CRT = "" Then
        SSA = "PLAN"
    ElseIf LLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "" And FAIL = "" And DMG = "" And CRT = "Y" Then
        SSA = "VITAL"
    ElseIf LLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "" And FAIL = "" And DMG = "Y" And CRT = "Y" Then
        SSA = "SS1"
    ElseIf LLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "Y" And CRT = "" Then
        SSA = "LTO"
    ElseIf LLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "" And CRT = "" Then
        SSA = "LTO"
    ElseIf LLT = "" And SLT = "" And ITO = "" And ITI = "Y" And SL6 = "Y" And FAIL = "" And DMG = "" And CRT = "" Then
        SSA = "LTO"
    ElseIf LLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "Y" And FAIL = "" And DMG = "" And CRT = "" Then
        SSA = "LTO"
    ElseIf LLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "" And CRT = "" Then
        SSA = "LTO"
    ElseIf LLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "Y" And CRT = "" Then
        SSA = "LTO"
    ElseIf LLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "Y" And CRT = "Y" Then
        SSA = "SS1"
    ElseIf LLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "" And CRT = "" Then
        SSA = "LTO"
    ElseIf LLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "Y" And CRT = "" Then
        SSA = "LTO"
    ElseIf LLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "Y" And CRT = "Y" Then
        SSA = "SS1"
    ElseIf LLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "" And DMG = "Y" And CRT = "" Then
        SSA = "PLAN"
    ElseIf LLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "" And DMG = "Y" And CRT = "Y" Then
        SSA = "SS1"
    ElseIf LLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "" And DMG = "" And CRT = "Y" Then
        SSA = "SS1"
    ElseIf LLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "" And CRT = "Y" Then
        SSA = "LTO"
    ElseIf LLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "" And CRT = "Y" Then
        SSA = "LTO"
    ElseIf LLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "Y" And FAIL = "" And DMG = "" And CRT = "Y" Then
        SSA = "VITAL"
    ElseIf LLT = "" And SLT = "" And ITO = "Y" And ITI = "" And SL6 = "Y" And FAIL = "" And DMG = "Y" And CRT = "Y" Then
        SSA = "VITAL"
    ElseIf LLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "Y" And CRT = "Y" Then
        SSA = "SS1"
    ElseIf LLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "Y" And CRT = "Y" Then
        SSA = "SS1"
    ElseIf LLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "F" And DMG = "" And CRT = "" Then
        SSA = "LTO"
    ElseIf LLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "" And CRT = "Y" Then
        SSA = "SS1"
    ElseIf LLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "Y" And CRT = "" Then
        SSA = "LTO"
    ElseIf LLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "Y" And CRT = "Y" Then
        SSA = "VITAL"
    ElseIf LLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "" And DMG = "Y" And CRT = "" Then
        SSA = "LTO"
    ElseIf LLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "" And DMG = "Y" And CRT = "Y" Then
        SSA = "VITAL"
    ElseIf LLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "" And DMG = "" And CRT = "Y" Then
        SSA = "VITAL"
    ElseIf LLT = "" And SLT = "" And ITO = "" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "" And CRT = "Y" Then
        SSA = "VITAL"
    End If

ElseIf SLT = "Y" Then ' measuring SLT
    If LLT = "" And MLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "" And DMG = "" And CRT = "" Then
        SSA = "PLAN"
    ElseIf LLT = "" And MLT = "" And ITO = "" And ITI = "Y" And SL6 = "" And FAIL = "" And DMG = "" And CRT = "" Then
        SSA = "PLAN"
    ElseIf LLT = "" And MLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "" And DMG = "" And CRT = "" Then
        SSA = "PLAN"
    ElseIf LLT = "" And MLT = "" And ITO = "" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "" And CRT = "" Then
        SSA = "LTO"
    ElseIf LLT = "" And MLT = "" And ITO = "" And ITI = "" And SL6 = "" And FAIL = "" And DMG = "Y" And CRT = "" Then
        SSA = "PLAN"
    ElseIf LLT = "" And MLT = "" And ITO = "" And ITI = "" And SL6 = "" And FAIL = "" And DMG = "" And CRT = "Y" Then
        SSA = "PLAN"
    ElseIf LLT = "" And MLT = "" And ITO = "" And ITI = "" And SL6 = "" And FAIL = "" And DMG = "Y" And CRT = "Y" Then
        SSA = "PLAN"
    ElseIf LLT = "" And MLT = "" And ITO = "" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "Y" And CRT = "" Then
        SSA = "LTO"
    ElseIf LLT = "" And MLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "" And CRT = "" Then
        SSA = "LTO"
    ElseIf LLT = "" And MLT = "" And ITO = "" And ITI = "Y" And SL6 = "Y" And FAIL = "" And DMG = "" And CRT = "" Then
        SSA = "PLAN"
    ElseIf LLT = "" And MLT = "" And ITO = "Y" And ITI = "" And SL6 = "Y" And FAIL = "" And DMG = "" And CRT = "" Then
        SSA = "LTO"
    ElseIf LLT = "" And MLT = "" And ITO = "Y" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "" And CRT = "" Then
        SSA = "LTO"
    ElseIf LLT = "" And MLT = "" And ITO = "Y" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "Y" And CRT = "" Then
        SSA = "LTO"
    ElseIf LLT = "" And MLT = "" And ITO = "Y" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "Y" And CRT = "Y" Then
        SSA = "LTO"
    ElseIf LLT = "" And MLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "" And CRT = "" Then
        SSA = "LTO"
    ElseIf LLT = "" And MLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "Y" And CRT = "" Then
        SSA = "LTO"
    ElseIf LLT = "" And MLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "Y" And CRT = "Y" Then
        SSA = "LTO"
    ElseIf LLT = "" And MLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "" And DMG = "Y" And CRT = "" Then
        SSA = "PLAN"
    ElseIf LLT = "" And MLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "" And DMG = "Y" And CRT = "Y" Then
        SSA = "PLAN"
    ElseIf LLT = "" And MLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "" And DMG = "" And CRT = "Y" Then
        SSA = "PLAN"
    ElseIf LLT = "" And MLT = "" And ITO = "Y" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "" And CRT = "Y" Then
        SSA = "LTO"
    ElseIf LLT = "" And MLT = "" And ITO = "Y" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "" And CRT = "Y" Then
        SSA = "LTO"
    ElseIf LLT = "" And MLT = "" And ITO = "Y" And ITI = "" And SL6 = "Y" And FAIL = "" And DMG = "" And CRT = "Y" Then
        SSA = "PLAN"
    ElseIf LLT = "" And MLT = "" And ITO = "Y" And ITI = "" And SL6 = "Y" And FAIL = "" And DMG = "Y" And CRT = "Y" Then
        SSA = "PLAN"
    ElseIf LLT = "" And MLT = "" And ITO = "" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "Y" And CRT = "Y" Then
        SSA = "LTO"
    ElseIf LLT = "" And MLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "Y" And CRT = "Y" Then
        SSA = "LTO"
    ElseIf LLT = "" And MLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "F" And DMG = "" And CRT = "" Then
        SSA = "LTO"
    ElseIf LLT = "" And MLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "" And CRT = "Y" Then
        SSA = "LTO"
    ElseIf LLT = "" And MLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "Y" And CRT = "" Then
        SSA = "LTO"
    ElseIf LLT = "" And MLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "Y" And DMG = "Y" And CRT = "Y" Then
        SSA = "LTO"
    ElseIf LLT = "" And MLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "" And DMG = "Y" And CRT = "" Then
        SSA = "PLAN"
    ElseIf LLT = "" And MLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "" And DMG = "Y" And CRT = "Y" Then
        SSA = "PLAN"
    ElseIf LLT = "" And MLT = "" And ITO = "" And ITI = "" And SL6 = "Y" And FAIL = "" And DMG = "" And CRT = "Y" Then
        SSA = "PLAN"
    ElseIf LLT = "" And MLT = "" And ITO = "" And ITI = "" And SL6 = "" And FAIL = "Y" And DMG = "" And CRT = "Y" Then
        SSA = "LTO"
    End If
End If
Else
End If
Cells(i, ssatt).Value = SSA
Next i
End Sub

Go To Top

Next Page >> Material Requirement Planning

This site was created in February 2007
by William Tan