TJ's Blog
Search:

Posted by TJ on Monday December 31, 2018 @ 03:31 PM
[Tags: toplist, humor, status]

Another great year with some great post. Below is list compiled of some of the best status messages submitted in 2018. As always we appreciate the contributions of our visitors.

Happy New Year everyone and enjoy.
Read More...




Posted by TJ on Friday December 7, 2018 @ 12:56 PM
[Tags: tips, windows, guide]

My go to program to open any file that is unrecognizable in Windows is notepad. If the file happens to contain any readable text then you can at least get an idea what the file is.

To open any Windows file in notepad you can

1) right click the file
2) Choose "Open With"
3) and click Notepad (or browse for "notepad.exe")
4) Make sure to uncheck "Always use the selected program to open this kind of file" if you do not want this program to become program to open any file with the same file type.

However if you forget to deselect the option "Always use the selected program to open this kind of file" (as I often do) then Notepad will ever be associated with any file of the same type of file extension.

Windows 7 does not have any easy way to delete a file association once you set one up (you can only change it to a different program), however the below workaround should resolve the issue:
  • Right click on your desktop, select new->new text document
  • Rename the text document to “test.exe”.
  • Locate in explorer file you need to remove the file association for and right click on the file andd choose “open with” and select “Choose default program”.
  • Now, you will get a list of program to choose from, click on “Browse..” at the bottom of the list.
  • Navigate to desktop and choose “test.exe”.
  • Now, the file files would be associated with the “test.exe” program.
  • Delete the “test.exe” file you created in the desktop. Now, the file should not be associated with any program.






Posted by TJ on Wednesday December 5, 2018 @ 03:05 PM
[Tags: guide, business, events]

USPS Holidays - 2019

Tuesday, January 1 - New Year's Day
Monday,January 21 - Martin Luther King Jr. birthday
Monday,February 18 - Washington’s birthday
Monday,May 27 - Memorial Day
Thursday, July 4 - Independence Day
Monday,September 2 - Labor Day
Monday,October 14 - Columbus Day
Monday,November 11 - Veterans' Day
Thursday November 28 - Thanksgiving Day
Wednesday, December 25 - Christmas Day

USPS Holidays - 2020

Wednesday, January 1 - New Year's Day
Monday, January 20 - Martin Luther King Jr. birthday
Monday, February 17 - Washington’s birthday
Monday, May 25 - Memorial Day
Friday, July 3 - Independence Day
Monday, September 7 - Labor Day
Monday, October 12 - Columbus Day
Wednesday, November 11 - Veterans’ Day
Thursday November 26 - Thanksgiving Day
Friday, December 25 - Christmas Day



Posted by TJ on Friday November 9, 2018 @ 03:37 PM
[Tags: Tips, mobile, android]

If saying "OK Google" or "hey Google" is no longer opening Google Assistant on your Android phone try turning off "battery saver" in the top notification area of your phone.



Posted by TJ on Tuesday April 10, 2018 @ 02:24 AM
[Tags: html, updates, tjshome]

We need some tweaks to the header to hopefully make it easier on the eyes and hopefully easier to read... because who needs a big fat header anyways? Let us know what you think.



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 usforex.com, 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.

http://www.bankofengland.co.uk/boeapps/iadb/Rates.asp?TD=17&TM=Apr&TY=2015&into=GBP&rateview=D



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 ( https://docs.google.com ). 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.
Read More...




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/)
Read More...




| Next Page >