{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Grocery Items","Instructions","Chart Data","SpellCheckSheet","Metrics","Stores","Brands","Types","Cities"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Grocery Items","index":0,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["Item Name","On Sale","Type","Brand","Metric","Store","City","Price"]
["Grapes",true,"Fruit","Produce","per Pound","Maceys","Spanish Fork",0.99]
["Apples",true,"Fruit","Produce","per Pound","Smiths","Provo",0.89]
["Salmon",false,"Fish","Bulk/Generic","per Pound","Maceys","Provo",6.99]
["Cookies",false,"Junk Food","Bulk/Generic","per Piece","Maceys","Provo",0.49]
["Grapes",true,"Fruit","Bulk/Generic","per Pound","Walmart","Springville",0.89]
["Grapes",false,"Fruit","Produce","per Pound","Costco","Provo",1.25]
["Grapes",false,"Fruit","Produce","per Pound","Allens","Springville",1.99]
["Cookies",false,"Junk Food","Kirkland","per Piece","Costco","Springville",0.25]
["Hamburger",false,"Beef","Bulk/Generic","per Pound","Reams","Springville",4.99]
["Salmon",true,"Fish","Bulk/Generic","per Pound","Winco Foods","Orem",4.99]
["Salmon",false,"Fish","Bulk/Generic","per Pound","Smiths","Provo",7.99]
["Apples",false,"Fruit","Produce","per Pound","Walmart","Orem",0.99]
["Chicken",false,"Poultry","Foster Farms","per Pound","Winco Foods","Orem",0.99]
["Peanut",false,"Seeds/Nuts","Bulk/Generic","per Pound","Winco Foods","Orem",0.65]

{"sheet":"Instructions","index":1,"n_rows":30,"n_cols":3,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Grocery Tracker"]
[]
[null,null,"Description"]
[]
[null,null,"The Grocery Tracker project was created to help people keep track of their every-day grocery purchases. Grocery stores are largely apprehensive toward allowing people to monitor their prices due to the enormous variability of prices from store to store (even within the same chain). This project allows the user to enter in prices paid for different products. The program will keep track of all of the entries and then display the lowest price for a given product when prompted."]
[]
[null,null,"Instructions"]
[]
[null,null,"Add Items"]
[]
[null,null,"In order to add items to the Grocery Tracker, simply click on the 'Grocery Tracker' tab, then select 'Add Product.' A form will then appear. Fill out the form, and press 'Save.'"]
[]
[null,null,"Manage Items"]
[]
[null,null,"Several options exist to customize the addition of products. Within the 'Add Product' form exist several buttons that allow a user to manage types, brands, metrics, stores, and cities. These come in handy when trying to identify which store has the cheapest product. Basic create, edit, and delete functions are supported. NOTE: though an management item may be deleted from the list, it will still apear within the list of products so as to preserve accuracy."]
[]
[null,null,"Find the Lowest Price"]
[]
[null,null,"In order to find the lowest price of a product on Grocery Tracker, click on the 'Grocery Tracker' tab, then select 'Find Lowest Price.' A form will then appear. Two filter options exist: 'Product Name' and 'Product Type.' These filters work alone or together. As the filter is populated, results begin to show up in the 'Lowest Price Results' list. Click on one and see things like the location, store name, brand, metric, and whether the item was on sale! Further price comparison tools exist (see 'Compare all Prices for a Given Priduct')"]
[]
[null,null,"Compare all Prices for a Given Product"]
[]
[null,null,"The user may also access the pricing for a whole product. This can be accomplished by pressing the 'Compare Other Options' button. This will take the user to a screen whereupon exists a graph displaying all of the different options for a given product. This screen also dicplays the same information in a list view. This allows the user maximum flexibility to choose the best option when price is not the only deciding factor."]
[]
[null,null,"Additional Information"]
[]
[null,null,"Author:    Morgan Young"]
[null,null,"Date:        12/11/2014"]

{"sheet":"Chart Data","index":2,"n_rows":5,"n_cols":2,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[null,"Price Comparison Chart"]
["Spanish Fork Maceys",0.99]
["Springville Walmart",0.89]
["Provo Costco",1.25]
["Springville Allens",1.99]

{"sheet":"SpellCheckSheet","index":3,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
["Planters"]

{"sheet":"Metrics","index":4,"n_rows":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["per Piece"]
["per Pound"]
["per Ounce"]
["per Gram"]
["per Cup"]
["per Pint"]
["per Quart"]
["per Gallon"]
["per Kilogram"]
["per Milligram"]
["per Liter"]
["per Milliliter"]

{"sheet":"Stores","index":5,"n_rows":11,"n_cols":1,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
["Maceys"]
["Smiths"]
["Costco"]
["Walmart"]
["Dollar Tree"]
["Allens"]
["Reams"]
["Walgreens"]
["Target"]
["Sam's Club"]
["Winco Foods"]

{"sheet":"Brands","index":6,"n_rows":17,"n_cols":1,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Bulk/Generic"]
["Produce"]
["Western Family"]
["Kirkland"]
["Great Value"]
["Hytop"]
["Foster Farms"]
["Farmer John's"]
["Old Spice"]
["Hershey's"]
["Pillsbury"]
["Betty Crocker"]
["Heinz"]
["Kraft"]
["Motts"]
["Quaker"]
["Planters"]

{"sheet":"Types","index":7,"n_rows":21,"n_cols":1,"rows_kept":21,"cut":false,"hidden":true,"merged":[]}
["Fruit"]
["Vegetable"]
["Seeds/Nuts"]
["Spices"]
["Fish"]
["Seafood"]
["Poultry"]
["Beef"]
["Pork"]
["Dairy"]
["Beverage"]
["Candy"]
["Junk Food"]
["Bread"]
["Cereal"]
["Canned Goods"]
["Frozen Foods"]
["Hygene Products"]
["Pharmacy"]
["Cleaning Products"]
["Paper Goods"]

{"sheet":"Cities","index":8,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Provo"]
["Spanish Fork"]
["Orem"]
["Pleasant Grove"]
["Springville"]