teleren/devto huggingface dataset:
Convert Numbers to Ordinal Numeral in Excel Office 365!!
Tags: convertnumberstoordi, kutoolsexceltutorial, kutools
Published: 2020-09-25 03:44:06

---
title: Convert Numbers to Ordinal Numeral in Excel Office 365!!
published: true
date: 2020-09-24 11:44:04 UTC
tags: convertnumberstoordi,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/convert-numbers-to-ordinal-numeral-in-excel-office-365/
---

In this article, you will understand the steps to **Convert Numbers to Ordinal Numeral in Excel Office 365** using **Kutools.** For example, the numbers 1,2,3,… are converted to 1<sup>st</sup>, 2<sup>nd</sup>, 3<sup>rd</sup>,…and so on. 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)

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.

## **Steps to Convert Numbers to Ordinal Numeral:**

To do follow the below steps.

- First, you need to **select the number cells** that you need to convert to ordinal numbers.

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

- Go to the **Kutools Tab, select** the **Content** option, **select** the **Convert Number to Ordinal** option from the menu.

![Choose Number to Ordinal option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Choose-Number-to-Ordinal-option.png)<figcaption id="caption-attachment-14596">Choose Number to Ordinal option</figcaption>

- Now, all the selected numbers are displayed as ordinal numerals in the selected range as shown in the below screenshot.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Result-6.png)<figcaption id="caption-attachment-14597">Result</figcaption>

## **Summary:**

In this article, you can understand the steps to **Convert Numbers to Ordinal Numeral in Excel Office 365** using **Kutools.** Kindly, share your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!
How to Install Oreo TV in My Android Phone?
Published: 2020-09-24 11:34:24

Oreo TV APK is the best Live TV app for android, which allows you to watch movies, shows and IPLT20 in your smartphones or smart tv. Oreo TV is an Alternative to ThopTV APP.

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

I am Search on Google How to Install and Found this tutorial link for Download Oreo TV APK v1.8.5 here. https://www.final-job.com/2020/09/oreo-tv.html
Proxying website use backend
Published: 2020-09-24 11:11:42

Hello.
I have an iOS app where needs a proxying website through private server(HTTP / HTTPS proxy), but its idea each time has some trouble, when I am trying to solve their on the client-side, how I can solve this problem use the back end.

IMPORTANT: need proxying website which has various type of JavaScript. Appearing idea use anonymizer, I am trying various websites like 2ip and another anonymizer, it's work good BUT when I use anonymizer for a web site like, youtube which have JS I can't saw video content, If the site has PHP it's not a problem looking a video content through a proxy.

Question: How I can solve this problem use back end(Technology doesn`t matter) if I want proxying websites with video content through a proxy, and these sites have JS?
Do u like it ?
Tags: showdev, webdev
Published: 2020-09-24 10:51:27

Hello guys,
I just rework my portfolio, and I would be happy to have your opinions. So if u want let's get a look at it : [jeremymonatte.fr](https://jeremymonatte.fr/)

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/macrh40cugyvs4dxhzq9.PNG)

PS: You should know i'm french, so all texts are...   in French :)
Automating my set-up on a fresh Ubuntu by using a bash script
Tags: linux, productivity, bash, automate
Published: 2020-09-24 10:39:21

---
title: Automating my set-up on a fresh Ubuntu by using a bash script
published: true
description: Automating my set-up on a fresh Ubuntu by using a bash script
tags: #linux #productivity #bash #automate
canonical_url: https://andreigatej.dev/blog/automate-setup
---

_Originally published at [andreigatej.dev](https://andreigatej.dev/blog/automate-setup)_.

*The Github repository can be found [here](https://github.com/Andrei0872/automate-setup-on-fresh-ubuntu)*.

It usually takes me around 30 minutes - 1 hour to set up everything I need in order to start working on a new OS(in this case, Ubuntu). So I figured it would be worth the time spent on building a script that would automate all of this. Moreover, bash scripting has always been something cryptic to me, so I thought this was a good opportunity to get comfortable with writing such scripts.  

## Usage

Open your terminal in your preferred location and create a file that will eventually be invoked in order to install the programs you'd need.

```bash
# `vim` could be replaced with your text editor of choice(e.g `gedit`)
touch setup && vim $_
```

Paste the content of the [`setup.sh` file](https://github.com/Andrei0872/automate-setup-on-fresh-ubuntu/blob/master/setup.sh) into the newly created file.

Run the script with:

```bash
sudo bash setup $HOME
```

We need `sudo` privileges because the script will install new programs on the OS and `$HOME` in order to properly place `ZSH` and to determine the user so we can add it to the `docker` group.

---

## How it works

The [file](https://github.com/Andrei0872/automate-setup-on-fresh-ubuntu/blob/master/setup.sh) comprises functions that will install the needed programs. Each function follows this pattern: `function installProgramToBeInstalled { }`.

For example:

```bash
# ...

function installGit {
  format_output "installing git"

  sudo apt install -y git

  echo
}

function installDocker {
  format_output "installing docker"

  curl -s https://get.docker.com/ | bash

  usermod -aG docker $user

  su - $user

  echo
}
# ...
```

Then, in order to invoke all the functions, I've used this logic:

```bash
functions="$(cat $0 | egrep -o install[A-Z]+[A-Za-z]+)"
for f in $functions; do $f;done
```

`$0` refers to the current file. With `egrep -o install[A-Z]+[A-Za-z]+)` we get all the *install* functions. Lastly, we loop through each function and invoke it.
[Tutorial Linux] Terminal: Verificando informações do sistema
Tags: linux, terminal, uname, womakerscode
Published: 2020-09-24 10:36:47

O comando:

```
$ uname -a
```

retorna **informações referentes ao sistema**.

- **$** indica que você deve usar o **usuário comum** para fazer essa operação.

- **-a** do inglês, *all*, para retornar todas as informações.

No meu caso, temos o seguinte retorno:

```
Linux linux 5.4.0-42-generic #46~18.04.1-Ubuntu SMP Fri Jul 10 07:21:24 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux
```

![nome do Kernel](https://dev-to-uploads.s3.amazonaws.com/i/4vp6ofqw8qgqsg567vsl.png)

O primeiro item é o **nome do Kernel** do sistema. Para que seja mostrado na tela apenas ele, digite:

```
$ uname -s
```

Ou

```
$ uname
```

Sem qualquer argumento.

![nome da máquina](https://dev-to-uploads.s3.amazonaws.com/i/erg0c3ojbhfnrt312lgo.png)

O segundo item é o **nome da máquina**, dado no momento da instalação. Para que seja mostrado na tela apenas ele, digite:

```
$ uname -n
```

![versão kernel release](https://dev-to-uploads.s3.amazonaws.com/i/g3b0xglu4a8w1ss8i6g5.png)

O terceiro item é a **versão de lançamento do Kernel**. Para que seja mostrado na tela apenas ele, digite:

```
$ uname -r
```

![versão atual kernel](https://dev-to-uploads.s3.amazonaws.com/i/he42zhnc4rywviwo60kj.png)

O quarto item é a **versão atual do Kernel**. Para que seja mostrado na tela apenas ele, digite:

```
$ uname -v
```

![arquitetura](https://dev-to-uploads.s3.amazonaws.com/i/0r293hryqlslhfmisnwl.png)

O quinto item é a **arquitetura de hardware da máquina**. Para que seja mostrado apenas ela na tela, digite:

```
$ uname -m
```

![tipo de processador](https://dev-to-uploads.s3.amazonaws.com/i/vjgpez32ur997xgty3jf.png)

O sexto item é o **tipo de processador**. Para que seja mostrado apenas ele na tela, digite:

```
$ uname -p
```

![plataforma de hardware](https://dev-to-uploads.s3.amazonaws.com/i/qg9bheaq9ugr6slsm8jm.png)

O sétimo item é a **plataforma de hardware**. Para que seja mostrado apenas ela na tela, digite:

```
$ uname -i
```

![sistema operacional](https://dev-to-uploads.s3.amazonaws.com/i/l3radpkx5l5discpg3or.png)

O oitavo e último item é nome do **sistema operacional** da instalado. Para que seja mostrado apenas ele na tela, digite:

```
$ uname -o
```
What is Gradient descent algorithm?
Tags: gradientdescent, steepestdescent, machinelearning
Published: 2020-09-24 10:29:30

The gradient descent algorithm is an approach to find the minimum point or optimal solution for a given dataset. It follows the steepest descent approach. That is it moves in the negative gradient direction to find the local or global minima, starting out from a random point. We use gradient descent to reach the lowest point of the cost function.

In Machine Learning, it is used to update the coefficients of our model. It also ensures that the predicted output value is close to the expected output

For example, in Linear Regression, where we separate the output using a linear equation.

Let us say we have an equation **y=mx+c**.

Here, **m** stands for slope and **c** for the **y-intercept**. These two values can be optimized and the error in the cost function (the difference between expected and predicted output) can be reduced using the gradient descent algorithm.

### **Weight updation**

So let us see how weight updation works in gradient descent. Let us consider a graph of cost function vs weight. For improving our model, bringing down the value of cost function is essential. We consider the lowest point in the graph as the winner since the cost function would be minimal at this point.

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

In the above diagram, we can see that with each iteration, the function tries to bring down the cost value. But that is not the case in real-world datasets. In real-world cases, it moves in a zig-zag manner for most of the datasets. The graph for real-world cases is as shown below.

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

### **What is the maths behind it?**
The weight updation takes place by decrementing the cost function in steps of the gradient (derivative) of weight function. The equation used for weight updation is:

ω<sub>new</sub> = ω<sub>old</sub> -η* (δ<sub>L</sub>/δ<sub>OLD</sub> )

Here **ω** corresponds the weight and **η** the learning rate, which determines by what value the descent is made in each iteration.

For every cross mark shown in the graph, we calculate the slope. According to the slope value, we update the weights in the above equation.

### **Conclusion**
Here is a sequence diagram to brief out the process of updating the weights. This update in weights leads to a reduction in the cost function.

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

Hope you learnt something from this article. Thank you for taking the time to read this article.
Ocula - A weather app built on Vue 3
Tags: vue, javascript, webdev, typescript
Published: 2020-09-24 10:26:59

Hi Everybody

I wanted to share with you a project that I have been working on over the past few weeks: [Ocula](https://app.ocula.io).

Ocula is a free PWA weather app written using the latest version of Vue. It is designed to look and feel native on mobile devices while also offering a nice desktop experience.

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

Some of the features include:
- No location restrictions - available worldwide
- Daily forecast for up to 7 days
- Hourly forecast data for up to 24 hours
- Trend charts for hourly temp, rainfall and wind
- Interactive weather maps with 6 different map types (radar, precipitation, temp, cloud, wind, pressure)
- Frame-by-frame playback for radar images to visualise incoming rain
- Dark/Light Themes. Default theme changes based on current time of day
- Options to reorder or hide forecast sections, set your preferred map type, units and more
- Open-source, privacy friendly, and best of all - free

The app is currently in an alpha phase but I'm hoping to get some early feedback from the community to address some glaring bugs/UX issues.

Head over to [app.ocula.io](https://app.ocula.io) to check out the app and let me know what you think. The source is also available [here](https://github.com/andrewcourtice/ocula).

Thanks!
...its like a search engine, but for food
Tags: codepen, api, beginners
Published: 2020-09-24 10:20:39

As a beginner into the front-end field, if there is one thing I have learned from being in a community like CodePen is that you have to, as much as possible, showcase whatever you've been able to learn so far by creating something creative, something that mirrors something useful from the real world. So I've got this: Essentially a program made with #javascript that uses the fetch API to retrieve official meal API data and then renders it.

link to the Official theMealDB API: https://www.themealdb.com/api.php

link to my pen:
https://codepen.io/ikenna_ez/pen/ExKdJeO?editors=0010

My problem, however, is that search results are often duplicated when you type into the search bar too fast, as a result. One way to fix this is to make the input listen to 'submit' events instead of 'input' or 'keyup', but I wanted the search bar to be as interactive as possible, therefore I am still working to resolve this but if any of y'all know how to fix it feel free to fork it and send me the finished on Github or send the link to my feed.
What is CRM Consulting?
Published: 2020-09-24 10:11:09

It is the responsibility of a [CRM consultant](https://www.cloudanalogy.com/) to hire and find a perfect location for specialists in different fields. Consulting is about finding the perfect job for people specialized in the IT field, such as designers, administrators, programmers, analysts, managers, and project leaders. So when a CRM consultant is preparing to find a recruitment for a particular specialist or to find an employee for a reputable organization, they should make a list of CRM interview questions. The main goal of any CRM is to provide a perfect employee for an organization that absolutely matches the job profile. Likewise, the consultant must also take responsibility for finding the perfect job that matches the standard of the professional in the [IT industry](https://www.cloudanalogy.com/).

Meet all kinds of requirements

CRM is about looking for candidates not only in the technical field, but also from other fraternities such as attitudes and culture. The selection process includes a selection and a value proposition in which the main role is played by the CRM interview questions. The consultant is assisted by a team of IT industry experts and professionals from other fields of work. The first step generally involves preliminary screening of the potential employee. Second, the candidate must face both in-depth and intensive communication, personality and presentation tests. These efforts are essential to know if the future collaborator is capable of working in an intercultural and ethnic work environment.

So simply put, CRM is a person who builds a relationship with their customer around results so that their efforts have a positive impact on the way the business operates. Their job is to introduce improvised things that are measurable and somehow relate to value.

Every industry has its own challenges and pitfalls and needs an adequate response from the sales force to satisfy its team of workers. In the absence of a perfect sales force, a company's operation can stagnate and the speed of progress slows. That's why companies strive to hire a top-tier CRM consulting firm to discover their sales force team that is not only academically qualified enough, but also has the right temperament to work with. harsh situations and difficult working conditions. Therefore, finding the correct Salesforce answer becomes an integral part of the CRM consultant's job and job profile. So for a business, having a good [CRM consultant](https://www.cloudanalogy.com/) for assistance is of the utmost importance.
Azure Free Certification Exam Sep 22-24 2020
Published: 2020-09-24 10:11:08

Microsoft’s Ignite is live from 22nd-24th Sept 2020, Microsoft is giving a free certificate too for all participants who complete the challenge, Details below


Register for ignite Event on below link first:

https://myignite.microsoft.com/

After this sign up for the any of the interesting challenge using below URL: https://csc.docs.microsoft.com/ignite/registration

After this you will be able to see that under challenges section


 
Docs URL:https://docs.microsoft.com/en-us/users/<yourusername>/challenges


After completing your first challenge you will earn a free certification exam, you will be getting an e-mail around Oct 15 with more details on how to redeem that to schedule the certification exam.
Using AI to avoid touching your face
Tags: azure, tutorial, ai, webdev
Published: 2020-09-24 10:09:24


#### 📺 028 - Em Lazer Walker 🎙️ Frank Boucher

{% youtube ZdSFIUeJ2gk %}

---

In this episode, Em is showing one of her last projects. She trained a machine learning model using Azure Custom Vision to detect when someone, facing the camera, is touching or not their face. All this project is also available in [GitHub](https://github.com/lazerwalker/dont-touch-your-face).

Em will starts by explaining what a good machine learning model, and explain why the one use, in this case, is only "good enough for a demo".  We will cover different options available when building your model and the scenarios when those options should be used. Once created, we will train our brand new model using many images of faces for both of the scenarios: touching and not touching. 

The second part of this demo is composed of a JavaScript webapp. We will walk through the code that does all the operations to grab an image from the video feed and send it to the [Custom Vision](https://azure.microsoft.com/en-ca/services/cognitive-services/custom-vision-service/?WT.mc.id=allaroundazure-devto-emwalker) service.

Finally, she will share a VR project, inspired by the Microsoft Flight simulator (coming out that day), that use the [Bing map service](https://www.microsoft.com/en-us/maps/choose-your-bing-maps-api?WT.mc.id=allaroundazure-devto-emwalker) to let us fly in any sky around the globe.

---

### Useful Links

 🔗 [Custom Vision](https://azure.microsoft.com/en-ca/services/cognitive-services/custom-vision-service/?WT.mc.id=allaroundazure-devto-emwalker)

🔗 [Custom Vision Quickstart](https://docs.microsoft.com/en-us/azure/cognitive-services/custom-vision-service/getting-started-build-a-classifier?WT.mc.id=allaroundazure-devto-emwalker)

🔗 [How YOU Can Use Computer Vision to Avoid Touching Your Face!]( https://lzrwlkr.me/dont-touch-your-face-writeup)

🔗 [Don't Touch Your Face app](https://lazerwalker.com/dont-touch-your-face)

🔗 [Don't Touch Your Face code]( https://github.com/lazerwalker/dont-touch-your-face)

🔗 [Bing Map Service](https://www.microsoft.com/en-us/maps/choose-your-bing-maps-api?WT.mc.id=allaroundazure-devto-emwalker)


### Learn more about Em Lazer Walker

🔗 [@lazerwalker](https://twitter.com/lazerwalker)

🔗 [Bio](https://developer.microsoft.com/en-us/advocates/em-lazerwalker)



## Find us on

📺 [Twitch](https://www.twitch.tv/microsoftdeveloper)

🔗 [Twitter](https://twitter.com/fboucheros)


☁️
How to refresh/reload application properties runtime in spring boot ?
Tags: springboot, tutorial, java, spring
Published: 2020-09-24 10:00:47

---
title: How to refresh/reload application properties runtime in spring boot ?
published: true
description:  Manage and reload spring application properties on the fly
tags: springboot, tutorial, java, spring
cover_image: https://dev-to-uploads.s3.amazonaws.com/i/6xxet98xdwaxq08snali.PNG
---

In this tutorial, we are going to learn how to reload application properties in spring boot.

We have many options in spring boot, now I am explaining the easiest one here.

> Refresh beans with ***@ConfigurationProperties***

For Reloading properties, spring cloud has introduced ***@RefreshScope*** annotation which can be used for refreshing beans.

Spring Actuator provides different endpoints for health, metrics. but spring cloud will add extra end point ***/refresh*** to reload all the properties.

### Required maven/gradle dependencies

- Spring actuator
- Spring cloud starter

```java
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-actuator</artifactId>
</dependency>
```

```java
<dependency>
    <groupId>org.springframework.cloud</groupId>
    <artifactId>spring-cloud-starter</artifactId>
</dependency>
```

Then, add below property to application properties file

```java
management.endpoints.web.exposure.include=refresh

// Db Properties, Values to be store in a Map
db.dbProps.awsEndPoint=localhost:8080/aws/
db.dbProps.azureEndPoint=localhost:8080/azure/
```

Now, Create a class for configuring properties and add ***@RefreshScope*** annotation to class.

```java
@Component
@ConfigurationProperties(prefix = "db")
@RefreshScope
public class DbProperties {

	  // This is for storing application properties in a Map
    public Map<String, String> dbProps;

    public Map<String, String> getDbProps() {
        return dbProps;
    }

    public void setDbProps(Map<String, String> dbProps) {
        this.dbProps = dbProps;
    }

		// Get property value using key
    public String getDbPropData(String key) {
        return dbProps.get(key);
    }
}
```

Above code create a scope for refreshing application properties data.

Now, when you change data in application properties. we need to give a POST REST call using below URL.

```java
http://localhost:8080/actuator/refresh
```

from now, we can get new value from the next access.  

Thank you for reading my blog. 🤩
You've missed MS Ignite 2020? Don't worry!
Tags: msignite, events, microsoft
Published: 2020-09-24 09:51:23

Yes, while some webcasts of MS Ignite are not recorded or published after the event, some are! 

Even if you are a beginner developer, I really can recommend MS Ignite every year because it showcases a lot of ideas that might inspire you in your daily work. I personally try to follow MS Ignite every year because it is delivering so much content you can learn from. I also try to follow Twitterverse during that time because during those days the community is buzzing more than it normally does!

If you don't have the time, just crawl some through some of the videos on [YouTube](https://www.youtube.com/channel/UCrhJmfAGQ5K81XQ8_od1iTg) or check the slides on the [GitHub](https://github.com/microsoft/ignitelearnzone). 

Make sure that you visit those sites again in the next few days because according to my experience, Microsoft is going to upload sessions one after one in the next few days.

Have fun and enjoy the sessions!

I'd like to thank a lot to everybody who somehow contributed to Microsoft Ignite 2020!