teleren/devto huggingface dataset:
Divtober Day 23: Loud
Tags: codepen, divtober, css, art
Published: 2021-10-23 19:00:51

---
title: Divtober Day 23: Loud
description: My entry for divtober day 23: loud. A volume knob that goes up to 11.
published: true
tags: codepen,divtober,css,art
series: divtober
cover_image: https://dev-to-uploads.s3.amazonaws.com/uploads/articles/o5dmgzegz7joahl0iu69.png
---

The word of the day for divtober is "loud." This required a demo with that extra push over the cliff, so I brought it up "one louder" to 11 with this volume knob:

{% codepen https://codepen.io/alvaromontoro/pen/BadpNdN %}

It was developed using an input range as a base, so it is a bit interactive (but results may vary).

Firefox doesn't support pseudo-elements in inputs, so it will miss the "volume" label. It could be fixed by avoiding the pseudo-elements and making the input larger and using radial-gradients instead of box-shadows.
8 Dicas para facilitar o onboarding Dev em projetos
Tags: onboarding, beginners, programming, softskills
Published: 2021-10-23 18:31:18

Onboarding em inglês é embarcar,  então essas dicas são especialmente para os desenvolvedores que estão embarcando em um novo projeto de software. O objetivo é facilitar a etapa inicial nos projetos, quando você ainda não conhece nada sobre o projeto.

**Essas dicas podem te ajudar a fazer essa transição ser mais rápida e menos sofrida:**

**1** Entenda de forma ampla o negócio associado ao projeto. Depois, entenda questões mais estratégicas. No onboarding é suficiente entender o macro, pois em alguns projetos pode levar muito tempo entender todas as regras de negócio implementadas.

**2** Identifique todas as ferramentas que são utilizadas pelo time, e solicite acesso. Entenda quais fazem mais diferença para o seu trabalho.

**3** Entenda a responsabilidade de cada pessoa do time, isso faz diferença para resolver os problemas com a pessoa certa.

**4** Entenda quem pode ser a pessoa que te ajudaria com dúvidas cotidianas, por exemplo, quem te falaria qual é o canal certo para pedir um mouse novo.

**5** Marque um meeting com o propósito de entender a arquitetura do projeto. Nesse meeting pergunte todas as dúvidas, até as mais simples podem mostrar que uma decisão fora do óbvio foi tomada, e influenciar na implementação das tarefas do projeto.

**6** Solicite que as pessoas te informem os canais mais importantes, ou que te enviem o documento principal da empresa, onde estão as definições de projeto. 

**7** Combine e identifique:  
 
* Padrão para criação de branch. Ou seja, como devem ser os nomes de branch.
* Padrão de comentário de commit.
* Padrão de criação de PR.
* Utilização de lint, e padrões de escrita.
* Branch base para desenvolvimento (preferencialmente develop).

**8** Tenha paciência. Entender todo o projeto pode levar muito tempo, e dependendo da complexidade, talvez você nunca entenda todas as regras de negócio.  🤗

O processo de onboarding é super importante para a produtividade e adaptação de novos devs no time. Espero que essas dicas contribuam pra o teu processo :)

Curtiu? Tem mais dicas? Comenta aqui :)
6 Boas práticas para utilizar no code review 
Tags: codereview, beginners, programming, review
Published: 2021-10-23 18:23:48

O processo de code review é muito realizado em projetos de software que possuem uma estrutura mínima de qualidade. Esse procedimento consiste em, após uma pessoa desenvolvedora terminar uma tarefa e gerar um pull request (PR), outra pessoa desenvolvedora analisará e indicará melhorias para esse código.

Assim, as pessoas desenvolvedoras atuam na melhoria do código do time, aumentando o nível de qualidade do código e evitando possíveis bugs. Além disso, contribuindo para o aperfeiçoamento das habilidades técnicas e nivelando o time.

6 Boas práticas para executar no code review
1. Use emoticons apenas para demonstrar aprovação, por exemplo 👍🏽 , ✅, 🚀, 😊.

2. Não refatore o PR de outra pessoa sem que ela saiba. Caso sejam necessárias muitas modificações, realize comentários. Refatorar sem informar, retira a oportunidade de aprendizado da pessoa desenvolvedora.

3. Prefira explicar suas sugestões com pequenos pedaços de código ou links que direcionem a pessoa desenvolvedora.

4. Sempre que possível responda os comentários no PR. Habilitar a configuração para enviar alerta de novos comentários para o seu e-mail, pode ser uma ótima prática.

5. Prefira usar linguagem sugestiva à imperativa. Outra boa opção, é utilizar perguntas, por exemplo:

Exemplo 1

❌ ” Ficou ruim ”

✔️ ” É uma ótima prática utilizar nomes mais descritivos. Sugestão: isFlowStateFinished”.

Exemplo 2

❌ ” Nada disso ficou bom”

✔️ ” É mais interessante utilizarmos o padrão do MVC. Você consegue perceber as melhorias associadas? Podemos conversar melhor sobre 😄 ”.

Exemplo 3

❌ ” Esse for está com uma performance ruim”

✔️ ” Utilizar um find() poderia gerar uma performance melhor nesse trecho de código”.

6. Em PRs maiores ou mais difíceis dê parabéns, ou envie uma mensagem positiva, na aprovação do PR. Trabalhar com desenvolvimento normalmente não é fácil, o incentivo dos colegas é uma prática bem positiva. Apesar de parecer simples, essa prática ajuda na manutenção da cultura e clima.

Curtiu as dicas? 

Comenta aqui se você utiliza outras práticas interessantes no code review 😄
Excel Formulas to Check Multiple Cells have Same Value!!
Tags: excelformula, excelformulas
Published: 2021-10-25 13:15:21

---
title: Excel Formulas to Check Multiple Cells have Same Value!!
published: true
date: 2021-10-23 17:27:16 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-check-multiple-cells-have-same-value/
---

If you have a large data in your Excel spreadsheet and want to check if multiple cells have the same values, then we will assist you. In this article, we are going to see how to use **Excel formulas to check multiple cells have the same value in Excel Office 365**.

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)

## Generic Formula:

- Use this formula to check multiple cells have the same value in Excel 365.

**=COUNTIF(rng,”<>value”)=0**

## Syntax Definition:

- **COUNTIF** – This function counts the number of cells in a range that meets a given criterion.
- **rng** – It represents the input range.
- **value** – This is the value that you want to check on the given range.
- **Parenthesis ()** – The purpose of this symbol is to group the elements.

## Practical Example:

Use the following steps to check multiple cells have the same value in Excel.

- In the following example, you will see the input **ranges A** from **C3:C7** and **range B** from **D3:D7**.
- Now, **select a cell** where you want to place the result. Here, we selected two cells to get the output values such as **C8** and **D8**.
- **Apply the above-given formula** to get the result.
- **Hit** the **Enter** key to get the result as shown below.

## Summary:

In the above article, you can easily understand the simple steps to **check multiple cells have the same value in Excel Office 365** using formulas. Leave your **worthwhile feedback** in the below comment section.

Thanks for visiting **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

**Read Ahead:**

- [Excel Formulas to Find the First Row Number ~ Useful Tutorial!](https://geekexcel.com/excel-formulas-to-find-first-row-number/)
- [Excel Formulas to Find the Last Column Number in a Range ~ Quickly!!](https://geekexcel.com/excel-formulas-to-find-last-column-number/)
- [How to Count Variable Range with COUNTIFS Function?](https://geekexcel.com/excel-formulas-to-count-variable-range-with-countifs-function/)
- [Excel Formulas to Randomly Assign Data to Groups ~ Easy Tricks!!](https://geekexcel.com/excel-formulas-to-randomly-assign-data-to-groups/)

**Video Tutorial:**
Javascript 'For Loops'
Tags: javascript, beginners, codenewbie, tutorial
Published: 2021-10-23 17:18:16

What is the purpose of a 'for loop' in JavaScript? Its purpose is that it executes a block (of code) as long as its condition is met/returns 'true'. Conversely, if the the block is executed and the condition isn't met/returns 'false', the loop will stop. 

'For loops' have three arguments:

Initialization - this declares a counter variable

Condition - a condition is evaluated before each loop begins to see if it returns 'true'

Increment - this updates the loop counter each time the loop executes.

These 'for loops' are great for repetitive tasks. With each iteration of the loop, it runs the same block of code with a different value (the incremental aspect). Here is an example of a 'for loop':

for (let number = 0; number <= 12; number = number + 2) {
console.log(number);
}
// 0
// 2
// 4
// 6
// 8
// 10
// 12
(and it stops here)

Happy Coding!
MongoDB for arm64 at Alibaba Cloud
Tags: alibaba, aliyun, mongodb, arm64
Published: 2021-10-23 17:09:25

**WHAT?**

A brief article explaining how to install MongoDB at an Anolis Linux instance and the cool new arm64 CPU from Ampere Computing at Alibaba Cloud

**WHY?**

Because AWS is not the only cloud out there and also because ARM64 instances are cheaper than the old buddy Intel chips.

**HOW?**

Just download the MongoDB server version 5 from https://www.mongodb.com/try/download/community choosing Amazon Linux 2 ARM64 (Amazon Linux and Anolis Linux are very similar, both based on CentOS Linux).

Once you download the RPM package file for MongoDB server run these commands:

```bash
yum install compat-openssl10.aarch64
rpm -hiv --nodeps mongodb-org-server-5.0.3-1.amzn2.aarch64.rpm
```

NOTE: the option `nodeps` is required to use the openssl library compat at Anolis Linux
Windows 11 Windows subsystem for android(WSA) Yükleme
Tags: wsa, windows11
Published: 2021-10-23 16:58:33

# Microsoft Dışından indirme
> Beta'da olduğu için ve şuan bunu yazarken sadece US'ta izin verildiğinden amazon store maalesef kullanamıyoruz ve direkt olarak microsoft store üzerinden indiremiyoruz.
> NOT
> "Sanal Makine Platform" Özelliği Aktif Olması Gereklidir.
> Windows Terminalizi Yönetici Olarak Çalıştırın
> ```
> dism.exe /online /enable-feature /featurename:VirtualMachinePlatform /all /norestart
> ```
## İndirme
ilk önce https://store.rg-adguard.net/ bağlantılı sayfaya gidiyoruz ve birkaç adımı yapıyoruz.

1. İlk Button "URL (Link)" Olarak seçiniz.
2. URL olarak yazılması gereken yere "https://www.microsoft.com/store/productId/9P3395VX91NR" yazınız.
3. Varsayınal "RP" Seçili olan button "Retail" olarak seçiniz.
4. Tik işaretine basın ve aratın.

Aşağıdaki görsel gibi olması gerekiyor
![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/vnn47ttk8xbd6wcancln.png)
 

"MicrosoftCorporationII.WindowsSubsystemForAndroid_1.7.32815.0_neutral_~_8wekyb3d8bbwe.msixbundle" adlı dosyayı bulunuz
> NOT: Siz bu rehbere baktığınızda yeni bir sürüm çıkabilir o yüzden 1,3 GB+ olmasına dikkat ederek daha rahat bulabilirsiniz sonu ".msixbundle" ile bitmesinede dikkat edin

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/92ih2ply5nzmvzf8ndxt.png)
 

## Artık Yükleme Zamanı

Windows Terminali yönetici olarak başlatın. Windows Powershell seçin.
> Powershell 7 seçerseniz ilk önce 
> ```
> Import-Module -Name Appx -UseWIndowsPowershell
> ```

msixbundle dosyasını indirdiğiniz konuma gidin. 
Ben masaüstüne indirdiğinizi varsayarak ilerlicem.

```
cd .\Desktop\
```

> tab tuşuna basarsanız size kelime tamamlamada yardım edecektir.

msixbundle dosyamızı sisteme yükleme zamanı
```
add-appxpackage .\NAMEOFFILE.Msixbundle
```

> tab tuşuna basarsanız size kelime tamamlamada yardım edecektir.

ve işlem bu kadar!
YAGNI: Solucionando um problema na implantação de pequenas funcionalidades
Tags: yagni, programming, principles
Published: 2021-10-23 16:52:24

O YAGNI (junto ao [KISS](https://www.interaction-design.org/literature/topics/keep-it-simple-stupid#:~:text=Keep%20it%20simple%2C%20stupid%20(KISS)%20is%20a%20design%20principle,of%20user%20acceptance%20and%20interaction.) e ao [DRY](https://en.m.wikipedia.org/wiki/Don%27t_repeat_yourself#:~:text=The%20DRY%20principle%20is%20stated,authoritative%20representation%20within%20a%20system%22.&text=When%20the%20DRY%20principle%20is,in%20other%20logically%20unrelated%20elements.)) é um princípio base muito importante na vida de um desenvolvedor. O conceito que explica o YAGNI, diz que devemos isolar as etapas da nossa aplicação em funcionalidades que realizem o seu objetivo da forma mais simples e direta possível, evitando criar coisas desnecessárias que fujam do escopo inicial.
Vou dar um exemplo do mundo real, que é um aprendizado da minha carreira - motivo desse post - e que envolve projeto de software. Eu estava trabalhando em uma nova funcionalidade, e essa funcionalidade havia sido dividida e isolada em unidades menores que chamamos de histórias. Cada história contava uma etapa do processo, e os requisitos de completude. Por esse meio, nós temos uma noção do ponto de partida, as tecnologias necessárias, e o produto mínimo e viável para implantar a história.
De início, o desenvolvimento parecia constante e equilibrado, focado na solução. Mas decidimos dividir a equipe em outras histórias, e eu me perdi no desenvolvimento. Como a equipe estava dividida, quando precisamos implantar a história (e ela apresentava problemas) passamos a unir outras funcionalidades nela, aumentando o escopo e gerando mais bugs que atrasaram a nossa entrega.
Mas o que isso tem relação com o YAGNI? Tudo! Deixamos de focar no mínimo, quando tentamos adicionar mais código para corrigir os problemas. E o produto deixou de ser viável pois apresentou mais problemas do que funcionamento. Tornamos o desenvolvimento complexo, como que na tentativa de matar uma barata com um míssil.
Em resumo desse artigo, estou escrevendo para que eu mesmo não me esqueça de que é preciso focar, no desenvolvimento, naquilo que é mais importante para entregar a funcionalidade sempre considerando que o produto é incremental e sua evolução é contínua.
3 skills every programmer should have
Tags: beginners, programming, tutorial, codenewbie
Published: 2021-10-23 16:52:17

Programming can sometimes be really difficult but there are some skills that make it easier.

Here are some of the skills a good programmer should have:

## 1. How to Google

![programming](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/rodffm7ex4b5f122dtal.jpg)

This is something every good programmer do. It may sound really simple but the truth is, its not. Not at all.

If you have some experience developing applications, then you must have been in a situation where you can't seem to find the solutions you are looking for online. You can be stuck for days.

Believe it or not, it's not possible to have every code you need in your head. If it was possible, then technologies wouldn't need a detailed documentation and people wouldn't need to write blog posts.

We are all human and are bound to forget whatever we do not use frequently. Not just code.

No programmer knows everything and no programmer will be able to. You can only learn and understand the concepts and whenever you need to add something you're not familiar with, you can just look it up.

As time go by, you'd become better at googling and building applications faster.

## 2. How to read code

![programming](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ezmuukwsqlvlrnzysano.jpg)

This is another thing that every programmer must learn how to do.

From building a new application to learning how to use a new feature, you're going to come across pieces of code you need to understand, and having the ability to conveniently read code is going to make your life a lot easier.

Though this is not a skill you can develop overnight, it comes with time.

Learning how to read code is going to make you faster at coding, debugging and writing clean and more efficient code.

## 3. Patience

![programmer](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/m768j70n3he4lk8byf1h.jpg)

Like it's said, "Patience is a virtue".

As a programmer, from time to time, you're going to be faced with code that just don't work for reasons you just don't understand.

You're going to miss a semicolon, mistake a capital letter for a small letter or have a code from a tutorial you want to include in your application but it simply doesn't work.

This is where patience comes in.

Being a programmer requires you to patiently sit in front of a computer for long periods of time.

Most of that time can sometimes be used for debugging and believe me, a semicolon can drive you crazy.

If you have to be a better programmer you need to be able to sit in front of a computer for a long time without distractions.

If there are other skills a programmer should have, you can add value to this post by leaving them in the comments below..

Keep learning, keep coding and don't forget a semicolon! Happy coding!!
Windows 11'e Mağaza Üzerinden WSL yükleme
Tags: wsl2, wsl, windows11
Published: 2021-10-23 16:40:32

> *[Daha detaylı halini gitbook sayfamda bulabilirsiniz](https://herrwinfried.gitbook.io/tr/isletim-sistemleri/windows-11/windows-11-microsoft-store-uezerinden-wsl-kurulumu)*


# Microsoft Store üzerinden indirme

## Powershell Yazılması gereken komut
> Yönetici Olarak çalıştırın powershell. Windows 11 terminal üzerinden yönetici başlatıp oradan powershell seçebilirsiniz.

```
dism.exe /online /enable-feature /featurename:VirtualMachinePlatform /all /norestart
```

## Microsoft Store

- [İndirmek İçin Tıklayın](https://aka.ms/wslstorepage)

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/h54cghswjqfeviqrotyw.png) 

"Al" veya "Yükle" Tıklayın. İndikten Sonra **bilgisayarınızı yeniden başlatın**.

## Son Ayarlamalar

### Powershell yazılması komutlar
> Yönetici Olarak çalıştırın powershell. Windows 11 terminal üzerinden yönetici başlatıp oradan powershell seçebilirsiniz.

```
wsl --update
```

```
wsl --shutdown
```

```
wsl --set-default-version 2
```

ve artık hazır!
My Experience as Maintainer for Hacktoberfest 2021
Tags: hacktoberfest, opensource, experience, devjournal
Published: 2021-10-23 15:57:24

October is the best month for me as an open source developer advocate as we celebrate the biggest open source event every year which is the [**Hacktoberfest**](https://hacktoberfest.digitalocean.com/).

Last year, I participated as a simple contributor to some of the open source projects and be able to complete the task and receive the limited edition Hacktoberfest 2020 Tee. 😎✨

## ☕ Motivation

After receiving the gift from the DigitalOcean, I plan that the next event (which is in 2021 / this year) I'll be a maintainer.

I was excited to become part of Hacktoberfest 2021 as a maintainer in the first day of October. I quickly setup all of my 40+ open source project so it will be ready for any contributions.

To get more contributions to my projects, I decided to participate on a local event in my country (Philippines) celebrating Hacktoberfest 2021. Hosted by [PWA Pilipinas](https://pwapilipinas.org/).

## 🎤 Tech Talk for Hacktoberfest

Here's my participation to that event. Click the image below to watch my tech talk about working with open source.
[![guide to open source by warengonzaga](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/n1k52rjmvf0g16ucohd6.png)](https://youtu.be/eA011BP1d70?t=2235)

Basically, I share my experience as an open source developer advocate and guide the younger generations to love and care about open source software. The highlight of my talk is how I look and feel about open source. 

Here's the highlight: **``"Your open source project is like having a child."``** you must care about it and grow it and everyone will love it.

## 💖 Overall Experience

The celebration gives us (open source developers) an opportunity to work on open source projects, maintain, and develop. My open source projects become active after months of being inactive. That's why I love this celebration, also I met different persons to work with, in addition I got my first JS.ORG subdomain name with the help of awesome contributors to my open source project.

We are currently working on this project: [buymeacoffee.js.org](https://buymeacoffee.js.org). If you want to participate just check the issues and let me know.

Hacktoberfest is a big help to me as I maintain 40+ open source projects that needs attention and update.

P.S. If you are looking for projects to work on just visit [my profile on GitHub](https://github.com/warengonzaga).

---

If you love my hard work and dedication to Open Source you may nominate me for [GitHub Star](https://stars.github.com/nominate/) and that's my dream to become the first Filipino (Philippines) to be part of GitHub Stars. I hope you'll become part of my dream. All of my hard work and years of dedication will be paid off. 🙏💖
You can use your database as a simple calculator
Tags: database, todayilearned
Published: 2021-10-23 15:29:20

Saw this in the [MySQL docs](https://dev.mysql.com/doc/refman/8.0/en/entering-queries.html). I'm assuming this only works for relational databases.

I don't know if it's very useful but definitely interesting.

```sql
MariaDB[] > SELECT SIN(PI()/4), (4+1)*5;
+------------------+---------+
| SIN(PI()/4)      | (4+1)*5 |
+------------------+---------+
| 0.70710678118655 |      25 |
+------------------+---------+
1 row in set (0.02 sec)
```

```sql
postgres=# SELECT SIN(PI()/4), (4+1)*5;
        sin         | ?column?
--------------------+----------
 0.7071067811865475 |       25
(1 row)
```