{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Flux de trésorerie sur 12 mois","Résumé des flux de trésorerie"],"not_rendered":{"charts":1,"defined_names":12},"read":"whole","date_system":"1900"}

{"sheet":"Flux de trésorerie sur 12 mois","index":0,"n_rows":42,"n_cols":16,"rows_kept":42,"merged":[[7,0,7,15],[12,0,12,15],[18,0,18,15],[34,0,34,15]]}
[]
["Flux de trésorerie sur douze mois",{"$nulls":13},"Début exercice comptable :","2013-07-01"]
["Nom de la société"]
["Adresse, ville, état, code postal"]
["Téléphone, adresse de messagerie, adresse web"]
[]
[null,"Début",{"$f":"ExerciceComptable","v":"2013-07-01"},{"$f":"DATE(YEAR(C7),MONTH(C7)+1,1)","v":"2013-08-01"},{"$f":"DATE(YEAR(D7),MONTH(D7)+1,1)","v":"2013-09-01"},"2013-10-01","2013-11-01","2013-12-01","2014-01-01","2014-02-01","2014-03-01","2014-04-01","2014-05-01","2014-06-01","Moyenne mensuelle","Résumé"]
["Synthèse"]
[]
["Disponibilités\n(début du mois)",{"v":55000,"d":"55,000"},{"$f":"IF(Encaissements[[#Totals],[Colonne3]]+Décaissements[[#Totals],[Colonne3]]=0,\"\",B12)","v":{"v":67593,"d":"67,593"}},{"$f":"IF(Encaissements[[#Totals],[Colonne4]]+Décaissements[[#Totals],[Colonne4]]=0,\"\",C12)","v":{"v":54265,"d":"54,265"}},{"$f":"IF(Encaissements[[#Totals],[Colonne5]]+Décaissements[[#Totals],[Colonne5]]=0,\"\",D12)","v":{"v":55739,"d":"55,739"}},{"$f":"IF(Encaissements[[#Totals],[Colonne6]]+Décaissements[[#Totals],[Colonne6]]=0,\"\",E12)","v":{"v":69290,"d":"69,290"}},{"$f":"IF(Encaissements[[#Totals],[Colonne7]]+Décaissements[[#Totals],[Colonne7]]=0,\"\",F12)","v":{"v":65618,"d":"65,618"}},{"$f":"IF(Encaissements[[#Totals],[Colonne8]]+Décaissements[[#Totals],[Colonne8]]=0,\"\",G12)","v":""},{"$f":"IF(Encaissements[[#Totals],[Colonne9]]+Décaissements[[#Totals],[Colonne9]]=0,\"\",H12)","v":""},{"$f":"IF(Encaissements[[#Totals],[Colonne10]]+Décaissements[[#Totals],[Colonne10]]=0,\"\",I12)","v":""},{"$f":"IF(Encaissements[[#Totals],[Colonne11]]+Décaissements[[#Totals],[Colonne11]]=0,\"\",J12)","v":""},{"$f":"IF(Encaissements[[#Totals],[Colonne12]]+Décaissements[[#Totals],[Colonne12]]=0,\"\",K12)","v":""},{"$f":"IF(Encaissements[[#Totals],[Colonne13]]+Décaissements[[#Totals],[Colonne13]]=0,\"\",L12)","v":""},{"$f":"IF(Encaissements[[#Totals],[Colonne14]]+Décaissements[[#Totals],[Colonne14]]=0,\"\",M12)","v":""},{"$f":"IFERROR(AVERAGE(Synthèse[[#This Row],[Colonne3]:[Colonne14]]),\"\")","v":{"v":62501,"d":"62,501"}}]
["Trésorerie disponible\n(disponibilités + encaissements, avant décaissements) ",{"$f":"SUM(B10,Encaissements[[#Totals],[Colonne2]])","v":{"v":67593,"d":"67,593"}},{"$f":"IF(C10=\"\",\"\",SUM(C10,Encaissements[[#Totals],[Colonne3]]))","v":{"v":76065,"d":"76,065"}},{"$f":"IF(D10=\"\",\"\",SUM(D10,Encaissements[[#Totals],[Colonne4]]))","v":{"v":83301,"d":"83,301"}},{"$f":"IF(E10=\"\",\"\",SUM(E10,Encaissements[[#Totals],[Colonne5]]))","v":{"v":91032,"d":"91,032"}},{"$f":"IF(F10=\"\",\"\",SUM(F10,Encaissements[[#Totals],[Colonne6]]))","v":{"v":89662,"d":"89,662"}},{"$f":"IF(G10=\"\",\"\",SUM(G10,Encaissements[[#Totals],[Colonne7]]))","v":{"v":76200,"d":"76,200"}},{"$f":"IF(H10=\"\",\"\",SUM(H10,Encaissements[[#Totals],[Colonne8]]))","v":""},{"$f":"IF(I10=\"\",\"\",SUM(I10,Encaissements[[#Totals],[Colonne9]]))","v":""},{"$f":"IF(J10=\"\",\"\",SUM(J10,Encaissements[[#Totals],[Colonne10]]))","v":""},{"$f":"IF(K10=\"\",\"\",SUM(K10,Encaissements[[#Totals],[Colonne11]]))","v":""},{"$f":"IF(L10=\"\",\"\",SUM(L10,Encaissements[[#Totals],[Colonne12]]))","v":""},{"$f":"IF(M10=\"\",\"\",SUM(M10,Encaissements[[#Totals],[Colonne13]]))","v":""},{"$f":"IF(N10=\"\",\"\",SUM(N10,Encaissements[[#Totals],[Colonne14]]))","v":""},{"$f":"IFERROR(AVERAGE(Synthèse[[#This Row],[Colonne3]:[Colonne14]]),\"\")","v":{"v":83252,"d":"83,252"}}]
["Situation de trésorerie\n(fin du mois)",{"$f":"(B11-Décaissements[[#Totals],[Colonne2]])","v":{"v":67593,"d":"67,593"}},{"$f":"IFERROR(C11-Décaissements[[#Totals],[Colonne3]],\"\")","v":{"v":54265,"d":"54,265"}},{"$f":"IFERROR(D11-Décaissements[[#Totals],[Colonne4]],\"\")","v":{"v":55739,"d":"55,739"}},{"$f":"IFERROR(E11-Décaissements[[#Totals],[Colonne5]],\"\")","v":{"v":69290,"d":"69,290"}},{"$f":"IFERROR(F11-Décaissements[[#Totals],[Colonne6]],\"\")","v":{"v":65618,"d":"65,618"}},{"$f":"IFERROR(G11-Décaissements[[#Totals],[Colonne7]],\"\")","v":{"v":51413,"d":"51,413"}},{"$f":"IFERROR(H11-Décaissements[[#Totals],[Colonne8]],\"\")","v":""},{"$f":"IFERROR(I11-Décaissements[[#Totals],[Colonne9]],\"\")","v":""},{"$f":"IFERROR(J11-Décaissements[[#Totals],[Colonne10]],\"\")","v":""},{"$f":"IFERROR(K11-Décaissements[[#Totals],[Colonne11]],\"\")","v":""},{"$f":"IFERROR(L11-Décaissements[[#Totals],[Colonne12]],\"\")","v":""},{"$f":"IFERROR(M11-Décaissements[[#Totals],[Colonne13]],\"\")","v":""},{"$f":"IFERROR(N11-Décaissements[[#Totals],[Colonne14]],\"\")","v":""},{"$f":"IFERROR(AVERAGE(Synthèse[[#This Row],[Colonne3]:[Colonne14]]),\"\")","v":{"v":59265,"d":"59,265"}}]
[]
["Encaissements"]
["Ventes au comptant",{"v":5616,"d":"5,616"},{"v":3889,"d":"3,889"},{"v":24411,"d":"24,411"},{"v":31642,"d":"31,642"},{"v":14647,"d":"14,647"},{"v":3034,"d":"3,034"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(Encaissements[[#This Row],[Colonne3]:[Colonne14]]),\"\")","v":{"v":15524.6,"d":"15,525"}}]
["Ensemble des comptes créditeurs",{"v":4498,"d":"4,498"},{"v":3493,"d":"3,493"},{"v":1987,"d":"1,987"},{"v":1029,"d":"1,029"},{"v":2911,"d":"2,911"},{"v":4234,"d":"4,234"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(Encaissements[[#This Row],[Colonne3]:[Colonne14]]),\"\")","v":{"v":2730.8,"d":"2,731"}}]
["Prêt/autres apports de trésorerie",{"v":2479,"d":"2,479"},{"v":1090,"d":"1,090"},{"v":2638,"d":"2,638"},{"v":2622,"d":"2,622"},{"v":2814,"d":"2,814"},{"v":3314,"d":"3,314"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(Encaissements[[#This Row],[Colonne3]:[Colonne14]]),\"\")","v":{"v":2495.6,"d":"2,496"}}]
["Total des encaissements",{"$f":"SUBTOTAL(109,Encaissements[Colonne2])","v":{"v":12593,"d":"12,593"}},{"$f":"SUBTOTAL(109,Encaissements[Colonne3])","v":{"v":8472,"d":"8,472"}},{"$f":"SUBTOTAL(109,Encaissements[Colonne4])","v":{"v":29036,"d":"29,036"}},{"$f":"SUBTOTAL(109,Encaissements[Colonne5])","v":{"v":35293,"d":"35,293"}},{"$f":"SUBTOTAL(109,Encaissements[Colonne6])","v":{"v":20372,"d":"20,372"}},{"$f":"SUBTOTAL(109,Encaissements[Colonne7])","v":{"v":10582,"d":"10,582"}},{"$f":"SUBTOTAL(109,Encaissements[Colonne8])","v":0},{"$f":"SUBTOTAL(109,Encaissements[Colonne9])","v":0},{"$f":"SUBTOTAL(109,Encaissements[Colonne10])","v":0},{"$f":"SUBTOTAL(109,Encaissements[Colonne11])","v":0},{"$f":"SUBTOTAL(109,Encaissements[Colonne12])","v":0},{"$f":"SUBTOTAL(109,Encaissements[Colonne13])","v":0},{"$f":"SUBTOTAL(109,Encaissements[Colonne14])","v":0},{"$f":"IFERROR(AVERAGE(Encaissements[[#Totals],[Colonne3]:[Colonne14]]),\"\")","v":{"v":8646.25,"d":"8,646"}}]
[]
["Décaissements"]
["Achats (préciser)",null,521,323,274,451,104,{"$nulls":7},{"$f":"IFERROR(AVERAGE(Décaissements[[#This Row],[Colonne3]:[Colonne14]]),\"\")","v":{"v":334.6,"d":"335"}}]
["Salaires bruts (retrait exact)",null,{"v":10572,"d":"10,572"},{"v":14514,"d":"14,514"},{"v":10561,"d":"10,561"},{"v":13170,"d":"13,170"},{"v":12478,"d":"12,478"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(Décaissements[[#This Row],[Colonne3]:[Colonne14]]),\"\")","v":{"v":12259,"d":"12,259"}}]
["Fournitures",null,250,428,165,{"v":1168,"d":"1,168"},345,{"$nulls":7},{"$f":"IFERROR(AVERAGE(Décaissements[[#This Row],[Colonne3]:[Colonne14]]),\"\")","v":{"v":471.2,"d":"471"}}]
["Réparation et entretien",null,0,{"v":2200,"d":"2,200"},163,67,0,{"$nulls":7},{"$f":"IFERROR(AVERAGE(Décaissements[[#This Row],[Colonne3]:[Colonne14]]),\"\")","v":486}]
["Publicité",null,{"v":1100,"d":"1,100"},625,{"v":1356,"d":"1,356"},0,{"v":2560,"d":"2,560"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(Décaissements[[#This Row],[Colonne3]:[Colonne14]]),\"\")","v":{"v":1128.2,"d":"1,128"}}]
["Location",null,{"v":3500,"d":"3,500"},{"v":3500,"d":"3,500"},{"v":3500,"d":"3,500"},{"v":3500,"d":"3,500"},{"v":3500,"d":"3,500"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(Décaissements[[#This Row],[Colonne3]:[Colonne14]]),\"\")","v":{"v":3500,"d":"3,500"}}]
["Services",null,285,318,151,134,228,{"$nulls":7},{"$f":"IFERROR(AVERAGE(Décaissements[[#This Row],[Colonne3]:[Colonne14]]),\"\")","v":{"v":223.2,"d":"223"}}]
["Autre (préciser)",null,123,234,123,234,123,{"$nulls":7},{"$f":"IFERROR(AVERAGE(Décaissements[[#This Row],[Colonne3]:[Colonne14]]),\"\")","v":{"v":167.4,"d":"167"}}]
["Remboursement du capital d’un prêt",null,{"v":4000,"d":"4,000"},{"v":4000,"d":"4,000"},{"v":4000,"d":"4,000"},{"v":4000,"d":"4,000"},{"v":4000,"d":"4,000"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(Décaissements[[#This Row],[Colonne3]:[Colonne14]]),\"\")","v":{"v":4000,"d":"4,000"}}]
["Achat d’immobilisations (préciser)",null,679,700,679,650,679,{"$nulls":7},{"$f":"IFERROR(AVERAGE(Décaissements[[#This Row],[Colonne3]:[Colonne14]]),\"\")","v":{"v":677.4,"d":"677"}}]
["Autres frais de démarrage",null,400,350,400,300,400,{"$nulls":7},{"$f":"IFERROR(AVERAGE(Décaissements[[#This Row],[Colonne3]:[Colonne14]]),\"\")","v":370}]
["Compte sous séquestre",null,300,300,300,300,300,{"$nulls":7},{"$f":"IFERROR(AVERAGE(Décaissements[[#This Row],[Colonne3]:[Colonne14]]),\"\")","v":300}]
["Retrait du propriétaire",null,70,70,70,70,70,{"$nulls":7},{"$f":"IFERROR(AVERAGE(Décaissements[[#This Row],[Colonne3]:[Colonne14]]),\"\")","v":70}]
["Total des décaissements",null,{"$f":"SUBTOTAL(109,Décaissements[Colonne3])","v":{"v":21800,"d":"21,800"}},{"$f":"SUBTOTAL(109,Décaissements[Colonne4])","v":{"v":27562,"d":"27,562"}},{"$f":"SUBTOTAL(109,Décaissements[Colonne5])","v":{"v":21742,"d":"21,742"}},{"$f":"SUBTOTAL(109,Décaissements[Colonne6])","v":{"v":24044,"d":"24,044"}},{"$f":"SUBTOTAL(109,Décaissements[Colonne7])","v":{"v":24787,"d":"24,787"}},{"$f":"SUBTOTAL(109,Décaissements[Colonne8])","v":0},{"$f":"SUBTOTAL(109,Décaissements[Colonne9])","v":0},{"$f":"SUBTOTAL(109,Décaissements[Colonne10])","v":0},{"$f":"SUBTOTAL(109,Décaissements[Colonne11])","v":0},{"$f":"SUBTOTAL(109,Décaissements[Colonne12])","v":0},{"$f":"SUBTOTAL(109,Décaissements[Colonne13])","v":0},{"$f":"SUBTOTAL(109,Décaissements[Colonne14])","v":0},{"$f":"IFERROR(AVERAGE(Décaissements[[#Totals],[Colonne3]:[Colonne14]]),\"\")","v":{"v":9994.583333333334,"d":"9,995"}}]
[]
["Données d’exploitation essentielles (informations non liées aux flux de trésorerie)"]
["Volume de ventes (en dollars)",{"v":2000,"d":"2,000"},{"v":2500,"d":"2,500"},{"v":2257,"d":"2,257"},{"v":2387,"d":"2,387"},{"v":2664,"d":"2,664"},{"v":2324,"d":"2,324"},{"$nulls":7},{"$f":"IFERROR(AVERAGE(DonnéesExploitationEssentielles[[#This Row],[Colonne2]:[Colonne14]]),\"\")","v":{"v":2355.3333333333335,"d":"2,355"}}]
["Comptes clients",{"v":1500,"d":"1,500"},500,886,{"v":1035,"d":"1,035"},{"v":1775,"d":"1,775"},839,{"$nulls":7},{"$f":"IFERROR(AVERAGE(DonnéesExploitationEssentielles[[#This Row],[Colonne2]:[Colonne14]]),\"\")","v":{"v":1089.1666666666667,"d":"1,089"}}]
["Créance irrécouvrable (fin du mois)",300,200,225,269,448,359,{"$nulls":7},{"$f":"IFERROR(AVERAGE(DonnéesExploitationEssentielles[[#This Row],[Colonne2]:[Colonne14]]),\"\")","v":{"v":300.1666666666667,"d":"300"}}]
["Stock disponible (fin du mois)",{"$nulls":13},{"$f":"IFERROR(AVERAGE(DonnéesExploitationEssentielles[[#This Row],[Colonne2]:[Colonne14]]),\"\")","v":""}]
["Comptes fournisseurs (fin du mois)",{"$nulls":13},{"$f":"IFERROR(AVERAGE(DonnéesExploitationEssentielles[[#This Row],[Colonne2]:[Colonne14]]),\"\")","v":""}]
["Ammortissement",{"$nulls":13},{"$f":"IFERROR(AVERAGE(DonnéesExploitationEssentielles[[#This Row],[Colonne2]:[Colonne14]]),\"\")","v":""}]

{"sheet":"Résumé des flux de trésorerie","index":1,"n_rows":27,"n_cols":11,"rows_kept":27}
{"$rows_empty":25}
[{"$nulls":9},"Points de données :",5]
[null,null,"(Faites glisser le curseur ci-dessus pour modifier le nombre total de points de données à représenter.)"]