teleren/devto huggingface dataset:
Wednesday Links - Edition 2020-10-28 ⚡
Tags: java, spring, kotlin, lombok
Published: 2020-10-28 08:20:18

Chaos engineering (4 min) 👺
https://256.nurkiewicz.com/20

Falsehoods programmers believe about time zones ( 9 min read) 🕰️
https://www.zainrizvi.io/blog/falsehoods-programmers-believe-about-time-zones/

Class Unloading in Layered Java Applications ( 10 min read) 🍰
https://www.morling.dev/blog/class-unloading-in-layered-java-applications/

Fit URLs (4 min read) 🧗
https://blog.ploeh.dk/2020/10/26/fit-urls/

jMolecules – Architectural abstractions for Java (3 min read) 🧬
https://github.com/xmolecules/jmolecules

Maven Daemon powered by GraalVM (2 min read) 😈
https://github.com/mvndaemon/mvnd

Spring Framework 5.3 goes GA (1 min read) 🎉
https://spring.io/blog/2020/10/27/spring-framework-5-3-goes-ga

Lombok plugin is now bundled with IntelliJ IDEA  (20 sec read) 📚
https://youtrack.jetbrains.com/issue/IDEA-26296#focus=Comments-27-4468690.0-0

From Kotlin 1.4 standard library is added by default in each source set (20 sec read) 📚
https://twitter.com/kotlin/status/1321047218636443648

IntelliJ IDEA 2020.3 EAP5 (6 min read) 🎉
https://blog.jetbrains.com/idea/2020/10/intellij-idea-2020-3-eap5/

Update on the state of Java modularization (3 min read) 🧩
https://blog.frankel.ch/update-state-java-modularization/
[VIDEO] How to Host Multiple Docker Containers on a Single Server with Nginx Reverse Proxy?
Tags: docker, linux, ubuntu, devops
Published: 2020-10-28 09:06:06

Recently I had to setup a few small Docker containers for a couple of small websites.

As the sites were really small I didn’t want to run each one on a separate Droplet, so instead, I used Nginx with separate Nginx server blocks for each site and a reverse proxy for each Docker container.

Here’s how I set that up:

{%youtube spbkCihFpQ8%}

Post: [How to Host Multiple Docker Containers on a Single Droplet with Nginx Reverse Proxy?
](https://www.digitalocean.com/community/questions/how-to-host-multiple-docker-containers-on-a-single-droplet-with-nginx-reverse-proxy)
Java/ Wrapping Text Around Image in Word Document
Tags: java, wraptext
Published: 2020-10-28 09:01:47

When inserting an image to a Word document, choosing a reasonable wrapping style can not only make the display of text and image more coordinated, but also make the page layout more beautiful. This article will introduce how to wrap text around image in Word document by using Free Spire.Doc for Java.

**Installation**
**Method 1:** Download the [Free Spire.Doc for Java](https://www.e-iceblue.com/Download/doc-for-java-free.html) and unzip it. Then add the Spire.Doc.jar file to your Java application as dependency.

**Method 2:** You can also add the jar dependency to maven project by adding the following configurations to the pom.xml.

```xml
<repositories>
   <repository>
      <id>com.e-iceblue</id>
      <name>e-iceblue</name>
      <url>http://repo.e-iceblue.com/nexus/content/groups/public/</url>
   </repository>
</repositories>
<dependencies>
   <dependency>
      <groupId>e-iceblue</groupId>
      <artifactId>spire.doc.free</artifactId>
      <version>3.9.0</version>
   </dependency>
</dependencies>
```

**Java Code**

```java
import com.spire.doc.*;
import com.spire.doc.documents.Paragraph;
import com.spire.doc.documents.TextWrappingStyle;
import com.spire.doc.documents.TextWrappingType;
import com.spire.doc.fields.DocPicture;

public class ImageWrappingStyle {
    public static void main(String[] args) throws Exception {
        //Load the sample document
        Document doc = new Document();
        doc.loadFromFile("Herman.docx");

        //Add an image
        Section sec = doc.getSections().get(0);
        Paragraph para = sec.getParagraphs().get(0);
        DocPicture picture = para.appendPicture("C:\\Users\\Administrator\\Desktop\\Herman.jpg");

        //Set image width and height
        picture.setWidth(150f);
        picture.setHeight(125f);

        //Set text wrapping style to Square
        picture.setTextWrappingStyle(TextWrappingStyle.Square);
        picture.setTextWrappingType(TextWrappingType.Both);

        //Save the document to file
        doc.saveToFile("WrapStyle.docx");
        doc.close();

    }
}
```

**Output**
![](https://dev-to-uploads.s3.amazonaws.com/i/q0c4t633pldj8vkb0ir8.png)
Deployed smartcontract on XDC Network
Tags: blockchain
Published: 2020-10-28 08:50:26

Hello all my Dev friends, Check my new #Smartcontract that I have deployed today on #XinFin #XDC Network.
https://explorer.xinfin.network/tx/0x83fb1845cf4c18f632f0dc02262b33eaf0109ddc6d60f81196286d28365de006
Do you use any antivirus, anti-malware software?
Tags: security, software, watercooler
Published: 2020-10-28 08:38:49

---
title: Do you use any antivirus, anti-malware software?
published: true
description: 
tags: security, software, watercooler
cover_image: https://www.safetydetectives.com/wp-content/uploads/2020/06/10-Best-Antivirus-in-2020-Windows-Android-iOS-Mac-672x354.jpg
---
I have [AVG](https://avg.com/en-us/free-antivirus-download) and [Malwarebytes](https://www.malwarebytes.com/) installed from ages ago, tho I rarely run them. They have become bloated since I installed them and nowadays are often pushed via other software set-up wizards.

Furthermore, I have no idea how effective the scanning of free versions even is, and is it worth keeping them around.

Do you use any antivirus, anti-malware software these days and, if so, what would you recommend from personal experience?
Just refactor-ed. Study week fun & updates. Final week of Hacktober
Tags: opensource
Published: 2020-10-28 07:50:51

Well, well, well. Yep, I am back with a very late update on my journey to real world development. Where was I? I was away for a while, focused in my own health for a week. Last month and the current month was pretty heavy. Had bunch of doctors appointment and tests, so took a time off the internet. Anyways, back to my update on open source.

I just did a refactoring and rebasing on my GitHub. I am so hyped cause I just learned a very interesting way to merge the commits. This will be very helpful for people who commits daily onto GitHub and pushes at the end of the day. That way, refactoring can make everything in 1 commit. When refactoring, it take you to VI Editor. As a developer, there's not a single person who doesn't like Linux's VI Editor. Had lots of fun refactoring, and I am pretty positive that I'll be refactoring my commits very often.

Hacktober, final week. I have yet to do my PR 3 and PR4. I know I am pretty late, but don't worry, I have plans to finish everything related to Release 0.2 by 3 days from today. OI will be uploading a blog post regarding my 2nd PR very soon, as well as my 3rd PR. But, for the 4th PR, I will upload a post on the entirety of the month October and my opinions on Hacktober. So, be sure to check it out when uploaded.


Study week updates. I started this study week by watching a TV Karama. I agree, I have been watching em very of often nowadays, mainly because this week is study week. I plan on finishing up extra work that we will have after study week, so going to be very busy before class starts again from break. 

Anyways, this is all I have today regarding refactoring and updates. 

Links - 
[Commit (rebased)](https://github.com/Niaz-Ul-Haque/nlinks/commit/9fd631dfbe036b68843b9575afa3582c230191ca)
[Link to my CLI](https://github.com/Niaz-Ul-Haque/nlinks)
Learn Quran ONline
Published: 2020-10-28 08:37:13

Livequranforkids
We are providing the educational service of Learn Quran Online, 
female quran teacher,quran for kids, quran reading, 
quran memorization for kids, quran translation,online quran,  
quran for kids in USA, quran online and Online quran academy.

Learn Quran Online With Tajweed With Expert Tutors

https://livequranforkids.com
https://autoinsurancepk.com
Formulas to Count Cells Equal to One Of Many Values in Excel!!
Tags: excelformula, excelformulas
Published: 2020-10-28 12:19:49

---
title: Formulas to Count Cells Equal to One Of Many Values in Excel!!
published: true
date: 2020-10-28 07:57:55 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/formulas-to-count-cells-equal-to-one-of-many-values-in-excel/
---

In this short tutorial, we will discuss the **Formulas to count the cells equal to one of many values in Excel 365** with a brief explanation. Let’s get started!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[!["Formulas](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/main-image-2.png)](https://geekexcel.com/?attachment_id=16383#main)<figcaption id="caption-attachment-16383">Formulas to Count Cells Equal to One Of Many Values</figcaption>

## General Formula:

- The below formula will help you to count the cells which are equal to one of many values in Excel.

**=[SUMPRODUCT](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/)(COUNTIF(range,things))**

## Syntax Explanations:

- **SUMPRODUCT** – In Excel, this function can multiply the selected arrays or ranges and returns the sum of the products. Read more on [**SUMPRODUCT Function**](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/).
- **COUNTIF** – The COUNTIF Function will help to count the cells that match a single condition or criteria.
- **Range ** – It represents the input values of the cell.
- **Things** – This represents the values to be count.
- **Comma (,)** – It is a separator which helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Example:

- In the below image, we enter the inputs in **Column A**.
- Then, enter the given formula in the **formula bar**.
- After applying the formula it will display the results in **Cell D2** as shown below.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Example-33.png)  
Example

- Follow the above steps to count the cells which contain one or more values in Excel.

## Wind-Up:

In this tutorial, you can learn the simple and easy **formulas to count the cells equal to many values in Excel Office 365** with a suitable Example. If you have any **suggestions,** don’t forget to drop it in the below comment section. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!!**

### Read Also:

- **[Formulas to Count Cells Contains Equal Values or Numbers in Excel!!](https://geekexcel.com/wp-admin/post.php?post=16324&action=edit)**
- **[Formulas for Counting the Cells between Two Numbers in Excel!!](https://geekexcel.com/wp-admin/post.php?post=16304&action=edit)**
Ch solution to a currency problem
Tags: css, inputwithicon, chunits
Published: 2020-10-28 08:19:16

Having icons inside an input control is a very common behaviour. Classic use cases of search control with magnifier icon or password control with eye-icon (reveal/show password) or currency control with leading/trailing symbols or texts like dollar/pounds/INR are pretty common use cases. Most of these designs are achieved through any of the below approaches:
1. Using positions (relative position parent, absolute position prefix/suffix). 
2. Using negative margins for suffix/prefix
3. Directly squeezing in the prefix/suffix/text input in a wrapper element and removing the default border for text input and handling border/focus states through the wrapper element.

Now except with approach #3, we have one common problem with approach #1 and approach #2, "How do we make sure text inside input is not spilt over to prefix/suffix?". Oh that's simple, give padding (left/right) to the text input. Nope, in most cases, this is as straight forward as you thought but what if my prefix/suffix are dynamic values, beforehand I am not sure what sort of symbol or text I get, this info we get only during runtime. 
For such issues, we have "ch" units to our rescue. Please find the below code pen snippet describing the approach #1 and #3 and elaborating on props & cons with them. 
Code pen link: https://codepen.io/Raghavan/pen/Exybjev 
Please comment below if you think of any downsides with this approach of using ch units and do follow me here for more updates or notifications related to CSS primarily and sometimes with React :)
Do you remember your first DIY project created with STM32 Blue Pill Board?
Tags: opensource, discuss
Published: 2020-10-28 08:10:03

Do you remember your first DIY project created with STM32 Blue Pill Board?


Following this YouTube video to DIY a project of STM32 BluePill Board with OpenSource RT-Thread and contribute to the RT-Thread opensource community can win a well-prepared community gift❤️

https://youtu.be/0PwBBYXQ08g

**RT-Thread Contact Info:**

 [Website](https://www.rt-thread.io/)  |  [Github](https://github.com/RT-Thread)  | [Twitter](https://twitter.com/rt_thread) |  [Facebook](https://www.facebook.com/RT-Thread-IoT-OS-110395723808463)   |   [Youtube](https://www.youtube.com/channel/UCdDHtIfSYPq4002r27ffqPw
)
Spootify. The latest reactJS coding challenge in react-coding-challenges on GitHub.
Tags: react, challenge, github, javascript
Published: 2020-10-28 07:58:27

Hello! My name's Alex and I built the react-coding-challenges collection on GitHub. Find them [here](https://github.com/alexgurr/react-coding-challenges).

**So what are the coding challenges?** They are a series of small incomplete React apps you can use to test yourself in a variety of ways, or for example, as small code challenges for interview candidates. Get more information and deep dive in this [dev post](https://dev.to/alexgurr/react-coding-challenges-for-interviews-beginners-1hlk).

Today I'm excited to announce the latest challenge, **Spootify**. A basic Spotify clone, designed to test you around **API consumption and loading state**. Check it specifically out [here](https://github.com/alexgurr/react-coding-challenges/tree/master/spootify) or head over to the main code challenges repository. All UI/UX was done by me from scratch.

If you need access to the coding solutions, you can get an invite [here](https://www.solutions.alexgurr.com/).

![screenshot](https://puu.sh/GwPLE/3be580156a.png)
Color palette from Images
Tags: design, php, javascript, image
Published: 2020-10-28 07:55:37

Generate a color palette from image. Color palette based on the image's primary colors or mannually select colors from image. Upload an image to generate a color palette based on the image's primary colors. Useful for quickly grabbing a particular color within an image for inspiration.

##Image to Colors Palette Generator
This simple color palette generator extracts colors from any photo or file on upload. Then just copy the HEX codes from the color palette app with a simple click! [Color palette from image generator](https://hexcolor.co/image-to-colors) tool will extract the most dominant color of image with 2% tolerance level of neighbour colors. Once extracted, tool will list the dominant colors in palette until reaches the maximum number of color defined by the user.

**https://hexcolor.co/image-to-colors**
Formulas for Counting the Cells Greater than a Given Values in Excel!!
Tags: excelformula, excelformulas
Published: 2020-10-28 12:19:59

---
title: Formulas for Counting the Cells Greater than a Given Values in Excel!!
published: true
date: 2020-10-28 07:54:43 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/formulas-for-counting-the-cells-greater-than-a-given-values-in-excel/
---

This page will show the **Formulas for Counting the cells Contains Greater than a Given Values in Excel Office 365** with the best example. Let’s get into this article!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Formulas to count cells greater than a given value](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Formulas-to-count-cells-greater-than-a-given-value.png)](https://geekexcel.com/formulas-for-counting-the-cells-greater-than-a-given-values-in-excel/formulas-to-count-cells-greater-than-a-given-value/#main)<figcaption id="caption-attachment-16406">Formulas to count cells greater than a given value</figcaption>
## General Formula:

- To count the number of cells that contain values greater than a particular number in Excel, use the below formula.

**=COUNTIF(range,”>X”)**

## Syntax Explanations:

- **COUNTIF** – The Excel COUNTIF Function will help to count the cells that match a single condition or criteria.
- **Range** – It represents input values given in the cells.
- **Operator (>) **– This operator symbol will perform the greater than some value. If you count the cell which is greater than or equal to the given value, use the **(>=)** symbol.
- **X ** – It is a value you want to be count.
- **Comma (,)** – It is a separator which helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Example:

- Let’s consider the below image to count the cells that have values greater than a given number.
- First, you need to enter the inputs.
- After that, apply the given formula in the selected formula area.
- Then, it will display the results as shown below.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Example-34.png)<figcaption id="caption-attachment-16405">Example</figcaption>

## Closure:

From this article, we explained the **formulas to count the cells that have values greater than a given number in Excel Office 365** with a suitable example. Hope that this article is useful to you. If you have any **doubts** , feel free to share it with us. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!!**

### Read Also:

- [Formulas to Count Cells Contains Equal Values or Numbers in Excel!!](https://geekexcel.com/wp-admin/post.php?post=16324&action=edit)
- [Formulas for Counting the Cells between Two Numbers in Excel!!](https://geekexcel.com/wp-admin/post.php?post=16304&action=edit)
Excel Formulas to Count the Cells Less than a Given Number!!
Tags: excelformula, excelformulas
Published: 2020-10-28 12:20:23

---
title: Excel Formulas to Count the Cells Less than a Given Number!!
published: true
date: 2020-10-28 07:49:33 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-count-the-cells-less-than-a-given-number/
---

In this article, we will see the **Formulas to Count the cells Contains Less than a Given Values in Excel Office 365** with its brief explanations and example. Let’s get into this article!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Formulas to count cells contains less than a particular value](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Formulas-to-count-cells-contains-less-than-a-particular-value.png)](https://geekexcel.com/excel-formulas-to-count-the-cells-less-than-a-given-number/formulas-to-count-cells-contains-less-than-a-particular-value/#main)<figcaption id="caption-attachment-16419">Formulas to count cells contain less than a particular value</figcaption>
## General Formula:

- To count the number of cells that have values less than a given number in Excel, use the below formula.

**=COUNTIF(range,”<X”)**

## Explanations for Syntax:

- **COUNTIF** – In Excel, COUNTIF Function will help to count the cells that match a single condition or criteria.
- **Operator (<)** – This operator symbol will count less than a particular value. If you count the cell which is less than or equal to the given value, use the **(<=)** symbol.
- **Range** – It represents input numbers given in the workbook.
- **X ** – It is a value you want to be count.
- **Comma (,)** – It is a separator which helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Example:

- In the below screenshot, we entered the input ages in **Column A**.
- After that, apply the given formula in the **formula bar** section.
- Finally, it will show the result as shown below.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Example-35.png)<figcaption id="caption-attachment-16418">Example</figcaption>

- Use the above steps, for counting the cells which contain less than a given number in Excel.

## Conclusion:

From this article, you can know **formulas to count the cells that contain values less than a given number in Excel Office 365** with a suitable example. Hope that this article is useful to you. If you have any **queries** , kindly drop it in the comment box. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!!**

### Read Ahead:

- **[Formulas to Count Cells Contains Equal Values or Numbers in Excel!!](https://geekexcel.com/wp-admin/post.php?post=16324&action=edit)**
- **[Formulas for Counting the Times a Word Appears in a Cell in Excel!!](https://geekexcel.com/wp-admin/post.php?post=16248&action=edit)**
TCS Quick Shots
Tags: tutorial, python, showdev, quickshots
Published: 2020-10-28 07:34:33

For the last couple of days, I am observing the question pattern in TCS. I would like to share some tricks and tips to crack the question in less time.

` I hereby declare that these shots are only helpful for some type of questions in the Exam. `

As of now ` Quick Shots ` are available in only Python Programming Language.

### Good to Know

```python
### Quick Inputs
name = raw_input() # for Strings
number = int(input()) # for Integers
```

### Yes or No Questions

```python
def yes_or_no():
    reply = str(raw_input('(y/n):')).lower().strip()
    if reply[0] == 'y':
        return True
    if reply[0] == 'n':
        return False
    else:
        return None

isMember = yes_or_no()

if(isMember == None): 
    print("Invalid Input")
```

### Accepting Values in Same line (with Spaces)

```python
values = [int(x) for x in raw_input().split()]
print(values)

# input: 1 2 3 4
# output: [1, 2, 3, 4]
```

### Accepting Values in Same line (with Commas)

```python
values = [int(x) for x in raw_input().split(', ')]
print(values)

# input: 1, 2, 3, 4
# output: [1, 2, 3, 4]
```

### Percentage Questions

```python
# 85% of 2043.43

def percentage(part, whole):
    return (part * whole)/100

print(percentage(85,2043.43))

# output: 1736.9155
```

### Invalid Input
```text
INVALID INPUT
Note: Input and Output should be formatted as given for the example.
For any wrong value input display “INVALID INPUT”
```

```python
def inv():
    print("INVALID INPUT")

inv() 

# This helps you in code reusability 
# avoid this if have one possibility
```

### Float decimal value after a point

```python
value = 3282.2548

print("%.f"%value) # 3282
print("%.1f"%value) # 3282.3
print("%.2f"%value) # 3282.25
```



**Stay Tuned**

If you like to improve your App Development Skills, even more in Flutter and SwiftUI. Feel free to dm me on [Instagram](https://www.instagram.com/irangareddy/) or tweet to me on [Twitter](https://twitter.com/irangareddy) if you have any additional tips or feedback.

Thanks for reading!