topic Topic: Using JMP and Excel Together in Charlotte JMP Users Group https://community.jmp.com/t5/Charlotte-JMP-Users-Group/Topic-Using-JMP-and-Excel-Together/m-p/22244#M4 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333330154419px;">Charlotte, NC JMP Users Group meeting January 29, 2015</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">Topic: Using JMP and Excel Together: JMP Interacting with Excel Slide Deck</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">We had a great meeting, lots of discussion around tips and tricks for moving data between JMP and Excel. The case study where I took a collection of Excel forms and build something like a collection of relational database tables is included with this post. The script for extracting a range of cells from multiple tables along with a couple of example excel files to use as targets are in the zip file.</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">We also did a quick forward looking overview of the the JMP 12 Query Builder.&nbsp; This new feature generated a lot of interest and looks like it will have a high degree of utility for many of the members in the Charlotte JUG. At this link: <SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';"><A href="http://blogs.sas.com/content/jmp/tag/jmp-12-preview/" title="http://blogs.sas.com/content/jmp/tag/jmp-12-preview/">JMP 12 Preview - JMP Blog</A></SPAN> there are some descriptions of what's new in JMP 12.</P></BODY></HTML> Wed, 11 Feb 2015 17:11:04 GMT Byron_JMP 2015-02-11T17:11:04Z Topic: Using JMP and Excel Together https://community.jmp.com/t5/Charlotte-JMP-Users-Group/Topic-Using-JMP-and-Excel-Together/m-p/22244#M4 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333330154419px;">Charlotte, NC JMP Users Group meeting January 29, 2015</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">Topic: Using JMP and Excel Together: JMP Interacting with Excel Slide Deck</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">We had a great meeting, lots of discussion around tips and tricks for moving data between JMP and Excel. The case study where I took a collection of Excel forms and build something like a collection of relational database tables is included with this post. The script for extracting a range of cells from multiple tables along with a couple of example excel files to use as targets are in the zip file.</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">We also did a quick forward looking overview of the the JMP 12 Query Builder.&nbsp; This new feature generated a lot of interest and looks like it will have a high degree of utility for many of the members in the Charlotte JUG. At this link: <SPAN style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';"><A href="http://blogs.sas.com/content/jmp/tag/jmp-12-preview/" title="http://blogs.sas.com/content/jmp/tag/jmp-12-preview/">JMP 12 Preview - JMP Blog</A></SPAN> there are some descriptions of what's new in JMP 12.</P></BODY></HTML> Wed, 11 Feb 2015 17:11:04 GMT https://community.jmp.com/t5/Charlotte-JMP-Users-Group/Topic-Using-JMP-and-Excel-Together/m-p/22244#M4 Byron_JMP 2015-02-11T17:11:04Z