Inserting an Excel formula in Acrobat, possible?

[dcescott]

I understand the data merge, sorta...
I have an assignment coming, one of my managers wants a pdf form made up with a fixed excel formula to help his team in sales. I am on a mac, running CS3. I am not as skilled in Acrobat, so I am asking the experts here. Thanks guys!
Daniel

[The Repro Kid]

I've seen something similar to this at my last gig. I think it used the excel chart placed in html in the company intranet. Then if you clicked on the chart in a web browser it would open the excel chart and you could type in it to run formulas. I think someone there wanted me to set up the same thing with acrobat but we weren't successful.

It was over a year ago so I'm not remembering too clearly what we were doing.

It may have been that I was able to set it up and get it to work for me. Because I had Acrobat Pro, but it wouldn't work for the sales people because all they had was Adobe Reader.

[Lukas Engqvist]

Acrobat forms have a "basic" for simple summs, medians, avereage etc.
If you have a complex formula then you go JAVA…*don't know enough java to give you good advice, and you didn't show us if the problem with the formula lies in the complexity or that it is dependant on relative position in a complex table, but should be do-able.
(JAVA, like coffee can keep you awake into the small hours :p)

[dcescott]

Yeah well my manager just spoke about it to my wheels turning, and I have no earthly idea what's in store for me. All I have to say is JAVA might be the best method, but not on our intranet. I have limited web knowledge which means it goes to the eBusiness sect of the company, woo hoo!:D
I figured it could happen since it's a fixed formula and I add excel data to Indesign a lot exporting via pdf for sales. Cheers guys! I get to pass the buck!
Daniel

[jackgopher]

I once tried using an Excel formula (the countif) in Acrobat, but it totally didn't work. I think you should stick to the simple Sum, Average etc.



_________
Excel Formulas (http://www.free-training-tutorial.com/formulas.html)