Completed

Excel-based Quote Tool

We are a training company and need help creating an interactive Excel tool to help a client create a quote for a client.

On the main tab, we need:

1) Header information where the client can enter:

a) The Unit/RO number

b) Customer or Dealer Name

c) Vehicle Description

d) Vehicle Color

2) To be able to quickly select for each part the following:

a) Paint button with drop down for Paint and blend

b) Body button with drop down for Medium and large parts

c) R&I

c) Depending on what is selected in the buttons have the parts of the vehicle highlight

a) If a part has paint time, highlight it in red

b) If a part has body time, highlight it in blue

c) If a part has R&I time, highlight it in green

3) Based on what is selected, have the Excel sheet lookup and create a quote that subtotals at the bottom and then calculates the sales tax.

On the second tab, I need a set-up page created that allows for the client to enter flat prices for each part type:

a) Paint cost

b) Blend cost = 2/3 of paint cost

c) Body repair cost for Medium dent

d) Body repair time for a Large dent

e) R&I Cost

f) Sales tax rate

Taidot: Excel, Visual Basic

Näytä lisää: excel chart generator tool, excel freelance tracking tool, resources planning web based online tool, quotation format in word, quotation format in excel, quotation template doc, quotation letter format in word, quotation format doc free download, excel quotation template with database, quotation template pdf, quotation format pdf, data entry, data processing, excel, microsoft excel, xml based configuration tool, web based config tool cisco 837, flash based quote, macro excel develop business tool, open excel web query tool macro

Tietoa työnantajasta:
( 0 arvostelua ) United States

Projektin tunnus: #17488940

Myönnetty käyttäjälle:

TechnoGuruu

Hi, I have checked your project details, as you want an interactive Excel application to help your clients for creation of quote. I will develop the same for you. I have many years of experience in Excel,data analy Lisää

$283 USD 10 päivässä
(31 Arvostelua)
4.9

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

polarjin2017

Yes. It's just my top skill as you can see my reviews. I have worked in Excel extension for XLL in Visual studio already. And so many jobs done. I can help you if you want. Hope to work with you. Thank you.

$277 USD 1 päivässä
(52 arvostelua)
6.1
$250 USD 4 päivässä
(45 arvostelua)
5.9
asadkhan3533

Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thanks, Asad Khan

$555 USD 10 päivässä
(48 arvostelua)
5.2
c4cuteconain

I am a professional accountant with a decade of experience working in a US based NASDAQ registered company's finance department with excellent excel skills and can help you with this project as per your requirements.

$300 USD 10 päivässä
(32 arvostelua)
5.0
vinisaac

I am in Chicago, USA. I would love to work on your project. I have more than 25 years of experience in web/software development and system administration. My latest work is [login to view URL] Have worked on Lisää

$694 USD 10 päivässä
(1 arvostelu)
3.8
$250 USD 10 päivässä
(5 arvostelua)
2.1
atulmdsarkar11

Dear Sir, I have read the job post carefully. I have done several projects like this but new in freelancer.com .I have confidence that I will do your work very well. I hope you would like my work. So if you give me c Lisää

$250 USD 10 päivässä
(0 arvostelua)
0.0