cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Discussions

Solve problems, and share tips and tricks with other JMP users.
%3CLINGO-SUB%20id%3D%22lingo-sub-225417%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%E3%83%AC%E3%83%9D%E3%83%BC%E3%83%88%E3%83%87%E3%83%BC%E3%82%BF%E3%82%92%E6%8A%BD%E5%87%BA%E3%81%97%E3%81%A6Excel%E3%81%AB%E3%82%A8%E3%82%AF%E3%82%B9%E3%83%9D%E3%83%BC%E3%83%88%E3%81%99%E3%82%8B%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-225417%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3E%E7%A7%81%E3%81%AFJMP%E3%82%B3%E3%83%9F%E3%83%A5%E3%83%8B%E3%83%86%E3%82%A3%E3%81%AB%E3%81%AF%E3%81%BE%E3%81%A3%E3%81%9F%E3%81%8F%E6%96%B0%E3%81%97%E3%81%84%E4%BA%BA%E3%81%A7%E3%80%81%E3%82%B3%E3%83%BC%E3%83%87%E3%82%A3%E3%83%B3%E3%82%B0%E3%81%AE%E3%83%90%E3%83%83%E3%82%AF%E3%82%B0%E3%83%A9%E3%82%A6%E3%83%B3%E3%83%89%E3%81%AF%E9%99%90%E3%82%89%E3%82%8C%E3%81%A6%E3%81%84%E3%81%BE%E3%81%99%E3%80%82%E7%A7%81%E3%81%AFLife%20Distributions%EF%BC%88%E4%B8%BB%E3%81%AB%E3%83%AF%E3%82%A4%E3%83%96%E3%83%AB%E3%82%BA%EF%BC%89%E3%82%92%E6%89%B1%E3%81%A3%E3%81%A6%E3%81%84%E3%81%BE%E3%81%99%E3%80%82%E6%9C%80%E9%81%A9%E3%81%AA%E5%88%86%E5%B8%83%E3%82%92%E9%81%B8%E6%8A%9E%E3%81%97%E3%81%9F%E3%82%89%E3%80%81%E6%AC%A1%E3%81%AE%E3%82%BF%E3%82%B9%E3%82%AF%E3%82%92%E5%AE%9F%E8%A1%8C%E3%81%A7%E3%81%8D%E3%82%8B%E3%82%A2%E3%83%89%E3%82%A4%E3%83%B3%E3%82%92%E4%BD%9C%E6%88%90%E3%81%97%E3%81%9F%E3%81%84%E3%81%A8%E6%80%9D%E3%81%84%E3%81%BE%E3%81%99%E3%80%82%3C%2FP%3E%0A%3CP%3E1%E3%80%82%E9%85%8D%E5%B8%83%E3%81%8B%E3%82%89%E7%89%B9%E5%AE%9A%E3%81%AE%E3%83%AC%E3%83%9D%E3%83%BC%E3%83%88%E3%83%87%E3%83%BC%E3%82%BF%E3%82%92%E4%BF%9D%E5%AD%98%E3%81%97%E3%81%BE%E3%81%99%EF%BC%88%E3%83%87%E3%83%BC%E3%82%BF%E3%83%86%E3%83%BC%E3%83%96%E3%83%AB%E3%82%92%E5%8F%82%E7%85%A7%E3%81%97%E3%81%A6%E3%81%8F%E3%81%A0%E3%81%95%E3%81%84%EF%BC%89%20%3CFONT%20color%3D%22%23FF0000%22%3E%E8%B5%A4%E3%81%A7%EF%BC%89%20%3C%2FFONT%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Capturesss.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F19255iDDC2F4C1FA7E0FE8%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Capturesss.PNG%22%20alt%3D%22Capturesss.PNG%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20999px%3B%22%3E%3Cspan%20class%3D%22lia-inline-image-display-wrapper%22%20image-alt%3D%22Capture.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3Cimg%20src%3D%22https%3A%2F%2Fcommunity.jmp.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F19256i5F27939C314CEA6D%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Capture.PNG%22%20alt%3D%22Capture.PNG%22%20%2F%3E%3C%2Fspan%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3E2%E3%80%82%E3%83%87%E3%83%BC%E3%82%BF%E3%82%92Excel%E3%82%B7%E3%83%BC%E3%83%88%E3%81%AB%E3%82%A8%E3%82%AF%E3%82%B9%E3%83%9D%E3%83%BC%E3%83%88%E3%81%99%E3%82%8B%3C%2FP%3E%0A%3CP%3E3%E3%80%82%E3%83%AC%E3%83%9D%E3%83%BC%E3%83%88%E3%82%A6%E3%82%A3%E3%83%B3%E3%83%89%E3%82%A6%E3%81%A7%E3%82%A2%E3%83%89%E3%82%A4%E3%83%B3%E3%83%9C%E3%82%BF%E3%83%B3%E3%82%92%E4%BD%BF%E7%94%A8%E3%81%A7%E3%81%8D%E3%81%BE%E3%81%99%E3%81%8B%EF%BC%9F%3C%2FP%3E%0A%3CP%3E%E6%9C%AC%E5%BD%93%E3%81%AB%E3%81%82%E3%82%8A%E3%81%8C%E3%81%A8%E3%81%86%EF%BC%81%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%E3%81%93%E3%82%8C%E3%81%AF%E3%80%81%E3%82%B3%E3%83%BC%E3%83%89%E5%86%85%E3%81%A7%E5%BF%85%E8%A6%81%E3%81%AA%E5%88%86%E5%B8%83%E3%81%A8%E3%83%91%E3%83%A9%E3%83%A1%E3%83%BC%E3%82%BF%E3%83%BC%E3%81%AE%E8%83%8C%E5%BE%8C%E3%81%AB%E3%81%82%E3%82%8B%E3%83%AC%E3%83%9D%E3%83%BC%E3%83%88%E3%82%B9%E3%82%AF%E3%83%AA%E3%83%97%E3%83%88%E3%81%A7%E3%81%99%E3%80%82%3C%2FP%3E%0A%3CPRE%3E%3CCODE%20class%3D%22%20language-jsl%22%3ELife%20Distribution(%0A%20Y(%20%3Aevent_age%20)%2C%0A%20Censor(%20%3Aevent_type%20)%2C%0A%20Censor%20Code(%20%22S%22%20)%2C%0A%20%26lt%3B%3CFIT%20weibull%3D%22%22%3E%3C%2FFIT%3E%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Choose Language Hide Translation Bar

Extract Report Data and Export it to Excel

I am totally new to the JMP community and have a limited coding background. I am working with Life Distributions (Weibulls mostly), and I would like to create an Add-in that can do the following tasks once I have selected the best distribution fit:

1. Save specific report data from distribution (see the data tables in red)Capturesss.PNGCapture.PNG

2. Export the data into an excel sheet

3. Have the add-in button available whithin report window?

HUGE THANKS! 

 

This is the report script behind the distribution and parameters I need within the code:

Life Distribution(
	Y( :event_age ),
	Censor( :event_type ),
	Censor Code( "S" ),
	<<Fit Weibull,
	Confidence Interval Method( Likelihood ),
	<<Set Scale( Weibull ),
	<<Suppress Plot( Nonparametric ),
	Interval Type( Simultaneous ),
	Show Event Plot Frequency Label( 0 ),
	<<Set Scriptables(
		{Probability Paper(
			Profiler(
				1,
				Confidence Intervals( 1 ),
				Term Value( event_age( 4.657084189, Lock( 0 ), Show( 1 ) ) )
			)
		), Weibull Distribution(
			Profiler( 1, Confidence Intervals( 1 ), Term Value( event_age( 4.6571, Lock( 0 ), Show( 1 ) ) ) )
		), Weibull Quantile(
			Profiler( 1, Confidence Intervals( 1 ), Term Value( Probability( 0.5, Lock( 0 ), Show( 1 ) ) ) )
		), Weibull Hazard(
			Profiler( 1, Confidence Intervals( 1 ), Term Value( event_age( 4.6571, Lock( 0 ), Show( 1 ) ) ) )
		), Weibull Density(
			Profiler( 1, Confidence Intervals( 0 ), Term Value( event_age( 4.6571, Lock( 0 ), Show( 1 ) ) ) )
		), Custom Estimation( Weibull, 1, Estimate Probability( 5, 10, 15, 20, 25, 30, 35, 40 ) )}
	),
	SendToReport(
		Dispatch(
			{"Compare Distributions"},
			"Life Distribution",
			FrameBox( 2 ),
			{Grid Line Order( 2 ), Reference Line Order( 3 )}
		),
		Dispatch(
			{"Compare Distributions"},
			"Distribution Profiler",
			OutlineBox,
			{Set Summary Behavior( "Collapse" )}
		),
		Dispatch( {"Statistics"}, "", ListBox, {Set Summary Behavior( "Collapse" )} )
	)
);

 

0 REPLIES 0

Recommended Articles