expert Mathcad consultant out there?

[MA_4143836]

I need to hire a consultant to help set up a spreadsheet to  parse and analyze arrays of data. Any  ideas who  is out there?

[StuartBruff]

There are several people on this forum who could possibly do what you want.  However, I think you might need to provide more information about your problem to narrow down the required skill sets.  For example,

When you say ”spreadsheet”, do you mean an Excel-type spreadsheet, or perhaps a Mathcad worksheet (big difference)?

What form does the data take?

What kind of analyses do you need?

How large are the arrays?

Stuart

[MA_4143836]

I have an embedded excel spreadsheet with oscillating data.

I need to extract the positive and negative chunks, and then, integrate those. I used the filter function in excel to do that. I need an expert to look at what I did in excel, what I did in Matchcad, check it for me, and, maybe see if the filter function can be programmed into Matchcad. I also need to find mins and maxes of the data.

I also need to sum , not just integrate the data, and could not for the life of me find the sum function in Matchcad.

Another way I could chop this data is to extract it in 15 minute time segments.

Whatever, it is difficult for me and I need help!

[StuartBruff]

Hi Matt,

That sounds eminently doable.  I see Terry has replied; your task should be well within his capabilities.  

I’ve only got Mathcad Express, which should be sufficient for the task, but a full Mathcad Prime would make the task easier as it has programming.

Stuart

PS. The Summation operator is available via the Operator tab on the Home tab or the keyboard shortcut ctrl-shift-S. 

https://support.ptc.com/help/mathcad/r11.0/en/#page/PTC_Mathcad_Help/summation_operator.html%23wwID0EJMPR  

https://support.ptc.com/help/mathcad/r11.0/en/#page/PTC_Mathcad_Help/keyboard_shortcuts_for_calculus_operators.html%23wwID0E5SJR

[MA_4143836]

Both of you are awesome. I will reply to Stuart in a day or two. Thanks! And happy holidays

Marc

[terryhendicott]

Hi,

I'll give it a try.

[MA_4143836]

How may I contact you? Can you provide email

Best

Marc

[StuartBruff]

Hi Matt

You can use the Community’s Private Message facility.  Just click on my name at the top of the message.

Cheers,

Stuart