IP/RP Calculation Spreadsheet

Have you ever wondered how much IP or RP you earned or spent in your LoL career?
Do you want to know how much money a skin is worth or how much RP you actually saved by buying skins on sale rather at full price?
These and more questions I can answer for you. I made a spreadsheet in Excel for my team and wanted it to share it with you aswell. It just needs some input from you and the workbook calculates everything for you. It is easy to use and pretty much self explanatory.

For those, who don't trust everyone on the internet (which is wise):
There are three different version, so you should find one that suits you. See the description of the files for more information about this.


--FILE INFORMATION:

Version: 1.04
Last edit: July 28 2011
You need Excel 2003 or higher to open this file. Should also work with OpenOffice and NeoOffice.


A quick overview about the features and differences between the versions:

IP/RP Calculation Spreadsheet WITHOUT MACROS (*.xlsx)

Safety:
A *.xlsx file does not contain any code (VBA), therefor cannot do anything besides calculating simple math based on your input.

Features:
* Calculate Total IP and RP used on champions, runes, skins, bundles, boosts, and everything else on the store
* Calculate RP to money values and back (Supported currencies: EUR, GBP, USD, PLN)
* Calculate difference between RP spent on skins and their actual value (sale to regular price) (including conversion to real money)
* Distinction between old prices on champions, prices on sale, free skins, and variable prices
... and more

Download:
XLSX


IP/RP Calculation Spreadsheet WITH MACROS (*.xlsm)

Safety:
This *.xlsm file contains some Macros (VBA) to simplify input and make the overall input-process faster. There is always the possibility of errors within the code, but they can never do any harm. If you find an error, please let me know, so I can fix it.

Features:
*All of the above plus:
*Auto Fill for respective champions, skins and runes when selecting a bundle
*Button to clear all input and reset the spreadsheet

Download:
XLSM


IP/RP Calculation Spreadsheet ONLINE (Google Docs)

Safety:
As safe as any website on the internet. You cannot get a safer version.

Features:
None - I recently made the online version "view only" as it was almost always broken, due to someone editing cells, which should not be edited. There is not option to protect certain cells. I can only give everyone full access or leave it at "view only". You can still use this version to get basic information about the spreadsheet and to decide if you want to download one of the other version or not.

Link:
https://spreadsheets.google.com/spreadsheet/ccc?key=0Ai3_Gfwb5f_6dGF2Z0JkQmxfcjhBX25aeXdTd2pqTEE


--HOW TO USE:

*Choose your currency
*Fill in the yellow input cells in each sheet (the download versions have locked cells and validation to prevent incorrect data and breaking the code)
*If you need help, move the cursor to the headercell of an input column to see the tooltip, which gives you some information.
*After you finished your input, you see the result on the Sheet labeled "Details"
*If you need more help, just answer in this thread, contact me per email (it's in the sheet) or message me on the EU West server (Summoner Name: Izri)

If you find any bugs, have suggestions or simple found something I missed, please let me know. I will try to keep it updated with every new patch.
Have fun with it.


Greetings,
Izri

impressive that you have spent 300,000 ip on champs

Yeah, well I always wanted to calculate that, but a simple calculator didn't suffice. I actually thought I earned and spent more, but it's still a nice number.

I'm also almost finished with the RP calculation part. There is also a RP to Euro conversion, so you guys know how much money you spent on what ^^

Allright, new version added with a lot more information and stuff to calculate. I might have missed a few skins, so if you notice something, please let me know.

New version is out. Alot of changes this time. Just take a look at the first post at the top.

(copy paste from other forums)