.com.unity Forums
  The Official e-Store of Shrapnel Games

This Month's Specials

Air Assault Task Force- Save $8.00
Bronze- Save $10.00

   







Go Back   .com.unity Forums > Shrapnel Community > Space Empires: IV & V

Reply
 
Thread Tools Display Modes
  #1  
Old December 2nd, 2002, 09:26 PM
zen.'s Avatar

zen. zen. is offline
Sergeant
 
Join Date: Jan 2001
Location: Northern Virginia, United States
Posts: 203
Thanks: 0
Thanked 0 Times in 0 Posts
zen. is on a distinguished road
Default Re: Modding tools: Access vs. Excel

I usually go with Excel. I know that Access can compile data into charts that will look like like a spreadsheet, but it might just be overkill. Then again, I suck at using Access.

Just use whatever is most comfortable. If you ever plan on releasing the code/database to the community, though, Excel is the more prevalent app.

zen
Reply With Quote
  #2  
Old December 3rd, 2002, 03:25 PM

Gryphin Gryphin is offline
BANNED USER
 
Join Date: Nov 2001
Location: Near Boston, MA, USA
Posts: 2,471
Thanks: 0
Thanked 0 Times in 0 Posts
Gryphin is on a distinguished road
Default Re: Modding tools: Access vs. Excel

I use Access to store notes on SEIV in general.
To take advantage of Excells Calculations and Acccess DB functions:
Do the data manipulation in Excel and link the file to Access.
I have not tryed this and do not know how well it would work.
I would be happy to work with you on this.
Reply With Quote
  #3  
Old December 8th, 2002, 05:19 AM
Ed Kolis's Avatar

Ed Kolis Ed Kolis is offline
General
 
Join Date: Apr 2001
Location: Cincinnati, Ohio, USA
Posts: 4,547
Thanks: 1
Thanked 7 Times in 5 Posts
Ed Kolis is on a distinguished road
Default Re: Modding tools: Access vs. Excel

Excellent idea!

I went ahead and ran a test to see whether if I linked an Excel spreadsheet into Access, and modified the data in Access, the spreadsheet would be changed, and indeed it was, which is good...

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...

Then, once that self-contained modding tool is complete, I can create an Access database linked to the spreadsheet for those of us who have Access as well as Excel - then we can REALLY rock!

Thanks for the idea of the spreadsheet/database link! I wouldn't have thought of using BOTH!

Edit: You use Access for "general notes" on SE4? How? Like notes on empires you encounter, so you can easily search for what you need?

[ December 08, 2002, 03:21: Message edited by: Ed Kolis ]
__________________
The Ed draws near! What dost thou deaux?
Reply With Quote
  #4  
Old December 9th, 2002, 02:59 AM

Gryphin Gryphin is offline
BANNED USER
 
Join Date: Nov 2001
Location: Near Boston, MA, USA
Posts: 2,471
Thanks: 0
Thanked 0 Times in 0 Posts
Gryphin is on a distinguished road
Default Re: Modding tools: Access vs. Excel

I use Access to store just about everything so I can look it up. I use Word for composing and then transfere it.
I am only in one PBW game. In my sew low games I try to be in the habbit of recording anything I will want to retrieve. This requires a lot of dicipline. Not my forte.
I have tryed to store "Tip, Tricks, and Traps" along with ideas for mods and such.
I try to dessige it so I can look up:
Strategy > Expansion > Build >
How To > Planet > Capture
How To > Drones > Use

I guess I could clean it up so others could use it. I'm pretty bad at getting projects done. Quite a few of my ideas don't work so it would be a use at your own risk thing.

My background is:
I do Desktop Support for about 120 people. I spent 2 years of my life supporting Word for Micro$ponge. I spent another year supporting various other MS products.
Reply With Quote
  #5  
Old December 8th, 2002, 08:12 PM

Phoenix-D Phoenix-D is offline
National Security Advisor
 
Join Date: Nov 2000
Posts: 5,085
Thanks: 0
Thanked 0 Times in 0 Posts
Phoenix-D is on a distinguished road
Default 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
Reply With Quote
  #6  
Old December 8th, 2002, 08:20 PM
geoschmo's Avatar

geoschmo geoschmo is offline
National Security Advisor
 
Join Date: Jan 2001
Location: Ohio
Posts: 8,450
Thanks: 0
Thanked 4 Times in 1 Post
geoschmo is on a distinguished road
Default 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
Reply With Quote
  #7  
Old December 8th, 2002, 10:35 PM

Gryphin Gryphin is offline
BANNED USER
 
Join Date: Nov 2001
Location: Near Boston, MA, USA
Posts: 2,471
Thanks: 0
Thanked 0 Times in 0 Posts
Gryphin is on a distinguished road
Default 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).
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On

Forum Jump


All times are GMT -4. The time now is 10:34 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©1999 - 2025, Shrapnel Games, Inc. - All Rights Reserved.