Get Help

Turn on suggestions

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

- Community
- :
- PTC Mathcad
- :
- PTC Mathcad
- :
- Simple mathcad problem

Options

- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page

Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.

Showing results for

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

11-14-2014
10:57 AM

11-14-2014
10:57 AM

Simple mathcad problem

Hi all,

This should be a simple problem to solve for anyone with experience with Mathcad, I wish I had the patience to figure it out for myself, but I don't.

I have an asset list made up of thousands of item numbers and there associated item costs, from this list I have been given a selection of item numbers of which I would like to determine there costs.

Could anyone provide me with a programme where I can input the list item numbers and their costs will automatically be found, im sure similar questions have been asked, so possibly you could direct me to link.

Much appreciated,

James

Labels:

2 REPLIES 2

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

11-14-2014
12:34 PM

11-14-2014
12:34 PM

Re: Simple mathcad problem

This depends on the format of your data. If the data is inside Mathcad you could use one of the lookup functions.

Please post an example.

Highlighted
##

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Notify Moderator

11-14-2014
01:03 PM

11-14-2014
01:03 PM

Re: Simple mathcad problem

Agree with Mike. The lookup functions should do the job, I guess. Alas, we cannot be sure as long a we don't have a worksheet which shows the correct datastructure used, shows which version of Mathcad we are talking about, shows what exactly the output should be and shows the attempts you already made.

After all its a bit unclear what the function you are demanding should provide.

- input a single part number, output the appropriate cost value
- input a vector of part numbers, output a vector of the appropriate cost values
- input a vector of part numbers, output the total sum of costs.
- input a matrix of part numbers and number of items, output the total sum of costs.
- ....