BeanCounter Export

Export BeanCounter history to readable format with filters

File Details

Bean Counter 1.4.4

  • R
  • Sep 2, 2015
  • 52.09 KB
  • 3.9K
  • 6.2.2
  • Retail

File Name

BeanCounter_v1.4.4.xlsm

Supported Versions

  • 6.2.2

v1.4.4 Changes:

  • Added an "ItemID" column to all sheets (on a user request)

v1.4.3 Changes:

  • Increased supported itemID range to include all WoD items

v1.4.2 Changes:

  • Version change bump

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)