Get an Epic Experience with Premium

Gnomexcel

Data Export Login to Add Favorites
  • 1 Like
  • World of Warcraft
  • 28 Monthly Downloads
  • Supports: 5.4.1
  • 2,520 Total Downloads
  • Updated 11/14/2013
  • Created 08/31/2010
  • 30 Favorites
  • Project Site
  • Comments
  • Release Type: Release
  • License: Apache License version 2.0
  • Newest File: r29-release
or
Support development! **
Donate

About Gnomexcel

Gnomexcel is a GUI (Gnomatron Unified Interface) for LibSpreadsheet.
It might not (yet) be able to serve you breakfast in bed, but you can do your tax return while you PuG!

Features in Gnomexcel

  • Import from CSV to Gnomexcel
  • Export your data to either CSV, XML or HTML format.
  • Use math functions like a pro!
  • Works with Excel/Calc macros!
  • Cut, copy or paste cells around to your heart's delight
  • Works with both text, numbers, WoW currency and WoW items
  • Drag items or spells into any cell to copy it to the spreadsheet.

Type /gxl or /gnomexcel to open up the program.

Math functionality

You can use Gnomexcel as a simple spreadsheet, or you can take advantage of the fully equipped math functions by adding a "=" to your data, just like in regular spreadsheet programs:

  • Standard math:
    • ABS(number) - Returns the absolute value of a number.
    • AND(expression1, expression2) - Returns true if both expressions are true, false otherwise.
    • AVERAGE(number1, number2, ...) - Returns the average (mean value) of the numbers specified.
    • CEIL(number[,significance]) - Rounds a number up to the nearest integer value or the nearest multiple of significance.
    • COS(number) - Returns the cosine of an angle.
    • COSH(number) - Returns the hyperbolic cosine of a number
    • COUNT([range]) - Returns the total number of cells in the specified range that contains number values.
    • COUNTIF(statement, range) - Returns the total number of cells in the range that fits the statement (fx. ">= 4")
    • FLOOR(number[, significance]) - Rounds a number down (towards zero) to the nearest integer or multiple of significance.
    • IF(statement, trueResponse [, falseResponse]) - Evaluates the argument statement and returns the value trueResponse if the statement is true. If falseResponse is specified, it will be returned if the statement is false.
    • LARGE(k, number1, number2, ...) - Returns the kth largest value among the numbers passed, fx. the 3rd largest number in the range B1:D3
    • LEN(value) - Returns the length in characters of a number or a string.
    • LN(number) - Returns the natural logarithm of a number
    • LOG(number[,base]) - Returns the logarithm of the specified number to either 10 or the specified base number.
    • MAX(number1, number2, ...) - Returns the largest of the numbers passed.
    • MEDIAN(number1, number2, ...) - Returns the median (the number in the middle of all the numbers sorted numerically)
    • MIN(number1, number2, ...) - Returns the smallest of the numbers passed.
    • MOD(number, divisor) - Returns the remainder after a number is divided by a divisor
    • MODE(number1, number2, ...) - Returns the most frequently occurring number among those passed.
    • OR(expression1, expression2) - Returns true if either expressions are true, false otherwise.
    • POW(number, power) - Returns the result of a number raised to a power, e.g. 42
    • ROUND(number) - Rounds the number to the nearest integer value.
    • SELECT(k, number1, number2,...) - Returns the k-th item in the list
    • SIN(number) - Returns the sine of an angle.
    • SINH(number) - Returns the hyperbolic sine of a number
    • SMALL(number1, number2, ...) - Returns the smallest of the numbers passed.
    • SQRT(number) - Returns the square root of a number.
    • SUM(number1, number2, ...) - Returns the sum of all numbers passed, e.g. SUM(B1:B7) or SUM(1,34,6,3).
    • SUMIF(statement, number1, number2, ...) - Returns the sum of all numbers that passes the statement (fx. ">25")
    • STDEV(number1, number2, ...) - Returns the standard deviation for the population passed.
    • TAN(number) - Returns the tangent of an angle.
    • TANH(number) - Returns the hyperbolic tangent of a number.
    • UNIQUE(number1, number2, ...) - Returns a list of all the unique numbers passed.

  • WoW functions:
    • HEALTH([target]) - Returns the current health of [target] (or yourself if no target is set)
    • MAXHEALTH([target]) - Returns the max health of [target] (or yourself if no target is set)
    • POWER([target]) - Returns the current power (mana, rage, energy etc) of [target] (or yourself if no target is set)
    • MAXPOWER([target]) - Returns the max power of [target] (or yourself if no target is set)
    • MONEY() - Returns your current amount of money in copper.
    • LEVEL([target]) - Returns the current level of [target] (or yourself if no target is set)
    • ARMOR([target]) - Returns the current armor of [target] (or yourself if no target is set)
    • DEFENSE([target]) - Returns the current defense level of [target] (or yourself if no target is set)
    • MOBTYPE([target]) - Returns the mob type (normal, elite, heroic elite etc) of [target] (or yourself if no target is set)
    • RACE([target]) - Returns the race of [target] (or yourself if no target is set)
    • CLASS([target]) - Returns the class of [target] (or yourself if no target is set)
    • STRENGTH([target]) - Returns the current strength of [target] (or yourself if no target is set)
    • STAMINA([target]) - Returns the current stamina of [target] (or yourself if no target is set)
    • AGILITY([target]) - Returns the current agility of [target] (or yourself if no target is set)
    • INTELLECT([target]) - Returns the current intellect of [target] (or yourself if no target is set)
    • SPIRIT([target]) - Returns the current spirit of [target] (or yourself if no target is set)


Math examples:

  • =SUM(C2:E7)/POWER(player)
  • =FLOOR(HEALTH(target)/STAMINA(target))
  • =B2 + C5

More information to come.

------------------------------------------------------------------------
r29 | humbedooh | 2013-11-14 16:26:39 +0000 (Thu, 14 Nov 2013) | 1 line
Changed paths:
   A /tags/r29-release (from /trunk:28)

Tagging as r29-release
------------------------------------------------------------------------
r28 | humbedooh | 2013-11-05 15:28:48 +0000 (Tue, 05 Nov 2013) | 1 line
Changed paths:
   M /trunk/Gnomexcel.lua

Drop a hint on how to rename a book.
------------------------------------------------------------------------
r27 | humbedooh | 2013-11-05 15:14:16 +0000 (Tue, 05 Nov 2013) | 1 line
Changed paths:
   M /trunk/Gnomexcel.lua

whitespace fixes and allow users to rename a book my shift-clicking it.
------------------------------------------------------------------------
r26 | humbedooh | 2013-11-05 11:30:06 +0000 (Tue, 05 Nov 2013) | 1 line
Changed paths:
   M /trunk/Gnomexcel.lua

Simplify import of CSV and make the visual export mode work again.
------------------------------------------------------------------------
r25 | humbedooh | 2013-11-04 19:00:15 +0000 (Mon, 04 Nov 2013) | 1 line
Changed paths:
   M /trunk/Gnomexcel.lua

nil check
------------------------------------------------------------------------
r23 | humbedooh | 2013-11-04 11:50:23 +0000 (Mon, 04 Nov 2013) | 1 line
Changed paths:
   M /trunk/Gnomexcel.toc

Update TOC, this baby still works <3
------------------------------------------------------------------------
r22 | humbedooh | 2010-11-28 09:37:08 +0000 (Sun, 28 Nov 2010) | 3 lines
Changed paths:
   M /trunk/Gnomexcel.lua

Library updates
Added auto-highlight to the "add new book" dialog
Fixed an issue with new books not rendering properly on first load
------------------------------------------------------------------------

Comments

First Previous Page 1 of 2 Next Last
  • #18

    Thanks again for updating this addon.  I used to use Excel to track list of things like, toons, which BOAs are good for which class, bascially non math stuff.  This addon means I can do that without having to constantly Alt-Tab out of the game.

  • #17

    How do I import a CSV file?  I've tried opening an existing CSV file in notepad, select all, copy, paste into this addons import window.  Nothing happens.

    Last edited by s-conley on 11/30/2013 9:03:38 AM
  • #16

    Inserting a column is adding columns to the far right, not in front of the selected cell/column.

  • #13
    One bug and one suggestion for this most delightful of addons:

    1) The page numbers at the bottom redraw on top of each other making them impossible to read

    2) I'd really like to be able to rename my books (and ideally individually name my sheets as well)

    This program is a godsend.
  • #15

    Books can now be renamed by shift-clicking on a book name :)

  • #14
    Hiya!
    First off, yeah, the spreadsheet library is still quite buggy due to some odd behavior from WoW's widget API, but it's being worked on.

    Secondly, there will be a context menu (right-click) on books and such in the near future for editing names etc.
  • #11
    I love this addon, very useful and saves me having to open excel all the time!

    But may I suggest a couple of features too - One of them a simple feature, the other which is doubt will be possible / done:
    - A mini-map icon to open and close it - it's annoying when your in the middle of typing something and want to quickly check some data.
    - A guild funds manager that imports from guild money log? Something along the lines of:
    Overall totals deposited and withdrawn at the top
    Character per row with characters name in column 1
    Characters overall total amount (positive or negative) running down column 2 (=sum(range))
    0"))
    Total deposited in column 4 (reverse of the one before)
    And the rest of the columns used to store all the logs of that character (withdraws could be listed as negative, deposits could be listed as positive).

    If that makes sense?
  • #12
    Since you're suggesting improvements/features in both LibSpreadsheet and Gnomexcel, I'll address each topic separately:

    Regarding LibSpreadsheet features:
    I'll add SUMIF() and probably a COUNTIF() function within a day or two - thanks for suggesting that.

    Regarding Gnomexcel features:
    1) If you want to open gnomexcel without having to type /gxl, just make a macro that does it :)
    2) A guild funds manager sounds more like an add-on (or a plugin) for Gnomexcel than an actual core feature. I might look into creating a plugin-system for Gnomexcel which would allow for that.
  • #9
    but can it do nested IF statements?
  • #10
    If you mean something like this for setting C3:
    if ( sum(B2:B6) = 5 and A2 = 4 ) then
    c3 = 3
    else
    if ( c2 = 4 ) then
    c3 = 4
    end

    then yes, it would translate into something a'la this:
    =IF(AND(SUM(B2:B6) = 5, A2 = 4), 3, IF(C2 = 4, 4))
  • #6
    when i try use function =SUM(C1:C2:C3)/MANA(player), i got error "No such Math function: MANA!"
  • #8
    Also, if you want to sum up specific cells and not a range, use:
    =SUM(C1, C2, C3)

    or just use =SUM(C1:C3) to sum up all cells in that range.
  • #7
    There's no such function :p use POWER([target]) for getting the power (mana, rage, energy etc).
  • #4
    Can you now, or maybe in the future, copy the data from the 'Guild Roster Dump' addon and paste it into this great addon?
  • #5
    Yes, there will be several ways of importing data into the spreadsheets soon. One way will be through the "import/export" function, and another will be a regular copy/paste function accessible through right-clicking a selection range.
  • To post a comment, please login or register a new account.
Login to Curse

Don't have an account? Create One.

Get an epic experience with Curse Premium
  • Faster addon downloads
  • Premium-Only Beta Giveaways
  • Ad-Free Curse experience
  • Premium Curse Client
  • and many More Features
  • Learn More »

Leaguepedia PAX Skin Giveaway