Auto Fillable pdf form

[mirza5313]

I am creating an auto fillable pdf form for Living Expenses. Attached is an example excel spreadsheet with the elements I require. With each of the sections, I need to be able to create a total for each expense and user can select either weekly, monthly, quarterly or annually for their living expenses?

With the total at the bottom, I need this to show a monthly amount? Is this possible? Although I know the simple calculations using Adobe Acrobat DC but don't know how to accomplish this task?

EXAMPLES

PDF that needs to be auto calculations just like the excel spreadsheet.

[gkaiseril]

Yes, it is possible. The math is no more then multiplication, division, and addition. You will need to use custom JavaScript calculations since one will have to decide how to convert the inputted values to either a monthly amount. These types of scripts are covered in many tutorials How to do (not so simple) form calculations.

[mirza5313]

Thank You so much, Actually, I have no idea regarding JavaScript so can you please give me some idea how to do that? I have not much time to do that myself?

[mirza5313]

Thanks, gkaiseril for contribution, actually I have created 5 columns but there is one issue regarding amount type if you see my attachment for excel spreadsheet there is an option to auto convert any amount to another.

So there is any way to create something like excel sheet?

A PDF file with some auto calculations but not what I am looking FILE