teleren/devto huggingface dataset:
Update: What's New in the Diamond Standard EIP?
Published: 2020-08-20 11:45:49

The [Diamond Standard](https://eips.ethereum.org/EIPS/eip-2535) has just had its largest revision in months published.

See it here: https://eips.ethereum.org/EIPS/eip-2535

So what's new?

The standard tries to do a better job at introducing diamonds and explaining how they work. Did it succeed?

The Diamond Standard was originally written before [diamond storage](https://dev.to/mudgen/what-is-diamond-storage-3n7c) existed. Parts of the standard have been rewritten to introduce and show diamond storage and its use in facets. The standard also explains the flexibility, composability and modularity of facets.

The standard now features three diagrams showing the structure of a diamond and diamond storage, and how facets can be reused.

The standard has been modified to make it clearer that the `diamondCut` function is optional and just exists for interoperability with tools. People can create their own custom functions or different versions of `diamondCut` with different parameter types that add/replace/remove functions.

The `diamondCut` function has two new arguments.  These new arguments exist to enable a function to be executed to initialize or setup or tear down things after functions have been added/updated/removed from a diamond.

The example of a diamond in the standard was removed. Look at the [reference implementation](https://github.com/mudgen/Diamond) for an example.

The way a diamond is defined and explained has changed.  In the past a diamond was described as a proxy contract that supported multiple logic/delegated contracts. Now the standard describes a diamond as a contract that gets its external functions from other contracts. It is a conceptual difference. The word "proxy" is no longer used anywhere in the standard to describe a diamond.

The standard includes a compiled list of diamond benefits.

A new "Learning & References" sections has been added to the standard that provides links to useful diamond resources.
How to Use Excel FLOOR.PRECISE Function in Office 365?
Tags: excelfloorprecisefun, excelfunctions
Published: 2020-08-21 16:56:25

---
title: How to Use Excel FLOOR.PRECISE Function in Office 365?
published: true
date: 2020-08-20 11:41:29 UTC
tags: ExcelFLOORPRECISEFun,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-excel-floor-precise-function-in-office-365/
---

## FLOOR.PRECISE Function in Excel:

Here, we are going to explore how to use the **Excel FLOOR.PRECISE 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)

 

## FLOOR.PRECISE Function – Description:

- This function **rounds a given number to the specified multiple**.
- It always rounds a negative number away from zero.

## Syntax:

=**FLOOR.PRECISE(number, [significance])**

### Parameter Description:

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

**Significance** – It is optional. Multiple to use when rounding input value. If you omit significance, it will take 1 as its value.

### Note:

- If you give non-numeric values such as letters and special characters to any argument, it will return **#VALUE!** Error.

## Examples:

Let’s see some examples to understand this concept.

### Example 1:

- Refer to the below screenshot.
- You can see the input **numbers** in **Column A** , and its **significance** value in **Column B, ** the result is listed in **Column C**.

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

### Example 2:

- If you give non-numeric values such as letters and special characters to any argument, it will return **#VALUE!** Error.

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

## Wind-Up:

In this article, you can understand how to use the **Excel FLOOR.PRECISE 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!!

### Similar Articles:

- [**FLOOR Function in Excel **](https://geekexcel.com/how-to-use-excel-floor-function-in-office-365-with-examples/)
- [**FLOOR.MATH Function in Excel**](https://geekexcel.com/how-to-use-excel-floor-math-function-in-office-365/)

### Read Also:

- [How to Use Excel FACTDOUBLE Function in Office 365?](https://geekexcel.com/how-to-use-excel-factdouble-function-in-office-365/)
- [How to Use IMPRODUCT Function in Excel 365? – [with Examples]](https://geekexcel.com/how-to-use-improduct-function-in-excel-365-with-examples/)
How to Use Excel “FLOOR.MATH” Function in Office 365?
Tags: excelfloormathfuncti, excelfunctions
Published: 2020-08-21 16:56:39

---
title: How to Use Excel “FLOOR.MATH” Function in Office 365?
published: true
date: 2020-08-20 11:37:59 UTC
tags: ExcelFLOORMATHFuncti,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-excel-floor-math-function-in-office-365/
---

## Excel FLOOR.MATH Function :

In this post, we will guide you to know the usage of **Excel FLOOR.MATH Function in Office 365** with its syntax, definition, 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)

 

## FLOOR.MATH Function – Definition:

- **FLOOR.MATH Function** is used to **round a given number to a specified multiple**.
- This function provides support for rounding negative numbers.
- If it is a positive number with decimal values, it could be rounded to the nearest integer.
- If it is a negative number with decimal values, it could be rounded away from zero.

## Syntax:

**=FLOOR.MATH(number, [significance], [mode])**

### Arguments Description:

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

**Significance** – It is optional. The multiple for rounding the input number. If you cannot give significance value, it takes 1 by default.

**Mode** – It is optional. The mode is a direction to round the negative numbers round (towards or away from 0).

### Note:

- If any of the arguments is a non-numeric value, it returns **#VALUE!** Error.

## Examples:

The following examples help you to make it clear.

### Example 1:

- Refer to the below screenshot.
- You can see the **Input number** in the **Cell A4** , its **significance** value in **Cell B4** , and **mode** value in the **Cell C4**.
- After applying the FLOOR.MATH Function, it gives the **result as 5** in the **Cell D4**.

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

### Example 2:

- If any of the arguments is a non-numeric value, it returns **#VALUE!** Error.

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

## Wrap-Up:

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

### Similar Functions:

- [**FLOOR Function in Excel**](https://geekexcel.com/how-to-use-excel-floor-function-in-office-365-with-examples/)
- [**FLOOR.PRECISE Function in Excel**](https://geekexcel.com/how-to-use-excel-floor-precise-function-in-office-365/)

### 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 “TYPE Function” in Office 365? – (with Examples)](https://geekexcel.com/how-to-use-excel-type-function-in-office-365-with-examples/)
CSS Drop Shadow vs Box Shadow
Tags: css
Published: 2020-08-20 06:50:35

The other day [Josh](https://twitter.com/JoshWComeau) made a super cool tweet about drop-shadow supporting PNG's; I didn't know it supported PNG's, so I decided to give it a go.

<blockquote class="twitter-tweet"><p lang="en" dir="ltr">🔥 `box-shadow` doesn&#39;t work well with transparent images. `filter: drop-shadow` does what you&#39;d expect, adding a shadow to the image&#39;s contents.<br><br>.my-img {<br> filter: drop-shadow(1px 2px 3px black);<br>}<br><br>CSS filters are so rad 🥰<br><br>Pen: <a href="https://t.co/rVKgSlijt1">https://t.co/rVKgSlijt1</a> <a href="https://t.co/6rwc7gG1Ro">pic.twitter.com/6rwc7gG1Ro</a></p>&mdash; Josh ✨ (@JoshWComeau) <a href="https://twitter.com/JoshWComeau/status/1288830824322924544?ref_src=twsrc%5Etfw">July 30, 2020</a></blockquote> <script async src="https://platform.twitter.com/widgets.js" charset="utf-8"></script>

## HTML Structure

For my example we are using my favourite Pokémon "Eevee" and will place our three Eevee png's in a container.

```html
<div class="container">
  <img src="https://i.imgur.com/q3SXJQf.png" />
  <img src="https://i.imgur.com/q3SXJQf.png" class="box-shadow" />
  <img src="https://i.imgur.com/q3SXJQf.png" class="drop-shadow" />
</div>
```

As you can see one is going to be a raw example, one will have a box-shadow and the third will have the drop-shadow.

## CSS Box Shadow

You probably have seen and used the box-shadow before, it's a cool feature and adds a shadow to our "box".

It works like this:

```css
.box-shadow {
  box-shadow: 0px 0px 10px #000;
}
```

It puts a shadow on the image, but on the box of it.

![Box-shadow](https://i.imgur.com/ANAmEZ9.png)

## CSS Drop Shadow

Then there is a [CSS Filter](https://daily-dev-tips.com/posts/building-a-realtime-photoshop-%F0%9F%8E%A8/) which is amazing when it comes to contouring a PNG!

```css
.drop-shadow {
  filter: drop-shadow(0px 0px 10px rgba(0, 0, 0, 0.5));
}
```

![Drop-shadow](https://i.imgur.com/aJYVzi3.png)

This all will result in the following Codepen.

{% codepen https://codepen.io/rebelchris/pen/abNmJwE %}

## Browser Support

As mentioned before, CSS Filters are cool, but not widely supported yet 😩.

There is a [polyfill](https://github.com/Schepp/CSS-Filters-Polyfill), but also limited.

![CSS Filter support](https://caniuse.bitsofco.de/image/css-filters.png)

### Thank you for reading, and let's connect!

Thank you for reading my blog. Feel free to subscribe to my email newsletter and connect on [Facebook](https://www.facebook.com/DailyDevTipsBlog) or [Twitter](https://twitter.com/DailyDevTips1)
🤖 Building a Telegram bot with Apache Kafka, Go, and ksqlDB
Tags: apachekafka, go, showdev, techtalks
Published: 2020-08-20 11:35:08

I had the pleasure of presenting at [DataEngBytes](https://dataengconf.com.au/) recently, and am delighted to share with you my ✨brand new talk✨

[**🤖Building a Telegram bot with Apache Kafka, Go, and ksqlDB**](https://rmoff.dev/carpark-telegram-bot)

* [🗒️ Slides](https://rmoff.dev/carpark-telegram-bot)
* [👾 Code](https://github.com/confluentinc/demo-scene/tree/master/telegram-bot-carparks)
* [🎥 Recording](https://www.youtube.com/watch?v=W2VB9HuzsMM)

{% youtube W2VB9HuzsMM %}
New video series, who dis? 📞😉
Tags: news, tutorial, graphql
Published: 2020-08-19 12:02:16

---
title: New video series, who dis? 📞😉
published: true
description: Announcing a series of video tutorials on Data Federation with GraphQL using Hasura Remote Joins.
tags: news, tutorial, graphql
cover_image:
---

# **Hello lovely people!** 👋🏻

This year has been full of eccentricity & unpredictability. Of all the wild things it has brought to us all, it has also brought us amazing friends, content, events, and opportunities to explore our interests beyond what we did as part of our seemingly dated normalcy.

So while working from home, I've been enjoying a smol slice of this *cake* that is *content creation*. I've been working on improving my presentation skills and getting better at #LearningInPublic.

In this process, I've also been exploring creative ways to remodel deeply insightful and long form content into more consumable tidbits of information. This probably sounds fancier than it actually is, but starting out with condensed pieces of content is a good way to:
1. Get started with content creation and learn as you go!
2. Get a sense of your style & focus on the process without having to devote too much of your time
3. Create content that is beginner friendly and accessible for our communities because of its format

⚠️ Shameless Tweet plug Warning ⚠️

{% twitter 1293527196330385408 %}

{% twitter 1293527358448705536 %}

{% twitter 1294166060220837889 %}


The above tweets very accurately portray how I felt when I was working on my first video not too long ago, haha! For what it's worth, it's completely normal to not get it right the first few times. The goal is to get comfortable with the process over the time and be consistent with the practice.

And then there's always going to be folks who'd love to give feedback and help you out in the process. I'm grateful to have friends & mentors who constantly believe in me, help me grow and tackle my imposter syndrome to keep pushing myself, and work on exciting things! 🙏🏻

Ok, since I haven't really planned out this post properly, I could typically go on in pure `Vish is cake` fashion. But I'll save that for Twitter.

Sooo, without further ado...

****squeals in excitement****

# 📣  **Announcing #JoinAllTheThings!!**

A smol collection of byte-sized videos on Data Federation with GraphQL using Hasura Remote Joins!
{% twitter 1294371279345082368 %}

### Part I: Adding Contentful as a Remote Schema in Hasura

{% youtube aachB3XVKKI %}

### Part II: Joining Contentful Data in your Postgres Database with Hasura Remote Joins

{% youtube sRLPbkwZBPc %}

That's all for now folks! I'll be uploading more videos to this [playlist](https://www.youtube.com/playlist?list=PLTRTpHrUcSB-BvvMTcVVvvB5pNIdxZao8) and writing a proper blog post on whole process & learnings soon. So keep your eyes peeled for that?

If you have questions or just wanna have a chat, come say hi on [Twitter](https://twitter.com/VishwaMehta30)! ✨

Ciao! 💜
BKF Recovery Tool to Repair & Restore Corrupt BKF File
Tags: bkfrecovery, bkfrepair, backup
Published: 2020-08-20 10:58:18

I would like to suggest you this brilliant and efficient <a href="http://www.tools4recovery.com/open-bkf-file-recovery.html">BKF File Recovery</a> software which can easily repair corrupted BKF files and simply recover images, pictures, music files, email files, email mailbox files, document files etc from corrupt BKF file. An enhanced and easy to use user friendly interface also provided by this software for intense recovery. Try this free demo version of this software which can be very effective in evaluating its efficiency and functionalities. It allow the users to see the preview of all recovered files and folder.

Use this discount coupon (SYSPRING30OFF) to get 30% discount on full licensed version.

Visit here:- http://www.tools4recovery.com/open-bkf-file-recovery.html
Repair corrupted BKF files Using BKF Recovery Software
Tags: bkfrepair, bkfrecovery, recoverbkf, repairbkf
Published: 2020-08-20 10:56:51

Try this <a href="https://www.recoverydeletedfiles.com/bkf-file-recovery-tool.html">BKF File Recovery</a> tool to repair bkf files and recover lost and damaged backup files in simple and secure way. With this software you can easily recovers images, pictures, music files, emails, exchange mailbox files, document files. This software automatically save the scanned file that can be used in future when you begins the same process then it will load the previous scanned file and will save time. Checkout It free demo version of this software which can be very effective in evaluating its efficiency and functionalities. 

Use this discount coupon (SYSPRING30OFF) to get 30% discount on full licensed version.

Download link:- https://www.recoverydeletedfiles.com/bkf-file-recovery-tool.html
MS BKF Recovery Software to Repair corrupted BKF Files
Tags: bkfrepair, bkfrecovery, recoverbkf, backup
Published: 2020-08-20 10:54:49

With this <a href="https://www.mannatsoftware.com/stellar-phoenix-bkf-recovery.html">BKF File Recovery</a> software you can easily recovers images, pictures, music files, emails, exchange mailbox files, document files and so on from BKF file. This software is 100% safe and secure to maintain data hierarchy while recovery and keep safe original formatting of data after recovery as it was before recovery. It has enhanced and easy to use user friendly interface to make the whole recovery process fast and smooth. Download this free demo version of this software which can be very effective in evaluating its efficiency and functionalities.

Read more info:- https://www.mannatsoftware.com/stellar-phoenix-bkf-recovery.html
after 5 months of learning programming... 3 mistakes i did you should avoid them
Tags: codenewbie, 100daysofcode, beginners, productivity
Published: 2020-08-20 10:51:41

i started learning programming 5 months ago, i learned Html css and Javascript and now i can build website using this three. I am so happy of the result until now, but i made 3 big mistakes in my learning path that slowed my learning, so if you are newbie or you want to start learning here are 3 mistakes you should avoid.

###- don't have a road map:
when i started learning programming i didn't have any road map to follow, i just search for programming courses i choose one and i started learning html then css then python. when i finished my first course i didn't know what the next step so i started another course then another then another and i found my self in each time start from zero until i saw a video in youtube that talked about road map so i made mine, and the most important thing you need to do before make a road map is to chose if you will be a front-end or a back-end. by the way if you started as a front-end or back-end that doesn't mean you will be forever just front-end or back-end you can developed your self and become a full-stack developer, in your beginning you need just to focus in one thing.

###- don't have an idea about how computers and websites work before learning programming:
when i started i didn't have any idea about how computers and websites works and because of that i had some difficulties in understanding how programming languages work. so before you start learning programming take a time to understand the basic of how computers and websites working and also how the internet work these will help you a lot in understanding programming.

###- moving fast:
when i started my first course i just moved fast i learned html then css then python and after that i find my self didn't understand yet html and css, so i started again learned html then css then javascript and again i moved fast and i didn't understand very well the basics. so i decided to comeback again and learn deeply and slowly, i learned html but in this time i didn't just watch one course and move, in this time i watched many courses, i read book, documentation and i did some practice and when i found my self comfortable with html i moved to css then when i found my self Comfortable with css i moved to JavaScirpt and in this time i found my self had a good understanding of basics and i can start build websites.

I hope this was helpful, and I wish you all the best in your learning path.
Introduction to Composer [Command-line interface pt2]
Tags: php, composer, commandline
Published: 2020-08-20 10:49:32

---
title: Introduction to Composer [Command-line interface pt2]

published: true
description:Learn about composer create-project, dumpautoload, fund, composer why, validate and many other command you can use while writing PHP
 
tags: php, composer, commandLine
cover_image: https://anastasionico.uk/img/blog/introduction-to-composer-command-line-interface-second-part.jpg
---

There are only a few things we can be sure about,

 

Tomorrow the sun will rise again,
The world is a sphere (despite what someone says)
If you dream of getting a job or progress your career as a PHP developer you MUST learn Composer



 
Composer is the tool that made PHP what this language it is today.
Just the idea that you can code something useful wrap it into a package and send it out to the open-source world is something amazing.

Same for the opposite, typing a line into your terminal and have full-working framework or component is magical

This tool though even if very simple can be tricky at times.

for this reason, 

we have to BE AWARE and learn how to use it properly.

I have put together a comprehensive article that covers all the 30-ish command of Composer including their attributes and flags you can use on it.

go check it out, then bookmark it and use it when you need it!

[CLICK HERE TO READ THE FULL ARTICLE](https://anastasionico.uk/blog/introduction-to-composer-command-line-interface-second-part)
Pardus’ta VPN ile Giriş Ekranına Düşmek
Published: 2020-08-20 10:33:30

Sistem güncellenir ve vnc için gerekli olan paket kurulur.

    sudo apt-get update
    sudo apt-get install tightvncserver

Daha sonra Lightdm konfigurasyon dosyası açılarak aşağıdaki satırlar açılır ve enable değeri true olarak değiştirilir;

    sudo vi /etc/lightdm/lightdm.conf

    [VNCServer]
    enabled=true
    command=Xvnc
    port=5900
    width=1024
    height=768
    depth=8

Lightdm servisi yeniden başlatılır;

    sudo systemctl restart lightdm.service

Yukarıdaki adımlardan sonra vpn ile gelerek oturum açma ekranına(Lightdm) düşebilirsiniz.