Here a sample video of cost trend analysis where row for August 2016 details would be added manually to data entry blue colored table in row #9.
Columns like month, name, assembly, date, materials, printing and shipping and few columns calculated automatically without any Excel formulas in next green colored table.
This green colored table shall be refreshed and calculation done automatically and new columns shall be updated like production, shipping and package columns.
The month of August 2016 updated in the row #23, also year and month added by automation.
You may see how samples cost trend calculated automatically without human intervenes and error free.
Leave A Comment