Embedded Files
Search organization content
J Farringdon offers expert consulting, with 30 years experience of wearable-devices and physiology data modelling. Recent projects include AI and ML sleep algorithms for wearables & a smart mattress, heart-rate variability stress measurements, and EEG calmness measuring devices. Recently EMG systems for measuring cognitive performance. Projects include consumer and medical devices (FDA & EU-MDD). Just one person, I frequently spin up AI & machine learning teams for clients with a trustworthy overseas software partner of 20 years. Farringdon Science also works on data visualization, from holographic displays to custom charts in Sheets.
If your project needs some help then let's talk, jonny *at* farringdon.science
For years I have used Google Workspace and Sheets to analyze data. Frequently I wanted to make a chart that Sheets did not offer. So I made an add-in for Google Sheets called FSplots. I am solving a problem for myself, but you are welcome to try it.
FSplots is a fast and convenient way to build advanced scientific and statistical charts that Google Sheets does not directly offer. An easy to use add-on built specifically for the Sheets user who needs more from their data visualizations.
Split-Color Scatter Plots: Color-code your data points automatically by a custom category split (e.g., age range, gender, test group, or month). For "truth & prediction" data models, it automatically calculates Bias, Mean Absolute Error (MAE), and Correlation. With options to add the unity line (x=y), the best fit line, and the best fit equation & R2 value.
Bland-Altman Plots: Map data agreement quickly. Includes point-coloring by group splits, with automated Bias & Limits of Agreement lines and values.
Custom SD Bar Charts: Generate mean and standard deviation bar charts. Unlike native Google Sheets, every bar gets its own SD error bar value.
Interquartile Range charts (IQR): Calculates the median and displays the distribution with 3 options for the whiskers: max min, +-1.5 IQR (standard box plot rule) , & custom percentiles.
100% Secure & Local Processing: All data formatting and mathematical calculations happen entirely inside your spreadsheet. This tool contains no identity or activity tracking, and your data never leaves your Google Sheet.
Featured video
Featured video
Demo of Custom Plots in Sheets
Page updated
Report abuse