{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Suivi des réparations auto"],"not_rendered":{"images":1,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Suivi des réparations auto","index":0,"n_rows":10,"n_cols":6,"rows_kept":10}
[null,"OUTIL DE SUIVI DES RÉPARATIONS AUTOMOBILES"]
[null,"TOTAL GÉNÉRAL",{"$f":"IFERROR(SUM(Réparations[MONTANT]), \"\")","v":{"v":4751.509999999999,"d":"4,751.51 $"}}]
[null,"TOTAL VÉHICULE 1",{"$f":"IFERROR(SUMIFS(Réparations[MONTANT],Réparations[VÉHICULE],Nom_Véhicule_1), \"\")","v":{"v":4032.11,"d":"4,032.11 $"}},{"$f":"\"VALEUR \"&Nom_Véhicule_1","v":"VALEUR VÉHICULE 1"},{"v":14000,"d":"14,000.00 $"},{"$f":"Nom_Véhicule_1","v":"VÉHICULE 1"}]
[null,"TOTAL VÉHICULE 2",{"$f":"IFERROR(SUMIFS(Réparations[MONTANT],Réparations[VÉHICULE],Nom_Véhicule_2), \"\")","v":{"v":719.4,"d":"719.40 $"}},{"$f":"\"VALEUR \"&Nom_Véhicule_2","v":"VALEUR VÉHICULE 2"},{"v":7000,"d":"7,000.00 $"},{"$f":"Nom_Véhicule_2","v":"VÉHICULE 2"}]
[null,"DATE","MONTANT","VÉHICULE","LIEU","DESCRIPTION"]
[null,{"$f":"TODAY()-800","v":"2016-05-17"},{"v":632.11,"d":"632.11 $"},"VÉHICULE 1","Concessionnaire","Remplacement du radiateur"]
[null,{"$f":"TODAY()-270","v":"2017-10-29"},{"v":389.87,"d":"389.87 $"},"VÉHICULE 2","Magasin de pneus","4 nouveaux pneus"]
[null,{"$f":"TODAY()-400","v":"2017-06-21"},{"v":3400,"d":"3,400.00 $"},"VÉHICULE 1","Carrossier","Réparation après collision"]
[null,{"$f":"TODAY()-90","v":"2018-04-27"},{"v":89.99,"d":"89.99 $"},"VÉHICULE 2","Magasin de pneus","Parallélisme"]
[null,{"$f":"TODAY()","v":"2018-07-26"},{"v":239.54,"d":"239.54 $"},"VÉHICULE 2","Concessionnaire","Révision des 150 000 kilomètres"]