{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Menu_Info","Collected_Info","Additive Info"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Menu_Info","index":0,"n_rows":14,"n_cols":13,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["Discharge_Type",null,"Dosing Units","Cont/Inter",null,"Daphnidae","Freshwater_Fish","Category","#_Categories","Safety_Factor",null,null,"mg/L_PPM"]
["Municipal",null,"gal/day","Continuous",null,"Daphnia spp.","Fathead Minnow (Pimephales promelas)","Trout",2,13,null,null,"This Concentration is the Final Effluent Concentration"]
["Industrial",null,"lbs/day","Intermittent",null,"Daphnia Pulex","Bluegill (Lepomis macrochirus)","benthic crustation (e.g. crayfish)",3,8]
[null,null,null,null,null,"Daphnia magna","Zebra Fish (Danio rerio)","cladoceran (e.g. Daphnid)*",4,7]
[null,null,null,null,null,"Ceriodaphnia spp.","Rainbow Trout (Oncorynchus mykiss)","freshwater fish*",5,6.1]
[null,null,null,null,null,"Ceriodaphnia dubia","Mosquito Fish (Gambusia affinis)","freshwater fish/ amphibian",6,5.2]
[null,null,null,null,null,"Simocephalus spp.","Channel Catfish (Ictalurus punctatus)","aquatic insect",7,4.3]
[null,null,null,null,null,null,"Atlantic Salmon (Salmo salar)","phylum other that insect or fish/amphibian"]
[null,null,null,null,null,null,"Smallmouth Bass (Micropterus dolomieui)","second insect or phylum not represented"]
[null,null,null,null,null,null,"Brooktrout (Salvelinus fontinalis)"]
[null,null,null,null,null,null,"Chinook Salmon (Oncorhynchus tshawytscha)"]
[null,null,null,null,null,null,"Rio Grande minnow (Hybognathus amarus)"]
[null,null,null,null,null,null,"Green Sunfish (Lepomis cyanellus)"]
[null,null,null,null,null,null,"orfe (Leuciscus idus)"]

{"sheet":"Collected_Info","index":1,"n_rows":2,"n_cols":50,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Permit Name","Permit Number","Facility Type","Discharge Station","Contact First Name","Contact Last name","Contact Email","Contact Phone Number","Date ","Time Stamp","Notes-General_Info","Flow_MGD","Continuous or Intermittent Discharge","Dosing_Units","Blank1","Dose Per Day","Density or Specific Gravity","Overall Additive Removal Rate","Cooling Tower Discharge","Blank2","Blank3","Final Effluent Conc","Permitte Calculated","Notes_Effluent_Concentration","Additive Brand Name","Discharge_Type","Stream_7Q10_CFS","WWTP_Flow_MGD","Dilution_Ratio","Dosing_Free_Text","Number of Species","Cladoceran Species","Cladoceran EC50 or LC50","Freshwater Fish Species","Freshwater Fish EC50 or LC50","Min Value","FAV ","Chronic_Diluted ","ACR","Species 3 Name","Species 4 Name","Species 5 Name","Species 6 Name","Species 7 Name","Species 3 LCEC50","Species 4 LCEC50","Species 5 LCEC50","Species 6 LCEC50","Species 7 LCEC50","Notes_Aquatic_Tox"]
[123,123,"Municipal",123,123,123,123,123,"2014-08-01","2014-08-21T15:10:38","sdfg",1,"Continuous","gal/day",null,1,1,0,false,null,null,1,false,null,"asdf","Continuous",0.01,5,1.2928248222365899E-3,null,2,"Ceriodaphnia dubia",10,"Brooktrout (Salvelinus fontinalis)",10000,{"$f":"MIN(AG2,AI2,AS2:AW2)","v":10},0.76923076923076905,0.42790291659069946,18]

{"sheet":"Additive Info","index":2,"n_rows":44,"n_cols":8,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Button A Summary",null,null,"Button B Summary",null,null,"Button C Summary"]
["Permit Name",{"$f":"IF(Collected_Info!A2=0,\"\",Collected_Info!A2)","v":123},null,"Flow  (MGD)",{"$f":"IF(Collected_Info!L2=\"\",\"\",Collected_Info!L2)","v":1},null,"Additive Brand Name",{"$f":"IF(Collected_Info!Y2=\"\",\"\",Collected_Info!Y2)","v":"asdf"}]
["Permit Number",{"$f":"IF(Collected_Info!B2=0,\"\",Collected_Info!B2)","v":123},null,"Discharge Type",{"$f":"IF(Collected_Info!M2=\"\",\"\",Collected_Info!M2)","v":"Continuous"},null,"Dosage Type",{"$f":"IF(Collected_Info!Z2=0,\"\",Collected_Info!Z2)","v":"Continuous"}]
["Facility Type",{"$f":"IF(Collected_Info!C2=0,\"\",Collected_Info!C2)","v":"Municipal"},null,"Dosing Units",{"$f":"IF(Collected_Info!N2=0,\"\",Collected_Info!N2)","v":"gal/day"},null,"Stream Dilution Ratio",{"$f":"IF(Collected_Info!AC2=0,\"\",Collected_Info!AC2)","v":1.2928248222365899E-3}]
["Discharge Station",{"$f":"IF(Collected_Info!D2=0,\"\",Collected_Info!D2)","v":"1900-05-02"},null,"Dose Per Day",{"$f":"IF(Collected_Info!P2=0,\"\",Collected_Info!P2)","v":1},null,"Number of Reference Species",{"$f":"IF(Collected_Info!AE2=0,\"\",Collected_Info!AE2)","v":2}]
["Contact First Name",{"$f":"IF(Collected_Info!E2=0,\"\",Collected_Info!E2)","v":123},null,"Specific Gravity",{"$f":"IF(Collected_Info!Q2=0,\"\",Collected_Info!Q2)","v":1},null,"Minimum LC/EC50 of Reference Species",{"$f":"IF(Collected_Info!AJ2=0,\"\",Collected_Info!AJ2)","v":10}]
["Contact Last name",{"$f":"IF(Collected_Info!F2=0,\"\",Collected_Info!F2)","v":123},null,"Overall Removal Rate (%)",{"$f":"IF(Collected_Info!R2=0,0,Collected_Info!R2)","v":0},null,"Final Acute Value (mg/L)",{"$f":"IF(Collected_Info!AK2=0,\"\",Collected_Info!AK2)","v":0.76923076923076905}]
["Contact Email",{"$f":"IF(Collected_Info!G2=0,\"\",Collected_Info!G2)","v":123},null,"Projected Effluent Concentration (mg/L)",{"$f":"IF(Collected_Info!V2=\"\",\"\",Collected_Info!V2)","v":1},null,"Chronic Standard  (mg/L ; Dilution Adjusted)",{"$f":"IF(Collected_Info!AL2=0,\"\",Collected_Info!AL2)","v":0.42790291659069946}]
["Contact Phone Number",{"$f":"IF(Collected_Info!H2=0,\"\",Collected_Info!H2)","v":123},null,null,null,null,"Chronic Standard Applicable (Yes/No)","No"]
["Date of Submittal",{"$f":"IF(Collected_Info!I2=0,\"\",Collected_Info!I2)","v":"2014-08-01"},null,null,null,null,"Potentially Approvable at Current Dose (Yes/No)",{"$f":"IF(H42=\"Yes\",IF(E41<H41,\"Yes\",\"No\"),IF(E41<H40,\"Yes\",\"No\"))","v":"No"}]
["Notes",{"$f":"IF(Collected_Info!K2=0,\"\",Collected_Info!K2)","v":"sdfg"}]