Finding a way to use Call of War in Google Sheets?
•
Hello! I hope everyone's day is going well. I am trying to see if I can use Call of war in Google Sheets. Explaining this, I am still figuring out how to strategize well, and I want to use Google Sheets. So I can make more beneficial decisions.
I thought of it when I remembered having to complete a stock market project, and the goal was for the outcome to tell you if you should sell a stock, buy one, or remain the same. The sheet used some functions and math to give you the outcome, so I'm wondering if I can make a Google Sheet that tells me if I should make tanks or infantry... some sort of thing. Does anyone have an idea on how to make this? I would appreciate all help anyone offers!
Have an amazing day,
Jonathan
4 Replies
14 Nov 2021, 20:47
Altough it is possible i don't think it's practical because the decisions you take depends on the context, your nation's doctrine and your personal doctrine. Taking into account all of those variables the ammount of possible decisions grows exponentially, and with that, the ammount of fórmulas and research you have yo do yo make a robust method.
If you wan't to use data to aid your decision-making you can do 2 things:
- Try different strategies (unit selection, how much of your army consists of that unit, etc) and keep track on notes how you felt with it, your strengths, weaknesses and your performance (k/d ratio, points collected, etc), based on that information take decisions and see if you keep that strategy
- make a Google sheet with data from units and do fórmulas of cost/damage ratio, attack, speed, time to research, etc. With that you can choose the best units according yo your prefferences
14 Nov 2021, 22:24
I'll do that.
Thank you for your guidance!
Jonathan
15 Nov 2021, 01:54
Julianc97 wrote:
Altough it is possible i don't think it's practical because the decisions you take depends on the context, your nation's doctrine and your personal doctrine. Taking into account all of those variables the ammount of possible decisions grows exponentially, and with that, the ammount of fórmulas and research you have yo do yo make a robust method.
If you wan't to use data to aid your decision-making you can do 2 things:
- Try different strategies (unit selection, how much of your army consists of that unit, etc) and keep track on notes how you felt with it, your strengths, weaknesses and your performance (k/d ratio, points collected, etc), based on that information take decisions and see if you keep that strategy
- make a Google sheet with data from units and do fórmulas of cost/damage ratio, attack, speed, time to research, etc. With that you can choose the best units according yo your prefferences
I agree with this. There are just waaaay to many variables. And oftentimes, even experienced players make the wrong choices.
Kind regards, Donk Bytro game addict and avid CoW player. "Þ" > "th" Слава Україні!
21 Nov 2021, 20:40
This game has so many combinations, attack or defensive values against different unit branches, terrain bonuses, doctrine specifications that it is impossible to break this game down into a simple formula or spreadsheet. It was possible to do this with the 1.0 COW classic version but 1.5 is way too complex.
