I just got a request to convert an Excel file to PDF, and make the form calculate. The calculations are pretty complex (at least to me they are). There are four different types of formulas needed. I've copied the information below. Can someone help me with writing the scripts for PDF that would accomplish what the Excel formulas do? I don't even know if it's possible to do and where to start.
|If there is a tag number entered for the corresponding row, the equation will take the date cast and add the number of days until it's break, and give the date of the break. If no tag number (or any form of ID)|
is entered into the tag number cell, a blank cell will be shown.
|Correction Factor (C.F.):|
|=IF(N20>0,LOOKUP('Correction Factor'!A3,'Correction Factor'!$C$3:$C$104,'Correction Factor'!$D$3:$D$104)," ")|
|If there is a number entered in the corresponding Total Load cell, the equation will look up the correction factor value from the list in the correction factor tab based on the length and diameter ratio calculated in column A in the Correction Factor Tab, and give the proper correction factor. If no total load value is given, a blank cell will be shown.|
|If there is a number entered in the corresponding Total Load cell, the equation will solve (total load) / (pi * (diameter / 2)^2) to get PSI, and then multiply by the corresponding Correction factor to give it the appropriate PSI value. The round function then rounds it to the nearest 10 value. If no total load value is given, a blank cell will be shown.|
|If there is a number entered in the corresponding Total Load cell, the equation will average the values of the 2 breaks for the cylinders cast for that day and round to the nearest 10 value. If no load value is given, a blank cell will be shown.|
You might want to start with the tutorials at the http://acrobatusers.com/tutorials