1. Take note of the columns you which to multiply and by how much.
In this example we want to do Exp times 50, and dill drop amounts by 100
2. Scoot over to the side of the data in the csv, choose an empty column and press the sum button. (or type the start of a sum command)
3. Put in the sum you wish to do.
In this case it is the exp (column Y) which starts in row 2, Times by 50 (*50).
4. Press enter so it does the sum for you.
Then grab the little square at bottom right of the box thats indicated in that picture to the bottom of the info indicated in this picture:
5. When you release it it should give you the following:
But you will notice that the info in the box is still the sum, not the actual value typed into it.
6.To solve this, we save the csv (keeping its format if it asks you)
Then re-open the csv.
7. Now that it has the real values not the sum in each box, we can copy or cut the entire line.
8. And then place it over the old exp.
Which finishes off the exp.
9. Now for the dill amount dropped.
We start by placing the sum in for the min dill drop box.
10. Which will result in its reward, we then drag its box.
But this time, not straight down at first. Drag it across one box.
Exel will automatically put in the corresponding box for the max dill amount. (if it does not for you, put it in manually)
11. We then use the drag option like the exp on box lines (one at a time) to bring the following result.
12. But again, we need to save and re-open the csv so we get real values again.
13. We can then highlight both columns we just made, and then cut and paste them over the old dill values.
14. DONE!
Note: Some steps may vary a LITTLE if you are using microsoft office exel since I used open office. (the free version of microsoft office)
