{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["IDEES D'AMELIORATION ERP","Accueil","Devis","Devis refusés","Facturation","Factures établies (archives)","Clients","Charges","Résultat","Parc de bus"],"not_rendered":{"charts":0,"images":12,"macros":1,"external_links":2,"defined_names":9,"comments":1,"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":"IDEES D'AMELIORATION ERP","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Accueil","index":1,"n_rows":2,"n_cols":8,"rows_kept":2,"cut":false,"hidden":false,"merged":[[1,7,5,14]]}
[]
[null,null,null,null,null,null,null,"AT TRANSPORT"]

{"sheet":"Devis","index":2,"n_rows":46,"n_cols":9,"rows_kept":46,"cut":false,"hidden":false,"merged":[[0,1,1,4],[2,6,2,8]]}
["AT TRANSPORT","DEVIS"]
["3 Rue Louis de Funès"]
["13090 Les Milles",null,null,null,null,"Numéro client",5]
["0442637383",null,null,null,null,"Nom société",{"$f":"VLOOKUP(G3,Clients!A:G,3,FALSE)","v":"Lyon"}]
[null,null,null,null,null,"Adresse",{"$f":"VLOOKUP(G3,Clients!A:G,4,FALSE)","v":"117 Avenue Mozart"}]
[null,null,null,null,null,"Code postal",{"$f":"VLOOKUP(G3,Clients!A:G,5,FALSE)","v":69005}]
[null,null,null,null,null,"Ville",{"$f":"VLOOKUP(G3,Clients!A:G,6,FALSE)","v":"Lyon"}]
[null,null,null,null,null,"N°téléphone",{"$f":"VLOOKUP(G3,Clients!A:G,7,FALSE)","v":478302069}]
[]
[]
["Réf",1]
["Date",{"$f":"TODAY()","v":"2017-03-28"}]
[]
[]
["Détails"]
["Date prestation","Marque ","Modèle","Trajet",null,"Km parcourus","PU km","Montant HT","Tarif de base"]
[]
["2017-03-22","RENAULT","R4192","venelles aix",null,50,{"$f":"IFERROR(VLOOKUP(C18,Tableau2[[Modèle]:[Facturation au KM]],9),\"\")","v":8},{"$f":"IFERROR(F18*G18,\"\")","v":400},{"$f":"IFERROR(VLOOKUP(C18,Tableau2[[Modèle]:[Prix de la location]],10),\"\")","v":240}]
["2017-02-10","IVECO","AS490",null,null,12,{"$f":"IFERROR(VLOOKUP(C19,Tableau2[[Modèle]:[Facturation au KM]],9),\"\")","v":12},{"$f":"IFERROR(F19*G19,\"\")","v":144},{"$f":"IFERROR(VLOOKUP(C19,Tableau2[[Modèle]:[Prix de la location]],10),\"\")","v":360}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C20,Tableau2[[Modèle]:[Facturation au KM]],9),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(C20,Tableau2[[Modèle]:[Prix de la location]],10),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C21,Tableau2[[Modèle]:[Facturation au KM]],9),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(C21,Tableau2[[Modèle]:[Prix de la location]],10),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C22,Tableau2[[Modèle]:[Facturation au KM]],9),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(C22,Tableau2[[Modèle]:[Prix de la location]],10),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C23,Tableau2[[Modèle]:[Facturation au KM]],9),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(C23,Tableau2[[Modèle]:[Prix de la location]],10),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C24,Tableau2[[Modèle]:[Facturation au KM]],9),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(C24,Tableau2[[Modèle]:[Prix de la location]],10),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C25,Tableau2[[Modèle]:[Facturation au KM]],9),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(C25,Tableau2[[Modèle]:[Prix de la location]],10),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C26,Tableau2[[Modèle]:[Facturation au KM]],9),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(C26,Tableau2[[Modèle]:[Prix de la location]],10),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C27,Tableau2[[Modèle]:[Facturation au KM]],9),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(C27,Tableau2[[Modèle]:[Prix de la location]],10),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C28,Tableau2[[Modèle]:[Facturation au KM]],9),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(C28,Tableau2[[Modèle]:[Prix de la location]],10),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C29,Tableau2[[Modèle]:[Facturation au KM]],9),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(C29,Tableau2[[Modèle]:[Prix de la location]],10),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C30,Tableau2[[Modèle]:[Facturation au KM]],9),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(C30,Tableau2[[Modèle]:[Prix de la location]],10),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C31,Tableau2[[Modèle]:[Facturation au KM]],9),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(C31,Tableau2[[Modèle]:[Prix de la location]],10),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C32,Tableau2[[Modèle]:[Facturation au KM]],9),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(C32,Tableau2[[Modèle]:[Prix de la location]],10),\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(C33,Tableau2[[Modèle]:[Facturation au KM]],9),\"\")","v":""},"",{"$f":"IFERROR(VLOOKUP(C33,Tableau2[[Modèle]:[Prix de la location]],10),\"\")","v":""}]
[null,null,null,null,null,null,"Montant HT",null,{"$f":"SUM(H18:I33)","v":1144}]
[null,null,null,null,null,null,"Taux TVA",null,0.1]
[null,null,null,null,null,null,"Montant TVA",null,{"$f":"I34*I35","v":114.4}]
[null,null,null,null,null,null,"Montant TTC",null,{"$f":"I34+I36","v":1258.4000000000001}]
[]
[]
["Paiement à 15 jours dès réception de la facture.",null,null,"Pénalités en cas de retard : 1,5 fois le taux d'intérêt légal en vigueur"]
[]
[]
[]
["Siret",null,null,null,"BANQUE"]
["Code APE",null,null,null,"IBAN","xxxXXXXxxXX"]
[null,null,null,null,"BIC","xxxXXX"]

{"sheet":"Devis refusés","index":3,"n_rows":1,"n_cols":13,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["N° Devis","Date Devis","N° client","Nom société","Date prestation","Marque ","Modèle","Trajet","Km parcourus","PU km","Montant HT","Tarif de base","Montant TTC"]

{"sheet":"Facturation","index":4,"n_rows":46,"n_cols":9,"rows_kept":46,"cut":false,"hidden":false,"merged":[[34,6,34,7],[35,6,35,7],[36,6,36,7],[0,1,1,4],[3,6,3,8],[33,6,33,7],[7,6,7,7]]}
["AT TRANSPORT","FACTURE"]
["3 Rue Louis de Funès"]
["139 Les Milles",null,null,null,null,"Numéro client",{"$f":"Devis!G3","v":5}]
[442637383,null,null,null,null,"Nom société",{"$f":"Devis!G4","v":"Lyon"}]
[null,null,null,null,null,"Adresse",{"$f":"Devis!G5","v":"117 Avenue Mozart"}]
[null,null,null,null,null,"Code postal",{"$f":"Devis!G6","v":69005}]
[null,null,null,null,null,"Ville",{"$f":"Devis!G7","v":"Lyon"}]
[null,null,null,null,null,"N°téléphone",{"$f":"Devis!G8","v":478302069}]
[]
[]
["Réf"]
["Date"]
[]
[]
["Détails"]
["Date prestation","Marque ","Modèle","Trajet",null,"Km parcourus","PU km","Montant HT","Tarif de base"]
[{"$f":"+Devis!A17","v":0},{"$f":"+Devis!B17","v":0},{"$f":"+Devis!C17","v":0},{"$f":"+Devis!D17","v":0},{"$f":"+Devis!E17","v":0}]
[{"$f":"IF(A18=\"\",\"\",+Devis!A18)","v":0},{"$f":"+Devis!B18","v":"RENAULT"},{"$f":"+Devis!C18","v":"R4192"},{"$f":"+Devis!D18","v":"venelles aix"},{"$f":"+Devis!E18","v":0},{"$f":"+Devis!F18","v":50},{"$f":"+Devis!G18","v":8},{"$f":"+Devis!H18","v":400},{"$f":"+Devis!I18","v":240}]
[{"$f":"IF(A19=\"\",\"\",+Devis!A19)","v":0},{"$f":"+Devis!B19","v":"IVECO"},{"$f":"+Devis!C19","v":"AS490"},{"$f":"+Devis!D19","v":0},{"$f":"+Devis!E19","v":0},{"$f":"+Devis!F19","v":12},{"$f":"+Devis!G19","v":12},{"$f":"+Devis!H19","v":144},{"$f":"+Devis!I19","v":360}]
[{"$f":"IF(A20=0,\"\",+Devis!A20)","v":0},{"$f":"+Devis!B20","v":0},{"$f":"+Devis!C20","v":0},{"$f":"+Devis!D20","v":0},{"$f":"+Devis!E20","v":0},{"$f":"+Devis!F20","v":0},{"$f":"+Devis!G20","v":""},{"$f":"+Devis!H20","v":""},{"$f":"+Devis!I20","v":""}]
[{"$f":"IF(A21=0,\"\",+Devis!A21)","v":0},{"$f":"+Devis!B21","v":0},{"$f":"+Devis!C21","v":0},{"$f":"+Devis!D21","v":0},{"$f":"+Devis!E21","v":0},{"$f":"+Devis!F21","v":0},{"$f":"+Devis!G21","v":""},{"$f":"+Devis!H21","v":""},{"$f":"+Devis!I21","v":""}]
[{"$f":"IF(A22=0,\"\",+Devis!A22)","v":0},{"$f":"+Devis!B22","v":0},{"$f":"+Devis!C22","v":0},{"$f":"+Devis!D22","v":0},{"$f":"+Devis!E22","v":0},{"$f":"+Devis!F22","v":0},{"$f":"+Devis!G22","v":""},{"$f":"+Devis!H22","v":""},{"$f":"+Devis!I22","v":""}]
[{"$f":"IF(A23=0,\"\",+Devis!A23)","v":0},{"$f":"+Devis!B23","v":0},{"$f":"+Devis!C23","v":0},{"$f":"+Devis!D23","v":0},{"$f":"+Devis!E23","v":0},{"$f":"+Devis!F23","v":0},{"$f":"+Devis!G23","v":""},{"$f":"+Devis!H23","v":""},{"$f":"+Devis!I23","v":""}]
[{"$f":"IF(A24=0,\"\",+Devis!A24)","v":0},{"$f":"+Devis!B24","v":0},{"$f":"+Devis!C24","v":0},{"$f":"+Devis!D24","v":0},{"$f":"+Devis!E24","v":0},{"$f":"+Devis!F24","v":0},{"$f":"+Devis!G24","v":""},{"$f":"+Devis!H24","v":""},{"$f":"+Devis!I24","v":""}]
[{"$f":"IF(A25=0,\"\",+Devis!A25)","v":0},{"$f":"+Devis!B25","v":0},{"$f":"+Devis!C25","v":0},{"$f":"+Devis!D25","v":0},{"$f":"+Devis!E25","v":0},{"$f":"+Devis!F25","v":0},{"$f":"+Devis!G25","v":""},{"$f":"+Devis!H25","v":""},{"$f":"+Devis!I25","v":""}]
[{"$f":"IF(A26=0,\"\",+Devis!A26)","v":0},{"$f":"+Devis!B26","v":0},{"$f":"+Devis!C26","v":0},{"$f":"+Devis!D26","v":0},{"$f":"+Devis!E26","v":0},{"$f":"+Devis!F26","v":0},{"$f":"+Devis!G26","v":""},{"$f":"+Devis!H26","v":""},{"$f":"+Devis!I26","v":""}]
[{"$f":"IF(A27=0,\"\",+Devis!A27)","v":0},{"$f":"+Devis!B27","v":0},{"$f":"+Devis!C27","v":0},{"$f":"+Devis!D27","v":0},{"$f":"+Devis!E27","v":0},{"$f":"+Devis!F27","v":0},{"$f":"+Devis!G27","v":""},{"$f":"+Devis!H27","v":""},{"$f":"+Devis!I27","v":""}]
[{"$f":"IF(A28=0,\"\",+Devis!A28)","v":0},{"$f":"+Devis!B28","v":0},{"$f":"+Devis!C28","v":0},{"$f":"+Devis!D28","v":0},{"$f":"+Devis!E28","v":0},{"$f":"+Devis!F28","v":0},{"$f":"+Devis!G28","v":""},{"$f":"+Devis!H28","v":""},{"$f":"+Devis!I28","v":""}]
[{"$f":"IF(A29=0,\"\",+Devis!A29)","v":0},{"$f":"+Devis!B29","v":0},null,{"$f":"+Devis!D29","v":0},{"$f":"+Devis!E29","v":0},null,null,{"$f":"+Devis!H29","v":""}]
[{"$f":"IF(A30=0,\"\",+Devis!A30)","v":0},{"$f":"+Devis!B30","v":0},null,{"$f":"+Devis!D30","v":0},{"$f":"+Devis!E30","v":0},null,null,{"$f":"+Devis!H30","v":""}]
[{"$f":"IF(A31=0,\"\",+Devis!A31)","v":0},{"$f":"+Devis!B31","v":0},null,{"$f":"+Devis!D31","v":0},{"$f":"+Devis!E31","v":0},null,null,{"$f":"+Devis!H31","v":""}]
[{"$f":"IF(A32=0,\"\",+Devis!A32)","v":0},{"$f":"+Devis!B32","v":0},null,{"$f":"+Devis!D32","v":0},{"$f":"+Devis!E32","v":0},null,null,{"$f":"+Devis!H32","v":""}]
[{"$f":"IF(A33=0,\"\",+Devis!A33)","v":0},{"$f":"+Devis!B33","v":0},null,{"$f":"+Devis!D33","v":0},{"$f":"+Devis!E33","v":0},null,null,{"$f":"+Devis!H33","v":""}]
[null,null,null,null,null,null,"Montant HT",null,{"$f":"SUM(H18:I33)","v":1144}]
[null,null,null,null,null,null,"Taux TVA",null,{"$f":"Devis!I35","v":0.1}]
[null,null,null,null,null,null,"Montant TVA",null,{"$f":"I34*I35","v":114.4}]
[null,null,null,null,null,null,"Montant TTC",null,{"$f":"I34+I36","v":1258.4000000000001}]
[]
[]
["Paiement à 15 jours dès réception de la facture.",null,null,"Pénalités en cas de retard : 1,5 fois le taux d'intérêt légal en vigueur"]
[]
[]
[]
["Siret",null,null,null,"BANQUE"]
["Code APE",null,null,null,"IBAN"]
[null,null,null,null,"BIC"]

{"sheet":"Factures établies (archives)","index":5,"n_rows":1,"n_cols":13,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["N° Facture","Dte facture","N° client","Nom société","Date prestation","Marque ","Modèle","Trajet","Km parcourus","PU km","Montant HT","Tarif de base","Montant TTC"]

{"sheet":"Clients","index":6,"n_rows":35,"n_cols":7,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
["Numero client","Secteur d'activité","Nom du client","Adresse","Code postal","Ville","téléphone"]
[1,"Club de Rugby","RC Toulon","17 rue madon",83002,"Toulon",442255864]
[2,"Club de Rugby","Stade Toulousain","152 rue des pins",31000,"Toulouse",451256987]
[3,"Club de Rugby","Clermont Ferrand","36 avenue des champs",63000,"Clermont",495458930]
[4,"Club de Rugby","Grenoble ","14 route de Berg",38000,"Grenoble",456369125]
[5,"Club de Rugby","Lyon","117 Avenue Mozart",69005,"Lyon",478302069]
[6,"Club de Rugby","Marseille","88 avenue Sopraba",13002,"Marseille",491253092]
[7,"Club de Rugby","Castres","19 rue jaimal",81000,"Castres",476980209]
[8,"Club de Rugby","Biarritz","47 route des oliviers",64200,"Biarritz",470154607]
[9,"Club de Rugby","Perpignan","25 boulevard jobard",66000,"Perpignan",429583996]
[10,"Club de Rugby","Bayonne","14 boulevard joliette",64100,"Bayonne",415061599]
[11,"Club de Football","OM","115 la commanderie",13012,"Marseille",491253913]
[12,"Club de Football","AS Monaco","36 avenue le rocher",98000,"Monaco",419292037]
[13,"Club de Football","Nice","20 avenue des anglais",6000,"Nice",491068905]
[14,"Club de Football","Montpellier","274 rue la paillade",34000,"Montpellier",459583036]
[15,"Club de Football","Nimes","1 route des roses",30000,"Nimes",459251702]
[16,"Club de Football","AS Cannes","3 rue des bourgeois",6400,"Cannes",412069851]
[17,"Club de Football","Lyon","5 avenue des tulipes",69000,"Lyon",429120958]
[18,"Club de Football","St Etienne","7 chemin des verts",42000,"St-Etienne",441044239]
[19,"Club de Football","Marseille Consolat","10 route des fleurs",13012,"Marseille",491590202]
[20,"Club de Football","Aix ","77 cours mirabeau",13090,"Aix-en-Provence",492097475]
[21,"Handball","Aix ","8 rue du chemin rouge",13090,"Aix-en-Provence",452990630]
[22,"Handball","Istres","2 boulevard Méditerrannée",13118,"Istres",493262649]
[23,"Handball","Nimes ","16 avenue des crocodiles",30000,"Nimes",493262650]
[24,"Handball","Montpellier","9 chemin de la fosse",34000,"Montpellier",491026943]
[25,"Handball","St Raphael","12 boulevard de la plage",83530,"St-Raphael",412963674]
[26,"Basket","Venelles","4 rue Cousto",13770,"Venelles",496392014]
[27,"Basket","Aix ","5 avenue Beethoven",13090,"Aix-en-Provence",491207896]
[28,"Basket","Marseille","1 cours sextius",13001,"Marseille",491493697]
[29,"Hockey","Gap","32 route marguerite",5000,"Gap",492520369]
[30,"Hockey","Marseille","6 avenue Saglisse",13003,"Marseille",491395201]
[31,"Hockey","Briancon","10 chemin des bulles",5100,"Briancon",492410139]
[32,"Volleyball","Aix ","8 rue rotonde",13090,"Aix-en-Provence",490584123]
[33,"Volleyball","Marignane","4 avenue poisson",13250,"Marignane",497208696]
[34,"Volleyball","Istres","87 boulevard Pompidou",13118,"Istres",491263974]

{"sheet":"Charges","index":7,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[[7,2,7,3],[7,4,7,5]]}
["Charges N"]
[]
[null,null,null,null,null,null,null,null,"durée amortissement:",5]
[null,null,null,null,null,null,null,null,"Prix du litre Carburant Diesel",0.9]
[null,null,null,null,null,null,null,null,"Prix du litre Carburant Essence",1.1000000000000001]
[]
[]
[null,null,"CHARGES FIXES",null,"CHARGES VARIABLES"]
["Véhicules","Immatriculation","AMORTISSEMENT","ASSURANCE","CARBURANT","ENTRETIEN","TOTAL"]
["AS440","AE-915-KP",{"$f":"VLOOKUP(B10,Tableau2[[Numéro Immatriculation]:[Prix d''acquisition]],2,FALSE)/$J$3","v":16000},1500,null,1000,{"$f":"SUM(C10:F10)","v":18500}]
["AS490","FS-452-ML",{"$f":"VLOOKUP(B11,Tableau2[[Numéro Immatriculation]:[Prix d''acquisition]],2,FALSE)/$J$3","v":17000},1500,null,null,{"$f":"SUM(C11:F11)","v":18500}]
["AS710","BD-471-ZY",{"$f":"VLOOKUP(B12,Tableau2[[Numéro Immatriculation]:[Prix d''acquisition]],2,FALSE)/$J$3","v":16600},1500,null,null,18100]
["GK290","AP-217-DX",{"$f":"VLOOKUP(B13,Tableau2[[Numéro Immatriculation]:[Prix d''acquisition]],2,FALSE)/$J$3","v":24000},1500,null,560,26060]
["GK140","DX-452-MP",{"$f":"VLOOKUP(B14,Tableau2[[Numéro Immatriculation]:[Prix d''acquisition]],2,FALSE)/$J$3","v":22000},1500,null,null,23500]
["R4192","DR-784-YU",{"$f":"VLOOKUP(B15,Tableau2[[Numéro Immatriculation]:[Prix d''acquisition]],2,FALSE)/$J$3","v":4000},1100,null,null,5100]
["TRAFIC","CD-415-PM",{"$f":"VLOOKUP(B16,Tableau2[[Numéro Immatriculation]:[Prix d''acquisition]],2,FALSE)/$J$3","v":3000},900,null,null,3900,null,null," "]
["TOURISMO KRH","AC-557-RT",{"$f":"VLOOKUP(B17,Tableau2[[Numéro Immatriculation]:[Prix d''acquisition]],2,FALSE)/$J$3","v":30000},1700,null,2300,34000]
["TRAVEGO","MP-876-OI",{"$f":"VLOOKUP(B18,Tableau2[[Numéro Immatriculation]:[Prix d''acquisition]],2,FALSE)/$J$3","v":36000},1700,null,null,37700]
["TOURISMO","PL-128-KL",{"$f":"VLOOKUP(B19,Tableau2[[Numéro Immatriculation]:[Prix d''acquisition]],2,FALSE)/$J$3","v":39000},1700,null,840,41540]
["TOURISMO","KY-569-LM",{"$f":"VLOOKUP(B20,Tableau2[[Numéro Immatriculation]:[Prix d''acquisition]],2,FALSE)/$J$3","v":32800},1700,null,null,34500]
["TRAVEGO","GH-421-TR",{"$f":"VLOOKUP(B21,Tableau2[[Numéro Immatriculation]:[Prix d''acquisition]],2,FALSE)/$J$3","v":31040},1700,null,null,32740]
[null,"TOTAL",{"$f":"SUM(C10:C21)","v":271440},{"$f":"SUM(D10:D21)","v":18000},{"$f":"SUM(E10:E21)","v":0},4700]

{"sheet":"Résultat","index":8,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[[9,1,9,2],[10,1,10,2],[11,1,12,3],[2,5,3,6],[2,1,3,3],[4,1,4,2],[5,1,5,2],[6,1,6,2],[7,1,7,2],[8,1,8,2]]}
[]
[]
[null,"Frais fixe",null,null,null,"Résultats en cours"]
[]
[null,"Electricité et eau",null,null,null,"Ventes :"]
[null,"Loyer",null,null,null,"Achats :"]
[null,"Frais bancaire",null,null,null,"Résultat :"]
[null,"Entretien",null,null,null,"Personnel :"]
[null,"Marketing",null,null,null,"Transport :"]
[null,"Poste et télécom",null,null,null,"Fraix Fixe :"]
[null,"Total : ",null,0,null,"Charges Personnels :"]
[null,"Charges de Personnel",null,null,null,"Résultat avant IS :"]
[null,null,null,null,null,"IS :"]
[null,"Salaire","Charges sociales","Total ",null,"Résultat après IS :"]
[null,0,0,0]

{"sheet":"Parc de bus","index":9,"n_rows":13,"n_cols":16,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Marque","Modèle","Numéro Immatriculation","Prix d'acquisition","Année","Kilométrage origine","Km parcourus","Carburant","Consommation L/100","Facturation au KM","Prix de la location",null,null,"Carburant","Marque","Modèle"]
["IVECO","AS440","AE-915-KP",80000,2014,250000,null,"DIESEL",20,10,{"$f":"Tableau2[[#This Row],[Facturation au KM]]*30","v":300},null,null,"DIESEL","IVECO","AS440"]
["IVECO","AS490","FS-452-ML",85000,2015,102000,null,"ESSENCE",20,12,{"$f":"Tableau2[[#This Row],[Facturation au KM]]*30","v":360},null,null,"ESSENCE","MAN","AS490"]
["IVECO","AS710","BD-471-ZY",83000,2015,99000,null,"ESSENCE",22,11,{"$f":"Tableau2[[#This Row],[Facturation au KM]]*30","v":330},null,null,null,"RENAULT","AS710"]
["MAN","GK290","AP-217-DX",120000,2013,335000,null,"DIESEL",24,18,{"$f":"Tableau2[[#This Row],[Facturation au KM]]*30","v":540},null,null,null,"MERCEDES","GK290"]
["MAN","GK140","DX-452-MP",110000,2014,325000,null,"DIESEL",23,16,{"$f":"Tableau2[[#This Row],[Facturation au KM]]*30","v":480},null,null,null,null,"GK140"]
["RENAULT","R4192","DR-784-YU",20000,2013,300000,null,"DIESEL",15,8,{"$f":"Tableau2[[#This Row],[Facturation au KM]]*30","v":240},null,null,null,null,"R4192"]
["RENAULT","TRAFIC","CD-415-PM",15000,2014,260000,null,"ESSENCE",13,7,{"$f":"Tableau2[[#This Row],[Facturation au KM]]*30","v":210},null,null,null,null,"TRAFIC"]
["MERCEDES","TOURISMO KRH","AC-557-RT",150000,2015,50000,null,"DIESEL",30,22,{"$f":"Tableau2[[#This Row],[Facturation au KM]]*30","v":660},null,null,null,null,"TOURISMO KRH"]
["MERCEDES","TRAVEGO","MP-876-OI",180000,2016,0,null,"ESSENCE",35,25,{"$f":"Tableau2[[#This Row],[Facturation au KM]]*30","v":750},null,null,null,null,"TRAVEGO"]
["MERCEDES","TOURISMO","PL-128-KL",195000,2016,0,null,"DIESEL",33,23,{"$f":"Tableau2[[#This Row],[Facturation au KM]]*30","v":690},null,null,null,null,"TOURISMO"]
["MERCEDES","TOURISMO","KY-569-LM",164000,2015,80000,null,"ESSENCE",31,23,{"$f":"Tableau2[[#This Row],[Facturation au KM]]*30","v":690}]
["MERCEDES","TRAVEGO","GH-421-TR",155200,2015,70000,null,"DIESEL",41,25,{"$f":"Tableau2[[#This Row],[Facturation au KM]]*30","v":750}]