the Phrozen Forums
  General Mod Making
  Is there an easier way . . .

Post New Topic  Post A Reply
profile | register | preferences | faq | search

UBBFriend: Email This Page to Someone! next newest topic | next oldest topic
Author Topic:   Is there an easier way . . .
Raging_Canadian
Serf

Posts: 9
From:
Registered: Feb 2002

posted 19 February 2002 11:15     Click Here to See the Profile for Raging_Canadian   Click Here to Email Raging_Canadian        Reply w/Quote   
Is there an easier way to modify all the monster stats than 1 by 1??? I use D2Excel I changed all the monster lvls 1 at a time and b4 i start on the hps I want to know if theres someway i can increase the hps all by a single factor?

IP Logged

dectgap
Knight

Posts: 66
From: Malmö, Sweden
Registered: Dec 2001

posted 19 February 2002 11:55     Click Here to See the Profile for dectgap   Click Here to Email dectgap        Reply w/Quote   
You can use Microsoft Excel instead.
That we, you can easily multiply all HP with any value you want.
If you are having problems with how to do it, write here again.

IP Logged

Raging_Canadian
Serf

Posts: 9
From:
Registered: Feb 2002

posted 19 February 2002 12:03     Click Here to See the Profile for Raging_Canadian   Click Here to Email Raging_Canadian        Reply w/Quote   
I dont have excel (crud) but is there a way I could use ms works spreadsheet or is there a better program I could download and use?

------------------
If it is true the good die young, I will live for ever

IP Logged

dectgap
Knight

Posts: 66
From: Malmö, Sweden
Registered: Dec 2001

posted 19 February 2002 12:14     Click Here to See the Profile for dectgap   Click Here to Email dectgap        Reply w/Quote   
You can probably use MS Works, but I haven't used it for a long time, so I can't say for sure.

There should be some kind Excel Light that you can download from microsoft.com, but I can't find it right now. Tell me if you find it, and I can tell you how to change the HP in an easy way.

Or perhaps someone can tell you how to do it in Works.

IP Logged

Raging_Canadian
Serf

Posts: 9
From:
Registered: Feb 2002

posted 19 February 2002 12:17     Click Here to See the Profile for Raging_Canadian   Click Here to Email Raging_Canadian        Reply w/Quote   
I'll see if I can try with Works
I'll be back, hopefully to find out how to change em the easy way

------------------
If it is true the good die young, I will live for ever

IP Logged

Raging_Canadian
Serf

Posts: 9
From:
Registered: Feb 2002

posted 19 February 2002 12:19     Click Here to See the Profile for Raging_Canadian   Click Here to Email Raging_Canadian        Reply w/Quote   
Ok I got works to open Monstats.txt as a spreadsheet. How can i change em all easily and is there a way to lock the first row?

------------------
If it is true the good die young, I will live for ever

IP Logged

dectgap
Knight

Posts: 66
From: Malmö, Sweden
Registered: Dec 2001

posted 19 February 2002 12:33     Click Here to See the Profile for dectgap   Click Here to Email dectgap        Reply w/Quote   
It could be hard to explain since you are using Works, and I am using a Swedish version of Excel, but I'll try =)

Select cell B2 and chose "Lock Windows" (?) under "Windows". Now should have column A and row 1 locked.
Go to an empty column (for example IG) and write the following in IG2:
=FC2*2
FC is the column with the Min HP in Normal, and the "*2" just means that you double the HPs (change that number to what you want). IG2 should now show "12".
Left click in the lower right corner of IG2, and hold the mouse button down. Now, while you are holding the mouse button down, pull (is that the right word?) your way down to the very last monster (row 577).
Select the whole column (IG) and press Ctrl+C to copy them.
Now find column FC, select it and chose "Paste Special", or something like that. Chose "Values" and you're done.
Repeat the steps with all HP-columns.

I hope that helps.

IP Logged

Raging_Canadian
Serf

Posts: 9
From:
Registered: Feb 2002

posted 19 February 2002 12:37     Click Here to See the Profile for Raging_Canadian   Click Here to Email Raging_Canadian        Reply w/Quote   
Thanx

------------------
If it is true the good die young, I will live for ever

IP Logged

scambrig
Serf

Posts: 17
From:
Registered: Jun 2001

posted 19 February 2002 13:15     Click Here to See the Profile for scambrig   Click Here to Email scambrig        Reply w/Quote   
I use works too, if you do that dont forget to delete the column after you used it to copy from, also there is a row called expansion that has no values for any of the columns and so make sure you delete the zero that will be left over from pasting. Also if you are going to multiply rows that are next to each other by the same number then all you have to do is drag (pull) the new multiplier column to the right and it'll go to the next column just like it goes to the next row when you drag it down.

IP Logged

Myhrginoc
Honorary Warlord

Posts: 1326
From: Percussion U
Registered: Dec 2001

posted 19 February 2002 19:48     Click Here to See the Profile for Myhrginoc   Click Here to Email Myhrginoc        Reply w/Quote   
D2Excel allows you to select a column, then right-click the column header to add to, subtract from, multiply and divide every value in the column all at once. A quick way to scale monster HP and exp

[This message has been edited by Myhrginoc (edited 19 February 2002).]

IP Logged

All times are Central Standard Time

next newest topic | next oldest topic

Administrative Options: Close Topic | Archive/Move | Delete Topic
Post New Topic  Post A Reply
Hop to:

Contact Us | The PhrozenKeep

© PhrozenKeep.com . all buttons made by the Evilenglishman . swords and shields by DigiBO.


Ultimate Bulletin Board 5.47c