Find Jobs
Hire Freelancers

Price making tool

$10-30 USD

Zaprt
Objavljeno pred približno 9 leti

$10-30 USD

Plačilo ob dostavi
I need an application which can be Java or web based or I don't mind. It can be an excel macro etc. The program needs to make the following: Its will be a pricelist generator. I get the prices from my vendor in an excel table. In this excel table there will name, description, price, product number etc. The program needs to be able to import those parameters into a database. If its ready the program needs to be able to create different price levels based on formulas. For example: Product name: ABC Description: ABCDEEEEjhjkhfjkd product number: 123adf price: 100 USD I need to be able to calculate the following: landing cost based on the unit price : 100 + 1%= 101USD List price: 101 USD + 40% (Margin1) = 141,4 USD Delaer 1: 140 - 15%= 120,19 Need to be able to define upto 10 price levels. When my vendor change my prices I need to be able to import it to the program and the program will update the base price based on product number. I need to be able to print out from program into excel or pdf.
ID projekta: 7244947

Več o projektu

17 ponudb
Projekt na daljavo
Aktivno pred 9 leti

Želite zaslužiti?

Prednosti oddajanja ponudb na Freelancerju

Nastavite svoj proračun in časovni okvir
Prejmite plačilo za svoje delo
Povzetek predloga
Registracija in oddajanje ponudb sta brezplačna
17 freelancerjev je oddalo ponudbo s povprečno vrednostjo $34 USD za to delo
Avatar uporabnika
Hey, what you are looking for can be best accomplished through an excel macro. The macro will import the supplier price list and will have a sheet to define the price levels. You would be easily able to update these levels as well if required. I can create such a spreadsheet for you. I can assure you of quality work like I have been doing for past 6+ years as you would see my work history. I have been highly rated and recommended for solutions I provide. Please let me know if you would like me to work on this project for you and we may discuss the details and the next steps. Look forward to hearing from you. Thanks and Regards, Shikha (Automyze Consulting)
$55 USD v 3 dneh
4,9 (269 ocen)
7,2
7,2
Avatar uporabnika
A proposal has not yet been provided
$100 USD v 1 dnevu
5,0 (279 ocen)
7,3
7,3
Avatar uporabnika
Dear Sir, I ensure you of completing the project within the specified time. I have a previous experience of Data Modification work in Excel using Macro. Besides I am an Electrical Engineer and currently working in a reputed Power Plant in India. Data Integration and Compilation is my prime job over there. Making reports in Excel and Powerpoint is my routine job, which gives me an edge to carry out the project. I am a new Freelancer so I have the earnest desire to carry out the project successfully. So please consider my proposal and give me a chance to boom in the market of Freelancer. Kindly contact me for further details. Thanks and Regards Tonmoy Roy Electrical Engineer
$35 USD v 2 dneh
4,9 (240 ocen)
6,4
6,4
Avatar uporabnika
Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 225 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive response. Thanks.
$30 USD v 3 dneh
4,9 (155 ocen)
6,4
6,4
Avatar uporabnika
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 to identify the current input and output files and hosting command buttons and other controls if necessary. 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 (if necessary), fixing of bugs and minor changes are included in the bid without any additional fees. Regards PS. Magyarul is kommunikálhatunk, ami plusz könnyebbség, ráadásul a munkafüzet nyelve is lehet magyar.
$35 USD v 2 dneh
4,9 (62 ocen)
5,7
5,7
Avatar uporabnika
hi pls connect with me i am keen to do this project, can do this in one day infact in few hours, if you give me a chance and assign the project right away. Puneet
$25 USD v 1 dnevu
5,0 (3 ocen)
4,5
4,5
Avatar uporabnika
Hello. It can be an Excel file with macro, or MS Access file. All you needs could be executes in both cases :-) Let's discuss the details. I still have some datails about your prefers, for example: - do you need to save the total history of price changes? P.S. I'm beginner in Freelancer.com, not in MS office and VBA.
$23 USD v 1 dnevu
5,0 (18 ocen)
4,4
4,4
Avatar uporabnika
Jo napot kivanok. Erdekel a melo, PHP programozo vagyok, az ajanlatom egy PHP program lenne melyet helyileg vagy serverrol is el lehet erni az on valasztasa szerint. Ha erdekli az ajanlatom kerem valaszoljon Tisztelettel, Levente
$29 USD v 2 dneh
5,0 (22 ocen)
4,4
4,4
Avatar uporabnika
Having done this for other clients already, I will give you a Macro file that works as follows. Open supplier price list. On a "Ranges" spreadsheet, list all your dealers and their "discounts" (not clear whether you give different discounts to different dealers), Then enter the Tax and Profit Margin(s) onto same sheet (not clear whether you have one discount and Tax rate, or different ones for different products). Macro will then apply those calculation automatically to the supplier's pricelist. So when your supplier(s) change their prices, your Price List spreadsheet will show any changes automatically. I designed dashboards, reports and interactive spreadsheets and managed databases for twenty years at a leading multinational. Now work from home in the UK across five freelance sites with good reviews from international clients who have utilised my expertise in VBA Coding, Formulae and Conditional Formatting. I can work under a Confidentiality and Non-Disclosure Agreement if required, and start as soon as you pay the fee into the site. Would normally provide samples to let you judge my Excel skill for yourself, but can't send you an attachment unless you send me a Private Message first. Hope you find this of interest and look forward to hearing from you. Bob Allen-Tur
$36 USD v 1 dnevu
4,5 (12 ocen)
4,4
4,4
Avatar uporabnika
I can make a macros which will satisfy requirements. I thin vba in this case is more appropriate as the file you are getting from your supplier is in spreadsheet. So I will create a connection with your data and the data autocratically will be imported in a table, from where the calculation will be generated. But I need 1 day for it and more detail description of your requirements as I have some questions.
$35 USD v 1 dnevu
5,0 (2 ocen)
1,3
1,3
Avatar uporabnika
Hi Sir, Hope to present a BIG SMILE on your face on Project completion. Quality assured. Understood the requirements and im planning to incorporate it via Excel Macro. You can release the funds only if you are satisfied with the completed work.
$15 USD v 1 dnevu
5,0 (3 ocen)
1,5
1,5
Avatar uporabnika
Hi! I can do your job. Just please write me more about it. The database is like sql database, or just simple excel file?
$25 USD v 1 dnevu
5,0 (1 ocena)
0,8
0,8
Avatar uporabnika
A proposal has not yet been provided
$30 USD v 2 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
by the time bid gets closed i may be having your requirement completed. This my 1st bid so Please give me one chance
$15 USD v 1 dnevu
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
Java Expertise in web development for over 5 years. I will provide extra support for 1 week for free.
$35 USD v 2 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
Hi, I was working as a technology lead in Infosys Technologies Ltd. I have 11 yrs of strong developement experience in dotnet, excel Macros and have recently left the job to try freelancing. I plan to execute your requirement as follows: 1. Database will be protected worksheet(Read only or password protected as per your wish) which will store all product information. 2. There will be a screen provided to Add/Update/Delete product information. 3. A Screen for giving search facility to fetch product details i.e name, description, price, product number and calculated 10 prices as per given formulas. 3. A summary sheet for opening above forms My profile details: • Worked with Infosys Technologies as a Technology Lead • Have more than 11 years of experience • Have demonstrated technical expertise as well as managing skills at offshore, client side • Have worked on POCs and Estimation • In-Depth knowledge SDLC processes • Have worked in front end , back end as well as middleware Professional Skill Set Computer Languages/Technologies : VBA,C#,VB 6, VB.NET,ASP/ASP.NET,ZPL, Biztalk 2006 R2 Tools : Visual Studio .NET 2005/ 2008/2013 Databases : Microsoft SQL Server 2000, 2005 and 2008, Oracle Software Methodologies : Software Development Life Cycle, Production Support, Software Maintenance etc. Project Management Processes : Estimation, Planning Tracking and Reporting Thanks & Regards, Medha
$25 USD v 2 dneh
0,0 (0 ocen)
0,0
0,0
Avatar uporabnika
If you require the work to be web-based, I cannot assist you. However, I have experience with building excel files to do this type of work and based on the information provided in your posting, I am confident that I am able to complete the project accurately and fairly quickly within excel. For quick and successful completion of the project, please provide the following: - A report from your vendor that I may use as an example input file - Formulas for each pricing level with the desired headers for each associated formula - The version of Excel that you are using I will create an excel file based off of this report using the example input file and the formulas you provide. This file will use a vlookup of the product number to reference the vendor prices for calculation to create your pricing sheet.
$25 USD v 2 dneh
0,0 (0 ocen)
0,0
0,0

O stranki

Zastava HUNGARY
Budapest, Hungary
5,0
2
Član(ica) od okt. 10, 2012

Verifikacija stranke

Hvala! Po e-pošti smo vam poslali povezavo za prevzem brezplačnega dobropisa.
Pri pošiljanju vašega e-sporočila je šlo nekaj narobe. Poskusite znova.
Registrirani uporabniki Skupaj objavljenih del
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Nalaganje predogleda
Geolociranje je bilo dovoljeno.
Vaša prijavna seja je potekla, zato ste bili odjavljeni. Prosimo, da se znova prijavite.