{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["CALCUL","TABLEAU DE REPARTITION","Modèle"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":4,"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":"CALCUL","index":0,"n_rows":42,"n_cols":9,"rows_kept":42,"cut":false,"hidden":false,"merged":[[37,0,37,5],[37,7,37,8],[41,0,41,5],[41,7,41,8],[34,0,34,5],[34,7,34,8],[35,0,35,5],[35,7,35,8],[36,0,36,5],[36,7,36,8],[32,0,32,8],[19,0,19,2],[19,3,19,8],[21,1,21,2],[21,4,21,8],[23,0,23,8],[25,0,26,0],[25,1,26,1],[25,2,26,3],[25,4,26,6],[25,7,26,7],[25,8,26,8],[27,0,27,8],[28,0,28,8],[29,0,29,8],[30,0,30,7],[10,1,10,8],[12,1,12,8],[14,3,14,8],[16,3,16,4],[16,5,16,6],[16,7,17,8],[8,1,8,2],[8,3,8,8],[0,0,2,8],[3,0,3,8],[4,0,4,8],[5,0,5,8],[6,0,6,8]]}
["FORMULAIRE DE VERSEMENT DES 13% DU SOLDE DE LA TAXE D'APPRENTISSAGE 2021\nDécret N°2019-1491 du 27 décembre 2019"]
[]
[]
[]
["A REGLER AVANT LE 31 MAI 2021"]
[]
["VOTRE ENTREPRISE "]
[]
["SIRET SIEGE"]
[]
["RAISON SOCIALE"]
[]
["ADRESSE"]
[]
["CODE POSTAL",null,"VILLE "]
[]
["CODE NACE",null,"IDCC N°"]
[]
[]
["Personne à contacter"]
[]
["TEL",null,null,"EMAIL @"]
[]
["MASSE SALARIALE ET EFFECTIFS 2020 "]
[]
["EFFECTIF\nMOYEN 2020 ",null,null,null,"MASSE SALARIALE 2020",null,null,"A"]
[]
[]
["La masse salariale à prendre en compte est celle des établissements situés en dehors de l'Alsace Moselle. \nIl n'y a pas de 13% dans ces départements."]
[]
["Avez-vous employé un apprenti en 2020?"]
[]
["CALCUL DU SOLDE DE LA TAXE D'APPRENTISSAGE"]
[]
["TAXE BRUTE  A * 0,68%",null,null,null,null,null,"B",{"$f":"IF(AND(I31=\"OUI\",I26<109528),\"EXONERE\",I26*0.0068)","v":0},{"$f":"IF(AND(G31=\"OUI\",G26<108528),\"EXONERE\",G26*0.068)","v":0}]
["MONTANT DES 13%  B * 13%",null,null,null,null,null,"C",{"$f":"IF(AND(I31=\"OUI\",I26<109528),\"EXONERE\",H35*13%)","v":0}]
["DEDUCTIONS (voir notice)",null,null,null,null,null,"D"]
["MONTANT DES 13% A REGLER (C-D)",null,null,null,null,null,"E",{"$f":"IF(AND(I31=\"OUI\",I26<109528),\"EXONERE\",IF(0>=H36-H37,0,H36-H37))","v":0}]
[]
[]
[]
["TOTAL A REGLER",null,null,null,null,null,"F",{"$f":"IF(H38<=0,\"0   €\",H38)","v":"0   €"}]

{"sheet":"TABLEAU DE REPARTITION","index":1,"n_rows":32,"n_cols":24,"rows_kept":32,"cut":false,"hidden":false,"merged":[[28,0,28,7],[29,0,29,7],[30,0,30,7],[27,0,27,8],[0,0,0,8],[1,0,1,8],[2,0,2,7],[4,2,4,7]]}
["REPARTITION ET CHOIX DES ECOLES"]
[]
["RAPPEL DU MONTANT TOTAL A REGLER AU TITRE DES 13%",null,null,null,null,null,null,null,{"$f":"CALCUL!H42","v":"0   €"}]
[]
[null,null,"Montant maximum a attribuer aux écoles habilitées par arrêté",null,null,null,null,null,{"$f":"I3*30%","v":0}]
[]
["UAI ECOLE","ECOLE","ADRESSE","CP","VILLE","HABILITATION","MODE DE REGLEMENT","REPARTITION % ","MONTANT A VERSER"]
[null,null,null,null,null,null,null,0,{"$f":"$I$3*$H8","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(F8=\"PREFECTURE\",(I8),(0))","v":0},{"$f":"IF(F8=\"ARRETE\",(I8),(0))","v":0},{"$f":"COUNTIF(A:A,A8)","v":0},{"$f":"COUNTIF(B:B,B8)","v":0},{"$f":"IF(V8>1,V8,0)","v":0},{"$f":"IF(U8>1,U8,0)","v":0}]
[null,null,null,null,null,null,null,0,{"$f":"$I$3*$H9","v":0},null,null,null,null,null,null,null,null,null,0,0,0,0,{"$f":"IF(V9>1,V9,0)","v":0},{"$f":"IF(U9>1,U9,0)","v":0}]
[null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[null,null,null,null,null,null,null,0,0,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0]
[]
["TOTAL ECOLE PREFECTURE",null,null,null,null,null,null,null,{"$f":"S31","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W8:W27)","v":0},{"$f":"SUM(X8:X27)","v":0}]
["TOTAL ECOLES ARRÊTE",null,null,null,null,null,null,null,{"$f":"T31","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(W29:X29)","v":0}]
["TOTAL GENERAL",null,null,null,null,null,null,null,{"$f":"SUM(I8:I27)","v":0},null,null,null,null,null,null,null,null,null,{"$f":"SUM(S8:S27)","v":0},{"$f":"SUM(T8:T27)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(S31:T31)","v":0}]

{"sheet":"Modèle","index":2,"n_rows":46,"n_cols":8,"rows_kept":46,"cut":false,"hidden":false,"merged":[[21,3,21,7],[23,3,23,4],[13,0,13,7],[15,1,15,2],[15,3,15,7],[17,1,17,7],[19,1,19,7],[23,5,24,7],[26,0,26,2],[26,3,26,7],[28,1,28,2],[28,4,28,7],[32,0,32,7],[30,0,31,7],[8,0,9,7],[0,0,7,2],[11,0,11,7],[12,0,12,7],[7,4,7,5],[2,3,2,7],[3,3,3,7],[4,3,4,5],[4,6,4,7],[5,3,6,7],[10,0,10,7],[45,0,45,7],[34,1,34,7],[36,1,36,7],[35,0,35,7],[39,0,39,7],[40,0,41,7]]}
["LOGO ENTREPRISE"]
[]
[]
[]
[]
[]
[]
[null,null,null,"A",{"$f":"CALCUL!D15","v":0},null,"le",{"$f":"TODAY()","v":"2020-12-08"}]
[]
[]
["Nous vous prions de trouver ci-dessous les informations relatives au versement de la fraction 13% de la taxe d'apprentissage au bénéfice de votre établissement."]
["Nous vous remercions de nous établir dés reception un recu correspondant à notre versement conformément à la législation."]
[]
["Informations sur l'entreprise (à indiquer sur le recu)"]
[]
["SIRET SIEGE",{"$f":"CALCUL!B9","v":0}]
[]
["RAISON SOCIALE",{"$f":"CALCUL!B11","v":0}]
[]
["ADRESSE",{"$f":"CALCUL!B13","v":0}]
[]
["CODE POSTAL",{"$f":"CALCUL!B15","v":0},"VILLE ",{"$f":"CALCUL!D15","v":0}]
[]
["CODE NACE",{"$f":"CALCUL!B17","v":0},"IDCC N°",{"$f":"CALCUL!D17","v":0}]
[]
[]
["Personne à contacter",null,null,{"$f":"CALCUL!D20","v":0}]
[]
["TEL",{"$f":"CALCUL!B22","v":0},null,"EMAIL @",{"$f":"CALCUL!E22","v":0}]
[]
[]
[]
["Informations sur le réglement"]
[]
["Modalités de règlement : "]
[]
["Montant versé : "]
[]
[]
["Nous restons à votre entière disposition pour tout renseignement complémentaire. "]
["Nous esperons que ce versement vous aidera à poursuivre votre tache éducative dans les mielleures conditions, nous vous prions d'agréer, Madame , Monsieur, l'expression de nos salutations ditinguées."]
[]
[]
[]
[]
["                                                                                                      Le Service Comptable"]