If you have the time, I’d recommend trying it out. Creating a basic webpage isn’t too hard, and you probably have the tools to get started on your computer already (you can do it with just Notepad and view it in any web browser! Although I would recommend downloading a free proper code editor such as VS Code).
Most good libraries for interacting with DBs and Excel documents are written for the backend, so you’ll probably want to use Node with a simple web server like Express to serve pages, and do your heavy calculations, report generation, and DB stuff on the Node server. Making a server seems complex but Express is quite easy-- you can get a functional web server in like 10 lines of code.
As for what framework would be good to use for the actual calculations, unfortunately I don’t have any recommendations. Generally I find that JS has enough by default to do decently complex grouping, summarizing, subsetting, calculating, etc. operations. You’ll probably want to use the “new” (now pretty old) array methods Map and Reduce, and new stuff like groupBy could be helpful. If you have any specific questions I should be able to answer them.
deleted by creator
If you have the time, I’d recommend trying it out. Creating a basic webpage isn’t too hard, and you probably have the tools to get started on your computer already (you can do it with just Notepad and view it in any web browser! Although I would recommend downloading a free proper code editor such as VS Code).
deleted by creator
Oh, okay. Still more doable than you might think, but of course not trivial. Good luck!
deleted by creator
Apologies for the wait!
Most good libraries for interacting with DBs and Excel documents are written for the backend, so you’ll probably want to use Node with a simple web server like Express to serve pages, and do your heavy calculations, report generation, and DB stuff on the Node server. Making a server seems complex but Express is quite easy-- you can get a functional web server in like 10 lines of code.
As for what framework would be good to use for the actual calculations, unfortunately I don’t have any recommendations. Generally I find that JS has enough by default to do decently complex grouping, summarizing, subsetting, calculating, etc. operations. You’ll probably want to use the “new” (now pretty old) array methods Map and Reduce, and new stuff like groupBy could be helpful. If you have any specific questions I should be able to answer them.
Have you tried discussing this with ChatGPT/Claude/Perplexity? I’ve found it extremely helpful for getting started, and exploring different options.
Imma be blunt. Maybe your attitude is contributing to the ‘Several degrees of idiocy at work’
Dudes tryin to be helpful with beginner tips and you jump down his throat. The irony of you saying crud isn’t trivial 😂
deleted by creator