-
Carlson to Trimble xlsx
Today I spent my time writing an xlsx that intakes a Carlson GPS rw5 file and splits it up into its parts. The idea being I would re-configure and save as a Trimble .dc file. One sheet is the Carlson information, one sheet does all of the conversions I need done and the other sheet (the one to save) is in xls version of .dc format. My problem is that I see no way to achieve the very strict space delimited format that Trimble requires from Excel. Hopefully one of the Excel guru’s will know how to do that. I am mapping the .dc sheet into xml, so, I can get it done. It would just be easier if Excel could do it.
I have been using an early version of this sheet to do more of a manual convert right now. It works fine, but, just too much hands on for me. I added a feature for when the crews grab a VRS base that is way to far to work from and re-calculate the vectors from a more ideal base. The picture below is a screen shot of a collection done from SAMM3 that should have been collected from ENUM3 and I re-wrote it that way. I always throw in a sanity check back to the original base as is pictured. Never thought I would use it much, but, with the worry of plate movement, it allows me to move any VRS collection to the same base (if it existed at the same time). I have VRS vectors back to 2003 and haven’t yet tried older RTK onto a VRS base, but, I have thought of it. I can’t get rid of velocity this way, just minimize it
Log in to reply.