Post Made Community Wiki
2 minor spelling corrections
source | link

Since this is programmers.stackexchange, I'll give you example how spreadsheets are useful to me as programmer in real life scenarios:

  • analiseanalyze log data using pivot tables, giving me nice staticsstatistics that can be data mined;
  • using latency data from the server to analiseanalyze the curve and figure out what effect improvement will have;
  • given server failure probabilities (data mined using spreadsheet), figure out redundancy scenarios if these rates increase or decrease;
  • general powerful calculator for complex formulas with possibility of tweaking any parameter at any time;

As for 5-dimensional data, it's just data with vector length of 5. It can be handled by 2-dimensional spreadsheet, as it can be handled by computer with 1-dimensional memory.

Also -- it's not substitute for database nor it claims to be. In fact Excel for example is very often used as frontendfront-end for RDBMS data.

Since this is programmers.stackexchange, I'll give you example how spreadsheets are useful to me as programmer in real life scenarios:

  • analise log data using pivot tables, giving me nice statics that can be data mined;
  • using latency data from the server to analise the curve and figure out what effect improvement will have;
  • given server failure probabilities (data mined using spreadsheet), figure out redundancy scenarios if these rates increase or decrease;
  • general powerful calculator for complex formulas with possibility of tweaking any parameter at any time;

As for 5-dimensional data, it's just data with vector length of 5. It can be handled by 2-dimensional spreadsheet, as it can be handled by computer with 1-dimensional memory.

Also -- it's not substitute for database nor it claims to be. In fact Excel for example is very often used as frontend for RDBMS data.

Since this is programmers.stackexchange, I'll give you example how spreadsheets are useful to me as programmer in real life scenarios:

  • analyze log data using pivot tables, giving me nice statistics that can be data mined;
  • using latency data from the server to analyze the curve and figure out what effect improvement will have;
  • given server failure probabilities (data mined using spreadsheet), figure out redundancy scenarios if these rates increase or decrease;
  • general powerful calculator for complex formulas with possibility of tweaking any parameter at any time;

As for 5-dimensional data, it's just data with vector length of 5. It can be handled by 2-dimensional spreadsheet, as it can be handled by computer with 1-dimensional memory.

Also -- it's not substitute for database nor it claims to be. In fact Excel for example is very often used as front-end for RDBMS data.

1
source | link

Since this is programmers.stackexchange, I'll give you example how spreadsheets are useful to me as programmer in real life scenarios:

  • analise log data using pivot tables, giving me nice statics that can be data mined;
  • using latency data from the server to analise the curve and figure out what effect improvement will have;
  • given server failure probabilities (data mined using spreadsheet), figure out redundancy scenarios if these rates increase or decrease;
  • general powerful calculator for complex formulas with possibility of tweaking any parameter at any time;

As for 5-dimensional data, it's just data with vector length of 5. It can be handled by 2-dimensional spreadsheet, as it can be handled by computer with 1-dimensional memory.

Also -- it's not substitute for database nor it claims to be. In fact Excel for example is very often used as frontend for RDBMS data.