How to correctly compose the database structure for an Excel table?

Question

Database design

Hello!
There is a table in Excel of the following form:
In general, there is a list of construction objects, and columns with information on the progress of construction at the end of each month (in the picture there are 3 months, and of course, 12), a total of 50 columns.
What is the best way to organize all this in a database:
1) store everything in one table, creating all the columns for each month in advance,
2) or create a table with objects and link them one-to-many to the second table with monthly reports?
3) there was also an idea for the main information on objects to make their own columns, and store all monthly reports in one jsonfield field, I don’t know how correct this is.
The application will be made on Django.
There will be no more than 70-80 objects. You may still need to calculate the totals by columns, in Excel it is easy to do this with formulas, but what is the best way to do it in a web application? Calculate at the time of saving in the database and store somehow, cache, or carry out calculations on the client at the time of page formation?

Answer 1

I have a table in Excel

What is the best way to organize all this in a database

Creating a database in Excel .