New Spin on 30 year old Spreadsheet Technology

This topic was created by chrisglasier .

  1. chrisglasier

    New Spin on 30 year old Spreadsheet Technology

    The approach was triggered by the idea of using animation to move data into a fixed focus line rather than move the cursor to multiple data locations. Names and values that make up headings and data in spreadsheets are simply laid down as associated lists in sliding holders in an HTML5 web page. Housed in a NWJS (node-webkit) 'all Web technology' window on the desktop the page with its moving parts transforms into an authentic GUI machine, a novel 21st Century addition to both personal computing and World Wide Web.

    The machines create Information Technology (IT) objects (in JSON format) for their owners and collaborators to work on; each object has machine, type and category ids, a label for human recognition, key/value pairs for aspects needed for various tasks and an array of links to associated subsidiary objects. Machine owners store their own stringified objects in text files in locations of their choice.

    After parsing the plain text, each name and value to be displayed is made a hyperlink which passes machine and slider id to a universal function. When called the function moves vertical sliders to align the selections and adjusts the hierarchy of selections in a horizontal navigation slider along the top. Animation is needed not just to move data but also acknowledge machine reaction and changes to display.

    The first two of the row of four vertical sliders house lists of object labels derived from the link arrays; the third lists the plain or computed values of the last selected object (with value key names as floating text). A fourth holds a list of multimedia options that extends the potential of machines way beyond the scope of spreadsheets.

    For example, an animated 3D model can be generated in a NWJS monitor window that has links to machine, selected object and a JavaScript library like Threejs. Selections in the monitor change the machine display and vice versa. Several windows can show different multimedia views of the same object. The machine can also handle an unlimited number of different objects from different sources in a way that avoids coding conflicts.

    The machines offer an alternative way of working to that served by spreadsheets. They enable individuals to contribute to and participate in a world wide web of unique IT objects whether stored locally or online for sharing privately or publicly.

    Once created, access to an object and selected aspects can be passed to other individuals for different purposes. An IT object can represent anything however big or small provided it has ids, label and at least one aspect to be worked on; an object without links represents the smallest consideration of interest so that the web of objects replicates the world at work with all Web technology. It opens new opportunities for innovation generally, and in automation, recycling, compound search and consensual advertising in particular.

    1. This post has been deleted by a moderator

      1. This post has been deleted by its author

        1. chrisglasier

          Re: New Spin on 30 year old Spreadsheet Technology

          Authentic innovation is notorious for being initially considered incomprehensible. If any such innovation is lucky enough to gain traction, reactions progress from "it will never catch on" to "it was obvious anyway". I understand this and was expecting some acerbic dismissal of my post, but I certainly was not expecting to be accused of spam! I have no company and have nothing to sell. My description of a desktop web machine draws much from the content, style and purpose of 'As We May Think', in which acknowleged Internet Pioneer Dr Vannevar Bush describes his memex, a machine to help individuals automate information. The three links I included are to open source projects run by Roger Wang (NWJS), Douglas Crockford (JSON actually now built-in to modern browsers) and Ricardo Cabello (threejs - 3D library for HTML5 canvas).

          However despite hostility ('HTH,HAND') I still want to see if I can make my explanation less incoherent and find the traction needed. Having laid out the basic idea in text a screenshot may help.

          I am sure it is obvious to anyone here that the html, css and javascript needed to animate its sliding panels and generate its hypertext from JSON is pretty straightforward. However what may not be obvious is that what can be conveniently displayed and worked on because of the arrangement and animation would otherwise involve much human effort navigating and reworking data from widespread cells in many cumbersome spreadsheets. More than this using the NWJS (node webkit) windows mean individuals' desktop machines become part of the World Wide Web much like individuals' phones are part of telecommunication.

          1. jake Silver badge

            Re: New Spin on 30 year old Spreadsheet Technology

            It's still spam, dude. Justify it any way you want, you won't convince me otherwise.

            EOF

  2. This post has been deleted by its author

    1. chrisglasier

      ... is actually authentic innovation, nor that all innovation is useful.

      Don't you think that's worth discussing in relation to this post ... just in case? Or do you still think it's spam?

  3. This post has been deleted by its author

    1. chrisglasier

      Video

      Please have a look at https://www.youtube.com/watch?v=1zicsfNa1W8 for screenshots, functionality and commentary

      1. This post has been deleted by its author

        1. jake Silver badge

          @ 1980s_coder (was: Re: Video)

          "and has an obvious practical application."

          Assumes facts not in evidence.

          The OP is still a spammer.

          1. This post has been deleted by its author

            1. jake Silver badge

              Re: @jake (was:@ 1980s_coder (was: Video))

              "Why are you mis-quoting me, and inverting the sense of what I posted?"

              I did not misquote you. In:

              http://forums.theregister.co.uk/forum/containing/2678125

              You quite clearly typoed, in the final stanza, "and has an obvious practical application". To which I replied "Assumes facts not in evidence".

              Please, do try to read for comprehension. Ta.

              The OP is still a spammer.

              1. This post has been deleted by its author

POST COMMENT House rules

Not a member of The Register? Create a new account here.

  • Enter your comment

  • Add an icon

Anonymous cowards cannot choose their icon

Biting the hand that feeds IT © 1998–2020