{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Feuil1"],"not_rendered":{"charts":0,"images":0,"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":"Feuil1","index":0,"n_rows":41,"n_cols":9,"rows_kept":41,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
["Calcul des RFA 2020 :"]
[null,null,"CA","RFA","RFA"]
[null,null,null,"formule","fonction"]
["TARTAMPION SA",null,50000,{"$f":"C7*0.025","v":1250},{"$f":"Prime_CA(C7)","v":1250}]
["AUTO STAR SAS",null,150000,{"$f":"C8*0.025","v":3750},{"$f":"Prime_CA(C8)","v":3750}]
["AUTO 3000 SARL",null,350000,8750,8750]
["STERLING IMPORT SA",null,122000,3050,3050]
[]
[]
["Calcul des RFA 2020 (en fonction tranches de CA) :",null,null,null,null,null,null,"Grille de RFA"]
[null,null,"CA","RFA",null,null,null,"CA","% remise"]
[null,null,null,"fonction",null,null,null,"0-99999",0]
["TARTAMPION SA",null,50000,{"$f":"Prime_CA_grille(C16)","v":0},null,null,null,"100000-199999",1.4999999999999999E-2]
["AUTO STAR SAS",null,150000,{"$f":"Prime_CA_grille(C17)","v":2250},null,null,null,"200000-249999",0.02]
["AUTO 3000 SARL",null,350000,9625,null,null,null,"250000-299999",2.5000000000000001E-2]
["STERLING IMPORT SA",null,122000,1830,null,null,null,"300000-…",2.75E-2]
[]
[]
["Calcul des RFA 2020 (en fonction tranches de CA et par palier) :"]
[null,null,"CA","RFA"]
[null,null,null,"fonction"]
["TARTAMPION SA",null,50000,{"$f":"Prime_CA_palier(C25)","v":0}]
["AUTO STAR SAS",null,150000,{"$f":"Prime_CA_palier(C26)","v":750}]
["AUTO 3000 SARL",null,350000,5125]
["STERLING IMPORT SA",null,122000,330]
[]
["Plus d'infos :","www.auditsi.eu"]
[]
[]
["Calcul des RFA 2020 (en fonction de l'atteinte d'objectifs individuels) :",null,null,null,null,null,null,"Grille de RFA"]
[null,null,"CA réalisé","Objectif de CA","RFA",null,null,"% réalisation","% remise"]
[null,null,null,null,"fonction",null,null,">= 95 %",1.4999999999999999E-2]
["TARTAMPION SA",null,50000,10,{"$f":"Prime_Objectif(C36,D36)","v":1375},null,null,">= 100 %",0.02]
["AUTO STAR SAS",null,150000,{"$f":"Prime_CA_palier(C37)","v":750},{"$f":"Prime_Objectif(C37,D37)","v":4125},null,null,">= 105 %",2.5000000000000001E-2]
["AUTO 3000 SARL",null,350000,5125,9625,null,null,">= 110 %",2.75E-2]
["STERLING IMPORT SA",null,122000,330,3355]
[]
["Plus d'infos :","www.auditsi.eu"]