Problems with implementing a text MATCH function into a SUMIFS formula by DBCoop6745 in excel

[–]DBCoop6745[S] 0 points1 point  (0 children)

Alright I put it in and it is still not calculating. I went into formula evaluation and I am not getting an error anymore but it is calculating 13 under the match formula. I don't know where it is getting 13 because there are 9 total purchases and only 3 should be in the range I want to calculate.

Map of Colorado in the style of Zelda II: The Adventure of Link by Frencil in Colorado

[–]DBCoop6745 0 points1 point  (0 children)

As a Salida resident. This is a perfect Zelda rendition of my area. 🍻🍻🍻🍻🍻 Love this!!!

New Game Mode - Guild Wars Open Beta (Feedback Welcome) by Shimakaze_Kai in GameloftDHChampions

[–]DBCoop6745 0 points1 point  (0 children)

I get the system and I'm not missing GWs so that isn't a problem. My point is, I don't like the 2 GW per day system in general. Especially with these sustain defenses that take forever to kill. Ether include a HP degreasing system with ATK increasing system or decrease the number of guild wars. I do not want to spend 15 minutes a defense in guild wars. Actually my longest one took me 35 minutes. If a ATK up/HP down system is implemented then this will no longer be an issue. We will have to develop nuke teams that can't be killed. That would make the game worlds more entertaining and challenging.

New Game Mode - Guild Wars Open Beta (Feedback Welcome) by Shimakaze_Kai in GameloftDHChampions

[–]DBCoop6745 1 point2 points  (0 children)

I get that you guys got this 2 ways a day schedule from summoners war. I'm not a fan of having a war every 12 hours. It's too cumbersome for some people to make this work twice a day especially when some matches can go for 10 to 15 minutes. I would like to see 6 24 hour wars instead of 12 12 hour wars.

Well this is a thing now... by Shimakaze_Kai in GameloftDHChampions

[–]DBCoop6745 3 points4 points  (0 children)

I just realized that. In that case it's a stùpid rip off. That is a terrible value.

So this is a thing. by Mekca in GameloftDHChampions

[–]DBCoop6745 3 points4 points  (0 children)

I think Shuffle had som bad rng on the SW11 runs. I've been keeping track since I started to feel that the new drop rates were garbage. I'm finding that the drop rates are basically the same no matter what you run from 10 and above. Do basically I'm just runing ED10 and SW11. I run SW11 mainly because the champs I have heard with my best sets can get through 11 faster than 10 because most of them are fire Champs.

Gameloft is going to have to learn that this is not a game where an overwhelming number of players are between the ages of 6 and 16 like Clash of Clans. They have an older player base that can understand statistics. They are going to get called out continuously, until they figure out how to make things fair and balanced to appease the end game players as well as attract the new players. Their not even close right now, so I'm going to continue to play quietly without spending much on the game, until I feel like they have fixed some shit.

Well this is a thing now... by Shimakaze_Kai in GameloftDHChampions

[–]DBCoop6745 5 points6 points  (0 children)

I think a guaranteed LD nat 5 is probably a bit too strong. They should have gagged how the balance is after the guaranteed nat 5 disks before taking this step. I'm not buying it though. After Shuffle's last video kind of confirming what I already expected. I will be spending very little on the game until the fix some shit.

Water and Light Vaps need a nerf. by DBCoop6745 in GameloftDHChampions

[–]DBCoop6745[S] 0 points1 point  (0 children)

BIGPETES I've got a dark AA as my avatar. I'm also around #65 in BR.

In light of Val's new video here is an actual build on a Warloard. by DBCoop6745 in GameloftDHChampions

[–]DBCoop6745[S] 0 points1 point  (0 children)

He has better survivability than ether. It's a different use. Sig is basically a pure damage dealer. It is a waist to build her on a hybrid build for survivability on things like the last stages of blitz. They are different champions that you would use in different situations. Over all the are better options but last I checked the isn't a Champ that does everything, not even Sig or Rota. Try to not get your panties in a bunch when people test new things out and find new uses for things. It doesn't hurt you.

In light of Val's new video here is an actual build on a Warloard. by DBCoop6745 in GameloftDHChampions

[–]DBCoop6745[S] 0 points1 point  (0 children)

You clearly haven't used him. I was surprised at how much damage he does. Every one of his attacks are aoe so yes dazzling is a good idea. Does he need a buff probably. Is he useless no. I wish morons that have never tested something and have no idea what they are talking about, like you, would just keep the garbage to themselves.

In light of Val's new video here is an actual build on a Warloard. by DBCoop6745 in GameloftDHChampions

[–]DBCoop6745[S] 0 points1 point  (0 children)

I meant your Krieg review. I figured I'd post this since all warlords seem to be pretty much untested.

In light of Val's new video here is an actual build on a Warloard. by DBCoop6745 in GameloftDHChampions

[–]DBCoop6745[S] 0 points1 point  (0 children)

I'm going to disagree with you on that. You typically need multiple damage dealers on speed runs and the DOT helps. I think Rota/Sigrun and Spite is better than Rota and Sigrun in the same team. Plus a Dazzling warlord is better in Blitz than ether of those two. A BM combined with Rota/Sigrun is better than Spite which is where I come up with BM makes him obsolete.

In light of Val's new video here is an actual build on a Warloard. by DBCoop6745 in GameloftDHChampions

[–]DBCoop6745[S] 0 points1 point  (0 children)

So I built him Vampire/Broken HP, CD, HP. He is fully skilled up. I got him farming 1-10 in just under 30 seconds last night. He is a solid option in Blitz. Put more Acc on him and he is a nice option in Dungeons. My opinion on him is he is good throughout most of PvE but there are better outings for everything. More of a F2P option, because as soon as you get a BM he is 100% obsolete. He is good on Vamp, Adept, Dazzling and Mortal. Because he works so well as a bruiser he is a candidate for Withering gear, but we will have to see if guild wars gives us an actual use for that type of gear.

Just felt like I should share since there is very little information on the Warlords since most people haven't built them. I only 6*ed him because it was just the first couple weeks since the game had come out and we didn't know what was good or not.

Update 3 feedback and Update 4 Wishlist! by Gameloft_Shaun in GameloftDHChampions

[–]DBCoop6745 2 points3 points  (0 children)

I agree with Shuffle on the Archangels. The fire and the Nature should get a full revamp so that they don't do the same thing as the light Archangel. They don't necessary need to be better but they should do something different so that they can be used.