- Home
- Downloads
-
Addons & Mods
Featured
World of Warcraft
5,104 Server Mods
-
Popular Downloads
- Top World of Warcraft Addons
- Top Minecraft Server Mods
- Top Rift Addons
- Top Skyrim Mods
- Top World of Tanks WoT Mods
- Top Starcraft II Maps
- Top Terraria Maps
- Top Runes of Magic Addons
- Top Warhammer Online Addons
- Top Age of Conan Addons
-
- Curse Client
- Premium
- News
- Giveaways
- Videos
- Forums
BeanCounter Export
Login to Add Favorites
- 0 Likes
- World of Warcraft
- 34 Monthly Downloads
- Supports: 4.0.6
- 5,998 Total Downloads
- Updated 11/10/2010 1:33:20 AM
- Created 4/26/2010 3:43:47 AM
- 19 Favorites
- Project Site
- Comments
- Release Type: Release
- License: Public Domain
- Newest File: BeanCounter v1.4.1
About BeanCounter Export
I was quite bored to not be able to extract information from the in-game BeanCounter addon from Auctioneer Suite. With some VBA and regular expressions I succeeded to gather what I needed.
This excel file requires Office 2007 and macros to be allowed. Browse to your BeanCounter.lua and click Run button. (For versions 1.3 and lower: when the file opens hit Alt+F8 to run the macro named ReadFile...)
It will ask for your full path to your BeanCounter.lua (default c:\program files\World of warcraft\Wtf\xxxxxxx\bloodfeather\saved variables\beancounter.lua) wait a few minutes, and you should have all the successful and failed auctions on two separate sheets.
I mainly created it for my personal usage, but if you want anything (and I have time for it) let me know!
If you want to share of your revenues from AH, you can donate here
v1.4.1 Fixes:
- Updated the parsing algorithm to work with latest BeanCounter data, my tests were OK, let me know if you have any problems.
- Removed MS Dialog control class reference, which caused problems for some users.
v1.3.1 Fixes:
- Increased the transaction limit from 100.000 to 500.000, since I hit it yesterday :)
- Removed the Alt+F8 functionality, just click the Run button.
v1.3 Changes:
- Changed the way the BeanCounter filename is entered, now one can either paste into a cell on the main sheet or click a button to browse to the file (which enters the path into the cell) Thanks to Akrostychon for his small filedialog code
- Added a new optional selection which allows to disable new currency formatting if a user so desires (Again thanks to Akrostychon for the excek cell format)
v1.2 Fixes:
- Changed the code a bit, so it works regardless where the itemids data block appears in the lua file...
v1.1 Changes:
- Added 1 new sheet, called MyBids
- Changed regular expressions a bit to make sure unicode characters are matched even if in character name (this time for real I hope!)
v1.0 Changes:
- Added 3 toggle options to the main sheet, allowing some of the sheets to be ignored to gain speed
- Added a simple toggle to the main sheet, when set to yes, it autofilters the sheets upon finishing file reading
- Changed the reading code and reading speed increased around 3 times. Now it takes approx. 1 minute to read a 100000 transaction .lua (on a Core i7 920 machine)
For earlier changes, see the change log
v1.4.1 Fixes:
- Updated the parsing algorithm to work with latest BeanCounter data, my tests were OK, let me know if you have any problems.
- Removed MS Dialog control class reference, which caused problems for some users.
v1.3.1 Fixes:
- Increased the transaction limit from 100.000 to 500.000, since I hit it yesterday :)
- Removed the Alt+F8 functionality, just click the Run button.
v1.3 Changes:
- Changed the way the BeanCounter filename is entered, now one can either paste into a cell on the main sheet or click a button to browse to the file (which enters the path into the cell) Thanks to Akrostychon for his small filedialog code
- Added a new optional selection which allows to disable new currency formatting if a user so desires (Again thanks to Akrostychon for the excek cell format)
v1.2 Fixes:
- Changed the code a bit, so it works regardless where the itemids data block appears in the lua file...
v1.1 Changes:
- Added 1 new sheet, called MyBids
- Changed regular expressions a bit to make sure unicode characters are matched even if in character name (this time for real I hope!)
v1.0 Changes:
- Added 3 toggle options to the main sheet, allowing some of the sheets to be ignored to gain speed
- Added a simple toggle to the main sheet, when set to yes, it autofilters the sheets upon finishing file reading
- Changed the reading code and reading speed increased around 3 times. Now it takes approx. 1 minute to read a 100000 transaction .lua (on a Core i7 920 machine)
v0.05 Minor change:
- Changed the parsing code to be a bit more error-friendly
v0.04 Minor change:
- Changed the file reading routine with subxero's suggestion to support UTF8 (unicode) character names
v0.03 Several changes:
- Added CharacterName to settings sheet to only get that characters data
- Added Number of Days to settings sheet to only get last # of days data
- Added code to fill out MyBuyouts tab
v0.02 Added settings sheet, which only contains servername field, enter your servername into the orange colored box (probably case insensitive)
| File Name | Release Type | Game Version | Downloads | Date |
|---|---|---|---|---|
| BeanCounter v1.4.1 | Release | 4.0.6 | 2,144 | 11/10/2010 1:33:20 AM |
| BeanCounter v1.3.1 | Release | 3.3.5 | 1,125 | 10/2/2010 4:38:33 AM |
| BeanCounter v1.3 | Release | 3.3.5 | 574 | 9/7/2010 12:51:27 PM |
| BeanCounter v1.2 | Release | 3.3.5 | 273 | 9/6/2010 1:02:35 PM |
| BeanCounter v1.1 | Release | 3.3.5 | 556 | 8/5/2010 10:34:07 PM |
| BeanCounter v1.0 | Release | 3.3.5 | 133 | 8/3/2010 7:49:10 PM |
| BeanCounter v0.05 | Beta | 3.3.5 | 91 | 8/3/2010 5:24:04 PM |
| BeanCounter v0.04 | Beta | 3.3.5 | 32 | 7/13/2010 4:01:16 PM |
| BeanCounter v0.03 | Beta | 3.3.3 | 72 | 5/25/2010 5:06:05 PM |
| BeanCounter v0.02 | Beta | 3.3.3 | 39 | 4/29/2010 6:31:53 PM |
| BeanCounter.xlsm | Beta | 3.3.3 | 61 | 4/26/2010 4:59:16 AM |
Addon Packs Containing This...
Top Downloads
-
- Bagnon
- Bags & Inventory
- 379,555 Monthly Downloads
-
- Deadly Boss Mods
- Combat and Boss Encounters
- 307,157 Monthly Downloads
-
- Recount
- Combat
- 307,116 Monthly Downloads
-
- SpellFlash
- PvP, Buffs & Debuffs, Quests & Leveling, Action Bars, and Combat
- 281,580 Monthly Downloads
-
- GatherMate2_Data
- Achievements
- 213,801 Monthly Downloads
Comments
It's kind of hard for me to monitor comments. If you have any problems with this please open a ticket on curseforge (http://wow.curseforge.com/addons/beancounter-export/tickets/) and I'll do my best to fulfill your wishes :)
Was just starting to write my own code when I thought 'lets do another search' and voila...
Didn't work straight out the box with Office 2003 but replacing the rows R500001 with R65536 solves the problem and it creates my file. Add a pivot table and I can easily see what makes me the largest volume of cash, not profit but I'm just looking at reducing down the items I Sell.
Making pivot tables have always baffled me and i suck at excel
Having sales, bids and buyouts on 3 seperate sheets takes away some ability I can think of. Also, I am not sure if this is possible, but can vendor prices be added? I buy so many items every day that are auctioned under vendor prices, I am curious what my actual profit has been. When I use the dropdown for vendor its good to see what i spent on items, but there is no QUICK way for me to look up every item I buy but maybe the item ID can?
This macro successfully exported some data from my beancounter.lua, but the column "item name" is empty :(
Every other column seems to have correct data, but the name of the item is missing (empty cells).
Maybe cause by my localized german client?
It will be helpful for me not to forget it :)
Have you uploaded this yet?
I'm sorry, but I won't be able to support mac, because it does not have the same macro model for windows as far as I know. Feel free to use my VBA code to port it to mac if you want.
Thanks!