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.

    He helped save the world’s last unprotected redwoods. He co-created the predecessor to today’s Green New Deal. And he led a successful effort by climate scientists and activists to keep nuclear plants operating, preventing a spike of emissions.But in 2019, as some claimed “billions of people are going to die,” contributing to rising anxiety, including among adolescents, Shellenberger decided that, as a lifelong environmental activist, leading energy expert, and father of a teenage daughter, he needed to speak out to separate science from fiction.Despite decades of news media attention, many remain ignorant of basic facts. Carbon emissions peaked and have been declining in most developed nations for over a decade. Deaths from extreme weather, even in poor nations, declined 80 percent over the last four decades. And the risk of Earth warming to very high temperatures is increasingly unlikely thanks to slowing population growth and abundant natural gas.Curiously, the people who are the most alarmist about the problems also tend to oppose the obvious solutions.What’s really behind the rise of apocalyptic environmentalism? There are powerful financial interests. There are desires for status and power. But most of all there is a desire among supposedly secular people for transcendence. This spiritual impulse can be natural and healthy. But in preaching fear without love, and guilt without redemption, the new religion is failing to satisfy our deepest psychological and existential needs.

    Over years of groundbreaking experiments, he has distilled remarkable discoveries significant enough to become the bedrock of a whole new scientific field: social physics. Humans have more in common with bees than we like to admit: We’re social creatures first and foremost. Our most important habits of action—and most basic notions of common sense—are wired into us through our coordination in social groups. Social physics is about idea flow, the way human social networks spread ideas and transform those ideas into behaviors. Thanks to the millions of digital bread crumbs people leave behind via smartphones, GPS devices, and the Internet, the amount of new information we have about human activity is truly profound. Until now, sociologists have depended on limited data sets and surveys that tell us how people say they think and behave, rather than what they actually do. As a result, we’ve been stuck with the same stale social structures—classes, markets—and a focus on individual actors, data snapshots, and steady states. Pentland shows that, in fact, humans respond much more powerfully to social incentives that involve rewarding others and strengthening the ties that bind than incentives that involve only their own economic self-interest. Pentland and his teams have found that they can study patterns of information exchange in a social network without any knowledge of the actual content of the information and predict with stunning accuracy how productive and effective that network is, whether it’s a business or an entire city. We can maximize a group’s collective intelligence to improve performance and use social incentives to create new organizations and guide them through disruptive change in a way that maximizes the good. At every level of interaction, from small groups to large cities, social networks can be tuned to increase exploration and engagement, thus vastly improving idea flow.  Social Physics will change the way we think about how we learn and how our social groups work—and can be made to work better, at every level of society. Pentland leads readers to the edge of the most important revolution in the study of social behavior in a generation, an entirely new way to look at life itself.

    Veteran world-renowned author Dan Gookin walks you through everything from getting started with setup and configuration to making the most of your phone's potential with texting, e-mailing, accessing the Internet and social networking sites, using the camera, synching with a PC, downloading apps, and more.Covers all the details of the operating system that applies to every Android phone, including Motorola Droids, HTC devices, Samsung Galaxy S phones, to name a few Walks you through basic phone operations while also encouraging you to explore your phone's full potential Serves as an ideal guide to an inexperienced Android newbie who is enthusiastic about getting a handle on everything an Android phone can do Android Phones For Dummies helps you get smarter with your Android smartphone.

    Then came the fall of the Berlin Wall and the implosion of the Soviet Union; suddenly, unpredictability became a universal theme and foresight was critical. For the past decade, Burrows has overseen the creation of the Global Trends report—the key futurist guide for the White House, Departments of State and Defense, and Homeland Security. Global Trends has a history of making bold predictions and being right:* In 2004, it argued that al-Qaeda's centralized operations would dissolve and be replaced by groups, cells, and individuals—the very model of the 2012 Boston bombings.* In 2008, it included a scenario dubbed October Surprise, imagining a devastating late-season hurricane hitting an unprepared New York City.In The Future, Declassified, Burrows—for the first time—has expanded the most recent Global Trends report into a full-length narrative, forecasting the tectonic shifts that will drive us to 2030. A staggering amount of wholesale change is happening—from unprecedented and widespread aging to rampant urbanization and growth in a global middle class to an eastward shift in economic power and a growing number of disruptive technologies. Even our physical geography is changing as sea levels rise and faster commercial shipping routes open up through a warming Arctic region.The book concludes with its most provocative section: four fictional paths to 2030 with imagined storylines and characters based on analysis by the most authoritative figures in the intelligence community. As Burrows argues, we are living through some of the greatest and most momentous developments in history. Either we take charge and direct those or we are at their mercy. The stakes are particularly high for America's standing in the world and for ordinary Americans who want to maintain their quality of life. Running the gamut from scary to reassuring, this riveting book is essential reading.

    Since 2001, newspaper and music revenues have fallen by 70%, book publishing, film and television profits have also fallen dramatically. Revenues at Google in this same period grew from $400 million to $74.5 billion. Google's YouTube today controls 60% of the streaming audio business and pays only 11% of the streaming audio revenues. More creative content is being consumed than ever before, but less revenue is flowing to creators and owners of the content.With the reallocation of money to monopoly platforms comes a shift in power. Google, Facebook, and Amazon now enjoy political power on par with Big Oil and Big Pharma, which in part explains how such a tremendous shift in revenues from artists to platforms could have been achieved and why it has gone unchallenged for so long.The stakes in this story go far beyond the livelihood of any one musician or journalist. As Taplin observes, the fact that more and more Americans receive their news, music and other forms of entertainment from a small group of companies poses a real threat to democracy. Move Fast and Break Things offers a vital, forward-thinking prescription for how artists can reclaim their audiences using knowledge of the past and a determination to work together. Using his own half-century career as a music and film producer and early pioneer of streaming video online, Taplin offers new ways to think about the design of the World Wide Web and specifically the way we live with the firms that dominate it.Table of contentsIntroduction1. The Great Disruption2. Levon's Story3. Tech's Counterculture Roots4. The Libertarian Counterinsurgency5. Digital Destruction6. Monopoly in the Digital Age7. Google's Regulatory Capture8. The Social Media Revolution9. Pirates of the Internet10. Libertarian and the 1 Percent11. What It Means to Be Human12. The Digital RenaissanceAfterword

    After decades of sci-fi fantasies and hype, artificial intelligence has leapt out of research labs and Silicon Valley engineering departments and into the center of our lives. Algorithms shape everything around us, from the news we see to the products we buy and the relationships we form. And while the debate over whether or not automation will destroy jobs rages on, a much more important question is being ignored:What does it mean to be a human in a world that is increasingly built by and for machines?In Futureproof: 9 Rules for Humans in the Age of Automation, New York Times technology columnist Kevin Roose lays out a hopeful, pragmatic vision of how people can succeed in the machine age by making themselves irreplaceably human. He shares the secrets of people and organizations that have survived technological change, and explains how we can protect our own futures, with lessons like- Do work that is surprising, social, and scarce (the types of work machines can't do). - Demote your phone. - Work near other people. - Treat A.I. like an army of chimpanzees. - Add more friction to your life.Roose rejects the conventional wisdom that in order to compete with machines, we have to become more like them--hyper-efficient, data-driven, code-writing workhorses. Instead, he says, we should let machines be machines, and focus on doing the kinds of creative, inspiring, and meaningful things only humans can do.

     We are living in a time of deep divisions. Americans are sorting themselves along racial, religious, and cultural lines, leading to a level of polarization that the country hasn't seen since the Civil War. Pundits and politicians are calling for us to come together, to find common purpose. But how, exactly, can this be done?In Palaces for the People, Eric Klinenberg suggests a way forward. He believes that the future of democratic societies rests not simply on shared values but on shared spaces: the libraries, childcare centers, bookstores, churches, synagogues, and parks where crucial, sometimes life-saving connections, are formed. These are places where people gather and linger, making friends across group lines and strengthening the entire community. Klinenberg calls this the "social infrastructure" When it is strong, neighborhoods flourish; when it is neglected, as it has been in recent years, families and individuals must fend for themselves.Klinenberg takes us around the globe--from a floating school in Bangladesh to an arts incubator in Chicago, from a soccer pitch in Queens to an evangelical church in Houston--to show how social infrastructure is helping to solve some of our most pressing challenges: isolation, crime, education, addiction, political polarization, and even climate change.Richly reported, elegantly written, and ultimately uplifting, Palaces for the People urges us to acknowledge the crucial role these spaces play in civic life. Our social infrastructure could be the key to bridging our seemingly unbridgeable divides--and safeguarding democracy.

    With this book you will learn how to tap into every Kindle Fire feature, including many of the hidden ones not discussed in other books. From setting up your Kindle Page, managing your music, watching movies, and downloading content - this book covers everything. The task based full-color format allows you to quickly and easily find the exact task you want to accomplish and walks you through it in a delightfully concise and visual manner. My Kindle Fire makes it easy for you to:• Master all the basics, fast: reading, playing, watching, browsing, and more• Tweak your Kindle Fire for quicker access and longer battery life• Sample best-seller book chapters for free• Mark up any eBook with highlights, notes, and bookmarks• Convert your personal documents for use on Kindle Fire• Discover Calibre, a powerful eBook management tool• Control even the largest music libraries• Get instant answers from Wikipedia, and from Kindle Fire’s built-in dictionary• Listen to personalized Internet radio stations created just for you• Use your Kindle Fire as a digital photo frame• Prevent unwanted subscription charges• Set up any email account to work on your Kindle Fire• Explore any web content with Amazon’s innovative Silk browser• Use Amazon Cloud to get your stuff anywhere—even if you left your Kindle at home• And much much more…Unlike many other guides which might only briefly mention or skip over some very import Kindle Fire features My Kindle Fire covers everything. Here are just a few of the things you'll find in My Kindle Fire that aren't covered in other guides: • Full coverage of Calibre, a free application for Mac or PC that helps manage your eBook library• A large number of walkthroughs for managing music playlists, including how to use cloud playlists. • How to reinstall multiple apps at once in case you reset your Kindle Fire. • Step-by-step walkthroughs on configuring all types of email accounts. • Coverage on handling attachments in your email application. • Importing contacts from your existing email application or cloud service and how you can export your contacts in order to back them up. • How to use Copy and Paste on the Kindle Fire. • How to use social networking integration with Facebook and others. • Walkthroughs on using the Gallery app, Pandora, Audible, and other popular apps. • Shows you how to access files on other computers in your house right from your Kindle Fire.

    Desertification. Species extinction. Global warming. Growing threats to food and water. The driving issues of our times are the result of one huge problem: Us. As the population continues to grow, our problems will increase. And this means that every way we look at it, a planet of ten billion people is likely to be a nightmare. Stephen Emmott, a scientist whose lab is at the forefront of research into complex natural systems, sounds the alarm. TEN BILLION is a snapshot of our planet, and our species, approaching a crisis, and a stark analysis of where this leaves us. TEN BILLION is not another climate book. TEN BILLION is a book about us.

    Blockchain protocols are taking the world by storm, and the Ethereum project, with its Turing-complete scripting language Solidity, has rapidly become a front-runner. This book presents the blockchain phenomenon in context; then situates Ethereum in a world pioneered by Bitcoin.See why professionals and non-professionals alike are honing their skills in smart contract patterns and distributed application development. You'll review the fundamentals of programming and networking, alongside its introduction to the new discipline of crypto-economics. You'll then deploy smart contracts of your own, and learn how they can serve as a back-end for JavaScript and HTML applications on the Web.Many Solidity tutorials out there today have the same flaw: they are written for "advanced" JavaScript developers who want to transfer their skills to a blockchain environment. Introducing Ethereum and Solidity is accessible to technology professionals and enthusiasts of all levels. You'll find exciting sample code that can move forward real world assets in both the academic and the corporate arenas. Find out now why this book is a powerful gateway for creative technologists of all types, from concept to deployment.What You'll LearnSee how Ethereum (and other cryptocurrencies) workCompare distributed apps (dapps) to web appsWrite Ethereum smart contracts in Solidity Connect Ethereum smart contracts to your HTML/CSS/JavaScript web applicationsDeploy your own dapp, coin, and blockchainWork with basic and intermediate smart contractsWho This Book Is For Anyone who is curious about Ethereum or has some familiarity with computer science Product managers, CTOs, and experienced JavaScript programmersExperts will find the advanced sample projects in this book rewarding because of the power of Solidity

    The term “complexity” can be misleading, however, because what makes West’s discoveries so beautiful is that he has found an underlying simplicity that unites the seemingly complex and diverse phenomena of living systems, including our bodies, our cities and our businesses. Fascinated by issues of aging and mortality, West applied the rigor of a physicist to the biological question of why we live as long as we do and no longer. The result was astonishing, and changed science, creating a new understanding of energy use and metabolism: West found that despite the riotous diversity in the sizes of mammals, they are all, to a large degree, scaled versions of each other. If you know the size of a mammal, you can use scaling laws to learn everything from how much food it eats per day, what its heart-rate is, how long it will take to mature, its lifespan, and so on. Furthermore, the efficiency of the mammal’s circulatory systems scales up precisely based on weight: if you compare a mouse, a human and an elephant on a logarithmic graph, you find with every doubling of average weight, a species gets 25% more efficient—and lives 25% longer. This speaks to everything from how long we can expect to live to how many hours of sleep we need. Fundamentally, he has proven, the issue has to do with the fractal geometry of the networks that supply energy and remove waste from the organism's body. West's work has been game-changing for biologists, but then he made the even bolder move of exploring his work's applicability to cities. Cities, too, are constellations of networks and laws of scalability relate with eerie precision to them. For every doubling in a city's size, the city needs 15% less road, electrical wire, and gas stations to support the same population. More amazingly, for every doubling in size, cities produce 15% more patents and more wealth, as well as 15% more crime and disease. This broad pattern lays the groundwork for a new science of cities. Recently, West has applied his revolutionary work on cities and biological life to the business world. This investigation has led to powerful insights into why some companies thrive while others fail. The implications of these discoveries are far-reaching, and are just beginning to be explored. Scale is a thrilling scientific adventure story about the elemental natural laws that bind us together in simple but profound ways. Through the brilliant mind of Geoffrey West, we can envision how cities, companies and biological life alike are dancing to the same simple, powerful tune, however diverse and unrelated they are to each other.From the Hardcover edition.

    talks with some of the most revered voices in the nation, including Warren Buffett; former Treasury Secretaries Paul O'Neill and Robert Rubin; and Pete Peterson, CEO of The Blackstone Group. Defiantly non-partisan, the empowering solutions outlined in these pages are a must-read for any American concerned about the current state of affairs.

    Deeply attuned to the cycles of democratic expansion and decay that determine the fates of nations, he watched with mounting unease as illiberal rulers rose in Hungary, Poland, Turkey, the Philippines, and beyond, while China and Russia grew increasingly bold and bullying. Then, with Trump's election at home, the global retreat from freedom spread from democracy's margins to its heart.Ill Winds' core argument is stark: the defense and advancement of democratic ideals relies on U.S. global leadership. If we do not reclaim our traditional place as the keystone of democracy, today's authoritarian swell could become a tsunami, providing an opening for Vladimir Putin, Xi Jinping, and their admirers to turn the twenty-first century into a dark time of despotism.We are at a hinge in history, between a new era of tyranny and an age of democratic renewal. Free governments can defend their values; free citizens can exercise their rights. We can make the internet safe for liberal democracy, exploit the soft, kleptocratic underbelly of dictatorships, and revive America's degraded democracy. Ill Winds offers concrete, deeply informed suggestions to fight polarization, reduce the influence of money in politics, and make every vote count.In 2020, freedom's last line of defense still remains We the people.

    A brilliant exploration into the soiled heart of the American trash can.Into our trash cans go dead batteries, dirty diapers, bygone burritos, broken toys, tattered socks, eight-track cassettes, scratched CDs, banana peels … But where do these things go next? In a country that consumes and then casts off more and more, what actually happens to the things we throw away?