Author
|
Topic: Is there an easier way . . .
|
Raging_Canadian Serf
Posts: 9 From: Registered: Feb 2002 |
posted 19 February 2002 11:15
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?

|
dectgap Knight

Posts: 66 From: Malmö, Sweden Registered: Dec 2001 |
posted 19 February 2002 11:55
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.

|
Raging_Canadian Serf
Posts: 9 From: Registered: Feb 2002 |
posted 19 February 2002 12:03
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

|
dectgap Knight

Posts: 66 From: Malmö, Sweden Registered: Dec 2001 |
posted 19 February 2002 12:14
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.

|
Raging_Canadian Serf
Posts: 9 From: Registered: Feb 2002 |
posted 19 February 2002 12:17
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

|
Raging_Canadian Serf
Posts: 9 From: Registered: Feb 2002 |
posted 19 February 2002 12:19
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

|
dectgap Knight

Posts: 66 From: Malmö, Sweden Registered: Dec 2001 |
posted 19 February 2002 12:33
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.

|
Raging_Canadian Serf
Posts: 9 From: Registered: Feb 2002 |
posted 19 February 2002 12:37
Thanx------------------ If it is true the good die young, I will live for ever

|
scambrig Serf
Posts: 17 From: Registered: Jun 2001 |
posted 19 February 2002 13:15
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.

|
Myhrginoc Honorary Warlord
   
Posts: 1326 From: Percussion U Registered: Dec 2001 |
posted 19 February 2002 19:48
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).]

|