• 2 Posts
  • 34 Comments
Joined 1 year ago
cake
Cake day: January 9th, 2024

help-circle






    • Whatsapp has end-to-end encryption enabled by default on chats, along with disappearing messages. You’re good staying on it for now.
    • Proton
    • You’re on it right now
    • Orion (by Kagi) is available on Apple devices - I am not on them so haven’t used it, but seems really cool
    • Bitwarden, or I guess Apple’s native password manager if you’re already using iCloud
    • Simple Notes









  • Misleading title. From the article,

    Asked whether “scaling up” current AI approaches could lead to achieving artificial general intelligence (AGI), or a general purpose AI that matches or surpasses human cognition, an overwhelming 76 percent of respondents said it was “unlikely” or “very unlikely” to succeed.

    In no way does this imply that the “industry is pouring billions into a dead end”. AGI isn’t even needed for industry applications, just implementing current-level agentic systems will be more than enough to have massive industrial impact.




  • silverhand@reddthat.comtoTechnology@lemmy.world*Permanently Deleted*
    link
    fedilink
    English
    arrow-up
    13
    arrow-down
    2
    ·
    edit-2
    2 months ago

    Anybody who used ANY library to process xslx knows MS keeps changing it :-)

    I highly doubt that, also, people in corporate finance do not use libraries to process excel files.

    About ranges… can you give me the range for whole columns minus 6 first records and 9 last records?

    =OFFSET(first_cell, 7, COLUMNS(range_name), ROWS(range_name)-9-7) where range_name is the label given to the whole table and first_cell is its first cell.


  • silverhand@reddthat.comtoTechnology@lemmy.world*Permanently Deleted*
    link
    fedilink
    English
    arrow-up
    28
    arrow-down
    1
    ·
    edit-2
    2 months ago

    Try to write a formula range which covers only lower half of the column which is typical setup in summing numbers( avoiding headers )

    You can literally label ranges to use them as variables in Excel formulae, not to mention Excel Tables has more operations and features than you’ll ever need.

    limits in columns and records

    Unless you are working with an unfiltered, un-aggregated ledger dump straight out of your database (in which case you shouldn’t be let anywhere near an office computer), it’s rather hard to cross 1M+ rows and 16.4k columns in corporate finance.

    ever changing formats across versions

    The .xlsx format was introduced in 2007 (18 years ago) and hasn’t changed since. Not to mention you can still use all kinds of plaintext formats whenever you want.