The Captain
Junior Associate
Hugs are good...
Joined: Jan 4, 2011 16:21:23 GMT -5
Posts: 8,717
Location: State of confusion
Favorite Drink: Whinnnne
|
Post by The Captain on Sept 23, 2015 13:57:26 GMT -5
Must be nice to have a worldview where you can deny responsibility for your actions because the long term effects don't physically impact you.
|
|
The Captain
Junior Associate
Hugs are good...
Joined: Jan 4, 2011 16:21:23 GMT -5
Posts: 8,717
Location: State of confusion
Favorite Drink: Whinnnne
|
Post by The Captain on Sept 23, 2015 11:09:55 GMT -5
It's ok suesinfl - we get it. Rant all you want. I just came to the realization recently that my time on this rock is now waning, as opposed to waxing. Making me thing about a lot of things.
|
|
The Captain
Junior Associate
Hugs are good...
Joined: Jan 4, 2011 16:21:23 GMT -5
Posts: 8,717
Location: State of confusion
Favorite Drink: Whinnnne
|
Post by The Captain on Sept 23, 2015 11:07:15 GMT -5
Ok, been thinking on this for almost a day. Still thinking. Obviously I'm not a very spontaneous person. Decided to order in Chinese one night last week instead of cooking. Does that count? What is your worst personality trait?
|
|
The Captain
Junior Associate
Hugs are good...
Joined: Jan 4, 2011 16:21:23 GMT -5
Posts: 8,717
Location: State of confusion
Favorite Drink: Whinnnne
|
Post by The Captain on Sept 23, 2015 10:31:06 GMT -5
Beth - the second example in the link in my post tells you how to write the command. Vlookup will work as well, you just need to be more careful with how you write it. Can you give us the layout of your files, for example Spreadsheet #1 Column A = name (unique identifier) Spreadsheet #2 Column D = name (same unique identifier) Column E = field/data I want to pull into spreadsheet #1 Here's how vlookup works: support.office.com/en-us/article/VLOOKUP-function-0BBC8083-26FE-4963-8AB8-93A18AD188A1
|
|
The Captain
Junior Associate
Hugs are good...
Joined: Jan 4, 2011 16:21:23 GMT -5
Posts: 8,717
Location: State of confusion
Favorite Drink: Whinnnne
|
Post by The Captain on Sept 23, 2015 10:23:55 GMT -5
(slinks off into a corner) Coming to sit with me, are you? YES! Because I'm sure you have something I need - Chocolate!!! Can't remember - are you into wine also? Cause I could use some whine to go with that Chocolate. (Whinnnnnnees) I want this day to be overrrrrrr. I want to be on vacation nooowwwww!
|
|
The Captain
Junior Associate
Hugs are good...
Joined: Jan 4, 2011 16:21:23 GMT -5
Posts: 8,717
Location: State of confusion
Favorite Drink: Whinnnne
|
Post by The Captain on Sept 23, 2015 10:19:18 GMT -5
*Hangs head in embarrassed techno amateur shame* Yea, should have been able to figure that out... We all have things we never really think about until someone points it out and we feel stupid. As long as it doesn't happen multiple times a day, you're good. (slinks off into a corner)
|
|
The Captain
Junior Associate
Hugs are good...
Joined: Jan 4, 2011 16:21:23 GMT -5
Posts: 8,717
Location: State of confusion
Favorite Drink: Whinnnne
|
Post by The Captain on Sept 23, 2015 10:11:50 GMT -5
Well the audio input jack makes it all kinds of easy then. No bluetooth required, just that one cord that you can buy cheap just about anywhere. *Hangs head in embarrassed techno amateur shame* Yea, should have been able to figure that out...
|
|
The Captain
Junior Associate
Hugs are good...
Joined: Jan 4, 2011 16:21:23 GMT -5
Posts: 8,717
Location: State of confusion
Favorite Drink: Whinnnne
|
Post by The Captain on Sept 23, 2015 10:08:47 GMT -5
|
|
The Captain
Junior Associate
Hugs are good...
Joined: Jan 4, 2011 16:21:23 GMT -5
Posts: 8,717
Location: State of confusion
Favorite Drink: Whinnnne
|
Post by The Captain on Sept 23, 2015 10:02:53 GMT -5
Nope! No cassette. I have a CD player and an audio input jack.
May stay away from the Bluetooth thing, though. Since I'm not familiar with it, I may need to fiddle or do stuff while driving and I'd prefer to keep my hands on the wheel.
That's why I burn a CD or create a long playlist on my tablet. I just set it and forget it.
|
|
The Captain
Junior Associate
Hugs are good...
Joined: Jan 4, 2011 16:21:23 GMT -5
Posts: 8,717
Location: State of confusion
Favorite Drink: Whinnnne
|
Post by The Captain on Sept 23, 2015 9:52:27 GMT -5
It almost, almost makes me want to reactivate my Sirius... do you have a smartphone and bluetooth in your car? you can stream Pandora through your car's speakers. I've been doing that since I discovered it was possible a few weeks back......but I also have unlimited data on my phone. be careful with that. I have a phone that is smarter than I am, yes. I'm on a T-Mobile plan which allows for unlimited music streaming from several services including Pandora. Bluetooth - maybe? I have a 2010 Malibu so it seems likely. Now I have to go google how to set up Bluetooth. Dayum! The free music list is a LOT longer than the last time I checked - they've even added a Jazz site! Music services include: •Apple Music •Pandora •iHeartRadio •Rhapsody •Beatport •Spotify •Slacker •Radical.FM •8tracks •Samsung Milk Music •Black Planet •Songza •Rdio •Radio Paradise •AccuRadio •SoundCloud •Saavn •Digitally Imported •JAZZRADIO.com •ROCKRADIO.com •RadioTunes •radioPup •radio.com •Mad Genius Radio •Groove Music •Live365 •Fresca Radio •Google Music •Fit Radio •SiriusXM •Tidal Music •MixRadio •BandCamp
|
|
The Captain
Junior Associate
Hugs are good...
Joined: Jan 4, 2011 16:21:23 GMT -5
Posts: 8,717
Location: State of confusion
Favorite Drink: Whinnnne
|
Post by The Captain on Sept 23, 2015 9:04:15 GMT -5
I'd throw in some Boston & Rush. I'd also add some Dixie Chicks but you may not like country music. Huh, checked my CD collection last night and am embarrassed to admit I don't own a single Boston CD. I DO have moving pictures, though - and am adding a few tracks from that to the playlist. I'm ok with country, but never enough to go buy the albums.
|
|
The Captain
Junior Associate
Hugs are good...
Joined: Jan 4, 2011 16:21:23 GMT -5
Posts: 8,717
Location: State of confusion
Favorite Drink: Whinnnne
|
Post by The Captain on Sept 23, 2015 9:00:39 GMT -5
boooooo! I need to stay away during the drive, not be lulled into slumberland! (Sheepishly admits she has a few Abba, John Denver, Peter Paul & Mary CD's)
|
|
The Captain
Junior Associate
Hugs are good...
Joined: Jan 4, 2011 16:21:23 GMT -5
Posts: 8,717
Location: State of confusion
Favorite Drink: Whinnnne
|
Post by The Captain on Sept 23, 2015 8:57:48 GMT -5
It almost, almost makes me want to reactivate my Sirius...
|
|
The Captain
Junior Associate
Hugs are good...
Joined: Jan 4, 2011 16:21:23 GMT -5
Posts: 8,717
Location: State of confusion
Favorite Drink: Whinnnne
|
Post by The Captain on Sept 23, 2015 8:56:55 GMT -5
Ok. I'm in mentally checked out version 2.0 I leave pre-dawn tomorrow for a road trip to visit my sissy, BIL, and Dad (and her cat, there has to be at least one cat to pet). Just came down off my busiest filing season, had a two hour status update with my boss yesterday on all the open projects, got the celebratory luncheon for the floor today planned, and just really want to take a long nap. BUT noooooo - I have a state auditor in today so I have to stay/behave.
|
|
The Captain
Junior Associate
Hugs are good...
Joined: Jan 4, 2011 16:21:23 GMT -5
Posts: 8,717
Location: State of confusion
Favorite Drink: Whinnnne
|
Post by The Captain on Sept 23, 2015 8:52:46 GMT -5
Swamp, please give your thoughts on The Book of Mormon. I NEVER laughed so hard for so long in my life! Yea That!!!
|
|
The Captain
Junior Associate
Hugs are good...
Joined: Jan 4, 2011 16:21:23 GMT -5
Posts: 8,717
Location: State of confusion
Favorite Drink: Whinnnne
|
Post by The Captain on Sept 23, 2015 8:49:10 GMT -5
Why not listen to some books instead? I have never been able to get into audio books. Never. As weird as it sounds, I actually get so distracted by someone reading to me (even when DH tries it at home) that I have a hard time concentrating. Tried several times, but I prefer actually reading the books myself.
|
|
The Captain
Junior Associate
Hugs are good...
Joined: Jan 4, 2011 16:21:23 GMT -5
Posts: 8,717
Location: State of confusion
Favorite Drink: Whinnnne
|
Post by The Captain on Sept 23, 2015 8:46:55 GMT -5
If it has been around for 62 years why is there still a patent on it? Or why can't other companies gear up to sell it? Hickle - I used to work for a chemical, human, and animal drug manufacturing company. The cost to build a plant to manufacture one active ingredient was over $100M. Now I'm sure existing plants can be re-tooled etc, but still the start up costs (and don't forget the FDA approval process which takes many months if not years, even for generics) are very high. The volume and price justification has to be there. There's just a large enough market for this drug at the old price point to justify a competitor trying to make a generic. This is why there are so many "Orphan Drug" causes out there. Besides actually finding something to cure or treat the condition, the cost to manufacture the drug is usually not justified by the market size. Sounds cruel, but if companies constantly lose money trying to treat the orphan conditions, there wouldn't be anyone left in business to address the treatable conditions. I can't speak for every company but despite the economics, the company I worked for did continue to produce several loss leaders because there were no alternatives available in the market.
|
|
The Captain
Junior Associate
Hugs are good...
Joined: Jan 4, 2011 16:21:23 GMT -5
Posts: 8,717
Location: State of confusion
Favorite Drink: Whinnnne
|
Post by The Captain on Sept 22, 2015 15:35:58 GMT -5
How long is the trip anyway? Listen to a favorite band's entire catalog. Um........ I'll let you know if I have any good ideas. The trip is 9 hours. I thought about doing all Journey, but Steve Perry's voices gets a bit grating after the 3rd or 4th hour or so... Oh, OH - why did the Broadway recording of Ma a La Mancha just pop into my brain?
|
|
The Captain
Junior Associate
Hugs are good...
Joined: Jan 4, 2011 16:21:23 GMT -5
Posts: 8,717
Location: State of confusion
Favorite Drink: Whinnnne
|
Post by The Captain on Sept 22, 2015 13:33:23 GMT -5
Before we get all hysterical about lack of family planning, need I remind everyone that there are no less than 12 generic prescriptions for BC available at Walmart for less than $10 a month.You are far more likely to be able to find a walmart in a poor part of town than a Planned Parenthood facility. But don't let facts get in the way of a good rant. With all due respect . . . . which will do you absolutely NO good if you can't afford the cost of the doctor's office visit to obtain a prescription . If someone is poor they will be on Medicaid or one of the Federal health exchanges, correct? That covers doctor's visits and prescriptions. Isn't that what the whole ACA thing was about?
|
|
The Captain
Junior Associate
Hugs are good...
Joined: Jan 4, 2011 16:21:23 GMT -5
Posts: 8,717
Location: State of confusion
Favorite Drink: Whinnnne
|
Post by The Captain on Sept 22, 2015 13:23:05 GMT -5
Before we get all hysterical about lack of family planning, need I remind everyone that there are no less than 12 generic prescriptions for BC available at Walmart for less than $10 a month.
You are far more likely to be able to find a walmart in a poor part of town than a Planned Parenthood facility. But don't let facts get in the way of a good rant.
|
|
The Captain
Junior Associate
Hugs are good...
Joined: Jan 4, 2011 16:21:23 GMT -5
Posts: 8,717
Location: State of confusion
Favorite Drink: Whinnnne
|
Post by The Captain on Sept 22, 2015 12:25:43 GMT -5
For it to be a false front though, shouldn't they be engaged in something else than what they are advertising? I'd be surprised if the NJ AAA made all that much from travel, so I did a quick web search. Appears they are loosely associated, but according to the annual report from the California/Nevada one - travel service revenue is less than 10% of membership dues.
calstate.aaa.com/sites/default/files/AAANorthernCaliforniaNevadaUtah-FinancialStatements-2014.pdf
Page 6
I didn't not know that insurance is probably the biggest revenue producer, but kind of meh on this as a huge revelation. AARP I thought was pretty well known as described. They are. AAA is the American Automobile Association, they bill their main product as "roadside assistance" and towing and what not-- they are really a Travel Agent with a market that has self-selected, and volunteered themselves to be a captive audience for their services in exchange for help with a flat tire, and/or a jump start. By the way- Goodwill Industries is FOR profit. They get their inventory free from you and I, we get a tax break, and they get a taxpayer subsidized workforce on top of it because they hire the specially abled or whatever we call people with disabilities these days. Great work- ain't pickin' on them, but most people don't know this. ArchietheDragon is right- the tax code is a mess. Paul - please cite your source for this. I know a thing or two about the tax code and for profit entities are not permitted to issue donation receipts. Here's my source: www.goodwill.org/wp-content/uploads/2013/04/GII-2012-990.pdf
|
|
The Captain
Junior Associate
Hugs are good...
Joined: Jan 4, 2011 16:21:23 GMT -5
Posts: 8,717
Location: State of confusion
Favorite Drink: Whinnnne
|
Post by The Captain on Sept 22, 2015 10:32:07 GMT -5
I write lefty, but I've been forced by the dominant culture to use a mouse with my right hand.
One of my coworkers is a lefty and she mouses lefty as well, one time I sat at her desk and I was like "how the hell do you manage?". It felt so weird to me.
Wiki tells me that Bob Dole, Rand Paul, and Hugh Jackman are all lefties. You do know they make left handed mouses, and you can even swap out the "right click" "left click" if you want...
|
|
The Captain
Junior Associate
Hugs are good...
Joined: Jan 4, 2011 16:21:23 GMT -5
Posts: 8,717
Location: State of confusion
Favorite Drink: Whinnnne
|
Post by The Captain on Sept 22, 2015 9:44:05 GMT -5
My Great Aunt did. That was over, ummm 90 years ago? Sissy is a southpaw...she never experienced this in school during the 70's (and we went through catholic school) I even remember special left handed scissors and pencil grip helper thingy's specifically for lefties. In fact, I hope it's common knowledge that trying to re-wire a dominate hand can cause neurological problems (such as aunties hands always shaking whenever she wrote something). That teacher should be suspended without pay and brought into the 20th Century before being allowed around kids again. 21st Century? The few checks I do write, I still write 2014. Was wondering if anyone was paying attention. Nope, I wrote 20th Century on purpose. By the early 70's (at least in the Chicago area) it was known that you shouldn't try to force/switch dominate hands. The same auntie I referenced lived with us and when sissy started school it was the topic of more than a few conversations. Remember, my family was old school Catholic and we went to a school where the Franciscan nuns taught. They're as conservative as you can get, but they still followed modern teaching guidelines. Now the conversations we had on switch batters and pitchers are a whole nuther ball of wax.
|
|
The Captain
Junior Associate
Hugs are good...
Joined: Jan 4, 2011 16:21:23 GMT -5
Posts: 8,717
Location: State of confusion
Favorite Drink: Whinnnne
|
Post by The Captain on Sept 22, 2015 9:20:53 GMT -5
My Great Aunt did. That was over, ummm 90 years ago?
Sissy is a southpaw...she never experienced this in school during the 70's (and we went through catholic school) I even remember special left handed scissors and pencil grip helper thingy's specifically for lefties.
In fact, I hope it's common knowledge that trying to re-wire a dominate hand can cause neurological problems (such as aunties hands always shaking whenever she wrote something).
That teacher should be suspended without pay and brought into the 20th Century before being allowed around kids again.
|
|
The Captain
Junior Associate
Hugs are good...
Joined: Jan 4, 2011 16:21:23 GMT -5
Posts: 8,717
Location: State of confusion
Favorite Drink: Whinnnne
|
Post by The Captain on Sept 22, 2015 8:43:40 GMT -5
I'm going on a roadtrip soon to visit my sissy, Dad, and BIL (the cat is a bonus) . Since I'm not huge into turning knobs and flipping buttons while on the road, I always make a CD or two with a playlist. Obviously the music has to be upbeat, and happy. This time I'm going solo so no one else to keep me focused. In the past I've done themes (Disney Soundtracks, movie sountracks, Metal head mania, 80's, old skool mixmasters) and have those on standby. But....I want a new list for this trip. Can't come up with a theme. (Bangs head on the desk) empty, useless, brain... any ideas? (Kinda thinking of a movie so bad, it's good theme - yanno - Pacific Rim, Purple Rain, Flash Gordon, Ladyhawke - I can skip the slow songs and just add the ones with a good beat)
|
|
The Captain
Junior Associate
Hugs are good...
Joined: Jan 4, 2011 16:21:23 GMT -5
Posts: 8,717
Location: State of confusion
Favorite Drink: Whinnnne
|
Post by The Captain on Sept 22, 2015 8:19:49 GMT -5
He may be shooting himself in the foot. If the drug has been around for 62 years, and noted in Virgil Showlion's link, then the patent is expired.
Seems ripe for a generic if you ask me...
The original owner probably knew that, which is why the price was so low, generics couldn't compete when factoring in startup costs. That will change now.
|
|
The Captain
Junior Associate
Hugs are good...
Joined: Jan 4, 2011 16:21:23 GMT -5
Posts: 8,717
Location: State of confusion
Favorite Drink: Whinnnne
|
Post by The Captain on Sept 22, 2015 8:09:11 GMT -5
All the freaking time. Grrrrr - is an understatement. He pushed my buttons last night and is lucky he woke up this morning. In fact, - anyone want him? When is the last time you did a road trip solo?
|
|
The Captain
Junior Associate
Hugs are good...
Joined: Jan 4, 2011 16:21:23 GMT -5
Posts: 8,717
Location: State of confusion
Favorite Drink: Whinnnne
|
Post by The Captain on Sept 21, 2015 14:04:23 GMT -5
It's entirely possible you will have a loss on the sale of the business.
WHAT You say the business is incorporated. Here's an example. Let's assume you started with zero. You didn't buy the grocery store from anyone else. You spend $600 to incorporate, then you have to buy inventory for the store. Let's say you paid $80K for your current inventory. You purchased store fixtures for $15K and coolers/Freezers for $5K. Add another $5K for a cash register and sales tracking system and you have now put a total of $105,600 of your own money into the store. That is the basis (roughly speaking). If the buyer is only offering $98K you will have a loss on the sale. You spent $105,600, sell for $98K, thus a loss of $7,600. It's (of course) more complicated than that but this should give you an idea. This is why good records and an accountant are needed.
|
|
The Captain
Junior Associate
Hugs are good...
Joined: Jan 4, 2011 16:21:23 GMT -5
Posts: 8,717
Location: State of confusion
Favorite Drink: Whinnnne
|
Post by The Captain on Sept 21, 2015 13:28:40 GMT -5
Was your business incorporated?
Are you selling the assets of the store, or the stock of the business (do the business loans get sold with the business)?
Do you know what your basis is in your business (how much capital/cash) you've put into it.
We don't have enough information to give you good guidance right now. It's entirely possible you will have a loss on the sale of the business.
Verbal offers are a starting point for negotiations. Wait and don't do anything until you talk to your accountant.
|
|
The Captain
Junior Associate
Hugs are good...
Joined: Jan 4, 2011 16:21:23 GMT -5
Posts: 8,717
Location: State of confusion
Favorite Drink: Whinnnne
|
Post by The Captain on Sept 21, 2015 12:05:38 GMT -5
Nope - bean29 - you've got it right. As a practice note, this is one area (among many) that the Obama administration is targeting. They want to increase the capital gains rate. Personally, I don't think it will get any traction unless/until we get a 100% democratically controlled congress and presidency. Even then, it's not as popular as some other proposals.
|
|