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…mehr
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.Hinweis: Dieser Artikel kann nur an eine deutsche Lieferadresse ausgeliefert werden.
Jean-Michel Réveillac is a consultant-adviser and lecturer for large companies. He currently teaches at the University of Burgundy, and CNAM in France and at IGA in Morocco.
Inhaltsangabe
About This Book ix Introduction xv Chapter 1 Operational Research Using a Spreadsheet 1 1.1 Foreword 1 1.2 Dynamic programming 1 1.3 Scheduling 6 1.3.1 Critical path calculation matrix 7 1.3.2 Classic Gantt chart 11 1.3.3 Gantt chart with a calendar 17 1.4 Maximal flows 23 1.5 Transport model 29 1.5.1 Customer delivery 30 1.5.2 Minimum-cost transport 33 1.6 Linear programming 36 1.6.1 Creating a calculation table 36 1.6.2 Entering data 37 1.6.3 Using the solver 38 Chapter 2 Dashboards, Spreadsheets and Pivot Tables 41 2.1 Spreadsheets: a versatile tool 41 2.2 Example database 42 2.2.1 Calculated field and formatting 43 2.2.2 Calendar sections, rankings and averages 47 2.2.3 Conditional calculated fields 50 2.2.4 Slicers, filtering and calculated fields 53 2.2.5 Calculated items 58 2.3 Multiple databases 61 2.3.1 New tables for the database 62 2.3.2 Creating data tables 64 2.3.3 Relationships between tables 65 2.3.4 Using multiple tables to create a pivot table 67 2.4 Limits and constraints with calculated fields 69 2.5 Conclusion 72 Chapter 3 Scheduling and Planning Using a Project Manager 73 3.1 Reminders and information 73 3.2 Example: designing and building a machine-tool 74 3.2.1 Scenario 74 3.2.2 Creating and configuring the project 77 3.2.3 Entering tasks and durations 80 3.2.4 Entering predecessors 81 3.2.5 MPM network visualization 82 3.2.6 Calculating slacks 83 3.2.7 Entering resources 84 3.2.8 Allocating resources 86 3.2.9 Resolving over-allocations 88 3.2.10 Viewing the project timeline 92 3.2.11 Using WBS coding 92 3.2.12 Generating dashboards and reports 94 3.3 Project monitoring 97 3.4 Conclusion 99 Chapter 4 Road Traffic Simulation 101 4.1 Before we start 101 4.2 Ring road 102 4.2.1 A simulation example 103 4.3 RoadTrafficSimulator 104 4.3.1 Constructing a model 106 4.3.2 Activating the simulation from the model 108 4.4 Intersection simulator 109 4.5 Green Light District (GLD) 115 4.5.1 GLD compilation 116 4.5.2 Launching the GLD 117 4.5.3 The editor toolbar 119 4.5.4 An example using GLD 121 4.6 AnyLogic 144 4.6.1 Downloading AnyLogic 144 4.6.2 Our example 145 4.6.3 A last word on AnyLogic 165 4.7 Conclusion 165 Conclusion 167 Appendices 171 Appendix 1 173 Appendix 2 181 Glossary 187 Bibliography 193 Index 201
About This Book ix Introduction xv Chapter 1 Operational Research Using a Spreadsheet 1 1.1 Foreword 1 1.2 Dynamic programming 1 1.3 Scheduling 6 1.3.1 Critical path calculation matrix 7 1.3.2 Classic Gantt chart 11 1.3.3 Gantt chart with a calendar 17 1.4 Maximal flows 23 1.5 Transport model 29 1.5.1 Customer delivery 30 1.5.2 Minimum-cost transport 33 1.6 Linear programming 36 1.6.1 Creating a calculation table 36 1.6.2 Entering data 37 1.6.3 Using the solver 38 Chapter 2 Dashboards, Spreadsheets and Pivot Tables 41 2.1 Spreadsheets: a versatile tool 41 2.2 Example database 42 2.2.1 Calculated field and formatting 43 2.2.2 Calendar sections, rankings and averages 47 2.2.3 Conditional calculated fields 50 2.2.4 Slicers, filtering and calculated fields 53 2.2.5 Calculated items 58 2.3 Multiple databases 61 2.3.1 New tables for the database 62 2.3.2 Creating data tables 64 2.3.3 Relationships between tables 65 2.3.4 Using multiple tables to create a pivot table 67 2.4 Limits and constraints with calculated fields 69 2.5 Conclusion 72 Chapter 3 Scheduling and Planning Using a Project Manager 73 3.1 Reminders and information 73 3.2 Example: designing and building a machine-tool 74 3.2.1 Scenario 74 3.2.2 Creating and configuring the project 77 3.2.3 Entering tasks and durations 80 3.2.4 Entering predecessors 81 3.2.5 MPM network visualization 82 3.2.6 Calculating slacks 83 3.2.7 Entering resources 84 3.2.8 Allocating resources 86 3.2.9 Resolving over-allocations 88 3.2.10 Viewing the project timeline 92 3.2.11 Using WBS coding 92 3.2.12 Generating dashboards and reports 94 3.3 Project monitoring 97 3.4 Conclusion 99 Chapter 4 Road Traffic Simulation 101 4.1 Before we start 101 4.2 Ring road 102 4.2.1 A simulation example 103 4.3 RoadTrafficSimulator 104 4.3.1 Constructing a model 106 4.3.2 Activating the simulation from the model 108 4.4 Intersection simulator 109 4.5 Green Light District (GLD) 115 4.5.1 GLD compilation 116 4.5.2 Launching the GLD 117 4.5.3 The editor toolbar 119 4.5.4 An example using GLD 121 4.6 AnyLogic 144 4.6.1 Downloading AnyLogic 144 4.6.2 Our example 145 4.6.3 A last word on AnyLogic 165 4.7 Conclusion 165 Conclusion 167 Appendices 171 Appendix 1 173 Appendix 2 181 Glossary 187 Bibliography 193 Index 201
Es gelten unsere Allgemeinen Geschäftsbedingungen: www.buecher.de/agb
Impressum
www.buecher.de ist ein Internetauftritt der buecher.de internetstores GmbH
Geschäftsführung: Monica Sawhney | Roland Kölbl | Günter Hilger
Sitz der Gesellschaft: Batheyer Straße 115 - 117, 58099 Hagen
Postanschrift: Bürgermeister-Wegele-Str. 12, 86167 Augsburg
Amtsgericht Hagen HRB 13257
Steuernummer: 321/5800/1497
USt-IdNr: DE450055826
