What is the meaning of Tasks and Running in htop screen?

Question

I am trying to concatenate cells through excel VBA. This involves multiple ranges. Below is my table

Degree1
Course1,Course2,Course3
Course4,course5,course6

Degree2
Course1,Course2
Course3,Course4
Course5
Course6,Course7

Degree3
Course1,Course2,Course3
Course4,course5,course6
Course7

I want to concatenate all the courses listed below a degree into a single cell next to the degree. Each degree has multiple courses & the # of rows differ for each degree.

I am using excel find function to identify the cell contains the degree & select the courses below it. I am also using the concat function from http://www.contextures.com/rickrothsteinexcelvbatext.html so that I can concatenate the selected ranges.

I tried to write the below code but this is not working, I am getting value error in the end. I guess the range is not stored in the variable

Sub concatrange()

Dim D1Crng As Range         'to set courses under degree1 as range
Dim D2Crng As Range     
Dim D3Crng As Range     
Dim D1cell As Range     'to identify the cell of D1 and set it as range
Dim D2cell As Range
Dim D3cell As Range

Range("A1:B100").Select
Selection.Find(What:="Degree1", _
LookIn:=xlValues, LookAt:=xlPart, _
 SearchOrder:=xlByColumns, SearchDirection:=xlNext, _
 MatchCase:=False, SearchFormat:=False).Select
 ActiveCell.Select
 Set D1cell = Selection

Range(D1cell).Activate
ActiveCell.Offset(1, 0).End(xlDown).Select
Set D1Crng = Selection

Range(D1cell).Activate
ActiveCell.Offset(0, 1).Select
Selection.Formula = "=concat("","",D1Crng)"

End sub

I am repeating the above process for concatenating for other degrees.

Solution

Tasks do represent the number of opened processes. (Note that I do not use the term "running" to avoid confusion.)

You have to realize that not all opened processes consume CPU constantly.

Each process can be in a number of different states:

• running: actively using CPU
• stopped: the process was stopped (paused) by the user
• defunc or zombie: process is actually blocking on an external resource, commonly a disk drive
• sleeping: most common state as many processes actually sleep a lot of the time and do small checks at different intervals, or wait for user input

Comments

[Vidya Sahar]

Thanks so much! Jeeped. Your code works flawlessly & saved me a lot of time.

[Julie Pelletier]

htop does an average which is how it shows a percentage of CPU usage. Processes do not necessarily consume 100% of a CPU (or core). This is managed by a scheduler within the kernel, one of the most complex parts of the kernel actually. It ensures that all processes get a share of the CPU according to their priority compared to other processes.

[Julie Pelletier]

If your server's load goes beyond 2 * numberOfCores, it most likely will become very unresponsive. This is the kind of thing a good system admin will monitor. The number of running processes is not that useful.