topic Re: expert Mathcad consultant out there? in Mathcad

expert Mathcad consultant out there?

MA_4143836 — Sat, 20 Dec 2025 22:50:01 GMT

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?

Re: expert Mathcad consultant out there?

StuartBruff — Sat, 20 Dec 2025 23:43:44 GMT

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

Re: expert Mathcad consultant out there?

terryhendicott — Sun, 21 Dec 2025 01:52:45 GMT

Hi,

I'll give it a try.

Re: expert Mathcad consultant out there?

MA_4143836 — Sun, 21 Dec 2025 02:28:28 GMT

How may I contact you? Can you provide email

Best

Marc

Re: expert Mathcad consultant out there?

MA_4143836 — Sun, 21 Dec 2025 02:30:28 GMT

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!

Re: expert Mathcad consultant out there?

StuartBruff — Sun, 21 Dec 2025 05:31:11 GMT

Hi Matt

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

Cheers,

Stuart

Re: expert Mathcad consultant out there?

StuartBruff — Sun, 21 Dec 2025 03:57:52 GMT

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

Re: expert Mathcad consultant out there?

MA_4143836 — Sun, 21 Dec 2025 04:40:28 GMT

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

Marc