excel 足球 积分_Excel中的足球乐趣

excel 足球 积分

This Sunday is Super Bowl XLIX – the last one that will start with "XL".  Next year, it will be Super Bowl L – that doesn't exactly roll off the tongue!

这个星期天是XLIX超级碗-最后一个以“ XL”开头的超级碗。 明年，将是超级碗L –不会完全消失！

In 2011, I showed how you can use the ROMAN function in Excel, to change a number into a Roman numeral. That year, they were playing for the 45th time, which was XLV.

在2011年，我展示了如何在Excel中使用ROMAN函数将数字更改为罗马数字。 那一年，他们参加了第45次比赛，这是XLV。

=ROMAN(A2)

=罗马(A2)

其他足球功能 (Other Football Functions)

There are other Excel functions that sound like they could be used in a football game. Here are a few, and I'm sure you can think of others:

听起来还有其他Excel函数可以在足球比赛中使用。 这里有一些，我相信您会想到其他的：

• CONVERT
  兑换
• RECEIVE
  接收
• YIELD
  让
• SUBSTITUTE
  替代
• ISREF
  ISREF

Okay, that last one was a bit of a stretch, but I'll allow it. What functions did I miss?

好的，那最后一个有点麻烦，但我会允许的。 我错过了哪些功能？

关闭足球比赛 (Close Football Games)

While you wait for the game to start, you can look back at some historic games, with the data that Kevin Lehrbass compiled in an Excel file. You can download Kevin's workbook, which contains enough data to entertain you for a couple of days, while you try to decide which was the closest game.

等待游戏开始时，您可以回顾一些历史悠久的游戏，其中包括Kevin Lehrbass 在Excel文件中编译的数据。 您可以下载Kevin的工作簿，其中包含足够的数据可以让您娱乐几天，同时您可以尝试确定最接近的游戏。

Did Kevin think of all the factors that make a football game close, and exciting to watch?

凯文(Kevin)是否考虑了所有使足球比赛接近并令人兴奋的因素？

You can even select a couple of Super Bowls, and compare them. Have fun, and enjoy Sunday's game!

您甚至可以选择几个超级碗，然后进行比较。 玩得开心，享受周日的比赛！

翻译自: https://contexturesblog.com/archives/2015/01/29/football-fun-in-excel/

excel 足球 积分