{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Accueil","abc,000÷d (5)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Accueil","index":0,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["version 1.0","2021-06-22"]
["a","Ce générateur d'opérations n'explique en rien la technique opératoire."]
["b","Cependant, il offre un guide visuel pour organiser l'algorithme."]
["c","Au démarrage de la feuille, une nouvelle série est automatiquement élaborée."]
["d","On peut générer une nouvelle série avec la touche \"F9\" du clavier sous EXCEL."]
["e","Chaque série d'opérations possède une correction. "]
["f","Personnellement, j'imprime ma série au format pdf dans un premier temps afin de pouvoir m'en servir comme support visuel pour les corrections, les explications, à l'aide du vidéo projecteur.","logiciel gratuit pour créer des pdf"]
["g","Ce pdf me sert ensuite à lancer l'impression papier."]
["h","Vous devrez peut-être faire des ajustements des marges afin d'obtenir 2 pages seulement à l'impression."]
["i","Si des caractères \"dièse\" # apparaissent, vous pouvez jouer avec le zoom de la page afin qu'ils disparaissent et révèlent le chiffre qui ne pouvait s'afficher."]
["j","Vous constatez des erreurs? Merci de me les signaler.","scalpa@scalpa.info"]
[]
["version 2.0"]
[null,"Ajout d'un onglet de divisions décimales avec des quotients pouvant aller jusqu'aux millièmes nécessitant une macro pour adapter la taille des potences."]

{"sheet":"abc,000÷d (5)","index":1,"n_rows":95,"n_cols":54,"rows_kept":95,"cut":false,"hidden":false,"merged":[[2,11,2,12],[2,37,2,38],[18,11,18,12],[18,37,18,38],[82,11,82,12],[82,37,82,38],[66,11,66,12],[66,37,66,38],[3,52,28,57],[34,11,34,12],[34,37,34,38],[50,11,50,12],[50,37,50,38]]}
[{"$f":"CONCATENATE(\"FICHE \",BB1)","v":"FICHE 774"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"RANDBETWEEN(100,999)","v":774}]
["A",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"B"]
[null,{"$f":"RANDBETWEEN(100,790)","v":652},{"$f":"RANDBETWEEN(LEFT(B3,1)+1,9)","v":8},null,{"$f":"LEFT(B3,1)","v":"6"},{"$f":"MID(B3,2,1)","v":"5"},{"$f":"RIGHT(B3,1)","v":"2"},",",0,0,0,{"$f":"C3","v":8},null,null,null,null,null,null,{"$f":"B3","v":652},"=",{"$f":"C4","v":"81,5"},"×",{"$f":"C3","v":8},"+",{"$f":"S3-(U3*W3)","v":0},null,null,{"$f":"RANDBETWEEN(100,790)","v":556},{"$f":"RANDBETWEEN(LEFT(AB3,1)+1,9)","v":9},null,{"$f":"LEFT(AB3,1)","v":"5"},{"$f":"MID(AB3,2,1)","v":"5"},{"$f":"RIGHT(AB3,1)","v":"6"},",",0,0,0,{"$f":"AC3","v":9},null,null,null,null,null,null,{"$f":"AB3","v":556},"=",{"$f":"AC4","v":"61,777"},"×",{"$f":"AC3","v":9},"+",{"$f":"AS3-(AU3*AW3)","v":6.9999999999481588E-3}]
["GAUCHE(C4;1)*C3",{"$f":"LEFT(C4,1)*C3","v":64},{"$f":"MID(B15,1,6)","v":"81,5"},"-",{"$f":"IF(LEN(B4)>1,LEFT(B4,1),\"\")","v":"6"},{"$f":"RIGHT(B4,1)","v":"4"},null,null,null,null,null,{"$f":"LEFT(B15,1)","v":"8"},{"$f":"MID(B15,2,1)","v":"1"},{"$f":"IF(MOD(B3,C3)=0,\"\",\",\")","v":","},{"$f":"MID(B15,4,1)","v":"5"},{"$f":"MID(B15,5,1)","v":""},{"$f":"MID(B15,6,1)","v":""},null,{"$f":"B3","v":652},"=",{"$f":"INT(B3/C3)","v":81},"×",{"$f":"C3","v":8},"+",{"$f":"MOD(B3,C3)","v":4},null,null,{"$f":"LEFT(AC4,1)*AC3","v":54},{"$f":"MID(AB15,1,6)","v":"61,777"},"-",{"$f":"IF(LEN(AB4)>1,LEFT(AB4,1),\"\")","v":"5"},{"$f":"RIGHT(AB4,1)","v":"4"},null,null,null,null,null,{"$f":"LEFT(AB15,1)","v":"6"},{"$f":"MID(AB15,2,1)","v":"1"},{"$f":"IF(MOD(AB3,AC3)=0,\"\",\",\")","v":","},{"$f":"MID(AB15,4,1)","v":"7"},{"$f":"MID(AB15,5,1)","v":"7"},{"$f":"MID(AB15,6,1)","v":"7"},null,{"$f":"AB3","v":556},"=",{"$f":"INT(AB3/AC3)","v":61},"×",{"$f":"AC3","v":9},"+",{"$f":"MOD(AB3,AC3)","v":7},null,"Dans cette version du générateur, la hauteur de la potence reste le seul indice présumant de la longueur du calcul (taille du quotient). La précision ira au maximum jusqu'aux millièmes. Le quotient pourra être un entier. L'écriture en ligne du résultat pourra se faire de 2 façons afin de donner du sens au reste,"]
["(CONCATENER(STXT(B3;1;2)-B4;DROITE(B3;1)))",{"$f":"(CONCATENATE(MID(B3,1,2)-B4,RIGHT(B3,1)))","v":"12"},null,null,null,{"$f":"LEFT(B5,1)","v":"1"},{"$f":"RIGHT(B5,1)","v":"2"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(CONCATENATE(MID(AB3,1,2)-AB4,RIGHT(AB3,1)))","v":"16"},null,null,null,{"$f":"LEFT(AB5,1)","v":"1"},{"$f":"RIGHT(AB5,1)","v":"6"}]
["STXT(C4;2;1)*C3",{"$f":"MID(C4,2,1)*C3","v":8},null,null,"-",{"$f":"IF(LEN(B6)>1,LEFT(B6,1),\"\")","v":""},{"$f":"RIGHT(B6,1)","v":"8"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MID(AC4,2,1)*AC3","v":9},null,null,"-",{"$f":"IF(LEN(AB6)>1,LEFT(AB6,1),\"\")","v":""},{"$f":"RIGHT(AB6,1)","v":"9"}]
["(B5-B6)*10",{"$f":"(B5-B6)*10","v":40},null,null,null,null,{"$f":"LEFT(B7,1)","v":"4"},null,{"$f":"IF(G7=\"0\",\"\",0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AB5-AB6)*10","v":70},null,null,null,null,{"$f":"LEFT(AB7,1)","v":"7"},null,{"$f":"IF(AG7=\"0\",\"\",0)","v":0}]
["SI(B7=0;\"\";SI(STXT(C4;4;1)=0;\"\";STXT(C4;4;1)*C3))",{"$f":"IF(B7=0,\"\",IF(MID(C4,4,1)=0,\"\",MID(C4,4,1)*C3))","v":40},null,null,null,"-",{"$f":"IF(LEN(B8)=2,LEFT(B8,1),\"\")","v":"4"},null,{"$f":"IF(LEN(B8)=2,RIGHT(B8,1),B8)","v":"0"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AB7=0,\"\",IF(MID(AC4,4,1)=0,\"\",MID(AC4,4,1)*AC3))","v":63},null,null,null,"-",{"$f":"IF(LEN(AB8)=2,LEFT(AB8,1),\"\")","v":"6"},null,{"$f":"IF(LEN(AB8)=2,RIGHT(AB8,1),AB8)","v":"3"}]
["SI(B7=0;\"\";(B7-B8)*10)",{"$f":"IF(B7=0,\"\",(B7-B8)*10)","v":0},null,null,null,null,null,null,{"$f":"LEFT(B9,1)","v":"0"},{"$f":"IF(I9=\"\",\"\",0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AB7=0,\"\",(AB7-AB8)*10)","v":70},null,null,null,null,null,null,{"$f":"LEFT(AB9,1)","v":"7"},{"$f":"IF(AI9=\"0\",\"\",0)","v":0}]
["SI(OU(B9=0;B8=0;B7=0);\"\";SI(STXT(C4;5;1)=0;\"\";STXT(C4;5;1)*C3))",{"$f":"IF(OR(B9=0,B8=0,B7=0),\"\",IF(MID(C4,5,1)=0,\"\",MID(C4,5,1)*C3))","v":""},null,null,null,null,"-",null,{"$f":"IF(LEN(B10)=2,LEFT(B10,1),\"\")","v":""},{"$f":"IF(LEN(B10)=2,RIGHT(B10,1),B10)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AB9=0,AB8=0,AB7=0),\"\",IF(MID(AC4,5,1)=0,\"\",MID(AC4,5,1)*AC3))","v":63},null,null,null,null,"-",null,{"$f":"IF(LEN(AB10)=2,LEFT(AB10,1),\"\")","v":"6"},{"$f":"IF(LEN(AB10)=2,RIGHT(AB10,1),AB10)","v":"3"}]
["SI(OU(B9=0;B7=0);\"\";(B9-B10)*10)",{"$f":"IF(OR(B9=0,B7=0),\"\",(B9-B10)*10)","v":""},null,null,null,null,null,null,null,{"$f":"LEFT(B11,1)","v":""},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AB9=0,AB7=0),\"\",(AB9-AB10)*10)","v":70},null,null,null,null,null,null,null,{"$f":"LEFT(AB11,1)","v":"7"},0]
["SI(OU(B11=0;B10=0;B9=0;B8=0;B7=0);\"\";SI(STXT(C4;6;1)=0;\"\";STXT(C4;6;1)*C3))",{"$f":"IF(OR(B11=0,B10=0,B9=0,B8=0,B7=0),\"\",IF(MID(C4,6,1)=0,\"\",MID(C4,6,1)*C3))","v":""},null,null,null,null,null,null,"-",{"$f":"IF(LEN(B12)=2,LEFT(B12,1),\"\")","v":""},{"$f":"IF(LEN(B12)=2,RIGHT(B12,1),B12)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AB11=0,AB10=0,AB9=0,AB8=0,AB7=0),\"\",IF(MID(AC4,6,1)=0,\"\",MID(AC4,6,1)*AC3))","v":63},null,null,null,null,null,null,"-",{"$f":"IF(LEN(AB12)=2,LEFT(AB12,1),\"\")","v":"6"},{"$f":"IF(LEN(AB12)=2,RIGHT(AB12,1),AB12)","v":"3"}]
["SI(OU(B11=0;B9=0;B7=0);\"\";(B11-B12)*10)",{"$f":"IF(OR(B11=0,B9=0,B7=0),\"\",(B11-B12))","v":""},null,null,null,null,null,null,null,null,{"$f":"B13","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AB11=0,AB9=0,AB7=0),\"\",(AB11-AB12))","v":7},null,null,null,null,null,null,null,null,{"$f":"AB13","v":7}]
[]
[null,{"$f":"B3/C3","v":81.5},{"$f":"MOD(B3,C3)","v":4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB3/AC3","v":61.777777777777779},{"$f":"MOD(AB3,AC3)","v":7}]
[]
[]
["C",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"D"]
[null,{"$f":"RANDBETWEEN(100,790)","v":573},{"$f":"RANDBETWEEN(LEFT(B19,1)+1,9)","v":7},null,{"$f":"LEFT(B19,1)","v":"5"},{"$f":"MID(B19,2,1)","v":"7"},{"$f":"RIGHT(B19,1)","v":"3"},",",0,0,0,{"$f":"C19","v":7},null,null,null,null,null,null,{"$f":"B19","v":573},"=",{"$f":"C20","v":"81,857"},"×",{"$f":"C19","v":7},"+",{"$f":"S19-(U19*W19)","v":9.9999999997635314E-4},null,null,{"$f":"RANDBETWEEN(100,790)","v":305},{"$f":"RANDBETWEEN(LEFT(AB19,1)+1,9)","v":8},null,{"$f":"LEFT(AB19,1)","v":"3"},{"$f":"MID(AB19,2,1)","v":"0"},{"$f":"RIGHT(AB19,1)","v":"5"},",",0,0,0,{"$f":"AC19","v":8},null,null,null,null,null,null,{"$f":"AB19","v":305},"=",{"$f":"AC20","v":"38,125"},"×",{"$f":"AC19","v":8},"+",{"$f":"AS19-(AU19*AW19)","v":0}]
[null,{"$f":"LEFT(C20,1)*C19","v":56},{"$f":"MID(B31,1,6)","v":"81,857"},"-",{"$f":"IF(LEN(B20)>1,LEFT(B20,1),\"\")","v":"5"},{"$f":"RIGHT(B20,1)","v":"6"},null,null,null,null,null,{"$f":"LEFT(B31,1)","v":"8"},{"$f":"MID(B31,2,1)","v":"1"},{"$f":"IF(MOD(B19,C19)=0,\"\",\",\")","v":","},{"$f":"MID(B31,4,1)","v":"8"},{"$f":"MID(B31,5,1)","v":"5"},{"$f":"MID(B31,6,1)","v":"7"},null,{"$f":"B19","v":573},"=",{"$f":"INT(B19/C19)","v":81},"×",{"$f":"C19","v":7},"+",{"$f":"MOD(B19,C19)","v":6},null,null,{"$f":"LEFT(AC20,1)*AC19","v":24},{"$f":"MID(AB31,1,6)","v":"38,125"},"-",{"$f":"IF(LEN(AB20)>1,LEFT(AB20,1),\"\")","v":"2"},{"$f":"RIGHT(AB20,1)","v":"4"},null,null,null,null,null,{"$f":"LEFT(AB31,1)","v":"3"},{"$f":"MID(AB31,2,1)","v":"8"},{"$f":"IF(MOD(AB19,AC19)=0,\"\",\",\")","v":","},{"$f":"MID(AB31,4,1)","v":"1"},{"$f":"MID(AB31,5,1)","v":"2"},{"$f":"MID(AB31,6,1)","v":"5"},null,{"$f":"AB19","v":305},"=",{"$f":"INT(AB19/AC19)","v":38},"×",{"$f":"AC19","v":8},"+",{"$f":"MOD(AB19,AC19)","v":1}]
[null,{"$f":"(CONCATENATE(MID(B19,1,2)-B20,RIGHT(B19,1)))","v":"13"},null,null,null,{"$f":"LEFT(B21,1)","v":"1"},{"$f":"RIGHT(B21,1)","v":"3"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(CONCATENATE(MID(AB19,1,2)-AB20,RIGHT(AB19,1)))","v":"65"},null,null,null,{"$f":"LEFT(AB21,1)","v":"6"},{"$f":"RIGHT(AB21,1)","v":"5"}]
[null,{"$f":"MID(C20,2,1)*C19","v":7},null,null,"-",{"$f":"IF(LEN(B22)>1,LEFT(B22,1),\"\")","v":""},{"$f":"RIGHT(B22,1)","v":"7"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MID(AC20,2,1)*AC19","v":64},null,null,"-",{"$f":"IF(LEN(AB22)>1,LEFT(AB22,1),\"\")","v":"6"},{"$f":"RIGHT(AB22,1)","v":"4"}]
[null,{"$f":"(B21-B22)*10","v":60},null,null,null,null,{"$f":"LEFT(B23,1)","v":"6"},null,{"$f":"IF(G23=\"0\",\"\",0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AB21-AB22)*10","v":10},null,null,null,null,{"$f":"LEFT(AB23,1)","v":"1"},null,{"$f":"IF(AG23=\"0\",\"\",0)","v":0}]
[null,{"$f":"IF(B23=0,\"\",IF(MID(C20,4,1)=0,\"\",MID(C20,4,1)*C19))","v":56},null,null,null,"-",{"$f":"IF(LEN(B24)=2,LEFT(B24,1),\"\")","v":"5"},null,{"$f":"IF(LEN(B24)=2,RIGHT(B24,1),B24)","v":"6"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AB23=0,\"\",IF(MID(AC20,4,1)=0,\"\",MID(AC20,4,1)*AC19))","v":8},null,null,null,"-",{"$f":"IF(LEN(AB24)=2,LEFT(AB24,1),\"\")","v":""},null,{"$f":"IF(LEN(AB24)=2,RIGHT(AB24,1),AB24)","v":8}]
[null,{"$f":"IF(B23=0,\"\",(B23-B24)*10)","v":40},null,null,null,null,null,null,{"$f":"LEFT(B25,1)","v":"4"},{"$f":"IF(I25=\"0\",\"\",0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AB23=0,\"\",(AB23-AB24)*10)","v":20},null,null,null,null,null,null,{"$f":"LEFT(AB25,1)","v":"2"},{"$f":"IF(AI25=\"0\",\"\",0)","v":0}]
[null,{"$f":"IF(OR(B25=0,B24=0,B23=0),\"\",IF(MID(C20,5,1)=0,\"\",MID(C20,5,1)*C19))","v":35},null,null,null,null,"-",null,{"$f":"IF(LEN(B26)=2,LEFT(B26,1),\"\")","v":"3"},{"$f":"IF(LEN(B26)=2,RIGHT(B26,1),B26)","v":"5"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AB25=0,AB24=0,AB23=0),\"\",IF(MID(AC20,5,1)=0,\"\",MID(AC20,5,1)*AC19))","v":16},null,null,null,null,"-",null,{"$f":"IF(LEN(AB26)=2,LEFT(AB26,1),\"\")","v":"1"},{"$f":"IF(LEN(AB26)=2,RIGHT(AB26,1),AB26)","v":"6"}]
[null,{"$f":"IF(OR(B25=0,B23=0),\"\",(B25-B26)*10)","v":50},null,null,null,null,null,null,null,{"$f":"LEFT(B27,1)","v":"5"},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AB25=0,AB23=0),\"\",(AB25-AB26)*10)","v":40},null,null,null,null,null,null,null,{"$f":"LEFT(AB27,1)","v":"4"},0]
[null,{"$f":"IF(OR(B27=0,B26=0,B25=0,B24=0,B23=0),\"\",IF(MID(C20,6,1)=0,\"\",MID(C20,6,1)*C19))","v":49},null,null,null,null,null,null,"-",{"$f":"IF(LEN(B28)=2,LEFT(B28,1),\"\")","v":"4"},{"$f":"IF(LEN(B28)=2,RIGHT(B28,1),B28)","v":"9"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AB27=0,AB26=0,AB25=0,AB24=0,AB23=0),\"\",IF(MID(AC20,6,1)=0,\"\",MID(AC20,6,1)*AC19))","v":40},null,null,null,null,null,null,"-",{"$f":"IF(LEN(AB28)=2,LEFT(AB28,1),\"\")","v":"4"},{"$f":"IF(LEN(AB28)=2,RIGHT(AB28,1),AB28)","v":"0"}]
[null,{"$f":"IF(OR(B27=0,B25=0,B23=0),\"\",(B27-B28))","v":1},null,null,null,null,null,null,null,null,{"$f":"B29","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AB27=0,AB25=0,AB23=0),\"\",(AB27-AB28))","v":0},null,null,null,null,null,null,null,null,{"$f":"AB29","v":0}]
[]
[null,{"$f":"B19/C19","v":81.857142857142861},{"$f":"MOD(B19,C19)","v":6},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB19/AC19","v":38.125},{"$f":"MOD(AB19,AC19)","v":1}]
[]
[]
["E",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F"]
[null,{"$f":"RANDBETWEEN(100,790)","v":351},{"$f":"RANDBETWEEN(LEFT(B35,1)+1,9)","v":7},null,{"$f":"LEFT(B35,1)","v":"3"},{"$f":"MID(B35,2,1)","v":"5"},{"$f":"RIGHT(B35,1)","v":"1"},",",0,0,0,{"$f":"C35","v":7},null,null,null,null,null,null,{"$f":"B35","v":351},"=",{"$f":"C36","v":"50,142"},"×",{"$f":"C35","v":7},"+",{"$f":"S35-(U35*W35)","v":5.9999999999718057E-3},null,null,{"$f":"RANDBETWEEN(100,790)","v":298},{"$f":"RANDBETWEEN(LEFT(AB35,1)+1,9)","v":4},null,{"$f":"LEFT(AB35,1)","v":"2"},{"$f":"MID(AB35,2,1)","v":"9"},{"$f":"RIGHT(AB35,1)","v":"8"},",",0,0,0,{"$f":"AC35","v":4},null,null,null,null,null,null,{"$f":"AB35","v":298},"=",{"$f":"AC36","v":"74,5"},"×",{"$f":"AC35","v":4},"+",{"$f":"AS35-(AU35*AW35)","v":0}]
[null,{"$f":"LEFT(C36,1)*C35","v":35},{"$f":"MID(B47,1,6)","v":"50,142"},"-",{"$f":"IF(LEN(B36)>1,LEFT(B36,1),\"\")","v":"3"},{"$f":"RIGHT(B36,1)","v":"5"},null,null,null,null,null,{"$f":"LEFT(B47,1)","v":"5"},{"$f":"MID(B47,2,1)","v":"0"},{"$f":"IF(MOD(B35,C35)=0,\"\",\",\")","v":","},{"$f":"MID(B47,4,1)","v":"1"},{"$f":"MID(B47,5,1)","v":"4"},{"$f":"MID(B47,6,1)","v":"2"},null,{"$f":"B35","v":351},"=",{"$f":"INT(B35/C35)","v":50},"×",{"$f":"C35","v":7},"+",{"$f":"MOD(B35,C35)","v":1},null,null,{"$f":"LEFT(AC36,1)*AC35","v":28},{"$f":"MID(AB47,1,6)","v":"74,5"},"-",{"$f":"IF(LEN(AB36)>1,LEFT(AB36,1),\"\")","v":"2"},{"$f":"RIGHT(AB36,1)","v":"8"},null,null,null,null,null,{"$f":"LEFT(AB47,1)","v":"7"},{"$f":"MID(AB47,2,1)","v":"4"},{"$f":"IF(MOD(AB35,AC35)=0,\"\",\",\")","v":","},{"$f":"MID(AB47,4,1)","v":"5"},{"$f":"MID(AB47,5,1)","v":""},{"$f":"MID(AB47,6,1)","v":""},null,{"$f":"AB35","v":298},"=",{"$f":"INT(AB35/AC35)","v":74},"×",{"$f":"AC35","v":4},"+",{"$f":"MOD(AB35,AC35)","v":2}]
[null,{"$f":"(CONCATENATE(MID(B35,1,2)-B36,RIGHT(B35,1)))","v":"01"},null,null,null,{"$f":"LEFT(B37,1)","v":"0"},{"$f":"RIGHT(B37,1)","v":"1"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(CONCATENATE(MID(AB35,1,2)-AB36,RIGHT(AB35,1)))","v":"18"},null,null,null,{"$f":"LEFT(AB37,1)","v":"1"},{"$f":"RIGHT(AB37,1)","v":"8"}]
[null,{"$f":"MID(C36,2,1)*C35","v":0},null,null,"-",{"$f":"IF(LEN(B38)>1,LEFT(B38,1),\"\")","v":""},{"$f":"RIGHT(B38,1)","v":"0"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"MID(AC36,2,1)*AC35","v":16},null,null,"-",{"$f":"IF(LEN(AB38)>1,LEFT(AB38,1),\"\")","v":"1"},{"$f":"RIGHT(AB38,1)","v":"6"}]
[null,{"$f":"(B37-B38)*10","v":10},null,null,null,null,{"$f":"LEFT(B39,1)","v":"1"},null,{"$f":"IF(G39=\"0\",\"\",0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AB37-AB38)*10","v":20},null,null,null,null,{"$f":"LEFT(AB39,1)","v":"2"},null,{"$f":"IF(AG39=\"0\",\"\",0)","v":0}]
[null,{"$f":"IF(B39=0,\"\",IF(MID(C36,4,1)=0,\"\",MID(C36,4,1)*C35))","v":7},null,null,null,"-",{"$f":"IF(LEN(B40)=2,LEFT(B40,1),\"\")","v":""},null,{"$f":"IF(LEN(B40)=2,RIGHT(B40,1),B40)","v":7},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AB39=0,\"\",IF(MID(AC36,4,1)=0,\"\",MID(AC36,4,1)*AC35))","v":20},null,null,null,"-",{"$f":"IF(LEN(AB40)=2,LEFT(AB40,1),\"\")","v":"2"},null,{"$f":"IF(LEN(AB40)=2,RIGHT(AB40,1),AB40)","v":"0"}]
[null,{"$f":"IF(B39=0,\"\",(B39-B40)*10)","v":30},null,null,null,null,null,null,{"$f":"LEFT(B41,1)","v":"3"},{"$f":"IF(I41=\"0\",\"\",0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AB39=0,\"\",(AB39-AB40)*10)","v":0},null,null,null,null,null,null,{"$f":"LEFT(AB41,1)","v":"0"},{"$f":"IF(AI41=\"\",\"\",0)","v":0}]
[null,{"$f":"IF(OR(B41=0,B40=0,B39=0),\"\",IF(MID(C36,5,1)=0,\"\",MID(C36,5,1)*C35))","v":28},null,null,null,null,"-",null,{"$f":"IF(LEN(B42)=2,LEFT(B42,1),\"\")","v":"2"},{"$f":"IF(LEN(B42)=2,RIGHT(B42,1),B42)","v":"8"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AB41=0,AB40=0,AB39=0),\"\",IF(MID(AC36,5,1)=0,\"\",MID(AC36,5,1)*AC35))","v":""},null,null,null,null,"-",null,{"$f":"IF(LEN(AB42)=2,LEFT(AB42,1),\"\")","v":""},{"$f":"IF(LEN(AB42)=2,RIGHT(AB42,1),AB42)","v":""}]
[null,{"$f":"IF(OR(B41=0,B39=0),\"\",(B41-B42)*10)","v":20},null,null,null,null,null,null,null,{"$f":"LEFT(B43,1)","v":"2"},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AB41=0,AB39=0),\"\",(AB41-AB42)*10)","v":""},null,null,null,null,null,null,null,{"$f":"LEFT(AB43,1)","v":""},0]
[null,{"$f":"IF(OR(B43=0,B42=0,B41=0,B40=0,B39=0),\"\",IF(MID(C36,6,1)=0,\"\",MID(C36,6,1)*C35))","v":14},null,null,null,null,null,null,"-",{"$f":"IF(LEN(B44)=2,LEFT(B44,1),\"\")","v":"1"},{"$f":"IF(LEN(B44)=2,RIGHT(B44,1),B44)","v":"4"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AB43=0,AB42=0,AB41=0,AB40=0,AB39=0),\"\",IF(MID(AC36,6,1)=0,\"\",MID(AC36,6,1)*AC35))","v":""},null,null,null,null,null,null,"-",{"$f":"IF(LEN(AB44)=2,LEFT(AB44,1),\"\")","v":""},{"$f":"IF(LEN(AB44)=2,RIGHT(AB44,1),AB44)","v":""}]
[null,{"$f":"IF(OR(B43=0,B41=0,B39=0),\"\",(B43-B44))","v":6},null,null,null,null,null,null,null,null,{"$f":"B45","v":6},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AB43=0,AB41=0,AB39=0),\"\",(AB43-AB44))","v":""},null,null,null,null,null,null,null,null,{"$f":"AB45","v":""}]
[]
[null,{"$f":"B35/C35","v":50.142857142857146},{"$f":"MOD(B35,C35)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB35/AC35","v":74.5},{"$f":"MOD(AB35,AC35)","v":2}]
[]
[{"$f":"CONCATENATE(\"CORRECTION FICHE \",BB1)","v":"CORRECTION FICHE 774"}]
[{"$f":"A2","v":"A"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA2","v":"B"}]
[null,{"$f":"B3","v":652},{"$f":"C3","v":8},null,{"$f":"E3","v":"6"},"5","2",",",0,0,0,8,null,{"$f":"N3","v":0},null,null,null,null,{"$f":"S3","v":652},"=","81,5","×",8,"+",0,null,null,{"$f":"AB3","v":556},{"$f":"AC3","v":9},null,{"$f":"AE3","v":"5"},"5","6",",",0,0,0,9,0,0,null,null,null,null,{"$f":"AS3","v":556},"=","61,777","×",9,"+",6.9999999999481588E-3]
[null,{"$f":"B4","v":64},{"$f":"C4","v":"81,5"},{"$f":"D4","v":"-"},{"$f":"E4","v":"6"},{"$f":"F4","v":"4"},null,null,null,null,null,{"$f":"L4","v":"8"},{"$f":"M4","v":"1"},{"$f":"N4","v":","},{"$f":"O4","v":"5"},{"$f":"P4","v":""},{"$f":"Q4","v":""},null,652,"=",81,"×",8,"+",4,null,null,{"$f":"AB4","v":54},{"$f":"AC4","v":"61,777"},{"$f":"AD4","v":"-"},{"$f":"AE4","v":"5"},{"$f":"AF4","v":"4"},null,null,null,null,null,{"$f":"AL4","v":"6"},"1",",","7","7","7",null,556,"=",61,"×",9,"+",7]
[null,{"$f":"B5","v":"12"},null,null,null,{"$f":"F5","v":"1"},"2",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB5","v":"16"},null,null,{"$f":"AE5","v":0},"1","6",0]
[null,8,null,null,{"$f":"E6","v":"-"},"","8",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,null,null,"-","","9",0]
[null,40,null,null,null,null,{"$f":"G7","v":"4"},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,null,null,null,null,{"$f":"AG7","v":"7"},0,0]
[null,40,null,null,null,{"$f":"F8","v":"-"},"4",0,"0",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63,null,null,null,{"$f":"AF8","v":"-"},"6",0,"3"]
[null,0,null,null,null,null,null,{"$f":"H9","v":0},"0",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,null,null,null,null,0,0,"7",{"$f":"AJ9","v":0}]
[null,"",null,null,null,null,{"$f":"G10","v":"-"},0,"","",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63,null,null,null,null,"-",0,"6",{"$f":"AJ10","v":"3"}]
[null,"",null,null,null,null,null,{"$f":"H11","v":0},null,{"$f":"J11","v":""},{"$f":"K11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,70,null,null,null,null,null,{"$f":"AH11","v":0},0,{"$f":"AJ11","v":"7"},{"$f":"AK11","v":0}]
[null,"",null,null,null,null,null,{"$f":"H12","v":0},{"$f":"I12","v":"-"},{"$f":"J12","v":""},{"$f":"K12","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,63,null,null,null,null,null,0,"-",{"$f":"AJ12","v":"6"},{"$f":"AK12","v":"3"}]
[null,"",null,null,null,null,null,{"$f":"H13","v":0},null,null,{"$f":"K13","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7,null,null,null,null,null,0,0,{"$f":"AJ13","v":0},{"$f":"AK13","v":7}]
[]
[null,{"$f":"B15","v":81.5},{"$f":"C15","v":4},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB15","v":61.777777777777779},{"$f":"AC15","v":7}]
[]
[]
[{"$f":"A18","v":"C"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AA18","v":"D"}]
[null,{"$f":"B19","v":573},{"$f":"C19","v":7},null,{"$f":"E19","v":"5"},"7","3",",",0,0,0,7,0,0,null,null,null,null,{"$f":"S19","v":573},"=","81,857","×",7,"+",9.9999999997635314E-4,null,null,{"$f":"AB19","v":305},{"$f":"AC19","v":8},null,{"$f":"AE19","v":"3"},"0","5",",",0,0,0,8,0,0,null,null,null,null,{"$f":"AS19","v":305},"=","38,125","×",8,"+",0]
[null,{"$f":"B20","v":56},{"$f":"C20","v":"81,857"},{"$f":"D20","v":"-"},{"$f":"E20","v":"5"},{"$f":"F20","v":"6"},null,null,null,null,null,{"$f":"L20","v":"8"},"1",",","8","5","7",null,573,"=",81,"×",7,"+",6,null,null,{"$f":"AB20","v":24},{"$f":"AC20","v":"38,125"},{"$f":"AD20","v":"-"},{"$f":"AE20","v":"2"},{"$f":"AF20","v":"4"},null,null,null,null,null,{"$f":"AL20","v":"3"},"8",",","1","2","5",null,305,"=",38,"×",8,"+",1]
[null,{"$f":"B21","v":"13"},null,null,{"$f":"E21","v":0},"1","3",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB21","v":"65"},null,null,{"$f":"AE21","v":0},"6","5",0]
[null,7,null,null,"-","","7",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,64,null,null,"-","6","4",0]
[null,60,null,null,null,{"$f":"F23","v":0},"6",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,null,null,null,{"$f":"AF23","v":0},"1",0,0]
[null,56,null,null,null,"-","5",0,"6",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8,null,null,null,"-","",0,8]
[null,40,null,null,null,null,{"$f":"G25","v":0},0,"4",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,null,null,null,null,{"$f":"AG25","v":0},0,"2",0]
[null,35,null,null,null,null,"-",0,"3","5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,null,null,null,null,"-",0,"1","6"]
[null,50,null,null,null,null,null,{"$f":"H27","v":0},0,"5",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,null,null,null,null,null,{"$f":"AH27","v":0},0,"4",0]
[null,49,null,null,null,null,null,0,"-","4","9",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,40,null,null,null,null,null,0,"-","4","0"]
[null,1,null,null,null,null,null,{"$f":"H29","v":0},null,{"$f":"J29","v":0},{"$f":"K29","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,{"$f":"AH29","v":0},null,{"$f":"AJ29","v":0},{"$f":"AK29","v":0}]
[]
[null,{"$f":"B31","v":81.857142857142861},{"$f":"C31","v":6},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB31","v":38.125},{"$f":"AC31","v":1}]
[]
[]
[{"$f":"A34","v":"E"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"F"]
[null,{"$f":"B35","v":351},7,null,"3","5","1",",",0,0,0,7,0,0,null,null,null,null,351,"=","50,142","×",7,"+",5.9999999999718057E-3,null,null,298,4,null,"2","9","8",",",0,0,0,4,0,0,null,null,null,null,298,"=","74,5","×",4,"+",0]
[null,35,"50,142","-","3","5",null,null,null,null,null,"5","0",",","1","4","2",null,351,"=",50,"×",7,"+",1,null,null,28,"74,5","-","2","8",null,null,null,null,null,"7","4",",","5","","",null,298,"=",74,"×",4,"+",2]
[null,"01",null,null,0,"0","1",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"18",null,null,0,"1","8",0]
[null,0,null,null,"-","","0",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,16,null,null,"-","1","6",0]
[null,10,null,null,null,0,"1",0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,null,null,null,0,"2",0,0]
[null,7,null,null,null,"-","",0,7,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,20,null,null,null,"-","2",0,"0"]
[null,30,null,null,null,null,0,0,"3",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,0,0,"0",0]
[null,28,null,null,null,null,"-",0,"2","8",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,"-",0,"",""]
[null,20,null,null,null,null,null,0,0,"2",0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,0,0,"",0]
[null,14,null,null,null,null,null,0,"-","1","4",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,0,"-","",""]
[null,6,null,null,null,null,null,0,null,0,6,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,0,null,0,""]
[]
[null,{"$f":"B47","v":50.142857142857146},1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,74.5,2]