Excel is probably not the best application for that calculation. You can make a database in Access for that, or if you don't like driving yourself up the wall, you can make a database in Filemaker for that. Filemaker 12 has a free ios app to let you run and access databases from iphones and ipads.