+ Reply to Thread
Page 1 of 3 123 LastLast
Results 1 to 10 of 27
  1. #1

    Valor Excel Sheet

    I know that many serious Valorians use MS Excel to keep track of their Valor cities. I decided to share mine (developed over the course of an older world) and I'll update it from time to time with bug fixes and suggestions any of you may have to improve it for the community.

    Download Below
    Master Sheet Distro (V1.181)
    - Created a public password (GreatSphinx07) for the following tabs:
    - - Overview
    - - Names
    - - Land Time
    - - Launch Time
    - - Valor
    - NOTE: More unsuccessful attempts at figuring out the precise behavior of the Battle System are noticeable in several places throughout this sheet. The Battle Sim is not fully operational
    Master Sheet Distro (V1.179)
    - Updated Auto Filters (Macros need to be enabled)
    - Cleaned out my old city information (download V1.173 for example of sheet usage)
    - Expanded Guild Logs to 100 players
    - Minor Aesthetic improvements to Attack Table
    - Deleted un-needed hidden pages.

    Master Sheet Distro (V1.173)

    Features:

    Overview Page
    This is a very basic overview page. It has a breakdown of some built-in filters, and a map showing how many cites you have in a particular region, as well as a count of your total troops.

    City Organizer
    Some people use name sequences for figuring out where cities are, but for people like me who use names, things become a little disorganized. The city planner lets you input your city name and coordinates. This will automatically calculate your region. Additionally, you can keep track of how many troops you have in a city, and make basic notes on any resources you have shipping out/in.

    I have basic tags for city type (A = Attack, D = Defense, S = Scholar or Split (whatever)) and a Status tag (Ready, Attacking, Supporting, Building). There are filters applied to this page so you can sort by Region, Field Distance (for another page), City Type, Status, and the various troop types).

    Attack Table
    Some of you may be familiar with the Battle Planner on the iTunes store. It's a great app but the way it would crash annoyed me to no end. So I created an Attack Table that does the same thing as the Battle Planner, up to 40 Attacks.

    Note: I've shared my sheet with a few guild mates, and some Windows users reported having trouble with the drop down menu's I used for the Unit Selector. I think this is a Mac-to-Windows issue with Excels' developer tab.

    Claims Sheet
    This was a joint task between myself and an ally. We were tired of a crossfires so we created an online claims sheet for the alliance to use. It majorly cut back on time wasted with crossfire and it creates a nicely formatted list for KakaoTalk coordination rooms. The Basic idea, is that if the same coordinate pair is typed in twice, you're alerted so you can deny a claim.

    Calculators
    Various Calculators, including operational Land/Launch Travel Time Calculators.
    Additionally, there is a working-progress Simulator, with a built-in travel time and haul calc.

    Info Page
    Basic Valor Info page with data for how much food building upgrades take and wall bonuses.

    Guild Tracker / Log
    Gotta' tell you, these are handy in a war. My trackers currently only holds information for up to 25 players right now. (At least I think that's what I stopped it at.)

    But it lets you track the number of truces, the point growth between your current and last record, the percent growth between the current and last record, sequential instances/days of no growth, and overall guild growth (points and percentages).

    There are four of these available:
    1 - Personal Guild
    2 - Enemy Guild
    3 - Watched Guild
    4 - Watched Guild
    Last edited by Matthew618; 04-18-2013 at 01:35 AM.

  2. #2
    Nice work on that one bud. More to the point though, good work on releasing this to the 'public'.
    ┏( -_-)┛..::LtFarrk::..┗(-_- )┓

  3. #3
    Lion of Valor LordFirefall's Avatar
    Join Date
    May 2012
    Location
    Montival
    Posts
    1,011
    Definitely nice work
    W95 Praetorian Guard Guild Leader
    Kakao: LordFirefall or Firefall

  4. #4
    Great work .. love it.

  5. #5
    Very cool, kudos for the public release.

  6. #6
    Glad you all like it. I uploaded a new version that is blank with a few modifications.

  7. #7
    Having done nearly the same work, I gratz the work made...

    Contact me and/or I'll contact you if anyone of us find the mechanics of scouts fighting, rams and ballistas leveling down, ...

    ;-)

  8. #8
    Quote Originally Posted by MyName999 View Post
    Having done nearly the same work, I gratz the work made...

    Contact me and/or I'll contact you if anyone of us find the mechanics of scouts fighting, rams and ballistas leveling down, ...

    ;-)
    The formula for scouts is as follows:
    Attacker Scout Loss:
    (Attacking Scouts * -8%) + (Defending Scouts * 50%)
    or
    (Attacking Scouts * -0.08) + (Defending Scouts * 0.5)

    Defending Scouts die as normal troops

    I've figured out some of the wall/rams/ballista but not enough to have it operational in Excel yet.

  9. #9
    Great thx for the info

  10. #10
    Pretty useful, I used to use that too.

Posting Permissions

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