{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Intro","Portada","Index","1-Dades Generals","2-Index","Detall base","3-Index","Calibrat H 1","Calibrat H 2","Ruta H 1","Ruta H 2","4-Index","5-Index","Certificat","Base Calibrat"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Intro","index":0,"n_rows":139,"n_cols":10,"rows_kept":139,"cut":false,"hidden":false,"merged":[[43,2,43,5],[55,1,55,3],[45,1,45,3],[14,1,14,3],[8,2,8,5],[9,2,9,5],[50,1,50,3],[107,2,107,7],[140,1,140,7],[42,2,42,5],[51,1,51,3],[54,1,54,3],[138,2,138,7],[139,1,139,7],[108,1,108,7],[109,1,109,7],[56,1,56,3],[58,1,58,3],[59,1,59,3],[60,1,60,3],[46,1,46,3],[47,1,47,3],[49,1,49,3],[2,1,2,8],[18,4,18,5],[32,2,32,4],[34,2,34,4],[11,2,11,5],[7,2,7,5],[10,2,10,5],[26,3,26,7],[3,3,3,6],[25,3,25,7],[24,3,24,7],[27,3,27,7]]}
["JRS-v3.3"]
[]
[null,"FORMULARI D'HOMOLOGACIÓ CIRCUITS EN RUTA"]
[null,null,null,"Escriure només a les caselles blaves"]
[]
[null,"DADES DE LA PROVA"]
[]
[null,"Nom de la prova:"]
[null,"Organitzador:"]
[null,"Responsable:"]
[null,"Telèfon:"]
[null,"Ubicació:"]
[null,"Data de la prova:"]
[null,"Data de la medició:"]
[null,"Tipus circuit (en cercle, de punt a punt, etc.):"]
[null,"Recorregut:"]
[null,"Tipus de prova:"]
[null,"Mètode de medició: ( Bicicleta , Roda , Cinta d'acer ) :"]
[null,null,null,null,"Distància de la prova:",null,null,"metres"]
[null,null,null,null,"Distància mesurada:",null,null,"metres"]
[]
[]
[null,"DETALL DE LA BASE"]
[]
[null,"Situació de la base del Calibrat:"]
[null,"Ciutat:"]
[null,"Nº Registre:"]
[null,"Homologador(s) de la base:"]
[null,"Distància de la Base:",null,null,"metres"]
[]
[]
[null,"HOMOLOGADORS"]
[null,"Homologador 1:",null,null,null,"Categoria:"]
[]
[null,"Homologador 2:",null,null,null,"Categoria:"]
[]
[]
[null,"Lectures Comptador Jones"]
[null,"Hora pre-mesurament:"]
[null,"Hora post-mesurament:"]
[null,"Temperatura pre:"]
[null,"Temperatura post:"]
[null,"Condicions:"]
[null,"Comentari:"]
[]
[null,"PRE-CALIBRAT - Homologador 1",null,null,"1ª PASSADA","2ª PASSADA","3ª PASSADA","4ª PASSADA"]
[null,"SORTIDA"]
[null,"FINAL"]
[null,null,null,null,{"$f":"+E48-E47","v":0},{"$f":"+F48-F47","v":0},{"$f":"+G48-G47","v":0},{"$f":"+H48-H47","v":0},"K-pre :",{"$f":"+IF($D$29=\"\",\"\",(E49+F49+G49+H49)/4/$D$29*1001)","v":""}]
[null,"POST-CALIBRAT -Homologador 1",null,null,"1ª PASSADA","2ª PASSADA","3ª PASSADA","4ª PASSADA"]
[null,"SORTIDA",null,null,null,null,null,null,"   K-dia :",{"$f":"+IF($D$29=\"\",\"\",(J49+J53)/2)","v":""}]
[null,"FINAL"]
[null,null,null,null,{"$f":"+E52-E51","v":0},{"$f":"+F52-F51","v":0},{"$f":"+G52-G51","v":0},{"$f":"+H52-H51","v":0},"K-post :",{"$f":"+IF($D$29=\"\",\"\",(E53+F53+G53+H53)/4/$D$29*1001)","v":""}]
[]
[null,"PRE-CALIBRAT - Homologador 2",null,null,"1ª PASSADA","2ª PASSADA","3ª PASSADA","4ª PASSADA"]
[null,"SORTIDA"]
[null,"FINAL"]
[null,null,null,null,{"$f":"+E57-E56","v":0},{"$f":"+F57-F56","v":0},{"$f":"+G57-G56","v":0},{"$f":"+H57-H56","v":0},"K-pre :",{"$f":"+IF($D$29=\"\",\"\",(E58+F58+G58+H58)/4/$D$29*1001)","v":""}]
[null,"POST-CALIBRAT-Homologador 2",null,null,"1ª PASSADA","2ª PASSADA","3ª PASSADA","4ª PASSADA"]
[null,"SORTIDA",null,null,null,null,null,null,"K-dia :",{"$f":"+IF($D$29=\"\",\"\",(J58+J62)/2)","v":""}]
[null,"FINAL"]
[null,null,null,null,{"$f":"+E61-E60","v":0},{"$f":"+F61-F60","v":0},{"$f":"+G61-G60","v":0},{"$f":"+H61-H60","v":0},"K-post :",{"$f":"+IF($D$29=\"\",\"\",(E62+F62+G62+H62)/4/$D$29*1001)","v":""}]
[]
[null,"FULL DE RUTA:"]
[]
[null,"Hora d'inici:"]
[null,"Temperatura:"]
[]
[null,"Hora final:"]
[null,"Temperatura:"]
[]
[null,"ALTITUD"]
[null,"Sortida:"]
[null,"Arribada:"]
[null,"Punt mes alt:"]
[null,"Punt mes baix:"]
[]
[null,"Distància en línia recta "]
[null,"(entre sortida i arribada)"]
[]
[]
[null,"HOMOLOGADOR 1"]
[null,"PARADES","Nº COMPTADOR"]
[null,"SORTIDA"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"REAJUST REALITZAT:"]
[]
[]
[]
[]
[null,"HOMOLOGADOR 2"]
[null,"PARADES","Nº COMPTADOR"]
[null,{"$f":"IF(B84=\"\",\"\",B84)","v":"SORTIDA"}]
[null,{"$f":"IF(B85=\"\",\"\",B85)","v":""}]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]
[]
[null,"REAJUST REALITZAT:"]

{"sheet":"Portada","index":1,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[[20,1,20,5],[22,1,22,7]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Trafalgar, 12 entresol 2ª"]
[null,null,null,null,null,null,"08010 BARCELONA"]
[null,null,null,null,null,null,"Tel.- 93 268 79 22"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Informe d’homologació"]
[]
[null,{"$f":"+IF(Intro!C8=\"\",\"\",Intro!C8)","v":""}]

{"sheet":"Index","index":2,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Trafalgar, 12 entresol 2ª"]
[null,null,null,null,null,null,"08010 BARCELONA"]
[null,null,null,null,null,null,"Tel.- 93 268 79 22"]
[]
[null,"APARTATS DE L’INFORME "]
[null," "]
[null,"1.- Dades generals "]
[null," "]
[null,"2.- Base de calibrat "]
[null," "]
[null,null,"Detall de la base de calibrat"]
[]
[null,null,"Certificació de la base de calibrat           "]
[]
[null,null,"Plànols de la base de calibrat  "]
[null," "]
[]
[null,"3.- Mesurament de la prova "]
[null," "]
[null,null,"Lectures dels comptadors (Pre i Postcalibrat) "]
[]
[null,null,"Full de ruta "]
[null," "]
[null," "]
[null,"4.- El recorregut "]
[null," "]
[null,null,"Generalitats del recorregut "]
[]
[null,null,"Descripció recorregut"]
[]
[null,null,"Plànol general"]
[null," "]
[null,null,"Sortida / Arribada"]
[]
[null,null,"Detalls del circuit"]
[]
[null," "]
[null,"5.- Certificat d’homologació "]

{"sheet":"1-Dades Generals","index":3,"n_rows":41,"n_cols":10,"rows_kept":41,"cut":false,"hidden":false,"merged":[[40,2,40,9],[30,4,30,9],[32,2,32,6],[32,7,32,8],[36,1,36,9],[37,2,37,9],[38,2,38,9],[39,1,39,3],[39,6,39,7],[39,8,39,9],[25,2,25,3],[29,1,29,9],[30,2,30,3],[31,2,31,6],[31,7,31,8],[24,4,24,5],[24,6,24,7],[14,1,14,9],[15,2,15,9],[16,2,16,9],[17,2,17,9],[18,2,18,3],[18,4,18,5],[18,6,18,7],[18,8,18,9],[19,2,19,5],[19,6,19,7],[19,8,19,9],[23,1,23,9],[24,2,24,3]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Trafalgar, 12 entresol 2ª"]
[null,null,null,null,null,null,null,null,"08010 BARCELONA"]
[null,null,null,null,null,null,null,null,"Tel.- 93 268 79 22"]
[]
[null,null,{"$f":"+Index!B13","v":"1.- Dades generals "}]
[]
[]
[]
[null,"Dades de la prova"]
[null,"Prova",{"$f":"+Intro!C8","v":0}]
[null,"Organitzador",{"$f":"+Intro!C9","v":0}]
[null,"Localitat/s",{"$f":"+Intro!C12","v":0}]
[null,"Data de la prova",{"$f":"+Intro!C13","v":"00:00:00"},null,null,null,"Prova del calendari",null,"Català"]
[null,"Responsable",{"$f":"+Intro!C10","v":"00:00:00"},null,null,null,"Telèfon",null,{"$f":"+Intro!C11","v":0}]
[]
[]
[]
[null,"Dades del recorregut"]
[null,"Distància de la prova",{"$f":"+Intro!G19","v":0},null,"Recorregut",null,{"$f":"+Intro!E16","v":0},null,"Prova de ",{"$f":"+Intro!E17","v":0}]
[null,"Tipus de circuit",{"$f":"+Intro!E15","v":0}]
[]
[]
[]
[null,"Dades del mesurament"]
[null,"Data",{"$f":"+Intro!C14","v":"00:00:00"}]
[null,"Mesurador FCA 1",{"$f":"+Intro!C33","v":0},null,null,null,null,"Categoria",null,{"$f":"+Intro!G33","v":0}]
[null,"Mesurador  FCA 2",{"$f":"IF(Intro!C35=\"\",\"\",+Intro!C35)","v":""},null,null,null,null,"Categoria",null,{"$f":"IF(Intro!G35=\"\",\"\",+Intro!G35)","v":""}]
[]
[]
[]
[null,"Base de calibrat"]
[null,"Localització",{"$f":"+Intro!D25","v":0}]
[null,"Localitat",{"$f":"+Intro!D26","v":0}]
[null,"Distància de la base de calibrat",null,null,{"$f":"+Intro!D29","v":0},"metres","Núm. de registre",null,{"$f":"+Intro!D27","v":0}]
[null,"Homologador/s",{"$f":"+Intro!D28","v":0}]

{"sheet":"2-Index","index":4,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Trafalgar, 12 entresol 2ª"]
[null,null,null,null,null,null,"08010 BARCELONA"]
[null,null,null,null,null,null,"Tel.- 93 268 79 22"]
[]
[]
[]
[]
[]
[null,{"$f":"IF(Index!B15=\"\",\"\",Index!B15)","v":"2.- Base de calibrat "}]
[null," ",{"$f":"IF(Index!C16=\"\",\"\",Index!C16)","v":""}]
[null,null,{"$f":"IF(Index!C17=\"\",\"\",Index!C17)","v":"Detall de la base de calibrat"}]
[null,null,{"$f":"IF(Index!C18=\"\",\"\",Index!C18)","v":""}]
[null,null,{"$f":"IF(Index!C19=\"\",\"\",Index!C19)","v":"Certificació de la base de calibrat           "}]
[null,null,{"$f":"IF(Index!C20=\"\",\"\",Index!C20)","v":""}]
[null,null,{"$f":"IF(Index!C21=\"\",\"\",Index!C21)","v":"Plànols de la base de calibrat  "}]
[null,null,{"$f":"IF(Index!C22=\"\",\"\",Index!C22)","v":""}]

{"sheet":"Detall base","index":5,"n_rows":45,"n_cols":8,"rows_kept":45,"cut":false,"hidden":false,"merged":[[46,2,46,7],[38,5,38,7],[44,1,44,3],[42,1,42,3],[42,4,42,7],[44,4,44,7],[54,6,54,8],[52,6,52,8],[24,1,24,2],[26,1,26,3],[28,1,28,3],[24,3,24,7],[34,1,34,4],[36,1,36,4],[38,1,38,4],[32,1,32,4],[26,4,26,7],[30,2,30,7],[32,5,32,7],[28,4,28,6],[34,5,34,7],[36,5,36,7]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Trafalgar, 12 entresol 2ª"]
[null,null,null,null,null,null,null,"08010 BARCELONA"]
[null,null,null,null,null,null,null,"Tel.- 93 268 79 22"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"DETALL DE LA BASE DEL CALIBRAT"]
[]
[]
[]
[]
[]
[]
[null,"NOM DE LA PROVA :",null,{"$f":"IF(Intro!C8=\"\",\"\",Intro!C8)","v":""}]
[]
[null,"SITUACIÓ DE LA BASE DEL CALIBRAT :",null,null,{"$f":"IF(Intro!D25=\"\",\"\",Intro!D25)","v":""}]
[]
[null,"MIDA DE LA BASE DEL CALIBRAT :",null,null,{"$f":"IF(Intro!D29=\"\",\"\",Intro!D29)","v":""},null,null,"metres."]
[]
[null,"CIUTAT :",{"$f":"IF(Intro!D26=\"\",\"\",Intro!D26)","v":""}]
[]
[null,"Nº REGISTRE O DADES DE LA BASE DEL CALIBRAT:",null,null,null,{"$f":"IF(Intro!D27=\"\",\"\",Intro!D27)","v":""}]
[]
[null,"MÈTODE UTILITZAT PER MESURAR LA BASE :",null,null,null,"cinta metàl-lica d'acer"]
[]
[null,"NOMBRE DE PASSADES SOBRE LA BASE :",null,null,null,"dues"]
[]
[null,"TIPUS DE SENYALITZACIÓ DELS PUNTS \"A\" I \"B\" :",null,null,null,"claus i pintura"]
[]
[]
[]
[null,"HOMOLOGADOR DE LA BASE :",null,null,{"$f":"IF(Intro!D28=\"\",\"\",Intro!D28)","v":""}]
[]
[null,"HOMOLOGADOR DE LA PROVA:",null,null,{"$f":"IF(Intro!C33=\"\",\"\",IF(Intro!C35=\"\",Intro!C33,CONCATENATE(Intro!C33,\" i \",Intro!C35)))","v":""}]

{"sheet":"3-Index","index":6,"n_rows":20,"n_cols":7,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Trafalgar, 12 entresol 2ª"]
[null,null,null,null,null,null,"08010 BARCELONA"]
[null,null,null,null,null,null,"Tel.- 93 268 79 22"]
[]
[]
[]
[]
[]
[null,{"$f":"IF(Index!B24=\"\",\"\",Index!B24)","v":"3.- Mesurament de la prova "}]
[null,null,{"$f":"IF(Index!C25=\"\",\"\",Index!C25)","v":""}]
[null,null,{"$f":"IF(Index!C26=\"\",\"\",Index!C26)","v":"Lectures dels comptadors (Pre i Postcalibrat) "}]
[null,null,{"$f":"IF(Index!C27=\"\",\"\",Index!C27)","v":""}]
[null,null,{"$f":"IF(Index!C28=\"\",\"\",Index!C28)","v":"Full de ruta "}]
[null,null,{"$f":"IF(Index!C29=\"\",\"\",Index!C29)","v":""}]

{"sheet":"Calibrat H 1","index":7,"n_rows":54,"n_cols":9,"rows_kept":54,"cut":false,"hidden":false,"merged":[[34,1,34,3],[33,1,33,3],[11,1,11,9],[14,1,14,3],[20,1,20,3],[14,4,14,9],[20,4,20,5],[20,8,20,9],[17,1,17,6],[23,3,23,9],[31,5,31,6],[23,1,23,2],[26,3,26,9],[26,1,26,2],[54,8,54,9],[43,5,43,6],[35,1,35,3],[36,1,36,3],[45,1,45,3],[46,1,46,3],[53,1,53,5],[47,1,47,3],[48,1,48,3],[49,1,49,3],[50,1,50,3],[49,4,49,6],[37,1,37,3],[38,1,38,3],[37,4,37,6]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Trafalgar, 12 entresol 2ª"]
[null,null,null,null,null,null,null,null,"08010 BARCELONA"]
[null,null,null,null,null,null,null,null,"Tel.- 93 268 79 22"]
[]
[]
[null,"LECTURES DEL COMPTADOR JONES"]
[]
[]
[null,"NOM DE LA PROVA :",null,null,{"$f":"IF(Intro!C8=\"\",\"\",Intro!C8)","v":""}]
[]
[]
[null,"PRESA DE DADES SOBRE UNA DISTANCIA CALIBRADA DE :",null,null,null,null,null,{"$f":"IF(Intro!D29=\"\",\"\",Intro!D29)","v":""},"metres."]
[]
[]
[null,"NOM DE L' HOMOLOGADOR :",null,null,{"$f":"IF(Intro!C33=\"\",\"\",Intro!C33)","v":""},null,null,"CATEGORIA :",{"$f":"IF(Intro!G33=\"\",\"\",Intro!G33)","v":""}]
[]
[]
[null,"CONDICIONS :",null,{"$f":"IF(Intro!C43=\"\",\"\",Intro!C43)","v":""}]
[]
[]
[null,"COMENTARI :",null,{"$f":"IF(Intro!C44=\"\",\"\",Intro!C44)","v":""}]
[]
[]
[null,"CALIBRAT PRE-MESURAMENT"]
[]
[null,"DIA:",{"$f":"IF(Intro!C14=\"\",\"\",Intro!C14)","v":""},"HORA:",{"$f":"IF(Intro!C39=\"\",\"\",Intro!C39)","v":""},"TEMPERATURA:",null,{"$f":"IF(Intro!C41=\"\",\"\",Intro!C41)","v":""}]
[]
[null,"NÙMEROS COMPTADOR",null,null,"1ª PASSADA","2ª PASSADA","3ª PASSADA","4ª PASSADA"]
[null,"SORTIDA",null,null,{"$f":"Intro!E47","v":0},{"$f":"Intro!F47","v":0},{"$f":"Intro!G47","v":0},{"$f":"Intro!H47","v":0}]
[null,"FINAL",null,null,{"$f":"Intro!E48","v":0},{"$f":"Intro!F48","v":0},{"$f":"Intro!G48","v":0},{"$f":"Intro!H48","v":0}]
[null,"DIFERÈNCIA",null,null,{"$f":"+E36-E35","v":0},{"$f":"+F36-F35","v":0},{"$f":"+G36-G35","v":0},{"$f":"+H36-H35","v":0}]
[null,"MITJA",null,null,{"$f":"CONCATENATE(\"( \",E37,\" + \",F37,\" + \",G37,\" + \",H37,\" )   :  4  =\")","v":"( 0 + 0 + 0 + 0 )   :  4  ="},null,null,{"$f":"+(E37+F37+G37+H37)/4","v":0}]
[null,null,null,null,{"$f":"+H38","v":0},{"$f":"CONCATENATE(\":\",\"   \",H18)","v":":   "},"x  1,001  =",{"$f":"IF(Intro!D29=\"\",\"\",H38/H18*1001)","v":""}]
[]
[]
[null,"CALIBRAT POST-MESURAMENT"]
[]
[null,"DIA:",{"$f":"IF(Intro!C14=\"\",\"\",Intro!C14)","v":""},"HORA:",{"$f":"IF(Intro!C40=\"\",\"\",Intro!C40)","v":""},"TEMPERATURA:",null,{"$f":"IF(Intro!C42=\"\",\"\",Intro!C42)","v":""}]
[]
[null,"NÙMEROS COMPTADOR",null,null,"1ª PASSADA","2ª PASSADA","3ª PASSADA","4ª PASSADA"]
[null,"SORTIDA",null,null,{"$f":"Intro!E51","v":0},{"$f":"Intro!F51","v":0},{"$f":"Intro!G51","v":0},{"$f":"Intro!H51","v":0}]
[null,"FINAL",null,null,{"$f":"Intro!E52","v":0},{"$f":"Intro!F52","v":0},{"$f":"Intro!G52","v":0},{"$f":"Intro!H52","v":0}]
[null,"DIFERÈNCIA",null,null,{"$f":"+E48-E47","v":0},{"$f":"+F48-F47","v":0},{"$f":"+G48-G47","v":0},{"$f":"+H48-H47","v":0}]
[null,"MITJA",null,null,{"$f":"CONCATENATE(\"( \",E49,\" + \",F49,\" + \",G49,\" + \",H49,\" )   :  4  =\")","v":"( 0 + 0 + 0 + 0 )   :  4  ="},null,null,{"$f":"+(E49+F49+G49+H49)/4","v":0}]
[null,null,null,null,{"$f":"+H50","v":0},{"$f":"CONCATENATE(\":\",\"   \",H18)","v":":   "},"x  1,001  =",{"$f":"IF(Intro!D29=\"\",\"\",H50/H18*1001)","v":""}]
[]
[]
[null,"CONSTANT DE TREBALL PER AL DIA:",null,null,null,null,{"$f":"IF(Intro!D29=\"\",\"\",(H39+H51)/2)","v":""}]

{"sheet":"Calibrat H 2","index":8,"n_rows":54,"n_cols":9,"rows_kept":54,"cut":false,"hidden":false,"merged":[[54,8,54,9],[49,4,49,6],[50,1,50,3],[53,1,53,5],[46,1,46,3],[47,1,47,3],[48,1,48,3],[49,1,49,3],[37,4,37,6],[38,1,38,3],[43,5,43,6],[45,1,45,3],[34,1,34,3],[35,1,35,3],[36,1,36,3],[37,1,37,3],[31,5,31,6],[33,1,33,3],[20,1,20,3],[20,4,20,5],[20,8,20,9],[23,1,23,2],[23,3,23,9],[11,1,11,9],[14,1,14,3],[14,4,14,9],[17,1,17,6],[26,1,26,2],[26,3,26,9]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Trafalgar, 12 entresol 2ª"]
[null,null,null,null,null,null,null,null,"08010 BARCELONA"]
[null,null,null,null,null,null,null,null,"Tel.- 93 268 79 22"]
[]
[]
[null,"LECTURES DEL COMPTADOR JONES"]
[]
[]
[null,"NOM DE LA PROVA :",null,null,{"$f":"IF(Intro!C8=\"\",\"\",Intro!C8)","v":""}]
[]
[]
[null,"PRESA DE DADES SOBRE UNA DISTANCIA CALIBRADA DE :",null,null,null,null,null,{"$f":"IF(Intro!D29=\"\",\"\",Intro!D29)","v":""},"metres."]
[]
[]
[null,"NOM DE L' HOMOLOGADOR :",null,null,{"$f":"IF(Intro!C35=\"\",\"\",Intro!C35)","v":""},null,null,"CATEGORIA :",{"$f":"IF(Intro!G35=\"\",\"\",Intro!G35)","v":""}]
[]
[]
[null,"CONDICIONS :",null,{"$f":"IF(Intro!C43=\"\",\"\",Intro!C43)","v":""}]
[]
[]
[null,"COMENTARI :",null,{"$f":"IF(Intro!C44=\"\",\"\",Intro!C44)","v":""}]
[]
[]
[null,"CALIBRAT PRE-MESURAMENT"]
[]
[null,"DIA:",{"$f":"IF(Intro!C14=\"\",\"\",Intro!C14)","v":""},"HORA:",{"$f":"IF(Intro!C39=\"\",\"\",Intro!C39)","v":""},"TEMPERATURA:",null,{"$f":"IF(Intro!C41=\"\",\"\",Intro!C41)","v":""}]
[]
[null,"NÙMEROS COMPTADOR",null,null,"1ª PASSADA","2ª PASSADA","3ª PASSADA","4ª PASSADA"]
[null,"SORTIDA",null,null,{"$f":"Intro!E56","v":0},{"$f":"Intro!F56","v":0},{"$f":"Intro!G56","v":0},{"$f":"Intro!H56","v":0}]
[null,"FINAL",null,null,{"$f":"Intro!E57","v":0},{"$f":"Intro!F57","v":0},{"$f":"Intro!G57","v":0},{"$f":"Intro!H57","v":0}]
[null,"DIFERÈNCIA",null,null,{"$f":"+E36-E35","v":0},{"$f":"+F36-F35","v":0},{"$f":"+G36-G35","v":0},{"$f":"+H36-H35","v":0}]
[null,"MITJA",null,null,{"$f":"CONCATENATE(\"( \",E37,\" + \",F37,\" + \",G37,\" + \",H37,\" )   :  4  =\")","v":"( 0 + 0 + 0 + 0 )   :  4  ="},null,null,{"$f":"+(E37+F37+G37+H37)/4","v":0}]
[null,null,null,null,{"$f":"+H38","v":0},{"$f":"CONCATENATE(\":\",\"   \",H18)","v":":   "},"x  1,001  =",{"$f":"IF(Intro!D29=\"\",\"\",H38/H18*1001)","v":""}]
[]
[]
[null,"CALIBRAT POST-MESURAMENT"]
[]
[null,"DIA:",{"$f":"IF(Intro!C14=\"\",\"\",Intro!C14)","v":""},"HORA:",{"$f":"IF(Intro!C40=\"\",\"\",Intro!C40)","v":""},"TEMPERATURA:",null,{"$f":"IF(Intro!C42=\"\",\"\",Intro!C42)","v":""}]
[]
[null,"NÙMEROS COMPTADOR",null,null,"1ª PASSADA","2ª PASSADA","3ª PASSADA","4ª PASSADA"]
[null,"SORTIDA",null,null,{"$f":"Intro!E60","v":0},{"$f":"Intro!F60","v":0},{"$f":"Intro!G60","v":0},{"$f":"Intro!H60","v":0}]
[null,"FINAL",null,null,{"$f":"Intro!E61","v":0},{"$f":"Intro!F61","v":0},{"$f":"Intro!G61","v":0},{"$f":"Intro!H61","v":0}]
[null,"DIFERÈNCIA",null,null,{"$f":"+E48-E47","v":0},{"$f":"+F48-F47","v":0},{"$f":"+G48-G47","v":0},{"$f":"+H48-H47","v":0}]
[null,"MITJA",null,null,{"$f":"CONCATENATE(\"( \",E49,\" + \",F49,\" + \",G49,\" + \",H49,\" )   :  4  =\")","v":"( 0 + 0 + 0 + 0 )   :  4  ="},null,null,{"$f":"+(E49+F49+G49+H49)/4","v":0}]
[null,null,null,null,{"$f":"+H50","v":0},{"$f":"CONCATENATE(\":\",\"   \",H18)","v":":   "},"x  1,001  =",{"$f":"IF(Intro!D29=\"\",\"\",H50/H18*1001)","v":""}]
[]
[]
[null,"CONSTANT DE TREBALL PER AL DIA:",null,null,null,null,{"$f":"IF(Intro!D29=\"\",\"\",(H39+H51)/2)","v":""}]

{"sheet":"Ruta H 1","index":9,"n_rows":61,"n_cols":6,"rows_kept":61,"cut":false,"hidden":false,"merged":[[12,3,12,5],[58,2,58,5],[59,1,59,5],[12,1,12,2],[60,1,60,5],[15,3,15,5],[54,1,54,3],[55,1,55,3],[56,1,56,3],[15,1,15,2],[18,1,18,3]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Trafalgar, 12 entresol 2ª"]
[null,null,null,null,null,"08010 BARCELONA"]
[null,null,null,null,null,"Tel.- 93 268 79 22"]
[]
[null,null,null,"FULL DE RUTA"]
[]
[null,"MESURAMENT REALITZAT PER A LA PROVA:",null,{"$f":"IF(Intro!C8=\"\",\"\",Intro!C8)","v":""}]
[]
[]
[null,"DADES DEL MESURAMENT FETES PER:",null,{"$f":"IF(Intro!C33=\"\",\"\",Intro!C33)","v":""}]
[]
[]
[null,"MITJANA DEL CALIBRAT I POST CALIBRAT PER AL DIA:",null,null,{"$f":"'Calibrat H 1'!G54","v":""},"Nºs / Km"]
[]
[null,"DATA:",{"$f":"IF(Intro!C14=\"\",\"\",Intro!C14)","v":""}]
[]
[null,"HORA D'INICI:",{"$f":"IF(Intro!C66=\"\",\"\",Intro!C66)","v":""},"HORA FINAL:",{"$f":"IF(Intro!C69=\"\",\"\",Intro!C69)","v":""}]
[null,"TEMPERATURA:",{"$f":"IF(Intro!C67=\"\",\"\",Intro!C67)","v":""},"TEMPERATURA:",{"$f":"IF(Intro!C70=\"\",\"\",Intro!C70)","v":""}]
[]
[null,"ALTITUD","SORTIDA:","META:","PUNT MES ALT:","PUNT MES BAIX:"]
[null,null,{"$f":"IF(Intro!C73=\"\",\"\",Intro!C73)","v":""},{"$f":"IF(Intro!C74=\"\",\"\",Intro!C74)","v":""},{"$f":"IF(Intro!C75=\"\",\"\",Intro!C75)","v":""},{"$f":"IF(Intro!C76=\"\",\"\",Intro!C76)","v":""}]
[]
[null,"PARADES","Nº COMPTADOR","DIFERÈNCIA","METRES PARCIALS","METRES TOTALS"]
[null,"SORTIDA",{"$f":"IF(Intro!C84=\"\",\"\",Intro!C84)","v":""},"- - - - - - - - - - ","- - - - - - - - - - ","- - - - - - - - - - "]
[null,{"$f":"IF(Intro!B85=\"\",\"\",Intro!B85)","v":""},{"$f":"IF(Intro!C85=\"\",\"\",Intro!C85)","v":""},{"$f":"IF(C31=\"\",\"\",C31-C30)","v":""},{"$f":"IF(D31=\"\",\"\",D31*1000/$E$19)","v":""},{"$f":"+E31","v":""}]
[null,{"$f":"IF(Intro!B86=\"\",\"\",Intro!B86)","v":""},{"$f":"IF(Intro!C86=\"\",\"\",Intro!C86)","v":""},{"$f":"IF(C32=\"\",\"\",C32-C31)","v":""},{"$f":"IF(D32=\"\",\"\",D32*1000/$E$19)","v":""},{"$f":"IF(E32=\"\",\"\",+F31+E32)","v":""}]
[null,{"$f":"IF(Intro!B87=\"\",\"\",Intro!B87)","v":""},{"$f":"IF(Intro!C87=\"\",\"\",Intro!C87)","v":""},{"$f":"IF(C33=\"\",\"\",C33-C32)","v":""},"",{"$f":"IF(E33=\"\",\"\",+F32+E33)","v":""}]
[null,{"$f":"IF(Intro!B88=\"\",\"\",Intro!B88)","v":""},{"$f":"IF(Intro!C88=\"\",\"\",Intro!C88)","v":""},{"$f":"IF(C34=\"\",\"\",C34-C33)","v":""},"",""]
[null,{"$f":"IF(Intro!B89=\"\",\"\",Intro!B89)","v":""},{"$f":"IF(Intro!C89=\"\",\"\",Intro!C89)","v":""},{"$f":"IF(C35=\"\",\"\",C35-C34)","v":""},"",""]
[null,{"$f":"IF(Intro!B90=\"\",\"\",Intro!B90)","v":""},{"$f":"IF(Intro!C90=\"\",\"\",Intro!C90)","v":""},"","",""]
[null,{"$f":"IF(Intro!B91=\"\",\"\",Intro!B91)","v":""},{"$f":"IF(Intro!C91=\"\",\"\",Intro!C91)","v":""},"","",""]
[null,{"$f":"IF(Intro!B92=\"\",\"\",Intro!B92)","v":""},{"$f":"IF(Intro!C92=\"\",\"\",Intro!C92)","v":""},"","",""]
[null,{"$f":"IF(Intro!B93=\"\",\"\",Intro!B93)","v":""},{"$f":"IF(Intro!C93=\"\",\"\",Intro!C93)","v":""},"","",""]
[null,{"$f":"IF(Intro!B94=\"\",\"\",Intro!B94)","v":""},{"$f":"IF(Intro!C94=\"\",\"\",Intro!C94)","v":""},"","",""]
[null,{"$f":"IF(Intro!B95=\"\",\"\",Intro!B95)","v":""},{"$f":"IF(Intro!C95=\"\",\"\",Intro!C95)","v":""},"","",""]
[null,{"$f":"IF(Intro!B96=\"\",\"\",Intro!B96)","v":""},{"$f":"IF(Intro!C96=\"\",\"\",Intro!C96)","v":""},"","",""]
[null,{"$f":"IF(Intro!B97=\"\",\"\",Intro!B97)","v":""},{"$f":"IF(Intro!C97=\"\",\"\",Intro!C97)","v":""},"",{"$f":"IF(D43=\"\",\"\",D43*1000/$E$19)","v":""},""]
[null,{"$f":"IF(Intro!B98=\"\",\"\",Intro!B98)","v":""},{"$f":"IF(Intro!C98=\"\",\"\",Intro!C98)","v":""},"","",""]
[null,{"$f":"IF(Intro!B99=\"\",\"\",Intro!B99)","v":""},{"$f":"IF(Intro!C99=\"\",\"\",Intro!C99)","v":""},{"$f":"IF(C45=\"\",\"\",C45-C44)","v":""},{"$f":"IF(D45=\"\",\"\",D45*1000/$E$19)","v":""},{"$f":"IF(E45=\"\",\"\",+F44+E45)","v":""}]
[null,{"$f":"IF(Intro!B100=\"\",\"\",Intro!B100)","v":""},{"$f":"IF(Intro!C100=\"\",\"\",Intro!C100)","v":""},"","",""]
[null,{"$f":"IF(Intro!B101=\"\",\"\",Intro!B101)","v":""},{"$f":"IF(Intro!C101=\"\",\"\",Intro!C101)","v":""},"","",""]
[null,{"$f":"IF(Intro!B102=\"\",\"\",Intro!B102)","v":""},{"$f":"IF(Intro!C102=\"\",\"\",Intro!C102)","v":""},"","",""]
[null,{"$f":"IF(Intro!B103=\"\",\"\",Intro!B103)","v":""},{"$f":"IF(Intro!C103=\"\",\"\",Intro!C103)","v":""},"","",""]
[null,{"$f":"IF(Intro!B104=\"\",\"\",Intro!B104)","v":""},{"$f":"IF(Intro!C104=\"\",\"\",Intro!C104)","v":""},"","",""]
[null,{"$f":"IF(Intro!B105=\"\",\"\",Intro!B105)","v":""},{"$f":"IF(Intro!C105=\"\",\"\",Intro!C105)","v":""},"","",""]
[null,{"$f":"IF(Intro!B106=\"\",\"\",Intro!B106)","v":""},{"$f":"IF(Intro!C106=\"\",\"\",Intro!C106)","v":""},"","",""]
[]
[]
[null,"MESURAMENT DE LA PROVA AMB EL COMPTADOR \"JONES\":",null,null,{"$f":"IF(E31=\"\",\"\",SUM(E31:E52))","v":""},"metres."]
[null,"MIDA REAL DE LA PROVA:",null,null,{"$f":"IF(Intro!G20=\"\",\"\",Intro!G20)","v":""},"metres."]
[null,"DIFERÈNCIA:",null,null,{"$f":"IF(E56=\"\",\"\",E55-E56)","v":""},"metres."]
[]
[null,"REAJUST REALITZAT:",{"$f":"IF(Intro!C108=\"\",\"\",Intro!C108)","v":""}]
[null,{"$f":"IF(Intro!B109=\"\",\"\",Intro!B109)","v":""}]
[null,{"$f":"IF(Intro!B110=\"\",\"\",Intro!B110)","v":""}]

{"sheet":"Ruta H 2","index":10,"n_rows":60,"n_cols":6,"rows_kept":60,"cut":false,"hidden":false,"merged":[[12,1,12,2],[12,3,12,5],[15,1,15,2],[15,3,15,5],[57,2,57,5],[59,1,59,5],[18,1,18,3],[53,1,53,3],[54,1,54,3],[55,1,55,3],[58,1,58,5]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Trafalgar, 12 entresol 2ª"]
[null,null,null,null,null,"08010 BARCELONA"]
[null,null,null,null,null,"Tel.- 93 268 79 22"]
[]
[null,null,null,"FULL DE RUTA"]
[]
[null,"MESURAMENT REALITZAT PER A LA PROVA:",null,{"$f":"IF(Intro!C8=\"\",\"\",Intro!C8)","v":""}]
[]
[]
[null,"DADES DEL MESURAMENT FETES PER:",null,{"$f":"IF(Intro!C35=\"\",\"\",Intro!C35)","v":""}]
[]
[]
[null,"MITJANA DEL CALIBRAT I POST CALIBRAT PER AL DIA:",null,null,{"$f":"'Calibrat H 2'!G54","v":""},"Nºs / Km"]
[]
[null,"DATA:",{"$f":"IF(Intro!C14=\"\",\"\",Intro!C14)","v":""}]
[]
[null,"HORA D'INICI:",{"$f":"IF(Intro!C66=\"\",\"\",Intro!C66)","v":""},"HORA FINAL:",{"$f":"IF(Intro!C69=\"\",\"\",Intro!C69)","v":""}]
[null,"TEMPERATURA:",{"$f":"IF(Intro!C67=\"\",\"\",Intro!C67)","v":""},"TEMPERATURA:",{"$f":"IF(Intro!C70=\"\",\"\",Intro!C70)","v":""}]
[]
[null,"ALTITUD","SORTIDA:","META:","PUNT MES ALT:","PUNT MES BAIX:"]
[null,null,{"$f":"IF(Intro!C73=\"\",\"\",Intro!C73)","v":""},{"$f":"IF(Intro!C74=\"\",\"\",Intro!C74)","v":""},{"$f":"IF(Intro!C75=\"\",\"\",Intro!C75)","v":""},{"$f":"IF(Intro!C76=\"\",\"\",Intro!C76)","v":""}]
[]
[null,"PARADES","Nº COMPTADOR","DIFERÈNCIA","METRES PARCIALS","METRES TOTALS"]
[null,"SORTIDA",{"$f":"IF(Intro!C115=\"\",\"\",Intro!C115)","v":""},"- - - - - - - - - - ","- - - - - - - - - - ","- - - - - - - - - - "]
[null,{"$f":"IF(Intro!B116=\"\",\"\",Intro!B116)","v":""},{"$f":"IF(Intro!C116=\"\",\"\",Intro!C116)","v":""},{"$f":"IF(C31=\"\",\"\",C31-C30)","v":""},{"$f":"IF(D31=\"\",\"\",D31*1000/$E$19)","v":""},{"$f":"+E31","v":""}]
[null,{"$f":"IF(Intro!B117=\"\",\"\",Intro!B117)","v":""},{"$f":"IF(Intro!C117=\"\",\"\",Intro!C117)","v":""},{"$f":"IF(C32=\"\",\"\",C32-C31)","v":""},{"$f":"IF(D32=\"\",\"\",D32*1000/$E$19)","v":""},{"$f":"IF(E32=\"\",\"\",+F31+E32)","v":""}]
[null,{"$f":"IF(Intro!B118=\"\",\"\",Intro!B118)","v":""},{"$f":"IF(Intro!C118=\"\",\"\",Intro!C118)","v":""},"","",{"$f":"IF(E33=\"\",\"\",+F32+E33)","v":""}]
[null,{"$f":"IF(Intro!B119=\"\",\"\",Intro!B119)","v":""},{"$f":"IF(Intro!C119=\"\",\"\",Intro!C119)","v":""},"","",""]
[null,{"$f":"IF(Intro!B120=\"\",\"\",Intro!B120)","v":""},{"$f":"IF(Intro!C120=\"\",\"\",Intro!C120)","v":""},"","",""]
[null,{"$f":"IF(Intro!B121=\"\",\"\",Intro!B121)","v":""},{"$f":"IF(Intro!C121=\"\",\"\",Intro!C121)","v":""},"","",""]
[null,{"$f":"IF(Intro!B122=\"\",\"\",Intro!B122)","v":""},{"$f":"IF(Intro!C122=\"\",\"\",Intro!C122)","v":""},"","",""]
[null,{"$f":"IF(Intro!B123=\"\",\"\",Intro!B123)","v":""},{"$f":"IF(Intro!C123=\"\",\"\",Intro!C123)","v":""},"","",""]
[null,{"$f":"IF(Intro!B124=\"\",\"\",Intro!B124)","v":""},{"$f":"IF(Intro!C124=\"\",\"\",Intro!C124)","v":""},"","",""]
[null,{"$f":"IF(Intro!B125=\"\",\"\",Intro!B125)","v":""},{"$f":"IF(Intro!C125=\"\",\"\",Intro!C125)","v":""},"","",""]
[null,{"$f":"IF(Intro!B126=\"\",\"\",Intro!B126)","v":""},{"$f":"IF(Intro!C126=\"\",\"\",Intro!C126)","v":""},"","",""]
[null,{"$f":"IF(Intro!B127=\"\",\"\",Intro!B127)","v":""},{"$f":"IF(Intro!C127=\"\",\"\",Intro!C127)","v":""},"","",""]
[null,{"$f":"IF(Intro!B128=\"\",\"\",Intro!B128)","v":""},{"$f":"IF(Intro!C128=\"\",\"\",Intro!C128)","v":""},"","",""]
[null,{"$f":"IF(Intro!B129=\"\",\"\",Intro!B129)","v":""},{"$f":"IF(Intro!C129=\"\",\"\",Intro!C129)","v":""},"","",""]
[null,{"$f":"IF(Intro!B130=\"\",\"\",Intro!B130)","v":""},{"$f":"IF(Intro!C130=\"\",\"\",Intro!C130)","v":""},{"$f":"IF(C45=\"\",\"\",C45-C44)","v":""},{"$f":"IF(D45=\"\",\"\",D45*1000/$E$19)","v":""},{"$f":"IF(E45=\"\",\"\",+F44+E45)","v":""}]
[null,{"$f":"IF(Intro!B131=\"\",\"\",Intro!B131)","v":""},{"$f":"IF(Intro!C131=\"\",\"\",Intro!C131)","v":""},"","",""]
[null,{"$f":"IF(Intro!B132=\"\",\"\",Intro!B132)","v":""},{"$f":"IF(Intro!C132=\"\",\"\",Intro!C132)","v":""},"","",""]
[null,{"$f":"IF(Intro!B133=\"\",\"\",Intro!B133)","v":""},{"$f":"IF(Intro!C133=\"\",\"\",Intro!C133)","v":""},"","",""]
[null,{"$f":"IF(Intro!B134=\"\",\"\",Intro!B134)","v":""},{"$f":"IF(Intro!C134=\"\",\"\",Intro!C134)","v":""},"","",""]
[null,{"$f":"IF(Intro!B135=\"\",\"\",Intro!B135)","v":""},{"$f":"IF(Intro!C135=\"\",\"\",Intro!C135)","v":""},"","",""]
[null,{"$f":"IF(Intro!B136=\"\",\"\",Intro!B136)","v":""},{"$f":"IF(Intro!C136=\"\",\"\",Intro!C136)","v":""},"","",""]
[null,{"$f":"IF(Intro!B137=\"\",\"\",Intro!B137)","v":""},{"$f":"IF(Intro!C137=\"\",\"\",Intro!C137)","v":""},"","",""]
[]
[null,"MESURAMENT DE LA PROVA AMB EL COMPTADOR \"JONES\":",null,null,{"$f":"IF(E31=\"\",\"\",SUM(E31:E52))","v":""},"metres."]
[null,"MIDA REAL DE LA PROVA:",null,null,{"$f":"IF(Intro!G20=\"\",\"\",Intro!G20)","v":""},"metres."]
[null,"DIFERÈNCIA:",null,null,{"$f":"IF(E55=\"\",\"\",E54-E55)","v":""},"metres."]
[]
[null,"REAJUST REALITZAT:",{"$f":"IF(Intro!C139=\"\",\"\",Intro!C139)","v":""}]
[null,{"$f":"IF(Intro!B140=\"\",\"\",Intro!B140)","v":""}]
[null,{"$f":"IF(Intro!B141=\"\",\"\",Intro!B141)","v":""}]

{"sheet":"4-Index","index":11,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Trafalgar, 12 entresol 2ª"]
[null,null,null,null,null,null,"08010 BARCELONA"]
[null,null,null,null,null,null,"Tel.- 93 268 79 22"]
[]
[]
[]
[]
[]
[null,{"$f":"IF(Index!B31=\"\",\"\",Index!B31)","v":"4.- El recorregut "}]
[null,null,{"$f":"IF(Index!C32=\"\",\"\",Index!C32)","v":""}]
[null,null,{"$f":"IF(Index!C33=\"\",\"\",Index!C33)","v":"Generalitats del recorregut "}]
[null,null,{"$f":"IF(Index!C34=\"\",\"\",Index!C34)","v":""}]
[null,null,{"$f":"IF(Index!C37=\"\",\"\",Index!C37)","v":"Plànol general"}]
[null,null,{"$f":"IF(Index!C36=\"\",\"\",Index!C36)","v":""}]
[null,null,{"$f":"IF(Index!C35=\"\",\"\",Index!C35)","v":"Descripció recorregut"}]
[null,null,{"$f":"IF(Index!C38=\"\",\"\",Index!C38)","v":""}]
[null,null,{"$f":"IF(Index!C39=\"\",\"\",Index!C39)","v":"Sortida / Arribada"}]
[null,null,{"$f":"IF(Index!C40=\"\",\"\",Index!C40)","v":""}]
[null,null,{"$f":"IF(Index!C41=\"\",\"\",Index!C41)","v":"Detalls del circuit"}]
[null,null,{"$f":"IF(Index!C42=\"\",\"\",Index!C42)","v":""}]

{"sheet":"5-Index","index":12,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Trafalgar, 12 entresol 2ª"]
[null,null,null,null,null,null,"08010 BARCELONA"]
[null,null,null,null,null,null,"Tel.- 93 268 79 22"]
[]
[]
[]
[]
[]
[null,{"$f":"IF(Index!B44=\"\",\"\",Index!B44)","v":"5.- Certificat d’homologació "}]
[null,null,{"$f":"IF(Index!C45=\"\",\"\",Index!C45)","v":""}]
[null,null,{"$f":"IF(Index!C46=\"\",\"\",Index!C46)","v":""}]
[null,null,{"$f":"IF(Index!C47=\"\",\"\",Index!C47)","v":""}]
[null,null,{"$f":"IF(Index!C48=\"\",\"\",Index!C48)","v":""}]
[null,null,{"$f":"IF(Index!C49=\"\",\"\",Index!C49)","v":""}]
[null,null,{"$f":"IF(Index!C50=\"\",\"\",Index!C50)","v":""}]

{"sheet":"Certificat","index":13,"n_rows":63,"n_cols":7,"rows_kept":63,"cut":false,"hidden":false,"merged":[[31,5,31,6],[49,1,49,6],[40,5,40,6],[44,3,44,6],[13,2,13,6],[14,2,14,6],[15,2,15,6],[19,3,19,6],[21,3,21,6],[23,4,23,5],[40,1,40,4],[34,1,34,3],[37,1,37,3],[25,1,25,3],[31,1,31,4],[29,1,29,2],[62,1,62,3],[50,1,50,6],[48,1,48,6],[42,1,42,2],[52,1,52,6],[62,5,62,6],[61,5,61,6],[60,5,60,6],[53,1,53,6],[44,1,44,2],[42,3,42,6]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Trafalgar, 12 entresol 2ª"]
[null,null,null,null,null,null,"08010 BARCELONA"]
[null,null,null,null,null,null,"Tel.- 93 268 79 22"]
[]
[]
[]
[]
[null,null,"CERTIFICAT DE MESURAMENT"]
[null,null,"DE RECORREGUT"]
[null,null,"DE PROVA EN CARRETERA"]
[]
[]
[]
[null,"NOM DE LA PROVA :",null,{"$f":"IF(Intro!C8=\"\",\"\",Intro!C8)","v":""}]
[]
[null,"UBICACIÓ :",null,{"$f":"IF(Intro!C12=\"\",\"\",Intro!C12)","v":""}]
[]
[null,"DATA DE LA PROVA :",null,{"$f":"IF(Intro!C13=\"\",\"\",Intro!C13)","v":""},"DISTÀNCIA DE LA PROVA :",null,{"$f":"IF(Intro!G19=\"\",\"\",IF(Intro!G19=21097.5,\"1/2 Marató\",IF(Intro!G19=42195,\"Marató\",IF(Intro!G19=1609.35,\"Milla\",Intro!G19))))","v":""}]
[]
[null,"DISTÀNCIA MESURADA DEL RECORREGUT :",null,null,{"$f":"IF(Intro!G20=\"\",\"\",Intro!G20)","v":""},"DATA  MESURAMENT :",{"$f":"IF(Intro!C14=\"\",\"\",Intro!C14)","v":""}]
[]
[]
[null,"ALTITUD ",null,"SORTIDA:","ARRIBADA:","PUNT MES ALT:","PUNT MES BAIX:"]
[null,"(en metres sobre el nivell del mar)",null,{"$f":"IF(Intro!C73=\"\",\"\",Intro!C73)","v":""},{"$f":"IF(Intro!C74=\"\",\"\",Intro!C74)","v":""},{"$f":"IF(Intro!C75=\"\",\"\",Intro!C75)","v":""},{"$f":"IF(Intro!C76=\"\",\"\",Intro!C76)","v":""}]
[]
[null,"TIPUS DE RECORREGUT (en cercle, de punt a punt, etc.) :",null,null,null,{"$f":"IF(Intro!E15=\"\",\"\",Intro!E15)","v":""}]
[]
[null,null,null,null,"Metres","0/00"]
[null,"Diferència d'altitud entre sortida i arribada:",null,null,{"$f":"IF(G24=\"\",\"\",+Intro!C74-Intro!C73)","v":""},{"$f":"IF(Intro!G20=\"\",\"\",E35*1000/Intro!G20)","v":""},{"$f":"+IF(E26=\"\",\"\",IF(F35<-1,\"No compleix la normativa\",\"Compleix la normativa\"))","v":""}]
[]
[null,null,null,null,"Metres","%"]
[null,"Distància en línia recta entre sortida i arribada:",null,null,{"$f":"IF(G24=\"\",\"\",+Intro!C78)","v":""},{"$f":"IF(Intro!G20=\"\",\"\",E38*100/Intro!G20)","v":""},{"$f":"+IF(E26=\"\",\"\",IF(F38>50,\"No compleix la normativa\",\"Compleix la normativa\"))","v":""}]
[]
[]
[null,"MÈTODE DE MEDICIÓ  ( Bicicleta , Roda , Cinta d'acer ) :",null,null,null,{"$f":"IF(Intro!E18=\"\",\"\",Intro!E18)","v":""}]
[]
[null,"HOMOLOGADOR  1:",null,{"$f":"IF(Intro!C33=\"\",\"\",Intro!C33)","v":""}]
[]
[null,"HOMOLOGADOR  2 :",null,{"$f":"IF(Intro!C35=\"\",\"\",Intro!C35)","v":""}]
[]
[]
[]
[null,"Per la present  es  certifica que el recorregut descrit  anteriorment  i  definit pel plànol que s'adjunta,  ha"]
[null,"estat mesurat i aprovat per a la seva certificació. El mesurament del recorregut s'ajusta a les normes de"]
[null,"la I.A.A.F. per a Recorreguts en Carretera, i la distància mesurada no és menor que l'oficial de la prova."]
[]
[null,"Qualsevol modificació efectuada en el recorregut descrit donarà origen a l'anul-lació del present certificat "]
[null,"i aquell haurà de ser objecte d'un nou mesurament."]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"IF(Intro!C14=\"\",\"\",Intro!C14)","v":""},null,null,{"$f":"IF(Intro!C33=\"\",\"\",IF(Intro!C35=\"\",Intro!C33,CONCATENATE(Intro!C33,\" i \",Intro!C35)))","v":""}]
[null,null,"Data",null,null,"Signatura"]
[null,null,null,null,null,"Homologadors designats per la F.C.A."]

{"sheet":"Base Calibrat","index":14,"n_rows":60,"n_cols":10,"rows_kept":60,"cut":false,"hidden":false,"merged":[[17,2,17,4],[41,7,41,8],[59,2,59,4],[12,2,12,7],[13,2,13,7],[29,1,29,2],[32,1,32,2],[17,7,17,8],[19,1,19,2],[20,1,20,2],[20,4,20,7],[19,5,19,7],[47,1,47,8],[42,1,42,8],[27,1,27,8],[45,5,45,6],[21,1,21,8],[41,3,41,4],[34,1,34,3],[36,7,36,8],[55,4,55,8],[41,5,41,6],[50,2,50,8],[51,2,51,8],[54,5,54,8]]}
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Trafalgar, 12 entresol 2ª"]
[null,null,null,null,null,null,null,null,"08010 BARCELONA"]
[null,null,null,null,null,null,null,null,"Tel.- 93 268 79 22"]
[]
[]
[]
[null,null,"CERTIFICACIÓ DE LA BASE"]
[null,null,"DE CALIBRAT"]
[]
[]
[null,"SITUACIÓ DE LA BASE"]
[null,"CARRER :",null,null,null,null,"CIUTAT :"]
[null,"DATA :"]
[null,"HORA DE COMENÇAMENT:",null,null,null,"TEMPERATURA DEL SOL  (Tº):",null,null,null,"º"]
[null,"HORA D'ACABAMENT:"]
[null,"*******************"]
[null,"PUNTS DE MESURA:"]
[null,null,null,"A_________________________B_______B'         B / B' = 1 metre"]
[null,"A: PUNT D'INICI",null,null,"C: NOMBRE DE CINTADES"]
[null,"B: PUNT PROVISIONAL DEL FINAL"]
[null,"B': PUNT D'INICI EN SENTIT INVERS"]
[null,"*******************"]
[null,"PRIMERA MESURA:"]
[null,"DISTÀNCIA A / B = C x D=",null,null,"metres"]
[]
[null,"SEGONA MESURA:"]
[null,"DISTÀNCIA B' / A  =",null,null,"metres"]
[]
[null,"MITJANA DE LES DUES MESURES (MM)=  ",null,null,"A/B + B'/A - 1","=",{"$f":"IF(D30=\"\",\"\",(D30+D33-1)/2)","v":""},"metres."]
[null,null,null,null,2]
[null,"FACTOR DE CORECCIÓ TÈRMICA (FCT) =     1 + ( 0,0000116 x (Tº - 20 )) =",null,null,null,null,null,{"$f":"IF(D30=\"\",\"\",1+(0.0000116*(I20-20)))","v":""}]
[]
[null,"DISTÀNCIA REAL DE A/B  =  MM x FCT  =",null,null,{"$f":"+G35","v":""},"x",{"$f":"CONCATENATE(H37,\" = \")","v":" = "},{"$f":"IF(D30=\"\",\"\",G35*H37)","v":""},"metres."]
[]
[null,"EL PUNT \"B\" DEFINITIU S'ACONSEGUEIX : (tatxar el no adient):"]
[null,"Apropant    /","Allunyant","el PUNT PROVISIONAL \"B\" a",null,{"$f":"IF(D30=\"\",\"\",(D30-H39)*100)","v":""},null,"cm. del PUNT \"A\"."]
[]
[]
[null,"LA BASE DETERMINADA AMB CINTA MÈTRICA METÀL.LICA entre els punts definitius A i B ( pintats i"]
[null,"referenciats ) és CERTIFICADA per una distància de",null,null,null,{"$f":"IF(D30=\"\",\"\",+D30)","v":""},null,"metres."]
[]
[null,"*******************"]
[null,"LOCALITZACIÓ I DESCRIPCIÓ DELS PUNTS DE REFERÈNCIA:"]
[]
[null,"PUNT A:"]
[null,"PUNT B:"]
[]
[null,"ANNEX: PLÀNOL DETALLAT DE LA BASE DE CALIBRAT"]
[null,"NOMBRE DEL REGISTRE (a omplir per la F.C.A.) :"]
[null,"HOMOLOGACIÓ REALITZADA PER:"]
[]
[]
[]
[null,"Signat:",{"$f":"IF(E56=\"\",\"\",+E56)","v":""}]