Using an Excel Data Source as lookup?

Apr 17, 2014
Reaction score
Hello All,

I am actually trying to create an Army Physical Fitness Test calculator within an InfoPath form. Not the easiest task and I am a bit stuck at the moment. Let me first explain for those willing to offer some ideas on where to go from here.
First to fill out a form I would need the age and sex of the person which I can create as a drop down list box. The hard part is getting the raw score from the three fitness events. For the first two events(push ups, sit ups) the person gets his actual score which translate into an APFT score from a chart. The third event (2 MI run) is completed in a specific time which again translates into a score from a chart. This is the part I need help with. How to go about automatically getting the APFT scores from the raw event scores.

A bit off topic from all the posts I know but I thought this may be a good place to start with hopefully some ideas to point me in the right direction. Thanks!


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question