Yet another Production Calculator (v. 2.1)
•
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.
Facebook
Twitter
Youtube
Discord
Comments
Good job !
Vote
Thanks for the awesomeness
v19 s118
great work! 👍
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 🙂
Thank you very much 🙂
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!!
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
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.
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.
Good job !
Good job !
very interesting!
o7
Дякую друже, як завжди твої творіння приносять більше задоволення від цієї гри!
п. с. не зважай на "експертні" коментарі клоунів типу Quen Tuta
І тобі дякую 🙂
Щодо Queen TEUTA, то нічого поганого він не написав, а по ділу. До речіб він один із 2х (!) людей, хто задонатили по 10к, за що я їм дуже вдячний.
Ай, хитрюга 😃
Щиро дякую ❤️
😉
o7