Nerdburn - Web application & graphic user interface design blog by Shawn Adrian

Web site design by Shawn Adrian & friends

Complete List of Tax Increases in BC with HST

Posted July 1, 2010

Well, today is Canada day, and also the first day that the new HST takes effect in BC. If you live in BC, as I do, you're probably wondering how the new HST will affect your day to day spending. I've taken the time to create a no clutter, complete list of tax increases in BC as a result of HST. I hope it helps to clarify things for you.

What will cost more with HST?

 WasNow
Around The House
Newspapers 5% 12%
Certain School Supplies 5% 12%
Magazines 5% 12%
EnergyStar Windows 5% No PST 3 Yes 5% 12%
Thermal Insulation, Weather Stripping and Caulking 5% 12%
First Aid Kits 5% 12%
Smoke Detectors Valued Less Than $250 for Residential Use 5% 12%
Food Producing Plants and Trees 5% 12%
Household Moving Services 5% 12%
Clothing
Adult Sized Clothing for Children 5% 12%
Shoe Repair 5% 12%
Tailoring Services 5% 12%
Dry Cleaning 5% 12%
Used Adult Clothing Purchased for Less Than $100 5% 12%
Food
Snack Foods 5% 12%
Restaurant Meals 5% 12%
Alcoholic Beverages 5% 12%
Catering and Event Planning Services 5% 12%
Home Services
Basic Cable Television 5% 12%
Local Residential Phone 5% 12%
Repair to Refrigerators, Washers, and Dryers 5% 12%
Repair, Maintenance or Renovation Services for Real Property 5% 12%
Landscaping, Lawn-Care, Snow Removal, Cleaning 5% 12%
Accomodation / Travel
Taxis 5% 12%
Camping Sites 5% 12%
Domestic Air, Rail and Bus Travel 5% 12%
Motor Vehicle Parking 5% 12%
Home Purchases
Real Estate Commissions 5% 12%
Health & Beauty
Massage Therapy Services 5% 12%
Over-the-Counter Medications 5% 12%
Vitamins 5% 12%
Entertainment
Admission to Professional Sporting Events 5% 12%
Movie Tickets 5% 12%
Safety Helmets for Sports 5% 12%
Golf Memberships 5% 12%
Driving Range Fees 5% 12%
Gym and Athletic Memberships 5% 12%
Ballet, Karate, Trampoline, Hockey, Soccer Lessons etc. 5% 12%
Tickets for Live Theatre 5% 12%
Bicycles 5% 12%
Admission to Museums and Art Galleries 5% 12%
Music Concerts 5% 12%
Ski Lift Passes 5% 12%
Adult Sized Ski Gloves for Children 5% 12%
Adult Sized Ski Boots for Children 5% 12%
Children’s Sized Ski Boots 5% 12%
Hockey Rink and Hall Rentals 5% 12%
Electronics
Music or Video MP3s Downloaded Electronically 5% 12%
Services
Funeral Services 5% 12%
Fitness Trainer 5% 12%
Hair Stylist/Barber 5% 12%
Esthetician Services 5% 12%
Accounting Services 5% 12%
Interior Design Services 5% 12%
Wedding Planning Services 5% 12%
Veterinarian Services 5% 12%
Tobacco
Cigarettes 5% 12%
Cigars 5% 12%
Chewing Tobacco 5% 12%
Nicotine Replacement Products 5% 12%

In Summary

It looks to me like my own wallet will be hit hardest when it comes to entertainment and grooming. Things like seeing movies, renting movies, going out to eat, and getting my hair cut. What do you think of the new HST? If you're a web designer, or a freelancer, do you think it's going to affect your bottom line?

How to Select All New Entries From Today with MySQL

Posted June 17, 2010

Yesterday I wanted to create a little stats panel for a client that would tell me how many new people had signed up that day. Then I wanted to compare that with Google Analytics unique visitors to come up with a conversion rate for the day.

The Problem

The "creation_date" field in the "users" table was an int(12), and stored as a UNIX timestamp. The MySQL date() functions all work with "real" dates such as 2010-06-18, so comparing the UNIX timestamp with those didn't work.

The Solution

After some careful googling, I combined a couple of solutions to create this:

select id from users where date(from_unixtime(creation_date)) = date(now());

Using the from_unixtime() function, we convert the creation date field into a regular date field in this format: 2010-06-18 00:00:00. Then we run the date() function on that result to strip the 00:00:00 from it.

On the other side, we call the now() function, which gets the current date & time (according to the server, we won't get into timezones here). Then we call the date() function again to strip the 00:00:00 as it returns just the year-mm-dd. Then we compare them, and voila!

I hope this saves you a little searching.

QuoteRobot Lives! Try it Free for 30 Days

Posted May 31, 2010

This is just a quick post to let everyone know that Jon and I have finally launched QuoteRobot :) The official launch date isn't until tomorrow, June 1st, but we put it up early to make sure the DNS propagates in time. If you can see the site, you can sign up and enjoy the benefits because we're giving everyone a free 30 day unlimited trial.

If you have quotes or proposals to make, create them this month and it won't cost you anything! After that we're considering a base plan of $12 per month. Thanks for trying it, let me know what you think!

View older posts »