I'm trying to create a simple, or 3D, stratigraphic cross-section using an excel spread sheet I wrote up from well-log data. I've tried doing this a painful number of ways, and I'm fairly unfamiliar with RockWare. What I've tried so far: exporting the data as a CSV, and then opening it in the utilities window, checking it over, and then transferring to borehole manager.. The data shows up and even my stratigraphy is all there, I've filled out the stratigraphy types column, but when I go to actually model the boreholes I get the error that one of my stratigraphy layers can't be created (seems to change which one whenever I try; my grass layer, sand layer, or asphalt). I also get the error that I the model needs at least 3 points, or 2 points. I checked the forums and apparently this may have to do with the CRS assigned, but I've checked the CRS and it's all the same: UTM Nad 83.
I've also tried uploading right into the borehole manager with a number of different excel file types to arrive at the same errors. It mentions I should re-order my stratigraphy, but I don't understand that as some of the strata occurs in reverse order in some boreholes and not others, I don't see how I could possibly assign them an order, unless it was per borehole?.
I've also tried exporting a document to Excel from the borehole manager to examine the structure of spreadsheet it wants, I then filled out that spreadsheet with my data and imported it back into RockWare.. and arrive at the same errors.
Not sure what's going on!
attached is my data, in plain old xlsx format.
also attached is the data in the exported format from RockWare.
I did fiddle around with these spreadsheets to try to meet RockWare's error demands, but their both very simply laid out!
It seems I have all the pieces in RockWare but I guess I'm missing something.
Any help would be greatly appreciated!
cross section data rockware.xlsx
exported cross section data.xlsx