{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["ToolStammdaten","Berechnung1","Berechnung2","Berechnung3","Dashboard","Rohdaten","ABC-Analyse","Rapport","Diagramm ABC-Analyse","Kundendiagramm"],"not_rendered":{"charts":8,"images":2,"macros":1,"external_links":0,"defined_names":14,"comments":0,"pivot_tables":1},"unopened":[{"sheet":"Diagramm ABC-Analyse","index":8,"reason":"not_a_worksheet"},{"sheet":"Kundendiagramm","index":9,"reason":"not_a_worksheet"}],"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":"ToolStammdaten","index":0,"n_rows":72,"n_cols":11,"rows_kept":72,"cut":false,"hidden":true,"merged":[]}
[null,"A Klasse","B Klasse",null,"ABC Analyse",null,"Berechnungsart",null,"Währung",null,"Diagramm Titel"]
[]
[null,0.29999998999999999,{"$f":"Dashboard!G16+0.01","v":0.86},null,"Artikel",null,"Deckungsbeitrag",null,"Euro",null,{"$f":"ABC_Art_DB &\" ABC-Analyse\"","v":"Kunden ABC-Analyse"}]
[null,0.31,{"$f":"IF(C3=\"\",\"\",IF(C3+0.01<=0.99,C3+0.01,\"\"))","v":0.87},null,"Kunden",null,"Umsatz",null,"Franken",null,{"$f":"\"nach \"& [0]!ABC_Berechnungsart_DB","v":"nach Umsatz"}]
[null,0.32,{"$f":"IF(C4=\"\",\"\",IF(C4+0.01<=0.99,C4+0.01,\"\"))","v":0.88},null,"Lieferanten",null,"Warenaufwand",null,"Dollar",null,{"$f":"\"Top 10 \" & ABC_Art_DB","v":"Top 10 Kunden"}]
[null,0.33,0.89,null,"Dienstleistung",null,"Zugriffe",null,"Pfund"]
[null,0.34,0.9,null,null,null,"Absatz",null,"keine"]
[null,0.35,0.91]
[null,0.36,0.92]
[null,0.37,0.93]
[null,0.38,0.94000000000000006]
[null,0.39,0.95000000000000007]
[null,0.4,0.96000000000000008]
[null,0.41,0.97000000000000008]
[null,0.42,0.98000000000000009]
[null,0.43,0.9900000000000001]
[null,0.44,""]
[null,0.45,""]
[null,0.46,""]
[null,0.47,""]
[null,0.48,""]
[null,0.49,""]
[null,0.5,""]
[null,0.51,""]
[null,0.52,""]
[null,0.53,""]
[null,0.54,""]
[null,0.55000000000000004,""]
[null,0.56000000000000005,""]
[null,0.56999999999999995,""]
[null,0.57999999999999996,""]
[null,0.59,""]
[null,0.6,""]
[null,0.61,""]
[null,0.62,""]
[null,0.63,""]
[null,0.64,""]
[null,0.65,""]
[null,0.66,""]
[null,0.67,""]
[null,0.68,""]
[null,0.69,""]
[null,0.7,""]
[null,0.71,""]
[null,0.72,""]
[null,0.73,""]
[null,0.74,""]
[null,0.75,""]
[null,0.76,""]
[null,0.77,""]
[null,0.78,""]
[null,0.79,""]
[null,0.8,""]
[null,0.81,""]
[null,0.82,""]
[null,0.83,""]
[null,0.84,""]
[null,0.85,""]
[null,0.86,""]
[null,0.87000000000000099,""]
[null,0.880000000000001,""]
[null,0.89000000000000101,""]
[null,0.90000000000000102,""]
[null,0.91000000000000103,""]
[null,0.92000000000000104,""]
[null,0.93000000000000105,""]
[null,0.94000000000000095,""]
[null,0.95000000000000095,""]
[null,0.96000000000000096,{"$f":"IF(C68=\"\",\"\",IF(C68+0.01<=0.99,C68+0.01,\"\"))","v":""}]
[null,0.97000000000000097,{"$f":"IF(C69=\"\",\"\",IF(C69+0.01<=0.99,C69+0.01,\"\"))","v":""}]
[null,0.98000000000000098,{"$f":"IF(C70=\"\",\"\",IF(C70+0.01<=0.99,C70+0.01,\"\"))","v":""}]
[null,0.99000000000000099,{"$f":"IF(C71=\"\",\"\",IF(C71+0.01<=0.99,C71+0.01,\"\"))","v":""}]

{"sheet":"Berechnung1","index":1,"n_rows":29,"n_cols":5,"rows_kept":29,"cut":false,"hidden":true,"merged":[[33,3,33,4],[33,5,33,6],[33,7,33,8],[31,1,31,2],[32,1,32,2],[33,1,33,2],[31,3,31,4],[31,5,31,6],[31,7,31,8],[32,3,32,4],[32,5,32,6],[32,7,32,8]]}
[]
[]
["Zeilenbeschriftungen","Kunden ","Kunden in% ","Umsatz ","Umsatz in% "]
["A",22,0.18333333333333332,379931,0.84669006629895815]
["B",12,0.1,44544,9.9267925789737588E-2]
["C",86,0.71666666666666667,24250,5.404200791130425E-2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"IF(A4=\"(Leer)\",\"\",A4)","v":"A"},{"$f":"IF(B4=\"\",\"\",B4)","v":22},{"$f":"IF(B4=\"\",\"\",C4)","v":0.18333333333333332},{"$f":"IF(D4=\"\",\"\",D4)","v":379931},{"$f":"IF(D4=\"\",\"\",E4)","v":0.84669006629895815}]
[{"$f":"IF(A5=\"\",\"\",A5)","v":"B"},{"$f":"IF(B5=\"\",\"\",B5)","v":12},{"$f":"IF(C5=\"\",\"\",C5)","v":0.1},44544,9.9267925789737588E-2]
[{"$f":"IF(A6=\"\",\"\",A6)","v":"C"},{"$f":"IF(B6=\"\",\"\",B6)","v":86},{"$f":"IF(C6=\"\",\"\",C6)","v":0.71666666666666667},24250,5.404200791130425E-2]

{"sheet":"Berechnung2","index":2,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
[]
[null,{"$f":" ABC_Art_DB","v":"Kunden"},null,"Umsat in %"]
[null,"Mott",null,0.2451390049584935]
[null,"Arndt",null,0.10028413839211098]
[null,"Brinkmann",null,7.5770237896261625E-2]
[null,"Mertens",null,7.1313165078834478E-2]
[null,"Peters",null,4.4570728174271546E-2]
[null,"Meier",null,2.6742436904562929E-2]
[null,"Ganz",null,2.4761268037216559E-2]
[null,"Deck",null,2.0054599142013484E-2]
[null,"Müller",null,2.0050142069196055E-2]
[null,"Brucher",null,2.0047913532787343E-2]
[null,{"$f":" \"Restliche \" &ABC_Art_DB","v":"Restliche Kunden"},null,{"$f":"IF(SUM(D3:D12)=0,\"\",1-SUM(D3:D12))","v":0.35126636581425152}]

{"sheet":"Berechnung3","index":3,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Klasse","Wertanteil","Mengenanteil","Mengenanteil"]
[null,"A",0.84669006629895815,{"$f":"-1*E3","v":-0.18333333333333332},0.18333333333333332]
[null,"B",9.9267925789737588E-2,{"$f":"-1*E4","v":-0.1},0.1]
[null,"C",5.404200791130425E-2,{"$f":"-1*E5","v":-0.71666666666666667},0.71666666666666667]

{"sheet":"Dashboard","index":4,"n_rows":21,"n_cols":21,"rows_kept":21,"cut":false,"hidden":false,"merged":[[8,16,9,20]]}
[null,null,null,{"$f":"ABC_Art_DB & \" ABC-Analyse\"","v":"Kunden ABC-Analyse"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MeineVorlagen.com"]
[null,null,null,{"$f":"\"Berechnet nach \"&G13","v":"Berechnet nach Umsatz"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MeineVorlagen.com"]
[null,null,null,"Zeitraum:",null,null,"??.??.???? bis ??.??.????",null,null,null,null,null,null,null,null,null,null,null,null,null,"Musteradresse 16"]
[null,null,null,"Erstellt von: ",null,null,"Hans Muster",null,null,null,null,null,null,null,null,null,null,null,null,null,"9500 Wil (SG)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"www.meinevorlagen.com"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"info@meinevorlagen.com"]
[]
[]
[null,null,null,"ABC Art",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"\"Top 10 \" & ABC_Art_DB","v":"Top 10 Kunden"}]
[null,null,null,null,null,null,"Kunden",null,null,null,"Klasse","Kunden","in %","Umsatz","in %"]
[null,null,null,null,null,null,null,null,null,null,"A",22,0.18333333333333332,379931,0.84669006629895815]
[null,null,null,"Berechnungsart",null,null,null,null,null,null,"B",12,0.1,44544,9.9267925789737588E-2]
[null,null,null,null,null,"ABC nach","Umsatz",null,null,null,"C",86,0.71666666666666667,24250,5.404200791130425E-2]
[null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(L11:L13)","v":120},{"$f":"SUM(M11:M13)","v":1},{"$f":"SUM(N11:N13)","v":448725},{"$f":"SUM(O11:O13)","v":1}]
[null,null,null,"ABC Klassen"]
[null,null,null,null,null,"A - Klasse",0.85]
[null,null,null,null,null,"B - Klasse",0.95000000000000018]
[null,null,null,null,null,"C - Klasse",1]
[]
[null,null,null,"Währung"]
[null,null,null,null,null,null,"Euro"]

{"sheet":"Rohdaten","index":5,"n_rows":124,"n_cols":3,"rows_kept":124,"cut":false,"hidden":false,"merged":[]}
["Rohdaten"]
["Ein Musterdatensatz, zum testen des Tools, kann hier heruntergeladen werden:",null,"Musterdatensatz.xlsx"]
[]
["Kunden Nr.","Kunden","Umsatz"]
[1001,"Mott",110000]
[1002,"Peters",20000]
[1003,"Brinkmann",34000]
[1004,"Arndt",45000]
[1005,"Mertens",32000]
[1006,"Meier",12000]
[1007,"Kuhn",1]
[1008,"Deck",8999]
[1009,"Ganz",11111]
[1010,"Müller",8997]
[1011,"Brucher",8996]
[1012,"Höppner",5666]
[1013,"Hermanns",7998]
[1014,"Martinez",2422]
[1015,"Mager",7996]
[1016,"Hein",444]
[1017,"Heyl",7994]
[1018,"Frenzen",7992]
[1019,"Keil",7990]
[1020,"Schmitz",7988]
[1021,"Seifer",7986]
[1022,"Schäfer",2323]
[1023,"Hövel",7984]
[1024,"Brucherseifer",2]
[1025,"Gerfer",2323]
[1026,"Seifer",444]
[1027,"Witte",5900]
[1028,"Höppner",3]
[1029,"Wiemer",320]
[1030,"Heck",5700]
[1031,"Jamann",5500]
[1032,"Roth",5300]
[1033,"Deck",334]
[1034,"Köpke",6000]
[1035,"Mager",6500]
[1036,"Mertens",6300]
[1037,"Brinkmann",222]
[1038,"Hagen",333]
[1039,"Krämer",6100]
[1040,"Kuhn",2500]
[1041,"Wiemer",2300]
[1042,"Ganz",2100]
[1043,"Jamann",1900]
[1044,"Vitt",1700]
[1045,"Roth",1500]
[1046,"Höfig",1300]
[1047,"Müller",1100]
[1048,"Binder",900]
[1049,"Kolb",333]
[1050,"Heck",2300]
[1051,"Gatzmann",2310]
[1052,"Keil",2222]
[1053,"Brucher",44]
[1054,"Helt",980]
[1055,"Hagen",980]
[1056,"Hermanns",920]
[1057,"Peters",876]
[1058,"Krämer",150]
[1059,"Haber",150]
[1060,"Simon",150]
[1061,"Binder",13]
[1062,"Schäfer",150]
[1063,"Witte",150]
[1064,"Dunkel",150]
[1065,"Hecht",150]
[1066,"Schmitz",150]
[1067,"Hermanns",150]
[1068,"Deck",113]
[1069,"Deck",112]
[1070,"Deck",111]
[1071,"Deck",110]
[1072,"Deck",109]
[1073,"Deck",108]
[1074,"Deck",107]
[1075,"Deck",106]
[1076,"Deck",14]
[1077,"Deck",103]
[1078,"Deck",102]
[1079,"Deck",101]
[1080,"Deck",100]
[1081,"Deck",99]
[1082,"Deck",98]
[1083,"Deck",97]
[1084,"Deck",96]
[1085,"Deck",95]
[1086,"Deck",94]
[1087,"Deck",15]
[1088,"Deck",92]
[1089,"Deck",16]
[1090,"Deck",90]
[1091,"Deck",89]
[1092,"Deck",88]
[1093,"Deck",87]
[1094,"Deck",5]
[1095,"Deck",85]
[1096,"Deck",84]
[1097,"Deck",83]
[1098,"Deck",6]
[1099,"Deck",81]
[1100,"Deck",80]
[1101,"Deck",79]
[1102,"Deck",78]
[1103,"Hövel",60]
[1104,"Vitt",65]
[1105,"Gatzmann",7]
[1106,"Kolb",70]
[1107,"Driesch",75]
[1108,"Hein",80]
[1109,"Haber",8]
[1110,"Helt",85]
[1111,"Hermanns",90]
[1112,"Kleiber",9]
[1113,"Heyl",95]
[1114,"Mott",4]
[1115,"Dunkel",100]
[1116,"Frenzen",105]
[1117,"Hecht",10]
[1118,"Deck",110]
[1119,"Seiler",11]
[1120,"Leven",12]

{"sheet":"ABC-Analyse","index":6,"n_rows":129,"n_cols":10,"rows_kept":129,"cut":false,"hidden":false,"merged":[]}
["© Copyright by MeineVorlagen – www.MeineVorlagen.com - Alle Rechte vorbehalten"]
[]
[]
[{"$f":"ABC_Art_DB & \" ABC-Analyse\"","v":"Kunden ABC-Analyse"},null,null,null,null,null,null,null,"Klassen","Klassengrenzen [%] "]
[{"$f":"\"  \" &Dashboard!U2","v":"  MeineVorlagen.com"},null,null,null,null,null,null,null,"A",{"$f":"Dashboard!G16","v":0.85}]
[{"$f":"\"   \" &\"Erstellt von: \" & Dashboard!G4","v":"   Erstellt von: Hans Muster"},null,null,null,null,null,null,null,"B",{"$f":"Dashboard!G17","v":0.95000000000000018}]
[{"$f":"\"   \" &CONCATENATE(\"Druck: \",TEXT(TODAY(),\"TT.MM.JJ\"),\" um \",TEXT(NOW(),\"hh.mm\"))","v":"   Druck: 25.10.15 um 14.26"},null,null,null,null,null,null,null,"C",{"$f":"Dashboard!G18","v":1}]
[]
["Nr.","Kunden Nr.","Kunden","Umsatz","Rang","Wertanteil","Kum.Wertanteil","Anteil","Km.Anteil","ABC Klasse"]
[1,1001,"Mott",110000,1,0.2451390049584935,0.2451390049584935,8.3333333333333332E-3,8.3333333333333332E-3,"A"]
[2,1004,"Arndt",45000,2,0.10028413839211098,0.34542314335060448,8.3333333333333332E-3,1.6666666666666666E-2,"A"]
[3,1003,"Brinkmann",34000,3,7.5770237896261625E-2,0.42119338124686612,8.3333333333333332E-3,2.5000000000000001E-2,"A"]
[4,1005,"Mertens",32000,4,7.1313165078834478E-2,0.49250654632570057,8.3333333333333332E-3,3.3333333333333333E-2,"A"]
[5,1002,"Peters",20000,5,4.4570728174271546E-2,0.53707727449997211,8.3333333333333332E-3,4.1666666666666664E-2,"A"]
[6,1006,"Meier",12000,6,2.6742436904562929E-2,0.56381971140453502,8.3333333333333332E-3,4.9999999999999996E-2,"A"]
[7,1009,"Ganz",11111,7,2.4761268037216559E-2,0.58858097944175158,8.3333333333333332E-3,5.8333333333333327E-2,"A"]
[8,1008,"Deck",8999,8,2.0054599142013484E-2,0.60863557858376505,8.3333333333333332E-3,6.6666666666666666E-2,"A"]
[9,1010,"Müller",8997,9,2.0050142069196055E-2,0.62868572065296113,8.3333333333333332E-3,7.4999999999999997E-2,"A"]
[10,1011,"Brucher",8996,10,2.0047913532787343E-2,0.64873363418574848,8.3333333333333332E-3,8.3333333333333329E-2,"A"]
[11,1013,"Hermanns",7998,11,1.7823834196891191E-2,0.66655746838263963,8.3333333333333332E-3,9.166666666666666E-2,"A"]
[12,1015,"Mager",7996,12,1.7819377124073766E-2,0.6843768455067134,8.3333333333333332E-3,9.9999999999999992E-2,"A"]
[13,1017,"Heyl",7994,13,1.7814920051256337E-2,0.70219176555796969,8.3333333333333332E-3,0.10833333333333332,"A"]
[14,1018,"Frenzen",7992,14,1.7810462978438909E-2,0.72000222853640861,8.3333333333333332E-3,0.11666666666666665,"A"]
[15,1019,"Keil",7990,15,1.7806005905621484E-2,0.73780823444203014,8.3333333333333332E-3,0.12499999999999999,"A"]
[16,1020,"Schmitz",7988,16,1.7801548832804055E-2,0.75560978327483419,8.3333333333333332E-3,0.13333333333333333,"A"]
[17,1021,"Seifer",7986,17,1.779709175998663E-2,0.77340687503482086,8.3333333333333332E-3,0.14166666666666666,"A"]
[18,1023,"Hövel",7984,18,1.7792634687169202E-2,0.79119950972199005,8.3333333333333332E-3,0.15,"A"]
[19,1035,"Mager",6500,19,1.4485486656638253E-2,0.80568499637862834,8.3333333333333332E-3,0.15833333333333333,"A"]
[20,1036,"Mertens",6300,20,1.4039779374895537E-2,0.81972477575352387,8.3333333333333332E-3,0.16666666666666666,"A"]
[21,1039,"Krämer",6100,21,1.3594072093152823E-2,0.83331884784667665,8.3333333333333332E-3,0.17499999999999999,"A"]
[22,1034,"Köpke",6000,22,1.3371218452281465E-2,0.84669006629895815,8.3333333333333332E-3,0.18333333333333332,"A"]
[23,1027,"Witte",5900,23,1.3148364811410107E-2,0.85983843111036828,8.3333333333333332E-3,0.19166666666666665,"B"]
[24,1030,"Heck",5700,24,1.2702657529667391E-2,0.87254108864003566,8.3333333333333332E-3,0.19999999999999998,"B"]
[25,1012,"Höppner",5666,25,1.262688729177113E-2,0.88516797593180674,8.3333333333333332E-3,0.20833333333333331,"B"]
[26,1031,"Jamann",5500,26,1.2256950247924675E-2,0.89742492617973146,8.3333333333333332E-3,0.21666666666666665,"B"]
[27,1032,"Roth",5300,27,1.181124296618196E-2,0.90923616914591343,8.3333333333333332E-3,0.22499999999999998,"B"]
[28,1040,"Kuhn",2500,28,5.5713410217839432E-3,0.91480751016769735,8.3333333333333332E-3,0.23333333333333331,"B"]
[29,1014,"Martinez",2422,29,5.3975151819042845E-3,0.92020502534960158,8.3333333333333332E-3,0.24166666666666664,"B"]
[30,1022,"Schäfer",2323,30,5.1768900774416399E-3,0.92538191542704318,8.3333333333333332E-3,0.24999999999999997,"B"]
[31,1025,"Gerfer",2323,30,5.1768900774416399E-3,0.93055880550448478,8.3333333333333332E-3,0.2583333333333333,"B"]
[32,1051,"Gatzmann",2310,32,5.1479191041283638E-3,0.93570672460861315,8.3333333333333332E-3,0.26666666666666666,"B"]
[33,1041,"Wiemer",2300,33,5.125633740041228E-3,0.94083235834865442,8.3333333333333332E-3,0.27500000000000002,"B"]
[34,1050,"Heck",2300,33,5.125633740041228E-3,0.94595799208869569,8.3333333333333332E-3,0.28333333333333338,"B"]
[35,1052,"Keil",2222,35,4.9518079001615685E-3,0.95090979998885727,8.3333333333333332E-3,0.29166666666666674,"C"]
[36,1042,"Ganz",2100,36,4.679926458298512E-3,0.95558972644715579,8.3333333333333332E-3,0.3000000000000001,"C"]
[37,1043,"Jamann",1900,37,4.2342191765557969E-3,0.95982394562371154,8.3333333333333332E-3,0.30833333333333346,"C"]
[38,1044,"Vitt",1700,38,3.7885118948130813E-3,0.96361245751852465,8.3333333333333332E-3,0.31666666666666682,"C"]
[39,1045,"Roth",1500,39,3.3428046130703662E-3,0.96695526213159499,8.3333333333333332E-3,0.32500000000000018,"C"]
[40,1046,"Höfig",1300,40,2.8970973313276506E-3,0.9698523594629227,8.3333333333333332E-3,0.33333333333333354,"C"]
[41,1047,"Müller",1100,41,2.451390049584935E-3,0.97230374951250764,8.3333333333333332E-3,0.3416666666666669,"C"]
[42,1054,"Helt",980,42,2.1839656805393058E-3,0.974487715193047,8.3333333333333332E-3,0.35000000000000026,"C"]
[43,1055,"Hagen",980,42,2.1839656805393058E-3,0.97667168087358636,8.3333333333333332E-3,0.35833333333333361,"C"]
[44,1056,"Hermanns",920,44,2.050253496016491E-3,0.97872193436960286,8.3333333333333332E-3,0.36666666666666697,"C"]
[45,1048,"Binder",900,45,2.0056827678422194E-3,0.98072761713744505,8.3333333333333332E-3,0.37500000000000033,"C"]
[46,1057,"Peters",876,46,1.9521978940330938E-3,0.98267981503147817,8.3333333333333332E-3,0.38333333333333369,"C"]
[47,1016,"Hein",444,47,9.8947016546882842E-4,0.98366928519694696,8.3333333333333332E-3,0.39166666666666705,"C"]
[48,1026,"Seifer",444,47,9.8947016546882842E-4,0.98465875536241576,8.3333333333333332E-3,0.40000000000000041,"C"]
[49,1033,"Deck",334,49,7.4433116051033483E-4,0.98540308652292607,8.3333333333333332E-3,0.40833333333333377,"C"]
[50,1038,"Hagen",333,50,7.4210262410162131E-4,0.98614518914702765,8.3333333333333332E-3,0.41666666666666713,"C"]
[51,1049,"Kolb",333,50,7.4210262410162131E-4,0.98688729177112922,8.3333333333333332E-3,0.42500000000000049,"C"]
[52,1029,"Wiemer",320,52,7.1313165078834475E-4,0.98760042342191756,8.3333333333333332E-3,0.43333333333333385,"C"]
[53,1037,"Brinkmann",222,53,4.9473508273441421E-4,0.98809515850465202,8.3333333333333332E-3,0.44166666666666721,"C"]
[54,1058,"Krämer",150,54,3.3428046130703663E-4,0.98842943896595903,8.3333333333333332E-3,0.45000000000000057,"C"]
[55,1059,"Haber",150,54,3.3428046130703663E-4,0.98876371942726604,8.3333333333333332E-3,0.45833333333333393,"C"]
[56,1060,"Simon",150,54,3.3428046130703663E-4,0.98909799988857305,8.3333333333333332E-3,0.46666666666666728,"C"]
[57,1062,"Schäfer",150,54,3.3428046130703663E-4,0.98943228034988007,8.3333333333333332E-3,0.47500000000000064,"C"]
[58,1063,"Witte",150,54,3.3428046130703663E-4,0.98976656081118708,8.3333333333333332E-3,0.483333333333334,"C"]
[59,1064,"Dunkel",150,54,3.3428046130703663E-4,0.99010084127249409,8.3333333333333332E-3,0.49166666666666736,"C"]
[60,1065,"Hecht",150,54,3.3428046130703663E-4,0.9904351217338011,8.3333333333333332E-3,0.50000000000000067,"C"]
[61,1066,"Schmitz",150,54,3.3428046130703663E-4,0.99076940219510812,8.3333333333333332E-3,0.50833333333333397,"C"]
[62,1067,"Hermanns",150,54,3.3428046130703663E-4,0.99110368265641513,8.3333333333333332E-3,0.51666666666666727,"C"]
[63,1068,"Deck",113,63,2.5182461418463424E-4,0.99135550727059973,8.3333333333333332E-3,0.52500000000000058,"C"]
[64,1069,"Deck",112,64,2.4959607777592067E-4,0.9916051033483757,8.3333333333333332E-3,0.53333333333333388,"C"]
[65,1070,"Deck",111,65,2.473675413672071E-4,0.99185247088974293,8.3333333333333332E-3,0.54166666666666718,"C"]
[66,1071,"Deck",110,66,2.4513900495849353E-4,0.99209760989470142,8.3333333333333332E-3,0.55000000000000049,"C"]
[67,1118,"Deck",110,66,2.4513900495849353E-4,0.9923427488996599,8.3333333333333332E-3,0.55833333333333379,"C"]
[68,1072,"Deck",109,68,2.4291046854977994E-4,0.99258565936820964,8.3333333333333332E-3,0.5666666666666671,"C"]
[69,1073,"Deck",108,69,2.4068193214106634E-4,0.99282634130035075,8.3333333333333332E-3,0.5750000000000004,"C"]
[70,1074,"Deck",107,70,2.3845339573235277E-4,0.99306479469608311,8.3333333333333332E-3,0.5833333333333337,"C"]
[71,1075,"Deck",106,71,2.362248593236392E-4,0.99330101955540673,8.3333333333333332E-3,0.59166666666666701,"C"]
[72,1116,"Frenzen",105,72,2.3399632291492563E-4,0.9935350158783216,8.3333333333333332E-3,0.60000000000000031,"C"]
[73,1077,"Deck",103,73,2.2953925009749847E-4,0.9937645551284191,8.3333333333333332E-3,0.60833333333333361,"C"]
[74,1078,"Deck",102,74,2.273107136887849E-4,0.99399186584210786,8.3333333333333332E-3,0.61666666666666692,"C"]
[75,1079,"Deck",101,75,2.250821772800713E-4,0.99421694801938798,8.3333333333333332E-3,0.62500000000000022,"C"]
[76,1080,"Deck",100,76,2.2285364087135773E-4,0.99443980166025936,8.3333333333333332E-3,0.63333333333333353,"C"]
[77,1115,"Dunkel",100,76,2.2285364087135773E-4,0.99466265530113074,8.3333333333333332E-3,0.64166666666666683,"C"]
[78,1081,"Deck",99,78,2.2062510446264416E-4,0.99488328040559337,8.3333333333333332E-3,0.65000000000000013,"C"]
[79,1082,"Deck",98,79,2.1839656805393057E-4,0.99510167697364726,8.3333333333333332E-3,0.65833333333333344,"C"]
[80,1083,"Deck",97,80,2.16168031645217E-4,0.99531784500529252,8.3333333333333332E-3,0.66666666666666674,"C"]
[81,1084,"Deck",96,81,2.1393949523650343E-4,0.99553178450052904,8.3333333333333332E-3,0.67500000000000004,"C"]
[82,1085,"Deck",95,82,2.1171095882778986E-4,0.99574349545935681,8.3333333333333332E-3,0.68333333333333335,"C"]
[83,1113,"Heyl",95,82,2.1171095882778986E-4,0.99595520641818458,8.3333333333333332E-3,0.69166666666666665,"C"]
[84,1086,"Deck",94,84,2.0948242241907626E-4,0.99616468884060361,8.3333333333333332E-3,0.7,"C"]
[85,1088,"Deck",92,85,2.0502534960164913E-4,0.99636971419020526,8.3333333333333332E-3,0.70833333333333326,"C"]
[86,1090,"Deck",90,86,2.0056827678422196E-4,0.99657028246698953,8.3333333333333332E-3,0.71666666666666656,"C"]
[87,1111,"Hermanns",90,86,2.0056827678422196E-4,0.99677085074377381,8.3333333333333332E-3,0.72499999999999987,"C"]
[88,1091,"Deck",89,88,1.9833974037550839E-4,0.99696919048414934,8.3333333333333332E-3,0.73333333333333317,"C"]
[89,1092,"Deck",88,89,1.961112039667948E-4,0.99716530168811612,8.3333333333333332E-3,0.74166666666666647,"C"]
[90,1093,"Deck",87,90,1.9388266755808123E-4,0.99735918435567417,8.3333333333333332E-3,0.74999999999999978,"C"]
[91,1095,"Deck",85,91,1.8942559474065409E-4,0.99754860995041483,8.3333333333333332E-3,0.75833333333333308,"C"]
[92,1110,"Helt",85,91,1.8942559474065409E-4,0.9977380355451555,8.3333333333333332E-3,0.76666666666666639,"C"]
[93,1096,"Deck",84,93,1.8719705833194049E-4,0.99792523260348742,8.3333333333333332E-3,0.77499999999999969,"C"]
[94,1097,"Deck",83,94,1.8496852192322692E-4,0.9981102011254106,8.3333333333333332E-3,0.78333333333333299,"C"]
[95,1099,"Deck",81,95,1.8051144910579976E-4,0.9982907125745164,8.3333333333333332E-3,0.7916666666666663,"C"]
[96,1100,"Deck",80,96,1.7828291269708619E-4,0.99846899548721346,8.3333333333333332E-3,0.7999999999999996,"C"]
[97,1108,"Hein",80,96,1.7828291269708619E-4,0.99864727839991052,8.3333333333333332E-3,0.8083333333333329,"C"]
[98,1101,"Deck",79,98,1.7605437628837262E-4,0.99882333277619895,8.3333333333333332E-3,0.81666666666666621,"C"]
[99,1102,"Deck",78,99,1.7382583987965902E-4,0.99899715861607863,8.3333333333333332E-3,0.82499999999999951,"C"]
[100,1107,"Driesch",75,100,1.6714023065351831E-4,0.99916429884673219,8.3333333333333332E-3,0.83333333333333282,"C"]
[101,1106,"Kolb",70,101,1.5599754860995041E-4,0.99932029639534214,8.3333333333333332E-3,0.84166666666666612,"C"]
[102,1104,"Vitt",65,102,1.4485486656638254E-4,0.99946515126190849,8.3333333333333332E-3,0.84999999999999942,"C"]
[103,1103,"Hövel",60,103,1.3371218452281464E-4,0.99959886344643134,8.3333333333333332E-3,0.85833333333333273,"C"]
[104,1053,"Brucher",44,104,9.8055601983397398E-5,0.99969691904841473,8.3333333333333332E-3,0.86666666666666603,"C"]
[105,1089,"Deck",16,105,3.5656582539417236E-5,0.99973257563095419,8.3333333333333332E-3,0.87499999999999933,"C"]
[106,1087,"Deck",15,106,3.342804613070366E-5,0.9997660036770849,8.3333333333333332E-3,0.88333333333333264,"C"]
[107,1076,"Deck",14,107,3.1199509721990084E-5,0.99979720318680687,8.3333333333333332E-3,0.89166666666666594,"C"]
[108,1061,"Binder",13,108,2.8970973313276505E-5,0.9998261741601201,8.3333333333333332E-3,0.89999999999999925,"C"]
[109,1120,"Leven",12,109,2.6742436904562929E-5,0.99985291659702469,8.3333333333333332E-3,0.90833333333333255,"C"]
[110,1119,"Seiler",11,110,2.4513900495849349E-5,0.99987743049752054,8.3333333333333332E-3,0.91666666666666585,"C"]
[111,1117,"Hecht",10,111,2.2285364087135773E-5,0.99989971586160764,8.3333333333333332E-3,0.92499999999999916,"C"]
[112,1112,"Kleiber",9,112,2.0056827678422197E-5,0.99991977268928611,8.3333333333333332E-3,0.93333333333333246,"C"]
[113,1109,"Haber",8,113,1.7828291269708618E-5,0.99993760098055584,8.3333333333333332E-3,0.94166666666666576,"C"]
[114,1105,"Gatzmann",7,114,1.5599754860995042E-5,0.99995320073541683,8.3333333333333332E-3,0.94999999999999907,"C"]
[115,1098,"Deck",6,115,1.3371218452281464E-5,0.99996657195386907,8.3333333333333332E-3,0.95833333333333237,"C"]
[116,1094,"Deck",5,116,1.1142682043567887E-5,0.99997771463591267,8.3333333333333332E-3,0.96666666666666567,"C"]
[117,1114,"Mott",4,117,8.914145634854309E-6,0.99998662878154754,8.3333333333333332E-3,0.97499999999999898,"C"]
[118,1028,"Höppner",3,118,6.6856092261407322E-6,0.99999331439077366,8.3333333333333332E-3,0.98333333333333228,"C"]
[119,1024,"Brucherseifer",2,119,4.4570728174271545E-6,0.99999777146359103,8.3333333333333332E-3,0.99166666666666559,"C"]
[120,1007,"Kuhn",1,120,2.2285364087135773E-6,0.99999999999999978,8.3333333333333332E-3,0.99999999999999889,"C"]

{"sheet":"Rapport","index":7,"n_rows":54,"n_cols":8,"rows_kept":54,"cut":false,"hidden":false,"merged":[[51,0,51,2],[49,3,49,4],[51,3,51,4],[38,0,38,2],[39,0,39,2],[40,0,40,2],[41,0,41,2],[42,0,42,2],[43,0,43,2],[43,3,43,4],[44,3,44,4],[45,3,45,4],[46,3,46,4],[49,0,49,2],[46,0,46,2],[47,0,47,2],[53,0,53,9],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[8,5,8,6],[47,3,47,4],[48,3,48,4],[38,3,38,4],[39,3,39,4],[40,3,40,4],[41,3,41,4],[42,3,42,4],[8,7,8,8],[9,7,9,8],[48,0,48,2],[8,1,8,2],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[44,0,44,2],[45,0,45,2],[1,0,1,9],[0,0,0,9],[10,5,10,6],[11,5,11,6],[12,5,12,6],[9,5,9,6],[10,7,10,8],[11,7,11,8],[12,7,12,8],[2,7,2,9]]}
["© Copyright by MeineVorlagen – www.MeineVorlagen.com - Alle Rechte vorbehalten"]
[{"$f":"CONCATENATE(\"    Druck: \",TEXT(TODAY(),\"TT.MM.JJ\"),\" um \",TEXT(NOW(),\"hh.mm\"))","v":"    Druck: 25.10.15 um 14.26"}]
[{"$f":"ABC_Art_DB & \" ABC-Analyse\"","v":"Kunden ABC-Analyse"},null,null,null,null,null,"Betrachtungszeitraum:",{"$f":"Dashboard!G3","v":"??.??.???? bis ??.??.????"}]
[{"$f":"Dashboard!U1","v":"MeineVorlagen.com"}]
[{"$f":"\"Erstellt von: \" & Dashboard!G4","v":"Erstellt von: Hans Muster"}]
[]
["Wertanteil in Abhängigkeit zum Mengenanteil"]
[]
["Klasse","Kunden",null,"in %",null,"Umsatz",null," in %"]
["A",22,null,0.18333333333333332,null,379931,null,0.84669006629895815]
["B",12,null,0.1,null,44544,null,9.9267925789737588E-2]
["C",86,null,0.71666666666666667,null,24250,null,5.404200791130425E-2]
["Total",{"$f":"SUM(B10:C12)","v":120},null,{"$f":"SUM(D10:E12)","v":1},null,{"$f":"SUM(F10:G12)","v":448725},null,{"$f":"SUM(H10:I12)","v":1}]
[]
["Wertanteil vs. Mengenanteil"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"\"Top 10 \" & ABC_Art_DB","v":"Top 10 Kunden"}]
[]
["Kunden",null,null,"Umsatz"]
["Mott",null,null,110000,null,0.2451390049584935]
["Arndt",null,null,45000,null,0.10028413839211098]
["Brinkmann",null,null,34000,null,7.5770237896261625E-2]
["Mertens",null,null,32000,null,7.1313165078834478E-2]
["Peters",null,null,20000,null,4.4570728174271546E-2]
["Meier",null,null,12000,null,2.6742436904562929E-2]
["Ganz",null,null,11111,null,2.4761268037216559E-2]
["Deck",null,null,8999,null,2.0054599142013484E-2]
["Müller",null,null,8997,null,2.0050142069196055E-2]
["Brucher",null,null,8996,null,2.0047913532787343E-2]
[{"$f":"\"Total Top 10 \"  & ABC_Art_DB","v":"Total Top 10 Kunden"},null,null,{"$f":"SUM(D40:E49)","v":291103},null,{"$f":"SUM(F40:F49)","v":0.64873363418574848}]
[]
[{"$f":"\"Restliche \"  & ABC_Art_DB","v":"Restliche Kunden"},null,null,{"$f":"SUM('ABC-Analyse'!D10:D900000)-D50","v":157622},null,{"$f":"1-F50","v":0.35126636581425152}]
[]
["© Copyright by MeineVorlagen – www.MeineVorlagen.com - Alle Rechte vorbehalten"]