I'm not familiar with SQL so I don't know if SQL or Excel would be the best for what I need so please suggest one or the other or a combo of the two. Whatever you think my best option is.
I am trying to recreate a excel workbook created to select the best supplier based on price for up to 150 items but enhance it to also expedite the initial quoting process. I've detailed out generally how I want the flow to go below.
1) Enter product description/Product Material/Quantity/Unit of Measurement (UOM)on "Bid Details Sheet"
2) That data auto fills into "US Suppliers Sheet", "Sterling Suppliers Sheet", & "Euro Suppliers Sheet (Need to add this sheet still)"
3) In some way/shape/form, I need a list of suppliers from the sourcing workbook/sheet to contact based on Product/Material for each item. This would be presented on the Summary Sheet and contacts should be sorted based on Product / Material that they supply. (That info is found on sourcing tab)
4) An additional desire is that I would like to use this workbook to mail merge my emails to the listed contacts. The best way I can think to say it is that I would like to have the data display what item #'s (Bid Details Sheet Column A) to send to what suppliers. However this needs to work.
5) Fast forward - emails sent out and suppliers have submitted quotes. I add prices to US/Sterling Sheet based on where they are located and it updates Bid Details Sheet.
6) On bid details sheet, cheapest option is presented in blue columns. It shows cheapest "per unit" pricing with "item" and Supplier column filling with matching information respectively. I would also like to have a "markup" column added between columns S and T on Bid details sheet and two additional columns added to the right of that detailing the "unit" and "Item" cost with markup.
7) The summary page should detail and highlight overall job/product cost, the overall marked up cost, the profit margin %, and the profit.
The most important detail is that I would like this work book / database to allow be to submit requests for quotes to suppliers much faster and allow me to accurately forecast the financials.
It is important to note that the attached "Sourcing Tool" is a work in progress supplier wise so this project should allow for additional suppliers to be added to that list and the products they offer be updated without causing errors.
I've uploaded my current work-in-progress so please look it over and let me know what you can do for me.
13 freelance font une offre moyenne de $187 pour ce travail
Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl Plus
Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. So I think I can help you if you want. This is Excel /VBA result which I 've done This is what i have done i Plus
Hi, nice to meet you. I have read your post and check 2 excel files too. I think it need to convert excel into relational database. This is main key to solve issues and let it easy. Then don't worry to query database b Plus
Dear Client I have read your requirement in detail and understood almost Now I can help you with good job and I am ready to start working immediately I can do your job well and you will receive good result from me, Plus
I am postgraduate (MBA) in finance with more than 5 years of experience in financial modeling, financial analysis, advanced excel, VBA/Macro automation and data processing. I have previously worked for many reputed com Plus
Hi, How are you? I am interested in taking up your project. I recommend sql. I can complete your project on time and within your budget. I have worked on similar projects to what you are looking for, and I am conf Plus
Hi, I am interested in your offer: Excel VBA code. Let me know more details about this work. I will start working immediately :) Br;
Hi There, I am interested to your project. I am an Excel expert and have a great eperiences in excel automation with formulas and vba since my first career 15 years ago. I assured that you will get high quality / high Plus
Hello,How are you? I am an experienced professional graphic designer just available on freelancer to design your Logo & Brand Identities.I Love any form of Design and i do my work with great passion and dedication. If Plus
Hi, I read your project requirement carefully and I understand your project but I want to ask a few questions before mover further so that I can deliver you exact work with one shoot. I always deliver quality wit Plus
Hi!I'm very happy to have a chance of bidding your [login to view URL] can we talk?Please schedule a time? I am an excellent developer in this industry. If we work together, I will satisfy you fully. Please give me 10 minutes Plus
I am responsible and reliable. Always ready for new challenges as well as professional training. New technologies have always fascinated me and intrigued me. For myself, I can say that I'm moving, full of research spir Plus
Dear sir, i'm oracle certified OCA&OCB as i have a good experience in oracle database projects and SQL and database tools thanks Asmaa