Museum Calculator

So this is rather novel. It's a total pain working out whether it is worth buying plushies to swap for points. On this spreadsheet you enter in the green cells, the average plushy price (which is only used to weight relative values) and the price you are selling points for.

Any suggestions are welcome

 

https://docs.google.com/spreadsheets/d/1LS8roZ0u7Vx7L_bW_jWj6BBZYdQqLxbcMoTK56yytYk/edit?usp=sharing

Use Control-K to make it a clickable link. That goes in as the url and you can have anything for the tag such as Museum Calculator.

Thanks. I also need to learn how to grab current data so you don't have to type it in. But the maths is the main thing: the real value of a plushy's trade in value depends on two variables: the value of other plushies and the value of points.

Simple to do that.

Use API.

I suggest having the API every 2-6 hours refresh and take the top 3 bazaars and the value, then find the average of those 4 values, then use that as your value for the said plushie or flower. 

Then take the average of the first 5-10 points and the current point market value to find that.