{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instrucciones","Incertidumbre curva de calibrac","Incertidumbre medidas directas ","Hoja1","Incerdumbre con derivadas parci"],"not_rendered":{"charts":3,"images":1,"macros":1,"external_links":0,"defined_names":3,"comments":3,"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":"Instrucciones","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[[1,1,19,10]]}

{"sheet":"Incertidumbre curva de calibrac","index":1,"n_rows":72,"n_cols":17,"rows_kept":72,"cut":false,"hidden":false,"merged":[[71,0,71,4],[71,5,71,10],[71,11,71,15],[66,0,66,15],[68,0,68,1],[68,3,68,15],[69,0,69,1],[69,3,69,15],[0,13,0,15],[3,13,3,15],[2,13,2,15],[1,13,1,15],[0,3,3,12],[56,4,56,6],[56,7,56,8],[21,1,21,6],[21,8,21,14],[53,4,53,6],[53,7,53,8],[54,4,54,6],[54,7,54,8],[55,4,55,6],[55,7,55,8],[50,4,50,6],[50,7,50,8],[51,4,51,6],[51,7,51,8],[35,2,35,5],[43,4,43,6],[43,7,43,8],[40,9,40,14],[41,0,41,14],[52,4,52,6],[52,7,52,8],[44,4,44,6],[44,7,44,8],[45,4,45,6],[45,7,45,8],[47,0,47,15],[49,4,49,6],[49,7,49,8],[22,37,22,38],[23,2,23,3],[21,20,21,30],[22,18,22,19],[22,20,22,21],[22,27,22,28],[22,29,22,30],[22,8,23,14],[22,31,22,32],[22,33,22,34],[22,35,22,36],[23,4,23,6],[16,5,16,10],[17,5,17,10],[9,4,9,12],[11,0,11,15],[13,1,13,2],[13,5,13,10],[15,5,15,10],[8,4,8,12],[0,0,3,2],[5,4,5,12],[6,4,6,12],[7,4,7,12],[25,11,26,11],[25,12,26,12],[25,13,26,13],[33,8,33,9],[29,8,29,9],[30,8,30,9],[31,8,31,9],[32,8,32,9],[25,8,26,10],[27,8,27,9],[28,8,28,9],[38,8,38,9],[27,11,38,11],[27,12,38,12],[27,13,38,13],[37,8,37,9],[36,8,36,9],[35,8,35,9],[34,8,34,10]]}
[null,null,null,"ESTIMACIÓN DE LA INCERTIDUMBRE - CURVA DE CALIBRACIÓN",null,null,null,null,null,null,null,null,null,"Código: M-S-LC-F077"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Versión:  01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Fecha: 06/11/2018"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Página: 1 de 1"]
[]
[null,null,"MÉTODO"]
[null,null,"REFERENCIA"]
[null,null,"PROCEDIMIENTO TÉCNICO RELACIONADO"]
[null,null,"MATRIZ"]
[null,null,"DATA "]
[]
["DEFINICIÓN DE LAS FUENTES DE INCERTIDUMBRE"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E17=1,\"Ingrese el valor del volumen y temperatura =>\",\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E18=1,\"Ingrese el valor del volumen y temperatura =>\",\"\")","v":""}]
[]
[]
[]
[null,"DATA APORTADA ",null,null,null,null,null,null,"CUANTIFICACIÓN DE FUENTES"]
[null,null,null,null,null,null,null,null,"Se consideran significativas la variaciones aleatorias en y, su cuantificación se realiza mediante la siguiente ecuación:"]
[null,null,"Curva de calibración",null,"Muestra analizada"]
[null,null,"Concentración del patrón (x)","Señal promedio obtenida (y)","No. de ensayo","Señal obtenida (ym)","Concentración del analito ",null,null,null,null,null,null,null,null,null,13.97]
[null,null,null,null,1,null,null,null,"Estadística de la curva de calibración                          (modelo y = ax + b)",null,null,"Incertidumbre tipica  combinada\nuc(y) ","Factor de cobertura","Incertidumbre Expandida \nU",null,null,4.53]
[null,null,null,null,2,null,null,null,null,null,null,null,null,null,null,null,3.31]
[null,null,null,null,3,null,null,null,"Número de replicas de la curva (n)",null,{"$f":"D34*D35","v":0},{"$f":"SQRT(SUMSQ(K38,K39))","v":{"$error":"#DIV/0!"}},{"$f":"_xlfn.T.INV.2T(0.05,K28-2)","v":{"$error":"#NUM!"}},{"$f":"L28*M28","v":{"$error":"#DIV/0!"}},null,null,2.87]
[null,null,null,null,4,null,null,null,"R",null,{"$f":"CORREL(C26:C30,D26:D30)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,2.65]
[null,null,null,null,5,null,null,null,"b",null,{"$f":"INTERCEPT(D26:D33,C26:C33)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,2.52]
[null,null,null,null,6,null,null,null,"a",null,{"$f":"SLOPE(D26:D33,C26:C33)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,2.4300000000000002]
[null,null,null,null,7,null,null,null,"Desviación estandar de los residuales (S)",null,{"$f":"STEYX(D26:D33,C26:C33)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,2.37]
[null,null,null,null,8,null,null,null,"Promedio de concentración de los calibrantes, (x)",null,{"$f":"AVERAGE(C26:C33)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,2.3199999999999998]
[null,null,"Ingrese el número de replicas por punto",null,9,null,null,null,"Sxx",null,{"$f":"(SUMSQ(C26:C33))-(SUM(C26:C30)^2/K28)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,2.2799999999999998]
[null,null,"Numero de puntos de calibración",{"$f":"COUNT(D26:D33)","v":0},10,null,null,null,"Estadística del análisis de muestra                     ",null,null,null,null,null,null,null,2.25]
[null,null,"Factor de dilución",null,null,null,null,null,"Número de replicas de la muestra (p)",null,{"$f":"COUNT(F26:F35)","v":0},null,null,null,null,null,2.23]
[null,null,null,null,null,null,null,null,"Concentración de analito hallada por interpolacion, Xpred",null,{"$f":"(AVERAGE(F26:F35)-K30)/K31","v":{"$error":"#DIV/0!"}},null,null,null,null,null,2.21]
[null,null,null,null,null,null,null,null,"Incertidumbre típica de la curva ",null,{"$f":"K32/K31*SQRT((1/K36)+(1/K28)+((K37-K33)^2)/K34)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,2.2000000000000002]
[null,null,null,null,null,null,null,null,"Incertidumbre típica relativa a la repetibilidad",null,{"$f":"_xlfn.STDEV.S(G26:G35)/SQRT(K36)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,2.1800000000000002]
[]
[]
["EXPRESIÓN RESULTADO"]
[]
[null,null,null,null,{"$f":"+F16","v":0},null,null,{"$f":"G36*AVERAGE(G26:G35)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Incertidumbre expandida a 95,45 %",null,null,{"$f":"N28","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Grados de libertad",null,null,{"$f":"N40","v":0}]
[]
["CONTRIBUCIÓN DE FUENTES"]
[]
[null,null,null,null,"Componente de la incertidumbre tipica\nu(xi)",null,null,"Contribución\n%"]
[null,null,null,null,{"$f":"I38","v":"Incertidumbre típica de la curva "},null,null,{"$f":"K38*100/SUM(K38+K39)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,{"$f":"I39","v":"Incertidumbre típica relativa a la repetibilidad"},null,null,{"$f":"K39*100/SUM(K39+K38)","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["HISTORIAL DE CAMBIOS"]
[]
["VERSIÓN",null,"FECHA","DESCRIPCIÓN"]
["01",null,"2018-11-06","Creación del documento con base a la nueva estructura del SGI."]
[]
["ELABORÓ: \n\nElizabeth González Mateus\nContratista Laboratorio de Calidad Ambiental",null,null,null,null,"REVISÓ:\n\nCarlos Martín Velásquez Ramírez\nContratista Líder Técnico Grupo Laboratorio de Calidad Ambiental",null,null,null,null,null,"APROBÓ:\n\n    Nelson Omar Vargas Martínez\nSubdirector de Hidrología"]

{"sheet":"Incertidumbre medidas directas ","index":2,"n_rows":108,"n_cols":24,"rows_kept":108,"cut":false,"hidden":false,"merged":[[0,3,3,12],[102,0,102,17],[104,0,104,1],[104,3,104,17],[105,0,105,1],[105,3,105,17],[107,0,107,4],[107,5,107,10],[107,11,107,17],[63,7,65,8],[66,7,68,8],[69,7,71,8],[72,5,72,6],[73,5,73,6],[72,7,72,8],[73,7,73,8],[28,11,28,12],[63,3,65,3],[66,3,68,3],[56,7,56,8],[57,9,59,9],[45,2,45,3],[46,2,46,3],[57,3,59,3],[57,2,59,2],[55,1,55,14],[46,6,46,7],[56,2,56,4],[60,3,62,3],[45,10,45,12],[31,8,31,9],[32,8,32,9],[33,8,33,9],[34,8,34,9],[35,8,35,9],[36,8,36,9],[37,8,37,9],[57,7,59,8],[60,7,62,8],[69,3,71,3],[28,8,28,9],[29,8,29,9],[30,8,30,9],[40,8,40,9],[41,8,41,9],[42,8,42,9],[43,8,43,9],[45,6,45,8],[45,4,45,5],[38,8,38,9],[39,8,39,9],[54,0,54,14],[46,11,46,12],[47,11,47,12],[48,11,48,12],[49,11,49,12],[60,0,72,0],[12,17,12,18],[27,39,27,40],[27,20,27,21],[27,37,27,38],[22,5,22,10],[20,5,20,10],[21,5,21,10],[26,22,26,32],[16,11,16,12],[17,11,17,12],[18,11,18,12],[19,11,19,12],[20,11,20,12],[21,11,21,12],[26,0,26,16],[27,35,27,36],[27,31,27,32],[27,33,27,34],[27,29,27,30],[27,22,27,23],[22,11,22,12],[0,0,3,2],[13,1,13,2],[13,5,13,10],[15,5,15,10],[16,5,16,10],[17,5,17,10],[18,5,18,10],[19,5,19,10],[5,4,5,12],[6,4,6,12],[7,4,7,12],[8,4,8,12],[9,4,9,12],[11,0,11,15],[5,2,5,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[3,13,3,15],[2,13,2,15],[1,13,1,15],[0,13,0,15],[92,4,92,6],[90,7,90,8],[91,7,91,8],[92,7,92,8],[83,0,83,16],[85,4,85,6],[86,4,86,6],[87,4,87,6],[88,4,88,6],[89,4,89,6],[85,7,85,8],[86,7,86,8],[87,7,87,8],[88,7,88,8],[89,7,89,8],[90,4,90,6],[91,4,91,6],[72,2,72,4],[73,2,73,4],[57,0,59,0],[76,9,76,14],[81,4,81,6],[79,7,79,8],[80,7,80,8],[81,7,81,8],[66,2,68,2],[79,4,79,6],[80,4,80,6],[57,13,73,13],[60,9,62,9],[63,9,65,9],[66,9,68,9],[69,9,71,9],[74,9,75,11],[77,0,77,14],[57,10,73,10],[57,12,73,12],[60,2,62,2],[56,14,75,14],[63,2,65,2],[69,2,71,2]]}
[null,null,null,"ESTIMACIÓN DE LA INCERTIDUMBRE - MEDIDAS DIRECTAS",null,null,null,null,null,null,null,null,null,"Código: M-S-LC-F077"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Versión:  01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Fecha: 06/11/2018"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Página: 1 de 1"]
[]
[null,null,"MÉTODO"]
[null,null,"REFERENCIA"]
[null,null,"PROCEDIMIENTO TÉCNICO RELACIONADO"]
[null,null,"MATRIZ"]
[null,null,"DATA "]
[]
["DEFINICIÓN DE LAS FUENTES DE INCERTIDUMBRE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tabla G.2 GUM 2008"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,13.97]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,4.53]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N(E23)>0,\"VOLUMEN\",\"\")","v":""},{"$f":"IF(N(E23)>0,\"TEMPERATURA\",\"\")","v":""},null,null,3,3.31]
[null,null,null,null,{"$f":"SEARCH(\"VOLUMEN\",F17,1)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,{"$f":"IF(E17=1,\"Ingrese el valor del volumen y temperatura =>\",\"\")","v":{"$error":"#VALUE!"}},null,null,null,null,null,4,2.87]
[null,null,null,null,{"$f":"SEARCH(\"VOLUMEN\",F18,1)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,{"$f":"IF(E18=1,\"Ingrese el valor del volumen y temperatura =>\",\"\")","v":{"$error":"#VALUE!"}},null,null,null,null,null,5,2.65]
[null,null,null,null,{"$f":"SEARCH(\"VOLUMEN\",F19,1)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,{"$f":"IF(E19=1,\"Ingrese el valor del volumen y temperatura =>\",\"\")","v":{"$error":"#VALUE!"}},null,null,null,null,null,6,2.52]
[null,null,null,null,{"$f":"SEARCH(\"VOLUMEN\",F20,1)","v":{"$error":"#VALUE!"}},null,null,null,null,null,null,{"$error":"#VALUE!"},null,null,null,null,null,7,2.4300000000000002]
[null,null,null,null,{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,null,null,null,8,2.37]
[null,null,null,null,{"$error":"#VALUE!"},null,null,null,null,null,null,null,null,null,null,null,null,9,2.3199999999999998]
[null,null,"P",null,{"$f":"SUMIF(E17:E22,\">0\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,10,2.2799999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,2.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,2.23]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,2.21]
["DATA APORTADA ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,2.2000000000000002]
[null,null,null,null,null,null,null,null,{"$f":"IF(H32=\"NA\",\"NA\",(H32/I32))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,15,2.1800000000000002]
[null,null,"Equipos/Instrumentos","Rango","Tipo","Distribución","Fuentes de incertidumbre","Valor","Factor de cobertura, k",null,null,"Precisión del método"]
[null,null,null,null,"B","Normal","Tolerancia (MEP)",null,null,null,null,"No. de ensayo","Medida final"]
[null,null,null,null,"B","Rectangular","Resolución",null,null,null,null,1]
[null,null,null,null,"B","Normal","Incertidumbre asociada a la calibración",null,null,null,null,2]
[null,null,null,null,"B","Rectangular","Tolerancia (MEP)",null,null,null,null,3]
[null,null,null,null,"B","Rectangular","Resolución",null,null,null,null,4]
[null,null,null,null,"B","Normal","Incertidumbre asociada a la calibración",null,null,null,null,5]
[null,null,null,null,"B","Rectangular","Tolerancia (MEP)",null,null,null,null,6]
[null,null,null,null,"B","Rectangular","Resolución",null,null,null,null,7]
[null,null,null,null,"B","Normal","Incertidumbre asociada a la calibración",null,null,null,null,8]
[null,null,null,null,"B","Normal","Tolerancia (MEP)",null,null,null,null,9]
[null,null,null,null,"B","Rectangular","Resolución",null,null,null,null,10,null,null,null,null,null,"Columna1","Columna2","Columna3","Columna4","Columna5","Columna6","Columna7"]
[null,null,null,null,"B","Normal","Incertidumbre asociada a la calibración",null,null,null,null,"n",{"$f":"COUNT(M31:M40)","v":0}]
[null,null,null,null,"B","Normal","Tolerancia (MEP)",null,null,null,null,"Desviación estandar",{"$f":"_xlfn.STDEV.P(M31:M40)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"C31","v":0},"Tolerancia",{"$f":"IF(H30=\"NA\",\"NA\",IF(F30=\"Rectangular\",(H30/SQRT(3)),IF(F30=\"Triangular\",(H30/SQRT(6)),(H30/I30))))","v":{"$error":"#DIV/0!"}},"Resolusión",{"$f":"IF(H31=\"NA\",\"NA\",IF(G31=\"Rectangular\",(H31/SQRT(3)),(H31/SQRT(6))))","v":0},"Calibración",{"$f":"IF(H32=\"NA\",\"NA\",(H32/I32))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"B","Rectangular","Resolución",null,null,null,null,"Promedio",{"$f":"AVERAGE(M31:M40)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"C34","v":0},"Tolerancia",{"$f":"IF(H33=\"NA\",\"NA\",IF(F33=\"Rectangular\",(H33/SQRT(3)),IF(F33=\"Triangular\",(H33/SQRT(6)),(H33/I33))))","v":0},"Resolusión",{"$f":"IF(H34=\"NA\",\"NA\",IF(G34=\"Rectangular\",(H34/SQRT(3)),(H34/SQRT(6))))","v":0},"Calibración",{"$f":"IF(H35=\"NA\",\"NA\",(H35/I35))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"B","Normal","Incertidumbre asociada a la calibración",null,null,null,null,null,null,null,null,null,null,{"$f":"C37","v":0},"Tolerancia",{"$f":"IF(H36=\"NA\",\"NA\",IF(F36=\"Rectangular\",(H36/SQRT(3)),IF(F36=\"Triangular\",(H36/SQRT(6)),(H36/I36))))","v":0},"Resolusión",{"$f":"IF(H37=\"NA\",\"NA\",IF(G37=\"Rectangular\",(H37/SQRT(3)),(H37/SQRT(6))))","v":0},"Calibración",{"$f":"IF(H38=\"NA\",\"NA\",(H38/I38))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C40","v":0},"Tolerancia",{"$f":"IF(H39=\"NA\",\"NA\",IF(F39=\"Rectangular\",(H39/SQRT(3)),IF(F39=\"Triangular\",(H39/SQRT(6)),(H39/I39))))","v":{"$error":"#DIV/0!"}},"Resolusión",{"$f":"IF(H37=\"NA\",\"NA\",IF(G37=\"Rectangular\",(H37/SQRT(3)),(H37/SQRT(6))))","v":0},"Calibración",{"$f":"IF(H41=\"NA\",\"NA\",(H41/I41))","v":{"$error":"#DIV/0!"}}]
[null,null,"Patrón ",null,"Incertidumbre asociada",null,"Factor de cobertura, k",null,null,null," CORRECCIÓN POR TEMPERATURA",null,null,null,null,null,null,{"$f":"C43","v":0},"Tolerancia",{"$f":"IF(H42=\"NA\",\"NA\",IF(F42=\"Rectangular\",(H42/SQRT(3)),IF(F42=\"Triangular\",(H42/SQRT(6)),(H42/I42))))","v":{"$error":"#DIV/0!"}},"Resolusión",{"$f":"IF(H43=\"NA\",\"NA\",IF(G43=\"Rectangular\",(H43/SQRT(3)),(H43/SQRT(6))))","v":0},"Calibración",{"$f":"IF(H44=\"NA\",\"NA\",(H44/I44))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,{"$f":"IF(E47=\"\",\"0\",E47)","v":"0"},null,null,{"$f":"IF(N(G47<1.5),\"1\",G47)","v":"1"},null,"Corección  1",{"$f":"(N17*0.00021*ABS(20-O17))/SQRT(3)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Corección  2",{"$f":"(N18*0.00021*ABS(20-O18))/SQRT(3)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Corección  3",{"$f":"(N19*0.00021*ABS(20-O19))/SQRT(3)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Corección  4",{"$f":"(N20*0.00021*ABS(20-O20))/SQRT(3)","v":0}]
[]
[]
[]
[]
["CUANTIFICACIÓN DE FUENTES"]
[]
[null,null,"Componente de la incertidumbre tipica\nu(xi)",null,null,"Tipo","Contribución","Incertidumbre tipica \nu(xi)",null,"Coeficiente de sensibilidad \nci  ","Incertidumbre tipica  combinada\nuc(y) ","Grados de libertad \nνi","Grados de libertad efectivos\nνeff","Incertidumbre Expandida \nU"]
[null,null,{"$f":"F17","v":0},"SI",{"$f":"E59","v":"Bureta "},"Tolerancia (MEP)",{"$f":"VLOOKUP(E58,Tabla1[],3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D58=\"SI\",SQRT(SUMSQ(G58:G60,L47)),SQRT(SUMSQ(G58:G60)))","v":{"$error":"#N/A"}},null,1,{"$f":"SQRT(SUMSQ(H58*J58+H61*J61+H64*J64+H67/J67+H70*J70+H73*J73+H74*J74))","v":{"$error":"#N/A"}},"∞",{"$f":"K58^4/(H73^4/L73)","v":{"$error":"#N/A"}},{"$f":"K58*M76","v":{"$error":"#N/A"}}]
[null,null,null,null,"Bureta ","Resolución",{"$f":"VLOOKUP(E59,Tabla1[],5,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,"∞"]
[null,null,null,null,{"$f":"E59","v":"Bureta "},"Incertidumbre asociada a la calibración",{"$f":"VLOOKUP(E60,Tabla1[],7,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,"∞"]
[null,null,{"$f":"F18","v":0},"NO",{"$f":"E62","v":"Pipeta "},"Tolerancia (MEP)",{"$f":"VLOOKUP(E61,Tabla1[],3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D61=\"SI\",SQRT(SUMSQ(G61:G63,L48)),SQRT(SUMSQ(G61:G63)))","v":{"$error":"#N/A"}},null,1,null,"∞"]
[null,null,null,null,"Pipeta ","Resolución",{"$f":"VLOOKUP(E62,Tabla1[],5,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,"∞"]
[null,null,null,null,{"$f":"E62","v":"Pipeta "},"Incertidumbre asociada a la calibración",{"$f":"VLOOKUP(E63,Tabla1[],7,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,"∞"]
[null,null,{"$f":"F19","v":0},"SI",{"$f":"E65","v":"Bureta "},"Tolerancia (MEP)",{"$f":"VLOOKUP(E64,Tabla1[],3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D64=\"SI\",SQRT(SUMSQ(G64:G66,L49)),SQRT(SUMSQ(G64:G66)))","v":{"$error":"#N/A"}},null,1,null,"∞"]
[null,null,null,null,"Bureta ","Resolución",{"$f":"VLOOKUP(E65,Tabla1[],5,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,"∞"]
[null,null,null,null,{"$f":"E65","v":"Bureta "},"Incertidumbre asociada a la calibración",{"$f":"VLOOKUP(E66,Tabla1[],7,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,"∞"]
[null,null,{"$f":"F20","v":0},"¿Es un componente volumétrico?",{"$f":"E68","v":"NA"},"Tolerancia (MEP)",{"$f":"VLOOKUP(E67,Tabla1[],3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D67=\"SI\",SQRT(SUMSQ(G67:G69,L50)),SQRT(SUMSQ(G67:G69)))","v":{"$error":"#N/A"}},null,1,null,"∞"]
[null,null,null,null,"NA","Resolución",{"$f":"VLOOKUP(E68,Tabla1[],5,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,"∞"]
[null,null,null,null,{"$f":"E68","v":"NA"},"Incertidumbre asociada a la calibración",{"$f":"VLOOKUP(E69,Tabla1[],7,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,"∞"]
[null,null,{"$f":"F21","v":0},"¿Es un componente volumétrico?",{"$f":"E71","v":"Bureta "},"Tolerancia (MEP)",{"$f":"VLOOKUP(E70,Tabla1[],3,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(D70=\"SI\",SQRT(SUMSQ(G70:G72,N51)),SQRT(SUMSQ(G70:G72)))","v":{"$error":"#N/A"}},null,1,null,"∞"]
[null,null,null,null,"Bureta ","Resolución",{"$f":"VLOOKUP(E71,Tabla1[],5,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,"∞"]
[null,null,null,null,{"$f":"E71","v":"Bureta "},"Incertidumbre asociada a la calibración",{"$f":"VLOOKUP(E72,Tabla1[],7,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,"∞"]
[null,null,"Precisión relativa a la repetibilidad del método",null,null,{"$f":"M42","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(M42>0,F73/SQRT(M41),\"\")","v":{"$error":"#DIV/0!"}},null,1,null,{"$f":"M41-1","v":-1}]
[null,null,{"$f":"F23","v":0},null,null,{"$f":"F47/I47","v":0},null,{"$f":"F74","v":0},null,1,null,"∞"]
[null,null,null,null,null,null,null,null,null,"Factor de cobertura para:\n\ngrados de libertad con un nivel de confianza deseado del 95,45 % ",null,null,{"$f":"ROUND(M58,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+LOOKUP(M75,R14:R37,S14:S37)","v":{"$error":"#N/A"}}]
[]
["EXPRESIÓN RESULTADO"]
[]
[null,null,null,null,{"$f":"+F16","v":0},null,null,{"$f":"M43","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Incertidumbre expandida a 95,45 %",null,null,{"$f":"N58","v":{"$error":"#N/A"}}]
[null,null,null,null,"Grados de libertad",null,null,{"$f":"M75","v":{"$error":"#N/A"}}]
[]
["CONTRIBUCIÓN DE FUENTES"]
[]
[null,null,null,null,"Componente de la incertidumbre tipica\nu(xi)",null,null,"Contribución\n%"]
[null,null,null,null,{"$f":"C58","v":0},null,null,{"$f":"H58*J58*100/(SUM(H58*J58+H61*J61+H64*J64+H67*J67+H70*J70+H73*J73+H74*J74))","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"C61","v":0},null,null,{"$f":"H61*J61*100/(SUM(H58*J58+H61*J61+H64*J64+H67*J67+H70*J70+H73*J73+H74*J74))","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"C64","v":0},null,null,{"$f":"H64*J64*100/(SUM(H58*J58+H61*J61+H64*J64+H67*J67+H70*J70+H73*J73+H74*J74))","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"C67","v":0},null,null,{"$f":"H67*J67*100/(SUM(H58*J58+H61*J61+H64*J64+H67*J67+H70*J70+H73*J73+H74*J74))","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"C70","v":0},null,null,{"$f":"H70*J70*100/(SUM(H58*J58+H61*J61+H64*J64+H67*J67+H70*J70+H73*J73+H74*J74))","v":{"$error":"#N/A"}}]
[null,null,null,null,{"$f":"C73","v":"Precisión relativa a la repetibilidad del método"},null,null,{"$f":"SUM(H73*J73)*100/(SUM(H58*J58+H61*J61+H64*J64+H67*J67+H70*J70+H73*J73+H74*J74))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,{"$f":"C74","v":0},null,null,{"$f":"H1*J74*100/(SUM(H58*J58+H61*J61+H64*J64+H67*J67+H70*J70+H73*J73+H74*J74))","v":{"$error":"#N/A"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["HISTORIAL DE CAMBIOS"]
[]
["VERSIÓN",null,"FECHA","DESCRIPCIÓN"]
["01",null,"2018-11-06","Creación del documento con base a la nueva estructura del SGI."]
[]
["ELABORÓ: \n\nElizabeth González Mateus\nContratista Laboratorio de Calidad Ambiental",null,null,null,null,"REVISÓ:\n\nCarlos Martín Velásquez Ramírez\nContratista Líder Técnico Grupo Laboratorio de Calidad Ambiental",null,null,null,null,null,"APROBÓ:\n\n    Nelson Omar Vargas Martínez\nSubdirector de Hidrología"]

{"sheet":"Hoja1","index":3,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,"W1","W2","W5","W3","W4","W6"]
[null,"B2E",103.4,114.8,11.399999999999991,102.3,103.2,0.90000000000000568,10.499999999999986]
[null,"B2E",99.6,110.2,10.600000000000009,97.7,98.4,0.70000000000000284,9.9000000000000057]
[null,"B2E",101.5,114,12.5,99.4,100.4,1,11.5]
[null,"B2E",93.9,109,15.099999999999994,97.6,98.4,0.80000000000001137,14.299999999999983]
[null,"B2E",104.1,125.3,21.200000000000003,102.9,106.3,3.3999999999999915,17.800000000000011]
[null,"PROME",null,null,14.16,null,null,1.3600000000000023,12.799999999999997]
[null,"desv",null,null,4.2863737587849267,null,null,1.1458621208504916,3.2649655434629055]

{"sheet":"Incerdumbre con derivadas parci","index":4,"n_rows":110,"n_cols":29,"rows_kept":110,"cut":false,"hidden":false,"merged":[[109,11,109,17],[109,5,109,10],[109,0,109,4],[104,0,104,17],[106,3,106,17],[107,3,107,17],[106,0,106,1],[107,0,107,1],[75,11,76,12],[77,11,77,15],[78,0,78,15],[65,6,65,8],[68,6,68,8],[71,6,71,8],[66,15,66,17],[60,0,62,0],[60,3,62,3],[72,3,74,3],[66,9,68,9],[69,9,71,9],[72,9,74,9],[66,3,68,3],[69,3,71,3],[63,0,74,0],[63,3,65,3],[72,4,74,4],[62,6,62,8],[74,6,74,8],[93,4,93,8],[93,9,93,10],[92,9,92,10],[82,4,82,8],[82,9,82,10],[84,0,84,17],[91,7,91,8],[90,7,90,8],[27,23,27,28],[28,21,28,22],[28,23,28,24],[28,25,28,26],[28,27,28,28],[28,29,28,30],[28,31,28,32],[47,11,47,12],[28,33,28,34],[28,35,28,36],[46,11,46,13],[9,4,9,13],[11,0,11,16],[0,0,3,2],[5,4,5,13],[6,4,6,13],[7,4,7,13],[8,4,8,13],[0,13,0,15],[3,13,3,15],[2,13,2,15],[1,13,1,15],[0,3,3,12],[51,11,51,12],[18,4,18,10],[19,4,19,10],[20,4,20,10],[29,11,29,15],[47,5,47,6],[47,7,47,8],[27,0,27,17],[48,11,48,12],[49,11,49,12],[50,11,50,12],[12,18,12,19],[13,1,13,2],[21,4,21,10],[22,4,22,10],[17,4,17,10],[14,3,16,3],[12,7,12,11],[58,5,58,9],[86,7,86,8],[87,7,87,8],[88,7,88,8],[89,7,89,8],[81,4,81,8],[81,9,81,10],[80,4,80,8],[80,9,80,10],[72,10,74,10],[58,3,59,4],[60,4,62,4],[63,4,65,4],[66,4,68,4],[69,4,71,4],[56,0,56,15],[57,1,57,15],[60,13,74,13],[58,10,59,10],[60,9,62,9],[63,9,65,9],[63,10,65,10],[66,10,68,10],[69,10,71,10],[60,10,62,10],[60,11,74,11],[58,11,59,11],[58,12,59,12],[58,13,59,13],[58,14,59,14],[60,14,74,14]]}
[null,null,null,"ESTIMACIÓN DE LA INCERTIDUMBRE CON DERIVADAS PARCIALES",null,null,null,null,null,null,null,null,null,"Código: M-S-LC-F077"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Versión:  01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Fecha: 06/11/2018"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Página: 1 de 1"]
[]
[null,null,"MÉTODO"]
[null,null,"REFERENCIA"]
[null,null,"PROCEDIMIENTO TÉCNICO RELACIONADO"]
[null,null,"MATRIZ"]
[null,null,"DATA "]
[]
["DEFINICIÓN DE LAS FUENTES DE INCERTIDUMBRE"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tabla G.2 GUM 2008"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,13.97]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,4.53]
[null,null,null,null,null,null,null,null,null,null,null,"Valor promedio",null,null,"VOLUMEN","TEMPERATURA",null,null,3,3.31]
[null,null,null,null,null,null,null,null,null,null,null,null,"=>",null,null,null,null,null,4,2.87]
[null,null,null,null,null,null,null,null,null,null,null,null,"=>",null,null,null,null,null,5,2.65]
[null,null,null,null,null,null,null,null,null,null,null,null,"=>",null,null,null,null,null,6,2.52]
[null,null,null,null,null,null,null,null,null,null,null,null,"=>",null,null,null,null,null,7,2.4300000000000002]
[null,null,null,null,null,null,null,null,null,null,null,null,"=>",null,null,null,null,null,8,2.37]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,2.3199999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,2.2799999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,2.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,2.23]
["DATA APORTADA ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13,2.21]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14,2.2000000000000002]
[null,null,null,"Equipos/Instrumentos","Rango","Fuentes de incertidumbre","Tipo","Distribución","Valor","Factor de cobertura, k",null,"Precisión del método",null,null,null,null,null,null,15,2.1800000000000002]
[null,null,null,null,null,"Tolerancia (MEP)","B","Rectangular",null,null,null,"No. de ensayo",{"$f":"D19","v":0},{"$f":"D20","v":0},{"$f":"D21","v":0},{"$f":"D18","v":0},null,null,3000,2,null,null,{"$f":"D32","v":0},"Tolerancia",{"$f":"IF(I31=\"NA\",\"NA\",IF(H31=\"Rectangular\",(I31/SQRT(3)),IF(H31=\"Triangular\",I31/SQRT(6),(I31/J31))))","v":0},"Resolusión",{"$f":"IF(I32=\"NA\",\"NA\",IF(H32=\"Rectangular\",(I32/SQRT(3)),(I32/SQRT(6))))","v":0},"Incertidumbre asociada a la calibración",{"$f":"IF(I33=\"NA\",\"NA\",(I33/J33))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,"Resolución","B","Rectangular",null,null,null,1,null,null,null,null,null,null,null,null,null,null,{"$f":"D35","v":0},"Tolerancia",{"$f":"IF(I34=\"NA\",\"NA\",IF(H34=\"Rectangular\",(I34/SQRT(3)),IF(H34=\"Triangular\",I34/SQRT(6),(I34/J34))))","v":0},"Resolusión",{"$f":"IF(I35=\"NA\",\"NA\",IF(H35=\"Rectangular\",(I35/SQRT(3)),(I35/SQRT(6))))","v":0},"Incertidumbre asociada a la calibración",{"$f":"IF(I36=\"NA\",\"NA\",(I36/J36))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,"Incertidumbre asociada a la calibración","B","Normal",null,null,null,2,null,null,null,null,null,null,null,null,null,null,{"$f":"D38","v":0},"Tolerancia",{"$f":"IF(I37=\"NA\",\"NA\",IF(H37=\"Rectangular\",(I37/SQRT(3)),IF(H37=\"Triangular\",I37/SQRT(6),(I37/J37))))","v":{"$error":"#DIV/0!"}},"Resolusión",{"$f":"IF(I38=\"NA\",\"NA\",IF(H38=\"Rectangular\",(I38/SQRT(3)),(I38/SQRT(6))))","v":0},"Incertidumbre asociada a la calibración",{"$f":"IF(I39=\"NA\",\"NA\",(I39/J39))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,"Tolerancia (MEP)","B","Triangular",null,null,null,3,null,null,null,null,null,null,null,null,null,null,{"$f":"D41","v":0},"Tolerancia",{"$f":"IF(I40=\"NA\",\"NA\",IF(H40=\"Rectangular\",(I40/SQRT(3)),IF(H40=\"Triangular\",I40/SQRT(6),(I40/J40))))","v":0},"Resolusión",{"$f":"IF(I41=\"NA\",\"NA\",IF(H41=\"Rectangular\",(I41/SQRT(3)),(I41/SQRT(6))))","v":0},"Incertidumbre asociada a la calibración",{"$f":"IF(I42=\"NA\",\"NA\",(I42/J42))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,"Resolución","B","Triangular",null,null,null,4,null,null,null,null,null,null,null,null,null,null,{"$f":"D44","v":0},"Tolerancia",{"$f":"IF(I43=\"NA\",\"NA\",IF(H43=\"Rectangular\",(I43/SQRT(3)),IF(H43=\"Triangular\",I43/SQRT(6),(I43/J43))))","v":{"$error":"#DIV/0!"}},"Resolusión",{"$f":"IF(I44=\"NA\",\"NA\",IF(H44=\"Rectangular\",(I44/SQRT(3)),(I44/SQRT(6))))","v":0},"Incertidumbre asociada a la calibración",{"$f":"IF(I45=\"NA\",\"NA\",(I45/J45))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,"Incertidumbre asociada a la calibración","B","Normal",null,null,null,5,null,null,null,null,null,null,null,null,null,null,{"$f":"D46","v":"NA"}]
[null,null,null,null,null,"Tolerancia (MEP)","B","Normal",null,null,null,6]
[null,null,null,null,null,"Resolución","B","Rectangular",null,null,null,7]
[null,null,null,null,null,"Incertidumbre asociada a la calibración","B","Normal",null,null,null,8]
[null,null,null,null,null,"Tolerancia (MEP)","B","Triangular",null,null,null,9]
[null,null,null,null,null,"Resolución","B","Rectangular",null,null,null,10]
[null,null,null,null,null,"Incertidumbre asociada a la calibración","B","Normal",null,null,null,"n",{"$f":"COUNT(M32:M41)","v":0},{"$f":"COUNT(N32:N41)","v":0},{"$f":"COUNT(O32:O41)","v":0},{"$f":"COUNT(P32:P41)","v":0}]
[null,null,null,null,null,"Tolerancia (MEP)","B","Normal",null,null,null,"Desviación estandar",{"$f":"IF(COUNT(M32:M41)=0,\"\",_xlfn.STDEV.P(M32:M41))","v":""},"",{"$f":"IF(COUNT(O32:O41)=0,\"\",_xlfn.STDEV.P(O32:O41))","v":""},{"$f":"_xlfn.STDEV.P(P32:P41)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,"Resolución","B","Rectangular",null,null,null,"Promedio",{"$f":"IF(COUNT(M32:M41)=0,\"\",AVERAGE(M33:M41))","v":""},{"$f":"IF(COUNT(N32:N41)=0,\"\",AVERAGE(N33:N41))","v":""},{"$f":"IF(COUNT(O32:O41)=0,\"\",AVERAGE(O33:O41))","v":""},{"$f":"AVERAGE(P32:P41)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,"Incertidumbre asociada a la calibración","B","Normal"]
[null,null,null,"NA","NA"]
[null,null,null,null,null,null,null,null,null,null,null,"Corrección por temperatura"]
[null,null,null,null,"Material de referencia ","Incertidumbre asociada",null,"Factor de cobertura, k",null,null,null,"Corrección 1",null,{"$f":"(O19*0.00021*ABS(20-P19))/SQRT(3)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"IF(N(#REF!<1.5),\"1\",#REF!)","v":{"$error":"#REF!"}},null,null,"Corrección 2",null,{"$f":"(O20*0.00021*ABS(20-P20))/SQRT(3)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Corrección 3",null,{"$f":"(O21*0.00021*ABS(20-P21))/SQRT(3)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Corrección 4",null,{"$f":"(O22*0.00021*ABS(20-P22))/SQRT(3)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Corrección 5",null,{"$f":"(O23*0.00021*ABS(20-P23))/SQRT(3)","v":0}]
[]
[]
[]
[]
["CUANTIFICACIÓN DE FUENTES"]
[]
[null,null,null,"Componente de la incertidumbre tipica\nu(xi)",null,"Incertidumbre tipica\nu(xi)",null,null,null,null,"Derivada parcial","Incertidumbre tipica  combinada\nuc(y) ","Grados de libertad \nνi","Grados de libertad efectivos\nνeff","Incertidumbre Expandida U"]
[null,null,null,null,null,"Fuente / equipo","Tolerancia","Resolusión","Incertidumbre asociada a la calibración","Incertidumbre tipica\nu(xi)"]
[null,null,null,{"$f":"E19","v":0},"¿Es un componente volumétrico?","Bureta",{"$f":"VLOOKUP(F61,$W$30:$AC$36,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F61,$W$30:$AC$36,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F61,$W$31:$AC$36,7,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(E61=\"SI\",SQRT(SUMSQ(G61:I63,N48)),SQRT(SUMSQ(G61:I63)))","v":{"$error":"#N/A"}},{"$f":"IF(D61<>0,J61/L19,\"\")","v":""},{"$f":"SQRT(SUMSQ(K61:K75)) * P44","v":{"$error":"#DIV/0!"}},"∞",{"$f":"((L61)^4)/(IF(M63=\"∞\",\"0\",J61^4/M63)+IF(M66=\"∞\",\"0\",J64^4/M66)+IF(M69=\"∞\",\"0\",J67^4/M69)+IF(M72=\"∞\",\"0\",J70^4/M72)+IF(M75=\"∞\",\"0\",J73^4/M75))","v":{"$error":"#DIV/0!"}},{"$f":"L61*N77","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,"Balanza Analítica",{"$f":"VLOOKUP(F62,$W$30:$AC$36,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F62,$W$30:$AC$36,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F62,$W$31:$AC$36,7,FALSE)","v":{"$error":"#N/A"}},null,null,null,"∞"]
[null,null,null,null,null,"Repetibilidad 1",{"$f":"IF(F63=\"Material de referencia\",$F$49/$H$49,IF(F63=\"Repetibilidad 1\",$M$43/SQRT($M$42),IF(F63=\"Repetibilidad 2\",$N$43/SQRT($N$42),IF(F63=\"Repetibilidad 3\",$O$43/SQRT(O42),\"\"))))","v":{"$error":"#VALUE!"}},null,null,null,null,null,{"$f":"IF(F63=\"Material de referencia\",\"∞\",IF(F63=\"Repetibilidad 1\",$M$42-1,IF(F63=\"Repetibilidad 2\",N$42-1, IF(F63=\"Repetibilidad 3\",$O$42-1,\"∞\"))))","v":-1}]
[null,null,null,{"$f":"E20","v":0},"¿Es un componente volumétrico?","Bureta",{"$f":"VLOOKUP(F64,$W$30:$AC$36,3,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F64,$W$30:$AC$36,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F64,$W$31:$AC$36,7,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(E64=\"SI\",SQRT(SUMSQ(G64:I66,N51)),SQRT(SUMSQ(G64:I66)))","v":{"$error":"#N/A"}},{"$f":"IF(D64<>0,J64/L20,\"0\")","v":"0"},null,"∞"]
[null,null,null,null,null,"NA",0,0,0,null,null,null,"∞"]
[null,null,null,null,null,"Repetibilidad 2",{"$f":"IF(F66=\"Material de referencia\",$F$49/$H$49,IF(F66=\"Repetibilidad 1\",$M$43/SQRT($M$42),IF(F66=\"Repetibilidad 2\",$N$43/SQRT($N$42),IF(F66=\"Repetibilidad 3\",$O$43/SQRT(O42),\"\"))))","v":{"$error":"#VALUE!"}},null,null,null,null,null,{"$f":"IF(F66=\"Material de referencia\",\"∞\",IF(F66=\"Repetibilidad 1\",$M$42-1,IF(F66=\"Repetibilidad 2\",N$42-1, IF(F66=\"Repetibilidad 3\",$O$42-1,\"∞\"))))","v":-1}]
[null,null,null,{"$f":"E21","v":0},"¿Es un componente volumétrico?","Balon aforado",{"$error":"#N/A"},{"$f":"VLOOKUP(F67,$W$30:$AC$36,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F67,$W$31:$AC$36,7,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(E67=\"SI\",SQRT(SUMSQ(G67:I69,O55)),SQRT(SUMSQ(G67:I69)))","v":{"$error":"#N/A"}},{"$f":"IF(D67<>0,J67/L21,\"0\")","v":"0"},null,"∞"]
[null,null,null,null,null,"Pipeta 1,5",{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,null,"∞"]
[null,null,null,null,null,"Material de referencia",{"$f":"IF(F69=\"Material de referencia\",$F$49/$H$49,IF(F69=\"Repetibilidad 1\",$M$43/SQRT($M$42),IF(F69=\"Repetibilidad 2\",$N$43/SQRT($N$42),IF(F69=\"Repetibilidad 3\",$O$43/SQRT(O42),\"\"))))","v":{"$error":"#DIV/0!"}},null,null,null,null,null,{"$f":"IF(F69=\"Material de referencia\",\"∞\",IF(F69=\"Repetibilidad 1\",$M$42-1,IF(F69=\"Repetibilidad 2\",N$42-1, IF(F69=\"Repetibilidad 3\",$O$42-1,\"∞\"))))","v":"∞"}]
[null,null,null,{"$f":"E22","v":0},"¿Es un componente volumétrico?","Pipeta 2,5",{"$error":"#N/A"},{"$f":"VLOOKUP(F70,$W$30:$AC$36,5,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(F70,$W$31:$AC$36,7,FALSE)","v":{"$error":"#N/A"}},{"$f":"IF(E70=\"SI\",SQRT(SUMSQ(G70:I72,O58)),SQRT(SUMSQ(G70:I72)))","v":{"$error":"#N/A"}},{"$f":"IF(D70<>0,J70/L22,\"0\")","v":"0"},null,"∞"]
[null,null,null,null,null,"NA",0,0,0,null,null,null,"∞"]
[null,null,null,null,null,"NA",{"$f":"IF(F72=\"Material de referencia\",$F$49/$H$49,IF(F72=\"Repetibilidad 1\",$M$43/SQRT($M$42),IF(F72=\"Repetibilidad 2\",$N$43/SQRT($N$42),IF(F72=\"Repetibilidad 3\",$O$43/SQRT(O42),\"\"))))","v":""},null,null,null,null,null,{"$f":"IF(F72=\"Material de referencia\",\"∞\",IF(F72=\"Repetibilidad 1\",$M$42-1,IF(F72=\"Repetibilidad 2\",N$42-1, IF(F72=\"Repetibilidad 3\",$O$42-1,\"∞\"))))","v":"∞"}]
[null,null,null,{"$f":"E23","v":0},"¿Es un componente volumétrico?","NA",0,{"$f":"VLOOKUP(F73,$W$30:$AC$36,5,FALSE)","v":0},{"$f":"VLOOKUP(F73,$W$31:$AC$36,7,FALSE)","v":0},{"$f":"IF(E73=\"SI\",SQRT(SUMSQ(G73:I75,P61)),SQRT(SUMSQ(G73:I75)))","v":0},{"$f":"IF(D73<>0,J73/L23,\"0\")","v":"0"},null,"∞"]
[null,null,null,null,null,"NA",0,0,0,null,null,null,"∞"]
[null,null,null,null,null,"NA",{"$f":"IF(F75=\"Material de referencia\",$F$49/$H$49,IF(F75=\"Repetibilidad 1\",$M$43/SQRT($M$42),IF(F75=\"Repetibilidad 2\",$N$43/SQRT($N$42),IF(F75=\"Repetibilidad 3\",$O$43/SQRT(O42),\"\"))))","v":""},null,null,null,null,null,{"$f":"IF(F75=\"Material de referencia\",\"∞\",IF(F75=\"Repetibilidad 1\",$M$42-1,IF(F75=\"Repetibilidad 2\",N$42-1, IF(F75=\"Repetibilidad 3\",$O$42-1,\"∞\"))))","v":"∞"}]
[null,null,null,null,null,null,null,null,null,null,null,"Factor de cobertura para:\n\ngrados de libertad con un nivel de confianza deseado del 95,45 % ",null,{"$f":"N61","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+LOOKUP(N76,S14:S31,T14:T31)","v":{"$error":"#DIV/0!"}}]
[]
["EXPRESIÓN RESULTADO"]
[]
[null,null,null,null,{"$f":"+E18","v":0},null,null,null,null,{"$f":"P44","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Incertidumbre expandida a 95,45 %",null,null,null,null,{"$f":"O61","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Grados de libertad",null,null,null,null,{"$f":"N76","v":{"$error":"#DIV/0!"}}]
[]
["CONTRIBUCIÓN DE FUENTES"]
[]
[null,null,null,null,null,null,null,"Componente de la incertidumbre tipica\nu(xi)",null,"Contribución\n%"]
[null,null,null,null,null,null,null,{"$f":"D61","v":0},null,{"$f":"K61*100/(SUM($K$61+$K$64+$K$67+$K$70+$K$73))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,{"$f":"D64","v":0},null,{"$f":"K64*100/(SUM($K$61+$K$64+$K$67+$K$70+$K$73))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,{"$f":"D67","v":0},null,{"$f":"K67*100/(SUM($K$61+$K$64+$K$67+$K$70+$K$73))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,{"$f":"D70","v":0},null,{"$f":"K70*100/(SUM($K$61+$K$64+$K$67+$K$70+$K$73))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,{"$f":"D73","v":0},null,{"$f":"K73*100/(SUM($K$61+$K$64+$K$67+$K$70+$K$73))","v":{"$error":"#VALUE!"}}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["HISTORIAL DE CAMBIOS"]
[]
["VERSIÓN",null,"FECHA","DESCRIPCIÓN"]
["01",null,"2018-11-06","Creación del documento con base a la nueva estructura del SGI."]
[]
["ELABORÓ: \n\nElizabeth González Mateus\nContratista Laboratorio de Calidad Ambiental",null,null,null,null,"REVISÓ:\n\nCarlos Martín Velásquez Ramírez\nContratista Líder Técnico Grupo Laboratorio de Calidad Ambiental",null,null,null,null,null,"APROBÓ:\n\n    Nelson Omar Vargas Martínez\nSubdirector de Hidrología"]