polmuz

[polmuz @polmuz]

@chacon I think an existing or new functional language since I'm guessing LLMs will work better with pure functions over code with side effects due to the smaller and and better defined context.

[Felix Zumstein @felixzumstein]

🚀 And we’re live!

SQLookup is now officially available in the Excel Add-in Store. And it’s completely free! 🎉

✨ Key Highlights:

- Works across Windows, macOS, and Excel on the Web.

- Brings the power of SQL, the lingua franca of data analysis, directly to Excel.

- Say goodbye to incomprehensibly nested Excel formulas—SQLookup makes it easy to create complex queries.

- 100% privacy-compliant: Everything runs locally on your machine, with no data sent externally (no sign up, no tracker, no nothing).

- SQLookup was built with xlwings Lite. Take it as a small glimpse of what you can build with Python and Excel! 🚀

With SQLookup, Excel just got a whole lot smarter. 💡 Let me know your thoughts and feedback! 🙌

👉 https://t.co/IInVMnOCej

#Excel #SQL #DataAnalysis #Privacy #Productivity #SQLookup

[Felix Zumstein @felixzumstein]

I've just submitted my first Office add-in for publication in the Excel add-in store... wish me luck! Whoever guesses what it is, will get a lifetime license for free! Hint: while it's built with xlwings Lite, it's not the modern version of "the xlwings add-in". #xlwings #pythoninexcel #microsoftexcel

[Felix Zumstein @felixzumstein]

Big news: xlwings Lite is out!

🚀 xlwings Lite allows you to create modern Office add-ins with Python instead of JavaScript WITHOUT THE NEED TO INSTALL PYTHON, not even on the server!

🚀 It's the true "Python in Excel", with Python running on your own machine, inside the browser engine that powers modern Excel add-ins. It's based on Web-Assembly (Wasm) via Pyodide/PyScript.

🚀 Supports custom functions as well as the Excel object model, so you can run scripts that add new sheets etc.

🚀 Supports Windows, macOS, and Excel on the web

🚀 It's the only modern Python in Excel solution with 100% privacy: no trackers, no sign up required, and it can be self-hosted on a static file server like nginx or GitHub Pages.

🚀 Free for non-commercial use.

🚀 xlwings Lite is also the only Wasm-based product that offers a solution if you hit a limitation of Wasm: simply switch 1 setting and you can run everything with a full Python installation on the server. No code changes required.

The possibilities this opens up are amazing. I am currently building my first add-in with xlwings Lite (feel free to guess what it is), which I hope to publish soon in Excel's add-in store. Stay tuned!

📖 See the docs: https://t.co/keitpgri8H

#xlwings #python #wasm #microsoftexcel

[Jaime Gómez-Obregón @JaimeObregon]

La realidad 😅🔫

Entonces, ¿cómo se factura a partir de ahora? ¡Abróchense los cinturones, que vienen curvas!

✨ Cargarás tus facturas a clientes privados en el SPFE en formato Facturae y enviarás un extracto en un formato diferente a VeriFactu. Aunque olvídate de VeriFactu si ya estás usando el SII. Pero si estás en Euskadi usarás, en cambio, TicketBAI, quizá con ef4ktur. En Navarra será algo parecido, pero diferente. Tus facturas al sector público, sin embargo, no irán por el SPFE sino por FACe. O por e-FACT si son para Cataluña… Y para tus clientes extranjeros usarás Facturae adaptado al estándar europeo y las remitirás por correo electrónico. ✨

Fácil, ¿verdad? Jajaja, ¡NO! 😅🔫

Si nadie hace nada, pronto todo lo que respire y facture estará obligado a utilizar una mezcolanza de canales y plataformas públicas distintas e incompatibles entre sí para comunicar sus facturas y reportes fiscales.

Y aunque la AEAT recibirá el detalle del IVA de todas las facturas al momento de emitirlas, las empresas y autónomos tendremos que seguir presentando declaraciones periódicas de IVA, resúmenes anuales y contratando departamentos de administración o asesorías externas.

Pero más allá de la complejidad, la incompatibilidad y la ineficiencia, el sistema propuesto tiene además algún agujero. Porque antes veíamos que el SII lleva años en marcha y es obligatorio para empresas grandes …y opcional para las demás. Y reportar en el SII exonera de utilizar Verifactu y sus complejidades. Entonces, ¿qué pasará con Verifactu si todos nos pasamos al SII? 🤔

[polmuz @polmuz]

@garybernhardt That's only true for spherical computers in a vacuum.

[Felix Zumstein @felixzumstein]

Looks like you all love Python in Excel, except that it runs in the Microsoft cloud. Well, let me introduce you to xlwings, the privacy-friendly Python package that runs locally or on your self-hosted server! #xlwings #python #microsoftexcel #pythoninexcel @xlwingsorg

[Felix Zumstein @felixzumstein]

xlwings custom functions run on a server (e.g., serverless function etc.). Some of the advantages:

✅ No local Python installation required
✅ SSO auth via Azure AD or any other provider
✅ "Unlimited" computing resources
✅ Source code never gets in the hands of the end user

[polmuz @polmuz]

Microservices should have been called Bender Driven Development.

[Felix Zumstein @felixzumstein]

It's finally here: The new xlwings Custom Functions support all Excel platforms (Win, macOS, and Web)! They also solve pretty much every other issue that users complained about over the last 9 years. Check out the docs: https://t.co/t9Bt7CkKxP #python #microsoftexcel #xlwings

[polmuz @polmuz]

@jmrepetti Enhorabuena.

[polmuz @polmuz]

@fisadev Norris?

[April King 🌀 @CubicleApril]

discovered this preference today, and wish I had found earlier because wow is it annoying to be prompted to login to all sorts of random sites

https://t.co/JrC47q9IC8

[Metafy @TryMetafy]

I’m a 40 year old Italian plumber who manages a $0 portfolio of businesses. This is my daily schedule

[polmuz @polmuz]

@etmaroo Aged like milk

[polmuz @polmuz]

@jmrepetti Los mejores amigos contratan un flete y no te hacen ir a sufrir innecesariamente con ellos.

[Felix Zumstein @felixzumstein]

Watch me deploy a @render backend in a few clicks to query a SQLite database directly from #GoogleSheets https://t.co/YtXZ0SetRO

[Metafy @TryMetafy]

Metafy Classes are LIVE!

Grab a seat and learn from your favorite Experts as they share their hard-won experience and explain the aspects of the game that will help you and your classmates ruthlessly destroy your enemies!

New Classes added constantly!
https://t.co/dfALBUoMPk

[Cruecial @JoshFabian]

I've got one last announcement for the week, and it's a big one. Today, we're officially welcoming @GamerzClass to the @TryMetafy family.

Metafy will soon be a platform not just for coaching, but also in-depth courses from the experts you know and love.

[Cruecial @JoshFabian]

We're starting something of our own at @TryMetafy

It's my pleasure to announce Sumo (@trysumoGG), a rethinking of what a tournament platform could and should be. Built with our community in mind.

We won't forget the mobile app, of course.

https://t.co/RXmPgiSTzp