{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Cuve","Camions"],"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":"Cuve","index":0,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Date","Quantité livrée","Prix/L","Quantité consommée","Reste"]
["2022-11-12",2000,1.3,2000,0,"Ne pas toucher aux colonnes D et E elles sont remplies per la macro"]
["2022-12-04",3000,1.5,650,2250]
[null,null,null,null,null,"Lorsqu'un quantité livrée est rentrée la même valeur est mis par la macro dans la colonne Reste"]
[]
[null,null,null,null,null,"Pour voir la macro commentée Clic droit sur l'onglet Cuve puis Visualiser le code"]

{"sheet":"Camions","index":1,"n_rows":21,"n_cols":8,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Date","Camion","Nb Litres","Prix"]
[null,"A",400,520,null,"La macro se déclenche quand on rentre un litrage en C"]
[null,"B",350,455,null,"Elle calcule le prix et remplit la colonne D, puis met à jour la feuille Cuve"]
[null,"C",400,520]
[null,"A",400,520,null,"Clic- droit sur l'onglet de la feuille Camions puis Visualiser le code pour voir la macro commentée"]
[null,"C",400,520]
[null,"D",400,590]
[null,"E",300,450]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null," "]