Written by the world’s foremost PowerPivot blogger and practitioner, the book’s concepts and approach are introduced in a simple, step-by-step manner tailored to the learning style of Excel users everywhere. The techniques presented allow users to produce, in hours or even minutes, results that formerly would have taken entire teams weeks or months to produce. It includes lessons on the difference between calculated columns and measures; how formulas can be reused across reports of completely different shapes; how to merge disjointed sets of data into unified reports; how to make certain columns in a pivot behave as if the pivot were filtered while other columns do not; and how to create time-intelligent calculations in pivot tables such as “Year over Year” and “Moving Averages” whether they use a standard, fiscal, or a complete custom calendar. The “pattern-like” techniques and best practices contained in this book have been developed and refined over two years of onsite training with Excel users around the world, and the key lessons from those seminars costing thousands of dollars per day are now available to within the pages of this easy-to-follow guide. This updated second edition covers new features introduced with Office 2015.

    How did he pull it off? Was it his appeal to alienated voters in the battleground states? Was it Hillary Clinton and the scandals associated with her long career in politics? Were key factors already in place before the nominees were even chosen? Identity Crisis provides a gripping account of the campaign that appeared to break all the political rules--but in fact didn't.Identity Crisis takes readers from the bruising primaries to an election night whose outcome defied the predictions of the pollsters and pundits. The book shows how fundamental characteristics of the nation and its politics--the state of the economy, the Obama presidency, and the demographics of the political parties--combined with the candidates' personalities and rhetoric to produce one of the most unexpected presidencies in history. Early on, the fundamental characteristics predicted an extremely close election. And even though Trump's many controversies helped Clinton maintain a comfortable lead for most of the campaign, the prediction of a close election became reality when Americans cast their votes.Identity Crisis reveals how Trump's victory was foreshadowed by changes in the Democratic and Republican coalitions that were driven by people's racial and ethnic identities. The campaign then reinforced and exacerbated those cleavages as it focused on issues related to race, immigration, and religion. The result was an epic battle not just for the White House but about what America is and should be.

    Infrastructure is not only the underground pipes and cables controlling our cities. It also determines the hidden rules that structure the spaces all around us – free trade zones, smart cities, suburbs, and shopping malls. Extrastatecraft charts the emergent new powers controlling this space and shows how they extend beyond the reach of government. Keller Easterling explores areas of infrastructure with the greatest impact on our world – examining everything from standards for the thinness of credit cards to the urbanism of mobile telephony, the world’s largest shared platform, to the “free zone,” the most virulent new world city paradigm. In conclusion, she proposes some unexpected techniques for resisting power in the modern world.Extrastatecraft will change the way we think about urban spaces – and how we live in them.

    The long-anticipated revision of this best-selling text offers the most comprehensive, up-to-date introduction to the theory and practice of artificial intelligence. *NEW-Nontechnical learning material-Accompanies each part of the book. *NEW-The Internet as a sample application for intelligent systems-Added in several places including logical agents, planning, and natural language. *NEW-Increased coverage of material - Includes expanded coverage of: default reasoning and truth maintenance systems, including multi-agent/distributed AI and game theory; probabilistic approaches to learning including EM; more detailed descriptions of probabilistic inference algorithms. *NEW-Updated and expanded exercises-75% of the exercises are revised, with 100 new exercises. *NEW-On-line Java software. *Makes it easy for students to do projects on the web using intelligent agents. *A unified, agent-based approach to AI-Organizes the material around the task of building intelligent agents. *Comprehensive, up-to-date coverage-Includes a unified view of the field organized around the rational decision making pa

    How did the “land of the free” become the home of the world’s largest prison system? Challenging the belief that America’s prison problem originated with the Reagan administration’s War on Drugs, Elizabeth Hinton traces the rise of mass incarceration to an ironic source: the social welfare programs of Lyndon Johnson’s Great Society at the height of the civil rights era.Johnson’s War on Poverty policies sought to foster equality and economic opportunity. But these initiatives were also rooted in widely shared assumptions about African Americans’ role in urban disorder, which prompted Johnson to call for a simultaneous War on Crime. The 1965 Law Enforcement Assistance Act empowered the national government to take a direct role in militarizing local police. Federal anticrime funding soon incentivized social service providers to ally with police departments, courts, and prisons. Under Richard Nixon and his successors, welfare programs fell by the wayside while investment in policing and punishment expanded. Anticipating future crime, policymakers urged states to build new prisons and introduced law enforcement measures into urban schools and public housing, turning neighborhoods into targets of police surveillance.By the 1980s, crime control and incarceration dominated national responses to poverty and inequality. The initiatives of that decade were less a sharp departure than the full realization of the punitive transformation of urban policy implemented by Republicans and Democrats alike since the 1960s.

    strategy" (Washington Post Book World) from the vantage point of its fiercest opponents. Stephen M. Walt examines America's place as the world's singular superpower and the strategies that rival states have devised to counter it. Hailed as a "landmark book" by Foreign Affairs, Taming American Power makes the case that this ever-increasing tide of opposition not only could threaten America's ability to achieve its foreign policy goals today but also may undermine its dominant position in years to come.

    What distinguishes Sassen's theoretical framework is the emphasis on the formation of cross-border dynamics through which these cities and the growing number of other global cities begin to form strategic transnational networks. All the core data in this new edition have been updated, while the preface and epilogue discuss the relevant trends in globalization since the book originally came out in 1991.

    From art museums and university hospitals to think tanks and church charities, over 1.5 million organizations of staggering diversity share the tax-exempt 501(c)(3) designation, if little else. Many social justice organizations have joined this world, often blunting political goals to satisfy government and foundation mandates. But even as funding shrinks and government surveillance rises, many activists often find it difficult to imagine movement-building outside the nonprofit model. The Revolution Will Not Be Funded gathers original essays by radical activists from around the globe who are critically rethinking the long-term consequences of this investment. Together with educators and nonprofit staff they finally name the “nonprofit industrial complex” and ask hard questions: How did politics shape the birth of the nonprofit model? How does 501(c)(3) status allow the state to co-opt political movements? Activists--or careerists? How do we fund the movement outside this complex? Urgent and visionary, The Revolution Will Not Be Funded is an unbeholden exposé of the “nonprofit industrial complex” and its quietly devastating role in managing dissent.

    But as political scientist Jonathan A. Rodden demonstrates in Why Cities Lose, the left's electoral challenges have deeper roots in economic and political geography.In the late nineteenth century, support for the left began to cluster in cities among the industrial working class. Today, left-wing parties have become coalitions of diverse urban interest groups, from racial minorities to the creative class. These parties win big in urban districts but struggle to capture the suburban and rural seats necessary for legislative majorities. A bold new interpretation of today's urban-rural political conflict, Why Cities Lose also points to electoral reforms that could address the left's under-representation while reducing urban-rural polarization.

    My crime? As the publisher of Western Standard magazine, I had reprinted the Danish cartoons of Mohammed to illustrate a news story. I was charged with the offence of “discrimination,” and made to appear before Alberta’s “human rights commission” for questioning. As crazy as it sounds, I became the only person in the world to face legal sanction for printing those cartoons.”As a result of this highly publicized event, Ezra Levant began investigating other instances in which innocent people have had their freedoms compromised by bureaucrats presuming to protect Canadians’ human rights. He discovered some disturbing and even bizarre cases, such as the tribunal ruling that an employee at a McDonald’ s restaurant in Vancouver did not have to wash her hands at work. And the human rights complaint filed by a Calgary hair stylist against the women at a salon school who called him a “loser.” In another case that seemed stranger than fiction, an emotionally unstable transvestite fought for — and won — the right to counsel female rape victims, despite the anguished pleas of those same traumatized victims. Human rights commissions now monitor political opinions, fine people for expressing politically incorrect viewpoints, censor websites, and even ban people, permanently, from saying certain things. The book is a result of Levant’s ordeal and the research it inspired. It shows how our concept of human rights has morphed into something dangerous and drastically different from its original meaning. Shakedown is a convincing plea to Canadians to reclaim their basic liberties.

    Building on the work of Foucault, Giddens, Jameson and Lefebvre, one of America's geographers argues for a rethinking of the dialectics of space, time and social being.

    natural resource policies and collaborative ecosystem management, and the role of economics and market incentives in environmental policy. Incorporating analysis of the eight years under George W. Bush and a look ahead to the Barack Obama administration, all chapters include new scholarship, case studies, poll data, court rulings, congressional actions, agency decisions, and other events at the international, national, state, and local levels. With its clear, engaging writing, this tried and true reader makes great environmental research and scholarship accessible to an undergraduate audience.Environmental Policy includes new coverage of:national energy policyclimate changeimplementation of the Endangered Species Actexploration for oil and natural gas on public landsecosystem managementthe role of science in environmental policycourt decisions that challenge administrative rulemakingthe greening of industryurban sustainability initiativesthe environmental effects of national security decisionseconomic development and the environment

    By explaining the inner logic of parliamentary government, as well as the underlying rationale for its institutions and processes, the authors demystify what might appear to be a relatively complex political system. Urging readers to consider the organic nature of the political system--in which change in one area inevitably ripples through the rest of the system--the authors provide much more than just a description of the features of government.The fourth edition has been updated to include analysis of the 2008 Canadian federal election. Discussions of responsible government and the role of the Governor General have been revised and expanded. Coalition government, the Single Transferable Vote, and the emergence of the Green Party are explained and new developments in Senate reform and Supreme Court appointments are also covered.

    Lynch, supported by studies of Los Angeles, Boston, and Jersey City, formulates a new criterion -- imageability -- and shows its potential value as a guide for the building and rebuilding of cities. The wide scope of this study leads to an original and vital method for the evaluation of city form. The architect, the planner, and certainly the city dweller will all want to read this book.

    You'll discover the power of storytelling and the way to make data a pivotal point in your story. The lessons in this illuminative text are grounded in theory, but made accessible through numerous real-world examples--ready for immediate application to your next graph or presentation.Storytelling is not an inherent skill, especially when it comes to data visualization, and the tools at our disposal don't make it any easier. This book demonstrates how to go beyond conventional tools to reach the root of your data, and how to use your data to create an engaging, informative, compelling story. Specifically, you'll learn how to:Understand the importance of context and audience Determine the appropriate type of graph for your situation Recognize and eliminate the clutter clouding your information Direct your audience's attention to the most important parts of your data Think like a designer and utilize concepts of design in data visualization Leverage the power of storytelling to help your message resonate with your audience Together, the lessons in this book will help you turn your data into high impact visual stories that stick with your audience. Rid your world of ineffective graphs, one exploding 3D pie chart at a time. There is a story in your data--Storytelling with Data will give you the skills and power to tell it!