Skip to content
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. Contains 36 camera brands with a total of over 3700 models.

List of Singapore MRT and LRT stations

List of MRT and LRT stations

    If you are looking for a database of Singapore MRT and LRT stations in Excel format, I created an Excel database for you in November 2019, copy-pasted from Wikipedia and visually enhanced in Excel to match the style of my other spreadsheets “Made by Teoalida”. In January 2020 I expanded database adding postal codes and GPS coordinates (sourced from OneMap.sg) for all stations that are opened or under construction.

    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.

    Countries database

    World countries database

    Are you looking for a database of countries in Excel format with their facts and figures, for research or to create a website? I made a database for you. Took few hours to make a scraping script which extract data from The World Factbook and create a CSV file. Takes about 35 min to extract the 268 entries, and I can update anytime you want!

    Airports database

    Airports database

      Are you looking for a database of airports and other airfields in Excel format for research or to make a website? I made a database for you, you can open XLS file, save as CSV and import in SQL if needed.

      ID 100%, Ident 100%, Type 100%, Name 100%, Latitude 100%, Longitude 100%, Elevation (ft) 87.33%, Continent 100%, ISO country 100%, Country 100%, ISO region 100%, Region 100%, Municipality 89.67%, Scheduled service 100%, GPS code 74.11%, IATA code 16.58%, Local code 52.24%, Home link 5.43%, Wikipedia link 17.86%, Keywords 17.22%.

      Web hosting

      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)

      Solar System Database

      Solar System Database

      Are you looking for a database of planets and satellites in Excel format with their facts and figures, for research or to make a website? I made a database in 2014 with planets and main satellites, sourcing data from solarsystem.nasa.gov.

      Given by high number of free downloads, in 2019 I made a larger Excel database containing EVERY celestial body listed on NASA website (1 sun, 8 planets, 5 dwarf planets, 190 satellites) and offer for paid download.

      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.

      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.

        HDB floor plans in AutoCAD

        HDB floor plans > AutoCAD .DWG

        I can provide DWG file, 2D or 3D model of your HDB flat for only $40! And not just HDB floor plans. I can also design condo floor plans, house plans, etc. Contact me for anything that can be drafted in AutoCAD!

        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.

        Excel colors

        Colors database RGB & HEX

        First time I made such table was in 2004 (15 years old) when I spent few days making in Paint an image with 48 hue levels and 32 lighting levels (Excel 97-2003 was limited to 56 colors).

        In 2018 I remade it in Excel, adding RGB values for easier use, the job took about 4 hours, 48 hue levels and 16 lighting levels. In 2019 also made a Scalable Vector Graphics table with HEX colors.

        Furnished apartment

        Furniture & interior design

        I design furniture since ~14 years old (~2003), around 15 years old my mom employed in a furniture factory so we refurnished my room using my pre-made drawings. People who contacted me over years made me to pursue my career in architecture rather than interior design. Whenever I will do furniture design again, we will see… I am using AutoCAD so my drawings are more technical instead of photo realistic, like the ones made by professional interior designers in 3D Studio Max.

        Architecture – Rules for an ideal city

        Minimum room size, length, width and floor area, setback requirements and other rules used in apartment blocks and house projects designed by me in “Teoalida’s Virtual City”. plus comparison with building codes from various countries.

        Car design in AutoCAD

        Car design in AutoCAD 3D models

        Before moving into architecture design in 2008, I also modeled few 3D car models in AutoCAD. I did NOT wanted to design the ultimate sport car, instead I designed an average classic family car, with many details as possible, to show my skill as graphic designer, and to use many of AutoCAD photorealistic effects as possible, to show the performance of AutoCAD render. Do you though that AutoCAD is only for 2D drawings?

        City maps designed by me

        The hobby for designing maps have a long history. Starting from 6 years old I was drawing random roads on paper and coloured them in various colors. The first time I designed a map of a real city was at age of 14, in 2003 I made on paper a map of my city downtown with a special attention given to historical buildings.

        Palatul Cantacuzino "Micul Trianon" din Floreşti Prahova

        Palace Trianon 3D design in AutoCAD

        This palace is one of the most beautiful 3D modeling works that I ever designed in AutoCAD. Many people were impressed not only by the beautiful 3D renders, but also for excellent model geometry that makes it to look like 18-19th century neoclassic architecture. Some people asked me how I got the idea to design such complex building, and suggested to change some details to make it better, BUT…

        Paper to CAD conversion

        Paper to CAD drawing conversion services

        Most AutoCAD designers offering paper-to-CAD conversion simply put the scanned JPG in background and draw over it, every line, often making various identical drawing elements at different dimensions, aka low-quality CAD drawing.

        Personally I offer quality paper-to-CAD conversion services, taking care to make every element of drawing a rounded dimension, and in case of floor plans of various buildings, I will give you option to add dimensions in CAD file as they are in the original floor plan, as well as adding more dimensions, or providing a CAD file without dimensions but designed according dimensions from the scanned floor plan.

        You give me JPG, PNG or other raster image format, and I give you DWG, DXF or PDF. Contact me for price quote!

        Website penalized by Google and my solution

          I added too many keywords in image ALT tags on 2 pages each with around 100 images. These 2 pages have been the first to be penalized by Google, in mid-2013 for few months they were no longer appearing in searches and traffic dropped with 90%. I should have taken this as a WARNING that I do something wrong, but I did not paid any attention and continued adding ALT tags stuffed with keywords. On 12 October 2013 whole site was removed from Google search results for most keywords, causing traffic drop from 500 to 150 daily visitors. On 9 January 2014 remove the ALT and TITLE tags. Surprise, next day 10 January penalty was lifted (after 90 days).

          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.

            Beetle Buggin

            Beetle Crazy Cup

            Beetle Crazy Cup, also know on warez websites as Beetle Buggin’ (probably due to amount of software bugs included in game), or Käfer Total, is one of the worst racing games I ever played… but it can be fun if is played at home with a friend.

            Beetle Crazy Cup is the most recent game that can be played with 2 persons at same computer, know by me. Do you know other such games?

            I created an Excel table: Beetle Crazy Cup.xls containing statistics such as vehicle list with car prices and car top speed in each gear.

            Grand Theft Auto: San Andreas

            GTA Vice City & San Andreas

            Probably one of most played games today is Grand Theft Auto. Although I do not like violent games, I still played Vice City and San Andreas around 2005-2007, more as a driving game, not shooting and killing as many is possible (as my friends were doing!), but I also finished all missions of the story line.

            I show here the Excel files made by me with statistics about game:
            GTA Vice City mission tree, property list, weapons list, vehicle list with their top speed and other info.
            GTA San Andreas vehicle list with their top speed and other specs, mission tree, weapons.

            Miner VGA

            MinerVGA

            I played MinerVGA starting from 1998 for few years, losing every time (money earned from minerals was not enough to cover costs of digging). In 2016 I suddenly remembered this game, saw some walkarounds on YouTube, played it again in correct way, and won the game for the first time by finding the wedding ring to marry Mimi.

            Need For Speed Porsche Unleashed

            Need For Speed

              My favorite racing game was Need For Speed: Porsche 2000 / Porsche Unleashed. I got it in 2003 from a friend. I made this table NFS Porsche 2000.xls, including car list, top speed of each car, written my personal records, and other stuff.

              The next Need For Speed: Hot Pursuit 2 was a worsen game, as they moved to Arcade style of racing, no damage. Got it from friends. I made table NFS Hot Pursuit 2.xls, containing car list, car max speed, career track, prices, etc.

              Supaplex

              Supaplex

                Supaplex was the 1st game I ever played, shortly after my dad bought our first computer in 1995, but lost it in 1997 due to HDD crash. Once I connected to internet in 2005 I found a Windows version, Megaplex, and few years later I found original Supaplex again on DOS Games Archive. I made Supaplex level list in Excel

                The Sims 2

                The Sims 2

                I started playing The Sims in 2003 and The Sims 2 became my favorite game, I built over 50 houses in it and few more in The Sims 3 too, which I offer for free download on this website. I also love making tables, statistics and data analysis in Excel, for list of neighborhoods, worlds, jobs and list of items for all 4 Sims games.

                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.