Find Jobs
Hire Freelancers

Excel VBA macro to create Pareto analysis

$30-250 SGD

완료함
게시됨 6년 이상 전

$30-250 SGD

제출할때 지불됩니다
I need two VBA macros for the attached excel file. Background information (the following is already created with formulas and conditional formatting): - The user selects the parameters that he would like to analyze in the x/y-axes selector in sheet "Data input" - Upon selection, the columns for his data input appear in orange in the same sheet - IMPORTANT: The column headers and required input changes depending on the selection of the user - The user fills the columns with his data input whereas the amount of rows that he uses may vary - The user clicks "Create Pareto analysis" button to automatically create a Pareto analysis Macro 1: Automatic Pareto analysis - Macro gets assigned to the button labelled "Create Pareto analysis" in sheet "Data input" - This macro must create data columns and a chart as shown in the example sheet "Savings per supplier" - The data for the chart is taken from the orange cells in the "Data input" sheet - The order and content of the data input may vary depending upon the type of analysis that the user wants to run - In total 36 different data input combinations are possible; all of them are shown as examples in the sheet "Sample sets" - Each sample shows the type of analysis ("axis selection", the name of the resulting chart, sample input data, sample output data, notes to be considered for the development of the macro and a sample graph - Every time the user clicks on the button, the macro should create a new sheet that is named after the analysis chart, e.g. "Savings per supplier", and placed right after he sheet "Data input" - The layout and formatting of the new sheet must look as in the provided sample, however, the cells should just contain values (i.e. no formulas as in the sample sheet) - The following colors are to be used (in the sheet that the macro creates): - background of data headers: RGB 10, 34, 57 - borders of data rows: RGB 10, 34, 57 - Header, x-axis labels and legend of chart: RGB 10, 34, 57 - left y-axis labels and bar chart: RGB 7, 113, 135 - right y-axis labels and line chart: RGB 251, 139, 36 Macro 2: Clear data input - This macro gets assigned to the button "Clear input data" in sheet "Data input" - Upon being clicked by the user, a pop-up should appear to ask "Are you sure you want to delete all your data in rows 12 and below"; Possible answers are "Yes" and "No" - "Yes" closes the pop-up and deletes all data cells B9 and C9 as well as in rows 12 and below in sheet "Data input" - "No" closes the pop-up with no further action Please write proper documentation in the VBA macros to explain what each function within the macros does. Do not change or delete the sheets "ColCreator" and "Procurement Pareto 101". The sheets "Sample sets" and "Savings per supplier" will not be part of the final file; they only serve as a reference for you during the macro development.
프로젝트 ID: 15863163

프로젝트 정보

23 제안서
원격근무 프로젝트
활동 중 6년 전

돈을 좀 벌 생각이십니까?

프리랜서 입찰의 이점

예산 및 기간 설정
작업 결과에 대한 급여 수급
제안의 개요를 자세히 쓰세요
무료로 프로젝트에 신청하고 입찰할 수 있습니다
프로젝트를 수여된 사용자:
사용자 아바타
Thanks for very professional requirements definition - I have reviewed the attachment in detail and can develop a macro that can address all the X-Y Axis combinations (3*12=36). Relevant Skills and Experience 18 years experience in using Excel as part of daily work life. In the process, implemented lot of automation. Over the last 17 MONTHS , spent at least 250 HOURS on automation in Excel every month. Proposed Milestones $60 SGD - On Delivery of Macro $45 SGD - After Macro Testing
$105 SGD 3일에
5.0 (186 건의 리뷰)
6.8
6.8
23 이 프로젝트에 프리랜서들의 평균 입찰은 $263 SGD입니다.
사용자 아바타
Greeting, I have understood your VBA macro to create Pareto analysis task and can do it with your 100% satisfaction. Please ping me for more discussion. Relevant Skills and Experience I have more than 5 years of experience in Excel, Excel Macros, Excel VBA, Visual Basic, Visual Basic for Apps Proposed Milestones $150 SGD - VBA macro to create Pareto analysis
$150 SGD 2일에
4.9 (321 건의 리뷰)
7.9
7.9
사용자 아바타
I can do it for you quickly and exactly. Please contact me for saving your time and your money Relevant Skills and Experience I have finished great than 90 project in this site Proposed Milestones $350 SGD - finished
$350 SGD 5일에
4.9 (120 건의 리뷰)
6.9
6.9
사용자 아바타
Hello I can do this work. I have nothing to add about. Relevant Skills and Experience VBA, Excel, Statistics. Proposed Milestones $800 SGD - Milestone.
$800 SGD 6일에
5.0 (63 건의 리뷰)
6.3
6.3
사용자 아바타
I have read the entire description of this project that is very interesting. I have worked with similar projects to create charts automatically. Solution can be delivered in one day for you to test it Relevant Skills and Experience Visual Basic for Applications (VBA) in Excel Proposed Milestones $190 SGD - Macro development
$190 SGD 2일에
4.9 (49 건의 리뷰)
6.1
6.1
사용자 아바타
Hello. I have an experience with excel VBA incuding create charts Relevant Skills and Experience Excel, VBA Proposed Milestones $220 SGD - Completed task
$220 SGD 7일에
5.0 (48 건의 리뷰)
5.7
5.7
사용자 아바타
Hi, there I can code your current project using VBA, SQL, ADO coding within Excel. Relevant Skills and Experience I'm programming in ms Access/Excel/VB since Ms Office 97 released Proposed Milestones $833 SGD - default
$833 SGD 6일에
4.7 (33 건의 리뷰)
5.8
5.8
사용자 아바타
I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Relevant Skills and Experience -- VBA and Excel,Word,Office Applications -- Expert on C# using .NET framework using Visual Studio 2012 and 2013 -- Expert in VB.NET using VS2012/VS2013 -- WPF and Windows Forms Application Proposed Milestones $255 SGD - VBA
$255 SGD 3일에
4.9 (65 건의 리뷰)
5.6
5.6
사용자 아바타
I am not a random bidder.. But I hope I can do this one.. I dont outsource the work.. Please ping me if you are happy with my proposal and thank you.. Relevant Skills and Experience VBA Proposed Milestones $250 SGD - final payment
$250 SGD 5일에
4.9 (34 건의 리뷰)
5.2
5.2
사용자 아바타
Sydney based Excel Consultant, available immediately. I have read the entire description and am confident I will be able to sort this out for you quickly and efficiently. Relevant Skills and Experience 1. 17 Years Excel Experience, including advanced macro development 2. Fluent in English 3. University graduate 4. 12 years corporate experience Proposed Milestones $120 SGD - 50% completion of agreed scope $113 SGD - Payment on completion, and after the client is totally satisfied with the end deliverable Please message me for a detailed portfolio of experience
$233 SGD 3일에
5.0 (13 건의 리뷰)
4.9
4.9
사용자 아바타
Hi, I read project description extremely carefully and i have good command on Data Entry and MS Office like (Excel, VBA & Macro). I will do it as per your Instruction. Let's chat with me. Thank You Relevant Skills and Experience Excel, Excel Macros, Excel VBA, Visual Basic Proposed Milestones $238 SGD - Final Delivery
$238 SGD 5일에
4.9 (30 건의 리뷰)
4.5
4.5
사용자 아바타
Excel VBA developer Relevant Skills and Experience Excel VBA Developer Proposed Milestones $155 SGD - Full Price
$155 SGD 3일에
4.9 (16 건의 리뷰)
4.5
4.5
사용자 아바타
Dear sir How are you Relevant Skills and Experience I am +6 years experienced full stack developer. Proposed Milestones $111 SGD - Project Milestone
$111 SGD 3일에
4.8 (6 건의 리뷰)
3.6
3.6
사용자 아바타
A proposal has not yet been provided
$166 SGD 2일에
4.6 (1 건의 리뷰)
1.1
1.1
사용자 아바타
i am enthusiastic and expert in meeting deadlines. your satisfaction is my job .we will be having fun working together. price are negotiable,experienced projects can be shown as screenshots on demand Relevant Skills and Experience experienced over 7yrs Proposed Milestones $111 SGD - demo,final,editing give me a try i will satisfy you
$111 SGD 10일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
Though I am new on this platform, I have more than 7 years hands on working experience as an accountant and skilled in working with QuickBooks and other accounting softwares like pastel and excel. Please give me this chance to offer you my services.
$222 SGD 5일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
A proposal has not yet been provided
$166 SGD 5일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
Hi , I could replicate everything in 'Savings per supplier' sheet from vb macro . I can share the file if you chat with me. Just a quick work and not final.
$277 SGD 5일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
I offer to do VBA programming and deliver a solution as required. Relevant Skills and Experience VBA, Excel, Offic e programming, English translator and writer, software development. Proposed Milestones $266 SGD - Work done. Support anytime. Coaching. Additional Services Offered $100 SGD - Software engineering services worldwide.
$266 SGD 10일에
0.0 (1 건의 리뷰)
0.0
0.0

고객에 대한 정보

국기 (SINGAPORE)
Singapore, Singapore
5.0
1
결제 수단 확인
12월 13, 2017부터 회원입니다

고객 확인

감사합니다! 무료 크레딧을 신청할 수 있는 링크를 이메일로 보내드렸습니다.
이메일을 보내는 동안 문제가 발생했습니다. 다시 시도해 주세요.
등록 사용자 전체 등록 건수(일자리)
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
미리 보기 화면을 준비 중...
위치 정보 관련 접근권이 허용되었습니다.
고객님의 로그인 세션이 만료되어, 자동으로 로그아웃 처리가 되었습니다. 다시 로그인하여 주십시오.