{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["BP corrigé par JSC 1er oct17"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":"BP corrigé par JSC 1er oct17","index":0,"n_rows":82,"n_cols":70,"rows_kept":82,"cut":false,"hidden":false,"merged":[[2,68,2,69],[1,0,1,2],[1,3,1,9],[1,32,1,33],[1,37,1,38],[2,20,2,21],[2,22,2,23],[2,42,2,43],[2,47,2,48],[2,53,2,54],[2,58,2,59],[2,63,2,64],[4,61,4,63],[4,66,4,68],[3,0,4,1],[3,13,3,14],[3,15,3,17],[3,25,3,27],[3,30,3,32],[4,35,4,37],[4,40,4,42],[4,45,4,47],[4,51,4,53],[4,56,4,58],[7,13,7,14],[7,15,7,17],[7,25,7,27],[7,30,7,32],[8,61,8,63],[8,66,8,68],[12,13,12,14],[12,25,12,27],[12,30,12,32],[11,13,11,15],[11,16,11,17],[8,40,8,42],[8,45,8,47],[8,35,8,37],[8,51,8,53],[8,56,8,58],[13,13,13,14],[13,40,13,42],[31,25,31,27],[31,30,31,32],[13,61,13,63],[16,13,16,15],[18,25,18,27],[19,25,19,27],[19,30,19,32],[20,35,20,37],[20,40,20,42],[20,45,20,47],[20,51,20,53],[20,56,20,58],[13,51,13,53],[20,61,20,63],[20,66,20,68],[24,13,24,14],[24,15,24,17],[28,15,28,16],[45,17,45,19],[42,15,42,16],[32,35,32,37],[32,40,32,42],[32,45,32,47],[32,51,32,53],[32,66,32,68],[38,15,38,16],[39,15,39,16],[40,15,40,16],[41,15,41,16],[32,56,32,58],[32,61,32,63],[57,14,59,15],[61,14,61,15],[62,14,64,15],[43,15,43,16],[45,14,45,16],[49,14,49,15],[50,14,52,15],[56,14,56,15]]}
[{"$f":"+REPT(\"-\",300)","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"}]
["BUSINESS PLAN KHEPRISANTE ",null,null,"Année fiscale : 1 Septembre-31 Aout - le 1er oct.2017",null,null,null,null,null,null,null,null,null,null,"Prévisionnel","Prévisionnel","CA Realisé","CA Realisé",null,null,null,null,null,null,null,null,null,null,null,null,null,"Khepri santé 1","Centre Nogent ",null,null,null,"Khepri santé 2","Seconde centre "]
[{"$f":"A1","v":"------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Résultat K€",null,null,null,null,null,null,"Heure réalisée",null,"CA Réalisé","Résultat K€",null,null,null,null,"Résultat K€",null,null,null,null,null,null,null,"Khepri santé 1","Centre Nogent ",null,null,null,"Khepri santé 1","Seconde centre ",null,null,null,null,"Khepri santé 1","Centre Nogent ",null,null,null,"Khepri santé 1","Second Centre  ",null,null,null,"Khepri santé 1","Centre Nogent ",null,null,null,"Khepri santé 1","Second Centre  "]
["CPTES EXPLOITATION",null,null,"2015/2016",null,"2016/2017","2017/2018","2018/2019","2019/2020","2020/2021",null,null,null,"MAD intervenant fixe salle 2",null,"2015/2016",null,null,null,null,"tx d'occupation plein",null,null,null,null,"2016/2017 FIXE salle 1",null,null,null,null,"2017/2018  FIXE salle 1",null,null,null,null,null,null,null,"Résultat K€",null,null,null,null,"Résultat K€",null,null,null,null,"Résultat K€",null,null,null,null,null,"Résultat K€",null,null,null,null,"Résultat K€",null,null,null,null,"Résultat K€",null,null,null,null,"Résultat K€"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"salles","total h/mois à 100%","nbre h/Annuel","taux réel","vendu",null,null,"prix horaire",null,null,null,null,"nbre h/An","taux réel","vendu",null,null,"nbre h/An","taux réel","vendu",null,null,"2017/2018  FIXE salle 1",null,null,null,null,"2018/2019  FIXE salle 1",null,null,null,null,"2018/2019  FIXE salle 1",null,null,null,null,null,"2019/2020  FIXE salle 1",null,null,null,null,"2019/2020  FIXE salle 1",null,null,null,null,"2020/2021  FIXE salle 1",null,null,null,null,"2020/2021  FIXE salle 1"]
["MAD salle /forfait centre 1 Nogent",0.75,null,{"$f":"+R27","v":8.1999999999999993},null,35.402999999999999,{"$f":"F6*(1+$B$6)","v":61.955249999999999},{"$f":"G6*(1+$B$6)","v":108.4216875},189.73795312500002,332.04141796875001,null,null,null,2,{"$f":"240","v":240},{"$f":"+$O$6*12","v":2880},1,{"$f":"Q6*P6","v":2880},2.8,null,"CA prévisionnel ",null,null,null,null,{"$f":"+P11","v":1344},{"$f":"+AB6/X10","v":{"$error":"#DIV/0!"}},{"$f":"(1059*12)/1.2","v":10590},10.59,null,{"$f":"+Z6","v":1344},{"$f":"+$AG6/AB6","v":1.2},{"$f":"1059*12","v":12708},12.7,null,"nbre h/An","taux réel","vendu",null,null,"nbre h/An","taux réel","vendu",null,null,"nbre h/An","taux réel","vendu",null,null,null,"nbre h/An","taux réel","vendu",null,null,"nbre h/An","taux réel","vendu",null,null,"nbre h/An","taux réel","vendu",null,null,"nbre h/An","taux réel","vendu"]
["MAD salle /forfait Centre 2",null,null,null,null,null,{"$f":"F7*(1+$B$6)","v":0},0,0,0,null,null,null,2,200,{"$f":"+O7*12","v":2400},0,{"$f":"+Q7*P7","v":0},0,null,"Montant/mois",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+Z6","v":1344},{"$f":"+AA6","v":{"$error":"#DIV/0!"}},10590,12.7,null,{"$f":"+AJ7","v":1344},{"$f":"+AQ7/AL7","v":1.2},{"$f":"1059*12","v":12708},12.7,null,{"$f":"+AO7","v":1344},{"$f":"+AV7/AQ7","v":1},{"$f":"1059*12","v":12708},12.7,null,null,{"$f":"+AT7","v":1344},{"$f":"+AU7","v":1},{"$f":"1059*12","v":12708},12.7,null,{"$f":"+AZ7","v":1344},{"$f":"+BG7/BB7","v":1},{"$f":"1059*12","v":12708},12.7,null,{"$f":"+BE7","v":1344},{"$f":"+BL7/BG7","v":1},{"$f":"1059*12","v":12708},12.7,null,{"$f":"+BJ7","v":1344},{"$f":"+BQ7/BL7","v":1},{"$f":"1059*12","v":12708},12.7]
[" Abonnement Centre 1 Nogent",0.5,null,{"$f":"+R14","v":0},null,20.09,{"$f":"F8*(1+$B$8)","v":30.134999999999998},{"$f":"G8*(1+$B$8)","v":45.202500000000001},{"$f":"H8*(0.8+$B$8)","v":58.763249999999999},{"$f":"I8*(0.5+$B$8)","v":58.763249999999999},null,null,null,"MAD intervenant fixe salle 1",null,"2015/2016",null,null,null,null,"tx d'occupation plein",null,null,null,null,"2016/2017 FIXE salle 2",null,null,null,null,"2017/2018 FIXE salle 2"]
[" Abonnement Centre 2",null,null,null,null,null,0,0,0,0,null,null,null,"salles","total h/mois à 100%","nbre h/Annuel","taux réel"," A vendre",null,null,"prix horaire",null,null,null,null,"nbre h/An","taux réel","vendu",null,null,"nbre h/An","taux réel","vendu",null,null,"2017/2018 FIXE salle 2",null,null,null,null,"2018/2019 FIXE salle 2",null,null,null,null,"2018/2019 FIXE salle 2",null,null,null,null,null,"2019/2020 FIXE salle 2",null,null,null,null,"2019/2020 FIXE salle 2",null,null,null,null,"2020/2021 FIXE salle 2",null,null,null,null,"2020/2021 FIXE salle 2"]
[" CA intervenants  fixe Centre 1 Nogent",0.02,null,{"$f":"+S7+S11","v":5.2},null,15.917999999999999,36.576000000000001,{"$f":"G10*(1+$B$10)","v":37.307520000000004},38.053670400000001,38.814743808000003,null,null,null,1,152,{"$f":"+$O$6*12","v":2880},1,{"$f":"Q10*P10","v":2880},null,null,"CA prévisionnel ",null,null,null,null,{"$f":"+P7","v":2400},{"$f":"+AB10/X6","v":{"$error":"#DIV/0!"}},{"$f":"(800*12)/1.2","v":8000},8,null,{"$f":"+Z10","v":2400},{"$f":"+AG10/AB10","v":1.2},{"$f":"800*12","v":9600},9.6,null,"nbre h/An","taux réel","vendu",null,null,"nbre h/An","taux réel","vendu",null,null,"nbre h/An","taux réel","vendu",null,null,null,"nbre h/An","taux réel","vendu",null,null,"nbre h/An","taux réel","vendu",null,null,"nbre h/An","taux réel","vendu",null,null,"nbre h/An","taux réel","vendu"]
[" CA intervenants  fixe Centre 2 ",null,null,null,null,null,0,0,0,0,null,null,null,1,112,{"$f":"+O11*12","v":1344},1,{"$f":"+(X9*P11)/Q11","v":0},5.2,null,"Montant/mois",null,null,null,null,"Cumul",null,null,{"$f":"+AC6+AC10","v":18.59},null,null,null,null,null,null,{"$f":"+Z10","v":2400},{"$f":"+AA10","v":{"$error":"#DIV/0!"}},8000,9.6,null,{"$f":"+AJ11","v":2400},{"$f":"+AQ11/AL11","v":1.2},{"$f":"800*12","v":9600},9.6,null,{"$f":"+AO11","v":2400},{"$f":"+AV11/AQ11","v":1},{"$f":"800*12","v":9600},9.6,null,null,{"$f":"+AT11","v":2400},{"$f":"+AU11","v":1},{"$f":"800*12","v":9600},9.6,null,{"$f":"+AZ11","v":2400},{"$f":"+BG11/BB11","v":1},{"$f":"800*12","v":9600},9.6,null,{"$f":"+BE11","v":2400},{"$f":"+BL11/BG11","v":1},{"$f":"800*12","v":9600},9.6,null,{"$f":"+BJ11","v":2400},{"$f":"+BQ11/BL11","v":1},{"$f":"800*12","v":9600},9.6]
["CA Patients dirigeante",0.5,null,{"$f":"+U48","v":7.5},null,11.554,{"$f":"F12*(1+$B$12)","v":17.331},{"$f":"G12*(1+$B$12)","v":25.996499999999997},38.994749999999996,{"$f":"I12*(0.5+$B$12)","v":38.994749999999996},null,null,null,"Adhésion au centre ",null,null,"2015/2016"]
["PROGRESSION CA",null,null,null,null,{"$f":"+F14/D14-1","v":2.2862200956937802},{"$f":"G14/F14-1","v":1.1256988730671789},{"$f":"H14/G14-1","v":0.48583762707859246},0.50072518127915666,0.43945539454989913,null,null,null,"nbre souhaité",null,"prix /annuel","taux réel","CA vendu",null,null,null,null,null,null,null,"2015/2016 EVELYNE",null,null,null,null,"2017/2018 EVELYNE"]
["Total CA",null,null,{"$f":"D6+D8+D10+D12","v":20.9},null,68.682000000000002,{"$f":"+G6+G8+G10+G12","v":145.99724999999998},{"$f":"+H6+H7+H8+H9+H10+H11+H12","v":216.92820750000001},{"$f":"+I6+I7+I8+I9+I10+I11+I12","v":325.54962352500002},{"$f":"+J6+J7+J8+J9+J10+J11+J12","v":468.61416177675},null,null,null,170,null,{"$f":"+($N$14*41.58)*12","v":84823.2},0,{"$f":"+Q14*P14","v":0},null,null,null,null,null,null,null,"prix/Annuel","Taux réel","vendu",null,null,"prix/Annuel","Taux réel","vendu",null,null,null,null,null,null,null,"2018/2019 EVELYNE",null,null,null,null,null,null,null,null,null,null,"2019/2020 EVELYNE",null,null,null,null,null,null,null,null,null,"2020/2021 EVELYNE"]
["Location + charges Locatives",0.02,null,52.9,null,33.332000000000001,{"$f":"F15*(1+$B$15)","v":33.998640000000002},{"$f":"G15*(1+$B$15)","v":34.678612800000003},35.372185056000006,36.079628757120005]
["Sous traitance honoraire*",0.02,null,11.14,null,3.74,{"$f":"F16*(1+$B$16)","v":3.8148000000000004},25,35,55,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+$P$48*$Q$48","v":34650},{"$f":"+AB16/Z16","v":0.30014430014430016},10400,10.4,null,{"$f":"+$P$48*$Q$48","v":34650},{"$f":"+AG16/AE16","v":1.184935064935065},41058,41.58,null,null,null,null,null,null,"prix/Annuel","Taux réel","vendu",null,null,null,null,null,null,null,null,"prix/Annuel","Taux réel","vendu",null,null,null,null,null,null,null,"prix/Annuel","Taux réel","vendu"]
["Informaticien sous traitance Maintenance ",0.02,null,0.9,null,0,{"$f":"F17*(1+$B$17)","v":0},{"$f":"G17*(1+$B$17)","v":0},0,0,null,null,null,"Commissions de portage salarial",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+$P$48*$Q$48","v":34650},{"$f":"+AQ17/AO17","v":1.184935064935065},41058,41.58,null,null,null,null,null,null,null,{"$f":"+$P$48*$Q$48","v":34650},{"$f":"+BB17/AZ17","v":1.184935064935065},41058,41.58,null,null,null,null,null,null,{"$f":"+$P$48*$Q$48","v":34650},{"$f":"+BL17/BJ17","v":1.184935064935065},41058,41.58]
["Comptabilité ",0.02,null,3,null,4.43,{"$f":"F18*(1+$B$18)","v":4.5186000000000002},{"$f":"G18*(1+$B$18)","v":4.6089720000000005},{"$f":"H18*(1+$B$18)","v":4.7011514400000003},{"$f":"I18*(1+$B$18)","v":4.7951744688},null,null,null,"taux","salaires","com"]
["salarié CDD, charges, Stagiaires",0.02,null,13.1,null,32.298999999999999,30,30,40,41,null,null,null,0.05,400000,{"$f":"O19*N19","v":20000},null,null,null,null,null,null,null,null,null,"Adhésion mensuelle 41,58€ HT "]
["Rému chargée Dirigeant",0.02,null,null,null,null,25,40,{"$f":"H20*(1+$B$20)","v":40.799999999999997},41.616,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016/2017 ADHESION",null,null,null,null,"2017/2018 ADHESION"]
["AACE*",0.02,null,11,null,11.4,{"$f":"F21*(0.8+$B$21)","v":9.3480000000000008},{"$f":"G21*(0.8+$B$21)","v":7.6653600000000015},6.2855952000000013,5.1541880640000013,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"prix /annuel","taux réel","CA vendu",null,null,"prix /annuel","taux réel","CA vendu",null,null,"2017/2018 ADHESION",null,null,null,null,"2018/2019 ADHESION",null,null,null,null,"2018/2019 ADHESION",null,null,null,null,null,"2019/2020 ADHESION",null,null,null,null,"2019/2020 ADHESION",null,null,null,null,"2020/2021 ADHESION",null,null,null,null,"2020/2021 ADHESION"]
["Marketing pub et publications*",0.02,null,13,null,5.7329999999999997,{"$f":"F22*(3+$B$22)","v":17.313659999999999},{"$f":"G22*(1+$B$22)","v":17.659933199999998},{"$f":"H22*(1+$B$22)","v":18.013131863999998},{"$f":"I22*(1+$B$22)","v":18.37339450128},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,84830,{"$f":"+AB22/Z22","v":0.14980549333962043},12708,12.97,null,{"$f":"+($N$14*49.9)*12","v":101796},{"$f":"+AG22/AE22","v":0.69772879091516371},71026,71.260000000000005,null,"prix /annuel","taux réel","CA vendu",null,null,"prix /annuel","taux réel","CA vendu",null,null,"prix /annuel","taux réel","CA vendu",null,null,null,"prix /annuel","taux réel","CA vendu",null,null,"prix /annuel","taux réel","CA vendu",null,null,"prix /annuel","taux réel","CA vendu",null,null,"prix /annuel","taux réel","CA vendu"]
["Assurance et commissions",0.02,null,1.1000000000000001,null,1.2,{"$f":"F23*(1+$B$23)","v":1.224},{"$f":"G23*(1+$B$23)","v":1.24848},1.2734496,1.2989185919999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+($N$14*49.9)*12","v":101796},{"$f":"+AL23/AJ23","v":0.39365004518841606},40072,40.72,null,{"$f":"+($N$14*49.9)*12","v":101796},{"$f":"+AQ23/AO23","v":0.99296632480647573},101080,101.8,null,{"$f":"+($N$14*49.9)*12","v":101796},{"$f":"+AV23/AT23","v":0.69772879091516371},71026,71.260000000000005,null,null,{"$f":"+($N$14*49.9)*12","v":101796},{"$f":"+BB23/AZ23","v":1.8867047821132461},192059,192.59,null,{"$f":"+($N$14*49.9)*12","v":101796},{"$f":"+BG23/BE23","v":0.99296632480647573},101080,101.8,null,{"$f":"+($N$14*49.9)*12","v":101796},{"$f":"+BL23/BJ23","v":1.8867047821132461},192059,192.59,null,{"$f":"+($N$14*49.9)*12","v":101796},{"$f":"+BQ23/BO23","v":0.88490706904004091},90080,90.8]
["community manager",1.2E-2,10,null,null,null,{"$f":"C24*(1+$B$24)","v":10.120000000000001},{"$f":"G24*(1+$B$24)","v":10.241440000000001},{"$f":"H24*(1+$B$24)","v":10.364337280000001},{"$f":"I24*(1+$B$24)","v":10.488709327360001}]
["charges divers de gestion courante",0.02,null,0.5,null,{"$f":"D25*(1+$B$25)","v":0.51},{"$f":"E25*(1+$B$25)","v":0},0.5202,0,0.53060399999999996,null,null,null,"MAD forfait",null,"2015/2016",null,null,null,null,null,null,null,null,null,"tx d'occupation ",{"$f":"+AA26/P27","v":0.3147622053872054},"21% réel moyen",null,null,"tx d'occupation ",{"$f":"+AF26/P27","v":0.65561868686868685}]
["Entretien des locaux",0.02,3,null,null,1.365,{"$f":"C26*(1+$B$26)","v":3.06},{"$f":"G26*(1+$B$26)","v":3.1212},{"$f":"H26*(1+$B$26)","v":3.183624},{"$f":"I26*(1+$B$26)","v":3.2472964800000002},null,null,null,"salles","total h/mois","nbre h/An à 100%","taux reel","vendu",null,null,null,null,null,null,null,"nombre hr Annuel",5983,null,null,null,"nombre hr Annuel",12462,null,null,null,"tx d'occupation ",{"$f":"AA25","v":0.3147622053872054},null,null,null,"tx d'occupation ",{"$f":"+AP27/P27","v":0.83080808080808077},null,null,null,"tx d'occupation ",{"$f":"+AU27/P27","v":0.65561868686868685},null,null,null,null,"tx d'occupation ",{"$f":"+BA27/$P$27","v":1.1783459595959596},null,null,null,"tx d'occupation ",{"$f":"+BF27/P27","v":0.83080808080808077},null,null,null,"tx d'occupation ",{"$f":"+BK27/$P$27","v":1.0731271043771045},null,null,null,"tx d'occupation ",{"$f":"+BP27/P27","v":0.83080808080808077}]
["Diverses surprises*",0.02,null,null,null,null,10,10,20,30,null,null,null,8,{"$f":"+($N$27*9*6)*4","v":1728},{"$f":"+$O$27*11","v":19008},{"$f":"+R27/P27","v":4.3139730639730637E-4},8.1999999999999993,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"nombre hr Annuel",5983,null,null,null,"nombre hr Annuel",15792,null,null,null,"nombre hr Annuel",12462,null,null,null,null,"nombre hr Annuel",22398,null,null,null,"nombre hr Annuel",15792,null,null,null,"nombre hr Annuel",20398,null,null,null,"nombre hr Annuel",15792]
["Amort. Incorpo",5,null,null,null,0,{"$f":"F61/$B$28","v":0.55999999999999994},{"$f":"G61/$B$28","v":10.447999999999999},{"$f":"H61/$B$28","v":8.3583999999999996},{"$f":"I61/$B$28","v":6.6867199999999993}]
["Amort. corpo",5,null,5.4,null,4.4290000000000003,2,0.4,null,null,null,null,null,null,null,"Centre 1 Nogent "]
["Dotation aux amortissements ",{"$f":"+SUM(D15:D31)","v":123.03999999999999}]
["Impôt et versements assimilés",null,null,11,null,12.925000000000001,2.754,2.754,2.754,2.754,null,null,null,null,null,"tx d'occupation plein",1]
["REX",null,null,{"$f":"+D14-SUM(D15:D31)","v":-102.13999999999999},null,{"$f":"+F14-SUM(F15:F30)","v":-29.756000000000014},{"$f":"+G14-SUM(G15:G30)","v":-4.9604500000000371},21.336009500000046,102.19774908500003,214.34352758618999,null,{"$f":"SUM(D15:D31)","v":123.03999999999999},{"$f":"SUM(F15:F31)","v":111.36300000000001},null,null,"prix horaire",15,null,null,null,null,null,null,null,null,"2016/2017 Forfait",null,null,null,null,"2017/2018 Forfait"]
["REX%CA",null,null,{"$f":"D32/D14","v":-4.8870813397129185},null,-0.43324306222882286,-3.3976324896530845E-2,9.8355164346250565E-2,0.31392372068632396,0.45739874094608407,null,null,null,null,null,"CA prévisionnel ",{"$f":"+(Q32*P27)*Q31","v":285120},null,null,null,null,null,null,null,null,"nbre h/An","taux reel","vendu",null,null,"nbre h/An","taux reel","vendu",null,null,"2017/2018 Forfait",null,null,null,null,"2018/2019 Forfait",null,null,null,null,"2018/2019 Forfait",null,null,null,null,null,"2019/2020 Forfait",null,null,null,null,"2019/2020 Forfait",null,null,null,null,"2020/2021 Forfait",null,null,null,null,"2020/2021 Forfait"]
["Except subvention",null,null,null,null,1.5,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+$O$27*11","v":19008},{"$f":"+AB34/Q33","v":0.15979938271604938},45562,45.561999999999998,null,{"$f":"+$O$27*11","v":19008},{"$f":"+AG34/Q33","v":0.19992283950617284},57002,57.02,null,"nbre h/An","taux reel","vendu",null,null,"nbre h/An","taux reel","vendu",null,null,"nbre h/An","taux reel","vendu",null,null,null,"nbre h/An","taux reel","vendu",null,null,"nbre h/An","taux reel","vendu",null,null,"nbre h/An","taux reel","vendu",null,null,"nbre h/An","taux reel","vendu"]
["Résultat financier",null,null,-0.3,null,{"$f":"-10-7","v":-17},{"$f":"-8.3-6","v":-14.3},{"$f":"-6-5.1","v":-11.1},{"$f":"-3.3-3.8","v":-7.1},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+$O$27*11","v":19008},{"$f":"+AL35/Q33","v":0.12630471380471381},36012,36.119999999999997,null,{"$f":"+$O$27*11","v":19008},{"$f":"+AQ35/Q33","v":0.53312991021324352},152006,152.06,null,{"$f":"+$O$27*11","v":19008},{"$f":"+AV35/Q33","v":0.19992283950617284},57002,57.02,null,null,{"$f":"+$O$27*11","v":19008},{"$f":"+BB35/Q33","v":0.53312991021324352},152006,152.06,null,{"$f":"+$O$27*11","v":19008},{"$f":"+BG35/Q33","v":0.53312991021324352},152006,152.06,null,{"$f":"+$O$27*11","v":19008},{"$f":"+BL35/Q33","v":0.53312991021324352},152006,152.06,null,{"$f":"+$O$27*11","v":19008},{"$f":"+BQ35/Q33","v":0.53312991021324352},152006,152.06]
["IS",0.25,null,0,null,0,0,0,{"$f":"-(I32+I34+I35)*$B$36","v":-23.774437271250008},{"$f":"-(J32+J34+J35)*$B$36","v":-53.585881896547498},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AB34+AB22+AB16+AB10+AB6","v":87260}]
["RN",null,null,{"$f":"D32+SUM(D34:D36)","v":-102.43999999999998},null,{"$f":"F32+SUM(F34:F36)","v":-45.256000000000014},-19.260450000000038,10.236009500000046,71.323311813750024,160.75764568964249,null,"Compte courant"]
[null,null,null,null,null,null,null,null,null,null,null,"Evelyne",149.4,null,null,null,null,null,null,null,null,null,null,null,null,"Synthèse du système de réservation:"]
["Cptes financement",null,null,"2015/2016",null,"2016/2017","2017/2018","2018/2019","2019/2020","2020/2021",null,"Autres",0,null,null,"8 salles ",null,null,null,null,null,null,null,null,null,"heures consommées",5263]
["MBA",null,null,{"$f":"+D37+D28+D29","v":-97.039999999999978},null,-40.827000000000012,-16.700450000000039,21.084009500000043,79.681711813750027,167.4443656896425,null,"total",{"$f":"+M38+M39","v":149.4},null,null,"8h/jours",null,null,null,null,null,null,null,null,null,"CA HT heures réservées",50130]
["Compte courant +/-",null,null,93.9,null,55.53,-99.4,-50,null,null,null,null,null,null,null,"6 jours/semaines",null,null,null,null,null,null,null,null,null,"Taux occupation","mini 21%","maxi 28%"]
["Capital +/-",null,null,10,null,null,200,null,null,null,null,"CAPITAL",null,null,null,"12 mois ",null,null,null,null,null,null,null,null,null,"Taux croissance",0.97]
["Dette fi +/-",62.7,null,52.6,null,{"$f":"-18.2","v":-18.2},{"$f":"-7.3-4","v":-11.3},-12,-11.1,null,null,"EVELYNE",10,null,null,"total 1728 h/mois"]
["BFR+/-",null,null,{"$f":"+D78","v":6.4},null,{"$f":"+F78","v":5.0774573059360701},{"$f":"+G78","v":2.3570647945205536},{"$f":"+H78","v":1.962851016438357},{"$f":"+I78","v":-2.5927057116986312},{"$f":"+J78","v":-7.24323378112667},null,"AUTRES",0,null,null,"soit 19008 h/An"]
["Immo incorpo",null,null,-2.8,null,null,-50,null,null,null,null,"total",{"$f":"+M43+M44","v":10}]
["Immo corpo",null,null,-44.3,null,null,0,null,null,null,null,null,null,null,"C.A Evelyne",null,null,"2015/2016"]
["Immo fi",null,null,-8,null,null,0,null,null,null,null,null,null,null,"Patients/Mois ","visite /annuelle","prix/f/an","prix/Annuel","Taux réel","vendu"]
["Autres actifs",null,null,-3.1,null,null,-5,null,null,null,null,null,null,null,15,{"$f":"+O48*3*11","v":495},70,{"$f":"+$P$48*$Q$48","v":34650},{"$f":"+T48/R48","v":0.21650793650793651},7502,7.5]
["Autres passifs"]
["Disponibilités",null,null,{"$f":"SUM(D40:D48)","v":7.6600000000000339},null,{"$f":"D50+SUM(F40:F48)","v":9.2404573059360935},{"$f":"F50+SUM(G40:G48)","v":29.197072100456598},-9.7560673831050018,56.2329387189464,216.43407062746223,null,null,null,null,"AACE*"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Décoration,Receptions,Poste,Internet, Telephone,Eau-Gaz,petits equipement,Fourn Admin"]
["BILANS",null,null,"2015/2016",null,"2016/2017","2017/2018","2018/2019","2019/2020","2020/2021"]
["Ca propres",null,null,{"$f":"C53+D37+D42","v":-92.439999999999984},null,{"$f":"D53+F37+F42","v":-137.696},{"$f":"F53+G37+G42","v":43.043549999999954},{"$f":"G53+H37+H42","v":53.279559499999998},{"$f":"H53+I37+I42","v":124.60287131375003},{"$f":"I53+J37+J42","v":285.36051700339249}]
["Compte courant",null,null,{"$f":"+C54+D41","v":93.9},null,{"$f":"+D54+F41","v":149.43},{"$f":"+F54+G41","v":50.03},{"$f":"+G54+H41","v":3.0000000000001137E-2},{"$f":"+H54+I41","v":3.0000000000001137E-2},{"$f":"+I54+J41","v":3.0000000000001137E-2}]
["Dette Financière",null,null,{"$f":"C43+D43","v":52.6},null,{"$f":"+D55+F43","v":34.400000000000006},{"$f":"+F55+G43","v":23.100000000000005},{"$f":"+G55+H43","v":11.100000000000005},{"$f":"+H55+I43","v":0},{"$f":"+I55+J43","v":0}]
["Dette fournisseurs",null,null,{"$f":"+D75","v":3},null,{"$f":"+F75","v":12.172931506849313},16.451053150684935,20.661869194520552,22.525836053917811,22.186506442283836]
["Socfisc",null,null,{"$f":"+D76","v":3.4},null,2.6915833333333334,4.583333333333333,5.833333333333333,6.7333333333333334,6.8846666666666669,null,null,null,null,"Marketing*"]
["Autres passifs",null,null,0,null,null,null,null,null,null,null,null,null,null,"L'eventail du savoir,NJ Press,Police Municipale,Marie de nogent,FFE,Call Pact…."]
["Total passif",null,null,{"$f":"+SUM(D53:D58)","v":60.460000000000022},null,{"$f":"+SUM(F53:F58)","v":60.998514840182658},{"$f":"+SUM(G53:G58)","v":137.20793648401823},90.904762027853877,153.89204070100115,314.46169011234292]
[]
["Immo incorpo",null,null,{"$f":"C61-D45-D28","v":2.8},null,{"$f":"D61-F45-F28","v":2.8},{"$f":"F61-G45-G28","v":52.239999999999995},41.791999999999994,33.433599999999998,26.746879999999997,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17.07,"7 300 €",645]
["Immo corpo",null,null,{"$f":"C62-D46-D29","v":38.9},null,{"$f":"D62-F46-F29","v":34.470999999999997},32.470999999999997,32.070999999999998,32.070999999999998,32.070999999999998,null,null,null,null,"Diverses surprises*",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17.079999999999998,"8 103 €",716]
["Immo Fi",null,null,{"$f":"C63-D47","v":8},null,{"$f":"D63-F47","v":8},{"$f":"F63-G47","v":8},{"$f":"G63-H47","v":8},{"$f":"H63-I47","v":8},{"$f":"I63-J47","v":8},null,null,null,null,"Frais d'actes et contentieux",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17.09,"8 994 €",795,795,"1 206"]
["Stocks",null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17.100000000000001,"9 984 €",882,882,"1 339"]
["Clients",null,null,0,null,{"$f":"+F74","v":3.3870575342465759},{"$f":"+G74","v":7.1998643835616418},{"$f":"+H74","v":10.697829410958905},{"$f":"+I74","v":16.054501982054795},{"$f":"+J74","v":23.109739484880823},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17.11,"11 082 €",979,979,"1 486"]
["Autres actifs",null,null,{"$f":"C66-D48","v":3.1},null,{"$f":"D66-F48","v":3.1},{"$f":"F66-G48","v":8.1},{"$f":"G66-H48","v":8.1},{"$f":"H66-I48","v":8.1},{"$f":"I66-J48","v":8.1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,17.12,"12 301 €","1 087","1 087","1 650"]
["Dispo",null,null,7.5,null,{"$f":"F50","v":9.2404573059360935},{"$f":"G50","v":29.197072100456598},{"$f":"H50","v":-9.7560673831050018},{"$f":"I50","v":56.2329387189464},{"$f":"J50","v":216.43407062746223},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18.010000000000002,"13 654 €","1 206","1 206","1 831"]
["total actif",null,null,{"$f":"SUM(D61:D67)","v":60.3},null,{"$f":"SUM(F61:F67)","v":60.998514840182665},137.20793648401823,90.904762027853891,153.89204070100118,314.46169011234304,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18.02,"15 156 €","1 339","1 339","2 033"]
["Check1",null,null,{"$f":"D68-D59","v":-0.16000000000002501},null,{"$f":"F68-F59","v":0},0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18.03,"16 823 €","1 486","1 486","2 256"]
["Check2",null,null,{"$f":"D67-D50","v":-0.16000000000003389},null,{"$f":"F67-F50","v":0},{"$f":"G67-G50","v":0},{"$f":"H67-H50","v":0},{"$f":"I67-I50","v":0},{"$f":"J67-J50","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18.04,"18 674 €","1 650","1 650","2 504"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18.05,"20 728 €","1 831","1 831","2 780"]
["BFR",null,null,"2015/2016",null,"2016/2017","2017/2018","2018/2019","2019/2020","2020/2021",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18.059999999999999,"23 008 €","2 033","2 033","3 086"]
["Stocks",null,null,{"$f":"D64","v":0},null,{"$f":"F64","v":0},{"$f":"G64","v":0},{"$f":"H64","v":0},{"$f":"I64","v":0},{"$f":"J64","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18.07,"25 539 €","2 256","2 256","3 425"]
["Clients",null,null,{"$f":"+D65","v":0},null,{"$f":"F14*(1+F82)/365*F80","v":3.3870575342465759},{"$f":"G14*(1+G82)/365*G80","v":7.1998643835616418},{"$f":"H14*(1+H82)/365*H80","v":10.697829410958905},{"$f":"I14*(1+I82)/365*I80","v":16.054501982054795},{"$f":"J14*(1+J82)/365*J80","v":23.109739484880823},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18.079999999999998,"28 348 €","2 504","2 504","3 802"]
["Fournisseurs",null,null,3,null,{"$f":"SUM(F15:F18,F21:F26)*(1+G82)/365*F81","v":12.172931506849313},{"$f":"SUM(G15:G18,G21:G26)*(1+H82)/365*G81","v":16.451053150684935},{"$f":"SUM(H15:H18,H21:H26)*(1+I82)/365*H81","v":20.661869194520552},{"$f":"SUM(I15:I18,I21:I26)*(1+J82)/365*I81","v":22.525836053917811},{"$f":"SUM(J15:J18,J21:J26)*(1+K79)/365*J81","v":22.186506442283836},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18.09,"31 466 €","2 780"]
["Socfisc",null,null,3.4,null,{"$f":"(F19+F20)/3/12*3","v":2.6915833333333334},{"$f":"(G19+G20)/3/12*3","v":4.583333333333333},{"$f":"(H19+H20)/3/12*3","v":5.833333333333333},{"$f":"(I19+I20)/3/12*3","v":6.7333333333333334},{"$f":"(J19+J20)/3/12*3","v":6.8846666666666669},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18.100000000000001,"34 927 €","3 086"]
["BFR",null,null,{"$f":"D73+D74-D75-D76","v":-6.4},null,{"$f":"F73+F74-F75-F76","v":-11.47745730593607},-13.834522100456624,-15.797373116894981,-13.20466740519635,-5.9614336240696799,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18.11,"38 769 €","3 425"]
["Delta BFR",null,null,{"$f":"C77-D77","v":6.4},null,{"$f":"D77-F77","v":5.0774573059360701},{"$f":"F77-G77","v":2.3570647945205536},1.962851016438357,-2.5927057116986312,-7.24323378112667,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18.12,"43 034 €","3 802"]
["jours stocks",null,null,"ns",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19.010000000000002,"47 768 €","4 220"]
["jours clients",null,null,"ns",null,15,15,15,15,15,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,19.02,"53 022 €","4 684"]
["jours fournisseurs",null,null,"ns",null,60,60,60,60,60]
["TVA",null,null,0.2,null,0.2,0.2,0.2,0.2,0.2]