{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Anmeldung"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"Anmeldung","index":0,"n_rows":53,"n_cols":11,"rows_kept":53,"cut":false,"hidden":false,"merged":[[21,9,22,9],[23,7,24,7],[31,7,32,7],[31,8,32,8],[8,7,8,10],[9,7,9,10],[10,7,10,10],[29,10,30,10],[23,10,24,10],[25,10,26,10],[27,10,28,10],[23,8,24,8],[27,8,28,8],[25,8,26,8],[23,9,24,9],[25,9,26,9],[27,9,28,9],[21,8,22,8],[21,7,22,7],[21,10,22,10],[37,10,38,10],[31,10,32,10],[33,10,34,10],[35,10,36,10],[33,6,34,6],[33,7,34,7],[33,8,34,8],[35,6,36,6],[25,7,26,7],[27,7,28,7],[37,7,38,7],[37,8,38,8],[37,6,38,6],[41,2,41,8],[31,9,32,9],[33,9,34,9],[35,9,36,9],[35,7,36,7],[35,8,36,8],[2,2,2,3],[19,1,20,1],[39,1,40,1],[25,1,26,1],[33,1,34,1],[27,1,28,1],[29,1,30,1],[31,1,32,1],[37,1,38,1],[21,1,22,1],[23,1,24,1],[35,1,36,1],[33,4,34,4],[35,5,36,5],[37,4,38,4],[31,4,32,4],[29,5,30,5],[31,5,32,5],[27,5,28,5],[25,6,26,6],[23,5,24,5],[21,6,22,6],[27,6,28,6],[23,6,24,6],[51,8,51,10],[39,9,40,9],[39,10,40,10],[44,10,45,10],[44,9,45,9],[39,8,40,8],[44,6,44,8],[49,2,49,9],[29,8,30,8],[29,4,30,4],[29,9,30,9],[29,7,30,7],[46,2,46,5],[37,9,38,9],[31,6,32,6],[47,2,47,5],[39,6,40,6],[39,7,40,7],[2,6,2,8],[52,2,55,7],[25,5,26,5],[39,4,40,4],[37,5,38,5],[39,5,40,5],[35,4,36,4],[33,5,34,5],[19,5,20,5],[11,7,11,10],[19,6,19,8],[19,9,20,9],[48,2,48,5],[19,4,20,4],[13,7,13,10],[12,7,12,10],[19,10,20,10],[29,6,30,6],[14,4,15,10],[21,5,22,5],[21,4,22,4],[23,4,24,4],[25,4,26,4],[27,4,28,4]]}
[]
[null,null,null,null,null,null,"Vergnügungssteuererklärung"]
[null,null,null,null,null,null,"Buchungszeichen:        5.0280."]
[]
[null,null,null,null,null,null,null,null,null,"2024"]
[]
[]
[null,null,null,null,null,null,"Absender:"]
[null,null,null,null,null,null,"Name:"]
[null,null,null,null,null,null,"Anschrift:"]
[null,null,null,null,null,null,"Ort:"]
[null,null,null,null,null,null,"Tel."]
[null,null,null,null,null,null,"Fax.:"]
[null,null,null,null,null,null,"mail:"]
[null,null,null,null,"Das Formular finden Sie unter \"Vergnügungssteuererklärung für Gaststätten\" auf buergerservice.graben-neudorf.de/online-dienste/rathausformulare zum Download."]
[]
[null,null,"Spielgeräte in Gaststätten"]
[null,null,null,null,null,null,false,false,false,true,{"$f":"IF(G18,1,IF(H18,2,IF(I18,3,IF(J18,4,0))))","v":4}]
[null,null,"Spielgeräte mit Gewinnmöglichkeit",null," - Meldung der einzelnen Geräte -",null,null,null,null,"Steuersatz:",0.26]
[null,"Nr.","a)","Name der Gaststätte","Neu ab..\nTT.MM.JJ","Entfernt am..\nTT.MM.JJ","Bruttokasse",null,null,"steuer-pflichtige Summe","Steuer \nEuro"]
[null,null,"b)","Zulassungs-Nr. des Spielgeräts",null,null,{"$f":"IF($K$18=1,\"Januar\",IF($K$18=2,\"April\",IF($K$18=3,\"Juli\",IF($K$18=4,\"Oktober\",\"1. Quartals- monat\"))))","v":"Oktober"},{"$f":"IF($K$18=1,\"Februar\",IF($K$18=2,\"Mai\",IF($K$18=3,\"August\",IF($K$18=4,\"November\",\"2. Quartals- monat\"))))","v":"November"},{"$f":"IF($K$18=1,\"März\",IF($K$18=2,\"Juni\",IF($K$18=3,\"September\",IF($K$18=4,\"Dezember\",\"3. Quartals- monat\"))))","v":"Dezember"}]
[null,1,"a)",null,null,null,null,null,null,{"$f":"IF(SUM(G22:I23)=0,\"\",(IF($G22<0,0,$G22)+(IF($H22<0,0,$H22)+(IF($I22<0,0,$I22)))))","v":""},{"$f":"IF(AND(ISBLANK($G22),ISBLANK($H22),ISBLANK($I22)),\"\",(IF($G22<0,0,$G22*$K$19)+(IF($H22<0,0,$H22*$K$19)+(IF($I22<0,0,$I22*$K$19)))))","v":""}]
[null,null,"b)"]
[null,2,"a)",null,null,null,null,null,null,{"$f":"IF(SUM(G24:I25)=0,\"\",(IF($G24<0,0,$G24)+(IF($H24<0,0,$H24)+(IF($I24<0,0,$I24)))))","v":""},{"$f":"IF(AND(ISBLANK($G24),ISBLANK($H24),ISBLANK($I24)),\"\",(IF($G24<0,0,$G24*$K$19)+(IF($H24<0,0,$H24*$K$19)+(IF($I24<0,0,$I24*$K$19)))))","v":""}]
[null,null,"b)"]
[null,3,"a)",null,null,null,null,null,null,{"$f":"IF(SUM(G26:I27)=0,\"\",(IF($G26<0,0,$G26)+(IF($H26<0,0,$H26)+(IF($I26<0,0,$I26)))))","v":""},{"$f":"IF(AND(ISBLANK($G26),ISBLANK($H26),ISBLANK($I26)),\"\",(IF($G26<0,0,$G26*$K$19)+(IF($H26<0,0,$H26*$K$19)+(IF($I26<0,0,$I26*$K$19)))))","v":""}]
[null,null,"b)"]
[null,4,"a)",null,null,null,null,null,null,{"$f":"IF(SUM(G28:I29)=0,\"\",(IF($G28<0,0,$G28)+(IF($H28<0,0,$H28)+(IF($I28<0,0,$I28)))))","v":""},{"$f":"IF(AND(ISBLANK($G28),ISBLANK($H28),ISBLANK($I28)),\"\",(IF($G28<0,0,$G28*$K$19)+(IF($H28<0,0,$H28*$K$19)+(IF($I28<0,0,$I28*$K$19)))))","v":""}]
[null,null,"b)"]
[null,5,"a)",null,null,null,null,null,null,{"$f":"IF(SUM(G30:I31)=0,\"\",(IF($G30<0,0,$G30)+(IF($H30<0,0,$H30)+(IF($I30<0,0,$I30)))))","v":""},{"$f":"IF(AND(ISBLANK($G30),ISBLANK($H30),ISBLANK($I30)),\"\",(IF($G30<0,0,$G30*$K$19)+(IF($H30<0,0,$H30*$K$19)+(IF($I30<0,0,$I30*$K$19)))))","v":""}]
[null,null,"b)"]
[null,6,"a)",null,null,null,null,null,null,{"$f":"IF(SUM(G32:I33)=0,\"\",(IF($G32<0,0,$G32)+(IF($H32<0,0,$H32)+(IF($I32<0,0,$I32)))))","v":""},{"$f":"IF(AND(ISBLANK($G32),ISBLANK($H32),ISBLANK($I32)),\"\",(IF($G32<0,0,$G32*$K$19)+(IF($H32<0,0,$H32*$K$19)+(IF($I32<0,0,$I32*$K$19)))))","v":""}]
[null,null,"b)"]
[null,7,"a)",null,null,null,null,null,null,{"$f":"IF(SUM(G34:I35)=0,\"\",(IF($G34<0,0,$G34)+(IF($H34<0,0,$H34)+(IF($I34<0,0,$I34)))))","v":""},{"$f":"IF(AND(ISBLANK($G34),ISBLANK($H34),ISBLANK($I34)),\"\",(IF($G34<0,0,$G34*$K$19)+(IF($H34<0,0,$H34*$K$19)+(IF($I34<0,0,$I34*$K$19)))))","v":""}]
[null,null,"b)"]
[null,8,"a)",null,null,null,null,null,null,{"$f":"IF(SUM(G36:I37)=0,\"\",(IF($G36<0,0,$G36)+(IF($H36<0,0,$H36)+(IF($I36<0,0,$I36)))))","v":""},{"$f":"IF(AND(ISBLANK($G36),ISBLANK($H36),ISBLANK($I36)),\"\",(IF($G36<0,0,$G36*$K$19)+(IF($H36<0,0,$H36*$K$19)+(IF($I36<0,0,$I36*$K$19)))))","v":""}]
[null,null,"b)"]
[null,9,"a)",null,null,null,null,null,null,{"$f":"IF(SUM(G38:I39)=0,\"\",(IF($G38<0,0,$G38)+(IF($H38<0,0,$H38)+(IF($I38<0,0,$I38)))))","v":""},{"$f":"IF(AND(ISBLANK($G38),ISBLANK($H38),ISBLANK($I38)),\"\",(IF($G38<0,0,$G38*$K$19)+(IF($H38<0,0,$H38*$K$19)+(IF($I38<0,0,$I38*$K$19)))))","v":""}]
[null,null,"b)"]
[null,10,"a)",null,null,null,null,null,null,{"$f":"IF(SUM(G40:I41)=0,\"\",(IF($G40<0,0,$G40)+(IF($H40<0,0,$H40)+(IF($I40<0,0,$I40)))))","v":""},{"$f":"IF(AND(ISBLANK($G40),ISBLANK($H40),ISBLANK($I40)),\"\",(IF($G40<0,0,$G40*$K$19)+(IF($H40<0,0,$H40*$K$19)+(IF($I40<0,0,$I40*$K$19)))))","v":""}]
[null,null,"b)"]
[null,null,"Zwischensumme  Spielgeräte mit Gewinnmöglichkeit",null,null,null,null,null,null,{"$f":"IF(SUM(J22:J41)=0,\"\",SUM(J22:J41))","v":""},{"$f":"IF(SUM(K22:K41)=0,\"\",SUM(K22:K41))","v":""}]
[]
[null,null,"Spielgeräte ohne Gewinnmöglichkeit je Standort",null,null," - Meldung der Gesamtzahl der Geräte -"]
[null,"Nr.","Name der Gaststätte",null,null,null,"Anzahl",null,null,"Steuersatz je Monat und Gerät","Steuer\nEuro"]
[null,null,null,null,null,null,{"$f":"IF($K$18=1,\"Januar\",IF($K$18=2,\"April\",IF($K$18=3,\"Juli\",IF($K$18=4,\"Oktober\",\"1. Quartals- monat\"))))","v":"Oktober"},{"$f":"IF($K$18=1,\"Februar\",IF($K$18=2,\"Mai\",IF($K$18=3,\"August\",IF($K$18=4,\"November\",\"2. Quartals- monat\"))))","v":"November"},{"$f":"IF($K$18=1,\"März\",IF($K$18=2,\"Juni\",IF($K$18=3,\"September\",IF($K$18=4,\"Dezember\",\"3. Quartals- monat\"))))","v":"Dezember"}]
[null,1,null,null,null,null,null,null,null,40,{"$f":"IF((G47+H47+I47)*J47=0,\"\",G47*J47+H47*J47+I47*J47)","v":""}]
[null,2,null,null,null,null,null,null,null,40,{"$f":"IF((G48+H48+I48)*J48=0,\"\",G48*J48+H48*J48+I48*J48)","v":""}]
[null,3,null,null,null,null,null,null,null,40,{"$f":"IF((G49+H49+I49)*J49=0,\"\",G49*J49+H49*J49+I49*J49)","v":""}]
[null,null,"Zwischensumme  Spielgeräte ohne Gewinnmöglichkeit",null,null,null,null,null,null,null,{"$f":"IF(SUM(K47:K49)=0,\"\",SUM(K47:K49))","v":""}]
[]
[null,null,"Vergnügungssteuer im Abrechnungszeitraum gesamt in Euro ",null,null,null,null,null,{"$f":"IF(SUM(K42:K42)+SUM(K50:K50)=0,\" € \",SUM(K42:K42)+SUM(K50:K50))","v":" € "}]
[null,null,"Die Regelungen zum Meldeverfahren und zu den Anzeigepflichten nach der Vergnügugnssteuersatzung sind mir bekannt. Meine Angaben in dieser Steuererklärung habe ich wahrheitsgemäß nach bestem Wissen und Gewissen gemacht. Die Zählwerksausdrucke für jedes Spielgerät in der o.g. Nummerierung sind in Kopie beigefügt."]