Đã hoàn thành

Excel Expert - Format/Import Text List Into Excel File

I have a text file ([url removed, login to view] , attached) with information for a large ballot (Meta-Categories, Categories, Sub-Categories, Ballot Items). I have cleaned it up, in terms of making sure things were in the right places, spelled correctly, etc. I have added *** to the beginning of any meta-categories, to make them easier to find. Categories are separated by a row of dashed lines. Sub-Categories (the islands) are a little trickier. There are 3 islands, but not every category has items for each island. Also, some ballot items have the name of an island within their name (although the sub-categories/islands are on lines by themselves).

I need someone to take this information and put it into an Excel spreadsheet, then assign ballot codes to each ballot item (more on this in the next paragraph). Each category needs to have a ballot item, called "Write In", as its' last ballot item. I have attached a file called [url removed, login to view], showing how I want the spreadsheet formatted. Each row of the spreadsheet needs to have all information for its' corresponding ballot item (Meta-Category, Category, Sub-Category, Ballot Item, Ballot Code).

Ballot codes are determined by applying the following rules:

1st digit represents the island (1 = St Thomas; 2 = St John; 3 = St Croix)

2nd, 3rd & 4th digits represent the category number

5th & 6th digits represent ballot item number within the category

So, if a ballot item were in the 347th category, on the island of St John, and it were the 12th ballot item within the category, its' ballot code would be 234712.

I am certain there is a way to easily complete this task using a script or macro, but that is beyond my skill level in using Excel.

Kĩ năng: Nhập liệu, Xử lí dữ liệu, Excel

Xem nhiều hơn: import text list excel, excel list expert, expert import, format list excel, expert format excel, expert format, skill categories, make data entry easier, how to expert in excel, how to be an expert on excel, how to be an expert in excel, how to be an excel expert, find an excel expert, file excel expert, excel macro how to, excel expert up, skill list, how to find an expert, how to be expert in excel, xlsx, thomas, thomas i, skill level, need a excel expert, name format

Về Bên Thuê:
( 21 nhận xét ) Geneva, United States

ID dự án: #1697180

Được trao cho:


I am interested in your project.

$30 USD trong 1 ngày
(28 Đánh Giá)

29 freelancer đang chào giá trung bình $122 cho công việc này


We have done similar project, Pls Check PM

$35 USD trong 1 ngày
(206 Nhận xét)

Hello, Excel VBA expert here. Please check PM for details. Thanks!

$50 USD trong 1 ngày
(59 Nhận xét)

I think the process can be automated, but i have some questions. I am not sure that i understand the project completely.

$50 USD trong 0 ngày
(26 Nhận xét)

Such jobs are my daily practice. I can complete the job within some hours if it's that urgent. Further use of macros (if it's a repetitive job), fixing of bugs and minor changes are included in the bid without any addi Thêm

$60 USD trong 1 ngày
(39 Nhận xét)

It will be done within the same day after we officially start. Parsing various data structures is one of our core strengths.

$120 USD trong 0 ngày
(21 Nhận xét)

Hi, No problem at all. Please check Feedback and don't close this in the next hour or so . I'll get back to you. Regards David

$45 USD trong 0 ngày
(23 Nhận xét)

Dear Sir, We are ready to start and fulfill your requirement. Please check your inbox for details. Regards Rajaa

$50 USD trong 1 ngày
(19 Nhận xét)

******* DONE ************ Please check PM...

$30 USD trong 1 ngày
(20 Nhận xét)

Hi, I am very interested in your project. Kindly check PM. Many thanks.

$30 USD trong 1 ngày
(12 Nhận xét)

Script created.

$30 USD trong 0 ngày
(6 Nhận xét)

Hi, please read PMB for my further detail. Thanks.

$30 USD trong 1 ngày
(2 Nhận xét)

I 'm new freelancer, but with regard to excel, I think really capable to do this job.

$50 USD trong 1 ngày
(0 Nhận xét)

Expert in excel ready to automate your project. Additional details sent via PM.

$50 USD trong 1 ngày
(0 Nhận xét)

more details

$1250 USD trong 10 ngày
(0 Nhận xét)

To Project Manager I am writing to you because I believe my training, experience, and proven ability as & Data Analyst/Entry will allow me to significantly contribute to your company. you will note that I have acqu Thêm

$80 USD trong 1 ngày
(0 Nhận xét)

Dear Sir, I ensure that I will do this job in time with efficiency.

$30 USD trong 4 ngày
(0 Nhận xét)

I will try my best to work according to your requirments

$250 USD trong 5 ngày
(0 Nhận xét)

Hi I have number of years experience to develop excel based macro for data analysis. Recently i have developed a large macro for Transport For London using Excel, VB to support their on going data anlaysis ( Cost 7 Thêm

$75 USD trong 2 ngày
(0 Nhận xét)

Hi, I'm interested in the job and would love to know all details about it. Please let me know, i'm ready to work! Regards, lukman

$100 USD trong 1 ngày
(0 Nhận xét)

Dear Hiring Employer, I have read the entire job description and I am interested with the task.

$150 USD trong 3 ngày
(0 Nhận xét)