{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Umsätze nach Region"],"not_rendered":{"charts":1,"defined_names":7},"read":"whole","date_system":"1900"}

{"sheet":"Umsätze nach Region","index":0,"n_rows":12,"n_cols":17,"rows_kept":12,"merged":[[0,0,0,14],[1,0,1,12],[1,13,1,14]]}
["  UMSÄTZE NACH REGION",{"$nulls":15}," "]
["Das Diagramm der Umsätze nach Region verzeichnet die Umsätze von bis zu acht Regionen von Januar bis Dezember. Geben Sie Anmerkungen in Zelle N2 rechts und die Umsatzdaten für die einzelnen Monate in den Zellen unten ein.",{"$nulls":12},"\nANMERKUNGEN:\nNordamerika setzt den starken Lauf im August fort, aber wir müssen uns Asien genauer anschauen."]
["REGION","JAN","FEB","MRZ","APR","MAI","JUN","JUL","AUG","SEP","OKT","NOV","DEZ","SUMME","%","Bezeichnung"]
["Nordamerika",{"v":23000,"d":"23,000 €"},{"v":25000,"d":"25,000 €"},{"v":19000,"d":"19,000 €"},{"v":13000,"d":"13,000 €"},{"v":18000,"d":"18,000 €"},{"v":22000,"d":"22,000 €"},{"v":26000,"d":"26,000 €"},{"$nulls":5},{"$f":"SUM('Umsätze nach Region'!$B4:$M4)","v":{"v":146000,"d":"146,000.00 €"}},{"$f":"'Umsätze nach Region'!$N4/SUM('Umsätze nach Region'!$N$4:$N$11)","v":{"v":0.42196531791907516,"d":"0 €"}},{"$f":"'Umsätze nach Region'!$A4 & \" (\" & TEXT('Umsätze nach Region'!$O4,\"0%\") & \")\"","v":"Nordamerika (42%)"}]
["Asien",{"v":14000,"d":"14,000 €"},{"v":18000,"d":"18,000 €"},{"v":14000,"d":"14,000 €"},{"v":12000,"d":"12,000 €"},{"v":14000,"d":"14,000 €"},{"v":18000,"d":"18,000 €"},{"v":12000,"d":"12,000 €"},{"$nulls":5},{"$f":"SUM('Umsätze nach Region'!$B5:$M5)","v":{"v":102000,"d":"102,000.00 €"}},{"$f":"'Umsätze nach Region'!$N5/SUM('Umsätze nach Region'!$N$4:$N$11)","v":{"v":0.2947976878612717,"d":"0 €"}},{"$f":"'Umsätze nach Region'!$A5 & \" (\" & TEXT('Umsätze nach Region'!$O5,\"0%\") & \")\"","v":"Asien (29%)"}]
["Europa",{"v":20000,"d":"20,000 €"},{"v":12000,"d":"12,000 €"},{"v":13000,"d":"13,000 €"},{"v":10000,"d":"10,000 €"},{"v":11000,"d":"11,000 €"},{"v":15000,"d":"15,000 €"},{"v":17000,"d":"17,000 €"},{"$nulls":5},{"$f":"SUM('Umsätze nach Region'!$B6:$M6)","v":{"v":98000,"d":"98,000.00 €"}},{"$f":"'Umsätze nach Region'!$N6/SUM('Umsätze nach Region'!$N$4:$N$11)","v":{"v":0.2832369942196532,"d":"0 €"}},{"$f":"'Umsätze nach Region'!$A6 & \" (\" & TEXT('Umsätze nach Region'!$O6,\"0%\") & \")\"","v":"Europa (28%)"}]
[{"$nulls":13},{"$f":"SUM('Umsätze nach Region'!$B7:$M7)","v":{"v":0,"d":"0.00 €"}},{"$f":"'Umsätze nach Region'!$N7/SUM('Umsätze nach Region'!$N$4:$N$11)","v":{"v":0,"d":"0 €"}},{"$f":"'Umsätze nach Region'!$A7 & \" (\" & TEXT('Umsätze nach Region'!$O7,\"0%\") & \")\"","v":" (0%)"}]
[{"$nulls":13},{"$f":"SUM('Umsätze nach Region'!$B8:$M8)","v":{"v":0,"d":"0.00 €"}},{"$f":"'Umsätze nach Region'!$N8/SUM('Umsätze nach Region'!$N$4:$N$11)","v":{"v":0,"d":"0 €"}},{"$f":"'Umsätze nach Region'!$A8 & \" (\" & TEXT('Umsätze nach Region'!$O8,\"0%\") & \")\"","v":" (0%)"}]
[{"$nulls":13},{"$f":"SUM('Umsätze nach Region'!$B9:$M9)","v":{"v":0,"d":"0.00 €"}},{"$f":"'Umsätze nach Region'!$N9/SUM('Umsätze nach Region'!$N$4:$N$11)","v":{"v":0,"d":"0 €"}},{"$f":"'Umsätze nach Region'!$A9 & \" (\" & TEXT('Umsätze nach Region'!$O9,\"0%\") & \")\"","v":" (0%)"}]
[{"$nulls":13},{"$f":"SUM('Umsätze nach Region'!$B10:$M10)","v":{"v":0,"d":"0.00 €"}},{"$f":"'Umsätze nach Region'!$N10/SUM('Umsätze nach Region'!$N$4:$N$11)","v":{"v":0,"d":"0 €"}},{"$f":"'Umsätze nach Region'!$A10 & \" (\" & TEXT('Umsätze nach Region'!$O10,\"0%\") & \")\"","v":" (0%)"}]
[{"$nulls":13},{"$f":"SUM('Umsätze nach Region'!$B11:$M11)","v":{"v":0,"d":"0.00 €"}},{"$f":"'Umsätze nach Region'!$N11/SUM('Umsätze nach Region'!$N$4:$N$11)","v":{"v":0,"d":"0 €"}},{"$f":"'Umsätze nach Region'!$A11 & \" (\" & TEXT('Umsätze nach Region'!$O11,\"0%\") & \")\"","v":" (0%)"}]
["SUMME",{"$f":"SUBTOTAL(109,Region[JAN])","v":{"v":57000,"d":"57,000 €"}},{"$f":"SUBTOTAL(109,Region[FEB])","v":{"v":55000,"d":"55,000 €"}},{"$f":"SUBTOTAL(109,Region[MRZ])","v":{"v":46000,"d":"46,000 €"}},{"$f":"SUBTOTAL(109,Region[APR])","v":{"v":35000,"d":"35,000 €"}},{"$f":"SUBTOTAL(109,Region[MAI])","v":{"v":43000,"d":"43,000 €"}},{"$f":"SUBTOTAL(109,Region[JUN])","v":{"v":55000,"d":"55,000 €"}},{"$f":"SUBTOTAL(109,Region[JUL])","v":{"v":55000,"d":"55,000 €"}},{"$f":"SUBTOTAL(109,Region[AUG])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Region[SEP])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Region[OKT])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Region[NOV])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Region[DEZ])","v":{"v":0,"d":"0 €"}},{"$f":"SUBTOTAL(109,Region[SUMME])","v":{"v":346000,"d":"346,000.00 €"}},{"$f":"SUBTOTAL(109,Region[%])","v":{"v":1,"d":"1 €"}}]