Azalyn

Operations

Jun 29th, 2021 (edited)
345
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.57 KB | None | 0 0
  1. Need to create 4 Crafting and Material operations with varies changes on posting
  2. Crafting (professions group)
  3. Details > match stack size NO
  4. Posting > stack size (1, 5, 10, 20)
  5.  
  6. Minimum price
  7.  
  8. first(first(105%vendorbuy,105%minsell ,105%crafting),35%min(DBMarket, DBRegionMarketAvg, DBRegionHistorical))
  9.  
  10. Normal Price
  11.  
  12. max(250% first(Crafting, AvgSell)/0.95, 250% first(max(DBMarket, DBRegionMarketAvg), DBRegionHistorical), 240% VendorSell/0.95)
  13.  
  14. Max price
  15.  
  16. max(1000% Max(Crafting, AvgSell)/0.95, 1000% first(max(DBMarket, DBRegionMarketAvg), DBRegionHistorical), 240% VendorSell/0.95)
  17. ___________________________________________________________________________________________________________________________________
  18.  
  19. Material (Raw mats, Reputation items)
  20. Details > match stack size NO
  21. Posting > stack size (1, 5, 10, 20)
  22.  
  23. Minimum price
  24.  
  25. min(35%avgsell,15%min(min(DBMarket, DBHistorical, DBRegionMarketAvg, DBRegionHistorical), VendorSell/0.95))
  26.  
  27. Normal Price
  28.  
  29. first(min(250%avgsell/0.95),250% avg(DBMarket, DBHistorical, DBRegionMarketAvg, DBRegionHistorical))
  30.  
  31. Max Price
  32.  
  33. first(min(1000%avgsell/0.95),max(1000% avg(DBMarket, DBHistorical, DBRegionMarketAvg, DBRegionHistorical), VendorSell/0.95))
  34. ____________________________________________________________________________________________________________________________________
  35.  
  36. BoE
  37. Details > match stack size NO
  38. Posting > stack size 1
  39.  
  40. Min price
  41.  
  42. max(110% AvgBuy / 0.95, iflt(first(DBRegionMarketAvg, DBRegionHistorical), 1000g, 25% min(DBMarket, first(DBRegionMarketAvg, DBRegionHistorical)), first(DBRegionMarketAvg, DBRegionHistorical) * min(max((first(DBRegionMarketAvg, DBRegionHistorical) - 5000g)*(85 - 50)/(50000g - 5000g) + 50, 50), 85) / 100),102.%vendorsell,105%destroy)
  43.  
  44. Normal price
  45.  
  46. 250% max(150% AvgBuy / 0.95, iflt(first(DBRegionMarketAvg, DBRegionHistorical), 1000g, 75% min(DBMarket, first(DBRegionMarketAvg, DBRegionHistorical)), first(DBRegionMarketAvg, DBRegionHistorical) * min(max((first(DBRegionMarketAvg, DBRegionHistorical) - 5000g)*(85 - 50)/(50000g - 5000g) + 50, 50), 85) / 100))
  47.  
  48. Max price
  49.  
  50. min(750% max(220% AvgBuy / 0.95, iflt(first(DBRegionMarketAvg, DBRegionHistorical), 1000g, min(DBMarket, first(DBRegionMarketAvg, DBRegionHistorical)), first(DBRegionMarketAvg, DBRegionHistorical) * min(max((first(DBRegionMarketAvg, DBRegionHistorical) - 5000g)*(85 - 50)/(50000g - 5000g) + 50, 50), 85) / 100)), 9999999g99s99c)
  51.  
  52. _________________________________________________________________________________________________________________________________
Add Comment
Please, Sign In to add comment