Matrix Compare Report
$10-30 USD
Оплачується при отриманні
Ok, let me explain..
In the sheet last tab (Local stockfile) has all the items (SKUs) they sell and cost and Retail prices.
Column A and B shows their departments and fine lines respectively.
3 rd tab (Trade01-06 Matrix extract) tab is the download of pricing discount structure. If you filter
column A you can see 6 types of Matrix IDs.
For example of if you just filter by column A by TRADE01.
First from row 4 to 21 shows department discount structure
From row 22 to row 50 shows Fineline discount structure
Row 2 and 3 applies for all the items (skus).
2 nd tab (SKU check) is the ideal report im after. Basically when you enter Item (SKU) numer in cell A3
it shows all the discount structures, Column C to column P returns corresponding data from tab 2
(TRADE 01-06 Matrix extract). Sorry order in my sketch report tab (SKU Check) is not the same,,but
im basically after the same information.
Ignore columns from Q to Y in SKU check tab. This is to determine calculate best price depend on the
price basis, I can design this part.
If you can help me out to design what im after that would be great.
Let me know if you have any questiions.
---
cell I4 (best price) & J4 (GP%) is the best sell rate (column X) depending how many combination of matrices that item (SKu) has..Column Q to W you dont need to worry,
ID Проекту: #16947420
Про проект
Доручено:
Hi, I have seen your proposal. I am an excel expert with very good knowledge of formula and VBA. I can make this Matrix Compare Report for you. Please come on chat for more details. Awaiting your response. Thank you Більше
10 фрілансерів(-и) готові виконати цю роботу у середньому за $25
I am a highly trained in Data Entry, Research, Web search, Web scrape, great knowledge of Excel and all Social Networks. My bid is optional and I will let you chose the price that suits you best!
Dear Mrs/Mss, I'm working with BI-matrix report everyday and good at VBA , i would like to chat over to know detail what you expect the result, i can give the expected result as well as you want. Thank you!