{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Calculator","CI list"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":0,"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":"Calculator","index":0,"n_rows":24,"n_cols":14,"rows_kept":24,"cut":false,"hidden":false,"merged":[[15,10,15,13]]}
[null,"Durability Monitoring"]
[null,"Sample size calculation for physical durability"]
[]
[null,null,null,null,null,null,null,null,null,null,"Notes:"]
[null,"Clusters per site",15,null,null,"Anticipated all cause attrition rate after 4 years",0.35,null,null,null,"Parameters with green shading will need to be updated per country context"]
[null,"Households per cluster",10,null,null,"Anticipated attrition due to \"wear and tear\" after three years",0.2,null,null,null,"Parameters in green boxes are generally true and do not usually need adjustment"]
[null,null,null,null,null,"Resulting proportion given away",null,{"$f":"G5-G6","v":0.14999999999999997},null,null,"Parameters and results in red boxes are locked"]
[null,null,"Baseline","Year 3"]
[null,"Total households per site",{"$f":"C5*C6","v":150},{"$f":"(C5*C6)-((C5*C6)*G15)","v":142.5},null,"Mean number of nets given in campaign per HH",2.5]
[null,"Nets per hh",{"$f":"$G$9-($G$9*$G$10)","v":2.2999999999999998},{"$f":"$G$9-($G$9*$G$10)","v":2.2999999999999998},null,"Proportion of campaign nets lost by time of baseline survey",0.08]
[null,"Cohort nets per site",{"$f":"C9*C10","v":345},{"$f":"(D9*D10)-((D9*D10)*(G5-G6))","v":278.58750000000003}]
[null,null,null,null,null,"Confidence level  (select from pull down list)",0.95,{"$f":"VLOOKUP(G12,'CI list'!B3:C5, 2, FALSE)","v":1.96}]
[null,null,null,null,null,"Expected % of nets surviving in serviceable condition after 3 years",0.5]
[null,null,null,null,null,"Design effect",2.5]
[null,null,null,null,null,"Non response rate",0.05]
[null,null,null,null,null,null,null,null,null,null,"Reference survival rates per median net life with CI"]
[null,null,null,null,null,"Sample size (cohort nets for evaluation in year 3)",null,{"$f":"D11","v":278.58750000000003},null,null,"1.5-year",0.04,{"$f":"IF($L17-(SQRT((($H$12*$H$12)*($L17*(1-$L17))*$G$14)/$H$17))>=0, $L17-(SQRT((($H$12*$H$12)*($L17*(1-$L17))*$G$14)/$H$17)), 0)","v":3.6159638224150178E-3},{"$f":"$L17+(SQRT((($H$12*$H$12)*($L17*(1-$L17))*$G$14)/$H$17))","v":7.6384036177584991E-2}]
[null,null,null,null,null,"Estimated margin of error  (plus minus X %-points)",null,{"$f":"SQRT((($H$12*$H$12)*($G$13*(1-$G$13))*$G$14)/$H$17)","v":9.2835753560465098E-2},null,null,"2-year",0.19,{"$f":"$L18-(SQRT((($H$12*$H$12)*($L18*(1-$L18))*$G$14)/$H$17))","v":0.11716089973884755},{"$f":"$L18+(SQRT((($H$12*$H$12)*($L18*(1-$L18))*$G$14)/$H$17))","v":0.26283910026115243}]
[null,null,null,null,null,"Estimated confidence interval for LLIN functional survival",null,{"$f":"G13-H18","v":0.40716424643953492},{"$f":"G13+H18","v":0.59283575356046514},null,"2.5-year",0.36,0.2708776765819535,0.44912232341804648]
[null,null,null,null,null,null,null,null,null,null,"3-year",0.5,0.40716424643953492,0.59283575356046514]
[null,null,null,null,null,"Calculate sample size needed if margin of error is +/- 10%",null,{"$f":"(($H$12*$H$12)*($G$13*(1-$G$13)))/(0.1*0.1)*$G$14*(1+$G$15)","v":252.10499999999993},null,null,"3.5-year",0.6,0.50903990955603751,0.69096009044396245]
[null,null,null,null,null,"Calculate sample size needed if margin of error is +/- 5%",null,{"$f":"(($H$12*$H$12)*($G$13*(1-$G$13)))/(0.05*0.05)*$G$14*(1+$G$15)","v":1008.4199999999997},null,null,"4-year",0.68,0.59338866989875438,0.76661133010124571]
[null,null,null,null,null,null,null,null,null,null,"4.5-year",0.74,0.65855811884367055,0.82144188115632943]
[null,null,null,null,null,null,null,null,null,null,"5-year",0.78,0.70308626450168155,0.85691373549831851]

{"sheet":"CI list","index":1,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[]
[null,"CI","z"]
[null,0.99,2.57]
[null,0.95,1.96]
[null,0.9,1.65]