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
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 analysis, pivots and VBA macros etc. I have finished many such projects. Please give me this opportunity to work on your project.
Quality work with high accuracy and 100% customer satisfaction is guaranteed.
Thanks and regards,
Peter
$283 USD Om 10 dagar
5,0 (46 omdömen)
5,2
5,2
7 frilansar lägger i genomsnitt anbud på $329 USD för detta uppdrag
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.
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.
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 chance, then I show my working ability. I am all time focused my client 100% satisfied! I will be waiting for your response.
Thanks