Author: Mike Cline, T/X Resources
I was just notified that the instructions in the info page of the Culture Symbol Spreadsheet (posted on 02/08/08) were in error.
I had copied-and-pasted the intial text, for the info page, from another spreadsheet, and thought that I had made the appropriate changes. However, I may have uploaded the wrong version when I finished.
Sorry for any confusion, previously. I have corrected the version in the original posting, but here is the corrected Culture Symbol Spreadsheet, along with the ascii file that goes with it.
Copyright © T/X RESOURCES, 1995-2008. All Rights Reserved.
Mike,
Still unable to make this work. Here’s what happened.
1. No instructions for column B. Do I put text in there? This is what I assumed, so I did it.
2. Copied appropriate rows and columns into new spreadsheet.
3. When saving, I saw no specifically named “Text CSV” format, so I saved it as “CSV”. I didn’t see any option to select “Fixed Column Width” in the export process.
4. I didn’t understand your instructions 9-11. I couldn’t operate on the symbol ascii file - when I click the link I get an HTML version of the file and can’t save it as a .CUL file. But even if I could, is there a missing link? Don’t I need to paste the spreadsheet data into the CUL file? But I can’t do this because I can’t create the fixed column width format and I can’t create the CUL file in the first place.
5. So anyway, plunging ahead, when importing the CSV file I created in my #3 above, there were no fields for symbols or colors to select in SMT’s text importer - only text and X/Y locations. All I got was the well names posted at the right places.
Am I doing something wrong? I tried this on both WinXP and Mac OSX, same result.
Jerry,
Here’s the easy way:
1) Paste x locations into Column x, y locations into Column L. Use Paste Special (unformatted text).
2) Copy Row 4, Columns A-J (don’t include Columns K or L).
3) Paste into Row 5, to the last row of your xy data in Columns K and L.
4) Save spreadsheet as a text file.
5) Import new text file (named xxx.cul) into SMT as a Culture file.
That’s it!
Notes:
1) You don’t have to put anything into Column B.
2) Delete the first three lines of the cul text file in a text editor.
3) Your edited file should look like the ascii file that you can download from the blog posting.
4) This is for WinXP only. I don’t know if it works in Mac OSX.