About bfoulkes

bfoulkes · ‎03-12-2020

this script has been awesome to follow the progression and keep up on the impacted areas. thanks for showing us how to do this.

bfoulkes · ‎02-27-2020

In the RBD platform, there is a curve that is shown as the resulting distribution from the blocks that are entered. There is no way to get this curve, or an approximation of this curve, or even input different times to get the probabilities, except typing them manually, one by one. The results in this platform seem to be a series of profilers, but it would be nice to get the resulting distribution, even if it's just a table of times and probabilities. A similar issue is in the Repairable Systems Simulation (RSS) platform, where no resulting model is available as an output. This platform at least gives the output of events, so a distribution can be built from the event times.

bfoulkes · ‎02-18-2020

It would be helpful to be able to identify column types (numeric, character) or column format when importing Excel files. There can be some columns where you want to force them to character (i.e. serial numbers that begin with a 0) or a column which is a date time, and you want it to appear only as a date. These features are available for CSV files, but not Excel files, so it seems like something that could easily be applied.

bfoulkes · ‎01-24-2020

I did come upon this page that shows how to do it with JSL, https://www.jmp.com/support/help/14-2/associative-arrays-in-graph-theory.shtml

bfoulkes · ‎01-07-2020

This is also fantastic. I couldn't quite figure out how to grab the labels, but tossing them into a journal is brilliant. My actual dataset is over 2MM records and this goes 4X faster to complete. Thanks so much for sending this along.

bfoulkes · ‎01-06-2020

thanks Mark. I appreciate the quick response.

bfoulkes · ‎01-06-2020

I would like to script a row selection by the value labels in a column. As an example, the Big Class data set has a value label where F=Female and M=Male. As far I can tell, I cannot write JSL to do a column selection by "Female". Does anyone know how to do this in JSL? My bigger issue is that I have several values that have the same label, but instead of trying to select all of those values individually, I would like to just select the label.

bfoulkes · ‎12-02-2019

yes of course. You would just add them as subsequent groups. col cumulative sum(1, :Test, :OtherColumn, :AnotherColumn)

bfoulkes · ‎11-26-2019

Vaiju, i think you would just want col cumulative sum(1, :Test) which would give you a rolling count by the Test column, or you could swap out any column you want.

bfoulkes · ‎11-19-2019

there appears to be a few step process to complete this, where i would need to save the multiple phrases as phrases, then i can recode them once they are saved. This was not intuitive and it would still be good to be able the group phrases together.

bfoulkes · ‎11-16-2019

I want to be able to show the relationships between two groups of data. I have seen this as a Network Diagram or a Social Network plot, but JMP can't do this right now. There is an add-in that will create a plot that is not that interactive, but I would like this as a full plot, where items can be filtered and sizes don't need to be coded, so they can be changed on the fly. The add-in shows the use case as transactions from one group to another, but this could also be the flow of data from one group to another or a more general social network connections plot.

bfoulkes · ‎10-25-2019

When using Text Explorer, I would like to group similar phrases together. We can already recode terms, but that ability is not available for the phrases. An example would be to group "car battery" and "battery - car" together as similar phrases. This would be helpful for the later clustering analysis later.

bfoulkes · ‎10-08-2019

I like the Multiple File Import function, but when using excel spreadsheets, it would be nice to be able to select the worksheet that I want imported. It defaults to just the first sheet, which isn't always what I want. I currently use a script to select the appropriate worksheet in the file, so adding this feature to the Multiple File Import function would be nice.

bfoulkes · ‎09-30-2019

Depending on the format you're looking for, you can do a few things, I think. If you use the Selection tool in JMP, you should be able to grab the table you're looking for and paste just that, but it will paste it as a picture. I have also found that pasting things into Excel first, then into Word or Powerpoint made the data much easier to work with and kept it as a table.

bfoulkes · ‎09-27-2019

thank @markbailey That is what i ended up doing. I clear the log, then use get log() to grab the window and then cycle through to pull out the item with the term "convergence". I am hoping there is a more direct way to get it though.

bfoulkes · ‎09-26-2019

I frequently use the Minimize function in JSL to solve a non-linear equation and one thing i have noticed is that occasionally, the function may fail to reach convergence. Is there a way to get those results from the script? I am writing a script to solve the model for many different subsets of data and while I can get the parameters, minimized objective and number of iterations for each model that is solved, i don't know if it ended up on a result because it reached the max iterations, converged or failed to converge. Below is an example of the function and the results from a great post by Milo, from JMP. https://community.jmp.com/t5/JMPer-Cable/Minimize-and-Maximize-Functions-in-JSL/ba-p/36355 x = 0; y = 0; {objVal, iters, gradient, hessian} = Minimize( ((2 * x ^ 2 + 12 * x * y - y * 3)), {x( -1, 1 ), y( -1, 1 )}, <<maxIter( 200 ), <<tolerance( 10 ^ -6 ), <<ShowDetails( True ), //<<UseNumericDeriv( True ), /*rarely needed*/ //<<Gradient({4*x+12*y, 12*x-3}), /*rarely needed*/ //<<Hessian({{4,12},{0}}) /*rarely needed*/ ); Show( x, y, objVal, iters, gradient, hessian ); These details below are outputted into the log window, and i'd like to get the "Convergence SUCCESS" for the results of each model I run. Any suggestions would be appreciated. nParm=2 Newton ****************************************************** Iter nFree Objective RelGrad NormGrad2 Ridge nObj nGrad nHess Parm0 Parm1 0 2 0 0.125 0.5 0 1 1 1 0 0 1 1 -0.23568 29.52863 0.514107 2048 16 1 1 0.282987 -1 2 1 -1.92154 26.15693 0.310463 16 1 1 1 0.442808 -1 3 1 -6.6297 16.7406 0.002094 4 1 1 1 0.954236 -1 4 0 -7 . 0 1 1 1 1 1 -1 Convergence SUCCESS: Gradient Time: 0.0166666666627862 x = 1; y = -1; objVal = -7; iters = 4; gradient = [-8, 9]; hessian = [4 12, 12 0];

bfoulkes · ‎05-16-2019

Prior to JMP13, this post covered how to do a rolling sum. This post does not cover doing it by groups, but it's not too hard to extend the concept to that. https://community.jmp.com/t5/Discussions/how-to-get-cumulative-sum-data/td-p/6766

bfoulkes · ‎04-04-2019

Congratulations Julian! Hopefully you'll consider presenting this at the US Discovery Summit later this year.

bfoulkes · ‎03-26-2019

You could also replace the "For each row" section with a line to count the number of rows for each column. This would utilize the datatable functions instead of needing to look through each row of each column. COUNT_VAL=NROWS((DT<<SELECT WHERE(column(dt, Numeric Columns[i])[]<101))<<GET SELECTED ROWS);

bfoulkes · ‎02-01-2018

Predicting the NBA The task: Using the stats from 2012 through 2017, predict how the 2018 season will finish out. Any and all modeling methods can be used, but the final solutions must perform the best on the 2018 season. Data is provided from the website, https://basketball.realgm.com/nba/stats and is broken into three areas… Team Standings Team Stats Player Stats Those three tables are included, as well as a JSL script to download the data yourself. Additionally, there is an FAQ list included in the Word Document. The questions to answer are the following… Closest Order of Final Team Standings, as ranked by percentage of wins, by the end of the 2018 regular season, with a tie breaker being the closest to having the correct winning percentages. Closest Order of Final Player Standings, as ranked by average points per game, by the end of 2018 regular season, with a tie breaker being the closest to having the correct PPG values Best Visualization created with the data, voted on by the User Group community at the meeting. If you aren’t a data junky, this is your chance to shine. What is the neatest, coolest, most interesting graph/chart/etc. that you can come up with? The Scope and Rules Teams of 1-3 people. To sign up, go to this link, https://www.surveymonkey.com/r/HYRGQM9. Build 1 or 2 models to predict the above questions. Models must be able to run live, during a JMP User Group meeting. Provide a visualization that can be created during the meeting, and will be voted on during the meeting. At least one member of each team must be present to win. Register your team by April 28th. Solutions will be presented and winners will be announced at the Summer Upstate JMP User Group (typically in June) Solutions can be in the form of a JMP script, a data table, a JMP Journal, or other JMP data type that will be available to run during the meeting. If you have any questions, feel free to post them here, or message me directly. Brad Foulkes

bfoulkes · ‎01-29-2018

When creating a journal, if a text box is added in, then there is only one font that can be chosen for that series of text. It would be helpful to be able to change the font in that text box for different parts of the text. Being able to underline or bold words can help drawing emphasis and attention to different things.

bfoulkes · ‎01-17-2018

When I run the Life Distribution platform and create a model, there is an option to do a custom estimation. It would be good to have an opportunity to do a conditional probability calculation, in that the item has already run to time X and what is the likelihood of surviving to time Y? This would require one more input, maybe called "starting point" or something along those lines.

bfoulkes · ‎01-17-2018

I will occasionally have a distribution with zero's in there and when I try using the Distribution platform, I get a much smaller list of possible distributions to fit than normally. I then can go into Life Distribution and look at a ZI Lognormal or ZI Weibull, but why not offer these in the Distribution platform?

bfoulkes · ‎11-27-2017

Hi Erin, it was good to meet you at the last Discovery conference. I think starting this back up would be good. 0 I am a JMP user who works deeply across the Analysis platform, from simple models to more complex predictive modeling, as well as doing a lot of scripting to make jobs easier for other folks. Really, i do a little bit of everything. 1 frequency of meetings - I think quarterly has worked well in other groups i've been a part of, and it doesn't seem to overwhelm presenters in terms of coming up with topics. Monthly may be ok if the meetings are shorter, like an hour long, but unless there is an abundance of topics, there could be some sparse months. 2 predictive models and lessons learned; creating visualizations (like the "Pictures from the Gallery" Discover pitch); 3 In another group i'm in, we've done a "data deep dive" where there is a facilitator, but it's more up to the group as to how the data gets analyzed. The facilitator may have things they want to look at, but it ends up being more free form as other questions come up. I don't know if this would work in a virtual setting. Another idea would be to highlight some interesting questions from the JMP community boards. If there are things that someone found that the solution was quite novel or particularly helpful, then that could be good to share. 4 Building models, from linear regression, to life distribution, to gen reg type models; connecting JMP to different data sources

bfoulkes · ‎11-09-2017

Thank you to Steve Figard and Hyde Miller for presenting at today's meeting. I think these were two very informative talks about using JMP and statistics. Steve Figard presenting on "How can I compare thee, when to use the right comparison test", where he provided a nice guide for which tests he uses in his classes. Hyde Miller from JMP, discussed the highlights from the JMP Discovery Summit, including a talk on "Ghost Data", where the data isn't really these, but you're still able to build models. Both were great presentations. The next meeting will be on February 1, 2018, at the Pelham Medical Center. The topics are tbd, but if you have suggestions, please post them here.

bfoulkes · ‎10-31-2017

The topics will be "How do i compare thee? Knowing which comparison test to use when" by Steve Figard and "Discover JMP Discovery Summit" by Hyde Miller.

bfoulkes · ‎08-25-2017

Thank you to everyone who came out to the August meeting of the Upstate JMP Users Group. Attached is the JMP Journal with the agenda and links to help files and the JMP Journal on playing with fitness data in JMP. The next meeting will be November 9th, from 9-12 at the Pelham Medical Center. The topics will be "How do i compare thee? Knowing which comparison test to use when" by Steve Figard and "Discover JMP Discovery Summit" by Hyde Miller.

bfoulkes · ‎05-17-2017

A question about creating a pie chart with two labels came up in the most recent JMP user group meeting. Scott Wise from JMP provided a solution for this in a step by step example, as shown in the attached document.

bfoulkes · ‎05-11-2017

On May 11, 2017, we had our spring Upstate User Group meeting. Thank you to Veera Kullatham for presenting on using Big Data to drive business decisions and to Richard Riddlehuber for discussing process capability. Attached is the JMP journal from the meeting. The next meeting is tentatively scheduled for August 24th where Alicia Thompson will present on a Pharmaceutical Deep Dive and Brad Foulkes will present on Getting Running/Biking/GPS Data into JMP and seeing some neat things.

bfoulkes · ‎02-09-2017

Attached is the JMP journal from the meeting on February 9th. At the meeting, we had two great presenters, Steve Figard and Byron Wingerd. Steve presented on "Getting started when you have a dataset" and Byron presented on "Graph Builder, bubble plots and more". Their datasets and examples will be uploaded here soon. It was also mentioned there would be an upcoming event in Greenville on Building Better Models, on March 9th, from 9-12. If you are interested, please register at the link below. Link to Register The next Upstate User Group meeting will be May 11th, from 9-12 at the Pelham Medical center. Please keep an eye out for the registration link. Brad Foulkes

Date Registered	‎10-08-2014 10:09 AM
Date Last Visited	Monday
Total Messages Posted	54
Total Kudos Received	37

Online Status	Offline
Date Last Visited	Monday