The problem is, that you always start with a table just like in video, with 12 rows and simple functions.... coding everything for 12 rows is overkill.
Then you just add two more rows and one column. And 6 more rows and two more columns. And just two more formulas. And then you need just one minor thing, that can be done with a macro in five minutes.
Yes, companies such as Apple need specialized software to handle stuff, and there are solutions to handle this (eg. SAP, no matter how pain in the ass SAP is). But expecting Apple to use SAP when it was just the two Steves in a garage is stupid... and upgrading to SAP (or whatever other solution) is a thing you do, once the excell spreadsheet gets to an unmaintainable mess and not a second earlier.
Then you just add two more rows and one column. And 6 more rows and two more columns. And just two more formulas. And then you need just one minor thing, that can be done with a macro in five minutes.
Yes, companies such as Apple need specialized software to handle stuff, and there are solutions to handle this (eg. SAP, no matter how pain in the ass SAP is). But expecting Apple to use SAP when it was just the two Steves in a garage is stupid... and upgrading to SAP (or whatever other solution) is a thing you do, once the excell spreadsheet gets to an unmaintainable mess and not a second earlier.