How can I implement an interactive price filter in conjunction with the price list on google docs?

Question

WordPress

Good time of the day!
I've already broken my head with all sorts of options for implementing this task.
Initially, a price calculator was planned, but the problem lurked in the non-linear pricing of the price list.
That is, there is no way to use a mathematical formula to calculate the price.
Tell me, are there any WordPress solutions that allow you to select for example "Table" - "2 Shelves" - "800 mm Width" - "1000 mm Length" = and parse a specific cell in a Google Docs table?

Answer 1

Only one idea comes to mind...
The implementation of this task in several stages, namely:
1) Parsing data from Google Docs and storing it as JSON on your server.
2) Next, we connect DataTables and display a table on one of the pages.
3) Next, we implement filtering on the client side using DataTables.
There is a plugin for the VI that uses Datatables - TablePress, but it is unlikely to help you ... In any case, the question of data parsing remains open.