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%3EExtraiga%20los%20datos%20del%20informe%20y%20exp%C3%B3rtelos%20a%20Excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-225417%22%20slang%3D%22en-US%22%20mode%3D%22NONE%22%3E%3CP%3ESoy%20totalmente%20nuevo%20en%20la%20comunidad%20JMP%20y%20tengo%20un%20fondo%20de%20codificaci%C3%B3n%20limitado.%20Estoy%20trabajando%20con%20distribuciones%20de%20vida%20(principalmente%20Weibulls)%2C%20y%20me%20gustar%C3%ADa%20crear%20un%20complemento%20que%20pueda%20realizar%20las%20siguientes%20tareas%20una%20vez%20que%20haya%20seleccionado%20el%20mejor%20ajuste%20de%20distribuci%C3%B3n%3A%3C%2FP%3E%0A%3CP%3E1)%20Guarde%20datos%20de%20informes%20espec%C3%ADficos%20de%20la%20distribuci%C3%B3n%20(consulte%20las%20tablas%20de%20datos%20%3CFONT%20color%3D%22%23FF0000%22%3E%20en%20rojo)%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)%20Exportar%20los%20datos%20a%20una%20hoja%20de%20Excel%3C%2FP%3E%0A%3CP%3E3)%20%C2%BFTiene%20el%20bot%C3%B3n%20de%20complemento%20disponible%20dentro%20de%20la%20ventana%20del%20informe%3F%3C%2FP%3E%0A%3CP%3E%C2%A1MUCHAS%20GRACIAS!%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EEste%20es%20el%20script%20de%20informe%20detr%C3%A1s%20de%20la%20distribuci%C3%B3n%20y%20los%20par%C3%A1metros%20que%20necesito%20dentro%20del%20c%C3%B3digo%3A%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