Simple sales quote calculator based on excel price charts

В роботі Опубліковано %project.relative_time Оплачується при отриманні
В роботі Оплачується при отриманні

I need a sales quote calculator for Windows XP and Windows 7 that will allow me to enter a number of materials, each at different sizes, and calculate the total cost based on price charts stored in excel spreadsheets.

I am trying to streamline the quoting process.

Right now when my sales staff need to quote an order they have a book of spreadsheets in which they look up each item at each size and add up all the prices.

I'd like a simple program that will let them add any quantity of specific materials, each at a specific size (length x width), that will reference the excel entry for that material, at that size, and create a final total, with any applicable discounts.

It's important that it be able to reference an excel spreadsheet because our materials cost change over time and we'd like to be able to update it manually.

Specifics:

- 30 unique materials with corresponding excel files

- Up to 16 Rows X 32 Columns of prices (512 entries) for each material to be referenced

- Some materials have one price for the first unit ordered, and a discounted price for each additional.

- For each entry I need input boxes for:

- Quantity

- Material Type

- Length

- Width

- Discount Percentage

- A "+" button to add a new field

-A global discount percentage for simply discounting the entire order.

- Each new entry line should auto-fill from the previous, since most parameters are often similar (eg. quantity, size, discount).

- The Material Type field should be a drop down menu as well as auto-fill the alphabetically closest option, to speed up input.

- For ease and speed you should be able to use only the keyboard for all entries:

- ie. press Tab to go from field to field, press + to add a new entry line, press the up and down arrows to scroll through field options.

I do not need invoicing, saving or printing functionality, as we have that with our accounting software.

I am open to options that may be more simple than referencing excel files for pricing, as long as they allow for dynamic updating.

If this software works well I would be open to paying for added features in the future.

Excel Архітектура ПЗ Інтерфейс користувача / Інформаційна архітектура Visual Basic Робочій стіл Windows

ID Проекту: #4308300

Про проект

21 заявок(-ки) Дистанційний проект Остання активність Apr 11, 2013

21 фрілансерів(-и) готові виконати цю роботу у середньому за $123

mrbrave

Hi..I have past experience of developing cost calculators...See messagebox for demo.

$100 CAD за 2 дні(-в)
(293 відгуків(и))
6.9
ProfessionalBoss

I am here to do it

$500 CAD за 9 дні(-в)
(11 відгуків(и))
5.5
rajanlengde

I can do this well with a simple desktop application, Please see PMB

$150 CAD за 20 дні(-в)
(30 відгуків(и))
5.2
srdas2012

Hi Please check PMB

$120 CAD за 7 дні(-в)
(29 відгуків(и))
5.0
kulhanekd

I have 15 years exp in excel and access. I can create the form you need for your quoting process. Donna

$150 CAD за 3 дні(-в)
(12 відгуків(и))
4.7
JackBradford

Hello, I can accomplish the automated quote system you seek using Excel VBA. You will be able to create quotes as well as you will be able to change variables through an admin tab. I can even create a custom outpu Більше

$90 CAD за 1 день
(10 відгуків(и))
3.9
bubu77

Hi, MS Access/Excel expert having 8+ years of IT experience. I can do the project for you. Please see your PM for more details.

$150 CAD за 15 дні(-в)
(9 відгуків(и))
4.0
pixecs

Dear sir, i can help you with this project. I have over 16 years of experience in C/C++ development.

$75 CAD за 5 дні(-в)
(12 відгуків(и))
4.1
vikashgadia

we have all the required capability make application as per ur 100% satisfaction

$100 CAD за 5 дні(-в)
(15 відгуків(и))
3.8
Pharoa

Thank you for the opportunity to bid on your project. I propose to develop the calculator using Visual Basic 2010 in 5 days from the date of bid acceptance. I have very strong Visual Basic skills, using it for bu Більше

$150 CAD за 5 дні(-в)
(3 відгуків(и))
3.7
armitagecorto

Hi, i have experience in converting excel formulas into executable applications.

$60 CAD за 7 дні(-в)
(9 відгуків(и))
3.5
sudewa

Hi, I am thinking of building a C# application for your requirement since it is easy to update/maintain your software. We can store the data in Access and provide a user interface for the users to update the data Більше

$200 CAD за 20 дні(-в)
(2 відгуків(и))
2.9
AbhilashMishra

Hi, I can get your project done.

$50 CAD за 3 дні(-в)
(1 відгук)
2.6
xeancaile

Consider it done.... please see PMB...

$30 CAD за 2 дні(-в)
(5 відгуків(и))
2.1
epdailo

i would like to help you on this project. Please select me.

$30 CAD за 7 дні(-в)
(2 відгуків(и))
2.2
johnboscow

I am looking forward to join with you.

$30 CAD за 5 дні(-в)
(0 відгуків(и))
0.0
PercevalCiro

Dear digitalpassword, we have carefully considered your project and we are glad to confirm that we can do it. We really appreciate considering us for your project. More details in PMB. Best Regards.

$150 CAD за 5 дні(-в)
(0 відгуків(и))
0.0
sebdick

Hi digitalpassword, I can build you an efficient, user-friendly quote calculator that sits in its own excel workbook. The tool would allow for quick keyboard-data entry as you describe, and would reference all requi Більше

$50 CAD за 1 день
(0 відгуків(и))
0.0
TimotiusSL

I already create sample based on your description. Hope you'll like it. :)

$90 CAD за 3 дні(-в)
(0 відгуків(и))
0.0
larryagrossman

I have previous created pull downs and a GUI via Excel macro code. I have also extracted excel data and created new spreadsheets. All for a financial firm in NY, NY. I entered a low bid since I need the work and nee Більше

$200 CAD за 3 дні(-в)
(0 відгуків(и))
0.0