{"text_format":"3","workbook":"xlsx","n_sheets":9,"sheets":["如何使用菜谱跟踪程序","菜谱目录","类别设置","菠菜羊奶乳酪披萨","空白菜谱 1","空白菜谱 2","空白菜谱 3","空白菜谱 4","空白菜谱 5"],"not_rendered":{"images":4,"defined_names":20},"read":"whole","date_system":"1900"}

{"sheet":"如何使用菜谱跟踪程序","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,"李先生家菜谱跟踪程序"]
[]
[null,"关于菜谱跟踪程序",null,"跟踪工具包"]
[]
[null,"迈向无纸化，将您喜欢的菜谱存储在此数字食谱跟踪程序中！\n\n除了添加菜谱原料和说明，此模板还允许您给菜谱打分、添加标签和照片、输入营养价值，等等。\n\n查看右侧的说明以帮助您开始。 "]
[{"$nulls":3},"如何使用菜谱跟踪程序？"]
[{"$nulls":3},"“菜谱目录”工作表是概览查看您的菜谱的中心位置。要查看特定菜谱，可单击菜谱名称左侧的“ 单击以查看 ”链接快速跳转到菜谱详细信息。要返回“菜谱目录”，请在菜谱工作表上单击“ 菜谱目录 ”按钮。 "]
[{"$nulls":3},"如何添加自己的菜谱？"]
[{"$nulls":3},"要开始，您可以在我们添加的菠菜羊奶乳酪披萨示例上进行覆盖键入。如果您希望保留这个美味示例菜谱，找个时间试做一下，那么您可以将您的信息添加到空白菜谱工作表中。如果您需要具体的指导，请按照下列步骤操作。"]
[{"$nulls":3},{"v":1,"d":"1."},"单击菜谱左侧的“ 单击以查看 ”链接可导航到相应菜谱的工作表。 "]
[{"$nulls":3},{"v":2,"d":"2."},"在单元格 E3中，键入您的菜谱名称。"]
[{"$nulls":3},{"v":3,"d":"3."},"选择单元格 G3 并从下拉列表中选择菜谱类别。 "]
[{"$nulls":4},"提示： 请修改“类别设置”工作表上的类别下拉列表。"]
[{"$nulls":3},{"v":4,"d":"4."},"填充其余信息，例如原料、说明、标签、营养报告卡、卡路里等。 "]
[{"$nulls":3},{"v":5,"d":"5."},"要添加您的成品的照片，请右键单击照片或占位符，然后单击“ 更改图片”，导航到您的图片所在的位置，然后单击“ 插入”。"]
[{"$nulls":3},{"v":6,"d":"6."},"要更改工作表名称，请双击工作表选项卡，在选中的文本上覆盖键入您的菜谱名称，然后按 Enter。"]
[{"$nulls":4},"注意，菜谱名称将自动显示在菜谱工作表的顶部，以及“菜谱目录”页上（与菜谱的类别和标签一起）。 "]
[{"$nulls":3},"数据输入提示"]
[]
[{"$nulls":3},"● ","要添加新行（例如在“说明”单元格中添加新行），请按 Alt + Enter。 "]
[{"$nulls":3},"● ","要执行此操作，请在“ 开始 ”选项卡上的“ 剪贴板 ”组中单击“ 粘贴 ”按钮下的箭头，然后单击“ 匹配目标格式 ”图标。"]
[{"$nulls":3},"我已添加菜谱，下一步做什么？"]
[{"$nulls":3},"您构建菜谱数据库后，只需单击几下鼠标使用“筛选”选项，“菜谱目录”页即可帮助您轻松查找要找的内容。例如，如果您要搜索一道主菜，则可单击“ 类别 ”旁边的箭头，取消“ 全选 ”复选框，单击“ 主菜”，然后单击“ “确定”。 您可以通过筛选另一字段（例如“标签”）来进一步缩小搜索结果范围。要使用“标签”筛选器，请单击“ 标签 ”旁的箭头，在“ 搜索 ”文本框中键入搜索字符串，例如“ 乳酪 ”，然后单击 “确定”。 "]
[{"$nulls":3},"有关筛选的详细信息，请单击此链接："]
[{"$nulls":3},"筛选 Excel 表格中的数据"]

{"sheet":"菜谱目录","index":1,"n_rows":9,"n_cols":10,"rows_kept":9}
["菜谱跟踪程序"]
[]
["链接","菜谱名称","得分","第 1 颗星","第 2 颗星","第 3 颗星","第 4 颗星","类别","标签","批注"]
[{"$f":"HYPERLINK(CONCATENATE(\"# '\",RecipeTOC[[#This Row],[菜谱名称]],\"'\",\"!A1\"),\"单击以查看\")","v":"单击以查看"},{"$f":"菠菜羊奶乳酪披萨!菜谱名称","v":"菠菜羊奶乳酪披萨"},"4 颗星",{"$f":"IF(RecipeTOC[[#This Row],[得分]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[得分]],1)),\"\")","v":4},{"$f":"IF(RecipeTOC[[#This Row],[得分]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[得分]],1)),\"\")","v":4},{"$f":"IF(RecipeTOC[[#This Row],[得分]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[得分]],1)),\"\")","v":4},{"$f":"IF(RecipeTOC[[#This Row],[得分]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[得分]],1)),\"\")","v":4},{"$f":"IFERROR(INDIRECT(\"'\"&RecipeTOC[[#This Row],[菜谱名称]]&\"'!类别\"),\"\")","v":"主菜"},{"$f":"IFERROR(INDIRECT(\"'\"&RecipeTOC[[#This Row],[菜谱名称]]&\"'!标签\"),\"\")","v":"披萨，菠菜，羊奶，乳酪"}]
[{"$f":"HYPERLINK(CONCATENATE(\"# '\",RecipeTOC[[#This Row],[菜谱名称]],\"'\",\"!A1\"),\"单击以查看\")","v":"单击以查看"},{"$f":"'空白菜谱 1'!菜谱名称","v":"空白菜谱 1"},null,{"$f":"IF(RecipeTOC[[#This Row],[得分]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[得分]],1)),\"\")","v":""},{"$f":"IF(RecipeTOC[[#This Row],[得分]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[得分]],1)),\"\")","v":""},{"$f":"IF(RecipeTOC[[#This Row],[得分]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[得分]],1)),\"\")","v":""},{"$f":"IF(RecipeTOC[[#This Row],[得分]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[得分]],1)),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&RecipeTOC[[#This Row],[菜谱名称]]&\"'!类别\"),\"\")","v":0},{"$f":"IFERROR(INDIRECT(\"'\"&RecipeTOC[[#This Row],[菜谱名称]]&\"'!标签\"),\"\")","v":0}]
[{"$f":"HYPERLINK(CONCATENATE(\"# '\",RecipeTOC[[#This Row],[菜谱名称]],\"'\",\"!A1\"),\"单击以查看\")","v":"单击以查看"},{"$f":"'空白菜谱 2'!菜谱名称","v":"空白菜谱 2"},null,{"$f":"IF(RecipeTOC[[#This Row],[得分]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[得分]],1)),\"\")","v":""},{"$f":"IF(RecipeTOC[[#This Row],[得分]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[得分]],1)),\"\")","v":""},{"$f":"IF(RecipeTOC[[#This Row],[得分]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[得分]],1)),\"\")","v":""},{"$f":"IF(RecipeTOC[[#This Row],[得分]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[得分]],1)),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&RecipeTOC[[#This Row],[菜谱名称]]&\"'!类别\"),\"\")","v":0},{"$f":"IFERROR(INDIRECT(\"'\"&RecipeTOC[[#This Row],[菜谱名称]]&\"'!标签\"),\"\")","v":0}]
[{"$f":"HYPERLINK(CONCATENATE(\"# '\",RecipeTOC[[#This Row],[菜谱名称]],\"'\",\"!A1\"),\"单击以查看\")","v":"单击以查看"},{"$f":"'空白菜谱 3'!菜谱名称","v":"空白菜谱 3"},null,{"$f":"IF(RecipeTOC[[#This Row],[得分]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[得分]],1)),\"\")","v":""},{"$f":"IF(RecipeTOC[[#This Row],[得分]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[得分]],1)),\"\")","v":""},{"$f":"IF(RecipeTOC[[#This Row],[得分]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[得分]],1)),\"\")","v":""},{"$f":"IF(RecipeTOC[[#This Row],[得分]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[得分]],1)),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&RecipeTOC[[#This Row],[菜谱名称]]&\"'!类别\"),\"\")","v":0},{"$f":"IFERROR(INDIRECT(\"'\"&RecipeTOC[[#This Row],[菜谱名称]]&\"'!标签\"),\"\")","v":0}]
[{"$f":"HYPERLINK(CONCATENATE(\"# '\",RecipeTOC[[#This Row],[菜谱名称]],\"'\",\"!A1\"),\"单击以查看\")","v":"单击以查看"},{"$f":"'空白菜谱 4'!菜谱名称","v":"空白菜谱 4"},null,{"$f":"IF(RecipeTOC[[#This Row],[得分]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[得分]],1)),\"\")","v":""},{"$f":"IF(RecipeTOC[[#This Row],[得分]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[得分]],1)),\"\")","v":""},{"$f":"IF(RecipeTOC[[#This Row],[得分]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[得分]],1)),\"\")","v":""},{"$f":"IF(RecipeTOC[[#This Row],[得分]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[得分]],1)),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&RecipeTOC[[#This Row],[菜谱名称]]&\"'!类别\"),\"\")","v":0},{"$f":"IFERROR(INDIRECT(\"'\"&RecipeTOC[[#This Row],[菜谱名称]]&\"'!标签\"),\"\")","v":0}]
[{"$f":"HYPERLINK(CONCATENATE(\"# '\",RecipeTOC[[#This Row],[菜谱名称]],\"'\",\"!A1\"),\"单击以查看\")","v":"单击以查看"},{"$f":"'空白菜谱 5'!菜谱名称","v":"空白菜谱 5"},null,{"$f":"IF(RecipeTOC[[#This Row],[得分]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[得分]],1)),\"\")","v":""},{"$f":"IF(RecipeTOC[[#This Row],[得分]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[得分]],1)),\"\")","v":""},{"$f":"IF(RecipeTOC[[#This Row],[得分]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[得分]],1)),\"\")","v":""},{"$f":"IF(RecipeTOC[[#This Row],[得分]]<>\"\",VALUE(LEFT(RecipeTOC[[#This Row],[得分]],1)),\"\")","v":""},{"$f":"IFERROR(INDIRECT(\"'\"&RecipeTOC[[#This Row],[菜谱名称]]&\"'!类别\"),\"\")","v":0},{"$f":"IFERROR(INDIRECT(\"'\"&RecipeTOC[[#This Row],[菜谱名称]]&\"'!标签\"),\"\")","v":0}]

{"sheet":"类别设置","index":2,"n_rows":14,"n_cols":1,"rows_kept":14}
["菜谱类别"]
[]
["按类型划分的类别"]
["开胃菜"]
["饮料"]
["面包"]
["砂锅"]
["甜点"]
["儿童餐"]
["主菜"]
["沙拉"]
["三明治"]
["小菜"]
["粥汤"]

{"sheet":"菠菜羊奶乳酪披萨","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":"\"菜谱：\"&菜谱名称","v":"菜谱：菠菜羊奶乳酪披萨"}]
[{"$nulls":8},"准备时间"]
[{"$nulls":4},"菠菜羊奶乳酪披萨",null,"主菜"]
[]
[{"$nulls":4},"原料","说明",null,null,"烹调时间"]
[]
[{"$nulls":4},"3/4 杯温水","在面包机中，按生产商建议的顺序投入前六种原料。\n\n选择揉面团程序。搅拌 5 分钟后检查面团：按情况添加 1 至 2 茶匙水或面粉。\n\n程序结束后，将面团取出放到撒了少许面粉的表面，揉 1 分钟。\n\n盖上盖饧 15 分钟。\n\n放入 12 寸披萨盘中。盖上盖，在温暖处饧发至面团膨胀，大约 20 分钟。\n\n撒上蒜和大蒜盐。在上面摆好菠菜、洋葱、蘑菇、乳酪和罗勒。\n\n400 华氏度烤 35-40 分钟，或烤至外皮呈金黄色且乳酪融化。\n\n等 5 分钟后再进行分切。 "]
[{"$nulls":4},"2 茶匙橄榄油或油菜籽油"]
[{"$nulls":4},"1/2 茶匙盐"]
[{"$nulls":4},"2 杯面包粉",{"$nulls":3},"产量"]
[{"$nulls":4},"2 茶匙活性干酵母"]
[{"$nulls":4},"1 瓣大蒜，切碎"]
[{"$nulls":4},"1/8 茶匙大蒜盐"]
[{"$nulls":4},"2 杯切碎的新鲜菠菜"]
[{"$nulls":4},"1 个小红洋葱"]
[null,"营养报告卡（每份含量）",null,null,"1 杯切碎的新鲜蘑菇"]
[{"$nulls":4},"1 杯马苏里拉芝士碎"]
[null,null,10,"克\n脂肪总量","1/4 杯羊奶酪屑"]
[{"$nulls":4},"1/2 茶匙干罗勒"]
[null,null,16,"毫克\n胆固醇"]
[]
[null,null,401,"毫克\n钠"]
[]
[null,null,37,"克\n碳水化合物"]
[]
[null,"菜谱标签"]
[]
[]
[null,"披萨，菠菜，羊奶，乳酪"]

{"sheet":"空白菜谱 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":"\"菜谱：\"&菜谱名称","v":"菜谱：空白菜谱 1"}]
[{"$nulls":8},"准备时间"]
[{"$nulls":4},"空白菜谱 1"]
[]
[{"$nulls":4},"原料","说明",null,null,"烹调时间"]
[]
[]
[]
[]
[{"$nulls":8},"产量"]
[]
[]
[]
[]
[]
[null,"营养报告卡（每份含量）"]
[]
[null,null,"#","克\n脂肪总量"]
[]
[null,null,"#","毫克\n胆固醇"]
[]
[null,null,"#","毫克\n钠"]
[]
[null,null,"#","克\n碳水化合物"]
[]
[null,"菜谱标签"]

{"sheet":"空白菜谱 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":"\"菜谱：\"&菜谱名称","v":"菜谱：空白菜谱 2"}]
[{"$nulls":8},"准备时间"]
[{"$nulls":4},"空白菜谱 2"]
[]
[{"$nulls":4},"原料","说明",null,null,"烹调时间"]
[]
[]
[]
[]
[{"$nulls":8},"产量"]
[]
[]
[]
[]
[]
[null,"营养报告卡（每份含量）"]
[]
[null,null,"#","克\n脂肪总量"]
[]
[null,null,"#","毫克\n胆固醇"]
[]
[null,null,"#","毫克\n钠"]
[]
[null,null,"#","克\n碳水化合物"]
[]
[null,"菜谱标签"]

{"sheet":"空白菜谱 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":"\"菜谱：\"&菜谱名称","v":"菜谱：空白菜谱 3"}]
[{"$nulls":8},"准备时间"]
[{"$nulls":4},"空白菜谱 3"]
[]
[{"$nulls":4},"原料","说明",null,null,"烹调时间"]
[]
[]
[]
[]
[{"$nulls":8},"产量"]
[]
[]
[]
[]
[]
[null,"营养报告卡（每份含量）"]
[]
[null,null,"#","克\n脂肪总量"]
[]
[null,null,"#","毫克\n胆固醇"]
[]
[null,null,"#","毫克\n钠"]
[]
[null,null,"#","克\n碳水化合物"]
[]
[null,"菜谱标签"]

{"sheet":"空白菜谱 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":"\"菜谱：\"&菜谱名称","v":"菜谱：空白菜谱 4"}]
[{"$nulls":8},"准备时间"]
[{"$nulls":4},"空白菜谱 4"]
[]
[{"$nulls":4},"原料","说明",null,null,"烹调时间"]
[]
[]
[]
[]
[{"$nulls":8},"产量"]
[]
[]
[]
[]
[]
[null,"营养报告卡（每份含量）"]
[]
[null,null,"#","克\n脂肪总量"]
[]
[null,null,"#","毫克\n胆固醇"]
[]
[null,null,"#","毫克\n钠"]
[]
[null,null,"#","克\n碳水化合物"]
[]
[null,"菜谱标签"]

{"sheet":"空白菜谱 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":"\"菜谱：\"&菜谱名称","v":"菜谱：空白菜谱 5"}]
[{"$nulls":8},"准备时间"]
[{"$nulls":4},"空白菜谱 5"]
[]
[{"$nulls":4},"原料","说明",null,null,"烹调时间"]
[]
[]
[]
[]
[{"$nulls":8},"产量"]
[]
[]
[]
[]
[]
[null,"营养报告卡（每份含量）"]
[]
[null,null,"#","克\n脂肪总量"]
[]
[null,null,"#","毫克\n胆固醇"]
[]
[null,null,"#","毫克\n钠"]
[]
[null,null,"#","克\n碳水化合物"]
[]
[null,"菜谱标签"]