• 18 Posts
  • 2.02K Comments
Joined 3 years ago
cake
Cake day: July 4th, 2023

help-circle


  • The best part of vba is you can record a Macro then edit it. I think you should start by adding a button that shows a message box when you press it, then record a Macro and throw some message boxes in it to see what values are used. Beware, office 365 has some other thing besides vba that I’m not familiar with, you may be better off learning that.









  • If you’re writing a program, definitely multiple threads or processes that each scan a chunk of the file, which basically means seek to the start of the chunk, read lines into the scan code until you hit the end of the chunk. For jsonl each chunk will need an alignment step to not break the jsonl.

    For command line trickery, maybe the file could be chunked up by running multiple dd instances with an offset parameter piped into grep. This has many synchronization issues and all the outputs should be captured separately then combined afterwards. I can’t think of a good way to align this method to line edges but maybe you can put some fancy regular expression magic into the grep step to ignore malformed json at the beginning and end and overlap the chunks?

    Grep is fast already, maybe test the simple approach and see how long it takes.



  • Local LLMs and learning CUDA on a machine with 6 1070Ti GPUs… Some of it works out of the box… For other stuff I’m having to explore what will work on the sm61 cuda architecture.

    Also getting better at running a pair of old 3d printers.

    I’m not one to buy new hardware if you can’t tell :P