Computational Table for Web and Mobile

Excel sheet has proven highly successful for doing interactive calculations. Have created a solution to,

  1. Expose interactive calculations from Excel sheet to web and mobile.
  2. Get analytics on how users have interacted with exposed calculations.
  3. Show only grid ranges of interest to the user (ex: A1:C4). This feature helps to abstract away calculation complexities from end users and hides un-necessary rows of blank cells.

Here are screen shot of implmementaion for both web and mobile. Mobile implementation uses react native

Mobile — Exposed interactive calculation

Note: Exposed only selected grid range, without any blank cells and rows

Mobile — Calculation interaction

Web — Exposed interactive calculation

Note: Exposed only selected grid range, without any blank cells and rows

Web — Calculation interaction

Analytics on user interactions with calculations

When user interacts with exposed calculations, analytics on how user have interated with calculations are captured.

Sample calculation sheet used — Compound interest calculation

Please feel to share your thoughts / feedback.