• 0 Posts
  • 3 Comments
Joined 1 year ago
cake
Cake day: July 20th, 2023

help-circle
  • I can answer yes to all of these questions but still use a spreadsheet. I understand your point, but I feel even with these the line is still gray.

    I just checked and my largest spreadsheet currently has 14,300 lines across 12 tabs. Each tab contains the same information just pulled from a separate form. So each tab is linked to a form to update automatically when someone submits a new response. We then process these responses periodically throughout the day. Finished responses are color coded so a ton of formatting. Also 7+ people interacting with it daily.

    Then we have a data team that aggregates the information weekly through a script that sends them a .csv with the aggregate data.

    The spreadsheet (and subsequent forms) are updated twice a year. It was updated in June and will be updated again in December. It’s at 14k now and will continue to grow. We’ve been doing this through a few iterations and do not run into performance issues.