Modeling and Simulation of Logistics Flows 2 Dashboards, Traffic Planning and Management

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.

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

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.