3/24/11

10 Quick Pickups for Your Personal Finances

You don't have to be an expert to manage your money and prepare for life's unexpected twists and turns.

If you're like most people, your New Years Resolutions have already expired. You haven't lost 10 pounds, you're not going to the gym five days a week, and when was the last time you called your mother?

Chances are, your financial goals have fallen by the wayside too. I don't want to discourage you from paying down debt, saving a down payment for a house, or any of those big goals that you may have set for yourself at the beginning of the year. But if you sort of tuckered out on the big things (or even if you're still going strong -- go you!), maybe it's time to set some more achievable goals. Here are 10 things you can do in an hour or less apiece to make yourself -- or your household -- more financially sound.

1. Join Mint
I'm an unabashed fan of the site, and not just because they do some great data-mining on their blog. (Don't worry, all at the very aggregate level). It will track and aggregate your spending for you, showing you where the money is going, and what's happening to your net worth over time. If you have sort of complicated finances -- as I do, living in a two-journalist household -- then it's an absolute godsend at tax and expense time. And in the last year they've added goals, allowing you to set your spending, saving, and debt-reduction goals and then track how you're doing with a thermometer. It's surprisingly motivating, and it's free.

I probably spend 20 minutes a week in Mint, categorizing our expenses and monitoring our financial position. But even if you don't put in that kind of time (and most of you don't have to keep track of which meals are tax-deductible), it's still incredibly helpful at tracking the broad outlines of your spending.

2. Get Your Papers Together
If you die, someone is going to have to clean up the financial aftermath. Make it easy on them by putting everything in one place where they can find it. Dave Ramsey calls this a "Legacy Drawer," and suggests putting in a cover letter and letters to your loved ones as well as the financial papers. But we're trying to keep this under an hour, so the notes are optional. Here's what it should contain:

• Insurance papers.
• Loan documents.
• A list of every financial account: loans, bank accounts, investment accounts, 401(k)s, whatever. Security experts will kill me for saying this, but I'd say this list should have the account numbers, the PINs, and the passwords.
• Deeds and titles to any property you own (cars, land, etc).
• Birth certificate and social security card, if you have them.
• Information about your will/estate plans: who has them, who the executor is.
• Funeral instructions (if any; mine are "cheapest coffin you can find").
• Tax returns.
• A list of your major recurring expenses (so people know which bills to pay).

Start by putting this in a drawer; eventually, you should move this to a safe-deposit box, and tell whoever's likely to be taking care of your final details where to find the key. This should only take you an hour -- if it takes you longer than that, well, you really needed to get these documents while you could find them anyway.

3. Buy Life Insurance
If you're single, you don't need this unless you have a kid or someone else depending on you -- your job usually offers you enough to bury you. If you're married, I think you do need a little, even if you don't have kids. Married life is usually built on the expectation of two incomes: a mortgage (or lease), the cars, all sorts of other recurring expenses. At a minimum, make sure your partner will have enough to bury you and pay off any outstanding debt -- including not only mortgages and cars, but credit cards and student loans in their name alone, if you own property. You don't want to have to hassle with someone coming after their half of the house or car to pay off their unsecured debt. Obviously, if your partner is at home, or makes very little money, you're also going to want to replace some of your income.

You do not want "whole life" insurance, "return of premium" or any other product that promises you to give you some or all of your money back -- all this is is a savings vehicle with bad rates of return, bundled with expensive term life insurance. Buy a simple term life policy for 20 or 30 years -- long enough for you to accumulate enough assets to take care of your partner if you die. You can compare rates online or mosey down to your local insurance office, but either way, this shouldn't take you too long provided that you resist the blandishments of insurance agents who will attempt to upsell you "features" you don't need. Stand firm, buy term.

4. Cancel Stupid Recurring Expenses
Remember when you thought you'd try Stamps.com? How about that credit monitoring service you signed up for eighteen months ago? The dual subscriptions to Netflix left over from before you moved in together? For many of you, I am sad to say, your gym membership also falls into this category.

Whatever it is, if you haven't used it in three months, cancel it. Cancel it whether or not you think you should be using it. You can always rejoin the gym after you've developed a burning desire to actually go. With the hundreds of dollars you will save between now and then, you will easily be able to afford any re-initiation fees.

5. Ramp Up for Retirement
Unless you are already at the legal maximum, increase your 401(k) contribution by 1% of your income. Unless you are already pinching pennies so hard that Abraham Lincoln is actually screaming in pain, you can afford to put an extra 1% of your pre-tax income into your 401(k). Then every time you get a raise, you increase your contribution by another 1% until you hit the legal limit ($16,500) or 15-20% of your income. Almost painless, and you'll feel a lot safer in retirement. (Of course, if you want to save faster, you can -- try 2% or 3%).

6. Start Saving
If you don't have an emergency fund, you need one. Here's how to do it so that you almost won't notice: set up an automatic transfer into your savings account from every paycheck. Figure out how much can you afford, but even if it's only $25, transfer it from every paycheck, and resolve not to touch that money unless it's an actual emergency. (Emergency: my car won't start. Not an emergency: I really need a break, so I'm going to the beach for a week.)

The ideal way to handle this is to have a separate account that isn't linked to your other bank accounts, and to have the transfer done as part of your auto-deposit. That way, you never see the money -- and I think you'll be surprised to find that you don't much miss it. But if you don't want to go to the trouble, you can do this with your regular savings account, as long as you're resolved not to touch the money in that account for anything but an emergency: just use online banking to do a recurring transfer on the same day as your paycheck hits the account.

Over time, increase the amount that you're saving. Eventually you'll have a tidy nest egg, and because the money was never in your checking account, you won't have been tempted to spend it on incidentals.

7. Re-balance Your Portfolio
If you already have substantial assets, it's time to make sure they're correctly structured for your priorities. Are your mutual funds allocated the way that you want them, or over time, has one grown faster than the others, leaving your portfolio lopsided (many companies now automatically re-balance, but you should check.) You should also be thinking about your portfolio's life-cycle. If you're in your fifties, you should already be transitioning some of your money to bonds.

I know what you're going to say: you'll never be able to retire at those kinds of returns. My response is a piece of wisdom that I picked up from my driving instructor: "If you left late, you're going to get there late." Trying to flout that simple equation only gets you in trouble. Just as it's a bad idea to race through red lights in the hopes of making up the lost time, it's a bad idea to leave your assets in 100% equity because you're hoping that higher returns will still let you retire in comfort at 65. Risking destitution now is just compounding your earlier planning errors.

8. Make a Will
If your finances are pretty simple, you can do this in half an hour with something like Quicken Willmaker, which took Lifehacker half an hour. LegalZoom will also do it for you for a pretty modest fee. If your finances are complicated -- well, OK, this won't take under an hour, and you need a lawyer. But if your finances are complicated, you really need a will. If it freaks you out too much to meditate upon your own death, pretend that you are preparing this will so you can drop out of sight and assume your new identity as Agent 007 of Her Majesty's Secret Service.

9. Fix Your Withholding
Are you looking forward to a nice big refund from the IRS this year? Don't look so happy -- that refund means that you made the government an interest-free loan for most of the year. And if you're like many freelancers, and you owe the government a hefty chunk, then you may be liable for interest and penalties.

The easy way to fix either problem is to adjust your withholding. HR can help you do this. If you're getting a big refund every year, raise your exemptions; if you're having to pay, lower them. (If they're already as low as they can get, look at what you owe this year, adjust for what you'll owe next year ... and start making estimated payments every quarter.)

10. Shop for Better Deals
Can you get a better interest rate on your credit cards? How about your bank accounts? You don't have to follow through, if you decide it's not worth it. But it's worth taking 15 minutes on the web to find out. Also worth doing: threaten to cancel your cable. You don't have to actually do it -- though with Netflix and Hulu and Amazon Prime's new subscription service, it's possibly worth it. But if you call to cancel, they'll usually offer you a better deal.

http://financiallyfit.yahoo.com/finance/article-112368-8971-3-10-quick-pickups-for-your-personal-finances

3/22/11

Skimp or Splurge - Millionaire’s Car

We live in a very nice neighborhood where the houses and yards are well-tended, and new, shiny luxury cars are parked in most of the garages. I’m proud to say that in our garage are two of the least impressive cars in the neighborhood - an eight year old Pontiac and 11 year old Ford. Why do we skimp? Because doing so pays handsomely, and by handsomely I mean to the tune of $1.9 million dollars. Here’s my cost-benefit analysis.

Costs of the new car
I compared the costs of two imaginary families. The image conscious Jones family must drive $60,000 luxury SUVs, and wouldn’t be caught dead in a model that is more than three years old. Across the street, lives the Thriftys, a family with less invested in their image and more invested in their future. They feel no pressure to keep up with the Joneses, or anyone else. They buy $24,000 Fords and keep them for ten years.

Depreciation - Cars depreciate at a greater rate when they are new.
Sales tax - The Joneses pay a much greater tax, every three years, vs. the Thriftys.
Ownership tax - Most states impose a license tax based on the value of the car.
Insurance - More expensive cars cost more to insure.
Gasoline - The SUV gets 13 MPG while the Ford economy car gets 26 MPG.
Maintenance - Everything is covered on the SUV - The Ford has an average cost of $1,000 after the first three years.



On average, each of the two Lexus SUVs cost $15,060 annually, while the Ford clocks in at $10,000 less. This leaves the Thriftys with $20,000 annually to invest. If the investments return seven percent annually, the Thriftys will have built up a $1.9 million portfolio after 30 years. Of course to get that rate, you’ve got to keep expenses and emotions out of the equation and be a rational investor.

Benefits of the new car
You’ll get no argument from me that the Lexus SUVs are a little slice of automobile heaven. And I admit that I enjoy being a passenger in someone else’s Lexus. Getting a new car, with that new car smell, brings a certain pleasure and psychological well being. But studies show that this happiness is inevitably short-lived, even turning into anger or sadness, as soon as you notice that first ding.

The unsexy, boring truth is that the Ford gets to any destination just as fast as the Lexus. The comfort factor seems to disappear as one gets used to the ride in any car. So, for the most part, splurging on the Lexus gets you only one thing that you don’t get with the Ford - status.

Bottom line
If you have more money than you can ever spend, then have at it with my envious blessings, and get whatever kind of car you’d like. But if you are concerned about your financial well being, skimping on a car is the single most important thing you can do to cut expenditures without giving up a single economic good since you can still go anywhere you’d like. You need only give up the psychological value of status and, if you can reframe your view of psychological value, you may be even better off there too.

My advice is to get off of the hedonic treadmill and break the chains of status-seeking. Before you know it, the Joneses will be trying to keep up with your portfolio.

Top 10 Benefits of a Millionaire’s Car
1.You can actually be a millionaire rather than only looking like one.
2.You won’t have to worry about getting a ding on your car - go ahead and park in that tight space.
3.You know your friends won’t like you only for your car.
4.You won’t be accused of being materialistic.
5.You’ll get from point A to B just as fast as the luxury car.
6.When you drive somewhere with your friends, they will want to take their car.
7.If you get pulled over, the police officer won’t give you attitude because he can’t afford your car! (Okay - I’m reaching here.)
8.When your friends make fun of it, you’ll learn which friends are snobs.
9.You’ll demonstrate your self-image can’t be manipulated by advertising agencies.
10.Did I mention it will make you a millionaire?

http://moneywatch.bnet.com/investing/blog/irrational-investor/skimp-or-splurge-millionaires-car/1705/

3/13/11

How Great Entrepreneurs Think

Think inside the (restless, curious, eager) minds of highly accomplished company builders.

What distinguishes great entrepreneurs? Discussions of entrepreneurial psychology typically focus on creativity, tolerance for risk, and the desire for achievement—enviable traits that, unfortunately, are not very teachable. So Saras Sarasvathy, a professor at the University of Virginia's Darden School of Business, set out to determine how expert entrepreneurs think, with the goal of transferring that knowledge to aspiring founders. While still a graduate student at Carnegie Mellon, Sarasvathy—with the guidance of her thesis supervisor, the Nobel laureate Herbert Simon—embarked on an audacious project: to eavesdrop on the thinking of the country's most successful entrepreneurs as they grappled with business problems. She required that her subjects have at least 15 years of entrepreneurial experience, have started multiple companies—both successes and failures—and have taken at least one company public.

Sarasvathy identified 245 U.S. entrepreneurs who met her criteria, and 45 of them agreed to participate. (Responses from 27 appeared in her conclusions; the rest were reserved for subsequent studies. Thirty more helped shape the questionnaire.) Revenue at the subjects' companies—all run by the founders at that time—ranged from $200 million to $6.5 billion, in industries as diverse as toys and railroads. Sarasvathy met personally with all of her subjects, including such luminaries as Dennis Bakke, founder of energy giant AES; Earl Bakken of Medtronic; and T.J. Rodgers of Cypress Semiconductor. She presented each with a case study about a hypothetical start-up and 10 decisions that the founder of such a company would have to make in building the venture. Then she switched on a tape recorder and let the entrepreneur talk through the problems for two hours. Sarasvathy later collaborated with Stuart Read, of the IMD business school in Switzerland, to conduct the same experiment with professional managers at large corporations—the likes of Nestlé, Philip Morris, and Shell. Sarasvathy and her colleagues are now extending their research to novice entrepreneurs and both novice and experienced professional investors.

Sarasvathy concluded that master entrepreneurs rely on what she calls effectual reasoning. Brilliant improvisers, the entrepreneurs don't start out with concrete goals. Instead, they constantly assess how to use their personal strengths and whatever resources they have at hand to develop goals on the fly, while creatively reacting to contingencies. By contrast, corporate executives—those in the study group were also enormously successful in their chosen field—use causal reasoning. They set a goal and diligently seek the best ways to achieve it. Early indications suggest the rookie company founders are spread all across the effectual-to-causal scale. But those who grew up around family businesses will more likely swing effectual, while those with M.B.A.'s display a causal bent. Not surprisingly, angels and seasoned VCs think much more like expert entrepreneurs than do novice investors.

The following is a summary of some of the study's conclusions, illustrated with excerpts from the interviews. Understanding the entrepreneurs' comments requires familiarity with what they were evaluating. The case study and questions are too long to reproduce here. But briefly: Subjects were asked to imagine themselves as the founder of a start-up that had developed a computer game simulating the experience of launching a company. The game and ancillary materials were described as tools for teaching entrepreneurship. Subjects responded to questions about potential customers, competitors, pricing, marketing strategies, growth opportunities, and related issues. (The full case study and questions can be found here.)

Quotes have been edited for length, though we wish we had room to run them in their entirety. Sarasvathy remained almost silent throughout, forcing the founders to answer their own questions and externalize their thinking in the process. The transcripts, riddled with "ums" and "ers," doublings-back on assumptions, and references to personal rules of thumb, read like verbal MRIs of the entrepreneurial brain in action.

Do the doable, then push it
Sarasvathy likes to compare expert entrepreneurs to Iron Chefs: at their best when presented with an assortment of motley ingredients and challenged to whip up whatever dish expediency and imagination suggest. Corporate leaders, by contrast, decide they are going to make Swedish meatballs. They then proceed to shop, measure, mix, and cook Swedish meatballs in the most efficient, cost-effective manner possible.

That is not to say entrepreneurs don't have goals, only that those goals are broad and—like luggage—may shift during flight. Rather than meticulously segment customers according to potential return, they itch to get to market as quickly and cheaply as possible, a principle Sarasvathy calls affordable loss. Repeatedly, the entrepreneurs in her study expressed impatience with anything that smacked of extensive planning, particularly traditional market research. (Inc.'s own research backs this up. One survey of Inc. 500 CEOs found that 60 percent had not written business plans before launching their companies. Just 12 percent had done market research.)

When asked what kind of market research they would conduct for their hypothetical start-up, most of Sarasvathy's subjects responded with variations on the following:

"OK, I need to know which of their various groups of students, trainees, and individuals would be most interested so I can target the audience a little bit more. What other information...I've never done consumer marketing, so I don't really know. I think probably...I think mostly I'd just try to...I would...I wouldn't do all this, actually. I'd just go sell it. I don't believe in market research. Somebody once told me the only thing you need is a customer. Instead of asking all the questions, I'd try and make some sales. I'd learn a lot, you know: which people, what were the obstacles, what were the questions, which prices work better. Even before I started production. So my market research would actually be hands-on actual selling."

Here's another:

"Ultimately, the best test of any product is to go to your target market and pretend like it's a real business. You'll find out soon enough if it is or not. You have to take some risks. You can sit and analyze these different markets forever and ever and ever, and you'd get all these wonderful answers, and they still may be wrong. The problem with the businessman type is they spend a lot of time with all their great wisdom and all their spreadsheets and all their Harvard Business Review people, and they'd either become convinced that there's no market at all or that they have the market nailed. And they'd go out there big time, with a lot of expensive advertising and upfront costs, because they're gonna overwhelm the market, and the business would go under."

The corporate executives were much more likely to want a quantitative analysis of market size:

"If I had a budget, I could ask a specialist in the field of education to go through data and give me ideas of how many universities, how many media, how many large companies I will have to contact to have an idea of the work that has to be done."

Sarasvathy explains that entrepreneurs' aversion to market research is symptomatic of a larger lesson they have learned: They do not believe in prediction of any kind. "If you give them data that has to do with the future, they just dismiss it," she says. "They don't believe the future is predictable...or they don't want to be in a space that is very predictable." That attitude is a bit like Voltaire's assertion that the perfect is the enemy of the good. In this case, the careful forecast is the enemy of the fortuitous surprise:

"I always live by the motto of 'Ready, fire, aim.' I think if you spend too much time doing 'Ready, aim, aim, aim,' you're never going to see all the good things that would happen if you actually started doing it. I think business plans are interesting, but they have no real meaning, because you can't put in all the positive things that will occur...If you know intrinsically that this is possible, you just have to find out how to make it possible, which you can't do ahead of time."

That said, Sarasvathy points out that her entrepreneurs did adopt more formal research and planning practices over time. Their ability to do so—to become causal as well as effectual thinkers—helped this enduring group grow with their companies.

Woo partners first
Entrepreneurs' preference for doing the doable and taking it from there is manifest in their approach to partnerships. While corporate executives know exactly where they are going and follow a prescribed path to get there, entrepreneurs allow whomever they encounter on the journey—suppliers, advisers, customers—to shape their businesses.

"I would literally target...key companies who I would call flagship: do a frontal lobotomy on them. There are probably a dozen of those I would pick. Some entrepreneurial operations that would probably be smaller but have a global presence where I'm dealing with the challenges of international sales...Building rapport with partners, with joint-venture colleagues as well as with ultimate users....The challenge then is really to pick your partners and package yourself early on before you have to put a lot of capital out."

Chief among those influential partners are first customers. The entrepreneurs anticipated customer help on product design, sales, and identifying suppliers. Some even saw their first customer as their best investor.

"People chase investors, but your best investor is your first real customer. And your customers are also your best salesmen."

Sarasvathy says expert entrepreneurs have learned the hard way that "having even one real customer on board with you is better than knowing in a hands-off way 10 things about a thousand customers." Merely gathering information from a large number of potential customers, she says, "increases all the different things you could do but doesn't tell you what you should do." Toward that end, many of her subjects described their preference for an almost anthropological approach to customer interaction: observing a few customers as they work or actually working alongside them.

"You can't go out and survey customers and say, 'OK, what kinda car do you really want?' I believe very much in living it. If you're gonna write a book about stevedores, go work as a stevedore for a period of time. My company was going to design and sell products for physical therapy, so I worked in rehab medicine for two years."

Corporate executives, by contrast, generally envisioned more traditional vendor-customer interactions, such as focus groups.

"I would like to get from them...by meeting with them or getting their input on what they think of the limitation of existing programs....just kind of sit and listen to them telling me...what new features they'd like. And I'd just listen to them talk, talk, talk and then be thinking and develop something between what they want and what's possible technically."

Sarasvathy says executives rely less on firsthand insights, because they can afford to place bets on multiple segments and product versions. "Entrepreneurs don't have that luxury," she says.

Sweat competitors later
The study's corporate subjects focused intently on potential competitors, as eager for information about other vendors as about customers. "The corporate guys are like hunter-gatherers," says Sarasvathy. "They are hired to win market share, so they concentrate fiercely on who is in the marketplace. The first thing they do is map out the lay of the land."

"What information do I want about my competition? I want to see what kinds of resources they have. Do they have computer programmers? Do they have educational experts? Do they have teachers and trainers who can roll out this product? Do they have a support structure in place? Geographically, where are they situated? Have they got one center or lots of centers? Are they doing this just in English, or do they have different languages? I'd be wanting to look at the finances of these companies....I'd probably be looking at their track record to see what kind of approach they take to marketing and advertising so I know what to expect. I might look and see what people they hire, see if I can hire away someone who might have experience."

By the time entrepreneurs start seeking investment, of course, they should be as far inside competitors' heads as they can get. But the study subjects generally expressed little concern about the competition at launch.

"Your competition is a secondary factor. I think you are putting the cart before the horse...Analyze whether you think you can be successful or not before you worry about the competitors."

And:

"At one time in our company, I ordered our people not to think about competitors. Just do your job. Think only of your work. Now that isn't entirely possible. Now, in fact, competitive information is very valuable. But I wanted to be sure that we didn't worry about competitors. And to that end, I gave the annual plan to every employee. And they said, 'Well, aren't you afraid your competitors are gonna get this information and get an advantage?' I said, 'It's much riskier to not have your employees know what you need to do than it is to run the risk of competitors finding out. Cause they'll find out somehow anyway. But if one of your employees doesn't know why they're doing their job, then you're really losing out.'"

Entrepreneurs fret less about competitors, Sarasvathy explains, because they see themselves not in the thick of a market but on the fringe of one, or as creating a new market entirely. "They are like farmers, planting a seed and nurturing it," she says. "What they care about is their own little patch of ground."

Don't limit yourself
Corporate managers believe that to the extent they can predict the future, they can control it. Entrepreneurs believe that to the extent they can control the future, they don't need to predict it. That may sound like monumental hubris, but Sarasvathy sees it differently, as an expression of entrepreneurs' confidence in their ability to recognize, respond to, and reshape opportunities as they develop. Entrepreneurs thrive on contingency. The best ones improvise their way to an outcome that in retrospect feels ordained.

So although many corporate managers in Sarasvathy's study wanted more information about the product and market landscape, some entrepreneurs pushed back on the small amount of information provided as being too limiting. For example, the description of the product as a computer game for entrepreneurship:

"I would cast it not as a product but as a family of products, which might perform a broader function like helping people make career decisions. I always look for broad market opportunities."

And:

"I wanna use this product as a platform to attract other products literally to build a market-share play. I see this as a missionary product, an entrée into some of the best users and buyers."

The most fascinating part of the study relates to the product's potential. Asked about growth opportunities, the corporate managers mostly restricted their comments to the game as described:

"It depends on how it's marketed. I'm a little bit skeptical....I'm not certain entrepreneurs would go for that. Maybe they think they already know everything. But in terms of simulations for business schools or in further education, they seem to be very popular. And entrepreneurship degrees seem to be very popular as well. So, yeah, it could well be a lot of growth."

Here is where the entrepreneurs really let loose. Starting with the same information as one another and as the executives, they collectively spun out opportunities in 18 markets—not just academic institutions but also venture capital firms, consultancies, government agencies, and the military. As much as the ability to concoct new products, it is this tendency to riff off whatever ideas or materials are handy that defines entrepreneurs as a creative breed. Reading the transcripts, you can almost hear the enthusiasm mounting in their voices as the possibilities unfold:

"This company could make a few people rich, but I don't think it could ever be huge...You might have a successful second product about how to succeed and get promoted within a large company....That would give you a market of everybody with aspirations at IBM, AT&T, Exxon, etc....You could make another product for students. How do I graduate in the top 10 percent of my class at Stanford or Harvard or Yale?...A lot about how to be a good student is teachable. Now you've got a product you can sell to every student in the country. Next there is negotiation. You could practice being a good negotiator. There's not a salesman in the United States who wouldn't buy one of those. Then you could genericize the thing to any situation which requires some sort of technical knowledge. Or learning situations within companies where you are trying to get people to understand that company's methods or objectives. So maybe I'm gonna change my opinion about the growth potential. It's easy to see how within an hour you could name 10 products that would each address huge markets, like all employees in Fortune 500 companies, who are rich enough to pay $100 for it. It could be a hit on the scale of the Lotus spreadsheet. You can see a several-hundred-million-dollar company coming from it."

You might also glean from the preceding that entrepreneurs are eternal optimists. But you don't need an academic study to tell you that.

5 Things You Should Never Say While Negotiating

If you're new to negotiating or find it difficult, here are some missteps to avoid.

Every entrepreneur spends some time haggling, whether it is with customers, suppliers, investors, or would-be employees. Most business owners are street smart, and seem to naturally perform well in negotiations. You probably have a trick or two—some magic phrases to say, perhaps—that can help you gain the upperhand. But, often, the moment you get into trouble in a negotiation is when something careless just slips out. If you are new to negotiation, or feel it is an area where you can improve, check out these tips on precisely what not to say.

1. The word "between." It often feels reasonable—and therefore like progress—to throw out a range. With a customer, that may mean saying "I can do this for between $10,000 and $15,000." With a potential hire, you could be tempted to say, "You can start between April 1 and April 15." But that word between tends to be tantamount to a concession, and any shrewd negotiator with whom you deal will swiftly zero-in on the cheaper price or the later deadline. In other words, you will find that by saying the word between you will automatically have conceded ground without extracting anything in return.

2. "I think we're close." We've all experienced deal fatigue: The moment when you want so badly to complete a deal that you signal to the other side that you are ready to settle on the details and move forward. The problem with arriving at this crossroads, and announcing you're there, is that you have just indicated that you value simply reaching an agreement over getting what you actually want. And a skilled negotiator on the other side may well use this moment as an opportunity to stall, and thus to negotiate further concessions. Unless you actually face extreme time pressure, you shouldn't be the party to point out that the clock is loudly ticking in the background. Create a situation in which your counterpart is as eager to finalize the negotiation (or, better yet: more eager!) than you are.

3. "Why don't you throw out a number?" There are differing schools of thought on this, and many people believe you should never be the first person in a negotiation to quote a price. Let the other side start the bidding, the thinking goes, and they will be forced to show their hands, which will provide you with an advantage. But some research has indicated that the result of a negotiation is often closer to what the first mover proposed than to the number the other party had in mind; the first number uttered in a negotiation (so long as it is not ridiculous) has the effect of "anchoring the conversation." And one's role in the negotiation can matter, too. In the book Negotiation, Adam D. Galinsky of Northwestern's Kellogg School of Management and Roderick I. Swaab of INSEAD in France write: "In our studies, we found that the final outcome of a negotiation is affected by whether the buyer or the seller makes the first offer. Specifically, when a seller makes the first offer, the final settlement price tends to be higher than when the buyer makes the first offer."

4. "I'm the final decision maker." At the beginning of many negotiations, someone will typically ask, "Who are the key stakeholders on your side, and is everyone needed to make the decision in the room?" For most entrepreneurs, the answer, of course, is yes. Who besides you is ever needed to make a decision? Isn't one of the joys of being an entrepreneur that you get to call the shots? Yet in negotiations, particularly with larger organizations, this can be a trap. You almost always want to establish at the beginning of a negotiation that there is some higher authority with whom you must speak prior to saying yes. In a business owner's case, that mysterious overlord could be a key investor, a partner, or the members of your advisory board. The point is, while you will almost certainly be making the decision yourself, you do not want the opposing negotiators to know that you are the final decision maker, just in case you get cornered as the conversation develops. Particularly in a high-stakes deal, you will almost certainly benefit from taking an extra 24 hours to think through the terms. For once, be (falsely) humble: pretend like you aren't the person who makes all of the decisions.

5. "Fuck you." The savviest negotiators take nothing personally; they are impervious to criticism and impossible to fluster. And because they seem unmoved by the whole situation and unimpressed with the stakes involved, they have a way of unnerving less-experienced counterparts. This can be an effective weapon when used against entrepreneurs, because entrepreneurs tend to take every aspect of their businesses very personally. Entrepreneurs often style themselves as frank, no-nonsense individuals, and they can at times have thin skin. But whenever you negotiate, remember that it pays to stay calm, to never show that a absurdly low counter-offer or an annoying stalling tactic has upset you. Use your equanimity to unnerve the person who is negotiating with you. And if he or she becomes angry or peeved, don't take the bait to strike back. Just take heart: You've grabbed the emotional advantage in the situation. Now go close that deal.

http://www.inc.com/guides/2011/01/five-things-to-never-say-while-negotiating.html

3/4/11

Making a Trigger Fire On Column Change

I was working with some SQL Server triggers today at work, the triggers were used to track changes to a Price column on a table. Whenever the Price column changed, we wanted to track that in a separate table so we could have a price history. So I setup the trigger on the Price column and set it to fire on INSERTs and UPDATEs. Here was the trigger at this point:

CREATE TRIGGER trg_SavePriceHistory ON myTable
FOR INSERT, UPDATE
AS
IF UPDATE(Price)
BEGIN
DECLARE @newPrice decimal(18,2)
DECLARE @itemId int
SET @newPrice = (SELECT Price FROM Inserted)
SET @itemId = (SELECT ItemID FROM Inserted)
INSERT INTO PriceHistory (NewPrice, ItemID) VALUES (@newPrice, @itemId)
END

Its pretty straightforward, check to see if the Price column was updated and if it was then make a new entry in the PriceHistory table with the new price and the item�s id. After a little while, I realized that every update statement that included the Price column was setting off the trigger. It made sense, I guess I assumed that it would only fire when the value of the Price column actually changed, not if it simply got written with the same value. For instance, if I ran the following INSERT statement:

INSERT INTO myTable (Price) VALUES (10);

Then the trigger would fire and the price would get logged. Now suppose I update the record that I just inserted with the same value for price (assume the id = 1):

UPDATE myTable SET Price = 10 WHERE ItemID = 1;

Now the trigger will fire again, which is what I don�t want. I only wanted the trigger to fire if the value had changed. I was kind of scratching my head, being new to triggers and all, about how I could get that to work. I started writing an email to an internal mailing list, when it hit me in one of those �Aha!� moments. Inside each trigger are 2 special tables called �Inserted� and �Deleted�. The Deleted table holds the values of the record before its state was changed by my UPDATE statement and the Inserted table holds the values of record after my UPDATE statement. All I had to do was compare the Price columns from each table and see if they were different; if they were the same, then I could just exit my trigger. So heres what the trigger looked like after I modified it (modifications in red):

CREATE TRIGGER trg_SavePriceHistory ON myTable
FOR INSERT, UPDATE
AS
IF UPDATE(Price)
BEGIN
DECLARE @newPrice decimal(18,2)
DECLARE @oldPrice decimal(18,2)
DEClARE @itemId int
SET @newPrice = (SELECT Price FROM Inserted)
SET @oldPrice = (SELECT Price FROM Deleted)
IF @newPrice != @oldPrice
BEGIN
SET @itemId = (SELECT ItemID FROM Inserted)
INSERT INTO PriceHistory (NewPrice, ItemID) VALUES (@newPrice, @itemId)
END
END

This is all probably very obvious to someone familiar with triggers, just thought I would help someone else out if they were looking for this.
-----------------------------------------------------------------------
COMMENT:
Hi Ben,

I may be wrong but I don’t think your code will work correctly when updating sets: the inserted and deleted tables are what thet are: tables and not rows.
You are logging the changes to one row, not a set.

The following code works for an update trigger.
You can add similar code for delete and insert statements (or you can change this one to cover the three possibilities)

INSERT INTO PriceHistory(ItemId, OldPrice, NewPrice)
SELECT I.ItemId, D.Price, I.Price
FROM INSERTED I INNER JOIN DELETED D ON I.ItemId = D.ItemId
WHERE I.Price != D.Price

Kind regards,

Karel Vandenhove

http://benreichelt.net/blog/2005/12/13/making-a-trigger-fire-on-column-change

3/2/11

25 Ways to Waste Your Money

Has your budget sprung a leak?

Nearly everyone has spending holes. And as with other kinds of leaks, you may have hardly noticed them. But those small drips can quickly add up to big bucks. The trick is to find the holes and plug them so you can keep more money in your pocket. That extra cash could be the ticket to finally being able to save, invest, or break your cycle of living from paycheck to paycheck.

Here are 25 common ways people waste money. See if any of these sound familiar, then look for ways to plug your own leaks:

1. Carrying a balance. Debt is a shackle that holds you back. For instance, if you have a $1,000 balance on a credit card that charges an 18% rate, you blow $180 every year on interest. Get in the habit of paying off your balance in full each month.

2. Overspending on gas and oil for your car. There's no need to spring for premium fuel if the manufacturer says regular is just fine. You should also check to make sure your tires are optimally inflated to get the best gas mileage. And are you still paying for an oil change every 3,000 miles? Many models nowadays can last 5,000 to 7,000 miles between changes, and some even have built-in sensors to tell you when it's time to change the oil. Check your manual to find the best time for your car's routine maintenance.

3. Keeping unhealthy habits. Smoking costs a lot more than just what you pay for a pack of cigarettes. It significantly increases the cost of life and health insurance. And you'll pay more for homeowners and auto insurance. Add in various other expenses, and the true cost of smoking adds up dramatically over a lifetime -- $86,000 for a 24-year-old woman over a lifetime and $183,000 for a 24-year-old man over a lifetime, according to "The Price of Smoking" (The MIT Press).

Another habit to quit: indoor tanning. There is now a 10% tax on indoor tanning services. As with cigarettes, the true cost of tanning -- which the World Health Organization lists among the worst-known carcinogens -- is higher than just the price you pay each time you go to the salon.

4. Using a cell phone that doesn't fit. How many people do you know who have spent hundreds of dollars on fancy phones, and then pay hundreds of dollars every month for the privilege of using them? Your phone is not a status symbol. It is a way to communicate. Many people pay too much for cell phone contracts and don't use all their minutes. Go to BillShrink.com or Validas.com to evaluate your usage and see if you can find a plan that fits you better. Or consider a prepaid cell phone. Compare rates at MyRatePlan.com.

5. Buying brand-name instead of generic. From groceries to clothing to prescription drugs, you could save money by choosing the off-brand over the fancy label. And in many cases, you won't sacrifice much in quality. Clever advertising and fancy packaging don't make brand-name products better than lesser-known brands.

6. Keeping your mouth shut. No one wants to be a nuisance. But by simply asking, you may be able to snag a lower rate on your credit card.

When shopping, watch for price discrepancies at the cash register, and make a habit of asking, "Do you have a coupon for this?" You might even be able to haggle for a lower price, especially on seasonal or perishable items, floor models or big-ticket purchases. Many stores will also match or beat their competitors' prices if you speak up. And try asking for a discount if you pay cash or debit -- this saves the store the cut it has to pay the credit-card company, so it may be willing to give you a deal. It doesn't hurt to ask.

7. Buying beverages one at a time. If you're in the habit of buying bottled water, coffee-by-the-cup or vending-machine soda, your budget has sprung a leak. Instead, drink tap water or use a water filter. Brew a homemade cuppa joe. Buy your soda in bulk and bring it to work. (Better yet, skip the soda in favor of something healthier.)

8. Paying for something you can get for free. There's a boatload of freebies for the taking, if you know where to look. Some of our favorites include restaurant meals for kids, credit reports, software programs, prescription drugs and tech support. You can also help yourself to all the books, music and movies your heart desires at your local library for free (or dirt cheap).

9. Stashing your money with Uncle Sam rather than in an interest-earning account. If you get a tax refund each April, you let the government take too much money in taxes from your paycheck all year long. Get that money back in your pocket this year -- and put it to work for you -- by adjusting your tax withholding. You can file a new Form W-4 with your employer at any time.

10. Being disorganized. It pays to get your financial house in order. Lost bills and receipts, forgotten tax deductions, and clueless spending can cost you hundreds of dollars each year. Start by setting up automatic bill payment online for your monthly bills to eliminate late fees and postage costs. Then get a handful of files to organize important receipts, insurance policies, tax documents and other statements.

Finally, consider using free budgeting software such as Mint.com to see exactly where your money goes, making it much harder for you to lose track of it.

11. Letting your money wallow in a low-interest account. You work hard for your money. Shouldn't it work hard for you too? If you're stashing your cash in a traditional savings account earning next-to-nothing, you're wasting it. Make sure you're getting the best return on your money. Search for the highest yields on CDs and money-market savings accounts. And consider using a free online checking account that pays interest, such as ones offered by Everbank and ING Direct.

Your stocks and mutual funds should be working hard for you, too. If they've been lagging behind their peers for too long, it could be time to say goodbye. Learn how to spot a wallowing fund or stock.

12. Paying late fees and missing deadlines. Return those library books and movie rentals on time. Mail in those rebates. Submit expense reports on time for reimbursement. And if you make a bad purchase, don't just stuff it in the back of the closet and hope it goes away. Get off your duff, return it and get your money back before you lose the receipt.

13. Paying ATM fees. Expect to throw away nearly $4 every time you use an ATM that isn't in your bank's network. That's because you'll pay an ATM surcharge, and your own bank will hit you with a non-network fee. Consider switching to a bank, such as Ally Bank, that doesn't charge ATM fees and reimburses you for fees other banks charge. Another way to avoid fees if there's not an ATM in your bank's network nearby is to get cash back when you make a purchase at the grocery store or drugstore.

14. Shopping at the grocery store without a calculator. Check how much an item costs per ounce, pound or other unit of measurement. When you comparison-shop by unit price, you save. For example, if a pack of 40 diapers costs $13, that's 33 cents per diaper. But if you buy a box of 144 diapers for $35, that's 24 cents per diaper. You save 27%! (Of course, buying more of something only saves money if you use it all. If you end up throwing much out, you wasted money.)

15. Paying for things you don't use. Do you watch all those cable channels? Do you need those extra features on your phone? Are you getting your money's worth out of your gym membership? Are you taking full advantage of your Netflix, TiVo and magazine subscriptions? Take a look at what your family actually uses, then trim accordingly.

16. Not reading the fine print. Thought you were being smart by transferring the balance on a high-rate credit card to a low-rate one? Did you read the fine print, though? Some credit-card companies now charge up to 5% for balance transfers. Also watch out for free checking accounts that aren't so free. Some banks are starting to charge fees unless you meet certain criteria.

17. Mismanaging your flexible spending account. For some people, that means failing to take advantage of their workplace FSA, which lets employees set aside pre-tax dollars for out-of-pocket medical costs. Other people fail to submit receipts on time. And the average worker leaves $86 behind in his or her use-it-or-lose-it FSA account each year, according to WageWorks, an employee benefits provider.

18. Being an inflexible traveler. You'll save a lot of money on travel if you're willing to be flexible. Consider traveling before or after peak season when prices are lower. Or search for flights over a range of dates to find the lowest fare. Booking at the last minute also can save you money because hotels and airlines slash prices to fill rooms and planes. And flexibility pays off at blind-booking sites, such as Priceline or Hotwire, which offer deep discounts if you're willing to book a room or flight without knowing which hotel or airline (or other details about the flight) you're getting until you pay.

19. Sticking with the same service plans and the same service providers year after year. Hey, we're all for loyalty to trusted service providers, such as your bank, insurer, credit-card company, mutual fund, phone plan or cable plan. But over time, as prices and your circumstances change, the status-quo may not be the best deal any more. Smart consumers are always on the lookout for bargains.

20. Making impulse purchases. When you buy before you think, you don't give yourself time to shop around for the best price. Take the time to compare prices online, read product reviews and look for coupons when appropriate.

Make it a policy to give yourself a cooling-off period in case you're ever tempted to make an impulse purchase. Go home and sleep on the decision. More often than not, you'll decide you don't need the item after all.

21. Dining out frequently. Spending $10, $20, $30 per person for dinner can be a huge drain on your wallet. Throw in a $6 sandwich for lunch every day and you've got quite a leak. Learning to cook and bringing your lunch from home can save a couple hundred bucks each month. When you do go out, consider getting carry-out instead of dining in (you'll save on the tip and drink), skip the overpriced appetizer and dessert, and search the Web for coupons ahead of time.

22. Trying to time the stock market. In trying to buy low and sell high, many people actually do the opposite. Instead, employ the simple strategy of "dollar-cost-averaging." By investing a fixed dollar amount at regular intervals, you smooth out the ups and downs of the market over time. If you take out the emotion and guesswork, investing can become less stressful, less wasteful and more successful.

23. Buying insurance you don't need. You only need life insurance if someone is financially dependent upon you, such as a child. That means most singles, seniors or kids don't need a policy. Other policies you can probably do without include credit-card insurance (better to use the premium to pay down your debt in the first place), rental-car insurance (most auto policies and credit cards carry some coverage), mortgage life insurance and accidental-death insurance (a regular term-life insurance policy will do the trick).

24. Buying new instead of used. Talk about a spending leak -- or, rather, a gush. Cars lose 20% of their value the moment they're driven off the lot and 65% in the first five years. Used models can be a real value because you can get a car that's still in fine working order for a fraction of the new-car price. And you'll pay less in collision insurance and taxes, too.

Cars aren't the only things worth buying used. Consider the savings on pre-owned books, toys, exercise equipment, children's clothing and furniture. (Of course, there are some things you're better off buying new, including mattresses, laptops, linens, shoes and safety equipment, such as car seats and bike helmets.)

25. Procrastinating. Time is an asset money can't buy. Start investing for retirement as soon as possible. For instance, if a 40-year-old saves $300 a month with an 8% return per year, he'll have $287,000 by age 65. If he had started saving 15 years earlier at age 25, he'd have more than $1 million.

http://finance.yahoo.com/banking-budgeting/article/112202/25-ways-to-waste-your-money

3/1/11

How to Assemble a Team to Buy a Business

Sure, there are the obvious experts you need by your side when buying a business. But did you consider a technology analyst, who could help evaluate the state of the company's technology? It could create leverage in negotiations.

You've decided it's time to finally buy your own business. Now what? Obviously buying a business can be a risky proposition, not unlike buying a house. And just like when you go about a home for the first time, you'll want to make sure you're not going in blind. That means that you need to assemble a team of skilled advisers to help guide your decisions that might range from evaluating business plans to nailing down the financing needed to make the deal. "Anyone buying a business will always be at a disadvantage even when they're asking the right questions because there are things sellers would rather not tell you, like that 75 percent of their business comes from a single client," says Carol Roth, a Chicago-based business strategist with Intercap Merchant Partners and author of The Entrepreneur Equation. "That's why you need to build a sharp team that can help uncover as many skeletons as possible."

And what kinds of experienced professionals should you include on the team you assemble to buy a business? There are three key experts that you must have at the table with you and six others that are strongly recommended.


Assembling a Team to Buy a Business: The 3 Key Experts

1. The Accountant
One expert you can't afford not to have on your team is an accountant who has experience in performing due diligence and buying businesses. The rub is that many accountants or CPAs think they know what they're doing when it comes to crunching the numbers of a business involved in a sale. Not so, says Bill Watson, whose company, Advanced Business Group, in Nashville, Tennessee, helps buy, sell, and value businesses. "I'm a CPA, and I can tell you that the average CPA is not out buying and selling businesses every day so they don't understand deal structure," he says. "It's not like buying a car." There are nuances to buying a business that the accountant you hire needs to be aware of. For instance, if you were to look at the books of a small business, you need to understand where and how the owner used "chargebacks," those ambiguous tax deductions like insurance charges or vacation expenses that business owners have the habit of burying in their books. In other words, a skilled accountant can help you uncover many of those skeletons hiding in the business's closets in an effort to evaluate what you should or shouldn't pay for.

2. The Lawyer
Just as when you go about choosing a CPA to join your team, you should target an attorney who specializes in mergers and acquisitions to give you the best advice when it comes to buying a business, says Roth. "This is not a case where you want to save a few dollars by hiring your cousin who happens to be a lawyer, but specializes in divorce law," she says. The reason is that you want an expert who knows how to review documents, such as environmental variables, and the kinds of contracts that might be in place with the current business owner. One of the most common sticky situations that many business buyers get into involves change-of-control issues related to leases or vendors, says Roth, where, based on a sale of the business, those relationships are no longer transferable—something that could dramatically change your appetite in terms of buying the business. "A good transactional lawyer can help you understand what contracts are null and void when you buy a business," says Roth.

3. The Intermediary
While entrepreneurs tend to pride themselves on their ability to go it alone, there are many reasons why it makes sense to bring on an experienced intermediary such as a business broker or investment banker to help shepherd your way through the business-buying process. Not only can an experienced banker or broker show you the ropes when it comes to what to expect throughout the entire process, they can also play a key role when it comes to playing hard ball with the seller, says Roth. "It can be really beneficial to have someone to play the 'bad cop' during negotiations," she says. "That way the buyer can ask the tough questions but blame it on their intermediary while preserving the relationships with employees and key partners they will need to run the business moving forward." In many cases, intermediaries can also pay for themselves, Roth says, by negotiating special deal terms or by finding hidden skeletons in the business they sniff out.


Assembling a Team to Buy a Business: 6 Additional Experts That Are Highly Recommended

4. Business Valuation Specialist
While settling on a price for the business you want to buy is something that your investment banker or broker will help with, it can also be valuable to reach out to someone who specializes in valuing companies, not unlike what an appraiser does with homes. A good valuation will take the business's financial strengths and weaknesses into account relative to its assets and cash flow, among other metrics.


5. Financing Expert
Unless you're planning on buying your new business with cash, you'll also need to have someone on your team that will help you secure the financing you'll need to get the deal done. Ideally, you'll be able to rely on someone who can walk you through the options available—bank loans, credit, etc.—as well as which ones make the best sense for you.


6. Real Estate Adviser
On a general level, most every business will have some real estate or property component linked to it, such as a lease, a deed, or even an option to buy additional land to expand upon in the future. That means it's wise to bring on someone who can help you weigh the pros and cons when it comes to the real estate details of the business you're considering buying. One organization to consider contacting for advice is The Counselors of Real Estate, www.cre.org, a professional association of commercial real estate advisers.


7. Insurance Agent
As an owner of a business, you'll also need to understand what you need to insure it. Therefore, it would be wise to get good counsel from an insurance agent or expert who can help map out what kind of coverage you might need regarding fire, error and omission, etc., before pulling the trigger on the deal.


8. Industry Expert
If you are interested in buying a business you already know something about, perhaps because you've worked for or owned a similar one in the past, you might not need to rely on someone to explain how the business works. If you are making a leap into a new industry, however, it makes sense to find someone you trust who has deep experience in that industry and can help you evaluate where the business stands relative to its competition and its customers.


9. Technology Analyst
Few companies these days operate without computers, whether it's to market themselves or to take orders from customers. That means that when you buy a business, you're also buying the equipment and data that the company has accumulated in its history—all of which can be extremely valuable to you. But, if the business has not kept on top of its information technology, perhaps by not backing up key data or by not investing in the best technology, you might want to bring in an expert who can help evaluate the state of the company's information technology infrastructure. Plus, if the company's technology is subpar, it could create some leverage in negotiations.

1/25/11

Excellent SQL Server Backup and Maintenance Solution

One of the first things I have to do after I’ve installed Dynamics GP and created the DYNAMICS, TWO and company databases, is setup jobs to backup and optimize those databases. The best method I’ve found to do that is a free solution developed by Ola Hallengren that can be found here. This solution received the 2010 Editor’s Choice Bronze Award for best Free SQL Tool, while the SQL Server Community gave it the Gold. After a previous write-up of this solution Ola contacted me directly asking for my feedback, and he has been in touch several times since – he clearly cares about his solution and makes regular improvements as SQL Server features are added or changed.

The solution can be installed by downloading and running a single sql script – direct link here. Upon opening the script in SQL Management Studio, I typically make two changes. First I change the value of the @BackupDirectory parameter, highlighted below, to point to the location I want the backups stored. The backup job will create a folder with the server name in this folder, with folders for each database below that, followed by folders for each of the backup types – full, differential, and log.

ScreenClip(9)

The second change I make is that I like to keep 3 days worth of backups on disk if possible, and the scripts defaults to cleaning up backups older than 24 hours, so I like to change that to 72 hours. This can certainly be done afterwards by editing the job step but I like to do it up front. I usually do a quick find and replace operation on “24, ” replacing with 72.

ScreenClip(10)

After the replace is completed, I run the script and the highlighted jobs below are created. From there I open each job, set the desired schedule for each one, and I’m done.

ScreenClip(11)

I use this script because I want consistently configured backup and database maintenance jobs on all of the SQL Servers I manage for my customers. It takes 10-15 minutes to configure and I love that it’s smart enough to not throw an error on the whole transaction log job if someone creates a new company and the recovery is still set to Simple – it skips that database and moves on to the next one. It is also much smarter then the SQL Server Maintenance Plans about whether it rebuilds or reorganizes the databases indexes. Visit Ola’s site, http://ola.hallengren.com/ to read more about the solution or view the documentation.



http://www.andynifong.com/blog/2011/1/24/excellent-sql-server-backup-and-maintenance-solution.html

How to avoid Malware

What is malware?
The term "malware" comes from the two words "malicious software," and refers to any software that is designed to cause damage to a computer, server, or network.

Viruses, spyware, worms, key loggers, and Trojans are examples of malware. If you click links that are disguised as images, audio, or video files which might appear on suspicious websites or in Instant Messages (IMs) or email messages, you might expose your computer to malware. In some cases, malware can even be hidden in files that have been uploaded to reputable websites. Malware can:

•Corrupt data.
•Slow down your computer.
•Use your email or instant message(IM) program to spread itself to other computers.
•Erase everything on your computer.
•Result in identity theft or give a criminal access to your web accounts.


1. Don't use file sharing applications. If I see Limewire, Bearshare, or Kazaa on a program list in a PC I can find malware approximately 100% of the time. There is simply no way to safely download with these programs because you can't trust the source.

2. Never open an email attachment if you don't know what it is. Even if you know the person who sent the email beware of attachments. Many computers with infections will send out email to everyone on their address book without the owner ever being aware.

3. If you get pop-ups when opening a web page don't click inside the pop-up to close it. Always click the red "x" in the upper right corner. The "cancel" or "close" button in the pop-up might have unintended effects. clicking inside the pop-up allows code to run that may not be what the button indicates. ie. by clicking inside the pop-up you may be allowing a virus to take control of your computer.

4. If you get a message from your computer warning you that it is infected and you need to download suchandsuch software to remove the virus, don't do it. At this point you are already infected, downloading the fake virus remover will only make it worse. No legit software ever uses this tactic.

5. Avoid free downloads unless you are absolutely sure you can trust the source. Often these freebies are packaged with a good deal of adware, so be careful.

Most of the time good common sense will keep your computer safer than whatever virus protection you have installed. Start practicing safe web viewing and you will find you rarely have a problem with malware.

The Carbon:Nitrogen Ratio (C:N) in Composting

Did you know that all organic matter has a ratio of Carbon to Nitrogen (C:N) in their tissues? For microorganisms, carbon is the basic building block of life and is a source of energy, but nitrogen is also necessary for such things as proteins, genetic material, and cell structure.

Balance of C:N is Key
Decomposition of organic materials in your compost pile is greatly increased when you create the proper balance between the carbonaceous materials (called BROWN because they are dry) and the nitrogen-rich materials (called GREEN because they are more fresh and moist).

In compost lingo, this balance is referred to as the Carbon-Nitrogen ratio, and shown as C:N.

Now, it is true that most people simply don't give a hoot about this scientific hocus-pocus stuff. Waste is waste! And when you just want to throw the stuff away, you're not inclined to stop a moment to ask, "Gosh, is this Carbon or Nitrogen?"

But magic is afoot out there in nature. And much of the sleight of hand of composting, whether you are aware of it or not, has to do with the organic materials' content of Carbon and Nitrogen. Blow this stuff off and you might get a surprise when you open the lid to your bin: it may reek to holy hell, like rotten eggs or ammonia, or it may just be sitting there doing absolutely nothing! Which is to say your pile has become a cold couch potato, and it ain't going nowhere fast!

So, back to this necessary balance between the Carbon content of your waste material and the Nitrogen content. For best performance, the compost pile, or more to the point the composting microorganisms, require the correct proportion of Carbon for energy and Nitrogen for protein production. Compost scientists have determined that the fastest way to produce fertile, sweet-smelling compost is to maintain a C:N ratio somewhere around 25 to 30 parts Carbon to 1 part Nitrogen, or 25-30:1. If the C:N ratio is too high (excess Carbon), decomposition slows down. If the C:N ratio is too low (excess nitrogen) you will end up with a stinky pile.

A Little More Science Behind the C:N Ratio
Microorganisms that digest compost need about 30 parts of carbon for every part of nitrogen they consume. That's a balanced diet for them. If there's too much nitrogen, the microorganisms can't use it all and the excess is lost in the form of smelly ammonia gas. Nitrogen loss due to excess nitrogen in the pile (a low C:N ratio) can be over 60%. At a C:N ratio of 30 or 35 to 1, only one half of one percent of the nitrogen will be lost. That's why you don't want too much nitrogen (fresh manure, for example) in your compost: the nitrogen will be lost in the air in the form of ammonia gas, and nitrogen is too valuable for plants to allow it to escape into the atmosphere.

Scientists have determined four conditions that are constant for all residue decomposition:

1.A maximum of 35% of the carbon in fresh organic material will be converted into soil humus IF there is sufficient nitrogen present.

2.A minimum of 65% of the carbon in fresh organic material will be given off to the atmosphere as carbon dioxide due to microbial respiration. (Uh-oh! An argument could be made that composting contributes to greenhouse gases and warming of the Earth's atmosphere. However, consider this, nature is always decomposing everywhere; so, what you are doing in your little compost bin is a mere iota of carbon release compared to nature's vast compost bin in forests, rangeland, etc.)

3.The humus formed from the decomposition of fresh organic material will contain approximately 50% carbon and 5% nitrogen. In other words, the C:N ratio of the humus is 10:1.

4.Most fresh plant material contains 40% carbon. The C:N ratio varies because of differences in nitrogen content, not carbon content. (Note: Dry materials are generally in the range of 40 to 50 percent carbon, and sloppy, wet materials are generally 10 to 20 percent carbon. Therefore, the most important factor in estimating the carbon-to-nitrogen ratio of plant or food waste is how much water is present).

HOW TO USE THE C:N RATIO

Principle #1: The Ideal 30:1 Ratio

A hot, fast pile (with temperatures up to 140°F/60°C) is obtained when the C:N ratio of all the materials you add averages 30:1 (50:1 is adequate for most slower, lower-temperature piles). You can be sure, then, that the little microbes are stuffing themselves. Of course, this is ideal: you may not necessarily obtain this!

Don't Make This Mistake: This ratio describes the chemical composition of a material and does not mean that you need a volume of brown materials that is thirty times greater than the amount of green matter! Don't make this mistake!

Principle #2: 2 Parts Green to 1 Part Brown
(The best stragey to mix your compostable materials)

Generally speaking, you can get C:N ratios of 30:1 to 50:1 by adding two parts of a GREEN material to one part of a BROWN material to your bin. A "part" can be defined as a certain quantity of the material, such as two 5-gallon buckets of GREEN and 1 packed bucket of BROWN.

Play with the chart below. For example, food scraps, grass clippings and leaves come close to an average of 30:1. How? Add-up the Carbon side of the ratio for all three materials, i.e. 15, 17, 60, and divide by the number of materials, i.e. three. 92/3 = about 31:1.

Experiment (this isn't a perfect world!) to find your own style. Many people have very good success with equal parts. Just don't have too much brown or too much green!

QUESTION: "Can I use 1-part GREEN and 1-part BROWN?"
ANSWER: Yes you can. The best combination would be a mixture of GREEN sources, as shown on the left of the chart below and a BROWN source such as leaves (notice that leaves have a fairly low C:N ratio compared to other carbonaceous materials shown on the right of the chart. Leaves are ideal for composting!). Researchers have determined that effective compost can be made with equal parts GREEN and BROWN, or with 2 parts GREEN and 1 part BROWN.

QUESTION: I am confused. Half the articles I read suggest using 2-parts BROWN to 1-part GREEN. The other half say to use 2-parts GREEN to 1-part BROWN. WHAT IS CORRECT?!
ANSWER: When authors/researchers call for 2-parts BROWN, they are considering the fact that common BROWNS such as leaves or hay, etc. have a lot of fluff or air in a particualr volume as compared to the more matted volume of GREEN. So, they might say use two shovels full of BROWN and one shovel full of GREEN. We don't dispute this advice if you use unshredded leaves or hay. However, when shredded, a large volume of leaves/hay is cut to about 1/4 its mass. Therefore, 2-parts of such shredded BROWN would be too much carbon for the 1-part volume of GREEN. Experiment to see what happens.

Our caution to using the 2-parts BROWN to 1-part GREEN approach is that one can easily overestimate the volume of BROWNS whereas in fact the GREENS are vital for getting the pile heated (but not too many or you get smelly material). Too much BROWN and the pile is too dry and will not heat up. We attempt to use the scientifically known make-up of Carbon and Nitrogen in materials and use the the C:N Ratio formula for computing the balanced ratio. This is why the 2-parts GREEN to 1-part BROWN has been promoted. Our best advice is to try both formulas for GREENS and BROWNS. You may be surprised at what you find: probably good compost!


Use this Rule of Thumb when viewing the chart below

•Any organic matter that has a C:N ratio generally smaller than 30:1 is considered a GREEN.
•Any organic matter that has a C:N ratio generally larger than 30:1 is considered a BROWN.

Common Home Compostable Materials & C:N Ratios
(Example: Food Scraps has a Carbon:Nitrogen Ratio of 17:1,
meaning 17 parts Carbon to 1 part Nitrogen)


GREEN (Nitrogen)
BROWN (Carbon)
Aged Chicken Manure 7:1

Fresh manures are way to hot and can burn your plants and roots!
Leaves 60-80:1
One of the most important ingredients for composting, especially shredded or broken down (leaf mulch).

Food Scraps 17:1

Vegetable Scraps 25:1

Straw, Hay 90:1

The best way to use is to shred for faster breakdown.

Coffee Grounds 25:1
Sawdust 500:1

Commercially produced compost is high in sawdust or shredded bark chips. Use very sparingly!
Grass Clippings - Fresh 17:1

Dry clippings would be higher in Carbon. Therefore, use as carbon source if necessary.
Woody chips & twigs 700:1

Be sparing. Best use is small material at bottom of bin or pile.
Fresh Weeds 20:1

Make sure you don't compost weeds with seeds, unless you insure that your pile gets hot - over 140°F/60°C.
Shredded Newspaper 175:1

Has no nutrient content. Best used in vermicomposting. Always shred and soak in water for fast breakdown.
Fruit Wastes 25-40:1
Nut shells 35:1
Rotted Manure 20:1

Horse manure should not be used because it contains undigested seeds that can sprout in the bin.
Pine Needles 80:1

Use sparingly. Very acidic and waxy; breaks down slowly.
Humus (soil) 10:1

This is nature's natural ratio. Use sparingly in pile. Best used to "seal" the pile by putting a 1-2 inch layer on top.
Corn Stalks 60:1

Shred or cut up in small pieces for fast break down.
Seaweed 19:1
Peat Moss 58:1

Has no nutrient value. In the bin it is mostly filler.

General Garden Waste 30:1

Clippings from plants, stalks, dead flowers, etc. Excellent mix with leaves

NOTE

The C:N Ratios given in this chart are average and may slightly vary according to source, researcher or scientist!




TIPS TO REMEMBER
  • The 2-to-1 ratio of Greens to Browns is your best bet when creating a Batch Pile. This will aid you in creating about a 30:1 C/N Ratio. Adequate enough to get a hot pile.

  • A 1-to-1 Ratio works well with the Add as You Go Pile as well as the Batch Pile. This will aid you in creating about a 50:1 C/N Ratio, adequate enough to get a warm pile.

  • Stockpiling of leaves and food scraps or yard waste is perhaps the best composting strategy to make a heap large enough for the microorganisms to get hot and bothered.

1/24/11

Holiday Functions

Often it is useful to return the date of a holiday for a given year, perhaps for a schedule application. Neither Excel nor VBA have any built in functions for working with holidays -- you have to create your own. Holidays can be thought of as being either Fixed or Floating. Fixed holidays are those that occur on the same day each year, such as Christmas. Floating holidays are those which occur on different days in different years. For example, Thanksgiving (in the US) occurs on the fourth Thursday of November. Therefore, we need a function that will calculate the fourth Thursday. We'll generalize that function, in both VBA and worksheet function form, to return the Nth day-of-week for any month and year.

Other floating holidays are a bit harder to calculate. For example, in the US, Memorial Day occurs on the last Monday of May. Depending on the year, this may be either the 4th or 5th Monday. So we need a function to calculate the number of Mondays in May. We'll generalize this to compute the number of any day-of-week in any month and year.

Finally, there is Easter, whose actual date is some bizarre result of the phases of the moon. I don't claim credit for the formulas for calculating Easter shown below, nor do I claim to understand why the work, but they do.



Fixed Holidays
For fixed holidays, such as Christmas, this is simple since the date of the holiday does not change from year to year. For example, use the following to return the date of Christmas in the current year:

=DATE(YEAR(NOW()),12,25)


Floating Holidays
Other holidays, however, are not assigned to a specific date. For example, Thanksgiving Day is defined to be the 4th Thursday of November. Therefore its exact date will change from year to year. For Thanksgiving, we have an explicit VBA function:

Public Function ThanksgivingDate(Yr As Integer) As Date
ThanksgivingDate = DateSerial(Yr, 11, 29 - _
WeekDay(DateSerial(Yr, 11, 1), vbFriday))
End Function

We can generalize this to holidays that are defined as the Nth Day of some month, such as Martin Luther King's birthday, celebrated on the 3rd Monday of January. The following function will return the Nth DayOfWeek for a given month and year:

Public Function NDow(Y As Integer, M As Integer, _
N As Integer, DOW As Integer) As Date

NDow = DateSerial(Y, M, (8 - WeekDay(DateSerial(Y, M, 1), _
(DOW + 1) Mod 8)) + ((N - 1) * 7))
End Function

To return the date of the 3rd Monday in January of 1998, use
=NDow (1998, 1, 3, 2)


The NDow function can also be written as a worksheet formula:
=DATE(Yr,Mon,1+((Nth-(DoW>=WEEKDAY(DATE(Yr,Mon,1))))*7)
+(DoW-WEEKDAY(DATE(Yr,Mon,1))))

Where Yr,Mon, and DoW are cell references or values indicating Year, Month, Nth, and Day-Of-Week.


This will work fine for most floating holidays. However, Memorial Day is celebrated on the Last Monday of May. To compute this date, we first need a function to tell us how many Mondays there are in the month.

Public Function DOWsInMonth(Yr As Integer, M As Integer, _
DOW As Integer) As Integer

On Error GoTo EndFunction

Dim I As Integer
Dim Lim As Integer
Lim = Day(DateSerial(Yr, M + 1, 0))
DOWsInMonth = 0
For I = 1 To Lim
If WeekDay(DateSerial(Yr, M, I)) = DOW Then
DOWsInMonth = DOWsInMonth + 1
End If
Next I

Exit Function
EndFunction:
DOWsInMonth = 0
End Function


Calling this function will tell us how many Mondays there are in May, 1998.
=DOWsInMonth(1998, 5, 2)

The DOWsInMonth can also be written as a worksheet function with the following array formula. Note that it will not work properly unless you press CTRL+SHIFT+ENTER instead of just ENTER when you first enter the formula and whenever you edit it later. If you do this properly, Excel will display the formula in the formula bar enclosed in curly braces {}.


=SUM((WEEKDAY(DATE(B3,C3,(ROW(INDIRECT
("1:"&DAY(DATE(B3,C3+1,0)))))))=D3)*1)

where B3 is the year, C3 is the month, and D3 is the day of week (1=Sunday, 2=Monday, ..., 7=Saturday)

There are 4 Mondays in May, 1998. The we can pass this into the NDOW function, to return 25-May-1998, the date of Memorial Day. Therefore, the formula to return the date of Memorial Day in 1999 would be

=NDow(1999,5,DowsInMonth(1999,5,2),2)

Many organizations recognize holiday dates on dates different than those of the actual date. Typically, this is done when the day of week of the holiday falls on a weekend and holidays are observed to make a three-day weekend. The general rule is that if the holiday falls on a Saturday, it is observed on the Friday before the holiday. If the holiday falls on a Sunday, it is observed on the following Monday. The following formula will return a Friday if the holiday falls on a Saturday, a Monday if the holiday falls on a Sunday, or the date itself if it falls on a weekday.=IF(WEEKDAY(A2, 1)=1,A2+1,IF(WEEKDAY(A2,1)=7,A2-1,A2)) where A2 is the date of the holiday. In VBA, you can use the following function:

Function Observed(TheDate As Date) As Date
If Weekday(TheDate, vbSunday) = 1 Then
Observed = TheDate + 1
ElseIf Weekday(TheDate, vbSunday) = 7 Then
Observed = TheDate - 1
Else
Observed = TheDate
End If
End Function

where TheDate is the date if the holiday.


Easter

Worksheet Formula For Easter
You can calculate the date of Easter with formula below. It is accurate for the years from 1900 to 2368. The formula is:

=FLOOR("5/"&DAY(MINUTE(YYYY/38)/2+56)&"/"&YYYY,7)-34

where YYYY is a four digit year between 1900 and 2368. The formula returns an incorrect for some years past 2369.


VBA Function For Easter
The date of Easter can be computed in VBA. The algorithm below is from the United States Naval Observatory, at Computing The Date Of Easter.

Public Function EasterUSNO(YYYY As Long) As Long
Dim C As Long
Dim N As Long
Dim K As Long
Dim I As Long
Dim J As Long
Dim L As Long
Dim M As Long
Dim D As Long

C = YYYY \ 100
N = YYYY - 19 * (YYYY \ 19)
K = (C - 17) \ 25
I = C - C \ 4 - (C - K) \ 3 + 19 * N + 15
I = I - 30 * (I \ 30)
I = I - (I \ 28) * (1 - (I \ 28) * (29 \ (I + 1)) * ((21 - N) \ 11))
J = YYYY + YYYY \ 4 + I + 2 - C + C \ 4
J = J - 7 * (J \ 7)
L = I - J
M = 3 + (L + 40) \ 44
D = L + 28 - 31 * (M \ 4)
EasterUSNO = DateSerial(YYYY, M, D)
End Function
You can call this from a worksheet cell with a formula like

=EasterUSNO(YYYY)

where YYYY is a four digit year.

http://www.cpearson.com/excel/holidays.htm
http://www.cpearson.com/excel/Easter.aspx

How to Find Money in Your Business

The solution to a cash flow problem is often right at your fingertips. Fear and concern can keep us from piecing together answers that can make a significant difference. When cash-strapped clients call for a session, we turn over a few stones that are damming up their cash flow and often resolve the immediate problem with a few simple changes or action steps.

Some common oversights and mistakes made by business owners are directly related to a lack of confidence or self worth. Some are related to a fear of looking at, and understanding, their numbers and some are simply due to lack of experience or knowledge. If you identify with any of these roadblocks reach out to someone who can help so you can put yourself firmly in the driver’s seat. Here are a few ideas that might just get the cash flowing and profits moving.

Review your accounts receivable (AR) – Who owes you money? How long have these outstanding invoices been on the books and what are you doing to collect them? The longer you allow these invoices to remain unpaid the less chance you have of collecting on them. Small business owners are often afraid to “get too pushy” for fear of jeopardizing future business. Ask yourself if you really want to do business with someone who doesn’t value your services enough to pay you on a timely basis. Ask yourself if YOU value your services and how these outstanding invoices reflect on your own values. Remember, the efforts that you put into collections could be put toward marketing instead. But meanwhile, make some phone calls, send letters and, if necessary, have an attorney draft a letter for you and nudge the late pays into action.

Review your terms - What are the terms that you apply to your sales? Do your clients pay you upfront? Do they pay a portion in advance and have 30, 60 or 90 days to pay the balance? I once worked with a client who provided a service in the wedding industry. She collected 30% at the time the order was placed and the remaining balance on the wedding day. We changed her collection terms to 1/3rd upon booking, 1/3rd 30 days prior to the event and the 1/3rd on the day of the event. This simple adjustment really loosened things up for her and gave her a safety net.

Charge your worth – Okay, here’s the real issue for many soloists. Wow! I can’t count the times that I have heard people say they haven’t raised their fees in 10 years or that they feel sorry for people who can’t afford their services. There is nothing wrong with a little pro bono work, for sure, but please don’t end up in the poor house to compensate for someone else’s financial concerns. If you do offer a reduction in fees or product cost communicate the terms clearly and make sure it’s not to your own detriment. Also, do a little competitive analysis by researching services and products similar to yours to see what the going rates are. Do you hear yourself making excuses to support your decision to charge lower rates? If so, talk to your accountant, coach, mentor or advisory board to gain perspective. Unless you are submitting RFP’s for government contracts the lowest bid doesn’t always win. Re-evaluate your pricing and make sure you are valuing your services and products as much as you hope that your clients will.

Evaluate your expenses – Another common cash flow issue is created by excess spending. For example, do you have contractors that you send jobs to because you want to keep them happy? We know that outsourcing is a priority so that your time is free to build your business, but if this is done to excess during a low revenue point it can backfire. I often hear concerns like, “Janie has been doing work for me for years and I can’t cut down on her hours.” Yes, it’s difficult when you feel responsible for a portion of someone else’s income, but in the long run these temporary cuts will keep you in the black long enough to rebuild and move forward in a stronger position so that you can resume sending work their way.

In this down economy, some soloists are holding on to office space that may no longer be necessary. If you need to make cuts like this, look for the advantages and give yourself a timeframe to work within. If you have a plan that you believe will turn things around, schedule a date to reevaluate your spending. It’s easy to get caught up in the “what if’s” when we are making decisions like letting go of an office. What if things turn around? What if my clients find out? Make a list of your pros and cons and understand your financial limits. Removing the stress of added expenses will help you to focus more clearly on solutions and growing your business.

http://www.inc.com/marla-tabaka/how-to-find-money-in-your-business.html

Selecting the right mulch for your garden or landscape

Any gardener will tell you that mulching is an essential element of landscaping. However, there is more to mulching than just spreading some straw or peat moss around your trees, shrubs and flowers. Mulch should, at the very least, have these qualities: insulate plants & roots, increase water retention, be attractive, have a pleasant odor or be odor free, allow water and air to penetrate soil and it must stay in place. Although there may not be an ideal or perfect mulch, several come close. Finding the right mulch for your purposes just takes a little research and maybe a few trips to the home improvement store or local garden supply store.

Before deciding what material to use as mulch, you need to decide between organic mulch and inorganic mulch for your landscaping. Both inorganic and organic mulch have certain characteristics that make each ideal for certain types of mulching projects. For example, organic mulches are eco-friendly and provide a continuous source of organic matter to the surface of the soil. However, if organic mulches are kept too wet they can breed mold. Hay, straw and other organic mulches may contain weed seeds that will be introduced to your yard and garden through the mulch. The merits of organic mulch probably outweigh the problems though. For instance, organic mulches alter the soil providing aeration in soil heavy with clay and more moisture retention in sandy soils. Inorganic mulch also has its own unique characteristics that make it both ideal at times and a detriment at other times. Inorganic mulch lasts much longer than organic mulch because the materials do not decay like the materials in organic mulch. Furthermore, most inorganic mulches prevent weeds or even completely inhibit weed growth. However, inorganic mulches are difficult to remove once they are in place, can prevent moisture and air from circulating through the soil and do nothing to improve or add nutrients to the soil.

Knowing when to mulch is also a key element to proper mulching. There are two seasons for mulching: growing season and dormant season. Mulching during growing season helps to maintain moisture until the new plants have become fully established. Furthermore, mulching during growing season reduces loss of soil and soil erosion until turf or plants are established. Mulch should not be applied until the soil has warmed up to promote active root growth - - if not, the mulch will keep the ground cool and roots will not grow. Dormant season mulching protects plants and roots from severe temperature changes by maintaining a constant soil temperature. However, dormant season mulching should not be done too early in the season or it will prevent plants from developing key processes that help them survive cold weather. Furthermore, pruning, fertilizing or doing anything to stimulate plant growth should be avoided after dormant season mulching has been done.

Some general precautions when using mulch include:
**Do not use reflective mulch (white rock, shiny pebbles, etc.) at the base of a building or home. They reflect the summer heat toward the house as well as damage plant roots by causing too much warmth during dormant winter months.

**It is not wise to use wood mulch around homes because this type of mulch attracts termites and other insects that will enter your home through cracks and spaces in the foundation and walls.

**Using mulch on soil that is poorly drained (soil that retains moisture and water) can cause the soil to be too wet for plants.

**Leaves, sawdust and shredded bark (all organic mulch) should be moist when they are applied to lawns and gardens. If they are dry, they will soak up the moisture from the soil leaving plants without water.


http://www.associatedcontent.com/article/5542944/in_search_of_the_perfect_mulch_for.html

Amazon's "Customers who bought this item also bought..."

This set of views is designed to show related items purchased with an inventory item in Dynamics GP.
This is similar in concept to Amazon's "Customers who bought this item also bought..."
The final view should ideally be restricted to a single item and will return items that have been bought (invoiced) with the
restricted item and the % of times they were bought together.

Using Fabrikam as a example, if you run this for item '5-Fee', you'll see that item '5-TVLLABOR' was on the same invoice as '5-Fee' 56%
of the time. The goal is to find related products for suggestive selling or product positioning.

These were built as views to allow them to be built into a Smartlist Builder based Smartlist. The use of views means that performance
suffers because the view has to hold all of the combinations and it may slow down with a large number of items and transactions.

I also have a Stored Procedure at http://www.dynamicaccounting.net that does the same thing and is more efficient.
That is a better option for custom programming, Crystal Reports or SSRS.

*/


--Create view to build denominator for % calc. This is the number of invoices per item.
Create View RelatedItems_InvoiceCount as
Select ItemNmbr as ItemNumber, COUNT(SOPNumbe) as InvoiceCount
FROM sop30300
WHERE sopnumbe IN (SELECT sopnumbe FROM SOP30300) and SOPTYPE=3
Group by ITEMNMBR

--Create view to hold the the relationships. This holds other items on the same invoice as an item.
Create View RelatedItems_Relationship as
SELECT SOP30300.SOPTYPE, SOP30300.SOPNUMBE, SOP30300.ITEMNMBR, SOP30300_2.ITEMNMBR AS RelatedItem
FROM SOP30300 INNER JOIN
SOP30300 AS SOP30300_2 ON SOP30300.SOPTYPE = SOP30300_2.SOPTYPE AND SOP30300.SOPNUMBE = SOP30300_2.SOPNUMBE
WHERE (SOP30300.SOPNUMBE IN
(SELECT SOPNUMBE
FROM SOP30300 AS SOP30300_1)) AND (SOP30300.SOPTYPE = 3) and SOP30300.ITEMNMBR <>SOP30300_2.ITEMNMBR

GROUP BY SOP30300.SOPTYPE, SOP30300.SOPNUMBE, SOP30300.ITEMNMBR, SOP30300_2.SOPNUMBE, SOP30300_2.SOPTYPE, SOP30300_2.ITEMNMBR
order by itemnmbr


--Create view to hold both related items and the % of common invoices they appeared on
Create View RelatedItems_PcntAlsoBought as
SELECT RelatedItems_Relationship.itemnmbr as ItemNumber, RelatedItems_Relationship.RelatedItem AS RelatedItem, IV00101.ITEMDESC AS Description,
Cast(cast(COUNT(SOPNUMBE) as decimal(8,2))/ CAST( RelatedItems_InvoiceCount.InvoiceCount as decimal(8,2)) *100 as decimal(8,2)) AS PcntAlsoBought
FROM RelatedItems_Relationship INNER JOIN
IV00101 ON RelatedItems_Relationship.RelatedItem = IV00101.ITEMNMBR
INNER JOIN
RelatedItems_InvoiceCount ON RelatedItems_Relationship.ItemNmbr = RelatedItems_InvoiceCount.ItemNumber
Where RelatedItems_Relationship.ITEMNMBR in (Select ITEMNMBR from IV00101)
GROUP BY RelatedItems_Relationship.itemnmbr,RelatedItems_Relationship.Relateditem, IV00101.ITEMDESC, RelatedItems_InvoiceCount.InvoiceCount

--Execute the view limiting it to one item and sorting by highest %
Select * from RelatedItems_PcntAlsoBought where ItemNumber='5-Fee'
Order by 4 desc