|
|
|
|
 |
December 8th, 2002, 08:12 PM
|
|
National Security Advisor
|
|
Join Date: Nov 2000
Posts: 5,085
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Re: Modding tools: Access vs. Excel
"I also went ahead and created an Excel macro that loads any SE4 data file into a spreadsheet, assuming that the spreadsheet has appropriate column headings (what would be the fields of the database - "Long Name", "Short Name", "Tonnage", etc.) for the data file being loaded. It works on CompEnhancement.txt quite nicely! Now to write the export macro, and create all the worksheets to store the data for all the various SE4 files..."
I haven't figured Excel out yet, but this sounds like it would be *really* useful. Would you mind posting it when you get it finished?
Phoenix-D
__________________
Phoenix-D
I am not senile. I just talk to myself because the rest of you don't provide adequate conversation.
- Digger
|
December 8th, 2002, 08:20 PM
|
 |
National Security Advisor
|
|
Join Date: Jan 2001
Location: Ohio
Posts: 8,450
Thanks: 0
Thanked 5 Times in 2 Posts
|
|
Re: Modding tools: Access vs. Excel
Yes please Gryhin, if it's not too much trouble. That does sound slick.
__________________
I used to be somebody but now I am somebody else
Who I'll be tomorrow is anybody's guess
|
December 8th, 2002, 10:35 PM
|
|
BANNED USER
|
|
Join Date: Nov 2001
Location: Near Boston, MA, USA
Posts: 2,471
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Re: Modding tools: Access vs. Excel
Ok, I'll try to clean it up by Jan 8, 03. It won't be a lot of troulbe, I just have to apply myself. It should only take about 4 Mid game SEIV turns. (that is how I measure time).
|
December 9th, 2002, 01:18 AM
|
 |
General
|
|
Join Date: Apr 2001
Location: Cincinnati, Ohio, USA
Posts: 4,547
Thanks: 1
Thanked 7 Times in 5 Posts
|
|
Re: Modding tools: Access vs. Excel
OK, here's the spreadsheet... currently I only have a worksheet for the weapon mounts, but if you change the column headings and the name of the file being read in the macro then you can read any SE4 data file...
www.geocities.com/edwardkolis/se4/SE4ModderWorkbook.zip (11 KB)
Don't forget to set cell A1 in the "Path" worksheet to the path of your data files, otherwise you'll probably get bunches of errors 
I'm probably going to rework this, though, since I realized it won't work for things like the weapon damages where there are really 20 entries in one, and the way I handled the "array" entries (like tech requirements and such) is not optimal - if there are more than 10 (or however many you make headings for) it just ignores the rest...
__________________
The Ed draws near! What dost thou deaux?
|
December 9th, 2002, 03:20 PM
|
 |
Lieutenant Colonel
|
|
Join Date: Jul 2001
Location: Orlando, FL
Posts: 1,259
Thanks: 0
Thanked 0 Times in 0 Posts
|
|
Re: Modding tools: Access vs. Excel
Don't forget about the optional lines in CompEnhancement.txt. It shouldn't be too hard to make allowances for them when reading/writing the file, though.
__________________
The Unpronounceable Krsqk
"Well, sir, at the moment my left processor doesn't know what my right is doing." - Freefall
|
December 17th, 2002, 09:01 PM
|
 |
General
|
|
Join Date: Nov 2000
Posts: 3,013
Thanks: 17
Thanked 25 Times in 22 Posts
|
|
Re: Modding tools: Access vs. Excel
Would it be possible to make this file available again?
|
December 17th, 2002, 11:50 PM
|
|
General
|
|
Join Date: Apr 2001
Location: Cincinnati, Ohio, USA
Posts: 4,547
Thanks: 1
Thanked 7 Times in 5 Posts
|
|
Re: Modding tools: Access vs. Excel
Oops, I forgot about Geocities' no remote linking rule... I'm trying to find another free hosting service, one where I can upload via FTP so I don't have to manually select every single file I upload...
Anyway, try this: www.geocities.com/edwardkolis/modder.htm
__________________
The Ed draws near! What dost thou deaux?
|
| Thread Tools |
|
|
| Display Modes |
 Hybrid Mode
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is On
|
|
|
|
|
