1_1_Gesamt MS Jahresvergleich_2018_2019.ppx 26 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543
  1. <?xml version="1.0" encoding="windows-1252" standalone="yes"?>
  2. <Document xmlns="http://www.cognos.com">
  3. <HEAD xmlns="http://www.w3.org/TR/REC-html40">
  4. <TITLE>1_1_Gesamt MS Jahresvergleich_2018_2019.ppx</TITLE>
  5. </HEAD>
  6. <PowerPlayReport xmlns="http://www.cognos.com/powerplay/report" Product_version="7.4.3101.0" Author="PPWIN" Version="1.3">
  7. <PPDSConnection Cube="nw_gw_vk_bc_2018_2020.mdc" Path="\\de0509-gaps\Gaps\Portal\System\Cube_out\">
  8. <DataPool>
  9. <CatExp ExpId="T666">
  10. <Op Code="+">
  11. <Ref RefId="814317"/>
  12. <Ref RefId="1385447"/>
  13. </Op>
  14. </CatExp>
  15. <CatExp ExpId="T674">
  16. <Op Code="%">
  17. <Ref RefId="11147"/>
  18. <Ref RefId="738253"/>
  19. </Op>
  20. </CatExp>
  21. <CatExp ExpId="T680">
  22. <Op Code="G">
  23. <Ref RefId="747879"/>
  24. <Ref RefId="1723371"/>
  25. <Ref RefId="1037799"/>
  26. <Ref RefId="1924139"/>
  27. <Ref RefId="2204589"/>
  28. <Ref RefId="948191"/>
  29. </Op>
  30. </CatExp>
  31. <CatExp ExpId="T682">
  32. <Op Code="G">
  33. <Ref RefId="749385"/>
  34. <Ref RefId="1043809"/>
  35. <Ref RefId="1049275"/>
  36. <Ref RefId="747149"/>
  37. <Ref RefId="1594833"/>
  38. <Ref RefId="915723"/>
  39. <Ref RefId="892875"/>
  40. <Ref RefId="747013"/>
  41. <Ref RefId="786429"/>
  42. <Ref RefId="747879"/>
  43. <Ref RefId="1723371"/>
  44. <Ref RefId="1037799"/>
  45. <Ref RefId="1924139"/>
  46. <Ref RefId="2204589"/>
  47. <Ref RefId="948191"/>
  48. </Op>
  49. </CatExp>
  50. <CatExp ExpId="T684">
  51. <Op Code="G">
  52. <Ref RefId="749385"/>
  53. <Ref RefId="1043809"/>
  54. <Ref RefId="1049275"/>
  55. <Ref RefId="747149"/>
  56. <Ref RefId="1594833"/>
  57. <Ref RefId="915723"/>
  58. <Ref RefId="892875"/>
  59. <Ref RefId="747013"/>
  60. <Ref RefId="786429"/>
  61. <Ref RefId="747879"/>
  62. <Ref RefId="1723371"/>
  63. <Ref RefId="1037799"/>
  64. <Ref RefId="1924139"/>
  65. <Ref RefId="2204589"/>
  66. <Ref RefId="948191"/>
  67. <Ref RefId="814317"/>
  68. <Ref RefId="1385447"/>
  69. </Op>
  70. </CatExp>
  71. <CatExp ExpId="T686">
  72. <Op Code="+">
  73. <Ref RefId="746437"/>
  74. <Const Value="0."/>
  75. </Op>
  76. </CatExp>
  77. <CatExp ExpId="T672">
  78. <Op Code="G">
  79. <Ref RefId="1502857"/>
  80. <Ref RefId="794135"/>
  81. <Ref RefId="804049"/>
  82. </Op>
  83. </CatExp>
  84. <CatExp ExpId="T692">
  85. <Op Code="/">
  86. <Ref RefId="11147"/>
  87. <Ref RefId="767"/>
  88. </Op>
  89. </CatExp>
  90. <CatExp ExpId="T690">
  91. <Op Code="G">
  92. <Ref RefId="750623"/>
  93. <Ref RefId="811581"/>
  94. <Ref RefId="1035153"/>
  95. <Ref RefId="2201803"/>
  96. <Ref RefId="3097697"/>
  97. </Op>
  98. </CatExp>
  99. <CatExp ExpId="T696">
  100. <Op Code="G">
  101. <Ref RefId="760659"/>
  102. <Ref RefId="1048789"/>
  103. <Ref RefId="1037303"/>
  104. <Ref RefId="1042475"/>
  105. <Ref RefId="746539"/>
  106. <Ref RefId="747077"/>
  107. <Ref RefId="1376655"/>
  108. <Ref RefId="1702725"/>
  109. <Ref RefId="1055751"/>
  110. <Ref RefId="2903411"/>
  111. <Ref RefId="2615649"/>
  112. <Ref RefId="2897467"/>
  113. <Ref RefId="3185645"/>
  114. </Op>
  115. </CatExp>
  116. <CatExp ExpId="T698">
  117. <Op Code="G">
  118. <Ref RefId="760659"/>
  119. <Ref RefId="1048789"/>
  120. <Ref RefId="1037303"/>
  121. <Ref RefId="1042475"/>
  122. <Ref RefId="746539"/>
  123. <Ref RefId="747077"/>
  124. <Ref RefId="1376655"/>
  125. <Ref RefId="1702725"/>
  126. <Ref RefId="1055751"/>
  127. <Ref RefId="2903411"/>
  128. <Ref RefId="2615649"/>
  129. <Ref RefId="2897467"/>
  130. <Ref RefId="3185645"/>
  131. <Ref RefId="750623"/>
  132. <Ref RefId="811581"/>
  133. <Ref RefId="1035153"/>
  134. <Ref RefId="2201803"/>
  135. <Ref RefId="3097697"/>
  136. <Ref RefId="804049"/>
  137. <Ref RefId="794135"/>
  138. <Ref RefId="1502857"/>
  139. <Ref RefId="746437"/>
  140. </Op>
  141. </CatExp>
  142. <Dimension DimIdx="10" Code="Fahrzeugart"/>
  143. <Dimension DimIdx="0" Code="Zeit"/>
  144. <Dimension DimIdx="37" Code="KENNZAHLEN"/>
  145. <Dimension DimIdx="1" Code="Siebrecht/AOV"/>
  146. <Dimension DimIdx="2" Code="Verkäufername"/>
  147. <PPDSID DimIdx="0" Code="20180101-20181231" CatId="1025783"/>
  148. <PPDSID DimIdx="0" Code="20190101-20191231" CatId="1374863"/>
  149. <PPDSID DimIdx="1" Code="Birth Place" CatId="168987"/>
  150. <PPDSID DimIdx="1" Code="169005" CatId="169005"/>
  151. <PPDSID DimIdx="1" Code="743959" CatId="743959"/>
  152. <Level LevelId="168999" DimIdx="1" Code="Bank Name 3"/>
  153. <PPDSID DimIdx="2" Code="El Zahran, Mohamed" CatId="760659"/>
  154. <PPDSID DimIdx="2" Code="Cherri, Mohamed" CatId="1048789"/>
  155. <PPDSID DimIdx="2" Code="Toy, Medat" CatId="1037303"/>
  156. <PPDSID DimIdx="2" Code="Macke, Philip" CatId="1042475"/>
  157. <PPDSID DimIdx="2" Code="Klee, Peter" CatId="746539"/>
  158. <PPDSID DimIdx="2" Code="Grützbach, Mike" CatId="747077"/>
  159. <PPDSID DimIdx="2" Code="Reinert, Rudolf" CatId="1376655"/>
  160. <PPDSID DimIdx="2" Code="Gorr, Alexander" CatId="1702725"/>
  161. <PPDSID DimIdx="2" Code="Gabriel, Christian" CatId="1055751"/>
  162. <PPDSID DimIdx="2" Code="Thieme, Alexander" CatId="2903411"/>
  163. <PPDSID DimIdx="2" Code="Weinrich, Alexander" CatId="2615649"/>
  164. <PPDSID DimIdx="2" Code="Buske, Noah" CatId="2897467"/>
  165. <PPDSID DimIdx="2" Code="Roloff, Martin" CatId="3185645"/>
  166. <PPDSID DimIdx="2" Code="Schrader, Timo" CatId="811259"/>
  167. <PPDSID DimIdx="2" Code="Hacke, Andreas" CatId="750623"/>
  168. <PPDSID DimIdx="2" Code="Grinda, Karsten" CatId="811581"/>
  169. <PPDSID DimIdx="2" Code="Binder, Michael" CatId="1035153"/>
  170. <PPDSID DimIdx="2" Code="Jung, Daniel" CatId="2201803"/>
  171. <PPDSID DimIdx="2" Code="Schäfer, Nando" CatId="3097697"/>
  172. <PPDSID DimIdx="2" Code="5125724 / 1042505 / Marcel Schürmann / 2014-10-15" CatId="3681379"/>
  173. <PPDSID DimIdx="2" Code="Muhs, Andreas" CatId="804049"/>
  174. <PPDSID DimIdx="2" Code="Werkmeister, Jörg" CatId="794135"/>
  175. <PPDSID DimIdx="2" Code="Petersen, Henrik" CatId="1502857"/>
  176. <PPDSID DimIdx="2" Code="Bretag, Wolfgang" CatId="746437"/>
  177. <PPDSID DimIdx="2" Code="Winzmann, Benjamin" CatId="749385"/>
  178. <PPDSID DimIdx="2" Code="Eichmann, Erik" CatId="1043809"/>
  179. <PPDSID DimIdx="2" Code="Frenzel, Niklas" CatId="1049275"/>
  180. <PPDSID DimIdx="2" Code="Keller, Thomas" CatId="747149"/>
  181. <PPDSID DimIdx="2" Code="Fuchs, Marita" CatId="1594833"/>
  182. <PPDSID DimIdx="2" Code="Vierke, Rüdiger" CatId="915723"/>
  183. <PPDSID DimIdx="2" Code="Schlufter, Jörg" CatId="892875"/>
  184. <PPDSID DimIdx="2" Code="Denk, Kai" CatId="747013"/>
  185. <PPDSID DimIdx="2" Code="Stübener, Katharina" CatId="786429"/>
  186. <PPDSID DimIdx="2" Code="Weigmann, Peter" CatId="2968545"/>
  187. <PPDSID DimIdx="2" Code="Bär, Konstantin" CatId="814317"/>
  188. <PPDSID DimIdx="2" Code="De Buhr, Sandra" CatId="1385447"/>
  189. <PPDSID DimIdx="2" Code="Wedekind, Andre" CatId="747879"/>
  190. <PPDSID DimIdx="2" Code="Nitsche, Marcel" CatId="1723371"/>
  191. <PPDSID DimIdx="2" Code="Burgmann, Felix" CatId="1037799"/>
  192. <PPDSID DimIdx="2" Code="Zimmermann, Dirk" CatId="1924139"/>
  193. <PPDSID DimIdx="2" Code="Renneberg, Jan" CatId="2204589"/>
  194. <PPDSID DimIdx="2" Code="Weseler, Stefan" CatId="948191"/>
  195. <PPDSID DimIdx="10" Code="Fahrzeugart" CatId="2483"/>
  196. <PPDSID DimIdx="10" Code="Neuwagen" CatId="2617"/>
  197. <PPDSID DimIdx="10" Code="Gebrauchtwagen" CatId="5221"/>
  198. <PPDSID DimIdx="37" Code="KENNZAHLEN" CatId="4"/>
  199. <PPDSID DimIdx="37" Code="Erlös" CatId="771"/>
  200. <PPDSID DimIdx="37" Code="Ums. Fracht und Überf." CatId="775"/>
  201. <PPDSID DimIdx="37" Code="Einsatz" CatId="783"/>
  202. <PPDSID DimIdx="37" Code="Menge FZG" CatId="767"/>
  203. <PPDSID DimIdx="37" Code="DB1" CatId="11147"/>
  204. <PPDSID DimIdx="37" Code="Gesamterlös (FZG u. Fracht)" CatId="11623"/>
  205. <PPDSID DimIdx="37" Code="Nachlass u. Prov." CatId="16459"/>
  206. <PPDSID DimIdx="37" Code="Menge" CatId="1025663"/>
  207. <PPDSID DimIdx="37" Code="Nettoerlös" CatId="738253"/>
  208. </DataPool>
  209. <custom_subsets/>
  210. <Filter RefIds="4,4"/>
  211. </PPDSConnection>
  212. <ReportSpecification>
  213. <ReportAxis RankOrSort="Sort" Identifier="row">
  214. <NestGroup>
  215. <NestLevel Extent="83"/>
  216. <Category Format="374" RefId="168987" Label="Gesamt"/>
  217. <Category DefaultLabel="Aufsummierung(El Zahran, Mohamed, Cherri, Mohamed, Toy, Medat, Macke, Philip, Klee, Peter, Grützbach, Mike, Reinert, Rudolf, Gorr, Alexander, Gabriel, Christian, Thieme, Alexander, Weinrich, Alexander, Buske, Noah, Roloff, Martin, Hacke, Andreas, Grinda, Karsten, Binder, Michael, Jung, Daniel, Schäfer, Nando, Muhs, Andreas, Werkmeister, Jörg, Petersen, Henrik, Bretag, Wolfgang)" Format="453" RefId="T698" Label="U + H + E + G"/>
  218. <Category DefaultLabel="Aufsummierung(El Zahran, Mohamed, Cherri, Mohamed, Toy, Medat, Macke, Philip, Klee, Peter, Grützbach, Mike, Reinert, Rudolf, Gorr, Alexander, Gabriel, Christian, Thieme, Alexander, Weinrich, Alexander, Buske, Noah, Roloff, Martin)" Format="450" RefId="T696" Label="Uslar"/>
  219. <Category RefId="760659"/>
  220. <Category RefId="1048789"/>
  221. <Category RefId="1037303"/>
  222. <Category RefId="1042475"/>
  223. <Category RefId="746539"/>
  224. <Category RefId="747077"/>
  225. <Category RefId="1376655"/>
  226. <Category RefId="1702725"/>
  227. <Category RefId="1055751"/>
  228. <Category RefId="2903411"/>
  229. <Category RefId="2615649"/>
  230. <Category RefId="2897467"/>
  231. <Category RefId="3185645"/>
  232. <Category RefId="811259"/>
  233. <Category DefaultLabel="Aufsummierung(Hacke, Andreas, Grinda, Karsten, Binder, Michael, Jung, Daniel, Schäfer, Nando)" Format="424" RefId="T690" Label="Holzminden"/>
  234. <Category RefId="750623"/>
  235. <Category RefId="811581"/>
  236. <Category RefId="1035153"/>
  237. <Category RefId="2201803"/>
  238. <Category RefId="3097697"/>
  239. <Category RefId="3681379"/>
  240. <Category DefaultLabel="Aufsummierung(Petersen, Henrik, Werkmeister, Jörg, Muhs, Andreas)" Format="377" RefId="T672" Label="Einbeck"/>
  241. <Category RefId="804049"/>
  242. <Category RefId="794135"/>
  243. <Category RefId="1502857"/>
  244. <Category DefaultLabel="Bretag, Wolfgang + 0" Format="439" RefId="T686" Label="Göttingen"/>
  245. <Category RefId="746437"/>
  246. <Category DefaultLabel="Aufsummierung(Winzmann, Benjamin, Eichmann, Erik, Frenzel, Niklas, Keller, Thomas, Fuchs, Marita, Vierke, Rüdiger, Schlufter, Jörg, Denk, Kai, Stübener, Katharina, Wedekind, Andre, Nitsche, Marcel, Burgmann, Felix, Zimmermann, Dirk, Renneberg, Jan, Weseler, Stefan, Bär, Konstantin, De Buhr, Sandra)" Format="433" RefId="T684" Label="Großkunden Gesamt"/>
  247. <Category DefaultLabel="Aufsummierung(Winzmann, Benjamin, Eichmann, Erik, Frenzel, Niklas, Keller, Thomas, Fuchs, Marita, Vierke, Rüdiger, Schlufter, Jörg, Denk, Kai, Stübener, Katharina, Wedekind, Andre, Nitsche, Marcel, Burgmann, Felix, Zimmermann, Dirk, Renneberg, Jan, Weseler, Stefan)" Format="432" RefId="T682" Label="Grokunden o.Bär+DeBuhr"/>
  248. <Category RefId="749385"/>
  249. <Category RefId="1043809"/>
  250. <Category RefId="1049275"/>
  251. <Category RefId="747149"/>
  252. <Category RefId="1594833"/>
  253. <Category RefId="915723"/>
  254. <Category RefId="892875"/>
  255. <Category RefId="747013"/>
  256. <Category RefId="786429"/>
  257. <Category RefId="2968545"/>
  258. <Category DefaultLabel="Bär, Konstantin + De Buhr, Sandra" Format="371" RefId="T666" Label="Team Bär + De Buhr"/>
  259. <Category RefId="814317"/>
  260. <Category RefId="1385447"/>
  261. <Category DefaultLabel="Aufsummierung(Wedekind, Andre, Nitsche, Marcel, Burgmann, Felix, Zimmermann, Dirk, Renneberg, Jan, Weseler, Stefan)" Format="407" RefId="T680" Label="Großkunden Einbeck"/>
  262. <Category RefId="747879"/>
  263. <Category RefId="1723371"/>
  264. <Category RefId="1037799"/>
  265. <Category RefId="1924139"/>
  266. <Category RefId="2204589"/>
  267. <Category RefId="948191"/>
  268. <Category Format="370" RefId="169005"/>
  269. <Category QueryKey="5"/>
  270. <Category Format="370" RefId="743959"/>
  271. <Category QueryKey="6"/>
  272. </NestGroup>
  273. <NestGroup>
  274. <NestLevel Extent="76"/>
  275. <Category RefId="2483" Label="Gesamt"/>
  276. <Category RefId="2617"/>
  277. <Category RefId="5221" Label="Gebrauchtw."/>
  278. </NestGroup>
  279. </ReportAxis>
  280. <ReportAxis Identifier="col">
  281. <NestGroup>
  282. <NestLevel Extent="24"/>
  283. <Category Format="113" RefId="2483" Label="Gesamt"/>
  284. </NestGroup>
  285. <NestGroup>
  286. <NestLevel Extent="28"/>
  287. <Category RefId="1025783"/>
  288. <Category RefId="1374863"/>
  289. </NestGroup>
  290. <NestGroup>
  291. <NestLevel Extent="39"/>
  292. <Category Hidden="1" RefId="771" ColExtent="77"/>
  293. <Category Hidden="1" RefId="775" ColExtent="77"/>
  294. <Category Hidden="1" RefId="783" ColExtent="71"/>
  295. <Category Format="447" RefId="767" Label="Menge" ColExtent="41"/>
  296. <Category Format="293" RefId="11147" Label="DB1" ColExtent="71"/>
  297. <Category DefaultLabel="Prozent(DB1 (Inkl. AfA), Nettoerlös)" Format="369" RefId="T674" Label="DB1 %" ColExtent="46"/>
  298. <Category DefaultLabel="DB1 (Inkl. AfA) / Menge FZG" Format="292" RefId="T692" Label="Durs. DB1" ColExtent="38"/>
  299. <Category Format="42" Hidden="1" RefId="11623" Label="Erlös (FZG u. Fracht)" ColExtent="69"/>
  300. <Category Format="45" Hidden="1" RefId="16459" ColExtent="65"/>
  301. <Category Hidden="1" RefId="771" ColExtent="77"/>
  302. <Category Hidden="1" RefId="775" ColExtent="77"/>
  303. <Category Hidden="1" RefId="783" ColExtent="71">
  304. <Blank ColExtent="3"/>
  305. <Blank ColExtent="6"/>
  306. </Category>
  307. </NestGroup>
  308. </ReportAxis>
  309. <ReportSettings Suppression="zero">
  310. <StandardReporting>
  311. <Set QueryKey="5" SetInsertAction="16" SetIndex="159" SetDimension="0" SetLevel="1"/>
  312. <Set QueryKey="6" SetInsertAction="16" SetIndex="183" SetDimension="0" SetLevel="1"/>
  313. <QueryList>
  314. <AdvancedSubset Dimension="1" Key="6" Alias="Vermittler">
  315. <Level RefId="168999"/>
  316. <IncludeCat RefId="743959"/>
  317. <IncludeDrilPath RefId="168987"/>
  318. </AdvancedSubset>
  319. <AdvancedSubset Dimension="1" Key="5" Alias="AOV">
  320. <Level RefId="168999"/>
  321. <IncludeCat RefId="169005"/>
  322. <IncludeDrilPath RefId="168987"/>
  323. </AdvancedSubset>
  324. </QueryList>
  325. </StandardReporting>
  326. <FormatList>
  327. <DefaultFormat>
  328. <Font Height="-11"/>
  329. <Align Column="0"/>
  330. <NumberFormat Decimals="2" RefId="0" Identifier="#,##0"/>
  331. </DefaultFormat>
  332. <Format Id="42">
  333. <PatternRef RefId="3" Specifier="1"/>
  334. <NumFormatRef RefId="38" Specifier="1025663"/>
  335. </Format>
  336. <Format Id="45">
  337. <NumFormatRef RefId="38" Specifier="1025663"/>
  338. </Format>
  339. <Format Id="113">
  340. <AlignRef RefId="3" Specifier="0"/>
  341. </Format>
  342. <Format Id="292">
  343. <FontRef RefId="5" Specifier="0"/>
  344. <FontRef RefId="8" Specifier="1"/>
  345. <PatternRef RefId="5" Specifier="0"/>
  346. <PatternRef RefId="6" Specifier="1"/>
  347. <NumFormatRef RefId="36" Specifier="0"/>
  348. <NumFormatRef RefId="38" Specifier="1025663"/>
  349. </Format>
  350. <Format Id="293">
  351. <FontRef RefId="8" Specifier="1"/>
  352. <PatternRef RefId="5" Specifier="0"/>
  353. <PatternRef RefId="6" Specifier="1"/>
  354. <NumFormatRef RefId="38" Specifier="1025663"/>
  355. </Format>
  356. <Format Id="369">
  357. <FontRef RefId="6" Specifier="0"/>
  358. <FontRef RefId="8" Specifier="1"/>
  359. <PatternRef RefId="4" Specifier="1"/>
  360. <NumFormatRef RefId="37" Specifier="0"/>
  361. </Format>
  362. <Format Id="370">
  363. <FontRef RefId="8" Specifier="0"/>
  364. <FontRef RefId="8" Specifier="1"/>
  365. <PatternRef RefId="8" Specifier="0"/>
  366. <PatternRef RefId="8" Specifier="1"/>
  367. </Format>
  368. <Format Id="371">
  369. <FontRef RefId="8" Specifier="0"/>
  370. <FontRef RefId="8" Specifier="1"/>
  371. <PatternRef RefId="9" Specifier="0"/>
  372. <PatternRef RefId="9" Specifier="1"/>
  373. </Format>
  374. <Format Id="374">
  375. <FontRef RefId="8" Specifier="0"/>
  376. <FontRef RefId="8" Specifier="1"/>
  377. <PatternRef RefId="10" Specifier="0"/>
  378. <PatternRef RefId="10" Specifier="1"/>
  379. </Format>
  380. <Format Id="377">
  381. <FontRef RefId="8" Specifier="0"/>
  382. <FontRef RefId="8" Specifier="1"/>
  383. <PatternRef RefId="9" Specifier="0"/>
  384. <PatternRef RefId="9" Specifier="1"/>
  385. <NumFormatRef RefId="43" Specifier="0"/>
  386. </Format>
  387. <Format Id="407">
  388. <FontRef RefId="8" Specifier="0"/>
  389. <FontRef RefId="8" Specifier="1"/>
  390. <PatternRef RefId="9" Specifier="0"/>
  391. <PatternRef RefId="9" Specifier="1"/>
  392. <NumFormatRef RefId="39" Specifier="0"/>
  393. </Format>
  394. <Format Id="424">
  395. <FontRef RefId="8" Specifier="0"/>
  396. <FontRef RefId="8" Specifier="1"/>
  397. <PatternRef RefId="9" Specifier="0"/>
  398. <PatternRef RefId="9" Specifier="1"/>
  399. <NumFormatRef RefId="44" Specifier="0"/>
  400. </Format>
  401. <Format Id="432">
  402. <FontRef RefId="8" Specifier="0"/>
  403. <FontRef RefId="8" Specifier="1"/>
  404. <PatternRef RefId="9" Specifier="0"/>
  405. <PatternRef RefId="9" Specifier="1"/>
  406. <NumFormatRef RefId="40" Specifier="0"/>
  407. </Format>
  408. <Format Id="433">
  409. <FontRef RefId="8" Specifier="0"/>
  410. <FontRef RefId="8" Specifier="1"/>
  411. <PatternRef RefId="9" Specifier="0"/>
  412. <PatternRef RefId="9" Specifier="1"/>
  413. <NumFormatRef RefId="41" Specifier="0"/>
  414. </Format>
  415. <Format Id="439">
  416. <FontRef RefId="8" Specifier="0"/>
  417. <FontRef RefId="8" Specifier="1"/>
  418. <PatternRef RefId="9" Specifier="0"/>
  419. <PatternRef RefId="9" Specifier="1"/>
  420. <NumFormatRef RefId="42" Specifier="0"/>
  421. </Format>
  422. <Format Id="447">
  423. <FontRef RefId="8" Specifier="1"/>
  424. <PatternRef RefId="7" Specifier="0"/>
  425. <PatternRef RefId="6" Specifier="1"/>
  426. <AlignRef RefId="3" Specifier="0"/>
  427. <NumFormatRef RefId="38" Specifier="1025663"/>
  428. </Format>
  429. <Format Id="450">
  430. <FontRef RefId="7" Specifier="0"/>
  431. <FontRef RefId="8" Specifier="1"/>
  432. <PatternRef RefId="9" Specifier="1"/>
  433. <NumFormatRef RefId="45" Specifier="0"/>
  434. </Format>
  435. <Format Id="453">
  436. <FontRef RefId="7" Specifier="0"/>
  437. <FontRef RefId="8" Specifier="1"/>
  438. <PatternRef RefId="9" Specifier="1"/>
  439. <NumFormatRef RefId="46" Specifier="0"/>
  440. </Format>
  441. <Style Shared="true" Name="Niedrige automat. Ausnahmen">
  442. <FontRef RefId="3" Specifier="0"/>
  443. <FontRef RefId="3" Specifier="1"/>
  444. <PatternRef RefId="1" Specifier="0"/>
  445. <PatternRef RefId="1" Specifier="1"/>
  446. <AlignRef RefId="1" Specifier="0"/>
  447. </Style>
  448. <Style Shared="true" Name="Hohe automat. Ausnahmen">
  449. <FontRef RefId="4" Specifier="0"/>
  450. <FontRef RefId="4" Specifier="1"/>
  451. <PatternRef RefId="2" Specifier="0"/>
  452. <PatternRef RefId="2" Specifier="1"/>
  453. <AlignRef RefId="2" Specifier="0"/>
  454. </Style>
  455. <FormatAtom Type="alignment" Id="2"/>
  456. <FormatAtom Type="alignment" Id="1"/>
  457. <FormatAtom Type="alignment" Id="3"/>
  458. <FormatAtom Weight="700" Type="font" Id="4">
  459. <Color R="255"/>
  460. </FormatAtom>
  461. <FormatAtom Weight="700" Type="font" Id="3">
  462. <Color R="255"/>
  463. </FormatAtom>
  464. <FormatAtom OwnerStyle="4294967293" RefId="0" Decimals="0" Type="numberformat" Id="36" Identifier="#,##0"/>
  465. <FormatAtom Height="-11" Type="font" Id="5"/>
  466. <FormatAtom OwnerStyle="4294967293" RefId="0" Decimals="2" Type="numberformat" Id="37" Identifier="0%"/>
  467. <FormatAtom Height="-11" Type="font" Id="6"/>
  468. <FormatAtom RefId="1025663" Decimals="0" Type="numberformat" Id="38" Identifier="#,##0"/>
  469. <FormatAtom OwnerStyle="4294967293" RefId="0" Decimals="2" Type="numberformat" Id="39" Identifier="#,##0"/>
  470. <FormatAtom OwnerStyle="4294967293" RefId="0" Decimals="2" Type="numberformat" Id="40" Identifier="#,##0"/>
  471. <FormatAtom OwnerStyle="4294967293" RefId="0" Decimals="2" Type="numberformat" Id="41" Identifier="#,##0"/>
  472. <FormatAtom OwnerStyle="4294967293" RefId="0" Decimals="2" Type="numberformat" Id="42" Identifier="#,##0"/>
  473. <FormatAtom OwnerStyle="4294967293" RefId="0" Decimals="2" Type="numberformat" Id="43" Identifier="#,##0"/>
  474. <FormatAtom OwnerStyle="4294967293" RefId="0" Decimals="2" Type="numberformat" Id="44" Identifier="#,##0"/>
  475. <FormatAtom OwnerStyle="4294967293" RefId="0" Decimals="2" Type="numberformat" Id="45" Identifier="#,##0"/>
  476. <FormatAtom OwnerStyle="4294967293" RefId="0" Decimals="2" Type="numberformat" Id="46" Identifier="#,##0"/>
  477. <FormatAtom Height="-11" Type="font" Id="7"/>
  478. <FormatAtom Height="-11" Weight="700" Type="font" Id="8"/>
  479. <FormatAtom Type="pattern" Id="2"/>
  480. <FormatAtom Type="pattern" Id="1"/>
  481. <FormatAtom Type="pattern" Id="3" Style="4">
  482. <Color G="255" B="255" Identifier="foreground"/>
  483. </FormatAtom>
  484. <FormatAtom Type="pattern" Id="4" Style="1">
  485. <Color G="192" R="192" B="192" Identifier="background"/>
  486. <Color G="255" R="255" B="255" Identifier="foreground"/>
  487. </FormatAtom>
  488. <FormatAtom Type="pattern" Id="5" Style="1"/>
  489. <FormatAtom Type="pattern" Id="6" Style="6">
  490. <Color G="192" R="192" B="192" Identifier="background"/>
  491. <Color G="192" R="192" B="192" Identifier="foreground"/>
  492. </FormatAtom>
  493. <FormatAtom Type="pattern" Id="7" Style="4">
  494. <Color G="192" R="192" B="192" Identifier="background"/>
  495. <Color G="255" R="255" B="255" Identifier="foreground"/>
  496. </FormatAtom>
  497. <FormatAtom Type="pattern" Id="8" Style="3">
  498. <Color G="255" R="255" Identifier="foreground"/>
  499. </FormatAtom>
  500. <FormatAtom Type="pattern" Id="9" Style="4">
  501. <Color G="255" R="255" Identifier="background"/>
  502. <Color G="255" R="255" B="255" Identifier="foreground"/>
  503. </FormatAtom>
  504. <FormatAtom Type="pattern" Id="10" Style="6">
  505. <Color G="255" R="255" Identifier="background"/>
  506. <Color G="255" R="255" B="255" Identifier="foreground"/>
  507. </FormatAtom>
  508. </FormatList>
  509. </ReportSettings>
  510. </ReportSpecification>
  511. <ChartLayout TileStyle="3" AutoFitMode="2">
  512. <CustomColor Idx="0" Value="10485760"/>
  513. <CustomColor Idx="1" Value="65535"/>
  514. <CustomColor Idx="2" Value="255"/>
  515. <CustomColor Idx="3" Value="16776960"/>
  516. <CustomColor Idx="4" Value="32512"/>
  517. <CustomColor Idx="5" Value="127"/>
  518. <CustomColor Idx="6" Value="8355584"/>
  519. <CustomColor Idx="7" Value="32767"/>
  520. <CustomColor Idx="8" Value="65280"/>
  521. <CustomColor Idx="9" Value="8323199"/>
  522. <CustomColor Idx="10" Value="32639"/>
  523. <CustomColor Idx="11" Value="16777087"/>
  524. <CustomColor Idx="12" Value="16711680"/>
  525. <CustomColor Idx="13" Value="16711935"/>
  526. <CustomColor Idx="14" Value="4243648"/>
  527. <CustomColor Idx="15" Value="12599360"/>
  528. <Crosstab/>
  529. <PageLayout>
  530. <MarginInfo L="51" R="51" B="54" T="114"/>
  531. <PageInfo PageOrientation="2" PageHeight="4318" PaperSource="15" PageWidth="2794" PageTypeID="3"/>
  532. <ReportStyle UseFontSubstitution="true" AxesAllPages="true"/>
  533. <ReportRange AllRows="1" Type="2" AllLayers="1"/>
  534. </PageLayout>
  535. </ChartLayout>
  536. <TextFrame Type="title" AppendPDFTitle="false">
  537. <Text>&lt;P&gt;&lt;Span Style="font: 12pt Arial; color: rgb(0,0,0); charset: 0"&gt;&lt;B&gt;Verkaufsübersicht per &lt;/B&gt;&lt;/Span&gt;&lt;Span Style="font: 12pt Arial; color: rgb(0,0,0); charset: 0"&gt;&lt;B&gt;&lt;Var&gt;MDC FILE DATE(dd.MM.yyyy)&lt;/Var&gt;&lt;/B&gt;&lt;/Span&gt;&lt;/P&gt;&lt;P&gt;&lt;Span Style="font: 10pt Arial; font-weight: normal; color: rgb(0,0,0); charset: 0"&gt;&lt;/Span&gt;&lt;/P&gt;</Text>
  538. </TextFrame>
  539. <Deployment>
  540. <ReportStyle UseFontSubstitution="true" AxesAllPages="true"/>
  541. </Deployment>
  542. </PowerPlayReport>
  543. </Document>