Software Engineering Stack Exchange
Software Engineering Stack Exchange

Questions tagged [spreadsheet]

11 questions
9
votes
6 answers

Do you see an use for "Spreadsheet programming"?

A while ago I stumbled upon the concept of using spreadsheets (I mean cells and formulas not Macro code) as a way to specify programming logic. The idea is: create a spreadsheet with a cleanly defined flow of calculations (which sometimes are…
Paolo Bozzola
  • 344
  • 2
  • 8
5
votes
4 answers

Spreadsheet or writing an application?

When would you keep simple to medium-complex personal calculations in a spread sheet (Excel etc) and when would you write a small program or script for it? For example when you want to calculate what size of mortgage you can afford to buy a house. I…
LennyProgrammers
  • 5,649
  • 24
  • 37
4
votes
16 answers

What is spreadsheet useful for?

I have been in computer business for 15 years in various roles (sysadmin, developer, researcher), and I have never encountered someone using excel for something more advanced than for formatting tables, or as an ad-hoc database that could have been…
zvrba
  • 3,470
  • 2
  • 23
  • 22
3
votes
1 answer

How to design a storage backend for a cloud spreadsheet?

As a personal project to learn key technologies, I am trying to build a spreadsheet on the cloud (something like Google Sheets). How would you design the storage backend to power something like this? Does it make more sense to use a relational DB,…
cydro
  • 49
  • 1
3
votes
2 answers

Reverse Engineering a Spreadsheet into a Model and Controller

I need some help with the approach to a specific project. We have a large excel workbook with a ton of worksheets. There are many user inputs, which formula fields pull, return, repeat. This all ends up in a final report. Each worksheet has…
ZAR
  • 221
  • 2
  • 7
3
votes
2 answers

How best to version control massive configuration for an application?

Apologies if this doesn't make sense, English is not my first language. I'm working on an application where workflow is split into 'rules' that are defined on several pages of an Excel spreadsheet, a VB script strips out the descriptions of the…
blarg
  • 151
  • 5
3
votes
2 answers

Strategy for building an application to replace a large spreadsheet

I'm working on an application that is going to replace a rather large spreadsheet. The spreadsheet is used to budget purchases and things like that. It is the largest spreadsheet I have ever seen, and it required a lot of manual data entry, so this…
Dan Walmsley
  • 133
  • 4
2
votes
1 answer

Best practices for for putting tabular data on the web for users to edit?

I've been working in ASP.net for over three years now. The project I'm working on is designed with a 3-layer presentation/business/data design. The presentation layer is an ASP.net web site. The business and data layer are also in .net, with the…
Vivian River
  • 2,397
  • 5
  • 21
  • 32
1
vote
0 answers

Best practice to handle input and output with several csv-like files

I am currently writing an application with the following structure: input: the equivalent of an excel workbook, i.e. a few tables with different headers and a few scalar values. They represent properties of hardware, workers, production…
Andreas
  • 19
  • 2
1
vote
1 answer

How to offer custom word processor like editing power from an application

I have a very complex Java application which renders spreadsheet tables and summary documents in a window. These outputs are non standard in the sense that for instance the spreadsheet table isn't really a spreadsheet indeed not every row is an…
dendini
  • 214
  • 2
  • 9
0
votes
1 answer

Complexity limits of solutions created in Google Spreadsheets

I am creating a solution where I essentially put all rules regarding communication with customers (including automatic invoicing, reminder emails, welcome emails, etc.) into a Google Sheets and use Ultradox to create emails and PDFs based upon…
David
  • 4,449
  • 6
  • 35
  • 48