Converting Excel formula in to Javascript to be used in an Acrobat form
- or -
Post a project like this$$
- Posted:
- Proposals: 3
- Remote
- #1416743
- Expired
Description
Experience Level: Intermediate
General information for the website: Not for web - Script required for Acrobat form
Description of every page/module: Not for web - for interactive acrobat form (to be used offline)
Description of every page/module: I would like to create an Interactive pdf form which includes sums from Excel - Like a sales calculator. I am able to create the form, add fields and use the basic calculations that Acrobat Pro allows. More complicated sums require translation in to javascript, this is where I need the help.
There would be between 5-15 sums, some more complicated than others - examples below
=E13*0.8
=IF(AND(OR(E16=0,E16=""),G19="x"),0,IF(AND(SUM(H16,I16,J16)=G40,G19="x",E19=""),0,IF(AND(E19="x",G19=""),SUM(H16,I16,J16),"Invalid selection recognized on Service included in disposable price")))
Description of requirements/features: I would like to create an Interactive pdf form which includes sums from Excel - Like a sales calculator.
Extra notes: The form would be then used on Mobile devices (offline) to perform calculations (for sales) and printed off for each client.
Description of every page/module: Not for web - for interactive acrobat form (to be used offline)
Description of every page/module: I would like to create an Interactive pdf form which includes sums from Excel - Like a sales calculator. I am able to create the form, add fields and use the basic calculations that Acrobat Pro allows. More complicated sums require translation in to javascript, this is where I need the help.
There would be between 5-15 sums, some more complicated than others - examples below
=E13*0.8
=IF(AND(OR(E16=0,E16=""),G19="x"),0,IF(AND(SUM(H16,I16,J16)=G40,G19="x",E19=""),0,IF(AND(E19="x",G19=""),SUM(H16,I16,J16),"Invalid selection recognized on Service included in disposable price")))
Description of requirements/features: I would like to create an Interactive pdf form which includes sums from Excel - Like a sales calculator.
Extra notes: The form would be then used on Mobile devices (offline) to perform calculations (for sales) and printed off for each client.
Mel N.
100% (2)Projects Completed
2
Freelancers worked with
2
Projects awarded
50%
Last project
18 Dec 2018
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
If you are still looking for one to get the job done, kindly ping me up. Thanks.
-
Hello,
Could you attach a sample of the form you are trying to build?
305962286583
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies