自谷歌将其尖端的双子座人工智能（Gemini AI）引入谷歌电子表格（Google Sheets）以来，已经过去了近九个月的时间。双子座人工智能以处理文本和图表而著称，如今它已涉足公式计算领域，在婚礼策划电子表格不可预知的混乱中茁壮成长。
Now when you’re confronted by a wall of data and need to figure out how best to sift through it, Gemini is here to help. Its chatbot sits on the right-hand side of Sheets, ready to respond to your queries about data manipulation. It offers you a selection of potential formulas, explains precisely how to use them, and helps you understand why they might not work as expected.
But the assistance from Gemini doesn’t stop at rectifying errors. Google’s innovative AI also presents you with an array of options if more than one formula can solve your problem. This means you’re not just blindly following instructions but also learning about the dynamics and flexibility of data management.
双子座的考验
I decided to put Gemini’s newfound capability to the test. So, I opened up my messy wedding guest spreadsheet – a monstrosity filled with names, email addresses, categories, and checkboxes. This spreadsheet was a result of my partner and I’s attempt to meticulously categorize an ever-expanding list of guests for our big day.
虽然我对客人名单的数学要求看起来相对简单，但我还是很想看看双子座是否真的能通过处理这些无序的数据来简化我的生活。
I started by asking Gemini to propose a formula for counting guests who RSVP’d ‘Yes’. The AI swiftly suggested a formula that used the COUNTIF function in the RSVP column. Normally, I would have needed a couple of Google searches to recall which function to use when tallying items that satisfy specific conditions. Yet, with Gemini’s help, the solution was right at my fingertips.
However, upon applying the formula, I was caught off guard as it informed me that not a single person had responded ‘Yes’ to my invitation. This, of course, couldn’t have been the case, since my wedding day was a joyous occasion filled with the presence of loved ones. Turns out, I had not been tracking RSVPs in my spreadsheet. Instead, all the accepted invitations were recorded on our wedding website.
领航高级领域
出了这个小差错之后，我又开始了一项更方便的工作：计算宾客们到婚礼场地的总路程。考虑到我们的亲朋好友将从遥远的地方赶来，我预计结果会令人吃惊。
While Gemini claimed not to be capable of directly calculating distances within a spreadsheet, it certainly didn’t leave me out in the cold. Instead, it suggested two ways I could manually tackle this task—either by implementing a custom script in Google Sheets or by using a formula for straight-line distances.
计算行车距离需要使用谷歌地图 API，这对大多数用户来说既陌生又害怕。比较简单的方法是哈弗辛公式，该公式使用经纬度计算飞行距离。虽然这种方法对公路旅行的准确性较低，但肯定比处理 API 更容易上手。
Nonetheless, the quest to calculate travel distances dampened my enthusiasm quickly, primarily because I wasn’t keen on finding the coordinates of each guest’s address. Still, it was reassuring to know that I certainly could unravel complex analytical tasks with some assistance from Gemini.
Google’s Gemini AI has undoubtedly added a layer of convenience to Google Sheets. While formulas might still be a hurdle for many, the journey to mastering them has become considerably less treacherous, thanks to this helpful chatbot.
