Find Jobs
Hire Freelancers

Wage Report Creator - Excel Layout Convertor

£20-250 GBP

In Progress
Posted over 5 years ago

£20-250 GBP

Paid on delivery
I am the Team Leader for a UK based transport company. My company produces a specific report for another company however our layout and their layout for the report differs. I need something to convert the layout of our report into their desired format. The details of the requirements are in the attached file "Development [login to view URL]" and you can see what the original report looks like and how the report is supposed to look after the conversion.
Project ID: 18224312

About the project

26 proposals
Remote project
Active 5 yrs 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
26 freelancers are bidding on average £122 GBP for this job
User Avatar
Hello Sir, I am the expert freelancer here. I am on the 6th position through out the world to deliver the quality job. I have deliver here more than 400 + projects with 100% client satisfaction. I have more than 5 years of the experience in Data Entry, Data Processing, Excel, Microsoft Office, Visual Basic. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. Thanks.
£180 GBP in 3 days
4.9 (445 reviews)
8.3
8.3
User Avatar
Hi, there! My name is Paris, and I was glad to see that you're looking for an Excel, and VBA developer. I plan to create a macro that will follow your instructions in the attached Word document. I work with similar tasks all the time. I will charge you 140 pounds and can deliver within a couple of days from awarding (a single milestone to release once you're satisfied with the final result). I'm among the most experienced, and skilled Excel, and VBA developers on this platform. I have completed 268 projects successfully in less than six years, and I feel confident to complete your project as well. You're welcome to visit my page on this platform (https://www.freelancer.com/u/paris2785) and get an idea of who I am and what services I provide to my clients. I'm looking forward to working with you. Sincerely, Paris Pallas
£140 GBP in 2 days
4.9 (361 reviews)
8.0
8.0
User Avatar
Hi, I can develop auto modules to produce the 'Shift - By Driver Report' from the 'original-OPTAC3 Shift Report (I cannot open the doc file). I am a financial expert and guru in Excel/VBA/Macro. I have extensive knowledge and expertise in advanced formulas, Pivot Tables, and Visual Basic Application. With these skills, I prepare dynamic & designed reports and dashboards, for pitch decks, business plans, due diligence, financial modules, feasibility studies, and financial projections with scenarios and charts.
£250 GBP in 3 days
4.9 (95 reviews)
7.5
7.5
User Avatar
Hi, Reading your project description about converting report document from one layout to another layout makes me feel like you have me in mind when creating the project. I have all it takes to deliver. I can tell you about how highly experienced and multi-talented I am. But I’m sure you need more than that. In less than 24 hrs, I will complete a sample part of the job before you award the project so you can be sure you’ve entrusted your job in the best hands. No commitments required! Hope to hear from you soon
£150 GBP in 3 days
4.9 (69 reviews)
6.9
6.9
User Avatar
I am Excel expert, your requirement can be completed with some VBA code. Contact me and we can start. I am an accountant too so your data is familiar with me. The cost can be reduce. No problem. Thanks.
£50 GBP in 1 day
5.0 (232 reviews)
6.6
6.6
User Avatar
I have 4 yrs in Programming, Automation & more importantly delivering projects as required & in quick turn around time. I work full time as Freelancer & Blogger. I will be able to start your work immediately. My Main Skills: - Excel - VBA - Python - Web Scraping - MS Office Word, Outlook, Access, PPT Skill Set in Detail: - Office & Web Automation & Blogging on Office Tricks & tips. - Python Programming, Web Scraping - Data Scraping - Manual to Automatic updates in Excel - Excel Pivot Charts & Tables - Excel Auto Filter, Vlookup, Formula Assistance - Excel to Access - User Forms in Excel - Calendars in Excel - Bulk Files Processing in side a Folder - Folder Operations - Sending Email from Excel - Extract Data from Webpages Requesting to Contact before ordering. This would enable me to give a feasible custom offer. Please drop a message once you feel comfortable with my profile & lets get started with a feasible amount. Thanks for your time
£77 GBP in 3 days
4.9 (192 reviews)
6.6
6.6
User Avatar
I am proficient with excel Visual Basic/macro development, I can write the macro to convert the report into desired format automatically, if you are interested feel free to message me, I am available to start your project immediately, looking forward to chat further and work on your project.
£100 GBP in 3 days
5.0 (131 reviews)
6.7
6.7
User Avatar
Hi I am a very experienced statistician, data scientist and academic writer. I have completed several PhD level thesis projects involving advanced statistical analysis of data. I have worked with data from several companies and have done projects involving high level quantitative analysis and data interpretation skills to study the trends, time behaviour and compare the variables in the data. I can do advanced level analysis in SPSS, R, PYTHON, WEKA, TABLEAU and EXCEL tools like machine learning, hypothesis testing, forecasting, T-test, ANOVA etc. Looking forward to discussion, Best Regards, Suyash
£277 GBP in 3 days
4.7 (89 reviews)
6.9
6.9
User Avatar
Hi, I went through the project documents ORginal as well Desired output. Its pretty much clear . I can complete the job within hour or two. I am expert in Excel/Macros. I propose to use Macro to achieve the desired output. Please ping back to discuss and get started right away. I have 10+ years of experience in Excel/VBA. I have done many similar projects. Thank You Regards Rishi
£60 GBP in 1 day
4.9 (180 reviews)
6.1
6.1
User Avatar
Hi, As per given details Its excel related and data entry task. I have great experience in all kind of backend support I am good in lead generation, internet research, market research, data entry, data processing and all kind of backend support. You can check my competencies. I can give you best quality output with fast turn around time in competitive price Thanks
£70 GBP in 3 days
4.9 (77 reviews)
6.1
6.1
User Avatar
Hello, I am Excel and VBA expert. I can do this project (VBA macro). Macro can create an output file completely automatically. The user only presses the "Create" button. I can start today. If you have any questions, I will be happy to answer. Please note that I have 100% completion rate and 5-star feedback on over 50 projects. Jan
£100 GBP in 3 days
5.0 (98 reviews)
6.2
6.2
User Avatar
Hello, I have already gone through the details from you. I think it is the best suited for me and you will have got an excellent feedback. I am available from now on. I ensure you i will provide you a better quality work. So please call me an invitation. Regards, Rana k.
£20 GBP in 1 day
4.9 (60 reviews)
5.6
5.6
User Avatar
Hello, I checked attached files and I can perfectly automate generation of output Excel file in shown and described format, with VBA macros. I can make output folder the same as source file or selected by user if preferred. What would be output file's name pattern? I will keep one worksheet hidden as output template, as layout area and formatting is constant, to minimize code clutter and allow to easily adjust visuals by simply formatting this template. My macros will generate file instantly. Code will be transparent and easy to maintain. I'm a full-time VBA developer with over 7 years of experience. I write macros for Windows operating system only, basically meaning no MAC. Best Regards
£60 GBP in 2 days
5.0 (64 reviews)
5.4
5.4
User Avatar
Hi there! I would love to have the opportunity to work with you on this project - as I am highly experienced with this style of automation work. I am a business analyst with over 15 years of professional experience, and a large part of my career has focused on automating data movement between systems (i.e. reformatting data from one system so it can be imported to another / presented according to a specific reporting requirement / added to templates etc.). I have taken a look through the files you have provided (which are extremely thorough - thank-you!) and just had a couple of questions - 1. The dates seem inconsistent (A7:13) in the output file they are all incremented by one - is this by design? 2. You mention the formulae in O15-O18 aren't calculating, however there no formulas in these cells (I can write a macro to add formulas in these cells no problem, I am just a little muddled by the comment) I would propose delivering a workbook / macro based solution, the file would have the option mentioned to specify the wage number for a driver list to be used in the macro. Once you start the macro it could either - 1. Show an open file dialogue and you navigate to where the original file is saved, it opens and transforms (better if save location changes often) 2. Batch process - you specify the folder where the original(s) are saved, it crawls that folder and transforms all the files in it (better for large volumes of files) It would be great to chat further!
£200 GBP in 3 days
5.0 (32 reviews)
5.4
5.4
User Avatar
Hi, I am an excel VBA expert and i went through both of the excel files. It certainly looks straightforward and i can start right away. Please go through my profile and reviews so that you can be confident about me. I've done a lot of similar projects. My last project was to pick selected stocks from a sheet of 500 stocks. Hope to have a quick chat soon mate! Thanks Sajid
£100 GBP in 3 days
4.2 (69 reviews)
5.9
5.9
User Avatar
"Hello Dear, Yes, I can work for you as per your project description with amazing exploration and experimental research abilities of mine organization is perfect for that you may require. My work fulfills as well as keep you returning consistently. It is because of the importance behind this field that I am confident & serious when taking these types of projects. Let me introduce with professionalism and skill that exists to supply the best. Regards"
£100 GBP in 3 days
4.9 (25 reviews)
4.9
4.9
User Avatar
Hi Next Employer, I am interested in your project. I hold master degree in Business Administration (Finance). I am experience data entry operator accountant and auditors having more than 9 years’ experience of data entry Microsoft Word, Excel Power Point and web scraping. I hope will be hear positive soon from you side..
£100 GBP in 3 days
4.6 (21 reviews)
4.6
4.6
User Avatar
Combined twenty years of accounting, analytical and project management experience. Enthusiastic, proactive and accomplished successful roles within the Financial Services sector.
£150 GBP in 3 days
5.0 (4 reviews)
3.7
3.7
User Avatar
Hi, My name is Héctor, I'm from Chile but living in Brazil for the last 7 years. I've 24 years of experience programming Office + VBA. I'm looking for new customers/projects, so I'm giving you a special price. Regards and thanks!
£55 GBP in 1 day
5.0 (2 reviews)
2.1
2.1
User Avatar
"Greetings! According to your stated project description you need an Google sheet and excel expert. I read your job description and understood. Yes, my experienced service will help you all about MS program. Just send me all of your requirements to start your project. I think no need to talk about the quality because I think provided work will proved it. I will be in touch with you any time you need. Looking forward to hearing you. Waiting for your kind response. Best Regards."
£100 GBP in 3 days
5.0 (2 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Dundee, United Kingdom
5.0
1
Payment method verified
Member since Nov 24, 2018

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.