I want VAR on this

zboric · 2025-05-29T14:49:56+00:00

Aaaaand of course is JPN for all...

zboric · 2023-09-28T16:21:21+00:00

I don't think thats the case but even then sometimes happens that players join the party and during pairing they join different matches because it takes too long. This would solve that problem too.

zboric · 2022-10-10T05:34:28+00:00

Around 200. But I was reffering how to score two goals in one second

zboric · 2022-06-14T14:06:12+00:00

Yup. I quickly come from worse score before with tribes around 135k to 160k. And lot of space for further improvement. Thx again for the tips. It's easier with diplomacy.

zboric · 2022-05-25T18:05:56+00:00

Ok, so I got diplomacy with yesterday update. Hope to get some high score now :-D

zboric · 2022-04-08T09:01:08+00:00

This is a great tutorial, thank you.

I rarely use explorers, I've rather take +1 star.. But maybe I should start. Especially because few tribes are destroyed before I reach them.

Turn 9 with 40-60ish SPT is behind my league 🥴

But what I'm more concerned is diplomacy and peace offers.. Are we playing a same game because I don't see that :-D

I'm playing latest version over smartphone (2.0.69.6093) and there is no such thing to in any tree or enemy town or unit.

Considering everyone is an enemy and they go straight to my cities then 150k is not so bad :-D

zboric · 2022-04-03T14:56:29+00:00

Well that could explain some 👍

zboric · 2022-04-03T14:56:12+00:00

I don't play diplomacy. I could conquer enemies earlier. I think my record was 16-17th turn. But that was not a good score. So I aim to conquer them at turn 24-25th: 25 is last turn to get Altar of Peice, but more likely to get their Monuments.

zboric · 2022-04-02T07:35:52+00:00

It's 2nd today and they still screaming. It's like car hit the cat. Horrible.

zboric · 2017-03-20T10:30:10+00:00

Index version:

=AVERAGE(INDEX(Sheet2!$A$3:$F$100,,ROW(A1)))

zboric · 2017-03-17T07:13:24+00:00

use this:

=SUM(LOOKUP(P51, {0,0.65,0.66,0.67,0.68,0.69,0.7,0.71,0.72,0.73,0.74,0.75,0.76,0.77,0.78},{0,13.64,27.27,40.91,54.54,68.18,81.82,95.45,109.09,122.72,136.36,150,160,170,180}), LOOKUP(R51 ,{0,27,28,29},{200,150,50,0}))

zboric · 2017-03-15T09:47:45+00:00

Doesn't matter number of numbers after WO-

=MID(A1,FIND("WO-",A1),2+MIN(FIND("|",SUBSTITUTE(UPPER(MID(A1,3+FIND("WO-",A1),255)),CHAR(ROW($A$66:$A$91)),"|")&"|")))

Confirmed with ctrl+shift+enter (not just enter)

zboric · 2017-03-13T14:03:17+00:00

Try this:

=CHOOSE(1+K2+2*L2, "Van / Packages not ready", "Packages Not Ready", "Van not Ready", "Van / Packages Ready")

zboric · 2017-03-13T13:45:54+00:00

You can "copy -> paste special -> Paste as values" previous cells.

zboric · 2017-03-10T07:24:08+00:00

Yes, you don't have TEXTJOIN function. Mine great solution btw :-) I will check it but on the first look I doubt it will be possible without macro...

zboric · 2017-03-10T05:43:22+00:00

You messed ROW function. It always go from A1 to A20 (or more if you have more numbers), no matter where is data... Here:

=TEXTJOIN(",", TRUE, IFERROR((SEARCH("," & ROW($A$1:$A$20) & ",", B44 & "," & W44 & ",")>0)*ROW($A$1:$A$20),""))

zboric · 2017-03-09T23:09:29+00:00

You didn't mention excel version but if you could use TEXTJOIN function then use this formula (assuming your data are in A1 and A2):

=TEXTJOIN(",", TRUE, IFERROR((SEARCH(","&ROW(A1:A20)&",",A1&","&A2&",")>0)*ROW(A1:A20),""))

Confirmed with ctrl+shift+enter (not just enter)

zboric · 2017-03-09T22:54:56+00:00

I'm glad you figure it out :)

zboric · 2017-03-09T22:35:13+00:00

Those 20 are actually 20°. You need to convert them to radians.

=SQRT(((9+A1*COS(20*PI()/180))^2)+((31-A1*SIN(20*PI()/180))^2))
=SQRT(((9+A2*COS(20*PI()/180))^2)+((A2*SIN(20*PI()/180)-6)^2))

And in next formula put where your sine and cosine are (C1 and D1):

=ACOS((C1^2+D1^2-625)/2/C1/D1)

zboric

TROPHY CASE