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 …
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 »