{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Start","Installation","Bestellungen (1)","Bestellungen (2)","Artikel","Kunden","Datenmodell","Pivot-Tabelle (2)","Bestellungen (3)","Pivot-Tabelle (3) + DAX","Pivot-Tabelle (3) + KPIs","Bestellungen (A)","Artikel (A)","Kunden (A)","Pivot-Tabelle (A)"],"not_rendered":{"charts":0,"images":16,"macros":1,"external_links":0,"defined_names":6,"comments":0,"pivot_tables":3},"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":"Start","index":0,"n_rows":20,"n_cols":9,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,4],[2,1,2,4],[5,5,33,5],[5,6,33,6]]}
[null,null,null,null,null,1,2,null,0]
[1,"Start"]
[2,"Start"]
[]
[0,null,null,2,0]
[null,null,"Start",null,null,"For many basic Excel techniques, which are used here in this file, there are detailed explanations in the file \"Excel-Basics\".\n\nTherefore - if here in this file it is said \"Do this … and that …\" and you don't know how to do it - please have a look into the file \"Excel-Basics\". Hopefully you will find the needed explanations there. \n\nIf not - send me a short notice to stern@jade-hs.de!\n\nBefore you start working with this file you should definitely work through the two sheets \"How to make notes\" and \"Help ...\" in the file \"Excel-Basics\"!\n\nIf the buttons for language switching don't work, please click the following:\n\nFile / Options / Trust Center / Trust Center Settings / Macro Settings / Enable All Macros \n\nThen close and re-open this file again.","Zu vielen grundlegenen Excel-Techniken, die hier in dieser Datei benutzt werden, gibt es detaillierte Erläuterungen in der Datei \"Excel-Basics\".\n\nWenn es daher in dieser Datei heißt \"Machen Sie dieses … und jenes …\" und Sie wissen nicht wie - sehen Sie bitte in der Datei \"Excel-Basics\" nach. Hoffentlich finden Sie dort die benötigten Erklärungen.\n\nWenn nicht - schicken Sie mir bitte einen Hinweis an stern@jade-hs.de!\n\nBevor Sie beginnen, mit dieser Datei zu arbeiten, sollten Sie aber auf jeden Fall zuerst die beiden Blätter \"Notizen machen\" und \"Hilfe ...\" in der Datei \"Excel-Basics\" durchgearbeitet haben!\n\nWenn die Buttons zur Sprachumschaltung nicht funktionieren, klicken Sie bitte folgendes an:\n\nDatei / Optionen / Trust-Center / Einstellungen für das Trust-Center / Makroeinstellungen / Alle Makros aktivieren\n\nDann diese Datei schließen und erneut öffnen."]
[null,null,"Installation"]
[null,null,"Bestellungen (1)"]
[null,null,"Bestellungen (2)"]
[null,null,"Artikel"]
[null,null,"Kunden"]
[null,null,"Datenmodell"]
[null,null,"Pivot-Tabelle (2)"]
[null,null,"Bestellungen (3)"]
[null,null,"Pivot-Tabelle (3) + DAX"]
[null,null,"Pivot-Tabelle (3) + KPIs"]
[null,null,"Bestellungen (A)"]
[null,null,"Artikel (A)"]
[null,null,"Kunden (A)"]
[null,null,"Pivot-Tabelle (A)"]

{"sheet":"Installation","index":1,"n_rows":42,"n_cols":6,"rows_kept":42,"cut":false,"hidden":false,"merged":[[21,2,23,8],[1,1,1,4],[2,1,2,4],[18,2,20,8],[4,2,10,8],[11,2,16,8]]}
[null,null,null,null,null,0]
[1,"Installation",null,null,null,"Back to Start"]
[2,"Installation",null,null,null,"Startseite"]
[]
[2,null,"PowerPivot ist ein Excel-Add-In, das evtl. extra installiert werden muss. Es bietet erweiterte Möglichkeiten zur Bearbeitung und Auswertung von Datenlisten mittels Pivot-Tabellen. Dazu wird ein sog. Datenmodell erstellt, das Access-Benutzern bekannt sein dürfte. Zur Datenauswertung gibt es spezielle, Excel-ähnliche Befehle, die DAX (\"Data Analysis Expression\") genannt werden. Es können auch KPI's (\"Key Performance Indicators\" = Kennzahlen) definiert und berechnet werden. "]
[2]
[2]
[2]
[2]
[2]
[2]
[1,null,"PowerPivot is an Excel add-in that may need to be installed separately. It offers extended options for editing and evaluating data lists using Pivot tables. For this purpose, a so-called data model is created, which should be known to Access users. For data evaluation there are special Excel-like commands called DAX (\"Data Analysis Expression\"). KPI's (\"Key Performance Indicators\") can also be defined and calculated."]
[1]
[1]
[1]
[1]
[1]
[]
[2,null,"\"Datei\" / \"Optionen\" / \"Add-Ins\"\n\"Verwalten: COM-Add-Ins\" + \"Los ...\"\n\"Microsoft Power Pivot for Excel\" + \"OK\""]
[2]
[2]
[1,null,"\"File\" / \"Options\" / \"Add-Ins\"\n\"Manage: COM-Add-Ins\" + \"Go ...\"\n\"Microsoft Power Pivot for Excel\" + \"OK\""]
[1]
[1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[0]

{"sheet":"Bestellungen (1)","index":2,"n_rows":160,"n_cols":16,"rows_kept":160,"cut":false,"hidden":false,"merged":[[1,1,1,4],[2,1,2,4],[4,2,13,7],[14,2,22,7]]}
[null,null,null,null,null,0]
[1,"Orders (1)",null,null,null,"Back to Start"]
[2,"Bestellungen (1)",null,null,null,"Startseite"]
[]
[2,null,"Wenn eine Datenliste vorliegt wie hier auf diesem Blatt, können Sie daraus direkt eine Pivot-Tabelle erstellen. Dabei werden die Spaltenüberschriften zu PivotTable-Feldern.\n\nEs kann aber auch sein, dass mehrere getrennte Datenlisten vorliegen (siehe die nächsten drei Blätter). Wenn dann zwischen den Listen eindeutige Beziehungen bestehen (z.B. \"Zu EINER Bestellung gehören EIN Kunde und EIN Artikel.\"), müssen Sie die Listen \n\n(1) entweder erst mittels SVERWEIS() zu einer Liste zusammenfassen \n(2) oder Sie setzen PowerPivot ein."]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[1,null,"If there is a data list like on this sheet, you can create a PivotTable from it directly. Then the column headers become PivotTable fields.\n\nBut may be, that there are several different data lists (see the next three sheets). If there are one-to-one relations between the lists (e.g. \"For ONE order there are ONE customer and ONE article.\") you must\n\n(1) either combine the lists using VLOOKUP()\n(2) or use PowerPivot."]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[]
[null,null,"order_nr","employee","customer","city","zip_code","country","article","price","discount","amount","total_price","shipping_date","shipping_company","category"]
[0,null,10289,"King","B's Beverages","London","EC2 5NT","Great Britain","Aniseed Syrup",8,0,30,240,"2011-09-09","Federal Shipping","spices"]
[null,null,10290,"King","B's Beverages","London","EC2 5NT","Great Britain","Wimmers gute Semmelknödel",26.6,0,9,239.4,"2011-09-09","Federal Shipping","cereals"]
[null,null,10291,"Peacock","Island Trading","Hedge End","LA9 PX8","Great Britain","Outback Lager",12,0,30,360,"2011-10-15","United Package","beverages"]
[null,null,10292,"Peacock","Island Trading","Hedge End","LA9 PX8","Great Britain","Sasquatch Ale",11.2,0,14,156.80000000000001,"2011-10-15","United Package","beverages"]
[null,null,10293,"Callahan","Island Trading","Hedge End","LA9 PX8","Great Britain","Jack's New England Clam Chowder",7.7,0,20,154,"2011-10-16","United Package","sea food"]
[null,null,10294,"Callahan","Island Trading","Hedge End","LA9 PX8","Great Britain","Lakkalikööri",14.4,0,6,86.4,"2011-10-16","United Package","beverages"]
[null,null,10295,"Leverling","Island Trading","Hedge End","LA9 PX8","Great Britain","Steeleye Stout",14.4,0,10,144,"2011-10-23","United Package","beverages"]
[null,null,10296,"Suyama","Around the Horn","London","WA1 1DP","Great Britain","Guaraná Fantástica",3.6,0,25,90,"2011-12-02","Speedy Express","beverages"]
[null,null,10297,"Suyama","Around the Horn","London","WA1 1DP","Great Britain","Ravioli Angelo",15.6,0,25,390,"2011-12-02","Speedy Express","cereals"]
[null,null,10298,"Buchanan","Seven Seas Imports","London","OX15 4NB","Great Britain","Camembert Pierrot",27.2,0.05,80,2067.1999999999998,"2011-12-08","Federal Shipping","milk products"]
[null,null,10299,"Buchanan","Seven Seas Imports","London","OX15 4NB","Great Britain","Gorgonzola Telino",10,0.05,70,665,"2011-12-08","Federal Shipping","milk products"]
[null,null,10300,"Buchanan","Seven Seas Imports","London","OX15 4NB","Great Britain","Pavlova",13.9,0.05,56,739.48,"2011-12-08","Federal Shipping","sweets"]
[null,null,10301,"Davolio","Eastern Connection","London","WX3 6FW","Great Britain","Fløtemysost",17.2,0,5,86,"2011-12-16","Speedy Express","milk products"]
[null,null,10302,"Davolio","Eastern Connection","London","WX3 6FW","Great Britain","Gudbrandsdalsost",28.8,0,30,864,"2011-12-16","Speedy Express","milk products"]
[null,null,10303,"Davolio","Seven Seas Imports","London","OX15 4NB","Great Britain","Chartreuse verte",14.4,0.15,20,244.8,"2011-12-25","Federal Shipping","beverages"]
[null,null,10304,"Davolio","Seven Seas Imports","London","OX15 4NB","Great Britain","Rössle Sauerkraut",36.4,0.15,20,618.79999999999995,"2011-12-25","Federal Shipping","natural products"]
[null,null,10305,"Callahan","Around the Horn","London","WA1 1DP","Great Britain","Gnocchi di nonna Alice",30.4,0,20,608,"2011-12-30","Federal Shipping","cereals"]
[null,null,10306,"Callahan","Around the Horn","London","WA1 1DP","Great Britain","Konbu",4.8,0,20,96,"2011-12-30","Federal Shipping","sea food"]
[null,null,10307,"Callahan","Around the Horn","London","WA1 1DP","Great Britain","Valkoinen suklaa",13,0,15,195,"2011-12-30","Federal Shipping","sweets"]
[null,null,10308,"Fuller","Seven Seas Imports","London","OX15 4NB","Great Britain","Filo Mix",5.6,0.2,20,89.6,"2012-01-01","Speedy Express","cereals"]
[null,null,10309,"Fuller","Seven Seas Imports","London","OX15 4NB","Great Britain","Perth Pasties",26.2,0,40,1048,"2012-01-01","Speedy Express","meat"]
[null,null,10310,"Fuller","Seven Seas Imports","London","OX15 4NB","Great Britain","Røgede sild",7.6,0.2,15,91.2,"2012-01-01","Speedy Express","sea food"]
[null,null,10311,"Davolio","Eastern Connection","London","WX3 6FW","Great Britain","Maxilaku",16,0,30,480,"2012-01-28","Federal Shipping","sweets"]
[null,null,10312,"Davolio","Eastern Connection","London","WX3 6FW","Great Britain","Steeleye Stout",14.4,0,35,504,"2012-01-28","Federal Shipping","beverages"]
[null,null,10313,"Davolio","Eastern Connection","London","WX3 6FW","Great Britain","Thüringer Rostbratwurst",99,0,21,2079,"2012-01-28","Federal Shipping","meat"]
[null,null,10314,"Callahan","Consolidated Holdings","London","WX1 6LT","Great Britain","Chang",15.2,0,10,152,"2012-02-19","United Package","beverages"]
[null,null,10315,"Callahan","Consolidated Holdings","London","WX1 6LT","Great Britain","Gustaf's Knäckebröd",16.8,0,12,201.6,"2012-02-19","United Package","cereals"]
[null,null,10316,"Callahan","Consolidated Holdings","London","WX1 6LT","Great Britain","Mozzarella di Giovanni",27.8,0,10,278,"2012-02-19","United Package","milk products"]
[null,null,10317,"Davolio","Around the Horn","London","WA1 1DP","Great Britain","Chocolade",10.199999999999999,0.1,15,137.69999999999999,"2012-03-09","United Package","sweets"]
[null,null,10318,"Davolio","Around the Horn","London","WA1 1DP","Great Britain","Outback Lager",12,0.1,25,270,"2012-03-09","United Package","beverages"]
[null,null,10319,"Fuller","Consolidated Holdings","London","WX1 6LT","Great Britain","Konbu",4.8,0,1,4.8,"2012-03-29","Speedy Express","sea food"]
[null,null,10320,"Fuller","Consolidated Holdings","London","WX1 6LT","Great Britain","Tunnbröd",7.2,0,21,151.19999999999999,"2012-03-29","Speedy Express","cereals"]
[null,null,10321,"Fuller","B's Beverages","London","EC2 5NT","Great Britain","Gnocchi di nonna Alice",30.4,0,20,608,"2012-03-29","Federal Shipping","cereals"]
[null,null,10322,"Fuller","B's Beverages","London","EC2 5NT","Great Britain","Uncle Bob's Organic Dried Pears",24,0,30,720,"2012-03-29","Federal Shipping","natural products"]
[null,null,10323,"Callahan","Seven Seas Imports","London","OX15 4NB","Great Britain","Guaraná Fantástica",3.6,0.05,80,273.60000000000002,"2012-03-30","Speedy Express","beverages"]
[null,null,10324,"Callahan","Seven Seas Imports","London","OX15 4NB","Great Britain","Manjimup Dried Apples",42.4,0,18,763.2,"2012-03-30","Speedy Express","natural products"]
[null,null,10325,"Davolio","Island Trading","Hedge End","LA9 PX8","Great Britain","Fløtemysost",17.2,0,12,206.4,"2012-04-01","Federal Shipping","milk products"]
[null,null,10326,"Davolio","Island Trading","Hedge End","LA9 PX8","Great Britain","Geitost",2,0,12,24,"2012-04-01","Federal Shipping","milk products"]
[null,null,10327,"Leverling","B's Beverages","London","EC2 5NT","Great Britain","Boston Crab Meat",14.7,0,10,147,"2012-04-12","Federal Shipping","sea food"]
[null,null,10328,"Leverling","B's Beverages","London","EC2 5NT","Great Britain","Manjimup Dried Apples",42.4,0,3,127.2,"2012-04-12","Federal Shipping","natural products"]
[null,null,10329,"Leverling","B's Beverages","London","EC2 5NT","Great Britain","Sir Rodney's Scones",8,0,14,112,"2012-04-12","Federal Shipping","sweets"]
[null,null,10330,"Leverling","North/South","London","SW7 1RZ","Great Britain","Filo Mix",7,0,6,42,"2012-05-10","Federal Shipping","cereals"]
[null,null,10331,"Leverling","North/South","London","SW7 1RZ","Great Britain","Outback Lager",15,0,6,90,"2012-05-10","Federal Shipping","beverages"]
[null,null,10332,"Leverling","North/South","London","SW7 1RZ","Great Britain","Raclette Courdavault",55,0,4,220,"2012-05-10","Federal Shipping","milk products"]
[null,null,10333,"King","Seven Seas Imports","London","OX15 4NB","Great Britain","Alice Mutton",39,0.1,25,877.5,"2012-06-10","United Package","meat"]
[null,null,10334,"King","Seven Seas Imports","London","OX15 4NB","Great Britain","Gravad lax",26,0.1,18,421.2,"2012-06-10","United Package","sea food"]
[null,null,10335,"King","Seven Seas Imports","London","OX15 4NB","Great Britain","Jack's New England Clam Chowder",9.65,0.1,6,52.11,"2012-06-10","United Package","sea food"]
[null,null,10336,"King","Seven Seas Imports","London","OX15 4NB","Great Britain","Sir Rodney's Marmalade",81,0.1,15,1093.5,"2012-06-10","United Package","sweets"]
[null,null,10337,"King","Eastern Connection","London","WX3 6FW","Great Britain","Louisiana Hot Spiced Okra",17,0,24,408,"2012-05-23","Federal Shipping","spices"]
[null,null,10338,"King","Eastern Connection","London","WX3 6FW","Great Britain","Nord-Ost Matjeshering",25.89,0,15,388.35,"2012-05-23","Federal Shipping","sea food"]
[null,null,10339,"Dodsworth","B's Beverages","London","EC2 5NT","Great Britain","Mozzarella di Giovanni",34.799999999999997,0,1,34.799999999999997,"2012-05-27","Federal Shipping","milk products"]
[null,null,10340,"Dodsworth","B's Beverages","London","EC2 5NT","Great Britain","Outback Lager",15,0,7,105,"2012-05-27","Federal Shipping","beverages"]
[null,null,10341,"Suyama","B's Beverages","London","EC2 5NT","Great Britain","Geitost",2.5,0,15,37.5,"2012-06-03","Federal Shipping","milk products"]
[null,null,10342,"Suyama","B's Beverages","London","EC2 5NT","Great Britain","Konbu",6,0,8,48,"2012-06-03","Federal Shipping","sea food"]
[null,null,10343,"Suyama","B's Beverages","London","EC2 5NT","Great Britain","Maxilaku",20,0,6,120,"2012-06-03","Federal Shipping","sweets"]
[null,null,10344,"Suyama","B's Beverages","London","EC2 5NT","Great Britain","Sir Rodney's Scones",10,0,15,150,"2012-06-03","Federal Shipping","sweets"]
[null,null,10345,"Leverling","Seven Seas Imports","London","OX15 4NB","Great Britain","Inlagd Sill",19,0,60,1140,"2012-06-13","United Package","sea food"]
[null,null,10346,"Leverling","Seven Seas Imports","London","OX15 4NB","Great Britain","Mascarpone Fabioli",32,0.15,24,652.79999999999995,"2012-06-13","United Package","milk products"]
[null,null,10347,"Davolio","Around the Horn","London","WA1 1DP","Great Britain","Filo Mix",7,0,30,210,"2012-06-21","United Package","cereals"]
[null,null,10348,"Davolio","Around the Horn","London","WA1 1DP","Great Britain","Manjimup Dried Apples",53,0,20,1060,"2012-06-21","United Package","natural products"]
[null,null,10349,"Davolio","Around the Horn","London","WA1 1DP","Great Britain","Perth Pasties",32.799999999999997,0,18,590.4,"2012-06-21","United Package","meat"]
[null,null,10350,"Davolio","Around the Horn","London","WA1 1DP","Great Britain","Röd Kaviar",15,0,3,45,"2012-06-21","United Package","sea food"]
[null,null,10351,"Davolio","Around the Horn","London","WA1 1DP","Great Britain","Zaanse koeken",9.5,0,25,237.5,"2012-06-21","United Package","sweets"]
[null,null,10352,"Peacock","B's Beverages","London","EC2 5NT","Great Britain","Ravioli Angelo",19.5,0,6,117,"2012-08-05","Federal Shipping","cereals"]
[null,null,10353,"Peacock","B's Beverages","London","EC2 5NT","Great Britain","Steeleye Stout",18,0,20,360,"2012-08-05","Federal Shipping","beverages"]
[null,null,10354,"Suyama","B's Beverages","London","EC2 5NT","Great Britain","Tarte au sucre",49.3,0,10,493,"2012-08-01","Federal Shipping","sweets"]
[null,null,10355,"Peacock","Island Trading","Hedge End","LA9 PX8","Great Britain","Fløtemysost",21.5,0,15,322.5,"2012-08-22","United Package","milk products"]
[null,null,10356,"Peacock","Island Trading","Hedge End","LA9 PX8","Great Britain","Outback Lager",15,0,20,300,"2012-08-22","United Package","beverages"]
[null,null,10357,"Peacock","Island Trading","Hedge End","LA9 PX8","Great Britain","Teatime Chocolate Biscuits",9.1999999999999993,0,5,46,"2012-08-22","United Package","sweets"]
[null,null,10358,"Peacock","Island Trading","Hedge End","LA9 PX8","Great Britain","Tunnbröd",9,0,10,90,"2012-08-22","United Package","cereals"]
[null,null,10359,"Peacock","Island Trading","Hedge End","LA9 PX8","Great Britain","Tunnbröd",9,0,5,45,"2012-10-11","United Package","cereals"]
[null,null,10360,"Peacock","Around the Horn","London","WA1 1DP","Great Britain","Outback Lager",15,0.15,28,357,"2012-11-03","Federal Shipping","beverages"]
[null,null,10361,"Peacock","Around the Horn","London","WA1 1DP","Great Britain","Pâté chinois",24,0,21,504,"2012-11-03","Federal Shipping","meat"]
[null,null,10362,"Peacock","Around the Horn","London","WA1 1DP","Great Britain","Ravioli Angelo",19.5,0,40,780,"2012-11-03","Federal Shipping","cereals"]
[null,null,10363,"Peacock","Eastern Connection","London","WX3 6FW","Great Britain","Chef Anton's Cajun Seasoning",22,0,25,550,"2012-12-16","Speedy Express","spices"]
[null,null,10364,"Peacock","Eastern Connection","London","WX3 6FW","Great Britain","Queso Cabrales",21,0,5,105,"2012-12-16","Speedy Express","milk products"]
[null,null,10365,"Peacock","Around the Horn","London","WA1 1DP","Great Britain","Chang",19,0.2,15,228,"2012-11-29","Federal Shipping","beverages"]
[null,null,10366,"Davolio","Around the Horn","London","WA1 1DP","Great Britain","Spegesild",12,0.05,28,319.2,"2012-12-02","United Package","sea food"]
[null,null,10367,"Peacock","Island Trading","Hedge End","LA9 PX8","Great Britain","Gnocchi di nonna Alice",38,0,15,570,"2012-12-30","United Package","cereals"]
[null,null,10368,"Peacock","Island Trading","Hedge End","LA9 PX8","Great Britain","Lakkalikööri",18,0,10,180,"2012-12-30","United Package","beverages"]
[null,null,10369,"Peacock","Island Trading","Hedge End","LA9 PX8","Great Britain","Raclette Courdavault",55,0,6,330,"2012-12-30","United Package","milk products"]
[null,null,10370,"Fuller","North/South","London","SW7 1RZ","Great Britain","Chai",18,0,8,144,"2012-12-09","Federal Shipping","beverages"]
[null,null,10371,"Fuller","North/South","London","SW7 1RZ","Great Britain","Gudbrandsdalsost",36,0,3,108,"2012-12-09","Federal Shipping","milk products"]
[null,null,10372,"Leverling","Around the Horn","London","WA1 1DP","Great Britain","Camembert Pierrot",34,0,15,510,"2012-12-26","United Package","milk products"]
[null,null,10373,"Leverling","Around the Horn","London","WA1 1DP","Great Britain","Fløtemysost",21.5,0,12,258,"2012-12-26","United Package","milk products"]
[null,null,10374,"Leverling","Around the Horn","London","WA1 1DP","Great Britain","Gorgonzola Telino",12.5,0,50,625,"2012-12-26","United Package","milk products"]
[null,null,10375,"Leverling","Around the Horn","London","WA1 1DP","Great Britain","Gustaf's Knäckebröd",21,0,4,84,"2012-12-26","United Package","cereals"]
[null,null,10376,"Leverling","Around the Horn","London","WA1 1DP","Great Britain","Filo Mix",7,0,8,56,"2013-01-19","Federal Shipping","cereals"]
[null,null,10377,"Leverling","Around the Horn","London","WA1 1DP","Great Britain","Jack's New England Clam Chowder",9.65,0,14,135.1,"2013-01-19","Federal Shipping","sea food"]
[null,null,10378,"Fuller","Island Trading","Hedge End","LA9 PX8","Great Britain","Mozzarella di Giovanni",34.799999999999997,0,10,348,"2013-01-16","Speedy Express","milk products"]
[null,null,10379,"Fuller","Island Trading","Hedge End","LA9 PX8","Great Britain","Tarte au sucre",49.3,0,2,98.6,"2013-01-16","Speedy Express","sweets"]
[null,null,10380,"Davolio","Seven Seas Imports","London","OX15 4NB","Great Britain","Manjimup Dried Apples",53,0.1,10,477,"2013-01-16","Federal Shipping","natural products"]
[null,null,10381,"Davolio","Seven Seas Imports","London","OX15 4NB","Great Britain","Queso Cabrales",21,0.1,50,945,"2013-01-16","Federal Shipping","milk products"]
[null,null,10382,"Davolio","Seven Seas Imports","London","OX15 4NB","Great Britain","Tourtière",7.45,0.1,7,46.93,"2013-01-16","Federal Shipping","meat"]
[null,null,10383,"Suyama","Seven Seas Imports","London","OX15 4NB","Great Britain","Ikura",31,0,36,1116,"2013-01-18","United Package","sea food"]
[null,null,10384,"Suyama","Seven Seas Imports","London","OX15 4NB","Great Britain","Maxilaku",20,0.15,4,68,"2013-01-18","United Package","sweets"]
[null,null,10385,"Suyama","Seven Seas Imports","London","OX15 4NB","Great Britain","Rössle Sauerkraut",45.6,0,24,1094.4000000000001,"2013-01-18","United Package","natural products"]
[null,null,10386,"Dodsworth","Island Trading","Hedge End","LA9 PX8","Great Britain","Camembert Pierrot",34,0,21,714,"2013-02-03","Speedy Express","milk products"]
[null,null,10387,"Dodsworth","Island Trading","Hedge End","LA9 PX8","Great Britain","Chang",19,0,10,190,"2013-02-03","Speedy Express","beverages"]
[null,null,10388,"Dodsworth","Island Trading","Hedge End","LA9 PX8","Great Britain","Konbu",6,0,10,60,"2013-02-03","Speedy Express","sea food"]
[null,null,10389,"Dodsworth","Island Trading","Hedge End","LA9 PX8","Great Britain","Northwoods Cranberry Sauce",40,0,20,800,"2013-02-03","Speedy Express","spices"]
[null,null,10390,"King","Consolidated Holdings","London","WX1 6LT","Great Britain","Chef Anton's Gumbo Mix",21.35,0,30,640.5,"2013-02-09","United Package","spices"]
[null,null,10391,"King","Consolidated Holdings","London","WX1 6LT","Great Britain","Mishi Kobe Niku",97,0,3,291,"2013-02-09","United Package","meat"]
[null,null,10392,"Peacock","Around the Horn","London","WA1 1DP","Great Britain","Laughing Lumberjack Lager",14,0,15,210,"2013-02-20","United Package","beverages"]
[null,null,10393,"Peacock","Around the Horn","London","WA1 1DP","Great Britain","Steeleye Stout",18,0,4,72,"2013-02-20","United Package","beverages"]
[null,null,10394,"Buchanan","Seven Seas Imports","London","OX15 4NB","Great Britain","Chai",18,0,40,720,"2013-02-20","Speedy Express","beverages"]
[null,null,10395,"Buchanan","Seven Seas Imports","London","OX15 4NB","Great Britain","Queso Cabrales",21,0,10,210,"2013-02-20","Speedy Express","milk products"]
[null,null,10396,"Buchanan","Seven Seas Imports","London","OX15 4NB","Great Britain","Scottish Longbreads",12.5,0,20,250,"2013-02-20","Speedy Express","sweets"]
[null,null,10397,"Buchanan","Seven Seas Imports","London","OX15 4NB","Great Britain","Tunnbröd",9,0,50,450,"2013-02-20","Speedy Express","cereals"]
[null,null,10398,"Peacock","Around the Horn","London","WA1 1DP","Great Britain","Valkoinen suklaa",16.25,0,24,390,"2013-03-20","United Package","sweets"]
[null,null,10399,"Suyama","Island Trading","Hedge End","LA9 PX8","Great Britain","Perth Pasties",32.799999999999997,0,2,65.599999999999994,"2013-03-27","Federal Shipping","meat"]
[null,null,10400,"Suyama","Island Trading","Hedge End","LA9 PX8","Great Britain","Sirop d'érable",28.5,0,30,855,"2013-03-27","Federal Shipping","spices"]
[null,null,10401,"Peacock","B's Beverages","London","EC2 5NT","Great Britain","Gustaf's Knäckebröd",21,0,21,441,"2013-03-30","United Package","cereals"]
[null,null,10402,"Peacock","B's Beverages","London","EC2 5NT","Great Britain","Konbu",6,0,15,90,"2013-03-30","United Package","sea food"]
[null,null,10403,"Peacock","B's Beverages","London","EC2 5NT","Great Britain","Spegesild",12,0,15,180,"2013-03-30","United Package","sea food"]
[null,null,10404,"Leverling","B's Beverages","London","EC2 5NT","Great Britain","Raclette Courdavault",55,0,4,220,"2013-03-27","United Package","milk products"]
[null,null,10405,"Dodsworth","Around the Horn","London","WA1 1DP","Great Britain","Gorgonzola Telino",12.5,0.05,50,593.75,"2013-04-05","United Package","milk products"]
[null,null,10406,"Dodsworth","Around the Horn","London","WA1 1DP","Great Britain","Sir Rodney's Marmalade",81,0.05,50,3847.5,"2013-04-05","United Package","sweets"]
[null,null,10407,"Callahan","Eastern Connection","London","WX3 6FW","Great Britain","Ipoh Coffee",46,0,6,276,"2013-04-17","Speedy Express","beverages"]
[null,null,10408,"Callahan","Eastern Connection","London","WX3 6FW","Great Britain","Mozzarella di Giovanni",34.799999999999997,0,20,696,"2013-04-17","Speedy Express","milk products"]
[null,null,10409,"Callahan","Eastern Connection","London","WX3 6FW","Great Britain","Uncle Bob's Organic Dried Pears",30,0,60,1800,"2013-04-17","Speedy Express","natural products"]
[null,null,10410,"Dodsworth","Around the Horn","London","WA1 1DP","Great Britain","Gorgonzola Telino",12.5,0,15,187.5,"2013-04-24","United Package","milk products"]
[null,null,10411,"Dodsworth","Around the Horn","London","WA1 1DP","Great Britain","Inlagd Sill",19,0,16,304,"2013-04-24","United Package","sea food"]
[null,null,10412,"Davolio","B's Beverages","London","EC2 5NT","Great Britain","Ipoh Coffee",46,0,30,1380,"2013-05-05","United Package","beverages"]
[null,null,10413,"Davolio","B's Beverages","London","EC2 5NT","Great Britain","Uncle Bob's Organic Dried Pears",30,0,4,120,"2013-05-05","United Package","natural products"]
[null,null,10414,"Peacock","Eastern Connection","London","WX3 6FW","Great Britain","Fløtemysost",21.5,0,50,1075,"2013-05-01","Speedy Express","milk products"]
[null,null,10415,"Peacock","Eastern Connection","London","WX3 6FW","Great Britain","Geitost",2.5,0,30,75,"2013-05-01","Speedy Express","milk products"]
[null,null,10416,"Peacock","Eastern Connection","London","WX3 6FW","Great Britain","Gumbär Gummibärchen",31.23,0,12,374.76,"2013-05-01","Speedy Express","sweets"]
[null,null,10417,"Peacock","Eastern Connection","London","WX3 6FW","Great Britain","Louisiana Fiery Hot Pepper Sauce",21.05,0,21,442.05,"2013-05-01","Speedy Express","spices"]
[null,null,10418,"King","Eastern Connection","London","WX3 6FW","Great Britain","Chai",18,0.25,25,337.5,"2013-05-12","Federal Shipping","beverages"]
[null,null,10419,"King","Eastern Connection","London","WX3 6FW","Great Britain","Chef Anton's Gumbo Mix",21.35,0.25,30,480.38,"2013-05-12","Federal Shipping","spices"]
[null,null,10420,"Callahan","Eastern Connection","London","WX3 6FW","Great Britain","Camembert Pierrot",34,0,50,1700,"2013-05-12","United Package","milk products"]
[null,null,10421,"Callahan","Eastern Connection","London","WX3 6FW","Great Britain","Pâté chinois",24,0,35,840,"2013-05-12","United Package","meat"]
[null,null,10422,"Callahan","Eastern Connection","London","WX3 6FW","Great Britain","Uncle Bob's Organic Dried Pears",30,0,40,1200,"2013-05-12","United Package","natural products"]
[null,null,10423,"Leverling","North/South","London","SW7 1RZ","Great Britain","Outback Lager",15,0,3,45,"2013-05-12","Federal Shipping","beverages"]

{"sheet":"Bestellungen (2)","index":3,"n_rows":164,"n_cols":21,"rows_kept":164,"cut":false,"hidden":false,"merged":[[19,2,26,8],[1,1,1,4],[2,1,2,4],[11,2,18,8],[4,2,6,8],[7,2,9,8]]}
[null,null,null,null,null,0]
[1,"Orders (2)",null,null,null,"Back to Start"]
[2,"Bestellungen (2)",null,null,null,"Startseite"]
[]
[2,"Achtung","Jede Bestellnummer darf nur ein einmal vorkommen.\nJede Kundennummer darf mehrmals vorkommen.\nJede Artikelnummer darf mehrmals vorkommen:"]
[2]
[2]
[1,"Attention","Each order number must appear only once.\nEach customer number may appear several times.\nEach article number may appear several times."]
[1]
[1]
[]
[2,"\"Tabelle\"","Wählen Sie alle Daten inkl. Spaltenüberschriften aus und klicken Sie dann\n\"Start\" / \"Formatvorlagen\" / \"Als Tabelle formatieren\"\nWenn Sie jetzt in die Tabelle klicken, erscheint das Register \"Tabellentools\"\nGeben Sie der Tabelle einen Namen:\n\"Tabellentools\" / \"Entwurf\" / \"Eigenschaften\" / \"Tabellenname\" = \"order_data2\"\n\nSollte es bei der Namensvergabe Probleme geben, können Sie diese mittels\n\"Formeln\" / \"Namensmanager\" bearbeiten."]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[1,"\"Table\"","Select all data incl. column headers - then click\n\"Home\" / \"Style\" / \"Format as Table\"\nIf you click into the table, the menu \"Table Tools\" appears.\nDefine a name for the table:\n\"Table Tools\" / \"Design\" / \"Properties\" / \"Table Name\" = \"order_data2\"\n\nIf there are any problems with the name definition, you can clarify them with\n\"Formulas\" / \"Name Manager\"."]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[]
[null,null,"order_nr","employee","customer_nr","article_nr","discount","amount","total_price","shipping_date","shipping_company","====>","order_nr","employee","customer_nr","article_nr","discount","amount"," total_price ","shipping_date","shipping_company"]
[null,null,10289,"King",1002,102,0,30,240,"2017-09-07","Federal Shipping",null,10289,"King",1002,102,0,30,240,"2017-09-07","Federal Shipping"]
[null,null,10290,"King",1002,161,0,9,239.4,"2017-09-07","Federal Shipping",null,10290,"King",1002,161,0,9,239.4,"2017-09-07","Federal Shipping"]
[null,null,10291,"Peacock",1005,137,0,30,360,"2017-10-13","United Package",null,10291,"Peacock",1005,137,0,30,360,"2017-10-13","United Package"]
[null,null,10292,"Peacock",1005,147,0,14,156.80000000000001,"2017-10-13","United Package",null,10292,"Peacock",1005,147,0,14,156.80000000000001,"2017-10-13","United Package"]
[null,null,10293,"Callahan",1005,124,0,20,154,"2017-10-14","United Package",null,10293,"Callahan",1005,124,0,20,154,"2017-10-14","United Package"]
[null,null,10294,"Callahan",1005,126,0,6,86.4,"2017-10-14","United Package",null,10294,"Callahan",1005,126,0,6,86.4,"2017-10-14","United Package"]
[null,null,10295,"Leverling",1005,153,0,10,144,"2017-10-21","United Package",null,10295,"Leverling",1005,153,0,10,144,"2017-10-21","United Package"]
[null,null,10296,"Suyama",1001,117,0,25,90,"2017-11-30","Speedy Express",null,10296,"Suyama",1001,117,0,25,90,"2017-11-30","Speedy Express"]
[null,null,10297,"Suyama",1001,143,0,25,390,"2017-11-30","Speedy Express",null,10297,"Suyama",1001,143,0,25,390,"2017-11-30","Speedy Express"]
[null,null,10298,"Buchanan",1007,104,0.05,80,2067.1999999999998,"2017-12-06","Federal Shipping",null,10298,"Buchanan",1007,104,0.05,80,2067.1999999999998,"2017-12-06","Federal Shipping"]
[null,null,10299,"Buchanan",1007,115,0.05,70,665,"2017-12-06","Federal Shipping",null,10299,"Buchanan",1007,115,0.05,70,665,"2017-12-06","Federal Shipping"]
[null,null,10300,"Buchanan",1007,139,0.05,56,739.48,"2017-12-06","Federal Shipping",null,10300,"Buchanan",1007,139,0.05,56,739.48,"2017-12-06","Federal Shipping"]
[null,null,10301,"Davolio",1004,112,0,5,86,"2017-12-14","Speedy Express",null,10301,"Davolio",1004,112,0,5,86,"2017-12-14","Speedy Express"]
[null,null,10302,"Davolio",1004,118,0,30,864,"2017-12-14","Speedy Express",null,10302,"Davolio",1004,118,0,30,864,"2017-12-14","Speedy Express"]
[null,null,10303,"Davolio",1007,107,0.15,20,244.8,"2017-12-23","Federal Shipping",null,10303,"Davolio",1007,107,0.15,20,244.8,"2017-12-23","Federal Shipping"]
[null,null,10304,"Davolio",1007,146,0.15,20,618.79999999999995,"2017-12-23","Federal Shipping",null,10304,"Davolio",1007,146,0.15,20,618.79999999999995,"2017-12-23","Federal Shipping"]
[null,null,10305,"Callahan",1001,114,0,20,608,"2017-12-28","Federal Shipping",null,10305,"Callahan",1001,114,0,20,608,"2017-12-28","Federal Shipping"]
[0,null,10306,"Callahan",1001,125,0,20,96,"2017-12-28","Federal Shipping",null,10306,"Callahan",1001,125,0,20,96,"2017-12-28","Federal Shipping"]
[null,null,10307,"Callahan",1001,160,0,15,195,"2017-12-28","Federal Shipping",null,10307,"Callahan",1001,160,0,15,195,"2017-12-28","Federal Shipping"]
[null,null,10308,"Fuller",1007,111,0.2,20,89.6,"2017-12-30","Speedy Express",null,10308,"Fuller",1007,111,0.2,20,89.6,"2017-12-30","Speedy Express"]
[null,null,10309,"Fuller",1007,140,0,40,1048,"2017-12-30","Speedy Express",null,10309,"Fuller",1007,140,0,40,1048,"2017-12-30","Speedy Express"]
[null,null,10310,"Fuller",1007,145,0.2,15,91.2,"2017-12-30","Speedy Express",null,10310,"Fuller",1007,145,0.2,15,91.2,"2017-12-30","Speedy Express"]
[null,null,10311,"Davolio",1004,132,0,30,480,"2018-01-26","Federal Shipping",null,10311,"Davolio",1004,132,0,30,480,"2018-01-26","Federal Shipping"]
[null,null,10312,"Davolio",1004,153,0,35,504,"2018-01-26","Federal Shipping",null,10312,"Davolio",1004,153,0,35,504,"2018-01-26","Federal Shipping"]
[null,null,10313,"Davolio",1004,156,0,21,2079,"2018-01-26","Federal Shipping",null,10313,"Davolio",1004,156,0,21,2079,"2018-01-26","Federal Shipping"]
[null,null,10314,"Callahan",1003,106,0,10,152,"2018-02-17","United Package",null,10314,"Callahan",1003,106,0,10,152,"2018-02-17","United Package"]
[null,null,10315,"Callahan",1003,120,0,12,201.6,"2018-02-17","United Package",null,10315,"Callahan",1003,120,0,12,201.6,"2018-02-17","United Package"]
[null,null,10316,"Callahan",1003,134,0,10,278,"2018-02-17","United Package",null,10316,"Callahan",1003,134,0,10,278,"2018-02-17","United Package"]
[null,null,10317,"Davolio",1001,110,0.1,15,137.69999999999999,"2018-03-08","United Package",null,10317,"Davolio",1001,110,0.1,15,137.69999999999999,"2018-03-08","United Package"]
[null,null,10318,"Davolio",1001,137,0.1,25,270,"2018-03-08","United Package",null,10318,"Davolio",1001,137,0.1,25,270,"2018-03-08","United Package"]
[null,null,10319,"Fuller",1003,125,0,1,4.8,"2018-03-28","Speedy Express",null,10319,"Fuller",1003,125,0,1,4.8,"2018-03-28","Speedy Express"]
[null,null,10320,"Fuller",1003,158,0,21,151.19999999999999,"2018-03-28","Speedy Express",null,10320,"Fuller",1003,158,0,21,151.19999999999999,"2018-03-28","Speedy Express"]
[null,null,10321,"Fuller",1002,114,0,20,608,"2018-03-28","Federal Shipping",null,10321,"Fuller",1002,114,0,20,608,"2018-03-28","Federal Shipping"]
[null,null,10322,"Fuller",1002,159,0,30,720,"2018-03-28","Federal Shipping",null,10322,"Fuller",1002,159,0,30,720,"2018-03-28","Federal Shipping"]
[null,null,10323,"Callahan",1007,117,0.05,80,273.60000000000002,"2018-03-29","Speedy Express",null,10323,"Callahan",1007,117,0.05,80,273.60000000000002,"2018-03-29","Speedy Express"]
[null,null,10324,"Callahan",1007,130,0,18,763.2,"2018-03-29","Speedy Express",null,10324,"Callahan",1007,130,0,18,763.2,"2018-03-29","Speedy Express"]
[null,null,10325,"Davolio",1005,112,0,12,206.4,"2018-03-31","Federal Shipping",null,10325,"Davolio",1005,112,0,12,206.4,"2018-03-31","Federal Shipping"]
[null,null,10326,"Davolio",1005,113,0,12,24,"2018-03-31","Federal Shipping",null,10326,"Davolio",1005,113,0,12,24,"2018-03-31","Federal Shipping"]
[null,null,10327,"Leverling",1002,103,0,10,147,"2018-04-11","Federal Shipping",null,10327,"Leverling",1002,103,0,10,147,"2018-04-11","Federal Shipping"]
[null,null,10328,"Leverling",1002,130,0,3,127.2,"2018-04-11","Federal Shipping",null,10328,"Leverling",1002,130,0,3,127.2,"2018-04-11","Federal Shipping"]
[null,null,10329,"Leverling",1002,150,0,14,112,"2018-04-11","Federal Shipping",null,10329,"Leverling",1002,150,0,14,112,"2018-04-11","Federal Shipping"]
[null,null,10330,"Leverling",1006,111,0,6,42,"2018-05-09","Federal Shipping",null,10330,"Leverling",1006,111,0,6,42,"2018-05-09","Federal Shipping"]
[null,null,10331,"Leverling",1006,137,0,6,90,"2018-05-09","Federal Shipping",null,10331,"Leverling",1006,137,0,6,90,"2018-05-09","Federal Shipping"]
[null,null,10332,"Leverling",1006,142,0,4,220,"2018-05-09","Federal Shipping",null,10332,"Leverling",1006,142,0,4,220,"2018-05-09","Federal Shipping"]
[null,null,10333,"King",1007,101,0.1,25,877.5,"2018-06-09","United Package",null,10333,"King",1007,101,0.1,25,877.5,"2018-06-09","United Package"]
[null,null,10334,"King",1007,116,0.1,18,421.2,"2018-06-09","United Package",null,10334,"King",1007,116,0.1,18,421.2,"2018-06-09","United Package"]
[null,null,10335,"King",1007,124,0.1,6,52.11,"2018-06-09","United Package",null,10335,"King",1007,124,0.1,6,52.11,"2018-06-09","United Package"]
[null,null,10336,"King",1007,149,0.1,15,1093.5,"2018-06-09","United Package",null,10336,"King",1007,149,0.1,15,1093.5,"2018-06-09","United Package"]
[null,null,10337,"King",1004,129,0,24,408,"2018-05-22","Federal Shipping",null,10337,"King",1004,129,0,24,408,"2018-05-22","Federal Shipping"]
[null,null,10338,"King",1004,135,0,15,388.35,"2018-05-22","Federal Shipping",null,10338,"King",1004,135,0,15,388.35,"2018-05-22","Federal Shipping"]
[null,null,10339,"Dodsworth",1002,134,0,1,34.799999999999997,"2018-05-26","Federal Shipping",null,10339,"Dodsworth",1002,134,0,1,34.799999999999997,"2018-05-26","Federal Shipping"]
[null,null,10340,"Dodsworth",1002,137,0,7,105,"2018-05-26","Federal Shipping",null,10340,"Dodsworth",1002,137,0,7,105,"2018-05-26","Federal Shipping"]
[null,null,10341,"Suyama",1002,113,0,15,37.5,"2018-06-02","Federal Shipping",null,10341,"Suyama",1002,113,0,15,37.5,"2018-06-02","Federal Shipping"]
[null,null,10342,"Suyama",1002,125,0,8,48,"2018-06-02","Federal Shipping",null,10342,"Suyama",1002,125,0,8,48,"2018-06-02","Federal Shipping"]
[null,null,10343,"Suyama",1002,132,0,6,120,"2018-06-02","Federal Shipping",null,10343,"Suyama",1002,132,0,6,120,"2018-06-02","Federal Shipping"]
[null,null,10344,"Suyama",1002,150,0,15,150,"2018-06-02","Federal Shipping",null,10344,"Suyama",1002,150,0,15,150,"2018-06-02","Federal Shipping"]
[null,null,10345,"Leverling",1007,122,0,60,1140,"2018-06-12","United Package",null,10345,"Leverling",1007,122,0,60,1140,"2018-06-12","United Package"]
[null,null,10346,"Leverling",1007,131,0.15,24,652.79999999999995,"2018-06-12","United Package",null,10346,"Leverling",1007,131,0.15,24,652.79999999999995,"2018-06-12","United Package"]
[null,null,10347,"Davolio",1001,111,0,30,210,"2018-06-20","United Package",null,10347,"Davolio",1001,111,0,30,210,"2018-06-20","United Package"]
[null,null,10348,"Davolio",1001,130,0,20,1060,"2018-06-20","United Package",null,10348,"Davolio",1001,130,0,20,1060,"2018-06-20","United Package"]
[null,null,10349,"Davolio",1001,140,0,18,590.4,"2018-06-20","United Package",null,10349,"Davolio",1001,140,0,18,590.4,"2018-06-20","United Package"]
[null,null,10350,"Davolio",1001,144,0,3,45,"2018-06-20","United Package",null,10350,"Davolio",1001,144,0,3,45,"2018-06-20","United Package"]
[null,null,10351,"Davolio",1001,162,0,25,237.5,"2018-06-20","United Package",null,10351,"Davolio",1001,162,0,25,237.5,"2018-06-20","United Package"]
[null,null,10352,"Peacock",1002,143,0,6,117,"2018-08-04","Federal Shipping",null,10352,"Peacock",1002,143,0,6,117,"2018-08-04","Federal Shipping"]
[null,null,10353,"Peacock",1002,153,0,20,360,"2018-08-04","Federal Shipping",null,10353,"Peacock",1002,153,0,20,360,"2018-08-04","Federal Shipping"]
[null,null,10354,"Suyama",1002,154,0,10,493,"2018-07-31","Federal Shipping",null,10354,"Suyama",1002,154,0,10,493,"2018-07-31","Federal Shipping"]
[null,null,10355,"Peacock",1005,112,0,15,322.5,"2018-08-21","United Package",null,10355,"Peacock",1005,112,0,15,322.5,"2018-08-21","United Package"]
[null,null,10356,"Peacock",1005,137,0,20,300,"2018-08-21","United Package",null,10356,"Peacock",1005,137,0,20,300,"2018-08-21","United Package"]
[null,null,10357,"Peacock",1005,155,0,5,46,"2018-08-21","United Package",null,10357,"Peacock",1005,155,0,5,46,"2018-08-21","United Package"]
[null,null,10358,"Peacock",1005,158,0,10,90,"2018-08-21","United Package",null,10358,"Peacock",1005,158,0,10,90,"2018-08-21","United Package"]
[null,null,10359,"Peacock",1005,158,0,5,45,"2018-10-10","United Package",null,10359,"Peacock",1005,158,0,5,45,"2018-10-10","United Package"]
[null,null,10360,"Peacock",1001,137,0.15,28,357,"2018-11-02","Federal Shipping",null,10360,"Peacock",1001,137,0.15,28,357,"2018-11-02","Federal Shipping"]
[null,null,10361,"Peacock",1001,138,0,21,504,"2018-11-02","Federal Shipping",null,10361,"Peacock",1001,138,0,21,504,"2018-11-02","Federal Shipping"]
[null,null,10362,"Peacock",1001,143,0,40,780,"2018-11-02","Federal Shipping",null,10362,"Peacock",1001,143,0,40,780,"2018-11-02","Federal Shipping"]
[null,null,10363,"Peacock",1004,108,0,25,550,"2018-12-15","Speedy Express",null,10363,"Peacock",1004,108,0,25,550,"2018-12-15","Speedy Express"]
[null,null,10364,"Peacock",1004,141,0,5,105,"2018-12-15","Speedy Express",null,10364,"Peacock",1004,141,0,5,105,"2018-12-15","Speedy Express"]
[null,null,10365,"Peacock",1001,106,0.2,15,228,"2018-11-28","Federal Shipping",null,10365,"Peacock",1001,106,0.2,15,228,"2018-11-28","Federal Shipping"]
[null,null,10366,"Davolio",1001,152,0.05,28,319.2,"2018-12-01","United Package",null,10366,"Davolio",1001,152,0.05,28,319.2,"2018-12-01","United Package"]
[null,null,10367,"Peacock",1005,114,0,15,570,"2018-12-29","United Package",null,10367,"Peacock",1005,114,0,15,570,"2018-12-29","United Package"]
[null,null,10368,"Peacock",1005,126,0,10,180,"2018-12-29","United Package",null,10368,"Peacock",1005,126,0,10,180,"2018-12-29","United Package"]
[null,null,10369,"Peacock",1005,142,0,6,330,"2018-12-29","United Package",null,10369,"Peacock",1005,142,0,6,330,"2018-12-29","United Package"]
[null,null,10370,"Fuller",1006,105,0,8,144,"2018-12-08","Federal Shipping",null,10370,"Fuller",1006,105,0,8,144,"2018-12-08","Federal Shipping"]
[null,null,10371,"Fuller",1006,118,0,3,108,"2018-12-08","Federal Shipping",null,10371,"Fuller",1006,118,0,3,108,"2018-12-08","Federal Shipping"]
[null,null,10372,"Leverling",1001,104,0,15,510,"2018-12-25","United Package",null,10372,"Leverling",1001,104,0,15,510,"2018-12-25","United Package"]
[null,null,10373,"Leverling",1001,112,0,12,258,"2018-12-25","United Package",null,10373,"Leverling",1001,112,0,12,258,"2018-12-25","United Package"]
[null,null,10374,"Leverling",1001,115,0,50,625,"2018-12-25","United Package",null,10374,"Leverling",1001,115,0,50,625,"2018-12-25","United Package"]
[null,null,10375,"Leverling",1001,120,0,4,84,"2018-12-25","United Package",null,10375,"Leverling",1001,120,0,4,84,"2018-12-25","United Package"]
[null,null,10376,"Leverling",1001,111,0,8,56,"2019-01-18","Federal Shipping",null,10376,"Leverling",1001,111,0,8,56,"2019-01-18","Federal Shipping"]
[null,null,10377,"Leverling",1001,124,0,14,135.1,"2019-01-18","Federal Shipping",null,10377,"Leverling",1001,124,0,14,135.1,"2019-01-18","Federal Shipping"]
[null,null,10378,"Fuller",1005,134,0,10,348,"2019-01-15","Speedy Express",null,10378,"Fuller",1005,134,0,10,348,"2019-01-15","Speedy Express"]
[null,null,10379,"Fuller",1005,154,0,2,98.6,"2019-01-15","Speedy Express",null,10379,"Fuller",1005,154,0,2,98.6,"2019-01-15","Speedy Express"]
[null,null,10380,"Davolio",1007,130,0.1,10,477,"2019-01-15","Federal Shipping",null,10380,"Davolio",1007,130,0.1,10,477,"2019-01-15","Federal Shipping"]
[null,null,10381,"Davolio",1007,141,0.1,50,945,"2019-01-15","Federal Shipping",null,10381,"Davolio",1007,141,0.1,50,945,"2019-01-15","Federal Shipping"]
[null,null,10382,"Davolio",1007,157,0.1,7,46.93,"2019-01-15","Federal Shipping",null,10382,"Davolio",1007,157,0.1,7,46.93,"2019-01-15","Federal Shipping"]
[null,null,10383,"Suyama",1007,121,0,36,1116,"2019-01-17","United Package",null,10383,"Suyama",1007,121,0,36,1116,"2019-01-17","United Package"]
[null,null,10384,"Suyama",1007,132,0.15,4,68,"2019-01-17","United Package",null,10384,"Suyama",1007,132,0.15,4,68,"2019-01-17","United Package"]
[null,null,10385,"Suyama",1007,146,0,24,1094.4000000000001,"2019-01-17","United Package",null,10385,"Suyama",1007,146,0,24,1094.4000000000001,"2019-01-17","United Package"]
[null,null,10386,"Dodsworth",1005,104,0,21,714,"2019-02-02","Speedy Express",null,10386,"Dodsworth",1005,104,0,21,714,"2019-02-02","Speedy Express"]
[null,null,10387,"Dodsworth",1005,106,0,10,190,"2019-02-02","Speedy Express",null,10387,"Dodsworth",1005,106,0,10,190,"2019-02-02","Speedy Express"]
[null,null,10388,"Dodsworth",1005,125,0,10,60,"2019-02-02","Speedy Express",null,10388,"Dodsworth",1005,125,0,10,60,"2019-02-02","Speedy Express"]
[null,null,10389,"Dodsworth",1005,136,0,20,800,"2019-02-02","Speedy Express",null,10389,"Dodsworth",1005,136,0,20,800,"2019-02-02","Speedy Express"]
[null,null,10390,"King",1003,109,0,30,640.5,"2019-02-08","United Package",null,10390,"King",1003,109,0,30,640.5,"2019-02-08","United Package"]
[null,null,10391,"King",1003,133,0,3,291,"2019-02-08","United Package",null,10391,"King",1003,133,0,3,291,"2019-02-08","United Package"]
[null,null,10392,"Peacock",1001,127,0,15,210,"2019-02-19","United Package",null,10392,"Peacock",1001,127,0,15,210,"2019-02-19","United Package"]
[null,null,10393,"Peacock",1001,153,0,4,72,"2019-02-19","United Package",null,10393,"Peacock",1001,153,0,4,72,"2019-02-19","United Package"]
[null,null,10394,"Buchanan",1007,105,0,40,720,"2019-02-19","Speedy Express",null,10394,"Buchanan",1007,105,0,40,720,"2019-02-19","Speedy Express"]
[null,null,10395,"Buchanan",1007,141,0,10,210,"2019-02-19","Speedy Express",null,10395,"Buchanan",1007,141,0,10,210,"2019-02-19","Speedy Express"]
[null,null,10396,"Buchanan",1007,148,0,20,250,"2019-02-19","Speedy Express",null,10396,"Buchanan",1007,148,0,20,250,"2019-02-19","Speedy Express"]
[null,null,10397,"Buchanan",1007,158,0,50,450,"2019-02-19","Speedy Express",null,10397,"Buchanan",1007,158,0,50,450,"2019-02-19","Speedy Express"]
[null,null,10398,"Peacock",1001,160,0,24,390,"2019-03-19","United Package",null,10398,"Peacock",1001,160,0,24,390,"2019-03-19","United Package"]
[null,null,10399,"Suyama",1005,140,0,2,65.599999999999994,"2019-03-26","Federal Shipping",null,10399,"Suyama",1005,140,0,2,65.599999999999994,"2019-03-26","Federal Shipping"]
[null,null,10400,"Suyama",1005,151,0,30,855,"2019-03-26","Federal Shipping",null,10400,"Suyama",1005,151,0,30,855,"2019-03-26","Federal Shipping"]
[null,null,10401,"Peacock",1002,120,0,21,441,"2019-03-29","United Package",null,10401,"Peacock",1002,120,0,21,441,"2019-03-29","United Package"]
[null,null,10402,"Peacock",1002,125,0,15,90,"2019-03-29","United Package",null,10402,"Peacock",1002,125,0,15,90,"2019-03-29","United Package"]
[null,null,10403,"Peacock",1002,152,0,15,180,"2019-03-29","United Package",null,10403,"Peacock",1002,152,0,15,180,"2019-03-29","United Package"]
[null,null,10404,"Leverling",1002,142,0,4,220,"2019-03-26","United Package",null,10404,"Leverling",1002,142,0,4,220,"2019-03-26","United Package"]
[null,null,10405,"Dodsworth",1001,115,0.05,50,593.75,"2019-04-04","United Package",null,10405,"Dodsworth",1001,115,0.05,50,593.75,"2019-04-04","United Package"]
[null,null,10406,"Dodsworth",1001,149,0.05,50,3847.5,"2019-04-04","United Package",null,10406,"Dodsworth",1001,149,0.05,50,3847.5,"2019-04-04","United Package"]
[null,null,10407,"Callahan",1004,123,0,6,276,"2019-04-16","Speedy Express",null,10407,"Callahan",1004,123,0,6,276,"2019-04-16","Speedy Express"]
[null,null,10408,"Callahan",1004,134,0,20,696,"2019-04-16","Speedy Express",null,10408,"Callahan",1004,134,0,20,696,"2019-04-16","Speedy Express"]
[null,null,10409,"Callahan",1004,159,0,60,1800,"2019-04-16","Speedy Express",null,10409,"Callahan",1004,159,0,60,1800,"2019-04-16","Speedy Express"]
[null,null,10410,"Dodsworth",1001,115,0,15,187.5,"2019-04-23","United Package",null,10410,"Dodsworth",1001,115,0,15,187.5,"2019-04-23","United Package"]
[null,null,10411,"Dodsworth",1001,122,0,16,304,"2019-04-23","United Package",null,10411,"Dodsworth",1001,122,0,16,304,"2019-04-23","United Package"]
[null,null,10412,"Davolio",1002,123,0,30,1380,"2019-05-04","United Package",null,10412,"Davolio",1002,123,0,30,1380,"2019-05-04","United Package"]
[null,null,10413,"Davolio",1002,159,0,4,120,"2019-05-04","United Package",null,10413,"Davolio",1002,159,0,4,120,"2019-05-04","United Package"]
[null,null,10414,"Peacock",1004,112,0,50,1075,"2019-04-30","Speedy Express",null,10414,"Peacock",1004,112,0,50,1075,"2019-04-30","Speedy Express"]
[null,null,10415,"Peacock",1004,113,0,30,75,"2019-04-30","Speedy Express",null,10415,"Peacock",1004,113,0,30,75,"2019-04-30","Speedy Express"]
[null,null,10416,"Peacock",1004,119,0,12,374.76,"2019-04-30","Speedy Express",null,10416,"Peacock",1004,119,0,12,374.76,"2019-04-30","Speedy Express"]
[null,null,10417,"Peacock",1004,128,0,21,442.05,"2019-04-30","Speedy Express",null,10417,"Peacock",1004,128,0,21,442.05,"2019-04-30","Speedy Express"]
[null,null,10418,"King",1004,105,0.25,25,337.5,"2019-05-11","Federal Shipping",null,10418,"King",1004,105,0.25,25,337.5,"2019-05-11","Federal Shipping"]
[null,null,10419,"King",1004,109,0.25,30,480.38,"2019-05-11","Federal Shipping",null,10419,"King",1004,109,0.25,30,480.38,"2019-05-11","Federal Shipping"]
[null,null,10420,"Callahan",1004,104,0,50,1700,"2019-05-11","United Package",null,10420,"Callahan",1004,104,0,50,1700,"2019-05-11","United Package"]
[null,null,10421,"Callahan",1004,138,0,35,840,"2019-05-11","United Package",null,10421,"Callahan",1004,138,0,35,840,"2019-05-11","United Package"]
[null,null,10422,"Callahan",1004,159,0,40,1200,"2019-05-11","United Package",null,10422,"Callahan",1004,159,0,40,1200,"2019-05-11","United Package"]
[null,null,10423,"Leverling",1006,137,0,3,45,"2019-05-11","Federal Shipping",null,10423,"Leverling",1006,137,0,3,45,"2019-05-11","Federal Shipping"]

{"sheet":"Artikel","index":4,"n_rows":99,"n_cols":11,"rows_kept":99,"cut":false,"hidden":false,"merged":[[7,2,21,6],[22,2,34,6],[1,1,1,4],[2,1,2,4],[4,2,4,8],[5,2,5,8]]}
[null,null,null,null,null,0]
[1,"Articles",null,null,null,"Back to Start"]
[2,"Artikel",null,null,null,"Startseite"]
[]
[2,"Achtung","Jede Artikelnummer darf nur einmal vorkommen."]
[1,"Attention","Each article number must appear only once."]
[]
[2,"Vorbereitung","alle Daten inkl. Spaltenüberschriften auswählen\n\"Start\" / \"Formatvorlagen\" / \"Als Tabelle formatieren\"\nWenn Sie jetzt in die Tabelle klicken, erscheint das Register \"Tabellentools\"\nGeben Sie der Tabelle einen Namen:\n\"Tabellentools\" / \"Entwurf\" / \"Eigenschaften\" / \"Tabellenname\" = \"article_data\"\n\nSollte es bei der Namensvergabe Probleme geben, können Sie diese mittels\n\"Formeln\" / \"Namensmanager\" bearbeiten.\n\nAls \"Tabelle\" formatierte Zellbereiche haben einen riesengroßen Vorteil, wenn es darum geht, weitere Zeilen oder Spalten hinzuzufügen. Wenn Sie nämlich rechts daneben oder darunter Spalten bzw. Zeilen hinzufügen, werden diese automatisch zu dem Bereich hinzugefügt, dem Sie einen Namen gegeben haben. Wenn also dann in irgeneiner anderen Excel-Funktion den Bereichsnamen benutzen, gehören die neuen Spalten bzw. Zeilen automatisch dazu. Sie brauchen den Bereich nach dem Hinzufügen von Spalten bzw. Zeilen also nicht neu zu definieren!"]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[1,"Preparation","select all data incl. column headers\n\"Home\" / \"Styles\" / \"Format as Table\"\nIf you click into the table, the menu \"Table Tools\" appears.\nDefine a name for the table:\n\"Table Tools\" / \"Design\" / \"Properties\" / \"Table Name\" = \"article_data\"\n\nIf there are any problems with the name definition, you can clarify them with\n\"Formulas\" / \"Name Manager\".\n\nRanges which are defiend as \"Table\" have a huge advantage, if you add columns or rows. That means, if you add a column right to the \"Table\" or a row at its bottom, then they are automatically added to the range with the name you had given to it. If you now use the name in any other Excel function, the new columns or rows belong to it automatically. You don't have to make a new range definition after adding columns or rows."]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[]
[null,null,"article_nr","article_name","article_price","category","====>","article_nr","article_name","article_price","category"]
[null,null,101,"Alice Mutton",39,"meat",null,101,"Alice Mutton",39,"meat"]
[null,null,102,"Aniseed Syrup",8,"spices",null,102,"Aniseed Syrup",8,"spices"]
[null,null,103,"Boston Crab Meat",14.7,"sea food",null,103,"Boston Crab Meat",14.7,"sea food"]
[null,null,104,"Camembert Pierrot",27.2,"milk products",null,104,"Camembert Pierrot",27.2,"milk products"]
[null,null,105,"Chai",18,"beverages",null,105,"Chai",18,"beverages"]
[null,null,106,"Chang",15.2,"beverages",null,106,"Chang",15.2,"beverages"]
[null,null,107,"Chartreuse verte",14.4,"beverages",null,107,"Chartreuse verte",14.4,"beverages"]
[null,null,108,"Chef Anton's Cajun Seasoning",22,"spices",null,108,"Chef Anton's Cajun Seasoning",22,"spices"]
[null,null,109,"Chef Anton's Gumbo Mix",21.35,"spices",null,109,"Chef Anton's Gumbo Mix",21.35,"spices"]
[null,null,110,"Chocolade",10.199999999999999,"sweets",null,110,"Chocolade",10.199999999999999,"sweets"]
[null,null,111,"Filo Mix",5.6,"cereals",null,111,"Filo Mix",5.6,"cereals"]
[null,null,112,"Fløtemysost",17.2,"milk products",null,112,"Fløtemysost",17.2,"milk products"]
[null,null,113,"Geitost",2,"milk products",null,113,"Geitost",2,"milk products"]
[null,null,114,"Gnocchi di nonna Alice",30.4,"cereals",null,114,"Gnocchi di nonna Alice",30.4,"cereals"]
[null,null,115,"Gorgonzola Telino",10,"milk products",null,115,"Gorgonzola Telino",10,"milk products"]
[null,null,116,"Gravad lax",26,"sea food",null,116,"Gravad lax",26,"sea food"]
[null,null,117,"Guaraná Fantástica",3.6,"beverages",null,117,"Guaraná Fantástica",3.6,"beverages"]
[0,null,118,"Gudbrandsdalsost",28.8,"milk products",null,118,"Gudbrandsdalsost",28.8,"milk products"]
[null,null,119,"Gumbär Gummibärchen",31.23,"sweets",null,119,"Gumbär Gummibärchen",31.23,"sweets"]
[null,null,120,"Gustaf's Knäckebröd",16.8,"cereals",null,120,"Gustaf's Knäckebröd",16.8,"cereals"]
[null,null,121,"Ikura",31,"sea food",null,121,"Ikura",31,"sea food"]
[null,null,122,"Inlagd Sill",19,"sea food",null,122,"Inlagd Sill",19,"sea food"]
[null,null,123,"Ipoh Coffee",46,"beverages",null,123,"Ipoh Coffee",46,"beverages"]
[null,null,124,"Jack's New England Clam Chowder",7.7,"sea food",null,124,"Jack's New England Clam Chowder",7.7,"sea food"]
[null,null,125,"Konbu",4.8,"sea food",null,125,"Konbu",4.8,"sea food"]
[null,null,126,"Lakkalikööri",14.4,"beverages",null,126,"Lakkalikööri",14.4,"beverages"]
[null,null,127,"Laughing Lumberjack Lager",14,"beverages",null,127,"Laughing Lumberjack Lager",14,"beverages"]
[null,null,128,"Louisiana Fiery Hot Pepper Sauce",21.05,"spices",null,128,"Louisiana Fiery Hot Pepper Sauce",21.05,"spices"]
[null,null,129,"Louisiana Hot Spiced Okra",17,"spices",null,129,"Louisiana Hot Spiced Okra",17,"spices"]
[null,null,130,"Manjimup Dried Apples",42.4,"natural products",null,130,"Manjimup Dried Apples",42.4,"natural products"]
[null,null,131,"Mascarpone Fabioli",32,"milk products",null,131,"Mascarpone Fabioli",32,"milk products"]
[null,null,132,"Maxilaku",16,"sweets",null,132,"Maxilaku",16,"sweets"]
[null,null,133,"Mishi Kobe Niku",97,"meat",null,133,"Mishi Kobe Niku",97,"meat"]
[null,null,134,"Mozzarella di Giovanni",27.8,"milk products",null,134,"Mozzarella di Giovanni",27.8,"milk products"]
[null,null,135,"Nord-Ost Matjeshering",25.89,"sea food",null,135,"Nord-Ost Matjeshering",25.89,"sea food"]
[null,null,136,"Northwoods Cranberry Sauce",40,"spices",null,136,"Northwoods Cranberry Sauce",40,"spices"]
[null,null,137,"Outback Lager",12,"beverages",null,137,"Outback Lager",12,"beverages"]
[null,null,138,"Pâté chinois",24,"meat",null,138,"Pâté chinois",24,"meat"]
[null,null,139,"Pavlova",13.9,"sweets",null,139,"Pavlova",13.9,"sweets"]
[null,null,140,"Perth Pasties",26.2,"meat",null,140,"Perth Pasties",26.2,"meat"]
[null,null,141,"Queso Cabrales",21,"milk products",null,141,"Queso Cabrales",21,"milk products"]
[null,null,142,"Raclette Courdavault",55,"milk products",null,142,"Raclette Courdavault",55,"milk products"]
[null,null,143,"Ravioli Angelo",15.6,"cereals",null,143,"Ravioli Angelo",15.6,"cereals"]
[null,null,144,"Röd Kaviar",15,"sea food",null,144,"Röd Kaviar",15,"sea food"]
[null,null,145,"Røgede sild",7.6,"sea food",null,145,"Røgede sild",7.6,"sea food"]
[null,null,146,"Rössle Sauerkraut",36.4,"natural products",null,146,"Rössle Sauerkraut",36.4,"natural products"]
[null,null,147,"Sasquatch Ale",11.2,"beverages",null,147,"Sasquatch Ale",11.2,"beverages"]
[null,null,148,"Scottish Longbreads",12.5,"sweets",null,148,"Scottish Longbreads",12.5,"sweets"]
[null,null,149,"Sir Rodney's Marmalade",81,"sweets",null,149,"Sir Rodney's Marmalade",81,"sweets"]
[null,null,150,"Sir Rodney's Scones",8,"sweets",null,150,"Sir Rodney's Scones",8,"sweets"]
[null,null,151,"Sirop d'érable",28.5,"spices",null,151,"Sirop d'érable",28.5,"spices"]
[null,null,152,"Spegesild",12,"sea food",null,152,"Spegesild",12,"sea food"]
[null,null,153,"Steeleye Stout",14.4,"beverages",null,153,"Steeleye Stout",14.4,"beverages"]
[null,null,154,"Tarte au sucre",49.3,"sweets",null,154,"Tarte au sucre",49.3,"sweets"]
[null,null,155,"Teatime Chocolate Biscuits",9.1999999999999993,"sweets",null,155,"Teatime Chocolate Biscuits",9.1999999999999993,"sweets"]
[null,null,156,"Thüringer Rostbratwurst",99,"meat",null,156,"Thüringer Rostbratwurst",99,"meat"]
[null,null,157,"Tourtière",7.45,"meat",null,157,"Tourtière",7.45,"meat"]
[null,null,158,"Tunnbröd",7.2,"cereals",null,158,"Tunnbröd",7.2,"cereals"]
[null,null,159,"Uncle Bob's Organic Dried Pears",24,"natural products",null,159,"Uncle Bob's Organic Dried Pears",24,"natural products"]
[null,null,160,"Valkoinen suklaa",13,"sweets",null,160,"Valkoinen suklaa",13,"sweets"]
[null,null,161,"Wimmers gute Semmelknödel",26.6,"cereals",null,161,"Wimmers gute Semmelknödel",26.6,"cereals"]
[null,null,162,"Zaanse koeken",9.5,"sweets",null,162,"Zaanse koeken",9.5,"sweets"]

{"sheet":"Kunden","index":5,"n_rows":57,"n_cols":13,"rows_kept":57,"cut":false,"hidden":false,"merged":[[22,2,34,7],[1,1,1,4],[2,1,2,4],[4,2,4,8],[5,2,5,8],[7,2,21,7]]}
[null,null,null,null,null,0]
[1,"Customers",null,null,null,"Back to Start"]
[2,"Kunden",null,null,null,"Startseite"]
[]
[2,"Achtung","Jede Kundennummer darf nur einmal vorkommen."]
[1,"Attention","Each customer number must appear only once."]
[]
[2,"Vorbereitung","alle Daten inkl. Spaltenüberschriften auswählen\n\"Start\" / \"Formatvorlagen\" / \"Als Tabelle formatieren\"\nWenn Sie jetzt in die Tabelle klicken, erscheint das Register \"Tabellentools\"\nGeben Sie der Tabelle einen Namen:\n\"Tabellentools\" / \"Entwurf\" / \"Eigenschaften\" / \"Tabellenname\" = \"customer_data\"\n\nSollte es bei der Namensvergabe Probleme geben, können Sie diese mittels\n\"Formeln\" / \"Namensmanager\" bearbeiten.\n\nAls \"Tabelle\" formatierte Zellbereiche haben einen riesengroßen Vorteil, wenn es darum geht, weitere Zeilen oder Spalten hinzuzufügen. Wenn Sie nämlich rechts daneben oder darunter Spalten bzw. Zeilen hinzufügen, werden diese automatisch zu dem Bereich hinzugefügt, dem Sie einen Namen gegeben haben. Wenn also dann in irgeneiner anderen Excel-Funktion den Bereichsnamen benutzen, gehören die neuen Spalten bzw. Zeilen automatisch dazu. Sie brauchen den Bereich nach dem Hinzufügen von Spalten bzw. Zeilen also nicht neu zu definieren!"]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[1,"Preparation","select all data incl. column headers\n\"Home\" / \"Styles\" / \"Format as Table\"\nIf you click into the table, the menu \"Table Tools\" appears.\nDefine a name for the table:\n\"Table Tools\" / \"Design\" / \"Properties\" / \"Table Name\" = \"customer_data\"\n\nIf there are any problems with the name definition, you can clarify them with\n\"Formulas\" / \"Name Manager\".\n\nRanges which are defiend as \"Table\" have a huge advantage, if you add columns or rows. That means, if you add a column right to the \"Table\" or a row at its bottom, then they are automatically added to the range with the name you had given to it. If you now use the name in any other Excel function, the new columns or rows belong to it automatically. You don't have to make a new range definition after adding columns or rows."]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[]
[]
[null,null,"customer_nr","customer_name","city","zip_code","country","====>","customer_nr","customer_name","city","zip_code","country"]
[null,null,1001,"Around the Horn","London","WA1 1DP","Great Britain",null,1001,"Around the Horn","London","WA1 1DP","Great Britain"]
[null,null,1002,"B's Beverages","London","EC2 5NT","Great Britain",null,1002,"B's Beverages","London","EC2 5NT","Great Britain"]
[null,null,1003,"Consolidated Holdings","London","WX1 6LT","Great Britain",null,1003,"Consolidated Holdings","London","WX1 6LT","Great Britain"]
[null,null,1004,"Eastern Connection","London","WX3 6FW","Great Britain",null,1004,"Eastern Connection","London","WX3 6FW","Great Britain"]
[null,null,1005,"Island Trading","Hedge End","LA9 PX8","Great Britain",null,1005,"Island Trading","Hedge End","LA9 PX8","Great Britain"]
[null,null,1006,"North/South","London","SW7 1RZ","Great Britain",null,1006,"North/South","London","SW7 1RZ","Great Britain"]
[null,null,1007,"Seven Seas Imports","London","OX15 4NB","Great Britain",null,1007,"Seven Seas Imports","London","OX15 4NB","Great Britain"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[0]

{"sheet":"Datenmodell","index":6,"n_rows":107,"n_cols":6,"rows_kept":107,"cut":false,"hidden":false,"merged":[[86,2,93,8],[17,2,27,8],[75,2,85,8],[1,1,1,4],[2,1,2,4],[4,2,16,8],[54,2,65,8],[66,2,73,8]]}
[null,null,null,null,null,0]
[1,"Data model",null,null,null,"Back to Start"]
[2,"Datenmodell",null,null,null,"Startseite"]
[]
[2,"Tabellen","Führen Sie mit allen Tabellen die folgende Operation durch. Klicken Sie an einer beliebigen Stelle in die formatierte Tabelle. Dann: \n\"Power Pivot\" / \"Zum Datenmodell hinzufügen\"\n\nEs öffnet sich automatisch das Power-Pivot-Fenster.\nDie hinzugefügten Tabellen erscheinen am unteren Rand auf separaten Blättern.\n\nFalls Sie das Power-Pivot-Fenster geschlossen haben, können Sie es durch einen Klick auf \"Verwalten\" im \"Power Pivot\"-Menü von Excel wieder öffnen.\n\nÜberprüfen Sie, ob alle Spalten im Datenmodell richtig formatiert sind. Sollte eine Formatierung verloren gegangen sein, können Sie sie im Menü \"Home\" / \"Formatierung\" neu formatieren."]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[1,"Tables","Execute the following operation with all tables. Click into any cell of the table. Then:\n\"Power Pivot\" / \"Add to Data Model\"\n\nThe PowerPivot window opens automatically.\nThe added tables appear at the lower border on separate sheets.\n\nIf you have closed the PowerPivot window, you can open it again with a click on \"Manage\" in the \"Power Pivot\" menu in Excel.\n\nPlease check, if all columns in the data model are correctly formatted. If a format has gone lost you can change it in the menu \"Home\" / \"Format\"."]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[2,"Beziehungen","Als nächstes müssen Beziehungen zwischen den Tabellen hergestellt werden. Dazu klicken Sie im PowerPivot-Fenster im Register \"Home\" auf \"Diagrammsicht\". Dort ziehen Sie per Drag&Drop \n\n\"article_nr\" aus \"article_data\" auf \"article_nr\" in \"order_data2\" und\n\"customer_nr\" aus \"customer_data\" auf \"customer_nr\" in \"order_data2\"\n\nSollte die Beziehung falsch erstellt worden sein, können Sie sie nach einem Rechtsklick auf das Beziehungssysmbol löschen bzw. bearbeiten.\n\nIn der Datenansicht (\"Home\" / \"Ansicht\" / \"Datenansicht\") sind die Spalten, die mit anderen in einer Beziehung stehen, durch ein Lupensymbol in der Titelzeile gekennzeichnet."]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2,"Achtung","Achten Sie sorgfältig darauf, die richtigen Tabellenspalten miteinander in Beziehung zu setzen!\n\n(1) Es ist auch möglich, falsche Beziehungen herzustellen - z.B. \"article_nr\" aus \"article_data\" zu \"employee\" in \"order_data2\". (Bitte ausprobieren!)\n\n(2) Die Beziehungslinie zwischen den Tabellen wird nicht zwischen den entsprechenden Spalten gezogen. Um zu sehen, welche Spalten in Beziehung gesetzt werden, müssen Sie den Mauszeiger über die Beziehungslinie halten."]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[]
[1,"Relations","Now the relations between the tables must be defined. To do that, click on \"Diagram view\" in the menu \"Home\". There you use drag&drop to pull\n\n\"article_nr\" from \"article_data\" to \"article_nr\" in \"order_data2\" and\n\"customer_nr\" from \"customer_data\" to \"customer_nr\" in \"order_data2\"\n\nIf you have created a wrong relation you can delete or edit it after a right click to the relation symbol.\n\nIn the data view (\"Home\" / \"View\" / \"Data view\") those columns which are related to other columns are marked with a magnifier symbol.\n\n"]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1,"Attention","Be very careful to relate the correct columns to each other!\n\n(1) It is possible to define wrong relations - e.g. between \"article_nr\" from \"article_data\" to \"employee\" in \"order_data2\". (Please try it!)\n\n(2) The relation line between the tables is not drawn between the corresponding columns. To see which columns are related, hold the mouse pointer over the relation line. "]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[0]

{"sheet":"Pivot-Tabelle (2)","index":7,"n_rows":62,"n_cols":12,"rows_kept":62,"cut":false,"hidden":false,"merged":[[21,2,36,7],[1,1,1,4],[2,1,2,4],[4,2,20,7]]}
[null,null,null,null,null,0]
[1,"Pivot table (2)",null,null,null,"Back to Start"]
[2,"Pivot-Tabelle (2)",null,null,null,"Startseite"]
[]
[2,null,"Nachdem das Datenmodell erstellt wurde, können Sie jetzt eine PowerPivot-Tabelle erzeugen. Diese holt sich ihre Daten im Gegensatz zur \"normalen\" Pivot-Tabelle aus mehreren Datenlisten, die über Beziehungen miteinander verknüpft sind. Dazu klicken Sie im PowerPivot-Fenster auf\n\n\"Home\" / \"PivotTable\" / \"PivotTable\"\n\nBenutzen Sie dafür das vorhandene Blatt \"Pivot-Tabelle (2)\". Schalten Sie die dort erscheinende Pivot-Tabelle mit\n\nRechtsklick + \"PivotTable-Optionen\" / \"Anzeige\" / \"Klassisches PivotTable-Layout\"\n\num ins klassische Layout. Rechts sehen Sie wie gewohnt die Liste der PivotTable-Felder - jetzt allerdings kommen sie nicht aus einer, sondern aus mehreren Datenlisten, die über Beziehungen miteinander verbunden sind. Sie können jetzt wie gewohnt per Drag&Drop Ihre Pivot-Tabelle entwerfen.\nZiehen Sie dazu \"customer_name\" ins Zeilenfeld, \"category\" ins Spaltenfeld und \"total_price\" ins Datenfeld.\n\nDas war's. Eigentlich ganz einfach - oder?"]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[1,null,"After having defined the data model you can now create a PowerPivot table. In contrast to a \"normal\" PivotTable it gets its data from several lists, which are connected with each other by relations. In the PowerPivot window click on\n\n\"Home\" / \"PivotTable\" / \"PivotTable\"\n\nUse the existing sheet \"Pivot table (2)\". Switch the PivotTable, which appears there, with\n\nright click + \"PivotTable Options\" / \"Display\" / \"Classic PivotTable layout\"\n\nto the classic layout. As usual, on the right you can see the list of PivotTable fields - but now they don't come from one data list but from several data lists which are related to each other. Now you can design your PivotTable with drag&drop as usual.\nDrag \"customer_name\" into the row field, \"category\" into the column field and \"total_price\" into the value field.\n\nThat's it. Actually quite simple - isn't it? "]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[]
[]
[]
[]
[null,null,"Sum of total_price","category"]
[null,null,"customer_name","beverages","cereals","meat","milk products","natural products","sea food","spices","sweets","Gesamtergebnis"]
[null,null,"Around the Horn",1227,2128,1094.4000000000001,2174.25,1060,899.3,null,4807.7,13390.65]
[null,null,"B's Beverages",1845,1405.4,null,292.3,967.2,465,240,875,6089.9]
[null,null,"Consolidated Holdings",152,352.8,291,278,null,4.8,640.5,null,1719.1]
[null,null,"Eastern Connection",1117.5,null,2919,4601,3000,388.35,1880.43,854.76,14761.04]
[null,null,"Island Trading",1417.2,705,65.599999999999994,1944.9,null,214,1655,144.6,6146.3]
[null,null,"North/South",279,42,null,328,null,null,null,null,649]
[null,null,"Seven Seas Imports",1238.4000000000001,539.6,1972.43,4540,2953.4,2820.51,null,2150.98,16215.32]
[null,null,"Gesamtergebnis",7276.1,5172.8,6342.43,14158.45,7980.6,4791.96,4415.93,8833.0400000000009,58971.31]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[0]

{"sheet":"Bestellungen (3)","index":8,"n_rows":204,"n_cols":12,"rows_kept":204,"cut":false,"hidden":false,"merged":[[1,1,1,4],[2,1,2,4],[5,2,23,9],[24,2,40,9]]}
[null,null,null,null,null,0]
[1,"Orders (3)",null,null,null,"Back to Start"]
[2,"Bestellungen (3)",null,null,null,"Startseite"]
[]
[]
[2,"Neue Spalte","Als \"Tabelle\" formatierte Zellbereiche haben einen riesengroßen Vorteil, wenn es darum geht, weitere Zeilen oder Spalten hinzuzufügen. Wenn Sie nämlich rechts daneben oder darunter Spalten bzw. Zeilen hinzufügen, werden diese automatisch zu dem Bereich hinzugefügt, dem Sie einen Namen gegeben haben. Wenn also dann in irgeneiner anderen Excel-Funktion den Bereichsnamen benutzen, gehören die neuen Spalten bzw. Zeilen automatisch dazu. Sie brauchen den Bereich nach dem Hinzufügen von Spalten bzw. Zeilen also nicht neu zu definieren!\n\nVon dieser Eigenschaft werden wir jetzt Gebrauch machen.\n\nErzeugen Sie zunächst - wie auf dem Blatt \"Bestellungen (2) beschrieben - dieselbe Tabelle noch einmal und nennen Sie sie \"order_data3\".\n\nWir erweitern jetzt die Tabelle \"order_data3\" um eine Spalte \"paid\". Die neue Spalte wird sofort automatisch in die Tabellendefinition von \"order_data3\" mit aufgenommen. Sie erkennen das daran, dass die neue Spalte genauso wie die bereits vorhandenen gefärbt wird.\n\nDie neue Spalte füllen wir mit zufällig verteilten Werten \"no\" und \"yes\".\n\nFügen Sie die neue Tabelle \"order_data3\" wie auf dem Blatt \"Datenmodell\" beschrieben dem Datenmodell hinzu und definieren Sie wieder die Beziehungen zu \"customer_data\" und \"article_data\"."]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[1,"New column","Ranges which are defined as \"Table\" have a huge advantage, if you add columns or rows. That means, if you add a column right to the \"Table\" or a row at its bottom, then they are automatically added to the range with the name you had given to it. If you now use the name in any other Excel function, the new columns or rows belong to it automatically. You don't have to make a new range definition after adding columns or rows.\n\nNow we will make use of this advantage.\n\nFirst of all generate a table \"order_data3\" as described on the sheet \"Orders (2)\".\n\nThen we extend the table \"order_data3\" by an additional column \"paid\". The new column is immediately included into the table definition \"order_data3\". You can recognize this, because the column is colored in the same way as the already existing columns.\n\nWe fill the new column with randomly distributed values \"no\" and \"yes\".\n\nAdd the new table to the data model - as described on the sheet \"Data model\". Then define the relations to \"customer_data\" and \"article_data\"."]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"order_nr","employee","customer_nr","article_nr","discount","amount"," total_price ","shipping_date","shipping_company","paid"]
[null,null,10289,"King",1002,102,0,30,240,"2017-09-07","Federal Shipping","yes"]
[null,null,10290,"King",1002,161,0,9,239.4,"2017-09-07","Federal Shipping","no"]
[null,null,10291,"Peacock",1005,137,0,30,360,"2017-10-13","United Package","no"]
[null,null,10292,"Peacock",1005,147,0,14,156.80000000000001,"2017-10-13","United Package","yes"]
[null,null,10293,"Callahan",1005,124,0,20,154,"2017-10-14","United Package","yes"]
[null,null,10294,"Callahan",1005,126,0,6,86.4,"2017-10-14","United Package","yes"]
[null,null,10295,"Leverling",1005,153,0,10,144,"2017-10-21","United Package","no"]
[null,null,10296,"Suyama",1001,117,0,25,90,"2017-11-30","Speedy Express","no"]
[null,null,10297,"Suyama",1001,143,0,25,390,"2017-11-30","Speedy Express","yes"]
[null,null,10298,"Buchanan",1007,104,0.05,80,2067.1999999999998,"2017-12-06","Federal Shipping","yes"]
[null,null,10299,"Buchanan",1007,115,0.05,70,665,"2017-12-06","Federal Shipping","yes"]
[null,null,10300,"Buchanan",1007,139,0.05,56,739.48,"2017-12-06","Federal Shipping","yes"]
[null,null,10301,"Davolio",1004,112,0,5,86,"2017-12-14","Speedy Express","no"]
[null,null,10302,"Davolio",1004,118,0,30,864,"2017-12-14","Speedy Express","no"]
[null,null,10303,"Davolio",1007,107,0.15,20,244.8,"2017-12-23","Federal Shipping","yes"]
[null,null,10304,"Davolio",1007,146,0.15,20,618.79999999999995,"2017-12-23","Federal Shipping","no"]
[null,null,10305,"Callahan",1001,114,0,20,608,"2017-12-28","Federal Shipping","no"]
[0,null,10306,"Callahan",1001,125,0,20,96,"2017-12-28","Federal Shipping","no"]
[null,null,10307,"Callahan",1001,160,0,15,195,"2017-12-28","Federal Shipping","yes"]
[null,null,10308,"Fuller",1007,111,0.2,20,89.6,"2017-12-30","Speedy Express","no"]
[null,null,10309,"Fuller",1007,140,0,40,1048,"2017-12-30","Speedy Express","no"]
[null,null,10310,"Fuller",1007,145,0.2,15,91.2,"2017-12-30","Speedy Express","yes"]
[null,null,10311,"Davolio",1004,132,0,30,480,"2018-01-26","Federal Shipping","yes"]
[null,null,10312,"Davolio",1004,153,0,35,504,"2018-01-26","Federal Shipping","yes"]
[null,null,10313,"Davolio",1004,156,0,21,2079,"2018-01-26","Federal Shipping","no"]
[null,null,10314,"Callahan",1003,106,0,10,152,"2018-02-17","United Package","no"]
[null,null,10315,"Callahan",1003,120,0,12,201.6,"2018-02-17","United Package","yes"]
[null,null,10316,"Callahan",1003,134,0,10,278,"2018-02-17","United Package","yes"]
[null,null,10317,"Davolio",1001,110,0.1,15,137.69999999999999,"2018-03-08","United Package","yes"]
[null,null,10318,"Davolio",1001,137,0.1,25,270,"2018-03-08","United Package","yes"]
[null,null,10319,"Fuller",1003,125,0,1,4.8,"2018-03-28","Speedy Express","no"]
[null,null,10320,"Fuller",1003,158,0,21,151.19999999999999,"2018-03-28","Speedy Express","no"]
[null,null,10321,"Fuller",1002,114,0,20,608,"2018-03-28","Federal Shipping","yes"]
[null,null,10322,"Fuller",1002,159,0,30,720,"2018-03-28","Federal Shipping","no"]
[null,null,10323,"Callahan",1007,117,0.05,80,273.60000000000002,"2018-03-29","Speedy Express","no"]
[null,null,10324,"Callahan",1007,130,0,18,763.2,"2018-03-29","Speedy Express","no"]
[null,null,10325,"Davolio",1005,112,0,12,206.4,"2018-03-31","Federal Shipping","yes"]
[null,null,10326,"Davolio",1005,113,0,12,24,"2018-03-31","Federal Shipping","no"]
[null,null,10327,"Leverling",1002,103,0,10,147,"2018-04-11","Federal Shipping","no"]
[null,null,10328,"Leverling",1002,130,0,3,127.2,"2018-04-11","Federal Shipping","yes"]
[null,null,10329,"Leverling",1002,150,0,14,112,"2018-04-11","Federal Shipping","yes"]
[null,null,10330,"Leverling",1006,111,0,6,42,"2018-05-09","Federal Shipping","yes"]
[null,null,10331,"Leverling",1006,137,0,6,90,"2018-05-09","Federal Shipping","no"]
[null,null,10332,"Leverling",1006,142,0,4,220,"2018-05-09","Federal Shipping","no"]
[null,null,10333,"King",1007,101,0.1,25,877.5,"2018-06-09","United Package","yes"]
[null,null,10334,"King",1007,116,0.1,18,421.2,"2018-06-09","United Package","yes"]
[null,null,10335,"King",1007,124,0.1,6,52.11,"2018-06-09","United Package","yes"]
[null,null,10336,"King",1007,149,0.1,15,1093.5,"2018-06-09","United Package","yes"]
[null,null,10337,"King",1004,129,0,24,408,"2018-05-22","Federal Shipping","no"]
[null,null,10338,"King",1004,135,0,15,388.35,"2018-05-22","Federal Shipping","no"]
[null,null,10339,"Dodsworth",1002,134,0,1,34.799999999999997,"2018-05-26","Federal Shipping","yes"]
[null,null,10340,"Dodsworth",1002,137,0,7,105,"2018-05-26","Federal Shipping","no"]
[null,null,10341,"Suyama",1002,113,0,15,37.5,"2018-06-02","Federal Shipping","no"]
[null,null,10342,"Suyama",1002,125,0,8,48,"2018-06-02","Federal Shipping","no"]
[null,null,10343,"Suyama",1002,132,0,6,120,"2018-06-02","Federal Shipping","yes"]
[null,null,10344,"Suyama",1002,150,0,15,150,"2018-06-02","Federal Shipping","no"]
[null,null,10345,"Leverling",1007,122,0,60,1140,"2018-06-12","United Package","no"]
[null,null,10346,"Leverling",1007,131,0.15,24,652.79999999999995,"2018-06-12","United Package","yes"]
[null,null,10347,"Davolio",1001,111,0,30,210,"2018-06-20","United Package","yes"]
[null,null,10348,"Davolio",1001,130,0,20,1060,"2018-06-20","United Package","yes"]
[null,null,10349,"Davolio",1001,140,0,18,590.4,"2018-06-20","United Package","no"]
[null,null,10350,"Davolio",1001,144,0,3,45,"2018-06-20","United Package","no"]
[null,null,10351,"Davolio",1001,162,0,25,237.5,"2018-06-20","United Package","yes"]
[null,null,10352,"Peacock",1002,143,0,6,117,"2018-08-04","Federal Shipping","yes"]
[null,null,10353,"Peacock",1002,153,0,20,360,"2018-08-04","Federal Shipping","yes"]
[null,null,10354,"Suyama",1002,154,0,10,493,"2018-07-31","Federal Shipping","yes"]
[null,null,10355,"Peacock",1005,112,0,15,322.5,"2018-08-21","United Package","no"]
[null,null,10356,"Peacock",1005,137,0,20,300,"2018-08-21","United Package","no"]
[null,null,10357,"Peacock",1005,155,0,5,46,"2018-08-21","United Package","yes"]
[null,null,10358,"Peacock",1005,158,0,10,90,"2018-08-21","United Package","no"]
[null,null,10359,"Peacock",1005,158,0,5,45,"2018-10-10","United Package","no"]
[null,null,10360,"Peacock",1001,137,0.15,28,357,"2018-11-02","Federal Shipping","no"]
[null,null,10361,"Peacock",1001,138,0,21,504,"2018-11-02","Federal Shipping","yes"]
[null,null,10362,"Peacock",1001,143,0,40,780,"2018-11-02","Federal Shipping","no"]
[null,null,10363,"Peacock",1004,108,0,25,550,"2018-12-15","Speedy Express","no"]
[null,null,10364,"Peacock",1004,141,0,5,105,"2018-12-15","Speedy Express","yes"]
[null,null,10365,"Peacock",1001,106,0.2,15,228,"2018-11-28","Federal Shipping","yes"]
[null,null,10366,"Davolio",1001,152,0.05,28,319.2,"2018-12-01","United Package","yes"]
[null,null,10367,"Peacock",1005,114,0,15,570,"2018-12-29","United Package","no"]
[null,null,10368,"Peacock",1005,126,0,10,180,"2018-12-29","United Package","no"]
[null,null,10369,"Peacock",1005,142,0,6,330,"2018-12-29","United Package","yes"]
[null,null,10370,"Fuller",1006,105,0,8,144,"2018-12-08","Federal Shipping","yes"]
[null,null,10371,"Fuller",1006,118,0,3,108,"2018-12-08","Federal Shipping","yes"]
[null,null,10372,"Leverling",1001,104,0,15,510,"2018-12-25","United Package","yes"]
[null,null,10373,"Leverling",1001,112,0,12,258,"2018-12-25","United Package","no"]
[null,null,10374,"Leverling",1001,115,0,50,625,"2018-12-25","United Package","no"]
[null,null,10375,"Leverling",1001,120,0,4,84,"2018-12-25","United Package","yes"]
[null,null,10376,"Leverling",1001,111,0,8,56,"2019-01-18","Federal Shipping","no"]
[null,null,10377,"Leverling",1001,124,0,14,135.1,"2019-01-18","Federal Shipping","no"]
[null,null,10378,"Fuller",1005,134,0,10,348,"2019-01-15","Speedy Express","no"]
[null,null,10379,"Fuller",1005,154,0,2,98.6,"2019-01-15","Speedy Express","yes"]
[null,null,10380,"Davolio",1007,130,0.1,10,477,"2019-01-15","Federal Shipping","no"]
[null,null,10381,"Davolio",1007,141,0.1,50,945,"2019-01-15","Federal Shipping","no"]
[null,null,10382,"Davolio",1007,157,0.1,7,46.93,"2019-01-15","Federal Shipping","yes"]
[null,null,10383,"Suyama",1007,121,0,36,1116,"2019-01-17","United Package","yes"]
[null,null,10384,"Suyama",1007,132,0.15,4,68,"2019-01-17","United Package","yes"]
[null,null,10385,"Suyama",1007,146,0,24,1094.4000000000001,"2019-01-17","United Package","no"]
[null,null,10386,"Dodsworth",1005,104,0,21,714,"2019-02-02","Speedy Express","no"]
[null,null,10387,"Dodsworth",1005,106,0,10,190,"2019-02-02","Speedy Express","yes"]
[null,null,10388,"Dodsworth",1005,125,0,10,60,"2019-02-02","Speedy Express","yes"]
[null,null,10389,"Dodsworth",1005,136,0,20,800,"2019-02-02","Speedy Express","yes"]
[null,null,10390,"King",1003,109,0,30,640.5,"2019-02-08","United Package","yes"]
[null,null,10391,"King",1003,133,0,3,291,"2019-02-08","United Package","no"]
[null,null,10392,"Peacock",1001,127,0,15,210,"2019-02-19","United Package","no"]
[null,null,10393,"Peacock",1001,153,0,4,72,"2019-02-19","United Package","yes"]
[null,null,10394,"Buchanan",1007,105,0,40,720,"2019-02-19","Speedy Express","no"]
[null,null,10395,"Buchanan",1007,141,0,10,210,"2019-02-19","Speedy Express","no"]
[null,null,10396,"Buchanan",1007,148,0,20,250,"2019-02-19","Speedy Express","no"]
[null,null,10397,"Buchanan",1007,158,0,50,450,"2019-02-19","Speedy Express","yes"]
[null,null,10398,"Peacock",1001,160,0,24,390,"2019-03-19","United Package","no"]
[null,null,10399,"Suyama",1005,140,0,2,65.599999999999994,"2019-03-26","Federal Shipping","no"]
[null,null,10400,"Suyama",1005,151,0,30,855,"2019-03-26","Federal Shipping","yes"]
[null,null,10401,"Peacock",1002,120,0,21,441,"2019-03-29","United Package","yes"]
[null,null,10402,"Peacock",1002,125,0,15,90,"2019-03-29","United Package","yes"]
[null,null,10403,"Peacock",1002,152,0,15,180,"2019-03-29","United Package","no"]
[null,null,10404,"Leverling",1002,142,0,4,220,"2019-03-26","United Package","no"]
[null,null,10405,"Dodsworth",1001,115,0.05,50,593.75,"2019-04-04","United Package","yes"]
[null,null,10406,"Dodsworth",1001,149,0.05,50,3847.5,"2019-04-04","United Package","yes"]
[null,null,10407,"Callahan",1004,123,0,6,276,"2019-04-16","Speedy Express","yes"]
[null,null,10408,"Callahan",1004,134,0,20,696,"2019-04-16","Speedy Express","yes"]
[null,null,10409,"Callahan",1004,159,0,60,1800,"2019-04-16","Speedy Express","no"]
[null,null,10410,"Dodsworth",1001,115,0,15,187.5,"2019-04-23","United Package","no"]
[null,null,10411,"Dodsworth",1001,122,0,16,304,"2019-04-23","United Package","yes"]
[null,null,10412,"Davolio",1002,123,0,30,1380,"2019-05-04","United Package","no"]
[null,null,10413,"Davolio",1002,159,0,4,120,"2019-05-04","United Package","no"]
[null,null,10414,"Peacock",1004,112,0,50,1075,"2019-04-30","Speedy Express","no"]
[null,null,10415,"Peacock",1004,113,0,30,75,"2019-04-30","Speedy Express","yes"]
[null,null,10416,"Peacock",1004,119,0,12,374.76,"2019-04-30","Speedy Express","no"]
[null,null,10417,"Peacock",1004,128,0,21,442.05,"2019-04-30","Speedy Express","no"]
[null,null,10418,"King",1004,105,0.25,25,337.5,"2019-05-11","Federal Shipping","yes"]
[null,null,10419,"King",1004,109,0.25,30,480.38,"2019-05-11","Federal Shipping","yes"]
[null,null,10420,"Callahan",1004,104,0,50,1700,"2019-05-11","United Package","yes"]
[null,null,10421,"Callahan",1004,138,0,35,840,"2019-05-11","United Package","no"]
[null,null,10422,"Callahan",1004,159,0,40,1200,"2019-05-11","United Package","no"]
[null,null,10423,"Leverling",1006,137,0,3,45,"2019-05-11","Federal Shipping","yes"]

{"sheet":"Pivot-Tabelle (3) + DAX","index":9,"n_rows":121,"n_cols":12,"rows_kept":121,"cut":false,"hidden":false,"merged":[[1,1,1,4],[2,1,2,4],[4,2,8,6],[9,2,13,6],[15,2,29,6],[103,2,108,6],[109,2,113,6],[30,2,44,6],[58,2,68,6],[69,2,78,6]]}
[null,null,null,null,null,0]
[1,"Pivot table (3) + DAX",null,null,null,"Back to Start"]
[2,"Pivot-Tabelle (3) + DAX",null,null,null,"Startseite"]
[]
[2,null,"Erstellen Sie entsprechend der Anleitung auf dem Blatt \"Pivot-Tabelle (2)\" eine neue Pivot-Tabelle basierend auf der Tabelle \"order_data3\" vom Blatt \"Bestellungen (3)\".\nZiehen Sie dazu \"customer_name\" ins Zeilenfeld, \"category\" ins Spaltenfeld und \"total_price\" ins Datenfeld."]
[2]
[2]
[2]
[2]
[1,null,"According to the instruction on the sheet \"Pivot table (2)\" create a new PivotTable based on the table \"order_data3\" from the sheet \"Orders (3)\".\nDrag \"customer_name\" into the row field, \"category\" into the column field and \"total_price\" into the value field."]
[1]
[1]
[1]
[1]
[]
[2,"IF()","Wir wollen jetzt die zusätzlich eingefügte Spalte \"paid\" benutzen, um die Summe der offenen Beträge zu berechnen. Dafür gibt es in PowerPivot eine spezielle Programmiersprache:\n\nDAX = \"Data Analysis Expression\"\n\nAls erste Beispiel dafür klicken Sie im PowerPivot-Fenster die Spalte mit der Überschrift \"Spalte hinzufügen\" an und geben folgende Formel ein:\n \n=IF([paid]=\"no\";[total_price];0)\n\nDiese Formel gilt für die gesamte Spalte und braucht nicht - wie in Excel - herunter kopiert zu werden. Die Bedeutung dieser Formel sollte sich wohl von selbst erklären ...\nBenennen Sie die Spalte mit einem Rechtsklick um in \"open\".\nAnschließend können Sie \"open\" statt \"total_price\" in der Pivot-Tabelle anzeigen lassen."]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[1,"IF()","Now we want to use the additional column \"paid\" to calculate the open (=not paid) amounts. For that purpose there is special programming language in PowerPivot:\n\nDAX = \"Data Analysis Expression\"\n\nFor a first DAX example click into the PowerPivot column \"Add Column\" and enter the following formula:\n\n=IF([paid]=\"no\";[total_price];0)\n\nThis formula is valid for the entire column and you don't have to copy it down like in Excel. The meaning of this formula should be self-explaining ...\nRename the column to \"open\" using a right click.\nAfterwards you can display the column \"open\" instead of \"total_price\" in the Pivot table."]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[]
[]
[null,null,"Summe von open","category"]
[null,null,"customer","beverages","cereals","meat","milk products","natural products","sea food","spices","sweets","Gesamtergebnis"]
[null,null,"Around the Horn",657,1444,590.4,1070.5,0,276.10000000000002,null,390,4428]
[null,null,"B's Beverages",1485,239.4,null,257.5,840,375,0,150,3346.9]
[null,null,"Consolidated Holdings",152,151.19999999999999,291,0,null,4.8,0,null,599]
[null,null,"Eastern Connection",0,null,2919,2025,3000,388.35,1400.05,374.76,10107.16]
[null,null,"Island Trading",984,705,65.599999999999994,1408.5,null,0,0,0,3163.1]
[null,null,"North/South",90,0,null,220,null,null,null,null,310]
[null,null,"Seven Seas Imports",993.6,89.6,1048,1155,2953.4,1140,null,250,7629.6]
[null,null,"Gesamtergebnis",4361.6000000000004,2629.2,4914,6136.5,6793.4,2184.25,1400.05,1164.76,29583.759999999998]
[]
[2,"RELATED()","Eine andere DAX-Funktion funktioniert so ähnlich wie der von Excel bekannte SVERWEIS. Klicken Sie dazu wieder die Spalte \"Spalte hinzufügen\" ganz rechts im PowerPivot-Fenster an und geben Sie =REL ein. Es wird Ihnen RELATED vorgeschlagen. Klicken Sie doppelt darauf. Es wird Ihnen eine Liste von \"related columns\" vorgeschlagen. Wählen Sie mit einem Doppelklick customer_data[customer_name] und schließen Sie die Eingabe mit einer runden Klammer und der Enter-Taste ab. In der Spalte erscheinen die Namen der Kunden.\nJetzt können Sie \"customer\" aus \"order_data3\" anstelle von \"customer_name\" aus \"customer_data\" im Zeilenfeld der Pivot-Tabelle benutzen.\nDer SVERWEIS() funktioniert bekanntermaßen nur nach rechts. Für RELATED() ist es egal, wo sich die andere Spalte befindet."]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[1,"RELATED()","Another Dax formula works similar to the well-known VLOOKUP() in Excel. Click into the right column \"Add column\" in the PowerPivot window and enter =REL. PowerPivot proposes you RELATED. Make a double-click to it. A list of related columns is displayed. Select customer_data[customer_name] with a double-click and finish the input with a round bracket and press the Enter key. Now the column displays the names of the customers.\nNow you can use \"customer\" from \"order_data3\" instead of \"customer_name\" from \"customer_data\" in the row field of the Pivot table.\nAs you know, VLOOKUP() only works to the right. For RELATED() is doesn't matter, where the other column is located."]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[2,"… andere","Genau wie in Excel gibt es auch in DAX eine Fülle von Funktionen. Sie können sich einen ersten Überblick verschaffen, wenn Sie im PowerPivot-Fenster eine Zelle anklicken und dann im Menü \"Entwurf\" auf \"Funktion einfügen\" klicken.\nEs öffnet sich ein Fenster, wo Sie oben eine Kategorie auswählen können und darunter in einer Liste eine Funktion dieser Kategorie. Darunter erscheint eine Erklärung zu dieser Funktion."]
[2]
[2]
[2]
[2]
[2]
[1,"… other","As in Excel there is a large number of functions in DAX. You can get a first overview, if you click into a cell in the PowerPivot window and the select \"Insert function\" in the \"Design\" menu.\nA windows opens, where you can select a category in a combo box and in the list below the combo box a function of this category. Below the list of functions there is an explanation of the selected function."]
[1]
[1]
[1]
[1]
[]
[]
[]
[]
[]
[]
[0]

{"sheet":"Pivot-Tabelle (3) + KPIs","index":10,"n_rows":128,"n_cols":19,"rows_kept":128,"cut":false,"hidden":false,"merged":[[116,2,118,7],[119,2,121,7],[57,2,65,7],[66,2,74,7],[1,1,1,4],[2,1,2,4],[4,2,16,7],[17,2,27,7]]}
[null,null,null,null,null,0]
[1,"Pivot table (3) + KPIs",null,null,null,"Back to Start"]
[2,"Pivot-Tabelle (3) + KPIs",null,null,null,"Startseite"]
[]
[2,"Measures","Wenn Sie sich das PowerPivot-Fenster genau ansehen, werden Sie feststellen, dass es einen oberen und einen unteren Bereich gibt. Dazwischen befindet sich eine Trennlinie, die mit der Maus verschoben werden kann.\nIm unteren Bereich können Sie sog. \"Measures\" erstellen, die wiederum Voraussetzung für die Erstellung von KPI's (\"Key Performance Indicators\" = Kennzahlen) sind.\n\nZum Erstellen eines Measures klicken Sie eine Zelle im unteren Fensterbereich an und wählen dann unter\n\"Home\" / \"Berechnungen\" / \"Autosumme\"\neine geeignete Funktion aus (Summe, Durchschnitt, Anzahl, ...).\nDie Bezeichnung des Measures (das ist der Text vor dem Doppelpunkt) können Sie beliebig ändern.\n\nIn unserem Beispiel wollen wir zwei Measures für die beiden Spalten \"total_price\" und \"open\" erstellen.\n\nEinmal erstellte Measures können Sie auch im Excel-Fenster verwalten über\n\"PowerPivot\" / \"Berechnungen\" / \" Measures\" / \"Measures verwalten ...\""]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[1,"Measures","If you look carefully at the PowerPivot window, you will see, that there is an upper and a lower area. Between them there is a dividing line which can be moved with the mouse. In the lower area you can create so-called \"measures\" which are a precondition for the later creation of KPI's (\"Key Performance Indicators\").\n\nTo create a measure click into a cell in the lower window area and select a function (Sum, Average, Number, ...) from\n\"Home\" / \"Calculations\" / \"Autosum\".\nThe name of the measure (=the text before the colon) can be changed by you.\n\nIn our example we want to create two measures for \"total_price\" and \"open\".\n\nIf you have ceated measures you can manage them in the Excel window with\n\"PowerPivot\" / \"Calculations\" / \"Measures\" / \"Manage measures\""]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[2,"KPI's","Voraussetzung für die Erstellung von KPI's ist, dass Sie vorher Measures erstellt haben. Ansonsten ist der Button \"KPIs\" inaktiv.\nEin KPI ist eine Art bedingte Formatierung für Pivot-Tabellen. Zum Erstellen eines KPI wählen Sie im Excel-Fenster \n\"PowerPivot\" / \"Berechnungen\" / \"KPIs\" / \"Neuer KPI ...\"\nDort können Sie als Zielwert entweder an anderes Measure benutzen oder einen absoluten Wert selber eingeben. Dann können Sie auf einer Farbskala eine Ampelanzeige einstellen.\n\nSie können einen vorhandenen KPI im Excel-Fenster bearbeiten. Wählen Sie dazu\n\"PowerPivot\" / \"Berechnungen\" / \"KPIs\" / \"KPIs verwalten ...\"\n\n"]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[2]
[1,"KPI's","Precondition for the creation of KPIs is, that you have created measures before. Otherwise the button \"KPIs\" is not activated.\nA KPI is a kind of conditional formatting for Pivot tables. To create a KPI select\n\"PowerPivot\" / \"Calculations\" / \"KPIs\" / \"New KPI ...\"\nin the Excel window. There you can use another measure or an absolute vaule as a target value. Then you can define a traffic light display on a color scale.\n\nYou can edit an existing KPI in the Excel window by selecting\n\"PowerPivot\" / \"Calculations\" / \"KPIs\" / \"Edit KPI settings ...\""]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[1]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"category","Werte"]
[null,null,null,"beverages",null,"cereals",null,"meat",null,"milk products",null,"natural products",null,"sea food",null,"spices",null,"sweets"]
[null,null,"customer","total open","KPI","total open","KPI","total open","KPI","total open","KPI","total open","KPI","total open","KPI","total open","KPI","total open","KPI"]
[null,null,"Around the Horn",657,0,1444,-1,590.4,0,1070.5,-1,0,1,276.10000000000002,0,null,null,390,0]
[null,null,"B's Beverages",1485,-1,239.4,0,null,null,257.5,0,840,0,375,0,0,1,150,1]
[null,null,"Consolidated Holdings",152,1,151.19999999999999,1,291,0,0,1,null,null,4.8,1,0,1]
[null,null,"Eastern Connection",0,1,null,null,2919,-1,2025,-1,3000,-1,388.35,0,1400.05,-1,374.76,0]
[null,null,"Island Trading",984,-1,705,0,65.599999999999994,1,1408.5,-1,null,null,0,1,0,1,0,1]
[null,null,"North/South",90,1,0,1,null,null,220,0]
[null,null,"Seven Seas Imports",993.6,-1,89.6,1,1048,-1,1155,-1,2953.4,-1,1140,-1,null,null,250,0]
[]
[]
[2,null,"Measures und KPI's werden Ihnen in der PivotTable-Feldliste angezeigt. Dort können Sie auswählen, welche Measures und KPI's Sie in der Pivot-Tabelle anzeigen wollen."]
[2]
[2]
[1,null,"Measures and KPI's are displayed in the PivotTable field list. There you can select, which measures and KPI's you want to display in the PivotTable. "]
[1]
[1]
[]
[]
[]
[]
[]
[0]

{"sheet":"Bestellungen (A)","index":11,"n_rows":189,"n_cols":11,"rows_kept":189,"cut":false,"hidden":false,"merged":[[1,1,1,5],[2,1,2,5]]}
[null,null,null,null,null,null,0]
[1,"Orders (E)",null,null,null,null,"Back to Start"]
[2,"Bestellungen (A)",null,null,null,null,"Startseite"]
[]
[null,null,"order nr.","employee","customer_nr","article_nr","discount","amount"," total price ","shipping date","shipping company"]
[null,null,12248,"Buchanan",2010,349,0,10,98,"2011-07-28","Federal Shipping"]
[null,null,12249,"Buchanan",2010,335,0,5,121.5,"2011-07-28","Federal Shipping"]
[null,null,12250,"Buchanan",2010,341,0,12,168,"2011-07-28","Federal Shipping"]
[null,null,12251,"Leverling",2009,322,5.0000001000000002E-2,6,95.76,"2011-07-27","Speedy Express"]
[null,null,12252,"Leverling",2009,343,5.0000001000000002E-2,15,222.3,"2011-07-27","Speedy Express"]
[null,null,12253,"Leverling",2009,331,0,20,336,"2011-07-27","Speedy Express"]
[null,null,12254,"Fuller",2001,338,0,20,240,"2011-08-24","Speedy Express"]
[0,null,12255,"Fuller",2001,301,0,30,936,"2011-08-24","Speedy Express"]
[null,null,12256,"Suyama",2010,311,0,20,344,"2011-08-28","Speedy Express"]
[null,null,12257,"Suyama",2010,335,0,7,194.6,"2011-08-28","Speedy Express"]
[null,null,12258,"Fuller",2010,314,0,4,121.6,"2011-09-22","United Package"]
[null,null,12259,"Buchanan",2001,306,0,60,864,"2011-09-22","United Package"]
[null,null,12260,"Buchanan",2001,335,0,20,556,"2011-09-22","United Package"]
[null,null,12261,"Davolio",2003,349,0,6,67.2,"2011-10-08","Federal Shipping"]
[null,null,12262,"Davolio",2003,319,0,7,201.6,"2011-10-08","Federal Shipping"]
[null,null,12263,"Dodsworth",2002,359,0,15,88.5,"2011-11-02","Speedy Express"]
[null,null,12264,"Callahan",2009,310,0,8,44.8,"2011-11-09","United Package"]
[null,null,12265,"Callahan",2009,348,0,10,100,"2011-11-09","United Package"]
[null,null,12266,"Davolio",2002,325,5.0000001000000002E-2,40,1398.4,"2011-11-20","Federal Shipping"]
[null,null,12267,"Davolio",2002,303,5.0000001000000002E-2,20,950,"2011-11-20","Federal Shipping"]
[null,null,12268,"Davolio",2002,326,5.0000001000000002E-2,12,87.78,"2011-11-20","Federal Shipping"]
[null,null,12269,"Suyama",2007,319,0.10000000100000001,18,466.56,"2011-12-15","United Package"]
[null,null,12270,"Suyama",2007,362,0.10000000100000001,15,175.5,"2011-12-15","United Package"]
[null,null,12271,"Buchanan",2007,346,5.0000001000000002E-2,10,106.4,"2011-12-09","Speedy Express"]
[null,null,12272,"Buchanan",2007,318,5.0000001000000002E-2,10,34.200000000000003,"2011-12-09","Speedy Express"]
[null,null,12273,"Buchanan",2007,324,5.0000001000000002E-2,20,288.8,"2011-12-09","Speedy Express"]
[null,null,12274,"Peacock",2001,309,0,10,2108,"2011-12-14","Federal Shipping"]
[null,null,12275,"Peacock",2001,357,0,35,3465,"2011-12-14","Federal Shipping"]
[null,null,12276,"Peacock",2001,359,0,28,165.2,"2011-12-14","Federal Shipping"]
[null,null,12277,"Peacock",2001,345,0,30,1092,"2011-12-14","Federal Shipping"]
[null,null,12278,"Peacock",2001,334,0,35,560,"2011-12-14","Federal Shipping"]
[null,null,12279,"Leverling",2002,359,0,24,141.6,"2011-12-10","Speedy Express"]
[null,null,12280,"Leverling",2002,333,0,20,848,"2011-12-10","Speedy Express"]
[null,null,12281,"Leverling",2002,337,0,50,560,"2011-12-10","Speedy Express"]
[null,null,12282,"Davolio",2007,324,0.20000000300000001,6,72.959999999999994,"2012-01-05","Speedy Express"]
[null,null,12283,"Callahan",2004,359,0,6,35.4,"2012-01-26","Speedy Express"]
[null,null,12284,"Callahan",2004,317,0,10,208,"2012-01-26","Speedy Express"]
[null,null,12285,"Callahan",2004,355,0,35,1379,"2012-01-26","Speedy Express"]
[null,null,12286,"Leverling",2007,304,0,24,345.6,"2012-01-28","United Package"]
[null,null,12287,"Leverling",2007,328,0,14,201.6,"2012-01-28","United Package"]
[null,null,12288,"Leverling",2007,355,0,40,1576,"2012-01-28","United Package"]
[null,null,12289,"Suyama",2007,328,0.25,20,216,"2012-02-26","United Package"]
[null,null,12290,"Suyama",2007,339,0.25,10,144,"2012-02-26","United Package"]
[null,null,12291,"Leverling",2001,344,0.10000000100000001,24,133.91999999999999,"2012-02-23","United Package"]
[null,null,12292,"Leverling",2001,364,0.10000000100000001,30,718.2,"2012-02-23","United Package"]
[null,null,12293,"Leverling",2001,314,0.10000000100000001,40,1094.4000000000001,"2012-02-23","United Package"]
[null,null,12294,"Leverling",2001,353,0,5,48,"2012-02-23","United Package"]
[null,null,12295,"Leverling",2001,310,0,20,112,"2012-03-10","United Package"]
[null,null,12296,"Leverling",2001,323,0,14,347.2,"2012-03-10","United Package"]
[null,null,12297,"Leverling",2001,355,0,35,1379,"2012-03-10","United Package"]
[null,null,12298,"Callahan",2009,359,0.20000000300000001,6,28.32,"2012-03-22","United Package"]
[null,null,12299,"Callahan",2009,323,0.20000000300000001,20,396.8,"2012-03-22","United Package"]
[null,null,12300,"Peacock",2007,312,0.20000000300000001,20,32,"2012-03-08","Federal Shipping"]
[null,null,12301,"Peacock",2007,353,0.20000000300000001,10,76.8,"2012-03-08","Federal Shipping"]
[null,null,12302,"Peacock",2007,340,0.20000000300000001,20,222.4,"2012-03-08","Federal Shipping"]
[null,null,12303,"Peacock",2009,335,0,40,1112,"2012-03-11","United Package"]
[null,null,12304,"Peacock",2009,361,5.0000001000000002E-2,16,364.8,"2012-03-11","United Package"]
[null,null,12305,"Peacock",2009,353,5.0000001000000002E-2,20,182.4,"2012-03-11","United Package"]
[null,null,12306,"Peacock",2002,360,0,15,108,"2012-03-25","United Package"]
[null,null,12307,"Peacock",2002,364,0,8,212.8,"2012-03-25","United Package"]
[null,null,12308,"Peacock",2002,303,0,30,1500,"2012-03-25","United Package"]
[null,null,12309,"Fuller",2009,323,5.0000001000000002E-2,20,471.2,"2012-04-06","Federal Shipping"]
[null,null,12310,"Suyama",2004,342,0,12,528,"2012-04-04","United Package"]
[null,null,12311,"Suyama",2004,365,0,30,228,"2012-04-04","United Package"]
[null,null,12312,"Peacock",2007,319,0.10000000100000001,10,259.2,"2012-04-21","Federal Shipping"]
[null,null,12313,"Peacock",2007,331,0.10000000100000001,15,226.8,"2012-04-21","Federal Shipping"]
[null,null,12314,"Peacock",2007,332,0.10000000100000001,10,122.4,"2012-04-21","Federal Shipping"]
[null,null,12315,"Suyama",2007,345,5.0000001000000002E-2,8,346.56,"2012-04-28","Speedy Express"]
[null,null,12316,"Suyama",2007,313,5.0000001000000002E-2,12,176.7,"2012-04-28","Speedy Express"]
[null,null,12317,"Peacock",2002,361,0.15000000599999999,50,1275,"2012-05-02","Federal Shipping"]
[null,null,12318,"Peacock",2002,307,0.15000000599999999,50,935,"2012-05-02","Federal Shipping"]
[null,null,12319,"Peacock",2002,336,0.15000000599999999,10,340,"2012-05-02","Federal Shipping"]
[null,null,12320,"Davolio",2002,324,0,30,570,"2012-06-03","United Package"]
[null,null,12321,"Davolio",2002,302,0.10000000100000001,15,248.4,"2012-06-03","United Package"]
[null,null,12322,"Davolio",2009,354,0,30,540,"2012-06-07","Federal Shipping"]
[null,null,12323,"Davolio",2009,361,0,10,300,"2012-06-07","Federal Shipping"]
[null,null,12324,"Davolio",2009,355,0,40,1972,"2012-06-07","Federal Shipping"]
[null,null,12325,"Suyama",2001,339,5.0000001000000002E-2,18,410.4,"2012-06-24","Speedy Express"]
[null,null,12326,"Suyama",2001,326,5.0000001000000002E-2,12,110.01,"2012-06-24","Speedy Express"]
[null,null,12327,"Dodsworth",2001,328,0,10,180,"2012-06-29","Speedy Express"]
[null,null,12328,"Dodsworth",2001,341,0.15000000599999999,35,624.75,"2012-06-29","Speedy Express"]
[null,null,12329,"Dodsworth",2001,303,0.15000000599999999,18,956.25,"2012-06-29","Speedy Express"]
[null,null,12330,"Peacock",2001,315,5.0000001000000002E-2,50,593.75,"2012-07-15","Speedy Express"]
[null,null,12331,"King",2003,304,0,3,54,"2012-08-10","United Package"]
[null,null,12332,"King",2003,323,0,10,310,"2012-08-10","United Package"]
[null,null,12333,"King",2003,351,0,6,60,"2012-08-10","United Package"]
[null,null,12334,"Callahan",2007,324,0.25,21,299.25,"2012-08-17","Speedy Express"]
[null,null,12335,"Peacock",2001,304,0,25,450,"2012-08-31","Federal Shipping"]
[null,null,12336,"Callahan",2007,344,0.10000000100000001,8,55.8,"2012-08-26","Speedy Express"]
[null,null,12337,"Peacock",2004,344,0,2,15.5,"2012-09-01","Federal Shipping"]
[null,null,12338,"Peacock",2004,333,0,15,795,"2012-09-01","Federal Shipping"]
[null,null,12339,"Peacock",2004,361,0,35,1050,"2012-09-01","Federal Shipping"]
[null,null,12340,"Peacock",2004,303,0,50,3125,"2012-09-01","Federal Shipping"]
[null,null,12341,"Fuller",2002,349,5.0000001000000002E-2,30,399,"2012-10-14","United Package"]
[null,null,12342,"Fuller",2002,333,5.0000001000000002E-2,20,1007,"2012-10-14","United Package"]
[null,null,12343,"Fuller",2002,302,5.0000001000000002E-2,30,524.4,"2012-10-14","United Package"]
[null,null,12344,"Davolio",2005,331,0,12,252.6,"2012-10-05","Speedy Express"]
[null,null,12345,"Davolio",2005,340,0,10,174.5,"2012-10-05","Speedy Express"]
[null,null,12346,"Davolio",2005,355,0,10,493,"2012-10-05","Speedy Express"]
[null,null,12347,"Callahan",2001,342,0,12,660,"2012-10-11","Federal Shipping"]
[null,null,12348,"Fuller",2003,310,0,9,63,"2012-10-12","Speedy Express"]
[null,null,12349,"Leverling",2002,311,0,30,645,"2012-11-09","Speedy Express"]
[null,null,12350,"Leverling",2002,323,0,21,651,"2012-11-09","Speedy Express"]
[null,null,12351,"Buchanan",2002,315,5.0000001000000002E-2,3,35.619999999999997,"2012-11-25","Speedy Express"]
[null,null,12352,"Buchanan",2002,331,5.0000001000000002E-2,10,199.97,"2012-11-25","Speedy Express"]
[null,null,12353,"Buchanan",2002,340,5.0000001000000002E-2,15,248.66,"2012-11-25","Speedy Express"]
[null,null,12354,"Leverling",2002,328,0,20,360,"2012-11-18","Speedy Express"]
[null,null,12355,"Fuller",2010,327,0,4,24,"2012-11-29","United Package"]
[null,null,12356,"Fuller",2010,326,0,12,115.8,"2012-11-29","United Package"]
[null,null,12357,"Fuller",2008,340,0,3,52.35,"2012-11-29","Speedy Express"]
[null,null,12358,"Leverling",2010,310,0,18,126,"2012-11-28","Federal Shipping"]
[null,null,12359,"Leverling",2010,324,0,6,114,"2012-11-28","Federal Shipping"]
[null,null,12360,"Peacock",2002,314,0.25,30,855,"2012-12-09","United Package"]
[null,null,12361,"Peacock",2002,343,0.25,14,204.75,"2012-12-09","United Package"]
[null,null,12362,"Peacock",2002,319,0.25,25,675,"2012-12-09","United Package"]
[null,null,12363,"Peacock",2002,365,0.25,30,213.75,"2012-12-09","United Package"]
[null,null,12364,"Leverling",2004,318,0,20,90,"2012-12-19","Federal Shipping"]
[null,null,12365,"Leverling",2004,322,0,6,126,"2012-12-19","Federal Shipping"]
[null,null,12366,"Leverling",2004,351,0,40,400,"2012-12-19","Federal Shipping"]
[null,null,12367,"Fuller",2007,305,5.0000001000000002E-2,15,270.75,"2013-01-06","Speedy Express"]
[null,null,12368,"Fuller",2007,357,5.0000001000000002E-2,20,2352.0100000000002,"2013-01-06","Speedy Express"]
[null,null,12369,"Davolio",2004,354,0,15,270,"2013-01-11","United Package"]
[null,null,12370,"Davolio",2004,303,0,30,1875,"2013-01-11","United Package"]
[null,null,12371,"Davolio",2004,363,0,30,1317,"2013-01-11","United Package"]
[null,null,12372,"Davolio",2004,348,0,18,225,"2013-01-11","United Package"]
[null,null,12373,"Leverling",2009,305,0.25,20,285,"2013-01-16","United Package"]
[null,null,12374,"Leverling",2009,330,0.25,15,112.5,"2013-01-16","United Package"]
[null,null,12375,"Leverling",2009,331,0,2,42.1,"2013-01-16","United Package"]
[null,null,12376,"Leverling",2009,325,0.15000000599999999,20,782,"2013-01-25","Federal Shipping"]
[null,null,12377,"Leverling",2009,326,0,20,193,"2013-01-25","Federal Shipping"]
[null,null,12378,"Leverling",2009,352,0.15000000599999999,30,726.75,"2013-01-25","Federal Shipping"]
[null,null,12379,"Leverling",2009,308,0.15000000599999999,8,86.7,"2013-01-25","Federal Shipping"]
[null,null,12380,"Suyama",2001,315,0,35,437.5,"2013-02-17","Speedy Express"]
[null,null,12381,"Suyama",2001,343,0,15,292.5,"2013-02-17","Speedy Express"]
[null,null,12382,"Davolio",2002,306,0,21,378,"2013-02-17","United Package"]
[null,null,12383,"Davolio",2002,323,0,15,465,"2013-02-17","United Package"]
[null,null,12384,"Fuller",2007,364,0,3,99.75,"2013-01-30","United Package"]
[null,null,12385,"Fuller",2007,327,0.20000000300000001,3,14.4,"2013-01-30","United Package"]
[null,null,12386,"Fuller",2007,320,0.20000000300000001,16,248.96,"2013-01-30","United Package"]
[null,null,12387,"Fuller",2007,337,0.20000000300000001,10,112,"2013-01-30","United Package"]
[null,null,12388,"Peacock",2009,333,0.25,4,159,"2013-02-06","United Package"]
[null,null,12389,"Davolio",2009,338,0.15000000599999999,30,382.5,"2013-02-10","Speedy Express"]
[null,null,12390,"Davolio",2009,312,0.15000000599999999,4,8.5,"2013-02-10","Speedy Express"]
[null,null,12391,"Davolio",2009,337,0.15000000599999999,20,238,"2013-02-10","Speedy Express"]
[null,null,12392,"Fuller",2006,338,0,4,60,"2013-02-14","Speedy Express"]
[null,null,12393,"Fuller",2006,361,0,5,150,"2013-02-14","Speedy Express"]
[null,null,12394,"Fuller",2006,347,0,10,439,"2013-02-14","Speedy Express"]
[null,null,12395,"Leverling",2005,328,0,20,360,"2013-02-15","Federal Shipping"]
[null,null,12396,"Leverling",2005,333,0,3,159,"2013-02-15","Federal Shipping"]
[null,null,12397,"Dodsworth",2002,301,5.0000001000000002E-2,16,592.79999999999995,"2013-02-21","United Package"]
[null,null,12398,"Dodsworth",2002,316,5.0000001000000002E-2,50,1187.5,"2013-02-21","United Package"]
[null,null,12399,"Dodsworth",2002,340,5.0000001000000002E-2,12,198.93,"2013-02-21","United Package"]
[null,null,12400,"King",2002,364,0,20,665,"2013-02-23","Federal Shipping"]
[null,null,12401,"King",2002,353,0,21,252,"2013-02-23","Federal Shipping"]
[null,null,12402,"King",2003,346,0,10,140,"2013-03-01","Speedy Express"]
[null,null,12403,"King",2003,301,0,15,585,"2013-03-01","Speedy Express"]
[null,null,12404,"King",2003,326,0,14,135.1,"2013-03-01","Speedy Express"]
[null,null,12405,"Suyama",2008,344,0,14,108.5,"2013-03-10","Federal Shipping"]
[null,null,12406,"King",2007,325,0.20000000300000001,10,368,"2013-03-24","Federal Shipping"]
[null,null,12407,"King",2007,329,0.20000000300000001,24,268.8,"2013-03-24","Federal Shipping"]
[null,null,12408,"King",2007,349,0.20000000300000001,10,112,"2013-03-24","Federal Shipping"]
[null,null,12409,"Peacock",2006,328,0,20,360,"2013-04-19","Speedy Express"]
[null,null,12410,"Peacock",2006,310,0,5,35,"2013-04-19","Speedy Express"]
[null,null,12411,"Peacock",2006,350,0,5,405,"2013-04-19","Speedy Express"]
[null,null,12412,"Callahan",2002,344,0.10000000100000001,20,139.5,"2013-04-04","Speedy Express"]
[null,null,12413,"Callahan",2002,335,0,16,556.79999999999995,"2013-04-04","Speedy Express"]
[null,null,12414,"Callahan",2002,355,0.10000000100000001,14,621.17999999999995,"2013-04-04","Speedy Express"]
[null,null,12415,"Callahan",2002,340,0.10000000100000001,30,471.15,"2013-04-04","Speedy Express"]
[null,null,12416,"Callahan",2002,361,0,8,240,"2013-04-03","Federal Shipping"]
[null,null,12417,"Callahan",2002,327,0,20,120,"2013-04-03","Federal Shipping"]
[null,null,12418,"Leverling",2008,309,0,5,1317.5,"2013-04-04","United Package"]
[null,null,12419,"Leverling",2008,319,0,10,360,"2013-04-04","United Package"]
[null,null,12420,"Leverling",2008,303,0,6,375,"2013-04-04","United Package"]
[null,null,12421,"Fuller",2005,357,0,14,1733.06,"2013-04-13","United Package"]
[null,null,12422,"Peacock",2006,301,0,6,234,"2013-04-06","United Package"]
[null,null,12423,"Peacock",2006,312,0,7,17.5,"2013-04-06","United Package"]
[null,null,12424,"Suyama",2006,344,0,10,77.5,"2013-04-07","United Package"]
[null,null,12425,"Suyama",2006,326,0,6,57.9,"2013-04-07","United Package"]
[null,null,12426,"Suyama",2006,321,0,5,156.15,"2013-04-07","United Package"]
[null,null,12427,"Buchanan",2008,341,0,10,210,"2013-05-10","United Package"]
[null,null,12428,"King",2007,318,0.20000000300000001,10,36,null,"Federal Shipping"]
[null,null,12429,"Peacock",2002,358,0.25,20,348.75,"2013-06-04","United Package"]
[null,null,12430,"Peacock",2002,316,0.25,20,375,"2013-06-03","United Package"]
[null,null,12431,"Peacock",2002,356,0.25,10,69,"2013-06-05","United Package"]

{"sheet":"Artikel (A)","index":12,"n_rows":70,"n_cols":6,"rows_kept":70,"cut":false,"hidden":false,"merged":[[1,1,1,4],[2,1,2,4]]}
[null,null,null,null,null,0]
[1,"Articles (E)",null,null,null,"Back to Start"]
[2,"Artikel (A)",null,null,null,"Startseite"]
[]
[null,null,"article_nr","article_name","article_price","category"]
[null,null,301,"Alice Mutton",31.2,"meat"]
[null,null,302,"Boston Crab Meat",18.399999999999999,"sea food"]
[null,null,303,"Carnarvon Tigers",50,"sea food"]
[null,null,304,"Chai",14.4,"beverages"]
[null,null,305,"Chang",19,"beverages"]
[null,null,306,"Chartreuse verte",14.4,"beverages"]
[null,null,307,"Chef Anton's Cajun Seasoning",22,"spices"]
[0,null,308,"Chocolade",12.75,"sweets"]
[null,null,309,"Côte de Blaye",210.8,"beverages"]
[null,null,310,"Filo Mix",5.6,"cereals"]
[null,null,311,"Fløtemysost",17.2,"milk products"]
[null,null,312,"Geitost",2,"milk products"]
[null,null,313,"Genen Shouyu",15.5,"spices"]
[null,null,314,"Gnocchi di nonna Alice",30.4,"cereals"]
[null,null,315,"Gorgonzola Telino",12.5,"milk products"]
[null,null,316,"Grandma's Boysenberry Spread",25,"spices"]
[null,null,317,"Gravad lax",20.8,"sea food"]
[null,null,318,"Guaraná Fantástica",3.6,"beverages"]
[null,null,319,"Gudbrandsdalsost",28.8,"milk products"]
[null,null,320,"Gula Malacca",19.45,"spices"]
[null,null,321,"Gumbär Gummibärchen",31.23,"sweets"]
[null,null,322,"Gustaf's Knäckebröd",16.8,"cereals"]
[null,null,323,"Ikura",24.8,"sea food"]
[null,null,324,"Inlagd Sill",15.2,"sea food"]
[null,null,325,"Ipoh Coffee",36.799999999999997,"beverages"]
[null,null,326,"Jack's New England Clam Chowder",7.7,"sea food"]
[null,null,327,"Konbu",6,"sea food"]
[null,null,328,"Lakkalikööri",14.4,"beverages"]
[null,null,329,"Laughing Lumberjack Lager",14,"beverages"]
[null,null,330,"Longlife Tofu",10,"natural products"]
[null,null,331,"Louisiana Fiery Hot Pepper Sauce",16.8,"spices"]
[null,null,332,"Louisiana Hot Spiced Okra",13.6,"spices"]
[null,null,333,"Manjimup Dried Apples",42.4,"natural products"]
[null,null,334,"Maxilaku",16,"sweets"]
[null,null,335,"Mozzarella di Giovanni",24.3,"milk products"]
[null,null,336,"Northwoods Cranberry Sauce",40,"spices"]
[null,null,337,"NuNuCa Nuß-Nougat-Creme",11.2,"sweets"]
[null,null,338,"Outback Lager",12,"beverages"]
[null,null,339,"Pâté chinois",19.2,"meat"]
[null,null,340,"Pavlova",13.9,"sweets"]
[null,null,341,"Queso Cabrales",14,"milk products"]
[null,null,342,"Raclette Courdavault",44,"milk products"]
[null,null,343,"Ravioli Angelo",15.6,"cereals"]
[null,null,344,"Rhönbräu Klosterbier",6.2,"beverages"]
[null,null,345,"Rössle Sauerkraut",36.4,"natural products"]
[null,null,346,"Sasquatch Ale",11.2,"beverages"]
[null,null,347,"Schoggi Schokolade",43.9,"sweets"]
[null,null,348,"Scottish Longbreads",10,"sweets"]
[null,null,349,"Singaporean Hokkien Fried Mee",9.8000000000000007,"cereals"]
[null,null,350,"Sir Rodney's Marmalade",81,"sweets"]
[null,null,351,"Sir Rodney's Scones",10,"sweets"]
[null,null,352,"Sirop d'érable",28.5,"spices"]
[null,null,353,"Spegesild",9.6,"sea food"]
[null,null,354,"Steeleye Stout",18,"beverages"]
[null,null,355,"Tarte au sucre",39.4,"sweets"]
[null,null,356,"Teatime Chocolate Biscuits",9.1999999999999993,"sweets"]
[null,null,357,"Thüringer Rostbratwurst",99,"meat"]
[null,null,358,"Tofu",23.25,"natural products"]
[null,null,359,"Tourtière",5.9,"meat"]
[null,null,360,"Tunnbröd",7.2,"cereals"]
[null,null,361,"Uncle Bob's Organic Dried Pears",24,"natural products"]
[null,null,362,"Valkoinen suklaa",13,"sweets"]
[null,null,363,"Vegie-spread",43.9,"spices"]
[null,null,364,"Wimmers gute Semmelknödel",26.6,"cereals"]
[null,null,365,"Zaanse koeken",7.6,"sweets"]

{"sheet":"Kunden (A)","index":13,"n_rows":15,"n_cols":7,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4],[2,1,2,4]]}
[null,null,null,null,null,0]
[1,"Customers (E)",null,null,null,"Back to Start"]
[2,"Kunden (A)",null,null,null,"Startseite"]
[]
[null,null,"customer_nr","customer_name","city","zip code","country"]
[null,null,2001,"Blondel père et fils","Strasbourg",67000,"France"]
[null,null,2002,"Bon app'","Marseille",13008,"France"]
[null,null,2003,"Du monde entier","Nantes",44000,"France"]
[null,null,2004,"Folies gourmandes","Lille",59000,"France"]
[null,null,2005,"France restauration","Nantes",44000,"France"]
[null,null,2006,"La corne d'abondance","Versailles",78000,"France"]
[null,null,2007,"La maison d'Asie","Toulouse",31000,"France"]
[0,null,2008,"Spécialités du monde","Paris",75016,"France"]
[null,null,2009,"Victuailles en stock","Lyon",69004,"France"]
[null,null,2010,"Vins et alcools Chevalier","Reims",51100,"France"]

{"sheet":"Pivot-Tabelle (A)","index":14,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[2,1,2,4]]}
[null,null,null,null,null,0]
[1,"Pivot table (E)",null,null,null,"Back to Start"]
[2,"Pivot-Tabelle (A)",null,null,null,"Startseite"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[0]