I have a steadily-expanding spreadsheet for doing thermal mass calculations. Various areas of the spreadsheet calculate different things (volumes of wall segments, etc). I’d like to reuse these areas by ‘calling’ them from other parts of the spreadsheet. In other words, I’d like to use them as functions.
Of course, there’s the option of programming the functions in the spreadsheet’s BASIC, but it occurred to me to wonder whether there’s an easier way.
Can one part of a spreadsheet ‘call’ another without writing a separate program? Or alternatively, is there a way to ‘capture’ the internal logic of an area of the spreadsheet and turn it into a function?
I’m using NeoOffice on the Mac. If it turns out that another spreadsheet, such as Microsoft Excel, can do this, it would be a serious push towards buying that spreadsheet. If Apple’s Numbers does this, I’ll be really embarassed, because I already have that.