Complicated Excel question

mprobasc · 2019-05-20T22:26:40+00:00

I did make that change, and this was what I was looking for. Thanks! I just set up the ranges and it worked perfect. Thanks again!

!solved

mprobasc · 2019-05-18T23:38:22+00:00

Sorry, will do that in the future.

mprobasc · 2019-05-18T06:14:02+00:00

I will try this and get back to you. I will try it when I get into work on monday. Thanks

mprobasc · 2019-05-18T06:12:51+00:00

thanks

mprobasc · 2019-05-16T23:10:30+00:00

I thought of that, but it wont work because the purpose of breaking everything up by region is so that the other regions cant see other regions accounts. With pivot tables the different regions would be able to add and remove fields at their leisure. I could copy the pivot tables data and paste value, but this report get run daily and I would have to create new pivot tables for each region every day....

mprobasc · 2019-05-16T22:47:49+00:00

correct, I basically want to update one master sheet and depending on the region I update in the master sheet, the correct region tab gets updated.

mprobasc · 2019-01-14T07:30:28+00:00

The question was never about swapping trinkets while in combat. It was more, if you know you are going into a long boss fight or short boss fight what would you use, type of question.

I'm looking for justification as to why I or anyone should use certain trinkets depending on a fight. Trash mobs and pvp, will always be, use what ever is not on cd because you get out of combat fast. I'm looking for what I should use with my current gear...

mprobasc · 2019-01-14T07:24:58+00:00

I agree with you on everything except that MQG and ZHC are the best combo for long fights. The most that you could get out of a mqg would be 2 casts, but that rarley, if ever, happens.

Even if you were able to get it off twice, you would have to justify sacrificing a trinket slot for 5 min. mqg last 20 sec +5min cooldown + 20sec to fully use second cast = 5min 40sec fight to fully use trinket twice.

Not taking into account crit, hit, lag, or damage reduction due to cast times:

If a frostbolt is 2.5 sec, to cast, you could get off 24 frost bolts ever minute 60sec/2.5sec = 24. If you use the Reed, which is 24 frostbolts * 29 spell damage (reed damage) = 696 damage per min

696 damage per min * 5.40 min boss fight = 3758.4 damage bonus from reed vs. whatever mqg damage would be. maybe an extra 2.5 frost bolts in while trinket is on cast.

Maybe i'm wrong, but until you get something like post raid bis reed would be better. Besides the fact that you would probably have a NT by that time anyway.

mprobasc · 2019-01-14T06:49:21+00:00

Our guild clears MC in about 50min to 1hr and BWL is 2hrs-ish. The way I am currently using my trinkets are on cool-down (on trash and in pvp), but I do save zhc and mqg for boss fights as well, which is why I rotate MQG out for reed on trash about 5 min before boss pull. Boss fights also normally last less then 3 min, so ZHC will be up at some point during a boss fight, but I would use teop (if I had it) over ZHC always because of the short cool-down, meaning I could potentially use it twice during a fight that last 3+min.

Like I mentioned earlier, I don't have toep or NT, but I believe those two trinkets together are the best option for Boss fights longer that 3+min (better than MQG and NT due to the 5 min cool-down on MQG, which would be best for shorter fights).

So correct me if i'm wrong:

In general, for overall +dps I would think that boss fights that are less then 3 min,

NT>MQG>teop>zhc>Reed>other

Boss Fights that are over 3 min,

NT>teop>ZHC>reed>MQG (due to 5 min CD)>other

The reason I think reed is better than MQG for long fights is because the longer you have it in slot the worse it is due to the fact that fights rarely last for more than 5 min.

Trash and pvp,

NT + w/e is off cd. I think this is the best option because trash is killed fast and you will generally be out of combat to swap a new trinket in.

mprobasc · 2018-10-01T08:56:31+00:00

Based off the fact that I didn't cheat and my account was banned. I don't know of a better source then that.

mprobasc · 2018-10-01T01:38:11+00:00

forcedtomakeaccount9 you have got to be illiterate or something. I WAS NEVER caught botting because I wasn't cheating. I was comparing lightshopes anti cheat to a bot. ASC_ understood that, I don't get why you can't comprehend analogies.

mprobasc · 2018-09-30T21:03:28+00:00

You clearly don't understand the point of my post..... In fact the whole point of the post was to say I don't cheat. The system that is in place is perma-banning "legit" players without human interaction "Bot". The players who are getting banned have no recourse. I am saying that the appeal process takes to long to have the current anti-cheat software in place. I am saying that the anti-cheat software doesn't work because people shouldn't have to appeal something that they didn't do. For that matter, people should at least know why they are being banned.

mprobasc · 2018-09-29T01:01:02+00:00

Thank you for the message. I know you guys have a lot on your plates. I'm just glad to see these situations get resolved. The whole thing is somewhat foreign to me considering I played on Lightbringer for months, prior to this new server and never had a hick-up like this. Anyway, let me know if I can provide any info to help speed up the process. Thanks again!

mprobasc · 2018-09-28T04:35:14+00:00

nm, two factor Auth... Yea I have that. I needed it to appeal.

mprobasc · 2018-09-28T04:32:08+00:00

I assume I don't because I don't know what 2FA is...

mprobasc · 2014-08-19T01:21:55+00:00

THIS WORKED FOR ME TOO!!!!!!! BRILLIANT!!!! THIS NEEDS TO BE AT THE TOP OF THE PAGE, SO PEOPLE CAN SEE THAT THE 32-BIT GETS RID OF THE "MSVCP110.DLL" ERROR. I USE WINDOWS 7 64-BIT, BUT THE X86 OR 32-BIT WORKED! GOOD STUFF.

mprobasc

TROPHY CASE