TJ's Blog

Posted by TJ on Saturday November 4, 2017 @ 01:36 PM
[Tags: tjshome, status, policies]

Commenting Terms of Use

1. Be relevant
Comments must be related to the article or message. (Promotional commercial messages are not allowed.)

2. Be respectful
Keep things civil. Abusive or offensive language, threats, hate speech, libel and calls for violence will not be tolerated.

3. Be honest
Use your own identity; don't pose as another person.

Commenting is a privilege that can be revoked for violations of our terms of use. Inappropriate comments may be deleted. Users who violate the guidelines will be banned from commenting, perhaps with their previous comments deleted.

The site is moderated at the sole discretion of the site administrators. Because of the volume of reader comments, we generally cannot review individual moderation decisions with readers.

Users are solely responsible for what they post and can be held responsible for violations of the law. Tjshome cannot verify the content of comments and does not vouch for their accuracy.

Posted by TJ on Wednesday August 31, 2016 @ 01:15 PM
[Tags: accounting, links, tips]

I think I found the best website for historical exchange rates. Before finding this site I would rely on Oanda and/or even, however, it seems those choices have gotten worst rather than better for providing historical data that is easily exportable into excel.

Bank of England provides a tool that provides historical fx rates based on the dates you enter for all countries. You can then click on a country to get even more detailed historical data that is exportable to excel and other formats.

Posted by TJ on Friday August 12, 2016 @ 12:28 PM
[Tags: excel, tips, accounting]

From time to time I run into an issue where for some reason the default styles in an excel workbook get corrupted and I unable to add or remove decimal places from cells even by using the standard ->Format Cells->Number or Account->Decimal places drop down. I found an easy to resolve this would be to import the spreadsheet into Google Sheets ( ). Doing this may remove some intentional formatting but it will also should fix the issue with default styles not working.

In Google Sheets:
Upload from Excel to Google Sheets ->File->Open-> Upload

Export file from Google Sheets to Excel : File->Download As...->Microsoft Excel

Posted by TJ on Thursday March 17, 2016 @ 11:46 AM
[Tags: toplist, humor, status]

Below are some funny status messages or tweets related to St Patrick's Day. If you like these you can browse more funny facebook status messages here: Funny Status Messages.

Posted by TJ on Friday March 4, 2016 @ 11:53 AM
[Tags: Excel, tips, accounting]

If you manage a partnership you might need to send out individual or personalized statements showing account activity or member financial information. If you already have a table in excel with the data one of the easiest ways to make an individual statement is to add a new tab and create the statement and then add a drop down (data validation) on the statement tab to select each persons name.

To add a drop down
1) From the Data Ribbon select Data Validation
2) Select Allow "list"
3) Your source should be the list of names from the data table you are pulling information from.

Now that you have a dropdown on the statement tab you can use the formula "SUMIF" to retrieve only the specific data from your data table for the name you select from the dropdown box.

Now if you have a lot of names you might want to automate selecting each name and printing the individual statement to the pdf. The below VB Code/macro will do this as long as on your statement tab you have the dropdown in cell A1 and the filename and path in cell A2 (ex: c:/folder/)

Posted by TJ on Friday February 12, 2016 @ 03:01 PM
[Tags: excel, tips, accounting]

Below are some short cuts I use almost every day in Excel when auditing worksheets in excel. There are certainly more shortcuts than I discuss below but these are certainly less commonly discussed:

Ctrl + { Press these two keys together when you are in a cell with a formulated value and Excel will bring you to the sheet and cell it got linked from. If you go nowhere that likely means the cell does not contain a formula or there were too many variables.

Ctrl + } When you use this shortcut on a value Excel will bring you to the sheet and cell where the selected cell is being used in a formula. If you go nowhere that means the cell is not used in a formula or there are too many variables.

Ctrl + ~ When you use this shortcut you can switch displaying showing formulas or values on a sheet.

Posted by TJ on Friday February 5, 2016 @ 03:45 PM
[Tags: humor, status, toplist]

It is almost Superbowl Sunday so we compiled the favorite funny status message related to football the the superbowl below:

If you like these you can browse more related funny status messages here: OR football OR superbowl.

Posted by TJ on Tuesday January 19, 2016 @ 05:38 PM
[Tags: status, humor, toplist]

Below are some funny status messages or tweets related to post when it snows. If you like these you can browse more related funny status messages here: OR flurries OR winter.

Posted by TJ on Sunday January 10, 2016 @ 03:23 AM
[Tags: humor, status, toplist]

Well since no one won Saturday's Powerball... below are some funny status messages or tweets related to the Powerball or the lottery.

If you like these you can browse more related funny status messages here:

Posted by TJ on Saturday January 9, 2016 @ 06:25 PM
[Tags: status, tjshome, update]

Happy New Year's Guys... We just wanted to check-in and talk about messages that appear on the "Funny Status Message" page that are not funny status messages .

In order to keep the content relevant and current we allow submissions to be posted live on our website immediately. We understand that this can cause issues since the content in submissions could be offensive and not funny and not represent the content we are looking for. While we are can not possibly be on here reviewing messages in real time we try to at least check-in once a day and do some moderating. The last few days we took a vacation and that is why you seen an influx of poor status submissions that were not effectively moderated. We apologize for this and we will be checking in more frequently to help keep the content interesting.

We also rely on support from our community for moderating status message submissions as well. One thing that visitors may do when they see a poor submission is post a comment about a posts using the "Funny Status Submission" Form in response, which is counterproductive as this will only be adding to the number of poor submissions. We recommend you do the following when you see a poor status submission:
  • 1) Vote the message down by click the Thumbs Down icon (User submitted image). This will help us quickly spot the poor submissions when we moderate.

  • 2) If you have a comment or response regarding a submission post your comment by clicking the number in the Comments (0) indicator. Do not respond to messages using the status message submission form.

  • 3) You can also contact us using the contact form:

| Next Page >