Take the 2-minute tour ×
Arqade is a question and answer site for passionate videogamers on all platforms. It's 100% free, no registration required.

I am playing a game (Valor on iPad) and several people are attacking a single city. We're all different distances away and have various troops that have different travel times. We need to be able to pick a time for us to hit the city, then count back the travel durations to determine what time we need to kick off each unit's attack.

Yes, I can do this on paper, but there are so many units and so many starting cities that it'd be great if someone could show me how to use Excel or something to do the computations.

share|improve this question
    
Pretty awesome question :) –  iber Nov 2 '12 at 11:14
    
Reminds me of troubles with Travian - there you had a very similar problem, and people used online calculators for coordinated attacks. –  Humungus Apr 27 at 9:15
add comment

1 Answer 1

Using variables in some kind of programming language would be the easiest, I think. I would just have a travel time variable for each location, and then a variable for each unit's travel time. Then just multiply the amount of each unit by that unit's travel time variable, then add or multiply that by the location travel time variable, depending on how the game works.

You could just do it on paper though, it might just take longer.

share|improve this answer
    
would you mind mentioning a basic algorithm for the solution? –  DrFish Nov 2 '12 at 9:19
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.