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

Hi, Was wondering if anyone can help me with a syntax problem, l wish to use the first value from another variable then increase this value by 3.3, the same as the below, Obs   Expected       12.3   12.3 15.4   15.6 18.7   18.9 22.0   22.2 25.8   25.5 28.9   28.8 32.2   32.1 35.1   35.4   Currently I have set the values as follows, however I would really like to automate as l have a few to do Acc << New Column( "exp", Numeric, Continuous, Format( "fixed dec", 6, 1 ), Set Selected, Set Values( [12.3, 15.6, 18.9, 22.2, 25.5, 28.8, 32.1, 35.4] ) ); Thanks to all ... View more

I have a data table consisting of six variables and 2000 subjects, I can manually do the analysis I want which is to fit y by x with y = mcg/mL, x = Time point and I want it by subtype, I then want to group it by Lot Number, and fit special – I want a natural log transformation of y and not centred and I get this along with a report which is perfect and exactly what I want, however, I would like to automate the process when I do this maually then use “current data table() get script;  and modify the syntax I get Bivariate(SendToByGroup({:Subtype }), Y(:Name("HA mcg/mL")), X(:Time point), Fit Where(:Lot Number, Fit Special(yTran("Log"), Centered Polynomial(0)))); however the by subtype is not working, group by lot number and the transformation isn’t working, can anyone provide any advice?? Many thanks   Mickyboy ... View more

Hi Guys,   Have written two bit of code to stack a Dt this: Stack(   columns( :Name( "L1-D1-O1-R1" ), :Name( "L1-D1-O1-R2" ), :Name( "L1-D1-O1-R3" ), :Name( "L1-D1-O2-R1" ), :Name( "L1-D1-O2-R2" ), :Name( "L1-D1-O2-R3" ), :Name( "L1-D2-O1-R1" ), :Name( "L1-D2-O1-R2" ), :Name( "L1-D2-O1-R3" ), :Name( "L1-D2-O2-R1" ), :Name( "L1-D2-O2-R2" ), :Name( "L1-D2-O2-R3" ), :Name( "L2-D3-O1-R1" ), :Name( "L2-D3-O1-R2" ), :Name( "L2-D3-O1-R3" ), :Name( "L2-D3-O2-R1" ), :Name( "L2-D3-O2-R2" ), :Name( "L2-D3-O2-R3" ), :Name( "L2-D4-O1-R1" ), :Name( "L2-D4-O1-R2" ), :Name( "L2-D4-O1-R3" ), :Name( "L2-D4-O2-R1" ), :Name( "L2-D4-O2-R2" ), :Name( "L2-D4-O2-R3" )   ), And this: dt2 = dta << stack(column(column("L1-D1-O1-R1"), column("L1-D1-O1-R2"), column("L1-D1-O1-R3"), column("L1-D1-O2-R1"), column("L1-D1-O2-R2"), column("L1-D1-O2-R3"),column("L1-D2-O1-R1"),column("L1-D2-O1-R2"), column("L1-D2-O1-R3"), column("L1-D2-O2-R1"), column("L1-D2-O2-R2"), column("L1-D2-O2-R3"), /// column("L2-D3-O1-R1"), column("L2-D3-O1-R2"), column("L2-D3-O1-R3"), column("L2-D3-O2-R1"), column("L2-D3-O2-R2"), column("L2-D3-O2-R3"),column("L2-D4-O1-R1"), column("L2-D4-O1-R2"), column("L2-D4-O1-R3"), column("L2-D4-O2-R1"),column("L2-D4-O2-R2", column("L2-D4-O2-R3")), Source Label Column( "Op_Rep" ), Stacked Data Column( "titer" ))   ); Cant get either of them to work, any ideas????     Thanks Mick   ... View more

Hi All,   l am importing excel spreadsheets into JMP using file open,  in excel the date is in Australian format of DD/MM/YYYY, JMP will only import when the date can also be interpreted as   American date format, for example, it will import 08/02/2018 as it could be 08/02/2018 or 02/08/2018, but it will not import 26/03/2018, which can be only 26/03/2018, i have tried changing the format in excel to a fixed date format (not sensitive to local settings), but this hasnt worked, does anyone else have any ideas??? ... View more