Jump to content
RockWare Support Forum
RockLover

What is the excel format needed for rockworks to register it?

Recommended Posts

Hello first time posting here sorry if my question or format is weird but here is my issue.

 

I have used the SampleProject excelt sheet provided by the RockWorks program to import borehole locations and various other data that it came with into RockWorks no problem. Its very nice that I am able to generate a Lithology 3d map and everything, Which is my main goal with my own data.

 

The problem I have is when I create an excel spread sheet in the same fashion as the SampleProject excel sheet given it doesnt register my Lithology values or anything other than the borehole data. I will upload the excel spreadsheet I have currently. I know by messing with it I probably altered something incorrect but if anyone has a specific format that exists for the program to read it that would be great! thank you

Brisben Site Data Site Interval Data B1 - B24.xlsx

Share this post


Link to post
Share on other sites

Hi RockLover,

 

RockWorks maps the columns in the Excel Lithology sheet to the Lithology table in RockWorks based on the column names. It can map the column named Lithology or Keyword automatically, but your Excel file has the column header named Simple Lithology, so it isn't imported.

 

Either rename the column header in your Excel sheet, or remap the columns in the Excel import dialog box. Select the Lithology table on the Block Selection tab of the import dialog box, and click the Show Block Mapping button to match the Simple Lithology column to the Keyword  field.

 

Regards,

Tom B

RockWare Inc

 

LithologyImportMapColumns.png

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×