P/C [Kykeon's Item Scrolling Cost Simulator]

Hey Maple Friends,

In regards to item scrolling, i've always manually run simulations of the production cost of scrolling items to better estimate their profitability margin and to gauge how lucky/lucky i've been. So I went ahead and made a tool for simulating the costs of producing scrolled items.



It works like this:

1. You enter the base information of the item you're scrolling¬



2. You Select the first scroll kind (10,30,60,70) and enter the number of passes in a row you'd like along with that scrolls current price.¬



3. Finish you can finish here or continue and complete the remaining of the rounds in similar fashion.¬



4. If it suits you, go ahead and specify the stat gain for the scrolls you're using for an accurate representation of your scrolled item.¬



5. Drop in a picture if you wanna make it pretty.¬



And that's pretty much it. It'll give you the cost of production of that item. After that, you can put in the prices you'd prefer to sell your item at and tinker with the [Luck Multiplier] setting until you match that price. (I havent quite figured out the math for auto-calculating it yet ** if anyone has any idea please message me and i'll implement its auto-calculation)¬





After playing around with this, you'll realize just how insanely lucky you'd be to scroll some of those +10 items. Prices are always sold under the cost of production, this single earring was definitely a best case item.

Here's the link to the spreadsheet, go ahead and head to File>Make A Copy.

Thanks for reading :>

¬Kykeon

 

Yeah, thats a fair observation. The free market is supply and demand and I think its in the nature of a free market that people will generally undercut production cost to sell faster. The utility in these statistics is though, for me, just a better way to differentiate between whether or not something is worth scrolling for a profit(or personal use) based on current market prices. Same goes for buying things, if I know a scrolled item is being way undersold on production cost i'm much more liable to snatch it up for being a gem. This has helped me. I hope it'll help others.

 

Ever
Yeah, there have been more than few shortcomings in the (let's call it) beta release lmao. I encountered the same dillemma. As for why the cost of production is higher: I think its just because there either isn't enough collective demand to justify selling at cost of production, and/or sellers won't hold out for long enough to sell for cost of production.

As for that bug. I think theres a discrepancy in the math for producing cost of items between rounds. I'll see if I can work my head around it when ive got more time to look at it.

As for the luck multiplier. I haven't been able to generate it mathematically/automatically in the sheet for you. I've got a script running that manually adjusts the cost of production to the a/w s/b until the prices match. Giving you the luck multiplier.

As for how its calculated to begin with, its just a multiplier on the scroll chance to succeed. e.g. A 1.5x mult on a 30% scroll raises the scrolls chance to succeed to 45%.

Selquin
You make very valid points, and you're right to throw shade on the integrity of the estimations outputted. I was aware of these things in building the sheet, but its really just beyond my scope of ability to accommodate such a complete model. Having made that concession, despite your assertion that it is 'hardly' useful-- I finished it in the hopes that it might still be moderately useful. Although, you do shine a better light on the lack of scope than I have myself, that rightly diminishes it a little more in my own mind.

And in spite of that, for me, accompanied by a little sense, I think it has been moderately useful. I am, though, starting to doubt the overall integrity of my calculation as more bugs bubble to the surface.

Thanks for the input though, I do appreciate it.