PDA

View Full Version : Step by Step Tutorial: Plot your DeviceLink data in EXCEL



AKA_TAGERT
02-06-2006, 08:46 AM
http://www.geocities.com/grantsenn/tutorials/excel/trendline/step01.JPG

http://www.geocities.com/grantsenn/tutorials/excel/trendline/step02.JPG

http://www.geocities.com/grantsenn/tutorials/excel/trendline/step03.JPG

http://www.geocities.com/grantsenn/tutorials/excel/trendline/step04.JPG

http://www.geocities.com/grantsenn/tutorials/excel/trendline/step05.JPG

http://www.geocities.com/grantsenn/tutorials/excel/trendline/step06.JPG

http://www.geocities.com/grantsenn/tutorials/excel/trendline/step07.JPG

http://www.geocities.com/grantsenn/tutorials/excel/trendline/step08.JPG

http://www.geocities.com/grantsenn/tutorials/excel/trendline/step09.JPG

stathem
02-06-2006, 08:51 AM
Target, that's fantastic. I was thinking of PMing you to ask the same...I guess you're going to be v.busy the next few weeks so it would be great if some of the rest of us could use your methods.

One other thing - I'm pretty proficient with excel, but can you bump the DeviceLink thread since I have no experience of using that to get the data in the first instance (ie and does that thread contain the info.to get it up and running?)

WOLFMondo
02-06-2006, 08:54 AM
Thanks Tagert..just after I spent the weekend looking at how to do this! http://forums.ubi.com/images/smilies/35.gif

AKA_TAGERT
02-06-2006, 08:58 AM
Originally posted by stathem:
Target, that's fantastic. I was thinking of PMing you to ask the same...I guess you're going to be v.busy the next few weeks so it would be great if some of the rest of us could use your methods.

One other thing - I'm pretty proficient with excel, but can you bump the DeviceLink thread since I have no experience of using that to get the data in the first instance (ie and does that thread contain the info.to get it up and running?) Your Welcome!

As for DeviceLink, there are TWO programs to choose from

UDPSpeed
UDPGraph

Here is a link that explains both

http://forums.ubi.com/eve/forums/a/tpc/f/49310655/m/7201027043

Personally I use UDPGraph while flying the actual mission in that it can GRAPH variables in real time while your flying, comes in very handy! UPDSpeed is more for displaying guages and stuff, not real useful for testings. Both can be set up to collect data to a log file. Once you get it to that log file you can put it into excel.

Allways include the time variable, because you can not depend on these progrmas to read exactally at 1ms intervals or what ever interval you set it up to read at.

stathem
02-06-2006, 09:00 AM
Superb, thanks. I'll try to get on to setting up and getting used to it.

Mondo, http://forums.ubi.com/images/smilies/25.gif