BookmarkSubscribeSubscribe to RSS Feed
0 Kudos

Import Excel Formulas

I'd love to be able to import an excel spreadsheet into JMP, including formulas.  For example, each row in Excel Column C contains the sum of the cells from the same row in Columns A & B.  Could JMP be made to recognize that this means to create a table with 3 columns, where the 3rd column contains a formula adding the first 2 columns?

 

Of course there would be limitations (how to handle Excel rows that are the sums of other rows? how to handle Excel columns that are functions of single cells? Etc.), but even if only my example above were possible, this would be a great help.

 

Tracking Number:

Defect ID: