{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Eingabe","Berechnungen","Grafik1","Grafik2"],"not_rendered":{"charts":2,"images":3,"macros":1,"external_links":0,"defined_names":0,"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":"Eingabe","index":0,"n_rows":29,"n_cols":8,"rows_kept":29,"cut":false,"hidden":false,"merged":[[9,3,11,7],[16,1,28,1],[1,1,1,7],[16,2,18,2],[16,3,18,3],[16,4,18,4],[16,5,18,5],[16,6,18,6],[16,7,18,7],[3,3,5,7],[6,3,8,7]]}
[]
[null,"ABC-Analyse (Absatzanalyse)"]
[]
[null,null,null,"Nach Klick auf \"Eingabe\" können bis zu 20 Produkte, deren Verkaufspreis und Verkaufsmengen eingeben werden. (Die Anwendung kann zur Eingabe weiterer Produkte erweitert werden)"]
[]
[]
[null,null,null,"Nack Klick auf \"Klassifzierung\" können die für die Zurordnung zu den Güterklassen A, B und C maßgeblichen Prozentsätze eingegeben werden."]
[]
[]
[null,null,null,"Nach Klick auf \"Analyse\" werden die kumulierten Mengen- und Wertanteile der Produkte ermittelt und die Einstufung in die Klassen A,B und C vorgenommen."]
[]
[]
[]
[]
[]
[]
[null,"A-Güter mit dem größten prozentualen Wertanteil am Gesamtumsatz","Produkte","Nettopreis","Verkaufs- mengen","Verkaufswert","Mengen- anteil      in %","Wert- anteil    in %"]
[]
[]
[null,null,{"$f":"IF(Berechnungen!K12=\"A\",Berechnungen!C12,\"\")","v":"Jeans 002"},{"$f":"IF(Berechnungen!K12=\"A\",Berechnungen!D12,\"\")","v":80},{"$f":"IF(Berechnungen!K12=\"A\",Berechnungen!E12,\"\")","v":5200},{"$f":"IF(Berechnungen!K12=\"A\",Berechnungen!F12,\"\")","v":416000},{"$f":"IF(Berechnungen!K12=\"A\",Berechnungen!G12,\"\")","v":0.12839506172839507},{"$f":"IF(Berechnungen!K12=\"A\",Berechnungen!H12,\"\")","v":0.20454824830977258}]
[null,null,{"$f":"IF(Berechnungen!K13=\"A\",Berechnungen!C13,\"\")","v":"Jeans 001"},{"$f":"IF(Berechnungen!K13=\"A\",Berechnungen!D13,\"\")","v":70},{"$f":"IF(Berechnungen!K13=\"A\",Berechnungen!E13,\"\")","v":4800},{"$f":"IF(Berechnungen!K13=\"A\",Berechnungen!F13,\"\")","v":336000},{"$f":"IF(Berechnungen!K13=\"A\",Berechnungen!G13,\"\")","v":0.11851851851851852},{"$f":"IF(Berechnungen!K13=\"A\",Berechnungen!H13,\"\")","v":0.16521204671173939}]
[null,null,{"$f":"IF(Berechnungen!K14=\"A\",Berechnungen!C14,\"\")","v":"Jeansjacke"},{"$f":"IF(Berechnungen!K14=\"A\",Berechnungen!D14,\"\")","v":90},{"$f":"IF(Berechnungen!K14=\"A\",Berechnungen!E14,\"\")","v":1600},{"$f":"IF(Berechnungen!K14=\"A\",Berechnungen!F14,\"\")","v":144000},{"$f":"IF(Berechnungen!K14=\"A\",Berechnungen!G14,\"\")","v":3.9506172839506172E-2},{"$f":"IF(Berechnungen!K14=\"A\",Berechnungen!H14,\"\")","v":7.0805162876459743E-2}]
[null,null,{"$f":"IF(Berechnungen!K15=\"A\",Berechnungen!C15,\"\")","v":"Armbanduhr \"Trophy\""},{"$f":"IF(Berechnungen!K15=\"A\",Berechnungen!D15,\"\")","v":265},{"$f":"IF(Berechnungen!K15=\"A\",Berechnungen!E15,\"\")","v":500},{"$f":"IF(Berechnungen!K15=\"A\",Berechnungen!F15,\"\")","v":132500},{"$f":"IF(Berechnungen!K15=\"A\",Berechnungen!G15,\"\")","v":1.2345679012345678E-2},{"$f":"IF(Berechnungen!K15=\"A\",Berechnungen!H15,\"\")","v":6.515058389674247E-2}]
[null,null,{"$f":"IF(Berechnungen!K16=\"A\",Berechnungen!C16,\"\")","v":"Trainingsanzug"},{"$f":"IF(Berechnungen!K16=\"A\",Berechnungen!D16,\"\")","v":110},{"$f":"IF(Berechnungen!K16=\"A\",Berechnungen!E16,\"\")","v":1000},{"$f":"IF(Berechnungen!K16=\"A\",Berechnungen!F16,\"\")","v":110000},{"$f":"IF(Berechnungen!K16=\"A\",Berechnungen!G16,\"\")","v":2.4691358024691357E-2},{"$f":"IF(Berechnungen!K16=\"A\",Berechnungen!H16,\"\")","v":5.4087277197295634E-2}]
[null,null,{"$f":"IF(Berechnungen!K17=\"A\",Berechnungen!C17,\"\")","v":"Partykleid"},{"$f":"IF(Berechnungen!K17=\"A\",Berechnungen!D17,\"\")","v":80},{"$f":"IF(Berechnungen!K17=\"A\",Berechnungen!E17,\"\")","v":1100},{"$f":"IF(Berechnungen!K17=\"A\",Berechnungen!F17,\"\")","v":88000},{"$f":"IF(Berechnungen!K17=\"A\",Berechnungen!G17,\"\")","v":2.7160493827160494E-2},{"$f":"IF(Berechnungen!K17=\"A\",Berechnungen!H17,\"\")","v":4.3269821757836509E-2}]
[null,null,{"$f":"IF(Berechnungen!K18=\"A\",Berechnungen!C18,\"\")","v":"Badeanzug"},{"$f":"IF(Berechnungen!K18=\"A\",Berechnungen!D18,\"\")","v":65},{"$f":"IF(Berechnungen!K18=\"A\",Berechnungen!E18,\"\")","v":1200},{"$f":"IF(Berechnungen!K18=\"A\",Berechnungen!F18,\"\")","v":78000},{"$f":"IF(Berechnungen!K18=\"A\",Berechnungen!G18,\"\")","v":2.9629629629629631E-2},{"$f":"IF(Berechnungen!K18=\"A\",Berechnungen!H18,\"\")","v":3.835279655808236E-2}]
[null,null,{"$f":"IF(Berechnungen!K19=\"A\",Berechnungen!C19,\"\")","v":"T-Shirt 001"},{"$f":"IF(Berechnungen!K19=\"A\",Berechnungen!D19,\"\")","v":25},{"$f":"IF(Berechnungen!K19=\"A\",Berechnungen!E19,\"\")","v":3000},{"$f":"IF(Berechnungen!K19=\"A\",Berechnungen!F19,\"\")","v":75000},{"$f":"IF(Berechnungen!K19=\"A\",Berechnungen!G19,\"\")","v":7.407407407407407E-2},{"$f":"IF(Berechnungen!K19=\"A\",Berechnungen!H19,\"\")","v":3.6877688998156119E-2}]
[null,null,{"$f":"IF(Berechnungen!K20=\"A\",Berechnungen!C20,\"\")","v":""},{"$f":"IF(Berechnungen!K20=\"A\",Berechnungen!D20,\"\")","v":""},{"$f":"IF(Berechnungen!K20=\"A\",Berechnungen!E20,\"\")","v":""},{"$f":"IF(Berechnungen!K20=\"A\",Berechnungen!F20,\"\")","v":""},{"$f":"IF(Berechnungen!K20=\"A\",Berechnungen!G20,\"\")","v":""},{"$f":"IF(Berechnungen!K20=\"A\",Berechnungen!H20,\"\")","v":""}]
[null,null,{"$f":"IF(Berechnungen!K21=\"A\",Berechnungen!C21,\"\")","v":""},{"$f":"IF(Berechnungen!K21=\"A\",Berechnungen!D21,\"\")","v":""},{"$f":"IF(Berechnungen!K21=\"A\",Berechnungen!E21,\"\")","v":""},{"$f":"IF(Berechnungen!K21=\"A\",Berechnungen!F21,\"\")","v":""},{"$f":"IF(Berechnungen!K21=\"A\",Berechnungen!G21,\"\")","v":""},{"$f":"IF(Berechnungen!K21=\"A\",Berechnungen!H21,\"\")","v":""}]

{"sheet":"Berechnungen","index":1,"n_rows":37,"n_cols":11,"rows_kept":37,"cut":false,"hidden":false,"merged":[[7,1,9,1],[7,9,9,9],[7,2,9,2],[1,3,2,4],[1,5,1,10],[7,10,9,10],[7,3,9,3],[7,4,9,4],[7,5,9,5],[7,6,9,6],[7,7,9,7],[7,8,9,8]]}
[]
[null,null,null,"kumulierter Wertanteil bis ",null,"ABC-Analyse (Berechnungen)"]
[null,null,"Güterklasse"]
[null,null,"A",70,{"$f":"D4%","v":0.7}]
[null,null,"B",20,{"$f":"D5%","v":0.2}]
[null,null,"C",10,{"$f":"D6%","v":0.1}]
[]
[null,"Rang- platz","Produkte","Nettopreis","Verkaufs- mengen","Verkaufswert","Mengen- anteil      in %","Wert- anteil    in %","kumulierter Mengenanteil    in %","kumulierter Wertanteil     in %","Einstufung"]
[]
[]
[]
[null,{"$f":"IF(C12=\"\",\"\",B11+1)","v":1},"Jeans 002",80,5200,{"$f":"IF(C12=\"\",\"\",D12*E12)","v":416000},{"$f":"IF(C12=\"\",\"\",E12/$E$37)","v":0.12839506172839507},{"$f":"IF(C12=\"\",0,F12/$F$37)","v":0.20454824830977258},{"$f":"IF(C12=\"\",\"\",I11+G12)","v":0.12839506172839507},{"$f":"IF(C12=\"\",\"\",J11+H12)","v":0.20454824830977258},{"$f":"IF(C12=\"\",\"\",IF(J12<$E$4,\"A\",IF(J12<($E$4+$E$5),\"B\",\"C\")))","v":"A"}]
[null,{"$f":"IF(C13=\"\",\"\",B12+1)","v":2},"Jeans 001",70,4800,336000,0.11851851851851852,0.16521204671173939,0.24691358024691359,0.36976029502151198,"A"]
[null,3,"Jeansjacke",90,1600,144000,3.9506172839506172E-2,7.0805162876459743E-2,0.28641975308641976,0.44056545789797175,"A"]
[null,4,"Armbanduhr \"Trophy\"",265,500,132500,1.2345679012345678E-2,6.515058389674247E-2,0.29876543209876544,0.50571604179471419,"A"]
[null,5,"Trainingsanzug",110,1000,110000,2.4691358024691357E-2,5.4087277197295634E-2,0.32345679012345679,0.55980331899200986,"A"]
[null,6,"Partykleid",80,1100,88000,2.7160493827160494E-2,4.3269821757836509E-2,0.35061728395061731,0.60307314074984641,"A"]
[null,7,"Badeanzug",65,1200,78000,2.9629629629629631E-2,3.835279655808236E-2,0.38024691358024693,0.64142593730792874,"A"]
[null,8,"T-Shirt 001",25,3000,75000,7.407407407407407E-2,3.6877688998156119E-2,0.454320987654321,0.67830362630608487,"A"]
[null,9,"Bikini",55,1300,71500,3.2098765432098768E-2,3.5156730178242161E-2,0.48641975308641977,0.71346035648432704,"B"]
[null,10,"Polohemd",40,1700,68000,4.1975308641975309E-2,3.343577135832821E-2,0.52839506172839512,0.74689612784265524,"B"]
[null,11,"Sweatshirt",60,1100,66000,2.7160493827160494E-2,3.2452366318377383E-2,0.55555555555555558,0.77934849416103258,"B"]
[null,12,"Strohhut \"Blues\"",10,5000,50000,0.12345679012345678,2.4585125998770743E-2,0.67901234567901236,0.8039336201598033,"B"]
[null,13,"Rippkleid",70,700,49000,1.7283950617283949E-2,2.4093423478795329E-2,0.6962962962962963,0.82802704363859858,"B"]
[null,14,"Sandale ",60,800,48000,1.9753086419753086E-2,2.3601720958819915E-2,0.71604938271604934,0.85162876459741854,"B"]
[null,15,"Sonnenbrille \"Florida\"",44.5,1000,44500,2.4691358024691357E-2,2.1880762138905961E-2,0.7407407407407407,0.87350952673632454,"B"]
[null,16,"Hemd \"Climatech\"",60,700,42000,1.7283950617283949E-2,2.0651505838967424E-2,0.75802469135802464,0.894161032575292,"B"]
[null,17,"Rippenshirt",40,900,36000,2.2222222222222223E-2,1.7701290719114936E-2,0.78024691358024689,0.91186232329440697,"C"]
[null,18,"Laufschuhe \"Runner\"",150,200,30000,4.9382716049382715E-3,1.4751075599262446E-2,0.78518518518518521,0.92661339889366945,"C"]
[null,19,"Hemd \"Honolulu\"",50,600,30000,1.4814814814814815E-2,1.4751075599262446E-2,0.8,0.94136447449293192,"C"]
[null,20,"Baseball Cap \"Miami\"",5,5000,25000,0.12345679012345678,1.2292562999385371E-2,0.92345679012345683,0.95365703749231734,"C"]
[null,21,"Badehose",30,800,24000,1.9753086419753086E-2,1.1800860479409958E-2,0.94320987654320987,0.96545789797172732,"C"]
[null,22,"Laufhose \"Night Run\"",65,350,22750,8.6419753086419745E-3,1.1186232329440689E-2,0.95185185185185184,0.97664413030116803,"C"]
[null,23,"Halstuch \"Tropical Wind\"",25,750,18750,1.8518518518518517E-2,9.2194222495390298E-3,0.97037037037037033,0.98586355255070701,"C"]
[null,24,"Gürtel",25,700,17500,1.7283950617283949E-2,8.6047940995697611E-3,0.98765432098765427,0.99446834665027672,"C"]
[null,25,"Regenschirm \"Tropic Rain\"",22.5,500,11250,1.2345679012345678E-2,5.531653349723417E-3,1,1.0000000000000002,"C"]
[null,null,null,null,{"$f":"SUM(E12:E36)","v":40500},{"$f":"SUM(F12:F36)","v":2033750},{"$f":"SUM(G12:G36)","v":1},{"$f":"SUM(H12:H36)","v":1.0000000000000002}]

{"sheet":"Grafik1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Grafik2","index":3,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}