PPIC Logo Independent, objective, nonpartisan research
Data Set

Decision Analysis on Delta Export Alternatives

This spreadsheet provides the data and formulas to compare the four water export alternatives analyzed in the report Comparing Futures for the Sacramento-San Joaquin Delta. These alternatives include (1) continue pumping exports through the Delta, (2) divert water upstream and convey it around the Delta through a peripheral canal, (3) combine the current through-Delta pumping strategy with a peripheral canal (so-called “dual conveyance” or “dual facility”), and (4) end exports altogether. The decision analysis considers two performance criteria: viability of native fish populations (delta smelt and fall-run Chinook salmon), and statewide economic costs for water supply and quality. As described in greater detail in Appendix J (Decision Analysis of Delta Strategies), the answers to 16 questions are used to develop these performance criteria. The report authors’ values for answers to these questions also are explained in Appendix J. The spreadsheet allows users to modify the answers to these questions to see how the results would change.

Note: Some browsers are programmed to automatically attempt to open certain types of files within the browser window. If you would like to bypass this attempt and make sure that the file is downloaded directly to your disk, right click on the file link and choose "Save Target As...".


Freshwater Ecosystems Water Supply Water, Land & Air