Excel spreadsheet to record tests - worlds most expensive spreadsheet

[EddieM]

I use excel 2010, I refuse to move to a subscription based model.

I'm tempted to try libre office, although the formatting options on excel are comprehensive and easy to use.

Having built an excel spreadsheet to calculate lengths and angles of timber roof lanterns, I can fully understand how quickly it goes teats up.

By entering the length, width and pitch of a roof lantern the spreadsheet workout the lengths and angles of the ridge, hips, common rafter and jack rafters as well as the glass sizes.

But by god it's hard finding an error, it's painful trawling through each cell, checking formulas and cell references.

Not much use if you already have excel, but you can purchase o365 for a one off payment, about £300 If memory serves.