Crystal Ball Simulation: allo_dem.xls.xls 31 Hog Appl Jan,allo_dem.xls.xls,OPT-Decisions,C7,0, .02,1,Discrete (0.01) Hog Appl Feb,allo_dem.xls.xls,OPT-Decisions,C8,0, .02,1,Discrete (0.01) Hog Appl Mar,allo_dem.xls.xls,OPT-Decisions,C9,0, .02,1,Discrete (0.01) Hog Appl Apr,allo_dem.xls.xls,OPT-Decisions,C10,0, .02,1,Discrete (0.01) Hog Appl May,allo_dem.xls.xls,OPT-Decisions,C11,0, .02,1,Discrete (0.01) Hog Appl June,allo_dem.xls.xls,OPT-Decisions,C12,0, .02,1,Discrete (0.01) Hog Appl July,allo_dem.xls.xls,OPT-Decisions,C13,0, .27,1,Discrete (0.01) Hog Appl Aug,allo_dem.xls.xls,OPT-Decisions,C14,0, .27,1,Discrete (0.01) Hog Appl Septem,allo_dem.xls.xls,OPT-Decisions,C15,0, .28,1,Discrete (0.01) Hog Appl Oct,allo_dem.xls.xls,OPT-Decisions,C16,0, .02,1,Discrete (0.01) Hog Appl Nov,allo_dem.xls.xls,OPT-Decisions,C17,0, .02,1,Discrete (0.01) Hog Appl Dec,allo_dem.xls.xls,OPT-Decisions,C18,0, .02,1,Discrete (0.01) Cow Appl Jan,allo_dem.xls.xls,OPT-Decisions,C19,0, 0,1,Discrete (0.01) Cow Appl Feb,allo_dem.xls.xls,OPT-Decisions,C20,0, 0,1,Discrete (0.01) Cow Appl March,allo_dem.xls.xls,OPT-Decisions,C21,0, 0,1,Discrete (0.01) Cow Appl April,allo_dem.xls.xls,OPT-Decisions,C22,0, .22,1,Discrete (0.01) Cow Appl May,allo_dem.xls.xls,OPT-Decisions,C23,0, .22,1,Discrete (0.01) Cow Appl June,allo_dem.xls.xls,OPT-Decisions,C24,0, .23,1,Discrete (0.01) Cow Appl July,allo_dem.xls.xls,OPT-Decisions,C25,0, .08,1,Discrete (0.01) Cow Appl Aug,allo_dem.xls.xls,OPT-Decisions,C26,0, .08,1,Discrete (0.01) Cow Appl Septem,allo_dem.xls.xls,OPT-Decisions,C27,0, .08,1,Discrete (0.01) Cow Appl Oct,allo_dem.xls.xls,OPT-Decisions,C28,0, .09,1,Discrete (0.01) Cow Appl Nov,allo_dem.xls.xls,OPT-Decisions,C29,0, 0,1,Discrete (0.01) Cow Appl Dec,allo_dem.xls.xls,OPT-Decisions,C30,0, 0,1,Discrete (0.01) Cow Incorp,allo_dem.xls.xls,OPT-Decisions,C31,.75, .75,1,Discrete (0.01) Hogs Incorp,allo_dem.xls.xls,OPT-Decisions,C32,.75, .75,1,Discrete (0.01) Compost Hog&dairy,allo_dem.xls.xls,OPT-Decisions,C33,0, 0,1,Discrete (0.01) Instream excl,allo_dem.xls.xls,OPT-Decisions,C35,0, 0,1,Discrete (0.01) Septic failures,allo_dem.xls.xls,OPT-Decisions,C38,0, 10,10,Discrete (1) WWTP limit,allo_dem.xls.xls,OPT-Decisions,C39,10, 200,200,Discrete (10) Compost Beef,allo_dem.xls.xls,OPT-Decisions,C36,0, 0,.05,Discrete (0.01) 10 1,1,1,1,1,1,1,1,1,1,1,1,,,,,,,,,,,,,,,,,,,,=,1 ,,,,,,,,,,,,1,1,1,1,1,1,1,1,1,1,1,1,,,,,,,,=,1 ,,,,,,,,,,,,,,,,,,,,,,,,1,,,,,,,>,.75 ,,,,,,,,,,,,,,,,,,,,,,,,1,,,,,,,<,1 ,,,,,,,,,,,,,,,,,,,,,,,,,1,,,,,,>,.75 ,,,,,,,,,,,,,,,,,,,,,,,,,1,,,,,,<,1 ,,,,,,,,,,,,,,,,,,,,,,,,,,1,,,,,>,0 ,,,,,,,,,,,,,,,,,,,,,,,,,,1,,,,,<,1 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,1,<,.05 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,1,>,0 Minimize 37 Annual Cost,$,allo_dem.xls.xls,OPT-Results,C9,Mean,,,0,0 Jan Conc:1,,allo_dem.xls.xls,OPT-Results,C24,Mean,,200,0,0 Jan Conc:1,,allo_dem.xls.xls,OPT-Results,C24,Percentile (90),,400,0,0 Jan Conc:2,,allo_dem.xls.xls,OPT-Results,C24,Percentile (100),,2000,0,0 Feb Conc:1,,allo_dem.xls.xls,OPT-Results,C25,Mean,,200,0,0 Feb Conc:1,,allo_dem.xls.xls,OPT-Results,C25,Percentile (90),,400,0,0 Feb Conc:2,,allo_dem.xls.xls,OPT-Results,C25,Percentile (100),,2000,0,0 March Conc:1,,allo_dem.xls.xls,OPT-Results,C26,Mean,,200,0,0 March Conc:1,,allo_dem.xls.xls,OPT-Results,C26,Percentile (90),,400,0,0 March Conc:2,,allo_dem.xls.xls,OPT-Results,C26,Percentile (100),,2000,0,0 Apr Conc:1,,allo_dem.xls.xls,OPT-Results,C27,Mean,,200,0,0 Apr Conc:1,,allo_dem.xls.xls,OPT-Results,C27,Percentile (90),,400,0,0 Apr Conc:2,,allo_dem.xls.xls,OPT-Results,C27,Percentile (100),,2000,0,0 May Conc:1,,allo_dem.xls.xls,OPT-Results,C28,Mean,,200,0,0 May Conc:1,,allo_dem.xls.xls,OPT-Results,C28,Percentile (90),,400,0,0 May Conc:2,,allo_dem.xls.xls,OPT-Results,C28,Percentile (100),,2000,0,0 June Conc:1,,allo_dem.xls.xls,OPT-Results,C29,Mean,,200,0,0 June Conc:1,,allo_dem.xls.xls,OPT-Results,C29,Percentile (90),,400,0,0 June Conc:2,,allo_dem.xls.xls,OPT-Results,C29,Percentile (100),,2000,0,0 July Conc:1,,allo_dem.xls.xls,OPT-Results,C30,Mean,,200,0,0 July Conc:1,,allo_dem.xls.xls,OPT-Results,C30,Percentile (90),,400,0,0 July Conc:2,,allo_dem.xls.xls,OPT-Results,C30,Percentile (100),,2000,0,0 Aug Conc:1,,allo_dem.xls.xls,OPT-Results,C31,Mean,,200,0,0 Aug Conc:1,,allo_dem.xls.xls,OPT-Results,C31,Percentile (90),,400,0,0 Aug Conc:2,,allo_dem.xls.xls,OPT-Results,C31,Percentile (100),,2000,0,0 Sept Conc:1,,allo_dem.xls.xls,OPT-Results,C32,Mean,,200,0,0 Sept Conc:1,,allo_dem.xls.xls,OPT-Results,C32,Percentile (90),,400,0,0 Sept Conc:2,,allo_dem.xls.xls,OPT-Results,C32,Percentile (100),,2000,0,0 Oct Conc:1,,allo_dem.xls.xls,OPT-Results,C33,Mean,,200,0,0 Oct Conc:1,,allo_dem.xls.xls,OPT-Results,C33,Percentile (90),,400,0,0 Oct Conc:2,,allo_dem.xls.xls,OPT-Results,C33,Percentile (100),,2000,0,0 Nov Conc:1,,allo_dem.xls.xls,OPT-Results,C34,Mean,,200,0,0 Nov Conc:1,,allo_dem.xls.xls,OPT-Results,C34,Percentile (90),,400,0,0 Nov Conc:2,,allo_dem.xls.xls,OPT-Results,C34,Percentile (100),,2000,0,0 Dec Conc:1,,allo_dem.xls.xls,OPT-Results,C35,Mean,,200,0,0 Dec Conc:1,,allo_dem.xls.xls,OPT-Results,C35,Percentile (90),,400,0,0 Dec Conc:2,,allo_dem.xls.xls,OPT-Results,C35,Percentile (100),,2000,0,0 "**********" #TRUE# #TRUE# 10 600 #FALSE# 1 #TRUE# 20 #TRUE# #FALSE# .001 1000000 #TRUE#