{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Cover","Jahresumsätze","Verkäuferumsätze","Regionale Produktumsätze","Produktgruppen","Quartalsumsätze","Auftragsliste","Umsatzprognose","Kundenumsätze","Produktumsätze","Einzelpositionen"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"defined_names":6,"comments":0,"pivot_tables":8},"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":"Cover","index":0,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Excel + VBA "]
[null,"für Controller"]
[]
[]
[null,"Kapitel",4]
[null,"Thema","Methoden der Datenaufbereitung"]
[]
[null,"Inhalt","Pivot-Tabellen"]
[null,null,"Beispiel Auftragsliste"]
[null,null," "]
[]
[]
[]
[]
[]
[null,"Autor","Harald Nahrstedt"]
[null,"Datum",43466]
[null,"Version","1.0"]
[]
[]
[null,"Springer Verlag"]

{"sheet":"Jahresumsätze","index":1,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Umsatzsumme","Jahre"]
["Verkäufer","2010","2011","2012","Gesamtergebnis"]
["Altmann",60365.270000000019,36702.04,44777.030000000013,141844.34000000003]
["Amtmann",36561.9,10185.530000000001,25546.360000000004,72293.790000000008]
["Bauer",63914.939999999988,63077.37999999999,20022.95,147015.26999999999]
["Becker",14420.599999999999,3573.52,4945.22,22939.34]
["Brenner",38837.039999999994,47126.779999999992,61391.499999999993,147355.31999999998]
["Filzer",13992.470000000001,8032.3499999999995,19044.759999999998,41069.58]
["Gärtner",39146.759999999995,25805.75,25270.189999999995,90222.699999999983]
["Hauer",51956.100000000006,22881.27,25232.5,100069.87000000001]
["Holzer",80733.510000000024,55752.859999999993,24793.530000000002,161279.90000000002]
["Holzmann",25271.829999999998,21943.68,12844.61,60060.119999999995]
["Lehmann",111845.19000000002,109474.31000000001,56454.369999999995,277773.87]
["Lehrer",27048.31,21077.739999999998,14787.419999999998,62913.47]
["Müller",null,28188.999999999996,22055.919999999998,50244.92]
["Näher",64630.11,71995.31,32134.800000000003,168760.21999999997]
["Renner",15837.28,15199.78,24208.940000000002,55246]
["Sandmann",62865.98000000001,58871.790000000008,65434.280000000006,187172.05000000002]
["Uhl",36526.36,27522.36,46551.08,110599.8]
["Wanda",48572.9,24576.299999999996,32148.139999999996,105297.34]
["Weber",59614.420000000006,41096.21,53783.85,154494.48000000001]
["Weinreich",28683.980000000003,15519.720000000001,7285.76,51489.460000000006]
["Gesamtergebnis",880824.95000000007,708603.68,618713.21,2208141.8400000003]

{"sheet":"Verkäuferumsätze","index":2,"n_rows":29,"n_cols":3,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Summe von Umsatz"]
["Region","Verkäufer","Ergebnis"]
["Nord","Altmann",141844.34000000005]
[null,"Hauer",100069.87]
[null,"Holzmann",60060.119999999988]
[null,"Lehmann",277773.87]
[null,"Müller",50244.92]
["Nord Ergebnis",null,629993.12]
["Ost","Filzer",41069.579999999994]
[null,"Gärtner",90222.700000000012]
[null,"Uhl",110599.8]
[null,"Wanda",105297.34]
["Ost Ergebnis",null,347189.42000000004]
["Süd","Amtmann",72293.789999999994]
[null,"Becker",22939.339999999997]
[null,"Brenner",147355.31999999998]
[null,"Lehrer",62913.47]
[null,"Sandmann",187172.05000000005]
[null,"Weinreich",51489.46]
["Süd Ergebnis",null,544163.42999999993]
["West","Bauer",147015.26999999999]
[null,"Holzer",161279.9]
[null,"Näher",168760.21999999994]
[null,"Renner",55246]
[null,"Weber",154494.48000000004]
["West Ergebnis",null,686795.86999999988]
["Gesamtergebnis",null,2208141.84]

{"sheet":"Regionale Produktumsätze","index":3,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Summe von Umsatz","Region"]
["Produktkategorie","Nord","Ost","Süd","West","Gesamtergebnis"]
["Dichtungen",33585.760000000002,21641.439999999999,10620.4,66411.31,132258.90999999997]
["Druckfedern",71036.780000000013,null,43684.2,37021.520000000004,151742.5]
["Gelenkbolzen",74272.75,29056.959999999999,85077.63,69953.099999999991,258360.44]
["Gleitlager",19815.350000000002,26001.279999999999,7147.04,51714.080000000002,104677.75]
["Kegelräder",null,63028,70685.289999999994,30173.1,163886.38999999998]
["Kettenglieder",3206.12,5542.3,25643.52,23643.48,58035.42]
["Kupplungen",50594.9,54418.600000000006,105633.41999999998,22522.9,233169.81999999998]
["Metallschrauben",20807.32,null,5738.6,111478.81999999999,138024.74]
["Nieten",null,17519.45,36028.68,28890.510000000002,82438.640000000014]
["Stirnräder",130656.52999999998,37991.300000000003,null,57267.73,225915.56]
["Tellerfedern",10590.150000000001,null,62574.899999999994,38835,112000.04999999999]
["Vierkant",null,null,30581.45,42294.1,72875.55]
["Wälzlager",73708.320000000007,41661.46,null,3290.1,118659.88]
["Zahnräder",30776.560000000001,null,11192.859999999999,65415.099999999991,107384.51999999999]
["Zugfedern",110942.58000000002,50328.63,49555.44,37885.019999999997,248711.67]
["Gesamtergebnis",629993.12,347189.42000000004,544163.42999999993,686795.87,2208141.84]

{"sheet":"Produktgruppen","index":4,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Umsatzsumme"]
["Produktgruppe","Produktkategorie","Ergebnis"]
["Elemente","Dichtungen",132258.91]
[null,"Gelenkbolzen",258360.44]
[null,"Metallschrauben",138024.74]
[null,"Nieten",82438.64]
[null,"Vierkant",72875.549999999988]
["Elemente Ergebnis",null,683958.28]
["Federn","Druckfedern",151742.50000000003]
[null,"Tellerfedern",112000.05]
[null,"Zugfedern",248711.67000000004]
["Federn Ergebnis",null,512454.22000000009]
["Antrieb","Gleitlager",104677.75000000003]
[null,"Kettenglieder",58035.420000000013]
[null,"Kupplungen",233169.82000000012]
[null,"Wälzlager",118659.88000000003]
["Antrieb Ergebnis",null,514542.87000000023]
["Zahnräder","Kegelräder",163886.39000000007]
[null,"Stirnräder",225915.56000000006]
[null,"Zahnräder",107384.52]
["Zahnräder Ergebnis",null,497186.47000000015]
["Gesamtergebnis",null,2208141.8400000003]

{"sheet":"Quartalsumsätze","index":5,"n_rows":25,"n_cols":7,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Summe von Umsatz","Jahre","Quartale"]
[null,"2010",null,null,null,"2010 Ergebnis","Gesamtergebnis"]
["Verkäufer","Qrtl1","Qrtl2","Qrtl3","Qrtl4"]
["Altmann",3503.26,9278.84,28147.86,19435.310000000001,60365.270000000004,60365.270000000004]
["Amtmann",13535.740000000002,7965.2999999999993,7530.43,7530.43,36561.9,36561.9]
["Bauer",15012.349999999999,21258.68,12053.38,15590.529999999999,63914.939999999995,63914.939999999995]
["Becker",3158.46,null,8103.68,3158.46,14420.599999999999,14420.599999999999]
["Brenner",7992.84,26847.78,3996.42,null,38837.039999999994,38837.039999999994]
["Filzer",11012.41,1490.03,1490.03,null,13992.470000000001,13992.470000000001]
["Gärtner",7357.75,22214.339999999997,1108.46,8466.2099999999991,39146.759999999995,39146.759999999995]
["Hauer",7597.92,7154.8200000000006,34678.119999999995,2525.2399999999998,51956.1,51956.1]
["Holzer",30301.789999999997,10453.85,17427.36,22550.51,80733.509999999995,80733.509999999995]
["Holzmann",null,17684.32,null,7587.51,25271.83,25271.83]
["Lehmann",28598.340000000004,17262.96,20850.100000000002,45133.79,111845.19,111845.19]
["Lehrer",241.12,6997.3,6410.88,13399.01,27048.309999999998,27048.309999999998]
["Näher",21495.3,17413.010000000002,19945.89,5775.91,64630.11,64630.11]
["Renner",9533.43,5028.8500000000004,637.5,637.5,15837.28,15837.28]
["Sandmann",16927.169999999998,19944.73,22942.53,3051.55,62865.979999999996,62865.979999999996]
["Uhl",1610.7,9004,null,25911.66,36526.36,36526.36]
["Wanda",21976.94,14756.31,8335.76,3503.89,48572.9,48572.9]
["Weber",33893.379999999997,7767,9970.7800000000007,7983.26,59614.42,59614.42]
["Weinreich",4370.62,12910.619999999999,5624.86,5777.88,28683.98,28683.98]
["Gesamtergebnis",238119.51999999996,235432.74000000002,209254.03999999998,198018.65000000002,880824.95,880824.95]

{"sheet":"Auftragsliste","index":6,"n_rows":501,"n_cols":7,"rows_kept":501,"cut":false,"hidden":false,"merged":[]}
["Region","Verkäufer","Kunde","Produktkategorie","Umsatz","Auftragsnummer","Auftragseingang"]
["Nord","Lehmann","Uhlmann GmbH","Wälzlager",5213.46,"A2010073",40186]
["Nord","Hauer","Freimann KG","Zugfedern",7597.92,"A2010060",40188]
["Nord","Lehmann","Bahr oHG","Tellerfedern",2118.0300000000002,"A2010049",40197]
["Nord","Altmann","Raabe & Partner","Stirnräder",2701.73,"A2010039",40209]
["Nord","Lehmann","Kortmann & Sohn","Zugfedern",960.85,"A2010083",40242]
["Nord","Lehmann","Enkel & Nachfolger","Stirnräder",9959.2900000000009,"A2010040",40249]
["Nord","Lehmann","Fricke & Söhne","Dichtungen",1256.56,"A2010046",40255]
["Nord","Altmann","Hobel GmbH","Kettenglieder",801.53,"A2010031",40255]
["Nord","Lehmann","Freimann KG","Gelenkbolzen",9090.15,"A2010087",40266]
["Nord","Lehmann","Fricke & Söhne","Dichtungen",1256.56,"A2010046",40271]
["Nord","Hauer","Rottmann GmbH","Zugfedern",6469.14,"A2010004",40288]
["Nord","Altmann","Ross oHG","Zahnräder",3847.07,"A2010038",40290]
["Nord","Lehmann","Vogel & Co.","Kupplungen",6916.25,"A2010029",40296]
["Nord","Hauer","Bartmann KG","Wälzlager",685.68,"A2010006",40300]
["Nord","Holzmann","Enkel & Nachfolger","Gelenkbolzen",7205.5,"A2010058",40304]
["Nord","Altmann","Raabe & Partner","Stirnräder",2701.73,"A2010039",40305]
["Nord","Holzmann","Enkel & Nachfolger","Gelenkbolzen",7205.5,"A2010058",40316]
["Nord","Altmann","Ross oHG","Metallschrauben",1928.51,"A2010013",40316]
["Nord","Altmann","Hobel GmbH","Kettenglieder",801.53,"A2010031",40316]
["Nord","Lehmann","Freimann KG","Gelenkbolzen",9090.15,"A2010087",40332]
["Nord","Holzmann","Asshoff KG","Metallschrauben",3273.32,"A2010012",40336]
["Nord","Hauer","Uhlmann GmbH","Dichtungen",6825.74,"A2010015",40363]
["Nord","Hauer","Rottmann GmbH","Zugfedern",6469.14,"A2010004",40373]
["Nord","Lehmann","Brand & Partner","Zugfedern",3758.11,"A2010088",40385]
["Nord","Hauer","Conen oHG & Co","Kupplungen",1262.6199999999999,"A2010085",40397]
["Nord","Hauer","Uhlmann GmbH","Dichtungen",6825.74,"A2010015",40405]
["Nord","Altmann","Ross oHG","Zahnräder",3847.07,"A2010038",40407]
["Nord","Altmann","Pieper & Co.","Wälzlager",7483.05,"A2010099",40415]
["Nord","Lehmann","Bahr oHG","Tellerfedern",2118.0300000000002,"A2010049",40420]
["Nord","Hauer","Uhlmann GmbH","Dichtungen",6825.74,"A2010015",40421]
["Nord","Altmann","Rühring GmbH","Druckfedern",8408.8700000000008,"A2010024",40426]
["Nord","Hauer","Rottmann GmbH","Zugfedern",6469.14,"A2010004",40433]
["Nord","Lehmann","Fricke & Söhne","Dichtungen",1256.56,"A2010046",40435]
["Nord","Lehmann","Brand & Partner","Zugfedern",3758.11,"A2010088",40435]
["Nord","Lehmann","Enkel & Nachfolger","Stirnräder",9959.2900000000009,"A2010040",40438]
["Nord","Altmann","Rühring GmbH","Druckfedern",8408.8700000000008,"A2010024",40443]
["Nord","Lehmann","Bahr oHG","Tellerfedern",2118.0300000000002,"A2010049",40453]
["Nord","Lehmann","Lange & Partner","Zugfedern",5890.83,"A2010025",40457]
["Nord","Lehmann","Enkel & Nachfolger","Stirnräder",9959.2900000000009,"A2010040",40458]
["Nord","Lehmann","Kortmann & Sohn","Zugfedern",960.85,"A2010083",40461]
["Nord","Lehmann","Hinz & Kunz KG","Stirnräder",7465.7,"A2010042",40463]
["Nord","Holzmann","Kuhn & Lanz","Stirnräder",382.01,"A2010028",40471]
["Nord","Lehmann","Brand & Partner","Zugfedern",3758.11,"A2010088",40483]
["Nord","Altmann","Raabe & Partner","Stirnräder",2701.73,"A2010039",40500]
["Nord","Lehmann","Lange & Partner","Zugfedern",5890.83,"A2010025",40501]
["Nord","Altmann","Raabe & Partner","Stirnräder",2701.73,"A2010039",40507]
["Nord","Hauer","Conen oHG & Co","Kupplungen",1262.6199999999999,"A2010085",40507]
["Nord","Lehmann","Freimann KG","Gelenkbolzen",9090.15,"A2010087",40512]
["Nord","Altmann","Ross oHG","Zahnräder",3847.07,"A2010038",40515]
["Nord","Altmann","Raabe & Partner","Stirnräder",2701.73,"A2010039",40528]
["Nord","Holzmann","Enkel & Nachfolger","Gelenkbolzen",7205.5,"A2010058",40534]
["Nord","Altmann","Pieper & Co.","Wälzlager",7483.05,"A2010099",40534]
["Nord","Hauer","Conen oHG & Co","Kupplungen",1262.6199999999999,"A2010085",40538]
["Nord","Hauer","Bartmann KG","Wälzlager",685.68,"A2011006",40546]
["Nord","Holzmann","Asshoff KG","Metallschrauben",3273.32,"A2011012",40564]
["Nord","Müller","Enkel & Nachfolger","Gleitlager",3963.07,"A2011075",40575]
["Nord","Altmann","Pieper & Co.","Wälzlager",7483.05,"A2011099",40581]
["Nord","Lehmann","Lange & Partner","Zugfedern",5890.83,"A2011025",40583]
["Nord","Lehmann","Hinz & Kunz KG","Stirnräder",7465.7,"A2011042",40593]
["Nord","Müller","Pollen GmbH","Stirnräder",117.78,"A2011065",40597]
["Nord","Müller","Enkel & Nachfolger","Gleitlager",3963.07,"A2011075",40597]
["Nord","Altmann","Raabe & Partner","Stirnräder",2701.73,"A2011039",40603]
["Nord","Altmann","Pieper & Co.","Wälzlager",7483.05,"A2011099",40608]
["Nord","Lehmann","Uhlmann GmbH","Wälzlager",5213.46,"A2011073",40613]
["Nord","Lehmann","Lange & Partner","Zugfedern",5890.83,"A2011025",40614]
["Nord","Lehmann","Freimann KG","Gelenkbolzen",9090.15,"A2011087",40619]
["Nord","Lehmann","Vogel & Co.","Kupplungen",6916.25,"A2011029",40626]
["Nord","Lehmann","Bahr oHG","Tellerfedern",2118.0300000000002,"A2011049",40628]
["Nord","Müller","Pollen GmbH","Stirnräder",117.78,"A2011065",40632]
["Nord","Lehmann","Brand & Partner","Zugfedern",3758.11,"A2011088",40633]
["Nord","Altmann","Pieper & Co.","Wälzlager",7483.05,"A2011099",40640]
["Nord","Lehmann","Bahr oHG","Tellerfedern",2118.0300000000002,"A2011049",40645]
["Nord","Lehmann","Fricke & Söhne","Dichtungen",1256.56,"A2011046",40648]
["Nord","Altmann","Ross oHG","Metallschrauben",1928.51,"A2011013",40660]
["Nord","Lehmann","Brand & Partner","Zugfedern",3758.11,"A2011088",40660]
["Nord","Altmann","Ross oHG","Zahnräder",3847.07,"A2011038",40677]
["Nord","Lehmann","Fricke & Söhne","Dichtungen",1256.56,"A2011046",40687]
["Nord","Holzmann","Kuhn & Lanz","Stirnräder",382.01,"A2011028",40689]
["Nord","Hauer","Neibel GmbH & Co.","Druckfedern",1488.57,"A2011074",40699]
["Nord","Hauer","Freimann KG","Zugfedern",7597.92,"A2011060",40706]
["Nord","Müller","Enkel & Nachfolger","Gleitlager",3963.07,"A2011075",40721]
["Nord","Lehmann","Enkel & Nachfolger","Stirnräder",9959.2900000000009,"A2011040",40731]
["Nord","Müller","Rüther & Hübner","Druckfedern",5991.69,"A2011077",40736]
["Nord","Lehmann","Hinz & Kunz KG","Stirnräder",7465.7,"A2011042",40739]
["Nord","Lehmann","Enkel & Nachfolger","Stirnräder",9959.2900000000009,"A2011040",40742]
["Nord","Lehmann","Kortmann & Sohn","Zugfedern",960.85,"A2011083",40743]
["Nord","Müller","Enkel & Nachfolger","Gleitlager",3963.07,"A2011075",40743]
["Nord","Lehmann","Enkel & Nachfolger","Stirnräder",9959.2900000000009,"A2011040",40754]
["Nord","Altmann","Ross oHG","Zahnräder",3847.07,"A2011038",40756]
["Nord","Holzmann","Kuhn & Lanz","Stirnräder",382.01,"A2011028",40761]
["Nord","Holzmann","Hofer oHG","Kupplungen",4154.2,"A2011011",40790]
["Nord","Hauer","Neibel GmbH & Co.","Druckfedern",1488.57,"A2011074",40806]
["Nord","Holzmann","Asshoff KG","Metallschrauben",3273.32,"A2011012",40816]
["Nord","Hauer","Bartmann KG","Wälzlager",685.68,"A2011006",40824]
["Nord","Lehmann","Brand & Partner","Zugfedern",3758.11,"A2011088",40830]
["Nord","Hauer","Neibel GmbH & Co.","Druckfedern",1488.57,"A2011074",40835]
["Nord","Lehmann","Hinz & Kunz KG","Stirnräder",7465.7,"A2011042",40846]
["Nord","Hauer","Neibel GmbH & Co.","Druckfedern",1488.57,"A2011074",40861]
["Nord","Altmann","Ross oHG","Metallschrauben",1928.51,"A2011013",40869]
["Nord","Holzmann","Enkel & Nachfolger","Gelenkbolzen",7205.5,"A2011058",40874]
["Nord","Hauer","Rottmann GmbH","Zugfedern",6469.14,"A2011004",40876]
["Nord","Müller","Pollen GmbH","Stirnräder",117.78,"A2011065",40881]
["Nord","Lehmann","Uhlmann GmbH","Wälzlager",5213.46,"A2011073",40883]
["Nord","Hauer","Neibel GmbH & Co.","Druckfedern",1488.57,"A2011074",40896]
["Nord","Müller","Rüther & Hübner","Druckfedern",5991.69,"A2011077",40896]
["Nord","Holzmann","Asshoff KG","Metallschrauben",3273.32,"A2011012",40898]
["Nord","Müller","Rüther & Hübner","Druckfedern",5991.69,"A2012077",40915]
["Nord","Hauer","Freimann KG","Zugfedern",7597.92,"A2012060",40921]
["Nord","Müller","Rüther & Hübner","Druckfedern",5991.69,"A2012077",40943]
["Nord","Holzmann","Hofer oHG","Kupplungen",4154.2,"A2012011",40947]
["Nord","Lehmann","Vogel & Co.","Kupplungen",6916.25,"A2012029",40954]
["Nord","Altmann","Hobel GmbH","Kettenglieder",801.53,"A2012031",40956]
["Nord","Hauer","Conen oHG & Co","Kupplungen",1262.6199999999999,"A2012085",40970]
["Nord","Hauer","Freimann KG","Zugfedern",7597.92,"A2012060",40988]
["Nord","Lehmann","Brand & Partner","Zugfedern",3758.11,"A2012088",40989]
["Nord","Lehmann","Kortmann & Sohn","Zugfedern",960.85,"A2012083",40990]
["Nord","Holzmann","Kuhn & Lanz","Stirnräder",382.01,"A2012028",40996]
["Nord","Altmann","Rühring GmbH","Druckfedern",8408.8700000000008,"A2012024",40999]
["Nord","Hauer","Conen oHG & Co","Kupplungen",1262.6199999999999,"A2012085",41008]
["Nord","Müller","Enkel & Nachfolger","Gleitlager",3963.07,"A2012075",41038]
["Nord","Altmann","Ross oHG","Zahnräder",3847.07,"A2012038",41059]
["Nord","Altmann","Hobel GmbH","Kettenglieder",801.53,"A2012031",41063]
["Nord","Altmann","Pieper & Co.","Wälzlager",7483.05,"A2012099",41066]
["Nord","Lehmann","Vogel & Co.","Kupplungen",6916.25,"A2012029",41069]
["Nord","Holzmann","Hofer oHG","Kupplungen",4154.2,"A2012011",41071]
["Nord","Lehmann","Uhlmann GmbH","Wälzlager",5213.46,"A2012073",41088]
["Nord","Lehmann","Enkel & Nachfolger","Stirnräder",9959.2900000000009,"A2012040",41093]
["Nord","Altmann","Ross oHG","Zahnräder",3847.07,"A2012038",41097]
["Nord","Holzmann","Hofer oHG","Kupplungen",4154.2,"A2012011",41099]
["Nord","Altmann","Rühring GmbH","Druckfedern",8408.8700000000008,"A2012024",41104]
["Nord","Lehmann","Freimann KG","Gelenkbolzen",9090.15,"A2012087",41114]
["Nord","Altmann","Raabe & Partner","Stirnräder",2701.73,"A2012039",41114]
["Nord","Lehmann","Kortmann & Sohn","Zugfedern",960.85,"A2012083",41140]
["Nord","Lehmann","Hinz & Kunz KG","Stirnräder",7465.7,"A2012042",41141]
["Nord","Altmann","Ross oHG","Metallschrauben",1928.51,"A2012013",41161]
["Nord","Lehmann","Uhlmann GmbH","Wälzlager",5213.46,"A2012073",41175]
["Nord","Hauer","Uhlmann GmbH","Dichtungen",6825.74,"A2012015",41190]
["Nord","Müller","Rüther & Hübner","Druckfedern",5991.69,"A2012077",41209]
["Nord","Hauer","Bartmann KG","Wälzlager",685.68,"A2012006",41225]
["Nord","Müller","Pollen GmbH","Stirnräder",117.78,"A2012065",41232]
["Nord","Altmann","Ross oHG","Zahnräder",3847.07,"A2012038",41234]
["Nord","Altmann","Raabe & Partner","Stirnräder",2701.73,"A2012039",41262]
["Ost","Filzer","Pollen GmbH","Kupplungen",1490.03,"A2010099",40184]
["Ost","Uhl","Ross oHG","Wälzlager",1610.7,"A2010070",40185]
["Ost","Wanda","Ross oHG","Gelenkbolzen",7264.24,"A2010061",40200]
["Ost","Wanda","Conen oHG & Co","Stirnräder",1712.06,"A2010084",40204]
["Ost","Wanda","Freimann KG","Gleitlager",6500.32,"A2010059",40207]
["Ost","Gärtner","Dober & Sohn KG","Stirnräder",7357.75,"A2010027",40215]
["Ost","Wanda","Freimann KG","Gleitlager",6500.32,"A2010059",40218]
["Ost","Filzer","Pieper & Co.","Zugfedern",6542.32,"A2010019",40222]
["Ost","Filzer","Pollen GmbH","Kupplungen",1490.03,"A2010099",40234]
["Ost","Filzer","Pollen GmbH","Kupplungen",1490.03,"A2010063",40243]
["Ost","Gärtner","Bahr oHG","Wälzlager",8401.99,"A2010062",40269]
["Ost","Wanda","Conen oHG & Co","Stirnräder",1712.06,"A2010084",40291]
["Ost","Gärtner","Neibel GmbH & Co.","Dichtungen",5410.36,"A2010023",40293]
["Ost","Wanda","Ehrmann GmbH","Zugfedern",4831.87,"A2010048",40299]
["Ost","Wanda","Freimann KG","Gleitlager",6500.32,"A2010059",40304]
["Ost","Uhl","Kramer GmbH","Kegelräder",9004,"A2010089",40314]
["Ost","Wanda","Conen oHG & Co","Stirnräder",1712.06,"A2010084",40329]
["Ost","Filzer","Pollen GmbH","Kupplungen",1490.03,"A2010099",40333]
["Ost","Gärtner","Bahr oHG","Wälzlager",8401.99,"A2010062",40338]
["Ost","Wanda","Ehrmann GmbH","Zugfedern",4831.87,"A2010048",40366]
["Ost","Gärtner","Ross oHG","Kettenglieder",1108.46,"A2010086",40374]
["Ost","Filzer","Pollen GmbH","Kupplungen",1490.03,"A2010063",40436]
["Ost","Wanda","Ross oHG","Nieten",3503.89,"A2010052",40444]
["Ost","Wanda","Ross oHG","Nieten",3503.89,"A2010052",40474]
["Ost","Gärtner","Dober & Sohn KG","Stirnräder",7357.75,"A2010027",40497]
["Ost","Uhl","Kramer GmbH","Kegelräder",9004,"A2010089",40506]
["Ost","Uhl","Kramer GmbH","Kegelräder",9004,"A2010089",40507]
["Ost","Gärtner","Ross oHG","Kettenglieder",1108.46,"A2010086",40513]
["Ost","Uhl","Lammer GmbH","Kupplungen",7903.66,"A2010078",40518]
["Ost","Wanda","Ross oHG","Gelenkbolzen",7264.24,"A2011061",40557]
["Ost","Gärtner","Neibel GmbH & Co.","Dichtungen",5410.36,"A2011023",40568]
["Ost","Gärtner","Ross oHG","Kettenglieder",1108.46,"A2011086",40593]
["Ost","Wanda","Conen oHG & Co","Stirnräder",1712.06,"A2011084",40598]
["Ost","Uhl","Lammer GmbH","Kupplungen",7903.66,"A2011078",40606]
["Ost","Filzer","Pollen GmbH","Kupplungen",1490.03,"A2011063",40670]
["Ost","Wanda","Ehrmann GmbH","Zugfedern",4831.87,"A2011048",40754]
["Ost","Wanda","Ross oHG","Nieten",3503.89,"A2011052",40771]
["Ost","Wanda","Ross oHG","Gelenkbolzen",7264.24,"A2011061",40785]
["Ost","Gärtner","Neibel GmbH & Co.","Dichtungen",5410.36,"A2011023",40793]
["Ost","Uhl","Kramer GmbH","Kegelräder",9004,"A2011089",40833]
["Ost","Filzer","Pieper & Co.","Zugfedern",6542.32,"A2011019",40854]
["Ost","Uhl","Ross oHG","Wälzlager",1610.7,"A2011070",40872]
["Ost","Gärtner","Neibel GmbH & Co.","Dichtungen",5410.36,"A2011023",40878]
["Ost","Uhl","Kramer GmbH","Kegelräder",9004,"A2011089",40887]
["Ost","Gärtner","Dober & Sohn KG","Stirnräder",7357.75,"A2011027",40894]
["Ost","Gärtner","Ross oHG","Kettenglieder",1108.46,"A2011086",40898]
["Ost","Uhl","Kramer GmbH","Kegelräder",9004,"A2012089",40921]
["Ost","Wanda","Ehrmann GmbH","Zugfedern",4831.87,"A2012048",40935]
["Ost","Uhl","Kramer GmbH","Kegelräder",9004,"A2012089",40940]
["Ost","Filzer","Pieper & Co.","Zugfedern",6542.32,"A2012019",40960]
["Ost","Filzer","Pollen GmbH","Kupplungen",1490.03,"A2012063",40961]
["Ost","Uhl","Lammer GmbH","Kupplungen",7903.66,"A2012078",40968]
["Ost","Uhl","Ross oHG","Wälzlager",1610.7,"A2012070",40972]
["Ost","Filzer","Pieper & Co.","Zugfedern",6542.32,"A2012019",40989]
["Ost","Wanda","Conen oHG & Co","Stirnräder",1712.06,"A2012084",40996]
["Ost","Gärtner","Dober & Sohn KG","Stirnräder",7357.75,"A2012027",41017]
["Ost","Gärtner","Ross oHG","Kettenglieder",1108.46,"A2012086",41032]
["Ost","Uhl","Lammer GmbH","Kupplungen",7903.66,"A2012078",41062]
["Ost","Gärtner","Bahr oHG","Wälzlager",8401.99,"A2012062",41125]
["Ost","Uhl","Ross oHG","Wälzlager",1610.7,"A2012070",41137]
["Ost","Wanda","Ross oHG","Nieten",3503.89,"A2012052",41141]
["Ost","Filzer","Pollen GmbH","Kupplungen",1490.03,"A2012099",41145]
["Ost","Wanda","Freimann KG","Gleitlager",6500.32,"A2012059",41180]
["Ost","Filzer","Pollen GmbH","Kupplungen",1490.03,"A2012099",41181]
["Ost","Wanda","Ross oHG","Gelenkbolzen",7264.24,"A2012061",41194]
["Ost","Uhl","Ross oHG","Wälzlager",1610.7,"A2012070",41209]
["Ost","Uhl","Lammer GmbH","Kupplungen",7903.66,"A2012078",41216]
["Ost","Gärtner","Bahr oHG","Wälzlager",8401.99,"A2012062",41218]
["Ost","Wanda","Ross oHG","Nieten",3503.89,"A2012052",41232]
["Ost","Filzer","Pollen GmbH","Kupplungen",1490.03,"A2012099",41239]
["Ost","Wanda","Ehrmann GmbH","Zugfedern",4831.87,"A2012048",41245]
["Süd","Lehrer","Anderer & Sohn","Zugfedern",120.56,"A2010094",40180]
["Süd","Sandmann","Hobel GmbH","Druckfedern",7921,"A2010002",40186]
["Süd","Weinreich","Dober & Sohn KG","Tellerfedern",1507.88,"A2010097",40192]
["Süd","Becker","Bartmann KG","Tellerfedern",3158.46,"A2010081",40214]
["Süd","Lehrer","Anderer & Sohn","Zugfedern",120.56,"A2010094",40215]
["Süd","Weinreich","Oppermann GmbH","Zahnräder",1354.86,"A2010044",40216]
["Süd","Brenner","Uhlmann GmbH","Kupplungen",3996.42,"A2010090",40217]
["Süd","Sandmann","Fischer GmbH","Gelenkbolzen",3098.73,"A2010035",40229]
["Süd","Amtmann","Philipps GmbH","Gelenkbolzen",7530.43,"A2010071",40231]
["Süd","Brenner","Uhlmann GmbH","Kupplungen",3996.42,"A2010090",40250]
["Süd","Amtmann","Münch GmbH","Tellerfedern",6005.31,"A2010026",40250]
["Süd","Sandmann","Asshoff KG","Zugfedern",5907.44,"A2010076",40260]
["Süd","Weinreich","Dober & Sohn KG","Tellerfedern",1507.88,"A2010097",40264]
["Süd","Brenner","Mütz GmbH","Metallschrauben",1434.65,"A2010030",40274]
["Süd","Amtmann","Rüther & Hübner","Dichtungen",2655.1,"A2010033",40274]
["Süd","Brenner","Uhlmann GmbH","Kupplungen",3996.42,"A2010090",40285]
["Süd","Weinreich","Bahr oHG","Kegelräder",4270,"A2010037",40288]
["Süd","Sandmann","Asshoff KG","Zugfedern",5907.44,"A2010076",40288]
["Süd","Lehrer","Dober & Sohn KG","Kupplungen",345.3,"A2010093",40293]
["Süd","Weinreich","Dober & Sohn KG","Tellerfedern",1507.88,"A2010097",40303]
["Süd","Weinreich","Dober & Sohn KG","Tellerfedern",1507.88,"A2010097",40319]
["Süd","Lehrer","Arnsberg GmbH","Kettenglieder",6410.88,"A2010066",40321]
["Süd","Brenner","Uhlmann GmbH","Kupplungen",3996.42,"A2010090",40323]
["Süd","Brenner","Uhlmann GmbH","Kupplungen",3996.42,"A2010090",40336]
["Süd","Sandmann","Anderer & Sohn","Vierkant",6116.29,"A2010045",40342]
["Süd","Lehrer","Anderer & Sohn","Zugfedern",120.56,"A2010094",40342]
["Süd","Brenner","Uhlmann GmbH","Kupplungen",3996.42,"A2010090",40344]
["Süd","Lehrer","Anderer & Sohn","Zugfedern",120.56,"A2010094",40346]
["Süd","Amtmann","Rüther & Hübner","Dichtungen",2655.1,"A2010033",40349]
["Süd","Weinreich","Oppermann GmbH","Zahnräder",1354.86,"A2010044",40350]
["Süd","Brenner","Mütz GmbH","Nieten",4573.59,"A2010032",40352]
["Süd","Weinreich","Bahr oHG","Kegelräder",4270,"A2010037",40352]
["Süd","Sandmann","Hobel GmbH","Druckfedern",7921,"A2010002",40356]
["Süd","Amtmann","Rüther & Hübner","Dichtungen",2655.1,"A2010033",40356]
["Süd","Brenner","Fischer GmbH","Zugfedern",4853.8599999999997,"A2010016",40359]
["Süd","Sandmann","Fischer GmbH","Gelenkbolzen",8757.64,"A2010003",40375]
["Süd","Amtmann","Philipps GmbH","Gelenkbolzen",7530.43,"A2010071",40384]
["Süd","Sandmann","Dunkel KG","Kegelräder",396.16,"A2010014",40385]
["Süd","Brenner","Uhlmann GmbH","Kupplungen",3996.42,"A2010090",40389]
["Süd","Sandmann","Tamm KG","Nieten",4433.58,"A2010021",40397]
["Süd","Becker","Bartmann KG","Tellerfedern",3158.46,"A2010081",40401]
["Süd","Weinreich","Oppermann GmbH","Zahnräder",1354.86,"A2010044",40413]
["Süd","Becker","Kramer GmbH","Gleitlager",1786.76,"A2010068",40414]
["Süd","Weinreich","Bahr oHG","Kegelräder",4270,"A2010037",40415]
["Süd","Sandmann","Dunkel KG","Kegelräder",396.16,"A2010014",40416]
["Süd","Lehrer","Arnsberg GmbH","Kettenglieder",6410.88,"A2010066",40417]
["Süd","Sandmann","Neibel GmbH & Co.","Tellerfedern",3051.55,"A2010005",40418]
["Süd","Sandmann","Asshoff KG","Zugfedern",5907.44,"A2010076",40436]
["Süd","Becker","Bartmann KG","Tellerfedern",3158.46,"A2010081",40443]
["Süd","Weinreich","Dober & Sohn KG","Tellerfedern",1507.88,"A2010097",40462]
["Süd","Amtmann","Philipps GmbH","Gelenkbolzen",7530.43,"A2010071",40467]
["Süd","Lehrer","Schulte & Sohn","Kegelräder",6988.13,"A2010050",40504]
["Süd","Lehrer","Arnsberg GmbH","Kettenglieder",6410.88,"A2010066",40506]
["Süd","Becker","Bartmann KG","Tellerfedern",3158.46,"A2010081",40521]
["Süd","Sandmann","Neibel GmbH & Co.","Tellerfedern",3051.55,"A2010005",40531]
["Süd","Weinreich","Bahr oHG","Kegelräder",4270,"A2010037",40538]
["Süd","Weinreich","Bahr oHG","Kegelräder",4270,"A2011037",40556]
["Süd","Lehrer","Arnsberg GmbH","Kettenglieder",6410.88,"A2011066",40556]
["Süd","Sandmann","Kortmann & Sohn","Druckfedern",3000.05,"A2011067",40557]
["Süd","Sandmann","Fischer GmbH","Gelenkbolzen",3098.73,"A2011035",40558]
["Süd","Sandmann","Fischer GmbH","Gelenkbolzen",3098.73,"A2011035",40562]
["Süd","Brenner","Mütz GmbH","Metallschrauben",1434.65,"A2011030",40565]
["Süd","Sandmann","Kortmann & Sohn","Druckfedern",3000.05,"A2011067",40566]
["Süd","Brenner","Uhlmann GmbH","Kupplungen",3996.42,"A2011090",40573]
["Süd","Sandmann","Tamm KG","Nieten",4433.58,"A2011021",40577]
["Süd","Sandmann","Anderer & Sohn","Vierkant",6116.29,"A2011045",40578]
["Süd","Brenner","Mütz GmbH","Nieten",4573.59,"A2011032",40594]
["Süd","Sandmann","Dunkel KG","Kegelräder",396.16,"A2011014",40615]
["Süd","Becker","Kramer GmbH","Gleitlager",1786.76,"A2011068",40633]
["Süd","Brenner","Uhlmann GmbH","Kupplungen",3996.42,"A2011090",40668]
["Süd","Brenner","Mütz GmbH","Nieten",4573.59,"A2011032",40671]
["Süd","Brenner","Uhlmann GmbH","Kupplungen",3996.42,"A2011090",40716]
["Süd","Weinreich","Oppermann GmbH","Zahnräder",1354.86,"A2011044",40721]
["Süd","Sandmann","Fischer GmbH","Gelenkbolzen",8757.64,"A2011003",40723]
["Süd","Brenner","Uhlmann GmbH","Kupplungen",3996.42,"A2011090",40746]
["Süd","Sandmann","Neibel GmbH & Co.","Tellerfedern",3051.55,"A2011005",40759]
["Süd","Sandmann","Friedrichs GmbH","Zahnräder",1104.6400000000001,"A2011010",40760]
["Süd","Lehrer","Schulte & Sohn","Kegelräder",6988.13,"A2011050",40765]
["Süd","Brenner","Mütz GmbH","Nieten",4573.59,"A2011032",40775]
["Süd","Lehrer","Dober & Sohn KG","Kupplungen",345.3,"A2011093",40782]
["Süd","Weinreich","Bahr oHG","Kegelräder",4270,"A2011037",40787]
["Süd","Sandmann","Neibel GmbH & Co.","Tellerfedern",3051.55,"A2011005",40791]
["Süd","Amtmann","Philipps GmbH","Gelenkbolzen",7530.43,"A2011071",40796]
["Süd","Brenner","Uhlmann GmbH","Kupplungen",3996.42,"A2011090",40805]
["Süd","Sandmann","Asshoff KG","Zugfedern",5907.44,"A2011076",40824]
["Süd","Sandmann","Friedrichs GmbH","Zahnräder",1104.6400000000001,"A2011010",40829]
["Süd","Sandmann","Dunkel KG","Kegelräder",396.16,"A2011014",40830]
["Süd","Brenner","Uhlmann GmbH","Kupplungen",3996.42,"A2011090",40833]
["Süd","Lehrer","Schulte & Sohn","Kegelräder",6988.13,"A2011050",40843]
["Süd","Sandmann","Tamm KG","Nieten",4433.58,"A2011021",40855]
["Süd","Weinreich","Oppermann GmbH","Zahnräder",1354.86,"A2011044",40867]
["Süd","Sandmann","Hobel GmbH","Druckfedern",7921,"A2011002",40870]
["Süd","Weinreich","Bahr oHG","Kegelräder",4270,"A2011037",40876]
["Süd","Brenner","Uhlmann GmbH","Kupplungen",3996.42,"A2011090",40877]
["Süd","Amtmann","Rüther & Hübner","Dichtungen",2655.1,"A2011033",40891]
["Süd","Becker","Kramer GmbH","Gleitlager",1786.76,"A2011068",40899]
["Süd","Brenner","Uhlmann GmbH","Kupplungen",3996.42,"A2011090",40907]
["Süd","Lehrer","Dober & Sohn KG","Kupplungen",345.3,"A2011093",40908]
["Süd","Sandmann","Friedrichs GmbH","Zahnräder",1104.6400000000001,"A2012010",40921]
["Süd","Sandmann","Anderer & Sohn","Vierkant",6116.29,"A2012045",40927]
["Süd","Amtmann","Münch GmbH","Tellerfedern",6005.31,"A2012026",40927]
["Süd","Brenner","Uhlmann GmbH","Kupplungen",3996.42,"A2012090",40968]
["Süd","Brenner","Uhlmann GmbH","Kupplungen",3996.42,"A2012090",40974]
["Süd","Lehrer","Anderer & Sohn","Zugfedern",120.56,"A2012094",40976]
["Süd","Amtmann","Philipps GmbH","Gelenkbolzen",7530.43,"A2012071",40981]
["Süd","Brenner","Uhlmann GmbH","Kupplungen",3996.42,"A2012090",40988]
["Süd","Weinreich","Dober & Sohn KG","Tellerfedern",1507.88,"A2012097",40999]
["Süd","Lehrer","Schulte & Sohn","Kegelräder",6988.13,"A2012050",41003]
["Süd","Weinreich","Bahr oHG","Kegelräder",4270,"A2012037",41023]
["Süd","Sandmann","Asshoff KG","Zugfedern",5907.44,"A2012076",41029]
["Süd","Brenner","Uhlmann GmbH","Kupplungen",3996.42,"A2012090",41033]
["Süd","Becker","Kramer GmbH","Gleitlager",1786.76,"A2012068",41043]
["Süd","Lehrer","Schulte & Sohn","Kegelräder",6988.13,"A2012050",41057]
["Süd","Brenner","Uhlmann GmbH","Kupplungen",3996.42,"A2012090",41073]
["Süd","Sandmann","Anderer & Sohn","Vierkant",6116.29,"A2012045",41079]
["Süd","Weinreich","Dober & Sohn KG","Tellerfedern",1507.88,"A2012097",41083]
["Süd","Sandmann","Anderer & Sohn","Vierkant",6116.29,"A2012045",41129]
["Süd","Sandmann","Kortmann & Sohn","Druckfedern",3000.05,"A2012067",41133]
["Süd","Sandmann","Tamm KG","Nieten",4433.58,"A2012021",41133]
["Süd","Sandmann","Kortmann & Sohn","Druckfedern",3000.05,"A2012067",41135]
["Süd","Amtmann","Münch GmbH","Tellerfedern",6005.31,"A2012026",41144]
["Süd","Brenner","Uhlmann GmbH","Kupplungen",3996.42,"A2012090",41154]
["Süd","Brenner","Fischer GmbH","Zugfedern",4853.8599999999997,"A2012016",41155]
["Süd","Sandmann","Fischer GmbH","Gelenkbolzen",3098.73,"A2012035",41161]
["Süd","Brenner","Fischer GmbH","Zugfedern",4853.8599999999997,"A2012016",41170]
["Süd","Becker","Bartmann KG","Tellerfedern",3158.46,"A2012081",41173]
["Süd","Sandmann","Fischer GmbH","Gelenkbolzen",8757.64,"A2012003",41174]
["Süd","Lehrer","Dober & Sohn KG","Kupplungen",345.3,"A2012093",41176]
["Süd","Sandmann","Fischer GmbH","Gelenkbolzen",8757.64,"A2012003",41177]
["Süd","Brenner","Uhlmann GmbH","Kupplungen",3996.42,"A2012090",41183]
["Süd","Brenner","Mütz GmbH","Metallschrauben",1434.65,"A2012030",41201]
["Süd","Brenner","Uhlmann GmbH","Kupplungen",3996.42,"A2012090",41201]
["Süd","Amtmann","Münch GmbH","Tellerfedern",6005.31,"A2012026",41207]
["Süd","Lehrer","Dober & Sohn KG","Kupplungen",345.3,"A2012093",41213]
["Süd","Brenner","Mütz GmbH","Metallschrauben",1434.65,"A2012030",41220]
["Süd","Brenner","Fischer GmbH","Zugfedern",4853.8599999999997,"A2012016",41239]
["Süd","Brenner","Uhlmann GmbH","Kupplungen",3996.42,"A2012090",41243]
["Süd","Sandmann","Friedrichs GmbH","Zahnräder",1104.6400000000001,"A2012010",41250]
["Süd","Sandmann","Hobel GmbH","Druckfedern",7921,"A2012002",41252]
["Süd","Brenner","Uhlmann GmbH","Kupplungen",3996.42,"A2012090",41253]
["Süd","Brenner","Uhlmann GmbH","Kupplungen",3996.42,"A2012090",41256]
["West","Weber","Rühring GmbH","Metallschrauben",7767.45,"A2010043",40179]
["West","Holzer","Enkel & Nachfolger","Metallschrauben",9529.23,"A2010008",40188]
["West","Weber","Assmann GmbH","Metallschrauben",2575.39,"A2010080",40196]
["West","Renner","Kortmann & Sohn","Kegelräder",5028.8500000000004,"A2010100",40197]
["West","Weber","Pollen GmbH","Gleitlager",7891.77,"A2010020",40199]
["West","Bauer","Zimmermann oHG","Dichtungen",9322.6299999999992,"A2010051",40199]
["West","Näher","Brommel GmbH","Gleitlager",2191.89,"A2010034",40208]
["West","Bauer","Neibel GmbH & Co.","Gleitlager",2844.86,"A2010017",40212]
["West","Weber","Fricke & Söhne","Tellerfedern",7767,"A2010095",40212]
["West","Holzer","Enkel & Nachfolger","Metallschrauben",9529.23,"A2010008",40213]
["West","Näher","Ehrmann GmbH","Druckfedern",3259.29,"A2010096",40222]
["West","Näher","Jung & Alt KG","Zahnräder",6641.73,"A2010047",40232]
["West","Bauer","Neibel GmbH & Co.","Gleitlager",2844.86,"A2010017",40232]
["West","Holzer","Kramer GmbH","Gelenkbolzen",5332.46,"A2010098",40242]
["West","Renner","Dober & Sohn KG","Kupplungen",4504.58,"A2010069",40243]
["West","Holzer","Friedrichs GmbH","Kettenglieder",5910.87,"A2010007",40253]
["West","Näher","Arnsberg GmbH","Metallschrauben",9402.39,"A2010053",40256]
["West","Weber","Pollen GmbH","Gleitlager",7891.77,"A2010020",40263]
["West","Bauer","Neibel GmbH & Co.","Gleitlager",2844.86,"A2010017",40273]
["West","Renner","Kortmann & Sohn","Kegelräder",5028.8500000000004,"A2010100",40281]
["West","Bauer","Ross oHG","Zugfedern",6314.17,"A2010091",40286]
["West","Bauer","Jung & Alt KG","Gelenkbolzen",5785.48,"A2010056",40291]
["West","Bauer","Ross oHG","Zugfedern",6314.17,"A2010091",40297]
["West","Näher","Jung & Alt KG","Zahnräder",6641.73,"A2010047",40308]
["West","Holzer","Nobel GmbH","Gelenkbolzen",924.62,"A2010064",40315]
["West","Näher","Freimann KG","Metallschrauben",1141.1099999999999,"A2010082",40320]
["West","Holzer","Enkel & Nachfolger","Metallschrauben",9529.23,"A2010008",40331]
["West","Weber","Fricke & Söhne","Tellerfedern",7767,"A2010095",40358]
["West","Näher","Schnieder KG","Nieten",9630.17,"A2010057",40359]
["West","Bauer","Jung & Alt KG","Gelenkbolzen",5785.48,"A2010056",40365]
["West","Holzer","Friedrichs GmbH","Kettenglieder",5910.87,"A2010007",40365]
["West","Weber","Assmann GmbH","Metallschrauben",2575.39,"A2010080",40367]
["West","Näher","Freimann KG","Metallschrauben",1141.1099999999999,"A2010082",40376]
["West","Holzer","Nobel GmbH","Gelenkbolzen",924.62,"A2010064",40388]
["West","Weber","Dunkel KG","Druckfedern",919.75,"A2010072",40388]
["West","Renner","Uhlmann GmbH","Wälzlager",637.5,"A2010018",40411]
["West","Näher","Arnsberg GmbH","Metallschrauben",9402.39,"A2010053",40420]
["West","Bauer","Jung & Alt KG","Gelenkbolzen",5785.48,"A2010056",40429]
["West","Holzer","Lange & Partner","Zahnräder",3637.8,"A2010009",40430]
["West","Weber","Hofer oHG","Wälzlager",148.02000000000001,"A2010054",40436]
["West","Holzer","Neibel GmbH & Co.","Stirnräder",6954.07,"A2010036",40437]
["West","Näher","Arnsberg GmbH","Metallschrauben",9402.39,"A2010053",40439]
["West","Weber","Uhlmann GmbH","Stirnräder",5407.87,"A2010041",40443]
["West","Bauer","Fahrer GmbH","Stirnräder",482.42,"A2010055",40450]
["West","Weber","Dunkel KG","Druckfedern",919.75,"A2010072",40451]
["West","Näher","Menge KG","Zahnräder",3531.05,"A2010092",40467]
["West","Bauer","Zimmermann oHG","Dichtungen",9322.6299999999992,"A2010051",40475]
["West","Renner","Uhlmann GmbH","Wälzlager",637.5,"A2010018",40478]
["West","Weber","Uhlmann GmbH","Stirnräder",5407.87,"A2010041",40488]
["West","Bauer","Fahrer GmbH","Stirnräder",482.42,"A2010055",40489]
["West","Holzer","Friedrichs GmbH","Kettenglieder",5910.87,"A2010007",40489]
["West","Näher","Bartmann KG","Vierkant",2244.86,"A2010079",40490]
["West","Holzer","Kramer GmbH","Gelenkbolzen",5332.46,"A2010098",40490]
["West","Weber","Assmann GmbH","Metallschrauben",2575.39,"A2010080",40496]
["West","Holzer","Lange & Partner","Zahnräder",3637.8,"A2010009",40498]
["West","Holzer","Anderer & Sohn","Druckfedern",4031.58,"A2010022",40507]
["West","Bauer","Jung & Alt KG","Gelenkbolzen",5785.48,"A2010056",40522]
["West","Holzer","Lange & Partner","Zahnräder",3637.8,"A2010009",40541]
["West","Holzer","Neibel GmbH & Co.","Stirnräder",6954.07,"A2011036",40548]
["West","Holzer","Kramer GmbH","Gelenkbolzen",5332.46,"A2011098",40560]
["West","Näher","Bartmann KG","Vierkant",2244.86,"A2011079",40564]
["West","Renner","Dober & Sohn KG","Kupplungen",4504.58,"A2011069",40569]
["West","Bauer","Fricke & Söhne","Dichtungen",4949.54,"A2011001",40569]
["West","Weber","Dunkel KG","Druckfedern",919.75,"A2011072",40593]
["West","Näher","Bartmann KG","Vierkant",2244.86,"A2011079",40599]
["West","Weber","Fricke & Söhne","Tellerfedern",7767,"A2011095",40603]
["West","Bauer","Jung & Alt KG","Gelenkbolzen",5785.48,"A2011056",40632]
["West","Näher","Brommel GmbH","Gleitlager",2191.89,"A2011034",40637]
["West","Näher","Menge KG","Zahnräder",3531.05,"A2011092",40638]
["West","Näher","Schnieder KG","Nieten",9630.17,"A2011057",40649]
["West","Näher","Brommel GmbH","Gleitlager",2191.89,"A2011034",40652]
["West","Bauer","Zimmermann oHG","Dichtungen",9322.6299999999992,"A2011051",40656]
["West","Bauer","Ross oHG","Zugfedern",6314.17,"A2011091",40656]
["West","Weber","Fricke & Söhne","Tellerfedern",7767,"A2011095",40657]
["West","Näher","Brommel GmbH","Gleitlager",2191.89,"A2011034",40660]
["West","Bauer","Ross oHG","Zugfedern",6314.17,"A2011091",40661]
["West","Holzer","Kramer GmbH","Gelenkbolzen",5332.46,"A2011098",40674]
["West","Holzer","Kramer GmbH","Gelenkbolzen",5332.46,"A2011098",40676]
["West","Weber","Rühring GmbH","Vierkant",7767.45,"A2011043",40680]
["West","Holzer","Kramer GmbH","Gelenkbolzen",5332.46,"A2011098",40686]
["West","Holzer","Neibel GmbH & Co.","Stirnräder",6954.07,"A2011036",40697]
["West","Renner","Kortmann & Sohn","Kegelräder",5028.8500000000004,"A2011100",40705]
["West","Näher","Menge KG","Zahnräder",3531.05,"A2011092",40709]
["West","Weber","Pollen GmbH","Gleitlager",7891.77,"A2011020",40734]
["West","Bauer","Fricke & Söhne","Dichtungen",4949.54,"A2011001",40736]
["West","Näher","Bartmann KG","Vierkant",2244.86,"A2011079",40738]
["West","Weber","Hofer oHG","Wälzlager",148.02000000000001,"A2011054",40759]
["West","Holzer","Anderer & Sohn","Druckfedern",4031.58,"A2011022",40774]
["West","Bauer","Zimmermann oHG","Dichtungen",9322.6299999999992,"A2011051",40777]
["West","Renner","Uhlmann GmbH","Wälzlager",637.5,"A2011018",40787]
["West","Näher","Jung & Alt KG","Zahnräder",6641.73,"A2011047",40796]
["West","Weber","Rühring GmbH","Vierkant",7767.45,"A2011043",40810]
["West","Weber","Dunkel KG","Druckfedern",919.75,"A2011072",40811]
["West","Bauer","Zimmermann oHG","Dichtungen",9322.6299999999992,"A2011051",40811]
["West","Bauer","Fahrer GmbH","Stirnräder",482.42,"A2011055",40823]
["West","Näher","Ehrmann GmbH","Druckfedern",3259.29,"A2011096",40834]
["West","Näher","Arnsberg GmbH","Metallschrauben",9402.39,"A2011053",40850]
["West","Weber","Hofer oHG","Wälzlager",148.02000000000001,"A2011054",40850]
["West","Näher","Jung & Alt KG","Zahnräder",6641.73,"A2011047",40866]
["West","Näher","Arnsberg GmbH","Metallschrauben",9402.39,"A2011053",40868]
["West","Bauer","Ross oHG","Zugfedern",6314.17,"A2011091",40870]
["West","Näher","Ehrmann GmbH","Druckfedern",3259.29,"A2011096",40872]
["West","Holzer","Enkel & Nachfolger","Metallschrauben",9529.23,"A2011008",40875]
["West","Holzer","Neibel GmbH & Co.","Stirnräder",6954.07,"A2011036",40888]
["West","Renner","Kortmann & Sohn","Kegelräder",5028.8500000000004,"A2011100",40888]
["West","Näher","Bartmann KG","Vierkant",2244.86,"A2011079",40891]
["West","Näher","Freimann KG","Metallschrauben",1141.1099999999999,"A2011082",40899]
["West","Holzer","Lange & Partner","Zahnräder",3637.8,"A2012009",40916]
["West","Näher","Jung & Alt KG","Zahnräder",6641.73,"A2012047",40929]
["West","Weber","Fricke & Söhne","Tellerfedern",7767,"A2012095",40942]
["West","Weber","Rühring GmbH","Vierkant",7767.45,"A2012043",40943]
["West","Renner","Uhlmann GmbH","Wälzlager",637.5,"A2012018",40946]
["West","Näher","Ehrmann GmbH","Druckfedern",3259.29,"A2012096",40947]
["West","Holzer","Friedrichs GmbH","Kettenglieder",5910.87,"A2012007",40948]
["West","Weber","Assmann GmbH","Metallschrauben",2575.39,"A2012080",40961]
["West","Weber","Hofer oHG","Wälzlager",148.02000000000001,"A2012054",40972]
["West","Bauer","Fahrer GmbH","Stirnräder",482.42,"A2012055",40983]
["West","Weber","Dunkel KG","Druckfedern",919.75,"A2012072",41020]
["West","Weber","Uhlmann GmbH","Stirnräder",5407.87,"A2012041",41027]
["West","Weber","Hofer oHG","Wälzlager",148.02000000000001,"A2012054",41029]
["West","Weber","Uhlmann GmbH","Stirnräder",5407.87,"A2012041",41037]
["West","Bauer","Neibel GmbH & Co.","Gleitlager",2844.86,"A2012017",41049]
["West","Näher","Freimann KG","Metallschrauben",1141.1099999999999,"A2012082",41049]
["West","Näher","Menge KG","Zahnräder",3531.05,"A2012092",41055]
["West","Renner","Kortmann & Sohn","Kegelräder",5028.8500000000004,"A2012100",41058]
["West","Renner","Dober & Sohn KG","Kupplungen",4504.58,"A2012069",41076]
["West","Näher","Menge KG","Zahnräder",3531.05,"A2012092",41099]
["West","Holzer","Kramer GmbH","Gelenkbolzen",5332.46,"A2012098",41107]
["West","Näher","Freimann KG","Metallschrauben",1141.1099999999999,"A2012082",41124]
["West","Bauer","Fahrer GmbH","Stirnräder",482.42,"A2012055",41125]
["West","Holzer","Nobel GmbH","Gelenkbolzen",924.62,"A2012064",41135]
["West","Renner","Kortmann & Sohn","Kegelräder",5028.8500000000004,"A2012100",41152]
["West","Holzer","Anderer & Sohn","Druckfedern",4031.58,"A2012022",41164]
["West","Weber","Pollen GmbH","Gleitlager",7891.77,"A2012020",41171]
["West","Bauer","Fricke & Söhne","Dichtungen",4949.54,"A2012001",41172]
["West","Bauer","Ross oHG","Zugfedern",6314.17,"A2012091",41188]
["West","Weber","Assmann GmbH","Metallschrauben",2575.39,"A2012080",41189]
["West","Näher","Ehrmann GmbH","Druckfedern",3259.29,"A2012096",41192]
["West","Bauer","Fricke & Söhne","Dichtungen",4949.54,"A2012001",41200]
["West","Weber","Uhlmann GmbH","Stirnräder",5407.87,"A2012041",41204]
["West","Renner","Dober & Sohn KG","Kupplungen",4504.58,"A2012069",41215]
["West","Holzer","Anderer & Sohn","Druckfedern",4031.58,"A2012022",41218]
["West","Näher","Schnieder KG","Nieten",9630.17,"A2012057",41243]
["West","Renner","Dober & Sohn KG","Kupplungen",4504.58,"A2012069",41247]
["West","Weber","Rühring GmbH","Vierkant",7767.45,"A2012043",41249]
["West","Holzer","Nobel GmbH","Gelenkbolzen",924.62,"A2012064",41267]

{"sheet":"Umsatzprognose","index":7,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Umsatzsumme"]
["Produktkategorie","Ergebnis","Prognosen","voraus. Umsatz"]
["Dichtungen",132258.91,0.05,{"$f":"Ergebnis*(1+Prognosen)","v":138871.85550000001}]
["Druckfedern",151742.50000000003,0.08,163881.90000000005]
["Gelenkbolzen",258360.44,-0.02,253193.23120000001]
["Gleitlager",104677.75000000003,-0.04,100490.64000000003]
["Kegelräder",163886.39000000007,0.03,168802.98170000009]
["Kettenglieder",58035.420000000013,-7.0000000000000007E-2,53972.940600000009]
["Kupplungen",233169.82000000012,-0.01,230838.12180000011]
["Metallschrauben",138024.74,0.02,140785.23480000001]
["Nieten",82438.64,-0.09,75019.162400000001]
["Stirnräder",225915.56000000006,0.1,248507.11600000007]
["Tellerfedern",112000.05,0.04,116480.05200000001]
["Vierkant",72875.549999999988,-0.04,69960.527999999991]
["Wälzlager",118659.88000000003,0.08,128152.67040000005]
["Zahnräder",107384.52,0.15,123492.19799999999]
["Zugfedern",248711.67000000004,0.02,253685.90340000004]
["Gesamtergebnis",2208141.8400000008,null,{"$f":"SUM(D5:D19)","v":2266134.5358000007}]

{"sheet":"Kundenumsätze","index":8,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["Kunde","(Alle)"]
["Region","(Alle)"]
[]
["Summe von Umsatz","Jahre"]
["Produktkategorie","2010","2011","2012","Gesamtergebnis"]
["Dichtungen",56267.819999999992,59266.27,16724.82,132258.91]
["Druckfedern",41790.11,45736.990000000005,64215.400000000016,151742.50000000003]
["Gelenkbolzen",126254.93,80424.980000000025,51680.530000000006,258360.44000000003]
["Gleitlager",47797.729999999996,33893.24,22986.78,104677.75]
["Kegelräder",61930.15,55644.28,46311.96,163886.38999999998]
["Kettenglieder",40785.230000000003,8627.7999999999993,8622.39,58035.42]
["Kupplungen",58882.74,57630.679999999993,116656.4,233169.81999999998]
["Metallschrauben",81207.179999999993,44586.75,12230.81,138024.74]
["Nieten",25645.119999999999,35721.99,21071.53,82438.64]
["Stirnräder",89820.56,86508.5,49586.500000000007,225915.56]
["Tellerfedern",54169.740000000005,25873.16,31957.15,112000.05000000002]
["Vierkant",8361.15,30630.63,33883.769999999997,72875.549999999988]
["Wälzlager",40702.939999999995,36791.669999999991,41165.269999999997,118659.87999999998]
["Zahnräder",43333.700000000012,32958.699999999997,31092.12,107384.52]
["Zugfedern",103875.84999999999,74308.040000000008,70527.78,248711.67]
["Gesamtergebnis",880824.95000000007,708603.68,618713.21000000008,2208141.8400000003]

{"sheet":"Produktumsätze","index":9,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Werte"]
["Produktkategorie","Umsatzsumme","Umsatzanzahl","Umsatzanteil","Umsatzanteil von GB"]
["Dichtungen",132258.91,26,5.9896020991115288E-2,0.51191625931586127]
["Druckfedern",151742.50000000003,36,6.8719543849592529E-2,0.58732869474908789]
["Gelenkbolzen",258360.44,42,0.11700355263410064,1]
["Gleitlager",104677.75000000003,25,4.7405355989269225E-2,0.40516168032536259]
["Kegelräder",163886.39000000007,30,7.4219140741429893E-2,0.6343323691506334]
["Kettenglieder",58035.420000000013,17,2.628246924572562E-2,0.22462966853594155]
["Kupplungen",233169.82000000012,64,0.1055954901882571,0.90249815335505745]
["Metallschrauben",138024.74,32,6.2507189302658167E-2,0.53423325955010759]
["Nieten",82438.64,16,3.7333942279722372E-2,0.31908383497101955]
["Stirnräder",225915.56000000006,51,0.10231025738817572,0.87442009310713376]
["Tellerfedern",112000.05,30,5.0721402027326258E-2,0.43350309358507055]
["Vierkant",72875.549999999988,14,3.3003110887115814E-2,0.28206930596650165]
["Wälzlager",118659.88000000003,33,5.3737435635022417E-2,0.45928037589655768]
["Zahnräder",107384.52,31,4.8631169454223078E-2,0.4156384003681059]
["Zugfedern",248711.67000000004,53,0.11263391938626546,0.96265384127693865]
["Gesamtergebnis",2208141.8400000012,500,1]

{"sheet":"Einzelpositionen","index":10,"n_rows":43,"n_cols":7,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["Region","Verkäufer","Kunde","Produktkategorie","Umsatz","Auftragsnummer","Auftragseingang"]
["West","Holzer","Nobel GmbH","Gelenkbolzen",924.62,"A2012064",41267]
["West","Holzer","Nobel GmbH","Gelenkbolzen",924.62,"A2012064",41135]
["West","Holzer","Kramer GmbH","Gelenkbolzen",5332.46,"A2012098",41107]
["West","Holzer","Kramer GmbH","Gelenkbolzen",5332.46,"A2011098",40686]
["West","Holzer","Kramer GmbH","Gelenkbolzen",5332.46,"A2011098",40676]
["West","Holzer","Kramer GmbH","Gelenkbolzen",5332.46,"A2011098",40674]
["West","Bauer","Jung & Alt KG","Gelenkbolzen",5785.48,"A2011056",40632]
["West","Holzer","Kramer GmbH","Gelenkbolzen",5332.46,"A2011098",40560]
["Nord","Lehmann","Freimann KG","Gelenkbolzen",9090.15,"A2010087",40266]
["West","Bauer","Jung & Alt KG","Gelenkbolzen",5785.48,"A2010056",40522]
["West","Holzer","Kramer GmbH","Gelenkbolzen",5332.46,"A2010098",40490]
["West","Bauer","Jung & Alt KG","Gelenkbolzen",5785.48,"A2010056",40429]
["West","Holzer","Nobel GmbH","Gelenkbolzen",924.62,"A2010064",40388]
["West","Bauer","Jung & Alt KG","Gelenkbolzen",5785.48,"A2010056",40365]
["Nord","Holzmann","Enkel & Nachfolger","Gelenkbolzen",7205.5,"A2010058",40304]
["West","Holzer","Nobel GmbH","Gelenkbolzen",924.62,"A2010064",40315]
["Nord","Holzmann","Enkel & Nachfolger","Gelenkbolzen",7205.5,"A2010058",40316]
["West","Bauer","Jung & Alt KG","Gelenkbolzen",5785.48,"A2010056",40291]
["West","Holzer","Kramer GmbH","Gelenkbolzen",5332.46,"A2010098",40242]
["Nord","Lehmann","Freimann KG","Gelenkbolzen",9090.15,"A2010087",40332]
["Süd","Sandmann","Fischer GmbH","Gelenkbolzen",8757.64,"A2012003",41177]
["Süd","Sandmann","Fischer GmbH","Gelenkbolzen",8757.64,"A2012003",41174]
["Süd","Sandmann","Fischer GmbH","Gelenkbolzen",3098.73,"A2012035",41161]
["Süd","Amtmann","Philipps GmbH","Gelenkbolzen",7530.43,"A2012071",40981]
["Süd","Amtmann","Philipps GmbH","Gelenkbolzen",7530.43,"A2011071",40796]
["Süd","Sandmann","Fischer GmbH","Gelenkbolzen",8757.64,"A2011003",40723]
["Süd","Sandmann","Fischer GmbH","Gelenkbolzen",3098.73,"A2011035",40562]
["Süd","Sandmann","Fischer GmbH","Gelenkbolzen",3098.73,"A2011035",40558]
["Süd","Amtmann","Philipps GmbH","Gelenkbolzen",7530.43,"A2010071",40467]
["Süd","Amtmann","Philipps GmbH","Gelenkbolzen",7530.43,"A2010071",40384]
["Süd","Sandmann","Fischer GmbH","Gelenkbolzen",8757.64,"A2010003",40375]
["Süd","Amtmann","Philipps GmbH","Gelenkbolzen",7530.43,"A2010071",40231]
["Süd","Sandmann","Fischer GmbH","Gelenkbolzen",3098.73,"A2010035",40229]
["Ost","Wanda","Ross oHG","Gelenkbolzen",7264.24,"A2012061",41194]
["Ost","Wanda","Ross oHG","Gelenkbolzen",7264.24,"A2011061",40785]
["Ost","Wanda","Ross oHG","Gelenkbolzen",7264.24,"A2011061",40557]
["Ost","Wanda","Ross oHG","Gelenkbolzen",7264.24,"A2010061",40200]
["Nord","Lehmann","Freimann KG","Gelenkbolzen",9090.15,"A2012087",41114]
["Nord","Holzmann","Enkel & Nachfolger","Gelenkbolzen",7205.5,"A2011058",40874]
["Nord","Lehmann","Freimann KG","Gelenkbolzen",9090.15,"A2011087",40619]
["Nord","Holzmann","Enkel & Nachfolger","Gelenkbolzen",7205.5,"A2010058",40534]
["Nord","Lehmann","Freimann KG","Gelenkbolzen",9090.15,"A2010087",40512]