Influent 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",,,,,,,,,,, Season ,Date,Flow (MGD),,TN (kg/d),TKN (kg/d),NO3 (kg/d),NO2 (kg/d),Total NH3 (kg/d),TP (kg/d),DRP (kg/d),TSS (kg/d) ,(mm/dd/yyyy),Ave Daily,Peak,,,,,,,Use Max Flow if sample type is grab, Dry,7/10/2012,4.23,8.15,725.279184,719.523,5.756184, ,575.6184,91.13958,163.2771,6187.8978 Wet,2/22/2013,4.72,8.14,888.51168,874.2384,14.27328, ,847.476,112.40208,215.3844,5298.9552 Dry,7/18/2013,3.53,5.5,725.347224,720.5436,4.803624, ,426.9888,96.07248,114.345,5617.5714 Wet,3/7/2014,5.42,7.9,855.767052,839.9916,15.775452, ,409.752,98.34048,131.3928,5080.9248 0,1/0/1900,0,0, , , , , , , , 0,1/0/1900,0,0, , , , , , , , 0,1/0/1900,0,0, , , , , , , , 0,1/0/1900,0,0, , , , , , , , 0,1/0/1900,0,0, , , , , , , , 0,1/0/1900,0,0, , , , , , , , 0,1/0/1900,0,0, , , , , , , , 0,1/0/1900,0,0, , , , , , , , 0,1/0/1900,0,0, , , , , , , , 0,1/0/1900,0,0, , , , , , , , 0,1/0/1900,0,0, , , , , , , , 0,1/0/1900,0,0, , , , , , , , 0,1/0/1900,0,0, , , , , , , , 0,1/0/1900,0,0, , , , , , , , 0,1/0/1900,0,0, , , , , , , , 0,1/0/1900,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,