{"text_format":"1","workbook":"xls","n_sheets":6,"sheets":["Accueil","O","Cat M1","Cat N1","Cat N2-N3","Benne Amovible"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":12,"comments":40,"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","formulas":"cached_only"}

{"sheet":"Accueil","index":0,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[null,"RÉPARTITION DE CHARGES SELON UE 1230/2012"]
[]
[null,"Cliquer sur votre cas de calcul (maintenir la touche Ctrl)"]
[]
[1,"Remorques de tous PTAC (dont caravanes)"]
[2,"Véhicules de transport de personnes de 9 places maximum (dont camping-car)"]
[3,"Véhicules de transport de marchandises de 3,5 t de PTAC maximum"]
[4,"Véhicules de transport de marchandises de PTAC supérieur à 3,5 t"]
[5,"Véhicules à benne amovible"]

{"sheet":"O","index":1,"n_rows":86,"n_cols":7,"rows_kept":86,"cut":false,"hidden":false,"merged":[[0,0,0,7],[2,0,2,255],[4,2,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[13,1,13,3],[18,1,18,4],[22,1,22,4],[22,5,22,6],[25,1,27,1],[25,4,27,4],[30,1,30,3],[34,1,34,2],[36,1,36,3],[37,1,38,2],[72,1,72,3]],"flags":["formulas_cached_only"]}
["VÉHICULE DE CATÉGORIE O\nCALCUL DE RÉPARTITION DES CHARGES"]
[]
["Ne remplir que les cases grisées – Ne saisir aucune unité (m, kg, L, %), seulement des chiffres"]
[]
[null,"Demandeur"]
[null,"Véhicule :   marque"]
[null,"                  type"]
[null,"                  VIN"]
[null,"                  Immatriculation"]
[null,"                  Date de mise en circulation (jj/mm/aaaa)"]
[null,"Date"]
[null,"Signature"]
[]
[]
[null,"Poids total autorisé en charge ","PTAC",null,null,"Longueur"]
[null,"Nombre de couchettes","N",null,null,"Largeur"]
[null,"Longueur","L",null,null,"Surface",0]
[]
[null,"MASSE À VIDE EN ORDRE DE MARCHE"]
[null,null,"Point d’attelage ou essieu pour un rond d’avant-train","Essieu(x) arrière(s)","Total"]
[null,"MASSE À VIDE EN ORDRE DE MARCHE",null,null,0]
[]
[null,"MASSES MAXIMALES TECHNIQUEMENT ADMISSIBLES",null,null,null,"DÉTERMINATION DE L’EMPATTEMENT THÉORIQUE"]
[null,null,null,"MMTA essieux","Théorie",null,"Distance"]
[null,"Avant","Tête ou essieu avant",null,0]
[null,"Arrière","Essieu 1",null,0,"0-1 :Tête à essieu 1"]
[null,null,"Essieu 2",null,null,"1-2 : Essieu 1 à essieu 2"]
[null,null,"Essieu 3",null,null,"2-3 : Essieu 2 à essieu 3"]
[null,null,null,null,null,"Empattement théorique =",0]
[]
[null,"ZONE DE CARGAISON (CHARGEMENT UNIFORME)"]
[null,"Longueur de la zone de cargaison"]
[null,"Porte-à-faux arrière utile à l’axe du dernier essieu"]
[null,"Porte-à-faux arrière utile à l’axe de l’essieu théorique",null,{"$error":"#DIV/0!"}]
[null,"Distance du centre de gravité du chargement à l'essieu arrière théorique",null,{"$error":"#DIV/0!"}]
[]
[null,"RÉPARTITION DE LA CHARGE UTILE SELON 1230/2012"]
[null,null,null,0]
[null,null,null,0]
[null,"Élément considéré","Distance par rapport à la tête ou l’essieu avant (m)","masse de l’élément (kg)"]
[null,"Chargement uniforme dans la zone de cargaison",{"$error":"#VALUE!"}]
[null,"Coffre n°1"]
[null,"Coffre n°2"]
[null,"Coffre n°3"]
[null,"Coffre n°4"]
[null,"Coffre n°5"]
[null,"Coffre n°6"]
[null,"Coffre n°7"]
[null,"Coffre n°8"]
[null,"Coffre n°9"]
[null,"Coffre n°10"]
[null,"Coffre n°11"]
[null,"Coffre n°12"]
[null,"Coffre n°13"]
[null,"Coffre n°14"]
[null,"Coffre n°15"]
[null,"Coffre n°16"]
[null,"Coffre n°17"]
[null,"Coffre n°18"]
[null,"Coffre n°19"]
[null,"Coffre n°20"]
[null,"Coffre n°21"]
[null,"Coffre n°22"]
[null,"Coffre n°23"]
[null,"Coffre n°24"]
[null,"Coffre n°25"]
[null,"Coffre n°26"]
[null,"Coffre n°27"]
[null,"Coffre n°28"]
[null,"Coffre n°29"]
[null,"Coffre n°30"]
[]
[null,"RECEVABILITÉ EN CARAVANE SELON 1230/2012 Annexe I partie D §2"]
[null,null,"Valeur","Critère"]
[null,"Charge utile :",0,0]
[]
[null,null,"Point d’attelage ou essieu 0 pour un rond d’avant-train","Essieu(x) arrière(s)","Total"]
[null,"Masse à vide en ordre de marche",0,0,0]
[null,"Chargement",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"TOTAL",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Maximum",0,0,0]
[]
[]
[null,"Barycentre 2-3 par rapport à 2",{"$error":"#DIV/0!"}]
[null,"Barycentre 2-3-4 par rapport à 2",{"$error":"#DIV/0!"}]
[null,"Empattement théorique",{"$error":"#DIV/0!"}]

{"sheet":"Cat M1","index":2,"n_rows":360,"n_cols":7,"rows_kept":360,"cut":false,"hidden":false,"merged":[[0,0,0,7],[2,0,2,255],[4,2,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[13,1,13,3],[19,1,19,5],[34,1,34,4],[34,5,34,6],[36,1,37,1],[36,4,37,4],[38,1,40,1],[38,4,40,4],[43,1,43,3],[56,1,56,3],[58,1,58,2],[59,1,59,2],[60,1,60,2],[64,1,64,4],[66,1,67,2],[101,1,101,3],[105,1,105,4],[115,1,115,4],[125,1,125,4]],"flags":["formulas_cached_only"]}
["VÉHICULE DE CATÉGORIE M1\nCALCUL DE RÉPARTITION DES CHARGES"]
[]
["Ne remplir que les cases grisées – Ne saisir aucune unité (m, kg, L, %), seulement des chiffres"]
[]
[null,"Demandeur"]
[null,"Véhicule :   marque"]
[null,"                  type"]
[null,"                  VIN"]
[null,"                  Immatriculation"]
[null,"                  Date de mise en circulation (jj/mm/aaaa)"]
[null,"Date"]
[null,"Signature"]
[]
[]
[null,"Masse maximale techniquement autorisée","MMTA (COC 16.1)"]
[null,"Poids total autorisé en charge ","PTAC"]
[null,"Nombre de passagers y compris conducteur","N"]
[null,"Longueur","L"]
[]
[null,"DÉTERMINATION DE LA MASSE À VIDE EN ORDRE DE MARCHE"]
[null,"Pesée avant"]
[null,"Pesée arrière"]
[]
[null,null,"Volume","Densité","Distance à l’axe de l’essieu avant","Taux de remplissage lors de la pesée"]
[null,"Carburant",null,0.84]
[null,"GPL",null,0.54]
[null,"Additif",null,1.09]
[]
[null,null,"AV","AR","Total"]
[null,"Masse carburant manquant",0,0,0]
[null,"Masse GPL manquant",0,0,0]
[null,"Masse AdBlue manquant",0,0,0]
[null,"Masse à vide en ordre de marche",0,0,0]
[]
[null,"MASSES MAXIMALES TECHNIQUEMENT ADMISSIBLES",null,null,null,"DÉTERMINATION DE L’EMPATTEMENT THÉORIQUE"]
[null,null,null,"MMTA essieux (COC 16.2)","Théorie",null,"Distance (COC 4.1)"]
[null,"Avant","Essieu 1",null,0]
[null,null,"Essieu 2",null,null,"1-2 : Essieu 1 à essieu 2"]
[null,"Arrière","Essieu 2",null,0,"1-2 : Essieu 1 à essieu 2"]
[null,null,"Essieu 3",null,null,"2-3 : Essieu 2 à essieu 3"]
[null,null,"Essieu 5",null,null,"4-5 : Essieu 4 à essieu 5"]
[null,null,null,null,null,"Empattement théorique =",0]
[]
[null,"RÉPARTITION DE LA MASSE DES OCCUPANTS"]
[null,"Occupants","Distance par rapport à l’essieu avant (m)","Nombre d’occupants"]
[null,"rangée de sièges n°1"]
[null,"rangée de sièges n°2"]
[null,"rangée de sièges n°3"]
[null,"rangée de sièges n°4"]
[null,"rangée de sièges n°5"]
[null,"Emplacement fauteuil roulant n°1"]
[null,"Emplacement fauteuil roulant n°2"]
[null,"Emplacement fauteuil roulant n°3"]
[null,"Emplacement fauteuil roulant n°4"]
[null,"Emplacement fauteuil roulant n°5"]
[]
[null,"CAPACITÉ DE CHARGEMENT"]
[null,"Charge maximale autorisée au point d’attelage","S (COC 19)"]
[null,"Distance du point d’attelage à l’axe du dernier essieu"]
[null,"Distance du point d’attelage à l’axe de l’essieu arrière théorique",null,{"$error":"#DIV/0!"}]
[null,"Distance du point d’attelage à l’axe de l’essieu avant théorique",null,{"$error":"#DIV/0!"}]
[]
[null,"Charge utile marchandises",null,{"$error":"#VALUE!"}]
[]
[null,"RÉPARTITION DE LA CHARGE UTILE SELON 1230/2012"]
[null,null,null," VÉHICULE CHARGÉ JUSQU’À SON PTAC COMPRENANT LA MASSE SUR LE POINT D’ATTELAGE","VÉHICULE CHARGÉ JUSQU’À SON PTAC PLUS LA MASSE SUR LE POINT D’ATTELAGE"]
[null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,null,{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Élément considéré","Distance par rapport à l’essieu avant (m)","masse de l’élément (kg)","masse de l’élément (kg)"]
[null,"Charge maximale autorisée au point d’attelage",0,0]
[null,"Coffre n°1"]
[null,"Coffre n°2"]
[null,"Coffre n°3"]
[null,"Coffre n°4"]
[null,"Coffre n°5"]
[null,"Coffre n°6"]
[null,"Coffre n°7"]
[null,"Coffre n°8"]
[null,"Coffre n°9"]
[null,"Coffre n°10"]
[null,"Coffre n°11"]
[null,"Coffre n°12"]
[null,"Coffre n°13"]
[null,"Coffre n°14"]
[null,"Coffre n°15"]
[null,"Coffre n°16"]
[null,"Coffre n°17"]
[null,"Coffre n°18"]
[null,"Coffre n°19"]
[null,"Coffre n°20"]
[null,"Coffre n°21"]
[null,"Coffre n°22"]
[null,"Coffre n°23"]
[null,"Coffre n°24"]
[null,"Coffre n°25"]
[null,"Coffre n°26"]
[null,"Coffre n°27"]
[null,"Coffre n°28"]
[null,"Coffre n°29"]
[null,"Coffre n°30"]
[]
[null,"RECEVABILITÉ EN AUTOCARAVANE SELON 2018/858 Annexe I partie A §2"]
[null,null,"Valeur","Critère"]
[null,"Charge utile :",{"$error":"#VALUE!"},0]
[]
[null,"VÉRIFICATIONS : VÉHICULE CHARGÉ JUSQU’À SON PTAC SANS MASSE SUR LE POINT D’ATTELAGE"]
[null,null,"Avant","Arrière","Total"]
[null,"Masse à vide en ordre de marche",0,0,0]
[null,"Conducteur et passagers",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Attelage",0,0,0]
[null,"Chargement",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"TOTAL",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Maximum",0,0,0]
[null,"Répartition de charge sur l’avant",{"$error":"#VALUE!"}]
[]
[null,"VÉRIFICATIONS : VÉHICULE CHARGÉ JUSQU’À SON PTAC COMPRENANT LA MASSE SUR LE POINT D’ATTELAGE"]
[null,null,"Avant","Arrière","Total"]
[null,"Masse à vide en ordre de marche",0,0,0]
[null,"Conducteur et passagers",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Attelage",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Chargement",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"TOTAL",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Maximum",0,0,0]
[null,"Répartition de charge sur l’avant",{"$error":"#VALUE!"}]
[]
[null,"VÉRIFICATIONS : VÉHICULE CHARGÉ JUSQU’À SON PTAC PLUS LA MASSE SUR LE POINT D’ATTELAGE"]
[null,null,"Avant","Arrière","Total"]
[null,"Masse à vide en ordre de marche",0,0,0]
[null,"Conducteur et passagers",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Attelage",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Chargement",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"TOTAL",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Maximum",0,0,0]
[null,"Répartition de charge sur l’avant",{"$error":"#VALUE!"}]
[]
[null,{"$error":"#DIV/0!"}]
[null,{"$error":"#VALUE!"}]
[]
[]
[]
[null,"Masse maximale au point d’attelage pour respecter le maxi arrière"]
[null,{"$error":"#DIV/0!"},"PTAC dont attelage"]
[null,{"$error":"#VALUE!"},"PTAC + attelage","Masse au point d’attelage minimale"]
[null,{"$error":"#VALUE!"},"Marge sur PTAC",25]
[null,{"$error":"#DIV/0!"},"Mini","Masse tractable maximale"]
[null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"}]
[]
[]
[null,"Barycentre 3-4 par rapport à 3",{"$error":"#DIV/0!"}]
[null,"Barycentre 3-4-5 par rapport à 3",{"$error":"#DIV/0!"}]
[null,"Barycentre 1-2 par rapport à 1",{"$error":"#DIV/0!"}]
[null,"Empattement théorique",{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[]
[null,{"$error":"#VALUE!"},null,null,null,"Indice mini"]
[null,"Indice suffisant ?","Indice de charge","Masse maximale","Essieu simple",{"$error":"#N/A"}]
[null,{"$error":"#VALUE!"},0,45,90,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},1,46.2,92.4,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},2,47.5,95,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},3,48.7,97.4,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},4,50,100,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},5,51.5,103,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},6,53,106,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},7,54.5,109,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},8,56,112,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},9,58,116,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},10,60,120,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},11,61.5,123,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},12,63,126,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},13,65,130,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},14,67,134,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},15,69,138,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},16,71,142,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},17,73,146,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},18,75,150,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},19,77.5,155,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},20,80,160,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},21,82.5,165,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},22,85,170,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},23,87.5,175,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},24,90,180,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},25,92.5,185,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},26,95,190,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},27,97.5,195,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},28,100,200,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},29,103,206,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},30,106,212,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},31,109,218,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},32,112,224,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},33,115,230,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},34,118,236,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},35,121,242,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},36,125,250,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},37,128,256,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},38,132,264,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},39,136,272,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},40,140,280,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},41,145,290,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},42,150,300,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},43,155,310,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},44,160,320,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},45,165,330,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},46,170,340,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},47,175,350,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},48,180,360,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},49,185,370,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},50,190,380,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},51,195,390,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},52,200,400,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},53,206,412,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},54,212,424,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},55,218,436,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},56,224,448,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},57,230,460,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},58,236,472,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},59,240,480,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},60,250,500,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},61,257,514,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},62,265,530,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},63,272,544,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},64,280,560,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},65,290,580,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},66,300,600,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},67,307,614,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},68,315,630,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},69,325,650,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},70,335,670,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},71,345,690,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},72,355,710,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},73,365,730,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},74,375,750,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},75,387,774,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},76,400,800,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},77,412,824,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},78,425,850,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},79,437,874,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},80,450,900,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},81,462,924,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},82,475,950,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},83,487,974,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},84,500,1000,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},85,515,1030,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},86,530,1060,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},87,545,1090,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},88,560,1120,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},89,580,1160,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},90,600,1200,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},91,615,1230,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},92,630,1260,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},93,650,1300,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},94,670,1340,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},95,690,1380,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},96,710,1420,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},97,730,1460,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},98,750,1500,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},99,775,1550,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},100,800,1600,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},101,825,1650,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},102,850,1700,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},103,875,1750,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},104,900,1800,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},105,925,1850,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},106,950,1900,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},107,975,1950,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},108,1000,2000,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},109,1030,2060,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},110,1060,2120,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},111,1090,2180,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},112,1120,2240,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},113,1150,2300,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},114,1180,2360,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},115,1215,2430,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},116,1250,2500,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},117,1285,2570,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},118,1320,2640,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},119,1360,2720,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},120,1400,2800,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},121,1450,2900,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},122,1500,3000,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},123,1550,3100,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},124,1600,3200,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},125,1650,3300,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},126,1700,3400,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},127,1750,3500,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},128,1800,3600,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},129,1850,3700,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},130,1900,3800,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},131,1950,3900,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},132,2000,4000,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},133,2060,4120,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},134,2120,4240,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},135,2180,4360,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},136,2240,4480,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},137,2300,4600,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},138,2360,4720,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},139,2430,4860,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},140,2500,5000,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},141,2575,5150,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},142,2650,5300,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},143,2725,5450,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},144,2800,5600,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},145,2900,5800,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},146,3000,6000,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},147,3075,6150,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},148,3150,6300,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},149,3250,6500,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},150,3350,6700,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},151,3450,6900,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},152,3550,7100,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},153,3650,7300,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},154,3750,7500,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},155,3875,7750,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},156,4000,8000,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},157,4125,8250,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},158,4250,8500,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},159,4375,8750,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},160,4500,9000,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},161,4625,9250,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},162,4750,9500,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},163,4875,9750,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},164,5000,10000,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},165,5150,10300,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},166,5300,10600,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},167,5450,10900,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},168,5600,11200,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},169,5800,11600,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},170,6000,12000,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},171,6150,12300,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},172,6300,12600,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},173,6500,13000,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},174,6700,13400,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},175,6900,13800,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},176,7100,14200,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},177,7300,14600,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},178,7500,15000,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},179,7750,15500,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},180,8000,16000,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},181,8250,16500,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},182,8500,17000,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},183,8750,17500,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},184,9000,18000,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},185,9250,18500,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},186,9500,19000,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},187,9750,19500,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},188,10000,20000,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},189,10300,20600,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},190,10600,21200,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},191,10900,21800,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},192,11200,22400,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},193,11500,23000,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},194,11800,23600,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},195,12150,24300,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},196,12500,25000,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},197,12850,25700,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},198,13200,26400,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},199,13600,27200,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},200,14000,28000,{"$error":"#VALUE!"}]

{"sheet":"Cat N1","index":3,"n_rows":322,"n_cols":7,"rows_kept":322,"cut":false,"hidden":false,"merged":[[0,0,0,7],[2,0,2,255],[4,2,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[13,1,13,3],[19,1,19,5],[34,1,34,4],[34,5,34,6],[36,1,37,1],[36,4,37,4],[38,1,40,1],[38,4,40,4],[43,1,43,3],[49,1,49,3],[51,1,51,2],[52,1,52,2],[53,1,53,2],[58,1,58,2],[59,1,59,2],[63,1,63,3],[69,1,69,4],[79,1,79,4],[89,1,89,4]],"flags":["formulas_cached_only"]}
["VÉHICULE DE CATÉGORIE N1\nCALCUL DE RÉPARTITION DES CHARGES"]
[]
["Ne remplir que les cases grisées – Ne saisir aucune unité (m, kg, L, %), seulement des chiffres"]
[]
[null,"Demandeur"]
[null,"Véhicule :   marque"]
[null,"                  type"]
[null,"                  VIN"]
[null,"                  Immatriculation"]
[null,"                  Date de mise en circulation (jj/mm/aaaa)"]
[null,"Date"]
[null,"Signature"]
[]
[]
[null,"Masse maximale techniquement autorisée","MMTA (COC 16.1)",null,null,"Longueur"]
[null,"Poids total autorisé en charge ","PTAC",null,null,"Largeur"]
[null,"Nombre de passagers y compris conducteur","N",null,null,"Surface",0]
[null,"Code carrosserie","COC 38","BB (Fourgon)"]
[]
[null,"DÉTERMINATION DE LA MASSE À VIDE EN ORDRE DE MARCHE"]
[null,"Pesée avant"]
[null,"Pesée arrière"]
[]
[null,null,"Volume","Densité","Distance à l’axe de l’essieu avant","Taux de remplissage lors de la pesée"]
[null,"Carburant",null,0.84]
[null,"GPL",null,0.54]
[null,"Additif",null,1.09]
[]
[null,null,"AV","AR","Total"]
[null,"Masse carburant manquant",0,0,0]
[null,"Masse GPL manquant",0,0,0]
[null,"Masse AdBlue manquant",0,0,0]
[null,"Masse à vide en ordre de marche",0,0,0]
[]
[null,"MASSES MAXIMALES TECHNIQUEMENT ADMISSIBLES",null,null,null,"DÉTERMINATION DE L’EMPATTEMENT THÉORIQUE"]
[null,null,null,"MMTA essieux (COC 16.2)","Théorie",null,"Distance (COC 4.1)"]
[null,"Avant","Essieu 1",null,0]
[null,null,"Essieu 2",null,null,"1-2 : Essieu 1 à essieu 2"]
[null,"Arrière","Essieu 2",null,0,"1-2 : Essieu 1 à essieu 2"]
[null,null,"Essieu 3",null,null,"2-3 : Essieu 2 à essieu 3"]
[null,null,"Essieu 5",null,null,"4-5 : Essieu 4 à essieu 5"]
[null,null,null,null,null,"Empattement théorique =",0]
[]
[null,"RÉPARTITION DE LA MASSE DES OCCUPANTS"]
[null,"Occupants","Distance par rapport à l’essieu avant (m)","Nombre d’occupants"]
[null,"rangée de sièges n°1"]
[null,"rangée de sièges n°2"]
[null,"rangée de sièges n°3"]
[]
[null,"CAPACITÉ DE CHARGEMENT"]
[null,"Charge maximale autorisée au point d’attelage","S (COC 19)"]
[null,"Distance du point d’attelage à l’axe du dernier essieu"]
[null,"Distance du point d’attelage à l’axe de l’essieu arrière théorique",null,{"$error":"#DIV/0!"}]
[null,"Distance du point d’attelage à l'essieu avant théorique",null,{"$error":"#VALUE!"}]
[]
[null,"Longueur de la zone de cargaison"]
[null,"Porte-à-faux arrière utile à l’axe du dernier essieu"]
[null,"Porte-à-faux arrière utile à l’axe de l’essieu théorique",null,{"$error":"#DIV/0!"}]
[null,"Distance du centre de gravité du chargement à l'essieu arrière théorique",null,{"$error":"#DIV/0!"}]
[null,"Distance du centre de gravité du chargement à l'essieu avant théorique",null,{"$error":"#VALUE!"}]
[]
[null,"Charge utile marchandises",null,{"$error":"#VALUE!"}]
[]
[null,"RECEVABILITÉ EN CATÉGORIE N SELON 2018/858 Annexe I partie A §3"]
[null,null,"Valeur","Critère"]
[null,"Nombre de places :",0,7]
[null,"Charge utile :",{"$error":"#VALUE!"},100]
[null,0,0,{"$error":"#VALUE!"}]
[]
[null,"VÉRIFICATIONS : VÉHICULE CHARGÉ JUSQU’À SON PTAC SANS MASSE SUR LE POINT D’ATTELAGE"]
[null,null,"Avant","Arrière","Total"]
[null,"Masse à vide en ordre de marche",0,0,0]
[null,"Conducteur et passagers",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Attelage",0,0,0]
[null,"Chargement",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"TOTAL",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Maximum",0,0,0]
[null,"Répartition de charge sur l’avant",{"$error":"#VALUE!"}]
[]
[null,"VÉRIFICATIONS : VÉHICULE CHARGÉ JUSQU’À SON PTAC COMPRENANT LA MASSE SUR LE POINT D’ATTELAGE"]
[null,null,"Avant","Arrière","Total"]
[null,"Masse à vide en ordre de marche",0,0,0]
[null,"Conducteur et passagers",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Attelage",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Chargement",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"TOTAL",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Maximum",0,0,0]
[null,"Répartition de charge sur l’avant",{"$error":"#VALUE!"}]
[]
[null,"VÉRIFICATIONS : VÉHICULE CHARGÉ JUSQU’À SON PTAC PLUS LA MASSE SUR LE POINT D’ATTELAGE"]
[null,null,"Avant","Arrière","Total"]
[null,"Masse à vide en ordre de marche",0,0,0]
[null,"Conducteur et passagers",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Attelage",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Chargement",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"TOTAL",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,"Maximum",0,0,0]
[null,"Répartition de charge sur l’avant",{"$error":"#VALUE!"}]
[]
[null,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"}]
[]
[]
[null,"Masse maximale au point d’attelage pour respecter le maxi arrière"]
[null,{"$error":"#VALUE!"},"PTAC dont attelage"]
[null,{"$error":"#VALUE!"},"PTAC + attelage","Masse au point d’attelage minimale"]
[null,{"$error":"#VALUE!"},"Marge sur PTAC",25]
[null,{"$error":"#VALUE!"},"Mini","Masse tractable maximale"]
[null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"}]
[]
[null,"Barycentre 3-4 par rapport à 3",{"$error":"#DIV/0!"}]
[null,"Barycentre 3-4-5 par rapport à 3",{"$error":"#DIV/0!"}]
[null,"Barycentre 1-2 par rapport à 1",{"$error":"#DIV/0!"}]
[null,"Empattement théorique",{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[]
[null,{"$error":"#VALUE!"},null,null,null,"Indice mini"]
[null,"Indice suffisant ?","Indice de charge","Masse maximale","Essieu simple",{"$error":"#N/A"}]
[null,{"$error":"#VALUE!"},0,45,90,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},1,46.2,92.4,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},2,47.5,95,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},3,48.7,97.4,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},4,50,100,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},5,51.5,103,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},6,53,106,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},7,54.5,109,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},8,56,112,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},9,58,116,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},10,60,120,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},11,61.5,123,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},12,63,126,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},13,65,130,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},14,67,134,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},15,69,138,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},16,71,142,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},17,73,146,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},18,75,150,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},19,77.5,155,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},20,80,160,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},21,82.5,165,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},22,85,170,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},23,87.5,175,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},24,90,180,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},25,92.5,185,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},26,95,190,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},27,97.5,195,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},28,100,200,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},29,103,206,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},30,106,212,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},31,109,218,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},32,112,224,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},33,115,230,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},34,118,236,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},35,121,242,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},36,125,250,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},37,128,256,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},38,132,264,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},39,136,272,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},40,140,280,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},41,145,290,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},42,150,300,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},43,155,310,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},44,160,320,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},45,165,330,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},46,170,340,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},47,175,350,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},48,180,360,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},49,185,370,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},50,190,380,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},51,195,390,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},52,200,400,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},53,206,412,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},54,212,424,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},55,218,436,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},56,224,448,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},57,230,460,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},58,236,472,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},59,240,480,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},60,250,500,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},61,257,514,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},62,265,530,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},63,272,544,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},64,280,560,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},65,290,580,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},66,300,600,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},67,307,614,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},68,315,630,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},69,325,650,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},70,335,670,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},71,345,690,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},72,355,710,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},73,365,730,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},74,375,750,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},75,387,774,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},76,400,800,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},77,412,824,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},78,425,850,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},79,437,874,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},80,450,900,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},81,462,924,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},82,475,950,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},83,487,974,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},84,500,1000,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},85,515,1030,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},86,530,1060,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},87,545,1090,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},88,560,1120,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},89,580,1160,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},90,600,1200,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},91,615,1230,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},92,630,1260,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},93,650,1300,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},94,670,1340,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},95,690,1380,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},96,710,1420,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},97,730,1460,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},98,750,1500,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},99,775,1550,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},100,800,1600,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},101,825,1650,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},102,850,1700,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},103,875,1750,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},104,900,1800,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},105,925,1850,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},106,950,1900,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},107,975,1950,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},108,1000,2000,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},109,1030,2060,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},110,1060,2120,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},111,1090,2180,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},112,1120,2240,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},113,1150,2300,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},114,1180,2360,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},115,1215,2430,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},116,1250,2500,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},117,1285,2570,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},118,1320,2640,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},119,1360,2720,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},120,1400,2800,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},121,1450,2900,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},122,1500,3000,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},123,1550,3100,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},124,1600,3200,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},125,1650,3300,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},126,1700,3400,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},127,1750,3500,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},128,1800,3600,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},129,1850,3700,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},130,1900,3800,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},131,1950,3900,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},132,2000,4000,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},133,2060,4120,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},134,2120,4240,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},135,2180,4360,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},136,2240,4480,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},137,2300,4600,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},138,2360,4720,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},139,2430,4860,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},140,2500,5000,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},141,2575,5150,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},142,2650,5300,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},143,2725,5450,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},144,2800,5600,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},145,2900,5800,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},146,3000,6000,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},147,3075,6150,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},148,3150,6300,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},149,3250,6500,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},150,3350,6700,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},151,3450,6900,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},152,3550,7100,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},153,3650,7300,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},154,3750,7500,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},155,3875,7750,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},156,4000,8000,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},157,4125,8250,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},158,4250,8500,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},159,4375,8750,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},160,4500,9000,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},161,4625,9250,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},162,4750,9500,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},163,4875,9750,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},164,5000,10000,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},165,5150,10300,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},166,5300,10600,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},167,5450,10900,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},168,5600,11200,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},169,5800,11600,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},170,6000,12000,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},171,6150,12300,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},172,6300,12600,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},173,6500,13000,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},174,6700,13400,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},175,6900,13800,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},176,7100,14200,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},177,7300,14600,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},178,7500,15000,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},179,7750,15500,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},180,8000,16000,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},181,8250,16500,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},182,8500,17000,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},183,8750,17500,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},184,9000,18000,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},185,9250,18500,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},186,9500,19000,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},187,9750,19500,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},188,10000,20000,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},189,10300,20600,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},190,10600,21200,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},191,10900,21800,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},192,11200,22400,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},193,11500,23000,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},194,11800,23600,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},195,12150,24300,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},196,12500,25000,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},197,12850,25700,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},198,13200,26400,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},199,13600,27200,{"$error":"#VALUE!"}]
[null,{"$error":"#VALUE!"},200,14000,28000,{"$error":"#VALUE!"}]

{"sheet":"Cat N2-N3","index":4,"n_rows":104,"n_cols":7,"rows_kept":104,"cut":false,"hidden":false,"merged":[[0,0,0,7],[2,0,2,255],[4,2,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[13,1,13,3],[18,1,18,6],[32,1,32,4],[32,5,32,6],[34,1,35,1],[34,4,35,4],[36,1,38,1],[36,4,38,4],[41,1,41,4],[47,1,47,3],[49,1,49,2],[50,1,50,2],[55,1,55,2],[59,1,59,3],[60,1,61,2],[76,1,76,3]],"flags":["formulas_cached_only"]}
["VÉHICULE DE CATÉGORIE N2/N3\nCALCUL DE RÉPARTITION DES CHARGES"]
[]
["Ne remplir que les cases grisées – Ne saisir aucune unité (m, kg, L, %), seulement des chiffres"]
[]
[null,"Demandeur"]
[null,"Véhicule :   marque"]
[null,"                  type"]
[null,"                  VIN"]
[null,"                  Immatriculation"]
[null,"                  Date de mise en circulation (jj/mm/aaaa)"]
[null,"Date"]
[null,"Signature"]
[]
[]
[null,"Masse maximale techniquement autorisée","MMTA (COC 16.1)",null,null,"Longueur"]
[null,"Poids total autorisé en charge ","PTAC",null,null,"Largeur"]
[null,"Nombre de passagers y compris conducteur","N",null,null,"Surface",0]
[]
[null,"DÉTERMINATION DE LA MASSE À VIDE EN ORDRE DE MARCHE"]
[null,"Pesée avant"]
[null,"Pesée arrière"]
[]
[null,null,"Volume","Densité","Distance à l’axe de l’essieu 1","Distance à l’axe de l’essieu avant théorique","Taux de remplissage lors de la pesée"]
[null,"Carburant 1",null,0.84,null,0]
[null,"Carburant 2",null,0.84,null,0]
[null,"Additif",null,1.09,null,0]
[]
[null,null,"AV","AR","Total"]
[null,"Masse carburant manquant",0,0,0]
[null,"Masse AdBlue manquant",0,0,0]
[null,"Masse à vide en ordre de marche",0,0,0]
[]
[null,"MASSES MAXIMALES TECHNIQUEMENT ADMISSIBLES",null,null,null,"DÉTERMINATION DE L’EMPATTEMENT THÉORIQUE"]
[null,null,null,"MMTA essieux (COC 16.2)","Théorie",null,"Distance (COC 4.1)"]
[null,"Avant","Essieu 1",null,0]
[null,null,0,null,null,0]
[null,"Arrière",0,null,0,0]
[null,null,0,null,null,0]
[null,null,0,null,null,0]
[null,null,null,null,null,"Empattement théorique =",0]
[]
[null,"RÉPARTITION DE LA MASSE DES OCCUPANTS"]
[null,"Occupants","Distance par rapport à l’essieu 1 (m)","Distance par rapport à l’essieu avant théorique","Nombre d’occupants"]
[null,"rangée de sièges n°1",null,{"$error":"#DIV/0!"}]
[null,"rangée de sièges n°2",null,{"$error":"#DIV/0!"}]
[null,"rangée de sièges n°3",null,{"$error":"#DIV/0!"}]
[]
[null,"CAPACITÉ DE CHARGEMENT"]
[null,"Charge maximale autorisée au point d’attelage","S (COC 19)"]
[null,"Distance du point d’attelage à l’axe du dernier essieu"]
[null,"Distance du point d’attelage à l’axe de l’essieu arrière théorique",null,{"$error":"#DIV/0!"}]
[]
[null,"Longueur de la zone de cargaison"]
[null,"Porte-à-faux arrière utile à l’axe du dernier essieu"]
[null,"Porte-à-faux arrière utile à l’axe de l’essieu théorique",null,{"$error":"#DIV/0!"}]
[null,"Distance du centre de gravité du chargement à l'essieu arrière théorique",null,{"$error":"#DIV/0!"}]
[]
[null,"Charge utile marchandises",null,{"$error":"#VALUE!"}]
[]
[null,"RÉPARTITION DE LA CHARGE UTILE SELON 1230/2012"]
[null,null,null,{"$error":"#VALUE!"}]
[null,null,null,{"$error":"#VALUE!"}]
[null,"Élément considéré","Distance par rapport à l’essieu 1 (m)","masse de l’élément (kg)","Distance par rapport à l’axe de l’essieu avant théorique"]
[null,"Charge maximale autorisée au point d’attelage",0,0,{"$error":"#DIV/0!"}]
[null,"Coffre n°1",null,null,{"$error":"#DIV/0!"}]
[null,"Coffre n°2",null,null,{"$error":"#DIV/0!"}]
[null,"Coffre n°3",null,null,{"$error":"#DIV/0!"}]
[null,"Coffre n°4",null,null,{"$error":"#DIV/0!"}]
[null,"Coffre n°5",null,null,{"$error":"#DIV/0!"}]
[null,"Coffre n°6",null,null,{"$error":"#DIV/0!"}]
[null,"Coffre n°7",null,null,{"$error":"#DIV/0!"}]
[null,"Coffre n°8",null,null,{"$error":"#DIV/0!"}]
[null,"Coffre n°9",null,null,{"$error":"#DIV/0!"}]
[null,"Coffre n°10",null,null,{"$error":"#DIV/0!"}]
[null,"Chargement dans la zone de cargaison",{"$error":"#VALUE!"},null,{"$error":"#VALUE!"}]
[]
[null,"RECEVABILITÉ EN CATÉGORIE N SELON 2018/858 Annexe I partie A §3"]
[null,null,"Valeur","Critère"]
[null,"Nombre de places :",0,7]
[null,"Charge utile :",{"$error":"#VALUE!"},100]
[]
[null,null,"Avant","Arrière","Total"]
[null,"Masse à vide en ordre de marche",0,0,0]
[null,"Conducteur et passagers",{"$error":"#VALUE!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Attelage",{"$error":"#VALUE!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Chargement",{"$error":"#VALUE!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"TOTAL",{"$error":"#VALUE!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Maximum",0,0,0]
[]
[null,{"$error":"#DIV/0!"}]
[null,{"$error":"#DIV/0!"}]
[]
[null,"Barycentre 3-4 par rapport à 3",{"$error":"#DIV/0!"}]
[null,"Barycentre 3-4-5 par rapport à 3",{"$error":"#DIV/0!"}]
[null,"Barycentre 1-2 par rapport à 1",{"$error":"#DIV/0!"}]
[null,"Empattement théorique",{"$error":"#DIV/0!"}]
[]
[null,"Charge maximale au point d’attelage pour respecter le maxi arrière"]
[null,null,{"$error":"#DIV/0!"}]
[null,null,null,"Masse au point d’attelage minimale"]
[null,null,null,25]
[null,null,null,"Masse tractable maximale"]
[null,null,null,{"$error":"#DIV/0!"}]
[null,{"$error":"#DIV/0!"}]

{"sheet":"Benne Amovible","index":5,"n_rows":91,"n_cols":7,"rows_kept":91,"cut":false,"hidden":false,"merged":[[0,0,0,7],[2,0,2,255],[4,2,4,3],[5,2,5,3],[6,2,6,3],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[13,1,13,3],[18,1,18,6],[32,1,32,4],[32,5,32,6],[34,1,35,1],[34,4,35,4],[36,1,38,1],[36,4,38,4],[41,1,41,4],[47,1,47,3],[49,1,49,2],[50,1,50,2],[51,1,51,2],[52,1,52,2],[55,1,55,3],[68,1,68,5],[69,1,69,4]],"flags":["formulas_cached_only"]}
["VÉHICULE DE CATÉGORIE N\nCALCUL DE RÉPARTITION DES CHARGES POUR UNE BENNE AMOVIBLE"]
[]
["Ne remplir que les cases grisées – Ne saisir aucune unité (m, kg, L, %), seulement des chiffres"]
[]
[null,"Demandeur"]
[null,"Véhicule :   marque"]
[null,"                  type"]
[null,"                  VIN"]
[null,"                  Immatriculation"]
[null,"                  Date de mise en circulation (jj/mm/aaaa)"]
[null,"Date"]
[null,"Signature"]
[]
[]
[null,"Masse maximale techniquement autorisée","MMTA (COC 16.1)",null,null,"Longueur"]
[null,"Poids total autorisé en charge ","PTAC",null,null,"Largeur"]
[null,"Nombre de passagers y compris conducteur","N",null,null,"Surface",0]
[]
[null,"DÉTERMINATION DE LA MASSE À VIDE EN ORDRE DE MARCHE"]
[null,"Pesée avant"]
[null,"Pesée arrière"]
[]
[null,null,"Volume","Densité","Distance à l’axe de l’essieu 1","Distance à l’axe de l’essieu avant théorique","Taux de remplissage lors de la pesée"]
[null,"Carburant 1",null,0.84,null,0]
[null,"Carburant 2",null,0.84,null,0]
[null,"Additif",null,1.09,null,0]
[]
[null,null,"AV","AR","Total"]
[null,"Masse carburant manquant",0,0,0]
[null,"Masse AdBlue manquant",0,0,0]
[null,"Masse à vide en ordre de marche",0,0,0]
[]
[null,"MASSES MAXIMALES TECHNIQUEMENT ADMISSIBLES",null,null,null,"DÉTERMINATION DE L’EMPATTEMENT THÉORIQUE"]
[null,null,null,"MMTA essieux (COC 16.2)","Théorie",null,"Distance (COC 4.1)"]
[null,"Avant","Essieu 1",null,0]
[null,null,0,null,null,0]
[null,"Arrière",0,null,0,0]
[null,null,0,null,null,0]
[null,null,0,null,null,0]
[null,null,null,null,null,"Empattement théorique =",0]
[]
[null,"RÉPARTITION DE LA MASSE DES OCCUPANTS"]
[null,"Occupants","Distance par rapport à l’essieu 1 (m)","Distance par rapport à l’essieu avant théorique","Nombre d’occupants"]
[null,"rangée de sièges n°1",null,{"$error":"#DIV/0!"}]
[null,"rangée de sièges n°2",null,{"$error":"#DIV/0!"}]
[null,"rangée de sièges n°3",null,{"$error":"#DIV/0!"}]
[]
[null,"CAPACITÉ DE CHARGEMENT"]
[null,"Charge maximale autorisée au point d’attelage","S (COC 19)"]
[null,"Distance du point d’attelage à l’axe du dernier essieu"]
[null,"Distance du point d’attelage à l’axe de l’essieu arrière théorique",null,{"$error":"#DIV/0!"}]
[null,"Distance du point d’attelage à l’axe de l’essieu avant théorique",null,{"$error":"#DIV/0!"}]
[null,"Longueur utile de chargement de la benne sur le véhicule"]
[null,"Porte-à-faux arrière utile à l’axe du dernier essieu"]
[]
[null,"RECEVABILITÉ EN CATÉGORIE N SELON 2018/858 Annexe I partie A §3"]
[null,null,"Valeur","Critère"]
[null,"Nombre de places :",0,7]
[null,"Charge utile :",{"$error":"#VALUE!"},100]
[]
[null,null,"Avant","Arrière","Total"]
[null,"Masse à vide en ordre de marche",0,0,0]
[null,"Conducteur et passagers",{"$error":"#VALUE!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Attelage",{"$error":"#VALUE!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Maximum",0,0,0]
[null,"Chargement maximal",{"$error":"#VALUE!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Chargement minimal",{"$error":"#VALUE!"}]
[]
[null,"POSITIONS EXTRÊMES DU CENTRE DE GRAVITÉ DE LA BENNE AMOVIBLE"]
[null,"Porte-à-faux arrière maximal à l’axe du dernier essieu compte-tenu des caractéristiques du dispositif anti-encastrement :"]
[null,null,null,"par rapport à l’essieu arrière théorique","par rapport au dernier essieu","Longueur maximale de la benne"]
[null,null,"Ymax",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,"Ymin",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[null,"Avec une remorque attelée","Ymax",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,"Ymin",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[null,"Sans remorque attelée","Ymax",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[null,null,"Ymin",{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"}]
[]
[]
[]
[]
[null,"Barycentre 3-4 par rapport à 3",{"$error":"#DIV/0!"}]
[null,"Barycentre 3-4-5 par rapport à 3",{"$error":"#DIV/0!"}]
[null,"Barycentre 1-2 par rapport à 1",{"$error":"#DIV/0!"}]
[null,"Empattement théorique",{"$error":"#DIV/0!"}]
[]
[null,"Charge maximale au point d’attelage pour respecter le maxi arrière"]
[]
[null,"Longueur maximale de la benne selon la BAE",0]
[null,"Centre de gravité d’une telle benne par rapport au dernier essieu",0]