{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Deckblatt","über 3,5 - 8,5 t","über 8,5 - 18 t","über 18 - 26 t","über 26 t"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Deckblatt","index":0,"n_rows":31,"n_cols":10,"rows_kept":31,"cut":false,"hidden":false,"merged":[[21,3,21,9],[13,1,13,10],[16,1,16,10],[17,1,17,3],[27,1,27,10],[30,2,30,3],[30,8,30,9],[18,1,18,10],[20,3,20,9],[22,3,22,9],[24,4,24,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"Année civile",null,null,null,null,null,"Vers. 2024"]
[null,null,null,"(période fiscale)"]
[]
[]
[null,"Déclaration pour une éventuelle perception subséquente de la RPLF pour les véhicules                                                 utilisés en trafic de ligne (tableaux 2 à 5; art. 9 ORPL)"]
[null,"Remarque: en font notamment partie les courses d'essai, les transports scolaires, ainsi que les parcours effectués en vue de"]
[null,"l'entretien ou du contrôle du véhicule."]
[null,"La déclaration doit être déposée à l'Office fédéral de la douane et de la sécurité des frontières OFDF, Redevances sur la circulation, "]
[null,"3003 Berne, pour le 30 juin",null,null,", faute de quoi la redevance pleine est due (art. 78 ORPL)."]
[]
[]
[null,"Maison:"]
[null,"N° de concession :"]
[null,"Adresse :"]
[]
[null,"Nombre de véhicules:",null,null,null,null,null,null,"Totale: ",{"$f":"IF('über 3,5 - 8,5 t'!L209+'über 8,5 - 18 t'!L207+'über 18 - 26 t'!L215+'über 26 t'!L385<10.01,0,'über 3,5 - 8,5 t'!L209+'über 8,5 - 18 t'!L207+'über 18 - 26 t'!L215+'über 26 t'!L385)","v":0}]
[null,"(poids total dépassant 3,5 t)"]
[]
[null,"J'atteste que les données figurant dans la déclaration ci-dessus sont correctes et conformes aux dossiers. Je prends connaissance du fait qu'une fausse déclaration constitue une infraction au sens de l'art. 20, al. 1, LRPL."]
[]
[]
[null,"Date :",null,null,null,null,"Signature:"]

{"sheet":"über 3,5 - 8,5 t","index":1,"n_rows":209,"n_cols":12,"rows_kept":209,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["Déclaration pour une éventuelle perception subséquente pour véhicules de ligne d'un poids total de plus de 3,5 t jusqu'à 8,5 t au taux de 2200 fr."]
[]
["N° matricule","Plaque de","Marque ","Km au 1.1","Km au 31.12","Kilomé-","Km hors","Pourcen-","immatriculé",null,"Total "]
["selon permis","contrôle",null,"ou lors de","ou lors mise","trage","trafic de ","tage","du","au","jours","Montant"]
["de circulation",null,null,"l'immatric.","hors circul.","annuel","ligne",null,"(J.M.A. 1)"]
[null,null,null,null,null,{"$f":"E11-D11","v":0},null,{"$f":" IF(F11>0,ROUNDUP(G11/F11,6),0)","v":0},null,null,{"$f":"IF(SUM(J11-I11+1)>365,365,SUM(J11-I11+1))","v":1},{"$f":"ROUNDUP(K11*2200*H11/365*20,0)/20","v":0}]
[null,null,null,null,null,{"$f":"E12-D12","v":0},null,0,null,null,1,{"$f":"ROUNDUP(K12*2200*H12/365*20,0)/20","v":0}]
[null,null,null,null,null,0,null,0,null,null,1,{"$f":"ROUNDUP(K13*2200*H13/365*20,0)/20","v":0}]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,{"$f":"E18-D18","v":0},null,{"$f":" IF(F18>0,ROUNDUP(G18/F18,6),0)","v":0},null,null,{"$f":"IF(SUM(J18-I18+1)>365,365,SUM(J18-I18+1))","v":1},0]
[null,null,null,null,null,{"$f":"E19-D19","v":0},null,{"$f":" IF(F19>0,ROUNDUP(G19/F19,6),0)","v":0},null,null,{"$f":"IF(SUM(J19-I19+1)>365,365,SUM(J19-I19+1))","v":1},0]
[null,null,null,null,null,{"$f":"E20-D20","v":0},null,{"$f":" IF(F20>0,ROUNDUP(G20/F20,6),0)","v":0},null,null,{"$f":"IF(SUM(J20-I20+1)>365,365,SUM(J20-I20+1))","v":1},0]
[null,null,null,null,null,{"$f":"E21-D21","v":0},null,{"$f":" IF(F21>0,ROUNDUP(G21/F21,6),0)","v":0},null,null,{"$f":"IF(SUM(J21-I21+1)>365,365,SUM(J21-I21+1))","v":1},0]
[null,null,null,null,null,{"$f":"E22-D22","v":0},null,{"$f":" IF(F22>0,ROUNDUP(G22/F22,6),0)","v":0},null,null,{"$f":"IF(SUM(J22-I22+1)>365,365,SUM(J22-I22+1))","v":1},0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,{"$f":"ROUNDUP(K35*2200*H35/365*20,0)/20","v":0}]
[]
["1) = jour, mois, année",null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(L11:L35)","v":0}]
[]
[]
[]
["N° matricule","Plaque de","Marque ","Km au 1.1","Km au 31.12","Kilomé-","Km hors","Pourcen-","immatriculé",null,"Total "]
["selon permis","contrôle",null,"ou lors de","ou lors mise","trage","trafic de ","tage","du","au","jours","Montant"]
["de circulation",null,null,"l'immatric.","hors circul.","annuel","ligne",null,"(J.M.A. 1)"]
[null,null,null,null,null,{"$f":"E44-D44","v":0},null,{"$f":" IF(F44>0,ROUNDUP(G44/F44,6),0)","v":0},null,null,{"$f":"IF(SUM(J44-I44+1)>365,365,SUM(J44-I44+1))","v":1},{"$f":"ROUNDUP(K44*2200*H44/365*20,0)/20","v":0}]
[null,null,null,null,null,{"$f":"E45-D45","v":0},null,{"$f":" IF(F45>0,ROUNDUP(G45/F45,6),0)","v":0},null,null,{"$f":"IF(SUM(J45-I45+1)>365,365,SUM(J45-I45+1))","v":1},{"$f":"ROUNDUP(K45*2200*H45/365*20,0)/20","v":0}]
[null,null,null,null,null,{"$f":"E46-D46","v":0},null,{"$f":" IF(F46>0,ROUNDUP(G46/F46,6),0)","v":0},null,null,{"$f":"IF(SUM(J46-I46+1)>365,365,SUM(J46-I46+1))","v":1},{"$f":"ROUNDUP(K46*2200*H46/365*20,0)/20","v":0}]
[null,null,null,null,null,{"$f":"E47-D47","v":0},null,{"$f":" IF(F47>0,ROUNDUP(G47/F47,6),0)","v":0},null,null,{"$f":"IF(SUM(J47-I47+1)>365,365,SUM(J47-I47+1))","v":1},0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,{"$f":"E56-D56","v":0},null,{"$f":" IF(F56>0,ROUNDUP(G56/F56,6),0)","v":0},null,null,{"$f":"IF(SUM(J56-I56+1)>365,365,SUM(J56-I56+1))","v":1},0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,{"$f":"E65-D65","v":0},null,{"$f":" IF(F65>0,ROUNDUP(G65/F65,6),0)","v":0},null,null,{"$f":"IF(SUM(J65-I65+1)>365,365,SUM(J65-I65+1))","v":1},0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,{"$f":"ROUNDUP(K76*2200*H76/365*20,0)/20","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L42:L74)","v":0}]
[]
["1) = jour, mois, année",null,null,null,null,null,null,null,null,"Total",null,{"$f":"L78+L37","v":0}]
[]
[]
[]
["N° matricule","Plaque de","Marque ","Km au 1.1","Km au 31.12","Kilomé-","Km hors","Pourcen-","immatriculé",null,"Total "]
["selon permis","contrôle",null,"ou lors de","ou lors mise","trage","trafic de ","tage","du","au","jours","Montant"]
["de circulation",null,null,"l'immatric.","hors circul.","annuel","ligne",null,"(J.M.A. 1)"]
[null,null,null,null,null,{"$f":"E87-D87","v":0},null,{"$f":" IF(F87>0,ROUNDUP(G87/F87,6),0)","v":0},null,null,{"$f":"IF(SUM(J87-I87+1)>365,365,SUM(J87-I87+1))","v":1},{"$f":"ROUNDUP(K87*2200*H87/365*20,0)/20","v":0}]
[null,null,null,null,null,{"$f":"E88-D88","v":0},null,0,null,null,1,{"$f":"ROUNDUP(K88*2200*H88/365*20,0)/20","v":0}]
[null,null,null,null,null,0,null,0,null,null,1,{"$f":"ROUNDUP(K89*2200*H89/365*20,0)/20","v":0}]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,{"$f":"E103-D103","v":0},null,{"$f":" IF(F103>0,ROUNDUP(G103/F103,6),0)","v":0},null,null,{"$f":"IF(SUM(J103-I103+1)>365,365,SUM(J103-I103+1))","v":1},0]
[null,null,null,null,null,{"$f":"E104-D104","v":0},null,{"$f":" IF(F104>0,ROUNDUP(G104/F104,6),0)","v":0},null,null,{"$f":"IF(SUM(J104-I104+1)>365,365,SUM(J104-I104+1))","v":1},0]
[null,null,null,null,null,{"$f":"E105-D105","v":0},null,{"$f":" IF(F105>0,ROUNDUP(G105/F105,6),0)","v":0},null,null,{"$f":"IF(SUM(J105-I105+1)>365,365,SUM(J105-I105+1))","v":1},0]
[null,null,null,null,null,{"$f":"E106-D106","v":0},null,{"$f":" IF(F106>0,ROUNDUP(G106/F106,6),0)","v":0},null,null,{"$f":"IF(SUM(J106-I106+1)>365,365,SUM(J106-I106+1))","v":1},0]
[null,null,null,null,null,{"$f":"E107-D107","v":0},null,{"$f":" IF(F107>0,ROUNDUP(G107/F107,6),0)","v":0},null,null,{"$f":"IF(SUM(J107-I107+1)>365,365,SUM(J107-I107+1))","v":1},0]
[null,null,null,null,null,{"$f":"E108-D108","v":0},null,{"$f":" IF(F108>0,ROUNDUP(G108/F108,6),0)","v":0},null,null,{"$f":"IF(SUM(J108-I108+1)>365,365,SUM(J108-I108+1))","v":1},0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,{"$f":"ROUNDUP(K119*2200*H119/365*20,0)/20","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L85:L117)","v":0}]
[]
["1) = jour, mois, année",null,null,null,null,null,null,null,null,"Total",null,{"$f":"L121+L78+L37","v":0}]
[]
[]
[]
["N° matricule","Plaque de","Marque ","Km au 1.1","Km au 31.12","Kilomé-","Km hors","Pourcen-","immatriculé",null,"Total "]
["selon permis","contrôle",null,"ou lors de","ou lors mise","trage","trafic de ","tage","du","au","jours","Montant"]
["de circulation",null,null,"l'immatric.","hors circul.","annuel","ligne",null,"(J.M.A. 1)"]
[null,null,null,null,null,{"$f":"E130-D130","v":0},null,{"$f":" IF(F130>0,ROUNDUP(G130/F130,6),0)","v":0},null,null,{"$f":"IF(SUM(J130-I130+1)>365,365,SUM(J130-I130+1))","v":1},{"$f":"ROUNDUP(K130*2200*H130/365*20,0)/20","v":0}]
[null,null,null,null,null,{"$f":"E131-D131","v":0},null,0,null,null,1,{"$f":"ROUNDUP(K131*2200*H131/365*20,0)/20","v":0}]
[null,null,null,null,null,0,null,0,null,null,1,{"$f":"ROUNDUP(K132*2200*H132/365*20,0)/20","v":0}]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,{"$f":"E146-D146","v":0},null,{"$f":" IF(F146>0,ROUNDUP(G146/F146,6),0)","v":0},null,null,{"$f":"IF(SUM(J146-I146+1)>365,365,SUM(J146-I146+1))","v":1},0]
[null,null,null,null,null,{"$f":"E147-D147","v":0},null,{"$f":" IF(F147>0,ROUNDUP(G147/F147,6),0)","v":0},null,null,{"$f":"IF(SUM(J147-I147+1)>365,365,SUM(J147-I147+1))","v":1},0]
[null,null,null,null,null,{"$f":"E148-D148","v":0},null,{"$f":" IF(F148>0,ROUNDUP(G148/F148,6),0)","v":0},null,null,{"$f":"IF(SUM(J148-I148+1)>365,365,SUM(J148-I148+1))","v":1},0]
[null,null,null,null,null,{"$f":"E149-D149","v":0},null,{"$f":" IF(F149>0,ROUNDUP(G149/F149,6),0)","v":0},null,null,{"$f":"IF(SUM(J149-I149+1)>365,365,SUM(J149-I149+1))","v":1},0]
[null,null,null,null,null,{"$f":"E150-D150","v":0},null,{"$f":" IF(F150>0,ROUNDUP(G150/F150,6),0)","v":0},null,null,{"$f":"IF(SUM(J150-I150+1)>365,365,SUM(J150-I150+1))","v":1},0]
[null,null,null,null,null,{"$f":"E151-D151","v":0},null,{"$f":" IF(F151>0,ROUNDUP(G151/F151,6),0)","v":0},null,null,{"$f":"IF(SUM(J151-I151+1)>365,365,SUM(J151-I151+1))","v":1},0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,{"$f":"ROUNDUP(K162*2200*H162/365*20,0)/20","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L128:L160)","v":0}]
[]
["1) = jour, mois, année",null,null,null,null,null,null,null,null,"Total",null,{"$f":"L121+L78+L37+L164","v":0}]
[]
[]
[]
["N° matricule","Plaque de","Marque ","Km au 1.1","Km au 31.12","Kilomé-","Km hors","Pourcen-","immatriculé",null,"Total "]
["selon permis","contrôle",null,"ou lors de","ou lors mise","trage","trafic de ","tage","du","au","jours","Montant"]
["de circulation",null,null,"l'immatric.","hors circul.","annuel","ligne",null,"(J.M.A. 1)"]
[null,null,null,null,null,{"$f":"E173-D173","v":0},null,{"$f":" IF(F173>0,ROUNDUP(G173/F173,6),0)","v":0},null,null,{"$f":"IF(SUM(J173-I173+1)>365,365,SUM(J173-I173+1))","v":1},{"$f":"ROUNDUP(K173*2200*H173/365*20,0)/20","v":0}]
[null,null,null,null,null,{"$f":"E174-D174","v":0},null,0,null,null,1,{"$f":"ROUNDUP(K174*2200*H174/365*20,0)/20","v":0}]
[null,null,null,null,null,0,null,0,null,null,1,{"$f":"ROUNDUP(K175*2200*H175/365*20,0)/20","v":0}]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,{"$f":"E189-D189","v":0},null,{"$f":" IF(F189>0,ROUNDUP(G189/F189,6),0)","v":0},null,null,{"$f":"IF(SUM(J189-I189+1)>365,365,SUM(J189-I189+1))","v":1},0]
[null,null,null,null,null,{"$f":"E190-D190","v":0},null,{"$f":" IF(F190>0,ROUNDUP(G190/F190,6),0)","v":0},null,null,{"$f":"IF(SUM(J190-I190+1)>365,365,SUM(J190-I190+1))","v":1},0]
[null,null,null,null,null,{"$f":"E191-D191","v":0},null,{"$f":" IF(F191>0,ROUNDUP(G191/F191,6),0)","v":0},null,null,{"$f":"IF(SUM(J191-I191+1)>365,365,SUM(J191-I191+1))","v":1},0]
[null,null,null,null,null,{"$f":"E192-D192","v":0},null,{"$f":" IF(F192>0,ROUNDUP(G192/F192,6),0)","v":0},null,null,{"$f":"IF(SUM(J192-I192+1)>365,365,SUM(J192-I192+1))","v":1},0]
[null,null,null,null,null,{"$f":"E193-D193","v":0},null,{"$f":" IF(F193>0,ROUNDUP(G193/F193,6),0)","v":0},null,null,{"$f":"IF(SUM(J193-I193+1)>365,365,SUM(J193-I193+1))","v":1},0]
[null,null,null,null,null,{"$f":"E194-D194","v":0},null,{"$f":" IF(F194>0,ROUNDUP(G194/F194,6),0)","v":0},null,null,{"$f":"IF(SUM(J194-I194+1)>365,365,SUM(J194-I194+1))","v":1},0]
[null,null,null,null,null,null,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,{"$f":"ROUNDUP(K205*2200*H205/365*20,0)/20","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L171:L203)","v":0}]
[]
["1) = jour, mois, année",null,null,null,null,null,null,null,null,"Total",null,{"$f":"L121+L78+L37+L164+L207","v":0}]

{"sheet":"über 8,5 - 18 t","index":2,"n_rows":207,"n_cols":12,"rows_kept":207,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["Déclaration pour une éventuelle perception subséquente pour véhicules de ligne d'un poids total de plus de 8,5 t jusqu'à 19,5 t au taux de 3300 fr."]
[]
["N° matricule","Plaque de","Marque ","Km au 1.1","Km au 31.12","Kilomé-","Km hors","Pourcen-","immatriculé",null,"Total "]
["selon permis","contrôle",null,"ou lors de","ou lors mise","trage","trafic de ","tage","du","au","jours","Montant"]
["de circulation",null,null,"l'immatric.","hors circul.","annuel","ligne",null,"(J.M.A. 1)"]
[null,null,null,null,null,{"$f":"E11-D11","v":0},null,{"$f":" IF(F11>0,ROUNDUP(G11/F11,6),0)","v":0},null,null,{"$f":"IF(SUM(J11-I11+1)>365,365,SUM(J11-I11+1))","v":1},{"$f":"ROUNDUP(K11*3300*H11/365*20,0)/20","v":0}]
[null,null,null,null,null,{"$f":"E12-D12","v":0},null,0,null,null,1,{"$f":"ROUNDUP(K12*3300*H12/365*20,0)/20","v":0}]
[null,null,null,null,null,0,null,0,null,null,1,{"$f":"ROUNDUP(K13*3300*H13/365*20,0)/20","v":0}]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,{"$f":"E15-D15","v":0},null,{"$f":" IF(F15>0,ROUNDUP(G15/F15,6),0)","v":0},null,null,{"$f":"IF(SUM(J15-I15+1)>365,365,SUM(J15-I15+1))","v":1},{"$f":"ROUNDUP(K15*3300*H15/365*20,0)/20","v":0}]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,{"$f":"ROUNDUP(K36*3300*H36/365*20,0)/20","v":0}]
[]
["1) = jour, mois, année"]
[null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(L11:L36)","v":0}]
[]
[]
[]
["N° matricule","Plaque de","Marque ","Km au 1.1","Km au 31.12","Kilomé-","Km hors","Pourcen-","immatriculé",null,"Total "]
["selon permis","contrôle",null,"ou lors de","ou lors mise","trage","trafic de ","tage","du","au","jours","Montant"]
["de circulation",null,null,"l'immatric.","hors circul.","annuel","ligne",null,"(J.M.A. 1)"]
[null,null,null,null,null,{"$f":"E46-D46","v":0},null,{"$f":" IF(F46>0,ROUNDUP(G46/F46,6),0)","v":0},null,null,{"$f":"IF(SUM(J46-I46+1)>365,365,SUM(J46-I46+1))","v":1},{"$f":"ROUNDUP(K46*3300*H46/365*20,0)/20","v":0}]
[null,null,null,null,null,{"$f":"E47-D47","v":0},null,{"$f":" IF(F47>0,ROUNDUP(G47/F47,6),0)","v":0},null,null,{"$f":"IF(SUM(J47-I47+1)>365,365,SUM(J47-I47+1))","v":1},{"$f":"ROUNDUP(K47*3300*H47/365*20,0)/20","v":0}]
[null,null,null,null,null,{"$f":"E48-D48","v":0},null,{"$f":" IF(F48>0,ROUNDUP(G48/F48,6),0)","v":0},null,null,{"$f":"IF(SUM(J48-I48+1)>365,365,SUM(J48-I48+1))","v":1},0]
[null,null,null,null,null,{"$f":"E49-D49","v":0},null,{"$f":" IF(F49>0,ROUNDUP(G49/F49,6),0)","v":0},null,null,{"$f":"IF(SUM(J49-I49+1)>365,365,SUM(J49-I49+1))","v":1},0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,{"$f":"ROUNDUP(K78*3300*H78/365*20,0)/20","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L46:L78)","v":0}]
["1) = jour, mois, année"]
[null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"L39+L80","v":0}]
[]
[]
[]
["N° matricule","Plaque de","Marque ","Km au 1.1","Km au 31.12","Kilomé-","Km hors","Pourcen-","immatriculé",null,"Total "]
["selon permis","contrôle",null,"ou lors de","ou lors mise","trage","trafic de ","tage","du","au","jours","Montant"]
["de circulation",null,null,"l'immatric.","hors circul.","annuel","ligne",null,"(J.M.A. 1)"]
[null,null,null,null,null,{"$f":"E89-D89","v":0},null,{"$f":" IF(F89>0,ROUNDUP(G89/F89,6),0)","v":0},null,null,{"$f":"IF(SUM(J89-I89+1)>365,365,SUM(J89-I89+1))","v":1},{"$f":"ROUNDUP(K89*3300*H89/365*20,0)/20","v":0}]
[null,null,null,null,null,{"$f":"E90-D90","v":0},null,0,null,null,1,{"$f":"ROUNDUP(K90*3300*H90/365*20,0)/20","v":0}]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,{"$f":"E105-D105","v":0},null,{"$f":" IF(F105>0,ROUNDUP(G105/F105,6),0)","v":0},null,null,{"$f":"IF(SUM(J105-I105+1)>365,365,SUM(J105-I105+1))","v":1},0]
[null,null,null,null,null,{"$f":"E106-D106","v":0},null,{"$f":" IF(F106>0,ROUNDUP(G106/F106,6),0)","v":0},null,null,{"$f":"IF(SUM(J106-I106+1)>365,365,SUM(J106-I106+1))","v":1},0]
[null,null,null,null,null,{"$f":"E107-D107","v":0},null,{"$f":" IF(F107>0,ROUNDUP(G107/F107,6),0)","v":0},null,null,{"$f":"IF(SUM(J107-I107+1)>365,365,SUM(J107-I107+1))","v":1},0]
[null,null,null,null,null,{"$f":"E108-D108","v":0},null,{"$f":" IF(F108>0,ROUNDUP(G108/F108,6),0)","v":0},null,null,{"$f":"IF(SUM(J108-I108+1)>365,365,SUM(J108-I108+1))","v":1},0]
[null,null,null,null,null,{"$f":"E109-D109","v":0},null,{"$f":" IF(F109>0,ROUNDUP(G109/F109,6),0)","v":0},null,null,{"$f":"IF(SUM(J109-I109+1)>365,365,SUM(J109-I109+1))","v":1},0]
[null,null,null,null,null,{"$f":"E110-D110","v":0},null,{"$f":" IF(F110>0,ROUNDUP(G110/F110,6),0)","v":0},null,null,{"$f":"IF(SUM(J110-I110+1)>365,365,SUM(J110-I110+1))","v":1},0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,{"$f":"ROUNDUP(K121*3300*H121/365*20,0)/20","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L89:L121)","v":0}]
["1) = jour, mois, année"]
[null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"L123+L80+L39","v":0}]
[]
["N° matricule","Plaque de","Marque ","Km au 1.1","Km au 31.12","Kilomé-","Km hors","Pourcen-","immatriculé",null,"Total "]
["selon permis","contrôle",null,"ou lors de","ou lors mise","trage","trafic de ","tage","du","au","jours","Montant"]
["de circulation",null,null,"l'immatric.","hors circul.","annuel","ligne",null,"(J.M.A. 1)"]
[null,null,null,null,null,{"$f":"E130-D130","v":0},null,{"$f":" IF(F130>0,ROUNDUP(G130/F130,6),0)","v":0},null,null,{"$f":"IF(SUM(J130-I130+1)>365,365,SUM(J130-I130+1))","v":1},{"$f":"ROUNDUP(K130*3300*H130/365*20,0)/20","v":0}]
[null,null,null,null,null,{"$f":"E131-D131","v":0},null,0,null,null,1,{"$f":"ROUNDUP(K131*3300*H131/365*20,0)/20","v":0}]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,{"$f":"E146-D146","v":0},null,{"$f":" IF(F146>0,ROUNDUP(G146/F146,6),0)","v":0},null,null,{"$f":"IF(SUM(J146-I146+1)>365,365,SUM(J146-I146+1))","v":1},0]
[null,null,null,null,null,{"$f":"E147-D147","v":0},null,{"$f":" IF(F147>0,ROUNDUP(G147/F147,6),0)","v":0},null,null,{"$f":"IF(SUM(J147-I147+1)>365,365,SUM(J147-I147+1))","v":1},0]
[null,null,null,null,null,{"$f":"E148-D148","v":0},null,{"$f":" IF(F148>0,ROUNDUP(G148/F148,6),0)","v":0},null,null,{"$f":"IF(SUM(J148-I148+1)>365,365,SUM(J148-I148+1))","v":1},0]
[null,null,null,null,null,{"$f":"E149-D149","v":0},null,{"$f":" IF(F149>0,ROUNDUP(G149/F149,6),0)","v":0},null,null,{"$f":"IF(SUM(J149-I149+1)>365,365,SUM(J149-I149+1))","v":1},0]
[null,null,null,null,null,{"$f":"E150-D150","v":0},null,{"$f":" IF(F150>0,ROUNDUP(G150/F150,6),0)","v":0},null,null,{"$f":"IF(SUM(J150-I150+1)>365,365,SUM(J150-I150+1))","v":1},0]
[null,null,null,null,null,{"$f":"E151-D151","v":0},null,{"$f":" IF(F151>0,ROUNDUP(G151/F151,6),0)","v":0},null,null,{"$f":"IF(SUM(J151-I151+1)>365,365,SUM(J151-I151+1))","v":1},0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,{"$f":"ROUNDUP(K162*3300*H162/365*20,0)/20","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L130:L162)","v":0}]
["1) = jour, mois, année"]
[null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"L123+L80+L39+L164","v":0}]
[]
["N° matricule","Plaque de","Marque ","Km au 1.1","Km au 31.12","Kilomé-","Km hors","Pourcen-","immatriculé",null,"Total "]
["selon permis","contrôle",null,"ou lors de","ou lors mise","trage","trafic de ","tage","du","au","jours","Montant"]
["de circulation",null,null,"l'immatric.","hors circul.","annuel","ligne",null,"(J.M.A. 1)"]
[null,null,null,null,null,{"$f":"E171-D171","v":0},null,{"$f":" IF(F171>0,ROUNDUP(G171/F171,6),0)","v":0},null,null,{"$f":"IF(SUM(J171-I171+1)>365,365,SUM(J171-I171+1))","v":1},{"$f":"ROUNDUP(K171*3300*H171/365*20,0)/20","v":0}]
[null,null,null,null,null,{"$f":"E172-D172","v":0},null,0,null,null,1,{"$f":"ROUNDUP(K172*3300*H172/365*20,0)/20","v":0}]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,{"$f":"E187-D187","v":0},null,{"$f":" IF(F187>0,ROUNDUP(G187/F187,6),0)","v":0},null,null,{"$f":"IF(SUM(J187-I187+1)>365,365,SUM(J187-I187+1))","v":1},0]
[null,null,null,null,null,{"$f":"E188-D188","v":0},null,{"$f":" IF(F188>0,ROUNDUP(G188/F188,6),0)","v":0},null,null,{"$f":"IF(SUM(J188-I188+1)>365,365,SUM(J188-I188+1))","v":1},0]
[null,null,null,null,null,{"$f":"E189-D189","v":0},null,{"$f":" IF(F189>0,ROUNDUP(G189/F189,6),0)","v":0},null,null,{"$f":"IF(SUM(J189-I189+1)>365,365,SUM(J189-I189+1))","v":1},0]
[null,null,null,null,null,{"$f":"E190-D190","v":0},null,{"$f":" IF(F190>0,ROUNDUP(G190/F190,6),0)","v":0},null,null,{"$f":"IF(SUM(J190-I190+1)>365,365,SUM(J190-I190+1))","v":1},0]
[null,null,null,null,null,{"$f":"E191-D191","v":0},null,{"$f":" IF(F191>0,ROUNDUP(G191/F191,6),0)","v":0},null,null,{"$f":"IF(SUM(J191-I191+1)>365,365,SUM(J191-I191+1))","v":1},0]
[null,null,null,null,null,{"$f":"E192-D192","v":0},null,{"$f":" IF(F192>0,ROUNDUP(G192/F192,6),0)","v":0},null,null,{"$f":"IF(SUM(J192-I192+1)>365,365,SUM(J192-I192+1))","v":1},0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,{"$f":"ROUNDUP(K203*3300*H203/365*20,0)/20","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L171:L203)","v":0}]
["1) = jour, mois, année"]
[null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"L123+L80+L39+L164+L205","v":0}]

{"sheet":"über 18 - 26 t","index":3,"n_rows":215,"n_cols":12,"rows_kept":215,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["Déclaration pour une éventuelle perception subséquente pour véhicules de ligne d'un poids total de plus de 19,5 t jusqu'à 26 t au taux de 4400 fr."]
[]
["N° matricule","Plaque de","Marque ","Km au 1.1","Km au 31.12","Kilomé-","Km hors","Pourcen-","immatriculé",null,"Total "]
["selon permis","contrôle",null,"ou lors de","ou lors mise","trage","trafic de ","tage","du","au","jours","Montant"]
["de circulation",null,null,"l'immatric.","hors circul.","annuel","ligne",null,"(J.M.A. 1)"]
[null,null,null,null,null,{"$f":"E11-D11","v":0},null,{"$f":" IF(F11>0,ROUNDUP(G11/F11,6),0)","v":0},null,null,{"$f":"IF(SUM(J11-I11+1)>365,365,SUM(J11-I11+1))","v":1},{"$f":"ROUNDUP(K11*4400*H11/365*20,0)/20","v":0}]
[null,null,null,null,null,{"$f":"E12-D12","v":0},null,0,null,null,1,{"$f":"ROUNDUP(K12*4400*H12/365*20,0)/20","v":0}]
[null,null,null,null,null,0,null,0,null,null,1,{"$f":"ROUNDUP(K13*4400*H13/365*20,0)/20","v":0}]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,{"$f":"ROUNDUP(K40*4400*H40/365*20,0)/20","v":0}]
[]
["1) = jour, mois, année",null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(L11:L40)","v":0}]
[]
[]
[]
[]
["N° matricule","Plaque de","Marque ","Km au 1.1","Km au 31.12","Kilomé-","Km hors","Pourcen-","immatriculé",null,"Total "]
["selon permis","contrôle",null,"ou lors de","ou lors mise","trage","trafic de ","tage","du","au","jours","Montant"]
["de circulation",null,null,"l'immatric.","hors circul.","annuel","ligne",null,"(J.M.A. 1)"]
[null,null,null,null,null,{"$f":"E50-D50","v":0},null,{"$f":" IF(F50>0,ROUNDUP(G50/F50,6),0)","v":0},null,null,{"$f":"IF(SUM(J50-I50+1)>365,365,SUM(J50-I50+1))","v":1},{"$f":"ROUNDUP(K50*4400*H50/365*20,0)/20","v":0}]
[null,null,null,null,null,{"$f":"E51-D51","v":0},null,{"$f":" IF(F51>0,ROUNDUP(G51/F51,6),0)","v":0},null,null,{"$f":"IF(SUM(J51-I51+1)>365,365,SUM(J51-I51+1))","v":1},{"$f":"ROUNDUP(K51*4400*H51/365*20,0)/20","v":0}]
[null,null,null,null,null,{"$f":"E52-D52","v":0},null,{"$f":" IF(F52>0,ROUNDUP(G52/F52,6),0)","v":0},null,null,{"$f":"IF(SUM(J52-I52+1)>365,365,SUM(J52-I52+1))","v":1},0]
[null,null,null,null,null,{"$f":"E53-D53","v":0},null,{"$f":" IF(F53>0,ROUNDUP(G53/F53,6),0)","v":0},null,null,{"$f":"IF(SUM(J53-I53+1)>365,365,SUM(J53-I53+1))","v":1},0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,{"$f":"ROUNDUP(K82*4400*H82/365*20,0)/20","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L50:L82)","v":0}]
["1) = jour, mois, année"]
[null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"L42+L84","v":0}]
[]
[]
[]
["N° matricule","Plaque de","Marque ","Km au 1.1","Km au 31.12","Kilomé-","Km hors","Pourcen-","immatriculé",null,"Total "]
["selon permis","contrôle",null,"ou lors de","ou lors mise","trage","trafic de ","tage","du","au","jours","Montant"]
["de circulation",null,null,"l'immatric.","hors circul.","annuel","ligne",null,"(J.M.A. 1)"]
[null,null,null,null,null,{"$f":"E93-D93","v":0},null,{"$f":" IF(F93>0,ROUNDUP(G93/F93,6),0)","v":0},null,null,{"$f":"IF(SUM(J93-I93+1)>365,365,SUM(J93-I93+1))","v":1},{"$f":"ROUNDUP(K93*4400*H93/365*20,0)/20","v":0}]
[null,null,null,null,null,{"$f":"E94-D94","v":0},null,0,null,null,1,{"$f":"ROUNDUP(K94*4400*H94/365*20,0)/20","v":0}]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,{"$f":"E109-D109","v":0},null,{"$f":" IF(F109>0,ROUNDUP(G109/F109,6),0)","v":0},null,null,{"$f":"IF(SUM(J109-I109+1)>365,365,SUM(J109-I109+1))","v":1},0]
[null,null,null,null,null,{"$f":"E110-D110","v":0},null,{"$f":" IF(F110>0,ROUNDUP(G110/F110,6),0)","v":0},null,null,{"$f":"IF(SUM(J110-I110+1)>365,365,SUM(J110-I110+1))","v":1},0]
[null,null,null,null,null,{"$f":"E111-D111","v":0},null,{"$f":" IF(F111>0,ROUNDUP(G111/F111,6),0)","v":0},null,null,{"$f":"IF(SUM(J111-I111+1)>365,365,SUM(J111-I111+1))","v":1},0]
[null,null,null,null,null,{"$f":"E112-D112","v":0},null,{"$f":" IF(F112>0,ROUNDUP(G112/F112,6),0)","v":0},null,null,{"$f":"IF(SUM(J112-I112+1)>365,365,SUM(J112-I112+1))","v":1},0]
[null,null,null,null,null,{"$f":"E113-D113","v":0},null,{"$f":" IF(F113>0,ROUNDUP(G113/F113,6),0)","v":0},null,null,{"$f":"IF(SUM(J113-I113+1)>365,365,SUM(J113-I113+1))","v":1},0]
[null,null,null,null,null,{"$f":"E114-D114","v":0},null,{"$f":" IF(F114>0,ROUNDUP(G114/F114,6),0)","v":0},null,null,{"$f":"IF(SUM(J114-I114+1)>365,365,SUM(J114-I114+1))","v":1},0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,{"$f":"ROUNDUP(K125*4400*H125/365*20,0)/20","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L93:L125)","v":0}]
["1) = jour, mois, année"]
[null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"L127+L86","v":0}]
[]
[]
[]
["N° matricule","Plaque de","Marque ","Km au 1.1","Km au 31.12","Kilomé-","Km hors","Pourcen-","immatriculé",null,"Total "]
["selon permis","contrôle",null,"ou lors de","ou lors mise","trage","trafic de ","tage","du","au","jours","Montant"]
["de circulation",null,null,"l'immatric.","hors circul.","annuel","ligne",null,"(J.M.A. 1)"]
[null,null,null,null,null,{"$f":"E136-D136","v":0},null,{"$f":" IF(F136>0,ROUNDUP(G136/F136,6),0)","v":0},null,null,{"$f":"IF(SUM(J136-I136+1)>365,365,SUM(J136-I136+1))","v":1},{"$f":"ROUNDUP(K136*4400*H136/365*20,0)/20","v":0}]
[null,null,null,null,null,{"$f":"E137-D137","v":0},null,0,null,null,1,{"$f":"ROUNDUP(K137*4400*H137/365*20,0)/20","v":0}]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,{"$f":"E152-D152","v":0},null,{"$f":" IF(F152>0,ROUNDUP(G152/F152,6),0)","v":0},null,null,{"$f":"IF(SUM(J152-I152+1)>365,365,SUM(J152-I152+1))","v":1},0]
[null,null,null,null,null,{"$f":"E153-D153","v":0},null,{"$f":" IF(F153>0,ROUNDUP(G153/F153,6),0)","v":0},null,null,{"$f":"IF(SUM(J153-I153+1)>365,365,SUM(J153-I153+1))","v":1},0]
[null,null,null,null,null,{"$f":"E154-D154","v":0},null,{"$f":" IF(F154>0,ROUNDUP(G154/F154,6),0)","v":0},null,null,{"$f":"IF(SUM(J154-I154+1)>365,365,SUM(J154-I154+1))","v":1},0]
[null,null,null,null,null,{"$f":"E155-D155","v":0},null,{"$f":" IF(F155>0,ROUNDUP(G155/F155,6),0)","v":0},null,null,{"$f":"IF(SUM(J155-I155+1)>365,365,SUM(J155-I155+1))","v":1},0]
[null,null,null,null,null,{"$f":"E156-D156","v":0},null,{"$f":" IF(F156>0,ROUNDUP(G156/F156,6),0)","v":0},null,null,{"$f":"IF(SUM(J156-I156+1)>365,365,SUM(J156-I156+1))","v":1},0]
[null,null,null,null,null,{"$f":"E157-D157","v":0},null,{"$f":" IF(F157>0,ROUNDUP(G157/F157,6),0)","v":0},null,null,{"$f":"IF(SUM(J157-I157+1)>365,365,SUM(J157-I157+1))","v":1},0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,{"$f":"ROUNDUP(K168*4400*H168/365*20,0)/20","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L136:L168)","v":0}]
["1) = jour, mois, année"]
[null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"L170+L129","v":0}]
[]
[]
[]
["N° matricule","Plaque de","Marque ","Km au 1.1","Km au 31.12","Kilomé-","Km hors","Pourcen-","immatriculé",null,"Total "]
["selon permis","contrôle",null,"ou lors de","ou lors mise","trage","trafic de ","tage","du","au","jours","Montant"]
["de circulation",null,null,"l'immatric.","hors circul.","annuel","ligne",null,"(J.M.A. 1)"]
[null,null,null,null,null,{"$f":"E179-D179","v":0},null,{"$f":" IF(F179>0,ROUNDUP(G179/F179,6),0)","v":0},null,null,{"$f":"IF(SUM(J179-I179+1)>365,365,SUM(J179-I179+1))","v":1},{"$f":"ROUNDUP(K179*4400*H179/365*20,0)/20","v":0}]
[null,null,null,null,null,{"$f":"E180-D180","v":0},null,0,null,null,1,{"$f":"ROUNDUP(K180*4400*H180/365*20,0)/20","v":0}]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,{"$f":"E195-D195","v":0},null,{"$f":" IF(F195>0,ROUNDUP(G195/F195,6),0)","v":0},null,null,{"$f":"IF(SUM(J195-I195+1)>365,365,SUM(J195-I195+1))","v":1},0]
[null,null,null,null,null,{"$f":"E196-D196","v":0},null,{"$f":" IF(F196>0,ROUNDUP(G196/F196,6),0)","v":0},null,null,{"$f":"IF(SUM(J196-I196+1)>365,365,SUM(J196-I196+1))","v":1},0]
[null,null,null,null,null,{"$f":"E197-D197","v":0},null,{"$f":" IF(F197>0,ROUNDUP(G197/F197,6),0)","v":0},null,null,{"$f":"IF(SUM(J197-I197+1)>365,365,SUM(J197-I197+1))","v":1},0]
[null,null,null,null,null,{"$f":"E198-D198","v":0},null,{"$f":" IF(F198>0,ROUNDUP(G198/F198,6),0)","v":0},null,null,{"$f":"IF(SUM(J198-I198+1)>365,365,SUM(J198-I198+1))","v":1},0]
[null,null,null,null,null,{"$f":"E199-D199","v":0},null,{"$f":" IF(F199>0,ROUNDUP(G199/F199,6),0)","v":0},null,null,{"$f":"IF(SUM(J199-I199+1)>365,365,SUM(J199-I199+1))","v":1},0]
[null,null,null,null,null,{"$f":"E200-D200","v":0},null,{"$f":" IF(F200>0,ROUNDUP(G200/F200,6),0)","v":0},null,null,{"$f":"IF(SUM(J200-I200+1)>365,365,SUM(J200-I200+1))","v":1},0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,{"$f":"ROUNDUP(K211*4400*H211/365*20,0)/20","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L179:L211)","v":0}]
["1) = jour, mois, année"]
[null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"L213+L172","v":0}]

{"sheet":"über 26 t","index":4,"n_rows":385,"n_cols":12,"rows_kept":385,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
["Déclaration pour une éventuelle perception subséquente pour véhicules de ligne d'un poids total de plus de 26 t au taux de 5000 fr."]
[]
["N° matricule","Plaque de","Marque ","Km au 1.1","Km au 31.12","Kilomé-","Km hors","Pourcen-","immatriculé",null,"Total "]
["selon permis","contrôle",null,"ou lors de","ou lors mise","trage","trafic de ","tage","du","au","jours","Montant"]
["de circulation",null,null,"l'immatric.","hors circul.","annuel","ligne",null,"(J.M.A. 1)"]
[null,null,null,null,null,{"$f":"E11-D11","v":0},null,{"$f":" IF(F11>0,ROUNDUP(G11/F11,6),0)","v":0},null,null,{"$f":"IF(SUM(J11-I11+1)>365,365,SUM(J11-I11+1))","v":1},{"$f":"ROUNDUP(K11*5000*H11/365*20,0)/20","v":0}]
[null,null,null,null,null,{"$f":"E12-D12","v":0},null,0,null,null,1,{"$f":"ROUNDUP(K12*5000*H12/365*20,0)/20","v":0}]
[null,null,null,null,null,0,null,0,null,null,1,{"$f":"ROUNDUP(K13*5000*H13/365*20,0)/20","v":0}]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,{"$f":"ROUNDUP(K40*5000*H40/365*20,0)/20","v":0}]
[]
["1) = jour, mois, année",null,null,null,null,null,null,null,null,"Total",null,{"$f":"SUM(L11:L40)","v":0}]
[]
[]
["N° matricule","Plaque de","Marque ","Km au 1.1","Km au 31.12","Kilomé-","Km hors","Pourcen-","immatriculé",null,"Total "]
["selon permis","contrôle",null,"ou lors de","ou lors mise","trage","trafic de ","tage","du","au","jours","Montant"]
["de circulation",null,null,"l'immatric.","hors circul.","annuel","ligne",null,"(J.M.A. 1)"]
[null,null,null,null,null,{"$f":"E48-D48","v":0},null,{"$f":" IF(F48>0,ROUNDUP(G48/F48,6),0)","v":0},null,null,{"$f":"IF(SUM(J48-I48+1)>365,365,SUM(J48-I48+1))","v":1},{"$f":"ROUNDUP(K48*5000*H48/365*20,0)/20","v":0}]
[null,null,null,null,null,{"$f":"E49-D49","v":0},null,{"$f":" IF(F49>0,ROUNDUP(G49/F49,6),0)","v":0},null,null,{"$f":"IF(SUM(J49-I49+1)>365,365,SUM(J49-I49+1))","v":1},{"$f":"ROUNDUP(K49*5000*H49/365*20,0)/20","v":0}]
[null,null,null,null,null,{"$f":"E50-D50","v":0},null,{"$f":" IF(F50>0,ROUNDUP(G50/F50,6),0)","v":0},null,null,{"$f":"IF(SUM(J50-I50+1)>365,365,SUM(J50-I50+1))","v":1},0]
[null,null,null,null,null,{"$f":"E51-D51","v":0},null,{"$f":" IF(F51>0,ROUNDUP(G51/F51,6),0)","v":0},null,null,{"$f":"IF(SUM(J51-I51+1)>365,365,SUM(J51-I51+1))","v":1},0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,{"$f":"ROUNDUP(K80*5000*H80/365*20,0)/20","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L48:L80)","v":0}]
["1) = jour, mois, année"]
[null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"L42+L82","v":0}]
[]
[]
[]
["N° matricule","Plaque de","Marque ","Km au 1.1","Km au 31.12","Kilomé-","Km hors","Pourcen-","immatriculé",null,"Total "]
["selon permis","contrôle",null,"ou lors de","ou lors mise","trage","trafic de ","tage","du","au","jours","Montant"]
["de circulation",null,null,"l'immatric.","hors circul.","annuel","ligne",null,"(J.M.A. 1)"]
[null,null,null,null,null,{"$f":"E91-D91","v":0},null,{"$f":" IF(F91>0,ROUNDUP(G91/F91,6),0)","v":0},null,null,{"$f":"IF(SUM(J91-I91+1)>365,365,SUM(J91-I91+1))","v":1},{"$f":"ROUNDUP(K91*5000*H91/365*20,0)/20","v":0}]
[null,null,null,null,null,{"$f":"E92-D92","v":0},null,0,null,null,1,{"$f":"ROUNDUP(K92*5000*H92/365*20,0)/20","v":0}]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,{"$f":"E107-D107","v":0},null,{"$f":" IF(F107>0,ROUNDUP(G107/F107,6),0)","v":0},null,null,{"$f":"IF(SUM(J107-I107+1)>365,365,SUM(J107-I107+1))","v":1},0]
[null,null,null,null,null,{"$f":"E108-D108","v":0},null,{"$f":" IF(F108>0,ROUNDUP(G108/F108,6),0)","v":0},null,null,{"$f":"IF(SUM(J108-I108+1)>365,365,SUM(J108-I108+1))","v":1},0]
[null,null,null,null,null,{"$f":"E109-D109","v":0},null,{"$f":" IF(F109>0,ROUNDUP(G109/F109,6),0)","v":0},null,null,{"$f":"IF(SUM(J109-I109+1)>365,365,SUM(J109-I109+1))","v":1},0]
[null,null,null,null,null,{"$f":"E110-D110","v":0},null,{"$f":" IF(F110>0,ROUNDUP(G110/F110,6),0)","v":0},null,null,{"$f":"IF(SUM(J110-I110+1)>365,365,SUM(J110-I110+1))","v":1},0]
[null,null,null,null,null,{"$f":"E111-D111","v":0},null,{"$f":" IF(F111>0,ROUNDUP(G111/F111,6),0)","v":0},null,null,{"$f":"IF(SUM(J111-I111+1)>365,365,SUM(J111-I111+1))","v":1},0]
[null,null,null,null,null,{"$f":"E112-D112","v":0},null,{"$f":" IF(F112>0,ROUNDUP(G112/F112,6),0)","v":0},null,null,{"$f":"IF(SUM(J112-I112+1)>365,365,SUM(J112-I112+1))","v":1},0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,{"$f":"ROUNDUP(K123*5000*H123/365*20,0)/20","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L91:L123)","v":0}]
["1) = jour, mois, année"]
[null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"L42+L82+L125","v":0}]
[]
[]
[]
["N° matricule","Plaque de","Marque ","Km au 1.1","Km au 31.12","Kilomé-","Km hors","Pourcen-","immatriculé",null,"Total "]
["selon permis","contrôle",null,"ou lors de","ou lors mise","trage","trafic de ","tage","du","au","jours","Montant"]
["de circulation",null,null,"l'immatric.","hors circul.","annuel","ligne",null,"(J.M.A. 1)"]
[null,null,null,null,null,{"$f":"E134-D134","v":0},null,{"$f":" IF(F134>0,ROUNDUP(G134/F134,6),0)","v":0},null,null,{"$f":"IF(SUM(J134-I134+1)>365,365,SUM(J134-I134+1))","v":1},{"$f":"ROUNDUP(K134*5000*H134/365*20,0)/20","v":0}]
[null,null,null,null,null,{"$f":"E135-D135","v":0},null,{"$f":" IF(F135>0,ROUNDUP(G135/F135,6),0)","v":0},null,null,{"$f":"IF(SUM(J135-I135+1)>365,365,SUM(J135-I135+1))","v":1},{"$f":"ROUNDUP(K135*5000*H135/365*20,0)/20","v":0}]
[null,null,null,null,null,{"$f":"E136-D136","v":0},null,{"$f":" IF(F136>0,ROUNDUP(G136/F136,6),0)","v":0},null,null,{"$f":"IF(SUM(J136-I136+1)>365,365,SUM(J136-I136+1))","v":1},0]
[null,null,null,null,null,{"$f":"E137-D137","v":0},null,{"$f":" IF(F137>0,ROUNDUP(G137/F137,6),0)","v":0},null,null,{"$f":"IF(SUM(J137-I137+1)>365,365,SUM(J137-I137+1))","v":1},0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,{"$f":"ROUNDUP(K166*5000*H166/365*20,0)/20","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L134:L166)","v":0}]
["1) = jour, mois, année"]
[null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"L42+L82+L125+L168","v":0}]
[]
[]
[]
["N° matricule","Plaque de","Marque ","Km au 1.1","Km au 31.12","Kilomé-","Km hors","Pourcen-","immatriculé",null,"Total "]
["selon permis","contrôle",null,"ou lors de","ou lors mise","trage","trafic de ","tage","du","au","jours","Montant"]
["de circulation",null,null,"l'immatric.","hors circul.","annuel","ligne",null,"(J.M.A. 1)"]
[null,null,null,null,null,{"$f":"E177-D177","v":0},null,{"$f":" IF(F177>0,ROUNDUP(G177/F177,6),0)","v":0},null,null,{"$f":"IF(SUM(J177-I177+1)>365,365,SUM(J177-I177+1))","v":1},{"$f":"ROUNDUP(K177*5000*H177/365*20,0)/20","v":0}]
[null,null,null,null,null,{"$f":"E178-D178","v":0},null,{"$f":" IF(F178>0,ROUNDUP(G178/F178,6),0)","v":0},null,null,{"$f":"IF(SUM(J178-I178+1)>365,365,SUM(J178-I178+1))","v":1},{"$f":"ROUNDUP(K178*5000*H178/365*20,0)/20","v":0}]
[null,null,null,null,null,{"$f":"E179-D179","v":0},null,{"$f":" IF(F179>0,ROUNDUP(G179/F179,6),0)","v":0},null,null,{"$f":"IF(SUM(J179-I179+1)>365,365,SUM(J179-I179+1))","v":1},0]
[null,null,null,null,null,{"$f":"E180-D180","v":0},null,{"$f":" IF(F180>0,ROUNDUP(G180/F180,6),0)","v":0},null,null,{"$f":"IF(SUM(J180-I180+1)>365,365,SUM(J180-I180+1))","v":1},0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,{"$f":"ROUNDUP(K209*5000*H209/365*20,0)/20","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L177:L209)","v":0}]
["1) = jour, mois, année"]
[null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"L42+L82+L125+L168+L211","v":0}]
[]
[]
[]
["N° matricule","Plaque de","Marque ","Km au 1.1","Km au 31.12","Kilomé-","Km hors","Pourcen-","immatriculé",null,"Total "]
["selon permis","contrôle",null,"ou lors de","ou lors mise","trage","trafic de ","tage","du","au","jours","Montant"]
["de circulation",null,null,"l'immatric.","hors circul.","annuel","ligne",null,"(J.M.A. 1)"]
[null,null,null,null,null,{"$f":"E220-D220","v":0},null,{"$f":" IF(F220>0,ROUNDUP(G220/F220,6),0)","v":0},null,null,{"$f":"IF(SUM(J220-I220+1)>365,365,SUM(J220-I220+1))","v":1},{"$f":"ROUNDUP(K220*5000*H220/365*20,0)/20","v":0}]
[null,null,null,null,null,{"$f":"E221-D221","v":0},null,{"$f":" IF(F221>0,ROUNDUP(G221/F221,6),0)","v":0},null,null,{"$f":"IF(SUM(J221-I221+1)>365,365,SUM(J221-I221+1))","v":1},{"$f":"ROUNDUP(K221*5000*H221/365*20,0)/20","v":0}]
[null,null,null,null,null,{"$f":"E222-D222","v":0},null,{"$f":" IF(F222>0,ROUNDUP(G222/F222,6),0)","v":0},null,null,{"$f":"IF(SUM(J222-I222+1)>365,365,SUM(J222-I222+1))","v":1},0]
[null,null,null,null,null,{"$f":"E223-D223","v":0},null,{"$f":" IF(F223>0,ROUNDUP(G223/F223,6),0)","v":0},null,null,{"$f":"IF(SUM(J223-I223+1)>365,365,SUM(J223-I223+1))","v":1},0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,{"$f":"ROUNDUP(K252*5000*H252/365*20,0)/20","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L220:L252)","v":0}]
["1) = jour, mois, année"]
[null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"L42+L82+L125+L168+L211+L254","v":0}]
[]
[]
[]
["N° matricule","Plaque de","Marque ","Km au 1.1","Km au 31.12","Kilomé-","Km hors","Pourcen-","immatriculé",null,"Total "]
["selon permis","contrôle",null,"ou lors de","ou lors mise","trage","trafic de ","tage","du","au","jours","Montant"]
["de circulation",null,null,"l'immatric.","hors circul.","annuel","ligne",null,"(J.M.A. 1)"]
[null,null,null,null,null,{"$f":"E263-D263","v":0},null,{"$f":" IF(F263>0,ROUNDUP(G263/F263,6),0)","v":0},null,null,{"$f":"IF(SUM(J263-I263+1)>365,365,SUM(J263-I263+1))","v":1},{"$f":"ROUNDUP(K263*5000*H263/365*20,0)/20","v":0}]
[null,null,null,null,null,{"$f":"E264-D264","v":0},null,{"$f":" IF(F264>0,ROUNDUP(G264/F264,6),0)","v":0},null,null,{"$f":"IF(SUM(J264-I264+1)>365,365,SUM(J264-I264+1))","v":1},{"$f":"ROUNDUP(K264*5000*H264/365*20,0)/20","v":0}]
[null,null,null,null,null,{"$f":"E265-D265","v":0},null,{"$f":" IF(F265>0,ROUNDUP(G265/F265,6),0)","v":0},null,null,{"$f":"IF(SUM(J265-I265+1)>365,365,SUM(J265-I265+1))","v":1},0]
[null,null,null,null,null,{"$f":"E266-D266","v":0},null,{"$f":" IF(F266>0,ROUNDUP(G266/F266,6),0)","v":0},null,null,{"$f":"IF(SUM(J266-I266+1)>365,365,SUM(J266-I266+1))","v":1},0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,{"$f":"ROUNDUP(K295*5000*H295/365*20,0)/20","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L263:L295)","v":0}]
["1) = jour, mois, année"]
[null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"L42+L82+L125+L168+L211+L254+L297","v":0}]
[]
[]
[]
["N° matricule","Plaque de","Marque ","Km au 1.1","Km au 31.12","Kilomé-","Km hors","Pourcen-","immatriculé",null,"Total "]
["selon permis","contrôle",null,"ou lors de","ou lors mise","trage","trafic de ","tage","du","au","jours","Montant"]
["de circulation",null,null,"l'immatric.","hors circul.","annuel","ligne",null,"(J.M.A. 1)"]
[null,null,null,null,null,{"$f":"E306-D306","v":0},null,{"$f":" IF(F306>0,ROUNDUP(G306/F306,6),0)","v":0},null,null,{"$f":"IF(SUM(J306-I306+1)>365,365,SUM(J306-I306+1))","v":1},{"$f":"ROUNDUP(K306*5000*H306/365*20,0)/20","v":0}]
[null,null,null,null,null,{"$f":"E307-D307","v":0},null,{"$f":" IF(F307>0,ROUNDUP(G307/F307,6),0)","v":0},null,null,{"$f":"IF(SUM(J307-I307+1)>365,365,SUM(J307-I307+1))","v":1},{"$f":"ROUNDUP(K307*5000*H307/365*20,0)/20","v":0}]
[null,null,null,null,null,{"$f":"E308-D308","v":0},null,{"$f":" IF(F308>0,ROUNDUP(G308/F308,6),0)","v":0},null,null,{"$f":"IF(SUM(J308-I308+1)>365,365,SUM(J308-I308+1))","v":1},0]
[null,null,null,null,null,{"$f":"E309-D309","v":0},null,{"$f":" IF(F309>0,ROUNDUP(G309/F309,6),0)","v":0},null,null,{"$f":"IF(SUM(J309-I309+1)>365,365,SUM(J309-I309+1))","v":1},0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,{"$f":"ROUNDUP(K338*5000*H338/365*20,0)/20","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L306:L338)","v":0}]
["1) = jour, mois, année"]
[null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"L42+L82+L125+L168+L211+L254+L297+L340","v":0}]
[]
[]
[]
["N° matricule","Plaque de","Marque ","Km au 1.1","Km au 31.12","Kilomé-","Km hors","Pourcen-","immatriculé",null,"Total "]
["selon permis","contrôle",null,"ou lors de","ou lors mise","trage","trafic de ","tage","du","au","jours","Montant"]
["de circulation",null,null,"l'immatric.","hors circul.","annuel","ligne",null,"(J.M.A. 1)"]
[null,null,null,null,null,{"$f":"E349-D349","v":0},null,{"$f":" IF(F349>0,ROUNDUP(G349/F349,6),0)","v":0},null,null,{"$f":"IF(SUM(J349-I349+1)>365,365,SUM(J349-I349+1))","v":1},{"$f":"ROUNDUP(K349*5000*H349/365*20,0)/20","v":0}]
[null,null,null,null,null,{"$f":"E350-D350","v":0},null,{"$f":" IF(F350>0,ROUNDUP(G350/F350,6),0)","v":0},null,null,{"$f":"IF(SUM(J350-I350+1)>365,365,SUM(J350-I350+1))","v":1},{"$f":"ROUNDUP(K350*5000*H350/365*20,0)/20","v":0}]
[null,null,null,null,null,{"$f":"E351-D351","v":0},null,{"$f":" IF(F351>0,ROUNDUP(G351/F351,6),0)","v":0},null,null,{"$f":"IF(SUM(J351-I351+1)>365,365,SUM(J351-I351+1))","v":1},0]
[null,null,null,null,null,{"$f":"E352-D352","v":0},null,{"$f":" IF(F352>0,ROUNDUP(G352/F352,6),0)","v":0},null,null,{"$f":"IF(SUM(J352-I352+1)>365,365,SUM(J352-I352+1))","v":1},0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,0]
[null,null,null,null,null,0,null,0,null,null,1,{"$f":"ROUNDUP(K381*5000*H381/365*20,0)/20","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L349:L381)","v":0}]
["1) = jour, mois, année"]
[null,null,null,null,null,null,null,null,null,"Total",null,{"$f":"L42+L82+L125+L168+L211+L254+L297+L340+L383","v":0}]