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…
Month: February 2015
VBA – Sorting VBA array – Functions in VBA
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…
C# – A simple interface with 3 classes in C#
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…
C# – Masking words in a text
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…
VBA – Making your Excel application really cool
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 – Probability Simulation of Two Dice
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…
VBA – Reverse colors in MS Excel
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…
Book Review – The Python Workbook
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)…
C# – Animate a ASCII picture in Console
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…
VBA – Sorting VBA array – Functions in VBA
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…
VBA – Insert a dash between odd numbers
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
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 – Count the Number of Chars in a String
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…
Book Review – Advanced Techniques for Lightning Fast Sorts and Searches
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 – Python Programming Fundamentals
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…
VBA – Excel custom formula for second biggest value
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.…
Top