{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["TC3 (GMIM) MUESTREO","Muestreo Aleatorio Simple","Muestreo Estratificado","Muestreo Información Auxiliar","Muestreo por Conglomerados","Estimacion Tamaño Población"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"TC3 (GMIM) MUESTREO","index":0,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"MUESTREO"]
[]
[null,null,"Técnicas Cuantitativas 3"]
[null,null,"Muestreo aleatorio simple."]
[null,null,"Muestreo aleatorio estratificado."]
[null,null,"Muestreo con información auxiliar."]
[null,null,"Muestreo sistemático."]
[null,null,"Muestreo por conglomerados."]
[null,null,"Estimación del tamaño de la población."]
[]
[null,null,"Grado en Marketing e Investigación de Mercados. Universidad de Granada."]
[]
[null,null,"© TC3. José Alberto Hermoso Gutiérrez"]

{"sheet":"Muestreo Aleatorio Simple","index":1,"n_rows":1013,"n_cols":11,"rows_kept":1013,"cut":false,"hidden":false,"merged":[[1,4,1,5]]}
["© TC3. José Alberto Hermoso Gutiérrez"]
[null,null,{"$f":"IF(OR(B6=0,B12=0,B19=0,B25=0,B31=0),\"COMPLETE EL FORMULARIO\",\"\")","v":""},null,{"$f":"IF(AND(B12=3,B19=1),\"Sin datos muestrales no es posible hacer una estimación\",IF(G10>0,\"Escriba sólo los datos solicitados\",\"\"))","v":""},null,"check","Datos"]
[null,null,null,null,{"$f":"IF(B6=1,\"Tamaño de la población:\",\"\")","v":"Tamaño de la población:"},2000,{"$f":"IF(OR(AND(E3=\"\",F3<>\"\"),AND(E3<>\"\",F3=\"\")),1,0)","v":0},"coef. corrector=",{"$f":"IF(G11=0,IF(B19=1,IF(B31=1,\"*Nivel de confianza 90% (z=1,645)\",IF(B31=2,\"*Nivel de confianza 95% (z=1,96)\",IF(B31=3,\"*Nivel de confianza 95% (z=2)\",IF(B31=4,\"*Nivel de confianza 99% (z=2,576)\",\"\")))),\"\"),\"\")","v":""},{"$f":"IF(G11=0,IF(B19=1,IF(B25=1,\"Media\",IF(B25=2,\"Proporción\",\"\")),\"\"),\"\")","v":""},{"$f":"IF(G11=0,IF(AND(B19=1,B6=1),\"Total\",\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(B12=2,B19=1),\"Tamaño de la muestra:\",\"\")","v":""},null,{"$f":"IF(OR(AND(E4=\"\",F4<>\"\"),AND(E4<>\"\",F4=\"\")),1,0)","v":0},{"$f":"IF(B6=2,1,IF(AND(B6=1,F3<>\"\",F10<>\"\"),(F3-F10)/F3,\"\"))","v":""},{"$f":"IF(G11=0,IF(B19=1,\"Estimación:\",\"\"),\"\")","v":""},{"$f":"IF(G11=0,IF(B19=1,IF(F11=\"\",\"\",F11),\"\"),\"\")","v":""},{"$f":"IF(G11=0,IF(OR(J4=\"\",F3=\"\"),\"\",F3*J4),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(B12=2,B19=1,B25=1),\"Media muestral:\",IF(AND(B12=2,B25=2),\"Proporción muestral:\",\"\"))","v":""},null,{"$f":"IF(OR(AND(E5=\"\",F5<>\"\"),AND(E5<>\"\",F5=\"\")),1,0)","v":0},null,{"$f":"IF(G11=0,IF(B19=1,\"Varianza del estimador:\",\"\"),\"\")","v":""},{"$f":"IF(G11=0,IF(B19=1,IF(OR(F10=\"\",F12=\"\",H4=\"\"),\"\",F12*H4/F10),\"\"),\"\")","v":""},{"$f":"IF(G11=0,IF(OR(J5=\"\",F3=\"\"),\"\",F3*F3*J5),\"\")","v":""}]
[null,1,null,null,{"$f":"IF(AND(B12=2,B25=1),\"Cuasivarianza muestral:\",\"\")","v":"Cuasivarianza muestral:"},36854,{"$f":"IF(OR(AND(E6=\"\",F6<>\"\"),AND(E6<>\"\",F6=\"\")),1,0)","v":0},"B media=",{"$f":"IF(G11=0,IF(B19=1,\"*Cota del error de estimación:\",\"\"),\"\")","v":""},{"$f":"IF(G11=0,IF(OR($D$33=\"\",J5=\"\"),\"\",$D$33*SQRT(J5)),\"\")","v":""},{"$f":"IF(G11=0,IF(OR(K5=\"\",$D$33=\"\"),\"\",$D$33*SQRT(K5)),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(B12=3,B19=2,B25=1),\"Rango de variación de la variable:\",\"\")","v":""},null,{"$f":"IF(OR(AND(E7=\"\",F7<>\"\"),AND(E7<>\"\",F7=\"\")),1,0)","v":0},{"$f":"IF(AND(F8<>\"\",F9=\"\"),F8,IF(AND(F8=\"\",F9<>\"\",F3<>\"\"),F9/F3,IF(AND(F8<>\"\",F9<>\"\",F3<>\"\"),MIN(F8,(F9/F3)),\"\")))","v":50},{"$f":"IF(G11=0,IF(B19=1,\"*Intervalo de confianza (extremo inferior):\",\"\"),\"\")","v":""},{"$f":"IF(G11=0,IF(OR(J4=\"\",J6=\"\"),\"\",J4-J6),\"\")","v":""},{"$f":"IF(G11=0,IF(OR(K4=\"\",K6=\"\"),\"\",K4-K6),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(B19=2,B25=2),\"Cota del error de estimación para la proporción:\",IF(AND(B19=2,B25=1),\"Cota del error de estimación para la media:\",\"\"))","v":"Cota del error de estimación para la media:"},null,{"$f":"IF(OR(AND(E8=\"\",F8<>\"\"),AND(E8<>\"\",F8=\"\",F9=\"\")),1,0)","v":0},"D para hallar n=",{"$f":"IF(G11=0,IF(B19=1,\"*Intervalo de confianza (extremo superior):\",\"\"),\"\")","v":""},{"$f":"IF(G11=0,IF(OR(J4=\"\",J6=\"\"),\"\",J4+J6),\"\")","v":""},{"$f":"IF(G11=0,IF(OR(K4=\"\",K6=\"\"),\"\",K4+K6),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(B19=2,B6=1),\"y/o Cota del error de estimación para el total:\",\"\")","v":"y/o Cota del error de estimación para el total:"},100000,{"$f":"IF(OR(AND(E9=\"\",F9<>\"\"),AND(E9<>\"\",F9=\"\",F8=\"\")),1,0)","v":0},{"$f":"IF(OR(H7=\"\",$D$33=\"\"),\"\",(H7/$D$33)^2)","v":923.86433976034948},{"$f":"IF(G11=0,IF(B19=2,IF(B31=1,\"Nivel de confianza 90% (z=1,645)\",IF(B31=2,\"Nivel de confianza 95% (z=1,96)\",IF(B31=3,\"Nivel de confianza 95% (z=2)\",IF(B31=4,\"Nivel de confianza 99% (z=2,576)\",\"\")))),\"\"),\"\")","v":"Nivel de confianza 90% (z=1,645)"},{"$f":"IF(G11=0,IF(J10=\"\",\"\",1),\"\")","v":1}]
[null,null,null,null,null,{"$f":"IF(B12=1,COUNT(F14:F1013),IF(AND(B12=2,F4<>\"\"),F4,\"\"))","v":""},{"$f":"SUM(G3:G9)","v":0},"←n tam. muestra",{"$f":"IF(G11=0,IF(B19=2,\"Tamaño muestral para la cota de error:\",\"\"),\"\")","v":"Tamaño muestral para la cota de error:"},{"$f":"IF(G11=0,IF(AND(B6=2,B19=2,F12<>\"\",H9<>\"\",OR(B25=1,AND(B25=2,B12=3))),F12/H9,IF(AND(B6=2,B19=2,B25=2,F11<>\"\",H9<>\"\"),F11*(1-F11)/H9,IF(AND(B6=1,B19=2,F12<>\"\",F3<>\"\",H9<>\"\",OR(B25=1,AND(B25=2,B12=3))),F3*F12/(((F3-1)*H9)+F12),IF(AND(B6=1,B19=2,B25=2,F11<>\"\",F3<>\"\",H9<>\"\"),F3*F11*(1-F11)/(((F3-1)*H9)+(F11*(1-F11))),\"\")))),\"\")","v":39.130228577471883}]
[null,null,null,{"$f":"IF(AND(B12=3,B19=1),1,0)","v":0},null,{"$f":"IF(B12=1,AVERAGE(F14:F1013),IF(AND(B12=2,F5<>\"\"),F5,\"\"))","v":""},{"$f":"SUM(D11,D13,G12,G10)","v":0},"←media muestra"]
[null,2,null,null,{"$f":"IF(G12>0,\"Complete los datos de la muestra\",\"\")","v":""},{"$f":"IF(B12=1,VAR(F14:F1013),IF(AND(B12=2,B25=1,F6<>\"\"),F6,IF(AND(B12=2,B25=2,F4<>\"\",F5<>\"\"),F4*F5*(1-F5)/(F4-1),IF(AND(B12=3,B25=1,F7<>\"\"),F7*F7/16,IF(AND(B12=3,B25=2),0.25,\"\")))))","v":36854},{"$f":"SUM(G14:G15)","v":0},"←cuasivar muestra"]
[null,null,null,{"$f":"IF(OR(B31=\"\",B25=\"\",B19=\"\",B12=\"\",B6=\"\"),1,0)","v":0},{"$f":"IF(B12=1,\"Muestras de hasta 1000 datos\",\"\")","v":""},"MUESTRA"]
[null,null,null,{"$f":"IF(AND(B6=2,B12=1,B19=1),1,0)","v":0},null,null,{"$f":"IF(AND($B$12=1,F14=\"\"),1,0)","v":0}]
[null,null,null,null,null,null,{"$f":"IF(AND($B$12=1,F15=\"\"),1,0)","v":0}]
[]
[]
[]
[null,2]
[]
[]
[]
[]
[]
[null,1]
[]
[]
[null,null,null,{"$f":"IF(B31=1,1.645,0)","v":1.645}]
[null,null,null,{"$f":"IF(B31=2,1.96,0)","v":0}]
[null,null,null,{"$f":"IF(B31=3,2,0)","v":0}]
[null,1,null,{"$f":"IF(B31=4,2.576,0)","v":0}]
[]
[null,null,null,{"$f":"SUM(D28:D31)","v":1.645}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"Esta hoja sirve para muestras de hasta 1000 datos"]

{"sheet":"Muestreo Estratificado","index":2,"n_rows":1015,"n_cols":19,"rows_kept":1015,"cut":false,"hidden":false,"merged":[[7,5,7,6],[8,5,8,6],[9,5,9,6],[1,2,1,3],[2,5,2,6],[3,5,3,6],[4,5,4,6],[5,5,5,6],[6,5,6,6]]}
["© TC3. José Alberto Hermoso Gutiérrez",null,null,null,null,null,"varianza para determinación de n=",{"$f":"IF(AND($B$16=1,$B$31=1),VAR(H16:H1015),IF(AND($B$16=1,$B$31=2),H13*(1-H13),IF(AND($B$16=2,$B$31=1,H8<>\"\"),H8,IF(AND($B$16=2,$B$31=2,H7<>\"\"),H7*(1-H7),IF(AND($B$16=3,$B$31=1,H9<>\"\"),H9*H9/16,IF(AND($B$16=3,$B$31=2),0.25,\"\"))))))","v":2.5},{"$f":"IF(AND($B$16=1,$B$31=1),VAR(I16:I1015),IF(AND($B$16=1,$B$31=2),I13*(1-I13),IF(AND($B$16=2,$B$31=1,I8<>\"\"),I8,IF(AND($B$16=2,$B$31=2,I7<>\"\"),I7*(1-I7),IF(AND($B$16=3,$B$31=1,I9<>\"\"),I9*I9/16,IF(AND($B$16=3,$B$31=2),0.25,\"\"))))))","v":2.4761904761904723},{"$f":"IF($B$7<3,0,IF(AND($B$16=1,$B$31=1),VAR(J16:J1015),IF(AND($B$16=1,$B$31=2),J13*(1-J13),IF(AND($B$16=2,$B$31=1,J8<>\"\"),J8,IF(AND($B$16=2,$B$31=2,J7<>\"\"),J7*(1-J7),IF(AND($B$16=3,$B$31=1,J9<>\"\"),J9*J9/16,IF(AND($B$16=3,$B$31=2),0.25,\"\")))))))","v":2},{"$f":"IF($B$7<4,0,IF(AND($B$16=1,$B$31=1),VAR(K16:K1015),IF(AND($B$16=1,$B$31=2),K13*(1-K13),IF(AND($B$16=2,$B$31=1,K8<>\"\"),K8,IF(AND($B$16=2,$B$31=2,K7<>\"\"),K7*(1-K7),IF(AND($B$16=3,$B$31=1,K9<>\"\"),K9*K9/16,IF(AND($B$16=3,$B$31=2),0.25,\"\")))))))","v":1.7000000000000028},"N↓","Ni/N"]
[null,null,{"$f":"IF(OR(B7=0,B10=0,B16=0,B23=0,B31=0,B37=0),\"COMPLETE EL FORMULARIO\",\"\")","v":""},null,null,null,{"$f":"IF(AND(B16=3,B23=1),\"Sin datos muestrales no es posible hacer una estimación\",IF(L11>0,\"Escriba sólo los datos solicitados\",\"\"))","v":""},{"$f":"IF($B$10=1,H4,H5)","v":120},{"$f":"IF($B$10=1,I4,I5)","v":240},{"$f":"IF($B$7<3,0,IF($B$10=1,J4,J5))","v":55},{"$f":"IF($B$7<4,0,IF($B$10=1,K4,K5))","v":90},{"$f":"SUM(H2:K2)","v":505},{"$f":"TRANSPOSE(H2:K2)/SUM(H2:K2)","v":0.23762376237623761}]
[null,null,null,null,null,null,null,"ESTRATO 1","ESTRATO 2","ESTRATO 3","ESTRATO 4",null,0.47524752475247523,"POBLACION",{"$f":"IF($B$37=1,\"*Nivel de confianza 90% (z=1,645)\",IF($B$37=2,\"*Nivel de confianza 95% (z=1,96)\",IF($B$37=3,\"*Nivel de confianza 95% (z=2)\",IF($B$37=4,\"*Nivel de confianza 99% (z=2,576)\",\"\"))))","v":"*Nivel de confianza 90% (z=1,645)"},"ESTRATO 1","ESTRATO 2","ESTRATO 3","ESTRATO 4"]
[null,null,null,null,null,{"$f":"IF(B10=1,\"Tamaño de la población:\",\"\")","v":"Tamaño de la población:"},null,120,240,55,90,{"$f":"IF(OR(AND(F4=\"\",$B$7=4,OR(H4<>\"\",I4<>\"\",J4<>\"\",K4<>\"\")),AND(F4=\"\",$B$7=3,OR(H4<>\"\",I4<>\"\",J4<>\"\")),AND(F4=\"\",OR(H4<>\"\",I4<>\"\")),AND(F4<>\"\",$B$7=4,OR(H4=\"\",I4=\"\",J4=\"\",K4=\"\")),AND(F4<>\"\",$B$7=3,OR(H4=\"\",I4=\"\",J4=\"\")),AND(F4<>\"\",OR(H4=\"\",I4=\"\"))),1,\"\")","v":""},0.10891089108910891,null,{"$f":"IF(B31=1,\"Media\",IF(B31=2,\"Proporción\",\"\"))","v":"Media"}]
[null,null,null,null,null,{"$f":"IF(B10=2,\"Tamaño relativo de la población (%):\",\"\")","v":""},null,null,null,null,null,"",0.17821782178217821,{"$f":"MMULT(P5:S5,M2:M5)","v":5.1398396982555399},"Estimación:",{"$f":"H13","v":3},{"$f":"I13","v":6.1428571428571432},{"$f":"IF($B$7>2,J13,0)","v":5.333333333333333},{"$f":"IF($B$7>3,K13,0)","v":5.2}]
[null,null,null,null,null,{"$f":"IF(AND(B16=2,B23=1),\"Tamaño de la muestra:\",\"\")","v":""},null,null,null,null,null,"","(Ni/N)^2",{"$f":"MMULT(P6:S6,M7:M10)","v":0.1170255728341069},"Varianza del estimador:",{"$f":"H14*H11/H12","v":0.47916666666666669},{"$f":"I14*I11/I12","v":0.34342403628117862},{"$f":"IF($B$7>2,J14*J11/J12,0)","v":0.18585858585858583},{"$f":"IF($B$7>3,K14*K11/K12,0)","v":0.32111111111111168}]
[null,4,null,{"$f":"IF(B7=\"\",\"\",B7)","v":4},null,{"$f":"IF(AND(B16=2,B23=1,B31=1),\"Media muestral:\",IF(AND(B16=2,B31=2),\"Proporción muestral:\",\"\"))","v":""},null,null,null,null,null,{"$f":"IF(OR(AND(F7=\"\",$B$7=4,OR(H7<>\"\",I7<>\"\",J7<>\"\",K7<>\"\")),AND(F7=\"\",$B$7=3,OR(H7<>\"\",I7<>\"\",J7<>\"\")),AND(F7=\"\",OR(H7<>\"\",I7<>\"\")),AND(F7<>\"\",$B$7=4,OR(H7=\"\",I7=\"\",J7=\"\",K7=\"\")),AND(F7<>\"\",$B$7=3,OR(H7=\"\",I7=\"\",J7=\"\")),AND(F7<>\"\",OR(H7=\"\",I7=\"\"))),1,\"\")","v":""},{"$f":"M2^2","v":5.6465052445838639E-2},{"$f":"$E$41*SQRT(N6)","v":0.56273806138239324},"*Cota del error de estimación:",{"$f":"$E$41*SQRT(P6)","v":1.1386996878750195},{"$f":"$E$41*SQRT(Q6)","v":0.96400935046179725},{"$f":"$E$41*SQRT(R6)","v":0.70918120378220673},{"$f":"$E$41*SQRT(S6)","v":0.93216666666666759}]
[null,null,null,null,null,{"$f":"IF(AND(B16=2,B31=1),\"Cuasivarianza muestral:\",\"\")","v":""},null,null,null,null,null,"",{"$f":"M3^2","v":0.22586020978335455},{"$f":"N5-N7","v":4.577101636873147},"*Intervalo de confianza (extremo inferior):",{"$f":"P5-P7","v":1.8613003121249805},{"$f":"Q5-Q7","v":5.178847792395346},{"$f":"R5-R7","v":4.6241521295511259},{"$f":"S5-S7","v":4.2678333333333329}]
[null,null,null,null,null,{"$f":"IF(AND(B16=3,B23>1,B31=1),\"Rango de variación de la variable:\",\"\")","v":""},null,null,null,null,null,"",{"$f":"M4^2","v":1.1861582197823742E-2},{"$f":"N5+N7","v":5.7025777596379328},"*Intervalo de confianza (extremo superior):",{"$f":"P5+P7","v":4.13869968787502},{"$f":"Q5+Q7","v":7.1068664933189405},{"$f":"R5+R7","v":6.0425145371155402},{"$f":"S5+S7","v":6.1321666666666674}]
[null,1,null,null,null,{"$f":"IF(OR(B23=2,B23=3),\"Coste de una observación\",\"\")","v":""},null,null,null,null,null,"",{"$f":"M5^2","v":3.1761592000784232E-2},null,"Total"]
[null,null,null,null,{"$f":"IF(OR(AND(F11=\"\",G11<>\"\"),AND(F11<>\"\",G11=\"\",G12=\"\")),1,0)","v":0},{"$f":"IF(AND(B23>2,B31=2),\"Cota del error de estimación para la proporción:\",IF(AND(B23>2,B31=1),\"Cota del error de estimación para la media:\",\"\"))","v":""},null,{"$f":"IF($B$10=2,1,IF(AND($B$10=1,H4<>\"\",H12<>\"\"),(H4-H12)/H4,\"\"))","v":0.95833333333333337},{"$f":"IF($B$10=2,1,IF(AND($B$10=1,I4<>\"\",I12<>\"\"),(I4-I12)/I4,\"\"))","v":0.97083333333333333},{"$f":"IF($B$10=2,1,IF(AND($B$10=1,J4<>\"\",J12<>\"\"),(J4-J12)/J4,\"\"))","v":0.83636363636363631},{"$f":"IF($B$10=2,1,IF(AND($B$10=1,K4<>\"\",K12<>\"\"),(K4-K12)/K4,\"\"))","v":0.94444444444444442},{"$f":"SUM(L3:L10,E11:E13)","v":0},"←coef corr",{"$f":"SUM(H2:K2)*N5","v":2595.6190476190477},"Estimación:",{"$f":"H2*P5","v":360},{"$f":"I2*Q5","v":1474.2857142857144},{"$f":"J2*R5","v":293.33333333333331},{"$f":"K2*S5","v":468}]
[null,null,null,null,{"$f":"IF(OR(AND(F12=\"\",G12<>\"\"),AND(F12<>\"\",G12=\"\",G11=\"\")),1,0)","v":0},{"$f":"IF(AND(B23>2,B10=1),\"y/o Cota del error de estimación para el total:\",\"\")","v":""},null,{"$f":"IF($B$16=1,COUNT(H16:H1015),IF(AND($B$16=2,H6<>\"\"),H6,\"\"))","v":5},{"$f":"IF($B$16=1,COUNT(I16:I1015),IF(AND($B$16=2,I6<>\"\"),I6,\"\"))","v":7},{"$f":"IF($B$16=1,COUNT(J16:J1015),IF(AND($B$16=2,J6<>\"\"),J6,\"\"))","v":9},{"$f":"IF($B$16=1,COUNT(K16:K1015),IF(AND($B$16=2,K6<>\"\"),K6,\"\"))","v":5},{"$f":"SUM(E24,L13,L11)","v":0},"←n ",{"$f":"(SUM(H2:K2)^2)*N6","v":29844.446712018114},"Varianza del estimador:",{"$f":"(H2^2)*P6","v":6900},{"$f":"(I2^2)*Q6","v":19781.224489795888},{"$f":"(J2^2)*R6","v":562.22222222222217},{"$f":"(K2^2)*S6","v":2601.0000000000045}]
[null,null,null,null,{"$f":"IF(OR(AND(F13=\"\",G13<>\"\"),AND(F13<>\"\",G13=\"\")),1,0)","v":0},{"$f":"IF(B23=2,\"Coste total máximo para la muestra:\",\"\")","v":""},null,{"$f":"IF($B$16=1,AVERAGE(H16:H1015),IF(AND($B$16=2,H7<>\"\"),H7,\"\"))","v":3},{"$f":"IF($B$16=1,AVERAGE(I16:I1015),IF(AND($B$16=2,I7<>\"\"),I7,\"\"))","v":6.1428571428571432},{"$f":"IF($B$16=1,AVERAGE(J16:J1015),IF(AND($B$16=2,J7<>\"\"),J7,\"\"))","v":5.333333333333333},{"$f":"IF($B$16=1,AVERAGE(K16:K1015),IF(AND($B$16=2,K7<>\"\"),K7,\"\"))","v":5.2},{"$f":"SUM(L16:L17)","v":0},"←media p",{"$f":"$E$41*SQRT(N12)","v":284.18272099810855},"*Cota del error de estimación:",{"$f":"$E$41*SQRT(P12)","v":136.64396254500232},{"$f":"$E$41*SQRT(Q12)","v":231.36224411083137},{"$f":"$E$41*SQRT(R12)","v":39.004966208021372},{"$f":"$E$41*SQRT(S12)","v":83.895000000000067}]
[null,null,null,null,null,null,null,{"$f":"IF($B$16=1,VAR(H16:H1015),IF(AND($B$16=2,$B$31=1,H8<>\"\"),H8,IF(AND($B$16=2,$B$31=2,H6<>\"\",H7<>\"\"),H6*H7*(1-H7)/(H6-1),IF(AND($B$16=3,$B$31=1,H9<>\"\"),H9*H9/16,IF(AND($B$16=3,$B$31=2),0.25,\"\")))))","v":2.5},{"$f":"IF($B$16=1,VAR(I16:I1015),IF(AND($B$16=2,$B$31=1,I8<>\"\"),I8,IF(AND($B$16=2,$B$31=2,I6<>\"\",I7<>\"\"),I6*I7*(1-I7)/(I6-1),IF(AND($B$16=3,$B$31=1,I9<>\"\"),I9*I9/16,IF(AND($B$16=3,$B$31=2),0.25,\"\")))))","v":2.4761904761904723},{"$f":"IF($B$16=1,VAR(J16:J1015),IF(AND($B$16=2,$B$31=1,J8<>\"\"),J8,IF(AND($B$16=2,$B$31=2,J6<>\"\",J7<>\"\"),J6*J7*(1-J7)/(J6-1),IF(AND($B$16=3,$B$31=1,J9<>\"\"),J9*J9/16,IF(AND($B$16=3,$B$31=2),0.25,\"\")))))","v":2},{"$f":"IF($B$16=1,VAR(K16:K1015),IF(AND($B$16=2,$B$31=1,K8<>\"\"),K8,IF(AND($B$16=2,$B$31=2,K6<>\"\",K7<>\"\"),K6*K7*(1-K7)/(K6-1),IF(AND($B$16=3,$B$31=1,K9<>\"\"),K9*K9/16,IF(AND($B$16=3,$B$31=2),0.25,\"\")))))","v":1.7000000000000028},null,"←var",{"$f":"N11-N13","v":2311.4363266209393},"*Intervalo de confianza (extremo inferior):",{"$f":"P11-P13","v":223.35603745499768},{"$f":"Q11-Q13","v":1242.9234701748831},{"$f":"R11-R13","v":254.32836712531196},{"$f":"S11-S13","v":384.1049999999999}]
[null,null,null,null,null,null,{"$f":"IF(B16=1,\"Muestras de hasta 1000 datos\",\"\")","v":"Muestras de hasta 1000 datos"},"MUESTRA 1","MUESTRA 2","MUESTRA 3","MUESTRA 4",null,null,{"$f":"N11+N13","v":2879.8017686171561},"*Intervalo de confianza (extremo superior):",{"$f":"P11+P13","v":496.6439625450023},{"$f":"Q11+Q13","v":1705.6479583965458},{"$f":"R11+R13","v":332.33829954135467},{"$f":"S11+S13","v":551.8950000000001}]
[null,1,null,null,null,null,{"$f":"IF(L13>0,\"Complete los datos de las muestras solicitadas\",\"\")","v":""},1,5,7,7,{"$f":"IF(OR(AND($B$16=1,$B$7=4,OR(H16=\"\",I16=\"\",J16=\"\",K16=\"\")),AND($B$16=1,$B$7=3,OR(H16=\"\",I16=\"\",J16=\"\")),AND($B$16=1,OR(H16=\"\",I16=\"\"))),1,0)","v":0},"Ni","POBLACION",{"$f":"IF($B$37=1,\"*Nivel de confianza 90% (z=1,645). Coste fijo\",IF($B$37=2,\"*Nivel de confianza 95% (z=1,96). Coste fijo\",IF($B$37=3,\"*Nivel de confianza 95% (z=2). Coste fijo\",IF($B$37=4,\"*Nivel de confianza 99% (z=2,576). Coste fijo\",\"\"))))","v":"*Nivel de confianza 90% (z=1,645). Coste fijo"},"ESTRATO 1","ESTRATO 2","ESTRATO 3","ESTRATO 4"]
[null,null,null,null,null,"B sobre la media=",null,2,4,5,4,{"$f":"IF(OR(AND($B$16=1,$B$7=4,OR(H17=\"\",I17=\"\",J17=\"\",K17=\"\")),AND($B$16=1,$B$7=3,OR(H17=\"\",I17=\"\",J17=\"\")),AND($B$16=1,OR(H17=\"\",I17=\"\"))),1,0)","v":0},{"$f":"TRANSPOSE(H2:K2)","v":120},null,"Asignación Óptima:  Coeficientes de asignación",{"$f":"P29/SUM($P29:$S29)","v":{"$error":"#DIV/0!"}},{"$f":"Q29/SUM($P29:$S29)","v":{"$error":"#DIV/0!"}},{"$f":"R29/SUM($P29:$S29)","v":{"$error":"#DIV/0!"}},{"$f":"S29/SUM($P29:$S29)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,{"$f":"IF(AND(G11<>\"\",G12=\"\"),G11,IF(AND(G11=\"\",G12<>\"\",L2<>\"\"),G12/L2,IF(AND(G11<>\"\",G12<>\"\",L2<>\"\"),MIN(G11,(G12/L2)),\"\")))","v":""},null,3,8,8,6,null,240,{"$f":"G13*SUM(P29:S29)/SUM(P28:S28)","v":{"$error":"#DIV/0!"}},"              Tamaño de la muestra",{"$f":"$N18*P17","v":{"$error":"#DIV/0!"}},{"$f":"$N18*Q17","v":{"$error":"#DIV/0!"}},{"$f":"$N18*R17","v":{"$error":"#DIV/0!"}},{"$f":"$N18*S17","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,{"$f":"IF(AND(B16=3,B23=1),1,0)","v":0},"D=",null,4,5,5,5,null,55,"POBLACION",{"$f":"IF($B$37=1,\"*Nivel de confianza 90% (z=1,645). Error fijo\",IF($B$37=2,\"*Nivel de confianza 95% (z=1,96). Error fijo\",IF($B$37=3,\"*Nivel de confianza 95% (z=2). Error fijo\",IF($B$37=4,\"*Nivel de confianza 99% (z=2,576). Error fijo\",\"\"))))","v":"*Nivel de confianza 90% (z=1,645). Error fijo"},"ESTRATO 1","ESTRATO 2","ESTRATO 3","ESTRATO 4"]
[null,null,null,null,null,{"$f":"IF(OR(F18=\"\",$E$41=\"\"),\"\",(F18/$E$41)^2)","v":""},null,5,6,4,4,null,90,null,"Asig. Proporcional:   Coeficientes de asignación",{"$f":"H2/SUM($H2:$K2)","v":0.23762376237623761},{"$f":"I2/SUM($H2:$K2)","v":0.47524752475247523},{"$f":"J2/SUM($H2:$K2)","v":0.10891089108910891},{"$f":"K2/SUM($H2:$K2)","v":0.17821782178217821}]
[null,null,null,null,{"$f":"IF(OR(B37=\"\",B31=\"\",B23=\"\",B16=\"\",B10=\"\",B7=\"\"),1,0)","v":0},null,null,null,7,6,null,null,null,{"$f":"IF(B10=1,SUM(P26:S26)/((L2*F20)+(SUM(P26:S26)/L2)),SUM(P26:S26)/(100*F20))","v":{"$error":"#VALUE!"}},"                       Tamaño de la muestra",{"$f":"$N21*P20","v":{"$error":"#VALUE!"}},{"$f":"$N21*Q20","v":{"$error":"#VALUE!"}},{"$f":"$N21*R20","v":{"$error":"#VALUE!"}},{"$f":"$N21*S20","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,8,5,null,null,null,null,"Asig. Neyman:         Coeficientes de asignación",{"$f":"P27/SUM($P27:$S27)","v":0.24882646931316718},{"$f":"Q27/SUM($P27:$S27)","v":0.49527749337533494},{"$f":"R27/SUM($P27:$S27)","v":0.10200536499734299},{"$f":"S27/SUM($P27:$S27)","v":0.1538906723141551}]
[null,1,null,null,null,null,null,null,null,4,null,null,null,{"$f":"IF(B10=1,(SUM(P27:S27)^2)/((L2*L2*F20)+SUM(P26:S26)),(SUM(P27:S27)^2)/(10000*F20))","v":{"$error":"#VALUE!"}},"               Tamaño de la muestra",{"$f":"$N23*P22","v":{"$error":"#VALUE!"}},{"$f":"$N23*Q22","v":{"$error":"#VALUE!"}},{"$f":"$N23*R22","v":{"$error":"#VALUE!"}},{"$f":"$N23*S22","v":{"$error":"#VALUE!"}}]
[null,null,null,null,{"$f":"SUM(E14:E23)","v":0},null,null,null,null,4,null,null,null,null,"Asignación Óptima:  Coeficientes de asignación",{"$f":"P17","v":{"$error":"#DIV/0!"}},{"$f":"Q17","v":{"$error":"#DIV/0!"}},{"$f":"R17","v":{"$error":"#DIV/0!"}},{"$f":"S17","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B10=1,SUM(P28:S28)*SUM(P29:S29)/((L2*L2*F20)+SUM(P26:S26)),SUM(P28:S28)*SUM(P29:S29)/(10000*F20))","v":{"$error":"#VALUE!"}},"              Tamaño de la muestra",{"$f":"$N25*P24","v":{"$error":"#VALUE!"}},{"$f":"$N25*Q24","v":{"$error":"#VALUE!"}},{"$f":"$N25*R24","v":{"$error":"#VALUE!"}},{"$f":"$N25*S24","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ni*Si^2",{"$f":"H2*H1","v":300},{"$f":"I2*I1","v":594.28571428571331},{"$f":"J2*J1","v":110},{"$f":"K2*K1","v":153.00000000000026}]
[null,null,null,null,{"$f":"IF(OR(B10=2,B23<>1),1,0)","v":0},null,null,null,null,null,null,null,null,null,"Ni*Si",{"$f":"H2*SQRT(H1)","v":189.73665961010278},{"$f":"I2*SQRT(I1)","v":377.66198038533241},{"$f":"J2*SQRT(J1)","v":77.781745930520231},{"$f":"K2*SQRT(K1)","v":117.34564329364778}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ni*Si*raiz(Ci)",{"$f":"IF(H10>0,P27*SQRT(H10),0)","v":0},{"$f":"IF(I10>0,Q27*SQRT(I10),0)","v":0},{"$f":"IF(J10>0,R27*SQRT(J10),0)","v":0},{"$f":"IF(K10>0,S27*SQRT(K10),0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ni*Si/raiz(Ci)",{"$f":"IF(H10>0,P27/SQRT(H10),0)","v":0},{"$f":"IF(I10>0,Q27/SQRT(I10),0)","v":0},{"$f":"IF(J10>0,R27/SQRT(J10),0)","v":0},{"$f":"IF(K10>0,S27/SQRT(K10),0)","v":0}]
[]
[null,1]
[]
[]
[]
[]
[null,null,null,null,{"$f":"IF(B37=1,1.645,0)","v":1.645}]
[null,1,null,null,{"$f":"IF(B37=2,1.96,0)","v":0}]
[null,null,null,null,{"$f":"IF(B37=3,2,0)","v":0}]
[null,null,null,null,{"$f":"IF(B37=4,2.576,0)","v":0}]
[]
[null,null,null,null,{"$f":"SUM(E36:E39)","v":1.645}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Esta hoja sirve para muestras de hasta 1000 datos"]

{"sheet":"Muestreo Información Auxiliar","index":3,"n_rows":1010,"n_cols":15,"rows_kept":1010,"cut":false,"hidden":false,"merged":[]}
["© TC3. José Alberto Hermoso Gutiérrez",null,null,null,null,null,null,{"$f":"IF(OR(B7=\"\",B12=\"\",B22=\"\",B29=\"\"),1,0)","v":0},null,null,null,null,"pendiente=",{"$f":"SLOPE(G11:G1010,F11:F1010)","v":6.7764804003336107E-2}]
[null,null,{"$f":"IF(OR(B7=0,B12=0,B22=0,B29=0),\"COMPLETE EL FORMULARIO\",\"\")","v":""},null,null,null,{"$f":"IF(H2>0,\"Se necesita información auxiliar poblacional para la estimación\",IF(H9>0,\"Escriba sólo los datos solicitados\",\"\"))","v":""},{"$f":"IF(AND(B12=2,B22=1),1,0)","v":0},null,null,null,"Varianza residual=",{"$f":"SUM(I11:I1010)/(D15-1)","v":1.6329281442995791},{"$f":"STEYX(G11:G1010,F11:F1010)^2","v":1.865095913261051},{"$f":"VAR(J11:J1010)","v":209.79999999999927}]
[null,null,null,{"$f":"IF(OR(B7=1,B12>2,B22>1),1,0)","v":1},{"$f":"IF(B7=1,\"Tamaño de la población:\",\"\")","v":"Tamaño de la población:"},null,7000,{"$f":"IF(OR(AND(E3=\"\",G3<>\"\"),AND(E3<>\"\",G3=\"\")),1,0)","v":0},null,null,null,{"$f":"IF(B29=1,\"*Nivel de confianza 90% (z=1,645)\",IF(B29=2,\"*Nivel de confianza 95% (z=1,96)\",IF(B29=3,\"*Nivel de confianza 95% (z=2)\",IF(B29=4,\"*Nivel de confianza 99% (z=2,576)\",\"\"))))","v":"*Nivel de confianza 95% (z=2)"},"RAZÓN","REGRESIÓN","DIFERENCIA"]
[null,null,null,null,{"$f":"IF(B22=2,\"Media poblacional de la variable auxiliar X:\",\"\")","v":""},null,null,{"$f":"IF(OR(AND(E4=\"\",G4<>\"\"),AND(E4<>\"\",G4=\"\")),1,0)","v":0},null,null,null,{"$f":"IF(B12=1,\"Razón\",IF(B12=2,\"Media\",\"\"))","v":"Media"}]
[null,null,null,null,{"$f":"IF(B22=3,\"Total poblacional de la variable auxiliar X:\",\"\")","v":"Total poblacional de la variable auxiliar X:"},null,1000000,{"$f":"IF(OR(AND(E5=\"\",G5<>\"\"),AND(E5<>\"\",G5=\"\")),1,0)","v":0},null,null,{"$f":"SUM(G11:G1010)/SUM(F11:F1010)","v":9.9009900990099015E-2},"Estimación",{"$f":"IF(B22=2,K5*G4,IF(AND(B22=3,B7=1),K5*G5/G3,\"\"))","v":14.144271570014146},{"$f":"IF(B22=2,AVERAGE(G11:G1010)+(N1*(G4-AVERAGE(F11:F1010))),IF(AND(B22=3,B7=1),AVERAGE(G11:G1010)+(N1*((G5/G3)-AVERAGE(F11:F1010))),\"\"))","v":14.098743000119146},{"$f":"IF(B22=2,AVERAGE(G11:G1010)+G4-AVERAGE(F11:F1010),IF(AND(B22=3,B7=1),AVERAGE(G11:G1010)+(G5/G3)-AVERAGE(F11:F1010),\"\"))","v":15.457142857142856}]
[null,null,null,null,{"$f":"IF(B12=3,\"Cota del error de estimación para la razón:\",\"\")","v":""},null,null,{"$f":"IF(OR(AND(E6=\"\",G6<>\"\"),AND(E6<>\"\",G6=\"\")),1,0)","v":0},null,null,{"$f":"D12*M2/((D11^2)*D15)","v":1.5991265317125776E-5},"Varianza del estimador",{"$f":"IF(B22=2,G4*G4*K6,IF(AND(B22=3,B7=1),((G5/G3)^2)*K6,\"\"))","v":0.32635235341073016},{"$f":"$D$12*N2/COUNT($F$11:$F$1010)","v":0.37275274037888717},{"$f":"$D$12*O2/COUNT($F$11:$F$1010)","v":41.930028571428423}]
[null,1,null,null,{"$f":"IF(B12=4,\"Cota del error de estimación para la media:\",\"\")","v":""},null,null,{"$f":"IF(OR(AND(E7=\"\",G7<>\"\"),AND(E7<>\"\",G7=\"\",G8=\"\")),1,0)","v":0},null,null,{"$f":"$D$32*SQRT(K6)","v":7.9978160311739536E-3},"*Cota del error de estimación",{"$f":"IF(M6=\"\",\"\",$D$32*SQRT(M6))","v":1.142545147310565},{"$f":"$D$32*SQRT(N6)","v":1.2210695973266834},{"$f":"$D$32*SQRT(O6)","v":12.950680070394515}]
[null,null,null,null,{"$f":"IF(AND(B7=1,B12=4),\"y/o Cota del error de estimación para el total:\",\"\")","v":""},null,null,{"$f":"IF(OR(AND(E8=\"\",G8<>\"\"),AND(E8<>\"\",G8=\"\",G7=\"\")),1,0)","v":0},null,null,{"$f":"K5-K7","v":9.1012084958925057E-2},"*Intervalo de confianza (extremo inferior)",{"$f":"IF(M7=\"\",\"\",M5-M7)","v":13.00172642270358},{"$f":"IF(N5=\"\",\"\",N5-N7)","v":12.877673402792462},{"$f":"IF(O5=\"\",\"\",O5-O7)","v":2.5064627867483402}]
[null,null,null,null,{"$f":"IF(H15>0,\"Complete los datos de la muestra\",\"\")","v":""},null,null,{"$f":"SUM(H3:H8)","v":0},null,null,{"$f":"K5+K7","v":0.10700771702127297},"*Intervalo de confianza (extremo superior)",{"$f":"IF(M7=\"\",\"\",M5+M7)","v":15.286816717324712},{"$f":"IF(N5=\"\",\"\",N5+N7)","v":15.31981259744583},{"$f":"IF(O5=\"\",\"\",O5+O7)","v":28.407822927537371}]
[null,null,null,null,"Muestras de hasta 1000 datos","MUESTRA X","MUESTRA Y",{"$f":"H9+H15+H1+H2","v":0},"(y-rx)^2","d=y-x",null,"Total"]
[null,null,null,{"$f":"IF(G4<>\"\",G4,IF(AND(G5<>\"\",G3<>\"\"),G5/G3,AVERAGE(F11:F1010)))","v":142.85714285714286},"media X (Poblacional o muestral)",120,12,{"$f":"IF(OR(F11=\"\",G11=\"\"),1,0)","v":0},{"$f":"(G11-($K$5*F11))^2","v":1.4116263111459686E-2},{"$f":"IF(F11=\"\",\"\",G11-F11)","v":-108},null,"Estimación",{"$f":"IF($G$5<>\"\",K5*$G$5,IF(AND($G$4<>\"\",$B$7=1),K5*$G$4*$G$3,\"\"))","v":99009.90099009902},{"$f":"IF($B$7=1,$G$3*N5,\"\")","v":98691.201000834029},{"$f":"IF($B$7=1,$G$3*O5,\"\")","v":108199.99999999999}]
[null,2,null,{"$f":"IF(B7=2,1,IF(AND(B7=1,G3<>\"\",D15<>\"\"),(G3-D15)/G3,\"\"))","v":0.99928571428571433},"coef. Corrector ",152,14,{"$f":"IF(OR(F12=\"\",G12=\"\"),1,0)","v":0},{"$f":"(G12-($K$5*F12))^2","v":1.1014606411136183},{"$f":"IF(F12=\"\",\"\",G12-F12)","v":-138},null,"Varianza del estimador",{"$f":"IF($G$5<>\"\",K6*($G$5^2),IF(AND($G$4<>\"\",$B$7=1),K6*(($G$4*$G$3)^2),\"\"))","v":15991265.317125777},{"$f":"IF($B$7=1,$G$3*$G$3*N6,\"\")","v":18264884.27856547},{"$f":"IF($B$7=1,$G$3*$G$3*O6,\"\")","v":2054571399.9999926}]
[null,null,null,{"$f":"IF(B12=3,G6*D11,IF(AND(B12=4,G7<>\"\",G8=\"\"),G7,IF(AND(B12=4,G7=\"\",G8<>\"\",G3<>\"\"),G8/G3,IF(AND(B12=4,G7<>\"\",G8<>\"\",G3<>\"\"),MIN(G7,(G8/G3)),\"\"))))","v":""},"B mínimo para la media",140,16,{"$f":"IF(OR(F13=\"\",G13=\"\"),1,0)","v":0},4.5736692481129309,-124,null,"*Cota del error de estimación",{"$f":"IF(M12=\"\",\"\",$D$32*SQRT(M12))","v":7997.8160311739548},{"$f":"IF(N12=\"\",\"\",$D$32*SQRT(N12))","v":8547.4871812867841},{"$f":"IF(O12=\"\",\"\",$D$32*SQRT(O12))","v":90654.760492761605}]
[null,null,null,{"$f":"(D13/D32)^2","v":{"$error":"#VALUE!"}},"D para hallar n",135,13,{"$f":"IF(COUNT(F11:F1010)=COUNT(G11:G1010),0,1)","v":0},0.13420252916380837,-122,null,"*Intervalo de confianza (extremo inferior)",{"$f":"IF(M13=\"\",\"\",M11-M13)","v":91012.084958925072},{"$f":"IF(N13=\"\",\"\",N11-N13)","v":90143.713819547251},{"$f":"IF(O13=\"\",\"\",O11-O13)","v":17545.239507238381}]
[null,null,null,{"$f":"COUNT(F11:F1010)","v":5},"tamaño muestral",160,15,{"$f":"SUM(H11:H14)","v":0},0.70826389569650006,-145,null,"*Intervalo de confianza (extremo superior)",{"$f":"IF(M13=\"\",\"\",M11+M13)","v":107007.71702127297},{"$f":"IF(N13=\"\",\"\",N11+N13)","v":107238.68818212081},{"$f":"IF(O13=\"\",\"\",O11+O13)","v":198854.76049276159}]
[null,null,null,{"$f":"IF(AND(B7=2,B22<>3),1,0)","v":0},"est. total en pobl inf con total pobl de X",null,null,null,0,"",null,{"$f":"IF(B29=1,\"*Nivel de confianza 90% (z=1,645)\",IF(B29=2,\"*Nivel de confianza 95% (z=1,96)\",IF(B29=3,\"*Nivel de confianza 95% (z=2)\",IF(B29=4,\"*Nivel de confianza 99% (z=2,576)\",\"\"))))","v":"*Nivel de confianza 95% (z=2)"},"RAZÓN","REGRESIÓN","DIFERENCIA"]
[null,null,null,{"$f":"IF(AND(B7=2,B22=3),1,0)","v":0},null,null,null,null,0,"",{"$f":"IF(B7=1,G3*M2/((G3*D14)+M2),M2/D14)","v":{"$error":"#VALUE!"}},"Tamaño muestral para la cota de error",{"$f":"IF($B$7=1,$G$3*M2/(($G$3*$D$14)+M2),M2/$D$14)","v":{"$error":"#VALUE!"}},{"$f":"IF($B$7=1,$G$3*N2/(($G$3*$D$14)+N2),N2/$D$14)","v":{"$error":"#VALUE!"}},{"$f":"IF($B$7=1,$G$3*O2/(($G$3*$D$14)+O2),O2/$D$14)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,3,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,{"$f":"IF(B29=1,1.645,0)","v":0},null,null,null,null,0,""]
[null,null,null,{"$f":"IF(B29=2,1.96,0)","v":0},null,null,null,null,0,""]
[null,3,null,{"$f":"IF(B29=3,2,0)","v":2},null,null,null,null,0,""]
[null,null,null,{"$f":"IF(B29=4,2.576,0)","v":0},null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,{"$f":"SUM(D27:D30)","v":2},null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,{"$f":"(G76-($K$5*F76))^2","v":0},{"$f":"IF(F76=\"\",\"\",G76-F76)","v":""}]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,{"$f":"(G140-($K$5*F140))^2","v":0},{"$f":"IF(F140=\"\",\"\",G140-F140)","v":""}]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,{"$f":"(G204-($K$5*F204))^2","v":0},{"$f":"IF(F204=\"\",\"\",G204-F204)","v":""}]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,{"$f":"(G268-($K$5*F268))^2","v":0},{"$f":"IF(F268=\"\",\"\",G268-F268)","v":""}]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,{"$f":"(G332-($K$5*F332))^2","v":0},{"$f":"IF(F332=\"\",\"\",G332-F332)","v":""}]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,{"$f":"(G396-($K$5*F396))^2","v":0},{"$f":"IF(F396=\"\",\"\",G396-F396)","v":""}]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,{"$f":"(G460-($K$5*F460))^2","v":0},{"$f":"IF(F460=\"\",\"\",G460-F460)","v":""}]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,{"$f":"(G524-($K$5*F524))^2","v":0},{"$f":"IF(F524=\"\",\"\",G524-F524)","v":""}]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,{"$f":"(G588-($K$5*F588))^2","v":0},{"$f":"IF(F588=\"\",\"\",G588-F588)","v":""}]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,{"$f":"(G652-($K$5*F652))^2","v":0},{"$f":"IF(F652=\"\",\"\",G652-F652)","v":""}]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,{"$f":"(G716-($K$5*F716))^2","v":0},{"$f":"IF(F716=\"\",\"\",G716-F716)","v":""}]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,{"$f":"(G780-($K$5*F780))^2","v":0},{"$f":"IF(F780=\"\",\"\",G780-F780)","v":""}]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,{"$f":"(G844-($K$5*F844))^2","v":0},{"$f":"IF(F844=\"\",\"\",G844-F844)","v":""}]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,{"$f":"(G908-($K$5*F908))^2","v":0},{"$f":"IF(F908=\"\",\"\",G908-F908)","v":""}]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,{"$f":"(G972-($K$5*F972))^2","v":0},{"$f":"IF(F972=\"\",\"\",G972-F972)","v":""}]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,null,null,null,null,0,""]
[null,null,null,null,"Esta hoja sirve para muestras de hasta 1000 datos",null,null,null,0,""]

{"sheet":"Muestreo por Conglomerados","index":4,"n_rows":1008,"n_cols":12,"rows_kept":1008,"cut":false,"hidden":false,"merged":[[15,11,15,12],[16,11,16,12]]}
["© TC3. José Alberto Hermoso Gutiérrez"]
[null,null,{"$f":"IF(OR(B7=0,B14=0,B21=0),\"COMPLETE EL FORMULARIO\",\"\")","v":""},null,null,null,{"$f":"IF(H7>0,\"Escriba sólo los datos solicitados\",\"\")","v":""},{"$f":"IF(OR(B7=\"\",B14=\"\",B21=\"\"),1,0)","v":0},null,null,"Varianza residual=",{"$f":"SUM(I9:I1008)/(D15-1)","v":13889.073764258554}]
[null,null,null,{"$f":"IF(OR(B7=1,B11=TRUE,B14=2),1,0)","v":1},{"$f":"IF(B11,\"Tamaño de la población (M):\",\"\")","v":"Tamaño de la población (M):"},null,4000,{"$f":"IF(OR(AND(E3=\"\",G3<>\"\"),AND(E3<>\"\",G3=\"\")),1,0)","v":0},null,null,{"$f":"IF(B21=1,\"*Nivel de confianza 90% (z=1,645)\",IF(B21=2,\"*Nivel de confianza 95% (z=1,96)\",IF(B21=3,\"*Nivel de confianza 95% (z=2)\",IF(B21=4,\"*Nivel de confianza 99% (z=2,576)\",\"\"))))","v":"*Nivel de confianza 90% (z=1,645)"}]
[null,null,null,null,{"$f":"IF(B7=1,\"Número de conglomerados (N):\",\"\")","v":"Número de conglomerados (N):"},null,100,{"$f":"IF(OR(AND(E4=\"\",G4<>\"\"),AND(E4<>\"\",G4=\"\")),1,0)","v":0},null,null,"Media o proporción"]
[null,null,null,null,{"$f":"IF(B14=2,\"Cota del error de estimación para la media (ó p):\",\"\")","v":""},null,null,{"$f":"IF(OR(AND(E5=\"\",G5<>\"\"),AND(E5<>\"\",G5=\"\",G6=\"\")),1,0)","v":0},null,null,"Estimación",{"$f":"SUM(G9:G1008)/SUM(F9:F1008)","v":14.239543726235741}]
[null,null,null,null,{"$f":"IF(AND(OR(B7=1,B11),B14=2),\"y/o Cota del error de estimación para el total:\",\"\")","v":""},null,null,{"$f":"IF(OR(AND(E6=\"\",G6<>\"\"),AND(E6<>\"\",G6=\"\",G5=\"\")),1,0)","v":0},null,null,"Varianza del estimador",{"$f":"D10*L2/((D9^2)*D15)","v":1.3599718060836501}]
[null,1,null,null,{"$f":"IF(AND(C2=\"\",H13>0),\"Complete los datos de la muestra\",\"\")","v":""},"m","y",{"$f":"SUM(H3:H6)","v":0},null,null,"*Cota del error de estimación",{"$f":"IF(L6=\"\",\"\",$D$24*SQRT(L6))","v":1.9183632884721051}]
[null,null,null,null,"Muestras de hasta 1000 datos","TAMAÑO","TOTAL",{"$f":"H7+H13+H2","v":0},"(y-med(y)*m)^2",null,"*Intervalo de confianza (extremo inferior)",{"$f":"IF(L7=\"\",\"\",L5-L7)","v":12.321180437763637}]
[null,null,null,{"$f":"IF(AND(G4<>\"\",G3<>\"\"),G3/G4,AVERAGE(F9:F1008))","v":40},"media M (Poblacional o muestral)",35,523,{"$f":"IF(OR(F9=\"\",G9=\"\"),1,0)","v":0},{"$f":"(G9-($L$5*F9))^2","v":605.94595844959622},null,"*Intervalo de confianza (extremo superior)",{"$f":"IF(L7=\"\",\"\",L5+L7)","v":16.157907014707845}]
[null,null,null,{"$f":"IF(B7=2,1,IF(AND(B7=1,G4<>\"\",D15<>\"\"),(G4-D15)/G4,\"\"))","v":0.94},"coef. Corrector ",36,645,{"$f":"IF(OR(F10=\"\",G10=\"\"),1,0)","v":0},{"$f":"(G10-($L$5*F10))^2","v":17523.518122280202},{"$f":"IF(B7=1,\"M.A.S.\",\"\")","v":"M.A.S."},"Total",{"$f":"IF(G3<>\"\",\"M Conocido\",\"\")","v":"M Conocido"}]
[null,true,null,{"$f":"IF(AND(G5<>\"\",G6=\"\"),G5,IF(AND(G5=\"\",G6<>\"\",G3<>\"\"),G6/G3,IF(AND(G5=\"\",G6<>\"\",G3=\"\",G4<>\"\"),G6/(G4*D9),IF(AND(G5<>\"\",G6<>\"\",G3<>\"\"),MIN(G5,(G6/G3)),IF(AND(G5<>\"\",G6<>\"\",G3=\"\",G4<>\"\"),MIN(G5,(G6/(G4*D9))),0)))))","v":0},"B mínimo para la media (conglm)",42,723,null,15609.794575604683,{"$f":"IF(B7=1,G4*AVERAGE(G9:G1008),\"\")","v":62416.666666666664},"Estimación",{"$f":"IF(G3<>\"\",G3*L5,\"\")","v":56958.174904942964}]
[null,null,null,{"$f":"(D11*D9/D24)^2","v":0},"D para hallar n (conglomerados)",45,469,{"$f":"IF(COUNT(F9:F1008)=COUNT(G9:G1008),0,1)","v":0},29508.185516633177,{"$f":"IF(B7=1,G4*(G4-D15)*VAR(G9:G1008)/D15,\"\")","v":17347647.777777825},"Varianza del estimador",{"$f":"IF(G3<>\"\",G3*G3*L6,\"\")","v":21759548.897338402}]
[null,null,null,{"$f":"IF(AND(B7=1,G6<>\"\"),(G6/(D24*G4))^2,0)","v":0},"D para hallar n (total MAS)",50,665,{"$f":"SUM(H9:H12)","v":0},2206.8560337723502,{"$f":"IF(J12=\"\",\"\",$D$24*SQRT(J12))","v":6851.5084892205487},"*Cota del error de estimación",{"$f":"IF(L12=\"\",\"\",$D$24*SQRT(L12))","v":7673.4531538884203}]
[null,1,null,null,null,55,720,null,3991.0686145527625,{"$f":"IF(J13=\"\",\"\",J11-J13)","v":55565.158177446116},"*Intervalo de confianza (extremo inferior)",{"$f":"IF(L13=\"\",\"\",L11-L13)","v":49284.721751054545}]
[null,null,null,{"$f":"COUNT(F9:F1008)","v":6},"tamaño muestral",null,null,null,0,{"$f":"IF(J13=\"\",\"\",J11+J13)","v":69268.175155887206},"*Intervalo de confianza (extremo superior)",{"$f":"IF(L13=\"\",\"\",L11+L13)","v":64631.628058831382}]
[null,null,null,null,null,null,null,null,0,"M.A.S.",{"$f":"IF(B21=1,\"*Nivel de confianza 90% (z=1,645)\",IF(B21=2,\"*Nivel de confianza 95% (z=1,96)\",IF(B21=3,\"*Nivel de confianza 95% (z=2)\",IF(B21=4,\"*Nivel de confianza 99% (z=2,576)\",\"\"))))","v":"*Nivel de confianza 90% (z=1,645)"},"CONGLOMERADOS"]
[null,null,null,{"$f":"IF(AND(B11=FALSE,B7=2),1,0)","v":0},"No se puede estimar el total",null,null,null,0,{"$f":"IF(D13=0,\"\",G4*VAR(G9:G1008)/((G4*D13)+VAR(G9:G1008)))","v":""},"Tamaño muestral para la cota de error",{"$f":"IF(D12=0,\"\",IF($B$7=1,$G$4*L2/(($G$4*$D$12)+L2),L2/$D$12))","v":""}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"IF(B21=1,1.645,0)","v":1.645},null,null,null,null,0]
[null,null,null,{"$f":"IF(B21=2,1.96,0)","v":0},null,null,null,null,0]
[null,1,null,{"$f":"IF(B21=3,2,0)","v":0},null,null,null,null,0]
[null,null,null,{"$f":"IF(B21=4,2.576,0)","v":0},null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"SUM(D19:D22)","v":1.645},null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,{"$f":"(G74-($L$5*F74))^2","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,{"$f":"(G138-($L$5*F138))^2","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,{"$f":"(G202-($L$5*F202))^2","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,{"$f":"(G266-($L$5*F266))^2","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,{"$f":"(G330-($L$5*F330))^2","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,{"$f":"(G394-($L$5*F394))^2","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,{"$f":"(G458-($L$5*F458))^2","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,{"$f":"(G522-($L$5*F522))^2","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,{"$f":"(G586-($L$5*F586))^2","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,{"$f":"(G650-($L$5*F650))^2","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,{"$f":"(G714-($L$5*F714))^2","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,{"$f":"(G778-($L$5*F778))^2","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,{"$f":"(G842-($L$5*F842))^2","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,{"$f":"(G906-($L$5*F906))^2","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,{"$f":"(G970-($L$5*F970))^2","v":0}]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,0]
[null,null,null,null,"Esta hoja sirve para muestras de hasta 1000 datos",null,null,null,0]

{"sheet":"Estimacion Tamaño Población","index":5,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["© TC3. José Alberto Hermoso Gutiérrez"]
[null,null,{"$f":"IF(OR(B7=\"\",B17=\"\"),\"COMPLETE EL FORMULARIO\",\"\")","v":""},null,null,{"$f":"IF(G11>0,\"Escriba sólo los datos solicitados\",\"\")","v":""},{"$f":"IF(OR(B7=\"\",B17=\"\"),1,0)","v":0}]
[null,null,null,null,{"$f":"IF(OR(B7=1,B7=2),\"Tamaño de la primera muestra marcada (t):\",\"\")","v":""},null,{"$f":"IF(OR(AND(E3=\"\",F3<>\"\"),AND(E3<>\"\",F3=\"\")),1,0)","v":0},{"$f":"IF(B17=1,\"*Nivel de confianza 90% (z=1,645)\",IF(B17=2,\"*Nivel de confianza 95% (z=1,96)\",IF(B17=3,\"*Nivel de confianza 95% (z=2)\",IF(B17=4,\"*Nivel de confianza 99% (z=2,576)\",\"NIVEL DE CONFIANZA\"))))","v":"*Nivel de confianza 99% (z=2,576)"}]
[null,null,null,null,{"$f":"IF(OR(B7=1,B7=2),\"Tamaño de la segunda muestra (n):\",\"\")","v":""},null,0,"Tamaño de la población"]
[null,null,null,null,{"$f":"IF(OR(B7=1,B7=2),\"Elementos marcados en la segunda muestra (s):\",\"\")","v":""},null,0,"Estimación",{"$f":"IF(OR(B7=1,B7=2),F4*F3/F5,F6*I11)","v":90}]
[null,null,null,null,{"$f":"IF(OR(B7=3,B7=4),\"Area total (A):\",\"\")","v":"Area total (A):"},1000,0,"Varianza del estimador",{"$f":"IF(B7=1,F3*F3*F4*(F4-F5)/(F5^3),IF(B7=2,F3*F3*F4*(F4-F5)/((F5^2)*(F5+1)),F6*F6*I12))","v":179.99999999999997}]
[null,3,null,null,{"$f":"IF(OR(B7=4,B7=3),\"Area de cada cuadro (a):\",\"\")","v":"Area de cada cuadro (a):"},10,0,"*Cota del error de estimación",{"$f":"D20*SQRT(I6)","v":34.560666660236748}]
[null,null,null,null,{"$f":"IF(OR(B7=4,B7=3),\"Número de cuadros en la muestra (n):\",\"\")","v":"Número de cuadros en la muestra (n):"},50,0,"*Intervalo de confianza (extremo inferior)",{"$f":"I5-I7","v":55.439333339763252}]
[null,null,null,null,{"$f":"IF(B7=3,\"Total de elementos en la muestra (m):\",\"\")","v":"Total de elementos en la muestra (m):"},45,0,"*Intervalo de confianza (extremo superior)",{"$f":"I5+I7","v":124.56066666023675}]
[null,null,null,null,{"$f":"IF(B7=4,\"Cuadros no cargados en la muestra (y):\",\"\")","v":""},null,0,"Densidad de población"]
[null,null,null,null,null,null,{"$f":"SUM(G2:G10)","v":0},"Estimación",{"$f":"IF(B7=3,F9/(F8*F7),IF(B7=4,-LN(F10/F8)/F7,\"\"))","v":0.09}]
[null,null,null,null,null,null,null,"Varianza del estimador",{"$f":"IF(B7=3,I11/(F7*F8),IF(B7=4,(F8-F10)/(F7*F7*F8*F10),\"\"))","v":1.7999999999999998E-4}]
[null,null,null,null,null,null,null,"*Cota del error de estimación",{"$f":"D20*SQRT(I12)","v":3.4560666660236751E-2}]
[null,null,null,null,null,null,null,"*Intervalo de confianza (extremo inferior)",{"$f":"I11-I13","v":5.5439333339763246E-2}]
[null,null,null,{"$f":"IF(B17=1,1.645,0)","v":0},null,null,null,"*Intervalo de confianza (extremo superior)",{"$f":"I11+I13","v":0.12456066666023674}]
[null,null,null,{"$f":"IF(B17=2,1.96,0)","v":0}]
[null,4,null,{"$f":"IF(B17=3,2,0)","v":0}]
[null,null,null,{"$f":"IF(B17=4,2.576,0)","v":2.5760000000000001}]
[]
[null,null,null,{"$f":"SUM(D15:D18)","v":2.5760000000000001}]