Skip to content

Database projects

Teoalida Music Database

Music Database

We all love music, but I may be the only person who made an Excel database and show to everyone what are my musical preferences in the style of a data scientist. Since 2005 I use Excel to organize the music I am listening, rate each songs from 0 to 16, then use complex mathematical formulas to calculate scores and rank best artists, best albums, best music genres, etc.

Web scraping services

Web scraping services

I offer data mining and web scraping services. “Scraping” usually means coding a bot that visit a list of given pages, copy specific data from each page and put it in an Excel / CSV file automatically, at rate of few pages per second. Watch the video!

If you are building a website, a mobile app, or just require specific data but cannot find in usable format, just give me link to a website having required data, I will make a scraper and turn website into an Excel database, for you and for future customers.

Excel, XLS, XLSX, CSV, SQL, XML, JSON

Index of databases made by Teoalida

During my live I made over 100+ databases, from personal interest to distribute freely or sell for professional use. Some projects I made at request and published on website to allow other customers to purchase if interested. They have been used by numerous people from students practicing data analysis, to multi-national companies in real estate and automobile industry. I offer web scraping services in VB.NET and Python, making custom databases according your requirements. I work in Word and Excel, other file formats available: CSV, SQL, XML, JSON.

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.