Hi,
I have been developing software for over 20 years, and have developed several iPhone/iPad applications (you can search for "Naxomedia" on the App Store to see some of them).
What you are asking for is definitely possible, especially on the iPad. I am proposing a native application that will allow you to enter the fill in the form using the provided data, and make all the calculations. It will be able to work even if there is no network coverage.
It is your choice whether the data (what is in the second sheet) is updated within the app as well, or if you want it to be remotely synchronised with a server (this is especially useful if you maintain the data on a different system, or if you have several users of the app, to make sure everybody has the latest data).
What do you want the app to do once the form has been filled? I can have it e-mail the data to you, or store it on a server, and probably anything else you can ask (of course depending on the complexity of what you ask for, it may change the cost and time to build the app).
How many users of the app are you planning to have? This changes whether I can simply add a few devices as "developer devices" to our Apple developer account, or if you need a separate account and possibly an Enterprise account.
Let me know if you have any questions or would like to add any further details.
Jacques.