Enter your data for Pre-Process Warranty Data

Select the option that best describes your data.

In This Topic

Shipment values in a column
Shipment values in first row of return columns

Shipment values in a column

Select this option if you recorded the total number of items shipped in a single column of the worksheet, and the number of items returned in each period in subsequent columns.

In Shipment (sale) column, enter the column that contains the number of items shipped in specific time periods.
In Return (failure) columns, enter the columns that contain the failures or returns for the production lots in subsequent time periods.

In this worksheet, the number of items shipped in each year is recorded in a single column, with each row representing a different year. The number of items returned each year is recorded in a separate column. For example, in 2011, 15,000 items were shipped. 78 of those items were returned in 2012, 130 of those items were returned in 2013, and 200 of those items were returned in 2014.

C1	C2	C3	C4	C5	C6
Year Shipped	Quantity Shipped	Returned 2011	Returned 2012	Returned 2013	Returned 2014
2010	10000	50	60	100	300
2011	15000		78	130	200
2012	23000			275	600
2013	32000				400

Shipment values in first row of return columns

Select this option if you recorded the total number of items shipped in the first row, and the number of items returned in each period in subsequent rows. In Return (failure) columns, enter the columns that contain the failures or returns for the production lots in subsequent time periods.

In this worksheet, the first row indicates the total number of items shipped in each year. Each column represents a different year of shipment. Each cell of a column indicates the number of items returned in each subsequent time period. For example, 23,000 items were shipped in 2012. In the following year, 275 of those items were returned. In the year after that, 600 were returned.

C1	C2	C3	C5
Shipped 2010	Shipped 2011	Shipped 2012	Shipped 2013
10000	15000	23000	32000
50	78	275	400
60	130	600
100	200
300