RequirementsEdit

• Microsoft Excel 2003 or better
• Some experience with Microsoft Excel

UsageEdit

Calculation of what you could make or lose from doing things, for example:

• Buying ores to make bars and sell them, etc.
• Merchanting

Ratio converterEdit

The stranded cell below the one cell in the C column is a ratio converter. Basically, it tells how much percent you're earning or losing. (i.e. 1.25 means 25% gain and 0.25 means you lose 75%)

How to make sheetEdit

1. Highlight A1 to A8 then colour it << with a green background
2. Highlight B1 to B8 then colour it << with a red background
3. Below those 2 columns, colour those 2 cells a colour, like greenish blue (NEVER EDIT THESE)
4. In cell A9 type the following code to add up cells highlighted in green:
   1. =SUM(A1:A8)
5. Type the following code in B9:
   1. =SUM(B1:B8)
6. Below those cells, colour them yellow in background.
7. Inside the cell on the left put the code as
   1. =B10
8. In cell A11, put
   1. =A9*A10
9. In cell B11, put
   1. =B9*B10
10. For those 2 cells, make the background colour the same as the warning colour of no editing.
11. In cell C11, put
    1. =A11+B11
12. Make it the same colour as the cells on the left.
13. In the cell below it put the code in as
    1. =A11/B11
14. Colour that cell as the no edit colour.
15. To Display a percentage without you having to convert it (So if you're as lazy as me) in the cell C13 put
    1. =(C12*100)-100

1. Save your sheet.
2. Use your sheet after saving.