148 Pages *Spiral Bound"
A surprising amount of vitally important union work like organizing, negotiating, lobbying, contract enforcement, safety and health, is increasingly data-driven and requires careful analysis and consideration of multiple scenarios and solutions. You may be missing valuable opportunities for your union to win by not seeking a spreadsheet solution. However, you may not be sure how to design and construct one. If so, this book is for you!
Whether you’ve never used a spreadsheet before, a power user or somewhere in between, this book will help you design and construct a number of spreadsheets to better organize complex information and find solutions to help your union win. It combines basic spreadsheet design and construction tools and templates with practical union examples.
Authored by John Lund, a professor emeritus from the University of Wisconsin School for Workers, who is a spreadsheet designer, consultant and someone who has been teaching spreadsheets all over the world for over forty years.
As a veteran labor educator, the author fully appreciates union representatives learn best by applying simple and then increasingly complex tools and skills to examples they are intimately familiar with, not generic examples. As you complete each detailed step outlined in the book, you’ll see screen shots of what the intermediate and final product should look like. After introducing basic spreadsheet design principles and tools in the first two chapters, the remaining eight chapters take a specific union application—building wage comparisons over time, indexing wages, costing out wage increases, tracking Davis-Bacon prevailing wage rates or OSHA citations, monitoring NLRB organizing campaigns and using publicly-available data from government web sites—and previews the tools and step-by-step instructions you’ll need to construct the finished product. Proceeding from the most basic to fairly complex spreadsheets, you’ll build confidence using the necessary spreadsheet commands and functions. You can also download the finished spreadsheet template from our website if you like.