新浪天气天气预报_外面的天气很可怕

新浪天气天气预报

外面的天气很可怕 (The Weather Outside is Frightful)

Let it snow! One of the advantages of working from home in Canada, is that you don't have to go out in rush hour, on snowy days. I can sit in my office, basking in the glow of the computer monitor, mesmerized by the flickering of the modem lights.

让它下雪吧！ 在加拿大在家工作的优点之一是，您不必在下雪天的高峰时间外出。 我可以坐在办公室里，沐浴在计算机显示器的照耀下，被调制解调器灯的闪烁迷住。

But eventually I'll have to go out to do some shovelling, in the sub-zero temperatures. Later, while thawing out, I'll create an Excel file, to track the miserable temperature and snowfall accumulation.

但是最终，我将不得不出去在低于零的温度下进行一些调整。 稍后，在解冻时，我将创建一个Excel文件，以跟踪温度和降雪量的累积。

学位问题 (A Matter of Degree)

We record our temperatures in Celsius, while our neighbours in the USA use a Fahrenheit scale. So, while I'm shivering on a -10°C day, it seems much warmer across the lake, where it's a balmy 8°F.

I'm sure there are good reasons why the USA didn't switch to the metric system when Canada did, but for now, we can use Excel to convert the temperatures.

我敢肯定，为什么加拿大在美国没有采用公制时会有充分的理由，但是目前，我们可以使用Excel来转换温度。

使用算术 (Use Arithmetic)

Maybe the temperature in the USA really isn't as warm as it seems. To convert the temperature from Fahrenheit to Celsius , you can use this formula:

也许美国的气温确实不像看起来那样温暖。 要将温度从华氏温度转换为摄氏温度，可以使用以下公式：

°C = (°F – 32) x 5/9

°C =(°F – 32)x 5/9

If the Fahrenheit temperature is in cell B2, put this formula in cell C2:

如果华氏温度在单元格B2中，则将此公式放在单元格C2中：

=(B2 – 32) * 5/9

=(B2 – 32)* 5/9

When I convert that balmy 8°F, it makes me feel better – it's actually colder there, at -13°C.

当我将温和的8°F转换时，它会让我感觉更好–实际上，温度在-13°C时更冷。

让Excel对其进行转换 (Let Excel Convert It)

That formula isn't too difficult, but it might be hard to remember if your brain is affected by the cold weather. An easier way to convert the temperature is to use Excel's CONVERT function.

这个公式不太困难，但是如果您的大脑受到寒冷天气的影响，可能很难记住。 转换温度的一种简单方法是使用Excel的CONVERT函数。

Note: If you're using Excel 2003, or an earlier version, you'll need to install the Analysis ToolPak to use the CONVERT function.

注意：如果您使用的是Excel 2003或更早版本，则需要安装Analysis ToolPak才能使用CONVERT函数。

With the CONVERT function, you refer to the cell that contains the amount that you want to convert. Then you enter the original unit of measurement, and then the new unit of measurement.

使用CONVERT函数，可以引用包含要转换金额的单元格。 然后，您输入原始的度量单位，然后输入新的度量单位。

We want to convert the value in cell B2, from Celsius ("C") to Fahrenheit ("F").

我们想将单元格B2中的值从摄氏(“ C”)转换为华氏(“ F”)。

=CONVERT(B2,"C","F")

= CONVERT(B2，“ C”，“ F”)

Later, I can use CONVERT to see how many inches of snow we got, when the weather channel reports the snowfall in centimetres.

稍后，当天气频道报告以厘米为单位的降雪量时，我可以使用CONVERT看看我们得到了多少英寸的雪。

If you aren't sure what code to use for each unit of measurement, you can check the list in Excel's help for the CONVERT function.

如果不确定每个度量单位要使用什么代码，可以查看Excel帮助中的CONVERT函数列表。

Now I have to go and figure out how many glasses of wine are in that 750 ml bottle. I think the answer might be – not enough!

现在，我必须找出750毫升的瓶子中有几杯葡萄酒。 我认为答案可能是–不够！

翻译自: https://contexturesblog.com/archives/2009/12/09/the-weather-outside-is-frightful/

新浪天气天气预报