{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["ACCUEIL","CAS 1","CAS 2","CAS 3"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"ACCUEIL","index":0,"n_rows":22,"n_cols":4,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Choisissez ci-dessous le cas qui concerne votre situation:"]
[]
[null,null,null,"Chambre d'hôtes, hôtel, résidence de tourisme..."]
[null,null,null,"Meublé classé "]
[]
[null,null,null,"Meublé non classé"]
[]
[]
[null,null,null,"Location meublé classé via une plateforme (type Airbnb)"]

{"sheet":"CAS 1","index":1,"n_rows":27,"n_cols":11,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Données à saisir :"]
[]
[null,null,null,null,"Classement du logement",1,null,null,null,{"$f":"INDEX($H$20:$K$24,1,(MATCH($F$12,$H$19:$K$19,0)))","v":"Hôtel, meublé et résidence 1*"}]
[null,null,null,null,"Nombre de nuits du séjour",0,null,null,"TAXE DE SEJOUR/NUIT/PERS.",{"$f":"INDEX($H$20:$K$24,4,(MATCH($F$12,$H$19:$K$19,0)))","v":0.73}]
[null,null,null,null,null,null,null,null,"TAXE ADDITIONNELLE/NUIT/PERS.",{"$f":"INDEX($H$20:$K$24,5,(MATCH($F$12,$H$19:$K$19,0)))","v":7.0000000000000007E-2}]
[null,null,null,null,"Nombre total de personnes accueillies",0,null,null,null,"MONTANT TOTAL A COLLECTER ET DECLARER",{"$f":"ROUND((J13+J14)*F13*(F15-F16),2)","v":0}]
[null,null,null,null,"dont personnes exonérées",0,null,null,null,"Dont Ville de Dunkerque",{"$f":"ROUND(J13*F13*(F15-F16),2)","v":0}]
[null,null,null,null,null,null,null,null,null,"Dont Département du Nord",{"$f":"ROUND(J14*F13*(F15-F16),2)","v":0}]
[]
[null,null,null,null,null,null,null,1,2,3,4]
[null,null,null,null,null,null,"Chambre d'hotes","Hôtel, meublé et résidence 1*","Hôtel, meublé et résidence 2*","Hôtel, meublé et résidence 3*","Hôtel, meublé et résidence 4*"]
[null,null,null,null,null,"Nombre de personnes assujetties",{"$f":"F15-F16","v":0},{"$f":"G21","v":0},{"$f":"H21","v":0},0,0]
[null,null,null,null,null,"Durée du séjour (nuits)",{"$f":"F13","v":0},{"$f":"G22","v":0},{"$f":"H22","v":0},0,0]
[null,null,null,null,null,"TAXE DE SEJOUR/NUIT/PERS.",0.73,0.73,0.82,1.2,1.35]
[null,null,null,null,null,"TAXE ADDITIONNELLE/NUIT/PERS.",7.0000000000000007E-2,7.0000000000000007E-2,0.08,0.12,0.14000000000000001]
[null,null,null,null,null,"MONTANT TOTAL A COLLECTER ET DECLARER",{"$f":"(G24+G23)*G22*G21","v":0},{"$f":"(H24+H23)*H22*H21","v":0},0,0,0]
[null,null,null,null,null,"Dont Ville de Dunkerque",{"$f":"G23*G22*G21","v":0},{"$f":"H23*H22*H21","v":0},0,0,0]
[null,null,null,null,null,"Dont Département du Nord",{"$f":"G24*G22*G21","v":0},{"$f":"H24*H22*H21","v":0},0,0,0]

{"sheet":"CAS 2","index":2,"n_rows":28,"n_cols":13,"rows_kept":28,"cut":false,"hidden":false,"merged":[[19,2,19,4],[19,5,19,6],[25,8,25,11],[12,5,12,6],[14,5,14,6],[16,5,16,6],[17,5,17,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Données à saisir :"]
[]
[]
[null,null,null,null,"Prix total HT de la location du séjour",0,null,null,null,null,null,"Taux communal pour 2019",0.03]
[null,null,null,null,null,null,null,null,null,null,null,"Tarif communal maximal pour 2019",1.35]
[null,null,null,null,"Nombre de nuits du séjour",0]
[null,null,null,null,null,null,null,null,null,null,null,"Taxe additionnelle départementale",0.1]
[null,null,null,null,"Nombre total de personnes accueillies",0]
[null,null,null,null,"dont  personnes exonérées",0,null,null,null,null,null,"Formule appliquée :"]
[null,null,null,null,null,null,null,null,null,null,null,null,"=    Cout/pers/nuit  x TAUX  x  nb pers. assujetties  x nb nuits"]
[null,null,"COUT DE LOCATION PAR PERSONNE ET PAR NUIT",null,null,{"$f":"F13/F15/F17","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Nombre de personnes assujetties",{"$f":"F17-F18","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"Durée du séjour (nuits)",{"$f":"F15","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,"TAXE DE SEJOUR COMMUNALE PAR NUIT/PERSONNE",{"$f":"IF((F20*M13)>M14,M14,(F20*M13))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,"TAXE ADDITIONNELLE PAR NUIT/PERSONNE",{"$f":"M24*M16","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,"MONTANT TOTAL A COLLECTER ET DECLARER",null,null,null,{"$f":"ROUND((M25+M24)*M22*M23,2)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,"Dont ville de dunkerque",{"$f":"ROUND((M24*M23*M22),2)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,"Dont Département du Nord",{"$f":"ROUND(M25*M23*M22,2)","v":{"$error":"#DIV/0!"}}]

{"sheet":"CAS 3","index":3,"n_rows":29,"n_cols":16,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDEX($M$23:$P$27,2,(MATCH($F$20,$M$23:$P$23,0)))","v":"Hôtel, meublé et résidence 1*"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"TAXE DE SEJOUR/NUIT/PERS.",{"$f":"INDEX($M$23:$P$27,3,(MATCH($F$20,$M$23:$P$23,0)))","v":0.73}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"TAXE ADDITIONNELLE/NUIT/PERS.",{"$f":"INDEX($M$23:$P$27,4,(MATCH($F$20,$M$23:$P$23,0)))","v":7.0000000000000007E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MONTANT TOTAL A COLLECTER ET DECLARER",{"$f":"ROUND((O13+O14)*F22*(F24-F25),2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dont Ville de Dunkerque",{"$f":"ROUND(O13*F22*(F24-F25),2)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dont Département du Nord",{"$f":"ROUND(O14*F22*(F24-F25),2)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L20:L21)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"IF(P15>L19,(P15-L19),0)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Classement du logement",1,null,null,null,null,"Dont Ville de Dunkerque",{"$f":"(IF(F21/F24/F22*F27>F28,F28,F21/F24/F22*F27)*F22*(F24-F25))","v":{"$error":"#DIV/0!"}},null,null,"Dont Ville de Dunkerque",{"$f":"IF(P16>L20,(P16-L20),0)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Prix HT de location du séjour / facture",0,null,null,null,null,"Dont Département du Nord",{"$f":"L20*F29","v":{"$error":"#DIV/0!"}},null,null,"Dont Département du Nord",{"$f":"IF(P17>L21,(P17-L21),0)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,"Nombre de nuits du séjour",0]
[null,null,null,null,null,null,null,null,null,null,null,null,1,2,3,4]
[null,null,null,null,"Nombre total de personnes accueillies",0,null,null,null,null,null,"Chambre d'hotes","Hôtel, meublé et résidence 1*","Hôtel, meublé et résidence 2*","Hôtel, meublé et résidence 3*","Hôtel, meublé et résidence 4*"]
[null,null,null,null,"dont personnes exonérées",0,null,null,null,null,"TAXE DE SEJOUR/NUIT/PERS.",0.73,0.73,0.82,1.2,1.35]
[null,null,null,null,null,null,null,null,null,null,"TAXE ADDITIONNELLE/NUIT/PERS.",7.0000000000000007E-2,7.0000000000000007E-2,0.08,0.12,0.14000000000000001]
[null,null,null,null,"Taux communal pour 2019",0.03]
[null,null,null,null,"Tarif communal maximal pour 2019",1.35]
[null,null,null,null,"Taxe additionnelle départementale",0.1]