(Posted on behalf of a user)
I have an Excel spreadsheet containing geotechnical boring information. I want to place several lines in succession, each having a specific color corresponding to the respective soil type. How can I do this without manually placing each line?
Try the following:
In Excel:
1. Arrange cells in the top row to contain all necessary components of the key-ins.
2. Copy this formatting to all rows below while preserving the given data.
3. Combine rows of cells into single cells.
4. Copy cells V1:V10 and paste the values only to cells W1:W10.
5. Copy cells W1:W10 from excel.
In NotePad:
6. Create a new TXT file.
7. Paste cells W1:W10 from excel into the TXT file.
8. Save.
In MicroStation:
9. Utilities > Batch Process
10. Click the icon "Add Files or Directories to Process" and select the file(s) you want to apply the TXT file to.
11. Click the icon "Browse for command file", locate and select the TXT file.
12. Select the model to apply the TXT file to, then click "Apply to Selection".
13. Click the icon "Process Batch Process Job".
14. In the "Files to Process" dialog, press "Process".
Note:
• The line weight value can be raised to display the different sections more clearly.
• The XLS, TXT and DGN files used in the example are attached for reference.
See Also:
Batch Process Utility
Batch Process Dialog
Using The Batch Process Utility In MicroStation V8 [CS]
How to string keyins together or create keyin scripts
Something neat to add to the end of script files
How to combine cells of information in Excel
Regards,
Craig Calvin
Bentley Technical Support
Depending on what information you have;
XY= works to give the initial location of the Boring X,Y,Z (Easting, Northing & Elevation (bottom/top of the hole)) From that initial point you may have just distances vertical and that would use the DX= or DL=,,value instead of XY.
DL or DX allow placement of points offset from the initial point by Dist X,Y,Z from the original point.
Either should work for top view. DL= follows the file coordinate system where DX= follows XYZ of view.
I Hope This Helps Someone Reading This! (Intergraph>PseudoStation>MicroStation user since 1980's)
In addition to Georges point
Repeating the coordinates is unnecessary because you can reference the data when you are doing the combine.
Why use a smart line and not a simple line, no reset or extra data point required.
I would probably format to place a rectangle or cylinder, depending on how the required output. Maybe even assign an element template to color and pattern based on the type of soil.
Thanks a lot Craig