GetAFreelancer.com
 
Find projectsSearch
Sign Up | Log in | Top Rated Users | Browse projects | Post Project | RSS feeds | Articles
 

Data Conversion in Excel

   Click here to post similar project

Data Conversion in Excel is project number 245300 posted at GetAFreelancer.com. Click here to post your own project.

Closed
(Selected Service Provider cheungkc)
Status: Closed
Budget: $30-250
Created: 04/03/2008 at 6:50 EDT
Bidding Ends: 04/10/2008 at 6:50 EDT
Project Creator: itstrdept View PM Post PM
Buyer Rating: 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(1 reviews)
Description: We need to reconstruct large amount of data in Excel. We have about 60 files with 20 tabs each. From each tab we need to make one entry in the output Excel sheet, i.e. we need to make a sheet with about 1200 rows at the end. The information for the columns is scattered within each tab. Although it is not always in a fixed cell for every tab, there are pointers that say where the needed info is.

Attached are 1) a file with a sample tab with data (Note: other tabs appear in similar, but not always the same structure); 2) the output table
Additional files submitted:
Output Table Layout.xls
Sample record- input.xls
Report violation
Job Type:
  • .NET
  • Data Entry
  • Data Processing
  • Excel
  • Visual Basic
Database: (None)
Operating system: MS Windows
Bid count: 78
Average bid: $ 100

 

Related project
 
Nonpublic project #289573 Featured Nonpublic
login to view
 

FREE Trial project for new buyers!

 

View Project Message Board     Post Message on Project Message Board
Messages Posted: 4

If you are the project creator or one of the bidders Log in as project creator or bidder for more options

Bid on This Project

Service Providers PMB Bid Delivery Within Time of Bid Provider Rating
devaka
View PM Post PM
$ 150 7 days 04-03-2008 07:21 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(53 reviews)
I can help you with this excell project
diy286
View PM Post PM
$ 120 2 days 04-03-2008 12:31 9.90/109.90/109.90/109.90/109.90/109.90/109.90/109.90/109.90/109.90/10
(42 reviews)
Dear sir, I am very interested in your project, Please see PMB for more details. Thanks. Best Regards.
JordanEnt
View PM Post PM
$ 100 10 days 04-04-2008 00:08 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(35 reviews)
Hello, We can do this with ease. We assure you of 100% accuracy. Regards, George.
zigmatech
View PM Post PM
$ 150 10 days 04-03-2008 09:38 9.93/109.93/109.93/109.93/109.93/109.93/109.93/109.93/109.93/109.93/10
(30 reviews)
Hi Thanks for the nice project.We have done many EXCEL projects.Let's talk in PMB for our detailes. Thanks & Regards Asg for ZIGMATECH Systems ITeS Division.
denisCh
View PM Post PM
$ 120 3 days 04-03-2008 08:31 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(26 reviews)
Ready to start now
brohhma
View PM Post PM
$ 250 3 days 04-03-2008 07:06 9.74/109.74/109.74/109.74/109.74/109.74/109.74/109.74/109.74/109.74/10
(23 reviews)
hi......we have a complete set up for this! can do it without error!
dataconsultants
View PM Post PM
$ 120 2 days 04-03-2008 07:18 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(20 reviews)
Please check PMB for details, Thank you
svet63
View PM Post PM
$ 90 3 days 04-03-2008 14:45 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(13 reviews)
VBA developer since 1997. Will automate it using VBA. Can do. Regards, Svet.
AmitKumarCal
View PM Post PM
$ 100 2 days 04-03-2008 07:21 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(10 reviews)
Hi Check PM
amarendar
View PM Post PM
$ 30 3 days 04-03-2008 07:05 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(8 reviews)
HI. Please check pmb
johnsinit
View PM Post PM
$ 48 3 days 04-03-2008 09:50 9.88/109.88/109.88/109.88/109.88/109.88/109.88/109.88/109.88/109.88/10
(8 reviews)
Dear RSM Strategy! I am an experienced VB and VBA programmer and would be happy to work for you. Please, check PMB. Sincerely yours, John.
iasmumbai
View PM Post PM
$ 40 3 days 04-03-2008 11:45 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(7 reviews)
Please check PMB for further details. Thanks
dearpravin
View PM Post PM
$ 247.8 12 days 04-03-2008 13:58 9.86/109.86/109.86/109.86/109.86/109.86/109.86/109.86/109.86/109.86/10
(7 reviews)
please check PM
pacejob
View PM Post PM
$ 100 2 days 04-03-2008 13:09 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(5 reviews)
hello, I'm professional in data scraping, extraction, transformation and loading. thank you, pacejob
VLADNOVA
View PM Post PM
$ 190 15 days 04-03-2008 17:02 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(5 reviews)
Sir/Madam: This is very serious and responsible project.I am interested in and case my bid won I'm going to make everything for satisfying result. Vlad
trans3
View PM Post PM
$ 100 3 days 04-03-2008 09:53 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(4 reviews)
Please check PM.
hmt141001
View PM Post PM
$ 100 7 days 04-05-2008 07:19 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(4 reviews)
Please CHECK PMB
cheungkc
View PM Post PM
$ 30 3 days 04-03-2008 18:29 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(4 reviews)
This will be a simple looping of files and sheets, using match and index functions.
gliip1
View PM Post PM
$ 125 20 days 04-04-2008 06:36 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(3 reviews)
Hello, please check your PMB. Regards
Kalpataru123
View PM Post PM
$ 50 7 days 04-04-2008 02:39 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(2 reviews)
dear Sir, i am very interested in this project detail of the bid amount and delevery date should finalised after known the project details so please waiting for further proceed
dominichan
View PM Post PM
$ 30 3 days 04-03-2008 20:50 9.50/109.50/109.50/109.50/109.50/109.50/109.50/109.50/109.50/109.50/10
(2 reviews)
No problem. i will use visual basic and using array to transfer those data as you required.
antilles
View PM Post PM
$ 200 3 days 04-03-2008 11:11 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(1 reviews)
This looks simple enough considering accounting and Excel background
katsonis
View PM Post PM
$ 100 3 days 04-03-2008 19:58 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(1 reviews)
Sir, I have a long experience in automating Excel for various tasks. I can complete the project with accuracy and have the results checked before submitting them.
frozendreamzz
View PM Post PM
$ 100 1 day 04-05-2008 05:16 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(1 reviews)
Can help you with this... All we would need is the location where the files are stored (Or let us know if you'd like to input that yourselves for your comfort). Also, I think that the output file you've provided is the illustration of what you want. I guess you'd want the actual data from the 60 files and not the text "Cell to the right of "Trade reg. nbr:" etc. that you've mentioned. So I think that the pointer would be in the input files? Please revert with more details if interested and i'll get it done for you. Thanks.
rajanlengde
View PM Post PM
$ 50 2 days 04-03-2008 15:12 9.35/109.35/109.35/109.35/109.35/109.35/109.35/109.35/109.35/109.35/10
(20 reviews)
I can do it , please see PMB
samrashu
View PM Post PM
$ 120 3 days 04-04-2008 01:35 6.50/106.50/106.50/106.50/106.50/106.50/106.50/106.50/106.50/106.50/10
(2 reviews)
Dear Sir, We are the company involved in data entry/data conversion since last 9 years. We have strength of 30-40 employees with us. We are submitting our rates on a per file basis. Period of the completion of the project can be reduced as per your requirement. Thanking you and assuring you our best services always. Sameer
ohmykay1
View PM Post PM
$ 30 3 days 04-03-2008 07:30 (No Feedback Yet)
Dear Sir or Madam, i am so interested in this project, and ready to work with u.
amanr
View PM Post PM
$ 150 3 days 04-03-2008 07:41 (No Feedback Yet)
I saw this posting while looking for freelance work, and find myself capable enough for this work. I have 3 years of working experience and have done a Couple of Admin Projects as well.Possess a good knowledge of computers and earlier worked with Microsoft Word and Excel. If everything suits you, you can further via e mail or refer to PMB
sathyaaac
View PM Post PM
$ 30 7 days 04-03-2008 07:56 (No Feedback Yet)
i can do this job for you!
ugs
View PM Post PM
$ 150 15 days 04-03-2008 08:14 (No Feedback Yet)
Need some more info.
carlestops
View PM Post PM
$ 250 12 days 04-03-2008 08:20 (No Feedback Yet)
By the looks of it... I can do this... I'll sample within days from now..
bmbutt143
View PM Post PM
$ 100 8 days 04-03-2008 08:47 (No Feedback Yet)
I can do this project with in my given time frame with no errors.
investOmatics
View PM Post PM
$ 250 3 days 04-03-2008 11:23 (No Feedback Yet)
I can write an Excel macro for you that will open every workbook in a given directory, find the eight pieces of data you have described (Name, ID, and both Liquid Assets and Receiveables as of 12/31/06, 12/31/05, and 12/31/04) in each tab of each workbook, and write those eight data fields to a separate row of a new spreadsheet. I would ask you to send me a couple of complete workbooks so that I can ensure that my macro correctly handles your actual data -- or, you could send me all of the workbooks and I will produce the full output file for you. Can I assume that all the workbooks to be processed will all reside in the same directory? Thanks for your consideration! -- Joe
unandhini
View PM Post PM
$ 75 2 days 04-03-2008 12:25 (No Feedback Yet)
Let us start immediately. Check PM. Thanks
roomana
View PM Post PM
$ 30 2 days 04-03-2008 12:48 (No Feedback Yet)
I can do this plz try me
shahbazali23
View PM Post PM
$ 100 2 days 04-03-2008 13:18 (No Feedback Yet)
I can this frequently.
Ishqh
View PM Post PM
$ 50 1 day 04-03-2008 14:36 (No Feedback Yet)
Please check your PM. Thanks...
maniloucorpuz
View PM Post PM
$ 250 15 days 04-03-2008 15:24 (No Feedback Yet)
Sir/Madam: I am interested in this project.
discus86
View PM Post PM
$ 60 4 days 04-03-2008 15:29 (No Feedback Yet)
I will do this job for you. Please give me a chance to make you smile.
sqlbuilder
View PM Post PM
$ 200 10 days 04-03-2008 15:34 (No Feedback Yet)
Boss i will complete this project in the given timeline.....
JeevendraR
View PM Post PM
$ 250 7 days 04-03-2008 16:12 (No Feedback Yet)
Hi! I am Jeevendra from Sri Lanka. I have sent you a PM with the necessary details. Thanks & best regards
meparashar
View PM Post PM
$ 30 2 days 04-03-2008 16:42 (No Feedback Yet)
Hello, I've read the description of the project and can finish this project very easily. I'm an experienced coder and have been working on freelancing site www.RentACoder.com for about a year. I'm new to this site, and this project will let me earn some extra bucks. Please give me this project, I'll work till you're satisfied. Thanks, Rahul Parashar My rentACoder profile: http://www.rentacoder.com/RentACoder/SoftwareCoders/showBioInfo.asp?lngAuthorId=6520311
kdw88
View PM Post PM
$ 100