Find Jobs
Hire Freelancers

The Leading Edge

$30-250 USD

Closed
Posted 11 months ago

$30-250 USD

Paid on delivery
Hi. This is a one off query. I use Excel with Office 2000, the attached file is a copy of a daily download from ESignal, the daily data file layout is constant. Up until May 1st the data was presented in a comma separated format, every spreadsheet I use looking at this raw data is comma separated. What I did:- I wrote and saved a simple macro DOTStoCOMMAS converting all dots to commas in the raw data file, it only worked 100% once, running the macro on the next days raw data file gave results which do not relate to the original file. I installed Office 365 thinking it would resolve the issue to no avail. I would prefer to keep everything in Excel 2000 if possible. Editing a macro is beyond my level at the present. I would ask what causes the macro to produce unrelated data and is it viable to produce a reliable macro using old software. I am an individual person not affiliated to any company or commercial enterprise. What would be the cost of a conversion file. Best regards Peter Dodd
Project ID: 36661690

About the project

17 proposals
Remote project
Active 10 mos ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
17 freelancers are bidding on average $100 USD for this job
User Avatar
Top 1% in Freelancer.com Hi, Greetings! ✅checked your project details: ✅Completed Time: In project deadline We have worked on 900 + Projects. I have 6 + years of the experience in same kind of projects. If you are looking for a true Freelancer, I am the Right person for you. I am available almost 24-7 and am very responsive. I feel proud that I am a trusted Freelancer who pleases almost every single client. You can rest assure, your work will be delivered well in advance of others, with passion and accuracy. I guarantee you instant communication & responses when you need me. Why choose me? I think every client is the reason for my success. I only take projects which I am sure I can do quickly. My Portfolio Items: https://www.freelancer.com/u/schoudhary1553 I would really like to work with you on this project. If interested, Kindly contact me via chat for further details and discussion. Thank you Sandeep
$220 USD in 5 days
4.9 (588 reviews)
8.5
8.5
User Avatar
I am an Excel and VBA programming expert and can do it easily and quickly as I have relevant experience in excel and VBA and completed a lot of relevant projects. Malik
$240 USD in 5 days
5.0 (100 reviews)
6.9
6.9
User Avatar
Hello peterdodd, I hope this message finds you well. I will be able to help you with your project. I read through the description and it sounds like I am just the right person for it. I have the right skill set with sophisticated experience in Data Processing and Excel. As a next step I would like to discuss some further questions with you. Either over the chat or a call, whatever you prefer. For my references and qualifications: I graduated in Computer Science with highest grades from one of the most reputable universities in Germany. Currently, I am enrolled in the Master's program. During my studies, I already published a paper on the subject of Artificial Intelligence. Further, I managed to get a lot of hands-on experience by working in several companies that operate in the field of Computer Science. As a native German speaker who was living in Canada for a year, my level in English is proficient/fluent. Further, I am in the preferred Freelancer program, making me part of the top 3% on the platform. Many successful past projects can be seen on my profile page. I am looking forward to working with you and if you have any further questions I would be happy to answer them. Best regards, Simon
$200 USD in 3 days
5.0 (21 reviews)
5.8
5.8
User Avatar
Hello sir/ madam I checked your project description. I can do Microsoft Excel macro task with 100% accuracy & i am ready to start right now. If you are interested to message me we can discuss more. Thank you. Regards, Saaniya.
$30 USD in 1 day
4.8 (167 reviews)
5.7
5.7
User Avatar
Hey Peter, I hope this message finds you well. After carefully reviewing your query, I understand that you are facing difficulties with a macro in Excel 2000 that converts dots to commas in your daily data file. You mentioned that the macro worked correctly only once, but subsequent attempts resulted in unrelated data. I am confident in my ability to assist you with this issue. As a Certified Chartered Accountant and experienced finance professional, I have extensive knowledge and expertise in Excel and macros. I will analyze your existing macro and identify the cause of the problem. I will then provide a reliable solution that ensures the accurate conversion of dots to commas consistently. Regarding your preference to keep everything in Excel 2000, I will work within that framework to develop a viable and functional macro. I understand the importance of maintaining compatibility with your current software. To provide you with a precise cost estimate for the conversion file, I would appreciate it if you could share the specific requirements and details of your daily data file layout. This will enable me to tailor the solution to your exact needs. Thank you for considering my services. I look forward to assisting you in resolving this issue promptly and effectively. Best regards, Member ACCA (UK), ACA (UK) finalist
$100 USD in 3 days
5.0 (35 reviews)
4.6
4.6
User Avatar
Hi I’m willing to provide you with a FREE SAMPLE in this way you will be able to trust my quality work. My bid amount is negotiable and we can discuss it over chat. There I am ready to start now. I will make a sample first if you like sample work then you can hire. I am ready to make a free sample now. I have done many jobs like this. Please message me for detail. Regards Fardin
$100 USD in 2 days
5.0 (4 reviews)
3.4
3.4
User Avatar
Hello, I am Peter Dodd and I am writing to ask about changing the comma-separated raw data stored in the Daily Download from ESignal into a comma-separated format so that it can be used in Excel 2000. I understand that this may be an issue for you as the data should currently be presented in a comma-separated format up until May 1st. I have experience in data entry, data processing and Excel. Specifically with regard to comma-separated data such as the one contained in the Daily Download from ESignal, I have used macros before to convert all dots to commas in order to make use of this file type in other applications like Office 365. This has only worked once so far but I am confident that I can produce a reliable macro for your use that will enable you to use this data in Excel 2000 without issue. I am available 24/7 for client work as well as offering upfront costs for projects and providing client 100% satisfaction as my first priority. If you would like to discuss further please don't hesitate to reach out to me directly
$55 USD in 1 day
5.0 (3 reviews)
3.0
3.0
User Avatar
"Dear client, I can assist you with your The Leading Edge project. My skills include Excel, copy typing, data entry, and data processing. I provide creative, proactive and high-tech solutions to your development needs. I have solid experience in HTML, Javascript, PHP,CSS,metatrader, MySQL, Node.js, React.js, Joomla,Angular.js, Laravel,Java, Python, Wordpress,linux Ruby on Rails, Database, Objective-C and Swift,C, C#, C++, Qt, Linux and raspberry. Don't hesitate to contact me to create awesome products! Thanks."
$50 USD in 2 days
4.7 (5 reviews)
3.2
3.2
User Avatar
I am a skilled freelancer offering data entry, word typing, Excel management, and virtual assistant services. With expertise in these areas, I can efficiently handle tasks such as data input, document creation, spreadsheet organization, and administrative support. Whether it's entering data into systems, typing up documents, managing Excel spreadsheets, or providing virtual assistance, I deliver accurate and timely results. As a dedicated professional, I am committed to meeting your requirements and providing a high level of quality in my work. Let me assist you with your projects and help streamline your tasks effectively.
$140 USD in 7 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Hiii i am a best excel progeramer and i am mange your work proper please give send me our file
$30 USD in 5 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Good day Peter, I have extensive experience in the banking industry in resolving issues similar to yours. You mentioned until the first of May you received the file as .csv. So I assume you NOW receive it only in the form of this Excel file. I picked up in line 10 of your example that it created a line that still has a "," in it, but merely added a '.' in front of it (column 4 refers). QME M23 MEXICAN PESO 0.5584 0.,5594 0.5526 0.5528 0.48900463 Also further down there are 3 lines ZW N23 [10] WHEAT 612'6 614'0 602'4 606'0 0.482060185 ZC N23 [10] CORN 594'2 595'6 588'2 590'2 0.482060185 ZS N23 [10] SOYBEANS 1336'4 1339'6 1322'0 1323'6 0.482060185 Is this how ESignal is exporting the file (or has some sort of program already run on this file (other than the conversion to an Excel file)? If so, then the problem lies in the data which is being exported from ESignal. But it is not a showstopper. I can assist you to rectify this, and avoid most of your manual work by letting the program step through each cell individually checking it for common errors to give you the desired result and create a log file of fixes. Further, I can assist you to embed the macro on your ribbon bar as an Excel Add-In, to allow you to merely run it on any Excel data file you receive without the VBA code having to be part of that data file. I look forward to your response.
$50 USD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of BRAZIL
Rio de Janeiro, Brazil
0.0
0
Payment method verified
Member since May 27, 2023

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.