I am looking to convert a 500-line excel spreadsheet logic into a mobile/web app. I am using power query right now and need that converted into a user-friendly platform. I am trying to implement a user subscription program that allows for unique data saved in each account. The content is a wide range of topics, subtopics, books, chapters, etc. with relevant info and curriculum outline to be used as a study tool.
Ideally, a user would subscribe to my app, and then get access to the curriculum from their personal user portal. All users would be able to see all the topics, subtopics, books, etc. Each user can then add notes to a certain book/article/page within their portal that only that user sees (like a personal digital flashcard/note-taking associated with the page/book they are studying.) The portal would save their searches, and their notes would then be attached to that book the next time they look for it.
There would also be a testing portion where people can enter answers and questions to test themselves as well (this would be just flashcard-style display).
I have attached currently a sneak peek of what the excel file looks like and how things are set up now.
Please feel free to ask questions as I know it is a complicated project. This would be a lucrative opportunity not just for the scale of the project but for the ongoing scope that will need updates and additions as we go along. We are hoping to have a prototype by the beginning of the school year.