{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Formulaire_1","Formulaire_2","Vérification_2_Ponts-bascules","Tolérance"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":3,"comments":3,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Formulaire_1","index":0,"n_rows":53,"n_cols":31,"rows_kept":53,"cut":false,"hidden":false,"merged":[[6,0,6,1],[6,2,6,10],[6,12,6,13],[6,14,6,16],[1,0,1,16],[3,0,3,16],[5,0,5,1],[5,2,5,10],[5,12,5,16],[7,0,7,2],[7,3,7,10],[7,12,7,13],[7,14,7,16],[8,12,8,13],[8,14,8,16],[9,0,9,1],[9,12,9,13],[9,14,9,16],[10,0,10,1],[10,12,10,13],[10,14,10,16],[12,0,12,6],[12,8,12,16],[14,1,14,3],[14,9,14,14],[15,1,15,3],[15,9,15,13],[16,1,16,3],[16,9,16,13],[17,1,17,3],[17,9,17,13],[18,1,18,3],[18,9,18,13],[19,1,19,3],[19,9,19,13],[20,1,20,3],[20,9,20,13],[21,1,21,3],[21,7,22,16],[22,1,22,3],[23,1,23,3],[25,0,25,16],[27,0,28,0],[27,1,28,3],[27,4,28,8],[27,10,27,16],[28,10,29,12],[28,13,29,16],[29,4,29,8],[30,4,30,8],[30,10,31,12],[30,13,31,16],[31,4,31,8],[32,4,32,8],[32,10,32,16],[33,1,33,3],[33,4,33,8],[33,10,34,12],[33,13,34,16],[34,1,34,3],[34,4,34,8],[35,4,35,8],[35,10,36,12],[35,13,36,16],[36,4,36,8],[37,4,37,8],[37,10,38,12],[37,13,38,16],[38,4,38,8],[49,4,49,9],[40,8,40,16],[41,0,41,1],[41,2,41,16],[42,0,42,16],[43,0,43,16],[44,0,44,16],[45,0,45,16],[46,0,46,16],[48,0,48,1],[48,2,48,9],[48,11,48,16],[52,0,52,16],[50,0,50,3],[50,4,50,9],[50,10,50,12],[50,13,50,16],[51,0,51,2],[51,3,51,12],[51,13,51,16]]}
[]
["CONTRÔLE DE PONT-BASCULE"]
[]
["MESURAGE MASSE / VOLUME"]
[]
["PROPRIÉTAIRE",null,null,null,null,null,null,null,null,null,null,null,"Projet (s) de mesurage"]
["LOCALISATION"]
["CAPACITÉ   Lb      ou   kg             :"]
[null,null,"Largeur","Longueur"]
["DIMENSIONS"]
["GRADUATION",null,"10 kg","20 kg",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
["INSPECTION VISUELLE (Facultatif)",null,null,null,null,null,null,null,"FONCTIONNEMENT"]
[]
["No","ÉLÉMENTS À VÉRIFIER",null,null,"Vérif.","C","NC",null,"#","ÉTAPES DE VÉRIFICATION",null,null,null,null,null,"C","NC"]
[1,"PLAQUE D'APPROBATION",null,null,{"$f":"IF(Z16=1,\"OUI\",IF(Z16>1,\"N/A\",\"NON\"))","v":"NON"},null,null,null,1,"RÉGLAGE À ZÉRO",null,null,null,null,{"$f":"IF(AE16=2,\"N/A\",\"\")","v":""},null,null,null,null,null,null,false,false,{"$f":"IF(V16=FALSE,0,IF(V16=TRUE,1,\"\"))","v":0},{"$f":"IF(W16=FALSE,0,IF(W16=TRUE,1,\"\"))","v":0},{"$f":"X16+Y16","v":0},false,false,{"$f":"IF(AA16=FALSE,0,IF(AA16=TRUE,1,\"\"))","v":0},0,{"$f":"AC16+AD16","v":0}]
[2,"SCELLÉS",null,null,{"$f":"IF(Z17=1,\"OUI\",IF(Z17>1,\"N/A\",\"NON\"))","v":"NON"},null,null,null,2,"SENSIBILITÉ À ZÉRO",null,null,null,null,"",null,null,null,null,null,null,false,false,{"$f":"IF(V17=FALSE,0,IF(V17=TRUE,1,\"\"))","v":0},0,{"$f":"X17+Y17","v":0},false,false,0,0,0]
[3,"VISIBILITÉ AFFICHAGE",null,null,{"$f":"IF(Z18=1,\"OUI\",IF(Z18>1,\"N/A\",\"NON\"))","v":"NON"},null,null,null,3,"SENSIBILITÉ EN CHARGE",null,null,null,null,"",null,null,null,null,null,null,false,false,0,0,0,false,false,0,0,0]
[4,"APPROCHES",null,null,"NON",null,null,null,4,"DÉTECTEUR DE MOUVEMENT",null,null,null,null,"",null,null,null,null,null,null,false,false,0,0,0,false,false,0,0,0]
[5,"BANDES PROTECTRICES (Tablier)",null,null,"NON",null,null,null,5,"VÉRIFICATION DE LA  RÉGULARITÉ",null,null,null,null,"",null,null,null,null,null,null,false,false,0,0,0,false,false,0,0,0]
[6,"LIBERTÉ DE MOUVEMENT (Tablier)",null,null,"NON",null,null,null,6,"RETOUR À ZÉRO",null,null,null,null,"",null,null,null,null,null,null,false,false,0,0,0,false,false,0,0,0]
[7,"PROPRETÉ DU TABLIER",null,null,"NON",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,0,0,0]
[8,"AMORTISSEURS",null,null,"NON",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,0,0,0]
[9,"DÉTECTEURS ET FEUX",null,null,"NON",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,0,0,0]
[]
["DONNÉES de la  VÉRIFICATION de la RÉGULARITÉ"]
[]
["No","POSITION DU VÉHICULE SUR LE TABLIER ",null,null,"MASSE                       (min. 15 000 kg)",null,null,null,null,null,"DIFFÉRENCE PERMISE"]
[null,null,null,null,null,null,null,null,null,null,"MASSE DU VÉHICULE",null,null,{"$f":"IF(E30<1,\" \",AVERAGE(E30:E39))","v":" "},null,null,null,null,{"$f":"IF(N29<5010,10,IF(N29<13010,20,IF(N29<21010,30,IF(N29<29010,40,IF(N29<37010,50,IF(N29<45010,60,IF(N29<53010,70,\"\")))))))","v":""}]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N29<10010,20,IF(N29<26010,40,IF(N29<42010,60,IF(N29<58010,80,IF(N29<74010,100,IF(N29<90010,120,IF(N29<106010,140,\"\")))))))","v":""}]
[2,null,null,null,null,null,null,null,null,null,"TOLÉRANCE",null,null,{"$f":"IF(S11=1,S29,IF(S11=2,S30,\"\"))","v":""}]
[3]
[4,null,null,null,null,null,null,null,null,null,"DIFFÉRENCE CALCULÉE",null,null,null,null,null,null,{"$f":"IF(E30<1,\" \",N29*0.002)","v":" "}]
[5,null,null,null,null,null,null,null,null,null,"PLUS GRANDE MASSE",null,null,{"$f":"IF(E30<1,\" \",MAX(E30:E39))","v":" "}]
[1]
[2,null,null,null,null,null,null,null,null,null,"PLUS PETITE MASSE",null,null,{"$f":"IF(E30<1,\" \",MIN(E30:E39))","v":" "}]
[3]
[4,null,null,null,null,null,null,null,null,null,"DIFFÉRENCE",null,null,{"$f":"IF(E30<1,\" \",N34-N36)","v":" "}]
[5]
[]
[null,null,null,null,null,null,null,"Résultats :",{"$f":"IF(E30=0,\"\",IF(N38<=N31,\"À l'intérieur des marges autorisées\",IF(N38>N31,\"À l'extérieur des marges autorisées\",)))","v":""}]
["REMARQUES :"]
[]
[]
[]
[]
[]
[]
["Réalisé par :",null,null,null,null,null,null,null,null,null,"Date : "]
[null,null,null,null,"Date"]
["J'ai pris connaissance des résultats le ",null,null,null,null,null,null,null,null,null,null,null,null,"Matricule"]
["Signature du mesureur"]
["N. B. Ce formulaire doit être signé par un mesureur et transmis électroniquement au MFFP,  le jour de sa signature"]

{"sheet":"Formulaire_2","index":1,"n_rows":53,"n_cols":31,"rows_kept":53,"cut":false,"hidden":false,"merged":[[52,0,52,16],[50,0,50,3],[50,4,50,9],[50,10,50,12],[50,13,50,16],[51,0,51,2],[51,3,51,12],[51,13,51,16],[49,4,49,9],[40,8,40,16],[41,0,41,1],[41,2,41,16],[42,0,42,16],[43,0,43,16],[44,0,44,16],[45,0,45,16],[46,0,46,16],[48,0,48,1],[48,2,48,9],[48,11,48,16],[35,4,35,8],[35,10,36,12],[35,13,36,16],[36,4,36,8],[37,4,37,8],[37,10,38,12],[37,13,38,16],[38,4,38,8],[33,1,33,3],[33,4,33,8],[33,10,34,12],[33,13,34,16],[34,1,34,3],[34,4,34,8],[30,4,30,8],[30,10,31,12],[30,13,31,16],[31,4,31,8],[32,4,32,8],[32,10,32,16],[23,1,23,3],[25,0,25,16],[27,0,28,0],[27,1,28,3],[27,4,28,8],[27,10,27,16],[28,10,29,12],[28,13,29,16],[29,4,29,8],[19,1,19,3],[19,9,19,13],[20,1,20,3],[20,9,20,13],[21,1,21,3],[21,7,22,16],[22,1,22,3],[16,1,16,3],[16,9,16,13],[17,1,17,3],[17,9,17,13],[18,1,18,3],[18,9,18,13],[12,0,12,6],[12,8,12,16],[14,1,14,3],[14,9,14,14],[15,1,15,3],[15,9,15,13],[9,0,9,1],[9,12,9,13],[9,14,9,16],[10,0,10,1],[10,12,10,13],[10,14,10,16],[7,0,7,2],[7,3,7,10],[7,12,7,13],[7,14,7,16],[8,12,8,13],[8,14,8,16],[6,0,6,1],[6,2,6,10],[6,12,6,13],[6,14,6,16],[1,0,1,16],[3,0,3,16],[5,0,5,1],[5,2,5,10],[5,12,5,16]]}
[]
["CONTRÔLE DE PONT-BASCULE"]
[]
["MESURAGE MASSE / VOLUME"]
[]
["PROPRIÉTAIRE",null,null,null,null,null,null,null,null,null,null,null,"Projet (s) de mesurage"]
["LOCALISATION"]
["CAPACITÉ   Lb      ou   kg             :"]
[null,null,"Largeur","Longueur"]
["DIMENSIONS"]
["GRADUATION",null,"10 kg","20 kg",null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
["INSPECTION VISUELLE (Facultatif)",null,null,null,null,null,null,null,"FONCTIONNEMENT"]
[]
["No","ÉLÉMENTS À VÉRIFIER",null,null,"Vérif.","C","NC",null,"#","ÉTAPES DE VÉRIFICATION",null,null,null,null,null,"C","NC"]
[1,"PLAQUE D'APPROBATION",null,null,{"$f":"IF(Z16=1,\"OUI\",IF(Z16>1,\"N/A\",\"NON\"))","v":"NON"},null,null,null,1,"RÉGLAGE À ZÉRO",null,null,null,null,{"$f":"IF(AE16=2,\"N/A\",\"\")","v":""},null,null,null,null,null,null,false,false,{"$f":"IF(V16=FALSE,0,IF(V16=TRUE,1,\"\"))","v":0},{"$f":"IF(W16=FALSE,0,IF(W16=TRUE,1,\"\"))","v":0},{"$f":"X16+Y16","v":0},false,false,{"$f":"IF(AA16=FALSE,0,IF(AA16=TRUE,1,\"\"))","v":0},0,{"$f":"AC16+AD16","v":0}]
[2,"SCELLÉS",null,null,{"$f":"IF(Z17=1,\"OUI\",IF(Z17>1,\"N/A\",\"NON\"))","v":"NON"},null,null,null,2,"SENSIBILITÉ À ZÉRO",null,null,null,null,"",null,null,null,null,null,null,false,false,{"$f":"IF(V17=FALSE,0,IF(V17=TRUE,1,\"\"))","v":0},0,{"$f":"X17+Y17","v":0},false,false,0,0,0]
[3,"VISIBILITÉ AFFICHAGE",null,null,{"$f":"IF(Z18=1,\"OUI\",IF(Z18>1,\"N/A\",\"NON\"))","v":"NON"},null,null,null,3,"SENSIBILITÉ EN CHARGE",null,null,null,null,"",null,null,null,null,null,null,false,false,0,0,0,false,false,0,0,0]
[4,"APPROCHES",null,null,"NON",null,null,null,4,"DÉTECTEUR DE MOUVEMENT",null,null,null,null,"",null,null,null,null,null,null,false,false,0,0,0,false,false,0,0,0]
[5,"BANDES PROTECTRICES (Tablier)",null,null,"NON",null,null,null,5,"VÉRIFICATION DE LA  RÉGULARITÉ",null,null,null,null,"",null,null,null,null,null,null,false,false,0,0,0,false,false,0,0,0]
[6,"LIBERTÉ DE MOUVEMENT (Tablier)",null,null,"NON",null,null,null,6,"RETOUR À ZÉRO",null,null,null,null,"",null,null,null,null,null,null,false,false,0,0,0,false,false,0,0,0]
[7,"PROPRETÉ DU TABLIER",null,null,"NON",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,0,0,0]
[8,"AMORTISSEURS",null,null,"NON",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,0,0,0]
[9,"DÉTECTEURS ET FEUX",null,null,"NON",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false,false,0,0,0]
[]
["DONNÉES de la  VÉRIFICATION de la RÉGULARITÉ"]
[]
["No","POSITION DU VÉHICULE SUR LE TABLIER ",null,null,"MASSE                       (min. 15 000 kg)",null,null,null,null,null,"DIFFÉRENCE PERMISE"]
[null,null,null,null,null,null,null,null,null,null,"MASSE DU VÉHICULE",null,null,{"$f":"IF(E30<1,\" \",AVERAGE(E30:E39))","v":" "},null,null,null,null,{"$f":"IF(N29<5010,10,IF(N29<13010,20,IF(N29<21010,30,IF(N29<29010,40,IF(N29<37010,50,IF(N29<45010,60,IF(N29<53010,70,\"\")))))))","v":""}]
[1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N29<10010,20,IF(N29<26010,40,IF(N29<42010,60,IF(N29<58010,80,IF(N29<74010,100,IF(N29<90010,120,IF(N29<106010,140,\"\")))))))","v":""}]
[2,null,null,null,null,null,null,null,null,null,"TOLÉRANCE",null,null,{"$f":"IF(S11=1,S29,IF(S11=2,S30,\"\"))","v":""}]
[3]
[4,null,null,null,null,null,null,null,null,null,"DIFFÉRENCE CALCULÉE",null,null,null,null,null,null,{"$f":"IF(E30<1,\" \",N29*0.002)","v":" "}]
[5,null,null,null,null,null,null,null,null,null,"PLUS GRANDE MASSE",null,null,{"$f":"IF(E30<1,\" \",MAX(E30:E39))","v":" "}]
[1]
[2,null,null,null,null,null,null,null,null,null,"PLUS PETITE MASSE",null,null,{"$f":"IF(E30<1,\" \",MIN(E30:E39))","v":" "}]
[3]
[4,null,null,null,null,null,null,null,null,null,"DIFFÉRENCE",null,null,{"$f":"IF(E30<1,\" \",N34-N36)","v":" "}]
[5]
[]
[null,null,null,null,null,null,null,"Résultats :",{"$f":"IF(E30=0,\"\",IF(N38<=N31,\"À l'intérieur des marges autorisées\",IF(N38>N31,\"À l'extérieur des marges autorisées\",)))","v":""}]
["REMARQUES :"]
[]
[]
[]
[]
[]
[]
["Réalisé par :",null,null,null,null,null,null,null,null,null,"Date : "]
[null,null,null,null,"Date"]
["J'ai pris connaissance des résultats le ",null,null,null,null,null,null,null,null,null,null,null,null,"Matricule"]
["Signature du mesureur"]
["N. B. Ce formulaire doit être signé par un mesureur et transmis électroniquement au MFFP,  le jour de sa signature"]

{"sheet":"Vérification_2_Ponts-bascules","index":2,"n_rows":49,"n_cols":18,"rows_kept":49,"cut":false,"hidden":false,"merged":[[25,10,26,12],[25,13,26,16],[12,0,12,3],[12,4,12,8],[25,0,25,3],[25,4,25,8],[14,31,15,34],[16,31,17,34],[35,4,35,8],[36,4,36,8],[37,4,37,8],[33,1,33,3],[33,4,33,8],[34,4,34,8],[19,13,20,16],[20,1,20,3],[20,4,20,8],[16,4,16,8],[16,10,17,12],[16,13,17,16],[17,4,17,8],[11,0,11,16],[31,4,31,8],[32,1,32,3],[32,4,32,8],[21,4,21,8],[21,10,22,12],[21,13,22,16],[22,4,22,8],[23,4,23,8],[23,10,24,12],[23,13,24,16],[24,4,24,8],[19,1,19,3],[19,4,19,8],[19,10,20,12],[48,0,48,16],[26,0,27,0],[26,1,27,3],[26,4,27,8],[27,10,28,12],[27,13,28,16],[28,4,28,8],[29,4,29,8],[30,4,30,8],[46,0,46,3],[46,4,46,9],[46,10,46,12],[46,13,46,16],[47,0,47,2],[47,3,47,12],[47,13,47,16],[42,0,42,16],[44,0,44,1],[44,2,44,9],[44,11,44,16],[45,4,45,9],[38,8,38,16],[39,0,39,1],[39,2,39,16],[40,0,40,16],[41,0,41,16],[18,4,18,8],[18,10,18,16],[13,0,14,0],[13,1,14,3],[13,4,14,8],[13,10,13,16],[14,10,15,12],[14,13,15,16],[15,4,15,8],[8,12,8,13],[8,14,8,16],[9,12,9,13],[9,14,9,16],[6,0,6,2],[6,3,6,10],[6,12,6,13],[6,14,6,16],[7,12,7,13],[7,14,7,16],[5,0,5,1],[5,2,5,10],[5,12,5,13],[5,14,5,16],[1,0,1,16],[3,0,3,16],[4,0,4,1],[4,2,4,10],[4,12,4,16]]}
[]
["CONTRÔLE DANS LE CADRE DE L'UTILISATION\nDE 2 PONTS-BASCULES"]
[]
["MESURAGE MASSE / VOLUME"]
["PROPRIÉTAIRE",null,null,null,null,null,null,null,null,null,null,null,"Projet (s) de mesurage"]
["LOCALISATION"]
[]
[]
[]
[]
[]
["DONNÉES de la  VÉRIFICATION de la RÉGULARITÉ"]
["Pont-Bascule 1 :"]
["No","POSITION DU VÉHICULE SUR LE TABLIER ",null,null,"MASSE                       (min. 15 000 kg)",null,null,null,null,null,"DIFFÉRENCE PERMISE"]
[null,null,null,null,null,null,null,null,null,null,"MASSE MOYENNE VÉHICULE",null,null,{"$f":"IF(E16<1,\" \",ROUNDUP((AVERAGE(E16:I25,E29:I38)),1))","v":" "}]
[1]
[2,null,null,null,null,null,null,null,null,null,"TOLÉRANCE",null,null,{"$f":"IF(E16<1,\" \",ROUNDUP((N15*0.003),-1))","v":" "}]
[3]
[4,null,null,null,null,null,null,null,null,null,"DIFFÉRENCE CALCULÉE",null,null,null,null,null,null,{"$f":"IF(E16<1,\" \",N15*0.002)","v":" "}]
[5,null,null,null,null,null,null,null,null,null,"PLUS GRANDE MASSE",null,null,{"$f":"IF(E16<1,\" \",MAX(E16:I25,E29:I38))","v":" "}]
[1]
[2,null,null,null,null,null,null,null,null,null,"PLUS PETITE MASSE",null,null,{"$f":"IF(E16<1,\" \",MIN(E16:I25,E29:I38))","v":" "}]
[3]
[4,null,null,null,null,null,null,null,null,null,"DIFFÉRENCE",null,null,{"$f":"IF(E16<1,\" \",N20-N22)","v":" "}]
[5]
["Pont-Bascule 2",null,null,null,null,null,null,null,null,null,"DIFFÉRENCE EN %",null,null,{"$f":"IFERROR(N24/N15,\"\")","v":""}]
["No","POSITION DU VÉHICULE SUR LE TABLIER ",null,null,"MASSE                       (min. 15 000 kg)"]
[]
[1]
[2]
[3]
[4]
[5]
[1]
[2]
[3]
[4]
[5]
[null,null,null,null,null,null,null,"Résultats :",{"$f":"IF(E16=0,\"\",IF(N24<=N17,\"À l'intérieur des marges autorisées\",IF(N24>N17,\"À l'extérieur des marges autorisées\",)))","v":""}]
["REMARQUES :"]
[]
[]
[]
[]
["Réalisé par :",null,null,null,null,null,null,null,null,null,"Date : "]
[null,null,null,null,"Date"]
["J'ai pris connaissance des résultats le ",null,null,null,null,null,null,null,null,null,null,null,null,"Matricule"]
["Signature du mesureur"]
["N. B. Ce formulaire doit être signé par un mesureur et transmis électroniquement au MFFP,  le jour de sa signature"]

{"sheet":"Tolérance","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}