|
|
|
 |

February 21st, 2008, 12:22 PM
|
 |
General
|
|
Join Date: Feb 2007
Location: R'lyeh
Posts: 3,861
Thanks: 144
Thanked 403 Times in 176 Posts
|
|
Static values?
Could you produce versions with static values instead of the formulas from the DB files you have? Because it does take lots of time to open the DB even on most recent computer hardware. I think most of that time is for replacing all those formulas with their respective values and could be shortened a lot for people who don't want to change the spreadsheet, just view it.
|

February 21st, 2008, 12:43 PM
|
 |
General
|
|
Join Date: Mar 2007
Location: Japan
Posts: 3,691
Thanks: 269
Thanked 397 Times in 200 Posts
|
|
Re: Static values?
lch, you could also do this yourself by just saving the page you want as a .csv in OpenOffice. So you end up with a directory with a bunch of .csv's, and just open the one you want, for example units (example attached).
There may even be an easier way to do this, but I'm unfortunately lazy, so once I find something that works without much too much trouble, my motivation to find a better solution evaporates.
__________________
Whether he submitted the post, or whether he did not, made no difference. The Thought Police would get him just the same. He had committed— would still have committed, even if he had never set pen to paper— the essential crime that contained all others in itself. Thoughtcrime, they called it. Thoughtcrime was not a thing that could be concealed forever.
http://z7.invisionfree.com/Dom3mods/index.php?
|

February 21st, 2008, 01:02 PM
|
 |
National Security Advisor
|
|
Join Date: Oct 2003
Location: Helsinki, Finland
Posts: 5,425
Thanks: 174
Thanked 695 Times in 267 Posts
|
|
Re: Static values?
Yes, I can do that, Ich.
It's probably a good idea to include a static version for reference and leave a the full DB in case someone wants to copy it and use it as a base for a mod project where a lot of things are changed. That way if someone wants to do a CBM DB for example, they just copy the full DB under a different name and change the values that the mod changes.
Making the static version will be easy, since all it requires is copying everything in a page and then Paste-specialing only its values on anotehr page, that'll get rid of the formulas and the time needed for calculation.
It's also confirmed that there will NOT be a 3.14 version of the DB, but a version for the next patch, since I don't like doing duplicate efforts.
|

February 21st, 2008, 07:27 PM
|
 |
General
|
|
Join Date: Mar 2007
Location: Japan
Posts: 3,691
Thanks: 269
Thanked 397 Times in 200 Posts
|
|
Re: Static values?
Quote:
Edi said:
Yes, I can do that, Ich.
...
Making the static version will be easy, since all it requires is copying everything in a page and then Paste-specialing only its values on anotehr page, that'll get rid of the formulas and the time needed for calculation.
...
|
Cool, thanks! That's easier than my clunky .csv export 
__________________
Whether he submitted the post, or whether he did not, made no difference. The Thought Police would get him just the same. He had committed— would still have committed, even if he had never set pen to paper— the essential crime that contained all others in itself. Thoughtcrime, they called it. Thoughtcrime was not a thing that could be concealed forever.
http://z7.invisionfree.com/Dom3mods/index.php?
|
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
|
|
|
|
|