Went through the Excel spheet - Customer Review, Range review sales out and Shipping data.
Based on the data entered, the Quarter consolidation QoQ and YoY consolidation for particular product type and for a partner can be summariesed into Customer overivew, using click of button.
- Thereby the margins, Salesout Allowance, MDF, Profit can be calculated.
- Separate buttons to generate the reports YoY, WoW, Vendor Vs Vendor can be generated.
- Regarding how to segerate the partners can decide, but from the first look vendor vs vendor comparison can be easier if all in one worksheet.
- Have done similar sales, inventory, tax calculations, product wise comparison in Freelancer projects.
My Skills:
- Have expertise in Excel automation, macros, formulas, calculations, summarising and Graphs.
- Extensively the macros/VBA to automate:
- Data camparision using formulas, lookups and summaries.,
- Data validation in a particular, Data consolidation into sheets, comparing, plugging in default values for few cells
- Data camparision using formulas, lookups and bringing up summaries.,
Sample HighComplex Projects using Macros:(via Freelancer)
- Heating Wire Design, Canada, - Identify the wiremodel running through multiple iterations.
- System log generation (users logged in time, duration, days) between time period based on the text log files. Generate report.
- Employee Tax, Canada - Calculations per hours,wage,provincial deductions, Federal deductions per reference tables.