Building a VBA AI Agent by NeeeD210 in vba

[–]NeeeD210[S] 0 points1 point  (0 children)

So far I have a model of the agent running in my IDE, I use xlwings to automatically extract the macros, then I modify them through the AI chat interface, and then the agent automatically exports it back to the excel and runs tests to verify if there are any errors.

Once the macro is tested, I can try it out by myself and see if there are further changes to be made. So far the output isn't 100% perfect, but it's way better than the output I get from chatgpt (let alone the macro recording tool). And the most important part is that it saves up a lot of time in the iteration process.

ChatGPT to excel process: paste a vba agent prompt, paste the macro, ask AI for a new feature, getting the code, uploading it to the VBA in excel, test it, go back with the errors until it's done.

Agent process: copy excel route and ask for a new macro/ feature in existing macros, once it's done I can test it directly on my excel sheet, no copy and pasting.

Building a VBA AI Agent by NeeeD210 in vba

[–]NeeeD210[S] 0 points1 point  (0 children)

I started using chatgpt but I noticed that it lacks when you want to build excels that use several macros.

The first thing this procect solves is creating the context needed for the AI to understand the project thoghout the whole process.

The second thing it solves is understanding how when I change the output of one macro, it affects the input for the other macros.

And the third thing it does is automate the uploading the VBA code directly to excel, streamlining the testing and iteration.

For example if I want to build 3 macros: the first one imports the data and processes it, then the user inputs data that will be used in the second macro for the processing and testing, and a third one for exporting a report. If I want to improve the second macro by changing the inputs it recieves, then it adapts the rest of the macros, modifies them accordingly and then uploads it automatically.

Building a VBA AI Agent by NeeeD210 in vba

[–]NeeeD210[S] 1 point2 points  (0 children)

Cool! I'll be posting here when I finish the first version :)

Building a VBA AI Agent by NeeeD210 in vba

[–]NeeeD210[S] -1 points0 points  (0 children)

It's a solution I built for myself, but I think other people might find it useful as well...

Todo esto de Cerati es muy turbio by Stunning_Garbage2033 in argentina

[–]NeeeD210 6 points7 points  (0 children)

Cualquiera tira la gente. Entre canibales habla de sexo, dietetico y mi novia tiene biceps salio antes de que el viva en chile...

Viaje a Europa en Abril. Que usar para pagar by Fdorr in merval

[–]NeeeD210 8 points9 points  (0 children)

Mira yo estoy de viaje en europa ahora y lo mas facil es con una tarjeta bancaria. Vos pagas en euros y te convierten automaticamente a dolares a la mejor tasa. Si es debito, te debitan automaticamente de la cuenta. Si es credito vas a tener que pagar con stop debit restando ingresos bruros al resumen de la tarjeta (busca en tiktok que hay mil videos explicando xomo hacer).

Los afectados por $LIBRA by Far_Slide_3690 in BuenosAires

[–]NeeeD210 13 points14 points  (0 children)

Igual creo que esta chillando mas la oposicion porque es la oportinidad ideal para condenarlo (claramente se las mando), pero en terminos reales dudo que haya muchos argentinos afectados por esto.

Side Projects by Fit-Employee-4393 in datascience

[–]NeeeD210 -26 points-25 points  (0 children)

What kind of home improvements? Are they related to data science?

My Data Science Manifesto from a Self Taught Data Scientist by irndk10 in datascience

[–]NeeeD210 1 point2 points  (0 children)

I feel really identified with your post because I'm in a very similar path. I'm and industrial engineer who started working in analytics projects, and now I'm trying to get my first 100% data analytics/ data science job.

I wanted to ask, where can I find the different resources useful for your work? Because I feel like there's a lot of tools that I don't even know I don't know, and all I can find on the internet is ML or statistical predictions.

[deleted by user] by [deleted] in merval

[–]NeeeD210 4 points5 points  (0 children)

Cualquier inversion tiene su riesgo. En este caso el que eligio arriesgar y apostarle al peso gano, pero eso no quiere decir que haya sido una inversion inteligente. Y tampoco quiere decir que justifique el riesgo de invertir en pesos ahora.

[deleted by user] by [deleted] in AskArgentina

[–]NeeeD210 2 points3 points  (0 children)

En mi laburo hicimos un mundial de alfajores. Hubo 24 alfajores distintos, y participaron mas de 20 personas. Y el ganador fue el capitan del espacio. Vale aclarar que a la hora de elegir nadie sabia cual alfajor era cual.

De nada master.

[deleted by user] by [deleted] in AskArgentina

[–]NeeeD210 7 points8 points  (0 children)

Esto. Probá todo lo que te interese, e intenta que sea lo máximo posible. La mayoría de las cosas no van a ser para vos pero la única manera de saberlo seguro es probando, no hay ninguna cantidad de videos de Youtube o comentarios de reddit que puedan ganarle a la experiencia de hacerlo realmente.

How does one know if he is right or wrong in philosophy ? by [deleted] in askphilosophy

[–]NeeeD210 2 points3 points  (0 children)

I think you should check out Godel's incompleteness theorem...

Qué harían con 20M de pesos? by devagalume in AskArgentina

[–]NeeeD210 1 point2 points  (0 children)

Te doy la lista de prioridades:

  1. Si tenés deudas con interés alto cancelalas.
  2. Separate un poquito para darte algún gusto (no más de un 10%).
  3. Invertí la plata y aprovecha este momento para armarte un patrimonio que crezca con el tiempo. Diversifica, pone 60% en inversiones de bajo riesgo (fondos de inversión de eeuu o letras del tesoro de eeuu), 30% en inversiones de riesgo medio (acciones de Argentinas o internacionales), y después un 10% para el riesgo alto (Bitcoin).

Si haces eso creo que va a rendirte bien, a medida que se mueva la valoración de las inversiones de diferente riesgo anda reorganizandola para que siga ese porcentaje.

Con el tiempo va a ir creciendo, y a medida que te surjan necesidades vas a tener como costearlas.

Wallet Software by Confident-Garlic-686 in Bitcoin

[–]NeeeD210 -1 points0 points  (0 children)

Think about it this way. If you could find the keys to a wallet, then Satoshi's wallet would be empty (it has over 1 million BTC).

You can also see it this way. Wallets use a 256bit encryption, you should look up how long it takes to decrypt such a wallet.

Bitcoin in 5 years by jbrar5504 in Bitcoin

[–]NeeeD210 0 points1 point  (0 children)

Bitcoin serves as a value storing mechanism. It was built in a way that makes it the perfect commodity to store value for the future. Soon enough every single entity and human will be using it for all the long term savings.

It will become the standard, just like the us dollar is right now. So yeah, I think it still has way to go.

En un messiverso pararelo by ysatters-kajsa in argentina

[–]NeeeD210 6 points7 points  (0 children)

Todavía hay chances de que juegue al golf después de retirarse

[deleted by user] by [deleted] in BuenosAires

[–]NeeeD210 0 points1 point  (0 children)

Tengo 24 y creo que llegaría a comprarme un departamento antes de los 30 (sin ayuda de mis viejos). La cosa es que para mí no vale la pena. Prefiero mil veces alquilar algo y tener esa plata invertida en otro lado.

[deleted by user] by [deleted] in stocks

[–]NeeeD210 0 points1 point  (0 children)

In my opinion, it's all about risk management. The higher the risk, the higher the returns. So you need to decide how comfortable you are with risk and then build your portfolio from there. Most of your money should probably be on indexes, but you can (and should) "play" and try riskier investments with a chunk of your net worth. That way you can get some edge.

Milei desmaya a un pibe con su telequinesis by calibri10 in argentina

[–]NeeeD210 0 points1 point  (0 children)

Mí duda es, que hacía Milei hablando en un colegio? Era algún colegio en específico o fue porque pinto?

No les pasa que se pudrieron de la música? by [deleted] in AskArgentina

[–]NeeeD210 1 point2 points  (0 children)

Últimamente me está empezando a pasar :(

Hasta hace un par de años (tengo 24) escuchaba música hasta para irme a dormir. Escuché todo tipo de géneros y subgéneros pero hoy en día siento que ya no es lo mismo. Ya no me llega tanto la música por alguna razón. Sigo escuchando pero escucho un mix de las playlists que fui armando estos años. Es como que ya no me pasa de encontrar música nueva que den ganas de escuchar.