{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Dateneingabe","ABC-Analyse","Auswertung grafisch"],"not_rendered":{"charts":3,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Dateneingabe","index":0,"n_rows":22,"n_cols":29,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["lfd Nr","Bezeichnung","Wert","Menge",null,null,"Staffelung","kumulativ"]
[0,"Möbelstück","Einkaufspreis","Anzahl",null,null,0.65,{"$f":"G2","v":0.65},{"$f":"H2","v":0.65},{"$f":"I2","v":0.65},0.65,0.65,0.65,0.65,0.65,0.65,0.65,0.65,0.65,0.65,0.65,0.65,0.65,0.65,0.65,{"$f":"Y2","v":0.65},0.65,0.65,0.65]
[1,"Bürostuhl",241,10,null,null,0.25,{"$f":"H2+G3","v":0.9},{"$f":"H3","v":0.9},0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9]
[2,"Beistellstuhlerl",83,17,null,null,0.1,{"$f":"H3+G4","v":1},1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1]
[3,"Tisch",443,20,null,null,null,{"$f":"IF(H4<>1,\"ö\",\"\")","v":""}]
[4,"Container",299,32,null,null,{"$f":"IF(H4<>1,\"Die Summe der Staffelung muss 100% ergeben!\",\"\")","v":""}]
[5,"Hängeschrank",125,5]
[6,"PC-Ansatz",77,72]
[7,"Besprechungstisch",336,36]
[8,"Flügeltürschrank 80 cm",579,54]
[9,"Flügeltürschrank 100 cm",679,33]
[10,"Flügeltürschrank 120 cm",779,17]
[11,"Sideboard",337,69]
[12,"Besprechungsstuhl",90,59]
[13,"Chefsessel",721,36]
[14,"Standcontainer",333,43]
[15,"Bild",23,65]
[16,"Unterschrank",266,24]
[17,"Verkettung",17,55]
[18,"Ansatzplatte rund",76,18]
[19,"Ansatzplatte eckig",59,74]
[20,"Ansatzplatte oval",112,42]

{"sheet":"ABC-Analyse","index":1,"n_rows":25,"n_cols":12,"rows_kept":25,"cut":false,"hidden":true,"merged":[]}
[]
[null,{"$f":"Dateneingabe!B2","v":"Möbelstück"},{"$f":"Dateneingabe!C2","v":"Einkaufspreis"},{"$f":"Dateneingabe!D2","v":"Anzahl"},"Gesamtwert","Relativ","Kumuliert","Wert relativ","Wert kumuliert","Menge relativ","Menge kumuliert","ABC-Einstufung"]
[null,null,null,null,null,null,0]
[null,"Flügeltürschrank 80 cm",579,54,{"$f":"C4*D4","v":31266},{"$f":"E4/SUM($E$4:$E$23)","v":0.15991202945990179},{"$f":"IF(ISTEXT(G3),F4,G3+F4)","v":0.15991202945990179},{"$f":"C4/SUM($C$4:$C$23)","v":0.10202643171806168},{"$f":"IF(ISTEXT(I2),H4,H4+I2)","v":0.10202643171806168},{"$f":"D4/SUM($D$4:$D$23)","v":6.9142125480153652E-2},{"$f":"IF(ISTEXT(K2),J4,J4+K2)","v":6.9142125480153652E-2},{"$f":"IF(G4<=Dateneingabe!$H$2,\"A\",IF(G4<=Dateneingabe!$H$3,\"B\",\"C\"))","v":"A"}]
[null,"Chefsessel",721,36,25956,0.13275368248772504,0.29266571194762681,0.12704845814977975,{"$f":"IF(ISTEXT(I4),H5,H5+I4)","v":0.22907488986784141},4.6094750320102434E-2,{"$f":"IF(ISTEXT(K4),J5,J5+K4)","v":0.11523687580025609},{"$f":"IF(G5<=Dateneingabe!$H$2,\"A\",IF(G5<=Dateneingabe!$H$3,\"B\",\"C\"))","v":"A"}]
[null,"Sideboard",337,69,23253,0.11892900981996726,0.41159472176759404,5.9383259911894276E-2,0.28845814977973572,8.8348271446862997E-2,0.20358514724711907,{"$f":"IF(G6<=Dateneingabe!$H$2,\"A\",IF(G6<=Dateneingabe!$H$3,\"B\",\"C\"))","v":"A"}]
[null,"Flügeltürschrank 100 cm",679,33,22407,0.11460208674304419,0.52619680851063821,0.11964757709251102,0.40810572687224672,4.2253521126760563E-2,0.24583866837387963,{"$f":"IF(G7<=Dateneingabe!$H$2,\"A\",IF(G7<=Dateneingabe!$H$3,\"B\",\"C\"))","v":"A"}]
[null,"Standcontainer",333,43,14319,7.323547463175123E-2,0.5994322831423895,5.86784140969163E-2,0.46678414096916304,5.5057618437900128E-2,0.30089628681177977,{"$f":"IF(G8<=Dateneingabe!$H$2,\"A\",IF(G8<=Dateneingabe!$H$3,\"B\",\"C\"))","v":"A"}]
[null,"Flügeltürschrank 120 cm",779,17,13243,6.7732201309328971E-2,0.6671644844517185,0.13726872246696034,0.60405286343612341,2.176696542893726E-2,0.32266325224071701,{"$f":"IF(G9<=Dateneingabe!$H$2,\"A\",IF(G9<=Dateneingabe!$H$3,\"B\",\"C\"))","v":"B"}]
[null,"Besprechungstisch",336,36,12096,6.1865793780687399E-2,0.72903027823240585,5.920704845814978E-2,0.66325991189427325,4.6094750320102434E-2,0.36875800256081948,{"$f":"IF(G10<=Dateneingabe!$H$2,\"A\",IF(G10<=Dateneingabe!$H$3,\"B\",\"C\"))","v":"B"}]
[null,"Container",299,32,9568,4.8936170212765959E-2,0.77796644844517182,5.2687224669603523E-2,0.71594713656387676,4.0973111395646605E-2,0.40973111395646611,{"$f":"IF(G11<=Dateneingabe!$H$2,\"A\",IF(G11<=Dateneingabe!$H$3,\"B\",\"C\"))","v":"B"}]
[null,"Tisch",443,20,8860,4.531505728314239E-2,0.82328150572831427,7.8061674008810575E-2,0.79400881057268735,2.5608194622279128E-2,0.43533930857874525,{"$f":"IF(G12<=Dateneingabe!$H$2,\"A\",IF(G12<=Dateneingabe!$H$3,\"B\",\"C\"))","v":"B"}]
[null,"Unterschrank",266,24,6384,3.2651391162029461E-2,0.85593289689034369,4.6872246696035243E-2,0.84088105726872264,3.0729833546734954E-2,0.46606914212548023,{"$f":"IF(G13<=Dateneingabe!$H$2,\"A\",IF(G13<=Dateneingabe!$H$3,\"B\",\"C\"))","v":"B"}]
[null,"PC-Ansatz",77,72,5544,2.8355155482815059E-2,0.88428805237315877,1.3568281938325991E-2,0.85444933920704869,9.2189500640204869E-2,0.55825864276568504,{"$f":"IF(G14<=Dateneingabe!$H$2,\"A\",IF(G14<=Dateneingabe!$H$3,\"B\",\"C\"))","v":"B"}]
[null,"Besprechungsstuhl",90,59,5310,2.7158346972176759E-2,0.91144639934533556,1.5859030837004406E-2,0.87030837004405304,7.5544174135723438E-2,0.63380281690140849,{"$f":"IF(G15<=Dateneingabe!$H$2,\"A\",IF(G15<=Dateneingabe!$H$3,\"B\",\"C\"))","v":"C"}]
[null,"Ansatzplatte oval",112,42,4704,2.4058919803600656E-2,0.9355053191489362,1.973568281938326E-2,0.89004405286343635,5.3777208706786171E-2,0.68758002560819464,{"$f":"IF(G16<=Dateneingabe!$H$2,\"A\",IF(G16<=Dateneingabe!$H$3,\"B\",\"C\"))","v":"C"}]
[null,"Ansatzplatte eckig",59,74,4366,2.2330196399345335E-2,0.9578355155482815,1.0396475770925111E-2,0.90044052863436141,9.4750320102432783E-2,0.78233034571062743,{"$f":"IF(G17<=Dateneingabe!$H$2,\"A\",IF(G17<=Dateneingabe!$H$3,\"B\",\"C\"))","v":"C"}]
[null,"Bürostuhl",241,10,2410,1.2326104746317512E-2,0.97016162029459907,4.2466960352422908E-2,0.94290748898678434,1.2804097311139564E-2,0.79513444302176695,{"$f":"IF(G18<=Dateneingabe!$H$2,\"A\",IF(G18<=Dateneingabe!$H$3,\"B\",\"C\"))","v":"C"}]
[null,"Bild",23,65,1495,7.6462765957446806E-3,0.97780789689034375,4.0528634361233478E-3,0.94696035242290766,8.3226632522407168E-2,0.87836107554417409,{"$f":"IF(G19<=Dateneingabe!$H$2,\"A\",IF(G19<=Dateneingabe!$H$3,\"B\",\"C\"))","v":"C"}]
[null,"Beistellstuhlerl",83,17,1411,7.2166530278232402E-3,0.98502454991816701,1.4625550660792951E-2,0.96158590308370062,2.176696542893726E-2,0.90012804097311139,{"$f":"IF(G20<=Dateneingabe!$H$2,\"A\",IF(G20<=Dateneingabe!$H$3,\"B\",\"C\"))","v":"C"}]
[null,"Ansatzplatte rund",76,18,1368,6.9967266775777413E-3,0.99202127659574479,1.3392070484581497E-2,0.97497797356828209,2.3047375160051217E-2,0.92317541613316256,{"$f":"IF(G21<=Dateneingabe!$H$2,\"A\",IF(G21<=Dateneingabe!$H$3,\"B\",\"C\"))","v":"C"}]
[null,"Verkettung",17,55,935,4.7821194762684123E-3,0.99680339607201318,2.9955947136563878E-3,0.97797356828193849,7.0422535211267609E-2,0.99359795134443019,{"$f":"IF(G22<=Dateneingabe!$H$2,\"A\",IF(G22<=Dateneingabe!$H$3,\"B\",\"C\"))","v":"C"}]
[null,"Hängeschrank",125,5,625,3.1966039279869066E-3,1,2.2026431718061675E-2,1.0000000000000002,6.4020486555697821E-3,1,{"$f":"IF(G23<=Dateneingabe!$H$2,\"A\",IF(G23<=Dateneingabe!$H$3,\"B\",\"C\"))","v":"C"}]
[]
[null,null,null,null,null,null,null,null,"ABC-Analyse Demoversion © Dietmar Brunner 2020"]

{"sheet":"Auswertung grafisch","index":2,"n_rows":47,"n_cols":19,"rows_kept":47,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,"VEKTORDATEN"]
[null,null,null,null,null,null,null,null,null,null,"Diff 1","x","d","a","b","Linie 1 x ","Linie 1 y","Diff 2","x"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"ABS(N4-M4)","v":0.49008797054009823},{"$f":"Dateneingabe!A3","v":1},{"$f":"'ABC-Analyse'!G4","v":0.15991202945990179},{"$f":"Dateneingabe!H2","v":0.65},{"$f":"Dateneingabe!H3","v":0.9},{"$f":"VLOOKUP(P8,K4:L23,2,FALSE)","v":6},0,{"$f":"ABS(O4-M4)","v":0.74008797054009823},{"$f":"L4","v":1}]
[null,null,null,null,null,null,null,null,null,null,0.35733428805237322,{"$f":"Dateneingabe!A4","v":2},{"$f":"'ABC-Analyse'!G5","v":0.29266571194762681},{"$f":"$N$4","v":0.65},{"$f":"$O$4","v":0.9},{"$f":"P4","v":6},{"$f":"Dateneingabe!G2","v":0.65},0.60733428805237322,2]
[null,null,null,null,null,null,null,null,null,null,0.23840527823240598,{"$f":"Dateneingabe!A5","v":3},{"$f":"'ABC-Analyse'!G6","v":0.41159472176759404},0.65,0.9,null,null,0.48840527823240598,3]
[null,null,null,null,null,null,null,null,null,null,0.12380319148936181,{"$f":"Dateneingabe!A6","v":4},{"$f":"'ABC-Analyse'!G7","v":0.52619680851063821},0.65,0.9,"min diff 1","min diff 2",0.37380319148936181,4]
[null,null,null,null,null,null,null,null,null,null,5.0567716857610523E-2,{"$f":"Dateneingabe!A7","v":5},{"$f":"'ABC-Analyse'!G8","v":0.5994322831423895},0.65,0.9,{"$f":"MIN(K4:K23)","v":1.7164484451718476E-2},{"$f":"MIN(R4:R23)","v":1.1446399345335534E-2},0.30056771685761052,5]
[null,null,null,null,null,null,null,null,null,null,1.7164484451718476E-2,{"$f":"Dateneingabe!A8","v":6},{"$f":"'ABC-Analyse'!G9","v":0.6671644844517185},0.65,0.9,null,null,0.23283551554828152,6]
[null,null,null,null,null,null,null,null,null,null,7.9030278232405826E-2,{"$f":"Dateneingabe!A9","v":7},{"$f":"'ABC-Analyse'!G10","v":0.72903027823240585},0.65,0.9,"Linie 2 x","Linie 2 y",0.17096972176759417,7]
[null,null,null,null,null,null,null,null,null,null,0.1279664484451718,{"$f":"Dateneingabe!A10","v":8},{"$f":"'ABC-Analyse'!G11","v":0.77796644844517182},0.65,0.9,{"$f":"VLOOKUP(Q8,R4:S23,2,FALSE)","v":12},0,0.1220335515548282,8]
[null,null,null,null,null,null,null,null,null,null,0.17328150572831424,{"$f":"Dateneingabe!A11","v":9},{"$f":"'ABC-Analyse'!G12","v":0.82328150572831427},0.65,0.9,{"$f":"P11","v":12},{"$f":"Dateneingabe!H3","v":0.9},7.6718494271685755E-2,9]
[null,null,null,null,null,null,null,null,null,null,0.20593289689034366,{"$f":"Dateneingabe!A12","v":10},{"$f":"'ABC-Analyse'!G13","v":0.85593289689034369},0.65,0.9,null,null,4.4067103109656336E-2,10]
[null,null,null,null,null,null,null,null,null,null,0.23428805237315875,{"$f":"Dateneingabe!A13","v":11},{"$f":"'ABC-Analyse'!G14","v":0.88428805237315877},0.65,0.9,null,null,1.5711947626841249E-2,11]
[null,null,null,null,null,null,null,null,null,null,0.26144639934533553,{"$f":"Dateneingabe!A14","v":12},{"$f":"'ABC-Analyse'!G15","v":0.91144639934533556},0.65,0.9,null,null,1.1446399345335534E-2,12]
[null,null,null,null,null,null,null,null,null,null,0.28550531914893618,{"$f":"Dateneingabe!A15","v":13},{"$f":"'ABC-Analyse'!G16","v":0.9355053191489362},0.65,0.9,null,null,3.5505319148936176E-2,13]
[null,null,null,null,null,null,null,null,null,null,0.30783551554828148,{"$f":"Dateneingabe!A16","v":14},{"$f":"'ABC-Analyse'!G17","v":0.9578355155482815},0.65,0.9,null,null,5.783551554828148E-2,14]
[null,null,null,null,null,null,null,null,null,null,0.32016162029459905,{"$f":"Dateneingabe!A17","v":15},{"$f":"'ABC-Analyse'!G18","v":0.97016162029459907},0.65,0.9,null,null,7.0161620294599047E-2,15]
[null,null,null,null,null,null,null,null,null,null,0.32780789689034373,{"$f":"Dateneingabe!A18","v":16},{"$f":"'ABC-Analyse'!G19","v":0.97780789689034375},0.65,0.9,"A",null,7.7807896890343731E-2,16]
[null,null,null,null,null,null,null,null,null,null,0.33502454991816699,{"$f":"Dateneingabe!A19","v":17},{"$f":"'ABC-Analyse'!G20","v":0.98502454991816701},0.65,0.9,"B",null,8.5024549918166992E-2,17]
[null,null,null,null,null,null,null,null,null,null,0.34202127659574477,{"$f":"Dateneingabe!A20","v":18},{"$f":"'ABC-Analyse'!G21","v":0.99202127659574479},0.65,0.9,"C",null,9.2021276595744772E-2,18]
[null,null,null,null,null,null,null,null,null,null,0.34680339607201316,{"$f":"Dateneingabe!A21","v":19},{"$f":"'ABC-Analyse'!G22","v":0.99680339607201318},0.65,0.9,null,null,9.6803396072013159E-2,19]
[null,null,null,null,null,null,null,null,null,null,0.35,{"$f":"Dateneingabe!A22","v":20},{"$f":"'ABC-Analyse'!G23","v":1},0.65,0.9,null,null,9.9999999999999978E-2,20]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"VERTEILUNG:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"A Menge von",null,{"$f":"MIN(IF('ABC-Analyse'!$L$4:$L$23=\"A\",'ABC-Analyse'!$K$4:$K$23))","v":6.9142125480153652E-2},{"$f":"MIN(IF('ABC-Analyse'!$L$4:$L$23=\"A\",'ABC-Analyse'!$I$4:$I$23))","v":0.10202643171806168}]
[null,null,null,null,null,null,null,null,null,null,null,"A Menge bis",null,{"$f":"MAX(IF('ABC-Analyse'!$L$4:$L$23=\"A\",'ABC-Analyse'!$K$4:$K$23))","v":0.30089628681177977},{"$f":"MIN(IF('ABC-Analyse'!$L$4:$L$23=\"A\",'ABC-Analyse'!$I$4:$I$23))","v":0.10202643171806168}]
[null,null,null,null,null,null,null,null,null,null,null,"A Wert von",null,{"$f":"MAX(IF('ABC-Analyse'!$L$4:$L$23=\"A\",'ABC-Analyse'!$K$4:$K$23))","v":0.30089628681177977},{"$f":"MAX(IF('ABC-Analyse'!$L$4:$L$23=\"A\",'ABC-Analyse'!$I$4:$I$23))","v":0.46678414096916304}]
[null,null,null,null,null,null,null,null,null,null,null,"A Wert bis",null,{"$f":"MIN(IF('ABC-Analyse'!$L$4:$L$23=\"A\",'ABC-Analyse'!$K$4:$K$23))","v":6.9142125480153652E-2},{"$f":"MAX(IF('ABC-Analyse'!$L$4:$L$23=\"A\",'ABC-Analyse'!$I$4:$I$23))","v":0.46678414096916304}]
[null,null,null,null,null,null,null,null,null,null,null,"A Vektor",null,{"$f":"MIN(IF('ABC-Analyse'!$L$4:$L$23=\"A\",'ABC-Analyse'!$K$4:$K$23))","v":6.9142125480153652E-2},{"$f":"MIN(IF('ABC-Analyse'!$L$4:$L$23=\"A\",'ABC-Analyse'!$I$4:$I$23))","v":0.10202643171806168}]
[null,null,null,null,null,null,null,null,null,null,null,"B Menge von",null,{"$f":"MIN(IF('ABC-Analyse'!$L$4:$L$23=\"B\",'ABC-Analyse'!$K$4:$K$23))","v":0.32266325224071701},{"$f":"MIN(IF('ABC-Analyse'!$L$4:$L$23=\"B\",'ABC-Analyse'!$I$4:$I$23))","v":0.60405286343612341}]
[null,null,null,null,null,null,null,null,null,null,null,"B Menge bis",null,{"$f":"MAX(IF('ABC-Analyse'!$L$4:$L$23=\"B\",'ABC-Analyse'!$K$4:$K$23))","v":0.55825864276568504},{"$f":"MIN(IF('ABC-Analyse'!$L$4:$L$23=\"B\",'ABC-Analyse'!$I$4:$I$23))","v":0.60405286343612341}]
[null,null,null,null,null,null,null,null,null,null,null,"B Wert von",null,{"$f":"MAX(IF('ABC-Analyse'!$L$4:$L$23=\"B\",'ABC-Analyse'!$K$4:$K$23))","v":0.55825864276568504},{"$f":"MAX(IF('ABC-Analyse'!$L$4:$L$23=\"B\",'ABC-Analyse'!$I$4:$I$23))","v":0.85444933920704869}]
[null,null,null,null,null,null,null,null,null,null,null,"B Wert bis",null,{"$f":"MIN(IF('ABC-Analyse'!$L$4:$L$23=\"B\",'ABC-Analyse'!$K$4:$K$23))","v":0.32266325224071701},{"$f":"MAX(IF('ABC-Analyse'!$L$4:$L$23=\"B\",'ABC-Analyse'!$I$4:$I$23))","v":0.85444933920704869}]
[null,null,null,null,null,null,null,null,null,null,null,"B Vektor",null,{"$f":"MIN(IF('ABC-Analyse'!$L$4:$L$23=\"B\",'ABC-Analyse'!$K$4:$K$23))","v":0.32266325224071701},{"$f":"MIN(IF('ABC-Analyse'!$L$4:$L$23=\"B\",'ABC-Analyse'!$I$4:$I$23))","v":0.60405286343612341}]
[null,null,null,null,null,null,null,null,null,null,null,"C Menge von",null,{"$f":"MIN(IF('ABC-Analyse'!$L$4:$L$23=\"C\",'ABC-Analyse'!$K$4:$K$23))","v":0.63380281690140849},{"$f":"MIN(IF('ABC-Analyse'!$L$4:$L$23=\"C\",'ABC-Analyse'!$I$4:$I$23))","v":0.87030837004405304}]
[null,null,null,null,null,null,null,null,null,null,null,"C Menge bis",null,{"$f":"MAX(IF('ABC-Analyse'!$L$4:$L$23=\"C\",'ABC-Analyse'!$K$4:$K$23))","v":1},{"$f":"MIN(IF('ABC-Analyse'!$L$4:$L$23=\"C\",'ABC-Analyse'!$I$4:$I$23))","v":0.87030837004405304}]
[null,null,null,null,null,null,null,null,null,null,null,"C Wert von",null,{"$f":"MAX(IF('ABC-Analyse'!$L$4:$L$23=\"C\",'ABC-Analyse'!$K$4:$K$23))","v":1},{"$f":"MAX(IF('ABC-Analyse'!$L$4:$L$23=\"C\",'ABC-Analyse'!$I$4:$I$23))","v":1.0000000000000002}]
[null,null,null,null,null,null,null,null,null,null,null,"C Wert bis",null,{"$f":"MIN(IF('ABC-Analyse'!$L$4:$L$23=\"C\",'ABC-Analyse'!$K$4:$K$23))","v":0.63380281690140849},{"$f":"MAX(IF('ABC-Analyse'!$L$4:$L$23=\"C\",'ABC-Analyse'!$I$4:$I$23))","v":1.0000000000000002}]
[null,null,null,null,null,null,null,null,null,null,null,"C Vektor",null,{"$f":"MIN(IF('ABC-Analyse'!$L$4:$L$23=\"C\",'ABC-Analyse'!$K$4:$K$23))","v":0.63380281690140849},{"$f":"MIN(IF('ABC-Analyse'!$L$4:$L$23=\"C\",'ABC-Analyse'!$I$4:$I$23))","v":0.87030837004405304}]