Home
ExcelCalcs
Welcome, Guest
Please Login or Register.    Lost Password?
Animated Polar Vectors Linked to an incoming data stream (1 viewing) (1) Guest
If none of the forum headings seem to fit your question or comment then post it here.
Go to bottom Favoured: 0
TOPIC: Animated Polar Vectors Linked to an incoming data stream
#2941
rgleason (User)
Tadpole (Junior Boarder)
Posts: 2
graphgraph
User Offline Click here to see the profile of this user
Animated Polar Vectors Linked to an incoming data stream 4 Years, 4 Months ago Karma: 0  
I'm new to this forum. This is primarily a physics and math problem with programming skills needed.

1. First I'd like to create a static matrix with data input that uses trig to calculate 2 to three force vectors. These force vectors would be shown and added graphically to produce the resultant vector. Changing the data in the input matrix would change the vectors. I don't know the simplest and best way to handle the graphic transformations...

2. Then I would like to link the matrix input to an incoming data stream and put the vector graphs into "real time mode"

3. I have some VBA that would enable access to the incoming data stream, but it might be better to just handle that without that VBA, I don't know.

4. I'd start with some simple vectors and model that. Then try animating it by reading a file of real data. Then once I had the skills and techniques down, I would start developing the full application.

From what you know of excel is this a feasible project?
Do you think this forum and website would be of assistance?
Do you know of any similar examples that I could learn from?
Do you have any suggestions for me?

Thank you
Rick

PS: I currently have Excel 2003 and would like to stick to that unless there is a really good reason to upgrade.
 
Logged Logged  
 
Last Edit: 2012/10/22 03:28 By rgleason.
  The administrator has disabled public write access.
#2943
JohnDoyle[Admin] (Admin)
Mechanical Engineer.
Moderator
Posts: 1725
graph
User Online Now Click here to see the profile of this user
Gender: Male MoreVision Location: LEEDS, WEST YORKSHIRE, UK Birthdate: 1965-02-24
Re:Animated Polar Vectors Linked to an incoming data stream 4 Years, 4 Months ago Karma: 492  
Hi Rick welcome to the site. I have a few suggestions for you

1. First I'd like to create a static matrix with data input that uses trig to calculate 2 to three force vectors. These force vectors would be shown and added graphically to produce the resultant vector. Changing the data in the input matrix would change the vectors. I don't know the simplest and best way to handle the graphic transformations...
/xlc/xlc-help-and-tutorials/matrix-operations-in-excel/
/repository/maths/transformation-matrix.xls/
/repository/geometry/coordinates/equilibrium-of-three-forces-in-a-plane.xls/

2. Then I would like to link the matrix input to an incoming data stream and put the vector graphs into "real time mode"
I'm not sure what you mean by a data stream?

3. I have some VBA that would enable access to the incoming data stream, but it might be better to just handle that without that VBA, I don't know.
You'll probably find more help about VBA from other sites. Here we tend to specialise in using Excel to solve science and engineering problems. There is plenty of help out there.

4. I'd start with some simple vectors and model that. Then try animating it by reading a file of real data. Then once I had the skills and techniques down, I would start developing the full application.
Our XLC software has a handy animation button you can use see here /ExcelCalcsTV/videodirectlink/9-16-xlc-tutorial/

PS: I currently have Excel 2003 and would like to stick to that unless there is a really good reason to upgrade.
When Excel 2003 tries to access columns beyond the 256th rows it returns a #REF error provides a limitation to the size of matrix Excel can handle. This is no problem for Excel 2007 and 2010. So depending upon the size of problem you are trying to solve you may find you need to move from Excel 2003. I would give it a try fist though.

I hope this is helpful.
 
Logged Logged  
 
  The administrator has disabled public write access.
#2944
rgleason (User)
Tadpole (Junior Boarder)
Posts: 2
graphgraph
User Offline Click here to see the profile of this user
Re:Animated Polar Vectors Linked to an incoming data stream 4 Years, 4 Months ago Karma: 0  
Yes John, this is very helpful. In fact I had viewed the videos for some of these examples before, but it reinforced my understanding.

The data stream is an outside source of information in a standard format or protocol. It is serial with identifiers. This stream could be a real input with sensors or for testing purposes, a file that is read.(Actually after reading this, I realized that to start testing, I could simply put the data stream into a tab as an organized spreadsheet and run it from there for testing purposes. Then I'd have to sort out how to connect a real data stream from the instruments -Do you have any ideas about that?)

The animator button looks very useful, and would be a first step after the calculations are set up. What I am wondering, is if there is a function for the animator button that I could link to the incoming data? IE assigning certain values in the incoming stream to certain values in the animator? What I'd like to end up with is a set of 2D vectors + resulatant, calculated based on this input stream -Or is excel going to break??
Ideally I'd like to be able to offer this spreadsheet to others, so I am unsure about how the XLC part would affect that.

I suppose I should first start this in small steps and learn. Then adjust. I think I am going to try to create a spreadsheet calculation along these lines, for submission to you, but I am not so sure it will meet your high standards, but I'll try!

Best Regards
Rick
 
Logged Logged  
 
Last Edit: 2012/10/22 15:04 By rgleason.
  The administrator has disabled public write access.
#2945
JohnDoyle[Admin] (Admin)
Mechanical Engineer.
Moderator
Posts: 1725
graph
User Online Now Click here to see the profile of this user
Gender: Male MoreVision Location: LEEDS, WEST YORKSHIRE, UK Birthdate: 1965-02-24
Re:Animated Polar Vectors Linked to an incoming data stream 4 Years, 4 Months ago Karma: 492  
Rick

The data stream is an outside source of information in a standard format or protocol. It is serial with identifiers. This stream could be a real input with sensors or for testing purposes, a file that is read.(Actually after reading this, I realized that to start testing, I could simply put the data stream into a tab as an organized spreadsheet and run it from there for testing purposes. Then I'd have to sort out how to connect a real data stream from the instruments -Do you have any ideas about that?)
File reading is easily done with VBA and I'm sure there will be a way of getting Excel to talk to a device though I have no experience of this.

The animator button looks very useful, and would be a first step after the calculations are set up. What I am wondering, is if there is a function for the animator button that I could link to the incoming data? IE assigning certain values in the incoming stream to certain values in the animator? What I'd like to end up with is a set of 2D vectors + resulatant, calculated based on this input stream -Or is excel going to break??
Ideally I'd like to be able to offer this spreadsheet to others, so I am unsure about how the XLC part would affect that.

Again VBA will be the solution here. If you do use XLC to develop your program you can always remove XLC functionality at any time so that it is readable to a native Excel user.

I suppose I should first start this in small steps and learn. Then adjust. I think I am going to try to create a spreadsheet calculation along these lines, for submission to you, but I am not so sure it will meet your high standards, but I'll try!
The best part of running the site is seeing what other people do with Excel. Best to follow these guidelines then I'm sure you'll meet our standards

We are here to help so chat your idea through with us first before committing yourself to the work.
 
Logged Logged  
 
  The administrator has disabled public write access.
Go to top
We have 22 guests and 41 members online
Contact Us
post/email Email (preferred method of contact)
telephone US +1 617 5008224
telephone EU +44 113 8152220
Our Feeds
Repository RSS. Forum RSS. User Comment RSS. News RSS.