?
Solved

How do I add formula to attached Adobe Acrobat document?

Posted on 2011-09-14
4
Medium Priority
?
388 Views
Last Modified: 2012-05-12
I would like to know if it is possible to add a formula to the attached file.
I want to be able to type in the actual load measured in the actual load column and the load variation % would be calculated. Please help.

Thanks in advance.
KM
1360---1361-JAR-TESTER-CALIBRATI.pdf
0
Comment
Question by:mcginniskj
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 31

Expert Comment

by:captain
ID: 36535045
Hi

I am not a java script developer, but as this is a division you need JS to avoid dividing by zero. Have a look at this:
http://forums.adobe.com/thread/825757?decorator=print&displayFullThread=true

I assume that you want to divide the actual load by the console pressure or the difference of the actual load and console pressure by the console pressure. Either way you need to tell Acrobat about the console pressure so it can be used for calculation. For that you should put all console pressure variables into fields and make these 'Read only'. That way they cannot be edited but you can reference these for your calculation. At the moment Acrobat has these only as background text which you cannot use in a calculation.

Once you have got your formula right you then need to change the format to 'Percentage' and you should be done.

I would also recommend simplifying your field names as they are complex and you may end up with errors because of typos when you change your script. If you need to calculate the difference between console pressure  and actual load and then use the result as a dividend then you may find it easier using a field to calculate that difference first (fieldname1-fieldname2, for examle console1-actual1) and set the attribute to 'Hidden' so it is not visible but can be used for calculation.

The difference calculation formula goes into the simple annotation option.

hth
capt.
0
 

Author Comment

by:mcginniskj
ID: 36535354
I need the difference of the console pressure and actual load divided by the actual load and this would give the load variance %. Do I need to add another column to show the load variance?
0
 
LVL 31

Accepted Solution

by:
captain earned 2000 total points
ID: 36536102
That's what I meant with adding a filed for each variance and making this hidden.

The field should contain the formula for calculating the difference (console1-actual1) and be named for instance variance1.

You will then reference the fields variance1 & actual1 in the script provided in the link.

hth
capt.
0
 

Author Closing Comment

by:mcginniskj
ID: 36591310
Thank you
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In a previous article published here at Experts Exchange, Signature Image with Transparent Background (http://www.experts-exchange.com/Web_Development/Document_Imaging/A_12380-Signature-Image-with-Transparent-Background.html), I explained how to cre…
This article shows how to convert a multi-page PDF file into multiple image files, with one image file created for each page of the PDF. It does this by utilizing an excellent, free software package called GraphicsMagick. The solution is amazingly s…
This video is the second in a two-part series that discusses PaperPort's "Send To Bar" feature . The first video tutorial (http://www.experts-exchange.com/VP_207.html) explains the purpose of the Send To Bar, how to use it, and how to hide unwanted …
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…
Suggested Courses
Course of the Month12 days, 4 hours left to enroll

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question