teleren/devto huggingface dataset:
How to Use Excel MOD Function in Office 365? – {with Examples}
Tags: excelfunctions, excelmodfunctioninof
Published: 2020-08-25 06:31:14

---
title: How to Use Excel MOD Function in Office 365? – {with Examples}
published: true
date: 2020-08-24 12:32:24 UTC
tags: ExcelFunctions,ExcelMODFunctioninOf
canonical_url: https://geekexcel.com/how-to-use-excel-mod-function-in-office-365-with-examples/
---

## Excel MOD Function:

In this article, we are going to learn the usage of **Excel MOD Function in Office 365** with its syntax, description, and examples. 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)



## **MOD Function – Description:**

- This function **returns the remainder of the two numbers after division**.
- The result has the same sign as the divisor.
- For example, **MOD(13,6)** returns **1** as a remainder.

## **Syntax:**

**=MOD(number, divisor)**

### Parameter Explanation:

**Number** – The input number to be divided.

**Divisor** – The number by which you want to divide the number.

### Note:

- If the divisor is 0, it returns **#DIV/0!** Error value.
- You can calculate MOD manually by using the below formula.
- “**n – d \* INT (n/d)**” where n is a number, d is a divisor.

## **Example:**

Let’s see some examples to make it clear.

## Example 1:

- Refer to the below example image.
- The input numbers are given in **Column A** and its divisors are given **Column B**. The remainders are listed in **Column C**.

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

### Example 2:

- If the divisor is 0, it returns **#DIV/0!** Error value.

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

## **Wrap-Up:**

In this article, you can understand the usage of **Excel MOD Function in Office 365** with its syntax, description, and examples. Give your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### See Also:

- [Excel FACTDOUBLE Function in Excel 365](https://geekexcel.com/how-to-use-excel-factdouble-function-in-office-365/)
- [LOG10 Function in Excel 365 – {with Examples}](https://geekexcel.com/how-to-use-excel-log10-function-in-office-365-with-examples/)
your language PATH ...
Tags: languages
Published: 2020-08-24 13:01:05

---
title: your language PATH ...
published: true
description: 
tags: languages
//cover_image: https://direct_url_to_image.jpg
---

Great twitter thread
https://twitter.com/Grady_Booch/status/1297683779931144192

I had to think about my own path.

BASIC -> assembly -> PASCAL -> C -> C++ -> Java -> Visual Basic -> COM (not a language) -> SQL -> Python -> Javascript -> Perl -> bash -> PL/SQL -> C#.dot net -> VB.dot net -> JS.dot net ->  more C# -> lua -> Clojure -> Racket

I think I missed some and COM is not a language but it was a moment where I really thought about function pointers and how binaries were put together at runtime. So I included it. Ha.
AzureFunBytes - Kubecon Europe Virtual: Debrief & Roundtable - Day 2 Video Recap with @CodeFresh
Tags: kubernetes, azure, cloud, containers
Published: 2020-08-24 12:55:40

Well KubeCon Europe has come to an end, which means there was tons to discuss in regards to new features.  I joined this group of experts to discuss some of the happenings around Kubernetes.  We discuss new storage options, increasing velocity for Windows Containers, and Kubernetes 1.19.

{% youtube mvU1pQmyFww %}

TIMESTAMPS 

[00:00](https://www.youtube.com/watch?v=mvU1pQmyFww&t=0s) - Intro
[03:36](https://www.youtube.com/watch?v=mvU1pQmyFww&t=216s) - What is new in Kubernetes 1.19
[22:05](https://www.youtube.com/watch?v=mvU1pQmyFww&t=1325s) - GitOps Operators- ArgoCD & Flux 
[30:30](https://www.youtube.com/watch?v=mvU1pQmyFww&t=1830s) - Favorite talks of Day 2 at Kubecon 
[44:39](https://www.youtube.com/watch?v=mvU1pQmyFww&t=2679s) - Proactive event monitoring and resiliency in K8s environments 
[47:05](https://www.youtube.com/watch?v=mvU1pQmyFww&t=2825s) - Contour CNCF announcement 
[49:52](https://www.youtube.com/watch?v=mvU1pQmyFww&t=2992s) - Recommended CNCF graduated projects

AzureFunBytes! - Byte-sized content with a live Twitch show!

Learn about Azure fundamentals with me!

Live stream is available on Twitch at 2 pm EDT Thursday. You can also find the recordings there as well.

https://twitch.tv/azurefunbytes
https://twitter.com/azurefunbytes

Join me, ask questions, and learn about Azure!

Useful Docs:
Azure Kubernetes Service (AKS) - https://cda.ms/1vq
App Service documentation - https://cda.ms/1vr
Azure Container Registry documentation - https://cda.ms/1vs
Microsoft Learn: Azure Fundamentals - https://cda.ms/1jV
Microsoft Azure: $200 Free Credit https://cda.ms/1tj
Django or Ruby on Rails: Which web framework has a more promising future?
Tags: django, ruby, webdev, python
Published: 2020-08-24 12:49:05

What do you mean by Django?
Introduced in the year 2005, Django happens to be a web framework that is based on Python. The reasons for its popularity are the fact that it is an open-source, general-purpose, and free framework that is accessible quite easily. There are many developers who appreciate the features provided by Django. The primary intention of its introduction on the market was to streamline the procedure of developing complicated websites. In fact, it comes with a tidy as well as the pragmatic interface while encouraging development as well.
The pros

•          Extremely customizable

•          Scalable

•          Adopts a battery-included approach

•          Effectual admin panel

•          Supports MVC programming

•          Can work extremely well with operating systems and databases

The cons

•          Does not have the capacity to take care of multiple requests at the same time

•          Extremely monolithic

•          Based on Django ORM

 
What do you mean by Ruby on Rails?

Acronymed as RoR, Ruby on Rails happens to be an open-source, server-side web application framework. It offers astounding default structures for Web services, databases, and pages. One can consider it to be a timesaving process of writing code for the developers.

The pros

•          High-speed development

•          Simple to migrate and modify

•          Superior environment for testing

•          Active Ruby on Rails community

•          Diverse presets and tools

The cons

•          Difficult to create API

•          Does not have much flexibility

•          Reduced runtime speed

Now that we have looked at the essential advantages and disadvantages of both these web development frameworks, we will mention the differences that exist between these two.

Learn more in details: https://rlogicaltechsoft.blogspot.com/2020/08/django-or-ruby-on-rails-which-web.html
How Do you Estimate, Mate!
Tags: softwaredevelopment, practices, developer, management
Published: 2020-08-24 12:46:09

---
title: How Do you Estimate, Mate!
published: true
description: Discussion around the right way to estimate the software Development.
tags: softwareDevelopment, practices, developer, management
//cover_image: https://direct_url_to_image.jpg
---
Heya Guys,

Most Software Developer beliefs there are two hard problem that exists: [https://martinfowler.com/bliki/TwoHardThings.html]
1st one is how to Name things correctly.
2nd one is to invalidate cache.

But there exists a more dangerous hidden problem that creep out once you start growing in terms of team size, i.e. how do you estimate the time requires for a development of any feature.

From my experience it is totally subjective and depends upon the experience and on your technical debt,so keeping them aside I want to know how you guys estimate any development process and what according to you work or will not work.
What are the best practices to do this so that neither the dev feels frustrated & overburdened and nor the management feels too bad about it.

@rfornal, love to listen your views.
📣 v0.3 for GraphQL API for WordPress released
Tags: graphql, wordpress, news
Published: 2020-08-24 12:41:34

Version 0.3 for the [GraphQL API for WordPress](https://github.com/GraphQLAPI/graphql-api-for-wp/) was just [released](https://github.com/GraphQLAPI/graphql-api-for-wp/releases/tag/v0.3).

### New features

- Filter modules by type
- Use different colors to distinguish modules by type
- Documentation for all modules, accessible clicking on "View details" on each module
- Documentation for modals inside blocks
- Module `Remove if Null` to add directive `@removeIfNull`
- Module `Proactive Feedback` to send data about deprecations, warnings, logs, notices and traces in the response to the query
- Module `Multiple Query Execution` to enable/disable functionality
- If module `Multiple Query Execution` is disabled:
    - Directive `@export` is also disabled
    - The server respects the GraphQL spec concerning `operationName` (https://spec.graphql.org/draft/#GetOperation())

The full CHANGELOG is [here](https://github.com/GraphQLAPI/graphql-api-for-wp/blob/master/CHANGELOG.md).
Golang Web - Hello World
Tags: backend, go, webdev
Published: 2020-08-24 12:31:46

Hi there! today i gonna show you how to create the Hello World in Go-language, so lets do it.

* First Step u Should to import (fmt, and net/http)

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

* Next, create two function for the Request

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

* Last step, create function main and add the Route

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

* And then open the terminal and your Browser

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

Finally! Congrats for your first Website with Go.

Enjoy it!.
Blocking twitter trolls (1): Blocking retweeters
Tags: twitter, tweepy, python
Published: 2020-08-24 12:29:38

Twitter is one of the most popular platforms for fandom activities, especially my fandom, and for the past years I've found a lot of mutuals I like to interact with. On the other hand, the deeper you're into the fandom, the more you encounter unreasonable tweets. You have many options: ignore, mute, or block. If you wish not to engage with any of those people in the future, you can automatically block (or mute) the original poster and the people who retweeted with the script below. 

You'll need a Twitter developer account (apply [here](https://developer.twitter.com/en/apply/user.html)) with 'Read and Write' permission. The full script is posted on [my github](https://gist.github.com/azukacchi/0263fcc20f2a0ce8ba6ed06bdcffedcf).

{% gist https://gist.github.com/azukacchi/0263fcc20f2a0ce8ba6ed06bdcffedcf %}

Note that by blocking them all at once you've shut down all the opportunities for any type of interaction with those people. I personally would like to read people's sentiment about a topic, but you'd know a troll tweet when you spot one. What this script does is block those people, but the judgment is yours.
How to Use Excel MINVERSE Function in Office 365? – with Examples
Tags: excelfunctions, excelminversefunctio
Published: 2020-08-25 03:39:39

---
title: How to Use Excel MINVERSE Function in Office 365? – with Examples
published: true
date: 2020-08-24 12:29:35 UTC
tags: ExcelFunctions,ExcelMINVERSEFunctio
canonical_url: https://geekexcel.com/how-to-use-excel-minverse-function-in-office-365-with-examples/
---

## MINVERSE Function in Excel:

In the post, you will learn the usage of **Excel MINVERSE Function in Office 365** with its syntax, description, 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)


## **MINVERSE Function – Description:**

- This function **returns the inverse matrix of the given array**.
- The input array must be a square matrix that contains an equal number of rows and columns.

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

## **Syntax:**

**=MINVERSE(array)**

### Argument Description:

**Array** – The input array with equal number of rows and columns.

### Note:

- If the input array doesn’t have an equal number of rows and columns, it returns the **#VALUE!** Error.
- If any cells in the array are empty or contain the string values, this function returns the **#VALUE!** Error.
- Some square matrices cannot be inverted, in that case, it will return **#NUM!** Error.

## **Example:**

Let’s see some examples below.

### Example 1:

- Refer to the below example image.
- The input matrix is given in the range “ **A2:B3″ ** and the inverted matrix is given in the range “ **D2:E3** “.
- After entering the formula in the formula bar. To get the proper output, You have to press the following keys **CTRL SHIFT ENTER**

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

### Example 2:

- If the input array doesn’t have an equal number of rows and columns, it returns the **#VALUE!** Error.
- If any cells in the array are empty or contain the string values, this function returns the **#VALUE!** Error.

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

## **Verdict:**

In this post, you can understand the usage of **Excel MINVERSE Function in Office 365** with its syntax, description, and examples. Drop your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Similar Articles:

- [**MDETERM Function in Excel**](https://geekexcel.com/how-to-use-excel-mdeterm-function-in-office-365-with-examples/)
Lego Webcam
Tags: codepen, glsl, lego, pixelart
Published: 2020-08-24 12:29:05

<p>My last <b>WebGL</b> experiment for <a href="https://codepen.io/tag/codepenchallenge">#codepenchallenge</a> <a href="https://codepen.io/tag/cpc-fell-in-love">#cpc-fell-in-love</a> by <a href="https://codepen.io">CodePen</a>.</p>

<p>A tribute to one of my favourites videoclip of all times: <a href="https://www.youtube.com/watch?v=fTH71AAxXmM"><b>Fell in love with a girl</b></a> by <i>The White Stripes</i> directed by <i>Michel Gondry</i>.</p>

<p><img src="https://dev-to-uploads.s3.amazonaws.com/i/2kn6be4jwtfjeynhdx43.jpg" /></p>

{% instagram CERBUB2Ka6p %}

{% codepen https://codepen.io/Grooo/pen/RwaGbdp %}

{% tag lego %}{% tag glsl %}
Big O Time/Space Complexity Types Explained - Logarithmic, Polynomial, Exponential, and More
Tags: bigo, bigonotation, algorithms, programming
Published: 2020-08-24 12:25:05

Hi all,

Today I will talk about the most important time and space complexity types. Time and space complexities are a measure of a function's processing power and memory requirements. Many time/space complexity types have special names that you can use while communicating with others. While some of the names for complexity types are well known, like linear and constant time, some others are living in the shadows, like quadratic and factorial time. In this video, I will use the big O notation to denote the complexities, which is specifically used to describe the worst-case performance of algorithms. If you want to see or read it, below are the links for the video and article:

Video: https://www.youtube.com/watch?v=GesAhP5jYLo
Article: https://quanticdev.com/articles/primitives/big-o-time-space-complexity-types-explained

Outline of the video/article:
* Overview
* Constant Time/Space Complexity: O(1)
* Logarithmic Complexity: O(logn)
* Linear Complexity: O(n)
* Polynomial Complexity: O(n^k)
* Exponential Complexity: O(2^n)
* Factorial Complexity: O(n!)
* Alternative Big O Notation
* Conclusion

I suggest the video format as it has animations for the references algorithms, which can help you comprehend them easier. Have fun learning!
How to Get Last Executed Query in Laravel?
Tags: php, laravel
Published: 2020-08-24 12:24:46

We have been many time need to get executed query log or you want to get last executed query or maybe if you want to diaplsy sql query from laravel query builder then you can do it that. so i have three example for display executed query in Laravel 5. when you are working on laravel application at that times , i think you need many time to print last run query or if you want to check direct from phpmyadmin sql box, so at that time you have to follow this three example. so, let's see three example of getting sql query from Laravel Query Builder.

<h2>Example 1:</h2>

In this example we can get directly get current sql query using toSql() of laravel query builder. In this example you don't need to enable query log or something you can directly query like bellow example:

<pre>
$user = User::where('id',1)->toSql();
print_r($user);
</pre>

<h2>Example 2:</h2>

Ok, In this example we must need to enable query log using DB::enableQueryLog() of Laravel Query builder. enableQueryLog() will give access to store all execute query in cache and we can get that query using DB::getQueryLog(). In this example you will get all query log not last only. bellow example how to use it together.

<pre>
DB::enableQueryLog();
$user = User::get();
$query = DB::getQueryLog();
print_r($query);
</pre>

<h2>Example 3:</h2>

In this example i make the same as example 2, but you can get exactly last query using end(). so let's see how to use.

<pre>
DB::enableQueryLog();
$user = User::get();
$query = DB::getQueryLog();
$query = end($query);
print_r($query);
</pre>

By default query log is disabled in Laravel 5, so don't forget to enable it before getting query log.


<h2>Example 4:</h2>

<pre>
public function querylog()
    {
        \DB::enableQueryLog();
        $list = \DB::table("categories")->get();
        $query = \DB::getQueryLog();
        print_r(end($query));
    }
</pre>

<b>output</b>
<pre>
  Array ( [query] => select * from `categories` [bindings] => Array ( ) [time] => 8.09 )
</pre>

<h2>Example 5: Echo Last Executed Query In Laravel</h2>

To See last Executed query in Laravel 5 we need to enable query log of laravel.To Enable query log use "DB::enableQueryLog()" function before query. As we know DB::getQueryLog() function of laravel return all executed queries.To get last query we will use end() function which return last executed query.

<pre>
$query = DB::getQueryLog();
$lastQuery = end($query);
</pre>

Before getting query log you need to first enable it by using DB::enableQueryLog() function and then you can get all executed queries.

<pre>
DB::enableQueryLog();
$users= DB::select('select * from user where 1');
$query = DB::getQueryLog();
$lastQuery = end($query);
print_r($lastQuery);
</pre>

<b>output</b>

<pre>
Array ( [query] => select * from user where 1 [bindings] => Array ( ) [time] => 0.39 )
</pre>

Ref Source : <a href="https://www.pakainfo.com/last-query-in-laravel/">last query in laravel</a>

It will help you...
wheredate in laravel	
Tags: php, laravel
Published: 2020-08-24 12:15:59

whereDate / whereMonth / whereDay / whereYear / whereTime. The whereDate method may be used to compare a column's value against a date:

<h2>whereDate()</h2>

whereDate() through we can make condition like date even column datatype timestamps. you can see bellow example how it is work.

<b>Example:</b>
The whereDate method may be used to compare a column's value against a specifice date.you can see bellow example how it is work.

<pre>
$products = DB::table('products')
            ->whereDate('created_at', '2021-09-03')
            ->get();
dd($products);
</pre>

<b>output</b>
<pre>
Illuminate\Support\Collection Object

(

    [items:protected] => Array

        (

            [0] => stdClass Object

                (

                    [id] => 2

                    [name] => Gold

                    [description] => Gold Brand

                    [created_at] => 2021-09-03 00:00:00

                    [updated_at] => 2021-09-01 00:00:00

                )

            [1] => stdClass Object

                (

                    [id] => 4

                    [name] => Toll

                    [description] => Toll Brand

                    [created_at] => 2021-09-03 00:00:00

                    [updated_at] => 2021-09-05 00:00:00

                )

        )

)
</pre>

Source : <a href="https://www.pakainfo.com/wheredate-in-laravel/">wheredate in laravel</a>

It will help you...
HOW LEAD BOTS CAN FUEL YOUR LEAD GENERATION EFFORTS IN 6 DIFFERENT WAYS
Tags: leadgenerationagencyindubai, ppcmanagementagencyindubai, socialmediamarketingindubai, googleadsindubai
Published: 2020-08-24 12:14:19

Leads are the eligible prospects who can become clients and envoys of your brand when you do your best. Of course, a firm may have a few significant objectives, however an enormous level of organizational objectives center around lead generation.
Lead generation marketers, especially B2C marketers, depend on a few channels to drive leads to their organizations and lift their conversion rate.
Know more about on https://www.prism-me.com/blog/how-chatbots-can-help-lead-generation
How to Use Excel MROUND Function in Office 365? – [with Examples]
Tags: excelfunctions, excelmroundfunctioni
Published: 2020-08-25 03:40:27

---
title: How to Use Excel MROUND Function in Office 365? – [with Examples]
published: true
date: 2020-08-24 12:13:49 UTC
tags: ExcelFunctions,ExcelMROUNDFunctioni
canonical_url: https://geekexcel.com/how-to-use-excel-mround-function-in-office-365-with-examples/
---

## MROUND Function in Excel:

In this article, you will understand the **Excel MROUND Function in Office 365** with its syntax, description, 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)


## MROUND Function – Description:

- This function **returns a number rounded to the given multiple**.
- It will round the number to the nearest multiple ( **“±” to the multiple value** ) of the given input value.

## Syntax:

**=MROUND(number, significance)**

### Argument Description:

**Number** – The input number that you need to round.

**Significance** –  The “ **multiple** ” by which you want to round the number.

### Note:

- The number and significance must have the same sign, else it returns **#NUM!** Error value.
- If you use any non-numeric values such as letters or special characters, it returns **#VALUE!** Error.

## Examples:

Here are the examples of the **MROUND** Function.

### Example 1:

- Refer to the below example.
- The input numbers and its multiples are given in **Column A and B**. The rounded output values are listed in **Column C**.

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

### Example 2:

- The number and significance must have the same sign, else it returns **#NUM!** Error value.

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

## Verdict:

In this article, you can understand the usage of **Excel MROUND Function in Office 365** with its syntax, description, and examples. Give your **suggestions** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Keep Reading:

- [How to Use Excel “FACT Function” in Office 365? – {with Examples}](https://geekexcel.com/how-to-use-excel-fact-function-in-office-365-with-examples/)
- [How to Use Excel EXP Function in Office 365? – [With Examples]](https://geekexcel.com/how-to-use-excel-exp-function-in-office-365-with-examples/)