↓ Skip to Main Content
Useful code Programming with VBA, C# and Python

Main Navigation

  • All
  • VBA
    • VBA Tools
    • VBA Online Resources
    • All VBA articles
  • Python
  • Else
    • C#
  • Reviews
    • List of reviews
  • YouTube
  • PayPal
  • About
Useful code Programming with VBA, C# and Python

Off Canvas Menu

  • All
  • VBA
    • VBA Tools
    • VBA Online Resources
    • All VBA articles
  • Python
  • Else
    • C#
  • Reviews
    • List of reviews
  • YouTube
  • PayPal
  • About

Year: 2017

Home › 2017 › Page 2
Excel VBA – Activity Selection Algorithm
VBA \ Excel

Excel VBA – Activity Selection Algorithm

Vitosh Jul 17, 2017 Tagged with algorithm, Excel, greedy, VBA

Wikipedia says that the activity selection problem is a combinatorial optimization problem concerning the selection of non-conflicting activities to perform within a given time frame, given a set of activities each marked by a start time (si) and finish time (fi). The problem is to select the maximum …

Excel VBA – Activity Selection Algorithm Read more →

C# – CodeForces – A. Mister B and Book Reading
C Sharp Tricks, CodeForces

C# – CodeForces – A. Mister B and Book Reading

Vitosh Jul 17, 2017 Tagged with C#, codefoces

Codeforces has easy and tough questions. However, the easy are not always easy, but the tough are always tough. Thus, after writing the Excel article here for Sumproduct, I have decided to go a bit easy and start with the …

C# – CodeForces – A. Mister B and Book Reading Read more →

C# – CodeForces – Okabe And Boxes
C Sharp Tricks, CodeForces

C# – CodeForces – Okabe And Boxes

Vitosh Jul 16, 2017 Tagged with C#, Stack

CodeForces has people working 24/7, trying to come up with interesting problems for the IT community. Thus, it’s always challenging to take a look at these problems and to try to solve them. The latest problem I have faced was one …

C# – CodeForces – Okabe And Boxes Read more →

Excel – Use Sumproduct() instead of Sumifs() or Countifs()
VBA \ Excel

Excel – Use Sumproduct() instead of Sumifs() or Countifs()

Vitosh Jul 15, 2017 Tagged with closed workbook, Countif, Excel, Sumif, Sumifs, Sumproduct

Sumifs() and Countifs() are formulas in Excel, that sum or count a range with multiple conditions. Unfortunately, these formulas do not work, when you want to refer to a closed workbook. That’s where the magic of the Sumproduct() formula comes. …

Excel – Use Sumproduct() instead of Sumifs() or Countifs() Read more →

Excel VBA – NetworkDays Formula
VBA \ Excel

Excel VBA – NetworkDays Formula

Vitosh Jul 14, 2017 Tagged with Excel, NetworkDays, VBA

In Excel, there are plenty of ways to calculate the differences between days. However, the NetworkDays Formula includes weekends and may include the holidays, which would be different for each country/province. Thus, it is useful! Here is how to use …

Excel VBA – NetworkDays Formula Read more →

News – Book Review – BI Tools for Small Companies – Coming Soon
News, Review

News – Book Review – BI Tools for Small Companies – Coming Soon

Vitosh Jul 13, 2017 Tagged with Book Review, Business Intelligence Tools

Business Intelligence is really a thing in the small companies – usually they do not want to invest a lot into software and consultancy, thus a regular controller or a developer can become the company’s champion easily. 🙂 As far …

News – Book Review – BI Tools for Small Companies – Coming Soon Read more →

C# – CodeForces – Okabe and Banana Trees
C Sharp Tricks, CodeForces

C# – CodeForces – Okabe and Banana Trees

Vitosh Jul 11, 2017 Tagged with C#, codeforces, linear equations

It does not happen a lot, but this time the 2. problem  of CodeForces really made me rethink my life choices and made me feel a bit sorry that I was in a school where we studied Maths about 4 hours …

C# – CodeForces – Okabe and Banana Trees Read more →

C# – CodeForces – Okabe and Future Gadget Laboratory
C Sharp Tricks

C# – CodeForces – Okabe and Future Gadget Laboratory

Vitosh Jul 10, 2017 Tagged with algorithm, C#, simple

CodeForces is a nice website for anyone, who likes checking himself vs the top developers worldwide. It’s even separated into divisions, thus, they kindly provide 3 easy questions and 5 hard. Although, I do not know anyone who can call …

C# – CodeForces – Okabe and Future Gadget Laboratory Read more →

C# – CodeForces – Karen and Game
C Sharp Tricks, CodeForces

C# – CodeForces – Karen and Game

Vitosh Jun 28, 2017 Tagged with C#, codeforces, greedy

Karen and Game is the third article about Karen. In a row. Pretty much, someone in CodeForces has created 7 different problems with her, thus the Japanese lady is getting famous. This time the problem looks like this: The game is …

C# – CodeForces – Karen and Game Read more →

C# – CodeForces – Karen and Coffee
C Sharp Tricks, CodeForces

C# – CodeForces – Karen and Coffee

Vitosh Jun 25, 2017 Tagged with binary search, C#, data structures

If you are following this blog you are probably asking yourself Who the beep is Karen? and why do I write a 2. article about her in a row? 🙂 Well, that’s Karen and she obviously likes coffee: Karen was the main …

C# – CodeForces – Karen and Coffee Read more →

C# – CodeForces – Karen and Morning
C Sharp Tricks, CodeForces

C# – CodeForces – Karen and Morning

Vitosh Jun 19, 2017 Tagged with C#, CodeForeces, TimeSpan

Its Sunday and it is time for CodeForces. Today I have taken a look at round number 816, Problem A. The problem initially looks rather easy and you think that nothing can go wrong, until you do not try it. …

C# – CodeForces – Karen and Morning Read more →

News – DevOpsCon – What has VitoshAcademy done 2 days in Berlin?
News

News – DevOpsCon – What has VitoshAcademy done 2 days in Berlin?

Vitosh Jun 17, 2017 Tagged with devops, linear regression python

The past week, on Monday and Tuesday I was in Berlin, for the DevOpsCon.     On Tuesday was the first day of the conference. I was present on a few DevOps talks and in general, I managed to understand …

News – DevOpsCon – What has VitoshAcademy done 2 days in Berlin? Read more →

C# – CodeForces – An express train to reveries
C Sharp Tricks, CodeForces

C# – CodeForces – An express train to reveries

Vitosh Jun 17, 2017 Tagged with C#, codeforces, constructive algorithms

CodeForces.com is a web site for competitive programming. One of the 2 really famous sites in internet. Yesterday I was fighting with a the problem 2 in Division B from competition number 814 for about 1 hour, until I have managed …

C# – CodeForces – An express train to reveries Read more →

C# – CodeForces – An abandoned sentiment from past
C Sharp Tricks

C# – CodeForces – An abandoned sentiment from past

Vitosh Jun 16, 2017 Tagged with Algorithms, C#, codeforces, string to list of int

CodeFoces.com is the place where I go when I do not know what to blog about. 🙂 Anyhow, as a developer who is with some experience there, I always expect that the first problems of Division 2 would be quite …

C# – CodeForces – An abandoned sentiment from past Read more →

DevOps Conference in coming – time to install Python on my machine
News, Python

DevOps Conference in coming – time to install Python on my machine

Vitosh Jun 8, 2017 Tagged with devops, how to install python, Python

In less than 4 days I would be travelling to Berlin to see what is happening on the DevOpsCon there. I will be present for a whole day workshop for machine learning with Python, thus I have decided that it …

DevOps Conference in coming – time to install Python on my machine Read more →

C# – CodeForces – Sagheer and Crossroads
C Sharp Tricks

C# – CodeForces – Sagheer and Crossroads

Vitosh Jun 5, 2017 Tagged with convert ToList() in one line, Split string

Codeforces.com is the web site, that lets you check your algorithmic skills, in case that you want to see where you are, compared to the world. Thus, today I was checking the problems in the 2. Division and the first …

C# – CodeForces – Sagheer and Crossroads Read more →

Entity Framework – C# – CodeFirst – Video
EntityFramework

Entity Framework – C# – CodeFirst – Video

Vitosh May 27, 2017 Tagged with C#, codefirst, Entity Framework

After the first two videos for C# Entity Framework (Video 1 and Video 2) I have decided to make a small one for the Code First approach. I have used the materials of SoftUni here, mainly concentrating on problem 3. …

Entity Framework – C# – CodeFirst – Video Read more →

Entity Framework – C# – Introduction – Video – Part 2
EntityFramework

Entity Framework – C# – Introduction – Video – Part 2

Vitosh May 16, 2017 Tagged with C#, Entity Framework, introduction, SoftUni

After the first part of the SoftUni homework for Entity Framework here, I have decided to make a small video with the next 4 problems. Following the same logic, I have made a 30 minute YouTube video with the trial …

Entity Framework – C# – Introduction – Video – Part 2 Read more →

Entity Framework – C# – Introduction – Video
C Sharp Tricks, EntityFramework

Entity Framework – C# – Introduction – Video

Vitosh May 14, 2017 Tagged with C#, EntityFramework, introduction, SoftUni

I have started some time ago to do stuff with Entity Framework (EF) in VitoshAcademy, I even have two articles about it – Beginning with EF and Enable Migrations with EF. I have noticed that the SoftUni is having an EF course, …

Entity Framework – C# – Introduction – Video Read more →

VBA – Knight’s tour algorithm with Excel
VBA \ Excel

VBA – Knight’s tour algorithm with Excel

Vitosh May 8, 2017 Tagged with Algorithms, knight's tour, VBA

Wikipedia says the following for the Knight’s tour : A knight’s tour is a sequence of moves of a knight on a chessboard such that the knight visits every square only once. If the knight ends on a square that is …

VBA – Knight’s tour algorithm with Excel Read more →

.Net Summit – Something interesting in Munich! :)
News

.Net Summit – Something interesting in Munich! :)

Vitosh May 7, 2017 Tagged with dotnet summit

This week was a nice one in a way – no work and just conferencing in Munich! The .Net Summit in Munich has gathered about 40 .Net professionals and “meine wenigkeit” was one of them. Thus, I have participated in …

.Net Summit – Something interesting in Munich! 🙂 Read more →

CodeForces – Problem 798B – Mike and strings
C Sharp Tricks

CodeForces – Problem 798B – Mike and strings

Vitosh May 2, 2017 Tagged with C#, codefoces

Solving problems in CodeForces usually never works out as expected somehow – if I tend to overestimate the problem, I am able to solve it within 10 minutes and if I underestimate it, I stay about 1 hour on a simple …

CodeForces – Problem 798B – Mike and strings Read more →

Codeforces – Problem 798A – Checking the Calendar
C Sharp Tricks, C++

Codeforces – Problem 798A – Checking the Calendar

Vitosh Apr 30, 2017 Tagged with algorithm, C#, codeforces

After reviewing the Meller watch, it’s time for some more IT related stuff in the blog.  Thus, I have decided to do what I usually do when I want to write some article and I do not know what to …

Codeforces – Problem 798A – Checking the Calendar Read more →

Review – Meller Watch
Review

Review – Meller Watch

Vitosh Apr 30, 2017 Tagged with Meller watch, video review

As a blogger I review software and IT books quite a lot. Thus, I have decided to switch a bit to something else. E.g. – reviewing gadgets and anything interesting. 🙂 Thus, the first item I managed to obtain for …

Review – Meller Watch Read more →

VBA vs C++ function – which one is faster in Excel?
C++, VBA \ Excel

VBA vs C++ function – which one is faster in Excel?

Vitosh Apr 25, 2017 Tagged with C#, custom c++ function, Excel, VBA

Comparing the speed of VBA and C++ in general is quite not fair. Its like comparing the speed of a military jet and a Boeing 767. But still, it’s interesting to see how much C++ is faster in Excel’s native …

VBA vs C++ function – which one is faster in Excel? Read more →

C++ – Adding C++ function to VBA/Excel
C++, VBA \ Excel

C++ – Adding C++ function to VBA/Excel

Vitosh Apr 24, 2017 Tagged with C#, dll, Excel, VBA

After adding a c# library to VBA I have decided to take a look how to do a similar trick with C++. C++ is a bit fancier in a way. And it works somehow else. So, let’s start. Imagine that we …

C++ – Adding C++ function to VBA/Excel Read more →

Oasis SVN – Software Review – with Video! :)
Review, VBA \ Excel

Oasis SVN – Software Review – with Video! :)

Vitosh Apr 18, 2017 Tagged with Oasis SVN, VBA

In VitoshAcademy I try to be on the edge of VBA technologies. Unfortunately, this is not that difficult, as far as VBA is really like the hated child of Microsoft – it works quite a lot and it does a pretty …

Oasis SVN – Software Review – with Video! 🙂 Read more →

Book Review – Practical Microsoft Visual Studio 2015
Review

Book Review – Practical Microsoft Visual Studio 2015

Vitosh Apr 16, 2017 Tagged with Peter Ritchie, Practical Microsoft Visual Studio 2015

My friends from Apress.com have provided me again with a great book upon my request! Thus, it is time for the review. In general, I was awaiting 190 page book with Visual Studio shortcuts and quick tricks. Even, I was …

Book Review – Practical Microsoft Visual Studio 2015 Read more →

Review – vbWatchdog – professional error tracking tool
Review, VBA \ Excel

Review – vbWatchdog – professional error tracking tool

Vitosh Apr 9, 2017 Tagged with VBA, vbWatchdog, watchdog

As a VBA Developer, I am always interested in the latest technologies in the VBA world. This is not that difficult, as far as there is not plenty of new stuff there, thus whenever I see something interesting, I try …

Review – vbWatchdog – professional error tracking tool Read more →

News – .Net Summit in Munich with VitoshAcademy
News

News – .Net Summit in Munich with VitoshAcademy

Vitosh Apr 8, 2017

VitoshAcademy is opening new horizons! In the beginning of May, I will go to Munich, to participate in the .Net Summit and just to see where the German .Net professionals stand.  The event is in Munich and is divided into …

News – .Net Summit in Munich with VitoshAcademy Read more →

Posts pagination

Previous 1 2 3 Next

Copyright © 2026 VitoshAcademy