{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["template1","template2","PC124","CP124","Firm","202302_TDMUHIOMOHI_iugo","template2 (2)","Barema"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":15,"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":"template1","index":0,"n_rows":43,"n_cols":11,"rows_kept":43,"cut":false,"hidden":true,"merged":[[42,0,42,9],[6,10,7,10],[1,0,1,2],[2,0,2,2],[6,0,7,0],[1,4,1,10],[2,4,2,10],[4,0,4,10],[7,8,7,9],[7,4,7,5],[6,4,6,9],[6,2,7,3],[6,1,7,1],[7,6,7,7]]}
[]
["Werknemer:"]
["Personeelsnummer:"]
[]
["Detail Mobiliteit"]
[]
[null,null,"Verplaatsing met eigen vervoermiddel bv. auto-moto (geen trein) ",null,"Verplaatsing georganiseerd door de werkgever met vervoermiddel werkgever"]
[null,null,null,null,"Passagier",null,"Chauffeur",null,"Chauffeur (alleen)"]
[null,"Datum","km / dag","€","km / dag","€","km / dag","€","km / dag","€","Dagtotaal"]
[null,null,null,{"$f":"IF(AND(LEN(C10)>0,VALUE(C10)>0), IF(C10+IF(LEN(E10)>0,E10,0)+IF(LEN(I10)>0,I10,0)<10,0,C10*VLOOKUP(C10,[0]!km_vergoeding,2,TRUE)),\"\")","v":""},null,{"$f":"IF(AND(LEN(E10)>0,VALUE(E10)>0), IF(E10+IF(LEN(C10)>0,C10,0)+IF(LEN(I10)>0,I10,0)<10,0,E10*VLOOKUP(E10,[0]!km_vergoeding,2,TRUE)),\"\")","v":""},null,{"$f":"IF(VALUE(G10)=0,\"\",G10*VLOOKUP(G10,km_vergoeding,3,TRUE))","v":""},null,{"$f":"IF(VALUE(I10)=0,\"\",I10*VLOOKUP(I10,km_vergoeding,4,TRUE))","v":""},{"$f":"IF(OR(LEN(D10)>0,LEN(E10)>0,LEN(G10)>0,LEN(I10)>0),IF(LEN(D10)>0,D10,0)+IF(LEN(F10)>0,F10,0)+IF(LEN(H10)>0,H10,0)+IF(LEN(J10)>0,J10,0),\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Totaal huidig kwartaal:"]

{"sheet":"template2","index":1,"n_rows":43,"n_cols":12,"rows_kept":43,"cut":false,"hidden":true,"merged":[[6,11,7,11],[1,0,1,2],[1,4,1,11],[2,0,2,2],[2,4,2,11],[4,0,4,11],[7,4,7,5],[7,6,7,7],[7,8,7,9],[42,0,42,9],[6,10,7,10],[6,0,7,0],[6,1,7,1],[6,2,7,3],[6,4,6,9]]}
[]
["Werknemer:"]
["Personeelsnummer:"]
[]
["Detail Mobiliteit"]
[]
[null,null,"Verplaatsing met eigen vervoermiddel bv. auto-moto (geen trein) ",null,"Verplaatsing georganiseerd door de werkgever met vervoermiddel werkgever"]
[null,null,null,null,"Passagier",null,"Chauffeur",null,"Chauffeur (alleen)"]
[null,"Datum","km / dag","€","km / dag","€","km / dag","€","km / dag","€","Dagtotaal Mobiliteit","Dagtotaal Verplaatsing"]
[null,null,null,{"$f":"IF(AND(LEN(C10)>0,VALUE(C10)>0), IF(C10+IF(LEN(E10)>0,E10,0)+IF(LEN(I10)>0,I10,0)<10,0,C10*VLOOKUP(C10,[0]!km_vergoeding,2,TRUE)),\"\")","v":""},null,{"$f":"IF(AND(LEN(E10)>0,VALUE(E10)>0), IF(E10+IF(LEN(C10)>0,C10,0)+IF(LEN(I10)>0,I10,0)<10,0,E10*VLOOKUP(E10,[0]!km_vergoeding,2,TRUE)),\"\")","v":""},null,{"$f":"IF(VALUE(G10)=0,\"\",G10*VLOOKUP(G10,km_vergoeding,3,TRUE))","v":""},null,{"$f":"IF(VALUE(I10)=0,\"\",I10*VLOOKUP(I10,km_vergoeding,4,TRUE))","v":""},null,{"$f":"IF(OR(LEN(D10)>0,LEN(E10)>0,LEN(G10)>0,LEN(I10)>0),IF(LEN(D10)>0,D10,0)+IF(LEN(F10)>0,F10,0)+IF(LEN(H10)>0,H10,0)+IF(LEN(J10)>0,J10,0),\"\")","v":""}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Totaal huidig kwartaal:"]

{"sheet":"PC124","index":2,"n_rows":33,"n_cols":2,"rows_kept":33,"cut":false,"hidden":true,"merged":[[0,0,0,1],[2,0,2,1],[18,0,18,1],[1,0,1,1]]}
[]
["Gebruiksaanwijzing tool \"Mobiliteitsvergoedingen PC 124\""]
["Gebruiksaanwijzing"]
[null,"Sinds 2012 zijn de werkgevers van PC 124 voor het Bouwbedrijf verplicht om een schriftelijk detail van het bedrag van de mobiliteitsvergoeding, te overhandigen aan de arbeider.\nIn het sectorakkoord 2019-2020 wordt voor de verplaatsing georganiseerd door de werkgever met een vervoermiddel van de werkgever, een 3de vergoedingscategorie toegevoegd nl. de chauffeur die zich alleen verplaatst naar de werf."]
[]
[null,"Het Sociaal Secretariaat Securex heeft haar excelbestand in die zin aangepast zodat u vanaf 01/07/2014 aan uw verplichting kan voldoen.     \nDeze exceltool bevat een invulpagina waarin u de gegevens opneemt van uw onderneming en van uw personeelsleden.      \nOp deze invulpagina duidt u tevens de betrokken maand aan waarvoor u dit maandelijks detail wenst op te maken."]
[]
[null,"Eens alle gegevens zijn ingebracht, klikt u op de knop \"Maand aanmaken\". Na een korte tijd is voor elk personeelslid de sheet vaangemaakt. Daarna kunt u per arbeider het detail van de mobiliteitsvergoeding beheren."]
[]
[null,"Het beheer is heel eenvoudig : u hoeft enkel het totaal aantal afgelegde km per dag in te vullen. Hiervoor is er een kolom per vervoermiddel voorzien : eigen vervoermiddel of vervoermiddel van de werkgever voor transport georganiseerd door de werkgever. Op basis van uw ingave gebeurt de berekening van de verschuldigde mobiliteitsvergoeding volledig automatisch. Let wel, er is geen mobiliteitsvergoeding verschuldigd indien de totale dagelijkse afstand minder dan 10 km bedraagt. "]
[]
[null,"Nadat de km zijn ingebracht , drukt u op de invulpagina op de knop \"Printen\".\nHier beschikt u over de mogelijkheid om het detail af te drukken voor elke arbeider afzonderlijk of voor alle arbeiders samen."]
[]
[null,"Wat moet u doen zo er in de loop van een maand een nieuwe arbeider in dienst treedt ?  U voegt de betrokken arbeider gewoon toe op de invulpagina en u drukt op de knop \"maand aanmaken\". Aldus wordt ook voor deze arbeider een sheet aangemaakt. "]
[]
[null,"Tot slot nog dit : u kan het maandelijks detail ook als basis gebruiken om de maandelijkse mobiliteitsvergoeding die op de loonfiche dient vermeld te worden, aan ons  sociaal secretariaat door te geven. "]
[]
[]
["Nog enkele praktische tips :"]
[]
["1.","Sla deze tool lokaal op op uw PC."]
[]
["2.","Vergeet niet de macro’s van deze tool te activeren.  Dit kan ofwel in het Microsoft Office Trust Center of in het document zelf."]
[]
["3.","Bij problemen met versies of macro's, gelieve uw softwareleverancier te raadplegen."]
[]
["4.","Indien een nieuwe versie van de tool beschikbaar is, zal u hierover bericht worden en wordt hiertoe tevens een bericht op onze portaalsite gepubliceerd"]
[null,"www.securex.be"]
[]
["5.","Voor alle andere problemen staat Customer Service Desk tot uw beschikking. U kan hen bereiken op T 078 05 90 14 of via e-mail op:"]
[null,"helpdesk@securex.be"]
[]
["6.","Uw client advisor staat tot uw beschikking voor al uw inhoudelijke vragen m.b.t. het trimestrieel detail of m.b.t. de berekeningswijze van de mobiliteitsvergoeding"]

{"sheet":"CP124","index":3,"n_rows":30,"n_cols":2,"rows_kept":30,"cut":false,"hidden":false,"merged":[[2,0,2,1],[15,0,15,1],[0,0,0,1],[1,0,1,1]]}
[]
["Indemnités de mobilité CP 124"]
["Manuel"]
[null,"Depuis 2012 les employeurs de la CP 124 de la construction sont obligés de fournir un détail écrit du montant de l’indemnité de mobilité.\nDans l’accord sectoriel 2019-2020, pour le transport organisé par l'employeur, une catégorie supplémentaire a été ajoutée pour les déplacements avec un véhicule de l'employeur : \"chauffeur seul\"\nLe Secrétariat Social Securex a modifié son outil excel afin que vous puissiez répondre à cette obligation modifiée à partir du 01/12/2019.       \nCet outil contient une page sur laquelle vous pouvez remplir les données de votre entreprise et celles de vos travailleurs."]
[]
[null,"Vous y indiquez le mois concerné pour lequel vous souhaitez établir ce détail.    \nUne fois que toutes les données ont été insérées, vous cliquez sur le bouton \"Générer le mois\".  Des feuilles ont été créées pour chaque travailleur. "]
[]
[null,"Il est maintenant possible de traiter le détail de l’indemnité de mobilité par travailleur.   \nLa gestion reste simple : il suffit de remplir le nombre total de kilomètres parcourus par jour. À cet effet, une colonne par moyen de transport a été prévue : une colonne pour les déplacements avec son propre véhicule et une colonne pour les déplacements avec un véhicule de l’employeur pour le transport organisé par l’employeur.\nLe calcul de l’indemnité de mobilité se fait automatiquement sur base de ce que vous avez rempli. \nPoint d’attention : l’indemnité de mobilité n’est pas due si la distance totale parcourue par jour est inférieure à 10 kilomètres."]
[]
[null,"Une fois que les kilomètres sont insérés, cliquez sur le bouton \"Imprimer\".    \nVous avez la possibilité d’imprimer le détail pour chaque travailleur séparément ou pour tous les travailleurs ensemble."]
[]
[null,"Que faire si un travailleur entre en service au cours du mois ?  Sur la feuille à remplir, vous ajoutez le travailleur et vous cliquez sur “Générer le mois”. Une feuille sera générée automatiquement pour ce travailleur. Idem pour un travailleur qui sort de service."]
[]
[null,"Finalement : vous pouvez également utiliser ce détail mensuel pour informer le Secrétariat Social Securex du montant mensuel de l’indemnité de mobilité qui doit être repris dans le calcul des salaires."]
[]
["Encore quelques conseils pratiques :"]
[]
["1.","Sauvegarder cet outil sur votre ordinateur. "]
[]
["2.","N’oubliez pas d’activer les macro’s de cet outil. Vous pouvez le faire dans le Microsoft Office Trust Center ou dans le document même."]
[]
["3.","Si vous constatez des problèmes avec des versions ou avec des macro’s, veullez consulter votre fournisseur de logiciels."]
[]
["4.","Si une nouvelle version de l’outil sera disponible, nous vous tiendrons au courant via plusieurs canaux : par mail, via un message sur notre portail"]
[null,"www.securex.be"]
[]
["5.","Notre Service Clients est à votre disposition pour d’autres problèmes et questions. Vous pouvez les joindre au T 078 05 90 14 ou envoyez un mail à "]
[null,"helpdesk@securex.be"]
[]
["6.","Votre client advisor reste à votre disposition  pour toutes vos questions spécifiques rélatives au détail trimestriel ou rélatives à la méthode de calcul de l’indemnité de mobilité."]

{"sheet":"Firm","index":4,"n_rows":10,"n_cols":28,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["Nom de la firme",null,null,null,"Calcul","Indemnités de mobilité",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mobiliteitsvergoedingen","Indemnités de mobilité"]
["Rue + numéro",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mobiliteits- en verplaatsingsvergoedingen","Indemnités de mobilité et de déplacement"]
["Code Postal + Commune"]
["Votre numéro de client (facultatif)"]
["Votre numéro d'entreprise (facultatif)"]
["Année",2025]
["Mois"]
["Langue","F"]
["Ouvriers"]
["Nom","Numéro de contrat","Langue","Dep/Cat   (vb: 00/1)"]

{"sheet":"202302_TDMUHIOMOHI_iugo","index":5,"n_rows":40,"n_cols":12,"rows_kept":40,"cut":false,"hidden":true,"merged":[[6,11,7,11],[7,4,7,5],[7,6,7,7],[7,8,7,9],[39,0,39,9],[6,0,7,0],[6,1,7,1],[6,2,7,3],[6,4,6,9],[6,10,7,10],[1,0,1,2],[1,4,1,11],[2,0,2,2],[2,4,2,11],[4,0,4,11]]}
[]
["Ouvrier:",null,null,null,"tdmuhiomohi"]
["Numéro personnel:",null,null,null,"iugo"]
[]
["Détail des indemnités de mobilité"]
[]
[null,null,"Déplacement avec son propre véhicule (voiture, moto)\nPas de train",null,"Transport organisé par l'employeur avec véhicule de la firme"]
[null,null,null,null,"Passager",null,"Chauffeur",null,"Chauffeur seul"]
[null,"Date","Km / jour","€","Km / jour","€","Km / jour","€","Km / jour","€","Tot. journée Mobilité","Tot. journée Déplacement"]
["me","2023-02-01",null,{"$f":"IF(AND(LEN(C10)>0,VALUE(C10)>0), IF(C10+IF(LEN(E10)>0,E10,0)+IF(LEN(G10)>0,G10,0)+IF(LEN(I10)>0,I10,0)<10,0,C10*VLOOKUP(C10,km_vergoeding,2,TRUE)),\"\")","v":""},null,{"$f":"IF(AND(LEN(E10)>0,VALUE(E10)>0), IF(E10+IF(LEN(C10)>0,C10,0)+IF(LEN(G10)>0,G10,0)+IF(LEN(I10)>0,I10,0)<10,0,E10*VLOOKUP(E10,km_vergoeding,2,TRUE)),\"\")","v":""},null,{"$f":"IF(VALUE(G10)=0,\"\",G10*VLOOKUP(G10,km_vergoeding,3,TRUE))","v":""},null,{"$f":"IF(AND(LEN(I10)>0,VALUE(I10)>0), IF(I10+IF(LEN(E10)>0,E10,0)+IF(LEN(C10)>0,C10,0)+IF(LEN(G10)>0,G10,0)<10,0,I10*VLOOKUP(I10,km_vergoeding,4,TRUE)),\"\")","v":""},{"$f":"IF(OR(LEN(D10)>0,LEN(E10)>0,LEN(G10)>0,LEN(I10)>0),IF(LEN(D10)>0,D10,0)+IF(LEN(F10)>0,F10,0)+IF(LEN(H10)>0,H10,0)+IF(LEN(J10)>0,J10,0),\"\")","v":""},{"$f":"IF(AND(LEN(C10)>0,VALUE(C10)>0),VLOOKUP(C10,km_verplaatsing,2,TRUE),\"\")","v":""}]
["je","2023-02-02",null,"",null,"",null,"",null,"",{"$f":"IF(OR(LEN(D11)>0,LEN(E11)>0,LEN(G11)>0,LEN(I11)>0),IF(LEN(D11)>0,D11,0)+IF(LEN(F11)>0,F11,0)+IF(LEN(H11)>0,H11,0)+IF(LEN(J11)>0,J11,0),\"\")","v":""},""]
["ve","2023-02-03",null,"",null,"",null,"",null,"","",""]
["sa","2023-02-04",null,"",null,"",null,"",null,"","",""]
["di","2023-02-05",null,"",null,"",null,"",null,"","",""]
["lu","2023-02-06",null,"",null,"",null,"",null,"","",""]
["ma","2023-02-07",null,"",null,"",null,"",null,"","",""]
["me","2023-02-08",null,"",null,"",null,"",null,"","",""]
["je","2023-02-09",null,"",null,"",null,"",null,"","",""]
["ve","2023-02-10",null,"",null,"",null,"",null,"","",""]
["sa","2023-02-11",null,"",null,"",null,"",null,"","",""]
["di","2023-02-12",null,"",null,"",null,"",null,"","",""]
["lu","2023-02-13",null,"",null,"",null,"",null,"","",""]
["ma","2023-02-14",null,"",null,"",null,"",null,"","",""]
["me","2023-02-15",null,"",null,"",null,"",null,"","",""]
["je","2023-02-16",null,"",null,"",null,"",null,"","",""]
["ve","2023-02-17",null,"",null,"",null,"",null,"","",""]
["sa","2023-02-18",null,"",null,"",null,"",null,"","",""]
["di","2023-02-19",null,"",null,"",null,"",null,"","",""]
["lu","2023-02-20",null,"",null,"",null,"",null,"","",""]
["ma","2023-02-21",null,"",null,"",null,"",null,"","",""]
["me","2023-02-22",null,"",null,"",null,"",null,"","",""]
["je","2023-02-23",null,"",null,"",null,"",null,"","",""]
["ve","2023-02-24",null,"",null,"",null,"",null,"","",""]
["sa","2023-02-25",null,"",null,"",null,"",null,"","",""]
["di","2023-02-26",null,"",null,"",null,"",null,"","",""]
["lu","2023-02-27",null,"",null,"",null,"",null,"","",""]
["ma","2023-02-28",null,"",null,"",null,"",null,"","",""]
["Montants totals du mois:",null,null,{"$f":"SUM(D10:D37)","v":0},null,{"$f":"SUM(F10:F37)","v":0},null,{"$f":"SUM(H10:H37)","v":0},null,{"$f":"SUM(J10:J37)","v":0},{"$f":"SUM(K10:K37)","v":0},{"$f":"SUM(L10:L37)","v":0}]
[]
["montant total du trimestre:"]

{"sheet":"template2 (2)","index":6,"n_rows":40,"n_cols":12,"rows_kept":40,"cut":false,"hidden":true,"merged":[[6,11,7,11],[7,4,7,5],[7,6,7,7],[7,8,7,9],[39,0,39,9],[6,0,7,0],[6,1,7,1],[6,2,7,3],[6,4,6,9],[6,10,7,10],[1,0,1,2],[1,4,1,11],[2,0,2,2],[2,4,2,11],[4,0,4,11]]}
[]
["Ouvrier:",null,null,null,"fgeuihegziezgjip"]
["Numéro personnel:",null,null,null,"guihgguh"]
[]
["Détail des indemnités de mobilité"]
[]
[null,null,"Déplacement avec son propre véhicule (voiture, moto)\nPas de train",null,"Transport organisé par l'employeur avec véhicule de la firme"]
[null,null,null,null,"Passager",null,"Chauffeur",null,"Chauffeur seul"]
[null,"Date","Km / jour","€","Km / jour","€","Km / jour","€","Km / jour","€","Tot. journée Mobilité","Tot. journée Déplacement"]
["me","2023-02-01",5,{"$f":"IF(AND(LEN(C10)>0,VALUE(C10)>0), IF(C10+IF(LEN(E10)>0,E10,0)+IF(LEN(G10)>0,G10,0)+IF(LEN(I10)>0,I10,0)<10,0,C10*VLOOKUP(C10,km_vergoeding,2,TRUE)),\"\")","v":0.3095},12,{"$f":"IF(AND(LEN(E10)>0,VALUE(E10)>0), IF(E10+IF(LEN(C10)>0,C10,0)+IF(LEN(G10)>0,G10,0)+IF(LEN(I10)>0,I10,0)<10,0,E10*VLOOKUP(E10,km_vergoeding,2,TRUE)),\"\")","v":0.7427999999999999},null,{"$f":"IF(VALUE(G10)=0,\"\",G10*VLOOKUP(G10,km_vergoeding,3,TRUE))","v":""},null,{"$f":"IF(AND(LEN(I10)>0,VALUE(I10)>0), IF(I10+IF(LEN(E10)>0,E10,0)+IF(LEN(C10)>0,C10,0)+IF(LEN(G10)>0,G10,0)<10,0,I10*VLOOKUP(I10,km_vergoeding,4,TRUE)),\"\")","v":""},{"$f":"IF(OR(LEN(D10)>0,LEN(E10)>0,LEN(G10)>0,LEN(I10)>0),IF(LEN(D10)>0,D10,0)+IF(LEN(F10)>0,F10,0)+IF(LEN(H10)>0,H10,0)+IF(LEN(J10)>0,J10,0),\"\")","v":1.0522999999999998},{"$f":"IF(AND(LEN(C10)>0,VALUE(C10)>0),VLOOKUP(C10,km_verplaatsing,2,TRUE),\"\")","v":2.7800000000000002}]
["je","2023-02-02",null,"",null,"",null,"",null,"",{"$f":"IF(OR(LEN(D11)>0,LEN(E11)>0,LEN(G11)>0,LEN(I11)>0),IF(LEN(D11)>0,D11,0)+IF(LEN(F11)>0,F11,0)+IF(LEN(H11)>0,H11,0)+IF(LEN(J11)>0,J11,0),\"\")","v":""},""]
["ve","2023-02-03",2,0,null,"",5,0.78950000000000009,null,"",0.78950000000000009,2.7800000000000002]
["sa","2023-02-04",null,"",null,"",null,"",null,"","",""]
["di","2023-02-05",null,"",null,"",null,"",null,"","",""]
["lu","2023-02-06",null,"",null,"",null,"",null,"","",""]
["ma","2023-02-07",null,"",null,"",null,"",null,"","",""]
["me","2023-02-08",null,"",null,"",null,"",null,"","",""]
["je","2023-02-09",null,"",null,"",null,"",null,"","",""]
["ve","2023-02-10",null,"",null,"",null,"",null,"","",""]
["sa","2023-02-11",null,"",null,"",null,"",null,"","",""]
["di","2023-02-12",null,"",null,"",null,"",null,"","",""]
["lu","2023-02-13",null,"",null,"",null,"",null,"","",""]
["ma","2023-02-14",null,"",null,"",null,"",null,"","",""]
["me","2023-02-15",null,"",null,"",null,"",null,"","",""]
["je","2023-02-16",null,"",null,"",null,"",null,"","",""]
["ve","2023-02-17",null,"",null,"",null,"",null,"","",""]
["sa","2023-02-18",null,"",null,"",null,"",null,"","",""]
["di","2023-02-19",null,"",null,"",null,"",null,"","",""]
["lu","2023-02-20",null,"",null,"",null,"",null,"","",""]
["ma","2023-02-21",null,"",null,"",null,"",null,"","",""]
["me","2023-02-22",null,"",null,"",null,"",null,"","",""]
["je","2023-02-23",null,"",null,"",null,"",null,"","",""]
["ve","2023-02-24",null,"",null,"",null,"",null,"","",""]
["sa","2023-02-25",null,"",null,"",null,"",null,"","",""]
["di","2023-02-26",null,"",null,"",null,"",null,"","",""]
["lu","2023-02-27",null,"",null,"",null,"",null,"","",""]
["ma","2023-02-28",null,"",null,"",null,"",null,"","",""]
["Montants totals du mois:",null,null,{"$f":"SUM(D10:D37)","v":0.3095},null,{"$f":"SUM(F10:F37)","v":0.7427999999999999},null,{"$f":"SUM(H10:H37)","v":0.78950000000000009},null,{"$f":"SUM(J10:J37)","v":0},{"$f":"SUM(K10:K37)","v":1.8417999999999999},{"$f":"SUM(L10:L37)","v":5.5600000000000005}]
[]
["montant total du trimestre:"]

{"sheet":"Barema","index":7,"n_rows":145,"n_cols":11,"rows_kept":145,"cut":false,"hidden":false,"merged":[]}
[null,null,"Mobiliteitsvergoeding",null,null,"Kwartaal","Maand","Mois",null,null,"Verplaatsingsvergoeding"]
[null,"KM","Passagier","Chauffeur","Chauffeur (alleen)",1,"jan","jan",null,"KM","Vergoeding"]
[null,null,null,null,null,null,"feb","fév"]
[null,0,6.1899999999999997E-2,0.15790000000000001,0.1,null,"maa","mars",null,2,2.7800000000000002]
[null,60,6.7599999999999993E-2,0.15790000000000001,0.106,2,"apr","avr",null,4,2.7800000000000002]
[null,78,7.0000000000000007E-2,0.15790000000000001,0.1085,null,"mei","mai",null,6,2.7800000000000002]
[null,104,7.2400000000000006E-2,0.15790000000000001,0.111,null,"jun","juin",null,8,3.02]
[null,130,7.7299999999999994E-2,0.15790000000000001,0.1162,3,"jul","juil",null,10,3.28]
[null,156,8.1799999999999998E-2,0.15790000000000001,0.12089999999999999,null,"aug","août",null,12,3.4799999999999995]
[null,208,8.4400000000000003E-2,0.15790000000000001,0.1236,null,"sep","sept",null,14,3.7]
[null,260,8.6800000000000002E-2,0.15790000000000001,0.12609999999999999,4,"okt","oct",null,16,3.9]
[null,null,null,null,null,null,"nov","nov",null,18,4.32]
[null,null,null,null,null,null,"dec","déc",null,20,4.5200000000000005]
[null,null,null,null,null,null,null,null,null,22,4.74]
[null,null,null,null,null,null,null,null,null,24,4.9399999999999995]
[null,null,null,null,null,null,null,null,null,26,5.16]
[null,null,null,null,null,null,null,null,null,28,5.36]
[null,null,null,null,null,null,null,null,null,30,5.58]
[null,null,null,null,null,null,null,null,null,32,5.7799999999999994]
[null,null,null,null,null,null,null,null,null,34,6]
[null,null,null,null,null,null,null,null,null,36,6.4]
[null,null,null,null,null,null,null,null,null,38,6.4]
[null,null,null,null,null,null,null,null,null,40,6.62]
[null,null,null,null,null,null,null,null,null,42,6.82]
[null,null,null,null,null,null,null,null,null,44,7.24]
[null,null,null,null,null,null,null,null,null,46,7.4599999999999991]
[null,null,null,null,null,null,null,null,null,48,7.6599999999999993]
[null,null,null,null,null,null,null,null,null,50,7.88]
[null,null,null,null,null,null,null,null,null,52,8.08]
[null,null,null,null,null,null,null,null,null,54,8.3000000000000007]
[null,null,null,null,null,null,null,null,null,56,8.5]
[null,null,null,null,null,null,null,null,null,58,8.84]
[null,null,null,null,null,null,null,null,null,60,8.84]
[null,null,null,null,null,null,null,null,null,62,9.36]
[null,null,null,null,null,null,null,null,null,64,9.36]
[null,null,null,null,null,null,null,null,null,66,9.36]
[null,null,null,null,null,null,null,null,null,68,9.36]
[null,null,null,null,null,null,null,null,null,70,9.879999999999999]
[null,null,null,null,null,null,null,null,null,72,9.879999999999999]
[null,null,null,null,null,null,null,null,null,74,10.379999999999999]
[null,null,null,null,null,null,null,null,null,76,10.379999999999999]
[null,null,null,null,null,null,null,null,null,78,10.9]
[null,null,null,null,null,null,null,null,null,80,10.9]
[null,null,null,null,null,null,null,null,null,82,11.42]
[null,null,null,null,null,null,null,null,null,84,11.42]
[null,null,null,null,null,null,null,null,null,86,11.42]
[null,null,null,null,null,null,null,null,null,88,11.92]
[null,null,null,null,null,null,null,null,null,90,11.92]
[null,null,null,null,null,null,null,null,null,92,11.92]
[null,null,null,null,null,null,null,null,null,94,12.28]
[null,null,null,null,null,null,null,null,null,96,12.28]
[null,null,null,null,null,null,null,null,null,98,12.66]
[null,null,null,null,null,null,null,null,null,100,12.66]
[null,null,null,null,null,null,null,null,null,102,12.66]
[null,null,null,null,null,null,null,null,null,104,13.02]
[null,null,null,null,null,null,null,null,null,106,13.5]
[null,null,null,null,null,null,null,null,null,108,13.5]
[null,null,null,null,null,null,null,null,null,110,13.5]
[null,null,null,null,null,null,null,null,null,112,13.5]
[null,null,null,null,null,null,null,null,null,114,14.12]
[null,null,null,null,null,null,null,null,null,116,14.12]
[null,null,null,null,null,null,null,null,null,118,14.12]
[null,null,null,null,null,null,null,null,null,120,14.12]
[null,null,null,null,null,null,null,null,null,122,14.719999999999999]
[null,null,null,null,null,null,null,null,null,124,14.719999999999999]
[null,null,null,null,null,null,null,null,null,126,14.719999999999999]
[null,null,null,null,null,null,null,null,null,128,14.719999999999999]
[null,null,null,null,null,null,null,null,null,130,15.34]
[null,null,null,null,null,null,null,null,null,132,15.940000000000001]
[null,null,null,null,null,null,null,null,null,134,15.940000000000001]
[null,null,null,null,null,null,null,null,null,136,15.940000000000001]
[null,null,null,null,null,null,null,null,null,138,15.940000000000001]
[null,null,null,null,null,null,null,null,null,140,16.559999999999999]
[null,null,null,null,null,null,null,null,null,142,16.559999999999999]
[null,null,null,null,null,null,null,null,null,144,16.559999999999999]
[null,null,null,null,null,null,null,null,null,146,16.559999999999999]
[null,null,null,null,null,null,null,null,null,148,17.16]
[null,null,null,null,null,null,null,null,null,150,17.16]
[null,null,null,null,null,null,null,null,null,152,17.16]
[null,null,null,null,null,null,null,null,null,154,17.16]
[null,null,null,null,null,null,null,null,null,156,18.380000000000003]
[null,null,null,null,null,null,null,null,null,158,18.380000000000003]
[null,null,null,null,null,null,null,null,null,160,18.380000000000003]
[null,null,null,null,null,null,null,null,null,162,18.380000000000003]
[null,null,null,null,null,null,null,null,null,164,19]
[null,null,null,null,null,null,null,null,null,166,19]
[null,null,null,null,null,null,null,null,null,168,19]
[null,null,null,null,null,null,null,null,null,170,19.600000000000001]
[null,null,null,null,null,null,null,null,null,172,19.600000000000001]
[null,null,null,null,null,null,null,null,null,174,19.600000000000001]
[null,null,null,null,null,null,null,null,null,176,20.22]
[null,null,null,null,null,null,null,null,null,178,20.22]
[null,null,null,null,null,null,null,null,null,180,20.22]
[null,null,null,null,null,null,null,null,null,182,20.22]
[null,null,null,null,null,null,null,null,null,184,20.82]
[null,null,null,null,null,null,null,null,null,186,20.82]
[null,null,null,null,null,null,null,null,null,188,20.82]
[null,null,null,null,null,null,null,null,null,190,20.82]
[null,null,null,null,null,null,null,null,null,192,21.44]
[null,null,null,null,null,null,null,null,null,194,21.44]
[null,null,null,null,null,null,null,null,null,196,21.44]
[null,null,null,null,null,null,null,null,null,198,21.44]
[null,null,null,null,null,null,null,null,null,200,22.04]
[null,null,null,null,null,null,null,null,null,202,22.04]
[null,null,null,null,null,null,null,null,null,204,22.04]
[null,null,null,null,null,null,null,null,null,206,22.04]
[null,null,null,null,null,null,null,null,null,208,22.64]
[null,null,null,null,null,null,null,null,null,210,23.259999999999998]
[null,null,null,null,null,null,null,null,null,212,23.259999999999998]
[null,null,null,null,null,null,null,null,null,214,23.259999999999998]
[null,null,null,null,null,null,null,null,null,216,23.259999999999998]
[null,null,null,null,null,null,null,null,null,218,24.119999999999997]
[null,null,null,null,null,null,null,null,null,220,24.119999999999997]
[null,null,null,null,null,null,null,null,null,222,24.119999999999997]
[null,null,null,null,null,null,null,null,null,224,24.4]
[null,null,null,null,null,null,null,null,null,226,24.4]
[null,null,null,null,null,null,null,null,null,228,24.4]
[null,null,null,null,null,null,null,null,null,230,24.4]
[null,null,null,null,null,null,null,null,null,232,25]
[null,null,null,null,null,null,null,null,null,234,25]
[null,null,null,null,null,null,null,null,null,236,25]
[null,null,null,null,null,null,null,null,null,238,25]
[null,null,null,null,null,null,null,null,null,240,25.6]
[null,null,null,null,null,null,null,null,null,242,25.6]
[null,null,null,null,null,null,null,null,null,244,25.6]
[null,null,null,null,null,null,null,null,null,246,26.4]
[null,null,null,null,null,null,null,null,null,248,26.4]
[null,null,null,null,null,null,null,null,null,250,26.4]
[null,null,null,null,null,null,null,null,null,252,26.4]
[null,null,null,null,null,null,null,null,null,254,27]
[null,null,null,null,null,null,null,null,null,256,27]
[null,null,null,null,null,null,null,null,null,258,27]
[null,null,null,null,null,null,null,null,null,260,27.6]
[null,null,null,null,null,null,null,null,null,262,28.2]
[null,null,null,null,null,null,null,null,null,264,28.2]
[null,null,null,null,null,null,null,null,null,266,28.2]
[null,null,null,null,null,null,null,null,null,268,28.2]
[null,null,null,null,null,null,null,null,null,270,28.8]
[null,null,null,null,null,null,null,null,null,272,28.8]
[null,null,null,null,null,null,null,null,null,274,28.8]
[null,null,null,null,null,null,null,null,null,276,29.4]
[null,null,null,null,null,null,null,null,null,278,29.4]
[null,null,null,null,null,null,null,null,null,280,29.4]
[null,null,null,null,null,null,null,null,null,282,29.4]
[null,null,null,null,null,null,null,null,null,284,30]