Adept Scientific - English
The world's best software for research, science and engineering.
flag arrow
clearclear
 

 Adept Store | register Join My Adept | Flags  
Adept Scientific | Amor Way | Letchworth Garden City | Herts | SG6 1ZA | Tel: +44 (0)1462 480055  
UKusdedksvnofi
Home
Products
Training
Consultancy
 Buy Online
Downloads
Education
Support
My Adept
International |  About Us |  Contact Us |  Press Room |  Jobs


The Next Steps

• Ask us a question
• Buy Mathcad Now
• View Mathcad Pricing
• Request a Demo
• Download a Brochure
• Find out about Training
• Sign up for a Webinar
• Meet Our Team
• Read our RSS Feeds

Learn More

Mathcad Home
What can Mathcad do?
Version Comparison Chart
Mathcad for Education
Add-ons
Rave Reviews

System Requirements

Latest Information

New Features in Mathcad 14
Using Mathcad and Excel
Engineering Application
Packs

Return on Investment

Service & Support

Patches & Downloads
Chemical & Process
Engineering with Mathcad

Frequently Asked Questions
Search the Knowledge Base
Join the Discussion List
Search the List Archive
Mathcad Library

List Archives >  Mathcad List Archive >  Archive by date >  This Month By Date >  This Month By Topic

[mathcad] Re: Vlookup problem finding angle of maximum value of error vector

Search email archive for  

[mathcad] Re: Vlookup problem finding angle of maximum value of error vector
Author: Samir Khan    Posted: Mon, 15 Aug 2005 09:33:11 +0100





Bill,

It's picking out angle values within a certain tolerance. Reduce TOL to
about 10^(-7) and it'll only return one angle.

Samir




"Bill E Dumke"
<Bill.Dumke@nsigh
ttel.com> To
Mathcad Discussion List
08/08/2005 19:24 "mathcad"
cc

Please respond to Subject
"mathcad" [mathcad] Vlookup problem finding
ptscience.com angle of maximum value of error
vector










Having trouble finding the angle corresponding with the maximum value of
an error vector using vlookup. It returns multiple values even though
there is only one legitimate value. Tried "match", but got a similar
result.

Attached mathcad file is in Mathcad 11 format. Attached data file is a
tab delimited text file.

Bill

[mathcad] RE: Vlookup problem finding angle of maximum value of e rror vector
Author: Bruff, Stuart    Posted: Mon, 15 Aug 2005 11:49:50 +0100

Bill,

An automated version of Samir's suggestion, plus another possibility.

Stuart

From: Bill E Dumke "mailto:Bill.Dumke"
Sent: Monday, August 08, 2005 19:25
To: Mathcad Discussion List
Subject: [mathcad] Vlookup problem finding angle of maximum value of
error vector


*** WARNING ***

This mail has originated outside your organization,
either from an external partner or the Global Internet.

Keep this in mind if you answer this message.


Having trouble finding the angle corresponding with the maximum value of
an error vector using vlookup. It returns multiple values even though
there is only one legitimate value. Tried "match", but got a similar
result.

Attached mathcad file is in Mathcad 11 format. Attached data file is a
tab delimited text file.

Bill




********************************************************************
This email and any attachments are confidential to the intended
recipient and may also be privileged. If you are not the intended
recipient please delete it from your system and notify the sender.
You should not copy it or use it for any purpose nor disclose or
distribute its contents to any other person.
********************************************************************

 Attachments:
 vlookup problem 2.mcd


[mathcad] RE: Vlookup problem finding angle of maximum value of e rror vector
Author: Potter, Mick    Posted: Mon, 15 Aug 2005 14:41:31 +0100
Bill,

Another variation, implementing the desired 'vlookup' function without
changing TOL.

==
Mick

|From: Bruff, Stuart "mailto:stuart.bruff"
|Sent: 15 August 2005 11:50
|To: Mathcad Discussion List
|Subject: [mathcad] RE: Vlookup problem finding angle of maximum value of e
|rror vector
|
|
|Bill,
|
|An automated version of Samir's suggestion, plus another possibility.
|
|Stuart
|
|From: Bill E Dumke "mailto:Bill.Dumke"
|Sent: Monday, August 08, 2005 19:25
|To: Mathcad Discussion List
|Subject: [mathcad] Vlookup problem finding angle of maximum value of
|error vector
|
|
| *** WARNING ***
|
|This mail has originated outside your organization,
|either from an external partner or the Global Internet.
|
| Keep this in mind if you answer this message.
|
|
|Having trouble finding the angle corresponding with the maximum value of
|an error vector using vlookup. It returns multiple values even though
|there is only one legitimate value. Tried "match", but got a similar
|result.
|
|Attached mathcad file is in Mathcad 11 format. Attached data file is a
|tab delimited text file.
|
|Bill
|
|
|
|
|********************************************************************
|This email and any attachments are confidential to the intended
|recipient and may also be privileged. If you are not the intended
|recipient please delete it from your system and notify the sender.
|You should not copy it or use it for any purpose nor disclose or
|distribute its contents to any other person.
|********************************************************************
|
|______________________________________________________________________
|This email has been scanned by the MessageLabs Email Security System.
|For more information please visit http://www.messagelabs.com/email
|______________________________________________________________________



This e-mail plus any attachments is intended for the addressee only. The information may contain material that is confidential. If you are not the intended recipient, please notify the sender immediately and delete from any computer. Any review, disclosure, distribution, copying, use or other action in reliance on this information is prohibited.

E-mail transmission cannot be guaranteed to be secure or free from error as information can be intercepted, corrupted, lost, destroyed, arrive late or be incomplete. The sender does not therefore accept any responsibilty for errors or omissions in the content of this message.

________________________________________________________________
This message has been checked for all known viruses by the
MessageLabs Virus Control Centre. For further information visit
http://www.messagelabs.com/

 Attachments:
 vlookup problem 3.mcd


Previous by date: [mathcad] Re: Mathcad 11-12 compatibility, Zdenek Sedlacek
Next by date: [mathcad] RE: Vlookup problem finding angle of maximum value of e rror vector,  Bruff, Stuart
Previous thread: [mathcad] Vlookup problem finding angle of maximum value of error vector,  Bill E Dumke
Next thread: [mathcad] Re: Vlookup problem finding angle of maximum value of error vector, Samir Khan



Ready to buy?

For more pricing information:
Visit our webstore, call us on +1 800 724 8380 or email us at info@adeptscience.com

Featured Downloads

Mathcad 14 demo
Mathcad 14 Brochure
Mathcad or Excel?
Mathcad Customer Story: Man B&W Diesel
Mathcad Customer Story: Stork Fokker Aerospace
Mathcad White Paper - Moving beyond the limitations of spreadsheets

Product Reviews

"Our work ranges from complex medical imaging research to large-scale mapping and diagrams and we need a tool that is able to handle anything we investigate. With Mathcad, we are able to manipulate and analyse our data quickly while at the same time documenting our work, for sharing and publication. We also use it for pilot studies conducted in support of research grant applications. It is an end-to-end tool for research and development."
Dr. Kenneth Castleman, President of Advanced Digital Imaging Research (ADIR), Houston, Texas

"Mathcad is an integral product for my work... With Mathcad, itís easy to disseminate design calculations because the documents look like real math. Thereís very little I canít do in Mathcad. The main benefits come from the format, which resemble a typed set of calculations. These programs are easier to develop by engineers and easier for others to follow and review since the logic is expressed in a familiar manner. The format is what places Mathcad head and shoulders above other programs of a similar function."
Andre Pavlov, Structural Engineer, Florida Department of Transportation
adept

Top of the Page

Our Privacy and Terms and Conditions Statement
All Trademarks Recognised. Copyright © 2007, Adept Scientific plc.
Site designed and maintained by Adeptise

Adept Scientific | Amor Way | Letchworth Garden City | Herts | SG6 1ZA | Tel: +44 (0)1462 480055