{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Feuil1","Feuil2","Feuil3"],"not_rendered":{"charts":1,"images":0,"macros":0,"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":"Feuil1","index":0,"n_rows":22,"n_cols":5,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["DATE","MONTANT","MOIS/MOIS","DEBUT","MOYENNE"]
["05-13",18000," ",null,{"$f":"AVERAGE($B$2:$B$13)","v":20827.833333333332}]
["2016-03-01",21250,{"$f":"B3-B2","v":3250},{"$f":"B3-$B$2","v":3250},{"$f":"$E$2","v":20827.833333333332}]
["2016-04-01",20500,{"$f":"B4-B3","v":-750},{"$f":"B4-$B$2","v":2500},{"$f":"$E$2","v":20827.833333333332}]
["2016-05-01",21005,{"$f":"B5-B4","v":505},{"$f":"B5-$B$2","v":3005},20827.833333333332]
["2016-06-01",21009,{"$f":"B6-B5","v":4},{"$f":"B6-$B$2","v":3009},20827.833333333332]
["2016-07-01",19500,{"$f":"B7-B6","v":-1509},{"$f":"B7-$B$2","v":1500},20827.833333333332]
["2016-08-01",23000,{"$f":"B8-B7","v":3500},{"$f":"B8-$B$2","v":5000},20827.833333333332]
["2016-09-01",20500,{"$f":"B9-B8","v":-2500},{"$f":"B9-$B$2","v":2500},20827.833333333332]
["2016-10-01",21450,{"$f":"B10-B9","v":950},{"$f":"B10-$B$2","v":3450},20827.833333333332]
["2016-11-01",20600,{"$f":"B11-B10","v":-850},{"$f":"B11-$B$2","v":2600},20827.833333333332]
["2016-12-01",21220,{"$f":"B12-B11","v":620},{"$f":"B12-$B$2","v":3220},20827.833333333332]
["2017-01-01",21900,{"$f":"B13-B12","v":680},{"$f":"B13-$B$2","v":3900},20827.833333333332]
[]
[]
[]
["Contraintes :","La ligne 2 (05-13) ne doit pas disparaitre"]
[null,"Calcul sur 12 mois glissants dont le mois d'origine (ligne 2)"]
["Mon souhait :","En février 2017, je crée une ligne avec les nouvelles valeurs, puis comment supprimer (ou remplacer, ou effacer….) la ligne 3 (pour garder mes 12 mois glissants) et faire en sorte que le graphique se mette"]
[null,"à jour automatiquement. Dans mes nombreux essais, les coordonnées passent de a13 et b13, à a12 et b12."]
[]
["Merci d'avance"]

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

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