Find Jobs
Hire Freelancers

Automated data extraction for report

£20-250 GBP

Completed
Posted over 8 years ago

£20-250 GBP

Paid on delivery
I have a tabular spreadsheet that I'd like to extract data from to make an automated report. Needs to be visual and needs to re-size in relation to the number of data points added. The example spreadsheet shows the source data in "Australia FPSO" and the next two tabs show the type of reporting required. As part of the project I would like the format of the reports to look good ready for printing. The Pipeline report is to be a single table which shows in colour of each stage. Ideally the spreadsheet should handle addition sales stages being added or removed (vertical) and additional opportunities added/removed (Horizontal groups). The Pipeline report and task list should use the cell colour that the source data presents.
Project ID: 8884651

About the project

29 proposals
Remote project
Active 8 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
Awarded to:
User Avatar
15 years of experience with MS OFFICE. You can see my portfolio
£44 GBP in 2 days
5.0 (17 reviews)
5.8
5.8
29 freelancers are bidding on average £112 GBP for this job
User Avatar
Hello Sir, I am an Expert Techno-Functional Analyst having vast experience in lots of arenas of IT industry including Excel Macros and Formulas. I am an Engineering Graduate with an MBA degree. If you see I am among niche bidders who have zero failed projects and 100% completion rate since I do not bid on projects which I am not certain of. I will not disappoint you, please give me an opportunity to work with you. No milestones required. Pay me only when your job is 100% done. Also I will provide you with a working version of file before you consider awarding me the project. Thanks, Jay
£50 GBP in 2 days
5.0 (825 reviews)
8.9
8.9
User Avatar
A proposal has not yet been provided
£120 GBP in 5 days
5.0 (474 reviews)
8.0
8.0
User Avatar
Hi sir, I am scraping expert, I have did too many similar projects, please check my feedback then you will know. Can you tell me more details? then I will provide demo data for you. Thanks, Kimi
£141 GBP in 3 days
5.0 (193 reviews)
7.3
7.3
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. They speak for themselves. Best regards
£127 GBP in 3 days
5.0 (307 reviews)
7.4
7.4
User Avatar
Hello Sir Im excel VBA macro and formula Expert :) i can do anything in excel :) please give me a chance for doing your job and im able to start doing your job right now :) Thank You Sincerely Prameswara
£20 GBP in 0 day
4.9 (398 reviews)
7.6
7.6
User Avatar
Hi, I have over 7 years of developing macros to automate Excel for different tasks. I am available to work on the project right now. Lets discuss the project in detail, so I can understand the key requirements in reports. Thanks
£77 GBP in 2 days
4.9 (282 reviews)
6.9
6.9
User Avatar
Hi there. I am a professional programmer, with more than 6 years of experience working with MS-Excel. I have complete knowledge of excel tools, formulas and VBA macros add-on. I can guarantee you an excellent job and deliver as soon as possible. I have checked out the file you attached and would like to chat with you to discuss a couple things. HOpe to hear back from you soon. Thanks, Daniel
£142 GBP in 3 days
4.8 (92 reviews)
7.1
7.1
User Avatar
Hi, I have read the project and understand your requirement.I am a highly trained on Data Entry ,Research, Web search, Web scraping, Product Add, Any Type Of eCommerce Cart, Expert with great knowledge of Excel. I also can do manual/ automated data scraping work.I definitely have some questions when we discuss project. I worked with many different American Law years, Entrepreneurs and Email Marketing Company of some extensive and difficult email searching and lead generation jobs. Apart from this type of job I have experience in Administration related job, Internet research, Virtual Assistant, Business analysis, Other Excel, Data Entry, excel formula generation etc. Kind regards, Fatima
£77 GBP in 3 days
4.9 (170 reviews)
6.9
6.9
User Avatar
I'm a computer science professional with a PhD degree and extensive experience in Excel and VBA. I could send you samples of my work if you wish. Please see reviews on my profile. It would be my pleasure to do your project. Please have a look at some Excel projects I've done: https://www.freelancer.com/jobs/php/Need-excel-plugin-convert-USD/ https://www.freelancer.com/jobs/Excel/Need-covert-very-large-dat/ https://www.freelancer.com/jobs/Excel-Mathematics/Convert-math-proofs-Excel-formulas/
£40 GBP in 2 days
4.8 (177 reviews)
7.1
7.1
User Avatar
Hello, I am Excel and VBA expert. I can write a macro to extract data from FPSO Regards Jan
£88 GBP in 3 days
5.0 (93 reviews)
6.1
6.1
User Avatar
Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 50 projects, almost 45+ are complex Java, VB/VBA projects, hence i can definitely deliver an excellent solution to your requirement. Expert in VB/.NET, Java, Javascript, Restful, Ruby, Matlab, SQL, MS Office, Access/Excel/Word, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex excel VBA projects, viz converting Raw data to structured using vba, sales dashboard, PO tracking, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers. Also Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc. Looking forward to work with you.. Have a nice day Thanks.
£74 GBP in 3 days
4.9 (82 reviews)
6.1
6.1
User Avatar
Hi there, I’d like to be considered for your programmer position. I’m an Access/VBA developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL including projects for start-up companies and small businesses For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship..... Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
£250 GBP in 3 days
4.8 (23 reviews)
5.5
5.5
User Avatar
Hi, I am very good in EXCEL and VBA programming so I can help you with this project in minimal time. as I have worked on similar projects many times. what I Imagen for this project is as below : 1- you will fill the data in "Australia FPSO" sheet with same format. 2- you will hit a button to start reporting the results. 3- the results will be on other two sheets "Pipeline Report" and "Task List" with some highlighting for the dates. in the "Pipeline Report" i saw that you highlight the cells only, so maybe we can also add who is responsible on this project to it with the highlighting. Regards.
£150 GBP in 1 day
5.0 (26 reviews)
5.3
5.3
User Avatar
Hi, I am a scientist by profession with extensive experience in creating Excel platforms for reformatting, organising and reporting large data sets. I have previously created similar reporting templates for a large variety of scientific analysis, and I believe creating one for your reporting purposes would be a similar use of my skills. I will quickly be able to make you an attractive, easy-to-use template that allows you to print your reports in formats similar to both shown in the example spreadsheet. I will also provide the ability to export and save the reports as .PDF files separate from the template spreadsheet. Please see my portfolio for some previous examples of similar Excel work I have done in the past. Thanks for your consideration, Dan
£80 GBP in 3 days
5.0 (50 reviews)
5.3
5.3
User Avatar
Hello, I am interesting to your project & placed bid for your consideration. with my experiences in excel coder & formulas I am very confident that i will deliver good result as per your requirement on time. Appreciate If you would like to talk thru PM before awarding this project as I'm online now. Hope to hear from you soon Thank & Regards, gsanggara
£70 GBP in 3 days
4.9 (27 reviews)
4.3
4.3
User Avatar
Hi, I have some experience in data sorting and reporting, so I can do macro for automated data extraction and report creating. Best regards, Remis
£66 GBP in 7 days
4.9 (5 reviews)
3.5
3.5
User Avatar
Hi, I have good amount of data processing in excel by writing program in C# .Net and you can refer to my profile. I can develop application in C# which reads the excel contents and generate report in the new tabs sheets. I will also make sure the formatting for report is provided as expected. Looking forward tow work with you. Waiting for your reply.
£100 GBP in 3 days
5.0 (11 reviews)
2.9
2.9
User Avatar
Hello sir, I am ready to take the project. I went through your project description and got enough expertise to handle and finish your project within in budget and within deadline. Thanks & Regards, Fayjur Rahman
£150 GBP in 3 days
5.0 (4 reviews)
1.1
1.1
User Avatar
GMC strategy is where we shape our client future. Combining deep business insight with understanding of how things will impact industry and business models. At GMC, we recognize that Business Strategy cannot realize its potential if not matched with the requisite Execution Capability and Technology. We work with our clients to arrive at the right solution in terms of strategy, capability and technology to enable them to improve business performance and achieve their objectives. “Everything we do to execute our strategy & deliver our vision comes to life through our employees and clients, all connected by the GMC way." The GMC way is how we do things, how we innovate, collaborate, operate & deliver value. It is how we interact with our clients & each other. From giving back to communities, to inspiring our people and to satisfy our clients in everything we do, we deliver high performance. We identify strategic opportunities for our clients and develop roadmaps to effectively harness those opportunities
£155 GBP in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
£23 GBP in 3 days
0.0 (0 reviews)
0.0
0.0

About the client

Flag of UNITED KINGDOM
Ashtead, United Kingdom
5.0
23
Payment method verified
Member since Mar 13, 2005

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.