Posted 7 Hours Ago Job ID: 2116153 66 quotes received

Migrate Algo to Web App

Fixed Price
Quotes (66)  ·  Premium Quotes (12)  ·  Invited (0)  ·  Hired (0)

  Send before: February 23, 2026

Send a Quote

Programming & Development Web Development & Design


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

  1. Review & Audit: Analyze my existing Google Apps Scripts (.gs files) and Excel formulas to understand the current logic (Velocity, Pace, Rate Triggers).

  2. Architecture: Propose a tech stack (e.g., Python/Django, Node/React, or similar) that fits a data-heavy application.

  3. Database Migration: Move my data from CSV/Sheets into a real SQL database (PostgreSQL or MySQL).

  4. 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).

  5. 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 Guru.



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?



... Show more
Parth S United States