Reply to Thread
Page 2 of 5 FirstFirst 1 2 3 4 ... LastLast
Results 11 to 20 of 49

Thread: [Spreadsheet] Aurorah's Resource Calculator v0.1!

  1. #11
    Recruit
    Join Date
    Jul 2011
    Posts
    34
    this is fantastic i like this

  2. #12
    Settler Aurorah's Avatar
    Join Date
    Jul 2011
    Posts
    137
    World
    Zeus
    Updated to v0.31!
    -All buildings up to level 19!
    -Fir Foresters now apply the correct number of resources when buffed.

  3. #13
    Former Community Manager BB_Katealyst's Avatar
    Join Date
    Jul 2011
    Location
    San Francisco
    Posts
    528
    World
    Zeus
    This is impressive, Aurorah! Great work!

  4. #14
    Settler Aurorah's Avatar
    Join Date
    Jul 2011
    Posts
    137
    World
    Zeus

    Bug Fix!

    Quote Originally Posted by BB_Katealyst View Post
    This is impressive, Aurorah! Great work!
    Thanks! =D

    -----------------------------------------------------------------------------------

    Updated to v0.311!
    -Coking Plants now take the correct number of resources.

  5. #15
    Settler
    Join Date
    Jul 2011
    Posts
    102
    World
    Zeus
    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

  6. #16
    Recruit
    Join Date
    Jul 2011
    Posts
    7
    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.

  7. #17
    Settler Aurorah's Avatar
    Join Date
    Jul 2011
    Posts
    137
    World
    Zeus
    Quote Originally Posted by toy4x4 View Post
    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):
    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.

    Quote Originally Posted by Meretrix View Post
    Nevermind it all works great. Thanks so much. I was very close but this let me tweak it some.
    Check your in-game mail, Meretrix

  8. #18
    Settler Aurorah's Avatar
    Join Date
    Jul 2011
    Posts
    137
    World
    Zeus

    v .32!

    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.

  9. #19
    Settler
    Join Date
    Jul 2011
    Posts
    102
    World
    Zeus
    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!

  10. #20
    Settler
    Join Date
    Jul 2011
    Posts
    102
    World
    Zeus
    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.

Reply to Thread

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts