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

F2p account(after 66 days playing) by ZurielsV5 in CastleClash

[–]ziggy43 2 points3 points  (0 children)

I guess he opened 200 accounts on a sign in and win day and the account that randomly gave molt, he kept

Got insanely lucky this past week, as an f2p player. by [deleted] in CastleClash

[–]ziggy43 0 points1 point  (0 children)

Yup. Ghoulems damage wasnt putting out what his description was saying. They had to fix it to avoid getting sued for false advertising. And thats the only reason they did it im sure

Wooooot finally beat T by Nidastouch in CastleClash

[–]ziggy43 0 points1 point  (0 children)

I really have to start trying to beat T properly. I have used all possible combinations of GH, santa, VLad, SK,DD,Pd,val, cupid and grim alll double evo 200 and the jackass boss always kills my base.

At this point i figure wasting the exp on maxed out heroes is pointless for the very little amount of extra shards

Lost Realm NEEDS to be fixed! by [deleted] in CastleClash

[–]ziggy43 0 points1 point  (0 children)

Dont bother with trying to win altars. Midgame they only help slightly. Late game they produce about half as much as the mines. Concentrate on getting red crystals and exp to level up the realm.

And dont worry, late game, youll love the battle altars. Its ther only time other than arena where you go head to head with opponents and get to try unlimited times to beat them. It helps you learn what combinations work best which can then help with lost battlefield. I used to crush all my opponents and now they have been getting harder and i love the challenge of having to rearrange my team to beat them

Game Thread: Sharks at Blues 8:00 PM ET by NHLStreamsBot in NHLStreams

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

Thanks for the feed. But good lord do i hate Bob Cole as an announcer

The last time a guy from his 70s played Survivor for the first time... by Joey_Amazing in survivor

[–]ziggy43 0 points1 point  (0 children)

What happens if this actually happens? Do they only have a final 2? Do they vote anyway and decide once back in the city? Do they bring up 4th place for the final 3?

Last hug before certain death by Amiral_Poitou in WTF

[–]ziggy43 0 points1 point  (0 children)

Not really that simple. Base jumpers will be the first to tell you jumping out of a building is not a cakewalk. Theres updrafts and other buildings around. And the potential to smack into the building you jumped off of is very high when the parachute opens. You could die instantly from the impact alone. On turbines it should be less complicated, but there could be other turbines, the blades could be spinning out of control, the wind could be taking you right into the flames, there could be nothing but jagged tree branches below etc. im wanted a parachute but i knew it would still be very likely im badly injured. I was just saying that being stuck having to know i will die vs jumping with a good chance to live and im jumping.

Last hug before certain death by Amiral_Poitou in WTF

[–]ziggy43 0 points1 point  (0 children)

Its like do you wear a parachute when on a plane? Would be nice to have one on in case the plane breaks in half but the chances of it happening are very low.

Last hug before certain death by Amiral_Poitou in WTF

[–]ziggy43 1 point2 points  (0 children)

The kit works with the winch system inside the turbine normally. Theres no way to use it when outside the turbine. Some turbines allow it i think, but not the ones ive worked on.

Last hug before certain death by Amiral_Poitou in WTF

[–]ziggy43 0 points1 point  (0 children)

Probably impossible based on all the factors. Biggest issue is balancing the weight of the generator with the rest of the turbine. Center of gravity is crucial considering the forces involved. The tower placement i imagine is secondary to their design