initially, the idea of the article was to write four lines of code, doing the following 2 tasks: uploading data to a given file getting JSON data from file and using it in an application However, as soon as I started, I …
Python – Add data to external files and get JSON data from files Read more →
In the current article, I will show you how to build functions for built-in objects in JavaScript. The way I know is using a prototype. Thus, I will create functions, giving us the last n values of an array or returning a capitalization …
JavaScript – Make Custom Functions with Prototype Read more →
JSON is somehow powerful. With Node JS and JSON you may build almost anything you can think of (if you have unlimited time and coffee/beer). How about building a small console application with the following options: Yesterday, I started to …
Python’s lists are powerful. Especially, if you come from the VBA world its like switching to a new car after years of using the old red Ikarus. Thus, I have decided to write a small article about them, just to be …
Python – A little bit about lists and operations with them Read more →
If you want to build a magic square, check this article, the python code is at the bottom – How to build a magic square A magic square is an arrangement of the numbers from 1 to N^2 (N-squared) in …
Some time ago I have started to learn Python. Today, I will present a way to solve the problem “Reduce file path”. The problem is the following – you are given a string and you should reduce it to a meaningful …
Python – Reduce file path problem (with string slicing and list comprehension) Read more →
This week I have started to study Python a little more into detail in the courses of HackBulgaria. After end of the second day, the last problem was considered worthy for blogging, as far as it took me about an …
In the current article, I will present a few useful commands, for the Linux(Ubuntu) terminal. The article is going to be updated constatly with new entries:) Here they come: General Python Related Java Script and Git related
Well, most probably the answer depends on the query language 🙂 Here is the task: Problem 3 – A query language over a CSV file A CSV files (comma separated values) can be represented as a table. For example this …
In the current article, I will show how to resolve with VBA an entry exam for programming in HackBulgaria. The problems could be resolved in any language and I will use VBA for the first two in this article. The idea …
In the current article, I will show how to resolve with VBA an entry exam for programming in HackBulgaria. The problems could be resolved in any language and I will use VBA for this last task. The program is actually the …
Imagine you are the owner of a web site with a lot of comments (not like this one, where noone comments due to the fact that he should do it with his Facebook account 🙂 ). In this site there …
Some time ago I was working over an Excel file, making it look like a cool application. As far as I was getting paid for it, it had to look really outstanding 🙂 In VBA, there is a way to make your Excel …
VBA – Making your Excel application really cool Read more →
Throwing dices used to be a way to gamble. Nowadays, with TexasHoldEm all over the internet, this game is forgotten 🙂 Probably for good. Anyway, at the beginning of statistics every student is required to resolve some problems, containing dice, cards or …
Today I was working with the Excel color styles and I tought that they are actually pretty well made. But for some reason I wanted to have a reverse of the styles and I did not want to waste time to define a …
This weekend I have managed to finish the online version of the book “The Python Workbook”, kindly provided to me by Springer. The book provides you with 174 exercises, which can make you an advanced beginner (if this term exists) …
I was searching for a way to animate a picture in the C# console and I managed to find something quite good here. Then it was quite easy, to do the animation – the key was in the adding of the line …
In the current article, I will show how to resolve with VBA an entry exam for programming in HackBulgaria. The problems could be resolved in any language and I will use VBA for this last task. The program is actually the …
In the current article, I will present the way to calculate the number of chars in a string with VBA. The inspiration came from the entry exam forHackBulgaria Programming 101v3. The tasks were given some months ago, so I assume it …
In the current article, I will present the way to calculate the number of chars in a string with VBA. The inspiration came from the entry exam forHackBulgaria Programming 101v3. The tasks were given some months ago, so I assume it …
VBA – Check distance between two chars in a string Read more →
In the current article, I will present the way to calculate the number of chars in a string with VBA. The inspiration came from the entry exam for HackBulgaria Programming 101v3. The tasks were given some months ago, so I assume …
The book Power-Up Using Excel VBA Sorts and Searches: Advanced Techniques for Lightning Fast Sorts and Searches by Rich Locus presents VBA code, that can be used for Searches and Sorts. The idea behind the book is to present the commands VLookup, Match …
Book Review – Advanced Techniques for Lightning Fast Sorts and Searches Read more →
This weekend I have managed to finish the online version of the book “Python Programming Fundamentals”, kindly provided to me by Springer. In general, I have almost no experience with Python, so I have read the book with the eyes …
In this rather small article I have decided to show how to take input from arrays for Excel custom formulas. In order to do this, I have decided to make a custom formula, calculating the second biggest number from a given sequence. …
VBA – Excel custom formula for second biggest value Read more →
As I have already mentioned in some articles here and there, in order to find something valuable and interesting to blog about, I convert tasks from C# into VBA. The C# task from the SoftUni looked like this: Define a class …
The book Excel Macro Mastery is an excellent book for non-programmers, willing to learn VBA. Indeed, it is written in simple English, following the 80/20 rule of Paretto in Excel, or as the author says, 99.9% of the time you …
For quite some time I have decided to solve some of the C# competition exams of the SoftUni in Excel. The problem for today is called Cheat Sheet and you may find the description here. Long story short, you have to …
VBA – Excel – building a custom formula for C# competition exam Read more →
In the current article, I show why it is convenient to use the Format as Table option in Excel. Pretty much, it enables a new feature – you may refer to the cells in it not by an address, but with the …
Simple Excel – Usage of column names for formulas Read more →
After the previous two articles, in which I have resolved two C# competition problems of the SoftUni, located here and here I have decided to resolve a new one. Pretty much, it turns out that it is really possible to …
VBA – Resolving C# competition problem with VBA and Excel (2) Read more →
In the previous article here I made a custom formula, building a plane in Excel. The idea for the article was inspired from the SoftUni entrance exam. Today I have done something similar – I found a challenge, where one was asked …
VBA – Excel – Bulls and Cows with Excel formula Read more →