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 volumeOperational research with a spreadsheetDashboards with spreadsheets and pivot tablesScheduling and planning with a project managerThe 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
