How to repair High Heel Shoes for a few dollars

September 1st, 2009

A very easy guide on repairing high heel shoes for a few dollars.

The damaged high heel shoe culprit, notice the lack of any heel and the exposed dangerous metal pin.

Damaged high heel, notice the metail pin protruding

Damaged high heel close up

The first task is to remove the old metal pin, depending on how worn the heel is depends on the ease of doing so. If there is a little rubber still visible or about 1mm of the pin showing it will be quite easy. I like to use a vice to squeeze the protruding head and then pull the shoe while rotating left and right, it should be easy enough with pliers, only a little more fiddling around.

If there is very little of the metal pin protruding and you are finding it very difficult to get a good grip on it, I sometimes cut about 1mm of the white plastic heel around the pin with a knife to expose more of the pin.

Remove the metal pin in a vice or with pliers

Once the pin is removed, give the heel a file to make everything nice and flat. Notice quite a bit of wear on the heel, depending on how fussy the owner is, you can remove any hanging leather and give the heel a nice coat of black paint. Personally, I don’t think it matters as it is quite hidden when worn.

Metal pin removed

After a double spray of flat black paint.

After a double coat of flat black spray paint

Now, I purchased 10 pairs of 10.5mm (7/16″) replacement heel tips for £7.50 (roughly $15 Australian, including shipping to Australia) on eBay. I have found that the majority of heels are around 10mm, there was one instance I had a stiletto of roughly 8mm and all that was required was some grinding/filing to obtain the required size. The shoes pictured are 10.5mm.

Replacement heel tips

In some cases the size of the pin hole may be too large for the regular 2.9mm (7/64″) pin, so some convertors to 3.1mm (or what they call Flexitubes) may be required. I purchased 8 pairs for £2.85 (roughly $5.7 Australian, including shipping to Australia) from Stiletto Heel Tips Online.

Flexitubes - comverts 2.9mm pin to 3.1mm pin

To fix the new heel to the shoe, first make a very basic shoehorn. Notice the wood is at an angle, as the sole of the shoe as actually at an angle to the heel. A slightly thicker piece of wood would have been better.

Very basic shoehorn

Hammer the new heel all the way down till the plastic heel is touching the shoe’s heel. Make sure it is facing the right direction, the curved size facing back, and the flat side facing front.

Hammer the new heel tip into the shoe

The completely repaired high heel shoes for the cost of less than $2.50 Australian.

Completely repaired high heel shoes

Bookmark and Share

Copyright Infringement – Pimsleur transcripts (Simon & Schuster)

August 25th, 2009

Seems that Pimsleur doesn’t like me providing transcripts for their Mandarin Chinese 1 Units and have asked for their removal.

Find the Notice of Copyright Infringement below.

So what are some Pimsleur alternatives for learning a language that are more than happy to provide transcripts.

  • Livemocha is a Social Language Learning resource.
  • The world’s number 1 in language learning software, Rosetta Stone is another alternative.
  • Instant Immersion produces a large collection of language learning programs, in the forms of computer software, audio and books.
  • FSI Language Courses is a free alternative with a large number of audio units in the public domain.

There are still plenty of sights that provide Pimsleur transcripts.

And don’t forgot you can freely download any of the Pimsleur audio books online

Update December 2009: I have made the transcripts available for download;

http://thydzik.com/pimsleur-mandarin-chinese-unit-1-transcripts/

Bookmark and Share

In Excel, find the value on the last row as a function, not VBA

July 20th, 2009

Here is a quick post, how to find the value of the last cell in a column.

Exaample below uses Column A with the first 3 rows used for the header:

=INDEX(A:A,COUNT(A:A)+3)
Bookmark and Share

Huge Pine USB to Serial Ports Driver

June 17th, 2009

Looking for the Huge Pine USB to Serial Ports driver?

Setup_For_HugePine.exe

Install, then connect your USB device and chose to automatically search for driver.

Bookmark and Share

Optimizing/faster String Concatenation in VBA

June 9th, 2009

There are numerous links about Visual Basic string concatenation, one particular is Microsoft’s How To Improve String Concatenation Performance. But the article is overwritten for the point it is trying to make, so I will share a simplified example.

Lets say we want to perform the following concatenation:

Dim i As Long
Dim s As String
For i = 1 To 100000000
	s = "A" & i & "B"
Next i

This takes approximately 6000 ticks. The faster approach, yet more complex functionality would be as follows:

Dim sourceLength As Long
sourceLength = 1
Dim source As String
s = "A B"

Dim i As Long
Dim s As String
For i = 1 To 100000000
	source = CStr(i)
	If Len(source) > sourceLength Then
		sourceLength = Len(source)
		s = "A" & Space$(sourceLength) & "B"
	End If
	Mid$(s, 2, sourceLength) = source
Next i

Which takes approximately 3700 ticks, a saving of nearly 40%.

Bookmark and Share

Altrex Light Skinz – the worst product

May 29th, 2009

I would like to share my experience with Altrex Light Skinz, a product when applied will allegedly protect a car’s headlights from rocks and stones.

As I planned to drive from Perth to Melbourne, I was after some headlight protection for the Hyundai Tucson. I purchased Altrex Light Skinz due to their claim of providing better protection than the common plastic clip-on equivalent, claiming ’simple and easy to fit’, claiming ‘completely invisible once fitted’ and being about half the price ($40 AUS) of the common plastic clip-on equivalent.

I cleaned the headlight glass before applying to make sure it was free of any dirt, as per instructions. Given that the Hyundai Tucson has curved headlights I let the glass heat up with the headlights for a little while, also as per instructions.

Here are some before shots of the Hyundai Tucson’s right and left headlights.
Light Skinz Right BeforeLight Skinz Left Before

And now some after shots after applying Altrex Light Skinz on the right and left headlights.
Light Skinz Right AfterLight Skinz Left After

Even after following these instructions, Altrex Light Skinz are not ’simple and easy to fit’ and are definitely not ‘completely invisible once fitted’. I am going to quote their FAQ with actual information based on my experience. Hopefully, this port will prevent people unsure of Altrex Light Skinz from wasting their money.

How easy are they to fit? Will I be able to fit them myself?
They are not easy to fit; you will be able to fit them yourself but will not be happy with the results.

How can I fit Altrex Light Skinz to a curved headlight? Are Altrex Light Skinz and Body Skinz easy to fit?
No and No. It just doesn’t make sense that a flat skin will fit over a curved headlight. Try getting a piece of paper and fitting it around a ball, how many crinkles do you get?
You can cut a “V-shape” but then you have a slit down one side.
You can cut the template into 2 pieces but then you have 2 slits down the side.

Can I remove Altrex Light Skinz and Body Skinz later if I decide to?
No. on removal of Altrex Light Skinz you will be left with a sticky glue to remove which is insoluble in soapy/hot water.
You will be able to remove all the glue by slowly peeling it from the edges working towards the centre with using your thumb.

Why are Altrex Light Skinz better than the old acrylic-style headlight protectors?
Light Skinz are not completely invisible once fitted. If you think you will be able to apply Light Skinz without leaving a crease, bubble, or smudges, then think again.

How can I ensure a perfect fit for my Altrex Skinz Protection?
You won’t be able to.

If I don’t put them on straight, can I take them off to adjust?
No, If you remove the Light Skinz to adjust the glue will be smudged and on reapplying your smudge will be permanent.
If they are not correctly fitted the first time, too bad.

What can I do about air bubbles?
And yes there will be air bubbles, and given it is also under Frequently Asked Questions must be a frequent problem.
The instructions suggest pricking the air bubble with a needle. Using this technique will only remove the air in the air bubble not the bubble itself.

Bookmark and Share

Fake/Counterfeit Canon NB-4L batteries

April 16th, 2009

I thought I would share my experience regarding fake Canon NB-4L batteries. Let me start by saying I own a Canon IXUS 55, with the girlfriend owning a Canon IXUS 40 both using the Canon NB-4L Battery. I have purchased two spare batteries from eBay, with one of the purchased batteries looking to be fake.  The following photos show the four batteries with the differences circled in red and reasons for this belief.

Firstly, a front photo of the four batteries, the lower right battery is the fake. Circled in red is a single linear indent on the fake battery whilst the real batteries have two linear indents. The text on the fake is also quite blurry.

Front photo of the four batteries, the lower right battery is the fake

Secondly, a back photo of the four batteries, the lower right battery is again the fake and again the single indent can be observed on the fake. Circled in red is the caution text which again is blurry. It can be observed that the words on each battery are different, and hence I believe is not a good indication to its authenticity.

Back photo of the four batteries, the lower right battery is again the fake

Lastly, a isometric view of the four batteries, the lower battery is the fake. Circled in red is a little rectangle, with the genuine batteries having a rectangle piece of plastic stuck on while missing on the fake battery. This would have been to save on manufacturing costs.

Isometric view of the four batteries, the lower battery is the fake

There are other differences, but those above are the most obvious. Click on the above images to display high resolution photos.

Bookmark and Share

thydzik Google Map v1.4.7 – inline Wordpress Google Maps

April 15th, 2009

I have released an updated version of thydzik Google Map which allows for colored and variable text markers, see the example below.

Unfortunatley, it now requires FreeType being compiled into PHP. If FreeType is not installed only the default marker and markers A-Z will be useable, with anything else being replaced with the default marker.

Download the latest from the WordPress Plugin Directory.

Bookmark and Share