C# – CodeForces – From Hero to Zero
It was some time ago, since I last took a look at programming challange in CodeForces, thus I have decided to take a look again. So, I chose the lowest problem of the second division just to boost up my …
Year: 2019
C# – Look at the Variables’ Values, while Debugging in Visual Studio
Debugging is like being the detective in a crime movie where you are also the murderer. In order to debug well, we need to know the value of the current variable. In Visual Studio, this could be acquired through multiple ways. …
C# – Look at the Variables’ Values, while Debugging in Visual Studio Read more →
Analyzing trends with map and reduce in Python
Editorial (from Vitosh): Lately, I have reviewed the Mastering Large Datasets book by J.T. Wolohan. The book is python based and it explains how to scale a data project, using the map and reduce to scale data projects. Long story …
Top VBA-Excel errors
Some months ago #VBA was finally considered the most dreaded language in the 2019 StackOverflow survey: One of the reasons for this, is probably that #VBA is quite too easy to enter, thus plenty of non-IT professionals feel fascinated about …
VBA – Abstract classes. Classes, that cannot be instantiated.
There are parts of #VBA, that can scare any VBA developer, who has not bumped into other languages. Although, the “abstract class” term is quite popular in C# and other languages, and is quite easy to be created, in VBA, …
VBA – Abstract classes. Classes, that cannot be instantiated. Read more →
C# – Reading from Excel Spreadsheets with Asynchronous Programming (Async)
Reading from Excel in C# is actally not at tough as many VBA developers would assume. The simple reading is actually quite straightforward – there is only small little trick, requiring the adding of the Microsoft.Office.Interop.Excel reference to the Visual …
C# – Reading from Excel Spreadsheets with Asynchronous Programming (Async) Read more →
C# – How to get the last filled cell of a given row in Excel
Getting the last row of a given column in Excel with a formula or with VBA is quite a trivial task. It is explained here quite well 🙂 However, when we come to C#, the only “trick” that is provided …
C# – How to get the last filled cell of a given row in Excel Read more →
C# – Find the Biggest Square in a Matrix – What can Excel and VBA add to it?
Finding the biggest square of specific units in a given matrix of these units is a standard dynamic programming problem. The examples in Google for it are above 18 million, thus I would simply show how it is done with …
C# – Find the Biggest Square in a Matrix – What can Excel and VBA add to it? Read more →
C# – Refactoring a Problem
Some days ago I have decided to take a look at one of the homeworks problem of the OOP course at SoftUni. Then, I have decided to solve it with my VBA OOP knowledge, implementing it in C#. Whether VBA …
C# – Quick Reference for Abstract Classes
Abstract Classes in C# are classes, intended only to be a base class of other classes. Members marked as abstract, or included in an abstract class, must be implemented by classes that derive from the abstract class. Reference With other …
Python – Customizing PyLab using Style
Learn how to customize PyLab using style in this article by Benjamin Walter Keller, a PhD candidate at McMaster University with BSc in physics with a minor in computer science from the University of Calgary in 2011. This article will delve …
Visual Studio – How to create a custom shortcut
If you want to create a custom shortcut to a command in Visual Studio, these are the steps to be taken: Ribbon>Tools>Options Environment>Keyboard Show commands containing (write the command) Press shortcut keys Assign and OK
VBA – How to copy a new object in VBA, without copying its reference
Copying an object in VBA to a new object is somehow tough. If you use Set foo = bar then, both foo and bar would be pointing to the same address in the heap. And if you change the properties of one, …
VBA – How to copy a new object in VBA, without copying its reference Read more →
C# – Entity Framework – Using LINQPad for Queries – Just Getting Started
After the previous two articles for C# – Foreign Keys in Entity Framework – Code First – Query with Linq and Entity Framework – Linq vs Extension Methods (Example) it is a good idea to present some actions with LINQPad. LINQPad5 is …
C# – Entity Framework – Using LINQPad for Queries – Just Getting Started Read more →
C# – Foreign Keys in Entity Framework – Code First – Query with Linq
In this article, I present an Entity Framework example, building two tables with foreign keys, using code first. The sample I am using is building over the previous article for EF. Pretty much, when you are running your application, if …
C# – Foreign Keys in Entity Framework – Code First – Query with Linq Read more →
Entity Framework – Linq vs Extension Methods (Example)
This article presents a simple example of querying with Linq and Extension Methods in Entity Framework (EF). To set the EF, create a C# Console application. Then add the Package Manager Console from Tools: Then run Install-Package EntityFramework in the Package …
Entity Framework – Linq vs Extension Methods (Example) Read more →
Python – Plotting with Object-Oriented API
Learn how to plot a correlation matrix using pyplot and object-oriented APIs in this article by Srinivasa Rao Poladi, the co-founder of krtrimaIQ a consulting firm that provides cognitive solutions to create tomorrow’s Intelligent Enterprises powered by automation, big data, …
VBA – Environmental Variables
The environmental variables are a dynamic-named values that can affect the way running processes will behave on a computer. With other words, if you want to see them in your PC, simply open the command prompt and write the nice word …
Fundamental Concepts of Concurrent Programming with Python
Learn some of the fundamental concepts of concurrent programming in this article by Quan Nguyen, a Python enthusiast and data scientist. It is estimated that the amount of data that needs to be processed by computer programs doubles every two years. The International Data Corporation (IDC), for …
Fundamental Concepts of Concurrent Programming with Python Read more →