spreadsheet data grid tool

Question

How can I effectively leverage Jspreadsheet to manage my spreadsheets in a more data-driven way and integrate a system that tracks and lists all the programming languages I use across various projects? I want to include specific details, such as the productivity level of each language, how frequently I use them, and the types of projects where each one is applied. Additionally, I&rsquo;m interested in understanding how I could organize this data efficiently to provide clear insights and, if possible, connect it to a backend, like Django, so that the data remains updated in real-time. This would allow me to make more informed decisions, especially when it comes to selecting the most appropriate language for future projects based on historical usage and performance metrics. What would be the best practices for structuring this information to ensure that it is both practical and insightful in a data-driven context?

kekline · Answer

This request is going to take a bit of time to decode. What is the main driver for this? Is it personal use or something that your team or someone higher up the chain is requesting? The reason I ask this is that the requirements you mention are a bit of jumble and it's hard to tell which are highest priority from those that are low priority. Also, if you're doing serious data analysis, why use Django. Django is fine as a front-end, but it's not really associated with data-centric applications or database solutions. If other people are updating the data in your spreadsheets, you should consider using a relational database. You could download the free version of SQL Server (SQL Server Developer Edition) and use it as the backend rather than a collection of spreadsheets, which are not designed for concurrent multi-user access. 
 But the tl;dr is that we need more information to give you a good recommendation.

spreadsheet data grid tool

Top Replies