Hey,
I am a college student and for a project i carried out a static survey with a Trimble R10, when it was completed i downloaded the data. The data was in .TO2 format. I wanted to carry out some statistical analysis on data but cant seem to open it in Excel, i don't know if it is even possible. I want to get the Standard Deviation of the data, any idea how i can access this data in Excel.
I did the survey on a point with known co-ordinates (Accuracy +/- 20mm) and carried out a network adjustment using CORS stations in Trimble Business Center to have an accuracy of (+/- 4mm), i used this as the true value. I also sent the RINEX data of this point into a PPP service (AUSPOS). I just wanted to carry Statistical Analysis on the data and compare the two results.
Cheers
There is nothing that you can do with a T02 file except process it; after processing the report will give you all the statistics, residuals for each satellite, etc. If you don't have any base data to process it against try using the Internet Download feature in TBC to download simultaneous observations from the nearest available CORS.
There are no point to point vectors in the .T02 file, only raw data from satellites. There may be a jxl file amongst your data, which might be more what you are looking for.
You can force the .t02 in TBC to become a continuous survey so if processed against a CORS each epoch will have a position. This function is nicely hidden but if you go to the project explorerimported filesxxxxx.t02point name then right click you get the properties option. In properties there is an icon to Force Continuous. Obviously you need a base with the same logging interval so internet download might help you there. Continuous processing in TBC can be set to do a trajectory or a vector to each epoch so that might be better. You can then export every epoch and do some analysis that way