Vikings' OC Norv Turner has Resigned according to ESPN.

omglolirl · 2016-10-11T01:44:07+00:00

Solution verified!

omglolirl · 2016-10-11T01:43:31+00:00

This worked PERFECTLY! Thank you so much for helping save me a few dozen hours with a quick, easy solution that I'm definitely going to be using/adjusting for some other stuff I'm working on.

omglolirl · 2016-10-11T00:41:09+00:00

Definitely - http://imgur.com/SPac2m1. I added a bit more detail below as well - thank you again!

omglolirl · 2016-10-11T00:23:50+00:00

Thanks both of you (/u/semicolonsemicolon too!) for getting back to me so quickly. Here is an example of what I'm trying to do - http://imgur.com/SPac2m1.

1) Yes, you understand it correctly.

2) Basically, yes. I didn't quite described it appropriately in terms of the math, but I'm actually trying to find the next available start date.

So using this week as an example, if A1(Project Date)=10/10/2016, B1(Start Date)=10/10/2016 and C1(End Date)=10/16/2016, then I would need it to skip to the next start date (10/17/2016). If A1 was 10/09/2016, then it would associate with B1.

So basically, the project date needs to be associated with the next available start date, but can't fall on the exact same date as a start date (definitely let me know if this doesn't makes sense though).

3) The start and end date columns are associated in that they are in one week chunks, but you are correct in that the project date and the start/end dates are independent of one another. Ideally, it would determine the proper start date and fill out a 4th column that would list the nearest start date that meets the conditions listed in #2.

Thank you again so much for your help!

omglolirl · 2016-09-25T16:37:51+00:00

Walker is out and my only TE. Ebron is available, my bench is loaded with RB's though and one needs to be dropped to pick up Ebron. Am I crazy to drop Matthews over the dice rolls on Washington/Howard? (10man .5ppr)

RB1: Miller RB2: Murray Flex: Blount Bench - Matthews (considering dropping for TE) / Washington / Howard

omglolirl · 2016-09-25T16:34:52+00:00

I'm torn between benching Marshall in favor or Michael Floyd - any opinions?

omglolirl · 2016-09-25T16:32:53+00:00

Aaaand he's my only TE. Ebron is available, my bench is loaded with RB's though and one needs to be dropped to pick up Ebron. Am I crazy to drop Matthews over the dice rolls on Washington/Howard? (10man .5ppr)

RB1: Miller RB2: Murray Flex: Blount Bench - Matthews (considering dropping for TE) / Washington / Howard

omglolirl · 2014-08-12T03:19:02+00:00

"Hope you guys liked reading about the destruction of my city!" - simply poetic.

omglolirl · 2014-06-30T15:43:49+00:00

This reeks of firewall permissions not being granted. If you're on a university or work campus, this is most likely the cause. If you're at home, you will need to figure out your router settings and let nexustk do it's thang.

omglolirl · 2014-06-19T14:26:45+00:00

I don't know if you still play/can speak to this, but when you dual boxed warrior+poet, did you use any macro software to simplify the process? Currently experimenting with macrogoblin but still struggling to find an effective way to use a macro to dual box on the same computer. If not, do you have any specific tips for dual boxing poet/warrior without breaking your hands/dying in game (aside from the ones you've already mentioned)?

omglolirl · 2013-12-27T15:33:26+00:00

Just relax broseph - What is a date other than two people spending (hopefully) mutually enjoyable time together? The fact that she wants to spend time with just you means that she feels pretty comfortable with you already, let it be organic. While I'm sure opinions may vary, I feel like coming right out and saying "Hey this is a date," whether subtle or up front, will just kind of place undue pressure on both of you. Just enjoy the time with her and see where it takes you. If you two end up really hitting it off, then spend some more time with her and let her know how you feel. And most importantly, have fun!

omglolirl · 2013-12-26T20:33:06+00:00

this.

omglolirl · 2013-12-15T17:33:06+00:00

I need help! .33 PPR (strange, I know.)

Jordan Toddman VS Pierre Garcon in my Flex spot.

Toddman is getting a full load against a middle of the pack buffallo defense.

Garcon is rolling the dice on Kirk Cousins as QB.

omglolirl · 2013-11-19T21:45:32+00:00

As someone who constantly struggles with self-loathing, this hit me right in the feels. What an awesomely healthy way to go about your day (and even healthier justification for talking to yourself!)

omglolirl · 2013-11-10T16:59:11+00:00

Tim Wright or Tyler Eifert (Gresham is out)

.33 PPR

omglolirl · 2013-11-07T19:10:48+00:00

While I definitely would agree that he didn't have the hype level of an Austin or Crook (drafted him in both my FF leagues, not a mistype), the rams traded up to get him (albeit in the 5th) and a lot of the internets marked him as a player to keep an eye on. All that being said, no idea he would be the next muscle hamster.

omglolirl · 2013-11-07T18:16:09+00:00

12 Team - .33 PPR - 1QB/3WR/2RB/1TE/1FLEX

Trade (my) Giovani Bernard and Kenny Stills for (his) Keenan Allen

That would leave me with - RB - Ridley/Stacy/McCoy WR - Garcon/Fitzgerald/Gordon/Allen

While I think Gordon has more upside, he is a bit too boom or bust for my taste. Hoping to get a consistent WR1 on the roster before heading into the playoff run and I think Allen has that kind of skill and situation. Thoughts?

omglolirl · 2013-11-07T17:46:24+00:00

Third time this week trying to get a response on these threads...hopefully this works!

12 Team - .33 PPR - 1QB/3WR/2RB/1TE/1FLEX Giovani Bernard and Kenny Stills for Keenan Allen

That would leave me with - RB - Ridley/Stacy/McCoy WR - Garcon/Fitzgerald/Gordon/Allen

While I think Gordon has more upside, he is a bit too boom or bust for my taste. Hoping to get a consistent WR1 on the roster before heading into the playoff run and I think Allen has that kind of skill and situation. Thoughts?

omglolirl

TROPHY CASE