7 ms·

One thing I wonder -- Google Sheets has relatively restrictive limits on the amount of data you can have per sheet. I think something like 400k cells? What happ

One thing I wonder -- Google Sheets has relatively restrictive limits on the amount of data you can have per sheet. I think something like 400k cells? What happens when a customer scales up to the point that their data doesn't fit anymore? I guess maybe users at that scale can afford to just buy a bespoke CRM solution / hire a dedicated programmer?

skellystudios 6y ago
I think it’s 5M cells, so there’s a 10x lifetime boost for you. We’d like to support SQL databases in the future, which would give the option to go forward without starting from scratch.
- charlesdaniels 6y ago
  Ahh, seems you are correct, I believe the 400k number was old. 5M cells is indeed a lot. Having an exporter that could generate an SQL schema + API that replicates what the user's formulas did would be a cool feature, but probably very difficult. I could see building an 80% solution (for your internal use), then selling a consulting service to take your existing Stacker setup and turn it into a bespoke system built on top of a real DB. Presumably by the time the customer has enough records for that to make sense, they would have the money to pay for such a service. Perhaps you could also offer an "archive your old data after $N years" feature. Maybe also sell snapshot storage, or allow the user to download the archive and save it themselves? I don't know your tech stack or the business concerns in your space, but maybe that looks like generating a static site that bundles all the user's data, so it can later be viewed in a read-only format using a regular browser (allowing you to just scrape calculated formula values instead of having to implement the formulas yourself). I could see that being useful to a user wanting to pull up a record years down the line as it was displayed when it was created.

7 ms·

One thing I wonder -- Google Sheets has relatively restrictive limits on the amount of data you can have per sheet. I think something like 400k cells? What happ

by charlesdaniels 6y ago

skellystudios 6y ago
I think it’s 5M cells, so there’s a 10x lifetime boost for you. We’d like to support SQL databases in the future, which would give the option to go forward without starting from scratch.
- charlesdaniels 6y ago
  Ahh, seems you are correct, I believe the 400k number was old. 5M cells is indeed a lot. Having an exporter that could generate an SQL schema + API that replicates what the user's formulas did would be a cool feature, but probably very difficult. I could see building an 80% solution (for your internal use), then selling a consulting service to take your existing Stacker setup and turn it into a bespoke system built on top of a real DB. Presumably by the time the customer has enough records for that to make sense, they would have the money to pay for such a service. Perhaps you could also offer an "archive your old data after $N years" feature. Maybe also sell snapshot storage, or allow the user to download the archive and save it themselves? I don't know your tech stack or the business concerns in your space, but maybe that looks like generating a static site that bundles all the user's data, so it can later be viewed in a read-only format using a regular browser (allowing you to just scrape calculated formula values instead of having to implement the formulas yourself). I could see that being useful to a user wanting to pull up a record years down the line as it was displayed when it was created.