{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Feuil1"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"Feuil1","index":0,"n_rows":10,"n_cols":10,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[null,null,"Fe","Cu","Autre","repartition","Fe","Cu"]
[null,"O1",50,null,null,{"$f":"calculval(B2)","v":"50/0"},{"$f":"VALUE(LEFT(F2,FIND(\"/\",F2)-1))","v":50},{"$f":"VALUE(RIGHT(F2,LEN(F2)-(LEN(G2)+1)))","v":0}]
[null,"O2",null,40,null,{"$f":"calculval(B3)","v":"0/40"},{"$f":"VALUE(LEFT(F3,FIND(\"/\",F3)-1))","v":0},{"$f":"VALUE(RIGHT(F3,LEN(F3)-(LEN(G3)+1)))","v":40}]
[null,"O3",10,25,"O1-2",{"$f":"calculval(B4)","v":"110/25"},110,25,null,"En colonne E Entrer les valeurs sous la forme ObjetA-nombre d'objetA/ObjetB-nombre d'objetB …etc"]
[null,"O4",null,30,"O1-1/O2-1",{"$f":"calculval(B5)","v":"50/70"},50,70]
[null,"O5",null,null,"O3-2/O4-3",{"$f":"calculval(B6)","v":"370/260"},370,260,null,"La fonction personnalisée calculval dont la formule est mise en colonne F fait le calcul et répartit entre Fe et Cu"]
[null,"O6",25,null,"O5-3",{"$f":"calculval(B7)","v":"1135/780"},1135,780,null,"ALT+F11 et aller dans Module 1 pour voir le code de la fonction "]
[null,"O7",null,null,"O1-1/O2-1/O3-1",{"$f":"calculval(B8)","v":"160/65"},160,65]
[null,"O8",15,22,"O6-2",{"$f":"calculval(B9)","v":"2285/1582"},2285,1582]
[null,"O9",5,null,"O1-1/O2-1/O3-4/O4-1/O5-1/O6-2",{"$f":"calculval(B10)","v":"3185/2030"},3185,{"$f":"VALUE(RIGHT(F10,LEN(F10)-(LEN(G10)+1)))","v":2030}]