Health Informatics Discussion Forum

Spreadsheet-based Software Framework (SSF)

Our Spreadsheet-based Software Framework (SSF) is used to build apps that reimagine what spreadsheets can do. SSF apps provide new ways to take advantage of a spreadsheet’s power, flexibility, and simplicity. At the core of an SSF app are grids composed of millions of spreadsheet cells. Each cell is a content container with a built-in computation engine that provides a rich set of capabilities for inputting, storing, modifying, calculating and displaying data (described below). SSF apps organize cells into different data models that: (a) harmonize disparate data for aggregation and integration using maps, (b) perform analytics and create charts using data arrays, and (c) enable data inputs and report outputs using lists and tables. These cells are embedded in worksheets, and the worksheets reside in workbooks. The workbooks also provide macros for process automation that includes data access, transformation, organization, storage, transmission, analysis, and rendering, as well as utilization of user forms and integration with third-party tools. The diagram below depicts the many capabilities of a spreadsheet cell, something that few people realize. 

Links to some SSF samples: SSF samples SSF samples2

We want to offer our SSF under an open source license that supports community collaboration, without inhibiting the potential for commercial use, to: 1) develop other SSF versions that use other spreadsheet programs, such as OpenOffice Calc and LibreOffice Calc, while we continue to evolve current Excel-based versions; and 2) build web-based apps that leverage the SSF HIS apps’ algorithms and processes. We believe such community involvement would enable our technology to have the greatest possible positive impact on human health and wellbeing worldwide. We welcome interested parties.

You need to be a member of Health Informatics Forum to add comments!

Join Health Informatics Forum

Email me when people reply –

Replies

  • Dear Steve, Mr. Beller,

    your work sounds really interesting.

    Please, correct me, do I understand it right that it is like a Data-Warehouse Software with many implemented functions to represent data finally in different ways.

    Kind regards, Verena (D.)
  • Sorry for the late reply, Verena … Just found your question. The SSF can work with a data warehouse backend, but it can also work with the data stored in any database or in an XML document, a CSV or XLSX file, or any other delimited format.
    • Thank you Steve for your answer. It sounds really interesting! I will keep your solution back in my head. In my studies I will now learn to handle Tableau and Talend.
      Kind regards, Verena
This reply was deleted.

e-Seminar: Careers in Health Informatics

Careers in Health Informatics

Dr Chris Paton
BMBS BMedSci, MBA, FACHI, FFCI

This e-Seminar will cover how to develop your career in Health Informatics.

Speaker:

The seminar is hosted by Dr Chris Paton, a digital health researcher at Oxford University and Editor of the Health Informatics Forum. He is a Fellow of the Australasian College of Health Informatics and the UK Faculty of Clinical Informatics and worked as a medical doctor in the NHS and New Zealand before specialising in Clinical Informatics research at Oxford University. Dr Paton is Associate Editor for Sage Digital Health and BMC Medical Informatics and Decision Making journals.

Tuesday 11th December 2018

7-8pm GMT, 2-3pm EST

REGISTER NOW