{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["H1(Synthèse de scénarios)","SEUIL RENTABILITE","H1(POINT MORT)","H2(SAISONNALITE)","H2(POINT MORT)","Evolution CA","AdressesActionnaires"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":23,"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":"H1(Synthèse de scénarios)","index":0,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Synthèse de scénarios"]
[null,null,null,"Valeurs actuelles :","Tx55%","TX70%","Tx95%"]
[null,null,null,null,"Créé par BTS le 16/01/2013","Créé par BTS le 16/01/2013","Créé par BTS le 16/01/2013"]
[null,"Cellules variables :"]
[null,null,"TxMoyenOccup",0.8,0.55000000000000004,0.7,0.95]
[null,"Cellules résultantes :"]
[null,null,"MCV",1504384,1034264,1316336,1786456]
[null,null,"TxMCV",0.7,0.7,0.7,0.7]
[null,null,"RtExpl",504384,34264,316336,786456]
[null,null,"SR€",1428571.42857143,1428571.42857143,1428571.42857143,1428571.42857143]
[null,null,"DateSeuilRentabilité","1900-08-29T14:58:52.919","1900-12-17T21:47:27.883","1900-10-03T06:50:09.051","1900-07-22T07:33:47.721"]
[null,"La colonne Valeurs actuelles affiche les valeurs des cellules variables"]
[null,"au moment de la création du rapport de synthèse. Les cellules variables"]
[null,"de chaque scénario se situent dans les colonnes grisées."]

{"sheet":"SEUIL RENTABILITE","index":1,"n_rows":48,"n_cols":5,"rows_kept":48,"cut":false,"hidden":false,"merged":[[3,1,3,3]]}
[]
[]
[]
[null,"La compagnie hôtelière II"]
[]
[]
["Valeur à saisir"]
["Nombre total de chambres",80]
["Taux moyen d'occupation",0.8,null,null,"Saisie"]
["Prix moyen de la chambre",92]
["Nombre de jours ouvrables",365,null,null,"Calcul"]
["Charges Variables",0.3]
[]
["Tableau de résultat par variabilité "]
[]
[null,null,null,"Marges","% "]
["Chiffre d'affaires",null,{"$f":"NBchambres*TxMoyenOccup*PxMoyenChambre*NbrJoursOuvrables","v":2149120}]
[]
["Charges variables",null,{"$f":"TauxCV*CA","v":644736}]
[]
[]
[]
["Marge sur coût variable",null,null,{"$f":"CA-CV","v":1504384},{"$f":"MCV/CA","v":0.7}]
[]
["Charges fixes"]
[null,"Charges fixes décaissables",800000]
[null,"Dotations aux amortissements",200000]
[]
[]
[]
[null,"Total",{"$f":"SUM(C26:C30)","v":1000000}]
["résutat d'exploitation",null,null,{"$f":"MCV-CF","v":504384},{"$f":"RtExpl/CA","v":0.23469326980345442}]
[]
[]
["Seuil de rentabilité"]
["En €uros",{"$f":"(CA*CF)/MCV","v":1428571.4285714286}]
["En Jours",{"$f":"(SR€/CA)*365","v":242.62422360248451}]
["Soit le",{"$f":"B37","v":"1900-08-29T14:58:52.919"}]
[]
["Marge de Sécurité"]
["Chiffre d'affaires",{"$f":"CA","v":2149120}]
["Seuil de Rentabilité",{"$f":"SR€","v":1428571.4285714286}]
["Marge de Sécurité",{"$f":"CA-SR€","v":720548.57142857136}]
["En Jours",{"$f":"ROUND(365-B38,0)","v":122}]
["En Mois",{"$f":"B44/30","v":4.0666666666666664}]
[]
["Indice de Sécurité"]
["Indice de sécurité",{"$f":"MS/CA","v":0.33527609971922057}]

{"sheet":"H1(POINT MORT)","index":2,"n_rows":13,"n_cols":12,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
["Exercice","Mois","1er J/M","Dernier J/M","Nbr J/M","Cumul","Tx Occup","CA en €","CV en €","MCV en €","CF En €","Résultat"]
[2017,1,{"$f":"DATE(ExEnCours,B2,1)","v":"2017-01-01"},{"$f":"EOMONTH(C2,0)","v":"2017-01-31"},{"$f":"D2-C2+1","v":31},{"$f":"SUM($E$2:E2)","v":31},{"$f":"TxMoyenOccup","v":0.8},{"$f":"NBchambres*TxMoyenOccup*PxMoyenChambre*F2","v":182528},{"$f":"H2*TauxCV","v":54758.400000000001},{"$f":"H2-I2","v":127769.60000000001},{"$f":"CF","v":1000000},{"$f":"J2-K2","v":-872230.40000000002}]
[null,2,"2017-02-01",{"$f":"EOMONTH(C3,0)","v":"2017-02-28"},{"$f":"D3-C3+1","v":28},{"$f":"SUM($E$2:E3)","v":59},0.8,347392,104217.59999999999,{"$f":"H3-I3","v":243174.40000000002},1000000,{"$f":"J3-K3","v":-756825.59999999998}]
[null,3,"2017-03-01","2017-03-31",31,{"$f":"SUM($E$2:E4)","v":90},0.8,{"$f":"NBchambres*TxMoyenOccup*PxMoyenChambre*F4","v":529920},158976,370944,1000000,-629056]
[null,4,"2017-04-01","2017-04-30",30,{"$f":"SUM($E$2:E5)","v":120},0.8,706560,211968,494592,1000000,-505408]
[null,5,"2017-05-01","2017-05-31",31,{"$f":"SUM($E$2:E6)","v":151},0.8,889088,266726.39999999997,622361.60000000009,1000000,-377638.39999999991]
[null,6,"2017-06-01","2017-06-30",30,{"$f":"SUM($E$2:E7)","v":181},0.8,1065728,{"$f":"H7*TauxCV","v":319718.39999999997},746009.60000000009,1000000,-253990.39999999991]
[null,7,"2017-07-01","2017-07-31",31,{"$f":"SUM($E$2:E8)","v":212},0.8,1248256,374476.79999999999,873779.19999999995,1000000,-126220.80000000005]
[null,8,"2017-08-01","2017-08-31",31,{"$f":"SUM($E$2:E9)","v":243},0.8,1430784,429235.20000000001,1001548.8,1000000,1548.8000000000466]
[null,9,"2017-09-01","2017-09-30",30,{"$f":"SUM($E$2:E10)","v":273},0.8,1607424,482227.19999999995,1125196.8,1000000,125196.80000000005]
[null,10,"2017-10-01","2017-10-31",31,{"$f":"SUM($E$2:E11)","v":304},0.8,1789952,536985.59999999998,1252966.3999999999,1000000,252966.39999999991]
[null,11,"2017-11-01","2017-11-30",30,{"$f":"SUM($E$2:E12)","v":334},0.8,1966592,589977.59999999998,1376614.3999999999,1000000,376614.39999999991]
[null,12,"2017-12-01","2017-12-31",31,{"$f":"SUM($E$2:E13)","v":365},0.8,2149120,644736,1504384,1000000,504384]

{"sheet":"H2(SAISONNALITE)","index":3,"n_rows":22,"n_cols":9,"rows_kept":22,"cut":false,"hidden":false,"merged":[[21,1,21,12],[4,1,6,7],[10,1,20,12]]}
[]
[]
[]
[]
[null,"Si tu veux voir une vidéo de cette situation professionnelle complète sur you tube clique"]
[null,null,null,null,null,null,null,null,"ICI"]
[]
[]
[]
[]
[null,"La partie découverte s'arrête ici. Si tu veux allez plus loin tu peux télécharger 3 exemples de situations professionnelles E5 (avec les 3 fiches correspondantes + des fiches résumées du cours utilisé pour chaque situation) + une vidéo présentation orale en situation d'examen sur chaque situations professionnelles + 2 tutos vidéos sur Excel"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"CLIQUER ICI POUR OBTENIR LE DOSSIER E5"]

{"sheet":"H2(POINT MORT)","index":4,"n_rows":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[{"$f":"SUM(#REF!)+((#REF!-SUM(#REF!))/(SUM(#REF!)-SUM(#REF!)))*#REF!","v":{"$error":"#REF!"}}]
[{"$f":"SUM(#REF!)+((#REF!-SUM(#REF!))/(SUM(#REF!)-SUM(#REF!)))*#REF!","v":{"$error":"#REF!"}}]
[{"$f":"SUM(#REF!)+((#REF!-SUM(#REF!))/(SUM(#REF!)-SUM(#REF!)))*#REF!","v":{"$error":"#REF!"}}]
[{"$f":"SUM(#REF!)+((#REF!-SUM(#REF!))/(SUM(#REF!)-SUM(#REF!)))*#REF!","v":{"$error":"#REF!"}}]
[{"$f":"SUM(#REF!)+((#REF!-SUM(#REF!))/(SUM(#REF!)-SUM(#REF!)))*#REF!","v":{"$error":"#REF!"}}]
[{"$f":"SUM(#REF!)+((#REF!-SUM(#REF!))/(SUM(#REF!)-SUM(#REF!)))*#REF!","v":{"$error":"#REF!"}}]
[{"$f":"SUM(#REF!)+((#REF!-SUM(#REF!))/(SUM(#REF!)-SUM(#REF!)))*#REF!","v":{"$error":"#REF!"}}]
[{"$f":"SUM(#REF!)+((#REF!-SUM(#REF!))/(SUM(#REF!)-SUM(#REF!)))*#REF!","v":{"$error":"#REF!"}}]
[{"$f":"SUM(#REF!)+((#REF!-SUM(#REF!))/(SUM(#REF!)-SUM(#REF!)))*#REF!","v":{"$error":"#REF!"}}]
[{"$f":"SUM(#REF!)+((#REF!-SUM(#REF!))/(SUM(#REF!)-SUM(#REF!)))*#REF!","v":{"$error":"#REF!"}}]
[{"$f":"SUM(#REF!)+((#REF!-SUM(#REF!))/(SUM(#REF!)-SUM(#REF!)))*#REF!","v":{"$error":"#REF!"}}]

{"sheet":"Evolution CA","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

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