Effluent Loads (Kg/d) [mg/l X MGD X 3.78 = Kg/d],,,,,,,,,,,,,,,, Novato Sanitary District,,,,,,,,,,,,,,,, "Sandeep Karkal, Manager-Engineer, (415) 892-1694, sandeepk@novatosan.com",,,,,,,,,,,,,,,, Quarter of Year,Date,Peak Flow Event (Y/N),Flow (MGD),,TN (kg/d),TDN (kg/d),TKN (kg/d),SKN (kg/d),NO3 (kg/d),NO2 (kg/d),Total NH3 (kg/d),Urea (kg/d),TP (kg/d),TDP (kg/d),DRP (kg/d),TSS (kg/d) ,(mm/dd/yyyy),,Ave Daily,Peak,,,,,,,,,,,Use Max Flow if sample type is Grab, Q3 2012,7/10/2012,N,4.23,8.15,225.130752,220.333932,28.78092,23.9841,191.8728,4.477032,8.474382, ,3.99735,2.558304,0.862596,39.9735 Q4 2012,11/8/2012,N,4.55,7.74,249.55749,249.55749,24.0786,24.0786,223.587,1.89189,5.50368, ,2.57985,1.633905,0.7899444,8.5995 Q4 2012,11/14/2012,N,4.23,13.25,214.8335784,208.4378184,22.38516,15.9894,191.8728,0.5756184,1.758834, ,2.718198,1.5509718,1.0017,35.17668 Q4 2012,12/13/2012,N,5.07,13.11,203.1830892,203.1830892,24.91398,24.91398,178.23078,0.0383292,2.299752, ,14.181804,13.031928,42.12243,21.08106 Q4 2012,12/19/2012,N,5.34,8.11,206.1110772,202.0740372,26.24076,22.20372,179.64828,0.2220372,2.01852, ,12.918528,11.707416,27.896778,22.20372 Q1 2013,1/11/2013,N,5.68,8.97,247.3175376,236.1529296,32.2056,21.040992,214.704,0.4079376,2.14704, ,34.35264,32.2056,54.25056,66.55824 Q1 2013,1/22/2013,N,5,8.6,209.979,209.979,24.57,24.57,181.44,3.969,2.457, ,13.041,11.718,16.57908,54.81 Q1 2013,2/13/2013,N,4.86,11.25,263.437272,252.414792,33.06744,22.04496,220.4496,9.920232,2.939328, ,22.04496,20.20788,25.94025,91.854 Q1 2013,2/22/2013,N,4.72,8.14,327.214944,316.509984,96.34464,85.63968,214.0992,16.771104,51.74064, ,49.95648,44.604,89.23068,235.50912 Q1 2013,3/6/2013,N,5.86,9.61,394.062732,354.191292,128.47464,88.6032,243.6588,21.929292,78.63534, ,57.59208,57.59208,90.8145,354.4128 Q1 2013,3/20/2013,N,4.91,7.64,259.280406,262.064376,14.291046,17.075016,241.2774,3.71196,3.340764, ,44.54352,42.68754,80.86176,48.25548 Q2 2013,4/3/2013,N,5.27,7.35,259.3064502,230.2223742,39.8412,10.757124,219.1266,0.3386502,2.191266, ,43.82532,37.84914,61.1226,87.65064 Q2 2013,4/23/2013,N,4.01,6.99,265.7010762,270.2484162,22.7367,27.28404,242.5248,0.4395762,1.51578, ,37.8945,37.8945,66.0555,81.85212 Q2 2013,5/10/2013,N,4.01,7.86,245.7988848,235.1884248,33.34716,22.7367,212.2092,0.2425248,1.51578, ,8.185212,7.275744,18.123588,60.6312 Q2 2013,5/16/2013,N,4.05,7.14,217.510272,206.793972,33.6798,22.9635,183.708,0.122472,1.5309, ,2.44944,1.68399,0.7556976,64.2978 Q3 2013,7/18/2013,N,3.53,5.5,194.14647,178.13439,29.35548,13.3434,160.1208,4.67019,17.212986, ,1.734642,1.000755,0.24948,18.68076 Q4 2013,10/17/2013,N,4.43,9.91,237.617226,228.072348,18.41994,8.875062,217.6902,1.507086,2.344356, ,10.214694,9.20997,10.114146,38.51442 Q42013,10/25/2013,N,4.22,7.34,222.52482,209.76354,28.71288,15.9516,191.4192,2.39274,8.135316, ,22.33224,22.33224,33.29424,62.21124 Q42013,11/15/2013,N,4.13,6.69,224.5231548,206.2578168,20.29482,2.029482,202.9482,1.2801348,2.810052, ,3.746736,1.4518602,1.5425802,49.95648 Q42013,11/22/2013,N,4,7.67,180.13968,172.12608,13.3056,5.292,166.32,0.51408,1.512, ,3.024,1.9656,0.8407854,65.016 Q4 2013,12/6/20013,N,4.27,9.05,242.593218,234.0387,24.2109,15.656382,209.8278,8.554518,13.880916, ,3.550932,2.098278,0.786807,51.64992 Q4 2013,12/16/2013,N,4.01,7.34,237.825882,233.278542,78.82056,74.27322,145.51488,13.490442,58.963842, ,4.092606,2.728404,0.69363,57.59964 Q1 2014,1/10/2014,N,4.21,6.4,223.827597,209.505177,63.6552,49.33278,159.138,1.034397,27.05346, ,7.002072,5.56983,0.653184,47.7414 Q1 2014,1/24/2014,N,4.39,7.5,233.97822,243.93474,56.42028,66.3768,121.13766,56.42028,58.0797, ,9.458694,8.2971,1.10565,49.7826 Q1 2014,2/12/2014,N,4.57,7,172.746,183.11076,25.9119,36.27666,143.37918,3.45492,17.792838, ,5.18238,3.45492,0.68796,51.8238 Q1 2014,3/8/2014,N,5.05,7.8,190.31733,197.38026,1.33623,8.39916,188.675676,0.305424,1.9089, ,4.19958,3.62691,1.208844,57.267 Q1 2014,3/19/2014,N,4.35,6,288.229347,286.091757,7.23492,5.09733,279.531,1.463427,3.12417, ,67.4163,69.0606,115.668,49.329 Q2 2014,1/0/1900,0,0,0, , , , , , , , , , , , 0,1/0/1900,0,0,0, , , , , , , , , , , , 0,1/0/1900,0,0,0, , , , , , , , , , , , 0,1/0/1900,0,0,0, , , , , , , , , , , , 0,1/0/1900,0,0,0, , , , , , , , , , , , 0,1/0/1900,0,0,0, , , , , , , , , , , , 0,1/0/1900,0,0,0, , , , , , , , , , , , 0,1/0/1900,0,0,0, , , , , , , , , , , , 0,1/0/1900,0,0,0, , , , , , , , , , , , 0,1/0/1900,0,0,0, , , , , , , , , , , , 0,1/0/1900,0,0,0, , , , , , , , , , , , 0,1/0/1900,0,0,0, , , , , , , , , , , , 0,1/0/1900,0,0,0, , , , , , , , , , , , 0,1/0/1900,0,0,0, , , , , , , , , , , , 0,1/0/1900,0,0,0, , , , , , , , , , , , 0,1/0/1900,0,0,0, , , , , , , , , , , , 0,1/0/1900,0,0,0, , , , , , , , , , , , 0,1/0/1900,0,0,0, , , , , , , , , , , , 0,1/0/1900,0,0,0, , , , , , , , , , , , 0,1/0/1900,0,0,0, , , , , , , , , , , , 0,1/0/1900,0,0,0, , , , , , , , , , , , 0,1/0/1900,0,0,0, , , , , , , , , , , , 0,1/0/1900,0,0,0, , , , , , , , , , , , 0,1/0/1900,0,0,0, , , , , , , , , , , , 0,1/0/1900,0,0,0, , , , , , , , , , , , 0,1/0/1900,0,0,0, , , , , , , , , , , , 0,1/0/1900,0,0,0, , , , , , , , , , , , 0,1/0/1900,0,0,0, , , , , , , , , , , , 0,1/0/1900,0,0,0, , , , , , , , , , , , 0,1/0/1900,0,0,0, , , , , , , , , , , , 0,1/0/1900,0,0,0, , , , , , , , , , , , 0,1/0/1900,0,0,0, , , , , , , , , , , , 0,1/0/1900,0,0,0, , , , , , , , , , , , THINGS TO DO,,,,,,,,,,,,,,,, "Correct bright yellow highlighted load calulations (0, #VALUE!"") by correcting the ""Conc"" worksheet",,,,,,,,,,,,,,,, "Use correct flow for load calculation: for grab sample, use peak flow; for composit sample, use average flow.",,,,,,,,,,,,,,,, Cells are conditionally formatted as explained below:,,,,,,,,,,,,,,,, 1. Cells are shaded purple if there is no load calculated for that parameter due to lack of concentration data. No need to do anything if that sampling is not required.,,,,,,,,,,,,,,,, "2. Cells are shaded bright yellow if the load is calculated as ""0"" due to concentration reported as ""0"", go to 'Conc"" worksheet to correct the concentration reported.",,,,,,,,,,,,,,,, "3. Cells are shaded bright yellow if concentration is reporetd as a text (such as ND,