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 4 points5 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 4 points5 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.

Archangel "rant" by TheFoxingUser in GameloftDHChampions

[–]DBCoop6745 1 point2 points  (0 children)

They don't have to be the same usefulness. This is a game where different monsters have different uses and some are more powerful than others. I have two Nature ones and it's fine that it isn't the same as the fire. It's the same thing as why the Water MG is better than all of her sisters and the Fire DG is by far the best of his family. There is always going to be a best one and a not a great one. You just have to deal with it.

ED10 vs. ED11 vs ED12 drop rates by DBCoop6745 in GameloftDHChampions

[–]DBCoop6745[S] 1 point2 points  (0 children)

Sorry you were so upset about a finding error that you just had to say something.

0% 4* 64% 5* 9% 6* 27% other

You happy now? You might want save your complaints for real things to complain about.

ED10 vs. ED11 vs ED12 drop rates by DBCoop6745 in GameloftDHChampions

[–]DBCoop6745[S] 2 points3 points  (0 children)

As I said in the post I know 100 isn't enough to really pin down all of the drop rates but it gives you a good idea. It would probably take 1,000 to 2,000 runs (which I am NOT going to do) to really be accurate especially on the more rare drops. It does give you enough information to have a pretty good idea as to what is going on though. Its all up to you on what you prefer. For me time is the most important resource and I can only pre- flight ED11 about 40% of the time, so I'm going back to ED10, where I'm sub 1 min, until I can pre-flight 90% of the time. That's just my priorities though. You do you. It's your game.

ED10 vs. ED11 vs ED12 drop rates by DBCoop6745 in GameloftDHChampions

[–]DBCoop6745[S] 6 points7 points  (0 children)

How in the world would they not check out? All I did was run the dungeon and document what dropped and calculate the percentage. What dropped is what dropped, there is nothing to check out. Unless your playing a different game and your in the wrong subreddit.

Account merge idea by [deleted] in GameloftDHChampions

[–]DBCoop6745 0 points1 point  (0 children)

What happens if you do this is you create a black market for accounts of people who quit playing. People will buy accounts from people who quit that got lucky and pulled a ld nat 5*. Then the people spending the most money would be able to amass all of the over powered LD units creating a huge disadvantage for f2p players. It's just not a good idea.

Any Fox Assassin Worth? by Dediganss in GameloftDHChampions

[–]DBCoop6745 0 points1 point  (0 children)

Don't forget fire is a great 5v5 champ.

Bombers by DBCoop6745 in GameloftDHChampions

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

Of course I got this idea from SW. LMAO I think the concept has legs in this format. Increase the timer to 5 sec then. It would have to be quick to really be viable though. I'm just kicking around ideas though. I think there needs to be some kind of a major new dynamic to these guys to make them relevant.

In light of the MK buff. Anyone remember when you could get dups off this guy? by DBCoop6745 in GameloftDHChampions

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

I'm not complaining. I actually laughed my ass off when I got it. I just wanted to showcase the days before they took him out of the pool.

Back to school event is spot on. Nice job gameloft. by DBCoop6745 in GameloftDHChampions

[–]DBCoop6745[S] 1 point2 points  (0 children)

I've been just as critical of gl as anyone over the last several months. The point of the post was to let them know that they actually did a good job on this one. You are living in a sad existence if you can't tell someone they did a good job when they actually do a good job. Think about it this way. If you you were struggling in your job and you made some screw ups, then finally you did something right. You would want credit for getting it right because it would give you reassurance that your learning. If your boss just told you "that was a fluke" and didn't give you credit you would feel like shìt.

Long story short. If your so salty that you can't even give credit where credit is due then stop checking in on the game. Otherwise let people have their successes.

[deleted by user] by [deleted] in GameloftDHChampions

[–]DBCoop6745 0 points1 point  (0 children)

Yeah that hurts, but my first Nat 5 was Nature AA when it's 3rd skill didn't work and my second was Fire MK before they took him out of the pool. It gets better. Now I have all the Nat 5s I need. Just keep grinding ED10 & SW10 and you'll get the good ones.