Tamamlanmış

help me organise this excel report generated by our POS. i want it to be SQL-compatible

Hello

we are a chain of 9 restaurants.

We use "maitreD" as our main Point Of Sale System.

the CEO would like to have a report of all the discounts that occured monthly, for each venue.

I would like to organize the repport in a fashion that i would be able to feed it in a pivot table. So it has to be kinda SQL-compatible.

i need a macro that would reorganize the data.

here attached is the file : "[login to view URL]" it's the report file from our POS.

as you can see, it's a piece of nonsense. different data appears on the same column, lots a merged cells, footers and headers everywhere... it's not workable.

the tab "expected result" is an exemple of what I would like

important :

in B7 you can see the number associated to the venue (called a "succursale"). this number as to appear on each line.

the number can change. if i extract the data for several venues at the same time, the number would increment at some point downwards (it's not at the same row each time) this data is always a number only.

column I is the bill number (numero facture)

for each bill number, there are items associated that appears bellow, as well as the price of each item

"Centre de Revenu" says if the bill has been punched as take out or not, it can be "emporter", "juliette" or "golo". we exepct to have more with uber eats, foodora, etc

"montant" (amount) is a difficult beast. it's the actual money discounted on the bill. we can't repeat it more than one time per bill !

I would like to delete all lines where the price of the item is 0

then i would like to distribute the amount of the discount to the items, proportionnaly to their price.

exemple :

order #563709

has those items

(SIM) ESPRESSO LONG 2,85

SHOOTER CHOCOLAT 4,95

total : 7,8$

the total discount on the bill is 0.78$

i want this total to be distributed

so the column "montant" would show :

(SIM) ESPRESSO LONG 2,85 0,285

SHOOTER CHOCOLAT 4,95 0,495

Beceriler: Veri İşleme, Excel, Visual Basic

Daha fazlasını gör: mysql excel report, league soccer system excel report, generating excel report aspnet, get paid to make excel spreadsheets, excel jobs from home part time, freelance excel spreadsheet design, part time spreadsheet work, earn money excel projects, excel for freelancers, jobs for excel experts, microsoft excel contractors, report generated online examination, excel report aspnet, custom help system excel vba, generating excel report net, aspdotnetstorefront help import excel products, crystal report restaurant pos, openbravo pos excel report, report generated excel sheet php, excel report generation sql server

İşveren Hakkında:
( 0 değerlendirme ) MONTREAL, Canada

Proje NO: #20034616

Seçilen:

aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 60%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(103 Değerlendirme)
5.8

Bu iş için 11 freelancer ortalamada $116 teklif veriyor

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl Daha Fazla

$220 CAD in 4 gün içinde
(329 Değerlendirme)
7.9
aimefx

Hi, I am an expert in Excel, Access VBA, MySQL, Google Sheet, Google Data Studio and Power BI. I can do any type of data analysis and data visualization creating pivot tables, charts, power pivot, interactive Real Time Daha Fazla

$140 CAD in 3 gün içinde
(73 Değerlendirme)
5.9
daniyal3214

I can definitely help you with that. I am a professional Data Analyst and Excel (VBA and Macro) expert holding years of experience in Excel, Access, SQL, Tableau and Power BI. I will be happy to discuss in detail.

$250 CAD in 3 gün içinde
(49 Değerlendirme)
5.4
cyash61

Hello there, I am an analytics consultant, having more than 6 years of experience. I have worked with big MNCs across the globe and delivered more than 50 projects in the field of data analytics, data science, busines Daha Fazla

$166 CAD in 3 gün içinde
(7 Değerlendirme)
4.3
TopWritingGuru

Hi. Since functioning from 2008, I have accomplished hawk eye for the requirements, and I have all the aptitudes to produce showpiece as per your anticipations. Creating a masterpiece is an art, and I am a master in it Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% CAD
(1 Yorum)
1.2
toplinesolutions

Hi I am good in your required project, I also have a huge amount of working experience of more than 7 years. To ensure please visit my profile and check customers satisfaction level. https://www.freelancer.com/u/topli Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% CAD
(0 Değerlendirme)
0.0
$30 CAD in 3 gün içinde
(0 Değerlendirme)
0.0
AlexOSA

I'm an Excel, VBA macro and formula expert . I can do anything in Excel. Projects: "Data spiders" "parser" .. etc. Algorithms: Algorithms Litla .. etc. Statistical analysis .. etc. Data migration - google tables Daha Fazla

$111 CAD in 4 gün içinde
(0 Değerlendirme)
0.0
ChrisKostas

Hi guys, I can make your data fit your database schema in no time . Seriously ,anything you need. I'd love to hear back from you!

$100 CAD in 2 gün içinde
(0 Değerlendirme)
0.0
lexxdigital

Hello, Greetings from Lexx Digital!! We are a team of developers who have a built our own custom POS software for retail and for the Bar and restaurants. We have made it after an extensive R&D and also have seen what Daha Fazla

$140 CAD in 7 gün içinde
(0 Değerlendirme)
0.0