AutoCAD Civil 3D :: Exporting Volume Dashboard Report From IE To Excel
Apr 9, 2013
Just trying to bring in a Volumes Dashboard report from IE10 to Excel 2010 (it all worked fine until I my PC was upgraded from IE9/Excel 2007)
When the report is in IE10, I Select All and paste to Excel (as I always have done) and the numbers are not recognised as numbers (there is no convert text to numbers prompt) and seem to have a leading space which Find/Replace can't find and replace.
If I right click in IE10 and Export to Excel, most of the exported data has a weird character preceding it (but which can be found and replaced). What this character is and how to stop it appearing?
IDSP Premium 2014 (mainly Civil 3D 2014 UKIE SP1 & Infraworks with some limited 3ds Max Design)
Win 7 Pro x64, 256Gb SSD, 300Gb 15,000 rpm HDD
16Gb Ram Intel Xeon CPU E5-1607 0 @ 3.00GHz (4 CPUs), ~3.0GHz
NVIDIA Quadro 4000, Dual 27" Monitor, Dell T3600
volume dashboard on which method of calculating is based. Why sometime are different, huge differences between counting volume based in "computer materials" which of 3 is the best? for calculating? I am using very often average end area, is that correct?
I have created surfaces for my original ground and my corridor. Both have appropriate boundaryies and the TIN looks good for both. I am trying to create a volume report through Volume Dashboard. I am able to create the volume surface with no issues but the numbers it comes up with do not seem correct. I can see from my profile that there is a small fill but the software seems to create a fill that is almost half of all the material when my profile shows there is more cut.
I tried creating a sample line group...it also shows the majority is cut. The only thing I can think is that there are about a dozen areas where my daylight does not work. how to do this volume correctly?
I am trying to get a material volume report for a corridor structure. The overall dirt cut fill is working, but the pavement and base keeps showing up as zero.
I started with the surfaces made, (perhaps that’s the problem,) I made an alignment, used an assembly, made a profile, and sample lines, made the corridor. The assembly draws in the cross sections, but the materials report shows zero in the pavement and stone.
I am having some issues getting a shared Volume parameter to work and report in a tag correctly. I can get the tag to report a value, but it is reporting the a value based on default values of the column (9*2*2) and not the value of the actual column (shown in the properites). Also, the tag I create reports a question mark, not the volume calculated. I've tried this a million times so it could be I have crossed up a parameter somewhere.
Is there a way I can sort the columns in the dashboard alphabetically? Normally you just click the title in these windows to toggle the way it sorts it, but you cannot do that with this tool. Its making my cut/fill report look messy, as the surface volumes are not in any order.
Whenever I open the Volumes Dashboard in a drawing and then close it, my cursor and my WCS compass start blinking erratically, and the program seems more apt to freeze up when I try to do other things from that point on, especially if I try to move to a drawing in another tab. If I bring back the volumes dashboard, it's fine again, but then I've got the annoying outlining of my volume surfaces that I don't want. how to handle this? Is it just an unavoidable glitch in the program?
I've read a few threads on this way back but cannot locate them. I have two surfaces and create a volume surface and it reported the volume as 493 cy. I then ran some sample lines at 25 foot interval and the total volume is reported as 964 cy.
I want to use it as my primary hydrologic and hydraulic modeler. It only makes sense. Well, I got the program to work and had things linked in and was able to route a storm through the network. But when I routed the storms, I had to model double the storage that i expected.
So I went back to the program I'm familiar with - Pondpack by Benltey - and designed the same system I routed in SSA in that program - and got the storage volume that I would expect for a site of this size - about 2 acres.
Is there possibly a setting that I'm missing that makes my outlet structures route slower or less than they should? Or is there some other reason that a system would give this kind of inflated need for storage?
I have an issue with using Bounded Volume or Adding a Boundary to Volume Surface things so bad... = incorrect volumes.. sometimes extremely incorrect.. I understand that the surface rectangle when a boundary is added but this could be horrible if not checked.
In a machine shop environment, the current practice is for an admin person to review the drawing, then take down all dimensions and enter them manually into Excel. Is there an easier way to export data to Excel so that I can have the dimension reports rather than doing them manually. The second question is on the ability to save the document as a .pdf, although I think this is possible.
I am trying to export a manually generated material list (not an AutoCAD "table") to an Excel spreadsheet or a .csv file. I've tried selecting the text and right clicking, but there is no export option. I've also tried selecting the text and going directly to Export, but I see no option to save it as a .csv.
I'm having an issue plotting or exporting a dwg to pdf. When I have a dwg with a linked excel table and want to plot a layout, everything plots except the excel table. I'm running LT 2012, windows 7 pro (64-bit). I send the same file over to a friend running LT 2011 an he adjust the viewport boundaries slightly and he encounters no problem either plotting or exporting to pdf. I've tried the same with no success. My Adobe Reader is up to date as well.
I am trying to export what looks like a table of text to Excel. The problem I have is the table is not an actual TABLE within AutoCAD but rather just columns of text with lines drawn around it. How I can grab this text and then put it into an Excel Spreadsheet.
I'm need to make a Map Check report on C3D2011, but I don't know how to do it. Since C3D everything have to be setup before it can be use, so my questions are: How do I setup map check? Or What do I need to do get map check report?
I import a survey data (X,Y,Z) in civil3D and make an horizontal alignment near them. I want reference theses survey points to my new alignment by a .txt report (#pts CH. OS elevation). Is it possible?
Setting up my first press parts list and already I'm regretting it...
How do we report material? Lower case letters spelling ductile iron is not acceptable in this office. How to I edit this to be 'DI' or anything else? I have looked in the press part catalog editor or whatever it's called and did not see a way to add to the list of all lower case materials.
Do I have to rely sole on part description for material in labels? ....and why do they still think that no one needs to use the " symbol with these parts? Freakin crashing all morning tring to get this going...
I copied the General Legal Description report and renamed it. When I ran the report, it asked me to save the file Civil.html before opening it. If I run the OOTB report it does not ask me to save the page before opening it. Is this something that I can fix? I have not found a setting anywhere that changes this.
Is there a way to included the radial bearings of curves for alignment reports generated for the report manager? I know the curves are tangent because I made them so, but the guy checking my report for errors doesn't know that. I don't know any xml.
First prize for me would be to be able to access Parcel boundary vertices via managed dot net.
I could not find the boundary property of the Parcel object.
It looks like developers can access Parcel vertices via COM, in the Loops property of Parcels.
So, it is possible to combine the two to get what I need.
Then I turned to the Report facility. The METESBOUND XSL iterates Parcel segments but provides the distance and bearing instead of the vertices. I was hoping to get to the bottom of the linked code to edit it and produce the vertices output. But - I failed again. Cannot see how the XSL files get to the data needed.
Is there maybe a book or comprehensive reference on the XSL files that provide the reporting function?