Lengkap

MS Excel BOMScreener

Hello!

I will provide two excel sheets: Main\_BOM and Modified\_BOM. Need an .exe file that will compare two excel files and generate a third excel ([url removed, login to view]), showing the difference between them.

There will be about 10-15 columns of data.

The screener should do the following stems:

1. Read the first **MFG Part #** field from the Modified_BOM, say "XXX"

2. Search all the fields of Main_BOM for "XXX"

3. Once you find it, compare every other field (Item, Quantity, Reference,....etc.,) of that line item, between Main\_BOM and Modified\_BOM.

4. If all the fields match, do nothing

5. If there are field mismatches, print log in the third excel. For example, if the quantity is reduced from 10 to 5, print as" Field: Quantity, Main\_BOM: 10, Modified\_BOM:5" in a new excel sheet, Diff_BOM.

6. If you don't find "XXX" in the Main\_BOM, print "Newly added item: XXX" in Diff\_BOM

7. Repeat steps 1-7 for all other line items.

8. I also want to find the list of items removed from the Main\_BOM. Read every MFG Part# from Main\_BOM, and check if they are present in Modified\_BOM. If you find them missing, say "YYY", print "Removed item: YYY" in Diff\_BOM.

Other Notes:

The first step is to make sure that all the column names match between the two excels. if there is no match, it should report as "Column Mismatch".

The MFG Part # field is the main field, and all other fields are compared based on this part.

Provide option to manually ignore a column. For example, we might not want to consider "Item" field.

Please provide the no of hours, hourly rate and the estimated time of completion.

Thanks,

G

Kemahiran: Pentadbiran Pangkalan Data, Kajian Pasaran, MySQL, SQL

Lihat lagi: mfg mfg, excel hourly rate, new excel, ms-excel, ms excel, mfg/, excel to sql, mysql read files, excel file mysql, check data excel files, excel compare list columns, need match files excel, please check log files, excel compare columns data, missing columns data, excel modified, Excel Time sheet, excel compare names, excel print sheet, check excel files

Tentang Majikan:
( 2 ulasan ) Chennai, India

ID Projek: #2670808

Dianugerahkan kepada:

shikhamehta

See private message.

$59 USD dalam 14 hari
(166 Ulasan)
6.0

13 pekerja bebas membida secara purata $49 untuk pekerjaan ini

mabozaidvw

See private message.

$76.5 USD dalam 14 hari
(10 Ulasan)
3.5
gentechsolution

See private message.

$25.5 USD dalam 14 hari
(13 Ulasan)
3.3
gyk

See private message.

$55.25 USD dalam 14 hari
(2 Ulasan)
3.2
oggimbix

See private message.

$50 USD dalam 14 hari
(3 Ulasan)
3.0
shaarawi

See private message.

$85 USD dalam 14 hari
(4 Ulasan)
2.8
wprosolutions

See private message.

$50.15 USD dalam 14 hari
(2 Ulasan)
2.8
chiru79850

See private message.

$51 USD dalam 14 hari
(2 Ulasan)
1.9
ralphmatthew

See private message.

$85 USD dalam 14 hari
(0 Ulasan)
0.0
mihairapciuc

See private message.

$40.8 USD dalam 14 hari
(0 Ulasan)
0.0
pankajchohan

See private message.

$20.4 USD dalam 14 hari
(0 Ulasan)
0.0
ashiva1976

See private message.

$30.6 USD dalam 14 hari
(0 Ulasan)
1.5
hexlasvw

See private message.

$3 USD dalam 14 hari
(0 Ulasan)
0.0