{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Eingabe","Berechnungen","Grafik1"],"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":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[6,3,8,7],[12,4,14,4],[9,3,11,7],[1,1,1,7],[12,3,14,3],[12,5,14,5],[12,6,14,6],[12,7,14,7],[3,3,5,7]]}
[]
[null,"ABC-Analyse (Materialwirtschaft)"]
[]
[null,null,null,"Nach Klick auf \"Eingabe\" können bis zu 20 Güter, deren Einkaufspreise und Verbrauchsmengen 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 Güter ermittelt und die Einstufung in die Klassen A,B und C vorgenommen."]
[]
[]
[null,null,null,"Güterklassen","Wert- bereiche","Güteranzahl je Klasse","Mengen- anteile je Güterklasse","Wertanteil je Güterklasse"]
[]
[]
[null,null,null,"A",{"$f":"Berechnungen!E4","v":0.7},{"$f":"COUNTIF(Berechnungen!K12:K36,\"A\")","v":10},{"$f":"Berechnungen!N37","v":0.31640625},{"$f":"Berechnungen!M37","v":0.69142249298907255}]
[null,null,null,"B",{"$f":"Berechnungen!E5","v":0.2},{"$f":"COUNTIF(Berechnungen!K12:K36,\"B\")","v":6},{"$f":"Berechnungen!P37","v":0.21875},{"$f":"Berechnungen!O37","v":0.19533894207523447}]
[null,null,null,"C",{"$f":"Berechnungen!E6","v":0.1},{"$f":"COUNTIF(Berechnungen!K12:K36,\"C\")","v":9},{"$f":"Berechnungen!R37","v":0.46484375},{"$f":"Berechnungen!Q37","v":0.11323856493569287}]

{"sheet":"Berechnungen","index":1,"n_rows":45,"n_cols":18,"rows_kept":45,"cut":false,"hidden":false,"merged":[[7,1,9,1],[7,9,9,9],[7,2,9,2],[1,3,2,4],[7,10,9,10],[7,3,9,3],[7,4,9,4],[1,5,2,10],[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,null,null,null,null,null,null,null,null,null,null,null,"Wertanteil","Mengenanteil","Wertanteil","Mengenanteil","Wertanteil","Mengenanteil"]
[null,null,null,null,null,null,null,null,null,null,null,null,"der A-Güter","der A-Güter","der B-Güter","der B-Güter","fder C-Güter","der C-Güter"]
[]
[null,{"$f":"IF(C12=\"\",\"\",B11+1)","v":1},"Schaltgruppe X",80,350,{"$f":"IF(C12=\"\",\"\",D12*E12)","v":28000},{"$f":"IF(C12=\"\",\"\",E12/$E$37)","v":2.734375E-2},{"$f":"IF(C12=\"\",0,F12/$F$37)","v":0.13538342520065758},{"$f":"IF(C12=\"\",\"\",I11+G12)","v":2.734375E-2},{"$f":"IF(C12=\"\",\"\",J11+H12)","v":0.13538342520065758},{"$f":"IF(C12=\"\",\"\",IF(J12<$E$4,\"A\",IF(J12<($E$4+$E$5),\"B\",\"C\")))","v":"A"},null,{"$f":"IF(K12=\"A\",H12,\"\")","v":0.13538342520065758},{"$f":"IF(K12=\"A\",G12,\"\")","v":2.734375E-2},{"$f":"IF(K12=\"B\",H12,\"\")","v":""},{"$f":"IF(K12=\"B\",G12,\"\")","v":""},{"$f":"IF(K12=\"C\",H12,\"\")","v":""},{"$f":"IF(K12=\"C\",G12,\"\")","v":""}]
[null,{"$f":"IF(C13=\"\",\"\",B12+1)","v":2},"Bremshebel",20,800,16000,6.25E-2,7.7361957257518613E-2,8.984375E-2,0.2127453824581762,"A",null,{"$f":"IF(K13=\"A\",H13,\"\")","v":7.7361957257518613E-2},{"$f":"IF(K13=\"A\",G13,\"\")","v":6.25E-2},{"$f":"IF(K13=\"B\",H13,\"\")","v":""},{"$f":"IF(K13=\"B\",G13,\"\")","v":""},{"$f":"IF(K13=\"C\",H13,\"\")","v":""},{"$f":"IF(K13=\"C\",G13,\"\")","v":""}]
[null,3,"Laufräder (Hohlkammer)",45,350,15750,2.734375E-2,7.6153176675369888E-2,0.1171875,0.28889855913354612,"A",null,7.6153176675369888E-2,2.734375E-2,"","","",""]
[null,4,"Schalgruppe A",55,250,13750,1.953125E-2,6.6482932018180063E-2,0.13671875,0.35538149115172618,"A",null,6.6482932018180063E-2,1.953125E-2,"","","",""]
[null,5,"Rahmen CroMo",40,300,12000,2.34375E-2,5.8021467943138963E-2,0.16015625,0.41340295909486513,"A",null,5.8021467943138963E-2,2.34375E-2,"","","",""]
[null,6,"Kette",15,800,12000,6.25E-2,5.8021467943138963E-2,0.22265625,0.47142442703800408,"A",null,5.8021467943138963E-2,6.25E-2,"","","",""]
[null,7,"Sattel ",20,600,12000,4.6875E-2,5.8021467943138963E-2,0.26953125,0.52944589498114303,"A",null,5.8021467943138963E-2,4.6875E-2,"","","",""]
[null,8,"Lenker (Trekking)",45,250,11250,1.953125E-2,5.4395126196692775E-2,0.2890625,0.58384102117783576,"A",null,5.4395126196692775E-2,1.953125E-2,"","","",""]
[null,9,"Schaltgruppe L",75,150,11250,1.171875E-2,5.4395126196692775E-2,0.30078125,0.6382361473745285,"A",null,5.4395126196692775E-2,1.171875E-2,"","","",""]
[null,10,"Rahmen Aluminium",55,200,11000,1.5625E-2,5.3186345614544051E-2,0.31640625,0.69142249298907255,"A",null,5.3186345614544051E-2,1.5625E-2,"","","",""]
[null,11,"Beleuchtungsgruppe",10,900,9000,7.03125E-2,4.3516100957354219E-2,0.38671875,0.7349385939464268,"B",null,"","",4.3516100957354219E-2,7.03125E-2,"",""]
[null,12,"Lenker (Rennen)",35,200,7000,1.5625E-2,3.3845856300164394E-2,0.40234375,0.76878445024659114,"B",null,"","",3.3845856300164394E-2,1.5625E-2,"",""]
[null,13,"Sattel Leder",35,200,7000,1.5625E-2,3.3845856300164394E-2,0.41796875,0.80263030654675549,"B",null,"","",3.3845856300164394E-2,1.5625E-2,"",""]
[null,14,"Laufräder ",30,200,6000,1.5625E-2,2.9010733971569481E-2,0.43359375,0.83164104051832499,"B",null,"","",2.9010733971569481E-2,1.5625E-2,"",""]
[null,15,"Bremsen V-Brake",15,400,6000,3.125E-2,2.9010733971569481E-2,0.46484375,0.86065177448989449,"B",null,"","",2.9010733971569481E-2,3.125E-2,"",""]
[null,16,"Pedale",6,900,5400,7.03125E-2,2.6109660574412531E-2,0.53515625,0.88676143506430705,"B",null,"","",2.6109660574412531E-2,7.03125E-2,"",""]
[null,17,"Steuersätze",6,700,4200,5.46875E-2,2.0307513780098638E-2,0.58984375,0.9070689488444057,"C",null,"","","","",2.0307513780098638E-2,5.46875E-2]
[null,18,"Decken ",5,800,4000,6.25E-2,1.9340489314379653E-2,0.65234375,0.9264094381587854,"C",null,"","","","",1.9340489314379653E-2,6.25E-2]
[null,19,"Schutzbleche",8,500,4000,3.90625E-2,1.9340489314379653E-2,0.69140625,0.94574992747316511,"C",null,"","","","",1.9340489314379653E-2,3.90625E-2]
[null,20,"Lenker (Mountain)",35,100,3500,7.8125E-3,1.6922928150082197E-2,0.69921875,0.96267285562324734,"C",null,"","","","",1.6922928150082197E-2,7.8125E-3]
[null,21,"Schläuche",3,900,2700,7.03125E-2,1.3054830287206266E-2,0.76953125,0.97572768591045356,"C",null,"","","","",1.3054830287206266E-2,7.03125E-2]
[null,22,"Bremsen U-Brake",10,250,2500,1.953125E-2,1.2087805821487283E-2,0.7890625,0.98781549173194083,"C",null,"","","","",1.2087805821487283E-2,1.953125E-2]
[null,23,"Griffe",2,1000,2000,7.8125E-2,9.6702446571898266E-3,0.8671875,0.99748573638913063,"C",null,"","","","",9.6702446571898266E-3,7.8125E-2]
[null,24,"Dekor",0.4,900,360,7.03125E-2,1.7406440382941688E-3,0.9375,0.99922638042742484,"C",null,"","","","",1.7406440382941688E-3,7.03125E-2]
[null,25,"Felgenbänder",0.2,800,160,6.25E-2,7.7361957257518618E-4,1,1,"C",null,"","","","",7.7361957257518618E-4,6.25E-2]
[null,null,null,null,{"$f":"SUM(E12:E36)","v":12800},{"$f":"SUM(F12:F36)","v":206820},{"$f":"SUM(G12:G36)","v":1},{"$f":"SUM(H12:H36)","v":1},null,null,null,null,{"$f":"SUM(M12:M36)","v":0.69142249298907255},0.31640625,0.19533894207523447,0.21875,0.11323856493569287,0.46484375]
[]
[null,"Berechnungen für Grafik: Spalten M-R",null,null,null,null,null,null,null,null,null,null,"kumulierte","kumulierte"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Mengenanteile","Wertanteile",null,"Güterklassen","Mengenanteile","Wertanteile"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,0,0,null,"A",{"$f":"N37","v":0.31640625},{"$f":"M37","v":0.69142249298907255}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M42+N37","v":0.31640625},{"$f":"N42+M37","v":0.69142249298907255},null,"B",{"$f":"P37","v":0.21875},{"$f":"O37","v":0.19533894207523447}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M43+P37","v":0.53515625},{"$f":"N43+O37","v":0.88676143506430705},null,"C",{"$f":"R37","v":0.46484375},{"$f":"Q37","v":0.11323856493569287}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M44+R37","v":1},{"$f":"N44+Q37","v":0.99999999999999989}]

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