@jitterboogie i just read last night about layers and layer groups I think the layer group and layers will help me keep the screen clean
@christ-lambrecht that is awesome. I was just playing with that. So i can sort and select and then copy or export. One step missing is a way to duplicate them in the workflow with new numbers or name and transform the elevation all in a sequence. ?ÿI might have to export then bring back in and do it who knows. ?ÿMany good ways. All the steps are there except doing the rename/raise elevation all at same time add new code and attach to new layer. ?ÿIts all there just a few quick steps to easily make it all stay in my project.
@rover83?ÿ
that's disheartening to read from you. That must be a very frustrating situation for you to mention it in the context of Dimensions too.?ÿ If crotchety old crusty surveyors don't want to adopt better tech then let's just roll over them and keep going.
and free ourselves from the money pinching engineering types that control our boards too much too....
THRAC OVER
?ÿ
?ÿ
@rover83 We either work for technology or make technology work for us. ?ÿWhen I see 100k of surveying equipment the latest and greatest no matter what brand and it is used like itbwas from the 90??s. It saddens me. I spent 1 hour twice this week overhead teaching a crew chief a few new tricks and ideas in what to watch for on a different job. I made him learn to inverse by non data collector so he knows. I try and do this every week a little old school and new way. I don??t want them to just push a button but to know what the button is doing. And to feel comfortable enough to ck it long hand when something doesn??t feel right .
You can just dump points into a spreadsheet and us the IF command to create an output file. It all you are doing is comparing the same point over and over...
Set Sheet 1 as master and seperate tabs for each day.?ÿ You can automate export reporting with pivot tables.?ÿ
@stlsurveyor yeah. We are not really staking points we are staking specific points to asbuilt. Then we take the as built physical elevation and raise it and then when that layer is reasonably stake the new point and asbuilt and then take new elevation and raise it. What i have been doing is the points and just use excel to compute the new elevation and assign a new point number. All the functions in TBC will do what i want to keep all the data in the project. It just has a few missing steps to keep the new comps from messing up the raw data which is still in there. I can copy point and then raise the elevation. I can transform the points to raise elevation but it keeps same point number. Whatbi need is to raise elevation and assign new point number in as few steps as possible. So i can keep everything in my project and manage each portion of the layers in near real-time. I am trying to cut out extra steps in excel. I want to update the different csv files for my field crews ?ÿas quickly as possible so i can work other projects. It??s just about shaving minutes off because this is being done several times a day a few points here few points there all at different layers on the ground. I could literally comp 4 points for one layer and 500 for another. In the field i did this myself. But they want it to be done on office side. So a file is sent job file. I bring in export what is needed and do it in excel.
@olemanriver That workflow can still be done in Excel.?ÿ IF X equals less that "Y" then add, etc. export to new sheet.?ÿ?ÿ
What you are doing in TBC is fine.?ÿ But sounds to me the workflow of layers, and multi-steps is slowing you down.?ÿ
Reduce to the basic operation.?ÿ If X is less or more than Y, add to X, export.?ÿ This is just a single column operation.
@stlsurveyor yes sir excel is fine. And it works. Easily. It just keeps many excel files going the file computations are in and the new excel file for using in field. If computation is in the csv file it blows civil3d up so it has to be a dummy csv file. I don??t know how access would handle formulas in a csv file. It might not recognize them. But i have to keep the computation sheet for checks and changes data trace ability. Which is exactly what i am doing. But it is so easy to select points in TBC by query and assign to a layer. And right now i have upwards of 10 field raw files per day from 1 to 5 crews all working and if i can keep all in one tbc project i can eliminate some headache for field crews and not have to have but one daily file with all work and manage the data in a way i have all in one place for changes and such. And comps. Tbc does the comps very easily as well. Selection of what data gets done is easy. Its just tying and retaining all original data and comping the new points elevation wise with a new way to rename and add elevation and create the new point groups. ?ÿ This will be a time saver if i can figure it out as we also use the new Trimble sync connect thing as any crew for any portion will all see the same data at same time even when say crew A gets some part done and crew B can now go right behind crew A and use the adjusted data points file to do that portion. It is a lot more going on than just the elevation change on the site all the time. We are basically doing inventory of materials at same time as well. I would prefer to bring in less than half of the daily job files i am now all in one tbc project and do qa/qc of instrument heights rod heights check the grades on whatever layer shoot out that report to client as staked report custom made for his purposes. Then do my comps send tgat to project folder so crews can re sync and have lates csv files for all material layers and updates to any changes that happens in near real time. I agree excel works but I literally have that project open 24/7 as i get calls from client and crews needing this or that. Having to go to one place is easy having to navigate to several different folders on a server is time consuming. The spreadsheets cause more time than not. I have been as i build the new all in one tbc project. Just reimport the latest csv file back to tbc. But this has been going on for years. A new phase is coming and if i can work out the kinks which i think a macro in tbc will solve it will save many steps. ?ÿCurrently it has been this. Bring in file export different points to different places do comps bring into civil3d do drawings do comps back to crew. Different daily tbc project.
@olemanriver I totally get what you are doing and the workflow will work. But all you are doing is, "...just tying and retaining all original data and comping the new points elevation wise with a new way to rename and add elevation and create the new point groups.
To me that says:?ÿ
1. Keep N,E the same
2. Determine Elevation change, add/subtract from proposed, update Z column, export
3. Add Subscript (to identify day) name to point number, export as .csv
It can all be done in one spreadsheet utilizing tabs.?ÿ If you are worried about formula, just paste "values", that strips formulas.?ÿ Using Excel can also track data per crew, reducing sub-layers.?ÿ
I am not trying to make more work or complicate things.?ÿ Just letting you know there is another way to skin the cat that may save you time.?ÿ The Visual/CAD data layer thingy can be updated while they are in the field, or with a bourbon in the other hand, but the number crunching can be automated.?ÿ Heck a little Python coding would make everything instant the second you type the "run" command.
?ÿ
@stlsurveyor yes i am using excel that way for sure. Thats how have been doing it pretty much . I am 100% with you. I am no slacker in excel. I even have it reach back and show what has and has not been shot. ?ÿI was just trying to keep it down to one platform is all. If i can eliminate civil3d and excel comps. I can use one software. Not that we would get rid of the others we will still use those. But in this case if i can figure it out it will be one platform totally. That any office in any state can open. No looking for last dwg in civil3d no computed points folders known raw points folders etc like Walmart use to be one stop shop. For this project. ?ÿNot all projects. Just this one. I will maybe have to keep doing excel. I have already adapted some to be more efficient than before I arrived here. I was just trying to eliminate a few extra steps is all. Right now if i were back at another place i would have my pythons guru set up the tml macro in tbc to do just that in house lol. And such. So i will have to re teach myself python and macros I reckon lol
I'm looking forward to the bourbon thing someday.
it's still useful for the field soreness and I pulled a Hammie the other day on black ice....only a knee down so pride intact.
????
@stlsurveyor i do have to fudge a little on N anE as some items and measurements error causes a little headache. Laying a plastic pipe on ground per plans is one thing. Cover it with a specific material and ist moved some. So i take the latest n and e and just keep coming up thats per client request. So the template gets replaced and the board keeps getting shorter and shorter lol. It does allow me to show the truth though. Yes i like your methods its just every click i can save adds up is all. And this is one of those projects that is easy it just time consuming. As you know a 15 second function cost more time as you have to get re focused on next project or task.
@jitterboogie LOL. ?ÿLast night i busted it getting out if my truck. I don??t know what happened I missed the step bar or something. Of course my 8 year old was right there. I started chunking gravel at her. ???? Then all i hear is daddy is a old crusty man that cannot walk anymore. I was letting tractor warm up the other day. Reading study materials in the truck. Tok my cheaters off and tried to step up on tractor and my eyes had not focused missed the step. Both daughters laughing at me. I want a bubble wrap all over so I don??t hurt no more lol.
