Wie man zwei Spalten in Excel für Übereinstimmungen und Unterschiede vergleicht

Der Vergleich von Spalten in Excel ist etwas, das wir alle ab und zu tun. Microsoft Excel bietet eine Reihe von Optionen zum Vergleichen und Abgleichen von Daten, z.B. excel tabellen vergleichen und unterschiede markieren, aber die meisten von ihnen konzentrieren sich auf die Suche in einer Spalte. In diesem Tutorial werden wir verschiedene Techniken untersuchen, um zwei Spalten in Excel zu vergleichen und Übereinstimmungen und Unterschiede zwischen ihnen zu finden.

  • Zwei Spalten in Excel zeilenweise vergleichen
  • Vergleich mehrerer Spalten für Zeilenübereinstimmungen
  • Vergleichen Sie zwei Spalten für Übereinstimmungen und Unterschiede.
  • Vergleichen Sie zwei Listen und ziehen Sie passende Daten.
  • Hervorhebung von Übereinstimmungen und Unterschieden zwischen 2 Spalten
  • Hervorhebung von Zeilenübereinstimmungen und Unterschieden
  • Wie man zwei Zellen in Excel vergleicht
  • Formelfreier Vergleich von zwei Spalten oder Listen in Excel

So vergleichen Sie 2 Spalten in Excel zeilenweise

Wenn Sie die Datenanalyse in Excel durchführen, ist der Datenvergleich in jeder einzelnen Zeile eine der häufigsten Aufgaben. Diese Aufgabe kann mit Hilfe der IF-Funktion erledigt werden, wie die folgenden Beispiele zeigen.
Beispiel 1. Vergleichen Sie zwei Spalten für Übereinstimmungen oder Unterschiede in derselben Zeile.

Um zwei Spalten in Excel zeilenweise zu vergleichen, schreiben Sie eine übliche IF-Formel, die die ersten beiden Zellen vergleicht. Geben Sie die Formel in eine andere Spalte in der gleichen Zeile ein und kopieren Sie sie dann durch Ziehen des Füllgriffs (ein kleines Quadrat in der rechten unteren Ecke der ausgewählten Zelle) in andere Zellen. Dabei wechselt der Cursor in das Pluszeichen:

Wie man zwei Spalten in Excel für Übereinstimmungen und Unterschiede vergleicht

Kopieren Sie die Formel in andere Zellen, um zwei Spalten in Excel zu vergleichen.
Formel für Spiele

Um Zellen innerhalb derselben Zeile mit dem gleichen Inhalt, in diesem Beispiel A2 und B2, zu finden, lautet die Formel wie folgt:

=IF(A2=B2, „Match“,““)
Formel für Differenzen

Um Zellen in der gleichen Zeile mit unterschiedlichem Inhalt zu finden, ersetzen Sie einfach „=“ durch das Ungleichheitszeichen:

=IF(A2<>B2, „Keine Übereinstimmung“,““)
Übereinstimmungen und Unterschiede

Und natürlich hindert Sie nichts daran, mit einer einzigen Formel sowohl Übereinstimmungen als auch Unterschiede zu finden:

=IF(A2=B2, „Match“, „No match“)

Oder

=IF(A2<>B2, „Keine Übereinstimmung“, „Übereinstimmung“)

Das Ergebnis kann ähnlich aussehen:

Eine Formel zum Vergleichen von 2 Spalten für Übereinstimmungen und Unterschiede in jeder Zeile.

Wie Sie sehen, verarbeitet die Formel Zahlen, Daten, Zeiten und Texte gleichermaßen gut.
Beispiel 2. Vergleichen Sie zwei Listen für groß- und kleingeschriebene Übereinstimmungen in derselben Zeile.

Wie Sie wahrscheinlich bemerkt haben, ignorieren die Formeln aus dem vorherigen Beispiel den Fall beim Vergleichen von Textwerten, wie in Zeile 10 im Screenshot oben. Wenn Sie zwischen 2 Spalten in jeder Zeile eine Übereinstimmung zwischen Groß- und Kleinschreibung finden möchten, verwenden Sie die Funktion EXACT:

=IF(EXACT(A2, B2), „Match“, „“)
Vergleich zweier Listen für groß- und kleingeschriebene Übereinstimmungen in derselben Zeile

Um case-sensitive Unterschiede in der gleichen Zeile zu finden, geben Sie den entsprechenden Text („Unique“ in diesem Beispiel) im dritten Argument der IF-Funktion ein, z.B:

=IF(EXACT(A2, B2), „Match“, „Unique“)
Mehrere Spalten für Übereinstimmungen in derselben Zeile vergleichen

In Ihren Excel-Arbeitsblättern können Sie mehrere Spalten anhand der folgenden Kriterien vergleichen:

Suchen von Zeilen mit gleichen Werten in allen Spalten (Beispiel 1)
Suchen von Zeilen mit den gleichen Werten in 2 beliebigen Spalten (Beispiel 2)

Beispiel 1. Findet Übereinstimmungen in allen Zellen innerhalb derselben Zeile.

Wenn Ihre Tabelle aus drei oder mehr Spalten besteht und Sie Zeilen finden möchten, die in allen Zellen die gleichen Werte haben, funktioniert eine IF-Formel mit einer AND-Anweisung wie eine Behandlung:

=IF(AND(A2=B2, A2=C2), „Vollständige Übereinstimmung“, „“)
Suchen von Zeilen mit gleichen Werten in allen Spalten

Wenn Ihre Tabelle viele Spalten hat, wäre eine elegantere Lösung die Verwendung der Funktion COUNTIF:

=IF(COUNTIF($A2:$E2, $A2)=5, „Full match“, „“)

Dabei ist 5 die Anzahl der Spalten, die Sie vergleichen.

Beispiel 2. Finden Sie Übereinstimmungen in zwei beliebigen Zellen in der gleichen Zeile.

Wenn Sie nach einer Möglichkeit suchen, Spalten für zwei oder mehr Zellen mit gleichen Werten innerhalb derselben Zeile zu vergleichen, verwenden Sie eine IF-Formel mit einer OR-Anweisung:

=IF(OR(A2=B2, B2=C2, A2=C2), „Übereinstimmung“, „“)
Suche nach Übereinstimmungen in zwei beliebigen Zellen in der gleichen Zeile

Wenn es viele Spalten zum Vergleichen gibt, kann Ihre OR-Anweisung zu groß werden. In diesem Fall wäre es besser, mehrere COUNTIF-Funktionen zusammenzufassen. Das erste COUNTIF zählt, wie viele Spalten den gleichen Wert wie in der ersten Spalte haben, das zweite COUNTIF zählt, wie viele der verbleibenden Spalten gleich der zweiten Spalte sind, und so weiter. Wenn die Anzahl 0 ist, gibt die Formel „Unique“ zurück, ansonsten „Match“. Zum Beispiel:

=IF(COUNTIF(B2:D2,A2)+COUNTIF(C2:D2,B2)+(C2=D2)=0, „Unique“, „Match“)
Vergleichen Sie mehrere Spalten und finden Sie Übereinstimmungen in zwei beliebigen Zellen derselben Zeile.
Wie man zwei Spalten in Excel für Übereinstimmungen und Unterschiede vergleicht

Angenommen, Sie haben 2 Listen von Daten in Excel, und Sie wollen alle Werte (Zahlen, Daten oder Textzeichenketten) finden, die sich in Spalte A befinden, aber nicht in Spalte A.

Einige Android Datei-Manager-Anwendungen

Dateimanager-Anwendungen gehören zu den wichtigsten Anwendungen auf Ihrem Gerät. Mit ihnen können Sie Ihre Dateien durchsuchen, Ihre Downloads finden, Ihren Speicherplatz verwalten, Dinge bewegen und vieles mehr. Nicht jeder ist zu sehr an der Dateiorganisation interessiert, weil sie ziemlich langweilig sein kann, aber jeder braucht immer noch einen Dateibrowser. Wenn du bester dateimanager android suchst, hier sind die besten Datei-Explorer-Anwendungen, Dateibrowser-Anwendungen und Datei-Manager-Anwendungen für Android.
Werden Sie noch produktiver mit diesen exzellenten Apps!

Amaze File Manager

Preis: Kostenlos bei In-App-Käufen
DOWNLOAD BEI GOOGLE PLAY
Amaze File Manager ist eine neuere App, die vergleichsweise neu ist, und sie ist ziemlich gut. Es ist Open Source und konzentriert sich auf ein leichteres Erlebnis für diejenigen, die nur etwas Light File Browsing betreiben müssen. Es bietet Material Design, SMB File Sharing, einen integrierten App Manager zum Deinstallieren von Apps, Root Explorer und mehr. Es verwaltet, die wichtigsten Dinge aufzunehmen, ohne sich aufgebläht zu fühlen. Es ist kostenlos herunterzuladen und mit optionalen In-App-Käufen zu verwenden, falls Sie bei der Finanzierung der Entwicklung helfen möchten.

https://www.giga.de/extra/android/specials/android-dateimanager-die-besten-in-der-uebersicht/

Astro Datei-Manager

  • Preis: Kostenlos
  • DOWNLOAD BEI GOOGLE PLAY
  • Astro ist eine der ältesten Dateimanager-Anwendungen von Android.
  • Es hatte seine Höhen und Tiefen im Laufe der Jahre.
  • Es war jedoch immer eine gute Wahl.
  • Einige der Funktionen umfassen SD-Kartenunterstützung, Cloud-Speicherunterstützung, Dateikomprimierung, App-Management und Unterstützung für die Archivextraktion (ZIP und RAR).
  • Sie erhalten auch eine gut aussehende, material designorientierte Benutzeroberfläche und einfache Bedienung.
  • Es ist auch völlig kostenlos und ohne Werbung. Metago, der Entwickler, hat auch eine Beta-Version, wenn Sie die neuesten Funktionen schneller testen wollen.

ASUS Datei-Manager

Preis: Kostenlos
DOWNLOAD BEI GOOGLE PLAY
Es kommt nicht jeden Tag vor, dass eine OEM-App eine App-Liste erstellt, aber File Manager von ASUS ist eigentlich wirklich gut. Es ist mit den meisten Geräten kompatibel, auch mit Geräten, die nicht von ASUS stammen. Sie erhalten auch eine saubere, einfache Schnittstelle mit LAN- und SMB-Unterstützung, Cloud-Speicherunterstützung, Unterstützung für verschiedene Dateitypen, Archivierungsunterstützung und mehr. Es ist völlig kostenlos ohne In-App-Käufe und bietet ein tolles Erlebnis für einen einfachen Dateibrowser. Der einzige negative Teil ist der fehlende Root-Zugriff. Es gibt auch einige Anzeigen.

FX Datei Explorer

Preis: Kostenlos / $2.99
DOWNLOAD BEI GOOGLE PLAY
FX File Explorer ist ein neuerer Dateimanager, der im Vergleich dazu sehr ähnlich ist. Es hat alle üblichen Funktionen. Dazu gehören verschiedene Funktionen für Ihre Medien und Dateien, Multi-Window-Unterstützung, Unterstützung für Netzwerkspeicher wie FTP und sogar Unterstützung für verschlüsselte archivierte Dateien. Das ist eine Menge zu verarbeiten, aber der FX Explorer erledigt im Grunde genommen alles. Sie erhalten sogar einen Texteditor und seine Archivunterstützung funktioniert mit weniger beliebten Programmen wie GZip, Bzip2 und 7zip. Und das Beste daran: Es gibt keine Werbung und es verfolgt Ihre Geräte nicht. Es ist eine gute Wahl für diejenigen, die besonders vom ES File Explorer weggehen.

MiXplorer Silber

Preis: $4.49
DOWNLOAD BEI GOOGLE PLAY
MiXplorer Silver ist der neueste Dateimanager auf der Liste. Die Liste der Funktionen ist recht beeindruckend. Sie erhalten die üblichen Funktionen wie Dateisuche, Archivunterstützung, Unterstützung für Cloud-Speicher und einen HTML-Viewer. Es gibt auch einige Nischenfunktionen, darunter EPub, MobiPlacket und PDF-Readerunterstützung sowie Dateiverschlüsselung. Es gibt auch eine Reihe von Plugins, die bei Bedarf noch mehr Funktionalität hinzufügen. Wenn Sie also mehr Archivunterstützung und weniger PDF-Unterstützung benötigen, können Sie das Archiv-Plugin erhalten und das PDF-Plugin überspringen. Die App hat keine kostenlose Version, also stellen Sie sicher, dass Sie sie ausprobieren, bevor die Rückerstattungszeit abläuft, um sicherzustellen, dass sie Ihnen gefällt.

France rejects tax reduction for Bitcoin & Co

France has rejected a draft law designed to favour the taxation of crypto profits. This is the fourth time that an effort to reach a compromise on crypto taxation policy has been rejected. The French crypto community is frustrated. What are the reasons?

For the fourth time, the lower house of parliament has rejected the amendments to the French financial law relating to crypto taxes. On 18th December the French news platform Capital questioned Alexandre Stachtchenko, managing director of the blockchain association La Chaintech, about the decision of the French parliament.

The Bitcoin news

On 13 November, Bitcoin news reported on the proposed legislation according to onlinebetrug. The bill provided that profits from the sale of crypto assets would be taxed at 30 percent. The tax rate would thus be identical to that for capital gains such as bonds and shares. This could have been a strong sign of crypto-acceptance as the law would have raised Bitcoin & Co. to the same level as traditional investments. Also under discussion was the introduction of a tax benefit that would take into account whether the gain is from regular or occasional crypto transactions.

Another bill proposed to increase the annual transaction volume in the Tax Exemption Act from a total of 305 to 3,000 euros or up to 5,000 euros. However, the chairman, who rejected this proposal, was of the opinion that the current 305 euros were already „quite cheap“.

Terrible Bitcoin news

The French crypto community is more than unhappy about the government’s negative attitude. Also surprise would be a comprehensible reaction to this current decision, since France had been quite positive about crypto issues so far. Four years ago, Europe’s first Bitcoin news Center opened in Paris and next year Bitcoin news will even be available in tobacco shops. The government’s reluctance to treat crypto transactions more fairly from a tax point of view than traditional investments seems to push these advances into the background. Stachtchenko is particularly frustrated about the lack of justification:

„The most frustrating thing about all this is that none of the rejections were justified by the rapporteur or the minister. In short, the message the Community receives in France and abroad is terrible: ‚Take all the risks, we will not support you, and the money you earn to take the risks will go to the treasury‘. It’s dramatic.“

However, the decision-makers pointed out that they wanted to discuss the legislative proposals again once Bitcoin & Co. had gained more acceptance in the country. What sounds a bit like a circular end, Stachtchenko considers a delaying tactic. Until then it would be too late, France’s connection to the worldwide crypto trade would already be missed.

Privacy is not a crime

Privacy in the 21st century is dwindling. Information is tapped and evaluated everywhere, on Facebook, Google, Amazon and also Bitcoin. Much more serious, however, is the fundamental attitude that privacy is something superfluous – even offensive. A counterposition.

Bitcoin’s promise was not only to be decentralized and open, but also to bring privacy to users – the „anonymous hacker money“. Well, after almost ten years we know that this is not the case. In fact, Bitcoin is anything but private. Instead, every transaction is held in the blockchain forever.

The Bitcoin formula option

Bitcoin formula opened a new paradigm in 2008, which was not a scam according to onlinebetrug. it should be possible to establish a financial system independent of any state authority. For the first time, mankind was given a new option to withdraw from the Fiat banking system. This would mean an extreme loss of control for the established elite. The independence of money could kill many a government, as most state institutions rely on a money monopoly and the power to print money. Andreas Antonopolous describes the approach of the banking cartel in his latest lecture:

De-Anonymization of Bitcoin trader

As already stated in the Watch my Block: Bitcoin, Bitcoin trader is pseudonymous, not anonymous. Read more about it: https://www.forexaktuell.com/en/bitcoin-trader-scam/ This means that all transactions are made with unique pseudonyms. These are not a chosen name as in some chat rooms, but a seemingly random character string: the Bitcoin address.

At first glance, it is impossible to tell to which person a particular address belongs. However, you can see how much money an address „carries around with it“. It can be seen how large the transaction is and where the money goes. The only form of privacy in Bitcoin is that identities cannot easily be assigned to addresses. But this privacy is also dwindling.

„KYC“ is the abbreviation of the buzzword. By imposing a „know-your-customer“ policy, governments want to prevent both illegal money laundering and the financing of terrorism. The bank must know and verify its customers and store the relevant information. A government thus has a contact point for the prosecution of potential criminals.

Escaping the Global Banking Cartel

The KYC process has also become part of everyday life in the crypto world. No large stock exchange can afford to be uncooperative with states in this regard. Even the young Binance exchange recently gave in to regulatory pressure. Buyers of crypto currencies must pass through a monitored gate at least once. A connection to the Bitcoin address is established there and subsequent transactions can also be monitored. The more real identities become known, the further the de-anonymization of the entire Bitcoin block chain progresses. Like a jigsaw puzzle that is put together piece by piece. The idea of such a data collection and tracking is not a dystopian nightmare, but has been taking place for years.

Even if it is a state-independent financial instrument, it is therefore only suitable as money to a limited extent. Blackened Bitcoin can be censored by stock exchanges. Perhaps the transparency of Bitcoin is a reason for the apparent calmness of the regulators. It is now clear that chain analysis and the blockchain can be used to retroactively identify most, if not all, cash flows.

Bitcoin (BTC) – Price Analysis KW20 – At the Edge of the Upward Channel

From 10 to 12 May, the share price fell by 12 per cent. There it was able to catch up again and rise slightly. This upward trend, together with the development between 12 and 17 April, describes the support from an upward channel.

The Bitcoin code course fell this week

The Bitcoin code development since the beginning of February can be described in the form of a symmetrical triangle pattern. Since the middle of April, the Bitcoin code has been moving in an upward-channel. Overall, one comes to a neutral price estimation. The most important support is currently 6,873.00 Euro, the first interesting resistance is 7,450.00 Euro.

As already described in the Altcoin market analysis, the Bitcoin price fell victim to FUD this week. Overall, it lost 12 percent compared to the May 10 price. There, however, he was able to catch himself again and recapture some of the lost territory. Currently the price is just below the exponential moving averages EMA50 and EMA100.

The MACD (second panel from above) is currently negative, but is rising. Accordingly, the MACD line (blue) lies above the signal (orange).

The RSI is at 53 and thus bullish.

From the indicators one would get a rather bullish impression. However, what prevents this is a look at the long-term development:

We see that Bitcoin has been going through a triangle pattern since the beginning of February. Recently, the resistance of this pattern was tested – without success so far. Although it is still interesting to look at the daily candles that the price is currently testing the EMA50 as resistance, the positive but falling MACD and the RSI at 50 with the above values lead to a neutral assessment.

Support and Resistance of the Bitcoin code

The first Bitcoin code support is 6.873,00 Euro and is described by the minimum of May 12th. This roughly coincides with the support of the current up channel. Another support is described by the plateau between 30 March and 11 April at 5,698.59 Euros. This is at the level of the Triangle Pattern support. Read more info about the Bitcoin code.

The first resistance is 7.450,00 Euro and thus on the level of the EMA100. If the price should overcome this level, a further resistance would be described by the price before the price fall of this week at 7,882.00 euros. This resistance is also equal to the resistance of the triangle pattern mentioned above.

Entry Points, Stop Losses and Targets
The neutral assessment advises to wait and see. If the price falls below the support level, this would be an interesting entry for a short position. Target would be the support of the triangle pattern, stop loss the first support at 6.873,00 Euro.

Should the price bounce off one of the supports or rise above the first resistance, this would be an interesting entry point for a long position. In the first two cases the support lines can be used as a stop loss, in the case of a breakthrough of the resistance the EMA50, which is currently around 7,400 Euros, is the best choice. The target would be the resistance of the triangle pattern at 7.882,00 Euro. After the breakthrough of the triangle pattern, risk takers could hope for a retest of the resistance from the upward channel and aim for another target at about 8,500 Euros. In this case, however, the stop loss should be tightened accordingly!

You are using an AI for your Cryptoradar – how does the AI manage to capture the mood on the market?

Sowa Labs comes from Predictive Data Analytics. For years we have been dealing with data and text mining as well as self-learning systems. Our specially created AI examines almost two million tweets every day for the Cryptoradar. These are then filtered and processed according to various criteria. At the end of the day, around 250,000 tweets remain, from which we calculate buzz and sentiment indicators. Our systems actually read each of these tweets and evaluate it positively, negatively or neutrally in relation to the respective crypto currency. This shows a certain market sentiment. Twitter is particularly well suited as an information medium for the cryptographic market, where almost all relevant information is shared within seconds.

„BISON will comply with all laws and obligations applicable in Germany“.

What are the biggest challenges in the development of the Bitcoin profit?

With BISON, we want to offer a Bitcoin profit app that works simply, safely and reliably. If the customer no longer has any complicated technical hurdles, we have to overcome them accordingly. This doesn’t always make development easy, for example with a view to safe storage for the customer. More about it: https://www.geldplus.net/en/bitcoin-profit-review/

The fact that we are launching the app on the German market is also not trivial: BISON will comply with all laws and obligations applicable in Germany in order to offer the customer maximum security and reliability.

Do you already have plans as to what will happen after the Bitcoin profit in September?

In any case! Bitcoin profit will develop continuously. On the one hand, we want to expand the universe of tradable crypto currencies like this: https://www.forexaktuell.com/en/bitcoin-profit-scam/. This is not easy because you have to consider the technology behind each currency for safekeeping. We also plan to launch BISON in other European countries. In addition to German-speaking countries, we find Scandinavia and the Benelux countries exciting. Last but not least, we are permanently expanding the features in BISON. We absolutely want to provide our customers with even more decision support when investing in crypto currencies, for example with well-prepared information and suitable alerting.

Managing Identities

The increasing number of digital crime cases shows the need for a reliable way to protect one’s own digital identity. Therefore, the goal of KYC-Chain is to create the highest level of trust through consensus on user identity. This service, which is currently under development, uses existing „know your customer“ rules and plans to simplify this process.

Identity Wallets provided by the Bitcoin trader platform will allow users to reveal only necessary information

KYC-Chain will use Ethereum and will use the help of „trusted gatekeepers“ – legal entities that are authorized by law to authenticate KYC documents: https://www.geldplus.net/en/bitcoin-trader-review/. Such a trusted gatekeeper would use a user ID using the KYC chain platform and authenticate it. In a decentralized data repository, corresponding Bitcoin trader documents would be stored, which could later be viewed by authorized parties to confirm an ID.

Decentralized help for companies
4G Capital provides microenterprises in Africa with immediate access to microcredit and has developed a concept for a dapp that uses smart contracts for this task.

Donors would then be able to use this Dapp to support micro-enterprises. The money lent – in the form of a digital currency – would be converted into Fiat using a 4G capital system and made available to the applicant.

In addition to these loans, which are not 100% secured, the company offers management consulting for micro-enterprises. The big goal of this project is to integrate individuals, companies and entire markets into the world market and thus help the African economy on a grass roots level.

Microblogging on the crypto trader chain

As a working crypto trader prototype, a review was created as a decentralized microblogging service that stores data on the Ethereum blockchain. The service has a generic Twitter-like function, so that messages up to 160 characters can be transmitted.

Since this service is decentralized, censorship is not possible: as soon as something is posted, it can only be deleted by the author himself.

You can also send donations to individual accounts in Ether. The team behind ETH-Tweet proposes to use this as a reward for good content – similar to the tip bots on reddit.

More power to the artists – Ethereum thanks to
Ampilative Art has set itself the goal of offering artists more opportunities and perspectives via a platform that corresponds to a social network.

It is planned as a platform where individuals can participate in the artist community and be remunerated by the community.

Artists will be able to create their own galleries in which their art will be accessible to others for free. Other users of the network can now reward the artist with donations, comments, ratings, or by sharing these galleries. The more an artist actively participates in the community, the greater the likelihood of being rewarded.

In addition, any revenue from Ampliative Art will be distributed among users according to their reputation.

As Dapp, Ampliative Art will be a kind of transparent cooperative in which users can cooperate and send and receive rewards.

Crowdfunding about Dapps
WeiFund uses Web3.0 technology to develop a crowdfunding solution on the Ethereum ecosystem.

Since, according to the project, they will only be one of many crowdfunding platforms in Web 3.0, they want to motivate these other platforms to cooperate by bringing crowdfunding utilities to market. These will be open source, modular and extensible. All critical aspects of the platform are decentralized.

In order to use WeiFund, WeiFund will first be opened in a Web3.0-enabled browser – for example Ethereums Mist – to initiate, search, manage and participate in crowdfunding campaigns.

The interface and user experience will be quite similar to known crowdfunding platforms like Kickstarter or GoFundMe, but all funds will be paid out in ether. WeiFund will also use smart contracts so that simple donations can become complex contracts.

Finally, Web3.0 browsers will use their own wallet systems so that payments within WeiFund will be secure and verifiable.

Rise of the Dapps – seven decentralized apps on Ethereum Blockchain

Imagine a company or service that is not controlled by a person, a board of directors or any other group whatsoever. This is to be achieved through smart contracts and Dapps.

Decentralized applications – Dapps in new German – is one of the newer ideas of the blockchain community

With the help of autonomously working programs stored in the blockchain, so-called smart contracts, proponents of this technology have developed a vision of a world in which everything that is needed for central management is controlled by intelligent contracts in the blockchain.

Bitcoin can be seen as the first dapp; the protocol is open source, rewards those who stand up for Bitcoin, needs no central authority and uses the blockchain to provide an online currency to the world.

These principles are now being used by visionaries for various online services in the form of different dapps. Even though this is a new field, the number of Dapps is increasing and many already exist in different phases of the development process.

Ethereum’s decentralized blockchain and its internal currency ether are the tools of choice for Dapp implementation. The Ethereum network has been created especially for this purpose and the Ethereum Foundation regularly organizes hackathons to promote decentralized applications.

All well and good – but what can you do with a Dapp? Here some use cases are discussed, which use the Ethereum Blockchain.

Dapps as an enrichment of the internet

The Vevue project promises to „bring Google Streetview to life“. Users are invited to share short video clips of restaurants, hotels, places, events and much more with users from all over the world.

The user does not need more than a smartphone and can earn equity by processing requests from the community Bitcoin and even Veuve. With the help of a Google Chrome extension, these „Veuves“ are also accessible via google maps.

An app called „Make Videos, earn Bitcoin“ is already available in the Google Play Store – even if it only does justice to the first half of the name and you can’t earn a Bitcoin.

Create worlds through Dapps in Etheria
Etheria is a sandbox game that strongly reminds of Minecraft: Players can buy certain tiles, create blocks from them and finally build things with them.

According to the project website the whole world as well as the interactions of the players are stored in the Ethereum Blockchain.

Until now, all virtual worlds were controlled by a central entity. In Etheria, however, all aspects of the world will be subject to a consensus of all those participating in the world.

This means that Etheria cannot be censored or put offline by anyone, neither by a government nor by players, nor by the „fivedogit“, the developer – Etheria will exist as long as Ethereum exists.