Curse

Vicviper101 · Oct 05, 2006, 08:59 AM // 08:59

Hi there folks!

I originally made my own little system for keeping track of my money and worth, and I told some of my alliance members about it, and they sounded interested, so I did a complete overhaul of my system so it would be viable for general use.

My handy dandy accounting system to keep track of all of your funds!

Farmer Kane's Accounting System.xls

Features:

-Tracks Gold across characters
-Helps Track Material Price Changes
-Tracks Total Material Worth
-Tracks Overall Worth (Gold + Materials/Runes)
-Tracks Overall changes in net worth
-And Much more!

I think it's pretty straight forward, but if you have any questions on how to use it, feel free to ask!

It'sa big ol' excel spreadsheet workbook, be sure to note that there are 4 sheets, to go to the next sheet, hit the different tab near the bottom of the excel window. Start on the "Totals" page by entering the date (which will be automaticly entered in the next sheets), Enter your character names, and under them, the amount of gold that they are carrying, as well as the amount of gold in your storage. You can stop here if that's as complex as you want to go.

If you want to keep track of your materials, go to the Material Prices sheet and enter the merchant buy prices (the prices the merchants will buy from you) in the respective cells. Next, go to the Material Amounts sheet and enter the amounts you have. You can now look at the Material Values sheet to see the value of your amounts of materials. Once you've entered the current price and your amounts, the Totals page will be updated with your total Gold Value, Material Value, and Net Value, as well as the change from the previous entry if applicable.

Enjoy!

PS. One problem others have found, depending on your system, the date format may get changed to UK or US, if it's one you don't want, just highlight like the first 100 date cells in the totals sheet, right click, hit format cells, then go to the numbers tab, then find date on the list, and change it to what you want.

Sereng Amaranth · Oct 12, 2006, 04:39 PM // 16:39

Nice stuff there. But why all the different date rows? I really dont care for how much money I used to have. Maybe just previous and present, so 2 rows.

I'm digging it tho. I was wanting something like this ingame, since the price data is right there.

kooldude · Oct 12, 2006, 08:43 PM // 20:43

sweet deal i like the idea but ya id halfto go with Sereng Amaranth, id like it to be in game but u cant always get wat u want :/

if it hack my acc i blame u -.-

Xaero Gouki Kriegor · Oct 12, 2006, 11:44 PM // 23:44

i wish anet had something that told the total gold made in the account since the first day spending, so i could see how much ive actualy spent on gold period when i first started playing

Bane of Worlds · Oct 13, 2006, 01:00 AM // 01:00

I'm definately loving this and will continue to use it since this is what I like to do anyways

Vicviper101 · Oct 14, 2006, 12:38 AM // 00:38

Thanks for the input guys. I see what you mean Sereng, maybe I should make a second version that isn't made to track money and material prices over time, but just one entry or two. I'm glad to know that my idea is being put to good use, let me know if any other problems come up, and I'll see about that second version.

-Vicviper101