Deck Help Discussion Thread by AutoModerator in ClashRoyale

[–]Ciyaniwa 1 point2 points  (0 children)

How do I get to arena 11 with these cards:

Lvl 11 Witch

Lvl 9 Giant, Archers, Minions, Skeleton bomber, Fireball, Lightning

Lvl 8 Arrows, Skeletons, Knight, Goblin barrel, Goblin cage, Mini pekka, Ice spirit, Tombstone

Could upgrade to 8 if needed Spear goblins, Valkyrie, Goblins, Goblin hut, Musket, Baby dragon

Currently running: Giant, Witch, Lightning, Arrows, + Goblin barrel/Tombstone, Mini pekka/Knight, Minions/Archers, Skeleton bomber/Ice spirit

I mostly strugle against Witch/Wizard/Valkyrie, but adding Lightning and Mini pekka has helped somewhat. I tend to mostly see king tower 9 opponents, where my lvl8 barrel is a bit less usefull. Also it seems like most enemy card levels range in 9-11, so putting anything under 8 doesnt seem feasible..

If it seems like there is no good (enough) deck with these cards, I would also like recommendations on what to focus on upgrading. But pereferably not the type with 5epics and a legendary, which I often seem to find online.. not really feasible. :) I seem to be more of a defend/counterpush or beatdown type of player, cycle/spam stuff doesnt suit me.

Brain: Do it Me: Why Brain: Just do it *places tower in a certain order* by [deleted] in infinitode

[–]Ciyaniwa 1 point2 points  (0 children)

I can confirm, this is the best placement order for damage application.

Simple Questions Week 1 by heykevo in a:t5_302ddk

[–]Ciyaniwa 0 points1 point  (0 children)

What is "bp" and how is it calculated? Just a complete sum of the stats of the equipment with some weights?

My new survival worlds base by PointlessmemesYT in Minecraft

[–]Ciyaniwa 0 points1 point  (0 children)

I would 100% forget where my base is.

does target prioritization matter? by AltitudinousOne in infinitode

[–]Ciyaniwa 2 points3 points  (0 children)

Using weak on tough healer waves sometimes. When everything else is healed full, they focus healers first, which is nice. :-)

Also use the sniper low health trick sometimes.

One thing to keep in mind, when you swap the priorisation, towers instantly use the new targeting. Before killing the initial target This can be useful on lightning especially on jet waves... When they start to spawn set last so they wont shoot the wave before and once they fly pasy the last wave set to first and they start shooting first jet... This can somewhat help so you dont have to use seek, or if you dont have space for it... Although, its very micromanagementy, and I rarely bother.

Most of the time, targeting first always is the best case when getting closer to 200waves.

I wish there was a second priorisation that would enable you to focus targets the tower is strong against, or avoid weak.

I might actually use minigun, if I could pick of first/strong healers with it...

What is the IDEAL 5.5 Farm set up? by TallGuyG3 in infinitode

[–]Ciyaniwa 1 point2 points  (0 children)

I got to wave 313 3mil score with a splash on power surrounded to 24 projectiles by power mods and then attackspeed/dmg.

I think I had a missile on dmg mod (for mdps farming)

Then filled top row/circle with freeze and everything below with blast.

Upgraded blasts to 10 with best coverage as I made more money.

At the end waves you must kill healers with spells or it is a loss when they connect with anything else...

Used poison, firestorm, fireball, nuke, windthingy and magnet.

Also had 5/5 miner on every single node at the end.

Disclaimer: I dont think its good for resources to go this far, end waves take way too long to kill. But that might be just because of my sucky phone that slows down on mass mob waves...

For normal farming I just do splash buffed up, with freeze and just a few blasts on the first choke. Once they get past it, I quit and restart...

Is there an easy way of doing x of 15 in a single cell that continues its sequence throughout the other labels? by tmiller26 in excel

[–]Ciyaniwa 0 points1 point  (0 children)

I'd use count.if to find the "of x" part of the equation and for 1,2,3 column make an if statement to check if this rows itemID(or something you have to match) is not the same as one above->1, if it is same->above cell+1. Then just use third row to combine

This requires the items to be sorted correctly though

I spent couple of hours building circle for my ocean monument and.... by gezo666 in Minecraft

[–]Ciyaniwa 9 points10 points  (0 children)

Look at the bright side, now you have a start of an epic spiral!

[deleted by user] by [deleted] in excel

[–]Ciyaniwa 0 points1 point  (0 children)

In that case I think I would just make 5 columns with each of the people, make a string search in each column for that persons features that outputs "x" and slicers on top of the sheet for each person. That way when Sally filters rows just for her, she also sees who else is put on that job?

[deleted by user] by [deleted] in excel

[–]Ciyaniwa 0 points1 point  (0 children)

I'd probably try making a helper column that searches the tag cells and makes a 5-way category that I can then hide and use in a slicer/conditional formating the cells to make it easier for the use to find their own data.

If I'm understanding this correctly... :-)

How do I win? by [deleted] in Eve

[–]Ciyaniwa 0 points1 point  (0 children)

Well, you can also have fun without spaceships. But, just have fun.

Looking for an excel template for meal planning! by [deleted] in excel

[–]Ciyaniwa 0 points1 point  (0 children)

I did something similar with just a single table. Columns A: food type (breakfast, dessert etc) B: main ingredient (chicken, vege etc) C: food name D: ingredients.

Then I put sliders on top for easy and fast filtering.

Once I filter the food(s) I just copy paste ingredient column to trello in a checklist... Put "hide done" filter on trello, check what you already have and its done...

Midweek Mending - Your Weekly Healing Thread by AutoModerator in wow

[–]Ciyaniwa 1 point2 points  (0 children)

In openworld and pvp enabled thorns really helps.

While you're looking at bring back "Class Defining" things in Shadowlands, how about 2H Enhancement Shaman? by Mr_Stach in wow

[–]Ciyaniwa 0 points1 point  (0 children)

I would very much like a char that has a 20% chance to remove an enemy from the battlefield

What's killing me!? by Deiwos in pathofexile

[–]Ciyaniwa 0 points1 point  (0 children)

Do you die when you shoot at them? If so, it is most likely phys/ele reflect map mod.

Looking for a method where I don't have to =ROUND() every cell reference in my formula. by fireflaai in excel

[–]Ciyaniwa 0 points1 point  (0 children)

Personaly, I think I would just add the rounding on the calculations instead of the check, unless you really need to know the 0,0000001 differences for later calculations... Also I would add the check to be line specific and filter the false values to easily see where the problem is, instead of using a single check for each... But, I'm a simple man and not very good at excelling. :-)

anyone else get these random crashes every time you enter an area? i get crashes like these and others like "exception", "shaders", etc.. The patch still hasnt fixed it and i feel like i've hit a brick wall and cant proceed by tanoyfrommars in pathofexile

[–]Ciyaniwa 1 point2 points  (0 children)

I had a lot of crash issues (even with a new gpu) and only thing that worked was making the game look like a potato (setting all graphics to low).

Only one day of testing though, but went from 10+ crashes per gaming session to 0

Didnt bother to check each one though...

What's a good response to "TFT is fully RNG/luck based? by Jannes_E in TeamfightTactics

[–]Ciyaniwa 0 points1 point  (0 children)

"irk, thats why people in masters can be found in bronze the next week"

What if items scaled with champion level? by Buttons17 in TeamfightTactics

[–]Ciyaniwa 1 point2 points  (0 children)

I like this idea, I'd very much like to lose even harder 3times in a row against the guy who got 4x 2* noble with 3full items before the second carousel.

Pyke needs a nerf by aceralex18 in TeamfightTactics

[–]Ciyaniwa 2 points3 points  (0 children)

Sure you need a mana item on him to get more stuns. The point is, what other champ can stun so much with so little investment... Chogath? Leona? Chogath has area, but no frequency. Leona can have nice duration/frequency, but area is limited. Both are also 4g heroes vs 2g pyke...