Gemini now explains the reason for the failure of your papers

Nine months after Google Gemini Ai in Google Leaves, the artificial intelligence system comes out of the text and graphs to Formula. (Even those who fell into chaotic wedding planning schedules, found.)

Chatbot Gemini appears on the right side of the leaves. Now, when you ask about how to process data, Gemini will respond to proposed formulas and step-by-step instructions on how to make formulas work-why do the formulas fail when they do so. The errors will be followed up with a guide to how to correct the problem, says Google. If multiple formulas can do the same thing, Gemini will explain the user options.

Formulas, for me, often include a troublesome problem in knowing the function I need to make it work with my data. (Is it Countif or Countifs, or perhaps the Countunique wild card?

We got married in May, but this spreadsheet still gives me nightmares.

I expected the mathematics that I would need to examine my list of guests is somewhat clear, but this Gemini interpretation test in this chaotic spreads will be the test, for me, about whether it will help my daily life.

I chose first from the proposed formulas of Gemini that offered “creating a formula to calculate the number of guests who responded” yes “to the invitation. A formula using Countif appeared to the function in the column described by “RSVP”. (Usually, it could take it from Google or so to remember the function that should be used when specifying the number of elements in a list that meets certain requirements.) I can insert the formula directly in my spreadsheet by clicking the button that appeared next to the formula.

I remember my wedding day as a happy occasion full of the people I loved in the world – but the answer of Gemini told me that he did not say one person yes to my invitation. This is when I realized that I did not already follow RSVPS Which – which The column, despite the head head says a lot in the top row. I remembered that the admission was followed on the wedding site on the wedding site, I used my partner. I literally forgot this site until Gemini told me that I have no guests of zero who did yes to my wedding.

I tried again, this time in a more complex inquiry: to calculate the number of miles that my guests traveled, combined, to attend my wedding. (Given that my partner and I grew up on different coasts and that our friends and family are spread all over the world, I learned that the number would be high, but I wondered how High.) With all guest addresses on the spreadsheet, the wedding venue address is on hand, I thought it would be possible, but very annoying to do it by hand.

twin also I found my request annoying, responding, “I still learn and I cannot calculate the distances directly for you on the spreadsheet.”

But then I gave me a response to the front: “However, I can guide you about how to do this manually using a text program dedicated to Google Leaves or by providing a formula for straight distances.”

The first option requires an adventure in Wilde programming facades in the west, or application programming facades, a program that two computer program uses to speak with each other. “The driving distance account requires the use of the Google Maps applications interface, which is not supported by simple formulas of Google”, told me Gemini.

The other option will be to calculate the “straight distance (as vitals), which is less accurate for traveling on the road but simpler to implement” using a formula called Haifin formula. You just need latitudes and length, which Gemini seems to not do for me. I found one of the coordinates to try it.

I had to ask for a formula, and the first response was in a sports text, which would not do so for me. Then I asked Papers That is calculated by the form of Hafreen and obtained:

= 6371 * Acos (Cos (Radians (90 – A2)) * Cos (Radians (90 – E2)) + Sin (Radians (90 – A2)) * Sin (Radians (90 – E2)) * Cos (B2 – F2))))

Gemini responds a brief description of the “6371” number, which is the radius of the Earth in kilometers. For miles, I can use 3959. Gemini got a mistake because my length and width lines cells were in a different column.

Once I retreat in the cells of the width lines, length and transformation into miles (because, you know, America), the formula captures a distance confirmed by another site on the calculator site.

Ultimately, I didn’t want to find coordinates for each guest address, so my enthusiasm for this endeavor is dissipated quickly. But I felt confident that I Be able to With the help of Gemini.