Jean-Michel Réveillac 
Modeling and Simulation of Logistics Flows 2 [PDF ebook] 
Dashboards, Traffic Planning and Management

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 Road Traffic Simulator 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 Any Logic 144
4.6.1 Downloading Any Logic 144
4.6.2 Our example 145
4.6.3 A last word on Any Logic 165
4.7 Conclusion 165
Conclusion 167
Appendices 171
Appendix 1 173
Appendix 2 181
Glossary 187
Bibliography 193
Index 201

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.