{"text_format":"1","workbook":"xlsx","n_sheets":23,"sheets":["Mod'Op","Fiche organisateur N°1","Catalogue SCC","Fiche organisateur N°2","Rapport de Concours","00","01","02","03","04","05","06","07","08","09","10","11","12","13","14","blanc","Print Points","Memo"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":45,"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":"Mod'Op","index":0,"n_rows":62,"n_cols":13,"rows_kept":62,"cut":false,"hidden":false,"merged":[[1,2,1,8],[2,2,2,8],[5,1,5,8],[7,1,7,8]]}
[]
[null,null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,null,"Président : Monsieur Jean Paul Kerihuel - 7, Allée Mme de La Fayette - 29 200 - ST RENAN",null,null,null,null,null,null,null,null,null,"Secrétariat : vous pouvez faire vos remarques dans ce cadre"]
[]
[]
[null,"Concours CONTINENTAL NIVEAU 1"]
[]
[null,"Comment utiliser ce fichier ? "]
[]
[null,"Attention"]
[null,"Ce fichier est conçu pour la gestion des concours Continentaux"]
[]
[null,"1. Phase préparatoire"]
[]
[null,"Dans l'onglet \"Fiche Organisateur N°1\" => compléter les cases grises. "]
[]
[null,"Dans l'onglet \"Catalogue SCC\" => faire un copier-coller du catalogue téléchargé depuis l'espace des manifestations"]
[null,"Ne copier que les Cellules en dessous de \"nom du chien\" à \"conducteur\" puis noter l'ordre de passage après le tirage au sort"]
[null,"puis cliquer dans la première case sous \"ordre de passage\" et cliquer sur le bouton \"trier et filtrer puis trier du plus petit au plus grand\" sans aucune sélection de zone"]
[]
[null,"Dans l'onglet \"Fiche Organisateur N°2\" => compléter les cases grises si un chien blanc est présent"]
[]
[null,"Dans l'onglet \"00\" => compléter les cases gris clair sous le contrôle du juge :  "]
[null," => liste des épreuves"]
[null," => pointages attribués (entrer le chiffre simple, la barre de fraction se met automatiquement)"]
[null,"Le concours N1 est sur 75 points,N2 sur 100 points et N3 sur 150 points. La répartition des points entre les épreuves"]
[null,"est à l'appréciation de chaque juge. Compléter la case (bleue) de l'onglet \"00\" en conséquence. "]
[null,"Si le pointage total n'est pas de 75, 100 ou 150  points, un message \"ATTENTION : TOTAL non égal à 75, 100 ou 150\" apparaît. "]
[null,"Sinon, le message est \"TOTAL = OK\" "]
[null,"Si l'organisateur a voulu s'avancer en imprimant 3 fois chacune des feuilles avec les noms des concurrents avant de compléter l'onglet \"00\""]
[null,"Il peut repasser les feuilles dans l'imprimante en utilisant l'onglet \"Print Points\"  seuls les points et nouvelles infos de l'onglet \"00\" seront ajoutées."]
[null,"Bien entendu cet onglet n'a aucune utilité pour ceux qui imprimeront les feuilles après le remplissage de l'onglet \"00\""]
[]
[null,"2. Phase de concours"]
[]
[null,"Imprimer la feuille (vierge) du concurrent qui doit passer et la donner au juge pour son brouillon. "]
[]
[null,"Pendant le passage du concurrent, le juge renseigne les cases en gris clair et gris foncé. "]
[]
[null,"Lorsque le concurrent est passé, le juge remet au secrétariat cette feuille de pointage manuscrite renseignée. "]
[null,"Le secrétariat retranscrit dans Excel (dans le bon onglet ! ) les pointages sur la feuille du concurrent "]
[null,"ATTENTION : bien vérifier que les noms du concurrent et du chien correspondent ! "]
[]
[null,"Pendant le déroulement du concours, les tableaux des onglets \"Fiche Organisateur N°2\" et \"Rapport de "]
[null,"concours\" se mettent à jour automatiquement en temps réel. "]
[]
[null,"Pendant le déroulement du concours, il est possible de mettre à jour le classement en appuyant sur le "]
[null,"bouton \"CLASSER\" (Attention : il est possible que le bouton ne fonctionne pas sous open Office). "]
[]
[null,"3. Fin du concours"]
[]
[null,"Lorsque toutes les feuilles sont saisies, le rapport du concours doit donc être à jour. "]
[null,"Il ne reste qu'à appuyer sur le bouton \"CLASSER\" pour que les lignes de concurrents soient dans l'ordre "]
[null,"croissant des résultats. "]
[]
[null,"ATTENTION CEPENDANT : ne pas faire une confiance aveugle à l'informatique ! "]
[null," => vérifier la cohérence des chiffres et sonder quelques feuilles pour détecter d'éventuelles erreurs…"]
[]
[null,"La cellule \"Observations\" du \"Rapport de concours\" doit être renseignée par le juge. "]
[null,"Il peut le faire manuellement après impression de la feuille."]
[null,null,null,null,null,null,null,null,null,null,null,null,"Note : CC = Centrale Canine (ex-SCC) "]
[null,"Lorsque tout est OK, éditer les feuilles pour le juge, la CC et les concurrents…"]

{"sheet":"Fiche organisateur N°1","index":1,"n_rows":48,"n_cols":14,"rows_kept":48,"cut":false,"hidden":false,"merged":[[20,5,20,8],[23,5,23,8],[27,5,27,8],[14,5,14,8],[15,5,15,8],[16,5,16,8],[17,5,17,8],[18,5,18,8],[19,5,19,8],[12,5,12,8],[1,2,1,8],[2,2,2,8],[7,2,7,8],[9,2,9,8],[11,5,11,8]]}
[]
[null,null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,null,"Président : Monsieur Jean-Paul Kerihuel - 7, Allée Madame de La Fayette - 29200 Saint-Renan",null,null,null,null,null,null,null,null,null,"Secrétariat : vous pouvez faire vos remarques dans ce cadre"]
[]
[]
[]
[]
[null,null,{"$f":"IF(NIVEAU=\"3CP\",\"COUPE de France CONTINENTAL\",\"Concours CONTINENTAL\")","v":"Concours CONTINENTAL"}]
[]
[null,null,"Organisateur ==> Fiche N°1"]
[null,null,null,null,{"$f":"IF(E12<>1,IF(E12<>2,IF(E12<>3,IF(E12<>\"3CP\",\"Erreur de saisie du niveau\",\"\"),\"\"),\"\"),\"\")","v":""}]
[null,null,null,"Choisir le Niveau : ",1,"Noter 1 ou 2 ou 3 ou 3CP selon le niveau choisi"]
[null,null,null,"Date : ",null,"Format  JJ/MM/AAAA"]
[]
[null,null,null,"ORGANISATEUR : "]
[null,null,null,"Lieu : "]
[null,null,null,"N° Cheptel : ",null,"Noter le numéro sans point et sans espace"]
[null,null,null,"Contact : "]
[null,null,null,"Coordonnées du contact : "]
[null,null,null,"Adresse mail : "]
[null,null,null,"Téléphone : ",null,"Noter le numéro sans point et sans espace"]
[]
[]
[null,null,null,"Adresse du rassemblement : "]
[]
[null,null,null,"Concours : ",{"$f":" \"Niveau \"&NIVEAU","v":"Niveau 1"}]
[]
[null,null,null,"Juge : "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"3CP"]

{"sheet":"Catalogue SCC","index":2,"n_rows":42,"n_cols":10,"rows_kept":42,"cut":false,"hidden":false,"merged":[[23,9,24,9],[25,0,26,0],[25,1,26,1],[25,2,26,2],[25,3,26,3],[25,4,26,4],[25,5,26,5],[37,0,38,14],[27,6,28,6],[27,7,28,7],[27,8,28,8],[27,9,28,9],[25,6,26,6],[25,7,26,7],[25,8,26,8],[25,9,26,9],[27,0,28,0],[27,1,28,1],[27,2,28,2],[27,3,28,3],[27,4,28,4],[27,5,28,5],[23,0,24,0],[23,1,24,1],[23,2,24,2],[23,3,24,3],[23,4,24,4],[23,5,24,5],[23,6,24,6],[23,7,24,7],[23,8,24,8],[19,6,20,6],[19,7,20,7],[19,8,20,8],[19,9,20,9],[21,0,22,0],[21,1,22,1],[21,2,22,2],[21,3,22,3],[21,4,22,4],[21,5,22,5],[19,0,20,0],[19,1,20,1],[19,2,20,2],[19,3,20,3],[19,4,20,4],[19,5,20,5],[21,6,22,6],[21,7,22,7],[21,8,22,8],[21,9,22,9],[15,0,16,0],[15,9,16,9],[17,0,18,0],[1,4,2,4],[1,5,2,5],[17,9,18,9],[11,5,12,5],[11,6,12,6],[11,9,12,9],[13,0,14,0],[13,1,14,1],[13,2,14,2],[13,3,14,3],[13,4,14,4],[13,5,14,5],[13,6,14,6],[13,7,14,7],[13,9,14,9],[9,3,10,3],[9,4,10,4],[9,5,10,5],[9,9,10,9],[11,0,12,0],[11,8,12,8],[5,9,6,9],[7,0,8,0],[7,1,8,1],[7,2,8,2],[7,3,8,3],[7,4,8,4],[7,5,8,5],[11,1,12,1],[11,2,12,2],[11,3,12,3],[11,4,12,4],[7,6,8,6],[7,7,8,7],[7,8,8,8],[7,9,8,9],[9,0,10,0],[9,6,10,6],[9,7,10,7],[9,8,10,8],[9,1,10,1],[9,2,10,2],[5,4,6,4],[3,2,4,2],[3,3,4,3],[3,4,4,4],[3,5,4,5],[3,6,4,6],[5,5,6,5],[5,6,6,6],[11,7,12,7],[5,7,6,7],[1,9,2,9],[3,0,4,0],[3,7,4,7],[3,8,4,8],[1,6,2,6],[1,7,2,7],[1,8,2,8],[15,1,16,1],[15,2,16,2],[15,3,16,3],[15,4,16,4],[15,5,16,5],[15,6,16,6],[1,0,2,0],[1,1,2,1],[1,2,2,2],[1,3,2,3],[3,9,4,9],[5,0,6,0],[5,8,6,8],[5,1,6,1],[5,2,6,2],[5,3,6,3],[3,1,4,1],[17,6,18,6],[17,7,18,7],[17,8,18,8],[17,1,18,1],[17,2,18,2],[17,3,18,3],[17,4,18,4],[17,5,18,5],[13,8,14,8],[15,7,16,7],[15,8,16,8]]}
["RESULTAT","NOM DU CHIEN","AFFIXE","RACE SEXE","FAPAC","IDENTIFIANT","CT","PROPRIETAIRE","CONDUCTEUR","ORDRE PASSAGE"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Il est possible de saisir un chien en blanc uniquement sur la fiche organisateur N°2"]
[null,"Faire un copier-coller du catalogue téléchargé depuis l'espace des manifestations - 14 chiens maximum"]
[null,"Ne copier que les Cellules en dessous de \"nom du chien\" à \"conducteur\" puis noter l'ordre de passage après le tirage au sort"]
["si un candidat est absent NE PAS UTILISER SUPPRIMER CELLULES OU LIGNE il faut simplement effacer le texte avec la touche suppr du clavier ou le laisser il sera mis en dernier automatique lors du tri"]
[null,"Cliquer sur le bouton \"TRIER selon ordre de passage\" alors le 1° chien sera sur l'onglet 01, le 2° sur l'onglet 02, etc…"]
["A partir du moment où la saisie des feuilles de pointage est commencée, ne plus rien changer sur cette page au niveau de l'ordre des noms (ne plus utiliser le tri) sinon gros bazar assuré dans les pointages"]
[null,"Cet onglet \"Catalogue SCC\" sera automatiquement déplacé à la fin des onglets lors de l'utilisation du bouton \"classer\" dans l'onglet \"rapport de concours\" il est indispensable de faire ce classement avant envoi à la CUN troupeau"]
["Il est possible d'imprimer les feuilles avant la saisie de la fiche 00, si l'organisateur veut s'avancer dans les impressions en triple exemplaires. Après la saisie de la feuille 00 il suffira de refaire passer les feuilles dans l'imprimante en utilisant l'onglet \"print points\" et les points s'ajouteront au bon endroit, ce sont des brouillons donc s'il y a un léger décalage ce n'est pas important"]
[]
["Astuce : les cellules du catalogue, téléchargé depuis l'espace des manifestations, sont verrouillées par défaut, dès que le copier-coller sera fait sur cette page, plus aucune modification ne pourra se faire."]
["si vous voulez pouvoir faire des modifications ultérieurement, après avoir sélectionné la zone à copier sur le catalogue  téléchargé, choisir \"Format de Cellule - onglet Protection\""]
["enlever la coche à gauche de \"verrouillée\" , valider en cliquant sur OK puis faire un click sur Copier, revenir sur ce fichier et Coller les cellules sur cette page."]

{"sheet":"Fiche organisateur N°2","index":3,"n_rows":41,"n_cols":18,"rows_kept":41,"cut":false,"hidden":false,"merged":[[38,3,38,11],[40,2,40,10],[0,3,0,13],[1,3,1,13],[3,3,3,13],[7,7,7,8],[13,1,13,13],[36,3,36,9]]}
[null,null,null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,null,null,{"$f":"'Fiche organisateur N°1'!C3","v":"Président : Monsieur Jean-Paul Kerihuel - 7, Allée Madame de La Fayette - 29200 Saint-Renan"}]
[]
[null,null,null,{"$f":"'Fiche organisateur N°1'!C8","v":"Concours CONTINENTAL"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Secrétariat : vous pouvez faire vos remarques dans ce cadre"]
[null,null,null,"ORGANISATEUR",{"$f":"'Fiche organisateur N°1'!E15","v":0}]
[null,null,null,"Lieu ",{"$f":"'Fiche organisateur N°1'!E16","v":0}]
[null,null,null,"Adresse du rassemblement",{"$f":"'Fiche organisateur N°1'!E24","v":0}]
[null,null,null,"N° Cheptel",{"$f":"'Fiche organisateur N°1'!E17","v":0},null,"Date du concours :",{"$f":"IF('Fiche organisateur N°1'!E13=\"\",\"-\",'Fiche organisateur N°1'!E13)","v":"-"}]
[null,null,null,"Contact",{"$f":"'Fiche organisateur N°1'!E18","v":0}]
[null,null,null,"Coordonnées du Contact",{"$f":"'Fiche organisateur N°1'!E19","v":0}]
[null,null,null,"Adresse Mail",{"$f":"'Fiche organisateur N°1'!E20","v":0}]
[null,null,null,"Téléphone",{"$f":"'Fiche organisateur N°1'!E21","v":0}]
[]
[null,"Organisateur ==> Fiche  N°2"]
[]
[null,"N°","Noms des Chiens","Affixe","Races + Sexe","N° FAPAC","Identifiants","N° Carnet de Travail","Propriétaires","Conducteurs","Points ","Qualificatifs",null,"Classement","engagés"]
[null,1,{"$f":"IF('Catalogue SCC'!B2<>\"\",'Catalogue SCC'!B2,\"\")","v":""},{"$f":"IF('Catalogue SCC'!C2<>\"\",'Catalogue SCC'!C2,\"\")","v":""},{"$f":"IF('Catalogue SCC'!D2<>\"\",'Catalogue SCC'!D2,\"\")","v":""},{"$f":"IF('Catalogue SCC'!E2<>\"\",'Catalogue SCC'!E2,\"\")","v":""},{"$f":"IF('Catalogue SCC'!F2<>\"\",'Catalogue SCC'!F2,\"\")","v":""},{"$f":"IF('Catalogue SCC'!G2<>\"\",'Catalogue SCC'!G2,\"\")","v":""},{"$f":"IF('Catalogue SCC'!H2<>\"\",'Catalogue SCC'!H2,\"\")","v":""},{"$f":"IF('Catalogue SCC'!I2<>\"\",'Catalogue SCC'!I2,\"\")","v":""},{"$f":"'01'!C50","v":"-"},{"$f":"'01'!F50","v":"-"},{"$f":"IF(AND(NIVEAU=2,'01'!C51=\"OUI\"),\"BREVET\",IF(AND(NIVEAU=2,'01'!C51=\"NON\"),\"-\",'01'!C51))","v":"-"},{"$f":"IF(K17=\"-\",\"X\",IF(K17=0,\"N.C.\",RANK(K17,$K$17:$K$30,0)))","v":"X"},{"$f":"IF(C17<>\"\",1,0)","v":0}]
[null,2,{"$f":"IF('Catalogue SCC'!B4<>\"\",'Catalogue SCC'!B4,\"\")","v":""},{"$f":"IF('Catalogue SCC'!C4<>\"\",'Catalogue SCC'!C4,\"\")","v":""},{"$f":"IF('Catalogue SCC'!D4<>\"\",'Catalogue SCC'!D4,\"\")","v":""},{"$f":"IF('Catalogue SCC'!E4<>\"\",'Catalogue SCC'!E4,\"\")","v":""},{"$f":"IF('Catalogue SCC'!F4<>\"\",'Catalogue SCC'!F4,\"\")","v":""},{"$f":"IF('Catalogue SCC'!G4<>\"\",'Catalogue SCC'!G4,\"\")","v":""},{"$f":"IF('Catalogue SCC'!H4<>\"\",'Catalogue SCC'!H4,\"\")","v":""},{"$f":"IF('Catalogue SCC'!I4<>\"\",'Catalogue SCC'!I4,\"\")","v":""},{"$f":"'02'!C50","v":"-"},{"$f":"'02'!F50","v":"-"},{"$f":"IF(AND(NIVEAU=2,'02'!C51=\"OUI\"),\"BREVET\",IF(AND(NIVEAU=2,'02'!C51=\"NON\"),\"-\",'02'!C51))","v":"-"},"X",0]
[null,3,{"$f":"IF('Catalogue SCC'!B6<>\"\",'Catalogue SCC'!B6,\"\")","v":""},{"$f":"IF('Catalogue SCC'!C6<>\"\",'Catalogue SCC'!C6,\"\")","v":""},{"$f":"IF('Catalogue SCC'!D6<>\"\",'Catalogue SCC'!D6,\"\")","v":""},{"$f":"IF('Catalogue SCC'!E6<>\"\",'Catalogue SCC'!E6,\"\")","v":""},{"$f":"IF('Catalogue SCC'!F6<>\"\",'Catalogue SCC'!F6,\"\")","v":""},{"$f":"IF('Catalogue SCC'!G6<>\"\",'Catalogue SCC'!G6,\"\")","v":""},{"$f":"IF('Catalogue SCC'!H6<>\"\",'Catalogue SCC'!H6,\"\")","v":""},{"$f":"IF('Catalogue SCC'!I6<>\"\",'Catalogue SCC'!I6,\"\")","v":""},{"$f":"'03'!C50","v":"-"},{"$f":"'03'!F50","v":"-"},{"$f":"IF(AND(NIVEAU=2,'03'!C51=\"OUI\"),\"BREVET\",IF(AND(NIVEAU=2,'03'!C51=\"NON\"),\"-\",'03'!C51))","v":"-"},"X",0]
[null,4,{"$f":"IF('Catalogue SCC'!B8<>\"\",'Catalogue SCC'!B8,\"\")","v":""},{"$f":"IF('Catalogue SCC'!C8<>\"\",'Catalogue SCC'!C8,\"\")","v":""},{"$f":"IF('Catalogue SCC'!D8<>\"\",'Catalogue SCC'!D8,\"\")","v":""},{"$f":"IF('Catalogue SCC'!E8<>\"\",'Catalogue SCC'!E8,\"\")","v":""},{"$f":"IF('Catalogue SCC'!F8<>\"\",'Catalogue SCC'!F8,\"\")","v":""},{"$f":"IF('Catalogue SCC'!G8<>\"\",'Catalogue SCC'!G8,\"\")","v":""},{"$f":"IF('Catalogue SCC'!H8<>\"\",'Catalogue SCC'!H8,\"\")","v":""},{"$f":"IF('Catalogue SCC'!I8<>\"\",'Catalogue SCC'!I8,\"\")","v":""},{"$f":"'04'!C50","v":"-"},{"$f":"'04'!F50","v":"-"},{"$f":"IF(AND(NIVEAU=2,'04'!C51=\"OUI\"),\"BREVET\",IF(AND(NIVEAU=2,'04'!C51=\"NON\"),\"-\",'04'!C51))","v":"-"},"X",0]
[null,5,{"$f":"IF('Catalogue SCC'!B10<>\"\",'Catalogue SCC'!B10,\"\")","v":""},{"$f":"IF('Catalogue SCC'!C10<>\"\",'Catalogue SCC'!C10,\"\")","v":""},{"$f":"IF('Catalogue SCC'!D10<>\"\",'Catalogue SCC'!D10,\"\")","v":""},{"$f":"IF('Catalogue SCC'!E10<>\"\",'Catalogue SCC'!E10,\"\")","v":""},{"$f":"IF('Catalogue SCC'!F10<>\"\",'Catalogue SCC'!F10,\"\")","v":""},{"$f":"IF('Catalogue SCC'!G10<>\"\",'Catalogue SCC'!G10,\"\")","v":""},{"$f":"IF('Catalogue SCC'!H10<>\"\",'Catalogue SCC'!H10,\"\")","v":""},{"$f":"IF('Catalogue SCC'!I10<>\"\",'Catalogue SCC'!I10,\"\")","v":""},{"$f":"'05'!C50","v":"-"},{"$f":"'05'!F50","v":"-"},{"$f":"IF(AND(NIVEAU=2,'05'!C51=\"OUI\"),\"BREVET\",IF(AND(NIVEAU=2,'05'!C51=\"NON\"),\"-\",'05'!C51))","v":"-"},"X",0]
[null,6,{"$f":"IF('Catalogue SCC'!B12<>\"\",'Catalogue SCC'!B12,\"\")","v":""},{"$f":"IF('Catalogue SCC'!C12<>\"\",'Catalogue SCC'!C12,\"\")","v":""},{"$f":"IF('Catalogue SCC'!D12<>\"\",'Catalogue SCC'!D12,\"\")","v":""},{"$f":"IF('Catalogue SCC'!E12<>\"\",'Catalogue SCC'!E12,\"\")","v":""},{"$f":"IF('Catalogue SCC'!F12<>\"\",'Catalogue SCC'!F12,\"\")","v":""},{"$f":"IF('Catalogue SCC'!G12<>\"\",'Catalogue SCC'!G12,\"\")","v":""},{"$f":"IF('Catalogue SCC'!H12<>\"\",'Catalogue SCC'!H12,\"\")","v":""},{"$f":"IF('Catalogue SCC'!I12<>\"\",'Catalogue SCC'!I12,\"\")","v":""},{"$f":"'06'!C50","v":"-"},{"$f":"'06'!F50","v":"-"},{"$f":"IF(AND(NIVEAU=2,'06'!C51=\"OUI\"),\"BREVET\",IF(AND(NIVEAU=2,'06'!C51=\"NON\"),\"-\",'06'!C51))","v":"-"},"X",0]
[null,7,{"$f":"IF('Catalogue SCC'!B14<>\"\",'Catalogue SCC'!B14,\"\")","v":""},{"$f":"IF('Catalogue SCC'!C14<>\"\",'Catalogue SCC'!C14,\"\")","v":""},{"$f":"IF('Catalogue SCC'!D14<>\"\",'Catalogue SCC'!D14,\"\")","v":""},{"$f":"IF('Catalogue SCC'!E14<>\"\",'Catalogue SCC'!E14,\"\")","v":""},{"$f":"IF('Catalogue SCC'!F14<>\"\",'Catalogue SCC'!F14,\"\")","v":""},{"$f":"IF('Catalogue SCC'!G14<>\"\",'Catalogue SCC'!G14,\"\")","v":""},{"$f":"IF('Catalogue SCC'!H14<>\"\",'Catalogue SCC'!H14,\"\")","v":""},{"$f":"IF('Catalogue SCC'!I14<>\"\",'Catalogue SCC'!I14,\"\")","v":""},{"$f":"'07'!C50","v":"-"},{"$f":"'07'!F50","v":"-"},{"$f":"IF(AND(NIVEAU=2,'07'!C51=\"OUI\"),\"BREVET\",IF(AND(NIVEAU=2,'07'!C51=\"NON\"),\"-\",'07'!C51))","v":"-"},"X",0]
[null,8,{"$f":"IF('Catalogue SCC'!B16<>\"\",'Catalogue SCC'!B16,\"\")","v":""},{"$f":"IF('Catalogue SCC'!C16<>\"\",'Catalogue SCC'!C16,\"\")","v":""},{"$f":"IF('Catalogue SCC'!D16<>\"\",'Catalogue SCC'!D16,\"\")","v":""},{"$f":"IF('Catalogue SCC'!E16<>\"\",'Catalogue SCC'!E16,\"\")","v":""},{"$f":"IF('Catalogue SCC'!F16<>\"\",'Catalogue SCC'!F16,\"\")","v":""},{"$f":"IF('Catalogue SCC'!G16<>\"\",'Catalogue SCC'!G16,\"\")","v":""},{"$f":"IF('Catalogue SCC'!H16<>\"\",'Catalogue SCC'!H16,\"\")","v":""},{"$f":"IF('Catalogue SCC'!I16<>\"\",'Catalogue SCC'!I16,\"\")","v":""},{"$f":"'08'!C50","v":"-"},{"$f":"'08'!F50","v":"-"},{"$f":"IF(AND(NIVEAU=2,'08'!C51=\"OUI\"),\"BREVET\",IF(AND(NIVEAU=2,'08'!C51=\"NON\"),\"-\",'08'!C51))","v":"-"},"X",0]
[null,9,{"$f":"IF('Catalogue SCC'!B18<>\"\",'Catalogue SCC'!B18,\"\")","v":""},{"$f":"IF('Catalogue SCC'!C18<>\"\",'Catalogue SCC'!C18,\"\")","v":""},{"$f":"IF('Catalogue SCC'!D18<>\"\",'Catalogue SCC'!D18,\"\")","v":""},{"$f":"IF('Catalogue SCC'!E18<>\"\",'Catalogue SCC'!E18,\"\")","v":""},{"$f":"IF('Catalogue SCC'!F18<>\"\",'Catalogue SCC'!F18,\"\")","v":""},{"$f":"IF('Catalogue SCC'!G18<>\"\",'Catalogue SCC'!G18,\"\")","v":""},{"$f":"IF('Catalogue SCC'!H18<>\"\",'Catalogue SCC'!H18,\"\")","v":""},{"$f":"IF('Catalogue SCC'!I18<>\"\",'Catalogue SCC'!I18,\"\")","v":""},{"$f":"'09'!C50","v":"-"},{"$f":"'09'!F50","v":"-"},{"$f":"IF(AND(NIVEAU=2,'09'!C51=\"OUI\"),\"BREVET\",IF(AND(NIVEAU=2,'09'!C51=\"NON\"),\"-\",'09'!C51))","v":"-"},"X",0]
[null,10,{"$f":"IF('Catalogue SCC'!B20<>\"\",'Catalogue SCC'!B20,\"\")","v":""},{"$f":"IF('Catalogue SCC'!C20<>\"\",'Catalogue SCC'!C20,\"\")","v":""},{"$f":"IF('Catalogue SCC'!D20<>\"\",'Catalogue SCC'!D20,\"\")","v":""},{"$f":"IF('Catalogue SCC'!E20<>\"\",'Catalogue SCC'!E20,\"\")","v":""},{"$f":"IF('Catalogue SCC'!F20<>\"\",'Catalogue SCC'!F20,\"\")","v":""},{"$f":"IF('Catalogue SCC'!G20<>\"\",'Catalogue SCC'!G20,\"\")","v":""},{"$f":"IF('Catalogue SCC'!H20<>\"\",'Catalogue SCC'!H20,\"\")","v":""},{"$f":"IF('Catalogue SCC'!I20<>\"\",'Catalogue SCC'!I20,\"\")","v":""},{"$f":"'10'!C50","v":"-"},{"$f":"'10'!F50","v":"-"},{"$f":"IF(AND(NIVEAU=2,'10'!C51=\"OUI\"),\"BREVET\",IF(AND(NIVEAU=2,'10'!C51=\"NON\"),\"-\",'10'!C51))","v":"-"},"X",0]
[null,11,{"$f":"IF('Catalogue SCC'!B22<>\"\",'Catalogue SCC'!B22,\"\")","v":""},{"$f":"IF('Catalogue SCC'!C22<>\"\",'Catalogue SCC'!C22,\"\")","v":""},{"$f":"IF('Catalogue SCC'!D22<>\"\",'Catalogue SCC'!D22,\"\")","v":""},{"$f":"IF('Catalogue SCC'!E22<>\"\",'Catalogue SCC'!E22,\"\")","v":""},{"$f":"IF('Catalogue SCC'!F22<>\"\",'Catalogue SCC'!F22,\"\")","v":""},{"$f":"IF('Catalogue SCC'!G22<>\"\",'Catalogue SCC'!G22,\"\")","v":""},{"$f":"IF('Catalogue SCC'!H22<>\"\",'Catalogue SCC'!H22,\"\")","v":""},{"$f":"IF('Catalogue SCC'!I22<>\"\",'Catalogue SCC'!I22,\"\")","v":""},{"$f":"'11'!C50","v":"-"},{"$f":"'11'!F50","v":"-"},{"$f":"IF(AND(NIVEAU=2,'11'!C51=\"OUI\"),\"BREVET\",IF(AND(NIVEAU=2,'11'!C51=\"NON\"),\"-\",'11'!C51))","v":"-"},"X",0]
[null,12,{"$f":"IF('Catalogue SCC'!B24<>\"\",'Catalogue SCC'!B24,\"\")","v":""},{"$f":"IF('Catalogue SCC'!C24<>\"\",'Catalogue SCC'!C24,\"\")","v":""},{"$f":"IF('Catalogue SCC'!D24<>\"\",'Catalogue SCC'!D24,\"\")","v":""},{"$f":"IF('Catalogue SCC'!E24<>\"\",'Catalogue SCC'!E24,\"\")","v":""},{"$f":"IF('Catalogue SCC'!F24<>\"\",'Catalogue SCC'!F24,\"\")","v":""},{"$f":"IF('Catalogue SCC'!G24<>\"\",'Catalogue SCC'!G24,\"\")","v":""},{"$f":"IF('Catalogue SCC'!H24<>\"\",'Catalogue SCC'!H24,\"\")","v":""},{"$f":"IF('Catalogue SCC'!I24<>\"\",'Catalogue SCC'!I24,\"\")","v":""},{"$f":"'12'!C50","v":"-"},{"$f":"'12'!F50","v":"-"},{"$f":"IF(AND(NIVEAU=2,'12'!C51=\"OUI\"),\"BREVET\",IF(AND(NIVEAU=2,'12'!C51=\"NON\"),\"-\",'12'!C51))","v":"-"},"X",0]
[null,13,{"$f":"IF('Catalogue SCC'!B26<>\"\",'Catalogue SCC'!B26,\"\")","v":""},{"$f":"IF('Catalogue SCC'!C26<>\"\",'Catalogue SCC'!C26,\"\")","v":""},{"$f":"IF('Catalogue SCC'!D26<>\"\",'Catalogue SCC'!D26,\"\")","v":""},{"$f":"IF('Catalogue SCC'!E26<>\"\",'Catalogue SCC'!E26,\"\")","v":""},{"$f":"IF('Catalogue SCC'!F26<>\"\",'Catalogue SCC'!F26,\"\")","v":""},{"$f":"IF('Catalogue SCC'!G26<>\"\",'Catalogue SCC'!G26,\"\")","v":""},{"$f":"IF('Catalogue SCC'!H26<>\"\",'Catalogue SCC'!H26,\"\")","v":""},{"$f":"IF('Catalogue SCC'!I26<>\"\",'Catalogue SCC'!I26,\"\")","v":""},{"$f":"'13'!C50","v":"-"},{"$f":"'13'!F50","v":"-"},{"$f":"IF(AND(NIVEAU=2,'13'!C51=\"OUI\"),\"BREVET\",IF(AND(NIVEAU=2,'13'!C51=\"NON\"),\"-\",'13'!C51))","v":"-"},{"$f":"IF(K29=\"-\",\"X\",IF(K29=0,\"N.C.\",RANK(K29,$K$17:$K$30,0)))","v":"X"},0]
[null,14,{"$f":"IF('Catalogue SCC'!B28<>\"\",'Catalogue SCC'!B28,\"\")","v":""},{"$f":"IF('Catalogue SCC'!C28<>\"\",'Catalogue SCC'!C28,\"\")","v":""},{"$f":"IF('Catalogue SCC'!D28<>\"\",'Catalogue SCC'!D28,\"\")","v":""},{"$f":"IF('Catalogue SCC'!E28<>\"\",'Catalogue SCC'!E28,\"\")","v":""},{"$f":"IF('Catalogue SCC'!F28<>\"\",'Catalogue SCC'!F28,\"\")","v":""},{"$f":"IF('Catalogue SCC'!G28<>\"\",'Catalogue SCC'!G28,\"\")","v":""},{"$f":"IF('Catalogue SCC'!H28<>\"\",'Catalogue SCC'!H28,\"\")","v":""},{"$f":"IF('Catalogue SCC'!I28<>\"\",'Catalogue SCC'!I28,\"\")","v":""},{"$f":"'14'!C50","v":"-"},{"$f":"'14'!F50","v":"-"},{"$f":"IF(AND(NIVEAU=2,'14'!C51=\"OUI\"),\"BREVET\",IF(AND(NIVEAU=2,'14'!C51=\"NON\"),\"-\",'14'!C51))","v":"-"},{"$f":"IF(K30=\"-\",\"X\",IF(K30=0,\"N.C.\",RANK(K30,$K$17:$K$30,0)))","v":"X"},0]
[null,"Blanc"," "," "," "," "," "," "," "," ",{"$f":"blanc!C50","v":"-"},{"$f":"blanc!F50","v":"-"}]
[]
[]
[]
[]
[]
[null,null,null,"ATTENTION : remplir ici le chien en Blanc le cas échéant ",null,null,null,null,null,null,null,null,null,{"$f":"SUM(O17:O30)","v":0}]
[]
[null,null,null,"NE  PAS  UTILISER  CETTE  FICHE  COMME  RAPPORT  DE  CONCOURS  ! "]
[null,null,"Attention  !"]
[null,null,"IMPORTER  LES  DONNEES RECUPEREES  SUR  LE  SITE  DE  LA  Centrale Canine  faire le COPIER - COLLER directement sur la fiche Catalogue SCC) "]

{"sheet":"Rapport de Concours","index":4,"n_rows":46,"n_cols":17,"rows_kept":46,"cut":false,"hidden":false,"merged":[[43,1,43,14],[0,3,0,13],[1,3,1,13],[3,3,3,13],[4,11,4,13],[13,1,13,13]]}
[null,null,null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,null,null,{"$f":"'Fiche organisateur N°1'!C3","v":"Président : Monsieur Jean-Paul Kerihuel - 7, Allée Madame de La Fayette - 29200 Saint-Renan"}]
[]
[null,null,null,{"$f":"'Fiche organisateur N°1'!C8","v":"Concours CONTINENTAL"},null,null,null,null,null,null,null,null,null,null,null,null,"Secrétariat : vous pouvez faire vos remarques dans ce cadre"]
[null,null,null,"ORGANISATEUR",{"$f":"'Fiche organisateur N°1'!E15","v":0},null,null,null,null,null,"Date du concours :",{"$f":"IF('Fiche organisateur N°1'!E13=\"\",\"-\",'Fiche organisateur N°1'!E13)","v":"-"}]
[null,null,null,"Lieu du concours",{"$f":"'Fiche organisateur N°1'!E16","v":0}]
[null,null,null,"Adresse du rassemblement",{"$f":"'Fiche organisateur N°1'!E24","v":0}]
[null,null,null,"N° du Cheptel",{"$f":"'Fiche organisateur N°1'!E17","v":0},null,null,null,null,null,null,null,null,null,null,null,"Note : sur cette feuille, vous pouvez ajuster les largeurs de colonnes…"]
[null,null,null,"Nom du Contact",{"$f":"'Fiche organisateur N°1'!E18","v":0}]
[null,null,null,"Coordonnées du Contact",{"$f":"'Fiche organisateur N°1'!E19","v":0},null,null,null,null,null,null,null,null,null,null,null,"Appuyer sur le bouton \"CLASSER\" pour classer les chiens dans l'ordre d'arrivée "]
[null,null,null,"Adresse mail",{"$f":"'Fiche organisateur N°1'!E20","v":0},null,null,null,null,null,null,null,null,null,null,null,"(opération irréversible)"]
[null,null,null,"Téléphone ",{"$f":"'Fiche organisateur N°1'!E21","v":0}]
[]
[null,{"$f":"IF('Fiche organisateur N°1'!E12=\"3CP\",\"RAPPORT DE CONCOURS => COUPE de France CONTINENTAL\",\"RAPPORT DE CONCOURS => NIVEAU \"&'Fiche organisateur N°1'!E12)","v":"RAPPORT DE CONCOURS => NIVEAU 1"}]
[]
[null,null,"Propriétaire","Conducteur","Nom du chien","Affixe","Race + Sexe","N° FAPAC","Identifiant","N° Carnet de travail","Résultat","Qualif.1","Qualif.2","Classement"]
[null,{"$f":"IF(N17=\"X\",\"-\",N17)","v":"-"},{"$f":"'Fiche organisateur N°2'!I17","v":""},{"$f":"'Fiche organisateur N°2'!J17","v":""},{"$f":"'Fiche organisateur N°2'!C17","v":""},{"$f":"'Fiche organisateur N°2'!D17","v":""},{"$f":"'Fiche organisateur N°2'!E17","v":""},{"$f":"'Fiche organisateur N°2'!F17","v":""},{"$f":"'Fiche organisateur N°2'!G17","v":""},{"$f":"'Fiche organisateur N°2'!H17","v":""},{"$f":"'Fiche organisateur N°2'!K17","v":"-"},{"$f":"'Fiche organisateur N°2'!L17","v":"-"},{"$f":"'Fiche organisateur N°2'!M17","v":"-"},{"$f":"'Fiche organisateur N°2'!N17","v":"X"}]
[null,"-",{"$f":"'Fiche organisateur N°2'!I18","v":""},{"$f":"'Fiche organisateur N°2'!J18","v":""},{"$f":"'Fiche organisateur N°2'!C18","v":""},{"$f":"'Fiche organisateur N°2'!D18","v":""},{"$f":"'Fiche organisateur N°2'!E18","v":""},{"$f":"'Fiche organisateur N°2'!F18","v":""},{"$f":"'Fiche organisateur N°2'!G18","v":""},{"$f":"'Fiche organisateur N°2'!H18","v":""},{"$f":"'Fiche organisateur N°2'!K18","v":"-"},{"$f":"'Fiche organisateur N°2'!L18","v":"-"},{"$f":"'Fiche organisateur N°2'!M18","v":"-"},{"$f":"'Fiche organisateur N°2'!N18","v":"X"}]
[null,"-",{"$f":"'Fiche organisateur N°2'!I19","v":""},{"$f":"'Fiche organisateur N°2'!J19","v":""},{"$f":"'Fiche organisateur N°2'!C19","v":""},{"$f":"'Fiche organisateur N°2'!D19","v":""},{"$f":"'Fiche organisateur N°2'!E19","v":""},{"$f":"'Fiche organisateur N°2'!F19","v":""},{"$f":"'Fiche organisateur N°2'!G19","v":""},{"$f":"'Fiche organisateur N°2'!H19","v":""},{"$f":"'Fiche organisateur N°2'!K19","v":"-"},{"$f":"'Fiche organisateur N°2'!L19","v":"-"},{"$f":"'Fiche organisateur N°2'!M19","v":"-"},{"$f":"'Fiche organisateur N°2'!N19","v":"X"}]
[null,"-",{"$f":"'Fiche organisateur N°2'!I20","v":""},{"$f":"'Fiche organisateur N°2'!J20","v":""},{"$f":"'Fiche organisateur N°2'!C20","v":""},{"$f":"'Fiche organisateur N°2'!D20","v":""},{"$f":"'Fiche organisateur N°2'!E20","v":""},{"$f":"'Fiche organisateur N°2'!F20","v":""},{"$f":"'Fiche organisateur N°2'!G20","v":""},{"$f":"'Fiche organisateur N°2'!H20","v":""},{"$f":"'Fiche organisateur N°2'!K20","v":"-"},{"$f":"'Fiche organisateur N°2'!L20","v":"-"},{"$f":"'Fiche organisateur N°2'!M20","v":"-"},{"$f":"'Fiche organisateur N°2'!N20","v":"X"}]
[null,"-",{"$f":"'Fiche organisateur N°2'!I21","v":""},{"$f":"'Fiche organisateur N°2'!J21","v":""},{"$f":"'Fiche organisateur N°2'!C21","v":""},{"$f":"'Fiche organisateur N°2'!D21","v":""},{"$f":"'Fiche organisateur N°2'!E21","v":""},{"$f":"'Fiche organisateur N°2'!F21","v":""},{"$f":"'Fiche organisateur N°2'!G21","v":""},{"$f":"'Fiche organisateur N°2'!H21","v":""},{"$f":"'Fiche organisateur N°2'!K21","v":"-"},{"$f":"'Fiche organisateur N°2'!L21","v":"-"},{"$f":"'Fiche organisateur N°2'!M21","v":"-"},{"$f":"'Fiche organisateur N°2'!N21","v":"X"}]
[null,"-",{"$f":"'Fiche organisateur N°2'!I22","v":""},{"$f":"'Fiche organisateur N°2'!J22","v":""},{"$f":"'Fiche organisateur N°2'!C22","v":""},{"$f":"'Fiche organisateur N°2'!D22","v":""},{"$f":"'Fiche organisateur N°2'!E22","v":""},{"$f":"'Fiche organisateur N°2'!F22","v":""},{"$f":"'Fiche organisateur N°2'!G22","v":""},{"$f":"'Fiche organisateur N°2'!H22","v":""},{"$f":"'Fiche organisateur N°2'!K22","v":"-"},{"$f":"'Fiche organisateur N°2'!L22","v":"-"},{"$f":"'Fiche organisateur N°2'!M22","v":"-"},{"$f":"'Fiche organisateur N°2'!N22","v":"X"}]
[null,"-",{"$f":"'Fiche organisateur N°2'!I23","v":""},{"$f":"'Fiche organisateur N°2'!J23","v":""},{"$f":"'Fiche organisateur N°2'!C23","v":""},{"$f":"'Fiche organisateur N°2'!D23","v":""},{"$f":"'Fiche organisateur N°2'!E23","v":""},{"$f":"'Fiche organisateur N°2'!F23","v":""},{"$f":"'Fiche organisateur N°2'!G23","v":""},{"$f":"'Fiche organisateur N°2'!H23","v":""},{"$f":"'Fiche organisateur N°2'!K23","v":"-"},{"$f":"'Fiche organisateur N°2'!L23","v":"-"},{"$f":"'Fiche organisateur N°2'!M23","v":"-"},{"$f":"'Fiche organisateur N°2'!N23","v":"X"}]
[null,"-",{"$f":"'Fiche organisateur N°2'!I24","v":""},{"$f":"'Fiche organisateur N°2'!J24","v":""},{"$f":"'Fiche organisateur N°2'!C24","v":""},{"$f":"'Fiche organisateur N°2'!D24","v":""},{"$f":"'Fiche organisateur N°2'!E24","v":""},{"$f":"'Fiche organisateur N°2'!F24","v":""},{"$f":"'Fiche organisateur N°2'!G24","v":""},{"$f":"'Fiche organisateur N°2'!H24","v":""},{"$f":"'Fiche organisateur N°2'!K24","v":"-"},{"$f":"'Fiche organisateur N°2'!L24","v":"-"},{"$f":"'Fiche organisateur N°2'!M24","v":"-"},{"$f":"'Fiche organisateur N°2'!N24","v":"X"}]
[null,"-",{"$f":"'Fiche organisateur N°2'!I25","v":""},{"$f":"'Fiche organisateur N°2'!J25","v":""},{"$f":"'Fiche organisateur N°2'!C25","v":""},{"$f":"'Fiche organisateur N°2'!D25","v":""},{"$f":"'Fiche organisateur N°2'!E25","v":""},{"$f":"'Fiche organisateur N°2'!F25","v":""},{"$f":"'Fiche organisateur N°2'!G25","v":""},{"$f":"'Fiche organisateur N°2'!H25","v":""},{"$f":"'Fiche organisateur N°2'!K25","v":"-"},{"$f":"'Fiche organisateur N°2'!L25","v":"-"},{"$f":"'Fiche organisateur N°2'!M25","v":"-"},{"$f":"'Fiche organisateur N°2'!N25","v":"X"}]
[null,"-",{"$f":"'Fiche organisateur N°2'!I26","v":""},{"$f":"'Fiche organisateur N°2'!J26","v":""},{"$f":"'Fiche organisateur N°2'!C26","v":""},{"$f":"'Fiche organisateur N°2'!D26","v":""},{"$f":"'Fiche organisateur N°2'!E26","v":""},{"$f":"'Fiche organisateur N°2'!F26","v":""},{"$f":"'Fiche organisateur N°2'!G26","v":""},{"$f":"'Fiche organisateur N°2'!H26","v":""},{"$f":"'Fiche organisateur N°2'!K26","v":"-"},{"$f":"'Fiche organisateur N°2'!L26","v":"-"},{"$f":"'Fiche organisateur N°2'!M26","v":"-"},{"$f":"'Fiche organisateur N°2'!N26","v":"X"}]
[null,"-",{"$f":"'Fiche organisateur N°2'!I27","v":""},{"$f":"'Fiche organisateur N°2'!J27","v":""},{"$f":"'Fiche organisateur N°2'!C27","v":""},{"$f":"'Fiche organisateur N°2'!D27","v":""},{"$f":"'Fiche organisateur N°2'!E27","v":""},{"$f":"'Fiche organisateur N°2'!F27","v":""},{"$f":"'Fiche organisateur N°2'!G27","v":""},{"$f":"'Fiche organisateur N°2'!H27","v":""},{"$f":"'Fiche organisateur N°2'!K27","v":"-"},{"$f":"'Fiche organisateur N°2'!L27","v":"-"},{"$f":"'Fiche organisateur N°2'!M27","v":"-"},{"$f":"'Fiche organisateur N°2'!N27","v":"X"}]
[null,"-",{"$f":"'Fiche organisateur N°2'!I28","v":""},{"$f":"'Fiche organisateur N°2'!J28","v":""},{"$f":"'Fiche organisateur N°2'!C28","v":""},{"$f":"'Fiche organisateur N°2'!D28","v":""},{"$f":"'Fiche organisateur N°2'!E28","v":""},{"$f":"'Fiche organisateur N°2'!F28","v":""},{"$f":"'Fiche organisateur N°2'!G28","v":""},{"$f":"'Fiche organisateur N°2'!H28","v":""},{"$f":"'Fiche organisateur N°2'!K28","v":"-"},{"$f":"'Fiche organisateur N°2'!L28","v":"-"},{"$f":"'Fiche organisateur N°2'!M28","v":"-"},{"$f":"'Fiche organisateur N°2'!N28","v":"X"}]
[null,"-",{"$f":"'Fiche organisateur N°2'!I29","v":""},{"$f":"'Fiche organisateur N°2'!J29","v":""},{"$f":"'Fiche organisateur N°2'!C29","v":""},{"$f":"'Fiche organisateur N°2'!D29","v":""},{"$f":"'Fiche organisateur N°2'!E29","v":""},{"$f":"'Fiche organisateur N°2'!F29","v":""},{"$f":"'Fiche organisateur N°2'!G29","v":""},{"$f":"'Fiche organisateur N°2'!H29","v":""},{"$f":"'Fiche organisateur N°2'!K29","v":"-"},{"$f":"'Fiche organisateur N°2'!L29","v":"-"},{"$f":"'Fiche organisateur N°2'!M29","v":"-"},{"$f":"'Fiche organisateur N°2'!N29","v":"X"}]
[null,"-",{"$f":"'Fiche organisateur N°2'!I30","v":""},{"$f":"'Fiche organisateur N°2'!J30","v":""},{"$f":"'Fiche organisateur N°2'!C30","v":""},{"$f":"'Fiche organisateur N°2'!D30","v":""},{"$f":"'Fiche organisateur N°2'!E30","v":""},{"$f":"'Fiche organisateur N°2'!F30","v":""},{"$f":"'Fiche organisateur N°2'!G30","v":""},{"$f":"'Fiche organisateur N°2'!H30","v":""},{"$f":"'Fiche organisateur N°2'!K30","v":"-"},{"$f":"'Fiche organisateur N°2'!L30","v":"-"},{"$f":"'Fiche organisateur N°2'!M30","v":"-"},{"$f":"'Fiche organisateur N°2'!N30","v":"X"}]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"'Fiche organisateur N°2'!N37","v":0},"(= inscrits)"]
[null,null,"Nombre de chiens ",{"$f":"COUNT(K17:K30)","v":0},"(=entrés sur le terrain)",3,{"$f":"D40*F40","v":0}," <====  Montant de la redevance SCC (chèque global à l'ordre de CC/ CUNTRP)"]
[null,null,null,{"$f":"COUNT(K17:K30)-COUNTIF(K17:K30,\"=0\")","v":0},"(=ayant un score non nul) ",null,null,"               à joindre au présent rapport"]
[]
[]
[null,"Observations du Juge "]
[]
[null,null,null,null,null,null,null,"Le Juge : ",{"$f":"'Fiche organisateur N°1'!E28","v":0},null,"Signature : "]

{"sheet":"00","index":5,"n_rows":69,"n_cols":20,"rows_kept":69,"cut":false,"hidden":false,"merged":[[51,2,51,8],[54,17,54,21],[55,17,55,21],[56,17,56,21],[57,17,57,21],[47,4,47,8],[48,4,48,8],[49,4,49,6],[49,7,49,8],[50,2,50,3],[50,5,50,6],[45,4,45,8],[34,4,34,8],[35,4,35,8],[36,4,36,8],[37,4,37,8],[38,4,38,8],[39,4,39,8],[40,4,40,8],[41,4,41,8],[42,4,42,8],[43,4,43,8],[44,4,44,8],[33,4,33,8],[18,4,18,8],[19,4,19,8],[26,4,26,8],[27,4,27,8],[20,4,20,8],[21,4,21,8],[22,4,22,8],[23,4,23,8],[24,4,24,8],[25,4,25,8],[28,4,28,8],[29,4,29,8],[30,4,30,8],[31,4,31,8],[32,4,32,8],[15,4,15,8],[16,4,16,8],[17,4,17,8],[0,7,0,8],[2,1,2,8],[3,1,3,8],[14,2,14,3],[14,4,14,8]]}
[null,null,null,null,null,null,null,{"$f":"\"NIVEAU \"&'Fiche organisateur N°1'!E12","v":"NIVEAU 1"}]
[]
[null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,{"$f":"'Fiche organisateur N°1'!C8","v":"Concours CONTINENTAL"},null,null,null,null,null,null,null,null,null,null,null,"Secrétariat : vous pouvez faire vos remarques dans ce cadre"]
[null,"ORGANISATEUR : ",{"$f":"'Fiche organisateur N°1'!E15","v":0}]
[null,"Lieu : ",{"$f":"'Fiche organisateur N°1'!E16","v":0},null,null,"Date : ",{"$f":"'Fiche organisateur N°1'!E13","v":"00:00:00"}]
[null,"Contact : ",{"$f":"'Fiche organisateur N°1'!E18","v":0}]
[]
[]
[]
[]
[]
[]
[]
[null,"Epreuves            ",{"$f":"IF('Fiche organisateur N°1'!E12=1,\"Pointages / 75\",IF('Fiche organisateur N°1'!E12=2,\"Pointage / 100\",\"Pointage / 150\"))","v":"Pointages / 75"},null,"Observations",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MISES A JOUR : Novembre 2018 : "]
[null,null,null,null,{"$f":"IF(AND(B16=\"\",D16<>\"\"),\" => indiquer une épreuve ou ôter le pointage\",IF(AND(B16<>\"\",D16=\"\"),\" => indiquer un pointage ou ôter l'épreuve\",\"  OK\"))","v":"  OK"},null,null,null,null,null,{"$f":"IF(E16=\"  OK\",1,0)","v":1},null,null,null,null,null,null,null,null," - EXCELLENT obtenu avec ≥ à 80% des points"]
[null,null,null,null,"  OK",null,null,null,null,null,1,null,null,null,null,null,null,null,null," - Ajout de « Activité – douceur - Initiative - obéissance - commandements » noté sur 20 points"]
[null,null,null,null,"  OK",null,null,null,null,null,1,null,null,null,null,null,null,null,null," - 2 excellents sont nécessaires pour passer en niveau 2 avec 2 juges différents"]
[null,null,null,null,"  OK",null,null,null,null,null,1,null,null,null,null,null,null,null,null," - 2 excellents sont nécessaires pour passer en niveau 3 avec 2 juges différents"]
[null,null,null,null,"  OK",null,null,null,null,null,1]
[null,null,null,null,{"$f":"IF(AND(B21=\"\",D21<>\"\"),\" => indiquer une épreuve ou ôter le pointage\",IF(AND(B21<>\"\",D21=\"\"),\" => indiquer un pointage ou ôter l'épreuve\",\"  OK\"))","v":"  OK"},null,null,null,null,null,{"$f":"IF(E21=\"  OK\",1,0)","v":1}]
[null,null,null,null,"  OK",null,null,null,null,null,1]
[null,null,null,null,"  OK",null,null,null,null,null,1]
[null,null,null,null,"  OK"]
[null,null,null,null,"  OK"]
[null,null,null,null,"  OK"]
[null,null,null,null,"  OK",null,null,null,null,null,1]
[null,null,null,null,"  OK",null,null,null,null,null,1]
[null,null,null,null,"  OK",null,null,null,null,null,1]
[null,null,null,null,"  OK"]
[null,null,null,null,"  OK"]
[null,null,null,null,"  OK"]
[null,null,null,null,"  OK"]
[null,null,null,null,"  OK"]
[null,null,null,null,"  OK"]
[null,null,null,null,"  OK",null,null,null,null,null,{"$f":"IF(E36=\"  OK\",1,0)","v":1}]
[null,null,null,null,"  OK",null,null,null,null,null,1]
[null,null,null,null,"  OK",null,null,null,null,null,1]
[null,null,null,null,"  OK",null,null,null,null,null,1]
[null,null,null,null,"  OK",null,null,null,null,null,1]
[null,null,null,null,"  OK",null,null,null,null,null,1]
[null,null,null,null,"  OK",null,null,null,null,null,1,null,null,null," "]
[null,null,null,null,"  OK",null,null,null,null,null,1]
[null,{"$f":"IF(NIVEAU=1,O61,IF(NIVEAU=2,O64,O67))","v":"Obéissance"},null,{"$f":"IF(NIVEAU=1,P61,IF(NIVEAU=2,P64,P67))","v":4},"  OK",null,null,null,null,null,1]
[null,{"$f":"IF(NIVEAU=1,O62,IF(NIVEAU=2,O65,O68))","v":"Initiative"},null,{"$f":"IF(NIVEAU=1,P62,IF(NIVEAU=2,P65,P68))","v":3},"  OK",null,null,null,null,null,1,null,null,null," "]
[null,{"$f":"IF(NIVEAU=1,O63,IF(NIVEAU=2,O66,O69))","v":"Douceur"},null,{"$f":"IF(NIVEAU=1,P63,IF(NIVEAU=2,P66,P69))","v":3},"  OK",null,null,null,null,null,1]
[null,"Pointage du Travail  =>   ",{"$f":"SUM(C16:C46)","v":0},{"$f":"SUM(D16:D46)","v":10},null,null,null,null,null,null,{"$f":"SUM(K16:K46)","v":22}]
[]
[null,"Vérification total points affectés => "," - ",{"$f":"D47+D48","v":10},{"$f":"IF(NIVEAU=1,R55,IF(NIVEAU=2,R56,IF(NIVEAU=3,R57,R58)))","v":"ATTENTION : TOTAL non égal à 75"}]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"J47+J50","v":0}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"N1","ATTENTION : TOTAL non égal à 75",null,null,{"$f":"IF(AND(NIVEAU=1,D47<>75),O55,O59)","v":"ATTENTION : TOTAL non égal à 75"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"N2","ATTENTION : TOTAL non égal à 100",null,null,{"$f":"IF(AND(NIVEAU=2,D47<>100),O56,O59)","v":"TOTAL OK"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"N3","ATTENTION : TOTAL non égal à 150",null,null,{"$f":"IF(AND(NIVEAU=3,D47<>150),O57,O59)","v":"TOTAL OK"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"N3CF","ATTENTION : TOTAL non égal à 150",null,null,{"$f":"IF(AND(NIVEAU=\"3CP\",D48<>150),O58,O59)","v":"TOTAL OK"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL OK"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"N1","Obéissance",4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"N1","Initiative",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"N1","Douceur",3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"N2","Obéissance",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"N2","Initiative",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"N2","Conduite bergère",5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"N3","Obéissance",7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"N3","Initiative",6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"N3","Conduite bergère",7]

{"sheet":"01","index":6,"n_rows":59,"n_cols":17,"rows_kept":59,"cut":false,"hidden":false,"merged":[[35,4,35,8],[26,4,26,8],[51,2,51,8],[53,2,53,3],[53,6,53,8],[48,4,48,6],[48,7,48,8],[49,2,49,3],[49,5,49,6],[50,2,50,3],[50,4,50,6],[47,4,47,8],[36,4,36,8],[37,4,37,8],[38,4,38,8],[39,4,39,8],[40,4,40,8],[41,4,41,8],[42,4,42,8],[43,4,43,8],[44,4,44,8],[45,4,45,8],[46,6,46,8],[29,4,29,8],[30,4,30,8],[31,4,31,8],[24,4,24,8],[25,4,25,8],[32,4,32,8],[33,4,33,8],[34,4,34,8],[14,2,14,3],[20,4,20,8],[21,4,21,8],[16,4,16,8],[17,4,17,8],[18,4,18,8],[19,4,19,8],[22,4,22,8],[23,4,23,8],[14,4,14,8],[15,4,15,8],[27,4,27,8],[28,4,28,8],[10,6,10,8],[11,6,11,8],[0,7,0,8],[2,1,2,8],[3,1,3,8],[8,6,8,8],[9,6,9,8]]}
[null,null,null,null,null,null,null,{"$f":"'00'!H1:I1","v":"NIVEAU 1"}]
[]
[null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,{"$f":"'Fiche organisateur N°1'!C8","v":"Concours CONTINENTAL"}]
[null,"ORGANISATEUR : ",{"$f":"'Fiche organisateur N°1'!E15","v":0}]
[null,"Lieu : ",{"$f":"'Fiche organisateur N°1'!E16","v":0},null,null,"Date : ",{"$f":"'Fiche organisateur N°1'!E13","v":"00:00:00"}]
[null,"Contact : ",{"$f":"'Fiche organisateur N°1'!E18","v":0}]
[]
[null,"PROPRIETAIRE : ",{"$f":"'Fiche organisateur N°2'!I17","v":""},null,null,"Race & sexe : ",{"$f":"'Fiche organisateur N°2'!E17","v":""}]
[null,"CONDUCTEUR : ",{"$f":"'Fiche organisateur N°2'!J17","v":""},null,null,"N° FAPAC : ",{"$f":"'Fiche organisateur N°2'!F17","v":""}]
[null,"NOM DU CHIEN : ",{"$f":"'Fiche organisateur N°2'!C17","v":""},null,null,"Affixe : ",{"$f":"'Fiche organisateur N°2'!D17","v":""}]
[null,null,null,null,null,"ID : ",{"$f":"'Fiche organisateur N°2'!G17","v":""},null,null,null,"Contrôle de saisie (sur les onglets 01 à 18 ) "]
[]
[null,null,null,null,null,null,null,null,null,null,"Ces colonnes n'apparaissent pas lors de l'impression… "]
[null,"Epreuves                 ","Pointages",null,{"$f":"IF(OR('00'!K47<>17,LEFT('00'!E49,9)=\"ATTENTION\")=1,\"NON VALIDE => corriger la feuille 00 ! ! !\",\"Observations\")","v":"Observations"},null,null,null,null,null,"contrôle-1",null,"contrôle-2"]
[null,{"$f":"IF('00'!B16=\"\",\" -\",'00'!B16)","v":" -"},null,{"$f":"IF('00'!D16=\"\",\"\",'00'!D16)","v":""},null,null,null,null,null,null,{"$f":"IF(B16=\"\",\"\",IF(C16>D16,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B16=\" -\",C16<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B17=\"\",\" -\",'00'!B17)","v":" -"},null,{"$f":"IF('00'!D17=\"\",\"\",'00'!D17)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-1 : Contrôle que les valeurs entrées ne sont pas supérieures "]
[null,{"$f":"IF('00'!B18=\"\",\" -\",'00'!B18)","v":" -"},null,{"$f":"IF('00'!D18=\"\",\"\",'00'!D18)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"                    aux pointages maxi attribués à chaque épreuve…"]
[null,{"$f":"IF('00'!B19=\"\",\" -\",'00'!B19)","v":" -"},null,{"$f":"IF('00'!D19=\"\",\"\",'00'!D19)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B20=\"\",\" -\",'00'!B20)","v":" -"},null,{"$f":"IF('00'!D20=\"\",\"\",'00'!D20)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-2 : Contrôle que les colonnes sans épreuve ne contiennent pas de note"]
[null,{"$f":"IF('00'!B21=\"\",\" -\",'00'!B21)","v":" -"},null,{"$f":"IF('00'!D21=\"\",\"\",'00'!D21)","v":""},null,null,null,null,null,null,{"$f":"IF(B21=\"\",\"\",IF(C21>D21,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B21=\" -\",C21<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B22=\"\",\" -\",'00'!B22)","v":" -"},null,{"$f":"IF('00'!D22=\"\",\"\",'00'!D22)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B23=\"\",\" -\",'00'!B23)","v":" -"},null,{"$f":"IF('00'!D23=\"\",\"\",'00'!D23)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B24=\"\",\" -\",'00'!B24)","v":" -"},null,{"$f":"IF('00'!D24=\"\",\"\",'00'!D24)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B25=\"\",\" -\",'00'!B25)","v":" -"},null,{"$f":"IF('00'!D25=\"\",\"\",'00'!D25)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B26=\"\",\" -\",'00'!B26)","v":" -"},null,{"$f":"IF('00'!D26=\"\",\"\",'00'!D26)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B27=\"\",\" -\",'00'!B27)","v":" -"},null,{"$f":"IF('00'!D27=\"\",\"\",'00'!D27)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B28=\"\",\" -\",'00'!B28)","v":" -"},null,{"$f":"IF('00'!D28=\"\",\"\",'00'!D28)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B29=\"\",\" -\",'00'!B29)","v":" -"},null,{"$f":"IF('00'!D29=\"\",\"\",'00'!D29)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B30=\"\",\" -\",'00'!B30)","v":" -"},null,{"$f":"IF('00'!D30=\"\",\"\",'00'!D30)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B31=\"\",\" -\",'00'!B31)","v":" -"},null,{"$f":"IF('00'!D31=\"\",\"\",'00'!D31)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B32=\"\",\" -\",'00'!B32)","v":" -"},null,{"$f":"IF('00'!D32=\"\",\"\",'00'!D32)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B33=\"\",\" -\",'00'!B33)","v":" -"},null,{"$f":"IF('00'!D33=\"\",\"\",'00'!D33)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B34=\"\",\" -\",'00'!B34)","v":" -"},null,{"$f":"IF('00'!D34=\"\",\"\",'00'!D34)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B35=\"\",\" -\",'00'!B35)","v":" -"},null,{"$f":"IF('00'!D35=\"\",\"\",'00'!D35)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B36=\"\",\" -\",'00'!B36)","v":" -"},null,{"$f":"IF('00'!D36=\"\",\"\",'00'!D36)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B37=\"\",\" -\",'00'!B37)","v":" -"},null,{"$f":"IF('00'!D37=\"\",\"\",'00'!D37)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B38=\"\",\" -\",'00'!B38)","v":" -"},null,{"$f":"IF('00'!D38=\"\",\"\",'00'!D38)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B39=\"\",\" -\",'00'!B39)","v":" -"},null,{"$f":"IF('00'!D39=\"\",\"\",'00'!D39)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B40=\"\",\" -\",'00'!B40)","v":" -"},null,{"$f":"IF('00'!D40=\"\",\"\",'00'!D40)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B41=\"\",\" -\",'00'!B41)","v":" -"},null,{"$f":"IF('00'!D41=\"\",\"\",'00'!D41)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B42=\"\",\" -\",'00'!B42)","v":" -"},null,{"$f":"IF('00'!D42=\"\",\"\",'00'!D42)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B43=\"\",\" -\",'00'!B43)","v":" -"},null,{"$f":"IF('00'!D43=\"\",\"\",'00'!D43)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B44=\"\",\" -\",'00'!B44)","v":"Obéissance"},null,{"$f":"IF('00'!D44=\"\",\"\",'00'!D44)","v":4},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B45=\"\",\" -\",'00'!B45)","v":"Initiative"},null,{"$f":"IF('00'!D45=\"\",\"\",'00'!D45)","v":3},null,null,null,null,null,null,"OK",null,"OK"," "]
[null,{"$f":"IF('00'!B46=\"\",\" -\",'00'!B46)","v":"Douceur"},null,{"$f":"IF('00'!D46=\"\",\"\",'00'!D46)","v":3},null,null,null,null,null,null,"OK",null,"OK"]
[null,"Pointage du Travail  =>   ",{"$f":"SUM(C16:C46)","v":0},{"$f":"SUM(D16:D46)","v":10},null,"Temps : "]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C48>D48,\"! ? !\",\"OK\")","v":"OK"}]
[null,"Pénalités Générales\n(chiffre négatif) ",null,{"$f":"IF(C49>0,\"Erreur\",\"\")","v":""},"Informations sur les pénalités générales : \n   \n   \n   ",null,null,"Classement :",null,null,{"$f":"IF(C49=\"\",\"\",IF(C49>0,\"ATTENTION : les 'Pénalités Générales' doivent être un nombre négatif !\",\"OK\"))","v":""}]
[null,"TOTAL GENERAL = ",{"$f":"IF(COUNT(C16:C46)=0,\"-\",C47+C48+C49)","v":"-"},null,"Qualificatif :",{"$f":"IF(C50=\"-\",\"-\",IF(C50>'00'!D49*0.7999,\"EXCELLENT\",IF(C50>'00'!D49*0.6499,\"TRES BON\",IF(C50>'00'!D49*0.5499,\"BON\",\" - \"))))","v":"-"},null,{"$f":"'Fiche organisateur N°2'!N17","v":"X"},{"$f":"PRESENTS","v":0},null,null,null,null,null,null,null,"CACT OUI"]
[null,{"$f":"IF(AND(NIVEAU<>1,NIVEAU<>2),\"C.A.C.T. et R.C.A.C.T.\",IF(NIVEAU=2,\"BREVET  \",\"\"))","v":""},{"$f":"IF(NIVEAU=1,Q57,IF(NIVEAU=2,Q58,Q59))","v":"-"},null,{"$f":"IF(B51<>\"\",\"<== sur décision du juge\",\"\")","v":""},null,null,null,null,null,"CACT OUI",null,null,null,null,null,"CACT NON"]
[null,{"$f":"IF(AND(NIVEAU=2,F50=\"EXCELLENT\"),\"Observations (zone en gris) :       +   Noter                            PROPOSE POUR LE BREVET CONTINENTAL                         sur le carnet de travail  \",\"Observations :  \")","v":"Observations :  "},null,null,null,null,null,null,null,{"$f":"J47+J49","v":0}]
[]
[null,"N° Cheptel du concours :",{"$f":"'Fiche organisateur N°1'!E17","v":0},null,null,"Le Juge : ",{"$f":"'Fiche organisateur N°1'!E28","v":0},null,null,null,"Qualificatif"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N1","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N2",{"$f":"IF(AND(NIVEAU=2,F50=\"excellent\"),\"OUI\",\"NON\")","v":"NON"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N3",{"$f":"IF(AND(NIVEAU<>1,NIVEAU<>2,H50=1,C47>119.999,K51=\"CACT OUI\"),\"C.A.C.T.\",IF(AND(NIVEAU<>1,NIVEAU<>2,H50=2,C47>119.999,K51=\"CACT OUI\"),\"R.C.A.C.T.\",\"\"))","v":""}]

{"sheet":"02","index":7,"n_rows":59,"n_cols":17,"rows_kept":59,"cut":false,"hidden":false,"merged":[[35,4,35,8],[26,4,26,8],[51,2,51,8],[53,2,53,3],[53,6,53,8],[48,4,48,6],[48,7,48,8],[49,2,49,3],[49,5,49,6],[50,2,50,3],[50,4,50,6],[47,4,47,8],[36,4,36,8],[37,4,37,8],[38,4,38,8],[39,4,39,8],[40,4,40,8],[41,4,41,8],[42,4,42,8],[43,4,43,8],[44,4,44,8],[45,4,45,8],[46,6,46,8],[29,4,29,8],[30,4,30,8],[31,4,31,8],[24,4,24,8],[25,4,25,8],[32,4,32,8],[33,4,33,8],[34,4,34,8],[14,2,14,3],[20,4,20,8],[21,4,21,8],[16,4,16,8],[17,4,17,8],[18,4,18,8],[19,4,19,8],[22,4,22,8],[23,4,23,8],[14,4,14,8],[15,4,15,8],[27,4,27,8],[28,4,28,8],[10,6,10,8],[11,6,11,8],[0,7,0,8],[2,1,2,8],[3,1,3,8],[8,6,8,8],[9,6,9,8]]}
[null,null,null,null,null,null,null,{"$f":"'00'!H1:I1","v":"NIVEAU 1"}]
[]
[null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,{"$f":"'Fiche organisateur N°1'!C8","v":"Concours CONTINENTAL"}]
[null,"ORGANISATEUR : ",{"$f":"'Fiche organisateur N°1'!E15","v":0}]
[null,"Lieu : ",{"$f":"'Fiche organisateur N°1'!E16","v":0},null,null,"Date : ",{"$f":"'Fiche organisateur N°1'!E13","v":"00:00:00"}]
[null,"Contact : ",{"$f":"'Fiche organisateur N°1'!E18","v":0}]
[]
[null,"PROPRIETAIRE : ",{"$f":"'Fiche organisateur N°2'!I18","v":""},null,null,"Race & sexe : ",{"$f":"'Fiche organisateur N°2'!E18","v":""}]
[null,"CONDUCTEUR : ",{"$f":"'Fiche organisateur N°2'!J18","v":""},null,null,"N° FAPAC : ",{"$f":"'Fiche organisateur N°2'!F18","v":""}]
[null,"NOM DU CHIEN : ",{"$f":"'Fiche organisateur N°2'!C18","v":""},null,null,"Affixe : ",{"$f":"'Fiche organisateur N°2'!D18","v":""}]
[null,null,null,null,null,"ID : ",{"$f":"'Fiche organisateur N°2'!G18","v":""},null,null,null,"Contrôle de saisie (sur les onglets 01 à 18 ) "]
[]
[null,null,null,null,null,null,null,null,null,null,"Ces colonnes n'apparaissent pas lors de l'impression… "]
[null,"Epreuves                 ","Pointages",null,{"$f":"IF(OR('00'!K47<>17,LEFT('00'!E49,9)=\"ATTENTION\")=1,\"NON VALIDE => corriger la feuille 00 ! ! !\",\"Observations\")","v":"Observations"},null,null,null,null,null,"contrôle-1",null,"contrôle-2"]
[null,{"$f":"IF('00'!B16=\"\",\" -\",'00'!B16)","v":" -"},null,{"$f":"IF('00'!D16=\"\",\"\",'00'!D16)","v":""},null,null,null,null,null,null,{"$f":"IF(B16=\"\",\"\",IF(C16>D16,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B16=\" -\",C16<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B17=\"\",\" -\",'00'!B17)","v":" -"},null,{"$f":"IF('00'!D17=\"\",\"\",'00'!D17)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-1 : Contrôle que les valeurs entrées ne sont pas supérieures "]
[null,{"$f":"IF('00'!B18=\"\",\" -\",'00'!B18)","v":" -"},null,{"$f":"IF('00'!D18=\"\",\"\",'00'!D18)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"                    aux pointages maxi attribués à chaque épreuve…"]
[null,{"$f":"IF('00'!B19=\"\",\" -\",'00'!B19)","v":" -"},null,{"$f":"IF('00'!D19=\"\",\"\",'00'!D19)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B20=\"\",\" -\",'00'!B20)","v":" -"},null,{"$f":"IF('00'!D20=\"\",\"\",'00'!D20)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-2 : Contrôle que les colonnes sans épreuve ne contiennent pas de note"]
[null,{"$f":"IF('00'!B21=\"\",\" -\",'00'!B21)","v":" -"},null,{"$f":"IF('00'!D21=\"\",\"\",'00'!D21)","v":""},null,null,null,null,null,null,{"$f":"IF(B21=\"\",\"\",IF(C21>D21,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B21=\" -\",C21<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B22=\"\",\" -\",'00'!B22)","v":" -"},null,{"$f":"IF('00'!D22=\"\",\"\",'00'!D22)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B23=\"\",\" -\",'00'!B23)","v":" -"},null,{"$f":"IF('00'!D23=\"\",\"\",'00'!D23)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B24=\"\",\" -\",'00'!B24)","v":" -"},null,{"$f":"IF('00'!D24=\"\",\"\",'00'!D24)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B25=\"\",\" -\",'00'!B25)","v":" -"},null,{"$f":"IF('00'!D25=\"\",\"\",'00'!D25)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B26=\"\",\" -\",'00'!B26)","v":" -"},null,{"$f":"IF('00'!D26=\"\",\"\",'00'!D26)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B27=\"\",\" -\",'00'!B27)","v":" -"},null,{"$f":"IF('00'!D27=\"\",\"\",'00'!D27)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B28=\"\",\" -\",'00'!B28)","v":" -"},null,{"$f":"IF('00'!D28=\"\",\"\",'00'!D28)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B29=\"\",\" -\",'00'!B29)","v":" -"},null,{"$f":"IF('00'!D29=\"\",\"\",'00'!D29)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B30=\"\",\" -\",'00'!B30)","v":" -"},null,{"$f":"IF('00'!D30=\"\",\"\",'00'!D30)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B31=\"\",\" -\",'00'!B31)","v":" -"},null,{"$f":"IF('00'!D31=\"\",\"\",'00'!D31)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B32=\"\",\" -\",'00'!B32)","v":" -"},null,{"$f":"IF('00'!D32=\"\",\"\",'00'!D32)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B33=\"\",\" -\",'00'!B33)","v":" -"},null,{"$f":"IF('00'!D33=\"\",\"\",'00'!D33)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B34=\"\",\" -\",'00'!B34)","v":" -"},null,{"$f":"IF('00'!D34=\"\",\"\",'00'!D34)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B35=\"\",\" -\",'00'!B35)","v":" -"},null,{"$f":"IF('00'!D35=\"\",\"\",'00'!D35)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B36=\"\",\" -\",'00'!B36)","v":" -"},null,{"$f":"IF('00'!D36=\"\",\"\",'00'!D36)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B37=\"\",\" -\",'00'!B37)","v":" -"},null,{"$f":"IF('00'!D37=\"\",\"\",'00'!D37)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B38=\"\",\" -\",'00'!B38)","v":" -"},null,{"$f":"IF('00'!D38=\"\",\"\",'00'!D38)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B39=\"\",\" -\",'00'!B39)","v":" -"},null,{"$f":"IF('00'!D39=\"\",\"\",'00'!D39)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B40=\"\",\" -\",'00'!B40)","v":" -"},null,{"$f":"IF('00'!D40=\"\",\"\",'00'!D40)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B41=\"\",\" -\",'00'!B41)","v":" -"},null,{"$f":"IF('00'!D41=\"\",\"\",'00'!D41)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B42=\"\",\" -\",'00'!B42)","v":" -"},null,{"$f":"IF('00'!D42=\"\",\"\",'00'!D42)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B43=\"\",\" -\",'00'!B43)","v":" -"},null,{"$f":"IF('00'!D43=\"\",\"\",'00'!D43)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B44=\"\",\" -\",'00'!B44)","v":"Obéissance"},null,{"$f":"IF('00'!D44=\"\",\"\",'00'!D44)","v":4},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B45=\"\",\" -\",'00'!B45)","v":"Initiative"},null,{"$f":"IF('00'!D45=\"\",\"\",'00'!D45)","v":3},null,null,null,null,null,null,"OK",null,"OK"," "]
[null,{"$f":"IF('00'!B46=\"\",\" -\",'00'!B46)","v":"Douceur"},null,{"$f":"IF('00'!D46=\"\",\"\",'00'!D46)","v":3},null,null,null,null,null,null,"OK",null,"OK"]
[null,"Pointage du Travail  =>   ",{"$f":"SUM(C16:C46)","v":0},{"$f":"SUM(D16:D46)","v":10},null,"Temps : "]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C48>D48,\"! ? !\",\"OK\")","v":"OK"}]
[null,"Pénalités Générales\n(chiffre négatif) ",null,{"$f":"IF(C49>0,\"Erreur\",\"\")","v":""},"Informations sur les pénalités générales : \n   \n   \n   ",null,null,"Classement :",null,null,{"$f":"IF(C49=\"\",\"\",IF(C49>0,\"ATTENTION : les 'Pénalités Générales' doivent être un nombre négatif !\",\"OK\"))","v":""}]
[null,"TOTAL GENERAL = ",{"$f":"IF(COUNT(C16:C46)=0,\"-\",C47+C48+C49)","v":"-"},null,"Qualificatif :",{"$f":"IF(C50=\"-\",\"-\",IF(C50>'00'!D49*0.7999,\"EXCELLENT\",IF(C50>'00'!D49*0.6499,\"TRES BON\",IF(C50>'00'!D49*0.5499,\"BON\",\" - \"))))","v":"-"},null,{"$f":"'Fiche organisateur N°2'!N18","v":"X"},{"$f":"PRESENTS","v":0},null,null,null,null,null,null,null,"CACT OUI"]
[null,{"$f":"IF(AND(NIVEAU<>1,NIVEAU<>2),\"C.A.C.T. et R.C.A.C.T.\",IF(NIVEAU=2,\"BREVET  \",\"\"))","v":""},{"$f":"IF(NIVEAU=1,Q57,IF(NIVEAU=2,Q58,Q59))","v":"-"},null,{"$f":"IF(B51<>\"\",\"<== sur décision du juge\",\"\")","v":""},null,null,null,null,null,"CACT OUI",null,null,null,null,null,"CACT NON"]
[null,{"$f":"IF(AND(NIVEAU=2,F50=\"EXCELLENT\"),\"Observations (zone en gris) :       +   Noter                            PROPOSE POUR LE BREVET CONTINENTAL                         sur le carnet de travail  \",\"Observations :  \")","v":"Observations :  "},null,null,null,null,null,null,null,{"$f":"J47+J49","v":0}]
[]
[null,"N° Cheptel du concours :",{"$f":"'Fiche organisateur N°1'!E17","v":0},null,null,"Le Juge : ",{"$f":"'Fiche organisateur N°1'!E28","v":0},null,null,null,"Qualificatif"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N1","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N2",{"$f":"IF(AND(NIVEAU=2,F50=\"excellent\"),\"OUI\",\"NON\")","v":"NON"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N3",{"$f":"IF(AND(NIVEAU<>1,NIVEAU<>2,H50=1,C47>119.999,K51=\"CACT OUI\"),\"C.A.C.T.\",IF(AND(NIVEAU<>1,NIVEAU<>2,H50=2,C47>119.999,K51=\"CACT OUI\"),\"R.C.A.C.T.\",\"\"))","v":""}]

{"sheet":"03","index":8,"n_rows":59,"n_cols":17,"rows_kept":59,"cut":false,"hidden":false,"merged":[[35,4,35,8],[26,4,26,8],[51,2,51,8],[53,2,53,3],[53,6,53,8],[48,4,48,6],[48,7,48,8],[49,2,49,3],[49,5,49,6],[50,2,50,3],[50,4,50,6],[47,4,47,8],[36,4,36,8],[37,4,37,8],[38,4,38,8],[39,4,39,8],[40,4,40,8],[41,4,41,8],[42,4,42,8],[43,4,43,8],[44,4,44,8],[45,4,45,8],[46,6,46,8],[29,4,29,8],[30,4,30,8],[31,4,31,8],[24,4,24,8],[25,4,25,8],[32,4,32,8],[33,4,33,8],[34,4,34,8],[14,2,14,3],[20,4,20,8],[21,4,21,8],[16,4,16,8],[17,4,17,8],[18,4,18,8],[19,4,19,8],[22,4,22,8],[23,4,23,8],[14,4,14,8],[15,4,15,8],[27,4,27,8],[28,4,28,8],[10,6,10,8],[11,6,11,8],[0,7,0,8],[2,1,2,8],[3,1,3,8],[8,6,8,8],[9,6,9,8]]}
[null,null,null,null,null,null,null,{"$f":"'00'!H1:I1","v":"NIVEAU 1"}]
[]
[null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,{"$f":"'Fiche organisateur N°1'!C8","v":"Concours CONTINENTAL"}]
[null,"ORGANISATEUR : ",{"$f":"'Fiche organisateur N°1'!E15","v":0}]
[null,"Lieu : ",{"$f":"'Fiche organisateur N°1'!E16","v":0},null,null,"Date : ",{"$f":"'Fiche organisateur N°1'!E13","v":"00:00:00"}]
[null,"Contact : ",{"$f":"'Fiche organisateur N°1'!E18","v":0}]
[]
[null,"PROPRIETAIRE : ",{"$f":"'Fiche organisateur N°2'!I19","v":""},null,null,"Race & sexe : ",{"$f":"'Fiche organisateur N°2'!E19","v":""}]
[null,"CONDUCTEUR : ",{"$f":"'Fiche organisateur N°2'!J19","v":""},null,null,"N° FAPAC : ",{"$f":"'Fiche organisateur N°2'!F19","v":""}]
[null,"NOM DU CHIEN : ",{"$f":"'Fiche organisateur N°2'!C19","v":""},null,null,"Affixe : ",{"$f":"'Fiche organisateur N°2'!D19","v":""}]
[null,null,null,null,null,"ID : ",{"$f":"'Fiche organisateur N°2'!G19","v":""},null,null,null,"Contrôle de saisie (sur les onglets 01 à 18 ) "]
[]
[null,null,null,null,null,null,null,null,null,null,"Ces colonnes n'apparaissent pas lors de l'impression… "]
[null,"Epreuves                 ","Pointages",null,{"$f":"IF(OR('00'!K47<>17,LEFT('00'!E49,9)=\"ATTENTION\")=1,\"NON VALIDE => corriger la feuille 00 ! ! !\",\"Observations\")","v":"Observations"},null,null,null,null,null,"contrôle-1",null,"contrôle-2"]
[null,{"$f":"IF('00'!B16=\"\",\" -\",'00'!B16)","v":" -"},null,{"$f":"IF('00'!D16=\"\",\"\",'00'!D16)","v":""},null,null,null,null,null,null,{"$f":"IF(B16=\"\",\"\",IF(C16>D16,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B16=\" -\",C16<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B17=\"\",\" -\",'00'!B17)","v":" -"},null,{"$f":"IF('00'!D17=\"\",\"\",'00'!D17)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-1 : Contrôle que les valeurs entrées ne sont pas supérieures "]
[null,{"$f":"IF('00'!B18=\"\",\" -\",'00'!B18)","v":" -"},null,{"$f":"IF('00'!D18=\"\",\"\",'00'!D18)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"                    aux pointages maxi attribués à chaque épreuve…"]
[null,{"$f":"IF('00'!B19=\"\",\" -\",'00'!B19)","v":" -"},null,{"$f":"IF('00'!D19=\"\",\"\",'00'!D19)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B20=\"\",\" -\",'00'!B20)","v":" -"},null,{"$f":"IF('00'!D20=\"\",\"\",'00'!D20)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-2 : Contrôle que les colonnes sans épreuve ne contiennent pas de note"]
[null,{"$f":"IF('00'!B21=\"\",\" -\",'00'!B21)","v":" -"},null,{"$f":"IF('00'!D21=\"\",\"\",'00'!D21)","v":""},null,null,null,null,null,null,{"$f":"IF(B21=\"\",\"\",IF(C21>D21,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B21=\" -\",C21<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B22=\"\",\" -\",'00'!B22)","v":" -"},null,{"$f":"IF('00'!D22=\"\",\"\",'00'!D22)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B23=\"\",\" -\",'00'!B23)","v":" -"},null,{"$f":"IF('00'!D23=\"\",\"\",'00'!D23)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B24=\"\",\" -\",'00'!B24)","v":" -"},null,{"$f":"IF('00'!D24=\"\",\"\",'00'!D24)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B25=\"\",\" -\",'00'!B25)","v":" -"},null,{"$f":"IF('00'!D25=\"\",\"\",'00'!D25)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B26=\"\",\" -\",'00'!B26)","v":" -"},null,{"$f":"IF('00'!D26=\"\",\"\",'00'!D26)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B27=\"\",\" -\",'00'!B27)","v":" -"},null,{"$f":"IF('00'!D27=\"\",\"\",'00'!D27)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B28=\"\",\" -\",'00'!B28)","v":" -"},null,{"$f":"IF('00'!D28=\"\",\"\",'00'!D28)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B29=\"\",\" -\",'00'!B29)","v":" -"},null,{"$f":"IF('00'!D29=\"\",\"\",'00'!D29)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B30=\"\",\" -\",'00'!B30)","v":" -"},null,{"$f":"IF('00'!D30=\"\",\"\",'00'!D30)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B31=\"\",\" -\",'00'!B31)","v":" -"},null,{"$f":"IF('00'!D31=\"\",\"\",'00'!D31)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B32=\"\",\" -\",'00'!B32)","v":" -"},null,{"$f":"IF('00'!D32=\"\",\"\",'00'!D32)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B33=\"\",\" -\",'00'!B33)","v":" -"},null,{"$f":"IF('00'!D33=\"\",\"\",'00'!D33)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B34=\"\",\" -\",'00'!B34)","v":" -"},null,{"$f":"IF('00'!D34=\"\",\"\",'00'!D34)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B35=\"\",\" -\",'00'!B35)","v":" -"},null,{"$f":"IF('00'!D35=\"\",\"\",'00'!D35)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B36=\"\",\" -\",'00'!B36)","v":" -"},null,{"$f":"IF('00'!D36=\"\",\"\",'00'!D36)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B37=\"\",\" -\",'00'!B37)","v":" -"},null,{"$f":"IF('00'!D37=\"\",\"\",'00'!D37)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B38=\"\",\" -\",'00'!B38)","v":" -"},null,{"$f":"IF('00'!D38=\"\",\"\",'00'!D38)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B39=\"\",\" -\",'00'!B39)","v":" -"},null,{"$f":"IF('00'!D39=\"\",\"\",'00'!D39)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B40=\"\",\" -\",'00'!B40)","v":" -"},null,{"$f":"IF('00'!D40=\"\",\"\",'00'!D40)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B41=\"\",\" -\",'00'!B41)","v":" -"},null,{"$f":"IF('00'!D41=\"\",\"\",'00'!D41)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B42=\"\",\" -\",'00'!B42)","v":" -"},null,{"$f":"IF('00'!D42=\"\",\"\",'00'!D42)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B43=\"\",\" -\",'00'!B43)","v":" -"},null,{"$f":"IF('00'!D43=\"\",\"\",'00'!D43)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B44=\"\",\" -\",'00'!B44)","v":"Obéissance"},null,{"$f":"IF('00'!D44=\"\",\"\",'00'!D44)","v":4},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B45=\"\",\" -\",'00'!B45)","v":"Initiative"},null,{"$f":"IF('00'!D45=\"\",\"\",'00'!D45)","v":3},null,null,null,null,null,null,"OK",null,"OK"," "]
[null,{"$f":"IF('00'!B46=\"\",\" -\",'00'!B46)","v":"Douceur"},null,{"$f":"IF('00'!D46=\"\",\"\",'00'!D46)","v":3},null,null,null,null,null,null,"OK",null,"OK"]
[null,"Pointage du Travail  =>   ",{"$f":"SUM(C16:C46)","v":0},{"$f":"SUM(D16:D46)","v":10},null,"Temps : "]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C48>D48,\"! ? !\",\"OK\")","v":"OK"}]
[null,"Pénalités Générales\n(chiffre négatif) ",null,{"$f":"IF(C49>0,\"Erreur\",\"\")","v":""},"Informations sur les pénalités générales : \n   \n   \n   ",null,null,"Classement :",null,null,{"$f":"IF(C49=\"\",\"\",IF(C49>0,\"ATTENTION : les 'Pénalités Générales' doivent être un nombre négatif !\",\"OK\"))","v":""}]
[null,"TOTAL GENERAL = ",{"$f":"IF(COUNT(C16:C46)=0,\"-\",C47+C48+C49)","v":"-"},null,"Qualificatif :",{"$f":"IF(C50=\"-\",\"-\",IF(C50>'00'!D49*0.7999,\"EXCELLENT\",IF(C50>'00'!D49*0.6499,\"TRES BON\",IF(C50>'00'!D49*0.5499,\"BON\",\" - \"))))","v":"-"},null,{"$f":"'Fiche organisateur N°2'!N19","v":"X"},{"$f":"PRESENTS","v":0},null,null,null,null,null,null,null,"CACT OUI"]
[null,{"$f":"IF(AND(NIVEAU<>1,NIVEAU<>2),\"C.A.C.T. et R.C.A.C.T.\",IF(NIVEAU=2,\"BREVET  \",\"\"))","v":""},{"$f":"IF(NIVEAU=1,Q57,IF(NIVEAU=2,Q58,Q59))","v":"-"},null,{"$f":"IF(B51<>\"\",\"<== sur décision du juge\",\"\")","v":""},null,null,null,null,null,"CACT OUI",null,null,null,null,null,"CACT NON"]
[null,{"$f":"IF(AND(NIVEAU=2,F50=\"EXCELLENT\"),\"Observations (zone en gris) :       +   Noter                            PROPOSE POUR LE BREVET CONTINENTAL                         sur le carnet de travail  \",\"Observations :  \")","v":"Observations :  "},null,null,null,null,null,null,null,{"$f":"J47+J49","v":0}]
[]
[null,"N° Cheptel du concours :",{"$f":"'Fiche organisateur N°1'!E17","v":0},null,null,"Le Juge : ",{"$f":"'Fiche organisateur N°1'!E28","v":0},null,null,null,"Qualificatif"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N1","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N2",{"$f":"IF(AND(NIVEAU=2,F50=\"excellent\"),\"OUI\",\"NON\")","v":"NON"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N3",{"$f":"IF(AND(NIVEAU<>1,NIVEAU<>2,H50=1,C47>119.999,K51=\"CACT OUI\"),\"C.A.C.T.\",IF(AND(NIVEAU<>1,NIVEAU<>2,H50=2,C47>119.999,K51=\"CACT OUI\"),\"R.C.A.C.T.\",\"\"))","v":""}]

{"sheet":"04","index":9,"n_rows":59,"n_cols":17,"rows_kept":59,"cut":false,"hidden":false,"merged":[[35,4,35,8],[26,4,26,8],[51,2,51,8],[53,2,53,3],[53,6,53,8],[48,4,48,6],[48,7,48,8],[49,2,49,3],[49,5,49,6],[50,2,50,3],[50,4,50,6],[47,4,47,8],[36,4,36,8],[37,4,37,8],[38,4,38,8],[39,4,39,8],[40,4,40,8],[41,4,41,8],[42,4,42,8],[43,4,43,8],[44,4,44,8],[45,4,45,8],[46,6,46,8],[29,4,29,8],[30,4,30,8],[31,4,31,8],[24,4,24,8],[25,4,25,8],[32,4,32,8],[33,4,33,8],[34,4,34,8],[14,2,14,3],[20,4,20,8],[21,4,21,8],[16,4,16,8],[17,4,17,8],[18,4,18,8],[19,4,19,8],[22,4,22,8],[23,4,23,8],[14,4,14,8],[15,4,15,8],[27,4,27,8],[28,4,28,8],[10,6,10,8],[11,6,11,8],[0,7,0,8],[2,1,2,8],[3,1,3,8],[8,6,8,8],[9,6,9,8]]}
[null,null,null,null,null,null,null,{"$f":"'00'!H1:I1","v":"NIVEAU 1"}]
[]
[null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,{"$f":"'Fiche organisateur N°1'!C8","v":"Concours CONTINENTAL"}]
[null,"ORGANISATEUR : ",{"$f":"'Fiche organisateur N°1'!E15","v":0}]
[null,"Lieu : ",{"$f":"'Fiche organisateur N°1'!E16","v":0},null,null,"Date : ",{"$f":"'Fiche organisateur N°1'!E13","v":"00:00:00"}]
[null,"Contact : ",{"$f":"'Fiche organisateur N°1'!E18","v":0}]
[]
[null,"PROPRIETAIRE : ",{"$f":"'Fiche organisateur N°2'!I20","v":""},null,null,"Race & sexe : ",{"$f":"'Fiche organisateur N°2'!E20","v":""}]
[null,"CONDUCTEUR : ",{"$f":"'Fiche organisateur N°2'!J20","v":""},null,null,"N° FAPAC : ",{"$f":"'Fiche organisateur N°2'!F20","v":""}]
[null,"NOM DU CHIEN : ",{"$f":"'Fiche organisateur N°2'!C20","v":""},null,null,"Affixe : ",{"$f":"'Fiche organisateur N°2'!D20","v":""}]
[null,null,null,null,null,"ID : ",{"$f":"'Fiche organisateur N°2'!G20","v":""},null,null,null,"Contrôle de saisie (sur les onglets 01 à 18 ) "]
[]
[null,null,null,null,null,null,null,null,null,null,"Ces colonnes n'apparaissent pas lors de l'impression… "]
[null,"Epreuves                 ","Pointages",null,{"$f":"IF(OR('00'!K47<>17,LEFT('00'!E49,9)=\"ATTENTION\")=1,\"NON VALIDE => corriger la feuille 00 ! ! !\",\"Observations\")","v":"Observations"},null,null,null,null,null,"contrôle-1",null,"contrôle-2"]
[null,{"$f":"IF('00'!B16=\"\",\" -\",'00'!B16)","v":" -"},null,{"$f":"IF('00'!D16=\"\",\"\",'00'!D16)","v":""},null,null,null,null,null,null,{"$f":"IF(B16=\"\",\"\",IF(C16>D16,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B16=\" -\",C16<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B17=\"\",\" -\",'00'!B17)","v":" -"},null,{"$f":"IF('00'!D17=\"\",\"\",'00'!D17)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-1 : Contrôle que les valeurs entrées ne sont pas supérieures "]
[null,{"$f":"IF('00'!B18=\"\",\" -\",'00'!B18)","v":" -"},null,{"$f":"IF('00'!D18=\"\",\"\",'00'!D18)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"                    aux pointages maxi attribués à chaque épreuve…"]
[null,{"$f":"IF('00'!B19=\"\",\" -\",'00'!B19)","v":" -"},null,{"$f":"IF('00'!D19=\"\",\"\",'00'!D19)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B20=\"\",\" -\",'00'!B20)","v":" -"},null,{"$f":"IF('00'!D20=\"\",\"\",'00'!D20)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-2 : Contrôle que les colonnes sans épreuve ne contiennent pas de note"]
[null,{"$f":"IF('00'!B21=\"\",\" -\",'00'!B21)","v":" -"},null,{"$f":"IF('00'!D21=\"\",\"\",'00'!D21)","v":""},null,null,null,null,null,null,{"$f":"IF(B21=\"\",\"\",IF(C21>D21,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B21=\" -\",C21<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B22=\"\",\" -\",'00'!B22)","v":" -"},null,{"$f":"IF('00'!D22=\"\",\"\",'00'!D22)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B23=\"\",\" -\",'00'!B23)","v":" -"},null,{"$f":"IF('00'!D23=\"\",\"\",'00'!D23)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B24=\"\",\" -\",'00'!B24)","v":" -"},null,{"$f":"IF('00'!D24=\"\",\"\",'00'!D24)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B25=\"\",\" -\",'00'!B25)","v":" -"},null,{"$f":"IF('00'!D25=\"\",\"\",'00'!D25)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B26=\"\",\" -\",'00'!B26)","v":" -"},null,{"$f":"IF('00'!D26=\"\",\"\",'00'!D26)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B27=\"\",\" -\",'00'!B27)","v":" -"},null,{"$f":"IF('00'!D27=\"\",\"\",'00'!D27)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B28=\"\",\" -\",'00'!B28)","v":" -"},null,{"$f":"IF('00'!D28=\"\",\"\",'00'!D28)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B29=\"\",\" -\",'00'!B29)","v":" -"},null,{"$f":"IF('00'!D29=\"\",\"\",'00'!D29)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B30=\"\",\" -\",'00'!B30)","v":" -"},null,{"$f":"IF('00'!D30=\"\",\"\",'00'!D30)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B31=\"\",\" -\",'00'!B31)","v":" -"},null,{"$f":"IF('00'!D31=\"\",\"\",'00'!D31)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B32=\"\",\" -\",'00'!B32)","v":" -"},null,{"$f":"IF('00'!D32=\"\",\"\",'00'!D32)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B33=\"\",\" -\",'00'!B33)","v":" -"},null,{"$f":"IF('00'!D33=\"\",\"\",'00'!D33)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B34=\"\",\" -\",'00'!B34)","v":" -"},null,{"$f":"IF('00'!D34=\"\",\"\",'00'!D34)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B35=\"\",\" -\",'00'!B35)","v":" -"},null,{"$f":"IF('00'!D35=\"\",\"\",'00'!D35)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B36=\"\",\" -\",'00'!B36)","v":" -"},null,{"$f":"IF('00'!D36=\"\",\"\",'00'!D36)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B37=\"\",\" -\",'00'!B37)","v":" -"},null,{"$f":"IF('00'!D37=\"\",\"\",'00'!D37)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B38=\"\",\" -\",'00'!B38)","v":" -"},null,{"$f":"IF('00'!D38=\"\",\"\",'00'!D38)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B39=\"\",\" -\",'00'!B39)","v":" -"},null,{"$f":"IF('00'!D39=\"\",\"\",'00'!D39)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B40=\"\",\" -\",'00'!B40)","v":" -"},null,{"$f":"IF('00'!D40=\"\",\"\",'00'!D40)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B41=\"\",\" -\",'00'!B41)","v":" -"},null,{"$f":"IF('00'!D41=\"\",\"\",'00'!D41)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B42=\"\",\" -\",'00'!B42)","v":" -"},null,{"$f":"IF('00'!D42=\"\",\"\",'00'!D42)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B43=\"\",\" -\",'00'!B43)","v":" -"},null,{"$f":"IF('00'!D43=\"\",\"\",'00'!D43)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B44=\"\",\" -\",'00'!B44)","v":"Obéissance"},null,{"$f":"IF('00'!D44=\"\",\"\",'00'!D44)","v":4},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B45=\"\",\" -\",'00'!B45)","v":"Initiative"},null,{"$f":"IF('00'!D45=\"\",\"\",'00'!D45)","v":3},null,null,null,null,null,null,"OK",null,"OK"," "]
[null,{"$f":"IF('00'!B46=\"\",\" -\",'00'!B46)","v":"Douceur"},null,{"$f":"IF('00'!D46=\"\",\"\",'00'!D46)","v":3},null,null,null,null,null,null,"OK",null,"OK"]
[null,"Pointage du Travail  =>   ",{"$f":"SUM(C16:C46)","v":0},{"$f":"SUM(D16:D46)","v":10},null,"Temps : "]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C48>D48,\"! ? !\",\"OK\")","v":"OK"}]
[null,"Pénalités Générales\n(chiffre négatif) ",null,{"$f":"IF(C49>0,\"Erreur\",\"\")","v":""},"Informations sur les pénalités générales : \n   \n   \n   ",null,null,"Classement :",null,null,{"$f":"IF(C49=\"\",\"\",IF(C49>0,\"ATTENTION : les 'Pénalités Générales' doivent être un nombre négatif !\",\"OK\"))","v":""}]
[null,"TOTAL GENERAL = ",{"$f":"IF(COUNT(C16:C46)=0,\"-\",C47+C48+C49)","v":"-"},null,"Qualificatif :",{"$f":"IF(C50=\"-\",\"-\",IF(C50>'00'!D49*0.7999,\"EXCELLENT\",IF(C50>'00'!D49*0.6499,\"TRES BON\",IF(C50>'00'!D49*0.5499,\"BON\",\" - \"))))","v":"-"},null,{"$f":"'Fiche organisateur N°2'!N20","v":"X"},{"$f":"PRESENTS","v":0},null,null,null,null,null,null,null,"CACT OUI"]
[null,{"$f":"IF(AND(NIVEAU<>1,NIVEAU<>2),\"C.A.C.T. et R.C.A.C.T.\",IF(NIVEAU=2,\"BREVET  \",\"\"))","v":""},{"$f":"IF(NIVEAU=1,Q57,IF(NIVEAU=2,Q58,Q59))","v":"-"},null,{"$f":"IF(B51<>\"\",\"<== sur décision du juge\",\"\")","v":""},null,null,null,null,null,"CACT OUI",null,null,null,null,null,"CACT NON"]
[null,{"$f":"IF(AND(NIVEAU=2,F50=\"EXCELLENT\"),\"Observations (zone en gris) :       +   Noter                            PROPOSE POUR LE BREVET CONTINENTAL                         sur le carnet de travail  \",\"Observations :  \")","v":"Observations :  "},null,null,null,null,null,null,null,{"$f":"J47+J49","v":0}]
[]
[null,"N° Cheptel du concours :",{"$f":"'Fiche organisateur N°1'!E17","v":0},null,null,"Le Juge : ",{"$f":"'Fiche organisateur N°1'!E28","v":0},null,null,null,"Qualificatif"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N1","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N2",{"$f":"IF(AND(NIVEAU=2,F50=\"excellent\"),\"OUI\",\"NON\")","v":"NON"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N3",{"$f":"IF(AND(NIVEAU<>1,NIVEAU<>2,H50=1,C47>119.999,K51=\"CACT OUI\"),\"C.A.C.T.\",IF(AND(NIVEAU<>1,NIVEAU<>2,H50=2,C47>119.999,K51=\"CACT OUI\"),\"R.C.A.C.T.\",\"\"))","v":""}]

{"sheet":"05","index":10,"n_rows":59,"n_cols":17,"rows_kept":59,"cut":false,"hidden":false,"merged":[[35,4,35,8],[26,4,26,8],[51,2,51,8],[53,2,53,3],[53,6,53,8],[48,4,48,6],[48,7,48,8],[49,2,49,3],[49,5,49,6],[50,2,50,3],[50,4,50,6],[47,4,47,8],[36,4,36,8],[37,4,37,8],[38,4,38,8],[39,4,39,8],[40,4,40,8],[41,4,41,8],[42,4,42,8],[43,4,43,8],[44,4,44,8],[45,4,45,8],[46,6,46,8],[29,4,29,8],[30,4,30,8],[31,4,31,8],[24,4,24,8],[25,4,25,8],[32,4,32,8],[33,4,33,8],[34,4,34,8],[14,2,14,3],[20,4,20,8],[21,4,21,8],[16,4,16,8],[17,4,17,8],[18,4,18,8],[19,4,19,8],[22,4,22,8],[23,4,23,8],[14,4,14,8],[15,4,15,8],[27,4,27,8],[28,4,28,8],[10,6,10,8],[11,6,11,8],[0,7,0,8],[2,1,2,8],[3,1,3,8],[8,6,8,8],[9,6,9,8]]}
[null,null,null,null,null,null,null,{"$f":"'00'!H1:I1","v":"NIVEAU 1"}]
[]
[null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,{"$f":"'Fiche organisateur N°1'!C8","v":"Concours CONTINENTAL"}]
[null,"ORGANISATEUR : ",{"$f":"'Fiche organisateur N°1'!E15","v":0}]
[null,"Lieu : ",{"$f":"'Fiche organisateur N°1'!E16","v":0},null,null,"Date : ",{"$f":"'Fiche organisateur N°1'!E13","v":"00:00:00"}]
[null,"Contact : ",{"$f":"'Fiche organisateur N°1'!E18","v":0}]
[]
[null,"PROPRIETAIRE : ",{"$f":"'Fiche organisateur N°2'!I21","v":""},null,null,"Race & sexe : ",{"$f":"'Fiche organisateur N°2'!E21","v":""}]
[null,"CONDUCTEUR : ",{"$f":"'Fiche organisateur N°2'!J21","v":""},null,null,"N° FAPAC : ",{"$f":"'Fiche organisateur N°2'!F21","v":""}]
[null,"NOM DU CHIEN : ",{"$f":"'Fiche organisateur N°2'!C21","v":""},null,null,"Affixe : ",{"$f":"'Fiche organisateur N°2'!D21","v":""}]
[null,null,null,null,null,"ID : ",{"$f":"'Fiche organisateur N°2'!G21","v":""},null,null,null,"Contrôle de saisie (sur les onglets 01 à 18 ) "]
[]
[null,null,null,null,null,null,null,null,null,null,"Ces colonnes n'apparaissent pas lors de l'impression… "]
[null,"Epreuves                 ","Pointages",null,{"$f":"IF(OR('00'!K47<>17,LEFT('00'!E49,9)=\"ATTENTION\")=1,\"NON VALIDE => corriger la feuille 00 ! ! !\",\"Observations\")","v":"Observations"},null,null,null,null,null,"contrôle-1",null,"contrôle-2"]
[null,{"$f":"IF('00'!B16=\"\",\" -\",'00'!B16)","v":" -"},null,{"$f":"IF('00'!D16=\"\",\"\",'00'!D16)","v":""},null,null,null,null,null,null,{"$f":"IF(B16=\"\",\"\",IF(C16>D16,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B16=\" -\",C16<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B17=\"\",\" -\",'00'!B17)","v":" -"},null,{"$f":"IF('00'!D17=\"\",\"\",'00'!D17)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-1 : Contrôle que les valeurs entrées ne sont pas supérieures "]
[null,{"$f":"IF('00'!B18=\"\",\" -\",'00'!B18)","v":" -"},null,{"$f":"IF('00'!D18=\"\",\"\",'00'!D18)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"                    aux pointages maxi attribués à chaque épreuve…"]
[null,{"$f":"IF('00'!B19=\"\",\" -\",'00'!B19)","v":" -"},null,{"$f":"IF('00'!D19=\"\",\"\",'00'!D19)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B20=\"\",\" -\",'00'!B20)","v":" -"},null,{"$f":"IF('00'!D20=\"\",\"\",'00'!D20)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-2 : Contrôle que les colonnes sans épreuve ne contiennent pas de note"]
[null,{"$f":"IF('00'!B21=\"\",\" -\",'00'!B21)","v":" -"},null,{"$f":"IF('00'!D21=\"\",\"\",'00'!D21)","v":""},null,null,null,null,null,null,{"$f":"IF(B21=\"\",\"\",IF(C21>D21,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B21=\" -\",C21<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B22=\"\",\" -\",'00'!B22)","v":" -"},null,{"$f":"IF('00'!D22=\"\",\"\",'00'!D22)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B23=\"\",\" -\",'00'!B23)","v":" -"},null,{"$f":"IF('00'!D23=\"\",\"\",'00'!D23)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B24=\"\",\" -\",'00'!B24)","v":" -"},null,{"$f":"IF('00'!D24=\"\",\"\",'00'!D24)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B25=\"\",\" -\",'00'!B25)","v":" -"},null,{"$f":"IF('00'!D25=\"\",\"\",'00'!D25)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B26=\"\",\" -\",'00'!B26)","v":" -"},null,{"$f":"IF('00'!D26=\"\",\"\",'00'!D26)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B27=\"\",\" -\",'00'!B27)","v":" -"},null,{"$f":"IF('00'!D27=\"\",\"\",'00'!D27)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B28=\"\",\" -\",'00'!B28)","v":" -"},null,{"$f":"IF('00'!D28=\"\",\"\",'00'!D28)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B29=\"\",\" -\",'00'!B29)","v":" -"},null,{"$f":"IF('00'!D29=\"\",\"\",'00'!D29)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B30=\"\",\" -\",'00'!B30)","v":" -"},null,{"$f":"IF('00'!D30=\"\",\"\",'00'!D30)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B31=\"\",\" -\",'00'!B31)","v":" -"},null,{"$f":"IF('00'!D31=\"\",\"\",'00'!D31)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B32=\"\",\" -\",'00'!B32)","v":" -"},null,{"$f":"IF('00'!D32=\"\",\"\",'00'!D32)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B33=\"\",\" -\",'00'!B33)","v":" -"},null,{"$f":"IF('00'!D33=\"\",\"\",'00'!D33)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B34=\"\",\" -\",'00'!B34)","v":" -"},null,{"$f":"IF('00'!D34=\"\",\"\",'00'!D34)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B35=\"\",\" -\",'00'!B35)","v":" -"},null,{"$f":"IF('00'!D35=\"\",\"\",'00'!D35)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B36=\"\",\" -\",'00'!B36)","v":" -"},null,{"$f":"IF('00'!D36=\"\",\"\",'00'!D36)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B37=\"\",\" -\",'00'!B37)","v":" -"},null,{"$f":"IF('00'!D37=\"\",\"\",'00'!D37)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B38=\"\",\" -\",'00'!B38)","v":" -"},null,{"$f":"IF('00'!D38=\"\",\"\",'00'!D38)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B39=\"\",\" -\",'00'!B39)","v":" -"},null,{"$f":"IF('00'!D39=\"\",\"\",'00'!D39)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B40=\"\",\" -\",'00'!B40)","v":" -"},null,{"$f":"IF('00'!D40=\"\",\"\",'00'!D40)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B41=\"\",\" -\",'00'!B41)","v":" -"},null,{"$f":"IF('00'!D41=\"\",\"\",'00'!D41)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B42=\"\",\" -\",'00'!B42)","v":" -"},null,{"$f":"IF('00'!D42=\"\",\"\",'00'!D42)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B43=\"\",\" -\",'00'!B43)","v":" -"},null,{"$f":"IF('00'!D43=\"\",\"\",'00'!D43)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B44=\"\",\" -\",'00'!B44)","v":"Obéissance"},null,{"$f":"IF('00'!D44=\"\",\"\",'00'!D44)","v":4},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B45=\"\",\" -\",'00'!B45)","v":"Initiative"},null,{"$f":"IF('00'!D45=\"\",\"\",'00'!D45)","v":3},null,null,null,null,null,null,"OK",null,"OK"," "]
[null,{"$f":"IF('00'!B46=\"\",\" -\",'00'!B46)","v":"Douceur"},null,{"$f":"IF('00'!D46=\"\",\"\",'00'!D46)","v":3},null,null,null,null,null,null,"OK",null,"OK"]
[null,"Pointage du Travail  =>   ",{"$f":"SUM(C16:C46)","v":0},{"$f":"SUM(D16:D46)","v":10},null,"Temps : "]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C48>D48,\"! ? !\",\"OK\")","v":"OK"}]
[null,"Pénalités Générales\n(chiffre négatif) ",null,{"$f":"IF(C49>0,\"Erreur\",\"\")","v":""},"Informations sur les pénalités générales : \n   \n   \n   ",null,null,"Classement :",null,null,{"$f":"IF(C49=\"\",\"\",IF(C49>0,\"ATTENTION : les 'Pénalités Générales' doivent être un nombre négatif !\",\"OK\"))","v":""}]
[null,"TOTAL GENERAL = ",{"$f":"IF(COUNT(C16:C46)=0,\"-\",C47+C48+C49)","v":"-"},null,"Qualificatif :",{"$f":"IF(C50=\"-\",\"-\",IF(C50>'00'!D49*0.7999,\"EXCELLENT\",IF(C50>'00'!D49*0.6499,\"TRES BON\",IF(C50>'00'!D49*0.5499,\"BON\",\" - \"))))","v":"-"},null,{"$f":"'Fiche organisateur N°2'!N21","v":"X"},{"$f":"PRESENTS","v":0},null,null,null,null,null,null,null,"CACT OUI"]
[null,{"$f":"IF(AND(NIVEAU<>1,NIVEAU<>2),\"C.A.C.T. et R.C.A.C.T.\",IF(NIVEAU=2,\"BREVET  \",\"\"))","v":""},{"$f":"IF(NIVEAU=1,Q57,IF(NIVEAU=2,Q58,Q59))","v":"-"},null,{"$f":"IF(B51<>\"\",\"<== sur décision du juge\",\"\")","v":""},null,null,null,null,null,"CACT OUI",null,null,null,null,null,"CACT NON"]
[null,{"$f":"IF(AND(NIVEAU=2,F50=\"EXCELLENT\"),\"Observations (zone en gris) :       +   Noter                            PROPOSE POUR LE BREVET CONTINENTAL                         sur le carnet de travail  \",\"Observations :  \")","v":"Observations :  "},null,null,null,null,null,null,null,{"$f":"J47+J49","v":0}]
[]
[null,"N° Cheptel du concours :",{"$f":"'Fiche organisateur N°1'!E17","v":0},null,null,"Le Juge : ",{"$f":"'Fiche organisateur N°1'!E28","v":0},null,null,null,"Qualificatif"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N1","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N2",{"$f":"IF(AND(NIVEAU=2,F50=\"excellent\"),\"OUI\",\"NON\")","v":"NON"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N3",{"$f":"IF(AND(NIVEAU<>1,NIVEAU<>2,H50=1,C47>119.999,K51=\"CACT OUI\"),\"C.A.C.T.\",IF(AND(NIVEAU<>1,NIVEAU<>2,H50=2,C47>119.999,K51=\"CACT OUI\"),\"R.C.A.C.T.\",\"\"))","v":""}]

{"sheet":"06","index":11,"n_rows":59,"n_cols":17,"rows_kept":59,"cut":false,"hidden":false,"merged":[[35,4,35,8],[26,4,26,8],[51,2,51,8],[53,2,53,3],[53,6,53,8],[48,4,48,6],[48,7,48,8],[49,2,49,3],[49,5,49,6],[50,2,50,3],[50,4,50,6],[47,4,47,8],[36,4,36,8],[37,4,37,8],[38,4,38,8],[39,4,39,8],[40,4,40,8],[41,4,41,8],[42,4,42,8],[43,4,43,8],[44,4,44,8],[45,4,45,8],[46,6,46,8],[29,4,29,8],[30,4,30,8],[31,4,31,8],[24,4,24,8],[25,4,25,8],[32,4,32,8],[33,4,33,8],[34,4,34,8],[14,2,14,3],[20,4,20,8],[21,4,21,8],[16,4,16,8],[17,4,17,8],[18,4,18,8],[19,4,19,8],[22,4,22,8],[23,4,23,8],[14,4,14,8],[15,4,15,8],[27,4,27,8],[28,4,28,8],[10,6,10,8],[11,6,11,8],[0,7,0,8],[2,1,2,8],[3,1,3,8],[8,6,8,8],[9,6,9,8]]}
[null,null,null,null,null,null,null,{"$f":"'00'!H1:I1","v":"NIVEAU 1"}]
[]
[null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,{"$f":"'Fiche organisateur N°1'!C8","v":"Concours CONTINENTAL"}]
[null,"ORGANISATEUR : ",{"$f":"'Fiche organisateur N°1'!E15","v":0}]
[null,"Lieu : ",{"$f":"'Fiche organisateur N°1'!E16","v":0},null,null,"Date : ",{"$f":"'Fiche organisateur N°1'!E13","v":"00:00:00"}]
[null,"Contact : ",{"$f":"'Fiche organisateur N°1'!E18","v":0}]
[]
[null,"PROPRIETAIRE : ",{"$f":"'Fiche organisateur N°2'!I22","v":""},null,null,"Race & sexe : ",{"$f":"'Fiche organisateur N°2'!E22","v":""}]
[null,"CONDUCTEUR : ",{"$f":"'Fiche organisateur N°2'!J22","v":""},null,null,"N° FAPAC : ",{"$f":"'Fiche organisateur N°2'!F22","v":""}]
[null,"NOM DU CHIEN : ",{"$f":"'Fiche organisateur N°2'!C22","v":""},null,null,"Affixe : ",{"$f":"'Fiche organisateur N°2'!D22","v":""}]
[null,null,null,null,null,"ID : ",{"$f":"'Fiche organisateur N°2'!G22","v":""},null,null,null,"Contrôle de saisie (sur les onglets 01 à 18 ) "]
[]
[null,null,null,null,null,null,null,null,null,null,"Ces colonnes n'apparaissent pas lors de l'impression… "]
[null,"Epreuves                 ","Pointages",null,{"$f":"IF(OR('00'!K47<>17,LEFT('00'!E49,9)=\"ATTENTION\")=1,\"NON VALIDE => corriger la feuille 00 ! ! !\",\"Observations\")","v":"Observations"},null,null,null,null,null,"contrôle-1",null,"contrôle-2"]
[null,{"$f":"IF('00'!B16=\"\",\" -\",'00'!B16)","v":" -"},null,{"$f":"IF('00'!D16=\"\",\"\",'00'!D16)","v":""},null,null,null,null,null,null,{"$f":"IF(B16=\"\",\"\",IF(C16>D16,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B16=\" -\",C16<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B17=\"\",\" -\",'00'!B17)","v":" -"},null,{"$f":"IF('00'!D17=\"\",\"\",'00'!D17)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-1 : Contrôle que les valeurs entrées ne sont pas supérieures "]
[null,{"$f":"IF('00'!B18=\"\",\" -\",'00'!B18)","v":" -"},null,{"$f":"IF('00'!D18=\"\",\"\",'00'!D18)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"                    aux pointages maxi attribués à chaque épreuve…"]
[null,{"$f":"IF('00'!B19=\"\",\" -\",'00'!B19)","v":" -"},null,{"$f":"IF('00'!D19=\"\",\"\",'00'!D19)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B20=\"\",\" -\",'00'!B20)","v":" -"},null,{"$f":"IF('00'!D20=\"\",\"\",'00'!D20)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-2 : Contrôle que les colonnes sans épreuve ne contiennent pas de note"]
[null,{"$f":"IF('00'!B21=\"\",\" -\",'00'!B21)","v":" -"},null,{"$f":"IF('00'!D21=\"\",\"\",'00'!D21)","v":""},null,null,null,null,null,null,{"$f":"IF(B21=\"\",\"\",IF(C21>D21,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B21=\" -\",C21<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B22=\"\",\" -\",'00'!B22)","v":" -"},null,{"$f":"IF('00'!D22=\"\",\"\",'00'!D22)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B23=\"\",\" -\",'00'!B23)","v":" -"},null,{"$f":"IF('00'!D23=\"\",\"\",'00'!D23)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B24=\"\",\" -\",'00'!B24)","v":" -"},null,{"$f":"IF('00'!D24=\"\",\"\",'00'!D24)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B25=\"\",\" -\",'00'!B25)","v":" -"},null,{"$f":"IF('00'!D25=\"\",\"\",'00'!D25)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B26=\"\",\" -\",'00'!B26)","v":" -"},null,{"$f":"IF('00'!D26=\"\",\"\",'00'!D26)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B27=\"\",\" -\",'00'!B27)","v":" -"},null,{"$f":"IF('00'!D27=\"\",\"\",'00'!D27)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B28=\"\",\" -\",'00'!B28)","v":" -"},null,{"$f":"IF('00'!D28=\"\",\"\",'00'!D28)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B29=\"\",\" -\",'00'!B29)","v":" -"},null,{"$f":"IF('00'!D29=\"\",\"\",'00'!D29)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B30=\"\",\" -\",'00'!B30)","v":" -"},null,{"$f":"IF('00'!D30=\"\",\"\",'00'!D30)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B31=\"\",\" -\",'00'!B31)","v":" -"},null,{"$f":"IF('00'!D31=\"\",\"\",'00'!D31)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B32=\"\",\" -\",'00'!B32)","v":" -"},null,{"$f":"IF('00'!D32=\"\",\"\",'00'!D32)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B33=\"\",\" -\",'00'!B33)","v":" -"},null,{"$f":"IF('00'!D33=\"\",\"\",'00'!D33)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B34=\"\",\" -\",'00'!B34)","v":" -"},null,{"$f":"IF('00'!D34=\"\",\"\",'00'!D34)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B35=\"\",\" -\",'00'!B35)","v":" -"},null,{"$f":"IF('00'!D35=\"\",\"\",'00'!D35)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B36=\"\",\" -\",'00'!B36)","v":" -"},null,{"$f":"IF('00'!D36=\"\",\"\",'00'!D36)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B37=\"\",\" -\",'00'!B37)","v":" -"},null,{"$f":"IF('00'!D37=\"\",\"\",'00'!D37)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B38=\"\",\" -\",'00'!B38)","v":" -"},null,{"$f":"IF('00'!D38=\"\",\"\",'00'!D38)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B39=\"\",\" -\",'00'!B39)","v":" -"},null,{"$f":"IF('00'!D39=\"\",\"\",'00'!D39)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B40=\"\",\" -\",'00'!B40)","v":" -"},null,{"$f":"IF('00'!D40=\"\",\"\",'00'!D40)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B41=\"\",\" -\",'00'!B41)","v":" -"},null,{"$f":"IF('00'!D41=\"\",\"\",'00'!D41)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B42=\"\",\" -\",'00'!B42)","v":" -"},null,{"$f":"IF('00'!D42=\"\",\"\",'00'!D42)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B43=\"\",\" -\",'00'!B43)","v":" -"},null,{"$f":"IF('00'!D43=\"\",\"\",'00'!D43)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B44=\"\",\" -\",'00'!B44)","v":"Obéissance"},null,{"$f":"IF('00'!D44=\"\",\"\",'00'!D44)","v":4},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B45=\"\",\" -\",'00'!B45)","v":"Initiative"},null,{"$f":"IF('00'!D45=\"\",\"\",'00'!D45)","v":3},null,null,null,null,null,null,"OK",null,"OK"," "]
[null,{"$f":"IF('00'!B46=\"\",\" -\",'00'!B46)","v":"Douceur"},null,{"$f":"IF('00'!D46=\"\",\"\",'00'!D46)","v":3},null,null,null,null,null,null,"OK",null,"OK"]
[null,"Pointage du Travail  =>   ",{"$f":"SUM(C16:C46)","v":0},{"$f":"SUM(D16:D46)","v":10},null,"Temps : "]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C48>D48,\"! ? !\",\"OK\")","v":"OK"}]
[null,"Pénalités Générales\n(chiffre négatif) ",null,{"$f":"IF(C49>0,\"Erreur\",\"\")","v":""},"Informations sur les pénalités générales : \n   \n   \n   ",null,null,"Classement :",null,null,{"$f":"IF(C49=\"\",\"\",IF(C49>0,\"ATTENTION : les 'Pénalités Générales' doivent être un nombre négatif !\",\"OK\"))","v":""}]
[null,"TOTAL GENERAL = ",{"$f":"IF(COUNT(C16:C46)=0,\"-\",C47+C48+C49)","v":"-"},null,"Qualificatif :",{"$f":"IF(C50=\"-\",\"-\",IF(C50>'00'!D49*0.7999,\"EXCELLENT\",IF(C50>'00'!D49*0.6499,\"TRES BON\",IF(C50>'00'!D49*0.5499,\"BON\",\" - \"))))","v":"-"},null,{"$f":"'Fiche organisateur N°2'!N22","v":"X"},{"$f":"PRESENTS","v":0},null,null,null,null,null,null,null,"CACT OUI"]
[null,{"$f":"IF(AND(NIVEAU<>1,NIVEAU<>2),\"C.A.C.T. et R.C.A.C.T.\",IF(NIVEAU=2,\"BREVET  \",\"\"))","v":""},{"$f":"IF(NIVEAU=1,Q57,IF(NIVEAU=2,Q58,Q59))","v":"-"},null,{"$f":"IF(B51<>\"\",\"<== sur décision du juge\",\"\")","v":""},null,null,null,null,null,"CACT OUI",null,null,null,null,null,"CACT NON"]
[null,{"$f":"IF(AND(NIVEAU=2,F50=\"EXCELLENT\"),\"Observations (zone en gris) :       +   Noter                            PROPOSE POUR LE BREVET CONTINENTAL                         sur le carnet de travail  \",\"Observations :  \")","v":"Observations :  "},null,null,null,null,null,null,null,{"$f":"J47+J49","v":0}]
[]
[null,"N° Cheptel du concours :",{"$f":"'Fiche organisateur N°1'!E17","v":0},null,null,"Le Juge : ",{"$f":"'Fiche organisateur N°1'!E28","v":0},null,null,null,"Qualificatif"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N1","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N2",{"$f":"IF(AND(NIVEAU=2,F50=\"excellent\"),\"OUI\",\"NON\")","v":"NON"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N3",{"$f":"IF(AND(NIVEAU<>1,NIVEAU<>2,H50=1,C47>119.999,K51=\"CACT OUI\"),\"C.A.C.T.\",IF(AND(NIVEAU<>1,NIVEAU<>2,H50=2,C47>119.999,K51=\"CACT OUI\"),\"R.C.A.C.T.\",\"\"))","v":""}]

{"sheet":"07","index":12,"n_rows":59,"n_cols":17,"rows_kept":59,"cut":false,"hidden":false,"merged":[[35,4,35,8],[26,4,26,8],[51,2,51,8],[53,2,53,3],[53,6,53,8],[48,4,48,6],[48,7,48,8],[49,2,49,3],[49,5,49,6],[50,2,50,3],[50,4,50,6],[47,4,47,8],[36,4,36,8],[37,4,37,8],[38,4,38,8],[39,4,39,8],[40,4,40,8],[41,4,41,8],[42,4,42,8],[43,4,43,8],[44,4,44,8],[45,4,45,8],[46,6,46,8],[29,4,29,8],[30,4,30,8],[31,4,31,8],[24,4,24,8],[25,4,25,8],[32,4,32,8],[33,4,33,8],[34,4,34,8],[14,2,14,3],[20,4,20,8],[21,4,21,8],[16,4,16,8],[17,4,17,8],[18,4,18,8],[19,4,19,8],[22,4,22,8],[23,4,23,8],[14,4,14,8],[15,4,15,8],[27,4,27,8],[28,4,28,8],[10,6,10,8],[11,6,11,8],[0,7,0,8],[2,1,2,8],[3,1,3,8],[8,6,8,8],[9,6,9,8]]}
[null,null,null,null,null,null,null,{"$f":"'00'!H1:I1","v":"NIVEAU 1"}]
[]
[null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,{"$f":"'Fiche organisateur N°1'!C8","v":"Concours CONTINENTAL"}]
[null,"ORGANISATEUR : ",{"$f":"'Fiche organisateur N°1'!E15","v":0}]
[null,"Lieu : ",{"$f":"'Fiche organisateur N°1'!E16","v":0},null,null,"Date : ",{"$f":"'Fiche organisateur N°1'!E13","v":"00:00:00"}]
[null,"Contact : ",{"$f":"'Fiche organisateur N°1'!E18","v":0}]
[]
[null,"PROPRIETAIRE : ",{"$f":"'Fiche organisateur N°2'!I23","v":""},null,null,"Race & sexe : ",{"$f":"'Fiche organisateur N°2'!E23","v":""}]
[null,"CONDUCTEUR : ",{"$f":"'Fiche organisateur N°2'!J23","v":""},null,null,"N° FAPAC : ",{"$f":"'Fiche organisateur N°2'!F23","v":""}]
[null,"NOM DU CHIEN : ",{"$f":"'Fiche organisateur N°2'!C23","v":""},null,null,"Affixe : ",{"$f":"'Fiche organisateur N°2'!D23","v":""}]
[null,null,null,null,null,"ID : ",{"$f":"'Fiche organisateur N°2'!G23","v":""},null,null,null,"Contrôle de saisie (sur les onglets 01 à 18 ) "]
[]
[null,null,null,null,null,null,null,null,null,null,"Ces colonnes n'apparaissent pas lors de l'impression… "]
[null,"Epreuves                 ","Pointages",null,{"$f":"IF(OR('00'!K47<>17,LEFT('00'!E49,9)=\"ATTENTION\")=1,\"NON VALIDE => corriger la feuille 00 ! ! !\",\"Observations\")","v":"Observations"},null,null,null,null,null,"contrôle-1",null,"contrôle-2"]
[null,{"$f":"IF('00'!B16=\"\",\" -\",'00'!B16)","v":" -"},null,{"$f":"IF('00'!D16=\"\",\"\",'00'!D16)","v":""},null,null,null,null,null,null,{"$f":"IF(B16=\"\",\"\",IF(C16>D16,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B16=\" -\",C16<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B17=\"\",\" -\",'00'!B17)","v":" -"},null,{"$f":"IF('00'!D17=\"\",\"\",'00'!D17)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-1 : Contrôle que les valeurs entrées ne sont pas supérieures "]
[null,{"$f":"IF('00'!B18=\"\",\" -\",'00'!B18)","v":" -"},null,{"$f":"IF('00'!D18=\"\",\"\",'00'!D18)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"                    aux pointages maxi attribués à chaque épreuve…"]
[null,{"$f":"IF('00'!B19=\"\",\" -\",'00'!B19)","v":" -"},null,{"$f":"IF('00'!D19=\"\",\"\",'00'!D19)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B20=\"\",\" -\",'00'!B20)","v":" -"},null,{"$f":"IF('00'!D20=\"\",\"\",'00'!D20)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-2 : Contrôle que les colonnes sans épreuve ne contiennent pas de note"]
[null,{"$f":"IF('00'!B21=\"\",\" -\",'00'!B21)","v":" -"},null,{"$f":"IF('00'!D21=\"\",\"\",'00'!D21)","v":""},null,null,null,null,null,null,{"$f":"IF(B21=\"\",\"\",IF(C21>D21,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B21=\" -\",C21<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B22=\"\",\" -\",'00'!B22)","v":" -"},null,{"$f":"IF('00'!D22=\"\",\"\",'00'!D22)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B23=\"\",\" -\",'00'!B23)","v":" -"},null,{"$f":"IF('00'!D23=\"\",\"\",'00'!D23)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B24=\"\",\" -\",'00'!B24)","v":" -"},null,{"$f":"IF('00'!D24=\"\",\"\",'00'!D24)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B25=\"\",\" -\",'00'!B25)","v":" -"},null,{"$f":"IF('00'!D25=\"\",\"\",'00'!D25)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B26=\"\",\" -\",'00'!B26)","v":" -"},null,{"$f":"IF('00'!D26=\"\",\"\",'00'!D26)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B27=\"\",\" -\",'00'!B27)","v":" -"},null,{"$f":"IF('00'!D27=\"\",\"\",'00'!D27)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B28=\"\",\" -\",'00'!B28)","v":" -"},null,{"$f":"IF('00'!D28=\"\",\"\",'00'!D28)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B29=\"\",\" -\",'00'!B29)","v":" -"},null,{"$f":"IF('00'!D29=\"\",\"\",'00'!D29)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B30=\"\",\" -\",'00'!B30)","v":" -"},null,{"$f":"IF('00'!D30=\"\",\"\",'00'!D30)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B31=\"\",\" -\",'00'!B31)","v":" -"},null,{"$f":"IF('00'!D31=\"\",\"\",'00'!D31)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B32=\"\",\" -\",'00'!B32)","v":" -"},null,{"$f":"IF('00'!D32=\"\",\"\",'00'!D32)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B33=\"\",\" -\",'00'!B33)","v":" -"},null,{"$f":"IF('00'!D33=\"\",\"\",'00'!D33)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B34=\"\",\" -\",'00'!B34)","v":" -"},null,{"$f":"IF('00'!D34=\"\",\"\",'00'!D34)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B35=\"\",\" -\",'00'!B35)","v":" -"},null,{"$f":"IF('00'!D35=\"\",\"\",'00'!D35)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B36=\"\",\" -\",'00'!B36)","v":" -"},null,{"$f":"IF('00'!D36=\"\",\"\",'00'!D36)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B37=\"\",\" -\",'00'!B37)","v":" -"},null,{"$f":"IF('00'!D37=\"\",\"\",'00'!D37)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B38=\"\",\" -\",'00'!B38)","v":" -"},null,{"$f":"IF('00'!D38=\"\",\"\",'00'!D38)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B39=\"\",\" -\",'00'!B39)","v":" -"},null,{"$f":"IF('00'!D39=\"\",\"\",'00'!D39)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B40=\"\",\" -\",'00'!B40)","v":" -"},null,{"$f":"IF('00'!D40=\"\",\"\",'00'!D40)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B41=\"\",\" -\",'00'!B41)","v":" -"},null,{"$f":"IF('00'!D41=\"\",\"\",'00'!D41)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B42=\"\",\" -\",'00'!B42)","v":" -"},null,{"$f":"IF('00'!D42=\"\",\"\",'00'!D42)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B43=\"\",\" -\",'00'!B43)","v":" -"},null,{"$f":"IF('00'!D43=\"\",\"\",'00'!D43)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B44=\"\",\" -\",'00'!B44)","v":"Obéissance"},null,{"$f":"IF('00'!D44=\"\",\"\",'00'!D44)","v":4},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B45=\"\",\" -\",'00'!B45)","v":"Initiative"},null,{"$f":"IF('00'!D45=\"\",\"\",'00'!D45)","v":3},null,null,null,null,null,null,"OK",null,"OK"," "]
[null,{"$f":"IF('00'!B46=\"\",\" -\",'00'!B46)","v":"Douceur"},null,{"$f":"IF('00'!D46=\"\",\"\",'00'!D46)","v":3},null,null,null,null,null,null,"OK",null,"OK"]
[null,"Pointage du Travail  =>   ",{"$f":"SUM(C16:C46)","v":0},{"$f":"SUM(D16:D46)","v":10},null,"Temps : "]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C48>D48,\"! ? !\",\"OK\")","v":"OK"}]
[null,"Pénalités Générales\n(chiffre négatif) ",null,{"$f":"IF(C49>0,\"Erreur\",\"\")","v":""},"Informations sur les pénalités générales : \n   \n   \n   ",null,null,"Classement :",null,null,{"$f":"IF(C49=\"\",\"\",IF(C49>0,\"ATTENTION : les 'Pénalités Générales' doivent être un nombre négatif !\",\"OK\"))","v":""}]
[null,"TOTAL GENERAL = ",{"$f":"IF(COUNT(C16:C46)=0,\"-\",C47+C48+C49)","v":"-"},null,"Qualificatif :",{"$f":"IF(C50=\"-\",\"-\",IF(C50>'00'!D49*0.7999,\"EXCELLENT\",IF(C50>'00'!D49*0.6499,\"TRES BON\",IF(C50>'00'!D49*0.5499,\"BON\",\" - \"))))","v":"-"},null,{"$f":"'Fiche organisateur N°2'!N23","v":"X"},{"$f":"PRESENTS","v":0},null,null,null,null,null,null,null,"CACT OUI"]
[null,{"$f":"IF(AND(NIVEAU<>1,NIVEAU<>2),\"C.A.C.T. et R.C.A.C.T.\",IF(NIVEAU=2,\"BREVET  \",\"\"))","v":""},{"$f":"IF(NIVEAU=1,Q57,IF(NIVEAU=2,Q58,Q59))","v":"-"},null,{"$f":"IF(B51<>\"\",\"<== sur décision du juge\",\"\")","v":""},null,null,null,null,null,"CACT OUI",null,null,null,null,null,"CACT NON"]
[null,{"$f":"IF(AND(NIVEAU=2,F50=\"EXCELLENT\"),\"Observations (zone en gris) :       +   Noter                            PROPOSE POUR LE BREVET CONTINENTAL                         sur le carnet de travail  \",\"Observations :  \")","v":"Observations :  "},null,null,null,null,null,null,null,{"$f":"J47+J49","v":0}]
[]
[null,"N° Cheptel du concours :",{"$f":"'Fiche organisateur N°1'!E17","v":0},null,null,"Le Juge : ",{"$f":"'Fiche organisateur N°1'!E28","v":0},null,null,null,"Qualificatif"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N1","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N2",{"$f":"IF(AND(NIVEAU=2,F50=\"excellent\"),\"OUI\",\"NON\")","v":"NON"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N3",{"$f":"IF(AND(NIVEAU<>1,NIVEAU<>2,H50=1,C47>119.999,K51=\"CACT OUI\"),\"C.A.C.T.\",IF(AND(NIVEAU<>1,NIVEAU<>2,H50=2,C47>119.999,K51=\"CACT OUI\"),\"R.C.A.C.T.\",\"\"))","v":""}]

{"sheet":"08","index":13,"n_rows":59,"n_cols":17,"rows_kept":59,"cut":false,"hidden":false,"merged":[[35,4,35,8],[26,4,26,8],[51,2,51,8],[53,2,53,3],[53,6,53,8],[48,4,48,6],[48,7,48,8],[49,2,49,3],[49,5,49,6],[50,2,50,3],[50,4,50,6],[47,4,47,8],[36,4,36,8],[37,4,37,8],[38,4,38,8],[39,4,39,8],[40,4,40,8],[41,4,41,8],[42,4,42,8],[43,4,43,8],[44,4,44,8],[45,4,45,8],[46,6,46,8],[29,4,29,8],[30,4,30,8],[31,4,31,8],[24,4,24,8],[25,4,25,8],[32,4,32,8],[33,4,33,8],[34,4,34,8],[14,2,14,3],[20,4,20,8],[21,4,21,8],[16,4,16,8],[17,4,17,8],[18,4,18,8],[19,4,19,8],[22,4,22,8],[23,4,23,8],[14,4,14,8],[15,4,15,8],[27,4,27,8],[28,4,28,8],[10,6,10,8],[11,6,11,8],[0,7,0,8],[2,1,2,8],[3,1,3,8],[8,6,8,8],[9,6,9,8]]}
[null,null,null,null,null,null,null,{"$f":"'00'!H1:I1","v":"NIVEAU 1"}]
[]
[null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,{"$f":"'Fiche organisateur N°1'!C8","v":"Concours CONTINENTAL"}]
[null,"ORGANISATEUR : ",{"$f":"'Fiche organisateur N°1'!E15","v":0}]
[null,"Lieu : ",{"$f":"'Fiche organisateur N°1'!E16","v":0},null,null,"Date : ",{"$f":"'Fiche organisateur N°1'!E13","v":"00:00:00"}]
[null,"Contact : ",{"$f":"'Fiche organisateur N°1'!E18","v":0}]
[]
[null,"PROPRIETAIRE : ",{"$f":"'Fiche organisateur N°2'!I24","v":""},null,null,"Race & sexe : ",{"$f":"'Fiche organisateur N°2'!E24","v":""}]
[null,"CONDUCTEUR : ",{"$f":"'Fiche organisateur N°2'!J24","v":""},null,null,"N° FAPAC : ",{"$f":"'Fiche organisateur N°2'!F24","v":""}]
[null,"NOM DU CHIEN : ",{"$f":"'Fiche organisateur N°2'!C24","v":""},null,null,"Affixe : ",{"$f":"'Fiche organisateur N°2'!D24","v":""}]
[null,null,null,null,null,"ID : ",{"$f":"'Fiche organisateur N°2'!G24","v":""},null,null,null,"Contrôle de saisie (sur les onglets 01 à 18 ) "]
[]
[null,null,null,null,null,null,null,null,null,null,"Ces colonnes n'apparaissent pas lors de l'impression… "]
[null,"Epreuves                 ","Pointages",null,{"$f":"IF(OR('00'!K47<>17,LEFT('00'!E49,9)=\"ATTENTION\")=1,\"NON VALIDE => corriger la feuille 00 ! ! !\",\"Observations\")","v":"Observations"},null,null,null,null,null,"contrôle-1",null,"contrôle-2"]
[null,{"$f":"IF('00'!B16=\"\",\" -\",'00'!B16)","v":" -"},null,{"$f":"IF('00'!D16=\"\",\"\",'00'!D16)","v":""},null,null,null,null,null,null,{"$f":"IF(B16=\"\",\"\",IF(C16>D16,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B16=\" -\",C16<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B17=\"\",\" -\",'00'!B17)","v":" -"},null,{"$f":"IF('00'!D17=\"\",\"\",'00'!D17)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-1 : Contrôle que les valeurs entrées ne sont pas supérieures "]
[null,{"$f":"IF('00'!B18=\"\",\" -\",'00'!B18)","v":" -"},null,{"$f":"IF('00'!D18=\"\",\"\",'00'!D18)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"                    aux pointages maxi attribués à chaque épreuve…"]
[null,{"$f":"IF('00'!B19=\"\",\" -\",'00'!B19)","v":" -"},null,{"$f":"IF('00'!D19=\"\",\"\",'00'!D19)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B20=\"\",\" -\",'00'!B20)","v":" -"},null,{"$f":"IF('00'!D20=\"\",\"\",'00'!D20)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-2 : Contrôle que les colonnes sans épreuve ne contiennent pas de note"]
[null,{"$f":"IF('00'!B21=\"\",\" -\",'00'!B21)","v":" -"},null,{"$f":"IF('00'!D21=\"\",\"\",'00'!D21)","v":""},null,null,null,null,null,null,{"$f":"IF(B21=\"\",\"\",IF(C21>D21,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B21=\" -\",C21<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B22=\"\",\" -\",'00'!B22)","v":" -"},null,{"$f":"IF('00'!D22=\"\",\"\",'00'!D22)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B23=\"\",\" -\",'00'!B23)","v":" -"},null,{"$f":"IF('00'!D23=\"\",\"\",'00'!D23)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B24=\"\",\" -\",'00'!B24)","v":" -"},null,{"$f":"IF('00'!D24=\"\",\"\",'00'!D24)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B25=\"\",\" -\",'00'!B25)","v":" -"},null,{"$f":"IF('00'!D25=\"\",\"\",'00'!D25)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B26=\"\",\" -\",'00'!B26)","v":" -"},null,{"$f":"IF('00'!D26=\"\",\"\",'00'!D26)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B27=\"\",\" -\",'00'!B27)","v":" -"},null,{"$f":"IF('00'!D27=\"\",\"\",'00'!D27)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B28=\"\",\" -\",'00'!B28)","v":" -"},null,{"$f":"IF('00'!D28=\"\",\"\",'00'!D28)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B29=\"\",\" -\",'00'!B29)","v":" -"},null,{"$f":"IF('00'!D29=\"\",\"\",'00'!D29)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B30=\"\",\" -\",'00'!B30)","v":" -"},null,{"$f":"IF('00'!D30=\"\",\"\",'00'!D30)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B31=\"\",\" -\",'00'!B31)","v":" -"},null,{"$f":"IF('00'!D31=\"\",\"\",'00'!D31)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B32=\"\",\" -\",'00'!B32)","v":" -"},null,{"$f":"IF('00'!D32=\"\",\"\",'00'!D32)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B33=\"\",\" -\",'00'!B33)","v":" -"},null,{"$f":"IF('00'!D33=\"\",\"\",'00'!D33)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B34=\"\",\" -\",'00'!B34)","v":" -"},null,{"$f":"IF('00'!D34=\"\",\"\",'00'!D34)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B35=\"\",\" -\",'00'!B35)","v":" -"},null,{"$f":"IF('00'!D35=\"\",\"\",'00'!D35)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B36=\"\",\" -\",'00'!B36)","v":" -"},null,{"$f":"IF('00'!D36=\"\",\"\",'00'!D36)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B37=\"\",\" -\",'00'!B37)","v":" -"},null,{"$f":"IF('00'!D37=\"\",\"\",'00'!D37)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B38=\"\",\" -\",'00'!B38)","v":" -"},null,{"$f":"IF('00'!D38=\"\",\"\",'00'!D38)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B39=\"\",\" -\",'00'!B39)","v":" -"},null,{"$f":"IF('00'!D39=\"\",\"\",'00'!D39)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B40=\"\",\" -\",'00'!B40)","v":" -"},null,{"$f":"IF('00'!D40=\"\",\"\",'00'!D40)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B41=\"\",\" -\",'00'!B41)","v":" -"},null,{"$f":"IF('00'!D41=\"\",\"\",'00'!D41)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B42=\"\",\" -\",'00'!B42)","v":" -"},null,{"$f":"IF('00'!D42=\"\",\"\",'00'!D42)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B43=\"\",\" -\",'00'!B43)","v":" -"},null,{"$f":"IF('00'!D43=\"\",\"\",'00'!D43)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B44=\"\",\" -\",'00'!B44)","v":"Obéissance"},null,{"$f":"IF('00'!D44=\"\",\"\",'00'!D44)","v":4},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B45=\"\",\" -\",'00'!B45)","v":"Initiative"},null,{"$f":"IF('00'!D45=\"\",\"\",'00'!D45)","v":3},null,null,null,null,null,null,"OK",null,"OK"," "]
[null,{"$f":"IF('00'!B46=\"\",\" -\",'00'!B46)","v":"Douceur"},null,{"$f":"IF('00'!D46=\"\",\"\",'00'!D46)","v":3},null,null,null,null,null,null,"OK",null,"OK"]
[null,"Pointage du Travail  =>   ",{"$f":"SUM(C16:C46)","v":0},{"$f":"SUM(D16:D46)","v":10},null,"Temps : "]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C48>D48,\"! ? !\",\"OK\")","v":"OK"}]
[null,"Pénalités Générales\n(chiffre négatif) ",null,{"$f":"IF(C49>0,\"Erreur\",\"\")","v":""},"Informations sur les pénalités générales : \n   \n   \n   ",null,null,"Classement :",null,null,{"$f":"IF(C49=\"\",\"\",IF(C49>0,\"ATTENTION : les 'Pénalités Générales' doivent être un nombre négatif !\",\"OK\"))","v":""}]
[null,"TOTAL GENERAL = ",{"$f":"IF(COUNT(C16:C46)=0,\"-\",C47+C48+C49)","v":"-"},null,"Qualificatif :",{"$f":"IF(C50=\"-\",\"-\",IF(C50>'00'!D49*0.7999,\"EXCELLENT\",IF(C50>'00'!D49*0.6499,\"TRES BON\",IF(C50>'00'!D49*0.5499,\"BON\",\" - \"))))","v":"-"},null,{"$f":"'Fiche organisateur N°2'!N24","v":"X"},{"$f":"PRESENTS","v":0},null,null,null,null,null,null,null,"CACT OUI"]
[null,{"$f":"IF(AND(NIVEAU<>1,NIVEAU<>2),\"C.A.C.T. et R.C.A.C.T.\",IF(NIVEAU=2,\"BREVET  \",\"\"))","v":""},{"$f":"IF(NIVEAU=1,Q57,IF(NIVEAU=2,Q58,Q59))","v":"-"},null,{"$f":"IF(B51<>\"\",\"<== sur décision du juge\",\"\")","v":""},null,null,null,null,null,"CACT OUI",null,null,null,null,null,"CACT NON"]
[null,{"$f":"IF(AND(NIVEAU=2,F50=\"EXCELLENT\"),\"Observations (zone en gris) :       +   Noter                            PROPOSE POUR LE BREVET CONTINENTAL                         sur le carnet de travail  \",\"Observations :  \")","v":"Observations :  "},null,null,null,null,null,null,null,{"$f":"J47+J49","v":0}]
[]
[null,"N° Cheptel du concours :",{"$f":"'Fiche organisateur N°1'!E17","v":0},null,null,"Le Juge : ",{"$f":"'Fiche organisateur N°1'!E28","v":0},null,null,null,"Qualificatif"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N1","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N2",{"$f":"IF(AND(NIVEAU=2,F50=\"excellent\"),\"OUI\",\"NON\")","v":"NON"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N3",{"$f":"IF(AND(NIVEAU<>1,NIVEAU<>2,H50=1,C47>119.999,K51=\"CACT OUI\"),\"C.A.C.T.\",IF(AND(NIVEAU<>1,NIVEAU<>2,H50=2,C47>119.999,K51=\"CACT OUI\"),\"R.C.A.C.T.\",\"\"))","v":""}]

{"sheet":"09","index":14,"n_rows":59,"n_cols":17,"rows_kept":59,"cut":false,"hidden":false,"merged":[[35,4,35,8],[26,4,26,8],[51,2,51,8],[53,2,53,3],[53,6,53,8],[48,4,48,6],[48,7,48,8],[49,2,49,3],[49,5,49,6],[50,2,50,3],[50,4,50,6],[47,4,47,8],[36,4,36,8],[37,4,37,8],[38,4,38,8],[39,4,39,8],[40,4,40,8],[41,4,41,8],[42,4,42,8],[43,4,43,8],[44,4,44,8],[45,4,45,8],[46,6,46,8],[29,4,29,8],[30,4,30,8],[31,4,31,8],[24,4,24,8],[25,4,25,8],[32,4,32,8],[33,4,33,8],[34,4,34,8],[14,2,14,3],[20,4,20,8],[21,4,21,8],[16,4,16,8],[17,4,17,8],[18,4,18,8],[19,4,19,8],[22,4,22,8],[23,4,23,8],[14,4,14,8],[15,4,15,8],[27,4,27,8],[28,4,28,8],[10,6,10,8],[11,6,11,8],[0,7,0,8],[2,1,2,8],[3,1,3,8],[8,6,8,8],[9,6,9,8]]}
[null,null,null,null,null,null,null,{"$f":"'00'!H1:I1","v":"NIVEAU 1"}]
[]
[null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,{"$f":"'Fiche organisateur N°1'!C8","v":"Concours CONTINENTAL"}]
[null,"ORGANISATEUR : ",{"$f":"'Fiche organisateur N°1'!E15","v":0}]
[null,"Lieu : ",{"$f":"'Fiche organisateur N°1'!E16","v":0},null,null,"Date : ",{"$f":"'Fiche organisateur N°1'!E13","v":"00:00:00"}]
[null,"Contact : ",{"$f":"'Fiche organisateur N°1'!E18","v":0}]
[]
[null,"PROPRIETAIRE : ",{"$f":"'Fiche organisateur N°2'!I25","v":""},null,null,"Race & sexe : ",{"$f":"'Fiche organisateur N°2'!E25","v":""}]
[null,"CONDUCTEUR : ",{"$f":"'Fiche organisateur N°2'!J25","v":""},null,null,"N° FAPAC : ",{"$f":"'Fiche organisateur N°2'!F25","v":""}]
[null,"NOM DU CHIEN : ",{"$f":"'Fiche organisateur N°2'!C25","v":""},null,null,"Affixe : ",{"$f":"'Fiche organisateur N°2'!D25","v":""}]
[null,null,null,null,null,"ID : ",{"$f":"'Fiche organisateur N°2'!G25","v":""},null,null,null,"Contrôle de saisie (sur les onglets 01 à 18 ) "]
[]
[null,null,null,null,null,null,null,null,null,null,"Ces colonnes n'apparaissent pas lors de l'impression… "]
[null,"Epreuves                 ","Pointages",null,{"$f":"IF(OR('00'!K47<>17,LEFT('00'!E49,9)=\"ATTENTION\")=1,\"NON VALIDE => corriger la feuille 00 ! ! !\",\"Observations\")","v":"Observations"},null,null,null,null,null,"contrôle-1",null,"contrôle-2"]
[null,{"$f":"IF('00'!B16=\"\",\" -\",'00'!B16)","v":" -"},null,{"$f":"IF('00'!D16=\"\",\"\",'00'!D16)","v":""},null,null,null,null,null,null,{"$f":"IF(B16=\"\",\"\",IF(C16>D16,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B16=\" -\",C16<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B17=\"\",\" -\",'00'!B17)","v":" -"},null,{"$f":"IF('00'!D17=\"\",\"\",'00'!D17)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-1 : Contrôle que les valeurs entrées ne sont pas supérieures "]
[null,{"$f":"IF('00'!B18=\"\",\" -\",'00'!B18)","v":" -"},null,{"$f":"IF('00'!D18=\"\",\"\",'00'!D18)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"                    aux pointages maxi attribués à chaque épreuve…"]
[null,{"$f":"IF('00'!B19=\"\",\" -\",'00'!B19)","v":" -"},null,{"$f":"IF('00'!D19=\"\",\"\",'00'!D19)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B20=\"\",\" -\",'00'!B20)","v":" -"},null,{"$f":"IF('00'!D20=\"\",\"\",'00'!D20)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-2 : Contrôle que les colonnes sans épreuve ne contiennent pas de note"]
[null,{"$f":"IF('00'!B21=\"\",\" -\",'00'!B21)","v":" -"},null,{"$f":"IF('00'!D21=\"\",\"\",'00'!D21)","v":""},null,null,null,null,null,null,{"$f":"IF(B21=\"\",\"\",IF(C21>D21,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B21=\" -\",C21<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B22=\"\",\" -\",'00'!B22)","v":" -"},null,{"$f":"IF('00'!D22=\"\",\"\",'00'!D22)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B23=\"\",\" -\",'00'!B23)","v":" -"},null,{"$f":"IF('00'!D23=\"\",\"\",'00'!D23)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B24=\"\",\" -\",'00'!B24)","v":" -"},null,{"$f":"IF('00'!D24=\"\",\"\",'00'!D24)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B25=\"\",\" -\",'00'!B25)","v":" -"},null,{"$f":"IF('00'!D25=\"\",\"\",'00'!D25)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B26=\"\",\" -\",'00'!B26)","v":" -"},null,{"$f":"IF('00'!D26=\"\",\"\",'00'!D26)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B27=\"\",\" -\",'00'!B27)","v":" -"},null,{"$f":"IF('00'!D27=\"\",\"\",'00'!D27)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B28=\"\",\" -\",'00'!B28)","v":" -"},null,{"$f":"IF('00'!D28=\"\",\"\",'00'!D28)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B29=\"\",\" -\",'00'!B29)","v":" -"},null,{"$f":"IF('00'!D29=\"\",\"\",'00'!D29)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B30=\"\",\" -\",'00'!B30)","v":" -"},null,{"$f":"IF('00'!D30=\"\",\"\",'00'!D30)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B31=\"\",\" -\",'00'!B31)","v":" -"},null,{"$f":"IF('00'!D31=\"\",\"\",'00'!D31)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B32=\"\",\" -\",'00'!B32)","v":" -"},null,{"$f":"IF('00'!D32=\"\",\"\",'00'!D32)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B33=\"\",\" -\",'00'!B33)","v":" -"},null,{"$f":"IF('00'!D33=\"\",\"\",'00'!D33)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B34=\"\",\" -\",'00'!B34)","v":" -"},null,{"$f":"IF('00'!D34=\"\",\"\",'00'!D34)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B35=\"\",\" -\",'00'!B35)","v":" -"},null,{"$f":"IF('00'!D35=\"\",\"\",'00'!D35)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B36=\"\",\" -\",'00'!B36)","v":" -"},null,{"$f":"IF('00'!D36=\"\",\"\",'00'!D36)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B37=\"\",\" -\",'00'!B37)","v":" -"},null,{"$f":"IF('00'!D37=\"\",\"\",'00'!D37)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B38=\"\",\" -\",'00'!B38)","v":" -"},null,{"$f":"IF('00'!D38=\"\",\"\",'00'!D38)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B39=\"\",\" -\",'00'!B39)","v":" -"},null,{"$f":"IF('00'!D39=\"\",\"\",'00'!D39)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B40=\"\",\" -\",'00'!B40)","v":" -"},null,{"$f":"IF('00'!D40=\"\",\"\",'00'!D40)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B41=\"\",\" -\",'00'!B41)","v":" -"},null,{"$f":"IF('00'!D41=\"\",\"\",'00'!D41)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B42=\"\",\" -\",'00'!B42)","v":" -"},null,{"$f":"IF('00'!D42=\"\",\"\",'00'!D42)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B43=\"\",\" -\",'00'!B43)","v":" -"},null,{"$f":"IF('00'!D43=\"\",\"\",'00'!D43)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B44=\"\",\" -\",'00'!B44)","v":"Obéissance"},null,{"$f":"IF('00'!D44=\"\",\"\",'00'!D44)","v":4},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B45=\"\",\" -\",'00'!B45)","v":"Initiative"},null,{"$f":"IF('00'!D45=\"\",\"\",'00'!D45)","v":3},null,null,null,null,null,null,"OK",null,"OK"," "]
[null,{"$f":"IF('00'!B46=\"\",\" -\",'00'!B46)","v":"Douceur"},null,{"$f":"IF('00'!D46=\"\",\"\",'00'!D46)","v":3},null,null,null,null,null,null,"OK",null,"OK"]
[null,"Pointage du Travail  =>   ",{"$f":"SUM(C16:C46)","v":0},{"$f":"SUM(D16:D46)","v":10},null,"Temps : "]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C48>D48,\"! ? !\",\"OK\")","v":"OK"}]
[null,"Pénalités Générales\n(chiffre négatif) ",null,{"$f":"IF(C49>0,\"Erreur\",\"\")","v":""},"Informations sur les pénalités générales : \n   \n   \n   ",null,null,"Classement :",null,null,{"$f":"IF(C49=\"\",\"\",IF(C49>0,\"ATTENTION : les 'Pénalités Générales' doivent être un nombre négatif !\",\"OK\"))","v":""}]
[null,"TOTAL GENERAL = ",{"$f":"IF(COUNT(C16:C46)=0,\"-\",C47+C48+C49)","v":"-"},null,"Qualificatif :",{"$f":"IF(C50=\"-\",\"-\",IF(C50>'00'!D49*0.7999,\"EXCELLENT\",IF(C50>'00'!D49*0.6499,\"TRES BON\",IF(C50>'00'!D49*0.5499,\"BON\",\" - \"))))","v":"-"},null,{"$f":"'Fiche organisateur N°2'!N25","v":"X"},{"$f":"PRESENTS","v":0},null,null,null,null,null,null,null,"CACT OUI"]
[null,{"$f":"IF(AND(NIVEAU<>1,NIVEAU<>2),\"C.A.C.T. et R.C.A.C.T.\",IF(NIVEAU=2,\"BREVET  \",\"\"))","v":""},{"$f":"IF(NIVEAU=1,Q57,IF(NIVEAU=2,Q58,Q59))","v":"-"},null,{"$f":"IF(B51<>\"\",\"<== sur décision du juge\",\"\")","v":""},null,null,null,null,null,"CACT OUI",null,null,null,null,null,"CACT NON"]
[null,{"$f":"IF(AND(NIVEAU=2,F50=\"EXCELLENT\"),\"Observations (zone en gris) :       +   Noter                            PROPOSE POUR LE BREVET CONTINENTAL                         sur le carnet de travail  \",\"Observations :  \")","v":"Observations :  "},null,null,null,null,null,null,null,{"$f":"J47+J49","v":0}]
[]
[null,"N° Cheptel du concours :",{"$f":"'Fiche organisateur N°1'!E17","v":0},null,null,"Le Juge : ",{"$f":"'Fiche organisateur N°1'!E28","v":0},null,null,null,"Qualificatif"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N1","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N2",{"$f":"IF(AND(NIVEAU=2,F50=\"excellent\"),\"OUI\",\"NON\")","v":"NON"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N3",{"$f":"IF(AND(NIVEAU<>1,NIVEAU<>2,H50=1,C47>119.999,K51=\"CACT OUI\"),\"C.A.C.T.\",IF(AND(NIVEAU<>1,NIVEAU<>2,H50=2,C47>119.999,K51=\"CACT OUI\"),\"R.C.A.C.T.\",\"\"))","v":""}]

{"sheet":"10","index":15,"n_rows":59,"n_cols":17,"rows_kept":59,"cut":false,"hidden":false,"merged":[[35,4,35,8],[26,4,26,8],[51,2,51,8],[53,2,53,3],[53,6,53,8],[48,4,48,6],[48,7,48,8],[49,2,49,3],[49,5,49,6],[50,2,50,3],[50,4,50,6],[47,4,47,8],[36,4,36,8],[37,4,37,8],[38,4,38,8],[39,4,39,8],[40,4,40,8],[41,4,41,8],[42,4,42,8],[43,4,43,8],[44,4,44,8],[45,4,45,8],[46,6,46,8],[29,4,29,8],[30,4,30,8],[31,4,31,8],[24,4,24,8],[25,4,25,8],[32,4,32,8],[33,4,33,8],[34,4,34,8],[14,2,14,3],[20,4,20,8],[21,4,21,8],[16,4,16,8],[17,4,17,8],[18,4,18,8],[19,4,19,8],[22,4,22,8],[23,4,23,8],[14,4,14,8],[15,4,15,8],[27,4,27,8],[28,4,28,8],[10,6,10,8],[11,6,11,8],[0,7,0,8],[2,1,2,8],[3,1,3,8],[8,6,8,8],[9,6,9,8]]}
[null,null,null,null,null,null,null,{"$f":"'00'!H1:I1","v":"NIVEAU 1"}]
[]
[null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,{"$f":"'Fiche organisateur N°1'!C8","v":"Concours CONTINENTAL"}]
[null,"ORGANISATEUR : ",{"$f":"'Fiche organisateur N°1'!E15","v":0}]
[null,"Lieu : ",{"$f":"'Fiche organisateur N°1'!E16","v":0},null,null,"Date : ",{"$f":"'Fiche organisateur N°1'!E13","v":"00:00:00"}]
[null,"Contact : ",{"$f":"'Fiche organisateur N°1'!E18","v":0}]
[]
[null,"PROPRIETAIRE : ",{"$f":"'Fiche organisateur N°2'!I26","v":""},null,null,"Race & sexe : ",{"$f":"'Fiche organisateur N°2'!E26","v":""}]
[null,"CONDUCTEUR : ",{"$f":"'Fiche organisateur N°2'!J26","v":""},null,null,"N° FAPAC : ",{"$f":"'Fiche organisateur N°2'!F26","v":""}]
[null,"NOM DU CHIEN : ",{"$f":"'Fiche organisateur N°2'!C26","v":""},null,null,"Affixe : ",{"$f":"'Fiche organisateur N°2'!D26","v":""}]
[null,null,null,null,null,"ID : ",{"$f":"'Fiche organisateur N°2'!G26","v":""},null,null,null,"Contrôle de saisie (sur les onglets 01 à 18 ) "]
[]
[null,null,null,null,null,null,null,null,null,null,"Ces colonnes n'apparaissent pas lors de l'impression… "]
[null,"Epreuves                 ","Pointages",null,{"$f":"IF(OR('00'!K47<>17,LEFT('00'!E49,9)=\"ATTENTION\")=1,\"NON VALIDE => corriger la feuille 00 ! ! !\",\"Observations\")","v":"Observations"},null,null,null,null,null,"contrôle-1",null,"contrôle-2"]
[null,{"$f":"IF('00'!B16=\"\",\" -\",'00'!B16)","v":" -"},null,{"$f":"IF('00'!D16=\"\",\"\",'00'!D16)","v":""},null,null,null,null,null,null,{"$f":"IF(B16=\"\",\"\",IF(C16>D16,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B16=\" -\",C16<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B17=\"\",\" -\",'00'!B17)","v":" -"},null,{"$f":"IF('00'!D17=\"\",\"\",'00'!D17)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-1 : Contrôle que les valeurs entrées ne sont pas supérieures "]
[null,{"$f":"IF('00'!B18=\"\",\" -\",'00'!B18)","v":" -"},null,{"$f":"IF('00'!D18=\"\",\"\",'00'!D18)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"                    aux pointages maxi attribués à chaque épreuve…"]
[null,{"$f":"IF('00'!B19=\"\",\" -\",'00'!B19)","v":" -"},null,{"$f":"IF('00'!D19=\"\",\"\",'00'!D19)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B20=\"\",\" -\",'00'!B20)","v":" -"},null,{"$f":"IF('00'!D20=\"\",\"\",'00'!D20)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-2 : Contrôle que les colonnes sans épreuve ne contiennent pas de note"]
[null,{"$f":"IF('00'!B21=\"\",\" -\",'00'!B21)","v":" -"},null,{"$f":"IF('00'!D21=\"\",\"\",'00'!D21)","v":""},null,null,null,null,null,null,{"$f":"IF(B21=\"\",\"\",IF(C21>D21,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B21=\" -\",C21<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B22=\"\",\" -\",'00'!B22)","v":" -"},null,{"$f":"IF('00'!D22=\"\",\"\",'00'!D22)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B23=\"\",\" -\",'00'!B23)","v":" -"},null,{"$f":"IF('00'!D23=\"\",\"\",'00'!D23)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B24=\"\",\" -\",'00'!B24)","v":" -"},null,{"$f":"IF('00'!D24=\"\",\"\",'00'!D24)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B25=\"\",\" -\",'00'!B25)","v":" -"},null,{"$f":"IF('00'!D25=\"\",\"\",'00'!D25)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B26=\"\",\" -\",'00'!B26)","v":" -"},null,{"$f":"IF('00'!D26=\"\",\"\",'00'!D26)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B27=\"\",\" -\",'00'!B27)","v":" -"},null,{"$f":"IF('00'!D27=\"\",\"\",'00'!D27)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B28=\"\",\" -\",'00'!B28)","v":" -"},null,{"$f":"IF('00'!D28=\"\",\"\",'00'!D28)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B29=\"\",\" -\",'00'!B29)","v":" -"},null,{"$f":"IF('00'!D29=\"\",\"\",'00'!D29)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B30=\"\",\" -\",'00'!B30)","v":" -"},null,{"$f":"IF('00'!D30=\"\",\"\",'00'!D30)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B31=\"\",\" -\",'00'!B31)","v":" -"},null,{"$f":"IF('00'!D31=\"\",\"\",'00'!D31)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B32=\"\",\" -\",'00'!B32)","v":" -"},null,{"$f":"IF('00'!D32=\"\",\"\",'00'!D32)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B33=\"\",\" -\",'00'!B33)","v":" -"},null,{"$f":"IF('00'!D33=\"\",\"\",'00'!D33)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B34=\"\",\" -\",'00'!B34)","v":" -"},null,{"$f":"IF('00'!D34=\"\",\"\",'00'!D34)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B35=\"\",\" -\",'00'!B35)","v":" -"},null,{"$f":"IF('00'!D35=\"\",\"\",'00'!D35)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B36=\"\",\" -\",'00'!B36)","v":" -"},null,{"$f":"IF('00'!D36=\"\",\"\",'00'!D36)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B37=\"\",\" -\",'00'!B37)","v":" -"},null,{"$f":"IF('00'!D37=\"\",\"\",'00'!D37)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B38=\"\",\" -\",'00'!B38)","v":" -"},null,{"$f":"IF('00'!D38=\"\",\"\",'00'!D38)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B39=\"\",\" -\",'00'!B39)","v":" -"},null,{"$f":"IF('00'!D39=\"\",\"\",'00'!D39)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B40=\"\",\" -\",'00'!B40)","v":" -"},null,{"$f":"IF('00'!D40=\"\",\"\",'00'!D40)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B41=\"\",\" -\",'00'!B41)","v":" -"},null,{"$f":"IF('00'!D41=\"\",\"\",'00'!D41)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B42=\"\",\" -\",'00'!B42)","v":" -"},null,{"$f":"IF('00'!D42=\"\",\"\",'00'!D42)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B43=\"\",\" -\",'00'!B43)","v":" -"},null,{"$f":"IF('00'!D43=\"\",\"\",'00'!D43)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B44=\"\",\" -\",'00'!B44)","v":"Obéissance"},null,{"$f":"IF('00'!D44=\"\",\"\",'00'!D44)","v":4},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B45=\"\",\" -\",'00'!B45)","v":"Initiative"},null,{"$f":"IF('00'!D45=\"\",\"\",'00'!D45)","v":3},null,null,null,null,null,null,"OK",null,"OK"," "]
[null,{"$f":"IF('00'!B46=\"\",\" -\",'00'!B46)","v":"Douceur"},null,{"$f":"IF('00'!D46=\"\",\"\",'00'!D46)","v":3},null,null,null,null,null,null,"OK",null,"OK"]
[null,"Pointage du Travail  =>   ",{"$f":"SUM(C16:C46)","v":0},{"$f":"SUM(D16:D46)","v":10},null,"Temps : "]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C48>D48,\"! ? !\",\"OK\")","v":"OK"}]
[null,"Pénalités Générales\n(chiffre négatif) ",null,{"$f":"IF(C49>0,\"Erreur\",\"\")","v":""},"Informations sur les pénalités générales : \n   \n   \n   ",null,null,"Classement :",null,null,{"$f":"IF(C49=\"\",\"\",IF(C49>0,\"ATTENTION : les 'Pénalités Générales' doivent être un nombre négatif !\",\"OK\"))","v":""}]
[null,"TOTAL GENERAL = ",{"$f":"IF(COUNT(C16:C46)=0,\"-\",C47+C48+C49)","v":"-"},null,"Qualificatif :",{"$f":"IF(C50=\"-\",\"-\",IF(C50>'00'!D49*0.7999,\"EXCELLENT\",IF(C50>'00'!D49*0.6499,\"TRES BON\",IF(C50>'00'!D49*0.5499,\"BON\",\" - \"))))","v":"-"},null,{"$f":"'Fiche organisateur N°2'!N26","v":"X"},{"$f":"PRESENTS","v":0},null,null,null,null,null,null,null,"CACT OUI"]
[null,{"$f":"IF(AND(NIVEAU<>1,NIVEAU<>2),\"C.A.C.T. et R.C.A.C.T.\",IF(NIVEAU=2,\"BREVET  \",\"\"))","v":""},{"$f":"IF(NIVEAU=1,Q57,IF(NIVEAU=2,Q58,Q59))","v":"-"},null,{"$f":"IF(B51<>\"\",\"<== sur décision du juge\",\"\")","v":""},null,null,null,null,null,"CACT OUI",null,null,null,null,null,"CACT NON"]
[null,{"$f":"IF(AND(NIVEAU=2,F50=\"EXCELLENT\"),\"Observations (zone en gris) :       +   Noter                            PROPOSE POUR LE BREVET CONTINENTAL                         sur le carnet de travail  \",\"Observations :  \")","v":"Observations :  "},null,null,null,null,null,null,null,{"$f":"J47+J49","v":0}]
[]
[null,"N° Cheptel du concours :",{"$f":"'Fiche organisateur N°1'!E17","v":0},null,null,"Le Juge : ",{"$f":"'Fiche organisateur N°1'!E28","v":0},null,null,null,"Qualificatif"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N1","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N2",{"$f":"IF(AND(NIVEAU=2,F50=\"excellent\"),\"OUI\",\"NON\")","v":"NON"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N3",{"$f":"IF(AND(NIVEAU<>1,NIVEAU<>2,H50=1,C47>119.999,K51=\"CACT OUI\"),\"C.A.C.T.\",IF(AND(NIVEAU<>1,NIVEAU<>2,H50=2,C47>119.999,K51=\"CACT OUI\"),\"R.C.A.C.T.\",\"\"))","v":""}]

{"sheet":"11","index":16,"n_rows":59,"n_cols":17,"rows_kept":59,"cut":false,"hidden":false,"merged":[[35,4,35,8],[26,4,26,8],[51,2,51,8],[53,2,53,3],[53,6,53,8],[48,4,48,6],[48,7,48,8],[49,2,49,3],[49,5,49,6],[50,2,50,3],[50,4,50,6],[47,4,47,8],[36,4,36,8],[37,4,37,8],[38,4,38,8],[39,4,39,8],[40,4,40,8],[41,4,41,8],[42,4,42,8],[43,4,43,8],[44,4,44,8],[45,4,45,8],[46,6,46,8],[29,4,29,8],[30,4,30,8],[31,4,31,8],[24,4,24,8],[25,4,25,8],[32,4,32,8],[33,4,33,8],[34,4,34,8],[14,2,14,3],[20,4,20,8],[21,4,21,8],[16,4,16,8],[17,4,17,8],[18,4,18,8],[19,4,19,8],[22,4,22,8],[23,4,23,8],[14,4,14,8],[15,4,15,8],[27,4,27,8],[28,4,28,8],[10,6,10,8],[11,6,11,8],[0,7,0,8],[2,1,2,8],[3,1,3,8],[8,6,8,8],[9,6,9,8]]}
[null,null,null,null,null,null,null,{"$f":"'00'!H1:I1","v":"NIVEAU 1"}]
[]
[null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,{"$f":"'Fiche organisateur N°1'!C8","v":"Concours CONTINENTAL"}]
[null,"ORGANISATEUR : ",{"$f":"'Fiche organisateur N°1'!E15","v":0}]
[null,"Lieu : ",{"$f":"'Fiche organisateur N°1'!E16","v":0},null,null,"Date : ",{"$f":"'Fiche organisateur N°1'!E13","v":"00:00:00"}]
[null,"Contact : ",{"$f":"'Fiche organisateur N°1'!E18","v":0}]
[]
[null,"PROPRIETAIRE : ",{"$f":"'Fiche organisateur N°2'!I27","v":""},null,null,"Race & sexe : ",{"$f":"'Fiche organisateur N°2'!E27","v":""}]
[null,"CONDUCTEUR : ",{"$f":"'Fiche organisateur N°2'!J27","v":""},null,null,"N° FAPAC : ",{"$f":"'Fiche organisateur N°2'!F27","v":""}]
[null,"NOM DU CHIEN : ",{"$f":"'Fiche organisateur N°2'!C27","v":""},null,null,"Affixe : ",{"$f":"'Fiche organisateur N°2'!D27","v":""}]
[null,null,null,null,null,"ID : ",{"$f":"'Fiche organisateur N°2'!G27","v":""},null,null,null,"Contrôle de saisie (sur les onglets 01 à 18 ) "]
[]
[null,null,null,null,null,null,null,null,null,null,"Ces colonnes n'apparaissent pas lors de l'impression… "]
[null,"Epreuves                 ","Pointages",null,{"$f":"IF(OR('00'!K47<>17,LEFT('00'!E49,9)=\"ATTENTION\")=1,\"NON VALIDE => corriger la feuille 00 ! ! !\",\"Observations\")","v":"Observations"},null,null,null,null,null,"contrôle-1",null,"contrôle-2"]
[null,{"$f":"IF('00'!B16=\"\",\" -\",'00'!B16)","v":" -"},null,{"$f":"IF('00'!D16=\"\",\"\",'00'!D16)","v":""},null,null,null,null,null,null,{"$f":"IF(B16=\"\",\"\",IF(C16>D16,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B16=\" -\",C16<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B17=\"\",\" -\",'00'!B17)","v":" -"},null,{"$f":"IF('00'!D17=\"\",\"\",'00'!D17)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-1 : Contrôle que les valeurs entrées ne sont pas supérieures "]
[null,{"$f":"IF('00'!B18=\"\",\" -\",'00'!B18)","v":" -"},null,{"$f":"IF('00'!D18=\"\",\"\",'00'!D18)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"                    aux pointages maxi attribués à chaque épreuve…"]
[null,{"$f":"IF('00'!B19=\"\",\" -\",'00'!B19)","v":" -"},null,{"$f":"IF('00'!D19=\"\",\"\",'00'!D19)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B20=\"\",\" -\",'00'!B20)","v":" -"},null,{"$f":"IF('00'!D20=\"\",\"\",'00'!D20)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-2 : Contrôle que les colonnes sans épreuve ne contiennent pas de note"]
[null,{"$f":"IF('00'!B21=\"\",\" -\",'00'!B21)","v":" -"},null,{"$f":"IF('00'!D21=\"\",\"\",'00'!D21)","v":""},null,null,null,null,null,null,{"$f":"IF(B21=\"\",\"\",IF(C21>D21,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B21=\" -\",C21<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B22=\"\",\" -\",'00'!B22)","v":" -"},null,{"$f":"IF('00'!D22=\"\",\"\",'00'!D22)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B23=\"\",\" -\",'00'!B23)","v":" -"},null,{"$f":"IF('00'!D23=\"\",\"\",'00'!D23)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B24=\"\",\" -\",'00'!B24)","v":" -"},null,{"$f":"IF('00'!D24=\"\",\"\",'00'!D24)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B25=\"\",\" -\",'00'!B25)","v":" -"},null,{"$f":"IF('00'!D25=\"\",\"\",'00'!D25)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B26=\"\",\" -\",'00'!B26)","v":" -"},null,{"$f":"IF('00'!D26=\"\",\"\",'00'!D26)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B27=\"\",\" -\",'00'!B27)","v":" -"},null,{"$f":"IF('00'!D27=\"\",\"\",'00'!D27)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B28=\"\",\" -\",'00'!B28)","v":" -"},null,{"$f":"IF('00'!D28=\"\",\"\",'00'!D28)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B29=\"\",\" -\",'00'!B29)","v":" -"},null,{"$f":"IF('00'!D29=\"\",\"\",'00'!D29)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B30=\"\",\" -\",'00'!B30)","v":" -"},null,{"$f":"IF('00'!D30=\"\",\"\",'00'!D30)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B31=\"\",\" -\",'00'!B31)","v":" -"},null,{"$f":"IF('00'!D31=\"\",\"\",'00'!D31)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B32=\"\",\" -\",'00'!B32)","v":" -"},null,{"$f":"IF('00'!D32=\"\",\"\",'00'!D32)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B33=\"\",\" -\",'00'!B33)","v":" -"},null,{"$f":"IF('00'!D33=\"\",\"\",'00'!D33)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B34=\"\",\" -\",'00'!B34)","v":" -"},null,{"$f":"IF('00'!D34=\"\",\"\",'00'!D34)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B35=\"\",\" -\",'00'!B35)","v":" -"},null,{"$f":"IF('00'!D35=\"\",\"\",'00'!D35)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B36=\"\",\" -\",'00'!B36)","v":" -"},null,{"$f":"IF('00'!D36=\"\",\"\",'00'!D36)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B37=\"\",\" -\",'00'!B37)","v":" -"},null,{"$f":"IF('00'!D37=\"\",\"\",'00'!D37)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B38=\"\",\" -\",'00'!B38)","v":" -"},null,{"$f":"IF('00'!D38=\"\",\"\",'00'!D38)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B39=\"\",\" -\",'00'!B39)","v":" -"},null,{"$f":"IF('00'!D39=\"\",\"\",'00'!D39)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B40=\"\",\" -\",'00'!B40)","v":" -"},null,{"$f":"IF('00'!D40=\"\",\"\",'00'!D40)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B41=\"\",\" -\",'00'!B41)","v":" -"},null,{"$f":"IF('00'!D41=\"\",\"\",'00'!D41)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B42=\"\",\" -\",'00'!B42)","v":" -"},null,{"$f":"IF('00'!D42=\"\",\"\",'00'!D42)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B43=\"\",\" -\",'00'!B43)","v":" -"},null,{"$f":"IF('00'!D43=\"\",\"\",'00'!D43)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B44=\"\",\" -\",'00'!B44)","v":"Obéissance"},null,{"$f":"IF('00'!D44=\"\",\"\",'00'!D44)","v":4},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B45=\"\",\" -\",'00'!B45)","v":"Initiative"},null,{"$f":"IF('00'!D45=\"\",\"\",'00'!D45)","v":3},null,null,null,null,null,null,"OK",null,"OK"," "]
[null,{"$f":"IF('00'!B46=\"\",\" -\",'00'!B46)","v":"Douceur"},null,{"$f":"IF('00'!D46=\"\",\"\",'00'!D46)","v":3},null,null,null,null,null,null,"OK",null,"OK"]
[null,"Pointage du Travail  =>   ",{"$f":"SUM(C16:C46)","v":0},{"$f":"SUM(D16:D46)","v":10},null,"Temps : "]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C48>D48,\"! ? !\",\"OK\")","v":"OK"}]
[null,"Pénalités Générales\n(chiffre négatif) ",null,{"$f":"IF(C49>0,\"Erreur\",\"\")","v":""},"Informations sur les pénalités générales : \n   \n   \n   ",null,null,"Classement :",null,null,{"$f":"IF(C49=\"\",\"\",IF(C49>0,\"ATTENTION : les 'Pénalités Générales' doivent être un nombre négatif !\",\"OK\"))","v":""}]
[null,"TOTAL GENERAL = ",{"$f":"IF(COUNT(C16:C46)=0,\"-\",C47+C48+C49)","v":"-"},null,"Qualificatif :",{"$f":"IF(C50=\"-\",\"-\",IF(C50>'00'!D49*0.7999,\"EXCELLENT\",IF(C50>'00'!D49*0.6499,\"TRES BON\",IF(C50>'00'!D49*0.5499,\"BON\",\" - \"))))","v":"-"},null,{"$f":"'Fiche organisateur N°2'!N27","v":"X"},{"$f":"PRESENTS","v":0},null,null,null,null,null,null,null,"CACT OUI"]
[null,{"$f":"IF(AND(NIVEAU<>1,NIVEAU<>2),\"C.A.C.T. et R.C.A.C.T.\",IF(NIVEAU=2,\"BREVET  \",\"\"))","v":""},{"$f":"IF(NIVEAU=1,Q57,IF(NIVEAU=2,Q58,Q59))","v":"-"},null,{"$f":"IF(B51<>\"\",\"<== sur décision du juge\",\"\")","v":""},null,null,null,null,null,"CACT OUI",null,null,null,null,null,"CACT NON"]
[null,{"$f":"IF(AND(NIVEAU=2,F50=\"EXCELLENT\"),\"Observations (zone en gris) :       +   Noter                            PROPOSE POUR LE BREVET CONTINENTAL                         sur le carnet de travail  \",\"Observations :  \")","v":"Observations :  "},null,null,null,null,null,null,null,{"$f":"J47+J49","v":0}]
[]
[null,"N° Cheptel du concours :",{"$f":"'Fiche organisateur N°1'!E17","v":0},null,null,"Le Juge : ",{"$f":"'Fiche organisateur N°1'!E28","v":0},null,null,null,"Qualificatif"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N1","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N2",{"$f":"IF(AND(NIVEAU=2,F50=\"excellent\"),\"OUI\",\"NON\")","v":"NON"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N3",{"$f":"IF(AND(NIVEAU<>1,NIVEAU<>2,H50=1,C47>119.999,K51=\"CACT OUI\"),\"C.A.C.T.\",IF(AND(NIVEAU<>1,NIVEAU<>2,H50=2,C47>119.999,K51=\"CACT OUI\"),\"R.C.A.C.T.\",\"\"))","v":""}]

{"sheet":"12","index":17,"n_rows":59,"n_cols":17,"rows_kept":59,"cut":false,"hidden":false,"merged":[[35,4,35,8],[26,4,26,8],[51,2,51,8],[53,2,53,3],[53,6,53,8],[48,4,48,6],[48,7,48,8],[49,2,49,3],[49,5,49,6],[50,2,50,3],[50,4,50,6],[47,4,47,8],[36,4,36,8],[37,4,37,8],[38,4,38,8],[39,4,39,8],[40,4,40,8],[41,4,41,8],[42,4,42,8],[43,4,43,8],[44,4,44,8],[45,4,45,8],[46,6,46,8],[29,4,29,8],[30,4,30,8],[31,4,31,8],[24,4,24,8],[25,4,25,8],[32,4,32,8],[33,4,33,8],[34,4,34,8],[14,2,14,3],[20,4,20,8],[21,4,21,8],[16,4,16,8],[17,4,17,8],[18,4,18,8],[19,4,19,8],[22,4,22,8],[23,4,23,8],[14,4,14,8],[15,4,15,8],[27,4,27,8],[28,4,28,8],[10,6,10,8],[11,6,11,8],[0,7,0,8],[2,1,2,8],[3,1,3,8],[8,6,8,8],[9,6,9,8]]}
[null,null,null,null,null,null,null,{"$f":"'00'!H1:I1","v":"NIVEAU 1"}]
[]
[null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,{"$f":"'Fiche organisateur N°1'!C8","v":"Concours CONTINENTAL"}]
[null,"ORGANISATEUR : ",{"$f":"'Fiche organisateur N°1'!E15","v":0}]
[null,"Lieu : ",{"$f":"'Fiche organisateur N°1'!E16","v":0},null,null,"Date : ",{"$f":"'Fiche organisateur N°1'!E13","v":"00:00:00"}]
[null,"Contact : ",{"$f":"'Fiche organisateur N°1'!E18","v":0}]
[]
[null,"PROPRIETAIRE : ",{"$f":"'Fiche organisateur N°2'!I28","v":""},null,null,"Race & sexe : ",{"$f":"'Fiche organisateur N°2'!E28","v":""}]
[null,"CONDUCTEUR : ",{"$f":"'Fiche organisateur N°2'!J28","v":""},null,null,"N° FAPAC : ",{"$f":"'Fiche organisateur N°2'!F28","v":""}]
[null,"NOM DU CHIEN : ",{"$f":"'Fiche organisateur N°2'!C28","v":""},null,null,"Affixe : ",{"$f":"'Fiche organisateur N°2'!D28","v":""}]
[null,null,null,null,null,"ID : ",{"$f":"'Fiche organisateur N°2'!G28","v":""},null,null,null,"Contrôle de saisie (sur les onglets 01 à 18 ) "]
[]
[null,null,null,null,null,null,null,null,null,null,"Ces colonnes n'apparaissent pas lors de l'impression… "]
[null,"Epreuves                 ","Pointages",null,{"$f":"IF(OR('00'!K47<>17,LEFT('00'!E49,9)=\"ATTENTION\")=1,\"NON VALIDE => corriger la feuille 00 ! ! !\",\"Observations\")","v":"Observations"},null,null,null,null,null,"contrôle-1",null,"contrôle-2"]
[null,{"$f":"IF('00'!B16=\"\",\" -\",'00'!B16)","v":" -"},null,{"$f":"IF('00'!D16=\"\",\"\",'00'!D16)","v":""},null,null,null,null,null,null,{"$f":"IF(B16=\"\",\"\",IF(C16>D16,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B16=\" -\",C16<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B17=\"\",\" -\",'00'!B17)","v":" -"},null,{"$f":"IF('00'!D17=\"\",\"\",'00'!D17)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-1 : Contrôle que les valeurs entrées ne sont pas supérieures "]
[null,{"$f":"IF('00'!B18=\"\",\" -\",'00'!B18)","v":" -"},null,{"$f":"IF('00'!D18=\"\",\"\",'00'!D18)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"                    aux pointages maxi attribués à chaque épreuve…"]
[null,{"$f":"IF('00'!B19=\"\",\" -\",'00'!B19)","v":" -"},null,{"$f":"IF('00'!D19=\"\",\"\",'00'!D19)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B20=\"\",\" -\",'00'!B20)","v":" -"},null,{"$f":"IF('00'!D20=\"\",\"\",'00'!D20)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-2 : Contrôle que les colonnes sans épreuve ne contiennent pas de note"]
[null,{"$f":"IF('00'!B21=\"\",\" -\",'00'!B21)","v":" -"},null,{"$f":"IF('00'!D21=\"\",\"\",'00'!D21)","v":""},null,null,null,null,null,null,{"$f":"IF(B21=\"\",\"\",IF(C21>D21,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B21=\" -\",C21<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B22=\"\",\" -\",'00'!B22)","v":" -"},null,{"$f":"IF('00'!D22=\"\",\"\",'00'!D22)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B23=\"\",\" -\",'00'!B23)","v":" -"},null,{"$f":"IF('00'!D23=\"\",\"\",'00'!D23)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B24=\"\",\" -\",'00'!B24)","v":" -"},null,{"$f":"IF('00'!D24=\"\",\"\",'00'!D24)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B25=\"\",\" -\",'00'!B25)","v":" -"},null,{"$f":"IF('00'!D25=\"\",\"\",'00'!D25)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B26=\"\",\" -\",'00'!B26)","v":" -"},null,{"$f":"IF('00'!D26=\"\",\"\",'00'!D26)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B27=\"\",\" -\",'00'!B27)","v":" -"},null,{"$f":"IF('00'!D27=\"\",\"\",'00'!D27)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B28=\"\",\" -\",'00'!B28)","v":" -"},null,{"$f":"IF('00'!D28=\"\",\"\",'00'!D28)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B29=\"\",\" -\",'00'!B29)","v":" -"},null,{"$f":"IF('00'!D29=\"\",\"\",'00'!D29)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B30=\"\",\" -\",'00'!B30)","v":" -"},null,{"$f":"IF('00'!D30=\"\",\"\",'00'!D30)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B31=\"\",\" -\",'00'!B31)","v":" -"},null,{"$f":"IF('00'!D31=\"\",\"\",'00'!D31)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B32=\"\",\" -\",'00'!B32)","v":" -"},null,{"$f":"IF('00'!D32=\"\",\"\",'00'!D32)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B33=\"\",\" -\",'00'!B33)","v":" -"},null,{"$f":"IF('00'!D33=\"\",\"\",'00'!D33)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B34=\"\",\" -\",'00'!B34)","v":" -"},null,{"$f":"IF('00'!D34=\"\",\"\",'00'!D34)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B35=\"\",\" -\",'00'!B35)","v":" -"},null,{"$f":"IF('00'!D35=\"\",\"\",'00'!D35)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B36=\"\",\" -\",'00'!B36)","v":" -"},null,{"$f":"IF('00'!D36=\"\",\"\",'00'!D36)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B37=\"\",\" -\",'00'!B37)","v":" -"},null,{"$f":"IF('00'!D37=\"\",\"\",'00'!D37)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B38=\"\",\" -\",'00'!B38)","v":" -"},null,{"$f":"IF('00'!D38=\"\",\"\",'00'!D38)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B39=\"\",\" -\",'00'!B39)","v":" -"},null,{"$f":"IF('00'!D39=\"\",\"\",'00'!D39)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B40=\"\",\" -\",'00'!B40)","v":" -"},null,{"$f":"IF('00'!D40=\"\",\"\",'00'!D40)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B41=\"\",\" -\",'00'!B41)","v":" -"},null,{"$f":"IF('00'!D41=\"\",\"\",'00'!D41)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B42=\"\",\" -\",'00'!B42)","v":" -"},null,{"$f":"IF('00'!D42=\"\",\"\",'00'!D42)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B43=\"\",\" -\",'00'!B43)","v":" -"},null,{"$f":"IF('00'!D43=\"\",\"\",'00'!D43)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B44=\"\",\" -\",'00'!B44)","v":"Obéissance"},null,{"$f":"IF('00'!D44=\"\",\"\",'00'!D44)","v":4},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B45=\"\",\" -\",'00'!B45)","v":"Initiative"},null,{"$f":"IF('00'!D45=\"\",\"\",'00'!D45)","v":3},null,null,null,null,null,null,"OK",null,"OK"," "]
[null,{"$f":"IF('00'!B46=\"\",\" -\",'00'!B46)","v":"Douceur"},null,{"$f":"IF('00'!D46=\"\",\"\",'00'!D46)","v":3},null,null,null,null,null,null,"OK",null,"OK"]
[null,"Pointage du Travail  =>   ",{"$f":"SUM(C16:C46)","v":0},{"$f":"SUM(D16:D46)","v":10},null,"Temps : "]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C48>D48,\"! ? !\",\"OK\")","v":"OK"}]
[null,"Pénalités Générales\n(chiffre négatif) ",null,{"$f":"IF(C49>0,\"Erreur\",\"\")","v":""},"Informations sur les pénalités générales : \n   \n   \n   ",null,null,"Classement :",null,null,{"$f":"IF(C49=\"\",\"\",IF(C49>0,\"ATTENTION : les 'Pénalités Générales' doivent être un nombre négatif !\",\"OK\"))","v":""}]
[null,"TOTAL GENERAL = ",{"$f":"IF(COUNT(C16:C46)=0,\"-\",C47+C48+C49)","v":"-"},null,"Qualificatif :",{"$f":"IF(C50=\"-\",\"-\",IF(C50>'00'!D49*0.7999,\"EXCELLENT\",IF(C50>'00'!D49*0.6499,\"TRES BON\",IF(C50>'00'!D49*0.5499,\"BON\",\" - \"))))","v":"-"},null,{"$f":"'Fiche organisateur N°2'!N28","v":"X"},{"$f":"PRESENTS","v":0},null,null,null,null,null,null,null,"CACT OUI"]
[null,{"$f":"IF(AND(NIVEAU<>1,NIVEAU<>2),\"C.A.C.T. et R.C.A.C.T.\",IF(NIVEAU=2,\"BREVET  \",\"\"))","v":""},{"$f":"IF(NIVEAU=1,Q57,IF(NIVEAU=2,Q58,Q59))","v":"-"},null,{"$f":"IF(B51<>\"\",\"<== sur décision du juge\",\"\")","v":""},null,null,null,null,null,"CACT OUI",null,null,null,null,null,"CACT NON"]
[null,{"$f":"IF(AND(NIVEAU=2,F50=\"EXCELLENT\"),\"Observations (zone en gris) :       +   Noter                            PROPOSE POUR LE BREVET CONTINENTAL                         sur le carnet de travail  \",\"Observations :  \")","v":"Observations :  "},null,null,null,null,null,null,null,{"$f":"J47+J49","v":0}]
[]
[null,"N° Cheptel du concours :",{"$f":"'Fiche organisateur N°1'!E17","v":0},null,null,"Le Juge : ",{"$f":"'Fiche organisateur N°1'!E28","v":0},null,null,null,"Qualificatif"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N1","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N2",{"$f":"IF(AND(NIVEAU=2,F50=\"excellent\"),\"OUI\",\"NON\")","v":"NON"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N3",{"$f":"IF(AND(NIVEAU<>1,NIVEAU<>2,H50=1,C47>119.999,K51=\"CACT OUI\"),\"C.A.C.T.\",IF(AND(NIVEAU<>1,NIVEAU<>2,H50=2,C47>119.999,K51=\"CACT OUI\"),\"R.C.A.C.T.\",\"\"))","v":""}]

{"sheet":"13","index":18,"n_rows":59,"n_cols":17,"rows_kept":59,"cut":false,"hidden":false,"merged":[[35,4,35,8],[26,4,26,8],[51,2,51,8],[53,2,53,3],[53,6,53,8],[48,4,48,6],[48,7,48,8],[49,2,49,3],[49,5,49,6],[50,2,50,3],[50,4,50,6],[47,4,47,8],[36,4,36,8],[37,4,37,8],[38,4,38,8],[39,4,39,8],[40,4,40,8],[41,4,41,8],[42,4,42,8],[43,4,43,8],[44,4,44,8],[45,4,45,8],[46,6,46,8],[29,4,29,8],[30,4,30,8],[31,4,31,8],[24,4,24,8],[25,4,25,8],[32,4,32,8],[33,4,33,8],[34,4,34,8],[14,2,14,3],[20,4,20,8],[21,4,21,8],[16,4,16,8],[17,4,17,8],[18,4,18,8],[19,4,19,8],[22,4,22,8],[23,4,23,8],[14,4,14,8],[15,4,15,8],[27,4,27,8],[28,4,28,8],[10,6,10,8],[11,6,11,8],[0,7,0,8],[2,1,2,8],[3,1,3,8],[8,6,8,8],[9,6,9,8]]}
[null,null,null,null,null,null,null,{"$f":"'00'!H1:I1","v":"NIVEAU 1"}]
[]
[null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,{"$f":"'Fiche organisateur N°1'!C8","v":"Concours CONTINENTAL"}]
[null,"ORGANISATEUR : ",{"$f":"'Fiche organisateur N°1'!E15","v":0}]
[null,"Lieu : ",{"$f":"'Fiche organisateur N°1'!E16","v":0},null,null,"Date : ",{"$f":"'Fiche organisateur N°1'!E13","v":"00:00:00"}]
[null,"Contact : ",{"$f":"'Fiche organisateur N°1'!E18","v":0}]
[]
[null,"PROPRIETAIRE : ",{"$f":"'Fiche organisateur N°2'!I29","v":""},null,null,"Race & sexe : ",{"$f":"'Fiche organisateur N°2'!E29","v":""}]
[null,"CONDUCTEUR : ",{"$f":"'Fiche organisateur N°2'!J29","v":""},null,null,"N° FAPAC : ",{"$f":"'Fiche organisateur N°2'!F29","v":""}]
[null,"NOM DU CHIEN : ",{"$f":"'Fiche organisateur N°2'!C29","v":""},null,null,"Affixe : ",{"$f":"'Fiche organisateur N°2'!D29","v":""}]
[null,null,null,null,null,"ID : ",{"$f":"'Fiche organisateur N°2'!G29","v":""},null,null,null,"Contrôle de saisie (sur les onglets 01 à 18 ) "]
[]
[null,null,null,null,null,null,null,null,null,null,"Ces colonnes n'apparaissent pas lors de l'impression… "]
[null,"Epreuves                 ","Pointages",null,{"$f":"IF(OR('00'!K47<>17,LEFT('00'!E49,9)=\"ATTENTION\")=1,\"NON VALIDE => corriger la feuille 00 ! ! !\",\"Observations\")","v":"Observations"},null,null,null,null,null,"contrôle-1",null,"contrôle-2"]
[null,{"$f":"IF('00'!B16=\"\",\" -\",'00'!B16)","v":" -"},null,{"$f":"IF('00'!D16=\"\",\"\",'00'!D16)","v":""},null,null,null,null,null,null,{"$f":"IF(B16=\"\",\"\",IF(C16>D16,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B16=\" -\",C16<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B17=\"\",\" -\",'00'!B17)","v":" -"},null,{"$f":"IF('00'!D17=\"\",\"\",'00'!D17)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-1 : Contrôle que les valeurs entrées ne sont pas supérieures "]
[null,{"$f":"IF('00'!B18=\"\",\" -\",'00'!B18)","v":" -"},null,{"$f":"IF('00'!D18=\"\",\"\",'00'!D18)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"                    aux pointages maxi attribués à chaque épreuve…"]
[null,{"$f":"IF('00'!B19=\"\",\" -\",'00'!B19)","v":" -"},null,{"$f":"IF('00'!D19=\"\",\"\",'00'!D19)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B20=\"\",\" -\",'00'!B20)","v":" -"},null,{"$f":"IF('00'!D20=\"\",\"\",'00'!D20)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-2 : Contrôle que les colonnes sans épreuve ne contiennent pas de note"]
[null,{"$f":"IF('00'!B21=\"\",\" -\",'00'!B21)","v":" -"},null,{"$f":"IF('00'!D21=\"\",\"\",'00'!D21)","v":""},null,null,null,null,null,null,{"$f":"IF(B21=\"\",\"\",IF(C21>D21,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B21=\" -\",C21<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B22=\"\",\" -\",'00'!B22)","v":" -"},null,{"$f":"IF('00'!D22=\"\",\"\",'00'!D22)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B23=\"\",\" -\",'00'!B23)","v":" -"},null,{"$f":"IF('00'!D23=\"\",\"\",'00'!D23)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B24=\"\",\" -\",'00'!B24)","v":" -"},null,{"$f":"IF('00'!D24=\"\",\"\",'00'!D24)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B25=\"\",\" -\",'00'!B25)","v":" -"},null,{"$f":"IF('00'!D25=\"\",\"\",'00'!D25)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B26=\"\",\" -\",'00'!B26)","v":" -"},null,{"$f":"IF('00'!D26=\"\",\"\",'00'!D26)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B27=\"\",\" -\",'00'!B27)","v":" -"},null,{"$f":"IF('00'!D27=\"\",\"\",'00'!D27)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B28=\"\",\" -\",'00'!B28)","v":" -"},null,{"$f":"IF('00'!D28=\"\",\"\",'00'!D28)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B29=\"\",\" -\",'00'!B29)","v":" -"},null,{"$f":"IF('00'!D29=\"\",\"\",'00'!D29)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B30=\"\",\" -\",'00'!B30)","v":" -"},null,{"$f":"IF('00'!D30=\"\",\"\",'00'!D30)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B31=\"\",\" -\",'00'!B31)","v":" -"},null,{"$f":"IF('00'!D31=\"\",\"\",'00'!D31)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B32=\"\",\" -\",'00'!B32)","v":" -"},null,{"$f":"IF('00'!D32=\"\",\"\",'00'!D32)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B33=\"\",\" -\",'00'!B33)","v":" -"},null,{"$f":"IF('00'!D33=\"\",\"\",'00'!D33)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B34=\"\",\" -\",'00'!B34)","v":" -"},null,{"$f":"IF('00'!D34=\"\",\"\",'00'!D34)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B35=\"\",\" -\",'00'!B35)","v":" -"},null,{"$f":"IF('00'!D35=\"\",\"\",'00'!D35)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B36=\"\",\" -\",'00'!B36)","v":" -"},null,{"$f":"IF('00'!D36=\"\",\"\",'00'!D36)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B37=\"\",\" -\",'00'!B37)","v":" -"},null,{"$f":"IF('00'!D37=\"\",\"\",'00'!D37)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B38=\"\",\" -\",'00'!B38)","v":" -"},null,{"$f":"IF('00'!D38=\"\",\"\",'00'!D38)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B39=\"\",\" -\",'00'!B39)","v":" -"},null,{"$f":"IF('00'!D39=\"\",\"\",'00'!D39)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B40=\"\",\" -\",'00'!B40)","v":" -"},null,{"$f":"IF('00'!D40=\"\",\"\",'00'!D40)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B41=\"\",\" -\",'00'!B41)","v":" -"},null,{"$f":"IF('00'!D41=\"\",\"\",'00'!D41)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B42=\"\",\" -\",'00'!B42)","v":" -"},null,{"$f":"IF('00'!D42=\"\",\"\",'00'!D42)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B43=\"\",\" -\",'00'!B43)","v":" -"},null,{"$f":"IF('00'!D43=\"\",\"\",'00'!D43)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B44=\"\",\" -\",'00'!B44)","v":"Obéissance"},null,{"$f":"IF('00'!D44=\"\",\"\",'00'!D44)","v":4},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B45=\"\",\" -\",'00'!B45)","v":"Initiative"},null,{"$f":"IF('00'!D45=\"\",\"\",'00'!D45)","v":3},null,null,null,null,null,null,"OK",null,"OK"," "]
[null,{"$f":"IF('00'!B46=\"\",\" -\",'00'!B46)","v":"Douceur"},null,{"$f":"IF('00'!D46=\"\",\"\",'00'!D46)","v":3},null,null,null,null,null,null,"OK",null,"OK"]
[null,"Pointage du Travail  =>   ",{"$f":"SUM(C16:C46)","v":0},{"$f":"SUM(D16:D46)","v":10},null,"Temps : "]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C48>D48,\"! ? !\",\"OK\")","v":"OK"}]
[null,"Pénalités Générales\n(chiffre négatif) ",null,{"$f":"IF(C49>0,\"Erreur\",\"\")","v":""},"Informations sur les pénalités générales : \n   \n   \n   ",null,null,"Classement :",null,null,{"$f":"IF(C49=\"\",\"\",IF(C49>0,\"ATTENTION : les 'Pénalités Générales' doivent être un nombre négatif !\",\"OK\"))","v":""}]
[null,"TOTAL GENERAL = ",{"$f":"IF(COUNT(C16:C46)=0,\"-\",C47+C48+C49)","v":"-"},null,"Qualificatif :",{"$f":"IF(C50=\"-\",\"-\",IF(C50>'00'!D49*0.7999,\"EXCELLENT\",IF(C50>'00'!D49*0.6499,\"TRES BON\",IF(C50>'00'!D49*0.5499,\"BON\",\" - \"))))","v":"-"},null,{"$f":"'Fiche organisateur N°2'!N29","v":"X"},{"$f":"PRESENTS","v":0},null,null,null,null,null,null,null,"CACT OUI"]
[null,{"$f":"IF(AND(NIVEAU<>1,NIVEAU<>2),\"C.A.C.T. et R.C.A.C.T.\",IF(NIVEAU=2,\"BREVET  \",\"\"))","v":""},{"$f":"IF(NIVEAU=1,Q57,IF(NIVEAU=2,Q58,Q59))","v":"-"},null,{"$f":"IF(B51<>\"\",\"<== sur décision du juge\",\"\")","v":""},null,null,null,null,null,"CACT OUI",null,null,null,null,null,"CACT NON"]
[null,{"$f":"IF(AND(NIVEAU=2,F50=\"EXCELLENT\"),\"Observations (zone en gris) :       +   Noter                            PROPOSE POUR LE BREVET CONTINENTAL                         sur le carnet de travail  \",\"Observations :  \")","v":"Observations :  "},null,null,null,null,null,null,null,{"$f":"J47+J49","v":0}]
[]
[null,"N° Cheptel du concours :",{"$f":"'Fiche organisateur N°1'!E17","v":0},null,null,"Le Juge : ",{"$f":"'Fiche organisateur N°1'!E28","v":0},null,null,null,"Qualificatif"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N1","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N2",{"$f":"IF(AND(NIVEAU=2,F50=\"excellent\"),\"OUI\",\"NON\")","v":"NON"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N3",{"$f":"IF(AND(NIVEAU<>1,NIVEAU<>2,H50=1,C47>119.999,K51=\"CACT OUI\"),\"C.A.C.T.\",IF(AND(NIVEAU<>1,NIVEAU<>2,H50=2,C47>119.999,K51=\"CACT OUI\"),\"R.C.A.C.T.\",\"\"))","v":""}]

{"sheet":"14","index":19,"n_rows":59,"n_cols":17,"rows_kept":59,"cut":false,"hidden":false,"merged":[[35,4,35,8],[26,4,26,8],[51,2,51,8],[53,2,53,3],[53,6,53,8],[48,4,48,6],[48,7,48,8],[49,2,49,3],[49,5,49,6],[50,2,50,3],[50,4,50,6],[47,4,47,8],[36,4,36,8],[37,4,37,8],[38,4,38,8],[39,4,39,8],[40,4,40,8],[41,4,41,8],[42,4,42,8],[43,4,43,8],[44,4,44,8],[45,4,45,8],[46,6,46,8],[29,4,29,8],[30,4,30,8],[31,4,31,8],[24,4,24,8],[25,4,25,8],[32,4,32,8],[33,4,33,8],[34,4,34,8],[14,2,14,3],[20,4,20,8],[21,4,21,8],[16,4,16,8],[17,4,17,8],[18,4,18,8],[19,4,19,8],[22,4,22,8],[23,4,23,8],[14,4,14,8],[15,4,15,8],[27,4,27,8],[28,4,28,8],[10,6,10,8],[11,6,11,8],[0,7,0,8],[2,1,2,8],[3,1,3,8],[8,6,8,8],[9,6,9,8]]}
[null,null,null,null,null,null,null,{"$f":"'00'!H1:I1","v":"NIVEAU 1"}]
[]
[null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,{"$f":"'Fiche organisateur N°1'!C8","v":"Concours CONTINENTAL"}]
[null,"ORGANISATEUR : ",{"$f":"'Fiche organisateur N°1'!E15","v":0}]
[null,"Lieu : ",{"$f":"'Fiche organisateur N°1'!E16","v":0},null,null,"Date : ",{"$f":"'Fiche organisateur N°1'!E13","v":"00:00:00"}]
[null,"Contact : ",{"$f":"'Fiche organisateur N°1'!E18","v":0}]
[]
[null,"PROPRIETAIRE : ",{"$f":"'Fiche organisateur N°2'!I30","v":""},null,null,"Race & sexe : ",{"$f":"'Fiche organisateur N°2'!E30","v":""}]
[null,"CONDUCTEUR : ",{"$f":"'Fiche organisateur N°2'!J30","v":""},null,null,"N° FAPAC : ",{"$f":"'Fiche organisateur N°2'!F30","v":""}]
[null,"NOM DU CHIEN : ",{"$f":"'Fiche organisateur N°2'!C30","v":""},null,null,"Affixe : ",{"$f":"'Fiche organisateur N°2'!D30","v":""}]
[null,null,null,null,null,"ID : ",{"$f":"'Fiche organisateur N°2'!G30","v":""},null,null,null,"Contrôle de saisie (sur les onglets 01 à 18 ) "]
[]
[null,null,null,null,null,null,null,null,null,null,"Ces colonnes n'apparaissent pas lors de l'impression… "]
[null,"Epreuves                 ","Pointages",null,{"$f":"IF(OR('00'!K47<>17,LEFT('00'!E49,9)=\"ATTENTION\")=1,\"NON VALIDE => corriger la feuille 00 ! ! !\",\"Observations\")","v":"Observations"},null,null,null,null,null,"contrôle-1",null,"contrôle-2"]
[null,{"$f":"IF('00'!B16=\"\",\" -\",'00'!B16)","v":" -"},null,{"$f":"IF('00'!D16=\"\",\"\",'00'!D16)","v":""},null,null,null,null,null,null,{"$f":"IF(B16=\"\",\"\",IF(C16>D16,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B16=\" -\",C16<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B17=\"\",\" -\",'00'!B17)","v":" -"},null,{"$f":"IF('00'!D17=\"\",\"\",'00'!D17)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-1 : Contrôle que les valeurs entrées ne sont pas supérieures "]
[null,{"$f":"IF('00'!B18=\"\",\" -\",'00'!B18)","v":" -"},null,{"$f":"IF('00'!D18=\"\",\"\",'00'!D18)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"                    aux pointages maxi attribués à chaque épreuve…"]
[null,{"$f":"IF('00'!B19=\"\",\" -\",'00'!B19)","v":" -"},null,{"$f":"IF('00'!D19=\"\",\"\",'00'!D19)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B20=\"\",\" -\",'00'!B20)","v":" -"},null,{"$f":"IF('00'!D20=\"\",\"\",'00'!D20)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-2 : Contrôle que les colonnes sans épreuve ne contiennent pas de note"]
[null,{"$f":"IF('00'!B21=\"\",\" -\",'00'!B21)","v":" -"},null,{"$f":"IF('00'!D21=\"\",\"\",'00'!D21)","v":""},null,null,null,null,null,null,{"$f":"IF(B21=\"\",\"\",IF(C21>D21,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B21=\" -\",C21<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B22=\"\",\" -\",'00'!B22)","v":" -"},null,{"$f":"IF('00'!D22=\"\",\"\",'00'!D22)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B23=\"\",\" -\",'00'!B23)","v":" -"},null,{"$f":"IF('00'!D23=\"\",\"\",'00'!D23)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B24=\"\",\" -\",'00'!B24)","v":" -"},null,{"$f":"IF('00'!D24=\"\",\"\",'00'!D24)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B25=\"\",\" -\",'00'!B25)","v":" -"},null,{"$f":"IF('00'!D25=\"\",\"\",'00'!D25)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B26=\"\",\" -\",'00'!B26)","v":" -"},null,{"$f":"IF('00'!D26=\"\",\"\",'00'!D26)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B27=\"\",\" -\",'00'!B27)","v":" -"},null,{"$f":"IF('00'!D27=\"\",\"\",'00'!D27)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B28=\"\",\" -\",'00'!B28)","v":" -"},null,{"$f":"IF('00'!D28=\"\",\"\",'00'!D28)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B29=\"\",\" -\",'00'!B29)","v":" -"},null,{"$f":"IF('00'!D29=\"\",\"\",'00'!D29)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B30=\"\",\" -\",'00'!B30)","v":" -"},null,{"$f":"IF('00'!D30=\"\",\"\",'00'!D30)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B31=\"\",\" -\",'00'!B31)","v":" -"},null,{"$f":"IF('00'!D31=\"\",\"\",'00'!D31)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B32=\"\",\" -\",'00'!B32)","v":" -"},null,{"$f":"IF('00'!D32=\"\",\"\",'00'!D32)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B33=\"\",\" -\",'00'!B33)","v":" -"},null,{"$f":"IF('00'!D33=\"\",\"\",'00'!D33)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B34=\"\",\" -\",'00'!B34)","v":" -"},null,{"$f":"IF('00'!D34=\"\",\"\",'00'!D34)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B35=\"\",\" -\",'00'!B35)","v":" -"},null,{"$f":"IF('00'!D35=\"\",\"\",'00'!D35)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B36=\"\",\" -\",'00'!B36)","v":" -"},null,{"$f":"IF('00'!D36=\"\",\"\",'00'!D36)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B37=\"\",\" -\",'00'!B37)","v":" -"},null,{"$f":"IF('00'!D37=\"\",\"\",'00'!D37)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B38=\"\",\" -\",'00'!B38)","v":" -"},null,{"$f":"IF('00'!D38=\"\",\"\",'00'!D38)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B39=\"\",\" -\",'00'!B39)","v":" -"},null,{"$f":"IF('00'!D39=\"\",\"\",'00'!D39)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B40=\"\",\" -\",'00'!B40)","v":" -"},null,{"$f":"IF('00'!D40=\"\",\"\",'00'!D40)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B41=\"\",\" -\",'00'!B41)","v":" -"},null,{"$f":"IF('00'!D41=\"\",\"\",'00'!D41)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B42=\"\",\" -\",'00'!B42)","v":" -"},null,{"$f":"IF('00'!D42=\"\",\"\",'00'!D42)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B43=\"\",\" -\",'00'!B43)","v":" -"},null,{"$f":"IF('00'!D43=\"\",\"\",'00'!D43)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B44=\"\",\" -\",'00'!B44)","v":"Obéissance"},null,{"$f":"IF('00'!D44=\"\",\"\",'00'!D44)","v":4},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B45=\"\",\" -\",'00'!B45)","v":"Initiative"},null,{"$f":"IF('00'!D45=\"\",\"\",'00'!D45)","v":3},null,null,null,null,null,null,"OK",null,"OK"," "]
[null,{"$f":"IF('00'!B46=\"\",\" -\",'00'!B46)","v":"Douceur"},null,{"$f":"IF('00'!D46=\"\",\"\",'00'!D46)","v":3},null,null,null,null,null,null,"OK",null,"OK"]
[null,"Pointage du Travail  =>   ",{"$f":"SUM(C16:C46)","v":0},{"$f":"SUM(D16:D46)","v":10},null,"Temps : "]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C48>D48,\"! ? !\",\"OK\")","v":"OK"}]
[null,"Pénalités Générales\n(chiffre négatif) ",null,{"$f":"IF(C49>0,\"Erreur\",\"\")","v":""},"Informations sur les pénalités générales : \n   \n   \n   ",null,null,"Classement :",null,null,{"$f":"IF(C49=\"\",\"\",IF(C49>0,\"ATTENTION : les 'Pénalités Générales' doivent être un nombre négatif !\",\"OK\"))","v":""}]
[null,"TOTAL GENERAL = ",{"$f":"IF(COUNT(C16:C46)=0,\"-\",C47+C48+C49)","v":"-"},null,"Qualificatif :",{"$f":"IF(C50=\"-\",\"-\",IF(C50>'00'!D49*0.7999,\"EXCELLENT\",IF(C50>'00'!D49*0.6499,\"TRES BON\",IF(C50>'00'!D49*0.5499,\"BON\",\" - \"))))","v":"-"},null,{"$f":"'Fiche organisateur N°2'!N30","v":"X"},{"$f":"PRESENTS","v":0},null,null,null,null,null,null,null,"CACT OUI"]
[null,{"$f":"IF(AND(NIVEAU<>1,NIVEAU<>2),\"C.A.C.T. et R.C.A.C.T.\",IF(NIVEAU=2,\"BREVET  \",\"\"))","v":""},{"$f":"IF(NIVEAU=1,Q57,IF(NIVEAU=2,Q58,Q59))","v":"-"},null,{"$f":"IF(B51<>\"\",\"<== sur décision du juge\",\"\")","v":""},null,null,null,null,null,"CACT OUI",null,null,null,null,null,"CACT NON"]
[null,{"$f":"IF(AND(NIVEAU=2,F50=\"EXCELLENT\"),\"Observations (zone en gris) :       +   Noter                            PROPOSE POUR LE BREVET CONTINENTAL                         sur le carnet de travail  \",\"Observations :  \")","v":"Observations :  "},null,null,null,null,null,null,null,{"$f":"J47+J49","v":0}]
[]
[null,"N° Cheptel du concours :",{"$f":"'Fiche organisateur N°1'!E17","v":0},null,null,"Le Juge : ",{"$f":"'Fiche organisateur N°1'!E28","v":0},null,null,null,"Qualificatif"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N1","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N2",{"$f":"IF(AND(NIVEAU=2,F50=\"excellent\"),\"OUI\",\"NON\")","v":"NON"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N3",{"$f":"IF(AND(NIVEAU<>1,NIVEAU<>2,H50=1,C47>119.999,K51=\"CACT OUI\"),\"C.A.C.T.\",IF(AND(NIVEAU<>1,NIVEAU<>2,H50=2,C47>119.999,K51=\"CACT OUI\"),\"R.C.A.C.T.\",\"\"))","v":""}]

{"sheet":"blanc","index":20,"n_rows":54,"n_cols":15,"rows_kept":54,"cut":false,"hidden":false,"merged":[[35,4,35,8],[26,4,26,8],[51,2,51,8],[53,2,53,3],[53,6,53,8],[48,4,48,6],[48,7,48,8],[49,2,49,3],[49,5,49,6],[50,2,50,3],[50,4,50,6],[47,4,47,8],[36,4,36,8],[37,4,37,8],[38,4,38,8],[39,4,39,8],[40,4,40,8],[41,4,41,8],[42,4,42,8],[43,4,43,8],[44,4,44,8],[45,4,45,8],[46,6,46,8],[29,4,29,8],[30,4,30,8],[31,4,31,8],[24,4,24,8],[25,4,25,8],[32,4,32,8],[33,4,33,8],[34,4,34,8],[14,2,14,3],[20,4,20,8],[21,4,21,8],[16,4,16,8],[17,4,17,8],[18,4,18,8],[19,4,19,8],[22,4,22,8],[23,4,23,8],[14,4,14,8],[15,4,15,8],[27,4,27,8],[28,4,28,8],[10,6,10,8],[11,6,11,8],[0,7,0,8],[2,1,2,8],[3,1,3,8],[8,6,8,8],[9,6,9,8]]}
[null,null,null,null,null,null,null,{"$f":"'00'!H1:I1","v":"NIVEAU 1"}]
[]
[null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,{"$f":"'Fiche organisateur N°1'!C8","v":"Concours CONTINENTAL"}]
[null,"ORGANISATEUR : ",{"$f":"'Fiche organisateur N°1'!E15","v":0}]
[null,"Lieu : ",{"$f":"'Fiche organisateur N°1'!E16","v":0},null,null,"Date : ",{"$f":"'Fiche organisateur N°1'!E13","v":"00:00:00"}]
[null,"Contact : ",{"$f":"'Fiche organisateur N°1'!E18","v":0}]
[]
[null,"PROPRIETAIRE : ",{"$f":"'Fiche organisateur N°2'!I31","v":" "},null,null,"Race & sexe : ",{"$f":"'Fiche organisateur N°2'!E31","v":" "}]
[null,"CONDUCTEUR : ",{"$f":"'Fiche organisateur N°2'!J31","v":" "},null,null,"N° FAPAC : ",{"$f":"'Fiche organisateur N°2'!F31","v":" "}]
[null,"NOM DU CHIEN : ",{"$f":"'Fiche organisateur N°2'!C31","v":" "},null,null,"Affixe : ",{"$f":"'Fiche organisateur N°2'!D31","v":" "}]
[null,null,null,null,null,"ID : ",{"$f":"'Fiche organisateur N°2'!G31","v":" "},null,null,null,"Contrôle de saisie (sur les onglets 01 à 18 ) "]
[]
[null,null,null,null,null,null,null,null,null,null,"Ces colonnes n'apparaissent pas lors de l'impression… "]
[null,"Epreuves                 ","Pointages",null,{"$f":"IF(OR('00'!K47<>17,LEFT('00'!E49,9)=\"ATTENTION\")=1,\"NON VALIDE => corriger la feuille 00 ! ! !\",\"Observations\")","v":"Observations"},null,null,null,null,null,"contrôle-1",null,"contrôle-2"]
[null,{"$f":"IF('00'!B16=\"\",\" -\",'00'!B16)","v":" -"},null,{"$f":"IF('00'!D16=\"\",\"\",'00'!D16)","v":""},null,null,null,null,null,null,{"$f":"IF(B16=\"\",\"\",IF(C16>D16,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B16=\" -\",C16<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B17=\"\",\" -\",'00'!B17)","v":" -"},null,{"$f":"IF('00'!D17=\"\",\"\",'00'!D17)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-1 : Contrôle que les valeurs entrées ne sont pas supérieures "]
[null,{"$f":"IF('00'!B18=\"\",\" -\",'00'!B18)","v":" -"},null,{"$f":"IF('00'!D18=\"\",\"\",'00'!D18)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"                    aux pointages maxi attribués à chaque épreuve…"]
[null,{"$f":"IF('00'!B19=\"\",\" -\",'00'!B19)","v":" -"},null,{"$f":"IF('00'!D19=\"\",\"\",'00'!D19)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B20=\"\",\" -\",'00'!B20)","v":" -"},null,{"$f":"IF('00'!D20=\"\",\"\",'00'!D20)","v":""},null,null,null,null,null,null,"OK",null,"OK",null,"Contrôle-2 : Contrôle que les colonnes sans épreuve ne contiennent pas de note"]
[null,{"$f":"IF('00'!B21=\"\",\" -\",'00'!B21)","v":" -"},null,{"$f":"IF('00'!D21=\"\",\"\",'00'!D21)","v":""},null,null,null,null,null,null,{"$f":"IF(B21=\"\",\"\",IF(C21>D21,\"! ? !\",\"OK\"))","v":"OK"},null,{"$f":"IF(AND(B21=\" -\",C21<>0),\"! ? !\",\"OK\")","v":"OK"}]
[null,{"$f":"IF('00'!B22=\"\",\" -\",'00'!B22)","v":" -"},null,{"$f":"IF('00'!D22=\"\",\"\",'00'!D22)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B23=\"\",\" -\",'00'!B23)","v":" -"},null,{"$f":"IF('00'!D23=\"\",\"\",'00'!D23)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B24=\"\",\" -\",'00'!B24)","v":" -"},null,{"$f":"IF('00'!D24=\"\",\"\",'00'!D24)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B25=\"\",\" -\",'00'!B25)","v":" -"},null,{"$f":"IF('00'!D25=\"\",\"\",'00'!D25)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B26=\"\",\" -\",'00'!B26)","v":" -"},null,{"$f":"IF('00'!D26=\"\",\"\",'00'!D26)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B27=\"\",\" -\",'00'!B27)","v":" -"},null,{"$f":"IF('00'!D27=\"\",\"\",'00'!D27)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B28=\"\",\" -\",'00'!B28)","v":" -"},null,{"$f":"IF('00'!D28=\"\",\"\",'00'!D28)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B29=\"\",\" -\",'00'!B29)","v":" -"},null,{"$f":"IF('00'!D29=\"\",\"\",'00'!D29)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B30=\"\",\" -\",'00'!B30)","v":" -"},null,{"$f":"IF('00'!D30=\"\",\"\",'00'!D30)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B31=\"\",\" -\",'00'!B31)","v":" -"},null,{"$f":"IF('00'!D31=\"\",\"\",'00'!D31)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B32=\"\",\" -\",'00'!B32)","v":" -"},null,{"$f":"IF('00'!D32=\"\",\"\",'00'!D32)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B33=\"\",\" -\",'00'!B33)","v":" -"},null,{"$f":"IF('00'!D33=\"\",\"\",'00'!D33)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B34=\"\",\" -\",'00'!B34)","v":" -"},null,{"$f":"IF('00'!D34=\"\",\"\",'00'!D34)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B35=\"\",\" -\",'00'!B35)","v":" -"},null,{"$f":"IF('00'!D35=\"\",\"\",'00'!D35)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B36=\"\",\" -\",'00'!B36)","v":" -"},null,{"$f":"IF('00'!D36=\"\",\"\",'00'!D36)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B37=\"\",\" -\",'00'!B37)","v":" -"},null,{"$f":"IF('00'!D37=\"\",\"\",'00'!D37)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B38=\"\",\" -\",'00'!B38)","v":" -"},null,{"$f":"IF('00'!D38=\"\",\"\",'00'!D38)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B39=\"\",\" -\",'00'!B39)","v":" -"},null,{"$f":"IF('00'!D39=\"\",\"\",'00'!D39)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B40=\"\",\" -\",'00'!B40)","v":" -"},null,{"$f":"IF('00'!D40=\"\",\"\",'00'!D40)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B41=\"\",\" -\",'00'!B41)","v":" -"},null,{"$f":"IF('00'!D41=\"\",\"\",'00'!D41)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B42=\"\",\" -\",'00'!B42)","v":" -"},null,{"$f":"IF('00'!D42=\"\",\"\",'00'!D42)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B43=\"\",\" -\",'00'!B43)","v":" -"},null,{"$f":"IF('00'!D43=\"\",\"\",'00'!D43)","v":""},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B44=\"\",\" -\",'00'!B44)","v":"Obéissance"},null,{"$f":"IF('00'!D44=\"\",\"\",'00'!D44)","v":4},null,null,null,null,null,null,"OK",null,"OK"]
[null,{"$f":"IF('00'!B45=\"\",\" -\",'00'!B45)","v":"Initiative"},null,{"$f":"IF('00'!D45=\"\",\"\",'00'!D45)","v":3},null,null,null,null,null,null,"OK",null,"OK"," "]
[null,{"$f":"IF('00'!B46=\"\",\" -\",'00'!B46)","v":"Douceur"},null,{"$f":"IF('00'!D46=\"\",\"\",'00'!D46)","v":3},null,null,null,null,null,null,"OK",null,"OK"]
[null,"Pointage du Travail  =>   ",{"$f":"SUM(C16:C46)","v":0},{"$f":"SUM(D16:D46)","v":10},null,"Temps : "]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C48>D48,\"! ? !\",\"OK\")","v":"OK"}]
[null,"Pénalités Générales\n(chiffre négatif) ",null,{"$f":"IF(C49>0,\"Erreur\",\"\")","v":""},"Informations sur les pénalités générales : \n   \n   \n   ",null,null,null,null,null,{"$f":"IF(C49=\"\",\"\",IF(C49>0,\"ATTENTION : les 'Pénalités Générales' doivent être un nombre négatif !\",\"OK\"))","v":""}]
[null,"TOTAL GENERAL = ",{"$f":"IF(COUNT(C16:C46)=0,\"-\",C47+C48+C49)","v":"-"},null,"Qualificatif :",{"$f":"IF(C50=\"-\",\"-\",IF(C50>'00'!D49*0.7999,\"EXCELLENT\",IF(C50>'00'!D49*0.6499,\"TRES BON\",IF(C50>'00'!D49*0.5499,\"BON\",\" - \"))))","v":"-"}]
[null,{"$f":"IF(AND(NIVEAU<>1,NIVEAU<>2),\"C.A.C.T. et R.C.A.C.T.\",\"\")","v":""}," - ",null,{"$f":"IF(B51<>\"\",\"<== chien en blanc, qualificatif non retenu\",\"\")","v":""}]
[null,"Observations :  ","Qualificatif et Pointage Fictifs - chien en Blanc",null,null,null,null,null,null,{"$f":"J47+J49","v":0}]
[]
[null,"N° Cheptel du concours :",{"$f":"'Fiche organisateur N°1'!E17","v":0},null,null,"Le Juge : ",{"$f":"'Fiche organisateur N°1'!E28","v":0}]

{"sheet":"Print Points","index":21,"n_rows":52,"n_cols":10,"rows_kept":52,"cut":false,"hidden":false,"merged":[[35,4,35,8],[26,4,26,8],[51,2,51,8],[53,6,53,8],[48,4,48,6],[48,7,48,8],[49,2,49,3],[49,5,49,6],[50,2,50,3],[50,4,50,6],[47,4,47,8],[36,4,36,8],[37,4,37,8],[38,4,38,8],[39,4,39,8],[40,4,40,8],[41,4,41,8],[42,4,42,8],[43,4,43,8],[44,4,44,8],[45,4,45,8],[46,6,46,8],[29,4,29,8],[30,4,30,8],[31,4,31,8],[24,4,24,8],[25,4,25,8],[32,4,32,8],[33,4,33,8],[34,4,34,8],[14,2,14,3],[20,4,20,8],[21,4,21,8],[16,4,16,8],[17,4,17,8],[18,4,18,8],[19,4,19,8],[22,4,22,8],[23,4,23,8],[14,4,14,8],[15,4,15,8],[27,4,27,8],[28,4,28,8],[10,6,10,8],[11,6,11,8],[0,7,0,8],[2,1,2,8],[3,1,3,8],[8,6,8,8],[9,6,9,8]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"IF('00'!B16=\"\",\" -\",'00'!B16)","v":" -"},null,{"$f":"IF('00'!D16=\"\",\"\",'00'!D16)","v":""}]
[null,{"$f":"IF('00'!B17=\"\",\" -\",'00'!B17)","v":" -"},null,{"$f":"IF('00'!D17=\"\",\"\",'00'!D17)","v":""}]
[null,{"$f":"IF('00'!B18=\"\",\" -\",'00'!B18)","v":" -"},null,{"$f":"IF('00'!D18=\"\",\"\",'00'!D18)","v":""}]
[null,{"$f":"IF('00'!B19=\"\",\" -\",'00'!B19)","v":" -"},null,{"$f":"IF('00'!D19=\"\",\"\",'00'!D19)","v":""}]
[null,{"$f":"IF('00'!B20=\"\",\" -\",'00'!B20)","v":" -"},null,{"$f":"IF('00'!D20=\"\",\"\",'00'!D20)","v":""}]
[null,{"$f":"IF('00'!B21=\"\",\" -\",'00'!B21)","v":" -"},null,{"$f":"IF('00'!D21=\"\",\"\",'00'!D21)","v":""}]
[null,{"$f":"IF('00'!B22=\"\",\" -\",'00'!B22)","v":" -"},null,{"$f":"IF('00'!D22=\"\",\"\",'00'!D22)","v":""}]
[null,{"$f":"IF('00'!B23=\"\",\" -\",'00'!B23)","v":" -"},null,{"$f":"IF('00'!D23=\"\",\"\",'00'!D23)","v":""}]
[null,{"$f":"IF('00'!B24=\"\",\" -\",'00'!B24)","v":" -"},null,{"$f":"IF('00'!D24=\"\",\"\",'00'!D24)","v":""}]
[null,{"$f":"IF('00'!B25=\"\",\" -\",'00'!B25)","v":" -"},null,{"$f":"IF('00'!D25=\"\",\"\",'00'!D25)","v":""}]
[null,{"$f":"IF('00'!B26=\"\",\" -\",'00'!B26)","v":" -"},null,{"$f":"IF('00'!D26=\"\",\"\",'00'!D26)","v":""}]
[null,{"$f":"IF('00'!B27=\"\",\" -\",'00'!B27)","v":" -"},null,{"$f":"IF('00'!D27=\"\",\"\",'00'!D27)","v":""}]
[null,{"$f":"IF('00'!B28=\"\",\" -\",'00'!B28)","v":" -"},null,{"$f":"IF('00'!D28=\"\",\"\",'00'!D28)","v":""}]
[null,{"$f":"IF('00'!B29=\"\",\" -\",'00'!B29)","v":" -"},null,{"$f":"IF('00'!D29=\"\",\"\",'00'!D29)","v":""}]
[null,{"$f":"IF('00'!B30=\"\",\" -\",'00'!B30)","v":" -"},null,{"$f":"IF('00'!D30=\"\",\"\",'00'!D30)","v":""}]
[null,{"$f":"IF('00'!B31=\"\",\" -\",'00'!B31)","v":" -"},null,{"$f":"IF('00'!D31=\"\",\"\",'00'!D31)","v":""}]
[null,{"$f":"IF('00'!B32=\"\",\" -\",'00'!B32)","v":" -"},null,{"$f":"IF('00'!D32=\"\",\"\",'00'!D32)","v":""}]
[null,{"$f":"IF('00'!B33=\"\",\" -\",'00'!B33)","v":" -"},null,{"$f":"IF('00'!D33=\"\",\"\",'00'!D33)","v":""}]
[null,{"$f":"IF('00'!B34=\"\",\" -\",'00'!B34)","v":" -"},null,{"$f":"IF('00'!D34=\"\",\"\",'00'!D34)","v":""}]
[null,{"$f":"IF('00'!B35=\"\",\" -\",'00'!B35)","v":" -"},null,{"$f":"IF('00'!D35=\"\",\"\",'00'!D35)","v":""}]
[null,{"$f":"IF('00'!B36=\"\",\" -\",'00'!B36)","v":" -"},null,{"$f":"IF('00'!D36=\"\",\"\",'00'!D36)","v":""}]
[null,{"$f":"IF('00'!B37=\"\",\" -\",'00'!B37)","v":" -"},null,{"$f":"IF('00'!D37=\"\",\"\",'00'!D37)","v":""}]
[null,{"$f":"IF('00'!B38=\"\",\" -\",'00'!B38)","v":" -"},null,{"$f":"IF('00'!D38=\"\",\"\",'00'!D38)","v":""}]
[null,{"$f":"IF('00'!B39=\"\",\" -\",'00'!B39)","v":" -"},null,{"$f":"IF('00'!D39=\"\",\"\",'00'!D39)","v":""}]
[null,{"$f":"IF('00'!B40=\"\",\" -\",'00'!B40)","v":" -"},null,{"$f":"IF('00'!D40=\"\",\"\",'00'!D40)","v":""}]
[null,{"$f":"IF('00'!B41=\"\",\" -\",'00'!B41)","v":" -"},null,{"$f":"IF('00'!D41=\"\",\"\",'00'!D41)","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"J47+J49","v":0}]

{"sheet":"Memo","index":22,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":false,"merged":[[24,9,24,15],[24,1,24,5],[25,1,25,4],[26,1,26,5],[9,1,9,4],[12,2,12,4],[20,1,20,5],[21,1,21,5],[22,1,22,5],[23,1,23,5],[6,2,6,3],[6,4,6,5],[1,2,1,5],[2,2,2,5],[4,1,4,4],[5,2,5,3],[5,4,5,5]]}
[]
[null,null,"COMMISSION D'UTILISATION TROUPEAUX"]
[null,null,{"$f":"'Fiche organisateur N°1'!C3","v":"Président : Monsieur Jean-Paul Kerihuel - 7, Allée Madame de La Fayette - 29200 Saint-Renan"},null,null,null,null,null,null,"Chers relecteurs, vous pouvez faire vos remarques dans ce cadre"]
[]
[]
[]
[]
[]
[]
[null,"QUELQUES RAPPELS "]
[]
[]
[null,null,"Niveaux"]
[null,"Qualificatifs","I   / 75","II   / 100","III   / 150",null,null,null,null,"MISES A JOUR NOVEMBRE 2018 : "]
[null,null,"Débutant","Brevet","Sélectif",null,null,null,null," - EXCELLENT obtenu avec ≥ à 80% des points (soit : ≥ 60 / 75) "]
[null,"Excellent : ","³ 60","³ 80.00","³ 120.0"," <===="]
[null,"Très Bon : ","³ 48.75","³ 65.00","³ 97.50",null,null,null,null," - Ajout de « Activité – douceur - Initiative - obéissance - commandements conducteur » notés sur 20 points"]
[null,"Bon : ","³ 41.25","³ 55.00","³ 82.50",null,null,null,null," - 2 excellents sont nécessaires pour passer en niveau 2 avec 2 juges différents"]
[null,"Sans Qualif. : ","< 41.25","< 55.00","< 82.50"]
[]
[]
[null,"La classe Travail en Expo. : Le qualificatif « Excellent » en niveau I, donne droit à l’engagement en classe Travail dans les Expositions de Conformité au Standard."]
[null,"Brevet : Le Brevet de Travail sur Troupeaux est décerné après avoir obtenu un minimum de 80 points sur 100, en concours de niveau II sous deux Juges différents. "]
[null," Le Brevet n’est homologué qu’après enregistrement sur le Carnet de travail des deux propositions faites suivant les règles ci-dessus et il est obligatoire pour tout engagement en niveau III."]
[null,"CACT  &  RCACT : Le Certificat d’Aptitude au Championnat de Travail sur troupeaux (C.A.C.T.) et sa Réserve (R.C.A.C.T.) ne peuvent être attribués que dans les concours sélectifs, Coupe de France compris, à condition que les chiens classés premier et deuxième aient obtenu au moins 80 % des points, soit 120 / 150  et qu’il n’y ait pas d’ex-æquo pour les places de premier et de deuxième.",null,null,null,null,null,null,null,"l'affichage est automatique pour le 1° et le 2° s'ils ont les conditions de pointage, si le juge ne souhaite pas attribuer l'un ou l'autre il doit choisir CACT NON dans le menu déroulant pour le faire disparaître "]
[null,"               Seul un Juge qualifié peut décerner ces récompenses."]
[null," L’attribution de ces récompenses n’est pas systématique, même si le pointage est conforme, c’est le juge qui apprécie s’il peut les attribuer, au vu du travail qui a été exécuté et qui doit être de qualité exceptionnelle."]