{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Analysis","Dashboard"],"not_rendered":{"charts":3,"images":2,"macros":1,"external_links":0,"defined_names":7,"comments":0,"pivot_tables":2},"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":"Analysis","index":0,"n_rows":109,"n_cols":12,"rows_kept":109,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[null,"category","age"]
[null,1,"18 - 59"]
[null,2,"60 - 69"]
[null,3,"70+"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Vaccination rate","Planned vaccination rate"]
[null,"Zeilenbeschriftungen","Anzahl von SaveID","Vaccination rate","Planned vaccination rate",null,{"$f":"GETPIVOTDATA(\"[Measures].[Vaccination rate]\",$B$15)","v":0.36192761447710459},{"$f":"GETPIVOTDATA(\"[Measures].[Planned vaccination rate]\",$B$15)","v":0.1923615276944611},null,"Land","Bundesland","Impfquote"]
[null,"Baden-Württemberg",637,0.34065934065934067,0.19309262166405022,null,{"$f":"GETPIVOTDATA(\"[Measures].[Vaccination rate]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Baden-Württemberg]\")","v":0.34065934065934067},{"$f":"GETPIVOTDATA(\"[Measures].[Planned vaccination rate]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Baden-Württemberg]\")","v":0.19309262166405022},null,"Germany","Baden-Württemberg",{"$f":"_xlfn.IFS(Dashboard!$AL$28=\"Geimpft\", Analysis!G16, Dashboard!$AL$28=\"Impfung geplant\", Analysis!H16, Dashboard!$AL$28=\"Geimpft & Impfung geplant\", (Analysis!G16+Analysis!H16))","v":0.34065934065934067}]
[null,"Bayern",781,0.34699103713188223,0.14340588988476313,null,{"$f":"GETPIVOTDATA(\"[Measures].[Vaccination rate]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Bayern]\")","v":0.34699103713188223},{"$f":"GETPIVOTDATA(\"[Measures].[Planned vaccination rate]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Bayern]\")","v":0.14340588988476313},null,"Germany","Bayern",{"$f":"_xlfn.IFS(Dashboard!$AL$28=\"Geimpft\", Analysis!G17, Dashboard!$AL$28=\"Impfung geplant\", Analysis!H17, Dashboard!$AL$28=\"Geimpft & Impfung geplant\", (Analysis!G17+Analysis!H17))","v":0.34699103713188223}]
[null,"Berlin",230,0.43913043478260871,0.17391304347826086,null,{"$f":"GETPIVOTDATA(\"[Measures].[Vaccination rate]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Berlin]\")","v":0.43913043478260871},{"$f":"GETPIVOTDATA(\"[Measures].[Planned vaccination rate]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Berlin]\")","v":0.17391304347826086},null,"Germany","Berlin",{"$f":"_xlfn.IFS(Dashboard!$AL$28=\"Geimpft\", Analysis!G18, Dashboard!$AL$28=\"Impfung geplant\", Analysis!H18, Dashboard!$AL$28=\"Geimpft & Impfung geplant\", (Analysis!G18+Analysis!H18))","v":0.43913043478260871}]
[null,"Brandenburg",156,0.35256410256410259,0.28205128205128205,null,{"$f":"GETPIVOTDATA(\"[Measures].[Vaccination rate]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Brandenburg]\")","v":0.35256410256410259},{"$f":"GETPIVOTDATA(\"[Measures].[Planned vaccination rate]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Brandenburg]\")","v":0.28205128205128205},null,"Germany","Brandenburg",{"$f":"_xlfn.IFS(Dashboard!$AL$28=\"Geimpft\", Analysis!G19, Dashboard!$AL$28=\"Impfung geplant\", Analysis!H19, Dashboard!$AL$28=\"Geimpft & Impfung geplant\", (Analysis!G19+Analysis!H19))","v":0.35256410256410259}]
[null,"Bremen",38,0.28947368421052633,0.10526315789473684,null,{"$f":"GETPIVOTDATA(\"[Measures].[Vaccination rate]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Bremen]\")","v":0.28947368421052633},{"$f":"GETPIVOTDATA(\"[Measures].[Planned vaccination rate]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Bremen]\")","v":0.10526315789473684},null,"Germany","Bremen",{"$f":"_xlfn.IFS(Dashboard!$AL$28=\"Geimpft\", Analysis!G20, Dashboard!$AL$28=\"Impfung geplant\", Analysis!H20, Dashboard!$AL$28=\"Geimpft & Impfung geplant\", (Analysis!G20+Analysis!H20))","v":0.28947368421052633}]
[null,"Hamburg",112,0.4017857142857143,0.1875,null,{"$f":"GETPIVOTDATA(\"[Measures].[Vaccination rate]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Hamburg]\")","v":0.4017857142857143},{"$f":"GETPIVOTDATA(\"[Measures].[Planned vaccination rate]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Hamburg]\")","v":0.1875},null,"Germany","Hamburg",{"$f":"_xlfn.IFS(Dashboard!$AL$28=\"Geimpft\", Analysis!G21, Dashboard!$AL$28=\"Impfung geplant\", Analysis!H21, Dashboard!$AL$28=\"Geimpft & Impfung geplant\", (Analysis!G21+Analysis!H21))","v":0.4017857142857143}]
[null,"Hessen",379,0.34828496042216361,0.21372031662269128,null,{"$f":"GETPIVOTDATA(\"[Measures].[Vaccination rate]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Hessen]\")","v":0.34828496042216361},{"$f":"GETPIVOTDATA(\"[Measures].[Planned vaccination rate]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Hessen]\")","v":0.21372031662269128},null,"Germany","Hessen",{"$f":"_xlfn.IFS(Dashboard!$AL$28=\"Geimpft\", Analysis!G22, Dashboard!$AL$28=\"Impfung geplant\", Analysis!H22, Dashboard!$AL$28=\"Geimpft & Impfung geplant\", (Analysis!G22+Analysis!H22))","v":0.34828496042216361}]
[null,"Mecklenburg-Vorpommern",102,0.29411764705882354,0.29411764705882354,null,{"$f":"GETPIVOTDATA(\"[Measures].[Vaccination rate]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Mecklenburg-Vorpommern]\")","v":0.29411764705882354},{"$f":"GETPIVOTDATA(\"[Measures].[Planned vaccination rate]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Mecklenburg-Vorpommern]\")","v":0.29411764705882354},null,"Germany","Mecklenburg-Vorpommern",{"$f":"_xlfn.IFS(Dashboard!$AL$28=\"Geimpft\", Analysis!G23, Dashboard!$AL$28=\"Impfung geplant\", Analysis!H23, Dashboard!$AL$28=\"Geimpft & Impfung geplant\", (Analysis!G23+Analysis!H23))","v":0.29411764705882354}]
[null,"Niedersachsen",483,0.39337474120082816,0.17805383022774326,null,{"$f":"GETPIVOTDATA(\"[Measures].[Vaccination rate]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Niedersachsen]\")","v":0.39337474120082816},{"$f":"GETPIVOTDATA(\"[Measures].[Planned vaccination rate]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Niedersachsen]\")","v":0.17805383022774326},null,"Germany","Niedersachsen",{"$f":"_xlfn.IFS(Dashboard!$AL$28=\"Geimpft\", Analysis!G24, Dashboard!$AL$28=\"Impfung geplant\", Analysis!H24, Dashboard!$AL$28=\"Geimpft & Impfung geplant\", (Analysis!G24+Analysis!H24))","v":0.39337474120082816}]
[null,"Nordrhein-Westfalen",1083,0.39242843951985223,0.20406278855032317,null,{"$f":"GETPIVOTDATA(\"[Measures].[Vaccination rate]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Nordrhein-Westfalen]\")","v":0.39242843951985223},{"$f":"GETPIVOTDATA(\"[Measures].[Planned vaccination rate]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Nordrhein-Westfalen]\")","v":0.20406278855032317},null,"Germany","Nordrhein-Westfalen",{"$f":"_xlfn.IFS(Dashboard!$AL$28=\"Geimpft\", Analysis!G25, Dashboard!$AL$28=\"Impfung geplant\", Analysis!H25, Dashboard!$AL$28=\"Geimpft & Impfung geplant\", (Analysis!G25+Analysis!H25))","v":0.39242843951985223}]
[null,"Rheinland-Pfalz",233,0.30901287553648071,0.18454935622317598,null,{"$f":"GETPIVOTDATA(\"[Measures].[Vaccination rate]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Rheinland-Pfalz]\")","v":0.30901287553648071},{"$f":"GETPIVOTDATA(\"[Measures].[Planned vaccination rate]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Rheinland-Pfalz]\")","v":0.18454935622317598},null,"Germany","Rheinland-Pfalz",{"$f":"_xlfn.IFS(Dashboard!$AL$28=\"Geimpft\", Analysis!G26, Dashboard!$AL$28=\"Impfung geplant\", Analysis!H26, Dashboard!$AL$28=\"Geimpft & Impfung geplant\", (Analysis!G26+Analysis!H26))","v":0.30901287553648071}]
[null,"Saarland",59,0.32203389830508472,0.11864406779661017,null,{"$f":"GETPIVOTDATA(\"[Measures].[Vaccination rate]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Saarland]\")","v":0.32203389830508472},{"$f":"GETPIVOTDATA(\"[Measures].[Planned vaccination rate]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Saarland]\")","v":0.11864406779661017},null,"Germany","Saarland",{"$f":"_xlfn.IFS(Dashboard!$AL$28=\"Geimpft\", Analysis!G27, Dashboard!$AL$28=\"Impfung geplant\", Analysis!H27, Dashboard!$AL$28=\"Geimpft & Impfung geplant\", (Analysis!G27+Analysis!H27))","v":0.32203389830508472}]
[null,"Sachsen",264,0.32575757575757575,0.20833333333333334,null,{"$f":"GETPIVOTDATA(\"[Measures].[Vaccination rate]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Sachsen]\")","v":0.32575757575757575},{"$f":"GETPIVOTDATA(\"[Measures].[Planned vaccination rate]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Sachsen]\")","v":0.20833333333333334},null,"Germany","Sachsen",{"$f":"_xlfn.IFS(Dashboard!$AL$28=\"Geimpft\", Analysis!G28, Dashboard!$AL$28=\"Impfung geplant\", Analysis!H28, Dashboard!$AL$28=\"Geimpft & Impfung geplant\", (Analysis!G28+Analysis!H28))","v":0.32575757575757575}]
[null,"Sachsen-Anhalt",136,0.30882352941176472,0.26470588235294118,null,{"$f":"GETPIVOTDATA(\"[Measures].[Vaccination rate]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Sachsen-Anhalt]\")","v":0.30882352941176472},{"$f":"GETPIVOTDATA(\"[Measures].[Planned vaccination rate]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Sachsen-Anhalt]\")","v":0.26470588235294118},null,"Germany","Sachsen-Anhalt",{"$f":"_xlfn.IFS(Dashboard!$AL$28=\"Geimpft\", Analysis!G29, Dashboard!$AL$28=\"Impfung geplant\", Analysis!H29, Dashboard!$AL$28=\"Geimpft & Impfung geplant\", (Analysis!G29+Analysis!H29))","v":0.30882352941176472}]
[null,"Schleswig-Holstein",177,0.3559322033898305,0.20338983050847459,null,{"$f":"GETPIVOTDATA(\"[Measures].[Vaccination rate]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Schleswig-Holstein]\")","v":0.3559322033898305},{"$f":"GETPIVOTDATA(\"[Measures].[Planned vaccination rate]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Schleswig-Holstein]\")","v":0.20338983050847459},null,"Germany","Schleswig-Holstein",{"$f":"_xlfn.IFS(Dashboard!$AL$28=\"Geimpft\", Analysis!G30, Dashboard!$AL$28=\"Impfung geplant\", Analysis!H30, Dashboard!$AL$28=\"Geimpft & Impfung geplant\", (Analysis!G30+Analysis!H30))","v":0.3559322033898305}]
[null,"Thüringen",131,0.38931297709923662,0.17557251908396945,null,{"$f":"GETPIVOTDATA(\"[Measures].[Vaccination rate]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Thüringen]\")","v":0.38931297709923662},{"$f":"GETPIVOTDATA(\"[Measures].[Planned vaccination rate]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Thüringen]\")","v":0.17557251908396945},null,"Germany","Thüringen",{"$f":"_xlfn.IFS(Dashboard!$AL$28=\"Geimpft\", Analysis!G31, Dashboard!$AL$28=\"Impfung geplant\", Analysis!H31, Dashboard!$AL$28=\"Geimpft & Impfung geplant\", (Analysis!G31+Analysis!H31))","v":0.38931297709923662}]
[null,"Gesamtergebnis",5001,0.36192761447710459,0.1923615276944611,null,{"$f":"GETPIVOTDATA(\"[Measures].[Vaccination rate]\",$B$15)","v":0.36192761447710459},{"$f":"GETPIVOTDATA(\"[Measures].[Planned vaccination rate]\",$B$15)","v":0.1923615276944611},null,"Total"]
[]
[]
[]
[]
[null,null,null,null,null,null,"Geimpft"]
[null,null,null,null,null,null,"Impfung geplant"]
[null,null,null,null,null,null,"Geimpft & Impfung geplant"]
[]
[null,null,null,null,null,null,null,null,null,null,30]
[null,null,null,null,null,null,null,null,null,null,"±"]
[null,null,null,null,null,null,null,10,null,1.33,"MoE"]
[null,"Total",{"$f":"IF(E44=0,\"-\", _xlfn.IFS(Dashboard!$AL$28=\"Geimpft\", Analysis!G15, Dashboard!$AL$28=\"Impfung geplant\", Analysis!H15, Dashboard!$AL$28=\"Geimpft & Impfung geplant\", (Analysis!G15+Analysis!H15)))","v":0.36192761447710459},-0.25,{"$f":"GETPIVOTDATA(\"[Measures].[Anzahl von SaveID]\",$B$15)","v":5001},{"$f":"IF(E44>=$H$43, 0.01, -0.15)","v":0.01},1,{"$f":"IF(E44<$H$43,0.01,-0.15)","v":-0.15},{"$f":"IF(AND(E44<$H$43,E44>0),IF(C44=0, 0.19, IF(C44=1, 1.26, (C44+0.23))),-0.15)","v":-0.15},{"$f":"$J$43","v":1.33},{"$f":"IF(E44>=$K$41, 1.96*(SQRT((C44*(1-C44))/E44)), \"n/a\")","v":1.3319057047348691E-2}]
[null,"Baden-Württemberg",{"$f":"IF(E45=0,\"-\", _xlfn.IFS(Dashboard!$AL$28=\"Geimpft\", Analysis!G16, Dashboard!$AL$28=\"Impfung geplant\", Analysis!H16, Dashboard!$AL$28=\"Geimpft & Impfung geplant\", (Analysis!G16+Analysis!H16)))","v":0.34065934065934067},{"$f":"D44","v":-0.25},{"$f":"GETPIVOTDATA(\"[Measures].[Anzahl von SaveID]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Baden-Württemberg]\")","v":637},{"$f":"IF(E45>=$H$43, 0.01, -0.15)","v":0.01},2,{"$f":"IF(E45<$H$43,0.01,-0.15)","v":-0.15},{"$f":"IF(AND(E45<$H$43,E45>0),IF(C45=0, 0.19, IF(C45=1, 1.26, (C45+0.23))),-0.15)","v":-0.15},{"$f":"$J$43","v":1.33},{"$f":"IF(E45>=$K$41, 1.96*(SQRT((C45*(1-C45))/E45)), \"n/a\")","v":3.6804543464947055E-2}]
[null,"Bayern",{"$f":"IF(E46=0,\"-\", _xlfn.IFS(Dashboard!$AL$28=\"Geimpft\", Analysis!G17, Dashboard!$AL$28=\"Impfung geplant\", Analysis!H17, Dashboard!$AL$28=\"Geimpft & Impfung geplant\", (Analysis!G17+Analysis!H17)))","v":0.34699103713188223},{"$f":"D45","v":-0.25},{"$f":"GETPIVOTDATA(\"[Measures].[Anzahl von SaveID]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Bayern]\")","v":781},0.01,3,-0.15,-0.15,{"$f":"$J$43","v":1.33},3.3384836529219954E-2]
[null,"Berlin",{"$f":"IF(E47=0,\"-\", _xlfn.IFS(Dashboard!$AL$28=\"Geimpft\", Analysis!G18, Dashboard!$AL$28=\"Impfung geplant\", Analysis!H18, Dashboard!$AL$28=\"Geimpft & Impfung geplant\", (Analysis!G18+Analysis!H18)))","v":0.43913043478260871},{"$f":"D46","v":-0.25},{"$f":"GETPIVOTDATA(\"[Measures].[Anzahl von SaveID]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Berlin]\")","v":230},0.01,4,-0.15,-0.15,1.33,6.4138656613071734E-2]
[null,"Brandenburg",{"$f":"IF(E48=0,\"-\", _xlfn.IFS(Dashboard!$AL$28=\"Geimpft\", Analysis!G19, Dashboard!$AL$28=\"Impfung geplant\", Analysis!H19, Dashboard!$AL$28=\"Geimpft & Impfung geplant\", (Analysis!G19+Analysis!H19)))","v":0.35256410256410259},-0.25,{"$f":"GETPIVOTDATA(\"[Measures].[Anzahl von SaveID]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Brandenburg]\")","v":156},0.01,5,-0.15,-0.15,1.33,7.4974090390227746E-2]
[null,"Bremen",{"$f":"IF(E49=0,\"-\", _xlfn.IFS(Dashboard!$AL$28=\"Geimpft\", Analysis!G20, Dashboard!$AL$28=\"Impfung geplant\", Analysis!H20, Dashboard!$AL$28=\"Geimpft & Impfung geplant\", (Analysis!G20+Analysis!H20)))","v":0.28947368421052633},-0.25,{"$f":"GETPIVOTDATA(\"[Measures].[Anzahl von SaveID]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Bremen]\")","v":38},0.01,6,-0.15,-0.15,1.33,0.14419788852160603]
[null,"Hamburg",{"$f":"IF(E50=0,\"-\", _xlfn.IFS(Dashboard!$AL$28=\"Geimpft\", Analysis!G21, Dashboard!$AL$28=\"Impfung geplant\", Analysis!H21, Dashboard!$AL$28=\"Geimpft & Impfung geplant\", (Analysis!G21+Analysis!H21)))","v":0.4017857142857143},-0.25,{"$f":"GETPIVOTDATA(\"[Measures].[Anzahl von SaveID]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Hamburg]\")","v":112},0.01,7,-0.15,-0.15,1.33,9.0797250096024393E-2]
[null,"Hessen",{"$f":"IF(E51=0,\"-\", _xlfn.IFS(Dashboard!$AL$28=\"Geimpft\", Analysis!G22, Dashboard!$AL$28=\"Impfung geplant\", Analysis!H22, Dashboard!$AL$28=\"Geimpft & Impfung geplant\", (Analysis!G22+Analysis!H22)))","v":0.34828496042216361},-0.25,{"$f":"GETPIVOTDATA(\"[Measures].[Anzahl von SaveID]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Hessen]\")","v":379},0.01,8,-0.15,-0.15,1.33,4.7965911148829157E-2]
[null,"Mecklenburg-Vorpommern",{"$f":"IF(E52=0,\"-\", _xlfn.IFS(Dashboard!$AL$28=\"Geimpft\", Analysis!G23, Dashboard!$AL$28=\"Impfung geplant\", Analysis!H23, Dashboard!$AL$28=\"Geimpft & Impfung geplant\", (Analysis!G23+Analysis!H23)))","v":0.29411764705882354},-0.25,{"$f":"GETPIVOTDATA(\"[Measures].[Anzahl von SaveID]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Mecklenburg-Vorpommern]\")","v":102},0.01,9,-0.15,-0.15,1.33,8.8426551655343882E-2]
[null,"Niedersachsen",{"$f":"IF(E53=0,\"-\", _xlfn.IFS(Dashboard!$AL$28=\"Geimpft\", Analysis!G24, Dashboard!$AL$28=\"Impfung geplant\", Analysis!H24, Dashboard!$AL$28=\"Geimpft & Impfung geplant\", (Analysis!G24+Analysis!H24)))","v":0.39337474120082816},-0.25,{"$f":"GETPIVOTDATA(\"[Measures].[Anzahl von SaveID]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Niedersachsen]\")","v":483},0.01,10,-0.15,-0.15,1.33,4.3565829339604754E-2]
[null,"Nordrhein-Westfalen",{"$f":"IF(E54=0,\"-\", _xlfn.IFS(Dashboard!$AL$28=\"Geimpft\", Analysis!G25, Dashboard!$AL$28=\"Impfung geplant\", Analysis!H25, Dashboard!$AL$28=\"Geimpft & Impfung geplant\", (Analysis!G25+Analysis!H25)))","v":0.39242843951985223},-0.25,{"$f":"GETPIVOTDATA(\"[Measures].[Anzahl von SaveID]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Nordrhein-Westfalen]\")","v":1083},0.01,11,-0.15,-0.15,1.33,2.9081767512344179E-2]
[null,"Rheinland-Pfalz",{"$f":"IF(E55=0,\"-\", _xlfn.IFS(Dashboard!$AL$28=\"Geimpft\", Analysis!G26, Dashboard!$AL$28=\"Impfung geplant\", Analysis!H26, Dashboard!$AL$28=\"Geimpft & Impfung geplant\", (Analysis!G26+Analysis!H26)))","v":0.30901287553648071},-0.25,{"$f":"GETPIVOTDATA(\"[Measures].[Anzahl von SaveID]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Rheinland-Pfalz]\")","v":233},0.01,12,-0.15,-0.15,1.33,5.9333692434722904E-2]
[null,"Saarland",{"$f":"IF(E56=0,\"-\", _xlfn.IFS(Dashboard!$AL$28=\"Geimpft\", Analysis!G27, Dashboard!$AL$28=\"Impfung geplant\", Analysis!H27, Dashboard!$AL$28=\"Geimpft & Impfung geplant\", (Analysis!G27+Analysis!H27)))","v":0.32203389830508472},-0.25,{"$f":"GETPIVOTDATA(\"[Measures].[Anzahl von SaveID]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Saarland]\")","v":59},0.01,13,-0.15,-0.15,1.33,0.11922980949304311]
[null,"Sachsen",{"$f":"IF(E57=0,\"-\", _xlfn.IFS(Dashboard!$AL$28=\"Geimpft\", Analysis!G28, Dashboard!$AL$28=\"Impfung geplant\", Analysis!H28, Dashboard!$AL$28=\"Geimpft & Impfung geplant\", (Analysis!G28+Analysis!H28)))","v":0.32575757575757575},-0.25,{"$f":"GETPIVOTDATA(\"[Measures].[Anzahl von SaveID]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Sachsen]\")","v":264},0.01,14,-0.15,-0.15,1.33,5.6533960070326489E-2]
[null,"Sachsen-Anhalt",{"$f":"IF(E58=0,\"-\", _xlfn.IFS(Dashboard!$AL$28=\"Geimpft\", Analysis!G29, Dashboard!$AL$28=\"Impfung geplant\", Analysis!H29, Dashboard!$AL$28=\"Geimpft & Impfung geplant\", (Analysis!G29+Analysis!H29)))","v":0.30882352941176472},-0.25,{"$f":"GETPIVOTDATA(\"[Measures].[Anzahl von SaveID]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Sachsen-Anhalt]\")","v":136},0.01,15,-0.15,-0.15,1.33,7.7649073975108923E-2]
[null,"Schleswig-Holstein",{"$f":"IF(E59=0,\"-\", _xlfn.IFS(Dashboard!$AL$28=\"Geimpft\", Analysis!G30, Dashboard!$AL$28=\"Impfung geplant\", Analysis!H30, Dashboard!$AL$28=\"Geimpft & Impfung geplant\", (Analysis!G30+Analysis!H30)))","v":0.3559322033898305},-0.25,{"$f":"GETPIVOTDATA(\"[Measures].[Anzahl von SaveID]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Schleswig-Holstein]\")","v":177},0.01,16,-0.15,-0.15,1.33,7.0537306548461118E-2]
[null,"Thüringen",{"$f":"IF(E60=0,\"-\", _xlfn.IFS(Dashboard!$AL$28=\"Geimpft\", Analysis!G31, Dashboard!$AL$28=\"Impfung geplant\", Analysis!H31, Dashboard!$AL$28=\"Geimpft & Impfung geplant\", (Analysis!G31+Analysis!H31)))","v":0.38931297709923662},-0.25,{"$f":"GETPIVOTDATA(\"[Measures].[Anzahl von SaveID]\",$B$15,\"[Influenza_Dashboard_raw data].[QMktSize_6_1]\",\"[Influenza_Dashboard_raw data].[QMktSize_6_1].&[Thüringen]\")","v":131},0.01,17,-0.15,-0.15,1.33,8.34986029953248E-2]
[null,"Gesamt",null,null,{"$f":"\"Teilnehmende  n=\"&GETPIVOTDATA(\"[Measures].[Anzahl von SaveID]\",$B$15)","v":"Teilnehmende  n=5001"}]
[]
[]
[]
[]
[null,"Konfidenzintervall",0.95]
[null,"Z-score",1.96]
[null,"Impfquote (p)",0.31]
[null,"Sample per Bundesland/Total",297]
[null,"MoE",{"$f":"C67*(SQRT((C68*(1-C68))/C69))","v":5.2599696584753039E-2}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null," ","<60 Jahre","≥60 Jahre"]
[null,"W1 \n(22.10.-01.11.24)",{"$f":"IFERROR(GETPIVOTDATA(\"[Measures].[Vaccination rate]\",$B$101,\"[Influenza_Dashboard_raw data].[Wave]\",\"[Influenza_Dashboard_raw data].[Wave].&[1 (KW 43/44)]\",\"[Influenza_Dashboard_raw data].[age_category2]\",\"[Influenza_Dashboard_raw data].[age_category2].&[0]\"),NA())","v":0.21381578947368421},{"$f":"IFERROR(GETPIVOTDATA(\"[Measures].[Vaccination rate]\",$B$101,\"[Influenza_Dashboard_raw data].[Wave]\",\"[Influenza_Dashboard_raw data].[Wave].&[1 (KW 43/44)]\",\"[Influenza_Dashboard_raw data].[age_category2]\",\"[Influenza_Dashboard_raw data].[age_category2].&[1]\"),NA())","v":0.31321839080459768}]
[null,"W2 \n(04.11.-15.11.24)",{"$f":"IFERROR(GETPIVOTDATA(\"[Measures].[Vaccination rate]\",$B$101,\"[Influenza_Dashboard_raw data].[Wave]\",\"[Influenza_Dashboard_raw data].[Wave].&[2 (KW 45/46)]\",\"[Influenza_Dashboard_raw data].[age_category2]\",\"[Influenza_Dashboard_raw data].[age_category2].&[0]\"),NA())","v":0.21666666666666667},{"$f":"IFERROR(GETPIVOTDATA(\"[Measures].[Vaccination rate]\",$B$101,\"[Influenza_Dashboard_raw data].[Wave]\",\"[Influenza_Dashboard_raw data].[Wave].&[2 (KW 45/46)]\",\"[Influenza_Dashboard_raw data].[age_category2]\",\"[Influenza_Dashboard_raw data].[age_category2].&[1]\"),NA())","v":0.3457142857142857}]
[null,"W3 \n(18.11.-01.12.24)",{"$f":"IFERROR(GETPIVOTDATA(\"[Measures].[Vaccination rate]\",$B$101,\"[Influenza_Dashboard_raw data].[Wave]\",\"[Influenza_Dashboard_raw data].[Wave].&[3 (KW 47/48)]\",\"[Influenza_Dashboard_raw data].[age_category2]\",\"[Influenza_Dashboard_raw data].[age_category2].&[0]\"),NA())","v":0.27906976744186046},{"$f":"IFERROR(GETPIVOTDATA(\"[Measures].[Vaccination rate]\",$B$101,\"[Influenza_Dashboard_raw data].[Wave]\",\"[Influenza_Dashboard_raw data].[Wave].&[3 (KW 47/48)]\",\"[Influenza_Dashboard_raw data].[age_category2]\",\"[Influenza_Dashboard_raw data].[age_category2].&[1]\"),NA())","v":0.47564469914040114}]
[null,"W4 \n(02.12.-13.12.24)",{"$f":"IFERROR(GETPIVOTDATA(\"[Measures].[Vaccination rate]\",$B$101,\"[Influenza_Dashboard_raw data].[Wave]\",\"[Influenza_Dashboard_raw data].[Wave].&[4 (KW 49/50)]\",\"[Influenza_Dashboard_raw data].[age_category2]\",\"[Influenza_Dashboard_raw data].[age_category2].&[0]\"),NA())","v":0.19333333333333333},{"$f":"IFERROR(GETPIVOTDATA(\"[Measures].[Vaccination rate]\",$B$101,\"[Influenza_Dashboard_raw data].[Wave]\",\"[Influenza_Dashboard_raw data].[Wave].&[4 (KW 49/50)]\",\"[Influenza_Dashboard_raw data].[age_category2]\",\"[Influenza_Dashboard_raw data].[age_category2].&[1]\"),NA())","v":0.45441595441595439}]
[null,"W5 \n(03.02.-07.02.25)",{"$f":"IFERROR(GETPIVOTDATA(\"[Measures].[Vaccination rate]\",$B$101,\"[Influenza_Dashboard_raw data].[Wave]\",\"[Influenza_Dashboard_raw data].[Wave].&[5 (KW 06/07)]\",\"[Influenza_Dashboard_raw data].[age_category2]\",\"[Influenza_Dashboard_raw data].[age_category2].&[0]\"),NA())","v":0.25333333333333335},{"$f":"IFERROR(GETPIVOTDATA(\"[Measures].[Vaccination rate]\",$B$101,\"[Influenza_Dashboard_raw data].[Wave]\",\"[Influenza_Dashboard_raw data].[Wave].&[5 (KW 06/07)]\",\"[Influenza_Dashboard_raw data].[age_category2]\",\"[Influenza_Dashboard_raw data].[age_category2].&[1]\"),NA())","v":0.50142857142857145}]
[]
[]
[]
[]
[]
[]
[null,null,"Spaltenbeschriftungen"]
[null,null,"0",null,"1",null,"Gesamt: Anzahl von SaveID","Gesamt: Vaccination rate"]
[null,"Zeilenbeschriftungen","Anzahl von SaveID","Vaccination rate","Anzahl von SaveID","Vaccination rate"]
[null,"1 (KW 43/44)",304,0.21381578947368421,696,0.31321839080459768,1000,0.28299999999999997]
[null,"2 (KW 45/46)",300,0.21666666666666667,700,0.3457142857142857,1000,0.307]
[null,"3 (KW 47/48)",301,0.27906976744186046,698,0.47564469914040114,999,0.41641641641641641]
[null,"4 (KW 49/50)",300,0.19333333333333333,702,0.45441595441595439,1002,0.37624750499001997]
[null,"5 (KW 06/07)",300,0.25333333333333335,700,0.50142857142857145,1000,0.42699999999999999]
[null,"Gesamtergebnis",1505,0.23122923588039868,3496,0.41819221967963388,5001,0.36192761447710459]

{"sheet":"Dashboard","index":1,"n_rows":28,"n_cols":38,"rows_kept":28,"cut":false,"hidden":false,"merged":[[25,37,26,52],[21,37,24,52]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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,"Influenza Impfquote"]
[]
[]
[]
[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,"Bitte unten auswählen"]
[]
[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,"Geimpft"]