Last year, one of the CORS sites that I administer appeared to flake out. In the process of figuring out what was up (a very long story,) I ended up generating over 500 24-hour occupation OPUS Solutions for the site, some going back to 2008.
I needed some way to take a folder of Outlook .MSG files and regular .TXT files, read them all, parse out the results, change the Lat/Lon values to decimal degrees (so I could average and plot them) sort the occupations by start time and then make a file I could open in EXCEL and futz around with.
It was way too much to copy/paste and it has been a frequent issue for me so I built a tool. The tool has been in use by a couple of friends for the past year and I figured it might be of some real value to others. Recently I added a summary for the numeric columns that tabulates the Min, Max, Range, Average and Population Standard Deviation adding them to the column bottoms. You can see a screen shot of the results [ here ]
My tool is called the 'OPUS Accumulator', it is free and anyone is welcome to use, distribute or share it. No strings, no nothing. (You can even have a copy of the source code if you need it.)
You don't need to install it as it is a single code-signed windows .EXE with no helper files. I put it on the web in a .ZIP file. If you have any use for it you can grab a copy from [ here ]. I also put a ZIP file at that location that has 500+ files that you can extract into a folder and play with.
I suspect that only a few folks would ever need it, but if you need it you probably really-really need it.
Thanks to all,
Mark
G, be careful. I had a $1,000+ bar bill at the last training in Florida that I attended. It was not a pretty site here at the office when I tendered my receipts. I think I would have topped that at the Carlson User's Conference except Bob LeMoine from Hemisphere picked up the first three or four Kentucky Bourbons. (He is a great, great man!)
If you find any files that it won't read, send them to me and I will get it fixed.
I've recently used this tool for a couple RTK Network CORS sites I've setup... this tool saved me over 2 hours of work on just 3 reference stations, have 70 more sites to go so all I can say is a big THANKS to Mark!