Formation Spreadsheet

[motrin]

for the spreadsheet, how to determine the arrows?

Haven't really determined a way. I've toyed with putting red arrows on players that have 1 or greater on their block. Blue arrows on players with less than 1.

Sent from my SAMSUNG-SM-G900A using Tapatalk

[imsy]

dude，can you send your sheet to my email,I am chinese,I can not link to google,thanks!
My email : imsy8461@163.com

[ampehalex]

I will try and see if wins will come

Sent from my TECNO-Y4 using Tapatalk

[motrin]

I will try and see if wins will come

Sent from my TECNO-Y4 using Tapatalk

Remember it's just a visual aid to help with your initial setup. In game management is the other half to winning.

Sent from my SAMSUNG-SM-G900A using Tapatalk

[woopypooky]

Haven't really determined a way. I've toyed with putting red arrows on players that have 1 or greater on their block. Red arrows on players with less than 1.

Sent from my SAMSUNG-SM-G900A using Tapatalk

You mean blue for less than one?

Btw this is great coding.

[motrin]

You mean blue for less than one?

Btw this is great coding.

Yup... Fixed

And thanks. Feel free to make a copy and tweak away. Although I see someone's been resizing and changing the language of the sharing sheet.

Sent from my SAMSUNG-SM-G900A using Tapatalk

[motrin]

That number is just the sum of the whole pitch. it isn't used for any calculations. I initially put it there to serve as a quick indication of if you generally are stronger. Higher= stronger. For possession, I find that the midfield number is a better indicator. On that screenshot, it is 0. I try to get that as high as possible.

Sent from my SAMSUNG-SM-G900A using Tapatalk

[motrin]

Also, this is set up assuming equal strength and not accounting for home field advantage. You'll notice this sheet won't provide you orders to get blow out wins. Because it's set up with defense first and generally, this will provide you orders where you won't get in trouble. You can tweak what the numbers around the pitch sum up or the order formulas to fit your taste.

Currently, I'm trying to figure out a way to account for team quality and home/away. But that's a far way off.

Sent from my SAMSUNG-SM-G900A using Tapatalk

[woopypooky]

Posses 51%
Shots 12 opponent 11
On target 5 opponent 4
Both managers watching .
I using some funny formation 3-3-2-1-1.


I noticed sometimes even using formation like 4-1-2-1-2 narrow, the orders ask me attack flank? Will it be able to work? So far I haven't tested it yet. I not performing well in the league at the moment so I dont want to risk. I didnt last long in cup either. I might test it in champios league last 2 group games.

Thanks.

[motrin]

I've experimented going flanks with a narrow formation. It didn't seem bad in specific situations. Are you going against another narrow formation? But what I prefer to do when i see an order that doesn't really fit the formation is to switch the formation to a flank hitter.

Sent from my SAMSUNG-SM-G900A using Tapatalk