• WWW.WIRED.COM
    WIRED Tested Miracle Hangover Cures. You're Welcome
    Do anti-hangover supplements really work? With the sterling help of a UK rugby team, we raised a glass or five to find out.
    0 Kommentare 0 Anteile 42 Ansichten
  • WWW.WIRED.COM
    7 Best Lighted Makeup Mirrors (2024), Tested and Reviewed
    Ensure a flawless finish every time with these WIRED-tested picks, no matter where you're putting on your face.
    0 Kommentare 0 Anteile 42 Ansichten
  • WWW.WIRED.COM
    How Do You Live a Happier Life? Notice What Was There All Along
    Reacquaint yourself with the good things in life by taking the time to appreciate themand yes, its OK to rush through the bad stuff.
    0 Kommentare 0 Anteile 43 Ansichten
  • Home Beauty Device Trends
    As the science of skin care continues to expand, some of those advances have landed directly in consumers hands. Is that a good thing?
    0 Kommentare 0 Anteile 56 Ansichten
  • WWW.MACWORLD.COM
    The entire Apple TV+ catalog is free to watch this weekend
    MacworldIn just a couple of weeks, Severance, Apples most popular show not named Ted Lasso will begin its long-awaited second season. And Apple is so excited to mark the occasion, it wants to make sure everyone is caught up on the first season.This weekend, January 4-5, Apple is making Apple TV+ free for everyone. That means you can watch as many shows and movies as you can handle in a 48-hour period, beginning at midnight on Saturday and continuing to 11:59pm on Sunday.You can access Apple TV+ through the Apple TV app on all Apple devices, Roku, Google TV Streamer, and most smart TVs, including Samsung and LG.Apple has already received several Golden Globe nominations, including Best Drama for Slow Horses and Best Limited Series for Disclaimer. Other critically acclaimed shows airing in 2024 are Shrinking starring Harrison Ford and Presumed Innocent led by Jake Gyllenhaal.Apple TV+ normally costs $9.99 a month with a seven-day free trial for new subscribers. Additionally, customers who purchase and activate a new iPhone, iPad, Apple TV, or Mac get three months of Apple TV+ for free.
    0 Kommentare 0 Anteile 43 Ansichten
  • WWW.MACWORLD.COM
    Cue the confetti: Apple has 20 billion reasons to celebrate Google
    MacworldYouve gotta love these court cases against major tech companies if only for the discovery and testimony that come out because of them.Turns out Eddy Cue still works at Apple. A few years of not seeing a guy dance onstage at a keynote can make you forget.Eddy Cue reveals the three reasons Apple wont build a search engineOf course, Apples not going to build a search engine! We wouldnt build one if you gave us $20 billion! Which, uh, is what Google gives us every year to not build a search engine.Cues comments come as the result of the U.S. Department of Justices suit against Google which accuses the company of holding a monopoly in online search, something it says Apple aids and abetts through the afore-joked deal. The court believes that, without the deal, Apple might develop its own search engine. Possibly called Ping. Can neither confirm nor deny.Cue has three reasons why it wouldnt, which the Macalope will summarize for you:Apple is a busy company! It has no time to develop a search business! Its too busy rolling around in piles of cash!Search seems like a lousy business to get into right now what with the AI and such.Advertising is only a hobby for Apple, not a core business! Also we hate advertising because it inevitably leads to privacy violations. Wed prefer to just do a little advertising and let others do the big-time privacy violatin.None of these seem super convincing. Naturally, Apple would just rather have the $20 billion. That seems obvious. So, yeah, the company doesnt want to make a search engine. Would you rather go find a job digging ditches or win the lottery? Seems like if you won the lottery you could get the satisfaction of digging a few ditches on your own time.The AI argument isnt a terrible one, but the company certainly could build a search engine if it wanted to, if only by acquiring an existing one to build on which surprise! it was looking into just a few years ago. Its worth pointing out that Apple didnt have mapping capabilities, either, and it managed to create one, albeit not without some pains along the way. Is Maps a core business? Hardly. For that matter, is TV? Or weather? Apple bought Dark Sky. Internet search certainly seems just as core to iOS as weather does, even if the former comes with the ickiness of advertising.IDGMeanwhile, in the DOJs suit against Apple, the government contends that Apples deal with Google puts the lie to the companys assertions that it cares about its customers privacy. How could Apple care about privacy, the argument goes, if it uses Google which does not care at all about privacy as the default search engine?Quod! Erat! Demonstrandum!Its not an argument devoid of any logic but, while Apple certainly isnt a victim here No. Please. Stop throwing money at us. Oh, my, this is truly a horrible turn of events. Google is literally the name that is synonymous with online search. Apple could use Bing or DuckDuckGo as the default, but most consumers, for better or worse, expect Google and would likely say What the heck is this nonsense? if Apple set the default to anything but.But to Cues point, if Apple made its own search engine, it would be doing the privacy-violating instead of Google. If search must include advertising, then it is probably better to not do it yourself. Like, if U.S. foreign policy has to involve murder, the Macalopes not moving out of the country, but hes also not running out to join a CIA hit squad.He doesnt know what youve heard.The horny one supposes its probably naive to suggest a search engine not be run with ads and maybe just delivers the best results possible without 3-10 things at the top someone paid to put there.Yeah, thats probably naive, when theres all that money to be made.The obvious answer is to simply not have a default at all; just pop up a dialog box asking people to pick their favorite search engine on setup. But Google doesnt like that answer because iOS is such a big part of its search business and Apple doesnt like that answer because it wouldnt get that sweet $20 billion. Plus, most people would probably just pick Google out of habit anyway, even though its increasingly just not a good user experience.It seems Cue doth protest too much. All the way to the bank.
    0 Kommentare 0 Anteile 43 Ansichten
  • WWW.MACWORLD.COM
    Shokz Openfit Air review: Lightweight sporty open-air earphones
    MacworldAt a glanceExpert's RatingProsVery comfortable to wearLightweightOpen, stress-free soundConsMicrophones distortOur Verdict The Openfit Air lives up to its name and convinces as good sports headphones. The sound is stress-free and suits the application, as does the wearing comfort. If you want a party in your head, youre in the wrong place, but if you dont want to spend a lot of money, you should give them a listen.Price When ReviewedThis value will show the geolocated pricing text for product undefinedBest Pricing TodayPrice When Reviewed129,90 EuroBest Prices Today: Shokz OpenFit AirRetailerPrice109,00 View Deal109,00 View Deal119,99 View Deal139,00 View Deal144,41 View DealPrice comparison from over 24,000 stores worldwideView more pricesProductPricePrice comparison from BackmarketOpen-ear earphones dont have a seal between your ears and the device, allowing outside sounds to be heard. That might be preferable in some instances, like if youre running or riding a bike alongside traffic or on a trail where you want to be aware of whats around you. Also, the fit of an open-ear earphone might be more comfortable.The Shokz Openfit Air has an open-ear design. It uses a well-shaped ear hook made of a nickel-titanium alloy to ensure an ideal fit on the ear. It is covered with soft silicone so that it is also comfortable to wear during sporting activity. They look big, but they weigh just 8.7 grams and are correspondingly light to wear. As with all headphones with ear hooks, people who wear glasses can also have problems with the Openfit Air, though I didnt have any problems. Otherwise, the wearing comfort is good, which is also due to the soft earhook. Certified to IP54, it is resistant to water and sweat.Shokz offers a lineup of bone-conduction earphones, but the Openfit Air isnt one of them. It uses a conventional mini loudspeaker with Shokzs own Directpitch and Openbass technology that should ensure a full sound. While using the Openfit Air to listen to my favorite music while running, the earphones produced no abysmal bass and a pleasant sound without stress. The sound is right, with a tuning that is more on the airy side. Its also nice that the vocals arent too harsh and the bass has enough depth for a well-rounded sound.Four integrated microphones can track your voice precisely thanks to their adaptive beamformer. However, I found phone calls and voice recordings muffled and distorted.The Openfit Air connects via Bluetooth 5.2 with multipoint pairing, which means that it can be paired with two devices at the same time. The built-in battery lasts for around six hours, which Shokz claims can be extended to a maximum of 28 hours with the charging boxthats what we experienced in our testing. A ten-minute quick charge is enough for a maximum of two hours of music enjoyment.A charging box with USB-C connection is included. The charging box is a real hand flatterer, both in terms of the curves and the soft-touch surface. The charging box cannot be recharged inductively. Shokz offers the Openfit Air in black, white, and pink.The Shokz app can be used to set the buttons or update the firmware. You can select one of the four presets in the equalizer in the app, activate multipoint pairing, or check the battery status of the earphones and charging box. The app is clear, but it cannot adopt the system language of the iPhone when it is first started and the user has to do this manually.Should you buy the Shokz Openfit Air?The Openfit Air lives up to its name and convinces as good sports headphones. The sound is stress-free and suits the application, as does the wearing comfort. If you want a party in your head, youre in the wrong place, but if you dont want to spend a lot of money, you should give them a listen.
    0 Kommentare 0 Anteile 43 Ansichten
  • WWW.COMPUTERWORLD.COM
    The best new Windows 11 features of 2024
    Microsoft is a little sneaky. Sure, theres just one big update for Windows 11 each year. But Microsofts Windows team is always working on something, and new Windows 11 features are arriving on PCs every month even outside of those high-profile updates.So as we arrive at the end of 2024, lets review the most interesting and useful new features that have shown up on Windows 11 in the past year. I bet youll find at least a few features you havent yet discovered!And be sure to sign up for my free Windows Intelligence newsletter for even more useful knowledge. Ill keep you up to date on all the interesting new features you can find and explore as we get into the new year.New Windows 11 features #13: Phone integration powersUse an Android phone as a webcam, wirelesslyWindows now lets you use your Android phone as a webcam. It all happens entirely wirelessly, if you like no cables! The setup process is quick, and its particularly useful if youre not a big fan of your PCs on-board webcam quality.Get PC notifications when you take new photos or screenshots on AndroidWindows can now pop up a notification whenever you take a new photo or screenshot on your Android phone. Then you can click that notification to immediately transfer the photo and open it for viewing, editing, or sharing on your PC.Transfer files to and from Android phones, wirelesslyOnce youve connected your Android phone to your PC for the above wireless features, youll also see your phone pop up in File Explorer. You can transfer files to and from your Android phone right from File Explorer wirelessly!New Windows 11 features #45: Windows taming tricksWhy Widgets on Windows 11 are finally worth usingWindows 11s built-in Widgets menu got some big updates in 2024. Its worth giving it a second chance now that you can tweak various options to hide the viral article feed and customize it further.Remove stocks and sports from your PCs lock screenWindows now shows stock prices and sports updates alongside the weather on your lock screen its a recent update, too! (That said, many people wont be fans of this.)New Windows 11 features #68: New Microsoft appsTry the new Sticky Notes appOut with the old and in with the new! Windows has a new Sticky Notes app thats more closely integrated with OneNote.The ultimate Windows app launcherMicrosofts PowerToys package isnt included with Windows, but its an honorary part of the operating system as far as Im concerned. In 2024, Microsoft released an especially powerful application-launcher-and-arranger named PowerToys Workspaces. Its a big productivity upgrade for many people.Activate and use the PowerToys New+ menuSpeaking of PowerToys, Microsoft also launched an even more powerful and flexible New+ menu that lets you quickly create new files and folders from templates right in File Explorer. Im already putting this one to good use myself.New Windows 11 features #912: AI grab bagErase objects from photos with AI on your PCMicrosofts Photos app includes a new Generative Erase feature that works on all Windows 11 PCs and on Windows 10 PCs, too! You can select objects in photos and use this AI-powered erase to get rid of them.Microsoft wants Copilot to be your new AI best friendWindows got a brand-spanking-new Copilot app this year. Beyond productivity, Copilot now wants to be your best buddy!5 Copilot+ PC AI features you can use at launchSome of the newest PCs are branded Copilot+ PCs, and they have access to new AI-based Windows features. Again, these dont work on most Windows 11 PCs these need a new Copilot+ PC. Here are the AI features you can use on those PCs.Hands on with Microsofts Windows RecallRecall is the most controversial Windows feature of the year. Its still available only in testing form right now but Im experimenting with it, and you can see how it works.Bonus: More Windows AI features10 Windows 11 AI features you can use todayOkay technically this one is from December 2023, but whos counting? All Windows 11 PCs include AI features, even if they arent Copilot+ PCs. This guide reveals what you can use today on any Windows 11 PC.Stay tuned: 2025 promises to be even more of a busy year when it comes to Windows development. Well explore it all together, every step of the way.Dont wait for next years December review! Sign up for my free Windows Intelligence newsletter now, and Ill send you three new things to know and try every single Friday.
    0 Kommentare 0 Anteile 45 Ansichten
  • WWW.COMPUTERWORLD.COM
    Whats next for generative AI in 2025?
    In 2024, the surge in generative AI (genAI) pilot projects sparked concerns over high experimentation costs and uncertain benefits. That prompted companies to then shift their focus to delivering business outcomes, enhancing data quality, and developing talent.In 2025, enterprises are expected to prioritize strategy, add business-IT partnerships to assist with genAI projects and move from large language model (LLM) pilots to production instances. And small language models will also likely come into their own, addressing specific tasks without overburdening data center processing and power.Organizations will also adopt new technologies and architectures to better govern data and AI, with a return to predictive AI, according to Forrester Research.Predictive AI uses historical data and techniques such as machine learning and statistics to forecast future events or behaviors, said Forrester analyst Jayesh Chaurasia. GenAI, on the other hand, creates new content such as images, text, videos, or synthetic data leveraging deep learning methods such as generative adversarial networks (GANs). Chaurasia predicts the AI pendulum will swing back to predictive AI for over 50% of use cases.LLMs are, of course, central to genAI, helping enterprises tackle complex tasks and improve operations. Forrester reported that 55% of US genAI decision-makers with a strategy use LLMs embedded in applications, while 33% purchase domain-specific genAI apps. Meanwhile, SLMs are quickly gaining attention.The rise of small and mid-sized language models should enable customers to better meet the trade-offs on accuracy, speed and costs, said Arun Chandrasekaran, a distinguished vice president analyst with Gartner Research, noting that Most organizations are still struggling to realize business value from their genAI investment.GartnerIn the coming year, SLM integration could surge by as much as 60%, according to a Forrester report.As nearly eight-in-10 IT decision makers report software costs rising over the past year, theyre looking to SLMs because theyre more cost-effective and offer better accuracy, relevance, and trustworthiness by training on specific domains. Theyre also easier to integrate and excel in specialized industries such as finance, healthcare, and legal services.By 2025, 750 million apps are expected to use LLMs, underscoring the genAI markets rapid growth. Forrester predicts the market will grow in value from $1.59 billion in 2023 to $259.8 billion by 2030,.Even with that growth, many AI experts argue that LLMs may be excessive for automating workflows and repetitive tasks, both in terms of performance and environmental impact. A Cornell University study found that training OpenAIs GPT-3 LLM consumed 500 metric tons of carbon, the equivalent of 1.1 million pounds.As enterprises face challenges meeting expectations, gen AI investments in 2025 will likely shift toward proven predictive AI applications like maintenance, personalization, supply chain optimization, and demand forecasting. Forward-thinking organizations will also recognize the synergy between predictive and generative AI, using predictions to enhance generative outputs. That approach is expected to boost the share of combined use cases from 28% today to 35%, according to Forrester.What are small language models?In the simplest of terms, an SLM is a lightweight genAI model. The small in this context refers to the size of the models neural network, the number of parameters, and the volume of data on which it is trained, according toRosemary Thomas, a senior technical researcher in the AI lab at Version 1, a management consulting and software development firm.SLMs use fewer computational resources, enabling on-premises or private cloud deployment, which natively enhances privacy and security.While some SLM implementations can require substantial compute and memory resources, several models can have more than 5 billion parameters and run on a single GPU, Thomas said.Gartner Research defines SLMs differently, as language models with 10 billion parameters or less. Compared to LLMs, they are two to three orders of magnitude (around 100-1,000x) smaller, making them significantly more cost-efficient to use or customize.SLMs includeGoogle Gemini Nano, MicrosoftsOrca-27bandOrca-213b, MetasLlama-213b,andothers, Thomas noted in arecent post, arguing that SLM growth is being driven by the need for more efficient models and the speed at which they can be trained and set up.GartnerSLMs have gained popularity due to practical considerations such as computational resources, training time, and specific application requirements, Thomas said. Over the past couple of years, SLMs have become increasingly relevant, especially in scenarios where sustainability and efficiency are crucial.SLMs enable most organizations to achieve task specialization, improving the accuracy, robustness, and reliability of genAI solutions, according to Gartner. And because deployment costs, data privacy, and risk mitigation are key challenges when using genAI, SLMs offer a cost-effective and energy-efficient alternative to LLMs for most organizations, Gartner said.Three out of four (75%) of IT-decision makers believe SLMs outperform LLMs in speed, cost, accuracy and ROI, according to a Harris Poll of more than 500 users commissioned by the start-up Hyperscience.Data is the lifeblood of any AI initiative, and the success of these projects hinges on the quality of the data that feeds the models, said Andrew Joiner, CEO of Hyperscience, which develops AI-based office work automation tools. Alarmingly, three out of five decision makers report their lack of understanding of their own data inhibits their ability to utilize genAI to its maximum potential. The true potentiallies in adopting tailored SLMs, which can transform document processing and enhance operational efficiency.Gartner recommends that organizations customize SLMs to specific needs for better accuracy, robustness, and efficiency. Task specialization improves alignment, while embedding static organizational knowledge reduces costs. Dynamic information can still be provided as needed, making this hybrid approach both effective and efficient, the research firm said.In highly regulated industries, such as financial services, healthcare and pharmaceuticals, the future of LLMs is definitely small, according to Emmanuel Walckenaer, CEO of Yseop, a vendor that offers pre-trained genAI models for the BioPharma industry.Smaller, more specialized models will reduce wasted time and energy spent on building large models that arent needed for current tasks, according to Yseop.Agentic AI holds promise, but its not yet matureIn the year ahead, there is likely to be a rise in domain-specific AI agents, although it is unclear how many of these agents can live up to the lofty expectations, according to Gartners Chandrasekaran.While Agentic AI architectures are a top emerging technology, theyre still two years away from reaching the lofty automation expected of them, according to Forrester.While companies are eager to push genAI into complex tasks through AI agents, the technology remains challenging to develop because it mostly relies on synergies between multiple models, customization through retrieval augmented generation (RAG), and specialized expertise. Aligning these components for specific outcomes is an unresolved hurdle, leaving developers frustrated, Forrester said in its report.A recent Capital One survey of 4,000 business leaders and technical practitioners across industries found that while 87% believe their data ecosystem is ready for AI at scale, 70% of technologists spend hours daily fixing data issues.Still, Capital Ones survey revealed strong optimism among business leaders about their companies AI readiness. Notably, 87% believe they have a modern data ecosystem for scaling AI solutions, 84% report having centralized tools and processes for data management, 82% are confident in their data strategy for AI adoption, and 78% feel prepared to manage the increasing volume and complexity of AI-driven data.And yet, 75% of enterprises attempting to build AI agents in-house next year are expected to fail, opting instead for consulting services or pre-integrated agents from existing software vendors. To address the mismatch between AI data preparedness and real-world complexities in 2025, 30% of enterprise CIOs will integrate Chief Data Officers (CDOs) into their IT teams as they lead AI initiatives, according to Forrester Research. CEOs will rely on CIOs to bridge the gap between technical and business expertise, recognizing that successful AI requires both solid data foundations and effective stakeholder collaboration.Forresters 2024 survey also showed that 39% of senior data leaders report to CIOs, with a similar 37% reporting to CEOs and that trend is growing. To drive AI success, CIOs and CEOs must elevate CDOs beyond being mere liaisons, positioning them as key leaders in AI strategy, change management, and delivering ROI.A growing interest in multi-modality and upskillingEmerging use cases for multi-modality, particularly image and speech as modalities in both genAI inputs and outputs, will also see more adoption in 2025.Multimodal learning, a subfield of AI, enhances machine learning by training models on diverse data types, including text, images, videos, and audio. The approach enables models to identify patterns and correlations between text and associated sensory data.By integrating multiple data types, multimodal AI expands the capabilities of intelligent systems. These models can process various input types and generate diverse outputs. For example, GPT-4, the foundation of ChatGPT, accepts both text and image inputs to produce text outputs, while OpenAIs Sora model generates videos from text.Other examples include medical imaging, patient history, and lab results that can be integrated to enhance pateitn diagnosis and treatment. In financial services, multimodal AI can analyze customer phone queries to assist contact center employees in resolving issues. And in the automotive industry inputs from cameras, GPS, and LiDAR can be integrated by AI to enhance autonomous driving, emergency response, and navigation for companies, such as Tesla, Waymo and Li Auto.AI leaders have also realized they need to prioritize business outcomes, clean their data houses, and start building AI talent. The latter is especially important given the growing gap between enterprise genAI needs and the workers with skills to meet those needs.In the year ahead, youll need to put your nose to the grindstone to develop an effective AI strategy and implementation plan, Forrester said in its report. In 2025, organizational success will depend on strong leadership, strategic refinement, and recalibration of enterprise data and AI initiatives commensurate with AI aspirations.
    0 Kommentare 0 Anteile 45 Ansichten
  • WWW.COMPUTERWORLD.COM
    How to use Gemini AI to make templates in Google Sheets
    Need ideas or motivation to help you build a spreadsheet in Google Sheets? You can browse through the templates that are included in this office app and select one to customize. But a more intriguing option is to use the tool in Sheets called Help Me Organize. Powered by Googles generative AI technology, Gemini, you can use it to generate a template thats more tailored for you.Based on a brief description that you write (referred to as a prompt), Help Me Organize generates a table with headings, placeholder text, and possible formulas in its cells that you can then adjust to your needs. Its mainly designed to create templates for project management. But you can tease it to make templates that include some formulas and tables that can be used to create charts.This guide explains how to use Help Me Organize and provides tips for getting best results.Who can use Gemini AI in Google SheetsIf you have a Google Workspace account, the Gemini AI tools that include Help Me Organize are available as an add-on called Gemini for Google Workspace for an extra subscription charge. If you have a regular Google personal account, you can pay for a Google One AI Premium subscription to have access to these tools. Or, for no cost, you can sign up for access to Workspace Labs with your Google account to be permitted to try out Help Me Organize.How to access Help Me Organize in Google SheetsYou access the Help Me Organize tool from a right side panel that you open while in a spreadsheet in Google Sheets. The spreadsheet can have existing data on it. But for generating templates, its best to use Help Me Organize on a new, blank spreadsheet or on a new sheet in an existing spreadsheet. You can add a new sheet to a spreadsheet by clicking the + sign thats toward the lower-left corner of the opened spreadsheet.To launch the Help me organize panel, click Insert and select Help me organize at the very bottom of the menu that opens.In the Help me organize panel that opens to the right of the page, a large text entry box invites you to write a prompt inside it. Some example prompts that are meant to show you how you can write your own cycle through this box.When you open the Help me organize panel, its entry box shows example prompts.Howard Wen / IDGHow to use Help Me OrganizeClick inside the entry box on the Help me organize panel, type a description of the kind of template you want Gemini to generate, and click Create.Type a prompt into the box on the Help me organize panel and click Create.Howard Wen / IDGDepending on the complexity of your prompt, it may take several seconds for the AI to generate a template but it may not be able to generate anything. If its unable to, try entering your description again but use fewer words.Gemini may think for a while as it generates a template.Howard Wen / IDGHow to insert a template generated by GeminiIf Gemini produces a result, the template will appear over your spreadsheet. Itll start from the upper-leftmost cell, with the templates columns and rows spreading out from here.Review the template Gemini generated, then insert it in your spreadsheet or start over.Howard Wen / IDGYou can scroll through the template to see what you think of it. Keep in mind that you should always consider what Gemini generates as a rough draft that youll need to modify to make it more suitable for your use (such as replacing placeholder text and scrutinizing and modifying any formulas). It is a template, after all.Scroll to the bottom of the template youll find a small toolbar attached to it. If you like this template, click Insert. Itll then be inserted into your spreadsheet.If you dont, click the X. The template will be removed from your spreadsheet. You can try writing another prompt in the Help me organize panel. Note that if you create a new template, you cant go back to the previous version.Optionally, you can rate if you like this template or not by clicking the thumbs up or thumbs down icon. Your feedback is used to help train Gemini to produce results in the future that may be more preferable.Once youve inserted a template in your spreadsheet, you can tweak it however you like: change heading names, add rows or columns, adjust formulas, enter real data, and so on. See How to use Google Sheets for project management for details on working with templates in Sheets.How to write a prompt in Help Me OrganizeUnsure about how to write a prompt? Need inspiration? Here are some general tips that can elicit useful templates from Gemini:1. First, describe a specific project that you want to track.Examples:budget breakdownbusiness travel itinerarypayroll schedule2. Describe or specifically name headings that youd like to see in the template.budget breakdown that includes in the following order: revenue, rent, utilities, internet, expensesbusiness travel itinerary with sections for travel to airport, airline, flight number, hotel, and so onpayroll schedule for employees named Mike, Pedro, Shawna, and TashaIncluding specifics in a prompt will help Gemini generate a better template.Howard Wen / IDG3. Use numbers and math formulas.a table depicting 12 months with 3 categories per monthpayroll schedule thats monthly across one yeara table that calculates compound interest at 3.5% over 3 yearsGemini can create a template that includes formulas.Howard Wen / IDG4. Describe dropdowns, lists, task lists, or to-dos.a dropdown with selections that include Greek, Japanese, Italian for a business luncheona project tracker with task lists assigned to peoplea to-do list for onboarding a new employeeA generated to-do list with status dropdowns.Howard Wen / IDGFor more on working with dropdowns, see Google Sheets power tips: How to use dropdown lists.5. Describe a chart.Gemini cant generate charts directly, but you can prompt it to create a template (table) that you can then derive a chart from. Examples:a bar chart with 9 labelsa line chart with 4 categoriesa pie chart depicting 3 categoriesDescribe a chart youd like to create.Howard Wen / IDGInsert the generated template in your spreadsheet.Next, select the template by clicking its top-leftmost cell.Then, on the menu bar over your spreadsheet, click Insert > Chart. By default, a pie chart will be generated. The Chart editor panel will also open along the right of the page, so you can change the pie chart to another type or make other adjustments to it.A pie chart based on a template that Gemini generated from a prompt.Howard Wen / IDGIts worth noting that in this pie chart example, Gemini went beyond what was asked for, breaking each of the three categories into three sections with different colors. Thus, the resulting pie chart has nine sections instead of three. Thats unlikely to be what most people would be looking for from the original prompt a good illustration of why you always need to check and adjust Geminis output, or simply discard it and start over.6. Dont be afraid to describe something complicated.a budget for at least 12 departments in my office for one year and assign supervision to employeesa project manager for 8 salespersons who have to sell seashells to the 10 biggest cities in the US Midwest with an April deadlinea weekly restaurant employee work schedule for 10 back-of-house kitchen employees and 6 front-of-house employees over 4 weeksGemini can often handle complicated prompts.Howard Wen / IDGRemember that the best way to use Help Me Organize (or any generative AI tool) is to experiment and play around with the wording of your prompts. You never know Gemini may surprise you with a result thats better or more useful than what you originally envisioned.In summaryKeep these tips in mind to write prompts that will trigger Gemini to give you the best (or at least most interesting) results in Help Me Organize:Define exactly what you want to use the template for. How would you describe it in three words?Use headings or numbers (such as dates or math formulas). These can imply columns and rows in the template.If you want the template to have a dropdown or other list type, describe it.Use Gemini to generate a table that you can then derive a chart from.Dont be afraid to experiment even if your request sounds complicated.As with all AI-generated content, the templates created with Help Me Organize should never be seen as final but they can give you a big head start for all sorts of spreadsheet-related tasks, from setting up complex schedules to creating charts to performing time-oriented calculations.This article was originally published in February 2024 and updated in December 2024.
    0 Kommentare 0 Anteile 71 Ansichten