Since its inception, Microsoft Excel has changed how people organize, analyze, and visualize their data, providing a basis for decision-making for the flying billionaires heads up in the clouds who don’t give a fuck for life offtheline

    • sugar_in_your_tea@sh.itjust.works
      link
      fedilink
      arrow-up
      0
      ·
      10 months ago

      Python is fast enough, and generally quite a bit faster than complex spreadsheet formulas. I’ve seen formulas that can take minutes that Python could do in seconds. A web request isn’t going to matter that much.

      • Aatube@kbin.socialOP
        link
        fedilink
        arrow-up
        1
        ·
        10 months ago

        Web requests are \very\ slow compared to CPU computations, not to mention that time has to be doubled since it’s a two-way route.

        • sugar_in_your_tea@sh.itjust.works
          link
          fedilink
          arrow-up
          0
          ·
          10 months ago

          Sure, but it happens once. So as long as Python saves you more than the half second or so round trip, it’ll be preferable.

          I’d prefer it to be embedded, but I can absolutely see it being useful even if it’s cloud-only.

          • Aatube@kbin.socialOP
            link
            fedilink
            arrow-up
            1
            ·
            10 months ago

            Wouldn’t it need to send to the cloud and back every time you change one of the cells the script is depending on?

            • sugar_in_your_tea@sh.itjust.works
              link
              fedilink
              arrow-up
              0
              ·
              10 months ago

              Yup, most likely. I’m saying the total calculation w/ Excel formulas is often greater than that round trip + computation time w/ Python. Excel formulas are pretty slow.