teleren/devto huggingface dataset:
Svelte Transitions?
Tags: discuss, webdev, svelte, javascript
Published: 2020-10-27 10:46:00

How are people handling page/component transitions in their [Svelte](https://svelte.dev/) web apps?

I found [Barba.js](https://barba.js.org/) the other day and want to give it a go. Thought I might try in on a Svelte app I’m building.

Anyone used Barba with Svelte? Would you recommend, or discourage?
Hacktoberfest
Tags: hacktoberfest
Published: 2020-10-27 10:45:33

<!-- ✨This template is only meant to get your ideas going, so please feel free to write your own title, structure, and words! ✨ -->


### [Intro Heading]
<!-- If you are new to the DEV community, introduce yourself and share a bit about why you joined DEV and decided to participate in Hacktoberfest this year.  --> 
### Background

<!-- Are you brand new to open source? What about coding in general? Tell us about how you got here →

### Progress

<!-- Share a bit about where you’re at in your Hacktoberfest journey. What stage are you at? How has the process been?  -->

### Contributions

<!-- This is where you can list the contributions you made and explain why you chose the projects you did. Don’t forget to add links!  -->


### Reflections
<!-- Overall, how has your Hacktoberfest 2020 experience been? If you’re a first-timer, will you participate again? What have you learned? Have you made any interesting connections? What is your next step in open source?  -->
A mobile application that helps medical specialists and patients interact effectively
Tags: startup, uiweekly, android, ios
Published: 2020-10-27 10:41:33

Our client was looking for a professional engineering team to build a highly functional mobile application that would simplify the interaction between medical institutions, patients, doctors, and specialists.

They wanted the app that would meet the needs of the potential users, provide an intuitive and friendly experience, allow for rapid communication and be equipped with push notifications.

[Learn more about the development of cloud-based medical service and a mobile application for clinics](https://evrone.com/medme)
Developing a comprehensive search engine for an industrial machinery company
Tags: startup, machinelearning, vue, react
Published: 2020-10-27 10:32:52

In 2012, Dan Pinto and Dmitriy Rokhfeld created an aggregator that automatically collected information about used industrial machinery and heavy equipment that was for sale.

The idea of ​​creating the service came to Dan when he received a work assignment to search the Internet for a printing machine. The task turned out to be more difficult than expected. You can’t buy such a machine on eBay, and comparing price lists on a thousand different sites takes a lot of time. So, Dan developed a technology for automatically collecting the information from websites and combining the data into one place.

[Learn more about how we bolstered Machinio’s original in-house development processes with our expertise.](https://evrone.com/machinio)
Creating a custom CRM to launch KFC into the future of customer-defined service
Tags: startup, ruby, go, rust
Published: 2020-10-27 10:24:52

We are helping KFC build the fast-food restaurant of the future. A restaurant that integrates technologies with [CRM](https://evrone.com/crm) to recognize and cater to the needs of each individual customer. In Moscow, KFC is opening a restaurant that has no cash desks, and where orders are brought by a conveyor and a robot.

Evrone has extensive experience working with large international companies. However, the task of personalizing interactions with millions of KFC customers was a new challenge. One that we were excited to take on.

Learn more about how we built a CRM system for one of the most popular fast-food restaurants in the world via the link above.
Hash Tables
Tags: javascript, hacktoberfest
Published: 2020-10-27 10:18:30

    class HashTable {
      constructor(size=53){
        this.keyMap = new Array(size);
      }

      _hash(key) {
        let total = 0;
        let WEIRD_PRIME = 31;
        for (let i = 0; i < Math.min(key.length, 100); i++) {
          let char = key[i];
          let value = char.charCodeAt(0) - 96
          total = (total * WEIRD_PRIME + value) % this.keyMap.length;
        }
        return total;
      }

      // Add a Value
      set(key, value) {
        let index = this._hash(key);
        if(!this.keyMap[index]) {
          this.keyMap[index] = [];
        }
        this.keyMap[index].push([key, value]);
        console.log(` ${key} or ${value} ->> is added successfully 👍👍`)
        return ht;
      }

      // Find a value 
      get(key) {
        let index = this._hash(key);
        if(this.keyMap[index]) {
          for(let i = 0; i < this.keyMap[index].length; i++) {
            if(this.keyMap[index][i][0] === key) {
              return this.keyMap[index][i][1]
            }
          }
        }
        return undefined;
      }

      // Show all Keys
      keys() {
        let keysArr = [];
        for(let i = 0; i <this.keyMap.length; i++) {
          if(this.keyMap[i]) {
            for( let j = 0; j < this.keyMap[i].length; j++) {
              if(!keysArr.includes(this.keyMap[i][j][0])) { 
                keysArr.push(this.keyMap[i][j][0])
              }
            }
          }
        }
        console.log(` Your Keys is -> ${keysArr}`);
        return keysArr;
      }

      // Show all Value
      value() {
        let valuesArr = [];
        for(let i = 0; i <this.keyMap.length; i++) {
          if(this.keyMap[i]) {
            for( let j = 0; j < this.keyMap[i].length; j++) {
              if(!valuesArr.includes(this.keyMap[i][j][1])) { 
                valuesArr.push(this.keyMap[i][j][1])
              }
            }
          }
        }
        console.log(` Your Value is -> ${valuesArr}`)
        return valuesArr;
      }
    }

    let ht = new HashTable(17);
    ht.set("java script ", "java")
    ht.set("html ", "css")
    ht.set("c ", "c++")
    ht.value();
    ht.keys();



    //  ht.keys().forEach(function(key) {
    //    console.log(` -> your Key is -> ${ht.get(key)}`);
    //  })

    //       👆👆 👆 👆 👆 👆 👆 👆 👆

    //           👉  OUTPUT 👈

    //            -> your Key is -> java
    //            -> your Key is -> css 
    //            -> your Key is -> c++
From supermarket shelves to your doorstep in 90 minutes
Tags: startup, webdev, ruby, programming
Published: 2020-10-27 10:17:40

Why go to the supermarket when iGooods can bring the supermarket to you? iGooods is transforming grocery shopping in St. Petersburg: bringing together customers, in-store staff, and couriers to deliver your regular shopping right to your door, in as little as 90 minutes.

Across desktop and mobile, at home, in the office, in-store, and on the road, [Evrone engineers](https://evrone.com/web-development) developed a complete solution that keeps each part of iGooods operating smoothly.

[Learn more about how customers shop at their favorite supermarkets, right from the comfort of their desktop or mobile device](https://evrone.com/igooods)
Tổng Quan Về Lập Trình AI & Các Bước Học Lập Trình AI Đơn Giản
Published: 2020-10-27 10:14:02

Ngày nay, lập trình AI trên các thiết bị điện tử thông minh ngày càng xâm nhập vào cuộc sống hàng ngày của con người và hỗ trợ chúng ta trong các hoạt động.Xem chi tiết tại: https://blog.itnavi.com.vn/lap-trinh-ai/
Innovating the Hype.codes tech media portal
Tags: blockchain, programming, uiweekly, startup
Published: 2020-10-27 10:09:51

The founders of Hype.codes approached us with the goal of building a media portal that would present the most up-to-date and relevant news on programming technologies, tech innovations, and blockchain and cryptocurrency development.
The client had partnered with other media companies, cryptocurrency leaders, and online content creators, and they were striving to dominate the technology-related media market.

[Learn more about how we developed an impressive portal with a vastly different design and identity than its competitors](https://evrone.com/hypecodes)
keyoxide.org proof
Published: 2020-10-27 10:07:56

This is an OpenPGP proof that connects [my OpenPGP key](https://keyoxide.org/FDB9561FCC5F4399744C644113DFE4530C28527B) to [this dev.to account](https://dev.to/savasana). For details check out https://keyoxide.org/guides/openpgp-proofs

[Verifying my OpenPGP key: openpgp4fpr: FDB9561FCC5F4399744C644113DFE4530C28527B]
Mapreduce Là Gì- Tổng Quan Mô Hình Lập Trình Mapreduce
Published: 2020-10-27 10:06:00

MapReduce là gì? Các hàm chính của MapReduce?  Nền tảng MapReduce hoạt động như thế nào? Hãy cùng chúng tôi gửi đến cho các bạn ngay sau bài viết này! Xem chi tiết tại: https://blog.itnavi.com.vn/mapreduce-nhung-uu-diem-va-cach-thuc-hoat-dong-cua-nen-tang-nay/
A very productive start to the year for personal projects.
Tags: productivity, goals, motivation, discuss
Published: 2020-10-27 09:54:33

Since the beginning of the year in 5 months I have done 254 tasks. This is twice as much as last year.
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/3qj8ajkeru34rquixd0s.png)

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/5tshn5ses6nhnle11n23.png)

I have been using the [iSmartLife](https://ismart.life/) application to manage my home projects and have been using it for more than 3 years. Today I decided to analyze the results of the reports. This is the most productive period of all time. I did many tasks. Of course, this is due to the transition to remote work and the ability to devote more time to personal projects.

I think the current period is a good time to implement personal projects. Do not miss this time.

What are your results? How and what do you use to receive reports?
Formulas for Counting the Cells between Two Numbers in Excel!!
Tags: excelformula, excelformulas
Published: 2020-10-27 12:19:45

---
title: Formulas for Counting the Cells between Two Numbers in Excel!!
published: true
date: 2020-10-27 09:53:34 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/formulas-for-counting-the-cells-between-two-numbers-in-excel/
---

This page shows the basic syntax and explanations on the **Formulas for Counting the Cells Between Two Numbers** in Excel Office 365. 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)

![Count Cells between Two Numbers](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Main.png)<figcaption id="caption-attachment-16320">Count Cells between Two Numbers</figcaption>

## General Formula:

- Use the below formula to count the cells between two numbers in Excel.

**=COUNTIFS(range,”>=X”,range,”<=Y”)**

## Syntax Explanations:

- **COUNTIFS** – The COUNTIFS function helps to count cells that match multiple criteria.
- **X and Y** – It is a Numbers or Values, which is used to count the cells.
- **Operators (“>=” ,”<=”)** – These operators are used to check the condition between two dates.
- **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.
- **Ranges** – It contains the **input ranges.**

## Example:

- Let’s consider the below image to count the cells between two numbers.
- First, you need to give the input values or numbers.
- Then, enter the given formula in the selected field.
- After applying the formula you can get the results as shown below.

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

- The above steps will help to count the cells between two numbers in Excel using formula.

## Closure:

From this article, you can get to know the simple and useful **Formulas for Counting the Cells between Two Numbers** in Excel Office 365. You can also learn its basic syntax with brief explanations. If you have any **queries,** feel free to share it with us. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!!**
Excel Formulas to Count Cells Equal to Case Sensitive Values!!
Tags: excelformula, excelformulas
Published: 2020-10-27 12:20:00

---
title: Excel Formulas to Count Cells Equal to Case Sensitive Values!!
published: true
date: 2020-10-27 09:51:42 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-count-cells-equal-to-case-sensitive-values/
---

Here, we will show the simple and useful **Formulas to Count the Cells Equal to Case Sensitive Values in Excel Office 365** with the best example. It also describes the basic syntax with its brief explanations. 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)

[![Formula to Count cells equal to case-sensitive](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/Main-Image.png)](https://geekexcel.com/?attachment_id=16355#main)<figcaption id="caption-attachment-16355">Formula to Count cells equal to case-sensitive</figcaption>

## General Formula:

**=[SUMPRODUCT](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/)((–[EXACT](https://geekexcel.com/how-to-use-exact-function-in-microsoft-excel-365/)(value,range)))**

## Syntax Explanations:

- **SUMPRODUCT** – The Excel [**SUMPRODUCT Function**](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/) will multiply the corresponding arrays or ranges and returns the sum of the product.
- **EXACT** – It helps to compare two text strings in Excel and returns the result as TRUE when they are the same values otherwise it will return FALSE. Read more on the [**EXACT Function**](https://geekexcel.com/how-to-use-exact-function-in-microsoft-excel-365/).
- **Minus operator (-)** – This symbol will subtract the two values.
- **Range** – It is an input value given in a worksheet.
- **Values** – This value is will help to count the cells.
- **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 input 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-31.png)<figcaption id="caption-attachment-16354">Example</figcaption>

- The above steps will help to count the cells contains case-sensitive values using Excel Formulas.

## A Brief Summary:

In this tutorial, we explained the **formulas to count the cells equal to case-sensitive values in Excel Office 365**. You can also learn the basic syntax and its explanations for the formula. If you have any **doubts,** drop it in the below comment box.
🎈 Weekly Win (44/2020)
Tags: win, done, nextjs, transition
Published: 2020-10-27 09:49:13

Did you attend the [Jamstackconf](https://jamstackconf.com/2020/october/) a few weeks ago? If you did, I hope you visited our virtual booth too. We had many interesting conversations and got to live coding too.

Around that time I have just finished my new [personal site](https://ondrabus.com) on Jamstack. You know, to have it nice and fast. But what I observed on other, mainly Gatsby-powered, sites were these nice transitions between pages. No visible flick and reload in the browser when navigating to other pages, but a seamless transition.

When we discussed that on Jamstackconf, there was a guest in our booth that encouraged me and helped me to do the same on my website using [Framer Motion](https://github.com/framer/motion). It took literally just an hour including finding and fixing one bug in routing 😄

Take a look at [ondrabus.com](https://ondrabus.com) and if you like the transitions, add them to your website too: [Framer Motion on Github](https://github.com/framer/motion).
Formulas to Count Cells Either X or Y In Excel Office 365!!
Tags: excelformula, excelformulas
Published: 2020-10-27 12:20:10

---
title: Formulas to Count Cells Either X or Y In Excel Office 365!!
published: true
date: 2020-10-27 09:48:46 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/formulas-to-count-cells-either-x-or-y-in-excel-office-365/
---

In this article, we will see the **Formulas to Count the Cells Either X or Y in Excel Office 365** with a suitable 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 either X or Y](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/10/main-image-1.png)<figcaption id="caption-attachment-16360">Formulas to Count Cells either X or Y</figcaption>


## General Formula:

**=COUNTIF(range, value1)+COUNTIF(range,value2)**

## Explanations for Syntax:

- **COUNTIF** -The **COUNTIF Function** will help to count the cells that match a single condition or criteria. It is not case-sensitive.
- **Range** – It is an input value given in a worksheet.
- **Values** – This value is will help to count the cells.
- **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.
- **Plus Operator (+)** – This symbol will help to add the two ranges or values.

## Example:

- Let’s consider the below screenshot to count the cells either x or y.
- First, you need to enter the input ranges.
- Then, apply the given formula in the formula bar section.
- After that, it will display the result as shown below.

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

## Verdict:

In this tutorial, you can learn simple and useful **formulas to count the cells either X or Y in Excel Office 365**. You can also know its basic syntax with its explanation. If you have any **queries/doubts,** kindly share it with us. Thank you so much for Visiting Our Site!! Continue learning on **[Geek Excel](https://geekexcel.com/)!!**

### Read Also:

- **[Excel Formulas to Count the Cells Between Two Dates!!](https://geekexcel.com/wp-admin/post.php?post=16261&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)**
- **[Formulas for Counting the Number of Bold Cells in a Range In Excel!!](https://geekexcel.com/wp-admin/post.php?post=16065&action=edit)**
[3] My Studies at the University
Tags: codenewbie, webdev, beginners, career
Published: 2020-10-27 09:43:44

As I mentioned in [one of my previous posts](https://create-react-app.com/creare-react-app-blog/), I am currently studying IT at the LAB University of Applied Sciences (Finland, Lahti). The first year of my studies ended about one month ago, and in the coming fall, I will continue with the second one.

During the first year, we had basically a lot of core studies, like English, math, and physics, which is, I think, quite common. Fortunately, we also had some courses on more IT-related topics: web development (HTML, CSS & JS), basics of software engineering (Python, SQL), servers, virtualization, etc.

Anyway, after the first year, we will need to choose our study path more precisely. So, as you can see from the picture below, every student has a lot of options to choose from. The point is to choose seven modules (except the lower module and also the thesis and internship). Each module worth 15 credits, and to graduate, you need to complete 240 credits in four years. At the moment, I have 90 credits, so I guess it is pretty realistic.

![](https://create-react-app.com/wp-content/uploads/2020/07/D9E820F7-5FCB-4F30-BDEE-6EEB2533DCDE.png)

I tagged some modules, about which I decided to take them: Web and game dev, Software engineering, Web services, and Mobile and game dev. There are also four modules about which I’m not sure yet. You can choose from a lot of inspiring subjects, for example, data analysis and machine learning. At the same time, I am trying to concentrate more on web development related things. So, maybe it is not a very productive strategy to go for too many things at the same time. In any case, I still have time to think about it.

[Original post 04.07.20 @ create-react-app.com](https://create-react-app.com/my-studies-at-the-university/)

Site https://proj.create-react-app.com/
GitHub https://github.com/villivald
My Hactoberfest
Tags: hacktoberfest
Published: 2020-10-27 09:37:41

<!-- ✨This template is only meant to get your ideas going, so please feel free to write your own title, structure, and words! ✨ -->

Fun Coding...

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/l4baxyds4mt31wtzybmm.png)![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/o9kexkutlzin2zjj5i9u.png)


### Beginner
<!-- If you are new to the DEV community, introduce yourself and share a bit about why you joined DEV and decided to participate in Hacktoberfest this year.  --> 
This was my first hacktoberfest, In fact, a real inspiration to Open Source Contribution, In the beginning, I did have any idea about collaborating, But this month and Digital Ocean has helped me to a big extend thereby giving me a wonderful entry the field

### Background

<!-- Are you brand new to open source? What about coding in general? Tell us about how you got here →

My self a second Year Student from India, Learning Python, Android, and much more during the quarantine. Obsessed with Webpages, Apps, and those technologies yet to conquer.

Being a beginner I was a bit afraid to attend this event, but certain blog post gave me the inspiration to try at least a PR 

### Progress

<!-- Share a bit about where you’re at in your Hacktoberfest journey. What stage are you at? How has the process been?  -->

I learned Django and developing Android packages through the hacktoberfest, I have also started a repo as a maintainer of hacktoberfest projects one with a Youtube API.

### Contributions

<!-- This is where you can list the contributions you made and explain why you chose the projects you did. Don’t forget to add links!  -->

A Project on Youtube API, Some C Codes, Django Rest Framework, and as a Maintainer 


### Reflections
<!-- Overall, how has your Hacktoberfest 2020 experience been? If you’re a first-timer, will you participate again? What have you learned? Have you made any interesting connections? What is your next step in open source?  -->

This was a great inspiration for upcoming contributions I will try to make more development and make quality code for the Open Source Projects out there.....