{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["tableau","ville","Feuil3"],"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":"tableau","index":0,"n_rows":95,"n_cols":7,"rows_kept":95,"cut":false,"hidden":false,"merged":[]}
["lieu d'achat","numéro","achat","gains","total","total cumulé","pourcentage gain ville"]
["GUER",1,-76,0,{"$f":"D2-C2","v":76},-76,{"$f":"AVERAGE(B2:F2,D2)","v":-12.5}]
["GUER",2,null,0,{"$f":"D3-C3","v":0},{"$f":"F2+E3","v":-76},{"$f":"AVERAGE(B3:F3,D3)","v":-14.8}]
["GUER",1,2,0,-2,{"$f":"F3+E4","v":-78},-12.833333333333334]
["GUER",1,2,0,-2,-80,-13.166666666666666]
["GUER",1,2,2,0,-80,-12.166666666666666]
["GUER",1,2,0,-2,-82,-13.5]
["GUER",1,2,0,-2,-84,-13.833333333333334]
["GUER",1,2,0,-2,-86,-14.166666666666666]
["GUER",1,2,0,-2,-88,-14.5]
["GUER",2,2,0,-2,-90,-14.666666666666666]
["GUER",1,2,4,2,-88,-12.5]
["GUER",1,2,10,8,-80,-8.1666666666666661]
["GUER",1,2,4,2,-78,-10.833333333333334]
["GUER",1,2,0,-2,-80,-13.166666666666666]
["GUER",1,2,0,-2,-82,-13.5]
["GUER",1,2,4,2,-80,-11.166666666666666]
["GUER",1,2,0,-2,-82,-13.5]
["GUER",1,2,10,8,-74,-7.166666666666667]
["GUER",1,2,0,-2,-76,-12.5]
["GUER",1,2,0,-2,-78,-12.833333333333334]
["GUER",1,2,4,2,-76,-10.5]
["GUER",1,2,4,2,-74,-10.166666666666666]
["GUER",1,2,4,2,-72,-9.8333333333333339]
["GUER",1,2,0,-2,-74,-12.166666666666666]
["GUER",1,2,0,-2,-76,-12.5]
["GUER",1,2,10,8,-68,-6.166666666666667]
["GUER",1,2,0,-2,-70,-11.5]
["GUER",1,2,0,-2,-72,-11.833333333333334]
["GUER",1,2,0,-2,-74,-12.166666666666666]
["GUER",1,2,0,-2,-76,-12.5]
["GUER",1,2,0,-2,-78]
[null,1]
[null,2]
["GUER"]
["GUER"]
["GUER"]
["GUER"]
["GUER"]
["GUER"]
["GUER"]
["GUER"]
["GUER"]
["GUER"]
["GUER"]
["GUER"]
["GUER"]
["GUER"]
["GUER"]
["GUER"]
["GUER"]
["GUER"]
["GUER"]
["GUER"]
["GUER"]
["GUER"]
["GUER"]
["GUER"]
["GUER"]
["GUER"]
["GUER"]
["GUER"]
["GUER"]
["GUER"]
["GUER"]
["GUER"]
["GUER"]
["GUER"]
["GUER"]
["GUER",1]
["GUER",1]
["GUER",1]
["GUER",1]
["GUER",1]
["GUER",1]
["GUER",1]
["GUER",1]
["GUER",1]
["GUER",1]
["GUER",1]
["GUER",1]
["GUER",1]
["GUER",1]
["GUER",1]
["GUER",1]
["GUER",1]
["GUER",1]
["GUER",1]
["GUER",1]
["GUER",1]
["GUER",1]
["GUER",1]
["GUER",1]
["GUER",1]
["GUER",1]

{"sheet":"ville","index":1,"n_rows":72,"n_cols":4,"rows_kept":72,"cut":false,"hidden":false,"merged":[]}
["nombre","villes","pourcentage","gain"]
[{"$f":"IF(B2=\"\",\"\",VLOOKUP(B2,ville!$A$2:$B$11,2,0))","v":0},"GUER",{"$f":"AVERAGE(A2:B2,D2)","v":0},0]
[{"$f":"IF(B3=\"\",\"\",VLOOKUP(B3,ville!$A$2:$B$11,2,0))","v":0},"PLOERMEL",null,0]
[{"$f":"IF(B4=\"\",\"\",VLOOKUP(B4,ville!$A$2:$B$11,2,0))","v":0},"VANNES",null,0]
[null,null,null,0]
[null,null,null,2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]

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