{"text_format":"3","workbook":"xlsx","n_sheets":9,"sheets":["How to use the Recipe Tracker","Recipe Contents","Category Setup","Spinach Feta Pizza","Empty Recipe 1","Empty Recipe 2","Empty Recipe 3","Empty Recipe 4","Empty Recipe 5"],"not_rendered":{"images":4,"defined_names":20},"read":"whole","date_system":"1900"}

{"sheet":"How to use the Recipe Tracker","index":0,"n_rows":25,"n_cols":5,"rows_kept":25,"merged":[[2,3,4,13],[4,1,11,1],[5,3,5,13],[6,3,6,12],[7,3,7,12],[8,3,8,12],[9,4,9,12],[10,4,10,12],[12,4,12,12],[13,4,13,12],[14,4,14,12],[15,4,15,12],[16,4,16,12],[17,3,17,12],[19,4,19,12],[20,4,20,12],[21,3,21,13],[22,3,22,12],[23,3,23,12],[24,3,24,7]]}
[null,"Johnson Family Recipe Tracker"]
[]
[null,"ABOUT THE RECIPE TRACKER",null,"Tracking Toolkit"]
[]
[null,"Go paperless and store your favorite recipes in this digital recipe tracker! \n\nAlong with adding recipe ingredients and instructions, this template enables you to rate your recipes, add tags and a photo, enter nutritional values, and more. \n\nUse the instructions on the right to help you get started. "]
[{"$nulls":3},"HOW DO I USE THE RECIPE TRACKER?"]
[{"$nulls":3},"The Recipe Contents sheet is your central hub for viewing your recipes at-a-glance. To view a specific recipe, click the Click to View link to the left of the recipe name to quickly jump to the recipe details. To return to the Recipe Contents, on the recipe sheet, click the Recipe Contents button. "]
[{"$nulls":3},"HOW DO I ADD MY OWN RECIPES?"]
[{"$nulls":3},"To get started, you can type over the Spinach Feta Pizza recipe we added as an example. Or, if you want to keep  the scrumptious sample recipe and try it sometime, add your information to a empty recipe sheet. If you need specific instructions, follow these steps."]
[{"$nulls":3},{"v":1,"d":"1."},"Click the Click to View link to the left of a recipe to navigate to that recipe sheet. "]
[{"$nulls":3},{"v":2,"d":"2."},"In cell E3, type your recipe name."]
[{"$nulls":3},{"v":3,"d":"3."},"Select cell G3 and select a recipe category from the drop down list. "]
[{"$nulls":4},"Tip: Modify the category drop down list on the Category Setup sheet."]
[{"$nulls":3},{"v":4,"d":"4."},"Fill out the remaining information, such as Ingredients, Directions, Tags, Nutritional Report Card, Calories, etc. "]
[{"$nulls":3},{"v":5,"d":"5."},"To add a photo of your completed recipe, right-click the photo or placeholder, click Change Picture, navigate to the location of your picture and select it, and then click Insert."]
[{"$nulls":3},{"v":6,"d":"6."},"To change the worksheet name, double-click the sheet tab, type your recipe name over the selected text, and the press Enter."]
[{"$nulls":4},"Note that the recipe name recipe name will automatically appear at the top of the recipe sheet and on the Recipe Contents page along with the recipe's category and tags. "]
[{"$nulls":3},"DATA ENTRY TIPS"]
[]
[{"$nulls":3},"● ","To add a new line, such as in the Directions cell, press Alt + Enter. "]
[{"$nulls":3},"● ","If you copy the Ingredients and Directions from a web page you can easily retain the template formatting when you paste. To do so, on the Home tab, in the Clipboard group, click the arrow below the Paste button and then click the Match Destination Formatting icon."]
[{"$nulls":3},"I ADDED MY RECIPIES, WHAT DO I DO NEXT?"]
[{"$nulls":3},"After you have built your database of recipes, the Recipe Contents page helps you easily find what you're looking for with a few clicks of your mouse using the Filter options. For example, if you’re searching for a main course, click the arrow next to Category, clear the (Select All) check box, click Main Course, and then click OK. You can narrow your results further by filtering on another field, such as Tags. To use the Tags filter, click the arrow next to Tags and in the Search text box type your search string, such as cheese, and click OK. "]
[{"$nulls":3},"For more information on filtering, click this link:"]
[{"$nulls":3},"Filter data in an Excel table"]

{"sheet":"Recipe Contents","index":1,"n_rows":9,"n_cols":10,"rows_kept":9}
["Recipe Tracker"]
[]
["LINK","RECIPE NAME","RATING","Star 1","Star 2","Star 3","Star 4","CATEGORY","TAGS","COMMENTS"]
[{"$f":"HYPERLINK(CONCATENATE(\"# '\",RecipeTOC[[#This Row],[RECIPE NAME]],\"'\",\"!A1\"),\"Click to view\")","v":"Click to view"},{"$f":"'Spinach Feta Pizza'!RecipeName","v":"Spinach Feta Pizza"},"4 stars",{"$f":"IF(RecipeTOC[[#This Row],[RATING]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[RATING]],1)),\"\")","v":4},{"$f":"IF(RecipeTOC[[#This Row],[RATING]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[RATING]],1)),\"\")","v":4},{"$f":"IF(RecipeTOC[[#This Row],[RATING]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[RATING]],1)),\"\")","v":4},{"$f":"IF(RecipeTOC[[#This Row],[RATING]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[RATING]],1)),\"\")","v":4},{"$f":"IFERROR(INDIRECT(\"'\"&RecipeTOC[[#This Row],[RECIPE NAME]]&\"'!Category\"),\"\")","v":"Main Course"},{"$f":"IFERROR(INDIRECT(\"'\"&RecipeTOC[[#This Row],[RECIPE NAME]]&\"'!Tags\"),\"\")","v":"pizza, spinach, feta, cheese"}]
[{"$f":"HYPERLINK(CONCATENATE(\"# '\",RecipeTOC[[#This Row],[RECIPE NAME]],\"'\",\"!A1\"),\"Click to view\")","v":"Click to view"},{"$f":"'Empty Recipe 1'!RecipeName","v":"Empty Recipe 1"},null,{"$f":"IF(RecipeTOC[[#This Row],[RATING]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[RATING]],1)),\"\")","v":""},{"$f":"IF(RecipeTOC[[#This Row],[RATING]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[RATING]],1)),\"\")","v":""},{"$f":"IF(RecipeTOC[[#This Row],[RATING]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[RATING]],1)),\"\")","v":""},{"$f":"IF(RecipeTOC[[#This Row],[RATING]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[RATING]],1)),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&RecipeTOC[[#This Row],[RECIPE NAME]]&\"'!Category\"),\"\")","v":0},{"$f":"IFERROR(INDIRECT(\"'\"&RecipeTOC[[#This Row],[RECIPE NAME]]&\"'!Tags\"),\"\")","v":0}]
[{"$f":"HYPERLINK(CONCATENATE(\"# '\",RecipeTOC[[#This Row],[RECIPE NAME]],\"'\",\"!A1\"),\"Click to view\")","v":"Click to view"},{"$f":"'Empty Recipe 2'!RecipeName","v":"Empty Recipe 2"},null,{"$f":"IF(RecipeTOC[[#This Row],[RATING]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[RATING]],1)),\"\")","v":""},{"$f":"IF(RecipeTOC[[#This Row],[RATING]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[RATING]],1)),\"\")","v":""},{"$f":"IF(RecipeTOC[[#This Row],[RATING]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[RATING]],1)),\"\")","v":""},{"$f":"IF(RecipeTOC[[#This Row],[RATING]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[RATING]],1)),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&RecipeTOC[[#This Row],[RECIPE NAME]]&\"'!Category\"),\"\")","v":0},{"$f":"IFERROR(INDIRECT(\"'\"&RecipeTOC[[#This Row],[RECIPE NAME]]&\"'!Tags\"),\"\")","v":0}]
[{"$f":"HYPERLINK(CONCATENATE(\"# '\",RecipeTOC[[#This Row],[RECIPE NAME]],\"'\",\"!A1\"),\"Click to view\")","v":"Click to view"},{"$f":"'Empty Recipe 3'!RecipeName","v":"Empty Recipe 3"},null,{"$f":"IF(RecipeTOC[[#This Row],[RATING]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[RATING]],1)),\"\")","v":""},{"$f":"IF(RecipeTOC[[#This Row],[RATING]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[RATING]],1)),\"\")","v":""},{"$f":"IF(RecipeTOC[[#This Row],[RATING]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[RATING]],1)),\"\")","v":""},{"$f":"IF(RecipeTOC[[#This Row],[RATING]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[RATING]],1)),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&RecipeTOC[[#This Row],[RECIPE NAME]]&\"'!Category\"),\"\")","v":0},{"$f":"IFERROR(INDIRECT(\"'\"&RecipeTOC[[#This Row],[RECIPE NAME]]&\"'!Tags\"),\"\")","v":0}]
[{"$f":"HYPERLINK(CONCATENATE(\"# '\",RecipeTOC[[#This Row],[RECIPE NAME]],\"'\",\"!A1\"),\"Click to view\")","v":"Click to view"},{"$f":"'Empty Recipe 4'!RecipeName","v":"Empty Recipe 4"},null,{"$f":"IF(RecipeTOC[[#This Row],[RATING]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[RATING]],1)),\"\")","v":""},{"$f":"IF(RecipeTOC[[#This Row],[RATING]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[RATING]],1)),\"\")","v":""},{"$f":"IF(RecipeTOC[[#This Row],[RATING]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[RATING]],1)),\"\")","v":""},{"$f":"IF(RecipeTOC[[#This Row],[RATING]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[RATING]],1)),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&RecipeTOC[[#This Row],[RECIPE NAME]]&\"'!Category\"),\"\")","v":0},{"$f":"IFERROR(INDIRECT(\"'\"&RecipeTOC[[#This Row],[RECIPE NAME]]&\"'!Tags\"),\"\")","v":0}]
[{"$f":"HYPERLINK(CONCATENATE(\"# '\",RecipeTOC[[#This Row],[RECIPE NAME]],\"'\",\"!A1\"),\"Click to view\")","v":"Click to view"},{"$f":"'Empty Recipe 5'!RecipeName","v":"Empty Recipe 5"},null,{"$f":"IF(RecipeTOC[[#This Row],[RATING]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[RATING]],1)),\"\")","v":""},{"$f":"IF(RecipeTOC[[#This Row],[RATING]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[RATING]],1)),\"\")","v":""},{"$f":"IF(RecipeTOC[[#This Row],[RATING]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[RATING]],1)),\"\")","v":""},{"$f":"IF(RecipeTOC[[#This Row],[RATING]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[RATING]],1)),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&RecipeTOC[[#This Row],[RECIPE NAME]]&\"'!Category\"),\"\")","v":0},{"$f":"IFERROR(INDIRECT(\"'\"&RecipeTOC[[#This Row],[RECIPE NAME]]&\"'!Tags\"),\"\")","v":0}]

{"sheet":"Category Setup","index":2,"n_rows":14,"n_cols":1,"rows_kept":14}
["Recipe Categories"]
[]
["CATEGORIES BY TYPE"]
["Appetizer"]
["Beverage"]
["Bread"]
["Casserole"]
["Dessert"]
["Kid's Kitchen"]
["Main Course"]
["Salad"]
["Sandwich"]
["Side dish"]
["Soup"]

{"sheet":"Spinach Feta Pizza","index":3,"n_rows":29,"n_cols":9,"rows_kept":29,"merged":[[0,0,0,4],[2,4,3,5],[6,5,30,6],[9,8,10,8],[15,1,16,3],[17,2,18,2],[17,3,18,3],[19,2,20,2],[19,3,20,3],[21,2,22,2],[21,3,22,3],[23,2,24,2],[23,3,24,3],[25,1,26,3],[28,1,29,3]]}
[{"$f":"\"Recipe: \"&RecipeName","v":"Recipe: Spinach Feta Pizza"}]
[{"$nulls":8},"PREP TIME"]
[{"$nulls":4},"Spinach Feta Pizza",null,"Main Course"]
[]
[{"$nulls":4},"INGREDIENTS","DIRECTIONS",null,null,"COOK TIME"]
[]
[{"$nulls":4},"3/4 cup warm water","In bread machine, place the first six ingredients on order suggested by manufacturer. \n\nSelect dough setting.  Check dough after 5 minutes of mixing: add 1 to 2 tablespoons of water or flour if needed. \n\nWhen cycle is complete, turn dough onto a lightly flowered surface. Knead for 1 minute. \n\nCover and let rest for 15 minutes. \n\nRoll into a 12-in. pizza pan. Cover and let rise in a warm place until puffed, about 20 minutes. \n\nSprinkle with garlic and garlic salt. Top with spinach, onion, mushrooms, cheeses, and basil. \n\nBake at 400 degrees F for 35-40 minutes or until crust is golden and cheese is melted. \n\nLet stand for 5 minutes before slicing. "]
[{"$nulls":4},"2 tablespoons olive or canola oil"]
[{"$nulls":4},"1/2 teaspoon salt"]
[{"$nulls":4},"2 cups bread flour",{"$nulls":3},"YIELD"]
[{"$nulls":4},"2 teaspoons active dry yeast"]
[{"$nulls":4},"1 garlic clove, minced"]
[{"$nulls":4},"1/8 teaspoon garlic salt"]
[{"$nulls":4},"2 cups chopped fresh spinach"]
[{"$nulls":4},"1 small red onion"]
[null,"NUTRITION REPORT CARD (amount per serving)",null,null,"1 cup sliced fresh mushrooms"]
[{"$nulls":4},"1 cup shredded mozzarella cheese"]
[null,null,10,"grams \ntotal fat","1/4 cup crumbled feta cheese"]
[{"$nulls":4},"1/2 teaspoon dried basil"]
[null,null,16,"milligrams\ncholesterol"]
[]
[null,null,401,"milligrams\nsodium"]
[]
[null,null,37,"grams\ncarbs"]
[]
[null,"RECIPE TAGS"]
[]
[]
[null,"pizza, spinach, feta, cheese"]

{"sheet":"Empty Recipe 1","index":4,"n_rows":26,"n_cols":9,"rows_kept":26,"merged":[[0,0,0,4],[2,4,3,5],[6,5,30,6],[9,8,10,8],[15,1,16,3],[17,2,18,2],[17,3,18,3],[19,2,20,2],[19,3,20,3],[21,2,22,2],[21,3,22,3],[23,2,24,2],[23,3,24,3],[25,1,26,3],[28,1,29,3]]}
[{"$f":"\"Recipe: \"&RecipeName","v":"Recipe: Empty Recipe 1"}]
[{"$nulls":8},"PREP TIME"]
[{"$nulls":4},"Empty Recipe 1"]
[]
[{"$nulls":4},"INGREDIENTS","DIRECTIONS",null,null,"COOK TIME"]
[]
[]
[]
[]
[{"$nulls":8},"YIELD"]
[]
[]
[]
[]
[]
[null,"NUTRITION REPORT CARD (amount per serving)"]
[]
[null,null,"#","grams \ntotal fat"]
[]
[null,null,"#","milligrams\ncholesterol"]
[]
[null,null,"#","milligrams\nsodium"]
[]
[null,null,"#","grams\ncarbs"]
[]
[null,"RECIPE TAGS"]

{"sheet":"Empty Recipe 2","index":5,"n_rows":26,"n_cols":9,"rows_kept":26,"merged":[[0,0,0,4],[2,4,3,5],[6,5,30,6],[9,8,10,8],[15,1,16,3],[17,2,18,2],[17,3,18,3],[19,2,20,2],[19,3,20,3],[21,2,22,2],[21,3,22,3],[23,2,24,2],[23,3,24,3],[25,1,26,3],[28,1,29,3]]}
[{"$f":"\"Recipe: \"&RecipeName","v":"Recipe: Empty Recipe 2"}]
[{"$nulls":8},"PREP TIME"]
[{"$nulls":4},"Empty Recipe 2"]
[]
[{"$nulls":4},"INGREDIENTS","DIRECTIONS",null,null,"COOK TIME"]
[]
[]
[]
[]
[{"$nulls":8},"YIELD"]
[]
[]
[]
[]
[]
[null,"NUTRITION REPORT CARD (amount per serving)"]
[]
[null,null,"#","grams \ntotal fat"]
[]
[null,null,"#","milligrams\ncholesterol"]
[]
[null,null,"#","milligrams\nsodium"]
[]
[null,null,"#","grams\ncarbs"]
[]
[null,"RECIPE TAGS"]

{"sheet":"Empty Recipe 3","index":6,"n_rows":26,"n_cols":9,"rows_kept":26,"merged":[[0,0,0,4],[2,4,3,5],[6,5,30,6],[9,8,10,8],[15,1,16,3],[17,2,18,2],[17,3,18,3],[19,2,20,2],[19,3,20,3],[21,2,22,2],[21,3,22,3],[23,2,24,2],[23,3,24,3],[25,1,26,3],[28,1,29,3]]}
[{"$f":"\"Recipe: \"&RecipeName","v":"Recipe: Empty Recipe 3"}]
[{"$nulls":8},"PREP TIME"]
[{"$nulls":4},"Empty Recipe 3"]
[]
[{"$nulls":4},"INGREDIENTS","DIRECTIONS",null,null,"COOK TIME"]
[]
[]
[]
[]
[{"$nulls":8},"YIELD"]
[]
[]
[]
[]
[]
[null,"NUTRITION REPORT CARD (amount per serving)"]
[]
[null,null,"#","grams \ntotal fat"]
[]
[null,null,"#","milligrams\ncholesterol"]
[]
[null,null,"#","milligrams\nsodium"]
[]
[null,null,"#","grams\ncarbs"]
[]
[null,"RECIPE TAGS"]

{"sheet":"Empty Recipe 4","index":7,"n_rows":26,"n_cols":9,"rows_kept":26,"merged":[[0,0,0,4],[2,4,3,5],[6,5,30,6],[9,8,10,8],[15,1,16,3],[17,2,18,2],[17,3,18,3],[19,2,20,2],[19,3,20,3],[21,2,22,2],[21,3,22,3],[23,2,24,2],[23,3,24,3],[25,1,26,3],[28,1,29,3]]}
[{"$f":"\"Recipe: \"&RecipeName","v":"Recipe: Empty Recipe 4"}]
[{"$nulls":8},"PREP TIME"]
[{"$nulls":4},"Empty Recipe 4"]
[]
[{"$nulls":4},"INGREDIENTS","DIRECTIONS",null,null,"COOK TIME"]
[]
[]
[]
[]
[{"$nulls":8},"YIELD"]
[]
[]
[]
[]
[]
[null,"NUTRITION REPORT CARD (amount per serving)"]
[]
[null,null,"#","grams \ntotal fat"]
[]
[null,null,"#","milligrams\ncholesterol"]
[]
[null,null,"#","milligrams\nsodium"]
[]
[null,null,"#","grams\ncarbs"]
[]
[null,"RECIPE TAGS"]

{"sheet":"Empty Recipe 5","index":8,"n_rows":26,"n_cols":9,"rows_kept":26,"merged":[[0,0,0,4],[2,4,3,5],[6,5,30,6],[9,8,10,8],[15,1,16,3],[17,2,18,2],[17,3,18,3],[19,2,20,2],[19,3,20,3],[21,2,22,2],[21,3,22,3],[23,2,24,2],[23,3,24,3],[25,1,26,3],[28,1,29,3]]}
[{"$f":"\"Recipe: \"&RecipeName","v":"Recipe: Empty Recipe 5"}]
[{"$nulls":8},"PREP TIME"]
[{"$nulls":4},"Empty Recipe 5"]
[]
[{"$nulls":4},"INGREDIENTS","DIRECTIONS",null,null,"COOK TIME"]
[]
[]
[]
[]
[{"$nulls":8},"YIELD"]
[]
[]
[]
[]
[]
[null,"NUTRITION REPORT CARD (amount per serving)"]
[]
[null,null,"#","grams \ntotal fat"]
[]
[null,null,"#","milligrams\ncholesterol"]
[]
[null,null,"#","milligrams\nsodium"]
[]
[null,null,"#","grams\ncarbs"]
[]
[null,"RECIPE TAGS"]