Do some Excel Work

$250-750 AUD

Closed

Posted

over 7 years ago

$250-750 AUD

Paid on delivery

I need an excel guru to develop a dashboard interface for some background data to make the presentation of the information more interactive and user friendly. The end result being a report that will need to have the background data updated by myself quarterly. We currently use a cloud based platform that has the capability to generate raw data excel spreadsheets with all the required information - I wish to be able to generate this data report and copy and paste the data into the developed excel spreadsheet where to front page dashboard will update automatically (or to something of that effect). The data that will need to be represented is manufacturing data - criteria being manufacturing production weights, versus how much energy is used to produce this product, how much water is required, and how much waste and greenhouse gases are generated due to our operations. I have a sketch of what I wish the dashboard to include but there will need to be a number of background calculations applied to the raw data to enable to functionality of the graphs on the dashboard. There will also need to be year on year graph comparisons as to how the site is tracking each consecutive year (using historical data).

Data Entry

Data Processing

Excel

Software Architecture

Project ID: 12020668

About the project

25 proposals

Remote project

Active 7 yrs ago

Looking to make some money?

Email address

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

25 freelancers are bidding on average $468 AUD for this job

@seaanddream

Hi, my name is Sevinc. I read your "Do some Excel Work" project descriptions carefully before bidding. I checked the attached reporting template as well... I got what you need and ready to go ahead as soon as we can clarify further project details. I am 5-star excel and vba coding expert here at freelancer.com. Pls check my profile and feedbacks first to have some idea about the quality of my previous businesses. I had many similar excel tasks, including automated data extraction, aggregation and reporting, all achieved with 5/5 rating. Kindly get back to me if you wish to proceed with a top-rated and reliable partner here...pls note that I only deliver best quality at a reasonable price, and I am open for longterm partnerships, if you wish too... I bid my best for you to start business, and I am ready to prepare an excel workbook template for you to check & validate, once you give me a reply...regards.

$430 AUD in 5 days

5.0

(284 reviews)

7.7

@mirniyazuddin92

Dear Sir/Ma'am, I am a Web research, Data Entry & Webs Scrapping expert. I checked and understood your requirements. I can handle this job very well to your appreciation. I can find and extract the information from different websites into an Excel sheet. I am ready to hear the details of the project more in detail now. I have always created a long-term collaboration with my clients through hard work and quality output for a reasonable price. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir

$631 AUD in 10 days

4.9

(304 reviews)

7.6

@someka

Hi there. What we going to develop is a simple model in which you can paste your raw data and get the results automatically calculated and presented in a dashboard. Background calculations will not bother you and you will just manage the model with a nice frontend interface from dashboard (your tables, charts) Lets discuss more at chat. Thanks..

$789 AUD in 7 days

5.0

(149 reviews)

7.1

@mehedi276

"Rate and duration will be fixed on discussion" Dear Hiring Manager, I have gone through your job posting and become very much interested to work with you. I am an expert in these fields. I have already completed several projects like this. For evidence you can see my profile. I have excellent command over English. I am a hard worker, productive and worthy of your attention I hope, I would be the right candidate for this post. Awaiting an affirmative response from you. -- Kinds Regards, Mehedi Hasan.

$515 AUD in 10 days

4.9

(444 reviews)

7.4

@elqueabandona

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

$500 AUD in 10 days

5.0

(189 reviews)

6.7

@cugamelover

I can do exactly what you need. I'm a computer science professional with extensive experience in automation of data acquisition, processing, analysis, and presentation in Excel using custom dashboards, macros (VBA scripts), pivots, filters, and other advanced tools. I've done a lot of similar work. 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/projects/Excel/Build-Excel-reports-dashboard/ 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/

$300 AUD in 3 days

4.7

(205 reviews)

7.2

@ksriniravi

Greetings! I have 17+ years experience in using Excel as part of my daily work life. In the process I have implemented lot of automation similar to what you are expecting as well as dashboards for Management Reporting. In fact, over the last MONTH , I have spent at least 225 HOURS on automation in Excel. I can get your work completed to your fullest satisfaction. Looking forward to hearing a positive response from you. Thanks in advance! Have a Great Day! Srinivasan Krishnamoorthi

$400 AUD in 10 days

5.0

(137 reviews)

6.5

@danielgpratidya

Hi, Check my XL dashboard example in my portfolio page. The data from the raw file (the one downloaded from the cloud) can be calculated/populated and then update the dashboard figures by a click of a button, which once you click you will be able to choose any raw file from a open-file dialog box. I can create the automation program for that function. Let me know what is the best time to discuss. Cheers, Daniel

$750 AUD in 10 days

5.0

(188 reviews)

6.5

@dpune

Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. Please send me more details so that I can estimate cost and time better. I have completed more than 290 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.

$500 AUD in 10 days

4.9

(209 reviews)

6.6

@prashushinde9

Hello, I understood the initial scope of this project. Although i want to discuss further this job in order to prepare the final concept for this project. After Complete discussion over the call or in chat, i will prepare following things for you - Technical Project Proposal - Flow chart for this Project - Execution plan (Step by step procedure with explanation how and at what that we are going to execute a particular task)

$773 AUD in 20 days

4.6

(15 reviews)

6.1

@macroPOL

Hello, I am Excel and VBA expert. Can I see raw data? Please note that I have 100% completion rate and 5-star feedback on 50 projects.

$555 AUD in 10 days

5.0

(61 reviews)

5.6

@nagybatonyi

Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macro contained in a separate XLSM file. This approach makes further use of the macro very convenient by offering a Control sheet containing cells populated by the usual Open file and/or select folder dialogs to identify the current input and output files (or the folders containing them, as required by the job) and hosting command buttons and other controls if necessary. In this way you can spare copy/pasting, you will be able to import new data via a single click. In my approach you'll have opportunity to consult details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. I can start working on the project immediately. If you send me a sample file and a job specification, I'm ready to create a free draft pilot for you. Regards

$250 AUD in 5 days

4.9

(62 reviews)

5.7

@haibg2111

Dear the potential client I don’t know why many guys bid so high for this simple task, just draw data from the raw data sheet, then create a graphic dashboard. My name is Hai, I’m an expert in VBA programming and excel templates. I’ve helped many business create sale and production dashboard from start-ups to big corporations. With experience of production, manufacturing when I worked as an auditor’ assistant at Deloitte, I strongly believe I can help improve your dashboard. Contact me

$250 AUD in 10 days

5.0

(31 reviews)

5.3

@dangphap

Hello, thank you for reading mu proposal. I am an accountant with 3 years of experienced in manufacturing and also an Excel expert. I can do graphs, tables and implement VBA to automated tasks. I am willing to do this job at the minimum budget. Hire me!

$250 AUD in 2 days

5.0

(3 reviews)

1.4

@DataEntryVersed

Hello! Good Day! My name is Moshiur. I have read the job description and very much interested in the Project that you posted, so I'm applying for this job. I am an expert in those fields that you mentioned in the job description. I have already completed a lot of projects like this over the past 7 years. I have the ability to deliver accurate results in the deadline. So, I hope you will give me chance to work for this project. Respectfully, Moshiur

$250 AUD in 5 days

5.0

(1 review)

1.3

@Maniche83

Hi, I am Manish. I have over 7 years of experience in data analysis on excel. I am proficient with excel formulas. Please do let me know if you would like to offer me this opportunity. Thanks Manish

$250 AUD in 10 days

0.0

(0 reviews)

0.0

@jonathanparisot

Hello, Making sense of unorganized data is my expertise. I have been doing this for very prestigious european companies: Orange (main telecom operator in Europe), Casino Group (one of the 20 biggest global supermarket chains), Societe Generale (one of the biggest banks in Europe) and Jumia, the biggest African E-commerce company (valued at 1 Billions USD). Moreover, I am not only a technical expert, as the former a Managing Director of a +200 employees company, I undertand how a business is run and will more likely to understand your requirements and problems than another freelancer. The tool I will build will be automated. All you will have to do is copy and paste your database in the Excel document, and all the rest will automatically update. I am also able to add a smart recommendation algorithm to the tool. Based on some criteria you will give me, the tool will give automatic recommendations (for example: if waste of this product > treshold, recommendation will be "Fix the waste problem on this product") Finally, I will be happy to make business recommendations based on the data you will give me. Thank you

$500 AUD in 2 days