Hi CodeAcademy Community,
I am a new user, and this is my first post.
My coding experience is limited to creating a user-interactive Excel Financial model using VBA which involves heavy calculations, and millions of rows of data in it.
My goal is to convert that Excel model into a web application, where a user can:
Input data into tables directly from excel data sources, and also input manual numbers into some cells.
Based on the inputs, the “Calculations” page runs is updated dynamically after any change to the input, and results in various rows of calculations that are visible to the user.
Based on the calculations and outputs, the webpage displays many different type of charts such as:
- Area & Line Time Series Charts
- Pie Charts
- Bar Charts
- Map where points can be marked based on lat/long.
- User Defined Charts based on data that they want to visualize
The user should be able to save their input and move onto the next set of inputs to continue with their financial modeling.
The user should be able to load any of their input set and edit it.
Multiple users can work simultaneously but on different set of inputs.
There are so many sources out there to learn from, and so many platforms/languages to learn from but as per my understanding, I should be learning these:
Any help to steer me in the right direction would be appreciated.