Automate a spreadsheet financial consolidation using Caspio or Quickbase

Project includes approximately 5 data intake sheets/forms with up 50 10 data validations (empty values, values outside of a range), followed by 2-5 transformations (currency conversion from a table in the same system, resolution of intersystem transactions), followed by 10 or so calculations of ratios, differences, averages. On top of that is 5-10 data very simple reports/visualizations. Please assess the visualizations separately.