{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["calcul taxe","Feuil1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":1,"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 taxe","index":0,"n_rows":42,"n_cols":30,"rows_kept":42,"cut":false,"hidden":false,"merged":[[4,0,4,1],[8,0,8,1],[10,0,10,1]]}
["Remplir les cases en rose et faire les sélections pour la situation géographique et les effectifs"]
[]
[null,null,"Masse salariale",1000000]
[]
["Situation géographique",null,null,null,null,"Taxe Brute",{"$f":"IF(Y37=2,0.68%,0.44%)","v":6.8000000000000005E-3},{"$f":"IF(Y37=1,D3*AD21,D3*AD22)","v":6800}]
[]
[null,null,null,null,null,"CSA",{"$f":"IF(Y37=1,VLOOKUP(Y42,Y12:Z18,2,FALSE),VLOOKUP(Y42,Y19:Z25,2,FALSE))","v":5.0000000000000001E-4},{"$f":"G7*D3","v":500}]
[null,null,null,null,null,{"$f":" IF(H7=0,\" \",\"Reversement au CFA choisi\")","v":"Reversement au CFA choisi"}]
["Effectif et part des alternants\npar rapport à l'effectif",null,null,null,null,"Total Taxe ",null,{"$f":"H5+H7-C17","v":7300}]
[]
["Répartition de la taxe"]
[" ",null,"Hors quota",{"$f":"IF(Y37=2,H5*23%,\" \")","v":1564},null,"Quota d'apprentissage",null,{"$f":"IF(Y37=2,H5*26%,H5*49%)","v":1768},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0]
[null,null,null,null,null,"Part Région",null,{"$f":"H5*51%","v":3468},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,0]
["Répartition Hors quota si TB sup à 415 €",null,"Catégorie 1",{"$f":"D12*65%","v":1016.6},null," ",null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,3.1199999999999999E-3,null," "]
[null,null,"Catégorie 2",{"$f":"D12*35%","v":547.4},null," ",null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,2.0799999999999998E-3]
[null,null," "," ",null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,5.1999999999999995E-4]
["Déduction frais de stage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,5.1999999999999995E-4]
["maxi 3% de la TB, soit :",{"$f":"H5*3%","v":204},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,2.5999999999999998E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,6.0000000000000001E-3,null,null,"taxe ",4.4000000000000003E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,4,4.0000000000000001E-3,null,null,null,6.7999999999999996E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5,2E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6,1E-3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,5.0000000000000001E-4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"inf à 250 sal"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," + 250 salariés et quota alt sup à 5%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," + 2000 salariés et quota alt inf à 1%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," + 250 salariés et quota alt inf à 1% "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," + 250 salariés et quota alt entre 1 et 2% "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  + 250 salariés et quota alt entre 2 et 3%"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"  + 250 salariés et quota alt entre 3 et 5%"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alsace Moselle"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Reste de la France"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]

{"sheet":"Feuil1","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}