this is fantastic i like this
this is fantastic i like this
Updated to v0.31!
-All buildings up to level 19!
-Fir Foresters now apply the correct number of resources when buffed.
This is impressive, Aurorah! Great work!
Hey Aurorah,
My spreadsheet was getting rather long. I hope you don't mind, I added a Quantity Column. Below is a link(let me know if it does not work):
--- link removed ----
It was rather easy to do. Here is what I did.
1. Inserted a new column B and labeled is Quantity.
2. I selected columns E through AA on row 4
3. I did a find and replace for (C4+1) and replaced with (c4+1)*b4
It found 64 instances to replace
4. I then copied column E through AA from row 4 to the other rows. (5-92)
5. I put in the Quantity for all the current buildings I have to show a sample. For your spreadsheet sample, you could put 1 under Quantity. (And yes, I need trees and coal!)
If you want to incorporate it, go ahead and then I will take the doc down.
Now the other thing is if you have two buildings of the same type, but only one is upgraded or buffed, you need two have two lines for each building in the spreadsheet with a quantity of 1 and show one of them as upgraded/buffed and one line not.
Thanks for all the great work on the spreadsheet!
Last edited by toy4x4; 08-01-11 at 07:57 am. Reason: Removed link
Nevermind it all works great. Thanks so much. I was very close but this let me tweak it some.
Last edited by Meretrix; 07-30-11 at 05:42 pm.
Ill be adding this tomorrow, hopefully, after I do some testing with it. I don't know why but I feel something is off.
Didn't add it in first place because I was going to go the more detail route of having customizable times for each building. But now that I think about it I can have both for the casual player and the hardcore perfectionist.
Check your in-game mail, Meretrix
Updated to v0.32!
-Add a quantity column.
-Fir and Hardwood Foresters now work with buffs.
Thanks to toy4x4 for helping with quantity column.
Last edited by Aurorah; 07-31-11 at 10:25 pm.
Aurorah,
Thanks, Thanks, Thanks!!
I now have a excellent view into what I need to do to resolve production issues!
Excellent work. They should give you a bunch of gems!
Hey Aurorah,
Here is another suggestion. I would change Column C to default to the Building Level instead of the upgrade level.
Right now with Column C, I have to subtract one from the building level in the game to put in column C. For example, if I upgraded a building once, it now shows a 2 when I hover the mouse over it. I then have to go into the spreadsheet and put 1 in column C. Just takes a little more thinking which I don't like to do
If you changed Column C to be the "Building Level", you would simply put the number shown when you hover over it with the mouse. So in the above instance I would put the 2 in Column C instead of subtracting 1 and putting that there.
To accomplish this, here is what you would need to do:
1. Relabel Column C to be Building Level
2. Default Column C numbers to be 1 instead of 0
3. Search and replace (c4+1) with (c4) on row 4
4. Copy row 4 to the other rows as before.
Like last time, if you want to incorporate this and you want a copy of what I did in excel to do the find and replace I can give you a link again.
I did this and then compared your spreadsheet with the modified one side by side and the calculations all are the same.
Last edited by toy4x4; 08-06-11 at 06:53 am.