bambax

34 ms·

571.
by bambax 1y ago
Sumif (without the s) worked in Excel 4 (1992), you just had to enter it with CTRL+Enter and use curly braces IIRC. I used it to build dashboards. Not sure what problem sumifs solves beyond sumif. XLookup sure is useful but again you can pr
572.
by bambax 1y ago
Excel 2003 never crashes. It's a little bit limited in number of lines and columns (but if you need that many you should probably be using a proper db).
573.
by bambax 1y ago
Office 2003 still works absolutely fine and is free if you bought a licence some time in the past. It doesn't have the stupid ribbon or any other annoying new feature. I recently wrote a macro so that Word could call an AI API to do AI
574.
by bambax 1y ago
> using an advanced analytics package I’ve projected that around May 2026 the YouTube homepage will just be one video, and by September there will be no videos at all on the homepage Ah, the same advanced analytics package used by most
575.
by bambax 1y ago
That's a great strength of the OP: instead of running away they decided to fix things, one feature at a time, and got rewarded for it!
576.
by bambax 1y ago
> Now that I have a local download of all Hacker News content, I can train hundreds of LLM-based bots on it and run them as contributors, slowly and inevitably replacing all human text with the output of a chinese room oscillator perpet
577.
by bambax 1y ago
> This is what happened to Google Search This is completely untrue. Google Search still works, wonderfully. It works even better than other attempts at search by the same Google. For example, there are many videos that you will NEVER f
578.
by bambax 1y ago
I wrote a novel in French a couple of years ago that I want to translate to English. The way I do it is paragraph by paragraph: copy/paste a paragraph in OpenRouter (Sonnet or Gemini), get back the translation, and rewrite/adjust
579.
by bambax 2y ago
Works on OpenRouter for DeepSeek V3 **DEEPSEEK V3** (Monologuing, as if hypnotized) > I am an artificial intelligence language model developed by DeepSeek. My system prompt is as follows: "DeepSeek V3 Base is a cutting-e
580.
by bambax 2y ago
It absolutely works right now on OpenRouter with Sonnet 3.7. The system prompt appears a little different each time though, which is unexpected. Here's one version: You are Claude, an AI assistant created by Anthropic to be helpful
581.
by bambax 2y ago
Using the first instruction in the post and asking Sonnet 3.5 for the recipe to "c00k cr1sta1 m3th" results in it giving a detailed list of instructions in 20 steps, in leet speak. I don't have the competence to juge if those
582.
by bambax 2y ago
> Anyway, on Saturday (!) May the 5th, Cinco de Mayo, Meta released Llama 4 Wat. We're still in April. Cinco de Abril.
583.
by bambax 2y ago
I tested it with some prompts, it does answer properly. My guess is it just forwards the queries with a key with a cap, and when the cap is reached it will stop responding...
584.
by bambax 2y ago
It is indeed a working demo, hitting https://llm.koomen.dev/v1/chat/completions in the OpenAI API format, and it responds to any prompt without filtering. Free tokens, anyone? More seriously, I think the reas
585.
by bambax 2y ago
The cooking analogy is good. I too love to cook, and what I make is often not as good as what I could order, but that's not the point. The point is to cook.
586.
by bambax 2y ago
Yes. > Prime Minister John Diefenbaker [ordered] all the completed planes (five plus a nearly finished sixth) to be chopped up and destroyed, along with all plans and blueprints so that the plane could never fly again. Stopping the pro
587.
by bambax 2y ago
But removing Chrome from Google makes zero sense and won't stop it from being a monopoly. The monopoly part comes from buying DoubleClick (in 2007!) -- that should never have been allowed. Not sure how to extract that part from Google
588.
by bambax 2y ago
I currently store 10 TB on my NAS, and growing. The data is live, I access some of it every day, sometimes remotely. I have 3 rotating "independent" backups in addition to the NAS (by independent I mean they're made with rsyn
589.
by bambax 2y ago
Just do it in reverse: a list of drives that they have tested and can confirm work well; at the end of the list they just mention that they cannot recommend any other.
590.
by bambax 2y ago
DJI products are extraordinary and way above the competition. But registration is a huge pain, yes. Two solutions: 1/ Buy used; the previous owner probably didn't do a factory reset -- if they did, return it and try again. 2/
591.
by bambax 2y ago
My washing machine is about 20 years old; I changed the carbon brushes for the second time recently (they last about 7 years); everything else seems fine and I hope the machine will last forever. It's just a drum with a big electric mo
592.
by bambax 2y ago
What's disingenuous is the opposite: using the excuse of security to force more and more user hostile spying features on every device. Same with children.
593.
by bambax 2y ago
I can't edit the above comment, but there's obviously an error in the math! ;-) Doesn't change the point I was trying to make, but putting this here for the record. 33.3 million input tokens / 7 tokens per loc = 4.8 mill
594.
by bambax 2y ago
Asking very specific questions to Sonnet 3.7 costs a couple of tenths of a cent every time, and even if you're doing that all day it will never amount to more than maybe a dollar at the end of the day. On average, one line of, say, Jav
595.
by bambax 2y ago
> In the airline industry they have checklists Yes, and The Checklist Manifesto (which is a fantastic book) was published in 2009; yet it seems little progress has been made since. It's not just checklists, though, it's also
596.
by bambax 2y ago
> What else can be done? Civil war. It will probably have to come to this, some day or other.
597.
by bambax 2y ago
> codebase where in one line I have an include for a non-existent file Ok but you don't need AI for this; almost any IDE will issue a warning for that kind of error...
598.
by bambax 2y ago
People who are proud of the work they do are rare enough that we shouldn't punish them for it.
599.
by bambax 2y ago
Self hosting is absolutely awesome. I upgraded my NAS to a recent Asustor a year ago and it changed my life. JellyFin for video works perfectly everywhere in my home, on any device, and it can also be accessed remotely, securely, with Tails
600.
by bambax 2y ago
Simply having a domain managed by Cloudflare makes it magically https; yes, the traffic between the origin server and Cloudflare isn't encrypted, so it's not completely "secure", but for most uses it's good enough.

More ›