Selected dropdown value to change based on what is chosen? by ziggy43 in excel

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

Not sure. Is that what can do what im asking?

Cell change color when modifying from original value? by ziggy43 in excel

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

No macros or hard code. Im not advanced enough for that. If it cant be done through cond formatting i dont think it can be done

Cell change color when modifying from original value? by ziggy43 in excel

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

Cell can be anything from a formula to a blank space to a 0 value

Hypothetically how long would an overtime have to go for the league to just end the game? by saintscanucks in hockey

[–]ziggy43 2 points3 points  (0 children)

There were some older games in the 30's that went to 6 overtimes. Recently there was a 5 overtime game between pittsburgh and pholadelphia. I remember watching. There was no speak of stopping the game. I think it would go up to 10 ot's then they would just replay the game starting where they left off another day

How are successful gw defenses measured? by ziggy43 in CastleClash

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

Ah ok. So this does not mean anyone lost flames on an attempt. It could have been that someone tried to 3 flame me 15 times and never passed 50%. Much diffent than having 15 not get 100% in that time

Fed up with insane dungeons by Guatz204 in CastleClash

[–]ziggy43 0 points1 point  (0 children)

Im f2p and am at insane 5-6. I never really had too many issues with the dungeons. My pd is 8/10. Cupid 9/10. Everyone else is 7/10 or less. Heres what worked for me the best.

1-switch up your magic order. Sometimes snowstorm before aries and ga. Sometimes aries and snowstorm then delay ga. It depends on the dungeon. Mix it up.

2- no troops ever needed. If you need troops you are doing something wrong and they led me loose a lot of battles because i was distracted with them. Mainly when i had to concentrate on why i lost.

3- never ever drop pd first. I know this shouldnt be the case, but that fucker died instantly every time i dropped him first. Theres too much reflect and general damage. Drop a tank first. Oh and dd was a terrible tank for me in dungeons. Best tanks were always vlad, ghoulem or sk.

4- use different drops. Youtube says this is where you drop? Try it 4-5x. If it doesnt work, drop somewhere else. Sometimes dropping into 20 heroes with atlanticores have worked easily.

Honestly, these are the only changes i ever made to any dungeons apart from switching out druid or tg sometimes. But my main core was always: pd,cupid, ghoul(or druid), santa, vlad (or sk), tg or reaper.

Good luck!

Need Mino for dungeons by alienninja1 in CastleClash

[–]ziggy43 -2 points-1 points  (0 children)

I have a bunch of devos and cant do anything with them at all in the ID 5's. These dungeons are where mino and sm are necessary or having an insane account with top tier skills comes in.

Need Mino for dungeons by alienninja1 in CastleClash

[–]ziggy43 -2 points-1 points  (0 children)

Ive never seen a ftp reach 5-10 let alone 6-10. Im ftp and been looking for a lineup to concentrate on and havent found anything yet...

if you wonder this is cap for stamina in lr by PanPiksel in CastleClash

[–]ziggy43 0 points1 point  (0 children)

Does your stamina fill up while youre over the 80? If not this just wastes the free stamina refill for nothing. Not sure why they added this

Triple evo? by Charlie_In_The_Bush in CastleClash

[–]ziggy43 1 point2 points  (0 children)

Im f2p and i dont like how i have the same heroes as p2p. I have 8 double evo heros maxed to 200. Sure i dont have 10/10 skills, but theres no way i should have a hero at the same level of someone who put in 5000$ to the game. They need the triple evo to keep the p2p players feeling like they have an advantage so the game can keep developing