Beginning with an introduction to array formulas, this manual examines topics such as how they differ from ordinary formulas, the benefits and drawbacks of their use, functions that can and cannot handle array calculations, and array constants and functions. Among the practical applications surveyed include how to extract data from tables and unique lists, how to get results that match any criteria, and how to utilize various methods for unique counts. This book contains 529 screen shots.

    A fascinating chronological guide to all the key events and people who have helped shape the world today.From the Big Bang through the rise and fall of the greatest empires to the great technological achievements of modern times, this book will help readers view our collective past in panorama, making sense of the confusing world in which we live today.Contents1) The Ancient World 2) The Medieval and Renaissance World3) The Enlightened World4) The Nineteenth Century5) The Modern World

    Born in England and emigrating to Queensland in 1883 in his early twenties, Morant was a charming but reckless man who established a reputation as a rider, polo player and writer. He submitted ballads to The Bulletin that were published under the name 'The Breaker' and counted Banjo Paterson as a friend. When appeals were made for horsemen to serve in the war in South Africa, Morant joined up, first with the South Australian Mounted Rifles and then with a South African irregular unit, the Bushveldt Carbineers.In October 1901 Morant and two other Australians, Lieutenants Peter Handcock and George Witton, were arrested for the murder of Boer prisoners. Morant and Handcock were court-martialled and executed in February 1902 as the Boer War was in its closing stages, but the debate over their convictions continues to this day.Does Breaker Morant deserve his iconic status? Who was Harry Morant? What events and passions led him to a conflict that was essentially an Imperial war, played out on a distant continent under a foreign flag? Was he a scapegoat for British war crimes or a criminal himself?With his trademark brilliant command of story, Peter FitzSimons unravels the many myths and fictions that surround the life of Harry Morant. The truths FitzSimons uncovers about 'The Breaker' and the part he played in the Boer War are astonishing - and, in the hands of this master storyteller, make compelling reading.

    But in the modern world, the breast is changing. Breasts are getting bigger, arriving earlier, and attracting newfangled chemicals. Increasingly, the odds are stacked against us in the struggle with breast cancer, even among men. What makes breasts so mercurial—and so vulnerable?In this informative and highly entertaining account, intrepid science reporter Florence Williams sets out to uncover the latest scientific findings from the fields of anthropology, biology, and medicine. Her investigation follows the life cycle of the breast from puberty to pregnancy to menopause, taking her from a plastic surgeon’s office where she learns about the importance of cup size in Texas to the laboratory where she discovers the presence of environmental toxins in her own breast milk. The result is a fascinating exploration of where breasts came from, where they have ended up, and what we can do to save them.

    His display of extraordinary courage that day saw him awarded the Victoria Cross for Australia, making him the first Australian to receive our highest award for bravery in wartime since Keith Payne in 1969.Yet Mark's journey to those crucial moments in Afghanistan was almost as exceptional as the acts that led to his VC.He was a rebellious child and teenager, even before the death of his father - a Vietnam veteran - when Mark and his brother were in their mid-teens. A few years later, their mother disappeared, presumed murdered. Her body has never been found.Mark's decisions could have easily led him down another path, to a life of self-destructiveness and petty crime. But he chose a different road: the army. It proved to be his salvation and he found himself a natural soldier, progressing unerringly to the SAS, the peak of the Australian military.From his turbulent early years to the stark realities of combat in the mountains and valleys of Afghanistan, Mark's book is the frank and compelling story of a man who turned his life around by sheer determination and strength of mind.

    Recent research has revealed dark surprises and yielded a radically new scenario of how AIDS began and spread. Excerpted and adapted from the book Spillover, with a new introduction by the author, Quammen's hair-raising investigation tracks the virus from chimp populations in the jungles of southeastern Cameroon to laboratories across the globe, as he unravels the mysteries of when, where, and under what circumstances such a consequential "spillover" can happen. An audacious search for answers amid more than a century of data, The Chimp and the River tells the haunting tale of one of the most devastating pandemics of our time.

    “They are often full of tragedy, sometimes laced with wonder, but always deeply aware that science does not exist in a social vacuum. They are beautiful, whether in their clarity of ideas, the elegance of their prose, or often both.” The essays in this year’s Best American Science and Nature Writing brought clarity to the complexity and bewilderment of 2020 and delivered us necessary information during a global pandemic. From an in-depth look at the moment of the virus’s outbreak, to a harrowing personal account of lingering Covid symptoms, to a thoughtful analysis on how the pandemic will impact the environment, these essays, as Yong says, “synthesize, evaluate, dig, unveil, and challenge,” imbuing a pivotal moment in history with lucidity and elegance.

    Revised and updated with lots of new material, this book is every bit as vital as the first edition. From the inequalities and absurdities of the so-called developed world to the vast scale of suffering wreaked by war, famine, and AIDS in developing countries, it paints a picture of incredible contrasts.This 2.0 edition again contains an eclectic selection of facts addressing a broad range of global issues, now with added emphasis on climate change, the decline in human rights and democratic freedoms around the world, the unexpected global impact of corporate growth, sports and media madness and inequality, and lots of updated facts and figures. Each is followed by a short essay explaining the story behind the fact, fleshing out the bigger problem lurking behind the numbers. Real-life stories, anecdotes, and case studies help to humanize the figures and make clear the human impact of the bald statistics.All of the facts remind us that whether we like to think of it or not, the world is interconnected and civilization is a fragile concept. Williams makes us think about some of the hard facts about our civilization, and what we can do about them.Jessica Williams is a journalist and producer of the BBC's flagship international interview program, HARDTalk with Tim Sebastian, where she has researched and produced interviews with such disparate figures as the political philosopher Noam Chomsky, President Paul Kagame of Rwanda, Sir David Attenborough, and the academic Edward Said.

    On January 26, no Australian can really look away.'Since publishing his critically acclaimed, Walkley Award-winning, bestselling memoir Talking to My Country in early 2016, Stan Grant has been crossing the country, talking to huge crowds everywhere about how racism is at the heart of our history and the Australian dream. But Stan knows this is not where the story ends.In this book, Australia Day, his long-awaited follow up to Talking to My Country, Stan talks about our country, about who we are as a nation, about the indigenous struggle for belonging and identity in Australia, and what it means to be Australian. A sad, wise, beautiful, reflective and troubled book, Australia Day asks the questions that have to be asked, that no else seems to be asking. Who are we? What is our country? How do we move forward from here?

    ‘From page one the book is entertaining, sophisticated and provocative, and we see Malcolm as we have never seen him before.’Mr Turnbull said, ‘The only thing that is more fun than writing an adventure story is living it. I love stories, and love telling them. And this time I am telling my own – an Australian adventure.’

    Drawing on momentous (yet dimly remembered) historical epidemics, contemporary analyses, and cutting-edge research from a range of scientific disciplines, bestselling author, physician, sociologist, and public health expert Nicholas A. Christakis explores what it means to live in a time of plague—an experience that is paradoxically uncommon to the vast majority of humans who are alive, yet deeply fundamental to our species.Unleashing new divisions in our society as well as opportunities for cooperation, this 21st-century pandemic has upended our lives in ways that will test, but not vanquish, our already frayed collective culture. Featuring new, provocative arguments and vivid examples ranging across medicine, history, sociology, epidemiology, data science, and genetics, Apollo's Arrow envisions what happens when the great force of a deadly germ meets the enduring reality of our evolved social nature.

    Their deaths in the late 1970s marked the end of a tribal lifestyle that stretched back more than 30,000 years. The Last of the Nomads tells of an extraordinary journey in search of Warri and Yatungka.

    It shows how the UN's Intergovernmental Panel on Climate Change is run by a small group of 'global warming' zealots, who have repeatedly rigged evidence to support their theory. But the politicians, pushed by the media, have so fallen for its propaganda that, short of dramatic change, our Western world now faces an unprecedented disaster.

    Laughlin transports us two centuries into the future, when we've ceased to use carbon from the ground--either because humans have banned carbon burning or because fuel has simply run out. Boldly, Laughlin predicts no earth-shattering transformations will have taken place. Six generations from now, there will still be soccer moms, shopping malls, and business trips. Firesides will still be snug and warm.How will we do it? Not by discovering a magic bullet to slay our energy problems, but through a slew of fascinating technologies, drawing on wind, water, and fire. Powering the Future is an objective yet optimistic tour through alternative fuel sources, set in a world where we've burned every last drop of petroleum and every last shovelful of coal.The Predictable: Fossil fuels will run out. The present flow of crude oil out of the ground equals in one day the average flow of the Mississippi River past New Orleans in thirteen minutes. If you add the energy equivalents of gas and coal, it's thirty-six minutes. At the present rate of consumption, we'll be out of fossil fuels in two centuries' time. We always choose the cheapest gas. From the nineteenth-century consolidation of the oil business to the California energy crisis of 2000-2001, the energy business has shown, time and again, how low prices dominate market share. Market forces--not green technology--will be the driver of energy innovation in the next 200 years. The laws of physics remain fixed. Energy will still be conserved, degrade entropically with use, and have to be disposed of as waste heat into outer space. How much energy a fuel can pack away in a given space is fixed by quantum mechanics--and if we want to keep flying jet planes, we will need carbon-based fuels. The Potential: Animal waste. If dried and burned, the world's agricultural manure would supply about one-third as much energy as all the coal we presently consume. Trash. The United States disposes of 88 million tons of carbon in its trash per year. While the incineration of waste trash is not enough to contribute meaningfully to the global demand for energy, it will constrain fuel prices by providing a cheap supply of carbon. Solar energy. The power used to light all the cities around the world is only one-millionth of the total power of sunlight pouring down on earth's daytime side. And the amount of hydropump storage required to store the world's daily electrical surge is equal to only eight times the volume of Lake Mead. PRAISE FOR ROBERT B. LAUGHLIN -Perhaps the most brilliant theoretical physicist since Richard Feynman---George Chapline, Lawrence Livermore National Laboratory -Powerful but controversial.--- Financial Times -[Laughlin's] company ... is inspirational.- --New Scientist

    The story was made into a movie in 1980, "Breaker Morant," starring Edward Woodward, Lewis Fitz-Gerald, and Jack Thompson. 240 pp. printed on cream acid-free paper. Illustrated with half-tone photographs. First Clock & Rose trade edition in paperback, preceded by a limited edition of 1,000, individually numbered, and first trade edition in hardcover. The Clock & Rose Press edition is published and printed in the USA.