Find Jobs
Hire Freelancers

Hire an Excel Expert

€30-250 EUR

완료함
게시됨 6년 이상 전

€30-250 EUR

제출할때 지불됩니다
The goal of this project is to create a VBA script (to use in the file "structure and filters", as described below) that will generate an excel file, called here "output file", with one sheet only, containing a product list with "tier prices". A product can have max 3 rows for each different tier level and related price. To generate the "output file" we will use 2 files. The first file is the "database" file containing the "base product list". Each product has its own "base price", and there will be columns aimed to add details for each product, like "brand" -> "family" -> "group" -> "subgroup". This columns will be used in a second file, as described below. The second file is used as "structure and filters" to understand which rows should be generated in the output file, in function of product code, subgroup, group, family or brand, with which tier levels and which price, for each tier level, to apply. For any product in the "base product list" that have the same brand, family, group or subgroup exposed in the "structure and filters", will have to be generated in the "output file". On the same row in "structure file" will be exposed tier levels (in three columns maximum) and, for each tier level, the percentage of discount to apply to the base price exposed in the "product list" file. For example: if the "product list" file contains 2000 products/rows, and 150 products has the column "subgroup" with the value "ABCDE", the script should look if the subgroup "ABCDE" exists in the "structure and filters" file and, if so, it should generated 3 rows in the "output file", one for each tier level found (in respective 3 columns), and it should calculate the price, getting the base price in the "product list" file and appling a specific % discount indicated in a specific column in the "structure and filters" price. NOTE: the complete structure of the "output file" will be sent once the project will be assigned.
프로젝트 ID: 15789059

프로젝트 정보

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

돈을 좀 벌 생각이십니까?

프리랜서 입찰의 이점

예산 및 기간 설정
작업 결과에 대한 급여 수급
제안의 개요를 자세히 쓰세요
무료로 프로젝트에 신청하고 입찰할 수 있습니다
프로젝트를 수여된 사용자:
사용자 아바타
Hi there, I can start now. I am expert in Excel VBA with over 5+ years of experience. Ping me to discuss more about the project. Thanks Aman
€40 EUR 1일에
4.9 (172 건의 리뷰)
6.5
6.5
28 이 프로젝트에 프리랜서들의 평균 입찰은 €124 EUR입니다.
사용자 아바타
Greeting, I have understood your Excel VBA 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 Data Entry, Data Processing, Excel, Visual Basic Proposed Milestones €150 EUR - excel VBA
€50 EUR 2일에
4.9 (309 건의 리뷰)
7.7
7.7
사용자 아바타
Dear Employer, I have read your job and I will do it for you. Please check my reviews. Request you to give me one chance. I am an expert. Relevant Skills and Experience Excel VBA MAcro Proposed Milestones €155 EUR - Project
€155 EUR 3일에
5.0 (137 건의 리뷰)
7.2
7.2
사용자 아바타
Hi, I ll code the VBA macro which will generate the output file based on the 2 input files. We will do a sample 1-2 rows together to be sure that the logic of the generation is clear. Thanks Expérience et Compétences appropriées Excel/VBA Expert Étapes proposées €100 EUR - m
€100 EUR 2일에
4.9 (276 건의 리뷰)
7.5
7.5
사용자 아바타
i understand your project, it's very simple work, i can do this please contact me thanks, Relevant Skills and Experience Data Entry, Data Processing, Excel, Visual Basic Proposed Milestones €155 EUR - full I am a professional Freelancer. I would like to work on this project.
€155 EUR 3일에
4.9 (162 건의 리뷰)
6.7
6.7
사용자 아바타
Excel expert here with more than 12 year's experience. Let's discuss and make this project a success, I can take up the project on urgent basis. Relevant Skills and Experience Excel VBA Proposed Milestones €135 EUR - To be discussed
€150 EUR 3일에
4.9 (27 건의 리뷰)
5.5
5.5
사용자 아바타
Hi, I can do that via Ms Access app with Excel automation. Relevant Skills and Experience I'm programming in ms Access/Excel/VB since Ms Office 97 released Proposed Milestones €155 EUR - default
€155 EUR 3일에
4.7 (31 건의 리뷰)
5.8
5.8
사용자 아바타
Hi, I will create a macro to manipulate "product list" first. Macro will check rows one by one and if found "subgroup" then will go to second file "structure and filters" and find that subgroup code. If found then 3 rows will be added to "output file" and process according to required conditions. Relevant Skills and Experience Experienced Data Analyst and Macro Developer. I have excellent knowledge and experience of Manipulating Data in Multiple Sheets and Creating Reports. I have done mostly Excel VBA Programming job. Proposed Milestones €80 EUR - initial €75 EUR - final Please let me know the OS. Windows or Mac? We will discuss in details once you replied.
€155 EUR 3일에
4.8 (75 건의 리뷰)
5.3
5.3
사용자 아바타
Hi, I read you project description and I'm Dynamic Professional has good command on Office tools like (Excel, Word, VBA, Macro and Data Entry). I will done it as per your requirement. Thank You Relevant Skills and Experience Data Entry, Data Processing, Excel, Visual Basic Proposed Milestones €194 EUR - Final Delivery
€194 EUR 2일에
4.9 (33 건의 리뷰)
4.6
4.6
사용자 아바타
Excel VBA Expert Relevant Skills and Experience Excel VBA Expert Proposed Milestones €222 EUR - Full Price
€100 EUR 1일에
4.9 (9 건의 리뷰)
4.1
4.1
사용자 아바타
I developed many projects with Excel that include VBA/macros. Please check my portfolio. Relevant Skills and Experience My skills are in programming with languages like Excel, Python, C#. I have an experience of 5 yrs. Proposed Milestones €111 EUR - Complete the whole project.
€111 EUR 3일에
4.7 (14 건의 리뷰)
3.8
3.8
사용자 아바타
I guarantee you a first class service with the quality and in the time it deserves by putting at your disposal all my knowledge and years of practice. Habilidades y experiencia relevante Advanced proficiency on Microsoft Offices. Excellent team work and collaboration through influencing skills in the project. Strong attention to detail and ability to manage multiple priorities. Htos propuestos €250 EUR - Development and materialization of the requirements
€250 EUR 2일에
5.0 (1 건의 리뷰)
2.6
2.6
사용자 아바타
A proposal has not yet been provided
€34 EUR 1일에
5.0 (1 건의 리뷰)
0.0
0.0
사용자 아바타
A proposal has not yet been provided
€125 EUR 3일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
Hello Sir, I am Saiful. I can help you on this project. Thanks Relevant Skills and Experience I am Digital Merketer Proposed Milestones €170 EUR - mileston
€170 EUR 3일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
A proposal has not yet been provided
€127 EUR 5일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
I am Data Entry/Data Processing Expert I am the Right person for you Sir, I'm interested in your project. Please send me a message so that we can discuss more Relevant Skills and Experience Sir, I'm interested in your project. Please send me a message so that we can discuss more Proposed Milestones €111 EUR - Please send me a message so that we can discuss more
€111 EUR 1일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
We will be able to complete the work with better quality. Relevant Skills and Experience We are very experienced in excel. We will be able to provide the work with the stipulated time.
€155 EUR 3일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
A proposal has not yet been provided
€34 EUR 2일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
A proposal has not yet been provided
€127 EUR 2일에
0.0 (0 건의 리뷰)
0.0
0.0
사용자 아바타
I would like to start working on the project, and look forward to achieving the required task properly,Accurately and be able to meet deadline. Relevant Skills and Experience Excel files, attention to details, meet deadline, typing, data entry
€155 EUR 3일에
0.0 (0 건의 리뷰)
0.0
0.0

고객에 대한 정보

국기 (ITALY)
Ascoli Piceno, Italy
5.0
1
결제 수단 확인
12월 3, 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)
미리 보기 화면을 준비 중...
위치 정보 관련 접근권이 허용되었습니다.
고객님의 로그인 세션이 만료되어, 자동으로 로그아웃 처리가 되었습니다. 다시 로그인하여 주십시오.