| Tech Board|| re: Excel Question about returning values over/under a certain number - TU Rob on 3/2/15 at 8:02 pm|
[quote]Access is better for something like that.[/quote]
Yeah the girl in finance that does this for the other units runs an access query. But ours is a different loan system. And they don't have access to it. So it is up to me to filter this report and distribute it. ...
| Tech Board|| re: AT&T uverse speed question. - TU Rob on 3/2/15 at 6:33 pm|
It sucks. Keep charter. ...
| O-T Lounge|| re: Looking to get this truck. Anyone has experience with a Ram 1500? - TU Rob on 3/2/15 at 4:41 pm|
There's always a bunch of shite talked about a Ram, but I bought a new one in 2000. 2001 model, drove it for 4 years through college and grad school. Traded with my dad for his Grand Cherokee since I would be traveling a good bit for my job and he wanted a truck for a 3rd vehicle. He kept it a few...
| Tech Board|| re: TV for bedroom? - TU Rob on 3/2/15 at 2:48 pm|
[quote]I like the built on Roku, wife will like Netflix in the bed. I will report back with results. [/quote]
How are you liking it? I still haven't moved any of my TV's in the house, and when I was at Sam's the other day I saw the 40 inch version for $300. At that price, and for what I wou...
| Movie/TV Board|| re: Leonardo DiCaprio will be playing a role he's eyed for nearly 20 years. - TU Rob on 3/2/15 at 2:39 pm|
Isn't this similar to Shutter Island? It has been a while since I saw it, but he was playing a patient with multiple personalities in it, right?...
| Tech Board|| re: Excel Question about returning values over/under a certain number - TU Rob on 3/2/15 at 2:37 pm|
[quote]Excel Question about returning values over/under a certain numberWhy don't you create another column with: =if(g2>amount,"Over","") And drag it down. Then use auto filter to only select lines with Over in column G.[/quote]
Thanks. I used this in my macro. Ended up writing an imbedded ...
| Tech Board|| Excel Question about returning values over/under a certain number - TU Rob on 3/2/15 at 11:53 am|
I have a new report at work that shows us daily changes in balances. The report is automated from our system, but in order for it to capture all changes, it has to return a value for every contract we have, which is currently about 4,800 rows of data. What I would like is to run some sort of Macro...
| Tech Board|| re: Mounting and weight - TU Rob on 3/2/15 at 9:48 am|
[quote]Fixed 4-bolt mount, you should be fine. As long as it's in studs (all 4 bolts), it's likely capable of well over 55 lbs.
I was looking at a mount the other day for my son's room, but the mount was only 14" wide (32" TV). So it wasn't capable of reaching 2 studs. I ordered a larger one so I...
| O-T Lounge|| re: "Fabric protection" for new furniture - yea or nay? - TU Rob on 3/2/15 at 9:23 am|
$150-200 seems like a steep markup for some ScotchGard. We had it added to a couch we bought 10 years ago. Couch still looks great. But I think we paid $20. They had a compressor set up with a sprayer, and sprayed the whole thing right in front of us before loading it into our truck. Wrapped it...
| O-T Lounge|| re: Who here pays their bills at the place of business? - TU Rob on 2/27/15 at 8:49 am|
[quote]I don't use my bank's payment system. I just give all my service providers a credit card # or bank account # for automatic payments. What is the advantage of using the bank system?[/quote]
None. I have all of mine set up on draft through my CC, get cash back rewards on it. The only two I...
| Food and Drink Board|| re: How often do you drink adventerous cocktails - TU Rob on 2/26/15 at 11:19 am|
[quote]I lean more this way. Mixology just doesn't do it for me. I'd rather drink a beer or wine, and if I'm drinking liquor it usually doesn't involve more than 3 ingredients. [/quote]
I will occasionally have a cocktail. For special occasions, like the Derby, I'll mix up a batch of Mint Juleps...
| O-T Lounge|| re: In 1 hr, every single human in the entire world will begin looking for you... - TU Rob on 2/26/15 at 11:10 am|
I would like for my hour to start right when a massive snow/ice storm hits the southeast. All the people down here freak out when the roads turn to slush. Pretty sure I could get somewhere remote and inaccessible for a couple of days in my Jeep. Once it thaws out, that only gives people about 2-3...
| Food and Drink Board|| re: How often do you drink adventerous cocktails - TU Rob on 2/24/15 at 10:35 pm|
Sometimes I get really adventurous and add ice.
Like my father always said, we're having mixed drinks. We take bourbon and mix it with ice and a glass. Ice optional. ...
| O-T Lounge|| re: wanting to take a pic of chick, app idea - TU Rob on 2/24/15 at 10:28 pm|
| O-T Lounge|| re: Could you beat Ronda Rousey in a fight (ufc rules)? - TU Rob on 2/24/15 at 12:25 pm|
I'm the same height so there's no advantages there, and have 50 lbs on her. I'm not in my best shape but with a month to prepare it would be fun. I can take a punch. But I'm a bigger target than she would be. At some point stamina and strength come into play. She may have me on stamina but I've got ...
| Outdoor Board|| re: State Snapper Season - TU Rob on 2/24/15 at 11:11 am|
And I thought the 2 week season a few years ago going out of Florida was brutal.
BTW, can anyone recommend a small charter out of the Orange Beach area the week leading up to July 4th? There will be 4-5 adult males, and perhaps an almost 9 year old boy. Probably don't want a 12 hour, 8 would ...
| O-T Lounge|| re: In 1 hr, every single human in the entire world will begin looking for you... - TU Rob on 2/24/15 at 11:07 am|
[quote]You forgot the hitchhike, muslim woman disguise, and above ground grave parts[/quote]
The train/4 wheeler/bike/pirouge scenario doesn't involve hitchhiking, and you don't want to be dressed as a muslim woman when encountering the horny sorority submarine inhabitants, and we're going underg...
| O-T Lounge|| re: In 1 hr, every single human in the entire world will begin looking for you... - TU Rob on 2/24/15 at 11:03 am|
So to recap, toss your cell phone in your friend's attic, toss your other cell phone on a greyhound bus, hop a train to a remote location, then ride a 4wheeler to some place near a large body of water then sink it in the water, ride a bike to another part of the water and sink it under a log, ride y...
| O-T Lounge|| re: car battery has a mileage warranty... - TU Rob on 2/24/15 at 10:28 am|
[quote]With the things that can go wrong with vehicles, if $100.00 can fix it I'm not complaining. [/quote]
And batteries are one of the easiest things to replace on most vehicles. I had to put a new one in my wife's Van last night. It was dead so instead if jumping it off and driving it to the s...
| O-T Lounge|| re: In 1 hr, every single human in the entire world will begin looking for you... - TU Rob on 2/24/15 at 9:15 am|
[quote]That was one thought I had. Is there anything smart about the strategy of maybe getting on offense a little bit? Maybe as soon as you get the notice that you have an hour, steal a car and somehow ram it (jumping out beforehand) into a power substation, police hq, or something. May not be the ...