{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Instrucciones","Incertidumbre curva de calibrac","Incertidumbre medidas directas ","Hoja1","Incerdumbre con derivadas parci","Hoja2"],"not_rendered":{"charts":3,"images":2,"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":73,"n_cols":19,"rows_kept":73,"cut":false,"hidden":false,"merged":[[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],[47,0,47,16],[49,4,49,6],[49,7,49,8],[22,39,22,40],[23,2,23,3],[21,22,21,32],[22,20,22,21],[22,22,22,23],[22,29,22,30],[22,31,22,32],[22,8,23,14],[22,33,22,34],[22,35,22,36],[22,37,22,38],[23,4,23,6],[23,17,23,18],[11,0,11,15],[13,1,13,2],[13,5,13,10],[15,5,15,10],[9,2,9,3],[25,8,26,10],[27,8,27,9],[28,8,28,9],[8,4,8,12],[0,0,3,2],[5,4,5,12],[6,4,6,12],[7,4,7,12],[5,2,5,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[0,3,3,12],[16,5,16,10],[17,5,17,10],[9,4,9,12],[33,8,33,9],[29,8,29,9],[30,8,30,9],[31,8,31,9],[32,8,32,9],[0,13,0,15],[1,13,1,15],[2,13,2,15],[3,13,3,15],[66,0,66,17],[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],[25,11,26,11],[25,12,26,12],[25,13,26,13],[67,1,67,18],[72,10,72,15],[68,0,68,1],[68,3,68,15],[69,0,69,1],[69,3,69,15],[72,0,72,4],[72,5,72,9],[70,3,70,15],[70,0,70,1],[71,3,71,15]]}
[null,null,null,"FORMATO\nESTIMACIÓN DE LA INCERTIDUMBRE - CURVA DE CALIBRACIÓN",null,null,null,null,null,null,null,null,null,"Código: SLC-F077"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Versión:  03"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Fecha: 17072025"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Página: 1 de 1"]
[]
[null,null,"MÉTODO",null,"Determinación de hidrocarburos totales"]
[null,null,"REFERENCIA",null,"NTC 3362"]
[null,null,"INSTRUCTIVO DE ENSAYO",null,"M-S-LC-XXXX"]
[null,null,"MATRIZ",null,"Agua"]
[null,null,"DATA ",null,"M-S-LC-F020, Folio 1, 2. "]
[]
["DEFINICIÓN DE LAS FUENTES DE INCERTIDUMBRE"]
[]
[null,null,null,null,null,"S=f(C,r)"]
[]
[null,null,null,"S",null,"Fósforo reactivo disuelto, mg/L"]
[null,null,null,"C",null,"Desviación asociada a la curva de calibración",null,null,null,null,null,{"$f":"IF(E17=1,\"Ingrese el valor del volumen y temperatura =>\",\"\")","v":""}]
[null,null,null,"r",null,"Repetibilidad del analista",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,null,null,null,null,null,null,null,null,null,null,"Tabla G.2 GUM 2008"]
[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,null,1,13.97]
[null,null,0.03,1.9619999999999999E-2,1,4.2318000000000001E-2,0.01,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,null,2,4.53]
[null,null,0.1,6.3265000000000016E-2,2,4.1036000000000003E-2,9.7000000000000003E-3,null,null,null,null,null,null,null,null,null,null,3,3.31]
[null,null,0.3,0.19443666666666667,3,4.1514000000000002E-2,9.4400000000000005E-3,null,"Número de replicas de la curva (n)",null,{"$f":"D34*D35","v":15},{"$f":"SQRT(SUMSQ(K38,K39))","v":9.395364161603341E-4},{"$f":"_xlfn.T.INV.2T(0.05,K28-2)","v":2.1603686564627926},{"$f":"L28*M28","v":2.0297450250781682E-3},null,null,null,4,2.87]
[null,null,0.5,0.32116666666666666,4,"0,0383,44",1.0500000000000001E-2,null,"R",null,{"$f":"CORREL(C26:C30,D26:D30)","v":0.99999207094962872},null,null,null,null,null,null,5,2.65]
[null,null,1,0.64522333333333337,5,4.0247999999999999E-2,1.03E-2,null,"b",null,{"$f":"INTERCEPT(D26:D33,C26:C33)","v":-3.3065393671335985E-4},null,null,null,null,null,null,6,2.52]
[null,null,null,null,6,3.8844999999999998E-2,9.6799999999999994E-3,null,"a",null,{"$f":"SLOPE(D26:D33,C26:C33)","v":0.64526680639908462},null,null,null,null,null,null,7,2.4300000000000002]
[null,null,null,null,7,4.0765000000000003E-2,9.6799999999999994E-3,null,"Desviación estandar de los residuales (S)",null,{"$f":"STEYX(D26:D33,C26:C33)","v":1.1548205679671802E-3},null,null,null,null,null,null,8,2.37]
[null,null,null,null,8,4.2542000000000003E-2,9.6799999999999994E-3,null,"Promedio de concentración de los calibrantes, (x)",null,{"$f":"AVERAGE(C26:C33)","v":0.38600000000000001},null,null,null,null,null,null,9,2.3199999999999998]
[null,null,"Ingrese el número de replicas por punto",3,9,4.0096E-2,9.6799999999999994E-3,null,"Sxx",null,{"$f":"(SUMSQ(C26:C33))-(SUM(C26:C30)^2/K28)","v":1.1025733333333334},null,null,null,null,null,null,10,2.2799999999999998]
[null,null,"Numero de puntos de calibración",{"$f":"COUNT(D26:D33)","v":5},10,4.1284000000000001E-2,9.6799999999999994E-3,null,"Estadística del análisis de muestra                     ",null,null,null,null,null,null,null,null,11,2.25]
[null,null,"Factor de dilución",null,null,null,1,null,"Número de replicas de la muestra (p)",null,{"$f":"COUNT(F26:F35)","v":9},null,null,null,null,null,null,12,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":6.3991425587238804E-2},null,null,null,null,null,null,13,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":9.3307524778666446E-4},null,null,null,null,null,null,14,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":1.09996632945101E-4},null,null,null,null,null,null,15,2.1800000000000002]
[]
[]
["EXPRESIÓN RESULTADO"]
[]
[null,null,null,null,{"$f":"+F16","v":"Fósforo reactivo disuelto, mg/L"},null,null,{"$f":"G36*AVERAGE(G26:G35)","v":9.833999999999999E-3}]
[null,null,null,null,"Incertidumbre expandida a 95,45 %",null,null,{"$f":"N28","v":2.0297450250781682E-3}]
[]
[]
["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":89.454549108549145}]
[null,null,null,null,{"$f":"I39","v":"Incertidumbre típica relativa a la repetibilidad"},null,null,{"$f":"K39*100/SUM(K39+K38)","v":10.545450891450839}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"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."]
["02",null,"2020-12-11","Nueva versión producto de la actualización de la documentación del Sistema Integrado de Gestión, por parte del funcionario Renzzo González."]
[null,3,"2025-07-17","Se actualiza el Formato de acuerdo con el memorando enviado por la OAP memorando 20251100097283 lineamientos para la actualización documental en el marco de la implementación del aplicativo suite visión. El código pasa de M-S-LC-F077 a SLC-F077."]
["ELABORÓ: \n\n\nElizabeth González Mateus\nContratista Laboratorio de Calidad Ambiental",null,null,null,null,"REVISÓ:\n\n\nCarlos Martín Velásquez Ramírez\nContratista Líder Técnico Grupo Laboratorio de Calidad Ambiental",null,null,null,null,"APROBÓ:\n\n\n  Claudia María Ávila Laverde\nCoordinadora Grupo Laboratorio  de Calidad Ambiental\n"]

{"sheet":"Incertidumbre medidas directas ","index":2,"n_rows":109,"n_cols":24,"rows_kept":109,"cut":false,"hidden":false,"merged":[[41,8,41,9],[42,8,42,9],[43,8,43,9],[106,0,106,1],[106,3,106,15],[54,0,54,14],[46,11,46,12],[47,11,47,12],[48,11,48,12],[49,11,49,12],[60,0,72,0],[69,9,71,9],[89,7,89,8],[90,4,90,6],[91,4,91,6],[69,3,71,3],[57,7,59,8],[60,7,62,8],[56,14,75,14],[63,2,65,2],[63,7,65,8],[66,7,68,8],[69,7,71,8],[72,5,72,6],[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],[45,10,45,12],[45,6,45,8],[45,4,45,5],[57,12,73,12],[60,2,62,2],[69,2,71,2],[73,5,73,6],[72,7,72,8],[73,7,73,8],[27,39,27,40],[27,20,27,21],[27,37,27,38],[27,35,27,36],[27,31,27,32],[27,33,27,34],[27,29,27,30],[27,22,27,23],[28,11,28,12],[40,8,40,9],[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],[22,11,22,12],[38,8,38,9],[39,8,39,9],[34,8,34,9],[35,8,35,9],[36,8,36,9],[37,8,37,9],[31,8,31,9],[32,8,32,9],[33,8,33,9],[28,8,28,9],[29,8,29,9],[30,8,30,9],[0,3,3,12],[0,13,0,15],[1,13,1,15],[2,13,2,15],[3,13,3,15],[12,17,12,18],[0,0,3,2],[22,5,22,10],[20,5,20,10],[21,5,21,10],[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],[102,0,102,17],[57,0,59,0],[66,2,68,2],[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],[63,3,65,3],[66,3,68,3],[60,3,62,3],[104,0,104,1],[105,0,105,1],[108,0,108,4],[108,5,108,9],[108,10,108,15],[104,3,104,15],[105,3,105,15],[72,2,72,4],[73,2,73,4],[76,9,76,14],[79,7,79,8],[80,7,80,8],[79,4,79,6],[80,4,80,6],[57,13,73,13],[60,9,62,9],[63,9,65,9],[66,9,68,9],[74,9,75,11],[77,0,77,14],[57,10,73,10],[107,3,107,15]]}
[null,null,null,"FORMATO\nESTIMACIÓN DE LA INCERTIDUMBRE - MEDIDAS DIRECTAS",null,null,null,null,null,null,null,null,null,"Código: SLC-F077"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Versión:  03"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Fecha: 17072025"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Página: 1 de 1"]
[]
[null,null,"MÉTODO",null,"Determinación de hidrocarburos totales"]
[null,null,"REFERENCIA",null,"NTC 3362"]
[null,null,"INSTRUCTIVO DE ENSAYO",null,"M-S-LC-XXXX"]
[null,null,"MATRIZ",null,"Agua"]
[null,null,"DATA ",null,"(Indicar el documento de donde se tomaron los datos)"]
[]
["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,"S=f(T)",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,"S",null,null,"pH",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,"T",null,{"$f":"SEARCH(\"VOLUMEN\",F17,1)","v":{"$error":"#VALUE!"}},"Temperatura",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!"}},"ga",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!"}},"vol",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},"Patron de referencia",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":5.0000000000000001E-3},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)","NA",2,null,null,"No. de ensayo","Medida final"]
[null,null,"Termómetro","0-100","B","Triangular","Resolución",0.1,"NA","NA",null,1,10]
[null,null,null,null,"B","Normal","Incertidumbre asociada a la calibración",0.01,2,2,null,2,10.199999999999999]
[null,null,null,null,"B","Rectangular","Tolerancia (MEP)","NA",2,"NA",null,3,11.2]
[null,null,"NA","NA","B","Rectangular","Resolución","NA","NA","NA",null,4,10.5]
[null,null,null,null,"B","Normal","Incertidumbre asociada a la calibración","NA",2,2.2000000000000002,null,5,9.4]
[null,null,null,null,"B","Rectangular","Tolerancia (MEP)","NA",2,"NA",null,6,10.6]
[null,null,"NA","NA","B","Rectangular","Resolución","NA","NA","NA",null,7,11.2]
[null,null,null,null,"B","Normal","Incertidumbre asociada a la calibración","NA",2.2000000000000002,2.1,null,8,10.199999999999999]
[null,null,null,null,"B","Normal","Tolerancia (MEP)","NA","NA","NA",null,9,9.5]
[null,null,"NA","NA","B","Rectangular","Resolución","NA","NA","NA",null,10,11,null,null,null,null,"Columna1","Columna2","Columna3","Columna4","Columna5","Columna6","Columna7"]
[null,null,null,null,"B","Normal","Incertidumbre asociada a la calibración","NA","NA",2,null,"n",{"$f":"COUNT(M31:M40)","v":10}]
[null,null,null,null,"B","Normal","Tolerancia (MEP)","NA","NA","NA",null,"Desviación estandar",{"$f":"_xlfn.STDEV.P(M31:M40)","v":0.61122827159744475},null,null,null,null,{"$f":"C31","v":"Termómetro"},"Tolerancia",{"$f":"IF(H30=\"NA\",\"NA\",IF(F30=\"Rectangular\",(H30/SQRT(3)),IF(F30=\"Triangular\",(H30/SQRT(6)),(H30/I30))))","v":"NA"},"Resolusión",{"$f":"IF(H31=\"NA\",\"NA\",IF(G31=\"Rectangular\",(H31/SQRT(3)),(H31/SQRT(6))))","v":4.0824829046386304E-2},"Calibración",{"$f":"IF(H32=\"NA\",\"NA\",(H32/I32))","v":5.0000000000000001E-3}]
[null,null,"NA","NA","B","Rectangular","Resolución","NA","NA","NA",null,"Promedio",{"$f":"AVERAGE(M31:M40)","v":10.379999999999999},null,null,null,null,{"$f":"C34","v":"NA"},"Tolerancia",{"$f":"IF(H33=\"NA\",\"NA\",IF(F33=\"Rectangular\",(H33/SQRT(3)),IF(F33=\"Triangular\",(H33/SQRT(6)),(H33/I33))))","v":"NA"},"Resolusión",{"$f":"IF(H34=\"NA\",\"NA\",IF(G34=\"Rectangular\",(H34/SQRT(3)),(H34/SQRT(6))))","v":"NA"},"Calibración",{"$f":"IF(H35=\"NA\",\"NA\",(H35/I35))","v":"NA"}]
[null,null,null,null,"B","Normal","Incertidumbre asociada a la calibración","NA","NA",2,null,null,null,null,null,null,null,{"$f":"C37","v":"NA"},"Tolerancia",{"$f":"IF(H36=\"NA\",\"NA\",IF(F36=\"Rectangular\",(H36/SQRT(3)),IF(F36=\"Triangular\",(H36/SQRT(6)),(H36/I36))))","v":"NA"},"Resolusión",{"$f":"IF(H37=\"NA\",\"NA\",IF(G37=\"Rectangular\",(H37/SQRT(3)),(H37/SQRT(6))))","v":"NA"},"Calibración",{"$f":"IF(H38=\"NA\",\"NA\",(H38/I38))","v":"NA"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C40","v":"NA"},"Tolerancia",{"$f":"IF(H39=\"NA\",\"NA\",IF(F39=\"Rectangular\",(H39/SQRT(3)),IF(F39=\"Triangular\",(H39/SQRT(6)),(H39/I39))))","v":"NA"},"Resolusión",{"$f":"IF(H37=\"NA\",\"NA\",IF(G37=\"Rectangular\",(H37/SQRT(3)),(H37/SQRT(6))))","v":"NA"},"Calibración",{"$f":"IF(H41=\"NA\",\"NA\",(H41/I41))","v":"NA"}]
[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":"NA"},"Tolerancia",{"$f":"IF(H42=\"NA\",\"NA\",IF(F42=\"Rectangular\",(H42/SQRT(3)),IF(F42=\"Triangular\",(H42/SQRT(6)),(H42/I42))))","v":"NA"},"Resolusión",{"$f":"IF(H43=\"NA\",\"NA\",IF(G43=\"Rectangular\",(H43/SQRT(3)),(H43/SQRT(6))))","v":"NA"},"Calibración",{"$f":"IF(H44=\"NA\",\"NA\",(H44/I44))","v":"NA"}]
[null,null,"BUFFER 10 ",null,5.0000000000000001E-4,{"$f":"IF(E47=\"\",\"0\",E47)","v":5.0000000000000001E-4},2,null,{"$f":"IF(N(G47<1.5),\"1\",G47)","v":2},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":"Temperatura"},"NO",{"$f":"E59","v":"Termómetro"},"Tolerancia (MEP)",{"$f":"VLOOKUP(E58,Tabla1[],3,FALSE)","v":"NA"},{"$f":"IF(D58=\"SI\",SQRT(SUMSQ(G58:G60,L47)),SQRT(SUMSQ(G58:G60)))","v":4.1129875597510225E-2},null,1,{"$f":"SQRT(SUMSQ(H58*J58+H61*J61+H64*J64+H67/J67+H70*J70+H73*J73+H74*J74))","v":0.23466722645110324},"∞",{"$f":"K58^4/(H73^4/L73)","v":19.554131702415699},{"$f":"K58*M76","v":0.5115745536634051}]
[null,null,null,null,"Termómetro","Resolución",{"$f":"VLOOKUP(E59,Tabla1[],5,FALSE)","v":4.0824829046386304E-2},null,null,null,null,"∞"]
[null,null,null,null,{"$f":"E59","v":"Termómetro"},"Incertidumbre asociada a la calibración",{"$f":"VLOOKUP(E60,Tabla1[],7,FALSE)","v":5.0000000000000001E-3},null,null,null,null,"∞"]
[null,null,{"$f":"F18","v":"ga"},"NO",{"$f":"E62","v":"NA"},"Tolerancia (MEP)",{"$f":"VLOOKUP(E61,Tabla1[],3,FALSE)","v":"NA"},{"$f":"IF(D61=\"SI\",SQRT(SUMSQ(G61:G63,L48)),SQRT(SUMSQ(G61:G63)))","v":0},null,1,null,"∞"]
[null,null,null,null,"NA","Resolución",{"$f":"VLOOKUP(E62,Tabla1[],5,FALSE)","v":"NA"},null,null,null,null,"∞"]
[null,null,null,null,{"$f":"E62","v":"NA"},"Incertidumbre asociada a la calibración",{"$f":"VLOOKUP(E63,Tabla1[],7,FALSE)","v":"NA"},null,null,null,null,"∞"]
[null,null,{"$f":"F19","v":"vol"},"NO",{"$f":"E65","v":"NA"},"Tolerancia (MEP)",{"$f":"VLOOKUP(E64,Tabla1[],3,FALSE)","v":"NA"},{"$f":"IF(D64=\"SI\",SQRT(SUMSQ(G64:G66,L49)),SQRT(SUMSQ(G64:G66)))","v":0},null,1,null,"∞"]
[null,null,null,null,"NA","Resolución",{"$f":"VLOOKUP(E65,Tabla1[],5,FALSE)","v":"NA"},null,null,null,null,"∞"]
[null,null,null,null,{"$f":"E65","v":"NA"},"Incertidumbre asociada a la calibración",{"$f":"VLOOKUP(E66,Tabla1[],7,FALSE)","v":"NA"},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":"NA"},{"$f":"IF(D67=\"SI\",SQRT(SUMSQ(G67:G69,L50)),SQRT(SUMSQ(G67:G69)))","v":0},null,1,null,"∞"]
[null,null,null,null,"NA","Resolución",{"$f":"VLOOKUP(E68,Tabla1[],5,FALSE)","v":"NA"},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":"NA"},null,null,null,null,"∞"]
[null,null,{"$f":"F21","v":0},"¿Es un componente volumétrico?",{"$f":"E71","v":"NA"},"Tolerancia (MEP)",{"$f":"VLOOKUP(E70,Tabla1[],3,FALSE)","v":"NA"},{"$f":"IF(D70=\"SI\",SQRT(SUMSQ(G70:G72,N51)),SQRT(SUMSQ(G70:G72)))","v":0},null,1,null,"∞"]
[null,null,null,null,"NA","Resolución",{"$f":"VLOOKUP(E71,Tabla1[],5,FALSE)","v":"NA"},null,null,null,null,"∞"]
[null,null,null,null,{"$f":"E71","v":"NA"},"Incertidumbre asociada a la calibración",{"$f":"VLOOKUP(E72,Tabla1[],7,FALSE)","v":"NA"},null,null,null,null,"∞"]
[null,null,"Precisión relativa a la repetibilidad del método",null,null,{"$f":"M42","v":0.61122827159744475},null,{"$f":"IF(M42>0,F73/SQRT(M41),\"\")","v":0.19328735085359303},null,1,null,{"$f":"M41-1","v":9}]
[null,null,{"$f":"F23","v":"Patron de referencia"},null,null,{"$f":"F47/I47","v":2.5000000000000001E-4},null,{"$f":"F74","v":2.5000000000000001E-4},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":20}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+LOOKUP(M75,R14:R37,S14:S37)","v":2.1800000000000002}]
[]
["EXPRESIÓN RESULTADO"]
[]
[null,null,null,null,{"$f":"+F16","v":"pH"},null,null,{"$f":"M43","v":10.379999999999999}]
[null,null,null,null,"Incertidumbre expandida a 95,45 %",null,null,{"$f":"N58","v":0.5115745536634051}]
[]
[]
["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":"Temperatura"},null,null,{"$f":"H58*J58*100/(SUM(H58*J58+H61*J61+H64*J64+H67*J67+H70*J70+H73*J73+H74*J74))","v":17.526893814497061}]
[null,null,null,null,{"$f":"C61","v":"ga"},null,null,{"$f":"H61*J61*100/(SUM(H58*J58+H61*J61+H64*J64+H67*J67+H70*J70+H73*J73+H74*J74))","v":0}]
[null,null,null,null,{"$f":"C64","v":"vol"},null,null,{"$f":"H64*J64*100/(SUM(H58*J58+H61*J61+H64*J64+H67*J67+H70*J70+H73*J73+H74*J74))","v":0}]
[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":0}]
[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":0}]
[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":82.366572348724461}]
[null,null,null,null,{"$f":"C74","v":"Patron de referencia"},null,null,{"$f":"H1*J74*100/(SUM(H58*J58+H61*J61+H64*J64+H67*J67+H70*J70+H73*J73+H74*J74))","v":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."]
["02",null,"2020-12-11","Nueva versión producto de la actualización de la documentación del Sistema Integrado de Gestión, por parte del funcionario Renzzo González."]
[null,3,"2025-07-17","Se actualiza el Formato de acuerdo con el memorando enviado por la OAP memorando 20251100097283 lineamientos para la actualización documental en el marco de la implementación del aplicativo suite visión. El código pasa de M-S-LC-F077 a SLC-F077."]
["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,"APROBÓ:\n\n    Claudia María Ávila Laverde\nCoordinadora Grupo Laboratorio  de Calidad Ambiental"]

{"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":111,"n_cols":30,"rows_kept":111,"cut":false,"hidden":false,"merged":[[109,3,109,15],[104,0,104,18],[106,3,106,18],[107,3,107,18],[69,15,71,18],[72,15,74,18],[69,10,71,10],[60,15,62,18],[63,15,65,18],[66,15,68,18],[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],[62,6,62,8],[60,9,62,9],[60,4,62,4],[28,36,28,37],[47,11,47,13],[81,4,81,8],[81,9,81,10],[80,4,80,8],[80,9,80,10],[72,10,74,10],[27,24,27,29],[28,22,28,23],[28,24,28,25],[28,26,28,27],[28,28,28,29],[63,9,65,9],[63,10,65,10],[66,10,68,10],[75,11,76,12],[77,11,77,16],[78,0,78,16],[65,6,65,8],[68,6,68,8],[71,6,71,8],[63,3,65,3],[72,4,74,4],[60,10,62,10],[28,32,28,33],[28,34,28,35],[9,2,9,3],[12,19,12,20],[13,1,13,2],[21,4,21,10],[22,4,22,10],[17,4,17,10],[14,3,16,3],[12,7,12,11],[18,4,18,10],[19,4,19,10],[20,4,20,10],[5,2,5,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[28,30,28,31],[58,12,59,12],[58,13,59,13],[7,4,7,13],[8,4,8,13],[110,0,110,5],[110,12,110,18],[110,6,110,11],[106,0,106,1],[107,0,107,1],[60,11,74,11],[60,14,74,14],[60,13,74,13],[93,4,93,8],[93,9,93,10],[92,9,92,10],[84,0,84,18],[91,7,91,8],[90,7,90,8],[87,7,87,8],[88,7,88,8],[89,7,89,8],[86,7,86,8],[74,6,74,8],[63,4,65,4],[108,0,108,1],[108,3,108,18],[66,4,68,4],[69,4,71,4],[0,15,0,18],[3,15,3,18],[2,15,2,18],[1,15,1,18],[0,3,3,14],[63,0,74,0],[58,3,59,4],[56,0,56,16],[57,1,57,16],[30,11,31,11],[30,12,30,15],[9,4,9,13],[11,0,11,17],[0,0,3,2],[5,4,5,13],[6,4,6,13],[29,11,29,16],[47,5,47,6],[47,7,47,8],[27,0,27,18],[58,14,59,14],[58,5,58,9],[58,10,59,10],[58,11,59,11]]}
[null,null,null,"FORMATO\nESTIMACIÓN DE LA INCERTIDUMBRE CON DERIVADAS PARCIALES",null,null,null,null,null,null,null,null,null,null,null,"Código: SLC-F077"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Versión:  03"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Fecha: 17/07/2025"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Página: 1 de 1"]
[]
[null,null,"MÉTODO",null,"DETERMINACIÓN DE DEMANDA BIOQUÍMICA DE OXÍGENO"]
[null,null,"REFERENCIA",null,"S.M. 5210B"]
[null,null,"INSTRUCTIVO DE ENSAYO",null,"M-S-LC-I025  INSTRUCTIVO DE ENSAYO DETERMINACIÓN DE DEMANDA BIOQUÍMICA"]
[null,null,"MATRIZ",null,"AGUA SUPERFICIAL- RESIDUAL."]
[null,null,"DATA ",null,"YSI-CÁLCULOS DE CONFIRMACIÓN O VALIDACIÓN DEL MÉTODO DBO5."]
[]
["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,null,"Tabla G.2 GUM 2008"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,13.97]
[null,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,null,2,4.53]
[null,null,null,"DBO5","DBO como mg O2/L",null,null,null,null,null,null,"Valor promedio",null,"VOLUMEN","TEMPERATURA",null,null,null,null,3,3.31]
[null,null,null,"B","Volumen utilizado para la muestra, mL",null,null,null,null,null,null,{"$f":"M45","v":3.5605714285714285},"==>",3.125,23,null,null,null,null,4,2.87]
[null,null,null,"A","Volumen utillizado para el blanco, mL",null,null,null,null,null,null,{"$f":"N45","v":3.7674285714285713},"==>",3.5,23,null,null,null,null,5,2.65]
[null,null,null,"N","Normalidad",null,null,null,null,null,null,{"$f":"O45","v":3.9766666666666665E-2},"==>",null,null,null,null,null,null,6,2.52]
[null,null,null,"V","Volumen de muestra, mL",null,null,null,null,null,null,{"$f":"P45","v":2.5},"==>",2.5,23,null,null,null,null,7,2.4300000000000002]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"#REF!","v":{"$error":"#REF!"}},"==>",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,null,9,2.3199999999999998]
[null,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,null,11,2.25]
[null,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,null,13,2.21]
[null,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,null,15,2.1800000000000002]
[null,null,null,null,null,"Tolerancia (MEP)","B","Rectangular","NA","NA",null,"No. de ensayo","Variables de la formula",null,null,null,"Resultado final",null,null,3000,2,null,null,{"$f":"D32","v":"Bureta"},"Tolerancia",{"$f":"IF(I31=\"NA\",\"NA\",IF(H31=\"Rectangular\",(I31/SQRT(3)),IF(H31=\"Triangular\",I31/SQRT(6),(I31/J31))))","v":"NA"},"Resolusión",{"$f":"IF(I32=\"NA\",\"NA\",IF(H32=\"Rectangular\",(I32/SQRT(3)),(I32/SQRT(6))))","v":1.1547005383792516E-2},"Incertidumbre asociada a la calibración",{"$f":"IF(I33=\"NA\",\"NA\",(I33/J33))","v":2.8899082568807338E-3}]
[null,null,null,"Bureta","2-20","Resolución","B","Rectangular",0.02,"NA",null,null,{"$f":"D19","v":"B"},{"$f":"D20","v":"A"},{"$f":"D21","v":"N"},{"$f":"D22","v":"V"},{"$f":"D18","v":"DBO5"},null,null,null,null,null,null,{"$f":"D35","v":"Balanza Analítica"},"Tolerancia",{"$f":"IF(I34=\"NA\",\"NA\",IF(H34=\"Rectangular\",(I34/SQRT(3)),IF(H34=\"Triangular\",I34/SQRT(6),(I34/J34))))","v":"NA"},"Resolusión",{"$f":"IF(I35=\"NA\",\"NA\",IF(H35=\"Rectangular\",(I35/SQRT(3)),(I35/SQRT(6))))","v":5.7735026918962585E-5},"Incertidumbre asociada a la calibración",{"$f":"IF(I36=\"NA\",\"NA\",(I36/J36))","v":1E-4}]
[null,null,null,null,null,"Incertidumbre asociada a la calibración","B","Normal",6.3E-3,2.1800000000000002,null,1,3.5659999999999998,3.7040000000000002,0.04,2.5,20,null,null,null,null,null,null,{"$f":"D38","v":"Pipeta 2,5"},"Tolerancia",{"$f":"IF(I37=\"NA\",\"NA\",IF(H37=\"Rectangular\",(I37/SQRT(3)),IF(H37=\"Triangular\",I37/SQRT(6),(I37/J37))))","v":4.0824829046386306E-3},"Resolusión",{"$f":"IF(I38=\"NA\",\"NA\",IF(H38=\"Rectangular\",(I38/SQRT(3)),(I38/SQRT(6))))","v":"NA"},"Incertidumbre asociada a la calibración",{"$f":"IF(I39=\"NA\",\"NA\",(I39/J39))","v":"NA"}]
[null,null,null,null,null,"Tolerancia (MEP)","B","Triangular","NA","NA",null,2,3.5760000000000001,3.726,null,2.5,18,null,null,null,null,null,null,{"$f":"D41","v":"Balon aforado"},"Tolerancia",{"$f":"IF(I40=\"NA\",\"NA\",IF(H40=\"Rectangular\",(I40/SQRT(3)),IF(H40=\"Triangular\",I40/SQRT(6),(I40/J40))))","v":4.0824829046386306E-3},"Resolusión",{"$f":"IF(I41=\"NA\",\"NA\",IF(H41=\"Rectangular\",(I41/SQRT(3)),(I41/SQRT(6))))","v":"NA"},"Incertidumbre asociada a la calibración",{"$f":"IF(I42=\"NA\",\"NA\",(I42/J42))","v":"NA"}]
[null,null,null,"Balanza Analítica","0,001 - 210 g","Resolución","B","Rectangular",1E-4,"NA",null,3,3.5579999999999998,3.8380000000000001,null,2.5,22,null,null,null,null,null,null,{"$f":"D44","v":"Pipeta 1,5"},"Tolerancia",{"$f":"IF(I43=\"NA\",\"NA\",IF(H43=\"Rectangular\",(I43/SQRT(3)),IF(H43=\"Triangular\",I43/SQRT(6),(I43/J43))))","v":"NA"},"Resolusión",{"$f":"IF(I44=\"NA\",\"NA\",IF(H44=\"Rectangular\",(I44/SQRT(3)),(I44/SQRT(6))))","v":"NA"},"Incertidumbre asociada a la calibración",{"$f":"IF(I45=\"NA\",\"NA\",(I45/J45))","v":7.5000000000000002E-4}]
[null,null,null,null,null,"Incertidumbre asociada a la calibración","B","Normal",2.0000000000000001E-4,2,null,4,3.5779999999999998,3.782,3.95E-2,2.5,20,null,null,null,null,null,null,{"$f":"D46","v":"NA"}]
[null,null,null,null,null,"Tolerancia (MEP)","B","Triangular",0.01,"NA",null,5,3.61,3.8,null,2.5,21]
[null,null,null,"Pipeta 2,5",2.5,"Resolución","B","Rectangular","NA","NA",null,6,3.6040000000000001,3.806,3.9399999999999998E-2,2.5,22]
[null,null,null,null,null,"Incertidumbre asociada a la calibración","B","Normal","NA",2,null,7,3.5059999999999998,3.7,null,2.5,20]
[null,null,null,null,null,"Tolerancia (MEP)","B","Triangular",0.01,"NA",null,8,3.492,3.72,4.0399999999999998E-2,2.5,22]
[null,null,null,"Balon aforado",1000,"Resolución","B","Rectangular","NA","NA",null,9]
[null,null,null,null,null,"Incertidumbre asociada a la calibración","B","Normal","NA",2,null,10]
[null,null,null,null,null,"Tolerancia (MEP)","B","Normal","NA",{"$f":"IF(H43=\"Normal\",\"2\",IF(H43=\"Rectangular\",SQRT(3),SQRT(6)))","v":"2"},null,"n",{"$f":"COUNT(M33:M42)","v":8},{"$f":"COUNT(N33:N42)","v":8},{"$f":"COUNT(O33:O42)","v":4},{"$f":"COUNT(P33:P42)","v":8},{"$f":"COUNT(Q33:Q42)","v":8}]
[null,null,null,"Pipeta 1,5",1.5,"Resolución","B","Rectangular","NA","NA",null,"Desviación estandar",{"$f":"IF(COUNT(M33:M42)=0,\"\",_xlfn.STDEV.P(M33:M42))","v":3.9660276095861993E-2},4.971669739634757E-2,{"$f":"IF(COUNT(O33:O42)=0,\"\",_xlfn.STDEV.P(O33:O42))","v":4.0233692348577715E-4},0,{"$f":"_xlfn.STDEV.P(Q33:Q42)","v":1.3169567191065923}]
[null,null,null,null,null,"Incertidumbre asociada a la calibración","B","Normal",1.5E-3,2,null,"Promedio",{"$f":"IF(COUNT(M33:M42)=0,\"\",AVERAGE(M34:M42))","v":3.5605714285714285},{"$f":"IF(COUNT(N33:N42)=0,\"\",AVERAGE(N34:N42))","v":3.7674285714285713},{"$f":"IF(COUNT(O33:O42)=0,\"\",AVERAGE(O34:O42))","v":3.9766666666666665E-2},{"$f":"IF(COUNT(P33:P42)=0,\"\",AVERAGE(P34:P42))","v":2.5},{"$f":"AVERAGE(Q33:Q42)","v":20.625}]
[null,null,null,"NA","NA"]
[]
[null,null,null,null,"Material de referencia ","Incertidumbre asociada",null,"Factor de cobertura, k",null,null,null,"Corrección de volumen por temperatura"]
[null,null,null,null,"Material de referencia ",5.0000000000000001E-4,{"$f":"IF(F49=\"\",\"0\",F49)","v":5.0000000000000001E-4},{"$f":"SQRT(3)","v":1.7320508075688772},{"$f":"IF(N(#REF!<1.5),\"1\",#REF!)","v":{"$error":"#REF!"}},null,null,"Corrección 1",null,{"$f":"(N19*0.00021*ABS(20-O19))/SQRT(3)","v":1.1366583424670758E-3}]
[null,null,null,null,null,null,null,null,null,null,null,"Corrección 2",null,{"$f":"(N20*0.00021*ABS(20-O20))/SQRT(3)","v":1.2730573435631247E-3}]
[null,null,null,null,null,null,null,null,null,null,null,"Corrección 3",null,{"$f":"(N21*0.00021*ABS(20-O21))/SQRT(3)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Corrección 4",null,{"$f":"(N22*0.00021*ABS(20-O22))/SQRT(3)","v":9.0932667397366075E-4}]
[null,null,null,null,null,null,null,null,null,null,null,"Corrección 5",null,{"$f":"(N23*0.00021*ABS(20-O23))/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":"Volumen utilizado para la muestra, mL"},"SI","Bureta",{"$f":"VLOOKUP(F61,$X$30:$AD$36,3,FALSE)","v":"NA"},{"$f":"VLOOKUP(F61,$X$30:$AD$36,5,FALSE)","v":1.1547005383792516E-2},{"$f":"VLOOKUP(F61,$X$31:$AD$36,7,FALSE)","v":2.8899082568807338E-3},{"$f":"IF(E61=\"SI\",SQRT(SUMSQ(G61:I63,N49)),SQRT(SUMSQ(G61:I63)))","v":1.8428078650635858E-2},{"$f":"IF(D61<>0,J61/L19,\"\")","v":5.1755958335119165E-3},{"$f":"SQRT(SUMSQ(K61:K75)) * Q45","v":2.1269504446607361},"∞",{"$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":446951922.09708899},{"$f":"L61*N77","v":4.2539008893214723},{"$f":"IF(J61=\"NA\",\"Se realiza estimación de incertidumbre de la estandarización de forma independiente\",\"\")","v":""}]
[null,null,null,null,null,"NA",{"$f":"VLOOKUP(F62,$X$30:$AD$36,3,FALSE)","v":0},{"$f":"VLOOKUP(F62,$X$30:$AD$36,5,FALSE)","v":0},{"$f":"VLOOKUP(F62,$X$31:$AD$36,7,FALSE)","v":0},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$44/SQRT($M$43),IF(F63=\"Repetibilidad 2\",$N$44/SQRT($N$43),IF(F63=\"Repetibilidad 3\",$O$44/SQRT(O43),IF(F63=\"Repetibilidad 4\",$P$44/SQRT($P$43),\"\")))))","v":1.4022025085557372E-2},null,null,null,null,null,{"$f":"IF(F63=\"Material de referencia\",\"∞\",IF(F63=\"Repetibilidad 1\",$M$43-1,IF(F63=\"Repetibilidad 2\",N$43-1, IF(F63=\"Repetibilidad 3\",$O$43-1,\"∞\"))))","v":7}]
[null,null,null,{"$f":"E20","v":"Volumen utillizado para el blanco, mL"},"SI","Bureta",{"$f":"VLOOKUP(F64,$X$30:$AD$36,3,FALSE)","v":"NA"},{"$f":"VLOOKUP(F64,$X$30:$AD$36,5,FALSE)","v":1.1547005383792516E-2},{"$f":"VLOOKUP(F64,$X$31:$AD$36,7,FALSE)","v":2.8899082568807338E-3},{"$f":"IF(E64=\"SI\",SQRT(SUMSQ(G64:I66,N50)),SQRT(SUMSQ(G64:I66)))","v":2.1266742300280028E-2},{"$f":"IF(D64<>0,J64/L20,\"0\")","v":5.6448959541164946E-3},null,"∞",null,null,{"$f":"IF(J64=\"NA\",\"Se realiza estimación de incertidumbre de la estandarización de forma independiente\",\"\")","v":""}]
[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$44/SQRT($M$43),IF(F66=\"Repetibilidad 2\",$N$44/SQRT($N$43),IF(F66=\"Repetibilidad 3\",$O$44/SQRT(O43),IF(F66=\"Repetibilidad 4\",$P$44/SQRT($P$43),\"\")))))","v":1.7577506933578468E-2},null,null,null,null,null,{"$f":"IF(F66=\"Material de referencia\",\"∞\",IF(F66=\"Repetibilidad 1\",$M$43-1,IF(F66=\"Repetibilidad 2\",N$43-1, IF(F66=\"Repetibilidad 3\",$O$43-1,\"∞\"))))","v":7}]
[null,null,null,{"$f":"E21","v":"Normalidad"},"NO","Balon aforado",4.0824829046386306E-3,{"$f":"VLOOKUP(F67,$X$30:$AD$36,5,FALSE)","v":"NA"},{"$f":"VLOOKUP(F67,$X$31:$AD$36,7,FALSE)","v":"NA"},{"$f":"IF(E67=\"SI\",SQRT(SUMSQ(G67:I69,N51)),SQRT(SUMSQ(G67:I69)))","v":4.0890669779302963E-3},{"$f":"IF(D67<>0,J67/L21,\"0\")","v":0.10282649567301667},null,"∞",null,null,{"$f":"IF(J67=\"NA\",\"Se realiza estimación de incertidumbre de la estandarización de forma independiente\",\"\")","v":""}]
[null,null,null,null,null,"Balanza Analítica","NA",5.7735026918962585E-5,1E-4,null,null,null,"∞"]
[null,null,null,null,null,"Repetibilidad 3",{"$f":"IF(F69=\"Material de referencia\",$F$49/$H$49,IF(F69=\"Repetibilidad 1\",$M$44/SQRT($M$43),IF(F69=\"Repetibilidad 2\",$N$44/SQRT($N$43),IF(F69=\"Repetibilidad 3\",$O$44/SQRT(O43),IF(F69=\"Repetibilidad 4\",$P$44/SQRT($P$43),\"\")))))","v":2.0116846174288858E-4},null,null,null,null,null,{"$f":"IF(F69=\"Material de referencia\",\"∞\",IF(F69=\"Repetibilidad 1\",$M$43-1,IF(F69=\"Repetibilidad 2\",N$43-1, IF(F69=\"Repetibilidad 3\",$O$43-1,\"∞\"))))","v":3}]
[null,null,null,{"$f":"E22","v":"Volumen de muestra, mL"},"SI","Pipeta 2,5",4.0824829046386306E-3,{"$f":"VLOOKUP(F70,$X$30:$AD$36,5,FALSE)","v":"NA"},{"$f":"VLOOKUP(F70,$X$31:$AD$36,7,FALSE)","v":"NA"},{"$f":"IF(E70=\"SI\",SQRT(SUMSQ(G70:I72,N52)),SQRT(SUMSQ(G70:I72)))","v":4.1825281429617028E-3},{"$f":"IF(D70<>0,J70/L22,\"0\")","v":1.6730112571846812E-3},null,"∞",null,null,{"$f":"IF(J70=\"NA\",\"Se realiza estimación de incertidumbre de la estandarización de forma independiente\",\"\")","v":""}]
[null,null,null,null,null,"NA",0,0,0,null,null,null,"∞"]
[null,null,null,null,null,"Repetibilidad 4",{"$f":"IF(F72=\"Material de referencia\",$F$49/$H$49,IF(F72=\"Repetibilidad 1\",$M$44/SQRT($M$43),IF(F72=\"Repetibilidad 2\",$N$44/SQRT($N$43),IF(F72=\"Repetibilidad 3\",$O$44/SQRT(O43),IF(F72=\"Repetibilidad 4\",$P$44/SQRT($P$43),\"\")))))","v":0},null,null,null,null,null,{"$f":"IF(F72=\"Material de referencia\",\"∞\",IF(F72=\"Repetibilidad 1\",$M$43-1,IF(F72=\"Repetibilidad 2\",N$43-1, IF(F72=\"Repetibilidad 3\",$O$43-1,\"∞\"))))","v":"∞"}]
[null,null,null,{"$f":"E23","v":0},"¿Es un componente volumétrico?","NA",0,{"$f":"VLOOKUP(F73,$X$30:$AD$36,5,FALSE)","v":0},{"$f":"VLOOKUP(F73,$X$31:$AD$36,7,FALSE)","v":0},{"$f":"IF(E73=\"SI\",SQRT(SUMSQ(G73:I75,N53)),SQRT(SUMSQ(G73:I75)))","v":0},{"$f":"IF(D73<>0,J73/L23,\"0\")","v":"0"},null,"∞",null,null,{"$f":"IF(J73=\"NA\",\"Se realiza estimación de incertidumbre de la estandarización de forma independiente\",\"\")","v":""}]
[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$44/SQRT($M$43),IF(F75=\"Repetibilidad 2\",$N$44/SQRT($N$43),IF(F75=\"Repetibilidad 3\",$O$44/SQRT(O43),IF(F75=\"Repetibilidad 4\",$P$44/SQRT($P$43),\"\")))))","v":""},null,null,null,null,null,{"$f":"IF(F75=\"Material de referencia\",\"∞\",IF(F75=\"Repetibilidad 1\",$M$43-1,IF(F75=\"Repetibilidad 2\",N$43-1, IF(F75=\"Repetibilidad 3\",$O$43-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":446951922.09708899}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+LOOKUP(N76,T14:T31,U14:U31)","v":2}]
[]
["EXPRESIÓN RESULTADO"]
[]
[null,null,null,null,{"$f":"+E18","v":"DBO como mg O2/L"},null,null,null,null,{"$f":"Q45","v":20.625}]
[null,null,null,null,"Incertidumbre expandida a 95,45 %",null,null,null,null,{"$f":"O61","v":4.2539008893214723}]
[]
[]
["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":"Volumen utilizado para la muestra, mL"},null,{"$f":"K61*100/(SUM($K$61+$K$64+$K$67+$K$70+$K$73))","v":4.4880297355672027}]
[null,null,null,null,null,null,null,{"$f":"D64","v":"Volumen utillizado para el blanco, mL"},null,{"$f":"K64*100/(SUM($K$61+$K$64+$K$67+$K$70+$K$73))","v":4.8949844058953591}]
[null,null,null,null,null,null,null,{"$f":"D67","v":"Normalidad"},null,{"$f":"K67*100/(SUM($K$61+$K$64+$K$67+$K$70+$K$73))","v":89.166230329760268}]
[null,null,null,null,null,null,null,{"$f":"D70","v":"Volumen de muestra, mL"},null,{"$f":"K70*100/(SUM($K$61+$K$64+$K$67+$K$70+$K$73))","v":1.4507555287771738}]
[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":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."]
["02",null,"2020-12-11","Nueva versión producto de la actualización de la documentación del Sistema Integrado de Gestión, por parte del funcionario Renzzo González."]
[null,3,"2025-07-17","Se actualiza el Formato de acuerdo con el memorando enviado por la OAP memorando 20251100097283 lineamientos para la actualización documental en el marco de la implementación del aplicativo suite visión. El código pasa de M-S-LC-F077 a SLC-F077."]
["ELABORÓ: \n\n\nElizabeth González Mateus\nContratista Laboratorio de Calidad Ambiental",null,null,null,null,null,"REVISÓ:\n\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\n    Claudia María Ávila Laverde\nCoordinadora Grupo Laboratorio  de Calidad Ambiental"]

{"sheet":"Hoja2","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}