DeletedUser
Guest
have you ever seen a loan rate calculator, online? one where you plug in various values, like the amount you want to borrow, the interest and the monthly payment you can afford, and it figures out how long the loan term will be? or you plug in the amount, the interest rate and the term, and it calculates your monthly payments? sometimes, they're even in javascript form, and you have a little slider that you can move back and forth.
while mine's not quite as elaborate as all that, i've put together an MS EXCEL spreadsheet to figure out how to optimise your resources to calculate your building upgrade times more precisely! :icon_idea::icon_idea::icon_idea:
you plug in the:
1.) resource production rate [from your village overview screen]
2.) name of the target building [just as a reminder]
3.) resources required [by clicking on the village headquarters]
4.) current resource supply [from near the top of most pages]
and then comes the thinking part. :icon_eek::icon_sad::icon_eek::icon_sad:
you have to work out which resources you can sell and which ones you need to buy, to equal out the time you'll need to have them all be finished at nearly the same minute!
right now you're probably thinking, "well, that's what i'm doing now, einstein!" :icon_confused:
ah, yes! but how many times have you had one resource fill up to the point you want, only to have to wait another ten or fifteen minutes, because you figured wrong, hmmm...??? :icon_twisted:
this spreadsheet makes doing that figuring a little less complicated. mainly, because it's doing most of the figuring for you! :icon_biggrin:
here are a series of pix, explaining how it works:
let's say you want to upgrade your village headquarters to level 22.
and let's also assume that your timber camp, clay pit and iron mine are at levels 17, 19 and 14, respectively.
this shows what the sheet looks like after filling in initial data.
http://home.att.net/~oxo/TW/TW_calc_1.jpg
[note that cell C7 is highlighted, because i had to hit the left-arrow key after entering the 0 in D7, in order for that entry to register. you never have to hit the enter key. just numbers and arrow keys. oh, yeah... and the minus sign, but that's not until the next step.]
my clay will be ready in just under 12½ hours, but i won't have enough iron for more than 22 hours!!! the difference is so huge, i thought trading as many as 1000 units might be a good, first guess.
i typed -1000, hit the right-arrow key, typed 1000, and hit the left-arrow key again, to register my second entry.
http://home.att.net/~oxo/TW/TW_calc_2.jpg
[notice how the minus number is shown in red, and in parentheses, and how that cell is highlighted, again, after my last entry.]
ok, so clay is up to 14:34, but timber's now the long-runner, at 19:36
i typed -2000 [to add another -1000 to the -1000 that was already there,] hit the left-arrow key, typed 1000, and hit the right-arrow key, to register the last entry
http://home.att.net/~oxo/TW/TW_calc_3.jpg
now, clay is somewhere in between timber and iron, so i'll need to balance those two out
because iron production is so slow, a little goes a long way. i tried shifting only 100 timber over to iron by hitting the left-arrow [to make timber the active cell,] typed 900, hit the right-arrow key *twice* [to make iron the active cell,] typed 1100, and hit the left-arrow key [to register the entry]
http://home.att.net/~oxo/TW/TW_calc_4.jpg
after another few tweaks, i got all three resources to come in just under 17 hours, and all in the same minute! [this finalisation may vary by a minute or two, either way, once more and more resources are built up.]
http://home.att.net/~oxo/TW/TW_calc_5.jpg
what i have just achieved is not only knocking nearly FIVE AND A HALF HOURS off the total time i have to wait for my resources to accumulate to the point i can upgrade the building of my choice, but i also know *exactly* how many units of which resource to trade, to optimise that wait!
:icon_smile::icon_biggrin:
if you want to d/l a BLANK copy of the spreadsheet, you can get it from here:
http://home.att.net/~oxo/TW/TW_calc.xls
there's a likely possibility that you'll need MS OFFICE, in some form or other, in order to access an MS EXCEL spreadsheet. this one was built on office 2000.
most cells in the spreadsheet [the ones that are black-on-grey] are "protected," meaning you can't change the values in those cells. that's so you can't accidentally screw up the calculation functions. the only cells you can change data in, are the ones you need to.
you will notice, right away, a few differences from my demo pix:
a.) a division by zero error in line 9, when you open it, which will go away once you plug numbers into line 2.
b.) the colours are a bit different. you can alter these if you first un-protect the sheet in your tools menu, but i would entreat you to protect it again, *immediately* after making any changes, so you can screw something up while entering your data. [trust me on this one; i learned through unpleasant experience.]
c.) the font is different. i like the swirly letters. again, if you un-protect the sheet, you can use whatever font you want, but protect it again, afterwards.
if someone wants to upgrade this into a javascript, that would make it more user friendly for more users. i'd sure love a copy of it, if you do. i don't do java. it took me three days to put *this* one together! [and you should *see* that calculation in line 9!!! :icon_eek:]
take care, and happy upgrading to one and all!
blingadore
while mine's not quite as elaborate as all that, i've put together an MS EXCEL spreadsheet to figure out how to optimise your resources to calculate your building upgrade times more precisely! :icon_idea::icon_idea::icon_idea:
you plug in the:
1.) resource production rate [from your village overview screen]
2.) name of the target building [just as a reminder]
3.) resources required [by clicking on the village headquarters]
4.) current resource supply [from near the top of most pages]
and then comes the thinking part. :icon_eek::icon_sad::icon_eek::icon_sad:
you have to work out which resources you can sell and which ones you need to buy, to equal out the time you'll need to have them all be finished at nearly the same minute!
right now you're probably thinking, "well, that's what i'm doing now, einstein!" :icon_confused:
ah, yes! but how many times have you had one resource fill up to the point you want, only to have to wait another ten or fifteen minutes, because you figured wrong, hmmm...??? :icon_twisted:
this spreadsheet makes doing that figuring a little less complicated. mainly, because it's doing most of the figuring for you! :icon_biggrin:
here are a series of pix, explaining how it works:
let's say you want to upgrade your village headquarters to level 22.
and let's also assume that your timber camp, clay pit and iron mine are at levels 17, 19 and 14, respectively.
this shows what the sheet looks like after filling in initial data.
http://home.att.net/~oxo/TW/TW_calc_1.jpg
[note that cell C7 is highlighted, because i had to hit the left-arrow key after entering the 0 in D7, in order for that entry to register. you never have to hit the enter key. just numbers and arrow keys. oh, yeah... and the minus sign, but that's not until the next step.]
my clay will be ready in just under 12½ hours, but i won't have enough iron for more than 22 hours!!! the difference is so huge, i thought trading as many as 1000 units might be a good, first guess.
i typed -1000, hit the right-arrow key, typed 1000, and hit the left-arrow key again, to register my second entry.
http://home.att.net/~oxo/TW/TW_calc_2.jpg
[notice how the minus number is shown in red, and in parentheses, and how that cell is highlighted, again, after my last entry.]
ok, so clay is up to 14:34, but timber's now the long-runner, at 19:36
i typed -2000 [to add another -1000 to the -1000 that was already there,] hit the left-arrow key, typed 1000, and hit the right-arrow key, to register the last entry
http://home.att.net/~oxo/TW/TW_calc_3.jpg
now, clay is somewhere in between timber and iron, so i'll need to balance those two out
because iron production is so slow, a little goes a long way. i tried shifting only 100 timber over to iron by hitting the left-arrow [to make timber the active cell,] typed 900, hit the right-arrow key *twice* [to make iron the active cell,] typed 1100, and hit the left-arrow key [to register the entry]
http://home.att.net/~oxo/TW/TW_calc_4.jpg
after another few tweaks, i got all three resources to come in just under 17 hours, and all in the same minute! [this finalisation may vary by a minute or two, either way, once more and more resources are built up.]
http://home.att.net/~oxo/TW/TW_calc_5.jpg
what i have just achieved is not only knocking nearly FIVE AND A HALF HOURS off the total time i have to wait for my resources to accumulate to the point i can upgrade the building of my choice, but i also know *exactly* how many units of which resource to trade, to optimise that wait!
:icon_smile::icon_biggrin:if you want to d/l a BLANK copy of the spreadsheet, you can get it from here:
http://home.att.net/~oxo/TW/TW_calc.xls
there's a likely possibility that you'll need MS OFFICE, in some form or other, in order to access an MS EXCEL spreadsheet. this one was built on office 2000.
most cells in the spreadsheet [the ones that are black-on-grey] are "protected," meaning you can't change the values in those cells. that's so you can't accidentally screw up the calculation functions. the only cells you can change data in, are the ones you need to.
you will notice, right away, a few differences from my demo pix:
a.) a division by zero error in line 9, when you open it, which will go away once you plug numbers into line 2.
b.) the colours are a bit different. you can alter these if you first un-protect the sheet in your tools menu, but i would entreat you to protect it again, *immediately* after making any changes, so you can screw something up while entering your data. [trust me on this one; i learned through unpleasant experience.]
c.) the font is different. i like the swirly letters. again, if you un-protect the sheet, you can use whatever font you want, but protect it again, afterwards.
if someone wants to upgrade this into a javascript, that would make it more user friendly for more users. i'd sure love a copy of it, if you do. i don't do java. it took me three days to put *this* one together! [and you should *see* that calculation in line 9!!! :icon_eek:]
take care, and happy upgrading to one and all!
blingadore
Last edited by a moderator:
34:13 ; 
28:53 ; 
41:55