Relative Content

Tag Archive for excelgoogle-sheetsexcel-formulagoogle-sheets-formula

Custom aggregate functions in Google Sheets or MS Excel?

– Background – We work with non-linear data that has to be normalized for basic math functions to work. (Think of sound or earthquakes). For example, the total energy of two speakers playing a sound at 80 Decibels each is ~83dB (not 160dB). This is because we have to normalize the data before we can […]