Interactive Multi-User Dynamic Online Excel Scatterplot Chart with Multi-User Interactive Controls
Budget: €250 – €750 EUR
### Description:
I have an Excel file with a scatterplot chart located on the "Graph" sheet. This chart is powered by the worksheet "Calculation" and contains VBA code and ActiveX form controls. I need this functionality replicated online with the following requirements:
1. **Interactive Scatterplot Chart:**
- The scatterplot chart should display on a publicly accessible webpage.
- Users can interact with dropdowns and selection boxes to customize axes and data shown dynamically.
2. **Multi-User Support:**
- Multiple users should be able to access the "Graph" sheet simultaneously.
- Each user should have their own settings defined by the dropdowns and selection boxes, without interference with other users' sessions.
3. **Backend Data Updates:**
- The back-end "Watchlist" data can be updated regularly by me, and these updates should automatically reflect on the scatterplot chart.
4. **Preservation of Functionality:**
- Ensure all interactive features currently in the Excel file (e.g., dropdowns, selection boxes) work seamlessly on the online version.
5. **User Experience:**
- Users can only interact with the "Graph" sheet functionalities.
- Back-end data and VBA code remain private and accessible only to me.
### Deliverables:
- Fully functional online version of the scatterplot with all required interactive features.
- Capability for multiple users to access the Graph page simultaneously, each using their own configurations.
- A simple, secure interface for updating back-end data.
### Skills Required:
- Expertise in VBA, Excel, and ActiveX controls.
- Experience with web application development (e.g., HTML, JavaScript, Flask/Django, or real-time frameworks like Node.js or WebSockets).
- Ability to translate Excel functionality into a web-based format with multi-user support.
Please provide examples of similar projects you have worked on or suggest tools/frameworks for implementation.
I have an Excel file with a scatterplot chart located on the "Graph" sheet. This chart is powered by the worksheet "Calculation" and contains VBA code and ActiveX form controls. I need this functionality replicated online with the following requirements:
1. **Interactive Scatterplot Chart:**
- The scatterplot chart should display on a publicly accessible webpage.
- Users can interact with dropdowns and selection boxes to customize axes and data shown dynamically.
2. **Multi-User Support:**
- Multiple users should be able to access the "Graph" sheet simultaneously.
- Each user should have their own settings defined by the dropdowns and selection boxes, without interference with other users' sessions.
3. **Backend Data Updates:**
- The back-end "Watchlist" data can be updated regularly by me, and these updates should automatically reflect on the scatterplot chart.
4. **Preservation of Functionality:**
- Ensure all interactive features currently in the Excel file (e.g., dropdowns, selection boxes) work seamlessly on the online version.
5. **User Experience:**
- Users can only interact with the "Graph" sheet functionalities.
- Back-end data and VBA code remain private and accessible only to me.
### Deliverables:
- Fully functional online version of the scatterplot with all required interactive features.
- Capability for multiple users to access the Graph page simultaneously, each using their own configurations.
- A simple, secure interface for updating back-end data.
### Skills Required:
- Expertise in VBA, Excel, and ActiveX controls.
- Experience with web application development (e.g., HTML, JavaScript, Flask/Django, or real-time frameworks like Node.js or WebSockets).
- Ability to translate Excel functionality into a web-based format with multi-user support.
Please provide examples of similar projects you have worked on or suggest tools/frameworks for implementation.