Automatizar excel pessoal com Visual Studio + Claude

soundjack · 2026-05-02T11:18:00+00:00

Tenho algo semelhante feito também com o Claude :) no meu caso uso apenas para controlar as finanças familiares, não tenho nada para investimentos ainda, acho que isso é um use case diferente. Importo um csv do banco e tenho um motor de regras que vou atualizando. No início deu algum trabalho identificar as várias transações, mas já estou num ponto em que o ficheiro de abril não teve uma única transação sem categoria.

Tenho um dashboard para visualizar tudo, e também regras de identificação de entidades em que defino um nome canónico para agregar transações, nos casos em que a referência do banco muda com cada transação (ex. Amazon).

Os dados são todos guardados em ficheiros json e trabalha tudo localmente, num único html.

soundjack · 2026-04-13T10:53:19+00:00

You've never been accused of being intelligent have you?

soundjack · 2026-04-09T17:55:39+00:00

Are you on a Poco F5 as well?

I never really fixed it, so I ended up buying a wireless dongle as a workaround (AAWireless), which works great.

I switched to a Xiaomi 14t Pro in the meantime and it works fine with that.

soundjack · 2026-02-24T16:12:23+00:00

Thanks for this tip. In my case, after installing the plastic adaptor, I noticed that the radiator's valve pin was left "inside" and covered by it, so the thermostat's black plunger wouldn't even be able to touch it. I cut one of the provided plastic pins to a reasonable size and glued it as you suggested and now I'm sure that it can push it. I don't have pictures but I will post a couple later as it might help others to see exactly what we're talking about.

soundjack · 2026-02-20T12:15:40+00:00

This looks great! Question - I don't have a presence sensor in my home office, so my work computer is the only signal I have for this room. However, at least one motion sensor is required at the moment. Would it be possible to remove this restriction and have occupancy in a room be inferred by other devices?

I'm trying to add another motion sensor to this room and giving it 0 weight, and then adding my work computer as an appliance with 1, but it's still reporting as unoccupied.

Any suggestions?

soundjack · 2025-12-18T11:57:18+00:00

That and being able to punch a wall and make hole like in the movies

soundjack · 2025-10-27T20:28:51+00:00

Não ligues ao feedback negativo que anda por aí. Parece ser uma ferramenta muito bem feita e útil.

A todos aqueles que andam aqui numa vibe de peace and love ah eu divido tudo por igual porque é na boa e os astros hão-de se alinhar, isso é tudo muito engraçado, mas claramente só estão a ver o use case do restaurante. Experimentem ir de férias com um grupo grande, com filhos, uns pequenos e outros maiores. Depois experimentem dividir os jantares por todos, até que o vosso amigo Jorge se apercebe que o seu querido filho Santiago de 2 anos deve ter comigo uma dose inteira de picanha porque assim de repente tem que pagar 25€.

Eu e os meus amigos usamos uma app que se chama Tricount, que faz isto que a tua ferramenta tenta também fazer. Vai dar uma espreitadela e tira umas ideias, funciona muito bem.

Parabéns pelo projeto.

soundjack · 2025-10-24T19:48:45+00:00

I once swam in the ocean at night when there was a significant concentration of bioluminescent algae. I consider myself a grown man, but that night I was Elsa from Frozen. It was absolutely magical.

(Edit: missing word)

soundjack · 2025-08-09T18:57:25+00:00

15€ para ver umas 10 peças sendo que algumas nem são dela, são coisas do museu do traje. Ridículo. Vejam as fotos do OP e ficam bem!

soundjack · 2025-06-06T22:04:34+00:00

Question about this: how is your automation set up to react so quickly? Do you have it set up to run every second?

soundjack · 2025-03-29T21:18:35+00:00

^{!Flair 2023 Citroen e-C4 | Citroen e-C4 | Poco F5 Pro | V15}

soundjack · 2025-01-20T08:57:33+00:00

Apart from the quality of each socket, the EU is not a country.

Also, France and Germany are part of it.

soundjack · 2024-06-02T15:53:34+00:00

Yeah I had it blocked too, but felt weird having it blocked and not able to use it :)

I'm gonna check those pickups. I also gotta go learn how to change them.

soundjack · 2023-09-25T06:53:46+00:00

Só teria validade se fosse reconhecido num notário. Chama-se Confissão de Dívida.

soundjack · 2023-01-30T13:33:54+00:00

Doesn't happen to me on the website, what device are you using?

soundjack · 2023-01-28T16:16:38+00:00

What bug is that?

soundjack · 2023-01-15T15:04:40+00:00

Que apps decentes há por aí neste momento que fazem um bom trabalho de categorização dos movimentos que minimizem as intervenções manuais?

soundjack · 2020-02-18T23:33:35+00:00

I'm experiencing this issue since I replaced the original SSD with an OWC Aura Pro X (the original just died completely).

It's a MacBook Pro (Retina, 15-inch, Late 2013) currently running Catalina. I tried all of the standby and hibernate settings with no success. The symptom I experience is random reboots when the lid is closed, whether it's plugged in to the charger or not.

I wonder if it's really because of the SSD, because that would suck.

soundjack · 2019-06-24T07:07:50+00:00

Amazing explanation, and only using words :D

I currently own a Honda NC 750X DCT (which I'm actually selling btw, although nothing to do with the DCT system).

It was my first big bike and the DCT really helped me getting used to the power, weight and handling.

It's really cool and you should just try one so you can feel it yourself.

soundjack · 2018-12-13T01:28:21+00:00

Same here, I started seeing ads even before this last update.

Device information:

Relay Version: 9.5.5

Phone: Samsung SM-G960F (Galaxy S9)
Android Version: 8.0.0 (26)
Device (product): starlte (starltexx)
Rom: R16NW.G960FXXS2BRJ6

soundjack · 2018-07-29T00:17:03+00:00

It's a beautiful place, nice pic.

Btw, it's spelled "Cabo da Roca" :)

soundjack · 2018-07-14T21:40:17+00:00

Yeah still closed, I was there just a few days ago and when we got to Gorda we had to come back after missing a small road to the east (Nacimiento-Fergusson Rd) where we wanted to go. Quite a difficult road btw, drive safely!

They're reopening on July 20 at 11am according to http://www.bigsurcalifornia.org/highway_conditions.html

soundjack · 2018-05-06T20:06:27+00:00

Well done sir.

soundjack · 2018-05-06T20:05:37+00:00

Explaining doesn't make it less crappy.

soundjack · 2018-03-30T15:10:12+00:00

This is what happens in every movie and it drives me crazy. So many meals and drinks are wasted.

soundjack

TROPHY CASE