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.