Migrate Algo to Web App
Budget: $750 – $1,500 USD
I am looking for a long-term technical partner to convert a fully functional Hotel Revenue Management System (RMS) from a Google Sheets/Google Apps Script prototype into a deployed, secure, and scalable web application.
I have already built the logic, database structure, and algorithms inside Google Sheets (using extensive App Scripts). It currently functions as a "MySQL database inside a Sheet." I need you to professionalize this into a real web application that I can access via a browser.
The Application Logic Includes:
Dynamic Rate Engine: Algorithms that calculate room rates based on occupancy velocity, momentum, and historical pace.
Competitor Rate Shopping: Ingesting and comparing rates against a defined competitor set (CompSet).
Inventory & Booking Management: Visualization of room availability, hold statuses, and incoming booking data.
Dashboarding: A "Rate Central" view that mimics an Excel grid but with better UI/UX for setting rates and viewing alerts.
How We Will Work Together (Important)
I am looking for a consultative partner, not just a task-taker.
Flexibility is Key: I do not have a 100% defined feature list. We will build this iteratively. As we progress, variables will change, and we may need to redo parts of the architecture. You must be patient and agile.
Input Required: I want you to look at my current setup and ask questions like, "Have you considered doing X feature this way instead?" I need you to guide the deployment and hosting process (AWS, Vercel, DigitalOcean, etc.) entirely.
Responsibilities
Review & Audit: Analyze my existing Google Apps Scripts (.gs files) and Excel formulas to understand the current logic (Velocity, Pace, Rate Triggers).
Architecture: Propose a tech stack (e.g., Python/Django, Node/React, or similar) that fits a data-heavy application.
Database Migration: Move my data from CSV/Sheets into a real SQL database (PostgreSQL or MySQL).
Frontend Development: Build a user interface that allows me to view grid-based data (similar to Excel) but with web-app functionality (buttons, toggles, secure logins).
Deployment: Handle all server setup, security certificates, and domain hosting.
Required Skills
Strong Backend Logic: Experience with complex algorithms and data processing (not just simple CRUD apps).
Database Design: Experience structuring relational databases for time-series data (historical rates, booking logs).
Communication: Excellent English. You must be able to explain technical concepts simply and be willing to jump on Zoom calls to brainstorm.
Security Minded: Experience building secure login portals and protecting proprietary algorithms.
Intellectual Property & Security
Strict NDA: You will be required to sign a Non-Disclosure Agreement before viewing the source code.
Ownership: All code, algorithms, and intellectual property created will belong 100% to me.
Trust: I am looking for a freelancer with a high reputation score and verified identity on freelancer.
When submitting your response, please tell me about a time you migrated a complex spreadsheet tool into a web app. What challenges did you face with the data logic?
I have already built the logic, database structure, and algorithms inside Google Sheets (using extensive App Scripts). It currently functions as a "MySQL database inside a Sheet." I need you to professionalize this into a real web application that I can access via a browser.
The Application Logic Includes:
Dynamic Rate Engine: Algorithms that calculate room rates based on occupancy velocity, momentum, and historical pace.
Competitor Rate Shopping: Ingesting and comparing rates against a defined competitor set (CompSet).
Inventory & Booking Management: Visualization of room availability, hold statuses, and incoming booking data.
Dashboarding: A "Rate Central" view that mimics an Excel grid but with better UI/UX for setting rates and viewing alerts.
How We Will Work Together (Important)
I am looking for a consultative partner, not just a task-taker.
Flexibility is Key: I do not have a 100% defined feature list. We will build this iteratively. As we progress, variables will change, and we may need to redo parts of the architecture. You must be patient and agile.
Input Required: I want you to look at my current setup and ask questions like, "Have you considered doing X feature this way instead?" I need you to guide the deployment and hosting process (AWS, Vercel, DigitalOcean, etc.) entirely.
Responsibilities
Review & Audit: Analyze my existing Google Apps Scripts (.gs files) and Excel formulas to understand the current logic (Velocity, Pace, Rate Triggers).
Architecture: Propose a tech stack (e.g., Python/Django, Node/React, or similar) that fits a data-heavy application.
Database Migration: Move my data from CSV/Sheets into a real SQL database (PostgreSQL or MySQL).
Frontend Development: Build a user interface that allows me to view grid-based data (similar to Excel) but with web-app functionality (buttons, toggles, secure logins).
Deployment: Handle all server setup, security certificates, and domain hosting.
Required Skills
Strong Backend Logic: Experience with complex algorithms and data processing (not just simple CRUD apps).
Database Design: Experience structuring relational databases for time-series data (historical rates, booking logs).
Communication: Excellent English. You must be able to explain technical concepts simply and be willing to jump on Zoom calls to brainstorm.
Security Minded: Experience building secure login portals and protecting proprietary algorithms.
Intellectual Property & Security
Strict NDA: You will be required to sign a Non-Disclosure Agreement before viewing the source code.
Ownership: All code, algorithms, and intellectual property created will belong 100% to me.
Trust: I am looking for a freelancer with a high reputation score and verified identity on freelancer.
When submitting your response, please tell me about a time you migrated a complex spreadsheet tool into a web app. What challenges did you face with the data logic?