Music database

Music Database

First time I used Excel to organize and rate songs I had in my computer was in 2002. The current Music Database, including complete discographies of selected artists, is a project started in 2005, shortly after connecting to internet I started creating a database in Excel with the MP3 songs downloaded from internet, to review each song and give a rating from 0 to 16, and make top best artists, best albums, best genres, etc, using complex mathematical formulas, to show to friends exactly what music I like and how much. Database is useful for me to organize my own music. How useful is for other people, I don’t know… your feedback is needed to make a better database for YOU and future customers!

Digital cameras database

Digital cameras database

If you are looking for a database of digital cameras specifications in Excel format to create a website, use in a repair shop or anything similar, I created an Excel database for you.

Brands included: Acer, AgfaPhoto, BenQ, Canon, Casio, Concord, Contax, Epson, Fujifilm, GE, HP, Jenoptik, JVC, Kodak, Konica, Konica-Minolta, Kyocera, Leica, Minolta, Minox, Nikon, Nokia, Olympus, Panasonic, Pentax, Praktica, Ricoh, Rollei, Samsung, Sanyo, Sigma, Sony, Toshiba, Vivitar, Yakumo.

Is possible (and legal) to obtain a mobile phone numbers database?

Homeowners associations does have phone numbers of some owners (is a good practice to give your contact info to be announced in case there is a problem in your home while you are away), car insurance companies also have phone numbers of their clients, but what makes you to think that they would give their database to you or potential competitors? Also, distributing / selling phone numbers without owner consent is ILLEGAL all over the world. In Singapore you can be fined up to $10,000 or up to 12 months of jail according pdpc.gov.sg.

Football stadiums database

Football Database

Download free SAMPLE: 2018-FIFA-World-Cup.xls

Took me about 5 minutes to compile this table sourcing data from Wikipedia using “XPath Helper” extension for Chrome.

If you are interested in similar table for all FIFA World Cups 1930-2018, UEFA Euro Cups and other football tournaments, please contact me.

Screen resolution statistics

As graphic designer and enthusiast in computer history, I became curious how the monitor dimensions evolved over the years and analyzed which screen resolutions were most popular, so I created these Excel files:

Choosing a good web hosting service

There are 3 types of hosting services:
– Free web hosting services with pre-made templates
– Free web hosting with PHP and MySQL, similar with paid hosting
– Paid hosting services (shared server, virtual private server, dedicated server)

Webs.com review – WORST hosting ever?

Webs.com is extremely limited compared with other free hosting services, and you get a lot ads and pop-ups telling you to upgrade, as well as weekly emails about Premium services with 50% off… but these Premium services lack features that should exists at any paid hosting services (see below What you CANNOT do on Webs.com).

Webs.com offer a tiny 42 MB storage space and stupid 500 MB monthly bandwidth, unchanged since at least 2008. Is a common trend for hosting services to add new features in their free plans over time. Webs.com marketing strategy is opposite: overtime Webs remove features from free accounts and tell you to upgrade to Premium to continue using them.

SEO SPAM from India

SEO SPAM from India

Webdesign companies do exist all over the world, but 90% of spammers sending unsolicited emails and phone calls are from India, usually start-ups and unexperienced teenagers claiming that are big companies and fool naive people to outsource work to them. Not all Indian companies are spammers, but the (5%?) doing SPAM damage reputation of Indian IT industry and reputable companies suffer as well.

They guarantee that will push my website to top of Google search results, 101% recovery from Panda and Penguin penalties, etc (for your info: no one can guarantee #1 in Google. What if multiple websites in same niche apply for their services, who will be #1?). I asked them how they do that, but most of them do not provide details, they just insist to get paid and let my website on their hands.

Singapore Buildings Database

Database of all buildings in Singapore

The database contains EVERY searchable item in Singapore map, including HDB blocks, condominiums, landed houses, commercial, office and industrial buildings, schools, places of worship, gas stations, parks, MRT stations, and few more. Data included is building name, address, street name, postal code, latitude and longitude, X and Y coordinates of OneMap.sg, etc.

HDB Resale Flat Prices Database

Database of HDB resale flat prices in Excel format

On 1 April 2009, HDB improved its Resale Flat Prices e-service, now showing transactions for last 1 year instead of last 3 months, also added flat model beside floor area. I copied the listings for 1 year (April 2008 – March 2009) in Microsoft Excel, which were displaying 20 per page. I spent about 10 days at 5 hours per day. I did this for purpose of personal analysis, for example estimate average apartment size nationwide and per town, and showing the results of analysis in HDB Statistics page. Few months later HDB showed all transactions in a scroll-able list rather than 20 pages, allowing me to copy transactions much faster, so started to update my database once per year.

City View Boon Keng DBSS

List of DBSS projects

Design, Build and Sell Scheme was introduced in 2005, giving private developers freedom to build and sell public housing in the way they sell condos. Since private developers are hungry for profit, DBSS flats have smaller rooms and abnormal high prices compared with BTO flats despite of same income ceiling ($8.000 per month, $10.000 per month after 2011). DBSS land sales were suspended in 2011.

What is Lease Commence Date

Properties in Singapore are by two types: freehold and leasehold. Leasehold in case of private residential buildings is 999 years, 99 years (or 103 years with 4 years construction time), or in rare cases, 60 years. Other types of buildings can have shorter leases. All HDB flats except Studio Apartments are leased on 99 years.

List of SBF launches

Sale of Balance Flats, comprising unsold leftover flats from past BTO launches, surplus flats from SERS projects, old repurchased flats (including flats from some divorced or fiance couples), are done “when HDB accumulate sufficient flats“, usually twice per year, but this is NOT A RULE. Since 2010 the SBF exercise is done same day with a BTO launch.

HDB Annual Report

HDB Annual Reports 1927-present

I transcribed the tables in Annual Reports 1990-2017 into Excel (New Towns under development and Dwelling units under management by town and flat type). I can go further and do the same for 1960-1989 tables, also transcribe in Word all the Annual Reports if there is sufficient demand.

List of BTO flat types and their prices

List of BTO prices

Have you ever wondered what were the HDB flat prices in the past, but have a hard time digging for prices around various news websites and forums? In 2016 I spent about 10 hours compiling selling price ranges of all BTO flats in one Excel database that allow you to compare flat prices by town, by flat type, etc. I update database with every BTO launch (usually every 3 months).

SIT Tiong Bahru Estate

List of old SIT estates

Singapore Improvement Trust set up in 1927 and focused on infrastructure, it also built small scale public housing, such as Tiong Bahru (started in 1936) and Queenstown (started in 1952 and completed by HDB in 1960s). In 32 years, SIT built only 23,000 flats, housing 8.8% of Singapore population in 1959.

Update list

Several people asked me when the page was last updated.
If today I correct a spelling error, can be considered updated today?
Last update matter less… instead, please report if I forgot to add something, or suggest what else to add, and I may update it today!

Caesar III

Caesar 3

Caesar III is one of my favorite games. I got the demo version in 2000 from a magazine CD. Demo version include only first 2 missions but 2nd one is bigger than in full game. Started playing in the morning and build as much I can by end of day, reaching population of about 5000, Demo version was not allowing me to save game.

I got the full game only in 2005, and I played it a lot in 2005-2006, then in 2008, and a little since October 2011, the moment in which I created this page on my website, originally strictly for cities built by me. In 2012 the business forced me to stop playing games, but I kept expanding page adding info about game itself.

Age of Empires

Age of Empires

Excel tables made by me, containing list and tree of buildings, villagers, military units, boats, animals, research and upgrades. Hit points, attack, armor, piercing armor, range, speed, cost, time required to produce, etc.