128 Google Sheets functions you need in your life

Plus: Award-winning plastic-eating robo-fish is here to rid our waters of waste. Oct 27, 2022 [Blueprint]( Together with Stand aside Excel, there’s a new spreadsheet master in town. (Ok, not that new)... In truth, Google Sheets launched over 16 years ago, but it’s safe to say it’s gone from strength to strength ever since. While not as capable as premium off-the-shelf spreadsheet packages like Microsoft Excel, you can't really snub Google Sheets, especially when you consider that it’s free. And, because so many of you agree and use it on a regular basis, we’ve come up with all the vital functions you might possibly need, to make your life that little bit easier. (You’re welcome.) But before you pore over that, pore over something a tiny bit more violent. Namely this video of YouTubers who have made a laser-sighted, fully automatic, knife-throwing machine gun (as you do.) Good morning. I’m Alice, an Editor at IE. This is The Blueprint. Let’s get started. Last Sunday, Blueprint subscribers had an exclusive insight from the man behind the new solar-powered wearable tech, on how he did it and what he wants to do with it. This Sunday we'll be talking to people in the know about whether killer robots are actually going to take over the world. Don't miss out — [subscribe to IE+]( today to receiv e exclusive interviews, features, and much more. [Play]VIDEO OF THE DAY [YouTubers make laser-sighted, fully automatic, knife-throwing machine gun.]( [YouTubers make laser-sighted, fully automatic, knife-throwing machine gun.]( It’s got everything you could possibly need… for something fairly sinister?! [Must Read]MUST READ [128 invaluable Google Sheets functions and formulas for engineers. [premium]]( [128 invaluable Google Sheets functions]( When you think Google you don’t necessarily think Sheets, but it’s safe to say it’s been [nothing short of a roaring success](. It may not have all the capabilities of Microsoft Word yet… but er, it’s free. And like any spreadsheet package, Google Sheets comes with some potent functions and formulae that can help your sort, clean, analyze, and otherwise organize your data in a matter of minutes. For engineers, this matters. Not least because, unlike your average spreadsheet user, engineers often need more advanced mathematical and statistical functions. So here, to make your life that little bit more streamlined (which I think is something we could all do with), we’ve made a handy list of what we consider to be some of the most useful ones. → While it is more limited in its capabilities than Excel, many of the functions and formulae you can use in Excel can also be used (to some extent) in Google Sheets, so it’s well worth a try. [READ MORE [Arrow]]( [Facebook]( [INNOVATION]INNOVATION [Award-winning plastic-eating robo-fish is finally here to rid our waters of waste.]( A [robot fish that filters microplastics]( has been created after winning a robotics contest in Surrey in the U.K. Researchers in robotics said they had made the “robo-fish” concept a reality. [READ MORE [Arrow]]( And Other Stories in Innovation - What happened to [WWII aircraft manufacturers]( - SpaceX announces a new ['flat high performance' Starlink dish]( for internet on moving vehicles. - NASA-funded space robots will grab objects in orbit [using arms controlled from Earth](. [SPONSORSHIP]SPONSORSHIP Instagram spying is legal. Only if you have the right tool for it. Knowing a person means knowing about his or her likes, dislikes, interests, and choices. After all, the right information helps you form the right communication. And, Instagram is one such massive source where you can get to know about the choices and interests of the people you like, simply by following their activities. Snoopreport is a tool that can help you get all the necessary information about a person's likes, dislikes, and tastes without getting into legal trouble. If you're a business, you can use this tool to know your audience better. Snoopreport uses web scraping, a practice legalized by the US courts, to gather data about public Instagram accounts and show them to you. [Click here]( to know more on how you can start tracking Instagram accounts at an affordable price. [SCIENCE]SCIENCE [New 3D-printed bricks withstand pressures 250 million times higher than the Earth's.]( NASA aims to establish a permanent presence on the moon with its Artemis program. It has asked scientists to devise [clever new methods]( for building lunar bases capable of withstanding harsh conditions. [READ MORE [Arrow]]( And Other Stories in Science - James Webb captures [two clashing galaxies]( birthing new stars. - Sea animals were [thought to be mute](. A scientist just discovered they can talk. - Scientists accomplish '[evolution on demand]( by creating shape-shifting turtle robot. [premium] [MAIL & MUSINGS]MAIL & MUSINGS 128 invaluable Google Sheets functions and formulas for engineers. Do you favor Google Sheets over Excel? [No, I’m an Excel fan]( [Yes, all day long]( [I actually use both]( [I don’t use either of them]( YESTERDAY'S RESULTS Yesterday, we asked you if you think Saudi Arabia’s plan to produce so many EVs will help EV sales outpace gas cars, and 36 percent of you said no, this is a drop in the ocean. 36% No, this is too small for that 28% Maybe, every little helps 18% Yes, as it could inspire others 17% It’s too early to say [QUOTE OF THE DAY]QUOTE OF THE DAY “Ignorance is like a delicate exotic fruit; touch it and the bloom is gone. The whole theory of modern education is radically unsound. Fortunately, in England, at any rate, education produces no effect whatsoever.” Oscar Wilde 1854–1900 Irish dramatist and poet: The Importance of Being Earnest (1895) act 1. [THINGS WE LOVE]THINGS WE LOVE [image]( [EKSA 1000E Gaming Headset]( [image]( [HTC VIVE VR Headset]( [image]( [Oakcha Portable TV]( [image]( [Onkyo TX-NR797 AV Receiver]( [AND ANOTHER THING]AND ANOTHER THING - Tesla to receive the [most essential tool]( for Cybertruck, Gigapress. - Particles from space provide a [new look inside cyclones](. (Science News) - This [thumb-sized microscope]( captures 'neural landscapes' from deep inside animal brains. - Why we are [making progress on climate action]( even after a tough year. (New Scientist) - Russian Air Force lost 23 of its [highly advanced attack helicopters]( in Ukraine. - [Mysteries about the universe abound]( from its beginning to its end. (SN Explores) - The future of energy has a [surprising 'big problem,']( Carl Pope reveals. [premium] Prepared by Alice Cooke Enjoy Reading? Forward this email to a friend. Was this email forwarded to you? [Join Free!]( [About Us]( [Advertise]( [Contact Us]( [Facebook]( [Twitter]( [Youtube]( [Linkedin]( [Instagram]( You are receiving this email because you have subscribed to our newsletter. Manage you e-mail preferences or unsubscribe [here](. © Copyright 2022 | The Blueprint is by Interesting Engineering, Inc. 205 Hudson St New York, NY, 10013, USA [Interesting Engineering]