These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Technology Lab

 
  • Topic is locked indefinitely.
 

Eve's corp wallet tax calulator and ratting statistic
Author
Previous Topic Next Topic
Heleana Commodus Luyseyal
TheBlacklist
Fraternity.
#1 - 2016-09-02 19:30:32 UTC  |  Edited by: Heleana Commodus Luyseyal
Here is a EXCEL 2013 file which calulates your corp taxes, and how much did your members ratted away.

Statistical format is:

- corp tax for any given date that you select;
- earnings from bounties of your corp members;
- total number of ticks.

Read first!

1. Make corp API with wallet journal accesible.

2. Under data tab go to connections -> Select WalletJournal.xml1 and go to Properties;
2a. Go to Definiton tab, go to Connection file and click Browse button
2b. Copy the corp API link in next format:

https://api.eveonline.com//corp/WalletJournal.xml.aspx?rowCount=2560&keyID=XXXXXXX&vCode=XXXXXXXXXXXXXXXXXXXXXXXXXXXX

3. Paste into "File name" text box in browse window and press "open";

4. After that right click A1 cell and click "refresh" first in "Data" sheet, than in "Sheet2" sheet.;

5. Tax rate, under "Data" sheet update forumla in cell V2, to =[@amount]/0.10 (this would be for a 10% tax rate)




Download : http://www.filedropper.com/bounties