Skip to main content
3-Newcomer
December 20, 2025
Question

expert Mathcad consultant out there?

  • December 20, 2025
  • 2 replies
  • 320 views

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?

2 replies

23-Emerald V
December 20, 2025

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

3-Newcomer
December 21, 2025
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!


23-Emerald V
December 21, 2025

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

 

21-Topaz II
December 21, 2025

 

Hi,

I'll give it a try.

 

3-Newcomer
December 21, 2025
How may I contact you? Can you provide email

Best
Marc

23-Emerald V
December 21, 2025

Hi Matt

 

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

 

Cheers,

 

Stuart