+ Reply to Thread
Results 1 to 2 of 2

Calculating a percentage

  1. #1
    Registered User
    Join Date
    08-15-2007
    Posts
    10

    Calculating a percentage

    I am writing a spreadsheet for a game I play that will help me decide which buildings to build, it's an easy calculation but problem is is I haven't messed with excel in so long, I can't think of how to do it so any help is appreciated.

    Ok here is the problem, I want to

    Buildings \ My Aim \ Land \ Current \ Build

    Buildings are the name of the buildings, my aim is the % I want, Land is how many I have built already, current is the % it is at now, and last is build, it will tell me how many of each to build.

    What I am doing is picking a build strategy and sticking with it and when I attack and new land comes in, I input how much it is, it adds to total land then the calculation tells me which buildings to build.

    Example:
    Buildings \ My Aim \ Land \ Current \ Build
    Homes \ 30% \ 40 \ 10% \ ??

    Say I input 400 total acres, that makes it 10%, I need to figure out how to tell me how to build the other 80 Homes to get it to 30%.

    Thank you in advance, it is appreciated.
    Last edited by wishblades; 07-20-2011 at 09:41 PM.

  2. #2
    Registered User
    Join Date
    07-18-2011
    Location
    Venice, FL
    MS-Off Ver
    Excel 2007
    Posts
    8

    Re: Calculating a percentage

    Me thinks the reason you have not been assisted is not because no one wants to touch it, but rather, you have not provided enough info to us NON-GAMERS (at least not familiar with your game) to understand the rules and tools necessary to complete the task.

    For example, you say you input 400 acres and that makes it 10%. Ten percent of what? What does that matter? How must it be used in the formula?

    If you explain it more clearly, I'm sure that a few wise forum members will be glad to tackle it, as it appears that it will actually be quite simple, once we know the rules and methods.

    Have a good day!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1