Excel每周膳食计划器和配方选择器

最新推荐文章于 2023-03-02 07:00:30 发布

culiao2169

最新推荐文章于 2023-03-02 07:00:30 发布

阅读量315

点赞数 1

文章标签： java 深度学习 c++ excel github

原文链接：https://contexturesblog.com/archives/2010/12/06/excel-weekly-meal-planner-with-recipe-selector/

版权

The problem with putting a lovely red geranium on your table is that you can end up remodelling the kitchen! (Do you remember that magic geranium fable?)

在桌子上放一个可爱的红色天竺葵的问题是，您最终可能会改造厨房！ (你还记得那个神奇的天竺葵寓言吗？)

Anyway, a while ago, I posted my Excel Weekly Meal Planner, which let you select meals for each weeknight, and print a grocery shopping list. All was well in my kitchen, as I happily planned my meals with that useful workbook.

无论如何，前一阵子，我发布了我的Excel Weekly Meal Planner，它使您可以在每个工作日中选择餐点并打印购物清单。当我高兴地用那本有用的工作簿计划进餐时，厨房里的一切都很好。

Then, JP from Code for Excel and Outlook, sent me a "geranium" -- a copy of my Excel Christmas Planner, with a fancy new Excel Recipe Selector worksheet. JP's workbook has code that looks up recipes via web API, and returns the result to Excel.

然后，来自Code for Excel and Outlook的JP给我发送了一个“天竺葵”-我的Excel Christmas Planner的副本，以及一个精美的新Excel Recipe Selector工作表。 JP的工作簿中的代码可通过Web API查找配方，并将结果返回到Excel。

For example, if you're tired of steamed carrots, you can enter "Carrots" in the Recipes worksheet, and find more exotic recipes online.

例如，如果您厌倦了蒸胡萝卜，则可以在“食谱”工作表中输入“胡萝卜”，然后在线查找更多奇特的食谱。

Thanks JP! Your enhancement works great, and now it will be easy to spice up those holiday meals.

谢谢JP！您的增强效果很好，现在可以轻松为那些节日大餐加些香料了。

重塑Excel每周膳食计划器 (Remodelling the Excel Weekly Meal Planner)

Yes, JP's Recipe Selector makes the Holiday Dinner Planner better, but it made my Excel Weekly Meal Planner look shabby! It needed a recipe selector too. In his blog post, JP showed the code for using the API, and had a link to another function that's required.

是的，JP的食谱选择器使假日晚餐计划者更好，但它使我的Excel Weekly Meal Planner显得简陋！它也需要一个配方选择器。 JP在他的博客文章中展示了使用API的代码，并链接到所需的另一个功能。

So, I copied the Recipes sheet from JP's workbook, and inserted it into my weekly meal planner file. It worked great in its new location, and I just had to change a couple of references in the code.

因此，我从JP的工作簿中复制了食谱表，并将其插入到我的每周膳食计划器文件中。它在新位置上运行良好，我只需要在代码中更改几个引用即可。

But...now the rest of the weekly meal planner looked a bit run down, so I decide to remodel it. After a couple of coats of paint, a new backsplash and a shiny new pivot table, it's ready for the open house.

但是...现在，每周的膳食计划程序的其余部分看起来都快用完了，所以我决定对其进行改版。经过几层油漆，新的后挡板和闪亮的新枢轴工作台后，就可以为开放日做准备了。

You can tour the remodelled version on the Excel Weekly Meal Planner page on the Contextures website, and download a copy to help plan your meals.

您可以在Contextures网站上的Excel Weekly Meal Planner页面上浏览经过修改的版本，并下载一份副本以帮助您计划用餐。