Minion Beta! - Help us test our new AddOn updater. Get it now!
Download
(47 Kb)
Download
Updated: 12-11-11 11:28 PM
Pictures
File Info
Updated:12-11-11 11:28 PM
Created:unknown
Downloads:39,229
Favorites:518
MD5:

LilSparky's Workshop  Popular! (More than 5000 hits)

Version: 119release
by: lilsparky [More]

LilSparky's Workshop adds auction-derived pricing information for trade skills right into the trade skill recipe frame. Each skill is evaluated for material costs and potential value of the item created. These two numbers are listed next to each skill in an easy-to-read format.

Supported Auction Scanners:

* Auctioneer
* AuctionLite
* AuctionMaster
* Auctionator

Trade Skill Interfaces Supported:

* GnomeWorks
* AdvancedTradeSkillWindow
* Skillet
* Blizzard's Standard UI
* Doublewide Tradeskills
* Tradeskill HD
* MrTrader
* Jobber

Optionally Requires:

* Informant
* LibPeriodicTable
(these mods will assist in identifying vendor sourced items)


Auction pricing models can be selected by right-clicking either the value column or the cost column (each can have a different pricing method attached).

The Value column can be left clicked to cycle through the different valuation methods for the resultant item: Auction Value (a), Vendor Value (v), Disenchant Value (d) or the greatest of the three different values (the default). Any instance of an item Value being greater than the Cost to create it will have a highlighted Value entry. Optionally, the Value column can be displayed as a percentage of the Cost column.

The Cost column simply sums up the costs for each reagent and reports the total.

Both columns can be combined into a single "Profit" column which simply reflects the Value minus the Cost.

Tooltips for each column give more details about the price breakdowns LSW is considering.


Right clicking on the cost column will bring up a menu offering the ability to override item price and vendor availability on a per-reagent basis.


version history:
v0.1 - oct.09,2007
- initial release

v0.2 - oct.11,2007
- fixed skill value computation (no longer reports inflated values)
- removed dependency on advanced tradeskill window
- fixed bug where addon initialized prior to auctioneer loading
- now loads on demand

v0.3 -- oct.12,2007
- added skillet support
- additional bug fixes in auctioneer queries

v0.31 -- oct.12,2007
- added support for resizable skillet window

v0.32 -- oct.18,2007
- support for latest skillet features (sorting)

v0.33 -- oct.22,2007
- added value as percent toggle
- added KC_Items support (initial)

v0.34 -- oct.26,2007
- added support for "GetSellValue()" api as fallback for when Informant or SellValues is not loaded

v0.40 -- oct.29,2007
- bug fixes

v0.41 -- oct.31, 2007
- fixed informant bug for purchase price of stacked items (like vials)
- added price sanity check routine for skill costs

v0.42 -- nov.05, 2007
- added detailed info to value tooltip

v0.43 -- nov.17, 2007
- updated toc for 2.3

v0.44 -- dec.10, 2007
- fixed enchanting values losing parenting

v0.50 -- dec.20, 2007
- added tradeskillinfoui support

v0.51b -- jan.10, 2008
- added support for periodic table interface to determine reagent availability at vendors
- identifies BOP items when displaying auction item values and reagent purchase prices


v0.52 -- jan.19, 2008
- added tooltip info for known recipes (note that only information that has been cached will show up here)

v0.71 -- oct.23, 2008
- reworked for 3.0 api (skillet support semi-functional)

v0.72 -- nov.2, 2008
- support for skillet reworked, should support standard skillet as well as my updated branch

v0.80 -- nov.22, 2008
- reworked support for all known tradeskill ui's (blizzard, advanced tradeskill window, skillet)
- removed support for tradeskill info ui

v0.91 -- feb.4, 2009
- added support for auctionmaster
- added support for auctionlite
- added support for selectable auctioneer modules
Optional Files (0)


Archived Files (6)
File Name
Version
Size
Author
Date
r88beta
41kB
lilsparky
03-26-10 03:40 PM
r84
37kB
lilsparky
09-11-09 05:33 PM
r77
37kB
lilsparky
07-01-09 05:19 PM
r72
36kB
lilsparky
06-29-09 02:04 AM
v0.91beta
17kB
lilsparky
02-06-09 11:08 AM
v0.80b
17kB
lilsparky
11-24-08 04:30 PM


Post A Reply Comment Options
Unread 08-06-08, 02:16 PM  
Dragonknight
A Kobold Labourer

Forum posts: 0
File comments: 2
Uploads: 0
well still couldnt download it
Dragonknight is offline Report comment to moderator  
Reply With Quote
Unread 08-05-08, 10:59 PM  
lilsparky
A Flamescale Wyrmkin
AddOn Author - Click to view AddOns

Forum posts: 117
File comments: 164
Uploads: 3
Re: download error

Originally posted by Dragonknight
whenever i try to download the mod i get an error that says the system cannot find file specified
weird. i just tried it and it worked for me. maybe it was a temporary glitch with wowinterface's system...
lilsparky is offline Report comment to moderator  
Reply With Quote
Unread 08-05-08, 03:21 PM  
Dragonknight
A Kobold Labourer

Forum posts: 0
File comments: 2
Uploads: 0
download error

whenever i try to download the mod i get an error that says the system cannot find file specified
Dragonknight is offline Report comment to moderator  
Reply With Quote
Unread 01-12-08, 05:52 AM  
lilsparky
A Flamescale Wyrmkin
AddOn Author - Click to view AddOns

Forum posts: 117
File comments: 164
Uploads: 3
v0.51 went out with a problem that causes the libPeriodicTable check to fail if it's not available. v0.51b fixes that issue. sorry for any inconvenience.
lilsparky is offline Report comment to moderator  
Reply With Quote
Unread 11-06-07, 06:34 PM  
lilsparky
A Flamescale Wyrmkin
AddOn Author - Click to view AddOns

Forum posts: 117
File comments: 164
Uploads: 3
Originally posted by Quiveringfinger
I get this bug message everytime I open my first trade skill window. No Idea what the problem is any Ideas ?
which version of auctioneer and enchantrix are you using? that's a problem with the enchantrix de pricing system.
lilsparky is offline Report comment to moderator  
Reply With Quote
Unread 11-06-07, 06:19 PM  
Quiveringfinger
A Kobold Labourer
 
Quiveringfinger's Avatar

Forum posts: 1
File comments: 11
Uploads: 0
I get this bug message everytime I open my first trade skill window. No Idea what the problem is any Ideas ?

Date: 2007-11-06 19:15:08
ID: 52
Error occured in: Global
Count: 1
Message: ...ace\AddOns\LilSparkysWorkshop\lilsparkysworkshop.lua line 468:
attempt to call field 'GetItemDisenchantTotals' (a nil value)
Debug:
+Wowhead_Looter\Wowhead_Looter.lua:2198:
+Wowhead_Looter\Wowhead_Looter.lua:2191
[C]: GetItemDisenchantTotals()
...ace\AddOns\LilSparkysWorkshop\lilsparkysworkshop.lua:468: LSW_itemValuation()
...ace\AddOns\LilSparkysWorkshop\lilsparkysworkshop.lua:695:
...ace\AddOns\LilSparkysWorkshop\lilsparkysworkshop.lua:613
[C]: Show()
...dOns\Blizzard_TradeSkillUI\Blizzard_TradeSkillUI.lua:137:
...dOns\Blizzard_TradeSkillUI\Blizzard_TradeSkillUI.lua:74
[C]: pcall()
Stubby\Stubby.lua:308:
Stubby\Stubby.lua:292
(tail call): ?
...ace\AddOns\LilSparkysWorkshop\lilsparkysworkshop.lua:1069: TradeSkillFrame_Update()
...dOns\Blizzard_TradeSkillUI\Blizzard_TradeSkillUI.lua:32: TradeSkillFrame_Show_ORIGINAL()
...ace\AddOns\LilSparkysWorkshop\lilsparkysworkshop.lua:1050: Original_TradeSkillFrame_Show()
LootLink\LootLink_Parsing.lua:460: TradeSkillFrame_Show()
..\FrameXML\UIParent.lua:750: UIParent_OnEvent()
[string "*:OnEvent"]:1:
[string "*:OnEvent"]:1
[C]: ?
[C]: ?
[C]: UseAction()
..\FrameXML\SecureTemplates.lua:266: SecureActionButton_OnClick()
[string "*:OnClick"]:1:
[string "*:OnClick"]:1
(tail call): ?
[C]: securecall()
..\FrameXML\SecureStateHeader.lua:998:
..\FrameXML\SecureStateHeader.lua:979
Quiveringfinger is offline Report comment to moderator  
Reply With Quote
Unread 11-05-07, 12:25 AM  
lilsparky
A Flamescale Wyrmkin
AddOn Author - Click to view AddOns

Forum posts: 117
File comments: 164
Uploads: 3
Originally posted by Fin
Note that some recipes also produce more than one item (eg, many of the cooking recipes).
recipes that produce more than one item are accounted for in the value -- or at least, they should be. there's a built-in api call to determine the number of items created. unfortunately, some items (like tailor specializations) don't report the correct number with this api call, so some items aren't currently accurate in that regard. i think for the next version, i'll indicate the number of items created in the value tooltip just so you can be sure what that number is based on and whether you need to do any extra multiplication.
lilsparky is offline Report comment to moderator  
Reply With Quote
Unread 11-04-07, 07:19 PM  
Fin
An Aku'mai Servant
 
Fin's Avatar
AddOn Author - Click to view AddOns

Forum posts: 34
File comments: 74
Uploads: 4
1) When a recipe calls for vendor items that are sold in lots, LilSparkys should calculate the cost of the actual number of items that will be used. While some recipes actually DO use 5 Imbued Vials at a time (the Major Arcane, Fire, Frost, Nature, Holy, and Shadow Protection potions do this), most recipes only use 1 vial at a time.
Note that some recipes also produce more than one item (eg, many of the cooking recipes).
Fin is offline Report comment to moderator  
Reply With Quote
Unread 11-01-07, 06:45 PM  
lilsparky
A Flamescale Wyrmkin
AddOn Author - Click to view AddOns

Forum posts: 117
File comments: 164
Uploads: 3
Originally posted by Lorelei
I found the problem. It has to do with vendor items that are sold in multiples. Alchemy is particularly bad because the profit margin is such that the relatively expensive vials throw everything off if miscalculated. For example:

Elixir of Major Mageblood: Lil Sparky Cost to make: 4.54g. AucAdv market value: 4.14g. So, it looks like these potions are unprofitable. But, when we break it down:

1x Ancient Lichen: 82s28c
1x Netherbloom: 1g71s72c
1x Imbued vial: 40s

Actual cost: 2.94g, so I should be able to make these at a profit. The 1.6g difference is because the Imbued vials are sold in lots of 5 for 2g, So LilSparkys adds 2g to the cost of every elixir instead of 40s which is the actual cost of one vial. This raises a couple of issues:

1) When a recipe calls for vendor items that are sold in lots, LilSparkys should calculate the cost of the actual number of items that will be used. While some recipes actually DO use 5 Imbued Vials at a time (the Major Arcane, Fire, Frost, Nature, Holy, and Shadow Protection potions do this), most recipes only use 1 vial at a time.

2) If possible, there should be an option to calculate reputation discounts (which will be expanded in 2.3, fyi) for vendor items. Right now there is only a discount for honored, but post 2.3 users should have an option to select exactly which reputation level they want to use for vendor costs (friendly, honored, revered or exalted) and LilSparky's should use (5%, 10%, 15% or 20%) for vendor items as appropriate. For expensive vendor items the rep discounts really can make a difference in profitability.
thanks for the bug report. v0.41 will fix that issue and give a handy price sanity checking tooltip when mousing over the item cost.

reputation discounts i'll leave for the vendor pricing mods. that's kind of beyond the scope of lsw.
lilsparky is offline Report comment to moderator  
Reply With Quote
Unread 10-31-07, 03:28 PM  
Lorelei
A Kobold Labourer

Forum posts: 1
File comments: 20
Uploads: 0
I found the problem. It has to do with vendor items that are sold in multiples. Alchemy is particularly bad because the profit margin is such that the relatively expensive vials throw everything off if miscalculated. For example:

Elixir of Major Mageblood: Lil Sparky Cost to make: 4.54g. AucAdv market value: 4.14g. So, it looks like these potions are unprofitable. But, when we break it down:

1x Ancient Lichen: 82s28c
1x Netherbloom: 1g71s72c
1x Imbued vial: 40s

Actual cost: 2.94g, so I should be able to make these at a profit. The 1.6g difference is because the Imbued vials are sold in lots of 5 for 2g, So LilSparkys adds 2g to the cost of every elixir instead of 40s which is the actual cost of one vial. This raises a couple of issues:

1) When a recipe calls for vendor items that are sold in lots, LilSparkys should calculate the cost of the actual number of items that will be used. While some recipes actually DO use 5 Imbued Vials at a time (the Major Arcane, Fire, Frost, Nature, Holy, and Shadow Protection potions do this), most recipes only use 1 vial at a time.

2) If possible, there should be an option to calculate reputation discounts (which will be expanded in 2.3, fyi) for vendor items. Right now there is only a discount for honored, but post 2.3 users should have an option to select exactly which reputation level they want to use for vendor costs (friendly, honored, revered or exalted) and LilSparky's should use (5%, 10%, 15% or 20%) for vendor items as appropriate. For expensive vendor items the rep discounts really can make a difference in profitability.
Lorelei is offline Report comment to moderator  
Reply With Quote
Unread 10-31-07, 01:24 PM  
Lorelei
A Kobold Labourer

Forum posts: 1
File comments: 20
Uploads: 0
Originally posted by lilsparky
do you have auctioneer installed as well? because auctioneer will also have some input on prices if it's installed as well as aucadvanced.

also, if a reagent hasn't been seen enough times (hardwired to 10 times atm), it will revert to the vendor purchase price -- this is to avoid contamination from people putting up vendor items at the ah (like threads and vials). if your aucadv database is small, then this might be the issue.

i'm obviously very interested in making sure the pricing is accurate, so i'd like to hear more if your prices aren't reflecting reality.
I'm going to do some more testing today and get back with some specific numbers, but no, I don't have auctioneer installed. I uninstalled it when I tried out AucAdv, and have been using it for several weeks now. I will double check to make sure I don't have the old auctioneer savedvariables, though, but I'm pretty sure I don't.

I definitely want to get to the bottom of it as well. Currently my TS window shows a very substantial loss for making virtually any alchemy item. I know that a whole lot of alchemy recipes aren't profitable, but there are some that I noticed actually do turn a profit but weren't reflected as such.
Last edited by Lorelei : 10-31-07 at 01:26 PM.
Lorelei is offline Report comment to moderator  
Reply With Quote
Unread 10-30-07, 10:55 PM  
lilsparky
A Flamescale Wyrmkin
AddOn Author - Click to view AddOns

Forum posts: 117
File comments: 164
Uploads: 3
Originally posted by Lorelei
I can't exactly pinpoint the exact issue, but the prices seem to be off when using auctioneer advanced and certain recipes with multiple numbers of the same item. I've noticed it with alchemy most prominently -- the prices shown as the costs are way higher than what I'd get by manually adding the cost of the components. The AucAdv tooltip seems to display the total cost of items shown in a tooltip -- for example, 3x mana thistle may show as 3g if I mouse over the components in the recipe but it doesn't seem as though that is the price that is used in the final calculations.
do you have auctioneer installed as well? because auctioneer will also have some input on prices if it's installed as well as aucadvanced.

also, if a reagent hasn't been seen enough times (hardwired to 10 times atm), it will revert to the vendor purchase price -- this is to avoid contamination from people putting up vendor items at the ah (like threads and vials). if your aucadv database is small, then this might be the issue.

i'm obviously very interested in making sure the pricing is accurate, so i'd like to hear more if your prices aren't reflecting reality.
lilsparky is offline Report comment to moderator  
Reply With Quote
Unread 10-30-07, 08:57 PM  
Lorelei
A Kobold Labourer

Forum posts: 1
File comments: 20
Uploads: 0
I can't exactly pinpoint the exact issue, but the prices seem to be off when using auctioneer advanced and certain recipes with multiple numbers of the same item. I've noticed it with alchemy most prominently -- the prices shown as the costs are way higher than what I'd get by manually adding the cost of the components. The AucAdv tooltip seems to display the total cost of items shown in a tooltip -- for example, 3x mana thistle may show as 3g if I mouse over the components in the recipe but it doesn't seem as though that is the price that is used in the final calculations.
Lorelei is offline Report comment to moderator  
Reply With Quote
Unread 10-24-07, 11:12 AM  
lilsparky
A Flamescale Wyrmkin
AddOn Author - Click to view AddOns

Forum posts: 117
File comments: 164
Uploads: 3
Re: Re: Re: AucAdvanced support without Auctioneer

Originally posted by Wingforce
Confirmed, thanks for the quick response and great mod. Is there a better place to be posting bugs/issues or is this the right place?
i'm using wowace as my development site. there's a thread in the forum there. because i'm keeping up to date with skillet features, i don't want to make an official release until skillet has as well or else it might break things.
lilsparky is offline Report comment to moderator  
Reply With Quote
Unread 10-23-07, 07:40 PM  
Wingforce
A Kobold Labourer

Forum posts: 0
File comments: 4
Uploads: 0
Re: Re: AucAdvanced support without Auctioneer

Originally posted by lilsparky
darned typos... update and it should work.
Confirmed, thanks for the quick response and great mod. Is there a better place to be posting bugs/issues or is this the right place?
Wingforce is offline Report comment to moderator  
Reply With Quote
Post A Reply



Category Jump:

Support AddOn Development!

You have just downloaded by the author . If you like this AddOn why not consider supporting the author? This author has set up a donation account. Donations ensure that authors can continue to develop useful tools for everyone.