Skip to main content
S
snã¦ss8-Gravel
8-Gravel
October 8, 2015
Question

Excel file in Mathcad 14

  • October 8, 2015
  • 2 replies
  • 7041 views

Hi all!

I'm trying to embed an excel file in mathcad 14 using the    insert--> component--> excel file--> "create from file" (display as icon).

All I want is data from A1:A166053  (i know it is a lot of data ), this data represent the significant wave height since 1957.


After I "create from file" I select 0 input and 1 output and then define the range i need. When this is done the icon appers in mathcad and I define the 

name. In this case "Hs". Then the error message "The range value specified is invalid" appears...What am i missing??

Regards
Sigurd Næss

2 replies

L
LucMeekes23-Emerald IV
23-Emerald IV
October 8, 2015

What version of Office/Excel?

Note that Mathcad 14 is around for some time, and MS have changed Office significantly since then. Mathcad 14 may not know how to handle.

To be independent: Copy your one-column data to a Notepad file, save as .PRN file and use READPRN to read the data.

Then you can process.

Success!
Luc

L
LucMeekes23-Emerald IV
23-Emerald IV
October 8, 2015

The other way 'round is to make sure your excel data is saved as office 2003 or earlier...

S
snã¦ss8-GravelAuthor
8-Gravel
October 8, 2015

Thank you for the answer i will try this tomorrow.  I have office 2010,

Regards

Sigurd

S
snã¦ss8-GravelAuthor
8-Gravel
October 10, 2015

Hello again!

First! Thank you all for contributing to my question, things got a bit too advanced for me towards the end, but all is appreciated

I managed to import the data, I included a new column which represents the year the wave height was collected. Is there a way to find out the max value for each year, and have that returned in a nice table?

I tired a bit myself, extracting submatrix for a year and finding the max value for that submatrix. But I couldn't make Mathcad do all the steps from 1957-2014.

Hope I expressed myself correct and I appreciate all the help I can get

Regards

Sigurd

S
StuartBruff23-Emerald V
23-Emerald V
October 10, 2015

Sigurd Næss wrote:

Hello again!

First! Thank you all for contributing to my question, things got a bit too advanced for me towards the end, but all is appreciated

I managed to import the data, I included a new column which represents the year the wave height was collected. Is there a way to find out the max value for each year, and have that returned in a nice table?

I tired a bit myself, extracting submatrix for a year and finding the max value for that submatrix. But I couldn't make Mathcad do all the steps from 1957-2014.

Hope I expressed myself correct and I appreciate all the help I can get

Regards

Sigurd

Hi Sigurd,

Is this of any help?  There's another approach in the worksheet that uses a few of my utility functions to extract the data.

Could you please post the data file as well?  It will help verify the solution.  Thanks,

Stuart

S
snã¦ss8-GravelAuthor
8-Gravel
October 11, 2015

Wow! That looks great!

Sigurd

Terms & ConditionsCookie settingsAccessibility statement