Nine months after Google Infused Gemini AI to Google Arkus, the AI system completed the text and charts to taking formulas. (I even found those that fell into messy wedding planning sheets.)
Chatbot Gemini appears on the right side of the sheets. Now, when you ask how to manipulate data, Gemini will answer the suggested formulas and step-by-step instructions on how to make the formulas work-why the formulas fail when they do it. Google says that they will continue through a guide on how to solve the problem. If many formulas can do the same, Gemini will explain the user options.
For me, formulas often require an unbearable problem of determining which function I have to make it work with my data. (Is this a count or a wild Countunique card, so I tried the possibility of Gemini formula for my spreadsheet wedding guests, massive reinforcement of names, categories, e-mail addresses and electoral fields, which my partner and I tried to keep the handle on the growing list of people with whom we wanted to celebrate our great day.
We got married in May, but this spreadsheet still gives me nightmares.
I expected that the mathematics that I would have to examine, my guest list would be quite straightforward, but testing the explanation of the twin on this messy spreadsheet will be a test for me whether it will lend a hand my everyday life.
For the first time I chose from suggested Gemini formulas, which offered “creating a formula to count the number of guests who answered” yes “at the invitation.” He took out the formula using the number of functions in the column, which I marked “RSVP”. (Usually it would take me two Google search to remember which function to operate when raising the number of elements on the list that meets specific requirements.) I could insert the formula directly into my spreadsheet, clicking the button that appeared next to the formula.
I remember the wedding day as a cheerful opportunity full of people I loved the most in the world – but Gemini’s answer told me that not a single person said “yes”. Then I realized that I didn’t really follow RSVPS This The column, despite the column header, which says the same in the upper row. I remembered that the acceptance was tracked on the wedding page, my partner and I used. I literally forgot about this page until Gemini told me that I don’t have guests who are for the wedding.
I tried again, this time on a more sophisticated question: to calculate how many miles my guests traveled to take part in my wedding. (Considering that my partner and I grew up on various coasts, and our friends and family are spread all over the world, I knew that the number would be high, but I wondered How High.) From all my guests’ addresses in the spreadsheet and the address of the wedding place at hand, I thought it would be possible, but simply very annoying.
Twins Also I found my annoying request, answering: “I am still learning and I cannot directly calculate the distance in the spreadsheet.”
But then the answer gave me a way to me: “However, I can lead you how to do it by hand with a custom script in Google sheets or by providing a formula for straight distances.”
The first option required adventure in the Wild West programming interfaces of application or API interfaces, which is a software from which they operate two computer programs for conversation. “Calculation of driving distance requires the use of the Google Maps API interface, which is not natively supported by Google sheets with a simple formula,” Gemini informed me.
Another option would be to calculate the distance of the “straight line (like discs), which is less accurate in the case of road travel, but simpler to implement” using a formula called Haversine formula. I only needed latitudes and longitudinal width, which Gemini would not have done for me. I found one set of coordinates to try it out.
I had to ask for the Haversine formula, and the first answer was a mathematical script that was not supposed to do it for me. Then I asked for Sheet formula This calculates the Haversine formula and she got:
= 6371 * acos (COS (radans (90 – A2)) * COS (radans (90 – E2)) + sin (radans (90 – A2)) * sin (radans (90 – E2)) * COS (radans (B2 – F2))))
Gemini’s answer contained a brief description of the number “6371”, which is a ray of land in kilometers. For many kilometers I could operate 3959. Gemini got a mistake because my cells width and geographical length were in a different column.
After subordination in the cells for my latitudes and longitudinal widths and I switched to nice (because, you know, America), the formula spat out the distance confirmed by another calculator website.
Ultimately, I did not want to find coordinates for each guest address, so my enthusiasm for this task quickly dispersed. But I felt sure I was could With the lend a hand of Gemini.
0 Comments