Template:Workbook Example - Revision history

Dingzhou Cao at 16:22, 19 March 2012

2012-03-19T16:22:36Z

← Older revision		Revision as of 16:22, 19 March 2012
Line 14:		Line 14:
	: Tip:In Weibull++ you can use the RELIABILITY function to generate both standard and conditional calculations. For standard calculations, you would enter a value in the Age field and leave the Add Time field empty. For conditional calculations, you would enter the starting time in the Age field and the additional time in the Add Time field. In ALTA and BlockSim you can use the CONDRELIABILITY_S function to generate conditional calculations in a similar manner.		: Tip:In Weibull++ you can use the RELIABILITY function to generate both standard and conditional calculations. For standard calculations, you would enter a value in the Age field and leave the Add Time field empty. For conditional calculations, you would enter the starting time in the Age field and the additional time in the Add Time field. In ALTA and BlockSim you can use the CONDRELIABILITY_S function to generate conditional calculations in a similar manner.

	* Starting in cell C1, repeat for the second associated data source. When finished, your window would look like this: ~~Figure~~		* Starting in cell C1, repeat for the second associated data source. When finished, your window would look like this: [[Image:Report example2 WorkBook.png\|thumb\|center\|346px\|]]

	By looking at the data in the table you can see which design has the better reliability at a given time.		By looking at the data in the table you can see which design has the better reliability at a given time.

Dingzhou Cao at 16:21, 19 March 2012

2012-03-19T16:21:49Z

← Older revision		Revision as of 16:21, 19 March 2012
Line 7:		Line 7:
	* Associate the two analyses to the spreadsheet.		* Associate the two analyses to the spreadsheet.
	* Update the column headings in the report (i.e., Time in column A, Reliability Data Source 1 in column B and Reliability Data Source 2 in column C).		* Update the column headings in the report (i.e., Time in column A, Reliability Data Source 1 in column B and Reliability Data Source 2 in column C).
	* In cell A1 enter the first time value and in cell A2 use a function like =A1+100 to increment the time value used in that cell. Fill in cells A3 through A12 in a similar manner. When finished, your window would look like this: ~~Figure~~		* In cell A1 enter the first time value and in cell A2 use a function like =A1+100 to increment the time value used in that cell. Fill in cells A3 through A12 in a similar manner. When finished, your window would look like this:
			[[Image:Report example1 WorkBook.png\|thumb\|center\|346px\|]]

	* Click in cell B1 and open the Function Wizard. Select the RELIABILITY function (in Weibull++ or BlockSim) or the RELIABILITY_S function (in ALTA), use cell A1 for the time value and select the first associated data source. Then drag the column down to cell B12.		* Click in cell B1 and open the Function Wizard. Select the RELIABILITY function (in Weibull++ or BlockSim) or the RELIABILITY_S function (in ALTA), use cell A1 for the time value and select the first associated data source. Then drag the column down to cell B12.

Dingzhou Cao at 16:18, 19 March 2012

2012-03-19T16:18:30Z

← Older revision		Revision as of 16:18, 19 March 2012
Line 4:		Line 4:

	* First create the folios (in Weibull++ or ALTA) or diagrams (in BlockSim), add some data and calculate them.		* First create the folios (in Weibull++ or ALTA) or diagrams (in BlockSim), add some data and calculate them.
	# Add an Analysis Workbook to your project and do not select a default data source.		* Add an Analysis Workbook to your project and do not select a default data source.
	# Associate the two analyses to the spreadsheet.		* Associate the two analyses to the spreadsheet.
	# Update the column headings in the report (i.e., Time in column A, Reliability Data Source 1 in column B and Reliability Data Source 2 in column C).		* Update the column headings in the report (i.e., Time in column A, Reliability Data Source 1 in column B and Reliability Data Source 2 in column C).
	# In cell A1 enter the first time value and in cell A2 use a function like =A1+100 to increment the time value used in that cell. Fill in cells A3 through A12 in a similar manner. When finished, your window would look like this: Figure		* In cell A1 enter the first time value and in cell A2 use a function like =A1+100 to increment the time value used in that cell. Fill in cells A3 through A12 in a similar manner. When finished, your window would look like this: Figure
	# Click in cell B1 and open the Function Wizard. Select the RELIABILITY function (in Weibull++ or BlockSim) or the RELIABILITY_S function (in ALTA), use cell A1 for the time value and select the first associated data source. Then drag the column down to cell B12.		* Click in cell B1 and open the Function Wizard. Select the RELIABILITY function (in Weibull++ or BlockSim) or the RELIABILITY_S function (in ALTA), use cell A1 for the time value and select the first associated data source. Then drag the column down to cell B12.

	: Tip:In Weibull++ you can use the RELIABILITY function to generate both standard and conditional calculations. For standard calculations, you would enter a value in the Age field and leave the Add Time field empty. For conditional calculations, you would enter the starting time in the Age field and the additional time in the Add Time field. In ALTA and BlockSim you can use the CONDRELIABILITY_S function to generate conditional calculations in a similar manner.		: Tip:In Weibull++ you can use the RELIABILITY function to generate both standard and conditional calculations. For standard calculations, you would enter a value in the Age field and leave the Add Time field empty. For conditional calculations, you would enter the starting time in the Age field and the additional time in the Add Time field. In ALTA and BlockSim you can use the CONDRELIABILITY_S function to generate conditional calculations in a similar manner.

	# Starting in cell C1, repeat for the second associated data source. When finished, your window would look like this: Figure		* Starting in cell C1, repeat for the second associated data source. When finished, your window would look like this: Figure

	By looking at the data in the table you can see which design has the better reliability at a given time.		By looking at the data in the table you can see which design has the better reliability at a given time.

Dingzhou Cao at 16:18, 19 March 2012

2012-03-19T16:18:10Z

← Older revision		Revision as of 16:18, 19 March 2012
Line 3:		Line 3:
	For example, suppose that you have the reliability data for two components from different suppliers. You can create a table that shows the reliability for each at a given time.		For example, suppose that you have the reliability data for two components from different suppliers. You can create a table that shows the reliability for each at a given time.

	# First create the folios (in Weibull++ or ALTA) or diagrams (in BlockSim), add some data and calculate them.		* First create the folios (in Weibull++ or ALTA) or diagrams (in BlockSim), add some data and calculate them.
	# Add an Analysis Workbook to your project and do not select a default data source.		# Add an Analysis Workbook to your project and do not select a default data source.
	# Associate the two analyses to the spreadsheet.		# Associate the two analyses to the spreadsheet.

Dingzhou Cao at 16:17, 19 March 2012

2012-03-19T16:17:56Z

← Older revision		Revision as of 16:17, 19 March 2012
Line 7:		Line 7:
	# Associate the two analyses to the spreadsheet.		# Associate the two analyses to the spreadsheet.
	# Update the column headings in the report (i.e., Time in column A, Reliability Data Source 1 in column B and Reliability Data Source 2 in column C).		# Update the column headings in the report (i.e., Time in column A, Reliability Data Source 1 in column B and Reliability Data Source 2 in column C).
	# In cell A1 enter the first time value and in cell A2 use a function like =A1+100 to increment the time value used in that cell. Fill in cells A3 through A12 in a similar manner. When finished, your window would look like this:		# In cell A1 enter the first time value and in cell A2 use a function like =A1+100 to increment the time value used in that cell. Fill in cells A3 through A12 in a similar manner. When finished, your window would look like this: Figure
	Figure
	# Click in cell B1 and open the Function Wizard. Select the RELIABILITY function (in Weibull++ or BlockSim) or the RELIABILITY_S function (in ALTA), use cell A1 for the time value and select the first associated data source. Then drag the column down to cell B12.		# Click in cell B1 and open the Function Wizard. Select the RELIABILITY function (in Weibull++ or BlockSim) or the RELIABILITY_S function (in ALTA), use cell A1 for the time value and select the first associated data source. Then drag the column down to cell B12.

	: Tip:In Weibull++ you can use the RELIABILITY function to generate both standard and conditional calculations. For standard calculations, you would enter a value in the Age field and leave the Add Time field empty. For conditional calculations, you would enter the starting time in the Age field and the additional time in the Add Time field. In ALTA and BlockSim you can use the CONDRELIABILITY_S function to generate conditional calculations in a similar manner.		: Tip:In Weibull++ you can use the RELIABILITY function to generate both standard and conditional calculations. For standard calculations, you would enter a value in the Age field and leave the Add Time field empty. For conditional calculations, you would enter the starting time in the Age field and the additional time in the Add Time field. In ALTA and BlockSim you can use the CONDRELIABILITY_S function to generate conditional calculations in a similar manner.

	# Starting in cell C1, repeat for the second associated data source. When finished, your window would look like this:		# Starting in cell C1, repeat for the second associated data source. When finished, your window would look like this: Figure
	Figure
	By looking at the data in the table you can see which design has the better reliability at a given time.		By looking at the data in the table you can see which design has the better reliability at a given time.

Dingzhou Cao at 16:17, 19 March 2012

2012-03-19T16:17:40Z

← Older revision		Revision as of 16:17, 19 March 2012
Line 10:		Line 10:
	Figure		Figure
	# Click in cell B1 and open the Function Wizard. Select the RELIABILITY function (in Weibull++ or BlockSim) or the RELIABILITY_S function (in ALTA), use cell A1 for the time value and select the first associated data source. Then drag the column down to cell B12.		# Click in cell B1 and open the Function Wizard. Select the RELIABILITY function (in Weibull++ or BlockSim) or the RELIABILITY_S function (in ALTA), use cell A1 for the time value and select the first associated data source. Then drag the column down to cell B12.

	: Tip:In Weibull++ you can use the RELIABILITY function to generate both standard and conditional calculations. For standard calculations, you would enter a value in the Age field and leave the Add Time field empty. For conditional calculations, you would enter the starting time in the Age field and the additional time in the Add Time field. In ALTA and BlockSim you can use the CONDRELIABILITY_S function to generate conditional calculations in a similar manner.		: Tip:In Weibull++ you can use the RELIABILITY function to generate both standard and conditional calculations. For standard calculations, you would enter a value in the Age field and leave the Add Time field empty. For conditional calculations, you would enter the starting time in the Age field and the additional time in the Add Time field. In ALTA and BlockSim you can use the CONDRELIABILITY_S function to generate conditional calculations in a similar manner.

	# Starting in cell C1, repeat for the second associated data source. When finished, your window would look like this:		# Starting in cell C1, repeat for the second associated data source. When finished, your window would look like this:
	Figure		Figure
	By looking at the data in the table you can see which design has the better reliability at a given time.		By looking at the data in the table you can see which design has the better reliability at a given time.

Dingzhou Cao at 16:17, 19 March 2012

2012-03-19T16:17:29Z

← Older revision		Revision as of 16:17, 19 March 2012
Line 10:		Line 10:
	Figure		Figure
	# Click in cell B1 and open the Function Wizard. Select the RELIABILITY function (in Weibull++ or BlockSim) or the RELIABILITY_S function (in ALTA), use cell A1 for the time value and select the first associated data source. Then drag the column down to cell B12.		# Click in cell B1 and open the Function Wizard. Select the RELIABILITY function (in Weibull++ or BlockSim) or the RELIABILITY_S function (in ALTA), use cell A1 for the time value and select the first associated data source. Then drag the column down to cell B12.
	:: Tip:In Weibull++ you can use the RELIABILITY function to generate both standard and conditional calculations. For standard calculations, you would enter a value in the Age field and leave the Add Time field empty. For conditional calculations, you would enter the starting time in the Age field and the additional time in the Add Time field. In ALTA and BlockSim you can use the CONDRELIABILITY_S function to generate conditional calculations in a similar manner.		: Tip:In Weibull++ you can use the RELIABILITY function to generate both standard and conditional calculations. For standard calculations, you would enter a value in the Age field and leave the Add Time field empty. For conditional calculations, you would enter the starting time in the Age field and the additional time in the Add Time field. In ALTA and BlockSim you can use the CONDRELIABILITY_S function to generate conditional calculations in a similar manner.
	# Starting in cell C1, repeat for the second associated data source. When finished, your window would look like this:		# Starting in cell C1, repeat for the second associated data source. When finished, your window would look like this:
	Figure		Figure
	By looking at the data in the table you can see which design has the better reliability at a given time.		By looking at the data in the table you can see which design has the better reliability at a given time.

Dingzhou Cao at 16:17, 19 March 2012

2012-03-19T16:17:12Z

← Older revision		Revision as of 16:17, 19 March 2012
Line 4:		Line 4:

	# First create the folios (in Weibull++ or ALTA) or diagrams (in BlockSim), add some data and calculate them.		# First create the folios (in Weibull++ or ALTA) or diagrams (in BlockSim), add some data and calculate them.
			# Add an Analysis Workbook to your project and do not select a default data source.
			# Associate the two analyses to the spreadsheet.
			# Update the column headings in the report (i.e., Time in column A, Reliability Data Source 1 in column B and Reliability Data Source 2 in column C).
			# In cell A1 enter the first time value and in cell A2 use a function like =A1+100 to increment the time value used in that cell. Fill in cells A3 through A12 in a similar manner. When finished, your window would look like this:
			Figure
			# Click in cell B1 and open the Function Wizard. Select the RELIABILITY function (in Weibull++ or BlockSim) or the RELIABILITY_S function (in ALTA), use cell A1 for the time value and select the first associated data source. Then drag the column down to cell B12.
			:: Tip:In Weibull++ you can use the RELIABILITY function to generate both standard and conditional calculations. For standard calculations, you would enter a value in the Age field and leave the Add Time field empty. For conditional calculations, you would enter the starting time in the Age field and the additional time in the Add Time field. In ALTA and BlockSim you can use the CONDRELIABILITY_S function to generate conditional calculations in a similar manner.
			# Starting in cell C1, repeat for the second associated data source. When finished, your window would look like this:
			Figure
			By looking at the data in the table you can see which design has the better reliability at a given time.

Dingzhou Cao at 16:15, 19 March 2012

2012-03-19T16:15:36Z

← Older revision		Revision as of 16:15, 19 March 2012
Line 3:		Line 3:
	For example, suppose that you have the reliability data for two components from different suppliers. You can create a table that shows the reliability for each at a given time.		For example, suppose that you have the reliability data for two components from different suppliers. You can create a table that shows the reliability for each at a given time.

	## First create the folios (in Weibull++ or ALTA) or diagrams (in BlockSim), add some data and calculate them.		# First create the folios (in Weibull++ or ALTA) or diagrams (in BlockSim), add some data and calculate them.

Dingzhou Cao: Created page with 'Using ReliaSoft’s analysis workbook and Function Wizard, you can generate many different types of results. For example, suppose that you have the reliability data for two comp…'

2012-03-19T16:14:04Z

Created page with 'Using ReliaSoft’s analysis workbook and Function Wizard, you can generate many different types of results. For example, suppose that you have the reliability data for two comp…'

New page

Using ReliaSoft’s analysis workbook and Function Wizard, you can generate many different types of results.

For example, suppose that you have the reliability data for two components from different suppliers. You can create a table that shows the reliability for each at a given time.

## First create the folios (in Weibull++ or ALTA) or diagrams (in BlockSim), add some data and calculate them.