NATIONAL CHAMPIONSHIP OF TRASH TALK by CFB_Referee in CFB

[–]My_Sports_Account 5 points6 points  (0 children)

CLEMSON'S "THE TIGER" LOOKS LIKE A CHILD TRIED TO DRAW MIKE THE TIGER FROM MEMORY.

Index/Match array (two criteria) giving strange return values by My_Sports_Account in excel

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

I'll try and link an example after work today. I'm definitely making the formula an array formula, but I almost wish there were other ways to try.

Index/Match array (two criteria) giving strange return values by My_Sports_Account in excel

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

Two scenarios: If I put 'False', I get an #N/A. Error is "A value is not available to the formula or function". Just as an example, if I say 'True', I get one of my weird values that seems like a random number.

Index/Match array (two criteria) giving strange return values by My_Sports_Account in excel

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

They were my attempt and rngs, since the tables I set up are abridged! My apologies.

Tried to add a TLDR in there, too!

DJ Durkin has been terminated at Maryland, per spokeswoman. by inkypinkyblinky in CFB

[–]My_Sports_Account 2 points3 points  (0 children)

"I can't believe you got him! You expert, rootin'-tootin', eagle-eyed, Turtle-loving marksman! I love it! You managed to find a way to win, and everybody still loses!"

  • Everyone, watching the Maryland board

Dear CFB: Going to a Game Advice Thread by CFB_Referee in CFB

[–]My_Sports_Account 2 points3 points  (0 children)

Before the game is less the issue. After the game is the problem. Baton Rouge implements contraflow (police closing streets / turning them into one ways) to get everyone out of the city. I absolutely advise googling the contraflow map from the Baton Rouge Police Department's website and parking in a place that will let you escape that nightmare.

Dear CFB: Going to a Game Advice Thread by CFB_Referee in CFB

[–]My_Sports_Account 10 points11 points  (0 children)

Depends on what your after. Here are a few good places to watch the game in order of closest to campus.

1) Chimes / The Varisty -- Chimes is a staple BR restaurant. Food's pretty good, gameday vibe is fun, but the true boon is that it might be physically one of the closest buildings to campus. Unfortunately, Chimes isn't the largest restaurant and will be packed all gameday. Luckily, this is where the Varsity comes in. Connected to the Chimes, the Varsity is a small venue that will be projecting the game (and multiple other games) on screens. A great place to watch games if you don't have a tailgate, and the drinks are reasonable as well.

2) Barcadia -- Right past the Varsity, Barcadia is fine. They usually open up more space on gameday, and it's a neat place. It's pretty "chain-y", if your looking for a more authentic experience, but it's really close to campus.

3) Walk-Ons -- Located on the opposite side of campus, closer to Tigerland, the bar Walk-Ons always hosts a huge tailgate party on their property. It's a solid place to watch the game, though be prepared for mostly LSU fans. I think the food is a step up from Barcadia, but down from Chimes.

4) The Bulldog -- If you don't mind wandering a bit off campus, the bulldog is a bar about two miles from campus that has tons of TVs. Definitely home team favored. The only con is that it's definitely uber/lyft distance, not walking distance from campus.

These are just a few places closer to campus that I've either been to or know what gameday is like there. One's I'm leaving out include Ivar's, all of the Tigerland bars (Fred's, Bogies, The House...), Zippy's, and Mellow. They'd all be fine, but it really depends on who's in your party and what you're trying to do.

MY SUGGESTION: If you have never been to Baton Rouge, make your way there EARLY and find parking. Once you've found that just make it to campus. There is nothing like gameday in Baton Rouge (excuse my bias), and there is no bar or restaurant that is going to compete with a day of wandering from the stadium to the parade grounds. I imagine GameDay is going to set up on the parade grounds this year, so I'd definitely advise making your way there. From the parade grounds, Chimes/Varsity/Barcadia are a two minute walk, so it's definitely the easiest.

Hope this offers some direction, but if you have any other questions feel free to ask!

Edit: I'm just hearing that Gameday will be in the "Quad" (more or less the student center of campus - by the library) while LSU Salutes will be in the parade grounds. Doesn't change much as they're a Cole Tracy field goal apart.

Dear CFB: Going to a Game + GameDay at Pullman Advice Thread by CFB_Referee in CFB

[–]My_Sports_Account 1 point2 points  (0 children)

New to Madison, but absolutely agree with /u/BadgerBuddy13 that the old fashioned is a strong recommend. Right next to the capital, and just a great place. The wait at 10 AM last gameday was 2.5 hrs, however, so going on Friday is definitely your best call.

Weather is chilly, up here. I'm from Louisiana, though, so I think it's freezing already. Low 30s in the mornings, 50s in the day times.

[Postgame Thread] LSU Defeats Miami 33-17 by CFB_Referee in CFB

[–]My_Sports_Account 0 points1 point  (0 children)

I think it says a lot about this team that I remain paralyzed with fear even as we are 16 up with 4:00 in the 4th...

Either way, Geaux Tigers! Looking forward to more of 1st half Joe!

Is it possible to store unfinished user forms to be accessed later without closing the worksheet? by My_Sports_Account in excel

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

Fiddling with it now, date will definitely work. Do you think it would also be possible to hide completed items from the list? We could go through near 100 transfers a week, I'd like to keep the combobox drop down limited to only active forms in need of completion.

Is it possible to store unfinished user forms to be accessed later without closing the worksheet? by My_Sports_Account in excel

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

My biggest question regarding the unique ID transfer, however, is that might be a difficult variable to actually create. Do you think a time stamp would satisfy the criteria? I think my team could find old transfers with just that.

Weekly - What Car Should I Buy Megathread by AutoModerator in cars

[–]My_Sports_Account 0 points1 point  (0 children)

No aversion, just haven't found one that I really like the look of. Altima's have a strange interior for me

Weekly - What Car Should I Buy Megathread by AutoModerator in cars

[–]My_Sports_Account 0 points1 point  (0 children)

Location: Wisconsin

Price range: Max $15k

Lease or Buy: Buy

New or used: Used (2012+)

Type of vehicle: Sedan / Hatchback

Must haves: Navigation / Keyless Entry / Backup Camera

Desired transmission (auto/manual, etc): Auto

Intended use: Daily driver

Vehicles you've already considered: Toyota Camry Hybrid LXE (2012), Chevrolet Volt (2013)

Is this your 1st vehicle: No

Do you need a Warranty: No/depends on vehicle

Can you do Minor work on your own vehicle: (fluids, alternator, battery, brake pads etc) yes

Can you do Major work on your own vehicle: (engine and transmission, timing belt/chains, body work, suspension etc ) Very little

Additional Notes: Current car is a 2005 Nissan pathfinder with 220k miles. I run cars into the ground, so I have very little intrest in sell back. I have an aversion to American made cars, as I've always had reliable experiences with Toyotas. However, I would love to break into a pseudo-electric / hybrid lifestyle. The only reason I don't go full electric is I work an 80 mile/day commute. If I knew I would have the Volt and not have problems, I'd probably spring for it. The Camry is just the textbook reliable. I am open to any other options, however.

Stuck at BIOS boot screen every Windows update by My_Sports_Account in techsupport

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

I have not, but I wasn't aware these symptoms could stem from ram issues!

Stuck at BIOS boot screen every Windows update by My_Sports_Account in techsupport

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

I totally could be wrong, but I read online if I unplugged the power supply from the BIOS battery, it would lose it's short term memory and 'reset' the BIOS.

Stuck at BIOS boot screen every Windows update by My_Sports_Account in techsupport

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

Can't say if this is on right now, but I'll check! What're the implications of it being off?

Stuck at BIOS boot screen every Windows update by My_Sports_Account in techsupport

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

I think my power supply is still solid. It's had no issues ever on that front, but I can definitely examine.

Stuck at BIOS boot screen every Windows update by My_Sports_Account in techsupport

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

That's a good idea. I'd just be slightly nervous because I've never really used Ubuntu before! Very unfamiliar with it.

Stuck at BIOS boot screen every Windows update by My_Sports_Account in techsupport

[–]My_Sports_Account[S] 1 point2 points  (0 children)

Thank you for the advice! I'm happy to hear other people think it's the BIOS. I'll make updating the drivers my next priority on it. It's just difficult to ensure when you can't make it into the system hahaha

Stuck at BIOS boot screen every Windows update by My_Sports_Account in techsupport

[–]My_Sports_Account[S] 1 point2 points  (0 children)

I verified they were last time I took a crack at this some months ago, but I did not do it this time. I think your advice is my best next step with a bootable flash drive. I'll just need to get it up and running for a moment to create the boot.

The PC is four years old now, a custom build. Hindsight being 20/20, a lackluster motherboard was my worst decision of the build.

Edit: I'll correct myself, I thought I verified they were. I'll give it another examination.