IMDB Top 250 movies extended, past and present v2.0

November 1st, 2008

I have further updated my Top 250 list with a lot of cool features. The main improvement is daily updating of ratings and votes, and the automatic insertion of any new movies that enter the top 250.

http://imdbtop250.thydzik.com/

A brief explanation on headings:

  • Rank - the rank of the movie sorted by weighted and then average rating, similar to the actual IMDB top 250 rank
  • Rating - the IMDB weighted rating, pulled from each movie page so only available to 1 decimal place (for now)
  • Title - the movie’s title, if title was in quotes these have been removed
  • Year - the movies year
  • Votes - the total number of votes
  • Average - the movies average rating, calculated from the movies ratings page
  • Year in Top 250 - the last year the movie was seen in the Top 250, pre 2008 data was pulled from the Internet Archive
  • Actual - the actual IMDB top 250 rating, useful to filter only movies in the actual IMDB top 250

Credit to daemach for his tableFilter app used to produce the fancy sort and filters.

Pimsleur Mandarin Chinese 1 Units 27 to 30 transcripts

October 6th, 2008

The final transcripts for Level 1.

Pimsleur Mandarin Chinese 1 Unit 27 transcript by thydzik

Pimsleur Mandarin Chinese 1 Unit 28 transcript by thydzik

Pimsleur Mandarin Chinese 1 Unit 29 transcript by thydzik

Pimsleur Mandarin Chinese 1 Unit 30 transcript by thydzik

5 Dimension - a 5 suit playing cards

August 16th, 2008

I recently purchased a 5 Dimension (5D) deck of playing cards from Canada for $5 (plus $5 shipping to Australia). Unlike a normal deck, the 5D deck has an extra suit, the star, plus a numeric 1 card (as opposed to an ace), a princess card and jokers, totalling 80 playing cards.

5 Dimension playing cards

The cards are standard bridge size 2.25″ x 3.5″ (the thinner width making it easier to hold more cards), with a card width of 0.3 mm. The card material is of quite good quality, with no ruined corners yet.

So how does an extra suite and more denominations affect the probabilities of standard 5 card poker hands? With reference to Durango Bill’s Poker Probabilities, the probabilities in a 5 suit 13 denomination deck are as follows:

Poker Hand        Number of Combinations     Probability
--------------------------------------------------------
Royal Flush                         5        .0000006053
Five of a kind                     13        .0000015739
Straight Flush                     45        .0000054480
Four of a kind                  3,900        .0004721614
Flush                           6,385        .0007730129
Full House                      9,360        .0011331873
Straight                       31,200        .0037772909

Total                       8,259,888       1.0000000000

The biggest difference is a Full House is easier to be dealt then a Flush.

Now, how does adding a One and Princess denomination affect the probabilities.

Poker Hand        Number of Combinations     Probability
--------------------------------------------------------
Royal Flush                         5        .0000002897
Five of a kind                     15        .0000008691
Straight Flush                     55        .0000031867
Four of a kind                  5,250        .0003041822
Full House                     12,600        .0007300374
Flush                          14,955        .0008664849
Straight                       37,440        .0021692540

Total                      17,259,390       1.0000000000

A Flush goes back to having a higher probability than the Full House.

Motorola RAZR V3 repair and housing change guide

August 16th, 2008

This guide will step through the process required to repair a Motorola RAZR V3 “the phone”, including the flex cable and then replacing the housing.

The flex cable can be purchased from eBay for $7 US (including shipping), and the housing can be purchased for around $16 (including shipping). The flex cable is attached to the keypad circuit, which is automatically included in the purchase. When purchasing the housing, you need to make sure it is NOT a slip on case, skin, pouch, fascia, protector, etc, etc. The housing should include as a minimum the front, middle, back and battery cover. Keypad, hinge, pads, grommets, buttons may even be included, as well as TORX screwdrivers, make sure you buy all what you need. The included contents of my purchased housing were as follows.

The included contents housing contents purchased from eBay

To perform repairs on the phone, you require TORX T5 and T4 drivers, a small flat driver will come in handy as well, also at least 2 hours of spare time.

First a look at my broken phone, besides the obvious fact that it is broken into two separate halves, the hinge is broken and there is normal housing wear.

My broken Motorola RAZR V3

First remove the battery cover, battery and SIM card. Remove 2 TORX T5 screws under the battery cover circled in red. Separate the plastic case via two plastic clips as squared in red.

Remove battery case and battery and then TORX T5 screws

The antenna assembly can be removed by disconnection of the keyboard connector, squared in red. Remove the 4 TORX T4 screws, circled in red. These screws will be required for the new housing.

Disconnect the antenna assembly and remove the 4 TORX screws

Now, if you need to preserve the keypad circuit; it is a little bit more involved. First, lift up the tabs of the metal keypad as circled in red and then pry of the metal keypad. Most likely the keypad circuit will be stuck to the plastic so extreme care is required when removing. It may be easier to reuse this whole part, as it seems all colour housing still have this same silver part.

Lift the metal tabs, as circled to remove the keypad

Following is a photo of the new keypad circuit and the plastic keyboard housing.

The new keypad circuit and the plastic keyboard housing

Remove the backing of the keypad circuit and stick the circuit to the plastic housing. You will need to start from the bottom to allow the connectors to be threaded through the holes.

Stick the keyboard circuit to the plastic housing

A photo of the completed keypad assembly.

The completed keypad assembly

Remove the antenna from the antenna assembly by first removing two black grommets and then unclipping the two plastic clips.

The antenna assembly

Once the circuit board is removed, remove all the following from the plastic housing as these are required in the new housing.

Remove all the following

Insert all the old removed parts into the new housing as follows.

Insert all the old removed parts into the new housing

The change the screen housing, first remove the 4 rubber grommets as circled in red, and then the 4 TORX T5 screws behind.

Remove the 4 rubber grommets and then the 4 TORX T5 screws behind

Once the plastic screen housing is removed, the display circuit is visible. Carefully pry away the circuit from the plastic near all buttons and the backup battery as circled in red. The camera can be removed by lifting the brown tab as squared in red. Move the circuitry to the new housing and then connect the camera.

Carefully pry away the circuit from the plastic near all buttons and the backup battery

To connect the two clamshell halves, the hinge can be retracted in, the hinge is circled in red. This allows the two halves to combine; the hinge should then pop into place securing the two halves.

To connect the two clamshell halves, the hinge can be retracted in

Finally, replace all the finishing touches such as labels, hinge caps and grommets. Photos of the new phone are below.

Final image of the Motorola RAZR V3 with the new housing

Final image of the Motorola RAZR V3 with the new housing

The following repair guide may be of further help
Motorola V3-Razr Repair Manual KS-042050-V1.2.pdf

IMDb Top 250 movies extended: all past and present movies

August 9th, 2008

I like the IMDb Top 250 list as it lets me know about movies I would normally never hear about. The problem though, is that a lot of the movies get pushed off the list by newer movies, and unfortunately you may never get to hear about them again.

Hence, I present the IMDb Top 250 movies extended list, a collection of all the IMDb Top 250 movies from 18th October 2000 to the 8th August 2008.

This list was made by downloading all the archived Top 250 lists on the Internet Archive. Once all the movie titles were extracted, I extracted current ratings and votes for the individual movie titles. The movie titles were sorted by rating producing the list.

This list is not a definitive list, and doesn’t include all the movies after number 250. I do wish IMDb did have this feature. Furthermore, this list is not updated in real time, and hence the list is already outdated.

However, this list does provide movies that may be worth enjoying during the next rainy day in.

IMDb Top 250 movies extended

Unlock the Nokia 6300 for under $10 with the iSIM

July 4th, 2008

Here’s a quick post on a tested method to unlock a Nokia 6300. Well, not quite unlock a Nokia 6300 but trick the phone into thinking your SIM is of compatible carrier. I purchased the iSIM from eBay for $10 including shipping to Australia. When searching on eBay, search for “unlock 6300″ and arrange by lowest price first.

The iSIM is a IC that goes in-between your phone and SIM card. The only drawback with this method is having to cut a 5mm by 5mm slot into your SIM card to allow the chip to sit flush (see below picture)

iSIM with cut Optus SIM card

I successfully tested the iSIM with a locked Nokia 6300 to Vodafone, with an Optus SIM card.

VBA automatically saves Excel 2003 Workbook in compatibility mode as Excel 2007 Workbook

July 2nd, 2008

Lets say you have a neat little Excel 2003 macro, when you run your macro in Excel 2007, Excel runs it in Compatibility Mode, and any benefits (such as the 16384 columns) you were hoping to use are still unavailable. So how can we enable these benefits depending on the Excel version? Simply by including the following code in the Auto_Open subroutine.


Public Sub auto_open()
'add some smarts if opened in Excel 2007 or later
Dim oldFileName As String
oldFileName = ThisWorkbook.Name
Dim tempi As Integer 'used to store position of '.' before file extension in workbook file name
tempi = InStrRev(oldFileName, ".xls", -1, vbTextCompare)
If Application.version > 11 And Len(oldFileName) - tempi = 3 Then 'assume running in compatability mode
Application.DisplayAlerts = False
Dim newFileName As String
newFileName = Mid$(oldFileName, 1, tempi) & "xlsm"
If fileExist(newFileName) Then 'if the new workbook version already exists, then open it and close this one
'open the new workbook by emulating double clicking the file, as this is the only way to run the auto_open
Shell "Excel """ & ThisWorkbook.Path & "\" & newFileName & """", 3 '3 = vbMaximizedFocus
'close this Excel application
Application.Quit
Else 'if the new workbook version doesn't exist, then save it as new workbook version
'save as macro enables office 2007 workbook
ActiveWorkbook.SaveAs fileName:=newFileName, FileFormat:=52, CreateBackup:=False '52 = xlOpenXMLWorkbookMacroEnabled
'create a timer to call the same new workbook as it will be now opened in non compatibility mode
Application.OnTime Now + TimeValue("00:00:01"), "auto_open"
Workbooks(newFileName).Close
End If
Application.DisplayAlerts = True
End If

UserForm1.Show
End Sub

Some brief info on how this works, so far the only way I have found to run in Non-Compatibility Mode is to save the Workbook as an Excel Macro Enabled Workbook and reopen the file, or if the file already exists then open that file and close the Excel 2003 Workbook. The main problem is the showing of a UserForm on the reopen or existing open. The bove code is the only way I have found so far, and it involves some trickery. It can be simplified if portions are separated into the Workbook_Activate subroutine, but I wanted to provide a copy and paste solution with minimal fiddling around. The only change in the above code is the UserForm1 name.

One of the problems was the Workbook_Activate or Auto_open not running when called via the normal Open method. I actually had to ask ExpertsExchange, the expert was very helpful.

Any comments or suggestions welcome as always.

Pimsleur’s Mandarin Chinese 1 Units 22 to 26 transcripts

June 24th, 2008

Here’s are 5 more transcripts

Pimsleur’s Mandarin Chinese 1 Units 22 transcript by thydzik

Pimsleur’s Mandarin Chinese 1 Units 23 transcript by thydzik

Pimsleur’s Mandarin Chinese 1 Units 24 transcript by thydzik

Pimsleur’s Mandarin Chinese 1 Units 25 transcript by thydzik

Pimsleur’s Mandarin Chinese 1 Units 26 transcript by thydzik

I have also created a Firefox Search Engine Plugin to translate the search to Mandarin using mandarintools.com

Install here