Sedang Disiapkan

Excel Data Formating

You are bidding on 2 excel data formatting automation spreadsheets. I think these can be done with excel macros and visual basic, but that’s beyond my skills. I have some complicated data formatting that needs to be done on csv files I download from our website. I hope to automate it so I don’t have to do so much copy and pasting. These are reformatting csv files I export from our wig sales website with volusion shopping cart, so I can upload the files back to the database. I need to format them as follows:

1st spreadsheet (see attached files [url removed, login to view], [url removed, login to view], [url removed, login to view])

I download columns productcode, catID, optionid, optiondesc (see [url removed, login to view])

Column k is just a copy of optionid with “-“ instead of “/” to fit the jpg filenames.

The rest of the columns are just html code to make some color choice charts with pictures.

I want all of these condensed into one field for each productcode (“AS_ANGELA” in sample file)

Attachment [url removed, login to view] is a sample of what I want in each product field. The <table> tag on top, and </table> tag on bottom must also be included, and the “<tr>” tag must be after every rows (column “M” in [url removed, login to view]).

So the code in [url removed, login to view] must then be placed in a column field called extinfo (see attachment [url removed, login to view]). Each product code has (10-50 options). So AS_ANGELA would be 1 row, with the “extinfo” field containing everything in 2.txt. Other productcodes would each have 1 row.

I can then upload the resulting spreadsheet back up to our web site database.

2nd Excel formatting project:

See attachment: [url removed, login to view]

This one has the column names: id,optioncatid,optionsdesc,applytoproductcodes,ArrangeOptionsBy

ID is the product option ID, optioncat is the product category, options desc is a description (usually a color number), applytoproductcodes is the product code the option is used for, and ArrangeOptionsby is the order the options for each product appear in the drop down menu on the website.

The problem is each product can have as many as 50 options, and each product has a different combination of options. With 20,000 products, there are over 400,000options which is straining our server. I need to condense it so each option applies to multiple product codes.

The applytoproductcodes field can have multiple product codes, but is limited to 255 characters. I need to reuse each ID for as many product codes such as “BJ_Amy” and “BJ_Charli” that will fit in 255 characters. For common colors such as 1 or 2, several option fields called 1 or 2, ect. will be needed. Excel will need to not go over 255 characters, and create as many options as needed to fit all the productcodes that use that color. The catID must stay the same. Some colors are rare and may only have a couple applytoproductcodes.

I will try to clarify it better if you have any questions, and I can send larger samples if needed.

Thank you!

Kemahiran: Excel, Visual Basic

Lihat lebih lanjut: txt jpg, top data, top codes, make charts, html spreadsheet code, html codes create website, csv codes, common questions, beyond menu, introduction aboutdata formating, excel pro formating, data formating, n excel, wig, sales excel, reformatting, need sales data, format excel, export data, excel visual basic, excel html, excel formatting, excel charts, excel automate, do excel

Tentang Majikan:
( 120 ulasan ) Ashland, United States

ID Projek: #341825

Dianugerahkan kepada:

best4best

I am an Excel expert, please see PMB.

$40 USD dalam sehari
(56 Ulasan)
4.9

16 pekerja bebas membida secara purata $68 untuk pekerjaan ini

MAnkita

Hello,Please refer your PMB.Thank you.

$60 USD dalam 2 hari
(76 Ulasan)
6.1
agihcam

I can help you with this. Please refer to PMB for the results.

$50 USD dalam sehari
(39 Ulasan)
5.2
pyazlm

You may check PM.

$30 USD dalam 3 hari
(32 Ulasan)
4.5
johnsinit

Dear Budgetech! I am an experienced VB and VBA programmer and would be happy to work for you. Please, check PMB.

$38 USD dalam 2 hari
(16 Ulasan)
4.2
refractocd

This can certainly be done using Excel VBA. I am ready to start IMMEDIATELY. Please refer to PM.

$40 USD dalam sehari
(14 Ulasan)
4.0
ioanaprof

Dear Mr / Ms Please have the kindness to check Project Message Board. Thanks

$50 USD dalam 3 hari
(12 Ulasan)
3.5
priyakakkar

i m interseted

$65 USD dalam 15 hari
(0 Ulasan)
0.0
xlent82

Hello, Ready to start. Please check PMB. Regards

$40 USD dalam 2 hari
(0 Ulasan)
0.0
softrixonline

Greetings, can do you task easily. Expert in writing macros in Excel. Let me know if you are interested. Can provide you sample macros of previously related projects.

$50 USD dalam 3 hari
(0 Ulasan)
0.0
carlestops

Hello I can do this

$200 USD dalam 5 hari
(0 Ulasan)
0.0
flpchair

Kindly see PM...

$100 USD dalam 2 hari
(0 Ulasan)
0.0
SeniorVBAcoder

This absolutely can be done with VBA (An Excel Macro) I have entensive experience with data manipulation and would be happy to get this done quickly and efficently...

$50 USD dalam 2 hari
(0 Ulasan)
0.0
linkonb

sir, i am very very interest of your project. please select me a bid winner.

$150 USD dalam 20 hari
(0 Ulasan)
0.0
farhankhalid

Professional Work

$60 USD dalam 3 hari
(0 Ulasan)
0.0
ExcellentSolutio

Hi, This would be an everyday routine for me, look forward to hearing from you ;). Cheers

$63 USD dalam sehari
(0 Ulasan)
0.0