free hit counter

«

»

May 10

Books and databases Word / Excel

Since childhood I love writing books, doing research, making databases and statistics. I started using computers in 1997, my dad taught me to use Word, but around 2003 I started using Excel more than Word. Analyzing data, making tables and charts about everything encountered in my life! For example, in racing games I measure the speed of each car and write the numbers in an Excel spreadsheet then make a chart.

Early works were pure hobbies, made from personal interest. Hong Kong Housing Database‘s expansion with private estates, was the my FIRST large project done for a customer, an insurance company, in 2011.

Other works such as Car Database and HDB Database were started as hobby for my personal use, but had an unexpected turnout into business after 2012, and now I update them regularly to sell for professional use.

List of Word / Excel projects done so far
incomplete list, I made so many… that I forgot them! I will post more works, once I remind them, and recheck the quality
Do you want to make any database for you?

Project File type Size (KB) Pages /
rows
How was
made
Date made /
maintained
World geography-related
Solar System (Word version, DELETED) DOC manual 2000 ?
Solar System (Excel version) XLS 45 manual 2014
World countries & facts
(Word, based on old atlas, DELETED)
DOC manual 1998-2000
World countries & facts (Excel, based on Encarta 2002) XLS 81 ~200 rows manual 2004
World cities population DOC 727 130 pages manual 2003-2005
Tallest buildings database XLS 5425 15000+ scraping 2015-present
Singapore-related
Database of HDB Blocks XLS 6000+ 14000+ rows manual 2009-present
Database of HDB Resale Flat Prices XLS 24307  80 rows copy-paste 2009-present
List of BTO & DBSS projects XLS 103 300+ rows manual 2009-present
List of BTO prices XLS 121  500+ rows manual 2009-present
List of SERS sites XLS 49 80 rows manual 2009-present
Hong Kong-related
Hong Kong Public & Private Housing Estates Database XLS 592 1000+ rows manual 2011
Romania-related – download from www.teoalida.com/ro/geografie
Geografia Romaniei (geographic features) DOC 198 23 pages manual 1998-2006
Drumuri nationale (list of roads) DOC 72 6 pages manual 1999-2006
Cai ferate linii (list of railways) DOC 74 6 pages manual 1999-2006
Cai ferate linii & statii (list of railways with stations) DOC 347 51 pages manual 2000-2006
Impartirea administrativa interbelica (1925-1940) DOC 166 11 pages manual 2006 ?
Impartirea administrativa in regiuni (1950-1968) DOC 81 8 pages manual 1999-2006
Impartirea administrativa actuala (1968-prezent) DOC 105 10 pages manual 1998-2006
Populatia judetelor si oraselor (city population) XLS 213 320 rows manual 2004-2006
Automobile-related – download from www.teoalida.com/cardatabase
Car Models List DOC 403 59 pages manual 2003-present
Car Models List XLS 835 4000+ rows manual 2012-present
Car Models Timeline XLS 584 no manual 2003-present
Car Models Encyclopedia DOC 1680 360 pages manual 2005-present
Car Models Database XLS 1338 3000+ rows manual 2005-present
Car Models & Engines Database XLS 12873 16000+ rows manual 2003-present
American Year-Make-Model XLS 1117 10000+ rows manual 2013-present
American Year-Make-Model-Trim-Specs XLS 22954 46000+ rows scraping 2013-present
Indian Car Database XLS 17152 3000+ rows scraping 2013-present
AutoKatalog Statistics XLS 212 manual 2012-present
Automobile Production XLS 130 copy-aste 2012-present
Computer-related
Screen size calculator XLS 50.5 manual 2014
Screen resolution statistics XLS 326 copy-paste 2014-present
Screen resolution statistics by country XLS 2380 copy-paste 2014-present
Gaming-related – see www.teoalida.com/games
Age of Empires DOC 208 manual 2001 ?
Age of Empires (base game)
(table of military units)
XLS 106 manual remade 2007 ?
Age of Empires: The Rise of Rome
(table of military units)
XLS 112 manual remade 2007 ?
Beetle Crazy Cup
(vehicle stats)
XLS 71 manual 2002?
GTA Vice City
(mission tree, vehicle stats)
XLS 117 manual 2005
GTA San Andreas
(mission tree, vehicle stats)
XLS 134 manual 2007
Commander Keen 4 – Second game I ever played!
(statistics of levels and items)
XLS 117 manual ~2000? DOC
remade 2007 XLS
Midtown Madness 1
(vehicle stats)
XLS 40 manual 2003
Midtown Madness 2
(vehicle stats)
XLS 35 manual 2005
Need For Speed: Porsche Unleashed
(vehicle stats, personal records on every track)
XLS 217 manual 2003-2006
Need For Speed: Hot Pursuit 2
(career levels, vehicle top speed stats)
XLS 58 manual 2003
Need For Speed: Underground
(career events, vehicle performance stats, tuning items)
XLS 161 manual 2006
Quake 3 maps statistics
(not yet public due of messy work)
XLS ? manual 2000-2007
The Sims 2/3 List of houses made by me XLS 24 manual 2013
The Sims 2 Career Tracks XLS 219 copy-paste 2012
The Sims 2 List of Items XLS 216 manual 2012
The Sims 3 Worlds and List of Lots XLS 398 manual 2013
Miscellaneous
Music Database XLS 2000+ 5000+ rows manual 2005-present


Some projects (example Database of HDB Resale Flat Prices) involve copying the data from a source website and pasting in Excel, then few visual adjustments to make it beautiful, which takes just few hours to create a 20 MB Excel database.

Other projects (example Database of HDB blocks) involve compiling data from various sources and manual data entry in Excel, taking hundreds hours of work!

All works are made primarily for visualization in Excel, but some (especially the Car Database) are often used by professionals who are converting the Excel spreadsheet to CSV and MySQL and use in web design and mobile app development.

About me & history

My parents encouraged me to work in Microsoft Word, and told me to finish and print the work because “what is not finished have ZERO value“. I never understand why they wanted to print… some works for example Car Database should NOT be printed and cannot be “finished”, it need to be updated constantly with new launched cars. They promised me that will help me publishing a book… but this never happened (there is a possibility that they encouraged me just to give me a solitary occupation at computer to prevent me disturbing them, instead of letting me to have a social life).

My dad even set me rules, how a book should be written: Arial font, 12pt body text, 16-20pt titles, all titles centered, bolded, underlined. However, since my writings were not really a book but a list of… something, the rules imposed by dad created excessive bold and centered text.

Around 2001-2003 I got fascinated by Notepad and by fixed-width font and I was using lines of — and === signs full page width to enhance titles.

Since 2003 I broke away from dad rules and started using Excel more than Word. New works in Word were optimized for on-screen display instead of printing, often using non-standard page sizes, to make exactly 1 page for each subject. I write with 10pt font for body text, 20pt and 15pt for titles, 10pt and 5pt for empty spaces.

Since 2003 for both Word and Excel works, the titles were white text on blue background for full page width, which does not look very well on paper. I used same style when created my website in 2009.

Since 2010, one of the distinctive features of all my Excel works are the coloured columns, older works were coloured to this format too. I combine the Excel databases with my graphic design hobby, making Excel files also artistic!

Since 2015 I changed the standard of Word files, removing full-width coloured backgrounds of titles and putting instead full-width horizontal lines (similar with what I was doing in 2001-2003 in Notepad). This will be better for printing (even if I assume that nobody will print my works). I changed also my website design to this format.

Example of styling in my books: 2012, 2013, 2015 editions of Car Models Encyclopedia
  

I also done some kind of competition between my works, a race to create biggest database in Excel or biggest book in Word, in terms of pages and file size, under certain standards (10pt font, no duplicate stuff, no large open spaces, NO bullshit but useful content, etc). I kept track of file size in an Excel table similar with above table.

1 comment

3 pings

  1. Herminia

    nice

  1. About me & history of Car Database | Car Database

    […] databases about buildings too, and many others. I als work in architecture & CAD design. Read the Main page. I am a car expert and a web […]

  2. Music database, songs rating and artist rank | Teoalida Website

    […] Word / Excel databases […]

  3. Data scrapping services | Car Database

    […] databases. Time-costly jobs which limited the size of the databases I could make. Even in this way I made about 40 databases about cars, geography, real estate, gaming, […]

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>