{"text_format":"1","workbook":"xls","n_sheets":3,"sheets":["Source Data","PivotTable Template","Sample PivotTable Report"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Source Data","index":0,"n_rows":287,"n_cols":4,"rows_kept":287,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
["Category","Product","Sales","Quarter"]
["Beverages","Chai",705.6,"Qtr 1"]
["Beverages","Chai",878.4,"Qtr 2"]
["Beverages","Chai",1174.5,"Qtr 3"]
["Beverages","Chai",2128.5,"Qtr 4"]
["Beverages","Chang",2720.8,"Qtr 1"]
["Beverages","Chang",228,"Qtr 2"]
["Beverages","Chang",2061.5,"Qtr 3"]
["Beverages","Chang",2028.25,"Qtr 4"]
["Beverages","Chartreuse verte",590.4,"Qtr 1"]
["Beverages","Chartreuse verte",360,"Qtr 2"]
["Beverages","Chartreuse verte",1100.7,"Qtr 3"]
["Beverages","Chartreuse verte",2424.6,"Qtr 4"]
["Beverages","Côte de Blaye",25127.36,"Qtr 1"]
["Beverages","Côte de Blaye",12806.1,"Qtr 2"]
["Beverages","Côte de Blaye",7312.12,"Qtr 3"]
["Beverages","Côte de Blaye",1317.5,"Qtr 4"]
["Beverages","Guaraná Fantástica",529.2,"Qtr 1"]
["Beverages","Guaraná Fantástica",467.55,"Qtr 2"]
["Beverages","Guaraná Fantástica",219.37,"Qtr 3"]
["Beverages","Guaraná Fantástica",337.5,"Qtr 4"]
["Beverages","Ipoh Coffee",1398.4,"Qtr 1"]
["Beverages","Ipoh Coffee",4496.5,"Qtr 2"]
["Beverages","Ipoh Coffee",1196,"Qtr 3"]
["Beverages","Ipoh Coffee",3979,"Qtr 4"]
["Beverages","Lakkalikööri",1141.92,"Qtr 1"]
["Beverages","Lakkalikööri",1774.08,"Qtr 2"]
["Beverages","Lakkalikööri",3261.6,"Qtr 3"]
["Beverages","Lakkalikööri",1705.5,"Qtr 4"]
["Beverages","Laughing Lumberjack Lager",518,"Qtr 2"]
["Beverages","Laughing Lumberjack Lager",350,"Qtr 3"]
["Beverages","Laughing Lumberjack Lager",42,"Qtr 4"]
["Beverages","Outback Lager",1508.4,"Qtr 1"]
["Beverages","Outback Lager",384,"Qtr 2"]
["Beverages","Outback Lager",1252.5,"Qtr 3"]
["Beverages","Outback Lager",2683.5,"Qtr 4"]
["Beverages","Rhönbräu Klosterbier",214.52,"Qtr 1"]
["Beverages","Rhönbräu Klosterbier",1508.92,"Qtr 2"]
["Beverages","Rhönbräu Klosterbier",1233.8,"Qtr 3"]
["Beverages","Rhönbräu Klosterbier",1233.8,"Qtr 4"]
["Beverages","Sasquatch Ale",179.2,"Qtr 1"]
["Beverages","Sasquatch Ale",1037.4,"Qtr 2"]
["Beverages","Sasquatch Ale",750.4,"Qtr 4"]
["Beverages","Steeleye Stout",1742.4,"Qtr 1"]
["Beverages","Steeleye Stout",1008,"Qtr 2"]
["Beverages","Steeleye Stout",1683,"Qtr 3"]
["Beverages","Steeleye Stout",1273.5,"Qtr 4"]
["Condiments","Aniseed Syrup",544,"Qtr 1"]
["Condiments","Aniseed Syrup",600,"Qtr 2"]
["Condiments","Aniseed Syrup",140,"Qtr 3"]
["Condiments","Aniseed Syrup",440,"Qtr 4"]
["Condiments","Chef Anton's Cajun Seasoning",225.28,"Qtr 1"]
["Condiments","Chef Anton's Cajun Seasoning",2970,"Qtr 2"]
["Condiments","Chef Anton's Cajun Seasoning",1337.6,"Qtr 3"]
["Condiments","Chef Anton's Cajun Seasoning",682,"Qtr 4"]
["Condiments","Chef Anton's Gumbo Mix",288.22,"Qtr 3"]
["Condiments","Chef Anton's Gumbo Mix",85.4,"Qtr 4"]
["Condiments","Genen Shouyu",176.7,"Qtr 2"]
["Condiments","Genen Shouyu",1298.12,"Qtr 3"]
["Condiments","Grandma's Boysenberry Spread",1750,"Qtr 3"]
["Condiments","Grandma's Boysenberry Spread",750,"Qtr 4"]
["Condiments","Gula Malacca",1994.85,"Qtr 1"]
["Condiments","Gula Malacca",1753.62,"Qtr 2"]
["Condiments","Gula Malacca",1093.09,"Qtr 3"]
["Condiments","Gula Malacca",1701.87,"Qtr 4"]
["Condiments","Louisiana Fiery Hot Pepper Sauce",1347.36,"Qtr 1"]
["Condiments","Louisiana Fiery Hot Pepper Sauce",2150.77,"Qtr 2"]
["Condiments","Louisiana Fiery Hot Pepper Sauce",1975.54,"Qtr 3"]
["Condiments","Louisiana Fiery Hot Pepper Sauce",3857.41,"Qtr 4"]
["Condiments","Louisiana Hot Spiced Okra",816,"Qtr 1"]
["Condiments","Louisiana Hot Spiced Okra",1224,"Qtr 2"]
["Condiments","Louisiana Hot Spiced Okra",918,"Qtr 4"]
["Condiments","Northwoods Cranberry Sauce",1300,"Qtr 2"]
["Condiments","Northwoods Cranberry Sauce",2960,"Qtr 4"]
["Condiments","Original Frankfurter grüne Soße",1112.8,"Qtr 1"]
["Condiments","Original Frankfurter grüne Soße",1027.78,"Qtr 2"]
["Condiments","Original Frankfurter grüne Soße",2255.5,"Qtr 3"]
["Condiments","Original Frankfurter grüne Soße",510.9,"Qtr 4"]
["Condiments","Sirop d'érable",2679,"Qtr 1"]
["Condiments","Sirop d'érable",1881,"Qtr 2"]
["Condiments","Sirop d'érable",3021,"Qtr 3"]
["Condiments","Sirop d'érable",1510.5,"Qtr 4"]
["Condiments","Vegie-spread",3202.87,"Qtr 1"]
["Condiments","Vegie-spread",263.4,"Qtr 2"]
["Condiments","Vegie-spread",842.88,"Qtr 3"]
["Condiments","Vegie-spread",2590.1,"Qtr 4"]
["Confections","Chocolade",744.6,"Qtr 1"]
["Confections","Chocolade",162.56,"Qtr 2"]
["Confections","Chocolade",68.85,"Qtr 3"]
["Confections","Chocolade",306,"Qtr 4"]
["Confections","Gumbär Gummibärchen",5079.6,"Qtr 1"]
["Confections","Gumbär Gummibärchen",1249.2,"Qtr 2"]
["Confections","Gumbär Gummibärchen",2061.17,"Qtr 3"]
["Confections","Gumbär Gummibärchen",2835.68,"Qtr 4"]
["Confections","Maxilaku",1605.6,"Qtr 1"]
["Confections","Maxilaku",620,"Qtr 2"]
["Confections","Maxilaku",835,"Qtr 3"]
["Confections","NuNuCa Nuß-Nougat-Creme",193.2,"Qtr 1"]
["Confections","NuNuCa Nuß-Nougat-Creme",865.2,"Qtr 2"]
["Confections","NuNuCa Nuß-Nougat-Creme",493.5,"Qtr 4"]
["Confections","Pavlova",1685.36,"Qtr 1"]
["Confections","Pavlova",2646.08,"Qtr 2"]
["Confections","Pavlova",1849.7,"Qtr 3"]
["Confections","Pavlova",999.01,"Qtr 4"]
["Confections","Schoggi Schokolade",1755,"Qtr 1"]
["Confections","Schoggi Schokolade",5268,"Qtr 2"]
["Confections","Schoggi Schokolade",2195,"Qtr 3"]
["Confections","Schoggi Schokolade",1756,"Qtr 4"]
["Confections","Scottish Longbreads",1267.5,"Qtr 1"]
["Confections","Scottish Longbreads",1062.5,"Qtr 2"]
["Confections","Scottish Longbreads",492.5,"Qtr 3"]
["Confections","Scottish Longbreads",1935,"Qtr 4"]
["Confections","Sir Rodney's Marmalade",4252.5,"Qtr 2"]
["Confections","Sir Rodney's Marmalade",1360.8,"Qtr 3"]
["Confections","Sir Rodney's Marmalade",1701,"Qtr 4"]
["Confections","Sir Rodney's Scones",1418,"Qtr 1"]
["Confections","Sir Rodney's Scones",756,"Qtr 2"]
["Confections","Sir Rodney's Scones",1733,"Qtr 3"]
["Confections","Sir Rodney's Scones",1434,"Qtr 4"]
["Confections","Tarte au sucre",4728,"Qtr 1"]
["Confections","Tarte au sucre",4547.92,"Qtr 2"]
["Confections","Tarte au sucre",5472.3,"Qtr 3"]
["Confections","Tarte au sucre",6014.6,"Qtr 4"]
["Confections","Teatime Chocolate Biscuits",943.89,"Qtr 1"]
["Confections","Teatime Chocolate Biscuits",349.6,"Qtr 2"]
["Confections","Teatime Chocolate Biscuits",841.8,"Qtr 3"]
["Confections","Teatime Chocolate Biscuits",204.7,"Qtr 4"]
["Confections","Valkoinen suklaa",845,"Qtr 1"]
["Confections","Valkoinen suklaa",385.94,"Qtr 3"]
["Confections","Valkoinen suklaa",942.5,"Qtr 4"]
["Confections","Zaanse koeken",817,"Qtr 1"]
["Confections","Zaanse koeken",285.95,"Qtr 2"]
["Confections","Zaanse koeken",668.8,"Qtr 3"]
["Confections","Zaanse koeken",1159,"Qtr 4"]
["Dairy Products","Camembert Pierrot",3329.28,"Qtr 1"]
["Dairy Products","Camembert Pierrot",3989.9,"Qtr 2"]
["Dairy Products","Camembert Pierrot",10273.1,"Qtr 3"]
["Dairy Products","Camembert Pierrot",3060,"Qtr 4"]
["Dairy Products","Fløtemysost",4454.8,"Qtr 1"]
["Dairy Products","Fløtemysost",174.15,"Qtr 2"]
["Dairy Products","Fløtemysost",2541.29,"Qtr 3"]
["Dairy Products","Fløtemysost",2472.5,"Qtr 4"]
["Dairy Products","Geitost",294,"Qtr 1"]
["Dairy Products","Geitost",242.5,"Qtr 2"]
["Dairy Products","Geitost",99.5,"Qtr 3"]
["Dairy Products","Geitost",150,"Qtr 4"]
["Dairy Products","Gorgonzola Telino",487,"Qtr 1"]
["Dairy Products","Gorgonzola Telino",2993.12,"Qtr 2"]
["Dairy Products","Gorgonzola Telino",1458.75,"Qtr 3"]
["Dairy Products","Gorgonzola Telino",2681.87,"Qtr 4"]
["Dairy Products","Gudbrandsdalsost",2649.6,"Qtr 1"]
["Dairy Products","Gudbrandsdalsost",1267.2,"Qtr 2"]
["Dairy Products","Gudbrandsdalsost",4473,"Qtr 3"]
["Dairy Products","Gudbrandsdalsost",5652,"Qtr 4"]
["Dairy Products","Mascarpone Fabioli",2220.8,"Qtr 2"]
["Dairy Products","Mascarpone Fabioli",448,"Qtr 4"]
["Dairy Products","Mozzarella di Giovanni",1973.8,"Qtr 1"]
["Dairy Products","Mozzarella di Giovanni",4488.2,"Qtr 2"]
["Dairy Products","Mozzarella di Giovanni",3027.6,"Qtr 3"]
["Dairy Products","Mozzarella di Giovanni",2349,"Qtr 4"]
["Dairy Products","Queso Cabrales",1357.44,"Qtr 1"]
["Dairy Products","Queso Cabrales",3029.25,"Qtr 2"]
["Dairy Products","Queso Cabrales",504,"Qtr 3"]
["Dairy Products","Queso Cabrales",656.25,"Qtr 4"]
["Dairy Products","Queso Manchego La Pastora",456,"Qtr 1"]
["Dairy Products","Queso Manchego La Pastora",1396.5,"Qtr 2"]
["Dairy Products","Queso Manchego La Pastora",1162.8,"Qtr 3"]
["Dairy Products","Queso Manchego La Pastora",5320,"Qtr 4"]
["Dairy Products","Raclette Courdavault",9116.8,"Qtr 1"]
["Dairy Products","Raclette Courdavault",7452.5,"Qtr 2"]
["Dairy Products","Raclette Courdavault",5087.5,"Qtr 3"]
["Dairy Products","Raclette Courdavault",11959.75,"Qtr 4"]
["Grains/Cereals","Filo Mix",187.6,"Qtr 1"]
["Grains/Cereals","Filo Mix",742,"Qtr 2"]
["Grains/Cereals","Filo Mix",226.8,"Qtr 3"]
["Grains/Cereals","Filo Mix",911.75,"Qtr 4"]
["Grains/Cereals","Gnocchi di nonna Alice",6931.2,"Qtr 1"]
["Grains/Cereals","Gnocchi di nonna Alice",9868.6,"Qtr 2"]
["Grains/Cereals","Gnocchi di nonna Alice",6771.6,"Qtr 3"]
["Grains/Cereals","Gnocchi di nonna Alice",9032.6,"Qtr 4"]
["Grains/Cereals","Gustaf's Knäckebröd",201.6,"Qtr 1"]
["Grains/Cereals","Gustaf's Knäckebröd",504,"Qtr 2"]
["Grains/Cereals","Gustaf's Knäckebröd",3318,"Qtr 3"]
["Grains/Cereals","Gustaf's Knäckebröd",210,"Qtr 4"]
["Grains/Cereals","Ravioli Angelo",499.2,"Qtr 1"]
["Grains/Cereals","Ravioli Angelo",87.75,"Qtr 2"]
["Grains/Cereals","Ravioli Angelo",585,"Qtr 3"]
["Grains/Cereals","Ravioli Angelo",984.75,"Qtr 4"]
["Grains/Cereals","Singaporean Hokkien Fried Mee",985.6,"Qtr 1"]
["Grains/Cereals","Singaporean Hokkien Fried Mee",912.8,"Qtr 2"]
["Grains/Cereals","Singaporean Hokkien Fried Mee",2307.2,"Qtr 3"]
["Grains/Cereals","Singaporean Hokkien Fried Mee",978.6,"Qtr 4"]
["Grains/Cereals","Tunnbröd",979.2,"Qtr 1"]
["Grains/Cereals","Tunnbröd",778.5,"Qtr 2"]
["Grains/Cereals","Tunnbröd",423,"Qtr 3"]
["Grains/Cereals","Tunnbröd",396,"Qtr 4"]
["Grains/Cereals","Wimmers gute Semmelknödel",2912.7,"Qtr 1"]
["Grains/Cereals","Wimmers gute Semmelknödel",1735.65,"Qtr 2"]
["Grains/Cereals","Wimmers gute Semmelknödel",1679.12,"Qtr 3"]
["Grains/Cereals","Wimmers gute Semmelknödel",798,"Qtr 4"]
["Meat/Poultry","Alice Mutton",2667.6,"Qtr 1"]
["Meat/Poultry","Alice Mutton",4013.1,"Qtr 2"]
["Meat/Poultry","Alice Mutton",3900,"Qtr 3"]
["Meat/Poultry","Alice Mutton",6000.15,"Qtr 4"]
["Meat/Poultry","Mishi Kobe Niku",1396.8,"Qtr 1"]
["Meat/Poultry","Mishi Kobe Niku",1319.2,"Qtr 2"]
["Meat/Poultry","Mishi Kobe Niku",4219.5,"Qtr 4"]
["Meat/Poultry","Pâté chinois",5710.08,"Qtr 1"]
["Meat/Poultry","Pâté chinois",1316.4,"Qtr 2"]
["Meat/Poultry","Pâté chinois",864,"Qtr 3"]
["Meat/Poultry","Pâté chinois",936,"Qtr 4"]
["Meat/Poultry","Perth Pasties",5154.85,"Qtr 1"]
["Meat/Poultry","Perth Pasties",2099.2,"Qtr 2"]
["Meat/Poultry","Perth Pasties",1500.6,"Qtr 3"]
["Meat/Poultry","Perth Pasties",4029.48,"Qtr 4"]
["Meat/Poultry","Thüringer Rostbratwurst",5702.4,"Qtr 1"]
["Meat/Poultry","Thüringer Rostbratwurst",4456.44,"Qtr 2"]
["Meat/Poultry","Thüringer Rostbratwurst",8912.88,"Qtr 3"]
["Meat/Poultry","Thüringer Rostbratwurst",14037.79,"Qtr 4"]
["Meat/Poultry","Tourtière",966.42,"Qtr 1"]
["Meat/Poultry","Tourtière",490.21,"Qtr 2"]
["Meat/Poultry","Tourtière",666.03,"Qtr 3"]
["Meat/Poultry","Tourtière",978.93,"Qtr 4"]
["Produce","Longlife Tofu",360,"Qtr 1"]
["Produce","Longlife Tofu",128,"Qtr 2"]
["Produce","Longlife Tofu",400,"Qtr 4"]
["Produce","Manjimup Dried Apples",1411.92,"Qtr 1"]
["Produce","Manjimup Dried Apples",8384.6,"Qtr 2"]
["Produce","Manjimup Dried Apples",1855,"Qtr 3"]
["Produce","Manjimup Dried Apples",11898.5,"Qtr 4"]
["Produce","Rössle Sauerkraut",4105.92,"Qtr 1"]
["Produce","Rössle Sauerkraut",3310.56,"Qtr 2"]
["Produce","Rössle Sauerkraut",1881,"Qtr 3"]
["Produce","Rössle Sauerkraut",3556.8,"Qtr 4"]
["Produce","Tofu",2018.1,"Qtr 1"]
["Produce","Tofu",2185.5,"Qtr 2"]
["Produce","Tofu",1866.97,"Qtr 3"]
["Produce","Tofu",470.81,"Qtr 4"]
["Produce","Uncle Bob's Organic Dried Pears",1084.8,"Qtr 1"]
["Produce","Uncle Bob's Organic Dried Pears",1575,"Qtr 2"]
["Produce","Uncle Bob's Organic Dried Pears",2700,"Qtr 3"]
["Produce","Uncle Bob's Organic Dried Pears",3826.5,"Qtr 4"]
["Seafood","Boston Crab Meat",1474.41,"Qtr 1"]
["Seafood","Boston Crab Meat",2272,"Qtr 2"]
["Seafood","Boston Crab Meat",3887.92,"Qtr 3"]
["Seafood","Boston Crab Meat",2162,"Qtr 4"]
["Seafood","Carnarvon Tigers",1500,"Qtr 1"]
["Seafood","Carnarvon Tigers",2362.5,"Qtr 2"]
["Seafood","Carnarvon Tigers",7100,"Qtr 3"]
["Seafood","Carnarvon Tigers",4987.5,"Qtr 4"]
["Seafood","Escargots de Bourgogne",265,"Qtr 2"]
["Seafood","Escargots de Bourgogne",1393.9,"Qtr 3"]
["Seafood","Escargots de Bourgogne",417.38,"Qtr 4"]
["Seafood","Gravad lax",208,"Qtr 1"]
["Seafood","Gravad lax",421.2,"Qtr 2"]
["Seafood","Ikura",1215.2,"Qtr 1"]
["Seafood","Ikura",533.2,"Qtr 2"]
["Seafood","Ikura",3747.9,"Qtr 3"]
["Seafood","Ikura",3323.2,"Qtr 4"]
["Seafood","Inlagd Sill",68.4,"Qtr 1"]
["Seafood","Inlagd Sill",2698,"Qtr 2"]
["Seafood","Inlagd Sill",2199.25,"Qtr 3"]
["Seafood","Inlagd Sill",1928.5,"Qtr 4"]
["Seafood","Jack's New England Clam Chowder",385,"Qtr 1"]
["Seafood","Jack's New England Clam Chowder",1242.52,"Qtr 2"]
["Seafood","Jack's New England Clam Chowder",468.51,"Qtr 3"]
["Seafood","Jack's New England Clam Chowder",2542.77,"Qtr 4"]
["Seafood","Konbu",61.44,"Qtr 1"]
["Seafood","Konbu",168,"Qtr 2"]
["Seafood","Konbu",469.5,"Qtr 3"]
["Seafood","Konbu",60,"Qtr 4"]
["Seafood","Nord-Ost Matjeshering",1308.24,"Qtr 1"]
["Seafood","Nord-Ost Matjeshering",1838.19,"Qtr 2"]
["Seafood","Nord-Ost Matjeshering",815.54,"Qtr 3"]
["Seafood","Nord-Ost Matjeshering",1922.33,"Qtr 4"]
["Seafood","Röd Kaviar",216,"Qtr 1"]
["Seafood","Röd Kaviar",714,"Qtr 2"]
["Seafood","Röd Kaviar",1646.25,"Qtr 3"]
["Seafood","Röd Kaviar",941.25,"Qtr 4"]
["Seafood","Røgede sild",205.2,"Qtr 1"]
["Seafood","Røgede sild",1007,"Qtr 2"]
["Seafood","Røgede sild",190,"Qtr 3"]
["Seafood","Røgede sild",1953.67,"Qtr 4"]
["Seafood","Spegesild",803.52,"Qtr 1"]
["Seafood","Spegesild",91.8,"Qtr 2"]
["Seafood","Spegesild",1504.8,"Qtr 3"]
["Seafood","Spegesild",823.2,"Qtr 4"]

{"sheet":"PivotTable Template","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}

{"sheet":"Sample PivotTable Report","index":2,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,"Sum of Sales"]
[null,"Category","Total"]
[null,"Beverages",102074.29]
[null,"Condiments",55277.56]
[null,"Confections",80894.11]
[null,"Dairy Products",114749.75]
[null,"Grains/Cereals",55948.82]
[null,"Meat/Poultry",81338.06]
[null,"Produce",53019.98]
[null,"Seafood",65544.19]
[null,"Grand Total",608846.76]