{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"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":"Sheet1","index":0,"n_rows":29,"n_cols":13,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
["Montant Disponible",5300]
["Montant restant",null,506.44]
["Les N° de priorités restantes",null,5]
[null,null,null,null,null,null,null,"Priorité","Priorité 1","Priorité 2","Priorité 3","Priorité 4","Priorité 5"]
[null,"Prix","Priorité d'Achat","Article a acheter par priorité",null,null,null,"montant restant",5300,{"$f":"+I22","v":3767},{"$f":"+J22","v":1425},1085.44,506.44000000000005]
["Produit A",250,1,null,null,1,null,null,{"$f":"+IF(C7=1,B7,0)","v":250},{"$f":"+IF(C7=2,B7,0)","v":0},{"$f":"+IF(C7=3,B7,0)","v":0},{"$f":"+IF(C7=4,B7,0)","v":0},{"$f":"+IF(C7=5,B7,0)","v":0}]
["Produit B",125.56,3,null,null,9,null,null,{"$f":"+IF(C8=1,B8,0)","v":0},{"$f":"+IF(C8=2,B8,0)","v":0},{"$f":"+IF(C8=3,B8,0)","v":125.56},{"$f":"+IF(C8=4,B8,0)","v":0},{"$f":"+IF(C8=5,B8,0)","v":0}]
["Produit C",321,4,null,null,11,null,null,0,0,0,321,0]
["Produit D",563,2,null,null,5,null,null,0,563,0,0,0]
["Produit E",142,1,null,null,2,null,null,142,0,0,0,0]
["Produit F",236,2,null,null,6,null,null,0,236,0,0,0]
["Produit G",214,3,null,null,10,null,null,0,0,214,0,0]
["Produit H",563,1,null,null,3,null,null,563,0,0,0,0]
["Produit I",145,5,null,null,"Erreur",null,null,0,0,0,0,145]
["Produit G",854,2,null,null,7,null,null,0,854,0,0,0]
["Produit K",258,4,null,null,12,null,null,0,0,0,258,0]
["Produit L",964,5,null,null,"Erreur",null,null,0,0,0,0,964]
["Produit M",578,1,null,null,4,null,null,578,0,0,0,0]
["Produit N",689,2,null,null,8,null,null,0,689,0,0,0]
[null,null,null,null,null,null,null,null,{"$f":"+SUM(I7:I20)","v":1533},{"$f":"+SUM(J7:J20)","v":2342},339.56,579,1109]
[null,null,null,null,null,null,null,null,{"$f":"+B2-I21","v":3767},{"$f":"+J6-J21","v":1425},{"$f":"+K6-K21","v":1085.44},{"$f":"+L6-L21","v":506.44000000000005}]
[null,"Dans la colonne D a mettre des N° séquentiel des produits à acheter selon les priorités"]
[null,"Si le montant disponible est terminé ou manquant pour la nième priorité mettre erreur pour "]
[null,"tous les nième et prcedente priorités "]
[null,"comme les résultats qui ont été afficher de façon manuel dans la colonne E"]
[null,"ainsi d'enlever tous le travail des colomme H a L"]
[null,"Dans la cellule B3 mettre le montant restant à diviser de façon manuel"]
[null,"et mettre toutes les priorités restantes dans la cellule C3 avec \"et\" s'il y a plusieurs priorités"]