Join the new world

Already have an account? Login



What is this?

You are reading an article written by a citizen of eRepublik, an immersive multiplayer strategy game based on real life countries. Create your own character and help your country achieve its glory while establishing yourself as a war hero, renowned publisher or finance guru.

Yet another Production Calculator (v. 2.1)

Day 5,661, 08:56 • Published in Lithuania

• by driver sti

Hi all.
Almost 3 months ago I wrote an article about my Production Calculator.
Today I'm happy to release the version 2.0.
I added all countries. Their regions are being loaded automatically.
Also, I implemented an automatic update of the price of resources and goods so you don't need to do this manually. Price is fetched from eRepublik.tools.
Basically, you need to input the number of your factories only.

ATTENTION! Do not change the original file! You have to copy it to your space.

If you find my work helpful consider donations. It will keep my motivation to do more for you.

Thank you in advance.

P.S. Yes, there might be bugs in the calc, so do not hesitate to let me know if you spot them.

P.S.S. Many thanks to those who helped me find the bugs. I have solved everything we found. The latest version is v.2.1.
You can find the list of changes on the corresponding sheet of the document.

Comments

Turnbeutel Day 5,661, 09:04

Good job !
Vote

Judas H Christ Day 5,661, 09:42

Thanks for the awesomeness

Brotling Day 5,661, 09:51

v19 s118

great work! 👍

AZEmLB Day 5,661, 09:59

Nice article.
Remind me of old days when articles were published everyday on each country regarding almost everything, and now press is pretty much dead!
Endorsed + a little donation 🙂

driver sti Day 5,661, 12:51

Thank you very much 🙂

Little Beast Day 5,661, 10:30

Amazing! Thank you on working on this and sharing!

Just a little note - if prices are taken from Ereptools, then they are lowest in the market. There are sometimes two items or just very low quantity below market price. There is no way to work around this - only manual input.
So you should just keep that in mind (that raw might cost more than calculated and that final goods might also bring in more revenue than expected).

But overall very great tool!!

AZEmLB Day 5,661, 11:12

I believe you are right in this case, so I think it would be a solution to take as a basis the fulfillment of one or two conditions to determine the lowest price.
for example:
1) the minimum quantity of the product from which it was received as the cheapest offer,
2) or the average of 3 offers in the same country from which the minimum price is taken

driver sti Day 5,661, 12:59

Thank you for your kind words and notice. I'm aware of this case and mentioned it in point 4 on the first page. Actually, you can pass the price you need, because the original file can be edited by me only. Other users have to copy it to their space.

driver sti Day 5,661, 13:03

Queen TEUTA, it was quite challenging to automate all these things, and considering additional cases will overcomplicate formulas. From my point of view, the current state is quite an optimal solution. Every user can modify their copy as they see fit.

Roberrto Day 5,661, 10:37

Good job !

windows2012server Day 5,661, 13:06

Good job !

chris jonadicus Day 5,661, 14:43

very interesting!

Driver of ufo Day 5,662, 09:30

Anchik De Elite Day 5,663, 00:08

Дякую друже, як завжди твої творіння приносять більше задоволення від цієї гри!

п. с. не зважай на "експертні" коментарі клоунів типу Quen Tuta

driver sti Day 5,663, 03:13

І тобі дякую 🙂
Щодо Queen TEUTA, то нічого поганого він не написав, а по ділу. До речіб він один із 2х (!) людей, хто задонатили по 10к, за що я їм дуже вдячний.

driver sti Day 5,663, 03:28

Ай, хитрюга 😃
Щиро дякую ❤️

Anchik De Elite Day 5,663, 03:31

😉

myAnguish Day 5,663, 06:17

Ukranian Dreamer Day 5,876, 06:21

Топовий калькулятор, користуюся завжди, лиш доробив собі колонки "Payback (days)" для FRM/WRM і ще планую такуж додати і до виробничих заводів

Post your comment