Or 5 ... or 6 ... or maybe
One of my co-workers has spent a LOT of time creating a spreadsheet to guide homeowners and small contractors through the process of figuring out what size pipe or tube they need to use for a gas line, based on the number of appliances, the Btu/H ratings, and the length of the pipe or tube from the gas meter or tank to the appliance(s). It involves some formulas, which he has put in protected cells -- the only cells left unlocked are the cells into which the project-specific variables are entered.
As a spreadsheet, it works as intended. The issue he has asked for help with is that we need it converted to a fillable, interactive PDF. He has converted it to a PDF from Excel, then he used Adobe Acrobat Professional to go in and clean up a few things. What we have now is a PDF that
looks like an interactive, fillable PDF ... but it doesn't work. In either Adobe Reader or Acrobat, the data entry forms allow putting the cursor in the field, but won't accept any input. When I opened the form at home using a PDF reader/editor from another source, I was able to enter numbers in the data entry fields, but none of the calculations were performed.
I'm not even certain a PDF can run calculations. Does anyone know? If it can, does anyone have any suggestions of how we can get this thing functioning? This guy has expended a LOT of time on this, and he's really bummed out that after all his effort, it's dead in the water.