Inputs                  
Target Date   6/1/2002                            
Highlight and Calc Condition <10.5                            
      Query Detail June 1 to Decumber 31            
      (note target date +1 if data missing on target date)            
          St. Lucie Estuary  Caloosahatchee Estuary            
       Target Date Lake Level [N3466] S-80 From Lake From C-44 Basin Total at S-80 S-79 From Lake From C-43 Basin Total at S-79            
      6/1/2002 11.9 90,609 82,144 172,753 318,967 959,959 1,278,925            
      6/1/2003 14.95 379,550 170,999 550,549 1,014,833 1,003,591 2,018,424            
      6/1/2004 12.71 385,316 129,892 515,208 800,380 654,329 1,454,709            
      6/1/2005 14 698,023 314,849 1,012,872 1,693,989 1,359,145 3,053,134            
      6/1/2006 12.67 179 19,815 19,993 33,318 590,971 624,289            
      6/2/2007 9.01 0 0 0 159 66,339 66,498            
      6/1/2008 9.58 95,984 58,663 154,648 172,673 739,598 912,272            
      6/1/2009 11.29 8,805 46,927 55,732 11,679 661,358 673,037            
      6/2/2010 14.59 127,768 35,298 163,065 279,952 489,732 776,888            
      6/1/2011 10.05 0 119 119 12,230 459,924 472,154            
      6/1/2012 11.69 61,521 83,433 144,954 301,046 581,890 882,936            
      6/1/2013 13.33 338,260 309,940 648,200 926,033 1,284,263 2,210,296            
      6/2/2014 12.46 0 100,721 100,721 166,384 565,739 732,579            
      6/2/2015 12.56 0 73,644 73,644 109,824 539,476 651,086            
      6/1/2016 14.38 295,107 56,624 351,732 807,419 774,906 1,582,326            
      6/1/2017 10.94 592,240 69,670 652,274 1,090,823 1,311,367 2,402,190            
      6/1/2018 14.2 253,895 74,918 328,813 640,482 648,075 1,288,557            
      6/1/2019 10.81 0 29,149 29,149 78,308 615,623 693,931            
      6/1/2020 11.47 157,488 104,116 261,604 541,215 870,633 1,411,848            
      6/1/2021 12.8     ???,???.??                  
      Summary by Lake Level on June 1, 2002 - 2020              
      Average Lake Dicharges to Estuaries              
      June 1 - December 31              
      Lake Level # below St. Lucie Caloosahatchee # at or above St. Lucie Caloosahatchee              
      10.0 2           47,992.18             86,416.07 17         199,338.81          519,228.43              
      10.5 3           31,994.78             61,687.41 16         211,797.49          550,915.82              
      11.0 5         137,644.88          270,838.60 14         199,751.41          546,108.74              
      11.5 7         122,073.86          272,440.97 12         219,185.59          591,052.38              
      12.0 9         111,849.69          280,788.88 10         247,809.69          647,261.55              
      12.5 10         100,664.72          269,348.37 9         275,344.10          700,692.41              
      13.0 13         107,087.82          279,769.74 6         348,767.08          893,784.80              
      13.5 14         123,600.11          325,931.42 5         350,868.51          887,335.11              
      14.0 14         123,600.11          325,931.42 5         350,868.51          887,335.11              
      14.5 17         175,142.74          453,231.19 2         253,658.76          647,392.56              
      15.0 19         183,407.59          473,669.23 0  n/a   n/a               
      Summary by Lake Level on June 1, 2002 - 2020              
      Average Lake + Basin [C43/C44] Dicharges to Estuaries              
      June 1 - December 31              
      Lake Level # below St. Lucie Caloosahatchee # at or above St. Lucie Caloosahatchee              
      10.0 2           77,323.81          489,384.93 17         298,904.82      1,306,312.28              
      10.5 3           51,588.88          483,641.44 16         317,578.93      1,358,447.14              
      11.0 5         167,237.94          909,408.94 14         314,274.28      1,331,359.56              
      11.5 7         164,789.34          947,418.50 12         340,208.68      1,379,512.42              
      12.0 9         163,470.28          977,087.88 10         376,479.70      1,439,228.76              
      12.5 10         157,195.34          952,636.98 9         407,119.57      1,517,745.41              
      13.0 13         167,753.75          942,804.11 6         509,205.14      1,821,604.18              
      13.5 14         202,071.33       1,033,339.25 5         481,406.20      1,743,865.82              
      14.0 14         202,071.33       1,033,339.25 5         481,406.20      1,743,865.82              
      14.5 17         266,024.39       1,199,456.84 2         356,807.43      1,397,656.10              
      15.0 19         275,580.50       1,220,319.92 0  n/a   n/a