{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Report"],"not_rendered":{"charts":10,"images":0,"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":"Report","index":0,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":false,"merged":[[20,2,20,4],[1,1,1,5],[15,1,15,5],[17,2,17,4],[18,2,18,4],[19,2,19,4]]}
[]
[null,"Sampling Error - Variable Confidence Level"]
[]
[null,"Total headcount (population)","Number of responses (sample size)","% Participation","Sampling error","Confidence level",null,"Total headcount (population)","Number of responses (sample size)","Critical Value (95% confidence level)","Sampling Error","Sample Proportion (uncertain)"]
[{"$f":"1-D5","v":0},10,10,{"$f":"C5/B5","v":1},{"$f":"IF(C5<B5,IF(B5<30,1.28*SQRT(0.5*(1-0.5))/SQRT((B5-1)*C5/(B5-C5)),IF(B5<50,1.45*SQRT(0.5*(1-0.5))/SQRT((B5-1)*C5/(B5-C5)),IF(B5<100,1.62*SQRT(0.5*(1-0.5))/SQRT((B5-1)*C5/(B5-C5)),1.96*SQRT(0.5*(1-0.5))/SQRT((B5-1)*C5/(B5-C5))))),0)","v":0},{"$f":"IF(B5<30,0.8,IF(B5<50,0.85,IF(B5<100,0.9,0.95)))","v":0.8},{"$f":"1-D5","v":0},39,{"$f":"(H5*(J5^2)*L5*(1-L5)/(K5^2)/(H5-1+((J5^2)*L5*(1-L5)/(K5^2))))","v":35.489482660602611},1.96,0.05,0.5]
[{"$f":"1-D6","v":9.9999999999999978E-2},20,18,0.9,{"$f":"IF(C6<B6,IF(B6<30,1.28*SQRT(0.5*(1-0.5))/SQRT((B6-1)*C6/(B6-C6)),IF(B6<50,1.45*SQRT(0.5*(1-0.5))/SQRT((B6-1)*C6/(B6-C6)),IF(B6<100,1.62*SQRT(0.5*(1-0.5))/SQRT((B6-1)*C6/(B6-C6)),1.96*SQRT(0.5*(1-0.5))/SQRT((B6-1)*C6/(B6-C6))))),0)","v":4.894202322571984E-2},{"$f":"IF(B6<30,0.8,IF(B6<50,0.85,IF(B6<100,0.9,0.95)))","v":0.8},{"$f":"1-D6","v":9.9999999999999978E-2}]
[9.9999999999999978E-2,30,27,{"$f":"C7/B7","v":0.9},4.4876373392787536E-2,0.85]
[0.14000000000000001,50,43,{"$f":"C8/B8","v":0.86},4.6687623834043034E-2,0.9]
[0.19999999999999996,100,80,0.8,4.924685294770139E-2,0.95]
[0.33999999999999997,200,132,0.66,4.9861693897713923E-2,0.95]
[0.56400000000000006,500,218,0.436,4.9896732909741642E-2,0.95]
[0.72,1000,280,0.28000000000000003,4.9719936364320413E-2,0.95]
[0.92800000000000005,5000,360,7.1999999999999995E-2,4.9761360676543534E-2,0.95]
[0.96299999999999997,10000,370,3.6999999999999998E-2,4.999885662934804E-2,0.95]
[]
[null,"Type any values into the green cells. The 'Total headcount' column is the total number of employees in a business unit, and the 'Number of responses' is the number of employees that participated in the survey. "]
[]
[null,"Sampling Error","Description"]
[null,"< 5%","Survey response % is adequately representative of the\npopulation and survey results can be used with confidence"]
[null,"5 - 10%","Survey response % is not adequately representative of the population and survey results should be used with caution "]
[null,"> 10%","Survey response % is not representative of the population and survey results should not be used as basis for important decisions"]