Matrix Compare Report

Виконано Опубліковано %project.relative_time Оплачується при отриманні
Виконано Оплачується при отриманні

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,

Введення даних Обробка даних Excel PHP Архітектура ПЗ

ID Проекту: #16947420

Про проект

10 заявок(-ки) Дистанційний проект Остання активність 5 роки(ів) тому

Доручено:

prasannjeetp

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 Більше

$30 USD за 1 день
(40 відгуків(-и))
4.5

10 фрілансерів(-и) готові виконати цю роботу у середньому за $25

maiarif98

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!

$25 USD за 1 день
(0 відгуків(и))
0.0
arainjamil

A proposal has not yet been provided

$25 USD за 1 день
(0 відгуків(и))
0.0
Satish12345k

I wii do Relevant Skills and Experience I will do

$25 USD за 1 день
(0 відгуків(и))
0.0
ninhnt

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!

$25 USD за 1 день
(0 відгуків(и))
0.0
adrmend

A proposal has not yet been provided

$23 USD за 2 дні(-в)
(0 відгуків(и))
0.0