This spreadsheet contains the source data and formulas used in the decision analysis on Delta island levee upgrades and repairs presented in Chapter 2 and Appendix B of the report Comparing Futures for the Sacramento-San Joaquin Delta. Users can modify the data inputs on island land and asset values, repair and upgrade costs, and probabilities of island failure to see how the results would change for individual islands. The first page of the spreadsheet provides a tutorial and helps users get started. For details on how the analysis was conducted and a presentation of the results, see Appendix B: Levee Decisions and Sustainability for the Delta.
Analysis of the Economics of Delta Levee Repairs and Upgrades
Analysis of the Economics of Delta Levee Repairs and Upgrades
(175 KB, Excel)