Hi all,   l am currently working on a project and was given four excel files that l need to import into JMP and was using the below script to import these files, however, l was just informed that up to 20 files might be involved so i was wondering if the code i have below could be simplified that i am not copying and pasting up to 20 times, all the excel files will have the same structure. Names Default To Here( 1 ); Clear Symbols(); pb = Page Break Box(); fileopen= "\\prusntyfil01\home$\sv001241\Desktop\Project Rodger\File 1.xlsx"; //dt=open(fileopen,private); dt = Open( fileopen, Worksheets( "Sheet1" ), Worksheet Settings( 1, Has Column Headers( 1 ), Number of Rows in Headers( 1 ), Headers Start on Row( 2 ), Data Starts on Row( 3 ), Data Starts on Column( 1 ), Data Ends on Row( 18 ), Data Ends on Column( 39 ), Replicated Spanned Rows( 1 ), Replicated Spanned Headers( 0 ), Suppress Hidden Rows( 1 ), Suppress Hidden Columns( 1 ), Suppress Empty Columns( 1 ), Treat as Hierarchy( 0 ), Multiple Series Stack( 0 ), Import Cell Colors( 0 ), Limit Column Detect( 0 ), Column Separator String( "" ) ), ); Datasource = fileopen; dtvn = Open( fileopen, Worksheets( "Sheet1" ), Worksheet Settings( 1, Has Column Headers( 0 ), Number of Rows in Headers( 0 ), Headers Start on Row( 0 ), Data Starts on Row( 1 ), Data Starts on Column( 1 ), Data Ends on Row( 1 ), Data Ends on Column( 1 ), Replicated Spanned Rows( 1 ), Replicated Spanned Headers( 0 ), Suppress Hidden Rows( 1 ), Suppress Hidden Columns( 1 ), Suppress Empty Columns( 1 ), Treat as Hierarchy( 0 ), Multiple Series Stack( 0 ), Import Cell Colors( 0 ), Limit Column Detect( 0 ), Column Separator String( "-" ) ), ); col=Column(1); col << Set Name("plate"); dt1=dt << Join( With( dtvn ), Copy second table formula( 0 ), Suppress main table formula evaluation( 0 ), Cartesian Join ); dt1 << New Column( "Scheme", Character, Nominal, Formula(Left(Right(:plate, 15), 2) ) ); fileopen= "\\prusntyfil01\home$\sv001241\Desktop\Project Rodger\File 2.xlsx"; //dt=open(fileopen,private); dt2 = Open( fileopen, Worksheets( "Sheet1" ), Worksheet Settings( 1, Has Column Headers( 1 ), Number of Rows in Headers( 1 ), Headers Start on Row( 2 ), Data Starts on Row( 3 ), Data Starts on Column( 1 ), Data Ends on Row( 18 ), Data Ends on Column( 39 ), Replicated Spanned Rows( 1 ), Replicated Spanned Headers( 0 ), Suppress Hidden Rows( 1 ), Suppress Hidden Columns( 1 ), Suppress Empty Columns( 1 ), Treat as Hierarchy( 0 ), Multiple Series Stack( 0 ), Import Cell Colors( 0 ), Limit Column Detect( 0 ), Column Separator String( "" ) ), ); Datasource = fileopen; dtvn1 = Open( fileopen, Worksheets( "Sheet1" ), Worksheet Settings( 1, Has Column Headers( 0 ), Number of Rows in Headers( 0 ), Headers Start on Row( 0 ), Data Starts on Row( 1 ), Data Starts on Column( 1 ), Data Ends on Row( 1 ), Data Ends on Column( 1 ), Replicated Spanned Rows( 1 ), Replicated Spanned Headers( 0 ), Suppress Hidden Rows( 1 ), Suppress Hidden Columns( 1 ), Suppress Empty Columns( 1 ), Treat as Hierarchy( 0 ), Multiple Series Stack( 0 ), Import Cell Colors( 0 ), Limit Column Detect( 0 ), Column Separator String( "-" ) ), ); col=Column(1); col << Set Name("plate"); dt3=dt << Join( With( dtvn1 ), Copy second table formula( 0 ), Suppress main table formula evaluation( 0 ), Cartesian Join ); dt3 << New Column( "Scheme", Character, Nominal, Formula(Left(Right(:plate, 15), 2) ) ); fileopen= "\\prusntyfil01\home$\sv001241\Desktop\Project Rodger\File 3.xlsx"; //dt=open(fileopen,private); dt4 = Open( fileopen, Worksheets( "Sheet1" ), Worksheet Settings( 1, Has Column Headers( 1 ), Number of Rows in Headers( 1 ), Headers Start on Row( 2 ), Data Starts on Row( 3 ), Data Starts on Column( 1 ), Data Ends on Row( 18 ), Data Ends on Column( 39 ), Replicated Spanned Rows( 1 ), Replicated Spanned Headers( 0 ), Suppress Hidden Rows( 1 ), Suppress Hidden Columns( 1 ), Suppress Empty Columns( 1 ), Treat as Hierarchy( 0 ), Multiple Series Stack( 0 ), Import Cell Colors( 0 ), Limit Column Detect( 0 ), Column Separator String( "" ) ), ); Datasource = fileopen; dtvn2 = Open( fileopen, Worksheets( "Sheet1" ), Worksheet Settings( 1, Has Column Headers( 0 ), Number of Rows in Headers( 0 ), Headers Start on Row( 0 ), Data Starts on Row( 1 ), Data Starts on Column( 1 ), Data Ends on Row( 1 ), Data Ends on Column( 1 ), Replicated Spanned Rows( 1 ), Replicated Spanned Headers( 0 ), Suppress Hidden Rows( 1 ), Suppress Hidden Columns( 1 ), Suppress Empty Columns( 1 ), Treat as Hierarchy( 0 ), Multiple Series Stack( 0 ), Import Cell Colors( 0 ), Limit Column Detect( 0 ), Column Separator String( "-" ) ), ); col=Column(1); col << Set Name("plate"); dt5=dt4 << Join( With( dtvn2 ), Copy second table formula( 0 ), Suppress main table formula evaluation( 0 ), Cartesian Join ); dt5 << New Column( "Scheme", Character, Nominal, Formula(Left(Right(:plate, 15), 2) ) ); fileopen= "\\prusntyfil01\home$\sv001241\Desktop\Project Rodger\File 4.xlsx"; //dt=open(fileopen,private); dt6 = Open( fileopen, Worksheets( "Sheet1" ), Worksheet Settings( 1, Has Column Headers( 1 ), Number of Rows in Headers( 1 ), Headers Start on Row( 2 ), Data Starts on Row( 3 ), Data Starts on Column( 1 ), Data Ends on Row( 18 ), Data Ends on Column( 39 ), Replicated Spanned Rows( 1 ), Replicated Spanned Headers( 0 ), Suppress Hidden Rows( 1 ), Suppress Hidden Columns( 1 ), Suppress Empty Columns( 1 ), Treat as Hierarchy( 0 ), Multiple Series Stack( 0 ), Import Cell Colors( 0 ), Limit Column Detect( 0 ), Column Separator String( "" ) ), ); Datasource = fileopen; dtvn3 = Open( fileopen, Worksheets( "Sheet1" ), Worksheet Settings( 1, Has Column Headers( 0 ), Number of Rows in Headers( 0 ), Headers Start on Row( 0 ), Data Starts on Row( 1 ), Data Starts on Column( 1 ), Data Ends on Row( 1 ), Data Ends on Column( 1 ), Replicated Spanned Rows( 1 ), Replicated Spanned Headers( 0 ), Suppress Hidden Rows( 1 ), Suppress Hidden Columns( 1 ), Suppress Empty Columns( 1 ), Treat as Hierarchy( 0 ), Multiple Series Stack( 0 ), Import Cell Colors( 0 ), Limit Column Detect( 0 ), Column Separator String( "-" ) ), ); col=Column(1); col << Set Name("plate"); dt7=dt6 << Join( With( dtvn3 ), Copy second table formula( 0 ), Suppress main table formula evaluation( 0 ), Cartesian Join ); dt7 << New Column( "Scheme", Character, Nominal, Formula(Left(Right(:plate, 15), 2) ) ); dt8=dt1 << Concatenate( Data Table ( dt3 ), Data Table ( dt5 ), Data Table ( dt7 ), ); ... View more

Hi All,    i would like to replicate the following scatter plots in JMP, the problem i am having is when i go to axis setting and request a log scale with a base 2 the scale starts from 1, so the scales is 1,2,4,8,16, 32, 64 etc i would like it to start at 5, 10, 20,40, 80,160,320 etc does anyone have any advice??     Any help would be appreciated.   Thanks ... View more

Hi,   l am trying to check if a value in a cell within a variable lies within a range of values, between 0.50 and 2.0, and if it does fall within that range to return true and if it doesnt return false. i am in the data table, and column info, and typing the following into the edit formula:      If (0.50 < ( :Name( "P1-R1-D1-L1" ) > 2.0), "True", "False") // and  If (0.50 < ( :Name( "P1-R1-D1-L1" ))|(2.0 > ( :Name( "P1-R1-D1-L1" ), "True", "False"))   but neither is working for me, what am i doing wrong, any help would be greatly appreciated   Thanks ... View more

Hi, i have the following syntax: dt2<< Summary( Group( :Sample ), Mean( :dilution factor, :l10t ), Freq( "None" ), Weight( "None" ), Output Table( "log10t" ), Std Err( :l10t ), Link to original data table(0) ); Loq = Data Table( "log10t" ); Loq << column(:Mean(l10t)) <<Format( "Fixed Dec", 12, 4 ); Loq << column(:Name ("Mean(l10t)")) << Format( "Fixed Dec", 12, 4 ); Column(Loq,:Mean(l10t)) << Set Format ( "Fixed Dec", 12, 4 ); so l get a data table using the above syntax, however, the variable Mean(l10t) it produces in the table has 10 decimal places, the next three lines of code are trying to re format to a fixed decimal place of 4, none has worked, could anyone please advise why?? Also when i work with variables in JMP sometimes i can use just :variable name to use the variable, quite often this wont work and i have to use :Name("Variable Name"), why??   Thanks ... View more

Hello All, i was hoping that someone can help me with Modal, previously i was calculating FV in my JMP script as follows: Finalivc2 << New Column( "Runs", Numeric, Continuous ); :Runs<<set each value(2); Finalivc2 << New Column( "Replicates per Run", Numeric, Continuous); :Replicates per run<<set each value(1); Finalivc2 << New Column( "Format Variability %GCV", Numeric, Continuous, Formula( ((2^root(((:IR)/(:Runs)+(:Residual)/(:Replicates per Run*:Runs)),2))-1)*100 ), Format( "fixed dec", 4, 1 ) ); which worked OK, although on ocassions i would forget to update the :Runs and :Replicates per run parameters which gave me some grief, i decided to automate this process using modal as follows FV_param = New Window ("Format Variability Parameters", << Modal, << Return Result, Text Box ("Select Format Variability Parameters"),//Create the display box HListBox( LineupBox (NCol (2), Text Box ("Runs NOT REPLICATES"), Runs = numberEditBox(2), Text Box ("Replicates NOT RUNS"), Replicates per Run = numberEditBox(1), ), // end of lineupbox LineupBox ( NCol (1), ButtonBox ("OK"), ButtonBox ("Cancel")) ) // end HListBox ); show (FV_param, FV_param ["Runs"], FV_param ["Replicates per Run"], FV_param ["Button"] ); If (FV_param ["Button"] == -1, Caption (" Wait...Aborting..."); Wait (3) ; Caption(Remove); Throw()); StatusMsg ("Processing next steps"); RemoveFrom (FV_param, NItems(FV_param)); // Removes the last item "Button 1" from the assignment list Eval List(FV_param); // the assignment from the display box Eval( Substitute( Expr( Finalivc2 = New Column( "Runs", Numeric, "Continuous", Format( "Best", 12 ), Expr( Finalivc2 = New Column( "Replicates per Run", Numeric, "Continuous", Format( "Best", 12 ), ) ), Expr( __FV_param__ ), Runs, Replicates per Run ) ))); Finalivc2 << New Column( "Format Variability %GCV", Numeric, Continuous, Formula( ((2^root(((:IR)/(:Runs)+(:Residual)/(:Replicates per Run*:Runs)),2))-1)*100 ), Format( "fixed dec", 4, 1 ) ); i have no doubt i am doing the evaluating and substituting incorrectly, i am not getting the variables runs and Relicates per run in the table, and its then not doing the calculation, can anyone please offer some help   Thanks ... View more