phoenix
phoenixPhoenix - Your AI Assistant
Inactive session will be ended in 24 hours
End Session

Convert formulas in Excel file to preferably Javascript

  • Posted:
  • Proposals: 8
  • Remote
  • #2998228
  • Awarded
Samar H.Ali Hasnain C.Sergej M.Shahid Y.Ibrahim S. + 3 others have already sent a proposal.
  • 0

Description

Experience Level: Entry
Develop and convert logic and formulas in Excel file to preferably Javascript, for use in a simple calculator on web page. We need a script that can calculate a total price, based on number of users and number of units, for several different settings. Please see files attached for specifications.

New Proposal

Login to your account and send a proposal now to get this project.

Log in

Clarification Board Ask a Question

  • Partha Sarathi B.

    Hi, is it a mandatory requirement that the formula cannot be decoded by an expert in JavaScript from the source code? We can put things in different frames and have the scripts in different JS files to mix things up but I don't think the formula can be completely hidden from an expert. Please clarify.

    Thanks,
    Partha Sarathi Bhowmick

    Marius A.16 Sep 2020

    Hi Partha,
    Thank you for your question. Yes, it is mandatory. I am sure you understand that, in a very competitive situation, we don't want the main price formula and the price variables be open for inspection.

    Based on the response on the project, I am recommended to use PHP/Ajax. I have only two concerns, hiding variables/formula to front-end and that visitor don’t need to wait for page to refresh or clicking on a submit button.

    I was hoping it could be solved by Javascript because of the easiness of adding it to our website. If using PHP it’s a bit more complicated (at least for me), because the PHP must be develop as a snippet inside our CMS system, which is Modx CMS (https://modx.com/) .

    Hope I answered your question.

    Regards
    Marius Andersen

    Partha Sarathi B.16 Sep 2020

    Hi Marius, thanks for your detailed reply! Will obfuscated JavaScript code work? It would not be impossible but would be very difficult to decipher the formulas from obfuscated code. If yes then I would be able to help you without using PHP.

    Best regards,
    Partha Sarathi