Favorite team:LSU 
Location:Baton Rouge
Biography:
Interests:
Occupation:Marketing Coordinator
Number of Posts:168
Registered on:7/13/2011
Online Status:Not Online

Recent Posts

Message
This is the best I could come up with. If you have stuff above or below your intended data, you can change the complete column references to you desired range (i.e. change from "C:C" to "C4:C101"). If you don't have data that might get caught up in your calcs, then it should prove to be a little easier for continued use since you won't have to worry about the number of plays exceeding your current reference.

Starting in cell:
M4: =SUM(N4:S4)
N4: =COUNTIF(C:C,$T4)-(COUNTIFS(C:C,$T4,$F:$F,">0")*0.5)
O4: =COUNTIF(D:D,$T4)-(COUNTIFS(D:D,$T4,$F:$F,">0")*0.5)
P4: =COUNTIF(E:E,$T4)-(COUNTIFS(E:E,$T4,$F:$F,">0")*0.5)
Q4: =COUNTIFS($F:$F,$T4,C:C,">0")*0.5
R4: =COUNTIFS($F:$F,$T4,D:D,">0")*0.5
S4: =COUNTIFS($F:$F,$T4,E:E,">0")*0.5

N-P is counting the number of times the player's number appears in C-E and then subtracting .5 each time there is a number in F since they were assisted.

Q-S is counting the where each player had an assisted tackle based on the type (C-E) and multiplying it by 1/2.
Who is going to win the race to the bottom?

Slippy or Hammertime LINK
First thing that came to mind with "Sloth."



quote:

1) the maps were very close quarter maps and the games are fast paced.

2) killstreaks were terrible with the exception of the UAV's.

4) shotgun was way to strong.


On PS4 but here's my thoughts.

1) Agree. I prefer close quarters, fast paced TDM so this works for me.

2) Disagree. UAV was easy up, easy down. Molotov cocktails were great the first weekend, they gave you 2 instead of 1. Strafing run was over too quick for my taste but probably better that way. Flamethrower was overpowered - short burst kills and it persisted after death.

4) Agree. I started with that class and quickly worked my way through all three guns. Incendiary Shells and longer distance helped dropped people quick, especially with the last one.

re: Powerpoint animation question

Posted by MiloTealeaf on 6/20/17 at 12:24 pm
Definitely doable. You will need to add several animations to two objects (just talking about (P) and "ersonal").

(P) will get the Emphasis Animation of Grow/Shrink (you can mess with different percentages of shrinkage in the Additional Effects Options box - if the presented Smaller or Tiny settings don't fit you needs).

You can also set the Trigger to be on the click of the slide (if the order of all of your words will be consistent - this is recommended, otherwise you can miss your targeted letter by accident and advance to the next slide) or you can set it to trigger on the click of the specific letter you want to run.

You will also need to add a Motion Path (straight line should be fine for your purpose) that occurs with the "Grow/Shrink" animation.

"ersonal" you need to set with an "Entrance" animation (Fade, Wipe, Appear, whatever) and have that trigger "after previous" with the (P) animations. You could also have it set to trigger "with previous" and delay it until right before the (P) motion path ends (can help give something a little more polished look.

I would recommend doing each on their own slide while you set them up, to help avoid confusion when you have 3 ovals and 3 text boxes to choose from and try to keep track of. This, or names open up your Selection Pane and give each object an easy to understand name (such as "P Circle" and "ersonal").

re: Jailbreak iPhone

Posted by MiloTealeaf on 6/20/17 at 12:09 pm
Last iOS version that I know of to be jailbroken was 10.2 (I missed the boat when Apple stopped signing that version of the OS and am still stuck on 9.3.3. Link below keeps a running status update (page down 2-3 times) of the status of the next JB.

LINK

re: Assassins Creed movie trailer

Posted by MiloTealeaf on 5/13/16 at 9:59 am
Short description: Stabby parkour.

re: Need some OT magic. Who is this

Posted by MiloTealeaf on 2/17/16 at 1:00 pm
Asian Stanley Tucci :cheers:
I was there for work last week. The locals we were working with suggested Johnny T's for the food but more for the live entertainment. My boss and I had to work and eat later but everyone that went seemed to enjoy themselves.
According to their video on youtube, 30 minute flight time and able to carry a payload of 120 kg (265 lbs).

I'm not really sure how you could use this for firefighting other than spotting people trapped on upper levels. One man with full gear (45 lbs according to the google machine) and you don't have a whole lot of wiggle room. I can't imagine trying to use a fire hose on that thing either; wouldn't the pressure from the hose push you away from the fire?

They did say in can be remote controlled...maybe send the firefighter up to the window and use this thing as a ladder, one person at a time?
Downloaded and ready. :cheers:

PS4: MiloTealeaf

re: PS4 disk/system help

Posted by MiloTealeaf on 10/29/15 at 8:42 am
I had the same issue. After much searching online, I found a few "fixes," none of which worked for me but they might for you.

1. The middle rubber foot is pushing against the eject button. I can be pulled out (and put back in) without cutting.

2. Start in safe mode and select Rebuild Database. Don't worry, this does not wipe any of your data (a very real fear I had with all my downloads and lack of wanting to re-download).

3. Was told by the tech support folks to shutdown for a few minutes and try using it standing on its side (no reason was given that this might do anything).

4. There was also talk of turning the disc ejection screw because it was too tight/loose. Not the easiest to find and you will need a precision screwdriver (think eyeglasses type).

I ended up having to send it in for repair. To their credit, I was out of the 1 year warranty but they still fixed it for free.
After a quick Google session, advice seems pretty consistent. Once per year as long as you keep the preventatives current. If you miss a month or are late, test immediately, then six months later, then back to the yearly.
quote:

quote:

Why should a simple check take 4 math problems?

It shouldn't. There's no need for the implementation of common core in math at levels where only simple arithmetic is being used. It's very inefficient.


And why are we teaching kids the alphabet? I don't recite it when I read sentences.

re: 1

Posted by MiloTealeaf on 9/24/15 at 8:40 am
quote:

...annual hajj pilgrimage...millions of visitors for a few days each year.

If only there were an article linked in the OP.
I second the ball fields at the Burbank Soccer Complex & Dog Park (30.345693, -91.094341). And you can try Highland Road Park just down the road if they are busy (or play on one of the empty soccer fields).
quote:

Racist?


Of course it is. The accepted term is Native American. :lol: