{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Calcul des frais"],"not_rendered":{"charts":0,"images":2,"macros":0,"external_links":0,"defined_names":1,"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 des frais","index":0,"n_rows":20,"n_cols":17,"rows_kept":20,"cut":false,"hidden":false,"merged":[[11,11,12,11],[0,3,0,12],[2,3,2,12],[1,3,1,12],[13,12,18,12],[11,9,11,10],[11,8,12,8]]}
[null,null,null,{"$f":"UPPER(\"CHAMPIONNAT DE France PAR éQUIPES DE CLUBS\")","v":"CHAMPIONNAT DE FRANCE PAR ÉQUIPES DE CLUBS"}]
[]
[null,null,null,"FICHE DE FRAIS 2021-2022"]
[]
[]
[]
[null,null,null,null,null,null,"Niveau de la compétition : ","Eliminatoires"]
[null,null,null,null,null,null,"Nombre de joueurs d'une rencontre : ",3]
[]
[]
[null,null,null,null,null,0.23]
[null,null,null,null,null,"Km Aller","Nuits","Repas","Total","A verser",null,"Coût",null,null,null,"Finale",3]
[null,null,null,null,null,0.23,27.4,13.7,null,"Reçoit","Donne",null,null,null,null,"Eliminatoires",4]
[null,null,null,"Club recevant",null,0,{"$f":"IF(F14*2<100,0,IF(AND(F14*2>400,$H$7=\"Finale\"),2*$H$8,$H$8))","v":0},{"$f":"IF(D14=\"\",0,IF($H$7=\"Finale\",3*$H$8,IF(AND($H$7=\"Eliminatoires\",(F14*2)<100),$H$8,IF(AND($H$7=\"Eliminatoires\",(F14*2)>=100),$H$8*3,0))))","v":3},{"$f":"IF(D14<>\"\",IF(G14>0,F14*2*$F$13,F14*4*$F$13)+G14*$G$13+H14*$H$13,0)","v":41.099999999999994},{"$f":"SUM(K15:K19)","v":0},{"$f":"SUM(J15:J19)","v":0},{"$f":"I14-J14+K14","v":41.099999999999994},{"$f":"SUM(I14:I19)","v":123.29999999999998}]
[null,null,null,"club 2",null,null,{"$f":"IF(F15*2<100,0,IF(AND(F15*2>400,$H$7=\"Finale\"),2*$H$8,$H$8))","v":0},3,41.099999999999994,{"$f":"IF(D15<>\"\",IF(I15<$M$20,0,I15-$M$20),0)","v":0},{"$f":"IF(D15<>\"\",IF(I15>$M$20,0,$M$20-I15),0)","v":0},41.099999999999994]
[null,null,null,"club 3",null,null,0,3,41.099999999999994,{"$f":"IF(D16<>\"\",IF(I16<$M$20,0,I16-$M$20),0)","v":0},{"$f":"IF(D16<>\"\",IF(I16>$M$20,0,$M$20-I16),0)","v":0},41.099999999999994]
[null,null,null,null,null,null,0,0,0,{"$f":"IF(D17<>\"\",IF(I17<$M$20,0,I17-$M$20),0)","v":0},{"$f":"IF(D17<>\"\",IF(I17>$M$20,0,$M$20-I17),0)","v":0},0]
[null,null,null,null,null,null,0,0,0,{"$f":"IF(D18<>\"\",IF(I18<$M$20,0,I18-$M$20),0)","v":0},{"$f":"IF(D18<>\"\",IF(I18>$M$20,0,$M$20-I18),0)","v":0},0]
[null,null,null,null,null,null,0,0,0,{"$f":"IF(D19<>\"\",IF(I19<$M$20,0,I19-$M$20),0)","v":0},{"$f":"IF(D19<>\"\",IF(I19>$M$20,0,$M$20-I19),0)","v":0},0]
[null,null,null,null,null,null,null,null,null,null,null,"Cout moyen :",{"$f":"M14/(6-COUNTBLANK(D14:D19))","v":41.099999999999994}]