Not sure if you have seen the work i have done in automating form import and excel files but it may be a workable idea for your system.

It imports to excel 2007-2010 and does all the calcs for you.

Take a look at the link for excel 2007-2010 below, the other file has some issues in getting earlier versions of office to work with the formulas i have created.

__________________
One Drive

"If the corporates are treating you poorly , just go elsewhere."
"If they need you , they will soon find out."
"If you need them , you will soon find out." --moeee
_______________________________________________