Create/Re-design RFQ Request Database

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.

Taidot: tiedonsyöttö, Excel, graafinen suunnittelu, PHP, SQL

Näytä lisää: create professional design elegant, web design quote request, create email form puts data database, website design rfp example, website rfp example, simple request for proposal example, sample proposal for website design and development, rfp for website design and development 2018, rfq process flow chart, rfq template, how to write a request for proposal, create tarpaulin design, create shirt design, create web design script, quickly create web design mock, create tshirt design tool, create asterisk design java script, create macro cut paste web database, create logo design roofing, create web application form update database

Tietoa työnantajasta:
( 0 arvostelua ) Sugar Land, United States

Projektin tunnus: #19642881

13 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


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 Lisää

$250 USD 7 päivässä
(350 arvostelua)

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 Lisää

$140 USD 7 päivässä
(135 arvostelua)

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 Lisää

$250 USD 7 päivässä
(49 arvostelua)

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, Lisää

$120 USD 3 päivässä
(17 arvostelua)

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 Lisää

$250 USD 3 päivässä
(24 arvostelua)

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 Lisää

$140 USD 3 päivässä
(9 arvostelua)

Hi, I am interested in your offer: Excel VBA code. Let me know more details about this work. I will start working immediately :) Br;

$155 USD 3 päivässä
(23 arvostelua)

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 Lisää

$200 USD 5 päivässä
(24 arvostelua)

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 Lisää

$50 USD 1 päivässä
(10 arvostelua)

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 Lisää

$555 USD 3 päivässä
(1 arvostelu)

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 Lisää

$140 USD 7 päivässä
(5 arvostelua)

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 Lisää

$133 USD 3 päivässä
(3 arvostelua)

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

$50 USD 2 päivässä
(0 arvostelua)