So, for that item with a DBRegionMarketAvg value of 27500g, this would equate to 27500g * 67.5 / 100 Which is the same as 67.5% 27500g = 18562g50s Now all you need to do is multiply DBRegionMarketAvg with it and divide it by 100Р”ВBRegionMarketAvg * min(max((DBRegionMarketAvg- 5000g)*(85-50)/(50000g-5000g)+50, 50), 85) / 100 Now this will always equate to something in between 50 and 85 Now, we want to ensure that this can never be lower than 50% and never higher than 85% So we wrap it in a max() and a min() So now it will look like this: So, if DBRegionMarketAvg is 27500g as in our example earlier this string will equate to 68c, (67.5% rounded up) So far this formula will spit out a percentage in copper (DBRegionMarketAvg - minvalue)*(maxpercentage-minpercentage)/(maxvalue-minvalue)+minpercentage So this is how we build that linear function Remember we said, for items worth 50k or above, use 85% So for items worth 50k or above, use 85% so an item worth 100k won't use 110% It would use 85%

Then you'd end up with two points P1(5000g, 50%) and P2(50000g, 85%)Р”В«ased on these two points you can now have tsm calculate the percentage for any given value So lets say an item has a value of 27500g That's exactly in the middle between the two values So the resulting percentage will be exactly in the middle between the two percentages So for an item with a value of 27.5k you'd use 67.5% So I went with:Р”Р‡or items with a value of 5k or below, use 50%Р”Р‡or items with a value of 50k or above, use 85% So in order to build this linear operation, you first have to define 2 points on that line. Thanks for all the patience you have provided me. Also a big shout out to BilisOnyxia for helping me with building this string. So we will build part 3 of the operation first, then add in the other little bits at the end. This is a more stable number and once you start getting into selling higher value transmog, you need to use more stable numbers or you risk letting your item go for way too cheap. I also wanted to use RegionMarketAvg for the pricing reference for all items >1000g. I wanted smooth gradual increases in prices as the value of the item went up. As an example, a 4,999g item might sell at 60% and a 5,001g item might sell at 80%. I could have gone with nested if functions but that would result in large jumps in prices.

I wanted to sell all the cheap transmog 1000g) to slightly increase as the price of the transmog increased. My idea going into it was that I wanted the operation to do a number of things: Then I wanted to make a really solid operation for transmog. It really doesn't matter how it's sorted, doesn't change any of the operations, it's just more for visual appeal. So I've re-sorted all the transmog based on 70% avg(dbregionmarketavg, dbglobalmarketavg). The sorting feature I needed wasn't implemented until this week. So guys, I finally updated my transmog group as promised. RAW Paste Data Sheyrah's Transmog Operation Explained

Shey tsm4 transmog