{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["toxicity calculator","Compound Data","Probit Analysis"],"not_rendered":{"charts":4,"defined_names":27},"read":"whole","date_system":"1904"}

{"sheet":"toxicity calculator","index":0,"n_rows":31,"n_cols":12,"rows_kept":31,"merged":[[27,1,27,6],[28,1,28,6],[29,1,29,6]]}
["Bee Mortality Calculator",{"$nulls":7},"Conversion Calculator"]
["Use: enter LD50, slope, field app. rate, others are calculated"]
["data can be modified in yellow cells only, the other values are calculated",{"$nulls":8},"acres / Ha","lbs / kg"]
["Compound","LD50, µg/bee","slope probits/log u","field rate lbs AI per acre","rate factor","probits from LD50","predicted percent mortality",null,"note: kg/Ha about same as lb/acre",2.4710437,2.2046226]
["Baythroid",0.025,2.92,null,{"$f":"IF(OR(FieldRate=\"\",slope=\"\"),\"\",FieldRate/_LD50)","v":""},{"$f":"IF(factor=\"\",\"\",slope*LOG(factor))","v":""},{"$f":"IF(F5=\"\",\"\",NORMSDIST(slope*LOG(factor)))","v":""},null,"entered",null,"calculated"]
["Lannate",1.29,2.39,null,{"$f":"IF(OR(FieldRate=\"\",slope=\"\"),\"\",FieldRate/_LD50)","v":""},{"$f":"IF(factor=\"\",\"\",slope*LOG(factor))","v":""},{"$f":"IF(F6=\"\",\"\",NORMSDIST(slope*LOG(factor)))","v":""},null,1,"kg AI/Ha =",{"$f":"I7*(1/AcPerHa)*LbsPerKg","v":{"v":0.8921827647159781,"d":"0.892"}},"lbs AI/acre"]
["Permetrin",0.159,5.52,null,"","","",null,1,"lbs AI/acre =",{"$f":"I6/(LbsPerKg/AcPerHa)","v":{"v":1.1208465793646496,"d":"1.121"}},"kg AI/Ha"]
["Phosdrin",0.305,7.77,null,"","","",null,1,"lbs AI/acre =",{"$f":"I8*16","v":16},"Oz AI/acre"]
["Clorpyriphos",0.11,10.17,null,"","","",null,1,"Oz AI/acre =",{"$f":"I9/16","v":0.0625},"lbs AI/acre"]
["Malathion",0.726,7.83,null,"","",""]
[{"$nulls":4},"","",""]
[null,2,1,1,{"v":0.5,"d":"0.50"},{"v":-0.3010299956639812,"d":"-0.30"},{"v":0.38169581076965786,"d":"38%"}]
[null,2,2,4,{"v":2,"d":"2.00"},{"v":0.6020599913279624,"d":"0.60"},{"v":0.7264328975138229,"d":"73%"},null,"Halflife model"]
[null,2,3,4,{"v":2,"d":"2.00"},{"v":0.9030899869919435,"d":"0.90"},{"v":0.8167609311033388,"d":"82%"},null,null,"hrs","halflife","Newfactor"]
["known 1/2 life",2,2,4,{"$f":"IF(OR(FieldRate=\"\",slope=\"\"),\"\",Newfactor*11.21*FieldRate/_LD50)","v":{"v":1.9977032319184314,"d":"2.00"}},{"v":0.6010619444436215,"d":"0.60"},{"v":0.7261006354870918,"d":"73%"},"<--","this row links",3,0.86,{"$f":"0.5^(TofExposure/halflife)","v":0.08910362318993895}]
[{"$nulls":9},3,0.86,0.08910362318993895]
["Note: These calculations assume the rule of thumb that field mortality",{"$nulls":8},1,0.86,0.4466477199290042]
["will be similar for lb/acre of AI to lab mortality for ug/bee AI",{"$nulls":8},4,0.86,0.039797930135199375]
["This is equivalent to bees receiving only 1/11.2 of the rate of field",{"$nulls":8},8,0.86,1.5838752430462103E-3]
["application of AI.  This rule of thumb assumes dilute water spray",{"$nulls":8},12,0.86,6.3034956265625028E-5]
["early in the morning, and average residual activity.",{"$nulls":8},14,0.86,1.2575107271966623E-5]
["Spraying after 7 AM will usually double the mortality;"]
["Spraying before 4 AM will usually halve the mortality.",{"$nulls":7},"Caution:","This halflife model is not well tested."]
["Long residual compounds will be more toxic than indicated.",{"$nulls":7},"Rules of thumb are equivalent to halflife of about 1 hour."]
["Short residual compounds will be less toxic than indicated.",{"$nulls":7},"if LD50 in lb/acre at 3 hours is same as LD50 in ug/bee,"]
["ULV applications will generally be more toxic than indicated.",{"$nulls":7},"then T50 is 0.86 hrs.  Or, If risk doubles or halves for"]
[{"$nulls":8},"each 3 hrs, then T50 is 0.90"]
[null,"This spreadsheet is copyright 2000 by P. Kirk Visscher",{"$nulls":6},"If halflife of activity is known, mortality can be corrected."]
[null,"further information can be obtained from",{"$nulls":6},"Newfactor provides the effective amount of AI still present."]
[null,"visscher@mail.ucr.edu",{"$nulls":6},"This is used with a rate factor based on actual µg AI/cm2."]
[{"$nulls":8},"The 1st row is linked to the to the mortality calculator"]

{"sheet":"Compound Data","index":1,"n_rows":91,"n_cols":7,"rows_kept":91,"merged":[[1,1,1,4],[1,5,1,6]]}
[]
["Pesticide*","Laboratory data",{"$nulls":3},"Field test data"]
["(trade and/or","Slope,","LD10","LD50","LD50","Toxicity of residues to bees:  †"]
[" common name)","probits",{"$nulls":3},"No. days","Hazard"]
["GROUP I—highly toxic pesticides (LD50 = 0.001 to 1.99 µg/bee)"]
["Severe losses may be expected if these pesticides are applied when bees are present at treatment time or within a day thereafter, except as indicated by footnotes.  (Listed in order of toxicity; first named is most toxic.)"]
["tepp1, 3",0.68,">0",2E-3,0.197,"0.5(H)","ML"]
["bioethanomethrin",3.95,0.017,0.035,0.074,"0.5(H)","L"]
["resmethrin ",4.17,0.031,0.062,0.126,"-","-"]
["decamethrin, Decis®",4.88,0.037,0.067,0.124,"1.5(H)","NIL"]
["Pay-Off®",3.37,0.035,0.078,0.172,"0.5(M)","NIL"]
["chlorpyrifos, Lorsban®, Dursban®",10.17,0.083,0.11,0.147,"2-3.5(H)","M-MH"]
["(continued)"]
["methyl parathion1,‡ ",5.13,0.063,0.111,0.197,"0.5(H)","H-VHi:"]
["dieldrin1",2.51,0.041,0.133,0.431,"1.5-5(H)","H"]
["carbofuran5, Furadan ®",6.14,0.092,0.149,0.241,"3>5(H)","M-H"]
["permethrin18, Ambush®, Pounce®",5.52,0.094,0.159,0.272,">5(VH)","L"]
["parathion1",4.96,0.098,0.175,0.321,"1(H)","H-VH"]
["fenitrothion, Sumithion®",5.75,0.105,0.176,0.294]
["dimethoate1, Cygon®, De-Fend'®",5.84,0.115,0.191,0.316,"1-3.5(H)","M-VH"]
["methidathion1, Supracide®",8.48,0.167,0.237,0.335,"2.5(H)","MH"]
["EPN1",4.31,0.119,0.237,0.469,"1.5-3(H)","H"]
["methyl parathion1,‡, encapsulated,",5.13,0.136,0.241,0.428]
["Penncap-M®"]
["etrimfos, Ekamet®",2.52,0.082,0.264,0.85,">5(H)","H-VH"]
["aldicarb1, 5, 7, Temik®",5,0.151,0.272,0.491,"-","-"]
["mexacarbate, Zectran®",4.87,0.165,0.302,0.553,"NIL","NIL§"]
["dicrotophos1, Bidrin®",15.86,0.253,0.305,0.367,"3(H)","H"]
["mevinphos1, 3, Phosdrin®",7.77,0.209,0.305,0.446,"2-4(H)","M-MH"]
["fenthion, Baytex®",6.14,0.197,0.319,0.515,"<1-1.5(H)","M-H"]
["fensulfothion5, Dasanit®",4.78,0.182,0.337,0.624,"-","-"]
["aldrin",5.06,0.197,0.352,0.629,"-","-"]
["monocrotophos1, Azodrin®",8.31,0.25,0.357,0.509,"-","-"]
["diazinon, Spectracide®",8.03,0.258,0.372,0.538,"2-3.5(H)","MH-VH"]
["methiocarb, Mesurol®",3.35,0.154,0.372,0.896,"1-2(H)","H"]
["fenvalerate, Pydrin®",4.46,0.211,0.408,0.791,"1 (L)","NIL"]
["famphur, Famophos®",4.85,0.225,0.414,0.759,"-","-"]
["azinphos-methyl1, Guthion®",7.43,0.288,0.428,0.637,"5(H)","M-VH"]
["bendiocarb, Ficam®",3.28,0.174,0.428,1.05,"-","-"]
["naled3, Dibrom®",16.43,0.406,0.485,0.581,"<1-1.5(H) ","MH-VH"]
["dichlorvos, DDVP, Vapona®",8.61,0.356,0.501,0.705,"-","-"]
["heptachlor1, Drinox®",5.94,0.32,0.526,0.864,"-","-"]
["isofenphos, Amaze®, Oftanol®",6.61,0.388,0.606,0.947,"-","-"]
["carbosulfan, FMC-35001",4.69,0.362,0.678,1.27,"3.5(H)","ML"]
["malathion4, Cythion®",7.83,0.49,0.726,1.6,"1-2(M)","L-MH"]
["azinphos-ethyl, Ethyl Guthion®",7.92,0.661,0.958,1.39,"-","-"]
["aminocarb, Matacil®",3.61,0.494,1.12,2.53,"-","-"]
["phosmet, Imidan®",3.55,0.495,1.13,2.6,"3.5(H)","MH-VH"]
["acephate, Orthene®",8.26,0.841,1.2,1.72,"2.5(H)","M-MH"]
["methomyl5, Lannate®, Nudrin®",2.39,0.374,1.29,4.42,"1.5(H)","L-M"]
["propoxur, Baygon®",3.23,0.537,1.34,3.33,"-","-"]
["methamidophos, Monitor®",0.61,1.04,1.37,1.81,"1 (M)","LM"]
["stirofos, Gardona®",3.96,1.13,1.39,1.72,"3.5-5(L)","LM-M"]
["fenamiphos5, Nemacur®",5.25,0.81,1.43,2.5,"-","-"]
["phosphamidon, Dimecron®",2.74,1.15,1.45,1.83,"2-5(M)","M-VH"]
["carbaryl, Sevin®",3.04,0.59,1.54,4.05,"3-7(H)","M-VH"]
["bufencarb, Bux®",4.95,0.91,1.65,2.99,"-","-"]
["pyrazophos, Afugan®",3.48,0.79,1.85,4.32,"-","-"]
["arsenicals1",1.22,2.47,27.15,299.04,"-","-"]
["GROUP II—moderately toxic pesticides (LD50 = 2.0 to 10.99 µg/bee)"]
["These can be used in the vicinity of bees if dosage, timing, and method of application are correct, but should not be applied directly on bees in the field or at colonies."]
["temephos, Abate®",2.56,0.44,1.4,4.42,"0-3(M)","L"]
["demeton1, 18, Systox®",10.02,1.27,1.71,2.29,"1 (L)","L"]
["trichloronate, Agritox®",4.28,1,2,3.98,"-","-"]
["endrin1, Endrex®",4.06,0.99,2.04,4.21,"1-3(M)","L-M"]
["crotoxyphos, Ciodrin®",15.42,1.92,2.31,2.78,"-","-"]
["Pyramat®",5.08,1.47,2.62,4.68,"-","-"]
["oxydemeton-methyl, Metasystox-R®",2.49,0.88,2.86,9.35,"0.5(L)","M-H"]
["profenofos, Curacon®",5.96,2.11,3.46,5.68,"-","-"]
["terbufos, Counter®",3.54,1.78,4.09,9.42,"-","-"]
["ethylan, Perthane®",4.01,2.19,4.57,9.57,"-","-"]
["ethoprop, Mocap®",4.66,2.95,5.56,10.5,"-"]
["ronnel, Korlan®",2.11,1.39,5.62,22.6,"-","-"]
["disulfoton1, 6, 18, Di-Syston®",1.19,0.52,6.12,72.7,"1 (L)","NIL"]
["DDT1, 10",4.74,3.33,6.19,11.5,"1(L)","L"]
["ethiofencarb, Croneton®",1.99,1.48,6.85,31.6,"N I L","N I L"]
["Larvin®, thiodicarb",3.52,3.08,7.08,16.3,"NIL","ML"]
["sulprofos, Bolstar®",5.53,4.43,7.22,12.3,"-","-"]
["endosulfan, Thiodan® ",3.15,3.06,7.81,19.9,"2(L)","L-MH"]
["fonofos, Dyfonate®",4.87,4.74,8.68,15.9,"-","-"]
["chlordane",2.34,2.5,8.8,30.9,"-","-"]
["phosalone, Zolone®",3.67,4.02,8.97,20,"-","-"]
["formetanate hydrochloride, Carzol®",4.21,4.57,9.21,18.6,"2(L)","L"]
["phorate1, 6, Thimet®",1.27,1,10.25,104.8,"<1-1(L)","L11"]
["temephos, Abate®",2.56,0.44,1.4,4.42,"0-3(M)","L"]
["oxamyl, Vydate®",5.81,6.17,10.26,17,"3-4(H)","VH "]
["carbophenothion, Trithion®",2.78,4.51,12.99,37.5,"<1 (M)","L"]
["Sevin® SL, carbaryl ",1.57,2.07,13.72,">100","6(MH)","H"]
["Pirimor®, pirimicarb ",2.87,6.71,18.72,52.2,"0.5(L)","L"]
["Sevin® SLR, carbaryl ",1.14,1.33,26.53,">100",">6(H)","M"]
["Mavrik®, fluvalinate",1.85,13.36,65.85,324.5,"0.5(L)","L-ML "]

{"sheet":"Probit Analysis","index":2,"n_rows":28,"n_cols":8,"rows_kept":28}
["Use: calculate LD50 or LC50 from entered dose and %mortality"]
["For LC50, change Label and format Applied_Dose as %"]
["For LD50, change Label and format Applied_Dose as general"]
["Label","enter dose. applied","enter pctmort","logdose","nscores","probits","fit logdose"]
[{"$f":"\"LC\"&TEXT(C5*100,0)","v":"LC50"},{"$f":"10^G5","v":{"v":0.004033739630747156,"d":"0.403%"}},{"v":0.5,"d":"50%"},"**",{"$f":"IF(C5=\"\",NA(),NORMSINV(C5))","v":{"v":0,"d":"0.00"}},{"$f":"IF(C5=\"\",NA(),E5+5)","v":5},{"$f":"TREND(INDEX(logdose,1):INDEX(logdose,COUNT(logdose)),INDEX(probits,1):INDEX(probits,COUNT(probits)),F5,TRUE)","v":-2.3942921379971067},{"$f":"\"Probits vs logdose \"&A5&\" at X\"","v":"Probits vs logdose LC50 at X"}]
[null,{"v":3.333E-3,"d":"0.333%"},{"v":0.1375,"d":"14%"},{"$f":"IF(dose=\"\",NA(),LOG(B6))","v":{"v":-2.47716468633947,"d":"-2.48"}},{"$f":"IF(pctmort=\"\",NA(),NORMSINV(C6))","v":{"v":-1.091620367434168,"d":"-1.09"}},{"$f":"IF(pctmort=\"\",NA(),E6+5)","v":3.9083796325658318},{"$f":"IF(pctmort=\"\",NA(),TREND(INDEX(logdose,1):INDEX(logdose,COUNT(logdose)),INDEX(probits,1):INDEX(probits,COUNT(probits)),F6,TRUE))","v":-2.4548456463108472}]
[null,{"v":0.004166,"d":"0.417%"},{"v":0.43119999999999997,"d":"43%"},{"v":-2.380280734388273,"d":"-2.38"},{"v":-0.17331987769005144,"d":"-0.17"},4.8266801223099485,{"$f":"IF(pctmort=\"\",NA(),TREND(INDEX(logdose,1):INDEX(logdose,COUNT(logdose)),INDEX(probits,1):INDEX(probits,COUNT(probits)),F7,TRUE))","v":-2.4039064022301107}]
[null,{"v":0.004583,"d":"0.458%"},{"v":0.7701,"d":"77%"},{"v":-2.3388501427552133,"d":"-2.34"},{"v":0.7391762178696043,"d":"0.74"},5.739176217869605,{"$f":"IF(pctmort=\"\",NA(),TREND(INDEX(logdose,1):INDEX(logdose,COUNT(logdose)),INDEX(probits,1):INDEX(probits,COUNT(probits)),F8,TRUE))","v":-2.3532891349482603}]
[null,{"v":0.005,"d":"0.500%"},{"v":0.9753000000000001,"d":"98%"},{"v":-2.3010299956639813,"d":"-2.30"},{"v":1.9651230274150542,"d":"1.97"},6.965123027415054,{"$f":"IF(pctmort=\"\",NA(),TREND(INDEX(logdose,1):INDEX(logdose,COUNT(logdose)),INDEX(probits,1):INDEX(probits,COUNT(probits)),F9,TRUE))","v":-2.285284375657718}]
[{"$nulls":3},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(pctmort=\"\",NA(),TREND(INDEX(logdose,1):INDEX(logdose,COUNT(logdose)),INDEX(probits,1):INDEX(probits,COUNT(probits)),F10,TRUE))","v":{"$error":"#N/A"}}]
[{"$nulls":3},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(pctmort=\"\",NA(),TREND(INDEX(logdose,1):INDEX(logdose,COUNT(logdose)),INDEX(probits,1):INDEX(probits,COUNT(probits)),F11,TRUE))","v":{"$error":"#N/A"}}]
[{"$nulls":3},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(pctmort=\"\",NA(),TREND(INDEX(logdose,1):INDEX(logdose,COUNT(logdose)),INDEX(probits,1):INDEX(probits,COUNT(probits)),F12,TRUE))","v":{"$error":"#N/A"}}]
[{"$nulls":3},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(pctmort=\"\",NA(),TREND(INDEX(logdose,1):INDEX(logdose,COUNT(logdose)),INDEX(probits,1):INDEX(probits,COUNT(probits)),F13,TRUE))","v":{"$error":"#N/A"}}]
[{"$nulls":3},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(pctmort=\"\",NA(),TREND(INDEX(logdose,1):INDEX(logdose,COUNT(logdose)),INDEX(probits,1):INDEX(probits,COUNT(probits)),F14,TRUE))","v":{"$error":"#N/A"}}]
[{"$nulls":3},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(pctmort=\"\",NA(),TREND(INDEX(logdose,1):INDEX(logdose,COUNT(logdose)),INDEX(probits,1):INDEX(probits,COUNT(probits)),F15,TRUE))","v":{"$error":"#N/A"}}]
[{"$nulls":3},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"IF(pctmort=\"\",NA(),TREND(INDEX(logdose,1):INDEX(logdose,COUNT(logdose)),INDEX(probits,1):INDEX(probits,COUNT(probits)),F16,TRUE))","v":{"$error":"#N/A"}}]
["probit/",null,"regression of probits on log(conc.)"]
["logunit",{"$f":"LINEST(INDEX(nscores,1):INDEX(nscores,COUNT(nscores)),INDEX(logdose,1):INDEX(logdose,COUNT(logdose)),TRUE,TRUE)","v":16.445751783219823},39.407504437580094,"intercept"]
["se slope",3.6063045372535973,8.56583500445258,"se intercept"]
["rsqr",0.9122658362188989,0.4735408105985377,"se y",null,{"$f":"SQRT(B20)","v":0.9551260839380835}]
["F",20.79613680470072,2,"df 2 (df 1=1)"]
["ss reg",4.663344419100167,0.44848179860464027,"ss resid"]
["P(F,df1,df2)=",null,{"$f":"FDIST(B21,1,C21)","v":0.04487391606191653}]
["calculate expected mortality from conc"]
[null,"conc.","%mort","probits"]
["set ",{"v":0.02,"d":"2.00%"},{"$f":"NORMSDIST(C18+B18*LOG(B26))","v":{"v":1,"d":"1.0000"}},{"$f":"C18+B18*LOG(B26)","v":11.466665459134024}]
[]
["Graphs bleow are to illstrate effect of Probit analysis tranformations"]