Minecraft / Blogs

How to create stable economy system on Your server [Updated for 1.14]

  • 54
  • 31
  • comment108
  • playlist_add
  • share
  • more_horiz
avatar vagrant326
Level 45 : Master Engineer
17
Welcome!

In this "tutorial" I want to show You how to easily solve never-ending problem of prices for many plugins allowing players to buy items.

We will use mine Minecraft Economy Manager.
Before You proceed, make sure You have MS Excel 2007, OpenOffice 3.4.1 or LibreOffice 4.0 (or newer). If You don`t, please send me an e-mail with info about it, address can be found in the sheet, or post it on Facebook. Maybe we will come with a solution how to create new version. At the moment I have no idea which other program can I use to do it.

So, now we can begin:

Step 1: Download MEM.
We honestly admit, that link goes through AdFly site. It`s our only income coming from MEM. If, for some reason, You don`t want us to get any money or You hate AdFly THAT much, old DropBox links were moved to the bottom of this blog.
[url=(Ad link removed)]Download MEM (click this)[/url]

Overall description:
As You can see, spreadsheet contains 2 sheets, "Sheet" and "Proposition".
If You want to invent prices Yourself, we will use "Sheet". If You don`t have time, invention or willingness to do this, check our "Proposition". I will describe both of them below.

Step 2a: I will begin with "Proposition", because it`s shorter and easier work. "Sheet" below.
95% of Your work is already done. Now You only have to check few things. Every server have individual availability of individual items e.g. wood - if most of Your map is desert, it should be higher than if most of Your map is forest. Even individual types of wood - oak,birch and especially pine - should have various (in respect of availability) prices. You should check almost every item, because MEM is prepared to decide which type of wood or furnace fuel will be most commonly used. Also check if on Your server, any item colored with Red is obtainable. If yes, You`ll have to invent it`s price. When You check the prices and approve them, pass over "Sheet" part below and read Step 3 now, please.

Step 2b: Now the harder way - "Sheet" description:
Take a quick look on whole spreadsheet. All items are divided to 3 groups.
Green items:
They are foundation of all calculations. Most of them are components in crafting or smelting Yellow items. This is Your job - invent basic prices. Like I wrote I didn`t include ores obtainable with Silk Touch enchantment to this group, because ores obtained this way are more expensive to smelt, so every intelligent player won`t use them this way
Yellow items:
This was our job. With every Green item added You`ll see more and more Yellow items prices ready. The point is, that those prices contains cost of production, like components, fuel for smelt etc. and taxes, explained below.
Red items:
Those items are unobtainable for players in standard conditions, however I added them in case of You decide to allow players to obtain them, so You could keep prices in one place

How to invent green prices.
Everyone have their own method. I, for example, found somewhere in the Internet, that because Coal can be found in XX layers, and it`s taking XX% of this volume and at the end of the calculations, that it should cost 8$. Then I was thinking "If Coal costs 8$ the XXXXX should cost about XX$". This is just an example. Try to invent prices in most comfortable, for You, way. But for a little help, keep in mind that price should vary in respect of: item availability (mostly), item usefulness, time and level of tool needed to obtain it. You can type prices for more than 1 item of Green items type. Also You can check Production Cost and Sell Price e.g. for whole stack - it has no matter for other prices. Every Yellow item cell has a comment which contain components which this item depend on. It`s a lot of thinking, but believe me, as You go further it gets easier. My last proposition - try in the beginning invent prices of Coal, Wood, Cobblestone and Iron Ore, because they are the main resources and good base for further prices.
Then, You`ll have to choose which type of wood will be most commonly used. This price will be used to calculate production cost of items which can be crafted with any type of planks. Usually, it will depend on size of each type of biome on Your map. If most of Your map is Forest biome, think about choosing Oak, if Taiga, try Spruce and so on. You also have to choose basic fuel. Almost always it`s Coal, but I thought it may prove itself useful. Just type ID and proceed.

Step 3: We can proceed to Taxes.
You`ll find them in "Variables" table. Numbers inside, are percents added to production cost, when Sheet calculates Sell Price. Production Cost is 100% base for Sell Price, but You can add e.g. 5% margin for seller. Then Sell Price will will be equal to 105% Production Cost. If You still don`t understand, have some fun typing random numbers in those cells. I`m quite sure, that You`ll quickly get it. I`ve added 3 types of taxes.
First one is created for servers using plugins allowing players to trade with server (like DynamicMarket). Production Cost would then be amount of money which player will get when it`s SELLING items to server. Sell Price would be amount of money player will have to pay for BOUGHT item.
If You`re using plugins allowing players to trade with themselves (like ChestShop), You can also use 2nd and 3rd option.
Collector tax is size of spread between Production Cost and Sell Price for Green Items. Crafter tax is working same way, but for Yellow Items. I`m afraid that I had no idea, why should I create Red items tax, feel free to add it to those items Yourself. If You don`t find it useful at all, leave it with "0" value, and overwrite Sell Prices with in Your own way, but remember, that You can`t get the formulas back then (if out of ctrl+z range).

Step 4: Copy prices to Your plugin & have fun because it`s finished!

Stay informed! Like MEM on Facebook!
Updates, announcements and more!

Download link - MS Office
Download link - OpenOffice
Download link - Libre Office
CreditJiFProductions
Tags

6 Update Logs

Update #6 : 12/09/2014 3:05:12 pmDec 9th, 2014

Thanks to pizz11, added current version.
LOAD MORE LOGS

108 replies

1
08/19/2019 6:04 pm
Level 1 : New Miner
SchrottiGER
can you provide a 1.12.2 version + Link please ?
1
08/23/2019 3:43 pm
Level 45 : Master Engineer
vagrant326
1
08/23/2019 3:44 pm
Level 45 : Master Engineer
vagrant326
Oh crap :/
Could You message me on fanpage or on email in spreadsheet? PMC censors my links.
1
07/27/2019 11:35 am
Level 15 : Journeyman Network
killer5362
I have been a fan of this post since day 1 and I thank you for updating it to the most recent version.
1
08/03/2019 2:16 pm
Level 45 : Master Engineer
vagrant326
Thanks :) That means a lot for me :)
1
07/08/2019 8:37 pm
Level 1 : New Network
ItsDamian626
Hey there vagrant326.
Thank you for making Economy Excel that calculates prices it really helps out when making Shops.
1
07/15/2019 6:52 pm
Level 45 : Master Engineer
vagrant326
I'm happy to hear that :)
1
04/25/2019 8:07 pm
Level 1 : New Miner
mynamejeff318
So ill get right to the point, the 1.14 version was released, but i was already working on the 1.13.2 version of the sheet. Is there a way to combine the two sheets, without breaking the formulas?
1
04/27/2019 6:30 pm
Level 45 : Master Engineer
vagrant326
I understand, that You had prepared some prices already.
You should be fine if You rewrite only prices of green items (and red ones if You use them).
Unfortunately, You can't copy-paste stuff, because cell addresses changed
1
04/27/2019 6:48 pm
Level 1 : New Miner
mynamejeff318
Thanks for the info, i forgot to say this in my first post, but this sheet is really well made and it really speeds up the otherwise very tedious process of making a balanced shop. Thanks for all the hard work you put into it, and good luck on all your future projects too!
1
05/04/2019 7:20 pm
Level 45 : Master Engineer
vagrant326
Thanks :)
1
04/09/2019 9:50 am
Level 1 : New Miner
TheRobLP
Love it. Nothing more to say.
1
04/15/2019 5:19 pm
Level 45 : Master Engineer
vagrant326
I'm happy to hear that :)
1
01/16/2017 4:33 am
Level 19 : Journeyman Miner
Disorbs
do you have any good prices already made for a skyblock with spawners and ore gen
1
01/16/2017 9:06 am
Level 45 : Master Engineer
vagrant326
Unfortunately no, but I can help You work something out. Just contact me via email or even better, through Facebook fanpage.
1
01/14/2017 7:52 am
Level 1 : New Explorer
Varo95
There is a mistake on id 361 pumkin seeds, 4 seeds given from pumkin (86), both values are on green and players abuse them on my server xd Please fix that too ^^
1
01/15/2017 6:46 pm
Level 45 : Master Engineer
vagrant326
Will do! Sorry for that
1
12/28/2016 9:11 pm
Level 23 : Expert Miner
TrulyUnique
Please make one for notepad++ i can't use any of these :(
1
01/04/2017 6:20 am
Level 45 : Master Engineer
vagrant326
Could You send me an email on jifproductions2009(a t)gmail.com ? Maybe we can work something out.
1
12/25/2016 11:17 am
Level 1 : New Explorer
Varo95
You need to fix End Stone Bricks on the table, because it's red, when they got a craft: http://minecraft.gamepedia.com/End_Stone_Bricks
1
12/28/2016 8:31 pm
Level 45 : Master Engineer
vagrant326
I'm not sure if we didn't speak about this on fanpage already, because I've got identical report there :)
1
12/30/2016 5:09 pm
Level 1 : New Explorer
Varo95
Yeah i'm the same who talks u on facebook, bu i put it here first jajaja :)
1
11/10/2016 7:12 am
Level 15 : Journeyman Network
killer5362
Thank you so much. Every year I look for this blog post and every year I find it, I am so grateful. You my friend have earned a diamond, favorite, and subscriber!
1
11/10/2016 2:57 pm
Level 45 : Master Engineer
vagrant326
I proud to hear that. I hope we will meet here in the future! :)
1
11/15/2016 1:15 pm
Level 15 : Journeyman Network
killer5362
Thanks again for including new items!
1
11/15/2016 1:14 pm
Level 15 : Journeyman Network
killer5362
Glad to see your reply.

So I figured out a way to further enhance your stable prices file..
ShopGUI+ lets you make a shop and it looks nice. It lets people see what they are buying, change the amount of items they buy and sell, and overall works well with the stable prices.

Would you like a copy of the config once I'm done? (Anyone? just reply)

*Note: I'm not making any irl money by advertising this plugin and am just helping others*
1
11/18/2016 6:41 pm
Level 45 : Master Engineer
vagrant326
I could eventually use plugin's config file which contain prices.
1
10/23/2016 12:02 pm
Level 1 : New Engineer
3ssej_
It would be very cool if you could upload this to google, as they have a feature every similar to Excel, but you do not need to download any program.
Thanks for doing this though, it is very helpful.
1
10/29/2016 7:12 pm
Level 45 : Master Engineer
vagrant326
I'm thinking about that a lot but for some reason I can't decide if I should and want to do that. It's a little complicated :)
1
09/02/2016 5:40 pm
Level 5 : Apprentice Miner
mcwintercraft
you forgot red sandstone stairs (180)
also 183-187,202,203
there is also a comment about end stone bricks that needs to be removed
on ms office version
1
09/22/2016 5:13 pm
Level 45 : Master Engineer
vagrant326
Update is now online. Thanks for Your help!
1
09/08/2016 8:34 am
Level 45 : Master Engineer
vagrant326
I will check that as soon as possible
1
07/13/2016 8:58 pm
Level 1 : New Miner
TheSurvivalCommunity
It wont let me enable editing when I have opened the file ???
1
07/14/2016 6:27 am
Level 45 : Master Engineer
vagrant326
Spreadsheet has no security measures. No passwords, no protection.
Check Your Office package. MS Office 2015 opens files downloaded from Internet in "read-only" mode in order to protect Your computer. However, it should allow You to enable editing.
1
05/23/2016 10:50 am
Level 1 : New Miner
Don_El
get an update to 1.9?
1
05/23/2016 7:03 pm
Level 45 : Master Engineer
vagrant326
oh my God, so stupid oversight. new version was available for weeks on website but I forgot to update dropbox files. I'm terribly sorry for that...
1
05/23/2016 7:06 pm
Level 45 : Master Engineer
vagrant326
I've updated dropbox files. Sorry again
1
01/26/2016 11:42 pm
Level 1 : New Miner
TheGamingGattsby
Hey I think you should add something that converts it so you can copy and paste it to a worth.yml file for essentials. i am converting it all manually now. anyway thanks this really helped me and saved me tons of time.
1
02/05/2016 2:49 pm
Level 45 : Master Engineer
vagrant326
There was a community-made tool for Essentials, but unfortunately it got outdated and is no longer supported by it`s author. I was trying to address this issue with app for PC but for the next few weeks I`ll be really busy.
1
10/23/2015 7:45 pm
Level 1 : New Miner
TGP_TomParkinson
Hello, the adfly link no longer works.

Please could you repost a working link.

Thank you
1
10/26/2015 3:47 pm
Level 45 : Master Engineer
vagrant326
Could You please describe what isn`t working?
I`ve just checked and everything works fine...
1
08/17/2015 10:32 am
Level 3 : Apprentice Network
ScoutGod
This link is a virus. As soon as I clicked in Malwarebytes went off.
1
08/18/2015 3:52 pm
Level 45 : Master Engineer
vagrant326
As I said in tutorial, link goes through AdFly. Could You report them that issue? They are responsible for security of this link.
1
01/15/2015 4:04 pm
Level 1 : New Miner
andaray
Adfly (the download links from site) did not work. I'm forced to try the download links on below, but ill still click the initial link, because you deserve it for saving people the time to do it on their own.
1
01/17/2015 9:09 am
Level 45 : Master Engineer
vagrant326
What happens when You click that link?
In my browser it works perfectly good!
1
01/07/2015 3:26 pm
Level 5 : Apprentice Network
EnixGaming
Can't download from your adfly link. can you provide a different adfly link? it just freezez on the adfly page
1
01/07/2015 6:10 pm
Level 45 : Master Engineer
vagrant326
It works properly for me. Try checking Your AdBlock or similar software!
1
12/29/2014 2:23 pm
Level 4 : Apprentice Architect
GamingNorge
Trying it out now..
1
12/30/2014 4:55 pm
Level 45 : Master Engineer
vagrant326
And?
1
01/08/2015 3:39 pm
Level 4 : Apprentice Architect
GamingNorge
Worked fine, exept that i wont probably use it, i might shut my whole store down and create a new one witn new prices, but its a good guide.

Planet Minecraft

Browse

Site

© 2010 - 2019
planetminecraft.com

Welcome