TJ's Blog

Posted by TJ on Monday April 5, 2010 @ 10:54 AM
[Tags: accounting, taxes, guide]

The table below summarizes the income limitations on Roth contributions for 2010

Posted by TJ on Friday March 26, 2010 @ 12:38 PM
[Tags: guide, excel, accounting]

If you are trying to convert a Microsoft Excel 2007 file to open with Excel 2003 you may receive an error that there are "Too Many Cell Formats". After spending quite sometime I found a fix for this. You need to open the file in the Excel 2007 and run the macro below and then resave the file. Before you do anything make sure you save your file in case you don't like the results.

OPTION 1: The macro below will show a prompt "Delete Style ____" for each style which and you will need to click "YES" for each style. If you are not concerned about deleting a valid style you can use OPTION 2

Sub DeleteStyles()
' DeleteStyles Macro
Dim styT As Style
Dim intRet As Integer

For Each styT In ActiveWorkbook.Styles
If Not styT.BuiltIn Then
intRet = MsgBox("Delete style '" & styT.Name & "'?", vbYesNo)
If intRet = vbYes Then styT.Delete
End If
Next styT
End Sub

OPTION 2:The macro below will delete all unused styles without a prompt. This is faster but can be more dangerous than OPTION 1. Make sure you save the file both before and after running the macro (thanks to Nick)

Sub DeleteStyles()
' DeleteStyles Macro
Dim styT As Style
Dim intRet As Integer

For Each styT In ActiveWorkbook.Styles
If Not styT.BuiltIn Then
End If
Next styT
End Sub

OPTION 3: For those that do not want to deal with Macro's there is a tool you can download that I also find very helpful and easy to use. The tool removes unused cell styles, "stubborn styles" that you can't delete through Excel UI, bad named ranges, named ranges with external references, and unhides non-system created hidden named ranges. Download XLCleaner here:!526&sc=documents

Posted by TJ on Thursday March 11, 2010 @ 12:58 PM
[Tags: accounting, taxes, humor]

In honor of tax season here are some quick accounting and IRS jokes:

A businessman on his deathbed called his friend and said, "Bill, I want you to promise me that when I die you will have my remains cremated."

"And what," his friend asked, "Do you want me to do with your ashes?"

The businessman said, "Just put them in an envelope and mail them to the Internal Revenue Service and write on the envelope, "Now you have everything."

"Your taxes are due a week from today. You can make out your check directly to Halliburton. Or you can do what I'm going to do. I'm filing my first joint return. No, I'm not getting married, I'm sending the IRS an actual joint with a note that says, 'If you think I'm paying for this war, you must be high.'" --Bill Maher

"It's tax time and President Bush is saving a lot on taxes this year. He's writing off his entire second term." --David Letterman

George Washington never told a lie, but then he never had to file a Form 1040.

Posted by TJ on Thursday February 18, 2010 @ 08:05 PM
[Tags: scam, internet, business]

Yes I know it's a scam, a pretty funny one actually. A donation from from the United Nation, interesting.

Date: 18th Febuary 2010.

Customer Service!

This mail is to remind you of your registered package. CONTENT: Bank
Draft of
$890 000 USD officially registered by an Official of the United
Nation. The
Fund is a donation to you from the U.N through e-mails Balloting.
For your information the VAT and COD have been paid. Please Contact
Delivery Department Mr. Grege Silva for shipment details and
Tel: +2348071208793
It is mandatory to reconfirm your Postal address and telephone number:
Full Name:
Postal Address:
Yours Faithfully,
Mrs. Margaret Blair
©Federal Express Corporation
All rights reserved. © 1995-2010 FedEx.
This E-mail is only for the above addressees. It may contain
or Privileged information. If you are not an addressee you must not
distribute, disclose or use any of the information in it or any

Posted by TJ on Monday February 1, 2010 @ 01:14 AM
[Tags: facebook, news, internet]

I would like to create a list of all social networking holidays that people celebrate on facebook/myspace/twitter, etc.

Apparently this week is Doppelganger Week (1st week of February), Facebook users switch their profile pictures to famous people they have been told they resemble.
Read more:

Rubber Ducky Day is January 13th Why? the Rubber Duckie Song appeared on Semame street in 1970 in which it actually made the Billboard hits chart. January 13th is supposedly to be Ernie Duck's birthday, hence the holiday Read more

International Caps Lock Day is October 22 and June 28th. For these days, and these days only, people aren't allowed to belittle you for writing IN ALL CAPS Official website

What are some other holidays to celebrate on the web?

Posted by TJ on Tuesday January 19, 2010 @ 02:12 AM
[Tags: health, statistics, serious]

The Consumer Product Safety Commission's National Electronic Injury Surveillance System (NEISS) offers a database from a sample of 100 hospital emergency rooms in the United States and its territories. Patient information is collected from NEISS hospitals for every emergency visit involving an injury associated with consumer products.

Search the Database

Besides reading about the strange ways people hurt themselves this database can also be used to find the most dangerous sport by counting the results for each sport:

Here are the results:
Football: 14,579
Soccer: 6,159.
Baseball: 4,042
Softball: 2,748
Hockey: 1,567
Wrestling: 1,483
Volleyball: 1,469
Cheerleading: 779
Tennis: 760
Jogging: 403
Basketball: 362
Rugby: 328

Also if you want to stay away from the emergency room don't buy... these:
Trampoline: 3,078
bicycle: 2,639
swing: 2,439

What weird things can you find?

Posted by TJ on Saturday December 5, 2009 @ 05:47 PM
[Tags: internet, links, bored]

As 2009 is winding down lets look at some of the top list of 2009 from around the web:
  1. 50 Best Websites 2009
  2. - 100 Best books of 2009
  3. Popular Science - Best of What's new in 2009 - New products and innovations in 2009.
  4. Best free software of 2009
  5. 50 Best Rock Songs from 2009
  6. Top Ten Internet Memes of 2009
  7. Top 100 Best Products of 2009
  8. Arizona State University Top 10 new Species of 2009
  9. Top 10 CNN Heroes of 2009
  10. Top 99 Women from 2009 voted by Men
  11. 100 Best Companies to Work For 2009
  12. The Best and Worst Video Games for 2009
  13. Top 10 Epic Fails of 2009
  14. National Geographic Top Ten Discoveries in 2009
  15. Top Internet Searches of 2009
  16. Best Jobs of 2009
  17. Apple Unveils the Top Songs, Movies and Apps of 2009
  18. 5 Best YouTube Sports Moments of 2009

Added 1/13/10
  1. Famous quotes of 2009.
  2. Most expensive car crashes of 2009
  3. Most surprising deaths of 2009.
  4. Top 10 space stories of 2009 [GALLERY]
If you have any to add post a comment below.

Posted by TJ on Wednesday November 4, 2009 @ 12:53 PM
[Tags: scam, facebook, internet]

This is a scam email don't click the links:


Dear Facebook user,
In an effort to make your online experience safer and more enjoyable, Facebook will be implementing a new login system that will affect all Facebook users. These changes will offer new features and increased account security.
Before you are able to use the new login system, you will be required to update your account.
Click here to update your account online now.
If you have any questions, reference our New User Guide.
The Facebook Team

Posted by TJ on Friday October 30, 2009 @ 11:10 AM
[Tags: news, local, topten]

CNN published an article listing the 10 most expensive colleges in the US, and of course New York owns the title to 4 out of 10.
  1. Sarah Lawrence College
    Bronxville, N.Y. - $55,788/yr

  2. Parsons The New School for Design
    New York, N.Y. - $52,400/yr

  3. Georgetown University
    Washington, D.C - $52,161/yr

  4. New York University
    New York, N.Y. - $51,193/yr

  5. George Washington University
    Washington, D.C. - $51,775/yr

  6. Johns Hopkins University
    Baltimore, Md. - $51,690/yr

  7. Columbia University
    New York, N.Y. - $51,544/yr

  8. Wesleyan University
    Middletown, Conn. - $51,432/yr

  9. Trinity College
    Hartford, Conn. - $51,400/yr

  10. Washington University in St. Louis
    St. Louis, Mo. - $51,329/yr

Posted by TJ on Monday October 12, 2009 @ 05:56 PM
[Tags: link, news, business]

Bernie Madoff is the top selling costume this Halloween. I kinda agree he is a bigger creep than most costumes on the market.,0,601399.story

< Previous Page | Next Page >