create and update an Excel with your personalized movements, totals and balances

Let’s explain to you how to create an Excel with your monthly movements wearing artificial intelligenceand from your bank statements. We will go far beyond the spreadsheets that your bank can generate with your expenses. The AI ​​will list what you spend and what you earn, and at the end of each month it will show you your total balance. But we are also going to ask that at the end of each month there be custom totals for specific expensessuch as Amazon purchases, Bizum movements, etc. This is something quite complex to do, and after testing we are going to give you the guide using Claudebecause it is by far the one that has given us the best results. The prompt that we are going to tell you you can also use it in ChatGPTwhere it will give you very good results. The only difference is that in ChatGPT You won’t have a button to save it to Drive, but at least you can download it. As to GeminiGoogle’s AI gives the worst results with this prompt, I would try to avoid it. In Claude we are going to seamlessly generate different pages for each month, it will use color coding, and we will tell you that add a button to save it to Google Drivesomething quite useful, although you can also ask it to simply allow you to download the file. Get your bank statements first The first thing you have to do is download a document with all your banking transactions from your bank application. In some cases you will already be able to download it in Excel, but our idea is to make one with AI in which specific totals are also calculated at the end of each month. Many banks will allow you to choose the time periods you want to take into account when downloading expenses. Here, you should keep in mind that AIs usually have a limit in the context of your requests. This means that it is better to cover shorter periods of time. For example, you will be able to download statements for each month or every two months, because then you can ask the artificial intelligence to update your spreadsheet with the new data from each extract. If you use Claude, link your Drive account One of the positive aspects of Claude is that you can add and activate the connector Google Drive. The connectors are used to connect Claude to other services, in this case Google Drive. You’ll have to give the AI ​​access to your entire Drive, so be careful if you’re looking for maximum privacy. In our case, this will help us be able to create a save button in Drive our document. Thus, not only will you be able to view the spreadsheet directly in Claude, but you will also be able to download it or save it to your cloud. Create your spreadsheet Now let’s get to work. Open Claude and attach the document with your banking transactions that you have downloaded from your bank application. When you do it, you have to include the prompt explaining what you want. We have used this: “This is a statement from my bank. From your data, I want you to generate a spreadsheet showing the total expenses for each month. Each month must be separated, and you must list all expenses and income with negative and positive signs. At the end of each month you must show me a box where I see the total to know if I have had a positive or negative balance. At the end of each month I also want you to make two extra boxes where you show me the total expenses on Amazon purchases, and the balance of Bizum movements. Each month should then be separated on a different page within the spreadsheet. Additionally, I want you to use a color code, to put the rows that represent an expense in red and an income in green. The spreadsheet should be a .xlsx file, and I also want you to generate a button so I can save this document directly to Google Drive. Also, from now on, every time I share a bank statement with you in this conversation, you will update that document to add the data.” As you can see, we have asked for it to be a multi-page spreadsheet, one for each month, and to use color coding. We have also requested boxes for extra balancessuch as the total spent on Amazon or the balance of movements in Bizum. You can also ask for other types of balances, but it is better that stick to requests that the AI ​​can identify. This means that perhaps if you ask it how much you spend on subscriptions, it may not be able to identify all of them correctly or it may charge you more than necessary. It’s best to include specific expenses with a name that appears on your statements. If you want to include subscriptionsto give you an idea, in another conversation you can ask him to identify your subscriptions from your bank statements. And after doing so, you can include in your prompt that puts the monthly expenses of those specific subscriptions in a cell. Claude will take a few minutes to do everything and will show you each step he takes. In the end, you will have a document with the Excel XLSX format that we have requested. If you click on it you will open it directly in Claudealthough you will also have a button to open it in the application compatible with the format you have by default. When you click on the file that has been generated, in Claude it will open in the same chat. If you use ChatGPT you will have to download it. When you open it, you can check that everything is the way you like it, and check the totals and expense list. That’s it, you will … Read more

How to create Gemini Gems to have your personalized view of artificial intelligence

Let’s explain How to create your own Gemini Gemand thus have a personalized version of Google’s artificial intelligence. The Gemini Gems They are like a kind of light and very simplified version of the Artificial Intelligence Agentsnot so complete, but easier to create. The idea of ​​this article is to have a mini guide to understand these personalized versions of Geminiand help you create the first to be able to adapt it to your needs. You will see that they are easier to do than you think, and the options are simple. What are the gems exactly The gems are Personalized versions of Geminithat allow you to use a personalized version of this artificial intelligence assistant. So you can adapt it to perform concrete tasks, play specific roles, or get answers of certain topics that interest you. It is something similar to Chatgpt GPTSbut for Gemini. Gems will allow you to create a version specialized in something concrete of Gemini. Thus, instead of the generic version of the AI ​​you can have one that is centered on the programming, on making a personal tutor or even reviewing your writing. For this, you will simply have to Write instructions telling you what your role and purpose isand from then on all the interactions will start from those rules that you have established. You can even add concrete articles or files to take into account your content in your answers. Although initially the gems were a payment function, currently You can create and use them with a free account from Google with Gemini. However, even being a function that is no longer paying is subject to the general limits of the free account, which means that you can only use the most basic AI model, with a very scarce limit in the use of the advanced model. Another of the limits to be used is in the context window, which is 32,000 tokens or around 50 pages of text, while The file limit for the knowledge base It is only 10. How to create your own gems To create your own Gemini Gems, you have to open the lateral menu of the web or the mobile application. Once inside, click on the option Discover Gems That will appear. This will take you to a screen where you can see a list of gems created by Google itself, and below the section where you have created. Here, click on the + buttonNew gene that will appear to start the process of creating a new one from scratch. This will take you to the screen where you will have to fill in the three necessary fields to create your Gem. You will have to give it a name, instructions and a knowledge base In the event that the latter is necessary. Three fields to define your new gem The first thing you have to do is name your gem. This is the distinctive name it will have, and with which it will appear on your list of gems created. It is recommended that it be a clear and distinctive name. Come on, it is better to call him “expert in SEO writing” than simply “Julián”. Then comes the most complex part, because you will have to Write detailed instructions of the Gem. This is the most important step, because it serves to define the role, tone and rules that this automatism must follow. You have to specify everything you can When you are writing these instructions. These are any of the most important aspects to be defined in the instructions When you are going to create your Gem: Personality: You will have to say what your role is, the character you must interpret and the tone you must use. For example, you can ask you to act as a rigorous but friendly university professor, or an editor of casual content and focused on Reels. Whatever you want, but this personality is important to define it to establish behavior. Objective and rules: It is also also important to specify what the main task of the GEM is, and what are the rules to be used. For example, you can say “Your work is to review the texts to find spelling, grammatical failures and improve the structure”, for example. You can also say things like “Never talk about issues that are not about …” to make it focus on that concrete task. Format: This is something optional, but you will also be able to define the structure of the answers. For example, you can ask that you always start with a summary and then make a list at several points, or whatever you think is necessary. In the end, the question is to define a response structure that is useful and according to the tasks you want to do this customization of Gemini. If you don’t clarify writing the instructionsyou have at your disposal the option to use Gemini to help you write them. For that, write two or three phrases describing the instructions, and then click on the pencil button Use Gemini to rewrite the instructions. By doing so, AI will develop instructions from your phrases, and then you will only have to modify them as you consider necessary. And last place, you have The field of Knowledge Where can you add files. This is something optional, you can simply give your Gem an additional information or context base to reference in chats. These files can upload them from Google Drive or your device. Here, when you upload files keep in mind that They will have priority over general knowledge When you ask the Gem. Come on, that version of Gemini will first look for the answer in those files you have sent, and if you ask you questions that can be answered with them. But if the GEM does not find the answer in its content, then it will resort to Gemini’s general knowledge. Try the Gem before saving it Once you have … Read more

How to generate one in voice artificial intelligence from a text: Create your personalized announcer

Let’s tell you How to generate a voice with AIto be able to tell things from a text you write to him. This will allow you to have a personalized announcer or broadcaster to create your own podcasts or audiobooks, and to read you anything you want. First, we are going to give you a series of previous tips for you to know what you should have in mind to use these tools for artificial intelligence. Then we will tell you four free tools you can use To move from text to voice and use voices by AI to create audios. Before starting, some tips Before put to create locutions with a voice made by artificial intelligence you must think about What do you want to get with her. Think about whether you want it to be a natural voice or a robotic narrative, and also in the language, the tone or accent you want to use. It is very important have written a well structured text so that then the voice of the say it. Use the punctuation marks well so that the intonation sounds natural, and if it can be, divide the text into short phrases to also improve naturalness. Tests before getting seriouslyUse some short phrases to test your voice and see if you are using a tool or configuration that convenient you. And before that, Listen to several voice examples If the tool has several available to better choose the one you want to use. Finally, be aware of the limitations of the platform you use. Most are paying, and In their free ways they have limits by number of characters or minutes of audio generated. Therefore, if you see it necessary, you may have to divide a long text into different fragments instead of trying to make it whole. Generates phrases with notebooklm The first tool you can use is Notebooklmwhich is free and from Google. In this case, You can only make audio summaries Of one or more issues that you upload on the web, you will not be able to write what you want me to say the voice. But it is totally free. To use it you have to enter Notebooklm.google.comand on the main page click on the option of Create notebook. It is also available In Google Play For Android and In the App Store For the iPhone. Notebooklm is divided into notebooks, which are work spaces. The first thing you will have to do, therefore, is to create a new one. Once inside, You will have three columns or sections. On the left you have the fountains. Here, You can add one or more sources. Everything you upload will be what analyzes Google’s artificial intelligence when you ask you questions or ask for content. They can be text documents, slides, PDF, YouTube videos or links to web pages or online items. Then you have the section of Chatwhich is where you will be able to ask Google’s AI all the questions you want and get answers based on the sources. And then you have the section of Studio. In it, you will be able to create an audio with a summary of the sources provided in this project. If you click on the Customize Audio Summary buttonthen you will be able to determine how the summary that your voice will make, giving indications on the subject to speak or the source to focus, and you can also have the way this voice speaks. Elevenlabs Elevenlabs is a platform with several artificial intelligence resources, including one for AUDIO TEXT. You can find it on the web Elevenlabs.io/es/text-to-speechand although you can try it without registering you will need to create an account to download the audio you generate. It is very easy to use. First you write or fight the text you want to narrate, and then you will have to Choose the voice and language What do you want to use, being able to determine the model to be used and the speed at which it is discussed. There are voices in Spanish from Spain, and also Latinas. Then you press in Play And ready, reproduce. Here, the bad news is that The free account has limit In the number of characters to process every month. Specifically, you can create 10 minutes monthly of high quality text -based audio. TTSMaker This is another tool to move from text to voice with artificial intelligence, which is characteristic by Do not need to create account To use it for free. You just have to write the text, choose the language and ready, generate what you have written in voice. You can use it from the web TTSMaker.com. Here, you should know that each audio has a maximum of 1,000 characters, and that you can Use 20,000 characters a week being a free user. For more, you will have to pay. They are very generous margins, although the web has enough advertising. You also have options how to choose the audio format you want to generate, or listen only to the first 50 characters before creating the audio to make sure you are to your liking. You can also configure the speed, volume, audio quality, the length of each pause. Many things. Clipchamp This is a Microsoft tool to create videos, including the option to do so for the. However, You have an option of Text to voice When creating, with which you can write a text you want and choose the voice to use. You will need to enter the website clipchamp.com and log in with your Microsoft account (Hotmail or Outlook). Once the text option is chosen to voice, You will have the creation options in the right column. There, you can hit the text you want, choose the language and voice. In addition, there are advanced options to choose the voice passage and the rhythm you use to read what you write. And ready, with this, what you write will … Read more

We usually think that all pirates used the same flag. Actually, it was a personalized presentation letter

“The old Truhan, captain of a ship that had a pair of warm and a skull,” Sabina sang in his ‘a lame pirate’. Surely there is large countries flags that we do not recognize the first, but one that we have in mind is the pirate flag. But there is something interesting in the world of these finding: each captain had their flag. And although the black background inspires terror, the really infernal in the seas was the pirate flag of red background. Jolly Roger. This is what the pirate flag is called because, obviously, they did not call it “pirate flag.” It is not clear where the term came from and there are theories that relate it to the Templar flag and to this order, but also that it comes from the Frenchman “Joli Rouge”, Which comes to mean“ beautiful red ”reference to a variant of red flag that was used in combat. It loses strength when there was a first flag called ‘Old Roger’ that would refer to the devil, but well. It is also theorized with the copy of Spanish icons. What seems something more settled is that it appeared for the first time in 1724 in the book ‘General History of the Pirates’ that, supposedly, wrote one Captain Johnson. Again, it is not very clear how the flag arose and has its logic, since it would not be what most worried the first pirates who used it. Personal brand. The skull and the two crossed bones is the most iconic design. It is not since we have seen it in innumerable fiction worksbut also adapted to anime as’ mainstream ‘as’One Piece‘, video gamesbooks, musical bands … whatever. It is a powerful design of which there are variants with low bones or behind the skull, but also other designs that replace those bones with saber. However, although it is the most representative of piracy, it is not the only design that was used by these sailors. In fact, each captain had their flag. The most iconic belonged to Edward Seegar, an Irish sailor who was on a ship that the pirates took, decided to join his crew and then became independent as a captain. His flag was associated with all the pirates of history and at all times, but as we say, this is false. Another Edward, but Teach in this case, was the immortal ‘Barbanegra’. A flag is attributed with a skeleton that supported a sand watch and a spear pointing to a bleeding heart, but other sources say that its design was much simpler: a single skull. Bartholomew Roberts had several flags with skulls and complete bodies that represented different enemies. Henry Every had another iconic design: the profile skull with a handkerchief and crossed bones (although there are doubts about their authenticity). And Stede Bonnet was in his air, as a good pirate, with a design composed of a skull, a horizontal bone, a dagger and a heart. When designing it, it is seen that they asked “how many elements you want in the flag”, and he replied “yes”, although there is also doubts about his authenticity. Flags without evidence Historical errors. In some designs there are contradictions Historical, being a good example. Popularly, this skeleton design with horns, the clock and the bleeding heart has been attributed. The own Smithsonian has contributed to popular thinking to associate this flag into the pirate, but this design appeared for the first time in a 1912 magazine and there is no evidence that it was used by the pirate. The bearding flag on the left and the erroneously attributed to it to the right Not so deep symbology. Beyond these errors, what is clear is that pirates chose with care what elements to carry on their flag. It was still his visiting card and presentation letter, so the icons were not randomly there. The cross swords represented the skill in combat and ferocity. The sand watches could represent the E of death. The bleeding heart and skeletons, more of the same. There were some that customized the skull, such as Every, showing personal variations of a classic design, and others, such as Roberts, included letters that alluded to personal revenge against specific people. Barry Skeates Photo Psychological warfare. The flag was ‘branding’, but also something fundamental in the struggle in the high seas: an element of deterrence. A very powerful one, in addition, since the black color and the design of skeletons and swords sought to infuse psychological terror in the adversaries. When the pirates were in sight of another ship that interested them, they raised the black flag seeking to persuade their victims and to give up without resistance. The objective of the vandals was to take the loot, and that included the ship. The repairs were expensive and required time and a friend port in which to perform them, so the ideal was to take the target ship without any damage. But … what if the other ship did not give up? There was an alternative plan: the flag with red background. If the pirates raised this flag, what they transmitted to the goal is that they would not have compassion with the crew. Contemporary use. In the end, the pirates had their ego, but we can think that these designs died when piracy is over (that of that idealized time, of course, since Pirates continue to exist). And, although they no longer had a patch in the eye or stick leg, there were ships that They raised The flag during the last century. The British raised her in the submarines HMS UTMOST during the Second World War and in him HMS conqueror After sinking the Argentine General Beldrano cruise in the Falklands War. The Poles of the Submarine ORP Sokol They also raised it with two captured Nazi flags. Images | Barry Skeates, Malene Thyssen In Xataka | 22 years later, ‘Master and Commander’ is still obsessed with men. And it has … Read more

How to use the genumjis to create personalized emojis on the iPhone

Let’s explain How to use the genumjis function that has begun to arrive at the iPhone in Spain from iOS 18.4. It is one of the various options based on Apple Intelligence who have finally begun to arrive in Europe, such as Magic draft of the APP photos. This is a function that is integrated directly into the native Apple keyboard, so you will need to use this and not have another third parties activated. What he does is allow you Create personalized emojis that are sent as stickers through artificial intelligence. You describe what you want and the AI ​​creates it for you. Create Personalized Emojis with Genmoji The first thing you have to do is, in a conversation, click on the emojis icon From your Apple keyboard. It is the one that appears with a smiling face down to the left. When the emojis screen is displayed with your search engine, click on the button Genmoji that will appear above right. The first time you use this you will have to wait several minutes to download the necessary files to use it. Once on the Genmojis screen, the operation is simple. You just have to Describe what you want it to appear in the emoji. It is the same as generating images for artificial intelligence you describe what you want and Apple Intelligence will make it emoji. When you do, several creations based on your description will appear above. You can change the description whenever you want to generate genmojis, and thus refine until you get the result that best suits you. Now, Choose the genum that you like the mostand this will become a stick to send it to WhatsApp, Telegram or the messaging app that you prefer. You can do this every time you want. In Xataka Basics | iOS 18: Guide with 68 functions and tricks to squeeze Apple’s mobile operating system

Personalized GPTS are one of Openai’s great inventions. Now Google has just released yours in Gemini

One of the most interesting functions that chatgpt has are GPTS. In a nutshell, they are Chatgpt personalized versions created for specific purposes. We could have a GPT focused on correcting our texts, to solve mathematical problems or plan trips. It is a really useful function, but for now they can only be created by payment users. Anyone can use them, but only premium users can create them. Well Google has decided to opt for a different path with Gemini and its Gems. And yes, the user win. Gems? That is the name that the equivalents of GPTs receive on Google Gemini. To all purposes, they are exactly the same. Instead of using Gemini’s “general” version, Gems allow us to use a specialized version in certain tasks. It is a function that, having dedicated the necessary time and care, can be very useful. 10 Google applications that could have triumphed For everyone. So far, only payment users could create and use Gems. That is, the only way to access this function was paying the 21.99 euros per month that costs access to Gemini Advanced. That is over. As plannedGoogle has released access to gems and, from today, creating them and using them is completely free. Gems creator | Capture: Xataka Options. Google gives us five predetermined gems focused on brainstorming, professional orientation, programming, learning and writing review. Grace, however, is to create ours. To do this, you just have to go to the Gems manager and start the process (or you can do it by clicking directly in This linkwhich is direct access). Important: Although gems can be used from mobile app (and deployment is being progressive), they can only be created in the web version. Some keys. When creating a GEM it is important to be clear, concise and descriptive. Here are Some tricks to get the perfect prompt. For example, if we want our Gem to serve us to correct texts in English, something like this should be put: “You are a text reviewer in English and aid to people to detect and correct failures in their writings. Your work is to analyze the texts, find all errors, explain to the user why he is poorly written and suggest improvements. Use a friendly tone. Use Spanish to give explanations. Be patient.” The result will be something similar to this: when giving the badly written phrase “I are not feeling lots well”, the GEM returns the following answer: Example of use of a Gem created by us | Capture: Xataka Models. In our Gems we can use the models we have access to Google Gemini. In the free version we can use Gemini Flash 2.0 and Gemini Flash 2.0 Flash Thinkingwhich is experimental. If we had the payment version we could use the most advanced models. Using the reasoning model can be really useful if we create a very specific Gem focused on answers that need precision. Limitations. Gems are very useful, but they have an important limitation: they do not admit the rise in documents, at least in the Spanish version and for now. In the English version they seem to admit them. Being able to upload documents is a very interesting function to consult bibliography, interact with a PDF, with an Excel sheet, etc. Let’s think about the potential that this has to analyze data, extract trends or digest a lot of information more easily. The problem is that, for the moment, we do not have it available. Cover image | Xataka In Xataka | Google’s results with generative come to Spain. And with them, an elephant in the media room

Log In

Forgot password?

Forgot password?

Enter your account data and we will send you a link to reset your password.

Your password reset link appears to be invalid or expired.

Log in

Privacy Policy

Add to Collection

No Collections

Here you'll find all collections you've created before.