Find Jobs
Hire Freelancers

Write a VBA code to convert excel file into a standardized format (EDI or Excel)?

$30-250 USD

Imefungwa
Imechapishwa over 5 years ago

$30-250 USD

Kulipwa wakati wa kufikishwa
I work in the container shipping industry. Currently we are receiving Terminal Departure Reports (TDRs) from terminals all over the world after a port of call. My company is adopting a global standard format known as the TPFREP, where it can be uploaded into our systems either in EDI or excel format. However, not all terminals in the world today are able to produce the TDRs in the TPFREP format, hence a number of locations worldwide are still sending their TDRs in their own formats. The task is to be able to write a VBA code to convert the TDRs from those terminals not able to support TPFREP, into the standardized TPFREP template (either in excel or EDI formats). To do this, the macro must be generic enough to read a variety of formats from the terminals, pick up the right information to populate the TPFREP template so that it can be uploaded.
Kitambulisho cha mradi: 17783396

Kuhusu mradi

32 mapendekezo
Mradi wa mbali
Inatumika 5 yrs ago

Unatafuta kupata pesa?

Faida za kutoa zabuni kwenye Freelancer

Weka bajeti yako na muda uliopangwa
Pata malipo kwa kazi yako
Eleza pendekezo lako
Ni bure kujiandikisha na kutoa zabuni kwa kazi
32 wafanyakazi huru wana zabuni kwa wastani $219 USD kwa kazi hii
Picha ya Mtumiaji
Hello, Hope you are doing well. I can help with your project Write a VBA code to convert excel file into a standardized format (EDI or Excel). I can assure you the quality job. I have good experience in Excel, Visual Basic. We have worked on several similar projects before! Please have a look at my portfolio below: https://www.freelancer.com/u/schoudhary1553 We have worked on 400+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
$250 USD ndani ya siku 4
5.0 (290 hakiki)
7.7
7.7
Picha ya Mtumiaji
Dear Employer, I understand your need of writing VBA code on Excel but I need to discuss few things, please message me so that we can discuss in detail. Thanks and Regards, Ash
$250 USD ndani ya siku 7
5.0 (145 hakiki)
7.2
7.2
Picha ya Mtumiaji
Hi, I am an Excel macro expert and would be happy to take on your project. Kindly provide sample TDR format files and the expected TPFREP format Excel file. Regards, Arul
$200 USD ndani ya siku 3
5.0 (201 hakiki)
7.4
7.4
Picha ya Mtumiaji
Dear client I understand the scope of work involved in the project. I can write the macro code for you which will solve the purpose you mentioned. Please share sample files to understand the nature of the data. Roy
$200 USD ndani ya siku 3
4.9 (283 hakiki)
6.6
6.6
Picha ya Mtumiaji
Hello, I am ready to discuss project with you. Being experienced in working on excel using VBA/macro and completed several tasks of generating required excel format from given input, based on it I can help you with solution quickly and efficiently. I am available to discuss now for further discussion. Looking forward to have further project discussion on chat. Thanks. Vimal Arora
$61 USD ndani ya siku 2
4.8 (92 hakiki)
5.8
5.8
Picha ya Mtumiaji
PhD in computer science having seven years of experience in Excel development and visual basics
$200 USD ndani ya siku 1
4.7 (53 hakiki)
6.0
6.0
Picha ya Mtumiaji
I can write a macro to do the necessary format conversions in Excel. I have even worked with EDI format before. https://www.freelancer.com/projects/php/Write-code-convert-the-Excel/?w=f I have excellent command on MS Excel. I have completed complex projects in Excel before . For instance - Built a delivery schedule for pick-up and drop of raw-material under given constraints optimizing the utilization of available resources - Get match details, odds and stats of tennis matches and place bet automatically on betfair (API), pinnacle (API) and tennisinsight (scraping) websites - Buy and sell bitcoins on Coinfloor and GDAX using respective APIs - Built a POS and inventory management system - Built a hotel price comparison that pulls data using the website's API You can see the reviews of the same in my profile Thanks, Archana
$100 USD ndani ya siku 2
4.9 (78 hakiki)
5.8
5.8
Picha ya Mtumiaji
Hi, I am very confident on handling this writing of generic macro using VBA to convert various terminal formats to standard format. If possible, please share the variation of the formats to understand the degree of deviation. Just to introduce myself, I have done good amount of work in VBA. It includes, extracting information from text files, transferring info in to excel, E-commerce templates, sending email through Outlook, Image handling, Shapes variation, Pivot Tables, Data Scrapping from websites, data extraction for multiple Excel sheets and consolidating in a central sheet.etc. I would be happy to answer any queries that you may have. Looking forward to hearing from you. Thanks & Regards FineCoder
$200 USD ndani ya siku 10
4.9 (66 hakiki)
5.5
5.5
Picha ya Mtumiaji
Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I can arrange data into various formats. I have excellent knowledge and experience of Manipulating Data of Multiple Sheets, Using Advanced Formulas, Critical Programming, Developing System for Management and Creating Reports. I have done mostly Excel VBA Programming job. Please check my portfolio to see my work – https://www.freelancer.com/u/vsprybhanu.html?page=portfolio So, I can do this job nicely. Ready to start please reply soon. Thanks, Virendra
$120 USD ndani ya siku 3
4.8 (66 hakiki)
5.3
5.3
Picha ya Mtumiaji
Hello, I see your requirements and what I need to do. For logic and process flow, we can discuss over chat. I have 10+ years of experience on Excel, VBA, Access and outher Office applications. Please ping me and lets go over with it. Thanks, Rayyan
$150 USD ndani ya siku 3
5.0 (15 hakiki)
4.7
4.7
Picha ya Mtumiaji
am not a random bidder.. Please ping me if you are intersted with my proposal and share more detail along with smaple formats.. thank you..
$250 USD ndani ya siku 3
4.9 (23 hakiki)
4.8
4.8
Picha ya Mtumiaji
.......................................................................................................................................................................
$333 USD ndani ya siku 3
5.0 (3 hakiki)
4.2
4.2
Picha ya Mtumiaji
Hi, I have 10+ years of experience in Advance Excel, VBA, Macros and other office integration development. I am sure i can handle your requst
$120 USD ndani ya siku 3
5.0 (10 hakiki)
4.0
4.0
Picha ya Mtumiaji
Hi I have more than 8 years of experiencing in building these kind of tools. Formatting and logic being the key of these tools to work without breaking. The VBA coding will we done for long term usage basis....and will be providing mainatainence support for an year included in the coding bid.
$222 USD ndani ya siku 7
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
Hi! I use macroses to automate work on my job every day and have expirience with coplex ones. Your project seems simple, can you send me examples of input/output data so I can validete size of work.
$30 USD ndani ya siku 2
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
I'm good in VBA and in excel macros trust me and get me a chance. I'll do allwyn.
$194 USD ndani ya siku 3
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
Yes i will done this project i have 5yrs experience of this so please suggest me.
$155 USD ndani ya siku 3
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
Hey dear...i have 2 year expierence in data entry operator n also research associate....
$155 USD ndani ya siku 3
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
I have good knowledge in domain and programming. I can give you the right solution within the stipulated time period...
$277 USD ndani ya siku 10
0.0 (0 hakiki)
0.0
0.0
Picha ya Mtumiaji
I have experience on such projects around 6 years and i always want to make some things special, different, saving time, not do the regular job.
$120 USD ndani ya siku 3
0.0 (0 hakiki)
0.0
0.0

Kuhusu mteja

Bedera ya SINGAPORE
Singapore, Singapore
0.0
0
Mwanachama tangu Sep 17, 2018

Uthibitishaji wa Mteja

Asante! Tumekutumia kiungo cha kudai mkopo wako bila malipo kwa barua pepe.
Hitilafu fulani imetokea wakati wa kutuma barua pepe yako. Tafadhali jaribu tena.
Watumiaji Waliosajiliwa Jumla ya Kazi Zilizochapishwa
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Onyesho la kukagua linapakia
Ruhusa imetolewa kwa Uwekaji wa Kijiografia.
Muda wako wa kuingia umeisha na umetoka nje. Tafadhali ingia tena.