{"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":140,"n_cols":7,"rows_kept":140,"cut":false,"hidden":false,"merged":[]}
["lieu d'achat","numéro","achat","gains","total","total cumulé","pourcentage gain ville"]
[{"$f":"IF($B2<>\"\",(VLOOKUP($B2,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,-76,0,{"$f":"D2-C2","v":76},-76,{"$f":"AVERAGE(A2:F2,D2)","v":-12.5}]
[{"$f":"IF($B3<>\"\",(VLOOKUP($B3,ville!$A$2:$B$4,2,0)),\"\")","v":"PLOERMEL"},2,null,0,{"$f":"D3-C3","v":0},{"$f":"F2+E3","v":-76},-14.8]
[{"$f":"IF($B4<>\"\",(VLOOKUP($B4,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,{"$f":"F3+E4","v":-78},-12.833333333333334]
[{"$f":"IF($B5<>\"\",(VLOOKUP($B5,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-80,-13.166666666666666]
[{"$f":"IF($B6<>\"\",(VLOOKUP($B6,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,2,0,-80,-12.166666666666666]
[{"$f":"IF($B7<>\"\",(VLOOKUP($B7,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-82,-13.5]
[{"$f":"IF($B8<>\"\",(VLOOKUP($B8,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-84,-13.833333333333334]
[{"$f":"IF($B9<>\"\",(VLOOKUP($B9,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-86,-14.166666666666666]
[{"$f":"IF($B10<>\"\",(VLOOKUP($B10,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-88,-14.5]
[{"$f":"IF($B11<>\"\",(VLOOKUP($B11,ville!$A$2:$B$4,2,0)),\"\")","v":"PLOERMEL"},2,2,0,-2,-90,-14.666666666666666]
[{"$f":"IF($B12<>\"\",(VLOOKUP($B12,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,4,2,-88,-12.5]
[{"$f":"IF($B13<>\"\",(VLOOKUP($B13,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,10,8,-80,-8.1666666666666661]
[{"$f":"IF($B14<>\"\",(VLOOKUP($B14,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,4,2,-78,-10.833333333333334]
[{"$f":"IF($B15<>\"\",(VLOOKUP($B15,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-80,-13.166666666666666]
[{"$f":"IF($B16<>\"\",(VLOOKUP($B16,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-82,-13.5]
[{"$f":"IF($B17<>\"\",(VLOOKUP($B17,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,4,2,-80,-11.166666666666666]
[{"$f":"IF($B18<>\"\",(VLOOKUP($B18,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-82,-13.5]
[{"$f":"IF($B19<>\"\",(VLOOKUP($B19,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,10,8,-74,-7.166666666666667]
[{"$f":"IF($B20<>\"\",(VLOOKUP($B20,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-76,-12.5]
[{"$f":"IF($B21<>\"\",(VLOOKUP($B21,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-78,-12.833333333333334]
[{"$f":"IF($B22<>\"\",(VLOOKUP($B22,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,4,2,-76,-10.5]
[{"$f":"IF($B23<>\"\",(VLOOKUP($B23,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,4,2,-74,-10.166666666666666]
[{"$f":"IF($B24<>\"\",(VLOOKUP($B24,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,4,2,-72,-9.8333333333333339]
[{"$f":"IF($B25<>\"\",(VLOOKUP($B25,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-74,-12.166666666666666]
[{"$f":"IF($B26<>\"\",(VLOOKUP($B26,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-76,-12.5]
[{"$f":"IF($B27<>\"\",(VLOOKUP($B27,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,10,8,-68,-6.166666666666667]
[{"$f":"IF($B28<>\"\",(VLOOKUP($B28,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-70,-11.5]
[{"$f":"IF($B29<>\"\",(VLOOKUP($B29,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-72,-11.833333333333334]
[{"$f":"IF($B30<>\"\",(VLOOKUP($B30,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-74,-12.166666666666666]
[{"$f":"IF($B31<>\"\",(VLOOKUP($B31,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-76,-12.5]
[{"$f":"IF($B32<>\"\",(VLOOKUP($B32,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-78]
[{"$f":"IF($B33<>\"\",(VLOOKUP($B33,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-80]
[{"$f":"IF($B34<>\"\",(VLOOKUP($B34,ville!$A$2:$B$4,2,0)),\"\")","v":"PLOERMEL"},2,2,0,-2,-82]
[{"$f":"IF($B35<>\"\",(VLOOKUP($B35,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-84]
[{"$f":"IF($B36<>\"\",(VLOOKUP($B36,ville!$A$2:$B$4,2,0)),\"\")","v":"PLOERMEL"},2,6,0,-6,-90]
[{"$f":"IF($B37<>\"\",(VLOOKUP($B37,ville!$A$2:$B$4,2,0)),\"\")","v":"PLOERMEL"},2,2,0,-2,-92]
[{"$f":"IF($B38<>\"\",(VLOOKUP($B38,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,4,2,-90]
[{"$f":"IF($B39<>\"\",(VLOOKUP($B39,ville!$A$2:$B$4,2,0)),\"\")","v":"PLOERMEL"},2,2,0,-2,-92]
[{"$f":"IF($B40<>\"\",(VLOOKUP($B40,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-94]
[{"$f":"IF($B41<>\"\",(VLOOKUP($B41,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,10,8,-86]
[{"$f":"IF($B42<>\"\",(VLOOKUP($B42,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-88]
[{"$f":"IF($B43<>\"\",(VLOOKUP($B43,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,2,0,-88]
[{"$f":"IF($B44<>\"\",(VLOOKUP($B44,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-90]
[{"$f":"IF($B45<>\"\",(VLOOKUP($B45,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,4,2,-88]
[{"$f":"IF($B46<>\"\",(VLOOKUP($B46,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-90]
[{"$f":"IF($B47<>\"\",(VLOOKUP($B47,ville!$A$2:$B$4,2,0)),\"\")","v":"PLOERMEL"},2,2,0,-2,-92]
[{"$f":"IF($B48<>\"\",(VLOOKUP($B48,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,null,-92]
[{"$f":"IF($B49<>\"\",(VLOOKUP($B49,ville!$A$2:$B$4,2,0)),\"\")","v":"PLOERMEL"},2,2,0,-2,-94]
[{"$f":"IF($B50<>\"\",(VLOOKUP($B50,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-96]
[{"$f":"IF($B51<>\"\",(VLOOKUP($B51,ville!$A$2:$B$4,2,0)),\"\")","v":"PLOERMEL"},2,2,null,{"$f":"D69-C51","v":0},-96]
[{"$f":"IF($B52<>\"\",(VLOOKUP($B52,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-98]
[{"$f":"IF($B53<>\"\",(VLOOKUP($B53,ville!$A$2:$B$4,2,0)),\"\")","v":"PLOERMEL"},2,2,0,-2,-100]
[{"$f":"IF($B54<>\"\",(VLOOKUP($B54,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-102]
[{"$f":"IF($B55<>\"\",(VLOOKUP($B55,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-104]
[{"$f":"IF($B56<>\"\",(VLOOKUP($B56,ville!$A$2:$B$4,2,0)),\"\")","v":"PLOERMEL"},2,2,2,0,-104]
[{"$f":"IF($B57<>\"\",(VLOOKUP($B57,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-106]
[{"$f":"IF($B58<>\"\",(VLOOKUP($B58,ville!$A$2:$B$4,2,0)),\"\")","v":"PLOERMEL"},2,2,0,-2,-108]
[{"$f":"IF($B59<>\"\",(VLOOKUP($B59,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-110]
[{"$f":"IF($B60<>\"\",(VLOOKUP($B60,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,2,0,-110]
[{"$f":"IF($B61<>\"\",(VLOOKUP($B61,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,2,0,-110]
[{"$f":"IF($B62<>\"\",(VLOOKUP($B62,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-112]
[{"$f":"IF($B63<>\"\",(VLOOKUP($B63,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,2,0,-112]
[{"$f":"IF($B64<>\"\",(VLOOKUP($B64,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-114]
[{"$f":"IF($B65<>\"\",(VLOOKUP($B65,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-116]
[{"$f":"IF($B66<>\"\",(VLOOKUP($B66,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-118]
[{"$f":"IF($B67<>\"\",(VLOOKUP($B67,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-120]
[{"$f":"IF($B68<>\"\",(VLOOKUP($B68,ville!$A$2:$B$4,2,0)),\"\")","v":"PLOERMEL"},2,2,0,-2,{"$f":"F67+E68","v":-122}]
[{"$f":"IF($B69<>\"\",(VLOOKUP($B69,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,2,0,-122]
[{"$f":"IF($B70<>\"\",(VLOOKUP($B70,ville!$A$2:$B$4,2,0)),\"\")","v":"PLOERMEL"},2,6,0,-6,-128]
[{"$f":"IF($B71<>\"\",(VLOOKUP($B71,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-130]
[{"$f":"IF($B72<>\"\",(VLOOKUP($B72,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,10,8,-122]
[{"$f":"IF($B73<>\"\",(VLOOKUP($B73,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-124]
[{"$f":"IF($B74<>\"\",(VLOOKUP($B74,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,2,0,-124]
[{"$f":"IF($B75<>\"\",(VLOOKUP($B75,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-126]
[{"$f":"IF($B76<>\"\",(VLOOKUP($B76,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,2,0,-126]
[{"$f":"IF($B77<>\"\",(VLOOKUP($B77,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-128]
[{"$f":"IF($B78<>\"\",(VLOOKUP($B78,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-130]
[{"$f":"IF($B79<>\"\",(VLOOKUP($B79,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,2,0,-130]
[{"$f":"IF($B80<>\"\",(VLOOKUP($B80,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-132]
[{"$f":"IF($B81<>\"\",(VLOOKUP($B81,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,10,8,-124]
[{"$f":"IF($B82<>\"\",(VLOOKUP($B82,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,{"$f":"F81+E82","v":-126}]
[{"$f":"IF($B83<>\"\",(VLOOKUP($B83,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,{"$f":"F82+E83","v":-128}]
[{"$f":"IF($B84<>\"\",(VLOOKUP($B84,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,2,0,{"$f":"F83+E84","v":-128}]
[{"$f":"IF($B85<>\"\",(VLOOKUP($B85,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-130]
[{"$f":"IF($B86<>\"\",(VLOOKUP($B86,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,{"$f":"D86-C86","v":-2},-132]
[{"$f":"IF($B87<>\"\",(VLOOKUP($B87,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,4,2,-130]
[{"$f":"IF($B88<>\"\",(VLOOKUP($B88,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,4,6,2,-128]
[{"$f":"IF($B89<>\"\",(VLOOKUP($B89,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-130]
[{"$f":"IF($B90<>\"\",(VLOOKUP($B90,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-132]
[{"$f":"IF($B91<>\"\",(VLOOKUP($B91,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-134]
[{"$f":"IF($B92<>\"\",(VLOOKUP($B92,ville!$A$2:$B$4,2,0)),\"\")","v":"GUER"},1,2,0,-2,-136]
["GUER",1,2,2,0,-136]
["GUER",1,2,4,2,-134]
["GUER",1,4,20,16,-118]
["GUER",1,null,0,{"$f":"D96-C97","v":-2},-120]
["GUER",1,2,0,-2,-122]
["GUER",1,2,0,-2,-124]
["GUER",1,2,0,-2,-126]
["GUER",1,2,0,-2,-128]
["GUER",1,2,0,-2,-130]
["GUER",1,2,2,0,-130]
["GUER",1,2,20,18,-112]
["GUER",1,2,0,-2,-114]
["GUER",1,2,0,-2,-116]
["GUER",1,2,0,-2,-118]
["GUER",1,2,0,-2,-120]
["GUER",1,2,10,8,-112]
["GUER",1,2,2,0,-112]
["GUER",1,2,0,-2,-114]
["GUER",1,2,0,-2,-116]
["GUER",1,2,0,-2,-118]
["GUER",1,2,0,-2,-120]
["GUER",1,2,null,{"$f":"D113-C115","v":-2},-122]
["GUER",1,2,0,{"$f":"D115-C116","v":-2},-124]
["GUER",1,2,0,{"$f":"D116-C117","v":-2},-126]
["GUER",1,2,4,{"$f":"D117-C118","v":2},-124]
["GUER",1,2,4,{"$f":"D118-C119","v":2},-122]
["GUER",1,2,4,{"$f":"D119-C120","v":-2},-124]
["GUER",1,6,0,-6,-130]
["GUER",1,2,0,-2,-132]
["GUER",1,2,0,-2,-134]
["GUER",1,6,null,null,-134]
[null,null,null,null,null,-134]
[null,null,null,null,null,-134]
[null,null,null,null,null,-134]
[null,null,null,null,null,-134]
[null,null,null,null,null,-134]
[null,null,null,null,null,-134]
[null,null,null,null,null,-134]
[null,null,null,null,null,-134]
[null,null,null,null,null,-134]
[null,null,null,null,null,-134]
[null,null,null,null,null,-134]
[null,null,null,null,null,-134]
[null,null,null,null,null,-134]
[null,null,null,null,null,-134]
[null,null,null,null,null,-134]
[null,null,null,null,null,-134]
[null,null,null,null,null,-134]

{"sheet":"ville","index":1,"n_rows":48,"n_cols":4,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["Numéro","villes","pourcentage","gain"]
[1,"GUER",{"$f":"AVERAGE(B48:B48,D2)","v":0},0]
[2,"PLOERMEL",null,0]
[3,"VANNES",null,0]
[null,null,null,0]
[null,null,null,2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"GUER"]

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