BigDMcGee 3,352 Posted June 4, 2017 Share Posted June 4, 2017 How are you always lurking in the shadows, BigD? That's impressive. I'm not always in the shadows. I just check the website once or twice a day. Which pretty much means, I check this thread once or twice a day. I just don't always comment because most of it is about Austin's boring life and not something interesting like Shake. 3 Link to post Share on other sites
SuitedAces21 2,721 Posted June 5, 2017 Share Posted June 5, 2017 i think i'm getting exactly what i deserve. Link to post Share on other sites
Ron_Mexico 4,219 Posted June 5, 2017 Share Posted June 5, 2017 i think i'm getting exactly what i deserve. Deserves got nothing to do with this Link to post Share on other sites
Napa Lite 3,278 Posted June 5, 2017 Share Posted June 5, 2017 Strat, I just what I think is a really cool thing with excel that I want to tell you about but I'm worried you'll just be like "uh, there's an excel feature that does that" because there probably is. But I'm going to tell you anyways. Basically, I have a dump from all our branches showing all active accounts. And this creates a pivot table of all new accounts and then from that pivot table I formulla'ed out a report that populates by every branch and then the # of new accounts by type, how many of those were new customers, the avg age of those new customers, and the avg balance and total balances by account type and then it subtotals each branch and I set the conditional formatting to make it very clear where each new branch summary starts. And then every month it will automatically reconfigure itself all without any blank spaces between each section so it's only ever as long as it needs to be. Link to post Share on other sites
InternetExplorer 2,609 Posted June 5, 2017 Share Posted June 5, 2017 That sounds pretty neat. I bet it was a bitch to figure all of that out. I doubt I could do it easily. My annual review is coming up in a month or so, meaning I am about as irritated with my comp as I will ever be throughout a given cycle. I also had a pretty demoralizing experience 2-3 weeks ago with this upcoming incentive deal, where I was originally in the "haves" group, then got returned to the "have nots" due to the way it played out. So basically, I am in a pretty hard line mindset right now, and am fantasizing about job searching in places like LA, should my bump be anything less than anticipated. Link to post Share on other sites
Napa Lite 3,278 Posted June 5, 2017 Share Posted June 5, 2017 It really wasn't that bad. I've done similar stuff in the past, just not with the subtotalling. Embarrassingly enough conditional formatting trips me up more often than not. Link to post Share on other sites
Essay21 2,385 Posted June 5, 2017 Share Posted June 5, 2017 Jesus, I mastered conditional formatting in the womb. Some d bags car alarm went off at 530 this morning and that was all she wrote. Im gonna have to hit the sack early tonight. Link to post Share on other sites
Napa Lite 3,278 Posted June 6, 2017 Share Posted June 6, 2017 I know, I'm ashamed. You all may recall my concern about the less than stellar health insurance here. Well, I was looking over the benefits section and they have a second option they didn't inform me about that's $60 more a month ($180 vs $120) but it actually covers prescriptions and has a lower overall deductible but it's still considered a HDHP that's HSA eligible. So by paying $60 more a month it'll save me literal thousands a year. Plus, barring some emergency, I won't come close to using my full HSA balance every year so that might actually be useful as a retirement savings vehicle. This has made my day, to say the least. 1 Link to post Share on other sites
iZuma 764 Posted June 6, 2017 Share Posted June 6, 2017 That's amazing napa I'm so happy My house and land are still there. House deteriorating but getting cleaner every month. Throwing stuff away steadily. Still not decided on when and where to move to in the big city but I guess I gotta figure it out at some point. And Ron I felt weird commenting on those things I'm tagged in. I'm not familiar with facebook etiquette. Wedding is on Friday at THE BEACH. sweet hotel room booked too. Costs about as much as a damn house so it better be good. 4 Link to post Share on other sites
Napa Lite 3,278 Posted June 6, 2017 Share Posted June 6, 2017 I choose to believe you were being genuine because if you weren't I might just START YOUR PRECIOUS BEACH ON FIRE. 1 Link to post Share on other sites
InternetExplorer 2,609 Posted June 6, 2017 Share Posted June 6, 2017 I thought you moved to Houston or something? Link to post Share on other sites
Napa Lite 3,278 Posted June 6, 2017 Share Posted June 6, 2017 Well I hope you're happy, Shake. Adp lied to me and I can't actually enroll in that plan even though it says it's an option. Link to post Share on other sites
Essay21 2,385 Posted June 6, 2017 Share Posted June 6, 2017 A strongly worded letter from your attorney might spur them to action. Link to post Share on other sites
Essay21 2,385 Posted June 7, 2017 Share Posted June 7, 2017 Coincidentally, my cousin is selling her business and wants me to review the contract. Hopefully no one gets sued. Link to post Share on other sites
Essay21 2,385 Posted June 7, 2017 Share Posted June 7, 2017 You guessed it, they were trying to steal from my kin. It was an asset purchase instead of stock purchase and an installment sale. And there was no language concerning a missed payment, no penalties, no collateral, no liability. Thing was a joke. Link to post Share on other sites
InternetExplorer 2,609 Posted June 7, 2017 Share Posted June 7, 2017 Installment sale. Get real. Link to post Share on other sites
SuitedAces21 2,721 Posted June 7, 2017 Share Posted June 7, 2017 problem is she is desperate to sell. my guess is she ends up signing some version of the horse shit document i read this morning - against my express warnings. Link to post Share on other sites
InternetExplorer 2,609 Posted June 8, 2017 Share Posted June 8, 2017 We have our JDs review stuff like that for clients all the time. People really seem appreciative, but I am guessing it ends up like your cousin more often than not (follow original plan of action anyway). Link to post Share on other sites
InternetExplorer 2,609 Posted June 8, 2017 Share Posted June 8, 2017 I'm pretty pumped for this new arcade fire album It's funny, I haven't done any job searching at all in the last year, but I am now seeing LinkedIn YouTube ads with interviewing tips. I wonder if that is some kind of a judgment call based on my work experience--any time someone's profile hits 3.5 years' experience, start planting the idea to job search? Link to post Share on other sites
SuitedAces21 2,721 Posted June 8, 2017 Share Posted June 8, 2017 We have our JDs review stuff like that for clients all the time. People really seem appreciative, but I am guessing it ends up like your cousin more often than not (follow original plan of action anyway). for my day job, i review estate plans and note changes that need to be made for the trust to function properly, and people thank me and they say this is great and that they'll call their attorney the next day and that they'll have me come with them when they make the changes and so on and so forth. and almost every time i have to badger them with calls and emails and letters to get them to actually do it. it's the second most frustrating part of the my job. Link to post Share on other sites
InternetExplorer 2,609 Posted June 8, 2017 Share Posted June 8, 2017 Not quite the same level, but the same is true of 401k recommendations. People just don't implement... 1 Link to post Share on other sites
Napa Lite 3,278 Posted June 8, 2017 Share Posted June 8, 2017 Speaking of, Strat, I would like your help again soon if you're willing to give it. Link to post Share on other sites
InternetExplorer 2,609 Posted June 9, 2017 Share Posted June 9, 2017 Sure Link to post Share on other sites
Theraflu 1,035 Posted June 9, 2017 Share Posted June 9, 2017 Coulda gone for a straight "No" reply. 1 Link to post Share on other sites
Essay21 2,385 Posted June 9, 2017 Share Posted June 9, 2017 Haha, I just remembered how I ignored stratty's advice. Link to post Share on other sites
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now