Đang Thực Hiện

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 thêm: import text list excel, excel list expert, expert import, format list excel, expert format excel, expert format, skill categories, make data entry easier, find excel expert, file excel expert, skill list, xlsx, thomas, thomas i, skill level, name format, meta expert, macro excel, list making, text processing, macro script file, excel categories, excel digit, write macro, excel macro txt

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

Mã Dự Án: #1697180

Đã trao cho:

pishty

I am interested in your project.

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

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

Kamalkishover

We have done similar project, Pls Check PM

$35 USD trong 1 ngày
(206 Đánh Giá)
6.5
bharanisrihari

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

$50 USD trong 1 ngày
(59 Đánh Giá)
6.3
greggfletcher

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 Giá)
5.8
nagybatonyi

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 Giá)
5.4
Krusche

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 Giá)
5.1
MDavidCrompton

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 Giá)
4.9
nagendraraja

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 Giá)
4.5
microk

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

$30 USD trong 1 ngày
(20 Đánh Giá)
4.1
mjxone

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

$30 USD trong 1 ngày
(12 Đánh Giá)
3.7
quatroo

Script created.

$30 USD trong 0 ngày
(6 Đánh Giá)
3.1
duchuyctlk

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

$30 USD trong 1 ngày
(2 Đánh Giá)
0.6
fjhunick

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 Giá)
0.0
MSExcelGuru

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

$50 USD trong 1 ngày
(0 Đánh Giá)
0.0
bpojobs909

more details

$1250 USD trong 10 ngày
(0 Đánh Giá)
0.0
saumil123in

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 Giá)
0.0
anjonbappy

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

$30 USD trong 4 ngày
(0 Đánh Giá)
0.0
vital247

I will try my best to work according to your requirments

$250 USD trong 5 ngày
(0 Đánh Giá)
0.0
SummonLancer

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 Giá)
0.0
lookm4an

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 Giá)
0.0
anyabatara

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 Giá)
0.0