{"text_format":"2","workbook":"xls","n_sheets":7,"sheets":["Formulaire","Taux Client_C","Taux Client_M","Part B_C","Part B_M","Part A_D","base"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Formulaire","index":0,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Phase 1"]
["COCHER TYPE",null,"AV","CT"]
["Phase2"]
["COCHER SOCIETE",null,"C"]
[null,null,"G"]
[null,null,"A"]
[null,null,"S"]
[null,null,"EP"]
[null,null,"XA"]
[null,null,"CL"]
["Phase 3"]
["Ex: C sélectionné soit 5 Contracts relatifs à la Société C"]
["Phase 4"]
["COCHER TYPE DE MONTANT",null,null,"S","V","A"]
["Phase 5"]
["SAISIE d'un MONTANT",{"$nulls":4},"4 Conditions voir Feuille 2, 3 et 4"]
["Phase 6"]
["COCHER TYPE UTILISATEUR",null,null,"C","M","D"]
["Phase 7"]
["SAISIE TAUX % dans les cellules B24, B26,B28,B30,B32,B34"]
[null,null,"Affichage du tableau C23:I34 après la saisie des cellules"]
["Name Contract",null,"Rappel","Rappel","Formule","Rappel (Dépend du montant saisie)","Rappel (Dépend du montant saisie)","Rappel (Dépend du montant saisie)","Rappel (Dépend du montant saisie)","Rappel (Feuille PartA_D)","Rappel Statut Contract Sélectionné"]
[null,"Colonne Saisie","Colonne Rappel Taux Standard","PART A (toujours fixe comme standard)","PART B (différentiel colonne saisie - Colonne Part A)","Taux Client_C","Part B_C","Taux Client_M","Part B_M","Taux Part A_D","OPEN OR CLOSE"]
["DE TOTAL"]
[]
["FDG A"]
[]
["FDG FE"]
[]
["FDG LI"]
[]
["FDG AD"]
[]
["FDG FI"]

{"sheet":"Taux Client_C","index":1,"n_rows":5,"n_cols":8,"rows_kept":5,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["MONTANT","A","EP","G","S","C","CL","XA"]
["< 150 000",2.5,1.5,1.5,1.5,1.5,1.5,"non défini"]
["150 000 - 500 000",1.5,1.2,1.2,1.2,1.2,1.2,"non défini"]
["500 000 - 1 000 000",1.3,1,1,1,1,1,"non défini"]
["> 1 000 000",1,0.8,0.8,0.8,0.8,0.8,"non défini"]

{"sheet":"Taux Client_M","index":2,"n_rows":5,"n_cols":8,"rows_kept":5,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["MONTANT","A","EP","G","S","C","CL","XA"]
["< 150 000",2,1,1,1,1,1,"non défini"]
["150 000 - 500 000",1,0.7,0.7,0.7,0.7,0.7,"non défini"]
["500 000 - 1 000 000",0.8,0.5,0.5,0.5,0.5,0.5,"non défini"]
["> 1 000 000",0.5,0.3,0.3,0.3,0.3,0.3,"non défini"]

{"sheet":"Part B_C","index":3,"n_rows":5,"n_cols":8,"rows_kept":5,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["MONTANT","A","EP","G","S","C","CL","XA"]
["< 150 000","1,2 à 1,65",1.3,1.3,1.3,1.2,1.2,"non défini"]
["150 000 - 500 000",1,1,1,1,0.9,1,"non défini"]
["500 000 - 1 000 000",0.8,0.8,0.8,0.8,0.7,0.8,"non défini"]
["> 1 000 000",0.5,0.6,0.6,0.6,0.5,"> 0,6","non défini"]

{"sheet":"Part B_M","index":4,"n_rows":5,"n_cols":8,"rows_kept":5,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["MONTANT","A","EP","G","S","C","CL","XA"]
["< 150 000","0,7 à 1,15",0.8,0.8,0.8,0.7,0.7,"non  défini"]
["150 000 - 500 000",0.5,0.5,0.5,0.5,0.4,0.5,"non  défini"]
["500 000 - 1 000 000",0.3,0.3,0.3,0.3,0.2,0.3,"non  défini"]
["> 1 000 000",0,0.1,0.1,0.1,0,">0,1","non  défini"]

{"sheet":"Part A_D","index":5,"n_rows":5,"n_cols":8,"rows_kept":5,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["MONTANT","A","EP","G","S","C","CL","XA"]
["< 150 000","0,85 à 1,3",0.2,0.2,0.2,0.3,0.3,"non défini"]
["150 000 - 500 000",0.3,0.2,0.2,0.2,0.3,0.2,"non défini"]
["500 000 - 1 000 000",0.5,0.2,0.2,0.2,0.3,0.2,"non défini"]
["> 1 000 000",0.5,0.2,0.2,0.2,0.3," à voir","non défini"]

{"sheet":"base","index":6,"n_rows":48,"n_cols":22,"rows_kept":48,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["SOCIETE","CONTRACT","Statut ","MONTANT MiniPart A","DE TOTAL","DE A","DE B","FDG A","FDG A A","FDG A B","FDG FE ","FDG FE A","FDG FE B","FDG LI ","FDG LI A","FDG LI B","FDG AD","FDG AD A","FDG AD B","FDG FI ","FDG FI A","FDG FI B"]
["A"," A","OPEN",null,3.15,0.5,2.65,0.5,0.25,0.25,0.65,0.325,null,0.75,0.375,0.375,"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"}]
["A","ESS","OPEN",null,3.15,1,2.15,0.5,0.25,0.25,0.75,0.375,null,0.75,0.375,0.375,"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"}]
["A","PRI(Hq)","OPEN",null,3.15,0.2,2.9499999999999997,0,0,0,0.65,0.325,null,0.75,0.375,0.375,"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"}]
["A","PRI (Q)","OPEN",null,3.15,0,3.15,0,0,0,0.65,0.4,null,0.75,0.375,0.375,"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"}]
["G","TRAVIE ","OPEN",null,4.5,0.2,4.3,"0,5 plafonné à 200€",1,{"$error":"#VALUE!"},0.6,0.4,null,"0,90%LIEx& 0,80% LIGr",0.4,{"$error":"#VALUE!"},"0,90%LIEx& 0,80% LIGr",0.4,{"$error":"#VALUE!"},1.2,0,1.2]
["G","TRACAPI ","OPEN",null,4.5,0.2,4.3,"0,5 plafonné à 200€",1,{"$error":"#VALUE!"},0.6,0.4,null,"0,90%LIEx& 0,80% LIGr",0.4,{"$error":"#VALUE!"},"0,90%LIEx& 0,80% LIGr",0.4,{"$error":"#VALUE!"},1.2,0,1.2]
["G","AGVI",null,null,4.5,0.2,4.3,"0,5 plafonné à 200€",2,{"$error":"#VALUE!"},0.8,0.4,null,"0,90%LIEx& 0,80% LIGr",0.4,{"$error":"#VALUE!"},"0,90%LIEx& 0,80% LIGr",0.4,{"$error":"#VALUE!"},1.2,0,1.2]
["EP","TransExcVie ","OPEN",null,3,0.2,2.8,"0,5 plafonné à 150€",0.25,{"$error":"#VALUE!"},0.96,0.5,null,0.96,0.35,0.61,0.96,0.35,0.61,1,0,1]
["EP","TransExcCa","OPEN",null,3,0.2,2.8,"0,5 plafonné à 150€",0.25,{"$error":"#VALUE!"},0.96,0.5,null,0.96,0.35,0.61,0.96,0.35,0.61,1,0,1]
["S","OPTCAP","OPEN",null,1.5,0.2,1.3,0.5,0.5,0,0.6,0.4,null,0.8,0.4,0.4,"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"}]
["S","OPTVI","OPEN",null,1.5,0.2,1.3,0.5,0.5,0,0.6,0.4,null,0.8,0.4,0.4,"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"}]
["S","REL VARI","OPEN",null,1.5,0.5,1,"Interdit","Interdit",{"$error":"#VALUE!"},"ND","ND",null,0.8,0.55,0.25,"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"}]
["S","LONG VAR","OPEN",null,1.5,0.5,1,"Interdit","Interdit",{"$error":"#VALUE!"},"ND","ND",null,0.8,0.55,0.25,"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"}]
["CL","LUXINT A","OPEN","< 250 k€",4,0.3,3.7,1,0.33,0.6699999999999999,0.96,0.6,null,0.96,0.5,0.45999999999999996,1.11,"0,45 à 0,75",{"$error":"#VALUE!"},0.7,0,0.7]
["CL","LUXINT A","OPEN","250 k€ - 1 M€",4,0.2,3.8,1,0.33,0.6699999999999999,0.96,0.6,null,0.96,0.5,0.45999999999999996,1.11,"0,45 à 0,75",{"$error":"#VALUE!"},0.7,0,0.7]
["CL","LUXINT A","OPEN","> 1 M€",4,"A voir",{"$error":"#VALUE!"},1,0.33,0.6699999999999999,0.96,0.6,null,"A voir","A voir",{"$error":"#VALUE!"},"A voir","A voir",{"$error":"#VALUE!"},"A voir","A voir",{"$error":"#VALUE!"}]
["CL","MINV","OPEN","< 250 k€",4,0.3,3.7,1,0.33,0.6699999999999999,0.96,0.6,null,0.96,0.5,0.45999999999999996,1.11,"0,45 à 0,75",{"$error":"#VALUE!"},0.7,0,0.7]
["CL","MINV","OPEN","250 k€ - 1 M€",4,0.2,3.8,1,0.33,0.6699999999999999,0.96,0.6,null,0.96,0.5,0.45999999999999996,1.11,"0,45 à 0,75",{"$error":"#VALUE!"},0.7,0,0.7]
["CL","MINV","OPEN","> 1 M€",4,"A voir",{"$error":"#VALUE!"},1,0.33,0.6699999999999999,0.96,0.6,null,"A voir","A voir",{"$error":"#VALUE!"},"A voir","A voir",{"$error":"#VALUE!"},"A voir","A voir",{"$error":"#VALUE!"}]
["A","LivASS","OPEN","> 150 k€",2.85,0.5,2.35,0.5,0.25,0.25,0.55,0.28,null,"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"}]
["A","LivASS","OPEN","50-150 k€",2.85,0.85,2,0.5,0.25,0.25,0.55,0.28,null,"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"}]
["A","LivASS","OPEN","5-50 k€",2.85,1.15,1.7000000000000002,0.5,0.25,0.25,0.55,0.28,null,"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"}]
["A","LivASS","OPEN","< 5 k€",2.85,1.3,1.55,0.5,0.25,0.25,0.55,0.28,null,"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"}]
["A","AssRe","CLOSE","> 150 k€",3.85,0.5,3.35,0.5,0.25,0.25,0.55,0.28,null,"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"}]
["A","AssRe","CLOSE","50-150 k€",3.85,0.85,3,0.5,0.25,0.25,0.55,0.28,null,"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"}]
["A","AssRe","CLOSE","5-50 k€",3.85,1.15,2.7,0.5,0.25,0.25,0.55,0.28,null,"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"}]
["A","AssRe","CLOSE","< 5 k€",3.85,1.3,2.55,0.5,0.25,0.25,0.55,0.28,null,"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"}]
["A","ASR ZON","CLOSE","> 150 k€",3.85,0.5,3.35,0.5,0.25,0.25,0.75,0.375,null,"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"}]
["A","ASR ZON","CLOSE","50-150 k€",3.85,0.85,3,0.5,0.25,0.25,0.75,0.375,null,"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"}]
["A","ASR ZON","CLOSE","5-50 k€",3.85,1.15,2.7,0.5,0.25,0.25,0.75,0.375,null,"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"}]
["A","ASR ZON","CLOSE","< 5 k€",3.85,1.3,2.55,0.5,0.25,0.25,0.75,0.375,null,"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"}]
["ACM","PATROR","CLOSE",null,1.65,0,1.65,0.5,0.25,0.25,0.65,0.45,null,0.8,0.55,0.25,"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"}]
["ACM","PATROB ","CLOSE","> 150 k€",1.65,0.5,1.15,0.5,0.25,0.25,0.65,0.45,null,0.8,0.55,0.25,"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"}]
["ACM","PATROB ","CLOSE","50-150 k€",1.65,0.85,0.7999999999999999,0.5,0.25,0.25,0.65,0.45,null,0.8,0.55,0.25,"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"}]
["ACM","PATROB ","CLOSE","5-50 k€",1.65,1.15,0.5,0.5,0.25,0.25,0.65,0.45,null,0.8,0.55,0.25,"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"}]
["ACM","PATROB ","CLOSE","< 5 k€",1.65,1.3,0.34999999999999987,0.5,0.25,0.25,0.65,0.45,null,0.8,0.55,0.25,"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"}]
["ACM","RETRREV","CLOSE","> 150 k€",4,0.5,3.5,0.5,0.25,0.25,1,0.5,null,"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"}]
["ACM","RETRREV","CLOSE","50-150 k€",4,0.85,3.15,0.5,0.25,0.25,1,0.5,null,"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"}]
["ACM","RETRREV","CLOSE","5-50 k€",4,1.15,2.85,0.5,0.25,0.25,1,0.5,null,"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"}]
["ACM","RETRREV","CLOSE","< 5 k€",4,1.3,2.7,0.5,0.25,0.25,1,0.5,null,"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"}]
["CL","TRANASSTOINE ","CLOSE",null,4,0.3,3.7,1000,null,1000,{"$nulls":8},0,null,null,0]
["CL","TRANASSTOINE ","CLOSE",null,4,0.3,3.7,1000,null,1000,{"$nulls":8},0,null,null,0]
["CL","TRANSLIF","CLOSE",null,4,0.25,3.75,0.01,null,0.01,{"$nulls":8},0,null,null,0]
["G","ESPINVT 3","CLOSE",null,4.5,0,4.5,0.6,0.6,0,0.6,0.4,null,0.96,0.5,null,"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"}]
["G","ESINV","CLOSE",null,4.5,0,4.5,0.6,0.6,0,0.6,0.4,null,0.96,0.5,null,"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"}]
["G","ESPINV 4","CLOSE",null,4.5,0,4.5,"0,6  plafonné 200€","15€+50% des F",{"$error":"#VALUE!"},0.8,0.6,null,0.96,0.5,null,"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"}]
["G","ESINV","CLOSE",null,4.5,0,4.5,"0,6  plafonné 200€","15€+50% des F",{"$error":"#VALUE!"},0.8,0.6,null,0.96,0.5,null,"ND","ND",{"$error":"#VALUE!"},"ND","ND",{"$error":"#VALUE!"}]