{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Hoja2","DATOS 0","RT03-F55","Incertidumbre","interpolación pat","Interpol TH","Interpolación bñ ","RT03-F56","RT03-F57","RT03-F64","EJEMPLO","DATOS ANTERIORES DE PATRONES ","CORRECCIÓN INST AUX","TABLA DE CONVERSIÓN 1","TABLA DE CONVERSIÓN "],"not_rendered":{"charts":13,"images":7,"macros":1,"external_links":4,"defined_names":194,"comments":2,"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":"Hoja2","index":0,"n_rows":49,"n_cols":4,"rows_kept":49,"cut":false,"hidden":true,"merged":[[0,0,1,0],[0,2,0,3]]}
["CIUDAD Y/O MUNICIPIO","TERMÓMETRO CON SONDA","TERMOHIGROMETRO"]
[null,"°C (LÍQUIDO)","°C (AMBIENTE)","RH%"]
["ARMENIA",27.2,28.4,58.1]
["ARMENIA",22.7,24.1,37.9]
["BARRANQUILLA",34.1,30.8,69.5]
["BARRANQUILLA",33.700000000000003,31.9,66.099999999999994]
["BOGOTÁ",22.1,21.8,47.8]
["BOGOTÁ",19.8,22.2,44]
["BUCARAMANGA",29.4,30.7,52.4]
["BUCARAMANGA",30.5,28.7,60.1]
["CALDAS",24.1,23.7,64.900000000000006]
["CARTAGENA",32.200000000000003,33.299999999999997,65.8]
["CARTAGENA",33.5,32,69.5]
["IBAGUÉ",28.4,25.1,62.5]
["IBAGUÉ",30.9,31,39.200000000000003]
["MONTERIA",32.5,33.299999999999997,53.3]
["MONTERIA",30.6,28.9,71.3]
["OCAÑA",28.3,27.5,62.9]
["OCAÑA",25.5,27.6,59.9]
["PASTO",21.2,19.100000000000001,59.5]
["PASTO",22.6,21.4,49.4]
["PIEDECUESTA",29.9,30.8,49.4]
["PIEDECUESTA",27.5,26.3,57.4]
["ROVIRA",34.200000000000003,31.6,38.4]
["ROVIRA",32,29.1,51.5]
["SALGAR",27.2,25.3,68.099999999999994]
["ZIPAQUIRA",20.100000000000001,21.8,50.6]
["ZIPAQUIRA",19.3,17.8,60.2]
["VALLEDUPAR",34.1,30.9,59.4]
["VALLEDUPAR",36.5,36.799999999999997,44.8]
["SAN BERNARDO",24,20.2,81]
["MOSQUERA",21.9,19,57.7]
["CAJICÁ",21.4,20.3,57.8]
["SILVANIA",23.8,22.7,66.7]
["SALENTO",20.6,21.2,67.8]
["ACACIAS",28.5,29.8,60.9]
["GUALANDAY",33.799999999999997,25.2,80]
["Fusagasugá",21.8,20.8,79.3]
["GARAGOA",26.3,28.4,53.3]
["MUZO",25.2,25.8,69.599999999999994]
["TUNJA",22,19.3,53.8]
["TUTA",23,17.3,66.099999999999994]
["PROVIDENCIA",27.9,28.8,67.7]
["SAN ANDRÉS",29.1,29.6,70.099999999999994]
["SAN ANDRÉS",30.7,33.1,61]
["GUADUAS",27.9,26.1,66.599999999999994]
[null,{"$f":"+MAX(B3:B46)","v":36.5}]
[null,{"$f":"+MIN(B3:B46)","v":19.3}]
[null,{"$f":"+B47-B48","v":17.2}]

{"sheet":"DATOS 0","index":1,"n_rows":66,"n_cols":17,"rows_kept":66,"cut":false,"hidden":true,"merged":[[71,2,72,2],[71,3,72,7],[71,8,72,11],[71,12,72,15],[0,5,2,16],[65,2,66,2],[65,3,66,7],[65,8,66,11],[65,12,66,15],[67,2,68,2],[67,3,68,7],[67,8,68,11],[67,12,68,15],[69,2,70,2],[69,3,70,7],[69,8,70,11],[69,12,70,15],[55,2,55,15],[56,2,58,15],[60,2,61,15],[62,3,62,7],[62,8,62,15],[63,2,64,2],[63,3,64,7],[63,8,64,11],[63,12,64,15],[45,1,47,7],[45,8,47,8],[45,9,47,9],[45,10,47,16],[48,1,50,7],[48,8,50,8],[48,9,50,9],[48,10,50,16],[51,1,53,7],[51,8,53,8],[51,9,53,9],[51,10,53,16],[38,12,38,16],[39,4,39,8],[39,9,39,11],[39,12,39,16],[41,1,41,7],[41,10,41,16],[42,1,44,7],[42,8,44,8],[42,9,44,9],[42,10,44,16],[38,4,38,8],[38,9,38,11],[34,12,34,16],[35,4,35,8],[35,9,35,11],[35,12,35,16],[36,4,36,8],[36,9,36,11],[36,12,36,16],[37,4,37,8],[37,9,37,11],[37,12,37,16],[34,4,34,8],[34,9,34,11],[29,12,29,16],[30,4,30,8],[30,9,30,11],[30,12,30,16],[31,4,31,8],[31,9,31,11],[31,12,31,16],[32,12,32,13],[33,4,33,8],[33,9,33,11],[33,12,33,16],[29,4,29,8],[29,9,29,11],[25,4,25,8],[25,9,25,11],[25,12,25,16],[26,4,26,8],[26,9,26,11],[26,12,26,16],[27,4,27,8],[27,9,27,11],[27,12,27,16],[21,9,21,11],[21,12,21,16],[22,4,22,8],[22,9,22,11],[22,12,22,16],[23,4,23,8],[23,9,23,11],[23,12,23,16],[24,12,24,13],[17,1,17,3],[17,4,17,8],[17,9,17,11],[17,12,17,16],[18,1,18,3],[18,4,18,8],[18,9,18,11],[18,12,18,16],[19,4,19,8],[19,9,19,11],[19,12,19,16],[13,1,13,3],[13,4,13,8],[13,9,13,11],[13,12,13,13],[13,14,13,16],[14,1,14,3],[14,4,14,8],[14,9,14,16],[16,1,16,16],[0,0,2,4],[4,1,4,3],[4,4,4,8],[4,9,4,12],[4,13,4,16],[5,1,5,3],[5,4,5,8],[5,9,6,12],[5,13,6,16],[6,1,6,3],[6,4,6,8],[7,1,7,3],[7,4,7,8],[7,9,7,12],[7,13,7,16],[8,1,8,3],[8,4,8,8],[20,4,20,8],[20,9,20,11],[24,5,24,6],[23,1,23,3],[24,1,24,3],[8,9,8,12],[8,13,8,16],[10,1,10,16],[11,1,11,3],[11,4,11,8],[11,9,11,11],[11,12,11,13],[11,14,11,15],[12,1,12,3],[12,4,12,8],[12,9,12,11],[12,12,12,13],[12,14,12,16],[28,4,28,8],[28,9,28,11],[28,12,28,16],[37,1,37,3],[38,1,38,3],[39,1,39,3],[25,1,25,3],[26,1,26,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[22,1,22,3],[27,1,27,3],[29,1,29,3],[30,1,30,3],[31,1,31,3],[32,1,32,3],[33,1,33,3],[34,1,34,3],[35,1,35,3],[36,1,36,3],[28,1,28,3],[20,12,20,16],[21,4,21,8]]}
[null,null,null,null,null,"HOJA DE CÁLCULO PARA CALIBRACIÓN DE TERMÓMETROS DIGITALES"]
[]
[]
[]
[null,"Solicitante:",null,null,"Laboratorio de calibración de temperatúra y humedad",null,null,null,null,"Número de certificado:",null,null,null,"LCTD-"]
[null,"Dirección:",null,null,"Avenida carrera 50 # 26-50 int 2, piso 5",null,null,null,null,"Código interno  LCTD-XX-XXXXX (compuesto por N° Radicado)",null,null,null,"LCTD-"]
[null,"Ciudad:",null,null,"Bogotá D.C. "]
[null,"Fecha de recepción:",null,null,null,null,null,null,null,"Unidad de calibración:",null,null,null,"°C"]
[null,"Fecha de calibración:",null,null,null,null,null,null,null,"Método de calibración:",null,null,null,"Comparación en medio isotérmicos."]
[]
[null,"DATOS DEL INSTRUMENTO BAJO CALIBRACIÓN (IBC)"]
[null,"Instrumento:",null,null,null,null,null,null,null,"Intervalo de medición :",null,null,10,null,50,null,"°C"]
[null,"Fabricante:",null,null,null,null,null,null,null,"Resolución:",null,null,null,null,{"$f":"+Q12","v":"°C"}]
[null,"Modelo:",null,null,null,null,null,null,null,"Canal:"]
[null,"Serie:"]
[]
[null,"DATOS DEL INSTRUMENTO UTILIZADO EN LA CALIBRACIÓN"]
[null,"Instrumento:",null,null,"Baño Térmico",null,null,null,null,"Instrumento:",null,null,"Termómetro"]
[null,"Marca:",null,null,"Polyscience",null,null,null,null,"Marca:",null,null,"Lufft"]
[98,"Serie:",null,null,"2110-90004",null,null,null,null,"Serie:",null,null,"008.0916.1212.006 - 347980.006"]
[null,"Modelo:",null,null,"AP15RCAL-A11BR",null,null,null,null,"Modelo:",null,null,"XP100   -   PT100"]
[null,"Certificado No:",null,null,"MI-0841",null,null,null,null,"Certificado No:",null,null,"5736"]
[null,"Proveedor  de trazabilidad:",null,null,"Unión Metrológica",null,null,null,null,"Proveedor  de trazabilidad:",null,null,"INM"]
[null,"Fecha de calibración:",null,null,"2021-12-06",null,null,null,null,"Fecha de calibración:",null,null,"16/02/2022"]
[]
[null,"Instrumento:",null,null,"Termómetro digital",null,null,null,null,"Instrumento:",null,null,"Termómetro digital"]
[null,"Marca:",null,null,"Lufft",null,null,null,null,"Marca:",null,null,"YOWEXA"]
[null,"Serie:",null,null,"022.1014.1212.005 - 347980.004",null,null,null,null,"Serie:",null,null,"190724GSM0087287"]
[null,"Modelo:",null,null,"XP100   -   PT100",null,null,null,null,"Modelo:",null,null,"NO INDICA"]
[null,"Certificado No:",null,null,"5737",null,null,null,null,"Certificado No:",null,null,"5717 // 5720"]
[null,"Proveedor  de trazabilidad:",null,null,"INM",null,null,null,null,"Proveedor  de trazabilidad:",null,null,"INM"]
[null,"Fecha de calibración:",null,null,"2022-02-16",null,null,null,null,"Fecha de calibración:",null,null,"2021-01-27"]
[]
[null,"Instrumento:",null,null,null,null,null,null,null,"Instrumento:"]
[null,"Marca:",null,null,{"$f":"I43:J54","v":{"$error":"#VALUE!"}},null,null,null,null,"Marca:"]
[null,"Serie:",null,null,null,null,null,null,null,"Serie:"]
[null,"Modelo:",null,null,null,null,null,null,null,"Modelo:"]
[null,"Certificado No:",null,null,null,null,null,null,null,"Certificado No:"]
[null,"Proveedor  de trazabilidad:",null,null,null,null,null,null,null,"Proveedor  de trazabilidad:"]
[null,"Fecha de calibración:",null,null,null,null,null,null,null,"Fecha de calibración:"]
[]
[null,"Verificar que:",null,null,null,null,null,null,"SI","NO","OBSERVACIONES"]
[null,"¿El termómetro está roto?"]
[]
[]
[null,"¿El  termómetro está midiendo similar a la temperatura ambiente?"]
[]
[]
[null,"¿El  termómetro esta libre de golpes o arañazos?"]
[]
[]
[null,"¿El instrumento de medición presenta todas las partes?"]
[]
[]
[]
[null,null,"OBSERVACIONES"]
[null,null,"Este es un ejercicio prueba, por tanto el certificado sera parte del ejercicio."]
[]
[]
[]
[null,null,"Grupo de trabajo del laboratorio"]
[]
[null,null,"No","Nombres",null,null,null,null,"Roles del grupo de trabajo"]
[null,null,"AC","Astrid Camila Riveros Meza",null,null,null,null,"Responsable de la Dirección Técnica del Laboratorio de Temperatura y Humedad",null,null,null,"Metrólogo del Laboratorio Temperatura y Humedad"]
[]
[null,null,"PV","Pedro José Vargas López",null,null,null,null," Sustituto del Responsable de la Dirección Técnica del Laboratorio de Temperatura y Humedad",null,null,null,"Metrólogo del Laboratorio Temperatura y Humedad"]

{"sheet":"RT03-F55","index":2,"n_rows":104,"n_cols":12,"rows_kept":104,"cut":false,"hidden":true,"merged":[[0,3,2,12],[0,0,2,2],[103,0,104,1],[103,2,104,2],[8,0,9,0],[8,1,9,1],[8,2,9,2],[76,4,76,6],[16,3,16,5],[39,4,40,4],[39,5,40,5],[54,4,55,4],[69,4,70,4],[7,3,7,11],[8,3,9,11],[93,3,93,4],[69,5,70,5],[24,8,26,10],[4,8,4,10],[4,6,4,7],[5,8,5,10],[54,5,55,5]]}
[null,null,null,"HOJA DE CÁLCULO PARA CALIBRACIÓN DE TERMÓMETROS DIGITALES"]
[]
[]
[]
[null,null,null,null,null,null,"Diligenció"]
["Código Interno:",{"$f":"'DATOS 0'!N6","v":"LCTD-"}]
[]
[null,null,null,"OBSERVACIONES"]
[]
[]
[]
[]
[]
["t",0,"°C",1]
["n","Patrón °C","FECHA","2021-08-03"]
[1,1E-3,"HORA","15:14:00"]
[2,1E-3,"PATRÓN","Pt 100"]
[3,2E-3,"MEDIO","Punto de Hielo","SP",{"$f":"+B14","v":0},"°C"]
[4,2E-3,"INMERSIÓN",53,"mm"]
[5,1E-3,"ta, °C","ha, % HR","THG:","CS-TE-005"]
[6,null,21.7,53]
[7]
[8]
[9]
["PROMEDIO",{"$f":"AVERAGE(B16:B24)","v":1.4E-3}]
["DESV EST",{"$f":"STDEV(B16:B24)","v":5.4772255750516611E-4}]
[]
[]
["t",null,"°C"]
["n","Patrón ","Patrón °C","IBC °C","Fecha",null,null,null,null,null,"Patrón Corregido °C","Patrón t Corregido °C"]
[1,null,null,null,"Hora",null,null,null,null,null,{"$f":"+'RT03-F55'!B31^2*'interpolación pat'!$B$18+'RT03-F55'!B31*'interpolación pat'!$C$18+'interpolación pat'!$D$18+B31","v":-1.8678069397539229E-2},{"$f":"+'RT03-F55'!C31^2*'interpolación pat'!$I$18+'RT03-F55'!C31*'interpolación pat'!$J$18+'interpolación pat'!$K$18+C31","v":-2.7976702323079423E-2}]
[2,null,null,null,"Patrón",null,null,null,null,null,{"$f":"+'RT03-F55'!B32^2*'interpolación pat'!$B$18+'RT03-F55'!B32*'interpolación pat'!$C$18+'interpolación pat'!$D$18+B32","v":-1.8678069397539229E-2},{"$f":"+'RT03-F55'!C32^2*'interpolación pat'!$I$18+'RT03-F55'!C32*'interpolación pat'!$J$18+'interpolación pat'!$K$18+C32","v":-2.7976702323079423E-2}]
[3,null,null,null,"Medio","Baño líquido","SP",null,"°C",null,{"$f":"+'RT03-F55'!B33^2*'interpolación pat'!$B$18+'RT03-F55'!B33*'interpolación pat'!$C$18+'interpolación pat'!$D$18+B33","v":-1.8678069397539229E-2},{"$f":"+'RT03-F55'!C33^2*'interpolación pat'!$I$18+'RT03-F55'!C33*'interpolación pat'!$J$18+'interpolación pat'!$K$18+C33","v":-2.7976702323079423E-2}]
[4,null,null,null,"Inmersión",null,"mm","THG:",null,null,{"$f":"+'RT03-F55'!B34^2*'interpolación pat'!$B$18+'RT03-F55'!B34*'interpolación pat'!$C$18+'interpolación pat'!$D$18+B34","v":-1.8678069397539229E-2},{"$f":"+'RT03-F55'!C34^2*'interpolación pat'!$I$18+'RT03-F55'!C34*'interpolación pat'!$J$18+'interpolación pat'!$K$18+C34","v":-2.7976702323079423E-2}]
[5,null,null,null,"ta, °C","ha, % hr","ta, °C","ha, % hr",null,null,{"$f":"+'RT03-F55'!B35^2*'interpolación pat'!$B$18+'RT03-F55'!B35*'interpolación pat'!$C$18+'interpolación pat'!$D$18+B35","v":-1.8678069397539229E-2},{"$f":"+'RT03-F55'!C35^2*'interpolación pat'!$I$18+'RT03-F55'!C35*'interpolación pat'!$J$18+'interpolación pat'!$K$18+C35","v":-2.7976702323079423E-2}]
[6,null,null,null,null,null,{"$f":"+E36*'Interpol TH'!$B$15+'Interpol TH'!$C$15+E36","v":0.24864429179313646},{"$f":"+F36*'Interpol TH'!$F$15+'Interpol TH'!$G$15+F36","v":-14.526928323457453},null,null,{"$f":"+'RT03-F55'!B36^2*'interpolación pat'!$B$18+'RT03-F55'!B36*'interpolación pat'!$C$18+'interpolación pat'!$D$18+B36","v":-1.8678069397539229E-2},{"$f":"+'RT03-F55'!C36^2*'interpolación pat'!$I$18+'RT03-F55'!C36*'interpolación pat'!$J$18+'interpolación pat'!$K$18+C36","v":-2.7976702323079423E-2}]
[7,null,null,null,"Estabilidad",null,null,null,null,null,{"$f":"+'RT03-F55'!B37^2*'interpolación pat'!$B$18+'RT03-F55'!B37*'interpolación pat'!$C$18+'interpolación pat'!$D$18+B37","v":-1.8678069397539229E-2},{"$f":"+'RT03-F55'!C37^2*'interpolación pat'!$I$18+'RT03-F55'!C37*'interpolación pat'!$J$18+'interpolación pat'!$K$18+C37","v":-2.7976702323079423E-2}]
[8,null,null,null,"Uniformidad",{"$f":"+MAX(ABS(K31-L31),ABS(K32-L32),ABS(K33-L33),ABS(K34-L34),ABS(K35-L35),ABS(K36-L36),ABS(K37-L37),ABS(K38-L38),ABS(K39-L39))","v":9.2986329255401942E-3},{"$f":"+IF(F38<'Interpolación bñ '!C8,\"SI\",\"NO\")","v":"SI"},null,null,null,{"$f":"+'RT03-F55'!B38^2*'interpolación pat'!$B$18+'RT03-F55'!B38*'interpolación pat'!$C$18+'interpolación pat'!$D$18+B38","v":-1.8678069397539229E-2},{"$f":"+'RT03-F55'!C38^2*'interpolación pat'!$I$18+'RT03-F55'!C38*'interpolación pat'!$J$18+'interpolación pat'!$K$18+C38","v":-2.7976702323079423E-2}]
[9,null,null,null,"ESTA",{"$f":"+ABS(MAX(K31:K39)-MIN(K31:K39))","v":0},{"$f":"+IF(F39<'Interpolación bñ '!D9,\"SI\",\"NO\")","v":"SI"},null,null,null,{"$f":"+'RT03-F55'!B39^2*'interpolación pat'!$B$18+'RT03-F55'!B39*'interpolación pat'!$C$18+'interpolación pat'!$D$18+B39","v":-1.8678069397539229E-2},{"$f":"+'RT03-F55'!C39^2*'interpolación pat'!$I$18+'RT03-F55'!C39*'interpolación pat'!$J$18+'interpolación pat'!$K$18+C39","v":-2.7976702323079423E-2}]
["PROMEDIO",{"$f":"AVERAGE(B31:B39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(C31:C39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(D31:D39)","v":{"$error":"#DIV/0!"}},"¿Pasa el punto de calibración?",{"$f":"+IF(AND(G38=\"SI\",G39=\"SI\"),\"SI\",\"NO\")","v":"SI"},null,null,null,null,{"$f":"+AVERAGE(K31:K39)","v":-1.8678069397539229E-2},{"$f":"+AVERAGE(L31:L39)","v":-2.7976702323079423E-2}]
["DESV EST",{"$f":"STDEV(B31:B39)","v":{"$error":"#DIV/0!"}},{"$f":"STDEV(C31:C39)","v":{"$error":"#DIV/0!"}},{"$f":"STDEV(D31:D39)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,{"$f":"STDEV(K31:K39)","v":0}]
[]
[]
["t",null,"°C"]
["n","Patrón °C","Patrón °C","IBC °C","Fecha",null,null,null,null,null,"Patrón Corregido °C","Patrón t Corregido °C"]
[1,null,null,null,"Hora",null,null,null,null,null,{"$f":"+'RT03-F55'!B46^2*'interpolación pat'!$B$18+'RT03-F55'!B46*'interpolación pat'!$C$18+'interpolación pat'!$D$18+B46","v":-1.8678069397539229E-2},{"$f":"+'RT03-F55'!C46^2*'interpolación pat'!$I$18+'RT03-F55'!C46*'interpolación pat'!$J$18+'interpolación pat'!$K$18+C46","v":-2.7976702323079423E-2}]
[2,null,null,null,"Patrón",null,null,null,null,null,{"$f":"+'RT03-F55'!B47^2*'interpolación pat'!$B$18+'RT03-F55'!B47*'interpolación pat'!$C$18+'interpolación pat'!$D$18+B47","v":-1.8678069397539229E-2},{"$f":"+'RT03-F55'!C47^2*'interpolación pat'!$I$18+'RT03-F55'!C47*'interpolación pat'!$J$18+'interpolación pat'!$K$18+C47","v":-2.7976702323079423E-2}]
[3,null,null,null,"Medio","Baño líquido","SP",null,"°C",null,{"$f":"+'RT03-F55'!B48^2*'interpolación pat'!$B$18+'RT03-F55'!B48*'interpolación pat'!$C$18+'interpolación pat'!$D$18+B48","v":-1.8678069397539229E-2},{"$f":"+'RT03-F55'!C48^2*'interpolación pat'!$I$18+'RT03-F55'!C48*'interpolación pat'!$J$18+'interpolación pat'!$K$18+C48","v":-2.7976702323079423E-2}]
[4,null,null,null,"Inmersión",null,"mm","THG:",null,null,{"$f":"+'RT03-F55'!B49^2*'interpolación pat'!$B$18+'RT03-F55'!B49*'interpolación pat'!$C$18+'interpolación pat'!$D$18+B49","v":-1.8678069397539229E-2},{"$f":"+'RT03-F55'!C49^2*'interpolación pat'!$I$18+'RT03-F55'!C49*'interpolación pat'!$J$18+'interpolación pat'!$K$18+C49","v":-2.7976702323079423E-2}]
[5,null,null,null,"ta, °C","ha, % hr","ta, °C","ha, % hr",null,null,{"$f":"+'RT03-F55'!B50^2*'interpolación pat'!$B$18+'RT03-F55'!B50*'interpolación pat'!$C$18+'interpolación pat'!$D$18+B50","v":-1.8678069397539229E-2},{"$f":"+'RT03-F55'!C50^2*'interpolación pat'!$I$18+'RT03-F55'!C50*'interpolación pat'!$J$18+'interpolación pat'!$K$18+C50","v":-2.7976702323079423E-2}]
[6,null,null,null,null,null,{"$f":"+E51*'Interpol TH'!$B$15+'Interpol TH'!$C$15+E51","v":0.24864429179313646},{"$f":"+F51*'Interpol TH'!$F$15+'Interpol TH'!$G$15+F51","v":-14.526928323457453},null,null,{"$f":"+'RT03-F55'!B51^2*'interpolación pat'!$B$18+'RT03-F55'!B51*'interpolación pat'!$C$18+'interpolación pat'!$D$18+B51","v":-1.8678069397539229E-2},{"$f":"+'RT03-F55'!C51^2*'interpolación pat'!$I$18+'RT03-F55'!C51*'interpolación pat'!$J$18+'interpolación pat'!$K$18+C51","v":-2.7976702323079423E-2}]
[7,null,null,null,"Estabilidad",null,null,null,null,null,{"$f":"+'RT03-F55'!B52^2*'interpolación pat'!$B$18+'RT03-F55'!B52*'interpolación pat'!$C$18+'interpolación pat'!$D$18+B52","v":-1.8678069397539229E-2},{"$f":"+'RT03-F55'!C52^2*'interpolación pat'!$I$18+'RT03-F55'!C52*'interpolación pat'!$J$18+'interpolación pat'!$K$18+C52","v":-2.7976702323079423E-2}]
[8,null,null,null,"Uniformidad",{"$f":"+MAX(ABS(K46-L46),ABS(K47-L47),ABS(K48-L48),ABS(K49-L49),ABS(K50-L50),ABS(K51-L51),ABS(K52-L52),ABS(K53-L53),ABS(K54-L54))","v":9.2986329255401942E-3},{"$f":"+IF(F53<'Interpolación bñ '!C9,\"SI\",\"NO\")","v":"SI"},null,null,null,{"$f":"+'RT03-F55'!B53^2*'interpolación pat'!$B$18+'RT03-F55'!B53*'interpolación pat'!$C$18+'interpolación pat'!$D$18+B53","v":-1.8678069397539229E-2},{"$f":"+'RT03-F55'!C53^2*'interpolación pat'!$I$18+'RT03-F55'!C53*'interpolación pat'!$J$18+'interpolación pat'!$K$18+C53","v":-2.7976702323079423E-2}]
[9,null,null,null,"ESTA",{"$f":"+ABS(MAX(K46:K54)-MIN(K46:K54))","v":0},{"$f":"+IF(F54<'Interpolación bñ '!D9,\"SI\",\"NO\")","v":"SI"},null,null,null,{"$f":"+'RT03-F55'!B54^2*'interpolación pat'!$B$18+'RT03-F55'!B54*'interpolación pat'!$C$18+'interpolación pat'!$D$18+B54","v":-1.8678069397539229E-2},{"$f":"+'RT03-F55'!C54^2*'interpolación pat'!$I$18+'RT03-F55'!C54*'interpolación pat'!$J$18+'interpolación pat'!$K$18+C54","v":-2.7976702323079423E-2}]
["PROMEDIO",{"$f":"AVERAGE(B46:B54)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(C46:C54)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(D46:D54)","v":{"$error":"#DIV/0!"}},"¿Pasa el punto de calibración?",{"$f":"+IF(AND(G53=\"SI\",G54=\"SI\"),\"SI\",\"NO\")","v":"SI"},null,null,null,null,{"$f":"+AVERAGE(K46:K54)","v":-1.8678069397539229E-2},{"$f":"+AVERAGE(L46:L54)","v":-2.7976702323079423E-2}]
["DESV EST",{"$f":"STDEV(B46:B54)","v":{"$error":"#DIV/0!"}},{"$f":"STDEV(C46:C54)","v":{"$error":"#DIV/0!"}},{"$f":"STDEV(D46:D54)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,{"$f":"STDEV(K46:K54)","v":0}]
[]
[]
["t",null,"°C"]
["n","Patrón °C","Patrón °C","IBC °C","Fecha",null,null,null,null,null,"Patrón Corregido °C","Patrón t Corregido °C"]
[1,null,null,null,"Hora",null,null,null,null,null,{"$f":"+'RT03-F55'!B61^2*'interpolación pat'!$B$18+'RT03-F55'!B61*'interpolación pat'!$C$18+'interpolación pat'!$D$18+B61","v":-1.8678069397539229E-2},{"$f":"+'RT03-F55'!C61^2*'interpolación pat'!$I$18+'RT03-F55'!C61*'interpolación pat'!$J$18+'interpolación pat'!$K$18+C61","v":-2.7976702323079423E-2}]
[2,null,null,null,"Patrón",null,null,null,null,null,{"$f":"+'RT03-F55'!B62^2*'interpolación pat'!$B$18+'RT03-F55'!B62*'interpolación pat'!$C$18+'interpolación pat'!$D$18+B62","v":-1.8678069397539229E-2},{"$f":"+'RT03-F55'!C62^2*'interpolación pat'!$I$18+'RT03-F55'!C62*'interpolación pat'!$J$18+'interpolación pat'!$K$18+C62","v":-2.7976702323079423E-2}]
[3,null,null,null,"Medio","Baño líquido","SP",null,"°C",null,{"$f":"+'RT03-F55'!B63^2*'interpolación pat'!$B$18+'RT03-F55'!B63*'interpolación pat'!$C$18+'interpolación pat'!$D$18+B63","v":-1.8678069397539229E-2},{"$f":"+'RT03-F55'!C63^2*'interpolación pat'!$I$18+'RT03-F55'!C63*'interpolación pat'!$J$18+'interpolación pat'!$K$18+C63","v":-2.7976702323079423E-2}]
[4,null,null,null,"Inmersión",null,"mm","THG:",null,null,{"$f":"+'RT03-F55'!B64^2*'interpolación pat'!$B$18+'RT03-F55'!B64*'interpolación pat'!$C$18+'interpolación pat'!$D$18+B64","v":-1.8678069397539229E-2},{"$f":"+'RT03-F55'!C64^2*'interpolación pat'!$I$18+'RT03-F55'!C64*'interpolación pat'!$J$18+'interpolación pat'!$K$18+C64","v":-2.7976702323079423E-2}]
[5,null,null,null,"ta, °C","ha, % hr","ta, °C","ha, % hr",null,null,{"$f":"+'RT03-F55'!B65^2*'interpolación pat'!$B$18+'RT03-F55'!B65*'interpolación pat'!$C$18+'interpolación pat'!$D$18+B65","v":-1.8678069397539229E-2},{"$f":"+'RT03-F55'!C65^2*'interpolación pat'!$I$18+'RT03-F55'!C65*'interpolación pat'!$J$18+'interpolación pat'!$K$18+C65","v":-2.7976702323079423E-2}]
[6,null,null,null,null,null,{"$f":"+E66*'Interpol TH'!$B$15+'Interpol TH'!$C$15+E66","v":0.24864429179313646},{"$f":"+F66*'Interpol TH'!$F$15+'Interpol TH'!$G$15+F66","v":-14.526928323457453},null,null,{"$f":"+'RT03-F55'!B66^2*'interpolación pat'!$B$18+'RT03-F55'!B66*'interpolación pat'!$C$18+'interpolación pat'!$D$18+B66","v":-1.8678069397539229E-2},{"$f":"+'RT03-F55'!C66^2*'interpolación pat'!$I$18+'RT03-F55'!C66*'interpolación pat'!$J$18+'interpolación pat'!$K$18+C66","v":-2.7976702323079423E-2}]
[7,null,null,null,"Estabilidad",null,null,null,null,null,{"$f":"+'RT03-F55'!B67^2*'interpolación pat'!$B$18+'RT03-F55'!B67*'interpolación pat'!$C$18+'interpolación pat'!$D$18+B67","v":-1.8678069397539229E-2},{"$f":"+'RT03-F55'!C67^2*'interpolación pat'!$I$18+'RT03-F55'!C67*'interpolación pat'!$J$18+'interpolación pat'!$K$18+C67","v":-2.7976702323079423E-2}]
[8,null,null,null,"Uniformidad",{"$f":"+MAX(ABS(K61-L61),ABS(K62-L62),ABS(K63-L63),ABS(K64-L64),ABS(K65-L65),ABS(K66-L66),ABS(K67-L67),ABS(K68-L68),ABS(K69-L69))","v":9.2986329255401942E-3},{"$f":"+IF(F68<'Interpolación bñ '!C10,\"SI\",\"NO\")","v":"SI"},null,null,null,{"$f":"+'RT03-F55'!B68^2*'interpolación pat'!$B$18+'RT03-F55'!B68*'interpolación pat'!$C$18+'interpolación pat'!$D$18+B68","v":-1.8678069397539229E-2},{"$f":"+'RT03-F55'!C68^2*'interpolación pat'!$I$18+'RT03-F55'!C68*'interpolación pat'!$J$18+'interpolación pat'!$K$18+C68","v":-2.7976702323079423E-2}]
[9,null,null,null,"ESTA",{"$f":"+ABS(MAX(K61:K69)-MIN(K61:K69))","v":0},{"$f":"+IF(F69<'Interpolación bñ '!D10,\"SI\",\"NO\")","v":"SI"},null,null,null,{"$f":"+'RT03-F55'!B69^2*'interpolación pat'!$B$18+'RT03-F55'!B69*'interpolación pat'!$C$18+'interpolación pat'!$D$18+B69","v":-1.8678069397539229E-2},{"$f":"+'RT03-F55'!C69^2*'interpolación pat'!$I$18+'RT03-F55'!C69*'interpolación pat'!$J$18+'interpolación pat'!$K$18+C69","v":-2.7976702323079423E-2}]
["PROMEDIO",{"$f":"AVERAGE(B61:B69)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(C61:C69)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(D61:D69)","v":{"$error":"#DIV/0!"}},"¿Pasa el punto de calibración?",{"$f":"+IF(AND(G68=\"SI\",G69=\"SI\"),\"SI\",\"NO\")","v":"SI"},null,null,null,null,{"$f":"+AVERAGE(K61:K69)","v":-1.8678069397539229E-2},{"$f":"+AVERAGE(L61:L69)","v":-2.7976702323079423E-2}]
["DESV EST",{"$f":"STDEV(B61:B69)","v":{"$error":"#DIV/0!"}},{"$f":"STDEV(C61:C69)","v":{"$error":"#DIV/0!"}},{"$f":"STDEV(D61:D69)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,{"$f":"STDEV(K61:K69)","v":0}]
[]
[]
["t",190,"°C",4]
["n","Patrón °C","Patrón °C","FECHA","2021-08-03"]
[1,192.3,193.4,"HORA","17:43:00"]
[2,192.4,193.3,"PATRÓN","Punto de Hielo"]
[3,192.3,193.4,"MEDIO",9150,"SP",{"$f":"+B74","v":190},"°C"]
[4,192.4,193.3,"INMERSIÓN",53,"mm"]
[5,192.3,193.4,"ta, °C","ha, % HR","THG:","CS-TE-005"]
[6,192.4,193.3,21.7,53]
[7,192.3,193.4]
[8,192.4,193.3]
[9,192.3,193.4]
["PROMEDIO",{"$f":"AVERAGE(B76:B84)","v":192.34444444444446},{"$f":"AVERAGE(C76:C84)","v":193.35555555555558}]
["DESV EST",{"$f":"STDEV(B76:B84)","v":5.270462766946999E-2},{"$f":"STDEV(C76:C84)","v":5.2704627669469997E-2}]
[]
["SEGUNDO PUNTO DE HIELO"]
["t",0]
["n",{"$f":"+B75","v":"Patrón °C"}]
[1]
[2,null,"Fecha"]
[3,null,"Hora"]
[4,null,"Patrón","Punto de Hielo"]
[5,null,"Medio","Vaso Dewar","SP",{"$f":"+B89","v":0}]
[6,null,"Inmersión",null,"mm","THG:"]
[7,null,"ta, °C","ha, % hr","ta, °C","ha, % hr"]
[8,null,null,null,{"$f":"+C98*'Interpol TH'!$B$15+'Interpol TH'!$C$15+C98","v":0.24864429179313646},{"$f":"+D98*'Interpol TH'!$F$15+'Interpol TH'!$G$15+D98","v":-14.526928323457453}]
[9]
["PROMEDIO",{"$f":"AVERAGE(B91:B99)","v":{"$error":"#DIV/0!"}}]
["DESV EST",{"$f":"STDEV(B91:B99)","v":{"$error":"#DIV/0!"}}]
[]
[]
["Calidad de calibración"]

{"sheet":"Incertidumbre","index":3,"n_rows":99,"n_cols":25,"rows_kept":99,"cut":false,"hidden":true,"merged":[[93,1,93,3],[94,1,94,3],[95,1,95,3],[87,1,87,3],[88,1,88,3],[89,1,89,3],[90,1,90,3],[91,1,91,3],[83,1,83,3],[84,1,84,3],[85,1,85,3],[86,1,86,3],[92,1,92,3],[46,1,46,3],[32,1,32,3],[33,1,33,3],[37,1,37,3],[28,1,28,3],[31,1,31,3],[30,1,30,3],[35,1,35,3],[36,1,36,3],[45,1,45,3],[34,1,34,3],[39,0,42,3],[29,1,29,3],[27,1,27,3],[7,1,7,3],[8,1,8,3],[11,1,11,3],[12,1,12,3],[9,1,9,3],[10,1,10,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[16,1,16,3],[17,1,17,3],[18,1,18,3],[19,1,19,3],[26,1,26,3],[0,0,2,3],[0,4,2,24],[25,4,26,4],[25,5,26,5],[25,6,26,6],[25,7,26,7],[25,8,26,8],[25,9,26,9],[25,10,26,10],[25,16,26,16],[25,17,26,17],[25,11,25,12],[25,14,25,15],[67,1,67,3],[68,1,68,3],[75,1,75,3],[69,1,69,3],[71,1,71,3],[72,1,72,3],[73,1,73,3],[74,1,74,3],[70,1,70,3],[54,1,54,3],[47,1,47,3],[64,1,64,3],[65,1,65,3],[66,1,66,3],[49,1,49,3],[50,1,50,3],[51,1,51,3],[53,1,53,3],[52,1,52,3],[55,1,55,3],[56,1,56,3],[48,1,48,3],[44,14,44,15],[44,4,45,4],[44,5,45,5],[44,6,45,6],[44,7,45,7],[44,8,45,8],[44,16,45,16],[44,17,45,17],[63,4,64,4],[63,5,64,5],[63,6,64,6],[63,7,64,7],[63,8,64,8],[63,17,64,17],[63,9,64,9],[63,10,64,10],[63,11,63,12],[63,14,63,15],[63,16,64,16],[44,9,45,9],[44,10,45,10],[44,11,44,12]]}
[null,null,null,null,"HOJA DE CÁLCULO PARA CALIBRACIÓN DE TERMÓMETROS DIGITALES"]
[]
[]
[]
[]
[]
["SP °C",{"$f":"+'[4] DATOS 1'!B88","v":0},null,null,null,null,null,null,null,null,null,"Incertidumbre Standard",null,"Grados de Libertad","Coeficiente de Sensibilidad",null,null,null,"Porcentaje"]
[null,"Fuente de Incertidumbre",null,null,"Valor Estimado","Unidad","Tipo","Distribución","u","Unidad","Factor","u tipica","Unidad","G.L.","Ci","Unidad","Contribución a u","Unidad","%"]
[null,"Repetibilidad del Patrón 1",null,null,{"$f":"+'[4] DATOS 1'!B99","v":2.1111111111111113E-3},"°C","A","N",{"$f":"+'[4] DATOS 1'!B100","v":9.2796072713833698E-4},"°C",3,{"$f":"I9/K9","v":3.0932024237944564E-4},{"$f":"+J9","v":"°C"},8,1,"--",{"$f":"ABS(L9*O9)","v":3.0932024237944564E-4},"°C",{"$f":"(Q9*100%)^2/$L$20^2","v":{"$error":"#REF!"}},null,null,"Uniformidad °C","Estabilidad °C"]
[null,"Incertidumbre del Termómetro Patrón 1",null,null,0,"-","B","N",{"$f":"+IF(E9<200,V17,V16)","v":-1.2470444584388524E-7},"°C",2,{"$f":"I10/K10","v":-6.2352222921942621E-8},{"$f":"+J10","v":"°C"},199.99999999999966,1,"--",6.2352222921942621E-8,"°C",{"$error":"#REF!"},null,9150,{"$f":"+[4]Incertidumbre!E9^2*'[4]Interpolación bñ '!#REF!++[4]Incertidumbre!E9*'[4]Interpolación bñ '!#REF!+'[4]Interpolación bñ '!#REF!","v":{"$error":"#REF!"}},{"$f":"+E9^2*'[4]Interpolación bñ '!#REF!+E9*'[4]Interpolación bñ '!#REF!+'[4]Interpolación bñ '!#REF!","v":{"$error":"#REF!"}}]
[null,"Resolución Indicador patrón",null,null,0,"-","B","R",1E-3,"Ohm",1.7320508075688772,5.773502691896258E-4,"Ohm",1000000,3.9249999999999997E-3,"°C/Ohm",2.2660998065692812E-6,"°C",{"$error":"#REF!"},null,7103,{"$f":"+E9*'[4]Interpolación bñ '!$B$20+'[4]Interpolación bñ '!$C$20","v":3.6995988888888795E-4},{"$f":"+E9*'[4]Interpolación bñ '!$B$27+'[4]Interpolación bñ '!$C$27","v":1.3849130925925909E-3}]
[null,"Deriva del Termómetro Patrón 1",null,null,0,"-","B","R",{"$f":"+IF($E9<200,[4]Incertidumbre!W17,[4]Incertidumbre!W16)","v":0.01},"Ohm",1.7320508075688772,5.773502691896258E-3,"Ohm",1000000,3.9249999999999997E-3,"°C/Ohm",2.2660998065692809E-5,"°C",{"$error":"#REF!"},null,6330,{"$f":"+E9*'[4]Interpolación bñ '!#REF!+'[4]Interpolación bñ '!#REF!","v":{"$error":"#REF!"}},{"$f":"+E9*'[4]Interpolación bñ '!#REF!+'[4]Interpolación bñ '!#REF!","v":{"$error":"#REF!"}}]
[null,"Incertidumbre del indicador",null,null,0,"-","B","N",{"$f":"+IF(E9<200,[4]Incertidumbre!X17,[4]Incertidumbre!X16)","v":{"$error":"#REF!"}},{"$f":"+IF('[4] DATOS 1'!$H$32<200, \"Ohm\", \"mV\")","v":"Ohm"},2,{"$error":"#REF!"},"Ohm",200,3.9249999999999997E-3,"°C/Ohm",{"$error":"#REF!"},"°C",{"$error":"#REF!"}]
[null,"Deriva del indicador",null,null,0,"-","B","R",{"$f":"+IF(E9<200,[4]Incertidumbre!X17/2,X16/2)","v":{"$error":"#REF!"}},{"$f":"+IF('[4] DATOS 1'!$H$32<200, \"Ohm\", \"mV\")","v":"Ohm"},1.7320508075688772,{"$error":"#REF!"},"Ohm",1000000,3.9250999999999999E-3,"°C/Ohm",{"$error":"#REF!"},"°C",{"$error":"#REF!"}]
[null,"Uniformidad del medio",null,null,0,"-","B","R",{"$f":"+IF(+'[4] DATOS 1'!D94=7103,V11,IF('[4] DATOS 1'!D94=6330,V12,IF('[4] DATOS 1'!D94=9150,V10,\"REVISAR\")))","v":"REVISAR"},"°C",1.7320508075688772,{"$error":"#VALUE!"},"°C",1000000,1,"--",{"$error":"#VALUE!"},"°C",{"$error":"#VALUE!"},null,null,"U sensor °C","deriva °C","U indicador ohm","Resolución"]
[null,"Estabilidad",null,null,0,"-","B","R",{"$f":"+IF('[4] DATOS 1'!D94=7103,$W$11,IF('[4] DATOS 1'!D94=6330,$W$12,IF('[4] DATOS 1'!D94=9150,$W$10,\"REVISAR\")))","v":"REVISAR"},"°C",1.7320508075688772,{"$error":"#VALUE!"},"°C",1000000,1,"--",{"$error":"#VALUE!"},"°C",{"$error":"#VALUE!"},null,"Ter Tipo R",{"$f":"+E9^3*'[4]interpolación pat'!$B$28+E9^2*'[4]interpolación pat'!$C$15+E9*'[4]interpolación pat'!$D$25+'[4]interpolación pat'!$E$25","v":0},0.5,{"$f":"+'[4] DATOS 1'!B99^4*#REF!+'[4] DATOS 1'!B99^3*#REF!+'[4] DATOS 1'!B99^2*#REF!+'[4] DATOS 1'!B99*#REF!+#REF!","v":{"$error":"#REF!"}},1.0000000000000001E-5]
[null,"Repetibilidad del Termómetro IBC",null,null,{"$f":"+'[4] DATOS 1'!I100","v":0},"°C","A","N",{"$f":"+'[4] DATOS 1'!I101","v":0},"°C",3,0,"°C",8,1,"--",0,"°C",{"$error":"#REF!"},null,"PRT pt 100",{"$f":"+E9^4*'[4]interpolación pat'!$I$18+E9^3*'[4]interpolación pat'!$J$18+E9^2*'[4]interpolación pat'!$K$18+E9*'[4]interpolación pat'!$L$18+'[4]interpolación pat'!$M$18","v":-1.2470444584388524E-7},0.01,{"$f":"+'[4] DATOS 1'!B99^4*#REF!+'[4] DATOS 1'!B99^3*#REF!+'[4] DATOS 1'!B99^2*#REF!+'[4] DATOS 1'!B99*#REF!+#REF!","v":{"$error":"#REF!"}},1E-4]
[null,"Resolución Indicador ",null,null,0,"-","B","R",{"$f":"+'[4]DATOS 0'!L14","v":0.01},"°C",1.7320508075688772,5.773502691896258E-3,"°C",1000000,1,"--",5.773502691896258E-3,"°C",{"$error":"#REF!"}]
[null,"Variación en cero",null,null,{"$f":"+ABS('[4] DATOS 1'!#REF!-'[4] DATOS 1'!$I$100)","v":{"$error":"#REF!"}},"°C","A","R",{"$f":"+E19/2","v":{"$error":"#REF!"}},"°C",1.7320508075688772,{"$error":"#REF!"},"°C",1000000,1,"--",{"$error":"#REF!"},"°C",{"$error":"#REF!"}]
[null,"Corrección",null,null,{"$f":"+E9-E17","v":2.1111111111111113E-3},"-","A","N",{"$f":"L20*K20","v":{"$error":"#REF!"}},"°C",{"$f":"TINV(0.05,N20)","v":{"$error":"#REF!"}},{"$f":"(SUMSQ(Q9:Q19)^0.5)","v":{"$error":"#REF!"}},"°C",{"$f":"L20^4/(Q9^4/N9+Q10^4/N10+Q11^4/N11+Q12^4/N12+Q13^4/N13+Q14^4/N14+Q15^4/N15+Q16^4/N16+Q17^4/N17+Q18^4/N18+Q19^4/N19)","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"SUM(S9:S19)","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,"Corrección   C (°C)","K",null,"°C"]
[null,null,null,null,{"$f":"+E20","v":2.1111111111111113E-3},{"$f":"K20","v":{"$error":"#REF!"}},"±",{"$f":"I20","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,"SE HACE REDONDEO DE DECIMALES TAL COMO LO RECOMIENDA LA GUM"]
[]
["SP °C",{"$f":"+'[4] DATOS 1'!B28","v":10},null,null,"Valor Estimado","Unidad","Tipo","Distribución","u","Unidad","Factor","Incertidumbre Standard",null,"Grados de Libertad","Coeficiente de Sensibilidad",null,"Contribución a u","Unidad","Porcentaje"]
[null,"Fuente de Incertidumbre",null,null,null,null,null,null,null,null,null,"u tipica","Unidad","G.L.","Ci","Unidad",null,null,"%"]
[1,"Repetibilidad del patrón 1",null,null,{"$f":"+'[4] DATOS 1'!K39","v":9.9681425338177743},"°C","A","N",{"$f":"+'RT03-F55'!K40","v":-1.8678069397539229E-2},"°C",3,{"$f":"I28/K28","v":-6.2260231325130767E-3},{"$f":"+J28","v":"°C"},8,1,"--",{"$f":"ABS(L28*O28)","v":6.2260231325130767E-3},"°C",{"$f":"(Q28*100%)^2/$L$38^2","v":{"$error":"#DIV/0!"}}]
[2,"Incertidumbre del termómetro patrón 1",null,null,0,"°C","B","N",4.3999999999999997E-2,"°C",2,{"$f":"I29/K29","v":2.1999999999999999E-2},{"$f":"+J29","v":"°C"},199.99999999999966,1,"--",2.1999999999999999E-2,"°C",{"$f":"(Q29*100%)^2/$L$38^2","v":{"$error":"#DIV/0!"}}]
[3,"Interpolación corrección patrón",null,null,0,"°C","B","N",{"$f":"+SQRT('interpolación pat'!$C$22/(5-3))","v":6.3803049135771736E-4},"°C",{"$f":"+SQRT(5)","v":2.2360679774997898},2.8533591007868961E-4,"°C",199.99999999999966,1,"--",2.8533591007868961E-4,null,{"$f":"(Q30*100%)^2/$L$38^2","v":{"$error":"#DIV/0!"}}]
[4,"Resolución  patrón",null,null,0,"°C","B","R",1E-3,"°C",1.7320508075688772,5.773502691896258E-4,"°C",1000000,1,"--",5.773502691896258E-4,"°C",{"$error":"#DIV/0!"}]
[5,"Deriva del termómetro patrón 1",null,null,0,"°C","B","R",2.9999999999999997E-4,"°C",1.7320508075688772,1.7320508075688773E-4,"°C",1000000,1,"--",1.7320508075688773E-4,"°C",{"$error":"#DIV/0!"}]
[6,"Uniformidad del medio",null,null,0,"°C","B","R",{"$f":"+'Interpolación bñ '!C8","v":6.8000000000000005E-2},"°C",1.7320508075688772,3.9259818304894556E-2,"°C",1000000,1,"--",3.9259818304894556E-2,"°C",{"$error":"#DIV/0!"}]
[7,"Estabilidad",null,null,0,"°C","B","R",{"$f":"+'Interpolación bñ '!D8","v":7.0199999999999999E-2},"°C",1.7320508075688772,4.0529988897111728E-2,"°C",1000000,1,"--",4.0529988897111728E-2,"°C",{"$error":"#DIV/0!"}]
[8,"Repetibilidad del termómetro IBC",null,null,{"$f":"+'[4] DATOS 1'!D39","v":10.019999999999998},"°C","A","N",{"$f":"+'RT03-F55'!D40","v":{"$error":"#DIV/0!"}},"°C",3,{"$error":"#DIV/0!"},"°C",8,1,"--",{"$error":"#DIV/0!"},"°C",{"$error":"#DIV/0!"}]
[9,"Resolución indicador IBC",null,null,0,"°C","B","R",{"$f":"+'DATOS 0'!L14","v":0},"°C",1.7320508075688772,0,"°C",1000000,1,"--",0,"°C",{"$error":"#DIV/0!"}]
[10,"Variación a cero",null,null,0,"°C","A","R",{"$f":"+ABS('RT03-F55'!B24-'RT03-F55'!B99)","v":0},"°C",1.7320508075688772,0,"°C",1000000,1,"--",0,"°C",{"$error":"#DIV/0!"}]
[null,"Corrección",null,null,{"$f":"+E28-E35","v":-5.1857466182223533E-2},"°C","A","N",{"$f":"L38*K38","v":{"$error":"#DIV/0!"}},"°C",{"$f":"TINV(0.05,N38)","v":{"$error":"#DIV/0!"}},{"$f":"(SUMSQ(Q28:Q37)^0.5)","v":{"$error":"#DIV/0!"}},"°C",{"$f":"L38^4/(Q28^4/N28+Q29^4/N29++Q30^4/N30+Q31^4/N31+Q32^4/N32+Q33^4/N33+Q34^4/N34+Q35^4/N35+Q36^4/N36+Q37^4/N37)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"SUM(S28:S37)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,"Corrección   C (°C)","K",null,"°C"]
[null,null,null,null,{"$f":"+E38","v":-5.1857466182223533E-2},{"$f":"K38","v":{"$error":"#DIV/0!"}},"±",{"$f":"I38","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
["SP °C",{"$f":"+'[4] DATOS 1'!B43","v":20},null,null,"Valor Estimado","Unidad","Tipo","Distribución","u","Unidad","Factor","Incertidumbre Standard",null,"Grados de Libertad","Coeficiente de Sensibilidad",null,"Contribución a u","Unidad","Porcentaje"]
[null,"Fuente de Incertidumbre",null,null,null,null,null,null,null,null,null,"u tipica","Unidad","G.L.","Ci","Unidad",null,null,"%"]
[1,"Repetibilidad del patrón 1",null,null,{"$f":"+'[4] DATOS 1'!K54","v":20.011435741884764},"°C","A","N",{"$f":"+'RT03-F55'!K55","v":-1.8678069397539229E-2},"°C",3,{"$f":"I47/K47","v":-6.2260231325130767E-3},{"$f":"+J47","v":"°C"},8,1,"--",{"$f":"ABS(L47*O47)","v":6.2260231325130767E-3},"°C",{"$f":"(Q47*100%)^2/$L$57^2","v":{"$error":"#DIV/0!"}},null,null,"Uniformidad °C","Estabilidad °C"]
[2,"Incertidumbre del termómetro patrón 1",null,null,0,"-","B","N",4.3999999999999997E-2,"°C",2,{"$f":"I48/K48","v":2.1999999999999999E-2},{"$f":"+J48","v":"°C"},199.99999999999966,1,"--",{"$f":"ABS(L48*O48)","v":2.1999999999999999E-2},"°C",{"$f":"(Q48*100%)^2/$L$57^2","v":{"$error":"#DIV/0!"}},null,9150,{"$f":"+[4]Incertidumbre!E47^2*'[4]Interpolación bñ '!#REF!++[4]Incertidumbre!E47*'[4]Interpolación bñ '!#REF!+'[4]Interpolación bñ '!#REF!","v":{"$error":"#REF!"}},{"$f":"+E47^2*'[4]Interpolación bñ '!#REF!+E47*'[4]Interpolación bñ '!#REF!+'[4]Interpolación bñ '!#REF!","v":{"$error":"#REF!"}}]
[3,"Interpolación corrección patrón",null,null,0,"-","B","N",{"$f":"+SQRT('interpolación pat'!$C$22/(5-3))","v":6.3803049135771736E-4},"°C",{"$f":"+K30","v":2.2360679774997898},2.8533591007868961E-4,"°C",199.99999999999966,1,"--",2.8533591007868961E-4,null,{"$error":"#DIV/0!"}]
[4,"Resolución  patrón",null,null,0,"-","B","R",1E-3,"°C",1.7320508075688772,5.773502691896258E-4,"°C",1000000,1,"--",5.773502691896258E-4,"°C",{"$error":"#DIV/0!"},null,7103,{"$f":"+E47*'[4]Interpolación bñ '!$B$20+'[4]Interpolación bñ '!$C$20","v":-1.0217279095811214E-5},{"$f":"+E47*'[4]Interpolación bñ '!$B$27+'[4]Interpolación bñ '!$C$27","v":5.6119589529240955E-4}]
[5,"Deriva del termómetro patrón 1",null,null,0,"-","B","R",{"$f":"+I32","v":2.9999999999999997E-4},"°C",1.7320508075688772,1.7320508075688773E-4,"°C",1000000,1,"--",1.7320508075688773E-4,"°C",{"$error":"#DIV/0!"},null,6330,{"$f":"+E47*'[4]Interpolación bñ '!#REF!+'[4]Interpolación bñ '!#REF!","v":{"$error":"#REF!"}},{"$f":"+E47*'[4]Interpolación bñ '!#REF!+'[4]Interpolación bñ '!#REF!","v":{"$error":"#REF!"}}]
[6,"Uniformidad del medio",null,null,0,"-","B","R",{"$f":"+'Interpolación bñ '!C9","v":6.6000000000000003E-2},"°C",1.7320508075688772,3.8105117766515303E-2,"°C",1000000,1,"--",3.8105117766515303E-2,"°C",{"$error":"#DIV/0!"},null,null,"U sensor °C","deriva °C","U indicador ohm","Resolución"]
[7,"Estabilidad",null,null,0,"-","B","R",{"$f":"+'Interpolación bñ '!D9","v":7.17E-2},"°C",1.7320508075688772,4.1396014300896171E-2,"°C",1000000,1,"--",4.1396014300896171E-2,"°C",{"$error":"#DIV/0!"},null,"Ter Tipo R",{"$f":"+'[4] DATOS 1'!B54^3*'[4]interpolación pat'!$B$28+'[4] DATOS 1'!B54^2*'[4]interpolación pat'!$C$15+'[4] DATOS 1'!B54*'[4]interpolación pat'!$D$25+'[4]interpolación pat'!$E$25","v":0},0.5,{"$f":"+E47^4*#REF!+E47^3*#REF!+E47^2*#REF!+E47*#REF!+#REF!","v":{"$error":"#REF!"}},1.0000000000000001E-5]
[8,"Repetibilidad del termómetro IBC",null,null,{"$f":"+'[4] DATOS 1'!D54","v":20.04111111111111},"°C","A","N",{"$f":"+'RT03-F55'!D55","v":{"$error":"#DIV/0!"}},"°C",3,{"$error":"#DIV/0!"},"°C",8,1,"--",{"$error":"#DIV/0!"},"°C",{"$error":"#DIV/0!"},null,"PRT pt 100",{"$f":"+E47^4*'[4]interpolación pat'!$I$18+E47^3*'[4]interpolación pat'!$J$18+E47^2*'[4]interpolación pat'!$K$18+E47*'[4]interpolación pat'!$L$18+'[4]interpolación pat'!$M$18","v":-25.865038884985367},0.01,{"$f":"'[4] DATOS 1'!B54^4*#REF!+'[4] DATOS 1'!B54^3*#REF!+'[4] DATOS 1'!B54^2*#REF!+'[4] DATOS 1'!B54*#REF!+#REF!","v":{"$error":"#REF!"}},1E-4]
[9,"Resolución indicador IBC",null,null,0,"-","B","R",{"$f":"+I36","v":0},"°C",1.7320508075688772,0,"°C",1000000,1,"--",0,"°C",{"$error":"#DIV/0!"}]
[10,"Variación en cero",null,null,1,"-","A","R",{"$f":"+I37","v":0},"°C",1.7320508075688772,0,"°C",1000000,1,"--",0,"°C",{"$error":"#DIV/0!"}]
[null,"Corrección",null,null,{"$f":"+E47-E54","v":-2.9675369226346504E-2},"-","A","N",{"$f":"L57*K57","v":{"$error":"#DIV/0!"}},"°C",{"$f":"TINV(0.05,N57)","v":{"$error":"#DIV/0!"}},{"$f":"(SUMSQ(Q47:Q56)^0.5)","v":{"$error":"#DIV/0!"}},"°C",{"$f":"L57^4/(Q47^4/N47+Q48^4/N48+Q49^4/N49+Q50^4/N50+Q51^4/N51+Q52^4/N52+Q53^4/N53+Q54^4/N54+Q55^4/N55+Q56^4/N56)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"SUM(S47:S56)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,"Corrección   C (°C)","K",null,"°C",null,null,null,null,null,null,null,{"$f":"100-0.05","v":99.95}]
[null,null,null,null,{"$f":"+E57","v":-2.9675369226346504E-2},{"$f":"K57","v":{"$error":"#DIV/0!"}},"±",{"$f":"I57","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
["SP °C",{"$f":"+'[4] DATOS 1'!B58","v":40},null,null,"Valor Estimado","Unidad","Tipo","Distribución","u","Unidad","Factor","Incertidumbre Standard",null,"Grados de Libertad","Coeficiente de Sensibilidad",null,"Contribución a u","Unidad","Porcentaje"]
[null,"Fuente de Incertidumbre",null,null,null,null,null,null,null,null,null,"u tipica","Unidad","G.L.","Ci","Unidad",null,null,"%"]
[1,"Repetibilidad del patrón 1",null,null,{"$f":"+'[4] DATOS 1'!K69","v":39.930025914972326},"°C","A","N",{"$f":"+'RT03-F55'!B70","v":{"$error":"#DIV/0!"}},"°C",3,{"$f":"I66/K66","v":{"$error":"#DIV/0!"}},{"$f":"+J66","v":"°C"},8,1,"--",{"$f":"ABS(L66*O66)","v":{"$error":"#DIV/0!"}},"°C",{"$f":"(Q66*100%)^2/$L$76^2","v":{"$error":"#DIV/0!"}},null,null,"Uniformidad °C","Estabilidad °C"]
[2,"Incertidumbre del termómetro patrón 1",null,null,0,"-","B","N",4.3999999999999997E-2,"°C",2,{"$f":"I67/K67","v":2.1999999999999999E-2},{"$f":"+J67","v":"°C"},199.99999999999966,1,"--",{"$f":"ABS(L67*O67)","v":2.1999999999999999E-2},"°C",{"$f":"(Q67*100%)^2/$L$76^2","v":{"$error":"#DIV/0!"}},null,9150,{"$f":"+[4]Incertidumbre!E66^2*'[4]Interpolación bñ '!#REF!++[4]Incertidumbre!E66*'[4]Interpolación bñ '!#REF!+'[4]Interpolación bñ '!#REF!","v":{"$error":"#REF!"}},{"$f":"+E66^2*'[4]Interpolación bñ '!#REF!+E66*'[4]Interpolación bñ '!#REF!+'[4]Interpolación bñ '!#REF!","v":{"$error":"#REF!"}}]
[3,"Interpolación corrección patrón",null,null,0,"-","B","N",4.3999999999999997E-2,"°C",{"$f":"+K49","v":2.2360679774997898},1.9677398201998146E-2,"°C",199.99999999999966,1,"--",1.9677398201998146E-2,null,{"$error":"#DIV/0!"}]
[4,"Resolución indicador patrón",null,null,0,"-","B","R",1E-3,"°C",1.7320508075688772,5.773502691896258E-4,"°C",1000000,1,"--",5.773502691896258E-4,"°C",{"$error":"#DIV/0!"},null,7103,{"$f":"+E66*'[4]Interpolación bñ '!$B$20+'[4]Interpolación bñ '!$C$20","v":-3.8867049238447464E-4},{"$f":"+E66*'[4]Interpolación bñ '!$B$27+'[4]Interpolación bñ '!$C$27","v":-2.5878606683302783E-4}]
[5,"Deriva del termómetro patrón 1",null,null,0,"-","B","R",{"$f":"+I51","v":2.9999999999999997E-4},"°C",1.7320508075688772,1.7320508075688773E-4,"°C",1000000,1,"--",1.7320508075688773E-4,"°C",{"$error":"#DIV/0!"},null,6330,{"$f":"+E66*'[4]Interpolación bñ '!#REF!+'[4]Interpolación bñ '!#REF!","v":{"$error":"#REF!"}},{"$f":"+E66*'[4]Interpolación bñ '!#REF!+'[4]Interpolación bñ '!#REF!","v":{"$error":"#REF!"}}]
[6,"Uniformidad del medio",null,null,0,"-","B","R",{"$f":"+'Interpolación bñ '!C9","v":6.6000000000000003E-2},"°C",1.7320508075688772,3.8105117766515303E-2,"°C",1000000,1,"--",3.8105117766515303E-2,"°C",{"$error":"#DIV/0!"},null,null,"U sensor °C","deriva °C","U indicador ohm","Resolución"]
[7,"Estabilidad",null,null,0,"-","B","R",{"$f":"+'Interpolación bñ '!D9","v":7.17E-2},"°C",1.7320508075688772,4.1396014300896171E-2,"°C",1000000,1,"--",4.1396014300896171E-2,"°C",{"$error":"#DIV/0!"},null,"Ter Tipo R",{"$f":"+'[4] DATOS 1'!B73^3*'[4]interpolación pat'!$B$28+'[4] DATOS 1'!B73^2*'[4]interpolación pat'!$C$15+'[4] DATOS 1'!B73*'[4]interpolación pat'!$D$25+'[4]interpolación pat'!$E$25","v":0},0.5,{"$f":"+E66^4*#REF!+E66^3*#REF!+E66^2*#REF!+E66*#REF!+#REF!","v":{"$error":"#REF!"}},1.0000000000000001E-5]
[8,"Repetibilidad del termómetro IBC",null,null,{"$f":"+'[4] DATOS 1'!D69","v":40.03},"°C","A","N",{"$f":"+'RT03-F55'!D70","v":{"$error":"#DIV/0!"}},"°C",3,{"$error":"#DIV/0!"},"°C",8,1,"--",{"$error":"#DIV/0!"},"°C",{"$error":"#DIV/0!"},null,"PRT pt 100",{"$f":"+E66^4*'[4]interpolación pat'!$I$18+E66^3*'[4]interpolación pat'!$J$18+E66^2*'[4]interpolación pat'!$K$18+E66*'[4]interpolación pat'!$L$18+'[4]interpolación pat'!$M$18","v":-154.7433941125895},0.01,{"$f":"'[4] DATOS 1'!B73^4*#REF!+'[4] DATOS 1'!B73^3*#REF!+'[4] DATOS 1'!B73^2*#REF!+'[4] DATOS 1'!B73*#REF!+#REF!","v":{"$error":"#REF!"}},1E-4]
[9,"Resolución indicador IBC",null,null,0,"-","B","R",{"$f":"+I55","v":0},"°C",1.7320508075688772,0,"°C",1000000,1,"--",0,"°C",{"$error":"#DIV/0!"}]
[10,"Variación en cero",null,null,1,"-","A","R",{"$f":"+I56","v":0},"°C",1.7320508075688772,0,"°C",1000000,1,"--",0,"°C",{"$error":"#DIV/0!"}]
[null,"Corrección",null,null,{"$f":"+E66-E73","v":-9.997408502767513E-2},"-","A","N",{"$f":"L76*K76","v":{"$error":"#DIV/0!"}},"°C",{"$f":"TINV(0.05,N76)","v":{"$error":"#DIV/0!"}},{"$f":"(SUMSQ(Q66:Q75)^0.5)","v":{"$error":"#DIV/0!"}},"°C",{"$f":"L76^4/(Q66^4/N66+Q67^4/N67+Q68^4/N68+Q69^4/N69+Q70^4/N70+Q71^4/N71+Q72^4/N72+Q73^4/N73+Q74^4/N74+Q75^4/N75)","v":{"$error":"#DIV/0!"}},null,null,null,null,{"$f":"SUM(S66:S75)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,"Corrección   C (°C)","K",null,"°C"]
[null,null,null,null,{"$f":"+E76","v":-9.997408502767513E-2},{"$f":"+K76","v":{"$error":"#DIV/0!"}},"±",{"$f":"+I76","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
["SP °C",{"$f":"+'[4] DATOS 1'!B73","v":190},null,null,null,null,null,null,null,null,null,"Incertidumbre Standard",null,"Grados de Libertad","Coeficiente de Sensibilidad",null,null,null,"Porcentaje"]
[null,"Fuente de Incertidumbre",null,null,"Valor Estimado","Unidad","Tipo","Distribución","u","Unidad","Factor","u tipica","Unidad","G.L.","Ci","Unidad","Contribución a u","Unidad","%"]
[null,"Repetibilidad del Patrón 1",null,null,{"$f":"+'[4] DATOS 1'!B75","v":192.3},"°C","A","N",{"$f":"+'[4] DATOS 1'!B85","v":5.270462766946999E-2},"°C",3,{"$f":"I85/K85","v":1.7568209223156665E-2},{"$f":"+J85","v":"°C"},8,1,"--",{"$f":"ABS(L85*O85)","v":1.7568209223156665E-2},"°C",{"$f":"(Q85*100%)^2/$L$76^2","v":{"$error":"#DIV/0!"}},null,null,"Uniformidad °C","Estabilidad °C"]
[null,"Incertidumbre del Termómetro Patrón 1",null,null,0,"-","B","N",{"$f":"+IF(E85<200,V93,V92)","v":-7918.5698333301916},"°C",2,{"$f":"I86/K86","v":-3959.2849166650958},{"$f":"+J86","v":"°C"},199.99999999999966,1,"--",3959.2849166650958,"°C",{"$f":"(Q86*100%)^2/$L$76^2","v":{"$error":"#DIV/0!"}},null,9150,{"$f":"+[4]Incertidumbre!E85^2*'[4]Interpolación bñ '!#REF!++[4]Incertidumbre!E85*'[4]Interpolación bñ '!#REF!+'[4]Interpolación bñ '!#REF!","v":{"$error":"#REF!"}},{"$f":"+E85^2*'[4]Interpolación bñ '!#REF!+E85*'[4]Interpolación bñ '!#REF!+'[4]Interpolación bñ '!#REF!","v":{"$error":"#REF!"}}]
[null,"Resolución Indicador patrón",null,null,0,"-","B","R",1E-3,"Ohm",1.7320508075688772,5.773502691896258E-4,"Ohm",1000000,3.9249999999999997E-3,"°C/Ohm",2.2660998065692812E-6,"°C",{"$error":"#DIV/0!"},null,7103,{"$f":"+E85*'[4]Interpolación bñ '!$B$20+'[4]Interpolación bñ '!$C$20","v":-3.2836999999999988E-3},{"$f":"+E85*'[4]Interpolación bñ '!$B$27+'[4]Interpolación bñ '!$C$27","v":-6.5313499999999974E-3}]
[null,"Deriva del Termómetro Patrón 1",null,null,0,"-","B","R",{"$f":"+IF($E85<200,[4]Incertidumbre!W93,[4]Incertidumbre!W92)","v":0.01},"°C",1.7320508075688772,5.773502691896258E-3,"°C",1000000,1,"--",5.773502691896258E-3,"°C",{"$error":"#DIV/0!"},null,6330,{"$f":"+E85*'[4]Interpolación bñ '!#REF!+'[4]Interpolación bñ '!#REF!","v":{"$error":"#REF!"}},{"$f":"+E85*'[4]Interpolación bñ '!#REF!+'[4]Interpolación bñ '!#REF!","v":{"$error":"#REF!"}}]
[null,"Incertidumbre del indicador",null,null,0,"-","B","R",{"$f":"+IF(E85<200,[4]Incertidumbre!X93,[4]Incertidumbre!X92)","v":{"$error":"#REF!"}},{"$f":"+IF('[4] DATOS 1'!$H$32<200, \"Ohm\", \"mV\")","v":"Ohm"},2,{"$error":"#REF!"},"Ohm",200,3.9249999999999997E-3,"--",{"$error":"#REF!"},"°C",{"$error":"#REF!"}]
[null,"Deriva del indicador",null,null,0,"-","B","R",{"$f":"+IF(E85<200,[4]Incertidumbre!X93,X92)","v":{"$error":"#REF!"}},{"$f":"+IF('[4] DATOS 1'!$H$32<200, \"Ohm\", \"mV\")","v":"Ohm"},1.7320508075688772,{"$error":"#REF!"},"Ohm",1000000,3.9250999999999999E-3,"°C/Ohm",{"$error":"#REF!"},"°C",{"$error":"#REF!"}]
[null,"Uniformidad del medio",null,null,0,"-","B","R",{"$f":"+IF('[4] DATOS 1'!E77=7103,V87,IF('[4] DATOS 1'!E77=6330,V88,IF('[4] DATOS 1'!E77=9150,V86,\"REVISAR\")))","v":{"$error":"#REF!"}},"°C",1.7320508075688772,{"$error":"#REF!"},"°C",1000000,1,"--",{"$error":"#REF!"},"°C",{"$error":"#REF!"},null,null,"U sensor °C","deriva °C","U indicador ohm","Resolución"]
[null,"Estabilidad",null,null,0,"-","B","R",{"$f":"+IF('[4] DATOS 1'!E77=7103,W87,IF('[4] DATOS 1'!E77=6330,W88,IF('[4] DATOS 1'!E77=9150,W86,\"REVISAR\")))","v":{"$error":"#REF!"}},"°C",1.7320508075688772,{"$error":"#REF!"},"°C",1000000,1,"--",{"$error":"#REF!"},"°C",{"$error":"#REF!"},null,"Ter Tipo R",{"$f":"'[4] DATOS 1'!B838^3*'[4]interpolación pat'!$B$28+'[4] DATOS 1'!B84^2*'[4]interpolación pat'!$C$15+'[4] DATOS 1'!B84*'[4]interpolación pat'!$D$25+'[4]interpolación pat'!$E$25","v":0},0.5,{"$f":"+'[4] DATOS 1'!B84^4*#REF!+'[4] DATOS 1'!B84^3*#REF!+'[4] DATOS 1'!B84^2*#REF!+'[4] DATOS 1'!B84*#REF!+#REF!","v":{"$error":"#REF!"}},1.0000000000000001E-5]
[null,"Repetibilidad del Termómetro IBC",null,null,{"$f":"+'[4] DATOS 1'!C84","v":193.35555555555558},"°C","A","N",{"$f":"+'[4] DATOS 1'!C85","v":5.2704627669469997E-2},"Ohm",3,1.7568209223156665E-2,"Ohm",8,3.9249999999999997E-3,"--",6.89552212008899E-5,"°C",{"$error":"#DIV/0!"},null,"PRT pt 100",{"$f":"+(E85^4*'[4]interpolación pat'!$I$18+E85^3*'[4]interpolación pat'!$J$18+E85^2*'[4]interpolación pat'!$K$18+E85*'[4]interpolación pat'!$L$18+'[4]interpolación pat'!$M$18)","v":-7918.5698333301916},0.01,{"$f":"+'[4] DATOS 1'!B84^4*#REF!+'[4] DATOS 1'!B84^3*#REF!+'[4] DATOS 1'!B84^2*#REF!+'[4] DATOS 1'!B84*#REF!+#REF!","v":{"$error":"#REF!"}},1E-4]
[null,"Resolución Indicador patrón",null,null,0,"-","B","R",1E-3,"Ohm",1.7320508075688772,5.773502691896258E-4,"Ohm",1000000,3.9249999999999997E-3,"°C/Ohm",2.2660998065692812E-6,"°C",{"$error":"#DIV/0!"}]
[null,"Variación en cero",null,null,{"$f":"+ABS('[4] DATOS 1'!#REF!-'[4] DATOS 1'!$I$100)","v":{"$error":"#REF!"}},"Ohm","A","R",{"$f":"+E95/2","v":{"$error":"#REF!"}},"°C",1.7320508075688772,{"$error":"#REF!"},"°C",1000000,1,"--",{"$error":"#REF!"},"°C",{"$f":"(Q95*100%)^2/$L$96^2","v":{"$error":"#REF!"}}]
[null,"Corrección",null,null,{"$f":"+E85-E93","v":-1.0555555555555713},"-","A","N",{"$f":"L96*K96","v":{"$error":"#REF!"}},"°C",{"$f":"TINV(0.05,N96)","v":{"$error":"#REF!"}},{"$f":"(SUMSQ(Q85:Q95)^0.5)","v":{"$error":"#REF!"}},"°C",{"$f":"L96^4/(Q85^4/N85+Q86^4/N86+Q87^4/N87+Q88^4/N88+Q89^4/N89+Q90^4/N90+Q91^4/N91+Q92^4/N92+Q93^4/N93+Q94^4/N94+Q95^4/N95)","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"SUM(S85:S95)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Corrección   C (°C)","K",null,"°C"]
[null,null,null,null,{"$f":"+E96","v":-1.0555555555555713},{"$f":"+K95","v":1.7320508075688772},"±",{"$f":"+I96","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,"SE HACE REDONDEO DE DECIMALES TAL COMO LO RECOMIENDA LA GUM"]

{"sheet":"interpolación pat","index":4,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":true,"merged":[[4,1,4,3],[4,8,4,10],[0,0,2,2],[0,3,2,15],[40,8,40,12],[29,14,29,15],[40,14,40,15],[5,1,5,3],[5,8,5,10],[25,1,25,5],[29,8,29,12],[15,1,15,3],[15,8,15,10]]}
[null,null,null,"HOJA DE CÁLCULO PARA CALIBRACIÓN DE TERMÓMETROS DIGITALES"]
[]
[]
[]
[null,"\n2022-02-16  N° 5736",null,null,null,null,null,null,"2022-02-16  N° 5737"]
[null,"Patrón 1",null,null,null,null,null,null,"Patrón 2"]
[null,"Valor Medido °C","Corrección °C","U °C",null,null,null,null,"Valor Medido °C","Corrección °C","ohm"]
[null,0,-1.9E-2,1.2999999999999999E-2]
[null,10,-3.3000000000000002E-2,4.3999999999999997E-2,null,{"$f":"+B9^2*$B$18+B9*$C$18+$D$18","v":-3.3435468813888085E-2},{"$f":"+ABS(C9-F9)","v":4.3546881388808328E-4},null,10.013999999999999,-4.7E-2,4.3999999999999997E-2]
[null,20.003,-4.7E-2,4.3999999999999997E-2,null,{"$f":"+B10^2*$B$18+B10*$C$18+$D$18","v":-4.7375213529750729E-2},{"$f":"+ABS(C10-F10)","v":3.7521352975072864E-4},null,20.021000000000001,-6.4000000000000001E-2,4.3999999999999997E-2]
[null,29.997,-6.0999999999999999E-2,4.3999999999999997E-2,null,-6.0481320335218691E-2,5.1867966478130745E-4,null,30.018000000000001,-8.2000000000000003E-2,4.3999999999999997E-2]
[null,40.002000000000002,-7.2999999999999995E-2,4.3999999999999997E-2,null,-7.2779770650605036E-2,2.2022934939495975E-4,null,40.027000000000001,-9.7000000000000003E-2,4.3999999999999997E-2]
[null,50.002000000000002,-8.4000000000000005E-2,4.3999999999999997E-2,null,-8.4250157272998213E-2,2.5015727299820822E-4,null,50.03,-0.112,4.3999999999999997E-2]
[null,null,null,null,null,null,{"$f":"+SUMSQ(G9:G13)","v":7.1052650300357185E-7}]
[]
[null,"Lectura",null,null,null,null,null,null,"Lectura"]
["grado poli",2,1,0,0,null,null,null,2,1,0]
["coef",{"$f":"+LINEST(C8:C13,B8:B13^{1,2},1,1)","v":4.1085605644163595E-6},-1.516825547279049E-3,-1.8678069397539229E-2,{"$error":"#N/A"},{"$error":"#N/A"},null,null,{"$f":"+LINEST(J9:J13,I9:I13^{1,2},1,1)","v":5.0002811349297785E-6},-1.929617278306561E-3,-2.7976702323079423E-2]
[null,8.5250059878644684E-7,4.4408635150805864E-5,4.7214989577408105E-4,{"$error":"#N/A"},{"$error":"#N/A"},null,null,1.7043826016625401E-6,1.0430976974308578E-4,1.3699167758207656E-3]
[null,0.99973012568947428,5.2094971472121335E-4,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,0.99969385003053801,6.382500680502057E-4,{"$error":"#N/A"}]
[null,5556.6429632111976,3,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,3265.37301894042,2,{"$error":"#N/A"}]
[null,3.0160191675175289E-3,8.1416581580434053E-7,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},null,null,2.6603852737012677E-3,8.147262987321845E-7,{"$error":"#N/A"}]
[]
[]
[]
[null,"INCERTIDUMBRE"]
[null,3,2,1,0]
[null,{"$f":"+LINEST(D9:D11,B9:B11^{1,2},1,1)","v":0},0,4.4000000000000004E-2,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,0,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]

{"sheet":"Interpol TH","index":5,"n_rows":19,"n_cols":8,"rows_kept":19,"cut":false,"hidden":true,"merged":[[12,1,12,3],[12,5,12,7],[0,0,2,1],[0,2,2,7],[4,1,4,3],[4,5,4,7],[5,1,5,3],[5,5,5,7]]}
[null,null,"HOJA DE CÁLCULO PARA CALIBRACIÓN DE TERMÓMETROS DIGITALES"]
[]
[]
[]
[null,"Número de certificado y fecha de calibración\n5720, 2021-01-27",null,null,null,"Número de certificado y fecha de calibración\n5717, 2021-01-27"]
[null,"Temperatura  °C",null,null,null,"Humedad % hr"]
[null,"V medido","Corrección","U",null,"V medido","Corrección","U"]
[null,9.6999999999999993,0.2,0.2,null,37.1,-7.1,1.7]
[null,24.9,0.2,0.2,null,54.2,-4.2,1.7]
[null,40,0.1,0.2,null,79.8,1.2,1.7]
[]
[]
[null,"Interpolación",null,null,null,"Interpolación"]
[null,"m","b",null,null,"m","b"]
[null,{"$f":"+LINEST(C8:C10,B8:B10,TRUE,TRUE)","v":-3.296687337525596E-3},0.24864429179313646,{"$error":"#N/A"},null,{"$f":"+LINEST(G8:G10,F8:F10,TRUE,TRUE)","v":0.19567963162111254},-14.526928323457453,{"$error":"#N/A"}]
[null,1.9117280940969645E-3,5.3095358346903605E-2,{"$error":"#N/A"},null,1.1313403396893866E-2,0.67508858069298194,{"$error":"#N/A"}]
[null,0.74834802561831038,4.0959490099502754E-2,{"$error":"#N/A"},null,0.99666845247259106,0.34383937614723514,{"$error":"#N/A"}]
[null,2.973741920590951,1,{"$error":"#N/A"},null,299.1608086851229,1,{"$error":"#N/A"}]
[null,4.9889868374554036E-3,1.6776798292112642E-3,{"$error":"#N/A"},null,35.368441150077345,0.11822551658931986,{"$error":"#N/A"}]

{"sheet":"Interpolación bñ ","index":6,"n_rows":29,"n_cols":6,"rows_kept":29,"cut":false,"hidden":true,"merged":[[0,0,2,1],[0,2,2,7],[5,1,5,3],[17,1,17,5],[24,1,24,5],[4,4,4,7],[3,1,4,3]]}
[null,null,"HOJA DE CÁLCULO PARA CALIBRACIÓN DE TERMÓMETROS DIGITALES"]
[]
[]
[null,"Número de certificado y fecha de calibración"]
[]
[null,"Polysicience"]
[null,"VALOR MEDIDO","UNIFORMIDAD","ESTABILIDAD"]
[null,10,6.8000000000000005E-2,7.0199999999999999E-2]
[null,20,6.6000000000000003E-2,7.17E-2]
[null,50,3.7199999999999997E-2,2.6800000000000001E-2]
[]
[null,{"$f":"+LINEST(C8:C10,B8:B10^{2},1,1)","v":-1.3157894736842108E-5},7.0224561403508787E-2,{"$error":"#N/A"}]
[null,7.4954245473740733E-7,1.0964860818592664E-3,{"$error":"#N/A"}]
[null,0.99676545916776138,1.3861470011409041E-3,{"$error":"#N/A"}]
[null,308.16289262235352,1,{"$error":"#N/A"}]
[]
[]
[null,"Uniformidad"]
[null,2,1,0]
[null,{"$f":"+LINEST(C8:C10,B8:B10^{1,2},1,1)","v":-1.8999999999999987E-5},3.6999999999999907E-4,6.6200000000000023E-2,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,0,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[]
[null,"Estabilidad"]
[null,2,1,0]
[null,{"$f":"+LINEST(D8:D10,B8:B10^{1,2},1,1)","v":-4.116666666666664E-5},1.3849999999999984E-3,6.0466666666666676E-2,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,0,0,0,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,1,0,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]

{"sheet":"RT03-F56","index":7,"n_rows":121,"n_cols":17,"rows_kept":121,"cut":false,"hidden":false,"merged":[[112,1,112,4],[112,7,112,10],[113,1,113,4],[113,7,113,10],[92,9,92,10],[96,1,96,11],[97,1,97,11],[98,1,98,11],[99,1,99,11],[43,0,45,11],[40,9,40,10],[14,3,14,11],[15,3,15,11],[16,3,16,11],[17,3,17,11],[20,0,20,11],[22,0,22,10],[41,0,41,4],[23,0,23,10],[24,0,24,3],[24,4,24,7],[26,0,26,7],[35,0,35,1],[35,2,35,3],[32,0,32,4],[36,2,36,3],[36,0,36,1],[9,7,9,8],[28,0,30,11],[34,0,34,11],[9,9,9,10],[19,0,19,3],[19,4,19,7],[9,0,9,1],[13,0,13,2],[15,0,15,2],[16,0,16,2],[17,0,17,2],[18,0,18,2],[13,3,13,11],[11,0,11,11],[53,4,53,5],[53,7,53,8],[52,7,52,8],[0,0,0,10],[2,9,2,10],[3,0,3,3],[5,0,5,1],[5,3,5,10],[6,0,6,1],[6,3,6,10],[10,0,10,1],[10,3,10,5],[7,0,7,1],[7,3,7,10],[14,0,14,2],[9,4,9,5],[111,13,111,15],[47,0,47,4],[107,1,107,10],[109,0,109,3],[111,5,111,7],[57,9,58,9],[49,0,49,10],[51,0,51,2],[79,0,79,11],[88,0,88,11],[51,4,51,5],[52,0,52,2],[52,4,52,5],[51,7,51,8],[55,0,55,10],[53,0,53,2],[120,0,120,10],[116,2,116,5],[118,1,118,2],[118,8,118,9],[94,0,94,5],[115,7,115,10],[100,1,100,11],[101,1,101,11],[102,1,102,11],[103,1,103,11],[104,1,104,11],[114,1,114,4],[114,7,114,10],[115,1,115,4],[105,1,105,11],[106,1,106,11]]}
[]
[]
[null,null,null,null,null,null,null,null,"Certificado N°",{"$f":"+'DATOS 0'!M5","v":0}]
["Información del Cliente"]
[]
["Solicitante:",null,null,{"$f":"+'DATOS 0'!D5","v":0}]
["Dirección:",null,null,{"$f":"+'DATOS 0'!D6","v":0}]
["Ciudad :",null,null,{"$f":"+'DATOS 0'!D7","v":0}]
[]
["Fecha de recepción:",null,null,{"$f":"'DATOS 0'!D8","v":"00:00:00"},null,null,null,"Fecha de calibración:",null,{"$f":"'DATOS 0'!D9","v":"00:00:00"}]
[]
["1.   INFORMACIÓN DEL EQUIPO SOMETIDO A CALIBRACIÓN"]
[]
["Objeto:",null,null,{"$f":"'DATOS 0'!D13","v":0}]
["Fabricante:",null,null,{"$f":"'DATOS 0'!D14","v":0}]
["Número de serie:",null,null,{"$f":"+'DATOS 0'!D16","v":0}]
["Modelo:",null,null,{"$f":"'DATOS 0'!D15","v":"00:00:00"}]
["Intervalo de calibración:",null,null,{"$f":"CONCATENATE('DATOS 0'!L13,\" \",'DATOS 0'!N13,\" a\",\" \",'DATOS 0'!M13,\" \",'DATOS 0'!N13)","v":"  a  "}]
["Resolución:",null,null,{"$f":"'DATOS 0'!L14","v":0},"°C"]
[]
["2.   LUGAR Y DIRECCIÓN DE CALIBRACIÓN"]
[]
["Laboratorio de calibración de temperatura, avenida carrera 50 # 26-55, interior 2 del CAN"]
[]
["3.   CÓDIGO INTERNO",null,null,null,{"$f":"+'DATOS 0'!M6","v":0}]
[]
["4.   MÉTODO DE CALIBRACIÓN UTILIZADO "]
[]
["Para la calibración del termómetro digital, se utilizó el método  establecido en el documento normativo Guía para aa calibración de termómetros digitales con sensor tipo Prt, termistor y termopar en baños líquidos y hornos de bloque metálico  INM/Gtm-T/01. Bogotá, D.C. 2019-12-05 Versión No. 1."]
[]
[]
[]
["5.  CONDICIONES AMBIENTALES"]
[]
["La calibración se realizó bajo condiciones ambientales de: "]
["Temperatura:",null,"23 °C ± 5 °C"]
["Humedad Relativa: ",null,"50 % hr ± 20 % hr"]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Certificado N°",{"$f":"J3","v":0}]
["6.   INCERTIDUMBRE DE MEDICIÓN"]
[]
["La incertidumbre expandida de la medición reportada se establece como la incertidumbre estándar de medición multiplicada por el factor de cobertura \"k\",y la probabilidad de cobertura,  la cual debe ser aproximada al 95 % y no menor a este valor\" de acuerdo con el documento: \"CGM 100:2008. GUM 1995\"."]
[]
[]
[]
["7.   TRAZABILIDAD METROLÓGICA"]
[]
["Propiedad de un resultado de medida por la cual el resultado puede relacionarse con una referencia mediante una cadena ininterrumpida y documentada de calibraciones, cada una de las cuales contribuye a la incertidumbre de medida."]
[]
["Instrumento",null,null,"Fabricante","No. de serie",null,"Trazabilidad","Fecha de calibración"]
[{"$f":"+'DATOS 0'!E18","v":"Baño Térmico"},null,null,{"$f":"+'DATOS 0'!E19","v":"Polyscience"},{"$f":"+'DATOS 0'!E20","v":"2110-90004"},null,{"$f":"+'DATOS 0'!E23","v":"Unión Metrológica"},{"$f":"+'DATOS 0'!E24","v":"2021-12-06"}]
[{"$f":"+'DATOS 0'!E26","v":"Termómetro digital"},null,null,{"$f":"+'DATOS 0'!E27","v":"Lufft"},{"$f":"+'DATOS 0'!E28","v":"022.1014.1212.005 - 347980.004"},null,{"$f":"+'DATOS 0'!E31","v":"INM"},{"$f":"+'DATOS 0'!E32","v":"2022-02-16"}]
[]
["8.   RESULTADOS DE LA CALIBRACIÓN"]
[]
[null,null,"Valor Nominal","Temperatura del patrón","Lectura promedio\nIBC","Corrección","Incertidumbre  Expandida  ± U","Factor de cobertura","Límite  de Aceptación LA","Cumple"]
[null,null,"°C","°C","°C","°C","°C","°C","°C",null,null,null,"EMP +","EMP -",null,"LA","LA"]
[null,null,10,{"$f":"+Incertidumbre!E28","v":9.9681425338177743},{"$f":"+Incertidumbre!E35","v":10.019999999999998},{"$f":"+Incertidumbre!E41","v":-5.1857466182223533E-2},{"$f":"+Incertidumbre!H41","v":{"$error":"#DIV/0!"}},{"$f":"+Incertidumbre!F41","v":{"$error":"#DIV/0!"}},{"$f":"+$F$82-G60","v":{"$error":"#DIV/0!"}},{"$f":"+IF(ABS(F60)+G60<I60,\"SI\",\"NO\")","v":{"$error":"#DIV/0!"}},null,null,{"$f":"+$F$82","v":0.5},{"$f":"-M60","v":-0.5},0,{"$f":"+I60","v":{"$error":"#DIV/0!"}},{"$f":"-P60","v":{"$error":"#DIV/0!"}}]
[null,null,20,{"$f":"+Incertidumbre!E47","v":20.011435741884764},{"$f":"+Incertidumbre!E54","v":20.04111111111111},{"$f":"+Incertidumbre!E60","v":-2.9675369226346504E-2},{"$f":"+Incertidumbre!H60","v":{"$error":"#DIV/0!"}},{"$f":"+Incertidumbre!F41","v":{"$error":"#DIV/0!"}},{"$f":"+$F$82-G61","v":{"$error":"#DIV/0!"}},{"$f":"+IF(ABS(F61)+G61<I61,\"SI\",\"NO\")","v":{"$error":"#DIV/0!"}},null,null,0.5,{"$f":"-M61","v":-0.5},{"$f":"+($D$61-$D$60)/2+$D$60","v":14.989789137851268},{"$f":"+I60","v":{"$error":"#DIV/0!"}},{"$f":"-P61","v":{"$error":"#DIV/0!"}}]
[null,null,40,{"$f":"+Incertidumbre!E66","v":39.930025914972326},{"$f":"+Incertidumbre!E73","v":40.03},{"$f":"+Incertidumbre!E79","v":-9.997408502767513E-2},{"$f":"+Incertidumbre!H79","v":{"$error":"#DIV/0!"}},{"$f":"+Incertidumbre!F79","v":{"$error":"#DIV/0!"}},{"$f":"+$F$82-G62","v":{"$error":"#DIV/0!"}},{"$f":"+IF(ABS(F62)+G62<I62,\"SI\",\"NO\")","v":{"$error":"#DIV/0!"}},null,null,0.5,-0.5,{"$f":"+($D$61-$D$60)/2+$D$60","v":14.989789137851268},{"$f":"+I61","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,0.5,-0.5,{"$f":"+($D$62-$D$61)/2+$D$61","v":29.970730828428543},{"$f":"+I61","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,0.5,-0.5,{"$f":"+($D$62-$D$61)/2+$D$61","v":29.970730828428543},{"$f":"+I62","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,0.5,-0.5,{"$f":"+($D$62-$D$61)/2+D62","v":49.889321001516109},{"$f":"+I62","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,0.5,-0.5,{"$f":"+($D$62-$D$61)/2+D62","v":49.889321001516109},{"$f":"+I62","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["La declaración de conformidad se aplica teniendo en cuenta el error más la incertidumbre de medición, la cual no deberá superar los errores máximos permitidos (EMP), según xxxxxx"]
[]
[null,null,null,null,"EMP",0.5,"°C"]
[]
[]
[]
[]
[]
[]
["El riesgo de que los valores  aceptados estén fuera del límite de tolerancia es < 2.5% y para los valores rechazados, el riesgo de estar dentro del límite de tolerancia es <2.5%. El EMP está basado en el numeral 7.10.4.1 la resolución 77507-2016."]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Certificado N°",{"$f":"J3","v":0}]
[]
["10.   OBSERVACIONES"]
[]
["*","Los resultados obtenidos en esta calibración, aplican a la información del equipo descrito en el numeral uno (1) del presente certificado."]
["*","Los resultados obtenidos en el presente certificado se refieren al momento y condiciones en que se realizaron las mediciones."]
["*","Los laboratorios de calibración de la Superintendencia de Industria y Comercio no se responsabilizan de los perjuicios que puedan derivarse del uso inadecuado del equipo calibrado."]
["*","Se adhiere al equipo calibrado una estampilla identificada con el número del  certificado."]
["*","Se realiza medición en 0°C para calcular la histéresis del sensor de temperatura."]
["*","En el presente certificado se usa la coma “,” como separador decimal."]
["*","Este certificado de calibración no puede ser reproducido parcial, ni totalmente,  excepto  con  autorización  del  laboratorio  de la Superintendencia de Industria y Comercio."]
["*","El certificado de calibración sin las firmas autorizadas no es válido."]
["*","(* IBC) Instrumento bajo Calibración."]
["*","(* EMP) Error Máximo Permitido."]
["*","Los resultados de la calibración son trazables al Sistema Internacional (SI)."]
[]
[]
["FIRMAS AUTORIZADAS:"]
[]
[null,null,null,null,null,null,null,null,"SC"]
[]
["LH","Firma Autorizada",null,null,null,null,null,"Calibrado por"]
[null,{"$f":"VLOOKUP($F113,'DATOS 0'!C64:L73,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"VLOOKUP($L113,'DATOS 0'!C64:P73,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP($F113,'DATOS 0'!C64:L73,7,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"VLOOKUP($L113,'DATOS 0'!C64:P73,11,FALSE)","v":{"$error":"#N/A"}}]
[]
[]
[null,"Fecha de elaboración:  ",null,null,null,null,null,null,"Fecha de emisión:  "]
[]
["…………………..Fin de este documento………………………"]

{"sheet":"RT03-F57","index":8,"n_rows":121,"n_cols":17,"rows_kept":121,"cut":false,"hidden":true,"merged":[[6,0,6,1],[6,3,6,10],[0,0,0,10],[2,9,2,10],[3,0,3,3],[5,0,5,1],[5,3,5,10],[14,0,14,2],[14,3,14,11],[7,0,7,1],[7,3,7,10],[9,0,9,1],[9,4,9,5],[9,7,9,8],[9,9,9,10],[10,0,10,1],[10,3,10,5],[11,0,11,11],[13,0,13,2],[13,3,13,11],[23,0,23,10],[15,0,15,2],[15,3,15,11],[16,0,16,2],[16,3,16,11],[17,0,17,2],[17,3,17,11],[18,0,18,2],[19,0,19,3],[19,4,19,7],[20,0,20,11],[22,0,22,10],[41,0,41,4],[24,0,24,3],[24,4,24,7],[26,0,26,7],[28,0,30,11],[32,0,32,4],[34,0,34,11],[35,0,35,1],[35,2,35,3],[36,0,36,1],[36,2,36,3],[40,9,40,10],[43,0,45,11],[47,0,47,4],[49,0,49,10],[51,0,51,2],[51,4,51,5],[51,7,51,8],[52,0,52,2],[52,4,52,5],[52,7,52,8],[53,0,53,2],[53,4,53,5],[53,7,53,8],[101,1,101,11],[55,0,55,10],[57,9,58,9],[79,0,79,11],[88,0,88,11],[92,9,92,10],[94,0,94,5],[96,1,96,11],[97,1,97,11],[98,1,98,11],[99,1,99,11],[100,1,100,11],[113,1,113,4],[113,7,113,10],[102,1,102,11],[103,1,103,11],[104,1,104,11],[105,1,105,11],[106,1,106,11],[107,1,107,10],[109,0,109,3],[111,5,111,7],[111,13,111,15],[112,1,112,4],[112,7,112,10],[120,0,120,10],[114,1,114,4],[114,7,114,10],[115,1,115,4],[115,7,115,10],[116,2,116,5],[118,1,118,2],[118,8,118,9]]}
[]
[]
[null,null,null,null,null,null,null,null,"Certificado N°",{"$f":"+'DATOS 0'!M5","v":0}]
["Información del Cliente"]
[]
["Solicitante:",null,null,{"$f":"+'DATOS 0'!D5","v":0}]
["Dirección:",null,null,{"$f":"+'DATOS 0'!D6","v":0}]
["Ciudad :",null,null,{"$f":"+'DATOS 0'!D7","v":0}]
[]
["Fecha de recepción:",null,null,{"$f":"'DATOS 0'!D8","v":"00:00:00"},null,null,null,"Fecha de calibración:",null,{"$f":"'DATOS 0'!D9","v":"00:00:00"}]
[]
["1.   INFORMACIÓN DEL EQUIPO SOMETIDO A CALIBRACIÓN"]
[]
["Objeto:",null,null,{"$f":"'DATOS 0'!D13","v":0}]
["Fabricante:",null,null,{"$f":"'DATOS 0'!D14","v":0}]
["Número de serie:",null,null,{"$f":"+'DATOS 0'!D16","v":0}]
["Modelo:",null,null,{"$f":"'DATOS 0'!D15","v":"00:00:00"}]
["Intervalo de calibración:",null,null,{"$f":"CONCATENATE('DATOS 0'!L13,\" \",'DATOS 0'!N13,\" a\",\" \",'DATOS 0'!M13,\" \",'DATOS 0'!N13)","v":"  a  "}]
["Resolución:",null,null,{"$f":"'DATOS 0'!L14","v":0},"°C"]
[]
["2.   LUGAR Y DIRECCIÓN DE CALIBRACIÓN"]
[]
["Laboratorio de calibración de temperatura, avenida carrera 50 # 26-55, interior 2 del CAN"]
[]
["3.   CÓDIGO INTERNO",null,null,null,{"$f":"+'DATOS 0'!M6","v":0}]
[]
["4.   MÉTODO DE CALIBRACIÓN UTILIZADO "]
[]
["Para la calibración del termómetro digital, se utilizó el método  establecido en el documento normativo Guía para aa calibración de termómetros digitales con sensor tipo Prt, termistor y termopar en baños líquidos y hornos de bloque metálico  INM/Gtm-T/01. Bogotá, D.C. 2019-12-05 Versión No. 1."]
[]
[]
[]
["5.  CONDICIONES AMBIENTALES"]
[]
["La calibración se realizó bajo condiciones ambientales de: "]
["Temperatura:",null,"23 °C ± 5 °C"]
["Humedad Relativa: ",null,"50 % hr ± 20 % hr"]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Certificado N°",{"$f":"J3","v":0}]
["6.   INCERTIDUMBRE DE MEDICIÓN"]
[]
["La incertidumbre expandida de la medición reportada se establece como la incertidumbre estándar de medición multiplicada por el factor de cobertura \"k\",y la probabilidad de cobertura,  la cual debe ser aproximada al 95 % y no menor a este valor\" de acuerdo con el documento: \"CGM 100:2008. GUM 1995\"."]
[]
[]
[]
["7.   TRAZABILIDAD METROLÓGICA"]
[]
["Propiedad de un resultado de medida por la cual el resultado puede relacionarse con una referencia mediante una cadena ininterrumpida y documentada de calibraciones, cada una de las cuales contribuye a la incertidumbre de medida."]
[]
["Instrumento",null,null,"Fabricante","No. de serie",null,"Trazabilidad","Fecha de calibración"]
[{"$f":"+'DATOS 0'!E18","v":"Baño Térmico"},null,null,{"$f":"+'DATOS 0'!E19","v":"Polyscience"},{"$f":"+'DATOS 0'!E20","v":"2110-90004"},null,{"$f":"+'DATOS 0'!E23","v":"Unión Metrológica"},{"$f":"+'DATOS 0'!E24","v":"2021-12-06"}]
[{"$f":"+'DATOS 0'!E26","v":"Termómetro digital"},null,null,{"$f":"+'DATOS 0'!E27","v":"Lufft"},{"$f":"+'DATOS 0'!E28","v":"022.1014.1212.005 - 347980.004"},null,{"$f":"+'DATOS 0'!E31","v":"INM"},{"$f":"+'DATOS 0'!E32","v":"2022-02-16"}]
[]
["8.   RESULTADOS DE LA CALIBRACIÓN"]
[]
[null,null,"Valor Nominal","Temperatura del patrón","Lectura promedio\nIBC","Corrección","Incertidumbre  Expandida  ± U","Factor de cobertura","Límite  de Aceptación LA","Cumple"]
[null,null,"°C","°C","°C","°C","°C","°C","°C",null,null,null,"EMP +","EMP -",null,"LA","LA"]
[null,null,10,{"$f":"+Incertidumbre!E28","v":9.9681425338177743},{"$f":"+Incertidumbre!E35","v":10.019999999999998},{"$f":"+Incertidumbre!E41","v":-5.1857466182223533E-2},{"$f":"+Incertidumbre!H41","v":{"$error":"#DIV/0!"}},{"$f":"+Incertidumbre!F41","v":{"$error":"#DIV/0!"}},{"$f":"+$F$82-G60","v":{"$error":"#DIV/0!"}},{"$f":"+IF(ABS(F60)+G60<I60,\"SI\",\"NO\")","v":{"$error":"#DIV/0!"}},null,null,{"$f":"+$F$82","v":0.5},{"$f":"-M60","v":-0.5},0,{"$f":"+I60","v":{"$error":"#DIV/0!"}},{"$f":"-P60","v":{"$error":"#DIV/0!"}}]
[null,null,20,{"$f":"+Incertidumbre!E47","v":20.011435741884764},{"$f":"+Incertidumbre!E54","v":20.04111111111111},{"$f":"+Incertidumbre!E60","v":-2.9675369226346504E-2},{"$f":"+Incertidumbre!H60","v":{"$error":"#DIV/0!"}},{"$f":"+Incertidumbre!F41","v":{"$error":"#DIV/0!"}},{"$f":"+$F$82-G61","v":{"$error":"#DIV/0!"}},{"$f":"+IF(ABS(F61)+G61<I61,\"SI\",\"NO\")","v":{"$error":"#DIV/0!"}},null,null,0.5,{"$f":"-M61","v":-0.5},{"$f":"+($D$61-$D$60)/2+$D$60","v":14.989789137851268},{"$f":"+I60","v":{"$error":"#DIV/0!"}},{"$f":"-P61","v":{"$error":"#DIV/0!"}}]
[null,null,40,{"$f":"+Incertidumbre!E66","v":39.930025914972326},{"$f":"+Incertidumbre!E73","v":40.03},{"$f":"+Incertidumbre!E79","v":-9.997408502767513E-2},{"$f":"+Incertidumbre!H79","v":{"$error":"#DIV/0!"}},{"$f":"+Incertidumbre!F79","v":{"$error":"#DIV/0!"}},{"$f":"+$F$82-G62","v":{"$error":"#DIV/0!"}},{"$f":"+IF(ABS(F62)+G62<I62,\"SI\",\"NO\")","v":{"$error":"#DIV/0!"}},null,null,0.5,-0.5,{"$f":"+($D$61-$D$60)/2+$D$60","v":14.989789137851268},{"$f":"+I61","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,0.5,-0.5,{"$f":"+($D$62-$D$61)/2+$D$61","v":29.970730828428543},{"$f":"+I61","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,0.5,-0.5,{"$f":"+($D$62-$D$61)/2+$D$61","v":29.970730828428543},{"$f":"+I62","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,0.5,-0.5,{"$f":"+($D$62-$D$61)/2+D62","v":49.889321001516109},{"$f":"+I62","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,0.5,-0.5,{"$f":"+($D$62-$D$61)/2+D62","v":49.889321001516109},{"$f":"+I62","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["La declaración de conformidad se aplica teniendo en cuenta el error más la incertidumbre de medición, la cual no deberá superar los errores máximos permitidos (EMP), según xxxxxx"]
[]
[null,null,null,null,"EMP",0.5,"°C"]
[]
[]
[]
[]
[]
[]
["El riesgo de que los valores  aceptados estén fuera del límite de tolerancia es < 2.5% y para los valores rechazados, el riesgo de estar dentro del límite de tolerancia es <2.5%. El EMP está basado en el numeral 7.10.4.1 la resolución 77507-2016."]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Certificado N°",{"$f":"J3","v":0}]
[]
["10.   OBSERVACIONES"]
[]
["*","Los resultados obtenidos en esta calibración, aplican a la información del equipo descrito en el numeral uno (1) del presente certificado."]
["*","Los resultados obtenidos en el presente certificado se refieren al momento y condiciones en que se realizaron las mediciones."]
["*","Los laboratorios de calibración de la Superintendencia de Industria y Comercio no se responsabilizan de los perjuicios que puedan derivarse del uso inadecuado del equipo calibrado."]
["*","Se adhiere al equipo calibrado una estampilla identificada con el número del  certificado."]
["*","Se realiza medición en 0°C para calcular la histéresis del sensor de temperatura."]
["*","En el presente certificado se usa la coma “,” como separador decimal."]
["*","Este certificado de calibración no puede ser reproducido parcial, ni totalmente,  excepto  con  autorización  del  laboratorio  de la Superintendencia de Industria y Comercio."]
["*","El certificado de calibración sin las firmas autorizadas no es válido."]
["*","(* IBC) Instrumento bajo Calibración."]
["*","(* EMP) Error Máximo Permitido."]
["*","Los resultados de la calibración son trazables al Sistema Internacional (SI)."]
[]
[]
["FIRMAS AUTORIZADAS:"]
[]
[null,null,null,null,null,null,null,null,"SC"]
[]
["LH","Firma Autorizada",null,null,null,null,null,"Calibrado por"]
[null,{"$f":"VLOOKUP($F113,'DATOS 0'!C64:L73,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"VLOOKUP($L113,'DATOS 0'!C64:P73,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP($F113,'DATOS 0'!C64:L73,7,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"VLOOKUP($L113,'DATOS 0'!C64:P73,11,FALSE)","v":{"$error":"#N/A"}}]
[]
[]
[null,"Fecha de elaboración:  ",null,null,null,null,null,null,"Fecha de emisión:  "]
[]
["…………………..Fin de este documento………………………"]

{"sheet":"RT03-F64","index":9,"n_rows":116,"n_cols":9,"rows_kept":116,"cut":false,"hidden":true,"merged":[[13,3,13,11],[3,0,3,3],[5,0,5,1],[19,0,19,3],[19,4,19,7],[17,0,17,2],[17,3,17,11],[18,0,18,2],[5,3,5,10],[6,0,6,1],[6,3,6,10],[20,0,20,11],[0,0,0,9],[14,0,14,2],[14,3,14,11],[7,0,7,1],[7,3,7,10],[9,0,9,1],[9,4,9,5],[9,7,9,8],[9,9,9,10],[10,0,10,1],[10,3,10,5],[11,0,11,11],[16,0,16,2],[16,3,16,11],[13,0,13,2],[23,0,23,10],[15,0,15,2],[15,3,15,11],[43,0,45,11],[47,0,47,4],[22,0,22,9],[24,4,24,7],[41,0,41,7],[28,0,30,11],[32,0,32,4],[34,0,34,11],[35,0,35,1],[35,2,35,3],[36,0,36,1],[36,2,36,3],[24,0,24,3],[49,0,49,10],[51,0,51,2],[51,4,51,5],[51,7,51,8],[52,0,52,2],[52,4,52,5],[52,7,52,8],[53,0,53,2],[53,4,53,5],[53,7,53,8],[95,1,95,9],[96,1,96,9],[97,1,97,9],[55,0,55,10],[57,9,58,9],[79,0,79,11],[90,0,90,5],[110,6,110,8],[106,5,106,7],[98,1,98,9],[99,1,99,9],[100,1,100,9],[101,1,101,9],[102,1,102,9],[106,13,106,15],[108,1,108,4],[108,6,108,8],[107,6,107,8],[109,6,109,8],[115,0,115,10],[2,6,2,7],[2,8,2,9],[40,6,40,7],[88,6,88,7],[88,8,88,9],[40,8,40,9],[92,1,92,9],[93,1,93,9],[94,1,94,9],[109,1,109,4],[110,1,110,4],[111,2,111,5],[113,1,113,2],[113,6,113,7],[104,0,104,3]]}
[]
[]
[null,null,null,null,null,null,"Informe N°",null,{"$f":"+'DATOS 0'!M5","v":0}]
["Información del Cliente"]
[]
["Solicitante:",null,null,{"$f":"+'DATOS 0'!D5","v":0}]
["Dirección:",null,null,{"$f":"+'DATOS 0'!D6","v":0}]
["Ciudad :",null,null,{"$f":"+'DATOS 0'!D7","v":0}]
[]
["Fecha de recepción:",null,null,{"$f":"'DATOS 0'!D8","v":"00:00:00"}]
[]
["1.   INFORMACIÓN DEL EQUIPO "]
[]
["Objeto:",null,null,{"$f":"+'DATOS 0'!D13","v":0}]
["Fabricante:",null,null,{"$f":"+'DATOS 0'!D14","v":0}]
["Número de serie:",null,null,{"$f":"+'DATOS 0'!D16","v":0}]
["Modelo:",null,null,{"$f":"+'DATOS 0'!D15","v":"00:00:00"}]
["Intervalo de calibración:",null,null,{"$f":"CONCATENATE('DATOS 0'!L13,\" \",'DATOS 0'!N13,\" a\",\" \",'DATOS 0'!M13,\" \",'DATOS 0'!N13)","v":"  a  "}]
["Resolución:",null,null,{"$f":"+'DATOS 0'!L14","v":0},"°C"]
[]
["2.   LUGAR Y DIRECCIÓN "]
[]
["Laboratorio de calibración de temperatura, avenida carrera 50 # 26-55, interior 2 del CAN"]
[]
["3.   CÓDIGO INTERNO",null,null,null,{"$f":"+'DATOS 0'!M6","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Informe N°",null,{"$f":"I3","v":0}]
["4.   REGISTRO FOTOGRÁFICO"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Informe N°",null,{"$f":"I3","v":0}]
[]
["5. OBSERVACIONES"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["FIRMAS AUTORIZADAS:"]
[]
[null,null,null,null,null,null,null,null,"SC"]
[]
["LH","Autorizado por",null,null,null,null,"Elaborado por"]
[null,{"$f":"VLOOKUP($F108,'DATOS 0'!C64:P73,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"VLOOKUP($J108,'DATOS 0'!C64:P73,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP($F108,'DATOS 0'!C64:P73,7,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,{"$f":"VLOOKUP($J108,'DATOS 0'!C64:P73,11,FALSE)","v":{"$error":"#N/A"}}]
[]
[]
[null,"Fecha de elaboración:  ",null,"2021-06-21",null,null,"Fecha de emisión:  ",null,"2021-06-21"]
[]
["…………………..Fin de este documento………………………"]

{"sheet":"EJEMPLO","index":10,"n_rows":49,"n_cols":16,"rows_kept":49,"cut":false,"hidden":true,"merged":[[15,4,15,5],[16,4,16,5],[26,4,26,6],[26,7,26,9],[25,4,25,9],[19,4,19,7],[14,4,14,5],[31,3,31,4],[16,0,16,2],[4,0,5,0],[2,4,2,5],[3,4,3,5],[4,4,4,5],[5,4,5,5],[6,4,6,5],[7,4,7,5],[8,4,8,5],[9,4,9,5],[10,4,10,5],[11,4,11,5],[12,4,12,5],[13,4,13,5]]}
["PIE DE REY",150,"mm"]
["Resolución",0.01,"mm"]
["Estabilidad",2,"°C",null,"Longitud Nominal",null,0,10,30,50,70,90,110,130,150]
[null,null,null,null,"Longitud Bloque patrón",null,0,10,30,50,70,90,110,130,150]
["Bloques patrón","V nominal","U K=2",null,"Lectura IBC 1",null,0,9.99,29.97,50.02,70,89.98,109.99,129.99,149.99]
[null,"mm","μm",null,"Lectura IBC 2",null,0.01,9.98,29.99,49.99,70.02,89.97,110,129.99,149.97999999999999]
["Bloque 1",10,{"$f":"((0.1/1000+0.000001*B7))*1000","v":0.11},null,"Lectura IBC 3",null,null,null,null,49.98,null,null,null,129.94999999999999]
["Bloque 2",30,0.13,null,"Lectura IBC 4",null,null,null,null,49.96,null,null,null,129.99]
["Bloque 3",50,0.15000000000000002,null,"Lectura IBC 5",null,null,null,null,50.01,null,null,null,129.97999999999999]
["Bloque 4",70,0.17,null,"Lectura IBC 6",null,null,null,null,50.01,null,null,null,129.97999999999999]
["Bloque 5",90,0.19,null,"Lectura IBC 7",null,null,null,null,50.01,null,null,null,129.96]
["Bloque 6",110,0.21000000000000002,null,"Lectura IBC 8",null,null,null,null,50.04,null,null,null,129.97]
["Bloque 7",130,0.23,null,"Lectura IBC 9",null,null,null,null,50.02,null,null,null,129.99]
["Bloque 8",150,{"$f":"((0.1/1000+0.000001*B14))*1000","v":0.25},null,"Lectura IBC 10",null,null,null,null,50.01,null,null,null,130]
["Deriva",null,0.125,null,"Promedio mm",null,{"$f":"AVERAGE(G5:G6)","v":5.0000000000000001E-3},{"$f":"AVERAGE(H5:H6)","v":9.9849999999999994},29.979999999999997,{"$f":"AVERAGE(J5:J14)","v":50.005000000000003},70.009999999999991,89.974999999999994,109.995,{"$f":"AVERAGE(N5:N14)","v":129.98000000000002},149.98500000000001]
[null,null,null,null,"Desviación estandar (μm)",null,{"$f":"_xlfn.STDEV.S(G5:G6)*1000","v":7.0710678118654755},{"$f":"_xlfn.STDEV.S(H5:H6)*1000","v":7.0710678118653245},14.142135623730649,{"$f":"_xlfn.STDEV.S(J5:J14)*1000","v":22.730302828309924},14.142135623728137,7.0710678118690922,7.0710678118690922,{"$f":"_xlfn.STDEV.S(N5:N14)*1000","v":15.63471919941539},7.0710678118791419]
["Termómetro",null,null,null,"Error Promedio (μm)",null,{"$f":"(G15-G4)*1000","v":5},{"$f":"(H15-H4)*1000","v":-15.000000000000568},-20.000000000003126,5.000000000002558,9.9999999999909051,-25.000000000005684,-4.9999999999954525,-19.99999999998181,-14.999999999986358]
["Resolución",0.5,"°C"]
["U K=2",1,"°C",null,null,null,null,null,null,null,null,20]
["Deriva",0.25,"°C",null,"Coeficiente de dilatación",null,null,null,null,null,null,22]
[null,null,null,null,null,"Estimado","U"]
["Planitud",5,"μm",null," ͞α Bloque",1.15E-5,9.9999999999999995E-7,"°C-1"]
["Paralelismo",10,"μm",null," ͞α Pie de rey",1.15E-5,9.9999999999999995E-7,"°C-1"]
["H",30,"mm",null,"u ͞α total",null,{"$f":"SQRT(SUMSQ((G22/SQRT(3)),(G23/SQRT(3))))","v":8.1649658092772609E-7},"°C-1",null,null,null,"Modelo del coeficiente de dilatación"]
["res",0.01,"mm"]
["β",{"$f":"ATAN(B25/B24)","v":3.3333332098765513E-4},"rad",null,"Variación de temperatura"]
["Abbe",{"$f":"(B26*B24)*1000","v":9.9999996296296541},"μm",null,"Estimado",null,null,"U"]
[null,null,null,null,null,null,null,"Res",{"$f":"B18","v":0.5},"°C"]
[null,null,null,null,"Δt",2,"°C","Der",{"$f":"B20","v":0.25},"°C"]
[null,null,null,null,null,null,null,"Cal",{"$f":"B19","v":1},"°C"]
[]
["Unidad",null,"Estimado","Incertidumbre estandar",null,"Tipo de u","Distribución","Ci","Ci*u","Unidad"]
["μm","u rep",{"$f":"MAX(G16:O16)","v":22.730302828309924}," s/√n",{"$f":"C33/SQRT(10)","v":7.1879528842826597},"Tipo A","Normal",1,{"$f":"E33*H33","v":7.1879528842826597},"μm"]
["μm","u Patron",{"$f":"C14","v":0.25},"U / k",{"$f":"C34/2","v":0.125},"Tipo B","Normal",1,{"$f":"E34*H34","v":0.125},"μm"]
["μm","u Deriva",{"$f":"C15","v":0.125},"Der / 2√3",{"$f":"C35/(2*SQRT(3))","v":3.6084391824351615E-2},"Tipo B","Rectangular",1,{"$f":"E35*H35","v":3.6084391824351615E-2},"μm",null,150,100,101.05,{"$f":"N35-M35","v":1.0499999999999972},5.5999999999999999E-3]
["μm","u Pla",{"$f":"B22","v":5},"Tem  / 2√3",{"$f":"C36/(SQRT(6))","v":2.0412414523193152},"Tipo B","Rectangular",1,2.0412414523193152,"μm"]
["μm","u Par",{"$f":"B23","v":10},"Res  / 2√3",{"$f":"C37/(2*SQRT(3))","v":2.8867513459481291},"Tipo B","Rectangular",1,2.8867513459481291,"μm"]
["μm","u Abbe",{"$f":"B27","v":9.9999996296296541},"His  / 2√3",{"$f":"C38/(2*SQRT(3))","v":2.8867512390314194},"Tipo B","Rectangular",1,2.8867512390314194,"μm"]
["μm","u res",{"$f":"B2*1000","v":10},"Tem  / 2√3",{"$f":"C39/(2*SQRT(3))","v":2.8867513459481291},"Tipo B","Rectangular",1,2.8867513459481291,"μm"]
["°C-1","u ͞α",null,null,8.1999999999999998E-7,"Tipo B","Rectangular","L Δt",{"$f":"(E40*B1*B3)*1000","v":0.24600000000000002},"μm"]
["°C","u Δt",2,"ρf  / √3",{"$f":"C41/SQRT(3)","v":1.1547005383792517},"Tipo B","Rectangular"]
["°C","Cal",{"$f":"I30","v":1},"U / k",{"$f":"C42/2","v":0.5},"Tipo B","Normal"]
["°C","Res",{"$f":"I28","v":0.5},"Res / 2√3",{"$f":"C43/SQRT(12)","v":0.14433756729740646},"Tipo B","Rectangular"]
["°C","Der",{"$f":"I29","v":0.25},"Der / 2√3",{"$f":"C44/SQRT(12)","v":7.216878364870323E-2},"Tipo B","Rectangular"]
["°C","u Δt",null,null,{"$f":"SQRT(SUMSQ(E41:E44))","v":1.2686114456365276},"Tipo B","Rectangular","L͞α",{"$f":"(E45*B1*F22)*1000","v":2.1883547437230098},"μm"]
[null,null,null,null,null,null,null,"uc",{"$f":"SQRT(SUMSQ(I33:I40,I45))","v":9.2574117486346328},"μm"]
[null,null,null,null,null,null,null,"veff",{"$f":"I46^4/((I33^4/10)+(I34^4/200)+(I35^4/200)+(I36^4/200)+(I37^4/200)+(I38^4/200)+(I39^4/200)+(I40^4/200)+(I45^4/200))","v":27.385433649414914},"μm"]
[null,null,null,null,null,null,null,"k",{"$f":"TINV((100%-95.45%),I47)","v":2.0969451164181208},"μm"]
[null,null,null,null,null,null,null,"Uexp",{"$f":"I48*I46","v":19.412284356971128},"μm"]

{"sheet":"DATOS ANTERIORES DE PATRONES ","index":11,"n_rows":174,"n_cols":32,"rows_kept":174,"cut":false,"hidden":true,"merged":[[108,15,108,16],[109,12,109,14],[109,15,109,16],[110,12,110,14],[110,15,110,16],[104,0,111,0],[104,12,104,14],[104,15,104,16],[105,12,105,14],[105,15,105,16],[106,12,106,14],[106,15,106,16],[107,12,107,14],[107,15,107,16],[108,12,108,14],[12,21,14,21],[98,14,98,16],[99,14,99,16],[100,14,100,16],[101,12,101,16],[103,12,103,14],[103,15,103,16],[12,14,14,14],[12,15,14,15],[12,17,14,17],[12,18,14,18],[12,19,14,19],[12,20,14,20],[12,7,14,7],[12,8,14,8],[12,9,14,9],[12,10,14,10],[12,11,14,11],[12,12,14,12],[12,1,14,1],[12,2,14,2],[12,3,14,3],[12,4,14,4],[12,5,14,5],[12,6,14,6],[7,17,7,18],[7,19,7,20],[8,1,8,2],[8,3,8,4],[8,6,8,7],[8,8,8,9],[8,11,8,12],[8,14,8,15],[8,17,8,18],[8,19,8,20],[7,1,7,2],[7,3,7,4],[7,6,7,7],[7,8,7,9],[7,11,7,12],[7,14,7,15],[5,17,5,18],[5,19,5,20],[6,1,6,2],[6,3,6,4],[6,6,6,7],[6,8,6,9],[6,11,6,12],[6,14,6,15],[6,17,6,18],[6,19,6,20],[5,1,5,2],[5,3,5,4],[5,6,5,7],[5,8,5,9],[5,11,5,12],[5,14,5,15],[3,17,3,18],[3,19,3,20],[4,1,4,2],[4,3,4,4],[4,6,4,7],[4,8,4,9],[4,11,4,12],[4,14,4,15],[4,17,4,18],[4,19,4,20],[3,1,3,2],[3,3,3,4],[3,6,3,7],[3,8,3,9],[3,11,3,12],[3,14,3,15],[1,17,1,18],[1,19,1,20],[2,1,2,2],[2,3,2,4],[2,6,2,7],[2,8,2,9],[2,11,2,12],[2,14,2,15],[2,17,2,18],[2,19,2,20],[1,1,1,2],[1,3,1,4],[1,6,1,7],[1,8,1,9],[1,11,1,12],[1,14,1,15]]}
[]
[1,"Instrumento:",null,"Bloques patrón",null,1,"Instrumento:",null,"Bloques patrón",null,1,"Instrumento:",null,null,"Bloques escalonados",null,null,"Instrumento:",null,"Bloques patrón"]
[2,"Marca:",null,"MOORE & WRIGHT",null,2,"Marca:","Marca:","MOORE & WRIGHT",null,2,"Marca:","Marca:",null,"MITUTOYO",null,null,"Marca:","Marca:","MITUTOYO"]
[3,"Grado:",null,0,null,3,"Grado","Modelo:",0,null,3,"Grado","Modelo:",null,"No Aplica",null,null,"Grado","Modelo:",1]
[4,"Rango:",null,"0,5 mm a 100 mm",null,4,"Rango:","Rango:","0,5 mm a 100 mm",null,4,"Rango:","Rango:",null,"0 mm a 600 mm",null,null,"Rango:","Rango:","0,1 in a 6 in",null,null,null,null,"Serie","Marca","Grado","Rango","Certificado","Fecha Cal","Prox. Cal","Equipo"]
[5,"Serie:",null,"110108 / CS-JBP-002",null,5,"Serie:","Serie:","090130 / CS-JBP-005",null,5,"Serie:","Serie:",null,800014,null,null,"Serie:","Serie:","080167 / 1304410",null,null,null,null,"110108 / CS-JBP-002",{"$f":"D3","v":"MOORE & WRIGHT"},{"$f":"D4","v":0},{"$f":"D5","v":"0,5 mm a 100 mm"},{"$f":"D7","v":"LMD-151424"},{"$f":"D8","v":"Junio 22 de 2015"},{"$f":"D9","v":"Junio 22 de 2020"},"Bloques patrón"]
[6,"Certificado No:",null,"LMD-151424",null,6,"Certificado No:","Certificado No:","LMD-142362",null,6,"Certificado No:","Certificado No:",null,20694,null,null,"Certificado No:","Certificado No:","LMD-151427 / LMD-151381",null,null,null,null,"160203 / CS-JBP-008",{"$f":"P105","v":"SWT"},{"$f":"P106","v":1},{"$f":"P107","v":"125 mm a 500 mm"},{"$f":"P109","v":"LMD170789"},{"$f":"P110","v":"Abril 28 de 2017"},{"$f":"P111","v":"Abril 28 de 2018"},"Bloques patrón"]
[7,"Fecha de calibración:",null,"Junio 22 de 2015",null,7,"Fecha de calibración:","Fecha de calibración:","Septiembre 04 de 2014",null,7,"Fecha de calibración:","Fecha de calibración:",null,40675,null,null,"Fecha de calibración:","Fecha de calibración:","2015-06-17 / 2015-06-24",null,null,null,null,"080167 / 1304410",{"$f":"T3","v":"MITUTOYO"},{"$f":"T4","v":1},{"$f":"T5","v":"0,1 in a 6 in"},{"$f":"T7","v":"LMD-151427 / LMD-151381"},{"$f":"T8","v":"2015-06-17 / 2015-06-24"},{"$f":"T9","v":"2018-06-17 / 2018-06-24"},"Bloques patrón"]
[8,"Próxima calibración:",null,"Junio 22 de 2020",null,8,"Próxima calibración:","Próxima calibración:","Septiembre 04 de 2017",null,8,"Próxima calibración:","Próxima calibración:",null,null,null,null,"Próxima calibración:","Próxima calibración:","2018-06-17 / 2018-06-24",null,null,null,null,"0800014 / CH-CCH-001 (Ext)",{"$f":"$O$3","v":"MITUTOYO"},{"$f":"$O$4","v":"No Aplica"},{"$f":"$O$5","v":"0 mm a 600 mm"},{"$f":"$O$7","v":20694},{"$f":"$O$8","v":40675},{"$f":"$O$9","v":0},"Bloques escalonados"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"0800014 / CH-CCH-001 (Int)",{"$f":"$O$3","v":"MITUTOYO"},{"$f":"$O$4","v":"No Aplica"},{"$f":"$O$5","v":"0 mm a 600 mm"},{"$f":"$O$7","v":20694},{"$f":"$O$8","v":40675},{"$f":"$O$9","v":0},"Bloques escalonados"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"I6","v":"090130 / CS-JBP-005"},{"$f":"I3","v":"MOORE & WRIGHT"},{"$f":"I4","v":0},{"$f":"I5","v":"0,5 mm a 100 mm"},{"$f":"I7","v":"LMD-142362"},{"$f":"I8","v":"Septiembre 04 de 2014"},{"$f":"I9","v":"Septiembre 04 de 2017"},"Bloques patrón"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No aplica"]
[null,"Valor nominal","Desviación de longitud en el punto central respecto al valor nominal,","Variación en longitud","U","DERIVA","Valor Nominal","Desviación de longitud en el punto central respecto al valor nominal,","Variación en longitud","U","DERIVA","Valor Nominal","Desviación de longitud en el punto central respecto al valor nominal,",null,"U","DERIVA",null,"Valor Nominal","Desviación de longitud en el punto central respecto al valor nominal,","Variación en longitud","U","DERIVA"]
[]
[]
[null,"mm","µm","µm","µm","µm","mm","µm","µm","µm","µm","mm","µm",null,"µm","µm",null,"in","µm","µm","µm","µm"]
[null,0.5,-0.03,0.02,2.4E-2,1.9999999999999997E-2,0.5,0.02,0.06,0.03,0.01,0,-2.1,null,4,2.1,null,0.1,0,0.02,2.4E-2,{"$f":"((R17*$W$102)+$L$112)*1000","v":1.9685059055118111E-3}]
[null,1,-0.05,0.05,2.4E-2,0.04,1,0.04,0.03,0.03,0.03,20,-2.1,null,4,2.2000000000000002,null,0.10005,0.03,0.04,2.4E-2,1.9685059064960628E-3]
[null,1.0009999999999999,0.05,0.02,2.4E-2,1.0000000000000002E-2,1.0009999999999999,0.03,0.05,0.03,1.0000000000000002E-2,50,-1.8,null,4,1.9,null,0.10009999999999999,0.01,0.01,2.4E-2,1.968505907480315E-3]
[null,1.002,-0.06,0.03,2.4E-2,1.9999999999999997E-2,1.002,0,0.02,0.03,0.04,100,0,null,4,0.2,null,0.1002,-0.03,0.05,2.4E-2,1.9685059094488189E-3]
[null,1.0029999999999999,0.04,0.03,2.4E-2,0.06,1.0029999999999999,-0.03,0.03,0.03,9.9999999999999985E-3,150,2.2999999999999998,null,4,2.2000000000000002,null,0.1003,-0.03,0.03,2.4E-2,1.9685059114173229E-3]
[null,1.004,-0.03,0.02,2.4E-2,9.9999999999999985E-3,1.004,-7.0000000000000007E-2,0.02,0.03,0.05,250,2.6,null,4,2.1,null,0.1004,0.02,0.03,2.4E-2,1.9685059133858268E-3]
[null,1.0049999999999999,-0.03,0.02,2.4E-2,1.9999999999999997E-2,1.0049999999999999,0.05,0.01,0.03,0.04,350,1.7,null,4,1.8,null,0.10050000000000001,-0.03,0.05,2.4E-2,1.9685059153543307E-3]
[null,1.006,-0.02,0.03,2.4E-2,0.03,1.006,0.08,0.03,0.03,7.0000000000000007E-2,450,0.9,null,4,0.5,null,0.10059999999999999,0.01,0.03,2.4E-2,1.9685059173228346E-3]
[null,1.0069999999999999,-0.05,0.04,2.4E-2,6.0000000000000005E-2,1.0069999999999999,0.02,0.03,0.03,0.01,500,-1,null,4,1.2,null,0.1007,-0.06,0.01,2.4E-2,1.9685059192913385E-3]
[null,1.008,-0.06,0.03,2.4E-2,0.03,1.008,7.0000000000000007E-2,0.03,0.03,4.0000000000000008E-2,550,-1,null,4,1.2,null,0.1008,0.01,0.03,2.4E-2,1.9685059212598429E-3]
[null,1.0089999999999999,0.02,0.03,2.4E-2,0,1.0089999999999999,-0.01,0.01,0.03,0.01,600,-1.3,null,4,1.9,null,0.1009,0.02,0.05,2.4E-2,1.9685059232283464E-3]
[null,1.01,-0.02,0.04,2.4E-2,0.02,1.01,0.03,0.03,0.03,0.03,0,0.6,null,4,0.6,null,0.10100000000000001,0.04,0.05,2.4E-2,1.9685059251968507E-3]
[null,1.02,0.04,0.02,2.4E-2,0.02,1.02,0.05,0.02,0.03,3.0000000000000002E-2,20,-0.3,null,4,0.2,null,0.10199999999999999,-0.01,0.03,2.4E-2,1.9685059448818899E-3]
[null,1.03,-0.02,0.05,2.4E-2,0.02,1.03,0,0.02,0.03,0,50,-0.7,null,4,1.5,null,0.10299999999999999,0.01,0.02,2.4E-2,1.9685059645669291E-3]
[null,1.04,-0.06,0.03,2.4E-2,4.9999999999999996E-2,1.04,7.0000000000000007E-2,0.03,0.03,6.0000000000000005E-2,100,0.7,null,4,0.3,null,0.104,-0.06,0.03,2.4E-2,1.9685059842519687E-3]
[null,1.05,-0.03,0.04,2.4E-2,0.04,1.05,0.02,0.02,0.03,0.01,150,0.7,null,4,0.4,null,0.105,-0.05,0.05,2.4E-2,1.9685060039370079E-3]
[null,1.06,-0.02,0.04,2.4E-2,0.02,1.06,0.02,0.02,0.03,0.02,250,0.8,null,4,0.3,null,0.106,-0.01,0.06,2.4E-2,1.9685060236220471E-3]
[null,1.07,0.01,0.05,2.4E-2,0.01,1.07,0,0.04,0.03,0.02,350,-0.5,null,4,0.5,null,0.107,-0.05,0.04,2.4E-2,1.9685060433070867E-3]
[null,1.08,-0.02,0.03,2.4E-2,0.08,1.08,0.02,0.02,0.03,3.9999999999999994E-2,450,-0.7,null,4,1.3,null,0.108,-0.06,0.03,2.4E-2,1.9685060629921259E-3]
[null,1.0900000000000001,-0.02,0.03,2.4E-2,0.04,1.0900000000000001,0.03,0.03,0.03,9.9999999999999985E-3,500,-0.2,null,4,0.5,null,0.109,0.03,0.04,2.4E-2,1.9685060826771651E-3]
[null,1.1000000000000001,0.03,0.04,2.4E-2,9.9999999999999985E-3,1.1000000000000001,0,0.01,0.03,0.02,550,-0.5,null,4,0.9,null,0.11,-0.04,0.05,2.4E-2,1.9685061023622047E-3]
[null,1.1100000000000001,0,0.02,2.4E-2,0.01,1.1100000000000001,0.02,0.03,0.03,0.01,600,-0.2,null,4,0.5,null,0.12,-0.04,0.06,2.4E-2,1.9685062992125983E-3]
[null,1.1200000000000001,-0.03,0.04,2.4E-2,0.03,1.1200000000000001,0.01,0.04,0.03,0.01,null,null,null,null,null,null,0.13,-0.05,0.04,2.4E-2,1.9685064960629924E-3]
[null,1.1299999999999999,-0.06,0.04,2.4E-2,3.9999999999999994E-2,1.1299999999999999,0.02,0.02,0.03,0,null,null,null,null,null,null,0.14000000000000001,-0.02,0.03,2.4E-2,1.9685066929133856E-3]
[null,1.1399999999999999,-0.02,0.04,2.4E-2,0.02,1.1399999999999999,0.01,0.04,0.03,0.01,null,null,null,null,null,null,0.15,0.02,0.01,2.4E-2,1.9685068897637797E-3]
[null,1.1499999999999999,0.05,0.04,2.4E-2,1.0000000000000002E-2,1.1499999999999999,0,0.05,0.03,0.04,null,null,null,null,null,null,0.16,0.06,0.06,2.4E-2,1.9685070866141733E-3]
[null,1.1599999999999999,-0.01,0.03,2.4E-2,1.9999999999999997E-2,1.1599999999999999,0,0.03,0.03,0.03,null,null,null,null,null,null,0.17,0.03,0.05,2.4E-2,1.9685072834645669E-3]
[null,1.17,-0.03,0.04,2.4E-2,9.9999999999999985E-3,1.17,0.02,0.03,0.03,0,null,null,null,null,null,null,0.18,0.04,0.06,2.4E-2,1.9685074803149605E-3]
[null,1.18,0,0.01,2.4E-2,0.03,1.18,-0.01,0.05,0.03,1.9999999999999997E-2,null,null,null,null,null,null,0.19,-0.04,0.06,2.4E-2,1.9685076771653546E-3]
[null,1.19,0,0.05,2.4E-2,0.01,1.19,0,0.02,0.03,0.01,null,null,null,null,null,null,0.2,0.01,0.02,2.4E-2,1.9685078740157482E-3]
[null,1.2,0.01,0.05,2.4E-2,0.01,1.2,0.05,0.03,0.03,0.05,null,null,null,null,null,null,0.3,0.03,0.06,2.4E-2,1.9685098425196849E-3]
[null,1.21,-0.02,0.05,2.4E-2,0.03,1.21,-0.03,0.03,0.03,1.9999999999999997E-2,null,null,null,null,null,null,0.5,0.04,0.06,2.9000000000000001E-2,1.9685137795275591E-3]
[null,1.22,0.02,0.05,2.4E-2,9.9999999999999985E-3,1.22,0.03,0.03,0.03,0,null,null,null,null,null,null,1,-0.06,7.0000000000000007E-2,2.9000000000000001E-2,1.9685236220472442E-3]
[null,1.23,-0.03,0.03,2.4E-2,9.9999999999999985E-3,1.23,0.06,0.02,0.03,3.9999999999999994E-2,null,null,null,null,null,null,2,0.08,0.03,5.5E-2,1.9685433070866141E-3]
[null,1.24,-0.03,0.05,2.4E-2,9.9999999999999985E-3,1.24,0.01,0.02,0.03,0.01,null,null,null,null,null,null,4,0.02,0.15,9.0999999999999998E-2,1.9685826771653541E-3]
[null,1.25,-0.05,0.08,2.4E-2,6.0000000000000005E-2,1.25,0.01,0.03,0.03,0,null,null,null,null,null,null,6,3,6,13,1.9686220472440947E-3]
[null,1.26,0,0.04,2.4E-2,0.05,1.26,-0.02,0.02,0.03,3.0000000000000002E-2]
[null,1.27,-0.02,0.04,2.4E-2,0.03,1.27,0.04,0.02,0.03,0.03]
[null,1.28,-0.03,0.03,2.4E-2,0.03,1.28,0.04,0.02,0.03,0.04]
[null,1.29,0.02,0.04,2.4E-2,3.0000000000000002E-2,1.29,0.01,0.05,0.03,0.04]
[null,1.3,-0.2,0.03,2.4E-2,0.18000000000000002,1.3,-0.01,0.02,0.03,0.01]
[null,1.31,0.01,0.04,2.4E-2,0.01,1.31,0.02,0.01,0.03,0.02]
[null,1.32,-0.02,0.03,2.4E-2,0,1.32,0.03,0.02,0.03,9.9999999999999985E-3]
[null,1.33,-0.01,0.03,2.4E-2,0,1.33,0.03,0.02,0.03,1.9999999999999997E-2]
[null,1.34,0,0.04,2.4E-2,0.02,1.34,0.02,0.01,0.03,0]
[null,1.35,-0.01,0.05,2.4E-2,0.02,1.35,-0.01,0.04,0.03,0]
[null,1.36,0.04,0.06,2.4E-2,1.0000000000000002E-2,1.36,0,0.01,0.03,0.05]
[null,1.37,-0.03,0.04,2.4E-2,0.05,1.37,0.03,0.03,0.03,9.9999999999999985E-3]
[null,1.38,-0.02,0.04,2.4E-2,0,1.38,0.05,0.03,0.03,3.8000000000000006E-2]
[null,1.39,-0.02,0.03,2.4E-2,3.0000000000000002E-2,1.39,0.06,0.02,0.03,9.999999999999995E-3]
[null,1.4,-0.02,0.02,2.4E-2,0.02,1.4,0.06,0.02,0.03,1.9999999999999997E-2]
[null,1.41,0,0.03,2.4E-2,0.01,1.41,0.01,0.02,0.03,0]
[null,1.42,-0.04,0.04,2.4E-2,0.04,1.42,-0.03,0.02,0.03,0.03]
[null,1.43,0.03,0.03,2.4E-2,0,1.43,0,0.01,0.03,0.03]
[null,1.44,0.01,0.03,2.4E-2,0,1.44,0.01,0.01,0.03,0]
[null,1.45,-0.03,0.05,2.4E-2,1.9999999999999997E-2,1.45,0,0.04,0.03,0.01]
[null,1.46,-7.0000000000000007E-2,0.03,2.4E-2,0.05,1.46,0.03,0.03,0.03,9.9999999999999985E-3]
[null,1.47,-0.03,0.06,2.4E-2,0.04,1.47,-0.04,0.03,0.03,0.03]
[null,1.48,-0.05,0.04,2.4E-2,0.04,1.48,-0.01,0.01,0.03,0]
[null,1.49,-0.05,0.03,2.4E-2,3.0000000000000002E-2,1.49,0,"0 ,02",0.03,0.02]
[null,1.5,0.01,0.05,2.4E-2,0.01,1.5,0.06,0.03,0.03,0.06]
[null,2,-0.04,0.05,2.4E-2,1.0000000000000002E-2,2,-0.04,0.04,0.03,0.04]
[null,2.5,-0.03,7.0000000000000007E-2,2.4E-2,1.9999999999999997E-2,2.5,0.01,0.06,0.03,0]
[null,3,0,0.05,2.4E-2,0,3,0.02,0.03,0.03,0.02]
[null,3.5,0.01,0.04,2.4E-2,0.03,3.5,0.04,0.02,0.03,0.02]
[null,4,-0.04,0.04,2.4E-2,0.09,4,-0.05,0.02,0.03,0]
[null,4.5,0,0.05,2.4E-2,0.04,4.5,0.03,0.02,0.03,1.0000000000000002E-2]
[null,5,-0.02,0.06,2.4E-2,3.0000000000000002E-2,5,0.02,0.03,0.03,3.0000000000000002E-2]
[null,5.5,0.05,0.05,2.4E-2,9.999999999999995E-3,5.5,0.27,0.03,0.03,0.21000000000000002]
[null,6,0.02,0.02,2.4E-2,0,6,-0.01,0.04,0.03,0.01]
[null,6.5,0.02,0.04,2.4E-2,9.9999999999999985E-3,6.5,-7.0000000000000007E-2,0.02,0.03,4.0000000000000008E-2]
[null,7,0.2,0.05,2.4E-2,0.16,7,-0.08,0.04,0.03,0.04]
[null,7.5,-0.05,0.04,2.4E-2,0.04,7.5,-0.05,0.02,0.03,0.04]
[null,8,7.0000000000000007E-2,7.0000000000000007E-2,2.4E-2,1.0000000000000009E-2,8,0.06,0.04,0.03,0]
[null,8.5,-0.08,0.24,2.4E-2,0.03,8.5,-0.08,0.03,0.03,0.03]
[null,9,-0.04,0.06,2.4E-2,1.0000000000000002E-2,9,-0.08,0.03,0.03,0.03]
[null,9.5,0.04,7.0000000000000007E-2,2.4E-2,1.9999999999999997E-2,9.5,0.04,0.02,0.03,1.9999999999999997E-2]
[null,10,-0.04,0.05,2.4E-2,0,10,-0.04,0.04,0.03,0]
[null,20,-0.09,0.02,2.9000000000000001E-2,6.9999999999999993E-2,20,-0.08,0.04,3.1E-2,0.06]
[null,30,0.06,0.04,5.5E-2,1.0000000000000009E-2,30,-1.31,0.14000000000000001,5.5E-2,1.24]
[null,40,0.04,0.08,5.5E-2,1.9999999999999997E-2,40,-0.01,0.06,5.5E-2,4.9999999999999996E-2]
[null,50,0.01,0.11,5.5E-2,0.03,50,0.12,7.0000000000000007E-2,5.5E-2,7.9999999999999988E-2]
[null,60,0.24,0.15,0.08,0.22999999999999998,60,-0.01,7.0000000000000007E-2,0.08,0,null,"Grado",null,"Cambios máximos por año permitidos en longitud"]
[null,70,0.08,0.06,0.08,0.14000000000000001,70,0.23,0.16,0.08,0.17,null,"K, 0",null," (0,02 µm + 0,25  10-6  L)",null,null,null,null,"Datos_Bloques_CS_JBP_008",null,null,"Pulgadas"]
[null,80,-0.08,0.28000000000000003,9.0999999999999998E-2,0,80,0.04,0.06,9.0999999999999998E-2,0.04,null,"1, 2",null," (0,05 µm + 0,5  10-6  L)",null,null,0.02,2.4999999999999999E-7,null,null,null,{"$f":"(S101/1000)/25.4","v":9.8425196850393697E-12}]
[null,90,-0.28000000000000003,0.12,9.0999999999999998E-2,0.21000000000000002,90,-0.14000000000000001,0.08,9.0999999999999998E-2,7.0000000000000007E-2,null,"NOTA - L se expresa en milímetros",null,null,null,null,0.05,4.9999999999999998E-7,null,null,null,{"$f":"(S102/1000)/25.4","v":1.9685039370078739E-11}]
[null,100,-0.08,0.08,9.0999999999999998E-2,0.2,100,-0.25,0.08,9.0999999999999998E-2,0.13]
["Bloque individual",-100,-0.01,0.12,9.0999999999999998E-2,0.14000000000000001,-100,-0.01,0.12,9.0999999999999998E-2,0.14000000000000001,null,"Instrumento:",null,null,"Bloques patrón"]
["Juego de bloques SWT 500mm",125,0.38,0.1,0.3,{"$f":"$R$102+($S$102*B105)","v":5.0062500000000003E-2},125,0.38,0.1,0.3,{"$f":"$R$102+($S$102*G105)","v":5.0062500000000003E-2},null,"Marca:",null,"Marca:","SWT"]
[null,150,-0.06,0.18,0.32,5.0075000000000001E-2,150,-0.06,0.18,0.32,5.0075000000000001E-2,null,"Grado",null,"Modelo:",1]
[null,175,-0.57999999999999996,0.21,0.34,5.00875E-2,175,-0.57999999999999996,0.21,0.34,5.00875E-2,null,"Rango:",null,"Rango:","125 mm a 500 mm"]
[null,200,-0.5,0.17,0.36,5.0100000000000006E-2,200,-0.5,0.17,0.36,5.0100000000000006E-2,null,"Serie:",null,"Serie:","160203 / CS-JBP-008"]
[null,250,-0.72,0.14000000000000001,0.41,5.0125000000000003E-2,250,-0.72,0.14000000000000001,0.41,5.0125000000000003E-2,null,"Certificado No:",null,"Certificado No:","LMD170789"]
[null,300,-0.84,0.2,0.45,5.015E-2,300,-0.84,0.2,0.45,5.015E-2,null,"Fecha de calibración:",null,"Fecha de calibración:","Abril 28 de 2017"]
[null,400,0.66,0.23,0.57999999999999996,5.0200000000000002E-2,400,0.66,0.23,0.57999999999999996,5.0200000000000002E-2,{"$f":"(R101/1000)/25.4","v":7.8740157480314972E-7},"Próxima calibración:",null,"Próxima calibración:","Abril 28 de 2018"]
[null,500,1.31,0.25,0.71,5.0250000000000003E-2,500,1.31,0.25,0.71,5.0250000000000003E-2,{"$f":"(R102/1000)/25.4","v":1.9685039370078741E-6}]
[null,"NO","NO","NO","NO","NO","NO","NO","NO","NO","NO"]
[null,"Calliper ext"]
[null,0]
[null,20]
[null,50]
[null,100]
[null,150]
[null,200]
[null,300]
[null,400]
[null,500]
[null,550]
[null,600]
[null,"Calliper int"]
[null,0]
[null,20]
[null,50]
[null,100]
[null,150]
[null,200]
[null,300]
[null,400]
[null,500]
[null,550]
[null,600]
[null,"Pulgadas"]
[null,0.1]
[null,0.10005]
[null,0.10009999999999999]
[null,0.1002]
[null,0.1003]
[null,0.1004]
[null,0.10050000000000001]
[null,0.10059999999999999]
[null,0.1007]
[null,0.1008]
[null,0.1009]
[null,0.10100000000000001]
[null,0.10199999999999999]
[null,0.10299999999999999]
[null,0.104]
[null,0.105]
[null,0.106]
[null,0.107]
[null,0.108]
[null,0.109]
[null,0.11]
[null,0.12]
[null,0.13]
[null,0.14000000000000001]
[null,0.15]
[null,0.16]
[null,0.17]
[null,0.18]
[null,0.19]
[null,0.2]
[null,0.3]
[null,0.5]
[null,1]
[null,2]
[null,4]
[null,6]

{"sheet":"CORRECCIÓN INST AUX","index":12,"n_rows":56,"n_cols":9,"rows_kept":56,"cut":false,"hidden":true,"merged":[[54,0,54,1],[54,2,54,4],[54,6,54,8],[55,0,55,1],[55,2,55,4],[52,0,52,1],[52,2,52,4],[52,6,52,8],[53,0,53,1],[53,2,53,4],[53,6,53,8],[47,0,47,1],[47,2,47,4],[47,6,47,8],[48,0,48,1],[48,2,48,4],[45,0,45,1],[45,2,45,4],[45,6,45,8],[46,0,46,1],[46,2,46,4],[46,6,46,8],[38,0,38,1],[38,2,38,4],[38,6,38,8],[39,0,39,1],[39,2,39,4],[39,6,39,8],[40,0,40,1],[40,2,40,4],[40,6,40,8],[41,0,41,1],[41,2,41,4],[21,0,21,1],[21,2,21,4],[21,6,21,8],[3,6,3,8],[20,0,20,1],[20,2,20,4],[25,1,25,7],[26,0,26,7],[23,0,23,1],[23,2,23,4],[22,0,22,1],[22,2,22,4],[22,6,22,8],[0,0,0,7],[20,6,20,8],[6,0,6,1],[1,0,1,1],[1,2,1,4],[3,2,3,4],[3,0,3,1],[4,0,4,1],[4,2,4,4],[2,0,2,1],[2,2,2,4],[1,6,1,8],[2,6,2,8],[6,2,6,7]]}
["TERMOHIGRÓMETRO T&D"]
["Instrumento:",null,"TERMOHIGRÓMETRO DIGITAL",null,null,"Marca:","T&D CORPORATION"]
["Serie:",null,"42BC021C",null,null,"Modelo:","RTR-503"]
["Certificado No:",null,"CMK-TH-17183 / CMK-HR-17196",null,null,"Rango:","18°C a 28 °C / 30 %HR a 70%HR"]
["Fecha de calibración:",null,"2017-08-03",null,null,"Resolución:",0.1,"U:",{"$f":"MAX(D9:D11)","v":0.25}]
[]
[1,null,"INSTALACIONES PERMANENTES"]
["Patrón","Instrumento","Corrección","U","Patrón","Instrumento","Corrección","U"]
[18.010000000000002,18.2,-0.19,0.25,29.99,31,-1,1.3]
[23.02,23.4,-0.39,0.25,50,51,-1,1.5]
[28.01,28.3,-0.28999999999999998,0.25,70,72,-2,1.5]
["Minimo"]
["Temperatura",5.7999999999999996E-3,{"$f":"(#REF!)^2","v":{"$error":"#REF!"}},-0.28089999999999998,{"$f":"#REF!","v":{"$error":"#REF!"}},2.9923000000000002,"Temp (°C)",{"$f":"(B13*C13)+(D13*E13)+F13","v":{"$error":"#REF!"}}]
["Humedad",-1.1999999999999999E-3,{"$f":"(#REF!)^2","v":{"$error":"#REF!"}},9.5200000000000007E-2,{"$f":"#REF!","v":{"$error":"#REF!"}},-2.8361999999999998,"Hum (%HR)",{"$f":"(B14*C14)+(D14*E14)+F14","v":{"$error":"#REF!"}}]
["Máximo"]
["Temperatura",5.7999999999999996E-3,{"$f":"(#REF!)^2","v":{"$error":"#REF!"}},-0.28089999999999998,{"$f":"#REF!","v":{"$error":"#REF!"}},2.9923000000000002,"Temp (°C)",{"$f":"(B16*C16)+(D16*E16)+F16","v":{"$error":"#REF!"}}]
["Humedad",-1.1999999999999999E-3,{"$f":"(#REF!)^2","v":{"$error":"#REF!"}},9.5200000000000007E-2,{"$f":"#REF!","v":{"$error":"#REF!"}},-2.8361999999999998,"Hum (%HR)",{"$f":"(B17*C17)+(D17*E17)+F17","v":{"$error":"#REF!"}}]
[]
[]
[]
["Instrumento:",null,"TERMOHIGRÓMETRO",null,null,"Marca:","EXTECH"]
["Serie:",null,"A.078181",null,null,"Modelo:","SD700"]
["Certificado No:",null,"CMK-TH-17747 / CMK-HR-17744",null,null,"Rango:","18°C a 28°C"]
["Fecha de calibración:",null,"2017-08-10/ 2017-08-11",null,null,"Resolución:",0.1,"U:",{"$f":"MAX(D29:D31)","v":0.42}]
[]
[2,"SITIO"]
["Correcciones condiciones ambientales"]
["Patrón","Instrumento","Corrección","U","Patrón","Instrumento","Corrección","U"]
[18.05,18.100000000000001,-0.05,0.42,30.03,28.3,1.7,2]
[24.05,24.3,-0.25,0.42,50.02,48.3,1.7,2]
[28.01,28.3,-0.28999999999999998,0.42,70.010000000000005,68.3,1.7,2]
["Minimo"]
["Temperatura",2.2000000000000001E-3,{"$f":"(#REF!)^2","v":{"$error":"#REF!"}},-0.12479999999999999,{"$f":"#REF!","v":{"$error":"#REF!"}},1.4937,"Temp (°C)",{"$f":"(B33*C33)+(D33*E33)+F33","v":{"$error":"#REF!"}}]
["Humedad",0,{"$f":"(#REF!)^2","v":{"$error":"#REF!"}},8.9999999999999996E-17,{"$f":"#REF!","v":{"$error":"#REF!"}},1.7,"Hum (%HR)",{"$f":"(B34*C34)+(D34*E34)+F34","v":{"$error":"#REF!"}}]
["Máximo"]
["Temperatura",2.2000000000000001E-3,{"$f":"(#REF!)^2","v":{"$error":"#REF!"}},-0.12479999999999999,{"$f":"#REF!","v":{"$error":"#REF!"}},1.4937,"Temp (°C)",{"$f":"(B36*C36)+(D36*E36)+F36","v":{"$error":"#REF!"}}]
["Humedad",0,{"$f":"(#REF!)^2","v":{"$error":"#REF!"}},8.9999999999999996E-17,{"$f":"#REF!","v":{"$error":"#REF!"}},1.7,"Hum (%HR)",{"$f":"(B37*C37)+(D37*E37)+F37","v":{"$error":"#REF!"}}]
[]
["Instrumento:",null,"MICRÓMETRO EXTERIORES DIGITAL",null,null,"Marca:","MITUTOYO"]
["Serie:",null,25078834,null,null,"Modelo:","293-240"]
["Certificado No:",null,"CD-1444",null,null,"Rango:","0 mm a 25 mm"]
["Fecha de calibración:",null,"Marzo 6 de 2017",null,null,"Resolución:","0,001 mm","U:",0.72]
[null,null,null,null,null,null,null,"k:",2]
[]
[]
["Instrumento:",null,"PLANO ÓPTICO",null,null,"Marca:","MITUTOYO"]
["Serie:",null,"004251",null,null,"Modelo:","158-120"]
["Certificado No:",null,1205648,null,null,"Rango:","N.A."]
["Fecha de calibración:",null,"Febrero 12 de 2018",null,null,"Resolución:","N.A.","U:","0,064 µm"]
[]
[]
[]
["Instrumento:",null,"JUEGO DE PARALELOS ÓPTICOS",null,null,"Marca:","MITUTOYO"]
["Serie:",null,"006367",null,null,"Modelo:","157-903"]
["Certificado No:",null,1205649,null,null,"Rango:","N.A."]
["Fecha de calibración:",null,"Febrero 12 de 2018",null,null,"Resolución:","N.A.","U:","0,087 µm"]

{"sheet":"TABLA DE CONVERSIÓN 1","index":13,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":true,"merged":[[0,0,0,12]]}
["TABLAS DE CONVERSIÓN PARA UNIDADES DE PRESIÓN - NTC 3669:1995"]
["UNIDADES","m","mm","μm","in","mil"]
["m",1,1000,1000000,39.370100000000001,39370.1]
["mm",1E-3,1,1000,3.9369960000000002E-2,39.370100000000001]
["μm",9.9999999999999995E-7,1E-3,1,3.9369960000000001E-5,3.9370080000000002E-2]
["in",2.5399999999999999E-2,25.4,25400,1,1000]
["mil",2.5399999999999997E-5,2.5399999999999999E-2,25.4,1E-3,1]

{"sheet":"TABLA DE CONVERSIÓN ","index":14,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":true,"merged":[[0,0,0,12]]}
["TABLAS DE CONVERSIÓN PARA UNIDADES "]
["UNIDADES","m","mm","μm","in","mil"]
["m",1,1000,1000000,39.370100000000001,39370.1]
["mm",1E-3,1,1000,3.9369960000000002E-2,39.370100000000001]
["μm",9.9999999999999995E-7,1E-3,1,3.9369960000000001E-5,3.9370080000000002E-2]
["in",2.5399999999999999E-2,25.4,25400,1,1000]
["mil",2.5399999999999997E-5,2.5399999999999999E-2,25.4,1E-3,1]