teleren/devto huggingface dataset:
How to Use {IMAGINARY Function} in MS Excel 365?
Tags: excelfunctions, imaginaryfunctionine
Published: 2020-08-21 16:47:50

---
title: How to Use {IMAGINARY Function} in MS Excel 365?
published: true
date: 2020-08-14 12:22:45 UTC
tags: ExcelFunctions,IMAGINARYFunctioninE
canonical_url: https://geekexcel.com/how-to-use-imaginary-function-in-ms-excel-365/
---

## IMAGINARY Function in Excel:

In this article, we are going to see how to use **IMAGINARY Function in Excel 365** with its syntax, explanation, and examples. 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)

 

## **IMAGINARY – Function Description:**

- This function **returns the Imaginary Co-efficient** of a given complex number.
- For example, consider a complex number **a+bi** , after applying the **IMAGINARY function** it returns the value **b**.
- Where “ **a** ” is **a**  **real** part and “ **b** ” is an **imaginary** part.

## **Syntax:**

**=IMAGINARY(inumber)**

### Argument Explanation:

**Inumber** – A complex number in which you want to get the Imaginary co-efficient.

### **Note:**

- You can use COMPLEX function to convert real and imaginary coefficients to a complex number.

## **Examples:**

The following example has shown, how it gets the imaginary part of the complex number using this function.

- Kindly, see the active **cell B ** it shows the imaginary coefficient of the complex number given in a **cell A2**.

![Find Imaginary Co-efficient](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/1-27.png)<figcaption id="caption-attachment-11663">Find Imaginary Co-efficient</figcaption>

- You can use the COMPLEX function to convert real and imaginary coefficients to a complex number.

![COMPLEX Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/08/COMPLEX-Function.png)<figcaption id="caption-attachment-11660">COMPLEX Function</figcaption>

## **Closure:**

I hope, this article helped you to learn how to get the imaginary part from a complex number using **IMAGINARY Function in Excel 365** with its syntax, description, and examples. Leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Keep Reading:

- [How to Use BIN2HEX Function in Excel 365? {With example}](https://geekexcel.com/how-to-use-bin2hex-function-in-excel-365-with-example/)
- [How to Use DELTA Function in Microsoft Excel 365? – (With Examples)](https://geekexcel.com/how-to-use-delta-function-in-microsoft-excel-365-with-examples/)
How you decide what to focus on when learning something new?
Tags: discuss, help, career
Published: 2020-08-14 12:19:28

I struggle constantly with this. I want to learn everything. One day I'll wake up and decide I really want to dive into C but as I begin to prep, I talk myself out of it. The thoughts usually go something like this...

- C would be really cool to learn
- I should find a YouTube video that builds a simple project
- (searches for a good video for 30 minutes)
- (finds video)
- (opens IDE/vim)
- Wait, I probably should learn something more relevant to my day job if I'm going to be spending time on this today
- (closes video, closes IDE)
- goto 1, choose different topic

Some weekends I'll spend hours doing this with no progress. Most of the time I can convince myself that learning anything is always relevant, but it's hard some days. 

I think my problem boils down to something quite simple. If I don't have a clear goal or project, it's hard for me to focus.

Does anyone else suffer from this problem and if so, how do you navigate it?
Gaussian Elimination - [Linear Algebra #3]
Tags: computerscience, codepen
Published: 2020-08-14 12:14:08

#### Demo
{% codepen https://codepen.io/tlylt/pen/LYNVmMb %}

#### Gaussian Elimination
| Step | Detail                                                                                                                                     |
|------|-----------------------------------------------------------------------------------------------------------------------------------------------|
| 1    | Locate the leftmost column that does not contain all zero.                                                                                    |
| 2    | Interchange the top row with another row, so as to make the<br>leading entry of top row nonzero.                                              |
| 3    | For each row below the top row, add a suitable multiple of <br>top row so that all values below the leading entry of the <br>top row is zero. |
| ...  | Cover the top row and repeat as necessary to the rest of the<br>matrix.                                                                       |

#### Web Dev notes
* first-of-type only works on type such as div,p,etc, it does not work on [class](https://stackoverflow.com/questions/6447045/css3-selector-first-of-type-with-class-name).
* Use of animation keyframe for simple animations.
* Further extension could be adding error handling mechanisms and make the matrix re-sizable.
Função Equivalente ao setTimeout para o Flutter
Tags: dart
Published: 2020-08-14 12:04:48

Um cronômetro de contagem regressiva que pode ser configurado para disparar uma vez ou repetidamente.

O temporizador diminui da duração especificada para 0. Quando o temporizador atinge 0 chama a função de retorno de chamada especificada. 
```
var timer = Timer(Duration(seconds: 1), () => print('done'));
```

Fonte: https://api.dartlang.org/stable/2.4.0/dart-async/Timer-class.html
Como adicionar sombra ao TextFormField no Flutter
Published: 2020-08-14 12:03:42

Aprenda nesse tutorial como adicionar sombra ao TextFormField no Flutter utilizando o widget Material.

Você pode utilizar o TextFormFieldcom um Materialwidget e editar suas propriedades, como elevatione shadowColor.

Exemplo:
```dart
Material(
              elevation: 20.0,
              shadowColor: Colors.blue,
                          child: TextFormField(
                obscureText: true,
                autofocus: false,
                decoration: InputDecoration(
                    icon: new Icon(Icons.lock, color: Color(0xff224597)),
                    hintText: 'Password',
                    fillColor: Colors.white,
                    filled: true,
                    contentPadding: EdgeInsets.fromLTRB(20.0, 10.0, 20.0, 10.0),
                    enabledBorder: OutlineInputBorder(borderRadius:BorderRadius.circular(5.0),
                    borderSide: BorderSide(color: Colors.white, width: 3.0))
                ),
              ),
            )  
```
Você vai conseguir algo parecido com a imagem abaixo.
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/9x77tt9jwu45x1m1g28d.png)

Fonte: [stackoverflow.com](https://stackoverflow.com/questions/54194347/how-to-add-drop-shadow-to-textformfield-in-flutter)
Publicando Appbundle feito com Flutter na Play Store
Tags: android
Published: 2020-08-14 12:01:26

Solução para: Esta versão não está em conformidade com o requisito de 64 bits do Google Play

Solution for: This release is not compliant with the Google Play 64-bit requirement

O intuito deste post não é mostrar a fundo o conteúdo, por exemplo sobre como gerar as chaves de assinatura, item o qual é necessário para publicar seu app na loja. Vamos ao tutorial:

Adicione a seguinte linha no arquivo build.gradle dentro da pasta Android>App
```
ndk.abiFilters 'armeabi-v7a','arm64-v8a','x86','x86_64'
```
O Google exige que seu app possua a versão de 32 e 64 bits, então vamos primeiro gerar uma versão de 32 da seguinte forma no terminal dentro da pasta do projeto:
```
flutter build appbundle --release
```
Ao finalizar adicione no Play Console esta versão e agora vamos gerar a versão 64, porém fique atento pois agora teremos que mudar a versão no arquivo pubspec.yaml. Vai estar no topo do arquivo da seguinte forma caso você ainda não publicado nenhuma outra versão na loja:
```
version: 1.0.0+1
```
Mude para:
```
version: 2.0.0+2
```
Agora repita o comando no terminal, porém passaremos algumas informações a mais no terminal:
```
flutter build appbundle --release --target-platform=android-arm64
```
Pronto agora é só adicionar no Play Console junto ao outro.
How I learned flutter in 3 days 
Tags: flutter, github, android, app
Published: 2020-08-14 12:00:55

First of all, you can not learn everything about flutter in 3 days but you can learn most of the things needed to make a simple app. 

I am a data scientist and wanted to implement google PoseNet model on a mobile application. I have heard about flutter before and I always wanted to learn it so I combine both objectives. 

One more thing, I already knew other programming languages like python, C, C++, and Java. That helps a lot during the process of learning flutter. 

## Installation and Setup

I have used Ubuntu operating system for development so the installation process may not be for other operating systems. I would suggest you visit the official page of flutter for more information about installation and set up

[Flutter installation guide](https://flutter.dev/docs/get-started/install)

## Learning basic 

I have followed some YouTube playlist and flutter documentation to get familiar with dart and flutter. In my experience dart is very easy to learn if you already know other programming languages.

**YouTube tutorial**
{% youtube 1ukSR1GRtMU %}


**Official documentation**
[Flutter doc](https://flutter.dev/docs)

## Project

Once you get familiar with basic things you should start working on projects. I learned most while doing the project. During the project I faced very specific problems and solved them with the help of doc and stack overflow. To be honest you can't learn and master everything about a language so best way to Learn while doing. 

If you already don't have project idea search on GitHub and start with a project you like. 

In the beginning you can try to replicate a project from GitHub then slowly modify it according to your need.

Most importantly have fun while coding so don't think too much about usefulness of the apps in the beginning. 


![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/kur597cm8lquimoyipa6.jpg)
Daily Developer Jokes - Friday, Aug 14, 2020
Tags: jokes, dailydeveloperjokes
Published: 2020-08-14 12:00:03

---
title: "Daily Developer Jokes - Friday, Aug 14, 2020"
description: "Check out today's daily developer joke! (a project by Fred Adams at xtrp.io)"
series: "Daily Developer Jokes"
cover_image: "https://private.xtrp.io/projects/DailyDeveloperJokes/thumbnail_generator/?date=Friday%2C%20Aug%2014%2C%202020"
published: true
tags: #jokes, #dailydeveloperjokes
---

Generated by Daily Developer Jokes, a project by [Fred Adams](https://xtrp.io/) ([@xtrp](https://dev.to/xtrp) on DEV)

___Read about Daily Developer Jokes on [this blog post](https://xtrp.io/blog/2020/01/12/daily-jokes-bot-release/), and check out the [Daily Developer Jokes Website](https://dailydeveloperjokes.github.io/).___
### Today's Joke is...
![Joke Image](https://private.xtrp.io/projects/DailyDeveloperJokes/public_image_server/images/5e12589ca2833.png)

---
*Have a joke idea for a future post? Email ___[xtrp@xtrp.io](mailto:xtrp@xtrp.io)___ with your suggestions!*

*This joke comes from [Dad-Jokes GitHub Repo by Wes Bos](https://github.com/wesbos/dad-jokes) (thank you!), whose owner has given me permission to use this joke with credit.*

<!-- 
Joke text:
___Q:___ Why was the function sad after a successful first call?

___A:___ It didn’t get a callback.
 -->
How to make local Azure Static Web App development easier
Tags: azure, azurestaticwebapp, azurefunctions, staticsites
Published: 2020-08-18 06:45:02

---
title: How to make local Azure Static Web App development easier
published: true
date: 2020-08-14 11:40:12 UTC
tags: 
  - Azure
  - AzureStaticWebApp
  - AzureFunctions
  - StaticSites
canonical_url: https://www.eliostruyf.com/local-azure-static-web-app-development-easier/
---

Static sites are cool again (actually for a long time), and Microsoft knows that. Their new Azure Static Web App - App Service is currently in preview. At the moment, it still misses some key functionalities, but I am sure that these will get added once they put it in GA (hopefully to be announced at Ignite in September 2020).

> **Info** : The features I am mostly missing are the capability to link your Azure AD App and root domain configuration (at the moment only `www` works). Also, the option to gain access to the Storage Account the Functions are using might be useful.

The learning paths and documentation are a great way to get you started ([Azure Static Web Apps documentation](https://docs.microsoft.com/en-us/azure/static-web-apps/)). Suppose you followed any of the learning paths or documentation for local development. They tell you how to start your Azure Functions and local server with `Live Server` extension for VSCode.

My preference is to run it without the VSCode extension. Instead, I make use of NPM scripts. By using a script, I can run and test it anywhere I want.

## Running static web app locally

To run the static web app locally, you will need the following NPM dependency: `npm-run-all`. If you want, you can also use `concurrently`, but my preference is the first one.

This dependency allows you to run multiple commands sequentially or in parallel. For the static web app, this is what we need. We need the server for the site, and the Azure Functions instance both running at the same time.

Here is my default configuration:

```
"scripts": {
  "start": "npm-run-all --parallel start:*",
  "start:dev": "react-scripts start",
  "start:api": "cd api && npm start"
}
```

> **Info** : I like to use React, but if you use any other framework, be sure to modify the `start:dev` command to build and spin up your local server.

All you need to do is run the `npm start` command, and both services will start locally.

 ![](http://feeds.feedburner.com/~r/estruyf/~4/LdDxB-mWgH4)
Hi , i'm beginner and i need some suggest for development.
Tags: help, beginners, javascript, devops
Published: 2020-08-14 11:26:51

Hi everyone , once nice to meet you with all of you 🙏🏻

İ want to be a good developer so i watch a lot of videos and i make too much apps but i don't here where i want to be.

So i know basically JS , angularJS , CSS , HTML , SQL. 

İ want to make professional jobs how can I do this ?
What is your suggest for my main object ?
What can I do for that do you have any resource for me ?

Thank you so much :)
Building the backend - Part II (Live tweet sentiment analysis)
Tags: python, docker, machinelearning
Published: 2020-08-14 11:22:19

In the previous article, I explained how to build a sentiment classifier. Read it  [here](https://amalshaji.wtf/building-the-classifier-ckdu3pnrd001fn0s1c9lu0fbf). I this, we'll create the backend to serve predictions via an API.

### Building the API
`make sure you're in the backend folder` 

#### API
```python
# server.py

import nltk
import uvicorn
import utils as utils
from fastapi import FastAPI
from pydantic import BaseModel
from classify import remove_noise
from nltk.tokenize import word_tokenize

app = FastAPI()
classifier = utils.load_model()

class Tweet(BaseModel):
    tweet: str

@app.get("/")
def read_root():
    return {"message": "Welcome to sentiment classifier API"}

@app.post("/api")
def analyse_tweet(tweet: Tweet):
    custom_tokens = remove_noise(word_tokenize(tweet.tweet))
    result = classifier.classify(dict([token, True] for token in custom_tokens))
    return {"sentiment": result}

if __name__ == "__main__":
    uvicorn.run("server:app", host="0.0.0.0", log_level="info")
```
This is similar to the other articles where I showed how to build APIs using  [FastAPI](https://amalshaji.wtf/build-a-url-shortener-using-fastapi-and-redis-ckdofzjwi01i8bzs1ay54f3nh). Only change is that, In the previous ones, we launched the server using `uvicorn main: app`, here we're doing it programmatically. This way we can run the server using `python server.py`

#### Dockerize the API
```Dockerfile
FROM python:3.8-slim

WORKDIR /app

COPY requirements.txt .

RUN pip install -r requirements.txt

COPY . .

RUN python3 -m nltk.downloader punkt
RUN python3 -m nltk.downloader wordnet
RUN python3 -m nltk.downloader stopwords
RUN python3 -m nltk.downloader averaged_perceptron_tagger

EXPOSE 8000

CMD ["python3", "server.py"]
```

#### Build and run the image
```bash
docker built -t sentwitter-backend .
docker run -d -p 8000:8000 setwitter-backend
```
#### Test the API
```bash
❯ docker run -d -p 8000:8000 sentwitter_backend
ccd9fa0740cfd0f497308ef570e16c950233c29378029aac61c1479cc94163bc

❯ curl http://localhost:8000
{"message":"Welcome to sentiment classifier API"}

❯ curl -X POST "http://localhost:8000/api" -H  "accept: application/json" -H  "Content-Type: application/json" -d "{\"tweet\":\"I hate you\"}"
{"sentiment": "Negative"}
```

We have successfully built the backend. In the next article, we'll build a frontend that retrieves tweets and sent to the backend for prediction.

### References
- Article Cover by [Taylor Vick](https://unsplash.com/@tvick)
🚀The one secret of web performance
Published: 2020-08-14 11:16:24

I have been seen many articles on the internet about web performance and they have titles like “Top 5 secrets to boost your PHP performance” and “15 tips to improve the performance of your site” and yeah, they are really helpful, but we need to stop looking for hacks and quick tips and start to look deeper for what is performance.

## Why are you looking for performance?

Your boss came with some explicit orders from the client to test the web performance of a project that you just finished recently.

They are like “OMG, the SEO tool requires a good site performance. What we do??” And there is where you enter. You need to test your own site performance and is faced with something like that:

![A report from Google PageSpeed Insights](https://dev-to-uploads.s3.amazonaws.com/i/ckkmlq8s8k7ifvymzjjt.png)

> This really hurts, don’t?

You have a long way to go now. And to think that you would never touch this site again…

## What is performance?

If you are a runner, you always do your best to improve yourself. You don’t just buy a new pair of shoes and think that you’re the fastest runner on the planet.

How the development cycle of your applications is? Do you pay attention to what decisions you take off while programming or go back to any part of your code that doesn’t really like the implementation?

Do you like refactoring your code and always are searching for ways to increase the quality or you just make some configurations in your webserver to cache faster and that’s enough?

> Performance is a culture.

When you code something that works but don’t stop to overthink how that can affect your application in production scenarios, this can blow off all those articles about performance.

These articles can’t help you with structural issues. This is something much deeper. For that, you need to understand that programming language you are coding and the best solution gave by her based on your knowledge about data structured and requirements of the project.

Performance can be hard. There so many skills involved, like browser and network performance, web server, and… I’m getting sleepy.

Doing this, you can apply performance culture in every project and learn a lot with this. I know, sometimes can be really boring, but when you understand why you are doing this, became so much acceptable (I say this because still boring, but now you know that you are saving the user’s life and 3G, for sure).

> I can say for myself, performance can be a topic really interesting.

🎯 CHALLENGES

- Choose one project and start to analyze it. There is something that can be done in a different way?
- Take metrics from different methods in a programming language that do similar things (a for loop, while and forEach), compare them and find the best one for your implementation
- Code the way you know first and then spend some time refactoring your code
Ng Hacks: Series Introduction
Tags: angular, tutorial, nghacks
Published: 2020-08-14 11:03:40

Hi
This is my first ever technical writing. I used to read your posts silently. I read a lot of benefits of writing but couldn’t write something by myself. I’d got mixed feelings. This time I determined that I must write and I will write. And here it is. I wish to have your Indulgence.🤗

We developers always stuck into problems. We spend hours on finding solutions. Sometimes it seems impossible. But somehow we come up with a solution, does not need to be the perfect one. Everyone knows the term “hack” or “workaround”. Almost every developer does the practical implementation of this term. It can be because of the deadline, tight task estimation, lack of knowledge, or maybe the bug in the technology itself. I also did some hacky implementation with Angular. This series is about those hacks.

_**Note:** This series of articles shows hacks & workaround solutions. And also may contain bad practices. Please take it with that concern on your mind. Your opinion can be different on things and that's fine. Let me know your thoughts. These are the hacks that worked for me._

This series belongs to this [repo](https://github.com/abdunnahid/nghacks):

{% github abdunnahid/nghacks %}

Let the hacking begin.
Wish me luck. 😇
using jQuery-like syntax to scrap websites
Tags: scraping, jquery, javascript, go
Published: 2020-08-14 10:57:09

Without introduction, let's play with a simple tool that may help you scraping any HTML content easily and building a JSON based API from it.

Our tool is called `Scraply`, it is developed in `Golang`, and utilizes `HCL` and `Javascript` to simplify the configurations and scraping process.

Each scraping operation is called `macro`, a macro is just a simple configuration to scrap a specific URL, let's see an example.

```hcl
macro sqler {
    url = "https://github.com/alash3al/sqler"
    ttl = 120
    exec = <<JS
        exports = {
            title: $('title').Text(),
            description: $('meta[name="description"]').AttrOr('content', '')
        }
    JS
}
```

In the above example, we defined a macro called `sqler` and set the URL of the page we want to scrap its info, as well as a TTL in seconds (for caching purposes) and the execution code.

Let's say that we saved the above content in a file named `test.scraply.hcl`, now we can start the scraply engine by running the following command where we saved the file
```bash
$ /path/to/scraply_bin 
```

if you want to dig more into the tool and read more about it, just go to its repo from [here](https://github.com/alash3al/scraply)
Introduction to Numerical Computing with NumPy
Tags: datascience, machinelearning, 100daysofcode, asquero
Published: 2020-08-14 10:55:11

Being a Data Science enthusiast, it is very necessary to have basic skills in NumPy, which is a Numerical Computing Python library and helps a lot in the Data Cleaning process.

Below given is a series of tutorials we should start with whenever we plan to work with NumPy.

Introduction to NumPy arrays and their Attributes - https://lnkd.in/gcfzUj4

Array Indexing in NumPy - https://lnkd.in/gQkhwvT

Array Slicing in NumPy - https://lnkd.in/gvMNHeb

Array Reshaping in NumPy - https://lnkd.in/gvW2Mu3
Branding your Toradex TEZI install experience
Tags: toradex, linux, tutorial, tezi
Published: 2020-08-14 10:53:58

Once you have managed to produce a nice TEZI installer image, you will have the option to do some branding:

1. **logo**: a 32x32 log shown next to your image entry in the TEZI installer view
2. **marketing.tar**: in this tarball you find folder called `slides_vga`. Here you can place your slideshow as a sequence of png files, e.g. A.png, B.png, ...
3. **image.json**: this one has description and name and other fields that TEZI installer will surface in human readable areas (aka brand)

Remember the png's in marketing.tar are not getting auto scaled by TEZI installer; instead you have to ensure they are sized 640x400 pixel. I used the following command on linux to do that:

```
# this will replace A.png with the resized version
convert slides_vga/A.png -resize 640x400\> slides_vga/A.png
```

Happy Branding!