Volume 2 begins with an introduction and 4 chapters implementing software tools on cases of practical applications and it ends with a conclusion: The various tools used in this volume Operational research with a spreadsheet Dashboards with spreadsheets and pivot tables Scheduling and planning with a project manager The traffic simulation The conclusion shows the new features that are expected to emerge on spreadsheets as well as project managers, developments and convergences between traffic simulators and new infrastructure that are emerging on road networks. Annex 1 focuses on the installation Solver in Microsoft Excel and Annex 2 focuses on the installation of the Java Development Kit.

Volume 2 begins with an introduction and 4 chapters implementing software tools on cases of practical applications and it ends with a conclusion:* The various tools used in this volume* Operational research with a spreadsheet* Dashboards with spreadsheets and pivot tables* Scheduling and planning with a project manager* The traffic simulationThe conclusion shows the new features that are expected to emerge on spreadsheets as well as project managers, developments and convergences between traffic simulators and new infrastructure that are emerging on road networks. Annex 1 focuses on the installation Solver in Microsoft Excel and Annex 2 focuses on the installation of the Java Development Kit.

About This Book ixIntroduction xvChapter 1 Operational Research Using a Spreadsheet 11.1 Foreword 11.2 Dynamic programming 11.3 Scheduling 61.3.1 Critical path calculation matrix 71.3.2 Classic Gantt chart 111.3.3 Gantt chart with a calendar 171.4 Maximal flows 231.5 Transport model 291.5.1 Customer delivery 301.5.2 Minimum-cost transport 331.6 Linear programming 361.6.1 Creating a calculation table 361.6.2 Entering data 371.6.3 Using the solver 38Chapter 2 Dashboards, Spreadsheets and Pivot Tables 412.1 Spreadsheets: a versatile tool 412.2 Example database 422.2.1 Calculated field and formatting 432.2.2 Calendar sections, rankings and averages 472.2.3 Conditional calculated fields 502.2.4 Slicers, filtering and calculated fields 532.2.5 Calculated items 582.3 Multiple databases 612.3.1 New tables for the database 622.3.2 Creating data tables 642.3.3 Relationships between tables 652.3.4 Using multiple tables to create a pivot table 672.4 Limits and constraints with calculated fields 692.5 Conclusion 72Chapter 3 Scheduling and Planning Using a Project Manager 733.1 Reminders and information 733.2 Example: designing and building a machine-tool 743.2.1 Scenario 743.2.2 Creating and configuring the project 773.2.3 Entering tasks and durations 803.2.4 Entering predecessors 813.2.5 MPM network visualization 823.2.6 Calculating slacks 833.2.7 Entering resources 843.2.8 Allocating resources 863.2.9 Resolving over-allocations 883.2.10 Viewing the project timeline 923.2.11 Using WBS coding 923.2.12 Generating dashboards and reports 943.3 Project monitoring 973.4 Conclusion 99Chapter 4 Road Traffic Simulation 1014.1 Before we start 1014.2 Ring road 1024.2.1 A simulation example 1034.3 RoadTrafficSimulator 1044.3.1 Constructing a model 1064.3.2 Activating the simulation from the model 1084.4 Intersection simulator 1094.5 Green Light District (GLD) 1154.5.1 GLD compilation 1164.5.2 Launching the GLD 1174.5.3 The editor toolbar 1194.5.4 An example using GLD 1214.6 AnyLogic 1444.6.1 Downloading AnyLogic 1444.6.2 Our example 1454.6.3 A last word on AnyLogic 1654.7 Conclusion 165Conclusion 167Appendices 171Appendix 1 173Appendix 2 181Glossary 187Bibliography 193Index 201