ALBERT

Note: Inhalt Vorwort Der Aufbau dieses Buches Rechts- oder Linkshänder? Übungsdateien und Hilfe 1 Von der Idee zum Bericht Entwurf von Modellen und deren Dokumentation Planungsmethode und Lösungsentwicklung Praxisbeispiel Aufbereiten der Daten und Aufbau der Lösung Verwaltung der Daten 2 Entdecken Sie die Möglichkeiten von PivotTables und PivotCharts Lassen sich alle Daten mit PivotTables auswerten? Die verschiedenen Wege zu einer PivotTable Diese Prozessschritte führen Sie zu einem Pivot-Bericht Jetzt erstellen Sie eine PivotTable So verschieben Sie im Layoutbereich die Felder blitzschnell Darstellung der PivotTable ändern Gruppierung von Elementen in einer PivotTable Wie Datentypen die Gruppierung beeinflussen Eine Gruppierung aufheben Feldbeschriftungen in PivotTables und PivotCharts So erweitern Sie die PivotTable und verändern die Feldanordnung Mehrere Felder im Wertebereich Mit dem Berichtsfilter Daten selektiv anzeigen Alle Daten wieder anzeigen Die Wirkung der Layoutaktualisierung Felder verschieben, hinzufügen oder entfernen Feld aus dem Layoutabschnitt entfernen Feldbezeichnungen ändern Nutzen der PivotTable-Felderansicht Was beim Verschieben von Feldern in den vier Berichtsbereichen passiert Arbeitserleichterung durch eine geeignete Datensortierung Berechnungstypen in PivotTables Schnellformatierung von PivotTables PivotCharts: sich schon vorher ein Bild machen Aus einer PivotTable ein PivotChart erstellen Diagramm beschriften Das Layout für Berichte gestalten Berichtslayout in den PivotTable-Optionen anpassen Tabellenoptionen erleichtern die Arbeit mit PivotTables Anzeigen von Teilergebnissen und Gesamtergebnissen Sortieren in PivotTables Elemente mit der Maus verschieben Benutzerdefinierte Sortierreihenfolge erstellen und anwenden So sortieren Sie eine PivotTable nach Teilergebnissen Suchen und Filtern in den PivotTables Datenreduzierung auf oberster Ebene Komplexe Filter über das Eingabefeld »Suchen« steuern Die aktuelle Markierung als weitere Filtermöglichkeit verwenden Felder vor dem Hinzufügen filtern In einem Feld mehrere Filter aktivieren Neue Elemente automatisch anzeigen Vergleichsfilter im Umgang mit Datumswerten Filter löschen und alle Daten wieder anzeigen Genial: einfaches Filtern mit Datenschnitt und Zeitachse Einen Datenschnitt an Ihre Bedingungen anpassen Datenschnitte anzeigen oder ausblenden Größe und Eigenschaften von Datenschnitten Datenschnitt mit mehreren PivotTables verbinden Aktives Filtern mit der Zeitachse 3 Vertiefter Umgang mit PivotTable Gruppierung des Datums ändern Die Ansicht expandieren Eine Pivot-Tabelle kopieren Benutzerdefinierte Berechnungen für PivotTable-Wertefelder einsetzen Löschen eines PivotTable-Berichts oder PivotChart-Berichts Berechnungstypen im praktischen Einsatz % des Gesamtergebnisses berechnen % des Spaltenergebnisses % des Zeilenergebnisses % von % des übergeordneten Zeilenergebnisses % des übergeordneten Spaltenergebnisses % des übergeordneten Ergebnisses Differenz von % Differenz von Praxisbeispiel: Differenz zu einem vorherigen Basiselement in einem abweichenden Geschäftsjahr Laufende Summe von Rangfolge nach Größe (aufsteigend/absteigend) Index Praxisbeispiel: % Differenz und Fehlerbehandlung In PivotTable Fehlerdarstellungen bearbeiten Weitere Berechnungsmöglichkeiten in PivotTables So erstellen Sie ein berechnetes Feld in einer PivotTable So erstellen Sie ein berechnetes Element in einer PivotTable Lösungsreihenfolge für berechnete Elemente ändern Eine Liste der verwendeten Formeln erstellen So verwenden Sie die Funktion PIVOTDATENZUORDNEN () Zugriff auf Pivot-Daten Fehlermeldung der Funktion 4 In der Praxis: Logistikdienste mit PivotTables organisieren Überlegte Vorbereitung erleichtert das Arbeiten: als Datenbasis eine strukturierte Tabelle verwenden Die PivotTable erstellen Die PivotTable informativer machen Daten als Information flexibel anzeigen Die Anordnung macht’s: die Felder im informativsten Layoutbereich anzeigen Die Anzahl bestimmt die benötigte Kapazität In welches Hotel geht der Transfer des Teilnehmers? Den Check-in im Hotel planen Elegante Dynamik: mit Datenschnitten die Informationen komfortabel filtern Datenschnitte zum Filtern einbauen Die Steuerzentrale 5 Stundenabweichungsanalyse mit PivotTable Die Projektstruktur aufbauen Daten in PivotTable-Berichten auswerten Daten aus einem Vorsystem und der Planung übernehmen Daten aufbereiten, vervollständigen und pivotisieren Das Tabellenblatt WBS-Planung pivotisieren Importierte Daten pivotisieren und formatieren Dezimale Stundenangaben in Uhrzeitformat umwandeln Die Daten der Planung mit den Istdaten vergleichen und bewerten Zwei PivotTable-Berichte konsolidieren Zeitdifferenz berechnen Abweichungen hervorheben: weitere Formatierungen vornehmen Ein Projekt nach erweiterten Gesichtspunkten auswerten 6 Mit PivotTable einen Kostenträger überwachen und auswerten Ein Projekt nach erweiterten Gesichtspunkten aus werten Kostenstellenanalyse der Kostenträger 100112 und 1414 Nur die betroffenen Kostenträger anzeigen Kompaktansicht im Kostenträger: Details im Work Package ausblenden Mitarbeiter, die die angezeigte Leistung erbracht haben Die Gesamtkosten für den Kostenträger 100112 mit PivotTables berechnen Mehr Aussagekraft durch Neuanordnung der Wertefelder Die Stundenverteilung differenzieren - monatsweise anzeigen Ermitteln Sie die zeitlichen Arbeitsleistungen der Mitarbeiter in einem Projekt Die betroffenen Kostenstellen auswerten 7 Personal- und Personalstrukturanalyse mit PivotTable-Berichten Prozess der Analyse Welche Felder in der Basistabelle verändert oder berechnet werden Eine »intelligente« Tabelle Strukturen im Stellenplan und in den Tätigkeitsfeldern entdecken Zeigen Sie, wie viele Tätigkeitsfelder es im Unternehmen gibt Zeigen Sie die fünf Tätigkeitsfelder mit den meisten Mitarbeitern Neue Reihenfolge festlegen Prozentuale Darstellung wählen Prozentwerte und absolute Werte gleichzeitig darstellen Datenschnitte: mehr als nur einfache Filter Den Datenschnitt für die Vorselektion aufbauen Die Datenschnitte perfekt auf die Arbeitsumgebung einstellen Einstellungen für den Datenschnitt vornehmen Strukturanalyse zur Altersverteilung und Betriebszugehörigkeit Gruppen für Zeiträume bilden Aufbau des PivotTable-Berichts Betriebszugehörigkeit Betriebszugehörigkeit gruppieren Den Namen einer Feldschaltfläche anpassen Gruppen für Altersklassen bilden Die Anzahl der Mitarbeiter je Altersgruppe in den Tätigkeitsfeldern ermitteln Zeigen Sie in einer Grafik die Mitarbeiterverteilung in den Altersgruppen Das Layout des Diagramms verändern Zeigen Sie die grafische Verteilung der Betriebszugehörigkeit Die Betriebszugehörigkeit als Grafik Besondere Strukturen mit der PivotTable aufzeigen Zeigen Sie die Struktur der Betriebszugehörigkeit für das Tätigkeitsfeld Produktberater/-in an PivotTable-Bericht mit Minimum, Maximum und Durchschnittseinkommen je Altersgruppe Die Anzahl der Mitarbeiter einfügen, die die Berechnungsgrundlage bildet Mitarbeiter, die mehr als 120 Stunden monatlich tätig sind Auswertung auf ausgewählte Tätigkeitsfelder begrenzen 8 Wie Sie mit PivotTables Umsätze und Kosten berechnen und analysieren Aktion und Analyse Aufbau der PivotTable zur Kostenanalyse PivotTable in die Tabellenansicht und in ein neues Pivot-Format überführen Basisjahr 2019: Differenz der Kosten berechnen Basiswert des Jahres 2019 in die Ansicht des Berichts integrieren Die PivotTable informativer machen Prozentanteil des Deckungsbeitrages ermitteln Prozentanteil der Kosten am Umsatz 9 Mit PivotTable aggregieren: mit PIVOTDATENZUORDNENO Daten extrahieren Die Arbeitsweise der Funktion Syntax der Funktion Vorbereitung der Arbeitsumgebung Aufbau des Dashboards Die Auswahllisten erstellen Einrichten der Datenüberprüfung zur Auswahl der Steuergrößen Überprüfung der Auswahl und Folgeeinträge in den Steuertabellen Die Argumente der Funktion PIVOTDATENZUORDNEN() Die Funktion PIVOTDATENZUORDNENO entwickeln und dyna

Note: Table of contents Acknowledgements Chapter 1 - The restless ocean Chapter 2 - Frameworks, data, and methods Chapter 3 - Surface drift, gyres, and the fate of plastic Chapter 4 - Western boundary currents and drifting organisms Chapter 5 - Eastern boundary currents, upwelling, and high biological productivity Chapter 6 - The tropical oceans, interannual climate variability, and ecosystem adaptation Chapter 7 - From the northern subpolar oceans to the Arctic and its retreating sea ice Chapter 8 - From the Southern Ocean to Antarctica and its changing ice shelves Chapter 9 - Processes and flows in marginal seas Chapter 10 - Ocean boundaries, connectivity, and inter-ocean exchanges Chapter 11 - The global circulation and transformation of water masses Chapter 12 - Ocean currents, heat transport, and climate Epilogue: Looking ahead Index

Note: Contents Part I Atmosphere-Ocean Interaction and Physical Oceanography 1 Geostrophic and Wind-Driven Components of the Antarctic Circumpolar Current / Nikolay A. Diansky, Varvara V. Bagatinskaya, Anatoly V. Gusev, and Eugene G. Morozov 2 Multi-jet Structure of the Antarctic Circumpolar Current / Roman Yu Tarakanov 3 Frontal Zone Between Relatively Warm and Cold Waters in the Northern Weddell Sea / Eugene G. Morozov, Viktor A. Krechik, Dmitry I. Frey, Alexander A. Polukhin, Vladimir A. Artemiev, Valentina V. Kasyan, Philipp V. Sapozhnikov, and Rinat Z. Mukhametianov 4 Water Masses, Currents, and Phytoplankton in the Bransfield Strait in January 2020 / Eugene G. Morozov, Dmitry I. Frey, Viktor A. Krechik, Alexander A. Polukhin, and Philipp V. Sapozhnikov 5 Intra-annual Variability of Water Structure in the Atlantic Sector of the Southern Ocean Based on the ECMWF ORA-S3 and OI SST Reanalysis / Yuri V. Artamonov, Elena A. Skripaleva, Alexander V. Fedirko, and Nikolay V. Nikolsky 6 The Circulation and Mixing Zone in the Antarctic Sound in February 2020 / Alexander V. Krek, Elena V. Krek, and Viktor A. Krechik 7 Rogue Waves in the Drake Passage: Unpredictable Hazard / Ekaterina G. Didenkulova, Tatiana G. Talipova, and Efim N. Pelinovsky 8 Water Mass Transformation in the Powell Basin / Alina A. Fedotova and Svetlana V. Stepanova 9 Interannual Variations of Water Mass Properties in the Central Basin of the Bransfield Strait / Alina A. Fedotova and Sergey V. Kashin 10 Sea Surface Temperature and Ice Concentration Analysis Based on the NOAA Long-Term Satellite and Sea-Truth Data in the Atlantic Antarctic / Viktor V. Zamshin and Vladislav A. Shliupikov Part II Chemical Oceanography, Seawater Optical Properties, Productivity and Microbial Processes 11 Hydrochemical Structure of Waters in the Northern Weddell Sea in Austral Summer 2020 / Svetlana V. Stepanova, Alexander A. Polukhin, Gennadii V. Borisenko, Anna L. Chultsova, Evgeniia N. Marina, Oleg S. Popov, Anna M. Seliverstova, Anna V. Vidnichuk, and Petr P. Tishchenko 12 Features and Processes of the Oxygen and pCO2 Dynamics in the Surface Waters in the Western Parts of the Weddell and Scotia Seas (Southern Ocean) / Natalia A. Orekhova, Anna V. Vidnichuk, and Sergey K. Konovalov 13 Earth’s Insolation and Spatiotemporal Variability of Albedo in the Antarctic / Anton A. Bukatov and Margarita V. Babiy 14 Quantitative and Productional Characteristics of Microplankton in the Powell Basin and Bransfield Strait in Summer / Nadezda D. Romanova, Sergey A. Mosharov, Olga V. Vorobieva, and Elena V. Bardyukova 15 Detection of Thermophilic Methanotrophic Microbial Communities in the Water Column of the Bransfield Strait (Antarctica) / Anna L. Ponomareva, Nikita S. Polonik, Aleksandra V. Kim, and Renat B. Shakirov 16 Spectral Bio-optical Properties of Waters in the Bransfield Strait and Powell Basin / Tanya Ya Churilova, Nataliia A. Moiseeva, Tatiana V. Efimova, Vladimir A. Artemiev, Elena Y. Skorokhod, and Anatoly S. Buchelnikov 17 Variability of Seawater Optical Properties in the Adjacent Water Basins of the Antarctic Peninsula in January and February 2020 / Alexandr A. Latushkin, Vladimir A. Artemiev, Anton V. Garmashov, Pavel A. Salyuk, Inna V. Sahling, and Dmitry I. Glukhovets 18 Bio-Optical Models for Estimating Euphotic Zone Depth in the Western Atlantic Sector of the Southern Ocean in the Antarctic Summer / Pavel A. Salyuk, Vladimir A. Artemiev, Dmitry I. Glukhovets, Alexander N. Khrapko, Anatoly V. Grigoriev, Alexandr A. Latushkin, and Nadezda D. Romanova 19 Phycoerythrin Pigment Distribution in the Upper Water Layer Across the Weddell-Scotia Confluence Zone and Drake Passage / Pavel A. Salyuk, Dmitry I. Glukhovets, Alexander Yu. Mayor, Natalia A. Moiseeva, Vladimir A. Artemiev, and Alexander N. Khrapko 20 Nanophytoplankton in the Bransfield Strait: Contribution of Cryptophyta to the Community Abundance and Biomass During Austral Summer / Vladimir S. Mukhanov, Evgeny G. Sakhon, Aleksander A. Polukhin, and Vladimir A. Artemiev Part III Section Marine Ecosystems and Their Oceanographical Background 21 Phytopelagic Communities of the Powell Basin in the Summer of 2020 / Philipp V. Sapozhnikov, Olga Yu. Kalinina, and Tatiana V. Morozova 22 Bioluminescence in the Atlantic Sector of the Southern Ocean Based on the Field Observations and Sounding Data / Aleksandr V. Melnik, Viktor V. Melnikov, Lidiya A. Melnik, Olga V. Mashukova, and Sergei V. Kapranov 23 Parasites as an Inseparable Part of Antarctic and Subantarctic Marine Biodiversity / Tatyana A. Polyakova and Ilya I. Gordeev 24 Spatial Distribution, Species Composition, and Number of Seabirds in the Argentine Basin, Drake Passage, East of Antarctic Peninsula, and Powell Basin in January–March 2020 / Sergey P. Kharitonov, Alexander L. Mischenko, Nikolai B. Konyukhov, Alexander E. Dmitriyev, Andrey V. Tretyakov, Gleb Yu. Pilipenko, Svetlana M. Artemyeva, and Matvey S. Mamayev 25 Spatial Distribution, Species Composition, and Number of Marine Mammals in the Argentine Basin, Drake Passage, East of Antarctic Peninsula, and Powell Basin in January–March 2020 / Sergey P. Kharitonov, Andrey V. Tretyakov, Alexander L. Mischenko, Nikolai B. Konyukhov, Svetlana M. Artemyeva, Gleb Yu. Pilipenko, Matvey S. Mamayev, and Alexander E. Dmitriyev 26 Meat in the Ocean: How Much and Who Is to Blame? / Sergey P. Kharitonov, Andrey V. Tretyakov, and Alexander L. Mischenko 27 Macro- and Mesozooplankton in the Powell Basin (Antarctica): Species Composition and Distribution of Abundance and Biomass in February 2020 / Vladimir A. Yakovenko, Vassily A. Spiridonov, Konstantin M. Gorbatenko, Nickolai V. Shadrin, Ernest Z. Samyshev, and Natalia I. Minkina 28 Application of Autonomous Underwater Vehicles for Research of Ecosystems in the Southern Ocean / Alexander Yu. Konoplin, Alexey I. Borovik, Denis N. Mikhailov, Yuriy V. Vaulin, Alexander F. Scherbatyuk, Alexey A. Boreiko, Roman A. Babaev, Dmitriy A. Bolovin, and Dmitriy I. Tregubenko 29 Heavy Metals and Anthropogenic Radionuclides in the Region of the Antarctic Peninsula / Artem A. Paraskiv, Natalia Yu. Mirzoeva, Nataliya N. Tereshchenko, Vladislav Yu. Proskurnin, Ilya G. Sidorov, Svetlana I. Arkhipova, and Eugene G. Morozov

Note: Contents Contributors Editorial foreword Preface CHAPTER 1 Snow and ice-related hazards, risks, and disasters: Facing challenges of rapid change and long-term commitments / Wilfried Haeberli and Colin Whiteman 1.1 Introduction 1.2 Costs and benefits: Living with snow and ice 1.3 Small and large, fast and slow, local to global: Dealing with constraints 1.4 Beyond historical experience: Monitoring, modeling, and managing rapid and irreversible changes Acknowledgments References CHAPTER 2 Physical, thermal, and mechanical properties of snow, ice, and permafrost / Lukas Arenson (U.), William Colgan, and Hans Peter Marshall 2.1 Introduction 2.2 Density and structure 2.2.1 Snow 2.2.2 Ice 2.2.3 Frozen ground/permafrost 2.3 Thermal properties 2.3.1 Snow 2.3.2 Ice 2.3.3 Frozen ground 2.4 Mechanical properties 2.4.1 Brittle behavior 2.4.2 Ductile behavior 2.5 Electromagnetic and wave properties 2.5.1 Snow 2.5.2 Ice 2.5.3 Frozen ground 2.6 Summary Acknowledgment References.. CHAPTER 3 Snow and ice in the climate system / Atsumu Ohmura 3.1 Introduction 3.2 Physical extent of the cryosphere 3.3 Climatic conditions of the cryosphere 3.3.1 Snow cover 3.3.2 Sea ice 3.3.3 Permafrost 3.3.4 Glaciers References CHAPTER 4 Snow and ice in the hydrosphere / Jan Seibert, Michal Jenicek, Matthias Huss, Tracy Ewen, and Daniel Viviroli 4.1 Introduction 4.2 Snow accumulation and melt 4.2.1 Snowpack description 4.2.2 Snow accumulation 4.2.3 Snow redistribution, metamorphism, and ripening process 4.2.4 Snowpack development 4.2.5 Snowmelt 4.3 Glaciers and glacial mass balance 4.3.1 Glacier mass balance 4.3.2 Glacial drainage system 4.3.3 Modeling glacier discharge 4.4 Hydrology of snow- and ice-covered catchments 4.4.1 Influence of snow on discharge 4.4.2 Snowmelt runoff and climate change 4.4.3 Influence of glaciers on discharge 4.4.4 River ice 4.4.5 Seasonally frozen soil and permafrost 4.5 Concluding remarks References CHAPTER 5 Snow, ice, and the biosphere / Terry V. Callaghan and Margareta Johansson 5.1 Introduction 5.2 Adaptations to snow, ice, and permafrost. 5.3 Snow and ice as habitats 5.4 Snow as a moderator of habitat 5.4.1 Modification of winter habitat 5.4.2 Modification of nonwinter habitat 5.4.3 Effects of changing snow on the biosphere 5.5 Ice as a moderator of habitat 5.5.1 Mechanical effects of ice 5.5.2 Effects of changing lake and river ice on the biosphere 5.5.3 Effects of changing sea ice on the biosphere 5.6 Permafrost as a moderator of habitat 5.6.1 Effects of changing permafrost on the biosphere 5.6.2 Snow-permafrost-vegetation interactions 5.7 Vegetation as a moderator of snow, ice, and permafrost habitats 5.8 Conclusions Acknowledgments References CHAPTER 6 Ice and snow as land-forming agents / Darrel A. Swift, Simon Cook, Tobias Heckmann, Isabelle Gärtner-Roer, Oliver Korup, and Jeffrey Moore 6.1 Glacial processes and landscapes 6.1.1 Erosion mechanisms and their controls 6.1.2 Landforms and associated hazards 6.1.3 Landscape evolution and rates of glacial incision 6.1.4 Recommended avenues for further research 6.2 Periglacial and permafrost processes and landforms 6.2.1 Landforms and processes related to seasonal frost and permafrost 6.3 The role of snow in forming landscapes 6.3.1 Influence of snow cover on geomorphic processes 6.3.2 Snow-related geomorphic processes and landforms 6.3.3 Potential impacts of global change on snow-related geomorphic processes 6.3.4 Quantifying rates 6.3.5 Modeling 6.4 Conclusions and outlook Acknowledgments References CHAPTER 7 Mountains, lowlands, and coasts: The physiography of cold landscapes / Tobias Bolch and Hanne H. Christiansen 7.1 Introduction 7.2 Physiography of the terrestrial cryosphere 7.2.1 High altitudes/mountains 7.2.2 Cold lowlands 7.2.3 Cold coasts 7.3 Glaciers and ice sheets: Extent and distribution 7.4 Permafrost types, extent, and distribution 7.5 Glacier-permafrost interactions References CHAPTER 8 A socio-cryospheric systems approach to glacier hazards, glacier runoff variability, and climate change / Mark Carey, Graham McDowell, Christian Huggel, Becca Marshall, Holly Moulton, Cesar Portocarrero, Zachary Provant, John M. Reynolds, and Luis Vicuña 8.1 Introduction 8.2 Integrated adaptation in dynamic socio-cryospheric systems 8.3 Glacier and glacial lake hazards 8.3.1 Cordillera Blanca, Peru 8.3.2 Santa Teresa, Peru 8.3.3 Nepal 8.4 Volcano-ice hazards 8.5 Glacier runoff, hydrologic variability, and water use hazards 8.5.1 Nepal 8.5.2 Peru 8.6 Coastal resources and hazards 8.7 Discussion and conclusions Acknowledgments References CHAPTER 9 Integrative risk management: The example of snow avalanches / Michael Bründl and Stefan Margreth 9.1 Introduction 9.2 Risk analysis 9.2.1 Hazard analysis 9.2.2 Exposure and vulnerability analysis 9.2.3 Consequence analysis and calculation of risk 9.3 Risk evaluation 9.3.1 Evaluation of individual risk 9.3.2 Evaluation of collective risk 9.4 Mitigation of risk 9.4.1 Meaning of mitigation of risk 9.4.2 Technical avalanche mitigation measures 9.4.3 Land-use planning 9.4.4 Biological measures and protection forests 9.4.5 Organizational measures 9.5 Methods and tools for risk assessment and evaluation of mitigation measures 9.6 Case study “Evaluation of avalanche mitigation measures for Juneau, Alaska” 9.6.1 Introduction 9.6.2 Avalanche situation 9.6.3 Hazard analysis 9.6.4 Consequence analysis and risk evaluation 9.6.5 Protection measures 9.6.6 Conclusions 9.7 Final remarks References CHAPTER 10 Permafrost degradation / Dmitry Streletskiy 10.1 Introduction 10.2 Drivers of permafrost and active-layer change across space and time 10.2.1 Role of climate: Air temperature and liquid precipitation 10.2.2 Role of topography 10.2.3 Role of vegetation and snow 10.2.4 Role of soil properties 10.3 Observed permafrost and active-layer changes 10.4 Permafrost modeling and forecasting 10.5 Permafrost degradation and infrastructure hazards 10.5.1 Buildings on permafrost 10.5.2 Pipelines on permafrost 10.5.3 Railroads, roads, and utility on permafrost 10.6 Coastal erosion and permafrost 10.7 Summary Acknowledgments References CHAPTER 11 Radioactive waste under conditions of future ice ages / Urs H. Fischer, Anke Bebiolka, Jenny Brandefelt, Denis Cohen, Joel Harper, Sarah Hirschorn, Mark Jensen, Laura Kennell, Johan Liakka, Jens-Ove Näslund, Stefano Normani, Heidrun Stück, and Axel Weitkamp 11.1 Introduction 11.2 Timing of future glacial inception 11.2.1 Introduction 11.2.2 Definition of glacial inception 11.2.3 Controlling factors of glacial inception 11.2.4 Future long-term variations of insolation and atmospheric greenhouse gas concentrations 11.2.5 Modeling of future glacial inception 11.2.6 Timing of future glacial inception and concluding remarks 11.3 The glacier ice-groundwater interface: Constraints from a transect of the modern Greenland Ice Sheet 11.3.1 Background 11.3.2 Basal thermal state 11.3.3 Framework of the ice-bed interface 11.3.4 Basal water 11.3.5 Summary 11.4 Deep glacial erosion in the Alpine Foreland of northern Switzerland 11.4.1 Background 11.4.2 Ice age conditions 11.4.3 Processes of glacial erosion and glacial overdeepening 11.4.4 Water flow in overdeepenings 11.4.5 Deep glacial erosion in the Swiss Plateau 11.4.6 Future research focus 11.5 Tunnel valleys in Germany and their relevance to the long-term safety of nuclear waste repositories 11.5.1 Background 11.5.2 Formation of tunnel valleys 11.5.3 Tunnel valleys in Northern Germany 11.5.4 Tunnel valleys in the German North Sea 11.5.5 Glacial overdeepening in Southern Germany 11.5.6 Impact of tunnel valley formation on host rocks 11.6 Assessment of glacial impacts on geosphere stability and barrier capacity—Canadian perspective 11.6.1 Background 11.6.2 Bruce Nuclear Site—Location and geologic setting Acknowledgments References CHAPTER 12 Snow avalanches / Jürg Schweizer, Perry Bartelt, and Alec van Herwijnen 12.1 Introduction 12.2 The avalanche phenomenon 12.3 Avalanche release 12.3.1 Dry-snow avalanches 1

Note: Contents 1 Solar Thermal Energy Production in DSF Applied in the Human Comfort Improvements / Eusébio Conceição, Ma Inês Conceição, Ma Manuela Lúcio, João Gomes, André Ramos, and Hazim Awbi 2 Hydraulics Geometry Analysis of UPNM Channel / Zuliziana Suif, Saiful Syazwan Wahi Anuar, Nordila Ahmad, Maidiana Othman, and Siti Khadijah Che Osmi 3 Productivity Enhancement of Solar Still Distillation System Using Immersion-Type Water Heater / Nordila Ahmad, Norhasirah Mohd Isa, Zuliziana Suif, Maidana Othman, Jestin Jelani, and Jaafar Adnan 4 Stability Analysis of a Man-Made Slope: A Case Study on the UPNM Campus, Sg Besi, Kuala Lumpur / Jestin Jelani, Mohamad Saiful Adli Hah, Mohd Nazrin Mohd Daud, Nordila Ahmad, Maidiana Othman, and Wan Mohamed Syafuan Wan Mohamed Sabri 5 Comparison of the Full-Scale Municipal Wastewater Treatment Plant Designs Consisting of Modified Bardenpho Process with and Without Membrane Bioreactor for Nutrient Removal: Cost Analysis / Shahryar Jafarinejad 6 Analysis of the Influence of Wax Precipitation and Paraffin Control Technology on Environmental Protection / Deyin Zhao, Yi Zhao, Rongqiang Zhong, Lirong Yao, and Gaojie Liang 7 Impact of Abandoned Oil Well on Ecological Environment and Analysis of Geothermal Exploitation / Lirong Yao, Yi Zhao, Deyin Zhao, Rongqiang Zhong, and Jinbao Li 8 Numerical Evaluation of the Temperature Distribution in a Tree Trunk in a Forest Fire Environment / Eusébio Conceição, João Gomes, Maria Manuela Lúcio, Jorge Raposo, Domingos Xavier, and Maria Teresa Viegas 9 Analysis of Soluble Organic Polar Fractions from Sea Salt by GC–MS / Guo-hua Chang, Kang-ping Zhao, Bin Yue, Zhuo-xin Yin, Xiao-ke Li, and Hai-li Sun 10 Microplastics in Industrial Wastewater Treatment Plants: Dynamic Distribution, Seasonal Variation, and Removal Efficiencies / Sujarat Saiwaree and Vorapot Kanokkantapong 11 Spatial–Temporal Variation Analysis on Ecosystem Service Values in a Typical Inland River Basin, Northwest China / Mingtao Li, Lingfen Kang, and Chuancheng Zhao 12 Transportation of Chromium(VI) from Hydrochloric Acid Medium via a Dispersion Supported Liquid Membrane Using N235 / Yingxue Li, Yijian Zhong, Jiaheng Wu, Qingsong Shao, Xiaoyan Chen, and Yan Zhu 13 Effects of Important Factors on Determination of Metals in Soil Samples Using Hand-Held X-ray Fluorescence / Zhuoxin Yin, Yijun Wen, Weidong Chen, Fanxiang Han, Guohua Chang, and Caiping Yao 14 Collaboration Mapping in Sustainable Development: A Case Study from Haze in Chiang Mai / Pongtip Thiengburanathum 15 Greywater Treatment in Continuous Flow Solar Photocatalytic Reactor Using Graphite Supported Nitrogen-Doped TiO2 / Kumari Priyanka, Neelancherry Remya, and Manaswini Behera 16 Effect of Current and Electrodes Area to Color Removal Efficiency and Energy Consumption by Electrocoagulation Process / Bang-on Nareerob and Ponlakit Jitto 17 Accessing the Sustainable Developments Principle of Protection of the Mekong River’s Water Resources / Thuy Hang Tran, Hong Hanh Pham, and Thanh Hoa Ha 18 Key Technology and Economic Analysis of Using Fujiang River Water as the Cooling and Heating Sources for Air Conditioning System / Zhang Wei, Fu Daoyou, Yao Mingqiang, and Gan Shiyuan 19 Highly Effective Magnetic Silica-Chitosan Hybrid for Sulfate Ion Adsorption / Sukamto, Yuichi Kamiya, Bambang Rusdiarso, and Nuryono 20 Statistical Analysis of Water and Sediment Research in Heilongjiang River Basin / Ning Yu, Lei Zhang, Jun Li, and Yousheng Wang 21 Empowering Citizens’ Resilience - The FLOODLABEL / P. Meier, H. Meyer, A. Schüttrumpf, and G. Johann 22 Sustainable Environmental Planning of a Tourist Destination Bulgaria - State and Trends / Elenita Velikova 23 Analytical Approach for Sustainable Multi-Objective Management of Sediment-Algae Dynamics / Hidekazu Yoshioka and Saya Hashimoto 24 From Convergent to Ecological Transition—Challenges for the Management and Regional Development of Bulgaria / Georgi Tsolov and Nikola Tanakov 25 Comparison Methods of Carbon Oil Sorbents Hardening / Elena Ushakova, Liliya Soloveva, and Andrey Ushakov 26 Integration of Experimental and Numerical Methods to Investigate the Effect of Hydraulic Retention Time on Ultrafiltration Membrane Fouling / Meng Yao, Ting Chen, Zhilin Ran, Xiaoqing Dong, and Guosheng Wang 27 Using Electrodialysis to Recycle Chemical Polishing Agent from Anodizing Industry / Jih-Hsing Chang, Mohanraj Kumar, and Shan-Yi Shen 28 Methodological Aspects of Strategic Regional Planning for Achieving Sustainable Development in Bulgaria / Georgi Nikolov, Elka Vasileva, and Desislava Botseva 29 Study on the Model of Construction Safety Risk Evaluation Coupling Multiple Factors in Navigable Waters / Hui Sun, Yuchi Hao, Jiaming Qu, Ping Zhu, and Runli Tao 30 Distribution Characteristics of Plastic Particles in Coastal and Beach of Hsinchu, Taiwan / Ying-Fang Hsu, Feng-Hsin Chang, Pei-Yi Feng, Hsiao-Chien Huang, Chi-Yu Chuang, Shinhao Yang, and Wei-Ting Liu

Note: Contents 1 Introduction References 2 Meteorology as a Natural Science 2.1 Definition of the Atmosphere 2.2 Methods of Research of the Atmosphere 2.2.1 Experimental Method of Research 2.3 Relationship Between Meteorology and Other Sciences 2.4 Classification of Meteorology 2.4.1 Classification Based on the Studied Area 2.4.2 Classification According to the Scale of Processes 2.5 The Modern Term of Meteorology References 3 Historical Background 3.1 Aristotle’s Meteorologica 3.2 Early Research Period 3.3 Modern Research Period References 4 Structure and Composition of the Atmosphere 4.1 Earth Spheres 4.2 Basic Characteristics of the Atmosphere 4.3 Origin of the Atmosphere 4.4 Chemical Composition of the Atmosphere 4.5 Significant Atmospheric Gases 4.5.1 General Facts About the Atmosphere 4.6 Atmospheric Structure 4.6.1 Thermal Structure of the Atmosphere 4.7 Magneto-electronic Structure References 5 Energy and Radiation 5.1 Basic Features 5.2 Radiation Laws 5.3 Electromagnetic Radiation 5.4 Solar Radiation 5.4.1 Solar Constant 5.4.2 Direct Solar Radiation 5.4.3 Diffused Solar Radiation (D) 5.4.4 Solar Radiation Factors 5.4.5 Temporal and Spatial Changes in Insolation 5.5 Optical Radiation 5.5.1 UV Index 5.5.2 UV Index Factors 5.6 Ozone Layer 5.7 Earth Longwave Radiation 5.7.1 Earth’s Annual and Global Mean Energy Budget 5.7.2 Earth’s Heat Balance 5.7.3 Earth Radiation Budget and the Planetary Temperature 5.7.4 The Simple Greenhouse Model References 6 Atmospheric Thermodynamics 6.1 Definition 6.1.1 Thermodynamic System 6.2 An Ideal Gas Law 6.2.1 The Equation of State of Dry Air 6.2.2 The Equation of State of Moist Air 6.3 First Principle of Thermodynamics 6.3.1 The First Principle of Thermodynamics for an Ideal Gas 6.3.2 Enthalpy 6.3.3 Poisson Equations 6.3.4 Potential Temperature 6.3.5 Implementation of the First Principle of Thermodynamics 6.4 The Second Principle of Thermodynamics 6.4.1 Definition of Entropy 6.4.2 Summary on Reversible and Irreversible Processes References 7 Air Temperature 7.1 Air Temperature Definition 7.2 Heat and Temperature 7.2.1 Heat Transfer 7.3 Temperature Factors 7.3.1 Heat Advection 7.4 Temperature Changes 7.4.1 Daily Insolation and Pure Radiation 7.4.2 Daily Air Temperature Distribution 7.4.3 Vertical Temperature Change 7.4.4 Adiabatic Changes of Temperature 7.4.5 Temperature Inversion 7.4.6 Global Distributions of Temperature 7.4.7 Surface Temperatures 7.4.8 Urban Heat Island 7.5 Temperature Scales 7.6 Isotherms 7.7 Latitudinal Heat Balance References 8 Atmospheric Pressure and Wind 8.1 Mass of the Atmosphere 8.2 Definition of Atmospheric Pressure 8.3 Geopotential 8.4 Barometric Pressure Distribution 8.4.1 Pressure Gradient 8.4.2 Isobars 8.4.3 Isohypses 8.4.4 Hydrostatic Balance 8.5 Pressure Systems 8.6 Daily Pressure Distribution 8.7 Reduction of the Surface Pressure to Mean Sea Level Pressure (MSL) 8.8 Hydrostatic Equilibrium (Approximation) 8.9 Standard Atmosphere 8.10 Barotropic vs Baroclinic Atmosphere 8.11 Reduction on Atmospheric Pressure to Mean Sea Level Pressure 8.12 Stream Field 8.13 Definition of Wind 8.14 Classification of the Winds 8.14.1 Permanent Wind 8.14.2 Trade Winds 8.14.3 Anti-trade Winds 8.14.4 Periodic Winds 8.14.5 Local Winds 8.14.6 Land and Sea Breezes 8.14.7 Mountain and Valley Winds 8.14.8 Katabatic Winds References 9 Atmospheric Stability 9.1 Air Stability 9.2 Static Atmospheric Stability 9.3 Stability Due to Air Movement 9.4 Convective Instability 9.5 Low-Level Inversions References 10 Atmospheric Moisture 10.1 Water Vapour in the Atmosphere 10.2 Air Moisture Quantities 10.3 The Relative Humidity 10.4 The Moisture Deficit 10.5 A Dew Point Temperature 10.6 The Phase Changes 10.7 Condensation and Evaporation References 11 Clouds and Precipitation 11.1 Formation of Clouds 11.1.1 Air Saturation Mechanism 11.1.2 Adiabatic Cooling 11.1.3 Water Vapour Supply by Air Mixing 11.1.4 Mixing and Diffusion 11.1.5 Diabatic Cooling 11.1.6 Formation of Cloud Elements 11.1.7 Precipitation 11.1.8 The Mechanism of Ice Nucleation 11.1.9 Classification of the Microprocesses 11.2 Cloud Definition and Classification 11.2.1 Cloud Classification 11.2.2 Cloud Classification by Form 11.2.3 Cloud Classification Based on Height 11.2.4 International Cloud Classification 11.2.5 Cloud Classification by Composition 11.2.6 Classification by Mechanism of Formation 11.2.7 Special Clouds 11.3 Fog 11.3.1 Fog Types and Formation 11.4 Hydrometeors 11.4.1 Precipitation 11.4.2 Orographic Rainfall 11.4.3 Convective Rainfall 11.4.4 Frontal Rainfall References 12 Atmospheric Motion 12.1 Real Forces 12.1.1 Pressure Gradient Force 12.1.2 Gravity 12.1.3 Friction 12.2 The Forces That Are the Effects of Earth’s Rotation 12.2.1 Centrifugal Force 12.2.2 Coriolis Force (C) 12.3 Some Common Resultant Forces 12.3.1 Earth’s Gravity Force 12.3.2 Buoyancy Force 12.4 Atmospheric Motion 12.4.1 The Equation of Motion in a System Rotating Together with the Earth 12.5 Application of the Equations of Horizontal Motion 12.5.1 Geostrophic Wind (V g) 12.5.2 Thermal Wind (V T ) 12.5.3 Gradient Wind 12.5.4 Quasi-geostrophic Equations of Motion 12.6 Vertical Motions in the Atmosphere 12.7 Vorticity Equation 12.8 Basic Characteristics of Vorticity 12.8.1 Positive Vorticity Advection PVA and Upward Air Motion References 13 Atmospheric Waves 13.1 Waves: General Features 13.2 Wave Equation 13.2.1 Mathematical Description of 1-D Waves 13.3 Atmospheric Waves 13.3.1 History Studying Atmospheric Waves 13.3.2 Atmospheric Waves: Definition 13.3.3 Factors that Form a Wave 13.3.4 Basic Wave Properties and Classification 13.4 The Mathematical Concept of Atmospheric Waves 13.4.1 Atmospheric Sound Waves 13.4.2 Gravity Waves 13.4.3 Inertial-Gravity Waves 13.4.4 Rossby Waves References 14 Atmospheric Boundary Layer (ABL) 14.1 ABL Historical Overview 14.2 ABL Definition and Basic Characteristics 14.2.1 ABL Significance 14.3 ABL Structure 14.3.1 Surface Layer 14.3.2 Mixing Layer 14.3.3 Residual Layer 14.3.4 Stable Boundary Layer 14.3.5 Free Atmosphere 14.4 Factors Influence on ABL Structure 14.4.1 The Neutral PBL 14.4.2 The Ekman Wind Spiral 14.4.3 Unstable Stratified Atmospheric Boundary Layer References 15 General Circulation of the Atmosphere 15.1 General Atmospheric Circulation Definition 15.2 Conceptual Model of the General Atmospheric Circulation 15.3 Three-Cell Model of Circulation 15.3.1 Circulation in Hadley Cell 15.3.2 Intertropical Convergence Zone 15.3.3 Zonal Pressure Patterns 15.3.4 Upper Tropospheric Wind and Pressure Patterns 15.4 The Wind Patterns 15.4.1 Eastern and Western Winds 15.5 Global Distribution of Pressure, Rainfall, and Climate 15.6 Ocean Circulation 15.6.1 Major Ocean Currents 15.7 Ocean Waves 15.8 Large-Scale Circulation Modes 15.8.1 North Atlantic (NAO) and Artic Oscillation (AO) 15.8.2 El Niño-Southern Oscillation 15.8.3 La Nina 15.9 Winds at the Regional Scale: Monsoon 15.10 Jet Streams 15.10.1 A Waiver Jet Stream 15.11 Rossby Planetary Waves References 16 Air Masses and Fronts 16.1 Definition of Air Masses 16.1.1 Air Mass Source Region 16.1.2 Formation Criteria 16.2 Air Mass Classification 16.2.1 Polar Continental and Artic Continental Air Masses (cP and cA) 16.2.2 Maritime Polar Air Masses (mP) 16.2.3 Tropical Maritime Air Masses (mT) 16.3 Air Mass Modification 16.4 Fronts (Frontal Boundaries) 16.4.1 Types of Weather Fronts 16.4.2 Occluded Fronts References 17 Cyclones and Anticyclones 17.1 General Terms 17.2 Low-Pressure Systems: Cyclones 17.2.1 Formation of Extratropical Cyclone 17.2.2 Life Cycle of the Extratropical Cyclone 17.2.3 Cyclone Movement 17.2.4 Upper Level Low 17.3 High-Pressure System: Anticyclone 17.4 Weather Conditions Associate with Cyclones and Anticyclones References 18 Tropical Storms 18.1 General Overview 18.2 Tropical Cyclone Formation 18.2.1 General Factors 18.2.2 The Basic Ingredients 18.3 Areas of Formation 18.4 Classification of Tropical Cyclones 18.5 Tropical Storm Structure 18.5.1 Cyclonic Eye 18.5.2 Eyewall